Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

PCB Power Layout, IPC-2221 Copper Trace Ampacity & DC Rail Voltage Drop

IPC-2221 PCB Copper Trace Width & Voltage Drop Formula

Calculate IPC-2221 Required Copper Cross-Section (sq mils), Minimum PCB Trace Width (mm), Trace Series DC Resistance (mOhm), and End-to-End IR Voltage Drop (mV).

Read the guide →
Statistical & Clinical Analysis

IPI and R-IPI for Lymphoma: Scores, Groups and Context

Count five historical lymphoma prognostic factors and compare classic IPI and R-IPI groupings with complete example inputs.

Read the guide →
Financial

IPMT function: calculate the interest portion of any loan payment period

Isolate exact monthly interest charges at the beginning, middle, or end of an amortizing loan using IPMT.

Read the guide →
Equity Capital Markets & IPO Syndicate

IPO Underpricing, Gross Spread & Greenshoe Formula

Calculate IPO First-Day Underpricing Pop, Jay Ritter’s Money Left on the Table, Net Issuer Proceeds after Underwriter Gross Spread, and 15% Greenshoe Over-Allotment exercise vs stabilization.

Read the guide →
Healthcare & Clinical

IPSS / AUA-SI: Urinary Symptom Score and Subscores

Sum seven IPSS symptom points, see the numerical symptom band, and compare the commonly used storage and voiding subscores.

Read the guide →
Statistical & Engineering

IPv4 CIDR Subnet Usable Host Count & 8-Bit Binary Octet Conversion Formula

Calculate total and usable IPv4 addresses for any /8–/32 CIDR prefix (2^(32 - prefix) - 2, honoring RFC 3021 /31 and /32 rules) and convert 0–255 octets to exact 8-bit binary strings.

Read the guide →
Real Estate Taxation, IRC Section 1031 Exchanges & Carryover Basis

IRC Section 1031 Like-Kind Exchange Boot & Basis Formula

Calculate IRC Section 1031 Real Estate Exchange Realized Gain ($M), Cash Plus Net Mortgage-Relief Boot under Treas. Reg. §1.1031(d)-2 ($M), Taxable Gain Recognized ($M), and Substituted Replacement-Property Tax Basis ($M).

Read the guide →
Venture Capital Taxation, IRC Section 1202 QSBS & Founder Exits

IRC Section 1202 QSBS Gain Exclusion Cap (10x Basis) Formula

Calculate IRC Section 1202 Qualified Small Business Stock Per-Issuer Exclusion Cap ($M), Excluded Federal Gain ($M), Residual Taxable Gain ($M), and Federal Cash Tax Saved ($M).

Read the guide →
M&A Tax Structuring, Corporate Acquisitions & IRC Section 338(h)(10)

IRC Section 338(h)(10) Basis Step-Up & Tax Shield PV Formula

Calculate Joint IRC Section 338(h)(10) / 336(e) Deemed-Asset-Sale 15-Year Section 197 Annual Amortization, Annual Buyer Cash Tax Shield, Present Value of the 15-Year Tax Shield Annuity, and Net Value Created After Seller Tax Gross-Up.

Read the guide →
Corporate Tax Accounting, M&A Tax Structuring & US IRC Section 382

IRC Section 382 NOL Annual Limitation & Built-In Gain Formula

Calculate US IRC Section 382 Post-Acquisition Base Annual NOL Limitation (Pre-Change Equity * Long-Term Tax-Exempt Rate), Recognized Built-In Gain (RBIG) Augmented Cap, TCJA 80%-Taxable-Income-Bound Deduction, and 21% Cash Tax Shield.

Read the guide →
Equity Compensation, Personal Finance & IRC Section 423 ESPP Plans

IRC Section 423 ESPP 15% Lookback & Minimum Return Formula

Calculate Qualified IRC Section 423 Employee Stock Purchase Plan (ESPP) Lookback Purchase Price (85% of Lower of Grant or Purchase Price), Shares Acquired, Immediate Dollar Gain ($), and 6-Month Holding Return % across Bull and Bear Markets.

Read the guide →
Startup Equity Compensation, IRC Section 83(b) & Tax Planning

IRC Section 83(b) Election Restricted-Stock Tax Formula

Calculate IRC Section 83(b) Day-1 Upfront Ordinary Tax ($k), Total Lifetime Tax With 83(b) ($k), Total Lifetime Tax Without 83(b) ($k), and Net Founder Tax Savings ($k).

Read the guide →
Clinical Medicine & Physiology

Ireton-Jones Energy Research and a Separate Weighted Sum

Learn how energy-estimation equations were studied and practice a fictional spreadsheet weighted sum.

Read the guide →
Coastal Hydraulics, Sea-Dike Overtopping & Wave Mechanics

Iribarren Surf Similarity Parameter & Wave Runup Formula

Calculate Deep-Water Wavelength L_0 (m), Iribarren Surf-Similarity Number xi_0, Smooth-Dike 2% Exceedance Wave Runup Height R_u2% (m), and Wave Breaker Regime.

Read the guide →
Financial

IRR function: calculate Internal Rate of Return across uneven cash flows

Find the periodic discount rate that sets project Net Present Value to zero with IRR, and understand why cash flows need at least one sign change.

Read the guide →
Financial Modeling

Irregular-Date Internal Rate of Return (XIRR Equation, Newton Step & XNPV = 0 Proof)

Solve and audit exact annualized IRR on irregular calendar dates using ACT/365 day-count exponents (d_i - d_0) / 365, Newton-Raphson updates, and zero-XNPV verification.

Read the guide →
Mechanical & Structural Engineering

Irwin Mode I Stress Intensity Factor K_I and Critical Crack Size Formula

Compute Mode I opening stress intensity K_I = Y * sigma * SQRT(PI() * a), fracture safety factor K_IC / K_I, and critical crack length a_crit while guarding millimeter unit traps.

Read the guide →
Information

ISBLANK function: why formula "" cells return FALSE and how to test both

Distinguish genuinely untouched cells (ISBLANK = TRUE) from zero-length formula strings "" and spaces.

Read the guide →
Engineering & Scientific

Isentropic Choked Nozzle Critical Pressure Ratio & Sonic Mass Flow Rate

Determine whether gas discharge through a relief valve or converging nozzle is subsonic or choked at Mach 1 using critical ratio (2/(gamma+1))^(gamma/(gamma-1)) and unified Saint-Venant mass flow.

Read the guide →
Information

ISERR function: detect broken math errors (#DIV/0!, #VALUE) while ignoring #N/A

Separate broken calculation errors from expected #N/A missing-lookup markers using ISERR vs ISERROR.

Read the guide →
Information

ISERROR function: flag and count any formula error without masking values

Return TRUE for #DIV/0!, #VALUE!, #N/A, #REF!, and #NUM! using ISERROR so audit columns and pre-send checks spot broken rows immediately.

Read the guide →
Information

ISEVEN and ISODD: test number parity for alternating-row banding and routing

Route odd/even street numbers, badge IDs, or worksheet rows with ISEVEN and ISODD—including decimal truncation rules.

Read the guide →
Information

ISFORMULA function: catch hardcoded manual overrides in calculated columns

Audit financial models with ISFORMULA to spot cells where someone typed a static number over a live formula.

Read the guide →
Information

ISLOGICAL function: verify real TRUE/FALSE values vs text "TRUE" or 1/0

Check whether imported flag columns hold genuine logical booleans (TRUE/FALSE) rather than strings or numbers using ISLOGICAL.

Read the guide →
Information

ISNA function: test specifically for #N/A missing-lookup results

Return TRUE only when a lookup produces #N/A—while returning FALSE on #DIV/0! or valid matches—to reconcile unmatched IDs cleanly.

Read the guide →
Cleaning imported data

ISNUMBER and ISTEXT: spot numbers stored as text that SUM ignores

Diagnose why SUM under-reports imported amounts by checking each cell’s stored data type with ISNUMBER and ISTEXT before converting.

Read the guide →
Cleanroom Engineering, Semiconductor Fabs & ISO 14644-1 Contamination Control

ISO 14644-1 Cleanroom Particle Limit & Recovery Time Formula

Calculate ISO 14644-1 Maximum Airborne Particle Concentration Cn (particles/m³) at Size D (µm), HEPA Air Changes Per Hour (ACH), Ideal Well-Mixed 100:1 Cleanliness Recovery Time (Minutes), and EU GMP / ISO 14644-3 15-Minute Recovery Gate.

Read the guide →
Mechanical Machine Design, Tribology & ISO 281 Rolling Bearings

ISO 281 Rolling-Bearing L10 Fatigue Life & Hours Formula

Calculate ISO 281 Bearing Load Ratio (C/P), Basic 90%-Reliability Rating Life L10 (million revolutions), Operating Service Life L10h (hours), and Continuous Operating Days.

Read the guide →
Equity Compensation, IRC Section 422 ISOs & Alternative Minimum Tax

ISO Stock Option Bargain Element & AMT Crossover Formula

Calculate Incentive Stock Option (ISO) Form 6251 Bargain Element ($k), Tentative Minimum Tax TMT ($k), Incremental Cash AMT Payable ($k), and Maximum AMT-Free Exercise Shares (k).

Read the guide →
Date & Time

ISO week number and YYYY-Www label formula (year-boundary safe)

Calculate exact ISO-8601 week numbers (1–53) and ISO week-years ("2026-W53") using Thursday-anchor date math that works in every spreadsheet.

Read the guide →
Power Electronics & Isolated AC-DC Supply Design

Isolated Flyback Converter Duty Cycle & Vds Stress Formula

Calculate Coupled-Inductor Flyback Reflected Primary Voltage V_ref = (V_out + V_f)*(N_p/N_s), CCM Duty Cycle D = V_ref / (V_in + V_ref), Peak Primary MOSFET Drain-Source Stress V_ds_pk, and 80%-Derated Breakdown Headroom.

Read the guide →
Healthcare & Clinical

ISS and NISS: Injury Severity Scores from AIS Grades

Compare the Injury Severity Score and New Injury Severity Score using regional versus individual injury AIS grades, with input validation.

Read the guide →
Healthcare & Clinical

ISTH Overt DIC Score: 2025 Proposed D-Dimer Thresholds

Calculate the proposed 2025 ISTH overt DIC score with D-dimer relative to the laboratory upper limit, platelet count, PT prolongation and fibrinogen.

Read the guide →
Math

IV rate unit-conversion exercises: drops/minute and mL/hour

Practice spreadsheet dimensional analysis with fictional infusion inputs. These exercises are not a validated dosing or pump-setting tool.

Read the guide →
Statistical

Jaccard Similarity Index & Hamming Distance formulas (SUMPRODUCT)

Compare binary feature sets and equal-length codes via Jaccard Similarity |A n B| / |A u B| (ignoring shared 0-0 absences) and Hamming Distance mismatch count.

Read the guide →
Business & Operations

Jackson Open Queueing Network: Total WIP & End-to-End Sojourn Time

Analyze multi-station M/M/1 manufacturing, hospital, or microservice networks with rework loops using Jackson's Theorem: L = SUM(lambda_i / (mu_i - lambda_i)) and Little's Law W = L / gamma_ext.

Read the guide →
Operations Research & Queueing

Jackson Queueing Network Rework Traffic Equations and Lead Time

Solve Jackson’s (1957) rework traffic balance lam_eff = lam_ext / (1 - p_rework), station utilizations, total WIP, and Little’s Law customer cycle time without throughput errors.

Read the guide →
Clinical Medicine & Physiology

Jackson–Pollock Three-Site Skinfold Equations: Density and Body-Fat Estimates

Compare the Jackson–Pollock and Jackson–Pollock–Ward three-site body-density equations and a separate Siri conversion, with input checks and source-population limitations.

Read the guide →
Civil, Structural & Geotechnical Engineering

Janbu Simplified Noncircular Slope Stability Formula: Correction Factor f_0 & FS_J

Analyze shallow translational and composite noncircular slip surfaces using Nilmar Janbu’s Simplified Method: compute empirical interslice shear correction f_0 = 1 + b_1 * ((d / L) - 1.4 * (d / L)^2) and corrected FS_J = f_0 * FS_0.

Read the guide →
Statistical & Econometric

Janoschek Growth Curve Formula: Bounded Sigmoidal Size & Inflection Age

Model nonzero-birth biological and forestry growth L(t) = L_∞ - (L_∞ - L_0) * EXP(-k * t^p) and compute exact analytical inflection age t_inf = ((p - 1) / (k * p))^(1 / p).

Read the guide →
Bulk Solids Mechanics, Eurocode EN 1991-4 Grain/Cement Silo Design & Janssen Theory

Janssen Silo Wall Friction & Pressure Saturation Formula

Calculate Janssen Characteristic Screening Depth z0 (m), Saturated Vertical Floor Pressure Pv(z) (kPa), Lateral Silo Wall Hoop Pressure Ph(z) (kPa), and Naive Hydrostatic Fluid Overprediction (kPa).

Read the guide →
Statistical

Jarque-Bera Normality Test: Skewness & Excess Kurtosis Chi-Square P-Value

Test whether regression residuals or asset returns follow a normal distribution using the Jarque-Bera statistic JB = (n / 6) * (S^2 + (K_excess^2 / 4)) and exact df = 2 exponential p-value EXP(-JB / 2).

Read the guide →
Science

Jeans Length & Jeans Mass Formula (Star-Formation Cloud Collapse)

Calculate the isothermal Jeans wavelength and the mass in a sphere of half that wavelength. Keep the linear-perturbation convention consistent and explore temperature and density scaling in a live worksheet.

Read the guide →
Statistical & Clinical Analysis

Jeffreys Beta(0.5, 0.5) Binomial Posterior Mean & Standard Deviation Formula

Estimate rare-event and zero-numerator binomial proportions without collapsing to 0% using Harold Jeffreys’ invariant Beta(1/2, 1/2) posterior mean (x + 0.5)/(n + 1) and exact posterior standard deviation.

Read the guide →
Corporate Governance & Capital Structure

Jensen Free Cash Flow Agency & Debt Discipline Formula

Model Michael Jensen’s (1986) Free Cash Flow overinvestment agency loss and quantify how mandatory debt service curbs negative-NPV empire building before triggering underinvestment.

Read the guide →
Corporate Governance & Agency Theory

Jensen-Meckling Outside-Equity Agency Cost Formula

Calculate managerial perk extraction F* = (1 - alpha)/k_u, realized equity value, and exact residual agency deadweight loss (1 - alpha)^2 / (2*k_u) under diluted inside ownership.

Read the guide →
Financial Modeling

Jensen’s Alpha (CAPM Abnormal Return) & Systematic Beta Return Attribution

Decompose realized portfolio return into risk-free carry, systematic market-beta exposure, and manager selection skill (Jensen’s Alpha = R_p - [R_f + beta * (R_m - R_f)]).

Read the guide →
Engineering & Science

Joback Group-Contribution Method: Boiling Point (T_b) & Critical Temp (T_c)

Estimate pure-component normal boiling point T_b = 198.2 + SUMPRODUCT(n, ΔT_b) and Lydersen-Joback critical temperature T_c = T_b / (0.584 + 0.965*ΣΔT_c - (ΣΔT_c)^2) directly from functional group counts.

Read the guide →
Engineering

Johnson–Euler Column Curve: Critical Stress and Transition

Calculate a piecewise Johnson–Euler critical-stress estimate, use the unrounded transition slenderness and convert stress to load with consistent units.

Read the guide →
Operations & Analytics

Johnson’s Rule Two-Machine Flow-Shop Makespan (Cmax) & Utilization

Classify jobs into Johnson’s Rule Group 1 (M1 <= M2, sort ascending M1) vs. Group 2 (M1 > M2, sort descending M2) and compute exact 4-job flow-shop makespan Cmax and Machine 2 utilization.

Read the guide →