Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Corporate Income Tax Footnote Analysis & US GAAP ASC 740

ASC 740 Valuation Allowance, UTP & Effective Tax Rate Formula

Reconcile US GAAP ASC 740 Statutory Income Tax Expense to Total GAAP Tax Provision Across Permanent Differences, Deferred-Tax Valuation Allowance Changes, Uncertain Tax Position (FIN 48) Reserves, and Effective Tax Rate (ETR).

Read the guide →
M&A Accounting, Business Combinations & US GAAP ASC 805 / IFRS 3

ASC 805 Purchase Price Allocation, DTL & Goodwill Formula

Calculate US GAAP ASC 805 / IFRS 3 Non-Tax-Deductible Intangible Step-Up Deferred Tax Liability (DTL), Fair Value of Net Identifiable Assets, Residual Goodwill Recorded, and Bargain Purchase Gain.

Read the guide →
Corporate Lease Accounting & US GAAP ASC 842

ASC 842 Operating Lease ROU Asset & Plug Amortization

Calculate US GAAP ASC 842 Day-1 Right-of-Use (ROU) Asset (Liability_PV + Direct_Costs - TI_Incentives), Single Straight-Line Annual Lease Expense, Year-1 Liability Discount Accretion, and Year-1 Plug ROU Amortization.

Read the guide →
Activated-Sludge Biological Treatment, ASCE 2-06 Fine-Bubble SOTR to Field AOTR

ASCE Fine-Bubble Diffuser SOTR to Field AOTR Formula

Calculate Dissolved-Oxygen Driving Deficit Ratio, Arrhenius Theta Temperature Factor, Overall Field-to-Clean-Water Transfer Ratio, and Actual Oxygen Transfer Rate AOTR (kg O2/h).

Read the guide →
Healthcare & Clinical Calculators

ASDAS-CRP Spreadsheet Example: ASAS Formula and CRP Floor

Explore the ASAS ASDAS-CRP formula with fictional symptom scores, a 2 mg/L CRP floor, and checks for complete numeric inputs.

Read the guide →
HVAC Ductwork Sizing, ASHRAE Equal-Friction Design & Building Mechanical Engineering

ASHRAE Huebscher Rectangular Equivalent Duct Diameter Formula

Calculate Huebscher Equal-Friction Circular Equivalent Diameter De (mm), Wetted-Perimeter Hydraulic Diameter Dh (mm), Rectangular Duct Air Velocity (m/s), and Velocity Pressure Pv (Pa).

Read the guide →
Math

ASIN function: calculate ramp incline angles from rise and sloped length

Convert vertical rise over ramp length into incline degrees in [-90, +90] using DEGREES(ASIN(ratio)), and guard impossible ratios.

Read the guide →
Math

ASINH, ACOSH, and ATANH: inverse hyperbolic functions and domain limits

Evaluate inverse hyperbolic sine, cosine, and tangent transformations—including Fisher Z correlation transforms with ATANH.

Read the guide →
ASME BPVC Section VIII Div. 1 Pressure Vessels, Taylor-Forge Flanges & Gasket Seating

ASME Bolted Flange Gasket m & y Bolt-Load Formula

Calculate Hydrostatic End Force H (kN), Operating Pressurized Bolt Load Wm1 = H + Hp (kN), Ambient Initial Gasket-Seating Bolt Load Wm2 (kN), and Governing Total Bolt Root Area Am (mm²).

Read the guide →
Statistical & Clinical Analysis

ASPECTS: Understanding the Ten-Region Stroke CT Score

Explore the arithmetic behind the ten-region ASPECTS score and understand why stroke treatment decisions require more than a score.

Read the guide →
Date & Time

Assign attendance points based on late arrival time (with grace period)

Convert clock-in delay into integer minutes with ROUND(MAX(0, PunchIn - ShiftStart) * 1440, 0) and assign progressive attendance points via IFS.

Read the guide →
Math

Assign cohort / batch numbers every N rows with QUOTIENT, MOD, and ROW

Generate repeating group IDs (1,1,1, 2,2,2...) and within-batch seat positions (1,2,3, 1,2,3...) for any group size N using zero-based row offsets.

Read the guide →
Math & Trig

Assign People or Leads to K Balanced Teams (Round-Robin MOD vs Block)

Assign a complete six-person roster to an integer number of teams from one to six. Compare round-robin and contiguous assignments whose headcounts differ by at most one.

Read the guide →
Metallurgical Quench Hardenability, ASTM A255 Jominy/Grossmann DI & Alloy Steels

ASTM A255 Grossmann Steel Hardenability (DI) Formula

Calculate Manganese Multiplying Factor f_Mn, Combined Alloy Hardenability Product (Mn*Cr*Mo*Ni), Ideal Critical Bar Diameter DI in Millimeters, and DI in Inches.

Read the guide →
Concrete Materials Testing, ASTM C136 / C33 Sieve Gradation & ACI 211.1 Mix Design

ASTM C136 Sand Sieve Analysis & Fineness Modulus Formula

Calculate Cumulative Percentage Retained Sum Across the 6 Standard ASTM Sieves (#4 to #100), Fine-Aggregate Fineness Modulus FM, ACI 211.1 Coarseness Shift vs 2.70 Baseline, and ASTM C33 Spec Status.

Read the guide →
Desalination & Ultrapure Water Pretreatment, ASTM D4189 Reverse-Osmosis SDI-15

ASTM D4189 Reverse-Osmosis SDI-15 & Plugging Formula

Calculate Filtrate Time Ratio (ti / tf), 0.45-um Membrane Plugging Factor PF (%), ASTM D4189 Silt Density Index SDI-T, and % of 5.0 RO Membrane Warranty Ceiling.

Read the guide →
Structural Fatigue Engineering, ASTM E1049 Spectrum Analysis & Miner Damage

ASTM E1049 Four-Point Rainflow & Equivalent Stress Formula

Evaluate ASTM E1049 Four-Point Rainflow Closed-Hysteresis Bounding Condition on Four Consecutive Stress Reversals (S1..S4), Extracted Inner Cycle Range ΔS_23 vs Outer Envelope ΔS_14 (MPa), and Basquin m-Power Equivalent Constant-Amplitude Stress Range ΔS_eq.

Read the guide →
Statistical & Clinical Analysis

ASTRAL Stroke Research: A Weighted Spreadsheet Sum

Explore the arithmetic behind a published stroke research score and understand the limits of predicting individual outcomes.

Read the guide →
Engineering & Science

Astrophysical Virial Theorem: Galaxy Cluster Dynamical Mass & M/L Ratio

Calculate total gravitating dynamical mass M_vir = (5 * R_eff * sigma_r^2) / G (in units of 10^14 solar masses) and dynamical Mass-to-Light ratio M / L from line-of-sight velocity dispersion sigma_r.

Read the guide →
Quantitative Finance & Derivatives

Asymmetric Power Option Formula: Lognormal Power Forward and Volatility

Price power calls MAX(S_T^p - K, 0) in Excel and Arte Sheets by exploiting lognormal closure: S_T^p has exact volatility p*sigma and convexity-boosted power forward E[S_T^p].

Read the guide →
Math

ATAN function: convert percent grade and rise-over-run slope into degrees

Turn road grade percentages (10%, 100%, -8%) or rise/run ratios into slope angles using DEGREES(ATAN(grade)).

Read the guide →
Math

ATAN2 function: calculate full 4-quadrant angles using Excel's (x, y) order

Find exact directional angles from -180 to +180 degrees from (x, y) coordinates with ATAN2—avoiding quadrant loss and Excel's (x_num, y_num) argument trap.

Read the guide →
Financial & Accounting

Atkinson Inequality Index & Equally Distributed Equivalent Income (y_EDE) Formula

Measure social-welfare-weighted income inequality with tunable bottom-tail sensitivity epsilon != 1 using Sir Anthony Atkinson’s 1970 formula A(epsilon) = 1 - y_EDE / mu, where y_EDE = (MEAN(y_i^(1 - epsilon)))^(1 / (1 - epsilon)).

Read the guide →
Healthcare & Clinical Formulas

ATRIA Bleeding Risk Study: Adding the Published Point Weights

Explore the five published ATRIA point weights using fictional binary inputs and complete-data checks.

Read the guide →
Operations & HR Analytics

Attendance Tracking Formula: Net Attendance Rate (Excluding Approved Leave) & Bradford Factor

Calculate fair employee shift attendance % by excluding pre-approved statutory leave from scheduled shifts, and pair it with the HR Bradford Disruption Factor B = S^2 * D.

Read the guide →
Learn with AI

Audit a Capped Partner Rebate Formula from Chat to a Live Shared Workbook

Practise catching an uncapped 8% rebate bug, test MIN(Cap, Billings * Rate) with a changed cap in a live sheet, and understand how peer suggestions, in-app Pro credits, and the submitted ChatGPT connector differ.

Read the guide →
Spreadsheet Governance & Collaborative Training

Audit Academy verifiedLessons vs MCP Learning-Progress Reads

Separate server-verified Academy lesson completion (verifiedLessons) from saved drafts, locked Pro lesson metadata, and read-only MCP training checks in Arte Sheets.

Read the guide →
Logical

Audit case-pack multiples and whole-percentage inputs with MOD and ROUND

Check positive integer pack quantities and percentage-point increments using explicit type guards and a documented numerical tolerance.

Read the guide →
Collaboration & Formula Auditing

Audit Cell Suggestions with Whole-Cell Comment Anchors Before Resolving

Review proposed margin formulas in shared cloud workbooks using whole-cell comment anchors, suggester role guardrails, and changed-input stress checks.

Read the guide →
Collaborative Workflows & AI Governance

Audit Connected-App OAuth Scopes, Base Revisions, and Pending-Review Edits

Validate external MCP write prerequisites (cloud workbook, active Pro, editor/owner role, 16-80 char operation_id, <= 100 cells, and matching base revision vs pendingReview) in Arte Sheets.

Read the guide →
Spreadsheet Governance & Connected Workflows

Audit In-App AI Credits vs MCP Connector Rate Limits

Separate metered monthly in-app Pro Assistant Arte AI credits from 0-credit external OAuth MCP tool calls, shared 120-call/min account burst limits, and Pro write gates.

Read the guide →
AI-Assisted Spreadsheets & Collaboration

Audit Multi-Step Spreadsheet Commands: Row Shifts, Limits, and Rollback

Verify 1-based row insertions, formula range expansion, step/cell limits, and rollback differences between in-app sequential execution and atomic worker commits.

Read the guide →
Collaborative Workflows & AI Governance

Audit Named Workbook Invitations vs Paginated 20x10 Public Links

Verify owner-only Pro sharing gates, named collaborator roles (viewer, contributor, suggester) with in-app-only invitations (emailSent=false), and separate 20x10 paginated public read-only links in Arte Sheets.

Read the guide →
Data Validation & Hygiene

Audit Non-Text Cells and Extract Text-Only Values (ISNONTEXT & T Function Patterns)

Distinguish numbers, booleans, and true blanks from text strings—including zero-length formula strings ""—using NOT(ISTEXT(...)) and IF(ISTEXT(...), cell, "").

Read the guide →
Logical

Audit uppercase-style codes and Monday–Friday dates with EXACT and WEEKDAY

Check that a code is nonblank text unchanged by UPPER, and that a scheduling date is an integer date in 2026 falling Monday through Friday.

Read the guide →
Healthcare & Clinical

AUDIT-C Alcohol Screening: Scoring and Input Checks

Learn what AUDIT-C screens for and practice summing three pre-scored responses without treating missing or inconsistent entries as abstinence.

Read the guide →
Cooperative Game Theory & Restructuring

Aumann-Maschler Contested-Garment Bankruptcy Formula

Calculate Robert Aumann and Michael Maschler’s (1985) Contested-Garment (nucleolus) bankruptcy awards x_1 = 0.5*(E + MAX(0, E - c_2) - MAX(0, E - c_1)) versus pari-passu recovery.

Read the guide →
Ferrous Metallurgy & Foundry Heat Treatment, ASTM A897 Austempered Ductile Iron (ADI)

Austempered Ductile Iron (ADI) Ms & Ausferrite Formula

Calculate Initial Matrix Martensite-Start Ms (°C), Salt-Bath Austempering Superheat Above Ms (°C), T0-Limited Enriched Austenite Carbon C_gamma (wt%), and Enriched Ms (°C).

Read the guide →
Aerospace Carbon/Epoxy Prepreg Layup, Autoclave Consolidation & Laminate CPT

Autoclave Prepreg Fiber Volume & Cured Ply Thickness Formula

Calculate Zero-Void Fiber Volume Fraction Vf (%) from Resin Weight Content, Single Cured Ply Thickness CPT (mm), Total N-Ply Laminate Thickness (mm), and Cured Laminate Density (g/cm³).

Read the guide →
Dynamic Arrays & Lookup

Automatic Row Numbers That Expand Dynamically and Skip Blank Separator Rows

Number task lists automatically without broken #REF! chains using SEQUENCE(COUNTA(...)) for contiguous blocks or IF(ISBLANK(...), "", COUNTA($B$2:B2)) for tables with blank separator rows.

Read the guide →
Statistical

AVEDEV function: measure Mean Absolute Deviation without squaring outliers

Calculate the average absolute distance from the sample mean using AVEDEV when extreme outliers inflate standard deviation.

Read the guide →
Statistical & Clinical Analysis

Average & Sum If Companion Column Is Not Blank (and Exclude Zero Placeholders) with AVERAGEIFS

Average or sum values in column C only where companion column B is populated ("<>") while optionally excluding unrecorded 0 placeholders ("<>0") without triggering #DIV/0!.

Read the guide →
Statistical & Aggregation

Average a Range While Ignoring #DIV/0! and #N/A Errors (AVERAGEIF)

Compute the exact arithmetic mean of valid numeric cells in a range containing formula errors (#DIV/0!, #N/A, #VALUE) using AVERAGEIF(range, "<1E100") without distorting zeros.

Read the guide →
Statistical

Average Call Duration (AHT) Per Month with AVERAGEIFS & EOMONTH

Calculate monthly call-center Average Handle Time (AHT) between dynamic month start >= MonthStart and <= EOMONTH(MonthStart, 0) using AVERAGEIFS—with COUNTIFS zero-call protection.

Read the guide →
Statistical

Average ignoring zeros: exclude 0 placeholders without counting blanks

Use AVERAGEIF(range, "<>0") to skip both blank cells and zero-output shutdown days—and guard all-zero ranges cleanly.

Read the guide →
Averages and missing data

AVERAGE in Excel: why a blank and a zero give different results

Calculate a mean from a small equipment log, show how many readings support it, and avoid replacing missing observations with zero.

Read the guide →
Statistical & Aggregation

Average Non-Zero Values While Keeping or Excluding Negatives (AVERAGEIF)

Exclude placeholder 0.00 cells from KPI and margin averages using AVERAGEIF(range, "<>0") vs. strictly positive AVERAGEIF(range, ">0") with #DIV/0! protection.

Read the guide →
Dynamic Arrays

Average or sum the last N numeric entries with FILTER and TAKE

Select the last N numeric cells in source-row order, retaining zero and negative values while skipping text, blanks and error cells.

Read the guide →
Conditional Aggregation

Average Salary by Department & Job Level (AVERAGEIF / AVERAGEIFS)

Calculate mean base compensation by department with AVERAGEIF and by department + seniority band with AVERAGEIFS, guarding zero-headcount #DIV/0! errors cleanly.

Read the guide →
Statistical

Average top 3 (or top N) scores: drop lowest grades dynamically

Combine SORT, TAKE, and AVERAGE to average the highest N scores—with N driven by a cell instead of a fixed {1,2,3} constant.

Read the guide →