Subscription cost tracker: find what each plan costs a year
Turn each subscription into a monthly equivalent and an annual cost, measure the unused share, and total the list with formulas you can check.
Worked examples and plain explanations: spreadsheet formats, financial models, engineering calculations and the public data behind the datasets.
BudgetingArchitectureFinanceAccountingIndustrial engineeringBiddingEngineeringManagementFormatsSpreadsheet skillsChemistrySales engineeringOpen data
Turn each subscription into a monthly equivalent and an annual cost, measure the unused share, and total the list with formulas you can check.
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.
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.
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.
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.
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.
Build a construction cost estimate by CSI MasterFormat division, with takeoff, unit costs, markups in order, AACE estimate class and cost per square foot.
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.
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.
Calculate net working capital, the current ratio and the quick ratio from balance-sheet inputs, with a worked three-quarter example and its limits.
Calculate unit contribution, break-even volume, forecast profit, and a price from target gross margin using a worked example with explicit cost assumptions.
How to build a 13-week cash flow forecast in a spreadsheet, with receipts, disbursements, a revolver line, weekly variance analysis and common pitfalls.
Build a DCF valuation in a spreadsheet with free cash flow, WACC, terminal value, mid-year discounting, an equity bridge and a sensitivity table.
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.
Build a deferred revenue schedule that splits an upfront billing into recognized revenue and a remaining liability, with monthly formulas and a worked example.
Build an invoice tracker that separates invoice value, payments, outstanding balance, and overdue days, with a fixed review date and a worked example.
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.
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.
Calculate first-pass yield, final good units and rolled throughput yield across three stations, and see why rework hides losses that station yield shows.
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.
Roll stock from opening to closing quantities, calculate a manual reorder quantity, and compare book stock with physical counts without canceling discrepancies.
Calculate overall equipment effectiveness from shift data: a worked example, how to combine shifts, SUMIFS formulas and the mistakes to avoid.
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.
Calculate earned value, retainage held and the current payment due per schedule-of-values line, with a three-line worked example and common pitfalls.
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.
Convert airflow and supply-to-return temperature difference into mass flow and sensible heating or cooling load in kilowatts, with three worked zones.
Calculate loop resistance, voltage drop, percent drop and load voltage for a single-phase circuit from current, length and conductor resistance.
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.
Calculate beam deflection and moment in a spreadsheet with standard formulas, consistent units, superposition, a worked steel example and the L/360 limit.
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.
Choose an action, issue, or milestone tracker and calculate overdue days, issue age, and baseline delay using explicit dates and completion-aware formulas.
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.
Prepare CSV records for import with column profiles, duplicate checks, careful whitespace cleanup, stable sorting, and splitting that keeps quoted rows intact.
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.
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.
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.
Build conditional sales totals and task counts with SUMIFS and COUNTIFS, using small worked examples, aligned ranges, and checks for missing matches.
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.
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.
Rules for spreadsheets others can trust: separate inputs, calculations and outputs, one formula per row, no hard-coded numbers, units, checks and notes.
Work through mass percent, serial dilution factors, and purity-adjusted reaction yield, with explicit units and checks that keep these calculations distinct.
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.
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.
NASA's GISTEMP global temperature record in a spreadsheet: reading anomalies against the 1951-1980 base, decade averages, RANK formulas and hemisphere files.
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.
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.
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.