{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Formulaire","Avion, train, autocar, voiture","Kilométrage","Stationnement","Taxi","Hôtel","Repas","Politiques"],"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":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Inscrivez votre nom, adresse, numéro de téléphone et adresse électronique sur le formulaire et enregistrez le fichier pour sauvegarder vos renseignements. "]
[]
[null,"Veuillez indiquer la raison et les dates de votre voyage dans le formulaire de demande de remboursement.  "]
[]
[null,"Pour les frais de transport, cliquez sur les onglets jaunes intitulés :"]
[null,null,"Avion, train, autocar, location de voiture"]
[null,null,"Kilométrage"]
[null,null,"Stationnement"]
[null,null,"Taxi"]
[]
[null,"Pour les frais d'hébergement, cliquez sur l'onglet vert intitulé :"]
[null,null,"Hôtel"]
[]
[null,"Pour les frais de repas, cliquez sur l'onglet violet intitulé :"]
[null,null,"Repas"]
[]
[null,"Entrez tous les reçus dans les onglets correspondants."]
[null,"Le total de chaque onglet sera automatiquement relié au formulaire de demande de remboursement."]
[]
[null,"Vérifiez que tous les reçus ont été pris en compte et que le total qui figure sur le formulaire est exact."]
[]
[null,"Si vous envoyez le formulaire par courrier électronique, inscrivez votre nom dans le bloc-signature.  "]
[null,"Numérisez le formulaire de demande de remboursement, les onglets et tous les reçus, et envoyez le tout par courrier électronique à :",null,null,null,"finance@engineerscanada.ca"]
[]
[null,"Si vous envoyez votre demande de remboursement par courrier, imprimez et signez le formulaire. Imprimez tous les onglets et annexez tous les reçus.  "]
[]
[null,"Envoyez le formulaire dûment rempli à :"]
[]
[null,null,null,"Ingénieurs Canada"]
[null,null,null,"55 Metcalfe Street, Suite 300"]
[null,null,null,"Ottawa (Ontario)  K1P 6L5"]
[null,null,null,"Att :  Comptes fournisseurs"]

{"sheet":"Formulaire","index":1,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[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],[19,2,19,12],[7,8,7,12],[11,9,11,12],[13,9,13,10],[5,8,5,12],[38,2,38,6],[39,2,39,6],[41,2,41,6],[40,2,40,6],[23,10,23,12],[24,10,24,12],[26,10,26,12],[30,10,30,12]]}
[]
[]
[null,null,null,null,null,null,null,null,"Disponible à www.ingenieurscanada.ca"]
[null,null,null,null,null,null,null,null,"(Aussi disponible en anglais)"]
[]
[null,null,null,null,null,null,null,null,"FORMULAIRE DE \nDEMANDE DE REMBOURSEMENT"]
[]
[null,null,null,null,null,null,null,null,"IMPORTANT : Les reçus doivent être remis avec le formulaire de demande de remboursement. Les reçus pour les repas et les divertissements doivent indiquer la raison de l'activité et le nom des personnes qui y ont participé, et il est préférable de les numériser. Vous trouverez de l'information supplémentaire dans les différents onglets de cette feuille Excel. "]
[]
[null,null,"RAISON DU VOYAGE :"]
[null,null,"DATE : "]
[null,null,null,null,null,null,null,null,null,"Réservé à l'usage d'Ingénieurs Canada "]
[null,null,"Nom :",null,null,null,null,null,null,"Code G/L",null,null,"Montant"]
[null,null,"Adresse :"]
[]
[null,null,"Téléphone :"]
[null,null,"Courriel :"]
[null,null,"Date :"]
[]
[]
[]
[null,null,"TRANSPORT - cliquer sur les onglets jaunes"]
[]
[null,null,"Avion/Train/Autocar/Location de voiture",null,null,null,null,null,{"$f":"'Avion, train, autocar, voiture'!C3","v":0}]
[null,null,"Kilométrage ",null,null,null,null,null,{"$f":"Kilométrage!E3","v":0}]
[null,null,"Stationnement",null,null,null,null,null,{"$f":"Stationnement!C3","v":0}]
[null,null,"Taxi",null,null,null,null,null,{"$f":"Taxi!B3","v":0}]
[]
[null,null,"HÉBERGEMENT - cliquer sur l'onglet vert"]
[]
[null,null,"Hôtel (frais de repas, de téléphone, etc. figurant sur la note d'hôtel)",null,null,null,null,null,{"$f":"Hôtel!B3","v":0}]
[]
[null,null,"REPAS - cliquer sur l'onglet violet"]
[]
[null,null,"Repas (non inclus dans la note d'hôtel)",null,null,null,null,null,{"$f":"Repas!D3","v":0}]
[]
[null,null,"AUTRES (préciser)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total des dépenses",null,{"$f":"+I42+I41+I40+I39+I35+I31+I27+I26+I25+I24","v":0}]
[]
[null,null,"Moins : Montant remboursé par une autre organisation ou avance reçue"]
[]
[null,null,null,"Montant total qu'Ingénieurs Canada doit rembourser",null,null,null,null,{"$f":"+I44-I46","v":0}]
[]
[null,null,"SIGNATURE DU DEMANDEUR :"]
[]
[null,null,"APPROBATION D'INGÉNIEURS CANADA :"]
[]
[]
[null,null,"Envoyer à : ",null,null,null,null,"Poster à :"]
[null,null,"finance@engineerscanada.ca",null,null,"OU",null,"Ingénieurs Canada"]
[null,null,null,null,null,null,null,"55 Metcalfe Street, Suite 300"]
[null,null,null,null,null,null,null,"Ottawa (Ontario)  K1P 6L5"]
[null,null,null,null,null,null,null,"Att :  Comptes fournisseurs"]

{"sheet":"Avion, train, autocar, voiture","index":2,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Frais d'avion, de train, d'autocar ou de location de voiture"]
[]
["No de facture","Raison ",{"$f":"SUM(C4:C59)","v":0},"Total"]

{"sheet":"Kilométrage","index":3,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,11,0,12]]}
["Frais kilométriques",null,null,null,null,null,null,null,null,null,null,"Table de recherche"]
[null,null,null,null,null,null,null,null,null,null,null,"Province/Territoire","Cents/KM (taxes incluses"]
["Province/Territoire","Raison","Kilométrage total","Cents/KM (taxes incluses",{"$f":"SUM(E4:E59)","v":0},"Total (km)",null,null,null,null,null,"l’Alberta",56.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,"la Colombie-Britannique ",59.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,"le Manitoba",56]
[null,null,null,"","",null,null,null,null,null,null,"le Nouveau-Brunswick",59.5]
[null,null,null,"","",null,null,null,null,null,null,"la Terre-Neuve-et-Labrador ",61.5]
[null,null,null,"","",null,null,null,null,null,null,"les Territoires du Nord-Ouest",70]
[null,null,null,"","",null,null,null,null,null,null,"la Nouvelle-Écosse",59.5]
[null,null,null,"","",null,null,null,null,null,null,"le Nunavut",70.5]
[null,null,null,"","",null,null,null,null,null,null,"l’Ontario",62]
[null,null,null,"","",null,null,null,null,null,null,"\tl’île du Prince-Édouard ",58.5]
[null,null,null,"","",null,null,null,null,null,null,"le Québec",60.5]
[null,null,null,"","",null,null,null,null,null,null,"la Saskatchewan",55.5]
[null,null,null,"","",null,null,null,null,null,null,"le Yukon",70.5]
[null,null,null,"",""]

{"sheet":"Stationnement","index":4,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Frais de stationnement"]
[]
["No de facture","Raison",{"$f":"SUM(C4:C59)","v":0},"Total"]

{"sheet":"Taxi","index":5,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Frais de taxi"]
[]
["No de facture",{"$f":"SUM(B4:B59)","v":0},"Total"]

{"sheet":"Hôtel","index":6,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Frais d'hôtel"]
[]
["No de facture",{"$f":"SUM(B4:B59)","v":0},"Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Frais d'hôtel"]

{"sheet":"Repas","index":7,"n_rows":263,"n_cols":12,"rows_kept":263,"cut":false,"hidden":false,"merged":[]}
["Frais de repas"]
[]
["Date","Type de repas (petit-déjeuner/déjeuner/dîner/Frais accessoires)","Montant",{"$f":"SUM(C4:C59)","v":0},"Total",null,null,null,null,null,"Lookup table"]
[null,null,{"$f":"IFERROR(VLOOKUP(B4,K:L,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"Frais accessoires",17.3]
[null,null,{"$f":"IFERROR(VLOOKUP(B5,K:L,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"Déjeuner",29.6]
[null,null,"",null,null,null,null,null,null,null,"Dîner",60.75]
[null,null,"",null,null,null,null,null,null,null,"Petit-déjeuner",29.05]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[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(B69,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(B133,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(B197,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(B261,K:L,2,FALSE),\"\")","v":""}]
[null,null,""]
[null,null,""]

{"sheet":"Politiques","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dépenses du conseil, des comités et d’autres bénévoles"]
[null,null,"https://engineerscanada.ca/fr/apropos/gouvernance/reunions-du-conseil/remboursement-des-depenses"]
[]
[]
[]
[null,"Extrait du chapitre 13 du manuel de l'employé :"]
[null,null,"Ingénieurs Canada a pour politique de rembourser aux bénévoles et aux membres du personnel tous les frais raisonnables engagés pour s’adonner aux affaires d’Ingénieurs Canada, "]
[null,null,"sous réserve de l’obtention d’une autorisation préalable. Pour plus de détails, consulter la politique du conseil PG-10.  "]
[]
[null,null,"Le lien vers cette politique se trouve ci-dessus. "]