Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Engineering

MOSFET Drain Current (Cutoff, Triode & Saturation) & gm formulas

Model square-law NMOS transistor drain current across Cutoff (V_GS <= V_th), Triode/Linear (V_DS < V_OV), and Saturation (V_DS >= V_OV) with IFS plus transconductance g_m.

Read the guide →
Engineering & Science

Moss’s Rule: Semiconductor Refractive Index From Bandgap (n^4 * Eg = 95 eV)

Estimate infrared semiconductor refractive index n = (95 / E_g)^0.25, high-frequency dielectric constant eps_inf = n^2, and normal-incidence Fresnel air-interface reflectance R (%) from optical bandgap E_g (eV).

Read the guide →
Engineering & Science

Mössbauer Spectroscopy: Free-Nucleus Recoil Energy & Doppler Velocity

Calculate free-nucleus gamma-ray recoil energy E_R = E_gamma^2 / (2 * M * c^2) (meV) and Mössbauer spectrometer linear Doppler velocity v = (Delta_E / E_gamma) * c (mm/s) for 57Fe isomer shifts and hyperfine splitting.

Read the guide →
Statistical

Most frequent text value with criteria: top ticket reason by region

Find the #1 recurring text label (defect code, ticket category, or top SKU) within a chosen department or region using COUNTIFS + masked XLOOKUP.

Read the guide →
Math

Mosteller Body Surface Area (BSA) & Cockcroft-Gault Creatinine Clearance (CrCl)

Spreadsheet arithmetic examples for Mosteller BSA and the historical Cockcroft–Gault estimate using fictional adult inputs; not a drug-dosing recommendation.

Read the guide →
Process Heat Transfer, Distillation Reboilers & Phase-Change Design

Mostinski Reduced-Pressure Kettle Reboiler Boiling h & CHF Formula

Calculate Reduced Pressure P_r = P / P_c, Mostinski Pressure Factor F_p, Nucleate Pool-Boiling Coefficient h_nb (W/m²·K), and Mostinski Maximum Critical Heat Flux q_crit (kW/m²).

Read the guide →
Engineering & Science

Mott-Gurney Space-Charge-Limited Current (SCLC) Law for OLEDs & Perovskites

Calculate trap-free solid-state space-charge-limited current density J = (9/8) * eps_r * eps_0 * mu * (V^2 / L^3) (A/m^2) to extract carrier mobility in organic OLEDs, polymers, and halide perovskites.

Read the guide →
High-Voltage Insulation Coordination, IEEE C62.22 MOV Arrester BIL & Separation Distance

MOV Surge Arrester BIL Margin & Separation Formula

Calculate Traveling-Wave Reflected Transformer Terminal Voltage Vt (kV), IEEE C62.22 Protective Ratio (BIL / Vt), Insulation Margin (%), and Maximum Safe Arrester Separation Lmax (m).

Read the guide →
Statistical

Moving average formula: smooth noisy weekly data with a trailing N-period window

Calculate a dynamic trailing N-period moving average with TAKE and AVERAGE, and emit NA() on incomplete warm-up rows.

Read the guide →
ERP Supply-Chain Planning & Inventory Control

MRP Gross-to-Net & Lot-Multiple Planned Order Formula

Calculate Joseph Orlicky’s MRP Unreplenished Projected Balance, Safety-Stock-Protected Net Requirement MAX(0, Gross + Safety_Stock - On_Hand - Scheduled_Receipts), Lot-Multiple Planned Order Receipt, and Ending On-Hand Inventory.

Read the guide →
Engineering

MTBF, MTTR, System Availability & SLA "Nines" downtime budget formulas

Calculate observed availability and a time-based downtime budget for the supplied window. Distinguish sample repair statistics from future reliability and contractual SLA rules.

Read the guide →
Operations & Logistics

Multi-Sheet Inventory Reconciliation: ERP Book Stock, In-Transit Transfers & Shrinkage Audit

Reconcile ERP ledger balances against physical warehouse cycle counts by netting outbound in-transit stock, computing unit and dollar shrinkage variances, and flagging material recount exceptions.

Read the guide →
Math & Statistical

Multi-Step AI Spreadsheet Commands: Sheets, Rows/Columns, Charts & Role-Aware Sharing

Chain up to 10 ordered workbook steps (create/rename/select sheets, insert/delete rows or columns, populate formulas, and build charts) in Arte Sheets while keeping collaborator invitations gated behind explicit owner confirmation.

Read the guide →
Math & Engineering

Multinomial Coefficient Formula: Group Partitions & Repeated-Item Permutations (FACT)

Calculate the exact multinomial coefficient (n1 + n2 + ... + nk)! / (n1! * n2! * ... * nk) using FACT and SUM to count ordered squad assignments, categorical outcomes, and word anagrams.

Read the guide →
Math & Trig

Multiplication table & 2D SaaS seat-pricing matrix ($A3 * B$1 vs spilled array)

Generate a 2D outer-product matrix with either classic mixed references ($A3 * B$1) or a single spilled dynamic-array formula (A3:A5 * B1:D1).

Read the guide →
Engineering & Fluid Mechanics

Murphree Vapor Tray Efficiency (E_MV) Formula: Single-Stage Mass Transfer & Pseudo-Equilibrium

Evaluate single-plate distillation and gas-absorption performance using Eger V. Murphree’s 1925 vapor efficiency E_MV = (y_n - y_(n+1)) / (y_n* - y_(n+1)) and step off actual tray outlet compositions y_n = y_(n+1) + E_MV * (y_n* - y_(n+1)).

Read the guide →
Healthcare & Clinical Formulas

Murray Lung Injury Score: Four-Component Average

Explore the arithmetic behind four historical lung-injury grades and the limitations of interpreting the average.

Read the guide →
Commercial Offset/Flexo Printing, ISO 12647 Colorimetry & Pressroom Densitometry

Murray-Davies Halftone Dot Area & Dot Gain (TVI) Formula

Calculate Tint Patch Paper-Relative Reflectance R_t (%), Solid-Ink Patch Reflectance R_s (%), Murray-Davies Apparent Printed Dot Area (%A), and Tone Value Increase / Dot Gain TVI (%).

Read the guide →
Music IP Royalties, Entertainment M&A & Alternative Credit

Music Catalog Net Publisher’s Share (NPS) Valuation Formula

Calculate Music IP Post-Administration Net Receipts, Investor Net Publisher’s Share (NPS) / Net Label Share After Writer Payables, Catalog Acquisition Valuation (NPS * Multiple), and Implied Unlevered Royalty Yield.

Read the guide →
Media, Music & Royalty Accounting

Music Streaming Royalty & Advance Recoupment Formula

Calculate Pro-Rata DSP Master Royalty Pool Payout, Contractual Artist Royalty Credited, Remaining Unrecouped Label Advance, and Payable Artist Cash Royalty.

Read the guide →
Engineering & Science

Muskingum River Flood Routing: C1, C2, C3 Coefficients & Routed Outflow (Q2)

Route upstream flood hydrographs through natural river reaches using McCarthy's Muskingum storage equation Q2 = C1*I2 + C2*I1 + C3*Q1 with automatic Courant/sub-interval stability guard 2*K*X <= dt <= 2*K*(1 - X).

Read the guide →
SaaS Pricing & Mechanism Design

Mussa-Rosen SaaS Versioning & Information Rent Formula

Calculate Incentive-Compatible Basic Price P_L = theta_L * q_L, High-Type Information Rent (theta_H - theta_L) * q_L, Enterprise Tier Price P_H = theta_H * q_H - Rent_H, and Total Versioning Revenue.

Read the guide →
Logical

Must pass K out of N subjects or checks (quorum and floor rule)

Evaluate multi-part exams, vendor scorecards, or board quorums requiring at least K passing scores plus a minimum floor on every item.

Read the guide →
Corporate Finance & Restructuring

Myers Debt-Overhang Underinvestment NPV Hurdle Formula

Quantify senior-creditor wealth transfer, shareholder net NPV Delta_E, and Stewart Myers’s (1977) debt-overhang hurdle NPV_min = I * (1 - p_G) / p_G.

Read the guide →
Corporate Finance & Capital Structure

Myers-Majluf Equity Issuance & Pecking Order Formula

Calculate Stewart Myers and Nicholas Majluf’s (1984) pooled equity-issuance dilution loss on undervalued high-state firms and prove why internal cash and riskless debt beat seasoned equity.

Read the guide →
Mechanism Design & Auction Theory

Myerson Optimal Auction Virtual Valuation and Reserve Price Formula

Calculate Myerson’s (1981) virtual valuation psi(v) = 2*v - H, optimal bidder-count-invariant reserve price r* = (v_0 + H) / 2, and expected Vickrey auction seller payoff.

Read the guide →
Information

N function: convert TRUE/FALSE to 1/0 and embed inline formula comments

Turn logical checkboxes into 1/0 numbers and document complex formulas inline with + N("explanation") using N.

Read the guide →
Information

NA function: output #N/A intentionally so line charts skip missing periods

Mark missing readings with NA(), distinguish them from zero, and understand chart-specific handling before plotting.

Read the guide →
Healthcare & Clinical

NAFLD Fibrosis Score: historical equation and limitations

Practice the historical NAFLD Fibrosis Score equation using fictional inputs, with its units, study context and modern guidance.

Read the guide →
Statistical

Naive forecast accuracy: WMAPE and row percentage errors

Benchmark any demand forecast against a Naïve (Yt-1) baseline using Mean Absolute Percentage Error (MAPE) and volume-weighted WMAPE.

Read the guide →
Equity REIT Analysis, Real Estate Accounting & Dividend Sustainability

NAREIT FFO, AFFO & True Dividend Payout Ratio Formula

Calculate Equity REIT NAREIT Funds From Operations (FFO), Adjusted Funds From Operations (AFFO) After Straight-Line Rent Accruals and Recurring TI/LC Maintenance Capex, Headline FFO Payout Ratio, and True Cash AFFO Payout Ratio.

Read the guide →
Heat Transfer, Electronics Thermal Management & Passive Natural Convection

Natural Convection Rayleigh & Churchill-Chu Nusselt Formula

Calculate Vertical Heatsink / Enclosure Plate Laminar Rayleigh Number Ra_L, Exact Churchill-Chu Laminar Nusselt Number Nu_L in Air (Pr = 0.71), Natural-Convection Heat-Transfer Coefficient h (W/m²·K), and Passive Heat Dissipation Q (W).

Read the guide →
High-Voltage Transmission & Substation Duct Banks, NEC 310.15(C) Neher-McGrath Ampacity

Neher-McGrath Underground Cable Ampacity Formula

Calculate AC Skin/Proximity Conductor Resistance Rac (mOhm/m), Available Conductor Thermal Headroom (K), Maximum Continuous Ampacity Imax (A), and Joule Heat Load (W/m).

Read the guide →
Statistical Analysis

Nelson-Aalen Cumulative Hazard H(t), Aalen Variance & Fleming-Harrington Survival

Estimate nonparametric cumulative failure hazard H(t) = SUM(d_i / n_i), Aalen standard error SQRT(SUM(d_i / n_i^2)), and exponential survival S_FH(t) = EXP(-H(t)) on right-censored cohorts.

Read the guide →
Financial Modeling

Nelson-Siegel Yield Curve Model: Level, Slope & Curvature Spot & Forward Rates

Fit parsimonious sovereign and corporate spot yield curves across any maturity tau using Charles Nelson and Andrew Siegel’s (1987) four-parameter level, slope, and medium-term hump loadings.

Read the guide →
Financial Modeling

Nelson-Siegel-Svensson (NSS) 4-Factor Yield Curve & Second Curvature Hump

Extend 4-parameter Nelson-Siegel with Lars Svensson’s (1994) second curvature loading beta_3 and decay tau_2 used by the ECB and Bundesbank to fit 10Y–30Y sovereign convexity.

Read the guide →
Marketing Science & Industrial Organization

Nerlove-Arrow Advertising Goodwill Stock Formula

Generalize Dorfman-Steiner to durable brand equity dG/dt = a - delta*G using Marc Nerlove and Kenneth Arrow’s (1962) dynamic goodwill-to-sales rule G* / (P*Q) = beta_G / (epsilon_P * (r + delta)).

Read the guide →
Engineering

Nernst equation: electrochemical cell potential and reaction quotient

Calculate a reversible cell potential from a supplied standard potential, temperature and dimensionless activity-based reaction quotient.

Read the guide →
Engineering & Scientific

Nernst Equilibrium (Reversal) Potential & Electrochemical Driving Force

Compute ion reversal potential E_ion = (R*T / (z*F)) * LN([X]_out / [X]_in) in millivolts across temperature and valence, plus net transmembrane driving force V_m - E_ion.

Read the guide →
Engineering & Science

Nernst-Planck Electrodiffusion Equation: Fickian Diffusion + Electric Migration Flux

Calculate total ionic molar flux J_i = -D_i * (dC/dx + ((z_i * F) / (R * T)) * C * (dPhi/dx)) in umol/(m^2*s) across PEM fuel cells, Li-ion electrolytes, and biological ion channels.

Read the guide →
Econometrics & Discrete Choice Modeling

Nested Logit Inclusive Value (Logsum) and IIA Paradox Formula

Resolve Multinomial Logit’s Red-Bus/Blue-Bus IIA paradox using McFadden’s Nested Logit inclusive value IV = LN(SUM EXP(V_j / lambda)) and Random Utility consistency check 0 < lambda <= 1.

Read the guide →
Lookup & Reference

Nested VLOOKUP & Chained XLOOKUP: Two-Hop Crosswalk Mapping Formula

Translate legacy ERP or vendor codes through an intermediate crosswalk bridge table into master pricing using IFNA(VLOOKUP(VLOOKUP(G2, A2:B5, 2, FALSE), D2:E5, 2, FALSE), "Unmapped Code") or chained XLOOKUP.

Read the guide →
Statistical

Net Promoter Score (NPS) & CSAT Top-2-Box formulas with COUNTIF

Calculate NPS including passive respondents and a 1–5 top-two-box CSAT percentage from a validated eight-response sample.

Read the guide →
Statistical & Clinical Analysis

Net Reclassification Improvement (NRI) & Integrated Discrimination Improvement (IDI)

Evaluate Michael Pencina’s biomarker incremental value metrics: additive Event + Non-Event NRI and probability-slope separation gain IDI = (IS_new - IS_old).

Read the guide →
Dates and reporting

NETWORKDAYS function: count working days excluding holidays

Count Monday-to-Friday working days between a start and end date inclusively, deducting weekday closures from a holiday range without double-counting weekend holidays.

Read the guide →
Engineering & Science

Neuber's Rule: Local Elastic-Plastic Notch Stress & Strain Concentration

Calculate the Neuber hyperbola product sigma * epsilon = (Kt * S)^2 / E (MPa) at geometric stress raisers and solve local notch-root total strain under elastic-perfectly-plastic yielding.

Read the guide →
Engineering & Science

Neutron Star Compactness (2GM/Rc^2), Gravitational Redshift & Buchdahl Limit

Calculate general-relativistic stellar compactness Xi = (2 * G * M) / (R * c^2), exact Schwarzschild surface gravitational redshift z_grav = ((1 - Xi)^-0.5) - 1, and verify Buchdahl's stability bound Xi < 8/9.

Read the guide →
Engineering & Science

Neutron Star Relativistic Compactness (Ξ), Surface Redshift & Buchdahl Limit

Calculate general-relativistic compactness Ξ = G*M / (R*c^2), NICER X-ray surface gravitational redshift z_surf = (1 - 2*Ξ)^(-1/2) - 1, and Hans Buchdahl’s Ξ < 4/9 collapse limit.

Read the guide →
Healthcare & Clinical Calculations

New Ballard Score: Gestational Age Estimates and Their Limits

Learn what the New Ballard assessment estimates, why completed weeks are reported, and why the result cannot provide an exact gestational age.

Read the guide →
Healthcare & Clinical

New Orleans Head-Injury Criteria: Scope and Spreadsheet Logic

Review the seven published findings and the limits of a spreadsheet example; head imaging decisions require clinical assessment.

Read the guide →