Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Statistical & Psychometrics

PABAK (Prevalence-Adjusted Bias-Adjusted Kappa), PI & BI Formula

Report Ted Byrt’s (1993) clinical diagnostic trio—PABAK = 2 * p_o - 1, Prevalence Index PI = |a - d| / N, and Bias Index BI = |b - c| / N—on 2×2 observer reliability studies.

Read the guide →
Text

Pad text and amounts into an illustrative fixed-width record

Build a 12-character name and eight-digit cents field, with an explicit amount-overflow guard.

Read the guide →
Text & String Manipulation

Pad Text with Spaces or Zeros for Fixed-Width Exports (REPT + Overflow Guard)

Build exact N-character fixed-width ACH, EDI, and banking record fields by right-padding text with spaces and left-padding numeric IDs with zeros—safely clamping strings that exceed field width.

Read the guide →
Text

Pad Week & Fiscal Period Numbers with Leading Zeros ("2026-W04")

Build fixed-width week and fiscal-period codes with RIGHT, validate integers before padding, and distinguish ISO week-year labels from fiscal periods.

Read the guide →
Nonparametric Statistics

Page’s L Trend Test Formula for Ordered Treatments in Blocked Ranks

Detect monotonic dose-response or learning-curve trends across blocked repeated-measures ranks using Page’s (1963) weighted rank sum L = SUM(j * R_j) and directional Z_L score.

Read the guide →
Financial Modeling

Pain Index & Pain Ratio: Measuring Drawdown Depth AND Time Under Water

Compute the Zephyr Pain Index—the average percentage drawdown from running high-water mark across every period—and Pain Ratio (R_p - R_f) / Pain_Index to penalize stalled recoveries.

Read the guide →
Engineering

Paint calculator formula: net wall square footage, coats & whole gallons

Estimate interior/exterior paint gallons by subtracting door and window openings from room perimeter × height, multiplying by coats, and rounding up.

Read the guide →
Operations Research & Service Parts Logistics

Palm’s Theorem (S-1, S) Spare-Parts Base-Stock Formula

Size repairable spare-parts base stock S using Palm’s Theorem Poisson pipeline mean mu_p = lambda * T_rep, exact Fill Rate P(X <= S - 1), and Expected Backorders EBO(S).

Read the guide →
Financial & Accounting

Palma Ratio Formula: Top 10% to Bottom 40% National Income Share & Middle-50% Check

Calculate the OECD/UNDP Palma inequality ratio S_Top10 / S_Bottom40 and verify José Gabriel Palma’s "homogeneous middle" share S_Deciles_5_to_9 = 100 - S_Top10 - S_Bottom40 (~50% across nations).

Read the guide →
Engineering

Palmgren-Miner damage index and a Basquin S-N life example

Sum cycle ratios in a linear fatigue model and explore a separate Basquin cycle-life calculation with an explicit reversals convention.

Read the guide →
Charts & Visual Data

Panel Chart (Small Multiples) Formula: Vertical Lane Offset & Base-100 Index

Separate tangled spaghetti line charts into clean Small-Multiples lanes by adding a fixed vertical Panel Span offset (k * Span + Value) or indexing every series to 100 at period t = 0.

Read the guide →
Print Production, Bookbinding & Packaging Engineering

Paper GSM, US Basis Weight, PPI & Book Spine Formula

Convert US 500-Sheet Basis Weight (lb) across Text (25x38") vs Cover (20x26") parent sheets into ISO Metric Grammage GSM = (Lb * 1406.5) / (W_in * L_in), Pages Per Inch PPI = 2000 / Caliper_mils, and Perfect-Bound Spine Width.

Read the guide →
Pulp, Paper & Packaging Process Engineering, Fourdrinier Wet-End & Dryer Section Balance

Paper Machine Wet-End Dewatering & Steam Drying Formula

Calculate Bone-Dry Fiber Throughput (t/h), Headbox Slurry Flow (t/h), Dryer-Section Water Evaporation Rate (t/h), and Steam Boiler Demand (t/h) across Press-Felt Solids.

Read the guide →
Quantitative Finance & Trading

Parabolic SAR Formula: Acceleration Factor Step & Prior Two-Bar Penetration Clamp

Implement J. Welles Wilder’s exact Parabolic Stop-and-Reverse (SAR) step SAR_next = SAR_curr + AF * (EP - SAR_curr) including the often-omitted prior two-lows non-penetration clamp.

Read the guide →
Aerospace Recovery Systems, Rocketry & Fluid Drag Mechanics

Parachute Terminal Velocity, Canopy Diameter & Impact KE

Calculate Steady-State Canopy Drag Force m*g, Terminal Descent Rate Vt = SQRT((2*m*g)/(rho*Cd*S)), Equivalent Circular Canopy Diameter SQRT(4*S/PI()), and Touchdown Impact Kinetic Energy.

Read the guide →
Power Generation Dispatch, Synchronous Turbine Governors & Primary Frequency Control

Parallel Generator Speed-Droop Governor Load Sharing Formula

Calculate Composite Island Frequency Stiffness K_tot (MW/Hz), Settling Bus Frequency f_bus (Hz), Unit 1 Active Load P_1 (MW), and Unit 2 Active Load P_2 (MW).

Read the guide →
Statistical

Pareto 80/20 cumulative percentage and ABC inventory classification

Calculate running cumulative share on descending revenue SKUs and classify items into A (top 80%), B (next 15%), and C (bottom 5%) tiers.

Read the guide →
Casualty Actuarial Science & Excess Pricing

Pareto Excess Layer Severity & ILF Pricing Formula

Price heavy-tailed casualty layers using Single-Parameter Pareto Limited Expected Value LEV(x), Excess Layer Severity LEV(D + L) - LEV(D), and Increased Limits Factor ILF(L_high, L_base).

Read the guide →
Mechanical & Aerospace Fracture Mechanics

Paris-Erdogan Fatigue Crack Growth Life Formula

Calculate Critical Fracture Crack Size a_c = (1 / PI()) * (K_IC / (Y * Delta_sigma))^2 and exact Paris-Erdogan Fatigue Cycles to Failure N_f across both power-law (m != 2) and logarithmic (m = 2) exponents.

Read the guide →
Engineering

Paris' Law Crack Growth: Integrated Cycles and Critical Size

Build a constant-amplitude Paris-law spreadsheet with separate maximum stress and stress range, a logarithmic m = 2 limit, and explicit model boundaries.

Read the guide →
Finance

Parkinson High-Low & Garman-Klass OHLC Volatility Formulas

Calculate Parkinson and Garman-Klass range-based volatility estimates from a valid OHLC bar, then apply an explicit periods-per-year assumption without rounding intermediate results.

Read the guide →
Date & Time

Parse 4-digit military time ("0930", 1745, 15) into real Excel time and hours

Convert numeric HHMM codes or numeric text to clock labels and elapsed hours for intervals shorter than one day.

Read the guide →
Text

Parse a full address into Street, City, State, and ZIP code

Split comma-delimited US addresses ("742 Evergreen Ter, New Haven, CT 06510") cleanly even when street or city names contain multiple words.

Read the guide →
Text & Cleaning

Parse European Comma-Decimal & Thousands-Separated Text (NUMBERVALUE Pattern)

Convert locale-specific numeric strings such as "1.250,75", "4 820,50", and "12,5%" into true numbers regardless of system regional settings using SUBSTITUTE, TRIM, and VALUE.

Read the guide →
Text

Parse XML tags and JSON webhook fields with formulas (TEXTAFTER & TEXTBEFORE)

Extract text from controlled XML-like tags and compact JSON string fields using delimiter formulas. These are not general parsers.

Read the guide →
Business & Operations

Part-Period Balancing (EPP) & Groff's Marginal Lot-Sizing Heuristic in MRP

Determine discrete MRP production batch horizons under lumpy time-varying demand using Economic Part-Period EPP = S / h and Groff's marginal rule Dt+n * n * (n + 1) <= 2*S / h.

Read the guide →
Lookup & Reference

Partial Substring Match on Numeric Cells (Why "*45*" Fails & SEARCH Fix)

Match, count, sum, and look up numeric invoice IDs or part numbers by embedded digit pattern without converting numeric columns to text, overcoming COUNTIF and XLOOKUP wildcard failure on numbers.

Read the guide →
Lookup & Reference

Partial-Match Wildcard Lookup: VLOOKUP("*" & Key & "*") & XLOOKUP Mode 2

Look up vendor records or catalog SKUs by partial embedded code using VLOOKUP("*" & E2 & "*", A2:C5, 3, FALSE) or XLOOKUP("*" & E2 & "*", ..., 2).

Read the guide →
Engineering & Science

Paschen's Law: Gas Breakdown Voltage (Vb) & Minimum Paschen (p*d) Curve

Calculate Townsend DC gas breakdown voltage Vb = (B * p * d) / (LN(A * p * d) - LN(LN(1 + 1 / gamma_se))) and the minimum breakdown product (p * d)_min = (EXP(1) / A) * LN(1 + 1 / gamma_se).

Read the guide →
Healthcare & Clinical Calculations

PASI Score and PASI-90: Regional Weighting and Score Reduction

Calculate a weighted PASI total from pre-assessed regional grades and compare it with a positive baseline, with interpretation and validation limits.

Read the guide →
Atmospheric Dispersion & Air-Permit Modeling, Pasquill-Gifford-Turner (1961) Gaussian Plume

Pasquill-Gifford Gaussian Plume Ground Concentration

Calculate Effective Stack Plume Height Heff (m), Ground-Reflection Vertical Exponential Factor, Downwind Centerline Ground Concentration (ug/m³), and Worst-Case Peak Cmax (ug/m³).

Read the guide →
Statistical & Psychometrics

Passing-Bablok Nonparametric Method-Comparison Regression (Median Slope & Intercept)

Fit outlier-proof clinical laboratory calibration lines via Heinrich Passing & Wolfgang Bablok’s (1983) pairwise slope median b = MEDIAN((Y_j - Y_i) / (X_j - X_i)) and intercept a = MEDIAN(Y_i - b * X_i).

Read the guide →
Financial

Payback Period formula: interpolated fractional years to break even on CapEx

Calculate the estimated year and fraction when cumulative project cash flows recover an upfront capital investment—and check whether a project does not recover its cost within the forecast.

Read the guide →
Electronics Thermal Management, Exposed-Pad QFN/MOSFET Cooling & Plated Thermal Vias

PCB Thermal Via Array Resistance & Temperature Rise Formula

Calculate Hollow Plated-Copper Barrel Ring Area (mm²), Single-Via Vertical Thermal Resistance (°C/W), Parallel N-Via Array Resistance (°C/W), and Exposed-Pad Board Delta_T (°C).

Read the guide →
Financial & Accounting

PDURATION & RRI Formulas: Periods to Reach Target Value & Equivalent Return

Calculate the exact number of compounding periods required for an investment to grow from PV to FV (PDURATION) and the equivalent compound growth rate over N periods (RRI) using exact logarithmic and power identities.

Read the guide →
Private Equity, Venture Capital & Institutional LP Reporting

PE & Venture Fund DPI, RVPI, Gross TVPI & Net TVPI Formula

Calculate ILPA Institutional LP Fund Multiples: Realized Cash-on-Cash DPI (Distributions / Paid-In Capital), Unrealized RVPI (Residual NAV / PIC), Gross Total Value to Paid-In (TVPI), and Accrued-Carry-Adjusted LP Net TVPI.

Read the guide →
Private Equity Partnership Agreements, LPA Waterfalls & GP Clawback

PE American Deal-by-Deal Waterfall & GP Clawback Formula

Calculate Private Equity American (Deal-by-Deal) Early Carried Interest Paid, True Whole-Fund Earned Carry After Later Realized Write-Offs, Gross GP Clawback Liability, and Out-of-Pocket GP Cash Beyond Escrow.

Read the guide →
Private Equity & Fund Accounting

PE European Waterfall, GP Catch-Up & Carried Interest Formula

Calculate Limited Partner and General Partner distributions across all four European Waterfall tiers: Return of Capital, Preferred Hurdle, 100% GP Catch-Up Tranche H * c / (1 - c), and 80/20 Carried Interest.

Read the guide →
Private Equity Fund Finance, Portfolio NAV Facilities & Credit Risk

PE NAV Loan LTV Covenant, Drawdown Buffer & DPI Formula

Calculate Late-Life PE Portfolio NAV Facility Initial LTV (Debt / NAV), Hard Maintenance Covenant Minimum NAV (Debt / Max_LTV), Allowable Portfolio Valuation Drawdown Buffer, and Synthetic Recap DPI Uplift.

Read the guide →
Private Equity Fund Finance, ILPA Reporting & Performance Attribution

PE Subscription Line (Subline) IRR Boost vs TVPI Formula

Calculate Unlevered Deal IRR (%), Delayed LP Capital Call With Subline Interest ($M), Subline-Levered LP IRR (%), and Net LP TVPI Multiple Dilution (x).

Read the guide →
Private Equity Fund Finance, ILPA Reporting & Subscription Facilities

PE Subscription Line IRR Uplift vs TVPI Dilution Formula

Compare Unlevered Day-1 Capital-Call IRR against Subscription-Credit-Facility ("Sub-Line") Deferred LP Capital-Call IRR, Financed LP Drawdown Including Interest, and Sub-Line Net TVPI Multiple Dilution.

Read the guide →
Dairy Standardization, Beverage/Feed Formulation & Mass-Balance Blending

Pearson Square Dairy Butterfat & Two-Stream Blend Formula

Calculate Pearson Diagonal Parts of High-Concentration Stream, Diagonal Parts of Low-Concentration Stream, Exact High-Stream Mass (kg), and Exact Low-Stream Mass (kg).

Read the guide →
Healthcare & Clinical Calculators

Pediatric Appendicitis Score: Eight Factors and Limits of a Spreadsheet

Add the eight documented Pediatric Appendicitis Score findings and understand why the result cannot diagnose or exclude appendicitis on its own.

Read the guide →
Clinical Medicine & Physiology

Pediatric skinfold research: measurement sums and limitations

Explore the sum of triceps and subscapular skinfold measurements and the limits of historical body-composition equations.

Read the guide →
Healthcare & Clinical

Pediatric Trauma Score: Adding Six Component Points

Practice summing the published component-point values with complete and discrete input checks.

Read the guide →
Learn with AI

Peer review a spreadsheet answer: value, formula and explanation

Use a two-person practice exercise to distinguish a correct number from a reusable formula. Discuss a cell, propose a correction and verify it before acceptance.

Read the guide →
Financial

PEG Ratio & Benjamin Graham Number SQRT(22.5 * EPS * BVPS) stock valuation

Practice PEG and the Graham-number heuristic using consistent per-share inputs. Neither calculation establishes fair value or investment suitability.

Read the guide →
Healthcare & Clinical Calculators

PELOD-2 Research and the Logistic Function: A Spreadsheet Example

Explore a fictional logistic transformation and read the original PELOD-2 pediatric intensive-care research.

Read the guide →
Engineering & Science

Peltier Thermoelectric Cooler (TEC) Net Cooling Power (Qc) & Optimal Current (Imax)

Model solid-state Peltier laser/CCD cooling modules via the 3-term cold-plate energy balance Q_c = S_m * T_c * I - 0.5 * I^2 * R_m - K_m * (T_h - T_c) (Watts) and maximum-cooling current I_max = (S_m * T_c) / R_m.

Read the guide →
Electrochemical Engineering, Green Hydrogen & PEM / Alkaline Electrolyzers

PEM Electrolyzer Faradaic H2 Rate & LHV Efficiency Formula

Calculate Multi-Cell PEM / Alkaline Electrolyzer Stack DC Input Power (MW), Faradaic Hydrogen Mass Production Rate (kg H2/hr), Specific Stack Energy Consumption (kWh/kg H2), and Lower Heating Value (33.33 kWh/kg) Efficiency.

Read the guide →