{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Consignes","Version","Analyse graphique","Encodage","Resumé","G_Elec","G_Combustible","G_Eau","Paramètres","DJ"],"not_rendered":{"charts":30,"images":9,"macros":1,"external_links":0,"defined_names":48,"comments":2,"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":"Consignes","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Version","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Modifications avril 2023 - ICEDD"]
[null,"Mise à jour de valeurs, logo, coûts, etc \n- Possibilité d'aller jusque 2030\n- Degrés jours\n- Logo E+ onglet consigne \n\nNouvelles fonctionnalités \n- Prise en compte d'un compteur mono et d'un compteur bihoraire dans un même bâtiment \n- Autoproduction électrique et autconsommation\n\nAméliorations diverses \n- Résolution de la fonctionnalité pour afficher un certain nombre de bâtiments. N'affichait que N-1 lignes et N_bat s'affichait en D6 au lieu de D7.\n- Suppression de l'onglet caché ResumeBatiment qui ne se mettait pas à jour et qui n'était pas pertinent"]

{"sheet":"Analyse graphique","index":2,"n_rows":288,"n_cols":1,"rows_kept":288,"cut":false,"hidden":false,"merged":[[12,0,12,12],[131,0,131,12],[285,0,285,12],[287,0,287,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graphiques ELECTRICITE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graphiques COMBUSTIBLES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graphiques EAU"]
[]
["Il est toujours bon de se demander si les fluctuations sont justifiées ou si elles proviennent d'une anomalie dont il faut rechercher la cause. Pour ce faire un relevé mensuel sera plus parlant et permetttra de mieux cibler la dérive."]

{"sheet":"Encodage","index":3,"n_rows":131,"n_cols":37,"rows_kept":131,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Encodage des données et des factures"]
[]
["Année du 1er encodage:",null,null,2009]
["Choix de degrés jours:",null,null,"16,5/16,5"]
["Secteur général:",null,null,"Aide à la jeunesse"]
["Nombre de bâtiments:",null,null,12]
[]
[null,"Aller à    --->",{"$f":"A13","v":2009},{"$f":"C9+1","v":2010},2011,2012,2013,2014,2015,2016]
[]
[null,"Nom du bâtiment \n","Surface chauffée","Affectation du bâtiment","Horaires d'occupa-tion du bâtiment","Usage énergétique spécifique","Energies renouvelables","Achat\nélectricité (mono-horaire)","Achat\nélectricité Heures pleines","Achat\nélectricité Heures creuses","Coût total électricité","Autoproduction électrcitié","Injection sur le réseau",{"$f":"Paramètres!$A$3","v":"gaz naturel"},{"$f":"Paramètres!$A$4","v":"gasoil"},{"$f":"Paramètres!$A$5","v":"propane"},{"$f":"Paramètres!$A$6","v":"pellets"},{"$f":"Paramètres!$A$7","v":"Autres"},"Coût total combustible","Eau","Coût total Eau","Evol Conso Eau v/v année précédente","Achat\nélectricité \n(total)","Electricité consommée\n(total)","Auto-consommation électrcité","Elec Proportion Heure Creuse\n(Achat)","Evol Conso Elec v/v année précédente","Cons spéc d'électricité","Cons spéc d'électricité moy du secteur (2012)","Combustible \n(total)","% de norma-lisation","Combustible\n(total) \nnormalisé","Cons spéc \nnormalisée \nde combustible","Evol Cons spéc normalisée de combustible v/v année précédente","Cons spéc chauffage moy du secteur (2012)","Evol Conso spéc normalisée de combustible v/v année du 1er encodage","Potentiel d'économie de combustible"]
[null,"Sélectionner les bâtiments","m²",null,null,null,null,"kWh","kWh","kWh","euro","kWh","kWh",{"$f":"Paramètres!$B$3","v":"kWhs"},{"$f":"Paramètres!$B$4","v":"litre"},{"$f":"Paramètres!$B$5","v":"m³"},{"$f":"Paramètres!$B$6","v":"kg"},{"$f":"Paramètres!$B$7","v":"kWh"},"euro","m³","euro","%","kWh","kWh","%","%","%","kWh/m²","kWh/m²","kWhi","%","kWhi","kWhi/m²","%","kWhi/m²","%","kWh²/m²"]
[{"$f":"D4","v":2009}]
[{"$f":"A13","v":2009},"Bâtiment 1",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H14:J14)","v":0},0,{"$f":"IFERROR((L14-M14)/L14,\"NA\")","v":"NA"},{"$f":"IFERROR(J14/W14,\"NA\")","v":"NA"},null,{"$f":"IFERROR(X14/C14,0)","v":0},{"$f":"VLOOKUP(D14,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N14*Paramètres!$C$3+O14*Paramètres!$C$4+Encodage!P14*Paramètres!$C$5+Encodage!Q14*Paramètres!$C$6+R14*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D14,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD14*(1-AE14)+(AD14*AE14*DJ!$D$3/VLOOKUP(Encodage!A14,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF14/C14,0)","v":0},null,{"$f":"VLOOKUP(D14,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG14/AG$14,\"\")","v":""},{"$f":"AF14*AG14","v":0}]
[{"$f":"A13","v":2009},"Bâtiment 2",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H15:J15)","v":0},{"$f":"W15+L15-M15","v":0},{"$f":"IFERROR((L15-M15)/L15,\"NA\")","v":"NA"},"NA",null,0,{"$f":"VLOOKUP(D15,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N15*Paramètres!$C$3+O15*Paramètres!$C$4+Encodage!P15*Paramètres!$C$5+Encodage!Q15*Paramètres!$C$6+R15*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D15,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD15*(1-AE15)+(AD15*AE15*DJ!$D$3/VLOOKUP(Encodage!A15,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF15/C15,0)","v":0},null,{"$f":"VLOOKUP(D15,Paramètres!$A$24:$D$36,2)","v":100},"",{"$f":"AF15*AG15","v":0}]
[{"$f":"A15","v":2009},"Bâtiment 3",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IFERROR((L16-M16)/L16,\"NA\")","v":"NA"},"NA",null,0,{"$f":"VLOOKUP(D16,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N16*Paramètres!$C$3+O16*Paramètres!$C$4+Encodage!P16*Paramètres!$C$5+Encodage!Q16*Paramètres!$C$6+R16*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D16,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD16*(1-AE16)+(AD16*AE16*DJ!$D$3/VLOOKUP(Encodage!A16,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D16,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 4",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H17:J17)","v":0},0,"NA","NA",null,0,{"$f":"VLOOKUP(D17,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N17*Paramètres!$C$3+O17*Paramètres!$C$4+Encodage!P17*Paramètres!$C$5+Encodage!Q17*Paramètres!$C$6+R17*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D17,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD17*(1-AE17)+(AD17*AE17*DJ!$D$3/VLOOKUP(Encodage!A17,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D17,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 5",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA","NA",null,0,{"$f":"VLOOKUP(D18,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N18*Paramètres!$C$3+O18*Paramètres!$C$4+Encodage!P18*Paramètres!$C$5+Encodage!Q18*Paramètres!$C$6+R18*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D18,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD18*(1-AE18)+(AD18*AE18*DJ!$D$3/VLOOKUP(Encodage!A18,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D18,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 6",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"W19+L19-M19","v":0},"NA","NA",null,0,{"$f":"VLOOKUP(D19,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N19*Paramètres!$C$3+O19*Paramètres!$C$4+Encodage!P19*Paramètres!$C$5+Encodage!Q19*Paramètres!$C$6+R19*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D19,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD19*(1-AE19)+(AD19*AE19*DJ!$D$3/VLOOKUP(Encodage!A19,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D19,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 7",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA","NA",null,0,{"$f":"VLOOKUP(D20,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N20*Paramètres!$C$3+O20*Paramètres!$C$4+Encodage!P20*Paramètres!$C$5+Encodage!Q20*Paramètres!$C$6+R20*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D20,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD20*(1-AE20)+(AD20*AE20*DJ!$D$3/VLOOKUP(Encodage!A20,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D20,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 8",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA","NA",null,0,{"$f":"VLOOKUP(D21,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N21*Paramètres!$C$3+O21*Paramètres!$C$4+Encodage!P21*Paramètres!$C$5+Encodage!Q21*Paramètres!$C$6+R21*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D21,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD21*(1-AE21)+(AD21*AE21*DJ!$D$3/VLOOKUP(Encodage!A21,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D21,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 9",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA","NA",null,0,{"$f":"VLOOKUP(D22,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N22*Paramètres!$C$3+O22*Paramètres!$C$4+Encodage!P22*Paramètres!$C$5+Encodage!Q22*Paramètres!$C$6+R22*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D22,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD22*(1-AE22)+(AD22*AE22*DJ!$D$3/VLOOKUP(Encodage!A22,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D22,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 10",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA","NA",null,0,{"$f":"VLOOKUP(D23,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N23*Paramètres!$C$3+O23*Paramètres!$C$4+Encodage!P23*Paramètres!$C$5+Encodage!Q23*Paramètres!$C$6+R23*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D23,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD23*(1-AE23)+(AD23*AE23*DJ!$D$3/VLOOKUP(Encodage!A23,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D23,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 11",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA","NA",null,0,{"$f":"VLOOKUP(D24,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N24*Paramètres!$C$3+O24*Paramètres!$C$4+Encodage!P24*Paramètres!$C$5+Encodage!Q24*Paramètres!$C$6+R24*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D24,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD24*(1-AE24)+(AD24*AE24*DJ!$D$3/VLOOKUP(Encodage!A24,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D24,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Bâtiment 12",null,"A sélectionner dans la liste déroulante",null,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA","NA",null,0,{"$f":"VLOOKUP(D25,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N25*Paramètres!$C$3+O25*Paramètres!$C$4+Encodage!P25*Paramètres!$C$5+Encodage!Q25*Paramètres!$C$6+R25*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D25,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD25*(1-AE25)+(AD25*AE25*DJ!$D$3/VLOOKUP(Encodage!A25,DJ!$A$3:$D$25,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D25,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2009,"Total",{"$f":"SUM(C14:C25)","v":0},null,null,null,null,{"$f":"SUM(H14:H25)","v":0},{"$f":"SUM(I14:I25)","v":0},{"$f":"SUM(J14:J25)","v":0},{"$f":"SUM(K14:K25)","v":0},null,null,{"$f":"SUM(N14:N25)","v":0},0,0,0,0,0,null,0,null,{"$f":"SUM(W14:W25)","v":0},{"$f":"SUM(X14:X25)","v":0},null,null,null,{"$f":"IFERROR(W26/C26,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD14:AD25)","v":0},null,{"$f":"SUM(AF14:AF25)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]
[]
[{"$f":"A13+1","v":2010}]
[{"$f":"A28","v":2010},{"$f":"B14","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",{"$f":"E14","v":0},{"$f":"F14","v":"à encoder"},{"$f":"G14","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T29=0,,T29/T14-1)","v":0},{"$f":"SUM(H29:J29)","v":0},0,{"$f":"IFERROR((L29-M29)/L29,\"NA\")","v":"NA"},{"$f":"IFERROR(J29/W29,\"NA\")","v":"NA"},{"$f":"IF(X29=0,0,X29/X14-1)","v":0},{"$f":"IFERROR(X29/C29,0)","v":0},{"$f":"VLOOKUP(D29,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N29*Paramètres!$C$3+O29*Paramètres!$C$4+Encodage!P29*Paramètres!$C$5+Encodage!Q29*Paramètres!$C$6+R29*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D29,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD29*(1-AE29)+(AD29*AE29*DJ!$D$3/VLOOKUP(Encodage!A29,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF29/C29,0)","v":0},{"$f":"IF(AF29=0,,AF29/AF14-1)","v":0},{"$f":"VLOOKUP(D29,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG29/AG$14,\"\")","v":""},{"$f":"AF29*AG29","v":0}]
[{"$f":"A29","v":2010},"Bâtiment 2",0,"A sélectionner dans la liste déroulante",0,{"$f":"F15","v":"à encoder"},"à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T30=0,,T30/T15-1)","v":0},{"$f":"SUM(H30:J30)","v":0},{"$f":"W30+L30-M30","v":0},{"$f":"IFERROR((L30-M30)/L30,\"NA\")","v":"NA"},"NA",{"$f":"IF(X30=0,0,X30/X30-1)","v":0},{"$f":"IFERROR(X30/C30,0)","v":0},{"$f":"VLOOKUP(D30,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N30*Paramètres!$C$3+O30*Paramètres!$C$4+Encodage!P30*Paramètres!$C$5+Encodage!Q30*Paramètres!$C$6+R30*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D30,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD30*(1-AE30)+(AD30*AE30*DJ!$D$3/VLOOKUP(Encodage!A30,DJ!$A$3:$D$25,4)),0)","v":0},0,{"$f":"IF(AF30=0,,AF30/AF15-1)","v":0},{"$f":"VLOOKUP(D30,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A30","v":2010},"Bâtiment 3",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T31=0,,T31/T16-1)","v":0},0,0,"NA","NA",0,{"$f":"IFERROR(X31/C31,0)","v":0},{"$f":"VLOOKUP(D31,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N31*Paramètres!$C$3+O31*Paramètres!$C$4+Encodage!P31*Paramètres!$C$5+Encodage!Q31*Paramètres!$C$6+R31*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D31,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD31*(1-AE31)+(AD31*AE31*DJ!$D$3/VLOOKUP(Encodage!A31,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D31,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,{"$f":"F17","v":"à encoder"},"à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X32/C32,0)","v":0},{"$f":"VLOOKUP(D32,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N32*Paramètres!$C$3+O32*Paramètres!$C$4+Encodage!P32*Paramètres!$C$5+Encodage!Q32*Paramètres!$C$6+R32*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D32,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD32*(1-AE32)+(AD32*AE32*DJ!$D$3/VLOOKUP(Encodage!A32,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D32,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 5",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D33,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N33*Paramètres!$C$3+O33*Paramètres!$C$4+Encodage!P33*Paramètres!$C$5+Encodage!Q33*Paramètres!$C$6+R33*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D33,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD33*(1-AE33)+(AD33*AE33*DJ!$D$3/VLOOKUP(Encodage!A33,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D33,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 6",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D34,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N34*Paramètres!$C$3+O34*Paramètres!$C$4+Encodage!P34*Paramètres!$C$5+Encodage!Q34*Paramètres!$C$6+R34*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D34,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD34*(1-AE34)+(AD34*AE34*DJ!$D$3/VLOOKUP(Encodage!A34,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D34,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 7",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D35,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N35*Paramètres!$C$3+O35*Paramètres!$C$4+Encodage!P35*Paramètres!$C$5+Encodage!Q35*Paramètres!$C$6+R35*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D35,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD35*(1-AE35)+(AD35*AE35*DJ!$D$3/VLOOKUP(Encodage!A35,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D35,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 8",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D36,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N36*Paramètres!$C$3+O36*Paramètres!$C$4+Encodage!P36*Paramètres!$C$5+Encodage!Q36*Paramètres!$C$6+R36*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D36,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD36*(1-AE36)+(AD36*AE36*DJ!$D$3/VLOOKUP(Encodage!A36,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D36,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 9",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(H37:J37)","v":0},0,"NA","NA",0,0,{"$f":"VLOOKUP(D37,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N37*Paramètres!$C$3+O37*Paramètres!$C$4+Encodage!P37*Paramètres!$C$5+Encodage!Q37*Paramètres!$C$6+R37*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D37,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD37*(1-AE37)+(AD37*AE37*DJ!$D$3/VLOOKUP(Encodage!A37,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D37,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 10",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D38,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N38*Paramètres!$C$3+O38*Paramètres!$C$4+Encodage!P38*Paramètres!$C$5+Encodage!Q38*Paramètres!$C$6+R38*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D38,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD38*(1-AE38)+(AD38*AE38*DJ!$D$3/VLOOKUP(Encodage!A38,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D38,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 11",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X39/C39,0)","v":0},{"$f":"VLOOKUP(D39,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N39*Paramètres!$C$3+O39*Paramètres!$C$4+Encodage!P39*Paramètres!$C$5+Encodage!Q39*Paramètres!$C$6+R39*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D39,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD39*(1-AE39)+(AD39*AE39*DJ!$D$3/VLOOKUP(Encodage!A39,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D39,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Bâtiment 12",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D40,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N40*Paramètres!$C$3+O40*Paramètres!$C$4+Encodage!P40*Paramètres!$C$5+Encodage!Q40*Paramètres!$C$6+R40*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D40,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD40*(1-AE40)+(AD40*AE40*DJ!$D$3/VLOOKUP(Encodage!A40,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D40,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2010,"Total",{"$f":"SUM(C29:C40)","v":0},null,null,null,null,{"$f":"SUM(H29:H40)","v":0},{"$f":"SUM(I29:I40)","v":0},0,0,null,null,0,0,0,0,0,0,0,{"$f":"SUM(U29:U40)","v":0},null,{"$f":"SUM(W29:W40)","v":0},{"$f":"SUM(X29:X40)","v":0},null,null,null,{"$f":"IFERROR(W41/C41,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD29:AD40)","v":0},null,{"$f":"SUM(AF29:AF40)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]
[]
[{"$f":"A28+1","v":2011}]
[{"$f":"A43","v":2011},{"$f":"B29","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T44=0,,T44/T29-1)","v":0},{"$f":"SUM(H44:J44)","v":0},{"$f":"W44+L44-M44","v":0},{"$f":"IFERROR((L44-M44)/L44,\"NA\")","v":"NA"},{"$f":"IFERROR(J44/W44,\"NA\")","v":"NA"},{"$f":"IF(X44=0,0,X44/X44-1)","v":0},{"$f":"IFERROR(X44/C44,0)","v":0},{"$f":"VLOOKUP(D44,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N44*Paramètres!$C$3+O44*Paramètres!$C$4+Encodage!P44*Paramètres!$C$5+Encodage!Q44*Paramètres!$C$6+R44*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D44,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD44*(1-AE44)+(AD44*AE44*DJ!$D$3/VLOOKUP(Encodage!A44,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF44/C44,0)","v":0},{"$f":"IF(AF44=0,,AF44/AF29-1)","v":0},{"$f":"VLOOKUP(D44,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG44/AG$14,\"\")","v":""},{"$f":"AF44*AG44","v":0}]
[{"$f":"A44","v":2011},"Bâtiment 2",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T45=0,,T45/T30-1)","v":0},{"$f":"SUM(H45:J45)","v":0},{"$f":"W45+L45-M45","v":0},{"$f":"IFERROR((L45-M45)/L45,\"NA\")","v":"NA"},"NA",{"$f":"IF(X45=0,0,X45/X45-1)","v":0},{"$f":"IFERROR(X45/C45,0)","v":0},{"$f":"VLOOKUP(D45,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N45*Paramètres!$C$3+O45*Paramètres!$C$4+Encodage!P45*Paramètres!$C$5+Encodage!Q45*Paramètres!$C$6+R45*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D45,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD45*(1-AE45)+(AD45*AE45*DJ!$D$3/VLOOKUP(Encodage!A45,DJ!$A$3:$D$25,4)),0)","v":0},0,{"$f":"IF(AF45=0,,AF45/AF30-1)","v":0},{"$f":"VLOOKUP(D45,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A45","v":2011},"Bâtiment 3",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D46,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N46*Paramètres!$C$3+O46*Paramètres!$C$4+Encodage!P46*Paramètres!$C$5+Encodage!Q46*Paramètres!$C$6+R46*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D46,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD46*(1-AE46)+(AD46*AE46*DJ!$D$3/VLOOKUP(Encodage!A46,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D46,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,{"$f":"F32","v":"à encoder"},"à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X47/C47,0)","v":0},{"$f":"VLOOKUP(D47,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N47*Paramètres!$C$3+O47*Paramètres!$C$4+Encodage!P47*Paramètres!$C$5+Encodage!Q47*Paramètres!$C$6+R47*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D47,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD47*(1-AE47)+(AD47*AE47*DJ!$D$3/VLOOKUP(Encodage!A47,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D47,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 5",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",{"$f":"IF(X48=0,0,X48/X48-1)","v":0},0,{"$f":"VLOOKUP(D48,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N48*Paramètres!$C$3+O48*Paramètres!$C$4+Encodage!P48*Paramètres!$C$5+Encodage!Q48*Paramètres!$C$6+R48*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D48,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD48*(1-AE48)+(AD48*AE48*DJ!$D$3/VLOOKUP(Encodage!A48,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D48,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 6",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D49,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N49*Paramètres!$C$3+O49*Paramètres!$C$4+Encodage!P49*Paramètres!$C$5+Encodage!Q49*Paramètres!$C$6+R49*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D49,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD49*(1-AE49)+(AD49*AE49*DJ!$D$3/VLOOKUP(Encodage!A49,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D49,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 7",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D50,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N50*Paramètres!$C$3+O50*Paramètres!$C$4+Encodage!P50*Paramètres!$C$5+Encodage!Q50*Paramètres!$C$6+R50*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D50,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD50*(1-AE50)+(AD50*AE50*DJ!$D$3/VLOOKUP(Encodage!A50,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D50,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 8",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D51,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N51*Paramètres!$C$3+O51*Paramètres!$C$4+Encodage!P51*Paramètres!$C$5+Encodage!Q51*Paramètres!$C$6+R51*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D51,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD51*(1-AE51)+(AD51*AE51*DJ!$D$3/VLOOKUP(Encodage!A51,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D51,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 9",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(H52:J52)","v":0},0,"NA","NA",0,0,{"$f":"VLOOKUP(D52,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N52*Paramètres!$C$3+O52*Paramètres!$C$4+Encodage!P52*Paramètres!$C$5+Encodage!Q52*Paramètres!$C$6+R52*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D52,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD52*(1-AE52)+(AD52*AE52*DJ!$D$3/VLOOKUP(Encodage!A52,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D52,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 10",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D53,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N53*Paramètres!$C$3+O53*Paramètres!$C$4+Encodage!P53*Paramètres!$C$5+Encodage!Q53*Paramètres!$C$6+R53*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D53,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD53*(1-AE53)+(AD53*AE53*DJ!$D$3/VLOOKUP(Encodage!A53,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D53,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 11",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X54/C54,0)","v":0},{"$f":"VLOOKUP(D54,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N54*Paramètres!$C$3+O54*Paramètres!$C$4+Encodage!P54*Paramètres!$C$5+Encodage!Q54*Paramètres!$C$6+R54*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D54,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD54*(1-AE54)+(AD54*AE54*DJ!$D$3/VLOOKUP(Encodage!A54,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D54,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Bâtiment 12",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D55,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N55*Paramètres!$C$3+O55*Paramètres!$C$4+Encodage!P55*Paramètres!$C$5+Encodage!Q55*Paramètres!$C$6+R55*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D55,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD55*(1-AE55)+(AD55*AE55*DJ!$D$3/VLOOKUP(Encodage!A55,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D55,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2011,"Total",{"$f":"SUM(C44:C55)","v":0},null,null,null,null,{"$f":"SUM(H44:H55)","v":0},{"$f":"SUM(I44:I55)","v":0},{"$f":"SUM(J44:J55)","v":0},{"$f":"SUM(K44:K55)","v":0},{"$f":"SUM(L44:L55)","v":0},{"$f":"SUM(M44:M55)","v":0},{"$f":"SUM(N44:N55)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(W44:W55)","v":0},{"$f":"SUM(X44:X55)","v":0},null,null,null,{"$f":"IFERROR(W56/C56,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD44:AD55)","v":0},null,{"$f":"SUM(AF44:AF55)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]
[]
[{"$f":"A43+1","v":2012}]
[{"$f":"A58","v":2012},{"$f":"B44","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F44","v":"à encoder"},{"$f":"G44","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T59=0,,T59/T44-1)","v":0},{"$f":"SUM(H59:J59)","v":0},{"$f":"W59+L59-M59","v":0},{"$f":"IFERROR((L59-M59)/L59,\"NA\")","v":"NA"},{"$f":"IFERROR(J59/W59,\"NA\")","v":"NA"},{"$f":"IF(X59=0,0,X59/X59-1)","v":0},{"$f":"IFERROR(X59/C59,0)","v":0},{"$f":"VLOOKUP(D59,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N59*Paramètres!$C$3+O59*Paramètres!$C$4+Encodage!P59*Paramètres!$C$5+Encodage!Q59*Paramètres!$C$6+R59*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D59,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD59*(1-AE59)+(AD59*AE59*DJ!$D$3/VLOOKUP(Encodage!A59,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF59/C59,0)","v":0},{"$f":"IF(AF59=0,,AF59/AF44-1)","v":0},{"$f":"VLOOKUP(D59,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG59/AG$14,\"\")","v":""},{"$f":"AF59*AG59","v":0}]
[{"$f":"A59","v":2012},"Bâtiment 2",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T60=0,,T60/T45-1)","v":0},{"$f":"SUM(H60:J60)","v":0},{"$f":"W60+L60-M60","v":0},{"$f":"IFERROR((L60-M60)/L60,\"NA\")","v":"NA"},"NA",{"$f":"IF(X60=0,0,X60/X60-1)","v":0},{"$f":"IFERROR(X60/C60,0)","v":0},{"$f":"VLOOKUP(D60,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N60*Paramètres!$C$3+O60*Paramètres!$C$4+Encodage!P60*Paramètres!$C$5+Encodage!Q60*Paramètres!$C$6+R60*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D60,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD60*(1-AE60)+(AD60*AE60*DJ!$D$3/VLOOKUP(Encodage!A60,DJ!$A$3:$D$25,4)),0)","v":0},0,{"$f":"IF(AF60=0,,AF60/AF45-1)","v":0},{"$f":"VLOOKUP(D60,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A60","v":2012},"Bâtiment 3",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D61,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N61*Paramètres!$C$3+O61*Paramètres!$C$4+Encodage!P61*Paramètres!$C$5+Encodage!Q61*Paramètres!$C$6+R61*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D61,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD61*(1-AE61)+(AD61*AE61*DJ!$D$3/VLOOKUP(Encodage!A61,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D61,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X62/C62,0)","v":0},{"$f":"VLOOKUP(D62,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N62*Paramètres!$C$3+O62*Paramètres!$C$4+Encodage!P62*Paramètres!$C$5+Encodage!Q62*Paramètres!$C$6+R62*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D62,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD62*(1-AE62)+(AD62*AE62*DJ!$D$3/VLOOKUP(Encodage!A62,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D62,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 5",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",{"$f":"IF(X63=0,0,X63/X63-1)","v":0},0,{"$f":"VLOOKUP(D63,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N63*Paramètres!$C$3+O63*Paramètres!$C$4+Encodage!P63*Paramètres!$C$5+Encodage!Q63*Paramètres!$C$6+R63*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D63,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD63*(1-AE63)+(AD63*AE63*DJ!$D$3/VLOOKUP(Encodage!A63,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D63,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 6",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D64,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N64*Paramètres!$C$3+O64*Paramètres!$C$4+Encodage!P64*Paramètres!$C$5+Encodage!Q64*Paramètres!$C$6+R64*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D64,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD64*(1-AE64)+(AD64*AE64*DJ!$D$3/VLOOKUP(Encodage!A64,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D64,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 7",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D65,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N65*Paramètres!$C$3+O65*Paramètres!$C$4+Encodage!P65*Paramètres!$C$5+Encodage!Q65*Paramètres!$C$6+R65*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D65,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD65*(1-AE65)+(AD65*AE65*DJ!$D$3/VLOOKUP(Encodage!A65,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D65,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 8",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D66,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N66*Paramètres!$C$3+O66*Paramètres!$C$4+Encodage!P66*Paramètres!$C$5+Encodage!Q66*Paramètres!$C$6+R66*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D66,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD66*(1-AE66)+(AD66*AE66*DJ!$D$3/VLOOKUP(Encodage!A66,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D66,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 9",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(H67:J67)","v":0},0,"NA","NA",0,0,{"$f":"VLOOKUP(D67,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N67*Paramètres!$C$3+O67*Paramètres!$C$4+Encodage!P67*Paramètres!$C$5+Encodage!Q67*Paramètres!$C$6+R67*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D67,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD67*(1-AE67)+(AD67*AE67*DJ!$D$3/VLOOKUP(Encodage!A67,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D67,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 10",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D68,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N68*Paramètres!$C$3+O68*Paramètres!$C$4+Encodage!P68*Paramètres!$C$5+Encodage!Q68*Paramètres!$C$6+R68*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D68,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD68*(1-AE68)+(AD68*AE68*DJ!$D$3/VLOOKUP(Encodage!A68,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D68,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 11",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X69/C69,0)","v":0},{"$f":"VLOOKUP(D69,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N69*Paramètres!$C$3+O69*Paramètres!$C$4+Encodage!P69*Paramètres!$C$5+Encodage!Q69*Paramètres!$C$6+R69*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D69,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD69*(1-AE69)+(AD69*AE69*DJ!$D$3/VLOOKUP(Encodage!A69,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D69,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Bâtiment 12",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D70,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N70*Paramètres!$C$3+O70*Paramètres!$C$4+Encodage!P70*Paramètres!$C$5+Encodage!Q70*Paramètres!$C$6+R70*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D70,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD70*(1-AE70)+(AD70*AE70*DJ!$D$3/VLOOKUP(Encodage!A70,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D70,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2012,"Total",{"$f":"SUM(C59:C70)","v":0},null,null,null,null,{"$f":"SUM(H59:H70)","v":0},{"$f":"SUM(I59:I70)","v":0},{"$f":"SUM(J59:J70)","v":0},{"$f":"SUM(K59:K70)","v":0},{"$f":"SUM(L59:L70)","v":0},{"$f":"SUM(M59:M70)","v":0},{"$f":"SUM(N59:N70)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(W59:W70)","v":0},{"$f":"SUM(X59:X70)","v":0},null,null,null,{"$f":"IFERROR(W71/C71,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD59:AD70)","v":0},null,{"$f":"SUM(AF59:AF70)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]
[]
[{"$f":"A58+1","v":2013}]
[{"$f":"A73","v":2013},{"$f":"B59","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F59","v":"à encoder"},{"$f":"G59","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T74=0,,T74/T59-1)","v":0},{"$f":"SUM(H74:J74)","v":0},{"$f":"W74+L74-M74","v":0},{"$f":"IFERROR((L74-M74)/L74,\"NA\")","v":"NA"},{"$f":"IFERROR(J74/W74,\"NA\")","v":"NA"},{"$f":"IF(X74=0,0,X74/X74-1)","v":0},{"$f":"IFERROR(X74/C74,0)","v":0},{"$f":"VLOOKUP(D74,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N74*Paramètres!$C$3+O74*Paramètres!$C$4+Encodage!P74*Paramètres!$C$5+Encodage!Q74*Paramètres!$C$6+R74*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D74,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD74*(1-AE74)+(AD74*AE74*DJ!$D$3/VLOOKUP(Encodage!A74,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF74/C74,0)","v":0},{"$f":"IF(AF74=0,,AF74/AF59-1)","v":0},{"$f":"VLOOKUP(D74,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG74/AG$14,\"\")","v":""},{"$f":"AF74*AG74","v":0}]
[{"$f":"A74","v":2013},"Bâtiment 2",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T75=0,,T75/T60-1)","v":0},{"$f":"SUM(H75:J75)","v":0},{"$f":"W75+L75-M75","v":0},{"$f":"IFERROR((L75-M75)/L75,\"NA\")","v":"NA"},"NA",{"$f":"IF(X75=0,0,X75/X75-1)","v":0},{"$f":"IFERROR(X75/C75,0)","v":0},{"$f":"VLOOKUP(D75,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N75*Paramètres!$C$3+O75*Paramètres!$C$4+Encodage!P75*Paramètres!$C$5+Encodage!Q75*Paramètres!$C$6+R75*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D75,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD75*(1-AE75)+(AD75*AE75*DJ!$D$3/VLOOKUP(Encodage!A75,DJ!$A$3:$D$25,4)),0)","v":0},0,{"$f":"IF(AF75=0,,AF75/AF60-1)","v":0},{"$f":"VLOOKUP(D75,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A75","v":2013},"Bâtiment 3",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D76,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N76*Paramètres!$C$3+O76*Paramètres!$C$4+Encodage!P76*Paramètres!$C$5+Encodage!Q76*Paramètres!$C$6+R76*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D76,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD76*(1-AE76)+(AD76*AE76*DJ!$D$3/VLOOKUP(Encodage!A76,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D76,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X77/C77,0)","v":0},{"$f":"VLOOKUP(D77,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N77*Paramètres!$C$3+O77*Paramètres!$C$4+Encodage!P77*Paramètres!$C$5+Encodage!Q77*Paramètres!$C$6+R77*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D77,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD77*(1-AE77)+(AD77*AE77*DJ!$D$3/VLOOKUP(Encodage!A77,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D77,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 5",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",{"$f":"IF(X78=0,0,X78/X78-1)","v":0},0,{"$f":"VLOOKUP(D78,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N78*Paramètres!$C$3+O78*Paramètres!$C$4+Encodage!P78*Paramètres!$C$5+Encodage!Q78*Paramètres!$C$6+R78*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D78,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD78*(1-AE78)+(AD78*AE78*DJ!$D$3/VLOOKUP(Encodage!A78,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D78,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 6",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D79,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N79*Paramètres!$C$3+O79*Paramètres!$C$4+Encodage!P79*Paramètres!$C$5+Encodage!Q79*Paramètres!$C$6+R79*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D79,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD79*(1-AE79)+(AD79*AE79*DJ!$D$3/VLOOKUP(Encodage!A79,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D79,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 7",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D80,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N80*Paramètres!$C$3+O80*Paramètres!$C$4+Encodage!P80*Paramètres!$C$5+Encodage!Q80*Paramètres!$C$6+R80*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D80,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD80*(1-AE80)+(AD80*AE80*DJ!$D$3/VLOOKUP(Encodage!A80,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D80,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 8",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D81,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N81*Paramètres!$C$3+O81*Paramètres!$C$4+Encodage!P81*Paramètres!$C$5+Encodage!Q81*Paramètres!$C$6+R81*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D81,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD81*(1-AE81)+(AD81*AE81*DJ!$D$3/VLOOKUP(Encodage!A81,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D81,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 9",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(H82:J82)","v":0},0,"NA","NA",0,0,{"$f":"VLOOKUP(D82,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N82*Paramètres!$C$3+O82*Paramètres!$C$4+Encodage!P82*Paramètres!$C$5+Encodage!Q82*Paramètres!$C$6+R82*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D82,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD82*(1-AE82)+(AD82*AE82*DJ!$D$3/VLOOKUP(Encodage!A82,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D82,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 10",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D83,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N83*Paramètres!$C$3+O83*Paramètres!$C$4+Encodage!P83*Paramètres!$C$5+Encodage!Q83*Paramètres!$C$6+R83*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D83,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD83*(1-AE83)+(AD83*AE83*DJ!$D$3/VLOOKUP(Encodage!A83,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D83,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 11",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X84/C84,0)","v":0},{"$f":"VLOOKUP(D84,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N84*Paramètres!$C$3+O84*Paramètres!$C$4+Encodage!P84*Paramètres!$C$5+Encodage!Q84*Paramètres!$C$6+R84*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D84,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD84*(1-AE84)+(AD84*AE84*DJ!$D$3/VLOOKUP(Encodage!A84,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D84,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Bâtiment 12",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D85,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N85*Paramètres!$C$3+O85*Paramètres!$C$4+Encodage!P85*Paramètres!$C$5+Encodage!Q85*Paramètres!$C$6+R85*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D85,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD85*(1-AE85)+(AD85*AE85*DJ!$D$3/VLOOKUP(Encodage!A85,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D85,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Total",{"$f":"SUM(C74:C85)","v":0},null,null,null,null,{"$f":"SUM(H74:H85)","v":0},{"$f":"SUM(I74:I85)","v":0},{"$f":"SUM(J74:J85)","v":0},{"$f":"SUM(K74:K85)","v":0},{"$f":"SUM(L74:L85)","v":0},{"$f":"SUM(M74:M85)","v":0},{"$f":"SUM(N74:N85)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(W74:W85)","v":0},{"$f":"SUM(X74:X85)","v":0},null,null,null,{"$f":"IFERROR(W86/C86,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD74:AD85)","v":0},null,{"$f":"SUM(AF74:AF85)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]
[]
[{"$f":"A73+1","v":2014}]
[{"$f":"A88","v":2014},{"$f":"B74","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F74","v":"à encoder"},{"$f":"G74","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T89=0,,T89/T74-1)","v":0},{"$f":"SUM(H89:J89)","v":0},{"$f":"W89+L89-M89","v":0},{"$f":"IFERROR((L89-M89)/L89,\"NA\")","v":"NA"},{"$f":"IFERROR(J89/W89,\"NA\")","v":"NA"},{"$f":"IF(X89=0,0,X89/X89-1)","v":0},{"$f":"IFERROR(X89/C89,0)","v":0},{"$f":"VLOOKUP(D89,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N89*Paramètres!$C$3+O89*Paramètres!$C$4+Encodage!P89*Paramètres!$C$5+Encodage!Q89*Paramètres!$C$6+R89*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D89,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD89*(1-AE89)+(AD89*AE89*DJ!$D$3/VLOOKUP(Encodage!A89,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF89/C89,0)","v":0},{"$f":"IF(AF89=0,,AF89/AF74-1)","v":0},{"$f":"VLOOKUP(D89,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG89/AG$14,\"\")","v":""},{"$f":"AF89*AG89","v":0}]
[{"$f":"A89","v":2014},"Bâtiment 2",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T90=0,,T90/T75-1)","v":0},{"$f":"SUM(H90:J90)","v":0},{"$f":"W90+L90-M90","v":0},{"$f":"IFERROR((L90-M90)/L90,\"NA\")","v":"NA"},"NA",{"$f":"IF(X90=0,0,X90/X90-1)","v":0},{"$f":"IFERROR(X90/C90,0)","v":0},{"$f":"VLOOKUP(D90,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N90*Paramètres!$C$3+O90*Paramètres!$C$4+Encodage!P90*Paramètres!$C$5+Encodage!Q90*Paramètres!$C$6+R90*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D90,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD90*(1-AE90)+(AD90*AE90*DJ!$D$3/VLOOKUP(Encodage!A90,DJ!$A$3:$D$25,4)),0)","v":0},0,{"$f":"IF(AF90=0,,AF90/AF75-1)","v":0},{"$f":"VLOOKUP(D90,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A90","v":2014},"Bâtiment 3",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D91,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N91*Paramètres!$C$3+O91*Paramètres!$C$4+Encodage!P91*Paramètres!$C$5+Encodage!Q91*Paramètres!$C$6+R91*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D91,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD91*(1-AE91)+(AD91*AE91*DJ!$D$3/VLOOKUP(Encodage!A91,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D91,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X92/C92,0)","v":0},{"$f":"VLOOKUP(D92,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N92*Paramètres!$C$3+O92*Paramètres!$C$4+Encodage!P92*Paramètres!$C$5+Encodage!Q92*Paramètres!$C$6+R92*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D92,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD92*(1-AE92)+(AD92*AE92*DJ!$D$3/VLOOKUP(Encodage!A92,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D92,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 5",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",{"$f":"IF(X93=0,0,X93/X93-1)","v":0},0,{"$f":"VLOOKUP(D93,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N93*Paramètres!$C$3+O93*Paramètres!$C$4+Encodage!P93*Paramètres!$C$5+Encodage!Q93*Paramètres!$C$6+R93*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D93,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD93*(1-AE93)+(AD93*AE93*DJ!$D$3/VLOOKUP(Encodage!A93,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D93,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 6",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D94,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N94*Paramètres!$C$3+O94*Paramètres!$C$4+Encodage!P94*Paramètres!$C$5+Encodage!Q94*Paramètres!$C$6+R94*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D94,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD94*(1-AE94)+(AD94*AE94*DJ!$D$3/VLOOKUP(Encodage!A94,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D94,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 7",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D95,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N95*Paramètres!$C$3+O95*Paramètres!$C$4+Encodage!P95*Paramètres!$C$5+Encodage!Q95*Paramètres!$C$6+R95*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D95,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD95*(1-AE95)+(AD95*AE95*DJ!$D$3/VLOOKUP(Encodage!A95,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D95,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 8",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D96,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N96*Paramètres!$C$3+O96*Paramètres!$C$4+Encodage!P96*Paramètres!$C$5+Encodage!Q96*Paramètres!$C$6+R96*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D96,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD96*(1-AE96)+(AD96*AE96*DJ!$D$3/VLOOKUP(Encodage!A96,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D96,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 9",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(H97:J97)","v":0},0,"NA","NA",0,0,{"$f":"VLOOKUP(D97,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N97*Paramètres!$C$3+O97*Paramètres!$C$4+Encodage!P97*Paramètres!$C$5+Encodage!Q97*Paramètres!$C$6+R97*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D97,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD97*(1-AE97)+(AD97*AE97*DJ!$D$3/VLOOKUP(Encodage!A97,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D97,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 10",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D98,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N98*Paramètres!$C$3+O98*Paramètres!$C$4+Encodage!P98*Paramètres!$C$5+Encodage!Q98*Paramètres!$C$6+R98*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D98,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD98*(1-AE98)+(AD98*AE98*DJ!$D$3/VLOOKUP(Encodage!A98,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D98,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 11",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X99/C99,0)","v":0},{"$f":"VLOOKUP(D99,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N99*Paramètres!$C$3+O99*Paramètres!$C$4+Encodage!P99*Paramètres!$C$5+Encodage!Q99*Paramètres!$C$6+R99*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D99,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD99*(1-AE99)+(AD99*AE99*DJ!$D$3/VLOOKUP(Encodage!A99,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D99,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 12",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D100,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N100*Paramètres!$C$3+O100*Paramètres!$C$4+Encodage!P100*Paramètres!$C$5+Encodage!Q100*Paramètres!$C$6+R100*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D100,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD100*(1-AE100)+(AD100*AE100*DJ!$D$3/VLOOKUP(Encodage!A100,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D100,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Total",{"$f":"SUM(C89:C100)","v":0},null,null,null,null,{"$f":"SUM(H89:H100)","v":0},{"$f":"SUM(I89:I100)","v":0},{"$f":"SUM(J89:J100)","v":0},{"$f":"SUM(K89:K100)","v":0},{"$f":"SUM(L89:L100)","v":0},{"$f":"SUM(M89:M100)","v":0},{"$f":"SUM(N89:N100)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(W89:W100)","v":0},{"$f":"SUM(X89:X100)","v":0},null,null,null,{"$f":"IFERROR(W101/C101,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD89:AD100)","v":0},null,{"$f":"SUM(AF89:AF100)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]
[]
[{"$f":"A88+1","v":2015}]
[{"$f":"A103","v":2015},{"$f":"B89","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F89","v":"à encoder"},{"$f":"G89","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T104=0,,T104/T89-1)","v":0},{"$f":"SUM(H104:J104)","v":0},{"$f":"W104+L104-M104","v":0},{"$f":"IFERROR((L104-M104)/L104,\"NA\")","v":"NA"},{"$f":"IFERROR(J104/W104,\"NA\")","v":"NA"},{"$f":"IF(X104=0,0,X104/X104-1)","v":0},{"$f":"IFERROR(X104/C104,0)","v":0},{"$f":"VLOOKUP(D104,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N104*Paramètres!$C$3+O104*Paramètres!$C$4+Encodage!P104*Paramètres!$C$5+Encodage!Q104*Paramètres!$C$6+R104*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D104,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD104*(1-AE104)+(AD104*AE104*DJ!$D$3/VLOOKUP(Encodage!A104,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF104/C104,0)","v":0},{"$f":"IF(AF104=0,,AF104/AF89-1)","v":0},{"$f":"VLOOKUP(D104,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG104/AG$14,\"\")","v":""},{"$f":"AF104*AG104","v":0}]
[{"$f":"A104","v":2015},"Bâtiment 2",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T105=0,,T105/T90-1)","v":0},{"$f":"SUM(H105:J105)","v":0},{"$f":"W105+L105-M105","v":0},{"$f":"IFERROR((L105-M105)/L105,\"NA\")","v":"NA"},"NA",{"$f":"IF(X105=0,0,X105/X105-1)","v":0},{"$f":"IFERROR(X105/C105,0)","v":0},{"$f":"VLOOKUP(D105,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N105*Paramètres!$C$3+O105*Paramètres!$C$4+Encodage!P105*Paramètres!$C$5+Encodage!Q105*Paramètres!$C$6+R105*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D105,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD105*(1-AE105)+(AD105*AE105*DJ!$D$3/VLOOKUP(Encodage!A105,DJ!$A$3:$D$25,4)),0)","v":0},0,{"$f":"IF(AF105=0,,AF105/AF90-1)","v":0},{"$f":"VLOOKUP(D105,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A105","v":2015},"Bâtiment 3",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D106,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N106*Paramètres!$C$3+O106*Paramètres!$C$4+Encodage!P106*Paramètres!$C$5+Encodage!Q106*Paramètres!$C$6+R106*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D106,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD106*(1-AE106)+(AD106*AE106*DJ!$D$3/VLOOKUP(Encodage!A106,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D106,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X107/C107,0)","v":0},{"$f":"VLOOKUP(D107,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N107*Paramètres!$C$3+O107*Paramètres!$C$4+Encodage!P107*Paramètres!$C$5+Encodage!Q107*Paramètres!$C$6+R107*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D107,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD107*(1-AE107)+(AD107*AE107*DJ!$D$3/VLOOKUP(Encodage!A107,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D107,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 5",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",{"$f":"IF(X108=0,0,X108/X108-1)","v":0},0,{"$f":"VLOOKUP(D108,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N108*Paramètres!$C$3+O108*Paramètres!$C$4+Encodage!P108*Paramètres!$C$5+Encodage!Q108*Paramètres!$C$6+R108*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D108,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD108*(1-AE108)+(AD108*AE108*DJ!$D$3/VLOOKUP(Encodage!A108,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D108,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 6",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D109,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N109*Paramètres!$C$3+O109*Paramètres!$C$4+Encodage!P109*Paramètres!$C$5+Encodage!Q109*Paramètres!$C$6+R109*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D109,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD109*(1-AE109)+(AD109*AE109*DJ!$D$3/VLOOKUP(Encodage!A109,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D109,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 7",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D110,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N110*Paramètres!$C$3+O110*Paramètres!$C$4+Encodage!P110*Paramètres!$C$5+Encodage!Q110*Paramètres!$C$6+R110*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D110,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD110*(1-AE110)+(AD110*AE110*DJ!$D$3/VLOOKUP(Encodage!A110,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D110,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 8",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D111,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N111*Paramètres!$C$3+O111*Paramètres!$C$4+Encodage!P111*Paramètres!$C$5+Encodage!Q111*Paramètres!$C$6+R111*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D111,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD111*(1-AE111)+(AD111*AE111*DJ!$D$3/VLOOKUP(Encodage!A111,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D111,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 9",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(H112:J112)","v":0},0,"NA","NA",0,0,{"$f":"VLOOKUP(D112,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N112*Paramètres!$C$3+O112*Paramètres!$C$4+Encodage!P112*Paramètres!$C$5+Encodage!Q112*Paramètres!$C$6+R112*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D112,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD112*(1-AE112)+(AD112*AE112*DJ!$D$3/VLOOKUP(Encodage!A112,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D112,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 10",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D113,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N113*Paramètres!$C$3+O113*Paramètres!$C$4+Encodage!P113*Paramètres!$C$5+Encodage!Q113*Paramètres!$C$6+R113*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D113,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD113*(1-AE113)+(AD113*AE113*DJ!$D$3/VLOOKUP(Encodage!A113,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D113,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 11",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X114/C114,0)","v":0},{"$f":"VLOOKUP(D114,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N114*Paramètres!$C$3+O114*Paramètres!$C$4+Encodage!P114*Paramètres!$C$5+Encodage!Q114*Paramètres!$C$6+R114*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D114,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD114*(1-AE114)+(AD114*AE114*DJ!$D$3/VLOOKUP(Encodage!A114,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D114,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 12",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D115,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N115*Paramètres!$C$3+O115*Paramètres!$C$4+Encodage!P115*Paramètres!$C$5+Encodage!Q115*Paramètres!$C$6+R115*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D115,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD115*(1-AE115)+(AD115*AE115*DJ!$D$3/VLOOKUP(Encodage!A115,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D115,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Total",{"$f":"SUM(C104:C115)","v":0},null,null,null,null,{"$f":"SUM(H104:H115)","v":0},{"$f":"SUM(I104:I115)","v":0},{"$f":"SUM(J104:J115)","v":0},{"$f":"SUM(K104:K115)","v":0},{"$f":"SUM(L104:L115)","v":0},{"$f":"SUM(M104:M115)","v":0},{"$f":"SUM(N104:N115)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(W104:W115)","v":0},{"$f":"SUM(X104:X115)","v":0},null,null,null,{"$f":"IFERROR(W116/C116,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD104:AD115)","v":0},null,{"$f":"SUM(AF104:AF115)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]
[]
[{"$f":"A103+1","v":2016}]
[{"$f":"A118","v":2016},{"$f":"B104","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F104","v":"à encoder"},{"$f":"G104","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T119=0,,T119/T104-1)","v":0},{"$f":"SUM(H119:J119)","v":0},{"$f":"W119+L119-M119","v":0},{"$f":"IFERROR((L119-M119)/L119,\"NA\")","v":"NA"},{"$f":"IFERROR(J119/W119,\"NA\")","v":"NA"},{"$f":"IF(X119=0,0,X119/X119-1)","v":0},{"$f":"IFERROR(X119/C119,0)","v":0},{"$f":"VLOOKUP(D119,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N119*Paramètres!$C$3+O119*Paramètres!$C$4+Encodage!P119*Paramètres!$C$5+Encodage!Q119*Paramètres!$C$6+R119*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D119,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD119*(1-AE119)+(AD119*AE119*DJ!$D$3/VLOOKUP(Encodage!A119,DJ!$A$3:$D$25,4)),0)","v":0},{"$f":"IFERROR(AF119/C119,0)","v":0},{"$f":"IF(AF119=0,,AF119/AF104-1)","v":0},{"$f":"VLOOKUP(D119,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AG119/AG$14,\"\")","v":""},{"$f":"AF119*AG119","v":0}]
[{"$f":"A119","v":2016},"Bâtiment 2",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T120=0,,T120/T105-1)","v":0},{"$f":"SUM(H120:J120)","v":0},{"$f":"W120+L120-M120","v":0},{"$f":"IFERROR((L120-M120)/L120,\"NA\")","v":"NA"},"NA",{"$f":"IF(X120=0,0,X120/X120-1)","v":0},{"$f":"IFERROR(X120/C120,0)","v":0},{"$f":"VLOOKUP(D120,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N120*Paramètres!$C$3+O120*Paramètres!$C$4+Encodage!P120*Paramètres!$C$5+Encodage!Q120*Paramètres!$C$6+R120*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D120,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD120*(1-AE120)+(AD120*AE120*DJ!$D$3/VLOOKUP(Encodage!A120,DJ!$A$3:$D$25,4)),0)","v":0},0,{"$f":"IF(AF120=0,,AF120/AF105-1)","v":0},{"$f":"VLOOKUP(D120,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A120","v":2016},"Bâtiment 3",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D121,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N121*Paramètres!$C$3+O121*Paramètres!$C$4+Encodage!P121*Paramètres!$C$5+Encodage!Q121*Paramètres!$C$6+R121*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D121,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD121*(1-AE121)+(AD121*AE121*DJ!$D$3/VLOOKUP(Encodage!A121,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D121,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X122/C122,0)","v":0},{"$f":"VLOOKUP(D122,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N122*Paramètres!$C$3+O122*Paramètres!$C$4+Encodage!P122*Paramètres!$C$5+Encodage!Q122*Paramètres!$C$6+R122*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D122,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD122*(1-AE122)+(AD122*AE122*DJ!$D$3/VLOOKUP(Encodage!A122,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D122,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 5",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",{"$f":"IF(X123=0,0,X123/X123-1)","v":0},0,{"$f":"VLOOKUP(D123,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N123*Paramètres!$C$3+O123*Paramètres!$C$4+Encodage!P123*Paramètres!$C$5+Encodage!Q123*Paramètres!$C$6+R123*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D123,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD123*(1-AE123)+(AD123*AE123*DJ!$D$3/VLOOKUP(Encodage!A123,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D123,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 6",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D124,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N124*Paramètres!$C$3+O124*Paramètres!$C$4+Encodage!P124*Paramètres!$C$5+Encodage!Q124*Paramètres!$C$6+R124*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D124,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD124*(1-AE124)+(AD124*AE124*DJ!$D$3/VLOOKUP(Encodage!A124,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D124,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 7",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D125,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N125*Paramètres!$C$3+O125*Paramètres!$C$4+Encodage!P125*Paramètres!$C$5+Encodage!Q125*Paramètres!$C$6+R125*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D125,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD125*(1-AE125)+(AD125*AE125*DJ!$D$3/VLOOKUP(Encodage!A125,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D125,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 8",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D126,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N126*Paramètres!$C$3+O126*Paramètres!$C$4+Encodage!P126*Paramètres!$C$5+Encodage!Q126*Paramètres!$C$6+R126*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D126,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD126*(1-AE126)+(AD126*AE126*DJ!$D$3/VLOOKUP(Encodage!A126,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D126,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 9",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(H127:J127)","v":0},0,"NA","NA",0,0,{"$f":"VLOOKUP(D127,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N127*Paramètres!$C$3+O127*Paramètres!$C$4+Encodage!P127*Paramètres!$C$5+Encodage!Q127*Paramètres!$C$6+R127*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D127,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD127*(1-AE127)+(AD127*AE127*DJ!$D$3/VLOOKUP(Encodage!A127,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D127,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 10",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D128,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N128*Paramètres!$C$3+O128*Paramètres!$C$4+Encodage!P128*Paramètres!$C$5+Encodage!Q128*Paramètres!$C$6+R128*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D128,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD128*(1-AE128)+(AD128*AE128*DJ!$D$3/VLOOKUP(Encodage!A128,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D128,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 11",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,{"$f":"IFERROR(X129/C129,0)","v":0},{"$f":"VLOOKUP(D129,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N129*Paramètres!$C$3+O129*Paramètres!$C$4+Encodage!P129*Paramètres!$C$5+Encodage!Q129*Paramètres!$C$6+R129*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D129,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD129*(1-AE129)+(AD129*AE129*DJ!$D$3/VLOOKUP(Encodage!A129,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D129,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Bâtiment 12",0,"A sélectionner dans la liste déroulante",0,"à encoder","à encoder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"NA","NA",0,0,{"$f":"VLOOKUP(D130,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"N130*Paramètres!$C$3+O130*Paramètres!$C$4+Encodage!P130*Paramètres!$C$5+Encodage!Q130*Paramètres!$C$6+R130*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D130,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(AD130*(1-AE130)+(AD130*AE130*DJ!$D$3/VLOOKUP(Encodage!A130,DJ!$A$3:$D$25,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D130,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Total",{"$f":"SUM(C119:C130)","v":0},null,null,null,null,{"$f":"SUM(H119:H130)","v":0},{"$f":"SUM(I119:I130)","v":0},{"$f":"SUM(J119:J130)","v":0},{"$f":"SUM(K119:K130)","v":0},{"$f":"SUM(L119:L130)","v":0},{"$f":"SUM(M119:M130)","v":0},{"$f":"SUM(N119:N130)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(W119:W130)","v":0},{"$f":"SUM(X119:X130)","v":0},null,null,null,{"$f":"IFERROR(W131/C131,0)","v":0},{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"SUM(AD119:AD130)","v":0},null,{"$f":"SUM(AF119:AF130)","v":0},0,null,{"$f":"VLOOKUP($D$6,Paramètres!$A$24:$D$36,2)","v":0},""]

{"sheet":"Resumé","index":4,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Evolution des consommations totales de tous les bâtiments"]
[]
[null,"Consommations",{"$f":"Encodage!D4","v":2009},{"$f":"C4+1","v":2010},2011,2012,2013,2014,2015,2016]
[null,"Consommation Elec totale [kWh]",{"$f":"Encodage!$W26","v":0},{"$f":"Encodage!W41","v":0},{"$f":"Encodage!W56","v":0},{"$f":"Encodage!$W71","v":0},{"$f":"Encodage!$W86","v":0},{"$f":"Encodage!$W101","v":0},{"$f":"Encodage!$W116","v":0},{"$f":"Encodage!$W131","v":0}]
[null,"Cons. Elec heures pleines [kWh]",{"$f":"Encodage!$I26","v":0},{"$f":"Encodage!I41","v":0},{"$f":"Encodage!I56","v":0},{"$f":"Encodage!$I71","v":0},{"$f":"Encodage!$I86","v":0},{"$f":"Encodage!$I101","v":0},{"$f":"Encodage!$I116","v":0},{"$f":"Encodage!$I131","v":0}]
[null,"Cons. Elec heures creuses [kWh]",{"$f":"Encodage!$J26","v":0},{"$f":"Encodage!J41","v":0},{"$f":"Encodage!J56","v":0},{"$f":"Encodage!$J71","v":0},{"$f":"Encodage!$J86","v":0},{"$f":"Encodage!$J101","v":0},{"$f":"Encodage!$J116","v":0},{"$f":"Encodage!$J131","v":0}]
[null,"Cons. élect spécifique [kWh/m²]",{"$f":"IFERROR(Encodage!$AB26,0)","v":0},{"$f":"IFERROR(Encodage!$AB41,0)","v":0},{"$f":"IFERROR(Encodage!$AB56,0)","v":0},{"$f":"IFERROR(Encodage!$AB71,0)","v":0},{"$f":"IFERROR(Encodage!$AB86,0)","v":0},{"$f":"IFERROR(Encodage!$AB101,0)","v":0},{"$f":"IFERROR(Encodage!$AB116,0)","v":0},{"$f":"IFERROR(Encodage!$AB131,0)","v":0}]
[null,{"$f":"\"Cons. moyenne du secteur (= \"&C9&\" kWh/m²)\"","v":"Cons. moyenne du secteur (= 0 kWh/m²)"},{"$f":"VLOOKUP(Encodage!D6,Paramètres!$A$24:$D$36,3)","v":0},{"$f":"$C$9","v":0},{"$f":"$C$9","v":0},0,0,0,0,0]
[null,"Consommation de combustibles [kWhi]",{"$f":"Encodage!$AD26","v":0},{"$f":"Encodage!AD41","v":0},{"$f":"Encodage!AD56","v":0},{"$f":"Encodage!$AD71","v":0},{"$f":"Encodage!$AD86","v":0},{"$f":"Encodage!$AD101","v":0},{"$f":"Encodage!$AD116","v":0},{"$f":"Encodage!$AD131","v":0}]
[null,"Cons. de combustible normalisé [kWhi]",{"$f":"Encodage!$AF26","v":0},{"$f":"Encodage!$AF41","v":0},{"$f":"Encodage!$AF56","v":0},{"$f":"Encodage!$AF71","v":0},{"$f":"Encodage!$AF86","v":0},{"$f":"Encodage!$AF101","v":0},{"$f":"Encodage!$AF116","v":0},{"$f":"Encodage!$AF131","v":0}]
[null,"Cons. combustible spécifique normalisée [kWhi/m²]",{"$f":"IFERROR(Encodage!$AG26,0)","v":0},{"$f":"IFERROR(Encodage!AG41,0)","v":0},{"$f":"IFERROR(Encodage!AG56,0)","v":0},{"$f":"IFERROR(Encodage!$AG71,0)","v":0},{"$f":"IFERROR(Encodage!$AG86,0)","v":0},{"$f":"IFERROR(Encodage!$AG101,0)","v":0},{"$f":"IFERROR(Encodage!$AG116,0)","v":0},{"$f":"IFERROR(Encodage!$AG131,0)","v":0}]
[null,{"$f":"\"Consommation moyenne du secteur (= \"&C13&\" kWh/m²)\"","v":"Consommation moyenne du secteur (= 0 kWh/m²)"},{"$f":"VLOOKUP(Encodage!D6,Paramètres!$A$24:$D$36,2)","v":0},{"$f":"$C$13","v":0},0,0,0,0,0,0]
[null,"Degrés jours (16,5/16,5)",{"$f":"VLOOKUP(C4,DJ!$A$4:$D$25,4)","v":2212},{"$f":"VLOOKUP(D4,DJ!$A$4:$D$25,4)","v":2703},{"$f":"VLOOKUP(E4,DJ!$A$4:$D$25,4)","v":1928},{"$f":"VLOOKUP(F4,DJ!$A$4:$D$25,4)","v":2327},{"$f":"VLOOKUP(G4,DJ!$A$4:$D$25,4)","v":2537},{"$f":"VLOOKUP(H4,DJ!$A$4:$D$25,4)","v":1828},{"$f":"VLOOKUP(I4,DJ!$A$4:$D$25,4)","v":2112},{"$f":"VLOOKUP(J4,DJ!$A$4:$D$25,4)","v":2329}]
[null,"Eau (m³)",{"$f":"Encodage!$T26","v":0},{"$f":"Encodage!T41","v":0},{"$f":"Encodage!T56","v":0},{"$f":"Encodage!$T71","v":0},{"$f":"Encodage!$T86","v":0},{"$f":"Encodage!$T101","v":0},{"$f":"Encodage!$T116","v":0},{"$f":"Encodage!$T131","v":0}]
[null,"Coût total elec (€)",{"$f":"Encodage!$K$26","v":0},{"$f":"Encodage!$K$41","v":0},{"$f":"Encodage!$K$56","v":0},{"$f":"Encodage!$K$71","v":0},{"$f":"Encodage!$K$86","v":0},{"$f":"Encodage!$K$101","v":0},{"$f":"Encodage!K116","v":0},{"$f":"Encodage!$K$131","v":0}]
[null,"Coût total combustible (€)",{"$f":"Encodage!$S$26","v":0},{"$f":"Encodage!$S$41","v":0},{"$f":"Encodage!$S$56","v":0},{"$f":"Encodage!$S$71","v":0},{"$f":"Encodage!$S$86","v":0},{"$f":"Encodage!$S$101","v":0},{"$f":"Encodage!S117","v":0},{"$f":"Encodage!$S$131","v":0}]
[null,"Coût total eau (€)",{"$f":"Encodage!$U$26","v":0},{"$f":"Encodage!$U$41","v":0},{"$f":"Encodage!$U$56","v":0},{"$f":"Encodage!$U$71","v":0},{"$f":"Encodage!$U$86","v":0},{"$f":"Encodage!$U$101","v":0},{"$f":"Encodage!U118","v":0},{"$f":"Encodage!$U$131","v":0}]
[]
[null,"Evolution par rapport à l’année du 1er encodage",{"$f":"C4","v":2009},2010,2011,2012,2013,2014,2015,2016]
[null,{"$f":"B5","v":"Consommation Elec totale [kWh]"},{"$f":"IFERROR(C5/$C5,0)","v":0},{"$f":"IFERROR(D5/$C5,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B6","v":"Cons. Elec heures pleines [kWh]"},{"$f":"IFERROR(C6/$C6,0)","v":0},0,0,0,0,0,0,0]
[null,{"$f":"B7","v":"Cons. Elec heures creuses [kWh]"},{"$f":"IFERROR(C7/$C7,0)","v":0},{"$f":"IFERROR(D7/$C7,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B10","v":"Consommation de combustibles [kWhi]"},{"$f":"IFERROR(C10/$C10,0)","v":0},{"$f":"IFERROR(D10/$C10,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B11","v":"Cons. de combustible normalisé [kWhi]"},{"$f":"IFERROR(C11/$C11,0)","v":0},{"$f":"IFERROR(D11/$C11,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B12","v":"Cons. combustible spécifique normalisée [kWhi/m²]"},{"$f":"IFERROR(C12/$C12,0)","v":0},{"$f":"IFERROR(D12/$C12,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B15","v":"Eau (m³)"},{"$f":"IFERROR(C15/$C15,0)","v":0},{"$f":"IFERROR(D15/$C15,0)","v":0},0,0,0,0,0,0]
[null,"Coût total elec",{"$f":"IFERROR(C16/$C16,0)","v":0},0,0,0,0,0,0,0]
[null,"Coût total combustible",{"$f":"IFERROR(C17/$C17,0)","v":0},0,0,0,0,0,0,0]
[null,"Coût total eau",{"$f":"IFERROR(C18/$C18,0)","v":0},0,0,0,0,0,0,0]
[]
[null,"Evolution par rapport à l'année précédente",{"$f":"C20","v":2009},2010,2011,2012,2013,2014,2015,2016]
[null,{"$f":"B21","v":"Consommation Elec totale [kWh]"},null,{"$f":"IFERROR(IF(D21=0,0,D21/C21-1),\"\")","v":0},0,0,0,0,0,0]
[null,"Cons. Elec heures pleines [kWh]",null,0,0,0,0,0,0,0]
[null,"Cons. Elec heures creuses [kWh]",null,0,0,0,0,0,0,0]
[null,"Consommation de combustibles [kWhi]",null,0,0,0,0,0,0,0]
[null,"Cons. de combustible normalisé [kWhi]",null,0,0,0,0,0,0,0]
[null,"Cons. combustible spécifique normalisée [kWhi/m²]",null,0,0,0,0,0,0,0]
[null,"Eau (m³)",null,{"$f":"IFERROR(IF(D27=0,0,D27/C27-1),\"\")","v":0},0,0,0,0,0,0]
[null,"Coût total elec",null,{"$f":"IFERROR(IF(D28=0,0,D28/C28-1),\"\")","v":0},{"$f":"IFERROR(IF(E28=0,0,E28/D28-1),\"\")","v":0},{"$f":"IFERROR(IF(F28=0,0,F28/E28-1),\"\")","v":0},{"$f":"IFERROR(IF(G28=0,0,G28/F28-1),\"\")","v":0},{"$f":"IFERROR(IF(H28=0,0,H28/G28-1),\"\")","v":0},{"$f":"IFERROR(IF(I28=0,0,I28/H28-1),\"\")","v":0},{"$f":"IFERROR(IF(J28=0,0,J28/I28-1),\"\")","v":0}]
[null,"Coût total combustible",null,0,0,0,0,0,0,0]
[null,"Coût total eau",null,0,0,0,0,0,0,0]

{"sheet":"G_Elec","index":5,"n_rows":126,"n_cols":17,"rows_kept":126,"cut":false,"hidden":false,"merged":[[124,0,124,5],[124,6,124,10],[124,11,124,15],[124,16,124,20],[125,0,125,5],[125,6,125,10],[125,11,125,15],[125,16,125,20],[100,0,100,5],[100,6,100,10],[100,11,100,15],[100,16,100,20],[102,0,102,5],[102,6,102,10],[102,11,102,15],[102,16,102,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Consommation d'élec par bâtiment",null,null,null,null,null,{"$f":"$A$125","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$125","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$125","v":"Consommation d'élec par bâtiment"}]
[]
[{"$f":"Encodage!A13","v":2009},null,null,null,null,null,{"$f":"Encodage!A28","v":2010},null,null,null,null,{"$f":"Encodage!A43","v":2011},null,null,null,null,{"$f":"Encodage!A58","v":2012}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Consommation d'élec par bâtiment",null,null,null,null,null,{"$f":"$A$125","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$125","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$125","v":"Consommation d'élec par bâtiment"}]
[{"$f":"Encodage!A73","v":2013},null,null,null,null,null,{"$f":"Encodage!A88","v":2014},null,null,null,null,{"$f":"Encodage!A103","v":2015},null,null,null,null,{"$f":"Encodage!A118","v":2016}]

{"sheet":"G_Combustible","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[41,0,41,5],[41,6,41,10],[60,6,60,10]]}

{"sheet":"G_Eau","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[24,0,24,5],[24,6,24,10]]}

{"sheet":"Paramètres","index":8,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Coefficients de conversion:"]
["Electricité","kWh",2.5,{"$f":"\"kWhp\"&\"/\"&B2","v":"kWhp/kWh"}]
["gaz naturel","kWhs",0.90300000000000002,"kWhp/kWhs"]
["gasoil","litre",{"$f":"36500/3600","v":10.138888888888889},"kWhp/litre"]
["propane","m³",6.5555555555555598,"kWhp/m³"]
["pellets","kg",4,"kWhp/kg"]
["Autres","kWh",1,"kWhp/kWh"]
[]
["Usage énergétique"]
["Chauffage"]
["Eau chaude sanitaire (ECS)"]
["Cuisine"]
["Ch + ECS"]
["Ch + cuisine"]
["ECS + Cuisine"]
["Ch + ECS + Cuisine"]
["cuisine collective"]
["air-conditionné"]
["chauffage électrique"]
["piscine"]
[]
["Consommation moyenne du secteur (2012)"]
[null,"Chauffage","Elec",null,"Rapport Normalisation"]
[{"$f":"DJ!A28","v":"A sélectionner dans la liste déroulante"},100,100,"kWh/m²",{"$f":"DJ!B28","v":0.85}]
[{"$f":"DJ!A29","v":"Accueil de jour"},0,0,"kWh/m²",{"$f":"DJ!B29","v":0.85}]
[{"$f":"DJ!A30","v":"Bureau privé HT"},102,138,"kWh/m²",{"$f":"DJ!B30","v":0.85}]
[{"$f":"DJ!A31","v":"Bureau public HT"},165,65,"kWh/m²",{"$f":"DJ!B31","v":0.85}]
[{"$f":"DJ!A32","v":"Centre d’insertion socio-professionnel"},0,0,"kWh/m²",{"$f":"DJ!B32","v":0.85}]
[{"$f":"DJ!A33","v":"Crèche"},0,0,"kWh/m²",{"$f":"DJ!B33","v":0.85}]
[{"$f":"DJ!A34","v":"École"},143,26,"kWh/m²",{"$f":"DJ!B34","v":0.85}]
[{"$f":"DJ!A35","v":"Entreprise de travail adapté"},0,0,"kWh/m²",{"$f":"DJ!B35","v":0.85}]
[{"$f":"DJ!A36","v":"Etablissement culturel"},177,59,"kWh/m²",{"$f":"DJ!B36","v":0.85}]
[{"$f":"DJ!A37","v":"Etablissement sportif"},150,50,"kWh/m²",{"$f":"DJ!B37","v":0.85}]
[{"$f":"DJ!A38","v":"Hébergement"},199,72,"kWh/m²",{"$f":"DJ!B38","v":0.7}]
[{"$f":"DJ!A39","v":"Hôpitaux"},194,122,"kWh/m²",{"$f":"DJ!B39","v":0.7}]
[{"$f":"DJ!A40","v":"autre"},0,0,"kWh/m²",{"$f":"DJ!B40","v":0.85}]
[]
["Energies renouvelables"]
["A sélectionner dans la liste déroulante"]
["o   Biomasse sèche"]
["o   Biomasse humide"]
["o   Cogénération Biomasse"]
["o   Solaire photovoltaïque"]
["o   Solaire thermique"]
["o   Eolien"]
["o   Hydroélectricité"]
["o   Géothermie profonde comme utilisateur"]
["o   Pompe à Chaleur"]
[]
[]
[]
["Secteur"]
["Hébergement"]
["Accueil de jour"]
["Bureau"]
["Crèche"]
["École"]
["Etablissement sportif"]
["Etablissement culturel"]
["Entreprise de travail adapté"]
["Centre d’insertion socio-professionnel"]
["autre"]

{"sheet":"DJ","index":9,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,5,2,9]]}
[]
["Degrés jours","15/15","16,5/16,5",{"$f":"IF(Encodage!$D$5=$B$2,B2,C2)","v":"16,5/16,5"}]
["degré jour normaux",1913,2301,{"$f":"IF(Encodage!$D$5=$B$2,B3,C3)","v":2301},null,"Les degrés jours normaux  sont  la  moyenne des degrés jours des 30 dernières années (de 1986 à 2015). Cette  moyenne est revue par l'IRM tous les 5 ans "]
[2009,1819.7,2212,{"$f":"IF(Encodage!$D$5=$B$2,B4,C4)","v":2212}]
[2010,2309,2703,{"$f":"IF(Encodage!$D$5=$B$2,B5,C5)","v":2703}]
[2011,1514.5,1928,{"$f":"IF(Encodage!$D$5=$B$2,B6,C6)","v":1928}]
[2012,1914.7,2327,{"$f":"IF(Encodage!$D$5=$B$2,B7,C7)","v":2327}]
[2013,2137.6999999999998,2537,{"$f":"IF(Encodage!$D$5=$B$2,B8,C8)","v":2537}]
[2014,1424.1,1828,{"$f":"IF(Encodage!$D$5=$B$2,B9,C9)","v":1828}]
[2015,1688.3,2112,{"$f":"IF(Encodage!$D$5=$B$2,B10,C10)","v":2112}]
[2016,1947.6,2329,{"$f":"IF(Encodage!$D$5=$B$2,B11,C11)","v":2329}]
[2017,1780.4,2155,{"$f":"IF(Encodage!$D$5=$B$2,B12,C12)","v":2155}]
[2018,1739.3,2091,{"$f":"IF(Encodage!$D$5=$B$2,B13,C13)","v":2091}]
[2019,1675.65,2076,{"$f":"IF(Encodage!$D$5=$B$2,B14,C14)","v":2076}]
[2020,1517.85,1867,{"$f":"IF(Encodage!$D$5=$B$2,B15,C15)","v":1867}]
[2021,1909.2,2286,{"$f":"IF(Encodage!$D$5=$B$2,B16,C16)","v":2286}]
[2022,1554.1,1922,{"$f":"IF(Encodage!$D$5=$B$2,B17,C17)","v":1922}]
[2023,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B18,C18)","v":0}]
[2024,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B19,C19)","v":0}]
[2025,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B20,C20)","v":0}]
[2026,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B21,C21)","v":0}]
[2027,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B22,C22)","v":0}]
[2028,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B23,C23)","v":0}]
[2029,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B24,C24)","v":0}]
[2030,null,null,{"$f":"IF(Encodage!$D$5=$B$2,B25,C25)","v":0}]
[]
["Rapport Normalisation"]
["A sélectionner dans la liste déroulante",0.85]
["Accueil de jour",0.85]
["Bureau privé HT",0.85]
["Bureau public HT",0.85]
["Centre d’insertion socio-professionnel",0.85]
["Crèche",0.85]
["École",0.85]
["Entreprise de travail adapté",0.85]
["Etablissement culturel",0.85]
["Etablissement sportif",0.85]
["Hébergement",0.7]
["Hôpitaux",0.7]
["autre",0.85]