{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Modèle"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Modèle","index":0,"n_rows":69,"n_cols":97,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,2,71,3],[68,4,71,5],[68,6,71,7],[68,8,71,9],[42,2,42,9],[60,2,63,3],[60,4,63,5],[60,6,63,7],[60,8,63,9],[64,2,67,3],[64,4,67,5],[64,6,67,7],[64,8,67,9],[52,2,55,3],[52,4,55,5],[52,6,55,7],[52,8,55,9],[56,2,59,3],[56,4,59,5],[56,6,59,7],[56,8,59,9],[44,2,47,3],[44,4,47,5],[44,6,47,7],[44,8,47,9],[48,2,51,3],[48,4,51,5],[48,6,51,7],[48,8,51,9],[28,2,29,2],[10,2,11,2],[12,2,13,2],[14,2,15,2],[16,2,17,2],[26,2,27,2],[18,2,19,2],[20,2,21,2],[22,2,23,2],[24,2,25,2],[1,1,1,2],[2,2,3,2],[4,2,5,2],[6,2,7,2],[8,2,9,2],[56,1,59,1],[60,1,63,1],[64,1,67,1],[68,1,71,1],[44,1,47,1],[48,1,51,1],[52,1,55,1]]}
["2015-05-26",null,null,"Jean","Paul","Pierre","Alain","Michel","Louise","Marie","Jeanne","Nouveau",null,"Repas"]
[null,"fonction",null,null,null,null,null,null,null,"apprenti","apprenti","Nouveau",null,"11:30:00","12:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","15:00:00"]
[{"$f":"\"Semaine actuelle n° \"&INT(MOD(INT((A1-2)/7)+0.6,52+5/28))+1","v":"Semaine actuelle n° 22"},null,"matin","Repos","Repos","Repos",0.27083333333333298,0.375,"Repos",0.29166666666666702,"Repos",null,null,"18:45:00","19:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:30:00","15:30:00"]
[null,{"$f":"$A$1-WEEKDAY($A$1-1)+8","v":"2015-06-01"},null,"Repos","Repos","Repos",0.4375,0.66666666666666596,"Repos",0.45833333333333298,"Repos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01:00:00","16:00:00"]
[null,null,"soir","Repos","Repos","Repos","Repos","Repos","Repos",0.72916666666666663,"Repos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01:30:00","16:30:00"]
[null,null,null,"Repos","Repos","Repos","Repos","Repos","Repos",0.91666666666666696,"Repos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02:00:00","17:00:00"]
[null,null,"matin",0.33333333333333298,"Repos","Repos",0.41666666666666702,0.41666666666666702,0.41666666666666702,"Repos","Repos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02:30:00","17:30:00"]
[null,{"$f":"B4+1","v":"2015-06-02"},null,0.58333333333333304,"Repos","Repos",0.58333333333333304,0.58333333333333304,0.58333333333333304,"Repos","Repos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03:00:00","18:00:00"]
[null,null,"soir",0.75,0.75,"Congé payé",0.75,0.75,0.75,0.66666666666666696,0.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03:30:00","18:30:00"]
[null,null,null,0.91666666666666696,0.91666666666666696,"Congé payé",0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04:00:00","19:00:00"]
[null,null,"matin",0.375,0.375,"Congé payé","Repos","Repos","Repos",0.375,0.375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04:30:00","19:30:00"]
[null,{"$f":"B8+1","v":"2015-06-03"},null,0.58333333333333304,0.58333333333333304,"Congé payé","Repos","Repos","Repos",0.58333333333333304,0.58333333333333304,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05:00:00","20:00:00"]
[null,null,"soir",0.72916666666666663,0.72916666666666696,"Congé payé","Repos","Repos",0.66666666666666696,0.72916666666666663,0.72916666666666663,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05:30:00","20:30:00"]
[null,null,null,0.91666666666666696,0.91666666666666696,"Congé payé","Repos","Repos",0.95833333333333304,0.91666666666666696,0.91666666666666696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06:30:00","21:00:00"]
[null,null,"matin",0.41666666666666702,0.41666666666666702,0.41666666666666702,0.41666666666666702,0.41666666666666702,0.41666666666666702,"Repos",0.41666666666666702,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:00:00","21:30:00"]
[null,{"$f":"B12+1","v":"2015-06-04"},null,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,"Repos",0.58333333333333304,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:30:00","22:00:00"]
["Légende",null,"soir",0.75,0.75,0.75,0.75,0.75,0.75,"Repos",0.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:00:00","22:30:00"]
["Repos hebdomadaire",null,null,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,"Repos",0.91666666666666696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:30:00","23:00:00"]
["Récupération",null,"matin","Repos",0.375,0.375,0.375,0.375,0.375,0.375,0.375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:00:00","23:30:00"]
["Congé payé",{"$f":"B16+1","v":"2015-06-05"},null,"Repos",0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:30:00","Repos"]
["Ecole",null,"soir","Repos",0.72916666666666663,0.72916666666666663,0.72916666666666663,0.72916666666666663,0.72916666666666663,0.72916666666666663,0.72916666666666663,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:00:00","Congé payé"]
["Maladie","MARIAGE",null,"Repos",0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:30:00","Récupération"]
[null,null,"matin",0.375,0.41666666666666702,0.41666666666666702,0.41666666666666702,0.41666666666666702,0.41666666666666702,0.41666666666666702,0.41666666666666702,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:00:00","Maladie"]
[null,{"$f":"B20+1","v":"2015-06-06"},null,0.66666666666666596,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:30:00","Ecole"]
[null,null,"soir",0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:00:00"]
[null,"MARIAGE",null,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,0.91666666666666696,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:30:00"]
[null,null,"matin",0.375,0.375,0.375,0.375,0.375,0.375,"Repos",0.375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:00:00"]
[null,{"$f":"B24+1","v":"2015-06-07"},null,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,0.58333333333333304,"Repos",0.58333333333333304,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:30:00"]
[null,null,"soir","Repos","Repos","Repos","Repos","Repos","Repos","Repos","Repos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:00:00"]
[null,"MARIAGE",null,"Repos","Repos","Repos","Repos","Repos","Repos","Repos","Repos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:00:00"]
[null,"Total heures réelles",null,{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,D3:D30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,D3:D30,0))-(D37*\"0:30\")","v":1.625},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,E3:E30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,E3:E30,0))-(E37*\"0:30\")","v":1.6249999999999989},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,F3:F30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,F3:F30,0))-(F37*\"0:30\")","v":1.1249999999999993},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,G3:G30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,G3:G30,0))-(G37*\"0:30\")","v":1.5833333333333321},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,H3:H30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,H3:H30,0))-(H37*\"0:30\")","v":1.687499999999998},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,I3:I30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,I3:I30,0))-(I37*\"0:30\")","v":1.687499999999998},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,J3:J30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,J3:J30,0))-(J37*\"0:30\")","v":1.5624999999999993},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,K3:K30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,K3:K30,0))-(K37*\"0:30\")","v":1.6249999999999998},{"$f":"SUM(IF(MOD(ROW($3:$30),2)=0,L3:L30,0))-SUM(IF(MOD(ROW($3:$30),2)=1,L3:L30,0))-(L37*\"0:30\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:30:00"]
[null,"Total heures sup.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:00:00"]
[null,"Heures semaine dernière à récupérer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M32>39/24,M32-39/24,\"\")","v":""},null,null,"","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repos"]
[null,"Solde (à récupérer semaine suivante)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Congé payé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Récupération"]
[null,"Nombre de repas",null,{"$f":"SUMPRODUCT((D3:D30<>\"\")*(MOD(ROW($3:$30),2)=1)*(($N$2>=D3:D30)*($O$2<=D4:D31)+($N$3>=D3:D30)*($O$3<=D4:D31)))","v":9},{"$f":"SUMPRODUCT((E3:E30<>\"\")*(MOD(ROW($3:$30),2)=1)*(($N$2>=E3:E30)*($O$2<=E4:E31)+($N$3>=E3:E30)*($O$3<=E4:E31)))","v":10},7,9,10,10,8,10,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maladie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecole"]
[]
[null,"Signature"]
[]
[]
[null,null,"Présents"]
[null,null,"07:00:00","11:00:00","12:00:00","14:00:00","15:00:00","17:00:00","19:00:00","22:00:00"]
[null,{"$f":"B4","v":"2015-06-01"},{"$f":"SUMPRODUCT((C$44>=$D3:$L3)*(D$44<=$D4:$L4))","v":1},null,{"$f":"SUMPRODUCT((E$44>=$D3:$L3)*(F$44<=$D4:$L4))","v":1},null,{"$f":"SUMPRODUCT((G$44>=$D5:$L5)*(H$44<=$D6:$L6))","v":0},null,{"$f":"SUMPRODUCT((I$44>=$D5:$L5)*(J$44<=$D6:$L6))","v":1}]
[]
[]
[]
[null,{"$f":"B8","v":"2015-06-02"},{"$f":"SUMPRODUCT((C$44>=$D7:$L7)*(D$44<=$D8:$L8))","v":0},null,{"$f":"SUMPRODUCT((E$44>=$D7:$L7)*(F$44<=$D8:$L8))","v":4},null,{"$f":"SUMPRODUCT((G$44>=$D9:$L9)*(H$44<=$D10:$L10))","v":0},null,{"$f":"SUMPRODUCT((I$44>=$D9:$L9)*(J$44<=$D10:$L10))","v":7}]
[]
[]
[]
[null,{"$f":"B12","v":"2015-06-03"},{"$f":"SUMPRODUCT((C$44>=$D11:$L11)*(D$44<=$D12:$L12))","v":0},null,{"$f":"SUMPRODUCT((E$44>=$D11:$L11)*(F$44<=$D12:$L12))","v":4},null,{"$f":"SUMPRODUCT((G$44>=$D13:$L13)*(H$44<=$D14:$L14))","v":0},null,{"$f":"SUMPRODUCT((I$44>=$D13:$L13)*(J$44<=$D14:$L14))","v":5}]
[]
[]
[]
[null,{"$f":"B16","v":"2015-06-04"},{"$f":"SUMPRODUCT((C$44>=$D15:$L15)*(D$44<=$D16:$L16))","v":0},null,{"$f":"SUMPRODUCT((E$44>=$D15:$L15)*(F$44<=$D16:$L16))","v":7},null,{"$f":"SUMPRODUCT((G$44>=$D17:$L17)*(H$44<=$D18:$L18))","v":0},null,{"$f":"SUMPRODUCT((I$44>=$D17:$L17)*(J$44<=$D18:$L18))","v":7}]
[]
[]
[]
[null,{"$f":"B20","v":"2015-06-05"},{"$f":"SUMPRODUCT((C$44>=$D19:$L19)*(D$44<=$D20:$L20))","v":0},null,{"$f":"SUMPRODUCT((E$44>=$D19:$L19)*(F$44<=$D20:$L20))","v":7},null,{"$f":"SUMPRODUCT((G$44>=$D21:$L21)*(H$44<=$D22:$L22))","v":0},null,{"$f":"SUMPRODUCT((I$44>=$D21:$L21)*(J$44<=$D22:$L22))","v":7}]
[]
[]
[]
[null,{"$f":"B24","v":"2015-06-06"},{"$f":"SUMPRODUCT((C$44>=$D23:$L23)*(D$44<=$D24:$L24))","v":0},null,{"$f":"SUMPRODUCT((E$44>=$D23:$L23)*(F$44<=$D24:$L24))","v":8},null,{"$f":"SUMPRODUCT((G$44>=$D25:$L25)*(H$44<=$D26:$L26))","v":0},null,{"$f":"SUMPRODUCT((I$44>=$D25:$L25)*(J$44<=$D26:$L26))","v":8}]
[]
[]
[]
[null,{"$f":"B28","v":"2015-06-07"},{"$f":"SUMPRODUCT((C$44>=$D27:$L27)*(D$44<=$D28:$L28))","v":0},null,{"$f":"SUMPRODUCT((E$44>=$D27:$L27)*(F$44<=$D28:$L28))","v":7},null,{"$f":"SUMPRODUCT((G$44>=$D29:$L29)*(H$44<=$D30:$L30))","v":0},null,{"$f":"SUMPRODUCT((I$44>=$D29:$L29)*(J$44<=$D30:$L30))","v":0}]