Learn one useful thing today.
Glasgow Alcoholic Hepatitis Score: Research Formula Example
Explore the 5–12 point Glasgow Alcoholic Hepatitis Score using fictional inputs, explicit units, and validation of all five required values.
Read the guide →StatisticalGlasgow Coma Scale arithmetic: validate components and preserve not-testable status
Practice a validated E/V/M total for fictional observations while keeping non-testable components distinct from numeric scores.
Read the guide →HealthcareGlasgow-Blatchford Score: Spreadsheet Points and Unit Checks
Calculate the 0–23 Glasgow-Blatchford total from fictional inputs using explicit SI laboratory units, both published hemoglobin threshold sets and validated binary flags.
Read the guide →Float Glass, Container & Optical Glass Manufacturing, Adams-Williamson Annealing LehrGlass Annealing Lehr Cooling Rate & Birefringence Formula
Calculate Maximum Safe Annealing Lehr Cooling Rate hmax (°C/min), Critical Strain-Point Cooling Time (min), Polariscope Optical Retardation (nm/cm), and Anneal Quality Class.
Read the guide →Glass Manufacturing & Regenerative Tank Thermodynamics, Batch Fusion Loss & Cullet RuleGlass Furnace Carbonate Fusion Loss, Cullet & Fuel Formula
Calculate Fused Virgin-Batch Glass Tonnage (t/d), Total Regenerative Furnace Pull (t/d), Cullet Share in Molten Pull (%), and Cullet-Reduced Specific Melting Energy (GJ/t).
Read the guide →Statistical & Clinical AnalysisGlicko Rating & Rating Deviation (RD) Formula: Inactivity Uncertainty & Match Update
Upgrade Elo by incorporating Mark Glickman’s Rating Deviation (RD): inflate pre-period uncertainty RD_pre = MIN(350, SQRT(RD_0^2 + c^2*t)), compute opponent attenuation g(RD_j), and update post-match rating and RD.
Read the guide →Spatial Statistics & Supply Chain AnalyticsGlobal Moran’s I Spatial Autocorrelation and Null Expectation Formula
Calculate Global Moran’s I = (N / S_0) * (SUM_ij w_ij * z_i * z_j) / SUM(z_i^2) across contiguous regions and benchmark against exact finite-sample expectation E[I] = -1 / (N - 1).
Read the guide →Market Microstructure & Quantitative TradingGlosten-Milgrom Adverse-Selection Bid-Ask Spread Formula
Derive Bayesian market-maker Ask = E[V | Buy], Bid = E[V | Sell], and Glosten-Milgrom spread from informed-trader probability mu and asset value range V_H - V_L.
Read the guide →Civil, Structural & Geotechnical EngineeringGlover-Dumm Transient Drain Spacing Formula: Falling Water Table Drawdown m_0 to m_t
Calculate subsurface drain spacing L (m) required to lower a storm/irrigation water-table mound from m_0 to m_t within t days using R. E. Glover and L. D. Dumm’s (1954, USBR) Boussinesq diffusion solution.
Read the guide →FinancialGMROI and Sell-Through Rate formulas (retail merchandising KPIs)
Measure Gross Margin Return on Inventory Investment (GMROI = Gross Margin $ / Avg Inventory Cost) alongside monthly SKU Sell-Through %.
Read the guide →Healthcare & ClinicalGoldman-Hodgkin-Katz (GHK) Membrane Voltage Equation (K+, Na+, Cl-)
Explore the GHK constant-field voltage equation and a potassium Nernst comparison at 37 °C, with explicit units and input checks.
Read the guide →Quantitative Finance & DerivativesGoldman-Sosin-Gatto Floating-Strike Lookback Call Formula
Price continuous floating-strike lookback calls paying S_T - S_min in Excel and Arte Sheets using the Goldman-Sosin-Gatto (1979) / Conze-Viswanathan formula.
Read the guide →Statistical & Mathematical FormulasGompertz Growth Curve: Double-Exponential Volume & K/e Inflection
Model decelerating tumor spheroid, microbial, and SaaS adoption curves via Laird’s Gompertz equation N(t) = K * EXP(-LN(K / N0) * EXP(-α * t)) and locate the exact peak-growth inflection time t_inf = LN(LN(K / N0)) / α.
Read the guide →Actuarial Life Contingencies & DemographyGompertz-Makeham Force of Mortality and Survival _t p_x Formula
Compute Gompertz-Makeham force of mortality mu(x) = A + B * c^x and exact integrated t-year survival probability _t p_x = EXP(-A*t - (B * c^x / LN(c)) * (c^t - 1)).
Read the guide →Statistical & PsychometricsGoodman and Kruskal’s Gamma (γ) Ordinal Association Formula
Calculate tie-free ordinal monotonic association γ = (N_c - N_d) / (N_c + N_d) across Likert scales and clinical staging tables alongside tie-penalized Kim’s d_y.x.
Read the guide →EngineeringGoodman, Soderberg and Gerber Proportional-Loading Factors
Compare three mean-stress fatigue factors, calculate the Gerber root stably and check the peak-stress yield factor separately.
Read the guide →FinancialGordon Growth Model (DDM) formula: intrinsic stock value & implied cost of equity
Value dividend-paying equities via P0 = D0*(1+g)/(ke - g), guard against g >= ke blow-ups, and back out implied market cost of equity.
Read the guide →Operations Research, Closed Manufacturing Loops & Computer PerformanceGordon-Newell Closed Queueing & Buzen Convolution Formula
Calculate Exact 2-Station Gordon-Newell Normalization Constant G(N) via Buzen’s Convolution Sum, Exact Closed-Loop System Throughput G(N-1)/G(N), Bottleneck Asymptote 1/D_max, and Bottleneck Server Utilization.
Read the guide →Environmental & Natural Resource EconomicsGordon-Schaefer Fishery MSY, MEY & Open-Access Formula
Compare biological Maximum Sustainable Yield (E_MSY = r/(2*q)), Open-Access Bionomic rent dissipation (E_OA), and conservationist Maximum Economic Yield (E_MEY = E_OA / 2).
Read the guide →Cardiology Hemodynamics & Structural Heart CatheterizationGorlin Aortic Valve Area (AVA) Catheterization Formula
Calculate Invasive Hemodynamic Stroke Volume (mL/beat), Mean Systolic Transvalvular Flow Rate (CO_L_min * 1000)/(HR * SEP), Richard & Sandra Gorlin’s Aortic Valve Area AVA = Flow / (44.3 * SQRT(Mean_Grad_mmHg)), and ACC/AHA Stenosis Severity.
Read the guide →Alternative Asset Management, GP Stakes & Sum-of-the-Parts ValuationGP Stakes FRE vs PRE Asset-Manager Valuation Formula
Value Alternative Asset Management Firms via Sum-of-the-Parts: Recurring Fee-Related Earnings (FRE = FPAUM * Fee_Rate * FRE_Margin), Performance-Related Carry Earnings (PRE), FRE Valuation Weight, and Minority GP Stake Check.
Read the guide →Private Equity Secondaries, Continuation Vehicles & LP LiquidityGP-Led Continuation Fund Secondary Pricing & LP Cash Formula
Calculate GP-Led Continuation Vehicle (CV) Implied Transaction Value (Reference_NAV * Bid_Pct), Crystallized GP Carried Interest on Selling LPs, Selling-LP Net Cash Wire, and Secondary Buyer Day-1 Mark-to-NAV Gain.
Read the guide →Private Equity Secondaries, Continuation Vehicles & LPAC GovernanceGP-Led Continuation Vehicle (CV) Carry Rollover & Alignment
Calculate Legacy Fund Crystallized GP Carry ($M), Selling LP Cash Liquidity Payout ($M), Secondary Lead Syndicate Day-1 Check ($M), and GP Day-1 CV Ownership Alignment (%).
Read the guide →StatisticalGPA formula: calculate credit-weighted Grade Point Average
Map letter grades to 4.0 scale points with XLOOKUP and weight courses by credit hours with SUMPRODUCT(Credits, Points) / SUM(Credits).
Read the guide →Healthcare & Clinical CalculatorsGRACE Acute Coronary Syndrome Research and Spreadsheet Totals
Read the original GRACE research and current guidelines, then practice adding unrelated fictional component values.
Read the guide →MathGrade multiple-choice tests against an answer key (SUMPRODUCT, FILTER & TEXTJOIN)
Score student or certification exam responses automatically with unweighted counts, custom per-question point weights, and exact missed-question lists.
Read the guide →Engineering & ScienceGraham’s Law of Gas Effusion & Knudsen Isotope Separation Factor
Calculate molecular pinhole effusion rate ratios r_1 / r_2 = SQRT(M_2 / M_1) from molar masses—comparing rapid H2 vs. O2 vacuum leaks (3.984x) against razor-thin single-stage 235UF6 / 238UF6 gaseous diffusion enrichment (alpha = 1.004303).
Read the guide →Drinking-Water Treatment, PFAS/VOC Adsorption & Mass TransferGranular Activated Carbon (GAC) EBCT & Bed-Life Formula
Calculate Granular Activated Carbon Empty Bed Contact Time EBCT (min), Superficial Hydraulic Loading Rate (m/hr), Daily Carbon Usage Rate CUR (kg/d), and Days to Breakthrough.
Read the guide →EngineeringGrashof Number (Gr) & Rayleigh Number (Ra) Natural Convection
Calculate ideal-gas Grashof and Rayleigh magnitudes with SI inputs, then compare Ra with an illustrative vertical-plate reference without treating it as a universal transition rule.
Read the guide →ScienceGreen-Ampt Wetting-Front Soil Infiltration Rate & Ponding Depth
Calculate physically based Green-Ampt soil infiltration capacity f = K_s * (1 + (psi * Delta_theta) / F) (mm/hr) and Mein-Larson Cumulative Ponding Depth F_p = (K_s * psi * Delta_theta) / (i - K_s) (mm).
Read the guide →Transportation Engineering & Operations ResearchGreenshields Traffic Flow & Queue Shockwave Formula
Calculate Greenshields (1935) highway speed v(k) = v_f*(1 - k/k_j), parabolic flow q(k) = k*v(k), maximum lane capacity v_f*k_j / 4, and Lighthill-Whitham-Richards backward queue shockwave speed.
Read the guide →Biostatistics & Survival AnalysisGreenwood Survival Standard Error and Log-Log Confidence Interval
Compute Kaplan-Meier survival S(t), Greenwood’s variance formula, and Kalbfleisch-Prentice log(-log S(t)) confidence bounds that never exceed 100% survival.
Read the guide →Statistical & Mathematical FormulasGreenwood’s Formula & Kalbfleisch-Prentice Log-Log Survival 95% CI
Calculate Kaplan-Meier survival standard error SE(S(t)) = S(t) * SQRT(Σ d_i / (n_i * (n_i - d_i))) via Major Greenwood’s 1926 formula and construct bounded [0, 1] log-log 95% confidence limits S(t)^EXP(±1.96 * SQRT(V) / |LN(S(t))|).
Read the guide →Power System Reliability & Resource AdequacyGrid N-1 Reserve & ELCC Accredited Capacity Formula
Calculate Total Accredited Unforced Capacity UCAP = Thermal_ICAP*(1 - EFORd) + VRE_Nameplate*ELCC, Planning Reserve Margin Surplus vs Target PRM, and N-1 Largest-Contingency Margin.
Read the guide →Ceramic Materials, Fracture Mechanics & Semiconductor Wafer ReliabilityGriffith Brittle Fracture & Weibull Ceramic Volume Scaling
Calculate Griffith Critical Brittle Fracture Stress SQRT((2*E*gamma_s)/(PI()*a)), Weibull Weakest-Link Effective-Volume Knockdown Factor (V_coupon / V_part)^(1/m), Full-Component Characteristic Strength, and Design Safety Factor.
Read the guide →FinancialGross margin vs markup formula: calculate profit % and target selling price
Distinguish Gross Margin ((Price - Cost) / Price) from Markup ((Price - Cost) / Cost), and price products to hit an exact target margin.
Read the guide →FinancialGross-to-net sales bridge and incremental promotional ROI example
Build a simplified sales-deduction bridge and compare estimated incremental contribution with a separately specified campaign cost.
Read the guide →Contract Theory & Corporate GovernanceGrossman-Hart-Moore Hold-Up & Ownership Formula
Calculate non-contractible relationship-specific investment e_HU = (alpha + (1 - alpha)*lambda)*(k_S/c) and quantify how asset ownership shrinks hold-up deadweight loss.
Read the guide →Asset Pricing & Information EconomicsGrossman-Stiglitz Equilibrium Informed Trader Formula
Solve Sanford Grossman & Joseph Stiglitz’s (1980) equilibrium informed-trader share lambda* and prove why costly fundamental research requires noisy market prices.
Read the guide →Lookup & ReferenceGroup arbitrary text values into P&L roll-up buckets (XLOOKUP mapping table)
Map dozens of vendor names or raw status labels into clean summary categories—with an automatic "Other" catch-all—using XLOOKUP and SUMIFS.
Read the guide →Date & TimeGroup clock times into unequal shift or restaurant daypart buckets (MOD & XLOOKUP)
Classify timestamps into uneven operational windows (Early Bird, Lunch Rush, Afternoon, Dinner, Overnight) without nested IF chains.
Read the guide →Lookup & ReferenceGroup Numbers into Pricing or Loyalty Tiers (Approximate VLOOKUP vs XLOOKUP -1)
Bucket continuous revenue, score, or age figures into named brackets without deep nested IF chains—comparing classic sorted VLOOKUP(..., TRUE) against sort-independent XLOOKUP(..., -1).
Read the guide →Lookup & ReferenceGroup numbers into uneven custom brackets (Deal size & order value cohorts)
Assign nonnegative deal values to custom lower-inclusive, upper-exclusive tiers, then summarize amounts by tier.
Read the guide →Math & TrigGroup rows into fixed-size batches (1,1,1, 2,2,2) and alternating N-row bands
Assign cohort/pallet batch IDs every N rows, cycle 1..N slot positions within each batch, and shade alternating N-row blocks.
Read the guide →Date & TimeGroup times & timestamps into unequal shift or daypart buckets (MOD & XLOOKUP)
Map irregular clock windows (e.g., 06:30 Morning, 14:00 Swing, 21:30 Night) from full date-timestamps by stripping date serials with MOD(A2, 1) and XLOOKUP(..., -1).
Read the guide →Date & TimeGroup times into 15-minute, 30-minute, or multi-hour buckets
Round call and event timestamps down to the start of any N-minute interval using FLOOR(TimeVal, Minutes / 1440).
Read the guide →StatisticalGROWTH function: fit an exponential curve y = b * m^x to positive historical series
Project compounding series along a least-squares exponential curve with GROWTH, and see why zero or negative Y values return #NUM!.
Read the guide →International Trade & Competitiveness AnalyticsGrubel-Lloyd Intra-Industry Trade & Balassa RCA Formula
Distinguish two-way variety trade via Grubel-Lloyd Index GL_i = 1 - ABS(X_i - M_i)/(X_i + M_i) from inter-industry specialization via Bela Balassa’s (1965) Revealed Comparative Advantage RCA_ij.
Read the guide →StatisticsGumbel Return-Period Quantiles and Multi-Year Exceedance Risk
Calculate an illustrative Gumbel annual-maximum quantile from a sample mean and standard deviation, and distinguish return period from the chance of an exceedance during several years.
Read the guide →Engineering & ScienceGunn-Yamada Saturated Liquid Molar Volume Correlation (V_sat)
Calculate saturated liquid molar volume V_sat = V_sc * V_R^(0)(T_r) * (1 - ω * δ(T_r)) (cm^3/mol) across 0.2 <= T_r <= 0.8 via Gunn & Yamada’s 1971 Pitzer corresponding-states polynomial.
Read the guide →