Learn one useful thing today.
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 →TextPad 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 ManipulationPad 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 →TextPad 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 StatisticsPage’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 ModelingPain 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 →EngineeringPaint 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 LogisticsPalm’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 & AccountingPalma 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 →EngineeringPalmgren-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 DataPanel 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 EngineeringPaper 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 BalancePaper 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 & TradingParabolic 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 MechanicsParachute 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 ControlParallel 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 →StatisticalPareto 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 PricingPareto 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 MechanicsParis-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 →EngineeringParis' 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 →FinanceParkinson 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 & TimeParse 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 →TextParse 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 & CleaningParse 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 →TextParse 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 & OperationsPart-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 & ReferencePartial 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 & ReferencePartial-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 & SciencePaschen'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 CalculationsPASI 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 PlumePasquill-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 & PsychometricsPassing-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 →FinancialPayback 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 ViasPCB 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 & AccountingPDURATION & 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 ReportingPE & 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 ClawbackPE 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 AccountingPE 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 RiskPE 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 AttributionPE 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 FacilitiesPE 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 BlendingPearson 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 CalculatorsPediatric 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 & PhysiologyPediatric 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 & ClinicalPediatric Trauma Score: Adding Six Component Points
Practice summing the published component-point values with complete and discrete input checks.
Read the guide →Learn with AIPeer 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 →FinancialPEG 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 CalculatorsPELOD-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 & SciencePeltier 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 ElectrolyzersPEM 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 →