Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Geotechnical Earthwork QA/QC, ASTM D698 / D1557 Proctor Compaction & Zero-Air-Voids

Proctor Soil Compaction Dry Density & ZAV Curve Formula

Calculate In-Situ Dry Unit Weight gamma_d = gamma_m/(1+w) (kN/m³), Theoretical 100%-Saturated Zero-Air-Voids Ceiling gamma_ZAV (kN/m³), Relative Proctor Compaction (%), and >= 95% Spec Gate.

Read the guide →
Math

PRODUCT function: multiply chained yield factors and sequential discounts

Multiply an entire column of growth multipliers or manufacturing stage yields with PRODUCT while skipping blank and text cells.

Read the guide →
Math & Trig

Project completion percentage: task count vs effort-weighted progress

Avoid false progress spikes on small chores by weighting each task's % complete by budgeted hours with SUMPRODUCT.

Read the guide →
Date & Time

Project midpoint date and % schedule time elapsed (calendar vs workdays)

Find a calendar-date midpoint and an inclusive workday schedule ratio.

Read the guide →
Behavioral Economics & Decision Analysis

Prospect Theory Value & Prelec Weighting Formula

Evaluate reference-dependent gains and losses via Kahneman and Tversky’s (1992) asymmetric value function v(x) and Drazen Prelec’s (1998) inverse-S probability weight w(p) = EXP(-((-LN(p))^gamma)).

Read the guide →
Engineering & Science

Psychrometric Humidity Ratio (g/kg) & Moist Air Specific Enthalpy (ASHRAE / Arden Buck)

Calculate saturation vapor pressure Pws via the Arden Buck equation, humidity ratio W = 0.621945 * Pw / (Patm - Pw) in g/kg dry air, and moist-air specific enthalpy h in kJ/kg dry air.

Read the guide →
Industrial Dust Collection, Fabric Filtration & Fan Sizing

Pulse-Jet Baghouse Gross vs Net Air-to-Cloth Ratio Formula

Calculate Pulse-Jet Baghouse Single-Bag Area (ft²), Gross Air-to-Cloth Velocity (fpm), Net (N-1 Compartment Offline) Air-to-Cloth Velocity (fpm), and Filter Cake Pressure Drop (in. w.g.).

Read the guide →
Autonomous Sensing, Photonics & LiDAR Systems

Pulsed ToF LiDAR Power & Unambiguous Range Formula

Calculate Laser Time-of-Flight Round-Trip Delay (ns), Extended-Target Lambertian Received Power P_rx = P_pk * rho * (D^2 / (4 * R^2)) * eta, and Maximum Unambiguous PRF Range.

Read the guide →
Composites Manufacturing, Pultrusion Heated-Die Residence Time, Pull Force & Line Speed

Pultrusion Composite Die Residence Time & Pull Force Formula

Calculate Heated-Die Cure Residence Time (s), Net Fiber Cross-Section Area (mm²), Viscous-Gelation Die Wall Pull Force (kN), and Continuous Profile Mass Output (kg/h).

Read the guide →
Engineering

Pump NPSHa (Net Positive Suction Head Available) & Cavitation Margin formula

Estimate available suction head from a large reservoir and compare it with a supplied pump requirement and an explicit illustrative margin.

Read the guide →
Grid-Scale Long-Duration Storage, Hydropower Engineering & Power Markets

Pumped-Storage Hydro Reservoir MWh & Grid Arbitrage Formula

Calculate Pumped-Storage Hydropower (PSH) Upper-Reservoir Gravitational Potential Energy (MWh = 2.725 * Mm³ * Head_m), Generated MWh Delivered, AC-to-AC Round-Trip Efficiency, and Full-Cycle Duck-Curve Arbitrage Margin ($).

Read the guide →
Engineering & Science

Purcell Factor (F_P) & β-Factor Spontaneous Emission Enhancement Formula

Calculate Edward Purcell’s cavity QED spontaneous emission enhancement F_P = (3 / (4 * π^2)) * (Q / V_norm) and single-photon waveguide coupling efficiency β = F_P / (F_P + 1).

Read the guide →
Financial

Purchasing Power Parity (PPP) implied FX rate & currency over/under-valuation

Compare an illustrative matched-basket price ratio with a spot rate and model an inflation-ratio scenario. These are not forecasts of fair market exchange rates.

Read the guide →
Analytical Chemistry & Pharmaceutical QC

Purnell Chromatography Peak Resolution Rs Formula

Calculate Retention Factor k_2 = (t_R2 - t_0) / t_0, Selectivity Factor alpha = k_2 / k_1, Purnell Master Resolution R_s = (SQRT(N)/4) * ((alpha - 1)/alpha) * (k_2 / (1 + k_2)), and USP R_s >= 1.5 Separation Gate.

Read the guide →
Text

Put double quotes inside a formula: "" escaping vs CHAR(34)

Generate quoted CSV fields, JSON payloads, and HTML attributes cleanly using doubled "" quotes or readable CHAR(34).

Read the guide →
Financial analysis

PV function: find the maximum loan a monthly budget can support

Discount a fixed monthly repayment stream back to today’s affordable loan principal with PV, and verify how rising interest rates shrink borrowing capacity.

Read the guide →
Math & Everyday Calculations

Pythagorean Theorem Formula: Hypotenuse, Missing Leg & 3D Box Diagonal

Calculate right-triangle hypotenuse c = SQRT(a^2 + b^2), solve for an unknown leg b = SQRT(c^2 - a^2) with triangle-inequality validation, and find 3D shipping-crate space diagonal d = SQRT(L^2 + W^2 + H^2).

Read the guide →
Statistical

Pythagorean Win Expectation formula (Bill James Sports Analytics)

Compare observed wins with a scoring-based Pythagorean model estimate, using an explicitly chosen exponent.

Read the guide →
Restaurant & Retail Operations, Multi-Unit Franchising & Unit Economics

QSR Franchise Royalty, Four-Wall EBITDA & Cash-on-Cash Formula

Calculate Quick-Service Restaurant (QSR) Franchise Gross-Sales Royalty + National Brand Ad-Fund Assessment ($), Net Franchisee Four-Wall EBITDA ($), Unlevered Buildout Cash-on-Cash Return, and Simple Capex Payback Period (Years).

Read the guide →
Charts & Data Visualization

Quadrant Chart (2x2 Matrix) Formula: Crosshair-Centered XY & Quadrant Classifier

Build a 2x2 Strategic Quadrant Scatter Chart (BCG Growth-Share, Value-vs-Effort, Price-vs-Quality) by centering coordinates at origin (X - X_cut, Y - Y_cut) so plot axes form natural crosshairs and classifying items into Q1–Q4.

Read the guide →
Industrial Organization & Spatial Pricing

Quadratic Hotelling Maximal Differentiation Price Formula

Calculate d’Aspremont, Gabszewicz, and Thisse’s (1979) quadratic-transport spatial Nash equilibrium prices p_1* = c + t*(1 - a - b)*(1 + (a - b)/3) and prove maximal product differentiation.

Read the guide →
Mergers & Acquisitions, Financial Due Diligence & Quality of Earnings

Quality of Earnings (QoE) Adjusted & Pro-Forma EBITDA Formula

Calculate Buy-Side/Sell-Side Quality of Earnings (QoE) Normalized EBITDA (Reported EBITDA + Non-Recurring Add-Backs - Non-Operating Gains + Excess Owner Compensation), Full-Year Pro-Forma Run-Rate EBITDA, Implied Headline EV, and Add-Back Reliance Share.

Read the guide →
Engineering & Science

Quantum Barrier Tunneling (STM & Flash Oxide WKB Transmission Formula)

Calculate the evanescent wavefunction decay constant kappa = 5.12317 * SQRT((m_eff / m_0) * (V_0 - E)) (nm^-1) and exponential tunneling transmission probability T_WKB = EXP(-2 * kappa * L) across Scanning Tunneling Microscope (STM) vacuum gaps and gate oxides.

Read the guide →
Thin-Film Optics, Camera Lenses, Solar PV Glass & Photonics

Quarter-Wave Anti-Reflection (AR) Coating Thickness & R% Formula

Calculate Ideal Zero-Reflection Index SQRT(n_0 * n_s), Physical Quarter-Wave Film Thickness d (nm), Bare-Substrate Fresnel Reflectance (%), and Coated Quarter-Wave Reflectance (%).

Read the guide →
RF & Microwave Engineering

Quarter-Wave Impedance Transformer (Z_T) and Off-Frequency VSWR

Size a quarter-wave matching section Z_T = SQRT(Z_0 * R_L) and compute exact off-frequency reflection |Gamma(f/f_0)| and VSWR across fractional bandwidths.

Read the guide →
Statistical

QUARTILE.INC function: split salaries or deal sizes into Q1, median, and Q3 bands

Calculate the 25th, 50th, and 75th inclusive quartile cutoffs and interquartile range (IQR) with QUARTILE.INC.

Read the guide →
Reinsurance & Insurance Accounting

Quota-Share vs Surplus-Share Reinsurance Formula

Compare fixed Quota-Share cession against risk-sized First-Surplus-Share cession MIN(Max_Lines * Line, MAX(0, Sum_Insured - Line)) / Sum_Insured, Ceding Commission, and Net Retained Cash Flow.

Read the guide →
Math

QUOTIENT function: calculate full cases or whole hours without remainders

Return only the integer portion of division with QUOTIENT, and pair it with MOD to split totals into full packs plus leftovers.

Read the guide →
Statistical & Clinical Analysis

R-ISS for Multiple Myeloma: Staging Logic and Its Limits

Explore the original 2015 R-ISS criteria and how complete laboratory inputs affect an educational staging-logic example.

Read the guide →
Statistical

R-Squared (R^2) and linear regression residuals formula

Measure how much variance an OLS trendline explains with CORREL(X, Y)^2 and compute fitted values and residuals Y - Y_hat.

Read the guide →
Quantitative Finance & Risk

Rachev Ratio Formula: Upper Expected Tail Gain vs Lower Expected Tail Loss

Calculate the Rachev tail-asymmetry ratio in Excel and Arte Sheets by dividing upper beta-tail expected excess gain (right-tail ETL) by lower alpha-tail expected excess loss (CVaR).

Read the guide →
Chemical, Process & Catalysis Engineering

Rachford-Rice Isothermal VLE Flash Formula: Bubble/Dew Check & Objective f(V/F)

Test multicomponent feed phase stability (Subcooled Liquid SUM(z_i * K_i) <= 1, Superheated Vapor SUM(z_i / K_i) <= 1, or Two-Phase Flash) and evaluate H. H. Rachford and J. D. Rice’s (1952) monotonic flash residual f(psi).

Read the guide →
Engineering & Science

Rackett Equation: Saturated Liquid Molar Volume & Density

Predict saturated liquid molar volume V_sat = V_c * Z_c^((1 - T / T_c)^(2/7)) (cm^3/mol) and mass density ρ_L = MW / V_sat (g/cm^3) for LPG storage tanks and pressurized liquid pipelines.

Read the guide →
Charts & Data Visualization

Radar (Spider) Chart Formula: 0–100 Multi-Axis Normalization & Polygon Area

Normalize incommensurate KPI units (dollars, milliseconds, percentages) onto a common 0–100 Radar / Spider Chart spoke scale (with polarity inversion for lower-is-better metrics) and compute enclosed K-spoke polygon area.

Read the guide →
Math

RADIANS function: convert degree angles before SIN, COS, and TAN

Convert compass bearings and incline angles from degrees to radians with RADIANS so spreadsheet trigonometry produces accurate ratios.

Read the guide →
Industrial Radiography (RT), Ir-192 / X-Ray Weld Inspection & ASME Sec V Article 2

Radiographic NDT Geometric Unsharpness (Ug) & SFD Formula

Calculate Source-to-Object Distance D_o = SFD - t (mm), Penumbra Geometric Unsharpness U_g = F*t/(SFD - t) (mm), Minimum Code Source-to-Film Distance SFD_min (mm), and ASME Sec V Compliance.

Read the guide →
Operations

RAID Capacity, Mixed-Workload IOPS and Annual Failure Probability

Compare RAID capacity and derive host IOPS from backend operation costs. Explore a one-year drive-failure probability under an explicit constant-hazard model.

Read the guide →
Distributed Storage & Reliability Engineering

RAID-5 MTTDL & Erasure-Coding Overhead Formula

Calculate Patterson-Gibson-Katz RAID-5 Mean Time To Data Loss MTTDL = (MTBF^2) / (N*(N - 1)*MTTR) and compare Reed-Solomon (k + m) erasure-coding storage overhead against 3-way replication.

Read the guide →
Industrial Logistics, Rail Freight Operations & Fleet Capacity Sizing

Railcar Fleet Sizing, Turnaround Cycle & Dwell Cost Formula

Calculate Industrial Railcar Round-Trip Turnaround Cycle Time (Days), Active Operating Cars Required via Little’s Law, Total Leased Fleet Including Bad-Order Maintenance Spares, and Annual Lease Cost Impact of Terminal Dwell.

Read the guide →
Railway & Locomotive Traction Engineering, AREMA Train Resistance, Ruling Grade & Power

Railroad Train Resistance, Ruling Grade & Drawbar Power

Calculate Specific Rolling + Aerodynamic Resistance (N/t), Ruling Grade + Curve Resistance (N/t), Total Coupler Drawbar Tractive Effort (kN), and Rail Drawbar Power (kW).

Read the guide →
Railway Civil Engineering, High-Speed Track Alignment & EN 13803

Railway Equilibrium Cant, Cant Deficiency & Curve Speed Formula

Calculate Standard-Gauge Railway Equilibrium Cant (11.8 * V_kmh^2) / R_m, Uncompensated Cant Deficiency I (mm), Passenger Lateral Acceleration (I / 1500)*9.81, and Maximum Permitted Curve Speed.

Read the guide →
Financial Modeling

Ralph Vince Optimal f Position Sizing: Terminal Wealth Relative & Geometric HPR

Convert empirical trade P&Ls with unequal win/loss magnitudes into Holding Period Returns HPR_i = 1 + f * (-Trade_i / Worst_Loss), Terminal Wealth Relative (TWR), and Geometric Mean HPR G(f).

Read the guide →
Engineering & Science

Raman Shift Wavenumber (cm^-1) & Anti-Stokes / Stokes Boltzmann Ratio Formula

Convert laser excitation and scattered wavelengths (nm) into Raman vibrational shift Delta_nu = (10^7 / lambda_0) - (10^7 / lambda_s) in cm^-1 and compute the vibrational Boltzmann population ratio EXP((-1.4387769 * |Delta_nu|) / T).

Read the guide →
Aerospace Structural Mechanics & Plasticity

Ramberg-Osgood Elastic-Plastic Strain & Secant Formula

Calculate Metallic Elastic Strain sigma / E, MMPDS 0.2%-Offset Ramberg-Osgood Plastic Strain 0.002 * (sigma / sigma_02)^n, Total Nonlinear Strain, and Effective Secant Modulus E_sec.

Read the guide →
Financial & Accounting

Ramsey Rule & Keynes-Ramsey Euler Equation: Social Discount Rate & Consumption Growth

Calculate the social discount rate r = rho + eta * g for climate/infrastructure cost-benefit analysis and optimal per-capita consumption growth g_c = (r - rho) / eta using Frank P. Ramsey’s 1928 intertemporal optimization rule.

Read the guide →
Climate Economics & Benefit-Cost Policy

Ramsey Social Cost of Carbon (SCC) Discounting Formula

Calculate the closed-form Social Cost of Carbon SCC = D_0 / (rho + (eta - 1)*g + phi) and quantify why Nordhaus (rho = 1.5%) vs Stern (rho = 0.1%) discounting shifts carbon prices 2.5x.

Read the guide →
Regulatory Economics & Infrastructure Pricing

Ramsey-Boiteux Regulated Utility Inverse-Elasticity Pricing Formula

Set welfare-maximizing break-even tariffs P_i = MC_i / (1 - R_ramsey / |e_i|) across multi-segment rail, power, or water utilities using the Ramsey-Boiteux rule.

Read the guide →
Math

RANDBETWEEN and RAND: generate bounded integer and decimal test samples

Create synthetic QA datasets with inclusive integer RANDBETWEEN(bottom, top) and continuous [0, 1) RAND() scaling.

Read the guide →
Engineering & Science

Randles-Sevcik Equation: Cyclic Voltammetry Peak Current (ip) & Reversible Peak Split

Calculate Nernstian cyclic voltammetry peak current ip = 2.686e5 * n^1.5 * A * SQRT(D) * C0 * SQRT(v) at 25 °C in microamps and reversible peak-to-peak separation Delta_Ep = 59.2 / n mV.

Read the guide →
Lookup & Reference

Randomly Assign Rows to Equal-Sized Balanced Groups (RANK + MOD + INDEX)

Eliminate lopsided RANDBETWEEN group sizes by ranking pre-drawn random decimals with RANK(B2, $B$2:$B$7) and cycling evenly through group labels via INDEX($E$2:$E$4, MOD(Rank - 1, K) + 1).

Read the guide →