Learn one useful thing today.
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 →Healthcare & Clinical CalculatorsASDAS-CRP (Ankylosing Spondylitis Disease Activity Score) Formula
Calculate the ASAS/EULAR objective axial spondyloarthritis score ASDAS-CRP = 0.121*BackPain + 0.058*Stiffness + 0.110*Global + 0.073*Peripheral + 0.579*LN(MAX(CRP, 2) + 1).
Read the guide →HVAC Ductwork Sizing, ASHRAE Equal-Friction Design & Building Mechanical EngineeringASHRAE 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 →MathASIN 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 →ASME BPVC Section VIII Div. 1 Pressure Vessels, Taylor-Forge Flanges & Gasket SeatingASME 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 AnalysisASPECTS (Alberta Stroke Program Early CT Score 0–10) Formula: MCA Stroke Thrombectomy Gate
Calculate Philip A. Barber et al.’s (2000) 10-point subtractive ASPECTS score (10 minus early ischemic change across 4 subcortical ganglionic + 6 cortical M1–M6 MCA regions) for AHA/ASA acute ischemic stroke endovascular thrombectomy triage.
Read the guide →Date & TimeAssign 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 →MathAssign 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 & TrigAssign 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 SteelsASTM 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 DesignASTM 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 →Structural Fatigue Engineering, ASTM E1049 Spectrum Analysis & Miner DamageASTM 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 AnalysisASTRAL Score Formula: Acute Ischemic Stroke 3-Month Unfavorable Outcome
Calculate Georgios Ntaios & Patrik Michel’s integer ASTRAL score = INT(Age / 5) + NIHSS + 2*Onset>3h + 2*VisualField + 1*AbnormalGlucose + 3*DecreasedLOC for 3-month mRS > 2 prediction.
Read the guide →Engineering & ScienceAstrophysical 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 & DerivativesAsymmetric 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 →MathATAN 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 →MathATAN2 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 & AccountingAtkinson 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 FormulasATRIA Bleeding Risk Score (0–10) for Atrial Fibrillation Anticoagulation
Calculate Margaret Fang’s 5-variable ATRIA major hemorrhage score (0–10: Anemia +3, Severe Renal Disease eGFR <30 or Dialysis +3, Age >=75 +2, Prior Bleed +1, Hypertension +1) to stratify Low (0–3), Intermediate (4), and High (5–10) bleeding risk.
Read the guide →Operations & HR AnalyticsAttendance 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 AIAudit 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 TrainingAudit 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 →LogicalAudit 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 AuditingAudit 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 GovernanceAudit 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 WorkflowsAudit 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 & CollaborationAudit 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 GovernanceAudit 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 & HygieneAudit 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 →LogicalAudit 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 & ClinicalAUDIT-C Alcohol Misuse Screening Score (0–12) & Sex-Specific Cutoff Formula
Calculate the 3-question WHO/VA AUDIT-C consumption score (0 to 12 points) and apply validated sex-specific hazardous-drinking thresholds (>= 4 points in men, >= 3 points in women).
Read the guide →Cooperative Game Theory & RestructuringAumann-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 CPTAutoclave 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 & LookupAutomatic 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 & Clinical AnalysisAverage & 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 & AggregationAverage 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 →StatisticalAverage 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 →StatisticalAverage 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 dataAVERAGE 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 & AggregationAverage 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 ArraysAverage 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 AggregationAverage 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 →StatisticalAverage 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 →StatisticalAVERAGEA function: average ranges where TRUE = 1 and text = 0
Understand exactly how AVERAGEA evaluates logical checkboxes and text entries compared with standard AVERAGE.
Read the guide →Conditional averagesAVERAGEIF in Excel: average readings for one category
Choose a category, average its numeric readings, and check how a missing reading differs from a recorded zero.
Read the guide →Conditional averagesAVERAGEIFS function: average values matching multiple criteria
Calculate the mean turnaround time for rows matching both site and priority, ignore unrecorded blanks while keeping real zeros, and handle #DIV/0! when no rows match.
Read the guide →Regulatory & Energy Utility EconomicsAverch-Johnson Regulated Capital Gold-Plating Formula
Calculate the Averch-Johnson (1962) shadow cost of capital r_eff = r - (lambda/(1 - lambda))*(s - r) and quantify rate-base capital over-intensity ("gold-plating") under rate-of-return regulation.
Read the guide →ScienceAvrami (JMAK) Isothermal Crystallization Fraction & Half-Time Formula
Calculate Johnson-Mehl-Avrami-Kolmogorov (JMAK) transformed phase fraction X(t) = 1 - EXP(-k * t^n) and crystallization half-time t_1/2 = (LN(2) / k)^(1 / n) for polymers, steels, and glasses.
Read the guide →Commercial Pricing & Revenue OperationsB2B Price Waterfall Pocket Price & Margin Formula
Audit on-invoice and off-invoice B2B price leakage (rebates, co-op allowances, early-pay discounts, and free freight) to calculate Pocket Price and Pocket Margin %.
Read the guide →