Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

CRM Lifecycle Marketing & Growth Analytics

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 Analytics

Employee 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 Flow

EN 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 Engineering

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

England–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 →
Financial

Enterprise 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 reporting

EOMONTH 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 Chain

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

EPDS 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 Kinematics

Epicyclic 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 Optimization

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

Epworth 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 →
Engineering

Ergun 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 →
Operations

Erlang 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 Analytics

EROI & 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 & Logic

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

Eucken & 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 →
Engineering

Euler 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 & Risk

Euler 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 & Optics

EUV 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 Balancing

EV 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 Density

EV 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 Limits

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

EVEN 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 & Accounting

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

EWMA (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 errors

EXACT 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 Pricing

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

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

EXP 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 & Math

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

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

Exponential 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 →
Engineering

Exponential half-life model: remaining quantity and threshold time

Calculate an ideal exponential quantity and the time to a positive mathematical threshold.

Read the guide →
Statistical

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

Exponential 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 Banking

Export 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&A

External 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 Mechanism

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

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

Extract 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 & Text

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

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

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

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

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

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

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

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

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