Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Naval Architecture, Hydrostatic Stability & Maritime Safety

Ship Metacentric Height (GM), Transverse BM & Righting Arm GZ

Calculate Vessel Transverse Metacentric Radius BM = I_T / Disp_Vol, Free-Surface-Corrected Fluid Metacentric Height GM_eff = KB + BM - KG - FSC, Small-Angle Righting Lever GZ = GM_eff*SIN(theta), and IMO Intact Stability Compliance.

Read the guide →
Merchant Marine Cargo Operations, Plimsoll Load Lines & Hydrostatics

Ship Tons Per Centimeter (TPC) & Freshwater Allowance Formula

Calculate Saltwater Tons Per Centimeter Immersion TPC (t/cm), Plimsoll Freshwater Allowance FWA (mm), Brackish Dock Water Allowance DWA (mm), and Extra Permissible Cargo Mass (t).

Read the guide →
Statistical

Shock Index (HR / SBP), Modified Shock Index (HR / MAP) & Age Shock Index

Calculate heart-rate/blood-pressure ratios and an age-weighted index from consistently measured adult vital signs, without automatic diagnostic classification.

Read the guide →
Semiconductor Physics, Photovoltaics & Tandem Solar Cell Engineering

Shockley-Queisser Bandgap Thermalization & Voc Loss Formula

Calculate Solar Cell Sub-Bandgap Transmission vs Hot-Carrier Phonon Thermalization Loss (eV), Detailed-Balance Open-Circuit Voltage Voc (V), Extracted Electrical Work Per Photon (eV), and Monochromatic Photon Conversion Efficiency.

Read the guide →
Aerospace SAE J2277 / AMS 2430 Shot Peening, Compressive Residual Stress & Fatigue

Shot Peening Surface Coverage & Pass Count Formula

Calculate Multi-Pass Peened Dimple Coverage Cn = 1 - (1 - C1)^n (%), Residual Unpeened Parent Surface (%), Exact Continuous Passes for 98% Full Coverage, and Required Integer Nozzle Passes.

Read the guide →
Civil Engineering, Tunneling & Materials

Shotcrete: Geometric Volume and Rebound Mass Example

Practice the separate calculations for nominal lining volume and measured rebound by mass, and understand why neither determines tunnel-support safety.

Read the guide →
Engineering & Science

Shubnikov-de Haas (SdH) Onsager Frequency to 2DEG Carrier Density Formula

Extract two-dimensional electron gas (2DEG) sheet carrier density n_2D = 0.2418 * g_s * g_v * B_F (× 10^11 cm^-2) directly from 1/B Shubnikov-de Haas oscillation frequency B_F (Tesla).

Read the guide →
Lookup & Reference

Shuffle Rows & Draw a Sample Without Replacement (SORTBY + TAKE)

Sort rows by frozen random keys and select K records without replacement. Validate sample size, retain unique record IDs, and distinguish repeated names from repeated records.

Read the guide →
Engineering & Science

Sieder-Tate Laminar Tube Nusselt Number With Wall-Viscosity Correction

Calculate the Sieder-Tate developing laminar tube Nusselt number Nu_D = 1.86 * (Re * Pr * (D / L))^(1/3) * (mu_b / mu_w)^0.14 to capture viscous lube-oil heating enhancement vs. cold-wall boundary thickening.

Read the guide →
Engineering & Science

Sieverts' Law: Diatomic Gas Solubility (H2, N2, O2) in Molten Metals & Vacuum Degassing

Calculate dissolved atomic hydrogen or nitrogen concentration [X] = K_S * SQRT(P_X2) in ppm for steelmaking, aluminum foundry degassing, and TIG/MIG welding, plus target vacuum degassing pressure.

Read the guide →
Math

SIGN function: classify variances into +1, 0, or -1 directional flags

Turn any numeric delta into -1, 0, or +1 with SIGN to map status labels via CHOOSE or count net gains vs declines.

Read the guide →
Math & Rounding

Sign-Independent Directed Rounding Toward +Infinity and -Infinity (CEILING.PRECISE & FLOOR.PRECISE)

Round positive and negative numbers strictly toward +infinity or -infinity using ABS(significance) and INT identities that never fail with #NUM! when value and step have opposite signs.

Read the guide →
Operations

Silver-Meal Heuristic: Dynamic MRP Lot-Sizing Cost Per Period

Choose the next production lot with the Silver–Meal first-increase rule, compare unrounded average costs, and calculate its quantity in a four-period worksheet.

Read the guide →
Healthcare & Clinical

Silverman–Andersen Score: Five Respiratory Observations in a Spreadsheet

Practice adding five pre-assessed newborn respiratory observation grades and understand the limitations of interpreting the total.

Read the guide →
Biostatistics & Oncology Trials

Simon Two-Stage Phase II Futility Stopping and Expected Sample Size

Evaluate Simon’s (1989) Optimal vs Minimax single-arm Phase II designs via Stage-1 early futility probability PET(p_0) and expected sample size EN(p_0) = n_1 + (1 - PET(p_0)) * n_2.

Read the guide →
Financial

Simple interest formula: I = P * r * t for days, months, and years

Calculate non-compounding interest and maturity payoff on promissory notes under Actual/365 and commercial Actual/360 conventions.

Read the guide →
Statistical & Clinical Analysis

Simplified Fencl–Stewart Base Excess: Components and Limits

Calculate the sodium–chloride and albumin effects in the simplified Story model and explore the remaining base-excess residual without treating it as a diagnosis.

Read the guide →
Healthcare & Clinical Calculations

Simplified PESI Research: Adding Six Binary Flags

Learn the six published sPESI factor weights through fictional inputs and complete-data checks.

Read the guide →
Engineering

Simply supported beam deflection (5wL^4/384EI), bending moment & L/360 check

Explore ideal simply supported beam deflection and bending moment, with an illustrative span/360 comparison rather than a structural approval.

Read the guide →
Statistical

Simpson's Diversity Index (1 - D) & Lincoln-Petersen Mark-Recapture formulas

Calculate finite-sample diversity and a Chapman capture–recapture estimate under explicit sampling assumptions.

Read the guide →
Math

SIN function: calculate vertical rise from sloped length and angle

Convert degree angles with RADIANS before calling SIN to compute ramp elevation gain and wave amplitudes.

Read the guide →
Polymer Processing, Plastics Extrusion & Rheology Engineering

Single-Screw Extruder Drag Flow & Die Operating Point Formula

Calculate Open-Discharge Drag Flow Q_d (L/hr), Coupled Screw-Die Operating Throughput Q_op (L/hr), Back-Pressure Throttle Loss (%), and Die Head Melt Pressure Delta_P (MPa).

Read the guide →
Financial

Sinking Fund Payment (PMT) & Growing Perpetuity Valuation CF1 / (r - g) formulas

Calculate periodic sinking-fund savings needed to retire a future bond/capex obligation via PMT(r, n, 0, -FV) and value infinite cash flows via CF1 / (r - g).

Read the guide →
Powder Metallurgy, Metal Injection Molding (MIM) & Technical Ceramics, Sintering Shrinkage

Sintering Linear Shrinkage & Die Tooling Oversize Formula

Calculate Volumetric Sintering Shrinkage (%), Isotropic Linear Shrinkage 1 - (rho_g/rho_s)^(1/3) (%), Tooling Oversize Scale Factor, and Green Die Cavity Dimension (mm).

Read the guide →
Operations, Logistics & Engineering

Sips (Langmuir-Freundlich) & Redlich-Peterson 3-Parameter Adsorption Isotherm Formula

Bridge heterogeneous Freundlich low-concentration behavior and finite Langmuir monolayer saturation using Robert Sips’s (1948) isotherm q_e = q_max*(K_S*C_e)^n / (1 + (K_S*C_e)^n) and the Redlich-Peterson (1959) hybrid equation.

Read the guide →
Epidemiology & Biostatistics

SIR Herd Immunity Threshold & Vaccine Efficacy Formula

Calculate the Kermack-McKendrick Herd Immunity Threshold 1 - 1/R_0, Effective Reproduction Number R_eff = R_0*(1 - v*VE), and critical coverage v_crit = (1 - 1/R_0)/VE.

Read the guide →
Clinical Medicine & Physiology

Siri and Brožek Body Density Equations: Comparing Body-Fat Estimates

Compare Siri and Brožek estimates of body-fat percentage from body density, and calculate an illustrative fat-free mass while keeping model assumptions and measurement limitations clear.

Read the guide →
Healthcare & Clinical

SIRS Criteria: A Historical Four-Part Spreadsheet Example

Count the four historical SIRS criteria in a complete example and understand why the result alone cannot diagnose or exclude sepsis.

Read the guide →
Statistical

Six Sigma DPMO and Rolled Throughput Yield (RTY) formulas

Calculate Defects Per Million Opportunities (DPMO) across multi-checkpoint units and chain step-by-step First Pass Yields with PRODUCT.

Read the guide →
Healthcare & Clinical Formulas

Six-Item Cognitive Screener: Understanding Study Results and Sensitivity

Read the original Six-Item Screener study in context and practice a separate sensitivity calculation without treating a screening result as a diagnosis.

Read the guide →
Sports Analytics & Quantitative Modeling

Skellam Goal Difference & Dixon-Coles Tau Formula

Calculate Skellam Poisson Goal-Difference Mean (lambda_H - lambda_A) and Variance (lambda_H + lambda_A), plus Dixon & Coles (1997) low-scoring correlation adjustment for 0-0 and 1-1 soccer draws.

Read the guide →
Engineering & Fluid Mechanics

Skempton’s Pore-Pressure Parameters B & A Formula: Undrained Triaxial Soil Saturation & Shear

Verify triaxial specimen saturation (B >= 0.95) and diagnose contractive vs. dilative undrained shear behavior using Alec W. Skempton’s 1954 equation delta_u = B * [delta_sigma3 + A * (delta_sigma1 - delta_sigma3)].

Read the guide →
Healthcare & Clinical Calculators

SLEDAI-2K: Disease Activity Index and Weighted-Sum Example

Learn why SLEDAI-2K requires all 24 descriptors and practice a separate six-row weighted sum without treating it as a lupus assessment.

Read the guide →
Financial

SLN function: calculate annual straight-line depreciation after salvage value

Spread fixed-asset cost minus salvage value evenly across useful life periods with SLN.

Read the guide →
Equity Valuation & Forensic Accounting

Sloan Accrual Anomaly & Cash-ROA Persistence Formula

Decompose Return on Assets into Cash-Flow ROA (CFO / Avg_Assets) and Operating Accrual Ratio ((NI - CFO) / Avg_Assets) to forecast next-year ROA under Richard Sloan’s (1996) differential persistence model.

Read the guide →
Statistical

SLOPE function: estimate variable cost per unit or trend rate of change

Calculate ordinary least-squares linear slope (change in Y per unit of X) using SLOPE—without reversing the Y and X arguments.

Read the guide →
Charts & Visual Data

Slopegraph & Bump Chart Formula: Tie-Safe Ordinal Rank & Rank-Jump Delta

Stage multi-period Bump Charts and Tufte Slopegraphs by computing tie-broken descending ranks RANK + COUNTIF_prior - 1 and signed rank-climb deltas Rank_Prior - Rank_Current.

Read the guide →
Biosolids Management, Decanter Centrifuges & Mass Balance

Sludge Centrifuge Solids Capture % & Cake Tonnage Formula

Calculate Decanter Centrifuge / Belt Press Solids Capture Recovery (%) from Lab %TS Samples, Daily Dry Solids Captured (t/d), Hauled Wet Cake Tonnage (t/d), and Volume Reduction (%).

Read the guide →
Wastewater Process Control, Activated Sludge & Secondary Clarification

Sludge Volume Index (SVI) & Return-Sludge RAS Ratio Formula

Calculate Mohlman Sludge Volume Index SVI (mL/g), Theoretical Maximum Return-Sludge Concentration X_R (mg/L), Minimum RAS Recycle Ratio Q_r/Q, and Filamentous Bulking Status.

Read the guide →
Healthcare & Clinical

SMART-COP Pneumonia Research: Weighted Score Example

Understand the eight weighted components in the published SMART-COP pneumonia study and practice a checked spreadsheet sum using hypothetical flags.

Read the guide →
Operations & Logistics

SMED Setup Reduction Formula: Internal-to-External Changeover & Lot Shrinking

Quantify Shigeo Shingo’s Single-Minute Exchange of Die (SMED) conversion—separating external setup from stopped-machine internal downtime to shrink economic lot sizes by SQRT(T_new / T_old) or unlock shift availability.

Read the guide →
Chemical, Process & Catalysis Engineering

Smith (1969) Annular-Mist Slip Ratio & Void Fraction Formula: Entrained Liquid e_k = 0.40

Calculate steam-water and refrigerant boiling cross-sectional void fraction alpha using S. L. Smith’s (1969) Momentum-Equalized Annular-Mist Slip Ratio S_Smith with entrained droplet fraction e_k = 0.40.

Read the guide →
Fatigue Durability & Mechanical Reliability

Smith-Watson-Topper (SWT) & Morrow Fatigue Formula

Calculate Peak Cyclic Stress sigma_max = sigma_a + sigma_m, Smith-Watson-Topper Damage Stress SQRT(MAX(0, sigma_max) * epsilon_a * E), Morrow Mean-Stress Equivalent Amplitude, and Crack-Closure Regime.

Read the guide →
SMT Electronics Assembly, SAC305 Lead-Free Reflow Profiling & IPC/JEDEC J-STD-020

SMT Reflow Oven Belt Speed, Ramp Slope & TAL Formula

Calculate Preheat Zone Residence Time (s), Preheat Thermal Ramp Slope (°C/s <= 3.0 °C/s limit), Peak Zone Time Above 217 °C SAC305 Liquidus TAL (s), and J-STD-020 Profile Audit.

Read the guide →
SMT Electronics Assembly, IPC-7525 Solder-Paste Stencil Design & Reflow Yield

SMT Stencil Aperture Area Ratio & Paste Volume Formula

Calculate IPC-7525 Aperture Area Ratio AR = (L*W)/(2*(L+W)*T), Width-to-Foil Aspect Ratio W/T, Wet Solder-Paste Brick Volume (nL), and >= 0.66 Paste-Release Gate.

Read the guide →
Healthcare & Clinical Calculators

SNAPPE-II: Neonatal Severity-Score Components and Research Limits

Add nine pre-assessed SNAPPE-II point values using explicit allowed categories, and understand the limits of interpreting a group-based neonatal score.

Read the guide →
Clinical Medicine & Physiology

SNAQ Appetite Score: A Four-Item Spreadsheet Example

Add four assessed appetite questionnaire scores and see why screening thresholds and study results need context.

Read the guide →
Engineering & Scientific

Snell’s Law Refraction Angle & Total Internal Reflection (TIR) Critical Angle

Calculate optical refraction angle theta_2 and Total Internal Reflection critical angle theta_c = DEGREES(ASIN(n_2 / n_1)) across planar dielectric interfaces with radian-degree conversion and ASIN domain guards.

Read the guide →
Engineering

Snell's Law refraction angle & Total Internal Reflection critical angle

Calculate refracted ray angles DEGREES(ASIN((n1/n2)*SIN(RADIANS(theta1)))) and fiber-optic Total Internal Reflection critical angles safely in degrees.

Read the guide →
Engineering & Science

Soave-Redlich-Kwong (SRK) Equation of State: Alpha Cohesion & Pressure

Calculate Giorgio Soave’s acentric cohesion function α(T_r, ω) = [1 + (0.480 + 1.574ω - 0.176ω^2)(1 - SQRT(T / T_c))]^2 and real-gas SRK pressure P (bar) for hydrocarbon and natural-gas processing.

Read the guide →