Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Lookup & Reference

Lookup a value between two numbers (explicit Min and Max columns)

Match an input inside inclusive [Min, Max] bracket rows using FILTER—rejecting out-of-bounds values that approximate VLOOKUP accepts.

Read the guide →
Lookup & Reference

Lookup Across Selectable Rate Tables Without Volatile INDIRECT (IFS & VLOOKUP)

Route SKU price lookups dynamically between Standard and Partner price books based on a customer tier cell using non-volatile IFS and VLOOKUP.

Read the guide →
Lookup & Reference

Lookup and sum an entire column or row dynamically (SUM + XLOOKUP)

Match a quarter, month, or scenario header horizontally and SUM, AVERAGE, or MAX the entire matched column in one readable formula.

Read the guide →
Financial & Business Formulas

Lookup Hourly Rates & Sum Total Invoice Billing (XLOOKUP & SUMPRODUCT)

Pull role-based hourly billing rates from a master rate card with XLOOKUP and roll up total project invoice value via SUMPRODUCT(Hours, Looked_Up_Rates).

Read the guide →
Lookup & Reference

Lookup Latest File Version, Artifact Filename & Author (XLOOKUP Reverse Search)

Retrieve the most recently appended file revision, version integer, and uploader for any document family in a chronological release log using XLOOKUP search_mode = -1 and MAXIFS.

Read the guide →
Lookup & Reference

Lookup latest price or revision by date (unsorted history safe)

Retrieve the most recent unit cost or contract rate for an item even when historical log rows are NOT sorted chronologically.

Read the guide →
Lookup & Reference

Lookup price with client-specific contract override and standard rate fallback

Check a negotiated client contract rate table first and automatically fall back to your master catalog price when no custom override exists.

Read the guide →
Lookup & Reference

Lookup Product Unit Cost & Extended Gross Profit Without #N/A (XLOOKUP)

Retrieve standard unit cost from a master catalog with built-in XLOOKUP if_not_found protection and compute extended gross profit (Unit_Price - Unit_Cost) * Qty safely.

Read the guide →
Lookup & Reference

Lookup the date or name of a MAX or MIN value: first and last matching rows

Return the label associated with a maximum or minimum, and choose the first or last matching row when values tie.

Read the guide →
Engineering

Lorentz Factor (gamma), Relativistic Time Dilation, Length Contraction & Kinetic Energy

Calculate Hendrik Lorentz & Albert Einstein's relativistic factor gamma = 1 / SQRT(1 - beta^2), dilated coordinate time, contracted length, and (gamma - 1)*mc^2.

Read the guide →
Engineering & Science

Lorentz-Lorenz Molar Refractivity (RM) & Clausius-Mossotti Polarizability Formula

Calculate phase-invariant molar refractivity R_M = ((n^2 - 1) / (n^2 + 2)) * (MW / rho) in cm^3/mol and electronic molecular polarizability alpha_0 (in Angstrom^3) from optical refractive index n and density rho.

Read the guide →
Science

Lotka-Volterra Equilibrium and Small-Amplitude Period in Excel

Explore predator-prey equilibria, local rates of change and a constant per-capita removal scenario, with a clear distinction between a linearized period and a full nonlinear trajectory.

Read the guide →
Private Equity Secondaries, Portfolio Pricing & SPA Mechanics

LP Secondary NAV Roll-Forward, Effective Discount & MOIC

Calculate LP Secondary Sale-and-Purchase Agreement (SPA) Closing Price ($M), Effective Closing Discount (%) After Interim Cash Flows, Day-1 Upfront Wire ($M), and Buyer Gross MOIC (x).

Read the guide →
Metal Additive Manufacturing, Laser Powder Bed Fusion (LPBF/SLM) & Melt-Pool QA

LPBF Metal 3D Printing Volumetric Energy Density Formula

Calculate Linear Energy Density P/v (J/mm), Volumetric Energy Density VED = P/(v*h*t) (J/mm³), Theoretical Laser Melt Build Rate (cm³/hr), and Lack-of-Fusion vs Keyhole Porosity Window.

Read the guide →
Engineering & Science

Lucas Corresponding-States Low-Pressure Gas Viscosity Formula (µPa·s)

Predict non-polar gas dynamic viscosity η (µPa·s) solely from critical temperature T_c, critical pressure P_c (bar), and molar mass M without Lennard-Jones collision integrals.

Read the guide →
Engineering & Science

Lucas-Washburn Capillary Wicking Length & Assay Flow Time

Calculate horizontal capillary penetration distance L(t) = SQRT((γ * r * cos(θ) / (2 * μ)) * t) (mm) and lateral-flow diagnostic transit time t_flow (s) in porous paper strips and heat-pipe wicks.

Read the guide →
Engineering & Science

Luedeking-Piret Bioprocess Kinetics: Growth vs. Non-Growth Product Rate

Calculate specific cellular product formation rate q_p = alpha * mu + beta (g product / g DCW / h) and volumetric bioreactor productivity r_p = (alpha * mu + beta) * X (g/(L*h)) across exponential and stationary fermentation phases.

Read the guide →
Math & Trig

Luhn Algorithm (Mod 10) formula: generate and validate account check digits

Generate and check a Luhn checksum for an illustrative eight-digit payload. A passing checksum does not validate an account or identity.

Read the guide →
Engineering

Lumber Board Feet (BF) & MBF pricing formula: (Thick" × Width" × Length') / 12

Convert nominal hardwood and framing tally lists into Board Feet, Linear Feet, and $/MBF (per 1,000 board feet) lumber orders.

Read the guide →
Engineering & Scientific

Lumped-Capacitance Biot Gate (Bi <= 0.1) & Newtonian Thermal Quench Time

Verify lumped-system validity via Characteristic Length L_c = V / A_s and Biot number Bi = h * L_c / k, then calculate thermal time constant tau and exact cooling/heating time.

Read the guide →
Clinical Medicine & Physiology

Lund–Browder Charts and Weighted Percentages: A Spreadsheet Exercise

Explore how weighted percentages add up using imaginary regions, and find official resources on burn-size assessment.

Read the guide →
Biopharmaceutical Fill-Finish, Freeze-Drying (Lyophilization) & Biologics

Lyophilization Primary Drying Vial Sublimation & Time Formula

Calculate Single-Vial Shelf Heat Transfer Input Q_v (W), Ice Sublimation Rate dm/dt (g/hr), Nominal Primary Drying Duration (hr), and Cake Collapse Safety Margin (K).

Read the guide →
Statistical

M/M/1 Queueing formula: server utilization, queue length (Lq) & wait time (Wq)

Model call-center, checkout, and API worker queues using M/M/1 arrival rate lambda, service rate mu, utilization rho = lambda/mu, Lq, and Wq.

Read the guide →
Operations & Logistics

M/M/1/K Finite-Buffer Queue Blocking Probability, Drop Rate & Mean Occupancy

Model finite-capacity single-server queues (API connection pools, router packet buffers, call trunks) with exact M/M/1/K blocking probability P_K, admitted throughput lambda_eff, mean occupancy L, and rho = 1 singularity handling.

Read the guide →
Investment Banking & M&A Structuring

M&A Contingent Earnout Sliding-Scale vs Cliff Formula

Calculate Linear Sliding-Scale Earnout Payout E_max * MIN(1, MAX(0, (R_act - R_min) / (R_max - R_min))), Binary All-or-Nothing Cliff Payout, Present-Value Total Consideration, and Marginal Revenue Slope.

Read the guide →
Investment Banking & Corporate M&A

M&A EPS Accretion / Dilution & Breakeven Synergy Formula

Calculate Pro-Forma M&A Earnings Per Share under mixed stock-and-debt acquisition financing, EPS Accretion/Dilution percentage, and Pre-Tax Breakeven Synergies.

Read the guide →
Mergers & Acquisitions, Transaction Advisory & Deal Closing Mechanics

M&A EV-to-Equity Bridge, Working Capital Peg & Wire Formula

Calculate M&A Completion-Accounts Closing Net Debt (Debt - Cash), Dollar-for-Dollar Net Working Capital (NWC) Peg Adjustment (Actual_NWC - Target_Peg), Adjusted Equity Purchase Price, and Day-1 Seller Wire Proceeds Net of Escrow.

Read the guide →
Investment Banking & M&A Structuring

M&A Floating-Value Stock Collar Exchange Ratio Formula

Calculate the floating stock exchange ratio ER = V_offer / MIN(P_cap, MAX(P_floor, P_acq)), implied target per-share payout, and pro-forma target ownership across M&A collar bands.

Read the guide →
Financial

Macaulay Duration and Modified Duration Bond Formulas (DURATION & MDURATION)

Compute present-value-weighted cash-flow maturity (Macaulay Duration) and yield sensitivity (Modified Duration) directly from coupon schedules without opaque Analysis ToolPak black boxes.

Read the guide →
Engineering

Mach Number, Speed of Sound in Air & Aerodynamic Dynamic Pressure (q) formulas

Calculate local speed of sound a = SQRT(1.4 * 287.05 * (T_C + 273.15)), flight Mach Number V / a, compressible regime, and dynamic pressure 0.5 * rho * V^2.

Read the guide →
Engineering & Science

Mach-Zehnder Interferometer (MZI): Phase Transmittance & Extinction Ratio

Calculate integrated silicon-photonics Mach-Zehnder bar-port transmittance T = COS(π * Δn_eff * L / λ)^2 and finite coupler Extinction Ratio ER = -20 * LOG10(ABS(1 - 2 * κ)) (dB).

Read the guide →
Personal Finance & Planning

Macro-Nutrient Meal & Grocery Budget Planner (SUMPRODUCT Atwater 4-4-9 & Protein Cost)

Scale serving multiples across daily meals with SUMPRODUCT to track total protein, carbs, fats, Atwater 4-4-9 calories, protein calorie share %, and daily grocery budget limits.

Read the guide →
Corporate Tax Accounting, CapEx Modeling & Capital Budgeting

MACRS 200% DB & IRC §168(k) Bonus Depreciation Formula

Calculate IRC Section 168(k) First-Year Bonus Depreciation ($M), Combined Year-1 MACRS Half-Year 200% Declining-Balance Deduction ($M), Cash Tax Shield ($M), and Adjusted End-of-Year-1 Tax Basis ($M).

Read the guide →
Operations

MAE, WAPE & Forecast Bias for Intermittent Zero-Demand SKUs

Measure supply-chain forecast accuracy without #DIV/0! zero-actual explosions using Mean Absolute Error MAE = AVERAGE(|A - F|), Weighted Absolute Percentage Error WAPE = SUM(|A - F|) / SUM(A), and Signed Bias.

Read the guide →
Semiconductor PVD & Thin-Film Vacuum Coating, Magnetron Sputtering Rate & Cosine Throw

Magnetron Sputtering PVD Deposition Rate & Throw Formula

Calculate Total Sputtered Atom Emission Rate (10¹⁹ atoms/s), Knudsen Cosine Wafer-Center Flux (10¹⁶ atoms/cm²·s), Film Deposition Rate (nm/min), and 500 nm Seed Coat Time (min).

Read the guide →
Operations & Logistics

Maister’s Square-Root Law of Warehouse Centralization & Correlated Safety Stock

Project safety-stock savings when consolidating N_old regional depots into N_new hubs using David Maister’s (1976) SQRT(N_new / N_old) law plus inter-regional demand correlation rho.

Read the guide →
Text

Make dynamic labels singular or plural based on count (1 item vs 0 items)

Format natural summary strings ("1 pallet", "0 entries", "5 boxes") by testing ABS(Qty) = 1 for regular and irregular nouns.

Read the guide →
Engineering

Malus's Law Polarizer Intensity & Brewster's Angle optics formulas

Calculate ideal analyzer transmission and the Brewster angle for two transparent dielectric media.

Read the guide →
Health Actuarial & Value-Based Care Finance

Managed Care PMPM Capitation & IBNR Pool Formula

Calculate Risk-Adjusted PMPM Capitation Pool Revenue, Actuarial Completion-Factor Ultimate Incurred Claims (Paid / Completion_Factor), Medical Cost Ratio (MCR), and Net Risk Margin PMPM.

Read the guide →
Statistical

Mann-Whitney U test (Wilcoxon Rank-Sum) statistic & AUC effect size

Calculate a pooled-rank Mann–Whitney statistic and a descriptive pairwise superiority estimate for two independent groups.

Read the guide →
Statistical & Clinical Analysis

Mannheim Peritonitis Research: A Weighted Point Sum

Explore the weighted structure of the Mannheim Peritonitis Index and practice adding already-assigned points.

Read the guide →
Engineering

Manning's Open-Channel Flow formula: hydraulic radius, velocity & discharge Q

Estimate velocity and discharge for a rectangular SI open channel under steady uniform-flow assumptions.

Read the guide →
Econometrics & Partial Identification

Manski Worst-Case and Monotone Causal Bounds Formula

Bound Average Treatment Effects without random assignment on bounded [0, 1] or [K_0, K_1] outcomes using Manski’s (1990) worst-case bounds and MTR/MTS tightening.

Read the guide →
Statistical & Mathematical Formulas

Mantel-Haenszel Pooled Odds Ratio: Defeating Simpson’s Paradox

Calculate the confounder-stratified Cochran-Mantel-Haenszel pooled Odds Ratio OR_MH = Σ(a_k * d_k / N_k) / Σ(b_k * c_k / N_k) across multi-center or acuity strata and contrast against biased crude pooled OR.

Read the guide →
Lookup & Reference

Map Likert Survey Text Labels to Numeric Scores (SWITCH vs XLOOKUP Table)

Convert qualitative survey responses ("Strongly Agree" through "Strongly Disagree") or risk ratings into numeric 1–5 weights using SWITCH or an XLOOKUP mapping table, while excluding "N/A" responses from averages.

Read the guide →
Logical & Lookup Formulas

Map Text Tiers to Arbitrary Numeric Weights (CHOOSE & MATCH vs XLOOKUP)

Assign non-linear SLA severity weights or T-shirt story points ("XS"->1, "S"->2, "M"->5, "L"->8, "XL"->13) to text categories without nested IFs using CHOOSE(MATCH(...)) or XLOOKUP.

Read the guide →
Statistical & Clinical Analysis

Margalef Richness, Menhinick Index & Berger-Parker Dominance Formula

Calculate three rapid ecological bioassessment indices from species counts: Margalef Richness D_Mg = (S - 1) / LN(N), Menhinick Richness D_Mn = S / SQRT(N), and Berger-Parker Dominance d_BP = N_max / N (plus reciprocal 1 / d_BP).

Read the guide →
Financial Modeling

Margrabe Exchange Option Formula & Correlation-Adjusted Spread Volatility

Value a European option to exchange asset 2 for asset 1 (stock-for-stock mergers, outperformance fees, spark spreads) using William Margrabe’s (1978) risk-free-rate-independent formula.

Read the guide →
Engineering & Science

Margules Non-Ideal Liquid Activity Coefficients (gamma1 & gamma2 VLE)

Calculate asymmetric binary vapor-liquid equilibrium (VLE) activity coefficients gamma_1 = EXP((1 - x_1)^2 * (A_12 + 2*(A_21 - A_12)*x_1)) and gamma_2 = EXP(x_1^2 * (A_21 + 2*(A_12 - A_21)*(1 - x_1))) for azeotropic distillation columns.

Read the guide →
Charts & Visual Data Modeling

Marimekko (Mekko) Chart Formula: Variable Column Widths, Cumulative X-Spans & Cell Area Share

Construct a two-dimensional Marimekko (Mosaic) market-map table: compute Segment Horizontal Width % W_j, Cumulative X-Axis Start/End Coordinates, Within-Segment Vertical Mix %, and Rectangle Area = Grand-Total Market Share.

Read the guide →