{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Employé","CUMULATIF","Modele","Début","P2","P3","P4","P5","Fin"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"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":"Employé","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Nom_employé","No_employé","Emploi"]
[null,null,3,"Employé y","B",null,"B = BUREAU (90010)"]
[null,null,4,"Employé x","C",null,"T = TRAVAILLEUR (80110)"]
[null,null,5,"Employer z","TA",null,"C = CHANTIER (80020)"]
[null,null,6,"Employer A","TA",null,"TA = TRAVAUX AUXILIAIRE"]
[null,null,7,"Employer B","B",null,"EX = EXCLUS"]
[null,null,8,"Employer C","EX"]

{"sheet":"CUMULATIF","index":1,"n_rows":22,"n_cols":20,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,19,6,19],[5,15,6,15],[5,16,6,16],[5,17,6,17],[5,18,6,18],[5,7,6,7],[5,9,6,9],[4,13,4,17],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[1,4,2,4],[1,1,2,3],[5,0,6,0],[5,1,6,1],[5,2,6,2]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[null,"N° de période à ajouter",null,null,6]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Poste"]
["N° employé","Nom employé","Revenu","Dépense",null,"Facture surplus",null,"Revenu généré","Excédent","Ne pas compter","HRS","taux",null,25,456,785,21,54,"Validation","Classification"]
[null,null,null,"(-)","(+)","(+)","Inclus",null,0]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne163","Colonne162","Colonne17"]
[3,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,2,FALSE))","v":"Employé y"},{"$f":"IFERROR(VLOOKUP($A9,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],C$1,FALSE),0)","v":3895.81},{"$f":"IFERROR(VLOOKUP($A9,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],D$1,FALSE),0)","v":10},{"$f":"IFERROR(VLOOKUP($A9,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A9,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],F$1,FALSE),0)","v":20},{"$f":"IFERROR(VLOOKUP($A9,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A9,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],H$1,FALSE),0)","v":3905.81},{"$f":"IFERROR(VLOOKUP($A9,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],I$1,FALSE),0)","v":3905.81},{"$f":"IFERROR(VLOOKUP($A9,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A9,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],K$1,FALSE),0)","v":110},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":35.507363636363635},{"$f":"IFERROR(VLOOKUP($A9,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A9,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],N$1,FALSE),0)","v":12},{"$f":"IFERROR(VLOOKUP($A9,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],O$1,FALSE),0)","v":15},{"$f":"IFERROR(VLOOKUP($A9,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],P$1,FALSE),0)","v":63},{"$f":"IFERROR(VLOOKUP($A9,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A9,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A9,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A9,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A9,_5[],R$1,FALSE),0)","v":20},{"$f":"IF(T9=\"EX\",\"OK validé\",(IF(A9=\"\",\"\",IF(SUM(M9+N9+O9+P9+Q9+R9)<>J9,\"À vérifier\",\"OK validé\"))))","v":"À vérifier"}]
[4,"Employé x",{"$f":"IFERROR(VLOOKUP($A10,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],C$1,FALSE),0)","v":2365},{"$f":"IFERROR(VLOOKUP($A10,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A10,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A10,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A10,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A10,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],H$1,FALSE),0)","v":2365},{"$f":"IFERROR(VLOOKUP($A10,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],I$1,FALSE),0)","v":2365},{"$f":"IFERROR(VLOOKUP($A10,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A10,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],K$1,FALSE),0)","v":110},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":21.5},{"$f":"IFERROR(VLOOKUP($A10,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A10,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],N$1,FALSE),0)","v":35},{"$f":"IFERROR(VLOOKUP($A10,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],O$1,FALSE),0)","v":35},{"$f":"IFERROR(VLOOKUP($A10,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],P$1,FALSE),0)","v":30},{"$f":"IFERROR(VLOOKUP($A10,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],Q$1,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A10,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A10,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A10,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A10,_5[],R$1,FALSE),0)","v":5},"À vérifier"]
[5,"Employer z",{"$f":"IFERROR(VLOOKUP($A11,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],C$1,FALSE),0)","v":1000},{"$f":"IFERROR(VLOOKUP($A11,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],H$1,FALSE),0)","v":1000},{"$f":"IFERROR(VLOOKUP($A11,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],I$1,FALSE),0)","v":1000},{"$f":"IFERROR(VLOOKUP($A11,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],K$1,FALSE),0)","v":32},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":31.25},{"$f":"IFERROR(VLOOKUP($A11,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],O$1,FALSE),0)","v":30},{"$f":"IFERROR(VLOOKUP($A11,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A11,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],Q$1,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A11,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A11,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A11,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A11,_5[],R$1,FALSE),0)","v":0},"À vérifier"]
[6,"Employer A",{"$f":"IFERROR(VLOOKUP($A12,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],C$1,FALSE),0)","v":1826.14},{"$f":"IFERROR(VLOOKUP($A12,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],D$1,FALSE),0)","v":325},{"$f":"IFERROR(VLOOKUP($A12,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A12,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],F$1,FALSE),0)","v":30},{"$f":"IFERROR(VLOOKUP($A12,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A12,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],H$1,FALSE),0)","v":1531.14},{"$f":"IFERROR(VLOOKUP($A12,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],I$1,FALSE),0)","v":1531.14},{"$f":"IFERROR(VLOOKUP($A12,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A12,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],K$1,FALSE),0)","v":50},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":30.622800000000002},{"$f":"IFERROR(VLOOKUP($A12,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],M$1,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A12,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A12,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],O$1,FALSE),0)","v":10},{"$f":"IFERROR(VLOOKUP($A12,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],P$1,FALSE),0)","v":25},{"$f":"IFERROR(VLOOKUP($A12,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],Q$1,FALSE),0)","v":10},{"$f":"IFERROR(VLOOKUP($A12,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A12,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A12,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A12,_5[],R$1,FALSE),0)","v":0},"À vérifier"]
[7,"Employer B",{"$f":"IFERROR(VLOOKUP($A13,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],C$1,FALSE),0)","v":650},{"$f":"IFERROR(VLOOKUP($A13,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A13,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A13,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A13,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A13,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],H$1,FALSE),0)","v":650},{"$f":"IFERROR(VLOOKUP($A13,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],I$1,FALSE),0)","v":650},{"$f":"IFERROR(VLOOKUP($A13,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A13,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],K$1,FALSE),0)","v":20},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":32.5},{"$f":"IFERROR(VLOOKUP($A13,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A13,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],N$1,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A13,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A13,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],P$1,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A13,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],Q$1,FALSE),0)","v":10},{"$f":"IFERROR(VLOOKUP($A13,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A13,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A13,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A13,_5[],R$1,FALSE),0)","v":0},"À vérifier"]
[8,"Employer C",{"$f":"IFERROR(VLOOKUP($A14,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],C$1,FALSE),0)","v":2920},{"$f":"IFERROR(VLOOKUP($A14,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],D$1,FALSE),0)","v":15},{"$f":"IFERROR(VLOOKUP($A14,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A14,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],F$1,FALSE),0)","v":75},{"$f":"IFERROR(VLOOKUP($A14,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A14,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],H$1,FALSE),0)","v":2980},{"$f":"IFERROR(VLOOKUP($A14,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A14,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],J$1,FALSE),0)","v":2980},{"$f":"IFERROR(VLOOKUP($A14,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],K$1,FALSE),0)","v":30},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A14,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],M$1,FALSE),0)","v":10},{"$f":"IFERROR(VLOOKUP($A14,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],N$1,FALSE),0)","v":15},{"$f":"IFERROR(VLOOKUP($A14,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A14,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A14,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A14,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A14,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A14,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A14,_5[],R$1,FALSE),0)","v":5},"À vérifier"]
[null,"",{"$f":"IFERROR(VLOOKUP($A15,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],C$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],H$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],K$1,FALSE),0)","v":0},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A15,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A15,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A15,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A15,_5[],R$1,FALSE),0)","v":0},""]
[null,"",{"$f":"IFERROR(VLOOKUP($A16,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],C$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],H$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],K$1,FALSE),0)","v":0},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A16,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A16,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A16,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A16,_5[],R$1,FALSE),0)","v":0},""]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Nom_employé,2,FALSE))","v":""},{"$f":"IFERROR(VLOOKUP($A17,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],C$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],H$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],K$1,FALSE),0)","v":0},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A17,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A17,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A17,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A17,_5[],R$1,FALSE),0)","v":0},{"$f":"IF(T17=\"EX\",\"OK validé\",(IF(A17=\"\",\"\",IF(SUM(M17+N17+O17+P17+Q17+R17)<>J17,\"À vérifier\",\"OK validé\"))))","v":""}]
[null,"",{"$f":"IFERROR(VLOOKUP($A18,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],C$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],H$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],K$1,FALSE),0)","v":0},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A18,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A18,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A18,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A18,_5[],R$1,FALSE),0)","v":0},""]
[null,"",{"$f":"IFERROR(VLOOKUP($A19,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],C$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],H$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],K$1,FALSE),0)","v":0},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A19,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A19,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A19,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A19,_5[],R$1,FALSE),0)","v":0},""]
[null,"",{"$f":"IFERROR(VLOOKUP($A20,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],C$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],H$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],K$1,FALSE),0)","v":0},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A20,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A20,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A20,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A20,_5[],R$1,FALSE),0)","v":0},""]
[null,"",{"$f":"IFERROR(VLOOKUP($A21,_2[],C$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],C$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],C$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],C$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],D$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],D$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],D$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],D$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],E$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],E$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],E$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],E$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],F$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],F$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],F$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],F$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],G$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],G$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],G$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],G$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],H$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],H$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],H$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],H$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],I$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],I$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],I$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],I$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],J$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],J$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],J$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],J$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],K$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],K$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],K$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],K$1,FALSE),0)","v":0},{"$f":"IF(Cumul_emp[[#This Row],[Colonne9]]>0,Cumul_emp[[#This Row],[Colonne9]]/Cumul_emp[[#This Row],[Colonne11]],0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],M$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],M$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],M$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],M$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],N$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],N$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],N$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],N$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],O$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],O$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],O$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],O$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],P$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],P$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],P$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],P$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],Q$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],Q$1,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A21,_2[],R$1,FALSE),0)+IFERROR(VLOOKUP($A21,_3[],R$1,FALSE),0)+IFERROR(VLOOKUP($A21,_4[],R$1,FALSE),0)+IFERROR(VLOOKUP($A21,_5[],R$1,FALSE),0)","v":0},""]
["Total",null,{"$f":"SUBTOTAL(109,Cumul_emp[Colonne3])","v":12656.949999999999},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne4])","v":350},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne5])","v":0},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne6])","v":125},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne7])","v":0},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne8])","v":12431.949999999999},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne9])","v":9451.9499999999989},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne10])","v":2980},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne11])","v":352},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne12])","v":151.38016363636365},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne13])","v":15},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne14])","v":67},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne15])","v":90},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne16])","v":123},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne163])","v":27},{"$f":"SUBTOTAL(109,Cumul_emp[Colonne162])","v":30}]

{"sheet":"Modele","index":2,"n_rows":1000,"n_cols":20,"rows_kept":1000,"cut":false,"hidden":false,"merged":[[1,0,1,1],[5,9,6,9],[5,18,6,18],[5,15,6,15],[5,14,6,14],[5,13,6,13],[5,12,6,12],[5,2,6,2],[5,1,6,1],[5,0,6,0],[5,7,6,7],[3,0,3,1],[1,5,1,7],[1,9,1,11],[4,13,4,17],[5,19,6,19],[5,16,6,16],[5,17,6,17],[5,11,6,11],[5,10,6,10]]}
[null,"Modele",{"$f":"Modele!#REF!","v":{"$error":"#REF!"}},{"$f":"Modele!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"Modele!#REF!","v":{"$error":"#REF!"}},{"$f":"Modele!#REF!","v":{"$error":"#REF!"}},{"$f":"Modele!#REF!","v":{"$error":"#REF!"}},{"$f":"Modele!#REF!","v":{"$error":"#REF!"}},{"$f":"Modele!#REF!","v":{"$error":"#REF!"}}]
["Calcul de la période",null,{"$f":"RIGHT(CELL(\"nomfichier\",A1),LEN(CELL(\"nomfichier\",A1))-FIND(\"]\",CELL(\"nomfichier\",A1)))","v":"Modele"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Poste"]
["N° employé","Nom employé","Revenu","Dépense",null,"Facture surplus",null,"Revenu généré","Excédent","Ne pas compter","HRS","taux",null,25,456,785,21,54,"Validation","Classification"]
[null,null,null,"(-)","(+)","(+)","Inclus",null,0]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne163","Colonne162","Colonne17","Colonne18"]
[{"$f":"_xlfn.LET(_xlpm.tbl,_xlfn.VSTACK(Début:Fin!A9:B1000),_xlpm.tblf,_xlfn._xlws.FILTER(_xlpm.tbl,_xlfn.TAKE(_xlpm.tbl,,-1)<>0),_xlpm.tblf2,_xlfn._xlws.FILTER(_xlpm.tblf,_xlfn.TAKE(_xlpm.tblf,,1)<>0),_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlpm.tblf2),1))","v":3},"Employé y",{"$f":"_xlfn.LET(_xlpm.tbl,_xlfn.VSTACK(Début:Fin!A9:C1000),_xlpm.tblf,_xlfn._xlws.FILTER(_xlpm.tbl,_xlfn.CHOOSECOLS(_xlpm.tbl,2)<>0),_xlpm.rech,_xlfn._xlws.FILTER(_xlpm.tblf,_xlfn.TAKE(_xlpm.tblf,,1)<>0),_xlfn.BYROW(A9:A1000,_xlfn.LAMBDA(_xlpm.x,SUMPRODUCT((_xlfn.TAKE(_xlpm.rech,,1)=_xlpm.x)*_xlfn.TAKE(_xlpm.rech,,-1)))))","v":3895.81},null,null,null,null,{"$f":"C9-D9+E9+F9","v":3895.81},{"$f":"IF(T9=\"EX\",0,IF($H9>$I$7,($H9-$I$7),0))","v":3895.81},{"$f":"IF(Modele!$T9=\"EX\",Modele!$H9,SUM(H9-I9))","v":0},null,{"$f":"IF(K9=\"\",\"\",J9/K9)","v":""},null,null,null,null,null,null,{"$f":"IF(T9=\"EX\",\"OK validé\",(IF(A9=\"\",\"\",IF(SUM(M9+N9+O9+P9+Q9+R9)<>J9,\"À vérifier\",\"OK validé\"))))","v":"OK validé"},{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,3))","v":"B"}]
[4,"Employé x",2365,null,null,null,null,2365,2365,{"$f":"IF(Modele!$T10=\"EX\",Modele!$H10,SUM(H10-I10))","v":0},null,{"$f":"IF(K10=\"\",\"\",J10/K10)","v":""},null,null,null,null,null,null,"OK validé","C"]
[5,"Employer z",1000,null,null,null,null,1000,1000,{"$f":"IF(Modele!$T11=\"EX\",Modele!$H11,SUM(H11-I11))","v":0},null,"",null,null,null,null,null,null,"OK validé","TA"]
[6,"Employer A",1826.14,null,null,null,null,1826.14,1826.14,{"$f":"IF(Modele!$T12=\"EX\",Modele!$H12,SUM(H12-I12))","v":0},null,"",null,null,null,null,null,null,"OK validé","TA"]
[7,"Employer B",650,null,null,null,null,650,650,{"$f":"IF(Modele!$T13=\"EX\",Modele!$H13,SUM(H13-I13))","v":0},null,"",null,null,null,null,null,null,"OK validé","B"]
[8,"Employer C",2920,null,null,null,null,{"$f":"C14-D14+E14+F14","v":2920},0,{"$f":"IF(Modele!$T14=\"EX\",Modele!$H14,SUM(H14-I14))","v":2920},null,{"$f":"IF(K14=\"\",\"\",J14/K14)","v":""},null,null,null,null,null,null,"OK validé","EX"]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T15=\"EX\",Modele!$H15,SUM(H15-I15))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T16=\"EX\",Modele!$H16,SUM(H16-I16))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,{"$f":"IF(T17=\"EX\",0,IF($H17>$I$7,($H17-$I$7),0))","v":0},{"$f":"IF(Modele!$T17=\"EX\",Modele!$H17,SUM(H17-I17))","v":0},null,"",null,null,null,null,null,null,{"$f":"IF(T17=\"EX\",\"OK validé\",(IF(A17=\"\",\"\",IF(SUM(M17+N17+O17+P17+Q17+R17)<>J17,\"À vérifier\",\"OK validé\"))))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Nom_employé,3))","v":""}]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T18=\"EX\",Modele!$H18,SUM(H18-I18))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T19=\"EX\",Modele!$H19,SUM(H19-I19))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T20=\"EX\",Modele!$H20,SUM(H20-I20))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T21=\"EX\",Modele!$H21,SUM(H21-I21))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T22=\"EX\",Modele!$H22,SUM(H22-I22))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T23=\"EX\",Modele!$H23,SUM(H23-I23))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T24=\"EX\",Modele!$H24,SUM(H24-I24))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T25=\"EX\",Modele!$H25,SUM(H25-I25))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T26=\"EX\",Modele!$H26,SUM(H26-I26))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T27=\"EX\",Modele!$H27,SUM(H27-I27))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T28=\"EX\",Modele!$H28,SUM(H28-I28))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T29=\"EX\",Modele!$H29,SUM(H29-I29))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T30=\"EX\",Modele!$H30,SUM(H30-I30))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T31=\"EX\",Modele!$H31,SUM(H31-I31))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T32=\"EX\",Modele!$H32,SUM(H32-I32))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T33=\"EX\",Modele!$H33,SUM(H33-I33))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T34=\"EX\",Modele!$H34,SUM(H34-I34))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T35=\"EX\",Modele!$H35,SUM(H35-I35))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T36=\"EX\",Modele!$H36,SUM(H36-I36))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T37=\"EX\",Modele!$H37,SUM(H37-I37))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T38=\"EX\",Modele!$H38,SUM(H38-I38))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T39=\"EX\",Modele!$H39,SUM(H39-I39))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T40=\"EX\",Modele!$H40,SUM(H40-I40))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T41=\"EX\",Modele!$H41,SUM(H41-I41))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T42=\"EX\",Modele!$H42,SUM(H42-I42))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T43=\"EX\",Modele!$H43,SUM(H43-I43))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T44=\"EX\",Modele!$H44,SUM(H44-I44))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T45=\"EX\",Modele!$H45,SUM(H45-I45))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T46=\"EX\",Modele!$H46,SUM(H46-I46))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T47=\"EX\",Modele!$H47,SUM(H47-I47))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T48=\"EX\",Modele!$H48,SUM(H48-I48))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T49=\"EX\",Modele!$H49,SUM(H49-I49))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T50=\"EX\",Modele!$H50,SUM(H50-I50))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T51=\"EX\",Modele!$H51,SUM(H51-I51))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T52=\"EX\",Modele!$H52,SUM(H52-I52))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T53=\"EX\",Modele!$H53,SUM(H53-I53))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T54=\"EX\",Modele!$H54,SUM(H54-I54))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T55=\"EX\",Modele!$H55,SUM(H55-I55))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0,null,null,null,null,0,0,{"$f":"IF(Modele!$T56=\"EX\",Modele!$H56,SUM(H56-I56))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]

{"sheet":"Début","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"P2","index":4,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,1,1],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,7,6,7],[1,5,1,7],[1,9,1,11],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,9,6,9],[5,16,6,16],[5,17,6,17],[5,18,6,18],[5,19,6,19],[3,0,3,1],[5,13,6,13],[5,14,6,14],[5,15,6,15],[4,13,4,17]]}
[]
["Calcul de la période",null,{"$f":"RIGHT(CELL(\"nomfichier\",A1),LEN(CELL(\"nomfichier\",A1))-FIND(\"]\",CELL(\"nomfichier\",A1)))","v":"P2"}]
[]
["TAUX VERSEMENT PERIODIQUE"]
[null,null,null,null,null,"EMPLOYEUR",null,null,null,null,null,null,null,"Poste"]
["N° employé","Nom employé","Salaire brut","SÉC. CCQ","AV. IMPOS.","RVER-REER","TRANSPORT","Salaire","Excédent","Salaire moins excédent","HRS","taux","TRAV. AUX.","*80110","*80130","*80100","*80020","*90010","Validation","Classification"]
[null,null,null,"(-)","(+)","(+)","Inclus",null,0]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne163","Colonne162","Colonne17","Colonne18"]
[3,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,2))","v":"Employé y"},1250,null,null,null,null,{"$f":"C9-D9+E9+F9","v":1250},{"$f":"IF(T9=\"EX\",0,IF($H9>$I$7,($H9-$I$7),0))","v":1250},{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H9-I9))","v":0},20,{"$f":"IF(K9=\"\",\"\",J9/K9)","v":0},null,2,10,8,null,null,{"$f":"IF(T9=\"EX\",\"OK validé\",(IF(A9=\"\",\"\",IF(SUM(M9+N9+O9+P9+Q9+R9)<>J9,\"À vérifier\",\"OK validé\"))))","v":"À vérifier"},{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,3))","v":"B"}]
[4,"Employé x",365,null,null,null,null,365,365,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H10-I10))","v":0},10,{"$f":"IF(K10=\"\",\"\",J10/K10)","v":0},null,null,5,null,5,null,"À vérifier","C"]
[8,"Employer C",600,null,null,null,null,600,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H11-I11))","v":600},30,20,10,15,null,null,null,5,"OK validé","EX"]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H12-I12))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H13-I13))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,{"$f":"C14-D14+E14+F14","v":0},0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H14-I14))","v":0},null,{"$f":"IF(K14=\"\",\"\",J14/K14)","v":""},null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H15-I15))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H16-I16))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Nom_employé,2))","v":""},null,null,null,null,null,0,{"$f":"IF(T17=\"EX\",0,IF($H17>$I$7,($H17-$I$7),0))","v":0},{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H17-I17))","v":0},null,"",null,null,null,null,null,null,{"$f":"IF(T17=\"EX\",\"OK validé\",(IF(A17=\"\",\"\",IF(SUM(M17+N17+O17+P17+Q17+R17)<>J17,\"À vérifier\",\"OK validé\"))))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Nom_employé,3))","v":""}]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H18-I18))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H19-I19))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H20-I20))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H21-I21))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H22-I22))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H23-I23))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H24-I24))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H25-I25))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H26-I26))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H27-I27))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H28-I28))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H29-I29))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H30-I30))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H31-I31))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H32-I32))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H33-I33))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H34-I34))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H35-I35))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H36-I36))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H37-I37))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H38-I38))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H39-I39))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H40-I40))","v":0},null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_2[[#This Row],[Colonne18]]=\"EX\",_2[[#This Row],[Colonne8]],SUM(H41-I41))","v":0},null,"",null,null,null,null,null,null,"",""]
["Total",null,{"$f":"SUBTOTAL(109,_2[Colonne3])","v":2215},{"$f":"SUBTOTAL(109,_2[Colonne4])","v":0},{"$f":"SUBTOTAL(109,_2[Colonne5])","v":0},{"$f":"SUBTOTAL(109,_2[Colonne6])","v":0},{"$f":"SUBTOTAL(109,_2[Colonne7])","v":0},{"$f":"SUBTOTAL(109,_2[Colonne8])","v":2215},{"$f":"SUBTOTAL(109,_2[Colonne9])","v":1615},{"$f":"SUBTOTAL(109,_2[Colonne10])","v":600},null,null,{"$f":"SUBTOTAL(109,_2[Colonne13])","v":10},{"$f":"SUBTOTAL(109,_2[Colonne14])","v":17},{"$f":"SUBTOTAL(109,_2[Colonne15])","v":15},{"$f":"SUBTOTAL(109,_2[Colonne16])","v":8},{"$f":"SUBTOTAL(109,_2[Colonne163])","v":5},{"$f":"SUBTOTAL(109,_2[Colonne162])","v":5}]

{"sheet":"P3","index":5,"n_rows":99,"n_cols":20,"rows_kept":99,"cut":false,"hidden":false,"merged":[[4,13,4,17],[5,17,6,17],[5,18,6,18],[5,19,6,19],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16],[1,0,1,1],[1,5,1,7],[1,9,1,11],[3,0,3,1],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,7,6,7],[5,9,6,9],[5,10,6,10]]}
[null,"P3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_3[[#Totals],[Colonne17]]","v":0}]
["Calcul de la période",null,{"$f":"RIGHT(CELL(\"nomfichier\",A1),LEN(CELL(\"nomfichier\",A1))-FIND(\"]\",CELL(\"nomfichier\",A1)))","v":"P3"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Poste"]
["N° employé","Nom employé","Revenu","Dépense",null,"Facture surplus",null,"Revenu généré","Excédent","Ne pas compter","HRS","taux",null,25,456,785,21,54,"Validation","Classification"]
[null,null,null,"(-)","(+)","(+)","Inclus",null,0]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne163","Colonne162","Colonne17","Colonne18"]
[7,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,2,FALSE))","v":"Employer B"},650,null,null,null,null,{"$f":"C9-D9+E9+F9","v":650},{"$f":"IF(T9=\"EX\",0,IF($H9>$I$7,($H9-$I$7),0))","v":650},{"$f":"IF(_3[[#This Row],[Colonne18]]=\"EX\",_3[[#This Row],[Colonne8]],SUM(H9-I9))","v":0},20,{"$f":"_3[[#This Row],[Colonne10]]/_3[[#This Row],[Colonne11]]","v":0},null,5,null,5,10,null,{"$f":"IF(T9=\"EX\",\"OK validé\",(IF(A9=\"\",\"\",IF(SUM(M9+N9+O9+P9+Q9+R9)<>J9,\"À vérifier\",\"OK validé\"))))","v":"À vérifier"},{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,3))","v":"B"}]
[4,"Employé x",1500,null,null,null,null,1500,1500,{"$f":"IF(_3[[#This Row],[Colonne18]]=\"EX\",_3[[#This Row],[Colonne8]],SUM(H10-I10))","v":0},75,{"$f":"_3[[#This Row],[Colonne10]]/_3[[#This Row],[Colonne11]]","v":0},null,20,20,30,null,5,"À vérifier","C"]
[6,"Employer A",250,null,null,null,null,250,250,{"$f":"IF(_3[[#This Row],[Colonne18]]=\"EX\",_3[[#This Row],[Colonne8]],SUM(H11-I11))","v":0},25,{"$f":"_3[[#This Row],[Colonne10]]/_3[[#This Row],[Colonne11]]","v":0},5,null,10,null,10,null,"À vérifier","TA"]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_3[[#This Row],[Colonne18]]=\"EX\",_3[[#This Row],[Colonne8]],SUM(H12-I12))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_3[[#This Row],[Colonne18]]=\"EX\",_3[[#This Row],[Colonne8]],SUM(H13-I13))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Nom_employé,2,FALSE))","v":""},null,null,null,null,null,{"$f":"C14-D14+E14+F14","v":0},{"$f":"IF(T14=\"EX\",0,IF($H14>$I$7,($H14-$I$7),0))","v":0},{"$f":"IF(_3[[#This Row],[Colonne18]]=\"EX\",_3[[#This Row],[Colonne8]],SUM(H14-I14))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(T14=\"EX\",\"OK validé\",(IF(A14=\"\",\"\",IF(SUM(M14+N14+O14+P14+Q14+R14)<>J14,\"À vérifier\",\"OK validé\"))))","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Nom_employé,3))","v":""}]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_3[[#This Row],[Colonne18]]=\"EX\",_3[[#This Row],[Colonne8]],SUM(H15-I15))","v":0},null,{"$f":"IF(K15=\"\",\"\",J15/K15)","v":""},null,null,null,null,null,null,"",""]
["Total",null,{"$f":"SUBTOTAL(109,_3[Colonne3])","v":2400},{"$f":"SUBTOTAL(109,_3[Colonne4])","v":0},{"$f":"SUBTOTAL(109,_3[Colonne5])","v":0},{"$f":"SUBTOTAL(109,_3[Colonne6])","v":0},{"$f":"SUBTOTAL(109,_3[Colonne7])","v":0},{"$f":"SUBTOTAL(109,_3[Colonne8])","v":2400},{"$f":"SUBTOTAL(109,_3[Colonne9])","v":2400},{"$f":"SUBTOTAL(109,_3[Colonne10])","v":0},null,null,{"$f":"SUBTOTAL(109,_3[Colonne13])","v":5},{"$f":"SUBTOTAL(109,_3[Colonne14])","v":25},{"$f":"SUBTOTAL(109,_3[Colonne15])","v":30},{"$f":"SUBTOTAL(109,_3[Colonne16])","v":35},{"$f":"SUBTOTAL(109,_3[Colonne163])","v":20},{"$f":"SUBTOTAL(109,_3[Colonne162])","v":5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Modele",{"$f":"_3[[#Totals],[Colonne3]]","v":2400},{"$f":"_3[[#Totals],[Colonne4]]","v":0},{"$f":"_3[[#Totals],[Colonne5]]","v":0},{"$f":"_3[[#Totals],[Colonne6]]","v":0},{"$f":"_3[[#Totals],[Colonne7]]","v":0},{"$f":"_3[[#Totals],[Colonne8]]","v":2400},{"$f":"_3[[#Totals],[Colonne9]]","v":2400},{"$f":"_3[[#Totals],[Colonne10]]","v":0},{"$f":"_3[[#Totals],[Colonne11]]","v":0},{"$f":"_3[[#Totals],[Colonne12]]","v":0},{"$f":"_3[[#Totals],[Colonne13]]","v":5},{"$f":"_3[[#Totals],[Colonne14]]","v":25},{"$f":"_3[[#Totals],[Colonne15]]","v":30},{"$f":"_3[[#Totals],[Colonne16]]","v":35},{"$f":"_3[[#Totals],[Colonne163]]","v":20},{"$f":"_3[[#Totals],[Colonne162]]","v":5},{"$f":"_3[[#Totals],[Colonne17]]","v":0}]

{"sheet":"P4","index":6,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,13,4,17],[5,17,6,17],[5,18,6,18],[5,19,6,19],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16],[1,0,1,1],[1,5,1,7],[1,9,1,11],[3,0,3,1],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,7,6,7],[5,9,6,9],[5,10,6,10]]}
[null,"P4"]
["Calcul de la période",null,{"$f":"RIGHT(CELL(\"nomfichier\",A1),LEN(CELL(\"nomfichier\",A1))-FIND(\"]\",CELL(\"nomfichier\",A1)))","v":"P4"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Poste"]
["N° employé","Nom employé","Revenu","Dépense",null,"Facture surplus",null,"Revenu généré","Excédent","Ne pas compter","HRS","taux",null,25,456,785,21,54,"Validation","Classification"]
[null,null,null,"(-)","(+)","(+)","Inclus",null,0]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne163","Colonne162","Colonne17","Colonne18"]
[3,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,2,FALSE))","v":"Employé y"},500,null,null,null,null,{"$f":"C9-D9+E9+F9","v":500},{"$f":"IF(T9=\"EX\",0,IF($H9>$I$7,($H9-$I$7),0))","v":500},{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H9-I9))","v":0},50,{"$f":"_4[[#This Row],[Colonne8]]/_4[[#This Row],[Colonne11]]","v":10},null,null,null,50,null,null,{"$f":"IF(T9=\"EX\",\"OK validé\",(IF(A9=\"\",\"\",IF(SUM(M9+N9+O9+P9+Q9+R9)<>J9,\"À vérifier\",\"OK validé\"))))","v":"À vérifier"},{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,3))","v":"B"}]
[4,"Employé x",500,null,null,null,null,500,500,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H10-I10))","v":0},25,{"$f":"_4[[#This Row],[Colonne8]]/_4[[#This Row],[Colonne11]]","v":20},null,15,10,null,null,null,"À vérifier","C"]
[5,"Employer z",1000,null,null,null,null,1000,1000,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H11-I11))","v":0},32,{"$f":"_4[[#This Row],[Colonne8]]/_4[[#This Row],[Colonne11]]","v":31.25},null,null,30,null,2,null,"À vérifier","TA"]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H12-I12))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Nom_employé,2,FALSE))","v":""},null,null,null,null,null,{"$f":"C13-D13+E13+F13","v":0},{"$f":"IF(T13=\"EX\",0,IF($H13>$I$7,($H13-$I$7),0))","v":0},{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H13-I13))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(T13=\"EX\",\"OK validé\",(IF(A13=\"\",\"\",IF(SUM(M13+N13+O13+P13+Q13+R13)<>J13,\"À vérifier\",\"OK validé\"))))","v":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Nom_employé,3))","v":""}]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H14-I14))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H15-I15))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H16-I16))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H17-I17))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H18-I18))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H19-I19))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H20-I20))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H21-I21))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H22-I22))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H23-I23))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_4[[#This Row],[Colonne18]]=\"EX\",_4[[#This Row],[Colonne8]],SUM(H24-I24))","v":0},null,{"$f":"IF(K24=\"\",\"\",J24/K24)","v":""},null,null,null,null,null,null,"",""]
["Total",null,{"$f":"SUBTOTAL(109,_4[Colonne3])","v":2000},{"$f":"SUBTOTAL(109,_4[Colonne4])","v":0},{"$f":"SUBTOTAL(109,_4[Colonne5])","v":0},{"$f":"SUBTOTAL(109,_4[Colonne6])","v":0},{"$f":"SUBTOTAL(109,_4[Colonne7])","v":0},{"$f":"SUBTOTAL(109,_4[Colonne8])","v":2000},{"$f":"SUBTOTAL(109,_4[Colonne9])","v":2000},{"$f":"SUBTOTAL(109,_4[Colonne10])","v":0},null,null,{"$f":"SUBTOTAL(109,_4[Colonne13])","v":0},{"$f":"SUBTOTAL(109,_4[Colonne14])","v":15},{"$f":"SUBTOTAL(109,_4[Colonne15])","v":40},{"$f":"SUBTOTAL(109,_4[Colonne16])","v":50},{"$f":"SUBTOTAL(109,_4[Colonne163])","v":2},{"$f":"SUBTOTAL(109,_4[Colonne162])","v":0}]

{"sheet":"P5","index":7,"n_rows":107,"n_cols":20,"rows_kept":107,"cut":false,"hidden":false,"merged":[[4,13,4,17],[5,17,6,17],[5,18,6,18],[5,19,6,19],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16],[1,0,1,1],[1,5,1,7],[1,9,1,11],[3,0,3,1],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,7,6,7],[5,9,6,9],[5,10,6,10]]}
[null,"P5"]
["Calcul de la période",null,{"$f":"RIGHT(CELL(\"nomfichier\",A1),LEN(CELL(\"nomfichier\",A1))-FIND(\"]\",CELL(\"nomfichier\",A1)))","v":"P5"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Poste"]
["N° employé","Nom employé","Revenu","Dépense",null,"Facture surplus",null,"Revenu généré","Excédent","Ne pas compter","HRS","taux",null,25,456,785,21,54,"Validation","Classification"]
[null,null,null,"(-)","(+)","(+)","Inclus",null,0]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne163","Colonne162","Colonne17","Colonne18"]
[8,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,2,FALSE))","v":"Employer C"},2320,15,null,75,null,{"$f":"C9-D9+E9+F9","v":2380},{"$f":"IF(T9=\"EX\",0,IF($H9>$I$7,($H9-$I$7),0))","v":0},{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H9-I9))","v":2380},null,null,null,null,null,null,null,null,{"$f":"IF(T9=\"EX\",\"OK validé\",(IF(A9=\"\",\"\",IF(SUM(M9+N9+O9+P9+Q9+R9)<>J9,\"À vérifier\",\"OK validé\"))))","v":"OK validé"},{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Nom_employé,3))","v":"EX"}]
[6,"Employer A",1576.14,325,null,30,null,1281.1400000000001,1281.1400000000001,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H10-I10))","v":0},25,{"$f":"H9/_5[[#This Row],[Colonne11]]","v":95.2},null,null,null,25,null,null,"À vérifier","TA"]
[3,"Employé y",2145.81,10,null,20,null,2155.81,2155.81,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H11-I11))","v":0},40,{"$f":"H10/_5[[#This Row],[Colonne11]]","v":32.028500000000001},null,10,5,5,null,20,"À vérifier","B"]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H12-I12))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H13-I13))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,{"$f":"C14-D14+E14+F14","v":0},0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H14-I14))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H15-I15))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H16-I16))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Nom_employé,2,FALSE))","v":""},null,null,null,null,null,0,{"$f":"IF(T17=\"EX\",0,IF($H17>$I$7,($H17-$I$7),0))","v":0},{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H17-I17))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(T17=\"EX\",\"OK validé\",(IF(A17=\"\",\"\",IF(SUM(M17+N17+O17+P17+Q17+R17)<>J17,\"À vérifier\",\"OK validé\"))))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Nom_employé,3))","v":""}]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H18-I18))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H19-I19))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H20-I20))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H21-I21))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H22-I22))","v":0},null,null,null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,0,0,{"$f":"IF(_5[[#This Row],[Colonne18]]=\"EX\",_5[[#This Row],[Colonne8]],SUM(H23-I23))","v":0},null,null,null,null,null,null,null,null,"",""]
["Total",null,{"$f":"SUBTOTAL(109,_5[Colonne3])","v":6041.9500000000007},{"$f":"SUBTOTAL(109,_5[Colonne4])","v":350},{"$f":"SUBTOTAL(109,_5[Colonne5])","v":0},{"$f":"SUBTOTAL(109,_5[Colonne6])","v":125},{"$f":"SUBTOTAL(109,_5[Colonne7])","v":0},{"$f":"SUBTOTAL(109,_5[Colonne8])","v":5816.9500000000007},{"$f":"SUBTOTAL(109,_5[Colonne9])","v":3436.95},{"$f":"SUBTOTAL(109,_5[Colonne10])","v":2380},null,null,{"$f":"SUBTOTAL(109,_5[Colonne13])","v":0},{"$f":"SUBTOTAL(109,_5[Colonne14])","v":10},{"$f":"SUBTOTAL(109,_5[Colonne15])","v":5},{"$f":"SUBTOTAL(109,_5[Colonne16])","v":30},{"$f":"SUBTOTAL(109,_5[Colonne163])","v":0},{"$f":"SUBTOTAL(109,_5[Colonne162])","v":20}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Modele",{"$f":"_5[[#Totals],[Colonne3]]","v":6041.9500000000007},{"$f":"_5[[#Totals],[Colonne4]]","v":350},{"$f":"_5[[#Totals],[Colonne5]]","v":0},{"$f":"_5[[#Totals],[Colonne6]]","v":125},{"$f":"_5[[#Totals],[Colonne7]]","v":0},{"$f":"_5[[#Totals],[Colonne8]]","v":5816.9500000000007},{"$f":"_5[[#Totals],[Colonne9]]","v":3436.95},{"$f":"_5[[#Totals],[Colonne10]]","v":2380},{"$f":"_5[[#Totals],[Colonne11]]","v":0},{"$f":"_5[[#Totals],[Colonne12]]","v":0},{"$f":"_5[[#Totals],[Colonne13]]","v":0},{"$f":"_5[[#Totals],[Colonne14]]","v":10},{"$f":"_5[[#Totals],[Colonne15]]","v":5},{"$f":"_5[[#Totals],[Colonne16]]","v":30},{"$f":"_5[[#Totals],[Colonne163]]","v":0},{"$f":"_5[[#Totals],[Colonne162]]","v":20},{"$f":"_5[[#Totals],[Colonne17]]","v":0}]

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