Learn one useful thing today.
RAID Capacity, Mixed-Workload IOPS and Annual Failure Probability
Compare RAID capacity and derive host IOPS from backend operation costs. Explore a one-year drive-failure probability under an explicit constant-hazard model.
Read the guide →Distributed Storage & Reliability EngineeringRAID-5 MTTDL & Erasure-Coding Overhead Formula
Calculate Patterson-Gibson-Katz RAID-5 Mean Time To Data Loss MTTDL = (MTBF^2) / (N*(N - 1)*MTTR) and compare Reed-Solomon (k + m) erasure-coding storage overhead against 3-way replication.
Read the guide →Industrial Logistics, Rail Freight Operations & Fleet Capacity SizingRailcar Fleet Sizing, Turnaround Cycle & Dwell Cost Formula
Calculate Industrial Railcar Round-Trip Turnaround Cycle Time (Days), Active Operating Cars Required via Little’s Law, Total Leased Fleet Including Bad-Order Maintenance Spares, and Annual Lease Cost Impact of Terminal Dwell.
Read the guide →Railway & Locomotive Traction Engineering, AREMA Train Resistance, Ruling Grade & PowerRailroad Train Resistance, Ruling Grade & Drawbar Power
Calculate Specific Rolling + Aerodynamic Resistance (N/t), Ruling Grade + Curve Resistance (N/t), Total Coupler Drawbar Tractive Effort (kN), and Rail Drawbar Power (kW).
Read the guide →Railway Civil Engineering, High-Speed Track Alignment & EN 13803Railway Equilibrium Cant, Cant Deficiency & Curve Speed Formula
Calculate Standard-Gauge Railway Equilibrium Cant (11.8 * V_kmh^2) / R_m, Uncompensated Cant Deficiency I (mm), Passenger Lateral Acceleration (I / 1500)*9.81, and Maximum Permitted Curve Speed.
Read the guide →Financial ModelingRalph Vince Optimal f Position Sizing: Terminal Wealth Relative & Geometric HPR
Convert empirical trade P&Ls with unequal win/loss magnitudes into Holding Period Returns HPR_i = 1 + f * (-Trade_i / Worst_Loss), Terminal Wealth Relative (TWR), and Geometric Mean HPR G(f).
Read the guide →Engineering & ScienceRaman Shift Wavenumber (cm^-1) & Anti-Stokes / Stokes Boltzmann Ratio Formula
Convert laser excitation and scattered wavelengths (nm) into Raman vibrational shift Delta_nu = (10^7 / lambda_0) - (10^7 / lambda_s) in cm^-1 and compute the vibrational Boltzmann population ratio EXP((-1.4387769 * |Delta_nu|) / T).
Read the guide →Aerospace Structural Mechanics & PlasticityRamberg-Osgood Elastic-Plastic Strain & Secant Formula
Calculate Metallic Elastic Strain sigma / E, MMPDS 0.2%-Offset Ramberg-Osgood Plastic Strain 0.002 * (sigma / sigma_02)^n, Total Nonlinear Strain, and Effective Secant Modulus E_sec.
Read the guide →Financial & AccountingRamsey Rule & Keynes-Ramsey Euler Equation: Social Discount Rate & Consumption Growth
Calculate the social discount rate r = rho + eta * g for climate/infrastructure cost-benefit analysis and optimal per-capita consumption growth g_c = (r - rho) / eta using Frank P. Ramsey’s 1928 intertemporal optimization rule.
Read the guide →Climate Economics & Benefit-Cost PolicyRamsey Social Cost of Carbon (SCC) Discounting Formula
Calculate the closed-form Social Cost of Carbon SCC = D_0 / (rho + (eta - 1)*g + phi) and quantify why Nordhaus (rho = 1.5%) vs Stern (rho = 0.1%) discounting shifts carbon prices 2.5x!
Read the guide →Regulatory Economics & Infrastructure PricingRamsey-Boiteux Regulated Utility Inverse-Elasticity Pricing Formula
Set welfare-maximizing break-even tariffs P_i = MC_i / (1 - R_ramsey / |e_i|) across multi-segment rail, power, or water utilities using the Ramsey-Boiteux rule.
Read the guide →MathRANDBETWEEN and RAND: generate bounded integer and decimal test samples
Create synthetic QA datasets with inclusive integer RANDBETWEEN(bottom, top) and continuous [0, 1) RAND() scaling.
Read the guide →Engineering & ScienceRandles-Sevcik Equation: Cyclic Voltammetry Peak Current (ip) & Reversible Peak Split
Calculate Nernstian cyclic voltammetry peak current ip = 2.686e5 * n^1.5 * A * SQRT(D) * C0 * SQRT(v) at 25 °C in microamps and reversible peak-to-peak separation Delta_Ep = 59.2 / n mV.
Read the guide →Lookup & ReferenceRandomly Assign Rows to Equal-Sized Balanced Groups (RANK + MOD + INDEX)
Eliminate lopsided RANDBETWEEN group sizes by ranking pre-drawn random decimals with RANK(B2, $B$2:$B$7) and cycling evenly through group labels via INDEX($E$2:$E$4, MOD(Rank - 1, K) + 1).
Read the guide →Logical & Lookup FormulasRange Dimensions & Relative Row/Column Position (ROW, COLUMN, ROWS, COLUMNS)
Compute dynamic 1-based relative column/row offsets COLUMN(D4) - COLUMN($B$4) + 1 for VLOOKUP col_index_num and audit total matrix capacity ROWS(rng) * COLUMNS(rng) immune to inserted rows or columns.
Read the guide →Lookup & ReferenceRank & Score Leaderboard with Deterministic Tie-Breaking (RANK + INDEX/MATCH)
Build a live 1-through-N ranked leaderboard that resolves tied scores deterministically via RANK + COUNTIF running offsets so INDEX and MATCH never repeat the same contender.
Read the guide →StatisticalRANK IF formula: rank values conditionally within groups or months (COUNTIFS)
Build a native RANKIF equivalent using COUNTIFS($A$2:$A$7, A2, $B$2:$B$7, ">" & B2) + 1 to rank reps within regions, products within categories, or sales within months.
Read the guide →StatisticalRANK IF formula: rank values within groups or categories using COUNTIFS
Build a conditional RANKIFS formula with COUNTIFS to rank employees inside their own department and optionally break ties.
Read the guide →StatisticalRank race results and sum stopwatch lap splits (hundredths of a second)
Total lap splits to 0.01-second precision, rank finish times ascending with RANK(..., 1) so fastest wins 1st place, and compute gap behind leader.
Read the guide →StatisticalRank Without Ties formula: Unique Sequential Ranks (RANK.EQ + COUNTIF)
Assign unique sequential positions to five numeric scores, resolving equal scores by their source-row order.
Read the guide →Healthcare & Clinical CalculationsRanson Criteria for Acute Pancreatitis Severity & Mortality (0–11)
Calculate John Ranson’s classic 5 Admission Criteria (Age > 55, WBC > 16k, Glucose > 200, LDH > 350, AST > 250) plus 6 48-Hour Criteria (0–11 total) to stratify mild (< 3) vs. severe necrotizing acute pancreatitis.
Read the guide →Engineering & ScienceRanz-Marshall Evaporating Droplet Nusselt & Sherwood Correlation
Calculate spray-drying and fuel-droplet heat and mass transfer via Ranz & Marshall’s 1952 correlation Nu = 2 + 0.6 * Re_d^0.5 * Pr^(1/3) and Sh = 2 + 0.6 * Re_d^0.5 * Sc^(1/3).
Read the guide →Statistical & Clinical AnalysisRao Quadratic Entropy Q Formula: Functional & Phylogenetic Trait Diversity Index
Incorporate pairwise species trait or genetic dissimilarity d_ij into biodiversity measurement using C. R. Rao’s (1982) Quadratic Entropy Q = SUM_i SUM_j d_ij * p_i * p_j and Jost’s Effective Functional Species 1 / (1 - Q).
Read the guide →Credit Risk & Corporate BankingRAROC Risk-Adjusted Return on Capital Formula
Price commercial credit facilities via Risk-Adjusted Return on Capital RAROC = (Net_Interest_And_Fees - OpEx - EAD*PD*LGD + r_f*EC) / EC by separating Expected Loss (pricing reserve) from Unexpected Loss (Economic Capital).
Read the guide →Statistical & Clinical AnalysisRasch Model (1PL IRT) Formula: Correct-Response Probability & Fisher Item Information
Evaluate Computerized Adaptive Testing (CAT — NCLEX, GMAT, GRE) item response probability P = 1 / (1 + EXP(-(theta - b))) and Fisher Item Information I(theta) = P * (1 - P) using Georg Rasch’s 1960 1-Parameter Logistic model.
Read the guide →Healthcare & ClinicalRASS Sedation Depth & CAM-ICU Delirium Screening Logic Formula
Pair the Richmond Agitation-Sedation Scale (RASS -5 to +4) arousal gate (RASS >= -3) with Wes Ely’s validated 4-feature Confusion Assessment Method for the ICU (CAM-ICU: Feature 1 AND Feature 2 AND [Feature 3 OR Feature 4]).
Read the guide →EngineeringRational Method Peak Stormwater Runoff (Q = C*i*A) & Composite C
Calculate an area-weighted runoff coefficient and Rational Method peak flow. Compare the customary Q≈CiA shortcut with the explicit acre-inch/hour conversion and validate the worksheet inputs.
Read the guide →ScienceRayleigh Diffraction Limit Angular Resolution & Airy Disk Diameter
Calculate circular-aperture Rayleigh angular resolution theta = 1.22 * lambda / D (in radians and arcseconds) and focal-plane Airy disk spot diameter d_Airy = 2.44 * lambda * N (in micrometers).
Read the guide →Fiber-Optic Telecom, Photonics & Link Power BudgetingRayleigh Fiber Scattering Loss & Optical Link Budget Formula
Calculate Silica Fiber Intrinsic Rayleigh Scattering Attenuation alpha_R = A / lambda_um^4 (dB/km), Total Unamplified Span Loss (alpha_R*L_km + Connector_Splice_dB), Unallocated Optical Power Margin, and Link Feasibility.
Read the guide →Engineering & ScienceRayleigh Flow Thermal Choking: P/P*, T/T* & Stagnation Temperature Ratio (T0/T0*)
Calculate static pressure ratio P/P*, static temperature ratio T/T*, and stagnation temperature ratio T0/T0* for compressible frictionless duct flow with heat addition (jet afterburners and ramjet combustors).
Read the guide →EngineeringRC Time Constant (tau), capacitor charging voltage & -3 dB cutoff frequency
Calculate tau = R * C, exponential charging curve Vc(t) = Vs * (1 - EXP(-t / tau)), and passive RC filter corner frequency fc = 1 / (2*PI*R*C).
Read the guide →Commercial Real Estate & Private EquityReal Estate JV Pari-Passu & Sponsor Promote Formula
Calculate LP and GP Sponsor Joint-Venture Equity Payouts and Effective MoICs under Pari-Passu Return of Capital & Preferred Hurdle followed by a Disproportionate Sponsor Promote Split.
Read the guide →Commercial Real Estate & Structured FinanceReal Estate Mezzanine Debt & Blended Cost Formula
Calculate Combined Senior-plus-Mezzanine Loan-to-Value (CLTV), Blended Debt Coupon Rate, Combined Interest-Only DSCR, and Levered Cash-on-Cash Equity Yield.
Read the guide →FinancialReal estate underwriting formulas: NOI, Cap Rate, and DSCR
Underwrite rental and commercial properties by calculating Net Operating Income (NOI), Capitalization Rate, Annual Debt Service, and lender DSCR covenants.
Read the guide →Lookup & ReferenceRearrange and select table columns dynamically by header name (CHOOSECOLS + XMATCH)
Reshape messy CSV exports into your exact target column order—while dropping unwanted columns—by matching header names with XMATCH inside CHOOSECOLS.
Read the guide →Econometrics & Distributional AnalysisRecentered Influence Function (RIF) Unconditional Quantile Formula
Transform outcomes into Firpo-Fortin-Lemieux Recentered Influence Functions RIF(y; q_tau) = q_tau + (tau - I(y <= q_tau)) / f_Y(q_tau) to estimate unconditional quantile treatment effects via OLS.
Read the guide →EngineeringRectangular & V-Notch Weir Flow Rate Discharge formulas (H^1.5 & H^2.5)
Explore the H^(3/2) and H^(5/2) dependence of idealized sharp-crested weir discharge with separate assumed coefficients, SI units and explicit input checks.
Read the guide →RF & Radar Microwave Engineering, WR-90 Rectangular Waveguides & TE10 DispersionRectangular Waveguide TE10 Cutoff & Wavelength Formula
Calculate Dominant TE10 Cutoff Frequency fc (GHz), Free-Space Wavelength lambda0 (mm), Stretched Guide Wavelength lambda_g (mm), and TE10 Wave Impedance Z_TE (ohms).
Read the guide →Power Generation Thermodynamics, Microturbines & Recuperated Brayton CyclesRecuperated Brayton Gas Turbine Effectiveness & Efficiency
Calculate Recuperated Gas Turbine / Microturbine Preheated Combustor-Inlet Temperature Tx (K), Combustor Fuel Heat Input Saved %, Simple Unrecuperated Brayton Efficiency, and Recuperated Thermal Efficiency.
Read the guide →Engineering & ScienceReddy-Doraiswamy Liquid Diffusivity Correlation (Two-Regime V_B / V_A)
Estimate liquid molecular diffusivity D_AB = K * SQRT(M_B) * T / (μ_B * (V_A * V_B)^(1/3)) (× 10^-5 cm^2/s) with automatic K = 0.010 vs. 0.0085 volume-ratio switching!
Read the guide →Engineering & ScienceRedlich-Kwong Real-Gas Equation of State (Pressure & Deviation From Ideal)
Calculate real-gas cylinder & pipeline pressure P = (R*T)/(V_m - b) - a/(SQRT(T)*V_m*(V_m + b)) in MPa using Otto Redlich and Joseph Kwong’s temperature-dependent attractive term.
Read the guide →Regional Economics & Public Policy AnalyticsRegional Shift-Share Growth Decomposition Formula
Decompose local employment change Delta_E_i = NS_i + IM_i + RS_i into National Growth Effect, Industry Mix Effect, and Regional Competitive Shift with zero residual.
Read the guide →Retail Site Selection & Spatial EconomicsReilly Retail Breaking-Point & Huff Gravity Formula
Delimit city trade-area boundaries via Converse-Reilly Breaking Point D_B = D_AB / (1 + SQRT(Pop_A / Pop_B)) and compute Huff (1964) probabilistic store patronage shares.
Read the guide →Dates & TimeReject Invalid Dates & Impossible Leap Days (Round-Trip DATE Year/Month/Day Audit)
Catch impossible imported date strings like "2026-02-29" or "2026-13-05" that DATE(y, m, d) would otherwise roll silently into the next month.
Read the guide →Clinical Medicine & PhysiologyRelative Fat Mass (RFM) Calculator: Woolcott & Bergman Height-to-Waist DXA Formula
Estimate whole-body fat percentage without a weight scale using Orison O. Woolcott and Richard N. Bergman’s (2018) NHANES DXA-validated Relative Fat Mass equation RFM = 64 - 20 * (Height / Waist) + 12 * Sex_Female(0/1).
Read the guide →International Finance & FX ValuationRelative PPP & Real Exchange Rate Misalignment Formula
Calculate Gustav Cassel’s Relative Purchasing Power Parity benchmark rate S_PPP = S_0 * (P_dom,t / P_dom,0) / (P_for,t / P_for,0), Real Exchange Rate index q_t, and bilateral FX misalignment.
Read the guide →StatisticalRelative Risk (RR), Odds Ratio (OR), ARR & Number Needed to Treat (NNT)
Compare fictional adverse-event counts over the same follow-up period using risk ratio, odds ratio, absolute risk reduction and a benefit-only NNT estimate.
Read the guide →Lookup & ReferenceRelative Row & Column Numbers, First & Last Row in Range (ROW / ROWS)
Convert absolute worksheet coordinates into 1-based relative table positions ROW(B5) - ROW($B$3) + 1 and calculate first/last row and column boundaries of any range.
Read the guide →Date & TimeRemaining Working Days Left in Current Month and Calendar Year (NETWORKDAYS & EOMONTH)
Calculate how many business days remain in the active month or calendar year—either including or excluding today—while deducting company holidays with NETWORKDAYS and EOMONTH.
Read the guide →Dynamic ArraysRemove blank rows from a range dynamically with FILTER (all-blank vs key-blank)
Compact messy CSV exports by stripping completely empty spacer rows while keeping partially filled records intact.
Read the guide →