Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Engineering & Fluid Mechanics

Koutecký-Levich Equation Formula: Electrocatalyst Kinetic vs. Diffusion RDE Current

Deconvolve intrinsic electrocatalyst kinetic current density j_k from convective mass-transport limiting current j_L on a rotating disk electrode (RDE) via 1/j = 1/j_k + 1/j_L.

Read the guide →
Engineering & Science

Kozai-Lidov Mechanism Formula: Maximum Eccentricity & Critical Inclination

Calculate secular Kozai-Lidov conserved vertical angular momentum L_z and peak quadrupole eccentricity e_max = SQRT(1 - (5/3)*cos^2(i_0)) in hierarchical triple systems.

Read the guide →
Engineering & Science

Kozeny-Carman Porous Media Permeability Formula (Darcies & m^2)

Calculate intrinsic porous-bed permeability k = ((phi^3) * (dp^2)) / (180 * ((1 - phi)^2)) in Darcies and square micrometers from porosity phi and effective grain diameter dp_mm.

Read the guide →
Pulp & Paper Chemical Engineering, Kraft Digesters & Recovery Boilers

Kraft White Liquor Active/Effective Alkali & Sulfidity Formula

Calculate North American Na2O-Basis Active Alkali AA (g/L), Effective Alkali EA (g/L), White-Liquor Sulfidity (%), and Digester Effective Alkali Charge (% on Oven-Dry Wood).

Read the guide →
Development Economics & Personnel Theory

Kremer O-Ring Production & Assortative Wage Formula

Calculate Michael Kremer’s (1993) multiplicative O-Ring output, supermodular positive assortative matching surplus Y_max*(q_H - q_L)^2, and convex n-task equilibrium wage ratio (q_H / q_L)^n.

Read the guide →
Engineering

Kremser Gas Absorption Factor (A) & Theoretical Scrubber Stages

Calculate the absorption factor and ideal equilibrium-stage estimate for a dilute countercurrent absorber, with input validation, a pinch check and stable evaluation near A = 1.

Read the guide →
Engineering & Science

Kretschmann Surface Plasmon Resonance (SPR) Biosensor Angle Formula

Calculate the prism-coupled Surface Plasmon Resonance dip angle θ_SPR = DEGREES(ASIN((1 / n_p) * SQRT((|ε_m| * n_d^2) / (|ε_m| - n_d^2)))) for label-free antibody-antigen optical biosensors.

Read the guide →
Statistical & Clinical Analysis

Krippendorff’s Alpha (α) Formula: Coincidence Matrix & Finite-Sample Reliability

Calculate Klaus Krippendorff’s content-analysis reliability coefficient α = 1 - D_o / D_e = 1 - (n - 1)*n_01 / (n_0*n_1) from a symmetric 2×2 coincidence matrix.

Read the guide →
Statistical & Engineering

Kronecker Delta Numeric Equality Indicator Formula (Exact & Tolerance-Safe)

Implement the Kronecker Delta indicator (returning 1 when x = y and 0 otherwise, with strict ISNUMBER type safety and optional floating-point tolerance) plus vector exact-match counting.

Read the guide →
International Macroeconomics & Sovereign Risk

Krugman Currency Crisis & Shadow Exchange Rate Formula

Calculate Paul Krugman’s (1979) and Flood-Garber’s (1984) shadow floating exchange rate s_tilde(0), speculative attack timing T* = (R_0 - R_min) / mu - alpha, and discrete reserve wipeout alpha * mu.

Read the guide →
International Trade & Economic Geography

Krugman Love-of-Variety Gain & Home-Market Effect Formula

Compute Dixit-Stiglitz-Krugman autarky varieties L / (sigma * F), frictionless trade welfare gain ((L_H + L_F)/L_H)^(1/(sigma - 1)), and iceberg Home-Market Effect firm share.

Read the guide →
Engineering & Science

Kubelka-Munk Diffuse Reflectance Function F(R) = K/S & Inverse Reflectance

Linearize diffuse reflectance R_inf of opaque paints, textiles, papers, and catalyst powders into absorption-to-scattering ratio F(R_inf) = (1 - R_inf)^2 / (2 * R_inf) = K / S and invert K/S back to R_inf.

Read the guide →
Statistical & Psychometrics

Kuder-Richardson Formula 20 (KR-20) Dichotomous Test Reliability

Calculate internal-consistency reliability KR-20 = (K / (K - 1)) * (1 - SUM(p_i * q_i) / σ_X^2) for binary right/wrong certification exams and diagnostic checklists.

Read the guide →
Statistical

Kullback-Leibler (KL) Divergence & Population Stability Index (PSI) drift formulas

Measure probability distribution shift D_KL(P || Q) = SUM(P * LN(P / Q)) and symmetric credit-model Population Stability Index (PSI) in spreadsheets.

Read the guide →
Engineering & Fluid Mechanics

Kutateladze Number (Ku) Formula: Countercurrent Gas-Liquid Flooding & Droplet Entrainment

Predict diameter-independent countercurrent gas-liquid flooding and droplet carry-over in large-diameter pipes, nuclear downcomers, and packed columns using Samson S. Kutateladze’s dimensionless gas flux number Ku_g = j_g * SQRT(rho_g) / (g * sigma * (rho_l - rho_g))^0.25.

Read the guide →
Mechanical Design & Kinematics

Kutzbach-Gruebler Planar Mechanism Mobility (DOF) Formula

Calculate planar linkage degrees of freedom M = 3*(L - 1) - 2*J_1 - J_2 + r_red in Excel and Arte Sheets to distinguish 1-DOF mechanisms, trusses, hyperstatic frames, and parallel-crank paradoxes.

Read the guide →
Quantitative Finance

Kyle Lambda Order-Flow Price Impact & Reciprocal Market Depth Formula (SLOPE)

Estimate Kyle’s (1985) price-impact coefficient lambda = SLOPE(Price_Change, Signed_Order_Flow) and implied book depth 1 / lambda from signed trade-imbalance intervals.

Read the guide →
Engineering & Fluid Mechanics

Kynch & Talmage-Fitch Thickener Sizing Formula: Unit Area (UA) & Clarifier Diameter

Scale 1-liter graduated-cylinder hindered settling tests up to continuous industrial gravity thickeners using G. J. Kynch & Talmage-Fitch Unit Area UA = t_u / (C_0 * H_0) and tank diameter D = SQRT(4 * F * UA / pi).

Read the guide →
Healthcare & Clinical

LACE Readmission Research: Spreadsheet Scoring Example

Learn how the LACE research index groups four hospital discharge variables, and practice its point arithmetic with hypothetical data.

Read the guide →
Public Procurement & Mechanism Design

Laffont-Tirole Procurement Incentive Power Formula

Calculate Jean-Jacques Laffont & Jean Tirole’s (1986) optimal cost-sharing contract slope b* = 1 - (lambda_f/(1 + lambda_f))*gamma_e*(beta - beta_L) between Fixed-Price and Cost-Plus.

Read the guide →
Behavioral Economics & Household Finance

Laibson Quasi-Hyperbolic (beta, delta) Discount Formula

Model time-inconsistent preference reversals using Phelps-Pollak and David Laibson’s (1997) quasi-hyperbolic discount sequence {1, beta*delta, beta*delta^2, ...}.

Read the guide →
Logical

LAMBDA function: package reusable custom formulas without macros

Define parameterized worksheet formulas with LAMBDA and call them by name across a workbook.

Read the guide →
Mechanical Design & Machine Elements

Lame Shrink-Fit Contact Pressure and Slip-Free Torque Formula

Calculate interference press/shrink-fit interface pressure p_if = (E * delta_r / (2 * R_if)) * (1 - (R_if / R_out)^2) and slip-free torque capacity T_max in Excel and Arte Sheets.

Read the guide →
Engineering

Lame Thick-Walled Cylinder Hoop & Radial Stress (Pressure Vessels)

Calculate inner-bore peak tensile hoop stress sigma_theta = P_i * (r_o^2 + r_i^2) / (r_o^2 - r_i^2) and outer-surface hoop stress in hydraulic cylinders, gun barrels, and autoclaves where t / r_i > 0.10.

Read the guide →
Microeconomic Consumer Theory & Hedonic Pricing

Lancaster Characteristics Shadow Price & Frontier Formula

Solve Kelvin Lancaster’s (1966) 2x2 Hedonic Attribute Shadow Prices (pi_1, pi_2) from two frontier goods and test whether a third competing SKU expands or falls inside the Characteristics Efficiency Frontier.

Read the guide →
Operations Research & Strategy

Lanchester’s Square & Linear Laws Formula: Concentration Advantage & Remaining Force

Model competitive market-share and operations-research engagements using Frederick Lanchester’s Square Law (alpha * A_0^2 vs beta * B_0^2), parity threshold, and surviving resource capacity.

Read the guide →
Financial

Landed Cost per unit formula: allocate ocean freight & customs tariffs across SKUs

Estimate per-unit cost using supplied duty rates and a weight-based allocation of shared freight.

Read the guide →
Water Chemistry, Cooling-Water Scaling & Corrosion Control

Langelier Saturation (LSI) & Ryznar Stability (RSI) Formula

Calculate AWWA / ASTM D3739 Calcium Carbonate Saturation pHs, Langelier Saturation Index LSI (pH - pHs), Ryznar Stability Index RSI (2*pHs - pH), and Scale vs Corrosion Regime.

Read the guide →
Engineering & Science

Langevin Function L(x) = coth(x) - 1/x for Superparamagnetic Nanoparticles

Evaluate Paul Langevin’s magnetization curve M / M_sat = coth(x) - 1/x as a function of magnetic-to-thermal energy ratio x = (mu * B) / (k_B * T) for MRI iron-oxide ferrofluids and dielectric dipole alignment.

Read the guide →
Engineering

Langmuir & Freundlich Adsorption Isotherm Capacity formulas

Compare equilibrium Langmuir and Freundlich uptake for a hypothetical solute/adsorbent system with explicit concentration and loading units.

Read the guide →
Engineering & Science

Langmuir Probe Plasma Diagnostics: Bohm Speed & Ion Saturation Current Formula

Calculate the Bohm acoustic ion sheath entry speed u_B = SQRT(e * T_e_eV / m_i) in m/s and Langmuir probe ion saturation current I_sat = 0.61 * e * n_e * A_p * u_B in mA for RF etch and thruster plasmas.

Read the guide →
Chemical, Process & Catalysis Engineering

Langmuir-Hinshelwood Bimolecular Surface Kinetics Formula & Self-Inhibition Peak

Calculate competitive bimolecular Langmuir-Hinshelwood catalytic reaction rate r = k_s * K_A * P_A * K_B * P_B / (1 + K_A * P_A + K_B * P_B)^2 and optimal reactant partial pressure P_A,opt = (1 + K_B * P_B) / K_A.

Read the guide →
Air Pollution Control, Particulate Separation & Chemical Engineering

Lapple Cyclone Cut-Diameter (d50) & Grade Efficiency Formula

Calculate Lapple Reverse-Flow Cyclone 50% Cut-Size Diameter d_p50 (µm), Fractional Grade Collection Efficiency (%), Dust Penetration (%), and 8-Velocity-Head Pressure Drop (Pa).

Read the guide →
Statistical

LARGE and SMALL with criteria: Nth highest or lowest value by group

Combine LARGE or SMALL with FILTER to retrieve the 2nd largest deal or 2nd fastest time inside a category—beyond MAXIFS and MINIFS.

Read the guide →
Descriptive statistics

LARGE, SMALL, and RANK.EQ: extract Nth values and handle ties

Pull the 1st, 2nd, or 3rd highest and lowest numbers without sorting the table, see how tied scores repeat in LARGE and skip ranks in RANK.EQ, and catch #NUM! bounds.

Read the guide →
High-Temperature Metallurgy, Gas Turbine Superalloys & Creep Mechanics

Larson-Miller Creep-Rupture Life & Monkman-Grant Formula

Calculate Superalloy Log10 Creep-Rupture Hours from the Larson-Miller Parameter LMP = (T_K / 1000)*(C_LM + LOG10(t_r)), Predicted Rupture Life t_r (hours), Monkman-Grant Steady-State Creep Rate, and Overhaul Life Margin.

Read the guide →
Additive Repair & Surface Hardfacing, Coaxial Laser Cladding / DED Dilution & Catchment

Laser Cladding Dilution Ratio & Powder Catchment Formula

Calculate Metallographic Clad Dilution Ratio (%), Deposited Alloy Mass Rate (g/min), Coaxial Powder Catchment Efficiency (%), and Specific Laser Energy (J/mm²).

Read the guide →
CNC Turning, Carbide Insert Nose Geometry & Surface Metrology (ISO 4287)

Lathe Turning Surface Roughness Ra & Rz Nose-Radius Formula

Calculate Schmaltz Kinematic Peak-to-Valley Roughness R_z (um), Exact Parabolic Arithmetic Average Roughness R_a (um), Finish Cut Cycle Time (s), and ISO N-Grade Finish Check.

Read the guide →
Cardiovascular Biomechanics, Cardiology & Vascular Surgery

Law of Laplace Cardiac & Aneurysm Wall Stress Formula

Calculate Spherical Left-Ventricular Myocardial Afterload Wall Stress (P*r)/(2*h), Cylindrical Aortic Aneurysm Circumferential Hoop Stress (P*r)/h in mmHg and kPa, and Geometric Stress Amplifier r/(2*h).

Read the guide →
Healthcare & Clinical Calculations

Lawton–Brody IADL: Functional Assessment and a Counting Example

Learn the purpose and limitations of the Lawton–Brody IADL scale and practice a separate eight-value spreadsheet count.

Read the guide →
Personnel Economics & Executive Compensation

Lazear Deferred Seniority Wage & Performance Bond Formula

Calculate Edward Lazear’s (1979) incentive-compatible senior wage w_2* = w_alt + s_shirk, junior underpayment performance bond VMP_1 - w_1*, and mandatory buyout/retirement surplus gap.

Read the guide →
Personnel Economics & Executive Compensation

Lazear-Rosen Tournament Prize Spread & Effort Formula

Design rank-order promotion tournaments via Edward Lazear and Sherwin Rosen’s (1981) optimal prize spread W_1 - W_2 = p / g(0), equilibrium effort, and participation-constrained pay levels.

Read the guide →
Private Equity & Leveraged Buyouts

LBO Value-Creation Bridge, MoIC & Gross IRR Formula

Calculate Private Equity LBO Sponsor Entry/Exit Equity, Multiple on Invested Capital (MoIC), Gross IRR = MoIC^(1/T) - 1, and exact EBITDA-Growth / Multiple-Expansion / Debt-Paydown value attribution.

Read the guide →
Math

LCM function: find shared maintenance intervals and common denominators

Calculate the smallest positive cycle where two or more repeating schedules align simultaneously using LCM.

Read the guide →
Process Safety Management, Combustion Engineering & Hazard Analysis

Le Chatelier Mixing Rule: An Illustrative Gas Limit Calculation

Use the approximate Le Chatelier mixing rule for a three-gas teaching example, with its assumptions and limitations clearly stated.

Read the guide →
Business & Operations

Lean Heijunka Pitch & Every Part Every Interval (EPEI) Level-Scheduling Formula

Calculate Toyota Production System Heijunka box Pitch = (Takt_Time * Pack_Qty) in minutes and mixed-model Every Part Every Interval EPEI = Total_Changeover_Min / (Available_Min - Daily_Run_Min) in days.

Read the guide →
Learn with AI

Learn a formula with AI hints, then test it yourself

Practise order totals by finding a missing row, predicting the result and checking a changed input. Ask AI for a hint before asking it to solve the task.

Read the guide →
Financial

Lease vs. Buy NPV calculator: Net Advantage to Leasing (NAL) after taxes

Explore a simplified annual lease-versus-purchase cash-flow model with assumed usable tax relief, zero residual value and end-of-year payments.

Read the guide →
Logical

Leave Inline Comments in Formulas (+ N("Note") & Self-Documenting LET)

Document complex audit logic directly inside spreadsheet formulas using the classic + N("Inline comment") zero-addition trick or modern LET(doc_note, "...", ...) named variables.

Read the guide →
Portfolio Construction & Risk

Ledoit-Wolf Constant-Correlation Shrinkage Covariance Formula

Stabilize noisy sample covariance matrices in Excel and Arte Sheets using Ledoit-Wolf convex shrinkage Sigma_LW = (1 - delta)*S + delta*F toward a constant-correlation prior.

Read the guide →