Learn one useful thing today.
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 ManipulationExtract 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 →TextExtract 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 ManipulationExtract 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 ArraysExtract 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 & ReferenceExtract 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 →TextExtract 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 ArraysExtract 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 →TextExtract 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 CleaningExtract 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 TransferExtruded 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 AnalysisF-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 →StatisticalF-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 & ScienceFabry-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 →MathFACT function: calculate factorials, route permutations, and combinations
Compute n! arrangements, ordered permutations n! / (n - k)!, and unordered combinations using FACT.
Read the guide →Business & OperationsFactory 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 ValueFader-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 CalculationsFagan’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 EngineeringFair-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 & ScienceFair’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 PricingFama-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 →EngineeringFanno 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 EngineeringFAO 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 & MicrometeorologyFAO-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 →EngineeringFaraday 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 LawFaraday 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 & ScienceFaraday 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 →ScienceFaraday'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 AnalysisFarrington-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 AnalysisFatigue 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 EconomicsFaustmann 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 BalanceFCC 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 & BiostatisticsFeldt 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 & ClinicalFENa 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 →EngineeringFenske 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 EngineeringFerguson & 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 & ClinicalFeverPAIN 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 & ClinicalFIB-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 & ScienceFiber 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 CompensationFiber-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 LinksFiber-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 →EngineeringFiber-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 & TrigFibonacci 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 →StatisticalFick 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 →ScienceFick'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 →FinancialFIFO 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 AnalysisFilament-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 LRFDFillet 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 WaterfallsFilm-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 ArraysFilter & 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 →