Learn one useful thing today.
Drilling Kill Mud Weight, ICP & FCP Well-Control Formula
Calculate True-Vertical-Depth Hydrostatic Mud Pressure 0.052 * MW * TVD, Required Kill Mud Weight KMW = MW_orig + SIDPP / (0.052 * TVD), Initial Circulating Pressure (ICP), and Final Circulating Pressure (FCP).
Read the guide →Dynamic arraysDROP function: strip opening balances, headers, or total rows dynamically
Exclude N rows or columns from the start or end of an imported range with DROP so summary rows never double-count.
Read the guide →Engineering & ScienceDrude Free-Electron Metal Conductivity & UV Plasma Frequency Formula
Calculate DC electrical conductivity sigma = (n * e^2 * tau) / m_e in MS/m and plasmon energy hbar * omega_p (in eV) explaining both metal Ohm's Law and why metals turn transparent in the deep ultraviolet.
Read the guide →Business & OperationsDrum-Buffer-Rope (DBR) Buffer Penetration % & TOC Green/Yellow/Red Expedite Priority
Calculate Theory of Constraints (TOC) time-buffer consumption percentage 100 * (Buffer_Hours - Remaining_Hours) / Buffer_Hours and classify work orders into Region I Green (<33.3%), Region II Yellow (33.3%–66.7%), or Region III Red (>66.7%) expedite zones.
Read the guide →MathDSUM function: sum database columns using multi-row AND/OR criteria ranges
Total a named column in a structured table using DSUM when filter rules combine AND columns across OR criteria rows.
Read the guide →Health & FitnessDu Bois and Haycock Body Surface Area: A Spreadsheet Comparison
Compare two empirical body-surface-area estimates using fictional weight and height inputs. This example is not a medication-dose calculator.
Read the guide →Healthcare & ClinicalDuke Treadmill Score: Bruce Protocol Spreadsheet Example
Use fictional exercise time, ST-segment deviation and an angina index to explore the Duke treadmill score arithmetic, with complete input checks.
Read the guide →Labor Economics & Demographic StatisticsDuncan Dissimilarity Index & Karmel-MacLachlan Formula
Calculate the Duncan Index of Dissimilarity D = 0.5 * SUM(|a_k/A - b_k/B|) and Karmel-MacLachlan replacement-preserving index I_p = 2 * p * (1 - p) * D.
Read the guide →Rotordynamics, Turbomachinery Shafts & Lateral Whirling ResonanceDunkerley Shaft Critical Whirling Speed & Margin Formula
Calculate Dunkerley Cumulative Static Deflection Equivalent (mm), Conservative First Lateral Critical Speed N_cr (RPM), Operating Speed Separation Margin (%), and Sub/Supercritical Regime.
Read the guide →FinancialDuPont ROE analysis formula: Margin x Asset Turnover x Financial Leverage
Break Return on Equity (NetIncome / Equity) into 3 diagnostic levers—Net Profit Margin, Total Asset Turnover, and Equity Multiplier—to see what drives ROE.
Read the guide →ScienceDupuit-Forchheimer Unconfined Aquifer Seepage & Parabolic Water Table
Calculate steady unconfined groundwater seepage per unit width q' = K * (h1^2 - h2^2) / (2 * L) (m^2/day) and parabolic phreatic water-table elevation h(x) between two canals or earthen dam faces.
Read the guide →Fixed Income & RatesDuration-Neutral Barbell-Bullet Butterfly Weights and Convexity Pickup
Construct cash-and-duration-neutral 2s5s10s fixed-income butterflies in Excel and Arte Sheets and quantify exact barbell convexity pickup over a bullet bond.
Read the guide →Econometrics & Causal InferenceDurbin-Wu-Hausman Control-Function Residual Endogeneity Test
Test regressor endogeneity in Excel and Arte Sheets by augmenting the structural equation with first-stage IV residuals v_hat = X - X_hat and computing the exact DWH t- and F-statistics.
Read the guide →Clinical Medicine & PhysiologyDurnin–Womersley Skinfold Equations: A Body Density Example
Explore how the 1974 Durnin–Womersley four-site equations estimate body density, followed by a separate Siri body-fat calculation, using an adult spreadsheet example.
Read the guide →Lookup & ReferenceDynamic Category and Monthly Totals With Percent-of-Total (GROUPBY, PIVOTBY & PERCENTOF Patterns)
Build live category summaries, category-by-month cross-tab totals, and share-of-grand-total ratios using UNIQUE, SORT, SUMIF, and SUMIFS.
Read the guide →Charts & Visual DataDynamic Chart Title Formula: Formatted KPI Headline & Signed YoY Delta Banner
Build a self-updating executive Chart Title cell using TEXT formatting and directional + / - variance logic so chart headlines never show stale numbers or raw floating-point decimals.
Read the guide →Lookup, Reference & Dynamic ArraysDynamic Line Chart Ignore Empty Future Months: NA() Formula vs. Zero-Cliff Drop
Stop YTD actuals line charts from plunging vertically to 0 in unrecorded future months by returning NA() instead of "" or 0—while using COUNT(B2:B7) to aggregate completed months cleanly.
Read the guide →Date & TimeDynamic monthly calendar grid formula (SEQUENCE + WEEKDAY)
Spill a complete 6-week x 7-day monthly calendar grid for any Year and Month (Sunday-start or Monday-start) with one SEQUENCE formula.
Read the guide →Lookup & ReferenceDynamic range between two matches: sum or extract rows between markers
Locate any Start milestone and End milestone with XMATCH and slice all rows inclusively between them using TAKE(DROP(...)).
Read the guide →StatisticalDynamic two-way average by row category and column header (CHOOSECOLS + FILTER)
Average rows matching a region or department while dynamically switching which quarter or metric column is aggregated via XMATCH + CHOOSECOLS.
Read the guide →Lookup & ReferenceDynamic two-way sum and average: aggregate a chosen column by row criteria
Select a monthly metric column with XLOOKUP, filter its rows, and calculate a dynamic sum or average.
Read the guide →FinancialEarned Value Management (EVM) formulas: EV, PV, CPI, SPI, and EAC
Distinguish true physical progress from raw budget burn using Cost Performance Index (CPI = EV / AC), Schedule Performance Index (SPI = EV / PV), and EAC.
Read the guide →Project Controls & Earned Value ManagementEarned Value TCPI & Lipke Earned Schedule Formula
Audit unrecoverable cost overruns via To-Complete Performance Index TCPI = (BAC - EV) / (BAC - AC) and fix late-project SPI = 1.00 convergence distortion with Walt Lipke’s Earned Schedule SPI(t) = ES / AT.
Read the guide →International Trade & Quantitative MacroeconomicsEaton-Kortum Trade Share & ACR Gains-from-Trade Formula
Compute multi-country Eaton-Kortum Fréchet import shares pi_ni = T_i*(c_i*d_ni)^(-theta) / Phi_n and Arkolakis-Costinot-Rodríguez-Clare welfare gain pi_nn^(-1/theta).
Read the guide →Structural Mechanics, Column Stability & Non-Linear P-Delta BendingEccentric Column Secant Formula Max Compressive Stress
Calculate Eccentric Column Direct Axial Stress P/A (MPa), Stability Secant Angle (rad), Exact Secant Maximum Fiber Compressive Stress (MPa), and Naive Linear Stress Without P-Delta (MPa).
Read the guide →Chemical, Process & Catalysis EngineeringEckert GPDC Packed-Column Flooding Formula: Flow Parameter F_LV & Tower Diameter
Size random and structured packed absorption, stripping, and distillation towers using Sherwood-Eckert Generalized Pressure Drop Correlation (GPDC) Flow Parameter F_LV = (L / G) * SQRT(rho_G / rho_L), Flooding Gas Velocity u_flood, and Column Diameter.
Read the guide →OperationsEconomic Production Quantity (EPQ) Finite-Rate Lot-Size Formula
Calculate an idealized finite-rate production lot, peak inventory and annual setup-plus-holding cost, deriving daily demand from annual demand on a consistent operating-day basis.
Read the guide →FinanceEconomic Value Added (EVA), NOPAT & ROIC vs WACC Economic Spread
Calculate Net Operating Profit After Tax NOPAT = EBIT * (1 - Tax), Economic Value Added EVA = NOPAT - (Invested_Capital * WACC), and the ROIC - WACC value-creation spread.
Read the guide →Dates and reportingEDATE function: add calendar months and handle month-end clipping
Schedule monthly equipment checks from a start date with EDATE, and see why anchoring offsets to the original start date preserves the 31st after February.
Read the guide →ScienceEddington Luminosity Limit & Black-Hole Accretion Rate Formula
Compute a hydrogen electron-scattering Eddington luminosity and the associated rest-mass inflow at a chosen radiative efficiency, using consistent luminosity units and retaining very small nonzero rates.
Read the guide →Powertrain Test Cells & Driveline Braking, Eddy-Current Dynamometer & Retarder PhysicsEddy-Current Dynamometer Torque, Critical RPM & Cooling
Calculate Speed Ratio (N / Ncrit), Kloss-Type Skin-Effect Braking Torque (N·m), Absorbed Rotor Thermal Power (kW), and Required Cooling-Water Flow at 25 K Rise (L/min).
Read the guide →Power Electronics, Ultracapacitor Energy Storage & Pulse-Power SizingEDLC Supercapacitor 75% Usable Energy & ESR Drop Formula
Calculate Electric Double-Layer Supercapacitor (EDLC) Usable Extractable Energy (Wh) Between V_max and Converter Cutoff V_min, Usable Energy Fraction (75% at 0.5*V_max), Instantaneous ESR Voltage Sag (V), and Matched-Impedance Peak Power (kW).
Read the guide →Statistical & Clinical AnalysisEdmonton Frail Scale: Background and Permission to Use
An overview of the Edmonton Frail Scale, its assessment context and the developer’s permission and licensing information.
Read the guide →FinancialEFFECT function: convert stated APR into effective annual interest rate (APY)
Compare loan or savings offers with different compounding frequencies on an apples-to-apples annual basis using EFFECT.
Read the guide →FinanceEffective Duration & Key-Rate Duration (Callable Bond Finite Difference)
Calculate effective duration, convexity and individual key-rate sensitivities from supplied repriced bond values, with a reproducible three-tenor example and input validation.
Read the guide →Lookup & ReferenceEffective-Date Rate & Price Lookup by Transaction Date (XLOOKUP Mode -1 & VLOOKUP)
Resolve the historical price, billing rate, or FX rate in effect on any transaction date using XLOOKUP with match_mode = -1 (exact or next earlier effective date) while guarding dates prior to contract inception.
Read the guide →Statistical & Clinical AnalysisEgger’s Linear Regression Test: Funnel Plot Asymmetry & Small-Study Publication Bias
Detect small-study publication bias in meta-analysis by regressing Standardized Normal Deviate SND_i = θ_i / SE_i on Precision P_i = 1 / SE_i via INTERCEPT and SLOPE.
Read the guide →Consumer Panel Analytics & Brand Growth ScienceEhrenberg NBD Brand Penetration & Double Jeopardy Formula
Calculate Andrew Ehrenberg’s Negative Binomial Distribution (NBD) Non-Buyer Share P_0 = (1 + m/k)^(-k), Household Penetration b = 1 - P_0, Average Purchase Frequency per Buyer w = m/b, and Duplication of Purchase D*b_Y.
Read the guide →Engineering & ScienceEinstein Quantum Solid Molar Heat Capacity (CV) vs. Dulong-Petit 3R Limit
Calculate quantized lattice molar heat capacity C_V = 3 * R * (theta_E / T)^2 * EXP(theta_E / T) / (EXP(theta_E / T) - 1)^2 (J/(mol*K)) and % of the classical Dulong-Petit 3R = 24.943 J/(mol*K) limit.
Read the guide →Civil, Structural & Geotechnical EngineeringEinstein-Brown Bedload Transport Formula: Stochastic Low-Shear & 40 * theta^3 Law
Calculate river and coastal bedload transport intensity Phi across stochastic incipient saltation (theta < 0.18) and sheet-flow high-shear transport (Phi = 40 * K_R * theta^3) using Hans Albert Einstein (1942) and Carl B. Brown (1950).
Read the guide →Healthcare & Clinical CalculationsEl-Ganzouri Airway Research: Seven Components and a Point Sum
Explore a seven-component airway research index and practice adding already-assigned integer points.
Read the guide →Fluid-Power Sealing, Parker / AS568 Elastomer O-Ring Glands, Squeeze & ExtrusionElastomer O-Ring Squeeze % & Gland Fill Swell Formula
Calculate Linear Diametral Interference Squeeze (mm), Percentage Cross-Sectional Squeeze (%), Swollen-Elastomer Rectangular Gland Fill (%), and Parker Static Gland Compliance.
Read the guide →EngineeringElectricity kWh and utility cost calculator formula (Watts to $ bill)
Estimate energy use and the energy component of a bill from average input power, operating hours and a flat tariff.
Read the guide →Turbine-Blade Superalloy Non-Traditional Machining, ECM Faraday Equilibrium Gap & Joule BoilElectrochemical Machining (ECM) Gap & Brine Boiling Formula
Calculate Anodic Dissolution Current Density J (A/cm²), Self-Regulating Equilibrium Inter-Electrode Gap heq (mm), Total Rectifier Current (A), and Brine Joule Temperature Rise (°C).
Read the guide →Engineering & ScienceElectron-Positron Pair & Triplet Production Gamma Threshold Formula
Evaluate gamma-ray nuclear pair-production threshold (2 * m_e * c^2 = 1.022 MeV), atomic-electron triplet-production threshold (4 * m_e * c^2 = 2.044 MeV), and total lepton kinetic energy K_e- + K_e+ = E_gamma - 1.022 MeV.
Read the guide →Nanomaterials, HEPA Filtration & Tissue Scaffolds, Taylor-Cone ElectrospinningElectrospinning Taylor-Cone Critical Voltage & GSM Formula
Calculate G. I. Taylor Critical Cone-Jet Onset Voltage Vc (kV), Mean Inter-Electrode Field Vc/H (kV/cm), Dry Nanofiber Production Rate (g/h), and Nonwoven Mat GSM (g/m²).
Read the guide →Chemical, Process & Catalysis EngineeringEley-Rideal Catalytic Rate Law Formula & Apparent Reaction Order Diagnostic
Compute Daniel Eley and Eric Rideal’s (1940) gas-surface collision rate r_ER = k_ER * K_A * P_A * P_B / (1 + K_A * P_A) and Apparent Reaction Order n_app,A = 1 / (1 + K_A * P_A) to distinguish Eley-Rideal from Langmuir-Hinshelwood kinetics.
Read the guide →Healthcare & Clinical CalculatorsElixhauser Comorbidity Research: Weighted Subtotal in Excel
Learn the purpose and limitations of the van Walraven administrative-data score and practice SUMPRODUCT using six illustrative weights.
Read the guide →VLSI Physical Design & Semiconductor InterconnectsElmore RC Wire Delay & Repeater Insertion Formula
Calculate Distributed-Line Elmore RC Time Constant tau_D, 50% Propagation Delay t_p50 = 0.69 * tau_D, Naive Lumped-RC Overprediction Error, and Bakoglu Optimal CMOS Repeater Count.
Read the guide →Operations, Logistics & EngineeringElovich (Roginsky-Zeldovich) Chemisorption Kinetics Formula: Uptake q(t) & Rate Decay
Model activated chemisorption on energetically heterogeneous catalysts, biochars, and soils using the integrated Elovich kinetic equation q(t) = (1 / beta) * LN(1 + alpha * beta * t) and instantaneous rate dq/dt = alpha * EXP(-beta * q).
Read the guide →