Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Electrochemical Powertrains, Hydrogen Fuel Cells & Polarization Modeling

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 →
Engineering

Peng-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 Mechanics

Penman 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 & Physiology

Penn 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 Transfer

Pension 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 & Clinical

PERC 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 →
Financial

Percent 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 & Aggregations

Percent 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 →
Percentages

Percentage 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 statistics

PERCENTILE.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 Panel

Perforated 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 & Logistics

Periodic 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 & Trigonometry

Permutations 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 →
Statistical

PERT 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 Series

Pesaran 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 & Analytics

Peterson-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 Analysis

Peto 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 & Science

Petukhov 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 Engineering

Peukert 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 →
Engineering

pH 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 & Neurology

Phenytoin, 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 Engineering

Philip 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 →
Science

Photoelectric 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 Shielding

Photon 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 & Clinical

PHQ-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 →
Math

PI 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 & Reference

Pick 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 & Statistical

Pie & 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 Debt

PIK-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 Calculators

PIM3 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 Counting

PIN 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 Analytics

Pinball 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 Efficiency

Pinch 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 →
Financial

Piotroski 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 →
Engineering

Pipe 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 Physics

Pirani 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 & Scientific

Pitot-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 Calculations

Pitt 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 & Clinical

Pittsburgh 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 & Science

Pitzer / 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 & Science

Pitzer 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 →
Engineering

Planck 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 →
Engineering

Plane-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 & Science

Planetary 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 Mechanics

Plank’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 & Science

Plasma 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 Analysis

PLASMIC 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 Brakes

Plate 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 Design

Plate 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 →
Statistical

Plus-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 →