Microsoft Excel has built-in functions for multiple depreciation ... balance accelerated method (DDB function), variable declining balance method (VDB function), and units of production method ...

This straight-line depreciation method evenly distributes ... that wear out based on production levels, like machinery that depreciates based on hours used or units produced.