{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Example","FORM(1)","FORM(2)","FORM(3)"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":20,"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":"Example","index":0,"n_rows":123,"n_cols":44,"rows_kept":123,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,11,4,14],[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,1,13,2],[13,4,13,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],[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],[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,1,29,2],[29,4,29,5],[29,12,29,13],[31,2,31,3],[31,13,32,13]]}
["EMPLOYEE NUMBER",null,null,689000000,null,null,"Annual Outing:","One Way",null,null,null,"Outing Expense #",null,{"$f":"TODAY()","v":44760},null,null,null,null,"One Way",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},"yes",{"$f":"IF(AN1=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.46}]
["Name of employee",null,null,null,null,null,"DESTINATION: ","Montréal",null,null,null,null,null,null,null,null,null,null,"Round Trip",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes",{"$f":"EXACT(AO2,K15)","v":true},{"$f":"CODE(AM2)","v":86},"yes",{"$f":"IF(AN2=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.64}]
["Keven Labrie",null,null,null,null,null,null,null,null,"    am    pm",null,null,null,null,null,null,null,null,"Return",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},"yes",{"$f":"IF(AN3=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.46}]
["Address",null,null,null,null,"DEPARTURE","2012-05-12","TIME:","06: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,"yes",0.46]
["Address:","56 street land",null,null,null,null,null,null,null,null,null,"             administrative use ",null,null,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,"yes",0.46]
["City:","Sept-Iles",null,null,null,"ARRIVED","2012-05-14","TIME:","12:00:00",null,null,"Verified by :",null,null,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,"yes",0.46]
["Province:","Québec",null,"G0G 1W0",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,"yes",0.46]
["Name of the persons who travelled",null,null,null,null,"DEPARTURE","2012-06-02","TIME:","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,"yes",0.46]
["Keven, Jen, Sara",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"yes",0.46]
[null,null,null,null,null,"ARRIVED","2012-06-03","TIME:","05:00:00",null,null,null,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,"yes",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,"Kilometer",0.46,0.49,null,"Cost with receipts",null,null,null,"Province",null,false,70,"yes",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,null,null,null,null,"Breakfast (max 10$)",null,null,null,"Alberta",null,false,70,"yes",0.46]
["Date","Kilometers ",null,"$ / km","Reimbursed expenses  (employee's amount)",null,"Expenses according to the receipts","Amount received "," Km covered","$ / km","Car Pool","Total",null,"Justification","Missing receipt",null,null,null,null,null,"Total ",null,null,"cost reimbursed","Kilometers","allocated amounts between villages",null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD13*$AD$11","v":722.66000000000008},null,"Bus",null,null,null,"British Columbia",null,false,70,"yes",0.46]
["2012-05-12","Sept-Îles - Montreal (920)",null,{"$f":"Y14","v":423.20000000000005},null,null,"Plane",1600,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":2023.2},"Plane St-Augustin to Sept-Iles",null,null,null,null,null,null,null,{"$f":"(X14+Y14+IF(I14<0,0,J14+H14))","v":2023.2},null,null,{"$f":"IF(ISNA(VLOOKUP($E14,$AE$39:$AF$59,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$39:$AF$59,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$13:$AE$34,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$13:$AE$34,3,FALSE))","v":423.20000000000005},null,null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD14*$AD$11","v":866.18000000000006},null,"Ferry Blanc-Sablon - St-Barbe",null,null,null,"Prince Edward Island",null,false,70,"yes",0.46]
["2012-06-02","Sept-Îles - Montreal (920)",null,423.20000000000005,null,null,"Lunch (max 15$)",13.25,null,{"$f":"+IF(AN2=70,($I15*$AD$11),($I15*$AD$10)+((D15/$AD$11)*$AD$10)-D15)","v":165.60000000000002},"yes",602.05000000000007,"return with (name employee) S-Iles to MTL",null,null,null,null,null,null,null,602.05000000000007,null,null,{"$f":"IF(ISNA(VLOOKUP($E15,$AE$39:$AF$59,2,FALSE))=TRUE, ,VLOOKUP($E15,$AE$39:$AF$59,2,FALSE))","v":0},423.20000000000005,null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD15*$AD$11","v":444.36},null,"Ferry Port-aux-Basques - North Sydney",null,null,null,"Manitoba",null,false,70,"yes",0.46]
[null,null,null,0,null,null,"Supper (max 27$)",24.59,null,0,null,24.59,null,null,null,null,null,null,null,null,24.59,null,null,0,0,null,null,null,"Lourdes-de-Blanc-Sablon - Blanc-Sablon (3,7km)",3.7,{"$f":"$AE$11*AD16","v":1.8129999999999999},null,"Lodging with hotel receipt",null,null,null,"New Brunswick",null,false,70,"yes",0.46]
[null,null,null,0,null,null,"Taxi, $ receipt",25,null,0,null,25,"airport to Sept-iles",null,null,null,null,null,null,null,25,null,null,0,0,null,null,null,"Montréal - Toronto (556km)",556,{"$f":"$AD$11*AD17","v":255.76000000000002},null,"Lunch (max 15$)",null,null,null,"Nunavut",null,false,70,"yes",0.46]
[null,null,null,0,null,null,"Lunch (max 15$)",123,null,0,null,123,null,null,null,null,null,null,null,null,123,null,null,0,0,null,null,null,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD18","v":92.92},null,"Meals ($52/day)",null,null,null,"Québec"]
["2012-06-03",null,null,0,"Chevery/  St-Augustin (130,00$)",null,"Plane",null,null,0,null,130,"Sept-Iles to chevery ",null,null,null,null,null,null,null,130,null,null,130,0,null,null,null,"Old Fort Bay - Rivière St-Paul (12$)",0,12,null,"Other",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":14.7},null,"Parking, $ receipt",null,null,null,"Newfoundland"]
[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":116.84},null,"Plane",null,null,null,"Northwest Territories"]
[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 (213km)",213,{"$f":"$AD$11*AD22","v":97.98},null,"Public transportation",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":32.241999999999997},null,"Supper (max 27$)"]
[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-Îles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD24","v":102.58},null,"Taxi, $ receipt"]
[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-Îles - La Malbaie (502 km)",502,{"$f":"AD25*$AD$11","v":230.92000000000002},null,"Train, $ receipt"]
[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-Îles - Montreal (920)",920,{"$f":"AD26*$AD$11","v":423.20000000000005}]
[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-Îles - Québec (653km)",653,{"$f":"AD27*$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-Îles- 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,0,null,null,0,0,null,null,null,"Sept-Îles- Natashquan (377km)",{"$f":"154+223","v":377},{"$f":"$AD$11*AD29","v":173.42000000000002}]
[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,"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 of outing expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St-Barbe - Deer Lake (298km)",298,137.08000000000001]
[null,"Date",{"$f":"TODAY()","v":"2022-07-18"},null,null,null,"Administrative use",null,null,null,null,null,null,{"$f":"SUM(L14:L30)","v":2927.84},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,"Travelling allocation"]
[null,null,null,null,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","Airport","Post office","Dock","Village"]
["Employee signature:",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,"Remb costs",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,"Chevery/  St-Augustin (130,00$)",130,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/ Harrington Harbour (16,50$)",16.5,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-Îles",null,null,null,"Chevery/ Kegaska (142,50$)",142.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/ La Tabatière (75,50$)",75.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/ Tête-a-la-Baleine (37,50$)",37.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/La Romaine (90.00$)",90,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,"Lodging (without receipt 30$)",30,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,"Natashquan",null,null,null,"Kegaska / La Romaine (53,50$)",53.5,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/Natashquan (45.00$)",45,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,"La Tabatière/ Vieux-Fort (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,"Kegaska",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,"La Romaine",null,null,null,"St-Augustin/ Vieux Fort (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,"Chevery",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,"Harrington Harbour"]
[null,null,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,"Vieux-Fort"]
[null,null,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":"FORM(1)","index":1,"n_rows":123,"n_cols":63,"rows_kept":123,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,11,4,14],[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,32,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]]}
["EMPLOYEE NUMBER",null,null,null,null,null,"Annual Outing:","Round Trip",null,null,null,"Outing Expense #",null,{"$f":"TODAY()","v":44760},null,null,null,null,"One Way",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},"yes",{"$f":"IF(AN1=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Name of employee",null,null,null,null,null,"DESTINATION: ","Montréal",null,null,null,null,null,null,null,null,null,null,"Round Trip",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes",{"$f":"EXACT(AO2,K15)","v":false},{"$f":"CODE(AM2)","v":70},"yes",{"$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,"Return",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},"yes",{"$f":"IF(AN3=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Address",null,null,null,null,"DEPARTURE",null,"TIME:",null,null,null,null,null,null,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,"yes",0.55000000000000004]
["Address:",null,null,null,null,null,null,null,null,null,null,"             administrative use ",null,null,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,"yes",0.55000000000000004]
["City:",null,null,null,null,"ARRIVED",null,"TIME:",null,null,null,"Verified by :",null,null,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,"yes",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,"yes",0.55000000000000004]
["Name of the persons who travelled",null,null,null,null,"DEPARTURE",null,"TIME:",null,null,null,null,null,null,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,"yes",0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"yes",0.55000000000000004]
[null,null,null,null,null,"ARRIVED",null,"TIME:",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,"yes",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,"Kilometer",0.55000000000000004,0.55000000000000004,null,"Cost with receipts",null,null,null,"Province",null,false,70,"yes",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,"Breakfast (max 10$)",null,null,null,"Alberta",null,false,70,"yes",0.55000000000000004]
["Date","Kilometers ",null,"$ / km","Reimbursed expenses  (employee's amount)",null,"Expenses according to the receipts","Amount of receipts"," Km covered","$ / km","Car Pool","Total",null,"Justification","Missing receipt",null,null,null,null,null,"Total ",null,null,"cost reimbursed","Kilometers","allocated amounts between villages",null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD13*$AD$11","v":864.05000000000007},null,"Bus",null,null,null,"British Columbia",null,false,70,"yes",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$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$39:$AF$61,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$13:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$13:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD14*$AD$11","v":1035.6500000000001},null,"Ferry Blanc-Sablon - St-Barbe",null,null,null,"Prince Edward Island",null,false,70,"yes",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,0,null,null,{"$f":"IF(ISNA(VLOOKUP($E15,$AE$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E15,$AE$39:$AF$61,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B15,$AC$13:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B15,$AC$13:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD15*$AD$11","v":531.30000000000007},null,"Ferry Port-aux-Basques - North Sydney",null,null,null,"Manitoba",null,false,70,"yes",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,{"$f":"IF(ISNA(VLOOKUP($E16,$AE$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E16,$AE$39:$AF$61,2,FALSE))","v":0},0,null,null,null,"Kegaska - Natasquan (49 km)",49,{"$f":"$AD$11*AD16","v":26.950000000000003},null,"Lodging with hotel receipt",null,null,null,"New Brunswick",null,false,70,"yes",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*AD17","v":2.0350000000000001},null,"Lunch (max 15$)",null,null,null,"Nunavut",null,false,70,"yes",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*AD18","v":305.8},null,"Meals ($52/day)",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,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD19","v":111.10000000000001},null,"Other",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 - Rivière St-Paul (12$)",0,12,null,"Parking, $ receipt",null,null,null,"Newfoundland"]
[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":"AD21*$AE$11","v":16.5},null,"Plane",null,null,null,"Northwest Territories"]
[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*AD22","v":139.70000000000002},null,"Public transportation",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,"Québec-Montréal (213km)",213,{"$f":"$AD$11*AD23","v":117.15},null,"Supper (max 27$)"]
[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":"AD24*$AE$11","v":36.190000000000005},null,"Taxi, $ receipt"]
[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-Îles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD25","v":122.65},null,"Train, $ receipt"]
[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-Îles - La Malbaie (502 km)",502,{"$f":"AD26*$AD$11","v":276.10000000000002}]
[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-Îles - Montreal (920)",920,{"$f":"AD27*$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-Îles - Québec (653km)",653,{"$f":"AD28*$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-Îles- 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,0,null,null,0,0,null,null,null,"Sept-Îles- Natashquan (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 of outing expenses",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,"Administrative use",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 - Deer Lake (298km)",298,163.9,null,null,null,null,null,null,null,null,"Travelling allocation"]
[null,null,null,null,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","Airport","Post office","Dock","Village"]
["Employee signature:",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,"Remb costs",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,"Baie-Comeau",null,null,null,"Chevery/  St-Augustin (130,00$)",130,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,"Blanc-Sablon",null,null,null,"Chevery/  St-Augustin (150,00$) commercial ",150,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,"Chevery",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/ Harrington Harbour (45,000$)commercial ",45,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/ Kegaska (142,50$)",142.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,"Harrington Harbour",null,null,null,"Chevery/ Kegaska (150,00$)commercial ",150,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,"Havre-St-Pierre",null,null,null,"Chevery/ La Tabatière (125,00$)commercial ",125,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,"Kegaska",null,null,null,"Chevery/ La Tabatière (75,50$)",75.5,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,"La Romaine",null,null,null,"Chevery/ Tête-a-la-Baleine (37,50$)",37.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,"La Tabatière",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,"Lourdes-de-Blanc-Sablon",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,"Malbaie",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,"Montréal",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,"Mutton Bay",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,"Natashquan",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,"Port Menier",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,"Québec",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,"Rivière St-Paul",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,"Sept-Îles",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,"Sherbrooke",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,"St-Augustin",null,null,null,"Lodging (without receipt 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,"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,"Toronto",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,"Vieux-Fort"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,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":"FORM(2)","index":2,"n_rows":123,"n_cols":63,"rows_kept":123,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,11,4,14],[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,32,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]]}
["EMPLOYEE NUMBER",null,null,null,null,null,"Annual Outing:","Round Trip",null,null,null,"Outing Expense #",null,{"$f":"TODAY()","v":44760},null,null,null,null,"One Way",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},"yes",{"$f":"IF(AN1=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Name of employee",null,null,null,null,null,"DESTINATION: ","Montréal",null,null,null,null,null,null,null,null,null,null,"Round Trip",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes",{"$f":"EXACT(AO2,K15)","v":false},{"$f":"CODE(AM2)","v":70},"yes",{"$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,"Return",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},"yes",{"$f":"IF(AN3=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Address",null,null,null,null,"DEPARTURE",null,"TIME:",null,null,null,null,null,null,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,"yes",0.55000000000000004]
["Address:",null,null,null,null,null,null,null,null,null,null,"             administrative use ",null,null,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,"yes",0.55000000000000004]
["City:",null,null,null,null,"ARRIVED",null,"TIME:",null,null,null,"Verified by :",null,null,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,"yes",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,"yes",0.55000000000000004]
["Name of the persons who travelled",null,null,null,null,"DEPARTURE",null,"TIME:",null,null,null,null,null,null,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,"yes",0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"yes",0.55000000000000004]
[null,null,null,null,null,"ARRIVED",null,"TIME:",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,"yes",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,"Kilometer",0.55000000000000004,0.55000000000000004,null,"Cost with receipts",null,null,null,"Province",null,false,70,"yes",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,"Breakfast (max 10$)",null,null,null,"Alberta",null,false,70,"yes",0.55000000000000004]
["Date","Kilometers ",null,"$ / km","Reimbursed expenses  (employee's amount)",null,"Expenses according to the receipts","Amount of receipts"," Km covered","$ / km","Car Pool","Total",null,"Justification","Missing receipt",null,null,null,null,null,"Total ",null,null,"cost reimbursed","Kilometers","allocated amounts between villages",null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD13*$AD$11","v":864.05000000000007},null,"Bus",null,null,null,"British Columbia",null,false,70,"yes",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$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$39:$AF$61,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$13:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$13:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD14*$AD$11","v":1035.6500000000001},null,"Ferry Blanc-Sablon - St-Barbe",null,null,null,"Prince Edward Island",null,false,70,"yes",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,0,null,null,{"$f":"IF(ISNA(VLOOKUP($E15,$AE$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E15,$AE$39:$AF$61,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B15,$AC$13:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B15,$AC$13:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD15*$AD$11","v":531.30000000000007},null,"Ferry Port-aux-Basques - North Sydney",null,null,null,"Manitoba",null,false,70,"yes",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,{"$f":"IF(ISNA(VLOOKUP($E16,$AE$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E16,$AE$39:$AF$61,2,FALSE))","v":0},0,null,null,null,"Kegaska - Natasquan (49 km)",49,{"$f":"$AD$11*AD16","v":26.950000000000003},null,"Lodging with hotel receipt",null,null,null,"New Brunswick",null,false,70,"yes",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*AD17","v":2.0350000000000001},null,"Lunch (max 15$)",null,null,null,"Nunavut",null,false,70,"yes",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*AD18","v":305.8},null,"Meals ($52/day)",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,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD19","v":111.10000000000001},null,"Other",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 - Rivière St-Paul (12$)",0,12,null,"Parking, $ receipt",null,null,null,"Newfoundland"]
[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":"AD21*$AE$11","v":16.5},null,"Plane",null,null,null,"Northwest Territories"]
[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*AD22","v":139.70000000000002},null,"Public transportation",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,"Québec-Montréal (213km)",213,{"$f":"$AD$11*AD23","v":117.15},null,"Supper (max 27$)"]
[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":"AD24*$AE$11","v":36.190000000000005},null,"Taxi, $ receipt"]
[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-Îles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD25","v":122.65},null,"Train, $ receipt"]
[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-Îles - La Malbaie (502 km)",502,{"$f":"AD26*$AD$11","v":276.10000000000002}]
[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-Îles - Montreal (920)",920,{"$f":"AD27*$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-Îles - Québec (653km)",653,{"$f":"AD28*$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-Îles- 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,0,null,null,0,0,null,null,null,"Sept-Îles- Natashquan (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 of outing expenses",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,"Administrative use",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 - Deer Lake (298km)",298,163.9,null,null,null,null,null,null,null,null,"Travelling allocation"]
[null,null,null,null,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","Airport","Post office","Dock","Village"]
["Employee signature:",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,"Remb costs",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,"Baie-Comeau",null,null,null,"Chevery/  St-Augustin (130,00$)",130,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,"Blanc-Sablon",null,null,null,"Chevery/  St-Augustin (150,00$) commercial ",150,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,"Chevery",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/ Harrington Harbour (45,000$)commercial ",45,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/ Kegaska (142,50$)",142.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,"Harrington Harbour",null,null,null,"Chevery/ Kegaska (150,00$)commercial ",150,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,"Havre-St-Pierre",null,null,null,"Chevery/ La Tabatière (125,00$)commercial ",125,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,"Kegaska",null,null,null,"Chevery/ La Tabatière (75,50$)",75.5,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,"La Romaine",null,null,null,"Chevery/ Tête-a-la-Baleine (37,50$)",37.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,"La Tabatière",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,"Lourdes-de-Blanc-Sablon",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,"Malbaie",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,"Montréal",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,"Mutton Bay",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,"Natashquan",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,"Port Menier",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,"Québec",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,"Rivière St-Paul",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,"Sept-Îles",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,"Sherbrooke",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,"St-Augustin",null,null,null,"Lodging (without receipt 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,"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,"Toronto",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,"Vieux-Fort"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,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":"FORM(3)","index":3,"n_rows":123,"n_cols":63,"rows_kept":123,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,11,4,14],[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,32,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]]}
["EMPLOYEE NUMBER",null,null,null,null,null,"Annual Outing:","Round Trip",null,null,null,"Outing Expense #",null,{"$f":"TODAY()","v":44760},null,null,null,null,"One Way",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},"yes",{"$f":"IF(AN1=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Name of employee",null,null,null,null,null,"DESTINATION: ","Montréal",null,null,null,null,null,null,null,null,null,null,"Round Trip",null,null,"999-9-99999-999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes",{"$f":"EXACT(AO2,K15)","v":false},{"$f":"CODE(AM2)","v":70},"yes",{"$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,"Return",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},"yes",{"$f":"IF(AN3=86,$AD$10*$AE$10,$AD$11*$AE$10)","v":0.55000000000000004}]
["Address",null,null,null,null,"DEPARTURE",null,"TIME:",null,null,null,null,null,null,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,"yes",0.55000000000000004]
["Address:",null,null,null,null,null,null,null,null,null,null,"             administrative use ",null,null,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,"yes",0.55000000000000004]
["City:",null,null,null,null,"ARRIVED",null,"TIME:",null,null,null,"Verified by :",null,null,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,"yes",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,"yes",0.55000000000000004]
["Name of the persons who travelled",null,null,null,null,"DEPARTURE",null,"TIME:",null,null,null,null,null,null,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,"yes",0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"yes",0.55000000000000004]
[null,null,null,null,null,"ARRIVED",null,"TIME:",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,"yes",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,"Kilometer",0.55000000000000004,0.55000000000000004,null,"Cost with receipts",null,null,null,"Province",null,false,70,"yes",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,"Breakfast (max 10$)",null,null,null,"Alberta",null,false,70,"yes",0.55000000000000004]
["Date","Kilometers ",null,"$ / km","Reimbursed expenses  (employee's amount)",null,"Expenses according to the receipts","Amount of receipts"," Km covered","$ / km","Car Pool","Total",null,"Justification","Missing receipt",null,null,null,null,null,"Total ",null,null,"cost reimbursed","Kilometers","allocated amounts between villages",null,null,"Blanc-Sablon - Rimouski (1571 km)",{"$f":"1883-312","v":1571},{"$f":"AD13*$AD$11","v":864.05000000000007},null,"Bus",null,null,null,"British Columbia",null,false,70,"yes",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$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E14,$AE$39:$AF$61,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B14,$AC$13:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B14,$AC$13:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon -Québec (1883km)",1883,{"$f":"AD14*$AD$11","v":1035.6500000000001},null,"Ferry Blanc-Sablon - St-Barbe",null,null,null,"Prince Edward Island",null,false,70,"yes",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,0,null,null,{"$f":"IF(ISNA(VLOOKUP($E15,$AE$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E15,$AE$39:$AF$61,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B15,$AC$13:$AE$35,3,FALSE))=TRUE, ,VLOOKUP($B15,$AC$13:$AE$35,3,FALSE))","v":0},null,null,null,"Blanc-Sablon- St-John(966km)",966,{"$f":"AD15*$AD$11","v":531.30000000000007},null,"Ferry Port-aux-Basques - North Sydney",null,null,null,"Manitoba",null,false,70,"yes",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,{"$f":"IF(ISNA(VLOOKUP($E16,$AE$39:$AF$61,2,FALSE))=TRUE, ,VLOOKUP($E16,$AE$39:$AF$61,2,FALSE))","v":0},0,null,null,null,"Kegaska - Natasquan (49 km)",49,{"$f":"$AD$11*AD16","v":26.950000000000003},null,"Lodging with hotel receipt",null,null,null,"New Brunswick",null,false,70,"yes",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*AD17","v":2.0350000000000001},null,"Lunch (max 15$)",null,null,null,"Nunavut",null,false,70,"yes",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*AD18","v":305.8},null,"Meals ($52/day)",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,"Montréal-Ottawa (202km)",202,{"$f":"$AD$11*AD19","v":111.10000000000001},null,"Other",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 - Rivière St-Paul (12$)",0,12,null,"Parking, $ receipt",null,null,null,"Newfoundland"]
[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":"AD21*$AE$11","v":16.5},null,"Plane",null,null,null,"Northwest Territories"]
[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*AD22","v":139.70000000000002},null,"Public transportation",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,"Québec-Montréal (213km)",213,{"$f":"$AD$11*AD23","v":117.15},null,"Supper (max 27$)"]
[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":"AD24*$AE$11","v":36.190000000000005},null,"Taxi, $ receipt"]
[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-Îles -  Havre-St-Pierre (223km)",223,{"$f":"$AD$11*AD25","v":122.65},null,"Train, $ receipt"]
[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-Îles - La Malbaie (502 km)",502,{"$f":"AD26*$AD$11","v":276.10000000000002}]
[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-Îles - Montreal (920)",920,{"$f":"AD27*$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-Îles - Québec (653km)",653,{"$f":"AD28*$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-Îles- 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,0,null,null,0,0,null,null,null,"Sept-Îles- Natashquan (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 of outing expenses",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,"Administrative use",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 - Deer Lake (298km)",298,163.9,null,null,null,null,null,null,null,null,"Travelling allocation"]
[null,null,null,null,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","Airport","Post office","Dock","Village"]
["Employee signature:",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,"Remb costs",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,"Baie-Comeau",null,null,null,"Chevery/  St-Augustin (130,00$)",130,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,"Blanc-Sablon",null,null,null,"Chevery/  St-Augustin (150,00$) commercial ",150,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,"Chevery",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/ Harrington Harbour (45,000$)commercial ",45,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/ Kegaska (142,50$)",142.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,"Harrington Harbour",null,null,null,"Chevery/ Kegaska (150,00$)commercial ",150,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,"Havre-St-Pierre",null,null,null,"Chevery/ La Tabatière (125,00$)commercial ",125,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,"Kegaska",null,null,null,"Chevery/ La Tabatière (75,50$)",75.5,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,"La Romaine",null,null,null,"Chevery/ Tête-a-la-Baleine (37,50$)",37.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,"La Tabatière",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,"Lourdes-de-Blanc-Sablon",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,"Malbaie",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,"Montréal",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,"Mutton Bay",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,"Natashquan",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,"Port Menier",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,"Québec",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,"Rivière St-Paul",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,"Sept-Îles",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,"Sherbrooke",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,"St-Augustin",null,null,null,"Lodging (without receipt 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,"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,"Toronto",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,"Vieux-Fort"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"  "]
[]
[]
["  "]
["  "]
["  "]
["  "]
["  "]
["  "]
["  "]
["  "]
["  "]