Learn one useful thing today.
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 3ASC 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 842ASC 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 AOTRASCE 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 CalculatorsASDAS-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 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 →MathASINH, 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 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: 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 & 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 →Desalination & Ultrapure Water Pretreatment, ASTM D4189 Reverse-Osmosis SDI-15ASTM 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 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 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 & 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 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 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 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 & 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 →StatisticalAVEDEV 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 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 →