Learn one useful thing today.
Gunther Universal Scalability Law (USL) Peak Formula
Calculate cluster relative capacity C(N) = N / (1 + alpha*(N - 1) + beta*N*(N - 1)) and exact retrograde concurrency peak N_peak* = SQRT((1 - alpha)/beta) under Neil Gunther’s USL.
Read the guide →Statistical & Clinical AnalysisGupta MICA: Perioperative Risk Model and Logistic Function
An overview of the published Gupta cardiac-risk model and a separate, nonclinical example of the logistic function.
Read the guide →Statistical & PsychometricsGuttman’s Split-Half Lambda-4 (λ₄) Reliability Formula (Constrained-Free Variances)
Calculate Louis Guttman’s (1945) split-half test reliability λ_4 = 2 * (1 - (s_A^2 + s_B^2) / s_X^2) without Spearman-Brown’s strict equal-half-variance assumption.
Read the guide →Statistical & PsychometricsGwet’s AC1 Inter-Rater Agreement Coefficient (Solving the Kappa Paradox)
Calculate Kilem Gwet’s (2008) paradox-resistant first-order agreement coefficient AC1 = (p_a - p_eγ) / (1 - p_eγ) vs. Cohen’s κ when trait prevalence is skewed near 0% or 100%.
Read the guide →EngineeringHaaland Explicit Turbulent Pipe Friction Factor (Moody Chart Formula)
Calculate Darcy-Weisbach pipe friction factor f without iterative Colebrook-White loops using S.E. Haaland's explicit formula (-1.8 * LOG10(((eps / D) / 3.7)^1.11 + (6.9 / Re)))^(-2) with a laminar 64 / Re branch.
Read the guide →Engineering & ScientificHaaland’s Explicit Darcy Friction Factor & Laminar-Turbulent Head-Loss Gate
Calculate Darcy-Weisbach pipe friction factor f directly without Colebrook circular iteration using S. E. Haaland’s (1983) 1.11-exponent Moody equation plus a laminar 64/Re switch.
Read the guide →Chemical Reaction Engineering, Synthesis Loops & Recycle Mass BalanceHaber-Bosch Ammonia Synthesis Recycle, Purge & Conversion Formula
Calculate Synthesis-Loop Inert Purge Flow (kmol/hr), Overall Reactant Conversion (%), Ammonia Production Rate (t/hr), and Total Reactor Inlet Flow (kmol/hr) from single-pass conversion.
Read the guide →Architectural Economics, Circular Construction & Lifecycle CostingHabraken Open-Building Support vs Infill Lifecycle Cost
Compare John Habraken Open-Building Decoupled Support + Modular Infill Cumulative Lifecycle Cost against Entangled Monolithic Renovation Tear-Out Penalties, Circular Demolition Savings, and Annualized Cost.
Read the guide →EngineeringHagen-Poiseuille Laminar Flow formula: R^4 radius law & hydraulic resistance
Calculate ideal fully developed laminar flow, hydraulic resistance and a Reynolds-number applicability check for a straight round tube.
Read the guide →Chemical, Process & Catalysis EngineeringHaider & Levenspiel (1989) Drag Coefficient C_D Formula: Spherical & Non-Spherical Particles
Calculate fluid-particle Drag Coefficient C_D across Stokes, intermediate, and Newton turbulent regimes (Re < 260,000) for spheres (phi = 1) and angular catalyst, mineral, or biomass particles (0.2 <= phi < 1) via A. Haider and Octave Levenspiel (1989).
Read the guide →ScienceHaldane Substrate-Inhibition Enzyme & Bioreactor Kinetics Formula
Explore a substrate-inhibition rate curve, its maximizing concentration and its actual peak. Distinguish the fitted rate-scale parameter from the peak and from a reactor feed concentration.
Read the guide →EngineeringHall Voltage, Single-Carrier Density & Seebeck Thermoelectric ZT
Calculate a simple transverse Hall voltage and single-carrier density estimate, then explore an independent constant-coefficient Seebeck voltage and dimensionless material ZT.
Read the guide →EngineeringHall-Petch Grain-Size Strengthening & Alloy Yield Strength Formula
Calculate polycrystalline metal yield strength sigma_y = sigma_0 + k_y / SQRT(d) (MPa) from lattice friction stress sigma_0, Hall-Petch locking coefficient k_y (MPa*m^0.5), and average grain diameter d (m).
Read the guide →FinancialHamada Equation formula: unlever peer Beta & relever to target Debt/Equity
Strip financial leverage out of comparable-company betas via Beta_U = Beta_L / (1 + (1 - Tax)*D/E) and relever to your valuation target capital structure.
Read the guide →Mass Timber & Structural Wood Design, NDS Hankinson Grain-Angle Bearing FormulaHankinson Wood Grain-Angle Bearing Strength Formula
Calculate NDS Hankinson Inclined-to-Grain Bearing Strength F_theta (MPa), Retained Parallel Strength (%), Allowable Joint Bearing Load (kN), and Naive Linear Error (MPa).
Read the guide →Economics & Market MicrostructureHannah-Kay Generalized Concentration Index HK(alpha) Formula: Numbers-Equivalent Firms
Unify Shannon Entropy (alpha -> 1), Herfindahl-Hirschman 1/HHI (alpha = 2), and large-firm dominance weighting in a single numbers-equivalent market structure formula: N_HK(alpha) = (SUM(s_i^alpha))^(1 / (1 - alpha)).
Read the guide →Asset Pricing & Macro-FinanceHansen-Jagannathan Bound & Equity Premium Puzzle
Test asset-pricing pricing kernels against Lars Peter Hansen and Ravi Jagannathan’s (1991) lower bound sigma(M) / E[M] >= ABS(E[R_e]) / sigma(R_e) and quantify Mehra-Prescott implied risk aversion.
Read the guide →Civil, Structural & Geotechnical EngineeringHantush-Jacob Leaky Aquifer Formula: Leakage Factor B, Aquitard Resistance c & Steady Drawdown
Analyze semi-confined ("leaky") pumping wells using Mahdi S. Hantush and C. E. Jacob’s (1955) Characteristic Leakage Length B = SQRT(T * b_prime / K_prime), Hydraulic Resistance c = b_prime / K_prime, and De Glee steady drawdown.
Read the guide →Date & TimeHappy Birthday & Work Anniversary Alert Formula (MONTH & DAY)
Build an annual reminder from numeric dates, with an explicit February 28 policy for leap-day anniversaries in common years and calendar-day comparisons for timestamps.
Read the guide →Healthcare & ClinicalHAPS Research Criteria: A Spreadsheet Boundary Exercise
Explore the three HAPS research criteria with fictional values, clear units, complete input checks, and an explicitly flagged ambiguous creatinine boundary.
Read the guide →Public Finance & Welfare EconomicsHarberger Deadweight Loss Triangle & Marginal Cost of Funds
Calculate Harberger excess burden DWL = 0.5 * eta * tau^2 * (P_0 * Q_0), quadratic distortion scaling, and Marginal Cost of Public Funds MCPF = (1 - eta*tau) / (1 - 2*eta*tau).
Read the guide →Mechanized Tunneling & Underground Civil Engineering, CSM / NTNU Hard-Rock TBM PerformanceHard-Rock TBM Cutterhead Thrust, Torque & Daily Advance
Calculate Total Cutterhead Normal Thrust (MN), Cutterhead Drive Torque (MN·m), Net Boring Rate of Penetration ROP (m/h), and Daily Utilization-Adjusted Tunnel Advance (m/d).
Read the guide →StatisticalHardy-Weinberg Equilibrium formula: allele & heterozygous carrier frequency (2pq)
Explore two-allele genotype proportions under Hardy–Weinberg assumptions using an assumed recessive homozygote frequency.
Read the guide →ScienceHargreaves-Samani Reference Evapotranspiration and Crop ET in Excel
Estimate reference ET0 from daily temperatures and extraterrestrial radiation, apply a crop coefficient, and distinguish crop evapotranspiration from irrigation water to apply.
Read the guide →Electrical Power Quality & Data-Center DistributionHarmonic THD, True Power Factor & K-Factor Formula
Calculate IEEE 519 Current Total Harmonic Distortion (THD_I), Total RMS Current, True Total Power Factor PF_disp / SQRT(1 + THD_I^2), and UL 1561 Transformer Eddy-Current K-Factor.
Read the guide →Statistical & Clinical AnalysisHarrell’s C-Index & Somers’ D_xy: Survival Model Concordance for Censored Data
Calculate Frank Harrell’s Cox survival discrimination index C = (N_concordant + 0.5*N_tied) / N_permissible and Somers’ rank correlation D_xy = 2*C - 1.
Read the guide →Development & Labor EconomicsHarris-Todaro Rural-Urban Migration & Unemployment Formula
Solve John Harris & Michael Todaro’s (1970) expected-wage migration equilibrium w_R = (L_M / L_U)*w_M, urban unemployment rate u* = 1 - w_R/w_M, and the Todaro job-creation paradox.
Read the guide →Clinical Medicine & PhysiologyHarris–Benedict and Roza–Shizgal Energy Equations
Compare the original and revised resting-energy equations and understand their study populations and limits.
Read the guide →Macroeconomics & Development FinanceHarrod-Domar ICOR Growth & Financing Gap Formula
Calculate Harrod-Domar warranted GDP growth g_w = (s / ICOR) - delta, required gross investment share (g_target + delta) * ICOR, and Chenery-Strout external financing gap.
Read the guide →Game Theory & Strategic CoordinationHarsanyi-Selten Risk Dominance (Stag Hunt) Formula
Calculate the Critical Trust Threshold p* = (D - C)/((A - B) + (D - C)) and Harsanyi-Selten (1988) risk-dominance margin in symmetric 2x2 Stag Hunt coordination games.
Read the guide →Statistical & Clinical AnalysisHartung-Knapp-Sidik-Jonkman (HKSJ) Random-Effects Standard Error Formula
Eliminate anti-conservative DerSimonian-Laird false positives in small-k meta-analyses using the Röver-Knapp truncated HKSJ variance factor q = MAX(1, [1/(k-1)] * Σ w_i*(y_i - μ_RE)²) and SE_HKSJ = SQRT(q / Σw_i*).
Read the guide →Macroeconomics & Sustainable DevelopmentHartwick Rule & Genuine Saving (ANS) Formula
Calculate World Bank Adjusted Net Saving GNS - D_cap + E_edu - R_dep - D_pol and test John Hartwick’s (1977) wealth-sustainability reinvestment rule.
Read the guide →Healthcare & Clinical CalculationsHarvey-Bradshaw Index (HBI) for Crohn’s Disease Activity & Remission
Sum five Harvey–Bradshaw Index components and compare the result with commonly used Crohn’s disease activity ranges, with input checks and interpretation.
Read the guide →StatisticalHAS-BLED spreadsheet exercise: nine validated risk-factor flags
Practice summing nine binary flags and comparing a historical HAS-BLED review threshold, without making treatment decisions.
Read the guide →Market Microstructure & Quant FinanceHasbrouck Information Share Bounds for Two-Venue Price Discovery
Calculate Hasbrouck (1995) Cholesky upper, lower, and midpoint price-discovery information shares across two cointegrated trading venues and audit correlation sensitivity.
Read the guide →Engineering & ScienceHausen Laminar Thermal Entry-Length Formula: Graetz Number & Pipe Nusselt
Calculate length-averaged laminar tube Nusselt number Nu_D = 3.66 + 0.0668*Gz / (1 + 0.04*Gz^(2/3)) from Graetz number Gz = (D/L)*Re*Pr for constant wall temperature.
Read the guide →Panel Data & EconometricsHausman Fixed-vs-Random-Effects Specification Test Formula
Test correlation between unobserved unit effects alpha_i and regressors X_it using Hausman’s (1978) H = (b_FE - b_RE)^2 / (SE_FE^2 - SE_RE^2) chi-square statistic.
Read the guide →Corporate Investment Theory & MacroeconomicsHayashi Marginal q & CapEx Adjustment-Cost Formula
Calculate Hayashi’s CRS Marginal/Average q Ratio V / K, Optimal Investment-to-Capital Rate I / K = delta + (q - 1) / phi, Optimal Gross CapEx, and Convex Installation Friction Cost.
Read the guide →Engineering & ScienceHayduk-Laudie Aqueous Diffusivity: An Estimate for Dilute Solutions
Estimate aqueous diffusivity with the Hayduk-Laudie correlation using water viscosity and the solute molar volume at its normal boiling point.
Read the guide →EngineeringHazen-Williams Water Pipe Head Loss formula: 10.67 * L * Q^1.852 / (C^1.852 * D^4.8704)
Estimate straight-pipe friction head loss for turbulent water flow with SI inputs and an assumed Hazen-Williams coefficient.
Read the guide →Hydrometallurgy, Gold ADR / Copper SX-EW & Heap Leach OperationsHeap Leach Irrigation Flux, PLS Flow & Metal Recovery Formula
Calculate Pregnant Leach Solution (PLS) Volumetric Flow (m³/hr), ADR/SX Stripping Efficiency (%), Daily Net Recovered Metal Mass (kg/d), and Daily Gold Equivalent (troy oz/d).
Read the guide →HealthcareHEART Score Spreadsheet: Validate and Sum Five Subscores
Practice input validation, SUM and IFS with five fictional HEART subscores. Calculate a total from 0 to 10 and a numerical score band without generating treatment or discharge instructions.
Read the guide →EngineeringHeat Exchanger Effectiveness-NTU Method (Counterflow & Condenser)
Calculate counterflow effectiveness, its balanced-capacity limit, an ideal isothermal phase-change comparison and heat duty, with explicit units and stable near-limit evaluation.
Read the guide →EngineeringHeat Exchanger LMTD (Log-Mean Temperature Difference) & Area sizing formula
Calculate counter-current heat exchanger Log-Mean Temperature Difference LMTD = (dT1 - dT2) / LN(dT1 / dT2) with L'Hopital equal-pinch guard and required surface area.
Read the guide →EngineeringHeat Pump & Chiller COP (Cooling vs Heating) & EER HVAC formulas
Calculate cooling Coefficient of Performance COP_cool = Q_cold / W_in, heating COP_heat = (Q_cold + W_in) / W_in = COP_cool + 1, and Energy Efficiency Ratio EER = 3.41214 * COP.
Read the guide →Engineering & ScienceHeating Degree Days (HDD) & Cooling Degree Days (CDD) Weather Energy Formula
Calculate daily and cumulative Heating Degree Days HDD = MAX(0, T_base - (T_max + T_min) / 2) and Cooling Degree Days CDD = MAX(0, (T_max + T_min) / 2 - T_base) for HVAC energy normalization and weather derivatives.
Read the guide →Pharmaceutical Solid-Dosage Engineering, Rotary Tablet Press Heckel Yield PressureHeckel Pharmaceutical Tablet Compaction Yield Formula
Calculate Tablet Relative Density D, Residual Porosity (%), Heckel Log-Porosity Value LN(1/(1-D)), and Excipient Mean Yield Pressure Py = 1/K (MPa).
Read the guide →Biostatistics & Meta-AnalysisHedges’ g Small-Sample Bias Correction and Glass’s Delta Formula
Correct upward small-sample bias in Cohen’s d using Hedges’ J(df) = 1 - 3 / (4*df - 1) factor and switch to Glass’s Delta when treatment alters group variance.
Read the guide →Quantitative Finance & TradingHeikin-Ashi Candlestick Formula: Smoothed HA-OHLC Recursion & Wickless Trend Filter
Transform noisy raw OHLC price bars into Munehisa Homma’s smoothed Heikin-Ashi ("Average Bar") coordinates HA_Open, HA_High, HA_Low, HA_Close and detect pure wickless trend candles.
Read the guide →Engineering & ScienceHeisenberg Uncertainty Principle: Momentum Spread & Natural Linewidth
Calculate minimum quantum momentum spread delta_p*c >= hbar*c / (2 * delta_x) (using hbar*c = 197.327 eV*nm) and excited-state / ultrafast-laser energy linewidth delta_E >= hbar / (2 * tau) (using hbar = 658.212 meV*fs).
Read the guide →