Learn one useful thing today.
Range 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: Admission and 48-Hour Point Arithmetic
Review the historical two-stage Ranson criteria and practice adding two already-counted groups of points.
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 and CAM-ICU: Delirium Screening Background
Understand the roles of arousal assessment and ICU delirium screening, and find the original training materials.
Read the guide →FinancialRATE function: solve for the implied interest rate of a loan or lease
Calculate periodic and annualized interest rates from known payment, term, and principal values using RATE.
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 →Experimental Stress Analysis & Structural Flight Testing, 0°-45°-90° Foil Rosette Mohr CircleRectangular 0-45-90 Strain Rosette & Von Mises Formula
Calculate Maximum & Minimum Principal Strains e1, e2 (microstrain), Biaxial Hooke Maximum Principal Stress sigma_1 (MPa), and Plane-Stress Equivalent Von Mises Stress (MPa).
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): A Height and Waist Estimate
Explore Woolcott and Bergman’s relative-fat-mass equation with study context, unit checks and clear limits on individual interpretation.
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 →TextRemove file extension from a filename (multi-dot safe)
Search from the end of a filename with instance_num = -1 in TEXTBEFORE and TEXTAFTER so version dots like .v2.final stay intact.
Read the guide →TextRemove first N or last N characters from a cell
Strip fixed-width prefixes, suffixes, or both from product codes safely without #VALUE! errors on short strings.
Read the guide →TextRemove leading zeros from numbers and alphanumeric codes ("000408-B" -> "408-B")
Convert zero-padded numeric text with VALUE or strip only leading zeros from alphanumeric SKUs while preserving internal zeros.
Read the guide →TextRemove non-numeric characters (keep digits only, or strip all digits)
Extract only digits 0–9 from messy IDs ("Order #482-B9" -> "4829") or strip all digits to isolate text labels using double-TEXTSPLIT.
Read the guide →TextRemove special characters from text (and generate clean URL slugs)
Strip punctuation symbols in a single pass or convert product titles into hyphenated URL slugs using TEXTSPLIT array delimiters and TEXTJOIN.
Read the guide →Text & String CleaningRemove Text Between Variable Delimiter Positions (REPLACE & FIND)
Excise variable-length middle segments—such as bracketed revision tags "[REV-204B]" or internal cost codes—regardless of length by feeding FIND start and end positions into REPLACE(text, start, end - start + 1, "").
Read the guide →Text & Data CleaningRemove the First Character or Strip the Last Word from Text Strings Safely
Trim leading symbol prefixes ("#INV-408" -> "INV-408") and strip trailing titles/units ("Elena Petrova PhD" -> "Elena Petrova") without #VALUE! errors on single-character or single-word cells.
Read the guide →Date & TimeRemove Time from Datetime Serials (INT, TRUNC & Pure-Date Matching)
Remove the time fraction from positive spreadsheet datetime serials, extract time of day, and sum a calendar day using an inclusive start and exclusive next-midnight boundary.
Read the guide →Text & Data CleaningRemove Trailing Slash from URLs for Canonical SEO & Lookup Deduplication
Normalize exported sitemap and analytics URLs by trimming spaces and stripping trailing slashes without corrupting bare protocol prefixes or already clean URLs.
Read the guide →Project Finance, Renewable Energy & Tax-Equity StructuringRenewable Tax-Equity Partnership Flip PTC & Cash Formula
Calculate Utility-Scale Renewable Tax-Equity Partnership Flip Gross Production Tax Credits ($M), Pre-Flip 99% Investor Tax Benefit ($M), and Post-Flip 5% Safe-Harbor Residual Cash Split ($M).
Read the guide →FinancialRent-free months: average monthly rent and discounted payment schedule
Model a 36-month rent schedule with its first three months free, and discount the actual remaining payments rather than an unabated annuity.
Read the guide →VLSI Packaging, Chiplets & FPGA ArchitectureRent’s Rule IC Pin Count & Chiplet I/O Formula
Calculate Landman-Russo Rent’s Rule Signal Terminal Count T = k * N_gates^p, External I/O Pins per Gate Locality Ratio, Package Micro-Bump Surplus/Deficit, and Pin-Limited vs Core-Limited Die Status.
Read the guide →