Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Clinical Medicine & Physiology

Deurenberg BMI Equations: Age- and Sex-Specific Body-Fat Estimates

Explore the original Deurenberg equations for estimating body-fat percentage from BMI, age and the study’s sex groups, with clear limits on what the numbers mean.

Read the guide →
Air Pollution Control, Power-Plant Flue Gas & Electrostatic Separation

Deutsch-Anderson Electrostatic Precipitator (ESP) SCA Formula

Calculate Electrostatic Precipitator Specific Collection Area (s/m), Deutsch-Anderson Collection Efficiency (%), Outlet Stack Dust Concentration (mg/m³), and Plate Area Required for 99.9% Removal (m²).

Read the guide →
Commercial Real Estate Development

Development Yield-on-Cost & Interest Reserve Formula

Solve Construction Loan Interest Reserve IR = (k * C_hs) / (1 - k) without circular spreadsheet references, Total Project Cost, Stabilized Yield on Cost (YoC), and Development Spread.

Read the guide →
Statistical

Devine weight, an adjusted-weight example and predicted body weight

Compare distinct weight equations with explicit units and assumptions; demonstrate why similarly named estimates should not be substituted blindly.

Read the guide →
Engineering

Dew Point temperature formula (Magnus equation) & condensation risk check

Estimate dew point over liquid water from air temperature and relative humidity using a Magnus approximation.

Read the guide →
Logical

Diagnose & Prevent #NUM!, #REF!, and #NAME? Formula Errors

Prevent #NUM! domain errors (negative SQRT/LOG or k > COUNT in LARGE/SMALL), #REF! out-of-bounds INDEX lookups, and #NAME? unquoted strings or function typos using proactive boundary guards.

Read the guide →
Lookup & Reference

Diagnose XLOOKUP #N/A: Text Numbers and Unwanted Spaces

Test a deliberate text-first, numeric-fallback lookup policy, distinguish true text from numeric cell entry, and avoid silently changing meaningful identifiers.

Read the guide →
Statistical & Clinical Analysis

Diagnostic meta-analysis: an illustrative ESS-weighted Deeks regression slope

Calculate Deeks effective sample size and an illustrative weighted regression slope; a slope alone is not a publication-bias test.

Read the guide →
Statistical

Diagnostic Sensitivity, Specificity, Youden's J & Likelihood Ratios (LR+/LR-)

Calculate sensitivity, specificity, Youden’s J and likelihood ratios from a fictional binary-classification table, with explicit checks for undefined ratios.

Read the guide →
Banking & Financial Intermediation

Diamond Delegated Monitoring & Diversification Formula

Calculate Douglas Diamond’s (1984) delegated-monitoring cost advantage of a diversified bank over duplicated direct saver monitoring (m*K) and unmonitored debt.

Read the guide →
Banking, Liquidity & Financial Stability

Diamond-Dybvig Bank-Run Threshold & Liquidity Formula

Solve the Diamond-Dybvig optimal risk-sharing deposit contract (c_1*, c_2*), liquid reserve share t * c_1*, and critical withdrawal fraction f_crit* triggering a rational bank run.

Read the guide →
Public Economics & Income Distribution

Diamond-Saez Optimal Top Marginal Rate & Pareto Formula

Estimate the Pareto income tail index a = z_bar / (z_bar - z*) and compute the Diamond-Saez optimal top bracket rate tau* = (1 - g) / (1 - g + a * e).

Read the guide →
High-Pressure Die Casting (HPDC), NADCA P-Q^2 Gating & Cold-Chamber Shot Control

Die-Casting Gate Area, Cavity Fill Time & Plunger Speed Formula

Calculate Cavity+Overflow Melt Volume (cm³), Volumetric Injection Flow Rate Q (cm³/s), Required Ingate Cross-Sectional Area A_g (mm²), and Cold-Chamber Fast-Shot Plunger Speed (m/s).

Read the guide →
Forecasting & Demand Planning

Diebold-Mariano and HLN Forecast Accuracy Test Formula

Test whether two competing models have equal out-of-sample forecast accuracy using Diebold-Mariano loss differentials d_t and Harvey-Leybourne-Newbold’s finite-sample correction.

Read the guide →
Econometrics & Causal Inference

Difference-in-Differences (DiD) Causal Estimator and Pre-Trend Check

Calculate the canonical 2x2 Difference-in-Differences ATT = (Y_T,post - Y_T,pre) - (Y_C,post - Y_C,pre), counterfactual level, and pre-intervention placebo trend test.

Read the guide →
Machine Design, Hoist & Drawworks Differential Band Brakes & Self-Locking

Differential Band Brake Force & Self-Locking Check Formula

Calculate Euler Band Tension Ratio exp(mu*theta), Tight & Slack Band Tensions T1 & T2 (N), Differential Lever Actuating Force F (N), and Self-Locking Grab Detection.

Read the guide →
Chemical, Process & Catalysis Engineering

Differential Batch Distillation Formula: Remaining Still Pot Moles W & Composite Purity x_D

Calculate remaining kettle liquid W (mol), boiled-off overhead distillate D = F - W, and pooled composite distillate purity x_D,avg in single-stage constant-alpha batch distillation via Lord Rayleigh’s (1902) integrated VLE material balance.

Read the guide →
Engineering

Dilution (C1*V1 = C2*V2) and two-stock blending (Pearson Square) formulas

Calculate a stock volume from concentration balance and illustrate two-stock blending under an additive-volume assumption.

Read the guide →
Math

Dimensional Weight (DIM Weight) vs. Actual Weight billable shipping formula

Compare dimensional and scale weight using a supplied divisor and an explicit whole-pound rounding assumption.

Read the guide →
Petroleum & Geothermal Wellbore Surveying, MWD Directional Drilling & Torque/Drag

Directional Drilling Dogleg Severity & Minimum Curvature Formula

Calculate 3D Spherical Dogleg Angle beta (deg), Normalized Dogleg Severity DLS (deg/30 m), Minimum-Curvature Ratio Factor RF, and True Vertical Depth Step Delta_TVD (m).

Read the guide →
Financial

Discount irregular dated cash flows on a 365-day basis

Discount cash flows arriving on exact irregular calendar dates using SUM(CashFlows / ((1 + Rate) ^ ((Dates - StartDate) / 365))).

Read the guide →
Quantitative Finance & Derivatives

Discrete Geometric Asian Option and Arithmetic Forward Moment Formula

Price discrete n-fixing Geometric Asian calls exactly via Kemna-Vorst volatility scaling and compute the Turnbull-Wakeman discrete arithmetic forward mean M1.

Read the guide →
Statistical & Aggregation

Discrete Probability Mass Interval, Expected Value & Variance (PROB & SUMIFS)

Validate discrete probability mass tables (sum = 1, non-negative weights), calculate interval probabilities P(L <= X <= U) via SUMIFS (PROB), and compute distribution mean and standard deviation.

Read the guide →
Drinking-Water Disinfection, US EPA SWTR & Clearwell Hydraulics

Disinfection Contact Time and CT: A Clearwell Arithmetic Example

Calculate theoretical detention time, an illustrative baffling-adjusted contact time and CT, while distinguishing these values from regulatory disinfection credit.

Read the guide →
Monetary Policy & Macroeconomics

Disinflation Sacrifice Ratio & Okun Misery Index Formula

Calculate Laurence Ball’s (1994) Disinflation Sacrifice Ratio SR = Cum_Output_Loss / (pi_peak - pi_trough), Unemployment Point-Years per 1-pp disinflation, and Arthur Okun’s Misery Index.

Read the guide →
Logical

Display a Checkmark When Checklist Conditions Pass

Use a literal Unicode checkmark with validated reviewer text and a 0–100 score. Calculate completion from the same row-status results so badges and progress agree.

Read the guide →
Industrial Wastewater, Dissolved Air Flotation & Sludge Thickening

Dissolved Air Flotation (DAF) Air-to-Solids Ratio Formula

Calculate DAF Saturator Net Released Air Factor (f*P - 1), Released Microbubble Air Concentration (mg/L), Mass Air-to-Solids Ratio A/S (kg air / kg TSS), and Recycle Pump Flow (m³/hr).

Read the guide →
Engineering

Distance formula: 2D and 3D Euclidean vs Manhattan grid distance

Calculate straight-line Pythagorean distance in 2D or 3D space with SQRT, and compare right-angle warehouse aisle distance with ABS.

Read the guide →
Overhead Utility Distribution Protection, IEEE C37.60 Auto-Recloser & Expulsion Fuse TCC

Distribution Recloser Fuse-Saving Coordination Formula

Calculate Fast-Trip Fault Joule Let-Through I²t (kA²·s), Fast-Clear-to-Fuse-MMT Ratio (<= 0.75), Slow-Curve-to-Fuse-TCT Backup Ratio (>= 1.35), and Fuse-Saving Margin (ms).

Read the guide →
Engineering

Dittus–Boelter and Gnielinski: Pipe Nusselt Number and Heat Transfer

Compare two turbulent circular-tube correlations, validate their input ranges and compute h from unrounded Nusselt values.

Read the guide →
Charts & Visual Data

Diverging Likert Stacked Bar Chart Formula: Neutral Midpoint Split & Padding Spacer

Align 5-point Likert survey responses around a vertical zero spine on a 100% Stacked Bar Chart by splitting Neutral responses in half and computing each row’s exact left-padding spacer.

Read the guide →
Financial

Dividend Yield, Yield on Cost, Payout Ratio, and Sustainable Growth (g)

Evaluate dividend stocks with Current Yield, Yield on Original Cost Basis, Earnings Payout Ratio, and Sustainable Growth Rate ROE * (1 - Payout).

Read the guide →
Strategic Competition & Industrial Organization

Dixit-Spence Capacity Commitment & Entry Deterrence

Calculate Avinash Dixit’s (1980) entry-deterring limit capacity K_det = (a - w - r - 2*SQRT(b*F)) / b and audit subgame-perfect credibility against K_max = (a - w + r) / (3*b).

Read the guide →
5G Wireless RF Front-End & Base-Station Engineering

Doherty RF Amplifier Back-Off Efficiency & PAPR Formula

Calculate OFDM Peak-to-Average Crest Ratio P_peak / P_avg, Classical Class-B Back-Off Drain Efficiency (PI()/4)*SQRT(P_avg/P_peak), Symmetric 2-Way Doherty Load-Modulated Efficiency, and DC Heat-Loss Saving Ratio.

Read the guide →
Financial & Accounting

Dollar-Cost Averaging (DCA) Formula: Harmonic Average Cost Basis & Unrealized Gain

Calculate exact share-weighted Dollar-Cost Averaging cost basis SUM(Invested) / SUMPRODUCT(Invested / Share_Price)—showing why fixed-dollar contributions beat the arithmetic average share price—plus unrealized P&L.

Read the guide →
Quantitative Finance & Trading

Donchian Channel & Turtle Position Sizing Formula: N-Bar High/Low Midpoint & 1% Risk Unit

Compute Richard Donchian’s N-period breakout channel (MAX High, MIN Low, Equilibrium Midpoint) paired with Dennis & Eckhardt’s volatility-parity 1% ATR Unit Size.

Read the guide →
Engineering

Doppler Effect frequency shift & compressed sound wavelength formula

Calculate observed acoustic frequency f_obs = f_src * (c + v_obs) / (c - v_src) and wavefront wavelength for approaching vs. receding sound sources.

Read the guide →
Marketing Analytics & Managerial Economics

Dorfman-Steiner Optimal Advertising-to-Sales Ratio Formula

Size profit-maximizing advertising spend A* / Revenue = e_A / |e_P| = ((P - MC) / P) * e_A using the Dorfman-Steiner theorem in Excel and Arte Sheets.

Read the guide →
International Macroeconomics & FX

Dornbusch Exchange-Rate Overshooting Model Formula

Calculate impact FX depreciation Delta_e0 = Delta_m * (1 + 1 / (lambda * theta)), overshoot ratio, liquidity interest-rate drop, and exponential convergence path.

Read the guide →
Charts & Data Visualization

Dot Plot Formula: Wilkinson Vertical Stack Y-Index & Cleveland Category Dot Gap

Build Wilkinson stacked frequency dot plots using an expanding running-occurrence counter COUNTIF($B$2:B2, B2) for Scatter Y coordinates, plus William S. Cleveland’s category-comparison dot gap and relative advantage.

Read the guide →
Math & Engineering

Double Factorial n!! & Perfect-Matching Pairings (SEQUENCE & PRODUCT)

Calculate the double factorial n!! for odd and even non-negative integers using PRODUCT and SEQUENCE, and count distinct ways to pair 2k items into k unordered pairs.

Read the guide →
Causal Inference & Machine Learning

Doubly Robust Augmented IPW (AIPW) Treatment Effect Formula

Build Robins-Rotnitzky-Zhao doubly robust AIPW pseudo-outcomes psi_i = (m_1 - m_0) + D*(Y - m_1)/e - (1 - D)*(Y - m_0)/(1 - e) and verify consistency when either nuisance model is misspecified.

Read the guide →
Charts & Visual Data

Doughnut Progress Ring Formula: Clamped Fill, Remainder Arc & Over-Target Guard

Prevent broken Doughnut Progress Charts when attainment exceeds 100% by clamping the unfilled remainder slice with MAX(0, 1 - Actual/Goal) instead of raw 1 - Actual/Goal.

Read the guide →
Power Magnetics, High-Frequency Planar Transformers & Eddy-Current Proximity Loss

Dowell Transformer AC Winding Resistance (Fr) & Proximity Loss

Calculate High-Frequency Transformer Normalized Foil Thickness Δ = h / δ, Dowell Sub-Skin AC-to-DC Resistance Ratio Fr = 1 + ((5*m² - 1)/45)*Δ⁴, DC Copper Loss (W), and Total AC Winding Loss Before and After P-S-P-S Layer Interleaving.

Read the guide →
Quantitative Finance & Derivatives

Down-and-Out Barrier Call Formula and Knock-In/Knock-Out Parity

Price continuous zero-rebate Down-and-Out Calls (H < K, S > H) via the Merton / Reiner-Rubinstein reflection principle and verify exact Down-and-In + Down-and-Out = Vanilla parity.

Read the guide →
Statistical & Clinical Analysis

Downes Respiratory Score: Adding Pre-Assessed Neonatal Signs

Add five pre-assessed neonatal respiratory sign scores in a spreadsheet, and understand why the total cannot determine respiratory support on its own.

Read the guide →
Tribology & Mechanical Engineering

Dowson-Higginson EHL Line-Contact Minimum Film Thickness Formula

Calculate elastohydrodynamic lubrication (EHL) dimensionless speed U, materials G, load W, and minimum film thickness h_min = 2.65 * R_eq * U^0.70 * G^0.54 * W^(-0.13) in microns.

Read the guide →
Statistical & Clinical Analysis

DRAGON Stroke Research: Six Components and a Point Sum

Review the six components used in the DRAGON research score and practice adding already-assigned points.

Read the guide →
Deep Foundations & Seismic Underpinning, FHWA Drilled & Grouted Micropile Design

Drilled & Grouted Micropile Bond & Structural Load Formula

Calculate Ultimate Grout-to-Ground Bond Capacity (kN), Allowable Geotechnical Bond Load (FS = 2.0, kN), Composite Casing+Grout Structural Capacity (kN), and Governing Load.

Read the guide →
Petroleum & Geothermal Wellbore Hydraulics, API Hole Cleaning & Equivalent Circulating Density

Drilling Annular Velocity, Cuttings Transport & ECD Formula

Calculate Open-Hole Annular Mud Velocity Va (m/min), Net Upward Cuttings Rise Velocity (m/min), Sifferman Cuttings Transport Ratio Ft (%), and Equivalent Circulating Density ECD (SG).

Read the guide →