Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Thermal Process Engineering, TEMA Shell-and-Tube Exchangers & Temperature Cross

1-2 Shell-and-Tube LMTD Correction Factor (Ft) Formula

Calculate Heat-Capacity Ratio R, Cold-Side Thermal Effectiveness P, Exact Bowman-Mueller-Nagle 1-Shell / 2-Tube-Pass LMTD Correction Factor F_t, and Effective Mean Temperature Difference (°C).

Read the guide →
Math & Statistical

100% Stacked Column & Bar Mix Matrix Formula: Mixed-Reference Period Shares (B$2:B$4)

Normalize multi-quarter revenue or headcount tables into a 100% composition matrix using column-row-locked mixed references ROUND(B2 / SUM(B$2:B$4) * 100, 2) and measure mix shift percentage-point changes.

Read the guide →
Financial

2/10 Net 30 formula: implied annualized cost of skipping trade discounts

Annualize the illustrative cost of foregoing an early-payment discount using simple and compounded conventions.

Read the guide →
Statistical & Clinical Analysis

2012 SLICC Lupus Classification: A Logic Exercise

Explore the two branches of the 2012 SLICC research classification rule using fictional counts and clearly defined flags.

Read the guide →
Healthcare & Clinical Calculators

2019 EULAR/ACR Lupus Criteria: An Educational Addition Example

Add illustrative domain subtotals while learning the limits of the 2019 SLE research classification criteria; the worksheet does not diagnose or classify a patient.

Read the guide →
Health & Fitness

2021 CKD-EPI Creatinine eGFR and GFR Categories in Excel

Practice the adult 2021 race-free creatinine equation, validate units and inputs, and classify the unrounded estimate without treating it as a CKD diagnosis.

Read the guide →
Lookup & Reference

2D Matrix Dynamic Row Sum, Column Sum & Two-Way Lookup (SUMPRODUCT)

Sum an entire dynamically matched row, sum an entire dynamically matched column, or retrieve a two-way matrix intersection across a 2D table using boolean-broadcast SUMPRODUCT.

Read the guide →
Statistical Analysis

2x2 Association Coefficients: Pearson Phi, Yule’s Q & Yule’s Y Colligation

Measure binary 2x2 contingency association on [-1, +1] with Pearson’s Phi coefficient and marginal-prevalence-invariant Yule’s Q and Yule’s Y formulas.

Read the guide →
Lookup & Reference

3D references: sum the same cell across consecutive monthly worksheets

Consolidate identical template cells across tab ranges like Jan:Dec!B5 using 3D worksheet references.

Read the guide →
Math & Trigonometry

3x3 Matrix Determinant and Cramer's Rule Linear System Solver (MDETERM & MINVERSE)

Calculate exact 2x2 and 3x3 matrix determinants, test for singular zero-determinant systems, and solve simultaneous linear equations A*x = b via cofactor expansion.

Read the guide →
Healthcare & Clinical Calculations

4Ts Score: An Educational Four-Domain Point Sum

Add four illustrative 4Ts domain values while learning the limits of a numerical score; the worksheet does not diagnose HIT or direct treatment.

Read the guide →
Finance

5-Factor DuPont ROE: Tax Burden, Interest Burden & EBIT Margin

Decompose ROE into five accounting ratios, reconcile their unrounded product to net income over average equity, and distinguish undefined factors from a still-defined direct ROE.

Read the guide →
Lookup & Reference

5x5 risk matrix formula: score Likelihood x Impact and assign severity

Convert qualitative Likelihood and Impact ratings into 1–5 scores with XMATCH, compute the 1–25 risk score, and classify Low/Medium/High/Critical.

Read the guide →
Lookup & Reference

5x5 Risk Score Buckets & Step-Based Tier Lookup (Sorted INDEX & MATCH)

Compute Likelihood x Impact risk scores (1–25) and map them into editable Low / Moderate / High / Critical governance tiers using sorted step-threshold lookup.

Read the guide →
Clinical Medicine & Physiology

A Body Shape Index (ABSI): Spreadsheet Formula and Reference Scores

Calculate the ABSI waist–BMI–height index and illustrate standardization using explicitly hypothetical reference values.

Read the guide →
Statistical

A/B test conversion lift and statistical significance (two-proportion Z-score)

Calculate relative conversion lift, pooled standard error, and two-proportion Z-score to test 95% statistical significance.

Read the guide →
Biostatistics & Survival Analysis

Aalen-Johansen Competing-Risks Cumulative Incidence vs Naive 1 - KM

Calculate cause-specific Cumulative Incidence CIF_1(t) = SUM(S_all(tj-1) * d1j / n_j) and prove why censoring competing deaths inflates naive 1 - KM above 100% total risk.

Read the guide →
Public Economics & Actuarial Pensions

Aaron-Samuelson PAYGO vs Funded Pension Formula

Compare Pay-As-You-Go social security’s Samuelson biological rate of return g_bio = (1 + n)*(1 + g_w) - 1 against funded capital return r and compute equilibrium replacement rates.

Read the guide →
Civil, Structural & Geotechnical Engineering

AASHTO 1993 Flexible Pavement Structural Number (SN) Formula: Layer & Drainage Design

Calculate composite asphalt highway Structural Number SN = a_1*D_1 + a_2*D_2*m_2 + a_3*D_3*m_3 and minimum required layer thicknesses using the AASHTO (1993) Guide for Design of Pavement Structures.

Read the guide →
Civil & Transportation Engineering, Highway Geometric Design (AASHTO)

AASHTO Curve Superelevation Radius & Stopping Sight Distance

Calculate AASHTO Green Book Minimum Horizontal Curve Radius V^2 / (127*(e + fs)), Perception-Reaction Distance 0.278*V*tr, Grade-Adjusted Braking Distance, and Total Stopping Sight Distance (SSD).

Read the guide →
Causal Inference & Policy Evaluation

Abadie Synthetic Control Convex Weights and Post/Pre RMSPE Ratio

Audit convex donor-pool weights (w_j >= 0, SUM w_j = 1), pre-intervention fit, and Abadie’s post-to-pre RMSPE permutation test ratio in Excel and Arte Sheets.

Read the guide →
Text

Abbreviate names into initials: 1-, 2-, and 3-word names

Extract uppercase initials from mononyms, two-part names, and full middle-name strings using TRIM, LEFT, and TEXTAFTER.

Read the guide →
Lookup & Reference

Abbreviate state or country names to 2-letter postal codes (mixed-input safe)

Standardize columns that mix full state names ("California", "New York") and 2-letter abbreviations ("tx", "CA") into clean uppercase postal codes.

Read the guide →
Healthcare & Clinical

Abbreviated Burn Severity Index: A Historical Spreadsheet Example

Reproduce the arithmetic of the historical five-component ABSI with explicitly validated illustrative inputs; it is not a current patient prognosis.

Read the guide →
Statistical

ABC–XYZ inventory example: cumulative spend share and demand variation

Combine a chosen cumulative-spend classification with population CV of four demand observations. Thresholds are example policy choices, not universal stocking rules.

Read the guide →
Healthcare & Clinical

ABCD2 TIA Score: An Educational Spreadsheet Example

Reproduce the point arithmetic of the ABCD2 score for an illustrative example, with input checks and important limits on its use.

Read the guide →
Quantitative Finance & Market Microstructure

Abdi-Ranaldo Close-High-Low (CHL) Bid-Ask Spread Formula

Estimate effective proportional bid-ask spreads from daily OHLC bars using Abdi and Ranaldo’s (2017) two-day zero-floored formula s_t = 2 * SQRT(MAX(0, (c_t - eta_t) * (c_t - etat+1))).

Read the guide →
Commercial Credit, Working Capital & Asset-Based Lending

ABL Borrowing Base, Dilution Reserve & Availability Formula

Calculate Asset-Based Lending (ABL) Effective AR Advance Rate 0.85 - MAX(0, 2*(Dilution - 0.05)), Capped Borrowing Base MIN(Commitment, AR_Adv + 0.85*Inventory_NOLV), Excess Availability, and Springing Cash-Dominion Covenant Gate.

Read the guide →
Non-Traditional Machining, Cold-Cutting Abrasive Waterjet (AWJ) & UHP Intensifier Pumps

Abrasive Waterjet (AWJ) Jet Velocity & Pump Power Formula

Calculate Supersonic Ruby/Diamond Orifice Waterjet Velocity (m/s), Vena-Contracta Orifice Water Flow (L/min), Hydraulic Jet Power (kW), and Garnet-to-Water Mass Loading Ratio.

Read the guide →
Math

ABS function: measure budget variance distance and tolerance bands

Strip minus signs with ABS so over-budget and under-budget variances do not cancel each other out and symmetric tolerance checks stay concise.

Read the guide →
Cell references

Absolute and relative cell references: lock constants with $ when copying formulas

Copied formulas adjust row and column coordinates automatically unless you lock them with dollar signs. Calculate wholesale pack prices from one shared pack size and handling fee without breaking rows below.

Read the guide →
Healthcare

Absolute Neutrophil Count (ANC) & Reticulocyte Production Index (RPI)

Practice ANC, corrected reticulocyte percentage and RPI calculations with explicit units, a configurable reference hematocrit and a supplied maturation factor.

Read the guide →
Engineering

AC & RF Skin Depth formula: delta = SQRT(rho / (pi * f * mu0 * mur))

Estimate skin depth for a good conductor with positive resistivity and a real permeability, keeping the DC case separate.

Read the guide →
Health Insurance Regulation & Actuarial Filing

ACA Medical Loss Ratio (MLR) & Rebate Formula

Calculate Statutory Health Insurer Adjusted Premium Denominator, HCQI-Adjusted Medical Loss Ratio (Claims + Quality_Improvement) / (Premiums - Regulatory_Assessments), and Mandatory Policyholder Rebate.

Read the guide →
Spreadsheet Governance & Collaborative AI Workflows

Academy MCP Lesson Gate, Locale & Progress Audit Formula

Audit academy:read lesson access across free vs Pro-gated catalog metadata, transparent locale fallback without fabricated official translations, and read-only server-verified progress boundaries.

Read the guide →
Logical

Accounts receivable aging buckets: classify invoices into Current, 1-30, 31-60, 61-90, and 90+

Assign standard AR aging bands with ordered IFS thresholds and summarize dollar exposure per bucket with SUMIF.

Read the guide →
Financial

ACCRINT and ACCRINTM: calculate accrued interest on coupon and at-maturity bonds

Choose ACCRINT for periodic-coupon bonds and ACCRINTM for securities that pay all interest at maturity.

Read the guide →
Labor Economics & Human Capital

Acemoglu-Pischke Firm-Sponsored General Training Formula

Calculate Daron Acemoglu and Jorn-Steffen Pischke’s (1998, 1999) optimal firm-paid general training intensity tau* = (theta_comp * p_skill) / c_tr under compressed wage structures versus Gary Becker’s (1964) zero-sponsorship benchmark.

Read the guide →
Structural Engineering, ACI 318 Reinforced Concrete & Flexural Design

ACI 318 Whitney Stress Block Concrete Beam Moment Formula

Calculate Whitney Compression Block Depth a (mm), Net Tensile Rebar Strain epsilon_t, Nominal Flexural Capacity M_n (kN·m), and Tension-Controlled Design Moment phi*M_n (kN·m).

Read the guide →
Civil, Structural & Geotechnical Engineering

Ackers-White (1973) Sediment Transport Formula: Mobility Number F_gr & Concentration

Calculate Peter Ackers and W. Rodney White’s (1973, HR Wallingford / ASCE) Transition-Exponent Sediment Mobility Number F_gr and Mass Flux Concentration X_ppm across fine transitional sand to coarse gravel.

Read the guide →
Mechanical Actuators, Acme Lead Screws & Lifting Jacks

Acme Power Screw Raising/Lowering Torque & Efficiency Formula

Calculate Acme Thread Raising Torque T_R (N·m) including Thrust Collar Friction, Load-Lowering Torque T_L (N·m), Overall Screw+Collar Efficiency (%), and Overhauling Check.

Read the guide →
Math

ACOS function: find roof or vector angles from adjacent-over-hypotenuse ratios

Calculate arccosine angles in [0, 180] degrees using DEGREES(ACOS(ratio)), and guard ratios outside [-1, 1].

Read the guide →
Math

ACOT and ACOTH: calculate inverse cotangent and inverse hyperbolic cotangent

Compute principal inverse cotangent angles in (0, pi) with ACOT and inverse hyperbolic cotangents for |x| > 1 with ACOTH.

Read the guide →
Architectural & Noise-Control Acoustics, Sound Isolation & Partitions

Acoustic Mass Law Wall Transmission Loss & Coincidence Formula

Calculate Partition Surface Mass Density m_s (kg/m²), Field-Incidence Mass-Law Sound Transmission Loss TL (dB), Critical Bending-Wave Coincidence Frequency f_c (Hz), and STC Speech-Band Warning.

Read the guide →
Engineering & Science

Acousto-Optic Modulator (AOM) Acoustic Wavelength & Bragg Deflection Angle

Calculate the ultrasonic grating period Lambda = v_a / f_RF (um) and external Bragg angle theta_B ~ (lambda_0 * f_RF) / (2 * v_a) (milliradians) for TeO2 and fused-silica laser acousto-optic deflectors.

Read the guide →
Clinical Medicine & Physiology

ACR TI-RADS: An Educational Example of Adding Feature Points

Practice adding invented thyroid ultrasound feature points, including the cystic or spongiform special case; this worksheet does not make clinical recommendations.

Read the guide →
Biological Wastewater Treatment, Nitrification & Sludge Wasting

Activated-Sludge SRT (MCRT), F/M Ratio & WAS Flow Formula

Calculate Aeration Bioreactor Biomass Inventory (kg MLVSS), Food-to-Microorganism F/M Ratio (d^-1), Required Daily Waste Activated Sludge Mass (kg/d), and WAS Pump Flow (m³/d).

Read the guide →
Hydronic HVAC Systems, DOAS + Active Chilled Beams & Sensible Cooling Engineering

Active Chilled Beam Induction Ratio & Cooling Formula

Calculate Induced Room Secondary Airflow Q_sec (L/s), Primary DOAS Ventilation Sensible Cooling (W), Secondary Hydronic Coil Sensible Cooling (W), and Total Chilled-Beam Sensible Capacity (W).

Read the guide →
Actuarial Life Contingencies & Insurance Mathematics

Actuarial Commutation Dx, Nx, Mx & Life Premium Formula

Calculate Life Annuity-Due a_ddot_x = N_x / D_x, Death-Benefit Commutation M_x = D_x - (i / (1 + i)) * N_x, Whole-Life Net Single Premium Face * (M_x / D_x), and Net Level Annual Premium Face * (M_x / N_x).

Read the guide →
Financial

Actuarial Pure Premium (Frequency x Severity) & Credibility Factor Z

Explore observed loss cost, a simplified variable-load calculation and a separate limited-fluctuation claim-frequency credibility illustration.

Read the guide →