Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Naval Architecture, Ship Propulsion & Noon-Report Performance

Marine Propeller Apparent vs True Wake Slip Formula

Calculate Theoretical Screw Pitch Velocity V_p (m/s), Ship Speed Over Water V_s (m/s), Bridge Noon-Report Apparent Slip (%), and Hydrodynamic True Slip (%) inside the Taylor Stern Wake.

Read the guide →
Maritime Chartering & Port Logistics

Maritime Laytime, Demurrage & Despatch Formula

Calculate Total Reversible Allowed Port Laytime Q/R_load + Q/R_dis, Net Laytime Balance, Shipowner Demurrage Penalty, and Charterer Half-Rate Despatch Rebate ("Despatch Half Demurrage").

Read the guide →
Maritime Economics & Shipping Finance

Maritime Time Charter Equivalent (TCE) Formula

Convert Lump-Sum or $/MT Spot Voyage Freight into Daily Time Charter Equivalent TCE = (Gross_Freight*(1 - comm) - Bunkers - Port_Dues) / Voyage_Days and Daily Vessel Cash Breakeven Margin.

Read the guide →
Engineering & Science

Mark-Houwink-Sakurada Equation: Intrinsic Viscosity [eta] & Polymer Molar Mass (Mv)

Calculate dilute polymer intrinsic viscosity [eta] = K * Mv^a (dL/g) and invert Ubbelohde viscometer measurements back to viscosity-average molecular weight Mv = ([eta] / K)^(1 / a).

Read the guide →
Logical & Conditional

Mark, Count & Sum Rows Matching Mixed AND + OR Rules (IF + COUNTIF + SUMIF)

Flag audit rows meeting compound AND + OR criteria (e.g., Amount >= $1,000 AND Status is Urgent OR Escalated), then count and sum flagged exposure cleanly.

Read the guide →
Two-Sided Marketplaces & Fintech Economics

Marketplace GMV, Take Rate & Interchange Margin Formula

Bridge Gross Merchandise Volume (GMV) from Headline Combined Take Rate to Net Realized Take Rate and Net Contribution Margin after GMV-denominated card interchange, fraud chargebacks, and incentives.

Read the guide →
Chemical, Process & Catalysis Engineering

Mars-van Krevelen Redox Catalytic Rate Law & Oxidized Lattice Fraction theta_ox

Model selective hydrocarbon oxidation over reducible metal oxides (V2O5, MoO3, CeO2) using Pieter Mars and Dirk Willem van Krevelen’s (1954) redox rate law r_R = (k_red * P_R * k_ox * P_O2^n) / (nu * k_red * P_R + k_ox * P_O2^n).

Read the guide →
Healthcare & Clinical Formulas

Marshall MODS and Pressure-Adjusted Heart Rate: An Educational Example

Practice a six-domain point sum and pressure-adjusted heart-rate arithmetic with fictional values; the worksheet does not predict individual outcomes.

Read the guide →
International Macroeconomics & Trade

Marshall-Lerner Condition and J-Curve Trade-Balance Formula

Test the Marshall-Lerner condition (e_X + e_M > 1), Hirschman’s initial-deficit condition ((X_0 / M_0)*e_X + e_M > 1), and J-curve trade-balance response Delta_NX = dq * (X_0*e_X + M_0*(e_M - 1)).

Read the guide →
Healthcare & Clinical

MASCC Risk Index: An Educational Point-Sum Example

Practice adding illustrative MASCC factors for febrile neutropenia; the worksheet does not choose antibiotics or determine care setting.

Read the guide →
Logical & Lookup Formulas

Match First Row Not Containing Specific Text (XLOOKUP & SEARCH)

Retrieve the first order or server record that excludes an internal/test substring using an ISERROR(SEARCH(...)) helper flag with XLOOKUP and count all non-matching records with COUNTIF.

Read the guide →
Lookup & Reference

Match Long Text Over 255 Characters (EXACT + XLOOKUP Bypass for Deep URLs & Clauses)

Bypass legacy 255-character lookup limits and prefix collisions when matching long tracking URLs, API payloads, and contract clauses that differ only after character 255.

Read the guide →
Lookup & Reference

Match Next Highest Capacity Bracket & Dynamic Column Peak (XLOOKUP +1 & CHOOSECOLS)

Select the smallest server, container, or breaker rating that meets or exceeds required load using XLOOKUP match_mode = 1, and verify dynamic column capacity peaks with MAX(CHOOSECOLS(...)).

Read the guide →
Information

Match the first error in a column: jump straight to broken rows

Identify the first record with a formula error and list all affected records using an audit helper column.

Read the guide →
Civil, Structural & Geotechnical Engineering

Matlock (1970) Soft-Clay Lateral Pile p-y Curve Formula: N_p, y_50 & Cubic Spring

Generate nonlinear lateral soil-pile spring resistance p(y) (kN/m) in submerged soft clay using Hudson Matlock’s (1970, API RP 2GEO / LPILE) bearing factor N_p = MIN(9, 3 + gamma_prime*z/c_u + J*z/D), y_50 = 2.5*eps_50*D, and cubic parabola.

Read the guide →
Statistical & Clinical Analysis

Matsuda insulin sensitivity index and HOMA-IR: worked examples

Practice OGTT-derived Matsuda and fasting HOMA-IR arithmetic using specified units and research context.

Read the guide →
Statistical

Matthews Correlation Coefficient (MCC) & Cohen's Kappa Confusion Matrix formulas

Compute binary MCC and unweighted Cohen kappa from valid integer counts, distinguish undefined cases and compare asymmetric confusion matrices.

Read the guide →
Engineering & Science

Matthiessen’s Rule & Cryogenic Residual Resistivity Ratio (RRR)

Separate impurity/defect resistivity rho_0 from thermal phonon scattering rho_ph(T) via Augustus Matthiessen’s Rule rho_tot = rho_0 + rho_ph and grade cryogenic copper/niobium purity via RRR = rho(300 K) / rho(4.2 K).

Read the guide →
Statistical & Aggregation

Maximum and Minimum Value by Calendar Month (MAXIFS, MINIFS & EOMONTH)

Find the peak high and trough low within any calendar month using MAXIFS and MINIFS bounded by first-of-month and EOMONTH(firstOfMonth, 0), distinguishing empty months from genuine zero readings.

Read the guide →
Financial

Maximum Drawdown (MDD), High-Water Mark & recovery gain % formulas

Track running portfolio peaks MAX($B$2:B2), underwater drawdown %, worst peak-to-trough Maximum Drawdown, and asymmetric recovery % needed.

Read the guide →
Operations & Logistics

Maximum Flow & Min-Cut Network Model (Node Conservation, Arc Slack & Bottleneck Cut)

Model directed logistics and pipeline networks by auditing SUMIFS transshipment flow conservation (Outflow - Inflow = 0), residual arc capacity slack, and Max-Flow = Min-Cut optimality.

Read the guide →
Engineering & Science

Mayo-Lewis Copolymer Equation & Azeotropic Feed Ratio

Calculate instantaneous copolymer chain composition F_1 = (r_1*f_1^2 + f_1*f_2) / (r_1*f_1^2 + 2*f_1*f_2 + r_2*f_2^2) and drift-free azeotropic monomer feed f_1,azeo = (1 - r_2) / (2 - r_1 - r_2).

Read the guide →
Engineering & Science

McCabe-Thiele Distillation Operating Lines & Feed q-Line Intersection Formula

Calculate the McCabe-Thiele rectifying operating-line slope R / (R + 1), intercept xD / (R + 1), and exact singularity-free feed q-line intersection coordinates (x_int, y_int) valid for ALL thermal qualities q (including q = 1).

Read the guide →
Statistical & Clinical Analysis

McDonald’s Omega (Composite Reliability) & Fornell-Larcker AVE Formula in CFA

Replace tau-equivalent Cronbach’s alpha assumptions in Confirmatory Factor Analysis (CFA / PLS-SEM) using Roderick McDonald’s congeneric omega = (SUM(lambda))² / ((SUM(lambda))² + SUM(1 - lambda²)) and Claes Fornell & David Larcker’s Average Variance Extracted AVE = SUMPRODUCT(lambda, lambda) / k.

Read the guide →
Healthcare

McIsaac and Alvarado Scores: Validated Spreadsheet Arithmetic

Practice binary-input validation, age bands and weighted sums using fictional McIsaac and Alvarado components. Return numerical totals without diagnosis or treatment instructions.

Read the guide →
Packaging Mechanics, Warehousing & Supply-Chain Ops

McKee Corrugated Box Compression (BCT) & Stacking Formula

Calculate R.C. McKee’s Simplified Corrugated Box Compression Strength BCT_lbf = 5.87 * ECT_lb_in * SQRT(Flute_Caliper_in * Box_Perimeter_in), Humidity/Creep Safe Bottom-Box Load, and Maximum Safe Pallet Layers.

Read the guide →
Statistical Analysis

McNemar’s Paired-Proportions Chi-Square Test & Edwards Continuity Correction

Test before-vs-after binary treatment shifts or matched classifier error rates using discordant pairs (b and c), Edwards continuity-corrected chi-square, and matched-pair odds ratio.

Read the guide →
Spreadsheet Governance & Collaborative AI Workflows

MCP apply_changes Revision, Idempotency & Conflict Audit

Audit external connector apply_changes guardrails on cloud workbooks: Pro + editor/owner access, <= 100 cell cap, 16-80 char operation_id idempotency, base revision matching, and pendingReview concurrent peer-edit routing.

Read the guide →
Spreadsheet Collaboration Governance, Comment Threading & OAuth Auditing

MCP Comment Reply Parent Anchor, comment_id Retry & Alert Audit

Audit Collaborative Comment Threading Rules in Arte Sheets: Exact read_range / Parent-Thread Anchor Inheritance, Explicit User Request Gate Before Participant Notification, Identical-Retry-Only comment_id Reuse, and Scoped Thread Resolution.

Read the guide →
Collaborative Spreadsheets & MCP Connector Governance

MCP Comment Tools: 25-Entry/120KB Cap & Suggester Audit

Audit list_comments (<=25 entries, <=120 KB), add_comment, and resolve_comment permissions (Pro + owner/editor/suggester on whole-cell anchors) and 120/min rate limits without Arte AI credit burn.

Read the guide →
Spreadsheet Security, Scoped OAuth Onboarding & AI Connector Governance

MCP Connector Setup: No Demo Edits & Credit Non-Transfer Audit

Audit Scoped OAuth Onboarding Rules for the Arte Sheets ChatGPT Connector (0.1.0, In review / Not published): Read-Only Setup Discovery via list_workbooks and list_lessons, Zero Speculative Demo Edits or Invitations, Neutral Access-Denial Reporting, and Zero ChatGPT Credit Transfer.

Read the guide →
Connected Apps & Collaboration Governance

MCP list_workbooks Pagination & Connected Apps Audit

Audit list_workbooks (<=100 cloud documents per page), why local browser-only workbooks require cloud collaboration before external MCP reads/writes, and OAuth revocation via Profile -> Connected apps.

Read the guide →
AI Connector Security, OAuth Hygiene & Setup Governance

MCP OAuth Hygiene, Cloud Visibility & Lesson Prompt Audit

Audit Arte Sheets ChatGPT 0.1.0 setup and teaching guardrails: host OAuth without chat passwords/tokens (revokable in Profile -> Connected apps), no ChatGPT credit transfer claims, cloud collaboration visibility vs local browser sheets, and lesson-text prompt-injection quarantine.

Read the guide →
Spreadsheet Security & Collaborative AI Governance

MCP Public Link Rotation & Cell Prompt-Guard Formula

Audit manage_public_link owner/Pro rotation vs named invitations, 20-row by 10-column anonymous pagination tiles, and strict untrusted-data isolation for cell/comment prompt strings.

Read the guide →
Spreadsheet Governance, Collaboration Permissions & External OAuth Auditing

MCP share_workbook In-App Invite, emailSent=false & Replay Audit

Audit External OAuth share_workbook Governance in Arte Sheets: Owner + Active Pro Gate, Ambiguous Recipient/Role Hold, In-App Invitation Disclosure (emailSent=false), Zero Arte AI Credit Usage, and Idempotent Replay Semantics.

Read the guide →
Spreadsheet Automation, AI Governance & MCP Reliability

MCP Structural Step Coordinate Shift & Readback Audit

Audit 1-based row/column coordinate shifts R_shifted = R_0 + Ins_Above - Del_Above inside execute_steps (<= 10 steps, <= 20 structural ops, <= 100 cells), enforce post-mutation read_range verification, and reject unsupported file-create/export/macro requests.

Read the guide →
Engineering & Science

Mears Criterion: External Boundary-Layer Mass Transfer Check (< 0.15)

Test whether external fluid-film mass transfer limits heterogeneous catalytic reaction rates (< 5% error) via David Mears’ observable criterion Ω_Mears = (-r_A')_obs * ρ_b * R * n / (k_c * C_Ab) < 0.15.

Read the guide →
API 682 Rotating Equipment, Centrifugal Pump Mechanical Seals & Tribology PV Limits

Mechanical Shaft Seal Balance Ratio, PV & Heat Formula

Calculate Net Seal-Face Contact Pressure Pf (MPa), Mean Sliding Velocity v (m/s), Tribological PV Factor (MPa·m/s), and Seal-Chamber Flush Heat Generation (W).

Read the guide →
Statistical

Median Absolute Deviation (MAD) & Iglewicz-Hoaglin Modified Z-Score outlier formula

Calculate median absolute deviation and a modified Z-score, including the zero-MAD case, to flag observations for investigation.

Read the guide →
Descriptive statistics

MEDIAN function: summarize typical values without outlier distortion

Find the middle value of a dataset when one extreme spike pulls AVERAGE upward, and verify how MEDIAN handles both odd and even observation counts.

Read the guide →
Healthcare Revenue Cycle & Medical Economics

Medicare Physician RVU, GPCI & Payment Formula

Calculate CMS Resource-Based Relative Value Scale (RBRVS) Unadjusted RVUs, Geographic Practice Cost Index (GPCI) Adjusted RVUs, Medicare Allowed Fee-Schedule Payment, and 80% Part B Plan Reimbursement.

Read the guide →
International Trade & Firm Dynamics

Melitz Export Productivity Cutoff & Exporter Share Formula

Calculate the Melitz-Chaney export cutoff hurdle phi_X* / phi_D* = tau * (f_X / f_D)^(1/(sigma - 1)), Pareto exporter share, and domestic survival cutoff elevation.

Read the guide →
Ground Improvement & Reclamation, Ménard Dynamic Compaction Energy & Depth

Ménard Dynamic Compaction Depth & Specific Energy Formula

Calculate Crane Drop-Tamper Impact Energy W*H (tonne·m & MJ), Ménard-Lukas Effective Densification Depth n*SQRT(W*H) (m), and Grid Applied Specific Energy (kJ/m²).

Read the guide →
Statistical & Clinical Analysis

Mentzer, Green–King and Srivastava Indices: CBC Formulas

Calculate three red-cell discrimination indices using their required CBC inputs and understand their limits as screening aids.

Read the guide →
Manufacturing Mechanics & Metal Cutting

Merchant Shear-Plane Angle & Cutting Force Formula

Calculate M.E. Merchant’s Minimum-Power Shear-Plane Angle phi = 45 + alpha/2 - beta/2, Rake-Face Friction Coefficient TAN(beta), Shear-Plane Area, and Tangential Cutting Force F_c.

Read the guide →
Lookup & Reference

Merge two tables by ID: Left Join, Inner Join, and Orphan Key audit

Join an Orders fact table to a Customers master table using XLOOKUP enrichment columns and FILTER for Inner Join vs unmatched Anti-Join audits.

Read the guide →
Financial

Merton distance to default: lognormal model and a one-year linear buffer

Calculate an illustrative distance to default from asset value, debt, annual asset drift and volatility, with explicit model assumptions and input checks.

Read the guide →
Quantitative Finance & Derivatives

Merton Jump-Diffusion Option Pricing via Poisson-Weighted Black-Scholes

Price European options under sudden lognormal jumps using Merton’s (1976) jump-compensated Poisson-weighted Black-Scholes sum and verify convergence to pure Black-Scholes at lambda = 0.

Read the guide →
Quantitative Finance & Portfolio Choice

Merton Optimal Portfolio Share & Consumption-Wealth Formula

Calculate Merton’s continuous-time risky-asset allocation pi* = (mu - r_f)/(gamma * sigma^2), certainty-equivalent return r_CE, and optimal CRRA payout propensity c*/W.

Read the guide →
Quantitative Finance

Merton Structural Credit Distance-to-Default (DD) Formula

Calculate Merton’s (1974) / KMV structural credit Distance-to-Default DD = (LN(V_A / D) + (mu_A - 0.5 * sigma_A^2) * T) / (sigma_A * SQRT(T)) in asset standard deviations.

Read the guide →