Learn one useful thing today.
Alloy Bow Shackle Side-Load Derating & Pin D/d Formula
Calculate ASME B30.26 Side-Pull Angle Multiplier, Derated Shackle Working Load Limit WLL (t), Wire-Rope Eye Pin D/d Bending Efficiency (%), and Shackle Utilization (%).
Read the guide →Quantitative FinanceAlmgren-Chriss Optimal Execution Market Impact & Urgency Kappa Formula
Calculate expected implementation shortfall E[Cost] = 0.5 * gamma * X^2 + (eta / tau) * SUMPRODUCT(n_k, n_k) and execution urgency kappa = SQRT(lambda_risk * sigma^2 / eta) across child-order slices.
Read the guide →Urban Economics & Real Estate ValuationAlonso-Muth-Mills Monocentric Bid-Rent & Fringe Formula
Model urban floor-space rent decay p_H(d) = p_H(0) * (1 - t*d/Y)^(1/alpha), suburban dwelling expansion, and agricultural city-edge radius d_max.
Read the guide →FinancialAltman Z-Score formula: corporate credit risk & bankruptcy distress zones
Practice the common rounded-coefficient Altman Z-score for public manufacturing firms and its conventional zones. The result is a screening metric, not a default probability.
Read the guide →Drinking-Water Coagulation, Jar-Test Stoichiometry & ResidualsAlum Coagulation Alkalinity Consumed & Sludge Yield Formula
Calculate Filter Alum Alkalinity Consumed (mg/L CaCO3), Unadjusted Remaining Alkalinity (mg/L), Supplemental Alkalinity Dose Required (mg/L CaCO3), and Daily Dry Alum Sludge (kg/d).
Read the guide →Aerospace MIL-A-8625 Aluminum Anodizing, Type III Hardcoat & CNC Pre-Plate AllowanceAluminum Sulfuric Anodizing "720 Rule" & Growth Formula
Calculate Target Coating Thickness in Mils (0.001 in), Sulfuric-Bath Anodizing Tank Time via the 720 Rule (min), Total Titanium-Rack DC Rectifier Load (A), and Outside-Diameter Dimensional Growth (um).
Read the guide →EngineeringAmdahl's Law parallel speedup, asymptotic ceiling & Gustafson's Law formulas
Calculate multi-core / GPU parallel speedup 1 / ((1 - p) + p / N), infinite-core serial bottleneck limit 1 / (1 - p), and Gustafson's scaled speedup.
Read the guide →Quantitative FinanceAmihud (ILLIQ) Illiquidity Ratio Formula: Return Impact per $1M Volume
Measure stock market illiquidity from standard daily bars using Amihud’s (2002) ratio ILLIQ = (1 / D) * Sum(|R_t %| / DollarVolume_MUSD_t) without requiring tick-level order-book data.
Read the guide →Bioenergy, Anaerobic Digestion & Wastewater Resource RecoveryAnaerobic Digester VS Destruction, Biogas & CHP kWe Formula
Calculate Mesophilic Anaerobic Digester Destroyed Volatile Solids (kg/d), Raw Biogas Production (Nm³/d), Pure Biomethane Yield (Nm³/d), and Continuous Cogeneration CHP Power (kWe).
Read the guide →Logical checks and errorsAND function: require two inspection checks to pass together
Accept a chilled delivery only when the recorded temperature is within limit and the receiver has signed off, while preventing blank temperature cells from passing as zero.
Read the guide →International Trade & Spatial EconometricsAnderson-van Wincoop Gravity & Multilateral Resistance
Compute structural bilateral trade X_ij = (Y_i * Y_j / Y_W) * (t_ij / (Pi_i * P_j))^(1 - sigma) and expose naive Tinbergen border-puzzle bias.
Read the guide →Quantitative Finance & RiskAndrew Lo Autocorrelated Sharpe Ratio Annualization Formula
Replace naive SQRT(12) Sharpe annualization on smoothed or illiquid returns with Andrew Lo’s (2002) exact AR(1) serial-correlation scaling factor eta(q, rho_1).
Read the guide →Finance & AccountingAnnual Compound Interest Schedule: Year-by-Year Opening, Interest & Ending Balance
Build a multi-year compound interest rollforward table showing Beginning Balance, Annual Interest Earned, and Ending Balance—reconciled against P * (1 + r)^n and FV.
Read the guide →Statistical & Clinical AnalysisAnscombe-Gart +0.5 Continuity-Corrected Odds Ratio Formula for Zero-Event 2×2 Tables
Prevent #DIV/0! and infinite log-odds collapse in sparse clinical trials with zero events in one arm by adding +0.5 to all four 2×2 cells: OR_corr = ((a + 0.5)*(d + 0.5)) / ((b + 0.5)*(c + 0.5)) and SE(ln OR) = SQRT(1/(a+0.5) + 1/(b+0.5) + 1/(c+0.5) + 1/(d+0.5)).
Read the guide →EngineeringAntoine Vapor Pressure Equation & Vacuum Boiling Point Temperature
Estimate water saturation pressure and invert the Antoine correlation within the documented 1–100°C range, using mmHg absolute pressure.
Read the guide →Healthcare & Clinical FormulasAPACHE II Score & Predicted ICU In-Hospital Mortality (%)
Sum Acute Physiology Score (APS, 0–60), Age Points (0–6), and Chronic Health Points (0, 2, or 5) into total APACHE II (0–71) and compute Knaus logistic hospital mortality (%) with diagnostic category weight.
Read the guide →Healthcare & Clinical CalculationsApfel Simplified PONV Risk Score & Multimodal Prophylaxis Calculator
Calculate the 0–4 Apfel Postoperative Nausea and Vomiting (PONV) score, baseline unprophylaxed PONV probability (10%, 21%, 39%, 61%, 79%), and Fourth Consensus antiemetic prophylaxis tier.
Read the guide →StatisticalApgar score spreadsheet exercise: validate five integer subscores
Sum five fictional 0–2 scores and practice validated band comparisons, with explicit limits on clinical interpretation.
Read the guide →Process Safety, API 520 Pressure-Relief Sizing & Mechanical IntegrityAPI 520 Liquid Relief Valve Orifice Area & API 526 Formula
Calculate API 520 Part I Liquid Relieving Differential Pressure (psi), Required Effective Orifice Area (in²), Rupture-Disk Combination Area (in²), and Selected API 526 Standard Orifice.
Read the guide →Process Safety, API 521 Flare Systems & Thermal RadiationAPI 521 Elevated Flare Thermal Radiation & Exclusion Formula
Calculate API 521 Point-Source Radiated Heat Power (MW), Minimum Safe Slant Distance D (m), Required Ground-Level Sterile Exclusion Radius R (m), and Grade Radiation at Stack Base (kW/m²).
Read the guide →Casing & Tubing Mechanical Design, API TR 5C3 / ISO 10400 Biaxial Collapse EllipseAPI 5C3 Casing Biaxial Tension Collapse Derating Formula
Calculate Casing Diameter-to-Thickness Ratio (D/t), Hencky-von Mises Biaxial Yield Reduction Factor, Effective Axial-Derated Yield Ypa (psi), and Biaxial Collapse Rating Pca (psi).
Read the guide →EngineeringApparent vs Absolute Magnitude, Distance Modulus & Pogson Flux Ratio
Calculate stellar absolute magnitude and distance in parsecs using consistent photometric bands, with an explicit extinction correction.
Read the guide →Dynamic ArraysAppend Ranges Horizontally & Vertically (HSTACK & VSTACK) While Dropping Blanks
Join side-by-side column blocks with HSTACK and append multi-region tables with VSTACK + FILTER so pre-allocated blank rows never leak zeros into consolidated reports.
Read the guide →Lookup & ReferenceApproximate Tier Lookup with Multiple Criteria (FILTER + XLOOKUP Weight Breaks)
Look up volume-discounted freight or commission rates where exact Zone and Service criteria combine with an approximate weight-break threshold—using FILTER inside XLOOKUP(..., -1).
Read the guide →Supply Chain Analytics & Inventory TheoryAR(1) & Moving-Average Order-Up-To Bullwhip Formula
Calculate Lee, Padmanabhan, and Whang’s (1997) exact AR(1) MMSE order-up-to variance amplification ratio and Chen et al.’s (2000) p-period moving-average bullwhip lower bound.
Read the guide →Welding Metallurgy, EN 1011 / AWS D1.1 WPS Qualification & Hydrogen Cold CrackingArc Welding Heat Input & IIW Carbon Equivalent (CE) Formula
Calculate Gross Arc Power (kW), EN 1011 Thermal-Efficiency-Factored Linear Heat Input Q (kJ/mm), IIW Carbon Equivalent CE_IIW (%), and Hydrogen Cold-Cracking Preheat Requirement.
Read the guide →EngineeringArchard Sliding Wear Equation: Wear Volume & Linear Depth (Tribology)
Calculate mechanical sliding wear volume V = (K * F_N * s) / H (mm^3) and bushing/brake-pad linear wear depth h = (K * P * s) / H from Archard's dimensionless wear coefficient K, load F_N, sliding distance s, and hardness H.
Read the guide →Petrophysics, Well-Log Interpretation & VolumetricsArchie Water Saturation (Sw) & Formation Factor Formula
Calculate Clean-Sandstone Formation Resistivity Factor F, Archie Water Saturation Sw, Hydrocarbon Saturation Sh, and Hydrocarbon Pore-Thickness HPV (m).
Read the guide →EngineeringArchimedes' Buoyancy Force, Apparent Immersed Weight & Iceberg Draft fraction
Calculate static buoyancy and a floating volume fraction, distinguishing neutral buoyancy and signed support force under full immersion.
Read the guide →Math & TrigArea of a triangle, trapezoid, and parallelogram (plus Heron's 3-side formula)
Compute planar land, roofing, and sheet-metal areas from base and perpendicular height—or from three measured triangle sides.
Read the guide →Statistical & Clinical AnalysisARISCAT Score Formula: Postoperative Pulmonary Complications (PPC) Risk
Calculate Jaume Canet’s 7-factor ARISCAT score (0–123 points) predicting postoperative respiratory failure, pneumonia, and atelectasis across Low (< 26), Intermediate (26–44), and High (>= 45) surgical risk.
Read the guide →Platform Economics & Marketplace PricingArmstrong Competitive Bottleneck Platform Formula
Price asymmetric marketplaces via Mark Armstrong’s (2006) Competitive Bottleneck model: subsidize single-homing buyers P_1* = c_1 + t_1 - (alpha_2 - c_2) and monopoly-charge multi-homing sellers.
Read the guide →Quantitative Finance & TradingAroon Up, Aroon Down & Aroon Oscillator Formula: Time-Since-Extreme Trend Gauge
Measure trend freshness on a [0, 100] scale using Tushar Chande’s Aroon-Up = 100 * (N - Bars_Since_High) / N, Aroon-Down, and bounded [-100, +100] Aroon Oscillator.
Read the guide →Engineering & ScienceArora Silicon Electron Mobility Model: Joint Temperature & Doping Law
Calculate n-type silicon electron mobility μ_n(T, N) (cm^2/(V·s)) across 200–500 K and arbitrary doping N via Narain Arora’s 1982 TCAD temperature-scaled Caughey-Thomas equations.
Read the guide →Petroleum Reservoir Engineering & ReservesArps Exponential, Hyperbolic & Harmonic Decline Formula
Forecast Oil/Gas Production Rate q(t) and Cumulative Recovery N_p(t) across all three J.J. Arps (1945) decline regimes (Exponential b = 0, Hyperbolic 0 < b < 1, and Harmonic b = 1) without #DIV/0! singularities.
Read the guide →EngineeringArrhenius and Q10 temperature-rate ratios in a spreadsheet
Compare idealized temperature-rate models with explicit units and assumed coefficients. A rate ratio alone does not establish a product shelf life.
Read the guide →Charts & Visual DataArrow & Dumbbell Chart Formula: Floating Base Anchor, Gain/Loss Span & Midpoint
Stage directional Arrow or Dumbbell change charts by pairing an invisible floating base MIN(Prior, Current) with separate Positive-Gain and Negative-Drop span columns and a centered delta-label midpoint.
Read the guide →Spreadsheet Automation & AI WorkflowsArte Sheets AI Assistant File Attachments: Safe .xlsx/.csv/.tsv/.txt Excerpts & Size Limits
Attach .xlsx, .csv, .tsv, or .txt reference files (up to 2 MB) to the Arte Sheets AI Assistant: understand isolated Web Worker parsing, zero macro/formula execution, and excerpt row/byte caps.
Read the guide →Spreadsheet Operations & CollaborationArte Sheets AI Assistant Formula Guardrails: Bounded Ranges, Spill Rules & Atomic Undo
Design reliable AI cell patches within Arte Sheets’ live validation rules: <= 100 unique non-merged/non-spill cells per patch, explicit ranges <= 10,000 cells (no A:A or [book] links), scalar alternatives to blocked spill/volatile functions, and atomic rollback.
Read the guide →Spreadsheet Automation & AI WorkflowsArte Sheets AI Assistant Permission-Aware Sharing: Owner Confirmation & Collaborator Roles
Prepare collaborator invitations safely through the Arte Sheets AI Assistant: understand owner-only permissions, viewer/suggester/contributor roles, untrusted-cell email protection, and mandatory Send Invitation confirmation.
Read the guide →Spreadsheet Operations & CollaborationArte Sheets AI Assistant Sheet Commands & Stale-Version Protection in Live Collaboration
Understand how Arte Sheets protects real-time multi-user workbooks by binding AI proposals to {workbookId, sheetId, version} and enforcing sheet naming rules (<= 31 chars, < 200 sheets, no \ / ? * [ ] :) across create_sheet, rename_sheet, and select_sheet.
Read the guide →Spreadsheet Automation & AI WorkflowsArte Sheets AI Voice & Multi-Step Commands: WebRTC Sessions & 10-Step Execution Budgets
Combine spoken WebRTC voice commands (up to 3 minutes per call with native barge-in) and multi-step workbook plans (up to 10 ordered steps, 100 edited cells, and 20 row/column edits) safely in Arte Sheets.
Read the guide →Receptor Pharmacology & BioassayArunlakshana-Schild Dose Ratio & pA2 Affinity Formula
Calculate Competitive Antagonist Dose Ratio DR = EC50_antag / EC50_ctrl, Schild Ordinate LOG10(DR - 1), Dissociation Constant K_B = [B] / (DR - 1), and negative log affinity pA_2 = -LOG10(K_B).
Read the guide →High-Bay Warehouse Automation, AS/RS Stacker Cranes & Bozer-White Chebyshev TravelAS/RS Crane Bozer-White Single vs Dual Command Formula
Calculate AS/RS Rack Time-Shape Factor b, Expected Single-Command Cycle Time E[SC] (s), Interleaved Dual-Command Cycle Time E[DC] (s), and Dual-Command Throughput (pallets/h).
Read the guide →Banking Credit Risk Accounting & US GAAP ASC 326ASC 326 CECL Lifetime Credit Loss & Q-Factor Formula
Calculate US GAAP ASC 326 Current Expected Credit Loss (CECL) Historical Through-the-Cycle Base Loss EAD*PD*LGD, Macro-Adjusted Lifetime PD MIN(1, PD*Macro_Scalar), Ending Allowance for Credit Losses (ACL), and Quarterly Provision Expense.
Read the guide →Technical Accounting, Valuation Testing & US GAAP ASC 350ASC 350 Goodwill Impairment & Simultaneous Tax Gross-Up Formula
Calculate US GAAP ASC 350 Reporting-Unit Valuation Surplus/Deficit, Non-Deductible Stock-Deal Goodwill Impairment, ASC 350-20-35-8C Tax-Deductible Simultaneous-Equation Impairment Gross-Up, and Post-Impairment Goodwill.
Read the guide →Software Revenue Recognition & US GAAP ASC 606 / IFRS 15ASC 606 / IFRS 15 Relative SSP Bundle Allocation Formula
Allocate Bundled Multi-Element Transaction Price Across Distinct Performance Obligations Using Relative Standalone Selling Prices (SSP), Point-in-Time License Recognition, Ratable PCS Support Revenue, and Deferred Revenue.
Read the guide →Corporate Accounting & Pension Actuarial GAAPASC 715 Pension 10% Corridor & NPPC Formula
Calculate US GAAP ASC 715 Pension 10% Corridor Threshold 0.10 * MAX(PBO, Plan_Assets), Excess Actuarial Loss Amortization, Net Periodic Pension Cost (NPPC), and Balance-Sheet Funded Status.
Read the guide →Corporate Income Tax Footnote Analysis & US GAAP ASC 740ASC 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 →