Learn one useful thing today.
Norrish Humectant Water Activity (aw) Formula
Calculate Ideal Raoult Water Mole Fraction x_w, Norrish Non-Ideal Sugar/Humectant Water Activity a_w = x_w * EXP(-K * x_s^2), Hydrogen-Bonding Depression, and FDA aw <= 0.85 Pathogen Hurdle status.
Read the guide →Healthcare & Clinical CalculationsNorton Scale Pressure-Ulcer Risk Calculator (5–20 Geriatric Nursing Score)
Calculate Doreen Norton’s pioneering 5-domain geriatric pressure-ulcer risk score (5–20 points across Physical Condition, Mental State, Activity, Mobility, and Incontinence; <= 14 High Risk).
Read the guide →LogicalNOT function: invert TRUE/FALSE and exclude blocked statuses cleanly
Negate logical tests and multi-value exclusion lists with NOT(OR(...)) so dispatch and approval rules stay easy to audit.
Read the guide →Date & TimeNOW function: compare live timestamps and add hours to the current time
Understand how NOW stores the current date and time as a serial number + decimal fraction, how it differs from TODAY, and why it recalculates on edit.
Read the guide →FinancialNPER function: calculate how many months it takes to pay off a loan
Find the number of payment periods needed to clear a balance with NPER, match monthly rate and cash-flow signs, and guard payments below monthly interest.
Read the guide →Financial analysisNPV function: keep the day-zero investment outside NPV
NPV discounts its first cash-flow argument by one full period. Add the initial day-zero outlay outside NPV(rate, Year1:YearN) so present value is never misstated.
Read the guide →Clinical Medicine & PhysiologyNRS-2002 Calculator: ESPEN Hospital Nutritional Risk Screening (Kondrup Score)
Calculate Jens Kondrup et al.’s (2003, ESPEN) NRS-2002 inpatient nutrition risk score (0–7 points) combining Impaired Nutritional Status (0–3), Disease Severity / Stress Metabolism (0–3), and Age >= 70 adjustment (+1).
Read the guide →Engineering & ScienceNRTL (Non-Random Two-Liquid) VLE & LLE Activity Coefficients
Calculate Henri Renon and John Prausnitz’s 3-parameter NRTL activity coefficients gamma_1 and gamma_2 using energy parameters tau_12, tau_21 and non-randomness factor alpha_12 for partially miscible liquid-liquid and azeotropic VLE mixtures.
Read the guide →Embedded Sensors, Battery BMS & Thermal ManagementNTC Thermistor Beta & Steinhart-Hart Divider Formula
Calculate Microcontroller Pull-Up Voltage Divider Output V_adc = V_ref * R_ntc / (R_pull + R_ntc), Log Resistance Ratio LN(R_ntc / R_25), Absolute Kelvin Temperature 1 / (1/298.15 + LN(R/R_25)/Beta), and Celsius Temperature.
Read the guide →StatisticalNth largest value without duplicates: dense Gold, Silver, Bronze tiers
Wrap UNIQUE inside LARGE(UNIQUE(Range), N) so tied top scores do not swallow 2nd and 3rd place prize tiers.
Read the guide →StatisticalNth Smallest Value with Criteria & Highlight Bottom K Bids (SMALL + FILTER)
Find the kth lowest bid in a category and flag all bids at or below that cutoff, with explicit tie handling and validation of K and matching bid data.
Read the guide →Date & TimeNumber of workdays in a month (and remaining business days)
Count total business days in any month and remaining working days to month-end excluding weekends and holidays with NETWORKDAYS.
Read the guide →Engineering & ScienceNusselt Laminar Film Condensation Coefficient on a Vertical Wall (h̄)
Calculate the mean condensing heat-transfer coefficient h̄ = 0.943 * ((ρ_l * (ρ_l - ρ_v) * g * h_fg * k_l^3) / (μ_l * L * ΔT))^0.25 (W/(m^2·K)) for vertical condenser tubes.
Read the guide →EngineeringNyquist Sampling Rate, Folded Alias Frequency & ADC SNR / ENOB formulas
Calculate a single-tone folded frequency, the twice-bandwidth Nyquist boundary, ideal full-scale sine quantization SNR and SINAD-derived ENOB.
Read the guide →Biostatistics & Clinical TrialsO’Brien-Fleming vs Pocock Group-Sequential Interim Boundary Formula
Compute O’Brien-Fleming information-scaled critical Z boundaries and Lan-DeMets cumulative alpha spending alpha*(t) across interim Data Monitoring Committee looks.
Read the guide →Chemical, Process & Catalysis EngineeringO’Connell Overall Distillation Tray Efficiency Formula & Actual Tray Count N_act
Convert theoretical equilibrium stages into actual sieve/valve trays using H. E. O’Connell’s (1946, AIChE) Overall Column Efficiency correlation E_0 (%) = 50.3 * (alpha * mu_L)^(-0.226) and Actual Tray Count -INT(-N_th / (E_0 / 100)).
Read the guide →Engineering & Fluid MechanicsO’Connell Tray Efficiency Correlation Formula: Actual vs. Theoretical Distillation Plates
Convert equilibrium McCabe-Thiele / Fenske-Underwood-Gilliland distillation stages N_eq into actual column trays N_actual = ROUNDUP(N_eq / E_o, 0) using H. E. O’Connell’s correlation E_o (%) = 50.3 * (mu_L * alpha)^(-0.226).
Read the guide →Healthcare & Clinical CalculatorsOABSS (Overactive Bladder Symptom Score — Homma 0–15 Scale)
Calculate Yukio Homma’s 4-item Overactive Bladder Symptom Score (0–15) and enforce the mandatory Q3 urinary urgency >= 2 gate required for diagnostic OAB classification.
Read the guide →Healthcare & Clinical CalculationsOakland Score for Safe ED Discharge in Acute Lower GI Bleeding
Calculate Kathryn Oakland’s BSG/ACG-endorsed 0–35 score across Age, Sex, Prior Lower GI Bleed, Digital Rectal Exam Blood, Heart Rate, Systolic BP, and Hemoglobin (g/dL) to identify Oakland <= 8 patients with >= 95% safe outpatient discharge probability.
Read the guide →Statistical & Clinical AnalysisOaxaca-Blinder Decomposition Formula: Explained Endowment vs. Unexplained Pay Gap
Decompose mean log-wage differentials (Y_A - Y_B) into Explained Endowment differences (X_A - X_B) * beta_A and Unexplained Coefficient/Return differences using Ronald Oaxaca & Alan Blinder’s 1973 counterfactual identity.
Read the guide →EngineeringOblique Shock Theta-Beta-Mach Wedge Deflection & Normal Mach Formula
Calculate supersonic wedge deflection angle theta (degrees) from upstream Mach M_1 and shock wave angle beta using the exact Theta-Beta-Mach relation, plus normal Mach component M_n1 = M_1 * SIN(beta).
Read the guide →Engineering & ScienceOcean Ekman Spiral Depth (DE) & Wind-Driven Ekman Transport Formula
Calculate Vagn Walfrid Ekman’s turbulent upper-ocean boundary layer thickness D_E = PI() * SQRT((2 * A_z) / |f|) (m) and depth-integrated 90°-deflected Ekman mass transport M_E = tau_wind / |f| (kg/(m*s)).
Read the guide →Marine Terminal & LNG Berth Engineering, OCIMF MEG4 Mooring Wind/Current & %MBLOCIMF Vessel Mooring Wind, Current & Hawser %MBL Formula
Calculate Aerodynamic Wind Load (kN), Seawater Tidal Current Drag (kN), Combined Environmental Surge/Sway Force (kN), and Hawser Tension as % of Ship Design MBL.
Read the guide →FinancialOdd Stub-Period Bond Clean Price and Implied Yield (ODDFPRICE & ODDLPRICE Valuation)
Value bonds with irregular short or long final/initial coupon periods using money-market stub discounting, accrued-interest deduction, and inverse stub yield.
Read the guide →Math & TrigOdometer gas mileage log: calculate MPG, L/100 km, and cost per mile
Compute trip distance from consecutive odometer readings, fuel efficiency in MPG and metric L/100 km, and fuel cost per mile.
Read the guide →StatisticalOEE formula: Availability x Performance x Quality (manufacturing KPI)
Calculate Overall Equipment Effectiveness (OEE) and reconcile the 3-factor loss breakdown against direct (GoodUnits * IdealCycleTime) / PlannedProductionTime.
Read the guide →Lookup & ReferenceOFFSET function: sum a dynamic trailing N-month window
Build a resizable range reference from an anchor cell with OFFSET(ref, rows, cols, height, width), and avoid out-of-bounds #REF! errors.
Read the guide →Charts & Visual Data ModelingOgive Graph Formula: Cumulative Frequency %, Upper Class Boundaries & Grouped Median
Build a "Less-Than" Ogive cumulative frequency curve: plot Cumulative % against Upper Class Boundaries (starting at 0% at the first Lower Boundary) and compute the linearly interpolated Grouped Percentile / Median.
Read the guide →Equity Valuation & Accounting TheoryOhlson Linear Information Dynamics Valuation Formula
Calculate James Ohlson’s (1995) closed-form equity value P_t = B_t + alpha_1 * x_t^a + alpha_2 * v_t combining clean-surplus book value, abnormal earnings persistence omega, and forward information v_t.
Read the guide →FinanceOhlson O-Score: Nine-Factor Logit Calculation in a Spreadsheet
Calculate a commonly reproduced Ohlson nine-factor linear score and its logistic transform, while distinguishing historical model output from a calibrated current bankruptcy forecast.
Read the guide →EngineeringOhm's Law, electrical power (Watts), and parallel resistance formulas
Calculate Current (V / R), Power dissipation (V^2 / R and I^2 * R), and Series vs Parallel equivalent resistance 1 / SUM(1 / R_range).
Read the guide →Wellbore Zonal Isolation & Primary Cementing, API Spec 10A Absolute-Volume Slurry DesignOilwell Primary Cementing Slurry Yield & Sack Count Formula
Calculate API Absolute-Volume Slurry Yield (ft³/sack), Mixed Slurry Density (ppg), Required Bulk Cement Sacks Including Open-Hole Washout Excess, and Total Mix Water (bbl).
Read the guide →Cellular RF Planning & Wireless Propagation ModelingOkumura-Hata Urban Macro-Cell Path Loss Formula
Calculate Masaharu Hata’s Empirical Urban Macro-Cell Mobile Height Correction a(h_m), Distance Path-Loss Slope 44.9 - 6.55*LOG10(h_b), Total Median Path Loss L_urban (dB), and Cell-Edge Received Signal Power (dBm).
Read the guide →Macroeconomics & Business Cycle ForecastingOkun’s Law Output Gap & Unemployment Change Formula
Calculate the Okun’s Law percentage GDP output gap -beta * (u - u*), lost dollar GDP, and growth-rate unemployment change Delta_u = -(1/beta) * (g_Y - g_Y*).
Read the guide →Public Choice & Institutional EconomicsOlson Collective Action Free-Rider Threshold Formula
Calculate Mancur Olson’s Privileged-Group Critical Benefit Share v_crit = C_pub / V_tot, Anchor Stakeholder Unilateral Net Surplus, Selective-Incentive Dues Gap, and Privileged vs Latent Group regime.
Read the guide →FinancialOmega Ratio & Ulcer Index drawdown risk formulas for skewed portfolios
Evaluate non-normal return distributions via Keating-Shadwick Omega Ratio SUM(MAX(0, R - MAR)) / SUM(MAX(0, MAR - R)) and Martin's RMS drawdown Ulcer Index.
Read the guide →Chemical, Process & Catalysis EngineeringOnda (1968) Packed-Column Wetted Surface Area (a_w) Formula: Surface Tension & HTU
Calculate effective liquid-wetted interfacial area a_w (m^2/m^3) in random-packed gas absorbers and air strippers using Kakusaburo Onda, Hiroshi Takeuchi & Yoshio Okumoto’s (1968) dimensionless Reynolds-Froude-Weber-Capillary correlation.
Read the guide →Logical & ValidationOne or the Other, Not Both: Exclusive OR (XOR) & Multi-Option Mutual Exclusion
Validate mutually exclusive promotional discounts or approval paths with two-argument XOR, and avoid the 3-argument odd-parity trap using boolean sum equality.
Read the guide →FinancialOne-asset Black-Litterman example: blend a prior and one absolute view
Explore a scalar normal-prior update with one absolute return view; distinguish uncertainty in the estimated mean from asset return variance.
Read the guide →Clinical Pharmacokinetics & BiopharmaceuticsOne-Compartment IV Bolus PK: k_el, V_d & Clearance Formula
Calculate first-order elimination rate constant k_el, biological half-life t_1/2, back-extrapolated C_0, apparent volume of distribution V_d, and systemic clearance CL from two plasma draws.
Read the guide →MathOne-Rep Max (1RM) Epley & Brzycki strength formulas + 2.5 kg plate rounding
Estimate 1-Rep Max from submaximal sets using Epley W*(1 + Reps/30) and Brzycki W*36/(37 - Reps), plus nearest-2.5-kg training load rounding.
Read the guide →StatisticalOne-Way ANOVA formula: Between-Group vs Within-Group F-statistic
Test whether three or more group means differ significantly by computing SS_Between, SS_Within, Mean Squares, and the One-Way ANOVA F-ratio directly in cells.
Read the guide →Logical & ConditionalOnly Calculate If Input Cells Are Not Blank (COUNTA & ISBLANK Gate)
Suppress premature $0.00 totals, negative margins, or #DIV/0! errors on partially entered invoice and quote rows using IF(COUNTA(B2:D2) < 3, "", ...) so formulas stay blank until every required input is entered.
Read the guide →Statistical & Clinical AnalysisOnodera Prognostic Nutritional Index (PNI) Formula: Albumin & Lymphocyte Surgical Cutoff
Calculate Tokiro Onodera et al.’s (1984) Prognostic Nutritional Index PNI = 10 * Albumin_gdL + 0.005 * Total_Lymphocyte_Count_per_uL to stratify gastrointestinal surgical anastomosis safety (PNI < 40 contraindicated / high fistula risk) and immuno-oncology prognosis.
Read the guide →EngineeringOp-Amp Gain, Closed-Loop Bandwidth (GBWP) & Slew-Rate Limit formulas
Explore ideal resistor-set gains, a single-pole noise-gain bandwidth estimate and the sine-wave slew-rate boundary.
Read the guide →Bulk Metal Forming, Open-Die Upset Forging, Barreling Friction Hill & Press TonnageOpen-Die Upset Forging Friction-Hill & Tonnage Formula
Calculate Compressive Logarithmic True Strain, Constant-Volume Upsetted Diameter Df (mm), Siebel Friction-Hill Shape Multiplier C_f, and Peak Forging Press Force (kN).
Read the guide →Mining Engineering & Mineral EconomicsOpen-Pit Cutoff Grade & Stripping Ratio Formula
Distinguish Marginal Milling Cutoff Grade (sunk mining cost) from Pit-Shell Full Mining Cutoff Grade and calculate Maximum Breakeven Waste-to-Ore Stripping Ratio SR_max.
Read the guide →Optical Fiber Transport & Coherent DWDM TelecomOptical DWDM EDFA Noise Figure & Cascaded OSNR Formula
Calculate 1550 nm C-Band Single-Span Optical Signal-to-Noise Ratio (0.1 nm reference bandwidth), Multi-Span ASE Accumulation Penalty 10*LOG10(N), Cascaded End-to-End OSNR_dB = 58 + P_in_dBm - NF_dB - 10*LOG10(N), and Coherent FEC Margin.
Read the guide →Engineering & ScienceOptical Kerr Effect Nonlinear Refractive Index & Laser B-Integral
Calculate intensity-dependent Kerr refractive index shift delta_n = n_2 * I and accumulated ultrafast laser amplifier B-integral = (2 * PI() / lambda_0) * n_2 * I * L_eff (radians) to prevent catastrophic filamentation breakup.
Read the guide →FinancialOption Put-Call Parity, Intrinsic Value, and Time Value formulas
Use a no-dividend European option parity model to infer a put value, then calculate the sample call premium minus intrinsic value.
Read the guide →