{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Previously Claimed","First Year Claimed"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Previously Claimed","index":0,"n_rows":80,"n_cols":17,"rows_kept":80,"cut":false,"hidden":false,"merged":[[6,4,6,5],[8,15,10,15],[4,16,7,16],[0,8,0,10],[1,8,1,10],[6,7,6,8],[6,9,6,10]]}
[null,null,null,"PAYG Withholding Variation - Depreciation Estimate",null,null,null,null,"Client Name",null,null,null,null,null,null,"HIDE"]
[null,null,null,{"$f":"CONCATENATE(\"Year Ended 30 June \",P14)","v":"Year Ended 30 June 2018"},null,null,null,null,"Preparer Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"blank\"","v":"blank"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this sheet if a depreciation schedule is available for either of the two prior years, otherwise go to the \"First Year Claimed\" sheet"]
[]
[null,null,null,null,"Depreciation Schedule for",null,"Select Year",{"$f":"IF(G7=\"Select Year\",0,G7+1)","v":0},null,{"$f":"IF(G7=LLY,H7+1,0)","v":0}]
[null,null,null,null,"Rate","Cost","CWDV",{"$f":"IF(G7=\"Select Year\",\"\",\"Depn\")","v":""},{"$f":"IF(G7=\"Select Year\",\"\",\"CWDV\")","v":""},{"$f":"IF(G7=LLY,\"Depn\",\"\")","v":""},{"$f":"IF(G7=LLY,\"CWDV\",\"\")","v":""}]
[null,null,null,"Prime Cost Method",null,null,null,null,null,null,null,null,null,null,null,"Financial Year Control"]
[null,null,null,null,null,null,null,{"$f":"IF(AND($G$7<>\"Please Select\",G10>0),MIN(G10,E10*F10),0)","v":0},{"$f":"IF($G$7<>\"Please Select\",G10-H10,0)","v":0},{"$f":"IF(AND($G$7=$P$18,I10>0),MIN(I10,F10*E10),0)","v":0},{"$f":"IF(AND($G$7=$P$18,I10>0),I10-J10,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($G$7<>\"Please Select\",G11>0),MIN(G11,E11*F11),0)","v":0},{"$f":"IF($G$7<>\"Please Select\",G11-H11,0)","v":0},{"$f":"IF(AND($G$7=$P$18,I11>0),MIN(I11,F11*E11),0)","v":0},{"$f":"IF(AND($G$7=$P$18,I11>0),I11-J11,0)","v":0},null,null,null,{"$f":"IF(OR(D11<>0,E11<>0,F11<>0,G11<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,{"$f":"IF(OR(D12<>0,E12<>0,F12<>0,G12<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank","Variation Year"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank",2018]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank","CWDV Year"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank","Select Year"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank",{"$f":"P14-2","v":2016}]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank",{"$f":"P14-1","v":2017}]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank","Depn LVP"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank",0.375]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank","Days in Year"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank",365]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank","Dates in Year"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank","2017-07-01"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank",{"$f":"EOMONTH(FirstDay,11)","v":"2018-06-30"}]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,"Prime Cost Method Totals",null,{"$f":"SUM(F10:F39)","v":0},0,0,0,0,0]
[]
[]
[null,null,null,"Diminishing Value Method"]
[null,null,null,null,null,null,null,{"$f":"IF(AND($G$7<>\"Please Select\",G44>0),G44*E44,0)","v":0},{"$f":"IF($G$7<>\"Please Select\",G44-H44,0)","v":0},{"$f":"IF(AND($G$7=$P$18,I44>0),I44*E44,0)","v":0},{"$f":"IF(AND($G$7=$P$18,I44>0),I44-J44,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($G$7<>\"Please Select\",G45>0),G45*E45,0)","v":0},{"$f":"IF($G$7<>\"Please Select\",G45-H45,0)","v":0},{"$f":"IF(AND($G$7=$P$18,I45>0),I45*E45,0)","v":0},{"$f":"IF(AND($G$7=$P$18,I45>0),I45-J45,0)","v":0},null,null,null,{"$f":"IF(OR(D45<>0,E45<>0,F45<>0,G45<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,null,0,0,{"$f":"IF(AND($G$7=$P$18,I73>0),I73*E73,0)","v":0},0]
[null,null,null,"Diminishing Value Method Totals",null,{"$f":"SUM(F44:F73)","v":0},0,0,0,0,0]
[]
[]
[null,null,null,"Low Value Pool",null,null,null,{"$f":"IF(G77>0,G77*Lvp,0)","v":0},{"$f":"G77-H77","v":0},{"$f":"IF(AND($G$7=P18,I77>0),I77*Lvp,0)","v":0},{"$f":"IF(AND($G$7=$P$18,I77>0),I77-J77,0)","v":0}]
[]
[]
[null,null,null,"Grand Total",null,{"$f":"F40+F74+F77","v":0},0,0,0,0,0]

{"sheet":"First Year Claimed","index":1,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":false,"merged":[[6,12,9,12],[4,12,5,12],[0,6,0,7],[1,6,1,7]]}
[null,null,null,"PAYG Withholding Variation - Depreciation Estimate",null,null,"Client Name",null,null,null,null,"HIDE"]
[null,null,null,{"$f":"'Previously Claimed'!D2","v":"Year Ended 30 June 2018"},null,null,"Preparer Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"blank\"","v":"blank"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[]
[null,null,null,null,null,null,"Date Assets Acquired   ",null,null,null,null,null,"Use this sheet if the property has been acquired during the variation year, otherwise go to the \"Previously Claimed\" sheet"]
[]
[null,null,null,null,"Depn","Initial","Depn to","CWDV at"]
[null,null,null,null,"Rate","Cost",{"$f":"LastDay","v":"2018-06-30"},{"$f":"G10","v":"2018-06-30"}]
[null,null,null,"Prime Cost Method"]
[null,null,null,null,null,null,{"$f":"F12*E12/Days*($G$10-$H$7+1)","v":0},{"$f":"F12-G12","v":0}]
[null,null,null,null,null,null,0,{"$f":"F13-G13","v":0},null,null,null,{"$f":"IF(OR(D13<>0,E13<>0,F13<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(OR(D14<>0,E14<>0,F14<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,{"$f":"F42*E42/Days*($G$10-$H$7+1)","v":0},{"$f":"F42-G42","v":0},null,null,null,"blank"]
[null,null,null,null,null,null,{"$f":"F43*E43/Days*($G$10-$H$7+1)","v":0},{"$f":"F43-G43","v":0}]
[null,null,null,"Prime Cost Method Totals",null,{"$f":"SUM(F12:F43)","v":0},{"$f":"SUM(G12:G43)","v":0},{"$f":"SUM(H12:H43)","v":0}]
[]
[]
[null,null,null,"Diminishing Value Method"]
[null,null,null,null,null,null,{"$f":"F48*E48/Days*($G$10-$H$7+1)","v":0},{"$f":"F48-G48","v":0}]
[null,null,null,null,null,null,0,{"$f":"F49-G49","v":0},null,null,null,{"$f":"IF(OR(D49<>0,E49<>0,F49<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0,null,null,null,"blank"]
[null,null,null,null,null,null,0,0]
[null,null,null,"Diminishing Value Method Totals",null,{"$f":"SUM(F48:F77)","v":0},{"$f":"SUM(G48:G77)","v":0},{"$f":"SUM(H48:H77)","v":0}]
[]
[]
[null,null,null,"Low Value Pool",null,null,{"$f":"F81*Lvp/2","v":0},{"$f":"F81-G81","v":0}]
[]
[]
[null,null,null,"Grand Total",null,{"$f":"F44+F78+F81","v":0},{"$f":"G44+G78+G81","v":0},{"$f":"H44+H78+H81","v":0}]