Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Lookup & Reference

Count, sum and find the maximum in a selected column with CHOOSECOLS

Select a metric by its unique header, then use SUMPRODUCT to count qualifying rows or total a region and MAX for all regions.

Read the guide →
Math

COUNTIF & SUMIF Across Non-Contiguous Ranges (Additive & VSTACK)

Count matching rows and sum quantities from two separate blocks, with literal criteria and a dynamic-array alternative.

Read the guide →
Checking repeated records

COUNTIF in Excel: flag repeated IDs before changing the data

Count repeated booking identifiers, keep blank IDs out of the flags, and distinguish repeated rows from extra copies.

Read the guide →
Dates and reporting

COUNTIFS between dates: count a full month, including timestamps

Count open repair tickets received in March. Use an inclusive start and an exclusive next-month boundary so a ticket arriving late on the final day is included.

Read the guide →
Counting records

COUNTIFS: count open orders above a minimum amount

Count qualifying orders without adding their values. This example combines an order status with a minimum amount and checks what happens exactly at the threshold.

Read the guide →
Financial

Coupon-date bond valuation with PV: par, discount and premium

Price a simplified fixed-coupon bond on a coupon date and compare its current yield with yield to maturity.

Read the guide →
Antitrust Economics & M&A Strategy

Cournot Merger Paradox & 80% Threshold Formula

Prove Salant, Switzer & Reynolds’s (1983) Cournot Merger Paradox: without cost synergies, merging M of N symmetric Cournot rivals loses money unless M >= 80% of the industry.

Read the guide →
Industrial Organization & Antitrust Economics

Cournot Oligopoly Nash Price and Cowling-Waterson HHI Lerner Formula

Solve N = 3 asymmetric Cournot-Nash equilibrium price P* = (a + SUM c_i) / (N + 1), firm outputs q_i = (P* - c_i) / b, and verify Cowling and Waterson’s HHI / |e_D| markup identity.

Read the guide →
Logical

Course & onboarding completion matrix formula ("Complete", "In Progress 3/4", "Not Started")

Summarize explicit X completion marks for four modules and calculate the share of listed learners with every module marked.

Read the guide →
Counting & Conditional Aggregation

Course Completion & Compliance Pass-Rate Summary With COUNTIFS

Calculate LMS training compliance rates (%) requiring both Status = "Completed" and Exam Score >= Passing Cutoff using COUNTIFS(C2:C7, "Completed", D2:D7, ">=" & F2) / COUNTA(A2:A7).

Read the guide →
Financial

Covered Interest Rate Parity (CIRP): FX forward rate & forward points formula

Compute an illustrative FX forward parity benchmark using simple annual rates, a common day basis and a stated quote convention.

Read the guide →
Health & Fitness

Cox Survival Arithmetic: Framingham and Historical Pooled Cohort Context

Explore the survival transformation shared by some historical cardiovascular risk models, with model-specific parameters and no automatic clinical classification.

Read the guide →
Financial Modeling

Cox-Ingersoll-Ross (CIR) Short-Rate Zero-Coupon Bond Price, Yield & Feller Condition

Price affine zero-coupon bonds under the Cox-Ingersoll-Ross (1985) square-root diffusion dr = a(b - r)dt + sigma*sqrt(r)dW with closed-form A(T), B(T), and Feller positivity ratio 2ab / sigma^2.

Read the guide →
Actuarial Science & Insurance Risk

Cramér-Lundberg Ruin Probability & Adjustment Coefficient R

Calculate relative security loading theta, Cramér-Lundberg adjustment coefficient R = theta / ((1 + theta) * mu), Lundberg ruin bound EXP(-R * u_0), and exact exponential ruin probability.

Read the guide →
Statistical

Cramer's V effect size & Chi-Square contingency table association formula

Calculate Chi-Square SUM((O - E)^2 / E) and sample-size-adjusted Cramer's V = SQRT(ChiSq / (N * MIN(r - 1, c - 1))) for categorical cross-tabulations.

Read the guide →
Aerospace Cost Estimating & Operations

Crawford Unit vs Wright Learning Curve Formula

Avoid a 44% unit-cost bidding error by distinguishing J. R. Crawford’s Incremental Unit Learning Curve Y_n = T_1 * n^b from T. P. Wright’s Cumulative-Average Unit Difference T_1*(n^(1+b) - (n-1)^(1+b)).

Read the guide →
Commercial Real Estate & Mortgage Finance

CRE Debt Yield, Loan Constant & Leverage Spread Formula

Underwrite commercial real estate via Debt Yield = NOI / Loan, Monthly-Pay Annual Loan Constant k_debt, DSCR = Debt_Yield / k_debt, and Positive vs Negative Cash-on-Cash Leverage.

Read the guide →
Dynamic Arrays

Create a date sequence between two dates with SEQUENCE

Generate an inclusive daily or weekly calendar column dynamically from StartDate and EndDate using SEQUENCE(End - Start + 1, 1, Start, 1).

Read the guide →
Text

Create a project-specific URL matching key

Build a simplified host/path comparison key only where your project explicitly treats these URL variants as equivalent.

Read the guide →
Text

Create display masks for synthetic identifiers and email addresses

Practice last-four display masking with synthetic text values. A masked output does not remove or secure the original data.

Read the guide →
Text

Create standardized email addresses from first and last name columns

Build lowercase first.last@domain email addresses while stripping stray spaces and apostrophes from multi-part surnames.

Read the guide →
Healthcare & Clinical

CRIB II Research and Temperature Unit Conversion in Spreadsheets

Learn about the CRIB II research and convert fictional temperatures between Celsius and Fahrenheit.

Read the guide →
Project Management & Operations Research

Critical Chain Root-Sum-of-Squares Buffer Formula

Pool task contingencies into Eliyahu Goldratt’s (1997) Critical Chain Project Buffer PB_SSQ = SQRT(SUM((P90_i - P50_i)^2)) and monitor execution with the Fever-Chart Buffer Burn Index.

Read the guide →
Statistical & Math

Cronbach’s Alpha (alpha) Internal Consistency & Spearman-Brown Prophecy

Calculate psychometric test reliability Cronbach’s alpha = (K / (K - 1)) * (1 - Sum_Item_Var / Total_Score_Var) and Spearman-Brown predicted reliability for scaled test length.

Read the guide →
FX Derivatives & International Money Markets

Cross-Currency Basis & CIP Deviation Formula

Calculate 1-Year FX Forward Premium, FX-Swapped Synthetic USD Rate, Du-Tepper-Verdelhan Cross-Currency Basis Spread (bps), and Hedged USD Cash-Lender Arbitrage Pickup.

Read the guide →
Petroleum Refining & Midstream Blending

Crude Oil API Gravity & Pipeline Blend Formula

Convert API Gravity to 60°F Specific Gravity SG = 141.5 / (API + 131.5), compute Exact Volumetric Blended Specific Gravity, and recover True Blended API Gravity without linear-API averaging error.

Read the guide →
Healthcare & Clinical Calculations

CRUSADE Bleeding Score: An Educational Point-Sum Example

Add invented CRUSADE component points with discrete-value checks. This worksheet does not estimate individual bleeding risk or prescribe care.

Read the guide →
Industrial Gases, Cryogenic Distillation & Steel/Gasification Utilities

Cryogenic Air Separation Unit (ASU) Oxygen & Power Formula

Calculate Cryogenic ASU Dry-Air Intake Flow (Nm³/hr), Daily Pure Oxygen Tonnage (t/day), Main Air Compressor Power (MW), and Total Pipeline GOX Electrical Load (MW).

Read the guide →
Aerospace LH2/LN2 Storage & MRI Cryostats, Multi-Layer Superinsulation (MLI) Boil-Off

Cryogenic Dewar MLI Heat Leak & NER Boil-Off Formula

Calculate MLI Blanket Radiative/Conductive Shell Leak (W), Total Parasitic Heat Load Including Neck/Supports (W), Daily Boil-Off Mass (kg/d), and Normal Evaporation Rate NER (%/d).

Read the guide →
Medical Imaging Physics, Computed Tomography (CT) QA & Radiodensity Windowing

CT Hounsfield Unit (HU) & Display Window Grayscale Formula

Calculate Calibrated Hounsfield Unit HU = 1000*(mu_x - mu_water)/(mu_water - mu_air), Lower/Upper Display Window Bounds, and 8-Bit Monitor Grayscale Intensity (0–255).

Read the guide →
Math & Trig

Cube root and nth root formula: positive and negative numbers

Raise numbers to fractional exponent ^(1/n) for any root degree, and pair SIGN with ABS for negative odd roots.

Read the guide →
Statistical

Cumulative (expanding) average formula: AVERAGE($B$2:B5)

Track season-to-date or year-to-date running averages with an expanding range $B$2:B2 that locks row 2 and grows automatically as you copy down.

Read the guide →
Finance & Accounting

Cumulative Loan Principal & Interest Paid Between Two Periods (FV & PMT)

Calculate exact cumulative principal and cumulative interest paid between any start period s and end period e without building a 360-row amortization schedule using FV balance differences.

Read the guide →
Clinical Medicine & Physiology

Cunningham Equations: Fat-Free Mass and Energy Estimates

Compare the 1980 and 1991 body-composition equations with a fictional example and an assumed activity multiplier.

Read the guide →
Statistical

CURB-65 and qSOFA: separate score formulas with boundary tests

Practice IF and OR using fictional CURB-65 and qSOFA inputs, explicit units and separate mental-status criteria.

Read the guide →
Engineering & Science

Curie-Weiss Paramagnetic Susceptibility & Effective Bohr Magneton (mu_eff)

Calculate molar magnetic susceptibility chi_m = C / (T - theta_CW) above magnetic ordering temperatures and extract unpaired d/f-electron effective moment mu_eff = SQRT(8 * C_cgs) in Bohr magnetons (mu_B).

Read the guide →
Financial

Currency conversion formula: cross-currency FX table with XLOOKUP

Convert between any pair of currencies (EUR to USD, EUR to GBP, JPY to EUR) from a single USD-anchored FX table—no N-by-N matrix needed.

Read the guide →
Engineering

Current Divider Rule & Thevenin Maximum Power Transfer Theorem formulas

Split parallel branch currents using opposite resistance I_1 = I_total * (R_2 / (R_1 + R_2)) and verify Thevenin load power P_L = V_th^2 * R_L / (R_th + R_L)^2 peaking at R_L = R_th.

Read the guide →
Financial

Current Ratio, Quick Ratio (Acid-Test), and Net Working Capital (NWC)

Calculate current and quick ratios and compare total working capital with one explicitly defined operating-working-capital measure.

Read the guide →
Date & Time

Custom 1-letter ("MTWRFSU") & 2-letter weekday abbreviations (WEEKDAY, MID & CHOOSE)

Map numeric dates to explicitly chosen one- or two-letter weekday labels, independently of localized weekday names.

Read the guide →
Data Validation & Auditing

Custom Data Validation: Numbers Only, Text Only, Whole %, & Weekdays Only

Enforce strict type, whole-percentage integer step, and Monday–Friday business-day rules on intake rows using ISNUMBER, ISTEXT, MOD, and WEEKDAY(date, 2) <= 5.

Read the guide →
Dynamic arrays

Custom sort order with formula: rank Critical, High, Medium, Low using SORTBY

Map non-alphabetical status labels to a custom priority table with XMATCH and sort rows automatically via SORTBY.

Read the guide →
Financial

Customer Lifetime Value (LTV), LTV:CAC ratio, and CAC Payback formula

Calculate gross-margin-adjusted Customer Lifetime Value (ARPU * GrossMargin / Churn), LTV:CAC ratio, and months to recover Customer Acquisition Cost.

Read the guide →
Science

Cyclotron Frequency, Larmor Gyroradius & MRI Proton Larmor Frequency

Calculate charged-particle Cyclotron Frequency f_c = |q| * B / (2 * PI() * m) (MHz), magnetic Larmor Gyroradius r_L = (m * v_perp) / (|q| * B) (mm), and 1H MRI nuclear Larmor resonance (42.577 MHz/T).

Read the guide →
Engine Block Tribology & Bore Finishing, Plateau Honing Included Crosshatch Angle

Cylinder-Bore Honing Crosshatch Angle & Speed Formula

Calculate Hone Stone Rotary Surface Speed vr (m/min), Mean Axial Reciprocating Speed va (m/min), Resultant Cutting Speed vres (m/min), and Included Crosshatch Angle 2·alpha (deg).

Read the guide →
Crystal Growth, Silicon Wafer Boules & Dopant Segregation

Czochralski Silicon Ingot Dopant Segregation Profile Formula

Calculate Seed-End Crystal Dopant Concentration C_s(0), Solidified-Fraction Ingot Concentration C_s(g), Enriched Crucible Melt Concentration C_L(g), and Tail-to-Seed Resistivity Drift Ratio.

Read the guide →
Political Economy, Governance & Resource Allocation

d’Hondt vs Sainte-Laguë Seat Apportionment Formula

Compare Victor d’Hondt (divisors 1, 2, 3) against André Sainte-Laguë (odd divisors 1, 3, 5) highest-averages apportionment using LARGE and COUNTIF across multi-party seat allocations.

Read the guide →
Transportation Logistics & Last-Mile Operations

Daganzo Milk-Run Vehicle Routing Length Formula

Estimate multi-stop fleet tour mileage using Carlos Daganzo’s (1984) continuous approximation L_fleet = 2 * r_stem * m_tours + k_tsp * SQRT(N_stops * Area) and quantify consolidation savings.

Read the guide →
Engineering

Dalton partial pressure and Henry equilibrium concentration formulas

Calculate ideal-mixture partial pressure and dilute-solution equilibrium concentration with an explicitly defined Henry solubility coefficient.

Read the guide →
Engineering & Science

Damköhler Number (Da): Isothermal First-Order CSTR vs. PFR Conversion

Calculate the first-order reactor Damköhler number Da = k * tau and compare continuous stirred-tank conversion X_CSTR = Da / (1 + Da) against plug-flow conversion X_PFR = 1 - EXP(-Da).

Read the guide →