{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Rapport_hygieniste","TCD_semestre_calcul","Cercles scolaires","Semestre scolaire","Saisie_Rapport_Hebdo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":1},"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":"Rapport_hygieniste","index":0,"n_rows":138,"n_cols":12,"rows_kept":138,"cut":false,"hidden":true,"merged":[[0,1,0,2],[2,1,2,2],[1,1,1,2]]}
["Rapport hygiéniste\n\n\n",{"$f":"TODAY()","v":"2018-04-22"},null,"Classes d'école","Horaire\ndu cours","Enseignant(e)","Nbre d'enfants Enf","Nbre d'enfants Prim","Total Nbre d'enf.","Nbre de classes","Salle \nou Classe"]
[]
["Hygiéniste :","Carole Steiner",null,null,null,null,"Enf","Prim","Total"]
[null,null,null,null,null,"Totaux",{"$f":"SUM(G6:G138)","v":1008},{"$f":"SUM(H6:H138)","v":2433},{"$f":"SUM(I6:I138)","v":3441},{"$f":"SUM(J6:J138)","v":112}]
["Dates","Cercle scolaire","Lieu du cours","Classes d'école","Horaire du cours","Enseignant(e)","Nbre d'enfants Enf","Nbre d'enfants Prim","Total Nbre d'enf.","Nbre de classes","Colonne2","Semestre"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,12,19,31,null,null,"Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,8,21,29,null,null,"Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,11,17,28,null,null,"Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,10,22,32,null,null,"Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,9,12,21,null,null,"Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,11,18,29,null,null,"Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,8,19,27,null,null,"Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,11,20,31,null,null,"Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,7,20,27,null,null,"Semestre1"]
["2018-04-01","Attalens/Granges",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-06-01","Bulle Léchère",null,null,null,null,7,18,25,null,null,"Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,11,18,29,1,"Classe","Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,11,20,31,1,"Classe","Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,7,20,27,1,"Classe","Semestre1"]
["2018-04-01","Attalens/Granges",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Léchère",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre1"]
["2018-06-01","Bulle Léchère",null,null,null,null,7,18,25,1,"Salle","Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,11,18,29,1,"Classe","Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,11,20,31,1,"Classe","Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,7,20,27,1,"Classe","Semestre1"]
["2018-04-01","Attalens/Granges",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-04-01","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-05-01","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-01","Bulle Léchère",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-03-12","Arconciel/Ependes/Le Mouret",null,null,null,null,11,18,29,1,"Classe","Semestre1"]
["2018-03-01","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre1"]
["2018-08-01","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre2"]
["2018-08-02","Attalens/Granges",null,null,null,null,11,20,31,1,"Classe","Semestre2"]
["2018-08-03","Attalens/Granges",null,null,null,null,7,20,27,1,"Classe","Semestre2"]
["2018-08-04","Attalens/Granges",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-05","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-06","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-07","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-08","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-09","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-10","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-11","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-12","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-13","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-14","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-15","Bulle Condémine",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-01","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre2"]
["2018-08-02","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre2"]
["2018-08-03","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre2"]
["2018-08-04","Bulle Léchère",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-05","Arconciel/Ependes/Le Mouret",null,null,null,null,11,18,29,1,"Classe","Semestre2"]
["2018-08-06","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre2"]
["2018-08-07","Attalens/Granges",null,null,null,null,11,20,31,1,"Classe","Semestre2"]
["2018-08-08","Attalens/Granges",null,null,null,null,7,20,27,1,"Classe","Semestre2"]
["2018-08-09","Attalens/Granges",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-10","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-11","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-12","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-13","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-14","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-15","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-16","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-17","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre2"]
["2018-08-18","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre2"]
["2018-08-19","Bulle Condémine",null,null,null,null,7,18,25,1,"Salle","Semestre2"]
["2018-06-01","Bulle Léchère",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-02","Arconciel/Ependes/Le Mouret",null,null,null,null,11,18,29,1,"Classe","Semestre1"]
["2018-06-03","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre1"]
["2018-06-04","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre1"]
["2018-06-05","Attalens/Granges",null,null,null,null,11,20,31,1,"Classe","Semestre1"]
["2018-06-06","Attalens/Granges",null,null,null,null,7,20,27,1,"Classe","Semestre1"]
["2018-06-07","Attalens/Granges",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-08","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-08-06","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-07","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-08","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-09","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-10","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-11","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-12","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-13","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-14","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-06-03","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre1"]
["2018-06-04","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe","Semestre1"]
["2018-06-05","Attalens/Granges",null,null,null,null,11,20,31,1,"Classe","Semestre1"]
["2018-06-06","Attalens/Granges",null,null,null,null,7,20,27,1,"Classe","Semestre1"]
["2018-06-07","Attalens/Granges",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-06-08","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre1"]
["2018-08-06","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-07","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-08","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-09","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-10","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-11","Bossonnens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-12","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-13","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]
["2018-08-14","Billens",null,null,null,null,7,18,25,1,"Classe","Semestre2"]

{"sheet":"TCD_semestre_calcul","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Valeurs"]
["Semestre","Cercle scolaire","Total du Nbre d'enfants Enf","Total du Nbre d'enfants Prim","Total des Nbre Enf et Prim","Total du Nbre des classes"]
["Semestre1","Arconciel/Ependes/Le Mouret",105,181,286,4]
[null,"Attalens/Granges",189,442,631,19]
[null,"Avry-sur-Matran",70,180,250,8]
[null,"Bulle Condémine",84,216,300,9]
[null,"Bossonnens",63,162,225,7]
[null,"Billens",84,216,300,9]
[null,"Bulle Léchère",35,90,125,4]
["Total Semestre1",null,630,1487,2117,60]
["Semestre2","Arconciel/Ependes/Le Mouret",11,18,29,1]
[null,"Attalens/Granges",66,154,220,8]
[null,"Avry-sur-Matran",84,216,300,12]
[null,"Bulle Condémine",49,126,175,7]
[null,"Bossonnens",77,198,275,11]
[null,"Billens",84,216,300,12]
[null,"Bulle Léchère",7,18,25,1]
["Total Semestre2",null,378,946,1324,52]
["Total général",null,1008,2433,3441,112]

{"sheet":"Cercles scolaires","index":2,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Cercle scolaire",null,null,"Salle-Classe"]
["ACER (Auboranges/Chapelle/Ecublens/Rue",null,null,"Salle"]
["Arconciel/Ependes/Le Mouret",null,null,"Classe"]
["Attalens/Granges"]
["Avry-sur-Matran"]
["Bas Intyamon"]
["Belfaux"]
["Billens"]
["Bossonnens"]
["Broc"]
["Bulle Condémine"]
["Bulle Léchère"]
["Bulle Tour-de-Trême"]
["Bulle Vudalla"]
["CENSG"]
["CESG"]
["CESLG"]
["Châtel-St-Denis Bourg"]
["Châtel-St-Denis Châteloise"]
["Châtel-St-Denis Lussy"]
["Châtel-St-Denis Misets"]
["Châtonnaye/Torny"]
["Corbières/Hauteville/Villarvolard"]
["CSER"]
["CSVV"]
["Gibloux"]
["Gibloux Corpataux/Rossens/Magnedens"]
["Gibloux Estavayer-le-Gibloux"]
["Gibloux Farvagny"]
["Gruyères"]
["Haut Intyamon"]
["Institut les Peupliers"]
["Institut St-Joseph"]
["La Brillaz"]
["La Jogne"]
["La Roche/Pont-la-Ville"]
["La Verrerie"]
["Le Flon"]
["Le Mouret"]
["Le Pâquier"]
["Les Buissonnets"]
["Marly"]
["Marly Cité"]
["Marly Grand-Pré"]
["Mézières"]
["Pont-en-Ogoz"]
["Remaufens"]
["Riaz"]
["Romon Ville"]
["Romont"]
["Romont Condémine"]
["Sâles"]
["Semsales"]
["Siviriez"]
["St-Martin"]
["Treyvaux"]
["Ursy"]
["Vaulruz"]
["Villars-sur-Glâne Rochettes"]
["Villars-sur-Glâne Villars-Vert"]
["Villaz-St-Pierre/La Folliaz"]
["Villorsonnens"]
["Vuadens"]
["Vuisternens-dt-Romont"]

{"sheet":"Semestre scolaire","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Premier semestre","Deuxième semestre"]
["2018-01-01","2018-08-23"]
["2018-07-06","2018-12-31"]

{"sheet":"Saisie_Rapport_Hebdo","index":4,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,2,2,4]]}
["Rapport hygiéniste\n\n\n","2018-03-19",null,"Classes d'école","Horaire\ndu cours","Enseignant(e)","Nbre d'enfants Enf","Nbre d'enfants Prim","Total Nbre d'enf.","Nbre de classes","Salle \nou Classe"]
[]
["Date :","2018-07-09",{"$f":"YEAR(B3)&\" - Rap_ Hebdo_ Sem._ No_ \"&WEEKNUM(B3)","v":"2018 - Rap_ Hebdo_ Sem._ No_ 28"},null,null,null,"Enf","Prim","Total"]
[null,null,null,null,null,"Totaux",{"$f":"SUM(G6:G39)","v":111},{"$f":"SUM(H6:H39)","v":276},{"$f":"SUM(I6:I39)","v":387},{"$f":"SUM(J6:J39)","v":15}]
["Dates","Cercle scolaire","Lieu du cours","Classes d'école","Horaire du cours","Enseignant(e)","Nbre d'enfants Enf","Nbre d'enfants Prim","Total Nbre d'enf.","Nbre de classes","Salle ou Classe","Semestre"]
["2018-06-03","Attalens/Granges",null,null,null,null,8,19,{"$f":"IF(SUM(G6:H6)>0,SUM(G6:H6),\"\")","v":27},1,"Classe",{"$f":"IF(A6>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre1"}]
["2018-06-04","Attalens/Granges",null,null,null,null,8,19,27,1,"Classe",{"$f":"IF(A7>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre1"}]
["2018-06-05","Attalens/Granges",null,null,null,null,11,20,31,1,"Classe",{"$f":"IF(A8>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre1"}]
["2018-06-06","Attalens/Granges",null,null,null,null,7,20,27,1,"Classe",{"$f":"IF(A9>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre1"}]
["2018-06-07","Attalens/Granges",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A10>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre1"}]
["2018-06-08","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A11>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre1"}]
["2018-08-06","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A12>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-07","Bossonnens",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A13>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-08","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A14>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-09","Avry-sur-Matran",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A15>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-10","Bossonnens",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A16>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-11","Bossonnens",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A17>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-12","Billens",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A18>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-13","Billens",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A19>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
["2018-08-14","Billens",null,null,null,null,7,18,25,1,"Classe",{"$f":"IF(A20>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":"Semestre2"}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A21>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A22>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A23>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A24>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A25>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A26>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A27>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A28>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A29>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A30>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A31>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A32>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A33>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A34>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A35>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A36>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A37>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A38>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(A39>0,IF(ToRH[[#This Row],[Dates]]<='Semestre scolaire'!$A$3,\"Semestre1\",\"Semestre2\"),\"\")","v":""}]