Learn one useful thing today.
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 StrategyWar 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 OperationsWarehouse 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 SizingWarehouse 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 VisualizationWaterfall (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 FormulasWaterlow 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 & ScienceWatson 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 & PhysiologyWatson 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 MicrostructureWatts 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 AnalyticsWatts-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 InferenceWeak-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 MobilityWebster 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 reportingWEEKDAY 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 & TimeWEEKNUM 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 →EngineeringWeibull 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 & FitnessWeight-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 averagesWeighted 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 & TrigWeighted 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 →StatisticalWeighted 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 →StatisticalWeighted 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 & TrigWeighted 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 & PhysiologyWeir 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 & ScienceWeisz-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 DesignWeitzman 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 MetabolismWell-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 EpidemiologyWells–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 & ScienceWen-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 & ScientificWenner 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 & ScienceWenzel 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 EngineeringWestergaard 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 & EpidemiologyWestgard 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 & ClinicalWestley 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 FormulasWFNS 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 ManagementWhalen 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 →EngineeringWheatstone 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 EngineeringWheeler 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 & ScienceWhitaker 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 & ScienceWiedemann-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 →ScienceWien'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 & StatisticalWilcoxon 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 & ScienceWilke 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 & ScienceWilke-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 & ScienceWilliams-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 & ScienceWilson 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 & ExperimentationWilson 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 →EngineeringWind 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 →EngineeringWind 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 ControlWind 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 OperationsWinemaking 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 →