{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Canevas","Explications"],"not_rendered":{"macros":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Canevas","index":0,"n_rows":58,"n_cols":19,"rows_kept":58,"merged":[[2,3,2,4],[2,7,2,10],[2,11,2,14],[3,11,3,12],[4,11,4,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12]]}
["AUDIT UNIFIE",{"$nulls":10},"x"]
["Tableau des énergies consommées (valeurs positives)",{"$nulls":17},0]
[{"$nulls":3},"Fossiles",null,"SER","Utilité","Utilité",{"$nulls":3},"Indicateurs d'activité",{"$nulls":6},"-"]
["Année",2016,"Electricité","Gaz naturel","Gasoil","Biomasse","Electricité","Chaud","Froid","Air comprimé","Vapeur","Description",null,"Valeur","Unité"]
[null,"Unités","kWh","kWhs","litre","kg","kWh","kWhth","kWhfr","Nm³","Tvap"]
["  Bâtiment"]
["Activités Variables"]
["IA1","Chauffage","-","-","-","-","-","-","-","-","-","Surface chauffée normalisée",null,0,"  m²*DJ"]
["IA2","Refroidissement","-","-","-","-","-","-","-","-","-","Surface climatisée normalisée",null,0,"m²*D°C"]
["IA3","Humidification","-","-","-","-","-","-","-","-","-","Qt eau ajoutée",null,0,"kgH2O"]
["IA4","Déshumidification","-","-","-","-","-","-","-","-","-","Qt eau évacuée",null,0,"kgH2O"]
["IA5","Ventilation (VMC)","-","-","-","-","-","-","-","-","-","Débit air pulsé",null,0,"m³"]
["Activités non variables"]
[null,"Eclair / Bureautique","-","-","-","-","-","-","-","-","-"]
[null,"Eau ch sanitaire","-","-","-","-","-","-","-","-","-"]
[null,"Eclairage extérieur","-","-","-","-","-","-","-","-","-"]
["Activité opérationnelle"]
["Activités Variables"]
["IA5","Prod1","-","-","-","-","-","-","-","-","-",{"$f":"B19","v":"Prod1"},null,0,"  Tonnes"]
["IA6","Prod2","-","-","-","-","-","-","-","-","-",{"$f":"B20","v":"Prod2"},null,0,"m²"]
["IA7","Prod3","-","-","-","-","-","-","-","-","-",{"$f":"B21","v":"Prod3"},null,0,"Heures"]
["Activités non variables"]
[null,"Fixe 1","-","-","-","-","-","-","-","-","-"]
[null,"Fixe 2","-","-","-","-","-","-","-","-","-"]
[null,null,"-","-","-","-","-","-","-","-","-"]
["Solde non concilié"]
[null,"Non Concilié <2%","-","-","-","-","-","-","-","-","-"]
["Transport"]
["IA8","Véhicule","-","-","-","-","-","-","-","-","-","Distance",null,0,"km"]
["  Utilités"]
[null,"Electricité totale","-","-","-","-","-","-","-","-","-","Usage réparti"]
[null,"Chaleur cogen","-","-","-","-","-","-","-","-","-","Usage réparti"]
[null,"Chaleur PAC","-","-","-","-","-","-","-","-","-","Usage réparti"]
[null,"Chaleur chaudières","-","-","-","-","-","-","-","-","-","Usage réparti"]
[null,"Froid","-","-","-","-","-","-","-","-","-","Usage réparti"]
[null,"Air comprimé","-","-","-","-","-","-","-","-","-","Usage réparti"]
[null,"Vapeur","-","-","-","-","-","-","-","-","-","Usage réparti"]
["Totaux",null,{"$f":"SUM(C8:C37)","v":0},{"$f":"SUM(D8:D37)","v":0},0,0,0,0,0,0,0]
[]
["Tableau des productions et transformations d'énergie (valeurs négatives)",{"$nulls":5},{"$f":"SUM(G41:G48)","v":0},{"$f":"SUM(H41:H48)","v":0},0,0,0,"Rendement"]
[{"$nulls":5},"-","-","-","-","-","-"]
[null,"Photovoltaïque",{"$nulls":3},"-","-","-","-","-","-",{"v":1,"d":"100%"}]
[null,"Cogénération",{"$nulls":3},"-","-","-","-","-","-",{"$f":"IFERROR(0,-SUM(C43:K43)/SUM(D31:D32))","v":{"v":0,"d":"0.0%"}},{"$f":"-SUM(D43:L43)/SUM(D32:L32)","v":{"$error":"#DIV/0!"}}]
[null,"PAC",{"$nulls":3},"-","-","-","-","-","-",{"$f":"IFERROR(0,-SUM(C44:K44)/SUM(C33:K33))","v":{"v":0,"d":"0.0"}}]
[null,"Chaudières",{"$nulls":3},"-","-","-","-","-","-",{"v":0,"d":"0%"}]
[null,"Groupe de froid",{"$nulls":3},"-","-","-","-","-","-",{"$f":"IFERROR(0,-SUM(C46:K46)/SUM(C35:K35))","v":{"v":0,"d":"0%"}}]
[null,"Compresseur à air",{"$nulls":3},"-","-","-","-","-","-",{"v":0,"d":"0%"}]
[null,"Chaudière vapeur",{"$nulls":3},"-","-","-","-","-","-",{"v":0,"d":"0%"}]
[]
[]
["Total Acheté",null,0,0,0,0]
["Ecart Stock",{"$nulls":3},0,0]
["Exports / Ventes",null,0,0,0,0,0,0,0,0,0]
["Total périmètre",null,{"$f":"C51+C52-C53","v":0},{"$f":"D51+D52-D53","v":0},0,0,0,0,0,0,0]
[]
[]
["Facteur de conversion en énergie primaire (kWhp/Unité)",null,2.5,0.903,{"$f":"36550/3600","v":{"v":10.152777777777779,"d":"10.153"}},{"v":0,"d":"0.0000"},{"$f":"SUMPRODUCT(C54:F54,C31:F31)/G38","v":{"$error":"#DIV/0!"}}]
["Facteur de conversion en CO2 (kgCO2/Unité)",null,{"$f":"55.8*0.0036*C57","v":0.5022},{"$f":"55.8*0.0036*D57","v":{"v":0.18139464,"d":"0.1814"}},{"$f":"73.3*0.0036*E57","v":{"v":2.6791150000000004,"d":"2.6791"}},{"v":0,"d":"0.0000"}]

{"sheet":"Explications","index":1,"n_rows":14,"n_cols":1,"rows_kept":14}
["Bat"]
["Chaudière gasoil pour chauffage et ECS"]
[]
["Process"]
["Bat"]
["Gnat sur prod "]
[]
[]
["Bat Uti"]
["Réseau eau chaude pour chauffage"]
["Humidification à la vapeur"]
[]
["Process Util"]
["Chambre froide sur activité 3"]