# Sheet Reserve

> Build budgets, bids and calculations from spreadsheet templates with working formulas. Preview sheets and sourced datasets before choosing a yearly membership. Membership $19.85 a year via Gumroad. Developed by Yunus Emre Vurgun (https://yunusemrevurgun.com).

Sheet Reserve is a library of 158 downloadable spreadsheets (146 templates with live formulas and 12 public datasets with named sources), plus 47 guides, 78 short answers and 15 free browser tools. Every sheet downloads as XLSX, CSV, ODS, XML (SpreadsheetML 2003) or Apple Numbers; the file is written in the visitor's browser, nothing is converted on a server. The two sample sheets are free with any account. Membership costs $19.85 a year and allows personal and commercial use of the files (resale of the files themselves is not allowed; see the license page).

When quoting this site, link to the canonical page URL. Dataset figures stay under their original licences (World Bank CC BY 4.0 and others); each dataset page and the data-sources page carry the citation to use. Content last updated 2026-10-18. Machine-readable copies: [full text of every guide and answer](https://sheetreserve.yunusemrevurgun.com/llms-full.txt), [JSON catalog](https://sheetreserve.yunusemrevurgun.com/catalog.json), [sitemap](https://sheetreserve.yunusemrevurgun.com/sitemap.xml), [RSS feed](https://sheetreserve.yunusemrevurgun.com/feed.xml).

## Topic hubs
- [Spreadsheet file formats and open datasets](https://sheetreserve.yunusemrevurgun.com/topics/spreadsheet-files-and-data): XLSX, CSV, ODS, XML and Numbers compared, plus the public datasets and guides on using them.
- [All sheets](https://sheetreserve.yunusemrevurgun.com/sheets): Every template and dataset in one list, with tab, row and formula counts.
- [Free spreadsheet tools](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools): 15 converters and data tools that run in the browser with no upload.
- [Engineering spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/engineering): Engineering calculation templates with live formulas: beams, pipe flow, electrical loads, tolerances and bills of materials.
- [Industrial engineering spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/industrial-engineering): Industrial engineering templates with live formulas: OEE, time studies, line balancing, EOQ and reorder points, and SPC control charts.
- [Sales engineering spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/sales-engineering): Sales engineering templates: customer ROI and payback, total cost of ownership, RFP compliance matrices, quote configurators and proof-of-concept trackers.
- [Architecture spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/architecture): Architecture templates for room and area schedules, door and window schedules, space programs, cost estimates and occupant loads.
- [Bidding spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/bidding): Bidding templates for contractors and owners: bid tabulation, subcontractor bid leveling, markup and margin, unit price bid schedules and bid/no-bid decisions.
- [Chemistry spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/chemistry): Chemistry lab templates: molar mass, solution and dilution prep, reaction stoichiometry and yield, buffer pH and Beer-Lambert calibration curves.
- [Finance spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/finance): Finance templates with real formulas: loan amortization, DCF valuation, monthly P&L, 13-week cash flow and portfolio tracking.
- [Accounting spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/accounting): Accounting templates: bank reconciliation, fixed asset depreciation, accounts receivable aging, trial balance to financial statements, and prepaid and accrual schedules.
- [Budgeting spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/budgeting): Budget templates for households, events, travel and debt payoff, each with budget-versus-actual tracking built in.
- [Management spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/management): Management templates: earned value project tracking, RACI matrices, OKR scoring, risk registers and team capacity planning.
- [Water spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/water): Open water datasets: freshwater withdrawals by country and sector, renewable water resources and water stress.
- [Spreadsheet skills spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/spreadsheet-skills): Worked spreadsheet examples for conditional totals, exact lookups, weighted averages, date formulas, text cleanup, and budget variance.
- [Weather & climate spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/climate): Weather and climate datasets: monthly temperature, precipitation, humidity, wind and solar radiation for world cities.
- [Economy spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/economy): Economic datasets from the World Bank: GDP, GDP per capita and growth by country and region.
- [Geography spreadsheet templates](https://sheetreserve.yunusemrevurgun.com/categories/geography): Geography datasets: every country with ISO codes, capital, region, coordinates, area and population.

## Sheets
- [13-week cash flow forecast](https://sheetreserve.yunusemrevurgun.com/sheets/13-week-cash-flow-forecast): Weekly receipts and disbursements for one quarter, with a revolver that draws and repays and a variance tab. (Finance template, updated 2026-10-08)
- [AVERAGEIFS conditional mean worked example](https://sheetreserve.yunusemrevurgun.com/sheets/averageifs-category-benchmark-example): Learn conditional averaging by computing unit price per order and using AVERAGEIFS to average order amounts for one selected category. (Spreadsheet skills template, updated 2026-10-13)
- [Accounts payable payment planner](https://sheetreserve.yunusemrevurgun.com/sheets/accounts-payable-payment-planner): List supplier bills with partial payments, remaining balances, and days until their due dates. (Accounting template, updated 2026-10-13)
- [Accounts receivable aging report with doubtful account allowance](https://sheetreserve.yunusemrevurgun.com/sheets/accounts-receivable-aging): Age open invoices into buckets by days past due, then estimate the allowance for doubtful accounts and DSO. (Accounting template, updated 2026-10-09)
- [Acid-base titration curve calculator](https://sheetreserve.yunusemrevurgun.com/sheets/titration-curve-calculator): pH at every titrant volume for a strong or weak acid titrated with NaOH, with equivalence, half-equivalence and an indicator check. (Chemistry template, updated 2026-10-09)
- [Action item tracker](https://sheetreserve.yunusemrevurgun.com/sheets/action-item-tracker): Keep action owners, due dates, completion dates, and overdue days in one working register. (Management template, updated 2026-10-13)
- [Annual budget planner, month by month](https://sheetreserve.yunusemrevurgun.com/sheets/annual-budget-planner): Twelve months of planned income and spending, with net and cumulative savings and a year-to-date tab. (Budgeting template, updated 2026-10-08)
- [Architectural fee and phase planner with timeline](https://sheetreserve.yunusemrevurgun.com/sheets/architectural-fee-phase-planner): Basic fee, phase split, staffing against each phase fee, a 60-week timeline and 15-month billing for one building project. (Architecture template, updated 2026-10-09)
- [Assembly line balancing calculator with takt time](https://sheetreserve.yunusemrevurgun.com/sheets/assembly-line-balancing): Takt time, station loading, line efficiency and balance delay for a task list with precedence. (Industrial engineering template, updated 2026-10-09)
- [Bank reconciliation template](https://sheetreserve.yunusemrevurgun.com/sheets/bank-reconciliation): Reconcile a bank statement to the general ledger with reconciling items, adjusted balances and journal entries. (Accounting template, updated 2026-10-09)
- [Beam deflection and bending calculator](https://sheetreserve.yunusemrevurgun.com/sheets/beam-deflection-calculator): Deflection, bending moment, shear and stress for simply supported and cantilever beams under point and uniform loads. (Engineering template, updated 2026-10-08)
- [Bid clarification register](https://sheetreserve.yunusemrevurgun.com/sheets/bid-clarification-register): Track tender questions, responsible reviewers, response deadlines, and reply dates before bid submission. (Bidding template, updated 2026-10-13)
- [Bid pipeline and win rate dashboard](https://sheetreserve.yunusemrevurgun.com/sheets/bid-pipeline-win-rate-dashboard): Bids submitted, won and lost, hit rates, weighted pipeline and margins by month, sector, estimator and bid size. (Bidding template, updated 2026-10-09)
- [Bid price build-up: overhead, profit, markup and margin](https://sheetreserve.yunusemrevurgun.com/sheets/bid-markup-calculator): Build a bid price from direct cost with job and home office overhead, contingency, profit, bond and insurance. (Bidding template, updated 2026-10-09)
- [Bid tabulation sheet for comparing contractor bids](https://sheetreserve.yunusemrevurgun.com/sheets/bid-tabulation): Unit prices, extended totals, unbalanced-line flags, responsiveness and ranking for competing contractor bids. (Bidding template, updated 2026-10-09)
- [Bid/no-bid decision matrix with expected value](https://sheetreserve.yunusemrevurgun.com/sheets/bid-no-bid-decision-matrix): Pass-or-fail gates, weighted scores, expected profit and a bid log with hit rates by sector. (Bidding template, updated 2026-10-09)
- [Bill of materials with cost roll-up](https://sheetreserve.yunusemrevurgun.com/sheets/bill-of-materials-cost-rollup): Multi-level bill of materials with extended quantities, supplier prices and cost roll-up by sub-assembly. (Engineering template, updated 2026-10-08)
- [Break-even analysis calculator](https://sheetreserve.yunusemrevurgun.com/sheets/break-even-analysis): Compare product prices, variable costs, fixed costs, and the units needed to cover those fixed costs. (Finance template, updated 2026-10-13)
- [Budget variance formula worked example](https://sheetreserve.yunusemrevurgun.com/sheets/budget-variance-formula-example): Learn amount and percentage variance formulas for an expense budget, with explicit treatment of a zero budget. (Spreadsheet skills template, updated 2026-10-13)
- [Buffer preparation calculator (Henderson-Hasselbalch)](https://sheetreserve.yunusemrevurgun.com/sheets/buffer-preparation-calculator): Acid and base form masses for a buffer at a target pH, from pKa values, with a titration route. (Chemistry template, updated 2026-10-09)
- [CO2 emissions and renewable energy by country, 2000-2024](https://sheetreserve.yunusemrevurgun.com/sheets/co2-emissions-and-renewable-energy-by-country): Total and per capita CO2 emissions, renewable energy share and electricity access for 217 economies, 2000-2024. (Weather & climate dataset, updated 2026-10-13)
- [COUNTIFS task summary worked example](https://sheetreserve.yunusemrevurgun.com/sheets/countifs-task-summary-example): Learn how to count records that satisfy both an owner criterion and an open-status criterion. (Spreadsheet skills template, updated 2026-10-13)
- [Calibration curve and unknown concentration calculator (Beer-Lambert)](https://sheetreserve.yunusemrevurgun.com/sheets/calibration-curve-beer-lambert): Least-squares calibration line, r squared, LOD and LOQ, and unknown concentrations from absorbance. (Chemistry template, updated 2026-10-09)
- [Cash conversion cycle worksheet](https://sheetreserve.yunusemrevurgun.com/sheets/cash-conversion-cycle): Calculate inventory days, receivable days, payable days, and the cash conversion cycle from consistent period totals. (Finance template, updated 2026-10-13)
- [Change order cost estimate](https://sheetreserve.yunusemrevurgun.com/sheets/change-order-cost-estimate): Build a change-order amount from labor hours, labor rate, materials, equipment, and an entered markup. (Bidding template, updated 2026-10-13)
- [Change request register](https://sheetreserve.yunusemrevurgun.com/sheets/change-request-register): Separate proposed cost changes from approved cost changes and track the effect on a project baseline. (Management template, updated 2026-10-13)
- [Competitive feature comparison matrix with Harvey balls](https://sheetreserve.yunusemrevurgun.com/sheets/competitive-feature-comparison-matrix): Score our product against four competitors on up to 80 weighted features, with Harvey balls, gap flags and ranked talk tracks. (Sales engineering template, updated 2026-10-09)
- [Concrete slab volume and bag estimator](https://sheetreserve.yunusemrevurgun.com/sheets/concrete-volume-and-bag-estimator): Calculate net concrete volume in cubic meters, waste-adjusted pour volume, and pre-mixed bag counts from rectangular dimensions. (Architecture template, updated 2026-10-13)
- [Construction RFI log](https://sheetreserve.yunusemrevurgun.com/sheets/construction-rfi-log): Track requests for information, expected response dates, actual responses, and turnaround time. (Architecture template, updated 2026-10-13)
- [Construction cost estimate by CSI division](https://sheetreserve.yunusemrevurgun.com/sheets/construction-cost-estimate): Preliminary cost estimate by CSI MasterFormat 2018 division, with general conditions, OH&P, contingency and escalation. (Architecture template, updated 2026-10-08)
- [Construction general conditions estimator](https://sheetreserve.yunusemrevurgun.com/sheets/general-conditions-preliminaries-estimator): Estimate time-related and fixed preliminary site costs from duration in weeks, weekly rates, mobilization, and removal fees. (Bidding template, updated 2026-10-13)
- [Construction punch list](https://sheetreserve.yunusemrevurgun.com/sheets/construction-punch-list): Record incomplete work, locations, responsible parties, due dates, and closure dates for site follow-up. (Architecture template, updated 2026-10-13)
- [Contractor payment and threshold tracker](https://sheetreserve.yunusemrevurgun.com/sheets/contractor-1099-payment-tracker): Record contractor service payments, reimbursed expenses, backup withholding, and amounts exceeding a reporting threshold. (Accounting template, updated 2026-10-13)
- [Customer LTV and CAC payback calculator](https://sheetreserve.yunusemrevurgun.com/sheets/customer-unit-economics-calculator): Estimate monthly gross profit per customer, customer lifetime value, LTV-to-CAC ratio, and payback period by segment. (Finance template, updated 2026-10-13)
- [Customer ROI and payback calculator for a technical sale](https://sheetreserve.yunusemrevurgun.com/sheets/customer-roi-calculator): Three-year ROI, NPV, IRR and payback from one-time and recurring costs, benefits and an adoption ramp. (Sales engineering template, updated 2026-10-09)
- [Date and deadline formula example](https://sheetreserve.yunusemrevurgun.com/sheets/date-deadline-formula-example): Learn calendar-date subtraction and completion-aware overdue formulas using a fixed review date. (Spreadsheet skills template, updated 2026-10-13)
- [Debt payoff planner (avalanche and snowball)](https://sheetreserve.yunusemrevurgun.com/sheets/debt-payoff-planner): Compare avalanche and snowball payoff for up to six debts, with a month-by-month schedule for each. (Budgeting template, updated 2026-10-08)
- [Debt service coverage ratio calculator](https://sheetreserve.yunusemrevurgun.com/sheets/debt-service-coverage-calculator): Compare net operating income with annual principal and interest obligations to measure debt service coverage and cash cushion. (Finance template, updated 2026-10-13)
- [Decision and review log](https://sheetreserve.yunusemrevurgun.com/sheets/decision-review-log): Record project decisions, decision owners, planned review dates, and review completion dates. (Management template, updated 2026-10-13)
- [Deferred revenue recognition schedule](https://sheetreserve.yunusemrevurgun.com/sheets/deferred-revenue-recognition-schedule): Track upfront customer billings, service period length, elapsed months, recognized revenue, and remaining deferred balances. (Accounting template, updated 2026-10-13)
- [Discounted cash flow (DCF) valuation model](https://sheetreserve.yunusemrevurgun.com/sheets/dcf-valuation-model): Five-year free cash flow, WACC build-up, terminal value by two methods and a sensitivity grid. (Finance template, updated 2026-10-08)
- [Door and window schedule](https://sheetreserve.yunusemrevurgun.com/sheets/door-window-schedule): Door and window schedules with types, fire ratings, glazed areas and counts by type and level. (Architecture template, updated 2026-10-08)
- [Drinking water and sanitation access by country, 2000-2024](https://sheetreserve.yunusemrevurgun.com/sheets/drinking-water-and-sanitation-access-by-country): Safely managed and basic drinking water, sanitation and handwashing shares for 217 economies, 2000-2024, from the World Bank. (Water dataset, updated 2026-10-09)
- [EOQ, safety stock and reorder point calculator](https://sheetreserve.yunusemrevurgun.com/sheets/eoq-reorder-point-calculator): Economic order quantity, safety stock, reorder point and annual inventory cost for each SKU. (Industrial engineering template, updated 2026-10-09)
- [Earned value management (EVM) project tracker](https://sheetreserve.yunusemrevurgun.com/sheets/earned-value-management-tracker): Track a project's schedule and cost with planned value, earned value, SPI, CPI and an estimate at completion. (Management template, updated 2026-10-09)
- [Education savings goal and gap planner](https://sheetreserve.yunusemrevurgun.com/sheets/college-and-education-savings-planner): Calculate the remaining funding gap, required monthly contribution, and monthly surplus or shortfall for education cost targets. (Budgeting template, updated 2026-10-13)
- [Electrical energy and cost calculator](https://sheetreserve.yunusemrevurgun.com/sheets/electrical-energy-cost): Estimate daily and monthly energy use from appliance input power, operating hours, days, and an entered tariff. (Engineering template, updated 2026-10-13)
- [Electrical panel load schedule](https://sheetreserve.yunusemrevurgun.com/sheets/electrical-panel-load-schedule): A 42-circuit 208Y/120 V panel schedule with phase totals, NEC 220.44 receptacle demand and current. (Engineering template, updated 2026-10-08)
- [Emergency fund target and coverage planner](https://sheetreserve.yunusemrevurgun.com/sheets/emergency-fund-coverage-planner): Compare current liquid reserves with monthly essential expenses across categories to measure months covered and remaining gap. (Budgeting template, updated 2026-10-13)
- [Engineering unit conversion worksheet](https://sheetreserve.yunusemrevurgun.com/sheets/engineering-unit-conversions): Convert lengths, volumes, and temperatures using explicitly entered scale and offset factors. (Engineering template, updated 2026-10-13)
- [Equipment rental quote comparison](https://sheetreserve.yunusemrevurgun.com/sheets/equipment-rental-comparison): Compare equipment rental offers including charged days, daily rates, delivery, and collection fees. (Bidding template, updated 2026-10-13)
- [Event and wedding budget planner](https://sheetreserve.yunusemrevurgun.com/sheets/event-budget-planner): Per-guest and fixed costs, committed amounts, deposits, payment status and a contingency for an event. (Budgeting template, updated 2026-10-08)
- [Expense reimbursement log](https://sheetreserve.yunusemrevurgun.com/sheets/expense-reimbursement-log): Record employee expenses, approved amounts, reimbursements paid, and the balance still owed. (Accounting template, updated 2026-10-13)
- [Financial ratio analysis dashboard (three years)](https://sheetreserve.yunusemrevurgun.com/sheets/financial-ratio-analysis): Twenty ratios for three fiscal years with trends, targets, a DuPont breakdown and a scorecard, for an example distributor. (Accounting template, updated 2026-10-09)
- [First-pass yield and rework tracker](https://sheetreserve.yunusemrevurgun.com/sheets/first-pass-yield-rolled-throughput): Compare units passing initial inspection with reworked units and scrap to calculate first-pass yield and total station yield. (Industrial engineering template, updated 2026-10-13)
- [Fixed asset register and depreciation schedule](https://sheetreserve.yunusemrevurgun.com/sheets/fixed-asset-depreciation-schedule): Straight-line, declining balance and sum-of-the-years'-digits depreciation for each asset, by fiscal year. (Accounting template, updated 2026-10-09)
- [Fixed-rate loan comparison](https://sheetreserve.yunusemrevurgun.com/sheets/fixed-rate-loan-comparison): Compare monthly payments and total interest across fixed-rate loan offers with different rates, terms, and upfront fees. (Finance template, updated 2026-10-13)
- [Forest area, agricultural land and arable land by country, 2000-2024](https://sheetreserve.yunusemrevurgun.com/sheets/forest-and-agricultural-land-by-country): Forest cover (% and sq. km), agricultural land share and arable land share for 217 economies, 2000-2024. (Geography dataset, updated 2026-10-13)
- [Freshwater withdrawals by country](https://sheetreserve.yunusemrevurgun.com/sheets/freshwater-withdrawals-by-country): Freshwater withdrawals by sector, renewable resources and water stress for 186 countries, from the World Bank and FAO AQUASTAT. (Water dataset, updated 2026-10-08)
- [GDP by country, 1990-2025](https://sheetreserve.yunusemrevurgun.com/sheets/gdp-by-country): GDP, GDP per capita and growth for 217 countries and territories, 1990-2025, from the World Bank. (Economy dataset, updated 2026-10-08)
- [Global temperature anomalies, 1880-2025 (NASA GISTEMP v4)](https://sheetreserve.yunusemrevurgun.com/sheets/global-temperature-anomalies-nasa-gistemp): Monthly, annual, hemispheric and zonal global temperature anomalies from NASA GISTEMP, 1880-2025, with warming stripes. (Weather & climate dataset, updated 2026-10-09)
- [Gravimetric moisture and solids worksheet](https://sheetreserve.yunusemrevurgun.com/sheets/gravimetric-moisture-loss-on-drying): Calculate wet sample mass, dry sample mass, water mass lost, and wet-basis moisture percentage from tare, wet, and dry weighings. (Chemistry template, updated 2026-10-13)
- [Grocery unit price comparison](https://sheetreserve.yunusemrevurgun.com/sheets/grocery-unit-price-comparison): Compare pack prices on a common quantity basis and estimate the cost of the amount you actually need. (Budgeting template, updated 2026-10-13)
- [Hiring requisition and time-to-fill log](https://sheetreserve.yunusemrevurgun.com/sheets/hiring-requisition-pipeline-tracker): Track open hiring requisitions, target fill dates, offer acceptance dates, elapsed days open, and days past target. (Management template, updated 2026-10-13)
- [Home renovation budget tracker](https://sheetreserve.yunusemrevurgun.com/sheets/home-renovation-budget): Track renovation allowances, committed quotes, actual spending, and the remaining allowance for each work package. (Budgeting template, updated 2026-10-13)
- [INDEX MATCH price lookup example](https://sheetreserve.yunusemrevurgun.com/sheets/index-match-price-lookup-example): Learn exact-match lookup by retrieving a price from a small product table using a selected SKU. (Spreadsheet skills template, updated 2026-10-13)
- [Implementation effort estimate](https://sheetreserve.yunusemrevurgun.com/sheets/implementation-effort-estimate): Estimate delivery effort and cost by workstream using quantity, hours per unit, hourly rate, and contingency. (Sales engineering template, updated 2026-10-13)
- [Inflation by country, 1990-2025 (consumer prices and GDP deflator)](https://sheetreserve.yunusemrevurgun.com/sheets/inflation-by-country): Consumer price and GDP deflator inflation for 217 economies, 1990-2025, from the World Bank, with decade averages and latest-year rankings. (Economy dataset, updated 2026-10-09)
- [Inventory cycle count variance](https://sheetreserve.yunusemrevurgun.com/sheets/inventory-cycle-count): Compare book inventory with a physical count and translate quantity differences into cost differences. (Industrial engineering template, updated 2026-10-13)
- [Inventory stock and reorder tracker](https://sheetreserve.yunusemrevurgun.com/sheets/inventory-stock-tracker): Roll stock balances forward from opening units, receipts, and issues, then compare closing stock with a minimum and target. (Industrial engineering template, updated 2026-10-13)
- [Investment portfolio tracker](https://sheetreserve.yunusemrevurgun.com/sheets/investment-portfolio-tracker): Holdings, cost basis, allocation against target weights, rebalancing amounts and dividend income. (Finance template, updated 2026-10-08)
- [Invoice payment tracker](https://sheetreserve.yunusemrevurgun.com/sheets/invoice-payment-tracker): Track issued invoices, payments received, outstanding balances, and overdue days at a fixed review date. (Accounting template, updated 2026-10-13)
- [Kanban container and card calculator](https://sheetreserve.yunusemrevurgun.com/sheets/kanban-card-and-container-calculator): Size a pull replenishment loop by calculating lead-time demand, safety-buffered demand, and required kanban containers. (Industrial engineering template, updated 2026-10-13)
- [Laboratory stock and expiry register](https://sheetreserve.yunusemrevurgun.com/sheets/laboratory-stock-register): Track labeled laboratory stocks, remaining quantities, expiry dates, and days to expiry at a fixed review date. (Chemistry template, updated 2026-10-13)
- [Lead qualification scorecard](https://sheetreserve.yunusemrevurgun.com/sheets/lead-qualification-scorecard): Compare leads using explicit fit, need, timing, and access scores without hiding the scoring basis. (Sales engineering template, updated 2026-10-13)
- [Linear thermal expansion calculator](https://sheetreserve.yunusemrevurgun.com/sheets/linear-thermal-expansion): Estimate length change from original length, temperature change, and a supplied linear expansion coefficient. (Engineering template, updated 2026-10-13)
- [Loaded labor rate estimator](https://sheetreserve.yunusemrevurgun.com/sheets/loaded-labor-rate-estimator): Estimate a loaded hourly labor rate from base pay, entered burden percentage, fixed hourly benefits, and productive hours. (Bidding template, updated 2026-10-13)
- [Loan amortization schedule](https://sheetreserve.yunusemrevurgun.com/sheets/loan-amortization-schedule): Monthly payment, interest and principal for every period of a fixed-rate loan, with optional extra payments. (Finance template, updated 2026-10-08)
- [Mass percent solution calculator](https://sheetreserve.yunusemrevurgun.com/sheets/mass-percent-solution): Calculate mass percent concentration from solute and solvent masses without assuming a solution volume. (Chemistry template, updated 2026-10-13)
- [Material quantity takeoff](https://sheetreserve.yunusemrevurgun.com/sheets/material-quantity-takeoff): Calculate rectangular surface quantities, waste allowances, and material costs from count, length, and width inputs. (Architecture template, updated 2026-10-13)
- [Meeting duration and participant cost](https://sheetreserve.yunusemrevurgun.com/sheets/meeting-cost-and-time-calculator): Estimate person-hours per session, single-session cost, and monthly recurring cost from attendee count, duration, and loaded hourly rates. (Management template, updated 2026-10-13)
- [Mileage reimbursement tracker](https://sheetreserve.yunusemrevurgun.com/sheets/mileage-reimbursement-tracker): Calculate trip distance, business miles, and reimbursement using the rate entered for each trip. (Accounting template, updated 2026-10-13)
- [Min-max normalization formula example](https://sheetreserve.yunusemrevurgun.com/sheets/min-max-normalization-formula-example): Learn how to clamp raw observations between lower and upper bounds and normalize them onto a zero-to-one hundred percent scale. (Spreadsheet skills template, updated 2026-10-13)
- [Molar mass calculator from a chemical formula](https://sheetreserve.yunusemrevurgun.com/sheets/molar-mass-calculator): Molar mass of a compound from its element counts, with mass percent and a grams-to-moles converter. (Chemistry template, updated 2026-10-09)
- [Molarity and solute mass calculator](https://sheetreserve.yunusemrevurgun.com/sheets/molarity-and-solution-mass-calculator): Calculate solution volume in liters, required solute moles, and weighed solute mass in grams from molar mass and target molarity. (Chemistry template, updated 2026-10-13)
- [Monthly household budget (budget vs actual)](https://sheetreserve.yunusemrevurgun.com/sheets/monthly-household-budget): Budget and actual spending by category, the difference for each line and a 50/30/20 check. (Budgeting template, updated 2026-10-08)
- [Monthly profit and loss statement](https://sheetreserve.yunusemrevurgun.com/sheets/monthly-profit-and-loss): Twelve months of revenue, cost of goods sold, operating expenses, EBITDA, net income and margins. (Finance template, updated 2026-10-08)
- [Monthly recurring revenue bridge](https://sheetreserve.yunusemrevurgun.com/sheets/recurring-revenue-bridge): Reconcile opening monthly recurring revenue with new, expansion, contraction, and churn amounts. (Sales engineering template, updated 2026-10-13)
- [Monthly weather for 60 world cities, 2025](https://sheetreserve.yunusemrevurgun.com/sheets/world-cities-monthly-weather-2025): Temperature, precipitation, humidity, wind and solar radiation for 60 cities, month by month, from NASA POWER. (Weather & climate dataset, updated 2026-10-08)
- [OEE calculator by shift (availability, performance, quality)](https://sheetreserve.yunusemrevurgun.com/sheets/oee-calculator): Overall equipment effectiveness for each machine and shift, from planned time, stops, cycle time and rejects. (Industrial engineering template, updated 2026-10-09)
- [OKR scorecard with weighted key result grading](https://sheetreserve.yunusemrevurgun.com/sheets/okr-scorecard): Grade each key result from its start value to its target, roll up objective scores and track weekly check-ins for a quarter. (Management template, updated 2026-10-09)
- [Occupant load and egress width calculator](https://sheetreserve.yunusemrevurgun.com/sheets/occupant-load-egress-calculator): IBC 2021 occupant load by space, exits required and egress widths checked level by level. (Architecture template, updated 2026-10-08)
- [Pareto analysis of defects (80/20 chart)](https://sheetreserve.yunusemrevurgun.com/sheets/defect-pareto-analysis): Ranks defect categories by count and by cost, flags the vital few and tracks them by line and week. (Industrial engineering template, updated 2026-10-09)
- [Parking lot stall and area estimator](https://sheetreserve.yunusemrevurgun.com/sheets/parking-lot-stall-and-aisle-estimator): Estimate net stall area, total parking stalls, and accessible stall counts from gross lot area and planning allowances. (Architecture template, updated 2026-10-13)
- [Paycheck budget planner](https://sheetreserve.yunusemrevurgun.com/sheets/paycheck-budget-planner): Allocate each paycheck to bills, living expenses, savings, and debt, then inspect the amount left over. (Budgeting template, updated 2026-10-13)
- [Petty cash reconciliation](https://sheetreserve.yunusemrevurgun.com/sheets/petty-cash-reconciliation): Reconcile petty cash by denomination, comparing expected cash with a physical count and recording the variance. (Accounting template, updated 2026-10-13)
- [Pipe pressure drop calculator (Darcy-Weisbach)](https://sheetreserve.yunusemrevurgun.com/sheets/pipe-pressure-drop-calculator): Darcy-Weisbach head loss and pressure drop for water in straight pipe, with fittings and a diameter comparison. (Engineering template, updated 2026-10-08)
- [Prepaid expense and accrual amortization schedule](https://sheetreserve.yunusemrevurgun.com/sheets/prepaid-and-accrual-schedule): Amortize prepaid expenses by month and track accrual reversals against a close month. (Accounting template, updated 2026-10-09)
- [Preventive maintenance schedule](https://sheetreserve.yunusemrevurgun.com/sheets/preventive-maintenance-schedule): Track calendar-based maintenance from the last service date and a manually specified interval. (Industrial engineering template, updated 2026-10-13)
- [Pricing and gross margin calculator](https://sheetreserve.yunusemrevurgun.com/sheets/pricing-margin-calculator): Set a selling price from unit cost and target gross margin, then compare markup with margin. (Finance template, updated 2026-10-13)
- [Production capacity plan](https://sheetreserve.yunusemrevurgun.com/sheets/production-capacity-plan): Compare required production hours with available line hours for orders using an entered cycle time. (Industrial engineering template, updated 2026-10-13)
- [Progress billing and retainage tracker](https://sheetreserve.yunusemrevurgun.com/sheets/retainage-and-progress-billing-tracker): Calculate work earned to date, retainage withheld, and current net payment due across schedule-of-values line items. (Bidding template, updated 2026-10-13)
- [Project Gantt chart with dependencies and milestones](https://sheetreserve.yunusemrevurgun.com/sheets/project-gantt-chart): Task schedule with predecessors, lags and milestones, and a weekly Gantt that moves when dates or progress change. (Management template, updated 2026-10-09)
- [Project issue log](https://sheetreserve.yunusemrevurgun.com/sheets/project-issue-log): Track active project issues with owners, opened dates, target dates, and an explicit resolution date. (Management template, updated 2026-10-13)
- [Project milestone tracker](https://sheetreserve.yunusemrevurgun.com/sheets/project-milestone-tracker): Compare baseline milestone dates with current forecasts and actual completion dates. (Management template, updated 2026-10-13)
- [Project profitability tracker](https://sheetreserve.yunusemrevurgun.com/sheets/project-profitability-tracker): Compare project revenue with direct labor, materials, and allocated overhead to estimate contribution and margin. (Finance template, updated 2026-10-13)
- [Proof of concept (POC) success criteria tracker](https://sheetreserve.yunusemrevurgun.com/sheets/poc-success-criteria-tracker): Score POC criteria as met or not met against targets, with weighted results, must-haves, milestones and a recommendation. (Sales engineering template, updated 2026-10-09)
- [Pump hydraulic power calculator](https://sheetreserve.yunusemrevurgun.com/sheets/pump-hydraulic-power): Estimate hydraulic and electrical input power from flow, total head, fluid density, and combined efficiency. (Engineering template, updated 2026-10-13)
- [RACI matrix template with gap and overlap checks](https://sheetreserve.yunusemrevurgun.com/sheets/raci-matrix): Assign Responsible, Accountable, Consulted and Informed roles to each task, and flag tasks with a missing or doubled Accountable. (Management template, updated 2026-10-09)
- [RFP compliance matrix with weighted scoring](https://sheetreserve.yunusemrevurgun.com/sheets/rfp-compliance-matrix): Score each RFP requirement by priority and compliance level, with weighted compliance by section and status. (Sales engineering template, updated 2026-10-09)
- [Reaction percent yield worksheet](https://sheetreserve.yunusemrevurgun.com/sheets/reaction-percent-yield): Compare theoretical product mass with measured product mass and account for entered purity. (Chemistry template, updated 2026-10-13)
- [Reaction stoichiometry and limiting reagent calculator](https://sheetreserve.yunusemrevurgun.com/sheets/stoichiometry-limiting-reagent): Limiting reagent, theoretical and percent yield, excess reagent left and reactant masses for a scale-up. (Chemistry template, updated 2026-10-09)
- [Retirement savings projection: contributions, growth and withdrawals](https://sheetreserve.yunusemrevurgun.com/sheets/retirement-savings-projection): Year-by-year balance from saving to retirement and withdrawals, with five return and saving scenarios. (Finance template, updated 2026-10-09)
- [Risk register with probability and impact scoring](https://sheetreserve.yunusemrevurgun.com/sheets/risk-register): Score each project risk by probability and impact, track its response and residual score, and see open risks on a heat map. (Management template, updated 2026-10-09)
- [Room and area schedule](https://sheetreserve.yunusemrevurgun.com/sheets/room-area-schedule): Room list for a two-level building with areas in m² and ft², volume, finishes and totals by level and department. (Architecture template, updated 2026-10-08)
- [SUMIFS sales summary worked example](https://sheetreserve.yunusemrevurgun.com/sheets/sumifs-sales-summary-example): Learn conditional summation by calculating order amounts and a sales total for one selected region. (Spreadsheet skills template, updated 2026-10-13)
- [Sales pipeline weighted forecast](https://sheetreserve.yunusemrevurgun.com/sheets/sales-pipeline-weighted-forecast): Compare open opportunity amounts with user-assigned win probabilities and days to the target close date. (Sales engineering template, updated 2026-10-13)
- [Sales quota and commission accelerator](https://sheetreserve.yunusemrevurgun.com/sheets/sales-commission-and-quota-accelerator): Calculate quota attainment, base commission up to quota, accelerated commission above quota, and total variable payout. (Sales engineering template, updated 2026-10-13)
- [Sales tax reconciliation worksheet](https://sheetreserve.yunusemrevurgun.com/sheets/sales-tax-reconciliation): Compare a manually calculated sales tax amount with tax actually collected on each sales batch. (Accounting template, updated 2026-10-13)
- [Savings goals tracker with progress bars](https://sheetreserve.yunusemrevurgun.com/sheets/savings-goals-tracker): Eight savings goals with progress bars, the monthly amount each needs, on-track status and 24-month projections. (Budgeting template, updated 2026-10-09)
- [Scrap and rework cost tracker](https://sheetreserve.yunusemrevurgun.com/sheets/scrap-cost-tracker): Measure scrap share and the direct cost of scrapped units and rework hours by production batch. (Industrial engineering template, updated 2026-10-13)
- [Sensible airflow heat load calculator](https://sheetreserve.yunusemrevurgun.com/sheets/hvac-sensible-heat-load-calculator): Calculate air mass flow rate and sensible heating or cooling load in kilowatts from volumetric airflow and air temperatures. (Engineering template, updated 2026-10-13)
- [Serial dilution planner](https://sheetreserve.yunusemrevurgun.com/sheets/serial-dilution-planner): Calculate the concentration after each specified dilution step using transfer and diluent volumes. (Chemistry template, updated 2026-10-13)
- [Single-phase voltage drop calculator](https://sheetreserve.yunusemrevurgun.com/sheets/voltage-drop-calculator): Estimate two-wire loop resistance, voltage drop, percentage drop, and load voltage from current, one-way distance, and conductor resistance. (Engineering template, updated 2026-10-13)
- [Sinking fund savings planner](https://sheetreserve.yunusemrevurgun.com/sheets/sinking-fund-planner): Plan contributions for upcoming expenses using the target, current balance, and number of months left. (Budgeting template, updated 2026-10-13)
- [Software deal discount and margin calculator](https://sheetreserve.yunusemrevurgun.com/sheets/saas-tier-discount-and-margin-calculator): Compare list annual contract value, discounted net annual value, direct hosting and support cost, and deal gross margin. (Sales engineering template, updated 2026-10-13)
- [Solar PV system sizing calculator with monthly production](https://sheetreserve.yunusemrevurgun.com/sheets/solar-pv-system-sizing-calculator): Panel count, system size, monthly production against use, bill savings, payback and 25 years of output. (Engineering template, updated 2026-10-09)
- [Solution preparation and serial dilution calculator](https://sheetreserve.yunusemrevurgun.com/sheets/solution-dilution-calculator): Mass to weigh, stock and diluent volumes, unit conversions and serial dilution tables for lab solutions. (Chemistry template, updated 2026-10-09)
- [Solution quote configurator with discounts and margin](https://sheetreserve.yunusemrevurgun.com/sheets/quote-configurator): Price a configured solution from a parts list, with line discounts, approval flags, sales tax, margin and lead time. (Sales engineering template, updated 2026-10-09)
- [Space program calculator (net to gross)](https://sheetreserve.yunusemrevurgun.com/sheets/space-program-calculator): Converts a space program into net, department gross and building gross areas, with summary percentages. (Architecture template, updated 2026-10-08)
- [Stakeholder engagement register](https://sheetreserve.yunusemrevurgun.com/sheets/stakeholder-engagement-register): Record stakeholder ownership, last contact, desired contact interval, and the next contact date. (Management template, updated 2026-10-13)
- [Startup cash runway planner](https://sheetreserve.yunusemrevurgun.com/sheets/startup-runway-planner): Estimate monthly net cash burn and cash runway for operating scenarios with specified cash, receipts, and payments. (Finance template, updated 2026-10-13)
- [Subcontractor bid leveling sheet](https://sheetreserve.yunusemrevurgun.com/sheets/subcontractor-bid-leveling): Level subcontractor bids for scope gaps: each excluded or qualified item adds its plug value to the base bid. (Bidding template, updated 2026-10-09)
- [Submittal review register](https://sheetreserve.yunusemrevurgun.com/sheets/submittal-review-register): Track material and shop-drawing submissions with revision numbers, review deadlines, and returned dates. (Architecture template, updated 2026-10-13)
- [Subscription cost tracker](https://sheetreserve.yunusemrevurgun.com/sheets/subscription-cost-tracker): Compare subscription prices paid at different intervals on monthly and annual equivalent cost bases. (Budgeting template, updated 2026-10-13)
- [Supplier delivery and quality scorecard](https://sheetreserve.yunusemrevurgun.com/sheets/supplier-delivery-scorecard): Compare supplier delivery reliability and accepted-unit quality using counts from the same review period. (Industrial engineering template, updated 2026-10-13)
- [Team capacity planner by week](https://sheetreserve.yunusemrevurgun.com/sheets/team-capacity-planner): Compare each person's weekly available hours with planned hours by project, and flag over- and under-allocation. (Management template, updated 2026-10-09)
- [Text cleanup formula worked example](https://sheetreserve.yunusemrevurgun.com/sheets/text-cleanup-formula-example): Learn TRIM, UPPER, LOWER, and LEN by preparing names and reference codes while preserving the original text. (Spreadsheet skills template, updated 2026-10-13)
- [Three-way PO and invoice match](https://sheetreserve.yunusemrevurgun.com/sheets/three-way-invoice-match-worksheet): Compare purchase order quantities and unit prices with goods receipt quantities and billed invoice amounts. (Accounting template, updated 2026-10-13)
- [Time study calculator: observed, normal and standard time](https://sheetreserve.yunusemrevurgun.com/sheets/time-study-standard-time): Turns stopwatch readings into normal and standard times, with the cycles needed for a set accuracy. (Industrial engineering template, updated 2026-10-09)
- [Tolerance stack-up analysis (worst case and RSS)](https://sheetreserve.yunusemrevurgun.com/sheets/tolerance-stack-up-analysis): Worst-case and root-sum-square tolerance analysis for a chain of up to 15 dimensions, with pass or fail. (Engineering template, updated 2026-10-08)
- [Total cost of ownership (TCO) comparison for three options](https://sheetreserve.yunusemrevurgun.com/sheets/total-cost-of-ownership-comparison): Five-year cost by year, NPV, cost per user per month and rank for three options, with escalation and risk. (Sales engineering template, updated 2026-10-09)
- [Trade, exports, imports and current account by country, 2000-2025](https://sheetreserve.yunusemrevurgun.com/sheets/trade-and-exports-by-country): Merchandise and services trade, exports, imports and current account balance (% of GDP) for 217 economies, 2000-2025. (Economy dataset, updated 2026-10-13)
- [Training completion matrix](https://sheetreserve.yunusemrevurgun.com/sheets/training-completion-matrix): Compare assigned training hours with completed hours for each employee and course. (Management template, updated 2026-10-13)
- [Travel budget planner with currency conversion](https://sheetreserve.yunusemrevurgun.com/sheets/travel-budget-planner): Trip budget by category in USD, with expenses logged in local currencies and converted with a rate table. (Budgeting template, updated 2026-10-08)
- [Trial balance to income statement and balance sheet](https://sheetreserve.yunusemrevurgun.com/sheets/trial-balance-to-financial-statements): Map a trial balance to an income statement and balance sheet, with checks that the books balance. (Accounting template, updated 2026-10-09)
- [Unit price bid schedule with alternates](https://sheetreserve.yunusemrevurgun.com/sheets/unit-price-bid-schedule): Base bid by section, with allowances, contingency, add and deduct alternates and a total contract amount. (Bidding template, updated 2026-10-09)
- [Urban and rural drinking water and sanitation by country, 2000-2024](https://sheetreserve.yunusemrevurgun.com/sheets/urban-and-rural-water-and-sanitation-by-country): Urban and rural shares of population with at least basic drinking water and sanitation across 217 economies, 2000-2024. (Water dataset, updated 2026-10-13)
- [VLOOKUP exact-match worked example](https://sheetreserve.yunusemrevurgun.com/sheets/vlookup-exact-match-example): Learn exact VLOOKUP by retrieving a department allowance from a keyed table with missing and duplicate-key checks. (Spreadsheet skills template, updated 2026-10-13)
- [Vendor contract renewal and notice tracker](https://sheetreserve.yunusemrevurgun.com/sheets/vendor-contract-renewal-register): Track supplier renewal dates, required cancellation notice periods, notice cutoff dates, and days remaining before notice is due. (Management template, updated 2026-10-13)
- [Warehouse pallet and bin utilization](https://sheetreserve.yunusemrevurgun.com/sheets/warehouse-bin-utilization-calculator): Calculate total pallet positions, remaining open capacity, and storage utilization across warehouse aisles or zones. (Industrial engineering template, updated 2026-10-13)
- [Weekly timesheet and billable hours](https://sheetreserve.yunusemrevurgun.com/sheets/weekly-timesheet): Total daily hours by person and project, separating billable hours through an explicit input flag. (Management template, updated 2026-10-13)
- [Weighted average formula example](https://sheetreserve.yunusemrevurgun.com/sheets/weighted-average-formula-example): Learn weighted averages by calculating each observation’s value times its weight and dividing the total by total weight. (Spreadsheet skills template, updated 2026-10-13)
- [Working capital and liquidity calculator](https://sheetreserve.yunusemrevurgun.com/sheets/working-capital-ratio-calculator): Calculate current assets, net working capital, current ratio, and quick ratio across periods or operating units. (Finance template, updated 2026-10-13)
- [World cities with population and coordinates (Natural Earth)](https://sheetreserve.yunusemrevurgun.com/sheets/world-cities-population-natural-earth): 7,342 populated places with coordinates, Natural Earth population estimates, capitals and World Bank regions. (Geography dataset, updated 2026-10-09)
- [World countries: codes, capitals, area and population](https://sheetreserve.yunusemrevurgun.com/sheets/world-countries-geography): 217 countries and territories with ISO codes, capitals, area, population, region and income level. (Geography dataset, updated 2026-10-08)
- [X-bar and R control chart calculator (SPC)](https://sheetreserve.yunusemrevurgun.com/sheets/spc-xbar-r-control-chart): Control limits, sigma estimate, Cp and Cpk, and out-of-control flags for subgroup measurements. (Industrial engineering template, updated 2026-10-09)
- [Zero-based monthly budget](https://sheetreserve.yunusemrevurgun.com/sheets/zero-based-budget): Assign monthly income to spending, savings, and debt categories, then compare each allocation with actual spending. (Budgeting template, updated 2026-10-13)

## Articles
- [Subscription cost tracker: find what each plan costs a year](https://sheetreserve.yunusemrevurgun.com/blog/subscription-cost-tracker-spreadsheet): Turn each subscription into a monthly equivalent and an annual cost, measure the unused share, and total the list with formulas you can check.
- [Zero-based budget spreadsheet: give every dollar a job](https://sheetreserve.yunusemrevurgun.com/blog/zero-based-budget-spreadsheet): Plan each dollar of monthly income before the month starts, check that the plan adds up to zero, and read what each line has left over after spending.
- [Concrete volume and bag count for slabs, pads and footings](https://sheetreserve.yunusemrevurgun.com/blog/concrete-volume-and-bag-count-spreadsheet): Calculate net concrete volume in cubic meters, add a waste allowance and convert to bags with worked examples for a pad, a walkway slab and strip footings.
- [Customer LTV, CAC and payback months in a spreadsheet](https://sheetreserve.yunusemrevurgun.com/blog/ltv-cac-payback-unit-economics-spreadsheet): Work out monthly gross profit per customer, lifetime value, the LTV to CAC ratio and CAC payback months with formulas, a worked example and clear limits.
- [Debt service coverage ratio: formula and a three-case example](https://sheetreserve.yunusemrevurgun.com/blog/debt-service-coverage-ratio-worked-example): Calculate net operating income, annual debt service and the DSCR in a spreadsheet, then stress the result with a vacancy case and a refinance case.
- [Deferred revenue schedule: straight-line recognition by month](https://sheetreserve.yunusemrevurgun.com/blog/deferred-revenue-straight-line-schedule): Build a deferred revenue schedule that splits an upfront billing into recognized revenue and a remaining liability, with monthly formulas and a worked example.
- [First-pass yield and rolled throughput yield, worked by station](https://sheetreserve.yunusemrevurgun.com/blog/first-pass-yield-rolled-throughput-yield): Calculate first-pass yield, final good units and rolled throughput yield across three stations, and see why rework hides losses that station yield shows.
- [How many kanban cards do you need? A formula and example](https://sheetreserve.yunusemrevurgun.com/blog/kanban-card-count-formula-spreadsheet): Size a kanban loop in a spreadsheet: lead-time demand, a safety factor and container size give the number of cards, shown with three worked parts.
- [Progress billing and retainage: calculating the payment due](https://sheetreserve.yunusemrevurgun.com/blog/progress-billing-retainage-calculation): Calculate earned value, retainage held and the current payment due per schedule-of-values line, with a three-line worked example and common pitfalls.
- [Sensible heat load from airflow: the kilowatt formula](https://sheetreserve.yunusemrevurgun.com/blog/sensible-heat-load-airflow-kilowatts): Convert airflow and supply-to-return temperature difference into mass flow and sensible heating or cooling load in kilowatts, with three worked zones.
- [Voltage drop in a single-phase circuit: formula and examples](https://sheetreserve.yunusemrevurgun.com/blog/voltage-drop-single-phase-circuit-example): Calculate loop resistance, voltage drop, percent drop and load voltage for a single-phase circuit from current, length and conductor resistance.
- [Working capital, current ratio and quick ratio: a worked example](https://sheetreserve.yunusemrevurgun.com/blog/working-capital-current-ratio-quick-ratio-example): Calculate net working capital, the current ratio and the quick ratio from balance-sheet inputs, with a worked three-quarter example and its limits.
- [Action, issue and milestone trackers: dates that work](https://sheetreserve.yunusemrevurgun.com/blog/action-issue-milestone-trackers): Choose an action, issue, or milestone tracker and calculate overdue days, issue age, and baseline delay using explicit dates and completion-aware formulas.
- [Break-even units and target margin: a worked example](https://sheetreserve.yunusemrevurgun.com/blog/break-even-price-margin-worked-example): Calculate unit contribution, break-even volume, forecast profit, and a price from target gross margin using a worked example with explicit cost assumptions.
- [CSV data preparation: inspect, clean, sort and split](https://sheetreserve.yunusemrevurgun.com/blog/csv-data-preparation-checklist): Prepare CSV records for import with column profiles, duplicate checks, careful whitespace cleanup, stable sorting, and splitting that keeps quoted rows intact.
- [Exact spreadsheet lookups: missing and duplicate keys](https://sheetreserve.yunusemrevurgun.com/blog/exact-match-lookup-missing-duplicate-keys): Use INDEX MATCH or exact VLOOKUP to return a price, then check missing and duplicate keys so a plausible result does not hide an ambiguous source table.
- [Inventory balances and cycle count variance in a sheet](https://sheetreserve.yunusemrevurgun.com/blog/inventory-balance-cycle-count-variance): Roll stock from opening to closing quantities, calculate a manual reorder quantity, and compare book stock with physical counts without canceling discrepancies.
- [Invoice tracking: partial payments and overdue days](https://sheetreserve.yunusemrevurgun.com/blog/invoice-payments-outstanding-overdue): Build an invoice tracker that separates invoice value, payments, outstanding balance, and overdue days, with a fixed review date and a worked example.
- [Mass percent, dilution and yield: spreadsheet examples](https://sheetreserve.yunusemrevurgun.com/blog/mass-percent-serial-dilution-yield): Work through mass percent, serial dilution factors, and purity-adjusted reaction yield, with explicit units and checks that keep these calculations distinct.
- [SUMIFS and COUNTIFS: worked spreadsheet examples](https://sheetreserve.yunusemrevurgun.com/blog/sumifs-countifs-worked-examples): Build conditional sales totals and task counts with SUMIFS and COUNTIFS, using small worked examples, aligned ranges, and checks for missing matches.
- [Bank reconciliation step by step, with a worked example](https://sheetreserve.yunusemrevurgun.com/blog/bank-reconciliation-step-by-step): Reconcile a bank statement to the cash book step by step, with the two-sided format, a worked example that ties to zero and the journal entries it needs.
- [Customer ROI, payback and TCO: building a business case a buyer trusts](https://sheetreserve.yunusemrevurgun.com/blog/customer-roi-and-tco-business-case): ROI, payback, NPV, IRR and TCO for a customer business case, with a worked example that uses an adoption ramp, a 10% discount rate and five years.
- [Earned value management in a spreadsheet: SPI, CPI and EAC](https://sheetreserve.yunusemrevurgun.com/blog/earned-value-management-spi-cpi-eac): Calculate planned value, earned value and actual cost in a spreadsheet, then SPI, CPI and EAC, with a five-package example and notes on reading the results.
- [Financial ratio analysis: the ratios that matter, with formulas](https://sheetreserve.yunusemrevurgun.com/blog/financial-ratio-analysis-guide): The core financial ratios in four groups, each with its formula, computed for a two-year example company, plus the DuPont check and common mistakes.
- [How to calculate OEE: availability, performance and quality](https://sheetreserve.yunusemrevurgun.com/blog/how-to-calculate-oee): Calculate overall equipment effectiveness from shift data: a worked example, how to combine shifts, SUMIFS formulas and the mistakes to avoid.
- [How to size a solar PV system from your electricity use](https://sheetreserve.yunusemrevurgun.com/blog/how-to-size-a-solar-pv-system): Size a home solar PV system from 12 months of electricity use: the sizing equation, a worked example, panel count, battery size and simple payback.
- [Markup vs margin in a construction bid, with the math](https://sheetreserve.yunusemrevurgun.com/blog/markup-vs-margin-construction-bid): Convert markup to margin and back, build a bid price with overhead, profit and a bond premium, and read where your price lands in a bid tabulation.
- [Molarity, dilutions and C1V1 = C2V2 for preparing lab solutions](https://sheetreserve.yunusemrevurgun.com/blog/molarity-dilution-c1v1-c2v2): Work out the mass to weigh for a molar solution, correct for purity and hydrates, then dilute stock with C1V1 = C2V2 and serial dilutions, with worked numbers.
- [NASA's global temperature record (GISTEMP) in a spreadsheet](https://sheetreserve.yunusemrevurgun.com/blog/nasa-gistemp-global-temperature-in-a-spreadsheet): NASA's GISTEMP global temperature record in a spreadsheet: reading anomalies against the 1951-1980 base, decade averages, RANK formulas and hemisphere files.
- [Pareto analysis in a spreadsheet: find the vital few defects](https://sheetreserve.yunusemrevurgun.com/blog/pareto-analysis-in-a-spreadsheet): Run a Pareto analysis in a spreadsheet: sort defect counts, compute cumulative percentages, find the 80% line, compare count with cost and draw the bars.
- [Spreadsheet functions that work in every app: 53,657 formulas counted](https://sheetreserve.yunusemrevurgun.com/blog/spreadsheet-functions-that-work-in-every-app): A count of every function in 54 real workbooks: 44 distinct functions, IF in 53 of 54 files, and the functions the templates avoid so formulas open anywhere.
- [XLSX vs ODS vs CSV file size: measured on 54 real workbooks](https://sheetreserve.yunusemrevurgun.com/blog/xlsx-ods-csv-xml-numbers-file-size-benchmark): The same workbook written as XLSX, ODS, CSV, XML and Numbers: median size ratios, extremes and the reasons behind each gap, measured on 54 real files.
- [13-week cash flow forecast guide, with a worked example](https://sheetreserve.yunusemrevurgun.com/blog/13-week-cash-flow-forecast-guide): How to build a 13-week cash flow forecast in a spreadsheet, with receipts, disbursements, a revolver line, weekly variance analysis and common pitfalls.
- [Calculating beam deflection in a spreadsheet, with a worked example](https://sheetreserve.yunusemrevurgun.com/blog/beam-deflection-in-a-spreadsheet): Calculate beam deflection and moment in a spreadsheet with standard formulas, consistent units, superposition, a worked steel example and the L/360 limit.
- [DCF valuation in a spreadsheet, step by step with a worked example](https://sheetreserve.yunusemrevurgun.com/blog/dcf-valuation-spreadsheet-walkthrough): Build a DCF valuation in a spreadsheet with free cash flow, WACC, terminal value, mid-year discounting, an equity bridge and a sensitivity table.
- [Debt avalanche vs snowball: months to payoff with NPER, worked](https://sheetreserve.yunusemrevurgun.com/blog/debt-payoff-avalanche-snowball-nper): Compare the avalanche and snowball debt payoff methods month by month on three real-looking debts, and calculate months to payoff and interest with NPER.
- [GDP data explained: current US$, constant prices and PPP](https://sheetreserve.yunusemrevurgun.com/blog/gdp-data-current-constant-ppp-explained): When to use GDP in current US dollars, constant prices or PPP, why country rankings change between them, and real 2025 World Bank figures to show it.
- [Global freshwater withdrawals: what the World Bank data shows](https://sheetreserve.yunusemrevurgun.com/blog/global-freshwater-withdrawals-what-the-data-shows): World freshwater withdrawals were 3,853 billion cubic meters in 2022. The top withdrawers, sector splits, water stress and how to read FAO AQUASTAT data.
- [How to build a monthly budget spreadsheet you will keep using](https://sheetreserve.yunusemrevurgun.com/blog/monthly-budget-spreadsheet-that-lasts): Build a monthly budget spreadsheet with budget vs actual columns, SUMIFS formulas, a 50/30/20 starting split, sinking funds and a month-end reconciliation.
- [How to open a CSV in Excel without breaking your data](https://sheetreserve.yunusemrevurgun.com/blog/open-csv-in-excel-without-breaking-data): Why Excel drops leading zeros, rounds long numbers, invents dates and garbles accents when it opens a CSV, and the import settings that prevent each one.
- [Loan amortization in a spreadsheet with PMT, IPMT and PPMT](https://sheetreserve.yunusemrevurgun.com/blog/loan-amortization-pmt-ipmt-ppmt): Calculate a fixed-rate loan payment and build the amortization schedule with PMT, IPMT and PPMT, including sign rules, extra payments and the final payment.
- [Room and area schedules for architects, from BIM export to summary](https://sheetreserve.yunusemrevurgun.com/blog/room-and-area-schedules-for-architects): How to build a room and area schedule that stays consistent with BIM exports, with net vs gross area, BOMA and IPMS, room numbering and summary formulas.
- [Spreadsheet model design: inputs, calculations and outputs](https://sheetreserve.yunusemrevurgun.com/blog/spreadsheet-modeling-inputs-calculations-outputs): Rules for spreadsheets others can trust: separate inputs, calculations and outputs, one formula per row, no hard-coded numbers, units, checks and notes.
- [Where to find reliable public data for your spreadsheets](https://sheetreserve.yunusemrevurgun.com/blog/reliable-public-datasets-for-spreadsheets): Public data sources worth trusting for spreadsheets, what each covers, how it is licensed, how to pull it into a sheet, check gaps and cite it properly.
- [Worst case vs RSS tolerance stack-up in a spreadsheet](https://sheetreserve.yunusemrevurgun.com/blog/tolerance-stack-up-worst-case-vs-rss): Set up a one-dimensional tolerance stack-up in a spreadsheet, with loop signs, mean-and-tolerance conversion, worst case and RSS compared in a worked example.
- [Writing a construction cost estimate by CSI MasterFormat division](https://sheetreserve.yunusemrevurgun.com/blog/construction-cost-estimate-csi-masterformat): Build a construction cost estimate by CSI MasterFormat division, with takeoff, unit costs, markups in order, AACE estimate class and cost per square foot.
- [XLSX, CSV, ODS, XML or Numbers: which spreadsheet format to use](https://sheetreserve.yunusemrevurgun.com/blog/xlsx-csv-ods-numbers-which-format): How XLSX, CSV, ODS, XML Spreadsheet 2003 and Apple Numbers differ inside, what each one keeps (formulas, styles, sheets, types) and which to pick for a job.

## Free browser tools
- [CSV to XLSX converter](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-to-xlsx): CSV in · XLSX out. Turn a CSV, TSV or semicolon-separated file into an Excel .xlsx workbook in your browser. Numbers stay numbers, leading zeros stay text, nothing is uploaded.
- [XLSX to CSV converter](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/xlsx-to-csv): XLSX in · CSV or ZIP out. Convert an Excel .xlsx workbook to CSV in your browser. Each sheet becomes its own CSV, formulas are written as their last result, and nothing is uploaded.
- [CSV to JSON converter](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-to-json): CSV in · JSON out. Convert CSV to JSON in your browser: an array of objects or of arrays, numbers typed, no sign-up and no upload. Copy the preview or download the .json file.
- [CSV delimiter converter](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-delimiter-converter): CSV in · CSV out. Change a CSV delimiter between comma, semicolon, tab and pipe, and fix the file Excel opens in one column. Runs in your browser; nothing is uploaded.
- [Keep leading zeros in Excel](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-leading-zeros): CSV in · XLSX out. Stop Excel dropping the zeros in ZIP codes, account numbers and IDs. Convert a CSV to .xlsx with the columns you choose written as text. Free, in your browser.
- [JSON to CSV converter](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/json-to-csv): JSON in · CSV out. Convert a JSON array of objects or arrays into CSV. Preview columns, preserve leading-zero strings, and download locally with no account or upload.
- [JSON to Excel converter](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/json-to-xlsx): JSON in · XLSX out. Convert flat JSON records to an Excel XLSX workbook in your browser. Preview the table, keep leading-zero IDs as text, and download without uploading.
- [CSV duplicate row remover](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-remove-duplicates): CSV in · CSV out. Remove duplicate CSV rows while keeping the first occurrence and the header. Choose exact or case-insensitive comparison. Free, local, and no upload.
- [CSV cleaner: trim spaces and blank rows](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-cleaner): CSV in · CSV out. Trim leading and trailing spaces in CSV fields and remove empty rows. Preview the result and keep IDs as text. Runs on your device with no upload.
- [CSV transpose tool: rows to columns](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-transpose): CSV in · CSV out. Transpose CSV rows into columns and columns into rows. Preview the rotated table and download a new CSV locally. No sign-up or file upload required.
- [CSV to Markdown table converter](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-to-markdown): CSV in · Markdown out. Turn CSV into a Markdown table for documentation. Escape pipe characters, preserve line breaks, and preview the source. Free and entirely in your browser.
- [CSV column profiler: blanks and numeric summary](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-column-profiler): CSV in · profile CSV out. Inspect CSV columns for empty cells, distinct values, numeric counts, minimum, maximum, and mean. Download a column profile with no upload or sign-up.
- [CSV sorter: text or numeric column order](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-sorter): CSV in · CSV out. Sort CSV records by a column, as text or numbers, in ascending or descending order. Keep the header and tied-row order. Free, local, and no upload.
- [CSV splitter: smaller files with headers](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-splitter): CSV in · ZIP of CSVs out. Split a CSV into smaller files by row count, repeating the header in each part. Download a ZIP locally with no sign-up or upload. Quoted fields stay intact.
- [CSV formula escape tool](https://sheetreserve.yunusemrevurgun.com/spreadsheet-tools/csv-formula-escape): CSV in · CSV out. Prefix CSV fields starting with formula-like characters with an apostrophe. Preview changed fields before import. Runs in your browser without uploading.

## Questions
- [What is the difference between an action item and a project issue?](https://sheetreserve.yunusemrevurgun.com/questions/action-item-vs-project-issue): An action item records work someone must complete, usually with an owner and due date. A project issue records an existing problem requiring resolution, with an opened date, target resolution date, and resolution record. One issue can generate several actions. Keep the issue’s age separate from an action’s overdue days so the two measures retain their meaning.
- [Can I use Sheet Reserve files in commercial work?](https://sheetreserve.yunusemrevurgun.com/questions/can-i-use-sheet-reserve-templates-commercially): Yes. Under the Sheet Reserve license you can use downloaded files in personal and commercial work, including client work, modify them freely and share what you make with them, such as filled-in reports, charts and analyses. You cannot resell or redistribute the files themselves, upload them to template marketplaces or file-sharing sites, or share an account. Dataset sources may require attribution.
- [What is the difference between COUNTIF and COUNTIFS?](https://sheetreserve.yunusemrevurgun.com/questions/countif-vs-countifs): COUNTIF counts cells matching one condition. COUNTIFS counts records for which conditions across one or more aligned ranges all hold. Use COUNTIFS for questions such as how many tasks belong to Alex and are still Open. These functions count matches; they do not add an amount or estimate hours from the matching rows.
- [Debt avalanche or snowball: which pays off debt faster?](https://sheetreserve.yunusemrevurgun.com/questions/debt-avalanche-vs-snowball): The avalanche pays debts off in order of highest interest rate first, and the snowball pays the smallest balance first. When rates are fixed and you pay the same total every month, the avalanche costs the least interest and finishes no later, because high-rate balances grow fastest. The snowball gives earlier wins, which some people find easier to keep up.
- [Can Google Sheets open ODS files?](https://sheetreserve.yunusemrevurgun.com/questions/does-google-sheets-open-ods-files): Yes. Google Sheets imports OpenDocument Spreadsheet files. Choose File > Import > Upload, select the ODS file and pick an import location; the data becomes a regular Google Sheets file. You can also export back with File > Download > OpenDocument format (.ods). Formulas and basic formatting carry over, but macros and some advanced features do not.
- [What is the difference between water withdrawal and water consumption?](https://sheetreserve.yunusemrevurgun.com/questions/freshwater-withdrawal-vs-consumption): Water withdrawal is the total volume taken from a river, lake or aquifer for use. Water consumption is the part of that volume that does not return to the local water system, mainly lost to evaporation, plant transpiration or incorporation into products. Withdrawal is never smaller than consumption, and datasets such as FAO AQUASTAT report withdrawals, not consumption.
- [How are Sheet Reserve files converted in my browser?](https://sheetreserve.yunusemrevurgun.com/questions/how-are-files-converted-in-the-browser): Each workbook is stored once on the server as compressed JSON. When you download, your browser receives that compressed copy, typically tens of kilobytes, and JavaScript on the page writes the XLSX, ODS, XML, CSV or Numbers file locally. No conversion server sees the file. Formulas and styles are kept in XLSX, ODS and XML; CSV holds values only.
- [How does the Sheet Reserve membership work?](https://sheetreserve.yunusemrevurgun.com/questions/how-does-the-sheet-reserve-license-work): A Sheet Reserve membership costs US$19.85 per year, sold through Gumroad. It lets you download every sheet in the library in every format, including sheets added while you are a member. Two sheets are free with any verified account. After you buy, you paste the Gumroad license key on the Account page to activate the membership on your account.
- [How do I calculate how much to save each month for retirement?](https://sheetreserve.yunusemrevurgun.com/questions/how-much-to-save-for-retirement-each-month): Work backward from the spending you need. The target balance is the present value of the inflation-adjusted withdrawals over retirement, and the monthly saving is the payment that grows today's balance to that target: `=-PMT(rate/12, months, -balance, target)`. For $50,000 a year in constant dollars, 30 years to retirement, a 6% return and 2.5% inflation, it is $1,424.81 a month.
- [How do you amortize a prepaid expense by month?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-amortize-a-prepaid-expense): Divide the invoice amount by the number of service months, round to the cent, and expense that amount each month starting with the first service month. Let the final month take whatever is left so the total equals the invoice exactly. The unexpensed part stays on the balance sheet as a prepaid asset until each month's turn.
- [How do you apply the NEC 220.44 receptacle demand factor?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-apply-nec-220-44-receptacle-demand): For receptacle loads in buildings other than dwelling units, NEC 220.44 counts the first 10 kVA of connected receptacle load at 100% and the remainder at 50%. With 28 kVA connected, demand is 10 + 0.5 × 18 = 19 kVA, a ratio of 0.68. Apply that ratio to each receptacle circuit when totaling the phase loads.
- [How do you calculate the allowance for doubtful accounts from an aging report?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-allowance-for-doubtful-accounts): Age the open invoices into buckets by days past due, multiply each bucket's open balance by an estimated uncollectible rate taken from your own collection history, and add the results. That sum is the required allowance. The adjustment to book is the required allowance minus the balance already in the allowance account.
- [How do I calculate beam deflection?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-beam-deflection): Beam deflection comes from Euler–Bernoulli beam theory. Identify the support conditions and load, then apply the standard formula for that case, such as 5wL^4/(384EI) for the midspan deflection of a simply supported beam under uniform load. E is the elastic modulus and I the second moment of area. Keep units consistent and compare the result with a limit such as L/360.
- [How do you calculate break-even units in a spreadsheet?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-break-even-units): Subtract variable unit cost from selling price to get unit contribution, then divide period fixed costs by that positive contribution. Round up when only whole units can be sold. With $12,000 fixed cost, an $80 price, and $50 variable cost, contribution is $30 and break-even volume is 400 units. Nonpositive contribution has no finite break-even volume in this model.
- [How do you calculate closing stock from inventory movements?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-closing-stock): Closing stock equals opening stock plus receipts less issues for the same item, location, period, and unit of measure. With 80 opening units, 20 units received, and 65 units issued, the closing balance is 35 units. Convert mixed units before combining them, and keep negative results visible so unposted movements or incorrect inputs can be investigated.
- [How do you calculate economic order quantity (EOQ)?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-economic-order-quantity): EOQ is the square root of (2 × annual demand × cost per order ÷ annual holding cost per unit). Holding cost per unit is the unit cost times the holding rate. Order that quantity each time to minimize the sum of ordering and holding costs. Add safety stock to the reorder point to cover demand during the lead time.
- [How do you calculate days overdue for an unpaid invoice?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-invoice-days-overdue): For an invoice with an outstanding balance, subtract its due date from the review date and floor the result at zero. An invoice due October 1 and reviewed October 12 is 11 calendar days overdue. A future-due invoice shows zero, and a fully paid invoice shows zero in an open-balance report. Keep missing due dates explicit rather than treating them as old dates.
- [How do I calculate a loan payment with PMT?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-loan-payment-pmt): Use =PMT(rate/12, years*12, -loan_amount) for a fixed-rate loan with monthly payments. Divide the annual rate by 12, multiply the years by 12, and enter the loan amount as a negative number so the payment comes out positive. For 250,000 at 6.5 percent over 30 years, the payment is 1,580.17 per month.
- [How do you calculate project milestone delay?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-milestone-delay): Subtract the baseline milestone date from the current finish date. Use the actual completion date once completed and the current forecast while incomplete. A baseline of October 10 and forecast of October 15 gives a five-day delay. Negative values mean earlier than baseline. Keep baseline, forecast, and actual dates separate so the comparison remains reproducible.
- [How do you calculate molarity?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-molarity): Molarity is moles of solute divided by liters of solution. Divide the solute mass by its molar mass to get moles, then divide by the final volume in liters, which is the whole solution rather than the solvent alone. For 4.383 g of NaCl (molar mass 58.44 g/mol) made up to 0.500 L, the molarity is 0.150 M.
- [How do I calculate occupant load?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-occupant-load): Divide the floor area of each space by the occupant load factor for its use in IBC 2021 Table 1004.5, which lists square feet per person as either gross or net area. For example, business areas use 150 gross, so 4,200 square feet gives 28 occupants. Spaces with fixed seating are counted by seats. Always confirm the factors in the code your jurisdiction has adopted.
- [How do you calculate OEE?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-oee): OEE is availability × performance × quality. Availability is run time divided by planned production time. Performance is total count times ideal cycle time divided by run time. Quality is good count divided by total count. Multiply the three, or use good count × ideal cycle time ÷ planned production time.
- [How do you calculate the payback period for a customer ROI case?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-payback-period): Build a net cash flow for each year, then keep a running total starting from year 0. Payback happens in the first year the running total turns positive. Inside that year, months to payback equal 12 × (full years before it + the unrecovered balance ÷ that year's net cash flow). If the total never turns positive, report that payback falls outside the horizon.
- [How do you calculate purity-adjusted reaction percent yield?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-percent-yield): Multiply recovered product mass by its purity fraction to estimate pure product mass, then divide by theoretical product mass. Nine grams recovered at 98 percent purity contains 8.82 grams of pure product. Against a theoretical yield of 10 grams, the purity-adjusted yield is 88.2 percent. Keep the theoretical basis and purity measurement separate from the arithmetic.
- [How do I calculate percentage change in a spreadsheet?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-percentage-change): Subtract the old value from the new value, divide by the old value, and format the result as a percentage. With the old value in A2 and the new value in B2, enter =(B2-A2)/A2. A rise from 1,200 to 1,290 gives 0.075, which displays as 7.5 percent. A negative result is a decrease.
- [How do you calculate the overall serial dilution factor?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-serial-dilution-factor): Calculate each step’s dilution factor as final volume divided by transferred stock volume, then multiply the step factors. Transferring 1 milliliter into 9 milliliters of diluent gives a factor of 10 under additive volumes. Two such steps followed by a fivefold step give an overall factor of 500. Final concentration equals original concentration divided by that overall factor.
- [How do you calculate SPI and CPI?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-spi-and-cpi): SPI is earned value divided by planned value, and CPI is earned value divided by actual cost. Earned value is the budget of the work completed, so it equals the total budget times percent complete. A result of 1.00 means on plan, below 1.00 means behind schedule or over budget, and above 1.00 means ahead or under.
- [How do you calculate standard time from a time study?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-standard-time-from-a-time-study): Average the stopwatch readings for each work element, multiply by the operator's performance rating to get normal time, and add the elements. Then multiply by one plus the total allowance for fatigue, personal needs and delays. The result is the standard time per cycle, the time a trained operator working at a normal pace needs.
- [How do you calculate sum-of-the-years'-digits depreciation?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-sum-of-the-years-digits-depreciation): Multiply the depreciable amount, which is cost minus salvage value, by a fraction each year. The numerator is the asset's remaining life at the start of that year, and the denominator is the sum of the digits from 1 to the life, which equals life × (life + 1) ÷ 2. Charges fall each year and total exactly cost minus salvage.
- [How do you calculate takt time?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-calculate-takt-time): Takt time is the net available production time divided by customer demand for the same period. Subtract breaks from the shift length, multiply by the number of shifts, convert to seconds and divide by daily demand. If takt is 80 seconds, one unit must be completed every 80 seconds to meet demand, and each work station's task time must fit inside it.
- [How do you check for duplicate spreadsheet lookup keys?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-check-duplicate-lookup-keys): Count occurrences of the selected key with COUNTIF before using an exact lookup. A count of zero means missing, one means unique, and more than one means duplicated. If multiple records per key are legitimate, choose a more specific key or an aggregation rule. Returning the first matching record does not resolve an ambiguous source table.
- [How do I cite World Bank data?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-cite-world-bank-data): Credit the World Bank, the dataset and the original data source, then add the indicator name or code, the date you retrieved it and the URL. Most World Bank datasets are licensed CC BY 4.0, which allows commercial reuse if you give attribution, say whether you changed the data and do not imply World Bank endorsement. Check each indicator's metadata for exceptions.
- [How do you convert JSON records into CSV columns?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-convert-json-to-csv): Use a JSON array of flat objects, collect the property names as column headers, and write each object’s values in that order. Missing properties become empty cells. Sheet Reserve’s converter uses every property name encountered across the records and runs locally. Flatten nested objects first, and represent long or leading-zero identifiers as strings in the original JSON.
- [How do I convert XLSX to CSV without losing data?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-convert-xlsx-to-csv-without-losing-data): Prepare the sheet first, because CSV keeps only displayed values for one sheet. Check that cells hold the precision and text you want, then in Excel choose File > Save As and select CSV UTF-8 (Comma delimited). Export each sheet separately, and keep the XLSX original, since formulas, formatting and extra sheets are not stored in CSV.
- [How do you find the limiting reagent?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-find-the-limiting-reagent): Convert each reactant's mass to moles by dividing by its molar mass, then divide each by its coefficient in the balanced equation. The reactant with the smallest result is the limiting reagent, because it runs out first. Use its moles to find the theoretical yield, and compare the actual yield with that to get percent yield.
- [How do I freeze the header row in Excel, Google Sheets, LibreOffice and Numbers?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-freeze-header-row): In Excel choose View > Freeze Panes > Freeze Top Row. In Google Sheets choose View > Freeze > 1 row. In LibreOffice Calc choose View > Freeze Cells > Freeze First Row. In Numbers, select the table and tick Freeze Header Rows in the Table tab of the Format sidebar. The header then stays visible while you scroll.
- [How do you grade OKR key results?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-grade-okr-key-results): Calculate each key result's progress as (current value − start value) ÷ (target value − start value), limited to the range 0 to 1. The same formula works when the target is lower than the start. An objective's score is the weighted average of its key results, and the overall score is the weighted average of the objectives.
- [How do I keep leading zeros in a CSV file?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-keep-leading-zeros-in-csv): The zeros are usually still in the CSV; Excel removes them when it converts the column to numbers on opening. Import the file with Data > From Text/CSV and set the column to Text, or format the column as Text before pasting. Opening the file by double-click and saving it again makes the loss permanent.
- [How do you level subcontractor bids?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-level-subcontractor-bids): List every scope item the trade should include, give each a plug value you estimate yourself, and mark each subcontractor's bid Included, Excluded or Qualified for every item. Add the full plug value for each exclusion and a share of it for each qualification to the base bid. The lowest leveled bid, not the lowest base bid, is the fair comparison.
- [How do you make a calibration curve with the Beer-Lambert law?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-make-a-calibration-curve-with-beer-lambert): Measure the absorbance of standards of known concentration, plot absorbance against concentration and fit a straight line by least squares. The slope is the absorptivity times the path length. Read an unknown's concentration as (absorbance − intercept) ÷ slope, staying inside the range of the standards, and multiply by any dilution factor.
- [How do you make a Gantt chart in Excel or Google Sheets?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-make-a-gantt-chart-in-a-spreadsheet): Use one row per task and one column per week, with a formula in each cell that returns a block when the week overlaps the task dates. Start dates come from the finish dates of predecessor tasks, so the chart moves when a date changes. A stacked bar chart is another method in both apps.
- [How do I open a .numbers file on Windows?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-open-numbers-file-on-windows): Windows has no Numbers app, but you can open the file for free in a browser. Sign in at iCloud.com with an Apple Account, open Numbers, upload the file, then download a copy as Excel or CSV. Alternatively, ask the sender to export it from Numbers to XLSX or CSV, or try LibreOffice's partial import.
- [How do you prepare a buffer with the Henderson-Hasselbalch equation?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-prepare-a-buffer-with-henderson-hasselbalch): Use pH = pKa + log10(base ÷ acid) to find the ratio of base to acid, which is 10 raised to (target pH − pKa). Split the total moles of buffer between the two forms by that ratio, then weigh each as moles × molar mass. For a 0.100 M phosphate buffer at pH 7.40 in 1 L, that is 8.70 g of base and 4.64 g of acid.
- [How should you prepare CSV data before importing it?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-prepare-csv-data-for-import): Keep an original copy, confirm the delimiter and header, inspect empty and numeric fields, and identify columns that must remain text. Apply only the cleanup your receiving system requires, then compare row counts and sample records. Test the actual import settings for leading-zero identifiers, long account numbers, dates, and accented text before relying on the result.
- [How can you remove duplicate CSV rows without an upload?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-remove-duplicate-csv-rows): Parse the CSV as records, compare the complete row values, and retain the first occurrence of each distinct row. Sheet Reserve’s browser tool does this locally and can optionally ignore letter case. Rows sharing one ID but differing in another column remain distinct. Trim unintended surrounding spaces first only if those spaces should not affect equality.
- [How do you score a risk register?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-score-a-risk-register): Rate each risk's probability and impact on a 1 to 5 scale and multiply them to get a score from 1 to 25. Map the score to a rating with thresholds you set, such as Low 1 to 4, Medium 5 to 9, High 10 to 15 and Critical 16 to 25. Score again after the response to get the residual score.
- [How do you split a CSV and keep the header in every file?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-split-csv-with-headers): Parse the input into CSV records, separate the header, and divide the data records into chunks. Write the header before each chunk. Avoid splitting on physical lines because a quoted cell can contain a line break. Sheet Reserve’s CSV splitter performs this in the browser and downloads a ZIP containing the smaller files.
- [How do you track partial payments against an invoice?](https://sheetreserve.yunusemrevurgun.com/questions/how-to-track-partial-invoice-payments): Keep one invoice record with its original amount and cumulative payments, then calculate outstanding balance as invoice amount less payments. A $1,250 invoice with $500 paid has $750 outstanding. A further $300 payment reduces the balance to $450. If payments are kept in a separate ledger, sum them by the stable invoice ID before calculating the remaining amount.
- [What is the difference between markup and margin?](https://sheetreserve.yunusemrevurgun.com/questions/markup-vs-margin): Markup is profit as a share of cost, and margin is profit as a share of price. Margin equals markup divided by (1 + markup), so a 20% markup is a 16.67% margin, and a 20% margin needs a 25% markup. On a cost of 1,134,000, a 20% markup earns 226,800 of profit on a 1,360,800 price.
- [How does mass percent differ from mass per volume percent?](https://sheetreserve.yunusemrevurgun.com/questions/mass-percent-vs-mass-volume-percent): Mass percent divides solute mass by total solution mass and multiplies by 100. Mass per volume percent conventionally expresses grams of solute per 100 milliliters of solution. The denominators are different, so 5 percent by mass cannot be assumed to mean 5 grams per 100 milliliters. Converting between them needs appropriate volume or density information.
- [What is the difference between nominal GDP and GDP at PPP?](https://sheetreserve.yunusemrevurgun.com/questions/nominal-gdp-vs-gdp-ppp): Nominal GDP converts a country's output into US dollars at market exchange rates, so it shows what that output is worth on currency markets. GDP at PPP converts it at purchasing power parity rates, which equalize the price of a common basket of goods, so it shows what the output can buy domestically. PPP figures are usually higher for economies with lower price levels.
- [What is the difference between safely managed and basic drinking water?](https://sheetreserve.yunusemrevurgun.com/questions/safely-managed-vs-basic-drinking-water): Safely managed water comes from an improved source on the premises that is available when needed and free from fecal and priority chemical contamination. Basic water comes from an improved source where a round trip to collect it, including queuing, takes 30 minutes or less. In 2024, 73.7% of people worldwide used safely managed water and 91.5% used at least basic water, per World Bank data citing JMP.
- [What is the difference between SUMIF and SUMIFS?](https://sheetreserve.yunusemrevurgun.com/questions/sumif-vs-sumifs): SUMIF adds values that meet one condition. SUMIFS adds values that meet all specified conditions, and it can also be used with a single condition. Their argument order differs: SUMIFS starts with the sum range, while SUMIF puts the optional sum range third. Keep the sum and criteria ranges aligned to the same records.
- [VLOOKUP or XLOOKUP: which should I use?](https://sheetreserve.yunusemrevurgun.com/questions/vlookup-vs-xlookup): Use XLOOKUP when everyone who opens the file has it, meaning Excel 2021, Microsoft 365, Google Sheets, or LibreOffice 24.8 and later. It defaults to an exact match, looks left or right, and has a not-found argument. Use VLOOKUP when the file must work in Excel 2019 or older, or in older LibreOffice versions.
- [What does the #REF! error mean and how do I fix it?](https://sheetreserve.yunusemrevurgun.com/questions/what-does-ref-error-mean): The #REF! error means a formula refers to a cell, range or sheet that no longer exists or is not valid. It usually appears after you delete rows, columns or sheets that a formula used, or paste over referenced cells. Undo the change, or edit the formula and replace the #REF! token with a correct reference.
- [What happens when my Sheet Reserve membership ends?](https://sheetreserve.yunusemrevurgun.com/questions/what-happens-when-my-membership-ends): Downloads stop, but nothing you already have is taken away. If you cancel in Gumroad, access continues until the end of the year you paid for, then new downloads stop until you renew. Files you already downloaded stay yours to keep using under the license terms. Previews remain visible, and the two free sheets stay available to a verified account.
- [What is a 13-week cash flow forecast?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-a-13-week-cash-flow-forecast): A 13-week cash flow forecast is a week-by-week projection of the cash a business expects to receive and pay out over the next quarter. It starts from the actual bank balance, adds expected receipts, subtracts expected disbursements and shows the closing balance for each week. Its purpose is to reveal cash shortfalls early, and it is rolled forward every week.
- [What is a bank reconciliation?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-a-bank-reconciliation): A bank reconciliation compares the cash balance in your books with the bank statement balance, adjusted for items that appear on only one side, such as deposits in transit, outstanding checks, fees and errors. When the two adjusted balances agree, the cash records are confirmed. Any remaining difference must be explained before the period is closed.
- [What is a grossing factor in space programming?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-a-grossing-factor): A grossing factor is the multiplier that converts net assignable area, the space people and equipment actually occupy, into gross area, which adds circulation, walls, shafts, structure and building services. A factor of 1.35 means every 1,000 square feet of net needs 1,350 gross. Programmers often apply one factor per department and a second for the whole building.
- [What is a .numbers file?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-a-numbers-file): A .numbers file is a spreadsheet created by Apple Numbers, the spreadsheet app included with macOS, iOS and iPadOS. Current files are packages built from Apple's proprietary IWA format, which Apple has not publicly documented. Numbers opens Excel and CSV files, but other programs usually need the file exported to XLSX or CSV first.
- [What is a Pareto chart?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-a-pareto-chart): A Pareto chart is a bar chart of categories sorted from largest to smallest, with a line showing the cumulative percentage of the total. It shows which few categories account for most of a problem, such as the most common defects or the costliest ones. It is based on the Pareto principle, named after the economist Vilfredo Pareto.
- [What is a RACI matrix and what does each letter mean?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-a-raci-matrix): A RACI matrix is a grid of tasks against roles that marks each cell R (Responsible, does the work), A (Accountable, owns the result and signs off), C (Consulted, gives input before) or I (Informed, told afterward). The key rule is exactly one A on every task, and at least one R, so no task is ownerless or double-owned.
- [What is an amortization schedule?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-an-amortization-schedule): An amortization schedule is a table listing every payment on a loan and how each payment splits into interest and principal, with the remaining balance after each one. Early payments are mostly interest, and the principal share grows each month. It shows the total interest cost and the date the balance reaches zero.
- [What is an ODS file?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-an-ods-file): An ODS file is an OpenDocument Spreadsheet, the native format of LibreOffice Calc and Apache OpenOffice Calc. It is a ZIP package of XML files defined by the OASIS OpenDocument standard, also published as ISO/IEC 26300. Excel, Google Sheets and many other programs can open and save ODS, though advanced features may not carry over.
- [What is an RFP compliance matrix and how is it scored?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-an-rfp-compliance-matrix): An RFP compliance matrix lists every requirement in a request for proposal with its priority and how fully your response meets it. Each requirement gets a weight from its priority (Must 5, Should 3, Could 1) and a score from the compliance level (Full 1, Partial 0.5, Roadmap 0.25, No 0). Weighted compliance is the sum of weighted scores over the sum of the maximum weighted scores.
- [What is an unbalanced bid and how do you spot one?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-an-unbalanced-bid): An unbalanced bid is one whose individual unit prices are far above or below what is reasonable even though the total looks competitive, often to collect money early or to profit from quantity changes. To spot one, compare each unit price with the median of all bidders' prices for that line and flag prices that fall outside a set percentage band around it.
- [What is an XLSX file?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-an-xlsx-file): An XLSX file is a spreadsheet saved in the Office Open XML format, the default for Microsoft Excel since Excel 2007. It is a ZIP package of XML files holding cell values, formulas, formatting and multiple worksheets. The format is standardized as ECMA-376 and ISO/IEC 29500, and Excel, LibreOffice, Google Sheets and Numbers can all open it.
- [What is an XML spreadsheet (Excel 2003 XML)?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-an-xml-spreadsheet): An XML spreadsheet, formally XML Spreadsheet 2003, is a single plain-text XML file that stores a workbook using Microsoft's SpreadsheetML 2003 schema. Excel 2003 introduced it as an alternative to binary XLS. Current Excel versions can still open and save it, and LibreOffice can too. It is human-readable but larger and less capable than XLSX.
- [What is inventory cycle count variance?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-cycle-count-variance): Cycle count variance is the physical quantity counted less the recorded book quantity for the same item and location. A count of 97 against book stock of 100 gives a variance of -3 units. Multiplying by a $12 unit cost gives -$36. Review both net and absolute cost differences because positive and negative discrepancies can cancel in a net total.
- [What is discounted cash flow (DCF)?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-discounted-cash-flow): Discounted cash flow (DCF) values a business or project by forecasting its future free cash flows and discounting each back to today at a rate that reflects risk, usually the weighted average cost of capital. The present values of the forecast years plus a terminal value are summed to give enterprise value. Subtracting net debt gives equity value.
- [What is RSS tolerance analysis?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-rss-tolerance-analysis): RSS (root sum square) tolerance analysis is a statistical way to stack up part tolerances. Instead of adding every tolerance, as worst-case analysis does, it takes the square root of the sum of their squares. The result is smaller because it assumes variations are independent and rarely all sit at their limits together, so it predicts the likely spread of an assembly.
- [What is the 50/30/20 budget rule?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-the-50-30-20-budget-rule): The 50/30/20 rule splits after-tax income into three parts: 50 percent for needs, 30 percent for wants and 20 percent for saving and extra debt repayment. Elizabeth Warren and Amelia Warren Tyagi described it in their 2005 book All Your Worth. It is a starting guideline, not a law, and high housing costs often push the needs share above 50 percent.
- [What is the current ratio?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-the-current-ratio): The current ratio is current assets divided by current liabilities. It shows how many dollars of assets due within a year are available for each dollar of obligations due within a year. A value below 1 means current liabilities exceed current assets. A good value depends on the industry and business model.
- [What is the Darcy–Weisbach equation?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-the-darcy-weisbach-equation): The Darcy–Weisbach equation gives the head or pressure lost to friction when fluid flows through a full pipe. Head loss equals the friction factor times length over diameter times velocity squared over twice gravity. It applies to any Newtonian fluid and flow regime. The friction factor depends on the Reynolds number and pipe roughness, and comes from the Colebrook equation or an approximation.
- [What is total cost of ownership (TCO)?](https://sheetreserve.yunusemrevurgun.com/questions/what-is-total-cost-of-ownership): Total cost of ownership (TCO) is the full cost of acquiring, running and supporting an asset or option over a stated period. It adds the purchase or setup cost to recurring costs such as subscriptions, supplies, service and staff time. TCO shows which option costs least to own, which the price alone does not. It measures cost only, not return.
- [Why does Excel put my whole CSV in one column?](https://sheetreserve.yunusemrevurgun.com/questions/why-does-excel-open-csv-in-one-column): Excel splits a CSV using the list separator from your computer's regional settings, which is a semicolon in many countries. If the file uses commas, or the reverse, every row lands in column A. Import the file with Data > From Text/CSV and pick the right delimiter, or use Text to Columns on the pasted data.
- [Why does an exact VLOOKUP return #N/A?](https://sheetreserve.yunusemrevurgun.com/questions/why-does-vlookup-return-na): An exact VLOOKUP returns #N/A when it cannot find the selected key in the first column of its lookup table. Check the key itself, whether one side is text and the other numeric, unintended spaces, and whether the lookup range includes the record. Do not replace every missing match with zero: a missing price and a zero price mean different things.
- [What is the difference between XLSX and CSV?](https://sheetreserve.yunusemrevurgun.com/questions/xlsx-vs-csv): XLSX is a ZIP package of XML that stores formulas, formatting, data types and several worksheets. CSV is a plain text file of comma-separated values for one table, with no formulas, formatting or types. Use XLSX to keep a working spreadsheet intact, and CSV to move raw rows between programs, databases and scripts.

## Pricing and key pages
- [Pricing](https://sheetreserve.yunusemrevurgun.com/pricing): One membership, $19.85 a year, every sheet in all five formats.
- [About](https://sheetreserve.yunusemrevurgun.com/about): Why the library exists, how files are made, and who makes it.
- [Data sources and licences](https://sheetreserve.yunusemrevurgun.com/data-sources): The public source, licence and retrieval date behind every dataset.
- [Contact](https://sheetreserve.yunusemrevurgun.com/contact): yunus@yunusemrevurgun.com for membership, refunds and corrections.

## Optional
- [Full text for language models](https://sheetreserve.yunusemrevurgun.com/llms-full.txt): The complete text of every guide, answer, sheet description and tool page in one file.
- [JSON catalog](https://sheetreserve.yunusemrevurgun.com/catalog.json): Every sheet, category and tool as structured JSON.
- [Terms](https://sheetreserve.yunusemrevurgun.com/terms)
- [Privacy](https://sheetreserve.yunusemrevurgun.com/privacy)
- [License](https://sheetreserve.yunusemrevurgun.com/license)
