Learn one useful thing today.
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 & ScienceKozai-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 & ScienceKozeny-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 BoilersKraft 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 TheoryKremer 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 →EngineeringKremser 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 & ScienceKretschmann 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 AnalysisKrippendorff’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 & EngineeringKronecker 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 RiskKrugman 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 GeographyKrugman 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 & ScienceKubelka-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 & PsychometricsKuder-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 →StatisticalKullback-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 MechanicsKutateladze 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 & KinematicsKutzbach-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 FinanceKyle 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 MechanicsKynch & 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 & ClinicalLACE 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 DesignLaffont-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 FinanceLaibson 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 →LogicalLAMBDA 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 ElementsLame 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 →EngineeringLame 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 PricingLancaster 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 & StrategyLanchester’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 →FinancialLanded 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 ControlLangelier 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 & ScienceLangevin 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 →EngineeringLangmuir & 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 & ScienceLangmuir 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 EngineeringLangmuir-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 EngineeringLapple 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 →StatisticalLARGE 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 statisticsLARGE, 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 MechanicsLarson-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 & CatchmentLaser 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 SurgeryLaw 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 CalculationsLawton–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 CompensationLazear 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 CompensationLazear-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 BuyoutsLBO 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 →MathLCM 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 AnalysisLe 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 & OperationsLean 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 AILearn 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 →FinancialLease 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 →LogicalLeave 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 & RiskLedoit-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 →