{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["27 janvier 2018","TABLES","Modifications"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":9,"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":"27 janvier 2018","index":0,"n_rows":106,"n_cols":38,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,0,3,1],[4,2,4,3],[4,4,4,5],[4,1,5,1],[0,28,1,29],[2,28,3,29],[0,2,3,27],[4,0,5,0]]}
["ENTREPRISE MARTIN",null,"CUMULATIF 2018",null,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":"PROPER(TEXT(AC3,\"jjjj\"))","v":"Samedi"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-27"]
[]
["N","NOM DE L'EMPLOYÉ","HEURE A.M.",null,"HEURE P.M.",null,"H","000","050","101","102","001","002","151","153","156","151","201","201","201","303","309","400","509",null,null,null,"T.V.H","CHANTIERS","N°"]
[null,null,"DE","À","DE","À","PR.",null,"DD",null,null,null,null,"MU",null,"PL","CO","DD","CR","MU"]
[1,"Denis Jacques",7,12,12.5,15.5,{"$f":"D7-C7+F7-E7","v":8},2,1,null,null,null,3,null,1,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H7:AA7)","v":8},"HOTEL CLASSIQUE",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC7,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5501"}]
[2,"Malagigi Deniger",6,12,12.5,14.5,{"$f":"D8-C8+F8-E8","v":8},null,null,null,null,null,2,null,null,null,null,null,null,6,null,null,null,null,null,null,null,{"$f":"SUM(H8:AA8)","v":8},"CENTRE DES CONGRES",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC8,TABLES!$G$2:$G$50,0),2),\"\")","v":"16-5406"}]
[3,"Manville Hughes",7,12,null,null,{"$f":"D9-C9+F9-E9","v":5},null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,5,"MARLY",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC9,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5490"}]
[4,"Lance Mathieu",6.5,12,12.5,15,8,null,null,null,4,null,null,null,null,null,2,2,null,null,null,null,null,null,null,null,null,8,"MARLY",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC10,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5490"}]
[5,"Franck Rousseau",7,12,12.5,17,9.5,1,2,null,null,2,null,3,null,null,1.5,null,null,null,null,null,null,null,null,null,null,9.5,"MARLY",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC11,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5490"},null," "]
[6,"Merle Saurel",10,12,12.5,18.5,8,null,null," ",null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,8,"CHU",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC12,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5506"},null,null,null,null," "]
[7,"Éric Tanguay",7,11,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"HOPITAL LAVAL",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC13,TABLES!$G$2:$G$50,0),2),\"\")","v":"16-5307"},null,null,null,null,null," "]
[8,"Luc Béland",7,12,12.5,15.5,8,null,null,null,null,2,3,1,1,1,null,null,null,null,null,null,null,null,null,null,null,8,"MARLY",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC14,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5490"}]
[9,"Roslyn Beaudry",7,12,12.5,15.5,8,null,null,2,1,1,1,1,1,null,null,null,null,1,null,null,null,null,null,null,null,8,"HOTEL CLASSIQUE",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC15,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5501"}]
[10,"Jay Tougas",7,12,12.5,15.5,8,null,null,null,2,null,3,null,1,null,1,1,null,null,null,null,null,null,null,null,null,8,"HOPITAL LAVAL",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC16,TABLES!$G$2:$G$50,0),2),\"\")","v":"16-5307"}]
[11,"Talbot Savard",6.5,12,12.5,15,8,1,null,null,3,null,null,null,null,2,null,null,2,null,null,null,null,null,null,null,null,8,"PÉRISCOPE",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC17,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5430"},null,null,null," ",null,null,null," "]
[12,"Olivier Turcotte",7,12,12.5,17,9.5,null,1,1,null,null,3,null,2,null,2.5,null,null,null,null,null,null,null,null,null,null,9.5,"CENTRE DES CONGRES",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC18,TABLES!$G$2:$G$50,0),2),\"\")","v":"16-5406"},null,null,null,null,null," "]
[13,"Turner Devost",10,12,12.5,18.5,8,null,null,2,3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"PÉRISCOPE",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC19,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5430"}]
[14,"Zacharie Salmons",7,12,null,null,5,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,5,"HOPITAL LAVAL",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC20,TABLES!$G$2:$G$50,0),2),\"\")","v":"16-5307"},null,null,null,null," "]
[15,"Zacharie Salmons",null,null,12,12.5,0.5,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,3,"PÉRISCOPE",{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC21,TABLES!$G$2:$G$50,0),2),\"\")","v":"17-5430"}]
[16,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC22,TABLES!$G$2:$G$50,0),2),\"\")","v":""},null,null,null,null,null," "]
[17,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC23,TABLES!$G$2:$G$50,0),2),\"\")","v":""},null,null,null,null," "]
[18,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC24,TABLES!$G$2:$G$50,0),2),\"\")","v":""},null," "," "," "]
[19,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC25,TABLES!$G$2:$G$50,0),2),\"\")","v":""},null,null,null,null,null,null," "]
[20,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC26,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[21,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC27,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[22,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC28,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[23,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC29,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[24,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC30,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[25,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC31,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[26,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC32,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[27,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC33,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[28,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC34,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[29,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC35,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[30,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC36,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[31,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC37,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[32,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC38,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[33,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC39,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[34,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC40,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[35,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC41,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[36,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC42,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[37,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC43,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[38,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC44,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[39,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC45,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[40,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC46,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[41,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC47,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[42,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC48,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[43,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC49,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[44,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC50,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[45,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC51,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[46,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC52,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[47,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC53,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[48,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC54,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[49,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC55,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[50,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC56,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[51,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC57,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[52,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC58,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[53,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC59,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[54,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC60,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[55,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC61,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[56,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC62,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[57,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC63,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[58,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC64,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[59,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC65,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[60,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC66,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[61,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC67,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[62,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC68,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[63,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC69,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[64,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC70,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[65,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC71,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[66,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H72:AA72)","v":0},null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC72,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[67,null,null,null,null,null,{"$f":"D73-C73+F73-E73","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC73,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[68,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC74,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[69,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC75,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[70,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC76,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[71,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC77,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[72,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC78,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[73,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC79,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[74,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC80,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[75,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC81,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[76,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC82,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[77,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC83,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[78,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC84,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[79,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC85,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[80,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC86,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[81,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC87,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[82,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC88,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[83,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC89,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[84,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC90,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[85,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC91,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[86,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC92,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[87,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC93,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[88,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC94,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[89,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC95,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[90,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC96,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[91,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC97,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[92,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC98,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[93,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC99,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[94,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC100,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[95,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC101,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[96,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC102,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[97,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC103,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[98,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC104,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[99,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC105,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]
[100,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX(TABLES!$G$2:$H$50,MATCH(AC106,TABLES!$G$2:$G$50,0),2),\"\")","v":""}]

{"sheet":"TABLES","index":1,"n_rows":103,"n_cols":8,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["CODES","TACHES","TYPES","TYPES D'INTERVENTION","EMPLOYÉS","SOUS TRAITANTS","CHANTIERS","N°"]
[]
["000","Organisation","AP","Appareil D'Appui","Arnou Bienvenue","Acier E.B.","HOPITAL LAVAL","16-5307"]
["000","Organisation De Chantier","BAL","Base De Lampadaire","Arridano Talon","Acier Écan","CENTRE DES CONGRES","16-5406"]
["001","Mobilisation/Démobilisation","BPO","Bout De Poutre","Auriville Hervieux","Armatech","PÉRISCOPE","17-5430"]
["002","Mur De Protection","CA","Canniveau","Bevis Tessier","Art-Dem","MARLY","17-5490"]
["003","Protection Générale","CH","Chape","Byron Daviau","Béton Provinciale","HOTEL CLASSIQUE","17-5501"]
["004","Échafaudage","CO","Colonnes","Chappell Chartré","Blastrac Pierre-Luc Veilleux","CHU","17-5506"]
["005","Étaiement","CR","Chasses-Roues","Charles Viens","Cimota","ADM","18-ADM"]
["006","Accès Et Entretien","CU","Culée","Delmar Lavallée","Construction Carrier"]
["007","Protection Temporaire","DA","Dalle","Denis Jacques","Diamantex"]
["008","Chute À Déchets","DD","Dessus Dalle","Éric Despins","Excavations AGCC"]
["009","Encapsulation","DIA","Diaphragme","Éric Méthot","Excavations Desgagné"]
["010","Protection Pour Chauffage","DR","Drain","Éric Tanguay","Gicleurs Québécois"]
["011","Main D'œuvre","ES","Escalier","Franck Rousseau","Imperméabilisation Eric Lessard"]
["020","Signalisation","GLI","Glissiere De Béton","Frontino Sorel","Imperméabilisation RAE"]
["050","Démolition","HYD","Hydro","Gabriel Gamelin","JM Lambert"]
["051","Démolition - Marteau-Piqueur","JC","Joint De Contrôle","Ganelon Bélair","La Truelle D'Or"]
["052","Démolition - Tramac","JD","Joint De Dilatation","Germain Carignan","Les Ferrailleurs Du Québec"]
["053","Démolition De Pelle","JETU","Jersey Tunnel","Honoré Quessy","Mécanique Ducro"]
["054","Démolition À Cisaille","MBL","Murs De Blocs","Javier Boncoeur","Monsieur Watt"]
["055","Démolition Générale (Propre)","ME","Membrane","Jay Tougas","Multi-Métal"]
["056","Hydrodémolition- Spinjet","MEC","Démolition De Mécanique","Jean Couturier","Nasco"]
["057","Hydrodémolition- Robot","MGY","Démolition Murs De Gypse","Karel Guertin","Plomberie Pichette"]
["058","Hydrodémolition-Lance","MTE","Démolition Murs Terracota","Kerman Marleau","Pompage Optimum"]
["059","Démolition De Mécanique","MU","Murs","Lance Mathieu","Profer"]
["060","Démolition-Scarification","PA","Passerelle","Luc Béland","Revenco"]
["061","Nettoyage","PE","Pleine Épaisseur","Malagigi Deniger","Sani-Orléans"]
["062","Enlèvement D'enduit","PFGY","Plafond Gypse Enlevement","Manville Hughes","Sciage Forage"]
["063","Bassin De Filtration Et Sédimentation","PFTU","Plafond Tuile Enlevement","Manville Provencher","Viking"]
["064","Enlèvement D'isolation Sur Mécanique","PI","Pile","Marc Quinn"]
["065","Lavage À Pression (Hydrodémolition)","PL","Dessous Dalle","Marlon Berthelette"]
["066","Nettoyage De Rebuts De Démolition","PLCE","Plancher Céramique Enlevement","Maslin Bourassa"]
["067","Démentèlement Pour Récupération","PLTU","Plancher Tuile Enlevement","Matthieu Thériault"]
["100","Lavage / Nettoyage","PO","Poutres","Matthieu Varieur"]
["101","Nettoyage De Chantier","SS","Super Structure","Merle Saurel"]
["102","Nettoyage Armature","TR","Transition","Michel Batard"]
["103","Nettoyage À L'eau Et À L'air","TRO","Trottoir","Nicolas Babin"]
["104","Lavage À Pression",null,null,"Noël De La Ronde"]
["105","Hydrodémolition-Lavage",null,null,"Normand Paiement"]
["106","Nettoyage Au Balai Mécanique",null,null,"Odo Ruel"]
["107","Nettoyage De Coffrage",null,null,"Olivier Marquis"]
["150","Armature",null,null,"Olivier Turcotte"]
["151","Forer/Poser Ancrages Pour Armature",null,null,"Paien Souplet"]
["152","Forer/Poser Ancrages À Béton Projeté",null,null,"Patrick Guernon"]
["153","Poser Armature",null,null,"Prewitt Francoeur"]
["154","Poser Treillis Métalique",null,null,"René Rossignol"]
["155","Couper Armature Existante",null,null,"Roger Louineaux"]
["156","Poser Manchons",null,null,"Roslyn Beaudry"]
["200","Béton",null,null,"Royden Sanschagrin"]
["201","Coffrage/Décoffrage",null,null,"Sidney Rhéaume"]
["202","Liant À Béton - Inhibiteur De Corrosion",null,null,"Talbot Savard"]
["203","Poser Scellant À Béton",null,null,"Tanguy Salmons"]
["204","Béton Projeté - Mûrissement",null,null,"Turner Devost"]
["205","Injection",null,null,"Tyson Goguen"]
["206","Resurfaçage Au Mortier",null,null,"Vachel Dupont"]
["207","Resurfaçage À L'époxy - Membrane",null,null,"Vaden Coulombe"]
["208","Traitement De Fissure",null,null,"Varden Chauvet"]
["209","Bétonnage",null,null,"Vick Nadeau"]
["210","Mûrissement",null,null,"Warrane Martel"]
["211","Bétonnage En Sac",null,null,"Yves Lafond"]
["212","Plastrage",null,null,"Zacharie Salmons"]
["213","Béton Remblai",null,null,null," "]
["214","Béton Rmaigre"]
["250","Membrane"]
["251","Préparation Des Surfaces"]
["252","Blastrac"]
["253","Application (Pose)"]
["300","Divers"]
["301","Enlèvement De Pavage"]
["302","Pose De Pavage"]
["303","Déficiences"]
["304","Poser Joint D'expansion"]
["305","Déblai/Remblai"]
["306","Entretien Mécanique"]
["307","Soudure"]
["308","Jet De Sable"]
["309","Métaux Ouvrés",null," "]
["310","Déneigement"]
["311","Protection Et Chauffage"]
["312","Chauffage De Pavage"]
["313","Meulage"]
["314","Forer Ancrages Au Rock"]
["315","Poser Filet Métallique"]
["316","Poser Appareil D'appui"]
["317","Déplacer Barge"]
["319","Poser Miradrain"]
["320","Chauffage Béton"]
["321","Lever Tablier"]
["400","Travaux Supplémentaires"]
["500","Architecture / Finition"]
["501","Démolition De Cloison Sèche (Gypse)"]
["502","Démolition De Mur De Bloc"]
["503","Pose De Cloison En Stud Bois Ou Métal"]
["504","Pose D'isolant"]
["505","Pose De Revêtement De Finition"]
["506","Pose De Solins"]
["507","Portes, Cadres Et Quincaillerie"]
["508","Peinture"]
["509","Joints De Scellant",null,null,null,null," "]
["600","Amiante"]
["601","Pour Travaux Amiante, Ajouté Le 6 Devant Le Code"]
[null,null,null,null,null,null," "]

{"sheet":"Modifications","index":2,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["MODIFICATIONS"]
[1,"changer onglet DATA en TABLES (les datas sont les données)"]
[2,"Onglet Tables : transformé colonne A en colonne texte pour pouvoir mettre la codification  avec 0 devant"]
[3,"Onglet Tables :manque le code 318 --> normal ??"]
[4,"Onglet Tables :que veux dire le code 6-- ?  Comment cela fonctionne t il ??"]
[5,"les heures sont en centièmes d'heures je suppose ??"]
[6,"Onglet d'encodage journalier : insertion d'une colonne H pour calcul des heures prestées suivant les heures déclarées."]
[7,"Onglet d'encodage journalier : MEFC pour la colonne Z si discordance avec colonne H (rouge)"]
[8,"Onglet d'encodage journalier : Il y a 17 codes possibles sur une feuille d'encodage journalier : c'est le maximum par jour ?? Par sécurité, j'en ai ajouté 3 pour faire un total de 20"]
[9,"Onglet d'encodage journalier : Quand il y a un sous code : c'est toujours valable pour toute la colonne ??  Il n'arrive pas que deux personnes travaillent pour le même code mais pour des sous codes différents (ou pas de sous code) ??"]
[10,"Onglet Tables :La table des noms a été transformée en \"TABLEAU EXCEL\" et ce tableau s'appelle EMPLOYES.  Les cellules contenant les noms ont été nommées EMPLOYE (sert dans la liste déroulante)"]
[11,"Onglet Tables : La table des chantiers a été transformée en \"TABLEAU EXCEL\" et ce tableau s'appelle CHANTIERS (contient 2 colonnes).  Les cellules contenant les noms de chantiers ont été nommées CHANTIER (sert dans la liste déroulante)"]
[12,"Onglet Tables : La table des codes tâches a été transformée en \"TABLEAU EXCEL\" et ce tableau s'appelle TACHES (contient 2 colonnes).  Les cellules contenant les codes ont été nommées CODE (sert dans la liste déroulante)"]
[13,"Onglet Tables : La table des codes interventions a été transformée en \"TABLEAU EXCEL\" et ce tableau s'appelle INTERVENTIONS (contient 2 colonnes).  Les cellules contenant les types ont été nommées TYPE (sert dans la liste déroulante)"]
[14,"Le tableau d'encodage journalier a été doté des différentes listes déroulantes"]
[15,"Onglet Tables : La table des sous-traitants (qui ne sert pas dans cette application) a été aussi transformée en \"TABLEAU EXCEL\" et ce tableau s'appelle SOUS_TRAITANTS.  Les cellules contenant les noms ont été nommées ST (pourrait servir dans une liste déroulante).  Ceci a été fait dans un souci d'homogénéité avec les autres tables"]
[16,"Onglet d'encodage journalier : Les boutons macros ont été déplacés hors champ du tableau"]
[17,"Onglet d'encodage journalier : La fusion des colonnes B et C a été supprimée et la colonne C enlevée (ne servait à rien)"]
[18,"Onglet d'encodage journalier : La colonne AD a été adaptée pour accueillir le numéro du chantier en fonction du nom de chantier déclaré en colonne AC"]