Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Statistical

AVERAGEA 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 averages

AVERAGEIF 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 averages

AVERAGEIFS 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 Economics

Averch-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 →
Science

Avrami (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 Operations

B2B 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 →
Quantitative Finance

Bachelier Normal ATM Option Price & Straddle Breakeven Formula

Price at-the-money options on interest rates, spreads, and commodities that can trade near or below zero using Bachelier’s (1900) arithmetic normal formula C_ATM = DF * sigma_N * SQRT(T / (2 * PI())).

Read the guide →
Civil, Structural & Geotechnical Engineering

Bagnold Stream Power Formula: Cross-Sectional Omega (W/m) & Unit Stream Power omega (W/m^2)

Quantify river geomorphic energy dissipation and channel incision/avulsion potential using Ralph A. Bagnold’s (1966, USGS PP 422-I) Cross-Sectional Stream Power Omega = rho * g * Q * S (W/m) and Specific Unit Stream Power omega = Omega / W (W/m^2).

Read the guide →
Commercial Baking & Cereal Chemistry, Baker’s Percentages, Hydration & Strike Water DDT

Baker’s Percentage Dough Scaling & Strike Water Temp Formula

Calculate Total Baker’s Formula Percentage (>100%), Scaled Total Flour Mass (kg), Hydration Water Mass (kg), and 3-Factor Strike Water Temperature for Desired Dough Temp (°C).

Read the guide →
International Macroeconomics & Development

Balassa-Samuelson Real Exchange Rate Appreciation Formula

Quantify trend real exchange rate appreciation (1 - gamma_T) * ((g_AT - g_AN) - (g_AT* - g_AN*)) and inflation differentials in catching-up economies.

Read the guide →
Financial

Balloon loan formula: monthly payment (PMT with FV) & 5/25 balloon payoff balance

Model commercial balloon mortgages both ways: solve monthly PMT for a fixed maturity residual OR compute the 5-year balloon payoff on a 25-year amortization schedule.

Read the guide →
Psychometrics & Clinical Epidemiology

Bangdiwala’s B Observer Agreement Area Index Formula

Quantify k x k observer agreement geometrically in Excel and Arte Sheets via Bangdiwala’s B = SUM(n_ii^2) / SUM(R_i * C_i) and linear partial-credit weighted B_w.

Read the guide →
Commercial Banking & Financial Institutions

Bank NIM, Efficiency Ratio & Basel III LCR Formula

Calculate bank Net Interest Margin NIM = (Interest_Inc - Interest_Exp) / Avg_Earning_Assets, Overhead Efficiency Ratio, and Basel III 30-day Liquidity Coverage Ratio LCR.

Read the guide →
Financial

Bank statement reconciliation formula: Adjusted Bank vs Adjusted Book balance

Reconcile month-end bank statements against general-ledger cash by adjusting for deposits in transit, outstanding checks, fees, interest, and NSF items.

Read the guide →
Economics & Market Microstructure

Banzhaf Voting Power Index Formula: Weighted Quota, Critical Swings & Power vs. Seat Share

Expose why nominal shareholdings mislead in weighted board voting [Quota q; w_1, w_2, w_3] by counting critical swing coalitions and computing the Normalized Banzhaf Power Index.

Read the guide →
Charts & Visual Data

Bar of Pie & Pie of Pie Chart Formula: Tail-Slice Threshold, "Other" Wedge & Sub-Bar Share

Build a clean Bar-of-Pie or Pie-of-Pie breakdown table by aggregating micro-slices below a percentage threshold into a single "Other" main-pie wedge and computing both within-"Other" and grand-total shares for the secondary bar stack.

Read the guide →
Fixed Income & Portfolio Analytics

Barbell vs Bullet Bond Convexity Advantage Formula

Match modified duration via w_short = (D_long - D_bullet)/(D_long - D_short) and calculate the Barbell Convexity Advantage and parallel-shift outperformance 0.5 * Delta_C * (Delta_y)^2.

Read the guide →
Healthcare Operations & Clinical Analytics

Barber-Johnson Hospital Bed Occupancy, TOI & ALOS Formula

Calculate all four Barber and Johnson (1973) inpatient hospital utilization metrics — Percentage Bed Occupancy, Average Length of Stay (ALOS), Turnover Interval (TOI), and Bed Throughput.

Read the guide →
Healthcare & Clinical Calculations

BARD Score in a Spreadsheet: BMI, AST/ALT, and Diabetes

Explore the original 0–4 point BARD research score for advanced fibrosis in NAFLD using fictional inputs, with checks for missing or invalid values.

Read the guide →
Engineering

Barometric Altitude Pressure & ISA Tropospheric Lapse Rate formulas

Compute International Standard Atmosphere (ISA) air pressure P(h) = 101.325 * (1 - 2.25577E-5 * h)^5.25588 in kPa and standard temperature from 0 to 11,000 meters.

Read the guide →
Quantitative Finance & Derivatives

Barone-Adesi and Whaley Quadratic American Option Early-Exercise Premium

Calculate the Barone-Adesi-Whaley (1987) quadratic exponent q2, smooth-pasting coefficient A2, and early-exercise premium for American options with carry b < r.

Read the guide →
Food, Pharma Blister & Flexible Packaging Engineering, ASTM F1249 WVTR Shelf-Life Mass Balance

Barrier Film WVTR Moisture Permeation & Shelf-Life Formula

Calculate Daily Water-Vapor Permeation Rate (g/day), Allowable Dry-Basis Moisture Budget (g), Predicted Crispness/Potency Shelf Life (days), and Shelf Life in Months.

Read the guide →
Monetary Economics & Central Banking

Barro-Gordon Inflation Bias & Rogoff Central Banker Formula

Calculate discretionary time-inconsistency inflation bias lambda * alpha * Delta_y*, excess social loss, and Rogoff conservative central-banker delegation.

Read the guide →
Ground Improvement, Soft Marine Clay & Prefabricated Wick Drains

Barron Radial Consolidation Vertical Wick Drain Time Formula

Calculate Drain Spacing Ratio n = d_e / d_w, Exact Barron Geometric Factor F(n), Radial Consolidation Time Factor T_r, and Surcharge Waiting Time to Target Consolidation (Months).

Read the guide →
Healthcare & Clinical

Barthel Index: Validating Ten Daily-Activity Scores

Explore the arithmetic of a common 0–100 Barthel Index form, checking each fictional item score individually.

Read the guide →
Healthcare & Clinical

BASDAI: Six Ratings and Five Weighted Domains

Calculate an illustrative BASDAI value from six fictional 0–10 ratings, with complete input checks and context for clinical interpretation.

Read the guide →
Statistical

Baseball OPS (On-Base Plus Slugging), OBP, SLG & Isolated Power (ISO)

Calculate Major League Baseball On-Base Percentage (H + BB + HBP) / (AB + BB + HBP + SF), Total Bases shortcut H + 2B + 2*3B + 3*HR, Slugging, OPS, and Isolated Power.

Read the guide →
Commercial Banking & Prudential Risk

Basel CET1 Ratio, RWA Density & Texas Ratio Formula

Audit bank solvency from three angles: Basel III Common Equity Tier 1 Ratio CET1 / RWA, Risk-Weight Density RWA / Total_Assets, and Gerard Cassidy’s Non-Performing Asset Texas Ratio.

Read the guide →
Banking Regulation & Asset-Liability Management

Basel III Net Stable Funding Ratio (NSFR) Formula

Calculate Basel III Available Stable Funding (ASF), Required Stable Funding (RSF), Structural 1-Year Net Stable Funding Ratio NSFR = ASF / RSF (>= 100%), and Stable Funding Surplus/Deficit.

Read the guide →
Marketing Analytics & Forecasting

Bass Diffusion Model Adoption Curve and Peak Time Formula

Forecast cumulative adopters N(t), peak sales timing t* = MAX(0, LN(q / p) / (p + q)), and peak adoption rate s(t*) = m * (p + q)^2 / (4 * q) using Frank Bass’s (1969) innovation-imitation model.

Read the guide →
Grid Energy Storage (BESS) & Electrochemistry

Battery Coulombic, Voltaic & Round-Trip RTE Formula

Decompose Grid Battery Storage Round-Trip Energy Efficiency RTE = eta_Coulombic * eta_Voltaic from Charge/Discharge Amp-Hours and Mean Voltages, and quantify Dissipated Cycle Energy Loss.

Read the guide →
Energy Finance & Grid Storage Analytics

Battery Levelized Cost of Storage (LCOS) Formula

Calculate utility-scale battery LCOS ($/MWh discharged) using Capital Recovery Factor r/(1 - (1 + r)^(-N)), usable DoD cycles, and round-trip charging cost P_charge / eta_rt.

Read the guide →
Electrochemical Energy Storage & EV Powertrains

Battery Ragone Specific Energy & Peak Power Formula

Calculate Matched-Load Peak Specific Power P_max = V_oc^2 / (4 * R_int * Mass), Ragone Voltage Efficiency (1 + SQRT(1 - P_load / P_max)) / 2, Delivered Specific Energy, and High-Power Runtime.

Read the guide →
Treasury & Corporate Finance

Baumol-Tobin Optimal Cash Replenishment Size and Opportunity Cost Audit

Balance fixed securities-liquidation fees against foregone short-term yield using the Baumol-Tobin square-root cash model C* = SQRT(2 * b * T / i) and verify cost symmetry.

Read the guide →
Economics & Market Microstructure

Baumol’s Cost Disease Formula: Relative Unit Labor Cost & Stagnant Sector GDP Share

Model William Baumol’s (1967) Unbalanced Growth Law: explain why healthcare, education, and live-service unit costs compound at ((1 + g_p) / (1 + g_s))^t when economy-wide wages track progressive-sector productivity.

Read the guide →
Clinical Medicine & Physiology

Baveno VII and VIII: Portal Hypertension Research Models

Compare the 2022 and 2026 Baveno consensus context and reproduce ANTICIPATE model arithmetic with fictional inputs.

Read the guide →
Statistical

Bayes' Theorem formula: Positive Predictive Value (PPV) & false-positive paradox

Use a hypothetical fraud detector to calculate predictive values from prevalence, sensitivity and specificity.

Read the guide →
Law & Economics & Regulatory Compliance

Becker Optimal Enforcement Audit & Sanction Formula

Compute Becker / Polinsky-Shavell maximal-fine audit probability p* = H/W_max - (c_p*G_max)/W_max^2 and explain optimal under-deterrence when auditing is costly.

Read the guide →
Healthcare & Clinical Calculations

Bedside Schwartz Equation: Pediatric eGFR Research Example

Explore the 2009 bedside Schwartz equation, its indexed units and important limits using fictional spreadsheet inputs.

Read the guide →
Brewing Packaging, Bright-Tank Cellaring & Draught Dispense, ASBC Zahm-Nagel Carbonation

Beer Carbonation Volumes CO2 (Zahm-Nagel) & Line Formula

Calculate ASBC Equilibrium Dissolved Carbonation (Volumes CO2 and g/L), Draught Choker Restriction Line Length (ft), and Beer Style Carbonation Band from Gauge Pressure & Temp.

Read the guide →
Engineering

Beer-Lambert Law formula: Absorbance (2 - LOG10(%T)) & Molar Concentration

Convert UV-Vis % Transmittance into Optical Absorbance A = 2 - LOG10(%T) and calculate unknown analyte concentration c = A / (ε · l).

Read the guide →
Statistical & Clinical Analysis

Begg & Mazumdar Rank Correlation Test: Kendall’s τ Funnel Asymmetry Z-Score

Test meta-analytic publication bias nonparametrically using Colin Begg and Madhuchhanda Mazumdar’s (1994) Kendall rank correlation τ and exact variance σ_S² = k*(k - 1)*(2*k + 5) / 18.

Read the guide →
Chemical, Process & Catalysis Engineering

Beggs-Brill Two-Phase Flow Formula: Mixture Froude Number & Horizontal Liquid Holdup H_L(0)

Determine horizontal gas-liquid pipeline Mixture Froude Number N_Fr = v_m^2 / (g * D), Input No-Slip Liquid Fraction lambda_L, and Segregated/Intermittent/Distributed Liquid Holdup H_L(0) via H. Dale Beggs and James P. Brill (1973).

Read the guide →
Statistical & Clinical Analysis

Beighton Score in a Spreadsheet: Joint Hypermobility and Age-Related Context

Sum five documented Beighton item groups and understand how maturity, age and the 2023 pediatric framework affect interpretation.

Read the guide →
Engineering & Science

Bélanger Equation: Hydraulic Jump Sequent Depth & Specific Energy Head Loss

Calculate rectangular stilling-basin sequent depth y_2 = 0.5*y_1*(SQRT(1 + 8*Fr_1^2) - 1) and turbulent energy dissipation ΔE = (y_2 - y_1)^3 / (4*y_1*y_2).

Read the guide →
Engineering & Fluid Mechanics

Bell-Delaware Method Formula: Shell-Side Heat Transfer Coefficient (Jc, Jl, Jb, Js, Jr)

Correct ideal crossflow tube-bank heat transfer h_id for real TEMA shell-and-tube baffle geometry, leakage, bundle bypass, unequal spacing, and laminar gradients via h_s = h_id * Jc * Jl * Jb * Js * Jr.

Read the guide →
Mechanical Machine Design, DIN 2092 Belleville Springs & Live Loading

Belleville Disc-Spring Parallel & Series Stack Formula

Calculate DIN 2092 Belleville Coned-Disc Spring Stack Load Capacity (N), Total Axial Deflection (mm), Effective Stack Stiffness Rate (N/mm), and Elastic Energy Stored (J).

Read the guide →
Aviation Yield Management & Dynamic Pricing

Belobaba EMSR-a Nested Seat Protection Formula

Calculate Pairwise Littlewood Seat Protections y_13 and y_23 under Exponential High-Fare Demand, Belobaba’s Additive EMSR-a Joint Protection Y_12, and Nested Discount Class Booking Limit.

Read the guide →
Bulk Material Handling, CEMA Belt Conveyors, Mining & Aggregate Plant Engineering

Belt Conveyor Bulk Tonnage Capacity & Drive Power Formula

Calculate CEMA Mass Conveying Capacity Q_m (t/h), Potential Gravity Lift Power P_lift (kW), Horizontal Idler Rolling Friction Power P_fric (kW), and Required Drive Motor Shaft Power (kW).

Read the guide →
Open-Pit Mining Engineering, Quarry Drill-and-Blast Design & Fragmentation Economics

Bench Blasting Burden, Stemming & Powder Factor Formula

Calculate In-Situ Bank Rock Volume Per Hole (m³), Bulk Explosive Charge Mass Per Blasthole (kg), Volumetric Powder Factor (kg/m³), and Mass Powder Factor (kg/metric ton).

Read the guide →