Learn one useful thing today.
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 SeparationDeutsch-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 DevelopmentDevelopment 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 →StatisticalDevine 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 →EngineeringDew 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 →LogicalDiagnose & 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 & ReferenceDiagnose 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 AnalysisDiagnostic 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 →StatisticalDiagnostic 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 IntermediationDiamond 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 StabilityDiamond-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 DistributionDiamond-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 ControlDie-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 PlanningDiebold-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 InferenceDifference-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-LockingDifferential 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 EngineeringDifferential 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 →EngineeringDilution (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 →MathDimensional 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/DragDirectional 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 →FinancialDiscount 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 & DerivativesDiscrete 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 & AggregationDiscrete 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 HydraulicsDisinfection 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 & MacroeconomicsDisinflation 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 →LogicalDisplay 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 ThickeningDissolved 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 →EngineeringDistance 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 TCCDistribution 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 →EngineeringDittus–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 DataDiverging 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 →FinancialDividend 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 OrganizationDixit-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 EngineeringDoherty 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 & AccountingDollar-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 & TradingDonchian 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 →EngineeringDoppler 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 EconomicsDorfman-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 & FXDornbusch 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 VisualizationDot 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 & EngineeringDouble 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 LearningDoubly 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 DataDoughnut 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 LossDowell 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 & DerivativesDown-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 AnalysisDownes 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 EngineeringDowson-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 AnalysisDRAGON 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 DesignDrilled & 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 DensityDrilling 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 →