Learn one useful thing today.
PMT function: calculate a fixed monthly loan payment
Convert an annual interest rate and term into matching monthly units inside PMT, interpret the negative cash-outflow sign, and test zero-interest financing.
Read the guide →Pneumatic Conveying, Powder Transport, Saltation Plugging & Blower Line SizingPneumatic Conveying Gas Velocity & Saltation Margin Formula
Calculate Required Conveying Air Mass Rate (kg/h), Line Volumetric Gas Flow at Pick-Up Pressure (m³/min), Superficial Pick-Up Gas Velocity U_gas (m/s), and Saltation Safety Margin U_gas / U_salt.
Read the guide →Health & FitnessPneumonia Severity Index (PSI / PORT): Score and Risk Classes I–V
Practice PSI scoring from verified clinical point subtotals, apply the separate Class I screen before score bands, and validate missing inputs. This worksheet does not prescribe admission or ICU care.
Read the guide →Healthcare & ClinicalPneumonia Severity Index: Point Totals and the Class I Step
Add pre-assessed components of the pneumonia severity index, understand the separate Class I screening step, and avoid making disposition decisions from a score alone.
Read the guide →Engineering & SciencePockels Electro-Optic Modulator Half-Wave Voltage (Vpi) & Transmission
Calculate transverse lithium-niobate (LiNbO3) Pockels modulator half-wave voltage V_pi = (lambda_0 * d) / (2 * n_e^3 * r_33 * L) and crossed-polarizer optical transmission I / I_0 = SIN((PI()/2) * (V / V_pi))^2.
Read the guide →Biostatistics & Clinical TrialsPocock Win Ratio, Win Odds, and Net Treatment Benefit Formula
Analyze hierarchical composite clinical endpoints (death before hospitalization before biomarker) using Pocock’s Win Ratio, Dong’s tie-adjusted Win Odds, and Buyse’s Net Benefit.
Read the guide →Statistical AnalysisPoint-Biserial Correlation (r_pb) for Binary Groups & Exam Item Discrimination
Compute Point-Biserial Correlation r_pb = ((M_1 - M_0) / SD_pop) * SQRT(p * q) from subgroup means and verify algebraic identity with CORREL on 0/1 binary indicators.
Read the guide →Process Safety, API 521 Flare Systems & Thermal RadiationPoint-Source Thermal Radiation: A Flare-Modelling Illustration
Explore inverse-square heat-flux arithmetic for an ideal point source, and understand why it cannot establish a flare safety perimeter by itself.
Read the guide →StatisticalPoisson probability formula: P(X = k) arrivals with EXP and FACT
Calculate the exact probability of k random arrivals, defects, or outages per interval given average rate lambda using (lambda^k * EXP(-lambda)) / FACT(k).
Read the guide →Charts & Data VisualizationPolar Plot Coordinate Formula: Convert Radius & Angle (r, theta) to XY Scatter
Plot true continuous-angle Polar Charts (antenna radiation lobes, wind roses, acoustic microphone patterns) on an XY Scatter grid by converting Polar (r, theta_deg) into Cartesian X = r * COS(RADIANS(theta)) and Y = r * SIN(RADIANS(theta)).
Read the guide →OperationsPollaczek-Khinchine M/G/1 Queue Waiting Time & Service Variance
Calculate exact M/G/1 expected queue wait W_q = (lambda * (sigma_s^2 + (1/mu)^2)) / (2 * (1 - rho)) and queue length L_q = lambda * W_q across deterministic (M/D/1), exponential (M/M/1), and high-variance servers.
Read the guide →Polymer Processing & Battery Electrode Coating, Gaskell Two-Roll Calendering NipPolymer Two-Roll Calendering Gaskell Nip Force Formula
Calculate Post-Nip Exit Sheet Gauge 1.226*H0 (mm), Peak Hydrodynamic Nip Pressure (MPa), Gaskell Roll Separating Force (kN), and Two-Roll Viscous Drive Power (kW).
Read the guide →Turbomachinery, Pipeline Gas Compression & Process EngineeringPolytropic Centrifugal Gas Compressor Temp & Power Formula
Calculate Centrifugal Gas Compressor Polytropic Temperature Exponent, Discharge Temperature T2 (K), Polytropic Specific Enthalpy Rise (kJ/kg), and Gas Compression Power (kW).
Read the guide →Engineering & SciencePoole-Frenkel Trap Barrier Lowering vs. Schottky Emission Formula
Calculate bulk dielectric Coulomb trap barrier lowering Delta_phi_PF = SQRT((e * E) / (PI() * eps_dyn * eps_0)) (eV) and compare directly against electrode-limited Schottky image-force lowering (0.5 * Delta_phi_PF).
Read the guide →Charts & Visual Data ModelingPopulation Pyramid Chart Formula: Negated Male Share, Sex Ratio & Age Dependency
Prepare an age-sex Population Pyramid bar chart: negate the left-side Male cohort share (-Male / Total_Pop * 100), compute Cohort Sex Ratio (Males per 100 Females), and Total Age-Dependency Ratio.
Read the guide →Statistical AnalysisPopulation Variance & Standard Deviation (VAR.P & STDEV.P vs. Bessel N-1 Correction)
Choose accurately between N-denominator population dispersion (VAR.P, STDEV.P) for complete censuses and N-1 sample estimators (VAR.S, STDEV.S), and verify the exact N/(N-1) Bessel scaling ratio.
Read the guide →StatisticalPopulation weighted standard deviation with frequency or probability weights
Calculate weighted variance and weighted standard deviation around the weighted mean in one LET + SUMPRODUCT formula.
Read the guide →Cement Pyroprocessing, ASTM C150 Clinker Mineralogy & Sulfate-Resistance ChemistryPortland Cement Bogue Clinker Phases & LSF Formula
Calculate ASTM C150 Bogue Potential Alite C_3S (%), Belite C_2S (%), Tricalcium Aluminate C_3A (%), and Raw-Mix Lime Saturation Factor LSF (%) from XRF Oxide Percentages.
Read the guide →Lookup & ReferencePosition & Exact Cell Address of Max or Min Value (XMATCH & ADDRESS)
Find both the relative list position (1..N) and exact worksheet cell address (such as "B4") of the maximum or minimum value in a column using XMATCH(MAX(range), range, 0) and ADDRESS.
Read the guide →Venture Capital & Seed FinancingPost-Money SAFE vs Pre-Money SAFE Dilution Formula
Compare stacked YC Post-Money SAFE ownership locks (alpha_i = I_i / Cap_i) against Legacy Pre-Money SAFEs that mutually dilute each other prior to a priced Series A round.
Read the guide →MathPOWER function: calculate exponents, reciprocals, and Nth roots
Raise numbers to positive, zero, negative, and fractional (1/N) powers with POWER—and guard even roots of negative numbers.
Read the guide →EngineeringPower-Plant Net Heat Rate (BTU/kWh & kJ/kWh) & Stirling Cycle Efficiency
Convert a supplied net thermal efficiency to heat rate in Btu/kWh or kJ/kWh, and separately calculate the ideal perfectly regenerated Stirling temperature limit.
Read the guide →EngineeringPoynting Vector Electromagnetic Intensity & Solar Sail Radiation Pressure
Calculate electromagnetic wave irradiance I = E_0^2 / (2 * c * mu_0) from peak electric field E_0 and compute absorbed (I / c) vs perfectly reflected (2 * I / c) radiation thrust.
Read the guide →Engineering & SciencePoynting-Robertson Effect: Interplanetary Dust Spiral Decay Lifetime & Beta Ratio
Calculate the solar radiation-to-gravity ratio beta = 0.574 * Qpr / (rho * s) and Poynting-Robertson orbital spiral decay lifetime t_PR = 700 * s * rho * a^2 / Qpr (years) for zodiacal dust grains.
Read the guide →FinancialPPMT function: calculate principal paid down in a specific loan period
Measure how much loan principal each installment retires—and verify that summing all periods recovers the exact original principal.
Read the guide →HealthcarePractice mg/kg/day to mg per Dose and mL Conversions
A fictional spreadsheet exercise for a supplied daily regimen, daily cap, dose count and liquid concentration. Distinguish daily amounts from per-dose quantities.
Read the guide →LogicalPractice text-complexity checks with dummy password-like strings
Combine length, case and digit checks in a spreadsheet using synthetic examples; this is not a password-strength test.
Read the guide →Economics & Market MicrostructurePrais-Shorrocks Income Mobility Index M(P) Formula: Markov Transition Matrix Trace
Quantify intergenerational or credit-rating transition mobility from a K x K Markov matrix P using the Prais-Shorrocks Trace Index M(P) = (K - trace(P)) / (K - 1) and Mean Class Stay Duration 1 / (1 - p_ii).
Read the guide →Statistical & Clinical AnalysisPRAM: Adding Five Pediatric Respiratory Assessment Scores
Sum five already-assessed PRAM component scores and display the numerical range, with input checks and pediatric clinical context.
Read the guide →EngineeringPrandtl-Meyer Supersonic Expansion Function nu(M) & Maximum Turn Angle
Calculate the isentropic Prandtl-Meyer expansion angle nu(M) (in degrees) from Mach 1 to supersonic Mach M and the vacuum limiting turn angle nu_max = (SQRT((gamma+1)/(gamma-1)) - 1) * 90.
Read the guide →Healthcare & Clinical CalculatorsPRECISE-DAPT Research and a Separate Capped-Input Exercise
Read about the PRECISE-DAPT bleeding-risk study and practice a separate fictional spreadsheet calculation with a ceiling.
Read the guide →StatisticalPrecision, Recall, F1 Score & Matthews Correlation (MCC) from a Confusion Matrix
Evaluate ML classifiers, spam filters, and QA inspection models on imbalanced datasets where raw Accuracy misleads.
Read the guide →FinancialPrepare a Trial Balance from journal entries (SUMIFS + balance check)
Aggregate general-ledger Debit and Credit lines by account with SUMIFS and verify double-entry balance to the cent.
Read the guide →FinancialPresent and future value of an annuity: Ordinary (type 0) vs Annuity Due (type 1)
Value leases, pensions, and savings plans accurately by choosing end-of-period (type = 0) vs beginning-of-period (type = 1) cash flows in PV and FV.
Read the guide →Sheet-Metal Forming, Hydraulic Press-Brake Tooling & Tonnage ProtectionPress-Brake Air-Bending Tonnage & V-Die Opening Formula
Calculate V-Die Shoulder Opening V (mm), Floated Air-Bent Natural Inside Radius I_r (mm), Forming Force F (kN), and Required Hydraulic Press-Brake Capacity (metric tons-force).
Read the guide →Process Safety, API 520 Pressure-Relief Sizing & Mechanical IntegrityPressure-Relief Data: Flow and Pressure Unit Conversions
Convert a hypothetical US liquid flow rate and pressure difference to SI units, and understand the limits of this calculation for relief-system design.
Read the guide →Semiconductor Back-End-of-Line (BEOL), CMP Polishing & MetrologyPreston Equation CMP Material Removal Rate (MRR) Formula
Calculate CMP Material Removal Rate MRR (nm/min) from Slurry Preston Coefficient, Downforce Pressure (kPa) & Relative Velocity (m/s), Polish Time (sec), and WIWNU Thickness Spread (nm).
Read the guide →Bridge & Structural Engineering, Post-Tensioned & Pre-Tensioned ConcretePrestressed Concrete Tendon Kern Point & Fiber Stress Formula
Calculate Section Kern Radius k = S / A (m), Top-Fiber Concrete Service Stress f_top (MPa, Compression +), Bottom-Fiber Service Stress f_bot (MPa), and Class U Uncracked Status.
Read the guide →Data Validation & CleaningPrevent Duplicate Entries (Normalized TRIM + UPPER Uniqueness Rule vs. Plain COUNTIF)
Block both exact and whitespace-padded stealth duplicates ("INV-101" vs. " inv-101 ") by pairing UPPER(TRIM(A2)) canonical keys with COUNTIF uniqueness rules.
Read the guide →Data Validation & AuditPrevent Split Allocations from Exceeding Total Pool or 100% Cap
Audit equity splits, cost-center allocations, and grant distributions so SUM($B$2:$B$6) never exceeds the master pool $E$2, reporting exact unallocated headroom or over-allocation excess.
Read the guide →Reliability Engineering & Maintenance OptimizationPreventive Age vs Block Replacement Renewal Cost Formula
Compare Barlow-Proschan Age Replacement C(T)/mu(T) against Block Replacement (c_p + c_f*M(T))/T and Run-to-Failure cost rates for increasing-hazard Erlang-2 lifetimes.
Read the guide →FinancialPrice Elasticity of Demand (Midpoint / Arc formula) & revenue impact check
Calculate symmetric Arc Price Elasticity ((Q2-Q1)/AvgQ) / ((P2-P1)/AvgP) to classify Elastic vs Inelastic demand and revenue change.
Read the guide →FinancialPRICE function: calculate clean bond price per $100 face value
Value fixed-coupon bonds between coupon dates using PRICE, accounting for settlement, maturity, coupon frequency, and day-count basis.
Read the guide →Engineering & SciencePriestley-Taylor Potential Evapotranspiration (PET) Radiation Formula
Calculate daily radiation-driven crop/watershed Potential Evapotranspiration PET = alpha_PT * (Delta / (Delta + gamma)) * ((R_n - G) / lambda_v) (mm/day) using the FAO-56 Tetens vapor-pressure slope Delta.
Read the guide →LogicalPrioritize example shipping workflow rules with IFS
Use an illustrative IFS decision tree to route special-handling flags before express requests and package-weight bands.
Read the guide →Statistical & Clinical AnalysisPRISM III Research and Summarizing Numbers in a Spreadsheet
Review the original pediatric intensive-care research and practice a separate example of mean and maximum calculations.
Read the guide →Healthcare & Clinical FormulasPRISMA-7: What the Original Scoring Guide Says
Understand the intended use, scoring cautions and study limitations of PRISMA-7, with a separate binary-counting exercise.
Read the guide →Quantitative Finance & Backtest AuditingProbabilistic Sharpe Ratio (PSR) Formula with Skewness and Kurtosis
Audit backtested Sharpe ratios against negative skewness, fat tails, and multiple-testing benchmarks SR_0 using Bailey and López de Prado’s Probabilistic Sharpe Ratio.
Read the guide →Market Microstructure & Quantitative TradingProbability of Informed Trading (PIN) & Spread Formula
Calculate Easley, Kiefer, O’Hara, and Paperman’s (1996) Probability of Informed Trading PIN = (alpha * mu) / (alpha * mu + epsilon_b + epsilon_s) and Bayesian opening bid-ask quotes.
Read the guide →StatisticalProcess capability Cp and Cpk: spread and centering
Measure manufacturing spread Cp = (USL - LSL)/(6*SD) and off-center capability Cpk = MIN((USL - Mean)/(3*SD), (Mean - LSL)/(3*SD)).
Read the guide →