Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Lookup & Reference

Case-sensitive lookup with EXACT, XLOOKUP and INDEX/MATCH

Use a per-row EXACT helper to distinguish letter case in text identifiers, with explicit blank and missing-match handling.

Read the guide →
Lookup & Reference

Case-sensitive lookup: match uppercase vs lowercase IDs with EXACT

Combine XLOOKUP or INDEX/MATCH with EXACT when short alphanumeric IDs differ only by letter case.

Read the guide →
Math

Case-sensitive sum and count with EXACT helper flags

Prevent SUMIF and COUNTIF from merging case-distinct IDs like "001XyzAB" and "001Xyzab" by pairing EXACT with SUMPRODUCT.

Read the guide →
Math & Trig

Cash denomination calculator: break amounts into $100, $50, $20, $10, $5, $1 bills

Compute the minimum number of banknotes for cash envelopes and register drawers using INT and sequential MOD remainders.

Read the guide →
Financial

Cash-on-Cash Return & Equity Multiple (EMx) formulas in Real Estate

Compute a simplified annual pre-tax cash-on-cash ratio and a realized full-cycle distributions-to-equity multiple, without confusing either with annualized return.

Read the guide →
Engineering & Science

Casimir Effect Quantum Vacuum Pressure (1/d^4) & MEMS Plate Force Formula

Calculate the attractive quantum-electrodynamic Casimir pressure P_C = (PI()^2 * hbar * c) / (240 * d^4) in Pascals and stiction force F_C in microNewtons between parallel uncharged conducting plates separated by d nanometers.

Read the guide →
Confectionery Rheology & Food Physics, IOCCC / ICA Casson Chocolate Flow Model

Casson Chocolate Yield Stress & Plastic Viscosity Formula

Calculate IOCCC Casson High-Shear Stress tau (Pa), Apparent Pumping Viscosity (Pa·s), Low-Shear 2 s⁻¹ Gravity-Drain Stress (Pa), and Low-Shear Coating Viscosity (Pa·s).

Read the guide →
Insurance-Linked Securities (ILS) & Reinsurance Capital Markets

Catastrophe Bond Spread Multiple & Layer Payout Formula

Calculate ILS Catastrophe Bond Risk-Spread-to-Expected-Loss Multiple, Actuarial Net Excess Spread (bps), Proportional Layer Principal Write-Down Principal * MIN(1, MAX(0, (Loss - Attach)/(Exhaust - Attach))), and Surviving Investor Principal.

Read the guide →
Healthcare & Clinical

CATCH Head-Injury Research: Understanding Sensitivity in a Spreadsheet

Calculate sensitivity from fictional counts and read the original CATCH derivation and later validation studies.

Read the guide →
Text

Categorize bank or expense descriptions by keyword rules

Map noisy merchant strings like "Card #44 UBER *TRIP" into clean accounting categories using IFS, ISNUMBER, and SEARCH.

Read the guide →
Engineering & Science

Cauchy Dispersion Equation: Phase Refractive Index n(λ) & Group Index ng(λ)

Calculate visible/near-IR optical phase refractive index n(λ) = A + B/λ^2 + C/λ^4 and ultrafast pulse group index n_g(λ) = n - λ*(dn/dλ) = A + 3B/λ^2 + 5C/λ^4 across wavelength λ (μm).

Read the guide →
Engineering & Science

Caughey-Thomas Doping-Dependent Mobility & Wafer Resistivity (Si)

Calculate semiconductor carrier mobility μ(N) = μ_min + (μ_max - μ_min) / (1 + (N / N_ref)^α) (cm^2/(V·s)) and doped wafer resistivity ρ = 1 / (q * N * μ) across five orders of dopant concentration.

Read the guide →
Healthcare & Clinical

CDAI and SDAI: Two Rheumatoid Arthritis Score Examples

Calculate fictional CDAI and SDAI totals from complete joint counts and global ratings, with explicit CRP units and scoring assumptions.

Read the guide →
Financial

CDS Credit Triangle Hazard Rate & Cumulative Default Probability formulas

Estimate a constant risk-neutral hazard rate from a spread and assumed recovery, then calculate the corresponding model survival and default probabilities.

Read the guide →
Numbers and totals

CEILING.MATH, FLOOR.MATH, and ROUNDDOWN: round to multiples and full units

Round billable minutes up to 15-minute blocks with CEILING.MATH, round stock down to whole pallet multiples with FLOOR.MATH, and count complete dozens with ROUNDDOWN.

Read the guide →
Conditional Aggregation

Cell Equals, Count, or Sum One of Many Values (Allowlist COUNTIF + SUMPRODUCT)

Replace brittle 10-way OR chains with a range-driven COUNTIF allowlist flag to test, count, and sum rows matching any value in an editable lookup list.

Read the guide →
Engineering

Celsius to Fahrenheit and Kelvin conversion formulas (and back)

Convert temperatures accurately between °C, °F, and Kelvin with exact 9/5 and 5/9 affine formulas.

Read the guide →
High-Precision Cylindrical Finishing, Centerless Grinding Regulating Feed & Lobing Geometry

Centerless Grinding Through-Feed & Workrest Angle Formula

Calculate Regulating-Wheel Surface Speed (m/min), Axial Through-Feed Rate (mm/min and m/min), and Above-Center Tangency Rounding Angle Beta (deg).

Read the guide →
HVAC Energy Retrofits, Variable Frequency Drives (VFDs) & Turbomachinery Fan Laws

Centrifugal Fan Affinity Laws & VFD Cubic Power Formula

Calculate VFD Turndown Airflow Q2 (m³/h), Quadratic Static Pressure Delta_P2 (Pa), Cubic Shaft Power P2 (kW), and Annual Fan Energy Savings (kWh/yr).

Read the guide →
Engineering

Centrifugal Pump & Fan Affinity Laws: Flow (N), Head (N^2) & Cube Power (N^3)

Explore ideal speed scaling for flow, head and shaft power at corresponding centrifugal-pump operating points.

Read the guide →
Science

Centrifuge RCF (x g) to RPM Conversion Formula & Rotor Scaling

Convert RPM and relative centrifugal force using a specified radius in centimeters. Keep the inverse result unrounded and distinguish a numerical conversion from a permitted instrument setting.

Read the guide →
Technical & Sanitaryware Ceramics, Darcy-Washburn Plaster Slip-Casting Kinetics

Ceramic Slip Casting Parabolic Wall-Buildup Formula

Calculate Wet Cast Green Wall Thickness L = SQRT(2*K*t) (mm), Instantaneous Buildup Rate dL/dt (mm/min), Fired Ceramic Wall Thickness (mm), and Dwell Time for 8 mm Cast (min).

Read the guide →
Technical Ceramics, Thermoelasticity & High-Temperature Materials

Ceramic Thermal-Shock Resistance R & R-Prime Formula

Calculate Hasselman/Kingery Severe-Quench Critical Delta-T Parameter R (K), Conduction-Weighted Parameter R-Prime (W/m), Biaxial Quench Surface Stress (MPa), and Thermal-Shock Safety Factor.

Read the guide →
Statistical

CHA2DS2-VASc score arithmetic with validated flags and age bands

Practice weighted binary flags and mutually exclusive age bands using a fictional CHA2DS2-VASc example; distinguish it from the newer ESC CHA2DS2-VA approach.

Read the guide →
Quantitative Finance & Trading

Chaikin Money Flow (CMF) Formula: Close Location Value Multiplier & Flat-Bar Guard

Calculate Marc Chaikin’s Close Location Value (Money Flow Multiplier) ((C - L) - (H - C)) / (H - L), Money Flow Volume, and 20-period CMF ratio with a halted/flat-bar zero-range guard.

Read the guide →
Lookup & Reference

Chained / Nested Two-Step Lookup Across Mapping Tables (XLOOKUP)

Bridge normalized relational tables (such as Employee -> Job Band -> Bonus Target %) in a single formula by nesting one XLOOKUP or VLOOKUP as the lookup_value of a second.

Read the guide →
Science

Chandrasekhar Mass Limit & White-Dwarf Radius in a Spreadsheet

Calculate a composition-dependent limiting mass and a Nauenberg-style zero-temperature radius. Keep solar and Earth units explicit, validate the model domain, and avoid treating the limit as a supernova prediction.

Read the guide →
Statistical & Clinical Analysis

Chao1 & Bias-Corrected Unseen Species Richness Formula: Singletons & Doubletons

Estimate true total assemblage richness (including undetected rare species, software bugs, or vocabulary words) using Anne Chao’s (1984) bias-corrected lower bound S_Chao1 = S_obs + f_1 * (f_1 - 1) / (2 * (f_2 + 1)) and Sample Inventory Completeness %.

Read the guide →
Engineering & Science

Chapman-Enskog Low-Pressure Gas Viscosity Formula (Lennard-Jones)

Calculate dilute gas dynamic viscosity μ = 2.6693 * SQRT(M * T) / (σ^2 * Ω_μ) (μPa·s) from molecular weight, absolute temperature, Lennard-Jones collision diameter σ (Å), and collision integral Ω_μ.

Read the guide →
Text

CHAR and CODE: insert line breaks CHAR(10) and inspect hidden character codes

Generate non-keyboard characters like CHAR(10) line feeds or increment letter sequences with CHAR and CODE.

Read the guide →
Healthcare & Clinical

Charlson Comorbidity Research: The 1987 Cohort and Formula

Examine the original age-comorbidity research, its historical cohort and the arithmetic of its theoretical 10-year model.

Read the guide →
Statistical & Clinical Analysis

Chart Error Bars Formula: Standard Error of the Mean (SEM) vs. SD & 95% CI Bounds

Avoid Excel’s default fixed-value "Standard Error" chart trap by calculating true replicate Standard Error SEM = STDEV(B2:B6) / SQRT(COUNT(B2:B6)) and custom 95% confidence bounds Mean ± 1.96 * SEM.

Read the guide →
Math & Statistical

Check & Count Exact Multiples of a Specific Pack or Lot Size (MOD = 0)

Test whether order quantities are exact multiples of case pack size N using MOD(qty, N) = 0, flag broken-case remainders, and count full-case orders across a table.

Read the guide →
Logical

Check a budget cap, allocation total, and order-pack multiples

Build TRUE/FALSE audit formulas for a budget cap, allocation weights and pack quantities. A formula result alone does not block data entry.

Read the guide →
Learn with AI

Check an AI forecast in a live workbook before sharing it

Turn a short sales example into a formula-based forecast, label its assumptions and test a changed month. Keep the workbook as the result, not only the chat answer.

Read the guide →
Engineering

Check Baggage Dimensions: Inches to Centimeters and Configurable Limits

Build a spreadsheet dimension check using configurable per-axis and total limits. Convert inches to centimeters and compare unrounded totals without claiming airline approval.

Read the guide →
Text

Check if a cell begins or ends with specific text (prefix and suffix)

Test dynamic prefixes with LEFT(text, LEN(prefix)) and suffixes with RIGHT(text, LEN(suffix)), with optional EXACT case sensitivity.

Read the guide →
Logical & Conditional

Check If a Cell Contains a Whole Integer vs. Decimal (ISNUMBER, INT & MOD)

Validate discrete carton quantities, headcount, and serial IDs using AND(ISNUMBER(B2), B2 = INT(B2))—rejecting fractional decimals (4.25), text strings ("12"), and blank cells cleanly.

Read the guide →
Logical

Check if a cell contains all required keywords (and no excluded words)

Screen resumes, logs, or SKUs for ALL required terms, ANY optional term, and ZERO excluded terms using AND, OR, ISNUMBER, ISERROR, and SEARCH.

Read the guide →
Text

Check if a cell contains any number (0–9) and count digits

Detect embedded numeric digits inside alphanumeric codes or passwords—where ISNUMBER returns FALSE—by stripping digits 0–9.

Read the guide →
Date & Time

Check If a Date Is a Workday (Exclude Weekends & Holidays)

Check a Monday–Friday work calendar against an explicit list of organization closure dates, with validation for missing dates and timestamp handling.

Read the guide →
Logical

Check if a range contains duplicates (single-cell audit gate)

Compare total non-blank entries against distinct UNIQUE values to trigger a sheet-level duplicate warning and count excess repeat rows.

Read the guide →
Logical

Check if a row is completely blank, complete, or partially filled

Classify rows as blank, Complete or Incomplete with COUNTBLANK and COLUMNS.

Read the guide →
Lookup & Reference

Check If a Value Exists in a Range (COUNTIF & XMATCH Membership Test)

Check a nonblank ID against an approved list, distinguish literal matching from COUNTIF criteria, and test whether either of two watch-list IDs is present.

Read the guide →
Logical

Check if a value is within a percentage tolerance (±%)

Test symmetric upper and lower tolerance bands in one step with ABS(Measured - Target) / ABS(Target) <= Tolerance.

Read the guide →
Date & Time

Check if a year is a leap year (4 / 100 / 400 Gregorian rule)

Test any year or date for 366-day leap years accurately—including century exceptions like 1900 vs 2000—using MOD or DATE(yr, 2, 29).

Read the guide →
Logical & Lookup Formulas

Check if All Cells in a Range Are Blank (COUNTBLANK vs COUNTA)

Test whether an entire row or multi-column block is completely blank using COUNTBLANK(B2:E2) = COLUMNS(B2:E2) (including formula empty strings "") vs strict COUNTA(B2:E2) = 0.

Read the guide →
Date & Time

Check if all dates in a column are in chronological order

Compare offset ranges A2:A4 and A3:A5 inside SUMPRODUCT to verify schedules never step backward and count out-of-order rows.

Read the guide →
Logical

Check if all values in a range are at least a minimum threshold

Verify that every cell in a batch meets a minimum score AND no cell was left blank—avoiding the MIN(range) blank-cell loophole.

Read the guide →
Text

Check if cell contains specific words but NOT others (SEARCH, ISNUMBER & NOT)

Match product SKUs, support tickets, or billing descriptions that include required keywords while excluding disqualifying terms like "Trial" or "Refund".

Read the guide →