Learn one useful thing today.
Winemaking Brix, Chaptalization & Tartaric Acid Formula
Calculate Grape Must Initial Potential Alcohol (% v/v), OIV Chaptalization Sucrose Addition MAX(0, Target_ABV - Potential_ABV) * 17 * Volume_L / 1000, L(+)-Tartaric Acid Must Addition, and Legal Enrichment Cap Compliance.
Read the guide →Enology, Wine Chemistry & Barrel Cellar QA, Henderson-Hasselbalch Molecular SO2 & KMBSWinemaking Molecular SO2 vs pH & KMBS Addition Formula
Calculate Antimicrobial Molecular SO2 (mg/L) from Wine pH and Free SO2, Required Free SO2 (ppm), Free SO2 Deficit (mg/L), and Potassium Metabisulfite KMBS Dose (g).
Read the guide →Solid Mechanics & Structural DesignWinkler-Bach Curved-Beam Neutral-Axis Shift and Stress Formula
Calculate curved-beam neutral-axis radius R_n = h / LN(r_o / r_i), eccentricity e = R_c - R_n, and hyperbolic inner-fiber stress sigma_i = M*(R_n - r_i) / (A * e * r_i) for crane hooks and C-clamps.
Read the guide →Auction Theory & Corporate M&AWinner’s Curse & Common-Value Bid Shading Formula
Quantify the Winner’s Curse conditional value E[V | Win] = s_i - eps*(N - 1)/(N + 1) and Kagel-Levin (1986) symmetric Nash bid shading B*(s_i) = s_i - eps in common-value auctions.
Read the guide →StatisticalWinsorized mean and percentile-cutoff trimmed mean: capping versus excluding values
Compare clamping values to percentile cutoffs with averaging only values inside those cutoffs, and distinguish this from rank-based TRIMMEAN.
Read the guide →Clinical Pharmacokinetics, Critical-Care Therapeutic Drug Monitoring & NeurologyWinter-Tozer Albumin-Corrected Phenytoin & ESRD Formula
Calculate Protein-Binding Normalization Factor, Adjusted Normal-Albumin Phenytoin Concentration (mg/L), Estimated Free Unbound Phenytoin (mg/L), and Therapeutic Range Alert (10–20 mg/L).
Read the guide →StatisticalWinters formula range comparison and smoking pack-years: spreadsheet examples
Practice a conditional comparison with an expected CO2 range and a separate pack-year calculation using fictional values.
Read the guide →Non-Traditional Precision Tool & Die Machining, Wire-Cut EDM Spark Overcut & Kerf OffsetWire-EDM Spark Pulse Energy, Overcut & Kerf Offset Formula
Calculate Single-Spark Discharge Energy (mJ), Pulse Duty Factor (%), Empirical Radial Spark Overcut Gap (um), and Total Wire-EDM Kerf Slot Width (mm).
Read the guide →Overhead Crane & Mine Hoist Engineering, Wire-Rope Winch Fleet Angle & D/d FatigueWire-Rope Winch Fleet Angle & Sheave D/d Ratio Formula
Calculate Maximum Winch-Drum Fleet Angle ATAN((W/2)/L) (deg), Minimum Lead-Sheave Stand-Off Distance for 1.5° Limit (m), Sheave-to-Rope Bending Ratio D/d, and Spooling Audit.
Read the guide →Digital Infrastructure REITs, Telecom Economics & Unit ValuationWireless Cell-Tower REIT Colocation & Yield-on-Cost Formula
Calculate Wireless Cell-Tower Build-to-Suit Tower Cash Flow ($k), Incremental Colocation Margin (%), Unlevered Yield-on-Cost (%), and Public REIT Multiple Valuation ($k).
Read the guide →Statistical & PsychometricsWoolf Inverse-Variance Pooled Odds Ratio & 95% CI (Meta-Analysis)
Synthesize multi-center 2×2 case-control or trial strata via Barnet Woolf’s (1955) inverse-variance log-odds weighting w_i = 1 / (1/a + 1/b + 1/c + 1/d) and Wald 95% confidence bounds.
Read the guide →Dates and reportingWORKDAY function: calculate a deadline N business days ahead
Step forward a given number of working days from a start date, skipping weekends and listed closures—such as a task opened Friday when Monday is a holiday.
Read the guide →Date & TimeWorking days in a year & business days left in year (NETWORKDAYS)
Count Monday–Friday dates in a year or remaining date window, excluding a supplied holiday list.
Read the guide →Energy Tanker Chartering & Oil TradingWorldscale Tanker Freight & Deadfreight Formula
Calculate Crude/Product Tanker Effective Freight Rate (WS / 100) * Flat_Rate, Performed Cargo Freight, Short-Loading Deadfreight Damages, and Total Payable Freight.
Read the guide →Mechanical Power Transmission, Worm Drives & Hoist SafetyWorm Gear Lead Angle, Sliding Efficiency & Self-Locking Formula
Calculate Worm Lead Angle lambda (deg), Worm-Driving-Gear Mechanical Efficiency (%), Speed Reduction Ratio (N_g / N_w), and Static Self-Locking Status.
Read the guide →Textile Engineering, Loom Weaving Costing & Composite ReinforcementsWoven Fabric GSM Weight from Warp/Weft, Tex & Crimp Formula
Calculate Warp Yarn Contribution (g/m²), Weft/Filling Yarn Contribution (g/m²), Total Finished Woven Fabric GSM (g/m²), and Warp-to-Weft Mass Balance Ratio.
Read the guide →Operations Management & Manufacturing CostingWright’s Law Learning Curve Unit Cost Formula
Calculate N-th unit manufacturing cost C_N = C_1 * N^(LN(LR)/LN(2)) under Theodore Paul Wright’s (1936) learning-curve law across aerospace, semiconductors, and solar PV.
Read the guide →Statistical & Clinical AnalysisWSACS Intra-Abdominal Hypertension (IAH Grades I–IV) & Abdominal Perfusion Pressure Formula
Calculate Abdominal Perfusion Pressure APP = MAP - IAP (target >= 60 mmHg) and classify trans-vesical bladder pressure into WSACS Intra-Abdominal Hypertension Grades I–IV and Abdominal Compartment Syndrome (ACS > 20 mmHg + new organ failure).
Read the guide →Lookup & ReferenceXLOOKUP across multiple tables or sheets: chained fallback and VSTACK
Search active and archived lookup tables in priority order by nesting XLOOKUP inside if_not_found or stacking ranges with VSTACK.
Read the guide →Lookup & ReferenceXLOOKUP across two identifier columns: OR matches and precedence
Normalize dual-column matches and choose between first matching row and primary-column priority.
Read the guide →Lookup & ReferenceXLOOKUP and VLOOKUP with a validated, zero-safe manual price override
Use a nonnegative numeric override, including zero, and fall back to catalog pricing only when the override is blank.
Read the guide →LookupsXLOOKUP function: exact match, left lookup, and missing-key fallback
Look up values in any column direction without counting column numbers, return a clear fallback when a code is missing, and optionally scan bottom-up for the latest entry.
Read the guide →Lookup & ReferenceXLOOKUP match any column: search Primary SKU, Legacy ID, or Barcode at once
Find a product or contact when the user types an identifier that could live in Column B, Column C, OR Column D using Boolean OR array math.
Read the guide →Lookup & ReferenceXLOOKUP return multiple columns (and reorder with CHOOSECOLS)
Fetch an entire multi-column record in one XLOOKUP call—and select or reorder non-adjacent columns dynamically with CHOOSECOLS.
Read the guide →Lookup & ReferenceXLOOKUP returns 0 for blank cells: return blank ("") without breaking real zeros
Stop XLOOKUP and VLOOKUP from turning empty target cells into 0 (or 1900-01-00 dates) while keeping genuine 0 balances and numeric data types intact.
Read the guide →Lookup & ReferenceXLOOKUP Search Modes 2 and -2: Sorted Tables and Safety Checks
Compare ascending and descending XLOOKUP search modes, distinguish exact matching from lower-bracket matching, and validate sorted numeric keys. Includes an explicit Arte Sheets performance limitation.
Read the guide →Lookup & ReferenceXLOOKUP wildcard partial match: remember match_mode = 2!
Search for substrings, prefixes, or patterns inside product descriptions with XLOOKUP("*", ..., 2) and escape literal asterisks with "~*".
Read the guide →Lookup & ReferenceXLOOKUP with Complex AND + OR Criteria (Fixing the 1 + 1 = 2 Boolean Trap)
Combine AND (*) and OR (+) boolean array expressions inside XLOOKUP(1, ..., return_array) safely by clamping OR sums with > 0 so rows matching both OR conditions evaluate to 1 instead of 2.
Read the guide →Lookup & ReferenceXLOOKUP with IF: Negotiated Rate Override vs Standard Price Fallback
Combine XLOOKUP, LET, and LEN-based IF logic so negotiated client overrides supersede standard catalog rates while preserving intentional 0-fee waivers and flagging unknown accounts.
Read the guide →Lookup & ReferenceXLOOKUP with Logical & Inequality Criteria: XLOOKUP(1, (Cond1)*(Cond2), ...)
Search for the first or last row satisfying combined equality, greater-than (>), and range-bound conditions using XLOOKUP(1, (ColA = X) * (ColB >= Y), ReturnCol, "No Match").
Read the guide →Lookup & ReferenceXLOOKUP with multiple criteria: match two or more columns using boolean math
Look up a rate or owner across two criteria columns using XLOOKUP(1, (Col1=Key1)*(Col2=Key2), ReturnCol) without adding a helper column.
Read the guide →Lookup & ReferenceXLOOKUP: Return Blank ("") Instead of 0 on Empty Cells Without Erasing Real Zeros
Stop XLOOKUP from turning blank cells into 0—and avoid the ="" trap that accidentally wipes out genuine 0 balances—using an ISBLANK return-array check.
Read the guide →Lookup & ReferenceXMATCH function: exact position by default, next-larger tiers, and reverse search
Find 1-based item positions with XMATCH—defaulting safely to exact match, finding the last occurrence with search_mode -1, or matching unsorted bracket thresholds.
Read the guide →Lookup & ReferenceXMATCH reverse search: find position of LAST occurrence (search_mode = -1)
Locate the bottom-most occurrence of a repeated event, SKU, or customer in a chronological log with XMATCH(Key, Range, 0, -1) and measure first-to-last row span.
Read the guide →Lookup & Dynamic ArraysXMATCH with Multiple Criteria: Locate Compound-Key Row Positions Cleanly
Find the exact 1-based row index where three columns match simultaneously using XMATCH(1, (colA=x)*(colB=y)*(colC=z)) and retrieve target attributes with INDEX.
Read the guide →LogicalXOR function: enforce mutually exclusive "either A or B, not both" rules
Validate two-way exclusive choices with XOR—and avoid the 3-condition odd-parity trap when checking 3+ columns.
Read the guide →Math & StatisticalXY Scatter Plot Trendline Formulas: Live Cell SLOPE, INTERCEPT, FORECAST & R²
Extract dynamic XY scatter-plot trendline equations directly into worksheet cells—instead of copying static chart label text—using SLOPE(Y, X), INTERCEPT(Y, X), FORECAST(x_new, Y, X), and CORREL(X, Y)².
Read the guide →Lean Manufacturing, Toyota Production System & Industrial EngYamazumi Operator Balance, Takt & Line Efficiency Formula
Calculate Toyota Production System Customer Takt Time, Theoretical Minimum Operator Headcount ROUNDUP(Total_Work_Sec / Takt_Sec, 0), Yamazumi Line-Balance Efficiency Total_Work / (N_ops * Bottleneck_Sec), and Takt Compliance.
Read the guide →Quantitative FinanceYang-Zhang Minimum-Variance OHLC Volatility Formula (Overnight + Intraday)
Combine overnight gap variance v_o, open-to-close variance v_c, and Rogers-Satchell intraday variance v_rs using Yang & Zhang’s (2000) optimal weight k = 0.34 / (1.34 + (N + 1)/(N - 1)).
Read the guide →Engineering & ScienceYarkovsky Effect Formula: Asteroid Thermal Recoil & Orbital Drift (da/dt)
Calculate diurnal thermal-photon recoil acceleration a_Y and secular semimajor axis drift da/dt (m/yr) driving near-Earth asteroids like (101955) Bennu and Apophis.
Read the guide →Ring & Rotor Spinning, Textile Physics & Technical Cord MechanicsYarn Twist Factor (Ktex), Diameter & Helix Angle Formula
Calculate Metric Twist Factor K_tex = TPM * SQRT(Tex), Equivalent Yarn Cylinder Diameter d (mm), Surface Fiber Helix Angle theta (deg), and Axial Obliquity cos^2(theta) Factor.
Read the guide →FinancialYear-to-Date (YTD), Month-to-Date (MTD), and prior-year totals
Calculate cumulative YTD, MTD, and Same-Period-Last-Year (PYTD) totals anchored to a single As-Of reporting date.
Read the guide →Dates and reportingYEAR, MONTH, and DAY: extract date parts and assign fiscal years
Pull integer year, month (1–12), and day (1–31) numbers out of stored serial dates for grouping, and map April-start fiscal years with a one-line IF.
Read the guide →Healthcare & Clinical FormulasYEARS Algorithm for Pulmonary Embolism: Dynamic D-Dimer Cutoff (1000 vs 500)
Evaluate Tom van der Hulle’s 3-item YEARS pulmonary embolism rule (DVT signs, hemoptysis, PE most likely diagnosis) and dynamic D-dimer threshold (< 1,000 ng/mL if 0 YEARS items vs < 500 ng/mL if >= 1 YEARS item) to safely reduce unnecessary CTPA scans.
Read the guide →Statistical AnalysisYouden’s J Index, Likelihood Ratios (LR+ / LR-) & Fagan Post-Test Probability
Evaluate ROC cutoff optimality via Youden’s J = Sens + Spec - 1, compute Positive and Negative Likelihood Ratios, and update pre-test prevalence to post-test probability via Fagan’s odds rule.
Read the guide →ScienceYoung-Laplace Capillary Pressure & Jurin's Law Capillary Rise
Calculate signed capillary pressure and rise or depression, while distinguishing tube radius from the curvature radius used for a spherical droplet.
Read the guide →ScienceYukawa Screened Nuclear Potential & Pion Compton Force Range
Calculate the Reduced Compton Force Range R = hbar*c / (m * c^2) (fm) of a massive exchange boson and Hideki Yukawa's exponentially screened nuclear potential V(r) = -g_eff * EXP(-r / R) / r (MeV).
Read the guide →Statistical & EconometricYule’s Q & Yule’s Y Coefficient of Colligation for 2×2 Contingency Tables
Normalize 2×2 odds ratios onto [-1, +1] marginal-invariant scales using George Udny Yule’s association Q = (ad - bc) / (ad + bc) and colligation Y = (SQRT(ad) - SQRT(bc)) / (SQRT(ad) + SQRT(bc)).
Read the guide →Statistical & AggregationZ-Score Feature Normalization Formula (STANDARDIZE With AVERAGE & STDEV.S)
Transform raw observations into dimensionless standard-deviation units z = (x - mean) / sd to compare metrics on different scales and invert Z-scores back to raw units.
Read the guide →Financial & AccountingZero-Coupon Commercial Paper: PRICEDISC, YIELDDISC, RECEIVED & INTRATE Formulas
Price discounted money-market bills and commercial paper per $100 par (PRICEDISC), compute true money-market investment yield (YIELDDISC & INTRATE), and determine maturity redemption value (RECEIVED).
Read the guide →