{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["TP","Parametres","Accueil","Planning","Juin","Juillet","août","recap"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":7,"defined_names":55,"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":"TP","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Code HQ","NOM","Matin","Après-Midi","Journée","Fin de Contrat","CDI/CDD"]
[1245,"toto","","","Mercredi","2026-06-30","CDI"]
[null,null,"","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lundi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mardi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercredi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Jeudi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vendredi"]

{"sheet":"Parametres","index":1,"n_rows":77,"n_cols":14,"rows_kept":77,"cut":false,"hidden":false,"merged":[[5,1,5,2],[4,6,4,7],[19,6,19,8]]}
[]
["Congé",2016]
["TP"]
["Récup HV"]
["Formation",null,null,null,null,null,"Jours Fériés",null,null,"Mois",null,"Semaine",null,"Matin"]
["75CTE",null,null,null,"Année",null,"Jour de l'an",{"$f":"DATE(B2,1,1)","v":"2016-01-01"},null,"2016-01-01",null,"Lundi",null,"Après-midi"]
["PA60",null,null,null,2013,null,"Pâques",{"$f":"FLOOR(DATE(B2,5,DAY(MINUTE(B2/38)/2+56)),7)-34+7*(B2=2079)","v":"2016-03-27"},null,"2016-02-01",null,"Mardi",null,"Journée"]
["Maladie",null,null,null,2014,null,"Lundi de Pâques",{"$f":"H7+1","v":"2016-03-28"},null,"2016-03-01",null,"Mercredi"]
["RTT",null,null,null,2015,null,"Fête du travail",{"$f":"DATE(B2,5,1)","v":"2016-05-01"},null,"2016-04-01",null,"Jeudi"]
["Absent",null,null,null,2016,null,"Armistice 1945",{"$f":"DATE(B2,5,8)","v":"2016-05-08"},null,"2016-05-01",null,"Vendredi"]
["GD00",null,null,null,2017,null,"Ascension",{"$f":"H7+39","v":"2016-05-05"},null,"2016-06-01",null,"Samedi"]
["JMOB",null,null,null,2018,null,"Pentecôte",{"$f":"H7+49","v":"2016-05-15"},null,"2016-07-01",null,"Dimanche"]
["PONT",null,null,null,2019,null,"Lundi de Pentecôte",{"$f":"H12+1","v":"2016-05-16"},null,"2016-08-01"]
["GD50",null,null,null,2020,null,"Fête nationale",{"$f":"DATE(B2,7,14)","v":"2016-07-14"},null,"2016-09-01"]
["férier",null,null,null,2021,null,"Assomption",{"$f":"DATE(B2,8,15)","v":"2016-08-15"},null,"2016-10-01"]
["CPFR",null,null,null,2022,null,"Toussaint",{"$f":"DATE(B2,11,1)","v":"2016-11-01"},null,"2016-11-01"]
["CPAN",null,null,null,2023,null,"Armistice 1918",{"$f":"DATE(B2,11,11)","v":"2016-11-11"},null,"2016-12-01"]
[null,null,null,null,2024,null,"Noël",{"$f":"DATE(B2,12,25)","v":"2016-12-25"}]
[]
[null,null,null,null,null,null,"Temps Partiel"]
[null,null,null,null,"Code HQ","LISTE NOM","Matin","Après Midi","Journée"]
[null,null,null,null,1245,"toto",{"$f":"TP!C2","v":""},{"$f":"TP!D2","v":""},{"$f":"TP!E2","v":"Mercredi"}]
[null,null,null,null,null,null,{"$f":"TP!C3","v":""},{"$f":"TP!D3","v":""},{"$f":"TP!E3","v":""}]
[null,null,null,null,{"$f":"TP!A4","v":0},{"$f":"TP!B4","v":0},{"$f":"TP!C4","v":0},{"$f":"TP!D4","v":0},{"$f":"TP!E4","v":0}]
[null,null,null,null,{"$f":"TP!A5","v":0},{"$f":"TP!B5","v":0},{"$f":"TP!C5","v":0},{"$f":"TP!D5","v":0},{"$f":"TP!E5","v":0}]
[null,null,null,null,{"$f":"TP!A6","v":0},{"$f":"TP!B6","v":0},{"$f":"TP!C6","v":0},{"$f":"TP!D6","v":0},{"$f":"TP!E6","v":0}]
[null,null,null,null,{"$f":"TP!A6","v":0},{"$f":"TP!B6","v":0},{"$f":"TP!C6","v":0},{"$f":"TP!D6","v":0},{"$f":"TP!E6","v":0}]
[null,null,null,null,{"$f":"TP!A6","v":0},{"$f":"TP!B6","v":0},{"$f":"TP!C6","v":0},{"$f":"TP!D6","v":0},{"$f":"TP!E6","v":0}]
[null,null,null,null,{"$f":"TP!A7","v":0},{"$f":"TP!B7","v":0},{"$f":"TP!C7","v":0},{"$f":"TP!D7","v":0},{"$f":"TP!E7","v":0}]
[null,null,null,null,{"$f":"TP!A8","v":0},{"$f":"TP!B8","v":0},{"$f":"TP!C8","v":0},{"$f":"TP!D8","v":0},{"$f":"TP!E8","v":0}]
[null,null,null,null,{"$f":"TP!A9","v":0},{"$f":"TP!B9","v":0},{"$f":"TP!C9","v":0},{"$f":"TP!D9","v":0},{"$f":"TP!E9","v":0}]
[null,null,null,null,{"$f":"TP!A10","v":0},{"$f":"TP!B10","v":0},{"$f":"TP!C10","v":0},{"$f":"TP!D10","v":0},{"$f":"TP!E10","v":0}]
[null,null,null,null,{"$f":"TP!A11","v":0},{"$f":"TP!B11","v":0},{"$f":"TP!C11","v":0},{"$f":"TP!D11","v":0},{"$f":"TP!E11","v":0}]
[null,null,null,null,{"$f":"TP!A12","v":0},{"$f":"TP!B12","v":0},{"$f":"TP!C12","v":0},{"$f":"TP!D12","v":0},{"$f":"TP!E12","v":0}]
[null,null,null,null,{"$f":"TP!A13","v":0},{"$f":"TP!B13","v":0},{"$f":"TP!C13","v":0},{"$f":"TP!D13","v":0},{"$f":"TP!E13","v":0}]
[null,null,null,null,{"$f":"TP!A14","v":0},{"$f":"TP!B14","v":0},{"$f":"TP!C14","v":0},{"$f":"TP!D14","v":0},{"$f":"TP!E14","v":0}]
[null,null,null,null,{"$f":"TP!A15","v":0},{"$f":"TP!B15","v":0},{"$f":"TP!C15","v":0},{"$f":"TP!D15","v":0},{"$f":"TP!E15","v":0}]
[null,null,null,null,{"$f":"TP!A16","v":0},{"$f":"TP!B16","v":0},{"$f":"TP!C16","v":0},{"$f":"TP!D16","v":0},{"$f":"TP!E16","v":0}]
[null,null,null,null,{"$f":"TP!A17","v":0},{"$f":"TP!B17","v":0},{"$f":"TP!C17","v":0},{"$f":"TP!D17","v":0},{"$f":"TP!E17","v":0}]
[null,null,null,null,{"$f":"TP!A18","v":0},{"$f":"TP!B18","v":0},{"$f":"TP!C18","v":0},{"$f":"TP!D18","v":0},{"$f":"TP!E18","v":0}]
[null,null,null,null,{"$f":"TP!A19","v":0},{"$f":"TP!B19","v":0},{"$f":"TP!C19","v":0},{"$f":"TP!D19","v":0},{"$f":"TP!E19","v":0}]
[null,null,null,null,{"$f":"TP!A20","v":0},{"$f":"TP!B20","v":0},{"$f":"TP!C20","v":0},{"$f":"TP!D20","v":0},{"$f":"TP!E20","v":0}]
[null,null,null,null,{"$f":"TP!A21","v":0},{"$f":"TP!B21","v":0},{"$f":"TP!C21","v":0},{"$f":"TP!D21","v":0},{"$f":"TP!E21","v":0}]
[null,null,null,null,{"$f":"TP!A22","v":0},{"$f":"TP!B22","v":0},{"$f":"TP!C22","v":0},{"$f":"TP!D22","v":0},{"$f":"TP!E22","v":0}]
[null,null,null,null,{"$f":"TP!A23","v":0},{"$f":"TP!B23","v":0},{"$f":"TP!C23","v":0},{"$f":"TP!D23","v":0},{"$f":"TP!E23","v":0}]
[null,null,null,null,{"$f":"TP!A24","v":0},{"$f":"TP!B24","v":0},{"$f":"TP!C24","v":0},{"$f":"TP!D24","v":0},{"$f":"TP!E24","v":0}]
[null,null,null,null,{"$f":"TP!A25","v":0},{"$f":"TP!B25","v":0},{"$f":"TP!C25","v":0},{"$f":"TP!D25","v":0},{"$f":"TP!E25","v":0}]
[null,null,null,null,{"$f":"TP!A26","v":0},{"$f":"TP!B26","v":0},{"$f":"TP!C26","v":0},{"$f":"TP!D26","v":0},{"$f":"TP!E26","v":0}]
[null,null,null,null,{"$f":"TP!A27","v":0},{"$f":"TP!B27","v":0},{"$f":"TP!C27","v":0},{"$f":"TP!D27","v":0},{"$f":"TP!E27","v":0}]
[null,null,null,null,{"$f":"TP!A28","v":0},{"$f":"TP!B28","v":0},{"$f":"TP!C28","v":0},{"$f":"TP!D28","v":0},{"$f":"TP!E28","v":0}]
[null,null,null,null,{"$f":"TP!A29","v":0},{"$f":"TP!B29","v":0},{"$f":"TP!C29","v":0},{"$f":"TP!D29","v":0},{"$f":"TP!E29","v":0}]
[null,null,null,null,{"$f":"TP!A30","v":0},{"$f":"TP!B30","v":0},{"$f":"TP!C30","v":0},{"$f":"TP!D30","v":0},{"$f":"TP!E30","v":0}]
[null,null,null,null,{"$f":"TP!A31","v":0},{"$f":"TP!B31","v":0},{"$f":"TP!C31","v":0},{"$f":"TP!D31","v":0},{"$f":"TP!E31","v":0}]
[null,null,null,null,{"$f":"TP!A32","v":0},{"$f":"TP!B32","v":0},{"$f":"TP!C32","v":0},{"$f":"TP!D32","v":0},{"$f":"TP!E32","v":0}]
[null,null,null,null,{"$f":"TP!A33","v":0},{"$f":"TP!B33","v":0},{"$f":"TP!C33","v":0},{"$f":"TP!D33","v":0},{"$f":"TP!E33","v":0}]
[null,null,null,null,{"$f":"TP!A34","v":0},{"$f":"TP!B34","v":0},{"$f":"TP!C34","v":0},{"$f":"TP!D34","v":0},{"$f":"TP!E34","v":0}]
[null,null,null,null,{"$f":"TP!A35","v":0},{"$f":"TP!B35","v":0},{"$f":"TP!C35","v":0},{"$f":"TP!D35","v":0},{"$f":"TP!E35","v":0}]
[null,null,null,null,{"$f":"TP!A36","v":0},{"$f":"TP!B36","v":0},{"$f":"TP!C36","v":0},{"$f":"TP!D36","v":0},{"$f":"TP!E36","v":0}]
[null,null,null,null,{"$f":"TP!A37","v":0},{"$f":"TP!B37","v":0},{"$f":"TP!C37","v":0},{"$f":"TP!D37","v":0},{"$f":"TP!E37","v":0}]
[null,null,null,null,{"$f":"TP!A38","v":0},{"$f":"TP!B38","v":0},{"$f":"TP!C38","v":0},{"$f":"TP!D38","v":0},{"$f":"TP!E38","v":0}]
[null,null,null,null,{"$f":"TP!A39","v":0},{"$f":"TP!B39","v":0},{"$f":"TP!C39","v":0},{"$f":"TP!D39","v":0},{"$f":"TP!E39","v":0}]
[null,null,null,null,{"$f":"TP!A40","v":0},{"$f":"TP!B40","v":0},{"$f":"TP!C40","v":0},{"$f":"TP!D40","v":0},{"$f":"TP!E40","v":0}]
[null,null,null,null,{"$f":"TP!A41","v":0},{"$f":"TP!B41","v":0},{"$f":"TP!C41","v":0},{"$f":"TP!D41","v":0},{"$f":"TP!E41","v":0}]
[null,null,null,null,{"$f":"TP!A42","v":0},{"$f":"TP!B42","v":0},{"$f":"TP!C42","v":0},{"$f":"TP!D42","v":0},{"$f":"TP!E42","v":0}]
[null,null,null,null,{"$f":"TP!A43","v":0},{"$f":"TP!B43","v":0},{"$f":"TP!C43","v":0},{"$f":"TP!D43","v":0},{"$f":"TP!E43","v":0}]
[null,null,null,null,{"$f":"TP!A44","v":0},{"$f":"TP!B44","v":0},{"$f":"TP!C44","v":0},{"$f":"TP!D44","v":0},{"$f":"TP!E44","v":0}]
[null,null,null,null,{"$f":"TP!A45","v":0},{"$f":"TP!B45","v":0},{"$f":"TP!C45","v":0},{"$f":"TP!D45","v":0},{"$f":"TP!E45","v":0}]
[null,null,null,null,{"$f":"TP!A46","v":0},{"$f":"TP!B46","v":0},{"$f":"TP!C46","v":0},{"$f":"TP!D46","v":0},{"$f":"TP!E46","v":0}]
[null,null,null,null,{"$f":"TP!A47","v":0},{"$f":"TP!B47","v":0},{"$f":"TP!C47","v":0},{"$f":"TP!D47","v":0},{"$f":"TP!E47","v":0}]
[null,null,null,null,{"$f":"TP!A48","v":0},{"$f":"TP!B48","v":0},{"$f":"TP!C48","v":0},{"$f":"TP!D48","v":0},{"$f":"TP!E48","v":0}]
[null,null,null,null,{"$f":"TP!A49","v":0},{"$f":"TP!B49","v":0},{"$f":"TP!C49","v":0},{"$f":"TP!D49","v":0},{"$f":"TP!E49","v":0}]
[null,null,null,null,{"$f":"TP!A50","v":0},{"$f":"TP!B50","v":0},{"$f":"TP!C50","v":0},{"$f":"TP!D50","v":0},{"$f":"TP!E50","v":0}]
[null,null,null,null,{"$f":"TP!A51","v":0},{"$f":"TP!B51","v":0},{"$f":"TP!C51","v":0},{"$f":"TP!D51","v":0},{"$f":"TP!E51","v":0}]
[null,null,null,null,{"$f":"TP!A52","v":0},{"$f":"TP!B52","v":0},{"$f":"TP!C52","v":0},{"$f":"TP!D52","v":0},{"$f":"TP!E52","v":0}]
[null,null,null,null,{"$f":"TP!A53","v":0},{"$f":"TP!B53","v":0},{"$f":"TP!C53","v":0},{"$f":"TP!D53","v":0},{"$f":"TP!E53","v":0}]
[null,null,null,null,{"$f":"TP!A54","v":0},{"$f":"TP!B54","v":0},{"$f":"TP!C54","v":0},{"$f":"TP!D54","v":0},{"$f":"TP!E54","v":0}]
[null,null,null,null,{"$f":"TP!A55","v":0},{"$f":"TP!B55","v":0},{"$f":"TP!C55","v":0},{"$f":"TP!D55","v":0},{"$f":"TP!E55","v":0}]

{"sheet":"Accueil","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,4,22,9],[27,5,27,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Planning  2016                  "]

{"sheet":"Planning","index":3,"n_rows":40,"n_cols":33,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,7,0,19],[1,7,2,19],[9,0,10,0],[9,1,10,1],[9,2,10,2],[11,1,12,1],[11,2,12,2],[13,1,14,1],[13,2,14,2],[15,1,16,1],[15,2,16,2],[17,1,18,1],[17,2,18,2],[29,2,30,2],[19,1,20,1],[19,2,20,2],[21,1,22,1],[21,2,22,2],[23,1,24,1],[23,2,24,2],[37,1,38,1],[37,2,38,2],[39,1,40,1],[39,2,40,2],[11,0,40,0],[31,1,32,1],[31,2,32,2],[33,1,34,1],[33,2,34,2],[35,1,36,1],[35,2,36,2],[25,1,26,1],[25,2,26,2],[27,1,28,1],[27,2,28,2],[29,1,30,1]]}
[null,null,"2016-02-01"]
[null,null,null,"FERIER",null,null,null,{"$f":"C1","v":"2016-02-01"}]
[]
[]
[]
[]
[]
[]
[]
["Service","Code HQ","Nom Prénom",{"$f":"IF(MONTH(WORKDAY(Planning!S_Mois-1,COLUMN(A:A)))=MONTH(Planning!S_Mois),WORKDAY(Planning!S_Mois-1,COLUMN(A:A)),\"\")","v":"2016-02-01"},{"$f":"IF(MONTH(WORKDAY($H$2-1,COLUMN(B:B)))=MONTH($H$2),WORKDAY($H$2-1,COLUMN(B:B)),\"\")","v":"2016-02-02"},"2016-02-03","2016-02-04","2016-02-05","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-29",{"$f":"IF(MONTH(WORKDAY($H$2-1,COLUMN(V:V)))=MONTH($H$2),WORKDAY($H$2-1,COLUMN(V:V)),\"\")","v":""},{"$f":"IF(MONTH(WORKDAY($H$2-1,COLUMN(W:W)))=MONTH($H$2),WORKDAY($H$2-1,COLUMN(W:W)),\"\")","v":""},{"$f":"recap!B2","v":"RTT"},{"$f":"recap!C2","v":"Récup HV"},{"$f":"recap!D2","v":"Congé"},{"$f":"recap!E2","v":"JMOB"},{"$f":"recap!F2","v":"Maladie"},{"$f":"recap!G2","v":"GD00"},{"$f":"recap!H2","v":"Droit au ticket"}]
[null,null,null,"2016-02-01","2016-02-02","2016-02-03","2016-02-04","2016-02-05","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-29","",""]
["RH","1245","toto",null,null,"TP",null,null,null,null,"TP",null,null,null,null,"TP",null,null,null,null,"TP"]
[null,null,null,null,null,"TP",null,null,null,null,"TP",null,null,null,null,"TP",null,null,null,null,"TP"]
[]
[]
[null,{"$f":"TP!A4","v":0},{"$f":"TP!B4","v":0}]
[]
[null,{"$f":"TP!A5","v":0},{"$f":"TP!B5","v":0}]
[]
[null,{"$f":"TP!A6","v":0},{"$f":"TP!B6","v":0}]
[]
[null,{"$f":"TP!A7","v":0},{"$f":"TP!B7","v":0}]
[]
[null,{"$f":"TP!A8","v":0},{"$f":"TP!B8","v":0}]
[]
[null,{"$f":"TP!A9","v":0},{"$f":"TP!B9","v":0}]
[]
[null,{"$f":"TP!A10","v":0},{"$f":"TP!B10","v":0}]
[]
[null,{"$f":"TP!A11","v":0},{"$f":"TP!B11","v":0}]
[]
[null,{"$f":"TP!A12","v":0},{"$f":"TP!B12","v":0}]
[]
[null,{"$f":"TP!A13","v":0},{"$f":"TP!B13","v":0}]
[]
[null,{"$f":"TP!A14","v":0},{"$f":"TP!B14","v":0}]
[]
[null,{"$f":"TP!A15","v":0},{"$f":"TP!B15","v":0}]
[]
[null,{"$f":"TP!A16","v":0},{"$f":"TP!B16","v":0}]

{"sheet":"Juin","index":4,"n_rows":40,"n_cols":33,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,7,2,19],[9,0,10,0],[9,1,10,1],[9,2,10,2],[11,0,40,0],[11,1,12,1],[11,2,12,2],[13,1,14,1],[13,2,14,2],[15,1,16,1],[15,2,16,2],[17,1,18,1],[17,2,18,2],[19,1,20,1],[19,2,20,2],[23,1,24,1],[23,2,24,2],[25,1,26,1],[25,2,26,2],[21,1,22,1],[21,2,22,2],[27,1,28,1],[27,2,28,2],[29,1,30,1],[29,2,30,2],[31,1,32,1],[31,2,32,2],[39,1,40,1],[39,2,40,2],[33,1,34,1],[33,2,34,2],[35,1,36,1],[35,2,36,2],[37,1,38,1],[37,2,38,2]]}
[]
[null,null,null,"FERIER",null,null,null,"2016-06-01"]
[]
[]
[]
[]
[]
[]
[]
["Service","Code HQ","Nom Prénom","2016-06-01","2016-06-02","2016-06-03","2016-06-06","2016-06-07","2016-06-08","2016-06-09","2016-06-10","2016-06-13","2016-06-14","2016-06-15","2016-06-16","2016-06-17","2016-06-20","2016-06-21","2016-06-22","2016-06-23","2016-06-24","2016-06-27","2016-06-28","2016-06-29","2016-06-30","",{"$f":"recap!B2","v":"RTT"},{"$f":"recap!C2","v":"Récup HV"},{"$f":"recap!D2","v":"Congé"},{"$f":"recap!E2","v":"JMOB"},{"$f":"recap!F2","v":"Maladie"},{"$f":"recap!G2","v":"GD00"},{"$f":"recap!H2","v":"Droit au ticket"}]
[null,null,null,"2016-06-01","2016-06-02","2016-06-03","2016-06-06","2016-06-07","2016-06-08","2016-06-09","2016-06-10","2016-06-13","2016-06-14","2016-06-15","2016-06-16","2016-06-17","2016-06-20","2016-06-21","2016-06-22","2016-06-23","2016-06-24","2016-06-27","2016-06-28","2016-06-29","2016-06-30",""]
["RH","1245","toto","TP",null,null,null,null,"TP",null,null,null,null,"TP","RTT","RTT","GD00",null,"TP",null,null,null,null,"TP"]
[null,null,null,"TP",null,null,null,null,"TP",null,null,null,null,"TP","RTT","RTT","GD00",null,"TP",null,null,null,null,"TP",null,null,{"$f":"COUNTIF($D$12:$Z$13,AA$10)/2","v":2},{"$f":"COUNTIF($D$12:$Z$13,AB$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AC$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AD$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AE$10)","v":0},{"$f":"COUNTIF($D$12:$Z$13,AF$10)/2","v":1},{"$f":"COUNTBLANK(D13:Y13)","v":14}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($D$14:$Z$15,AA$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AB$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AC$10)/2","v":0},{"$f":"COUNTIF($E$14:$AA$15,AD$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AE$10)","v":0},{"$f":"COUNTIF($D$14:$Z$15,AF$10)/2","v":0},{"$f":"COUNTBLANK(D15:Z15)","v":23}]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]
[]
[null,0,0]

{"sheet":"Juillet","index":5,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,0,40,0],[11,1,12,1],[11,2,12,2],[13,1,14,1],[13,2,14,2],[15,1,16,1],[15,2,16,2],[17,1,18,1],[17,2,18,2],[19,1,20,1],[19,2,20,2],[21,1,22,1],[21,2,22,2],[23,1,24,1],[23,2,24,2],[25,1,26,1],[0,7,0,19],[1,7,2,19],[9,0,10,0],[9,1,10,1],[9,2,10,2],[25,2,26,2],[27,1,28,1],[27,2,28,2],[29,1,30,1],[29,2,30,2],[31,1,32,1],[31,2,32,2],[39,1,40,1],[39,2,40,2],[33,1,34,1],[33,2,34,2],[35,1,36,1],[35,2,36,2],[37,1,38,1],[37,2,38,2]]}
[null,null,"2016-07-01"]
[null,null,null,"FERIER",null,null,null,{"$f":"C1","v":"2016-07-01"}]
[]
[]
[]
[]
[]
[]
[]
["Service","Code HQ","Nom Prénom","2016-07-01","2016-07-04","2016-07-05","2016-07-06","2016-07-07","2016-07-08","2016-07-11","2016-07-12","2016-07-13","2016-07-14","2016-07-15","2016-07-18","2016-07-19","2016-07-20","2016-07-21","2016-07-22","2016-07-25","2016-07-26","2016-07-27","2016-07-28","2016-07-29","","",{"$f":"recap!B2","v":"RTT"},{"$f":"recap!C2","v":"Récup HV"},{"$f":"recap!D2","v":"Congé"},{"$f":"recap!E2","v":"JMOB"},{"$f":"recap!F2","v":"Maladie"},{"$f":"recap!G2","v":"GD00"},{"$f":"recap!H2","v":"Droit au ticket"}]
[null,null,null,"2016-07-01","2016-07-04","2016-07-05","2016-07-06","2016-07-07","2016-07-08","2016-07-11","2016-07-12","2016-07-13","2016-07-14","2016-07-15","2016-07-18","2016-07-19","2016-07-20","2016-07-21","2016-07-22","2016-07-25","2016-07-26","2016-07-27","2016-07-28","2016-07-29","",""]
["RH","1245","toto",null,null,null,"TP",null,null,null,null,"TP","férier",null,null,null,"TP",null,null,null,null,"TP"]
[null,null,null,null,null,null,"TP",null,null,null,null,"TP","férier",null,null,null,"TP",null,null,null,null,"TP",null,null,null,null,{"$f":"COUNTIF($D$12:$Z$13,AA$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AB$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AC$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AD$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AE$10)","v":0},0,{"$f":"COUNTBLANK(D13:X13)","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($D$14:$Z$15,AA$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AB$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AC$10)/2","v":0},{"$f":"COUNTIF($E$14:$AA$15,AD$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AE$10)","v":0},{"$f":"COUNTIF($D$14:$Z$15,AF$10)","v":0},{"$f":"COUNTBLANK(D15:Z15)","v":22}]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,"férier"]

{"sheet":"août","index":6,"n_rows":41,"n_cols":33,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,0,40,0],[11,1,12,1],[11,2,12,2],[13,1,14,1],[13,2,14,2],[15,1,16,1],[15,2,16,2],[17,1,18,1],[17,2,18,2],[19,1,20,1],[19,2,20,2],[21,1,22,1],[21,2,22,2],[23,1,24,1],[23,2,24,2],[25,1,26,1],[0,7,0,19],[1,7,2,19],[9,0,10,0],[9,1,10,1],[9,2,10,2],[25,2,26,2],[27,1,28,1],[27,2,28,2],[29,1,30,1],[29,2,30,2],[31,1,32,1],[31,2,32,2],[39,1,40,1],[39,2,40,2],[33,1,34,1],[33,2,34,2],[35,1,36,1],[35,2,36,2],[37,1,38,1],[37,2,38,2]]}
[null,null,"2016-08-01"]
[null,null,null,"FERIER",null,null,null,{"$f":"C1","v":"2016-08-01"}]
[]
[]
[]
[]
[]
[]
[]
["Service","Code HQ","Nom Prénom","2016-08-01","2016-08-02","2016-08-03","2016-08-04","2016-08-05","2016-08-08","2016-08-09","2016-08-10","2016-08-11","2016-08-12","2016-08-15","2016-08-16","2016-08-17","2016-08-18","2016-08-19","2016-08-22","2016-08-23","2016-08-24","2016-08-25","2016-08-26","2016-08-29","2016-08-30","2016-08-31",{"$f":"recap!B2","v":"RTT"},{"$f":"recap!C2","v":"Récup HV"},{"$f":"recap!D2","v":"Congé"},{"$f":"recap!E2","v":"JMOB"},{"$f":"recap!F2","v":"Maladie"},{"$f":"recap!G2","v":"GD00"},{"$f":"recap!H2","v":"Droit au ticket"}]
[null,null,null,"2016-08-01","2016-08-02","2016-08-03","2016-08-04","2016-08-05","2016-08-08","2016-08-09","2016-08-10","2016-08-11","2016-08-12","2016-08-15","2016-08-16","2016-08-17","2016-08-18","2016-08-19","2016-08-22","2016-08-23","2016-08-24","2016-08-25","2016-08-26","2016-08-29","2016-08-30","2016-08-31"]
["Planning RH","1245","toto","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","férier","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé"]
[null,null,null,"Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","férier","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé","Congé",{"$f":"COUNTIF($D$12:$Z$13,AA$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AB$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AC$10)/2","v":22},{"$f":"COUNTIF($D$12:$Z$13,AD$10)/2","v":0},{"$f":"COUNTIF($D$12:$Z$13,AE$10)","v":0},0,{"$f":"COUNTBLANK(D13:Z13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($D$14:$Z$15,AA$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AB$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AC$10)/2","v":0},{"$f":"COUNTIF($E$14:$AA$15,AD$10)/2","v":0},{"$f":"COUNTIF($D$14:$Z$15,AE$10)","v":0},{"$f":"COUNTIF($D$14:$Z$15,AF$10)","v":0},{"$f":"COUNTBLANK(D15:Z15)","v":22}]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,"férier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"férier"]

{"sheet":"recap","index":7,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,{"$f":"Planning!C12","v":"toto"}]
[null,"RTT","Récup HV","Congé","JMOB","Maladie","GD00","Droit au ticket"]
["Janvier",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Février",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Mars",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Avril",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Mai",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Juin",{"$f":"Juin!AA$13","v":2},{"$f":"Juin!AB$13","v":0},{"$f":"Juin!AC$13","v":0},{"$f":"Juin!AD$13","v":0},{"$f":"Juin!AE$13","v":0},{"$f":"Juin!AF$13","v":1},{"$f":"Juin!AG$13","v":14}]
["Juillet",{"$f":"Juillet!AA$13","v":0},{"$f":"Juillet!AB$13","v":0},{"$f":"Juillet!AC$13","v":0},{"$f":"Juillet!AD$13","v":0},{"$f":"Juillet!AE$13","v":0},{"$f":"Juillet!AF$13","v":0},{"$f":"Juillet!AG$13","v":16}]
["Août",{"$f":"août!AA$13","v":0},{"$f":"août!AB$13","v":0},{"$f":"août!AC$13","v":22},{"$f":"août!AD$13","v":0},{"$f":"août!AE$13","v":0},{"$f":"août!AF$13","v":0},{"$f":"août!AG$13","v":0}]
["Septembre",{"$f":"[4]Septembre!AA$13","v":{"$error":"#REF!"}},{"$f":"[4]Septembre!AB$13","v":{"$error":"#REF!"}},{"$f":"[4]Septembre!AC$13","v":{"$error":"#REF!"}},{"$f":"[4]Septembre!AD$13","v":{"$error":"#REF!"}},{"$f":"[4]Septembre!AE$13","v":{"$error":"#REF!"}},{"$f":"[4]Septembre!AF$13","v":{"$error":"#REF!"}},{"$f":"[4]Septembre!AG$13","v":{"$error":"#REF!"}}]
["Octobre",{"$f":"[5]Octobre!AA$13","v":{"$error":"#REF!"}},{"$f":"[5]Octobre!AB$13","v":{"$error":"#REF!"}},{"$f":"[5]Octobre!AC$13","v":{"$error":"#REF!"}},{"$f":"[5]Octobre!AD$13","v":{"$error":"#REF!"}},{"$f":"[5]Octobre!AE$13","v":{"$error":"#REF!"}},{"$f":"[5]Octobre!AF$13","v":{"$error":"#REF!"}},{"$f":"[5]Octobre!AG$13","v":{"$error":"#REF!"}}]
["Novembre",{"$f":"[6]Novembre!AA$13","v":{"$error":"#REF!"}},{"$f":"[6]Novembre!AB$13","v":{"$error":"#REF!"}},{"$f":"[6]Novembre!AC$13","v":{"$error":"#REF!"}},{"$f":"[6]Novembre!AD$13","v":{"$error":"#REF!"}},{"$f":"[6]Novembre!AE$13","v":{"$error":"#REF!"}},{"$f":"[6]Novembre!AF$13","v":{"$error":"#REF!"}},{"$f":"[6]Novembre!AG$13","v":{"$error":"#REF!"}}]
["Décembre",{"$f":"[7]Décembre!AA$13","v":{"$error":"#REF!"}},{"$f":"[7]Décembre!AB$13","v":{"$error":"#REF!"}},{"$f":"[7]Décembre!AC$13","v":{"$error":"#REF!"}},{"$f":"[7]Décembre!AD$13","v":{"$error":"#REF!"}},{"$f":"[7]Décembre!AE$13","v":{"$error":"#REF!"}},{"$f":"[7]Décembre!AF$13","v":{"$error":"#REF!"}},{"$f":"[7]Décembre!AG$13","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"SUM(B3:B10)","v":{"$error":"#REF!"}},{"$f":"SUM(C3:C10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]