Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Statistical

Friedewald LDL-C estimate, non-HDL-C and TC/HDL: guarded spreadsheet examples

Calculate three different lipid-panel quantities with explicit mg/dL units, input checks and limits on the Friedewald estimate.

Read the guide →
Nonparametric Statistics

Friedman Repeated-Measures Rank Test and Iman-Davenport F Formula

Rank repeated-measures blocks row by row in Excel and Arte Sheets, verify the rank-sum invariant, and compute Friedman’s Q alongside the sharper Iman-Davenport F statistic.

Read the guide →
Engineering & Science

Friedmann Equation: Cosmological Critical Density & Hubble H(z)

Calculate the universe’s critical closure density rho_crit = (3 * H_0^2) / (8 * PI() * G) (in 10^-27 kg/m^3) and flat Lambda-CDM expansion rate H(z) = H_0 * SQRT(Omega_m * (1 + z)^3 + Omega_Lambda) at redshift z.

Read the guide →
RF & Wireless Communications Engineering

Friis Cascaded RF Noise Figure (dB) and LNA Placement Formula

Calculate 3-stage cascaded RF receiver Noise Factor F_tot = F_1 + (F_2 - 1)/G_1 + (F_3 - 1)/(G_1*G_2) and Noise Figure NF_dB = 10*LOG10(F_tot) in Excel and Arte Sheets.

Read the guide →
Engineering & Scientific

Friis Free-Space Path Loss (FSPL), Nyquist Noise Floor & RF Link SNR Margin

Build an end-to-end RF wireless link budget in dB/dBm combining exact speed-of-light Friis FSPL, Johnson-Nyquist k_B*T*B thermal noise floor plus receiver noise figure, and carrier-to-noise ratio (SNR).

Read the guide →
Engineering

Froude Number (Fr = V / SQRT(gD)) & Weber Number (We = rho*V^2*d / sigma)

Calculate an open-channel Froude number and a separately specified Weber number with explicit length, velocity and density conventions.

Read the guide →
Fluid Mechanics, Dimensional Analysis & Tow-Tank / Wind-Tunnel Testing

Froude vs Reynolds Scale-Model Similitude Scaling Formula

Calculate Tow-Tank Froude-Scaled Model Speed V_proto / SQRT(Lambda), Cubic Force Scaling F_proto / Lambda^3, Propulsion Power Scaling P_proto / Lambda^3.5, and Unpressurized Reynolds-Similitude Speed V_proto * Lambda.

Read the guide →
Strategic Competition & Game Theory

Fudenberg-Tirole Top Dog & Puppy Dog Strategy Formula

Classify Stage-1 strategic over- vs under-investment into Drew Fudenberg and Jean Tirole’s (1984) four animal strategies (Top Dog, Puppy Dog, Fat Cat, Lean and Hungry) using Tough/Soft and Substitutes/Complements derivatives.

Read the guide →
Clinical Medicine & Physiology

Fujimoto, Kurazumi and Shuter–Aslani Body Surface Area Equations

Compare three correctly attributed body-surface-area estimates using height and weight, with the populations and limits of each source clearly identified.

Read the guide →
Healthcare & Clinical Calculations

Full and Partial Mayo Scores: Adding Ulcerative Colitis Subscores

Add pre-scored 0–3 components for the full Mayo score and its three-component partial version, and see why the partial score cannot establish endoscopic findings.

Read the guide →
Engineering & Science

Fuller-Schettler-Giddings Binary Gas Diffusivity Formula (D_AB)

Calculate binary gas-phase diffusion coefficients D_AB = 0.00143 * T^1.75 / (P * SQRT(M_AB) * (v_A^(1/3) + v_B^(1/3))^2) (cm^2/s) from atomic diffusion volumes.

Read the guide →
Statistical & Clinical Analysis

FUNC Score After Intracerebral Hemorrhage: Formula and Study Context

Calculate the 0–11 FUNC score from five documented components and understand why outcomes from the 2008 study are not individual guarantees.

Read the guide →
Institutional Asset Allocation, Fund-of-Funds & Fee-Drag Economics

Fund-of-Funds Double-Layer Fee & Carry Net-TVPI Formula

Compare Direct Primary LP Net TVPI against Private Equity Fund-of-Funds (FoF) Two-Layer Fee & Carry Net TVPI, Cumulative Two-Tier Fee/Carry Leakage ($M), and End-Investor Gross-Gain Capture Ratio.

Read the guide →
Quantitative Finance

Fundamental Law of Active Management Formula (Grinold IR, IC, Breadth & TC)

Calculate ex-ante Information Ratio IR = IC * SQRT(Breadth) * TC and expected active alpha E[R_A] = IR * Tracking_Error under the Clarke-de Silva-Thorley extended Fundamental Law.

Read the guide →
Statistical

Funnel conversion analysis: step pass-through, drop-off %, and overall conversion

Diagnose where prospects abandon a signup or checkout funnel by contrasting stage-to-stage conversion (B3 / B2) against cumulative top-of-funnel conversion (B3 / $B$2).

Read the guide →
Financial analysis

FV function: project future reserve balance from regular deposits

Calculate how an opening reserve plus fixed monthly contributions grows under compound monthly interest, keeping deposit signs consistent.

Read the guide →
Food Dehydration & Pharmaceutical Stability, GAB Moisture Sorption Isotherm

GAB Food Moisture Sorption Isotherm (M0, C, K) Formula

Calculate Effective Multilayer Activity K*aw, GAB Equilibrium Moisture Content (% dry basis), Uncorrected BET Moisture Prediction (%), and High-aw BET Divergence Error (%).

Read the guide →
Food & Pharmaceutical Powder Stability

GAB Moisture Sorption Isotherm & Monolayer Formula

Calculate Optimal Monolayer Water Activity a_w0 = 1 / (K * (1 + SQRT(C))), GAB Equilibrium Moisture Content M(a_w) = (M_0*C*K*a_w) / ((1 - K*a_w)*(1 - K*a_w + C*K*a_w)), and Classic BET Bias.

Read the guide →
Healthcare & Clinical

GAD-7: Seven-Item Anxiety Symptom Score in a Spreadsheet

Sum seven fictional GAD-7 item scores with complete input checks, and understand the distinction between a screening score and a diagnosis.

Read the guide →
Quantitative Receptor Pharmacology

Gaddum Competitive vs Non-Competitive Occupancy Formula

Compare J.H. Gaddum’s (1937) Competitive Orthosteric Occupancy [A] / ([A] + K_A*(1 + [B]/K_B)) against Non-Competitive Allosteric Insurmountable Occupancy ([A] / ([A] + K_A)) / (1 + [B]/K_B) and Ceiling 1 / (1 + [B]/K_B).

Read the guide →
Market Design & Operations Research

Gale-Shapley Matching Blocking-Pair Audit Formula

Audit proposed hospital-resident, school-choice, or project-team assignments for David Gale and Lloyd Shapley’s (1962) stability condition by counting Blocking Pairs.

Read the guide →
Statistics

Gambler's Ruin Probability: Fair (p = 0.5) & Biased Random Walk

Calculate the probability of reaching zero before a fixed upper target in an independent unit-step random walk, including fair odds, deterministic endpoints and numerically stable near-fair evaluation.

Read the guide →
Statistical Analysis

Gamma Waiting-Time Quantile & SLA Buffer Formula (GAMMA.INV Wilson-Hilferty Cube-Root)

Calculate multi-stage Gamma and Erlang waiting-time quantiles (GAMMA.INV) using exact exponential inversion for shape k = 1 and the Wilson-Hilferty cube-root transformation for multi-stage queues.

Read the guide →
Science

Gamow Quantum Tunneling Factor, Gamow Energy & Stellar Gamow Peak

Calculate nuclear Gamow Energy E_G = 2 * mu_keV * (PI() * alpha * Z1 * Z2)^2, Coulomb barrier tunneling probability P = EXP(-SQRT(E_G / E)), and thermonuclear Gamow Peak energy E_0 = (SQRT(E_G) * kT / 2)^(2/3).

Read the guide →
Date & Time

Gantt chart formula: build a dynamic project timeline grid in cells

Populate calendar or weekly Gantt timeline bars with mixed-reference AND comparisons and compute overall project start and finish dates.

Read the guide →
Switch-Mode Power Magnetics, Gapped Ferrite Buck/Flyback Inductors & Reluctance

Gapped Ferrite Core Inductor Reluctance, AL & Isat Formula

Calculate Total Series Magnetic Reluctance R_tot (MA/Wb), Gapped Inductance Factor AL (nH/turn²), Winding Inductance L (uH), and Hard-Saturation Peak Current Isat (A).

Read the guide →
Financial Modeling

Garman-Kohlhagen FX Currency Option Pricing & Covered Interest Parity

Price European FX calls and puts under Garman and Kohlhagen (1983) by discounting foreign currency spot at r_f and domestic strike at r_d, verified via FX put-call parity.

Read the guide →
Engineering

Gas Mean Free Path & Knudsen Number (Kn) Vacuum Flow Regimes

Estimate an ideal hard-sphere gas mean free path, calculate Kn=lambda/L, and compare it with explicitly defined rarefaction ranges using absolute pressure and consistent length units.

Read the guide →
Metallurgical Surface Heat Treatment, AMS 2759/10 Controlled Gas Nitriding & KN Potential

Gas Nitriding Potential KN & Case Depth Formula

Calculate Retort Ammonia Partial Pressure p_NH3 (atm), Hydrogen Partial Pressure p_H2 (atm), Lehrer Nitriding Potential KN (atm^-0.5), and Parabolic Nitrided Case Depth (mm).

Read the guide →
Engineering & Fluid Mechanics

Gates-Gaudin-Schuhmann (GGS) Particle Size Formula: Power-Law Passing & P80 Interpolation

Characterize jaw/cone crusher products and fine mineral tails using the Gates-Gaudin-Schuhmann power law P(d) = 100 * MIN(1, (d / k)^m) and solve directly for 80%-passing size P80 = k * 0.8^(1/m).

Read the guide →
Charts & Data Visualization

Gauge (Speedometer) Chart Formula: 180-Degree Doughnut Dial & Pointer Needle XY

Build a semicircular KPI Gauge / Speedometer Chart by pairing a 360-degree Doughnut dial (Red + Amber + Green = 180 degrees plus a transparent 180-degree bottom half) with a clamped pointer angle theta = 180 * (1 - p) and needle tip (COS, SIN).

Read the guide →
Environmental Engineering & Air Quality Modeling

Gaussian Air Plume Ground Concentration Formula

Calculate steady-state downwind ground-level centerline pollutant concentration C(x, 0, 0) = (Q / (PI()*u*sigma_y*sigma_z)) * EXP(-H^2 / (2*sigma_z^2)) with ground eddy reflection.

Read the guide →
Engineering & Scientific

Gaussian Error Function & Complementary Tail (ERF & ERFC) for Fickian Diffusion & BER

Evaluate erf(x) and erfc(x) = 1 - erf(x) to 6-decimal accuracy for semi-infinite Fick's Second Law dopant/heat diffusion profiles and BPSK digital communication bit-error rates.

Read the guide →
Semiconductor Device Physics, Ion Implantation & CMOS Doping

Gaussian Ion Implantation Peak Dopant & Junction Depth Formula

Calculate Peak Implanted Dopant Concentration N_p (10^18 cm^-3), Wafer Surface Concentration N(0) (10^18 cm^-3), Metallurgical p-n Junction Depth x_j (nm), and Peak-to-Background Ratio.

Read the guide →
Math

GCD function: simplify aspect ratios and find largest equal batch sizes

Find the greatest common divisor of two or more integers with GCD to reduce screen or recipe ratios to lowest whole terms.

Read the guide →
Clinical Medicine & Physiology

Gehan–George and Boyd Body Surface Area: A Spreadsheet Comparison

Compare two empirical estimates of body surface area with illustrative height and weight inputs. This exercise does not calculate medication doses.

Read the guide →
Engineering & Science

Geiger-Nuttall Law: Alpha-Decay Half-Life vs. Q-Value Tunneling Formula

Calculate base-10 log half-life log10(T_1/2) = (A_GN / SQRT(Q_alpha)) + B_GN across Polonium and actinide isotopes to see why doubling alpha decay energy spans 14+ orders of magnitude in half-life.

Read the guide →
Chemical, Process & Catalysis Engineering

Geldart Powder Fluidization Group (C, A, B, D) Classifier Formula: Size & Density Map

Classify gas-solid fluidized bed powders into Derek Geldart’s (1973) four hydrodynamic regimes — Group C (Cohesive), Group A (Aeratable), Group B (Sand-Like Bubbling), and Group D (Spoutable) — from Sauter mean diameter d_sv (um) and density difference Delta_rho.

Read the guide →
Rock Mechanics, Open-Pit Slope Stability & Deep Caverns, Hoek-Brown 2002 Criterion

Generalized Hoek-Brown Rock Mass GSI & Strength Formula

Calculate Generalized Hoek-Brown Reduced Constant mb, Rock Mass Cohesion Parameter s, Non-Linear Exponent a, and Triaxial Major Principal Failure Stress sigma_1 (MPa).

Read the guide →
Date & Time

Generate & Filter Gregorian Leap Years Accurately Across Century Boundaries

Build a leap-year list that avoids the naive +4 century trap on 1900 and 2100 using exact 4/100/400 modular rules, MONTH(DATE(y,2,29))=2, and FILTER.

Read the guide →
Date & Time

Generate & Snap Time Slots at Specific Minute Intervals (15, 20, or 30 Min)

Compute total appointment slots in a shift, map any integer slot index to exact HH:MM clock time, and snap arbitrary arrival timestamps upward to the next scheduled interval.

Read the guide →
Dates, Time & Schedules

Generate a Dynamic Sequence of Time Slots Every N Minutes (SEQUENCE & TIME)

Spill an exact clinic, interview, or conference schedule of N appointment slots spaced every M minutes using SEQUENCE(Slots, 1, TIME(Start_Hr, Start_Min, 0), Interval_Min / 1440).

Read the guide →
Dates & Schedules

Generate a Dynamic Sequence of Upcoming Weekend Dates (WEEKDAY & SEQUENCE)

Anchor on the first Saturday on or after any start date using WEEKDAY(start, 2) modular arithmetic and step forward in 7-day increments with SEQUENCE.

Read the guide →
Dates, Time & Schedules

Generate a Dynamic Sequence of Years & Multi-Year Forecast Headers (SEQUENCE)

Spill vertical or horizontal N-year financial forecast timelines from a single Start_Year and Horizon_Years input using SEQUENCE(N, 1, Start_Year, 1) or SEQUENCE(1, N, Start_Year, 1).

Read the guide →
Date & Time

Generate a Recurring Custom Weekday Schedule (Mon/Wed/Fri & Tue/Thu Cadence)

Compute the exact calendar date of the Nth recurring class, clinic, or delivery session on a custom multi-day weekly pattern such as Monday/Wednesday/Friday using quotient-and-remainder cycle math.

Read the guide →
Dates, Time & Schedules

Generate a Rolling Sequence of Month-Start & Month-End Dates (EDATE & EOMONTH)

Step forward or backward any number of calendar months from a start date using EDATE(DATE(Year, Month, 1), Offset) for exact 1st-of-month headers and EOMONTH(..., Offset) for leap-year-safe month-end closing dates.

Read the guide →
Math

Generate Combination Lock & Zero-Padded PIN Codes (SEQUENCE & MOD)

Count independent dial combinations, decode a three-dial state, and generate every four-digit decimal code with leading zeros. Includes validated inputs and a SEQUENCE list with a text-formatting column.

Read the guide →
Date & Time

Generate Dates & Workdays Between Two Dates (RANDBETWEEN & WORKDAY)

Sample calendar dates or Monday–Friday workdays within inclusive date bounds. Exclude holidays, guard empty workday pools, and use a fixed fraction in [0,1) for repeatable examples.

Read the guide →
Date & Time

Generate Drift-Free Future Time Intervals and Slot Schedules (1440-Minute Anchor Math)

Generate N-minute appointment, shift, or dispatch intervals from an anchor start time without cumulative floating-point rounding drift by indexing off Start + (Slot - 1) * Minutes / 1440.

Read the guide →
Text

Generate hierarchical WBS outline numbering (1, 1.1, 1.2, 1.2.1, 2) by level

Build a three-level outline code from explicit depth values and running counters. Refill the formulas when extending or restructuring the list.

Read the guide →