{"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":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,11],[25,3,25,4],[24,5,24,10],[1,0,2,6],[1,7,2,8],[9,2,9,4],[10,2,10,4],[4,2,4,4],[5,2,5,4],[4,0,4,1],[8,0,8,11],[4,10,5,11],[7,6,7,11],[5,0,5,1],[18,1,18,2],[6,6,6,7],[4,6,5,9],[7,0,7,4],[11,2,11,4],[11,0,11,1],[9,0,9,1],[10,0,10,1],[52,10,52,11],[22,3,22,4],[22,5,22,10],[24,1,24,2],[23,1,23,2],[51,10,51,11],[23,5,23,10],[22,1,22,2],[47,10,47,11],[48,10,48,11],[48,7,48,9],[25,1,25,2],[43,2,43,4],[15,3,15,4],[43,7,43,8],[12,6,12,7],[18,3,18,4],[43,0,43,1],[15,1,15,2],[16,3,16,4],[34,0,34,10],[17,3,17,4],[12,0,12,1],[25,5,25,10],[19,1,19,2],[23,3,23,4],[24,3,24,4],[14,6,14,8],[12,2,12,4],[50,1,50,4],[29,0,29,10],[19,3,19,4],[30,0,30,10],[49,7,49,9],[50,7,50,9],[50,10,50,11],[33,0,33,10],[38,0,38,10],[49,10,49,11],[47,7,47,9],[45,0,45,11],[32,1,32,10],[39,0,39,10],[28,1,28,10],[43,9,43,11],[51,7,51,9],[9,6,9,7],[52,1,52,4],[37,0,37,10],[14,9,14,10],[14,0,14,4],[16,1,16,2],[17,1,17,2],[47,1,48,4],[46,0,48,0],[9,8,9,11],[10,8,10,11],[11,8,11,11],[12,8,12,11],[10,6,10,7],[11,6,11,7]]}
["Please note - expense form and receipts must be merged into one PDF before submitting"]
["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(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,null,null,{"$f":"IF(K20>0,J20*K20,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"IF(G5>\"\",VLOOKUP(G5,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L17:L20)","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(G5>\"\",VLOOKUP(G5,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L24:L26)","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(G5>\"\",VLOOKUP(G5,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L29:L31)","v":0}]
["Meals:"]
[]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"IF(G5>\"\",VLOOKUP(G5,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L33:L35)","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(G5>\"\",VLOOKUP(G5,Data,2,0),\"\")","v":"£"},{"$f":"SUM(L38:L40)","v":0}]
["necessarily incurred, will be refunded on production of receipts.",null,null,null,null,null,null,"TOTAL AMT CLAIMED:",null,{"$f":"IF(G5>\"\",VLOOKUP(G5,Data,2,0),\"\")","v":"£"},{"$f":"IF(G5>\"\",VLOOKUP(G5,Data,3,0),\"\")","v":"GBP"},{"$f":"SUM(L21+L27+L32+L36+L41)","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(G5>\"\",VLOOKUP(G5,Data,3,0),\"\")","v":"GBP"},{"$f":"IF(SUM(K49:K52) = L42,SUM(K49:L52),\"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"]