Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Wind Energy & Atmospheric Engineering

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

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

HEMORR2HAGES Study: Checking and Adding Weighted Binary Flags

Explore a fictional point-summing example based on the published HEMORR2HAGES factor weights.

Read the guide →
Engineering

Henderson-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 Formulas

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

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

Herning-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 Flow

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

Hertzian 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 Formulas

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

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

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

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

Higgins 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 & Auditing

Highlight & 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 & Rules

Highlight & 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 & Rules

Highlight & 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 & Audits

Highlight 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 & Audits

Highlight 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 & Audits

Highlight 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 & Conditional

Highlight 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 & Audits

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

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

Hildebrand 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 Dynamics

Hiley 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 Formulas

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

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

Historical 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 Scoring

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

Historical 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 →
Math

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

Historical 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 →
Lookups

HLOOKUP 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 Models

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

Hohmann 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 Waterfalls

HoldCo 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 Analytics

Holdout 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 Metallurgy

Hollomon 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 Scaling

Hollow 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 Design

Holmströ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 Theory

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

Holmströ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 Macro

Holmströ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 & Clinical

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

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

Hoover 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 & Reference

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

Horton 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 Statistics

Horvitz-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 Benchmarking

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