Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Drilling Engineering & Well Control

Drilling Kill Mud Weight, ICP & FCP Well-Control Formula

Calculate True-Vertical-Depth Hydrostatic Mud Pressure 0.052 * MW * TVD, Required Kill Mud Weight KMW = MW_orig + SIDPP / (0.052 * TVD), Initial Circulating Pressure (ICP), and Final Circulating Pressure (FCP).

Read the guide →
Dynamic arrays

DROP function: strip opening balances, headers, or total rows dynamically

Exclude N rows or columns from the start or end of an imported range with DROP so summary rows never double-count.

Read the guide →
Engineering & Science

Drude Free-Electron Metal Conductivity & UV Plasma Frequency Formula

Calculate DC electrical conductivity sigma = (n * e^2 * tau) / m_e in MS/m and plasmon energy hbar * omega_p (in eV) explaining both metal Ohm's Law and why metals turn transparent in the deep ultraviolet.

Read the guide →
Business & Operations

Drum-Buffer-Rope (DBR) Buffer Penetration % & TOC Green/Yellow/Red Expedite Priority

Calculate Theory of Constraints (TOC) time-buffer consumption percentage 100 * (Buffer_Hours - Remaining_Hours) / Buffer_Hours and classify work orders into Region I Green (<33.3%), Region II Yellow (33.3%–66.7%), or Region III Red (>66.7%) expedite zones.

Read the guide →
Math

DSUM function: sum database columns using multi-row AND/OR criteria ranges

Total a named column in a structured table using DSUM when filter rules combine AND columns across OR criteria rows.

Read the guide →
Health & Fitness

Du Bois and Haycock Body Surface Area: A Spreadsheet Comparison

Compare two empirical body-surface-area estimates using fictional weight and height inputs. This example is not a medication-dose calculator.

Read the guide →
Healthcare & Clinical

Duke Treadmill Score: Bruce Protocol Spreadsheet Example

Use fictional exercise time, ST-segment deviation and an angina index to explore the Duke treadmill score arithmetic, with complete input checks.

Read the guide →
Labor Economics & Demographic Statistics

Duncan Dissimilarity Index & Karmel-MacLachlan Formula

Calculate the Duncan Index of Dissimilarity D = 0.5 * SUM(|a_k/A - b_k/B|) and Karmel-MacLachlan replacement-preserving index I_p = 2 * p * (1 - p) * D.

Read the guide →
Rotordynamics, Turbomachinery Shafts & Lateral Whirling Resonance

Dunkerley Shaft Critical Whirling Speed & Margin Formula

Calculate Dunkerley Cumulative Static Deflection Equivalent (mm), Conservative First Lateral Critical Speed N_cr (RPM), Operating Speed Separation Margin (%), and Sub/Supercritical Regime.

Read the guide →
Financial

DuPont ROE analysis formula: Margin x Asset Turnover x Financial Leverage

Break Return on Equity (NetIncome / Equity) into 3 diagnostic levers—Net Profit Margin, Total Asset Turnover, and Equity Multiplier—to see what drives ROE.

Read the guide →
Science

Dupuit-Forchheimer Unconfined Aquifer Seepage & Parabolic Water Table

Calculate steady unconfined groundwater seepage per unit width q' = K * (h1^2 - h2^2) / (2 * L) (m^2/day) and parabolic phreatic water-table elevation h(x) between two canals or earthen dam faces.

Read the guide →
Fixed Income & Rates

Duration-Neutral Barbell-Bullet Butterfly Weights and Convexity Pickup

Construct cash-and-duration-neutral 2s5s10s fixed-income butterflies in Excel and Arte Sheets and quantify exact barbell convexity pickup over a bullet bond.

Read the guide →
Econometrics & Causal Inference

Durbin-Wu-Hausman Control-Function Residual Endogeneity Test

Test regressor endogeneity in Excel and Arte Sheets by augmenting the structural equation with first-stage IV residuals v_hat = X - X_hat and computing the exact DWH t- and F-statistics.

Read the guide →
Clinical Medicine & Physiology

Durnin–Womersley Skinfold Equations: A Body Density Example

Explore how the 1974 Durnin–Womersley four-site equations estimate body density, followed by a separate Siri body-fat calculation, using an adult spreadsheet example.

Read the guide →
Lookup & Reference

Dynamic Category and Monthly Totals With Percent-of-Total (GROUPBY, PIVOTBY & PERCENTOF Patterns)

Build live category summaries, category-by-month cross-tab totals, and share-of-grand-total ratios using UNIQUE, SORT, SUMIF, and SUMIFS.

Read the guide →
Charts & Visual Data

Dynamic Chart Title Formula: Formatted KPI Headline & Signed YoY Delta Banner

Build a self-updating executive Chart Title cell using TEXT formatting and directional + / - variance logic so chart headlines never show stale numbers or raw floating-point decimals.

Read the guide →
Lookup, Reference & Dynamic Arrays

Dynamic Line Chart Ignore Empty Future Months: NA() Formula vs. Zero-Cliff Drop

Stop YTD actuals line charts from plunging vertically to 0 in unrecorded future months by returning NA() instead of "" or 0—while using COUNT(B2:B7) to aggregate completed months cleanly.

Read the guide →
Date & Time

Dynamic monthly calendar grid formula (SEQUENCE + WEEKDAY)

Spill a complete 6-week x 7-day monthly calendar grid for any Year and Month (Sunday-start or Monday-start) with one SEQUENCE formula.

Read the guide →
Lookup & Reference

Dynamic range between two matches: sum or extract rows between markers

Locate any Start milestone and End milestone with XMATCH and slice all rows inclusively between them using TAKE(DROP(...)).

Read the guide →
Statistical

Dynamic two-way average by row category and column header (CHOOSECOLS + FILTER)

Average rows matching a region or department while dynamically switching which quarter or metric column is aggregated via XMATCH + CHOOSECOLS.

Read the guide →
Lookup & Reference

Dynamic two-way sum and average: aggregate a chosen column by row criteria

Select a monthly metric column with XLOOKUP, filter its rows, and calculate a dynamic sum or average.

Read the guide →
Financial

Earned Value Management (EVM) formulas: EV, PV, CPI, SPI, and EAC

Distinguish true physical progress from raw budget burn using Cost Performance Index (CPI = EV / AC), Schedule Performance Index (SPI = EV / PV), and EAC.

Read the guide →
Project Controls & Earned Value Management

Earned Value TCPI & Lipke Earned Schedule Formula

Audit unrecoverable cost overruns via To-Complete Performance Index TCPI = (BAC - EV) / (BAC - AC) and fix late-project SPI = 1.00 convergence distortion with Walt Lipke’s Earned Schedule SPI(t) = ES / AT.

Read the guide →
International Trade & Quantitative Macroeconomics

Eaton-Kortum Trade Share & ACR Gains-from-Trade Formula

Compute multi-country Eaton-Kortum Fréchet import shares pi_ni = T_i*(c_i*d_ni)^(-theta) / Phi_n and Arkolakis-Costinot-Rodríguez-Clare welfare gain pi_nn^(-1/theta).

Read the guide →
Structural Mechanics, Column Stability & Non-Linear P-Delta Bending

Eccentric Column Secant Formula Max Compressive Stress

Calculate Eccentric Column Direct Axial Stress P/A (MPa), Stability Secant Angle (rad), Exact Secant Maximum Fiber Compressive Stress (MPa), and Naive Linear Stress Without P-Delta (MPa).

Read the guide →
Chemical, Process & Catalysis Engineering

Eckert GPDC Packed-Column Flooding Formula: Flow Parameter F_LV & Tower Diameter

Size random and structured packed absorption, stripping, and distillation towers using Sherwood-Eckert Generalized Pressure Drop Correlation (GPDC) Flow Parameter F_LV = (L / G) * SQRT(rho_G / rho_L), Flooding Gas Velocity u_flood, and Column Diameter.

Read the guide →
Operations

Economic Production Quantity (EPQ) Finite-Rate Lot-Size Formula

Calculate an idealized finite-rate production lot, peak inventory and annual setup-plus-holding cost, deriving daily demand from annual demand on a consistent operating-day basis.

Read the guide →
Finance

Economic Value Added (EVA), NOPAT & ROIC vs WACC Economic Spread

Calculate Net Operating Profit After Tax NOPAT = EBIT * (1 - Tax), Economic Value Added EVA = NOPAT - (Invested_Capital * WACC), and the ROIC - WACC value-creation spread.

Read the guide →
Dates and reporting

EDATE function: add calendar months and handle month-end clipping

Schedule monthly equipment checks from a start date with EDATE, and see why anchoring offsets to the original start date preserves the 31st after February.

Read the guide →
Science

Eddington Luminosity Limit & Black-Hole Accretion Rate Formula

Compute a hydrogen electron-scattering Eddington luminosity and the associated rest-mass inflow at a chosen radiative efficiency, using consistent luminosity units and retaining very small nonzero rates.

Read the guide →
Powertrain Test Cells & Driveline Braking, Eddy-Current Dynamometer & Retarder Physics

Eddy-Current Dynamometer Torque, Critical RPM & Cooling

Calculate Speed Ratio (N / Ncrit), Kloss-Type Skin-Effect Braking Torque (N·m), Absorbed Rotor Thermal Power (kW), and Required Cooling-Water Flow at 25 K Rise (L/min).

Read the guide →
Power Electronics, Ultracapacitor Energy Storage & Pulse-Power Sizing

EDLC Supercapacitor 75% Usable Energy & ESR Drop Formula

Calculate Electric Double-Layer Supercapacitor (EDLC) Usable Extractable Energy (Wh) Between V_max and Converter Cutoff V_min, Usable Energy Fraction (75% at 0.5*V_max), Instantaneous ESR Voltage Sag (V), and Matched-Impedance Peak Power (kW).

Read the guide →
Statistical & Clinical Analysis

Edmonton Frail Scale: Background and Permission to Use

An overview of the Edmonton Frail Scale, its assessment context and the developer’s permission and licensing information.

Read the guide →
Financial

EFFECT function: convert stated APR into effective annual interest rate (APY)

Compare loan or savings offers with different compounding frequencies on an apples-to-apples annual basis using EFFECT.

Read the guide →
Finance

Effective Duration & Key-Rate Duration (Callable Bond Finite Difference)

Calculate effective duration, convexity and individual key-rate sensitivities from supplied repriced bond values, with a reproducible three-tenor example and input validation.

Read the guide →
Lookup & Reference

Effective-Date Rate & Price Lookup by Transaction Date (XLOOKUP Mode -1 & VLOOKUP)

Resolve the historical price, billing rate, or FX rate in effect on any transaction date using XLOOKUP with match_mode = -1 (exact or next earlier effective date) while guarding dates prior to contract inception.

Read the guide →
Statistical & Clinical Analysis

Egger’s Linear Regression Test: Funnel Plot Asymmetry & Small-Study Publication Bias

Detect small-study publication bias in meta-analysis by regressing Standardized Normal Deviate SND_i = θ_i / SE_i on Precision P_i = 1 / SE_i via INTERCEPT and SLOPE.

Read the guide →
Consumer Panel Analytics & Brand Growth Science

Ehrenberg NBD Brand Penetration & Double Jeopardy Formula

Calculate Andrew Ehrenberg’s Negative Binomial Distribution (NBD) Non-Buyer Share P_0 = (1 + m/k)^(-k), Household Penetration b = 1 - P_0, Average Purchase Frequency per Buyer w = m/b, and Duplication of Purchase D*b_Y.

Read the guide →
Engineering & Science

Einstein Quantum Solid Molar Heat Capacity (CV) vs. Dulong-Petit 3R Limit

Calculate quantized lattice molar heat capacity C_V = 3 * R * (theta_E / T)^2 * EXP(theta_E / T) / (EXP(theta_E / T) - 1)^2 (J/(mol*K)) and % of the classical Dulong-Petit 3R = 24.943 J/(mol*K) limit.

Read the guide →
Civil, Structural & Geotechnical Engineering

Einstein-Brown Bedload Transport Formula: Stochastic Low-Shear & 40 * theta^3 Law

Calculate river and coastal bedload transport intensity Phi across stochastic incipient saltation (theta < 0.18) and sheet-flow high-shear transport (Phi = 40 * K_R * theta^3) using Hans Albert Einstein (1942) and Carl B. Brown (1950).

Read the guide →
Healthcare & Clinical Calculations

El-Ganzouri Airway Research: Seven Components and a Point Sum

Explore a seven-component airway research index and practice adding already-assigned integer points.

Read the guide →
Fluid-Power Sealing, Parker / AS568 Elastomer O-Ring Glands, Squeeze & Extrusion

Elastomer O-Ring Squeeze % & Gland Fill Swell Formula

Calculate Linear Diametral Interference Squeeze (mm), Percentage Cross-Sectional Squeeze (%), Swollen-Elastomer Rectangular Gland Fill (%), and Parker Static Gland Compliance.

Read the guide →
Engineering

Electricity kWh and utility cost calculator formula (Watts to $ bill)

Estimate energy use and the energy component of a bill from average input power, operating hours and a flat tariff.

Read the guide →
Turbine-Blade Superalloy Non-Traditional Machining, ECM Faraday Equilibrium Gap & Joule Boil

Electrochemical Machining (ECM) Gap & Brine Boiling Formula

Calculate Anodic Dissolution Current Density J (A/cm²), Self-Regulating Equilibrium Inter-Electrode Gap heq (mm), Total Rectifier Current (A), and Brine Joule Temperature Rise (°C).

Read the guide →
Engineering & Science

Electron-Positron Pair & Triplet Production Gamma Threshold Formula

Evaluate gamma-ray nuclear pair-production threshold (2 * m_e * c^2 = 1.022 MeV), atomic-electron triplet-production threshold (4 * m_e * c^2 = 2.044 MeV), and total lepton kinetic energy K_e- + K_e+ = E_gamma - 1.022 MeV.

Read the guide →
Nanomaterials, HEPA Filtration & Tissue Scaffolds, Taylor-Cone Electrospinning

Electrospinning Taylor-Cone Critical Voltage & GSM Formula

Calculate G. I. Taylor Critical Cone-Jet Onset Voltage Vc (kV), Mean Inter-Electrode Field Vc/H (kV/cm), Dry Nanofiber Production Rate (g/h), and Nonwoven Mat GSM (g/m²).

Read the guide →
Chemical, Process & Catalysis Engineering

Eley-Rideal Catalytic Rate Law Formula & Apparent Reaction Order Diagnostic

Compute Daniel Eley and Eric Rideal’s (1940) gas-surface collision rate r_ER = k_ER * K_A * P_A * P_B / (1 + K_A * P_A) and Apparent Reaction Order n_app,A = 1 / (1 + K_A * P_A) to distinguish Eley-Rideal from Langmuir-Hinshelwood kinetics.

Read the guide →
Healthcare & Clinical Calculators

Elixhauser Comorbidity Research: Weighted Subtotal in Excel

Learn the purpose and limitations of the van Walraven administrative-data score and practice SUMPRODUCT using six illustrative weights.

Read the guide →
VLSI Physical Design & Semiconductor Interconnects

Elmore RC Wire Delay & Repeater Insertion Formula

Calculate Distributed-Line Elmore RC Time Constant tau_D, 50% Propagation Delay t_p50 = 0.69 * tau_D, Naive Lumped-RC Overprediction Error, and Bakoglu Optimal CMOS Repeater Count.

Read the guide →
Operations, Logistics & Engineering

Elovich (Roginsky-Zeldovich) Chemisorption Kinetics Formula: Uptake q(t) & Rate Decay

Model activated chemisorption on energetically heterogeneous catalysts, biochars, and soils using the integrated Elovich kinetic equation q(t) = (1 / beta) * LN(1 + alpha * beta * t) and instantaneous rate dq/dt = alpha * EXP(-beta * q).

Read the guide →