{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Présence Août 2014","Statistiques"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Présence Août 2014","index":0,"n_rows":17,"n_cols":43,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,22,4,31],[4,32,4,41],[4,14,4,21],[4,42,6,42],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,14,5,15],[1,3,1,7],[1,0,1,2],[5,16,5,17],[5,18,5,19],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,5,5],[4,4,4,13],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13]]}
[]
["Date du premier jour du séjour :",null,null,"2014-08-04"]
[]
[]
[null,null,null,null,"Semaine 1",null,null,null,null,null,null,null,null,null,"Semaine 2",null,null,null,null,null,null,null,"Semaine 3",null,null,null,null,null,null,null,null,null,"Semaine 4",null,null,null,null,null,null,null,null,null,"TOT"]
["NOM","Prénom","Date de naissance","Âge",4,null,5,null,6,null,7,null,8,null,11,null,12,null,13,null,14,null,18,null,19,null,20,null,21,null,22,null,25,null,26,null,27,null,28,null,29]
[null,null,null,null,"m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am","m","am"]
["NOM","Prénom","2000-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C8),DAY(C8))>D2,YEAR(D2)-YEAR(C8)-1,YEAR(D2)-YEAR(C8))","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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:AP8)","v":0}]
["NOM","Prénom","2005-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C9),DAY(C9))>D2,YEAR(D2)-YEAR(C9)-1,YEAR(D2)-YEAR(C9))","v":9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(E9:AP9)","v":0}]
["NOM","Prénom","2003-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C10),DAY(C10))>D2,YEAR(D2)-YEAR(C10)-1,YEAR(D2)-YEAR(C10))","v":11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(E10:AP10)","v":0}]
["NOM","Prénom","2009-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C11),DAY(C11))>D2,YEAR(D2)-YEAR(C11)-1,YEAR(D2)-YEAR(C11))","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(E11:AP11)","v":0}]
["NOM","Prénom","2010-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C12),DAY(C12))>D2,YEAR(D2)-YEAR(C12)-1,YEAR(D2)-YEAR(C12))","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(E12:AP12)","v":0}]
["NOM","Prénom","2006-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C13),DAY(C13))>D2,YEAR(D2)-YEAR(C13)-1,YEAR(D2)-YEAR(C13))","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(E13:AP13)","v":0}]
["NOM","Prénom","2004-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C14),DAY(C14))>D2,YEAR(D2)-YEAR(C14)-1,YEAR(D2)-YEAR(C14))","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(E14:AP14)","v":0}]
["NOM","Prénom","2002-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C15),DAY(C15))>D2,YEAR(D2)-YEAR(C15)-1,YEAR(D2)-YEAR(C15))","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(E15:AP15)","v":0}]
["NOM","Prénom","2001-01-01",{"$f":"IF(DATE(YEAR(D2),MONTH(C16),DAY(C16))>D2,YEAR(D2)-YEAR(C16)-1,YEAR(D2)-YEAR(C16))","v":13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOT",null,null,null,{"$f":"SUM(E14:E16)","v":0},{"$f":"SUM(F14:F16)","v":0},{"$f":"SUM(G14:G16)","v":0},{"$f":"SUM(H14:H16)","v":0},{"$f":"SUM(I14:I16)","v":0},{"$f":"SUM(J14:J16)","v":0},{"$f":"SUM(K14:K16)","v":0},{"$f":"SUM(L14:L16)","v":0},{"$f":"SUM(M14:M16)","v":0},{"$f":"SUM(N14:N16)","v":0},{"$f":"SUM(O14:O16)","v":0},{"$f":"SUM(P14:P16)","v":0},{"$f":"SUM(Q14:Q16)","v":0},{"$f":"SUM(R14:R16)","v":0},{"$f":"SUM(S14:S16)","v":0},{"$f":"SUM(T14:T16)","v":0},{"$f":"SUM(U14:U16)","v":0},{"$f":"SUM(V14:V16)","v":0},{"$f":"SUM(W14:W16)","v":0},{"$f":"SUM(X14:X16)","v":0},{"$f":"SUM(Y14:Y16)","v":0},{"$f":"SUM(Z14:Z16)","v":0},{"$f":"SUM(AA14:AA16)","v":0},{"$f":"SUM(AB14:AB16)","v":0},{"$f":"SUM(AC14:AC16)","v":0},{"$f":"SUM(AD14:AD16)","v":0},{"$f":"SUM(AE14:AE16)","v":0},{"$f":"SUM(AF14:AF16)","v":0},{"$f":"SUM(AG14:AG16)","v":0},{"$f":"SUM(AH14:AH16)","v":0},{"$f":"SUM(AI14:AI16)","v":0},{"$f":"SUM(AJ14:AJ16)","v":0},{"$f":"SUM(AK14:AK16)","v":0},{"$f":"SUM(AL14:AL16)","v":0},{"$f":"SUM(AM14:AM16)","v":0},{"$f":"SUM(AN14:AN16)","v":0},{"$f":"SUM(AO14:AO16)","v":0},{"$f":"SUM(AP14:AP16)","v":0}]

{"sheet":"Statistiques","index":1,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,0,49,1],[45,4,45,9],[46,4,46,9],[47,4,47,9],[48,4,48,9],[49,4,49,9],[39,0,43,1],[39,4,39,9],[40,4,40,9],[41,4,41,9],[42,4,42,9],[43,4,43,9],[1,0,4,9],[33,0,37,1],[33,4,33,9],[34,4,34,9],[35,4,35,9],[36,4,36,9],[37,4,37,9],[30,0,31,9],[12,0,16,1],[18,0,22,1],[6,0,10,1],[6,4,6,9],[7,4,7,9],[8,4,8,9],[9,4,9,9],[10,4,10,9],[12,4,12,9],[13,4,13,9],[14,4,14,9],[15,4,15,9],[16,4,16,9],[18,4,18,9],[19,4,19,9],[20,4,20,9],[21,4,21,9],[22,4,22,9],[24,0,28,1],[24,4,24,9],[25,4,25,9],[26,4,26,9],[27,4,27,9],[28,4,28,9]]}
[]
["Cette feuille est en lecture seule. \nAucune modification ne doit y être apportée. \nLes calculs se font automatiquements"]
[]
[]
[]
[]
["Moyennes :",null,"Semaine 1",{"$f":"AVERAGE('Présence Août 2014'!E17:N17)","v":0},"enfant(s) de moyenne par demi journée pour cette semaine"]
[null,null,"Semaine 2",{"$f":"AVERAGE('Présence Août 2014'!O17:V17)","v":0},"enfant(s) de moyenne par demi journée pour cette semaine"]
[null,null,"Semaine 3",{"$f":"AVERAGE('Présence Août 2014'!W17:AF17)","v":0},"enfant(s) de moyenne par demi journée pour cette semaine"]
[null,null,"Semaine 4",{"$f":"AVERAGE('Présence Août 2014'!AG17:AP17)","v":0},"enfant(s) de moyenne par demi journée pour cette semaine"]
[null,null,"Globale",{"$f":"AVERAGE(D7:D10)","v":0},"enfant(s) de moyenne par demi journée pour les quatre semaines"]
[]
["Fréquentation :\n(en demi-journée)",null,"Semaine 1",{"$f":"SUM('Présence Août 2014'!E17:N17)","v":0},"demi journée de fréquentation pour cette semaine"]
[null,null,"Semaine 2",{"$f":"SUM('Présence Août 2014'!O17:V17)","v":0},"demi journée de fréquentation pour cette semaine"]
[null,null,"Semaine 3",{"$f":"SUM('Présence Août 2014'!W17:AF17)","v":0},"demi journée de fréquentation pour cette semaine"]
[null,null,"Semaine 4",{"$f":"SUM('Présence Août 2014'!AG17:AP17)","v":0},"demi journée de fréquentation pour cette semaine"]
[null,null,"Globale",{"$f":"SUM(D13:D16)","v":0},"demi journées de fréquentation pour les quatre semaines"]
[]
["Fréquentation :\n(en jours)",null,"Semaine 1",{"$f":"D13/2","v":0},"journée(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 2",{"$f":"D14/2","v":0},"journée(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 3",{"$f":"D15/2","v":0},"journée(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 4",{"$f":"D16/2","v":0},"journée(s) de fréquentation pour cette semaine"]
[null,null,"Globale",{"$f":"SUM(D19:D22)","v":0},"journée(s) de fréquentation pour les quatre semaines"]
[]
["Fréquentation :\n(en heures)",null,"Semaine 1",{"$f":"D19*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 2",{"$f":"D20*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 3",{"$f":"D21*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 4",{"$f":"D22*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Globale",{"$f":"SUM(D25:D28)","v":0},"heure(s) de fréquentation pour les quatre semaines"]
[]
["Statistiques par tranche d'âge"]
[]
[]
["Fréquentation :\n(4-6 ans)",null,"Semaine 1",{"$f":"D25*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 2",{"$f":"D26*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 3",{"$f":"D27*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 4",{"$f":"D28*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Globale",{"$f":"SUM(D34:D37)","v":0},"heure(s) de fréquentation pour les quatre semaines"]
[]
["Fréquentation :\n(7-11 ans)",null,"Semaine 1",{"$f":"D34*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 2",{"$f":"D35*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 3",{"$f":"D36*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 4",{"$f":"D37*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Globale",{"$f":"SUM(D40:D43)","v":0},"heure(s) de fréquentation pour les quatre semaines"]
[]
["Fréquentation :\n(12-14 ans)",null,"Semaine 1",{"$f":"D40*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 2",{"$f":"D41*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 3",{"$f":"D42*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Semaine 4",{"$f":"D43*8","v":0},"heure(s) de fréquentation pour cette semaine"]
[null,null,"Globale",{"$f":"SUM(D46:D49)","v":0},"heure(s) de fréquentation pour les quatre semaines"]