Learn one useful thing today.
Join Date and Text Without Raw Serial Numbers (TEXT "yyyy-mm-dd" Formula)
Embed formatted ISO dates and rounded invoice amounts cleanly inside dynamic text sentences using TEXT(date_cell, "yyyy-mm-dd") so concatenation never prints raw serial numbers like "Due on 46157".
Read the guide →TextJoin dates with text in report headers (and auto-updating copyright years)
Prevent raw date serial numbers like 46143 when concatenating report titles by wrapping dates in TEXT(..., "yyyy-mm-dd") and YEAR.
Read the guide →Lookup & ReferenceJoin Two Tables with INDEX & MATCH (Relational SKU Enrichment & Team Review)
Perform SQL-style left joins between an order transaction log and a SKU master catalog—pulling Category and Unit Price regardless of column order while flagging unmapped SKUs.
Read the guide →Supply Chain & Inventory OptimizationJoint Replenishment Shared Major/Minor Setup Formula
Coordinate multi-SKU supplier shipments via the Joint Replenishment Problem (JRP) optimal cycle time T* = SQRT(2*(S_0 + SUM(s_i)) / SUM(D_i*H_i)) and quantify savings vs independent EOQ.
Read the guide →Nonparametric Statistics & Clinical TrialsJonckheere-Terpstra Ordered-Group Trend Statistic Formula
Test monotonic trend across independent ordered dose groups using the Jonckheere-Terpstra pairwise Mann-Whitney sum J = U_12 + U_13 + U_23 and exact null moments.
Read the guide →Macroeconomics & Innovation EconomicsJones Semi-Endogenous R&D Growth & Spillover Formula
Calculate steady-state idea growth g_A* = (lambda * n) / (1 - phi), transitional R&D surge, and permanent TFP level gain (s_R1 / s_R0)^(lambda / (1 - phi)).
Read the guide →Pore-Pressure Detection & Well Control, Jordan-Shirley (1966) d & Corrected dc ExponentJordan-Shirley Drilling d-Exponent & dc Overpressure
Calculate Bit Penetration per Revolution (ft/rev), Jordan-Shirley Raw d-Exponent, Rehm-McClendon Mud-Weight Corrected dc-Exponent, and Normal Compaction Trend Ratio (%).
Read the guide →Engineering & ScienceJosephson Junction AC Frequency (KJ) & Ambegaokar-Baratoff Critical Current (Ic)
Calculate the AC Josephson oscillation frequency f_J = 0.4835979 * V_uV in GHz using the 2019 SI Josephson constant KJ = 2e/h, plus T=0 Ambegaokar-Baratoff critical current Ic = ((PI()/2) * Delta_meV) / Rn.
Read the guide →EngineeringJoukowsky Water Hammer Pressure Surge & Piezometric Head Rise
Estimate the ideal initial pressure rise from a sudden velocity reduction, its equivalent fluid head and the pipe round-trip wave time. Compare an entered closure time without treating the result as a pipe-safety certification.
Read the guide →Cryogenic Air Separation & Gas Liquefaction, Joule-Thomson & Linde-Hampson (1895) CycleJoule-Thomson Cooling & Linde-Hampson Liquefaction Formula
Calculate Isenthalpic Joule-Thomson Temperature Drop (K), Warm-End Isothermal Enthalpy Deficit (kJ/kg), Linde-Hampson Liquid Yield Fraction (%), and Liquid Nitrogen Production (kg/h).
Read the guide →Operations, Logistics & EngineeringJovanović (1969) Monolayer & Multilayer Adsorption Isotherm Formula: Mechanical Contact Model
Calculate equilibrium adsorption with mechanical bulk-molecule collision knock-off corrections using Dušan S. Jovanović’s (1969) monolayer isotherm q_e = q_max * (1 - EXP(-K_J * C_e)) and multilayer extension.
Read the guide →Economics & Market MicrostructureKakwani Tax Progressivity & Reynolds-Smolensky Redistribution Index Formula
Decompose how much a tax system reduces income inequality using Nanak Kakwani’s Progressivity Index K = C_T - G_X and the Reynolds-Smolensky Net Redistribution identity RS = G_X - G_Y = (t / (1 - t)) * K - D_rerank.
Read the guide →Game Theory & Joint-Venture NegotiationKalai-Smorodinsky vs Nash Bargaining Split Formula
Allocate joint-venture surplus via Ehud Kalai and Meir Smorodinsky’s (1975) proportional ideal-point rule (u_1 - d_1)/(b_1 - d_1) = (u_2 - d_2)/(b_2 - d_2) when individual payoff caps bind.
Read the guide →StatisticalKanban Bin / Card Count & On-Time In-Full (OTIF) supply chain formulas
Calculate a simplified replenishment-container estimate and measure the share of five complete shipment records that are both on time and in full.
Read the guide →Engineering & Fluid MechanicsKandlikar Flow Boiling Correlation Formula: Convective Number Co & Two-Phase Heat Transfer
Calculate in-tube evaporator and cold-plate flow-boiling heat transfer using Satish G. Kandlikar’s 1990 Convection Number Co = ((1 - x)/x)^0.8 * (rho_g / rho_l)^0.5 and convective-dominant boiling branch h_TP = h_LO * (1.136 * Co^(-0.9) + 667.2 * Bo^0.7 * F_fl).
Read the guide →Financial ModelingKaplan-Knowles Kappa-3 Ratio & Third-Order Lower Partial Moment (LPM3)
Penalize severe left-tail crashes more strictly than Sortino’s quadratic LPM2 by dividing excess return over MAR by the cube root of third-order Lower Partial Moment LPM_3.
Read the guide →StatisticalKaplan-Meier Survival Estimator & Exponential Median Survival formulas
Calculate validated Kaplan–Meier steps with a small censored follow-up table, and distinguish them from a separate constant-hazard exponential median.
Read the guide →Engineering & ScienceKapustinskii & Born-Landé Ionic Crystal Lattice Energy Formula (kJ/mol)
Estimate ionic crystal lattice enthalpy U_L = ((-120,200 * nu * |z+ * z-|) / (r+ + r-)) * (1 - 34.5 / (r+ + r-)) in kJ/mol from Shannon/thermochemical ionic radii (pm) without needing crystal structure.
Read the guide →Healthcare & Clinical CalculationsKatz ADL: Add Six Assessed Independence Items
Sum six already-assessed Katz activities of daily living as numeric 0/1 inputs, while recognizing item-specific criteria and limits of the score.
Read the guide →Platform Economics & Network EffectsKatz-Shapiro Network Compatibility Equilibrium Formula
Solve Michael Katz and Carl Shapiro’s (1985) Fulfilled-Expectations Cournot Equilibrium under open standard compatibility q* = (A - c)/(N + 1 - N*v) versus proprietary incompatibility q* = (A - c)/(N + 1 - v).
Read the guide →Powder Metallurgy, Battery Cathode Calendering & Pharma Bulk Handling, Kawakita ModelKawakita Powder Volume Reduction & Cohesiveness Formula
Calculate Kawakita Engineering Volume Strain C (%), Compressed Bed Volume V (mL), Reciprocal Yield/Cohesion Pressure 1/b (MPa), and Asymptotic Packing Realization (%).
Read the guide →Climate Policy & Energy AnalyticsKaya Identity Emissions & Decarbonization Rate Formula
Compute total CO2 via Yoichi Kaya’s (1990) 4-factor identity Pop * (GDP/Pop) * (E/GDP) * (CO2/E) and solve the required carbon-intensity decline rate to meet net-zero pathways.
Read the guide →Engineering & ScienceKeldysh Parameter (γ_K): Multiphoton vs. Tunneling Ionization Formula
Calculate Leonid Keldysh’s strong-field adiabaticity parameter γ_K = 5.1232 * E_ph * SQRT(m_eff * I_p) / F to classify ultrafast laser excitation into multiphoton (γ_K > 1) or optical tunneling (γ_K < 1) regimes.
Read the guide →FinancialKelly Criterion position-sizing formula: Full Kelly, Half-Kelly & edge guard
Explore the mathematical Kelly fraction for a repeated binary payoff model and compare a fractional allocation.
Read the guide →Quantitative Finance & TradingKeltner Channel & Volatility Squeeze Formula: True Range, ATR Envelope & Squeeze Flag
Build Linda Raschke’s ATR-based Keltner Channel (EMA +- m * ATR), compute Wilder’s gap-aware True Range, and detect Bollinger-inside-Keltner Volatility Squeezes.
Read the guide →Engineering & ScienceKelvin Equation: Nanodroplet Vapor Pressure & Capillary Condensation RH
Calculate convex aerosol nanodroplet supersaturation ratio P / P_sat = EXP(+2 * γ * V_m / (r * R * T)) and concave silica-mesopore capillary condensation relative humidity RH_cond (%) = 100 * EXP(-2 * γ * V_m / (r * R * T)).
Read the guide →StatisticalKendall's Tau (tau-a & tau-b) & Somers' D Rank Concordance formulas
Measure ordinal rating and credit-scorecard rank agreement from Concordant (C), Discordant (D), and Tied pairs via Tau-a, tie-adjusted Tau-b, and Somers' D.
Read the guide →Engineering & Fluid MechanicsKern Shell-Side Nusselt & Square-Pitch Equivalent Diameter Formula
Perform preliminary shell-and-tube exchanger sizing using Donald Q. Kern’s square-pitch hydraulic diameter De = 4*(Pt² - pi*do²/4)/(pi*do) and turbulent shell correlation Nu_s = 0.36 * Re_s^0.55 * Pr^(1/3) * (mu/mu_w)^0.14.
Read the guide →Healthcare & ClinicalKhorana and Padua VTE Scores: An Educational Khorana Example
Explore the Khorana point arithmetic with fictional inputs and distinguish its research population from that of the Padua score.
Read the guide →Macroeconomics & Consumption TheoryKimball Prudence & Precautionary Saving Wedge Formula
Calculate Miles Kimball’s (1990) Coefficient of Relative Prudence P = gamma + 1, precautionary equivalent income haircut psi = 0.5*(gamma + 1)*sigma^2, and log-Euler consumption growth.
Read the guide →Wind-Tunnel Turbulence & Experimental Aerodynamics, L.V. King (1914) CTA AnemometryKing’s Law CTA Hot-Wire Anemometer Velocity Formula
Calculate Active Wire Overheat Difference (K), Bearman-Corrected Squared Bridge Voltage E²corr (V²), True Compensated Flow Velocity (m/s), and Uncorrected Raw Velocity (m/s).
Read the guide →StatisticalKingman's VUT Equation: G/G/1 queueing wait time from variability & utilization
Estimate real-world factory and service queue wait times Wq = ((Ca^2 + Cs^2)/2) * (u / (1 - u)) * ts when arrivals and processing times are NOT exponential.
Read the guide →Mechanical & Structural EngineeringKirchhoff-Love Circular Plate Flexural Rigidity and Diaphragm Deflection
Calculate thin-plate flexural rigidity D = E*h^3 / (12*(1 - nu^2)) and compare clamped vs simply supported circular diaphragm center deflection under uniform pressure.
Read the guide →Quantitative Finance & DerivativesKirk Spread Option Approximation for Nonzero-Strike Crack and Spark Spreads
Price two-asset commodity spread calls MAX(F1 - F2 - K, 0) in Excel and Arte Sheets using Kirk’s discounted-strike denominator weight and composite spread volatility.
Read the guide →Engineering & ScienceKirkbride Equation: Optimal Distillation Feed-Tray Location (NR / NS)
Locate the optimal feed stage in multicomponent Fenske-Underwood-Gilliland distillation design via C. G. Kirkbride’s rectifying-to-stripping stage ratio N_R / N_S = ((B / D) * (x_HK_F / x_LK_F) * (x_LK_B / x_HK_D)^2)^0.206.
Read the guide →EngineeringKirpich Watershed Time of Concentration (tc) & NRCS Basin Lag Time
Calculate stormwater watershed Time of Concentration t_c = 0.01947 * L^0.77 * S^(-0.385) (minutes, SI flow length L in meters and slope S in m/m) and NRCS Unit Hydrograph Lag Time t_lag = 0.60 * t_c.
Read the guide →Statistical AnalysisKish Design Effect (DEFF), Cluster ICC & Effective Sample Size Formula
Deflate nominal survey and cluster-randomized sample size N using Leslie Kish’s (1965) cluster DEFF_c = 1 + (m - 1)*rho and unequal-weighting DEFF_w = 1 + CV(w)^2.
Read the guide →Survey Statistics & Research DesignKish Unequal-Weight Effective Sample Size (n_eff) Formula
Calculate Kish’s unequal-weighting effective sample size n_eff = (SUM w)^2 / SUM(w^2), weighting design effect DEFF_w = 1 + CV_w^2, and efficiency n_eff / N in Excel and Arte Sheets.
Read the guide →Telecommunications & Queueing NetworksKleinrock Square-Root Channel Capacity Delay Formula
Calculate Leonard Kleinrock’s optimal M/M/1 packet-network link capacities C_i* = lambda_i/mu + (C_tot - F_sum)*(SQRT(lambda_i)/(SQRT(lambda_1)+SQRT(lambda_2))) and minimum average network delay.
Read the guide →Pricing Strategy & Industrial OrganizationKlemperer Switching-Cost Bargain-Then-Ripoff Formula
Calculate Paul Klemperer’s (1987, 1995) below-cost Period-1 customer acquisition price P_1* = c_1 + t - delta*s, Period-2 lock-in harvest price P_2* = c_2 + s, and lifecycle customer profit.
Read the guide →Public Economics & Causal InferenceKleven-Saez Kink Bunching Mass and Behavioral Elasticity Formula
Calculate normalized excess bunching mass b = B / h_0, marginal buncher shift Delta_z = b * w_bin, and exact log-retention elasticity e = (Delta_z / z_star) / LN((1 - m_1) / (1 - m_2)).
Read the guide →Petrophysics, Core Analysis & Tight-Gas Reservoir EngineeringKlinkenberg Gas-Slippage Core Permeability Formula
Calculate True Liquid-Equivalent Klinkenberg Permeability k_inf (mD), Low-Pressure Lab Overestimation (%), In-Situ High-Pressure Reservoir Gas Permeability (mD), and Slippage Multiplier.
Read the guide →Industrial Electric Drives & Rotating Machinery, Kloss Asynchronous Motor Torque-Slip LawKloss Induction Motor Torque-Slip & Breakdown Formula
Calculate Synchronous Rotating-Field Speed Ns (RPM), Rotor Slip s (%), Kloss Electromagnetic Shaft Torque T(s) (N·m), and Direct-On-Line (s = 1) Locked-Rotor Starting Torque (N·m).
Read the guide →Rarefied Gas Dynamics, High-Vacuum Plumbing & Molecular FlowKnudsen Molecular-Flow Tube Conductance & Aperture Formula
Calculate Gas Mean-Free-Path Knudsen Number Kn, Long-Tube Knudsen Conductance (L/s, scaling with D^3), Entrance Orifice Conductance (L/s), and Short-Tube Series Conductance (L/s).
Read the guide →Engineering & ScienceKohlrausch's Square-Root Law of Molar Conductivity & Weak-Acid Dissociation (alpha)
Calculate strong-electrolyte molar conductivity Lambda_m = Lambda_m^0 - K * SQRT(c) and weak-electrolyte degree of dissociation alpha = Lambda_m / Lambda_m^0 in electrochemistry.
Read the guide →Malting Grain Chemistry & Brewhouse Process ControlKolbach Index, Lintner Diastatic & Mash Efficiency Formula
Read a Malt Certificate of Analysis (COA) by calculating Kolbach Index % SNR = 100*(Soluble_N / Total_N), converting European Windisch-Kolbach (°WK) to Degrees Lintner (°L) = (WK + 16)/3.5, and auditing Brewhouse Mash Extract Efficiency.
Read the guide →Economics & Market MicrostructureKolm-Pollak Absolute Inequality Index K(kappa) & Translation-Invariant EDE Income
Measure absolute dollar income dispersion using Serge-Christophe Kolm’s (1976) Leftist Inequality Index K(kappa) = (1 / kappa) * LN((1 / N) * SUM(EXP(kappa * (mu - y_i)))) and Equally Distributed Equivalent income mu - K(kappa).
Read the guide →AI Accelerator Efficiency & Physics of ComputingKoomey Compute TOPS/W & Landauer Limit Formula
Calculate AI Accelerator Compute Efficiency (TOPS/W), Energy per Operation (pJ/op), Rolf Landauer’s Minimum Irreversible Bit-Erasure Energy k_B * T * LN(2) in zeptojoules, and Headroom Factor Above Landauer.
Read the guide →Operations, Logistics & EngineeringKoros-Nowak & Madon-Boudart Test Formula: Catalytic Turnover Frequency & Transport Disguise
Perform the definitive experimental test for heat- and mass-transfer artifacts in heterogeneous catalysis (Koros & Nowak, 1967; Madon & Boudart, 1982) by computing log-log slope d(LN R_vol) / d(LN Site_Density) across diluted active-metal loadings (Slope = 1.0 intrinsic vs. 0.5 pore-diffused vs. 0.0 film-limited).
Read the guide →Civil, Structural & Geotechnical EngineeringKostiakov-Lewis (Modified Kostiakov) Irrigation Infiltration Formula: Z(t) & Intake Rate
Design furrow, border, and basin surface irrigation opportunity times using A. N. Kostiakov (1932) and M. R. Lewis / Mezencev’s Modified Kostiakov-Lewis Cumulative Intake Z(t) = k * (t^a) + f_0 * t and Instantaneous Rate I(t).
Read the guide →