Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Healthcare Revenue Cycle & Hospital Finance

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

HOSPITAL Score for Potentially Avoidable 30-Day Readmission (0–13)

Calculate the 2016 international-validation version of the HOSPITAL score for 30-day potentially avoidable readmission, with input checks and study context.

Read the guide →
Aluminum & Copper Extrusion Presses, Billet Container Friction & Profile Speed

Hot 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 Life

Hot-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 QA

Hot-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 Management

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

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

Hotelling 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 & Accounting

Hotelling’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 & Time

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

How 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 & Errors

How 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 →
Finance

How 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 →
Logical

How 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 →
Logical

How 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 arrays

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

HTST 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 Evaluation

Hubert-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 Hydraulics

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

Hume and Hume–Weyers: Lean Mass and Body Water Estimates

Compare historical height-and-weight equations for lean body mass and total body water while recognizing their sampling and clinical limitations.

Read the guide →
Statistical & Clinical Analysis

Hurlbert’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 Cooling

HVAC 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 Arbitrage

HVAC 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 Recovery

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

HVAC 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 →
Mechanical MEP, Psychrometrics & Data-Center Cooling

HVAC Sensible Heat Ratio (SHR) & Coil Tons Formula

Calculate ASHRAE Sea-Level Air-Side Sensible Cooling Q_s = 1.08 * CFM * Delta_T_F, Latent Dehumidification Q_L = 0.68 * CFM * Delta_W_grains, Total Chiller Tons (/ 12,000), and Sensible Heat Ratio SHR = Q_s / Q_total.

Read the guide →
Civil, Structural & Geotechnical Engineering

Hveem Stabilometer Resistance R-Value Formula (ASTM D2844) & Subgrade Modulus

Calculate ASTM D2844 / Caltrans Test 301 Hveem Stabilometer Resistance R-Value (0–100 scale) from 160-psi vertical pressure, transmitted horizontal fluid pressure P_h, and displacement turns D_2, plus AASHTO Resilient Modulus M_R.

Read the guide →
Operations, Logistics & Engineering

Hvorslev Slug Test Formula: Piezometer Hydraulic Conductivity & Basic Time Lag T_0

Determine in-situ aquifer horizontal hydraulic conductivity K = (r_c^2 * LN(L_e / R)) / (2 * L_e * T_0) from rising- or falling-head piezometer slug-test recovery data using M. Juul Hvorslev’s (1951) USACE equation.

Read the guide →
Fluid Power Energy Storage, Nitrogen Bladder/Piston Accumulators & Emergency Fail-Safe Sizing

Hydraulic Bladder Accumulator Polytropic Sizing Formula

Calculate Dry-Nitrogen Precharge Pressure P_0 (bar_a), Naive Isothermal Gas Shell Volume V_0,iso (L), Polytropic/Adiabatic Required Shell Volume V_0,n (L), and Adiabatic Cooling Oversize Penalty (%).

Read the guide →
Fluid Power Engineering, Industrial & Mobile Hydraulic Cylinders & Regenerative Valves

Hydraulic Cylinder Push/Pull Force & Regenerative Speed Formula

Calculate Full-Bore Push Force (kN), Annular Rod-End Pull Force (kN), Normal Extension Speed (mm/s), Retraction Speed (mm/s), and Regenerative Fast-Approach Speed (mm/s).

Read the guide →
Mineral Comminution & Wet Classification, Plitt-Arterburn Hydrocyclone d50c & G-Force

Hydrocyclone Cut Size d50c, G-Force & Slurry Flow Formula

Calculate Hydrocyclone Volumetric Slurry Capacity (m³/h), Tangential Inlet Velocity (m/s), Wall Centrifugal G-Force, and Plitt-Arterburn Corrected Cut Size d50c (um).

Read the guide →
Hydropower Engineering, Fluid Turbomachinery & Renewable Energy

Hydroelectric Net Head, MW Output & Pelton Jet Speed Formula

Calculate Hydropower Net Effective Head (Gross_Head - Penstock_Loss), Electrical Generation Power (rho*g*Q*H_net*eta)/10^6 (MW), Pelton Impulse Nozzle Spouting Velocity Cv*SQRT(2*g*H_net), and Optimal Bucket Pitch Speed.

Read the guide →
Engineering & Science

Hydrogenic Bohr Radius (an) & Fine-Structure Relativistic Velocity (vn/c)

Calculate the quantized orbital radius a_n = a_0 * (n^2 / Z) in picometers (CODATA a_0 = 52.9177 pm) and relativistic electron velocity ratio v_n / c = (Z * alpha) / n (fine-structure constant alpha = 1 / 137.036) for hydrogen-like ions.

Read the guide →
Controlled-Environment Agriculture (CEA), Hydroponics & Venturi/Dosatron Fertigation

Hydroponic Fertigation Injector Stock Tank & ppm Formula

Calculate Dripper-Line Fertilizer Salt Concentration (mg/L), Concentrated Stock-Tank Salt Concentration (g/L), Total Dry Fertilizer Bag Charge (kg), and Cold-Water Solubility Utilization (%).

Read the guide →
Precision Machine-Tool Tables & Observatory Azimuth Bearings, Hydrostatic Thrust Pad

Hydrostatic Circular Step Thrust-Pad Load & h³ Flow Formula

Calculate Exact Radial-Log Pad Load Capacity W (kN), Viscous Sill Leakage Flow Q (L/min), Hydraulic Sill Pumping Power (W and kW), and Cubic Film-Gap Sensitivity.

Read the guide →
Well Control & Blowout Prevention (IWCF / IADC WellSharp), Casing-Shoe MAASP & Kick Tolerance

Hydrostatic Pressure Differences and the Limits of Well-Control Calculations

Explore a simple static hydrostatic-pressure difference while understanding why it does not determine safe kick tolerance or an operational well-control limit.

Read the guide →
Catalytic Reactor Engineering, ULSD Hydrotreating & SAF Hydroprocessing

Hydrotreater LHSV, WHSV & Catalyst Bed Inventory Formula

Calculate Required Catalyst Bed Volume V_cat (m³) from LHSV, Loaded CoMo/NiMo Catalyst Mass (metric tons), True Weight Hourly Space Velocity WHSV (hr^-1), and Apparent Space Time (min).

Read the guide →
Statistical & Engineering

Hyperbolic COSH, SINH & TANH via EXP: Overhead Cable Catenary Sag & Length

Evaluate exact hyperbolic cosine COSH(u) = (e^u + e^-u)/2 and hyperbolic sine SINH(u) = (e^u - e^-u)/2 using EXP to compute transmission-line catenary sag and true suspended arc length.

Read the guide →
Engineering & Scientific

Hyperbolic Secant Envelope & Complex Hyperbolic Reciprocals (SECH, IMSECH & IMCSCH)

Model optical soliton pulse envelopes sech^2(t/tau) with SECH(x) = 2 / (EXP(x) + EXP(-x)) and compute complex hyperbolic secant and cosecant components (IMSECH & IMCSCH).

Read the guide →
Statistical

Hypergeometric probability formula: exact sampling without replacement via FACT

Calculate exact finite-lot inspection probabilities P(X = k) = C(K, k) * C(N - K, n - k) / C(N, n) and finite-population variance using FACT and LET.

Read the guide →
Lookup & Reference

HYPERLINK function: build dynamic clickable URLs and sheet jumps from cell values

Combine base URLs with ticket IDs or tracking numbers using HYPERLINK and display concise friendly labels.

Read the guide →
Digital Infrastructure REITs, Data Centers & Project Underwriting

Hyperscale Data-Center REIT $/kW Lease & PUE NOI Formula

Calculate Wholesale Data-Center REIT Annual Base $/kW Lease Revenue ($M), Metered PUE Power Pass-Through Revenue ($M), Facility Cash NOI ($M), and Development Yield-on-Cost (%).

Read the guide →
Frozen Dairy & Confectionery Engineering, Ice Cream Overrun % & FDA 21 CFR 135.110

Ice Cream Overrun %, Air Fraction & Gallon Weight Formula

Calculate Gravimetric Overrun (%), Dispersed Air Volume Fraction (%), Finished Gallon Net Weight (lb/gal vs FDA 4.50 lb/gal Minimum), and Continuous Freezer Volumetric Yield (L/h).

Read the guide →
Health Economics & Clinical Decision Analysis

ICER & Net Monetary Benefit (NMB) QALY Formula

Calculate the Incremental Cost-Effectiveness Ratio (C_1 - C_0)/(E_1 - E_0), Net Monetary Benefit lambda*Delta_E - Delta_C, and expose the South-West quadrant ICER sign trap.

Read the guide →
Healthcare & Clinical

ICH Score: Intracerebral Hemorrhage Severity Points

Calculate the five-component Hemphill ICH severity score and understand why historical cohort outcomes are not individual predictions.

Read the guide →
Healthcare & Clinical Calculators

ICIQ-UI SF: Adding Three Already-Scored Items

Practice adding three hypothetical ICIQ-UI SF component scores and understand the study-specific severity bands and questionnaire permissions.

Read the guide →
Engineering

Ideal AC transformer: voltage ratio and reflected resistive load

Calculate step-down / step-up transformer turns ratio a = Np / Ns, secondary voltage Vs = Vp / a, current Is = Vs / ZL, and reflected primary impedance Zp = a^2 * ZL.

Read the guide →
Engineering

Ideal Buck, Boost and Inverting Buck-Boost Calculations

Compare ideal steady-state CCM voltage ratios and calculate boost inductor current ripple with explicit units and input checks.

Read the guide →
Engineering

Ideal constant-specific-heat Brayton efficiency and compressor temperature

Explore the ideal Brayton pressure-ratio expression and isentropic compression temperature, with explicit thermodynamic assumptions.

Read the guide →
Engineering

Ideal Gas Law (PV = nRT) and Combined Gas Law formulas

Solve pressure, volume, or moles with PV = nRT and scale compressed-gas states via (P1*V1)/T1 = (P2*V2)/T2 using mandatory Kelvin temperatures.

Read the guide →