Learn one useful thing today.
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 & ClinicalHOSPITAL 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 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 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 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 →Mechanical MEP, Psychrometrics & Data-Center CoolingHVAC 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 EngineeringHveem 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 & EngineeringHvorslev 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 SizingHydraulic 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 ValvesHydraulic 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-ForceHydrocyclone 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 EnergyHydroelectric 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 & ScienceHydrogenic 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 FertigationHydroponic 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 PadHydrostatic 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 ToleranceHydrostatic 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 HydroprocessingHydrotreater 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 & EngineeringHyperbolic 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 & ScientificHyperbolic 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 →StatisticalHypergeometric 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 & ReferenceHYPERLINK 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 UnderwritingHyperscale 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.110Ice 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 AnalysisICER & 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 & ClinicalICH 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 CalculatorsICIQ-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 →EngineeringIdeal 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 →EngineeringIdeal 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 →EngineeringIdeal 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 →EngineeringIdeal 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 →