Learn one useful thing today.
Lee Trimming Bounds Formula for Differential Sample Attrition
Correct selective follow-up attrition in randomized trials using David Lee’s (2009) excess-observer trimming fraction p_trim = (s_T - s_C) / s_T and sharp quantile-trimmed bounds.
Read the guide →Cleaning imported dataLEFT function: extract a fixed-width prefix from structured codes
Pull a three-letter depot code from the start of consistent identifiers like NTH-014, and check what happens on shorter strings, blanks, and variable-length prefixes.
Read the guide →Credit Risk & Corporate FinanceLeland Endogenous Default Barrier, Debt Value, and Credit Spread Formula
Price perpetual risky corporate debt, equity-chosen endogenous bankruptcy threshold V_B, and levered firm value under Leland’s (1994) structural trade-off model.
Read the guide →Corporate Finance & Asymmetric InformationLeland-Pyle IPO Equity Retention Signaling Formula
Value Hayne Leland & David Pyle’s (1977) separating IPO valuation schedule V(alpha) = V_min - b*sigma^2*(LN(1 - alpha) + alpha) from insider ownership retention.
Read the guide →Healthcare & ClinicalLEMON Airway Research: Five Components and a Point Sum
Explore how one research version of the LEMON airway assessment added five components and why the sum alone cannot determine an airway plan.
Read the guide →Cleaning imported dataLEN function: count characters and expose hidden trailing spaces
Measure exact string length—including spaces and punctuation—to diagnose why two visually identical bin codes fail to match.
Read the guide →LogicalLET function: name intermediate calculations once inside a formula
Store repeated sub-expressions in readable local names with LET so tiered pricing and margin formulas run cleaner and faster.
Read the guide →Engineering & ScienceLevenspiel CSTR vs. PFR Reactor Volume Ratio (1st & 2nd Order)
Calculate the isothermal CSTR-to-Plug-Flow-Reactor volume penalty V_CSTR / V_PFR across target conversion X (0 < X < 1) for first-order ((X / (1 - X)) / (-LN(1 - X))) and second-order (1 / (1 - X)) kinetics.
Read the guide →Employee Ownership, Corporate Succession & ERISA / IRC §4975 Leveraged ESOPsLeveraged ESOP Suspense-Share Release & Repurchase Formula
Calculate ERISA / IRC §4975 Leveraged ESOP General Principal-Plus-Interest Suspense-Share Release Fraction, Shares Allocated to Employee Accounts, IRC §404(a)(9) Principal + Interest Tax Shield ($M), and IRC §409(h) Share Repurchase Obligation ($).
Read the guide →Biostatistics & EpidemiologyLevey-Jennings QC Chart Formula: z-Score (1_2s / 1_3s), SDI & Peer CV Ratio (CVR)
Monitor daily clinical laboratory quality-control runs on a Levey-Jennings chart via QC z-score (x_QC - Mean) / SD (flagging 1_2s warning and 1_3s rejection) and inter-laboratory proficiency SDI & CVR.
Read the guide →Engineering & ScienceLevich Equation: Rotating Disk Electrode (RDE) Limiting Current vs RPM
Calculate steady-state convective-diffusion limiting current iL = 0.620 * n * F * A * D^(2/3) * omega^(1/2) * nu^(-1/6) * C0 in microamps as a function of RDE rotation speed (RPM).
Read the guide →Statistical AnalysisLevin’s Population Attributable Fraction (PAF) & Prevented Fraction Formula
Quantify public-health and operational defect impact using Morton Levin’s (1953) Population Attributable Fraction p_e*(RR - 1) / (1 + p_e*(RR - 1)) and protective Prevented Fraction p_cov*(1 - RR).
Read the guide →Mechanical Design & Power TransmissionLewis Gear-Tooth Bending Stress and Barth Velocity Factor Formula
Size spur-gear module m and face width b in Excel and Arte Sheets using Wilfred Lewis’s (1892) cantilever tooth root bending stress sigma_b = K_v * W_t / (b * m * Y).
Read the guide →ScienceLife Table R0, Cohort Generation Time and a Leslie Projection
Calculate lifetime recruitment, a cohort-weighted generation interval and an approximate growth rate, then project three age classes using an explicit discrete census convention.
Read the guide →Financial Statement Analysis, US GAAP vs IFRS Inventory & LIFO ConformityLIFO Reserve to FIFO Inventory, COGS & Tax Shield Formula
Convert US GAAP LIFO Financial Statements to IFRS-Comparable FIFO: FIFO Ending Inventory (LIFO + Reserve), FIFO COGS (LIFO COGS - ΔReserve), Cumulative Cash Tax Saved, and LIFO Liquidation Phantom Profit Detection.
Read the guide →Healthcare & ClinicalLight’s Criteria: Pleural Fluid Ratios and Cutoffs
Calculate the three commonly used Light’s criteria with consistent laboratory units and understand their limits.
Read the guide →Affordable Housing Finance, IRC Section 42 LIHTC & Real EstateLIHTC Section 42 Qualified Basis, DDA Boost & Equity Formula
Calculate IRC Section 42 Low-Income Housing Tax Credit (LIHTC) Boosted Qualified Basis ($M), Annual Tax Credit ($M), 10-Year Credit Allocation ($M), and Syndicated Investor Equity Proceeds ($M).
Read the guide →Healthcare & Clinical CalculationsLille Model: Day-7 Alcohol-Associated Hepatitis Example
Explore the original Lille model’s variables, units and limitations using fictional data; the example does not prescribe treatment.
Read the guide →Statistical & EconometricLin’s Concordance Correlation Coefficient (CCC, ρ_c) Formula
Calculate Lawrence Lin’s Concordance Correlation Coefficient ρ_c = (2 * r * s_x * s_y) / (s_x^2 + s_y^2 + (x̄ - ȳ)^2) and bias correction factor C_b = ρ_c / r to measure 45° identity-line assay agreement.
Read the guide →Statistical AnalysisLin’s Concordance Correlation Coefficient (CCC): Precision vs. 45-Degree Accuracy
Evaluate method-comparison and clinical assay reproducibility along the 45-degree identity line Y = X by factoring Lin’s CCC into Pearson precision (r) and bias correction accuracy (C_b).
Read the guide →Engineering & ScienceLindemann Melting Criterion & Thermal RMS Vibration Ratio
Estimate crystalline melting temperature T_m = 0.00229054 * M * Θ_D^2 * c_L^2 * d^2 (K) from Debye temperature Θ_D, atomic mass M (g/mol), nearest-neighbor spacing d (Å), and Lindemann constant c_L (~0.10–0.12).
Read the guide →Charts & Visual DataLine of Best Fit & Equation Formula: Exact OLS Slope, Intercept & R² via SUMPRODUCT
Extract the exact Scatter-Chart Line of Best Fit equation y = m*x + b and R-Squared directly into cells using closed-form SUMPRODUCT moments — so downstream forecasts reference live trendline coefficients.
Read the guide →Engineering & ScienceLinear & Quadratic Stark Effect Atomic Electric-Field Splitting Formula
Calculate Johannes Stark’s n = 2 hydrogen first-order linear electric-field energy splitting delta_E = 3 * e * a_0 * E (meV) and ground-state polarizability second-order quadratic Stark shift.
Read the guide →Engineering & ScientificLineweaver-Burk & Hanes-Woolf Enzyme Kinetics: Vmax, Km & Inhibitor Diagnosis
Extract catalytic maximum velocity V_max and Michaelis constant K_m from substrate-velocity assays using double-reciprocal Lineweaver-Burk (1/v vs 1/[S]) and Hanes-Woolf ([S]/v vs [S]) OLS regression.
Read the guide →FinancialLintner Dividend Smoothing Model formula: partial adjustment to target payout
Explore a simplified, zero-intercept dividend partial-adjustment model with explicit parameter bounds.
Read the guide →Clinical Medicine & PhysiologyLipid Accumulation Product: A Waist and Triglyceride Spreadsheet Example
Learn how Kahn’s sex-specific lipid accumulation product combines waist circumference and fasting triglycerides, and why its numerical value is not a diagnosis.
Read the guide →Dynamic ArraysList all combinations from two lists (Cartesian product with TOCOL)
Generate every Size x Color SKU variant or Region x Quarter pair into a single spilled column using TOCOL(List1 & "-" & TRANSPOSE(List2)).
Read the guide →Dates, Time & SchedulesList All Dates in a Month Dynamically with SEQUENCE & EOMONTH
Generate a self-resizing vertical calendar column of every date in any Year + Month (automatically adjusting for 28-, 29-, 30-, or 31-day months) using SEQUENCE(DAY(EOMONTH(DATE(Y, M, 1), 0)), 1, DATE(Y, M, 1), 1).
Read the guide →Date & TimeList all holidays falling between two project dates (FILTER holiday schedule)
List and count records from a supplied holiday table within an inclusive date window.
Read the guide →Statistical AnalysisList Most Frequently Occurring Numbers & Bimodal Ties (UNIQUE, COUNTIF & SORTBY)
Extract every tied numeric mode, rank distinct numbers by occurrence count, and compute modal frequency share without MODE.SNGL hiding bimodal clusters.
Read the guide →TextList team members by group in alphabetical order (TEXTJOIN, SORT & FILTER)
Roll up vertical employee-to-squad assignments into sorted, comma-separated roster strings per team with graceful empty-team fallbacks.
Read the guide →Alternative Credit, Commercial Litigation Finance & Settlement WaterfallsLitigation Finance Non-Recourse Funding Waterfall Formula
Calculate Commercial Litigation Finance Non-Recourse Senior Funder Return + Multiple Payout, Remaining-Pool Capped Trial Counsel Contingency Fee, Claimant Net Settlement Proceeds, and Claimant Recovery Share.
Read the guide →Math & TrigLittle's Law (WIP, Throughput, Cycle Time) and Takt Time formulas
Size Kanban WIP caps with Little's Law (WIP = Throughput * CycleTime) and balance production lines using Takt Time and workstation efficiency.
Read the guide →Operations Research & Revenue ManagementLittlewood Rule and EMSR-b Seat Protection Booking Limit Formula
Aggregate high-fare classes via Belobaba’s EMSR-b weighted fare p_pool, pooled SD SQRT(SUM sigma^2), and Littlewood’s critical ratio 1 - p_low / p_pool to set discount booking limits.
Read the guide →Soft-Switching Power Electronics & EV ChargersLLC Resonant Converter Tank Frequency, Ln & Q Formula
Calculate Half-Bridge LLC Series Resonant Frequency f_r = 1000 / (2*PI()*SQRT(L_r_uH * C_r_uF)) (kHz), Characteristic Impedance Z_0 = SQRT(L_r / C_r), Inductance Ratio L_n = L_m / L_r, and Loaded Quality Factor Q_e = Z_0 / R_ac.
Read the guide →MathLN function: calculate continuous growth rates and exact doubling time
Use the natural logarithm LN (inverse of EXP) to solve for unknown compounding time or continuous log returns, and handle zero/negative #NUM! inputs.
Read the guide →Maritime Energy Trading, LNG Cryogenics & Shipping EconomicsLNG Carrier Boil-Off Gas (BOG), Heel & Delivered MMBtu Formula
Calculate LNG Carrier Voyage Boil-Off Gas Loss (m³ LNG), Arrival Tank Volume (m³), Net Discharged Cargo After Cryogenic Heel (m³), and Delivered Regasification Energy (MMBtu).
Read the guide →Quantitative Finance & Time SeriesLo-MacKinlay Variance Ratio VR(q) Random-Walk Test Formula
Test the Random Walk Hypothesis in Excel and Arte Sheets using Lo and MacKinlay’s (1988) variance ratio VR(q) = var_q / (q * var_1) and asymptotic Z(q) statistic.
Read the guide →OSHA 1910.178 Powered Industrial Trucks, Forklift Attachment Derating & Warehouse SafetyLoad Moment: Why a Forklift’s Load Centre Matters
Explore the arithmetic of a force and lever arm, and find the manufacturer-rated capacity for a specific forklift and attachment.
Read the guide →FinancialLoan amortization schedule: reconcile payment, interest, principal, and ending balance
Combine PMT, IPMT, PPMT, and FV to build a self-balancing loan amortization schedule that amortizes cleanly to zero.
Read the guide →Regional Economics & Urban PlanningLocation Quotient & Economic Base Multiplier Formula
Calculate sectoral Location Quotients LQ_i = (E_ir / E_r) / (E_in / E_n), bifurcate Basic export employment MAX(0, E_ir - E_r*(E_in/E_n)), and compute the Economic Base Multiplier.
Read the guide →Engineering & ScienceLockhart-Martinelli Parameter (X_tt) & Chisholm Two-Phase Multiplier (φ_L²)
Calculate gas-liquid two-phase pipe frictional pressure drop multiplier φ_L^2 = 1 + C / X_tt + 1 / X_tt^2 from vapor quality x, phase densities, and viscosities.
Read the guide →MathLOG and LOG10: calculate custom-base logarithms, binary depth, and decibels
Compute base-10 orders of magnitude and decibels with LOG10, or binary/custom-base logarithms with LOG(number, base).
Read the guide →StatisticalLog-Gamma Scaling and Erlang Multi-Stage Waiting-Time Probability (GAMMALN & GAMMA.DIST)
Evaluate exact log-gamma LN(FACT(k - 1)), gamma density ordinates, and closed-form Erlang k-stage waiting-time cumulative probabilities using EXP, LN, and FACT.
Read the guide →Statistical & Mathematical FormulasLog-Rank (Mantel-Cox) Survival Test: Chi-Square & Hazard Ratio
Compare two censored Kaplan-Meier survival curves across discrete event times via the Mantel-Cox Log-Rank test χ^2 = (Σ O_1j - Σ E_1j)^2 / Σ V_j with exact hypergeometric tie variance.
Read the guide →Statistical AnalysisLognormal Cumulative Probability, Mean-Median Skew & Quantiles (LOGNORMDIST & LOGNORM.INV)
Model strictly positive right-skewed claim severities and response latencies by mapping log-space mean mu and volatility sigma into lognormal medians, expected means, cumulative probabilities, and VaR quantiles.
Read the guide →Engineering & ScienceLondon Magnetic Penetration Depth & BCS Superconducting Energy Gap Formula
Calculate the two-fluid temperature-dependent London penetration depth lambda_L(T) = lambda_0 / SQRT(1 - (T / Tc)^4) in nm and weak-coupling BCS Cooper-pair energy gap 2*Delta_0 = 3.528 * kB * Tc in meV.
Read the guide →StatisticalLongest winning or daily habit streak formula (current and best streak)
Track consecutive wins, incident-free days, or SLA hits with a resetting streak counter and summarize Best and Current Streak.
Read the guide →Lookup & ReferenceLook Up & Concatenate All Matches Into One Comma-Separated Cell (TEXTJOIN + FILTER)
Return every invoice, serial number, or owner matching a lookup key inside a single comma-delimited summary cell using TEXTJOIN(", ", TRUE, FILTER(..., "No Matches")).
Read the guide →Lookup & ReferenceLook up a table row and transpose it into a vertical summary card (HSTACK + TRANSPOSE)
Build a clean 2-column Field | Value inspector card from a wide horizontal table by pairing XLOOKUP, TRANSPOSE, and HSTACK.
Read the guide →