{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Actual Car Expenses","List5 (2)"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Actual Car Expenses","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,2,6,4],[7,2,7,4],[7,6,7,7],[9,0,9,4],[9,6,9,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,1]]}
[]
["13-000-RBIZZ"]
["team@rbizz.com.au"]
["ACTUAL CAR EXPENSES"]
["IMPORTANT : Please select a category to each expense in column C. For the list of category please refer column G. Please scroll the dropdown list to select the right category."]
[{"$nulls":7},{"$f":"SUM(D12:D499)","v":0}]
[null,"Name",{"$nulls":5},{"$f":"SUM(H13:H15,H17:H20,H22:H31,H33:H34,H36,H38:H46,H48:H50,H52:H75)","v":0}]
[null,"Financial Year",{"$nulls":4},{"$f":"IF(H6=H7,\"\",\"You have missed selecting category in column C\")","v":""}]
[]
["Actual Car Expenses Details",{"$nulls":5},"Actual Car Expenses Summary"]
["Date","Description","Select Expense Category - Ref Colm G","Amount","Notes",null,null,"Amount"]
[{"$nulls":6},"EXPENSE:"]
[{"$nulls":6},"Car - Fuel and oil",{"$f":"SUMIF($C$12:$C$506,G13,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Car - Registration",{"$f":"SUMIF($C$12:$C$506,G14,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Car - Insurance",{"$f":"SUMIF($C$12:$C$506,G15,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Car - Repairs and maintenance",{"$f":"SUMIF($C$12:$C$506,G16,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Car - Other Expenses",{"$f":"SUMIF($C$12:$C$506,G17,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Car - Interest paid",{"$f":"SUMIF($C$12:$C$506,G18,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Car - Finance leasing charges",{"$f":"SUMIF($C$12:$C$506,G19,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Car - Depreciation",{"$f":"SUMIF($C$12:$C$506,G20,$D$12:$D$506)","v":0}]
[{"$nulls":6},"Toal Actual Car Expenses",{"$f":"SUM(H13:H20)","v":0}]

{"sheet":"List5 (2)","index":1,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+'Actual Car Expenses'!G13","v":"Car - Fuel and oil"}]
[{"$f":"+'Actual Car Expenses'!G14","v":"Car - Registration"}]
[{"$f":"+'Actual Car Expenses'!G15","v":"Car - Insurance"}]
[{"$f":"+'Actual Car Expenses'!G17","v":"Car - Other Expenses"}]
[{"$f":"+'Actual Car Expenses'!G18","v":"Car - Interest paid"}]
[{"$f":"+'Actual Car Expenses'!G19","v":"Car - Finance leasing charges"}]
[{"$f":"+'Actual Car Expenses'!G20","v":"Car - Depreciation"}]