Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Synchronous Generator Protection & Commissioning, IEEE C37.102 / ANSI 25 Synchrocheck

IEEE C37.102 Generator Synchrocheck Out-of-Phase Shock

Calculate Phasor Difference Voltage Across Open Breaker dV (pu), Subtransient Synchronizing Surge Current (pu), Synchroscope Beat Period (s), and +/-10-deg Window Dwell Time (s).

Read the guide →
Power System Relaying & Substation Protection, IEEE C37.110 Transient CT Saturation

IEEE C37.110 CT Knee Voltage & X/R Saturation Formula

Calculate Secondary Symmetrical Fault Current (A), Symmetrical Burden Voltage Vs (V), Transient DC-Offset Excitation Demand Vs*(1 + X/R) (V), and % of Knee Voltage Vk.

Read the guide →
Architectural Illumination & MEP Electrical Design, IESNA Zonal Cavity Lumen Method

IES Zonal Cavity Lumen Method, RCR & Fixture Count Formula

Calculate IES Room Cavity Ratio RCR, Exact Fractional Luminaire Count, Rounded-Up Integer Luminaire Count, and Maintained Workplane Illuminance (Lux).

Read the guide →
Logical decisions

IF in Excel: flag low stock and keep missing counts visible

Compare a stock count with a minimum level. Decide what happens exactly at the threshold, then distinguish a missing count from a real zero.

Read the guide →
Logical & Validation

IF NOT This or That: Avoid the Always-True OR(<>X, <>Y) Trap

Apply surcharges or workflow rules whenever a cell equals neither X nor Y using NOT(OR(cell=X, cell=Y)) or AND(cell<>X, cell<>Y).

Read the guide →
Logical & Conditional

IF with Wildcards: Pattern Matching via COUNTIF & ISNUMBER(SEARCH)

Perform wildcard pattern tests (* and ?) inside IF statements—where direct =IF(A2="*PRO*", ...) fails—by pairing IF with COUNTIF(A2, pattern) > 0 or ISNUMBER(SEARCH()).

Read the guide →
Logical checks and errors

IFNA vs IFERROR: handle missing lookups without hiding broken data

A missing lookup key produces #N/A, whereas a zero pack size or broken reference produces a different error. Use IFNA so genuinely missing codes show a friendly label while real arithmetic mistakes stay visible.

Read the guide →
Logical checks and errors

IFS function: assign ordered score bands without nested IFs

Evaluate checklist scores from highest to lowest threshold because IFS stops at the first TRUE condition. Guard blank cells first and finish with a TRUE catch-all.

Read the guide →
Healthcare & Clinical

IIEF-5 / SHIM: Adding Five Component Scores

Add five already-scored SHIM items while accounting for zero responses, questionnaire version and the limits of interpreting the total.

Read the guide →
Financial

Illustrate a simplified US self-employment tax cash reserve

Practice a below-wage-cap US self-employment tax illustration and a rough equal-period cash reserve, not a filing calculation.

Read the guide →
Statistical

Illustrative logistic Elo expected score and one-game rating update

Calculate Arpad Elo's logistic expected match score E_A = 1 / (1 + 10^((R_B - R_A) / 400)) and post-game rating update R'_A = R_A + K * (S_A - E_A) for chess, esports, and LLM arenas.

Read the guide →
Financial

Illustrative mortgage payment caps and loan principal with PV

Combine assumed housing and debt-payment caps, subtract housing costs, and model loan principal.

Read the guide →
Financial

Illustrative progressive bracket calculation: base amount plus marginal rate

Learn progressive bracket arithmetic using a fictional four-bracket schedule and compare effective and marginal rates.

Read the guide →
Engineering

Illustrative tidal distance scales and planetary synodic periods

Compare a simple nonrotating tidal-balance estimate with a fluid Roche approximation, and calculate the beat period of two prograde mean orbital motions.

Read the guide →
Maritime Decarbonization & ESG Operations

IMO Shipping CII Rating, AER & EEOI Carbon Formula

Calculate IMO MARPOL Annex VI Attained Annual Efficiency Ratio AER (g CO2 / DWT-nm), Voluntary Operational EEOI (g CO2 / cargo-ton-nm), CII Compliance Ratio, and A-to-E Rating Band.

Read the guide →
Spreadsheet Governance & Collaborative AI Workflows

In-App 2 MB Attachment vs MCP 200-Cell Read Audit

Choose the right inspection path in Arte Sheets: metered in-app Pro Assistant file excerpts (.xlsx/.csv/.tsv/.txt <= 2 MB, safe non-executing) versus external MCP read_range (<= 200 cells raw values/formulas + revision, 0 Arte AI credits).

Read the guide →
AI Assistant & Workbook Safety

In-App AI Plan Validator, Suggest Style Guard & Undo Audit

Audit the client-side validatePlan and applyPlan safety rules in Arte Sheets: <=100 cell changes, <=2,000-char strings, <=10,000-cell range/SEQUENCE caps, suggest-mode style rejection, and local Undo stack recording.

Read the guide →
AI Assistant & Collaboration Governance

In-App Voice 3-Min Cap & Owner Share Preview Audit

Audit bounded WebRTC voice sessions (<=180s expiry, 15s heartbeat, barge-in turn guards) and verify why share_document requires verified-owner UI confirmation and cannot run inside execute_steps.

Read the guide →
Electrical Power Safety & Switchgear Protection, IEEE 1584 & NFPA 70E Arc Flash

Incident Energy Units and Arc-Flash Assessment

Convert energy per area between joules and thermochemical calories, and understand why conversion alone cannot establish an arc-flash boundary or PPE category.

Read the guide →
Logical

Include and exclude text substrings with SEARCH

Flag and filter transactions that match target keywords ("Cloud" OR "SaaS") while disqualifying rows containing exclusion terms ("Refund" OR "Test").

Read the guide →
Financial

Income tax bracket formula: calculate progressive marginal and effective tax

Compute progressive multi-bracket tax in a single SUMPRODUCT formula using differential bracket rates without nested IF ladders.

Read the guide →
Math

Increment a Calculation Automatically with ROW or COLUMN Step Ladders

Create arithmetic scenario ladders down rows or across columns from a base and a step. Keep full precision in rates and round only displayed cost results.

Read the guide →
Lookup & Reference

Increment a Cell Reference Every Nth Row When Copying Down (Non-Volatile INDEX)

Extract every 3rd (or k-th) row from repeating stacked export blocks—such as stacked Vendor / Invoice / Amount triplets—using non-volatile INDEX + ROW math instead of OFFSET or INDIRECT.

Read the guide →
Text

Increment a zero-padded ID number inside a text string (INV-0099 -> INV-0100)

Isolate the trailing numeric segment of a structured code, add N, and preserve leading-zero width automatically across 99-to-100 rollovers.

Read the guide →
Text

Increment letters (Rev A -> Rev B) and wrap A–Z shifts with CODE & CHAR

Step engineering revision letters forward ("A" -> "B"), wrap "Z" cleanly back to "A" with MOD(..., 26), and apply symmetric ROT13 character shifts.

Read the guide →
Lookup & Reference

INDEX and MATCH with multiple criteria: boolean array lookup without XLOOKUP

Match two or more columns simultaneously with INDEX(return_range, MATCH(1, (col1=x)*(col2=y), 0)) for universal workbook compatibility.

Read the guide →
Lookups

INDEX and MATCH: look up a column to the left of the search key

VLOOKUP can only search the leftmost column of a range. Combine INDEX and exact MATCH when the identifier you have sits to the right of the value you need to retrieve.

Read the guide →
Lookup & Reference

INDIRECT function: turn text cell and range strings into live references

Evaluate cell or range addresses stored as text with INDIRECT so summary formulas can switch target columns dynamically.

Read the guide →
Statistical

Individuals control chart: moving-range three-sigma limits

Estimate individual-observation control limits using average adjacent moving range, then compare a new reading with the fixed baseline.

Read the guide →
Geotechnical Engineering, Landslide Hazard & Hillslope Hydrology

Infinite-Slope Model: Illustrative Dry and Seepage Cases

Explore a simplified infinite-slope equation using hypothetical dry and surface-parallel seepage cases, with assumptions and limits made explicit.

Read the guide →
Financial

Information Ratio, Tracking Error, and Treynor Ratio formulas

Evaluate active portfolio managers against a benchmark index using Active Return, Tracking Error (STDEV.S of active diffs), Information Ratio, and Beta-adjusted Treynor Ratio.

Read the guide →
Behavioral Finance & Information Economics

Informational Cascade & Bayesian Herding Formula

Calculate Bikhchandani, Hirshleifer & Welch’s (1992) Bayesian herding posterior after two sequential actions, early cascade probability 1 - 2*q*(1 - q), and false-cascade risk (1 - q)^2.

Read the guide →
Plastics Manufacturing, Injection Molding Tooling & Press Sizing

Injection Molding Clamping Tonnage & Shot Weight Formula

Calculate Total Part+Runner Projected Area (cm²), Required Mold Clamping Force (kN), Press Clamping Rating (Metric Tons-Force at g = 9.81), and Polymer Shot Weight (g).

Read the guide →
Data Cleaning & Text

Inspect Character Code Sequences & Split a String into Characters (CODE & MID)

Audit 4-character SKU prefixes, currency codes, or short tokens by extracting each character with MID and inspecting its numeric code point with CODE.

Read the guide →
Financial

Insurance Loss Ratio, Expense Ratio & Combined Ratio formulas

Calculate loss, expense and combined ratios with an explicit earned/written premium convention, then subtract investment income relative to earned premium.

Read the guide →
Engineering & Science

Integer Quantum Hall Resistance (RK / nu) & Landau Level Cyclotron Gap Formula

Calculate quantized Hall plateau resistance R_xy = R_K / nu (where von Klitzing's constant R_K = h / e^2 = 25,812.80745 Ohms) and Landau level cyclotron spacing Delta_E = hbar * e * B / m_eff (in meV).

Read the guide →
Statistical

INTERCEPT function: estimate fixed overhead cost where X equals zero

Separate fixed baseline overhead from variable unit cost with INTERCEPT, and pair it with SLOPE for transparent forecasts.

Read the guide →
Financial

Interest Coverage Ratio (TIE) and Net Debt / EBITDA covenant formulas

Monitor corporate credit agreements with Times Interest Earned (EBIT / Interest), Net Leverage ((TotalDebt - Cash) / EBITDA), and automated covenant flags.

Read the guide →
Financial & Accounting

Interest-at-Maturity Note Clean Price & Yield (PRICEMAT & YIELDMAT Formulas)

Calculate the clean secondary-market price (PRICEMAT), dirty invoice price, and annualized yield to maturity (YIELDMAT) for certificates of deposit and notes paying interest in a single lump sum at maturity.

Read the guide →
Automotive & Industrial Machine Design, Internal Expanding Drum Brakes & Shoe Torque

Internal Expanding Drum Brake Leading vs Trailing Torque

Calculate Self-Energizing Leading-Shoe Braking Torque (N·m), De-Energizing Trailing-Shoe Braking Torque (N·m), Total Simplex Drum Torque (N·m), and Shoe Wear Asymmetry Ratio.

Read the guide →
Gear & Spline Production Machining, Internal Pull-Broaching Pitch, RPT & Tonnage

Internal Pull-Broaching Engaged Teeth & Tonnage Formula

Calculate Simultaneous Engaged Broach Teeth Ze, Total Instantaneous Uncut Chip Cross-Section (mm²), Peak Hydraulic Pull Force (kN), and Machine Pull Tonnage (metric tf).

Read the guide →
Statistical & Aggregation

Interpolated Percentile Rank: PERCENTRANK.INC vs PERCENTRANK.EXC Formulas

Compute exact inclusive [0, 1] and exclusive (0, 1) percentile ranks with linear interpolation between bracketing observations using COUNTIF, MAXIFS, and MINIFS.

Read the guide →
Statistical

Interquartile Range (IQR) formula and 1.5×IQR outlier detection fences

Measure middle-50% spread with QUARTILE.INC(r, 3) - QUARTILE.INC(r, 1) and flag potential outliers outside Tukey's Q1 - 1.5*IQR and Q3 + 1.5*IQR fences.

Read the guide →
Statistical Analysis

Intraclass Correlation Shrout-Fleiss ICC(2,1) Agreement vs ICC(3,1) Consistency

Calculate single-measure and k-rater Intraclass Correlation Coefficients ICC(2,1), ICC(3,1), and ICC(2,k) from two-way ANOVA Mean Squares (MS_R, MS_C, MS_E) to isolate systematic rater bias.

Read the guide →
Financial

Inventory EOQ and Reorder Point formulas: Economic Order Quantity

Balance fixed ordering costs against annual holding costs with SQRT(2 * D * S / H), and set lead-time Reorder Points.

Read the guide →
Financial

Inventory Turnover, Days Sales of Inventory (DSI), and Cash Conversion Cycle

Measure working-capital velocity with Inventory Turnover (COGS / AvgInventory), DSI (365 / Turnover), and Cash Conversion Cycle (DSI + DSO - DPO).

Read the guide →
Date & Time

Invoice Age, Days Past Due & Collection Status Escalation Formula

Calculate open days past due against an as-of reporting date while short-circuiting settled invoices first, then classify each receivable into PAID, CURRENT, PAST_DUE_1_30, PAST_DUE_31_60, or ESCALATE_60_PLUS.

Read the guide →
Financial

Invoice calculation formulas: line discounts, SUMIFS subtotal, and tax-exempt flag

Build two-decimal invoice templates with per-line ROUND(Qty * Price * (1 - Disc%), 2), multi-invoice SUMIFS rollups, and Tax-Exempt customer overrides.

Read the guide →
Working Capital & Commercial Trade Finance

Invoice Factoring Advance, Reserve & True APR Formula

Calculate Funded Receivable Factoring Cash Advance, Net Reserve Holdback Rebate, True Effective Annualized Cost (APR on Funded Cash), and Naive Face-Value APR Understatement.

Read the guide →
Water Treatment Engineering, Ion-Exchange Softening & Boiler Makeup

Ion-Exchange Water Softener Hardness & Brine Salt Formula

Calculate Ion-Exchange Softener Hardness in Grains per Gallon (gpg), Total Bed Kilograin Capacity (kgr), Service Gallon Run Before Regeneration (gal), and Salt Brining Efficiency (grains/lb NaCl).

Read the guide →