{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Expenses Form","Admin drop downs","Vehicle drop downs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"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":"Expenses Form","index":0,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,7],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,5,6,6]]}
["Expenses Claim Form",null,null,null,null,"Admin use only"]
[]
["Employee Name",null,null,null,null,"VAT rate",null,0.2]
["Date",null,null,null,null,"VATable calculation",null,1.2]
["Authorised By"]
["Vehicle Type (for business mileage claims)",null,"Company Car - Diesel (over 2000cc)"]
[null,null,null,null,null,"Mileage rate\n(calculated from Vehicle Type)",null,{"$f":"IF(C6='Vehicle drop downs'!A1,'Vehicle drop downs'!B1, IF(C6='Vehicle drop downs'!A2,'Vehicle drop downs'!B2, IF(C6='Vehicle drop downs'!A3,'Vehicle drop downs'!B3, IF(C6='Vehicle drop downs'!A4,'Vehicle drop downs'!B4, IF(C6='Vehicle drop downs'!A5,'Vehicle drop downs'!B5, IF(C6='Vehicle drop downs'!A6,'Vehicle drop downs'!B6, IF(C6='Vehicle drop downs'!A7,'Vehicle drop downs'!B7, IF(C6='Vehicle drop downs'!A8,'Vehicle drop downs'!B8, IF(C6='Vehicle drop downs'!A9,'Vehicle drop downs'!B9, IF(C6='Vehicle drop downs'!A10,'Vehicle drop downs'!B10, IF(C6='Vehicle drop downs'!A11,'Vehicle drop downs'!B11, IF(C6='Vehicle drop downs'!A12,'Vehicle drop downs'!B12))))))))))))","v":0.19}]
[]
["Business Mileage"]
[]
[null,"Date","Expense","Description","Miles","Total","Ex VAT","VAT"]
[1,null,"Business Mileage",null,null,{"$f":"+E12*$H$7","v":0},{"$f":"+F12/$H$4","v":0},{"$f":"+F12-G12","v":0}]
[2,null,"Business Mileage",null,null,0,{"$f":"+F13/$H$4","v":0},{"$f":"+F13-G13","v":0}]
[3,null,"Business Mileage",null,null,0,0,0]
[4,null,"Business Mileage",null,null,0,0,0]
[5,null,"Business Mileage",null,null,0,0,0]
[6,null,"Business Mileage",null,null,0,0,0]
[7,null,"Business Mileage",null,null,0,0,0]
[8,null,"Business Mileage",null,null,0,0,0]
[9,null,"Business Mileage",null,null,0,0,0]
[10,null,"Business Mileage",null,null,0,0,0]
[11,null,"Business Mileage",null,null,0,0,0]
[12,null,"Business Mileage",null,null,0,0,0]
[13,null,"Business Mileage",null,null,0,0,0]
[14,null,"Business Mileage",null,null,0,0,0]
[15,null,"Business Mileage",null,null,0,0,0]
[null,null,null,"Total",{"$f":"SUM(E12:E26)","v":0},{"$f":"SUM(F12:F26)","v":0},{"$f":"SUM(G12:G26)","v":0},{"$f":"SUM(H12:H26)","v":0}]
[]
["Other Expenses"]
[]
[null,"Date","Expense","Description","VAT applicable?","Cost","Ex VAT","VAT"]
[null,"2016-01-15","Toll Fee","Travel to Covase Fleet Management (RG8 8NA) for monthly touch point","VAT applicable",6,{"$f":"IF(E32=\"no VAT\",F32,F32/$H$4)","v":5},{"$f":"IF(E32=\"no VAT\",,F32-G32)","v":1}]
[1,null,null,null,null,null,0,{"$f":"IF(E33=\"no VAT\",,F33-G33)","v":0}]
[2,null,null,null,null,null,0,{"$f":"IF(E34=\"no VAT\",,F34-G34)","v":0}]
[3,null,null,null,null,null,0,{"$f":"IF(E35=\"VAT applicable\",F35-G35,)","v":0}]
[4,null,null,null,null,null,0,0]
[5,null,null,null,null,null,0,0]
[6,null,null,null,null,null,0,0]
[null,null,null,"Total",null,{"$f":"SUM(F33:F38)","v":0},{"$f":"SUM(G33:G38)","v":0},{"$f":"SUM(H33:H38)","v":0}]
[]
[null,null,null,"Grand Total",null,{"$f":"F27+F39","v":0},{"$f":"G27+G39","v":0},{"$f":"H27+H39","v":0}]
[]
[]
[]
[]
[]
["Template provided by Covase Fleet Management | covase.co.uk | 0345 369 7100"]

{"sheet":"Admin drop downs","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["VAT applicable"]
["no VAT"]

{"sheet":"Vehicle drop downs","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Own Car up to 10,000 business miles (reimbursement based on MAP rates)",0.45]
["Own Car over 10,000 business miles (reimbursement based on MAP rates)",0.25]
["Company Car - Diesel (1600cc or less)",0.12]
["Company Car - Diesel (1601cc to 2000cc)",0.14000000000000001]
["Company Car - Diesel (over 2000cc)",0.19]
["Company Car - Petrol (1400cc or less)",0.13]
["Company Car - Petrol (1401cc to 2000cc)",0.15]
["Company Car - Petrol (over 2000cc)",0.24]
["Company Car - LPG (1400cc or less)",0.11]
["Company Car - LPG (1401cc to 2000cc)",0.13]
["Company Car - LPG (over 2000cc)",0.21]
["Company Car - Fully Electric",0.09]