Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Engineering

Swamee-Jain Explicit Pipe Friction Factor formula (Moody Chart)

Estimate a Darcy pipe-friction factor with explicit Swamee–Jain arithmetic in a declared turbulent range, use 64/Re for laminar flow, and leave the transition region unresolved.

Read the guide →
Engineering & Science

Sweet-Parker Magnetic Reconnection Rate, Lundquist Number (S) & Sheet Thickness

Calculate the dimensionless MHD Lundquist number S = (L * vA) / eta_m, Sweet-Parker reconnection inflow speed v_in = vA / SQRT(S), and resistive current-sheet half-thickness delta = L / SQRT(S).

Read the guide →
Text

Switch "Last, First" names to "First Last" (and back)

Flip HR and payroll comma-formatted names ("Rivera, Elena M.") into natural "Elena M. Rivera" order while leaving non-comma names untouched.

Read the guide →
Lookup & Reference

Switch Financial Scenarios (Bear, Base, Bull) with CHOOSECOLS & INDEX

Switch among three named cash-flow scenarios, select a full column with CHOOSECOLS, and expose each year with INDEX while validating the selector and selected data.

Read the guide →
Logical checks and errors

SWITCH function: map exact status codes to readable labels

Evaluate a cell once against a list of exact code-to-label pairs, include a final default fallback for unexpected codes, and know when to use IFS instead.

Read the guide →
Lookup & Reference

Switch Lookup Tables Dynamically with CHOOSE & INDEX / MATCH

Route a two-way INDEX/MATCH lookup across Retail, Wholesale, or Enterprise rate tables dynamically based on a selected tier code using CHOOSE.

Read the guide →
High-Speed Multilayer PCB Stackup, IPC-2141 Symmetric Stripline & Signal Integrity

Symmetric Stripline PCB Impedance Z0 & Delay Formula

Calculate Single-Side Dielectric Height h = (b - t)/2 (mm), IPC-2141 Symmetric Stripline Characteristic Impedance Z0 (ohms), Pure TEM Propagation Delay (ps/mm), and Line Capacitance (pF/cm).

Read the guide →
Power Electronics & Voltage Regulator Design

Synchronous Buck Converter Ripple & CCM Formula

Calculate Step-Down Buck Converter Duty Cycle D = V_out / V_in, Peak-to-Peak Inductor Current Ripple (V_in - V_out)*D / (f_MHz * L_uH), Peak Switch Current, and Critical CCM Inductance.

Read the guide →
Engineering & Science

Synchrotron Radiation: Critical X-Ray Photon Energy & Energy Loss per Turn

Calculate bending-magnet synchrotron critical photon energy E_crit = 0.665 * E_GeV^2 * B_Tesla (in keV) and relativistic electron radiative energy loss per storage-ring revolution U0 = 88.46 * E_GeV^4 / rho_m (in keV/turn).

Read the guide →
Healthcare & Clinical Calculators

SYNTAX Score: Coronary Anatomy, Complexity and Spreadsheet Sums

Understand what the anatomical SYNTAX score describes, why treatment decisions need more than a sum, and practice adding four fictional values with input checks.

Read the guide →
Healthcare & Clinical

Systemic and Pulmonary Vascular Resistance: Pressure, Flow and Units

Explore pressure-gradient-to-flow calculations in Wood units and dyn·s·cm⁻⁵, with complete input checks and context about their clinical limitations.

Read the guide →
Quality & Six Sigma SPC

Tabular CUSUM Control Chart Formula: C+ / C- Cumulative Sum & h-Sigma Shift Alarm

Detect sustained 0.5-sigma to 1.5-sigma process drifts 3x–4x faster than Shewhart 3-sigma charts using Page’s Two-Sided Tabular CUSUM recursion C_i+ = MAX(0, x_i - (mu_0 + k*sigma) + Ci-1+).

Read the guide →
Quality Engineering & Lean Manufacturing

Taguchi Quadratic Quality Loss Function Formula

Replace binary goalpost tolerance thinking with Genichi Taguchi’s quadratic loss L(y) = (A_0 / Delta_0^2)*(y - m)^2 and expected batch loss k * (sigma^2 + (mu - m)^2).

Read the guide →
Distributed Systems & Performance Engineering

Tail-at-Scale Fan-Out Latency & Hedged Request Formula

Calculate Jeffrey Dean & Luiz André Barroso’s (2013) microservice fan-out tail probability 1 - (1 - p)^K and prove how r-way hedged requests collapse p99 amplification to 1 - (1 - p^r)^K.

Read the guide →
Queueing Theory, Computer Systems Latency & Operations Research

Takagi M/G/1 Server-Vacation Queue Waiting-Time Formula

Calculate Server Utilization rho = lambda*E[S], Pollaczek-Khinchine Non-Vacation M/G/1 Waiting Time W_q0, Mean Residual Vacation Life E[V]*(1 + CV_V^2)/2, and Takagi / Fuhrmann-Cooper Decomposed Queue Delay.

Read the guide →
Dynamic arrays

TAKE function: slice the first N or last N rows from a table

Keep a contiguous block of rows or columns from the start or end of a range—or pair TAKE with SORT for clean Top-N summaries.

Read the guide →
Healthcare & Clinical Calculators

Talcott Febrile Neutropenia Groups: A Historical Classification Example

Study the hierarchy behind Talcott’s four historical groups and practice complete binary inputs, without using a spreadsheet result to decide outpatient treatment.

Read the guide →
Mechanical Engineering & Tribology

Tallian Specific Film Thickness Lambda and Stribeck Regime Formula

Calculate composite RMS surface roughness SQRT(Rq_1^2 + Rq_2^2), Tallian’s specific oil-film ratio Lambda, and Stribeck lubrication regime (Boundary, Mixed, or Full Film).

Read the guide →
Math

TAN function: calculate mast or roof height from horizontal run and angle

Multiply horizontal ground distance by TAN(RADIANS(angle)) to find vertical height, and guard 90-degree vertical asymptotes.

Read the guide →
Bioprocess Engineering & Downstream Purification

Tangential-Flow Diafiltration Diavolume Formula

Calculate Constant-Volume Diafiltration Residual Impurity C_end = C_0 * EXP(-N_dv * S), Required Diavolumes LN(C_0 / C_target) / S with Non-Ideal Sieving S, Buffer Volume, and Spec Gate.

Read the guide →
Biostatistics & Survival Analysis

Tarone-Ware and Gehan-Breslow Weighted Log-Rank Survival Formula

Compare standard Mantel-Haenszel (w=1), Tarone-Ware (w=SQRT(n_j)), and Gehan-Breslow (w=n_j) weighted log-rank Z statistics across discrete failure risk sets.

Read the guide →
Statistical & Clinical Analysis

Tarone’s Homogeneity Test Correction: Exact Asymptotic χ² Adjustment to Breslow-Day

Correct the conservative inefficiency of the Mantel-Haenszel Breslow-Day test using Robert Tarone’s (1985) score adjustment χ²_Tarone = χ²_BD - [Σ(a_k - E_k)]² / ΣVar_k.

Read the guide →
Engineering & Science

Tauc Plot Optical Bandgap Calculator: Photon Energy & (alpha*h*nu)^n

Transform UV-Vis spectrophotometer wavelength (nm) and absorption coefficient alpha (cm^-1) into Tauc abscissa h*nu = 1239.842 / lambda_nm (eV) and direct ((alpha * h*nu)^2) vs. indirect (SQRT(alpha * h*nu)) ordinates.

Read the guide →
Portfolio Management, Tax-Loss Harvesting & IRC Section 1091

Tax-Loss Harvesting & IRC §1091 Partial Wash-Sale Formula

Calculate Realized Harvested Capital Loss ($), IRC Section 1091 Share-Matched Disallowed Wash-Sale Loss ($), Deductible Current-Year Loss ($), and Adjusted Replacement Lot Basis ($/sh).

Read the guide →
Financial

Taylor Rule formula: central bank policy interest rate & ZLB floor

Explore a Taylor-style policy-rule benchmark with supplied neutral rate, inflation target and output gap, plus an optional zero-floor scenario.

Read the guide →
CNC Machining & Manufacturing Process Engineering

Taylor Tool Life & Minimum-Cost Cutting Speed Formula

Calculate F.W. Taylor’s Cutting Tool Life T = (C / V)^(1/n), Gilbert’s Minimum-Cost Economic Tool Life T_opt = ((1 - n)/n) * (t_chg + C_edge / R_mach), and Optimal Cutting Speed V_opt.

Read the guide →
CNC Machining Economics & Carbide Tool Wear, F.W. Taylor (1906) & Gilbert Minimum-Cost Speed

Taylor Tool-Life & Gilbert Minimum-Cost Cutting Speed

Calculate Predicted Carbide Insert Edge Life T (min), Gilbert Economic Minimum-Cost Tool Life Topt (min), Optimum Minimum-Cost Cutting Speed Vopt (m/min), and Overspeed Penalty (%).

Read the guide →
Engineering & Science

Taylor-Couette Rotating Annulus: Taylor Number & Toroidal Vortex Onset

Calculate the root Taylor Number Ta_1/2 = ((Omega * R_i * d) / nu) * SQRT(d / R_i) for concentric journal bearings and chemical Taylor-vortex reactors against G. I. Taylor’s 1923 critical instability threshold (Ta_1/2 >= 41.3).

Read the guide →
Agency MBS Trading & Repo Financing

TBA Mortgage Dollar Roll Drop & Specialness Formula

Calculate Agency TBA Dollar Roll Price Drop (P_front - P_back), Breakeven Carry Drop, Net Roll Advantage Points, and Implied Dollar-Roll Financing Rate ("Trading Special").

Read the guide →
Engineering

TCP Bandwidth-Delay Product (BDP) & Mathis Throughput Formula

Calculate bandwidth-delay product in decimal MB and explore a simplified Reno-style loss model, with explicit units and limits rather than a universal TCP speed prediction.

Read the guide →
Engineering

Telescope Rayleigh Diffraction Limit, Dawes' Limit & Focal Ratio formulas

Calculate Airy-disk angular resolution in arcseconds theta = DEGREES(1.22 * lambda / D) * 3600, Dawes' empirical double-star limit 116 / D_mm, f-number, and magnification.

Read the guide →
Process Thermal Engineering & Heat Exchangers

TEMA Heat Exchanger Fouling & Dirty U-Value Formula

Calculate Outer-Area-Referenced Total Fouling Resistance R_f_tot = R_f_in * (D_o / D_i) + R_f_out, Service Dirty Overall Conductance U_dirty, Cleanliness Factor, and Surface Overdesign Fraction.

Read the guide →
Engineering & Science

Temkin & Dubinin-Radushkevich (D-R) Adsorption Isotherm Energy Formula

Distinguish physical micropore filling (< 8 kJ/mol) from ion-exchange / chemisorption (8–16+ kJ/mol) using Dubinin-Radushkevich mean free adsorption energy E = 1 / SQRT(2 * B_DR) and Temkin surface uptake q_e = ((R * T) / b_T) * LN(A_T * C_e).

Read the guide →
Geotechnical Engineering, Cofferdam Dewatering, Terzaghi Quicksand & Piping Heave

Terzaghi Critical Hydraulic Gradient & Quicksand Formula

Calculate Terzaghi Critical Hydraulic Gradient i_cr = (Gs - 1)/(1 + e), Cofferdam Upward Exit Gradient dh/L, Piping Factor of Safety FS, and Sand-Boiling Heave Audit.

Read the guide →
Engineering

Terzaghi Effective Soil Stress & Rankine Earth Pressure (Ka & Kp) formulas

Explore a simplified hydrostatic effective-stress calculation and Rankine coefficients for level cohesionless backfill.

Read the guide →
Engineering

Terzaghi Shallow Foundation Bearing Capacity (q_u & Allowable q_all)

Calculate strip and square footing ultimate pressures from supplied bearing-capacity factors, then distinguish net and gross allowable shear pressures with an explicit safety-factor convention.

Read the guide →
Text & Cleaning

Test Whether a Range Contains Any Substring from a Keyword List (COUNTIF)

Check whether any cell across an entire column or log range contains at least one keyword from a watchlist using wildcard COUNTIF checks, returning a clean TRUE/FALSE flag or total keyword hits.

Read the guide →
Logical & Conditional

Test Whether a Range Contains One of Many Exact Values (Set Overlap Audit)

Determine whether an entire column or manifest range contains at least one exact code from a restricted or priority list using whole-cell equality or COUNTIF checks without partial-prefix false positives.

Read the guide →
Dates & Schedules

Test Whether a Schedule Range Contains a Specific Date (Date & Timestamp Safe)

Check whether a target calendar date appears inside a holiday or blackout range using COUNTIFS whole-day bounds so fractional timestamps never cause missed matches.

Read the guide →
Cleaning imported data

TEXTBEFORE and TEXTAFTER: extract variable-length text around delimiters

Pull city prefixes and trailing status tags from hyphenated codes of any length without nesting FIND inside LEFT or RIGHT, and handle rows missing a delimiter.

Read the guide →
Apparel Sourcing, Textile Engineering & Commodity Trade

Textile Yarn Tex, Denier, Ne & Moisture Regain Formula

Convert Direct Linear Density Tex (g/1,000 m) into Synthetic Filament Denier (9 * Tex) and Indirect English Cotton Count Ne (590.5 / Tex), and calculate ASTM/BISFA Commercial Moisture Regain Invoice Weight.

Read the guide →
Cleaning imported data

TEXTJOIN function: combine optional address fields without double commas

Join street, optional unit, and city with a comma-space delimiter while automatically skipping genuinely blank cells—and check how zero and space-only cells behave.

Read the guide →
Cleaning imported data

TEXTSPLIT function: split semicolon or comma strings into columns

Break a delimited import string across columns dynamically with TEXTSPLIT, and control whether consecutive delimiters keep blank slots or collapse.

Read the guide →
Healthcare & Clinical

The CHALICE Head-Injury Study and Spreadsheet Age Boundaries

Explore comparisons at age boundaries with invented values and learn where to find the original CHALICE study and current guidance.

Read the guide →
Healthcare & Clinical Calculators

The Logistic Link in EuroSCORE II: An Educational Example

Explore a logistic transformation using invented values; this worksheet is not a cardiac-surgery risk calculator.

Read the guide →
Healthcare & Clinical

The PECARN Study and Binary Data: A Spreadsheet Exercise

Learn to validate and count fictional binary flags while reading about the PECARN head-injury research.

Read the guide →
Film Finance & Entertainment Distribution

Theatrical Box-Office 90/10 Split & P&A Formula

Calculate Distributor Theatrical Film Rentals MAX(Floor_Pct * GBO, 0.90 * MAX(0, GBO - House_Nut)), Effective Cinema Exhibitor Retention, Post-Fee Studio Receipts, and Net Producer P&A Recoupment.

Read the guide →
Forecasting & Demand Planning

Theil MSE Bias-Variance-Covariance and Mincer-Zarnowitz Formula

Decompose Mean Squared Forecast Error into exact additive Bias Share U_M, Variance Share U_S, and Unsystematic Covariance Share U_C = 1 - U_M - U_S alongside Mincer-Zarnowitz slope beta_MZ.

Read the guide →
Financial & Economic Analysis

Theil T & Theil L (Mean Log Deviation) Entropy Inequality Indices

Quantify revenue, wage, or regional resource concentration using Theil’s GE(1) T index, GE(0) Mean Log Deviation L, and normalized [0, 1] Shannon inequality share.

Read the guide →
Economics & Market Microstructure

Theil T Index GE(1) & Theil L Mean Log Deviation GE(0) Income Inequality Formula

Calculate Henri Theil’s (1967) information-theoretic inequality measures — income-weighted Theil T = (1 / N) * SUM((y_i / mu) * LN(y_i / mu)) and population-weighted Mean Log Deviation Theil L = (1 / N) * SUM(LN(mu / y_i)).

Read the guide →