Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Network Economics & Tech Valuation

Metcalfe vs Odlyzko-Tilly Network Value & Critical Mass

Compare Metcalfe pair count N*(N - 1)/2 against Odlyzko-Tilly Zipf network value N * LN(N) and solve Rohlfs’s (1974) critical-mass tipping penetration f_crit*.

Read the guide →
Precision Dimensional Metrology, GD&T Gage Uncertainty, Calipers & CMM Probing

Metrology Cosine Error & Abbe Offset Angular Error Formula

Calculate Indicator Tilt Cosine Error E_cos (um), Ernst Abbe’s First-Principle Offset Sine/Tangent Error E_Abbe (um), Combined Systematic Gage Error (um), and Error-to-Length PPM.

Read the guide →
Clinical Medicine & Physiology

METS-IR: Formula, Units and Limits of a Metabolic Research Score

Calculate METS-IR from fasting glucose, triglycerides, HDL cholesterol and BMI, and distinguish study-specific findings from a diagnosis.

Read the guide →
Healthcare & Clinical

MEWS: Comparing a Published Five-Parameter Example

Calculate a five-parameter MEWS example using one explicitly identified published scoring table, with complete-input checks and version limits.

Read the guide →
Civil, Structural & Geotechnical Engineering

Meyer-Peter & Muller (1948) Bedload Sediment Transport Formula: Shields Excess & q_b

Calculate gravel- and coarse-sand river bedload transport intensity Phi = 8 * MAX(0, theta_prime - 0.047)^1.5 and volumetric unit bedload rate q_b (m^2/s) using Eugen Meyer-Peter and Robert Muller’s (1948, ETH Zurich) flume law.

Read the guide →
Operations, Logistics & Engineering

Meyerhof & Vesić Ultimate Bearing Capacity Formula: Exact N_q, N_c & N_gamma Strip Footing

Calculate shallow strip-footing ultimate bearing capacity q_u = c'*N_c + q*N_q + 0.5*gamma*B*N_gamma from friction angle phi' using exact Prandtl-Reissner N_q, N_c and Vesić (1973) vs. Meyerhof (1963) N_gamma.

Read the guide →
Engineering

Michaelis-Menten enzyme kinetics formula: reaction velocity v, Km & kcat

Calculate a simple Michaelis-Menten initial rate, its fraction of Vmax, and kcat from compatible enzyme concentration units.

Read the guide →
High-Speed PCB Design, RF/SerDes Controlled Impedance & IPC-2141 Microstrip Lines

Microstrip PCB Impedance (Z0) & Propagation Delay Formula

Calculate Quasi-TEM Effective Dielectric Constant epsilon_eff, IPC-2141 Microstrip Characteristic Impedance Z_0 (Ohms), Propagation Delay (ps/mm), and Phase Velocity (% of c).

Read the guide →
Cleaning imported data

MID function: extract a middle code segment while keeping leading zeros

Slice a fixed-position middle segment such as 482 or 035 out of product codes like AA-482-Z using one-based character positions.

Read the guide →
Statistical & Clinical Analysis

Miettinen Test-Based Confidence Interval Formula: OR^(1 ± z / SQRT(Chi-Square))

Reconstruct 95% confidence limits for any Odds Ratio, Risk Ratio, or Hazard Ratio published with only a point estimate and Mantel-Haenszel chi-square statistic using Olli S. Miettinen’s 1976 test-based formula OR^(1 ± z / SQRT(chi²)).

Read the guide →
Math

Mifflin-St Jeor resting energy estimate: a spreadsheet exercise

Practice the adult Mifflin-St Jeor resting-energy equation with fictional inputs and an explicitly assumed activity multiplier.

Read the guide →
Industrial Organization & Game Theory

Milgrom-Roberts Limit-Pricing Separating Formula

Calculate Paul Milgrom and John Roberts’s (1982) least-cost separating limit quantity Q_sep = MAX(Q_m(L), Q_m(H) + SQRT(Delta_H / b)), limit price P_sep, and signaling profit distortion.

Read the guide →
Treasury & Corporate Finance

Miller-Orr Stochastic Cash Control Bands: Return Point and Upper Limit

Compute the Miller-Orr cube-root cash control spread Z, asymmetric one-third return point RP = L + Z/3, and upper sweep threshold H = L + Z for volatile daily cash flows.

Read the guide →
Descriptive statistics

MIN and MAX in Excel: find the extremes and calculate the range

Use a short temperature log to find the lowest and highest readings, calculate their difference, and avoid reporting missing data as zero.

Read the guide →
Financial & Accounting

Mincer Earnings Function Formula: Return to Schooling & Concave Experience Wage Profile

Model human-capital earnings EXP(beta_0 + r_s*S + beta_1*X + beta_2*X²), marginal return to work experience (beta_1 + 2*beta_2*X), and peak-earnings career horizon X* = -beta_1 / (2*beta_2) using Jacob Mincer’s 1974 log-wage equation.

Read the guide →
Mechanical & Structural Engineering

Mindlin-Reissner Thick Circular Plate Bending + Shear Deflection

Extend Kirchhoff thin-plate formulas to thick viewports and flange blinds using Mindlin-Reissner transverse shear deflection q*R^2 / (4*kappa*G*h) and exact (h/R)^2 scaling.

Read the guide →
Healthcare & Clinical Formulas

Mini-Cog: Cognitive Screening Context and Spreadsheet Counts

Understand the limits of a brief cognitive screening instrument, find its official licensing information, and practice adding unrelated aggregate visit counts.

Read the guide →
Descriptive statistics

MINIFS and MAXIFS: find lowest and highest values by category

Compare the lowest and highest supplier quotes within one material group, and avoid mistaking a 0 unmatched result for a free quote.

Read the guide →
Statistical

Minimum value if unique: find the lowest non-tied bid and winning bidder

Disqualify tied low values and extract the smallest strictly unique number (and its owner) using COUNTIF, FILTER, MIN, and XLOOKUP.

Read the guide →
Mineral Processing & Smelter Offtake

Mining Net Smelter Return (NSR) & TC/RC Formula

Calculate Concentrate Mass Pull, Minimum-Unit-Deducted Payable Copper Grade, Smelter Value per Dry Metric Tonne of Concentrate after Treatment/Refining/Freight Charges, and Mine-Mouth NSR per Tonne Milled.

Read the guide →
Agricultural Economics & Soil Fertility

Mitscherlich-Baule Fertilizer Yield & Optimum Formula

Calculate Mitscherlich-Baule Crop Yield Y = A_max * (1 - 2^(-(N0 + N_app) / b_Baule)), Unfertilized Check Yield, Net Agronomic Profit Lift ($/ha), and Profit-Maximizing Economic Optimal Nitrogen Rate.

Read the guide →
Statistical & Clinical Analysis

MNA-SF: Older-Adult Nutrition Screening and Meal-Count Example

Learn the purpose and licensing of the Mini Nutritional Assessment short form, and practice a separate spreadsheet calculation using hypothetical meal-service counts.

Read the guide →
Numbers and totals

MOD function: calculate leftover items after filling complete packs

Find how many loose items remain when packing whole quantities into fixed-size sleeves or cartons, and check exact multiples and zero-divisor errors.

Read the guide →
Statistical

MODE.SNGL and MODE: find the most frequent number in a dataset

Identify the most common pack size or order quantity with MODE.SNGL, and handle all-unique ranges where no value repeats (#N/A).

Read the guide →
Healthcare & Clinical Calculations

Modified Aldrete Score: Five Recovery Domains and a Sum

Practice summing five already-assigned recovery domain scores and understand why postanesthesia discharge requires clinical assessment.

Read the guide →
Healthcare & Clinical Calculations

Modified CT Severity Index: Pancreatitis Imaging Score Example

Add the modified CT severity index components in a complete spreadsheet example and distinguish the imaging score from clinical severity.

Read the guide →
Financial

Modified Dietz portfolio return with day-weighted external cash flows

Calculate investment performance across mid-month deposits and withdrawals without daily portfolio valuations via R = (EMV - BMV - SUM(CF)) / (BMV + SUM(w_i * CF_i)).

Read the guide →
Healthcare & Clinical

Modified Fisher and Hunt-Hess scales: an educational spreadsheet example

Explore an illustrative Modified Fisher mapping and a separately assigned Hunt-Hess grade using fictional inputs; this is not a clinical decision tool.

Read the guide →
Financial & Accounting

Modified Internal Rate of Return (MIRR): Separate Finance & Reinvestment Rates

Compute the exact Modified Internal Rate of Return (MIRR) by discounting negative cash outflows at your cost of capital and compounding positive cash inflows at realistic treasury reinvestment rates.

Read the guide →
Forensic Accounting & Earnings Quality

Modified Jones Discretionary Accruals Formula

Calculate Dechow, Sloan, and Sweeney’s (1995) Modified Jones Non-Discretionary Accruals NDA_t and Discretionary Accruals DA_t by subtracting credit-sales receivable growth from revenue growth.

Read the guide →
Healthcare & Clinical

Modified Maddrey Discriminant Function: Formula, Units and Threshold

Calculate the modified Maddrey discriminant function from patient and control prothrombin time and total bilirubin, and interpret the 32 threshold in context.

Read the guide →
Healthcare & Clinical Calculations

Modified Sgarbossa Criteria: Understanding the ST/S Ratio

Explore the arithmetic behind a single ST/S ratio and the limits of interpreting an ECG from one number.

Read the guide →
Macroeconomics & Household Finance

Modigliani Life-Cycle Saving & Wealth-Income Formula

Calculate Franco Modigliani’s Life-Cycle Hypothesis (LCH) smoothed annual consumption C = (W_0 + N*Y)/(N + M), active-worker saving rate, and retirement peak wealth-to-income ratio.

Read the guide →
Financial

Modigliani M-Squared (M2) Return & Grinold's Fundamental Law (IC * SQRT(BR))

Calculate a hypothetical volatility-scaled return and a simplified skill/breadth model using fictional, consistently measured inputs.

Read the guide →
Engineering

Mohr-Coulomb Soil Shear Strength & Infinite-Slope Factor of Safety

Calculate a drained Mohr–Coulomb shear-strength example and, separately, an ideal dry cohesionless infinite-slope ratio.

Read the guide →
Engineering

Mohr's Circle 2D Principal Stresses (sigma_1, sigma_2) & Max Shear Stress formulas

Compute the two in-plane principal stresses and distinguish maximum in-plane shear from absolute three-dimensional maximum shear in plane stress.

Read the guide →
Engineering

Molarity (M) & lab solution bench-prep mass formula (Grams = M × L × MW)

Convert mass, molar mass and final solution volume to molarity, and calculate theoretical solute mass for a target concentration.

Read the guide →
Fracture Mechanics & Fatigue Notch Analysis

Molski-Glinka ESED Notch Strain vs Neuber Formula

Calculate Elastic Pseudo-Notch Stress K_t * S_nom, Molski-Glinka Equivalent Strain-Energy Density (ESED) Elastic-Plastic Notch Strain, Neuber Hyperbola Strain, and Plane-Stress/Plane-Strain Ratio.

Read the guide →
Engineering

Monod Bioreactor Microbial Growth, Doubling Time & Chemostat Washout

Explore Monod growth, intrinsic doubling time and the washout boundary of an ideal single-substrate chemostat without decay or biomass retention.

Read the guide →
Operations, Logistics & Engineering

Mononobe-Okabe Seismic Active Earth Pressure Coefficient (K_AE) Formula: Retaining Wall Thrust

Calculate earthquake pseudo-static retaining-wall thrust P_AE = 0.5 * gamma * H^2 * (1 - k_v) * K_AE and dynamic increment Delta_K_AE = K_AE - K_A using N. Mononobe & S. Okabe’s (1926/1929) AASHTO/Eurocode 8 wedge formula.

Read the guide →
Engineering & Science

Monostatic Radar Range Equation: Maximum Detection Range (Rmax) & Fourth-Power Law

Calculate maximum monostatic radar detection range Rmax = ((Pt * G^2 * lambda^2 * sigma) / ((4*pi)^3 * Smin))^0.25 in kilometers and echo power Pr in dBm.

Read the guide →
Engineering & Science

Monrad-Pelton Concentric Annulus Heat Transfer Formula (Double-Pipe Exchangers)

Calculate inner-wall turbulent Nusselt number Nu_i = 0.020 * Re^0.8 * Pr^(1/3) * (D_o / D_i)^0.53 in jacketed double-pipe heat exchangers.

Read the guide →
Statistical & Clinical Analysis

Morisita-Horn Overlap Index Formula: Sample-Size-Robust Community Similarity & Dissimilarity

Compare two ecological assemblages, immune TCR repertoires, or dietary niches using Henry S. Horn’s (1966) Morisita-Horn Overlap Index C_MH = 2 * SUM(p_i * q_i) / (SUM(p_i^2) + SUM(q_i^2)) on [0, 1].

Read the guide →
Offshore Wind & Marine Structural Engineering, Wave Loading

Morison Equation Offshore Pile Wave Drag & Inertia Formula

Calculate Peak Wave Drag Force Amplitude F_D (kN/m), Peak Added-Mass Inertia Force Amplitude F_I (kN/m), Naive In-Phase Sum (kN/m), and True Phase-Accurate Peak Morison Force F_max (kN/m).

Read the guide →
Healthcare & Clinical

Morse Fall Scale: Adding the Six Item Scores in a Spreadsheet

Learn how to add the six pre-scored Morse Fall Scale items with validated inputs, and understand why an individual falls assessment cannot be replaced by a total score.

Read the guide →
Labor Economics & Search Theory

Mortensen-Pissarides Beveridge Curve & Hosios Formula

Calculate Cobb-Douglas job-finding rate mu * theta^(1 - eta), vacancy-filling rate mu * theta^(-eta), Beveridge steady-state unemployment u*, and Hosios efficiency.

Read the guide →
Financial

Mortgage CPR to SMM formula: Single Monthly Mortality & pool prepayments

Convert annualized Constant Prepayment Rate (CPR) to monthly Single Monthly Mortality (SMM) and model unscheduled mortgage pool principal prepayments.

Read the guide →
Financial

Mortgage refinance break-even formula: monthly savings, payback months & net gain

Compare equal-term fixed-rate loan payments and estimate simple payment-savings payback for upfront refinancing costs.

Read the guide →
Engineering & Science

Morton Number (Mo) & Grace Diagram Gas-Bubble Fluid Property Index

Calculate the dimensionless fluid-property Morton Number Mo = g * μ_L^4 * (ρ_L - ρ_G) / (ρ_L^2 * σ^3) and Grace diagram abscissa LOG10(Mo) spanning 14 orders of magnitude from clean water (-10.6) to viscous syrups (+1.1).

Read the guide →
Science

Moseley's Law Characteristic K-Alpha X-Ray Energy & Atomic Number Z

Calculate characteristic K-alpha X-ray photon energy E_Ka = (3/4) * R_inf * (Z - 1)^2 (keV), wavelength lambda (Angstroms), and inverse elemental identification Z = 1 + SQRT(E_eV / 10.2043) for XRF/EDS spectroscopy.

Read the guide →