{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Form","index":0,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,1,6],[0,7,1,8],[8,2,8,4],[9,2,9,4],[3,2,3,4],[4,2,4,4],[3,0,3,1],[7,0,7,11],[3,10,4,11],[6,6,6,11],[4,0,4,1],[5,6,5,7],[3,6,4,9],[6,0,6,4],[51,10,51,11],[21,3,21,4],[21,5,21,10],[23,1,23,2],[22,1,22,2],[50,10,50,11],[22,5,22,10],[21,1,21,2],[46,10,46,11],[47,10,47,11],[47,7,47,9],[24,1,24,2],[22,3,22,4],[23,3,23,4],[24,3,24,4],[23,5,23,10],[8,0,8,1],[9,0,9,1],[16,3,16,4],[11,0,11,1],[24,5,24,10],[18,1,18,2],[10,2,10,4],[10,0,10,1],[13,6,13,8],[11,2,11,4],[42,2,42,4],[17,1,17,2],[14,3,14,4],[42,7,42,8],[11,6,11,7],[17,3,17,4],[42,0,42,1],[14,1,14,2],[15,3,15,4],[33,0,33,10],[49,1,49,4],[28,0,28,10],[18,3,18,4],[29,0,29,10],[48,7,48,9],[49,7,49,9],[49,10,49,11],[32,0,32,10],[37,0,37,10],[48,10,48,11],[46,7,46,9],[44,0,44,11],[31,1,31,10],[38,0,38,10],[27,1,27,10],[42,9,42,11],[50,7,50,9],[8,6,8,7],[51,1,51,4],[36,0,36,10],[13,9,13,10],[13,0,13,4],[15,1,15,2],[16,1,16,2],[46,1,47,4],[45,0,47,0],[8,8,8,11],[9,8,9,11],[10,8,10,11],[11,8,11,11],[9,6,9,7],[10,6,10,7]]}
["NON-STAFF EXPENSES CLAIM FORM",null,null,null,null,null,null,"FORM UEA 6"]
[]
["Name of claimant (in CAPITALS)",null,null,null,null,null,null,"Currency claim to be paid in (form will be returned if left blank):"]
["First Name:",null," ",null,null,null,"Sterling (default)"]
["Surname:"]
["Purpose of Journey/Expense Claim:",null,null,null,null,null,"Date(s) of Journey:"]
[]
["Bank/Building Society Details (Please complete ALL of one of the sections below)"]
["UK Bank Name:",null,null,null,null,null,"Foreign Bank Name:"]
["Beneficiary Name:",null,null,null,null,null,"Beneficiary Name:"]
["Sort Code:",null,null,null,null,null,"IBAN/Account Number:"]
["Account Number:",null,null,null,null,null,"Swift Code:"]
["Travelling Expenses (Road/Rail)"]
["Journey Details",null,null,null,null,null,"Rail",null,null,"Car/Other Vehicle"]
["Date","To",null,"From",null,null,"Single","Return","2nd Class","Mileage","Rate","Amount"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16>0,J16*K16,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K17>0,J17*K17,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K18>0,J18*K18,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K19>0,J19*K19,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L16:L19)","v":0}]
["Other travelling expenses (please specify below):"]
["Date","To",null,"From",null,"Journey Details"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L23:L25)","v":0}]
["Hotels & Meals (Please attach all relevant bills and give details):"]
["Hotels:"]
[]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L28:L30)","v":0}]
["Meals:"]
[]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L32:L34)","v":0}]
["Other expenses (please specify below):"]
[]
[]
[]
["There is no scale of allowance for meals and reasonable expenses, ",null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L37:L39)","v":0}]
["necessarily incurred, will be refunded on production of receipts.",null,null,null,null,null,null,"TOTAL AMT CLAIMED:",null,{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,2,0),\"\")","v":"£"},{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,3,0),\"\")","v":"GBP"},{"$f":"SUM(L20+L26+L31+L35+L40)","v":0}]
[]
["Signature of claimant:",null,null,null,null,null,null,"Date form completed:"]
[]
["FOR OFFICE USE ONLY"]
["Certified for payment by (please sign):"]
[null,null,null,null,null,null,"Acct Code","Charge Code",null,null,"Amount"]
[]
[]
["Print Name:"]
[]
["Date:",null,null,null,null,null,null,"TOTAL CLAIMED: ",null,{"$f":"IF(G4>\"\",VLOOKUP(G4,Data,3,0),\"\")","v":"GBP"},{"$f":"IF(SUM(K48:K51) = L41,SUM(K48:L51),\"CHECK TOTALS\")","v":0}]

{"sheet":"Data","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Australian Dollars","$","AUD"]
["Canadian Dollars","$","CAD"]
["Czech Koruny","Kč","CZK",null,null,0.2]
["Danish Krona","kr","DKK",null,null,0.24]
["Euros","€","EUR",null,null,0.4]
["Hong Kong Dollars","$","HKD",null,null,0.45]
["Hungarian Florint","Ft","HUF"]
["Icelandic Krona","kr","ISK"]
["Indian Ruppee",null,"INR"]
["Japanese Yen","¥","JPY"]
["Mexican Peso","$","MXN"]
["New Zealand Dollars","$","NZD"]
["Norwegian Krona","kr","NOK"]
["Polish Zlotti","zł","PLN"]
["Singapore Dollar","$","SGD"]
["South African Rand","R","ZAR"]
["Sterling (default)","£","GBP"]
["Swedish Kronor","kr","SEK"]
["Swiss Francs","CHF","CHF"]
["Thailand Baht","฿","THB"]
["United States Dollars","$","USD"]