Learn one useful thing today.
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 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 →Conditional Formatting & RulesConditional 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 & ExtractionConditional 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 & ValidationConditional 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 →StatisticalConditional 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 ArraysConditional 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 →StatisticalConditional 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 MLCondorcet 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 KinematicsCone 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 →StatisticalConfidence 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 AnalysisConger’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 & PhysiologyConicity 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 EconometricsConjoint 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 EstimatingConstruction 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 CostingConstruction 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 ControlContact 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 FinanceContainer 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 BucklingContinuous 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 →FinancialContribution 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 AnalysisCONUT 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 OverlapConverse-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 & TimeConvert 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 →FinancialConvert 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 →EngineeringConvert 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 & ReferenceConvert 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 & TimeConvert 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 & TimeConvert 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 & TimeConvert 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 SystemsConvert 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 & TimeConvert 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 →TextConvert 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 →EngineeringCONVERT function: translate weight, distance, and temperature units accurately
Convert engineering and logistics measurements between metric and imperial unit codes with CONVERT.
Read the guide →TextConvert 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 & TimeConvert 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 →MathConvert 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 FormulasConvert 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 →TextConvert 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 CalculationsConvert 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 →