Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Lookup & Reference

Calculate Letter Grades (A+ to F) from Numeric Scores (XLOOKUP & VLOOKUP)

Assign A+ through F using an editable illustrative plus/minus scale, validate scores and cutoffs, and compare XLOOKUP with ascending-table VLOOKUP.

Read the guide →
Financial

Calculate loan interest and principal paid in any given year (closed-form FV)

Estimate interest and principal during a selected full 12-month loan year using PMT and FV.

Read the guide →
Statistical

Calculate Midrange and Tukey Trimean: extreme vs outlier-resistant centers

Compute the Midrange (MIN + MAX) / 2 and contrast it with Tukey's outlier-resistant Trimean (Q1 + 2*Median + Q3) / 4.

Read the guide →
Financial

Calculate monthly savings needed to reach a financial goal (PMT)

Pass GoalAmount as the 4th fv argument of PMT (with existing savings as negative pv) to solve required monthly contributions.

Read the guide →
Financial & Accounting

Calculate Original Loan Amount & Borrowing Limit from Monthly Payment (PV)

Back-solve the original loan principal or maximum affordable loan balance from a fixed periodic payment, annual interest rate, and term in months using PV.

Read the guide →
Math & Statistical

Calculate Percent Absent & Attendance Rate Ignoring Unmarked Days

Compute exact student or employee absence percentage COUNTIF(B2:G2, "A") / COUNTA(B2:G2) and present/excused attendance rate while ignoring blank unrecorded future sessions.

Read the guide →
Date & Time

Calculate percent of year complete (leap-year exact pacing)

Divide ordinal day-of-year by exact calendar days in that year (365 or 366) to benchmark annual quota and budget pacing.

Read the guide →
Statistical

Calculate quintiles (20%, 40%, 60%, 80%) and assign 1–5 quintile buckets

Compute percentile cutoffs and assign values to five threshold-based bands.

Read the guide →
Date & Time

Calculate retirement, benefit eligibility, and equity cliff dates (EDATE & EOMONTH)

Calculate illustrative age milestones and month-based waiting dates with explicit calendar conventions.

Read the guide →
Statistical

Calculate RMSE and MSE: Root Mean Squared Error forecast accuracy formula

Score demand and revenue forecasts in a single formula without helper columns using SQRT(SUMPRODUCT((Actual - Forecast)^2) / ROWS(Actual)).

Read the guide →
Financial

Calculate sales commission: flat-tier IFS vs marginal progressive brackets

Implement both retroactive flat-rate commission tiers with IFS and cliff-free marginal bracket commissions with MIN and MAX.

Read the guide →
Date & Time

Calculate stopped dwell time from a fleet GPS timestamp & milepost log

Estimate time in unchanged-location intervals from an ordered timestamp and milepost log, with explicit sampling assumptions.

Read the guide →
Statistics

Calculate Student & Workforce Absence Rate (%) & Chronic Absence Flag

Calculate absence rates from validated P, T, A and E codes, distinguish missing records from zero absence, and compare a recorded-period rate with an illustrative threshold.

Read the guide →
Date & Time

Calculate the Nth or last weekday of a month

Build a recurring monthly schedule and detect when a requested fifth weekday does not exist.

Read the guide →
Financial

Calculate VAT or sales tax: add tax to net and reverse gross to net

Compute tax-inclusive gross prices from net amounts and extract exact embedded VAT and net revenue from tax-inclusive totals.

Read the guide →
Statistical

Calculate win, loss, and tie totals (plus win % and league points)

Summarize raw match scores into Wins, Losses, Ties, Win Percentage, and 3-1-0 league points while ignoring unplayed fixtures.

Read the guide →
Charts & Data Visualization

Calculation of Pi in Spreadsheets: Unit-Circle Scatter Dartboard & Archimedes Bounds

Approximate Pi visually using a Monte Carlo unit-quarter-circle scatter indicator (X^2 + Y^2 <= 1 -> Pi_hat = 4 * Hits / N) and bound Pi deterministically via Archimedes’ inscribed/circumscribed regular N-gon perimeters.

Read the guide →
Civil, Structural & Geotechnical Engineering

California Bearing Ratio (CBR) & Subgrade Resilient Modulus M_R Formula (ASTM D1883)

Calculate ASTM D1883 California Bearing Ratio CBR (%) at 0.10-in (1,000 psi standard crushed rock) and 0.20-in (1,500 psi) piston penetrations, and convert CBR into AASHTO MEPDG Subgrade Resilient Modulus M_R = 2555 * CBR^0.64.

Read the guide →
Industrial Instrumentation, Metrology & Process Control

Callendar-Van Dusen Pt100 RTD Resistance Formula

Calculate IEC 60751 Platinum RTD Resistance R(T) = R_0 * (1 + A*T + B*T^2) for T >= 0 °C, compare against Naive Linear Alpha (0.00385/°C) Approximation, and quantify Uncalibrated Temperature Drift (°C).

Read the guide →
Financial

Calmar-style return/drawdown ratio and a CAPM excess-return worksheet

Compare a supplied annualized return with observed maximum drawdown and calculate a same-period return residual against a supplied CAPM beta.

Read the guide →
Oncology Pharmacy & Clinical Pharmacokinetics

Calvert Carboplatin Research and Capped Inputs: A Spreadsheet Exercise

Understand the context of Calvert carboplatin research and practice a separate, fictional capped-input calculation.

Read the guide →
Macroeconomics & DSGE Modeling

Calvo Staggered Pricing & New Keynesian Phillips Curve Slope

Derive mean price duration 1/(1 - theta), structural NKPC marginal-cost slope kappa = (1 - theta)*(1 - beta*theta)/theta, and quarterly inflation pi_t.

Read the guide →
Emerging Markets & Open-Economy Macroeconomics

Calvo Sudden-Stop Absorption Cut & RER Jump Formula

Calculate Guillermo Calvo’s (1998, 2004) sudden-stop Tradable Absorption Contraction CAD / omega_T and required Real Exchange Rate Depreciation (1 - CAD / omega_T)^(-1 / xi) - 1.

Read the guide →
Water Treatment Engineering, Rapid Mix & Tapered Flocculation

Camp-Stein Velocity Gradient (G) & Camp Number (Gt) Formula

Calculate Flocculation Basin RMS Velocity Gradient G (s^-1), Detention Time t (seconds), Dimensionless Camp Number G*t, and Specific Mixing Power Input (W/m³).

Read the guide →
Quantitative Finance

Campbell-Shiller CAPE Ratio & Excess CAPE Yield (ECY) Formula

Calculate the 10-year inflation-adjusted Cyclically Adjusted P/E ratio CAPE = Real_Price / AVERAGE(Real_EPS_10y) and Shiller’s Excess CAPE Yield ECY = (1 / CAPE) - Real_10Y_Bond_Yield.

Read the guide →
Quantitative Finance & Forecasting

Campbell-Thompson Out-of-Sample R-Squared and Truncated Forecast

Compute Campbell and Thompson’s (2008) out-of-sample R^2_OS = 1 - SSE_model / SSE_hist and verify how zero-truncating negative risk-premium forecasts MAX(0, r_hat) turns negative R^2_OS positive.

Read the guide →
Healthcare & Clinical

Canadian C-Spine Rule Research and a Nested IF Example

Review the scope of the Canadian C-Spine Rule study and learn sequential spreadsheet branching with fictional flags.

Read the guide →
Healthcare & Clinical

Canadian CT Head Rule Research and Binary Flag Counting

Understand the scope of the Canadian CT Head Rule research and practice counting fictional binary flags in a spreadsheet.

Read the guide →
Meteorology, Occupational Hygiene & Environment Canada Humidex

Canadian Humidex Vapor Pressure & Thermal Discomfort Formula

Calculate Environment and Climate Change Canada (MSC) Actual Water Vapor Pressure e (hPa) from Dew Point via Clausius-Clapeyron, Humidex Increment h = 0.5555*(e - 10), Total Humidex Score, and MSC Public Heat-Advisory Tier.

Read the guide →
Financial & Accounting

Candlestick (OHLC) Chart Formula: Real Body, Upper & Lower Wicks & Doji Body Ratio

Validate Open-High-Low-Close (OHLC) price bars and compute Candlestick Real Body = Close - Open, Upper Shadow = High - MAX(Open, Close), Lower Shadow = MIN(Open, Close) - Low, and Body-to-Range ratio.

Read the guide →
Engineering

Cantilever Beam Tip Deflection, Rotation Angle & Root Bending Stress

Calculate Euler-Bernoulli cantilever beam tip deflection delta = F*L^3 / (3*E*I), end slope theta = F*L^2 / (2*E*I), and fixed-wall bending stress sigma = F*L*c / I.

Read the guide →
Geotechnical Excavation Support, USACE Cantilever Steel Sheet-Pile Wall Mechanics

Cantilever Sheet-Pile Zero-Pressure Depth & Moment Formula

Calculate Rankine Active Ka & Passive Kp Earth Coefficients, Zero-Net-Pressure Depth z0 Below Dredge Line (m), and Active Wedge Overturning Moment at z0 (kN·m/m).

Read the guide →
Math

Cap & Floor Collar: Clamp Numbers Between Min & Max Bounds (MIN & MAX)

Clamp a numeric value to an ordered lower and upper bound using MIN/MAX or MEDIAN, with the same validation for both methods.

Read the guide →
Math & Trig

Cap percentages between 0% and 100% (clamping with MEDIAN)

Clamp attainment and completion ratios cleanly between a lower floor and upper cap in one readable formula with MEDIAN(0, 1, Ratio).

Read the guide →
Financial

Cap Rate, Net Operating Income (NOI) & Gross Rent Multiplier (GRM)

Calculate simplified annual rental NOI, cap rate, gross rent multiplier, expense ratio and a direct-capitalization scenario from consistent assumptions.

Read the guide →
Vacuum & Torch Brazing Metallurgy, AWS C3.4 Capillary Joint Overlap & Wicking Rise

Capillary Brazing Joint Overlap & Wicking Rise Formula

Calculate AWS Required Braze Overlap Length (mm), Overlap-to-Thickness Ratio (L/t), Molten Filler Capillary Suction Pressure (kPa), and Vertical Wicking Height (mm).

Read the guide →
Engineering & Science

Capillary Number (Ca) & Bond / Eötvös Number (Bo) Interfacial Scaling

Calculate the viscous-to-interfacial Capillary Number Ca = (mu * U) / sigma and buoyancy-to-capillary Bond (Eötvös) Number Bo = (delta_rho * g * L^2) / sigma for microfluidics, droplets, and enhanced oil recovery.

Read the guide →
Text

Capitalize only the first letter of a cell (sentence case)

Capitalize the first character and lowercase the rest of a short text label; preserve empty inputs with a blank guard.

Read the guide →
Agricultural Phenology & Crop Modeling

Capped Growing Degree Days (GDD) Maturity Formula

Calculate USDA / NOAA Modified Capped Growing Degree Days MAX(0, (MIN(T_max, T_upper) + MAX(T_min, T_base))/2 - T_base), Uncapped Bias, Remaining Thermal Units, and Days to Harvest.

Read the guide →
Healthcare & Clinical

Caprini VTE Score: An Educational Weighted-Count Example

Practice adding age points and fictional weighted factor counts; the worksheet does not assess a patient or choose thrombosis prophylaxis.

Read the guide →
Mechanical Design & Power Transmission

Capstan and Flat-Belt Friction Formula (Euler-Eytelwein Equation)

Calculate exponential capstan holding-force multiplication EXP(mu * theta_rad) and maximum slip-free flat-belt transmitted power P_kW = (T_1 - T_2) * v / 1000.

Read the guide →
Civil, Structural & Geotechnical Engineering

Caquot-Kerisel Log-Spiral Passive Earth Pressure (K_p) Formula vs Planar Coulomb Error

Calculate safe horizontal passive earth pressure coefficient K_p,h under wall-soil interface friction delta using Albert Caquot & Jean Kerisel’s (1948) / Eurocode 7 curved logarithmic-spiral slip surface, avoiding Coulomb’s dangerous overprediction.

Read the guide →
Operations, Logistics & Engineering

Carberry Number (Ca) Formula: Observable External Film Mass-Transfer Check in Catalysis

Diagnose external boundary-layer film diffusion falsification in packed-bed catalytic reactors using James J. Carberry’s observable number Ca = R_obs / (k_g * a_p * C_b) and Mears’s < 5% criterion n * Ca < 0.05.

Read the guide →
Engineering

Carnot Efficiency & Stefan-Boltzmann Thermal Radiation formulas (Kelvin)

Calculate a two-reservoir Carnot bound and gray-surface radiation to large isothermal surroundings using absolute temperatures.

Read the guide →
Engineering & Science

Carothers Equation: Step-Growth Polymerization Degree (Xn, Xw) & Stoichiometric Ratio (r)

Calculate number-average degree of polymerization Xn = (1 + r) / (1 + r - 2*r*p), weight-average Xw = (1 + p) / (1 - p), and Flory polydispersity PDI = 1 + p in nylon and polyester synthesis.

Read the guide →
Geotechnical Dewatering & Slope Stabilization, Casagrande Electro-Osmosis in Soft Clays

Casagrande Electro-Osmotic Clay Dewatering & Power Formula

Calculate Electric Voltage Gradient ie = V/L (V/m), Electro-Osmotic Cathode Water Flow Qe (L/h), DC Rectifier Ohmic Power (kW), and Specific Dewatering Energy (kWh/m³).

Read the guide →
Engineering & Fluid Mechanics

Casagrande Plasticity Chart (USCS) Formula: Atterberg Plasticity Index & A-Line Soil Symbol

Classify fine-grained soils into USCS Clay vs. Silt (CL, CH, ML, MH) using Arthur Casagrande’s Plasticity Index PI = LL - PL, A-line PI_A = 0.73 * (LL - 20), and LL = 50% compressibility boundary.

Read the guide →
Lookup & Reference

Cascading Lookup Across 2 Lookup Tables (XLOOKUP if_not_found & IFNA)

Search a Primary Domestic Catalog first and automatically fall back to a Secondary International/Archive Catalog when missing using XLOOKUP's 4th [if_not_found] argument.

Read the guide →
Text Functions

Case-Sensitive Cell Count & Substring Count (EXACT & FIND)

Count exact uppercase/lowercase matches and case-sensitive substrings where COUNTIF ignores letter case, using row-level --EXACT(A2, $E$2) and --ISNUMBER(FIND($E$3, A2)) helper columns.

Read the guide →
Lookup & Reference

Case-sensitive FILTER, SUM & COUNT using an EXACT helper flag

Use per-row EXACT flags to distinguish case variants, count matching records and sum their numeric amounts.

Read the guide →