Learn one useful thing today.
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 AnalysisIPI 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 →FinancialIPMT 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 SyndicateIPO 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 & ClinicalIPSS / 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 & EngineeringIPv4 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 BasisIRC 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 ExitsIRC 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 382IRC 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 PlansIRC 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 PlanningIRC 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 & PhysiologyIreton-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 MechanicsIribarren 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 →FinancialIRR 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 ModelingIrregular-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 EngineeringIrwin 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 →InformationISBLANK 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 & ScientificIsentropic 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 →InformationISERR 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 →InformationISERROR 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 →InformationISEVEN 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 →InformationISFORMULA 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 →InformationISLOGICAL 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 →InformationISNA 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 dataISNUMBER 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 ControlISO 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 BearingsISO 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 TaxISO 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 & TimeISO 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 DesignIsolated 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 & ClinicalISS 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 & ClinicalISTH 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 →MathIV 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 →StatisticalJaccard 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 & OperationsJackson 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 & QueueingJackson 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 & PhysiologyJackson–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 EngineeringJanbu 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 & EconometricJanoschek 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 TheoryJanssen 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 →StatisticalJarque-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 →ScienceJeans 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 AnalysisJeffreys 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 StructureJensen 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 TheoryJensen-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 ModelingJensen’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 & ScienceJoback 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 →EngineeringJohnson–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 & AnalyticsJohnson’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 →