Learn one useful thing today.
PEM Fuel Cell Polarization, LHV Efficiency & Heat Formula
Calculate Hydrogen PEM Fuel Cell Operating Voltage V_cell (V) After Activation and Area-Specific Ohmic Losses, Power Density (W/cm²), Anode-Utilization-Adjusted LHV Electrical Efficiency, and Coolant Radiator Waste-Heat Density (W/cm²).
Read the guide →EngineeringPeng-Robinson EOS: Acentric Kappa & Alpha(T) Cohesion Function
Calculate Peng–Robinson kappa, reduced temperature and alpha with unrounded helper cells, validated inputs and an explicit choice of acentric-factor correlation.
Read the guide →Engineering & Fluid MechanicsPenman Combination Equation Formula: Reservoir & Open-Water Evaporation (mm/day)
Combine net solar radiation energy balance E_rad and aerodynamic wind-vapor deficit drying power E_aero without needing surface water temperature via Howard L. Penman’s 1948 equation E_0 = (Delta * E_rad + gamma * E_aero) / (Delta + gamma).
Read the guide →Clinical Medicine & PhysiologyPenn State Energy-Estimation Research and a Fictional Formula Switch
Read about Penn State energy-expenditure studies and practice selecting between two fictional spreadsheet formulas.
Read the guide →Retirement Planning & Corporate Pension Risk TransferPension Lump-Sum Buyout vs Annuity Breakeven Formula
Compare a Corporate Pension Lump-Sum Buyout Offer against a Guaranteed Annuity by contrasting Naive Undiscounted Payback (Lump / Pmt) with True Discounted Breakeven Longevity -LN(1 - Lump*r/Pmt)/LN(1 + r) and Present-Value Advantage.
Read the guide →Healthcare & ClinicalPERC and Revised Geneva: Educational Flag and Point Sums
Practice two separate sums using fictional pulmonary-embolism assessment inputs. This worksheet does not rule out PE or decide diagnostic testing.
Read the guide →FinancialPercent of goal and budget variance formulas (Revenue vs Expense sign rules)
Calculate quota attainment %, remaining amount to goal, and favorable vs unfavorable FP&A variances for both revenue and cost centers.
Read the guide →Reporting & AggregationsPercent Sold, Remaining Allocation & Portfolio Weighted Completion Formula
Calculate SKU or event-tier percent sold (Sold / Allocation) with zero-allocation protection, oversold waitlist detection, and true volume-weighted portfolio percent sold.
Read the guide →PercentagesPercentage change in Excel: increases, decreases and a zero starting value
Compare monthly workshop bookings using the original month as the base. Distinguish a percentage change from an absolute difference and show an explicit result when the starting value is zero.
Read the guide →Descriptive statisticsPERCENTILE.INC function: calculate P50 and P90 service-level thresholds
Report 50th and 90th percentile latency or delivery times using a 0-to-1 k fraction, understand linear interpolation between points, and catch #NUM! errors.
Read the guide →Architectural Acoustics & Auditorium Timber Baffles, Ingard-Fok Perforated Resonant PanelPerforated Acoustic Panel Porosity & Peak Hz Formula
Calculate Square-Grid Perforation Open-Area Porosity (%), Ingard-Fok Hole-Interaction Effective Neck Length teff (mm), Resonant Peak Absorption Frequency f0 (Hz), and Wavelength (m).
Read the guide →Operations & LogisticsPeriodic Order Quantity (POQ) Time-Supply Interval & Discrete MRP Lot Sizing
Convert fractional Wilson EOQ into an integer MRP order cycle T_POQ = MAX(1, ROUND(EOQ / D_period, 0)) and evaluate discrete Periodic Order Quantity lot size and cycle cost.
Read the guide →Math & TrigonometryPermutations Without and With Repetition (PERMUT & PERMUTATIONA Formulas)
Count ordered sequences without replacement using FACT(n) / FACT(n - k) and with replacement using POWER(n, k), plus compute no-repeat collision probabilities.
Read the guide →StatisticalPERT three-point estimates and a fixed path’s duration uncertainty
Convert Optimistic, Most Likely, and Pessimistic estimates into PERT Weighted Mean (O + 4M + P)/6, Task SD (P - O)/6, and Quadrature Path Risk.
Read the guide →Panel Econometrics & Time SeriesPesaran CD Test for Cross-Sectional Dependence in Panels
Compute Pesaran’s (2004) cross-sectional dependence statistic CD = SQRT(2*T / (N*(N-1))) * SUM(rho_ij) and compare it against Breusch-Pagan LM across panel residual columns.
Read the guide →Operations & AnalyticsPeterson-Silver Variability Coefficient (V): EOQ vs. Dynamic Lot Sizing
Calculate Rein Peterson and Edward Silver’s squared-CV demand variability index V = (N * SUM(D^2)) / (SUM(D)^2) - 1 to decide when steady Economic Order Quantity (V < 0.25) beats Silver-Meal or Wagner-Whitin dynamic lot sizing (V >= 0.25).
Read the guide →Statistical & Clinical AnalysisPeto One-Step Pooled Odds Ratio Formula for Rare-Event Clinical Trials
Pool rare-event and zero-cell randomized trials without arbitrary 0.5 continuity corrections using Richard Peto’s O - E score and hypergeometric variance V: OR_Peto = EXP(Σ(O - E) / ΣV).
Read the guide →Engineering & SciencePetukhov Smooth-Pipe Darcy Friction Factor & Turbulent Nusselt Formula
Cut turbulent heat-exchanger tube error from ±25% (Dittus-Boelter) down to ±5% using Boris Petukhov’s (1970) momentum-heat analogy Nu_D and explicit Darcy friction factor f = (0.790 * LN(Re) - 1.64)^(-2).
Read the guide →Electrical & Energy Systems EngineeringPeukert Battery Discharge Runtime and Effective Capacity Formula
Calculate high-current battery discharge runtime t = H * (C_H / (I * H))^k and effective delivered amp-hours C_eff = I * t using the dimensionally balanced Peukert law.
Read the guide →EngineeringpH conversion and the logarithm of mean estimated hydrogen concentration
Compare arithmetic mean pH with the pH-scale value of a mean concentration under a dilute-solution approximation.
Read the guide →Clinical Pharmacokinetics, Critical-Care Therapeutic Drug Monitoring & NeurologyPhenytoin, Albumin and Corrected Concentrations: Limits of Estimation
Understand what albumin-corrected phenytoin equations estimate, why free-drug measurement may matter, and why a spreadsheet cannot determine dose or toxicity.
Read the guide →Civil, Structural & Geotechnical EngineeringPhilip Two-Term Soil Infiltration Formula: Sorptivity S, Gravity Factor A & Rate i(t)
Calculate cumulative rainfall/irrigation infiltration I(t) = S * SQRT(t) + A * t and instantaneous infiltration capacity i(t) = 0.5 * S / SQRT(t) + A using John R. Philip’s (1957) analytical solution of Richards’ unsaturated flow equation.
Read the guide →SciencePhotoelectric Effect Kinetic Energy & Compton X-Ray Wavelength Shift
Calculate a single-photon photoelectric energy threshold and maximum kinetic energy, and separately explore the ideal free-electron Compton wavelength shift.
Read the guide →Health Physics, Medical Linac / NDT Vaults & Gamma ShieldingPhoton Attenuation: Half-Value and Tenth-Value Layers
Explore exponential attenuation, half-value and tenth-value layers in an ideal monoenergetic narrow-beam example, with the limits of that model made clear.
Read the guide →Healthcare & ClinicalPHQ-9: Symptom Points and a Separate Item 9 Check
Add nine already-scored PHQ-9 items and inspect item 9 separately, including when another response is missing or invalid.
Read the guide →MathPI function: calculate circle area, pipe circumference, and tank volume
Use full 15-digit precision PI() instead of hardcoded 3.14 for engineering areas, circumferences, and cylindrical volumes.
Read the guide →Lookup & ReferencePick a Value From a Fixed Set of Options (INDEX + MOD / RANDBETWEEN)
Select an allowed tier, shift size, or discrete test parameter (such as {10, 25, 50, 100}) from a fixed lookup list using INDEX(Options, selector)—either deterministically via MOD(ID - 1, COUNTA(Options)) + 1 or randomly via RANDBETWEEN(1, COUNTA(Options)).
Read the guide →Math & StatisticalPie & Doughnut Chart Percentage Share & Small-Slice "Other" Rollup Formula
Compute exact category percentage shares ROUND(B2 / SUM($B$2:$B$6) * 100, 2) and consolidate unreadable < 5% tail categories into a single "Other" slice using SUMIFS(B2:B6, B2:B6, "<" & (0.05 * SUM(B2:B6))).
Read the guide →Leveraged Finance, Private Credit & Mezzanine DebtPIK-Toggle Mezzanine Note Balloon Accretion & Cash-Save Formula
Calculate Payment-in-Kind (PIK) Toggle Mezzanine Annual Cash Liquidity Preserved, Compounded Balloon Redemption Principal P0*(1 + r_cash + r_stepup)^T, Cumulative PIK Accretion, and Excess Compounding Cost vs Cash Pay.
Read the guide →Healthcare & Clinical CalculatorsPIM3 and Standardised Mortality Ratios: A Spreadsheet Illustration
Use a fictional data set to understand observed-to-expected ratios in paediatric intensive-care reporting.
Read the guide →Optoelectronics, Fiber-Optic Receivers & Photon CountingPIN Photodiode Responsivity & Shot-Noise SNR Formula
Convert Photodiode Quantum Efficiency eta and Wavelength lambda (um) into Responsivity R = (eta * lambda_um)/1.24 (A/W), Signal Photocurrent (uA), Combined Poisson Shot + TIA Thermal RMS Noise, and Electrical SNR (dB).
Read the guide →Probabilistic Forecasting & Supply Chain AnalyticsPinball Quantile Loss & Winkler Interval Score Formula
Evaluate probabilistic quantile forecasts via asymmetric Pinball Loss MAX(tau*(y - q), (tau - 1)*(y - q)) and audit (1 - alpha) prediction intervals with Robert Winkler’s (1972) Interval Score.
Read the guide →Process Heat Integration, Pinch Technology & Energy EfficiencyPinch Analysis Minimum Hot & Cold Utility (Delta Tmin) Formula
Calculate Hot-Stream Cooling Duty (kW), Maximum Process-to-Process Heat Recovery (kW), Minimum Cooling-Water Utility Q_C,min (kW), and Minimum Steam Hot Utility Q_H,min (kW).
Read the guide →FinancialPiotroski F-Score formula: 9-point fundamental value investing checklist
Practice a nine-signal accounting screen using explicitly prepared financial metrics. A high score is not a recommendation or a guaranteed return.
Read the guide →EngineeringPipe flow rate (Q = A * V) and continuity nozzle velocity formulas
Calculate volumetric pipe flow in Liters/sec from inner diameter and velocity using PI()*(D/2)^2*V*1000, and scale nozzle velocity via V1*(D1/D2)^2.
Read the guide →Vacuum Metrology & Semiconductor Load-Lock Safety, Marcello Pirani (1906) Gauge PhysicsPirani Vacuum Gauge Heat Loss & Gas Calibration Formula
Calculate Nitrogen-Equivalent Indicated Pirani Pressure (mbar), Gas-Conductive Filament Heat Loss (mW), Total Wheatstone Bridge Power (mW), and Gas Signal Share (%).
Read the guide →Engineering & ScientificPitot-Static Tube Velocity: Equivalent Airspeed (EAS) vs True Airspeed (TAS)
Convert Pitot-static differential pressure dP = P_total - P_static into sea-level calibrated Equivalent Airspeed and altitude-density-corrected True Airspeed V_TAS = SQRT(2 * dP / rho).
Read the guide →Healthcare & Clinical CalculationsPitt Bacteremia Score Research: Adding Five Component Points
Practice adding published Pitt bacteremia component points with fictional inputs and discrete-value checks.
Read the guide →Healthcare & ClinicalPittsburgh Knee Rule: An Educational Logic Example
Explore the age, mechanism and four-step criteria used in the Pittsburgh knee rule, with historical validation results and the limits of a spreadsheet example.
Read the guide →Engineering & SciencePitzer / Lee-Kesler Second-Virial Compressibility Factor Z = Z0 + ω·Z1
Calculate real-gas compressibility factor Z = 1 + (B^0 + ω * B^1) * (P_r / T_r) using Abbott’s Pitzer-virial correlations B^0 = 0.083 - 0.422 / T_r^1.6 and B^1 = 0.139 - 0.172 / T_r^4.2.
Read the guide →Engineering & SciencePitzer Acentric Factor (ω) from Reduced Vapor Pressure at Tr = 0.7
Calculate Kenneth Pitzer’s acentric factor ω = -1.000 - LOG10(P_sat(0.7 * T_c) / P_c) and invert it to estimate saturation vapor pressure at T_r = 0.7 for cubic equations of state.
Read the guide →EngineeringPlanck Photon Energy (1239.84 / lambda_nm) & Bragg X-Ray Diffraction Law
Convert optical/LED wavelength in nanometers directly to photon energy in electron-volts (eV) and solve Bragg's Law d = n*lambda / (2*sin(theta)) for crystal d-spacing.
Read the guide →EngineeringPlane-stress von Mises and Tresca equivalent stress and yield ratios
Combine multiaxial normal stresses sigma_x, sigma_y and shear stress tau_xy into FEA Von Mises distortion-energy stress SQRT(sig_x^2 - sig_x*sig_y + sig_y^2 + 3*tau_xy^2) and Yield Factor of Safety.
Read the guide →Engineering & SciencePlanetary Atmospheric Scale Height (H) & Barometric Altitude Pressure
Calculate isothermal planetary atmospheric scale height H = (R * T) / (M * g) (km) and exponential barometric pressure P(z) = P_0 * EXP(-z / H) (kPa) across Earth, Mars, Venus, and Titan.
Read the guide →Engineering & Fluid MechanicsPlank’s Freezing Time Equation: Blast-Freezer & Biopharma Cryopreservation Slab Formula
Calculate phase-change freezing time for infinite slabs, cylinders, and spheres using Rudolf Plank’s moving-boundary equation t_f = (rho_f * L_f / (T_f - T_inf)) * (P * a / h + R * a² / k_f) alongside the freezing Biot number.
Read the guide →Engineering & SciencePlasma Debye Screening Length (λ_D) & Debye Sphere Parameter (N_D)
Calculate electrostatic charge-shielding length λ_D = 7433.94 * SQRT(T_e_eV / n_e_m3) and weakly coupled plasma parameter N_D = (4/3) * π * n_e * λ_D^3 in RF etching tools and tokamaks.
Read the guide →Statistical & Clinical AnalysisPLASMIC Score: Seven Assessed Criteria
Add the seven PLASMIC criteria in an educational example for suspected thrombotic microangiopathy, with explicit population and input checks.
Read the guide →Machine Design, Friction Clutches & Automotive Disc BrakesPlate Clutch & Disc Brake Uniform-Wear vs Pressure Torque Formula
Calculate Uniform-Wear Effective Friction Radius (mm), Conservative Uniform-Wear Torque Capacity (N·m), Brand-New Uniform-Pressure Torque (N·m), and Max Inner-Edge Lining Pressure (kPa).
Read the guide →Thermal Process Engineering, Gasketed Plate Heat Exchangers & Anti-Fouling DesignPlate Heat Exchanger (PHE) Velocity & Wall Shear Formula
Calculate Parallel Channels Per Fluid, Enlargement-Adjusted Hydraulic Diameter D_h (mm), Inter-Plate Channel Velocity (m/s), and Self-Cleaning Wall Shear Stress tau_w (Pa).
Read the guide →StatisticalPlus-or-Minus (+/-) Tolerance Check & Count Out-of-Spec Values
Classify measurements using an explicit six-decimal comparison policy and count rejected parts from the same classifications.
Read the guide →