{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["EXEMPLE","FORMULAIRE (1)","FORMULAIRE (2)","FORMULAIRE (3)","Modèle "],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":3,"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":"EXEMPLE","index":0,"n_rows":123,"n_cols":44,"rows_kept":123,"cut":false,"hidden":false,"merged":[[0,13,0,14],[1,7,1,8],[5,13,5,14],[6,1,6,2],[6,13,6,14],[5,11,5,12],[6,11,6,12],[7,0,7,3],[8,0,8,3],[0,0,0,2],[0,3,0,4],[9,0,9,3],[2,0,2,3],[4,1,4,3],[5,1,5,3],[12,1,12,2],[12,4,12,5],[13,12,13,13],[13,1,13,2],[13,4,13,5],[14,1,14,2],[14,4,14,5],[15,1,15,2],[15,4,15,5],[16,1,16,2],[16,4,16,5],[17,1,17,2],[17,4,17,5],[18,1,18,2],[18,4,18,5],[19,1,19,2],[19,4,19,5],[24,4,24,5],[25,1,25,2],[25,4,25,5],[20,1,20,2],[20,4,20,5],[21,1,21,2],[21,4,21,5],[22,1,22,2],[22,4,22,5],[16,12,16,13],[17,12,17,13],[18,12,18,13],[34,0,35,4],[26,1,26,2],[26,4,26,5],[27,1,27,2],[27,4,27,5],[28,4,28,5],[28,1,28,2],[29,1,29,2],[29,4,29,5],[31,2,31,3],[23,1,23,2],[23,4,23,5],[24,1,24,2],[31,13,33,13],[29,12,29,13],[8,13,8,14],[4,11,4,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[14,12,14,13],[15,12,15,13]]}
["NUMÉRO DE MATRICULE: ",null,null,689000000,null,null,"Sortie annuelle:","Allée/Retour",null,null,null,"# Frais sortie",null,{"$f":"TODAY()","v":44760},null,null,null,null,"Allée ",null,null,"000-0-00000-000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO1,K14)","v":false},{"$f":"CODE(AM1)","v":70},"oui",{"$f":"IF(AN1=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.46}]
["Nom  de l'employé",null,null,null,null,null,"Destination: ","Sherbrooke",null,null,null,null,null,null,null,null,null,null,"Allée/Retour",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oui",null,{"$f":"EXACT(AO2,K15)","v":false},{"$f":"CODE(AM2)","v":70},"oui",{"$f":"IF(AN2=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.46}]
["Keven Labrie",null,null,null,null,null,null,null,null,"    am    pm",null,null,null,null,null,null,null,null,"Retour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO3,K16)","v":false},{"$f":"CODE(AM3)","v":70},"oui",{"$f":"IF(AN3=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.46}]
["Adresse ",null,null,null,null,"DÉPART:","30-05-2012","HEURE:","08:00:00",null,null,null,null,null,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":"EXACT(AO4,K17)","v":true},86,"oui",0.64]
["Rue:","123 Lauriers",null,null,null,null,null,null,null,null,null,"              réservé à l'administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.46]
["Ville: ","Lourdes de Blanc-Sablon",null,null,null,"ARRIVÉE:","2-06-2012","HEURE:","11:00:00",null,null,"Vérifié par: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.46]
["Province:","Québec",null,"G0G1L0",null,null,null,null,null,null,null,"Date :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.46]
["Nom des personnes qui ont voyagé",null,null,null,null,"RETOUR:","28-07-2012","HEURE:","10:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.46]
["Keven, Jenna, Sarah",null,null,null,null,null,null,null,null,null,null,"Équivalent aérien:",null,2200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.46]
[null,null,null,null,null,"ARRIVÉE:","29-07-2012","HEURE:","06:00:00",null,null,"(pour 1 personne)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64,1,null,null,null,null,null,null,null,false,70,"oui",0.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kilometre",0.46,0.49,null,"Frais fondés sur les reçu",null,null,null,"Province",null,false,70,"oui",0.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD12*$AD$11","v":722.66000000000008},null,"Autobus",null,null,null,"Alberta",null,false,70,"oui",0.46]
["Date","Km parcouru",null,"$ / km","Frais remboursé                          (montant employé)",null,"Frais fondés sur les reçus","Montant du reçu                              ($)"," Km  parcouru","$ / km","Covoiturage","Total de la ligne",null,"Justification","Reçu manquant",null,null,null,null,null,"Total ligne",null,null,"remb frais","Kilometrage","allocation versés entre village",null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD13*$AD$11","v":866.18000000000006},null,"Autres",null,null,null,"Colombie-Britannique",null,false,70,"oui",0.46]
["2012-05-30","Lourdes-de-Blanc-Sablon - Blanc-Sablon (3,7km)",null,{"$f":"Y14","v":1.8129999999999999},null,null,"Dîner (max 15$)",13.26,null,{"$f":"+IF(AN1=70,($I14*$AD$11),($I14*$AD$10)+((D14/$AD$11)*$AD$10)-D14)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U14,\" \"))","v":15.073},null,null,null,null,null,null,null,null,{"$f":"(X14+Y14+IF(I14<0,0,J14+H14))","v":15.073},null,null,{"$f":"IF(ISNA(VLOOKUP($E14,$AE$40:$AF$60,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$40:$AF$60,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))","v":1.8129999999999999},null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD14*$AD$11","v":444.36},null,"Avion",null,null,null,"Île-du-Prince-Édouard",null,false,70,"oui",0.46]
[null,null,null,0,null,null,"Avion",836,null,{"$f":"+IF(AN2=70,($I15*$AD$11),($I15*$AD$10)+((D15/$AD$11)*$AD$10)-D15)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U15,\" \"))","v":836},"avion Blanc-Sablon à Sept-Iles (aller/retour)",null,null,null,null,null,null,null,{"$f":"(X15+Y15+IF(I15<0,0,J15+H15))","v":836},null,null,0,0,null,null,null,"Lourdes-de-Blanc-Sablon - Blanc-Sablon (3,7km)",3.7,{"$f":"$AE$11*AD15","v":1.8129999999999999},null,"Déjeuner (max 10$)",null,null,null,"Manitoba",null,false,70,"oui",0.46]
[null,null,null,0,"Chevery/ La Tabatière (75,50$)",null,"Taxi, $ du reçu",26.84,null,{"$f":"+IF(AN3=70,($I16*$AD$11),($I16*$AD$10)+((D16/$AD$11)*$AD$10)-D16)","v":0},null,102.34,null,null,null,null,null,null,null,null,102.34,null,null,75.5,0,null,null,null,"Montréal - Toronto (556km)",556,{"$f":"$AD$11*AD16","v":255.76000000000002},null,"Dîner (max 15$)",null,null,null,"Nouveau-Brunswick",null,{"$f":"EXACT(AO16,K29)","v":false},70,"oui",0.46]
["2012-06-01","Sept-Iles - Québec (653km)",null,300.38,null,null,"Repas journée (max 52$)",52,null,{"$f":"+IF(AN4=70,($I17*$AD$11),($I17*$AD$10)+((D17/$AD$11)*$AD$10)-D17)","v":117.54000000000002},"oui",469.92,"covoiturage avec (nom de l'employé)",null,null,null,null,null,null,null,469.92,null,null,0,300.38,null,null,null,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD17","v":92.92},null,"Hébergement, fact d'hôtel",null,null,null,"Nunavut",null,{"$f":"EXACT(AO17,K30)","v":false},70,"oui",0.46]
["2012-06-01","Québec- Sherbrooke (254)",null,116.84,null,null,null,null,null,{"$f":"+IF(AN5=70,($I18*$AD$11),($I18*$AD$10)+((D18/$AD$11)*$AD$10)-D18)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U18,\" \"))","v":116.84},null,null,null,null,null,null,null,null,116.84,null,null,0,116.84,null,null,null,"Old Fort bay - Rivière St-Paul (12$)",0,12,null,"Repas journée (max 52$)",null,null,null,"Québec"]
[null,null,null,0,"Hébergement (sans reçu 30$)",null,null,null,null,{"$f":"+IF(AN6=70,($I19*$AD$11),($I19*$AD$10)+((D19/$AD$11)*$AD$10)-D19)","v":0},null,30,"Loger chez des amis à Sept-Iles",null,null,null,null,null,null,null,30,null,null,30,0,null,null,null,"Old Fort Bay-Blanc-Sablon  (30km)",30,{"$f":"AD19*$AE$11","v":14.7},null,"Souper (max 27$)",null,null,null,"Saskatchewan"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec- Sherbrooke (254)",254,{"$f":"$AD$11*AD20","v":116.84},null,"Stationnement, $ du reçu",null,null,null,"Terre-Neuve-et-Labrador"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec-Montréal (267km)",267,{"$f":"$AD$11*AD21","v":122.82000000000001},null,"Taxi, $ du reçu",null,null,null,"Territoire du Nord-Ouest"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Rivière St-Paul - Blanc Sablon (65,8km)",{"$f":"22.2+28+11.9+3.7","v":65.8},{"$f":"AD22*$AE$11","v":32.241999999999997},null,"Train, $ du reçu",null,null,null,"Yukon"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD23","v":102.58},null,"Transport en commun"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - La Malbaie (502 km)",502,{"$f":"AD24*$AD$11","v":230.92000000000002},null,"Traverse Blanc-Sablon - St-Barbe"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Montreal (920)",920,{"$f":"AD25*$AD$11","v":423.20000000000005},null,"Traverse Port-aux-Basques - North Sydney"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Québec (653km)",653,{"$f":"AD26*$AD$11","v":300.38}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - St-Urbain (555 km)",555,{"$f":"AD27*$AD$11","v":255.3}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles- Baie-Comeau (233 km)",233,{"$f":"AD28*$AD$11","v":107.18}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"(X29+Y29+IF(I29<0,0,J29+H29))","v":0},null,null,0,0,null,null,null,"Sept-Iles- Natasquan (377km)",{"$f":"154+223","v":377},{"$f":"$AD$11*AD29","v":173.42000000000002}]
[null,null,null,{"$f":"Y30","v":0},null,null,null,null,null,{"$f":"+IF(AN17=70,($I30*$AD$11),($I30*$AD$10)+((D30/$AD$11)*$AD$10)-D30)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U30,\" \"))","v":0},null,null,null,null,null,null,null,null,{"$f":"(X30+Y30+IF(I30<0,0,J30+H30))","v":0},null,null,0,0,null,null,null,"St-Barbe - Corner Brooke (350km)",{"$f":"298+52","v":350},161]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total du frais de la sortie annuelle ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - DeerLake (298km)",298,137.08000000000001]
[null,"Date",{"$f":"TODAY()","v":"2022-07-18"},null,null,null,"Réservé à l'administration",null,null,null,null,null,null,{"$f":"SUM(L14:L30)","v":1570.173},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Port-aux Basques (577km)",{"$f":"298+52+75+152","v":577},265.42,null,null,null,null,null,null,null,null,"Allocation lors des déplacemen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Stephenville (425km)",{"$f":"298+52+75","v":425},195.5,null,null,null,null,null,null,null,null,"Village","Aéroport","Bureau de poste","Quai","Village"]
["SIGNATURE DE L'EMPLOYÉ:",null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Paul -Blanc-sablon (20km)",20,9.2000000000000011,null,null,null,null,null,null,null,null,"Blanc-Sablon",10,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery",8,8,8,0]
[null,null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery (succursale)",8,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington",0,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kégaska",8,8,8,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,null,null,"Québec",null,null,null,"Remb frais ",null,null,null,null,null,null,null,null,"La Romaine",8,8,8,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,null,null,"Montréal",null,null,null,"Chevery/  St-Augustin (130,00$)",130,null,null,null,null,null,null,null,"La Tabatière",8,8,8,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,null,null,"Sept-iles ",null,null,null,"Chevery/ Harrington Harbour (16,50$)",16.5,null,null,null,null,null,null,null,"Middle bay",0,0,0,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,null,null,"Corner Brooke",null,null,null,"Chevery/ Kegaska (142,50$)",142.5,null,null,null,null,null,null,null,"Mutton Bay",8,8,8,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,null,null,"Gatineau",null,null,null,"Chevery/ La Tabatière (75,50$)",75.5,null,null,null,null,null,null,null,"Old Fort Bay",75,8,8,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,null,null,"Malbaie",null,null,null,"Chevery/ Tête-a-la-Baleine (37,50$)",37.5,null,null,null,null,null,null,null,"Port-Menier",8,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baie-Comeau",null,null,null,"Chevery/La Romaine (90.00$)",90,null,null,null,null,null,null,null,"St-Augustin",8,8,8,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,null,null,"Natasquan",null,null,null,"Hébergement (sans reçu 30$)",30,null,null,null,null,null,null,null,"St-Paul",51.5,8,24,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,null,null,"Havre-St-Pierre",null,null,null,"Kegaska / La Romaine (53,50$)",53.5,null,null,null,null,null,null,null,"Tête-à-la-Baleine",8,8,18,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,null,null,"Sherbrooke",null,null,null,"Kegaska/Natasquan (45.00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kegaska",null,null,null,"La Tabatière/ Old Fort Bay (12,00$)",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Romaine",null,null,null,"La Tabatière/ Rivière St-Augustin (54,50$)",54.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery",null,null,null,"St-Augustin/ Old Fort Bay (75,50$)",75.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington Harbour",null,null,null,"Tête-a-la-Baleine/ La Tabatière (45,00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-à-la-Baleine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Port Menier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mutton Bay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La Tabatière"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Fort Bay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rivière St-Paul"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lourdes-de-Blanc-Sablon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,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":"FORMULAIRE (1)","index":1,"n_rows":123,"n_cols":44,"rows_kept":123,"cut":false,"hidden":false,"merged":[[34,0,35,4],[27,1,27,2],[27,4,27,5],[27,12,27,13],[28,1,28,2],[28,4,28,5],[28,12,28,13],[29,4,29,5],[29,12,29,13],[31,2,31,3],[31,13,33,13],[29,0,29,2],[25,1,25,2],[25,4,25,5],[25,12,25,13],[26,1,26,2],[26,4,26,5],[26,12,26,13],[23,1,23,2],[23,4,23,5],[23,12,23,13],[24,1,24,2],[24,4,24,5],[24,12,24,13],[21,1,21,2],[21,4,21,5],[21,12,21,13],[22,1,22,2],[22,4,22,5],[22,12,22,13],[19,1,19,2],[19,4,19,5],[19,12,19,13],[20,1,20,2],[20,4,20,5],[20,12,20,13],[17,1,17,2],[17,4,17,5],[17,12,17,13],[18,1,18,2],[18,4,18,5],[18,12,18,13],[15,1,15,2],[15,4,15,5],[15,12,15,13],[16,1,16,2],[16,4,16,5],[16,12,16,13],[13,1,13,2],[13,4,13,5],[13,12,13,13],[14,1,14,2],[14,4,14,5],[14,12,14,13],[7,0,7,3],[8,0,8,3],[9,0,9,3],[12,1,12,2],[12,4,12,5],[5,1,5,3],[5,11,5,12],[5,13,5,14],[6,1,6,2],[6,11,6,12],[6,13,6,14],[4,1,4,3],[4,11,4,13],[0,0,0,2],[0,3,0,4],[0,13,0,14],[1,7,1,8],[2,0,2,3]]}
["NUMÉRO DE MATRICULE: ",null,null,null,null,null,"Sortie annuelle :","Aller/Retour",null,null,null,"Numéro de frais de sortie",null,{"$f":"TODAY()","v":44760},null,null,null,null,"Aller ",null,null,"000-0-00000-000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO1,K14)","v":false},{"$f":"CODE(AM1)","v":70},"oui",0.55000000000000004]
["NOM et Prénom de l'employé",null,null,null,null,null,"Destination: ","Montréal",null,null,null,null,null,null,null,null,null,null,"Aller/Retour",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oui",null,{"$f":"EXACT(AO2,K15)","v":false},{"$f":"CODE(AM2)","v":70},"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,"    am    pm",null,null,null,null,null,null,null,null,"Retour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO3,K16)","v":false},{"$f":"CODE(AM3)","v":70},"oui",0.55000000000000004]
["Adresse ",null,null,null,null,"DÉPART:",null,"HEURE:",null,null,null,null,null,null,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":"EXACT(AO4,K17)","v":false},70,"oui",0.55000000000000004]
["Rue:",null,null,null,null,null,null,null,null,null,null,"              réservé à l'administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Ville: ",null,null,null,null,"ARRIVÉE:",null,"HEURE:",null,null,null,"Vérifié par: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Province:",null,null,null,null,null,null,null,null,null,null,"Date :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Nom des personnes qui ont voyagé",null,null,null,null,"RETOUR:",null,"HEURE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,"ARRIVÉE:",null,"HEURE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61,1,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kilometre",0.55000000000000004,0.55000000000000004,null,"Frais fondés sur les reçu",null,null,null,"Province",null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD12*$AD$11","v":864.05000000000007},null,"Autobus",null,null,null,"Alberta",null,false,70,"oui",0.55000000000000004]
["Date","Km parcouru",null,"$ / km","Frais remboursé                          (montant employé)",null,"Frais fondés sur les reçus","Montant du reçu                              ($)"," Km  parcouru","$ / km","Covoiturage","Total de la ligne",null,"Justification","Reçu manquant",null,null,null,null,null,"Total ligne",null,null,"remb frais","Kilometrage","allocation versés entre village",null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD13*$AD$11","v":1035.6500000000001},null,"Autres",null,null,null,"Colombie-Britannique",null,false,70,"oui",0.55000000000000004]
[null,null,null,{"$f":"Y14","v":0},null,null,null,null,null,{"$f":"+IF(AN1=70,($I14*$AD$11),($I14*$AD$10)+((D14/$AD$11)*$AD$10)-D14)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U14,\" \"))","v":0},null,null,null,null,null,null,null,null,{"$f":"(X14+Y14+IF(I14<0,0,J14+H14))","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($E14,$AE$40:$AF$64,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$40:$AF$64,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD14*$AD$11","v":531.30000000000007},null,"Avion",null,null,null,"Île-du-Prince-Édouard",null,false,70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,{"$f":"+IF(AN2=70,($I15*$AD$11),($I15*$AD$10)+((D15/$AD$11)*$AD$10)-D15)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U15,\" \"))","v":0},null,null,null,null,null,null,null,null,{"$f":"(X15+Y15+IF(I15<0,0,J15+H15))","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($E15,$AE$40:$AF$64,2,FALSE))=TRUE, ,VLOOKUP($E15,$AE$40:$AF$64,2,FALSE))","v":0},0,null,null,null,"Kegaska - Natasquan (49 km)",49,{"$f":"AD15*$AD$11","v":26.950000000000003},null,"Déjeuner (max 10$)",null,null,null,"Manitoba",null,false,70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Lourdes-de-Blanc-Sablon - Blanc-Sablon (3,7km)",3.7,{"$f":"$AE$11*AD16","v":2.0350000000000001},null,"Dîner (max 15$)",null,null,null,"Nouveau-Brunswick",null,{"$f":"EXACT(AO16,K29)","v":false},70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Montréal - Toronto (556km)",556,{"$f":"$AD$11*AD17","v":305.8},null,"Hébergement, fact d'hôtel",null,null,null,"Nunavut",null,{"$f":"EXACT(AO17,K30)","v":false},70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,{"$f":"(IF(ISTEXT($H$2),U18,\" \"))","v":0},null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD18","v":111.10000000000001},null,"Repas journée (max 52$)",null,null,null,"Québec"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Old Fort bay - Rivière St-Paul (12$)",0,12,null,"Souper (max 27$)",null,null,null,"Saskatchewan"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Old Fort Bay-Blanc-Sablon  (30km)",30,{"$f":"AD20*$AE$11","v":16.5},null,"Stationnement, $ du reçu",null,null,null,"Terre-Neuve-et-Labrador"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec- Sherbrooke (254)",254,{"$f":"$AD$11*AD21","v":139.70000000000002},null,"Taxi, $ du reçu",null,null,null,"Territoire du Nord-Ouest"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec-Montréal (267km)",267,{"$f":"$AD$11*AD22","v":146.85000000000002},null,"Train, $ du reçu",null,null,null,"Yukon"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Rivière St-Paul - Blanc Sablon (65,8km)",{"$f":"22.2+28+11.9+3.7","v":65.8},{"$f":"AD23*$AE$11","v":36.190000000000005},null,"Transport en commun"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD24","v":122.65},null,"Traverse Blanc-Sablon - St-Barbe"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - La Malbaie (502 km)",502,{"$f":"AD25*$AD$11","v":276.10000000000002},null,"Traverse Port-aux-Basques - North Sydney"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Montreal (920)",920,{"$f":"AD26*$AD$11","v":506.00000000000006}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Québec (653km)",653,{"$f":"AD27*$AD$11","v":359.15000000000003}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - St-Urbain (555 km)",555,{"$f":"AD28*$AD$11","v":305.25}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"(X29+Y29+IF(I29<0,0,J29+H29))","v":0},null,null,0,0,null,null,null,"Sept-Iles- Baie-Comeau (233 km)",233,{"$f":"AD29*$AD$11","v":128.15}]
["TOTAL",null,null,{"$f":"SUM(D14:D29)","v":0},null,null,null,{"$f":"SUM(H14:H29)","v":0},null,{"$f":"SUM(J14:J29)","v":0},null,{"$f":"SUM(L14:L29)","v":0},null,null,null,null,null,null,null,null,{"$f":"(X30+Y30+IF(I30<0,0,J30+H30))","v":0},null,null,0,0,null,null,null,"Sept-Iles- Natasquan (377km)",{"$f":"154+223","v":377},{"$f":"$AD$11*AD30","v":207.35000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total du frais de la sortie annuelle ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Corner Brooke (350km)",{"$f":"298+52","v":350},192.50000000000003]
[null,"Date",{"$f":"TODAY()","v":"2022-07-18"},null,null,null,"Réservé à l'administration",null,null,null,null,null,null,{"$f":"SUM(L14:L29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - DeerLake (298km)",298,163.9,null,null,null,null,null,null,null,null,"Allocation lors des déplacemen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Port-aux Basques (577km)",{"$f":"298+52+75+152","v":577},317.35000000000002,null,null,null,null,null,null,null,null,"Village","Aéroport","Bureau de poste","Quai","Village"]
["SIGNATURE DE L'EMPLOYÉ:",null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Stephenville (425km)",{"$f":"298+52+75","v":425},233.75000000000003,null,null,null,null,null,null,null,null,"Blanc-Sablon",10,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Paul -Blanc-sablon (20km)",20,11,null,null,null,null,null,null,null,null,"Chevery",8,8,8,0]
[null,null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery (succursale)",8,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington",0,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kégaska",8,8,8,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,null,null,"Québec",null,null,null,"Remb frais ",null,null,null,null,null,null,null,null,"La Romaine",8,8,8,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,null,null,"Montréal",null,null,null,"Chevery/  St-Augustin (130,00$)",130,null,null,null,null,null,null,null,"La Tabatière",8,8,8,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,null,null,"Sept-iles ",null,null,null,"Chevery/  St-Augustin (150,00$) commercial ",150,null,null,null,null,null,null,null,"Middle bay",0,0,0,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,null,null,"Corner Brooke",null,null,null,"Chevery/ Harrington Harbour (16,50$)",16.5,null,null,null,null,null,null,null,"Mutton Bay",8,8,8,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,null,null,"Gatineau",null,null,null,"Chevery/ Harrington Harbour (45,000$)commercial ",45,null,null,null,null,null,null,null,"Old Fort Bay",75,8,8,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,null,null,"Malbaie",null,null,null,"Chevery/ Kegaska (142,50$)",142.5,null,null,null,null,null,null,null,"Port-Menier",8,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baie-Comeau",null,null,null,"Chevery/ Kegaska (150,00$)commercial ",150,null,null,null,null,null,null,null,"St-Augustin",8,8,8,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,null,null,"Natasquan",null,null,null,"Chevery/ La Tabatière (125,00$)commercial ",125,null,null,null,null,null,null,null,"St-Paul",51.5,8,24,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,null,null,"Havre-St-Pierre",null,null,null,"Chevery/ La Tabatière (75,50$)",75.5,null,null,null,null,null,null,null,"Tête-à-la-Baleine",8,8,18,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,null,null,"Sherbrooke",null,null,null,"Chevery/ Tête-a-la-Baleine (37,50$)",37.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kegaska",null,null,null,"Chevery/ Tête-a-la-Baleine (75,00$)commercial ",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Romaine",null,null,null,"Chevery/La Romaine (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery",null,null,null,"Chevery/La Romaine (90.00$)",90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington Harbour",null,null,null,"Hébergement (sans reçu 30$)",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-à-la-Baleine",null,null,null,"Kegaska / La Romaine (53,50$)",53.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Port Menier",null,null,null,"Kegaska / La Romaine (53,50$)commercial ",53.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mutton Bay",null,null,null,"Kegaska/Natasquan (45.00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La Tabatière",null,null,null,"Kegaska/Natasquan (50.00$)commercial ",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin",null,null,null,"La Tabatière/ Mutton Bay(12,00$)",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Fort Bay",null,null,null,"La Tabatière/ Mutton Bay(25,00$)commercial",25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rivière St-Paul",null,null,null,"La Tabatière/ Rivière St-Augustin (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lourdes-de-Blanc-Sablon",null,null,null,"La Tabatière/ Rivière St-Augustin (54,50$)",54.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon",null,null,null,"St-Augustin/ Old Fort Bay (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin/ Old Fort Bay (75,50$)",75.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-a-la-Baleine/ La Tabatière (45,00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-a-la-Baleine/ La Tabatière (50,00$)commercial ",50]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,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":"FORMULAIRE (2)","index":2,"n_rows":123,"n_cols":44,"rows_kept":123,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,11,4,13],[0,0,0,2],[0,3,0,4],[0,13,0,14],[1,7,1,8],[2,0,2,3],[5,1,5,3],[5,11,5,12],[5,13,5,14],[6,1,6,2],[6,11,6,12],[6,13,6,14],[7,0,7,3],[8,0,8,3],[9,0,9,3],[12,1,12,2],[12,4,12,5],[13,12,13,13],[14,1,14,2],[14,4,14,5],[14,12,14,13],[15,1,15,2],[15,4,15,5],[15,12,15,13],[13,1,13,2],[13,4,13,5],[16,1,16,2],[16,4,16,5],[16,12,16,13],[17,1,17,2],[17,4,17,5],[17,12,17,13],[18,1,18,2],[18,4,18,5],[18,12,18,13],[19,1,19,2],[19,4,19,5],[19,12,19,13],[20,1,20,2],[20,4,20,5],[20,12,20,13],[21,1,21,2],[21,4,21,5],[21,12,21,13],[22,1,22,2],[22,4,22,5],[22,12,22,13],[23,1,23,2],[23,4,23,5],[23,12,23,13],[24,1,24,2],[24,4,24,5],[24,12,24,13],[25,1,25,2],[25,4,25,5],[25,12,25,13],[26,1,26,2],[26,4,26,5],[26,12,26,13],[27,1,27,2],[27,4,27,5],[27,12,27,13],[31,2,31,3],[31,13,33,13],[34,0,35,4],[28,1,28,2],[28,4,28,5],[28,12,28,13],[29,0,29,2],[29,4,29,5],[29,12,29,13]]}
["NUMÉRO DE MATRICULE: ",null,null,null,null,null,"Sortie annuelle :","Aller/Retour",null,null,null,"Numéro de frais de sortie",null,{"$f":"TODAY()","v":44760},null,null,null,null,"Aller ",null,null,"000-0-00000-000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO1,K14)","v":false},{"$f":"CODE(AM1)","v":70},"oui",{"$f":"IF(AN1=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["NOM et Prénom de l'employé",null,null,null,null,null,"Destination: ","Montréal",null,null,null,null,null,null,null,null,null,null,"Aller/Retour",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oui",null,{"$f":"EXACT(AO2,K15)","v":false},{"$f":"CODE(AM2)","v":70},"oui",{"$f":"IF(AN2=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
[null,null,null,null,null,null,null,null,null,"    am    pm",null,null,null,null,null,null,null,null,"Retour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO3,K16)","v":false},{"$f":"CODE(AM3)","v":70},"oui",{"$f":"IF(AN3=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Adresse ",null,null,null,null,"DÉPART:",null,"HEURE:",null,null,null,null,null,null,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":"EXACT(AO4,K17)","v":false},70,"oui",0.55000000000000004]
["Rue:",null,null,null,null,null,null,null,null,null,null,"              réservé à l'administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Ville: ",null,null,null,null,"ARRIVÉE:",null,"HEURE:",null,null,null,"Vérifié par: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Province:",null,null,null,null,null,null,null,null,null,null,"Date :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Nom des personnes qui ont voyagé",null,null,null,null,"RETOUR:",null,"HEURE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,"ARRIVÉE:",null,"HEURE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61,1,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kilometre",0.55000000000000004,0.55000000000000004,null,"Frais fondés sur les reçu",null,null,null,"Province",null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD12*$AD$11","v":864.05000000000007},null,"Autobus",null,null,null,"Alberta",null,false,70,"oui",0.55000000000000004]
["Date","Km parcouru",null,"$ / km","Frais remboursé                          (montant employé)",null,"Frais fondés sur les reçus","Montant du reçu                              ($)"," Km  parcouru","$ / km","Covoiturage","Total de la ligne",null,"Justification","Reçu manquant",null,null,null,null,null,"Total ligne",null,null,"remb frais","Kilometrage","allocation versés entre village",null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD13*$AD$11","v":1035.6500000000001},null,"Autres",null,null,null,"Colombie-Britannique",null,false,70,"oui",0.55000000000000004]
[null,null,null,{"$f":"Y14","v":0},null,null,null,null,null,{"$f":"+IF(AN1=70,($I14*$AD$11),($I14*$AD$10)+((D14/$AD$11)*$AD$10)-D14)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U14,\" \"))","v":0},null,null,null,null,null,null,null,null,{"$f":"(X14+Y14+IF(I14<0,0,J14+H14))","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($E14,$AE$40:$AF$64,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$40:$AF$64,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD14*$AD$11","v":531.30000000000007},null,"Avion",null,null,null,"Île-du-Prince-Édouard",null,false,70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,{"$f":"+IF(AN2=70,($I15*$AD$11),($I15*$AD$10)+((D15/$AD$11)*$AD$10)-D15)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U15,\" \"))","v":0},null,null,null,null,null,null,null,null,{"$f":"(X15+Y15+IF(I15<0,0,J15+H15))","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($E15,$AE$40:$AF$64,2,FALSE))=TRUE, ,VLOOKUP($E15,$AE$40:$AF$64,2,FALSE))","v":0},0,null,null,null,"Kegaska - Natasquan (49 km)",49,{"$f":"AD15*$AD$11","v":26.950000000000003},null,"Déjeuner (max 10$)",null,null,null,"Manitoba",null,false,70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Lourdes-de-Blanc-Sablon - Blanc-Sablon (3,7km)",3.7,{"$f":"$AE$11*AD16","v":2.0350000000000001},null,"Dîner (max 15$)",null,null,null,"Nouveau-Brunswick",null,{"$f":"EXACT(AO16,K29)","v":false},70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Montréal - Toronto (556km)",556,{"$f":"$AD$11*AD17","v":305.8},null,"Hébergement, fact d'hôtel",null,null,null,"Nunavut",null,{"$f":"EXACT(AO17,K30)","v":false},70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,{"$f":"(IF(ISTEXT($H$2),U18,\" \"))","v":0},null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD18","v":111.10000000000001},null,"Repas journée (max 52$)",null,null,null,"Québec"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Old Fort bay - Rivière St-Paul (12$)",0,12,null,"Souper (max 27$)",null,null,null,"Saskatchewan"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Old Fort Bay-Blanc-Sablon  (30km)",30,{"$f":"AD20*$AE$11","v":16.5},null,"Stationnement, $ du reçu",null,null,null,"Terre-Neuve-et-Labrador"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec- Sherbrooke (254)",254,{"$f":"$AD$11*AD21","v":139.70000000000002},null,"Taxi, $ du reçu",null,null,null,"Territoire du Nord-Ouest"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec-Montréal (267km)",267,{"$f":"$AD$11*AD22","v":146.85000000000002},null,"Train, $ du reçu",null,null,null,"Yukon"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Rivière St-Paul - Blanc Sablon (65,8km)",{"$f":"22.2+28+11.9+3.7","v":65.8},{"$f":"AD23*$AE$11","v":36.190000000000005},null,"Transport en commun"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD24","v":122.65},null,"Traverse Blanc-Sablon - St-Barbe"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - La Malbaie (502 km)",502,{"$f":"AD25*$AD$11","v":276.10000000000002},null,"Traverse Port-aux-Basques - North Sydney"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Montreal (920)",920,{"$f":"AD26*$AD$11","v":506.00000000000006}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Québec (653km)",653,{"$f":"AD27*$AD$11","v":359.15000000000003}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - St-Urbain (555 km)",555,{"$f":"AD28*$AD$11","v":305.25}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"(X29+Y29+IF(I29<0,0,J29+H29))","v":0},null,null,0,0,null,null,null,"Sept-Iles- Baie-Comeau (233 km)",233,{"$f":"AD29*$AD$11","v":128.15}]
["TOTAL",null,null,{"$f":"SUM(D14:D29)","v":0},null,null,null,{"$f":"SUM(H14:H29)","v":0},null,{"$f":"SUM(J14:J29)","v":0},null,{"$f":"SUM(L14:L29)","v":0},null,null,null,null,null,null,null,null,{"$f":"(X30+Y30+IF(I30<0,0,J30+H30))","v":0},null,null,0,0,null,null,null,"Sept-Iles- Natasquan (377km)",{"$f":"154+223","v":377},{"$f":"$AD$11*AD30","v":207.35000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total du frais de la sortie annuelle ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Corner Brooke (350km)",{"$f":"298+52","v":350},192.50000000000003]
[null,"Date",{"$f":"TODAY()","v":"2022-07-18"},null,null,null,"Réservé à l'administration",null,null,null,null,null,null,{"$f":"SUM(L14:L29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - DeerLake (298km)",298,163.9,null,null,null,null,null,null,null,null,"Allocation lors des déplacemen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Port-aux Basques (577km)",{"$f":"298+52+75+152","v":577},317.35000000000002,null,null,null,null,null,null,null,null,"Village","Aéroport","Bureau de poste","Quai","Village"]
["SIGNATURE DE L'EMPLOYÉ:",null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Stephenville (425km)",{"$f":"298+52+75","v":425},233.75000000000003,null,null,null,null,null,null,null,null,"Blanc-Sablon",10,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Paul -Blanc-sablon (20km)",20,11,null,null,null,null,null,null,null,null,"Chevery",8,8,8,0]
[null,null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery (succursale)",8,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington",0,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kégaska",8,8,8,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,null,null,"Québec",null,null,null,"Remb frais ",null,null,null,null,null,null,null,null,"La Romaine",8,8,8,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,null,null,"Montréal",null,null,null,"Chevery/  St-Augustin (130,00$)",130,null,null,null,null,null,null,null,"La Tabatière",8,8,8,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,null,null,"Sept-iles ",null,null,null,"Chevery/  St-Augustin (150,00$) commercial ",150,null,null,null,null,null,null,null,"Middle bay",0,0,0,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,null,null,"Corner Brooke",null,null,null,"Chevery/ Harrington Harbour (16,50$)",16.5,null,null,null,null,null,null,null,"Mutton Bay",8,8,8,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,null,null,"Gatineau",null,null,null,"Chevery/ Harrington Harbour (45,000$)commercial ",45,null,null,null,null,null,null,null,"Old Fort Bay",75,8,8,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,null,null,"Malbaie",null,null,null,"Chevery/ Kegaska (142,50$)",142.5,null,null,null,null,null,null,null,"Port-Menier",8,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baie-Comeau",null,null,null,"Chevery/ Kegaska (150,00$)commercial ",150,null,null,null,null,null,null,null,"St-Augustin",8,8,8,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,null,null,"Natasquan",null,null,null,"Chevery/ La Tabatière (125,00$)commercial ",125,null,null,null,null,null,null,null,"St-Paul",51.5,8,24,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,null,null,"Havre-St-Pierre",null,null,null,"Chevery/ La Tabatière (75,50$)",75.5,null,null,null,null,null,null,null,"Tête-à-la-Baleine",8,8,18,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,null,null,"Sherbrooke",null,null,null,"Chevery/ Tête-a-la-Baleine (37,50$)",37.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kegaska",null,null,null,"Chevery/ Tête-a-la-Baleine (75,00$)commercial ",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Romaine",null,null,null,"Chevery/La Romaine (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery",null,null,null,"Chevery/La Romaine (90.00$)",90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington Harbour",null,null,null,"Hébergement (sans reçu 30$)",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-à-la-Baleine",null,null,null,"Kegaska / La Romaine (53,50$)",53.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Port Menier",null,null,null,"Kegaska / La Romaine (53,50$)commercial ",53.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mutton Bay",null,null,null,"Kegaska/Natasquan (45.00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La Tabatière",null,null,null,"Kegaska/Natasquan (50.00$)commercial ",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin",null,null,null,"La Tabatière/ Mutton Bay(12,00$)",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Fort Bay",null,null,null,"La Tabatière/ Mutton Bay(25,00$)commercial",25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rivière St-Paul",null,null,null,"La Tabatière/ Rivière St-Augustin (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lourdes-de-Blanc-Sablon",null,null,null,"La Tabatière/ Rivière St-Augustin (54,50$)",54.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon",null,null,null,"St-Augustin/ Old Fort Bay (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin/ Old Fort Bay (75,50$)",75.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-a-la-Baleine/ La Tabatière (45,00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-a-la-Baleine/ La Tabatière (50,00$)commercial ",50]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,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":"FORMULAIRE (3)","index":3,"n_rows":123,"n_cols":44,"rows_kept":123,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,11,4,13],[0,0,0,2],[0,3,0,4],[0,13,0,14],[1,7,1,8],[2,0,2,3],[5,1,5,3],[5,11,5,12],[5,13,5,14],[6,1,6,2],[6,11,6,12],[6,13,6,14],[7,0,7,3],[8,0,8,3],[9,0,9,3],[12,1,12,2],[12,4,12,5],[13,12,13,13],[14,1,14,2],[14,4,14,5],[14,12,14,13],[15,1,15,2],[15,4,15,5],[15,12,15,13],[13,1,13,2],[13,4,13,5],[16,1,16,2],[16,4,16,5],[16,12,16,13],[17,1,17,2],[17,4,17,5],[17,12,17,13],[18,1,18,2],[18,4,18,5],[18,12,18,13],[19,1,19,2],[19,4,19,5],[19,12,19,13],[20,1,20,2],[20,4,20,5],[20,12,20,13],[21,1,21,2],[21,4,21,5],[21,12,21,13],[22,1,22,2],[22,4,22,5],[22,12,22,13],[23,1,23,2],[23,4,23,5],[23,12,23,13],[24,1,24,2],[24,4,24,5],[24,12,24,13],[25,1,25,2],[25,4,25,5],[25,12,25,13],[26,1,26,2],[26,4,26,5],[26,12,26,13],[27,1,27,2],[27,4,27,5],[27,12,27,13],[31,2,31,3],[31,13,33,13],[34,0,35,4],[28,1,28,2],[28,4,28,5],[28,12,28,13],[29,0,29,2],[29,4,29,5],[29,12,29,13]]}
["NUMÉRO DE MATRICULE: ",null,null,null,null,null,"Sortie annuelle :","Aller/Retour",null,null,null,"Numéro de frais de sortie",null,{"$f":"TODAY()","v":44760},null,null,null,null,"Aller ",null,null,"000-0-00000-000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO1,K14)","v":false},{"$f":"CODE(AM1)","v":70},"oui",{"$f":"IF(AN1=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["NOM et Prénom de l'employé",null,null,null,null,null,"Destination: ","Montréal",null,null,null,null,null,null,null,null,null,null,"Aller/Retour",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oui",null,{"$f":"EXACT(AO2,K15)","v":false},{"$f":"CODE(AM2)","v":70},"oui",{"$f":"IF(AN2=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
[null,null,null,null,null,null,null,null,null,"    am    pm",null,null,null,null,null,null,null,null,"Retour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXACT(AO3,K16)","v":false},{"$f":"CODE(AM3)","v":70},"oui",{"$f":"IF(AN3=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Adresse ",null,null,null,null,"DÉPART:",null,"HEURE:",null,null,null,null,null,null,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":"EXACT(AO4,K17)","v":false},70,"oui",0.55000000000000004]
["Rue:",null,null,null,null,null,null,null,null,null,null,"              réservé à l'administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Ville: ",null,null,null,null,"ARRIVÉE:",null,"HEURE:",null,null,null,"Vérifié par: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Province:",null,null,null,null,null,null,null,null,null,null,"Date :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
["Nom des personnes qui ont voyagé",null,null,null,null,"RETOUR:",null,"HEURE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,"ARRIVÉE:",null,"HEURE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61,1,null,null,null,null,null,null,null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kilometre",0.55000000000000004,0.55000000000000004,null,"Frais fondés sur les reçu",null,null,null,"Province",null,false,70,"oui",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD12*$AD$11","v":864.05000000000007},null,"Autobus",null,null,null,"Alberta",null,false,70,"oui",0.55000000000000004]
["Date","Km parcouru",null,"$ / km","Frais remboursé                          (montant employé)",null,"Frais fondés sur les reçus","Montant du reçu                              ($)"," Km  parcouru","$ / km","Covoiturage","Total de la ligne",null,"Justification","Reçu manquant",null,null,null,null,null,"Total ligne",null,null,"remb frais","Kilometrage","allocation versés entre village",null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD13*$AD$11","v":1035.6500000000001},null,"Autres",null,null,null,"Colombie-Britannique",null,false,70,"oui",0.55000000000000004]
[null,null,null,{"$f":"Y14","v":0},null,null,null,null,null,{"$f":"+IF(AN1=70,($I14*$AD$11),($I14*$AD$10)+((D14/$AD$11)*$AD$10)-D14)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U14,\" \"))","v":0},null,null,null,null,null,null,null,null,{"$f":"(X14+Y14+IF(I14<0,0,J14+H14))","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($E14,$AE$40:$AF$64,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$40:$AF$64,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$12:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD14*$AD$11","v":531.30000000000007},null,"Avion",null,null,null,"Île-du-Prince-Édouard",null,false,70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,{"$f":"+IF(AN2=70,($I15*$AD$11),($I15*$AD$10)+((D15/$AD$11)*$AD$10)-D15)","v":0},null,{"$f":"(IF(ISTEXT($H$2),U15,\" \"))","v":0},null,null,null,null,null,null,null,null,{"$f":"(X15+Y15+IF(I15<0,0,J15+H15))","v":0},null,null,{"$f":"IF(ISNA(VLOOKUP($E15,$AE$40:$AF$64,2,FALSE))=TRUE, ,VLOOKUP($E15,$AE$40:$AF$64,2,FALSE))","v":0},0,null,null,null,"Kegaska - Natasquan (49 km)",49,{"$f":"AD15*$AD$11","v":26.950000000000003},null,"Déjeuner (max 10$)",null,null,null,"Manitoba",null,false,70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Lourdes-de-Blanc-Sablon - Blanc-Sablon (3,7km)",3.7,{"$f":"$AE$11*AD16","v":2.0350000000000001},null,"Dîner (max 15$)",null,null,null,"Nouveau-Brunswick",null,{"$f":"EXACT(AO16,K29)","v":false},70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Montréal - Toronto (556km)",556,{"$f":"$AD$11*AD17","v":305.8},null,"Hébergement, fact d'hôtel",null,null,null,"Nunavut",null,{"$f":"EXACT(AO17,K30)","v":false},70,"oui",0.55000000000000004]
[null,null,null,0,null,null,null,null,null,0,null,{"$f":"(IF(ISTEXT($H$2),U18,\" \"))","v":0},null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD18","v":111.10000000000001},null,"Repas journée (max 52$)",null,null,null,"Québec"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Old Fort bay - Rivière St-Paul (12$)",0,12,null,"Souper (max 27$)",null,null,null,"Saskatchewan"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Old Fort Bay-Blanc-Sablon  (30km)",30,{"$f":"AD20*$AE$11","v":16.5},null,"Stationnement, $ du reçu",null,null,null,"Terre-Neuve-et-Labrador"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec- Sherbrooke (254)",254,{"$f":"$AD$11*AD21","v":139.70000000000002},null,"Taxi, $ du reçu",null,null,null,"Territoire du Nord-Ouest"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Québec-Montréal (267km)",267,{"$f":"$AD$11*AD22","v":146.85000000000002},null,"Train, $ du reçu",null,null,null,"Yukon"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Rivière St-Paul - Blanc Sablon (65,8km)",{"$f":"22.2+28+11.9+3.7","v":65.8},{"$f":"AD23*$AE$11","v":36.190000000000005},null,"Transport en commun"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD24","v":122.65},null,"Traverse Blanc-Sablon - St-Barbe"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - La Malbaie (502 km)",502,{"$f":"AD25*$AD$11","v":276.10000000000002},null,"Traverse Port-aux-Basques - North Sydney"]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Montreal (920)",920,{"$f":"AD26*$AD$11","v":506.00000000000006}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - Québec (653km)",653,{"$f":"AD27*$AD$11","v":359.15000000000003}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,"Sept-Iles - St-Urbain (555 km)",555,{"$f":"AD28*$AD$11","v":305.25}]
[null,null,null,0,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"(X29+Y29+IF(I29<0,0,J29+H29))","v":0},null,null,0,0,null,null,null,"Sept-Iles- Baie-Comeau (233 km)",233,{"$f":"AD29*$AD$11","v":128.15}]
["TOTAL",null,null,{"$f":"SUM(D14:D29)","v":0},null,null,null,{"$f":"SUM(H14:H29)","v":0},null,{"$f":"SUM(J14:J29)","v":0},null,{"$f":"SUM(L14:L29)","v":0},null,null,null,null,null,null,null,null,{"$f":"(X30+Y30+IF(I30<0,0,J30+H30))","v":0},null,null,0,0,null,null,null,"Sept-Iles- Natasquan (377km)",{"$f":"154+223","v":377},{"$f":"$AD$11*AD30","v":207.35000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total du frais de la sortie annuelle ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Corner Brooke (350km)",{"$f":"298+52","v":350},192.50000000000003]
[null,"Date",{"$f":"TODAY()","v":"2022-07-18"},null,null,null,"Réservé à l'administration",null,null,null,null,null,null,{"$f":"SUM(L14:L29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - DeerLake (298km)",298,163.9,null,null,null,null,null,null,null,null,"Allocation lors des déplacemen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Port-aux Basques (577km)",{"$f":"298+52+75+152","v":577},317.35000000000002,null,null,null,null,null,null,null,null,"Village","Aéroport","Bureau de poste","Quai","Village"]
["SIGNATURE DE L'EMPLOYÉ:",null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Stephenville (425km)",{"$f":"298+52+75","v":425},233.75000000000003,null,null,null,null,null,null,null,null,"Blanc-Sablon",10,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Paul -Blanc-sablon (20km)",20,11,null,null,null,null,null,null,null,null,"Chevery",8,8,8,0]
[null,null,null,null,null,null,"CODE:____________________________________________________________________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery (succursale)",8,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington",0,8,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kégaska",8,8,8,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,null,null,"Québec",null,null,null,"Remb frais ",null,null,null,null,null,null,null,null,"La Romaine",8,8,8,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,null,null,"Montréal",null,null,null,"Chevery/  St-Augustin (130,00$)",130,null,null,null,null,null,null,null,"La Tabatière",8,8,8,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,null,null,"Sept-iles ",null,null,null,"Chevery/  St-Augustin (150,00$) commercial ",150,null,null,null,null,null,null,null,"Middle bay",0,0,0,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,null,null,"Corner Brooke",null,null,null,"Chevery/ Harrington Harbour (16,50$)",16.5,null,null,null,null,null,null,null,"Mutton Bay",8,8,8,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,null,null,"Gatineau",null,null,null,"Chevery/ Harrington Harbour (45,000$)commercial ",45,null,null,null,null,null,null,null,"Old Fort Bay",75,8,8,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,null,null,"Malbaie",null,null,null,"Chevery/ Kegaska (142,50$)",142.5,null,null,null,null,null,null,null,"Port-Menier",8,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baie-Comeau",null,null,null,"Chevery/ Kegaska (150,00$)commercial ",150,null,null,null,null,null,null,null,"St-Augustin",8,8,8,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,null,null,"Natasquan",null,null,null,"Chevery/ La Tabatière (125,00$)commercial ",125,null,null,null,null,null,null,null,"St-Paul",51.5,8,24,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,null,null,"Havre-St-Pierre",null,null,null,"Chevery/ La Tabatière (75,50$)",75.5,null,null,null,null,null,null,null,"Tête-à-la-Baleine",8,8,18,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,null,null,"Sherbrooke",null,null,null,"Chevery/ Tête-a-la-Baleine (37,50$)",37.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kegaska",null,null,null,"Chevery/ Tête-a-la-Baleine (75,00$)commercial ",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Romaine",null,null,null,"Chevery/La Romaine (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery",null,null,null,"Chevery/La Romaine (90.00$)",90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrington Harbour",null,null,null,"Hébergement (sans reçu 30$)",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-à-la-Baleine",null,null,null,"Kegaska / La Romaine (53,50$)",53.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Port Menier",null,null,null,"Kegaska / La Romaine (53,50$)commercial ",53.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mutton Bay",null,null,null,"Kegaska/Natasquan (45.00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La Tabatière",null,null,null,"Kegaska/Natasquan (50.00$)commercial ",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin",null,null,null,"La Tabatière/ Mutton Bay(12,00$)",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Old Fort Bay",null,null,null,"La Tabatière/ Mutton Bay(25,00$)commercial",25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rivière St-Paul",null,null,null,"La Tabatière/ Rivière St-Augustin (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lourdes-de-Blanc-Sablon",null,null,null,"La Tabatière/ Rivière St-Augustin (54,50$)",54.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc-Sablon",null,null,null,"St-Augustin/ Old Fort Bay (125,00$)commercial ",125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin/ Old Fort Bay (75,50$)",75.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-a-la-Baleine/ La Tabatière (45,00$)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tête-a-la-Baleine/ La Tabatière (50,00$)commercial ",50]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,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":"Modèle ","index":4,"n_rows":207,"n_cols":38,"rows_kept":207,"cut":false,"hidden":true,"merged":[[30,1,30,3],[32,17,34,17],[4,2,4,5],[7,2,7,5],[6,2,6,5],[32,12,32,13],[30,4,30,5],[32,4,32,5],[4,16,4,17],[6,16,6,17],[7,9,7,10],[9,9,9,10],[4,7,4,9],[11,8,11,9],[29,11,29,14]]}
[]
[null,null,"LOGO CS DU LITTORAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frais",null,"Nom du supérieur immédiat"]
[null,null,"Nom  du demandeur",null,null,null,null,"FRAIS    ",null,null,null,null,null,null,null,null,"CODE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Frais de formation",null,"Deborah Foltin"]
[null,null,"William Smith-Dufault",null,null,null,null,"Frais de rencontre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frais de rencontre",null,"Eileen Schofield"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janet Gallupe"]
[null,null,"Nom du supérieur immédiat",null,null,null,null,null,null,null,null,null,null,"    am            pm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jean Picard"]
[null,null,"Jean Picard",null,null,null,null,null,"DATE DE DÉPART:","2010-06-09",null,"HEURE:","10:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jean-Jacques Rhéaume"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lucy DeMendoça"]
[null,null,null,null,null,null,null,null,"DATE DE RETOUR:","2010-06-15",null,"HEURE:","09:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marc-André Masse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Martine Joncas"]
[null,null,"Date","Nb  jour","Frais Km","$","Frais remboursé                          (montant employé)","$","Allocations versées",null,"Nb fois","$","Frais fondés sur les reçus","Montant du reçu                              ($)","Nbr Km ","$","Total de la ligne","Justification","Reçu manquant",null,null,null,null,"Total ligne",null,null,"remb frais","Kilometrage","allocation versés entre village",null,null,null,"Nadia Landry",null,null,"Frais fondés sur les reçu"]
[null,null,"2010-06-10",2,"Blanc-Sablon -Sept-Iles (1800km)",{"$f":"AB13","v":828},"Chevery/ Tête-a-la-Baleine (37,50)",{"$f":"AA13","v":37.5},"Bureau de poste","La Romaine",4,{"$f":"IF($K13>0,$AC13*$K13,\" \")","v":32},"Taxi, $ du reçu",25,900,{"$f":"IF(O13>0,O13*0.46,\" \")","v":414},{"$f":"IF(D13>0,X13,\" \")","v":1336.5},null,null,null,null,null,null,{"$f":"(AA13+AB13+(AC13*K13))+IF(O13<0,0,(O13*0.46))+N13","v":1336.5},null,null,{"$f":"IF(ISNA(VLOOKUP($G13,$AH$34:$AI$52,2,FALSE))=TRUE, ,VLOOKUP($G13,$AH$34:$AI$52,2,FALSE))","v":37.5},{"$f":"IF(ISNA(VLOOKUP($E13,$AF$22:$AH$28,3,FALSE))=TRUE, ,VLOOKUP($E13,$AF$22:$AH$28,3,FALSE))","v":828},{"$f":"IF($K13=0,0, IF($AB76=1,(VLOOKUP($J13,$AH$78:$AI$91,2)),IF($AB76=2,(VLOOKUP($J13,$AH$78:$AJ$91,3)),IF($AB76=3,(VLOOKUP($J13,$AH$78:$AK$91,4)),IF($AB76=4,(VLOOKUP($J13,$AH$78:$AL$91,5)),)))))","v":8},null,null,null,"Philipp Robertson",null,null,"autobus"]
[null,null,"2010-06-14",2,"Sept-Iles - Montreal (900)",{"$f":"AB14","v":414},"frais de repas 1/2 jour (dejeuner-Diner) (33,00)",{"$f":"AA14","v":33},"Village","Kégaska",4,{"$f":"IF($K14>0,$AC14*$K14,\" \")","v":0},"Stationnement, $ du reçu",45,34,{"$f":"IF(O14>0,O14*0.46,\" \")","v":15.64},{"$f":"IF(D14>0,X14,\" \")","v":507.64},null,null,null,null,null,null,{"$f":"(AA14+AB14+(AC14*K14))+IF(O14<0,0,(O14*0.46))+N14","v":507.64},null,null,33,{"$f":"IF(ISNA(VLOOKUP($E14,$AF$22:$AH$28,3,FALSE))=TRUE, ,VLOOKUP($E14,$AF$22:$AH$28,3,FALSE))","v":414},{"$f":"IF($K14=0,0, IF($AB77=1,(VLOOKUP($J14,$AH$78:$AI$92,2)),IF($AB77=2,(VLOOKUP($J14,$AH$78:$AJ$92,3)),IF($AB77=3,(VLOOKUP($J14,$AH$78:$AK$92,4)),IF($AB77=4,(VLOOKUP($J14,$AH$78:$AL$92,5)),)))))","v":0},null,null,null,"Vincent Joncas",null,null,"Autres"]
[null,null,"2010-06-14",4,"OFB-Blanc-Sablon  (30km)",14.7,"Hébergment (sans reçu)",{"$f":"AA15","v":30},"Aéroport","Chevery",2,16,null,null,null,{"$f":"IF(O15>0,O15*0.46,\" \")","v":" "},{"$f":"IF(D15>0,X15,\" \")","v":60.7},null,null,null,null,null,null,60.7,null,null,30,14.7,{"$f":"IF($K15=0,0, IF($AB78=1,(VLOOKUP($J15,$AH$78:$AI$92,2)),IF($AB78=2,(VLOOKUP($J15,$AH$78:$AJ$92,3)),IF($AB78=3,(VLOOKUP($J15,$AH$78:$AK$92,4)),IF($AB78=4,(VLOOKUP($J15,$AH$78:$AL$92,5)),)))))","v":8},null,null,null,"William Macneil",null,null,"Avion"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null,{"$f":"IF(O16>0,O16*0.46,\" \")","v":" "}," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,"Yves Crépeau",null,null,"Hébergement, fact d'hôtel"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,null,null,null,"Stationnement, $ du reçu"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,null,null,null,"Taxi, $ du reçu"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,null,null,null,"Train, $ du reçu"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,null,null,null,"Transport en commun"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"Kilometre",0.46,0.49,null,"Traverse BS-TN"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"Blanc-Sablon- NL (500km)",500,{"$f":"AG22*$AG$21","v":230},null,"Traverse St-Barbe"]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"Blanc-Sablon -Sept-Iles (1800km)",1800,{"$f":"AG23*$AG$21","v":828}]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"LBS - Blanc-Sablon (10km)",10,{"$f":"$AH$21*AG24","v":4.9000000000000004}]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"OFB-Blanc-Sablon  (30km)",30,{"$f":"AG25*AH21","v":14.7}]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"Sept-Iles - Montreal (900)",900,{"$f":"AG26*$AG$21","v":414}]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"Sept-Iles - Quebec (700km)",700,{"$f":"AG27*$AG$21","v":322}]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0,null,null,"St-Paul -Blanc-sablon (20km)",20,{"$f":"$AH$21*AG28","v":9.8000000000000007}]
[null,null,null,null,null,0,null,0,null,null,null," ",null,null,null," "," ",null,null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2022-07-18"},null,"Réservé à l'administration"]
[null,"Signature de l'employé "]
[null,null,null,null,null,null,null,null,null,null,null,"Saisi par:",null,null,null,null,null,"Total du frais de déplacement "]
[null,"Signature du superviseur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q13:Q29)","v":1904.84},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remb frais "]
[null,null,null,null,null,null,null,null,null,null,null,"Code:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery/ Harrington Harbour (16,50)",16.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery/ Kegaska (142,50)",142.5]
[null,null,null,null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery/ La Tabatière (75,50)",75.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery/ Rivière St-Augustin (130,00)",130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery/ Tête-a-la-Baleine (37,50)",37.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chevery/La Romaine (90.00)",90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T(C8)","v":"Jean Picard"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dejeuner (10,00)",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diner (15,00)",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"frais de repas 1/2 jour (dejeuner-Diner) (33,00)",33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frais de repas 1/2 jour (Diner-Souper 50,00)",{"$f":"15+ 27+8","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hébergment (sans reçu)",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kegaska / La Romaine (53,50)",53.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kegaska/Natasquan (45.00)",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La Tabatière/ Old Fort Bay (12,00)",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La Tabatière/ Rivière St-Augustin (54,50)",54.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rivière St-Augustin/ Old Fort Bay (75,50)",75.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Souper (27,00)",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,"Tête-a-la-Baleine/ La Tabatière (45,00)",45]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mutton Bay"]
[]
[]
[null,null,null,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":"VLOOKUP($I13,$AD$78:$AE$81,2)","v":2},null,null,null,null,null,"Allocation lors des déplacemen"]
[null,null,null,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":"VLOOKUP($I14,$AD$78:$AE$81,2)","v":4},null,null,null,null,null,"Village","Aéroport","Bureau de poste","Quai","Village"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Aéroport",1,null,null,"Blanc-Sablon",10,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},null,"Bureau de poste",2,null,null,"Chevery",8,8,8,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,null,null,null,{"$error":"#N/A"},null,"Quai",3,null,null,"Chevery (succursale)",8,8,8,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,null,null,null,{"$error":"#N/A"},null,"Village",4,null,null,"Harrington",0,8,8,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,null,null,null,{"$error":"#N/A"},null,null,null,null,null,"Kégaska",8,8,8,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,null,null,null,{"$error":"#N/A"},null,null,null,null,null,"La Romaine",8,8,8,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,null,null,null,{"$error":"#N/A"},null,null,null,null,null,"La Tabatière",8,8,8,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,null,null,null,{"$error":"#N/A"},null,null,null,null,null,"Middle bay",0,0,0,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,null,null,null,{"$error":"#N/A"},null,null,null,null,null,"Mutton Bay",8,8,8,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,null,null,null,{"$error":"#N/A"},null,null,null,null,null,"Old Fort Bay",75,8,8,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,null,null,null,null,null,null,null,null,null,"Port-Menier",8,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Augustin",8,8,8,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,null,null,null,null,null,null,null,null,null,"St-Paul",51.5,8,24,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,null,null,null,null,null,null,null,null,null,"Tête-à-la-Baleine",8,8,18,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,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[]
[]
[null,null,"  "]
[null,null,"  "]
[null,null,"  "]
[null,null,"  "]
[null,null,"  "]
[null,null,"  "]
[null,null,"  "]
[null,null,"  "]
[null,null,"  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Frais Quotidiens hors Québec",null,null,null,null,null,null,null,null,null,null,null,null,"Frais fondés sur les reçus hors Québec"]
[]
[null,null,"Allocation forf 12 hres -ADM  67,50$",67.5,null,null,null,null,null,null,null,null,null,null,null,"Allocation forf modifiée"]
[null,null,"Allocation forf 12 hres -ADM 135$",135,null,null,null,null,null,null,null,null,null,null,null,"Allocation quotidienne 60% de l'héberg.+ repas"]
[null,null,"Repas - Déjeuner  10,40$",10.4,"Indemnité -Repas au Québec-Déjeuner (Dir. 61111, art.13a) 10,40$",null,null,null,null,null,null,null,null,null,null,"Appel téléphonique - Bureau, $ du reçu"]
[null,null,"Repas - Diner  14.30$",14.3,"Indemnité -Repas au Québec-Diner (Dir. 61111, art. 13b) 14.30$",null,null,null,null,null,null,null,null,null,null,"Appel téléphonique - Personnel, $ du reçu"]
[null,null,"Repas - Souper  21.55$",21.55,"Indemnité -Repas au Québec-Souper (Dir. 61111, art. 13c) 21.55$",null,null,null,null,null,null,null,null,null,null,"Assignation - Indem, hebdomadaire"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Autres"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Essence (pr loc d'auto), "]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Frais d'obtention - Devises"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Frais d'obtention - Passeport"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Hébergement, fact d'hôtel"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Location de voiture"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Petites dépenses (10%)"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"R-Déjeuner au restaurant (20%"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"R-Diner au restaurant (35%)"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"R-Repas jour complet"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"R-Souper au restaurant (45%)"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Stationnement, $ du reçu"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Taxi, $ du reçu"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Train, $ du reçu"]
[null,null,"  ",null,null,null,null,null,null,null,null,null,null,null,null,"Transport en commun"]
[null,null,"  "]
[null,null,"  "]