cost,date_purchased,first_period,salvage,period,rate,basis!Returns the prorated linear depreciation of an asset for each ...

!cost,date_purchased,first_period,salvage,period,rate,basis!!Returns the prorated linear depreciation of an asset for each accounting period.!is the cost of the asset!is the date the asset is purchased!is the date of the end of the first period!is the salvage value at the end of life of the asset.!is the period!is the rate of depreciation!year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days.!

connection,set_expression,caption,sort_order,sort_by!Defines a calculated set of members or tuples by sending a set expression ... connection,set_expression,rank,caption!Returns the nth, or ranked, member in a set.!is the name of a connection to an OLAP ... contains sound notes. If you save '|' in this format, the sound notes will be permanently lost. To keep the sound notes, ... Converting this query range to a list query range may cause some macro code and/or formulas not to function properly. Do ... cost,date_purchased,first_period,salvage,period,rate,basis!Returns the prorated linear depreciation of an asset for each ... cost,salvage,life!Returns the straight-line depreciation of an asset for one period!is the initial cost of the asset!is the ... cost,salvage,life,per!Returns the sum-of-years' digits depreciation of an asset for a specified period!is the initial cost ... cost,salvage,life,period,factor!Returns the depreciation of an asset for a specified period using the double-declining balance ... cost,salvage,life,period,month!Returns the depreciation of an asset for a specified period using the fixed-declining balance ...