Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Asset Management, Income Investing & 1940-Act Funds

Closed-End Fund NAV Discount & Market Yield Formula

Calculate Closed-End Fund (CEF) Share Price Discount/Premium to NAV (Price - NAV)/NAV, Required Portfolio NAV Distribution Rate vs Amplified Market Distribution Yield, and 1940-Act Structural Leverage Ratio.

Read the guide →
Commercial Mortgage & Fixed-Income Analytics

CMBS Yield Maintenance Prepayment Penalty Formula

Calculate commercial mortgage Yield Maintenance prepayment penalties MAX(Floor * Balance, Balance * (r_note - y_T) * ((1 - (1 + y_T)^(-T)) / y_T)) as Treasury yields move.

Read the guide →
Structural Engineering, TMS 402 Reinforced CMU Masonry Walls & Buckling Slenderness

CMU Masonry Wall Prism Strength & Slenderness Formula

Calculate Masonry Wall Slenderness Ratio h/r, TMS 402 Piecewise Parabolic-to-Euler Buckling Reduction Factor, Nominal Axial Capacity Pn (kN), and LRFD Strength phi*Pn (kN).

Read the guide →
5-Axis CNC Die/Mold Machining & CAM Toolpaths, Ball-Nose Scallop & Effective Diameter

CNC Ball-Nose Scallop Cusp Height & Effective Vc Formula

Calculate 3D Mold Finishing Scallop Cusp Height h (um), Effective Engaged Cutting Diameter Deff (mm), True Cutting Surface Speed Vc,eff (m/min), and % of Nominal Diameter Speed.

Read the guide →
Mechatronics, CNC Linear Motion Axes, Precision Ball Screws & Servo Sizing

CNC Ball-Screw Lead, RPM & Servo Motor Torque Formula

Calculate Peak Rapid-Traverse Ball-Screw Speed (RPM), External Thrust Load Torque T_load (N·m), Double-Nut Preload Drag Torque T_pre (N·m), and Continuous Servo Motor Torque (N·m).

Read the guide →
Automotive Transmission Gear Manufacturing, CNC Cylindrical Gear Hobbing Kinematics

CNC Gear Hobbing Sync RPM, Feed & Cycle Time Formula

Calculate Hob Cutter Spindle Speed (RPM), Electronic-Gearbox Synchronized Worktable Speed (RPM), Axial Saddle Feed Rate (mm/min), and Hobbing Cut Time per Stack (min).

Read the guide →
CNC Machining, High-Efficiency Milling (HEM), Trochoidal Toolpaths & CAM Feeds

CNC Milling Radial Chip-Thinning Factor & MRR Formula

Calculate Spindle Speed N (RPM), Exact Radial Chip-Thinning Compensation Factor RCTF, Compensated Table Feed Rate V_f (mm/min), and Volumetric Material Removal Rate MRR (cm³/min).

Read the guide →
Industrial Organization & Pricing Strategy

Coase Durable-Good Monopoly: Leasing vs Spot Sale Formula

Quantify Ronald Coase’s (1972) durable-good time-inconsistency profit loss by comparing 2-period commitment leasing (1 + delta)*(a^2 / 4) against spot selling a^2 * (2 + delta)^2 / (4 * (4 + delta)).

Read the guide →
Financial

Cobb-Douglas production function (Y = A * K^alpha * L^beta), MPK & MPL

Calculate economic output Y, Marginal Product of Capital (MPK), Marginal Product of Labor (MPL), and Returns to Scale from TFP, Capital, and Labor.

Read the guide →
Operations Research & Queueing Theory

Cobham Non-Preemptive Priority Queue Waiting Formula

Calculate urgent W_q1 = R_0/(1 - rho_1) and routine W_q2 = R_0/((1 - rho_1)*(1 - rho_1 - rho_2)) M/G/1 waits via Alan Cobham’s (1954) priority formula.

Read the guide →
Statistical & Econometric

Cochran-Armitage Trend Test (Z_CA & χ²_trend) for Dose-Response Proportions

Test monotonic dose-response trends across ordered 2×k clinical trial cohorts using the Cochran-Armitage statistic Z_CA = T / SQRT(Var(T)) and 1-df χ²_trend = Z_CA^2.

Read the guide →
Nonparametric Statistics & Clinical Trials

Cochran’s Q Test Formula for Matched Binary Outcomes Across k Conditions

Test whether binary pass/fail proportions differ across three or more matched treatments or raters using Cochran’s (1950) Q statistic and verify unanimous-row invariance.

Read the guide →
Mineral Processing & Tailings Dewatering, Coe & Clevenger (1916) Continuous Thickener Area

Coe-Clevenger Continuous Thickener Area & Solids Flux

Calculate Coe-Clevenger Thickener Clarification Area (m²), Required Circular Tank Diameter (m), Clarified Overflow Water Rate (m³/h), and Daily Solids Loading Flux (t/m²·d).

Read the guide →
Statistical

Coefficient of variation (CV) formula: compare relative volatility across scales

Divide STDEV.S by AVERAGE to measure unit-free relative dispersion across products, portfolios, or sensors with different price scales.

Read the guide →
Food & Beverage Science, SCA Coffee Brewing Control Chart, TDS & Extraction Yield

Coffee TDS, Extraction Yield (EY %) & Brew Ratio Formula

Calculate Pour-Over & Espresso Water-to-Coffee Input Ratio, Spent-Puck Liquid Retained Ratio LRR (g/g), Extracted Coffee Solubles (g), and SCA Extraction Yield EY (%).

Read the guide →
Engineering & Science

Coffin-Manson & Basquin Strain-Life Fatigue Equation + Transition Life (2Nt)

Calculate total strain amplitude delta_epsilon/2 across low-cycle plastic fatigue (Coffin-Manson) and high-cycle elastic fatigue (Basquin), plus the elastic-plastic transition reversals 2Nt.

Read the guide →
Statistical

Cohen's d effect size & Pooled Standard Deviation formula

Calculate a standardized mean difference for two independent groups using a pooled within-group standard deviation.

Read the guide →
Statistical Analysis

Cohen’s h Arcsine Two-Proportion Effect Size & Variance-Stabilized Z-Test

Measure standardized conversion and clinical rate differences across [0, 1] using Jacob Cohen’s arcsine transformation h = 2*ASIN(SQRT(p_1)) - 2*ASIN(SQRT(p_2)).

Read the guide →
Metallurgical Wire & Rod Drawing, Tungsten-Carbide Dies & Capstan Pass Design

Cold Wire-Drawing Reduction, True Strain & Pull Force Formula

Calculate Cross-Sectional Area Reduction r (%), True Logarithmic Strain epsilon = 2*LN(d_0/d_f), Factored Axial Draw Stress sigma_d (MPa), Capstan Pull Force (kN), and Tensile Necking Break Check.

Read the guide →
Industrial Logistics REITs, Cold-Chain Warehousing & Unit Economics

Cold-Storage REIT Pallet Rent, Handling Turns & NOI Formula

Calculate Cold-Storage Warehouse REIT Annual Pallet Storage Revenue ($M), Throughput Handling & Blast-Freezing Revenue ($M), Dual-Segment Facility NOI ($M), and Blended NOI Margin (%).

Read the guide →
Engineering & Science

Colebrook-White Pipe Friction via Serghides’ Steffensen Acceleration (< 0.003% Error)

Solve the implicit Colebrook-White turbulent Darcy friction equation without Goal Seek or circular references using T. K. Serghides’ (1984) 3-step Steffensen Aitken Δ² acceleration.

Read the guide →
AI & Collaboration

Collaborative Budget Variance Triage: @Mentions, Comments & Viewer Release Gate

Flag material department budget variances (> 5%), generate targeted @mention comment prompts for open breaches, and lock executive Viewer sign-off until all blockers resolve.

Read the guide →
Collaboration & Governance

Collaborative Formula-Override Audit with ISFORMULA & Suggest-Mode Governance

Detect accidental literal value pastes over calculated model columns using per-row ISFORMULA flags, pinpoint the first broken line via INDEX/MATCH, and prevent silent overrides with Suggest Mode and @mentions.

Read the guide →
Spreadsheet Auditing & Collaborative Workflows

Collaborative Month-End Close Checklist: Roles, @Mentions, Comments & Sign-Off Gate Formula

Coordinate multi-user month-end close and engineering QA reviews in Arte Sheets using role-based access (owner, contributor, suggester, viewer), threaded cell comments, @mentions, notifications, and automated sign-off readiness formulas.

Read the guide →
Conditional Logic & Validation

Collaborative Spreadsheet Sign-Off: Multi-Reviewer Roles, Suggestions, Comments & Consensus

Coordinate multi-user financial closes and engineering reviews using real-time roles (owner, contributor, suggester, viewer), cell suggestions, threaded comments, @mentions, notifications, and a formula-driven Reviewer Consensus Gate.

Read the guide →
Sports Analytics & Tournament Ranking

Colley Bias-Free Laplace Sports Rating Formula

Calculate Wesley Colley’s Laplace-regularized Strength-of-Schedule team rating r_i = (1 + (W - L)/2 + SUM(r_opp)) / (2 + W + L), Effective Wins W_eff, and Preseason Shrinkage vs Raw Win%.

Read the guide →
Lookup & Reference

COLUMN and COLUMNS: build dynamic horizontal indexes and count table width

Generate auto-incrementing VLOOKUP column numbers across a report with COLUMN or COLUMNS, and count total cells in a 2D block.

Read the guide →
Charts & Visual Data

Column Chart with Target Line & Conditional Above/Below Series Formula

Stage a two-color Column Chart with a constant horizontal Target Line by splitting actual values into mutually exclusive Above-Target and Below-Target helper series.

Read the guide →
Charts & Visual Data

Combination (Combo) Chart & Secondary Axis Scaling Formula: Zero-Baseline Alignment

Combine disparate units like Dollar Revenue Columns and Gross Margin % Lines on a Combo Chart without baseline distortion by computing exact Secondary Y-Axis bounds that lock both primary and secondary zero lines.

Read the guide →
Statistical & Engineering

Combinations Without & With Replacement Formula (COMBIN & COMBINA via FACT)

Calculate distinct k-item subsets without replacement C(n, k) = n! / (k!(n - k)) and multisets with replacement C(n + k - 1, k) using FACT for audit sampling, portfolio pairs, and reliability redundancy.

Read the guide →
Dynamic Arrays

Combine & Reorder Virtual Columns with CHOOSECOLS & HSTACK (Left VLOOKUP)

Assemble custom in-memory lookup tables in any column order—including right-to-left VLOOKUP without physically rearranging worksheet columns—using CHOOSECOLS and HSTACK.

Read the guide →
Data Validation & Cleaning

Combine Duplicate Rows & Sum Values Non-Destructively (UNIQUE, COUNTIF & SUMIFS)

Consolidate repeated SKU or customer line items into one summary row per key while preserving raw transaction audit trails and reconciling grand totals.

Read the guide →
Commercial Equipment Finance, Fleet Leasing & IRC Section 7701(h) TRAC Leases

Commercial Fleet TRAC Lease Terminal Adjustment Formula

Calculate Commercial Truck & Tractor IRC Section 7701(h) TRAC Lease Guaranteed Residual Value ($), Terminal Rental Adjustment Deficiency or Rebate ($), Lessee All-In Net Cash Lease Cost ($), and All-In Cost-to-Capex Ratio.

Read the guide →
Commercial Real Estate Finance, Bifurcated Ground Leases & Leasehold Underwriting

Commercial Ground Lease CPI-Collared Reset & Coverage Formula

Calculate 99-Year Bifurcated Commercial Ground Lease CPI-Collared Periodic Rent Reset ($M), Residual Leasehold Net Operating Income ($M), Senior Ground-Rent Coverage Ratio, and Ground Rent % of Property NOI.

Read the guide →
Commercial Real Estate & Property Accounting

Commercial Lease CAM Gross-Up & Expense-Stop Formula

Gross up occupancy-sensitive variable operating expenses Var_OpEx * MAX(1, GrossUp_Cap / Actual_Occ) without inflating fixed costs, and compute pro-rata tenant expense-stop recoveries.

Read the guide →
Commercial Real Estate & Leasing

Commercial Lease TI, Free Rent & Net Effective Rent Formula

Calculate ASC 842 Straight-Line Effective Rent, Unamortized Landlord Net Effective Rent (NER), and Time-Value-Discounted Landlord NER ($/SF/yr) after Tenant Improvements, Free Rent, and Commissions.

Read the guide →
Commercial Property Insurance, Risk Management, Underinsurance Audits & CPCU Claims

Commercial Property Coinsurance Penalty ("Did/Should") Formula

Calculate Required Coinsurance Limit ("Should Have"), Coinsurance Compliance Ratio MIN(1, Did/Should), Net Insurer Claim Recovery After Deductible, and Uninsured Coinsurance Penalty Haircut.

Read the guide →
Financial

Compare compounding periods: Annual, Quarterly, Monthly, Daily, and Continuous

See exact dollar differences across compounding frequencies m = 1, 4, 12, 365 using P*(1 + r/m)^(m*t) alongside the continuous limit P*EXP(r*t).

Read the guide →
Financial

Compare loans with different durations: monthly payment vs total interest

Evaluate 36-, 48-, 60-, and 72-month loan offers side by side by contrasting lower monthly payments against total lifetime interest paid.

Read the guide →
Statistical

Compare two columns row by row: count matches, mismatches, and accuracy %

Audit parallel Ordered vs Shipped or Forecast vs Actual columns row-for-row using SUMPRODUCT without helper columns.

Read the guide →
Lookup & Reference

Compare Two Lists: Count Shared Matches & Return First Overlap

Compare text identifiers using row membership, a separate distinct-item count and the first shared value in List1 order.

Read the guide →
Logical

Compare two tables or columns cell-by-cell for differences (audit & reconciliation)

Count value differences between aligned snapshots and list the old record IDs for rows containing a difference.

Read the guide →
Healthcare & Clinical

Comparing Karnofsky and ECOG Performance Scales

Explore one published KPS–ECOG comparison table and its limitations; the mapping does not replace an individual clinical assessment.

Read the guide →
Engineering & Scientific

Complex Cotangent, Secant & Cosecant Formulas (IMCOT, IMSEC & IMCSC)

Evaluate complex reciprocal trigonometric functions cot(z), sec(z), and csc(z) for lossy RF transmission-line stubs and waveguide impedances using exact conjugate denominator rationalization.

Read the guide →
Math & Engineering

Complex Number & AC Phasor Math: Magnitude, Phase, Multiply & Divide

Model complex impedances and AC phasors a + bi in numeric Real and Imaginary columns to compute modulus (IMABS), phase angle in degrees (IMARGUMENT), complex multiplication (IMPRODUCT), and rationalized division (IMDIV).

Read the guide →
Engineering

Complex Polar Powers, Square Roots, Exponentials, and Natural Logs (IMPOWER, IMSQRT, IMEXP & IMLN)

Compute numeric real and imaginary parts of z^n, sqrt(z), exp(z), and ln(z) using De Moivre's theorem and Euler's formula with ATAN2, COS, SIN, EXP, and LN.

Read the guide →
Engineering & Science

Composite Lamina Rule of Mixtures (Voigt / Reuss) & Halpin-Tsai Transverse Modulus

Calculate longitudinal stiffness E1 via the Voigt iso-strain rule of mixtures and transverse stiffness E2 via both the Reuss iso-stress lower bound and the semi-empirical Halpin-Tsai micromechanics equation.

Read the guide →
Structural Steel Design, AISC 360 Composite Floor Beams & Shear Studs

Composite Steel-Concrete Beam Shear Stud Count Formula

Calculate Governing Horizontal Interface Shear V_prime (kN) between Midspan & Support, Concrete Slab Compression Depth a (mm), Studs Required per Half-Span, and Total Full-Span Studs.

Read the guide →
Financial

Compound interest formula: project lump-sum growth across any compounding frequency

Calculate ending balance P * (1 + r/m)^(m*t) and total interest earned for annual, quarterly, monthly, or daily compounding.

Read the guide →
Logical & Conditional Formulas

Compound Logic: IF Cell Is (X or Y) and Z (Nested AND + OR Rebate Gate)

Evaluate compound business eligibility rules—such as Tier is ("Gold" OR "Platinum") AND Status is "Active" AND Spend >= 1,000—without operator-precedence bugs.

Read the guide →