Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Industrial Compressed Air Systems, Pneumatic Buffer Receivers & Plant Utilities

Compressed 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 Flow

Compressed-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 →
Science

Compton 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 data

CONCAT 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 →
Text

Concatenate 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 Control

Concrete 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 →
Engineering

Concrete 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 Efficiency

Condensate 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 Functions

Conditional 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 Counting

Conditional 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 Arrays

Conditional 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 & Validation

Conditional 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 & Schedules

Conditional 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 →
Conditional Formatting & Rules

Conditional Formatting Formula: Flag Past-Due Open Invoices & Missing Required Fields

Write row-level AND($C2 <> "Paid", $B2 < $G$2) rules that highlight overdue invoices without false-flagging settled rows or blank rows.

Read the guide →
Text, Cleaning & Extraction

Conditional Formatting If Cell Contains Specific Text, Any Text, or Not Equal

Write bullet-proof text conditional-formatting formulas: =ISNUMBER(SEARCH("urgent", $B2)) for case-insensitive substring highlights, =ISNUMBER(FIND("URGENT", $B2)) for exact-case tokens, and =AND(ISTEXT($B2), LEN(TRIM($B2))>0) for non-blank text.

Read the guide →
Conditional Logic & Validation

Conditional Formatting: Highlight an Entire Row or Column Based on Another Cell ($C2 vs C$2)

Master mixed cell references in custom conditional-formatting rules: lock the column ($C2="Overdue") to highlight an entire row across A2:E20, or lock the row (B$2="Blocked") to highlight an entire column.

Read the guide →
Statistical

Conditional MEDIAN and MODE (MEDIANIFS / MODEIFS with FILTER)

Nest FILTER inside MEDIAN and MODE.SNGL to calculate outlier-resistant group medians and most-common values without helper columns.

Read the guide →
Dynamic Arrays

Conditional Mode: Most Frequent Value with Criteria (MODE.SNGL & FILTER)

Find the most common price point, defect code, or ticket response time within a specific department or region using IFERROR(MODE.SNGL(FILTER(values, criteria)), "No Repeating Mode").

Read the guide →
Statistical

Conditional Percentile (PERCENTILE IF) with FILTER for P90 SLA and pay bands

Calculate P90, P75, or P25 percentiles for a specific department, region, or service tier by nesting FILTER inside PERCENTILE.INC.

Read the guide →
Decision Science, Governance & Ensemble ML

Condorcet Jury Theorem Majority Accuracy Formula

Calculate majority-vote accuracy for 3-, 5-, and 7-member independent committees/ensembles and verify Marquis de Condorcet’s (1785) p < 0.50 crowd-degradation trap.

Read the guide →
Aggregate Quarry & Mineral Comminution, Symons / Hydrocone Parallel-Zone Kinematics

Cone Crusher CSS, Eccentric Throw & Parallel-Zone Capacity

Calculate Open-Side Setting OSS (mm), Gravity Free-Fall Drop Per Half-Cycle (mm), Parallel-Zone Compression Hits, and Choke-Fed Volumetric Throughput (t/h).

Read the guide →
Statistical

Confidence interval for a mean with known population standard deviation

Calculate a normal-theory confidence interval with known population SD: standard error sigma/SQRT(n), margin Z*SE, and lower/upper bounds.

Read the guide →
Statistical & Clinical Analysis

Conger’s Multi-Rater Generalized Kappa (κ_C): Rater-Specific Marginal Agreement

Calculate Anthony Conger’s (1980) exact multi-rater kappa κ_C = (P_o - P_e,C) / (1 - P_e,C) across fixed raters with distinct positive-call rates—and contrast against Fleiss pooled P_e.

Read the guide →
Clinical Medicine & Physiology

Conicity Index and Waist-to-Height Ratio: Two Spreadsheet Examples

Calculate Valdez’s conicity index and waist-to-height ratio from consistent units, with clear distinctions between geometric models and health guidance.

Read the guide →
Product Pricing Research & Discrete Choice Econometrics

Conjoint Part-Worth & Multinomial Logit Share Formula

Calculate Conjoint Net Part-Worth Utility U_A = alpha_A - beta * Price_A, McFadden Multinomial Logit (MNL) Choice Shares EXP(U_i) / SUM(EXP(U_j)), and IIA Relative Odds Ratio EXP(U_A - U_B).

Read the guide →
Construction Accounting, Miller Act Surety Bonding & Bid Estimating

Construction Surety Sliding-Scale Bond & Capacity Formula

Calculate Commercial / Public-Works Miller Act Performance & Payment Surety Bond Tiered Sliding-Scale Premium ($), Effective Blended Bond Rate, Working-Capital Aggregate Bonding Capacity ($), and Remaining Unbonded Backlog Headroom.

Read the guide →
Construction Accounting & Surety Job Costing

Construction WIP Overbilling & Retainage Formula

Calculate Cost-to-Cost Earned WIP Revenue, Overbilling Liability vs Underbilling Asset (Billings - Earned Revenue), Collectible Cash Net of Retainage Holdback, and Net Job Cashflow.

Read the guide →
Inorganic Chemical Manufacturing, Sulfuric Acid & Emissions Control

Contact Process Sulfuric Acid (DCDA) Tonnage & SO2 Slip Formula

Calculate Sulfur-Burner SO2 Generated (t/d), 100%-Basis H2SO4 Equivalent (t/d), Commercial 98 wt% Acid Output (t/d), and Unconverted Stack SO2 Emissions (t/d).

Read the guide →
Container Liner Shipping & Maritime Finance

Container BAF Surcharge & TEU Slot Break-Even Formula

Calculate IMO-2020 Floating Bunker Adjustment Factor BAF = MAX(0, P_fuel - P_base) * Trade_Factor, All-In TEU Freight Rate, Breakeven Loaded TEUs, and Vessel Slot Utilization.

Read the guide →
Railway Track Infrastructure, AREMA Continuous Welded Rail (CWR) Thermal Buckling

Continuous Welded Rail (CWR) Neutral Temp & Buckling Force

Calculate Rail Temperature Excursion Above Neutral (°C), Constrained Axial Thermal Stress (MPa), Single-Rail Axial Force (kN), and Two-Rail Track Panel Force (kN).

Read the guide →
Financial

Contribution Margin CM1, CM2, and CM3 formulas (e-commerce unit economics)

Build an illustrative per-order contribution waterfall from net revenue through product, fulfillment, payment and advertising costs.

Read the guide →
Statistical & Clinical Analysis

CONUT laboratory score: component arithmetic and limitations

Explore the historical CONUT point system using albumin, absolute lymphocyte count and total cholesterol, with explicit units and limitations.

Read the guide →
Deep Foundations, Bridge Pier Pile Caps & Soil Stress Overlap

Converse-Labarre Friction Pile Group Efficiency Formula

Calculate Stress-Shadow Angle theta (deg), Converse-Labarre Group Efficiency eta_g (%), Unfactored Sum of Single Piles (kN), and Interaction-Reduced Group Ultimate Capacity (kN).

Read the guide →
Date & Time

Convert a fixed-format UTC timestamp with an explicit hour offset

Parse YYYY-MM-DDTHH:MM:SSZ timestamps and apply a supplied fixed UTC offset. Named-zone and daylight-saving rules are not inferred.

Read the guide →
Financial

Convert Budget Amounts Between Daily, Weekly, Monthly and Annual Units

Compare recurring amounts using an explicit periods-per-year table. Calculate planning equivalents, not calendar-accurate payment dates or payroll entitlements.

Read the guide →
Engineering

Convert cm to inches, kg to lbs, and km to miles (exact NIST constants)

Translate metric and imperial length and weight columns with exact international definition constants—compatible across every spreadsheet engine.

Read the guide →
Lookup & Reference

Convert column number to letter (and back) with ADDRESS and COLUMN

Translate 1-based column numbers like 1, 26, 27, and 53 into A, Z, AA, and BA using ADDRESS and SUBSTITUTE—and reverse the conversion with COLUMN.

Read the guide →
Date & Time

Convert Compact HHMMSS Timestamps (91500 or 144530) Into Time & Duration

Parse colon-free 6-digit HHMMSS log integers—even when CSV import strips leading zeros from 091500 to 91500—using TIME(INT(x/10000), MOD(INT(x/100),100), MOD(x,100)).

Read the guide →
Date & Time

Convert date to Julian day of year (1–366 and YYYYDDD) and back

Calculate the ordinal day of the year with Date - DATE(YEAR(Date), 1, 0), format 7-digit YYYYDDD codes, and parse them back.

Read the guide →
Date & Time

Convert DD/MM/YYYY text strings to real spreadsheet dates without locale bugs

Parse slash-separated DD/MM/YYYY text of variable digit width using DATE, TEXTBEFORE, and TEXTAFTER so days and months never swap.

Read the guide →
Engineering & Number Systems

Convert Decimal Bytes (0–255) To & From Hexadecimal and Octal (Positional Radix Math)

Convert 8-bit RGB channels, register bytes, and permissions between Decimal, 2-digit Hexadecimal, and 3-digit Octal using positional INT, MOD, MID, and FIND.

Read the guide →
Date & Time

Convert decimal hours, minutes, or seconds to spreadsheet time (and back)

Divide decimal hours by 24, minutes by 1440, or seconds by 86400 to build valid time values—and multiply by 24 for payroll.

Read the guide →
Text

Convert feet and inches text (5' 10") to total inches and back

Parse architectural measurement strings like 5' 10" into numeric inches with TEXTBEFORE and TEXTAFTER, and format inches back.

Read the guide →
Engineering

CONVERT function: translate weight, distance, and temperature units accurately

Convert engineering and logistics measurements between metric and imperial unit codes with CONVERT.

Read the guide →
Text

Convert letters to numbers (A=1 to Z=26 and phone keypad digits)

Map letters A–Z to 1–26 using CODE(UPPER(ch)) - 64, convert 1–26 back to letters with CHAR(n + 64), or map letters to T9 phone digits.

Read the guide →
Date & Time

Convert month name ("April" or "Apr") to month number (1–12)

Match the first 3 letters of any English month name against a 12-month array constant in XMATCH for locale-independent 1–12 numbers.

Read the guide →
Math

Convert negative numbers to zero (and clamp values between Min and Max)

Replace verbose IF(x<0, 0, x) formulas with MAX(0, x) for zero floors and MEDIAN(Min, x, Max) for two-sided caps.

Read the guide →
Logical & Lookup Formulas

Convert Numbers to 1 or 0 Binary Flags (--(B2>0), SIGN & SUMPRODUCT)

Transform arbitrary revenue, usage, or inventory quantities into clean 1/0 binary indicator variables using double-unary --(B2 > 0) and tally active periods across rows with SUMPRODUCT.

Read the guide →
Text

Convert numbers to text: preserve leading zeros and fixed formats with TEXT

Format numeric IDs, dates, and currency amounts as text strings with TEXT when building codes or labels.

Read the guide →
Math & Everyday Calculations

Convert Pounds (lb) to Kilograms (kg), Stones & Compound lb + oz Formula

Convert avoirdupois pounds to exact kilograms (* 0.45359237), kilograms back to pounds (/ 0.45359237), UK stones + pounds, and postal pounds + ounces using pure arithmetic that works in every spreadsheet.

Read the guide →