{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["HOWTO","Timesheet","MyTime","Projets","WEEK","VBA","Absence","Log","Abs"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":17,"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":"HOWTO","index":0,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Utilisation Générale"]
[]
[1,"Le Template est préparé chaque année par le CFO"]
[]
[2,"Renommer le fichier en faisant bien attention à respecter le coding pour le nom de fichier"]
[null,"(Note: Les matricules sont dispo dans Horoquartz)"]
[]
[]
[]
[]
[]
[]
[3,"Donner au CFO l'emplacement sur le réseau où est conservée la Timesheet"]
[]
[4,"Dans l'onglet Timesheet, cliquer sur le bouton \"Mettre à jour mes absences\""]
[]
[]
[5,"Remplir les commentaires et les temps par projets pour chaque journée en respectant la consigne:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Annexe 1","Ajouter un projet existant"]
[null,1,"Aller sur l'onglet Timesheet"]
[null,2,"Cliquer sur le bouton \"Ajouter une colonne projet\""]
[null,3,"Aller dans l'onglet Projets & cliquer sur \"Mettre à jour la liste des projets\""]
[null,4,"Identifier le code projet du projet à ajouter (s'il n'apparait pas, voir Annexe 3)"]
[null,5,{"$f":"\"En ligne \"&ROW(Timesheet!I9)&\" de la colonne nouvellement insérée, saisir le code du projet\"","v":"En ligne 9 de la colonne nouvellement insérée, saisir le code du projet"}]
[]
[]
["Annexe 2","Avoir plusieurs lignes pour une meme journée"]
[null,1,"Copier la ligne de la journée à dupliquer"]
[null,2,"Selectionner la ligne copiée / Insérer ligne copiée"]
[]
[]
[]
["Annexe 3","Ajouter un nouveau projet"]
[null,1,"Aller dans l'onglet Projets"]
[null,2,"Cliquer sur le bouton \"Ajouter un nouveau projet\""]
[null,3,"Vérifier dans la liste des projets si le projet existe déjà ou non. S'il existe, voir Annexe 1"]
[null,4,"Si le projet n'existe pas, le rajouter en bas de liste"]
[null,null,"Des commentaires sont rajoutés dans les titres des colonnes pour aider au remplissage"]
[null,null,"Pour la partie CIR:"]
[null,null,null,"Se référer à l'onglet CIR pour déterminer s'il ya une démarche expérimentale, des incertitudes/verrous ou une nouveauté"]
[null,null,null,"Valider avec Jayce MELONI (à défaut Christophe SIMEON) les trois critères"]
[null,5,"Communiquer aux personnes travaillant sur le projet le code du projet"]

{"sheet":"Timesheet","index":1,"n_rows":263,"n_cols":23,"rows_kept":263,"cut":false,"hidden":false,"merged":[]}
[null,null,"Nb jours > 8h",{"$f":"VBA!C9","v":0}]
[null,null,"Nb jours non alloué",{"$f":"VBA!C10","v":1}]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(F9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":0},{"$f":"IF(ISNA(VLOOKUP(G9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":0},{"$f":"IF(ISNA(VLOOKUP(H9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":0},{"$f":"IF(ISNA(VLOOKUP(I9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":0},{"$f":"IF(ISNA(VLOOKUP(J9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":0},{"$f":"IF(ISNA(VLOOKUP(K9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(M9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":1},{"$f":"IF(ISNA(VLOOKUP(N9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(W9,Projets!$B:$B,1,FALSE))=TRUE,1,0)","v":1}]
[null,null,null,{"$f":"VBA!C5","v":"MAT"},null,{"$f":"ROW(F9)+1","v":10},{"$f":"ROW(G9)+1","v":10},10,10,10,{"$f":"ROW(K9)+1","v":10},null,{"$f":"ROW(M9)+1","v":10},10,null,null,null,null,null,null,null,null,{"$f":"ROW(W9)+1","v":10}]
[null,null,null,null,null,{"$f":"ROW(F9)+F6","v":9},{"$f":"ROW(G9)+G6","v":9},9,9,9,{"$f":"ROW(K9)+K6","v":9},null,{"$f":"ROW(M9)+M6","v":9},10,null,null,null,null,null,null,null,null,{"$f":"ROW(W9)+W6","v":9}]
[null,null,null,null,null,{"$f":"COUNTIF(F$9:F$10154,\">0\")","v":0},0,0,0,0,0,null,{"$f":"COUNTIF(M$9:M$10154,\">0\")","v":0},{"$f":"COUNTIF(N$9:N$10154,\">0\")+COUNTIF(N$9:N$10154,\"<0\")","v":1},{"$f":"COUNTIF(O$9:O$10154,\">8\")","v":0},null,null,null,null,null,null,null,{"$f":"COUNTIF(W$9:W$10154,\">0\")","v":0}]
[null,null,null,null,null,"Heures projet",null,null,null,null,null,null,"Heures totales"]
[null,null,null,"Projet",null,{"$f":"IFERROR(VLOOKUP(F9,Projets!$B:$E,2,FALSE),\"\")","v":"MONTANA"},{"$f":"IFERROR(VLOOKUP(G9,Projets!$B:$E,2,FALSE),\"Saisir code projet ci-dessous\")","v":"VEGA"},{"$f":"IFERROR(VLOOKUP(H9,Projets!$B:$E,2,FALSE),\"Saisir code projet ci-dessous\")","v":"GTT"},{"$f":"IFERROR(VLOOKUP(I9,Projets!$B:$E,2,FALSE),\"\")","v":"Autres projets / Vie Série"},{"$f":"IFERROR(VLOOKUP(J9,Projets!$B:$E,2,FALSE),\"\")","v":"Non projet"},{"$f":"IFERROR(VLOOKUP(K9,Projets!$B:$E,2,FALSE),\"\")","v":"Absence"},null,"Alloué",{"$f":"IFERROR(VLOOKUP(N9,Projets!$B:$E,2,FALSE),\"\")","v":"Non Alloué"},"TOTAL",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(W9,Projets!$B:$E,2,FALSE),\"Saisir code projet ci-dessous\")","v":"Saisir code projet ci-dessous"}]
["Semaine","Type jour","Jour","Commentaires","Empty","2020_MONTANA","2020_ALAT_VEGA","2020_GTT_LH1488001","2020_VIESERIE","NOP","ABS","Empty","ALLOC","NOA","TOTAL",null,null,null,null,null,null,null,"NEW"]
[{"$f":"VLOOKUP(C10,WEEK!B:E,2,FALSE)","v":1},{"$f":"VLOOKUP(C10,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C10,Absence!D:D)/COUNTIF(C:C,C10)*8/7","v":0},null,{"$f":"SUM(E10:L10)","v":0},{"$f":"IF(C10>VBA!$C$19,0,(8-SUMIF($C:$C,C10,M:M))/COUNTIF(C:C,C10))","v":8},{"$f":"SUM(M10:N10)","v":8}]
[{"$f":"VLOOKUP(C11,WEEK!B:E,2,FALSE)","v":1},{"$f":"VLOOKUP(C11,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C11,Absence!D:D)/COUNTIF(C:C,C11)*8/7","v":0},null,0,{"$f":"IF(C11>VBA!$C$19,0,(8-SUMIF($C:$C,C11,M:M))/COUNTIF(C:C,C11))","v":0},0]
[{"$f":"VLOOKUP(C12,WEEK!B:E,2,FALSE)","v":1},{"$f":"VLOOKUP(C12,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C12,Absence!D:D)/COUNTIF(C:C,C12)*8/7","v":0},null,0,{"$f":"IF(C12>VBA!$C$19,0,(8-SUMIF($C:$C,C12,M:M))/COUNTIF(C:C,C12))","v":0},0]
[{"$f":"VLOOKUP(C13,WEEK!B:E,2,FALSE)","v":1},{"$f":"VLOOKUP(C13,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C13,Absence!D:D)/COUNTIF(C:C,C13)*8/7","v":0},null,0,{"$f":"IF(C13>VBA!$C$19,0,(8-SUMIF($C:$C,C13,M:M))/COUNTIF(C:C,C13))","v":0},0]
[{"$f":"VLOOKUP(C14,WEEK!B:E,2,FALSE)","v":1},{"$f":"VLOOKUP(C14,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C14,Absence!D:D)/COUNTIF(C:C,C14)*8/7","v":0},null,0,{"$f":"IF(C14>VBA!$C$19,0,(8-SUMIF($C:$C,C14,M:M))/COUNTIF(C:C,C14))","v":0},{"$f":"SUM(M14:N14)","v":0}]
[{"$f":"VLOOKUP(C15,WEEK!B:E,2,FALSE)","v":2},{"$f":"VLOOKUP(C15,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-11",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C15,Absence!D:D)/COUNTIF(C:C,C15)*8/7","v":0},null,0,{"$f":"IF(C15>VBA!$C$19,0,(8-SUMIF($C:$C,C15,M:M))/COUNTIF(C:C,C15))","v":0},0]
[{"$f":"VLOOKUP(C16,WEEK!B:E,2,FALSE)","v":2},{"$f":"VLOOKUP(C16,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C16,Absence!D:D)/COUNTIF(C:C,C16)*8/7","v":0},null,0,{"$f":"IF(C16>VBA!$C$19,0,(8-SUMIF($C:$C,C16,M:M))/COUNTIF(C:C,C16))","v":0},0]
[{"$f":"VLOOKUP(C17,WEEK!B:E,2,FALSE)","v":2},{"$f":"VLOOKUP(C17,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-13",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C17,Absence!D:D)/COUNTIF(C:C,C17)*8/7","v":0},null,0,{"$f":"IF(C17>VBA!$C$19,0,(8-SUMIF($C:$C,C17,M:M))/COUNTIF(C:C,C17))","v":0},{"$f":"SUM(M17:N17)","v":0}]
[{"$f":"VLOOKUP(C18,WEEK!B:E,2,FALSE)","v":2},{"$f":"VLOOKUP(C18,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-14",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C18,Absence!D:D)/COUNTIF(C:C,C18)*8/7","v":0},null,0,{"$f":"IF(C18>VBA!$C$19,0,(8-SUMIF($C:$C,C18,M:M))/COUNTIF(C:C,C18))","v":0},0]
[{"$f":"VLOOKUP(C19,WEEK!B:E,2,FALSE)","v":2},{"$f":"VLOOKUP(C19,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C19,Absence!D:D)/COUNTIF(C:C,C19)*8/7","v":0},null,0,{"$f":"IF(C19>VBA!$C$19,0,(8-SUMIF($C:$C,C19,M:M))/COUNTIF(C:C,C19))","v":0},0]
[{"$f":"VLOOKUP(C20,WEEK!B:E,2,FALSE)","v":3},{"$f":"VLOOKUP(C20,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C20,Absence!D:D)/COUNTIF(C:C,C20)*8/7","v":0},null,0,{"$f":"IF(C20>VBA!$C$19,0,(8-SUMIF($C:$C,C20,M:M))/COUNTIF(C:C,C20))","v":0},{"$f":"SUM(M20:N20)","v":0}]
[{"$f":"VLOOKUP(C21,WEEK!B:E,2,FALSE)","v":3},{"$f":"VLOOKUP(C21,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C21,Absence!D:D)/COUNTIF(C:C,C21)*8/7","v":0},null,0,{"$f":"IF(C21>VBA!$C$19,0,(8-SUMIF($C:$C,C21,M:M))/COUNTIF(C:C,C21))","v":0},0]
[{"$f":"VLOOKUP(C22,WEEK!B:E,2,FALSE)","v":3},{"$f":"VLOOKUP(C22,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C22,Absence!D:D)/COUNTIF(C:C,C22)*8/7","v":0},null,0,{"$f":"IF(C22>VBA!$C$19,0,(8-SUMIF($C:$C,C22,M:M))/COUNTIF(C:C,C22))","v":0},0]
[{"$f":"VLOOKUP(C23,WEEK!B:E,2,FALSE)","v":3},{"$f":"VLOOKUP(C23,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C23,Absence!D:D)/COUNTIF(C:C,C23)*8/7","v":0},null,0,{"$f":"IF(C23>VBA!$C$19,0,(8-SUMIF($C:$C,C23,M:M))/COUNTIF(C:C,C23))","v":0},{"$f":"SUM(M23:N23)","v":0}]
[{"$f":"VLOOKUP(C24,WEEK!B:E,2,FALSE)","v":3},{"$f":"VLOOKUP(C24,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C24,Absence!D:D)/COUNTIF(C:C,C24)*8/7","v":0},null,0,{"$f":"IF(C24>VBA!$C$19,0,(8-SUMIF($C:$C,C24,M:M))/COUNTIF(C:C,C24))","v":0},{"$f":"SUM(M24:N24)","v":0}]
[{"$f":"VLOOKUP(C25,WEEK!B:E,2,FALSE)","v":4},{"$f":"VLOOKUP(C25,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C25,Absence!D:D)/COUNTIF(C:C,C25)*8/7","v":0},null,0,{"$f":"IF(C25>VBA!$C$19,0,(8-SUMIF($C:$C,C25,M:M))/COUNTIF(C:C,C25))","v":0},0]
[{"$f":"VLOOKUP(C26,WEEK!B:E,2,FALSE)","v":4},{"$f":"VLOOKUP(C26,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C26,Absence!D:D)/COUNTIF(C:C,C26)*8/7","v":0},null,0,{"$f":"IF(C26>VBA!$C$19,0,(8-SUMIF($C:$C,C26,M:M))/COUNTIF(C:C,C26))","v":0},{"$f":"SUM(M26:N26)","v":0}]
[{"$f":"VLOOKUP(C27,WEEK!B:E,2,FALSE)","v":4},{"$f":"VLOOKUP(C27,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C27,Absence!D:D)/COUNTIF(C:C,C27)*8/7","v":0},null,0,{"$f":"IF(C27>VBA!$C$19,0,(8-SUMIF($C:$C,C27,M:M))/COUNTIF(C:C,C27))","v":0},0]
[{"$f":"VLOOKUP(C28,WEEK!B:E,2,FALSE)","v":4},{"$f":"VLOOKUP(C28,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C28,Absence!D:D)/COUNTIF(C:C,C28)*8/7","v":0},null,0,{"$f":"IF(C28>VBA!$C$19,0,(8-SUMIF($C:$C,C28,M:M))/COUNTIF(C:C,C28))","v":0},{"$f":"SUM(M28:N28)","v":0}]
[{"$f":"VLOOKUP(C29,WEEK!B:E,2,FALSE)","v":4},{"$f":"VLOOKUP(C29,WEEK!B:E,4,FALSE)","v":"ON"},"2021-01-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C29,Absence!D:D)/COUNTIF(C:C,C29)*8/7","v":0},null,0,{"$f":"IF(C29>VBA!$C$19,0,(8-SUMIF($C:$C,C29,M:M))/COUNTIF(C:C,C29))","v":0},0]
[{"$f":"VLOOKUP(C30,WEEK!B:E,2,FALSE)","v":5},{"$f":"VLOOKUP(C30,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C30,Absence!D:D)/COUNTIF(C:C,C30)*8/7","v":0},null,0,{"$f":"IF(C30>VBA!$C$19,0,(8-SUMIF($C:$C,C30,M:M))/COUNTIF(C:C,C30))","v":0},{"$f":"SUM(M30:N30)","v":0}]
[{"$f":"VLOOKUP(C31,WEEK!B:E,2,FALSE)","v":5},{"$f":"VLOOKUP(C31,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C31,Absence!D:D)/COUNTIF(C:C,C31)*8/7","v":0},null,0,{"$f":"IF(C31>VBA!$C$19,0,(8-SUMIF($C:$C,C31,M:M))/COUNTIF(C:C,C31))","v":0},0]
[{"$f":"VLOOKUP(C32,WEEK!B:E,2,FALSE)","v":5},{"$f":"VLOOKUP(C32,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C32,Absence!D:D)/COUNTIF(C:C,C32)*8/7","v":0},null,0,{"$f":"IF(C32>VBA!$C$19,0,(8-SUMIF($C:$C,C32,M:M))/COUNTIF(C:C,C32))","v":0},{"$f":"SUM(M32:N32)","v":0}]
[{"$f":"VLOOKUP(C33,WEEK!B:E,2,FALSE)","v":5},{"$f":"VLOOKUP(C33,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C33,Absence!D:D)/COUNTIF(C:C,C33)*8/7","v":0},null,0,{"$f":"IF(C33>VBA!$C$19,0,(8-SUMIF($C:$C,C33,M:M))/COUNTIF(C:C,C33))","v":0},0]
[{"$f":"VLOOKUP(C34,WEEK!B:E,2,FALSE)","v":5},{"$f":"VLOOKUP(C34,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C34,Absence!D:D)/COUNTIF(C:C,C34)*8/7","v":0},null,0,{"$f":"IF(C34>VBA!$C$19,0,(8-SUMIF($C:$C,C34,M:M))/COUNTIF(C:C,C34))","v":0},0]
[{"$f":"VLOOKUP(C35,WEEK!B:E,2,FALSE)","v":6},{"$f":"VLOOKUP(C35,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C35,Absence!D:D)/COUNTIF(C:C,C35)*8/7","v":0},null,0,{"$f":"IF(C35>VBA!$C$19,0,(8-SUMIF($C:$C,C35,M:M))/COUNTIF(C:C,C35))","v":0},0]
[{"$f":"VLOOKUP(C36,WEEK!B:E,2,FALSE)","v":6},{"$f":"VLOOKUP(C36,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C36,Absence!D:D)/COUNTIF(C:C,C36)*8/7","v":0},null,0,{"$f":"IF(C36>VBA!$C$19,0,(8-SUMIF($C:$C,C36,M:M))/COUNTIF(C:C,C36))","v":0},{"$f":"SUM(M36:N36)","v":0}]
[{"$f":"VLOOKUP(C37,WEEK!B:E,2,FALSE)","v":6},{"$f":"VLOOKUP(C37,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C37,Absence!D:D)/COUNTIF(C:C,C37)*8/7","v":0},null,0,{"$f":"IF(C37>VBA!$C$19,0,(8-SUMIF($C:$C,C37,M:M))/COUNTIF(C:C,C37))","v":0},0]
[{"$f":"VLOOKUP(C38,WEEK!B:E,2,FALSE)","v":6},{"$f":"VLOOKUP(C38,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-11",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C38,Absence!D:D)/COUNTIF(C:C,C38)*8/7","v":0},null,0,{"$f":"IF(C38>VBA!$C$19,0,(8-SUMIF($C:$C,C38,M:M))/COUNTIF(C:C,C38))","v":0},0]
[{"$f":"VLOOKUP(C39,WEEK!B:E,2,FALSE)","v":6},{"$f":"VLOOKUP(C39,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C39,Absence!D:D)/COUNTIF(C:C,C39)*8/7","v":0},null,0,{"$f":"IF(C39>VBA!$C$19,0,(8-SUMIF($C:$C,C39,M:M))/COUNTIF(C:C,C39))","v":0},0]
[{"$f":"VLOOKUP(C40,WEEK!B:E,2,FALSE)","v":7},{"$f":"VLOOKUP(C40,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C40,Absence!D:D)/COUNTIF(C:C,C40)*8/7","v":0},null,0,{"$f":"IF(C40>VBA!$C$19,0,(8-SUMIF($C:$C,C40,M:M))/COUNTIF(C:C,C40))","v":0},{"$f":"SUM(M40:N40)","v":0}]
[{"$f":"VLOOKUP(C41,WEEK!B:E,2,FALSE)","v":7},{"$f":"VLOOKUP(C41,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C41,Absence!D:D)/COUNTIF(C:C,C41)*8/7","v":0},null,0,{"$f":"IF(C41>VBA!$C$19,0,(8-SUMIF($C:$C,C41,M:M))/COUNTIF(C:C,C41))","v":0},0]
[{"$f":"VLOOKUP(C42,WEEK!B:E,2,FALSE)","v":7},{"$f":"VLOOKUP(C42,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C42,Absence!D:D)/COUNTIF(C:C,C42)*8/7","v":0},null,0,{"$f":"IF(C42>VBA!$C$19,0,(8-SUMIF($C:$C,C42,M:M))/COUNTIF(C:C,C42))","v":0},0]
[{"$f":"VLOOKUP(C43,WEEK!B:E,2,FALSE)","v":7},{"$f":"VLOOKUP(C43,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C43,Absence!D:D)/COUNTIF(C:C,C43)*8/7","v":0},null,0,{"$f":"IF(C43>VBA!$C$19,0,(8-SUMIF($C:$C,C43,M:M))/COUNTIF(C:C,C43))","v":0},0]
[{"$f":"VLOOKUP(C44,WEEK!B:E,2,FALSE)","v":7},{"$f":"VLOOKUP(C44,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C44,Absence!D:D)/COUNTIF(C:C,C44)*8/7","v":0},null,0,{"$f":"IF(C44>VBA!$C$19,0,(8-SUMIF($C:$C,C44,M:M))/COUNTIF(C:C,C44))","v":0},0]
[{"$f":"VLOOKUP(C45,WEEK!B:E,2,FALSE)","v":8},{"$f":"VLOOKUP(C45,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C45,Absence!D:D)/COUNTIF(C:C,C45)*8/7","v":0},null,0,{"$f":"IF(C45>VBA!$C$19,0,(8-SUMIF($C:$C,C45,M:M))/COUNTIF(C:C,C45))","v":0},0]
[{"$f":"VLOOKUP(C46,WEEK!B:E,2,FALSE)","v":8},{"$f":"VLOOKUP(C46,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C46,Absence!D:D)/COUNTIF(C:C,C46)*8/7","v":0},null,0,{"$f":"IF(C46>VBA!$C$19,0,(8-SUMIF($C:$C,C46,M:M))/COUNTIF(C:C,C46))","v":0},{"$f":"SUM(M46:N46)","v":0}]
[{"$f":"VLOOKUP(C47,WEEK!B:E,2,FALSE)","v":8},{"$f":"VLOOKUP(C47,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-24",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C47,Absence!D:D)/COUNTIF(C:C,C47)*8/7","v":0},null,0,{"$f":"IF(C47>VBA!$C$19,0,(8-SUMIF($C:$C,C47,M:M))/COUNTIF(C:C,C47))","v":0},0]
[{"$f":"VLOOKUP(C48,WEEK!B:E,2,FALSE)","v":8},{"$f":"VLOOKUP(C48,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C48,Absence!D:D)/COUNTIF(C:C,C48)*8/7","v":0},null,0,{"$f":"IF(C48>VBA!$C$19,0,(8-SUMIF($C:$C,C48,M:M))/COUNTIF(C:C,C48))","v":0},{"$f":"SUM(M48:N48)","v":0}]
[{"$f":"VLOOKUP(C49,WEEK!B:E,2,FALSE)","v":8},{"$f":"VLOOKUP(C49,WEEK!B:E,4,FALSE)","v":"ON"},"2021-02-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C49,Absence!D:D)/COUNTIF(C:C,C49)*8/7","v":0},null,0,{"$f":"IF(C49>VBA!$C$19,0,(8-SUMIF($C:$C,C49,M:M))/COUNTIF(C:C,C49))","v":0},{"$f":"SUM(M49:N49)","v":0}]
[{"$f":"VLOOKUP(C50,WEEK!B:E,2,FALSE)","v":9},{"$f":"VLOOKUP(C50,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C50,Absence!D:D)/COUNTIF(C:C,C50)*8/7","v":0},null,0,{"$f":"IF(C50>VBA!$C$19,0,(8-SUMIF($C:$C,C50,M:M))/COUNTIF(C:C,C50))","v":0},0]
[{"$f":"VLOOKUP(C51,WEEK!B:E,2,FALSE)","v":9},{"$f":"VLOOKUP(C51,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C51,Absence!D:D)/COUNTIF(C:C,C51)*8/7","v":0},null,0,{"$f":"IF(C51>VBA!$C$19,0,(8-SUMIF($C:$C,C51,M:M))/COUNTIF(C:C,C51))","v":0},0]
[{"$f":"VLOOKUP(C52,WEEK!B:E,2,FALSE)","v":9},{"$f":"VLOOKUP(C52,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C52,Absence!D:D)/COUNTIF(C:C,C52)*8/7","v":0},null,0,{"$f":"IF(C52>VBA!$C$19,0,(8-SUMIF($C:$C,C52,M:M))/COUNTIF(C:C,C52))","v":0},0]
[{"$f":"VLOOKUP(C53,WEEK!B:E,2,FALSE)","v":9},{"$f":"VLOOKUP(C53,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C53,Absence!D:D)/COUNTIF(C:C,C53)*8/7","v":0},null,0,{"$f":"IF(C53>VBA!$C$19,0,(8-SUMIF($C:$C,C53,M:M))/COUNTIF(C:C,C53))","v":0},0]
[{"$f":"VLOOKUP(C54,WEEK!B:E,2,FALSE)","v":9},{"$f":"VLOOKUP(C54,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C54,Absence!D:D)/COUNTIF(C:C,C54)*8/7","v":0},null,0,{"$f":"IF(C54>VBA!$C$19,0,(8-SUMIF($C:$C,C54,M:M))/COUNTIF(C:C,C54))","v":0},{"$f":"SUM(M54:N54)","v":0}]
[{"$f":"VLOOKUP(C55,WEEK!B:E,2,FALSE)","v":10},{"$f":"VLOOKUP(C55,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C55,Absence!D:D)/COUNTIF(C:C,C55)*8/7","v":0},null,0,{"$f":"IF(C55>VBA!$C$19,0,(8-SUMIF($C:$C,C55,M:M))/COUNTIF(C:C,C55))","v":0},0]
[{"$f":"VLOOKUP(C56,WEEK!B:E,2,FALSE)","v":10},{"$f":"VLOOKUP(C56,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C56,Absence!D:D)/COUNTIF(C:C,C56)*8/7","v":0},null,0,{"$f":"IF(C56>VBA!$C$19,0,(8-SUMIF($C:$C,C56,M:M))/COUNTIF(C:C,C56))","v":0},{"$f":"SUM(M56:N56)","v":0}]
[{"$f":"VLOOKUP(C57,WEEK!B:E,2,FALSE)","v":10},{"$f":"VLOOKUP(C57,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C57,Absence!D:D)/COUNTIF(C:C,C57)*8/7","v":0},null,0,{"$f":"IF(C57>VBA!$C$19,0,(8-SUMIF($C:$C,C57,M:M))/COUNTIF(C:C,C57))","v":0},0]
[{"$f":"VLOOKUP(C58,WEEK!B:E,2,FALSE)","v":10},{"$f":"VLOOKUP(C58,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-11",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C58,Absence!D:D)/COUNTIF(C:C,C58)*8/7","v":0},null,0,{"$f":"IF(C58>VBA!$C$19,0,(8-SUMIF($C:$C,C58,M:M))/COUNTIF(C:C,C58))","v":0},0]
[{"$f":"VLOOKUP(C59,WEEK!B:E,2,FALSE)","v":10},{"$f":"VLOOKUP(C59,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C59,Absence!D:D)/COUNTIF(C:C,C59)*8/7","v":0},null,0,{"$f":"IF(C59>VBA!$C$19,0,(8-SUMIF($C:$C,C59,M:M))/COUNTIF(C:C,C59))","v":0},0]
[{"$f":"VLOOKUP(C60,WEEK!B:E,2,FALSE)","v":11},{"$f":"VLOOKUP(C60,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C60,Absence!D:D)/COUNTIF(C:C,C60)*8/7","v":0},null,0,{"$f":"IF(C60>VBA!$C$19,0,(8-SUMIF($C:$C,C60,M:M))/COUNTIF(C:C,C60))","v":0},0]
[{"$f":"VLOOKUP(C61,WEEK!B:E,2,FALSE)","v":11},{"$f":"VLOOKUP(C61,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C61,Absence!D:D)/COUNTIF(C:C,C61)*8/7","v":0},null,0,{"$f":"IF(C61>VBA!$C$19,0,(8-SUMIF($C:$C,C61,M:M))/COUNTIF(C:C,C61))","v":0},0]
[{"$f":"VLOOKUP(C62,WEEK!B:E,2,FALSE)","v":11},{"$f":"VLOOKUP(C62,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C62,Absence!D:D)/COUNTIF(C:C,C62)*8/7","v":0},null,0,{"$f":"IF(C62>VBA!$C$19,0,(8-SUMIF($C:$C,C62,M:M))/COUNTIF(C:C,C62))","v":0},0]
[{"$f":"VLOOKUP(C63,WEEK!B:E,2,FALSE)","v":11},{"$f":"VLOOKUP(C63,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C63,Absence!D:D)/COUNTIF(C:C,C63)*8/7","v":0},null,0,{"$f":"IF(C63>VBA!$C$19,0,(8-SUMIF($C:$C,C63,M:M))/COUNTIF(C:C,C63))","v":0},0]
[{"$f":"VLOOKUP(C64,WEEK!B:E,2,FALSE)","v":11},{"$f":"VLOOKUP(C64,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C64,Absence!D:D)/COUNTIF(C:C,C64)*8/7","v":0},null,0,{"$f":"IF(C64>VBA!$C$19,0,(8-SUMIF($C:$C,C64,M:M))/COUNTIF(C:C,C64))","v":0},{"$f":"SUM(M64:N64)","v":0}]
[{"$f":"VLOOKUP(C65,WEEK!B:E,2,FALSE)","v":12},{"$f":"VLOOKUP(C65,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C65,Absence!D:D)/COUNTIF(C:C,C65)*8/7","v":0},null,0,{"$f":"IF(C65>VBA!$C$19,0,(8-SUMIF($C:$C,C65,M:M))/COUNTIF(C:C,C65))","v":0},0]
[{"$f":"VLOOKUP(C66,WEEK!B:E,2,FALSE)","v":12},{"$f":"VLOOKUP(C66,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C66,Absence!D:D)/COUNTIF(C:C,C66)*8/7","v":0},null,0,{"$f":"IF(C66>VBA!$C$19,0,(8-SUMIF($C:$C,C66,M:M))/COUNTIF(C:C,C66))","v":0},0]
[{"$f":"VLOOKUP(C67,WEEK!B:E,2,FALSE)","v":12},{"$f":"VLOOKUP(C67,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-24",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C67,Absence!D:D)/COUNTIF(C:C,C67)*8/7","v":0},null,0,{"$f":"IF(C67>VBA!$C$19,0,(8-SUMIF($C:$C,C67,M:M))/COUNTIF(C:C,C67))","v":0},0]
[{"$f":"VLOOKUP(C68,WEEK!B:E,2,FALSE)","v":12},{"$f":"VLOOKUP(C68,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C68,Absence!D:D)/COUNTIF(C:C,C68)*8/7","v":0},null,0,{"$f":"IF(C68>VBA!$C$19,0,(8-SUMIF($C:$C,C68,M:M))/COUNTIF(C:C,C68))","v":0},0]
[{"$f":"VLOOKUP(C69,WEEK!B:E,2,FALSE)","v":12},{"$f":"VLOOKUP(C69,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C69,Absence!D:D)/COUNTIF(C:C,C69)*8/7","v":0},null,0,{"$f":"IF(C69>VBA!$C$19,0,(8-SUMIF($C:$C,C69,M:M))/COUNTIF(C:C,C69))","v":0},0]
[{"$f":"VLOOKUP(C70,WEEK!B:E,2,FALSE)","v":13},{"$f":"VLOOKUP(C70,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C70,Absence!D:D)/COUNTIF(C:C,C70)*8/7","v":0},null,0,{"$f":"IF(C70>VBA!$C$19,0,(8-SUMIF($C:$C,C70,M:M))/COUNTIF(C:C,C70))","v":0},0]
[{"$f":"VLOOKUP(C71,WEEK!B:E,2,FALSE)","v":13},{"$f":"VLOOKUP(C71,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C71,Absence!D:D)/COUNTIF(C:C,C71)*8/7","v":0},null,0,{"$f":"IF(C71>VBA!$C$19,0,(8-SUMIF($C:$C,C71,M:M))/COUNTIF(C:C,C71))","v":0},{"$f":"SUM(M71:N71)","v":0}]
[{"$f":"VLOOKUP(C72,WEEK!B:E,2,FALSE)","v":13},{"$f":"VLOOKUP(C72,WEEK!B:E,4,FALSE)","v":"ON"},"2021-03-31",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C72,Absence!D:D)/COUNTIF(C:C,C72)*8/7","v":0},null,0,{"$f":"IF(C72>VBA!$C$19,0,(8-SUMIF($C:$C,C72,M:M))/COUNTIF(C:C,C72))","v":0},{"$f":"SUM(M72:N72)","v":0}]
[{"$f":"VLOOKUP(C73,WEEK!B:E,2,FALSE)","v":13},{"$f":"VLOOKUP(C73,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C73,Absence!D:D)/COUNTIF(C:C,C73)*8/7","v":0},null,0,{"$f":"IF(C73>VBA!$C$19,0,(8-SUMIF($C:$C,C73,M:M))/COUNTIF(C:C,C73))","v":0},0]
[{"$f":"VLOOKUP(C74,WEEK!B:E,2,FALSE)","v":13},{"$f":"VLOOKUP(C74,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C74,Absence!D:D)/COUNTIF(C:C,C74)*8/7","v":0},null,{"$f":"SUM(E74:L74)","v":0},{"$f":"IF(C74>VBA!$C$19,0,(8-SUMIF($C:$C,C74,M:M))/COUNTIF(C:C,C74))","v":0},0]
[{"$f":"VLOOKUP(C75,WEEK!B:E,2,FALSE)","v":14},{"$f":"VLOOKUP(C75,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C75,Absence!D:D)/COUNTIF(C:C,C75)*8/7","v":0},null,0,{"$f":"IF(C75>VBA!$C$19,0,(8-SUMIF($C:$C,C75,M:M))/COUNTIF(C:C,C75))","v":0},{"$f":"SUM(M75:N75)","v":0}]
[{"$f":"VLOOKUP(C76,WEEK!B:E,2,FALSE)","v":14},{"$f":"VLOOKUP(C76,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C76,Absence!D:D)/COUNTIF(C:C,C76)*8/7","v":0},null,0,{"$f":"IF(C76>VBA!$C$19,0,(8-SUMIF($C:$C,C76,M:M))/COUNTIF(C:C,C76))","v":0},0]
[{"$f":"VLOOKUP(C77,WEEK!B:E,2,FALSE)","v":14},{"$f":"VLOOKUP(C77,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C77,Absence!D:D)/COUNTIF(C:C,C77)*8/7","v":0},null,0,{"$f":"IF(C77>VBA!$C$19,0,(8-SUMIF($C:$C,C77,M:M))/COUNTIF(C:C,C77))","v":0},0]
[{"$f":"VLOOKUP(C78,WEEK!B:E,2,FALSE)","v":14},{"$f":"VLOOKUP(C78,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C78,Absence!D:D)/COUNTIF(C:C,C78)*8/7","v":0},null,0,{"$f":"IF(C78>VBA!$C$19,0,(8-SUMIF($C:$C,C78,M:M))/COUNTIF(C:C,C78))","v":0},0]
[{"$f":"VLOOKUP(C79,WEEK!B:E,2,FALSE)","v":15},{"$f":"VLOOKUP(C79,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C79,Absence!D:D)/COUNTIF(C:C,C79)*8/7","v":0},null,0,{"$f":"IF(C79>VBA!$C$19,0,(8-SUMIF($C:$C,C79,M:M))/COUNTIF(C:C,C79))","v":0},0]
[{"$f":"VLOOKUP(C80,WEEK!B:E,2,FALSE)","v":15},{"$f":"VLOOKUP(C80,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-13",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C80,Absence!D:D)/COUNTIF(C:C,C80)*8/7","v":0},null,0,{"$f":"IF(C80>VBA!$C$19,0,(8-SUMIF($C:$C,C80,M:M))/COUNTIF(C:C,C80))","v":0},{"$f":"SUM(M80:N80)","v":0}]
[{"$f":"VLOOKUP(C81,WEEK!B:E,2,FALSE)","v":15},{"$f":"VLOOKUP(C81,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-14",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C81,Absence!D:D)/COUNTIF(C:C,C81)*8/7","v":0},null,0,{"$f":"IF(C81>VBA!$C$19,0,(8-SUMIF($C:$C,C81,M:M))/COUNTIF(C:C,C81))","v":0},0]
[{"$f":"VLOOKUP(C82,WEEK!B:E,2,FALSE)","v":15},{"$f":"VLOOKUP(C82,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C82,Absence!D:D)/COUNTIF(C:C,C82)*8/7","v":0},null,0,{"$f":"IF(C82>VBA!$C$19,0,(8-SUMIF($C:$C,C82,M:M))/COUNTIF(C:C,C82))","v":0},0]
[{"$f":"VLOOKUP(C83,WEEK!B:E,2,FALSE)","v":15},{"$f":"VLOOKUP(C83,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C83,Absence!D:D)/COUNTIF(C:C,C83)*8/7","v":0},null,0,{"$f":"IF(C83>VBA!$C$19,0,(8-SUMIF($C:$C,C83,M:M))/COUNTIF(C:C,C83))","v":0},0]
[{"$f":"VLOOKUP(C84,WEEK!B:E,2,FALSE)","v":16},{"$f":"VLOOKUP(C84,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C84,Absence!D:D)/COUNTIF(C:C,C84)*8/7","v":0},null,0,{"$f":"IF(C84>VBA!$C$19,0,(8-SUMIF($C:$C,C84,M:M))/COUNTIF(C:C,C84))","v":0},{"$f":"SUM(M84:N84)","v":0}]
[{"$f":"VLOOKUP(C85,WEEK!B:E,2,FALSE)","v":16},{"$f":"VLOOKUP(C85,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C85,Absence!D:D)/COUNTIF(C:C,C85)*8/7","v":0},null,0,{"$f":"IF(C85>VBA!$C$19,0,(8-SUMIF($C:$C,C85,M:M))/COUNTIF(C:C,C85))","v":0},0]
[{"$f":"VLOOKUP(C86,WEEK!B:E,2,FALSE)","v":16},{"$f":"VLOOKUP(C86,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C86,Absence!D:D)/COUNTIF(C:C,C86)*8/7","v":0},null,0,{"$f":"IF(C86>VBA!$C$19,0,(8-SUMIF($C:$C,C86,M:M))/COUNTIF(C:C,C86))","v":0},{"$f":"SUM(M86:N86)","v":0}]
[{"$f":"VLOOKUP(C87,WEEK!B:E,2,FALSE)","v":16},{"$f":"VLOOKUP(C87,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C87,Absence!D:D)/COUNTIF(C:C,C87)*8/7","v":0},null,0,{"$f":"IF(C87>VBA!$C$19,0,(8-SUMIF($C:$C,C87,M:M))/COUNTIF(C:C,C87))","v":0},0]
[{"$f":"VLOOKUP(C88,WEEK!B:E,2,FALSE)","v":16},{"$f":"VLOOKUP(C88,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C88,Absence!D:D)/COUNTIF(C:C,C88)*8/7","v":0},null,0,{"$f":"IF(C88>VBA!$C$19,0,(8-SUMIF($C:$C,C88,M:M))/COUNTIF(C:C,C88))","v":0},{"$f":"SUM(M88:N88)","v":0}]
[{"$f":"VLOOKUP(C89,WEEK!B:E,2,FALSE)","v":17},{"$f":"VLOOKUP(C89,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C89,Absence!D:D)/COUNTIF(C:C,C89)*8/7","v":0},null,0,{"$f":"IF(C89>VBA!$C$19,0,(8-SUMIF($C:$C,C89,M:M))/COUNTIF(C:C,C89))","v":0},0]
[{"$f":"VLOOKUP(C90,WEEK!B:E,2,FALSE)","v":17},{"$f":"VLOOKUP(C90,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C90,Absence!D:D)/COUNTIF(C:C,C90)*8/7","v":0},null,0,{"$f":"IF(C90>VBA!$C$19,0,(8-SUMIF($C:$C,C90,M:M))/COUNTIF(C:C,C90))","v":0},0]
[{"$f":"VLOOKUP(C91,WEEK!B:E,2,FALSE)","v":17},{"$f":"VLOOKUP(C91,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C91,Absence!D:D)/COUNTIF(C:C,C91)*8/7","v":0},null,0,{"$f":"IF(C91>VBA!$C$19,0,(8-SUMIF($C:$C,C91,M:M))/COUNTIF(C:C,C91))","v":0},0]
[{"$f":"VLOOKUP(C92,WEEK!B:E,2,FALSE)","v":17},{"$f":"VLOOKUP(C92,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C92,Absence!D:D)/COUNTIF(C:C,C92)*8/7","v":0},null,0,{"$f":"IF(C92>VBA!$C$19,0,(8-SUMIF($C:$C,C92,M:M))/COUNTIF(C:C,C92))","v":0},0]
[{"$f":"VLOOKUP(C93,WEEK!B:E,2,FALSE)","v":17},{"$f":"VLOOKUP(C93,WEEK!B:E,4,FALSE)","v":"ON"},"2021-04-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C93,Absence!D:D)/COUNTIF(C:C,C93)*8/7","v":0},null,0,{"$f":"IF(C93>VBA!$C$19,0,(8-SUMIF($C:$C,C93,M:M))/COUNTIF(C:C,C93))","v":0},{"$f":"SUM(M93:N93)","v":0}]
[{"$f":"VLOOKUP(C94,WEEK!B:E,2,FALSE)","v":18},{"$f":"VLOOKUP(C94,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C94,Absence!D:D)/COUNTIF(C:C,C94)*8/7","v":0},null,0,{"$f":"IF(C94>VBA!$C$19,0,(8-SUMIF($C:$C,C94,M:M))/COUNTIF(C:C,C94))","v":0},0]
[{"$f":"VLOOKUP(C95,WEEK!B:E,2,FALSE)","v":18},{"$f":"VLOOKUP(C95,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C95,Absence!D:D)/COUNTIF(C:C,C95)*8/7","v":0},null,0,{"$f":"IF(C95>VBA!$C$19,0,(8-SUMIF($C:$C,C95,M:M))/COUNTIF(C:C,C95))","v":0},0]
[{"$f":"VLOOKUP(C96,WEEK!B:E,2,FALSE)","v":18},{"$f":"VLOOKUP(C96,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C96,Absence!D:D)/COUNTIF(C:C,C96)*8/7","v":0},null,0,{"$f":"IF(C96>VBA!$C$19,0,(8-SUMIF($C:$C,C96,M:M))/COUNTIF(C:C,C96))","v":0},0]
[{"$f":"VLOOKUP(C97,WEEK!B:E,2,FALSE)","v":18},{"$f":"VLOOKUP(C97,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C97,Absence!D:D)/COUNTIF(C:C,C97)*8/7","v":0},null,0,{"$f":"IF(C97>VBA!$C$19,0,(8-SUMIF($C:$C,C97,M:M))/COUNTIF(C:C,C97))","v":0},{"$f":"SUM(M97:N97)","v":0}]
[{"$f":"VLOOKUP(C98,WEEK!B:E,2,FALSE)","v":18},{"$f":"VLOOKUP(C98,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C98,Absence!D:D)/COUNTIF(C:C,C98)*8/7","v":0},null,0,{"$f":"IF(C98>VBA!$C$19,0,(8-SUMIF($C:$C,C98,M:M))/COUNTIF(C:C,C98))","v":0},0]
[{"$f":"VLOOKUP(C99,WEEK!B:E,2,FALSE)","v":19},{"$f":"VLOOKUP(C99,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C99,Absence!D:D)/COUNTIF(C:C,C99)*8/7","v":0},null,0,{"$f":"IF(C99>VBA!$C$19,0,(8-SUMIF($C:$C,C99,M:M))/COUNTIF(C:C,C99))","v":0},0]
[{"$f":"VLOOKUP(C100,WEEK!B:E,2,FALSE)","v":19},{"$f":"VLOOKUP(C100,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-11",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C100,Absence!D:D)/COUNTIF(C:C,C100)*8/7","v":0},null,0,{"$f":"IF(C100>VBA!$C$19,0,(8-SUMIF($C:$C,C100,M:M))/COUNTIF(C:C,C100))","v":0},0]
[{"$f":"VLOOKUP(C101,WEEK!B:E,2,FALSE)","v":19},{"$f":"VLOOKUP(C101,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C101,Absence!D:D)/COUNTIF(C:C,C101)*8/7","v":0},null,0,{"$f":"IF(C101>VBA!$C$19,0,(8-SUMIF($C:$C,C101,M:M))/COUNTIF(C:C,C101))","v":0},0]
[{"$f":"VLOOKUP(C102,WEEK!B:E,2,FALSE)","v":19},{"$f":"VLOOKUP(C102,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-14",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C102,Absence!D:D)/COUNTIF(C:C,C102)*8/7","v":0},null,0,{"$f":"IF(C102>VBA!$C$19,0,(8-SUMIF($C:$C,C102,M:M))/COUNTIF(C:C,C102))","v":0},{"$f":"SUM(M102:N102)","v":0}]
[{"$f":"VLOOKUP(C103,WEEK!B:E,2,FALSE)","v":20},{"$f":"VLOOKUP(C103,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C103,Absence!D:D)/COUNTIF(C:C,C103)*8/7","v":0},null,0,{"$f":"IF(C103>VBA!$C$19,0,(8-SUMIF($C:$C,C103,M:M))/COUNTIF(C:C,C103))","v":0},0]
[{"$f":"VLOOKUP(C104,WEEK!B:E,2,FALSE)","v":20},{"$f":"VLOOKUP(C104,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C104,Absence!D:D)/COUNTIF(C:C,C104)*8/7","v":0},null,0,{"$f":"IF(C104>VBA!$C$19,0,(8-SUMIF($C:$C,C104,M:M))/COUNTIF(C:C,C104))","v":0},0]
[{"$f":"VLOOKUP(C105,WEEK!B:E,2,FALSE)","v":20},{"$f":"VLOOKUP(C105,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C105,Absence!D:D)/COUNTIF(C:C,C105)*8/7","v":0},null,0,{"$f":"IF(C105>VBA!$C$19,0,(8-SUMIF($C:$C,C105,M:M))/COUNTIF(C:C,C105))","v":0},0]
[{"$f":"VLOOKUP(C106,WEEK!B:E,2,FALSE)","v":20},{"$f":"VLOOKUP(C106,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C106,Absence!D:D)/COUNTIF(C:C,C106)*8/7","v":0},null,0,{"$f":"IF(C106>VBA!$C$19,0,(8-SUMIF($C:$C,C106,M:M))/COUNTIF(C:C,C106))","v":0},{"$f":"SUM(M106:N106)","v":0}]
[{"$f":"VLOOKUP(C107,WEEK!B:E,2,FALSE)","v":20},{"$f":"VLOOKUP(C107,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C107,Absence!D:D)/COUNTIF(C:C,C107)*8/7","v":0},null,0,{"$f":"IF(C107>VBA!$C$19,0,(8-SUMIF($C:$C,C107,M:M))/COUNTIF(C:C,C107))","v":0},0]
[{"$f":"VLOOKUP(C108,WEEK!B:E,2,FALSE)","v":21},{"$f":"VLOOKUP(C108,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C108,Absence!D:D)/COUNTIF(C:C,C108)*8/7","v":0},null,0,{"$f":"IF(C108>VBA!$C$19,0,(8-SUMIF($C:$C,C108,M:M))/COUNTIF(C:C,C108))","v":0},0]
[{"$f":"VLOOKUP(C109,WEEK!B:E,2,FALSE)","v":21},{"$f":"VLOOKUP(C109,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C109,Absence!D:D)/COUNTIF(C:C,C109)*8/7","v":0},null,0,{"$f":"IF(C109>VBA!$C$19,0,(8-SUMIF($C:$C,C109,M:M))/COUNTIF(C:C,C109))","v":0},{"$f":"SUM(M109:N109)","v":0}]
[{"$f":"VLOOKUP(C110,WEEK!B:E,2,FALSE)","v":21},{"$f":"VLOOKUP(C110,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C110,Absence!D:D)/COUNTIF(C:C,C110)*8/7","v":0},null,0,{"$f":"IF(C110>VBA!$C$19,0,(8-SUMIF($C:$C,C110,M:M))/COUNTIF(C:C,C110))","v":0},0]
[{"$f":"VLOOKUP(C111,WEEK!B:E,2,FALSE)","v":21},{"$f":"VLOOKUP(C111,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C111,Absence!D:D)/COUNTIF(C:C,C111)*8/7","v":0},null,0,{"$f":"IF(C111>VBA!$C$19,0,(8-SUMIF($C:$C,C111,M:M))/COUNTIF(C:C,C111))","v":0},0]
[{"$f":"VLOOKUP(C112,WEEK!B:E,2,FALSE)","v":22},{"$f":"VLOOKUP(C112,WEEK!B:E,4,FALSE)","v":"ON"},"2021-05-31",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C112,Absence!D:D)/COUNTIF(C:C,C112)*8/7","v":0},null,0,{"$f":"IF(C112>VBA!$C$19,0,(8-SUMIF($C:$C,C112,M:M))/COUNTIF(C:C,C112))","v":0},0]
[{"$f":"VLOOKUP(C113,WEEK!B:E,2,FALSE)","v":22},{"$f":"VLOOKUP(C113,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C113,Absence!D:D)/COUNTIF(C:C,C113)*8/7","v":0},null,0,{"$f":"IF(C113>VBA!$C$19,0,(8-SUMIF($C:$C,C113,M:M))/COUNTIF(C:C,C113))","v":0},0]
[{"$f":"VLOOKUP(C114,WEEK!B:E,2,FALSE)","v":22},{"$f":"VLOOKUP(C114,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C114,Absence!D:D)/COUNTIF(C:C,C114)*8/7","v":0},null,0,{"$f":"IF(C114>VBA!$C$19,0,(8-SUMIF($C:$C,C114,M:M))/COUNTIF(C:C,C114))","v":0},{"$f":"SUM(M114:N114)","v":0}]
[{"$f":"VLOOKUP(C115,WEEK!B:E,2,FALSE)","v":22},{"$f":"VLOOKUP(C115,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C115,Absence!D:D)/COUNTIF(C:C,C115)*8/7","v":0},null,0,{"$f":"IF(C115>VBA!$C$19,0,(8-SUMIF($C:$C,C115,M:M))/COUNTIF(C:C,C115))","v":0},0]
[{"$f":"VLOOKUP(C116,WEEK!B:E,2,FALSE)","v":22},{"$f":"VLOOKUP(C116,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C116,Absence!D:D)/COUNTIF(C:C,C116)*8/7","v":0},null,0,{"$f":"IF(C116>VBA!$C$19,0,(8-SUMIF($C:$C,C116,M:M))/COUNTIF(C:C,C116))","v":0},0]
[{"$f":"VLOOKUP(C117,WEEK!B:E,2,FALSE)","v":23},{"$f":"VLOOKUP(C117,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C117,Absence!D:D)/COUNTIF(C:C,C117)*8/7","v":0},null,0,{"$f":"IF(C117>VBA!$C$19,0,(8-SUMIF($C:$C,C117,M:M))/COUNTIF(C:C,C117))","v":0},{"$f":"SUM(M117:N117)","v":0}]
[{"$f":"VLOOKUP(C118,WEEK!B:E,2,FALSE)","v":23},{"$f":"VLOOKUP(C118,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C118,Absence!D:D)/COUNTIF(C:C,C118)*8/7","v":0},null,0,{"$f":"IF(C118>VBA!$C$19,0,(8-SUMIF($C:$C,C118,M:M))/COUNTIF(C:C,C118))","v":0},0]
[{"$f":"VLOOKUP(C119,WEEK!B:E,2,FALSE)","v":23},{"$f":"VLOOKUP(C119,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C119,Absence!D:D)/COUNTIF(C:C,C119)*8/7","v":0},null,0,{"$f":"IF(C119>VBA!$C$19,0,(8-SUMIF($C:$C,C119,M:M))/COUNTIF(C:C,C119))","v":0},{"$f":"SUM(M119:N119)","v":0}]
[{"$f":"VLOOKUP(C120,WEEK!B:E,2,FALSE)","v":23},{"$f":"VLOOKUP(C120,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C120,Absence!D:D)/COUNTIF(C:C,C120)*8/7","v":0},null,0,{"$f":"IF(C120>VBA!$C$19,0,(8-SUMIF($C:$C,C120,M:M))/COUNTIF(C:C,C120))","v":0},{"$f":"SUM(M120:N120)","v":0}]
[{"$f":"VLOOKUP(C121,WEEK!B:E,2,FALSE)","v":23},{"$f":"VLOOKUP(C121,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-11",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C121,Absence!D:D)/COUNTIF(C:C,C121)*8/7","v":0},null,0,{"$f":"IF(C121>VBA!$C$19,0,(8-SUMIF($C:$C,C121,M:M))/COUNTIF(C:C,C121))","v":0},0]
[{"$f":"VLOOKUP(C122,WEEK!B:E,2,FALSE)","v":24},{"$f":"VLOOKUP(C122,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-14",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C122,Absence!D:D)/COUNTIF(C:C,C122)*8/7","v":0},null,0,{"$f":"IF(C122>VBA!$C$19,0,(8-SUMIF($C:$C,C122,M:M))/COUNTIF(C:C,C122))","v":0},{"$f":"SUM(M122:N122)","v":0}]
[{"$f":"VLOOKUP(C123,WEEK!B:E,2,FALSE)","v":24},{"$f":"VLOOKUP(C123,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C123,Absence!D:D)/COUNTIF(C:C,C123)*8/7","v":0},null,0,{"$f":"IF(C123>VBA!$C$19,0,(8-SUMIF($C:$C,C123,M:M))/COUNTIF(C:C,C123))","v":0},0]
[{"$f":"VLOOKUP(C124,WEEK!B:E,2,FALSE)","v":24},{"$f":"VLOOKUP(C124,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C124,Absence!D:D)/COUNTIF(C:C,C124)*8/7","v":0},null,0,{"$f":"IF(C124>VBA!$C$19,0,(8-SUMIF($C:$C,C124,M:M))/COUNTIF(C:C,C124))","v":0},0]
[{"$f":"VLOOKUP(C125,WEEK!B:E,2,FALSE)","v":24},{"$f":"VLOOKUP(C125,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C125,Absence!D:D)/COUNTIF(C:C,C125)*8/7","v":0},null,0,{"$f":"IF(C125>VBA!$C$19,0,(8-SUMIF($C:$C,C125,M:M))/COUNTIF(C:C,C125))","v":0},{"$f":"SUM(M125:N125)","v":0}]
[{"$f":"VLOOKUP(C126,WEEK!B:E,2,FALSE)","v":24},{"$f":"VLOOKUP(C126,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C126,Absence!D:D)/COUNTIF(C:C,C126)*8/7","v":0},null,0,{"$f":"IF(C126>VBA!$C$19,0,(8-SUMIF($C:$C,C126,M:M))/COUNTIF(C:C,C126))","v":0},0]
[{"$f":"VLOOKUP(C127,WEEK!B:E,2,FALSE)","v":25},{"$f":"VLOOKUP(C127,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C127,Absence!D:D)/COUNTIF(C:C,C127)*8/7","v":0},null,0,{"$f":"IF(C127>VBA!$C$19,0,(8-SUMIF($C:$C,C127,M:M))/COUNTIF(C:C,C127))","v":0},0]
[{"$f":"VLOOKUP(C128,WEEK!B:E,2,FALSE)","v":25},{"$f":"VLOOKUP(C128,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C128,Absence!D:D)/COUNTIF(C:C,C128)*8/7","v":0},null,0,{"$f":"IF(C128>VBA!$C$19,0,(8-SUMIF($C:$C,C128,M:M))/COUNTIF(C:C,C128))","v":0},{"$f":"SUM(M128:N128)","v":0}]
[{"$f":"VLOOKUP(C129,WEEK!B:E,2,FALSE)","v":25},{"$f":"VLOOKUP(C129,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C129,Absence!D:D)/COUNTIF(C:C,C129)*8/7","v":0},null,0,{"$f":"IF(C129>VBA!$C$19,0,(8-SUMIF($C:$C,C129,M:M))/COUNTIF(C:C,C129))","v":0},0]
[{"$f":"VLOOKUP(C130,WEEK!B:E,2,FALSE)","v":25},{"$f":"VLOOKUP(C130,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-24",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C130,Absence!D:D)/COUNTIF(C:C,C130)*8/7","v":0},null,0,{"$f":"IF(C130>VBA!$C$19,0,(8-SUMIF($C:$C,C130,M:M))/COUNTIF(C:C,C130))","v":0},0]
[{"$f":"VLOOKUP(C131,WEEK!B:E,2,FALSE)","v":25},{"$f":"VLOOKUP(C131,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C131,Absence!D:D)/COUNTIF(C:C,C131)*8/7","v":0},null,0,{"$f":"IF(C131>VBA!$C$19,0,(8-SUMIF($C:$C,C131,M:M))/COUNTIF(C:C,C131))","v":0},0]
[{"$f":"VLOOKUP(C132,WEEK!B:E,2,FALSE)","v":26},{"$f":"VLOOKUP(C132,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C132,Absence!D:D)/COUNTIF(C:C,C132)*8/7","v":0},null,0,{"$f":"IF(C132>VBA!$C$19,0,(8-SUMIF($C:$C,C132,M:M))/COUNTIF(C:C,C132))","v":0},0]
[{"$f":"VLOOKUP(C133,WEEK!B:E,2,FALSE)","v":26},{"$f":"VLOOKUP(C133,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C133,Absence!D:D)/COUNTIF(C:C,C133)*8/7","v":0},null,0,{"$f":"IF(C133>VBA!$C$19,0,(8-SUMIF($C:$C,C133,M:M))/COUNTIF(C:C,C133))","v":0},{"$f":"SUM(M133:N133)","v":0}]
[{"$f":"VLOOKUP(C134,WEEK!B:E,2,FALSE)","v":26},{"$f":"VLOOKUP(C134,WEEK!B:E,4,FALSE)","v":"ON"},"2021-06-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C134,Absence!D:D)/COUNTIF(C:C,C134)*8/7","v":0},null,0,{"$f":"IF(C134>VBA!$C$19,0,(8-SUMIF($C:$C,C134,M:M))/COUNTIF(C:C,C134))","v":0},0]
[{"$f":"VLOOKUP(C135,WEEK!B:E,2,FALSE)","v":26},{"$f":"VLOOKUP(C135,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C135,Absence!D:D)/COUNTIF(C:C,C135)*8/7","v":0},null,0,{"$f":"IF(C135>VBA!$C$19,0,(8-SUMIF($C:$C,C135,M:M))/COUNTIF(C:C,C135))","v":0},0]
[{"$f":"VLOOKUP(C136,WEEK!B:E,2,FALSE)","v":26},{"$f":"VLOOKUP(C136,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C136,Absence!D:D)/COUNTIF(C:C,C136)*8/7","v":0},null,0,{"$f":"IF(C136>VBA!$C$19,0,(8-SUMIF($C:$C,C136,M:M))/COUNTIF(C:C,C136))","v":0},{"$f":"SUM(M136:N136)","v":0}]
[{"$f":"VLOOKUP(C137,WEEK!B:E,2,FALSE)","v":27},{"$f":"VLOOKUP(C137,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C137,Absence!D:D)/COUNTIF(C:C,C137)*8/7","v":0},null,0,{"$f":"IF(C137>VBA!$C$19,0,(8-SUMIF($C:$C,C137,M:M))/COUNTIF(C:C,C137))","v":0},0]
[{"$f":"VLOOKUP(C138,WEEK!B:E,2,FALSE)","v":27},{"$f":"VLOOKUP(C138,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C138,Absence!D:D)/COUNTIF(C:C,C138)*8/7","v":0},null,{"$f":"SUM(E138:L138)","v":0},{"$f":"IF(C138>VBA!$C$19,0,(8-SUMIF($C:$C,C138,M:M))/COUNTIF(C:C,C138))","v":0},0]
[{"$f":"VLOOKUP(C139,WEEK!B:E,2,FALSE)","v":27},{"$f":"VLOOKUP(C139,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C139,Absence!D:D)/COUNTIF(C:C,C139)*8/7","v":0},null,0,{"$f":"IF(C139>VBA!$C$19,0,(8-SUMIF($C:$C,C139,M:M))/COUNTIF(C:C,C139))","v":0},0]
[{"$f":"VLOOKUP(C140,WEEK!B:E,2,FALSE)","v":27},{"$f":"VLOOKUP(C140,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C140,Absence!D:D)/COUNTIF(C:C,C140)*8/7","v":0},null,0,{"$f":"IF(C140>VBA!$C$19,0,(8-SUMIF($C:$C,C140,M:M))/COUNTIF(C:C,C140))","v":0},0]
[{"$f":"VLOOKUP(C141,WEEK!B:E,2,FALSE)","v":27},{"$f":"VLOOKUP(C141,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C141,Absence!D:D)/COUNTIF(C:C,C141)*8/7","v":0},null,0,{"$f":"IF(C141>VBA!$C$19,0,(8-SUMIF($C:$C,C141,M:M))/COUNTIF(C:C,C141))","v":0},{"$f":"SUM(M141:N141)","v":0}]
[{"$f":"VLOOKUP(C142,WEEK!B:E,2,FALSE)","v":28},{"$f":"VLOOKUP(C142,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C142,Absence!D:D)/COUNTIF(C:C,C142)*8/7","v":0},null,0,{"$f":"IF(C142>VBA!$C$19,0,(8-SUMIF($C:$C,C142,M:M))/COUNTIF(C:C,C142))","v":0},0]
[{"$f":"VLOOKUP(C143,WEEK!B:E,2,FALSE)","v":28},{"$f":"VLOOKUP(C143,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-13",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C143,Absence!D:D)/COUNTIF(C:C,C143)*8/7","v":0},null,0,{"$f":"IF(C143>VBA!$C$19,0,(8-SUMIF($C:$C,C143,M:M))/COUNTIF(C:C,C143))","v":0},0]
[{"$f":"VLOOKUP(C144,WEEK!B:E,2,FALSE)","v":28},{"$f":"VLOOKUP(C144,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C144,Absence!D:D)/COUNTIF(C:C,C144)*8/7","v":0},null,0,{"$f":"IF(C144>VBA!$C$19,0,(8-SUMIF($C:$C,C144,M:M))/COUNTIF(C:C,C144))","v":0},{"$f":"SUM(M144:N144)","v":0}]
[{"$f":"VLOOKUP(C145,WEEK!B:E,2,FALSE)","v":28},{"$f":"VLOOKUP(C145,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C145,Absence!D:D)/COUNTIF(C:C,C145)*8/7","v":0},null,0,{"$f":"IF(C145>VBA!$C$19,0,(8-SUMIF($C:$C,C145,M:M))/COUNTIF(C:C,C145))","v":0},0]
[{"$f":"VLOOKUP(C146,WEEK!B:E,2,FALSE)","v":29},{"$f":"VLOOKUP(C146,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C146,Absence!D:D)/COUNTIF(C:C,C146)*8/7","v":0},null,0,{"$f":"IF(C146>VBA!$C$19,0,(8-SUMIF($C:$C,C146,M:M))/COUNTIF(C:C,C146))","v":0},0]
[{"$f":"VLOOKUP(C147,WEEK!B:E,2,FALSE)","v":29},{"$f":"VLOOKUP(C147,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C147,Absence!D:D)/COUNTIF(C:C,C147)*8/7","v":0},null,0,{"$f":"IF(C147>VBA!$C$19,0,(8-SUMIF($C:$C,C147,M:M))/COUNTIF(C:C,C147))","v":0},0]
[{"$f":"VLOOKUP(C148,WEEK!B:E,2,FALSE)","v":29},{"$f":"VLOOKUP(C148,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C148,Absence!D:D)/COUNTIF(C:C,C148)*8/7","v":0},null,0,{"$f":"IF(C148>VBA!$C$19,0,(8-SUMIF($C:$C,C148,M:M))/COUNTIF(C:C,C148))","v":0},0]
[{"$f":"VLOOKUP(C149,WEEK!B:E,2,FALSE)","v":29},{"$f":"VLOOKUP(C149,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C149,Absence!D:D)/COUNTIF(C:C,C149)*8/7","v":0},null,0,{"$f":"IF(C149>VBA!$C$19,0,(8-SUMIF($C:$C,C149,M:M))/COUNTIF(C:C,C149))","v":0},0]
[{"$f":"VLOOKUP(C150,WEEK!B:E,2,FALSE)","v":29},{"$f":"VLOOKUP(C150,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C150,Absence!D:D)/COUNTIF(C:C,C150)*8/7","v":0},null,0,{"$f":"IF(C150>VBA!$C$19,0,(8-SUMIF($C:$C,C150,M:M))/COUNTIF(C:C,C150))","v":0},{"$f":"SUM(M150:N150)","v":0}]
[{"$f":"VLOOKUP(C151,WEEK!B:E,2,FALSE)","v":30},{"$f":"VLOOKUP(C151,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C151,Absence!D:D)/COUNTIF(C:C,C151)*8/7","v":0},null,0,{"$f":"IF(C151>VBA!$C$19,0,(8-SUMIF($C:$C,C151,M:M))/COUNTIF(C:C,C151))","v":0},0]
[{"$f":"VLOOKUP(C152,WEEK!B:E,2,FALSE)","v":30},{"$f":"VLOOKUP(C152,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C152,Absence!D:D)/COUNTIF(C:C,C152)*8/7","v":0},null,0,{"$f":"IF(C152>VBA!$C$19,0,(8-SUMIF($C:$C,C152,M:M))/COUNTIF(C:C,C152))","v":0},0]
[{"$f":"VLOOKUP(C153,WEEK!B:E,2,FALSE)","v":30},{"$f":"VLOOKUP(C153,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C153,Absence!D:D)/COUNTIF(C:C,C153)*8/7","v":0},null,0,{"$f":"IF(C153>VBA!$C$19,0,(8-SUMIF($C:$C,C153,M:M))/COUNTIF(C:C,C153))","v":0},0]
[{"$f":"VLOOKUP(C154,WEEK!B:E,2,FALSE)","v":30},{"$f":"VLOOKUP(C154,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C154,Absence!D:D)/COUNTIF(C:C,C154)*8/7","v":0},null,0,{"$f":"IF(C154>VBA!$C$19,0,(8-SUMIF($C:$C,C154,M:M))/COUNTIF(C:C,C154))","v":0},0]
[{"$f":"VLOOKUP(C155,WEEK!B:E,2,FALSE)","v":30},{"$f":"VLOOKUP(C155,WEEK!B:E,4,FALSE)","v":"ON"},"2021-07-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C155,Absence!D:D)/COUNTIF(C:C,C155)*8/7","v":0},null,0,{"$f":"IF(C155>VBA!$C$19,0,(8-SUMIF($C:$C,C155,M:M))/COUNTIF(C:C,C155))","v":0},{"$f":"SUM(M155:N155)","v":0}]
[{"$f":"VLOOKUP(C156,WEEK!B:E,2,FALSE)","v":31},{"$f":"VLOOKUP(C156,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C156,Absence!D:D)/COUNTIF(C:C,C156)*8/7","v":0},null,0,{"$f":"IF(C156>VBA!$C$19,0,(8-SUMIF($C:$C,C156,M:M))/COUNTIF(C:C,C156))","v":0},0]
[{"$f":"VLOOKUP(C157,WEEK!B:E,2,FALSE)","v":31},{"$f":"VLOOKUP(C157,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C157,Absence!D:D)/COUNTIF(C:C,C157)*8/7","v":0},null,0,{"$f":"IF(C157>VBA!$C$19,0,(8-SUMIF($C:$C,C157,M:M))/COUNTIF(C:C,C157))","v":0},0]
[{"$f":"VLOOKUP(C158,WEEK!B:E,2,FALSE)","v":31},{"$f":"VLOOKUP(C158,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C158,Absence!D:D)/COUNTIF(C:C,C158)*8/7","v":0},null,0,{"$f":"IF(C158>VBA!$C$19,0,(8-SUMIF($C:$C,C158,M:M))/COUNTIF(C:C,C158))","v":0},0]
[{"$f":"VLOOKUP(C159,WEEK!B:E,2,FALSE)","v":31},{"$f":"VLOOKUP(C159,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C159,Absence!D:D)/COUNTIF(C:C,C159)*8/7","v":0},null,0,{"$f":"IF(C159>VBA!$C$19,0,(8-SUMIF($C:$C,C159,M:M))/COUNTIF(C:C,C159))","v":0},{"$f":"SUM(M159:N159)","v":0}]
[{"$f":"VLOOKUP(C160,WEEK!B:E,2,FALSE)","v":31},{"$f":"VLOOKUP(C160,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C160,Absence!D:D)/COUNTIF(C:C,C160)*8/7","v":0},null,0,{"$f":"IF(C160>VBA!$C$19,0,(8-SUMIF($C:$C,C160,M:M))/COUNTIF(C:C,C160))","v":0},0]
[{"$f":"VLOOKUP(C161,WEEK!B:E,2,FALSE)","v":32},{"$f":"VLOOKUP(C161,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C161,Absence!D:D)/COUNTIF(C:C,C161)*8/7","v":0},null,0,{"$f":"IF(C161>VBA!$C$19,0,(8-SUMIF($C:$C,C161,M:M))/COUNTIF(C:C,C161))","v":0},0]
[{"$f":"VLOOKUP(C162,WEEK!B:E,2,FALSE)","v":32},{"$f":"VLOOKUP(C162,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C162,Absence!D:D)/COUNTIF(C:C,C162)*8/7","v":0},null,0,{"$f":"IF(C162>VBA!$C$19,0,(8-SUMIF($C:$C,C162,M:M))/COUNTIF(C:C,C162))","v":0},0]
[{"$f":"VLOOKUP(C163,WEEK!B:E,2,FALSE)","v":32},{"$f":"VLOOKUP(C163,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-11",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C163,Absence!D:D)/COUNTIF(C:C,C163)*8/7","v":0},null,0,{"$f":"IF(C163>VBA!$C$19,0,(8-SUMIF($C:$C,C163,M:M))/COUNTIF(C:C,C163))","v":0},0]
[{"$f":"VLOOKUP(C164,WEEK!B:E,2,FALSE)","v":32},{"$f":"VLOOKUP(C164,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C164,Absence!D:D)/COUNTIF(C:C,C164)*8/7","v":0},null,0,{"$f":"IF(C164>VBA!$C$19,0,(8-SUMIF($C:$C,C164,M:M))/COUNTIF(C:C,C164))","v":0},{"$f":"SUM(M164:N164)","v":0}]
[{"$f":"VLOOKUP(C165,WEEK!B:E,2,FALSE)","v":32},{"$f":"VLOOKUP(C165,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-13",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C165,Absence!D:D)/COUNTIF(C:C,C165)*8/7","v":0},null,0,{"$f":"IF(C165>VBA!$C$19,0,(8-SUMIF($C:$C,C165,M:M))/COUNTIF(C:C,C165))","v":0},0]
[{"$f":"VLOOKUP(C166,WEEK!B:E,2,FALSE)","v":33},{"$f":"VLOOKUP(C166,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C166,Absence!D:D)/COUNTIF(C:C,C166)*8/7","v":0},null,0,{"$f":"IF(C166>VBA!$C$19,0,(8-SUMIF($C:$C,C166,M:M))/COUNTIF(C:C,C166))","v":0},0]
[{"$f":"VLOOKUP(C167,WEEK!B:E,2,FALSE)","v":33},{"$f":"VLOOKUP(C167,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C167,Absence!D:D)/COUNTIF(C:C,C167)*8/7","v":0},null,0,{"$f":"IF(C167>VBA!$C$19,0,(8-SUMIF($C:$C,C167,M:M))/COUNTIF(C:C,C167))","v":0},0]
[{"$f":"VLOOKUP(C168,WEEK!B:E,2,FALSE)","v":33},{"$f":"VLOOKUP(C168,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C168,Absence!D:D)/COUNTIF(C:C,C168)*8/7","v":0},null,0,{"$f":"IF(C168>VBA!$C$19,0,(8-SUMIF($C:$C,C168,M:M))/COUNTIF(C:C,C168))","v":0},0]
[{"$f":"VLOOKUP(C169,WEEK!B:E,2,FALSE)","v":33},{"$f":"VLOOKUP(C169,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C169,Absence!D:D)/COUNTIF(C:C,C169)*8/7","v":0},null,0,{"$f":"IF(C169>VBA!$C$19,0,(8-SUMIF($C:$C,C169,M:M))/COUNTIF(C:C,C169))","v":0},0]
[{"$f":"VLOOKUP(C170,WEEK!B:E,2,FALSE)","v":33},{"$f":"VLOOKUP(C170,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C170,Absence!D:D)/COUNTIF(C:C,C170)*8/7","v":0},null,0,{"$f":"IF(C170>VBA!$C$19,0,(8-SUMIF($C:$C,C170,M:M))/COUNTIF(C:C,C170))","v":0},{"$f":"SUM(M170:N170)","v":0}]
[{"$f":"VLOOKUP(C171,WEEK!B:E,2,FALSE)","v":34},{"$f":"VLOOKUP(C171,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C171,Absence!D:D)/COUNTIF(C:C,C171)*8/7","v":0},null,0,{"$f":"IF(C171>VBA!$C$19,0,(8-SUMIF($C:$C,C171,M:M))/COUNTIF(C:C,C171))","v":0},0]
[{"$f":"VLOOKUP(C172,WEEK!B:E,2,FALSE)","v":34},{"$f":"VLOOKUP(C172,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-24",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C172,Absence!D:D)/COUNTIF(C:C,C172)*8/7","v":0},null,0,{"$f":"IF(C172>VBA!$C$19,0,(8-SUMIF($C:$C,C172,M:M))/COUNTIF(C:C,C172))","v":0},0]
[{"$f":"VLOOKUP(C173,WEEK!B:E,2,FALSE)","v":34},{"$f":"VLOOKUP(C173,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C173,Absence!D:D)/COUNTIF(C:C,C173)*8/7","v":0},null,0,{"$f":"IF(C173>VBA!$C$19,0,(8-SUMIF($C:$C,C173,M:M))/COUNTIF(C:C,C173))","v":0},0]
[{"$f":"VLOOKUP(C174,WEEK!B:E,2,FALSE)","v":34},{"$f":"VLOOKUP(C174,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C174,Absence!D:D)/COUNTIF(C:C,C174)*8/7","v":0},null,0,{"$f":"IF(C174>VBA!$C$19,0,(8-SUMIF($C:$C,C174,M:M))/COUNTIF(C:C,C174))","v":0},0]
[{"$f":"VLOOKUP(C175,WEEK!B:E,2,FALSE)","v":34},{"$f":"VLOOKUP(C175,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C175,Absence!D:D)/COUNTIF(C:C,C175)*8/7","v":0},null,0,{"$f":"IF(C175>VBA!$C$19,0,(8-SUMIF($C:$C,C175,M:M))/COUNTIF(C:C,C175))","v":0},0]
[{"$f":"VLOOKUP(C176,WEEK!B:E,2,FALSE)","v":35},{"$f":"VLOOKUP(C176,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C176,Absence!D:D)/COUNTIF(C:C,C176)*8/7","v":0},null,0,{"$f":"IF(C176>VBA!$C$19,0,(8-SUMIF($C:$C,C176,M:M))/COUNTIF(C:C,C176))","v":0},0]
[{"$f":"VLOOKUP(C177,WEEK!B:E,2,FALSE)","v":35},{"$f":"VLOOKUP(C177,WEEK!B:E,4,FALSE)","v":"ON"},"2021-08-31",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C177,Absence!D:D)/COUNTIF(C:C,C177)*8/7","v":0},null,0,{"$f":"IF(C177>VBA!$C$19,0,(8-SUMIF($C:$C,C177,M:M))/COUNTIF(C:C,C177))","v":0},0]
[{"$f":"VLOOKUP(C178,WEEK!B:E,2,FALSE)","v":35},{"$f":"VLOOKUP(C178,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C178,Absence!D:D)/COUNTIF(C:C,C178)*8/7","v":0},null,0,{"$f":"IF(C178>VBA!$C$19,0,(8-SUMIF($C:$C,C178,M:M))/COUNTIF(C:C,C178))","v":0},0]
[{"$f":"VLOOKUP(C179,WEEK!B:E,2,FALSE)","v":35},{"$f":"VLOOKUP(C179,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C179,Absence!D:D)/COUNTIF(C:C,C179)*8/7","v":0},null,0,{"$f":"IF(C179>VBA!$C$19,0,(8-SUMIF($C:$C,C179,M:M))/COUNTIF(C:C,C179))","v":0},0]
[{"$f":"VLOOKUP(C180,WEEK!B:E,2,FALSE)","v":35},{"$f":"VLOOKUP(C180,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C180,Absence!D:D)/COUNTIF(C:C,C180)*8/7","v":0},null,0,{"$f":"IF(C180>VBA!$C$19,0,(8-SUMIF($C:$C,C180,M:M))/COUNTIF(C:C,C180))","v":0},0]
[{"$f":"VLOOKUP(C181,WEEK!B:E,2,FALSE)","v":36},{"$f":"VLOOKUP(C181,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C181,Absence!D:D)/COUNTIF(C:C,C181)*8/7","v":0},null,0,{"$f":"IF(C181>VBA!$C$19,0,(8-SUMIF($C:$C,C181,M:M))/COUNTIF(C:C,C181))","v":0},0]
[{"$f":"VLOOKUP(C182,WEEK!B:E,2,FALSE)","v":36},{"$f":"VLOOKUP(C182,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C182,Absence!D:D)/COUNTIF(C:C,C182)*8/7","v":0},null,0,{"$f":"IF(C182>VBA!$C$19,0,(8-SUMIF($C:$C,C182,M:M))/COUNTIF(C:C,C182))","v":0},0]
[{"$f":"VLOOKUP(C183,WEEK!B:E,2,FALSE)","v":36},{"$f":"VLOOKUP(C183,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C183,Absence!D:D)/COUNTIF(C:C,C183)*8/7","v":0},null,0,{"$f":"IF(C183>VBA!$C$19,0,(8-SUMIF($C:$C,C183,M:M))/COUNTIF(C:C,C183))","v":0},0]
[{"$f":"VLOOKUP(C184,WEEK!B:E,2,FALSE)","v":36},{"$f":"VLOOKUP(C184,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C184,Absence!D:D)/COUNTIF(C:C,C184)*8/7","v":0},null,0,{"$f":"IF(C184>VBA!$C$19,0,(8-SUMIF($C:$C,C184,M:M))/COUNTIF(C:C,C184))","v":0},{"$f":"SUM(M184:N184)","v":0}]
[{"$f":"VLOOKUP(C185,WEEK!B:E,2,FALSE)","v":36},{"$f":"VLOOKUP(C185,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C185,Absence!D:D)/COUNTIF(C:C,C185)*8/7","v":0},null,0,{"$f":"IF(C185>VBA!$C$19,0,(8-SUMIF($C:$C,C185,M:M))/COUNTIF(C:C,C185))","v":0},0]
[{"$f":"VLOOKUP(C186,WEEK!B:E,2,FALSE)","v":37},{"$f":"VLOOKUP(C186,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-13",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C186,Absence!D:D)/COUNTIF(C:C,C186)*8/7","v":0},null,0,{"$f":"IF(C186>VBA!$C$19,0,(8-SUMIF($C:$C,C186,M:M))/COUNTIF(C:C,C186))","v":0},{"$f":"SUM(M186:N186)","v":0}]
[{"$f":"VLOOKUP(C187,WEEK!B:E,2,FALSE)","v":37},{"$f":"VLOOKUP(C187,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-14",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C187,Absence!D:D)/COUNTIF(C:C,C187)*8/7","v":0},null,0,{"$f":"IF(C187>VBA!$C$19,0,(8-SUMIF($C:$C,C187,M:M))/COUNTIF(C:C,C187))","v":0},0]
[{"$f":"VLOOKUP(C188,WEEK!B:E,2,FALSE)","v":37},{"$f":"VLOOKUP(C188,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C188,Absence!D:D)/COUNTIF(C:C,C188)*8/7","v":0},null,0,{"$f":"IF(C188>VBA!$C$19,0,(8-SUMIF($C:$C,C188,M:M))/COUNTIF(C:C,C188))","v":0},0]
[{"$f":"VLOOKUP(C189,WEEK!B:E,2,FALSE)","v":37},{"$f":"VLOOKUP(C189,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C189,Absence!D:D)/COUNTIF(C:C,C189)*8/7","v":0},null,0,{"$f":"IF(C189>VBA!$C$19,0,(8-SUMIF($C:$C,C189,M:M))/COUNTIF(C:C,C189))","v":0},0]
[{"$f":"VLOOKUP(C190,WEEK!B:E,2,FALSE)","v":37},{"$f":"VLOOKUP(C190,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C190,Absence!D:D)/COUNTIF(C:C,C190)*8/7","v":0},null,0,{"$f":"IF(C190>VBA!$C$19,0,(8-SUMIF($C:$C,C190,M:M))/COUNTIF(C:C,C190))","v":0},0]
[{"$f":"VLOOKUP(C191,WEEK!B:E,2,FALSE)","v":38},{"$f":"VLOOKUP(C191,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C191,Absence!D:D)/COUNTIF(C:C,C191)*8/7","v":0},null,0,{"$f":"IF(C191>VBA!$C$19,0,(8-SUMIF($C:$C,C191,M:M))/COUNTIF(C:C,C191))","v":0},0]
[{"$f":"VLOOKUP(C192,WEEK!B:E,2,FALSE)","v":38},{"$f":"VLOOKUP(C192,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C192,Absence!D:D)/COUNTIF(C:C,C192)*8/7","v":0},null,0,{"$f":"IF(C192>VBA!$C$19,0,(8-SUMIF($C:$C,C192,M:M))/COUNTIF(C:C,C192))","v":0},0]
[{"$f":"VLOOKUP(C193,WEEK!B:E,2,FALSE)","v":38},{"$f":"VLOOKUP(C193,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C193,Absence!D:D)/COUNTIF(C:C,C193)*8/7","v":0},null,0,{"$f":"IF(C193>VBA!$C$19,0,(8-SUMIF($C:$C,C193,M:M))/COUNTIF(C:C,C193))","v":0},0]
[{"$f":"VLOOKUP(C194,WEEK!B:E,2,FALSE)","v":38},{"$f":"VLOOKUP(C194,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C194,Absence!D:D)/COUNTIF(C:C,C194)*8/7","v":0},null,0,{"$f":"IF(C194>VBA!$C$19,0,(8-SUMIF($C:$C,C194,M:M))/COUNTIF(C:C,C194))","v":0},0]
[{"$f":"VLOOKUP(C195,WEEK!B:E,2,FALSE)","v":38},{"$f":"VLOOKUP(C195,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-24",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C195,Absence!D:D)/COUNTIF(C:C,C195)*8/7","v":0},null,0,{"$f":"IF(C195>VBA!$C$19,0,(8-SUMIF($C:$C,C195,M:M))/COUNTIF(C:C,C195))","v":0},0]
[{"$f":"VLOOKUP(C196,WEEK!B:E,2,FALSE)","v":39},{"$f":"VLOOKUP(C196,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C196,Absence!D:D)/COUNTIF(C:C,C196)*8/7","v":0},null,0,{"$f":"IF(C196>VBA!$C$19,0,(8-SUMIF($C:$C,C196,M:M))/COUNTIF(C:C,C196))","v":0},{"$f":"SUM(M196:N196)","v":0}]
[{"$f":"VLOOKUP(C197,WEEK!B:E,2,FALSE)","v":39},{"$f":"VLOOKUP(C197,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C197,Absence!D:D)/COUNTIF(C:C,C197)*8/7","v":0},null,0,{"$f":"IF(C197>VBA!$C$19,0,(8-SUMIF($C:$C,C197,M:M))/COUNTIF(C:C,C197))","v":0},0]
[{"$f":"VLOOKUP(C198,WEEK!B:E,2,FALSE)","v":39},{"$f":"VLOOKUP(C198,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C198,Absence!D:D)/COUNTIF(C:C,C198)*8/7","v":0},null,0,{"$f":"IF(C198>VBA!$C$19,0,(8-SUMIF($C:$C,C198,M:M))/COUNTIF(C:C,C198))","v":0},0]
[{"$f":"VLOOKUP(C199,WEEK!B:E,2,FALSE)","v":39},{"$f":"VLOOKUP(C199,WEEK!B:E,4,FALSE)","v":"ON"},"2021-09-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C199,Absence!D:D)/COUNTIF(C:C,C199)*8/7","v":0},null,0,{"$f":"IF(C199>VBA!$C$19,0,(8-SUMIF($C:$C,C199,M:M))/COUNTIF(C:C,C199))","v":0},{"$f":"SUM(M199:N199)","v":0}]
[{"$f":"VLOOKUP(C200,WEEK!B:E,2,FALSE)","v":39},{"$f":"VLOOKUP(C200,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C200,Absence!D:D)/COUNTIF(C:C,C200)*8/7","v":0},null,0,{"$f":"IF(C200>VBA!$C$19,0,(8-SUMIF($C:$C,C200,M:M))/COUNTIF(C:C,C200))","v":0},0]
[{"$f":"VLOOKUP(C201,WEEK!B:E,2,FALSE)","v":40},{"$f":"VLOOKUP(C201,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C201,Absence!D:D)/COUNTIF(C:C,C201)*8/7","v":0},null,0,{"$f":"IF(C201>VBA!$C$19,0,(8-SUMIF($C:$C,C201,M:M))/COUNTIF(C:C,C201))","v":0},{"$f":"SUM(M201:N201)","v":0}]
[{"$f":"VLOOKUP(C202,WEEK!B:E,2,FALSE)","v":40},{"$f":"VLOOKUP(C202,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C202,Absence!D:D)/COUNTIF(C:C,C202)*8/7","v":0},null,{"$f":"SUM(E202:L202)","v":0},{"$f":"IF(C202>VBA!$C$19,0,(8-SUMIF($C:$C,C202,M:M))/COUNTIF(C:C,C202))","v":0},0]
[{"$f":"VLOOKUP(C203,WEEK!B:E,2,FALSE)","v":40},{"$f":"VLOOKUP(C203,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C203,Absence!D:D)/COUNTIF(C:C,C203)*8/7","v":0},null,0,{"$f":"IF(C203>VBA!$C$19,0,(8-SUMIF($C:$C,C203,M:M))/COUNTIF(C:C,C203))","v":0},0]
[{"$f":"VLOOKUP(C204,WEEK!B:E,2,FALSE)","v":40},{"$f":"VLOOKUP(C204,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C204,Absence!D:D)/COUNTIF(C:C,C204)*8/7","v":0},null,0,{"$f":"IF(C204>VBA!$C$19,0,(8-SUMIF($C:$C,C204,M:M))/COUNTIF(C:C,C204))","v":0},0]
[{"$f":"VLOOKUP(C205,WEEK!B:E,2,FALSE)","v":40},{"$f":"VLOOKUP(C205,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C205,Absence!D:D)/COUNTIF(C:C,C205)*8/7","v":0},null,0,{"$f":"IF(C205>VBA!$C$19,0,(8-SUMIF($C:$C,C205,M:M))/COUNTIF(C:C,C205))","v":0},0]
[{"$f":"VLOOKUP(C206,WEEK!B:E,2,FALSE)","v":41},{"$f":"VLOOKUP(C206,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-11",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C206,Absence!D:D)/COUNTIF(C:C,C206)*8/7","v":0},null,0,{"$f":"IF(C206>VBA!$C$19,0,(8-SUMIF($C:$C,C206,M:M))/COUNTIF(C:C,C206))","v":0},{"$f":"SUM(M206:N206)","v":0}]
[{"$f":"VLOOKUP(C207,WEEK!B:E,2,FALSE)","v":41},{"$f":"VLOOKUP(C207,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C207,Absence!D:D)/COUNTIF(C:C,C207)*8/7","v":0},null,0,{"$f":"IF(C207>VBA!$C$19,0,(8-SUMIF($C:$C,C207,M:M))/COUNTIF(C:C,C207))","v":0},0]
[{"$f":"VLOOKUP(C208,WEEK!B:E,2,FALSE)","v":41},{"$f":"VLOOKUP(C208,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-13",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C208,Absence!D:D)/COUNTIF(C:C,C208)*8/7","v":0},null,0,{"$f":"IF(C208>VBA!$C$19,0,(8-SUMIF($C:$C,C208,M:M))/COUNTIF(C:C,C208))","v":0},0]
[{"$f":"VLOOKUP(C209,WEEK!B:E,2,FALSE)","v":41},{"$f":"VLOOKUP(C209,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-14",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C209,Absence!D:D)/COUNTIF(C:C,C209)*8/7","v":0},null,0,{"$f":"IF(C209>VBA!$C$19,0,(8-SUMIF($C:$C,C209,M:M))/COUNTIF(C:C,C209))","v":0},{"$f":"SUM(M209:N209)","v":0}]
[{"$f":"VLOOKUP(C210,WEEK!B:E,2,FALSE)","v":41},{"$f":"VLOOKUP(C210,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C210,Absence!D:D)/COUNTIF(C:C,C210)*8/7","v":0},null,0,{"$f":"IF(C210>VBA!$C$19,0,(8-SUMIF($C:$C,C210,M:M))/COUNTIF(C:C,C210))","v":0},0]
[{"$f":"VLOOKUP(C211,WEEK!B:E,2,FALSE)","v":42},{"$f":"VLOOKUP(C211,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C211,Absence!D:D)/COUNTIF(C:C,C211)*8/7","v":0},null,0,{"$f":"IF(C211>VBA!$C$19,0,(8-SUMIF($C:$C,C211,M:M))/COUNTIF(C:C,C211))","v":0},0]
[{"$f":"VLOOKUP(C212,WEEK!B:E,2,FALSE)","v":42},{"$f":"VLOOKUP(C212,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C212,Absence!D:D)/COUNTIF(C:C,C212)*8/7","v":0},null,0,{"$f":"IF(C212>VBA!$C$19,0,(8-SUMIF($C:$C,C212,M:M))/COUNTIF(C:C,C212))","v":0},0]
[{"$f":"VLOOKUP(C213,WEEK!B:E,2,FALSE)","v":42},{"$f":"VLOOKUP(C213,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C213,Absence!D:D)/COUNTIF(C:C,C213)*8/7","v":0},null,0,{"$f":"IF(C213>VBA!$C$19,0,(8-SUMIF($C:$C,C213,M:M))/COUNTIF(C:C,C213))","v":0},0]
[{"$f":"VLOOKUP(C214,WEEK!B:E,2,FALSE)","v":42},{"$f":"VLOOKUP(C214,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C214,Absence!D:D)/COUNTIF(C:C,C214)*8/7","v":0},null,0,{"$f":"IF(C214>VBA!$C$19,0,(8-SUMIF($C:$C,C214,M:M))/COUNTIF(C:C,C214))","v":0},{"$f":"SUM(M214:N214)","v":0}]
[{"$f":"VLOOKUP(C215,WEEK!B:E,2,FALSE)","v":42},{"$f":"VLOOKUP(C215,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C215,Absence!D:D)/COUNTIF(C:C,C215)*8/7","v":0},null,0,{"$f":"IF(C215>VBA!$C$19,0,(8-SUMIF($C:$C,C215,M:M))/COUNTIF(C:C,C215))","v":0},0]
[{"$f":"VLOOKUP(C216,WEEK!B:E,2,FALSE)","v":43},{"$f":"VLOOKUP(C216,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C216,Absence!D:D)/COUNTIF(C:C,C216)*8/7","v":0},null,0,{"$f":"IF(C216>VBA!$C$19,0,(8-SUMIF($C:$C,C216,M:M))/COUNTIF(C:C,C216))","v":0},0]
[{"$f":"VLOOKUP(C217,WEEK!B:E,2,FALSE)","v":43},{"$f":"VLOOKUP(C217,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C217,Absence!D:D)/COUNTIF(C:C,C217)*8/7","v":0},null,0,{"$f":"IF(C217>VBA!$C$19,0,(8-SUMIF($C:$C,C217,M:M))/COUNTIF(C:C,C217))","v":0},0]
[{"$f":"VLOOKUP(C218,WEEK!B:E,2,FALSE)","v":43},{"$f":"VLOOKUP(C218,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C218,Absence!D:D)/COUNTIF(C:C,C218)*8/7","v":0},null,0,{"$f":"IF(C218>VBA!$C$19,0,(8-SUMIF($C:$C,C218,M:M))/COUNTIF(C:C,C218))","v":0},{"$f":"SUM(M218:N218)","v":0}]
[{"$f":"VLOOKUP(C219,WEEK!B:E,2,FALSE)","v":43},{"$f":"VLOOKUP(C219,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C219,Absence!D:D)/COUNTIF(C:C,C219)*8/7","v":0},null,0,{"$f":"IF(C219>VBA!$C$19,0,(8-SUMIF($C:$C,C219,M:M))/COUNTIF(C:C,C219))","v":0},0]
[{"$f":"VLOOKUP(C220,WEEK!B:E,2,FALSE)","v":43},{"$f":"VLOOKUP(C220,WEEK!B:E,4,FALSE)","v":"ON"},"2021-10-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C220,Absence!D:D)/COUNTIF(C:C,C220)*8/7","v":0},null,0,{"$f":"IF(C220>VBA!$C$19,0,(8-SUMIF($C:$C,C220,M:M))/COUNTIF(C:C,C220))","v":0},0]
[{"$f":"VLOOKUP(C221,WEEK!B:E,2,FALSE)","v":44},{"$f":"VLOOKUP(C221,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C221,Absence!D:D)/COUNTIF(C:C,C221)*8/7","v":0},null,0,{"$f":"IF(C221>VBA!$C$19,0,(8-SUMIF($C:$C,C221,M:M))/COUNTIF(C:C,C221))","v":0},0]
[{"$f":"VLOOKUP(C222,WEEK!B:E,2,FALSE)","v":44},{"$f":"VLOOKUP(C222,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C222,Absence!D:D)/COUNTIF(C:C,C222)*8/7","v":0},null,0,{"$f":"IF(C222>VBA!$C$19,0,(8-SUMIF($C:$C,C222,M:M))/COUNTIF(C:C,C222))","v":0},0]
[{"$f":"VLOOKUP(C223,WEEK!B:E,2,FALSE)","v":44},{"$f":"VLOOKUP(C223,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-04",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C223,Absence!D:D)/COUNTIF(C:C,C223)*8/7","v":0},null,0,{"$f":"IF(C223>VBA!$C$19,0,(8-SUMIF($C:$C,C223,M:M))/COUNTIF(C:C,C223))","v":0},{"$f":"SUM(M223:N223)","v":0}]
[{"$f":"VLOOKUP(C224,WEEK!B:E,2,FALSE)","v":44},{"$f":"VLOOKUP(C224,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-05",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C224,Absence!D:D)/COUNTIF(C:C,C224)*8/7","v":0},null,0,{"$f":"IF(C224>VBA!$C$19,0,(8-SUMIF($C:$C,C224,M:M))/COUNTIF(C:C,C224))","v":0},0]
[{"$f":"VLOOKUP(C225,WEEK!B:E,2,FALSE)","v":45},{"$f":"VLOOKUP(C225,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C225,Absence!D:D)/COUNTIF(C:C,C225)*8/7","v":0},null,0,{"$f":"IF(C225>VBA!$C$19,0,(8-SUMIF($C:$C,C225,M:M))/COUNTIF(C:C,C225))","v":0},0]
[{"$f":"VLOOKUP(C226,WEEK!B:E,2,FALSE)","v":45},{"$f":"VLOOKUP(C226,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C226,Absence!D:D)/COUNTIF(C:C,C226)*8/7","v":0},null,0,{"$f":"IF(C226>VBA!$C$19,0,(8-SUMIF($C:$C,C226,M:M))/COUNTIF(C:C,C226))","v":0},0]
[{"$f":"VLOOKUP(C227,WEEK!B:E,2,FALSE)","v":45},{"$f":"VLOOKUP(C227,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C227,Absence!D:D)/COUNTIF(C:C,C227)*8/7","v":0},null,0,{"$f":"IF(C227>VBA!$C$19,0,(8-SUMIF($C:$C,C227,M:M))/COUNTIF(C:C,C227))","v":0},{"$f":"SUM(M227:N227)","v":0}]
[{"$f":"VLOOKUP(C228,WEEK!B:E,2,FALSE)","v":45},{"$f":"VLOOKUP(C228,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-12",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C228,Absence!D:D)/COUNTIF(C:C,C228)*8/7","v":0},null,0,{"$f":"IF(C228>VBA!$C$19,0,(8-SUMIF($C:$C,C228,M:M))/COUNTIF(C:C,C228))","v":0},0]
[{"$f":"VLOOKUP(C229,WEEK!B:E,2,FALSE)","v":46},{"$f":"VLOOKUP(C229,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C229,Absence!D:D)/COUNTIF(C:C,C229)*8/7","v":0},null,0,{"$f":"IF(C229>VBA!$C$19,0,(8-SUMIF($C:$C,C229,M:M))/COUNTIF(C:C,C229))","v":0},0]
[{"$f":"VLOOKUP(C230,WEEK!B:E,2,FALSE)","v":46},{"$f":"VLOOKUP(C230,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C230,Absence!D:D)/COUNTIF(C:C,C230)*8/7","v":0},null,0,{"$f":"IF(C230>VBA!$C$19,0,(8-SUMIF($C:$C,C230,M:M))/COUNTIF(C:C,C230))","v":0},0]
[{"$f":"VLOOKUP(C231,WEEK!B:E,2,FALSE)","v":46},{"$f":"VLOOKUP(C231,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C231,Absence!D:D)/COUNTIF(C:C,C231)*8/7","v":0},null,0,{"$f":"IF(C231>VBA!$C$19,0,(8-SUMIF($C:$C,C231,M:M))/COUNTIF(C:C,C231))","v":0},0]
[{"$f":"VLOOKUP(C232,WEEK!B:E,2,FALSE)","v":46},{"$f":"VLOOKUP(C232,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-18",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C232,Absence!D:D)/COUNTIF(C:C,C232)*8/7","v":0},null,0,{"$f":"IF(C232>VBA!$C$19,0,(8-SUMIF($C:$C,C232,M:M))/COUNTIF(C:C,C232))","v":0},0]
[{"$f":"VLOOKUP(C233,WEEK!B:E,2,FALSE)","v":46},{"$f":"VLOOKUP(C233,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-19",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C233,Absence!D:D)/COUNTIF(C:C,C233)*8/7","v":0},null,0,{"$f":"IF(C233>VBA!$C$19,0,(8-SUMIF($C:$C,C233,M:M))/COUNTIF(C:C,C233))","v":0},{"$f":"SUM(M233:N233)","v":0}]
[{"$f":"VLOOKUP(C234,WEEK!B:E,2,FALSE)","v":47},{"$f":"VLOOKUP(C234,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C234,Absence!D:D)/COUNTIF(C:C,C234)*8/7","v":0},null,0,{"$f":"IF(C234>VBA!$C$19,0,(8-SUMIF($C:$C,C234,M:M))/COUNTIF(C:C,C234))","v":0},0]
[{"$f":"VLOOKUP(C235,WEEK!B:E,2,FALSE)","v":47},{"$f":"VLOOKUP(C235,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C235,Absence!D:D)/COUNTIF(C:C,C235)*8/7","v":0},null,0,{"$f":"IF(C235>VBA!$C$19,0,(8-SUMIF($C:$C,C235,M:M))/COUNTIF(C:C,C235))","v":0},0]
[{"$f":"VLOOKUP(C236,WEEK!B:E,2,FALSE)","v":47},{"$f":"VLOOKUP(C236,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-24",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C236,Absence!D:D)/COUNTIF(C:C,C236)*8/7","v":0},null,0,{"$f":"IF(C236>VBA!$C$19,0,(8-SUMIF($C:$C,C236,M:M))/COUNTIF(C:C,C236))","v":0},{"$f":"SUM(M236:N236)","v":0}]
[{"$f":"VLOOKUP(C237,WEEK!B:E,2,FALSE)","v":47},{"$f":"VLOOKUP(C237,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-25",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C237,Absence!D:D)/COUNTIF(C:C,C237)*8/7","v":0},null,0,{"$f":"IF(C237>VBA!$C$19,0,(8-SUMIF($C:$C,C237,M:M))/COUNTIF(C:C,C237))","v":0},0]
[{"$f":"VLOOKUP(C238,WEEK!B:E,2,FALSE)","v":47},{"$f":"VLOOKUP(C238,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-26",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C238,Absence!D:D)/COUNTIF(C:C,C238)*8/7","v":0},null,0,{"$f":"IF(C238>VBA!$C$19,0,(8-SUMIF($C:$C,C238,M:M))/COUNTIF(C:C,C238))","v":0},0]
[{"$f":"VLOOKUP(C239,WEEK!B:E,2,FALSE)","v":48},{"$f":"VLOOKUP(C239,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C239,Absence!D:D)/COUNTIF(C:C,C239)*8/7","v":0},null,0,{"$f":"IF(C239>VBA!$C$19,0,(8-SUMIF($C:$C,C239,M:M))/COUNTIF(C:C,C239))","v":0},0]
[{"$f":"VLOOKUP(C240,WEEK!B:E,2,FALSE)","v":48},{"$f":"VLOOKUP(C240,WEEK!B:E,4,FALSE)","v":"ON"},"2021-11-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C240,Absence!D:D)/COUNTIF(C:C,C240)*8/7","v":0},null,0,{"$f":"IF(C240>VBA!$C$19,0,(8-SUMIF($C:$C,C240,M:M))/COUNTIF(C:C,C240))","v":0},{"$f":"SUM(M240:N240)","v":0}]
[{"$f":"VLOOKUP(C241,WEEK!B:E,2,FALSE)","v":48},{"$f":"VLOOKUP(C241,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-01",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C241,Absence!D:D)/COUNTIF(C:C,C241)*8/7","v":0},null,0,{"$f":"IF(C241>VBA!$C$19,0,(8-SUMIF($C:$C,C241,M:M))/COUNTIF(C:C,C241))","v":0},0]
[{"$f":"VLOOKUP(C242,WEEK!B:E,2,FALSE)","v":48},{"$f":"VLOOKUP(C242,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-02",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C242,Absence!D:D)/COUNTIF(C:C,C242)*8/7","v":0},null,0,{"$f":"IF(C242>VBA!$C$19,0,(8-SUMIF($C:$C,C242,M:M))/COUNTIF(C:C,C242))","v":0},{"$f":"SUM(M242:N242)","v":0}]
[{"$f":"VLOOKUP(C243,WEEK!B:E,2,FALSE)","v":48},{"$f":"VLOOKUP(C243,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-03",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C243,Absence!D:D)/COUNTIF(C:C,C243)*8/7","v":0},null,0,{"$f":"IF(C243>VBA!$C$19,0,(8-SUMIF($C:$C,C243,M:M))/COUNTIF(C:C,C243))","v":0},0]
[{"$f":"VLOOKUP(C244,WEEK!B:E,2,FALSE)","v":49},{"$f":"VLOOKUP(C244,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-06",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C244,Absence!D:D)/COUNTIF(C:C,C244)*8/7","v":0},null,0,{"$f":"IF(C244>VBA!$C$19,0,(8-SUMIF($C:$C,C244,M:M))/COUNTIF(C:C,C244))","v":0},0]
[{"$f":"VLOOKUP(C245,WEEK!B:E,2,FALSE)","v":49},{"$f":"VLOOKUP(C245,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-07",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C245,Absence!D:D)/COUNTIF(C:C,C245)*8/7","v":0},null,0,{"$f":"IF(C245>VBA!$C$19,0,(8-SUMIF($C:$C,C245,M:M))/COUNTIF(C:C,C245))","v":0},0]
[{"$f":"VLOOKUP(C246,WEEK!B:E,2,FALSE)","v":49},{"$f":"VLOOKUP(C246,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-08",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C246,Absence!D:D)/COUNTIF(C:C,C246)*8/7","v":0},null,0,{"$f":"IF(C246>VBA!$C$19,0,(8-SUMIF($C:$C,C246,M:M))/COUNTIF(C:C,C246))","v":0},0]
[{"$f":"VLOOKUP(C247,WEEK!B:E,2,FALSE)","v":49},{"$f":"VLOOKUP(C247,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-09",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C247,Absence!D:D)/COUNTIF(C:C,C247)*8/7","v":0},null,0,{"$f":"IF(C247>VBA!$C$19,0,(8-SUMIF($C:$C,C247,M:M))/COUNTIF(C:C,C247))","v":0},0]
[{"$f":"VLOOKUP(C248,WEEK!B:E,2,FALSE)","v":49},{"$f":"VLOOKUP(C248,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-10",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C248,Absence!D:D)/COUNTIF(C:C,C248)*8/7","v":0},null,0,{"$f":"IF(C248>VBA!$C$19,0,(8-SUMIF($C:$C,C248,M:M))/COUNTIF(C:C,C248))","v":0},0]
[{"$f":"VLOOKUP(C249,WEEK!B:E,2,FALSE)","v":50},{"$f":"VLOOKUP(C249,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-13",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C249,Absence!D:D)/COUNTIF(C:C,C249)*8/7","v":0},null,0,{"$f":"IF(C249>VBA!$C$19,0,(8-SUMIF($C:$C,C249,M:M))/COUNTIF(C:C,C249))","v":0},0]
[{"$f":"VLOOKUP(C250,WEEK!B:E,2,FALSE)","v":50},{"$f":"VLOOKUP(C250,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-14",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C250,Absence!D:D)/COUNTIF(C:C,C250)*8/7","v":0},null,0,{"$f":"IF(C250>VBA!$C$19,0,(8-SUMIF($C:$C,C250,M:M))/COUNTIF(C:C,C250))","v":0},0]
[{"$f":"VLOOKUP(C251,WEEK!B:E,2,FALSE)","v":50},{"$f":"VLOOKUP(C251,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-15",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C251,Absence!D:D)/COUNTIF(C:C,C251)*8/7","v":0},null,0,{"$f":"IF(C251>VBA!$C$19,0,(8-SUMIF($C:$C,C251,M:M))/COUNTIF(C:C,C251))","v":0},0]
[{"$f":"VLOOKUP(C252,WEEK!B:E,2,FALSE)","v":50},{"$f":"VLOOKUP(C252,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-16",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C252,Absence!D:D)/COUNTIF(C:C,C252)*8/7","v":0},null,0,{"$f":"IF(C252>VBA!$C$19,0,(8-SUMIF($C:$C,C252,M:M))/COUNTIF(C:C,C252))","v":0},0]
[{"$f":"VLOOKUP(C253,WEEK!B:E,2,FALSE)","v":50},{"$f":"VLOOKUP(C253,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-17",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C253,Absence!D:D)/COUNTIF(C:C,C253)*8/7","v":0},null,0,{"$f":"IF(C253>VBA!$C$19,0,(8-SUMIF($C:$C,C253,M:M))/COUNTIF(C:C,C253))","v":0},0]
[{"$f":"VLOOKUP(C254,WEEK!B:E,2,FALSE)","v":51},{"$f":"VLOOKUP(C254,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-20",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C254,Absence!D:D)/COUNTIF(C:C,C254)*8/7","v":0},null,0,{"$f":"IF(C254>VBA!$C$19,0,(8-SUMIF($C:$C,C254,M:M))/COUNTIF(C:C,C254))","v":0},0]
[{"$f":"VLOOKUP(C255,WEEK!B:E,2,FALSE)","v":51},{"$f":"VLOOKUP(C255,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-21",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C255,Absence!D:D)/COUNTIF(C:C,C255)*8/7","v":0},null,0,{"$f":"IF(C255>VBA!$C$19,0,(8-SUMIF($C:$C,C255,M:M))/COUNTIF(C:C,C255))","v":0},0]
[{"$f":"VLOOKUP(C256,WEEK!B:E,2,FALSE)","v":51},{"$f":"VLOOKUP(C256,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-22",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C256,Absence!D:D)/COUNTIF(C:C,C256)*8/7","v":0},null,0,{"$f":"IF(C256>VBA!$C$19,0,(8-SUMIF($C:$C,C256,M:M))/COUNTIF(C:C,C256))","v":0},0]
[{"$f":"VLOOKUP(C257,WEEK!B:E,2,FALSE)","v":51},{"$f":"VLOOKUP(C257,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-23",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C257,Absence!D:D)/COUNTIF(C:C,C257)*8/7","v":0},null,0,{"$f":"IF(C257>VBA!$C$19,0,(8-SUMIF($C:$C,C257,M:M))/COUNTIF(C:C,C257))","v":0},0]
[{"$f":"VLOOKUP(C258,WEEK!B:E,2,FALSE)","v":51},{"$f":"VLOOKUP(C258,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-24",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C258,Absence!D:D)/COUNTIF(C:C,C258)*8/7","v":0},null,0,{"$f":"IF(C258>VBA!$C$19,0,(8-SUMIF($C:$C,C258,M:M))/COUNTIF(C:C,C258))","v":0},0]
[{"$f":"VLOOKUP(C259,WEEK!B:E,2,FALSE)","v":52},{"$f":"VLOOKUP(C259,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-27",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C259,Absence!D:D)/COUNTIF(C:C,C259)*8/7","v":0},null,0,{"$f":"IF(C259>VBA!$C$19,0,(8-SUMIF($C:$C,C259,M:M))/COUNTIF(C:C,C259))","v":0},0]
[{"$f":"VLOOKUP(C260,WEEK!B:E,2,FALSE)","v":52},{"$f":"VLOOKUP(C260,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-28",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C260,Absence!D:D)/COUNTIF(C:C,C260)*8/7","v":0},null,0,{"$f":"IF(C260>VBA!$C$19,0,(8-SUMIF($C:$C,C260,M:M))/COUNTIF(C:C,C260))","v":0},0]
[{"$f":"VLOOKUP(C261,WEEK!B:E,2,FALSE)","v":52},{"$f":"VLOOKUP(C261,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-29",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C261,Absence!D:D)/COUNTIF(C:C,C261)*8/7","v":0},null,0,{"$f":"IF(C261>VBA!$C$19,0,(8-SUMIF($C:$C,C261,M:M))/COUNTIF(C:C,C261))","v":0},0]
[{"$f":"VLOOKUP(C262,WEEK!B:E,2,FALSE)","v":52},{"$f":"VLOOKUP(C262,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-30",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C262,Absence!D:D)/COUNTIF(C:C,C262)*8/7","v":0},null,0,{"$f":"IF(C262>VBA!$C$19,0,(8-SUMIF($C:$C,C262,M:M))/COUNTIF(C:C,C262))","v":0},0]
[{"$f":"VLOOKUP(C263,WEEK!B:E,2,FALSE)","v":52},{"$f":"VLOOKUP(C263,WEEK!B:E,4,FALSE)","v":"ON"},"2021-12-31",null,null,null,null,null,null,null,{"$f":"SUMIF(Absence!$B:$B,$D$4&\"-\"&C263,Absence!D:D)/COUNTIF(C:C,C263)*8/7","v":0},null,0,{"$f":"IF(C263>VBA!$C$19,0,(8-SUMIF($C:$C,C263,M:M))/COUNTIF(C:C,C263))","v":0},0]

{"sheet":"MyTime","index":2,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"EOMONTH(DATE(VBA!$C$6,C8,1),0)+1","v":"2021-02-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,D8,1),0)+1","v":"2021-03-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,E8,1),0)+1","v":"2021-04-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,F8,1),0)+1","v":"2021-05-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,G8,1),0)+1","v":"2021-06-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,H8,1),0)+1","v":"2021-07-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,I8,1),0)+1","v":"2021-08-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,J8,1),0)+1","v":"2021-09-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,K8,1),0)+1","v":"2021-10-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,L8,1),0)+1","v":"2021-11-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,M8,1),0)+1","v":"2021-12-01"},{"$f":"EOMONTH(DATE(VBA!$C$6,N8,1),0)+1","v":"2022-01-01"}]
[]
[]
[]
[]
[null,null,"Mois",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"TOTAL \"&VBA!C6","v":"TOTAL 2021"}]
[null,"Projet",1,2,3,4,5,6,7,8,9,10,11,12,"En heures","En %"]
[{"$f":"COLUMN(Timesheet!F8)","v":6},{"$f":"Timesheet!F8","v":"MONTANA"},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!C$2,Timesheet!$F:$F)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!D$2,Timesheet!$F:$F)-SUM($C9:C9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!E$2,Timesheet!$F:$F)-SUM($C9:D9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!F$2,Timesheet!$F:$F)-SUM($C9:E9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!G$2,Timesheet!$F:$F)-SUM($C9:F9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!H$2,Timesheet!$F:$F)-SUM($C9:G9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!I$2,Timesheet!$F:$F)-SUM($C9:H9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!J$2,Timesheet!$F:$F)-SUM($C9:I9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!K$2,Timesheet!$F:$F)-SUM($C9:J9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!L$2,Timesheet!$F:$F)-SUM($C9:K9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!M$2,Timesheet!$F:$F)-SUM($C9:L9)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!N$2,Timesheet!$F:$F)-SUM($C9:M9)","v":0},{"$f":"IF(B9=\"\",\"\",SUM(C9:N9))","v":0},{"$f":"IFERROR(O9/$O$16,\"\")","v":0}]
[{"$f":"+A9+1","v":7},{"$f":"OFFSET(Timesheet!$F$8,0,A10-$A$9)","v":"VEGA"},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!C$2,Timesheet!$G:$G)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!D$2,Timesheet!$G:$G)-SUM($C10:C10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!E$2,Timesheet!$G:$G)-SUM($C10:D10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!F$2,Timesheet!$G:$G)-SUM($C10:E10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!G$2,Timesheet!$G:$G)-SUM($C10:F10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!H$2,Timesheet!$G:$G)-SUM($C10:G10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!I$2,Timesheet!$G:$G)-SUM($C10:H10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!J$2,Timesheet!$G:$G)-SUM($C10:I10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!K$2,Timesheet!$G:$G)-SUM($C10:J10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!L$2,Timesheet!$G:$G)-SUM($C10:K10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!M$2,Timesheet!$G:$G)-SUM($C10:L10)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!N$2,Timesheet!$G:$G)-SUM($C10:M10)","v":0},{"$f":"IF(B10=\"\",\"\",SUM(C10:N10))","v":0},0]
[{"$f":"+A10+1","v":8},{"$f":"OFFSET(Timesheet!$F$8,0,A11-$A$9)","v":"GTT"},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!C$2,Timesheet!$H:$H)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!D$2,Timesheet!$H:$H)-SUM($C11:C11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!E$2,Timesheet!$H:$H)-SUM($C11:D11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!F$2,Timesheet!$H:$H)-SUM($C11:E11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!G$2,Timesheet!$H:$H)-SUM($C11:F11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!H$2,Timesheet!$H:$H)-SUM($C11:G11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!I$2,Timesheet!$H:$H)-SUM($C11:H11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!J$2,Timesheet!$H:$H)-SUM($C11:I11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!K$2,Timesheet!$H:$H)-SUM($C11:J11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!L$2,Timesheet!$H:$H)-SUM($C11:K11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!M$2,Timesheet!$H:$H)-SUM($C11:L11)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!N$2,Timesheet!$H:$H)-SUM($C11:M11)","v":0},0,0]
[{"$f":"COLUMN(Timesheet!I8)","v":9},{"$f":"OFFSET(Timesheet!$F$8,0,A12-$A$9)","v":"Autres projets / Vie Série"},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!C$2,Timesheet!$I:$I)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!D$2,Timesheet!$I:$I)-SUM($C12:C12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!E$2,Timesheet!$I:$I)-SUM($C12:D12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!F$2,Timesheet!$I:$I)-SUM($C12:E12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!G$2,Timesheet!$I:$I)-SUM($C12:F12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!H$2,Timesheet!$I:$I)-SUM($C12:G12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!I$2,Timesheet!$I:$I)-SUM($C12:H12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!J$2,Timesheet!$I:$I)-SUM($C12:I12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!K$2,Timesheet!$I:$I)-SUM($C12:J12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!L$2,Timesheet!$I:$I)-SUM($C12:K12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!M$2,Timesheet!$I:$I)-SUM($C12:L12)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!N$2,Timesheet!$I:$I)-SUM($C12:M12)","v":0},0,0]
[null,{"$f":"Timesheet!J8","v":"Non projet"},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!C$2,Timesheet!$J:$J)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!D$2,Timesheet!$J:$J)-SUM($C13:C13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!E$2,Timesheet!$J:$J)-SUM($C13:D13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!F$2,Timesheet!$J:$J)-SUM($C13:E13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!G$2,Timesheet!$J:$J)-SUM($C13:F13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!H$2,Timesheet!$J:$J)-SUM($C13:G13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!I$2,Timesheet!$J:$J)-SUM($C13:H13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!J$2,Timesheet!$J:$J)-SUM($C13:I13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!K$2,Timesheet!$J:$J)-SUM($C13:J13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!L$2,Timesheet!$J:$J)-SUM($C13:K13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!M$2,Timesheet!$J:$J)-SUM($C13:L13)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!N$2,Timesheet!$J:$J)-SUM($C13:M13)","v":0},{"$f":"IF(B13=\"\",\"\",SUM(C13:N13))","v":0},0]
[null,{"$f":"Timesheet!K8","v":"Absence"},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!C$2,Timesheet!$K:$K)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!D$2,Timesheet!$K:$K)-SUM($C14:C14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!E$2,Timesheet!$K:$K)-SUM($C14:D14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!F$2,Timesheet!$K:$K)-SUM($C14:E14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!G$2,Timesheet!$K:$K)-SUM($C14:F14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!H$2,Timesheet!$K:$K)-SUM($C14:G14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!I$2,Timesheet!$K:$K)-SUM($C14:H14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!J$2,Timesheet!$K:$K)-SUM($C14:I14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!K$2,Timesheet!$K:$K)-SUM($C14:J14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!L$2,Timesheet!$K:$K)-SUM($C14:K14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!M$2,Timesheet!$K:$K)-SUM($C14:L14)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!N$2,Timesheet!$K:$K)-SUM($C14:M14)","v":0},{"$f":"IF(B14=\"\",\"\",SUM(C14:N14))","v":0},0]
[null,{"$f":"Timesheet!N8","v":"Non Alloué"},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!C$2,Timesheet!$N:$N)","v":8},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!D$2,Timesheet!$N:$N)-SUM($C15:C15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!E$2,Timesheet!$N:$N)-SUM($C15:D15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!F$2,Timesheet!$N:$N)-SUM($C15:E15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!G$2,Timesheet!$N:$N)-SUM($C15:F15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!H$2,Timesheet!$N:$N)-SUM($C15:G15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!I$2,Timesheet!$N:$N)-SUM($C15:H15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!J$2,Timesheet!$N:$N)-SUM($C15:I15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!K$2,Timesheet!$N:$N)-SUM($C15:J15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!L$2,Timesheet!$N:$N)-SUM($C15:K15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!M$2,Timesheet!$N:$N)-SUM($C15:L15)","v":0},{"$f":"SUMIF(Timesheet!$C:$C,\"<\"&MyTime!N$2,Timesheet!$N:$N)-SUM($C15:M15)","v":0},8,1]
[null,"TOTAL HEURES",{"$f":"SUM(C9:C15)","v":8},{"$f":"SUM(D9:D15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C16:N16)","v":8},1]

{"sheet":"Projets","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NOP","Non projet","Vie_Serie",{"$f":"E3","v":2021}]
[null,"ABS","Absence","Autres",{"$f":"VBA!C6","v":2021}]
[null,"NOA","Non Alloué","Erreur",{"$f":"E3","v":2021},null,null,null,null,"Type"]
[null,null,null,null,null,null,null,null,null,"Montana"]
[null,null,null,null,null,null,null,null,null,"CIR"]
[null,"Code_Projet","Projet","Type","Annee","Project Leader",null,null,null,"NRE"]
[null,"2020_MONTANA","MONTANA","Montana",2020,"Benjamin Cros",null,null,null,"Vie_Serie"]
[null,"2020_VIESERIE","Autres projets / Vie Série","Vie_Serie",2020,"Aucun",null,null,null,"Autres"]
[null,"2020_ALAT_VEGA","VEGA","CIR1",2020,"Alexandre Henry",null,null,null,"Erreur"]
[null,"2020_AIRBUS_ORION","ORION","CIR2",2020,"Alexandre Henry"]
[null,"2020_Airbus_FlangesClamps","FLANGE & CLAMPS","CIR3",2020,"Maxime Duault"]
[null,"2020_GTT_LH1488001","GTT","CIR4",2020,"Mikael bosella"]
[null,"2020_ARIANE6","ARIANE 6","CIR5",2020,"Mikael bosella"]
[null,"2020_Prometheus","PROMETHEE","CIR6",2020,"Mourad Ben Abderrahmane"]
[null,"2020_Microturbo_PAC","PAC","CIR7",2020,"Mikael bosella"]

{"sheet":"WEEK","index":4,"n_rows":368,"n_cols":9,"rows_kept":368,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Jours","semaine","Jsemaine","TYPE",null,null,null,"FERIES"]
[null,"2021-01-01",0,"V",{"$f":"IF(ISNA(VLOOKUP(B4,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D4=\"S\",D4=\"D\"),\"OFF\",\"ON\"))","v":"OFF"},null,null,null,"2021-01-01"]
[null,{"$f":"+B4+1","v":"2021-01-02"},{"$f":"+C4","v":0},"S",{"$f":"IF(ISNA(VLOOKUP(B5,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D5=\"S\",D5=\"D\"),\"OFF\",\"ON\"))","v":"OFF"},null,null,null,"2021-04-05"]
[null,{"$f":"+B5+1","v":"2021-01-03"},{"$f":"+C5","v":0},"D","OFF",null,null,null,"2021-05-01"]
[null,"2021-01-04",{"$f":"+C6+1","v":1},"L",{"$f":"IF(ISNA(VLOOKUP(B7,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D7=\"S\",D7=\"D\"),\"OFF\",\"ON\"))","v":"ON"},null,null,null,"2021-05-08"]
[null,"2021-01-05",{"$f":"+C7","v":1},"M","ON",null,null,null,"2021-05-13"]
[null,"2021-01-06",{"$f":"+C8","v":1},"M","ON",null,null,null,"2021-05-24"]
[null,"2021-01-07",1,"J","ON",null,null,null,"2021-07-14"]
[null,"2021-01-08",1,"V","ON",null,null,null,"2021-08-15"]
[null,"2021-01-09",1,"S","OFF",null,null,null,"2021-11-01"]
[null,"2021-01-10",1,"D","OFF",null,null,null,"2021-11-11"]
[null,{"$f":"+B13+1","v":"2021-01-11"},{"$f":"+C13+1","v":2},"L","ON",null,null,null,"2021-12-25"]
[null,"2021-01-12",{"$f":"+C14","v":2},"M","ON"]
[null,"2021-01-13",{"$f":"+C15","v":2},"M","ON"]
[null,"2021-01-14",2,"J","ON"]
[null,"2021-01-15",2,"V","ON"]
[null,"2021-01-16",2,"S","OFF"]
[null,"2021-01-17",2,"D","OFF"]
[null,"2021-01-18",{"$f":"+C20+1","v":3},"L","ON"]
[null,"2021-01-19",{"$f":"+C21","v":3},"M","ON"]
[null,"2021-01-20",{"$f":"+C22","v":3},"M","ON"]
[null,"2021-01-21",3,"J","ON"]
[null,"2021-01-22",3,"V","ON"]
[null,"2021-01-23",3,"S","OFF"]
[null,"2021-01-24",3,"D","OFF"]
[null,"2021-01-25",{"$f":"+C27+1","v":4},"L","ON"]
[null,"2021-01-26",{"$f":"+C28","v":4},"M","ON"]
[null,"2021-01-27",{"$f":"+C29","v":4},"M","ON"]
[null,"2021-01-28",4,"J","ON"]
[null,"2021-01-29",4,"V","ON"]
[null,"2021-01-30",4,"S","OFF"]
[null,"2021-01-31",4,"D","OFF"]
[null,"2021-02-01",{"$f":"+C34+1","v":5},"L","ON"]
[null,"2021-02-02",{"$f":"+C35","v":5},"M","ON"]
[null,"2021-02-03",{"$f":"+C36","v":5},"M","ON"]
[null,"2021-02-04",5,"J","ON"]
[null,"2021-02-05",5,"V","ON"]
[null,"2021-02-06",5,"S","OFF"]
[null,"2021-02-07",5,"D","OFF"]
[null,"2021-02-08",{"$f":"+C41+1","v":6},"L","ON"]
[null,"2021-02-09",{"$f":"+C42","v":6},"M","ON"]
[null,"2021-02-10",{"$f":"+C43","v":6},"M","ON"]
[null,"2021-02-11",6,"J","ON"]
[null,"2021-02-12",6,"V","ON"]
[null,"2021-02-13",6,"S","OFF"]
[null,"2021-02-14",6,"D","OFF"]
[null,"2021-02-15",{"$f":"+C48+1","v":7},"L","ON"]
[null,"2021-02-16",{"$f":"+C49","v":7},"M","ON"]
[null,"2021-02-17",{"$f":"+C50","v":7},"M","ON"]
[null,"2021-02-18",7,"J","ON"]
[null,"2021-02-19",7,"V","ON"]
[null,"2021-02-20",7,"S","OFF"]
[null,"2021-02-21",7,"D","OFF"]
[null,"2021-02-22",{"$f":"+C55+1","v":8},"L","ON"]
[null,"2021-02-23",{"$f":"+C56","v":8},"M","ON"]
[null,"2021-02-24",{"$f":"+C57","v":8},"M","ON"]
[null,"2021-02-25",8,"J","ON"]
[null,"2021-02-26",8,"V","ON"]
[null,"2021-02-27",8,"S","OFF"]
[null,"2021-02-28",8,"D","OFF"]
[null,{"$f":"+B62+1","v":"2021-03-01"},{"$f":"+C62+1","v":9},"L","ON"]
[null,"2021-03-02",{"$f":"+C63","v":9},"M","ON"]
[null,"2021-03-03",{"$f":"+C64","v":9},"M","ON"]
[null,"2021-03-04",9,"J","ON"]
[null,"2021-03-05",9,"V","ON"]
[null,"2021-03-06",9,"S","OFF"]
[null,"2021-03-07",9,"D","OFF"]
[null,"2021-03-08",{"$f":"+C69+1","v":10},"L","ON"]
[null,"2021-03-09",{"$f":"+C70","v":10},"M",{"$f":"IF(ISNA(VLOOKUP(B71,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D71=\"S\",D71=\"D\"),\"OFF\",\"ON\"))","v":"ON"}]
[null,"2021-03-10",{"$f":"+C71","v":10},"M","ON"]
[null,"2021-03-11",10,"J","ON"]
[null,"2021-03-12",10,"V","ON"]
[null,"2021-03-13",10,"S","OFF"]
[null,"2021-03-14",10,"D","OFF"]
[null,"2021-03-15",{"$f":"+C76+1","v":11},"L","ON"]
[null,"2021-03-16",{"$f":"+C77","v":11},"M","ON"]
[null,"2021-03-17",{"$f":"+C78","v":11},"M","ON"]
[null,"2021-03-18",11,"J","ON"]
[null,"2021-03-19",11,"V","ON"]
[null,"2021-03-20",11,"S","OFF"]
[null,"2021-03-21",11,"D","OFF"]
[null,"2021-03-22",{"$f":"+C83+1","v":12},"L","ON"]
[null,"2021-03-23",{"$f":"+C84","v":12},"M","ON"]
[null,"2021-03-24",{"$f":"+C85","v":12},"M","ON"]
[null,"2021-03-25",12,"J","ON"]
[null,"2021-03-26",12,"V","ON"]
[null,"2021-03-27",12,"S","OFF"]
[null,"2021-03-28",12,"D","OFF"]
[null,"2021-03-29",{"$f":"+C90+1","v":13},"L","ON"]
[null,"2021-03-30",{"$f":"+C91","v":13},"M","ON"]
[null,"2021-03-31",{"$f":"+C92","v":13},"M","ON"]
[null,"2021-04-01",13,"J","ON"]
[null,"2021-04-02",13,"V","ON"]
[null,"2021-04-03",13,"S","OFF"]
[null,"2021-04-04",13,"D","OFF"]
[null,"2021-04-05",{"$f":"+C97+1","v":14},"L","OFF"]
[null,"2021-04-06",{"$f":"+C98","v":14},"M","ON"]
[null,"2021-04-07",{"$f":"+C99","v":14},"M","ON"]
[null,"2021-04-08",14,"J","ON"]
[null,"2021-04-09",14,"V","ON"]
[null,"2021-04-10",14,"S","OFF"]
[null,"2021-04-11",14,"D","OFF"]
[null,"2021-04-12",{"$f":"+C104+1","v":15},"L","ON"]
[null,"2021-04-13",{"$f":"+C105","v":15},"M","ON"]
[null,"2021-04-14",{"$f":"+C106","v":15},"M","ON"]
[null,"2021-04-15",15,"J","ON"]
[null,"2021-04-16",15,"V","ON"]
[null,"2021-04-17",15,"S","OFF"]
[null,"2021-04-18",15,"D","OFF"]
[null,"2021-04-19",{"$f":"+C111+1","v":16},"L","ON"]
[null,"2021-04-20",{"$f":"+C112","v":16},"M","ON"]
[null,"2021-04-21",{"$f":"+C113","v":16},"M","ON"]
[null,"2021-04-22",16,"J","ON"]
[null,"2021-04-23",16,"V","ON"]
[null,"2021-04-24",16,"S","OFF"]
[null,"2021-04-25",16,"D","OFF"]
[null,"2021-04-26",{"$f":"+C118+1","v":17},"L","ON"]
[null,"2021-04-27",{"$f":"+C119","v":17},"M","ON"]
[null,"2021-04-28",{"$f":"+C120","v":17},"M","ON"]
[null,"2021-04-29",17,"J","ON"]
[null,"2021-04-30",17,"V","ON"]
[null,"2021-05-01",17,"S","OFF"]
[null,"2021-05-02",17,"D","OFF"]
[null,"2021-05-03",{"$f":"+C125+1","v":18},"L","ON"]
[null,{"$f":"+B126+1","v":"2021-05-04"},{"$f":"+C126","v":18},"M","ON"]
[null,"2021-05-05",{"$f":"+C127","v":18},"M","ON"]
[null,"2021-05-06",18,"J","ON"]
[null,"2021-05-07",18,"V","ON"]
[null,"2021-05-08",18,"S","OFF"]
[null,"2021-05-09",18,"D","OFF"]
[null,"2021-05-10",{"$f":"+C132+1","v":19},"L","ON"]
[null,"2021-05-11",{"$f":"+C133","v":19},"M","ON"]
[null,"2021-05-12",{"$f":"+C134","v":19},"M",{"$f":"IF(ISNA(VLOOKUP(B135,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D135=\"S\",D135=\"D\"),\"OFF\",\"ON\"))","v":"ON"}]
[null,"2021-05-13",19,"J","OFF"]
[null,"2021-05-14",19,"V","ON"]
[null,"2021-05-15",19,"S","OFF"]
[null,"2021-05-16",19,"D","OFF"]
[null,"2021-05-17",{"$f":"+C139+1","v":20},"L","ON"]
[null,"2021-05-18",{"$f":"+C140","v":20},"M","ON"]
[null,"2021-05-19",{"$f":"+C141","v":20},"M","ON"]
[null,"2021-05-20",20,"J","ON"]
[null,"2021-05-21",20,"V","ON"]
[null,"2021-05-22",20,"S","OFF"]
[null,"2021-05-23",20,"D","OFF"]
[null,"2021-05-24",{"$f":"+C146+1","v":21},"L","OFF"]
[null,"2021-05-25",{"$f":"+C147","v":21},"M","ON"]
[null,"2021-05-26",{"$f":"+C148","v":21},"M","ON"]
[null,"2021-05-27",21,"J","ON"]
[null,"2021-05-28",21,"V","ON"]
[null,"2021-05-29",21,"S","OFF"]
[null,"2021-05-30",21,"D","OFF"]
[null,"2021-05-31",{"$f":"+C153+1","v":22},"L","ON"]
[null,"2021-06-01",{"$f":"+C154","v":22},"M","ON"]
[null,"2021-06-02",{"$f":"+C155","v":22},"M","ON"]
[null,"2021-06-03",22,"J","ON"]
[null,"2021-06-04",22,"V","ON"]
[null,"2021-06-05",22,"S","OFF"]
[null,"2021-06-06",22,"D","OFF"]
[null,"2021-06-07",{"$f":"+C160+1","v":23},"L","ON"]
[null,"2021-06-08",{"$f":"+C161","v":23},"M","ON"]
[null,"2021-06-09",{"$f":"+C162","v":23},"M","ON"]
[null,"2021-06-10",23,"J","ON"]
[null,"2021-06-11",23,"V","ON"]
[null,"2021-06-12",23,"S","OFF"]
[null,"2021-06-13",23,"D","OFF"]
[null,"2021-06-14",{"$f":"+C167+1","v":24},"L","ON"]
[null,"2021-06-15",{"$f":"+C168","v":24},"M","ON"]
[null,"2021-06-16",{"$f":"+C169","v":24},"M","ON"]
[null,"2021-06-17",24,"J","ON"]
[null,"2021-06-18",24,"V","ON"]
[null,"2021-06-19",24,"S","OFF"]
[null,"2021-06-20",24,"D","OFF"]
[null,"2021-06-21",{"$f":"+C174+1","v":25},"L","ON"]
[null,"2021-06-22",{"$f":"+C175","v":25},"M","ON"]
[null,"2021-06-23",{"$f":"+C176","v":25},"M","ON"]
[null,"2021-06-24",25,"J","ON"]
[null,"2021-06-25",25,"V","ON"]
[null,"2021-06-26",25,"S","OFF"]
[null,"2021-06-27",25,"D","OFF"]
[null,"2021-06-28",{"$f":"+C181+1","v":26},"L","ON"]
[null,"2021-06-29",{"$f":"+C182","v":26},"M","ON"]
[null,"2021-06-30",{"$f":"+C183","v":26},"M","ON"]
[null,"2021-07-01",26,"J","ON"]
[null,"2021-07-02",26,"V","ON"]
[null,"2021-07-03",26,"S","OFF"]
[null,"2021-07-04",26,"D","OFF"]
[null,"2021-07-05",{"$f":"+C188+1","v":27},"L","ON"]
[null,"2021-07-06",{"$f":"+C189","v":27},"M","ON"]
[null,{"$f":"+B190+1","v":"2021-07-07"},{"$f":"+C190","v":27},"M","ON"]
[null,"2021-07-08",27,"J","ON"]
[null,"2021-07-09",27,"V","ON"]
[null,"2021-07-10",27,"S","OFF"]
[null,"2021-07-11",27,"D","OFF"]
[null,"2021-07-12",{"$f":"+C195+1","v":28},"L","ON"]
[null,"2021-07-13",{"$f":"+C196","v":28},"M","ON"]
[null,"2021-07-14",{"$f":"+C197","v":28},"M","OFF"]
[null,"2021-07-15",28,"J",{"$f":"IF(ISNA(VLOOKUP(B199,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D199=\"S\",D199=\"D\"),\"OFF\",\"ON\"))","v":"ON"}]
[null,"2021-07-16",28,"V","ON"]
[null,"2021-07-17",28,"S","OFF"]
[null,"2021-07-18",28,"D","OFF"]
[null,"2021-07-19",{"$f":"+C202+1","v":29},"L","ON"]
[null,"2021-07-20",{"$f":"+C203","v":29},"M","ON"]
[null,"2021-07-21",{"$f":"+C204","v":29},"M","ON"]
[null,"2021-07-22",29,"J","ON"]
[null,"2021-07-23",29,"V","ON"]
[null,"2021-07-24",29,"S","OFF"]
[null,"2021-07-25",29,"D","OFF"]
[null,"2021-07-26",{"$f":"+C209+1","v":30},"L","ON"]
[null,"2021-07-27",{"$f":"+C210","v":30},"M","ON"]
[null,"2021-07-28",{"$f":"+C211","v":30},"M","ON"]
[null,"2021-07-29",30,"J","ON"]
[null,"2021-07-30",30,"V","ON"]
[null,"2021-07-31",30,"S","OFF"]
[null,"2021-08-01",30,"D","OFF"]
[null,"2021-08-02",{"$f":"+C216+1","v":31},"L","ON"]
[null,"2021-08-03",{"$f":"+C217","v":31},"M","ON"]
[null,"2021-08-04",{"$f":"+C218","v":31},"M","ON"]
[null,"2021-08-05",31,"J","ON"]
[null,"2021-08-06",31,"V","ON"]
[null,"2021-08-07",31,"S","OFF"]
[null,"2021-08-08",31,"D","OFF"]
[null,"2021-08-09",{"$f":"+C223+1","v":32},"L","ON"]
[null,"2021-08-10",{"$f":"+C224","v":32},"M","ON"]
[null,"2021-08-11",{"$f":"+C225","v":32},"M","ON"]
[null,"2021-08-12",32,"J","ON"]
[null,"2021-08-13",32,"V","ON"]
[null,"2021-08-14",32,"S","OFF"]
[null,"2021-08-15",32,"D","OFF"]
[null,"2021-08-16",{"$f":"+C230+1","v":33},"L","ON"]
[null,"2021-08-17",{"$f":"+C231","v":33},"M","ON"]
[null,"2021-08-18",{"$f":"+C232","v":33},"M","ON"]
[null,"2021-08-19",33,"J","ON"]
[null,"2021-08-20",33,"V","ON"]
[null,"2021-08-21",33,"S","OFF"]
[null,"2021-08-22",33,"D","OFF"]
[null,"2021-08-23",{"$f":"+C237+1","v":34},"L","ON"]
[null,"2021-08-24",{"$f":"+C238","v":34},"M","ON"]
[null,"2021-08-25",{"$f":"+C239","v":34},"M","ON"]
[null,"2021-08-26",34,"J","ON"]
[null,"2021-08-27",34,"V","ON"]
[null,"2021-08-28",34,"S","OFF"]
[null,"2021-08-29",34,"D","OFF"]
[null,"2021-08-30",{"$f":"+C244+1","v":35},"L","ON"]
[null,"2021-08-31",{"$f":"+C245","v":35},"M","ON"]
[null,"2021-09-01",{"$f":"+C246","v":35},"M","ON"]
[null,"2021-09-02",35,"J","ON"]
[null,"2021-09-03",35,"V","ON"]
[null,"2021-09-04",35,"S","OFF"]
[null,"2021-09-05",35,"D","OFF"]
[null,"2021-09-06",{"$f":"+C251+1","v":36},"L","ON"]
[null,"2021-09-07",{"$f":"+C252","v":36},"M","ON"]
[null,"2021-09-08",{"$f":"+C253","v":36},"M","ON"]
[null,{"$f":"+B254+1","v":"2021-09-09"},36,"J","ON"]
[null,"2021-09-10",36,"V","ON"]
[null,"2021-09-11",36,"S","OFF"]
[null,"2021-09-12",36,"D","OFF"]
[null,"2021-09-13",{"$f":"+C258+1","v":37},"L","ON"]
[null,"2021-09-14",{"$f":"+C259","v":37},"M","ON"]
[null,"2021-09-15",{"$f":"+C260","v":37},"M","ON"]
[null,"2021-09-16",37,"J","ON"]
[null,"2021-09-17",37,"V",{"$f":"IF(ISNA(VLOOKUP(B263,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D263=\"S\",D263=\"D\"),\"OFF\",\"ON\"))","v":"ON"}]
[null,"2021-09-18",37,"S","OFF"]
[null,"2021-09-19",37,"D","OFF"]
[null,"2021-09-20",{"$f":"+C265+1","v":38},"L","ON"]
[null,"2021-09-21",{"$f":"+C266","v":38},"M","ON"]
[null,"2021-09-22",{"$f":"+C267","v":38},"M","ON"]
[null,"2021-09-23",38,"J","ON"]
[null,"2021-09-24",38,"V","ON"]
[null,"2021-09-25",38,"S","OFF"]
[null,"2021-09-26",38,"D","OFF"]
[null,"2021-09-27",{"$f":"+C272+1","v":39},"L","ON"]
[null,"2021-09-28",{"$f":"+C273","v":39},"M","ON"]
[null,"2021-09-29",{"$f":"+C274","v":39},"M","ON"]
[null,"2021-09-30",39,"J","ON"]
[null,"2021-10-01",39,"V","ON"]
[null,"2021-10-02",39,"S","OFF"]
[null,"2021-10-03",39,"D","OFF"]
[null,"2021-10-04",{"$f":"+C279+1","v":40},"L","ON"]
[null,"2021-10-05",{"$f":"+C280","v":40},"M","ON"]
[null,"2021-10-06",{"$f":"+C281","v":40},"M","ON"]
[null,"2021-10-07",40,"J","ON"]
[null,"2021-10-08",40,"V","ON"]
[null,"2021-10-09",40,"S","OFF"]
[null,"2021-10-10",40,"D","OFF"]
[null,"2021-10-11",{"$f":"+C286+1","v":41},"L","ON"]
[null,"2021-10-12",{"$f":"+C287","v":41},"M","ON"]
[null,"2021-10-13",{"$f":"+C288","v":41},"M","ON"]
[null,"2021-10-14",41,"J","ON"]
[null,"2021-10-15",41,"V","ON"]
[null,"2021-10-16",41,"S","OFF"]
[null,"2021-10-17",41,"D","OFF"]
[null,"2021-10-18",{"$f":"+C293+1","v":42},"L","ON"]
[null,"2021-10-19",{"$f":"+C294","v":42},"M","ON"]
[null,"2021-10-20",{"$f":"+C295","v":42},"M","ON"]
[null,"2021-10-21",42,"J","ON"]
[null,"2021-10-22",42,"V","ON"]
[null,"2021-10-23",42,"S","OFF"]
[null,"2021-10-24",42,"D","OFF"]
[null,"2021-10-25",{"$f":"+C300+1","v":43},"L","ON"]
[null,"2021-10-26",{"$f":"+C301","v":43},"M","ON"]
[null,"2021-10-27",{"$f":"+C302","v":43},"M","ON"]
[null,"2021-10-28",43,"J","ON"]
[null,"2021-10-29",43,"V","ON"]
[null,"2021-10-30",43,"S","OFF"]
[null,"2021-10-31",43,"D","OFF"]
[null,"2021-11-01",{"$f":"+C307+1","v":44},"L","OFF"]
[null,"2021-11-02",{"$f":"+C308","v":44},"M","ON"]
[null,"2021-11-03",{"$f":"+C309","v":44},"M","ON"]
[null,"2021-11-04",44,"J","ON"]
[null,"2021-11-05",44,"V","ON"]
[null,"2021-11-06",44,"S","OFF"]
[null,"2021-11-07",44,"D","OFF"]
[null,"2021-11-08",{"$f":"+C314+1","v":45},"L","ON"]
[null,"2021-11-09",{"$f":"+C315","v":45},"M","ON"]
[null,"2021-11-10",{"$f":"+C316","v":45},"M","ON"]
[null,"2021-11-11",45,"J","OFF"]
[null,{"$f":"+B318+1","v":"2021-11-12"},45,"V","ON"]
[null,"2021-11-13",45,"S","OFF"]
[null,"2021-11-14",45,"D","OFF"]
[null,"2021-11-15",{"$f":"+C321+1","v":46},"L","ON"]
[null,"2021-11-16",{"$f":"+C322","v":46},"M","ON"]
[null,"2021-11-17",{"$f":"+C323","v":46},"M","ON"]
[null,"2021-11-18",46,"J","ON"]
[null,"2021-11-19",46,"V","ON"]
[null,"2021-11-20",46,"S",{"$f":"IF(ISNA(VLOOKUP(B327,I:I,1,FALSE))=FALSE,\"OFF\",IF(OR(D327=\"S\",D327=\"D\"),\"OFF\",\"ON\"))","v":"OFF"}]
[null,"2021-11-21",46,"D","OFF"]
[null,"2021-11-22",{"$f":"+C328+1","v":47},"L","ON"]
[null,"2021-11-23",{"$f":"+C329","v":47},"M","ON"]
[null,"2021-11-24",{"$f":"+C330","v":47},"M","ON"]
[null,"2021-11-25",47,"J","ON"]
[null,"2021-11-26",47,"V","ON"]
[null,"2021-11-27",47,"S","OFF"]
[null,"2021-11-28",47,"D","OFF"]
[null,"2021-11-29",{"$f":"+C335+1","v":48},"L","ON"]
[null,"2021-11-30",{"$f":"+C336","v":48},"M","ON"]
[null,"2021-12-01",{"$f":"+C337","v":48},"M","ON"]
[null,"2021-12-02",48,"J","ON"]
[null,"2021-12-03",48,"V","ON"]
[null,"2021-12-04",48,"S","OFF"]
[null,"2021-12-05",48,"D","OFF"]
[null,"2021-12-06",{"$f":"+C342+1","v":49},"L","ON"]
[null,"2021-12-07",{"$f":"+C343","v":49},"M","ON"]
[null,"2021-12-08",{"$f":"+C344","v":49},"M","ON"]
[null,"2021-12-09",49,"J","ON"]
[null,"2021-12-10",49,"V","ON"]
[null,"2021-12-11",49,"S","OFF"]
[null,"2021-12-12",49,"D","OFF"]
[null,{"$f":"+B349+1","v":"2021-12-13"},{"$f":"+C349+1","v":50},"L","ON"]
[null,"2021-12-14",{"$f":"+C350","v":50},"M","ON"]
[null,"2021-12-15",{"$f":"+C351","v":50},"M","ON"]
[null,"2021-12-16",50,"J","ON"]
[null,"2021-12-17",50,"V","ON"]
[null,"2021-12-18",50,"S","OFF"]
[null,"2021-12-19",50,"D","OFF"]
[null,"2021-12-20",{"$f":"+C356+1","v":51},"L","ON"]
[null,"2021-12-21",{"$f":"+C357","v":51},"M","ON"]
[null,"2021-12-22",{"$f":"+C358","v":51},"M","ON"]
[null,"2021-12-23",51,"J","ON"]
[null,"2021-12-24",51,"V","ON"]
[null,"2021-12-25",51,"S","OFF"]
[null,"2021-12-26",51,"D","OFF"]
[null,"2021-12-27",{"$f":"+C363+1","v":52},"L","ON"]
[null,"2021-12-28",{"$f":"+C364","v":52},"M","ON"]
[null,"2021-12-29",{"$f":"+C365","v":52},"M","ON"]
[null,"2021-12-30",52,"J","ON"]
[null,"2021-12-31",52,"V","ON"]

{"sheet":"VBA","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"MID(CELL(\"adresse\",Timesheet!$D$4),SEARCH(\"]\",CELL(\"adresse\",Timesheet!$D$4),1)+1,SEARCH(\"!\",CELL(\"adresse\",Timesheet!$D$4),1)-SEARCH(\"]\",CELL(\"adresse\",Timesheet!$D$4),1)-1)","v":"Timesheet"}]
[null,{"$f":"MID(CELL(\"adresse\",Absence!$D$4),SEARCH(\"]\",CELL(\"adresse\",Absence!$D$4),1)+1,SEARCH(\"!\",CELL(\"adresse\",Absence!$D$4),1)-SEARCH(\"]\",CELL(\"adresse\",Absence!$D$4),1)-1)","v":"Absence"}]
[null,{"$f":"MID(CELL(\"adresse\",MyTime!$D$4),SEARCH(\"]\",CELL(\"adresse\",MyTime!$D$4),1)+1,SEARCH(\"!\",CELL(\"adresse\",MyTime!$D$4),1)-SEARCH(\"]\",CELL(\"adresse\",MyTime!$D$4),1)-1)","v":"MyTime"}]
[null,"Matricule:",{"$f":"MID(CELL(\"adresse\",Timesheet!D6),2,3)","v":"MAT"}]
[null,"Année:",{"$f":"MID(CELL(\"adresse\",Timesheet!D6),6,4)*1","v":2021}]
[null,"Première ligne:",{"$f":"ROW(Timesheet!C9)+1","v":10}]
[null,"Dernière ligne:",{"$f":"COUNTA(Timesheet!C:C)+C7","v":267}]
[null,"Nb jours > 7h",{"$f":"Timesheet!O6","v":0},null,"Nb jours OFF",{"$f":"COUNTIF(Timesheet!B:B,\"OFF\")","v":0}]
[null,"Nb jours non alloué",{"$f":"Timesheet!N6","v":1}]
[null,"Nb projets:",{"$f":"COUNTIF(Timesheet!E6:L6,\">0\")-COUNTIF(Timesheet!J6:L6,\">0\")","v":0}]
[null,"Col_Start",{"$f":"COLUMN(Timesheet!E9)+1","v":6},{"$f":"COLUMN(Timesheet!I8)","v":9}]
[null,"Col_End",{"$f":"C12+C11-1","v":5},{"$f":"COLUMN(Timesheet!K8)","v":11},{"$f":"COLUMN(Timesheet!O8)","v":15},{"$f":"COLUMN(Timesheet!W8)","v":23},{"$f":"COLUMN(Timesheet!I8)","v":9}]
[null,null,null,null,null,{"$f":"ROW(MyTime!A12)-1","v":11}]
[]
[null,"Projet S_Line",{"$f":"ROW(Timesheet!F4)","v":4}]
[null,"Projet E_Line",{"$f":"ROW(Timesheet!F5)","v":5}]
[]
[null,"Aujourdhui:",{"$f":"IF(D19=\"\",TODAY(),D19)","v":"2021-01-04"},null,null,null,{"$f":"DATE(C6,1,1)","v":"2021-01-01"}]
[]
[]
[]
[null,{"$f":"\"Timesheet_Projets_\"&C6&\".xlsm\"","v":"Timesheet_Projets_2021.xlsm"}]
[null,{"$f":"\"\\\\SRVDATA\\Userscal\\public\\Transfert\\Timesheet_Projets_\"&C6&\".xlsm\"","v":"\\\\SRVDATA\\Userscal\\public\\Transfert\\Timesheet_Projets_2021.xlsm"}]
[null,{"$f":"MID(CELL(\"adresse\",Projets!$D$4),SEARCH(\"]\",CELL(\"adresse\",Projets!$D$4),1)+1,SEARCH(\"!\",CELL(\"adresse\",Projets!$D$4),1)-SEARCH(\"]\",CELL(\"adresse\",Projets!$D$4),1)-1)","v":"Projets"},{"$f":"COLUMN(Projets!B7)","v":2},{"$f":"COLUMN(Projets!F7)","v":6},{"$f":"ROW(Projets!B7)+1","v":8},{"$f":"COUNTA(Projets!B:B)+E25-5","v":16}]

{"sheet":"Absence","index":6,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"CODING","Duree","Duree_Normalise"]
[null,"329-43831",7,7]
[null,"329-43833",7,7]
[null,"329-43868",7,7]
[null,"329-43889",3.5,3.5]
[null,"329-43924",7,7]
[null,"329-43931",7,7]
[null,"329-43934",7,7]
[null,"329-43944",7,7]
[null,"329-43945",7,7]
[null,"329-43952",7,7]
[null,"329-43959",7,7]
[null,"329-43969",7,7]
[null,"329-43970",7,7]
[null,"329-43971",7,7]
[null,"329-43972",7,7]
[null,"329-43973",7,7]
[null,"329-43983",7,7]
[null,"329-44008",7,7]
[null,"329-44025",7,7]
[null,"329-44026",7,7]
[null,"329-44035",3.5,3.5]
[null,"329-44046",7,7]
[null,"329-44047",7,7]
[null,"329-44048",7,7]
[null,"329-44049",7,7]
[null,"329-44050",7,7]
[null,"329-44053",7,7]
[null,"329-44054",7,7]
[null,"329-44055",7,7]
[null,"329-44056",7,7]
[null,"329-44057",7,7]
[null,"329-44060",7,7]
[null,"329-44061",7,7]
[null,"329-44062",7,7]
[null,"329-44063",7,7]
[null,"329-44064",7,7]
[null,"329-44088",7,7]
[null,"329-44095",7,7]
[null,"329-44106",7,7]
[null,"329-44113",7,7]
[null,"329-44120",7,7]
[null,"329-44123",7,7]
[null,"329-44124",7,7]
[null,"329-44125",7,7]
[null,"329-44126",7,7]
[null,"329-44127",7,7]
[null,"329-44131",3.5,3.5]
[null,"329-44134",7,7]
[null,"329-44141",7,7]
[null,"329-44146",7,7]
[null,"329-44148",7,7]
[null,"329-44155",7,7]
[null,"329-44158",7,7]

{"sheet":"Log","index":7,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"V1.0","Lancement Timesheet"]

{"sheet":"Abs","index":8,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["DAT","NOMPRE","MATRI","MOTIF","VALORIS","MOTYPE","MOTIDUR","IEICATEGOR","CODING","Duree","Duree_Normalise"]