Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Financial analysis

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 Sizing

Pneumatic 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 & Fitness

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

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

Pockels 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 Trials

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

Point-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 Radiation

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

Poisson 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 Visualization

Polar 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 →
Operations

Pollaczek-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 Nip

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

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

Poole-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 Modeling

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

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

Population 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 Chemistry

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

Position & 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 Financing

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

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

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

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

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

PPMT 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 →
Healthcare

Practice 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 →
Logical

Practice 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 Microstructure

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

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

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

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

Precision, 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 →
Financial

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

Present 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 Protection

Press-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 Integrity

Pressure-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 & Metrology

Preston 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 Concrete

Prestressed 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 & Cleaning

Prevent 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 & Audit

Prevent 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 Optimization

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

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

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

Priestley-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 →
Logical

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

PRISM 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 Formulas

PRISMA-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 Auditing

Probabilistic 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 Trading

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

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