Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Quantitative Finance & Derivatives

Rubinstein Simple Chooser Option Formula: Call-or-Put Decision Date

Price a simple chooser option in Excel and Arte Sheets via Rubinstein’s (1991) put-call parity decomposition into a T-maturity call plus a t_c-maturity shifted-strike put.

Read the guide →
Financial

Rule of 72 vs exact doubling & tripling time formula (LN(2) / LN(1 + r))

Calculate exact compound doubling time LN(2)/LN(1+r), continuous doubling LN(2)/r, and N-fold multiplication time—and see where Rule of 72 drifts.

Read the guide →
Financial

Rule of 78s interest allocation: rebate and straight-line comparison

Illustrate sum-of-digits allocation for a precomputed finance charge. Compare with straight-line allocation, not an actuarial payoff calculation.

Read the guide →
Math & Trig

Running balance with debits and credits (checkbook and ledger formula)

Maintain a cumulative bank or ledger balance across separate Deposit and Withdrawal columns while hiding totals on unposted rows.

Read the guide →
Statistical

Running count of occurrences in a list (1st, 2nd, 3rd repeat)

Number each appearance of a customer or SKU sequentially down a table with SUMPRODUCT(--($A$2:A2=A2)) and build unique composite keys.

Read the guide →
Financial

Running Cumulative Balance, Compound Wealth Index, and High-Water Mark (SCAN & REDUCE Formulas)

Generate step-by-step intermediate accumulator states (running cash balance, compounded wealth index, and running high-water mark) alongside terminal totals.

Read the guide →
Lookup & Reference

Running Occurrence Count by Customer or SKU (Expanding COUNTIF)

Number each repeat occurrence of an item sequentially (1st, 2nd, 3rd order per customer) using an anchored expanding range =COUNTIF($A$2:A2, A2) and build unique composite lookup keys.

Read the guide →
Process Safety, ASME Section VIII UG-127 & Rupture Disks

Rupture Disk: Manufacturing Range and Burst Tolerance

Distinguish a manufacturing design range from a tolerance around a marked burst pressure using a manufacturer’s illustrative example.

Read the guide →
Chemical & Pharmaceutical Solid-Liquid Separation, Ruth Cake Filtration & Filter Press

Ruth Constant-Pressure Cake Filtration Time Formula

Calculate Total Dry Filter Cake Deposited (kg), Parabolic Cake-Resistance Filtration Time (min), Linear Filter-Cloth Resistance Time (min), and Total Cycle Filtration Time (min).

Read the guide →
Financial

SaaS cohort retention table: mixed-reference retention % and weighted cohort average

Divide active customers in Month 1, 2, 3... by locked Month-0 cohort size ($B2) while hiding unelapsed triangle cells.

Read the guide →
SaaS Metrics, Venture Growth Benchmarks & Cohort Retention Economics

SaaS Gross Revenue Retention (GRR) & Bessemer Score Formula

Calculate Enterprise SaaS Gross Revenue Retention (GRR <= 100%), Net Dollar Retention (NDR), Bessemer Venture Partners Capital Efficiency Score (Net New ARR / Net Burn), and Ending Total ARR ($M).

Read the guide →
Financial

SaaS MRR waterfall: Ending MRR, Gross Retention (GRR), and Net Dollar Retention (NDR)

Reconcile Starting, New, Expansion, Contraction, and Churned MRR and compute commonly used GRR and NDR percentages.

Read the guide →
Financial

SaaS Quick Ratio & Net New MRR / ARR waterfall formula (growth vs churn)

Measure subscription growth efficiency via (New MRR + Expansion MRR) / (Churned MRR + Contraction MRR) alongside Net New ARR.

Read the guide →
SaaS FP&A & ASC 606 Revenue Accounting

SaaS RPO, Calculated Billings & Book-to-Bill Formula

Reconcile ASC 606 / IFRS 15 Calculated Billings (Revenue + Delta Deferred Revenue), Remaining Performance Obligations (RPO = Deferred Revenue + Unbilled Backlog), Contracted Net Bookings, and RPO Book-to-Bill.

Read the guide →
Financial

SaaS Rule of 40, Magic Number, and Burn Multiple formulas

Benchmark SaaS growth efficiency using Rule of 40 (Growth % + FCF Margin %), Go-to-Market Magic Number, and Capital Burn Multiple.

Read the guide →
Power-to-Gas (PtG), E-Methane & Carbon Utilization Engineering

Sabatier CO2 Methanation H2 Demand, SNG & Heat Recovery Formula

Calculate Stoichiometric Green H2 Feed (kg/hr), Synthetic Natural Gas CH4 Output (kg/hr), Condensed Byproduct Water (kg/hr), and Exothermic Reactor Steam Duty (MWth).

Read the guide →
Engineering

Sabine & Eyring Reverberation Time (RT60) Room Acoustics Formulas

Compare Sabine and Eyring diffuse-field reverberation estimates using room volume, total surface area and a frequency-specific average absorption coefficient.

Read the guide →
Engineering & Science

Sackur-Tetrode Equation: Absolute Quantum Molar Entropy of Monatomic Gases

Calculate the absolute statistical-mechanics molar entropy S_m = R * (1.5*LN(M) + 2.5*LN(T) - LN(P_bar) - 1.15171) (J/(mol·K)) of noble gases directly from Planck’s constant.

Read the guide →
Corrosion Engineering, Subsea Pipelines & Offshore Structures

Sacrificial-Anode Cathodic Protection Mass & Count Formula

Calculate DNV-RP-B401 Galvanic Cathodic Protection Mean Current Demand (A), Required Net Anode Mass (kg), Minimum 150 kg Al-Zn-In Anode Count, and Gross Installed Anode Mass (kg).

Read the guide →
Powertrain & Off-Highway Machine Elements, ISO 4156 / ANSI B92.1 Involute Spline

SAE / ISO 4156 Involute Spline Flank & Shear Formula

Calculate Total Pitch-Circle Tangential Force (kN), Load-Shared Tooth Flank Compressive Stress (MPa), Minor-Root Torsional Shear Stress (MPa), and % of 120 MPa Case-Hardened Limit.

Read the guide →
Statistical

Safety stock formula: combine demand volatility and supplier lead-time variance

Size warehouse safety stock for 95% or 99% cycle service levels using Z * SQRT(AvgLeadTime * DemandSD^2 + AvgDemand^2 * LeadTimeSD^2).

Read the guide →
Mineral Comminution, SAG/Ball Grinding Mills & Liner Mechanics

SAG & Ball Mill Critical Centrifuging Speed (%Nc) Formula

Calculate Effective Ball-Center Orbit Diameter (D - d), Critical Centrifuging Speed N_c (RPM), Operating Percent Critical Speed (%Nc), and Grinding Motion Regime.

Read the guide →
Engineering & Science

Sagnac Interferometer Phase Shift Formula (Fiber-Optic Gyroscope FOG)

Calculate counter-propagating laser Sagnac phase shift Δφ = (2 * π * L * D * Ω_rad_s) / (λ * c) (radians) in aerospace and subsea inertial navigation fiber-optic gyroscopes.

Read the guide →
Science

Saha Thermal Ionization Equation (Stellar & Laboratory Plasma)

Estimate the ionized fraction of pure atomic hydrogen in a ground-state LTE approximation. Use a log-domain Saha ratio and a stable quadratic solution to avoid cancellation at high ionization.

Read the guide →
Engineering & Science

Saha Thermal Ionization Equation & Plasma Ionization Fraction (x)

Calculate the dimensionless Saha equilibrium constant K_Saha and quadratic plasma ionization degree x = (-K + SQRT(K^2 + 4*K)) / 2 for stellar atmospheres (A0 stars) and ICP spectroscopy.

Read the guide →
Mechanical & Structural Engineering

Saint-Venant Rectangular Bar Torsion Constant and Peak Shear Stress

Avoid the circular polar-inertia J_p trap on rectangular shafts by computing Saint-Venant torsional stiffness K_tor, twist angle, and midpoint long-side peak shear stress.

Read the guide →
CMOS Digital Design & Low-Power Electronics

Sakurai Alpha-Power CMOS Delay & EDP Formula

Calculate CMOS Dynamic Switching Energy E_dyn = C_L * V_DD^2, Sakurai Velocity-Saturated Propagation Delay t_p = 0.5 * C_L * V_DD / (K_d * (V_DD - V_th)^alpha), Shockley Square-Law Bias, and Energy-Delay Product (EDP).

Read the guide →
Statistical

Salary benchmarking formulas: Compa-Ratio, Range Penetration, and Percentile Rank

Compare salary with a defined band midpoint and range, and calculate a rank within the example peer set.

Read the guide →
Charts & Visual Data

Sales Funnel Chart Formula: Invisible Centering Spacer & Stage Drop-Off %

Construct a centered horizontal Sales Funnel on any stacked bar chart by computing the exact left-padding spacer (Top_Stage - Stage_i) / 2 alongside stage-to-stage conversion and leakage rates.

Read the guide →
SaaS RevOps & FP&A Capacity Planning

Sales Rep Ramp Quota Capacity & Attrition Formula

Calculate Ramped Rep Equivalents (RRE), Street Quota Capacity, and Attrition-Adjusted Expected Bookings against Board ARR targets using SUMPRODUCT.

Read the guide →
Finance & Accounting

Sales Tax Rate Lookup with Tax-Exempt Override (XLOOKUP + IF)

Calculate invoice sales tax and gross total dynamically by combining IF(Tax_Exempt = "Yes", 0, XLOOKUP(...)) with missing-jurisdiction validation.

Read the guide →
Healthcare & Clinical Formulas

SALT Scalp Hair-Loss Score: Weighted Regions and Change from Baseline

Practice the four-region weighted SALT arithmetic and distinguish an absolute score from relative change over time.

Read the guide →
Healthcare & Clinical Formulas

SAMe-TT₂R₂: An Educational Weighted-Points Example

Practice a historical six-flag weighted point sum; the worksheet does not predict an individual response or select an anticoagulant.

Read the guide →
Quantitative Finance

Sample & Population Covariance Formula (COVARIANCE.S / .P) & CAPM Beta

Calculate Population Covariance Cov_P = CORREL(X, Y) * STDEV.P(X) * STDEV.P(Y), Bessel-corrected Sample Covariance Cov_S = CORREL(X, Y) * STDEV.S(X) * STDEV.S(Y), and CAPM Market Beta = Cov(R_i, R_m) / Var(R_m).

Read the guide →
Statistical Analysis

Sample & Population Excess Kurtosis (KURT Fourth-Moment Tail Risk Formula)

Compute unbiased Fisher sample excess kurtosis (KURT) and population excess kurtosis from standardized fourth moments to detect fat-tailed (leptokurtic) vs thin-tailed (platykurtic) series.

Read the guide →
Statistical & Aggregation

Sample & Population Skewness Formulas (SKEW vs SKEW.P Third Standardized Moment)

Measure distribution asymmetry and tail direction using both the adjusted Fisher-Pearson sample skewness (SKEW, requiring n >= 3) and population skewness (SKEW.P) built from SUMPRODUCT, AVERAGE, STDEV.S, and STDEV.P.

Read the guide →
Healthcare & Clinical

Sampson–NIH LDL-C and Non-HDL Cholesterol Examples

Compare a calculated LDL-C estimate with the separate non-HDL cholesterol arithmetic, using fictional values in mg/dL.

Read the guide →
Healthcare & Clinical Calculations

Sampson–NIH LDL-C Equation: An Estimated Value

Calculate the 2020 Sampson–NIH LDL-C estimate with fictional lipid values and compare it with a Friedewald estimate when appropriate.

Read the guide →
International Trade & Customs Analytics

Samuelson Iceberg Trade Cost & CIF/FOB Wedge Formula

Convert customs CIF and FOB prices into Paul Samuelson’s (1954) iceberg factor tau = P_CIF / P_FOB >= 1, melting loss share (tau - 1) / tau, and Eaton-Kortum trade attenuation tau^(-theta).

Read the guide →
Public Economics & Mechanism Design

Samuelson Public-Good Rule & Lindahl Benefit Price Formula

Sum marginal willingness-to-pay schedules vertically via Samuelson’s rule SUM(MRS_i) = MC_G, compare against free-rider voluntary provision, and solve Lindahl benefit prices.

Read the guide →
Healthcare & Clinical

San Francisco Syncope Rule: CHESS Factors and Limitations

Count the five published CHESS factors with fictional inputs and understand why a negative rule is not a guarantee of safety.

Read the guide →
Foundry Mold Engineering, Archimedes Metallostatic Core Lift & Chaplet Design

Sand-Casting Core Buoyancy & Top Chaplet Load Formula

Calculate Dry Resin-Sand Core Weight (N), Upward Molten-Metal Archimedes Buoyancy (N), Net Upward Core Float Force (N), and Factored Top-Chaplet Hold-Down Load (N).

Read the guide →
Dairy, Brewery & Biopharma Hygienic Engineering, 3-A / ASME BPE CIP Spray-Ball & Scour

Sanitary CIP Spray-Ball Wetting & Return Scour Formula

Calculate Vessel Internal Circumference (m), Falling-Film Perimeter Wetting Rate (L/(min·m)), CIP Return-Pipe Velocity (m/s), and % of 3-A 1.52 m/s Turbulent Scour Minimum.

Read the guide →
Healthcare & Clinical Calculators

SAPS 3 Research and a Fictional Logarithmic Transform

Learn the context of the SAPS 3 admission research model and practice a separate fictional logarithmic formula.

Read the guide →
Healthcare & Clinical Formulas

SAPS II Research and a Fictional Logistic Formula

Read about the original SAPS II hospital-outcome model and practice a separate fictional logistic calculation.

Read the guide →
Statistical & Clinical Analysis

SARC-F Score Formula: A Sarcopenia Screening Example

Sum five SARC-F item scores and understand what a positive or negative screening result can and cannot tell you.

Read the guide →
Econometrics & Causal Inference

Sargan-Hansen Overidentifying Restrictions J-Statistic Formula

Calculate Sargan’s J = N * R^2_aux overidentification statistic with df = L_excl - K_endog and catch the exact-identification trap (L_excl = K_endog -> df = 0).

Read the guide →
Satellite Communications & RF Systems Engineering

Satellite EIRP, G/T & Carrier-to-Noise C/N0 Formula

Calculate Effective Isotropic Radiated Power EIRP_dBW = P_tx + G_tx - L_feed, Carrier-to-Noise Spectral Density C/N0 = EIRP - L_path + G/T + 228.6 dB-Hz, and Digital Demodulator E_b / N0.

Read the guide →
Semiconductor Thin-Film Deposition & Vacuum Metrology

Sauerbrey QCM Thin-Film Mass & Frequency Shift Formula

Calculate Vacuum PVD/ALD Thin-Film Areal Mass Density (ug/cm^2 = 0.1 * t_nm * rho_g_cm3), AT-Cut Quartz Sauerbrey Sensitivity C_f = 2.264 * f_0_MHz^2, Crystal Resonance Drop Delta_f (Hz), and 2% Crystal Replacement Gate.

Read the guide →
Operations Research & Inventory Management

Scarf Distribution-Free Min-Max Newsvendor Formula

Hedge unknown demand tail shapes using Herbert Scarf’s (1958) distribution-free min-max newsvendor order Q* = mu + (sigma / 2) * (SQRT(beta / (1 - beta)) - SQRT((1 - beta) / beta)).

Read the guide →