Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Industrial Organization & Game Theory

Stackelberg Leader-Follower Duopoly Output & Profit Formula

Solve backward-induction Stackelberg leader output q_L* = (a - 2*c_L + c_F)/(2*b), follower output q_F* = MAX(0, (a - c_F - b*q_L*)/(2*b)), market price, and first-mover profit gain over Cournot.

Read the guide →
Math & Trig

Staffing FTE & shrinkage formula: why you divide by (1 - Shrinkage%)

Convert contact-center or back-office volume and Average Handle Time into Workload Hours, Productive FTEs, and Shrinkage-grossed Headcount.

Read the guide →
Statistical Analysis

Standard Error of Measurement (SEM) & 95% Minimal Detectable Change (MDC95)

Convert baseline standard deviation and test-retest reliability (ICC) into Standard Error of Measurement SEM = SD * SQRT(1 - ICC) and two-measurement Minimal Detectable Change MDC_95.

Read the guide →
Statistical Analysis

Standard Normal Cumulative Probability, GAUSS Band & Inverse Quantile (NORM.S.DIST & NORM.INV)

Compute left-tail normal probabilities Phi(z), center-to-z GAUSS intervals Phi(z) - 0.5, and inverse normal quantile cutoffs x = mu + z_p * sigma using portable rational polynomials.

Read the guide →
Engineering & Science

Stanton Number (St) & Chilton-Colburn jH Heat-Momentum Analogy Formula

Calculate the dimensionless Stanton Number St = Nu / (Re * Pr) and Chilton-Colburn heat-transfer factor j_H = St * Pr^(2/3) to estimate convective heat transfer directly from Fanning skin-friction drag (j_H ~ f / 2).

Read the guide →
Semiconductor Yield Engineering & VLSI

Stapper Negative-Binomial & Bose-Einstein Yield Formula

Calculate Charles Stapper’s Negative-Binomial Clustered Wafer Yield Y_NB = (1 + D_0 * A / alpha)^(-alpha), Bose-Einstein Single-Layer Yield (alpha = 1), and Multi-Mask Critical-Layer Bose-Einstein Yield.

Read the guide →
Microvascular Physiology, Nephrology & Critical Care Medicine

Starling Forces: A Classical Fluid-Flux Example and Revised Physiology

Explore a classical pressure-balance equation with fictional values and learn why the revised glycocalyx model changes its physiological interpretation.

Read the guide →
Descriptive statistics

STDEV.S vs STDEV.P: measure sample variation vs full population spread

Know when to divide squared deviations by n - 1 (STDEV.S for quality samples) or n (STDEV.P for complete populations), and why a single reading returns #DIV/0!.

Read the guide →
Clinical Pharmacokinetics & Dosing Regimens

Steady-State Accumulation: A One-Compartment Arithmetic Model

Explore a geometric-series accumulation factor under explicit model assumptions using a fictional repeated-pulse example.

Read the guide →
Industrial Steam Systems, Boiler Water Chemistry & Energy Recovery

Steam Boiler TDS Blowdown Rate & Flash Heat Loss Formula

Calculate Steam Boiler TDS Cycles of Concentration, Continuous Drum Blowdown Mass Rate (kg/hr), Unrecovered Sensible Blowdown Heat Loss (kW), and Flash-Economizer Heat Recovery (kW).

Read the guide →
Petrochemical Olefins, Naphtha Steam Cracking & Pyrolysis Furnaces

Steam Cracker Ethylene/Propylene (P/E) Ratio & Steam Formula

Calculate Polymer-Grade Ethylene Output (t/hr), Co-Product Propylene Output (t/hr), Cracking Severity P/E Weight Ratio, and Furnace Dilution Steam Rate (t/hr).

Read the guide →
Hydrogen Engineering, Chemical Process Synthesis & Carbon Capture

Steam-Methane Reforming (SMR) H2 & Blue CO2 Intensity Formula

Calculate SMR Hydrogen Plant Total Methane Demand (t/day), Net Specific CO2 Intensity (kg CO2 / kg H2), Daily Captured CO2 Sequestered (t/day), and Residual Stack Emissions (t/day).

Read the guide →
Metallurgical Heat Treatment, Gear Gas/Vacuum Carburizing & Fick’s Second Law

Steel Gas Carburizing Harris Case-Depth & Time Formula

Calculate Arrhenius Carburizing Diffusion Factor KT (mm/sqrt(hr)), Required Furnace Soak Hours (t = (ECD/KT)²), Case Depth Achieved at 4 Hours (mm), and Total Cycle Minutes.

Read the guide →
Structural Steel Stability, AISC 360 / Eurocode 3 Beams & LTB

Steel I-Beam Lateral-Torsional Buckling (Mcr) Formula

Calculate Pure St. Venant Torsional Buckling Term (kN·m), Combined Timoshenko Elastic Critical LTB Moment M_cr (kN·m) including Flange Warping C_w, and Warping Stiffness Boost (%).

Read the guide →
Charts & Data Visualization

Stem-and-Leaf Plot Formula: Tens Stem Extraction, Leaf Digit & Bin Frequency

Construct John Tukey’s Exploratory Data Analysis (EDA) Stem-and-Leaf display in a spreadsheet by splitting observations into integer Stems INT(x / 10), Trailing Leaf Digits MOD(x, 10), and Per-Stem Bin Frequencies COUNTIFS.

Read the guide →
Lookup & Reference

Step across every Nth column when dragging a formula down rows (INDEX & ROW)

Pull values from every Nth horizontal column (e.g., B2, D2, F2) into a vertical summary list as you copy a formula down rows using non-volatile INDEX and ROW.

Read the guide →
Charts & Visual Data Modeling

Step Chart Formula: Piecewise-Constant Rate Staircase Coordinates & Time-Weighted Average

Plot discrete jumps (central-bank policy rates, SaaS pricing tiers, inventory reorders) accurately as a true Step Chart instead of misleading diagonal slopes, and calculate the exact Time-Weighted Average Rate.

Read the guide →
Mechatronics, CNC Motion Control & 3D Printing, Hybrid Stepper Motor Dynamics

Stepper Motor Microstep Resolution & Corner Speed Formula

Calculate Microsteps per Revolution, Ballscrew Linear Microstep Resolution (um), Required Step-Pulse Frequency (kHz), and Inductive L/R Chopper Corner Speed (RPM).

Read the guide →
Additive Manufacturing & Photopolymer 3D Printing, SLA Jacobs Working Curve Cure Depth

Stereolithography (SLA) Jacobs Cure Depth & Overcure Formula

Calculate Gaussian Centerline Peak UV Exposure Emax (mJ/cm²), Jacobs Beer-Lambert Cure Depth Cd (um), Interlayer Stitching Overcure Cd - z (um), and Cured Line Width (um).

Read the guide →
Financial Modeling

Sterling Ratio & Burke Ratio: Multi-Drawdown Risk-Adjusted Portfolio Return

Evaluate CTA and hedge-fund drawdown resilience across multiple historical drawdown episodes using both the classical +10%-buffered Sterling Ratio and quadratic-penalty Burke Ratio.

Read the guide →
Engineering & Science

Stern-Volmer Fluorescence Quenching (I0/I) & Förster FRET Energy Transfer Efficiency

Calculate collisional fluorescence quenching intensity ratio I0/I = 1 + kq * tau0 * [Q] via the Stern-Volmer equation and nanoscale Förster resonance energy transfer efficiency E = 1 / (1 + (r / R0)^6).

Read the guide →
Engineering & Science

Stiel-Thodos High-Pressure & Supercritical Gas Residual Viscosity Formula

Calculate dense-fluid and supercritical CO₂ viscosity η = η_0 + Δη(ρ_r) (µPa·s) across pipelines and compressors using Leonard Stiel & George Thodos’s (1961) reduced-density correlation.

Read the guide →
Produced-Water & Desalination Chemistry, ASTM D4582 Stiff-Davis Brine Scaling Index

Stiff-Davis High-TDS Brine Scaling Index (SDSI) Formula

Calculate Molar Negative Log Calcium pCa, Molar Negative Log Bicarbonate Alkalinity pAlk, Stiff-Davis Ionic-Strength Temperature Constant K, and SDSI Scaling Index.

Read the guide →
Banking, Credit Risk & Information Economics

Stiglitz-Weiss Credit Rationing Rate-Cap Formula

Calculate the Stiglitz-Weiss (1981) bank-optimal interest rate ceiling r_cap* = (R_S - u_0/p_S)/L - 1 and prove why raising loan rates above r_cap* slashes expected bank repayment.

Read the guide →
Biophysics, Colloid & Nanoparticle Science & Dynamic Light Scattering

Stokes-Einstein Nanoparticle Diffusion & RMS Walk Formula

Calculate Stokes-Einstein Brownian Translational Diffusion Coefficient D (µm²/s) from Temperature, Dynamic Viscosity, and Hydrodynamic Radius (nm), plus 3D and 1D Root-Mean-Square (RMS) Displacement (µm) and Characteristic Diffusive Transit Time.

Read the guide →
Engineering

Stokes' Law Terminal Settling Velocity & Laminar Re_p <= 1 Check

Calculate creeping-flow particle settling or rising velocity v_t = (g * d^2 * (rho_p - rho_f)) / (18 * mu) (mm/s) for clarifiers, emulsions, and falling-ball viscometers—with automatic Particle Reynolds Re_p verification.

Read the guide →
Engineering & Scientific

Stokes’ Law Terminal Settling Velocity, Particle Reynolds Gate & Clarifier Capture

Calculate laminar gravitational settling velocity v_s = g*(rho_p - rho_f)*d^2 / (18*mu), validate creeping flow via particle Reynolds number Re_p <= 1, and check sedimentation basin capture.

Read the guide →
Engineering

Stokes's Law Terminal Settling Velocity & Particle Reynolds Check formulas

Calculate the ideal terminal speed of an isolated sphere in a Newtonian fluid and screen the estimated particle Reynolds number.

Read the guide →
International Trade & General Equilibrium

Stolper-Samuelson & Rybczynski Magnification Formula

Solve Ronald Jones’s (1965) 2x2 Heckscher-Ohlin hat-algebra equations to verify Stolper-Samuelson factor-price magnification and Rybczynski endowment-output magnification.

Read the guide →
Health & Fitness

STOP-Bang Sleep Apnea Screening: An Overview and a Binary-Flag Exercise

Learn what STOP-Bang screening is designed to do and practice validating fictional yes/no flags without using this worksheet as a questionnaire.

Read the guide →
Engineering

Streeter-Phelps Dissolved Oxygen (DO) Sag Curve & Critical Time formulas

Model river dissolved oxygen depletion and recovery downstream of a wastewater discharge using Streeter-Phelps deficit D(t), remaining DO = DO_sat - D(t), and critical sag travel time t_c.

Read the guide →
Engineering

Stress, Strain, Young's Modulus & Factor of Safety formulas (PL / AE)

Calculate tensile stress (MPa = N / mm²), elastic elongation ΔL = (P · L) / (A · E), strain ε, and yield Factor of Safety.

Read the guide →
Lookup & Reference

Strict Single-Match Lookup (DGET Uniqueness Guard vs. Silent XLOOKUP First-Match)

Enforce primary-key uniqueness in lookup formulas by reproducing DGET's exact single-record behavior—returning the value when 1 row matches, NO_MATCH when 0 match, and DUPLICATE_KEY when 2+ rows collide.

Read the guide →
Text

Strip all numeric digits (0–9) from a text string (TEXTSPLIT & TEXTJOIN)

Remove digits 0–9 from display text, or replace digit and separator boundaries with spaces. Keep the original identifiers.

Read the guide →
Text

Strip HTML tags from text with a single formula (TEXTSPLIT + FILTER)

Extract text from simple balanced angle-bracket markup with TEXTSPLIT and FILTER; learn the limitations of this formula approach.

Read the guide →
Engineering & Science

Strömgren Sphere Radius (RS) & H II Nebula Recombination Timescale

Calculate the ionization-bounded H II region Strömgren radius RS = ((3 * Q_H) / (4 * PI() * n_H^2 * alpha_B))^(1/3) in parsecs and hydrogen recombination time t_rec = 1 / (n_H * alpha_B) in years.

Read the guide →
Science

Strong Allee Effect Population Growth & Critical Extinction Threshold

Calculate cubic strong Allee population growth rate dN/dt = r * N * (1 - N / K) * (N / A - 1), per-capita growth rate, and extinction-vortex vs carrying-capacity trajectory.

Read the guide →
Statistical & Clinical Analysis

Strong Ion Difference and Strong Ion Gap: Units and Worked Arithmetic

Explore apparent strong ion difference and a simplified strong ion gap approximation, including unit conversion, missing inputs and limitations.

Read the guide →
Engineering

Strouhal Number & Karman Vortex-Shedding Frequency Formula

Estimate stationary-cylinder shedding frequency and nominal frequency-match speed from a supplied Strouhal number, with a configurable comparison band that does not certify structural safety.

Read the guide →
Operations & Analytics

Student Course Enrollment Tracker: Open Seats, Waitlist & Fill Rate

Tally live course registrations from a student roster using COUNTIF, calculate remaining open seats via MAX(0, Cap - Enrolled) and waitlist overflow via MAX(0, Enrolled - Cap), and classify section status.

Read the guide →
Financial Modeling

Stutzer Performance Index: Skewness-Adjusted Sharpe & Cumulant Decay Rate

Adjust the Sharpe ratio for third-moment crash skewness using Michael Stutzer’s (2000) large-deviations information decay rate I_P and Sharpe-equivalent SQRT(2 * I_P).

Read the guide →
Text

Substitute multiple values at once: template placeholders and mixed delimiters

Replace Name and Plan placeholders sequentially, or normalize the example’s mixed separators.

Read the guide →
Cleaning imported data

SUBSTITUTE vs REPLACE: swap matching text or overwrite by position

Use SUBSTITUTE when you know which text to swap (all occurrences or a chosen Nth match), and REPLACE when you know the character start index and length.

Read the guide →
Math

Subtotal by invoice number on first row only (Prevent double-counting fees)

Show one merchandise subtotal and one repeated invoice-level freight charge per invoice, with an explicit consistency check.

Read the guide →
Math

SUBTOTAL function: sum filtered tables and prevent double-counting section totals

Use SUBTOTAL function codes (9 vs 109) so filtered views recalculate visible rows and grand totals skip nested section subtotals.

Read the guide →
Financial

Subtotal open invoices by invoice-age brackets with SUMIFS

Aggregate open invoice balances into standard 30-day AR aging subtotal buckets using elapsed age DaysOld = AuditDate - InvoiceDate and SUMIFS.

Read the guide →
Economics & Market Microstructure

Suits Index of Tax Progressivity (S) Formula: Tax-vs-Income Trapezoidal Integral

Calculate Daniel B. Suits’s (1977) Tax Progressivity Index S = 1 - SUM((T_i + Ti-1) * (Y_i - Yi-1)) across income brackets (-1 regressive to +1 ultra-progressive, 0 flat tax) directly from cumulative income and tax shares.

Read the guide →
Date & Time

Sum & Average Daily Revenue by Day of Week (WEEKDAY + SUMIF)

Aggregate daily POS or e-commerce transactions by ISO day of week (Monday = 1 through Sunday = 7) and split weekday vs. weekend totals using WEEKDAY(A2, 2) + SUMIF.

Read the guide →
Dynamic Arrays

Sum an entire 2D matrix across columns matching a header tag (SUM & FILTER)

Total a multi-row, multi-column 2D table (B3:E5) across ONLY the columns whose Row-2 status tag equals "Active"—solving the classic 2D SUMIF limitation cleanly.

Read the guide →
Date & Time

Sum and average by calendar month across years

Group dated observations by month and compare a group average with the overall sample average.

Read the guide →