Learn one useful thing today.
Email Deliverability, CTOR vs CTR & List Churn Formula
Calculate Delivered Rate, Open Rate on Delivered, Click-to-Open Rate (CTOR = Unique_Clicks / Unique_Opens) vs Unique CTR, Opt-Out Rate, and Net Subscriber List Growth.
Read the guide →HR & Payroll AnalyticsEmployee Salary Band Lookup, Compa-Ratio & Pay-Range Penetration Formulas
Join employee grades to compensation band minimums, midpoints, and maximums with XLOOKUP to compute Compa-Ratio, Range Penetration %, and Green-Circle / Red-Circle outlier flags.
Read the guide →ISO 14644 Cleanrooms & Aseptic Pharma Fill-Finish, EN 1822 HEPA/ULPA MPPS & Laminar FlowEN 1822 HEPA Filter MPPS Penetration, LRV & Hood CFM
Calculate Most Penetrating Particle Size (MPPS) Penetration (%), Filter Log-Reduction Value LRV, ISO Class 5 Unidirectional Hood Airflow (m³/h), and Fan Supply (CFM).
Read the guide →Civil, Structural & Geotechnical EngineeringEngelund-Hansen (1967) Total Alluvial Sand-Bed Sediment Transport Formula
Calculate total bed-material sediment load (bedload + suspended sand across dunes and upper-plane beds) via Frank Engelund and Eggert Hansen’s (1967, DTU) energy-balance law f_EH * Phi = 0.1 * theta^2.5 (Phi = 0.05 * (V^2 / (g * R_h * S)) * theta^2.5).
Read the guide →Statistical & Clinical AnalysisEngland–Fraser and Shine–Lal Indices: Formulas and Limits
Calculate two historical red-cell discriminants with correct units and learn why their numerical values do not diagnose the cause of anemia.
Read the guide →FinancialEnterprise value bridge, EBITDA multiple and a simplified Tobin’s Q proxy
Calculate a simplified enterprise-to-equity bridge and compare total claim value with estimated replacement assets, with explicit units and assumptions.
Read the guide →Dates and reportingEOMONTH function: find the last day of any reporting month
Calculate month-end closing dates from any mid-month transaction date, handling 28-day and 29-day Februaries as well as December-to-January year rollovers.
Read the guide →Operations & Supply ChainEOQ with Planned Backorders: Optimal Lot Size, Peak On-Hand & Max Shortage
Extend classical Wilson EOQ when customers tolerate backorders at finite annual shortage cost b, computing critical fill fraction b/(h+b), expanded lot size Q*, peak inventory, and annual cost savings.
Read the guide →Healthcare & Clinical CalculationsEPDS Screening: Checked Item Scoring and Safety Follow-up
Learn how to add pre-scored EPDS items while keeping a positive self-harm response visible even when other responses are missing.
Read the guide →Mechanical Machine Design, Gearboxes & EV Powertrain KinematicsEpicyclic Planetary Gear Willis Speed Ratio & Torque Formula
Calculate Coaxial Mesh Planet Tooth Count N_p, Fixed-Ring Sun-to-Carrier Speed Reduction Ratio (1 + N_r / N_s), Carrier Output Speed (RPM), and Carrier Output Torque (N·m).
Read the guide →Supply Chain & Inventory OptimizationEppen Inventory Risk Pooling & Square-Root Law Formula
Calculate centralized safety stock z * sigma * SQRT(N * (1 + (N - 1)*rho)) via Gary Eppen’s (1979) risk-pooling formula and quantify how demand correlation erodes Square-Root Law savings.
Read the guide →Healthcare & ClinicalEpworth Sleepiness Scale: Eight-Item Score Arithmetic
Practice summing fictional Epworth Sleepiness Scale item scores, including the author’s half-point rounding convention and checks for incomplete responses.
Read the guide →EngineeringErgun Packed-Bed Pressure Drop Formula (Catalyst & Filter Columns)
Build a guarded SI-unit spreadsheet for Ergun fixed-bed pressure loss, separating viscous and inertial contributions and testing sensitivity to flow, particle size and porosity.
Read the guide →OperationsErlang B Trunk Blocking & Erlang C Multi-Server Call Center Delay (M/M/c)
Calculate Agner Krarup Erlang's exact c=3 server Blocking Probability B(3, A), queueing Delay Probability C(3, A) = 3*B / (3 - A*(1 - B)), and Average Speed of Answer (ASA in seconds) from offered traffic Erlangs A = lambda / mu.
Read the guide →Energy Systems & Sustainability AnalyticsEROI & Net Energy Cliff Buffered Grid Formula
Calculate raw and storage-buffered Energy Return on Investment EROI = E_out*(1 - f_curt)/(E_inv + E_stor) and expose Charles Hall’s nonlinear Net Energy Cliff 1 - (1 / EROI).
Read the guide →Formula Auditing & LogicError-Proof a Complex Formula Chain: Targeted Stage Gates vs. Blanket IFERROR
Harden multi-step lookup, multiplication, and division pipelines by isolating missing lookup keys (IFNA), non-numeric text inputs (ISNUMBER), and zero denominators separately instead of masking bugs with IFERROR(..., 0).
Read the guide →Engineering & ScienceEucken & Modified Eucken Polyatomic Gas Thermal Conductivity Formula
Estimate dilute polyatomic gas thermal conductivity k = (μ / M) * (C_v + 2.25 * R) and Modified Eucken k_mod = (μ / M) * (1.32 * C_v + 1.77 * R) (mW/(m·K)) from gas viscosity and molar heat capacity.
Read the guide →EngineeringEuler Column Buckling Load formula: P_cr = PI()^2 * E * I / (K * L)^2
Explore the ideal elastic Euler buckling load and its dependence on effective length, without treating it as a structural design rating.
Read the guide →Portfolio Construction & RiskEuler Portfolio Risk Decomposition: Marginal and Component Volatility
Decompose multi-asset portfolio volatility into exact additive Component Risk CR_i = w_i * (Sigma * w)_i / sig_p and Percentage Risk Contribution in Excel and Arte Sheets.
Read the guide →Semiconductor Photolithography & OpticsEUV Lithography Rayleigh CD & Depth of Focus Formula
Calculate Photolithography Minimum Printable Half-Pitch CD = k_1 * (lambda / NA), Rayleigh Depth of Focus DOF = k_2 * (lambda / NA^2), Minimum Pitch 2 * CD, and Transistor Area Scaling.
Read the guide →Electric Vehicle Battery Packs, BMS Hardware & LFP/NMC Cell BalancingEV BMS Passive Bleed Resistor Balancing Time & Heat Formula
Calculate Excess Imbalance Charge Delta_Q (Ah), Peak Shunt Bleed Current I_bleed (mA), Duty-Cycle Average PCB Resistor Heat P_avg (mW), and Full Top-Balancing Time (hours).
Read the guide →EV Battery Pack Architecture, Cell-to-Pack (CTP) Integration & Energy DensityEV Cell-to-Pack (CTP) Gravimetric & Volumetric Efficiency Formula
Calculate Nominal Pack Energy (kWh), Gravimetric Cell-to-Pack Mass Ratio GCTP (%), Volumetric Cell-to-Pack Space Utilization VCTP (%), and Pack-Level Specific Energy (Wh/kg).
Read the guide →Electric Vehicle Powertrain Dynamics, Regenerative Braking & BMS Charge LimitsEV Regenerative Braking Kinetic Energy & Power Cap Formula
Calculate Deceleration Kinetic Energy Shed Delta_KE (kJ), Average Braking Power (kW), Peak Initial High-Speed Braking Power (kW), and BMS-Capped Battery Energy Recovered (Wh).
Read the guide →MathEVEN and ODD functions: round quantities away from zero to pair or odd counts
Round order quantities up to twin-pack even integers with EVEN or centered odd display counts with ODD.
Read the guide →Financial & AccountingEven-Principal Loan Interest Schedule (ISPMT Formula vs Level-Payment IPMT)
Calculate periodic interest and lifetime interest on straight-line (even-principal) commercial loans and municipal bonds where an equal slice of principal PV / Nper is retired each period.
Read the guide →StatisticalEWMA (Exponential Smoothing) & Croston Intermittent Demand Forecast formulas
Forecast continuous series via EWMA Ft+1 = alpha * Y_t + (1 - alpha) * F_t and lumpy zero-heavy spare-parts demand via Croston's Size / Interval ratio.
Read the guide →Logical checks and errorsEXACT function: compare two text strings with case sensitivity
Standard spreadsheet equality (=) treats uppercase and lowercase letters as identical. Use EXACT when external IDs, coupon tokens, or batch codes depend on letter case.
Read the guide →Reinsurance & Actuarial PricingExcess-of-Loss (XL) Layer & Rate-on-Line Formula
Calculate per-occurrence Excess-of-Loss reinsurance recovery MIN(Limit, MAX(0, Loss - Retention)), Burning-Cost Rate, Loaded Treaty Rate-on-Line (ROL = Premium / Limit), and Payback Years.
Read the guide →StatisticalExclusive Percentile and Quartile Interpolation (PERCENTILE.EXC & QUARTILE.EXC Formula)
Compute Weibull (N + 1) * k exclusive percentiles and quartiles alongside PERCENTILE_INC so small-sample tail cutoffs match engineering and hydrological standards.
Read the guide →MathEXP function: model continuous compounding and exponential decay
Raise Euler's constant e (2.71828...) to any power with EXP to calculate continuous growth P*e^(r*t) and exponential decay.
Read the guide →Statistical & MathExpected Calibration Error (ECE) & Expected-to-Observed (E/O) Risk Ratio
Audit clinical risk scores and ML classifiers across probability bins using Expected Calibration Error ECE = SUM(n_b * |p_pred - p_obs|) / N and overall Expected-to-Observed event ratio E/O = SUM(n_b * p_pred) / SUM(n_b * p_obs).
Read the guide →FinancialExpense or headcount begins on specific month (FP&A start/end date trigger)
Turn planned hires, SaaS subscriptions, and fixed-term contractor costs ON at StartMonth and OFF after EndMonth across a multi-column FP&A forecast.
Read the guide →StatisticalExponential Distribution PDF, CDF, and Memoryless Survival Probability (EXPON.DIST Formula)
Calculate inter-arrival probability density, cumulative failure probability, survival probability P(T > x), and target SLA quantiles using EXP and LN.
Read the guide →EngineeringExponential half-life model: remaining quantity and threshold time
Calculate an ideal exponential quantity and the time to a positive mathematical threshold.
Read the guide →StatisticalExponential Moving Average (EMA) and exponential smoothing formula
Smooth noisy time series recursively using Alpha = 2 / (Span + 1) and EMA_t = Alpha * Actual_t + (1 - Alpha) * EMAt-1.
Read the guide →StatisticalExponential Regression Compound Growth Factor and Base Formula (LOGEST via LN & SLOPE)
Fit exponential curves y = a * b^x using log-transformed linear regression EXP(SLOPE(LN(y), x)) and EXP(INTERCEPT(LN(y), x)) to forecast compounding series.
Read the guide →International Trade Finance & Export BankingExport Forfaiting Straight Discount to Yield Formula
Convert ICC URF 800 Forfaiting Straight Discount Quotes (ACT/360 plus Settlement Grace Days) into Upfront Discount Deduction, Net Exporter Proceeds, Discount-to-Yield Rate, and All-In Effective APR.
Read the guide →Corporate Financial Planning & FP&AExternal Financing Needed (EFN) Sales Plug Formula
Forecast pro-forma balance-sheet funding gaps via External Financing Needed EFN = ((A* - L*) / S_0)*Delta_S - PM * S_0 * (1 + g) * (1 - d) and find the zero-EFN internal growth cutoff.
Read the guide →Automated Packaging, CNC Tool Changers & Rotary Turrets, External Geneva MechanismExternal Geneva Wheel Dwell, Velocity & Accel Formula
Calculate Dwell-to-Index Motion Ratio, Mid-Stroke Peak Wheel Angular Velocity (rad/s), Crank Angle at Peak Acceleration (deg), and Peak Angular Acceleration (rad/s²).
Read the guide →Lookup & ReferenceExtract All Partial Substring Matches Into a Dynamic List (FILTER & SEARCH)
Return every row whose description or SKU contains a partial search string using row-level ISNUMBER(SEARCH(...)) flags paired with FILTER, replacing fragile legacy INDEX/SMALL array formulas.
Read the guide →Text & String FormulasExtract Clean Hostname / Domain from Any URL (LEFT, FIND & SUBSTITUTE)
Strip http://, https://, leading www., port numbers (:8443), and trailing /path?query segments from messy referral URLs using sentinel-guarded FIND and SUBSTITUTE.
Read the guide →Data Cleaning & TextExtract Common Shared Items Between Two Comma-Delimited Text Strings
Tokenize two comma-separated tag or skill strings with TEXTSPLIT and TOCOL, filter the overlapping tokens, and return a clean comma-joined intersection.
Read the guide →Dynamic ArraysExtract common values from two lists (set intersection with FILTER)
Find items that appear in BOTH List A and List B—count shared records and extract a deduplicated overlap list dynamically.
Read the guide →Date & TimeExtract date or time from a timestamp: split serial numbers with INT and MOD
Strip the clock fraction from date-time timestamps with INT(timestamp) so date lookups and daily groupings match cleanly.
Read the guide →TextExtract display name and company domain from an email address
Split mailbox handles and domains around "@" with TEXTBEFORE and TEXTAFTER, and turn dot/underscore usernames into Proper Case names.
Read the guide →TextExtract domain, clean URL, and page slug from web URLs
Strip ?utm query parameters, isolate the hostname after "://", and pull the final URL slug for SEO and analytics audits.
Read the guide →TextExtract last 2 (or N) words & remove the last word (TEXTAFTER / TEXTBEFORE -N)
Use negative instance numbers (-1, -2) in TEXTAFTER and TEXTBEFORE to slice from the RIGHT end of any phrase without RIGHT/SUBSTITUTE hacks.
Read the guide →Text & String FormulasExtract Middle Name(s) from Full Name (MID, FIND & SUBSTITUTE)
Isolate one or multiple middle names between the first and last space of a full name—and cleanly return "" when a person has only a first and last name—using TRIM, SUBSTITUTE nth-instance markers, and MID.
Read the guide →TextExtract text between parentheses (or brackets) with formulas
Pull SKUs, tickers, or currency codes enclosed in parentheses using TEXTBEFORE/TEXTAFTER or classic MID and FIND.
Read the guide →TextExtract the final domain label (.com, .org, .uk) from simple URLs and emails
Isolate a simple hostname, then extract its last dot-separated label with TEXTAFTER.
Read the guide →