Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Industrial Organization & Pricing Strategy

Adams-Yellen Pure vs Mixed Bundling Profit Formula

Compare Separate Component Pricing, Pure Bundling, and Mixed Bundling profits across negatively correlated customer segments and verify Adams & Yellen’s Sub-Cost Exclusion Theorem.

Read the guide →
Engineering

ADC Effective Number of Bits (ENOB), SINAD & Ideal SNR (6.02 N + 1.76)

Compare a rounded ideal full-scale sine-wave SNR formula with SINAD-derived ENOB, and calculate nominal LSB size from the full input-voltage span.

Read the guide →
Lookup, Reference & Dynamic Arrays

Add an Average Line to a Chart: Constant Helper Column, Variance & +1 SD Control Band

Plot a horizontal mean benchmark line across any column or line chart by anchoring =AVERAGE($B$2:$B$7) in a helper series, plus compute point-vs-mean variance and +1 SD upper control limits.

Read the guide →
Dates & Time

Add Decimal Minutes or Decimal Hours to a Clock Time (Midnight-Safe MOD)

Add or subtract decimal minutes (C2 / 1440) or decimal hours (C2 / 24) to any 24-hour clock time—wrapping cleanly across midnight without negative-time #### errors via MOD(..., 1).

Read the guide →
Text

Add Leading Spaces & Indent Hierarchy Levels with REPT(" ", ...)

Create a visual hierarchy by prefixing labels with a validated number of spaces. Keep original labels and numeric levels for sorting and lookup.

Read the guide →
Text

Add leading zeros to numbers: pad ZIP codes and IDs to fixed length

Pad numeric IDs with leading zeros to a target character width using REPT and MAX(0, ...) so longer codes are never truncated.

Read the guide →
Text & String Cleaning

Add Line Breaks in a Formula with CHAR(10) & TEXTJOIN (Multi-Line Address Labels)

Insert multi-line carriage breaks inside spreadsheet formulas using CHAR(10) and TEXTJOIN(CHAR(10), TRUE, ...) so blank apartment or suite rows collapse automatically without empty gap lines.

Read the guide →
Text

Add line breaks with CHAR(10) and extract the last line in a cell

Join status updates with newline delimiter CHAR(10), count lines, and pull the most recent bottom line with TEXTAFTER(..., CHAR(10), -1).

Read the guide →
Text & Cleaning

Add OS-Specific Line Breaks: LF CHAR(10) vs. Windows/RFC-4180 CRLF Payloads

Assemble multi-line shipping addresses, EDI blocks, and RFC-4180 CSV cells using configurable LF (CHAR(10)) or CRLF (CHAR(13)&CHAR(10)) delimiters while skipping empty address lines.

Read the guide →
Lookup & Reference

Add row numbers and skip blanks: sequential numbering with expanding COUNTA

Use IF(ISBLANK(B2), "", COUNTA($B$2:B2)) so populated items number 1, 2, 3 without gaps across blank spacer rows.

Read the guide →
Dates & Time

Add Workdays on a 6-Day (Mon–Sat) Custom Workweek (Skipping Sundays)

Calculate exact delivery, construction, or retail SLA deadlines on a 6-day Monday–Saturday schedule (skipping Sundays only) using universal closed-form weekday arithmetic A2 + B2 + INT((MOD(WEEKDAY(A2, 2), 7) + B2 - 1) / 6).

Read the guide →
Date & Time

Add years to a date: why EDATE(date, years*12) beats DATE on Feb 29 leap days

Compare EDATE(start, N*12) against DATE(YEAR(start)+N, MONTH(start), DAY(start)) for contract renewals and expiration dates.

Read the guide →
Lookup & Reference

ADDRESS function: build A1 and sheet-qualified cell references from numbers

Convert 1-based row and column numbers into absolute, relative, or sheet-prefixed cell reference strings using ADDRESS.

Read the guide →
Preventive Cardiology, Clinical Lipidology & Laboratory Diagnostics

Adjustable-Factor LDL-C: Martin–Hopkins and Sampson Context

See why the Martin–Hopkins divisor needs the published lookup table and compare estimates using a clearly fictional divisor.

Read the guide →
Finance

Adjusted Present Value (APV): Unlevered Value, Tax Shield & Distress

Value leveraged buyouts (LBOs) and project-finance structures using Stewart Myers's Adjusted Present Value APV = V_Unlevered + PV(Interest_Tax_Shields) - PV(Financial_Distress).

Read the guide →
Naval Architecture, Maritime Chartering & Propulsion Economics

Admiralty Coefficient, Hull Speed & Slow-Steaming Formula

Calculate Displacement Vessel Froude Hull Speed 1.34*SQRT(LWL_ft), Admiralty-Formula Shaft Power (Disp^(2/3) * V^3) / C_adm, Daily Bunker Consumption (t/day), and Slow-Steaming Voyage Fuel per 1,000 Nautical Miles.

Read the guide →
Statistical & Clinical Analysis

Adrogué–Madias Equation: An Educational One-Litre Model

Explore the arithmetic of a simplified one-litre sodium mass-balance model and its limits. This worksheet is not a treatment or infusion-volume calculator.

Read the guide →
Statistical & Clinical Analysis

Adult Appendicitis Score: Original Study and Validated Point Sets

Learn how the original Adult Appendicitis Score components are summed and why its study categories cannot replace individual clinical assessment.

Read the guide →
Epidemiology & Healthcare Quality Analytics

Age-Standardized Rate & SMR Simpson’s Paradox Formula

Resolve hospital mortality Simpson’s Paradox using Direct Age-Standardized Rate (DASR per 1,000) and Indirect Standardized Mortality Ratio SMR = Observed / Expected.

Read the guide →
Structured Finance & Mortgage-Backed Securities

Agency MBS PSA Prepayment Ramp & Cashflow Formula

Calculate SIFMA PSA Seasoned Conditional Prepayment Rate (CPR), Monthly Single Monthly Mortality SMM = 1 - (1 - CPR)^(1/12), Unscheduled Principal on Post-Amortization Balance, and Total Principal.

Read the guide →
Statistical

AGGREGATE function: summarize ranges while ignoring errors and hidden rows

Calculate sums, averages, medians, and percentiles with AGGREGATE option codes that skip error cells and filtered-out rows.

Read the guide →
Contract Theory & Corporate Governance

Aghion-Bolton Contingent Control & Covenant Formula

Model Philippe Aghion and Patrick Bolton’s (1992) incomplete-contract pecking order across entrepreneur control, debt-covenant state-contingent control, and investor control.

Read the guide →
Mechanical Design & Power Transmission

AGMA Gear Pitting Contact Stress (sigma_c) and Elastic C_p Formula

Calculate AGMA elastic coefficient C_p and Hertzian gear-tooth surface pitting stress sigma_c = C_p * SQRT(W_t * K_all / (b * d_p * I_geom)) in Excel and Arte Sheets.

Read the guide →
Statistical & Clinical Analysis

Agresti-Caffo "+1 Success, +1 Failure per Arm" Risk Difference 95% CI Formula

Replace degenerate small-sample Wald 2-proportion confidence intervals with Alan Agresti & Brian Caffo’s (2000) adjusted interval: add 1 pseudo-success and 1 pseudo-failure to EACH arm (p_tilde = (x + 1) / (n + 2)) before computing Wald bounds.

Read the guide →
Statistical & Clinical Analysis

Agresti-Coull Binomial Confidence Interval ("Add 2 Successes & 2 Failures")

Replace erratic small-sample Wald intervals with Alan Agresti and Brent Coull’s (1998) z²-adjusted proportion center p̃ = (x + 0.5*z²) / (n + z²) and 95% confidence bounds.

Read the guide →
Warehouse Automation, Intralogistics AGV / AMR Robotics & Fleet Dispatch Engineering

AGV & AMR Warehouse Fleet Sizing & Cycle Time Formula

Calculate Ideal Round-Trip Mission Time Including Deadhead & Docking (min), Net Effective Trips Per Robot Hour, Fractional AGV Requirement, and Rounded Integer Fleet Count.

Read the guide →
Lookup, Reference & Dynamic Arrays

AI Assistant Chart Creation: 7 Supported Chart Types, Explicit Ranges & Data Prep

Use Arte Sheets’ AI Assistant via text or voice to create column, bar, line, area, pie, doughnut, and scatter charts on explicit A1:C10 ranges (<= 10,000 cells, <= 50 charts/sheet, title <= 120 chars), and prepare clean summary tables for instant charting.

Read the guide →
AI & Automation

AI Assistant Context Window Sizing: 40x12 Selection Scan, 160-Cell & 14 KB Caps

Audit how Arte Sheets scopes live worksheet context for AI Assistant text and voice prompts—scanning up to 40x12 selected cells plus A1:H12 headers within a 160-cell, 14,000-byte, and 30-sheet-tab budget.

Read the guide →
Lookup & Reference

AI Assistant File Attachments (.xlsx, .csv, .tsv, .txt): Safe Excerpt Import & Reconciliation

Attach vendor .xlsx, .csv, .tsv, or .txt statements (up to 2 MB) in Arte Sheets’ AI assistant to populate clean comparison ranges and reconcile invoice variances with COUNTIF and XLOOKUP.

Read the guide →
Financial & Accounting

AI Assistant in Suggest Mode: Collaborative Cell Suggestions, Role Checks & Proposal Audit

Understand how Arte Sheets routes AI formula and value edits as reviewable cell suggestions for suggester roles and suggest mode, blocks unreviewed style/structural mutations, and requires explicit owner confirmation before sending share invitations.

Read the guide →
AI & Collaboration

AI Assistant Role Matrix: Cell Suggestion Routing vs. Structural Command Guards

Audit how Arte Sheets routes AI cell edits into reviewable proposals for Suggesters while enforcing Owner/Contributor roles and <=100-cell / <=20-row limits on structural commands.

Read the guide →
Lookup, Reference & Dynamic Arrays

AI Assistant Sheet & Grid Commands: Add/Rename Tabs & 1-Based Row/Column Edits

Learn how Arte Sheets’ AI Assistant executes create_sheet, rename_sheet, select_sheet, and 1-based insert/delete row and column commands (1..20 count) with protected-sheet and role guardrails, plus write row-insertion-safe total formulas.

Read the guide →
Financial & Accounting

AI Cell Formatting, Number Formats & Data-Validation Guardrails in Financial Schedules

Apply clean currency, percent, integer, alignment, and #RRGGBB highlight styles—or scale raw dollars into $M display columns—understanding how Arte Sheets validates cell styles, data-validation rules, and suggest-mode permissions.

Read the guide →
Financial & Accounting

AI Spreadsheet Assistant Workflow: Text & Voice Formula Proposals, Bounds & Undo

Select a target range in Arte Sheets to fill or update cells, formulas, and formats via text or bounded WebRTC voice commands—understanding Before/Proposal review cards, Undo, suggestion-mode routing, and safe formula bounds.

Read the guide →
Financial & Accounting

AI Voice Spreadsheet Commands: Live Selection Context, Barge-In & Validated Edits

Use Arte Sheets’ bounded WebRTC voice assistant (up to 3 minutes per call) to dictate quota attainment formulas, charts, and tab navigation hands-free while client-side validation and version checks protect every cell.

Read the guide →
Six Sigma & Measurement Systems Analysis

AIAG Gage R&R %StudyVar, P/T Ratio & ndc Formula

Combine Equipment Repeatability (EV), Appraiser Reproducibility (AV), and Part Variation (PV) via root-sum-of-squares to audit %StudyVar, 6-sigma Precision-to-Tolerance (P/T), and ndc = INT(1.41 * PV / GRR).

Read the guide →
Healthcare & Clinical

AIMS65: An Educational Point-Counting Spreadsheet Example

Practice the five-factor AIMS65 point arithmetic with invented inputs; the worksheet does not determine mortality risk, admission, or treatment.

Read the guide →
Global Freight Forwarding & Supply Chain

Air Cargo vs Ocean LCL Chargeable Weight Formula

Calculate IATA Air Volumetric & Chargeable Weight MAX(W_gross, V_cbm * 167), Air Freight Cost, Ocean LCL W/M Revenue Tons MAX(W_gross / 1000, V_cbm), and Modal Freight Savings.

Read the guide →
Aviation Finance, Airline Fleet Planning & ACMI Wet-Lease Operations

Aircraft ACMI Wet-Lease MGBH Floor & PBH Reserve Formula

Calculate Airline ACMI (Aircraft, Crew, Maintenance, Insurance) Wet-Lease Billable Block Hours with Minimum Guaranteed Block Hours (MGBH) Floor, Monthly ACMI Invoice ($), Power-by-the-Hour (PBH) Engine Overhaul Reserve, and Effective Cost Per Flown Seat-Hour.

Read the guide →
Aviation Finance & Capacity Planning

Airline RASM, CASM & Break-Even Load Factor Formula

Calculate Available Seat Miles (ASM), Revenue Passenger Miles (RPM), Passenger Yield, RASM, CASM, and Break-Even Load Factor BELF = CASM / Yield.

Read the guide →
Information Economics & Market Design

Akerlof Market for Lemons Adverse-Selection Cutoff Formula

Calculate the critical high-quality share q* = (S_H - B_L) / (B_H - B_L), pooling willingness-to-pay, and equilibrium trade surplus before adverse selection collapses the market.

Read the guide →
Healthcare & Clinical Calculations

ALBI Score and Grade: Research Context and Spreadsheet Arithmetic

Understand the albumin-bilirubin score and reproduce its published three-grade cut points with fictional values.

Read the guide →
International Trade & Price Theory

Alchian-Allen "Shipping Good Apples Out" Formula

Prove Armen Alchian and William Allen’s (1964) relative-price compression theorem (P_H + f) / (P_L + f) < P_H / P_L under per-unit freight or specific charges and predict export quality upgrading.

Read the guide →
Engineering & Science

Alfvén Wave Speed (vA) & Plasma Beta (MHD Magnetic Confinement Formula)

Calculate magnetohydrodynamic Alfvén speed vA = B / SQRT(mu0 * rho) in km/s and dimensionless Plasma Beta = P_thermal / (B^2 / (2 * mu0)) for tokamak fusion reactors and solar-wind plasmas.

Read the guide →
Development Economics & Welfare Indices

Alkire-Foster Multidimensional Poverty (MPI) Formula

Implement Sabina Alkire and James Foster’s (2011) dual-cutoff censoring c_i(k) = IF(c_i >= k, c_i, 0) to calculate Multidimensional Headcount H, Deprivation Intensity A, and MPI = H * A.

Read the guide →
Auction Theory & Contest Strategy

All-Pay Auction Bidding & Expected Revenue Formula

Calculate Baye-Kovenock-de Vries (1996) asymmetric all-pay contest abstention probability 1 - v_2/v_1, expected expenditures, and total sunk-effort dissipation (v_2/2)*(1 + v_2/v_1).

Read the guide →
Procurement & Inventory Management

All-Units vs Incremental Discount EOQ Formula

Compare All-Units Price-Break EOQ (step-up to Q_brk) against Incremental Marginal-Tier Discount EOQ (effective setup S + (p_0 - p_1)*Q_brk) on total annual landed cost.

Read the guide →
Operations Research & Factory Physics Queueing

Allen-Cuneen G/G/c Multi-Server Queue Formula

Calculate Multi-Server Utilization rho = lambda / (c * mu), Baseline Erlang-C M/M/c Waiting Time, Allen-Cuneen G/G/c Variability-Adjusted Waiting Time W_q, and Little’s Law Queue WIP L_q.

Read the guide →
Business & Operations

Allen-Cunneen G/G/c Multi-Server Queue Waiting Time Approximation

Calculate expected waiting time in queue Wq and queue length Lq for general multi-server G/G/c stations (fab tool groups, CT scanners, call centers) using Allen-Cunneen variability scaling (Ca^2 + Cs^2) / 2.

Read the guide →
Financial

Allowance for Doubtful Accounts & Bad Debt Expense (AR aging SUMPRODUCT)

Illustrate an aging-based allowance estimate and the adjustment from an existing unadjusted allowance balance.

Read the guide →