{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Mileage","Form","Air Fare Rail Bus Car Rental","Parking","Meals","Hotel","Taxi","Policies"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":10,"comments":1,"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":"Instructions","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Fill out your name, address, telephone number,  and email address on form and save the file for easy re-use."]
[]
[null,"Each time you use the expense claim form complete the reason for your travel and the date(s) of your travel. "]
[]
[null,"For Transportation expenses go to the yellow tabs called:"]
[null,null,"Air Fare Rail Bus Car Rental"]
[null,null,"Mileage"]
[null,null,"Parking"]
[null,null,"Taxi"]
[]
[null,"For Accommodation expenses go to the green tab called:"]
[null,null,"Hotel"]
[]
[null,"For Meal expenses go to the purple tab called:"]
[null,null,"Meals"]
[]
[null,"Meals are paid per diem based on the dates outlined for the meeting."]
[null,"Meals that are paid for by Engineers Canada should not have an associted per diem"]
[]
[]
[null,"If you are remitting by email, enter your name in the signature block.  "]
[null,"Attach scanned claim form, tabs and copies of each receipt and email to :",null,null,null,"finance@engineerscanada.ca"]
[null,"As we reimburse by EFT, please attach a copy of your bank detail (void chq) if  we do not have it on file from previous expense claims."]

{"sheet":"Mileage","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,11,0,12]]}
["Mileage Expenses",null,null,null,null,null,null,null,null,null,null,"Lookup table"]
[null,null,null,null,null,null,null,null,null,null,null,"Province/Territory","Cents/KM (taxes included)"]
["Province / Territory","Reason","Total KM","Cents/KM (taxes included)",{"$f":"SUM(E4:E23)","v":0},"Total $",null,null,null,null,null,"Alberta",54.5]
[null,null,null,{"$f":"IFERROR(VLOOKUP(A4,L:M,2,FALSE),\"\")","v":""},{"$f":"IF(D4<>\"\",C4*D4/100,\"\")","v":""},null,null,null,null,null,null,"British Columbia",57.5]
[null,null,null,{"$f":"IFERROR(VLOOKUP(A5,L:M,2,FALSE),\"\")","v":""},{"$f":"IF(D5<>\"\",C5*D5/100,\"\")","v":""},null,null,null,null,null,null,"Manitoba",54.5]
[null,null,null,"","",null,null,null,null,null,null,"New Brunswick",58.5]
[null,null,null,"","",null,null,null,null,null,null,"Newfoundland and Labrador",60.5]
[null,null,null,"","",null,null,null,null,null,null,"Northwest Territories",70]
[null,null,null,"","",null,null,null,null,null,null,"Nova Scotia",59.5]
[null,null,null,"","",null,null,null,null,null,null,"Nunavut",70.5]
[null,null,null,"","",null,null,null,null,null,null,"Ontario",60.5]
[null,null,null,"","",null,null,null,null,null,null,"Prince Edward Island",57.5]
[null,null,null,"","",null,null,null,null,null,null,"Quebec",58]
[null,null,null,"","",null,null,null,null,null,null,"Saskathewan",55]
[null,null,null,{"$f":"IFERROR(VLOOKUP(A15,L:M,2,FALSE),\"\")","v":""},{"$f":"IF(D15<>\"\",C15*D15/100,\"\")","v":""},null,null,null,null,null,null,"Yukon",71.5]
[null,null,null,"",""]

{"sheet":"Form","index":2,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[38,2,38,6],[39,2,39,6],[41,2,41,6],[40,2,40,6],[24,10,24,12],[26,10,26,12],[30,10,30,12],[19,2,19,12],[7,8,7,12],[11,9,11,12],[13,9,13,10],[5,8,5,12],[2,8,2,12],[3,8,3,12],[17,9,17,10],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[14,9,14,10],[15,9,15,10],[16,9,16,10]]}
[]
[]
[null,null,null,null,null,null,null,null,"Available at engineerscanada.ca"]
[null,null,null,null,null,null,null,null,"(Aussi dispondible en francais)"]
[]
[null,null,null,null,null,null,null,null,"EXPENSE CLAIM FORM"]
[]
[null,null,null,null,null,null,null,null,"IMPORTANT:  Receipts must be submitted with the expense claim form. Meal and entertainment receipts must be itemized receipts, include a description of business purpose, and the names of those in attendance. Scanned receipts are preferred. More information is available in this Excel spreadsheet's various bottom tabs."]
[]
[null,null,"REASON FOR TRAVEL:"]
[null,null,"DATE: "]
[null,null,null,null,null,null,null,null,null,"For Engineers Canada Use Only"]
[null,null,"Name:",null,null,null,null,null,null,"GL Code",null,null,"Amount"]
[null,null,"Address:"]
[]
[null,null,"Telephone:"]
[null,null,"email:"]
[null,null,"Date:"]
[]
[]
[]
[null,null,"TRANSPORTATION - see the yellow tabs"]
[]
[null,null,"Air Fare/Rail/Bus/Car Rental",null,null,null,null,null,{"$f":"'Air Fare Rail Bus Car Rental'!C3","v":0}]
[null,null,"Mileage ",null,null,null,null,null,{"$f":"Mileage!E3","v":0}]
[null,null,"Parking",null,null,null,null,null,{"$f":"Parking!C3","v":0}]
[null,null,"Taxi",null,null,null,null,null,{"$f":"Taxi!B3","v":0}]
[]
[null,null,"ACCOMMODATION - see the green tab"]
[]
[null,null,"Hotel (includes meals, phone, etc. on hotel bill)",null,null,null,null,null,{"$f":"Hotel!C3","v":0}]
[]
[null,null,"MEALS - see the purple tab"]
[]
[null,null,"Meals not included on hotel bill",null,null,null,null,null,{"$f":"Meals!D4","v":0}]
[]
[null,null,"OTHER (please provide details below)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total Expenses",null,{"$f":"I24+I25+I26+I27+I31+I35+I39+I40+I41+I42","v":0}]
[]
[null,null,"Less:  Total payable by another organization or advance received"]
[]
[null,null,null,"Total to be reimbursed by Engineers Canada"]
[]
[null,null,"SIGNATURE OF CLAIMANT:"]
[]
[null,null,"ENGINEERS CANADA APPROVAL:"]
[]
[]
[null,null,"Send to: ",null,null,null,null,"Mail to:"]
[null,null,"finance@engineerscanada.ca",null,null,"OR",null,"Engineers Canada"]
[null,null,null,null,null,null,null,"55 Metcalfe Street, Suite 300"]
[null,null,null,null,null,null,null,"Ottawa, ON K1P 6L5"]
[null,null,null,null,null,null,null,"Att:  Accounts Payable"]

{"sheet":"Air Fare Rail Bus Car Rental","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Air Fare, Rail, Bus and Car Rental Expenses"]
[]
["Receipt #","Purpose",{"$f":"SUM(C4:C14)","v":0},"Total"]

{"sheet":"Parking","index":4,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Parking Expenses"]
[]
["Receipt #","Purpose:  ",{"$f":"SUM(C4:C18)","v":0},"Total"]

{"sheet":"Meals","index":5,"n_rows":187,"n_cols":12,"rows_kept":187,"cut":false,"hidden":false,"merged":[]}
["Meal Expenses"]
[]
[null,null,null,"Total",null,null,null,null,null,null,"Lookup table"]
["Date","Meal Type (Breakfast/Lunch /Dinner/Incidental)","Amount",{"$f":"SUM(C5:C40)","v":0},null,null,null,null,null,null,"Breakfast",27.95]
[null,null,{"$f":"IFERROR(VLOOKUP(B5,K:L,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"Dinner",56.85]
[null,null,{"$f":"IFERROR(VLOOKUP(B6,K:L,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"Incidental",17.3]
[null,null,"",null,null,null,null,null,null,null,"Lunch",27]
[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,""]
[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,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B51,K:L,2,FALSE),\"\")","v":""}]
[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,""]
[null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B70,K:L,2,FALSE),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,{"$f":"IFERROR(VLOOKUP(B134,K:L,2,FALSE),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,""]
[null,null,""]

{"sheet":"Hotel","index":6,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Hotel Expenses"]
[]
["Receipt #",null,{"$f":"SUM(C4:C19)","v":0},"Total"]

{"sheet":"Taxi","index":7,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Taxi Expenses"]
[null," "," "]
[" ",{"$f":"SUM(B4:B20)","v":0},"TOTAL"]

{"sheet":"Policies","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Board, committee,and other volunteer expenses"]
[null,null,"https://engineerscanada.ca/about/governance/board-meetings/expense-claim-policy"]
[]
[]
[]
[null,"From Section 13 of the Employee Information manual:"]
[null,null,"It is the policy of Engineers Canada to reimburse employees for all reasonable expenses incurred while on Engineers Canada business, "]
[null,null,"where prior authorization has been obtained.  Please refer to the Board Policy for details. "]
[]
[null,null,"A link to the board policy is above. "]