Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Date & Time

Convert seconds to Excel time (Seconds / 86400) & HH:MM:SS over 24 hours

Transform raw call-center ACD seconds and video durations into Excel fractional-day serials and rollover-proof HH:MM:SS strings.

Read the guide →
Text

Convert snake_case, kebab-case, camelCase, and Human Title labels

Transform database column names (customer_first_name) into report headers ("Customer First Name"), camelCase ("customerFirstName"), and ENV_VARS.

Read the guide →
Date & Time

Convert spreadsheet dates to Unix timestamps (and Unix epoch seconds back to dates)

Translate UTC date-time serials to Unix seconds using DATE(1970, 1, 1) and 86400 seconds/day—including millisecond API feeds.

Read the guide →
Lookup & Reference

Convert State and Region Names to 2-Letter Postal Codes (Bidirectional XLOOKUP)

Standardize mixed CRM address columns that contain both full state names ("California", "new york ") and existing 2-letter postal codes ("TX") into clean ISO/USPS codes without #N/A errors.

Read the guide →
Financial

Convert time worked into money: billable hours x hourly rate formula

Multiply spreadsheet HH:MM durations by 24 * HourlyRate to avoid the 24x underbilling bug, and enforce minimum callout fees.

Read the guide →
Date & Time

Convert timestamps across time zones: UTC offsets and midnight rollover

Add OffsetHours / 24 to full date-time values to shift calendar dates automatically across midnight, or wrap time-only values with MOD.

Read the guide →
Text

Convert Y/N schedule columns into days-of-week text ("Mon, Wed, Fri")

Turn seven Y/N delivery or availability flags into a weekday label list and a matching count.

Read the guide →
Date & Time Formulas

Convert Year & Day-of-Year Number (1–366) to Calendar Date

Convert ordinal day-of-year numbers (e.g., Year = 2026, Day = 135 -> 2026-05-15) into ISO calendar dates via DATE(Year, 1, Day_Number) while catching invalid Day 366 in non-leap years.

Read the guide →
Hybrid Securities, Corporate Finance & Equity-Linked Debt

Convertible Bond Parity, Premium & Breakeven Formula

Calculate Corporate Convertible Bond Conversion Ratio (Par / Conv_Price), Equity Conversion Parity Value, Dollar & Percentage Conversion Premium, and Coupon-vs-Dividend Income Payback Years.

Read the guide →
Venture Capital & Seed Financing

Convertible Note Cap vs Discount Conversion Formula

Calculate Accrued Simple-Interest Note Balance, Effective Conversion Price MIN(P_round * (1 - d), V_cap / S_pre), Converted Preferred Shares, and Day-1 Paper Multiple on Principal.

Read the guide →
Engineering & Science

Conwell-Weisskopf Ionized-Impurity Mobility & Matthiessen Total μ

Calculate Coulombic ionized-impurity carrier mobility μ_CW (cm^2/(V·s)) via Esther Conwell and Victor Weisskopf’s screened T^(3/2)/N_I Rutherford formula and combine with phonon mobility μ_L by Matthiessen’s Rule.

Read the guide →
Engineering & Science

Cooling Fin Efficiency (eta_fin) & Fin Effectiveness (epsilon_fin) Heat-Sink Formula

Calculate the extended-surface fin parameter m*L = L * SQRT((h * P) / (k * Ac)), adiabatic-tip fin efficiency eta_fin = tanh(m*L) / (m*L) (%) via exact EXP identity, and fin effectiveness epsilon_fin.

Read the guide →
HVAC Central Plants, Industrial Water Treatment & Mass Balance

Cooling Tower Cycles of Concentration & Blowdown Formula

Calculate Cooling Tower Evaporation Loss (GPM), Chloride Cycles of Concentration (COC), Controlled Basin Blowdown Rate (GPM), and Total Makeup Water Demand (GPM).

Read the guide →
Central Chiller Plant Condenser Water, CTI Evaporative Cooling Towers & Wet-Bulb Approach

Cooling Tower Range, Wet-Bulb Approach & Effectiveness Formula

Calculate Condenser-Water Cooling Range T_hot - T_cold (°C), Wet-Bulb Approach T_cold - T_wb (°C), Cooling Tower Thermal Effectiveness (%), and Total Heat Rejection Rate (kW).

Read the guide →
Engineering

Cooper-Jacob Transient Well Drawdown Formula (Theis Approximation)

Estimate constant-rate confined-aquifer drawdown using the Cooper–Jacob late-time approximation. Calculate u, apply a conservative small-u screen, and inspect drawdown per tenfold increase in time.

Read the guide →
Flight Mechanics, Aerodynamics & Aviation Safety

Coordinated Level Turn: An Idealised Load-Factor Example

Explore load factor, a relative stall-speed multiplier and turn radius for a simplified steady coordinated level turn.

Read the guide →
RF & Microwave PCB Design, Coplanar Waveguide (CPW) Elliptic Impedance & Delay

Coplanar Waveguide (CPW) RF PCB Impedance Z0 Formula

Calculate CPW Elliptic Modulus k0 = w/(w + 2g), Half-Space Effective Permittivity (1 + eps_r)/2, Hilberg Characteristic Impedance Z0 (Ohms), and Phase Velocity (mm/ns).

Read the guide →
Extractive Metallurgy & Precious-Metals Recovery, Electrolytic Copper Refining Tankhouse

Copper Electrorefining Anode Cycle, Scrap & Slime Formula

Calculate Dissolvable Anode Copper Mass (kg), Faraday Daily Cathode Plating Rate (kg/d), Anode Campaign Life Before Scrap Pull (days), and Au/Ag/Se Anode Slime Yield (kg/anode).

Read the guide →
Hydrometallurgy & Electrochemical Refining, Copper SX-EW Tankhouse Faraday Balance

Copper Electrowinning Tankhouse Harvest & kWh/t Formula

Calculate Daily LME Grade-A Copper plated per Electrolytic Cell (kg/day), Total Tankhouse Cathode Harvest (t/day), Rectifier DC Bus Load (MW), and Specific DC Energy (kWh/t Cu).

Read the guide →
Lookup & Reference

Copy Value from Every Nth Row or Column into a Clean Table (INDEX)

Reshape regular vertical blocks using INDEX and a stride, or extract every Nth column from a horizontal source. Includes explicit output anchors and bounds checks.

Read the guide →
Statistical & Clinical Analysis

Cornfield 2x2 Odds Ratio Quadratic Expected Cell A(psi) & Score Test Formula

Evaluate Jerome Cornfield’s (1956) noncentral hypergeometric quadratic expected cell count A(psi), conditioning variance V(A), and continuity-corrected chi-square score X^2(psi) for any hypothesized 2x2 Odds Ratio psi.

Read the guide →
Financial

Cornish-Fisher Modified VaR (mVaR) formula: Skewness & Excess Kurtosis Tail Risk

Explore a truncated Cornish-Fisher quantile approximation and compare its illustrative loss threshold with a Gaussian calculation.

Read the guide →
Debt Capital Markets, Corporate Bond Indentures & Liability Management

Corporate Bond Make-Whole Call Price & Par Floor Formula

Calculate Investment-Grade Corporate Bond Semiannual Make-Whole Discount Rate (Benchmark Treasury + Spread), Present Value of Remaining Coupons and Principal, Contractual MAX(Par, PV) Redemption Price ($), and Make-Whole Premium %.

Read the guide →
Corporate Divestitures, Carve-Out Accounting & Spin-Off Valuation

Corporate Carve-Out Standalone Cost & Stranded Overhead Formula

Calculate Divisional Carve-Out GAAP EBITDA (Direct EBITDA - Allocated Parent Corporate Cost), Standalone G&A Cost Delta (Dis-Synergies vs Cost Savings), True Standalone Run-Rate EBITDA, and RemainCo Unabsorbed Stranded Overhead.

Read the guide →
Corporate Finance, Net-Lease Real Estate & Sale-Leaseback Structuring

Corporate Sale-Leaseback Debt-Paydown Arbitrage Formula

Calculate Industrial / Retail Sale-Leaseback Gross Valuation Proceeds (NNN Rent / Cap Rate), Net After-Tax Debt Paydown After Capital-Gain Tax on Low-Basis Real Estate, Annual Interest Saved, and Pre-Tax Annual Cash-Flow Accretion / Dilution ($M).

Read the guide →
Corporate Finance, M&A Divestitures & IRC Section 355 Split-Offs

Corporate Split-Off Exchange Offer Proration & EPS Formula

Calculate IRC Section 355 Split-Off Parent Shares Retired (M), Oversubscribed Tender Proration Factor (%), Post-Split RemainCo EPS ($/sh), and EPS Lift vs Pro-Rata Spin-Off (%).

Read the guide →
Quantitative Finance & Derivatives

Corrado-Miller Closed-Form Implied Volatility for Non-ATM Options

Extract implied volatility away from the money without Solver using the Corrado-Miller (1996) quadratic moneyness correction and spot why ATM Brenner-Subrahmanyam overstates ITM vol.

Read the guide →
Statistical

Corrected QT Interval (QTc) ECG formulas: Bazett (SQRT) vs Fridericia (Cube Root)

Compare Bazett and Fridericia heart-rate corrections using QT in milliseconds and heart rate in beats per minute.

Read the guide →
Health & Fitness

Corrected Sodium in Hyperglycemia: Katz and Hillier Estimates

Compare two commonly reported sodium correction estimates with clear units and limits; neither replaces the measured sodium value or clinical assessment.

Read the guide →
Statistical

CORREL function: measure positive, negative, and zero linear correlation

Calculate the Pearson correlation coefficient (-1 to +1) between two paired metrics with CORREL, and understand why constant series return #DIV/0!.

Read the guide →
Quantitative Finance

Corwin-Schultz High-Low Bid-Ask Spread Estimator Formula (2-Day vs 1-Day)

Estimate effective percentage bid-ask spreads from daily High and Low bars alone using the Corwin & Schultz (2012) two-day range decomposition.

Read the guide →
Math

COS function: calculate horizontal run from sloped distance and angle

Project sloped survey or rafter lengths onto the horizontal ground plane with COS(RADIANS(angle)), and round floating-point noise at 90 degrees.

Read the guide →
Statistical

Cosine Similarity and Euclidean Distance between two vectors in cells

Compare embeddings, customer preference profiles, or document term vectors using SUMPRODUCT dot products and L2 vector norms.

Read the guide →
Financial

Cost-of-carry price model: compare a maturity price with spot

Explore Spot × EXP((financing + storage - yield) × years), with explicit continuous-rate assumptions and a comparison against spot.

Read the guide →
Financial

Cost-of-living adjustment (COLA): percentage raises, dollar caps, and reverse base

Calculate adjusted salaries with Base * (1 + Pct), enforce maximum raise caps with MIN, and recover pre-raise pay accurately.

Read the guide →
Financial

Cost-to-cost project progress: a simplified revenue and billings worksheet

Practice cost-based progress and cumulative catch-up arithmetic. Determine applicable ASC 606 or IFRS 15 accounting separately before using a project model.

Read the guide →
Math & Engineering

Cotangent (COT), Cosecant (CSC) & Secant (SEC) Roof Pitch & Optical Formulas

Calculate cotangent, cosecant, and secant from degree or radian angles using exact COS/SIN and 1/SIN identities while guarding 0 and 180 degree singularities.

Read the guide →
Engineering & Science

Cottrell Equation: Chronoamperometry Diffusion Current i(t) & Nernst Layer Thickness

Calculate t^(-1/2) planar diffusion current i(t) = (n * F * A * C0 * SQRT(D)) / SQRT(PI() * t) in microamps and Nernst diffusion-layer thickness delta = SQRT(PI() * D * t) in electrochemical sensors.

Read the guide →
Engineering

Couette Shear Stress, Viscous Heating & Rotational Viscometer Torque

Compute planar Couette shear and viscous dissipation, then compare narrow-gap torque with the ideal concentric-cylinder solution using the same inputs.

Read the guide →
Retaining Wall Design, Lateral Earth Pressure & Limit Equilibrium

Coulomb Active Earth Pressure Coefficient (Ka) & Thrust Formula

Calculate Coulomb Active Coefficient K_a (with Wall Friction delta, Battered Stem beta & Backfill Slope alpha), Inclined Active Thrust P_a (kN/m), Horizontal Sliding Thrust P_ah (kN/m), and Stabilizing Vertical Shear P_av (kN/m).

Read the guide →
Engineering

Coulomb Active Retaining-Wall Earth Pressure (Ka) & Horizontal Thrust

Calculate Charles-Augustin de Coulomb's Active Earth Pressure Coefficient K_a (accounting for soil friction phi, wall-soil friction delta, and sloping backfill beta) and horizontal overturning thrust P_ah.

Read the guide →
Engineering

Coulomb's Law Electrostatic Force & Electric Field Strength formulas

Calculate point-charge electrostatic force F = ke * |q1 * q2| / r^2, attractive/repulsive polarity, and electric field E = ke * |q1| / r^2.

Read the guide →
Data Cleaning & Text

Count & Audit Cells Containing Exactly N Characters (REPT "?" & LEN)

Count text codes matching an exact character length N using COUNTIF(range, REPT("?", N)) and flag truncated or padded SKU/IBAN entries row by row with LEN(TRIM(cell)).

Read the guide →
Text & Regular Patterns

Count & List Which Keywords Appear Inside a Single Text Cell

Score support tickets, contract clauses, or incident notes by counting how many distinct keywords from a watchlist appear inside one cell and listing every matched keyword.

Read the guide →
Conditional Aggregation

Count & Sum Cells Ending With or Starting With Specific Text (COUNTIF / SUMIF)

Match SKU suffixes ("*" & suffix) and regional prefixes (prefix & "*") dynamically with COUNTIF and SUMIF while preventing blank-affix wildcard traps.

Read the guide →
Math

Count & Sum Odd vs Even Numbers in a Range (MOD, ISODD & SUMIF)

Test integer parity with MOD(n, 2) or ISODD/ISEVEN and count or sum odd-numbered vs even-numbered street addresses, lot IDs, and quantities cleanly across any spreadsheet engine.

Read the guide →
Math & Statistical

Count 16+ Digit Card, IBAN & Tracking IDs Safely (Avoid COUNTIF 15-Digit Bug)

Count 16-to-22-digit card tokens, GS1 SSCC barcodes, and bank IDs accurately with SUMPRODUCT(--(A2:A6 = D2)), avoiding Excel COUNTIF's silent 15-significant-digit coercion bug.

Read the guide →
Conditional Aggregation

Count Active Rows Not Equal to Multiple Terminal Statuses

Count non-blank records whose status does not match any item in an excluded list using SUMPRODUCT boolean inequalities or multi-criteria COUNTIFS.

Read the guide →
Math

Count and sum GL codes by the sixth character with positional wildcards

Use a sixth-character mask with literal target escaping, and sum matching numeric amounts.

Read the guide →
Date & Time

Count Birthdays & Records by Year Cohort (Avoiding the Blank-Cell 1900 Trap)

Count birthdates or hire dates belonging to a specific calendar year or multi-year cohort using COUNTIFS date bounds and blank-guarded SUMPRODUCT + YEAR.

Read the guide →