Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Engineering & Science

Wannier-Mott Exciton Binding Energy (meV) & Exciton Bohr Radius (nm)

Calculate semiconductor electron-hole exciton binding energy E_b = 13605.7 * (μ / m_0) / ε_r^2 (meV) and exciton Bohr radius a_B^* = 0.052918 * ε_r / (μ / m_0) (nm) to determine room-temperature exciton stability and quantum-dot confinement size.

Read the guide →
Game Theory & Competitive Strategy

War of Attrition Quit Hazard & Duration Formula

Calculate the Maynard Smith / Bishop-Cannings War of Attrition mixed equilibrium quit hazard h* = c / ((N - 1)*V), expected standoff duration, and survival probability EXP(-N*h**t).

Read the guide →
Warehouse Design & Supply Chain Operations

Warehouse Block-Stacking Optimal Lane Depth Formula

Calculate John Bartholdi and Steven Hackman’s optimal floor-stacking pallet lane depth d* = SQRT((a * N) / (2 * z)) balancing cross-aisle waste against honeycombing unoccupied pallet positions.

Read the guide →
Distribution Center Design, Cross-Dock Yard Logistics & Trailer Turnaround Sizing

Warehouse Receiving & Shipping Dock-Door Sizing Formula

Calculate Base Daily Trailer Door-Hours, Surge-Buffered Peak Door-Hours, Fractional Dock-Door Requirement, and Integer Dock-Bay Count.

Read the guide →
Charts & Data Visualization

Waterfall (Bridge) Chart Formula: Invisible Base, Up/Down Steps & Grounded Pillars

Build a universal Stacked-Column Waterfall / Financial Bridge Chart (Revenue-to-EBITDA, Budget-to-Actual, Headcount Bridge) using exact formulas for Running Balance, Invisible Pedestal Base, Positive Lift, and Negative Drag.

Read the guide →
Healthcare & Clinical Formulas

Waterlow Pressure Injury Risk: Context and a Spreadsheet Addition Exercise

Learn how a Waterlow assessment supports clinical judgment and practice validating a separate set of fictional values without assigning equipment from a score.

Read the guide →
Engineering & Science

Watson Correlation: Latent Heat of Vaporization vs Temperature

Scale enthalpy of vaporization ΔH_vap(T_2) = ΔH_vap(T_1) * ((T_c - T_2) / (T_c - T_1))^0.38 (kJ/mol) from normal boiling point up to high-pressure boiler conditions near the critical point.

Read the guide →
Clinical Medicine & Physiology

Watson Total Body Water Equations: An Anthropometric Estimate

Explore the Watson adult total body water equations and distinguish a population estimate from an individual hydration measurement.

Read the guide →
Economics & Market Microstructure

Watts Poverty Index Formula & Morduch Average Time-to-Exit Poverty Calculator

Calculate Harold Watts’s (1968) distribution-sensitive logarithmic poverty index W = (1 / N) * SUMy_i < z LN(z / y_i) and Jonathan Morduch’s (1998) expected years to exit poverty t_exit = W / g.

Read the guide →
Network Science & Graph Analytics

Watts-Strogatz Clustering & Friendship Paradox Formula

Calculate Watts-Strogatz (1998) node local clustering 2*T_i / (k_i*(k_i - 1)) and prove Scott Feld’s (1991) Friendship Paradox <k_nn> = SUMPRODUCT(k, k) / SUM(k) >= AVERAGE(k).

Read the guide →
Econometrics & Causal Inference

Weak-Instrument First-Stage F and Stock-Yogo 2SLS Bias Formula

Compute the excluded-instrument first-stage partial F-statistic, concentration parameter mu^2 = L_excl * F, and approximate 2SLS relative bias toward OLS 1 / (F + 1).

Read the guide →
Transportation Engineering & Urban Mobility

Webster Traffic Signal Cycle & Green Split Formula

Minimize intersection delay using F. V. Webster’s (1958) optimal cycle length C_opt = (1.5 * L + 5) / (1 - Y), critical flow-ratio sum Y = SUM(q_i / s_i), and proportional effective green splits.

Read the guide →
Dates and reporting

WEEKDAY function: use return_type 2 to flag Saturday and Sunday cleanly

Switch WEEKDAY from its Sunday-first default to Monday-first numbering (return_type = 2) so Saturday (6) and Sunday (7) share a single >= 6 weekend test.

Read the guide →
Dates & Time

WEEKNUM Return Types Explained: Sunday System 1 vs. Monday System 2 vs. ISO 8601

Reconcile North American January-1 Sunday weeks (WEEKNUM type 1), Monday-start January-1 weeks (type 2), and European ISO 8601 Thursday-anchored weeks (type 21) using exact DATE and WEEKDAY arithmetic.

Read the guide →
Engineering

Weibull Reliability: Survival R(t), Hazard Rate & B10 Bearing Life

Calculate two-parameter Weibull survival, cumulative failure probability, hazard rate and B10 life, with explicit handling of zero time and invalid inputs.

Read the guide →
Health & Fitness

Weight-Based Infusion Unit Conversion: mcg/kg/min and mL/hr

Learn dimensional analysis with a fictional infusion calculation: derive concentration from total drug and final volume, convert a supplied dose rate, and independently enter a rate for the reverse calculation.

Read the guide →
Working with averages

Weighted average in Excel: calculate unit cost with SUMPRODUCT

Three deliveries have different quantities and unit prices. Calculate the cost of one average unit, check it against the invoice totals, and handle a list with no units.

Read the guide →
Math & Trig

Weighted average with multiple criteria (SUMPRODUCT + SUMIFS)

Calculate volume-weighted unit price or yield strictly for rows matching Region, Channel, or Status filters.

Read the guide →
Statistical

Weighted Moving Average (WMA) formula: emphasize recent demand

React faster to trend turns than a simple moving average by weighting trailing observations linearly {1;2;3} inside SUMPRODUCT.

Read the guide →
Statistical

Weighted random assignment & Monte Carlo lookup (cumulative lower bounds)

Sample categories with unequal probabilities (e.g., 60% Standard, 30% Silver, 10% Gold) by matching a [0, 1) draw against cumulative lower thresholds.

Read the guide →
Math & Trig

Weighted vendor evaluation scorecard (SUMPRODUCT decision matrix)

Score competing RFP vendors across Price, Security, Support, and SLA weights using locked SUMPRODUCT($B$2:$B$5, VendorCol) / SUM($B$2:$B$5).

Read the guide →
Clinical Medicine & Physiology

Weir Equation: Gas Exchange, Urinary Nitrogen and Energy Expenditure

Explore abbreviated and nitrogen-adjusted Weir calculations with explicit units and understand the limits of interpreting the gas-exchange ratio.

Read the guide →
Engineering & Science

Weisz-Prater Criterion (CWP): Observable Internal Pore Diffusion Check

Diagnose internal catalyst pore diffusion limitations directly from measured laboratory reaction rate (-r_A')_obs without knowing intrinsic rate constant k via C_WP = (-r_A')_obs * ρ_c * R^2 / (D_e * C_As).

Read the guide →
Environmental Economics & Regulatory Design

Weitzman Prices vs. Quantities Instrument Choice Formula

Evaluate Martin Weitzman’s (1974) comparative advantage Delta_(P-Q) = sigma^2 * (C_slope - B_slope) / (2 * C_slope^2) between Pigouvian emission fees and tradable quantity caps.

Read the guide →
Clinical Pharmacokinetics & Drug Metabolism

Well-stirred hepatic clearance and first-pass model

Explore hepatic extraction, blood clearance and the fraction escaping hepatic first-pass elimination in a simplified well-stirred model.

Read the guide →
Indoor Air Quality, Bioaerosols & Hospital Epidemiology

Wells–Riley Model: An Illustrative Airborne-Exposure Calculation

Calculate a simplified Wells–Riley quanta dose, model probability and expected cases while keeping the steady-state and well-mixed assumptions explicit.

Read the guide →
Engineering & Science

Wen-Yu Minimum Fluidization Velocity (u_mf) & Archimedes Number Formula

Calculate the dimensionless particle Archimedes number Ar = (d_p^3 * rho_f * (rho_p - rho_f) * g) / mu^2, Wen-Yu Reynolds number Re_mf = SQRT(33.7^2 + 0.0408 * Ar) - 33.7, and superficial minimum fluidization velocity u_mf.

Read the guide →
Engineering & Scientific

Wenner Four-Pin Soil Resistivity (IEEE 81) & Dwight Ground-Rod Resistance

Convert four-point Wenner earth-tester readings into exact buried-probe and shallow-limit soil resistivity (ohm-m), then size single vertical grounding rod resistance via Dwight’s formula.

Read the guide →
Engineering & Science

Wenzel vs Cassie-Baxter Rough-Surface & Superhydrophobic Contact Angle

Calculate apparent droplet contact angle on textured surfaces in both the pinned Wenzel state cos(θ_W) = r * cos(θ_Y) and the lotus-leaf air-pocket Cassie-Baxter state cos(θ_CB) = f_s * (cos(θ_Y) + 1) - 1.

Read the guide →
Civil, Structural & Geotechnical Engineering

Westergaard Rigid Concrete Slab Formula: Radius of Relative Stiffness l & Corner Stress

Design concrete highway pavements and industrial warehouse slabs-on-grade using Harald M. Westergaard’s (1926) Radius of Relative Stiffness l = ((E * h^3) / (12 * (1 - mu^2) * k))^0.25 and Corner Wheel Tensile Stress sigma_c.

Read the guide →
Biostatistics & Epidemiology

Westgard Six-Sigma Laboratory Quality Metric: (TE_a% - |Bias%|) / CV% & QC Rules

Evaluate clinical analyzer analytical performance and select optimal Westgard Statistical Quality Control (SQC) rules using James O. Westgard’s Sigma-Metric equation Sigma = (TE_a% - ABS(Bias%)) / CV%.

Read the guide →
Healthcare & Clinical

Westley Croup Score: An Educational Point-Counting Example

Practice summing five illustrative Westley subscores with valid point values; this worksheet does not diagnose croup or select treatment.

Read the guide →
Occupational Health, Industrial Hygiene & Sports Medicine (ISO 7243)

Wet-Bulb Globe Temperature (WBGT): Indoor and Outdoor Arithmetic

Calculate example WBGT values from natural wet-bulb, globe and air temperatures, and understand why a heat-safety assessment needs more than a single number.

Read the guide →
Healthcare & Clinical Formulas

WFNS subarachnoid hemorrhage grades: a spreadsheet exercise

Explore a WFNS grading table with GCS, assessed focal deficit and explicitly handled source differences.

Read the guide →
Corporate Treasury & Liquidity Management

Whalen Precautionary Cash Cube-Root Reserve Formula

Calculate Whalen’s Optimal Precautionary Cash Buffer M* = ((2 * sigma^2 * c_ill) / r)^(1/3), Foregone Interest Holding Cost, Chebyshev Expected Shortage Penalty Bound, and Total Precautionary Cost.

Read the guide →
Engineering

Wheatstone Bridge Differential Voltage & Strain-Gauge Null Balance formulas

Calculate sensor bridge output Vout = Vex * (R3/(R1+R3) - R4/(R2+R4)) in millivolts and solve unknown resistance Rx = R3 * (R2 / R1) at null balance.

Read the guide →
Chemical, Process & Catalysis Engineering

Wheeler Catalyst Poisoning Formula: Uniform vs Selective Pore-Mouth Activity Ratio F

Predict heterogeneous catalyst deactivation severity when fraction alpha_p of active sites is poisoned using Ahlborn Wheeler’s (1951) Uniform Poisoning Ratio F_unif and Selective Pore-Mouth ("Shell") Poisoning Ratio F_mouth across Thiele modulus h_0.

Read the guide →
Engineering & Science

Whitaker Sphere Convection Correlation: External Flow Nusselt & Viscosity Correction

Calculate forced-convection heat transfer over spheres Nu_D = 2 + (0.4*Re^(1/2) + 0.06*Re^(2/3))*Pr^0.4*(μ_∞/μ_s)^(1/4) for spray drying, pellet cooling, and pebble beds.

Read the guide →
Engineering & Science

Wiedemann-Franz Law & Sommerfeld Lorenz Number (Metal Thermal Conductivity)

Calculate the electronic thermal conductivity kappa_e = L0 * sigma * T in W/(m*K) from electrical conductivity sigma using the Sommerfeld Lorenz number L0 = 2.44e-8 W*Ohm/K^2, and extract the empirical Lorenz ratio L = kappa / (sigma * T).

Read the guide →
Science

Wien's Displacement Law: Peak Blackbody Wavelength & Temperature

Calculate the wavelength-domain blackbody peak in nanometres or micrometres, invert a measured peak to an ideal blackbody temperature, and compare it with an explicitly chosen visible interval.

Read the guide →
Math & Statistical

Wilcoxon Signed-Rank Paired Nonparametric Test (W, Mean & Z-Score)

Calculate the paired Wilcoxon Signed-Rank statistic W = MIN(W_plus, W_minus), null expectation mu_W = n*(n+1)/4, standard deviation sigma_W = SQRT(n*(n+1)*(2*n+1)/24), and normal-approximation Z-score.

Read the guide →
Engineering & Science

Wilke Gas Mixture Viscosity Formula: Kinetic-Theory Binary φ_ij Parameter

Calculate Charles R. Wilke’s (1950) kinetic-theory gas interaction factors φ_12 = [1 + (μ_1/μ_2)^0.5*(M_2/M_1)^0.25]^2 / SQRT(8*(1 + M_1/M_2)) and mixture viscosity μ_m.

Read the guide →
Engineering & Science

Wilke-Chang Liquid Diffusivity Correlation (Dissolved Gas & Solute D_AB)

Estimate dilute liquid-phase molecular diffusivity D_AB (in 10^-5 cm^2/s) using Charles Wilke and Pin Chang’s 1955 Stokes-Einstein association correlation.

Read the guide →
Engineering & Science

Williams-Landel-Ferry (WLF) Equation: Viscoelastic Shift Factor log10(aT)

Calculate the time-temperature superposition shift factor log10(aT) = (-C1 * (T - Tr)) / (C2 + (T - Tr)) and viscosity ratio aT = 10^log10(aT) above Tg for amorphous polymers and asphalt binders.

Read the guide →
Engineering & Science

Wilson Local-Composition Binary VLE Activity Coefficients (gamma1 & gamma2)

Calculate George M. Wilson’s local-composition activity coefficients gamma_1 and gamma_2 for strongly non-ideal polar/alcohol-hydrocarbon distillation systems using binary interaction parameters Lambda_12 and Lambda_21.

Read the guide →
Statistics & Experimentation

Wilson Score Confidence Interval Formula: Small-Sample & Zero-Defect Proportion Bounds

Compute accurate asymmetric binomial confidence intervals for conversion rates or defect rates using Edwin Wilson’s Score Interval — eliminating negative lower bounds and the 0/n zero-width Wald collapse.

Read the guide →
Engineering

Wind chill and NWS heat-index calculations with input checks

Practice metric wind chill and the NWS heat-index sequence, including preliminary screening and humidity adjustments.

Read the guide →
Engineering

Wind Turbine Power & Betz Limit (16/27 = 59.26%) formula: 0.5 * rho * A * v^3 * Cp

Calculate swept rotor wind power, Albert Betz's theoretical 16/27 (59.26%) maximum extraction limit, and real-world Cp shaft output in kW.

Read the guide →
Renewable Energy Engineering, Wind Rotor Aerodynamics & Acoustic Control

Wind Turbine Tip-Speed Ratio (TSR) & Rotor Solidity Formula

Calculate Horizontal-Axis Wind Turbine Blade Tip Linear Velocity (m/s), Dimensionless Tip-Speed Ratio λ (TSR), Aerodynamic Rotor Solidity σ, and Onshore 80 m/s Aeroacoustic Tip-Noise Curtailment Gate.

Read the guide →
Enology, Viticulture & Winery Cellar Operations

Winemaking Brix, Chaptalization & Tartaric Acid Formula

Calculate Grape Must Initial Potential Alcohol (% v/v), OIV Chaptalization Sucrose Addition MAX(0, Target_ABV - Potential_ABV) * 17 * Volume_L / 1000, L(+)-Tartaric Acid Must Addition, and Legal Enrichment Cap Compliance.

Read the guide →