{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["MAIN FORM","International Claims","Checklist","Sheet3","Currencies","signature"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":4,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"MAIN FORM","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,2,3,4],[13,6,13,7],[35,0,38,4],[35,5,35,7],[36,5,36,7],[37,5,37,7],[13,0,13,1],[16,2,16,4],[12,2,12,3],[13,2,13,3],[12,5,12,7],[0,0,0,8],[1,0,1,8],[2,2,2,4],[2,5,5,5],[2,6,5,8],[4,2,4,4],[5,2,5,4],[6,2,7,4],[6,7,6,8],[7,7,7,8],[8,0,11,0],[8,2,11,8],[12,0,12,1]]}
["Acadia University"]
["Travel Expense Claim Form"]
["Name",{"$nulls":4},"Destination"]
["Employee/Student ID"]
["Position"]
["Department"]
["Address",{"$nulls":5},"Departure date/time"]
[{"$nulls":6},"Return date/time"]
["Purpose of travel and other notes:"]
[]
[]
[]
["Account/amount"]
["Account/amount",{"$nulls":5},"Total all accounts",null,{"$f":"E14+E13+I13","v":0}]
["Mileage:",null,null,"KM @",{"$nulls":4},{"$f":"ROUND(C15 *E15,2)","v":0}]
["Airfare: Economy class only (must include itinerary & paid receipt showing HST)",{"$nulls":6},"CAD"]
[null,null,"Meals"]
["Date","Currency","B","L","D","Transportation","Accommodations","Other","Daily total"]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C19:$H19)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C20:$H20)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C21:$H21)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C22:$H22)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C23:$H23)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C24:$H24)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C25:$H25)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C26:$H26)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C27:$H27)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C28:$H28)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C29:$H29)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C30:$H30)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C31:$H31)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C32:$H32)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C33:$H33)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C34:$H34)","v":0}]
[{"$nulls":8},{"$f":"SUM('MAIN FORM'!$C35:$H35)","v":0}]
["Amounts should be entered in the foreign currency. Include credit card statements as support to show the conversion. Bank of Canada rates will be used for any amounts without supporting receipts (i.e. per diems).",{"$nulls":4},"Total CAN expenses",null,null,{"$f":"SUMIF('MAIN FORM'!$B$19:$B$35,\"CAD\",'MAIN FORM'!$I$19:$I$35)+SUMIF(H16,\"CAD\",I16)+I15","v":0}]
[{"$nulls":5},"Total Foreign expenses",null,null,{"$f":"SUMIF('MAIN FORM'!$B$19:$B$35,\"<>\",'MAIN FORM'!$I$19:$I$35) + SUMIF(H16,\"<>\",I16) + I15 - I36","v":0}]
[{"$nulls":5},"Less: Advance or external funding"]
[{"$nulls":5},{"$f":"IF(I37=0,\"Balance to Reimburse (CAD)\",\"Balance to Reimburse (CAD + Foreign)\")","v":"Balance to Reimburse (CAD)"},null,null,{"$f":"I15 + I16 + SUM('MAIN FORM'!$I$19:$I$35) - I38","v":0}]

{"sheet":"International Claims","index":1,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[12,0,12,1],[12,2,12,3],[12,5,12,7],[0,0,0,8],[1,0,1,8],[2,2,2,4],[2,5,5,5],[2,6,5,8],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,7,4],[6,7,6,8],[7,7,7,8],[8,0,11,0],[8,2,11,8],[13,0,13,1],[13,2,13,3],[13,6,13,7],[16,2,16,4],[54,0,57,4],[54,5,54,7],[55,5,55,7],[56,5,56,7]]}
["Acadia University"]
["Travel Expense Claim Form"]
["Name",{"$nulls":4},"Destination"]
["Employee/Student ID"]
["Position"]
["Department"]
["Address",{"$nulls":5},"Departure date/time"]
[{"$nulls":6},"Return date/time"]
["Purpose of travel and other notes:"]
[]
[]
[]
["Account/amount"]
["Account/amount",{"$nulls":5},"Total all accounts",null,{"$f":"E14+E13+I13","v":0}]
["Mileage:",null,null,"KM @",{"$nulls":4},{"$f":"ROUND(C15 *E15,2)","v":0}]
["Airfare: Economy class only (must include itinerary & paid receipt showing HST)",{"$nulls":6},"CAD"]
[null,null,"Meals"]
["Date","Currency","B","L","D","Transportation","Accommodations","Other","Daily total"]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C19:$H19)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C20:$H20)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C21:$H21)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C22:$H22)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C23:$H23)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C24:$H24)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C25:$H25)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C26:$H26)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C27:$H27)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C28:$H28)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C29:$H29)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C30:$H30)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C31:$H31)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C32:$H32)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C33:$H33)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C34:$H34)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C35:$H35)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C36:$H36)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C37:$H37)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C38:$H38)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C39:$H39)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C40:$H40)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C41:$H41)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C42:$H42)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C43:$H43)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C44:$H44)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C45:$H45)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C46:$H46)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C47:$H47)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C48:$H48)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C49:$H49)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C50:$H50)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C51:$H51)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C52:$H52)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C53:$H53)","v":0}]
[{"$nulls":8},{"$f":"SUM('International Claims'!$C54:$H54)","v":0}]
["Amounts should be entered in the foreign currency. Include credit card statements as support to show the conversion. Bank of Canada rates will be used for any amounts without supporting receipts (i.e. per diems).",{"$nulls":4},"Total CAN expenses",null,null,{"$f":"SUMIF('International Claims'!$B$19:$B$54,\"CAD\",'International Claims'!$I$19:$I$54)+SUMIF(H16,\"CAD\",I16)+I15","v":0}]
[{"$nulls":5},"Total Foreign expenses",null,null,{"$f":"SUMIF('International Claims'!$B$19:$B$54,\"<>\",'International Claims'!$I$19:$I$54) + SUMIF(H16,\"<>\",I16) + I15 - I55","v":0}]
[{"$nulls":5},"Less: Advance or external funding"]
[{"$nulls":5},{"$f":"IF(I56=0,\"Balance to Reimburse (CAD)\",\"Balance to Reimburse (CAD + Foreign)\")","v":"Balance to Reimburse (CAD)"},null,null,{"$f":"I15 + I16 + SUM('International Claims'!$I$19:$I$54) - I57","v":0}]

{"sheet":"Checklist","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":3,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":true,"merged":[[43,5,43,9],[27,0,29,9],[31,0,33,9],[40,0,40,1],[43,0,43,1],[37,5,37,9],[37,0,37,1],[40,5,40,9],[0,0,0,9],[1,0,1,9],[4,0,9,9],[2,0,3,9],[22,0,24,9],[21,0,21,9],[11,1,11,9],[13,1,13,9],[15,1,15,9],[17,1,17,9],[19,1,19,9]]}
["Acadia University"]
["Missing Receipt Affadavit"]
[]
[]
["This form may not be used on a routine basis and overuse may result in the privilege of this form being accepted revoked. Individuals are responsible for first attempting to contact the vendor to request missing receipts. \n                                                                                                                                                              If this expense is to be charged to a grant, the Agency’s approval to use this form must first be obtained."]
[]
[]
[]
[]
[]
[]
["NAME:"]
[]
["VENDOR NAME:"]
[]
["VENDOR CITY/PROVINCE:"]
[]
["DATE OF PURCHASE:"]
[]
["AMOUNT:"]
[]
["DESCRIPTION OF PURCHASE:"]
[]
[]
[]
[]
["DESCRIBE EFFORT MADE TO OBTAIN RECEIPT:"]
[]
[]
[]
[]
["I certify that this expense represents the amount paid for approved University business, is an allowable expense under the appropriate University or Granting Agency policy and will not be reimbursed from any other source."]
[]
[]
[]
["CLAIMANT",{"$nulls":4},"APPROVER"]
[]
[]
["DATE",{"$nulls":4},"DATE"]
[]
[]
["PRINT NAME",{"$nulls":4},"PRINT NAME"]
[]
[]
["ORIGINAL SIGNATURE",{"$nulls":4},"ORIGINAL SIGNATURE"]

{"sheet":"Currencies","index":4,"n_rows":178,"n_cols":2,"rows_kept":178,"cut":false,"hidden":true,"merged":[]}
["Country/Currency","Currency Type"]
["Canada Dollar","CAD"]
["USA Dollar","USD"]
["Euro","EUR"]
["China Yuan/Renminbi","CNY"]
["Great Britain Pound","GBP"]
["Japan Yen","JPY"]
["Switzerland Franc","CHF"]
["Australia Dollar","AUD"]
["Afghanistan Afghani","AFN"]
["Albania Lek","ALL"]
["Algeria Dinar","DZD"]
["Angola Kwanza","AOA"]
["Argentina Peso","ARS"]
["Armenia Dram","AMD"]
["Aruba Florin","AWG"]
["Australia Dollar","AUD"]
["Austria Schilling","ATS (EURO)"]
["Belgium Franc","BEF (EURO)"]
["Azerbaijan New Manat","AZN"]
["Bahamas Dollar","BSD"]
["Bahrain Dinar","BHD"]
["Bangladesh Taka","BDT"]
["Barbados Dollar","BBD"]
["Belarus Ruble","BYR"]
["Belize Dollar","BZD"]
["Bermuda Dollar","BMD"]
["Bhutan Ngultrum","BTN"]
["Bolivia Boliviano","BOB"]
["Bosnia Mark","BAM"]
["Botswana Pula","BWP"]
["Brazil Real","BRL"]
["Great Britain Pound","GBP"]
["Brunei Dollar","BND"]
["Bulgaria Lev","BGN"]
["Burundi Franc","BIF"]
["CFA Franc BCEAO","XOF"]
["CFA Franc BEAC","XAF"]
["CFP Franc","XPF"]
["Cambodia Riel","KHR"]
["Cape Verde Escudo","CVE"]
["Cayman Islands Dollar","KYD"]
["Chili Peso","CLP"]
["Colombia Peso","COP"]
["Comoros Franc","KMF"]
["Congo Franc","CDF"]
["Costa Rica Colon","CRC"]
["Croatia Kuna","HRK"]
["Cuba Convertible Peso","CUC"]
["Cuba Peso","CUP"]
["Cyprus Pound","CYP (EURO)"]
["Czech Koruna","CZK"]
["Denmark Krone","DKK"]
["Djibouti Franc","DJF"]
["Dominican Republich Peso","DOP"]
["East Caribbean Dollar","XCD"]
["Egypt Pound","EGP"]
["El Salvador Colon","SVC"]
["Estonia Kroon","EEK (EURO)"]
["Ethiopia Birr","ETB"]
["Euro","EUR"]
["Falkland Islands Pound","FKP"]
["Finland Markka","FIM (EURO)"]
["Fiji Dollar","FJD"]
["Gambia Dalasi","GMD"]
["Georgia Lari","GEL"]
["Germany Mark","DMK (EURO)"]
["Ghana New Cedi","GHS"]
["Gibraltar Pound","GIP"]
["Greece Drachma","GRD (EURO)"]
["Guatemala Quetzal","GTQ"]
["Guinea Franc","GNF"]
["Guyana Dollar","GYD"]
["Haiti Gourde","HTG"]
["Honduras Lempira","HNL"]
["Hong Kong Dollar","HKD"]
["Hungary Forint","HUF"]
["Iceland Krona","ISK"]
["India Rupee","INR"]
["Indonesia Rupiah","IDR"]
["Iran Rial","IRR"]
["Iraq Dinar","IQD"]
["Ireland Pound","IED (EURO)"]
["Israel New Shekel","ILS"]
["Italy Lira","ITL (EURO)"]
["Jamaica Dollar","JMD"]
["Japan Yen","JPY"]
["Jordan Dinar","JOD"]
["Kazakhstan Tenge","KZT"]
["Kenya Shilling","KES"]
["Kuwait Dinar","KWD"]
["Kyrgyzstan Som","KGS"]
["Laos Kip","LAK"]
["Latvia Lats","LVL (EURO)"]
["Lebanon Pound","LBP"]
["Lesotho Loti","LSL"]
["Liberia Dollar","LRD"]
["Libya Dinar","LYD"]
["Lithuania Litas","LTL (EURO)"]
["Luxembourg Franc","LUF (EURO)"]
["Macau Pataca","MOP"]
["Macedonia Denar","MKD"]
["Malagasy Ariary","MGA"]
["Malawi Kwacha","MWK"]
["Malaysia Ringgit","MYR"]
["Maldives Rufiyaa","MVR"]
["Malta Lira","MTL (EURO)"]
["Mauritania Ouguiya","MRO"]
["Mauritius Rupee","MUR"]
["Mexico Peso","MXN"]
["Moldova Leu","MDL"]
["Mongolia Tugrik","MNT"]
["Morocco Dirham","MAD"]
["Mozambique New Metical","MZN"]
["Myanmar Kyat","MMK"]
["NL Antilles Guilder","ANG"]
["Namibia Dollar","NAD"]
["Nepal Rupee","NPR"]
["Netherlands Guilder","NLG (EURO)"]
["New Zealand Dollar","NZD"]
["Nicaragua Cordoba Oro","NIO"]
["Nigeria Naira","NGN"]
["North Korea Won","KPW"]
["Norway Kroner","NOK"]
["Oman Rial","OMR"]
["Pakistan Rupee","PKR"]
["Panama Balboa","PAB"]
["Papua New Guinea Kina","PGK"]
["Paraguay Guarani","PYG"]
["Peru Nuevo Sol","PEN"]
["Philippines Peso","PHP"]
["Poland Zloty","PLN"]
["Portugal Escudo","PTE (EURO)"]
["Qatar Rial","QAR"]
["Romania New Lei","RON"]
["Russia Rouble","RUB"]
["Rwanda Franc","RWF"]
["Samoa Tala","WST"]
["Sao Tome/Principe Dobra","STD"]
["Saudi Arabia Riyal","SAR"]
["Serbia Dinar","RSD"]
["Seychelles Rupee","SCR"]
["Sierra Leone Leone","SLL"]
["Singapore Dollar","SGD"]
["Slovakia Koruna","SKK (EURO)"]
["Slovenia Tolar","SIT (EURO)"]
["Solomon Islands Dollar","SBD"]
["Somali Shilling","SOS"]
["South Africa Rand","ZAR"]
["South Korea Won","KRW"]
["Spain Peseta","ESP (EURO)"]
["Sri Lanka Rupee","LKR"]
["St Helena Pound","SHP"]
["Sudan Pound","SDG"]
["Suriname Dollar","SRD"]
["Swaziland Lilangeni","SZL"]
["Sweden Krona","SEK"]
["Switzerland Franc","CHF"]
["Syria Pound","SYP"]
["Taiwan Dollar","TWD"]
["Tanzania Shilling","TZS"]
["Thailand Baht","THB"]
["Tonga Pa'anga","TOP"]
["Trinidad/Tobago Dollar","TTD"]
["Tunisia Dinar","TND"]
["Turkish New Lira","TRY"]
["Turkmenistan Manat","TMM"]
["USA Dollar","USD"]
["Uganda Shilling","UGX"]
["Ukraine Hryvnia","UAH"]
["Uruguay Peso","UYU"]
["United Arab Emirates Dirham","AED"]
["Vanuatu Vatu","VUV"]
["Venezuela Bolivar","VEB"]
["Vietnam Dong","VND"]
["Yemen Rial","YER"]
["Zambia Kwacha","ZMK"]
["Zimbabwe Dollar","ZWD"]

{"sheet":"signature","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}