Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Distributed Systems & Capacity Engineering

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 Analysis

Gupta 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 & Psychometrics

Guttman’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 & Psychometrics

Gwet’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 →
Engineering

Haaland 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 & Scientific

Haaland’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 Balance

Haber-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 Costing

Habraken 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 →
Engineering

Hagen-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 Engineering

Haider & 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 →
Science

Haldane 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 →
Engineering

Hall 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 →
Engineering

Hall-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 →
Financial

Hamada 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 Formula

Hankinson 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 Microstructure

Hannah-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-Finance

Hansen-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 Engineering

Hantush-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 & Time

Happy 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 & Clinical

HAPS 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 Economics

Harberger 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 Performance

Hard-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 →
Statistical

Hardy-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 →
Science

Hargreaves-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 Distribution

Harmonic 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 Analysis

Harrell’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 Economics

Harris-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 & Physiology

Harris–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 Finance

Harrod-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 Coordination

Harsanyi-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 Analysis

Hartung-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 Development

Hartwick 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 Calculations

Harvey-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 →
Statistical

HAS-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 Finance

Hasbrouck 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 & Science

Hausen 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 & Econometrics

Hausman 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 & Macroeconomics

Hayashi 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 & Science

Hayduk-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 →
Engineering

Hazen-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 Operations

Heap 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 →
Healthcare

HEART 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 →
Engineering

Heat 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 →
Engineering

Heat 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 →
Engineering

Heat 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 & Science

Heating 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 Pressure

Heckel 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-Analysis

Hedges’ 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 & Trading

Heikin-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 & Science

Heisenberg 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 →