电子表格工具与计算器
免费计算器，用于工时、百分比变化、日期差等常见表格计算，并附上对应的 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.