Learn one useful thing today.
Proctor Soil Compaction Dry Density & ZAV Curve Formula
Calculate In-Situ Dry Unit Weight gamma_d = gamma_m/(1+w) (kN/m³), Theoretical 100%-Saturated Zero-Air-Voids Ceiling gamma_ZAV (kN/m³), Relative Proctor Compaction (%), and >= 95% Spec Gate.
Read the guide →MathPRODUCT function: multiply chained yield factors and sequential discounts
Multiply an entire column of growth multipliers or manufacturing stage yields with PRODUCT while skipping blank and text cells.
Read the guide →Math & TrigProject completion percentage: task count vs effort-weighted progress
Avoid false progress spikes on small chores by weighting each task's % complete by budgeted hours with SUMPRODUCT.
Read the guide →Date & TimeProject midpoint date and % schedule time elapsed (calendar vs workdays)
Find a calendar-date midpoint and an inclusive workday schedule ratio.
Read the guide →Behavioral Economics & Decision AnalysisProspect Theory Value & Prelec Weighting Formula
Evaluate reference-dependent gains and losses via Kahneman and Tversky’s (1992) asymmetric value function v(x) and Drazen Prelec’s (1998) inverse-S probability weight w(p) = EXP(-((-LN(p))^gamma)).
Read the guide →Engineering & SciencePsychrometric Humidity Ratio (g/kg) & Moist Air Specific Enthalpy (ASHRAE / Arden Buck)
Calculate saturation vapor pressure Pws via the Arden Buck equation, humidity ratio W = 0.621945 * Pw / (Patm - Pw) in g/kg dry air, and moist-air specific enthalpy h in kJ/kg dry air.
Read the guide →Industrial Dust Collection, Fabric Filtration & Fan SizingPulse-Jet Baghouse Gross vs Net Air-to-Cloth Ratio Formula
Calculate Pulse-Jet Baghouse Single-Bag Area (ft²), Gross Air-to-Cloth Velocity (fpm), Net (N-1 Compartment Offline) Air-to-Cloth Velocity (fpm), and Filter Cake Pressure Drop (in. w.g.).
Read the guide →Autonomous Sensing, Photonics & LiDAR SystemsPulsed ToF LiDAR Power & Unambiguous Range Formula
Calculate Laser Time-of-Flight Round-Trip Delay (ns), Extended-Target Lambertian Received Power P_rx = P_pk * rho * (D^2 / (4 * R^2)) * eta, and Maximum Unambiguous PRF Range.
Read the guide →Composites Manufacturing, Pultrusion Heated-Die Residence Time, Pull Force & Line SpeedPultrusion Composite Die Residence Time & Pull Force Formula
Calculate Heated-Die Cure Residence Time (s), Net Fiber Cross-Section Area (mm²), Viscous-Gelation Die Wall Pull Force (kN), and Continuous Profile Mass Output (kg/h).
Read the guide →EngineeringPump NPSHa (Net Positive Suction Head Available) & Cavitation Margin formula
Estimate available suction head from a large reservoir and compare it with a supplied pump requirement and an explicit illustrative margin.
Read the guide →Grid-Scale Long-Duration Storage, Hydropower Engineering & Power MarketsPumped-Storage Hydro Reservoir MWh & Grid Arbitrage Formula
Calculate Pumped-Storage Hydropower (PSH) Upper-Reservoir Gravitational Potential Energy (MWh = 2.725 * Mm³ * Head_m), Generated MWh Delivered, AC-to-AC Round-Trip Efficiency, and Full-Cycle Duck-Curve Arbitrage Margin ($).
Read the guide →Engineering & SciencePurcell Factor (F_P) & β-Factor Spontaneous Emission Enhancement Formula
Calculate Edward Purcell’s cavity QED spontaneous emission enhancement F_P = (3 / (4 * π^2)) * (Q / V_norm) and single-photon waveguide coupling efficiency β = F_P / (F_P + 1).
Read the guide →FinancialPurchasing Power Parity (PPP) implied FX rate & currency over/under-valuation
Compare an illustrative matched-basket price ratio with a spot rate and model an inflation-ratio scenario. These are not forecasts of fair market exchange rates.
Read the guide →Analytical Chemistry & Pharmaceutical QCPurnell Chromatography Peak Resolution Rs Formula
Calculate Retention Factor k_2 = (t_R2 - t_0) / t_0, Selectivity Factor alpha = k_2 / k_1, Purnell Master Resolution R_s = (SQRT(N)/4) * ((alpha - 1)/alpha) * (k_2 / (1 + k_2)), and USP R_s >= 1.5 Separation Gate.
Read the guide →TextPut double quotes inside a formula: "" escaping vs CHAR(34)
Generate quoted CSV fields, JSON payloads, and HTML attributes cleanly using doubled "" quotes or readable CHAR(34).
Read the guide →Financial analysisPV function: find the maximum loan a monthly budget can support
Discount a fixed monthly repayment stream back to today’s affordable loan principal with PV, and verify how rising interest rates shrink borrowing capacity.
Read the guide →Math & Everyday CalculationsPythagorean Theorem Formula: Hypotenuse, Missing Leg & 3D Box Diagonal
Calculate right-triangle hypotenuse c = SQRT(a^2 + b^2), solve for an unknown leg b = SQRT(c^2 - a^2) with triangle-inequality validation, and find 3D shipping-crate space diagonal d = SQRT(L^2 + W^2 + H^2).
Read the guide →StatisticalPythagorean Win Expectation formula (Bill James Sports Analytics)
Compare observed wins with a scoring-based Pythagorean model estimate, using an explicitly chosen exponent.
Read the guide →Restaurant & Retail Operations, Multi-Unit Franchising & Unit EconomicsQSR Franchise Royalty, Four-Wall EBITDA & Cash-on-Cash Formula
Calculate Quick-Service Restaurant (QSR) Franchise Gross-Sales Royalty + National Brand Ad-Fund Assessment ($), Net Franchisee Four-Wall EBITDA ($), Unlevered Buildout Cash-on-Cash Return, and Simple Capex Payback Period (Years).
Read the guide →Charts & Data VisualizationQuadrant Chart (2x2 Matrix) Formula: Crosshair-Centered XY & Quadrant Classifier
Build a 2x2 Strategic Quadrant Scatter Chart (BCG Growth-Share, Value-vs-Effort, Price-vs-Quality) by centering coordinates at origin (X - X_cut, Y - Y_cut) so plot axes form natural crosshairs and classifying items into Q1–Q4.
Read the guide →Industrial Organization & Spatial PricingQuadratic Hotelling Maximal Differentiation Price Formula
Calculate d’Aspremont, Gabszewicz, and Thisse’s (1979) quadratic-transport spatial Nash equilibrium prices p_1* = c + t*(1 - a - b)*(1 + (a - b)/3) and prove maximal product differentiation.
Read the guide →Mergers & Acquisitions, Financial Due Diligence & Quality of EarningsQuality of Earnings (QoE) Adjusted & Pro-Forma EBITDA Formula
Calculate Buy-Side/Sell-Side Quality of Earnings (QoE) Normalized EBITDA (Reported EBITDA + Non-Recurring Add-Backs - Non-Operating Gains + Excess Owner Compensation), Full-Year Pro-Forma Run-Rate EBITDA, Implied Headline EV, and Add-Back Reliance Share.
Read the guide →Engineering & ScienceQuantum Barrier Tunneling (STM & Flash Oxide WKB Transmission Formula)
Calculate the evanescent wavefunction decay constant kappa = 5.12317 * SQRT((m_eff / m_0) * (V_0 - E)) (nm^-1) and exponential tunneling transmission probability T_WKB = EXP(-2 * kappa * L) across Scanning Tunneling Microscope (STM) vacuum gaps and gate oxides.
Read the guide →Thin-Film Optics, Camera Lenses, Solar PV Glass & PhotonicsQuarter-Wave Anti-Reflection (AR) Coating Thickness & R% Formula
Calculate Ideal Zero-Reflection Index SQRT(n_0 * n_s), Physical Quarter-Wave Film Thickness d (nm), Bare-Substrate Fresnel Reflectance (%), and Coated Quarter-Wave Reflectance (%).
Read the guide →RF & Microwave EngineeringQuarter-Wave Impedance Transformer (Z_T) and Off-Frequency VSWR
Size a quarter-wave matching section Z_T = SQRT(Z_0 * R_L) and compute exact off-frequency reflection |Gamma(f/f_0)| and VSWR across fractional bandwidths.
Read the guide →StatisticalQUARTILE.INC function: split salaries or deal sizes into Q1, median, and Q3 bands
Calculate the 25th, 50th, and 75th inclusive quartile cutoffs and interquartile range (IQR) with QUARTILE.INC.
Read the guide →Reinsurance & Insurance AccountingQuota-Share vs Surplus-Share Reinsurance Formula
Compare fixed Quota-Share cession against risk-sized First-Surplus-Share cession MIN(Max_Lines * Line, MAX(0, Sum_Insured - Line)) / Sum_Insured, Ceding Commission, and Net Retained Cash Flow.
Read the guide →MathQUOTIENT function: calculate full cases or whole hours without remainders
Return only the integer portion of division with QUOTIENT, and pair it with MOD to split totals into full packs plus leftovers.
Read the guide →Statistical & Clinical AnalysisR-ISS for Multiple Myeloma: Staging Logic and Its Limits
Explore the original 2015 R-ISS criteria and how complete laboratory inputs affect an educational staging-logic example.
Read the guide →StatisticalR-Squared (R^2) and linear regression residuals formula
Measure how much variance an OLS trendline explains with CORREL(X, Y)^2 and compute fitted values and residuals Y - Y_hat.
Read the guide →Quantitative Finance & RiskRachev Ratio Formula: Upper Expected Tail Gain vs Lower Expected Tail Loss
Calculate the Rachev tail-asymmetry ratio in Excel and Arte Sheets by dividing upper beta-tail expected excess gain (right-tail ETL) by lower alpha-tail expected excess loss (CVaR).
Read the guide →Chemical, Process & Catalysis EngineeringRachford-Rice Isothermal VLE Flash Formula: Bubble/Dew Check & Objective f(V/F)
Test multicomponent feed phase stability (Subcooled Liquid SUM(z_i * K_i) <= 1, Superheated Vapor SUM(z_i / K_i) <= 1, or Two-Phase Flash) and evaluate H. H. Rachford and J. D. Rice’s (1952) monotonic flash residual f(psi).
Read the guide →Engineering & ScienceRackett Equation: Saturated Liquid Molar Volume & Density
Predict saturated liquid molar volume V_sat = V_c * Z_c^((1 - T / T_c)^(2/7)) (cm^3/mol) and mass density ρ_L = MW / V_sat (g/cm^3) for LPG storage tanks and pressurized liquid pipelines.
Read the guide →Charts & Data VisualizationRadar (Spider) Chart Formula: 0–100 Multi-Axis Normalization & Polygon Area
Normalize incommensurate KPI units (dollars, milliseconds, percentages) onto a common 0–100 Radar / Spider Chart spoke scale (with polarity inversion for lower-is-better metrics) and compute enclosed K-spoke polygon area.
Read the guide →MathRADIANS function: convert degree angles before SIN, COS, and TAN
Convert compass bearings and incline angles from degrees to radians with RADIANS so spreadsheet trigonometry produces accurate ratios.
Read the guide →Industrial Radiography (RT), Ir-192 / X-Ray Weld Inspection & ASME Sec V Article 2Radiographic NDT Geometric Unsharpness (Ug) & SFD Formula
Calculate Source-to-Object Distance D_o = SFD - t (mm), Penumbra Geometric Unsharpness U_g = F*t/(SFD - t) (mm), Minimum Code Source-to-Film Distance SFD_min (mm), and ASME Sec V Compliance.
Read the guide →OperationsRAID Capacity, Mixed-Workload IOPS and Annual Failure Probability
Compare RAID capacity and derive host IOPS from backend operation costs. Explore a one-year drive-failure probability under an explicit constant-hazard model.
Read the guide →Distributed Storage & Reliability EngineeringRAID-5 MTTDL & Erasure-Coding Overhead Formula
Calculate Patterson-Gibson-Katz RAID-5 Mean Time To Data Loss MTTDL = (MTBF^2) / (N*(N - 1)*MTTR) and compare Reed-Solomon (k + m) erasure-coding storage overhead against 3-way replication.
Read the guide →Industrial Logistics, Rail Freight Operations & Fleet Capacity SizingRailcar Fleet Sizing, Turnaround Cycle & Dwell Cost Formula
Calculate Industrial Railcar Round-Trip Turnaround Cycle Time (Days), Active Operating Cars Required via Little’s Law, Total Leased Fleet Including Bad-Order Maintenance Spares, and Annual Lease Cost Impact of Terminal Dwell.
Read the guide →Railway & Locomotive Traction Engineering, AREMA Train Resistance, Ruling Grade & PowerRailroad Train Resistance, Ruling Grade & Drawbar Power
Calculate Specific Rolling + Aerodynamic Resistance (N/t), Ruling Grade + Curve Resistance (N/t), Total Coupler Drawbar Tractive Effort (kN), and Rail Drawbar Power (kW).
Read the guide →Railway Civil Engineering, High-Speed Track Alignment & EN 13803Railway Equilibrium Cant, Cant Deficiency & Curve Speed Formula
Calculate Standard-Gauge Railway Equilibrium Cant (11.8 * V_kmh^2) / R_m, Uncompensated Cant Deficiency I (mm), Passenger Lateral Acceleration (I / 1500)*9.81, and Maximum Permitted Curve Speed.
Read the guide →Financial ModelingRalph Vince Optimal f Position Sizing: Terminal Wealth Relative & Geometric HPR
Convert empirical trade P&Ls with unequal win/loss magnitudes into Holding Period Returns HPR_i = 1 + f * (-Trade_i / Worst_Loss), Terminal Wealth Relative (TWR), and Geometric Mean HPR G(f).
Read the guide →Engineering & ScienceRaman Shift Wavenumber (cm^-1) & Anti-Stokes / Stokes Boltzmann Ratio Formula
Convert laser excitation and scattered wavelengths (nm) into Raman vibrational shift Delta_nu = (10^7 / lambda_0) - (10^7 / lambda_s) in cm^-1 and compute the vibrational Boltzmann population ratio EXP((-1.4387769 * |Delta_nu|) / T).
Read the guide →Aerospace Structural Mechanics & PlasticityRamberg-Osgood Elastic-Plastic Strain & Secant Formula
Calculate Metallic Elastic Strain sigma / E, MMPDS 0.2%-Offset Ramberg-Osgood Plastic Strain 0.002 * (sigma / sigma_02)^n, Total Nonlinear Strain, and Effective Secant Modulus E_sec.
Read the guide →Financial & AccountingRamsey Rule & Keynes-Ramsey Euler Equation: Social Discount Rate & Consumption Growth
Calculate the social discount rate r = rho + eta * g for climate/infrastructure cost-benefit analysis and optimal per-capita consumption growth g_c = (r - rho) / eta using Frank P. Ramsey’s 1928 intertemporal optimization rule.
Read the guide →Climate Economics & Benefit-Cost PolicyRamsey Social Cost of Carbon (SCC) Discounting Formula
Calculate the closed-form Social Cost of Carbon SCC = D_0 / (rho + (eta - 1)*g + phi) and quantify why Nordhaus (rho = 1.5%) vs Stern (rho = 0.1%) discounting shifts carbon prices 2.5x.
Read the guide →Regulatory Economics & Infrastructure PricingRamsey-Boiteux Regulated Utility Inverse-Elasticity Pricing Formula
Set welfare-maximizing break-even tariffs P_i = MC_i / (1 - R_ramsey / |e_i|) across multi-segment rail, power, or water utilities using the Ramsey-Boiteux rule.
Read the guide →MathRANDBETWEEN and RAND: generate bounded integer and decimal test samples
Create synthetic QA datasets with inclusive integer RANDBETWEEN(bottom, top) and continuous [0, 1) RAND() scaling.
Read the guide →Engineering & ScienceRandles-Sevcik Equation: Cyclic Voltammetry Peak Current (ip) & Reversible Peak Split
Calculate Nernstian cyclic voltammetry peak current ip = 2.686e5 * n^1.5 * A * SQRT(D) * C0 * SQRT(v) at 25 °C in microamps and reversible peak-to-peak separation Delta_Ep = 59.2 / n mV.
Read the guide →Lookup & ReferenceRandomly Assign Rows to Equal-Sized Balanced Groups (RANK + MOD + INDEX)
Eliminate lopsided RANDBETWEEN group sizes by ranking pre-drawn random decimals with RANK(B2, $B$2:$B$7) and cycling evenly through group labels via INDEX($E$2:$E$4, MOD(Rank - 1, K) + 1).
Read the guide →