{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Calculation","index":0,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[32,5,32,7],[33,3,50,3],[0,5,0,7],[1,5,1,7]]}
[null,null,null,"PAYG Withholding Variation - Car Expense Estimate",null,"Client Name",null,null,null,null,null,"HIDE"]
[null,null,null,"Year Ended 30 June 2018",null,"Preparer Name"]
[]
[]
[]
[null,null,null,"Car Details","Car 1","Car 2","Car 3"]
[null,null,null,"Description of Car"]
[null,null,null,"Number of Months for Estimate"]
[null,null,null,"Fuel Per Month"]
[null,null,null,"Lease Payments Per Month"]
[]
[null,null,null,"Estimate of Expenses"]
[null,null,null,"Fuel Per Annum",{"$f":"E8*E9","v":0},{"$f":"IF(F9>0,F9*F8,0)","v":0},{"$f":"IF(G9>0,G9*G8,0)","v":0}]
[null,null,null,"Registration"]
[null,null,null,"Insurance - Comprehensive"]
[null,null,null,"Insurance - Third Party"]
[null,null,null,"Repairs & Maintenance"]
[null,null,null,"Interest"]
[null,null,null,"Lease Payments",{"$f":"IF(E10>0,E10*E8,0)","v":0},{"$f":"IF(F10>0,F10*F8,0)","v":0},{"$f":"IF(G10>0,G10*G8,0)","v":0}]
[null,null,null,"Depreciation"]
[null,null,null,"Tyres"]
[]
[]
[null,null,null,null,null,null,null,"Summary"]
[null,null,null,"Total Car Expenses",{"$f":"SUM(E13:E24)","v":0},{"$f":"SUM(F13:F24)","v":0},{"$f":"SUM(G13:G24)","v":0},{"$f":"SUM(E25:G25)","v":0}]
[null,null,null,"Times Business Use Per Log Book"]
[null,null,null,"Work-Related Car Expenses",{"$f":"E25*E26","v":0},{"$f":"F25*F26","v":0},{"$f":"G25*G26","v":0},{"$f":"SUM(E27:G27)","v":0}]
[null,null,null,"Total Annual Allowance",null,null,null,{"$f":"SUM(E28:G28)","v":0}]
[null,null,null,"Annual Percentage Expended",{"$f":"IF(E28>0,E27/E28,0)","v":0},{"$f":"IF(F28>0,F27/F28,0)","v":0},{"$f":"IF(G28>0,G27/G28,0)","v":0},{"$f":"IF(H28>0,H27/H28,0)","v":0}]
[]
[]
[]
[null,null,null,"Notes",null,"DIY Calculations",null,null,null,null,null,{"$f":"IF(OR($D$34<>0,SUM($F$34:$H$51)<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($D$34<>0,SUM($F$34:$H$51)<>0),0,\"blank\")","v":"blank"}]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[null,null,null,null,null,null,null,null,null,null,null,"blank"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"blank\"","v":"blank"}]