{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Home 1","Home 2","Home 3","Front","Back","LOG","Help","Tax Help","Revision History","NoMacro","Calcs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Home 1","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,"Welcome to the University of Warwick"]
[null,null,null,null,null,null,null,"FP16a Travelling and Subsistence Allowances Claim Form"]
[null,null,null,null,null,null,null,"Tax year 2018-2019"]

{"sheet":"Home 2","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[[3,2,3,12],[11,2,11,12],[13,2,13,12],[4,2,4,12],[6,2,6,12],[8,2,8,12],[9,2,9,12]]}
[]
[]
[null,null,"To use the expense claim spreadsheet"]
[null,null,"When you have completed reading the introductory screens please enter the required personal information on the FRONT sheet. The FRONT should not normally need to be touched again; all data entry should be on the back sheet only.  "]
[null,null,"To ensure that users have the latest version of the spreadsheet, once you have downloaded the spreadsheet and entered your name, then this cannot be changed. Other users are required to download their own copy."]
[null,null,"Claiming expenses"]
[null,null,"When you need to claim expenses, open the spreadsheet you have saved and complete the BACK sheet, entering full details of all expenditure incurred. Using the PRINT button at the top of that sheet, Print a copy of the expenses, check, sign and submit. "]
[null,null,"Expenses cumulative Log"]
[null,null,"The LOG sheet is provided as an aid to completing tax returns and can provide annual totals of all expenses claimed together with the necessary calculations relating to using your own car / motorcycle / bicycle  for work. "]
[null,null,"To add details of a completed claim to the LOG sheet, press the ADD TO LOG button on the BACK sheet. Wait as the spreadsheet copies entries onto the LOG, appending to any items already present. When the operation has completed, save and close the spreadsheet."]
[null,null,"Subsequent claims"]
[null,null,"When you need to claim further expenses, clear previously claimed expenses from the BACK sheet using the CLEAR button and enter details of new expenses on the BACK sheet as above. The FRONT sheet should not need to be changed unless mileage rates have changed."]
[null,null,"New Tax Year"]
[null,null,"Obtain a fresh expense sheet directly from the University website for each new tax year. It should have been updated with revised rates and any other necessary changes."]

{"sheet":"Home 3","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[[13,2,13,12],[7,2,7,12],[11,2,11,12]]}
[]
[]
[]
[null,null,"NOTES:",null,null,null,null,"This worksheet does not obviate the need to provide receipts or "]
[null,null,null,null,null,null,null," adequate detail / explanation of expenses entered."]
[]
[null,null,"Do not remove worksheet protection. "]
[null,null,"Protected cells contain either the wording of the official University form, or they contain information which is created automatically from data entered elsewhere (indicated by text in red)."]
[]
[null,null,"Text in green needs only to be entered once and thereafter should not normally need to be changed"]
[]
[null,null,"PLEASE DO NOT COPY THIS WORKSHEET TO OTHER USERS. EACH USER SHOULD DOWNLOAD THEIR OWN COPY DIRECTLY FROM THE FINANCE PAGE OF THE UNIVERSITY WEBSITE TO ENSURE THAT THEIR COPY IS FULLY FUNCTIONAL AND TO THE LATEST REVISION. "]
[]
[null,null,"The first time the spreadsheet is used it should open to these Home sheets and thereafter to the Back sheet. If using for the first time and it has not opened to this Home sheet then please download a new copy from the Finance Website"]
[null,null,"Macros must be enabled for this spreadsheet to operate correctly."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Front","index":3,"n_rows":59,"n_cols":35,"rows_kept":59,"cut":false,"hidden":true,"merged":[[4,0,6,4],[8,22,8,34],[10,28,10,29],[6,16,6,21],[6,23,6,28],[9,18,9,34],[9,0,9,17],[10,31,10,32],[8,0,8,6],[8,7,8,17],[55,25,55,33],[55,15,55,24],[56,15,56,24],[56,0,56,14],[56,25,56,34],[57,25,57,34],[59,25,59,34],[59,15,59,24],[57,15,57,24],[58,15,58,24],[58,25,58,34],[52,20,52,22],[52,23,52,24],[52,26,52,34],[53,20,53,22],[53,23,53,24],[53,26,53,34],[50,20,50,22],[50,23,50,24],[50,26,50,34],[51,20,51,22],[51,23,51,24],[51,26,51,34],[48,20,48,22],[48,23,48,24],[48,26,48,34],[49,20,49,22],[49,23,49,24],[49,26,49,34],[30,26,30,34],[37,8,37,34],[47,20,47,22],[47,23,47,24],[47,26,47,34],[34,7,34,23],[35,7,35,23],[34,26,34,34],[35,26,35,34],[33,0,33,34],[13,21,13,34],[17,8,17,17],[15,22,15,32],[17,0,17,7],[29,26,29,31],[29,32,29,34],[28,26,28,34],[21,18,21,21],[23,26,23,34],[21,26,21,34],[24,26,24,31],[25,26,25,34],[27,26,27,31],[19,0,19,7],[11,22,11,34],[24,32,24,34],[27,32,27,34],[26,26,26,34],[14,0,14,17],[18,8,18,17],[19,8,19,17],[18,0,18,7],[12,0,12,17],[22,11,22,14],[22,18,22,21],[12,18,12,34],[21,11,21,14],[13,0,13,17],[13,18,13,20],[22,26,22,34]]}
["Enter information in tan shaded cells. Shading will be automatically cleared before printing."]
["After initial entry of personal information and mileage rates, this sheet should not need to be changed."]
["Red cells are calculated automatically and cannot be edited."]
["Car mileage rates shown are those applicable from January 2017."]
[null,null,null,null,null,null,null,null,null,"Claim for travelling and subsistence allowances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form FP16a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please use BLOCK CAPITALS  throughout"]
[null,null,null,null,null,null,null,null,null,"Period of claim: From: ",null,null,null,null,null,null,{"$f":"MIN(Back!$A$11:$A$24)","v":"00:00:00"},null,null,null,null,null,"to",{"$f":"MAX(Back!$A$11:$A$24)","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"(First & last date of claim)"]
[null,null,null,null,null,null,null,null,null,"Note: All claims should be submitted within 3 months of the expenditure being incurred"]
["First Name",null,null,null,null,null,null,"Surname",null,null,null,null,null,null,null,null,null,null,"Department:"]
[]
["Complete address & bank details if this is your first claim or revision to existing details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"University employee:",null,null,null,null,null,null,null,null,null,"YES",null,"/","NO"]
["Address for remittance advice:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job Title:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"email:",null,null,"@warwick.ac.uk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendor number: "]
["Bank/Building Society details",null,null,null,null,null,null,null,null,"Only complete these if you are a "]
["new claimant or have changed your bank details."]
["Bank Account no:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your Ref: (max 16 characters)"]
["Bank Sort code: "]
["Building Society Roll no:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Mileage Allowance:",null,null,null,null,null,"Insert total miles shown overleaf, rate per mile and calculate totals:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Back!D26","v":0},null,null,null,"miles at ",null,null,45,null,null,null,"p. Per mile. ",null,null,null,{"$f":"L22*S22/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Back!E26","v":0},null,null,null,"miles at ",null,null,45,null,null,null,"p. Per mile. ",null,null,null,{"$f":"L23*S23/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total mileage claimed",null,{"$f":"SUM(AA22:AI23)","v":0}]
[]
[null,null,null,"Travelling and Subsistence",null,null,null,null,null,null,"Expenses:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total shown overleaf supported by receipts",null,{"$f":"Back!K27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total expenditure coded below",null,{"$f":"AA24+AA26","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LESS:",null,null,"amount of","ADVANCE",null,null,null,null,null,"already received",null,{"$f":"Back!M1","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total reimbursement claimed / money returned",null,{"$f":"AA27-AA29","v":0}]
["I request reimbursement of the expenses, specified above, incurred necessarily on University business. I confirm that I have personally "]
["incurred the expenditiure and have not reclaimed it by any other method. "]
["In claiming business mileage for the use of my private vehicle, I confirm that I have valid & appropriate vehicle insurance for business use, my vehicle has a valid road fund licence & MOT certificate & is serviced & maintained in a safe & roadworthy condition. (The University of Warwick reserves the right to check documents & inspect private vehicles at any time.)"]
["Signature of claimant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,{"$f":"NOW()","v":"2018-06-01T14:41:47.570"}]
["Departmental Authorisation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["(Signature of departmental authorised signatory)"]
["Please print name and title:"]
["(Authorised departmental signatory)"]
["University-level authorisation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["(Signature of University-level authorised signatory for Heads of Departments only)"]
[]
["The signatures above are confirming that the journeys were authorised, the expenses were incurred on the business of the University"]
["and are properly payable by the University and that due consideration has been given to achieving value for money."]
["Expenditure Codes:"]
["General ledger code",null,null,null,null,null,null,"and",null,"Cost centre/Project/Internal order",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Description: Date, Place, Purpose"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(max 50 characters)"]
[]
[]
[]
[]
[]
[]
[]
[]
["For use in the HR Department",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Claim checked",null,null,null,null,null,null,null,null,null,"Voucher Number"]
["Date claimed received in the Payroll Office",null,null,null,null,null,null,null,null,null,null,null,null,null,null," Payroll Office"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Claim Approved"]

{"sheet":"Back","index":4,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":true,"merged":[[27,4,27,12],[26,10,26,11],[26,1,27,3],[6,0,9,0],[8,9,9,9],[8,8,9,8],[25,0,25,2],[26,6,26,9],[6,2,9,2],[6,3,6,5],[9,3,9,5],[8,7,9,7],[7,6,7,9],[8,6,9,6],[9,16,9,17],[7,12,9,12],[7,11,9,11],[7,10,9,10],[0,12,0,14],[7,13,9,13],[7,14,9,14]]}
[null,null,null,null,null,null,null,null,null,null,null,"Enter any advances already received>>",null,null,null,null,null,"Validation status flags>>>","DateVal","GenVal","Printed","Added"]
[null,null,null,null,null,null,null,"Red triangle in corner of cell  indicates help text is available. ",null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,"Scroll over cell to view.",null,null,"Go to Tools, Options, View & select"]
["d mmm yy",null,null,null,"Only enter daily total ","êêê",null,null,"Comment indicator if there are no red triangles visible.",null,null,null,null,null,null,null,null,null,"0 not checked","0 not checked","0 not printed","0 not added"]
["Claim date","Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These columns contain the ",null,"1 error","1 error","1 error","1 error"]
[{"$f":"Front!AA35","v":"2018-06-01T14:41:47.570"},{"$f":"Front!A10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sterling value of mileage claims",null,"2 done OK","2 done OK","2 done OK","2 done OK"]
["Date","Details of expenditure","Trip Single or Return","Distance by car",null,null,null,null,"Other Expenses claimed:","Receipts supporting amounts claimed must be attached",null,null,null,null,null,null,"for logging purposes.",null,null,null,null,null,"Sterling value of "]
[null,"(For each journey state purpose, start, intermediate and end points)",null,"First","Over","Daily","Travel and Subsistence",null,null,null,"\nHospitality","\nOther","Receipt  Ref","\nExchange Rate","Foreign Expenditure",null,"First","Over","Expense sum",null,null,null,"Foreign Expenditure"]
[null,"(Briefly explain reason for incurring expenditure)",null,100,100,"Total","Travel","Accomm-odation","Lunch","Evening Meal",null,null,null,null,null,null,100,200,"column for",null,null,null,"for manual transfer to"]
[null,null,null,"miles in any one day",null,null,null,null,null,null,null,null,null,null,null,null,"miles in any one day",null,"validation",null,null,null,"printable area of spreadsheet"]
[null,null,null,{"$f":"IF(F11=0,0,IF(F11>99,100,F11))","v":0},{"$f":"F11-D11","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"D11*Front!$S$22/100","v":0},{"$f":"E11*Front!$S$23/100","v":0},{"$f":"SUM(G11:L11)","v":0},null,null,null,{"$f":"IF(N11=\"\",\"\",O11/N11)","v":""}]
[null,null,null,{"$f":"IF(F12=0,0,IF(F12>99,100,F12))","v":0},{"$f":"F12-D12","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"D12*Front!$S$22/100","v":0},{"$f":"E12*Front!$S$23/100","v":0},{"$f":"SUM(G12:L12)","v":0},null,null,null,{"$f":"IF(N12=\"\",\"\",O12/N12)","v":""}]
[null,null,null,{"$f":"IF(F13=0,0,IF(F13>99,100,F13))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D13*Front!$S$22/100","v":0},{"$f":"E13*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,{"$f":"IF(F14=0,0,IF(F14>99,100,F14))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D14*Front!$S$22/100","v":0},{"$f":"E14*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,{"$f":"IF(F15=0,0,IF(F15>99,100,F15))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D15*Front!$S$22/100","v":0},{"$f":"E15*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D16*Front!$S$22/100","v":0},{"$f":"E16*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D17*Front!$S$22/100","v":0},{"$f":"E17*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D18*Front!$S$22/100","v":0},{"$f":"E18*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D19*Front!$S$22/100","v":0},{"$f":"E19*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D20*Front!$S$22/100","v":0},{"$f":"E20*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D21*Front!$S$22/100","v":0},{"$f":"E21*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D22*Front!$S$22/100","v":0},{"$f":"E22*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D23*Front!$S$22/100","v":0},{"$f":"E23*Front!$S$23/100","v":0},0,null,null,null,""]
[null,null,null,{"$f":"IF(F24=0,0,IF(F24>99,100,F24))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D24*Front!$S$22/100","v":0},{"$f":"E24*Front!$S$23/100","v":0},0,null,null,null,""]
[]
["Totals of mileage band carried overleaf to apply rates per mile",null,null,{"$f":"SUM(D11:D24)","v":0},0,0,0,0,0,0,0,0]
["FP16a \nrev date","Further guidance can be found in 'The Financial Regulations & Procedures Manual' section 16. These, and current travel and subsistence allowances, are available on-line by clicking the following link:",null,null,null,null,"Total sterling value of spend\ncarried overleaf",null,null,null,{"$f":"SUM(G26:L26)","v":0}]
["2018-06-01T14:41:47",null,null,null,"http://www2.warwick.ac.uk/services/humanresources/payroll/expenses"]

{"sheet":"LOG","index":5,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":true,"merged":[[2,0,3,8],[10,0,13,0],[10,2,13,2],[10,3,10,5],[13,16,13,17],[12,7,13,7],[12,8,13,8],[12,9,13,9],[11,14,13,14],[11,13,13,13],[11,6,11,9],[11,10,13,10],[11,11,13,11],[11,12,13,12],[12,6,13,6],[13,3,13,5]]}
["EXPENSES LOG SHEET",null,"WARNING:"]
["Note - a blue line is automatically added to separate each batch of expenses added to the log"]
["Tax  section: Note - From 1/1/17 Warwick  pays all mileage up to 10,000 in a tax year at 45p therefore there will be no possibility of a tax refund and this page is therefore redundant for that purpose",null,null,null,null,null,null,null,null,null,null,null,null,null,"figure in box 1.15 or 1.32 of your tax return. >>>>",null,1.1499999999999999,{"$f":"IF((R15-R6)>0,R15-R6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.32,{"$f":"IF((R6-R15)>0,R6-R15,\"\")","v":""}]
["A number in 1.15 indicates you have received more expenses than the HMRC authorised rate"]
["- you will be liable for tax on this, or a number in 1.32 indicates you have received less in expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL HMRC AUTHORISED MILEAGE RATE",{"$f":"Q8+R8","v":0}]
[" than the HMRC authorised rate - you should be eligible for a tax refund on that.",null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,"First 10,000","Over 10,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL cost @ HMRC Rates",{"$f":"R6","v":0},null,{"$f":"Q9*Q10/100","v":0},{"$f":"R9*R10/100","v":0}]
[null,null,null,null,null,null,null,null,"As of April 2016, these rates are valid for the tax year 2016 - 2017 >>>>>",null,null,null,null,"HMRC Authorised  Mileage rate p / mile ",null,null,45,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL MILEAGE",{"$f":"Q10+R10","v":0},null,{"$f":"IF(F15=0,0,IF(F15>9999,10000,F15))","v":0},{"$f":"F15-Q10","v":0}]
["Date","Details of expenditure","Trip Single or Return","Distance by car",null,null,null,null,"Other Expenses claimed: "]
[null,"(For each journey state purpose, start, intermediate and end points)",null,"First","Over","Daily","Travel and Subsistence",null,null,null,"\nHospitality","\nOther","Receipt  Ref","\nExchange Rate","Foreign Expend-iture",null,"First","Over"]
[null,"(Briefly explain reason for incurring expenditure)",null,100,100,"Total","Travel","Accommodation","Lunch","Evening Meal",null,null,null,null,null,null,100,100]
[null,null,null,"miles in any one day"]
["Claimed expenses - Totals logged to date",null,null,null,"Total Mileage logged>>",{"$f":"SUM(F16:F21704)","v":0},{"$f":"SUM(G16:G21704)","v":0},{"$f":"SUM(H16:H21704)","v":0},{"$f":"SUM(I16:I21704)","v":0},{"$f":"SUM(J16:J21704)","v":0},{"$f":"SUM(K16:K21704)","v":0},{"$f":"SUM(L16:L21704)","v":0},null,null,null,null,"Total Logged Mileage expenses claimed >>",{"$f":"SUM(Q16:R21704)","v":0}]

{"sheet":"Help","index":6,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":true,"merged":[[3,4,3,9],[16,2,16,7],[5,5,5,9],[4,5,4,9]]}
["Yellow Areas","Yellow areas of the FRONT and BACK are hints & tips etc and should  not print"]
[]
["Allowances","These are the maximum allowances as from 1 April 2017 as per Financial Regulations; these rates do not automatically cap values entered on the forms."]
[null,null,"Lunch","Dinner","Accommodation"]
[null,null,14,25,180,"London"]
[null,null,null,null,120,"Elsewhere"]
[]
[]
[null,"Mileage rates need entering on front at the appropriate rate"]
[null,null,"Car - first 10,000 miles per year @ 45p per mile"]
[null,null,"Motorcycle - 24p per mile"]
[null,null,"Bicycle - 20p per mile"]
[null,null,"Student rate - 25p per mile"]
[null,"Rates are normally reviewed every October. Please check that you are using the correct rate after than date."]
[null,"For further information view the University on-line reference information on the humanresources /payroll /expenses Pages of the website"]
[null,null,"Financial Procedures - Section 16 - Expenses Guidance & Procedures Manual"]
[null,null,"http://www2.warwick.ac.uk/services/humanresources/payroll/expenses/"]
["Foreign","Expenditure in Foreign currency should be entered in the last column of the white printable area of the spreadsheet and the corresponding exchange rate"]
["Expenses"," for that transaction(s)  in the previous column. The Sterling equivalent is calculated from these and is provided in the green shaded area to the right of the "]
[null,"white printable area. The Sterling value should be manually copied into the appropriate column(s) of the 'Other Expenses Claimed' area of the spreadsheet."]
[null,"All Foreign expenditure on any one line of the expense sheet must be at the same exchange rate."]
[]
["Dates","The spreadsheet uses the date on your computer. If that date is incorrect then please correct by using the Desktop START menu, "]
[null,"selecting Settings, then Control Panel and finally Date/Time to correct this. Regional Settings should be set to English (United Kingdom)."]
[null,"Note that you may not have the required privilege to do this and you may therefore have to contact your System Administrator to do it on your behalf."]
[]
["Advances","Enter these on box on back, which does not print, but is automatically transferred to front"]
[]
[]
["Printing","Just hit the button on the 'back' sheet, both sides should come out as single sided copies"]
[null,"Don't forget to sign the front sheet, today's date is printed automatically, if the clock on your computer is right !"]
[null,"Depending upon screen resolution and system fonts, some printable text may appear to spill over boxes on the screen, the printed "]
[null,"version should be satisfactory and the font size etc should not need to be adjusted."]
[]
["Copying","Ensure correct two sided orientation - DAY column of back should be aligned with BOTTOM of front sheet."]
["(using Ricoh","Put front & back sheets face UP in automatic document feeder."]
["copiers)","The bypass facility on Ricoh copiers does not work in two sided mode. Therefore, either:"]
[null,null,"- put white / purple etc paper (as appropriate) into main paper tray and select single sided original to double sided copy, or"]
[null,null,"- use bypass tray and feed paper through bypass twice. "]
[null,null,"  On the second feed-though, ensure printed side is face DOWN "]
[null,null,"  & do not change orientation of the copied sheet as it is moved from output tray back to the bypass feeder"]
["Log Sheet","There may be occasions where you need to modify entries on the log sheet. "]
[null,"Do not leave blank dates as the Add to log routine starts adding on the first blank line it finds."]
[null,"If you need to delete entries then delete entire rows using EDIT DELETE, rather than using the delete key"]
[]
["Locked Areas","Apart from those cells where data needs to be entered, all the rest of the spreadsheet is locked to prevent inadvertent changes, "]
[null,"Should changes be required, be particularly careful about adding or deleting rows or columns, as calculations "]
[null,"and macros will probably be adversely affected. "]
[]
["Hidden Sheet","There are 2 hidden sheets in this spreadsheet with additional design information and a revision history - they shouldn't need to be touched."]
[]
["File Name","Create a new spreadsheet for each tax year, ensuring the spreadsheet template is current, "]
[null,"and save with a file name such as \"my name expenses 2003-4.xls\""]
[]
["Problems &","If you have problems using this spreadsheet, or suggestions for improvements, then please email:  "]
["Comments","(double click on address below to create an email)"]
[null,"s.a.hicks@warwick.ac.uk"]
[]
["Created by Peter du Feu. Warwick Manufacturing Group.  "]

{"sheet":"Tax Help","index":7,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":true,"merged":[[4,0,4,2],[3,0,3,2]]}
["The  log sheet and tax calculator is provided as an aid to completing your tax return."]
[]
["Further information can be found at:"]
["http://wwwgov.uk/tax-relief-for-employees/travel-and-overnight-expenses",null,null,"Note that this document is not always fully up to date, in which "]
[null,null,null,"case the latest budget info on the HMRC website should be consulted."]
[]
["You should satisfy yourself that the data it produces is applicable to your particular circumstances before using"]
["this as a source for completing your tax return."]
[]
["No liability will be accepted for errors in this worksheet or for any consequences arising from its use."]
[]
["The HMRC authorised rates from 6th April 2011 are:",null,null,"Note these rates are valid for 2017-18"]
[null,"Cars and vans"]
[null,"On the first 10,000 miles in the tax year",null,null,"45p per mile"]
[null,"On each additional mile over 10,000 miles",null,null,"25p per mile"]
[null,"Motor cycles",null,null,"24p per mile"]
[null,"Bicycles",null,null,"20p per mile"]
["The appropriate rate should be entered into S9 & T9 on the LOG sheet"]
[]
["Users claiming expenses for use of their own motor or pedal cycles can use this spreadsheet and log"]
["in a similar way to that for cars by entering the appropriate HMRC and University rates into the"]
["appropriate cells of the spreadsheet. "]
["However a separate spreadsheet and log is required for claims relating to each different mode of transport."]
["Mixed claims MUST NOT be submitted on the same expense sheet."]

{"sheet":"Revision History","index":8,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Date","Detail"]
[]
["thoughts for future","remove print icon from toolbar on front and back sheets"]
[null,"tick box for credit card statement"]
[]
["2005-03-24","RDSO (bottom box front) is now known as RSS"]
[null,"Automatic FR11a revision date added to back sheet & manual removed from front"]
[null,"date format validation on back added"]
[null,"milage rate was split into 100/100/200+, now just 100/100+ front, back & log sheets amended, & code updated, removing col E from back & log & row 22 from front "]
[null,"layout change re address / bank details & comment added"]
[]
["2004-09-28","rates revised post 1st Oct FGPC"]
[]
["2004-06-15","compile error on opening at home3 "]
["errors","problem due to older versions of vba requiring all variables to be dim'd, added to open3 & fr11aupdate subs"]
[]
["2004-06-14","compile error on opening - most likely is missing library - refer to KB article 283806 "]
["errors","vba > tools > references > clear missing type library"]
[null,"code changed to replace chr(13/10) with vbcr/lf etc"]
[]
["2004-04-20","password set / unset in macro added for print front sheet"]
[null,"finance links changed to personnel / payroll"]
[]
["2004-03-16","new autopen to prompt for user name and step through introduction"]
[null,"oct 2003 check removed"]
[null,"tax rates checked OK for 2004-5, no change in budget"]
[]
["2003-10-23","rates revised post 1st Oct FGPC"]
[null,"check on open to see if spreadsheet has been emailed around"]
[]
["2003-04-04","log sheet, shading removed to ease legibility when printing"]
[null,"car rates 2003/4 no change in April 2003 budget"]
[]
["2003-03-24","clear to clear advances"]
[null,"clear to check if added to log flag set "]
[null,"hyperlinks to span complete cell only "]
[null,"code allocation unprotect "]
[null,"car rates 2003/4 - waiting on budget - note added also to tax help"]
[null,"front: staff / finance ==> payroll / personnel "]
[null,"auto open to check on new sheet for April & rate change for October "]
[]
["2002-07-25","Over 3 month note added to front"]
[null,"date validation amended to cover 3 month criteria"]
[null,"Foreign exchange method changed to add for amount column & conversation calculation"]
[null,"validation amended to cover this - backrow,16 added"]
[null,"Foreign exchange help added"]
[]
["2005-10-31","Change tax office links "]
["Di Strapps","Remove middle band of rates"]
[null,"Update rates"]
[]
["2006-04-10","Change tax year to 2007"]
[]
["2006-11-13","Changes of rates and to text; add further signature."]

{"sheet":"NoMacro","index":9,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MACROS"]
[]
[null,"If this sheet is visible it is probably because either"]
[null,null,1,"The spreadsheet has been opened without enabling macros"]
[null,null,2,"Security settings in excel are incorrect"]
[]
[null,"Solutions"]
[null,null,1,"Close this spreadsheet without saving and reopen it, this time enabling macros"]
[]
[null,null,2,"Click on the Tools Command"]
[null,null,null,"Select Options, then"]
[null,null,null,"Click on Security Tab"]
[null,null,null,"Click on Macro Security Button"]
[null,null,null,"Select medium Security"]
[null,null,null,"Click Ok, then OK again"]
[null,null,null,"Close this spreadsheet without saving and reopen it, this time enabling macros"]

{"sheet":"Calcs","index":10,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":true,"merged":[[22,0,22,1],[20,9,20,10],[20,11,20,12]]}
["AddStatus",null,null,"TaxYr","Octrate"]
[3,null,null,0,0]
[null,null,"Status: 1- detail not yet added to log since last open 2- detail added to log since last open  3 - worksheet new"]
[]
["S",null,null,"Dates for checking spreadsheet up to date",null,null,null,"year"]
["R",null,null,{"$f":"H13","v":"2019-04-05"},{"$f":"H10","v":"2018-10-01"},null,"now",{"$f":"NOW()","v":"2018-06-01T14:41:47.570"}]
[null,null,null,null,null,null,"this year",2018]
["Notes",null,null,null,null,null,"1st oct year",2018]
[null,null,null,null,null,null,"1st oct in text",{"$f":"\"1 Oct \" &H8","v":"1 Oct 2018"}]
[null,null,"To prevent inadvertent changes, the template is saved with READ ONLY file attribute. ",null,null,null,"datevalue 1st oct",{"$f":"DATEVALUE(H9)","v":43374}]
[null,null,"Although each sheet is locked to prevent inadvertent use, there is no password protection, as some users may quite legitimately",null,null,null,"april year",2019]
[null,null,"need to update certain aspects of their own copy of the spreadsheet.",null,null,null,"5 apr in text",{"$f":"\"5 Apr \" &H11","v":"5 Apr 2019"}]
[null,null,null,null,null,null,"datevalue of 5 apr",{"$f":"DATEVALUE(H12)","v":43560}]
[null,null,"Should changes be required please note that there are macros which operate when the spreadsheet is opened and closed"]
[null,null,"and that the spreadsheet opens differently the first time it is used to any other time in order to ensure that users see the HOME page"]
[null,null,"the first time the spreadsheet is used, thereafter the spreadsheet will always open to the back page. "]
[null,null,"The AddStatus cell on this page is the flag used for this purpose."]
[null,null,"Should any changes be done to the template, then the macro FR11aUpdate should be run as the last thing before finally "]
[null,null,"saving the revised template. The file attributes should then be set to READ only."]
[]
[null,null,"Created by Peter du Feu. Warwick Manufacturing Group.  ",null,null,null,null,null,null,"Post Apr05",null,"PreApr05"]
[]
["Back Colum Row Numbering",null,null,null,null,null,null,null,null,"Col","No","Col","No","Detail"]
["Col","No","Detail",null,null,null,null,null,null,"A",1,"A",1,"Date"]
["A",1,"Date",null,null,null,null,null,null,"B",2,"B",2,"Details of expenditure"]
["B",2,"Details of expenditure",null,null,null,null,null,null,"C",3,"C",3,"Single / Return"]
["C",3,"Single / Return",null,null,null,null,null,null,"D",4,"D",4,"first 100"]
["D",4,"first 100",null,null,null,null,null,null,"-","-","E",5,"next 100"]
["E",5,"next 100",null,null,null,null,null,null,"E",5,"F",6,"over 200 100"]
["F",6,"over 200",null,null,null,null,null,null,"F",6,"G",7,"daily total"]
["G",7,"daily total",null,null,null,null,null,null,"G",7,"H",8,"travel"]
["H",8,"travel",null,null,null,null,null,null,"H",8,"I",9,"accommodation"]
["I",9,"accommodation",null,null,null,null,null,null,"I",9,"J",10,"lunch"]
["J",10,"lunch",null,null,null,null,null,null,"J",10,"K",11,"evening meal"]
["K",11,"evening meal",null,null,null,null,null,null,"K",11,"L",12,"hospitality"]
["L",12,"hospitality",null,null,null,null,null,null,"L",12,"M",13,"other"]
["M",13,"other",null,null,null,null,null,null,"M",13,"N",14,"receipt ref"]
["N",14,"receipt ref",null,null,null,null,null,null,"N",14,"O",15,"excahnge rate"]
["O",15,"excahnge rate",null,null,null,null,null,null,"O",15,"P",16,"foreign expenditure"]
["P",16,"foreign expenditure",null,null,null,null,null,null,"P",16,"Q",17,"BLANK"]
["Q",17,"BLANK",null,null,null,null,null,null,"Q",17,"R",18,"STERLING VALUE OF first 100"]
["R",18,"STERLING VALUE OF first 100",null,null,null,null,null,null,"-","-","S",19,"STERLING VALUE OF next 100"]
["S",19,"STERLING VALUE OF next 100",null,null,null,null,null,null,"R",18,"T",20,"STERLING VALUE OF over 200"]
["T",20,"STERLING VALUE OF over 200",null,null,null,null,null,null,"S",19,"U",21,"VALIDATION EXPNSE SUM"]
["U",21,"VALIDATION EXPNSE SUM",null,null,null,null,null,null,"T",20,"V",22,"blank"]
["V",22,"blank",null,null,null,null,null,null,"U",21,"W",23,"blank"]
["W",23,"blank",null,null,null,null,null,null,"V",22,"X",24,"blank"]
["X",24,"blank",null,null,null,null,null,null,"W",23,"Y",25,"sterling value of foreign expnditure"]
["Y",25,"sterling value of foreign expnditure",null,null,null,null,null,null,"X",24,"Z",26]
["Z",26,null,null,null,null,null,null,null,"Y",25]