スプレッドシートの計算ツール
労働時間、変化率、日付の差など、よくある表計算の無料ツールと、対応する Excel / Google Sheets の数式。
Percentage Change Calculator
Find the percent increase or decrease between two numbers, then copy the Excel and Google Sheets formula. Tested on revenue, price and score examples.
ツールDate Difference Calculator
Count the days, weeks, months and years between two dates, including the DATEDIF formula and a fix for the negative remaining-days bug.
ツールLoan Payment Calculator
Calculate a loan or mortgage payment, total interest and total paid. Uses the same PMT math as Excel and Google Sheets, with a worked $250,000 example.
ツールCAGR Calculator
Calculate the compound annual growth rate between a starting and ending value. Matches Excel and Google Sheets RRI, including a 10% five-year check.
ツールWeighted Average Calculator
Compute a weighted average from a list of values and weights, with the SUMPRODUCT formula that works in Excel and Google Sheets.
ツールPercentage of Total Calculator
Split a list of amounts into a percentage of the total, with the Excel and Google Sheets formula. Tested on a two-region revenue example.
ツールMarkup vs Margin Calculator
Convert between markup and margin, or find a selling price from cost. Uses the same profit/cost and profit/price formulas as Excel and Google Sheets.
ツールCompound Interest Calculator
Project a starting balance with compound interest, optional regular contributions, and the matching FV formula from Excel and Google Sheets.
ツールTime Card Calculator with Overtime
Split a week of hours into regular and overtime pay, using a daily or weekly threshold, with the Excel and Google Sheets formulas.
ツールDiscount Calculator (Percentage Off)
Find the sale price, savings, or discount percent from a list price, with the Excel and Google Sheets formulas.
ツールSimple Interest Calculator
Calculate simple interest and the total amount due using I = PRT, and see how it differs from compound interest.
ツールPercent Error Calculator
Measure how far a result is from an accepted value, with the ABS formula that works in Excel and Google Sheets.
ツールHourly to Salary Calculator
Convert an hourly wage to weekly, monthly, and annual salary using hours per week and paid weeks per year, with the spreadsheet formulas.
ツールRule of 72 Calculator
Estimate how many years an investment takes to double at a given rate, and compare the Rule of 72 to the exact compound formula.
ツールBreak-Even Calculator
Find the units and revenue needed to cover fixed costs from the selling price and variable cost per unit, with the spreadsheet formulas.
ツールSales Tax Calculator
Add sales tax to a net price, or back the tax out of a total, with the Excel and Google Sheets formulas.
ツールROI Calculator
Calculate return on investment from cost and ending value, with the spreadsheet formula and a profit figure.
ツールStraight-Line Depreciation Calculator
Compute annual straight-line depreciation and book value from cost, salvage, and useful life, including the SLN formula.
ツールPayback Period Calculator
Find how long it takes to recover a cost from even annual cash flows, or from a list of yearly amounts, with the spreadsheet formulas.
ツールAPY Calculator (Effective Annual Rate)
Convert a nominal annual rate into APY, or effective annual rate, for monthly, quarterly, or other compounding, including the EFFECT formula.
ツールDeclining-Balance Depreciation Calculator
Compute double-declining or declining-balance depreciation and book value by year, matching the Excel and Google Sheets DDB function.
ツールPresent Value Calculator
Find the present value of a lump sum, an annuity, or both, with the Excel and Google Sheets PV formula.
ツールNPV Calculator
Calculate net present value for uneven cash flows, subtract the initial cost outside NPV, and match the spreadsheet function.
ツールCommission Calculator
Calculate a flat or two-tier sales commission from a sales amount and a rate, with the spreadsheet formulas.
ツールHours Worked Calculator
Clock-in to clock-out hours, including overnight shifts and unpaid breaks, plus the matching spreadsheet formula.