Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Marine Terminal & LNG Berth Engineering, OCIMF MEG4 Mooring Wind/Current & %MBL

OCIMF Vessel Mooring Wind, Current & Hawser %MBL Formula

Calculate Aerodynamic Wind Load (kN), Seawater Tidal Current Drag (kN), Combined Environmental Surge/Sway Force (kN), and Hawser Tension as % of Ship Design MBL.

Read the guide →
Financial

Odd Stub-Period Bond Clean Price and Implied Yield (ODDFPRICE & ODDLPRICE Valuation)

Value bonds with irregular short or long final/initial coupon periods using money-market stub discounting, accrued-interest deduction, and inverse stub yield.

Read the guide →
Math & Trig

Odometer gas mileage log: calculate MPG, L/100 km, and cost per mile

Compute trip distance from consecutive odometer readings, fuel efficiency in MPG and metric L/100 km, and fuel cost per mile.

Read the guide →
Statistical

OEE formula: Availability x Performance x Quality (manufacturing KPI)

Calculate Overall Equipment Effectiveness (OEE) and reconcile the 3-factor loss breakdown against direct (GoodUnits * IdealCycleTime) / PlannedProductionTime.

Read the guide →
Lookup & Reference

OFFSET function: sum a dynamic trailing N-month window

Build a resizable range reference from an anchor cell with OFFSET(ref, rows, cols, height, width), and avoid out-of-bounds #REF! errors.

Read the guide →
Charts & Visual Data Modeling

Ogive Graph Formula: Cumulative Frequency %, Upper Class Boundaries & Grouped Median

Build a "Less-Than" Ogive cumulative frequency curve: plot Cumulative % against Upper Class Boundaries (starting at 0% at the first Lower Boundary) and compute the linearly interpolated Grouped Percentile / Median.

Read the guide →
Equity Valuation & Accounting Theory

Ohlson Linear Information Dynamics Valuation Formula

Calculate James Ohlson’s (1995) closed-form equity value P_t = B_t + alpha_1 * x_t^a + alpha_2 * v_t combining clean-surplus book value, abnormal earnings persistence omega, and forward information v_t.

Read the guide →
Finance

Ohlson O-Score: Nine-Factor Logit Calculation in a Spreadsheet

Calculate a commonly reproduced Ohlson nine-factor linear score and its logistic transform, while distinguishing historical model output from a calibrated current bankruptcy forecast.

Read the guide →
Engineering

Ohm's Law, electrical power (Watts), and parallel resistance formulas

Calculate Current (V / R), Power dissipation (V^2 / R and I^2 * R), and Series vs Parallel equivalent resistance 1 / SUM(1 / R_range).

Read the guide →
Wellbore Zonal Isolation & Primary Cementing, API Spec 10A Absolute-Volume Slurry Design

Oilwell Primary Cementing Slurry Yield & Sack Count Formula

Calculate API Absolute-Volume Slurry Yield (ft³/sack), Mixed Slurry Density (ppg), Required Bulk Cement Sacks Including Open-Hole Washout Excess, and Total Mix Water (bbl).

Read the guide →
Cellular RF Planning & Wireless Propagation Modeling

Okumura-Hata Urban Macro-Cell Path Loss Formula

Calculate Masaharu Hata’s Empirical Urban Macro-Cell Mobile Height Correction a(h_m), Distance Path-Loss Slope 44.9 - 6.55*LOG10(h_b), Total Median Path Loss L_urban (dB), and Cell-Edge Received Signal Power (dBm).

Read the guide →
Macroeconomics & Business Cycle Forecasting

Okun’s Law Output Gap & Unemployment Change Formula

Calculate the Okun’s Law percentage GDP output gap -beta * (u - u*), lost dollar GDP, and growth-rate unemployment change Delta_u = -(1/beta) * (g_Y - g_Y*).

Read the guide →
Public Choice & Institutional Economics

Olson Collective Action Free-Rider Threshold Formula

Calculate Mancur Olson’s Privileged-Group Critical Benefit Share v_crit = C_pub / V_tot, Anchor Stakeholder Unilateral Net Surplus, Selective-Incentive Dues Gap, and Privileged vs Latent Group regime.

Read the guide →
Financial

Omega Ratio & Ulcer Index drawdown risk formulas for skewed portfolios

Evaluate non-normal return distributions via Keating-Shadwick Omega Ratio SUM(MAX(0, R - MAR)) / SUM(MAX(0, MAR - R)) and Martin's RMS drawdown Ulcer Index.

Read the guide →
Chemical, Process & Catalysis Engineering

Onda (1968) Packed-Column Wetted Surface Area (a_w) Formula: Surface Tension & HTU

Calculate effective liquid-wetted interfacial area a_w (m^2/m^3) in random-packed gas absorbers and air strippers using Kakusaburo Onda, Hiroshi Takeuchi & Yoshio Okumoto’s (1968) dimensionless Reynolds-Froude-Weber-Capillary correlation.

Read the guide →
Logical & Validation

One or the Other, Not Both: Exclusive OR (XOR) & Multi-Option Mutual Exclusion

Validate mutually exclusive promotional discounts or approval paths with two-argument XOR, and avoid the 3-argument odd-parity trap using boolean sum equality.

Read the guide →
Financial

One-asset Black-Litterman example: blend a prior and one absolute view

Explore a scalar normal-prior update with one absolute return view; distinguish uncertainty in the estimated mean from asset return variance.

Read the guide →
Clinical Pharmacokinetics & Biopharmaceutics

One-Compartment IV Bolus Model: A Pharmacokinetic Arithmetic Example

Explore elimination, half-life, apparent volume and clearance under a stated one-compartment model using invented sample values.

Read the guide →
Math

One-Rep Max (1RM) Epley & Brzycki strength formulas + 2.5 kg plate rounding

Estimate 1-Rep Max from submaximal sets using Epley W*(1 + Reps/30) and Brzycki W*36/(37 - Reps), plus nearest -2.5-kg training load rounding.

Read the guide →
Statistical

One-Way ANOVA formula: Between-Group vs Within-Group F-statistic

Test whether three or more group means differ significantly by computing SS_Between, SS_Within, Mean Squares, and the One-Way ANOVA F-ratio directly in cells.

Read the guide →
Logical & Conditional

Only Calculate If Input Cells Are Not Blank (COUNTA & ISBLANK Gate)

Suppress premature $0.00 totals, negative margins, or #DIV/0! errors on partially entered invoice and quote rows using IF(COUNTA(B2:D2) < 3, "", ...) so formulas stay blank until every required input is entered.

Read the guide →
Statistical & Clinical Analysis

Onodera prognostic nutritional index: formula and limitations

Practice the historical Onodera index using albumin and lymphocyte counts, with correct units and study context.

Read the guide →
Engineering

Op-Amp Gain, Closed-Loop Bandwidth (GBWP) & Slew-Rate Limit formulas

Explore ideal resistor-set gains, a single-pole noise-gain bandwidth estimate and the sine-wave slew-rate boundary.

Read the guide →
Bulk Metal Forming, Open-Die Upset Forging, Barreling Friction Hill & Press Tonnage

Open-Die Upset Forging Friction-Hill & Tonnage Formula

Calculate Compressive Logarithmic True Strain, Constant-Volume Upsetted Diameter Df (mm), Siebel Friction-Hill Shape Multiplier C_f, and Peak Forging Press Force (kN).

Read the guide →
Mining Engineering & Mineral Economics

Open-Pit Cutoff Grade & Stripping Ratio Formula

Distinguish Marginal Milling Cutoff Grade (sunk mining cost) from Pit-Shell Full Mining Cutoff Grade and calculate Maximum Breakeven Waste-to-Ore Stripping Ratio SR_max.

Read the guide →
Optical Fiber Transport & Coherent DWDM Telecom

Optical DWDM EDFA Noise Figure & Cascaded OSNR Formula

Calculate 1550 nm C-Band Single-Span Optical Signal-to-Noise Ratio (0.1 nm reference bandwidth), Multi-Span ASE Accumulation Penalty 10*LOG10(N), Cascaded End-to-End OSNR_dB = 58 + P_in_dBm - NF_dB - 10*LOG10(N), and Coherent FEC Margin.

Read the guide →
Engineering & Science

Optical Kerr Effect Nonlinear Refractive Index & Laser B-Integral

Calculate intensity-dependent Kerr refractive index shift delta_n = n_2 * I and accumulated ultrafast laser amplifier B-integral = (2 * PI() / lambda_0) * n_2 * I * L_eff (radians) to prevent catastrophic filamentation breakup.

Read the guide →
Financial

Option Put-Call Parity, Intrinsic Value, and Time Value formulas

Use a no-dividend European option parity model to infer a put value, then calculate the sample call premium minus intrinsic value.

Read the guide →
Logical checks and errors

OR function: flag a support ticket when either trigger applies

Escalate a ticket if a service is down or if its response age exceeds 24 hours. Check all four truth-table cases and exact threshold equality.

Read the guide →
Clinical Pharmacokinetics & Biopharmaceutics

Oral Bateman pharmacokinetics: peak time and bioavailability

Explore dose-normalized oral-to-IV AUC, time to peak and peak concentration for a one-compartment first-order model.

Read the guide →
Healthcare & Clinical Formulas

ORBIT Bleeding Score: An Educational Weighted-Sum Example

Practice the ORBIT score’s five weighted binary flags with fictional inputs. The worksheet does not predict an individual outcome or choose medications.

Read the guide →
Engineering

Orbital velocity, escape velocity & Kepler's 3rd Law satellite period formulas

Calculate circular orbital speed SQRT(mu/r), local escape speed SQRT(2*mu/r), and orbital period in minutes from gravitational parameter mu and altitude.

Read the guide →
Statistical

Ordinary Least Squares Slope, Intercept, R-Squared, and Standard Error (LINEST Diagnostics)

Build labeled, self-documenting regression diagnostics—slope, intercept, R^2, residual standard error SE_y, and slope standard error SE_b—using SLOPE, INTERCEPT, CORREL, and VAR_S.

Read the guide →
Operations, Logistics & Engineering

Ordinary Method of Slices: An Illustrative Circular-Slip Calculation

Explore the USACE ordinary-method expression for a three-slice example and understand why a worksheet result alone does not establish slope safety.

Read the guide →
Thermodynamics, Geothermal Power & Industrial Waste-Heat Recovery

Organic Rankine Cycle (ORC) Back-Work & Net Power Formula

Calculate Organic Rankine Cycle (ORC) Working-Fluid Mass Flow (kg/s), Organic Feed-Pump Back-Work Ratio (%), Net Electrical Output (kWe), and Net Thermal Efficiency (%).

Read the guide →
Clinical Medicine & Physiology

Original ADO Index: An Educational Spreadsheet Example

Reproduce the 2009 ADO point arithmetic using illustrative inputs, and distinguish the original score from the later updated index.

Read the guide →
Healthcare & Clinical Formulas

Original HACOR Score: Adding Five Component Points in a Spreadsheet

Learn to add the five published component point values using a fictional example and explicit input checks.

Read the guide →
International Macroeconomics & Sovereign Risk

Original Sin & Currency Mismatch Debt Shock Formula

Calculate post-depreciation sovereign Debt-to-GDP valuation jump d_1 = d_0*(1 + alpha_fx * Delta_S)/(1 + g_y) under Eichengreen-Hausmann "Original Sin" and Goldstein-Turner Net FX Debt / Exports mismatch.

Read the guide →
Quantitative Finance & Time-Series Econometrics

Ornstein-Uhlenbeck AR(1) Half-Life & Spread Z-Score

Convert discrete AR(1) persistence phi in (0, 1) into continuous Ornstein-Uhlenbeck speed kappa = -LN(phi), exact half-life -LN(2) / LN(phi), and stationary spread volatility sigma_e / SQRT(1 - phi^2).

Read the guide →
Financial

Ornstein-Uhlenbeck conditional mean, half-life and uncertainty formulas

Calculate conditional expectation and dispersion under a constant-parameter mean-reverting model, with consistent time units and validated parameters.

Read the guide →
Math

Osmolality and water-deficit formulas: a fictional spreadsheet exercise

Practice units, arithmetic and input checks with fictional laboratory values. Results are educational calculations, not diagnoses or fluid-treatment instructions.

Read the guide →
Econometrics & Omitted-Variable Sensitivity

Oster Coefficient Stability Delta and Bias-Adjusted Beta Formula

Audit omitted-variable bias in Excel and Arte Sheets using Emily Oster’s (2019) R-squared-scaled bias-adjusted beta_star and breakdown proportionality delta_zero.

Read the guide →
Fertilizer & Industrial Chemical Manufacturing, Ostwald Nitric Acid

Ostwald Nitric Acid Pt-Rh Gauze Selectivity & Yield Formula

Calculate 100%-Basis Pure HNO3 Produced (t/d), Commercial Weak Nitric Acid Output (t/d), Effective Acid-to-Ammonia Mass Gain Ratio, and Unselective N2/N2O Nitrogen Loss (kmol N/d).

Read the guide →
Healthcare & Clinical

Ottawa Ankle and Foot Rules: Two Sets of Clinical Findings

Explore the ankle and midfoot rule combinations using explicitly assessed inputs, while recognizing the limits of an educational spreadsheet.

Read the guide →
Healthcare & Clinical

Ottawa Knee Rule: Counting Five Pre-Assessed Findings

Explore the five Ottawa knee rule findings using validated illustrative inputs, and understand why a spreadsheet cannot decide whether a patient needs imaging.

Read the guide →
Engineering

Otto & Diesel Cycle Thermal Efficiency formulas (Compression & Cutoff Ratio)

Calculate air-standard spark-ignition Otto efficiency 1 - 1 / r^(gamma - 1) and compression-ignition Diesel efficiency from compression ratio r, cutoff rc, and gamma.

Read the guide →
Environmental Science, Ecology & Hydrology

Oudin (2005) Potential Evapotranspiration (PET) Formula: Extraterrestrial R_a & Temperature

Calculate daily watershed Potential Evapotranspiration PET (mm/day) for lumped and distributed rainfall-runoff models (GR4J, HBV, SWAT) using Ludovic Oudin et al.’s (2005) parsimonious 308-catchment radiation-temperature law.

Read the guide →
Revenue Management & Hospitality Analytics

Overbooking Critical Fractile & Booking Limit Formula

Balance empty-seat spoilage c_u against denied-boarding bump compensation c_o via the Critical Fractile CF = c_u/(c_u + c_o) to set optimal flight and hotel overbooking limits.

Read the guide →
Healthcare & Clinical Formulas

Oxygenation Ratios: Spreadsheet Arithmetic and ARDS Definitions

Practice P/F ratio and oxygenation-index arithmetic and learn why diagnosis requires clinical context.

Read the guide →
Statistical & Clinical Analysis

P-POSSUM Surgical Audit Research and a Fictional Logistic Formula

Understand the context of the Portsmouth POSSUM surgical audit model and practice a separate fictional logistic calculation.

Read the guide →