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 Ulcer Risk Scale & Support Surface Tier

Calculate the 7-domain Waterlow Pressure Injury Score across BMI/build, skin status, sex/age, continence, mobility, appetite/nutrition, and tissue/neuro/surgical special risks (10+ At Risk, 15+ High Risk, 20+ Very High Risk).

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 (TBW) Calculator: Dialysis Kt/V & Hydrophilic V_d Formula

Calculate adult Total Body Water V (Liters) for hemodialysis urea Kt/V adequacy, dysnatremia correction, and hydrophilic/ethanol volume of distribution using Patricia E. Watson et al.’s (1980) isotope-dilution equations.

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) * SUM_{y_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 →
Occupational Health, Industrial Hygiene & Sports Medicine (ISO 7243)

WBGT Outdoor & Indoor Occupational Heat-Stress Formula

Calculate ISO 7243 / OSHA Wet-Bulb Globe Temperature (Outdoor Solar 0.7*Tnwb + 0.2*Tg + 0.1*Tdb vs Indoor 0.7*Tnwb + 0.3*Tg), PPE Clothing-Adjusted WBGT_eff, Radiant Globe Spread, and ACGIH Work-Rest Regime.

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 Indirect Calorimetry Calculator: Resting Energy Expenditure (REE) & RQ

Calculate gold-standard Resting Energy Expenditure REE (kcal/day) = 1.44 * (3.941 * VO2 + 1.106 * VCO2) (and urinary-nitrogen complete Weir REE) plus Respiratory Quotient RQ = VCO2 / VO2 from metabolic cart gas exchange.

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 →
Well Control & Blowout Prevention (IWCF / IADC WellSharp), Casing-Shoe MAASP & Kick Tolerance

Well Control Casing-Shoe MAASP & Kick Tolerance Formula

Calculate Maximum Allowable Mud Weight MAMW (SG), Static Casing-Shoe MAASP (kPa), Maximum Gas Influx Column Height at Shoe (m), and Kick-Tolerance Pit Gain (m³).

Read the guide →
Clinical Pharmacokinetics & Drug Metabolism

Well-Stirred Hepatic Extraction & First-Pass Formula

Calculate Rowland, Benet, and Graham’s (1973) well-stirred liver Extraction Ratio E_H = (f_u * CL_int) / (Q_H + f_u * CL_int), Hepatic Clearance CL_H, and First-Pass Oral Bioavailability F_H = 1 - E_H.

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

Wells-Riley Airborne Infection & Ventilation Formula

Calculate Well-Mixed Indoor Inhaled Quanta Dose mu = (I * q * p * t) / Q, Wells-Riley Individual Infection Probability 1 - EXP(-mu), Expected Secondary Cases among S Susceptibles, and Outbreak Threshold.

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 (0–17 Points): Pediatric Stridor & Epinephrine Triage Formula

Calculate Charles Westley's 5-item pediatric croup severity score (0 to 17 points across Level of Consciousness, Cyanosis, Inspiratory Stridor, Air Entry, and Retractions) to guide dexamethasone vs. nebulized racemic epinephrine.

Read the guide →
Healthcare & Clinical Formulas

WFNS Subarachnoid Hemorrhage (SAH) Grading Scale (Grades I–V)

Classify aneurysmal subarachnoid hemorrhage into objective World Federation of Neurosurgical Societies Grades I–V strictly from Glasgow Coma Scale (3–15) and major focal motor deficit (aphasia or hemiparesis/hemiplegia: 0/1).

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 →