Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Logical

Check if multiple cells are all equal (unanimous approval check)

Verify every cell across a row holds the same non-blank value with COUNTIF and COUNTA, or enforce exact casing with EXACT.

Read the guide →
Logical

Check if multiple cells have the exact same value (Standard vs Case-Sensitive EXACT)

Compare three text codes with direct equality or case-sensitive EXACT, without treating literal wildcard characters as search patterns.

Read the guide →
Logical & Lookup Formulas

Check if Multiple Columns Are Equal (Row Audit & SUMPRODUCT Count)

Verify whether three or more system export columns agree on every row using chained pairwise AND(B2=C2, B2=D2) tests and count fully synchronized rows across a table with SUMPRODUCT.

Read the guide →
Date & Time

Check if two dates are in the same month and year

Compare EOMONTH(Date1, 0) = EOMONTH(Date2, 0) so prior-year dates in the same month number never trigger false matches.

Read the guide →
Lookup & Reference

Check submitted codes against a master list with literal comparisons

Flag missing codes and list unmatched entries without treating wildcard characters as search patterns.

Read the guide →
Engineering & Science

Chen Flow-Boiling Correlation: Reynolds Factor (F) & Suppression Factor (S)

Calculate John C. Chen’s (1966) two-phase convective enhancement factor F = (1 / X_tt + 0.213)^0.736 and nucleate-boiling suppression factor S = 1 / (1 + 2.53E-6 * Re_TP^1.17) in vertical evaporators.

Read the guide →
Biochemical Pharmacology & Drug Discovery

Cheng-Prusoff Competitive K_i from IC50 Formula

Convert assay-dependent half-maximal inhibitory concentration IC_50 into intrinsic competitive inhibitor affinity K_i = IC_50 / (1 + [L] / K_d) and compute uncompeted vs competed target receptor occupancy.

Read the guide →
Engineering & Science

Cherenkov Radiation Cone Angle (theta_C) & Relativistic Threshold Kinetic Energy

Calculate the Cherenkov light-cone half-angle theta_C = DEGREES(ACOS(1 / (n * beta))) and minimum relativistic particle kinetic energy KE_min = m0_c2 * ((1 / SQRT(1 - 1 / n^2)) - 1) in water, ice, and glass.

Read the guide →
Engineering

Chezy Open-Channel Velocity, Critical Depth (y_c) & Specific Energy

Compute Chezy velocity for uniform flow, then explore rectangular-channel critical depth, minimum specific energy and Froude number using explicit SI inputs.

Read the guide →
Statistical

Chi-Square Goodness-of-Fit statistic formula: Observed vs Expected counts

Compute the Chi-Square Goodness-of-Fit test statistic SUMPRODUCT((O - E)^2 / E), degrees of freedom, and critical-value hypothesis decision.

Read the guide →
Statistical

Chi-Square Test of Independence: 2x2 contingency table and Phi effect size

Test whether two categorical variables are independent in a 2x2 table using N*(ad - bc)^2 / (R1*R2*C1*C2) and calculate expected counts and Phi.

Read the guide →
Demography, Actuarial Science & Population Health

Chiang Life-Table q_x & Sullivan DFLE Formula

Convert observed age-group mortality rates n_m_x into exact interval death probabilities n_q_x = (n*n_m_x)/(1 + n*(1 - n_a_x)*n_m_x) via Chiang (1968) and compute Sullivan healthy person-years.

Read the guide →
Engineering & Science

Child-Langmuir Three-Halves (V^3/2) Space-Charge Current Limit & Perveance

Calculate space-charge-limited electron current density J = 0.002334 * (V^1.5) / (d^2) in mA/cm^2 and diode perveance P = I / V^1.5 for vacuum tubes, X-ray anodes, and ion thruster grids.

Read the guide →
Statistical

Child-Pugh spreadsheet arithmetic with validated inputs and class boundaries

Practice nested IF with a conventional non-cholestatic Child-Pugh scoring example using fictional data and explicit units.

Read the guide →
Engineering & Science

Chirikov Resonance-Overlap Criterion: Hamiltonian Chaos & Standard Map Parameter

Evaluate Boris Chirikov’s resonance-overlap parameter s = (Δω_1 + Δω_2) / Ω_12 and Chirikov-Taylor standard-map stochasticity threshold K_c ≈ 0.9716.

Read the guide →
Electrochemical Engineering, Chlor-Alkali & Industrial Electrolyzers

Chlor-Alkali Membrane Cell NaOH, Cl2 ECU & kWh/Ton Formula

Calculate Daily 100%-Basis Caustic Soda NaOH Production (t/d), Co-Product Chlorine Gas Cl2 (t/d at 0.886 ECU Ratio), Rectifier DC Load (MW), and Specific DC Energy (kWh/t NaOH).

Read the guide →
Statistical

Choose arithmetic, geometric or harmonic means for the right weighting

Compute Geometric Mean PRODUCT(x)^(1/n) for compounded growth factors and Harmonic Mean COUNT(x)/SUM(1/x) for speeds, rates, and P/E multiples.

Read the guide →
Logical decisions

CHOOSE function: switch forecast scenarios with a 1-based selector

Pick the 1st, 2nd, or 3rd assumption cell from a numbered scenario input, and catch out-of-range selector numbers that trigger #VALUE!.

Read the guide →
Dynamic arrays

CHOOSECOLS function: extract, reorder, and pull last columns dynamically

Select non-adjacent columns in any order or reference columns from the right with negative indexes using CHOOSECOLS.

Read the guide →
Dynamic arrays

CHOOSEROWS function: pull specific rows or the latest entry from the bottom

Extract milestone rows by position or fetch the last row of a growing log with CHOOSEROWS and negative row indexes.

Read the guide →
Economic Geography & Urban Systems

Christaller K=3, 4, 7 & Beckmann City-Size Formula

Calculate Walter Christaller’s (1933) hexagonal Central Place market-area hierarchy K^(m - 1) and Martin Beckmann’s (1958) recursive urban system population T_m = (R_1 / (1 - k_srv)) * (K / (1 - k_srv))^(m - 1).

Read the guide →
Engineering & Science

Chun-Seban Falling-Film Evaporator Nusselt Correlation (Wavy vs. Turbulent)

Calculate vertical falling-film evaporator dimensionless Nusselt number Nu_f across wavy-laminar (0.821 * Re_f^-0.22) and turbulent (0.0038 * Re_f^0.4 * Pr^0.65) regimes.

Read the guide →
Engineering & Science

Chung-Lee-Starling Polar & Acentric Gas Viscosity Formula (F_c Shape Factor)

Calculate dilute gas viscosity η = 4.0785 * F_c * SQRT(M * T) / (V_c^(2/3) * Ω_v) (µPa·s) accounting for Pitzer acentricity ω, reduced dipole μ_r, and hydrogen-bonding κ.

Read the guide →
Engineering

Churchill-Bernstein Cylinder Crossflow Nusselt Number Formula

Estimate average Nusselt number and external convection coefficient for a circular cylinder in crossflow, using validated inputs and unrounded intermediate results.

Read the guide →
Engineering & Science

Churchill-Chu Vertical Plate Natural Convection Formula (All Rayleigh Numbers)

Calculate free-convection heat transfer Nu_L = [0.825 + 0.387*Ra^(1/6) / (1 + (0.492/Pr)^(9/16))^(8/27)]^2 across laminar and turbulent buoyancy boundary layers.

Read the guide →
Foundry Metallurgy, Green-Sand Casting Solidification & Shrinkage Riser Design

Chvorinov Sand-Casting Modulus & Riser Sizing Formula

Calculate Casting Cooling Modulus M_c = V/A (cm), Chvorinov Solidification Time t_s = B*(V/A)^n (min), Minimum Blind Cylindrical Riser Diameter D_r = H_r (cm), and Riser Feed Volume (cm³).

Read the guide →
Architectural Illumination & Ergonomics, CIE 117 / EN 12464-1 Unified Glare Rating (UGR)

CIE Unified Glare Rating (UGR) Discomfort Formula

Calculate Single-Luminaire Guth Glare Term (L²*omega/p²), Cumulative Multi-Fixture Glare Sum, CIE 117 Unified Glare Rating UGR, and EN 12464-1 <=19 Office Compliance.

Read the guide →
Econometrics & Omitted-Variable Sensitivity

Cinelli-Hazlett Partial R-Squared and Robustness Value (RV) Formula

Convert any regression t-statistic and degrees of freedom into partial R^2Y~D|X and Cinelli & Hazlett’s (2020) omitted-variable Robustness Value RV_q.

Read the guide →
Engineering & Science

Cipolletti Trapezoidal Weir & Parshall Flume Free-Flow Discharge Formulas

Measure irrigation canal and wastewater plant flow rates (m³/s) with Cesare Cipolletti’s 1H:4V end-contraction-compensated weir Q = 1.859*L*H^1.5 and Ralph Parshall’s throat flume Q = C*H_a^n.

Read the guide →
Healthcare & Clinical

CISNE Score: An Educational Weighted-Flags Example

Add illustrative CISNE component flags with their published weights; the worksheet does not select antibiotics or determine outpatient eligibility.

Read the guide →
Environmental Engineering, Water/Wastewater Clarification & Hydraulics

Clarifier Surface Overflow Rate (SOR) & Weir Loading Formula

Calculate Circular Clarifier Settling Plan Area (ft²), Camp-Hazen Surface Overflow Rate SOR (GPD/ft²), Hydraulic Detention Time HRT (hrs), and Peripheral Weir Overflow Rate (GPD/ft).

Read the guide →
Spatial Statistics & Ecology

Clark-Evans Nearest-Neighbor Dispersion Index (R) and Z-Score

Classify point patterns as Clustered (R < 1), Random Poisson CSR (R = 1), or Regular Lattice (up to R = 2.1491) using Clark and Evans’s (1954) nearest-neighbor formula.

Read the guide →
Supply Chain Operations, Multi-Echelon Inventory & Risk Pooling

Clark-Scarf Echelon Stock & Square-Root Risk-Pooling Formula

Calculate Clark-Scarf Multi-Echelon System Inventory Position (DC_OnHand + In_Transit + Downstream_Store_Stock), Decentralized Store Safety Stock N*z*sigma, Echelon-Pooled Safety Stock SQRT(N)*z*sigma, and Centralization Buffer Savings.

Read the guide →
Quantitative Finance & Forecasting

Clark-West Nested MSPE-Adjusted Test and Out-of-Sample R-Squared

Evaluate nested predictive regressions against a historical-mean or random-walk benchmark using Campbell-Thompson R^2_OS and Clark & West’s (2007) noise-adjusted f_t statistic.

Read the guide →
Transportation Logistics & Operations Research

Clarke-Wright VRP Route Savings s_ij Formula

Calculate Geoff Clarke and John Wright’s (1964) pairwise route-consolidation distance savings s_ij = MAX(0, d_0i + d_0j - d_ij) gated by truck payload capacity Q_veh.

Read the guide →
Statistical

Classify & Flag Scores by Quartile Tier (QUARTILE.INC & IQR)

Calculate inclusive quartile cutoffs and IQR, then classify scores into threshold bands with an explicit policy for ties. Bands do not necessarily contain equal numbers of observations.

Read the guide →
Data Validation & Hygiene

Classify and Count Formula Error Codes (#N/A vs. #DIV/0! and #VALUE) for Workbook QA

Separate benign missing-lookup #N/A flags from severe arithmetic or data-type faults (#DIV/0!, #VALUE) using ISNA and ISERROR priority triage.

Read the guide →
Date & Time

Classify elapsed calendar days into 0–30, 31–60, 61–90 and 91+ buckets

Calculate elapsed days between an onboarding, ticket, or trial start date and a report cutoff date, then map into clean tenure bands via table-driven XLOOKUP.

Read the guide →
Refinery Gas Treating, Sulfur Recovery Units (SRU) & Emissions

Claus Sulfur Recovery Unit (SRU) 1/3 Air Split & Yield Formula

Calculate Exact One-Third H2S Combustion O2 Demand (kmol/hr), Reaction-Furnace Dry Air Rate (kmol/hr), Recovered Liquid Elemental Sulfur (t/d), and Tail-Gas Incinerator SO2 (t/d).

Read the guide →
Engineering

Clausius-Clapeyron Vapor Pressure & Raoult's Law binary mixture formulas

Predict pure-component vapor pressure across temperature via P2 = P1 * EXP((-dHvap/R) * (1/T2 - 1/T1)) and ideal mixture bubble pressure via Raoult's Law.

Read the guide →
Engineering & Science

Clay Primary Consolidation Settlement (Sc) & Terzaghi Time Factor (Tv)

Calculate normally consolidated clay ultimate settlement Sc = (Cc * H0 / (1 + e0)) * LOG10((sigma0 + dsigma) / sigma0) in mm and Terzaghi dimensionless time factor Tv = (cv * t) / Hdr^2.

Read the guide →
Text

Clean and format 10-digit phone numbers with formulas

Strip spaces, parentheses, hyphens, and dots from imported phone strings, validate 10-digit length, and format uniformly.

Read the guide →
Text

CLEAN function: strip line breaks and control characters without fusing words

Remove non-printable ASCII 0-31 characters such as CHAR(10) line feeds with CLEAN, and avoid accidentally joining words across wrapped lines.

Read the guide →
Wholesale Electricity Trading & Carbon Markets

Clean Spark Spread, Clean Dark Spread & Fuel-Switch Formula

Calculate Wholesale Power Gross Spark Spread, Carbon-Adjusted Clean Spark Spread (Gas CCGT) vs Clean Dark Spread (Coal), and the Breakeven Carbon Allowance Fuel-Switching Price.

Read the guide →
Healthcare & Clinical Calculators

CLIF-C ACLF Research: A Logarithmic Spreadsheet Example

Work through the published model expression with fictional inputs and explicit numeric checks.

Read the guide →
Healthcare & Clinical Calculators

CLIF-C AD Research: Corrected Equation and Spreadsheet Example

Explore the corrected CLIF-C acute-decompensation equation, its research population and limitations using hypothetical spreadsheet inputs.

Read the guide →
Healthcare & Clinical

Clinical Frailty Scale: Background, Assessment and Permissions

Learn what the Clinical Frailty Scale is, why assessment needs clinical judgment and where to find the developer’s guidance and permission terms.

Read the guide →
Structured Finance, CLO Securitizations & Cashflow Waterfall Covenants

CLO Overcollateralization (OC), IC Test & Cure Paydown Formula

Calculate Collateralized Loan Obligation (CLO) Tranche Overcollateralization (OC) Ratio, Par Cushion Over Trigger ($M), Interest Coverage (IC) Ratio, and Senior Note Paydown Cure Required via Equity Interest Diversion.

Read the guide →
Business & Operations

Closed Queueing Network Throughput: Zahorjan-Lazowska Balanced Job Bounds (BJB)

Bracket exact Mean-Value-Analysis / Buzen closed-network throughput X(N) for fixed-population pallet loops and database thread pools between tight lower bound N / (D_tot + (N - 1) * D_max) and upper bound MIN(1 / D_max, N / (D_tot + (N - 1) * D_avg)).

Read the guide →
Closed-Die Impression Forging, Automotive Crankshaft/Connecting-Rod Tooling & Flash Design

Closed-Die Forging Flash-Land Factor & Tonnage Formula

Calculate Flash-Land Width-to-Thickness Aspect Ratio w/t, Cavity Multiplying Factor Kf = 3.0 + 1.15*(w/t), Mean Cavity Die Pressure (MPa), and Required Mechanical Press Capacity (metric tons).

Read the guide →