Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Nonparametric Statistics & Clinical Trials

Brunner-Munzel Heteroscedastic Rank Test and Stochastic Superiority

Solve the nonparametric Behrens-Fisher unequal-variance problem using Brunner and Munzel’s (2000) placement-variance rank statistic W_BM and Satterthwaite degrees of freedom.

Read the guide →
Charts & Data Visualization

Bubble Chart Size Formula: Area-Proportional Radius SQRT(Z / Z_max) vs Diameter Distortion

Encode a third quantitative variable Z accurately in Bubble Charts by scaling circle radius as R_i = R_max * SQRT(Z_i / MAX(Z)) so visual disk area PI * R_i^2 stays strictly proportional to magnitude Z_i.

Read the guide →
Public Economics & Club Goods

Buchanan Club Goods Optimal Membership Size Formula

Calculate James Buchanan’s Optimal Club Membership N* = SQRT(F / c_cong), Optimal Cost-Sharing Dues F / N*, Marginal Congestion Externality, and Per-Member Net Club Surplus.

Read the guide →
Vertical Bulk Material Handling, Grain Legs, Cement Bucket Elevators & CEMA Sizing

Bucket Elevator Critical RPM, Pole Distance & Capacity Formula

Calculate Centrifugal Pole Distance hp = g / omega² (m), Critical Zero-Throw Pulley Speed Ncrit (RPM), Linear Belt/Chain Speed (m/s), and Mass Elevating Capacity Qm (t/h).

Read the guide →
Actuarial Science & Credibility Pricing

Bühlmann-Straub Credibility Factor Z and Pure Premium Formula

Blend policyholder loss experience X_bar with manual class rate mu using Bühlmann-Straub credibility weight Z = (m * a) / (m * a + v) without division-by-zero traps.

Read the guide →
Statistical & Conditional Counting

Build a Dynamic Two-Way Count Matrix (Mixed-Reference COUNTIFS Cross-Tab)

Cross-tabulate ticket or order counts by Priority (rows) and Channel (columns) using mixed-reference COUNTIFS that updates instantly without manual PivotTable refreshes.

Read the guide →
Financial Modeling

Build a Formula-Driven KPI Scorecard Panel (Polarity-Aware Attainment, Weights & RAG Status)

Combine higher-is-better growth metrics and lower-is-better payback/defect metrics into one normalized executive KPI scorecard with weighted attainment and Red/Amber/Green status.

Read the guide →
Logical & Conditional

Build an "IF NOT ERROR" Rule (Execute Custom Logic Only When Lookup Succeeds)

Invert Excel’s built-in IFERROR—which only replaces errors while passing raw successes straight through—by combining IF(ISNA(XMATCH(...)), Fallback, Custom_Success_Result) or IF(NOT(ISERROR(expr)), Success, Error).

Read the guide →
Formula Auditing & Logic

Build an ISNOTERROR Formula Gate (NOT(ISERROR)) for Pre-Publish Workbook Checks

Construct the missing ISNOTERROR predicate with NOT(ISERROR(cell)) to score clean-row pass rates, block broken model tabs from release, and coordinate team sign-off.

Read the guide →
Text & Data Cleaning

Build Clean UTM & API Query URLs with Cross-Platform Percent-Encoding Formulas

Assemble campaign tracking and webhook URLs from spreadsheet columns while safely percent-encoding %, spaces, ampersands, and plus signs across Windows, Mac, and browser sheets.

Read the guide →
Text & String Cleaning

Build Dynamic mailto: Email Links With Subject, CC & URL-Encoded Body

Assemble RFC-6068 mailto: URIs from spreadsheet recipient, CC, subject, and body cells—replacing spaces with %20 via SUBSTITUTE so mail clients never truncate subjects at the first space.

Read the guide →
Text

Build in-cell histograms and 10-slot progress bars with REPT

Scale large counts down by a divisor for compact REPT("|", ...) histograms, and clamp [====------] progress bars safely with MEDIAN.

Read the guide →
Naval Architecture & Dry-Bulk Stowage

Bulk Carrier Stowage Factor & Full-and-Down Formula

Calculate Vessel Ideal Stowage Factor V_hold / DWT_cargo, Maximum Loadable Tonnage MIN(DWT_cargo, V_hold / (SF * (1 + bs))), Deadweight Utilization, and Cube-Out vs Weigh-Out status.

Read the guide →
Charts & Visual Data Modeling

Bullet Graph Formula: Stacked Qualitative Range Deltas, Actual Bar & Target Variance

Build Stephen Few’s compact dashboard Bullet Graph using incremental stacked qualitative bands (Poor, Satisfactory - Poor, Good - Satisfactory), Actual Performance % of Target, and Target Gap.

Read the guide →
Industrial Organization & Pricing Strategy

Bulow-Coase Durable Monopoly Selling vs Leasing Formula

Quantify Ronald Coase’s (1972) and Jeremy Bulow’s (1982) two-period durable-goods monopoly price erosion and compare subgame-perfect outright selling profit against credible leasing.

Read the guide →
Auction Theory & M&A Strategy

Bulow-Klemperer Extra-Bidder Auction Revenue Formula

Verify Jeremy Bulow & Paul Klemperer’s (1996) theorem that an (N + 1)-bidder zero-reserve auction (N/(N + 2))*V_max strictly beats an N-bidder Myerson optimal-reserve auction.

Read the guide →
Math & Trig

Bundle and quote pricing with SUMPRODUCT (quantities, unit prices, and discounts)

Compute gross subtotals, line-discounted net totals, and total savings in a single cell with SUMPRODUCT—no line-extension column required.

Read the guide →
Clinical Medicine & Physiology

Burch–Wartofsky Scale: Research Context and Point Addition

Review the Burch–Wartofsky scale and the 2025 ATA correction, then practice adding fictional preassigned points.

Read the guide →
Well Control & Drilling Operations, Burkhardt (1961) Pipe-Tripping Surge & Swab Hydraulics

Burkhardt Wellbore Surge & Swab Tripping Pressure Formula

Calculate Burkhardt Effective Annular Fluid Velocity Veff (m/s), Laminar Annular Surge/Swab Pressure Change (kPa), Running-In Surge EMW (SG), and Pulling-Out Swab EMW (SG).

Read the guide →
Civil, Structural & Geotechnical Engineering

Burmister Two-Layer Pavement & Odemark Equivalent Thickness Formula: Deflection Factor F_2

Calculate two-layer elastic pavement surface deflection w_0 = F_2 * (1.5 * q * a / E_2) and Odemark’s Method of Equivalent Thickness h_e = f * h_1 * (E_1 / E_2)^(1/3) for stiff asphalt or base courses over soft subgrade.

Read the guide →
Clinical Medicine & Physiology

Burn Research and Percentage Caps: A Spreadsheet Exercise

Explore a fictional percentage cap and read specialist sources on the limits of burn-fluid and nutrition formulas.

Read the guide →
Engineering & Science

Burstein-Moss Shift: Degenerate Doping Optical Bandgap Widening

Calculate the conduction-band Pauli-blocking blue-shift ΔE_BM = 3.64645E-15 * n^(2/3) / m_eh^* (eV) and apparent optical bandgap E_g,opt = E_g0 + ΔE_BM in ITO and AZO transparent conducting oxides.

Read the guide →
Biogas Engineering & Anaerobic Co-Digestion, Buswell-Mueller (1952) & Boyle Stoichiometry

Buswell Anaerobic Biomethane Potential (BMP) Formula

Calculate Empirical Substrate Molar Mass (g/mol), Stoichiometric Dry Biogas Methane Share (%), Theoretical Biomethane Potential BMP (Nm³ CH4/kg VS), and Practical Yield (Nm³/t VS).

Read the guide →
Engineering

Butterworth Filter Gain, dB Roll-Off Attenuation & Bandpass Q-Factor

Calculate the magnitude and signed dB gain of an ideal analog Butterworth low-pass filter, distinguish finite-frequency gain from asymptotic roll-off, and calculate a separate bandpass Q.

Read the guide →
Healthcare & Clinical Calculators

BVAS v3 and Capped Sums: A Spreadsheet Illustration

Learn how a per-group cap works in a fictional spreadsheet example, and why a partial sum is not a Birmingham Vasculitis Activity Score or a remission assessment.

Read the guide →
Monetary Economics & Sovereign Risk

Cagan Seigniorage Revenue & Peak Inflation Rate Formula

Calculate steady-state real seigniorage (pi + g_Y) * m_0 * EXP(-alpha * pi), Cagan’s revenue-maximizing inflation rate pi* = 1/alpha - g_Y, and maximum monetizable deficit.

Read the guide →
Healthcare & Clinical Calculations

CAGE and CAGE-AID: Adding Four Binary Answers

Practice adding four fictional yes/no answers while learning the historical context and limits of the CAGE and CAGE-AID screening questionnaires.

Read the guide →
Financial

CAGR formula: calculate Compound Annual Growth Rate over multiple years

Compute the smoothed annualized growth rate with (EndValue / StartValue) ^ (1 / Years) - 1 and verify multi-year compounding.

Read the guide →
Metalcasting & Steel Foundry Engineering, Caine (1948) AFS Hyperbolic Riser Feeding Law

Caine Sand-Casting Riser Freezing-Ratio & Yield Formula

Calculate Actual Riser-to-Casting Modulus Freezing Ratio x = Mr/Mc, Volume Ratio y = Vr/Vc, Caine Hyperbolic Minimum Soundness Ratio xmin, and Mold Casting Yield (%).

Read the guide →
Statistical & Clinical Analysis

Calculate & Plot Regression Residuals: Predicted Y, Residual Error & Outlier Flag

Build a linear regression Residual Plot table without Analysis ToolPak: compute Predicted Y_hat = INTERCEPT + SLOPE * X, Signed Residual e_i = Y_i - Y_hat, and Regression Standard Error s_e = SQRT(SSE / (n - 2)).

Read the guide →
Finance

Calculate a Complete Four-Period Hull Moving Average and Efficiency Ratio

Calculate two consecutive raw Hull values and their final weighted smoothing, then compare net change with total absolute movement using Kaufman’s efficiency ratio.

Read the guide →
Financial

Calculate a fictional two-rate marginal charge with MIN and MAX

Split an amount at a threshold, apply one rate to each slice, and compare rounded charges with the underlying blended rate.

Read the guide →
Math & Trig

Calculate a ratio from two numbers: simplified whole-number (16:9) and N:1

Reduce positive integer dimensions to lowest ratio terms with GCD, or express a ratio with a nonzero denominator in N:1 form.

Read the guide →
Math & Trig

Calculate a running total (cumulative balance) that skips blank rows

Use an expanding SUM range for cumulative balances and suppress output on truly empty rows.

Read the guide →
Date & Time

Calculate age from birthdate: exact years and months as of any date

Compute completed age in whole years and remaining months from a date of birth without off-by-one rounding errors.

Read the guide →
Date & Time

Calculate business work hours between two dates and times (SLA timer)

Count only business-day work hours (e.g., 09:00–17:00 Mon–Fri) between ticket open and close timestamps using NETWORKDAYS.

Read the guide →
Lookup & Reference

Calculate Carrier Shipping Cost by Weight Ceiling & Zone (2D XLOOKUP Mode 1)

Look up parcel shipping rates from a carrier Zone x Max-Weight rate card using nested XLOOKUP with match_mode = 1 (exact match or next larger weight ceiling)—fixing VLOOKUP's next-smaller bracket bug.

Read the guide →
Healthcare

Calculate Clinical and Full Rockall Scores in a Spreadsheet

Practice validated category inputs, missing-data guards and separate pre-endoscopy and full Rockall totals using fictional data.

Read the guide →
Financial

Calculate Coast FI number: invested balance needed to coast to retirement

Divide annual retirement spending by a chosen withdrawal-rate assumption and discount back to today using PV or (1 + RealReturn)^Years.

Read the guide →
Financial

Calculate cumulative loan interest and principal for any year or period range

Compute exact Year-1, Year-2, or full-term principal and interest paid from remaining FV balances—without a 360-row schedule.

Read the guide →
Date & Time

Calculate date overlap in days: find shared days between two bookings or projects

Count inclusive overlapping days between any two date ranges in one line using MAX(0, MIN(End1, End2) - MAX(Start1, Start2) + 1).

Read the guide →
Date & Time

Calculate Days Open & Invoice Age Status (Open vs Closed Items)

Calculate elapsed calendar days as of an explicit report date, cap aging at a valid closure date, and label active items using a configurable age threshold.

Read the guide →
Lookup & Reference

Calculate difference from last non-blank entry in a sparse log (TAKE & FILTER)

Subtract the previous numeric reading in source-row order, preserving gaps and numeric zero.

Read the guide →
Date & Time

Calculate due date by category or SLA priority (business or calendar days)

Look up turnaround days by ticket priority or vendor payment tier with XLOOKUP and add business days via WORKDAY.

Read the guide →
Finance

Calculate Effective Hourly Pay Rate (Weighted Shift Pay vs Simple Mean)

Compare gross earnings per worked hour with the simple average of shift rates, and calculate an illustrative gap to a chosen target without confusing it with a statutory payroll calculation.

Read the guide →
Date & Time

Calculate expiration dates and days remaining (days, months, or month-end)

Add fixed shelf-life days, calendar warranty months (EDATE), or end-of-month expirations (EOMONTH), and flag expired items.

Read the guide →
Engineering

Calculate GPS distance between latitude and longitude coordinates

Compute great-circle distance in kilometers or miles with spherical law of cosines—clamping ACOS inside [-1, 1] for identical points.

Read the guide →
Statistical

Calculate Grubbs G and an upper-end Dixon gap ratio

Calculate two single-extreme statistics for six numeric observations, with explicit assumptions and no automatic deletion of data.

Read the guide →
Date & Time

Calculate hours between two times (including overnight night shifts)

Wrap EndTime - StartTime in MOD(..., 1) * 24 so shifts crossing midnight return 8.5 positive hours instead of -15.5.

Read the guide →
Date & Time

Calculate hours that overlap a specific time window (shift differential)

Measure exact hours of a work shift or booking that fall inside an evening differential or peak-rate time block using MAX and MIN.

Read the guide →