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

{"sheet":"WDV","index":0,"n_rows":13,"n_cols":4,"rows_kept":13}
["Year","Opening Book Value","Depreciation (15%)","Closing Book Value"]
[1,{"v":100000,"d":"$100,000.00"},{"$f":"B2*15%","v":{"v":15000,"d":"$15,000.00"}},{"$f":"B2-C2","v":{"v":85000,"d":"$85,000.00"}}]
[2,{"$f":"D2","v":{"v":85000,"d":"$85,000.00"}},{"$f":"B3*15%","v":{"v":12750,"d":"$12,750.00"}},{"$f":"B3-C3","v":{"v":72250,"d":"$72,250.00"}}]
[3,{"$f":"D3","v":{"v":72250,"d":"$72,250.00"}},{"v":10837.5,"d":"$10,837.50"},{"v":61412.5,"d":"$61,412.50"}]
[4,{"v":61412.5,"d":"$61,412.50"},{"v":9211.875,"d":"$9,211.88"},{"v":52200.625,"d":"$52,200.63"}]
[5,{"v":52200.625,"d":"$52,200.63"},{"v":7830.09375,"d":"$7,830.09"},{"v":44370.53125,"d":"$44,370.53"}]
[6,{"v":44370.53125,"d":"$44,370.53"},{"v":6655.5796875,"d":"$6,655.58"},{"v":37714.9515625,"d":"$37,714.95"}]
[7,{"v":37714.9515625,"d":"$37,714.95"},{"v":5657.242734375,"d":"$5,657.24"},{"v":32057.708828125,"d":"$32,057.71"}]
[8,{"v":32057.708828125,"d":"$32,057.71"},{"v":4808.656324218749,"d":"$4,808.66"},{"v":27249.05250390625,"d":"$27,249.05"}]
[9,{"v":27249.05250390625,"d":"$27,249.05"},{"v":4087.357875585937,"d":"$4,087.36"},{"v":23161.69462832031,"d":"$23,161.69"}]
[10,{"v":23161.69462832031,"d":"$23,161.69"},{"v":3474.2541942480466,"d":"$3,474.25"},{"v":19687.440434072265,"d":"$19,687.44"}]
[11,{"v":19687.440434072265,"d":"$19,687.44"},{"v":2953.11606511084,"d":"$2,953.12"},{"v":16734.324368961425,"d":"$16,734.32"}]
[12,{"v":16734.324368961425,"d":"$16,734.32"},{"v":2510.1486553442137,"d":"$2,510.15"},{"v":14224.175713617211,"d":"$14,224.18"}]

{"sheet":"DB","index":1,"n_rows":13,"n_cols":4,"rows_kept":13}
["Year","Opening Book Value","Depreciation","Closing Book Value"]
[1,{"v":100000,"d":"$100,000.00"},{"$f":"DB($B$2,15000,$A$13,A2)","v":{"v":14599.999999999998,"d":"$14,600.00"}},{"$f":"B2-C2","v":{"v":85400,"d":"$85,400.00"}}]
[2,{"$f":"D2","v":{"v":85400,"d":"$85,400.00"}},{"$f":"DB($B$2,15000,$A$13,A3)","v":{"v":12468.4,"d":"$12,468.40"}},{"$f":"B3-C3","v":{"v":72931.6,"d":"$72,931.60"}}]
[3,{"$f":"D3","v":{"v":72931.6,"d":"$72,931.60"}},{"v":10648.0136,"d":"$10,648.01"},{"$f":"B4-C4","v":{"v":62283.58640000001,"d":"$62,283.59"}}]
[4,{"$f":"D4","v":{"v":62283.58640000001,"d":"$62,283.59"}},{"v":9093.4036144,"d":"$9,093.40"},{"$f":"B5-C5","v":{"v":53190.18278560001,"d":"$53,190.18"}}]
[5,{"$f":"D5","v":{"v":53190.18278560001,"d":"$53,190.18"}},{"v":7765.766686697601,"d":"$7,765.77"},{"$f":"B6-C6","v":{"v":45424.41609890241,"d":"$45,424.42"}}]
[6,{"$f":"D6","v":{"v":45424.41609890241,"d":"$45,424.42"}},{"v":6631.964750439752,"d":"$6,631.96"},{"$f":"B7-C7","v":{"v":38792.45134846266,"d":"$38,792.45"}}]
[7,{"$f":"D7","v":{"v":38792.45134846266,"d":"$38,792.45"}},{"v":5663.6978968755475,"d":"$5,663.70"},{"$f":"B8-C8","v":{"v":33128.75345158711,"d":"$33,128.75"}}]
[8,{"$f":"D8","v":{"v":33128.75345158711,"d":"$33,128.75"}},{"v":4836.798003931717,"d":"$4,836.80"},{"$f":"B9-C9","v":{"v":28291.95544765539,"d":"$28,291.96"}}]
[9,{"$f":"D9","v":{"v":28291.95544765539,"d":"$28,291.96"}},{"v":4130.625495357686,"d":"$4,130.63"},{"$f":"B10-C10","v":{"v":24161.329952297703,"d":"$24,161.33"}}]
[10,{"$f":"D10","v":{"v":24161.329952297703,"d":"$24,161.33"}},{"v":3527.5541730354644,"d":"$3,527.55"},{"$f":"B11-C11","v":{"v":20633.77577926224,"d":"$20,633.78"}}]
[11,{"$f":"D11","v":{"v":20633.77577926224,"d":"$20,633.78"}},{"v":3012.531263772287,"d":"$3,012.53"},{"$f":"B12-C12","v":{"v":17621.244515489954,"d":"$17,621.24"}}]
[12,{"$f":"D12","v":{"v":17621.244515489954,"d":"$17,621.24"}},{"v":2572.701699261533,"d":"$2,572.70"},{"$f":"B13-C13","v":{"v":15048.54281622842,"d":"$15,048.54"}}]