{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["DB","DDB","VDB"],"read":"whole","date_system":"1900"}

{"sheet":"DB","index":0,"n_rows":13,"n_cols":4,"rows_kept":13}
["Year","Opening Book Value","Depreciation","Closing Book Value"]
[1,{"v":200000,"d":"$200,000.00"},{"$f":"DB($B$2,20000,$A$13,A2)","v":{"v":35000,"d":"$35,000.00"}},{"$f":"B2-C2","v":{"v":165000,"d":"$165,000.00"}}]
[2,{"$f":"D2","v":{"v":165000,"d":"$165,000.00"}},{"$f":"DB($B$2,20000,$A$13,A3)","v":{"v":28874.999999999996,"d":"$28,875.00"}},{"$f":"B3-C3","v":{"v":136125,"d":"$136,125.00"}}]
[3,{"$f":"D3","v":{"v":136125,"d":"$136,125.00"}},{"v":23821.875,"d":"$23,821.88"},{"v":112303.125,"d":"$112,303.13"}]
[4,{"v":112303.125,"d":"$112,303.13"},{"v":19653.046875,"d":"$19,653.05"},{"v":92650.078125,"d":"$92,650.08"}]
[5,{"v":92650.078125,"d":"$92,650.08"},{"v":16213.763671874998,"d":"$16,213.76"},{"v":76436.314453125,"d":"$76,436.31"}]
[6,{"v":76436.314453125,"d":"$76,436.31"},{"v":13376.355029296874,"d":"$13,376.36"},{"v":63059.95942382813,"d":"$63,059.96"}]
[7,{"v":63059.95942382813,"d":"$63,059.96"},{"v":11035.492899169922,"d":"$11,035.49"},{"v":52024.46652465821,"d":"$52,024.47"}]
[8,{"v":52024.46652465821,"d":"$52,024.47"},{"v":9104.281641815185,"d":"$9,104.28"},{"v":42920.18488284302,"d":"$42,920.18"}]
[9,{"v":42920.18488284302,"d":"$42,920.18"},{"v":7511.032354497528,"d":"$7,511.03"},{"v":35409.1525283455,"d":"$35,409.15"}]
[10,{"v":35409.1525283455,"d":"$35,409.15"},{"v":6196.601692460462,"d":"$6,196.60"},{"v":29212.550835885035,"d":"$29,212.55"}]
[11,{"v":29212.550835885035,"d":"$29,212.55"},{"v":5112.196396279881,"d":"$5,112.20"},{"v":24100.354439605155,"d":"$24,100.35"}]
[12,{"v":24100.354439605155,"d":"$24,100.35"},{"v":4217.562026930902,"d":"$4,217.56"},{"v":19882.79241267425,"d":"$19,882.79"}]

{"sheet":"DDB","index":1,"n_rows":13,"n_cols":4,"rows_kept":13}
["Year","Opening Book Value","Depreciation","Closing Book Value"]
[1,{"v":200000,"d":"$200,000.00"},{"$f":"DDB($B$2,20000,$A$13,A2,2)","v":{"v":33333.33333333333,"d":"$33,333.33"}},{"$f":"B2-C2","v":{"v":166666.6666666667,"d":"$166,666.67"}}]
[2,{"$f":"D2","v":{"v":166666.6666666667,"d":"$166,666.67"}},{"$f":"DDB($B$2,20000,$A$13,A3,2)","v":{"v":27777.77777777778,"d":"$27,777.78"}},{"v":138888.8888888889,"d":"$138,888.89"}]
[3,{"v":138888.8888888889,"d":"$138,888.89"},{"v":23148.14814814815,"d":"$23,148.15"},{"v":115740.74074074076,"d":"$115,740.74"}]
[4,{"v":115740.74074074076,"d":"$115,740.74"},{"v":19290.123456790127,"d":"$19,290.12"},{"v":96450.61728395063,"d":"$96,450.62"}]
[5,{"v":96450.61728395063,"d":"$96,450.62"},{"v":16075.10288065844,"d":"$16,075.10"},{"v":80375.5144032922,"d":"$80,375.51"}]
[6,{"v":80375.5144032922,"d":"$80,375.51"},{"v":13395.919067215365,"d":"$13,395.92"},{"v":66979.59533607683,"d":"$66,979.60"}]
[7,{"v":66979.59533607683,"d":"$66,979.60"},{"v":11163.265889346141,"d":"$11,163.27"},{"v":55816.32944673069,"d":"$55,816.33"}]
[8,{"v":55816.32944673069,"d":"$55,816.33"},{"v":9302.721574455118,"d":"$9,302.72"},{"v":46513.60787227558,"d":"$46,513.61"}]
[9,{"v":46513.60787227558,"d":"$46,513.61"},{"v":7752.2679787126,"d":"$7,752.27"},{"v":38761.33989356298,"d":"$38,761.34"}]
[10,{"v":38761.33989356298,"d":"$38,761.34"},{"v":6460.223315593834,"d":"$6,460.22"},{"v":32301.116577969147,"d":"$32,301.12"}]
[11,{"v":32301.116577969147,"d":"$32,301.12"},{"v":5383.519429661528,"d":"$5,383.52"},{"v":26917.59714830762,"d":"$26,917.60"}]
[12,{"v":26917.59714830762,"d":"$26,917.60"},{"v":4486.266191384607,"d":"$4,486.27"},{"v":22431.330956923015,"d":"$22,431.33"}]

{"sheet":"VDB","index":2,"n_rows":5,"n_cols":5,"rows_kept":5}
["Parameter","Value",null,"Type","Depreciation"]
["Cost",{"v":10000,"d":"$10,000"},null,"Year",{"$f":"VDB(B2,B3,B4,0,1,B5,TRUE)","v":{"v":4000,"d":"$4,000.00"}}]
["Salvage Value",{"v":1000,"d":"$1,000"},null,"Month",{"$f":"VDB(B2,B3,B4*12,0,1,B5,TRUE)","v":{"v":333.3333333333333,"d":"$333.33"}}]
["Useful Life in Years",5,null,"Day",{"$f":"VDB(B2,B3,B4*365,0,1,B5,TRUE)","v":{"v":10.95890410958904,"d":"$10.96"}}]
["Factor",2]