Learn one useful thing today.
1-2 Shell-and-Tube LMTD Correction Factor (Ft) Formula
Calculate Heat-Capacity Ratio R, Cold-Side Thermal Effectiveness P, Exact Bowman-Mueller-Nagle 1-Shell / 2-Tube-Pass LMTD Correction Factor F_t, and Effective Mean Temperature Difference (°C).
Read the guide →Math & Statistical100% Stacked Column & Bar Mix Matrix Formula: Mixed-Reference Period Shares (B$2:B$4)
Normalize multi-quarter revenue or headcount tables into a 100% composition matrix using column-row-locked mixed references ROUND(B2 / SUM(B$2:B$4) * 100, 2) and measure mix shift percentage-point changes.
Read the guide →Financial2/10 Net 30 formula: implied annualized cost of skipping trade discounts
Annualize the illustrative cost of foregoing an early-payment discount using simple and compounded conventions.
Read the guide →Statistical & Clinical Analysis2012 SLICC Lupus Classification: A Logic Exercise
Explore the two branches of the 2012 SLICC research classification rule using fictional counts and clearly defined flags.
Read the guide →Healthcare & Clinical Calculators2019 EULAR/ACR Lupus Criteria: An Educational Addition Example
Add illustrative domain subtotals while learning the limits of the 2019 SLE research classification criteria; the worksheet does not diagnose or classify a patient.
Read the guide →Health & Fitness2021 CKD-EPI Creatinine eGFR and GFR Categories in Excel
Practice the adult 2021 race-free creatinine equation, validate units and inputs, and classify the unrounded estimate without treating it as a CKD diagnosis.
Read the guide →Lookup & Reference2D Matrix Dynamic Row Sum, Column Sum & Two-Way Lookup (SUMPRODUCT)
Sum an entire dynamically matched row, sum an entire dynamically matched column, or retrieve a two-way matrix intersection across a 2D table using boolean-broadcast SUMPRODUCT.
Read the guide →Statistical Analysis2x2 Association Coefficients: Pearson Phi, Yule’s Q & Yule’s Y Colligation
Measure binary 2x2 contingency association on [-1, +1] with Pearson’s Phi coefficient and marginal-prevalence-invariant Yule’s Q and Yule’s Y formulas.
Read the guide →Lookup & Reference3D references: sum the same cell across consecutive monthly worksheets
Consolidate identical template cells across tab ranges like Jan:Dec!B5 using 3D worksheet references.
Read the guide →Math & Trigonometry3x3 Matrix Determinant and Cramer's Rule Linear System Solver (MDETERM & MINVERSE)
Calculate exact 2x2 and 3x3 matrix determinants, test for singular zero-determinant systems, and solve simultaneous linear equations A*x = b via cofactor expansion.
Read the guide →Healthcare & Clinical Calculations4Ts Score: An Educational Four-Domain Point Sum
Add four illustrative 4Ts domain values while learning the limits of a numerical score; the worksheet does not diagnose HIT or direct treatment.
Read the guide →Finance5-Factor DuPont ROE: Tax Burden, Interest Burden & EBIT Margin
Decompose ROE into five accounting ratios, reconcile their unrounded product to net income over average equity, and distinguish undefined factors from a still-defined direct ROE.
Read the guide →Lookup & Reference5x5 risk matrix formula: score Likelihood x Impact and assign severity
Convert qualitative Likelihood and Impact ratings into 1–5 scores with XMATCH, compute the 1–25 risk score, and classify Low/Medium/High/Critical.
Read the guide →Lookup & Reference5x5 Risk Score Buckets & Step-Based Tier Lookup (Sorted INDEX & MATCH)
Compute Likelihood x Impact risk scores (1–25) and map them into editable Low / Moderate / High / Critical governance tiers using sorted step-threshold lookup.
Read the guide →Clinical Medicine & PhysiologyA Body Shape Index (ABSI): Spreadsheet Formula and Reference Scores
Calculate the ABSI waist–BMI–height index and illustrate standardization using explicitly hypothetical reference values.
Read the guide →StatisticalA/B test conversion lift and statistical significance (two-proportion Z-score)
Calculate relative conversion lift, pooled standard error, and two-proportion Z-score to test 95% statistical significance.
Read the guide →Biostatistics & Survival AnalysisAalen-Johansen Competing-Risks Cumulative Incidence vs Naive 1 - KM
Calculate cause-specific Cumulative Incidence CIF_1(t) = SUM(S_all(tj-1) * d1j / n_j) and prove why censoring competing deaths inflates naive 1 - KM above 100% total risk.
Read the guide →Public Economics & Actuarial PensionsAaron-Samuelson PAYGO vs Funded Pension Formula
Compare Pay-As-You-Go social security’s Samuelson biological rate of return g_bio = (1 + n)*(1 + g_w) - 1 against funded capital return r and compute equilibrium replacement rates.
Read the guide →Civil, Structural & Geotechnical EngineeringAASHTO 1993 Flexible Pavement Structural Number (SN) Formula: Layer & Drainage Design
Calculate composite asphalt highway Structural Number SN = a_1*D_1 + a_2*D_2*m_2 + a_3*D_3*m_3 and minimum required layer thicknesses using the AASHTO (1993) Guide for Design of Pavement Structures.
Read the guide →Civil & Transportation Engineering, Highway Geometric Design (AASHTO)AASHTO Curve Superelevation Radius & Stopping Sight Distance
Calculate AASHTO Green Book Minimum Horizontal Curve Radius V^2 / (127*(e + fs)), Perception-Reaction Distance 0.278*V*tr, Grade-Adjusted Braking Distance, and Total Stopping Sight Distance (SSD).
Read the guide →Causal Inference & Policy EvaluationAbadie Synthetic Control Convex Weights and Post/Pre RMSPE Ratio
Audit convex donor-pool weights (w_j >= 0, SUM w_j = 1), pre-intervention fit, and Abadie’s post-to-pre RMSPE permutation test ratio in Excel and Arte Sheets.
Read the guide →TextAbbreviate names into initials: 1-, 2-, and 3-word names
Extract uppercase initials from mononyms, two-part names, and full middle-name strings using TRIM, LEFT, and TEXTAFTER.
Read the guide →Lookup & ReferenceAbbreviate state or country names to 2-letter postal codes (mixed-input safe)
Standardize columns that mix full state names ("California", "New York") and 2-letter abbreviations ("tx", "CA") into clean uppercase postal codes.
Read the guide →Healthcare & ClinicalAbbreviated Burn Severity Index: A Historical Spreadsheet Example
Reproduce the arithmetic of the historical five-component ABSI with explicitly validated illustrative inputs; it is not a current patient prognosis.
Read the guide →StatisticalABC–XYZ inventory example: cumulative spend share and demand variation
Combine a chosen cumulative-spend classification with population CV of four demand observations. Thresholds are example policy choices, not universal stocking rules.
Read the guide →Healthcare & ClinicalABCD2 TIA Score: An Educational Spreadsheet Example
Reproduce the point arithmetic of the ABCD2 score for an illustrative example, with input checks and important limits on its use.
Read the guide →Quantitative Finance & Market MicrostructureAbdi-Ranaldo Close-High-Low (CHL) Bid-Ask Spread Formula
Estimate effective proportional bid-ask spreads from daily OHLC bars using Abdi and Ranaldo’s (2017) two-day zero-floored formula s_t = 2 * SQRT(MAX(0, (c_t - eta_t) * (c_t - etat+1))).
Read the guide →Commercial Credit, Working Capital & Asset-Based LendingABL Borrowing Base, Dilution Reserve & Availability Formula
Calculate Asset-Based Lending (ABL) Effective AR Advance Rate 0.85 - MAX(0, 2*(Dilution - 0.05)), Capped Borrowing Base MIN(Commitment, AR_Adv + 0.85*Inventory_NOLV), Excess Availability, and Springing Cash-Dominion Covenant Gate.
Read the guide →Non-Traditional Machining, Cold-Cutting Abrasive Waterjet (AWJ) & UHP Intensifier PumpsAbrasive Waterjet (AWJ) Jet Velocity & Pump Power Formula
Calculate Supersonic Ruby/Diamond Orifice Waterjet Velocity (m/s), Vena-Contracta Orifice Water Flow (L/min), Hydraulic Jet Power (kW), and Garnet-to-Water Mass Loading Ratio.
Read the guide →MathABS function: measure budget variance distance and tolerance bands
Strip minus signs with ABS so over-budget and under-budget variances do not cancel each other out and symmetric tolerance checks stay concise.
Read the guide →Cell referencesAbsolute and relative cell references: lock constants with $ when copying formulas
Copied formulas adjust row and column coordinates automatically unless you lock them with dollar signs. Calculate wholesale pack prices from one shared pack size and handling fee without breaking rows below.
Read the guide →HealthcareAbsolute Neutrophil Count (ANC) & Reticulocyte Production Index (RPI)
Practice ANC, corrected reticulocyte percentage and RPI calculations with explicit units, a configurable reference hematocrit and a supplied maturation factor.
Read the guide →EngineeringAC & RF Skin Depth formula: delta = SQRT(rho / (pi * f * mu0 * mur))
Estimate skin depth for a good conductor with positive resistivity and a real permeability, keeping the DC case separate.
Read the guide →Health Insurance Regulation & Actuarial FilingACA Medical Loss Ratio (MLR) & Rebate Formula
Calculate Statutory Health Insurer Adjusted Premium Denominator, HCQI-Adjusted Medical Loss Ratio (Claims + Quality_Improvement) / (Premiums - Regulatory_Assessments), and Mandatory Policyholder Rebate.
Read the guide →Spreadsheet Governance & Collaborative AI WorkflowsAcademy MCP Lesson Gate, Locale & Progress Audit Formula
Audit academy:read lesson access across free vs Pro-gated catalog metadata, transparent locale fallback without fabricated official translations, and read-only server-verified progress boundaries.
Read the guide →LogicalAccounts receivable aging buckets: classify invoices into Current, 1-30, 31-60, 61-90, and 90+
Assign standard AR aging bands with ordered IFS thresholds and summarize dollar exposure per bucket with SUMIF.
Read the guide →FinancialACCRINT and ACCRINTM: calculate accrued interest on coupon and at-maturity bonds
Choose ACCRINT for periodic-coupon bonds and ACCRINTM for securities that pay all interest at maturity.
Read the guide →Labor Economics & Human CapitalAcemoglu-Pischke Firm-Sponsored General Training Formula
Calculate Daron Acemoglu and Jorn-Steffen Pischke’s (1998, 1999) optimal firm-paid general training intensity tau* = (theta_comp * p_skill) / c_tr under compressed wage structures versus Gary Becker’s (1964) zero-sponsorship benchmark.
Read the guide →Structural Engineering, ACI 318 Reinforced Concrete & Flexural DesignACI 318 Whitney Stress Block Concrete Beam Moment Formula
Calculate Whitney Compression Block Depth a (mm), Net Tensile Rebar Strain epsilon_t, Nominal Flexural Capacity M_n (kN·m), and Tension-Controlled Design Moment phi*M_n (kN·m).
Read the guide →Civil, Structural & Geotechnical EngineeringAckers-White (1973) Sediment Transport Formula: Mobility Number F_gr & Concentration
Calculate Peter Ackers and W. Rodney White’s (1973, HR Wallingford / ASCE) Transition-Exponent Sediment Mobility Number F_gr and Mass Flux Concentration X_ppm across fine transitional sand to coarse gravel.
Read the guide →Mechanical Actuators, Acme Lead Screws & Lifting JacksAcme Power Screw Raising/Lowering Torque & Efficiency Formula
Calculate Acme Thread Raising Torque T_R (N·m) including Thrust Collar Friction, Load-Lowering Torque T_L (N·m), Overall Screw+Collar Efficiency (%), and Overhauling Check.
Read the guide →MathACOS function: find roof or vector angles from adjacent-over-hypotenuse ratios
Calculate arccosine angles in [0, 180] degrees using DEGREES(ACOS(ratio)), and guard ratios outside [-1, 1].
Read the guide →MathACOT and ACOTH: calculate inverse cotangent and inverse hyperbolic cotangent
Compute principal inverse cotangent angles in (0, pi) with ACOT and inverse hyperbolic cotangents for |x| > 1 with ACOTH.
Read the guide →Architectural & Noise-Control Acoustics, Sound Isolation & PartitionsAcoustic Mass Law Wall Transmission Loss & Coincidence Formula
Calculate Partition Surface Mass Density m_s (kg/m²), Field-Incidence Mass-Law Sound Transmission Loss TL (dB), Critical Bending-Wave Coincidence Frequency f_c (Hz), and STC Speech-Band Warning.
Read the guide →Engineering & ScienceAcousto-Optic Modulator (AOM) Acoustic Wavelength & Bragg Deflection Angle
Calculate the ultrasonic grating period Lambda = v_a / f_RF (um) and external Bragg angle theta_B ~ (lambda_0 * f_RF) / (2 * v_a) (milliradians) for TeO2 and fused-silica laser acousto-optic deflectors.
Read the guide →Clinical Medicine & PhysiologyACR TI-RADS: An Educational Example of Adding Feature Points
Practice adding invented thyroid ultrasound feature points, including the cystic or spongiform special case; this worksheet does not make clinical recommendations.
Read the guide →Biological Wastewater Treatment, Nitrification & Sludge WastingActivated-Sludge SRT (MCRT), F/M Ratio & WAS Flow Formula
Calculate Aeration Bioreactor Biomass Inventory (kg MLVSS), Food-to-Microorganism F/M Ratio (d^-1), Required Daily Waste Activated Sludge Mass (kg/d), and WAS Pump Flow (m³/d).
Read the guide →Hydronic HVAC Systems, DOAS + Active Chilled Beams & Sensible Cooling EngineeringActive Chilled Beam Induction Ratio & Cooling Formula
Calculate Induced Room Secondary Airflow Q_sec (L/s), Primary DOAS Ventilation Sensible Cooling (W), Secondary Hydronic Coil Sensible Cooling (W), and Total Chilled-Beam Sensible Capacity (W).
Read the guide →Actuarial Life Contingencies & Insurance MathematicsActuarial Commutation Dx, Nx, Mx & Life Premium Formula
Calculate Life Annuity-Due a_ddot_x = N_x / D_x, Death-Benefit Commutation M_x = D_x - (i / (1 + i)) * N_x, Whole-Life Net Single Premium Face * (M_x / D_x), and Net Level Annual Premium Face * (M_x / N_x).
Read the guide →FinancialActuarial Pure Premium (Frequency x Severity) & Credibility Factor Z
Explore observed loss cost, a simplified variable-load calculation and a separate limited-fluctuation claim-frequency credibility illustration.
Read the guide →