Learn one useful thing today.
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 & ScienceMoss’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 & ScienceMö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 →StatisticalMost 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 →MathMosteller 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 DesignMostinski 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 & ScienceMott-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 DistanceMOV 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 →StatisticalMoving 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 ControlMRP 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 →EngineeringMTBF, 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 & LogisticsMulti-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 & StatisticalMulti-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 & EngineeringMultinomial 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 & TrigMultiplication 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 MechanicsMurphree 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 FormulasMurray 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 DensitometryMurray-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 CreditMusic 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 AccountingMusic 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 & ScienceMuskingum 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 DesignMussa-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 →LogicalMust 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 & RestructuringMyers 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 StructureMyers-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 TheoryMyerson 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 →InformationN 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 →InformationNA 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 & ClinicalNAFLD 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 →StatisticalNaive 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 SustainabilityNAREIT 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 ConvectionNatural 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 AmpacityNeher-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 AnalysisNelson-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 ModelingNelson-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 ModelingNelson-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 OrganizationNerlove-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 →EngineeringNernst 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 & ScientificNernst 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 & ScienceNernst-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 ModelingNested 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 & ReferenceNested 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 →StatisticalNet 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 AnalysisNet 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 reportingNETWORKDAYS 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 & ScienceNeuber'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 & ScienceNeutron 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 & ScienceNeutron 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 CalculationsNew 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 & ClinicalNew 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 →