Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Statistical & Clinical Analysis

Newcombe Hybrid Wilson Score Confidence Interval for Two-Proportion Risk Difference

Construct boundary-respecting 95% confidence limits for independent risk difference RD = p_1 - p_2 using Robert Newcombe’s (1998) Method 10 square-and-add Wilson score intervals.

Read the guide →
Time-Series Econometrics & Forecasting

Newey-West Bartlett HAC Long-Run Variance and Standard Error Formula

Correct serially correlated regression or sample-mean standard errors using Newey and West’s (1987) Bartlett-kernel triangular weights w_j = 1 - j / (L + 1) that guarantee positive variance.

Read the guide →
Network Science & Graph Analytics

Newman-Girvan Network Modularity Q Partition Formula

Evaluate graph community clustering via Mark Newman and Michelle Girvan’s (2004) Modularity Q = SUM_c(e_cc - a_c^2) comparing intra-community edge share against the degree-preserving configuration null model.

Read the guide →
Civil, Structural & Geotechnical Engineering

Newmark Seismic Sliding-Block Formula: Yield Acceleration k_y & Permanent Slope Displacement

Evaluate earthquake slope performance beyond pseudo-static failure using Nathan M. Newmark’s (1965) Critical Yield Acceleration k_y = (FS_static - 1) * SIN(beta) and Ambraseys-Menu permanent co-seismic displacement D_N (cm).

Read the guide →
Statistical

NEWS2 Scale 1 spreadsheet exercise: scoring bands and single-parameter triggers

Practice IF and IFS with fictional NEWS2 Scale 1 observations, explicit input validation and the separate single-parameter three-point trigger.

Read the guide →
Statistical

Newsvendor model formula: Critical Fractile & optimal perishable stock level

Calculate a single-period critical fractile and select an order quantity from five equally likely demand scenarios. Distinguish empirical demand quantiles from interpolated percentiles.

Read the guide →
Engineering

Newton's Law of Cooling formula: transient temperature & time to cool

Calculate temperature and target time in a constant-ambient, constant-rate lumped cooling or warming model, with explicit reachability checks.

Read the guide →
Date & Time

Next & Previous Working Day: Strict Step vs. Same-or-Next Business Day Roll

Calculate strictly next/previous working days and roll-forward/roll-backward settlement dates that preserve valid business days while skipping weekends and holidays via WORKDAY.

Read the guide →
Date & Time

Next Biweekly Payday from Any Date formula (14-Day Anchor + CEILING.MATH)

Find the next date on or after a query date in a fixed 14-day schedule anchored to a known date.

Read the guide →
Date & Time

Next business day N months in the future (EDATE + WORKDAY "-1, +1" trick)

Shift a date by whole months, then keep it if it is a working day or roll forward using a supplied holiday list and Saturday–Sunday weekends.

Read the guide →
Date & Time

Next work anniversary date and completed years of service

Calculate completed employee tenure, exact upcoming anniversary date (leap-day safe), and 5-year service award milestones.

Read the guide →
Healthcare & Clinical

NEXUS Cervical Spine Criteria: Five Flags and Their Limits

Explore a spreadsheet count of five pre-assessed NEXUS findings, and understand why the result cannot independently clear a neck injury or determine imaging.

Read the guide →
Statistical

NFL Quarterback Passer Rating formula (0 to 158.3 Official Scale)

Calculate NFL passer rating with four clamped components and compare it with adjusted yards per attempt (AY/A).

Read the guide →
Underground Caverns, Drill-and-Blast Tunneling & NATM, NGI Barton Q-System

NGI Barton Tunneling Q-System & Roof Support Formula

Calculate Logarithmic NGI Rock Mass Quality Q (0.001–1,000), Equivalent Excavation Dimension De (m), Maximum Permanent Unsupported Span (m), and Crown Support Pressure (kPa).

Read the guide →
Precision Aerospace & Optical Tooling, Nickel Sulfamate Electroforming & Throwing Power

Nickel Electroforming Wall Rate & Haring-Blum Throwing Power

Calculate Faraday Nickel Deposition Rate (um/h), Electroformed Mandrel Shell Thickness (um and mm), and Field-Modified Haring-Blum Throwing Power (%).

Read the guide →
Panel Econometrics & Time Series

Nickell Dynamic Panel Fixed-Effects Bias Formula (Short-T Audit)

Quantify exact Nickell (1981) downward Fixed-Effects bias in dynamic AR(1) panels y_it = alpha_i + rho*yi,t-1 + u_it to decide when Arellano-Bond GMM is required.

Read the guide →
Healthcare & Clinical

NIH Stroke Scale: Understand the Score and Practice a Sum

Learn what the NIH Stroke Scale measures and practice a grouped point total while recognizing its clinical limitations.

Read the guide →
Operations

NIOSH Lifting Equation: Recommended Weight Limit (RWL) & Lifting Index

Use supplied task multipliers to calculate a NIOSH recommended weight limit and numerical lifting index. Validate inputs and preserve precision without presenting a personal safe-lifting guarantee.

Read the guide →
Financial

NOMINAL function: convert effective APY back to a stated annual rate (APR)

Find the stated nominal APR needed to hit a target effective annual yield under monthly or quarterly compounding using NOMINAL.

Read the guide →
Math & Statistical

Non-Volatile Dynamic N-Period Sum & Average Without OFFSET (SUMIFS & AVERAGEIFS)

Replace slow volatile SUM(OFFSET(B2,0,0,N,1)) rolling windows with dependency-tracked SUMIFS(B2:B7, A2:A7, "<=" & E2) and AVERAGEIFS for instant multi-sheet recalculation.

Read the guide →
Charts & Visual Data

Normal Distribution Bell Curve Formula: Exact Gaussian PDF Ordinate & Sigma Grid

Generate smooth XY Scatter Bell Curve coordinates for any mean mu and standard deviation sigma using the universal closed-form Gaussian density formula (1 / (sigma * SQRT(2*PI()))) * EXP(-0.5 * z^2).

Read the guide →
Statistical & Clinical Analysis

Normal Q-Q & Probability Plot Formula: Blom Plotting Position & Theoretical Z-Quantile

Build a Normal Q-Q (Quantile-Quantile) and Normal Probability Plot table from sorted sample data: compute Blom’s unbiased plotting position p_r = (r - 0.375) / (n + 0.25) and Tukey’s closed-form standard normal quantile z_r.

Read the guide →
Engineering & Science

Normal Zeeman Effect: Bohr Magneton Energy & Spectral Wavelength Splitting

Calculate Zeeman magnetic sublevel energy splitting delta_E = mu_B * B (in micro-electronvolts, mu_B = 57.8838 ueV/T) and Lorentz triplet wavelength shift delta_lambda = 4.66864e-5 * B * lambda_0^2 (in picometers).

Read the guide →
Statistical

Normalize data between 0 and 1 (Min-Max scaling vs Z-score)

Rescale disparate KPIs onto a common 0–1 (or 0–100) scale with (x - MIN) / (MAX - MIN) or standardize into Z-scores.

Read the guide →
Text & String Formulas

Normalize Dirty Text Keys: Strip CHAR(160), Control Codes & Case (CLEAN & TRIM)

Sanitize web-scraped and ERP-exported lookup keys via LOWER(TRIM(CLEAN(SUBSTITUTE(A2, CHAR(160), " ")))) so invisible HTML non-breaking spaces and line breaks stop breaking XLOOKUP and VLOOKUP.

Read the guide →
Text & Cleaning

Normalize Noisy Vendor & Bank-Feed Strings via Keyword Mapping (SEARCH & IFS)

Map messy corporate card and bank-feed descriptions containing terminal IDs, asterisks, and city suffixes to canonical vendor names using ordered ISNUMBER(SEARCH(...)) rules and SUMIF spend rollups.

Read the guide →
Lookup & Reference

Normalize storage units: binary KiB/MiB/GiB/TiB versus decimal GB

Use powers of 1024 for IEC binary units and powers of 1000 for decimal SI units; keep the two conventions distinct.

Read the guide →
Electronics Packaging Reliability, IPC-9701 / JEDEC Norris-Landzberg BGA Fatigue

Norris-Landzberg BGA Solder Thermal Acceleration Formula

Calculate CTE Strain-Range Multiplier (dT_test/dT_field)^1.9, Creep Frequency-Arrhenius Factor, Total Acceleration Factor AF, and Equivalent Field Service Life (years).

Read the guide →
Food Engineering & Microbial Hurdle Safety

Norrish Humectant Water Activity (aw) Formula

Calculate Ideal Raoult Water Mole Fraction x_w, Norrish Non-Ideal Sugar/Humectant Water Activity a_w = x_w * EXP(-K * x_s^2), Hydrogen-Bonding Depression, and FDA aw <= 0.85 Pathogen Hurdle status.

Read the guide →
Healthcare & Clinical Calculations

Norton Pressure Ulcer Risk Scale: Context and Summing Example

Understand the context and limitations of the Norton scale and practice validating and adding five whole-number scores in a separate exercise.

Read the guide →
Logical

NOT function: invert TRUE/FALSE and exclude blocked statuses cleanly

Negate logical tests and multi-value exclusion lists with NOT(OR(...)) so dispatch and approval rules stay easy to audit.

Read the guide →
Date & Time

NOW function: compare live timestamps and add hours to the current time

Understand how NOW stores the current date and time as a serial number + decimal fraction, how it differs from TODAY, and why it recalculates on edit.

Read the guide →
Financial

NPER function: calculate how many months it takes to pay off a loan

Find the number of payment periods needed to clear a balance with NPER, match monthly rate and cash-flow signs, and guard payments below monthly interest.

Read the guide →
Financial analysis

NPV function: keep the day-zero investment outside NPV

NPV discounts its first cash-flow argument by one full period. Add the initial day-zero outlay outside NPV(rate, Year1:YearN) so present value is never misstated.

Read the guide →
Clinical Medicine & Physiology

NRS-2002: Hospital Nutrition Screening Score and Context

Add pre-assessed nutrition and disease subscores and an age adjustment in an educational NRS-2002 example, with context about screening and follow-up.

Read the guide →
Engineering & Science

NRTL (Non-Random Two-Liquid) VLE & LLE Activity Coefficients

Calculate Henri Renon and John Prausnitz’s 3-parameter NRTL activity coefficients gamma_1 and gamma_2 using energy parameters tau_12, tau_21 and non-randomness factor alpha_12 for partially miscible liquid-liquid and azeotropic VLE mixtures.

Read the guide →
Embedded Sensors, Battery BMS & Thermal Management

NTC Thermistor Beta & Steinhart-Hart Divider Formula

Calculate Microcontroller Pull-Up Voltage Divider Output V_adc = V_ref * R_ntc / (R_pull + R_ntc), Log Resistance Ratio LN(R_ntc / R_25), Absolute Kelvin Temperature 1 / (1/298.15 + LN(R/R_25)/Beta), and Celsius Temperature.

Read the guide →
Statistical

Nth largest value without duplicates: dense Gold, Silver, Bronze tiers

Wrap UNIQUE inside LARGE(UNIQUE(Range), N) so tied top scores do not swallow 2nd and 3rd place prize tiers.

Read the guide →
Statistical

Nth Smallest Value with Criteria & Highlight Bottom K Bids (SMALL + FILTER)

Find the kth lowest bid in a category and flag all bids at or below that cutoff, with explicit tie handling and validation of K and matching bid data.

Read the guide →
Date & Time

Number of workdays in a month (and remaining business days)

Count total business days in any month and remaining working days to month-end excluding weekends and holidays with NETWORKDAYS.

Read the guide →
Engineering & Science

Nusselt Laminar Film Condensation Coefficient on a Vertical Wall (h̄)

Calculate the mean condensing heat-transfer coefficient h̄ = 0.943 * ((ρ_l * (ρ_l - ρ_v) * g * h_fg * k_l^3) / (μ_l * L * ΔT))^0.25 (W/(m^2·K)) for vertical condenser tubes.

Read the guide →
Engineering

Nyquist Sampling Rate, Folded Alias Frequency & ADC SNR / ENOB formulas

Calculate a single-tone folded frequency, the twice-bandwidth Nyquist boundary, ideal full-scale sine quantization SNR and SINAD-derived ENOB.

Read the guide →
Biostatistics & Clinical Trials

O’Brien-Fleming vs Pocock Group-Sequential Interim Boundary Formula

Compute O’Brien-Fleming information-scaled critical Z boundaries and Lan-DeMets cumulative alpha spending alpha*(t) across interim Data Monitoring Committee looks.

Read the guide →
Chemical, Process & Catalysis Engineering

O’Connell Overall Distillation Tray Efficiency Formula & Actual Tray Count N_act

Convert theoretical equilibrium stages into actual sieve/valve trays using H. E. O’Connell’s (1946, AIChE) Overall Column Efficiency correlation E_0 (%) = 50.3 * (alpha * mu_L)^(-0.226) and Actual Tray Count -INT(-N_th / (E_0 / 100)).

Read the guide →
Engineering & Fluid Mechanics

O’Connell Tray Efficiency Correlation Formula: Actual vs. Theoretical Distillation Plates

Convert equilibrium McCabe-Thiele / Fenske-Underwood-Gilliland distillation stages N_eq into actual column trays N_actual = ROUNDUP(N_eq / E_o, 0) using H. E. O’Connell’s correlation E_o (%) = 50.3 * (mu_L * alpha)^(-0.226).

Read the guide →
Healthcare & Clinical Calculators

OABSS: Adding Four Symptom Subscores in a Spreadsheet

Add pre-scored items for the Overactive Bladder Symptom Score and understand why symptom thresholds alone do not establish a diagnosis.

Read the guide →
Healthcare & Clinical Calculations

Oakland Score Research: Seven Components and a Point Sum

Review the components of a lower gastrointestinal bleeding research score and practice adding already-assigned points.

Read the guide →
Statistical & Clinical Analysis

Oaxaca-Blinder Decomposition Formula: Explained Endowment vs. Unexplained Pay Gap

Decompose mean log-wage differentials (Y_A - Y_B) into Explained Endowment differences (X_A - X_B) * beta_A and Unexplained Coefficient/Return differences using Ronald Oaxaca & Alan Blinder’s 1973 counterfactual identity.

Read the guide →
Engineering

Oblique Shock Theta-Beta-Mach Wedge Deflection & Normal Mach Formula

Calculate supersonic wedge deflection angle theta (degrees) from upstream Mach M_1 and shock wave angle beta using the exact Theta-Beta-Mach relation, plus normal Mach component M_n1 = M_1 * SIN(beta).

Read the guide →
Engineering & Science

Ocean Ekman Spiral Depth (DE) & Wind-Driven Ekman Transport Formula

Calculate Vagn Walfrid Ekman’s turbulent upper-ocean boundary layer thickness D_E = PI() * SQRT((2 * A_z) / |f|) (m) and depth-integrated 90°-deflected Ekman mass transport M_E = tau_wind / |f| (kg/(m*s)).

Read the guide →