{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[14,1,14,6],[6,0,9,0],[5,1,5,4],[6,1,6,4],[7,1,7,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[5,6,5,7],[6,6,6,7],[8,1,8,4],[8,6,8,7],[5,8,5,10],[6,8,6,10],[9,8,9,10],[10,8,10,10],[11,8,11,10],[15,1,15,6],[16,1,16,6],[17,1,17,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[24,1,24,6],[33,0,33,9],[30,1,30,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6]]}
[]
[null,null,null,null,"EXPENSES CLAIM FORM"]
[]
[]
[]
["Name:",null,null,null,null,null,"Event or Committee"]
["Address:",null,null,null,null,null,"Email address"]
[]
[null,null,null,null,null,null,"Bank details:"]
[null,null,null,null,null,null,"Account name"]
["Post Code:",null,null,null,null,null,"Sort Code"]
["Tel No.",null,null,null,null,null,"Account number"]
[]
[]
["Date","Details of expense (name and what for) or journey travelled.    (Give start and end point)",null,null,null,null,null,"Miles claimed","Vehicle Type","Mileage claim","Other cost"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H16=\"\",0,IF(I16=Sheet2!$A$2,Sheet2!$B$2,IF(I16=Sheet2!$A$3,Sheet2!$B$3,IF(I16=Sheet2!$A$4,Sheet2!$B$4,IF(I16=Sheet2!$A$5,Sheet2!$B$5,0)))))*H16","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H17=\"\",0,IF(I17=Sheet2!$A$2,Sheet2!$B$2,IF(I17=Sheet2!$A$3,Sheet2!$B$3,IF(I17=Sheet2!$A$4,Sheet2!$B$4,IF(I17=Sheet2!$A$5,Sheet2!$B$5,0)))))*H17","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H18=\"\",0,IF(I18=Sheet2!$A$2,Sheet2!$B$2,IF(I18=Sheet2!$A$3,Sheet2!$B$3,IF(I18=Sheet2!$A$4,Sheet2!$B$4,IF(I18=Sheet2!$A$5,Sheet2!$B$5,0)))))*H18","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H19=\"\",0,IF(I19=Sheet2!$A$2,Sheet2!$B$2,IF(I19=Sheet2!$A$3,Sheet2!$B$3,IF(I19=Sheet2!$A$4,Sheet2!$B$4,IF(I19=Sheet2!$A$5,Sheet2!$B$5,0)))))*H19","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H20=\"\",0,IF(I20=Sheet2!$A$2,Sheet2!$B$2,IF(I20=Sheet2!$A$3,Sheet2!$B$3,IF(I20=Sheet2!$A$4,Sheet2!$B$4,IF(I20=Sheet2!$A$5,Sheet2!$B$5,0)))))*H20","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H21=\"\",0,IF(I21=Sheet2!$A$2,Sheet2!$B$2,IF(I21=Sheet2!$A$3,Sheet2!$B$3,IF(I21=Sheet2!$A$4,Sheet2!$B$4,IF(I21=Sheet2!$A$5,Sheet2!$B$5,0)))))*H21","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H22=\"\",0,IF(I22=Sheet2!$A$2,Sheet2!$B$2,IF(I22=Sheet2!$A$3,Sheet2!$B$3,IF(I22=Sheet2!$A$4,Sheet2!$B$4,IF(I22=Sheet2!$A$5,Sheet2!$B$5,0)))))*H22","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H23=\"\",0,IF(I23=Sheet2!$A$2,Sheet2!$B$2,IF(I23=Sheet2!$A$3,Sheet2!$B$3,IF(I23=Sheet2!$A$4,Sheet2!$B$4,IF(I23=Sheet2!$A$5,Sheet2!$B$5,0)))))*H23","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H24=\"\",0,IF(I24=Sheet2!$A$2,Sheet2!$B$2,IF(I24=Sheet2!$A$3,Sheet2!$B$3,IF(I24=Sheet2!$A$4,Sheet2!$B$4,IF(I24=Sheet2!$A$5,Sheet2!$B$5,0)))))*H24","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H25=\"\",0,IF(I25=Sheet2!$A$2,Sheet2!$B$2,IF(I25=Sheet2!$A$3,Sheet2!$B$3,IF(I25=Sheet2!$A$4,Sheet2!$B$4,IF(I25=Sheet2!$A$5,Sheet2!$B$5,0)))))*H25","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H26=\"\",0,IF(I26=Sheet2!$A$2,Sheet2!$B$2,IF(I26=Sheet2!$A$3,Sheet2!$B$3,IF(I26=Sheet2!$A$4,Sheet2!$B$4,IF(I26=Sheet2!$A$5,Sheet2!$B$5,0)))))*H26","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H27=\"\",0,IF(I27=Sheet2!$A$2,Sheet2!$B$2,IF(I27=Sheet2!$A$3,Sheet2!$B$3,IF(I27=Sheet2!$A$4,Sheet2!$B$4,IF(I27=Sheet2!$A$5,Sheet2!$B$5,0)))))*H27","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H28=\"\",0,IF(I28=Sheet2!$A$2,Sheet2!$B$2,IF(I28=Sheet2!$A$3,Sheet2!$B$3,IF(I28=Sheet2!$A$4,Sheet2!$B$4,IF(I28=Sheet2!$A$5,Sheet2!$B$5,0)))))*H28","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H29=\"\",0,IF(I29=Sheet2!$A$2,Sheet2!$B$2,IF(I29=Sheet2!$A$3,Sheet2!$B$3,IF(I29=Sheet2!$A$4,Sheet2!$B$4,IF(I29=Sheet2!$A$5,Sheet2!$B$5,0)))))*H29","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H30=\"\",0,IF(I30=Sheet2!$A$2,Sheet2!$B$2,IF(I30=Sheet2!$A$3,Sheet2!$B$3,IF(I30=Sheet2!$A$4,Sheet2!$B$4,IF(I30=Sheet2!$A$5,Sheet2!$B$5,0)))))*H30","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H31=\"\",0,IF(I31=Sheet2!$A$2,Sheet2!$B$2,IF(I31=Sheet2!$A$3,Sheet2!$B$3,IF(I31=Sheet2!$A$4,Sheet2!$B$4,IF(I31=Sheet2!$A$5,Sheet2!$B$5,0)))))*H31","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J31)","v":0},{"$f":"SUM(K16:K31)","v":0}]
["Total Claim",null,null,null,null,null,null,null,null,null,{"$f":"+K32+J32","v":0}]
["I certify that these expenses were necessarily incurred whilst undertaking authorised Swim England Hertfordshire duties and have not been claimed elsewhere."]
[]
[]
["How to complete the form"]
[]
["Enter your name and contact details in the apropriate boxes"]
["Give your bank details where indicated - all claims will be paid by direct bank transfer"]
["The form is designed to be completed using the excel spreadsheet, it can be printed if necessary"]
["Enter the expense details line by line and put the amount to be claimed in the \"Other cost column\""]
["For mileage claims only enter the number of miles in the mileage column"]
["Next using the dropdown in the vehicle type column enter your vehicle type "]
["  - the mileage claim will automatically be entered in the mileage column"]
[]
["Mileage rates used from April 2026 are as follows:"]
[]
["Petrol/diesel",null,"55p per mile"]
["Hybrid",null,"55p per mile"]
["Electric",null,"55p per mile"]
["Motor bike",null,"24p per mile"]
[]
["Once completed send the form, together with copies of the relevant receipts, to the event organiser"]
["for them to approve and pass to the Finance Officer for payment"]

{"sheet":"Sheet2","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Vehicle Type","Fuel rates"]
["Petrol/diesel",0.55000000000000004]
["Hybrid",0.55000000000000004]
["Electric",0.55000000000000004]
["Motor bike",0.24]
[null,0]