Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Formula Auditing & Errors

Fix and Prevent #REF. Errors in VLOOKUP, INDEX, and Structural Edits

Reproduce #REF! when col_index_num or INDEX coordinates exceed table dimensions, guard column bounds dynamically with COLUMNS/ROWS, and prevent broken column counts with MATCH or XLOOKUP.

Read the guide →
Math

Fix floating-point errors: why 1.33 - 1.3 is not 0.03 and how ROUND solves it

Prevent false reconciliation breaks caused by IEEE-754 binary decimals using explicit ROUND(..., 2) or ABS tolerance checks.

Read the guide →
Lookup & Reference

Fixed annual date-band lookup: season labels and conventional zodiac bands

Use month/day thresholds for recurring annual categories, including bands crossing January 1.

Read the guide →
Financial Modeling

Fixed-Declining Balance Depreciation (DB Rate, Partial First-Year & Final Stub)

Compute exact fixed-declining balance depreciation rates rounded to 3 decimal places, prorate partial first-year months, and close out final stub periods cleanly.

Read the guide →
Logical & Conditional

Flag & Count Values NOT Between X and Y (OR & Two-Tail COUNTIF)

Detect cold-chain, blood-glucose, or machining readings that fall strictly outside an acceptable [Min, Max] window using OR(B2 < MIN(X,Y), B2 > MAX(X,Y)) and count total two-sided excursions via COUNTIF.

Read the guide →
Statistical

Flag customers as New vs Returning on every order row

Compare each order date against MINIFS earliest purchase date per customer so unsorted order exports still classify accurately.

Read the guide →
Logical

Flag original vs. first duplicate vs. repeat duplicates (Expanding COUNTIF)

Use an expanding range COUNTIF($A$2:A2, A2) to distinguish the 1st valid occurrence (=1), the exact 1st duplicate (=2), and 3rd+ repeats (>2).

Read the guide →
Logical

Flag out-of-sequence, skipped, and duplicate invoice or serial numbers

Audit sequential check, voucher, and batch serial logs to classify exact "+1 OK" transitions versus missing-number gaps, duplicates, and reversals.

Read the guide →
Financial

Flat add-on interest versus annual cash-flow IRR: a four-payment example

Compare four end-of-year flat-interest payments with a declining-balance loan and calculate the annual IRR of the cash flows.

Read the guide →
Statistical & Math

Fleiss’ Kappa (kappa) Multi-Rater Categorical Agreement Formula

Calculate chance-corrected multi-annotator reliability Fleiss’ Kappa = (P_bar - P_e) / (1 - P_e) across N items rated by n >= 3 raters into k categories for ML data-labeling QA and clinical radiology panels.

Read the guide →
Statistical

Flesch Reading Ease & Flesch-Kincaid Grade Level Readability Formulas

Calculate Flesch Reading Ease 206.835 - 1.015*(Words/Sentences) - 84.6*(Syllables/Words) and US school Flesch-Kincaid Grade Level 0.39*(Words/Sentences) + 11.8*(Syllables/Words) - 15.59 for editorial and compliance auditing.

Read the guide →
Dynamic Arrays & Spill

Flip Table Rows Upside-Down in Exact Reverse Order (SORTBY & SEQUENCE)

Invert any 1D list or multi-column 2D log table from bottom-to-top positional order—even when timestamps have ties or non-chronological text—using SORTBY(range, SEQUENCE(ROWS(range)), -1).

Read the guide →
Advanced IC Packaging & Heterogeneous Integration, Flip-Chip C4 Underfill & DNP Strain

Flip-Chip C4 DNP Shear Strain & Capillary Underfill Formula

Calculate Corner-Bump CTE Differential Displacement (um), Un-Underfilled Bump Shear Strain (%), Young-Laplace Gap Driving Pressure (kPa), and Washburn-Hele-Shaw Fill Time (s).

Read the guide →
Statistical & Clinical Analysis

FLIPI Score for Follicular Lymphoma: Factors and Study Context

Calculate the original five-factor FLIPI total using complete inputs, including the correct age boundary, and interpret risk groups in their research context.

Read the guide →
Charts & Visual Data Modeling

Floating Bar & Up-Down Column Span Chart Formula: Hidden Base & Positive/Negative Delta

Create Floating Bar (salary bands, temperature ranges) and Up-Down Floating Column charts using stacked series: Hidden Base = MIN(Start, End), Up Gain = MAX(0, End - Start), and Down Loss = MAX(0, Start - End).

Read the guide →
Engineering & Science

Flory-Huggins Polymer Solution Theory: Mixing Free Energy & Critical Chi (chi_c)

Calculate dimensionless Flory-Huggins lattice free energy of mixing Delta_Gm / (n_site * R * T) and the critical spinodal phase-separation parameter chi_c = 0.5 * (1 + 1 / SQRT(N))^2.

Read the guide →
Mechanical Energy Storage, Composite Rotordynamics & UPS Grid Frequency Regulation

Flywheel Kinetic Energy Storage & Rim Hoop-Stress Formula

Calculate High-Speed Vacuum Flywheel Usable Extractable Kinetic Energy (kWh) Across [RPM_min, RPM_max], Outer-Rim Linear Tip Speed (m/s), Thin-Rim Centrifugal Hoop Stress σ_θ = ρ*v² (MPa), and Composite Burst Safety Factor.

Read the guide →
Machine Dynamics, Mechanical Press Flywheels & Rotational Inertia

Flywheel Speed Fluctuation (Cs) & Moment of Inertia Formula

Calculate Mean Angular Velocity omega (rad/s), Required Mass Moment of Inertia I (kg·m²) for Target Speed Fluctuation Cs, Equivalent Thin-Rim Mass (kg), and Rim Tip Speed (m/s).

Read the guide →
Autonomous Sensing, 77 GHz Automotive FMCW Radar & Signal Processing

FMCW Radar Chirp Bandwidth, Beat Frequency & Range Formula

Calculate 77 GHz Frequency-Modulated Continuous-Wave (FMCW) Chirp Radar Range Resolution ΔR = c/(2*B), Chirp Slope S (MHz/µs), Target IF Beat Frequency f_b (MHz), and ADC-Limited Maximum Unaliased Detection Range (m).

Read the guide →
Statistical

FORECAST function: project a linear trend from historical X and Y pairs

Estimate future demand or utility load along a least-squares linear regression line using FORECAST, and guard against flat X inputs.

Read the guide →
Financial

Forecast vs Actual Budget Variance: Favorable (F) vs Unfavorable (U)

Build a budget-versus-actual report with an explicit favorable-positive convention, validated account types, zero-base handling and separate amount, percentage and status outputs.

Read the guide →
Statistical & Math

Forest Plot Meta-Analysis: Pooled Effect, 95% CI & Inverse-Variance Weights

Build clinical-trial Forest Plot summary rows by exponentiating log-odds/log-risk effects EXP(theta +/- 1.96 * SE), computing fixed-effect inverse-variance weights w_i = 1 / SE_i^2, and pooling theta_pooled = SUM(w_i * theta_i) / SUM(w_i).

Read the guide →
Text

Format email with display name ("Name <email>") and extract address back out

Format a simple single-recipient display string and extract an address from a controlled angle-bracket format. This is not a complete email-header parser.

Read the guide →
Text

Format MAC addresses: standardize colons (00:1A:2B...) or Cisco dots

Strip mixed separators from 12-character hex MAC addresses, validate length, and format into colon-separated pairs or Cisco dot-quads.

Read the guide →
Text

Format numbers as ordinals: 1st, 2nd, 3rd, 4th (including 11th–13th)

Append accurate English ordinal suffixes ("st", "nd", "rd", "th") to ranks and day numbers while handling the 11th/12th/13th teen exception.

Read the guide →
Date & Time Formulas

Formula to List Weekend Dates Only (Saturday & Sunday Shift Schedule)

Calculate the upcoming Saturday on or after any start date via B2 + MOD(6 - WEEKDAY(B2, 2), 7) and step strictly across consecutive Saturday/Sunday pairs using 7 * INT((N - 1) / 2) + MOD(N - 1, 2).

Read the guide →
Healthcare & Clinical Calculations

Forns Index Non-Invasive Liver Fibrosis Calculator (Platelets, GGT, Cholesterol)

Calculate the Forns liver fibrosis index from platelet count, GGT, age and total cholesterol, and understand the original chronic-hepatitis-C study context and thresholds.

Read the guide →
Statistical & Clinical Analysis

Forrester Hemodynamic Subsets: Cardiac Index and Wedge Pressure

Explore the historical four-subset classification using cardiac output, body surface area, and pulmonary capillary wedge pressure, without turning the result into an automatic diagnosis.

Read the guide →
Economics & Market Microstructure

Foster-Greer-Thorbecke (FGT_0, FGT_1, FGT_2) Poverty Headcount, Gap & Severity Formula

Calculate the World Bank’s unified Foster-Greer-Thorbecke (1984) poverty family P_alpha = (1/N) * SUM(MAX(0, (z - y_i)/z)^alpha): Headcount Ratio P_0, Poverty Gap Index P_1, and Distribution-Sensitive Squared Severity P_2.

Read the guide →
Foundry Sand Lab & Defect Control, AFS Standard 2-Inch Specimen Permeability Formula

Foundry Green-Sand AFS Permeability & Blowhole Formula

Calculate Volumetric Air Venting Rate (cm³/min), Superficial Darcy Gas Velocity (cm/min), AFS Permeability Number P, and Iron/Steel Castings Steam-Blowhole Gate.

Read the guide →
Metal Casting Gating Design, Bernoulli Mold Aspiration Prevention & Pouring Time

Foundry Tapered Sprue Choke & Aspiration Ratio Formula

Calculate Aspiration-Free Top Sprue Entry Area A1 = A2*SQRT(h2/h1) (mm²), Torricelli Choke Velocity (m/s), Volumetric Pouring Rate (cm³/s), and Mold Fill Time (s).

Read the guide →
Healthcare & Clinical Formulas

FOUR Score: Adding Four Neurological Subscores

Practice adding four fictional 0–4 subscores for the FOUR coma scale, with complete input validation and context about its limits.

Read the guide →
Engineering

Fourier Heat Conduction formula: composite wall R-Value, U-Value & heat loss (W)

Calculate SI area-normalized resistance, transmittance and signed steady heat flow through a planar layered wall.

Read the guide →
Engineering & Science

Fowler-Nordheim Quantum Field-Emission Tunneling Current Density Formula

Calculate cold-cathode quantum electron tunneling current density J = ((1.5414e-6 * E^2) / phi) * EXP((-6.8309e7 * phi^1.5) / E) in A/cm^2 for FE-SEM tips, carbon nanotubes, and flash memory.

Read the guide →
Machine Learning & Cluster Evaluation

Fowlkes-Mallows Clustering Index Formula vs Pairwise F1 and Jaccard

Evaluate clustering partitions in Excel and Arte Sheets using the Fowlkes-Mallows geometric mean of pairwise precision and recall TP / SQRT((TP + FP) * (TP + FN)).

Read the guide →
Engineering & Science

Fox Equation & Gordon-Taylor Copolymer Glass Transition Temperature (Tg)

Predict the glass transition temperature Tg (in °C via absolute Kelvin) of random copolymers, plasticized PVC, and miscible amorphous blends using the Fox harmonic rule and Gordon-Taylor equation.

Read the guide →
Statistical & Psychometrics

Fragility Quotient: A Sample-Size Ratio, Not a Trial Verdict

Calculate a percentage from an independently supplied fragility index and a stated sample-size denominator, and understand the limits of interpreting it.

Read the guide →
Healthcare & Clinical Calculations

FRAIL Scale: Five Screening Flags in a Spreadsheet

Add five fictional FRAIL screening flags with complete binary-input validation and context about the score’s limits.

Read the guide →
Hydropower & Turbomachinery Engineering, Francis Reaction Turbine & Thoma Cavitation Law

Francis Turbine Specific Speed & Thoma Draft-Tube Formula

Calculate Metric Power Specific Speed Ns, Required Runner Suction Head NPSH_r (m), Maximum Safe Runner Elevation Above Tailwater Hs,max (m), and Cavitation Submergence Margin (m).

Read the guide →
Engineering & Science

Franz-Keldysh Electro-Absorption Energy (ħΘ_FK) Modulator Formula

Calculate the Franz-Keldysh photon-assisted tunneling energy ħΘ_FK = 0.72495 * (F^2 / m_r)^(1/3) (meV) governing bulk III-V electro-absorption optical modulators.

Read the guide →
Engineering

Free-Space Path Loss (FSPL), Friis RF link power & Inverse-Square dB drop

Calculate wireless RF attenuation FSPL(dB) = 20*LOG10(d_km) + 20*LOG10(f_MHz) + 32.44, Friis received dBm, and acoustic -20*LOG10(d2/d1) distance attenuation.

Read the guide →
Statistical & Clinical Analysis

Freedman Log-Rank Sample Size Formula: Required Events ((k*HR + 1)/(HR - 1))²

Calculate conservative log-rank survival event targets under non-null variance using Laurence S. Freedman’s 1982 Statistics in Medicine formula E = ROUNDUP((z_alpha + z_beta)² * (1 + k*HR)² / (k * (1 - HR)²), 0).

Read the guide →
Statistical & Clinical Analysis

French TMA Score: Two Laboratory Criteria and Limits of Interpretation

Explore the two-point French score described by the French TMA reference center using platelet count and serum creatinine, with explicit units, thresholds and clinical limitations.

Read the guide →
LTCC Microelectronics, Glass Frits & SLS Polymer Powders, Yakov Frenkel (1945) Viscous Sintering

Frenkel Viscous Sintering Neck Ratio & Shrinkage Formula

Calculate Viscous Capillary Characteristic Time (min), Frenkel Neck-to-Particle Radius Ratio (x/r), Isotropic Linear Shrinkage (-dL/L0 %), and Frenkel-vs-Mackenzie Regime Status.

Read the guide →
Statistical

Frequency distribution table: Bin Count, Relative %, and Cumulative %

Group numeric scores into custom bins with COUNTIFS and calculate Relative Frequency % and Cumulative Frequency % without legacy array entry.

Read the guide →
Statistical

FREQUENCY function: group numeric values into histogram bins

Count how many observations fall into each upper-bound interval—plus the overflow bin above the highest threshold—using FREQUENCY.

Read the guide →
Charts & Visual Data Modeling

Frequency Polygon Chart Formula: Class Midpoints, Zero Anchor Bins & Grouped Mean

Construct a true closed Frequency Polygon line/scatter chart: calculate Class Midpoints x_m = (Lower + Upper) / 2, add zero-frequency boundary anchor bins so polygon area equals histogram area, and compute Grouped Mean.

Read the guide →
Engineering

Fresnel Optical Reflectance, Transmittance & Brewster's Angle formulas

Calculate uncoated glass or crystal surface reflection loss R = ((n1 - n2) / (n1 + n2))^2, single-interface transmittance 1 - R, and Brewster's polarizing angle ATAN(n2 / n1).

Read the guide →
Aerospace & EV Battery Tray Solid-State Joining, Friction Stir Welding (FSW) Energetics

Friction Stir Welding (FSW) Pitch, Heat Index & Power Formula

Calculate FSW Advance-per-Revolution Weld Pitch (mm/rev), Arbegast Pseudo-Heat Index, Mechanical Spindle Stir Power (kW), and Net Linear Heat Input (J/mm).

Read the guide →
Chemical, Process & Catalysis Engineering

Friedel Two-Phase Pressure-Drop Multiplier (Phi_LO^2) Formula: Froude & Weber Pipe Flow

Calculate two-phase gas-liquid frictional pressure drop dP_TP = Phi_LO^2 * dP_LO in horizontal and vertical upward pipelines using Lutz Friedel’s (1979) 25,000-point correlation incorporating Froude (Fr_H) and Weber (We_L) numbers.

Read the guide →