Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Financial

Beneish M-Score formula: 8-variable forensic earnings manipulation screen

Calculate an eight-input Beneish screening score from prepared accounting indices and compare its unrounded value with an explicit review threshold.

Read the guide →
Statistical

Benford first-digit probabilities and significant-digit extraction

Extract significant digits from numeric amounts and compare a sample count with a theoretical Benford probability; deviations alone do not establish fraud.

Read the guide →
Biostatistics & Multiple Testing

Benjamini-Hochberg FDR vs Holm-Bonferroni Threshold Formula

Compare Benjamini-Hochberg step-up False Discovery Rate critical values (i/m)*q against Holm-Bonferroni step-down Family-Wise Error Rate cutoffs alpha/(m - i + 1) across sorted p-values.

Read the guide →
Healthcare & Clinical Formulas

Berg Balance Scale: Summing 14 Items in a Spreadsheet

Sum fourteen fictional Berg Balance Scale item scores with checks for completeness and valid integers, and understand why the total is not a stand-alone mobility decision.

Read the guide →
Engineering

Bernoulli's Equation & Venturi Flowmeter differential-pressure formula

Calculate volumetric flow rate from Venturi throat pressure drop via Q = Cd * A2 * SQRT(2 * dP / (rho * (1 - (A2/A1)^2))) and throat velocity V2 = Q / A2.

Read the guide →
Electrical & Power Electronics Engineering

Bertotti-Steinmetz Magnetic Core Hysteresis and Eddy Loss Formula

Separate transformer and inductor core loss density into hysteresis k_h*f*B^beta, classical eddy-current k_e*(f*B)^2, and excess domain-wall k_exc*(f*B)^1.5 components.

Read the guide →
Science

BET Adsorption Isotherm: Monolayer Capacity, Constant C & Surface Area

Calculate Brunauer-Emmett-Teller (BET) energetic constant C = 1 + (s / i), monolayer capacity n_m = 1 / (s + i), and N2 specific surface area S_BET (m^2/g) from linearized isotherm slope and intercept.

Read the guide →
Engineering & Science

Bethe-Bloch Mass Stopping Power (-dE/rho*dx) & Proton Bragg Peak Formula

Calculate collisional mass stopping power S_mass = 0.307075 * (Z/A) * (z^2 / beta^2) * (LN((2 * m_e * c^2 * beta^2) / ((1 - beta^2) * I_eV)) - beta^2) in MeV*cm^2/g for protons and alpha particles in tissue/water.

Read the guide →
Engineering & Science

Bethe-Weizsäcker Semi-Empirical Nuclear Binding Energy (Liquid-Drop SEMF)

Calculate total nuclear binding energy B(A, Z) and binding energy per nucleon B / A (MeV) from Volume, Surface, Coulomb, Asymmetry, and ISEVEN/ISODD Pairing terms across the chart of nuclides.

Read the guide →
Rock Mechanics, Tunneling & Underground Mining, Bieniawski RMR89 Classification

Bieniawski Rock Mass Rating (RMR89) & Tunnel Load Formula

Calculate Basic RMR89 (0–100), Strike/Dip Orientation-Adjusted RMR89, Serafim-Pereira Deformation Modulus Em (GPa), and Unal Tunnel Roof Support Load Pressure (kPa).

Read the guide →
Utility-Scale Solar Photovoltaics, IEC 60904-1-2 Bifacial Modules & Yield Modeling

Bifacial Solar PV Albedo Rear Irradiance & Gain Formula

Calculate Unshaded Rear-Side Irradiance G_rear (W/m²), IEC 60904-1-2 Equivalent Effective Irradiance G_eff (W/m²), Bifacial Energy Gain BG (%), and Array DC Output (kW).

Read the guide →
Dynamic Arrays

Biggest gainers and losers formula: extract Top N & Bottom N movers (SORTBY & TAKE)

Rank the largest and smallest percentage changes without reordering the source table. Distinguish top/bottom rankings from positive-only gainers and negative-only losers.

Read the guide →
Lookup & Reference

Billing Lookup with Standard vs. Partner Client Rates (XLOOKUP + IF)

Calculate billable timecard line totals by selecting between Standard and Retainer/Partner hourly rate columns in a role rate card via XLOOKUP and multiplying by hours logged.

Read the guide →
Engineering & Science

Binary Phase Diagram Lever Rule: Liquid & Solid Equilibrium Mass Fractions

Calculate equilibrium liquid mass fraction w_L = (C0 - C_S) / (C_L - C_S) and solid mass fraction w_S = (C_L - C0) / (C_L - C_S) along a horizontal isothermal tie-line in binary alloy phase diagrams.

Read the guide →
Statistical Analysis

Binomial Acceptance Sampling & Critical Defect Cutoff (BINOMDIST & CRITBINOM)

Calculate exact binomial defect probabilities, cumulative lot-acceptance curves, producer’s risk, and the smallest critical defect threshold (CRITBINOM) using exact factorial combinatorics.

Read the guide →
Statistical

Binomial probability formula: exact k successes in n independent trials

Calculate exact binomial probability P(X = k), expected successes n*p, and binomial standard deviation SQRT(n*p*(1-p)) using FACT.

Read the guide →
Clinical Medicine & Physiology

Bioelectrical Impedance: Height² / Resistance and Body-Water Estimates

Explore a bioelectrical impedance index, a published Kushner body-water prediction and a separate fat-free-mass approximation, with limitations of the underlying assumptions.

Read the guide →
Healthcare Corporate Finance, Royalty Monetization & Structured Biotech Debt

Biopharma Synthetic Royalty Hard Cap & Post-Cap Tail Formula

Calculate Non-Dilutive Biopharma Synthetic Royalty Hard-Cap Trigger Sales ($M), Cumulative Royalty + Post-Cap Tail Payout ($M), Biotech Issuer Cap Savings vs Uncapped Royalty, and Royalty Investor Realized Multiple (MOIC).

Read the guide →
Engineering & Science

Bioreactor Volumetric Oxygen Transfer (kLa), OTR & Minimum kLa_min

Calculate aerobic fermenter Oxygen Transfer Rate OTR = k_L*a * (C_star - C_L) (mmol O2/(L*h)), cellular Oxygen Uptake Rate OUR = q_O2 * X, and minimum required k_L*a to prevent dissolved oxygen starvation below C_crit.

Read the guide →
Engineering

Biot (Bi), Prandtl (Pr) & Nusselt (Nu) Heat Transfer Dimensionless Numbers

Calculate Biot, Prandtl and Nusselt numbers with distinct solid/fluid conductivities and an illustrative small-Biot screening check.

Read the guide →
Engineering

Biot Number (Bi), Fourier Number (Fo) & Lumped-Capacitance Cooling

Calculate Biot and Fourier numbers and an approximate lumped transient temperature using a consistent characteristic length. Check inputs and a Bi < 0.1 screening criterion before displaying temperature.

Read the guide →
Biopharma Corporate Development, Licensing & rNPV Valuation

Biotech Clinical Phase POS & Risk-Adjusted rNPV Formula

Calculate Biopharma Cumulative Likelihood of Approval LOA = P_Ph1 * P_Ph2 * P_Ph3_NDA, Risk-Adjusted Commercial Launch PV, Pipeline Asset Risk-Adjusted Net Present Value (rNPV), and Breakeven Approval Probability.

Read the guide →
Engineering & Science

Birch-Murnaghan 3rd-Order Isothermal Equation of State (P–V GPa)

Calculate high-pressure crystal compression P(V) (GPa) in diamond-anvil cells and planetary mantles using Francis Birch’s Eulerian finite-strain 3rd-order Equation of State.

Read the guide →
Healthcare & Clinical

BISAP Research: Five Pancreatitis-Related Flags and a Sum

Explore the five components in the BISAP pancreatitis research score and practice a binary spreadsheet sum.

Read the guide →
Civil, Structural & Geotechnical Engineering

Bishop Simplified Method: One Illustrative Slice Iteration

Work through one trial-factor update for a three-slice circular slope example and distinguish an iteration from a complete stability assessment.

Read the guide →
Statistical & Engineering

Bitwise Permission Flag Extraction & Bit-Shift Formula (INT & MOD Powers of 2)

Test individual permission bits inside integer RBAC bitmasks using INT(MOD(mask / 2^bit, 2)) and perform exact left/right bit shifts (mask * 2^s and INT(mask / 2^s)) in any spreadsheet.

Read the guide →
Date & Time

Biweekly and semimonthly pay schedule formulas (with weekend adjustment)

Generate 26-period biweekly pay dates (+14 days) and 24-period semimonthly 15th/month-end pay dates that step back onto Friday.

Read the guide →
Quantitative Finance & Derivatives

Bjerksund-Stensland Closed-Form American Option Trigger Boundary

Compute the Bjerksund-Stensland (1993) closed-form flat early-exercise boundary I_flat, characteristic root beta, and smooth-pasting coefficient alpha without iterative root-finding.

Read the guide →
Operations, Logistics & Engineering

Bjerrum Field Vane Shear Correction Factor (mu) Formula: Plasticity Index Clay Strength

Correct raw in-situ Field Vane Shear strength s_u,FV for strain-rate and anisotropy effects in high-plasticity soft clays using Laurits Bjerrum’s (1972/1973) mobilization factor mu = 1.7 - 0.54 * LOG10(PI) and s_u,design = mu * s_u,FV.

Read the guide →
Quantitative Finance & Derivatives

Black-Scholes d1, d2 Log-Moneyness & Put-Call Parity Arbitrage Check Formula

Compute Black-Scholes-Merton standardized log-moneyness factors d1 and d2 using LN, SQRT, and EXP alongside Hans Stoll’s model-free European Put-Call Parity pricing residual.

Read the guide →
Mineral Processing, Quarry & Aggregate Comminution, Blake Jaw Crusher Mechanics

Blake Jaw Crusher Nip Angle & Critical RPM Formula

Calculate Crushing-Chamber Nip Angle alpha (deg), Gape-to-CSS Reduction Ratio, Rose & English Critical Toggle Flywheel Speed Ncrit (RPM), and Volumetric Wedge Throughput (t/h).

Read the guide →
Statistical & Econometric

Bland-Altman Bias & 95% Limits of Agreement (LoA) Method-Comparison Formula

Calculate mean inter-device bias d̄ = AVERAGE(D2:D7), difference standard deviation s_d = STDEV.S(D2:D7), and 95% Limits of Agreement d̄ ± 1.96 * s_d to validate clinical measurement instruments.

Read the guide →
Science

Blaney-Criddle Crop Evapotranspiration (ETo, ETc) & Net Irrigation

Calculate FAO Blaney-Criddle reference evapotranspiration ETo = p * (0.46 * T_mean + 8) (mm/day), crop water demand ETc = K_c * ETo, and monthly Net Irrigation Requirement MAX(0, 30 * ETc - P_eff).

Read the guide →
Robotics, UAV Propulsion & Electric Drivetrain Engineering, BLDC Motor Kv & Kt Physics

BLDC Motor Kv Constant, Torque Kt & Shaft Power Formula

Calculate Exact SI Torque Constant Kt = 60 / (2*PI()*Kv) (N·m/A), Electromagnetic Torque (N·m), Resistive Voltage-Drop Loaded Speed (RPM), and Mechanical Shaft Power (kW).

Read the guide →
Oncology Pharmacology & Biostatistics

Bliss Independence & Loewe Combination Index Formula

Calculate Chester Bliss’s Probabilistic Additive Inhibition E_Bliss = E_A + E_B - E_A * E_B, Excess Over Bliss (EOB), and Loewe / Chou-Talalay Isobole Combination Index CI = d_A / Dx,A + d_B / Dx,B.

Read the guide →
Engineering & Science

Bloch-Grüneisen Metal Resistivity: T^5 Cryogenic vs Linear High-T Law

Explore low- and high-temperature approximations to the Bloch–Grüneisen model and use the full integral in the crossover region.

Read the guide →
Computer Science, Databases & Storage Engines

Bloom Filter False-Positive & Optimal Hash Formula

Size LSM-tree and cache Bloom filters via optimal hash count k* = ROUND((m/n)*LN(2), 0), false-positive rate (1 - EXP(-k*n/m))^k, and required bits per key -LN(p)/(LN(2)^2).

Read the guide →
Plastics Packaging, HDPE Blow Molding & Viscoelastic Die Swell

Blow Molding Parison Swell, Blow-Up Ratio & Wall Formula

Calculate Swollen Parison Diameter D_p (mm), Swollen Parison Wall Thickness t_p (mm), True Parison Blow-Up Ratio (BUR), and Finished Bottle Wall Thickness t_wall (mm).

Read the guide →
Polymer Film & Flexible Packaging, Tubular Blown-Film Extrusion BUR, Layflat & DDR

Blown-Film Extrusion BUR, Layflat & Draw-Down Formula

Calculate Transverse Blow-Up Ratio BUR = D_bubble/D_die, Collapsed Nip Layflat Width (mm), Machine-Direction Draw-Down Ratio DDR, and Forming Orientation Ratio DDR/BUR.

Read the guide →
Math & Trig

BMI calculation formula: metric (kg/cm), imperial (lb/in), and categories

Calculate Body Mass Index from kilograms and centimeters or pounds and inches, and assign adult screening bands with IFS.

Read the guide →
Healthcare & Clinical Calculations

BODE Index for COPD: Research Context and Point Arithmetic

Explore the four domains of the original BODE research index and practice a checked point sum with fictional inputs.

Read the guide →
Engineering & Fluid Mechanics

Bodenstein Number (Bo) & Levenspiel Closed-Vessel RTD Variance Formula

Quantify non-ideal tubular reactor and chromatography column backmixing via the Bodenstein number Bo = u*L / D_ax and Octave Levenspiel’s exact closed-vessel dimensionless residence-time variance sigma_theta² = 2/Bo - (2/Bo²)*(1 - EXP(-Bo)).

Read the guide →
Clinical Medicine & Physiology

Body Roundness Index (BRI): Waist, Height and an Ellipse Model

Explore Thomas and colleagues’ body-roundness formula using waist and height, and distinguish a geometric index from a clinical diagnosis.

Read the guide →
Clinical Medicine & Physiology

Body Surface Area and Percentage: An Example from Pediatric Burn Research

Explore an estimated surface area and a fictional fraction without calculating fluid volumes or treatment rates.

Read the guide →
Clinical Medicine & Physiology

Boer Lean-Body-Mass Estimates and Resting Energy Expenditure

Use Boer’s height-and-weight equations with the 370 + 21.6 × fat-free-mass resting-energy estimate, while distinguishing model predictions from measurements.

Read the guide →
Statistical & Clinical Analysis

Boey Research: Three Surgical Risk Factors and a Point Sum

Explore three factors in the Boey perforated-ulcer research and practice adding binary points.

Read the guide →
PFAS & VOC Drinking-Water Treatment, Bohart-Adams (1920) / Hutchins BDST Carbon Column

Bohart-Adams BDST Activated-Carbon Breakthrough Formula

Calculate Empty-Bed Contact Time EBCT (min), Critical Mass-Transfer Zone Bed Depth Z0 (m), Stoichiometric Saturation Time (h), and Bohart-Adams Breakthrough Service Time tb (h).

Read the guide →
Engineering & Science

Bohm Diffusion Coefficient Formula: Turbulent Cross-Field Plasma Transport

Calculate David Bohm’s anomalous cross-field plasma diffusivity D_B = T_e_eV / (16 * B) (m^2/s) and cylindrical Bessel radial confinement time τ_B = a^2 / (5.783 * D_B) in Hall thrusters and magnetrons.

Read the guide →
Science

Bohr Hydrogen Energy Levels & Rydberg Spectral Wavelength Formula

Use a consistent approximate hydrogen Rydberg model for vacuum emission wavelengths, photon energies and shell energies, with positive integer level validation.

Read the guide →
Industrial Energy Efficiency, Steam Distribution & Plant Utilities

Boiler Condensate Return Ratio & Fired-Fuel Savings Formula

Calculate Steam Plant Blended Feedwater Temperature (°C), Sensible Enthalpy Power Saved (kWth), Boiler-Efficiency-Adjusted Fired Fuel Saved (kW), and Cold Makeup Demand (kg/hr).

Read the guide →