스프레드시트 도구와 계산기
근무 시간, 비율 변화, 날짜 차이 등 흔한 스프레드시트 계산을 위한 무료 도구와 해당 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.