Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Healthcare & Clinical Formulas

Scatchard Plot: A Synthetic Binding-Equation Example

Learn the slope and intercept relationship of a single-site Scatchard transformation with synthetic data, and understand why actual binding data are normally fit by nonlinear regression.

Read the guide →
Engineering & Science

Scheibel Liquid Diffusivity Correlation (Organic Solute–Solvent Molar Volume)

Estimate dilute organic liquid molecular diffusivity D_AB = 0.0082 * T * (1 + (3 * V_B / V_A)^(2/3)) / (μ_B * V_A^(1/3)) (× 10^-5 cm^2/s) without empirical association factors.

Read the guide →
Engineering & Science

Scheil-Gulliver Solidification Equation: Dendrite Coring & Non-Equilibrium Eutectic Fraction

Calculate local solid composition C_S = k * C0 * (1 - f_S)^(k - 1) during casting solidification and predict non-equilibrium interdendritic eutectic fraction f_E = (C_E / C0)^(-1 / (1 - k)).

Read the guide →
Receptor Pharmacology & Bioassay

Schild Dose Ratio and Apparent Antagonist Affinity

Practice the dose ratio, Schild ordinate and a single-shift apparent affinity estimate, with the assumptions and limitations of competitive antagonism.

Read the guide →
Operations, Logistics & Engineering

Schmertmann Strain Influence Factor (I_z) Formula: Sand Footing Immediate & Creep Settlement

Calculate shallow foundation settlement on granular sand soils using John H. Schmertmann’s (1970/1978) strain-influence method S = C_1 * C_2 * delta_q * SUM(I_z * dz / E_s) with embedment relief C_1 and creep factor C_2.

Read the guide →
Statistical & Clinical Analysis

Schoenfeld Formula: Log-Rank / Cox Survival Trial Required Events & Sample Size

Power Phase III oncology and cardiovascular time-to-event trials using David A. Schoenfeld’s 1983 asymptotic Cox/log-rank formula E = ROUNDUP((z_alpha/2 + z_beta)² / (p * (1 - p) * (LN(HR))²), 0) and total enrollment N = ROUNDUP(E / P_event, 0).

Read the guide →
Clinical Medicine & Physiology

Schofield pediatric basal metabolic equations: a weight-based example

Explore the historical weight-based Schofield equations for children, with age bands, units and limitations.

Read the guide →
Financial Modeling

Schwager Gain-to-Pain Ratio (GPR) & 90/10 Tail Ratio Asymmetry Formula

Evaluate CTA and hedge-fund return asymmetry without upside volatility punishment using Jack Schwager’s Gain-to-Pain Ratio SUM(r) / ABS(SUMIF(r, "<0")) and right-to-left Tail Ratio.

Read the guide →
Engineering

Schwarzschild Black Hole Radius, Gravitational Time Dilation & Hawking Temp

Calculate the Schwarzschild event horizon radius R_s = 2*G*M / c^2, general-relativistic gravitational time dilation 1 / SQRT(1 - R_s / r), and Hawking radiation temperature.

Read the guide →
Clinical Medicine & Physiology

SCOFF Screening: Context and a Binary-Counting Example

Learn what the five-item SCOFF screen measures, how to interpret its evidence carefully, and how to count complete binary responses in a separate spreadsheet exercise.

Read the guide →
Healthcare & Clinical Formulas

SCORAD and Objective SCORAD: Components and Examples

Calculate the total and objective atopic dermatitis scores from complete example components and understand their limitations.

Read the guide →
Math & Trig

Score quiz or exam answers automatically against an answer key

Compare student response rows against a locked answer-key row inside SUMPRODUCT for both equal-point and weighted-question exams.

Read the guide →
Psychometrics & Inter-Rater Reliability

Scott’s Pi Pooled-Marginal Agreement Formula vs Cohen’s Kappa Bias

Expose systematic rater threshold bias by comparing Scott’s (1955) pooled-marginal pi against Cohen’s (1960) separate-marginal kappa on 2x2 annotation tables.

Read the guide →
Text

Screen email addresses for common structural problems

Use five spreadsheet checks to flag obvious email-entry mistakes. This heuristic does not establish complete syntax validity, mailbox existence, or deliverability.

Read the guide →
Bulk Solids Processing, CEMA Screw/Auger Conveyors, Grain & Cement Silo Feeding

Screw Conveyor Flight Pitch & Trough Loading Capacity Formula

Calculate Net Annular Flight Area (m²), Inclined Volumetric Throughput Q_v (m³/h), Horizontal Zero-Incline Mass Rate (t/h), and Derated Inclined Mass Capacity Q_m (t/h).

Read the guide →
Lookup & Reference

Search a 2D Table Grid for a Value & Return Its Exact Cell Address

Find a nonblank text bin ID in a rectangular grid and return its worksheet address and aisle label, preserving empty grid positions and choosing the first row-by-row match.

Read the guide →
Water Desalination Engineering, Membrane Separations & Energy Recovery Devices

Seawater Reverse Osmosis (SWRO) Osmotic & ERD Energy Formula

Calculate Seawater Reverse Osmosis (SWRO) Concentrate Brine Osmotic Pressure Barrier (bar), Exit Net Driving Pressure (bar), Unrecovered Pump Specific Energy Consumption (kWh/m³), and Isobaric Pressure-Exchanger ERD Specific Energy Consumption SEC (kWh/m³).

Read the guide →
Solid Mechanics & Structural Design

Secant Formula for Eccentrically Loaded Column Stress

Compute nonlinear P-Delta maximum compressive stress sigma_max = (P/A) * (1 + (e*c/r^2) / COS((L_eff/(2*r)) * SQRT(P/(E*A)))) and guard against Euler buckling.

Read the guide →
Date & Time

SECOND function: extract seconds (0-59) and compute total duration in seconds

Pull the 0-59 seconds component from spreadsheet time serials with SECOND, and combine HOUR, MINUTE, and SECOND for total elapsed seconds.

Read the guide →
Civil, Structural & Geotechnical Engineering

Seed-Idriss Soil Liquefaction Formula: Cyclic Stress Ratio CSR & Factor of Safety

Evaluate earthquake-induced sand liquefaction using H. Bolton Seed and I. M. Idriss’s (1971 / NCEER) Simplified Procedure: compute depth stress-reduction r_d, Cyclic Stress Ratio CSR, and Liquefaction Factor of Safety FS_liq = (CRR_7.5 * MSF) / CSR.

Read the guide →
Lookup & Reference

Select columns with a header-driven horizontal FILTER mask

Build a smaller output view using literal header comparisons and a horizontal keep mask; source columns remain in the workbook.

Read the guide →
Warehouse Structural Racking, ANSI/RMI MH16.1 Beam Deflection & Material Storage

Selective Pallet-Rack Beam Deflection (L/180) Formula

Calculate Uniform Load Per Front/Rear Step Beam (kN), Midspan Elastic Beam Deflection delta (mm), ANSI/RMI MH16.1 L/180 Serviceability Limit (mm), and Deflection Utilization (%).

Read the guide →
Lookup & Reference

Self-Contained Inline Lookup Mapping with SWITCH & CHOOSE

Map plan codes, regions, or 1..N priority integers directly to discount rates and labels inside a single self-contained SWITCH or CHOOSE formula without maintaining an external helper table.

Read the guide →
Real Estate Operations, Self-Storage REITs & Revenue Management

Self-Storage Economic Occupancy & ECRI Rent-Roll Formula

Calculate Self-Storage REIT Move-In Concession & Bad-Debt Drag ($k), Existing Customer Rate Increase (ECRI) Lift ($k), Net Collected Rental Revenue ($k), and Economic Occupancy (%).

Read the guide →
Engineering & Science

Sellmeier Refractive Index Dispersion Equation & Abbe Number (Vd) for Optical Glass

Calculate wavelength-dependent refractive index n(lambda) via the 3-term Schott Sellmeier equation SQRT(1 + SUM((Bi * lambda^2) / (lambda^2 - Ci))) and chromatic Abbe number Vd = (nd - 1) / (nF - nC).

Read the guide →
Heavy-Duty Vehicle Suspension, Semi-Elliptic Multi-Leaf Springs & Stiffness

Semi-Elliptic Multi-Leaf Spring Stress & Deflection Formula

Calculate Total Leaf Count n = nf + ng, Uniform-Strength Leaf Bending Stress (MPa), Central Camber Deflection (mm), and Suspension Spring Rate k (N/mm).

Read the guide →
Semiconductor Manufacturing & Fab Economics

Semiconductor Wafer DPW, Poisson & Murphy Yield Formula

Calculate Edge-Corrected Gross Dies per Wafer (DPW), Poisson Random-Defect Yield EXP(-D_0*A), Bernard Murphy’s Triangular Yield ((1 - EXP(-D_0*A))/(D_0*A))^2, Seeds Yield 1/(1 + D_0*A), and Cost per Good Die.

Read the guide →
Engineering

Sensible heat Q = mcΔT: convert kJ to kWh and estimate ideal heating time

Calculate thermal energy Q = m * Cp * (T_out - T_in) in kilojoules, convert to kWh (/ 3600), and solve heating recovery time at Heater kW.

Read the guide →
Financial

Sensitivity analysis table with formulas: mixed references ($A3 and B$1)

Build live 1-variable and 2-variable financial sensitivity grids (e.g., Interest Rate x Loan Term) with mixed $ references that recalculate instantly anywhere.

Read the guide →
Dynamic arrays

SEQUENCE function: generate dynamic row numbers and weekly date lists

Spill consecutive ticket numbers or 7-day inspection schedules from a single cell without dragging fill handles down the sheet.

Read the guide →
Date & Time

Sequence of workdays and month-end dates (holiday-aware schedule)

Generate consecutive business days skipping weekends and holidays with WORKDAY(Start - 1, Step, Holidays) alongside rolling month-end closes.

Read the guide →
Engineering

Series vs Parallel System Reliability & active redundancy formula (PRODUCT)

Compare series and active-parallel mission reliability under independent failures and a common mission horizon.

Read the guide →
Logical

Shade alternating groups of N rows (ISEVEN, QUOTIENT & ROW)

Calculate alternating fixed-height row-band flags and block numbers, with a positive integer band height.

Read the guide →
Engineering

Shaft Torsional Shear Stress (16T / pi*d^3) & Twist Angle (TL / GJ) formulas

Calculate elastic stress magnitude and signed twist for an ideal uniform solid circular shaft under pure torsion.

Read the guide →
Engineering & Science

Shah In-Tube Two-Phase Condensation Heat-Transfer Correlation Formula

Calculate local annular/shear-driven condenser tube heat-transfer coefficient h_TP = h_L * ((1 - x)^0.8 + (3.8 * x^0.76 * (1 - x)^0.04) / p_r^0.38) across refrigerants and steam.

Read the guide →
Engineering

Shannon-Hartley channel capacity (Mbps) & RF dBm-to-milliwatt formulas

Calculate theoretical maximum wireless throughput B * LOG(1 + 10^(SNR_dB/10), 2) and convert RF link-budget power between dBm and milliwatts.

Read the guide →
Statistical

Shannon-Wiener Diversity Index (H'), Hill Number EXP(H') & Pielou's Evenness

Calculate ecological species diversity H' = -SUM(p_i * LN(p_i)), effective equal-abundance species EXP(H'), and Pielou's Evenness J' = H' / LN(S).

Read the guide →
Labor Economics & Personnel Economics

Shapiro-Stiglitz No-Shirking Efficiency Wage Formula

Compute the Shapiro-Stiglitz No-Shirking Condition wage w_NSC(u) = b + e + (e/q)*(r + s/u) and solve involuntary equilibrium unemployment u* against MPL.

Read the guide →
Economics & Market Microstructure

Shapley Value Formula (3-Player Cooperative Game): Exact Coalition Marginal Allocation

Compute the fair Shapley Value payoff allocation for a 3-player cooperative game (marketing attribution, joint logistics, or R&D consortium) across all 3! = 6 arrival permutations and verify grand-coalition efficiency.

Read the guide →
Cooperative Game Theory & Governance

Shapley-Shubik Weighted Voting Power Index Formula

Calculate Lloyd Shapley and Martin Shubik’s (1954) exact 6-permutation pivotal voting power index for three shareholder blocks or legislative parties against quota Q.

Read the guide →
Econometrics & Causal Inference

Sharp and Fuzzy Regression Discontinuity (RDD) Local Jump Formula

Estimate local linear Regression Discontinuity cutoff intercepts INTERCEPT(Y, X - c) from both sides of threshold c and compute the Fuzzy RDD jump ratio tau_FRD.

Read the guide →
Financial

Sharpe Ratio formula: periodic and annualized risk-adjusted return

Measure excess return per unit of volatility with (AVERAGE(Returns) - RiskFree) / STDEV.S(Returns) and scale periodic Sharpe by SQRT(PeriodsPerYear).

Read the guide →
Financial

Sharpe ratio standard error, illustrative track-record threshold and serial-correlation scaling

Calculate an IID-normal large-sample Sharpe standard error and compare annual scaling under a stated AR(1) correlation assumption.

Read the guide →
Sheet-Metal CAD/CAM Unfolding, Press-Brake Flat Patterns & Precision Fabrication

Sheet-Metal Bend Allowance, K-Factor & Bend Deduction Formula

Calculate Neutral-Axis Arc Bend Allowance BA (mm), Outside Setback OSSB (mm), Bend Deduction BD = 2*OSSB - BA (mm), and Laser-Cut Flat Blank Length (mm).

Read the guide →
Sheet-Metal Stamping & Press-Brake Forming, Gardiner Elastic-Plastic Springback Law

Sheet-Metal Bending Elastic Springback & Overbend Formula

Calculate Gardiner Springback Factor Ks, Unloaded Inside Bend Radius Rf (mm), Required Press-Brake Overbend Angle (deg), and Elastic Springback Angle Recovery (deg).

Read the guide →
Progressive Stamping Dies, Sheet-Metal Blanking/Piercing & Turret Punching

Sheet-Metal Blanking Shear Force & Die Clearance Formula

Calculate Single-Side Punch-to-Die Radial Clearance c (mm), Flat-Punch Peak Shear Force F_shear (kN), Stripper-Plate Unloading Force F_strip (kN), and Total Stamping Press Force (kN).

Read the guide →
Engineering & Science

Sherwood Number (Sh), Schmidt Number (Sc) & Frössling Sphere Mass Transfer

Calculate the dimensionless Schmidt number Sc = nu / D_AB, Frössling-Ranz-Marshall sphere Sherwood number Sh = 2 + 0.6 * (Re^0.5) * (Sc^(1/3)), and convective mass-transfer coefficient k_c = (Sh * D_AB) / d_p.

Read the guide →
Science

Shields Parameter for Incipient River Sediment Motion & Bed Shear

Calculate river bed shear stress tau_0 = rho * g * R_h * S, dimensionless Shields Stress tau_* = (rho * R_h * S) / ((rho_s - rho) * d_50), and gravel bedload mobilization status.

Read the guide →
Marketing Science & Subscription SaaS Analytics

Shifted-Beta-Geometric (sBG) Cohort Retention Formula

Project contractual subscription survival S(t) = S(t - 1) * (beta + t - 1) / (alpha + beta + t - 1) under unobserved churn heterogeneity and explain rising cohort retention rates.

Read the guide →
Quantitative Forecasting & Prediction Markets

Shin Method vs Multiplicative Vig-Removal Formula

Strip bookmaker overround S = 1/O1 + 1/O2 - 1 via Hyun Song Shin’s (1993) insider-trading equilibrium to correct Favorite-Longshot Bias in implied probabilities.

Read the guide →