Learn one useful thing today.
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 →StatisticalCoefficient 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 YieldCoffee 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 & ScienceCoffin-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 →StatisticalCohen'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 AnalysisCohen’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 DesignCold 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 EconomicsCold-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 & ScienceColebrook-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 & CollaborationCollaborative 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 & GovernanceCollaborative 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 WorkflowsCollaborative 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 & ValidationCollaborative 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 RankingColley 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 & ReferenceCOLUMN 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 DataColumn 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 DataCombination (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 & EngineeringCombinations 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 ArraysCombine & 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 & CleaningCombine 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 LeasesCommercial 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 UnderwritingCommercial 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 AccountingCommercial 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 & LeasingCommercial 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 ClaimsCommercial 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 →FinancialCompare 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 →FinancialCompare 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 →StatisticalCompare 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 & ReferenceCompare 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 →LogicalCompare 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 →Engineering & ScientificComplex 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 & EngineeringComplex 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 →EngineeringComplex 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 & ScienceComposite 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 StudsComposite 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 →FinancialCompound 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 FormulasCompound 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 →Industrial Compressed Air Systems, Pneumatic Buffer Receivers & Plant UtilitiesCompressed Air Receiver Drawdown Time & Tank Volume Formula
Calculate Usable Free-Air-Delivery Buffer Capacity V_FAD (m³), Net Surge Deficit Rate (m³/min FAD), Actuator Hold-Up Time Before Minimum Pressure (s), and Receiver Volume Required for a 3-Minute Surge (m³).
Read the guide →Plant Energy Audits, Compressed-Air Systems & Choked Sonic FlowCompressed-Air Orifice Leak SCFM & Annual kWh Waste Formula
Calculate Sonic Choked Compressed-Air Orifice Leak Flow (SCFM), Continuous Wasted Compressor Power (kW), Annual Electricity Waste (kWh/yr), and Annual Leak Cost ($/yr).
Read the guide →ScienceCompton Scattered Photon Energy, Compton Edge & Electron Recoil
Calculate scattered gamma-ray photon energy E' = E_0 / (1 + (E_0 / 511) * (1 - COS(RADIANS(theta)))), recoil kinetic energy T_e = E_0 - E', and the 180-degree Compton Edge in keV.
Read the guide →Cleaning imported dataCONCAT function: join cells and ranges when no separator is needed
Assemble compact tracking codes across cells or whole ranges with CONCAT, and know when delimiter-aware TEXTJOIN is the safer choice.
Read the guide →TextConcatenate IF: join matching rows into a comma-separated list
Combine TEXTJOIN and FILTER to roll up every name or SKU matching a category into one clean comma-separated cell.
Read the guide →Concrete Technology, ACI 211.1 Batch Mix Proportioning & Ready-Mix Quality ControlConcrete Abrams Water-Cement Ratio & Batch Yield Formula
Calculate Water-to-Cement Ratio w/c, Abrams Exponential 28-Day Cylinder Strength f'_c (MPa), Air-Free Solid+Water Volume (m³), and Air-Adjusted Batch Yield (m³).
Read the guide →EngineeringConcrete calculator formula: Cubic Yards (with waste %) & 80-lb bag count
Convert Length (ft) × Width (ft) × Thickness (inches) into ready-mix Cubic Yards and pre-mix 80-lb / 60-lb bag counts.
Read the guide →Industrial Steam Systems, Condensate Flash Tanks & Plant Energy EfficiencyCondensate Flash Steam Percentage & Heat Recovery Formula
Calculate Thermodynamic Flash Steam Mass Percentage (%Flash), Recovered Low-Pressure Flash Steam Flow (kg/hr), Recovered Latent Thermal Power (kW), and Gross Boiler Fuel Input Saved (kW).
Read the guide →Text FunctionsConditional Alert Messages & 5-Star Rating Displays with REPT
Display conditional status badges without IF using REPT("ALERT", --(Condition)) and render 5-slot star or block rating bars REPT("*", Score) & REPT("-", 5 - Score).
Read the guide →Statistical & Conditional CountingConditional Average with OR Criteria & Calculated Arrays (AVERAGE + FILTER)
Calculate conditional averages when AVERAGEIFS falls short—such as OR conditions across regions or row-level gross margin percentages computed on the fly without a helper column.
Read the guide →Lookup & Dynamic ArraysConditional Count with a Dynamic Selectable Column (CHOOSECOLS & MATCH)
Count rows meeting both a row category filter and a threshold on a user-selected metric column using CHOOSECOLS, MATCH, and SUMPRODUCT without hardcoding separate formulas per quarter.
Read the guide →Conditional Logic & ValidationConditional Formatting Based on XLOOKUP or VLOOKUP Result Across a Reference Table
Highlight order rows dynamically without adding clutter columns by writing an XLOOKUP (or IFNA + VLOOKUP) conditional-formatting rule that checks credit-hold or recall status in a master vendor/SKU table.
Read the guide →Dates, Time & SchedulesConditional Formatting for Dates: Blank-Safe Overdue, Due in 7 Days & Valid Date Checks
Prevent blank cells from lighting up red as "1900-01-00 Overdue" by pairing ISNUMBER($B2) with an explicit reference date $E$2 to classify Overdue, Due Within 7 Days, and Scheduled items.
Read the guide →