Learn one useful thing today.
OCIMF Vessel Mooring Wind, Current & Hawser %MBL Formula
Calculate Aerodynamic Wind Load (kN), Seawater Tidal Current Drag (kN), Combined Environmental Surge/Sway Force (kN), and Hawser Tension as % of Ship Design MBL.
Read the guide →FinancialOdd Stub-Period Bond Clean Price and Implied Yield (ODDFPRICE & ODDLPRICE Valuation)
Value bonds with irregular short or long final/initial coupon periods using money-market stub discounting, accrued-interest deduction, and inverse stub yield.
Read the guide →Math & TrigOdometer gas mileage log: calculate MPG, L/100 km, and cost per mile
Compute trip distance from consecutive odometer readings, fuel efficiency in MPG and metric L/100 km, and fuel cost per mile.
Read the guide →StatisticalOEE formula: Availability x Performance x Quality (manufacturing KPI)
Calculate Overall Equipment Effectiveness (OEE) and reconcile the 3-factor loss breakdown against direct (GoodUnits * IdealCycleTime) / PlannedProductionTime.
Read the guide →Lookup & ReferenceOFFSET function: sum a dynamic trailing N-month window
Build a resizable range reference from an anchor cell with OFFSET(ref, rows, cols, height, width), and avoid out-of-bounds #REF! errors.
Read the guide →Charts & Visual Data ModelingOgive Graph Formula: Cumulative Frequency %, Upper Class Boundaries & Grouped Median
Build a "Less-Than" Ogive cumulative frequency curve: plot Cumulative % against Upper Class Boundaries (starting at 0% at the first Lower Boundary) and compute the linearly interpolated Grouped Percentile / Median.
Read the guide →Equity Valuation & Accounting TheoryOhlson Linear Information Dynamics Valuation Formula
Calculate James Ohlson’s (1995) closed-form equity value P_t = B_t + alpha_1 * x_t^a + alpha_2 * v_t combining clean-surplus book value, abnormal earnings persistence omega, and forward information v_t.
Read the guide →FinanceOhlson O-Score: Nine-Factor Logit Calculation in a Spreadsheet
Calculate a commonly reproduced Ohlson nine-factor linear score and its logistic transform, while distinguishing historical model output from a calibrated current bankruptcy forecast.
Read the guide →EngineeringOhm's Law, electrical power (Watts), and parallel resistance formulas
Calculate Current (V / R), Power dissipation (V^2 / R and I^2 * R), and Series vs Parallel equivalent resistance 1 / SUM(1 / R_range).
Read the guide →Wellbore Zonal Isolation & Primary Cementing, API Spec 10A Absolute-Volume Slurry DesignOilwell Primary Cementing Slurry Yield & Sack Count Formula
Calculate API Absolute-Volume Slurry Yield (ft³/sack), Mixed Slurry Density (ppg), Required Bulk Cement Sacks Including Open-Hole Washout Excess, and Total Mix Water (bbl).
Read the guide →Cellular RF Planning & Wireless Propagation ModelingOkumura-Hata Urban Macro-Cell Path Loss Formula
Calculate Masaharu Hata’s Empirical Urban Macro-Cell Mobile Height Correction a(h_m), Distance Path-Loss Slope 44.9 - 6.55*LOG10(h_b), Total Median Path Loss L_urban (dB), and Cell-Edge Received Signal Power (dBm).
Read the guide →Macroeconomics & Business Cycle ForecastingOkun’s Law Output Gap & Unemployment Change Formula
Calculate the Okun’s Law percentage GDP output gap -beta * (u - u*), lost dollar GDP, and growth-rate unemployment change Delta_u = -(1/beta) * (g_Y - g_Y*).
Read the guide →Public Choice & Institutional EconomicsOlson Collective Action Free-Rider Threshold Formula
Calculate Mancur Olson’s Privileged-Group Critical Benefit Share v_crit = C_pub / V_tot, Anchor Stakeholder Unilateral Net Surplus, Selective-Incentive Dues Gap, and Privileged vs Latent Group regime.
Read the guide →FinancialOmega Ratio & Ulcer Index drawdown risk formulas for skewed portfolios
Evaluate non-normal return distributions via Keating-Shadwick Omega Ratio SUM(MAX(0, R - MAR)) / SUM(MAX(0, MAR - R)) and Martin's RMS drawdown Ulcer Index.
Read the guide →Chemical, Process & Catalysis EngineeringOnda (1968) Packed-Column Wetted Surface Area (a_w) Formula: Surface Tension & HTU
Calculate effective liquid-wetted interfacial area a_w (m^2/m^3) in random-packed gas absorbers and air strippers using Kakusaburo Onda, Hiroshi Takeuchi & Yoshio Okumoto’s (1968) dimensionless Reynolds-Froude-Weber-Capillary correlation.
Read the guide →Logical & ValidationOne or the Other, Not Both: Exclusive OR (XOR) & Multi-Option Mutual Exclusion
Validate mutually exclusive promotional discounts or approval paths with two-argument XOR, and avoid the 3-argument odd-parity trap using boolean sum equality.
Read the guide →FinancialOne-asset Black-Litterman example: blend a prior and one absolute view
Explore a scalar normal-prior update with one absolute return view; distinguish uncertainty in the estimated mean from asset return variance.
Read the guide →Clinical Pharmacokinetics & BiopharmaceuticsOne-Compartment IV Bolus Model: A Pharmacokinetic Arithmetic Example
Explore elimination, half-life, apparent volume and clearance under a stated one-compartment model using invented sample values.
Read the guide →MathOne-Rep Max (1RM) Epley & Brzycki strength formulas + 2.5 kg plate rounding
Estimate 1-Rep Max from submaximal sets using Epley W*(1 + Reps/30) and Brzycki W*36/(37 - Reps), plus nearest -2.5-kg training load rounding.
Read the guide →StatisticalOne-Way ANOVA formula: Between-Group vs Within-Group F-statistic
Test whether three or more group means differ significantly by computing SS_Between, SS_Within, Mean Squares, and the One-Way ANOVA F-ratio directly in cells.
Read the guide →Logical & ConditionalOnly Calculate If Input Cells Are Not Blank (COUNTA & ISBLANK Gate)
Suppress premature $0.00 totals, negative margins, or #DIV/0! errors on partially entered invoice and quote rows using IF(COUNTA(B2:D2) < 3, "", ...) so formulas stay blank until every required input is entered.
Read the guide →Statistical & Clinical AnalysisOnodera prognostic nutritional index: formula and limitations
Practice the historical Onodera index using albumin and lymphocyte counts, with correct units and study context.
Read the guide →EngineeringOp-Amp Gain, Closed-Loop Bandwidth (GBWP) & Slew-Rate Limit formulas
Explore ideal resistor-set gains, a single-pole noise-gain bandwidth estimate and the sine-wave slew-rate boundary.
Read the guide →Bulk Metal Forming, Open-Die Upset Forging, Barreling Friction Hill & Press TonnageOpen-Die Upset Forging Friction-Hill & Tonnage Formula
Calculate Compressive Logarithmic True Strain, Constant-Volume Upsetted Diameter Df (mm), Siebel Friction-Hill Shape Multiplier C_f, and Peak Forging Press Force (kN).
Read the guide →Mining Engineering & Mineral EconomicsOpen-Pit Cutoff Grade & Stripping Ratio Formula
Distinguish Marginal Milling Cutoff Grade (sunk mining cost) from Pit-Shell Full Mining Cutoff Grade and calculate Maximum Breakeven Waste-to-Ore Stripping Ratio SR_max.
Read the guide →Optical Fiber Transport & Coherent DWDM TelecomOptical DWDM EDFA Noise Figure & Cascaded OSNR Formula
Calculate 1550 nm C-Band Single-Span Optical Signal-to-Noise Ratio (0.1 nm reference bandwidth), Multi-Span ASE Accumulation Penalty 10*LOG10(N), Cascaded End-to-End OSNR_dB = 58 + P_in_dBm - NF_dB - 10*LOG10(N), and Coherent FEC Margin.
Read the guide →Engineering & ScienceOptical Kerr Effect Nonlinear Refractive Index & Laser B-Integral
Calculate intensity-dependent Kerr refractive index shift delta_n = n_2 * I and accumulated ultrafast laser amplifier B-integral = (2 * PI() / lambda_0) * n_2 * I * L_eff (radians) to prevent catastrophic filamentation breakup.
Read the guide →FinancialOption Put-Call Parity, Intrinsic Value, and Time Value formulas
Use a no-dividend European option parity model to infer a put value, then calculate the sample call premium minus intrinsic value.
Read the guide →Logical checks and errorsOR function: flag a support ticket when either trigger applies
Escalate a ticket if a service is down or if its response age exceeds 24 hours. Check all four truth-table cases and exact threshold equality.
Read the guide →Clinical Pharmacokinetics & BiopharmaceuticsOral Bateman pharmacokinetics: peak time and bioavailability
Explore dose-normalized oral-to-IV AUC, time to peak and peak concentration for a one-compartment first-order model.
Read the guide →Healthcare & Clinical FormulasORBIT Bleeding Score: An Educational Weighted-Sum Example
Practice the ORBIT score’s five weighted binary flags with fictional inputs. The worksheet does not predict an individual outcome or choose medications.
Read the guide →EngineeringOrbital velocity, escape velocity & Kepler's 3rd Law satellite period formulas
Calculate circular orbital speed SQRT(mu/r), local escape speed SQRT(2*mu/r), and orbital period in minutes from gravitational parameter mu and altitude.
Read the guide →StatisticalOrdinary Least Squares Slope, Intercept, R-Squared, and Standard Error (LINEST Diagnostics)
Build labeled, self-documenting regression diagnostics—slope, intercept, R^2, residual standard error SE_y, and slope standard error SE_b—using SLOPE, INTERCEPT, CORREL, and VAR_S.
Read the guide →Operations, Logistics & EngineeringOrdinary Method of Slices: An Illustrative Circular-Slip Calculation
Explore the USACE ordinary-method expression for a three-slice example and understand why a worksheet result alone does not establish slope safety.
Read the guide →Thermodynamics, Geothermal Power & Industrial Waste-Heat RecoveryOrganic Rankine Cycle (ORC) Back-Work & Net Power Formula
Calculate Organic Rankine Cycle (ORC) Working-Fluid Mass Flow (kg/s), Organic Feed-Pump Back-Work Ratio (%), Net Electrical Output (kWe), and Net Thermal Efficiency (%).
Read the guide →Clinical Medicine & PhysiologyOriginal ADO Index: An Educational Spreadsheet Example
Reproduce the 2009 ADO point arithmetic using illustrative inputs, and distinguish the original score from the later updated index.
Read the guide →Healthcare & Clinical FormulasOriginal HACOR Score: Adding Five Component Points in a Spreadsheet
Learn to add the five published component point values using a fictional example and explicit input checks.
Read the guide →International Macroeconomics & Sovereign RiskOriginal Sin & Currency Mismatch Debt Shock Formula
Calculate post-depreciation sovereign Debt-to-GDP valuation jump d_1 = d_0*(1 + alpha_fx * Delta_S)/(1 + g_y) under Eichengreen-Hausmann "Original Sin" and Goldstein-Turner Net FX Debt / Exports mismatch.
Read the guide →Quantitative Finance & Time-Series EconometricsOrnstein-Uhlenbeck AR(1) Half-Life & Spread Z-Score
Convert discrete AR(1) persistence phi in (0, 1) into continuous Ornstein-Uhlenbeck speed kappa = -LN(phi), exact half-life -LN(2) / LN(phi), and stationary spread volatility sigma_e / SQRT(1 - phi^2).
Read the guide →FinancialOrnstein-Uhlenbeck conditional mean, half-life and uncertainty formulas
Calculate conditional expectation and dispersion under a constant-parameter mean-reverting model, with consistent time units and validated parameters.
Read the guide →MathOsmolality and water-deficit formulas: a fictional spreadsheet exercise
Practice units, arithmetic and input checks with fictional laboratory values. Results are educational calculations, not diagnoses or fluid-treatment instructions.
Read the guide →Econometrics & Omitted-Variable SensitivityOster Coefficient Stability Delta and Bias-Adjusted Beta Formula
Audit omitted-variable bias in Excel and Arte Sheets using Emily Oster’s (2019) R-squared-scaled bias-adjusted beta_star and breakdown proportionality delta_zero.
Read the guide →Fertilizer & Industrial Chemical Manufacturing, Ostwald Nitric AcidOstwald Nitric Acid Pt-Rh Gauze Selectivity & Yield Formula
Calculate 100%-Basis Pure HNO3 Produced (t/d), Commercial Weak Nitric Acid Output (t/d), Effective Acid-to-Ammonia Mass Gain Ratio, and Unselective N2/N2O Nitrogen Loss (kmol N/d).
Read the guide →Healthcare & ClinicalOttawa Ankle and Foot Rules: Two Sets of Clinical Findings
Explore the ankle and midfoot rule combinations using explicitly assessed inputs, while recognizing the limits of an educational spreadsheet.
Read the guide →Healthcare & ClinicalOttawa Knee Rule: Counting Five Pre-Assessed Findings
Explore the five Ottawa knee rule findings using validated illustrative inputs, and understand why a spreadsheet cannot decide whether a patient needs imaging.
Read the guide →EngineeringOtto & Diesel Cycle Thermal Efficiency formulas (Compression & Cutoff Ratio)
Calculate air-standard spark-ignition Otto efficiency 1 - 1 / r^(gamma - 1) and compression-ignition Diesel efficiency from compression ratio r, cutoff rc, and gamma.
Read the guide →Environmental Science, Ecology & HydrologyOudin (2005) Potential Evapotranspiration (PET) Formula: Extraterrestrial R_a & Temperature
Calculate daily watershed Potential Evapotranspiration PET (mm/day) for lumped and distributed rainfall-runoff models (GR4J, HBV, SWAT) using Ludovic Oudin et al.’s (2005) parsimonious 308-catchment radiation-temperature law.
Read the guide →Revenue Management & Hospitality AnalyticsOverbooking Critical Fractile & Booking Limit Formula
Balance empty-seat spoilage c_u against denied-boarding bump compensation c_o via the Critical Fractile CF = c_u/(c_u + c_o) to set optimal flight and hotel overbooking limits.
Read the guide →Healthcare & Clinical FormulasOxygenation Ratios: Spreadsheet Arithmetic and ARDS Definitions
Practice P/F ratio and oxygenation-index arithmetic and learn why diagnosis requires clinical context.
Read the guide →Statistical & Clinical AnalysisP-POSSUM Surgical Audit Research and a Fictional Logistic Formula
Understand the context of the Portsmouth POSSUM surgical audit model and practice a separate fictional logistic calculation.
Read the guide →