Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Econometrics & Randomized Experiments

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 data

LEFT 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 Finance

Leland 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 Information

Leland-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 & Clinical

LEMON 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 data

LEN 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 →
Logical

LET 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 & Science

Levenspiel 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 ESOPs

Leveraged 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 & Epidemiology

Levey-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 & Science

Levich 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 Analysis

Levin’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 Transmission

Lewis 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 →
Science

Life 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 Conformity

LIFO 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 & Clinical

Light’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 Estate

LIHTC 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 Calculations

Lille 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 & Econometric

Lin’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 Analysis

Lin’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 & Science

Lindemann 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 Data

Line 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 & Science

Linear & 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 & Scientific

Lineweaver-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 →
Financial

Lintner 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 & Physiology

Lipid 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 Arrays

List 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 & Schedules

List 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 & Time

List 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 Analysis

List 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 →
Text

List 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 Waterfalls

Litigation 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 & Trig

Little'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 Management

Littlewood 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 Chargers

LLC 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 →
Math

LN 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 Economics

LNG 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 Series

Lo-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 Safety

Load 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 →
Financial

Loan 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 Planning

Location 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 & Science

Lockhart-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 →
Math

LOG 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 →
Statistical

Log-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 Formulas

Log-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 Analysis

Lognormal 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 & Science

London 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 →
Statistical

Longest 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 & Reference

Look 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 & Reference

Look 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 →