Arte SheetsLearn. Try. Understand.
Arte Sheets

Learn one useful thing today.

Public Choice & Political Economy

Riker-Ordeshook Calculus of Voting Formula

Calculate Expected Instrumental Pivotal Payoff p * B, Downsian Net Voting Return p * B - C, Riker-Ordeshook Expressive Turnout Utility R = p * B - C + D, and Breakeven Pivotal Probability.

Read the guide →
Healthcare & Clinical

RIPASA Appendicitis Score: Original Study and Spreadsheet Arithmetic

Explore the original RIPASA score components as an educational spreadsheet exercise, with the study results and limits of an automated sum.

Read the guide →
Engineering

RLC Circuit formulas: Resonant Frequency, Reactance (XL, XC), Impedance Z & Q-Factor

Calculate series RLC resonant frequency f0 = 1 / (2*PI()*SQRT(L*C)), total AC impedance Z = SQRT(R^2 + (XL - XC)^2), and circuit Quality Factor Q.

Read the guide →
Engineering

RLC Resonant Frequency (f0), Quality Factor (Q) & -3 dB Bandwidth

Calculate LC tank resonant frequency f_0 = 1 / (2 * PI() * SQRT(L * C)) (Hz), Series RLC Quality Factor Q = (1 / R) * SQRT(L / C), and half-power -3 dB Bandwidth BW = f_0 / Q.

Read the guide →
Statistical Analysis

Rogan-Gladen True Prevalence Estimator Correcting False Positives & Negatives

Recover true population prevalence from apparent screening-test positivity via Rogan and Gladen’s (1978) identity (p_app + Spec - 1) / (Sens + Spec - 1) with [0, 1] boundary clamping.

Read the guide →
Quantitative Finance

Rogers-Satchell Drift-Independent OHLC Volatility Estimator Formula

Estimate unbiased intraday and annualized return volatility on trending assets using the Rogers-Satchell (1991) Open-High-Low-Close variance v_RS = ln(H/C)*ln(H/O) + ln(L/C)*ln(L/O).

Read the guide →
Engineering & Science

Rohsenow Nucleate Pool Boiling Correlation: Wall Superheat ΔT_e Formula

Calculate boiler tube wall superheat ΔT_e = T_wall - T_sat (K) for nucleate pool boiling at heat flux q″ via Warren Rohsenow’s 1952 bubble-agitation correlation.

Read the guide →
Financial

ROI, ROAS, Break-Even ROAS, and Annualized ROI formulas

Distinguish Return on Ad Spend (Revenue / Spend) from true Gross-Profit ROI, solve for Break-Even ROAS (1 / GrossMargin), and annualize multi-year returns.

Read the guide →
Financial

ROIC, NOPAT, and Economic Value Added (EVA) formulas

Calculate Net Operating Profit After Tax (NOPAT), Operating Invested Capital, ROIC %, and dollar Economic Value Added above WACC.

Read the guide →
Quantitative Finance

Roll (1984) Implied Effective Bid-Ask Spread Formula (Serial Autocovariance)

Infer the hidden effective dollar and basis-point bid-ask spread from transaction prices alone using Roll’s (1984) first-order price-change autocovariance S_Roll = 2 * SQRT(-Cov(dP_t, dPt-1)).

Read the guide →
Market Microstructure & Quantitative Finance

Roll Serial-Covariance Implicit Bid-Ask Spread Formula

Estimate effective bid-ask spread s_Roll = 2 * SQRT(-Cov(Delta_P_t, Delta_Pt-1)) from transaction prices alone without quote data via Richard Roll’s (1984) bounce formula.

Read the guide →
Date & Time

Roll weekend or Monday dates to Friday / Monday (nearest workday rules)

Apply illustrative weekend shifts or calculate the previous Monday–Friday working date.

Read the guide →
Financial Modeling

Roll’s Implied Effective Bid-Ask Spread from First-Order Price Autocovariance

Estimate hidden transaction bid-ask spreads from trade-only price tapes using Richard Roll’s (1984) microstructure formula Spread = 2 * SQRT(MAX(0, -Cov(Delta_P_t, Delta_Pt-1))).

Read the guide →
Statistical

Rolled Throughput Yield (RTY = PRODUCT) & Hidden Factory DPU formulas

Multiply sequential step First-Pass Yields with PRODUCT(B2:B5) to expose multi-step "Hidden Factory" rework loss and Poisson Defects per Unit (-LN(RTY)).

Read the guide →
Mechanical Drives, Roller Chains & Sprocket Kinematics

Roller Chain Sprocket Pitch Diameter & Chordal Ripple Formula

Calculate Exact Polygon Sprocket Pitch Diameter D_p (mm), Chordal Speed Variation Ripple (%), Mean Linear Chain Velocity (m/s), and Chain Strand Tension (N) from kW.

Read the guide →
Metallurgical Rolling Mills, Hot/Cold Strip Pass Schedules & Roll Separating Force

Rolling Mill Draft, Max Friction Bite & Roll Force Formula

Calculate Pass Thickness Draft Delta_h (mm), Friction-Limited Maximum Self-Entry Draft mu^2*R (mm), Projected Roll-Bite Contact Length L_p (mm), Plane-Strain Roll Separating Force (kN), and Bite Status.

Read the guide →
Cloud Infrastructure & AI Systems Engineering

Roofline Model Compute vs Memory-Bound Formula

Diagnose LLM inference vs training bottlenecks via Samuel Williams, Andrew Waterman, and David Patterson’s (2009) Roofline ceiling MIN(Peak_TFLOPS, Operational_Intensity * HBM_Bandwidth) and Ridge Point.

Read the guide →
Urban Economics & Regional Labor Markets

Rosen-Roback Spatial Equilibrium Wage & Rent Formula

Invert Sherwin Rosen (1979) and Jennifer Roback’s (1982) spatial equilibrium conditions to extract unobserved Household Consumption Amenities (s_R*d_ln_r - d_ln_w) and Firm Agglomeration Productivity (theta_L*d_ln_w + theta_R*d_ln_r).

Read the guide →
Causal Inference & Sensitivity Analysis

Rosenbaum Sensitivity Bounds (Gamma) for Matched-Pair Studies

Calculate Rosenbaum hidden-bias probability bounds p_plus = Gamma / (1 + Gamma) and worst-case McNemar discordant-pair Z-scores to find the exact confounding odds Gamma that tips significance.

Read the guide →
Economics & Market Microstructure

Rosenbluth / Hall-Tideman Index (HTI) Formula: Rank-Weighted Market Concentration

Measure antitrust market concentration with full sensitivity to small-fringe competitors using Gideon Rosenbluth (1955) and Marshall Hall & Nicolaus Tideman’s (1967) rank-weighted index HTI = 1 / (2 * SUM(i * s_i) - 1).

Read the guide →
Statistical & Clinical Analysis

ROSIER Stroke Recognition: Seven Flags and a Spreadsheet Sum

Explore the arithmetic in the seven-item ROSIER stroke recognition scale and its limitations as a screening tool.

Read the guide →
Engineering & Fluid Mechanics

Rosin-Rammler (RRSB) Particle Size Distribution Formula: Cumulative Retained & Passing %

Model pulverized coal, cement clinker, pharmaceutical sprays, and cyclone dusts using Rosin & Rammler’s 1933 Weibull sieve law R(d) = 100 * EXP(-(d / d_63.2)^n) and cumulative passing P(d) = 100 - R(d).

Read the guide →
Engineering & Science

Rossby Number (Ro), Coriolis Parameter (f) & Geostrophic Wind Speed

Calculate the planetary Coriolis parameter f = 2 * Omega * SIN(phi), atmospheric/oceanic Rossby number Ro = U / (|f| * L), and geostrophic wind speed Ug = (dP / dn) / (rho * |f|).

Read the guide →
Pneumatic Conveying, Powder Handling, Rotary Airlock Valves & Flour/Cement Mills

Rotary Airlock Feeder Displacement & Solids Loading Formula

Calculate Theoretical Rotor Swept Volume (m³/h), Pocket-Fill-Adjusted Volumetric Feed (m³/h), Powder Mass Feed Rate (kg/h), and Dilute-Phase Solids-to-Air Mass Loading Ratio mu.

Read the guide →
Lithium-Battery Dry-Room HVAC, Silica-Gel Desiccant Wheels & Psychrometric Mass Balance

Rotary Desiccant Wheel Moisture Removal & Regen Formula

Calculate AHRI 940 Moisture Removal Capacity MRC (kg/h), Process Latent Heat of Sorption Released (kW), Reactivation Heater Thermal Input (kW), and Specific Regeneration Energy (kWh/kg).

Read the guide →
Cement, Lime & Mineral Pyroprocessing, USBM Sullivan Rotary Kiln Residence Time

Rotary Kiln Sullivan Residence Time & Fill % Formula

Calculate USBM Sullivan Solids Mean Residence Time (min), Axial Bed Advance Velocity (m/min), In-Kiln Solids Holdup Inventory (tonnes), and Volumetric Fill Degree (%).

Read the guide →
Mineral Processing, Composting & Recycling Separation, Rotary Trommel Screen Kinetics

Rotary Trommel Screen Critical RPM & Bed Fill Formula

Calculate Drum Critical Centrifuging Speed Ncrit (RPM), Operating % Critical Speed, Cascade Helix Residence Time (s), and Cross-Sectional Bed Holdup Fill (%) for Undersize Screening.

Read the guide →
Charts & Visual Data

Rotate Pie Chart Formula: Exact First-Slice Angle to Center Callout at 3 O’Clock

Calculate the exact Angle of First Slice in degrees MOD(90 - 180 * Share + 360, 360) so a highlighted pie wedge or Bar-of-Pie connector centers symmetrically on the 3 o’clock horizontal axis.

Read the guide →
Hollow Polymer Processing, Rotational Molding Powder Shot Weight & Cavity Tumbling Fill

Rotational Molding Powder Shot Weight & Bulk Fill Formula

Calculate Required Pulverized PE Charge Weight (kg), Unmelted Powder Loose Volume (L), Cold-Mold Volumetric Fill Fraction (%), and Solid-to-Powder Compaction Ratio.

Read the guide →
Biostatistics & Epidemiology

Rothman Additive Interaction: RERI, AP, and Synergy Index (S)

Calculate Relative Excess Risk due to Interaction (RERI = RR_11 - RR_10 - RR_01 + 1), Attributable Proportion (AP), and Rothman’s Synergy Index (S) to detect public-health synergy missed by multiplicative models.

Read the guide →
Actuarial Economics & Asymmetric Information

Rothschild-Stiglitz Insurance Screening Deductible Formula

Solve the incentive-compatible Low-risk partial coverage deductible D_L* and test Rothschild-Stiglitz separating equilibrium existence lambda_H >= lambda_H*.

Read the guide →
Master Production Scheduling & Factory Capacity Planning

Rough-Cut Capacity Planning (RCCP) & Overtime Formula

Validate a Master Production Schedule (MPS) using APICS Rough-Cut Capacity Planning (RCCP): Required Standard Hours, Demonstrated Capacity (Machines * Clock_Hours * Utilization_Efficiency), Load-to-Capacity Ratio, and Clock Overtime Hours.

Read the guide →
Math & Trig

Round a number to N significant figures (scientific and lab precision)

Dynamically compute ROUND's decimal-places argument from INT(LOG10(ABS(x))) to round large integers, tiny decimals, and negatives to N sig figs.

Read the guide →
Numbers and totals

ROUND in Excel: why rounded rows can disagree with the total

Compare rounding each amount with rounding the final sum. Use a three-row example, check negative midpoint values, and separate number formatting from changing a value.

Read the guide →
Math & Trig

Round order quantity up to case-pack / MOQ bundle size (CEILING & excess units)

Enforce supplier Minimum Order Quantity (MOQ) and case-pack multiples, calculate sealed cases to order, and track overage buffer units.

Read the guide →
Math & Rounding

Round Retail Prices to End in .45 or .95 with Minimum-Margin Floor Guard

Snap raw cost-plus catalog prices to the nearest .45 or .95 psychological charm ending—or force upward rounding when nearest-step rounding would dip below your target floor price.

Read the guide →
Math & Trig

Round retail prices to end in .99 or .95 (charm pricing formulas)

Convert calculated cost-plus prices to nearest .99, margin-safe upward .99, or $5-increment .95 retail price points.

Read the guide →
Date & Time

Round times or durations to 15-minute increments

Snap clock punches to the nearest quarter-hour (96 slots per day) or round billable duration upward to 15-minute increments.

Read the guide →
Math

Round to Nearest 10, 100, 1,000 or Million (Negative num_digits)

Round board-deck budgets, headcount forecasts, and property valuations to the LEFT of the decimal point using negative num_digits in ROUND(x, -3), ROUNDUP(x, -3), and ROUNDDOWN(x, -6).

Read the guide →
Math & Rounding

Round to Nearest Multiple (MROUND Pattern) vs. Up/Down Multiples (CEILING & FLOOR)

Round quantities, billing increments, and unit prices to the nearest, next-higher, or next-lower multiple of 5, 0.25, or carton pack size using ROUND, CEILING, and FLOOR.

Read the guide →
Math

Round Up or Down to Next Half (0.5), Quarter (0.25) or Custom Multiple

Round a numeric value upward, downward or to the nearest positive increment, with explicit input checks.

Read the guide →
Numbers and totals

ROUNDUP function: calculate how many boxes or packs are needed

Any leftover item requires another container. Divide item count by container capacity inside ROUNDUP(..., 0) so partial packs always round up to the next whole box.

Read the guide →
Lookup & Reference

ROW and ROWS: create deletion-proof line numbers and count table height

Distinguish position index ROW(reference) from range height ROWS(array) so inserted or blank rows never break numbering.

Read the guide →
Math & Trigonometry

Row-Wise and Column-Wise Matrix Summaries and Flags (BYROW & BYCOL Formula Patterns)

Evaluate row-by-row totals, minimum-threshold SLA flags, and column-by-column period peaks across 2D matrices using CHOOSEROWS, CHOOSECOLS, and helper vectors.

Read the guide →
Healthcare & Clinical

ROX and Rapid Shallow Breathing Indices: Units and Examples

Calculate two respiratory ratios with fictional values and understand their limits in clinical interpretation.

Read the guide →
Labor Economics & Policy Econometrics

Roy Self-Selection Positive vs Negative Sorting Formula

Diagnose Andrew Roy’s (1951) and George Borjas’s (1987) occupational/migration skill selection via covariance wedges Cov(u_1, u_1 - u_0) and Cov(u_0, u_1 - u_0).

Read the guide →
Labor Economics & Econometrics

Roy-Borjas Migration Self-Selection Skill Sorting Formula

Classify Positive Selection, Negative Selection, and Refugee Sorting using Borjas’s (1987) Roy-model conditional log-wage selection terms Q_0 and Q_1.

Read the guide →
Rubber & Tire Molding, Sulfur/Peroxide Vulcanization Kinetics & ASTM D5289 MDR t90

Rubber Vulcanization Equivalent Cure Units (ECU) Formula

Calculate Arrhenius Crosslinking Rate Multiplier vs Reference Temperature, Equivalent Cure Time t90(T) in Minutes and Seconds, and Press Cycle Time Saved (min).

Read the guide →
Civil, Structural & Geotechnical Engineering

Rubey (1933) Sediment Fall Velocity Formula: HEC-RAS Dimensionless Factor F_1 & Settling

Calculate river sand and gravel terminal settling velocity w_s = F_1 * SQRT((s - 1) * g * D) using USGS geologist William W. Rubey’s (1933) analytical viscous-plus-impact quadratic drag formula built into USACE HEC-RAS.

Read the guide →
Game Theory & Strategic Negotiation

Rubinstein Alternating-Offers Bargaining Equilibrium Formula

Calculate Rubinstein’s (1982) unique subgame-perfect bargaining split x_1* = S * (1 - delta_2) / (1 - delta_1 * delta_2) to quantify patience vs first-mover advantage.

Read the guide →