Learn one useful thing today.
Closed-End Fund NAV Discount & Market Yield Formula
Calculate Closed-End Fund (CEF) Share Price Discount/Premium to NAV (Price - NAV)/NAV, Required Portfolio NAV Distribution Rate vs Amplified Market Distribution Yield, and 1940-Act Structural Leverage Ratio.
Read the guide →Commercial Mortgage & Fixed-Income AnalyticsCMBS Yield Maintenance Prepayment Penalty Formula
Calculate commercial mortgage Yield Maintenance prepayment penalties MAX(Floor * Balance, Balance * (r_note - y_T) * ((1 - (1 + y_T)^(-T)) / y_T)) as Treasury yields move.
Read the guide →Structural Engineering, TMS 402 Reinforced CMU Masonry Walls & Buckling SlendernessCMU Masonry Wall Prism Strength & Slenderness Formula
Calculate Masonry Wall Slenderness Ratio h/r, TMS 402 Piecewise Parabolic-to-Euler Buckling Reduction Factor, Nominal Axial Capacity Pn (kN), and LRFD Strength phi*Pn (kN).
Read the guide →5-Axis CNC Die/Mold Machining & CAM Toolpaths, Ball-Nose Scallop & Effective DiameterCNC Ball-Nose Scallop Cusp Height & Effective Vc Formula
Calculate 3D Mold Finishing Scallop Cusp Height h (um), Effective Engaged Cutting Diameter Deff (mm), True Cutting Surface Speed Vc,eff (m/min), and % of Nominal Diameter Speed.
Read the guide →Mechatronics, CNC Linear Motion Axes, Precision Ball Screws & Servo SizingCNC Ball-Screw Lead, RPM & Servo Motor Torque Formula
Calculate Peak Rapid-Traverse Ball-Screw Speed (RPM), External Thrust Load Torque T_load (N·m), Double-Nut Preload Drag Torque T_pre (N·m), and Continuous Servo Motor Torque (N·m).
Read the guide →Automotive Transmission Gear Manufacturing, CNC Cylindrical Gear Hobbing KinematicsCNC Gear Hobbing Sync RPM, Feed & Cycle Time Formula
Calculate Hob Cutter Spindle Speed (RPM), Electronic-Gearbox Synchronized Worktable Speed (RPM), Axial Saddle Feed Rate (mm/min), and Hobbing Cut Time per Stack (min).
Read the guide →CNC Machining, High-Efficiency Milling (HEM), Trochoidal Toolpaths & CAM FeedsCNC Milling Radial Chip-Thinning Factor & MRR Formula
Calculate Spindle Speed N (RPM), Exact Radial Chip-Thinning Compensation Factor RCTF, Compensated Table Feed Rate V_f (mm/min), and Volumetric Material Removal Rate MRR (cm³/min).
Read the guide →Industrial Organization & Pricing StrategyCoase Durable-Good Monopoly: Leasing vs Spot Sale Formula
Quantify Ronald Coase’s (1972) durable-good time-inconsistency profit loss by comparing 2-period commitment leasing (1 + delta)*(a^2 / 4) against spot selling a^2 * (2 + delta)^2 / (4 * (4 + delta)).
Read the guide →FinancialCobb-Douglas production function (Y = A * K^alpha * L^beta), MPK & MPL
Calculate economic output Y, Marginal Product of Capital (MPK), Marginal Product of Labor (MPL), and Returns to Scale from TFP, Capital, and Labor.
Read the guide →Operations Research & Queueing TheoryCobham Non-Preemptive Priority Queue Waiting Formula
Calculate urgent W_q1 = R_0/(1 - rho_1) and routine W_q2 = R_0/((1 - rho_1)*(1 - rho_1 - rho_2)) M/G/1 waits via Alan Cobham’s (1954) priority formula.
Read the guide →Statistical & EconometricCochran-Armitage Trend Test (Z_CA & χ²_trend) for Dose-Response Proportions
Test monotonic dose-response trends across ordered 2×k clinical trial cohorts using the Cochran-Armitage statistic Z_CA = T / SQRT(Var(T)) and 1-df χ²_trend = Z_CA^2.
Read the guide →Nonparametric Statistics & Clinical TrialsCochran’s Q Test Formula for Matched Binary Outcomes Across k Conditions
Test whether binary pass/fail proportions differ across three or more matched treatments or raters using Cochran’s (1950) Q statistic and verify unanimous-row invariance.
Read the guide →Mineral Processing & Tailings Dewatering, Coe & Clevenger (1916) Continuous Thickener AreaCoe-Clevenger Continuous Thickener Area & Solids Flux
Calculate Coe-Clevenger Thickener Clarification Area (m²), Required Circular Tank Diameter (m), Clarified Overflow Water Rate (m³/h), and Daily Solids Loading Flux (t/m²·d).
Read the guide →StatisticalCoefficient of variation (CV) formula: compare relative volatility across scales
Divide STDEV.S by AVERAGE to measure unit-free relative dispersion across products, portfolios, or sensors with different price scales.
Read the guide →Food & Beverage Science, SCA Coffee Brewing Control Chart, TDS & Extraction YieldCoffee TDS, Extraction Yield (EY %) & Brew Ratio Formula
Calculate Pour-Over & Espresso Water-to-Coffee Input Ratio, Spent-Puck Liquid Retained Ratio LRR (g/g), Extracted Coffee Solubles (g), and SCA Extraction Yield EY (%).
Read the guide →Engineering & ScienceCoffin-Manson & Basquin Strain-Life Fatigue Equation + Transition Life (2Nt)
Calculate total strain amplitude delta_epsilon/2 across low-cycle plastic fatigue (Coffin-Manson) and high-cycle elastic fatigue (Basquin), plus the elastic-plastic transition reversals 2Nt.
Read the guide →StatisticalCohen's d effect size & Pooled Standard Deviation formula
Calculate a standardized mean difference for two independent groups using a pooled within-group standard deviation.
Read the guide →Statistical AnalysisCohen’s h Arcsine Two-Proportion Effect Size & Variance-Stabilized Z-Test
Measure standardized conversion and clinical rate differences across [0, 1] using Jacob Cohen’s arcsine transformation h = 2*ASIN(SQRT(p_1)) - 2*ASIN(SQRT(p_2)).
Read the guide →Metallurgical Wire & Rod Drawing, Tungsten-Carbide Dies & Capstan Pass DesignCold Wire-Drawing Reduction, True Strain & Pull Force Formula
Calculate Cross-Sectional Area Reduction r (%), True Logarithmic Strain epsilon = 2*LN(d_0/d_f), Factored Axial Draw Stress sigma_d (MPa), Capstan Pull Force (kN), and Tensile Necking Break Check.
Read the guide →Industrial Logistics REITs, Cold-Chain Warehousing & Unit EconomicsCold-Storage REIT Pallet Rent, Handling Turns & NOI Formula
Calculate Cold-Storage Warehouse REIT Annual Pallet Storage Revenue ($M), Throughput Handling & Blast-Freezing Revenue ($M), Dual-Segment Facility NOI ($M), and Blended NOI Margin (%).
Read the guide →Engineering & ScienceColebrook-White Pipe Friction via Serghides’ Steffensen Acceleration (< 0.003% Error)
Solve the implicit Colebrook-White turbulent Darcy friction equation without Goal Seek or circular references using T. K. Serghides’ (1984) 3-step Steffensen Aitken Δ² acceleration.
Read the guide →AI & CollaborationCollaborative Budget Variance Triage: @Mentions, Comments & Viewer Release Gate
Flag material department budget variances (> 5%), generate targeted @mention comment prompts for open breaches, and lock executive Viewer sign-off until all blockers resolve.
Read the guide →Collaboration & GovernanceCollaborative Formula-Override Audit with ISFORMULA & Suggest-Mode Governance
Detect accidental literal value pastes over calculated model columns using per-row ISFORMULA flags, pinpoint the first broken line via INDEX/MATCH, and prevent silent overrides with Suggest Mode and @mentions.
Read the guide →Spreadsheet Auditing & Collaborative WorkflowsCollaborative Month-End Close Checklist: Roles, @Mentions, Comments & Sign-Off Gate Formula
Coordinate multi-user month-end close and engineering QA reviews in Arte Sheets using role-based access (owner, contributor, suggester, viewer), threaded cell comments, @mentions, notifications, and automated sign-off readiness formulas.
Read the guide →Conditional Logic & ValidationCollaborative Spreadsheet Sign-Off: Multi-Reviewer Roles, Suggestions, Comments & Consensus
Coordinate multi-user financial closes and engineering reviews using real-time roles (owner, contributor, suggester, viewer), cell suggestions, threaded comments, @mentions, notifications, and a formula-driven Reviewer Consensus Gate.
Read the guide →Sports Analytics & Tournament RankingColley Bias-Free Laplace Sports Rating Formula
Calculate Wesley Colley’s Laplace-regularized Strength-of-Schedule team rating r_i = (1 + (W - L)/2 + SUM(r_opp)) / (2 + W + L), Effective Wins W_eff, and Preseason Shrinkage vs Raw Win%.
Read the guide →Lookup & ReferenceCOLUMN and COLUMNS: build dynamic horizontal indexes and count table width
Generate auto-incrementing VLOOKUP column numbers across a report with COLUMN or COLUMNS, and count total cells in a 2D block.
Read the guide →Charts & Visual DataColumn Chart with Target Line & Conditional Above/Below Series Formula
Stage a two-color Column Chart with a constant horizontal Target Line by splitting actual values into mutually exclusive Above-Target and Below-Target helper series.
Read the guide →Charts & Visual DataCombination (Combo) Chart & Secondary Axis Scaling Formula: Zero-Baseline Alignment
Combine disparate units like Dollar Revenue Columns and Gross Margin % Lines on a Combo Chart without baseline distortion by computing exact Secondary Y-Axis bounds that lock both primary and secondary zero lines.
Read the guide →Statistical & EngineeringCombinations Without & With Replacement Formula (COMBIN & COMBINA via FACT)
Calculate distinct k-item subsets without replacement C(n, k) = n! / (k!(n - k)) and multisets with replacement C(n + k - 1, k) using FACT for audit sampling, portfolio pairs, and reliability redundancy.
Read the guide →Dynamic ArraysCombine & Reorder Virtual Columns with CHOOSECOLS & HSTACK (Left VLOOKUP)
Assemble custom in-memory lookup tables in any column order—including right-to-left VLOOKUP without physically rearranging worksheet columns—using CHOOSECOLS and HSTACK.
Read the guide →Data Validation & CleaningCombine Duplicate Rows & Sum Values Non-Destructively (UNIQUE, COUNTIF & SUMIFS)
Consolidate repeated SKU or customer line items into one summary row per key while preserving raw transaction audit trails and reconciling grand totals.
Read the guide →Commercial Equipment Finance, Fleet Leasing & IRC Section 7701(h) TRAC LeasesCommercial Fleet TRAC Lease Terminal Adjustment Formula
Calculate Commercial Truck & Tractor IRC Section 7701(h) TRAC Lease Guaranteed Residual Value ($), Terminal Rental Adjustment Deficiency or Rebate ($), Lessee All-In Net Cash Lease Cost ($), and All-In Cost-to-Capex Ratio.
Read the guide →Commercial Real Estate Finance, Bifurcated Ground Leases & Leasehold UnderwritingCommercial Ground Lease CPI-Collared Reset & Coverage Formula
Calculate 99-Year Bifurcated Commercial Ground Lease CPI-Collared Periodic Rent Reset ($M), Residual Leasehold Net Operating Income ($M), Senior Ground-Rent Coverage Ratio, and Ground Rent % of Property NOI.
Read the guide →Commercial Real Estate & Property AccountingCommercial Lease CAM Gross-Up & Expense-Stop Formula
Gross up occupancy-sensitive variable operating expenses Var_OpEx * MAX(1, GrossUp_Cap / Actual_Occ) without inflating fixed costs, and compute pro-rata tenant expense-stop recoveries.
Read the guide →Commercial Real Estate & LeasingCommercial Lease TI, Free Rent & Net Effective Rent Formula
Calculate ASC 842 Straight-Line Effective Rent, Unamortized Landlord Net Effective Rent (NER), and Time-Value-Discounted Landlord NER ($/SF/yr) after Tenant Improvements, Free Rent, and Commissions.
Read the guide →Commercial Property Insurance, Risk Management, Underinsurance Audits & CPCU ClaimsCommercial Property Coinsurance Penalty ("Did/Should") Formula
Calculate Required Coinsurance Limit ("Should Have"), Coinsurance Compliance Ratio MIN(1, Did/Should), Net Insurer Claim Recovery After Deductible, and Uninsured Coinsurance Penalty Haircut.
Read the guide →FinancialCompare compounding periods: Annual, Quarterly, Monthly, Daily, and Continuous
See exact dollar differences across compounding frequencies m = 1, 4, 12, 365 using P*(1 + r/m)^(m*t) alongside the continuous limit P*EXP(r*t).
Read the guide →FinancialCompare loans with different durations: monthly payment vs total interest
Evaluate 36-, 48-, 60-, and 72-month loan offers side by side by contrasting lower monthly payments against total lifetime interest paid.
Read the guide →StatisticalCompare two columns row by row: count matches, mismatches, and accuracy %
Audit parallel Ordered vs Shipped or Forecast vs Actual columns row-for-row using SUMPRODUCT without helper columns.
Read the guide →Lookup & ReferenceCompare Two Lists: Count Shared Matches & Return First Overlap
Compare text identifiers using row membership, a separate distinct-item count and the first shared value in List1 order.
Read the guide →LogicalCompare two tables or columns cell-by-cell for differences (audit & reconciliation)
Count value differences between aligned snapshots and list the old record IDs for rows containing a difference.
Read the guide →Healthcare & ClinicalComparing Karnofsky and ECOG Performance Scales
Explore one published KPS–ECOG comparison table and its limitations; the mapping does not replace an individual clinical assessment.
Read the guide →Engineering & ScientificComplex Cotangent, Secant & Cosecant Formulas (IMCOT, IMSEC & IMCSC)
Evaluate complex reciprocal trigonometric functions cot(z), sec(z), and csc(z) for lossy RF transmission-line stubs and waveguide impedances using exact conjugate denominator rationalization.
Read the guide →Math & EngineeringComplex Number & AC Phasor Math: Magnitude, Phase, Multiply & Divide
Model complex impedances and AC phasors a + bi in numeric Real and Imaginary columns to compute modulus (IMABS), phase angle in degrees (IMARGUMENT), complex multiplication (IMPRODUCT), and rationalized division (IMDIV).
Read the guide →EngineeringComplex Polar Powers, Square Roots, Exponentials, and Natural Logs (IMPOWER, IMSQRT, IMEXP & IMLN)
Compute numeric real and imaginary parts of z^n, sqrt(z), exp(z), and ln(z) using De Moivre's theorem and Euler's formula with ATAN2, COS, SIN, EXP, and LN.
Read the guide →Engineering & ScienceComposite Lamina Rule of Mixtures (Voigt / Reuss) & Halpin-Tsai Transverse Modulus
Calculate longitudinal stiffness E1 via the Voigt iso-strain rule of mixtures and transverse stiffness E2 via both the Reuss iso-stress lower bound and the semi-empirical Halpin-Tsai micromechanics equation.
Read the guide →Structural Steel Design, AISC 360 Composite Floor Beams & Shear StudsComposite Steel-Concrete Beam Shear Stud Count Formula
Calculate Governing Horizontal Interface Shear V_prime (kN) between Midspan & Support, Concrete Slab Compression Depth a (mm), Studs Required per Half-Span, and Total Full-Span Studs.
Read the guide →FinancialCompound interest formula: project lump-sum growth across any compounding frequency
Calculate ending balance P * (1 + r/m)^(m*t) and total interest earned for annual, quarterly, monthly, or daily compounding.
Read the guide →Logical & Conditional FormulasCompound Logic: IF Cell Is (X or Y) and Z (Nested AND + OR Rebate Gate)
Evaluate compound business eligibility rules—such as Tier is ("Gold" OR "Platinum") AND Status is "Active" AND Spend >= 1,000—without operator-precedence bugs.
Read the guide →