Learn one useful thing today.
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 StatisticsFriedman 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 & ScienceFriedmann 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 EngineeringFriis 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 & ScientificFriis 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 →EngineeringFroude 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 TestingFroude 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 TheoryFudenberg-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 & PhysiologyFujimoto, 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 CalculationsFull 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 & ScienceFuller-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 AnalysisFUNC 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 EconomicsFund-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 FinanceFundamental 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 →StatisticalFunnel 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 analysisFV 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 IsothermGAB 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 StabilityGAB 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 & ClinicalGAD-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 PharmacologyGaddum 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 ResearchGale-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 →StatisticsGambler'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 AnalysisGamma 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 →ScienceGamow 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 & TimeGantt 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 & ReluctanceGapped 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 ModelingGarman-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 →EngineeringGas 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 PotentialGas 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 MechanicsGates-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 VisualizationGauge (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 ModelingGaussian 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 & ScientificGaussian 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 DopingGaussian 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 →MathGCD 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 & PhysiologyGehan–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 & ScienceGeiger-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 EngineeringGeldart 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 CriterionGeneralized 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 & TimeGenerate & 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 & TimeGenerate & 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 & SchedulesGenerate 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 & SchedulesGenerate 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 & SchedulesGenerate 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 & TimeGenerate 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 & SchedulesGenerate 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 →MathGenerate 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 & TimeGenerate 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 & TimeGenerate 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 →TextGenerate 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 →