Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Text

Extract the first or last word from a cell (single-word safe)

Pull the leading prefix token or trailing word from trimmed text with TEXTBEFORE/TEXTAFTER and IFERROR fallback for 1-word cells.

Read the guide →
Text & String Manipulation

Extract the Full Word Containing Specific Text (REPT Space-Island Method)

Pull an entire SKU, invoice tag, or email handle out of free-form memo text wherever a target prefix or substring appears—using the REPT(" ", 100) space-island pattern.

Read the guide →
Text

Extract the Nth word from a text string (or trim text to N words)

Normalize irregular spacing with TRIM, pull the exact Nth word with INDEX and TEXTSPLIT, or truncate descriptions to the first N words.

Read the guide →
Text & String Manipulation

Extract the Single Word Containing a Specific Substring (@, #, SKU-)

Pull out the exact space-delimited token containing "@", "#INC-", or "ORD-" from unstructured log messages using the padded-space SUBSTITUTE + SEARCH + MID + TRIM island technique.

Read the guide →
Dynamic Arrays

Extract unique multi-column rows and non-adjacent column pairs (UNIQUE & CHOOSECOLS)

Deduplicate entire multi-column records or specific non-adjacent columns (like Region + Plan) without modifying source data.

Read the guide →
Lookup & Reference

Extract unique values across multiple ranges while ignoring blanks (VSTACK, FILTER & UNIQUE)

Combine two lists, remove empty entries while retaining numeric zero, and produce a sorted distinct list and count.

Read the guide →
Text

Extract URL query parameters and UTM tags (utm_source, utm_campaign) by key

Extract the first raw value of a named query parameter from a controlled URL, excluding its fragment.

Read the guide →
Dynamic Arrays

Extract values that appear ONLY ONCE (UNIQUE 3rd argument: distinct vs singleton)

List identifiers that occur exactly once in a supplied range, rather than returning every distinct identifier.

Read the guide →
Text

Extract words starting with #, @, or a prefix (#hashtags, @mentions, Jira IDs)

Pull the 1st, 2nd, or Nth #hashtag, @mention, or PROJ- ticket code from free-form notes using padded " " & TRIM(A2) & " " with TEXTAFTER and TEXTBEFORE.

Read the guide →
Text & String Cleaning

Extract Workbook Filename, Folder Path & Sheet Tab Name from File Path (MID + FIND)

Split an Excel CELL("filename") path string like C:\Finance\[FY2026_Budget.xlsx]RevOps_Q4 into its workbook filename, folder directory, and active worksheet tab name.

Read the guide →
Power-Electronics Thermal Management, Extended-Surface Fin Efficiency & Heat Transfer

Extruded Heatsink Fin Efficiency TANH(mL)/(mL) Formula

Calculate Dimensionless Fin Parameter m*L, Single-Fin Efficiency eta_f = TANH(mL)/(mL) (%), Overall Finned-Array Thermal Resistance R_sa (°C/W), and Heatsink Base Temperature Ts (°C).

Read the guide →
Statistical Analysis

F-Distribution Right-Tail P-Value & ANOVA Critical Cutoff (F.DIST.RT & F.INV.RT)

Convert ANOVA and variance-equality F-ratios into normalized Paulson cube-root Z-scores, right-tail p-values (F.DIST.RT), and alpha significance cutoffs across numerator and denominator degrees of freedom.

Read the guide →
Statistical

F-Test formula: compare two sample variances (precision & spread ratio)

Calculate an oriented variance ratio and compare it with a two-sided F-test threshold under the stated assumptions.

Read the guide →
Engineering & Science

Fabry-Perot Etalon: Free Spectral Range (FSR), Reflective Finesse & Linewidth

Calculate optical cavity Free Spectral Range FSR = c / (2 * n * L) in GHz, mirror Reflective Finesse F = (PI() * SQRT(R)) / (1 - R), and transmission peak FWHM = FSR / F.

Read the guide →
Math

FACT function: calculate factorials, route permutations, and combinations

Compute n! arrangements, ordered permutations n! / (n - k)!, and unordered combinations using FACT.

Read the guide →
Business & Operations

Factory Physics CONWIP: Critical WIP (W0), Best-Case & Practical Worst-Case Throughput

Benchmark manufacturing line performance under Constant Work-In-Process (CONWIP) cap w using Hopp & Spearman Critical WIP W0 = rb * T0, Best-Case MIN(w/T0, rb), and Practical Worst-Case throughput (w / (w + W0 - 1)) * rb.

Read the guide →
Marketing Science & Customer Lifetime Value

Fader-Hardie BG/NBD Customer P(Alive) Formula

Calculate non-contractual repeat-buyer active probability P(Alive | x, t_x, T) = 1 / (1 + (a / (b + x - 1)) * ((T + beta) / (t_x + beta))^(r + x)) and uncover the Increase-Frequency Paradox.

Read the guide →
Healthcare & Clinical Calculations

Fagan’s Nomogram: Bayes Updates in a Spreadsheet

Calculate illustrative post-test probabilities from a prior, sensitivity and specificity, including valid boundary inputs and impossible-result cases.

Read the guide →
Civil, Structural & Geotechnical Engineering

Fair-Hatch Rapid Sand Filter Clean-Bed Head Loss Formula: Porosity & Sphericity

Calculate clean-bed hydraulic head loss h_L (m) through drinking-water rapid sand and dual-media anthracite filters using Gordon M. Fair and L. P. Hatch’s (1933) laminar porous-media drag equation.

Read the guide →
Engineering & Science

Fair’s Distillation Tray Flooding Velocity & Column Diameter Formula

Calculate maximum net-area vapor flooding velocity u_flood = C_sb * SQRT((ρ_L - ρ_V) / ρ_V) * (σ / 20)^0.2 (m/s) and minimum distillation column diameter via James Fair’s 1961 entrainment correlation.

Read the guide →
Quantitative Finance & Empirical Asset Pricing

Fama-MacBeth Risk Premia and Shanken EIV Standard Error Formula

Adjust naive Fama-MacBeth cross-sectional t-statistics for first-pass beta estimation error using Shanken’s (1992) errors-in-variables factor c_S = 1 + (lambda_hat / sigma_f)^2.

Read the guide →
Engineering

Fanno Compressible Pipe Flow Friction Parameter (4fL*/D) & Sonic Choking

Calculate the dimensionless Fanno friction choking parameter 4*f*L*/D = (1 - M^2)/(gamma*M^2) + ((gamma+1)/(2*gamma))*LN(((gamma+1)*M^2)/(2 + (gamma-1)*M^2)) and maximum unchoked gas pipe length L_max.

Read the guide →
Agronomy & Precision Irrigation Engineering

FAO Crop Coefficient Kc & Leaching Fraction Formula

Calculate FAO-56 Crop Evapotranspiration ET_c = K_c * ET_0, Ayers-Westcot Salinity Leaching Requirement LR = EC_w / (5 * EC_e - EC_w), Net Leaching-Adjusted Depth, and Gross Pumped Irrigation.

Read the guide →
Agricultural Hydrology, Precision Irrigation & Micrometeorology

FAO-56 Penman-Monteith Reference Evapotranspiration (ET0) Formula

Calculate FAO-56 Radiation-Driven ET Term (mm/d), Wind-VPD Aerodynamic ET Term (mm/d), Total Reference Grass Evapotranspiration ET0 (mm/d), and Weekly Water Volume per Hectare (m³/ha).

Read the guide →
Engineering

Faraday electrolysis yield and ideal van ’t Hoff osmotic pressure

Estimate deposited mass with a stated current efficiency and compare it with a separate ideal-solution osmotic-pressure calculation.

Read the guide →
Electroplating Surface Finishing, Watts Nickel / Hard Chrome Baths & Faraday’s Law

Faraday Electroplating Thickness & Cathode Efficiency Formula

Calculate Cathode Current Density J (A/dm²), Ideal 100%-Faradaic Deposited Mass (g), Cathode-Efficiency-Adjusted Metal Mass (g), and Mean Electroplated Coating Thickness (um).

Read the guide →
Engineering & Science

Faraday Magneto-Optic Rotation Angle & 45-Degree Optical Isolator Formula

Calculate non-reciprocal linear polarization rotation theta = DEGREES(V * B * L) from Verdet constant V (rad/(T*m)), axial magnetic field B (Tesla), and crystal length L (m), plus the exact field required for a 45° laser optical isolator.

Read the guide →
Science

Faraday's Law of Electrolysis Mass & Tafel Electrode Overpotential

Build a constant-current Faraday mass calculation with current efficiency, and a separate anodic Tafel approximation using a dimensionless current-density ratio.

Read the guide →
Statistical & Clinical Analysis

Farrington-Manning Non-Inferiority Risk Difference Score Test Formula

Test clinical non-inferiority of response rates H_0: p_T - p_C <= -delta_0 using C. P. Farrington & G. Manning’s (1990) FDA-preferred Score Z-statistic with restricted null variance.

Read the guide →
Mechanical Design & Fatigue Analysis

Fatigue Notch Sensitivity (q) and Factor K_f (Peterson Formula)

Convert static elastic stress concentration K_t into reduced cyclic fatigue concentration K_f = 1 + q * (K_t - 1) using Peterson’s notch-sensitivity formula q = 1 / (1 + a_pet / r_notch).

Read the guide →
Natural Resource & Forestry Economics

Faustmann Forest Rotation & Land Expectation Formula

Calculate Martin Faustmann’s (1849) infinite-rotation Land Expectation Value LEV = (p*V(T) - C*EXP(r*T))/(EXP(r*T) - 1) and contrast optimal Faustmann, single-cycle Wicksell, and biological MAI ages.

Read the guide →
Petroleum Refining, Fluid Catalytic Cracking (FCC) & Heat Balance

FCC Regenerator Coke Burn, Catalyst Circulation & Air Rate Formula

Calculate Zeolite Catalyst Circulation Rate (t/hr), Regenerator Coke Burn Rate (kg/hr), Exothermic Regenerator Heat Duty (MWth), and Main Air Blower Mass Flow (t/hr).

Read the guide →
Psychometrics & Biostatistics

Feldt W Statistic and Confidence Bounds for Cronbach’s Alpha

Test observed Cronbach’s alpha against a minimum reliability benchmark using Feldt’s exact variance-ratio W = (1 - alpha_0) / (1 - alpha_hat) and Bonett’s log-complement 95% confidence interval.

Read the guide →
Healthcare & Clinical

FENa and FEUrea: Fractional Excretion Spreadsheet Examples

Calculate fractional sodium and urea excretion from fictional urine and plasma measurements, while checking input units and the limits of clinical interpretation.

Read the guide →
Engineering

Fenske Minimum Distillation Stages (N_min) & Relative Volatility

Estimate binary total-reflux minimum equilibrium stages from mole fractions and supplied relative volatility, with input checks and explicit stage-counting assumptions.

Read the guide →
Civil, Structural & Geotechnical Engineering

Ferguson & Church (2004) Universal Sediment Settling Velocity Formula: Silt to Cobbles

Calculate terminal fall velocity w_s (m/s) of natural river/marine grains across ALL Reynolds numbers — bridging Stokes viscous silt (w ~ D^2) and turbulent gravel wake drag (w ~ SQRT(D)) without iteration — via R. I. Ferguson and M. Church (2004).

Read the guide →
Healthcare & Clinical

FeverPAIN Score: Five Criteria in a Spreadsheet

Explore FeverPAIN arithmetic using fictional sore-throat criteria, with input checks and the context needed to understand UK NICE guidance.

Read the guide →
Healthcare & Clinical

FIB-4 and APRI: Liver Fibrosis Index Spreadsheet Examples

Compute FIB-4 and APRI from fictional laboratory measurements, checking required inputs and the research context of each index.

Read the guide →
Engineering & Science

Fiber Bragg Grating (FBG) Wavelength, Strain & Temperature Shift Formula

Calculate FBG center Bragg reflection wavelength λ_B = 2 * n_eff * Λ and coupled strain-temperature shift Δλ_B = λ_B * ((1 - p_e) * ε + (α_Λ + ξ) * ΔT) for telecom C-band structural health sensors.

Read the guide →
Fiber-Laser Sheet Cutting, Nesting Cycle-Time Quoting & CNC Kerf Compensation

Fiber-Laser Cutting Pierce Time, Kerf & Cycle Time Formula

Calculate Total Pierce Dwell Time (s), Contour Cutting Time (s), Total Part Cycle Time Including Rapid Moves (s), Gross Parts Per Hour, and CNC Toolpath Kerf Offset (mm).

Read the guide →
Telecommunications Engineering, Single-Mode Fiber & DWDM Optical Links

Fiber-Optic Link Power Budget, Splice Loss & Margin Formula

Calculate Total Available Optical Power Budget (dB), Cumulative Span+Splice+Connector Attenuation (dB), Received Optical Power P_rx (dBm), and Unallocated Safety Margin (dB).

Read the guide →
Engineering

Fiber-Optic Numerical Aperture (NA), Acceptance Angle & V-Number

Explore an ideal circular step-index fiber: numerical aperture, a ray-model acceptance half-angle and V-number, using consistent units and an approximate higher-mode cutoff.

Read the guide →
Math & Trig

Fibonacci sequence in spreadsheets: recursive column and direct Nth term (Binet)

Generate Fibonacci numbers row-by-row (=B2+B3) or jump directly to the Nth Fibonacci number in a single cell using Binet's Golden Ratio formula.

Read the guide →
Statistical

Fick Cardiac Output, Stroke Volume & Systemic Vascular Resistance (SVR) formulas

Practice a simplified Fick-model calculation, stroke-volume conversion and resistance arithmetic with fictional inputs and explicit units.

Read the guide →
Science

Fick's First Law Diffusive Flux, Peclet (Pe) & Schmidt (Sc) Numbers

Compute signed one-dimensional diffusive molar flux from a linear concentration gradient, plus mass-transfer Peclet and Schmidt numbers with explicit units and input checks.

Read the guide →
Financial

FIFO vs. Weighted-Average Cost inventory COGS & Ending Inventory formulas

Allocate units sold across sequential purchase cost layers with MIN/MAX clipping to compute exact FIFO COGS, Ending Inventory, and WAC comparison.

Read the guide →
Hydrogen Type IV COPVs, Carbon-Fiber Filament Winding & 54.74° Netting Analysis

Filament-Wound Vessel Netting Analysis (54.74°) Formula

Calculate Exact Balanced Netting Winding Angle ATAN(SQRT(2)) = 54.74°, Axial-Governed Dry Fiber Thickness (mm), Hoop-Governed Dry Fiber Thickness (mm), and Total Composite Shell Thickness (mm).

Read the guide →
Structural Steel Connections, AWS D1.1 Welding & AISC 360 LRFD

Fillet Weld Effective Throat & AISC/AWS LRFD Strength Formula

Calculate 45° Fillet Effective Throat t_e = w / SQRT(2) (mm), Total Effective Weld Shear Area A_w (mm²), Design Strength per Millimeter (kN/mm), and Total Connection LRFD Capacity phi*R_n (kN).

Read the guide →
Media, Entertainment Finance & Film-Slate Recoupment Waterfalls

Film-Slate Recoupment Waterfall & Backend Profit Formula

Calculate Independent Film & Content-Slate Off-the-Top Distribution Fee, Post-P&A Recoupment Cash Available for Production Financing, Net Backend Profit Pool, and Equity Financier Total Cash Multiple.

Read the guide →
Dynamic Arrays

Filter & Flag Rows Containing Any Keyword from a Watchlist (SEARCH + FILTER)

Screen support tickets or bank-memo descriptions against multiple case-insensitive watchlist substrings using OR(ISNUMBER(SEARCH(...))) and FILTER.

Read the guide →