Learn one useful thing today.
Hellmann Wind Shear Hub-Height Power Formula
Extrapolate meteorological mast wind speed to turbine hub height via Gustav Hellmann’s Power Law v_hub = v_ref * (z_hub / z_ref)^alpha and compute the Cubic Wind Power Density Multiplier (z_hub / z_ref)^(3*alpha).
Read the guide →Engineering & ScienceHelmholtz Resonator Frequency Formula (With Flanged Neck End Correction)
Calculate the resonant frequency f_H = (c / (2 * PI())) * SQRT(A_neck / (V_cavity * L_eff)) in Hz of bass-reflex speaker ports, engine intake resonators, and acoustic absorbers including neck end correction L_eff = L + 1.7 * r.
Read the guide →Healthcare & ClinicalHEMORR2HAGES Study: Checking and Adding Weighted Binary Flags
Explore a fictional point-summing example based on the published HEMORR2HAGES factor weights.
Read the guide →EngineeringHenderson-Hasselbalch equation: Buffer pH & Conjugate Base/Acid ratio
Estimate buffer pH from a weak-acid/conjugate-base concentration ratio, and invert the approximation for a target pH.
Read the guide →Healthcare & Clinical FormulasHendrich II: Educational Weighted Score Example
Practice the arithmetic of the Hendrich II weighted score using already-assessed example inputs, with missing-value checks and current guideline context.
Read the guide →FinancialHerfindahl-Hirschman Index (HHI) formula for market & supplier concentration
Calculate revenue-share HHI on the 0–10,000 scale and the equivalent number of equal-sized firms for a defined market or supplier set.
Read the guide →Engineering & ScienceHerning-Zipperer Rule: Multicomponent Natural Gas Mixture Viscosity Formula
Calculate multicomponent hydrocarbon & flue-gas mixture viscosity μ_m = Σ(y_i * μ_i * SQRT(M_i)) / Σ(y_i * SQRT(M_i)) using square-root molecular weights.
Read the guide →Non-Newtonian Fluid Mechanics, API 13D Herschel-Bulkley & Bingham Plug FlowHerschel-Bulkley Yield Stress & Pipe Plug-Flow Formula
Calculate Herschel-Bulkley Total Shear Stress tau (Pa), Apparent Viscosity (mPa·s / cP), Unsheared Central Plug Radius Ratio rp/R, and Sheared Flowing Area (%).
Read the guide →EngineeringHertzian Contact Stress: Ball-on-Flat Contact Radius & Max Pressure
Calculate reduced contact modulus E*, circular contact-patch radius a = ((3 * F * R) / (4 * E*))^(1/3), and peak Hertzian bearing stress p_max = (3 * F) / (2 * PI() * a^2) (MPa).
Read the guide →Healthcare & Clinical FormulasHestia Criteria: An Educational Binary-Flag Counting Example
Count illustrative yes/no flags inspired by the Hestia checklist; the worksheet does not determine discharge, anticoagulant treatment, or clinical eligibility.
Read the guide →StatisticalHHI market concentration, Gini Impurity, and Shannon Entropy formulas
Quantify market concentration (HHI = SUM(s^2)*10000), classification Gini Impurity (1 - SUM(p^2)), and information Shannon Entropy in bits.
Read the guide →Statistical & Clinical AnalysisHick-Hyman Law Formula: Choice Reaction Time RT = a + b * log2(n + 1)
Quantify menu-navigation and cockpit decision latency across n equally probable choices using William Edmund Hick (1952) and Ray Hyman’s (1953) logarithmic law RT = a + b * LOG(n + 1, 2).
Read the guide →Engineering & ScienceHigbie Penetration & Danckwerts Surface-Renewal Mass Transfer (kL)
Calculate liquid-side gas-absorption mass-transfer coefficients k_L (mm/s) using Ralph Higbie’s unsteady penetration model 2*SQRT(D_AB / (π * t_e)) and Peter Danckwerts’ random surface-renewal theory SQRT(D_AB * s).
Read the guide →Statistical & Clinical AnalysisHiggins I² & H² Meta-Analysis Heterogeneity Formula from Cochran’s Q
Quantify percentage between-study inconsistency I² = MAX(0, (Q - (k - 1)) / Q) * 100% and variance-inflation factor H² = MAX(1, Q / (k - 1)) in Cochrane meta-analyses.
Read the guide →Data Validation & AuditingHighlight & Audit Numbers Stored with Embedded Unit or Currency Symbols (ISTEXT)
Catch imported entries like "125 kg", "approx 90", or "EUR 400" that masquerade as numbers and silently drop out of SUM() using --AND(B2 <> "", ISTEXT(B2)).
Read the guide →Conditional Formatting & RulesHighlight & Count Duplicate Columns in a Matrix (TEXTJOIN Signature + COUNTIF)
Detect accidentally duplicated import columns across a multi-row table by serializing each column vector with TEXTJOIN("|", FALSE, A2:A4) and flagging signatures with COUNTIF($A$5:$D$5, A5) > 1.
Read the guide →Conditional Formatting & RulesHighlight & Count Values Between Two Bounds: Order-Safe MIN/MAX & COUNTIFS
Test whether numbers or dates fall inside [Lower, Upper]—even if a user types Upper before Lower—using AND(B2 >= MIN($E$2,$E$3), B2 <= MAX($E$2,$E$3)) and COUNTIFS.
Read the guide →Conditional Formatting & AuditsHighlight Cells Matching Any Value in a Watchlist Range (COUNTIF Membership Rule)
Replace brittle 10-way OR formulas with a table-driven COUNTIF($D$2:$D$5, TRIM(A2)) > 0 rule that highlights any row matching an editable watchlist or priority code table.
Read the guide →Conditional Formatting & AuditsHighlight Cells That End With a Specific Suffix (RIGHT & LEN Exact Suffix Rule)
Flag filenames, SKUs, or email domains ending with a target suffix like ".csv" or "-TEMP" using TRIM, RIGHT, and LEN—avoiding wildcard false positives on "?" and "*".
Read the guide →Conditional Formatting & AuditsHighlight Entire Rows by Day of Week or Incomplete Required Fields
Apply column-locked row formatting rules using WEEKDAY($B2, 2) = $G$2 to spotlight Friday/Monday cutoffs and AND(COUNTA($A2:$D2) > 0, COUNTBLANK($A2:$D2) > 0) to catch half-entered rows.
Read the guide →Logical & ConditionalHighlight Every Other Row & N-Row Zebra Bands (ISEVEN, ROW & MOD)
Generate TRUE/FALSE zebra-striping flags for alternating single rows using ISEVEN(ROW(A2)) or header-anchored MOD(ROW(A2) - ROW($A$2), 2) = 1, and group N-row visual blocks via MOD(INT((ROW(A2) - ROW($A$2)) / N), 2) = 1.
Read the guide →Conditional Formatting & AuditsHighlight Strictly Unique (Once-Only) Values with Blank-Safe COUNTIF Rules
Flag single-occurrence IDs, unmatched reconciliation entries, or one-time buyers using COUNTIF($A$2:$A$7, A2) = 1 while preventing blank rows from highlighting.
Read the guide →Civil Transportation & Highway Pavement EngineeringHighway Fourth-Power Law & ESAL Axle Damage Formula
Calculate the AASHO Road Test Fourth-Power Load Equivalency Factor LEF = (Axle_kips / 18)^4, Daily & Cumulative Design Million ESALs, and Cubic Nonlinear Damage Amplification vs Linear Weight.
Read the guide →Engineering & ScienceHildebrand Solubility Parameter (delta) & Cohesive Energy Density
Calculate cohesive energy density c = (DeltaH_vap - R * T) / V_m (MPa) and Joel Hildebrand’s SI solubility parameter delta = SQRT(c) (MPa^0.5) to predict polymer-solvent miscibility.
Read the guide →Geotechnical Foundation Engineering, Driven Piles & Hammer DynamicsHiley Dynamic Pile-Driving Set & Ultimate Capacity Formula
Calculate Newtonian Cushion Impact Efficiency eta_impact, Net Transferred Blow Energy (kN·m), Hiley Ultimate Driving Resistance R_u (kN), and Safe Working Pile Capacity (kN at FS = 3.0).
Read the guide →Healthcare & Clinical FormulasHill Equation: Saturation, Slope and Worked Examples
Explore a Hill saturation curve, its logit and the difference between two modeled saturations, with parameter and interpretation limits.
Read the guide →Engineering & ScienceHill Sphere Radius (rH) & Orbital Moon Stability Calculator
Calculate George William Hill’s pericenter gravitational dominance sphere r_H = a * (1 - e) * (m_planet / (3 * M_star))^(1/3) (km) for planetary moons, James Webb L1/L2 halo orbits, and exoplanets.
Read the guide →FinancialHistorical beta, regression intercept and modeled CAPM return
Estimate historical Beta = Cov(Ri, Rm) / Var(Rm) in one SLOPE(StockReturns, MarketReturns) call and compute CAPM Required Return Rf + Beta * (Rm - Rf).
Read the guide →Hepatology, Organ Transplant Allocation & Clinical ScoringHistorical MELD Formula: Spreadsheet Arithmetic and Current OPTN Changes
Study a historical logarithmic formula with fictional numbers and find the current official MELD calculator.
Read the guide →StatisticalHistorical MELD-Na arithmetic: logarithms, bounds and rounding
Explore a simplified historical non-dialysis MELD-Na example with fictional laboratory inputs. This is not the current transplant-allocation calculator.
Read the guide →MathHistorical Parkland and 4-2-1 formulas as spreadsheet arithmetic exercises
Practice multiplication, remaining-volume arithmetic and piecewise weight brackets using fictional inputs, not clinical dosing instructions.
Read the guide →Healthcare & ClinicalHistorical TTKG and urine anion gap: arithmetic and limitations
Explore the historical TTKG and urine anion gap equations with units, missing-input checks and limits on interpretation.
Read the guide →LookupsHLOOKUP function: look up values across horizontal column headers
Search the top row of a wide quarterly table for an exact period label and return the value from a specified row beneath it.
Read the guide →Fixed Income & Interest Rate ModelsHo-Lee and Hull-White Short-Rate Drift Theta Calibration Formula
Calibrate no-arbitrage time-dependent drift theta(t) in Ho-Lee and one-factor Hull-White models to the observed forward curve f(0, t), slope df/dt, and convexity term.
Read the guide →EngineeringHohmann Transfer Orbit formulas: Perigee Burn, Apogee Burn & Coast Time
Calculate signed tangential velocity changes and coast time for an ideal two-impulse transfer between coplanar circular orbits.
Read the guide →Structured Credit, HoldCo Preferred Equity & LBO WaterfallsHoldCo Preferred Equity PIK vs Min-MOIC Waterfall Formula
Calculate HoldCo Preferred Equity Compounded PIK Claim ($M), Senior Liquidation Payout With Minimum-MOIC Floor ($M), Residual Common Equity Proceeds ($M), and Sponsor Common MOIC (x).
Read the guide →Growth Experimentation & Causal Marketing AnalyticsHoldout Incrementality iROAS & Attribution Bias Formula
Calculate Randomized Holdout / Geo-Lift Causal Revenue Lift per User, True Incremental Revenue, Causal Incremental ROAS (iROAS), and Platform Last-Touch Attribution Overclaim Multiplier.
Read the guide →Sheet-Metal Stamping, Plasticity & Mechanical MetallurgyHollomon Strain Hardening & Considere Necking Formula
Calculate John Hollomon’s True Flow Stress sigma_true = K * (eps_true ^ n), Armand Considère’s Diffuse Necking True Strain Limit (eps_u = n), Maximum Uniform Engineering Elongation EXP(n) - 1, and Stamping Instability Status.
Read the guide →Chassis Suspension & Motorsport Anti-Roll Bars, Hollow Torsion-Bar d^4 ScalingHollow Torsion-Bar Spring Rate, Twist & Shear Formula
Calculate Polar Area Moment J (cm⁴), Torsional Angular Stiffness k_theta (N·m/deg), Suspension Windup Twist Angle (deg), and Outer-Surface Shear Stress tau_max (MPa).
Read the guide →Organizational Economics & Incentive DesignHolmström Team Moral Hazard & 1/N Free-Rider Formula
Quantify Bengt Holmström’s (1982) 1/N team partnership free-rider effort e_Nash = k_p/(N*c) against first-best e_FB = k_p/c and prove the exact ((N - 1)/N)^2 surplus loss.
Read the guide →Personnel Economics & Contract TheoryHolmstrom-Milgrom Multitask Incentive Formula
Calculate Bengt Holmstrom and Paul Milgrom’s (1991) multitask optimal piece rate beta_1* when measured volume effort substitutes away from unmeasured quality effort (c_12 > 0).
Read the guide →Contract Theory & Organizational EconomicsHolmström-Milgrom Optimal Incentive Intensity (beta*) Formula
Design an optimal linear bonus contract w(x) = alpha + beta * x under CARA moral hazard using beta* = k^2 / (k^2 + r * c * sigma^2), base salary alpha*, and agency loss.
Read the guide →Corporate Finance & Banking MacroHolmström-Tirole Pledgeable Income & Leverage Multiplier
Calculate unit pledgeable income rho_0 = p_H*(R - b/dp), the Holmström-Tirole (1997) equity multiplier 1/(1 - rho_0/gamma), and maximum borrowing capacity I_max - A.
Read the guide →Healthcare & ClinicalHOMA-IR and QUICKI: Fasting Glucose and Insulin Formulas
Calculate the HOMA1-IR approximation in either glucose unit and QUICKI in mg/dL, with explicit units and interpretation limits.
Read the guide →Civil, Structural & Geotechnical EngineeringHooghoudt Subsurface Tile Drain Spacing Formula: Equivalent Depth d_e & Midpoint Mound m
Size parallel agricultural subsurface pipe/ditch drain spacing L (m) under steady-state rainfall or leaching recharge q using S. B. Hooghoudt’s (1940) equation L = SQRT((8 * K_b * d_e * m + 4 * K_a * m^2) / q).
Read the guide →Financial & Economic AnalysisHoover Index (Robin Hood / Schutz Index) & Exact Parity Reallocation Share
Calculate the Hoover (Robin Hood / Pietra) index 0.5 * SUM(|resource_share - population_share|) and the exact volume that must shift from surplus to deficit units to reach equal per-capita parity.
Read the guide →Lookup & ReferenceHorizontal XLOOKUP Across Columns: Upward Return & Right-to-Left Last Match
Replace fragile row-index HLOOKUP formulas with horizontal XLOOKUP across column headers, including upward lookups into rows above the match row and right-to-left latest-revision searches.
Read the guide →ScienceHorton Soil Infiltration Capacity Curve f(t) & Cumulative Depth F(t)
Calculate exponentially decaying storm infiltration capacity f(t) = f_c + (f_0 - f_c) * EXP(-k * t) (mm/hr) and exact integrated cumulative infiltration depth F(t) = f_c * t + ((f_0 - f_c) / k) * (1 - EXP(-k * t)) (mm).
Read the guide →Causal Inference & Survey StatisticsHorvitz-Thompson vs Hajek Inverse Probability Weighting (IPW) ATE
Compare unnormalized Horvitz-Thompson IPW against self-normalized Hajek IPW in Excel and Arte Sheets to eliminate finite-sample baseline-level distortion and audit propensity positivity.
Read the guide →Hospital Operations & Healthcare BenchmarkingHospital Case-Mix Index (CMI) & Cost per Case Formula
Calculate Hospital Case-Mix Index (CMI = Total_DRG_Weights / Discharges), AHA Outpatient-Adjusted Discharges, CMI-Adjusted Equivalent Discharges, and Acuity-Normalized Cost per Case.
Read the guide →