Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Logical & Lookup Formulas

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 & Reference

Rank & 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 →
Statistical

RANK 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 →
Statistical

RANK 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 →
Statistical

Rank 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 →
Statistical

Rank 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 Calculations

Ranson 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 & Science

Ranz-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 Analysis

Rao 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 Banking

RAROC 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 Analysis

Rasch 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 & Clinical

RASS 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 →
Financial

RATE 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 →
Engineering

Rational 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 →
Science

Rayleigh 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 Budgeting

Rayleigh 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 & Science

Rayleigh 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 →
Engineering

RC 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 Equity

Real 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 Finance

Real 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 →
Financial

Real 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 & Reference

Rearrange 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 Analysis

Recentered 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 →
Engineering

Rectangular & 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 Circle

Rectangular 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 Dispersion

Rectangular 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 Cycles

Recuperated 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 & Science

Reddy-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 & Science

Redlich-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 Analytics

Regional 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 Economics

Reilly 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 & Time

Reject 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 & Physiology

Relative 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 Valuation

Relative 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 →
Statistical

Relative 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 & Reference

Relative 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 & Time

Remaining 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 Arrays

Remove 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 →
Text

Remove 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 →
Text

Remove 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 →
Text

Remove 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 →
Text

Remove 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 →
Text

Remove 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 Cleaning

Remove 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 Cleaning

Remove 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 & Time

Remove 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 Cleaning

Remove 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 Structuring

Renewable 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 →
Financial

Rent-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 Architecture

Rent’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 →