Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Lookup & Reference

Repeat a 1..N number sequence & round-robin assign leads from a list (MOD & INDEX)

Cycle through non-empty names in a fixed roster range. Learn how roster changes affect calculated assignments.

Read the guide →
Lookup & Reference

Repeat a compacted list cyclically with INDEX, FILTER and MOD

Skip gaps and empty-string entries, then cycle through the remaining list with a validated positive step number.

Read the guide →
Date & Time

Repeat a payment every 3 months (or N months) in a monthly financial model

Build a monthly schedule that includes the start month and repeats an illustrative payment every positive whole number of months.

Read the guide →
Database & Dynamic Filtering

Replace DAVERAGE, DMAX, DMIN, and DSTDEV Criteria Ranges With Dynamic FILTER Formulas

Eliminate fragile multi-row database criteria blocks by pairing FILTER, AVERAGEIFS, MAXIFS, MINIFS, and STDEV_S with direct cell-referenced criteria.

Read the guide →
Data Cleaning & Text

Replace Inconsistent Delimiters with a Clean Standard Separator (SUBSTITUTE)

Normalize mixed semicolon, comma, and optional-space delimiters into a consistent pipe or CSV separator using nested SUBSTITUTE and TRIM without double spaces.

Read the guide →
Money Markets, Securities Financing & Tri-Party / Bilateral Repo

Repo Collateral Haircut, ACT/360 Interest & Leverage Formula

Calculate Securities Repurchase Agreement (Repo) Purchase Cash Lent After Haircut on Dirty Collateral Value, ACT/360 Repo Interest ($M), Term Repurchase Price ($M), and Implied Collateral Leverage Multiple (1 / Haircut).

Read the guide →
Text

REPT function: build in-cell progress bars and zero-pad fixed-width IDs

Repeat characters N times with REPT to render lightweight text bar charts or pad variable-length account numbers.

Read the guide →
Financial

Required recovery rate: percentage gain needed to break even after a loss

Calculate the asymmetric percentage gain required to recover from a portfolio drawdown or sales drop using LossPct / (1 - LossPct).

Read the guide →
Lookup & Reference

Reshape a Single Column Into Fixed-Width Rows or Columns (WRAPROWS & WRAPCOLS Formula)

Convert a flat 1D vertical list into a row-major (WRAPROWS) or column-major (WRAPCOLS) 2D table with custom padding for incomplete final blocks using INDEX and COUNTA.

Read the guide →
Finance

Residual Income (RI) Equity Valuation & Justified Price-to-Book (P/B)

Value banks, insurers, and non-dividend companies using the Edwards-Bell-Ohlson Residual Income Model V_0 = BV_0 + ((ROE - r_e) * BV_0) / (r_e - g) and Justified P/B = 1 + (ROE - r_e) / (r_e - g).

Read the guide →
Automotive Body-in-White Joining, AWS D8.1 Resistance Spot Welding & Joule Heating

Resistance Spot Welding Joule Heat & Nugget Size Formula

Calculate AWS D8.1 Minimum Weld Nugget Diameter 4*SQRT(t) (mm), 60 Hz Weld Squeeze/Hold Time (s), Joule Weld Energy I²Rt (J), and Electrode Cap Current Density (A/mm²).

Read the guide →
Financial

Restaurant food cost %, edible yield, and menu pricing formulas

Calculate Period Food Cost % from inventory counts, adjust ingredient costs for butcher/prep trim loss (AP Cost / Yield %), and price menu items.

Read the guide →
Restaurant Operations & Hospitality Finance

Restaurant Prime Cost & Menu Engineering Formula

Audit restaurant Prime Cost % = (CoGS + Total_Labor) / Sales and classify dishes into Stars, Plowhorses, Puzzles, and Dogs via Michael Kasavana and Donald Smith’s (1982) 70% popularity rule.

Read the guide →
AI workflows

Restore a table from an image with AI, then check the numbers

Turn a screenshot into editable spreadsheet cells. Review uncertain values, verify quantities and prices, and add formulas only after checking the transcription.

Read the guide →
Biostatistics & Survival Analysis

Restricted Mean Survival Time (RMST) Exact Step-Function Area Formula

Calculate exact Restricted Mean Survival Time RMST(tau) and Restricted Mean Time Lost RMTL(tau) under a Kaplan-Meier step curve without trapezoidal downward bias.

Read the guide →
Retail Merchandising & Revenue Management

Retail Clearance Markdown & Salvage Profit Formula

Calculate Constant-Elasticity Clearance Units Sold MIN(I_rem, v_0 * (1 - d)^epsilon * W_rem), Hold-Full-Price vs Markdown Gross Margin (with end-of-season liquidator salvage), and Net Markdown Profit Lift.

Read the guide →
Financial

Retail Open-to-Buy (OTB) formula: merchandise budget at retail and cost

Calculate monthly Open-to-Buy purchasing capacity OTB = PlannedSales + Markdowns + PlannedEOM - BOM - OnOrder at both retail value and wholesale cost.

Read the guide →
Retail Real Estate & Lease Accounting

Retail Percentage Lease & Natural Breakpoint Formula

Calculate shopping-center Natural Breakpoint = Base_Rent / Pct_Rate, Overage Rent = Pct_Rate * MAX(0, Sales - Breakpoint), and Effective Occupancy-Cost-to-Sales Ratio.

Read the guide →
Commercial Real Estate, Retail Leasing & Store Economics

Retail Percentage Rent, Natural Breakpoint & CAM Formula

Calculate Retail Shopping-Center Natural Sales Breakpoint (Base_Rent / Overage_Pct), Percentage Rent Overage Charge MAX(0, (Sales - Breakpoint)*Pct), Capped Controllable CAM Reconciliation, and Total Occupancy Cost % of Sales.

Read the guide →
Retail Category Management & Merchandising

Retail Planogram Linear-Foot Margin & Slotting Formula

Calculate Allocated Planogram Linear Shelf Feet, Weekly Gross Margin per Linear Foot (GM/LF), Space-to-Margin Productivity Index, and New-SKU Slotting Allowance Payback Weeks.

Read the guide →
Retail Merchandising & Trade Promotion

Retail Promo Cannibalization, Halo & Net Margin Formula

Decompose Trade Promotion ROI across Naive Promoted-SKU Margin Lift, Sister-SKU Cannibalization Loss, Cross-Category Basket Halo Profit, and True Net Incremental Category Margin.

Read the guide →
Financial

Retail Sell-Through Rate, Weeks of Supply (WOS) & Stock-to-Sales

Calculate sell-through, beginning-stock-to-sales and remaining weeks of supply for a closed inventory cohort with no replenishment or returns.

Read the guide →
Financial & Accounting

Retrieve Latest Closing Price, As-Of Quote & Trailing N-Day Average From a Price Log

Extract the most recent closing price for any ticker in an unsorted multi-symbol quote log, snap weekend or holiday valuation dates back to the prior trading close, and compute trailing N-day averages.

Read the guide →
Logical

Return Blank ("") If Input Is Empty—Without Breaking Downstream Math

Suppress ugly 0s on unentered template rows with IF(ISBLANK(B2), "", ...) while ensuring downstream totals use SUM/N() rather than + so "" never triggers #VALUE!.

Read the guide →
Lookup & Reference

Return Cell Address of Highest Value or Lookup Match (ADDRESS + MATCH)

Return address text for the first maximum, minimum or matching reading ID, with explicit validation and missing-match handling.

Read the guide →
Dynamic Arrays

Return multiple lookup matches into separate rows or columns (FILTER + TRANSPOSE)

Turn one-to-many lookups (all reps in a territory or all SKUs on an order) into vertical lists with FILTER or horizontal columns with TRANSPOSE(FILTER(...)).

Read the guide →
Lookup & Reference

Return the A1 cell address of the MAX value or lookup match (ADDRESS & XMATCH)

Locate the exact "$C$6" or "C6" coordinate of the highest number or a matched lookup key inside any offset range using ADDRESS, ROW, COLUMN, and XMATCH.

Read the guide →
Auction Theory & Mechanism Design

Revenue Equivalence: First-Price vs All-Pay Bid Formula

Compare symmetric Bayes-Nash equilibrium bids across Second-Price/English, First-Price/Dutch, and All-Pay auctions on [0, V_max] and verify William Vickrey (1961) and Roger Myerson’s (1981) Revenue Equivalence identity.

Read the guide →
Fintech Credit, SaaS/E-Commerce Capital & Non-Dilutive Debt

Revenue-Based Financing (RBF) Royalty Sweep & APR Formula

Calculate Revenue-Based Financing Total Repayment Cap ($k), Monthly Gross-Revenue Sweep ($k), Months to Payoff Cap, and Nominal Annualized Fee Rate (%).

Read the guide →
Financial

Reverse discount formula: find original price before a percentage discount

Divide SalePrice by (1 - DiscountPct) to recover exact list price—avoiding the common mistake of multiplying SalePrice by (1 + DiscountPct).

Read the guide →
Supply Chain Finance & Corporate Treasury

Reverse Factoring (SCF) Arbitrage & Savings Formula

Calculate Supply Chain Finance (Reverse Factoring) ACT/360 Early-Payment Discount Fee, Supplier Day-10 Net Cash Proceeds, Supplier Interest Savings vs Standalone Borrowing, and Participation Viability.

Read the guide →
Lookup & Reference

Reverse Left Lookup: Retrieve Values to the Left of the Lookup Column

Look up an ID or SKU positioned to the left of the search column without rearranging worksheet columns using XLOOKUP or INDEX and MATCH.

Read the guide →
Corporate Tax M&A, Divestiture Structuring & IRC Section 355(e)

Reverse Morris Trust >50% Tax-Free Spin-Merge Formula

Calculate Reverse Morris Trust (RMT) SpinCo Contributed Equity (EV - Leveraged Cash Distribution), Combined MergeCo Equity Value, Parent Shareholder Pro-Forma Ownership Share, and IRC Section 355(e) / Tax-Basis Qualification.

Read the guide →
Financial

Reverse mortgage illustration: growing balance and projected home equity with FV

Model an initial draw and fixed end-of-month advances at a constant monthly rate, then compare debt with an assumed future property value.

Read the guide →
Lookup & Reference

Reverse the order of a list or column dynamically

Flip a chronological log upside down without sorting alphabetically by pairing SORTBY with a descending SEQUENCE index or INDEX/ROWS.

Read the guide →
Text

Reverse word or category breadcrumb order inside a cell

Flip hierarchical paths ("Global / US / Retail / Shoes" -> "Shoes / Retail / US / Global") or space-separated words using vertical TEXTSPLIT + SORTBY.

Read the guide →
Healthcare & Clinical

Revised Baux Score: Burn Research and Spreadsheet Arithmetic

Explore the arithmetic used in the revised Baux research score and the limitations of using a model for an individual burn injury.

Read the guide →
Healthcare & Clinical

Revised Cardiac Risk Index: An Educational Point-Sum Example

Count five illustrative binary factors and a creatinine threshold from the RCRI; the worksheet does not predict an individual outcome or determine surgical care.

Read the guide →
Statistical & Clinical Analysis

Revised Five-Factor Score in Vasculitis: Context and Arithmetic

Explore the revised vasculitis Five-Factor Score and the limitations of applying historical cohort estimates to an individual.

Read the guide →
Healthcare & Clinical Calculations

Revised Geneva Score: Pulmonary Embolism Pretest Probability

Explore the 2006 Revised Geneva score weights and study categories using fictional inputs, with important limitations.

Read the guide →
Healthcare & Clinical

Revised Trauma Score: Weighted and Unweighted Arithmetic

Convert three fully documented physiological values into coded categories and compare weighted RTS with the unweighted sum, without automatic transport decisions.

Read the guide →
Engineering

Reynolds Number (Re) formula: Laminar vs Turbulent pipe flow regime

Calculate dimensionless Reynolds Number Re = (ρ · v · D) / μ in SI units and classify Laminar (< 2,300), Transitional, and Turbulent (> 4,000) flow.

Read the guide →
RF & Wireless Transceiver Design, Receiver Linearity & Dynamic Range

RF Receiver IIP3, IMD3 & Spurious-Free Dynamic Range Formula

Calculate RF Front-End Input-Referred Two-Tone Third-Order Intermodulation Product IMD3 (dBm = 3*Pin - 2*IIP3), Carrier-to-Intermod Suppression (dBc), Two-Thirds-Slope Spurious-Free Dynamic Range SFDR (dB), and Noise-Floor Headroom.

Read the guide →
Engineering

RF VSWR, Reflection Coefficient (Gamma) & Return Loss (dB) formulas

Calculate RF transmission-line impedance mismatch using Gamma = ABS((Z_L - Z_0) / (Z_L + Z_0)), Voltage Standing Wave Ratio VSWR = (1 + Gamma) / (1 - Gamma), Return Loss -20*LOG10(Gamma), and reflected power.

Read the guide →
Logical

RFM (Recency, Frequency, Monetary) customer scoring & CRM segment formula

Score customers 1–5 on Recency (lower days = higher score), Frequency, and Monetary spend, build 3-digit RFM codes ("555", "155"), and assign lifecycle segments.

Read the guide →
Statistical & Mathematical Formulas

Richards Generalized Logistic Curve: Asymmetry Parameter (ν) & Inflection

Model asymmetric epidemic, crop, and market S-curves via F. J. Richards’ 4-parameter generalized logistic equation Y(t) = K * (1 + ν * EXP(-r * (t - t_m)))^(-1 / ν) and inflection height Y_inf = K * (1 + ν)^(-1 / ν).

Read the guide →
Engineering & Science

Richardson-Dushman Thermionic Emission Current Density Formula (SEM, X-Ray & Klystron Cathodes)

Calculate thermionic electron emission current density J = A_G * T^2 * EXP(-phi_eV / (kB_eV * T)) in A/cm^2 across tungsten, thoriated tungsten, and LaB6 electron-microscope cathodes.

Read the guide →
Engineering & Science

Richardson-Zaki Hindered Settling Velocity & Kynch Gravity Thickener Solids Flux

Calculate concentrated slurry hindered settling velocity v_h = v_t * ((1 - C_v) ^ n) and batch gravity-thickener solids flux G_s = C_v * v_h for mineral tailings, wastewater clarifiers, and fluidized beds.

Read the guide →
Engineering & Science

Riedel Parameter (αc): Critical Vapor-Pressure Slope & dPsat/dT at Tc

Calculate L. Riedel’s dimensionless critical saturation slope α_c = 5.808 + 4.93 * ω and dimensional critical pressure-temperature derivative (dP_sat / dT)|_Tc = α_c * (P_c / T_c) (bar/K).

Read the guide →
Cleaning imported data

RIGHT function: extract trailing serial digits with leading zeros

Pull a fixed-width suffix from the end of invoice or voucher IDs while preserving leading zeros as text, and handle short or blank cells cleanly.

Read the guide →