{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Feuil3","index":0,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,8,16,10],[16,11,16,12]]}
["Année","Date jr férié","Nom","N° Pers1","Nom","N° Pers2","Nom",null,"N°","Travailleur","Nb jrs fériés trav","Dern année trav férié","Dern jr férié trav"]
[2015,"2015-12-25","Jour férié 2",1,{"$f":"IF(D2=\"\",\"\",VLOOKUP(D2,I:J,2,FALSE))","v":"Christian"},6,{"$f":"IF(F2=\"\",\"\",VLOOKUP(F2,I:J,2,FALSE))","v":"Vincent"},null,1,"Christian",{"$f":"COUNTIF(D:D,I2)+COUNTIF(F:F,I2)","v":2},{"$f":"IF(MAX(IFERROR(MATCH(I2,F:F,0),0),IFERROR(MATCH(I2,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I2,F:F,0),0),IFERROR(MATCH(I2,D:D,0),0))))","v":2015},{"$f":"IF(MAX(IFERROR(MATCH(I2,F:F,0),0),IFERROR(MATCH(I2,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I2,F:F,0),0),IFERROR(MATCH(I2,D:D,0),0))),\"jj/mm/aaaa\"))","v":"25/12/2015"}]
[2015,"2015-01-01","Jour férié 1",1,{"$f":"IF(D3=\"\",\"\",VLOOKUP(D3,I:J,2,FALSE))","v":"Christian"},2,{"$f":"IF(F3=\"\",\"\",VLOOKUP(F3,I:J,2,FALSE))","v":"Sylviane"},null,2,"Sylviane",{"$f":"COUNTIF(D:D,I3)+COUNTIF(F:F,I3)","v":1},{"$f":"IF(MAX(IFERROR(MATCH(I3,F:F,0),0),IFERROR(MATCH(I3,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I3,F:F,0),0),IFERROR(MATCH(I3,D:D,0),0))))","v":2015},{"$f":"IF(MAX(IFERROR(MATCH(I3,F:F,0),0),IFERROR(MATCH(I3,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I3,F:F,0),0),IFERROR(MATCH(I3,D:D,0),0))),\"jj/mm/aaaa\"))","v":"01/01/2015"}]
[2014,"2014-01-01","Jour férié 1",3,{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,I:J,2,FALSE))","v":"José"},4,{"$f":"IF(F4=\"\",\"\",VLOOKUP(F4,I:J,2,FALSE))","v":"Henry"},null,3,"José",{"$f":"COUNTIF(D:D,I4)+COUNTIF(F:F,I4)","v":1},{"$f":"IF(MAX(IFERROR(MATCH(I4,F:F,0),0),IFERROR(MATCH(I4,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I4,F:F,0),0),IFERROR(MATCH(I4,D:D,0),0))))","v":2014},{"$f":"IF(MAX(IFERROR(MATCH(I4,F:F,0),0),IFERROR(MATCH(I4,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I4,F:F,0),0),IFERROR(MATCH(I4,D:D,0),0))),\"jj/mm/aaaa\"))","v":"01/01/2014"}]
[null,null,null,null,null,null,null,null,4,"Henry",{"$f":"COUNTIF(D:D,I5)+COUNTIF(F:F,I5)","v":1},{"$f":"IF(MAX(IFERROR(MATCH(I5,F:F,0),0),IFERROR(MATCH(I5,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I5,F:F,0),0),IFERROR(MATCH(I5,D:D,0),0))))","v":2014},{"$f":"IF(MAX(IFERROR(MATCH(I5,F:F,0),0),IFERROR(MATCH(I5,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I5,F:F,0),0),IFERROR(MATCH(I5,D:D,0),0))),\"jj/mm/aaaa\"))","v":"01/01/2014"}]
[null,null,null,null,null,null,null,null,5,"Jonathan",{"$f":"COUNTIF(D:D,I6)+COUNTIF(F:F,I6)","v":0},{"$f":"IF(MAX(IFERROR(MATCH(I6,F:F,0),0),IFERROR(MATCH(I6,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I6,F:F,0),0),IFERROR(MATCH(I6,D:D,0),0))))","v":""},{"$f":"IF(MAX(IFERROR(MATCH(I6,F:F,0),0),IFERROR(MATCH(I6,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I6,F:F,0),0),IFERROR(MATCH(I6,D:D,0),0))),\"jj/mm/aaaa\"))","v":""}]
[null,null,null,null,null,null,null,null,6,"Vincent",{"$f":"COUNTIF(D:D,I7)+COUNTIF(F:F,I7)","v":1},{"$f":"IF(MAX(IFERROR(MATCH(I7,F:F,0),0),IFERROR(MATCH(I7,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I7,F:F,0),0),IFERROR(MATCH(I7,D:D,0),0))))","v":2015},{"$f":"IF(MAX(IFERROR(MATCH(I7,F:F,0),0),IFERROR(MATCH(I7,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I7,F:F,0),0),IFERROR(MATCH(I7,D:D,0),0))),\"jj/mm/aaaa\"))","v":"25/12/2015"}]
[null,null,null,null,null,null,null,null,7,"Kevin",{"$f":"COUNTIF(D:D,I8)+COUNTIF(F:F,I8)","v":0},{"$f":"IF(MAX(IFERROR(MATCH(I8,F:F,0),0),IFERROR(MATCH(I8,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I8,F:F,0),0),IFERROR(MATCH(I8,D:D,0),0))))","v":""},{"$f":"IF(MAX(IFERROR(MATCH(I8,F:F,0),0),IFERROR(MATCH(I8,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I8,F:F,0),0),IFERROR(MATCH(I8,D:D,0),0))),\"jj/mm/aaaa\"))","v":""}]
[null,null,null,null,null,null,null,null,8,"Nadine",{"$f":"COUNTIF(D:D,I9)+COUNTIF(F:F,I9)","v":0},{"$f":"IF(MAX(IFERROR(MATCH(I9,F:F,0),0),IFERROR(MATCH(I9,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I9,F:F,0),0),IFERROR(MATCH(I9,D:D,0),0))))","v":""},{"$f":"IF(MAX(IFERROR(MATCH(I9,F:F,0),0),IFERROR(MATCH(I9,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I9,F:F,0),0),IFERROR(MATCH(I9,D:D,0),0))),\"jj/mm/aaaa\"))","v":""}]
[null,null,null,null,null,null,null,null,9,"Lila",{"$f":"COUNTIF(D:D,I10)+COUNTIF(F:F,I10)","v":0},{"$f":"IF(MAX(IFERROR(MATCH(I10,F:F,0),0),IFERROR(MATCH(I10,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I10,F:F,0),0),IFERROR(MATCH(I10,D:D,0),0))))","v":""},{"$f":"IF(MAX(IFERROR(MATCH(I10,F:F,0),0),IFERROR(MATCH(I10,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I10,F:F,0),0),IFERROR(MATCH(I10,D:D,0),0))),\"jj/mm/aaaa\"))","v":""}]
[null,null,null,null,null,null,null,null,10,"Marie",{"$f":"COUNTIF(D:D,I11)+COUNTIF(F:F,I11)","v":0},{"$f":"IF(MAX(IFERROR(MATCH(I11,F:F,0),0),IFERROR(MATCH(I11,D:D,0),0))=0,\"\",INDEX(A:A,MAX(IFERROR(MATCH(I11,F:F,0),0),IFERROR(MATCH(I11,D:D,0),0))))","v":""},{"$f":"IF(MAX(IFERROR(MATCH(I11,F:F,0),0),IFERROR(MATCH(I11,D:D,0),0))=0,\"\",TEXT(INDEX(B:B,MAX(IFERROR(MATCH(I11,F:F,0),0),IFERROR(MATCH(I11,D:D,0),0))),\"jj/mm/aaaa\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,"Saisir un nouveau jour férié"]
[null,null,null,null,null,null,null,null,"Année","Date jr férié","Nom","N° Pers1","Nom","N° Pers2","Nom"]
[null,null,null,null,null,null,null,null,2016,"2016-01-01","Jour férié 1",2,{"$f":"IF(L15=\"\",\"\",VLOOKUP(L15,I:J,2,FALSE))","v":"Sylviane"},3,{"$f":"IF(N15=\"\",\"\",VLOOKUP(N15,I:J,2,FALSE))","v":"José"}]
[]
[null,null,null,null,null,null,null,null,"Pers ayant déjà travaillé sur ce jour férié",null,null,"Pers ayant déjà travaillé au jour férié précédent :"]
[null,null,null,null,null,null,null,null,"N-1",{"$f":"IF(MAX(IF((A:A=I15-1)*(C:C=K15),ROW(E:E),0))=0,\"\",INDEX(E:E,MAX(IF((A:A=I15-1)*(C:C=K15),ROW(E:E),0))))","v":"Christian"},{"$f":"IF(MAX(IF((A:A=I15-1)*(C:C=K15),ROW(G:G),0))=0,\"\",INDEX(G:G,MAX(IF((A:A=I15-1)*(C:C=K15),ROW(G:G),0))))","v":"Sylviane"},{"$f":"E2","v":"Christian"},{"$f":"G2","v":"Vincent"}]
[null,null,null,null,null,null,null,null,"N-2",{"$f":"IF(MAX(IF((A:A=I15-2)*(C:C=K15),ROW(E:E),0))=0,\"\",INDEX(E:E,MAX(IF((A:A=I15-2)*(C:C=K15),ROW(E:E),0))))","v":"José"},{"$f":"IF(MAX(IF((A:A=I15-2)*(C:C=K15),ROW(G:G),0))=0,\"\",INDEX(G:G,MAX(IF((A:A=I15-2)*(C:C=K15),ROW(G:G),0))))","v":"Henry"}]