{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Explication du tableau","Batîment 1","Batîment 2","Batîment 3","Total","Graphique 1","Graphique 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Explication du tableau","index":0,"n_rows":57,"n_cols":17,"rows_kept":57,"cut":false,"hidden":false,"merged":[[37,5,42,11],[56,6,58,11],[44,5,44,11],[46,5,48,5],[46,6,48,11],[51,5,53,5],[51,6,53,11],[56,5,58,5]]}
[]
[]
[{"$nulls":4},"Tableau de Bord de consommation d'électricité (TBE)",{"$nulls":11},"Date de mise à jour : XXX"]
[]
[{"$nulls":7},"Organisme XY"]
{"$rows_empty":30}
[{"$nulls":10},"\n\n"]
[]
[{"$nulls":5},"Le présent document sert de modèle pour l'introduction d'un tableau de bord. Il contient les rubriques de base nécessaires pour enregistrer la consommation d'énergie. À côté de cette fiche d'introduction, il y a trois fiches de registre exemplaires qui peuvent être remplies avec les données énergétiques de différentes branches. Le quatrième registre contient un résumé de la consommation totale. Ensuite, des graphiques peuvent être insérés pour donner un aperçu de la consommation. "]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Légende des couleurs de cellules"]
[]
[{"$nulls":6},"Les cellules jaunes requierent l'entrée de donnée de la part de l'utilisateur du TBE. Les valeurs actuelles dans ces cellules sont des valeurs fictives qui devront être remplacées par les données réelles de l'utilisateur du TBE. "]
[]
[]
[]
[]
[{"$nulls":6},"Les cellules grises sont celles des résultats d'analyse de données et par conséquent renferment des formules de calculs. Elles ne doivent pas être modifiées par l'utilisateur du TBE. "]
[]
[]
[]
[]
[{"$nulls":6},"Les cellules bleues contiennent des exemples de données pour montrer comment remplier et utiliser les données disponibles. Elles doivent être remplacées par des données réélles de la CU lors de l'utilisation du TBE"]

{"sheet":"Batîment 1","index":1,"n_rows":67,"n_cols":22,"rows_kept":67,"cut":false,"hidden":false,"merged":[[22,0,22,12],[47,0,47,12],[3,8,3,14],[3,15,3,21],[4,8,4,9],[4,11,4,14],[4,15,4,16],[4,18,4,21],[3,0,5,0],[3,1,3,7],[4,1,4,2],[4,4,4,7]]}
[]
[null,null,null,"Surface des bâtiments du site (m2)",null,null,1000]
[]
["ANNEE","Année de réference 1",{"$nulls":6},"Année de réference 2",{"$nulls":6},"Année de réference 3"]
[null,"Consommations",null,"Paramètres influents","Ratios ",null,null,null,"Consommations",null,"Paramètres influents","Ratios ",null,null,null,"Consommations",null,"Paramètres influents","Ratios "]
[null,"kWh","MAD","Nombre d'employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh","kWh","MAD","Nombre de employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh","kWh","MAD","Nombre d'employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh"]
["Janvier",1,1,1,{"$f":"C7/D7","v":1},{"$f":"C7/D7","v":1},{"$f":"B7/$G$2","v":1E-3},{"$f":"C7/B7","v":1},1,1,1,{"$f":"J7/K7","v":1},{"$f":"J7/K7","v":1},{"$f":"I7/$G$2","v":1E-3},{"$f":"J7/I7","v":1},1,1,1,{"$f":"Q7/R7","v":1},{"$f":"Q7/R7","v":1},{"$f":"P7/$G$2","v":1E-3},{"$f":"Q7/P7","v":1}]
["Février",1,1,1,{"$f":"C8/D8","v":1},{"$f":"C8/D8","v":1},1E-3,{"$f":"C8/B8","v":1},1,1,1,{"$f":"J8/K8","v":1},{"$f":"J8/K8","v":1},{"$f":"I8/$G$2","v":1E-3},{"$f":"J8/I8","v":1},1,1,1,{"$f":"Q8/R8","v":1},{"$f":"Q8/R8","v":1},{"$f":"P8/$G$2","v":1E-3},{"$f":"Q8/P8","v":1}]
["Mars",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Avril",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Mai",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Juin",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Juillet",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Août",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Septembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Octobre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Novembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Décembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Total",{"$f":"SUM(B7:B18)","v":12},{"$f":"SUM(C7:C18)","v":12},{"$f":"SUM(D7:D18)","v":12},1,1,1.2E-2,1,{"$f":"SUM(I7:I18)","v":12},{"$f":"SUM(J7:J18)","v":12},{"$f":"SUM(K7:K18)","v":12},1,1,1.2E-2,1,{"$f":"SUM(P7:P18)","v":12},{"$f":"SUM(Q7:Q18)","v":12},{"$f":"SUM(R7:R18)","v":12},1,1,1.2E-2,1]
[]
[]
[]
["Analyse des dépenses mensuelles en combustible "]
[]
["Type de combustible"]
[]
["Mois",2015,null,2016,null,2017,null,2018,null,2019,null,2020]
[null,"Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD"]
["Janvier",1,2,1,2,1,2,1,2,1,2,1,2]
["Février",1,2,1,2,1,2,1,2,1,2,1,2]
["Mars",1,2,1,2,1,2,1,2,1,2,1,2]
["Avril",1,2,1,2,1,2,1,2,1,2,1,2]
["Mai",1,2,1,2,1,2,1,2,1,2,1,2]
["Juin",1,2,1,2,1,2,1,2,1,2,1,2]
["Juillet",1,2,1,2,1,2,1,2,1,2,1,2]
["Août",1,2,1,2,1,2,1,2,1,2,1,2]
["Septembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Octobre",1,2,1,2,1,2,1,2,1,2,1,2]
["Novembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Décembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Total",{"$f":"SUM(B29:B40)","v":12},24,12,24,12,24,12,24,12,24,12,24]
["Moyenne",{"$f":"AVERAGE(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
["Min",{"$f":"MIN(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
["Max",{"$f":"MAX(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
[]
[]
[]
["Analyse des dépenses mensuelles en eau"]
[]
["Mois",2015,null,2016,null,2017,null,2018,null,2019,null,2020]
[null,"Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD"]
["Janvier",2,3,2,3,2,3,2,3,2,3,2,3]
["Février",2,3,2,3,2,3,2,3,2,3,2,3]
["Mars",2,3,2,3,2,3,2,3,2,3,2,3]
["Avril",2,3,2,3,2,3,2,3,2,3,2,3]
["Mai",2,3,2,3,2,3,2,3,2,3,2,3]
["Juin",2,3,2,3,2,3,2,3,2,3,2,3]
["Juillet",2,3,2,3,2,3,2,3,2,3,2,3]
["Août",2,3,2,3,2,3,2,3,2,3,2,3]
["Septembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Octobre",2,3,2,3,2,3,2,3,2,3,2,3]
["Novembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Décembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Total",{"$f":"SUM(B52:B63)","v":24},36,24,36,24,36,24,36,24,36,24,36]
["Moyenne",{"$f":"AVERAGE(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]
["Min",{"$f":"MIN(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]
["Max",{"$f":"MAX(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]

{"sheet":"Batîment 2","index":2,"n_rows":67,"n_cols":22,"rows_kept":67,"cut":false,"hidden":false,"merged":[[3,15,3,21],[4,1,4,2],[4,4,4,7],[4,11,4,14],[4,15,4,16],[4,18,4,21],[22,0,22,12],[47,0,47,12],[4,8,4,9],[3,0,5,0],[3,1,3,7],[3,8,3,14]]}
[]
[null,null,null,"Surface des bâtiments du site (m2)",null,null,1000]
[]
["ANNEE","Année de réference 1",{"$nulls":6},"Année de réference 2",{"$nulls":6},"Année de réference 3"]
[null,"Consommations",null,"Paramètres influents","Ratios ",null,null,null,"Consommations",null,"Paramètres influents","Ratios ",null,null,null,"Consommations",null,"Paramètres influents","Ratios "]
[null,"kWh","MAD","Nombre de employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh","kWh","MAD","Nombre de employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh","kWh","MAD","Nombre de employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh"]
["Janvier",1,1,1,{"$f":"C7/D7","v":1},{"$f":"C7/D7","v":1},{"$f":"B7/$G$2","v":1E-3},{"$f":"C7/B7","v":1},1,1,1,{"$f":"J7/K7","v":1},{"$f":"J7/K7","v":1},{"$f":"I7/$G$2","v":1E-3},{"$f":"J7/I7","v":1},1,1,1,{"$f":"Q7/R7","v":1},{"$f":"Q7/R7","v":1},{"$f":"P7/$G$2","v":1E-3},{"$f":"Q7/P7","v":1}]
["Février",1,1,1,{"$f":"C8/D8","v":1},{"$f":"C8/D8","v":1},1E-3,{"$f":"C8/B8","v":1},1,1,1,{"$f":"J8/K8","v":1},{"$f":"J8/K8","v":1},{"$f":"I8/$G$2","v":1E-3},{"$f":"J8/I8","v":1},1,1,1,{"$f":"Q8/R8","v":1},{"$f":"Q8/R8","v":1},{"$f":"P8/$G$2","v":1E-3},{"$f":"Q8/P8","v":1}]
["Mars",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Avril",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Mai",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Juin",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Juillet",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Août",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Septembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Octobre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Novembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Décembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Total",{"$f":"SUM(B7:B18)","v":12},{"$f":"SUM(C7:C18)","v":12},{"$f":"SUM(D7:D18)","v":12},1,1,1.2E-2,1,{"$f":"SUM(I7:I18)","v":12},{"$f":"SUM(J7:J18)","v":12},{"$f":"SUM(K7:K18)","v":12},1,1,{"$f":"I19/$G$2","v":1.2E-2},1,{"$f":"SUM(P7:P18)","v":12},{"$f":"SUM(Q7:Q18)","v":12},{"$f":"SUM(R7:R18)","v":12},1,1,{"$f":"P19/$G$2","v":1.2E-2},1]
[]
[]
[]
["Analyse des dépenses mensuelles en combustible "]
[]
["Type de combustible"]
[]
["Mois",2015,null,2016,null,2017,null,2018,null,2019,null,2020]
[null,"Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD"]
["Janvier",1,2,1,2,1,2,1,2,1,2,1,2]
["Février",1,2,1,2,1,2,1,2,1,2,1,2]
["Mars",1,2,1,2,1,2,1,2,1,2,1,2]
["Avril",1,2,1,2,1,2,1,2,1,2,1,2]
["Mai",1,2,1,2,1,2,1,2,1,2,1,2]
["Juin",1,2,1,2,1,2,1,2,1,2,1,2]
["Juillet",1,2,1,2,1,2,1,2,1,2,1,2]
["Août",1,2,1,2,1,2,1,2,1,2,1,2]
["Septembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Octobre",1,2,1,2,1,2,1,2,1,2,1,2]
["Novembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Décembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Total",{"$f":"SUM(B29:B40)","v":12},24,12,24,12,24,12,24,12,24,12,24]
["Moyenne",{"$f":"AVERAGE(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
["Min",{"$f":"MIN(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
["Max",{"$f":"MAX(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
[]
[]
[]
["Analyse des dépenses mensuelles en eau"]
[]
["Mois",2015,null,2016,null,2017,null,2018,null,2019,null,2020]
[null,"Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD"]
["Janvier",2,3,2,3,2,3,2,3,2,3,2,3]
["Février",2,3,2,3,2,3,2,3,2,3,2,3]
["Mars",2,3,2,3,2,3,2,3,2,3,2,3]
["Avril",2,3,2,3,2,3,2,3,2,3,2,3]
["Mai",2,3,2,3,2,3,2,3,2,3,2,3]
["Juin",2,3,2,3,2,3,2,3,2,3,2,3]
["Juillet",2,3,2,3,2,3,2,3,2,3,2,3]
["Août",2,3,2,3,2,3,2,3,2,3,2,3]
["Septembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Octobre",2,3,2,3,2,3,2,3,2,3,2,3]
["Novembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Décembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Total",{"$f":"SUM(B52:B63)","v":24},36,24,36,24,36,24,36,24,36,24,36]
["Moyenne",{"$f":"AVERAGE(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]
["Min",{"$f":"MIN(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]
["Max",{"$f":"MAX(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]

{"sheet":"Batîment 3","index":3,"n_rows":67,"n_cols":22,"rows_kept":67,"cut":false,"hidden":false,"merged":[[47,0,47,12],[4,4,4,7],[4,11,4,14],[4,15,4,16],[4,18,4,21],[22,0,22,12],[4,8,4,9],[3,0,5,0],[3,1,3,7],[3,8,3,14],[3,15,3,21],[4,1,4,2]]}
[]
[null,null,null,"Surface des bâtiments du site (m2)",null,null,1000]
[]
["ANNEE","Année de réference 1",{"$nulls":6},"Année de réference 2",{"$nulls":6},"Année de réference 3"]
[null,"Consommations",null,"Paramètres influents","Ratios ",null,null,null,"Consommations",null,"Paramètres influents","Ratios ",null,null,null,"Consommations",null,"Paramètres influents","Ratios "]
[null,"kWh","MAD","Nombre de employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh","kWh","MAD","Nombre de employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh","kWh","MAD","Nombre de employés","kWh/employé","MAD/employé","kWh/m2","MAD/kWh"]
["Janvier",1,1,1,{"$f":"C7/D7","v":1},{"$f":"C7/D7","v":1},{"$f":"B7/$G$2","v":1E-3},{"$f":"C7/B7","v":1},1,1,1,{"$f":"J7/K7","v":1},{"$f":"J7/K7","v":1},{"$f":"I7/$G$2","v":1E-3},{"$f":"J7/I7","v":1},1,1,1,{"$f":"Q7/R7","v":1},{"$f":"Q7/R7","v":1},{"$f":"P7/$G$2","v":1E-3},{"$f":"Q7/P7","v":1}]
["Février",1,1,1,{"$f":"C8/D8","v":1},{"$f":"C8/D8","v":1},1E-3,{"$f":"C8/B8","v":1},1,1,1,{"$f":"J8/K8","v":1},{"$f":"J8/K8","v":1},{"$f":"I8/$G$2","v":1E-3},{"$f":"J8/I8","v":1},1,1,1,{"$f":"Q8/R8","v":1},{"$f":"Q8/R8","v":1},{"$f":"P8/$G$2","v":1E-3},{"$f":"Q8/P8","v":1}]
["Mars",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Avril",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Mai",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Juin",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Juillet",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Août",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Septembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Octobre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Novembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Décembre",1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1,1,1,1,1,1,1E-3,1]
["Total",{"$f":"SUM(B7:B18)","v":12},{"$f":"SUM(C7:C18)","v":12},{"$f":"SUM(D7:D18)","v":12},1,1,1.2E-2,1,{"$f":"SUM(I7:I18)","v":12},{"$f":"SUM(J7:J18)","v":12},{"$f":"SUM(K7:K18)","v":12},1,1,{"$f":"I19/$G$2","v":1.2E-2},1,{"$f":"SUM(P7:P18)","v":12},{"$f":"SUM(Q7:Q18)","v":12},{"$f":"SUM(R7:R18)","v":12},1,1,{"$f":"P19/$G$2","v":1.2E-2},1]
[]
[]
[]
["Analyse des dépenses mensuelles en combustible "]
[]
["Type de combustible"]
[]
["Mois",2015,null,2016,null,2017,null,2018,null,2019,null,2020]
[null,"Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD","Consommation en m3 ou litres","Dépenses en MAD"]
["Janvier",1,2,1,2,1,2,1,2,1,2,1,2]
["Février",1,2,1,2,1,2,1,2,1,2,1,2]
["Mars",1,2,1,2,1,2,1,2,1,2,1,2]
["Avril",1,2,1,2,1,2,1,2,1,2,1,2]
["Mai",1,2,1,2,1,2,1,2,1,2,1,2]
["Juin",1,2,1,2,1,2,1,2,1,2,1,2]
["Juillet",1,2,1,2,1,2,1,2,1,2,1,2]
["Août",1,2,1,2,1,2,1,2,1,2,1,2]
["Septembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Octobre",1,2,1,2,1,2,1,2,1,2,1,2]
["Novembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Décembre",1,2,1,2,1,2,1,2,1,2,1,2]
["Total",{"$f":"SUM(B29:B40)","v":12},24,12,24,12,24,12,24,12,24,12,24]
["Moyenne",{"$f":"AVERAGE(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
["Min",{"$f":"MIN(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
["Max",{"$f":"MAX(B29:B40)","v":1},2,1,2,1,2,1,2,1,2,1,2]
[]
[]
[]
["Analyse des dépenses mensuelles en eau"]
[]
["Mois",2015,null,2016,null,2017,null,2018,null,2019,null,2020]
[null,"Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD","Consommation en m3 ","Dépenses en MAD"]
["Janvier",2,3,2,3,2,3,2,3,2,3,2,3]
["Février",2,3,2,3,2,3,2,3,2,3,2,3]
["Mars",2,3,2,3,2,3,2,3,2,3,2,3]
["Avril",2,3,2,3,2,3,2,3,2,3,2,3]
["Mai",2,3,2,3,2,3,2,3,2,3,2,3]
["Juin",2,3,2,3,2,3,2,3,2,3,2,3]
["Juillet",2,3,2,3,2,3,2,3,2,3,2,3]
["Août",2,3,2,3,2,3,2,3,2,3,2,3]
["Septembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Octobre",2,3,2,3,2,3,2,3,2,3,2,3]
["Novembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Décembre",2,3,2,3,2,3,2,3,2,3,2,3]
["Total",{"$f":"SUM(B52:B63)","v":24},36,24,36,24,36,24,36,24,36,24,36]
["Moyenne",{"$f":"AVERAGE(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]
["Min",{"$f":"MIN(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]
["Max",{"$f":"MAX(B52:B63)","v":2},3,2,3,2,3,2,3,2,3,2,3]

{"sheet":"Total","index":4,"n_rows":86,"n_cols":19,"rows_kept":86,"cut":false,"hidden":false,"merged":[[62,9,62,12],[63,3,63,4],[63,5,64,5],[63,6,64,6],[63,7,63,8],[63,9,64,9],[63,10,64,10],[63,11,63,12],[62,0,64,0],[63,1,64,1],[63,2,64,2],[60,4,60,5],[62,1,62,4],[62,5,62,8],[32,4,32,5],[34,0,36,0],[35,1,36,1],[35,2,36,2],[6,15,6,18],[35,11,35,12],[35,7,35,8],[35,3,35,4],[34,1,34,4],[34,5,34,8],[34,9,34,12],[35,5,36,5],[35,6,36,6],[35,9,36,9],[35,10,36,10],[1,0,1,18],[5,0,7,0],[5,1,5,6],[5,7,5,12],[5,13,5,18],[6,1,7,1],[6,2,7,2],[6,3,6,6],[6,7,7,7],[6,8,7,8],[6,9,6,12],[6,13,7,13],[6,14,7,14],[3,8,3,9]]}
[]
["Bilan des consommations  Multi-sites"]
[]
[{"$nulls":8},"Electricité"]
[]
["Batîment",2018,{"$nulls":5},2019,{"$nulls":5},2020]
[null,"Consommation (kWh)","Dépense (MAD)","Ratio",null,null,null,"Consommation (kWh)","Dépense (MAD)","Ratio",null,null,null,"Consommation (kWh)","Dépense (MAD)","Ratio"]
[null,null,null,"kWh/résident","MAD/résident","kWh/m2","MAD/kWh",null,null,"kWh/résident","MAD/résident","kWh/m2","MAD/kWh",null,null,"kWh/résident","MAD/résident","kWh/m2","MAD/kWh"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[]
[]
[]
[{"$nulls":4},"Combustibles ",null,null,"Note","Mettre un tableau par type de combustible"]
[]
["Batîment",2018,null,null,null,2019,null,null,null,2020]
[null,"Consommation (m3)","Dépense (MAD)","Ratio",null,"Consommation (m3)","Dépense (MAD)","Ratio",null,"Consommation (m3)","Dépense (MAD)","Ratio"]
[null,null,null,"m3/résident","MAD/résident",null,null,"m3/résident","MAD/résident",null,null,"m3/résident","MAD/résident"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[]
[]
[{"$nulls":4},"Eau"]
[]
["Batîment",2018,null,null,null,2019,null,null,null,2020]
[null,"Consommation (m3)","Dépense (MAD)","Ratio",null,"Consommation (m3)","Dépense (MAD)","Ratio",null,"Consommation (m3)","Dépense (MAD)","Ratio"]
[null,null,null,"m3/résident","MAD/résident",null,null,"m3/résident","MAD/résident",null,null,"m3/résident","MAD/résident"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]

{"sheet":"Graphique 1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Graphique 2","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}