Learn one useful thing today.
Rubinstein Simple Chooser Option Formula: Call-or-Put Decision Date
Price a simple chooser option in Excel and Arte Sheets via Rubinstein’s (1991) put-call parity decomposition into a T-maturity call plus a t_c-maturity shifted-strike put.
Read the guide →FinancialRule of 72 vs exact doubling & tripling time formula (LN(2) / LN(1 + r))
Calculate exact compound doubling time LN(2)/LN(1+r), continuous doubling LN(2)/r, and N-fold multiplication time—and see where Rule of 72 drifts.
Read the guide →FinancialRule of 78s interest allocation: rebate and straight-line comparison
Illustrate sum-of-digits allocation for a precomputed finance charge. Compare with straight-line allocation, not an actuarial payoff calculation.
Read the guide →Math & TrigRunning balance with debits and credits (checkbook and ledger formula)
Maintain a cumulative bank or ledger balance across separate Deposit and Withdrawal columns while hiding totals on unposted rows.
Read the guide →StatisticalRunning count of occurrences in a list (1st, 2nd, 3rd repeat)
Number each appearance of a customer or SKU sequentially down a table with SUMPRODUCT(--($A$2:A2=A2)) and build unique composite keys.
Read the guide →FinancialRunning Cumulative Balance, Compound Wealth Index, and High-Water Mark (SCAN & REDUCE Formulas)
Generate step-by-step intermediate accumulator states (running cash balance, compounded wealth index, and running high-water mark) alongside terminal totals.
Read the guide →Lookup & ReferenceRunning Occurrence Count by Customer or SKU (Expanding COUNTIF)
Number each repeat occurrence of an item sequentially (1st, 2nd, 3rd order per customer) using an anchored expanding range =COUNTIF($A$2:A2, A2) and build unique composite lookup keys.
Read the guide →Process Safety, ASME Section VIII UG-127 & Rupture DisksRupture Disk: Manufacturing Range and Burst Tolerance
Distinguish a manufacturing design range from a tolerance around a marked burst pressure using a manufacturer’s illustrative example.
Read the guide →Chemical & Pharmaceutical Solid-Liquid Separation, Ruth Cake Filtration & Filter PressRuth Constant-Pressure Cake Filtration Time Formula
Calculate Total Dry Filter Cake Deposited (kg), Parabolic Cake-Resistance Filtration Time (min), Linear Filter-Cloth Resistance Time (min), and Total Cycle Filtration Time (min).
Read the guide →FinancialSaaS cohort retention table: mixed-reference retention % and weighted cohort average
Divide active customers in Month 1, 2, 3... by locked Month-0 cohort size ($B2) while hiding unelapsed triangle cells.
Read the guide →SaaS Metrics, Venture Growth Benchmarks & Cohort Retention EconomicsSaaS Gross Revenue Retention (GRR) & Bessemer Score Formula
Calculate Enterprise SaaS Gross Revenue Retention (GRR <= 100%), Net Dollar Retention (NDR), Bessemer Venture Partners Capital Efficiency Score (Net New ARR / Net Burn), and Ending Total ARR ($M).
Read the guide →FinancialSaaS MRR waterfall: Ending MRR, Gross Retention (GRR), and Net Dollar Retention (NDR)
Reconcile Starting, New, Expansion, Contraction, and Churned MRR and compute commonly used GRR and NDR percentages.
Read the guide →FinancialSaaS Quick Ratio & Net New MRR / ARR waterfall formula (growth vs churn)
Measure subscription growth efficiency via (New MRR + Expansion MRR) / (Churned MRR + Contraction MRR) alongside Net New ARR.
Read the guide →SaaS FP&A & ASC 606 Revenue AccountingSaaS RPO, Calculated Billings & Book-to-Bill Formula
Reconcile ASC 606 / IFRS 15 Calculated Billings (Revenue + Delta Deferred Revenue), Remaining Performance Obligations (RPO = Deferred Revenue + Unbilled Backlog), Contracted Net Bookings, and RPO Book-to-Bill.
Read the guide →FinancialSaaS Rule of 40, Magic Number, and Burn Multiple formulas
Benchmark SaaS growth efficiency using Rule of 40 (Growth % + FCF Margin %), Go-to-Market Magic Number, and Capital Burn Multiple.
Read the guide →Power-to-Gas (PtG), E-Methane & Carbon Utilization EngineeringSabatier CO2 Methanation H2 Demand, SNG & Heat Recovery Formula
Calculate Stoichiometric Green H2 Feed (kg/hr), Synthetic Natural Gas CH4 Output (kg/hr), Condensed Byproduct Water (kg/hr), and Exothermic Reactor Steam Duty (MWth).
Read the guide →EngineeringSabine & Eyring Reverberation Time (RT60) Room Acoustics Formulas
Compare Sabine and Eyring diffuse-field reverberation estimates using room volume, total surface area and a frequency-specific average absorption coefficient.
Read the guide →Engineering & ScienceSackur-Tetrode Equation: Absolute Quantum Molar Entropy of Monatomic Gases
Calculate the absolute statistical-mechanics molar entropy S_m = R * (1.5*LN(M) + 2.5*LN(T) - LN(P_bar) - 1.15171) (J/(mol·K)) of noble gases directly from Planck’s constant.
Read the guide →Corrosion Engineering, Subsea Pipelines & Offshore StructuresSacrificial-Anode Cathodic Protection Mass & Count Formula
Calculate DNV-RP-B401 Galvanic Cathodic Protection Mean Current Demand (A), Required Net Anode Mass (kg), Minimum 150 kg Al-Zn-In Anode Count, and Gross Installed Anode Mass (kg).
Read the guide →Powertrain & Off-Highway Machine Elements, ISO 4156 / ANSI B92.1 Involute SplineSAE / ISO 4156 Involute Spline Flank & Shear Formula
Calculate Total Pitch-Circle Tangential Force (kN), Load-Shared Tooth Flank Compressive Stress (MPa), Minor-Root Torsional Shear Stress (MPa), and % of 120 MPa Case-Hardened Limit.
Read the guide →StatisticalSafety stock formula: combine demand volatility and supplier lead-time variance
Size warehouse safety stock for 95% or 99% cycle service levels using Z * SQRT(AvgLeadTime * DemandSD^2 + AvgDemand^2 * LeadTimeSD^2).
Read the guide →Mineral Comminution, SAG/Ball Grinding Mills & Liner MechanicsSAG & Ball Mill Critical Centrifuging Speed (%Nc) Formula
Calculate Effective Ball-Center Orbit Diameter (D - d), Critical Centrifuging Speed N_c (RPM), Operating Percent Critical Speed (%Nc), and Grinding Motion Regime.
Read the guide →Engineering & ScienceSagnac Interferometer Phase Shift Formula (Fiber-Optic Gyroscope FOG)
Calculate counter-propagating laser Sagnac phase shift Δφ = (2 * π * L * D * Ω_rad_s) / (λ * c) (radians) in aerospace and subsea inertial navigation fiber-optic gyroscopes.
Read the guide →ScienceSaha Thermal Ionization Equation (Stellar & Laboratory Plasma)
Estimate the ionized fraction of pure atomic hydrogen in a ground-state LTE approximation. Use a log-domain Saha ratio and a stable quadratic solution to avoid cancellation at high ionization.
Read the guide →Engineering & ScienceSaha Thermal Ionization Equation & Plasma Ionization Fraction (x)
Calculate the dimensionless Saha equilibrium constant K_Saha and quadratic plasma ionization degree x = (-K + SQRT(K^2 + 4*K)) / 2 for stellar atmospheres (A0 stars) and ICP spectroscopy.
Read the guide →Mechanical & Structural EngineeringSaint-Venant Rectangular Bar Torsion Constant and Peak Shear Stress
Avoid the circular polar-inertia J_p trap on rectangular shafts by computing Saint-Venant torsional stiffness K_tor, twist angle, and midpoint long-side peak shear stress.
Read the guide →CMOS Digital Design & Low-Power ElectronicsSakurai Alpha-Power CMOS Delay & EDP Formula
Calculate CMOS Dynamic Switching Energy E_dyn = C_L * V_DD^2, Sakurai Velocity-Saturated Propagation Delay t_p = 0.5 * C_L * V_DD / (K_d * (V_DD - V_th)^alpha), Shockley Square-Law Bias, and Energy-Delay Product (EDP).
Read the guide →StatisticalSalary benchmarking formulas: Compa-Ratio, Range Penetration, and Percentile Rank
Compare salary with a defined band midpoint and range, and calculate a rank within the example peer set.
Read the guide →Charts & Visual DataSales Funnel Chart Formula: Invisible Centering Spacer & Stage Drop-Off %
Construct a centered horizontal Sales Funnel on any stacked bar chart by computing the exact left-padding spacer (Top_Stage - Stage_i) / 2 alongside stage-to-stage conversion and leakage rates.
Read the guide →SaaS RevOps & FP&A Capacity PlanningSales Rep Ramp Quota Capacity & Attrition Formula
Calculate Ramped Rep Equivalents (RRE), Street Quota Capacity, and Attrition-Adjusted Expected Bookings against Board ARR targets using SUMPRODUCT.
Read the guide →Finance & AccountingSales Tax Rate Lookup with Tax-Exempt Override (XLOOKUP + IF)
Calculate invoice sales tax and gross total dynamically by combining IF(Tax_Exempt = "Yes", 0, XLOOKUP(...)) with missing-jurisdiction validation.
Read the guide →Healthcare & Clinical FormulasSALT Scalp Hair-Loss Score: Weighted Regions and Change from Baseline
Practice the four-region weighted SALT arithmetic and distinguish an absolute score from relative change over time.
Read the guide →Healthcare & Clinical FormulasSAMe-TT₂R₂: An Educational Weighted-Points Example
Practice a historical six-flag weighted point sum; the worksheet does not predict an individual response or select an anticoagulant.
Read the guide →Quantitative FinanceSample & Population Covariance Formula (COVARIANCE.S / .P) & CAPM Beta
Calculate Population Covariance Cov_P = CORREL(X, Y) * STDEV.P(X) * STDEV.P(Y), Bessel-corrected Sample Covariance Cov_S = CORREL(X, Y) * STDEV.S(X) * STDEV.S(Y), and CAPM Market Beta = Cov(R_i, R_m) / Var(R_m).
Read the guide →Statistical AnalysisSample & Population Excess Kurtosis (KURT Fourth-Moment Tail Risk Formula)
Compute unbiased Fisher sample excess kurtosis (KURT) and population excess kurtosis from standardized fourth moments to detect fat-tailed (leptokurtic) vs thin-tailed (platykurtic) series.
Read the guide →Statistical & AggregationSample & Population Skewness Formulas (SKEW vs SKEW.P Third Standardized Moment)
Measure distribution asymmetry and tail direction using both the adjusted Fisher-Pearson sample skewness (SKEW, requiring n >= 3) and population skewness (SKEW.P) built from SUMPRODUCT, AVERAGE, STDEV.S, and STDEV.P.
Read the guide →Healthcare & ClinicalSampson–NIH LDL-C and Non-HDL Cholesterol Examples
Compare a calculated LDL-C estimate with the separate non-HDL cholesterol arithmetic, using fictional values in mg/dL.
Read the guide →Healthcare & Clinical CalculationsSampson–NIH LDL-C Equation: An Estimated Value
Calculate the 2020 Sampson–NIH LDL-C estimate with fictional lipid values and compare it with a Friedewald estimate when appropriate.
Read the guide →International Trade & Customs AnalyticsSamuelson Iceberg Trade Cost & CIF/FOB Wedge Formula
Convert customs CIF and FOB prices into Paul Samuelson’s (1954) iceberg factor tau = P_CIF / P_FOB >= 1, melting loss share (tau - 1) / tau, and Eaton-Kortum trade attenuation tau^(-theta).
Read the guide →Public Economics & Mechanism DesignSamuelson Public-Good Rule & Lindahl Benefit Price Formula
Sum marginal willingness-to-pay schedules vertically via Samuelson’s rule SUM(MRS_i) = MC_G, compare against free-rider voluntary provision, and solve Lindahl benefit prices.
Read the guide →Healthcare & ClinicalSan Francisco Syncope Rule: CHESS Factors and Limitations
Count the five published CHESS factors with fictional inputs and understand why a negative rule is not a guarantee of safety.
Read the guide →Foundry Mold Engineering, Archimedes Metallostatic Core Lift & Chaplet DesignSand-Casting Core Buoyancy & Top Chaplet Load Formula
Calculate Dry Resin-Sand Core Weight (N), Upward Molten-Metal Archimedes Buoyancy (N), Net Upward Core Float Force (N), and Factored Top-Chaplet Hold-Down Load (N).
Read the guide →Dairy, Brewery & Biopharma Hygienic Engineering, 3-A / ASME BPE CIP Spray-Ball & ScourSanitary CIP Spray-Ball Wetting & Return Scour Formula
Calculate Vessel Internal Circumference (m), Falling-Film Perimeter Wetting Rate (L/(min·m)), CIP Return-Pipe Velocity (m/s), and % of 3-A 1.52 m/s Turbulent Scour Minimum.
Read the guide →Healthcare & Clinical CalculatorsSAPS 3 Research and a Fictional Logarithmic Transform
Learn the context of the SAPS 3 admission research model and practice a separate fictional logarithmic formula.
Read the guide →Healthcare & Clinical FormulasSAPS II Research and a Fictional Logistic Formula
Read about the original SAPS II hospital-outcome model and practice a separate fictional logistic calculation.
Read the guide →Statistical & Clinical AnalysisSARC-F Score Formula: A Sarcopenia Screening Example
Sum five SARC-F item scores and understand what a positive or negative screening result can and cannot tell you.
Read the guide →Econometrics & Causal InferenceSargan-Hansen Overidentifying Restrictions J-Statistic Formula
Calculate Sargan’s J = N * R^2_aux overidentification statistic with df = L_excl - K_endog and catch the exact-identification trap (L_excl = K_endog -> df = 0).
Read the guide →Satellite Communications & RF Systems EngineeringSatellite EIRP, G/T & Carrier-to-Noise C/N0 Formula
Calculate Effective Isotropic Radiated Power EIRP_dBW = P_tx + G_tx - L_feed, Carrier-to-Noise Spectral Density C/N0 = EIRP - L_path + G/T + 228.6 dB-Hz, and Digital Demodulator E_b / N0.
Read the guide →Semiconductor Thin-Film Deposition & Vacuum MetrologySauerbrey QCM Thin-Film Mass & Frequency Shift Formula
Calculate Vacuum PVD/ALD Thin-Film Areal Mass Density (ug/cm^2 = 0.1 * t_nm * rho_g_cm3), AT-Cut Quartz Sauerbrey Sensitivity C_f = 2.264 * f_0_MHz^2, Crystal Resonance Drop Delta_f (Hz), and 2% Crystal Replacement Gate.
Read the guide →Operations Research & Inventory ManagementScarf Distribution-Free Min-Max Newsvendor Formula
Hedge unknown demand tail shapes using Herbert Scarf’s (1958) distribution-free min-max newsvendor order Q* = mu + (sigma / 2) * (SQRT(beta / (1 - beta)) - SQRT((1 - beta) / beta)).
Read the guide →