{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Mileage Form","Extended Mileage Form","Sheet2"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Mileage Form","index":0,"n_rows":62,"n_cols":9,"rows_kept":62,"merged":[[2,2,2,8],[6,4,6,5],[8,4,8,5],[10,4,10,7],[12,4,12,5],[14,4,14,5],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[26,3,26,7],[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,3,31,7],[32,3,32,7],[33,3,33,7],[34,3,34,7],[35,3,35,7],[36,3,36,7],[47,4,47,5],[49,4,49,5],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4]]}
[]
[]
[null,null,"Mileage Claim Form  "]
[]
[]
[]
[{"$nulls":3},"For the Month of:     "]
[]
[{"$nulls":3},"Name:    "]
[]
[{"$nulls":3},"Address (Volunteers Only):"]
[]
[{"$nulls":3},"Engine Size:     ",null,null,"  (Please click on the the box to the left to select relevant engine size)"]
[]
[{"$nulls":3},"Registration No:     "]
[]
[]
[null,null,"Date","Destination",{"$nulls":4},"Miles"]
{"$rows_empty":20}
[{"$nulls":7},"Total Mileage Claim - Page 1     ",{"$f":"SUM(I19:I37)","v":0}]
[{"$nulls":7},"Total Mileage Claim - Page 2     ",{"$f":"+'Extended Mileage Form'!I57","v":0}]
[{"$nulls":7},"Total Mileage     ",{"$f":"SUM(I39:I40)","v":0}]
[]
[{"$nulls":7},"Rate Per Mile     ",{"v":0.45,"d":"£0.45"}]
[{"$nulls":7},"Claim     ",{"$f":"+I43*I41","v":0}]
[]
[null,null,"I certify the details in this claim are correct and that I hold the relevant insurance cover."]
[]
[null,null,"Signature of claimant",{"$nulls":3},"     Date:"]
[]
[null,null,"Manager's approval signature",{"$nulls":3},"     Date:"]
[]
[]
[]
[]
[null,null,"To be completed by Finance & Admin Department"]
[]
[null,null,"Supplier Number",{"$nulls":3},"Category","Rate per mile","Total"]
[null,null,"Net Invoice Value",{"$nulls":3},"Wear and Tear ",{"$f":"VLOOKUP($E$13,EngineData[],2,FALSE)","v":{"$error":"#N/A"}},{"$f":"+H58*$I$41","v":{"$error":"#N/A"}}]
[null,null,"Nominal Code",{"$nulls":3},"Petrol",{"$f":"VLOOKUP($E$13,EngineData[],3,FALSE)","v":{"$error":"#N/A"}},{"$f":"+H59*$I$41","v":{"$error":"#N/A"}}]
[null,null,"Cost Centre",{"$nulls":4},"Net Value",{"$f":"SUM(I58:I59)","v":{"$error":"#N/A"}}]
[null,null,"URN",{"$nulls":3},"VAT",{"$f":"VLOOKUP($E$13,EngineData[],4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+H61*$I$41","v":{"$error":"#N/A"}}]
[null,null,"Posted By",{"$nulls":4},"Gross Value",{"$f":"SUM(I60:I61)","v":{"$error":"#N/A"}}]

{"sheet":"Extended Mileage Form","index":1,"n_rows":57,"n_cols":9,"rows_kept":57,"merged":[[2,3,2,7],[3,3,3,7],[4,3,4,7],[5,3,5,7],[6,3,6,7],[7,3,7,7],[8,3,8,7],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[14,3,14,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[26,3,26,7],[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,3,31,7],[32,3,32,7],[33,3,33,7],[34,3,34,7],[35,3,35,7],[36,3,36,7],[37,3,37,7],[38,3,38,7],[39,3,39,7],[40,3,40,7],[41,3,41,7],[42,3,42,7],[43,3,43,7],[44,3,44,7],[45,3,45,7],[46,3,46,7],[47,3,47,7],[48,3,48,7],[49,3,49,7],[50,3,50,7],[51,3,51,7],[52,3,52,7],[53,3,53,7],[54,3,54,7]]}
[]
[]
[null,null,"Date","Destination",{"$nulls":4},"Miles"]
{"$rows_empty":53}
[{"$nulls":7},"Total Miles",{"$f":"SUM(I4:I55)","v":0}]

{"sheet":"Sheet2","index":2,"n_rows":32,"n_cols":13,"rows_kept":32,"hidden":true}
["Engine Size","Wear and Tear","Petrol/Deisel","VAT","Total"]
["Petrol: <=1400cc",{"v":0.31,"d":"0.3100"},0.1167,0.0233,{"v":0.44999999999999996,"d":"0.4500"}]
["Petrol: 1401 - 2000cc",{"v":0.29,"d":"0.2900"},0.1333,0.0267,{"v":0.45,"d":"0.4500"}]
["Petrol: >2001cc",{"v":0.22,"d":"0.2200"},0.1917,0.0383,{"v":0.45,"d":"0.4500"}]
["Diesel: <=1400cc",{"v":0.32,"d":"0.3200"},0.1083,0.0217,{"v":0.45,"d":"0.4500"}]
["Diesel: 1401 - 2000cc",{"v":0.32,"d":"0.3200"},0.1083,0.0217,{"v":0.45,"d":"0.4500"}]
["Diesel: Over 2001cc",{"v":0.29,"d":"0.2900"},0.1333,0.0267,{"v":0.45,"d":"0.4500"}]
{"$rows_empty":14}
[{"$nulls":4},"PETROL",{"$nulls":5},"DIESEL"]
[]
["VAT ",null,"1400cc or less",null,"1401 - 2000cc",null,"Over 2000cc",null,"1400cc or less",null,"1401 - 2000cc",null,"Over 2000cc"]
["RATE"]
["O",null,0.31,null,0.29,null,0.22,null,0.32,null,0.32,null,0.29]
[]
[{"v":0.2,"d":"20.00%"},null,0.1167,null,0.1333,null,0.1917,null,0.1083,null,0.1083,null,0.1333]
[]
[null,null,0.0233,null,0.0267,null,0.0383,null,0.0217,null,0.0217,null,0.0267]
[]
[null,null,{"$f":"SUM(C26:C31)","v":0.44999999999999996},null,{"$f":"SUM(E26:E31)","v":0.45},null,{"$f":"SUM(G26:G31)","v":0.45},null,{"$f":"SUM(I26:I31)","v":0.45},null,{"$f":"SUM(K26:K31)","v":0.45},null,{"$f":"SUM(M26:M31)","v":0.45}]