Learn one useful thing today.
Highway 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: Cooperative Oxygen / Receptor Binding & Hill Coefficient (nH)
Calculate fractional receptor or hemoglobin saturation θ (%) = 100 / (1 + (EC_50 / [L])^n_H) and arterial-to-venous cooperative O_2 unloading across positive (n_H > 1), non-cooperative (n_H = 1), and negative (n_H < 1) allostery.
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 →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 →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 →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 & QUICKI Fasting Insulin Resistance Indices Formula
Calculate Homeostatic Model Assessment of Insulin Resistance HOMA-IR = (Insulin_uIUmL * Glucose_mgdL) / 405 (or / 22.5 in mmol/L) and Quantitative Insulin Sensitivity Check Index QUICKI = 1 / (LOG10(Insulin) + LOG10(Glucose_mgdL)).
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 →Healthcare Revenue Cycle & Hospital FinanceHospital MS-DRG & High-Cost Outlier Payment Formula
Calculate CMS Inpatient Prospective Payment System (IPPS) Base MS-DRG Reimbursement, Cost-to-Charge Ratio (CCR) Estimated Case Cost, 80% High-Cost Outlier Add-On, and Total Claim Payment.
Read the guide →Healthcare & ClinicalHOSPITAL Score for Potentially Avoidable 30-Day Readmission (0–13)
Calculate Jacques Donzé’s internationally validated HOSPITAL score (0–13 points: Hemoglobin < 12, Oncology, Sodium < 135, Procedure, Urgent Index Type, Prior Admissions, LOS >= 5) before medical discharge.
Read the guide →Aluminum & Copper Extrusion Presses, Billet Container Friction & Profile SpeedHot Extrusion Ratio, Johnson Ram Pressure & Exit Speed Formula
Calculate Extrusion Area Ratio R_ext = A_0 / A_f, Direct-Extrusion Peak Ram Pressure p_ext (MPa), Hydraulic Press Force (MN), and Runout-Table Profile Exit Velocity (m/min).
Read the guide →ASTM A123 / ISO 1461 Hot-Dip Galvanizing, Zinc Kettle Pickup & Corrosion LifeHot-Dip Galvanizing Zinc Thickness & Service-Life Formula
Calculate Metallurgical Zinc Coating Thickness (um and mils) from Area Mass (g/m²), Total Molten-Kettle Zinc Pickup Weight (kg), and ISO 14713 Time to First Maintenance (years).
Read the guide →Highway Materials Engineering, Superpave Gyratory Compaction & Asphalt Pavement QAHot-Mix Asphalt Air Voids (Va), VMA & VFA Formula
Calculate Compacted Specimen Air Voids V_a (%), Voids in Mineral Aggregate VMA (%), Voids Filled with Asphalt VFA (%), and Superpave Volumetric Acceptance Status.
Read the guide →Hospitality Finance & Revenue ManagementHotel ADR, RevPAR, TRevPAR & GOPPAR Formulas
Calculate USALI hotel KPIs accurately: Occupancy, Average Daily Rate (ADR = Room_Rev / Rooms_Sold), RevPAR = Room_Rev / Available_Rooms, TRevPAR, and bottom-line GOPPAR.
Read the guide →Date & TimeHotel and rental stay cost: split Sun–Thu weekday vs Fri–Sat weekend nights
Count exact off-peak (Sun–Thu) and peak (Fri–Sat) stay nights between Check-In and Check-Out dates using a +1 shifted NETWORKDAYS trick.
Read the guide →Industrial Organization & Spatial EconomicsHotelling Linear City & Salop Circular City Pricing Formula
Calculate Hotelling endpoint Nash price c + t, Salop free-entry firm count SQRT(t / F), Salop equilibrium price c + SQRT(t * F), and Salop’s 2x excess-entry theorem.
Read the guide →Financial & AccountingHotelling’s Rule Formula: Exhaustible Resource Scarcity Rent & Price Trajectory
Project competitive mine, lithium, oil, and mineral equilibrium prices P_t = (P_0 - c) * (1 + r)^t + c using Harold Hotelling’s 1931 arbitrage law that in-situ net scarcity rent (P_t - c) rises at the real interest rate r.
Read the guide →Date & TimeHOUR and MINUTE: extract clock components and calculate elapsed shift minutes
Pull 0-23 hours and 0-59 minutes from timestamps with HOUR and MINUTE, and avoid the 24-hour rollover trap on long durations.
Read the guide →StatisticalHow MAXA, MINA, STDEVA, and VARA Coerce Booleans and Text vs. Numeric Aggregates
Audit and reproduce Excel's *A statistical functions (MAXA, MINA, STDEVA, STDEVPA, VARA, VARPA), where TRUE evaluates as 1, FALSE and text strings evaluate as 0, and blanks are ignored.
Read the guide →Formula Auditing & ErrorsHow to Diagnose and Fix #NAME? Errors: Unquoted Strings & Function Typos
Trace #NAME? errors to unquoted text criteria (Billing vs "Billing"), misspelled function identifiers (SUMIFF), or cell-coordinate LET names, and verify fixes with parameterized input cells.
Read the guide →FinanceHow to Fix & Break Circular References Algebraically in Financial Models
Resolve a bonus based on profit after its own deduction using algebra, validated inputs, an explicit rounding policy and a reconciliation check.
Read the guide →LogicalHow to Fix #VALUE! Errors in Math (+ vs SUM) & Text Slicing
Diagnose text in arithmetic and missing delimiters. Choose deliberately between a numeric subtotal and a complete-data total, and keep missing quantities distinct from zero.
Read the guide →LogicalHow to Prevent & Fix #DIV/0! Errors in Ratios, Margins & Averages
Keep undefined ratios separate from zero and compute a regional average using a count of numeric observations, including genuine zeros while excluding missing values.
Read the guide →Dynamic arraysHSTACK function: join separate columns or ranges side by side
Assemble a clean lookup or summary table horizontally from separate column blocks using HSTACK.
Read the guide →Dairy & Food Process Engineering, FDA PMO HTST Pasteurization & Sanitary Fluid FlowHTST Pasteurization Holding-Tube Fastest-Particle Formula
Calculate Sanitary Holding-Tube Mean Bulk Velocity (m/s), Reynolds Number Re, Laminar (2.0x) vs Turbulent (1.22x) Fastest-Particle Residence Time (s), and FDA PMO 15-Second Legal Compliance.
Read the guide →Machine Learning & Cluster EvaluationHubert-Arabie Adjusted Rand Index (ARI) Chance-Corrected Formula
Eliminate true-negative chance inflation in raw Rand cluster accuracy using the Hubert-Arabie (1985) Adjusted Rand Index pairwise formula in Excel and Arte Sheets.
Read the guide →Coastal & Port Engineering, Breakwater Armor & Storm Surge HydraulicsHudson Breakwater Armor Stone Mass & Kd Stability Formula
Calculate Submerged Relative Rock Density S_r, Median Armor Unit Mass M_50 (metric tons) under Cubic Wave-Height Scaling H^3, Nominal Cube Dimension D_n50 (m), and Double-Layer Thickness (m).
Read the guide →Clinical Medicine & PhysiologyHume (1966) Lean Body Mass & Hume-Weyers (1971) Total Body Water Formula
Calculate antipyrine/tritiated-water-calibrated Lean Body Mass (Hume, 1966) and Total Body Water (Hume & Weyers, 1971) from Height (cm) and Weight (kg) for hydrophilic drug dosing and peritoneal dialysis adequacy.
Read the guide →Statistical & Clinical AnalysisHurlbert’s PIE Formula: Unbiased Probability of Interspecific Encounter & S_PIE
Compute Stuart H. Hurlbert’s (1971) finite-sample-unbiased Probability of Interspecific Encounter PIE = (N / (N - 1)) * (1 - SUM((n_i / N)^2)) and Effective Common Species Count S_PIE = 1 / (1 - PIE).
Read the guide →ASHRAE 90.1 Building Controls, Airside Economizers, Mixed-Air Dampers & Free CoolingHVAC Airside Economizer Mixed-Air & Free-Cooling Formula
Calculate Modulating Outside-Air Damper Fraction (%), Mixed-Air Plenum Temperature T_mix (°C), Minimum-Ventilation Baseline Mixed Temp (°C), and Chiller Sensible Free-Cooling Saved (kW).
Read the guide →Building Energy Systems, Phase-Change Thermal Storage & Utility Tariff ArbitrageHVAC Ice-Bank Latent Fusion & Peak-Chiller Shift Formula
Calculate Commercial Ice-Bank Thermal Energy Storage Capacity (kWh_th) from Water Mass and 334 kJ/kg Latent Heat of Fusion, Latent Energy Share, Daytime On-Peak Chiller Electric Demand Shaved (kW_e), and Daily TOU Tariff Arbitrage Savings ($) Accounting for Lower Ice-Making COP.
Read the guide →Dedicated Outdoor Air Systems (DOAS), ASHRAE 84 Psychrometrics & Energy RecoveryHVAC Rotary Enthalpy Wheel Sensible & Latent Recovery Formula
Calculate ASHRAE Standard 84 Desiccant Rotary Enthalpy Wheel Leaving Supply Air Temperature (°C), Total Recovered Enthalpy Power (kW), Sensible Heat Recovered (kW), and Latent Dehumidification/Humidification Power Recovered (kW).
Read the guide →EngineeringHVAC sensible cooling/heating BTU/hr (1.08 * CFM * DeltaT) & Air Changes (ACH)
Calculate HVAC sensible heat transfer in BTU/hr and cooling tons from airflow (CFM) and supply-to-room temperature delta, plus room Air Changes per Hour (ACH).
Read the guide →