Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Healthcare & Clinical

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 →
Statistical

Glasgow 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 →
Healthcare

Glasgow-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 Lehr

Glass 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 Rule

Glass 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 Analysis

Glicko 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 Analytics

Global 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 Trading

Glosten-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 Engineering

Glover-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 →
Financial

GMROI 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 & Clinical

Goldman-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 & Derivatives

Goldman-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 Formulas

Gompertz 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 & Demography

Gompertz-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 & Psychometrics

Goodman 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 →
Engineering

Goodman, 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 →
Financial

Gordon 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 Performance

Gordon-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 Economics

Gordon-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 Catheterization

Gorlin 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 Valuation

GP 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 Liquidity

GP-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 Governance

GP-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 →
Statistical

GPA 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 Calculators

GRACE 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 →
Math

Grade 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 & Science

Graham’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 Transfer

Granular 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 →
Engineering

Grashof 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 →
Science

Green-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 Research

Greenshields 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 Analysis

Greenwood 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 Formulas

Greenwood’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 Adequacy

Grid 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 Reliability

Griffith 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 →
Financial

Gross 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 →
Financial

Gross-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 Governance

Grossman-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 Economics

Grossman-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 & Reference

Group 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 & Time

Group 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 & Reference

Group 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 & Reference

Group 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 & Trig

Group 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 & Time

Group 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 & Time

Group 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 →
Statistical

GROWTH 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 Analytics

Grubel-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 →
Statistics

Gumbel 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 & Science

Gunn-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 →