Learn one useful thing today.
Brunner-Munzel Heteroscedastic Rank Test and Stochastic Superiority
Solve the nonparametric Behrens-Fisher unequal-variance problem using Brunner and Munzel’s (2000) placement-variance rank statistic W_BM and Satterthwaite degrees of freedom.
Read the guide →Charts & Data VisualizationBubble Chart Size Formula: Area-Proportional Radius SQRT(Z / Z_max) vs Diameter Distortion
Encode a third quantitative variable Z accurately in Bubble Charts by scaling circle radius as R_i = R_max * SQRT(Z_i / MAX(Z)) so visual disk area PI * R_i^2 stays strictly proportional to magnitude Z_i.
Read the guide →Public Economics & Club GoodsBuchanan Club Goods Optimal Membership Size Formula
Calculate James Buchanan’s Optimal Club Membership N* = SQRT(F / c_cong), Optimal Cost-Sharing Dues F / N*, Marginal Congestion Externality, and Per-Member Net Club Surplus.
Read the guide →Vertical Bulk Material Handling, Grain Legs, Cement Bucket Elevators & CEMA SizingBucket Elevator Critical RPM, Pole Distance & Capacity Formula
Calculate Centrifugal Pole Distance hp = g / omega² (m), Critical Zero-Throw Pulley Speed Ncrit (RPM), Linear Belt/Chain Speed (m/s), and Mass Elevating Capacity Qm (t/h).
Read the guide →Actuarial Science & Credibility PricingBühlmann-Straub Credibility Factor Z and Pure Premium Formula
Blend policyholder loss experience X_bar with manual class rate mu using Bühlmann-Straub credibility weight Z = (m * a) / (m * a + v) without division-by-zero traps.
Read the guide →Statistical & Conditional CountingBuild a Dynamic Two-Way Count Matrix (Mixed-Reference COUNTIFS Cross-Tab)
Cross-tabulate ticket or order counts by Priority (rows) and Channel (columns) using mixed-reference COUNTIFS that updates instantly without manual PivotTable refreshes.
Read the guide →Financial ModelingBuild a Formula-Driven KPI Scorecard Panel (Polarity-Aware Attainment, Weights & RAG Status)
Combine higher-is-better growth metrics and lower-is-better payback/defect metrics into one normalized executive KPI scorecard with weighted attainment and Red/Amber/Green status.
Read the guide →Logical & ConditionalBuild an "IF NOT ERROR" Rule (Execute Custom Logic Only When Lookup Succeeds)
Invert Excel’s built-in IFERROR—which only replaces errors while passing raw successes straight through—by combining IF(ISNA(XMATCH(...)), Fallback, Custom_Success_Result) or IF(NOT(ISERROR(expr)), Success, Error).
Read the guide →Formula Auditing & LogicBuild an ISNOTERROR Formula Gate (NOT(ISERROR)) for Pre-Publish Workbook Checks
Construct the missing ISNOTERROR predicate with NOT(ISERROR(cell)) to score clean-row pass rates, block broken model tabs from release, and coordinate team sign-off.
Read the guide →Text & Data CleaningBuild Clean UTM & API Query URLs with Cross-Platform Percent-Encoding Formulas
Assemble campaign tracking and webhook URLs from spreadsheet columns while safely percent-encoding %, spaces, ampersands, and plus signs across Windows, Mac, and browser sheets.
Read the guide →Text & String CleaningBuild Dynamic mailto: Email Links With Subject, CC & URL-Encoded Body
Assemble RFC-6068 mailto: URIs from spreadsheet recipient, CC, subject, and body cells—replacing spaces with %20 via SUBSTITUTE so mail clients never truncate subjects at the first space.
Read the guide →TextBuild in-cell histograms and 10-slot progress bars with REPT
Scale large counts down by a divisor for compact REPT("|", ...) histograms, and clamp [====------] progress bars safely with MEDIAN.
Read the guide →Naval Architecture & Dry-Bulk StowageBulk Carrier Stowage Factor & Full-and-Down Formula
Calculate Vessel Ideal Stowage Factor V_hold / DWT_cargo, Maximum Loadable Tonnage MIN(DWT_cargo, V_hold / (SF * (1 + bs))), Deadweight Utilization, and Cube-Out vs Weigh-Out status.
Read the guide →Charts & Visual Data ModelingBullet Graph Formula: Stacked Qualitative Range Deltas, Actual Bar & Target Variance
Build Stephen Few’s compact dashboard Bullet Graph using incremental stacked qualitative bands (Poor, Satisfactory - Poor, Good - Satisfactory), Actual Performance % of Target, and Target Gap.
Read the guide →Industrial Organization & Pricing StrategyBulow-Coase Durable Monopoly Selling vs Leasing Formula
Quantify Ronald Coase’s (1972) and Jeremy Bulow’s (1982) two-period durable-goods monopoly price erosion and compare subgame-perfect outright selling profit against credible leasing.
Read the guide →Auction Theory & M&A StrategyBulow-Klemperer Extra-Bidder Auction Revenue Formula
Verify Jeremy Bulow & Paul Klemperer’s (1996) theorem that an (N + 1)-bidder zero-reserve auction (N/(N + 2))*V_max strictly beats an N-bidder Myerson optimal-reserve auction.
Read the guide →Math & TrigBundle and quote pricing with SUMPRODUCT (quantities, unit prices, and discounts)
Compute gross subtotals, line-discounted net totals, and total savings in a single cell with SUMPRODUCT—no line-extension column required.
Read the guide →Clinical Medicine & PhysiologyBurch–Wartofsky Scale: Research Context and Point Addition
Review the Burch–Wartofsky scale and the 2025 ATA correction, then practice adding fictional preassigned points.
Read the guide →Well Control & Drilling Operations, Burkhardt (1961) Pipe-Tripping Surge & Swab HydraulicsBurkhardt Wellbore Surge & Swab Tripping Pressure Formula
Calculate Burkhardt Effective Annular Fluid Velocity Veff (m/s), Laminar Annular Surge/Swab Pressure Change (kPa), Running-In Surge EMW (SG), and Pulling-Out Swab EMW (SG).
Read the guide →Civil, Structural & Geotechnical EngineeringBurmister Two-Layer Pavement & Odemark Equivalent Thickness Formula: Deflection Factor F_2
Calculate two-layer elastic pavement surface deflection w_0 = F_2 * (1.5 * q * a / E_2) and Odemark’s Method of Equivalent Thickness h_e = f * h_1 * (E_1 / E_2)^(1/3) for stiff asphalt or base courses over soft subgrade.
Read the guide →Clinical Medicine & PhysiologyBurn Research and Percentage Caps: A Spreadsheet Exercise
Explore a fictional percentage cap and read specialist sources on the limits of burn-fluid and nutrition formulas.
Read the guide →Engineering & ScienceBurstein-Moss Shift: Degenerate Doping Optical Bandgap Widening
Calculate the conduction-band Pauli-blocking blue-shift ΔE_BM = 3.64645E-15 * n^(2/3) / m_eh^* (eV) and apparent optical bandgap E_g,opt = E_g0 + ΔE_BM in ITO and AZO transparent conducting oxides.
Read the guide →Biogas Engineering & Anaerobic Co-Digestion, Buswell-Mueller (1952) & Boyle StoichiometryBuswell Anaerobic Biomethane Potential (BMP) Formula
Calculate Empirical Substrate Molar Mass (g/mol), Stoichiometric Dry Biogas Methane Share (%), Theoretical Biomethane Potential BMP (Nm³ CH4/kg VS), and Practical Yield (Nm³/t VS).
Read the guide →EngineeringButterworth Filter Gain, dB Roll-Off Attenuation & Bandpass Q-Factor
Calculate the magnitude and signed dB gain of an ideal analog Butterworth low-pass filter, distinguish finite-frequency gain from asymptotic roll-off, and calculate a separate bandpass Q.
Read the guide →Healthcare & Clinical CalculatorsBVAS v3 and Capped Sums: A Spreadsheet Illustration
Learn how a per-group cap works in a fictional spreadsheet example, and why a partial sum is not a Birmingham Vasculitis Activity Score or a remission assessment.
Read the guide →Monetary Economics & Sovereign RiskCagan Seigniorage Revenue & Peak Inflation Rate Formula
Calculate steady-state real seigniorage (pi + g_Y) * m_0 * EXP(-alpha * pi), Cagan’s revenue-maximizing inflation rate pi* = 1/alpha - g_Y, and maximum monetizable deficit.
Read the guide →Healthcare & Clinical CalculationsCAGE and CAGE-AID: Adding Four Binary Answers
Practice adding four fictional yes/no answers while learning the historical context and limits of the CAGE and CAGE-AID screening questionnaires.
Read the guide →FinancialCAGR formula: calculate Compound Annual Growth Rate over multiple years
Compute the smoothed annualized growth rate with (EndValue / StartValue) ^ (1 / Years) - 1 and verify multi-year compounding.
Read the guide →Metalcasting & Steel Foundry Engineering, Caine (1948) AFS Hyperbolic Riser Feeding LawCaine Sand-Casting Riser Freezing-Ratio & Yield Formula
Calculate Actual Riser-to-Casting Modulus Freezing Ratio x = Mr/Mc, Volume Ratio y = Vr/Vc, Caine Hyperbolic Minimum Soundness Ratio xmin, and Mold Casting Yield (%).
Read the guide →Statistical & Clinical AnalysisCalculate & Plot Regression Residuals: Predicted Y, Residual Error & Outlier Flag
Build a linear regression Residual Plot table without Analysis ToolPak: compute Predicted Y_hat = INTERCEPT + SLOPE * X, Signed Residual e_i = Y_i - Y_hat, and Regression Standard Error s_e = SQRT(SSE / (n - 2)).
Read the guide →FinanceCalculate a Complete Four-Period Hull Moving Average and Efficiency Ratio
Calculate two consecutive raw Hull values and their final weighted smoothing, then compare net change with total absolute movement using Kaufman’s efficiency ratio.
Read the guide →FinancialCalculate a fictional two-rate marginal charge with MIN and MAX
Split an amount at a threshold, apply one rate to each slice, and compare rounded charges with the underlying blended rate.
Read the guide →Math & TrigCalculate a ratio from two numbers: simplified whole-number (16:9) and N:1
Reduce positive integer dimensions to lowest ratio terms with GCD, or express a ratio with a nonzero denominator in N:1 form.
Read the guide →Math & TrigCalculate a running total (cumulative balance) that skips blank rows
Use an expanding SUM range for cumulative balances and suppress output on truly empty rows.
Read the guide →Date & TimeCalculate age from birthdate: exact years and months as of any date
Compute completed age in whole years and remaining months from a date of birth without off-by-one rounding errors.
Read the guide →Date & TimeCalculate business work hours between two dates and times (SLA timer)
Count only business-day work hours (e.g., 09:00–17:00 Mon–Fri) between ticket open and close timestamps using NETWORKDAYS.
Read the guide →Lookup & ReferenceCalculate Carrier Shipping Cost by Weight Ceiling & Zone (2D XLOOKUP Mode 1)
Look up parcel shipping rates from a carrier Zone x Max-Weight rate card using nested XLOOKUP with match_mode = 1 (exact match or next larger weight ceiling)—fixing VLOOKUP's next-smaller bracket bug.
Read the guide →HealthcareCalculate Clinical and Full Rockall Scores in a Spreadsheet
Practice validated category inputs, missing-data guards and separate pre-endoscopy and full Rockall totals using fictional data.
Read the guide →FinancialCalculate Coast FI number: invested balance needed to coast to retirement
Divide annual retirement spending by a chosen withdrawal-rate assumption and discount back to today using PV or (1 + RealReturn)^Years.
Read the guide →FinancialCalculate cumulative loan interest and principal for any year or period range
Compute exact Year-1, Year-2, or full-term principal and interest paid from remaining FV balances—without a 360-row schedule.
Read the guide →Date & TimeCalculate date overlap in days: find shared days between two bookings or projects
Count inclusive overlapping days between any two date ranges in one line using MAX(0, MIN(End1, End2) - MAX(Start1, Start2) + 1).
Read the guide →Date & TimeCalculate Days Open & Invoice Age Status (Open vs Closed Items)
Calculate elapsed calendar days as of an explicit report date, cap aging at a valid closure date, and label active items using a configurable age threshold.
Read the guide →Lookup & ReferenceCalculate difference from last non-blank entry in a sparse log (TAKE & FILTER)
Subtract the previous numeric reading in source-row order, preserving gaps and numeric zero.
Read the guide →Date & TimeCalculate due date by category or SLA priority (business or calendar days)
Look up turnaround days by ticket priority or vendor payment tier with XLOOKUP and add business days via WORKDAY.
Read the guide →FinanceCalculate Effective Hourly Pay Rate (Weighted Shift Pay vs Simple Mean)
Compare gross earnings per worked hour with the simple average of shift rates, and calculate an illustrative gap to a chosen target without confusing it with a statutory payroll calculation.
Read the guide →Date & TimeCalculate expiration dates and days remaining (days, months, or month-end)
Add fixed shelf-life days, calendar warranty months (EDATE), or end-of-month expirations (EOMONTH), and flag expired items.
Read the guide →EngineeringCalculate GPS distance between latitude and longitude coordinates
Compute great-circle distance in kilometers or miles with spherical law of cosines—clamping ACOS inside [-1, 1] for identical points.
Read the guide →StatisticalCalculate Grubbs G and an upper-end Dixon gap ratio
Calculate two single-extreme statistics for six numeric observations, with explicit assumptions and no automatic deletion of data.
Read the guide →Date & TimeCalculate hours between two times (including overnight night shifts)
Wrap EndTime - StartTime in MOD(..., 1) * 24 so shifts crossing midnight return 8.5 positive hours instead of -15.5.
Read the guide →Date & TimeCalculate hours that overlap a specific time window (shift differential)
Measure exact hours of a work shift or booking that fall inside an evening differential or peak-rate time block using MAX and MIN.
Read the guide →