{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Consignes","ResumeBatiment","Analyse graphique","Encodage","Resumé","G_Elec","Feuil1","G_Combustible","G_Eau","Paramètres","DJ"],"not_rendered":{"charts":29,"images":6,"macros":1,"external_links":0,"defined_names":52,"comments":2,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"ResumeBatiment","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Batiment","(Tous)"]
[]
[null,"Étiquettes de colonnes"]
["Valeurs",2010,2011,2012,2013,2014,2015,2016,2017]
["Somme de Electricité ",318905.99600000004,312719.99399999995,317661.99,316139.99200000003,0,0,0,0]
["Somme de Electricité Heures pleines",0,0,0,0,0,0,0,0]
["Somme de Electricité Heures creuses",0,0,0,0,0,0,0,0]
["Somme de Cons spéc d'électricité",244.0846845526776,239.35003762688407,243.13254800079363,241.96763772815893,0,0,0,0]
["Somme de Cons spéc d'électricité moy du secteur",100,100,100,100,100,100,100,100]
["Somme de Combustible ",1864875.6,1631164.2101999999,1787578.7999999998,1796355.96,0,0,0,0]

{"sheet":"Analyse graphique","index":2,"n_rows":269,"n_cols":1,"rows_kept":269,"cut":false,"hidden":false,"merged":[[11,0,11,12],[112,0,112,12],[266,0,266,12],[268,0,268,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":130,"n_cols":33,"rows_kept":130,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Encodage des données et des factures"]
[]
["Année du 1er encodage:",null,null,2013]
["Choix de degrés jours:",null,null,"16,5/16,5"]
["Secteur général:"]
["Nombre de bâtiments:",null,null,12]
[]
[null,"Aller à    --->",{"$f":"A12","v":2013},{"$f":"C8+1","v":2014},2015,{"$f":"E8+1","v":2016},{"$f":"F8+1","v":2017},{"$f":"G8+1","v":2018},{"$f":"H8+1","v":2019},{"$f":"I8+1","v":2020}]
[]
[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","Electricité (mono-horaire)","Electricité Heures pleines","Electricité Heures creuses","Coût total électricité",{"$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","Electricité \n(total)","Elec Proportion Heure Creuse","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",{"$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/m²","kWh/m²","kWhi","%","kWhi","kWhi/m²","%","kWhi/m²","%","kWh²/m²"]
[{"$f":"D3","v":2013}]
[{"$f":"A12","v":2013},"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,{"$f":"IF(H13<>0,H13,I13+J13)","v":0},{"$f":"IFERROR(J13/U13,\"NA\")","v":"NA"},{"$f":"IF(U13=0,0,U13/U13-1)","v":0},{"$f":"IFERROR(U13/C13,0)","v":0},{"$f":"VLOOKUP(D13,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L13*Paramètres!$C$3+M13*Paramètres!$C$4+Encodage!N13*Paramètres!$C$5+Encodage!O13*Paramètres!$C$6+P13*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D13,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z13*(1-AA13)+(Z13*AA13*DJ!$D$2/VLOOKUP(Encodage!A13,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB13/C13,0)","v":0},null,{"$f":"VLOOKUP(D13,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC13/AC$13,\"\")","v":""},{"$f":"AB13*AC13","v":0}]
[{"$f":"A12","v":2013},"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,0,"NA",{"$f":"IF(U14=0,0,U14/U14-1)","v":0},0,{"$f":"VLOOKUP(D14,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L14*Paramètres!$C$3+M14*Paramètres!$C$4+Encodage!N14*Paramètres!$C$5+Encodage!O14*Paramètres!$C$6+P14*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D14,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z14*(1-AA14)+(Z14*AA14*DJ!$D$2/VLOOKUP(Encodage!A14,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D14,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A14","v":2013},"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,0,"NA",0,0,{"$f":"VLOOKUP(D15,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L15*Paramètres!$C$3+M15*Paramètres!$C$4+Encodage!N15*Paramètres!$C$5+Encodage!O15*Paramètres!$C$6+P15*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D15,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z15*(1-AA15)+(Z15*AA15*DJ!$D$2/VLOOKUP(Encodage!A15,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D15,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D16,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L16*Paramètres!$C$3+M16*Paramètres!$C$4+Encodage!N16*Paramètres!$C$5+Encodage!O16*Paramètres!$C$6+P16*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D16,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z16*(1-AA16)+(Z16*AA16*DJ!$D$2/VLOOKUP(Encodage!A16,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D16,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D17,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L17*Paramètres!$C$3+M17*Paramètres!$C$4+Encodage!N17*Paramètres!$C$5+Encodage!O17*Paramètres!$C$6+P17*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D17,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z17*(1-AA17)+(Z17*AA17*DJ!$D$2/VLOOKUP(Encodage!A17,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D17,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D18,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L18*Paramètres!$C$3+M18*Paramètres!$C$4+Encodage!N18*Paramètres!$C$5+Encodage!O18*Paramètres!$C$6+P18*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D18,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z18*(1-AA18)+(Z18*AA18*DJ!$D$2/VLOOKUP(Encodage!A18,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D18,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D19,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L19*Paramètres!$C$3+M19*Paramètres!$C$4+Encodage!N19*Paramètres!$C$5+Encodage!O19*Paramètres!$C$6+P19*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D19,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z19*(1-AA19)+(Z19*AA19*DJ!$D$2/VLOOKUP(Encodage!A19,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D19,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D20,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L20*Paramètres!$C$3+M20*Paramètres!$C$4+Encodage!N20*Paramètres!$C$5+Encodage!O20*Paramètres!$C$6+P20*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D20,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z20*(1-AA20)+(Z20*AA20*DJ!$D$2/VLOOKUP(Encodage!A20,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D20,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D21,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L21*Paramètres!$C$3+M21*Paramètres!$C$4+Encodage!N21*Paramètres!$C$5+Encodage!O21*Paramètres!$C$6+P21*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D21,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z21*(1-AA21)+(Z21*AA21*DJ!$D$2/VLOOKUP(Encodage!A21,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D21,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D22,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L22*Paramètres!$C$3+M22*Paramètres!$C$4+Encodage!N22*Paramètres!$C$5+Encodage!O22*Paramètres!$C$6+P22*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D22,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z22*(1-AA22)+(Z22*AA22*DJ!$D$2/VLOOKUP(Encodage!A22,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D22,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",0,0,{"$f":"VLOOKUP(D23,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L23*Paramètres!$C$3+M23*Paramètres!$C$4+Encodage!N23*Paramètres!$C$5+Encodage!O23*Paramètres!$C$6+P23*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D23,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z23*(1-AA23)+(Z23*AA23*DJ!$D$2/VLOOKUP(Encodage!A23,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D23,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"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,0,"NA",{"$f":"IF(U24=0,0,U24/U24-1)","v":0},0,{"$f":"VLOOKUP(D24,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L24*Paramètres!$C$3+M24*Paramètres!$C$4+Encodage!N24*Paramètres!$C$5+Encodage!O24*Paramètres!$C$6+P24*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D24,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z24*(1-AA24)+(Z24*AA24*DJ!$D$2/VLOOKUP(Encodage!A24,DJ!$A$2:$D$14,4)),0)","v":0},0,null,{"$f":"VLOOKUP(D24,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2013,"Total",{"$f":"SUM(C13:C24)","v":0},null,null,null,null,{"$f":"SUM(H13:H24)","v":0},{"$f":"SUM(I13:I24)","v":0},{"$f":"SUM(J13:J24)","v":0},{"$f":"SUM(K13:K24)","v":0},{"$f":"SUM(L13:L24)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(U13:U24)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z13:Z24)","v":0},null,{"$f":"SUM(AB13:AB24)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]
[]
[{"$f":"A12+1","v":2014}]
[{"$f":"A27","v":2014},{"$f":"B13","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F13","v":"à encoder"},"à encoder",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R28=0,,R28/R13-1)","v":0},{"$f":"IF(H28<>0,H28,I28+J28)","v":0},{"$f":"IFERROR(J28/U28,\"NA\")","v":"NA"},{"$f":"IF(U28=0,0,U28/U13-1)","v":0},{"$f":"IFERROR(U28/C28,0)","v":0},{"$f":"VLOOKUP(D28,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L28*Paramètres!$C$3+M28*Paramètres!$C$4+Encodage!N28*Paramètres!$C$5+Encodage!O28*Paramètres!$C$6+P28*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D28,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z28*(1-AA28)+(Z28*AA28*DJ!$D$2/VLOOKUP(Encodage!A28,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB28/C28,0)","v":0},{"$f":"IF(AB28=0,,AB28/AB13-1)","v":0},{"$f":"VLOOKUP(D28,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC28/AC$13,\"\")","v":""},{"$f":"AB28*AC28","v":0}]
[{"$f":"A28","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,{"$f":"IF(R29=0,,R29/R14-1)","v":0},0,"NA",0,0,{"$f":"VLOOKUP(D29,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L29*Paramètres!$C$3+M29*Paramètres!$C$4+Encodage!N29*Paramètres!$C$5+Encodage!O29*Paramètres!$C$6+P29*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D29,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z29*(1-AA29)+(Z29*AA29*DJ!$D$2/VLOOKUP(Encodage!A29,DJ!$A$2:$D$14,4)),0)","v":0},0,{"$f":"IF(AB29=0,,AB29/AB14-1)","v":0},{"$f":"VLOOKUP(D29,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A29","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,0,0,"NA",0,0,{"$f":"VLOOKUP(D30,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L30*Paramètres!$C$3+M30*Paramètres!$C$4+Encodage!N30*Paramètres!$C$5+Encodage!O30*Paramètres!$C$6+P30*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D30,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z30*(1-AA30)+(Z30*AA30*DJ!$D$2/VLOOKUP(Encodage!A30,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D30,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,{"$f":"F16","v":"à encoder"},"à encoder",null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA",0,0,{"$f":"VLOOKUP(D31,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L31*Paramètres!$C$3+M31*Paramètres!$C$4+Encodage!N31*Paramètres!$C$5+Encodage!O31*Paramètres!$C$6+P31*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D31,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z31*(1-AA31)+(Z31*AA31*DJ!$D$2/VLOOKUP(Encodage!A31,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D31,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D32,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L32*Paramètres!$C$3+M32*Paramètres!$C$4+Encodage!N32*Paramètres!$C$5+Encodage!O32*Paramètres!$C$6+P32*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D32,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z32*(1-AA32)+(Z32*AA32*DJ!$D$2/VLOOKUP(Encodage!A32,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D32,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D33,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L33*Paramètres!$C$3+M33*Paramètres!$C$4+Encodage!N33*Paramètres!$C$5+Encodage!O33*Paramètres!$C$6+P33*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D33,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z33*(1-AA33)+(Z33*AA33*DJ!$D$2/VLOOKUP(Encodage!A33,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D33,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D34,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L34*Paramètres!$C$3+M34*Paramètres!$C$4+Encodage!N34*Paramètres!$C$5+Encodage!O34*Paramètres!$C$6+P34*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D34,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z34*(1-AA34)+(Z34*AA34*DJ!$D$2/VLOOKUP(Encodage!A34,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D34,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D35,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L35*Paramètres!$C$3+M35*Paramètres!$C$4+Encodage!N35*Paramètres!$C$5+Encodage!O35*Paramètres!$C$6+P35*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D35,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z35*(1-AA35)+(Z35*AA35*DJ!$D$2/VLOOKUP(Encodage!A35,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D35,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D36,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L36*Paramètres!$C$3+M36*Paramètres!$C$4+Encodage!N36*Paramètres!$C$5+Encodage!O36*Paramètres!$C$6+P36*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D36,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z36*(1-AA36)+(Z36*AA36*DJ!$D$2/VLOOKUP(Encodage!A36,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D36,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D37,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L37*Paramètres!$C$3+M37*Paramètres!$C$4+Encodage!N37*Paramètres!$C$5+Encodage!O37*Paramètres!$C$6+P37*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D37,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z37*(1-AA37)+(Z37*AA37*DJ!$D$2/VLOOKUP(Encodage!A37,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D37,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D38,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L38*Paramètres!$C$3+M38*Paramètres!$C$4+Encodage!N38*Paramètres!$C$5+Encodage!O38*Paramètres!$C$6+P38*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D38,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z38*(1-AA38)+(Z38*AA38*DJ!$D$2/VLOOKUP(Encodage!A38,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D38,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D39,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L39*Paramètres!$C$3+M39*Paramètres!$C$4+Encodage!N39*Paramètres!$C$5+Encodage!O39*Paramètres!$C$6+P39*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D39,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z39*(1-AA39)+(Z39*AA39*DJ!$D$2/VLOOKUP(Encodage!A39,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D39,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2014,"Total",{"$f":"SUM(C28:C39)","v":0},null,null,null,null,{"$f":"SUM(H28:H39)","v":0},{"$f":"SUM(I28:I39)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R28:R39)","v":0},{"$f":"SUM(S28:S39)","v":0},null,{"$f":"SUM(U28:U39)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z28:Z39)","v":0},null,{"$f":"SUM(AB28:AB39)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]
[]
[{"$f":"A27+1","v":2015}]
[{"$f":"A42","v":2015},{"$f":"B28","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,{"$f":"IF(R43=0,,R43/R28-1)","v":0},{"$f":"IF(H43<>0,H43,I43+J43)","v":0},{"$f":"IFERROR(J43/U43,\"NA\")","v":"NA"},{"$f":"IF(U43=0,0,U43/U28-1)","v":0},{"$f":"IFERROR(U43/C43,0)","v":0},{"$f":"VLOOKUP(D43,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L43*Paramètres!$C$3+M43*Paramètres!$C$4+Encodage!N43*Paramètres!$C$5+Encodage!O43*Paramètres!$C$6+P43*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D43,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z43*(1-AA43)+(Z43*AA43*DJ!$D$2/VLOOKUP(Encodage!A43,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB43/C43,0)","v":0},{"$f":"IF(AB43=0,,AB43/AB28-1)","v":0},{"$f":"VLOOKUP(D43,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC43/AC$13,\"\")","v":""},{"$f":"AB43*AC43","v":0}]
[{"$f":"A43","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,{"$f":"IF(R44=0,,R44/R29-1)","v":0},0,"NA",{"$f":"IF(U44=0,0,U44/U29-1)","v":0},0,{"$f":"VLOOKUP(D44,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L44*Paramètres!$C$3+M44*Paramètres!$C$4+Encodage!N44*Paramètres!$C$5+Encodage!O44*Paramètres!$C$6+P44*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D44,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z44*(1-AA44)+(Z44*AA44*DJ!$D$2/VLOOKUP(Encodage!A44,DJ!$A$2:$D$14,4)),0)","v":0},0,{"$f":"IF(AB44=0,,AB44/AB29-1)","v":0},{"$f":"VLOOKUP(D44,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A44","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,0,0,"NA",0,0,{"$f":"VLOOKUP(D45,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L45*Paramètres!$C$3+M45*Paramètres!$C$4+Encodage!N45*Paramètres!$C$5+Encodage!O45*Paramètres!$C$6+P45*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D45,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z45*(1-AA45)+(Z45*AA45*DJ!$D$2/VLOOKUP(Encodage!A45,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D45,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Bâtiment 4",0,"A sélectionner dans la liste déroulante",0,{"$f":"F31","v":"à encoder"},"à encoder",null,null,null,null,null,null,null,null,null,null,null,null,0,0,"NA",0,0,{"$f":"VLOOKUP(D46,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L46*Paramètres!$C$3+M46*Paramètres!$C$4+Encodage!N46*Paramètres!$C$5+Encodage!O46*Paramètres!$C$6+P46*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D46,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z46*(1-AA46)+(Z46*AA46*DJ!$D$2/VLOOKUP(Encodage!A46,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D46,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D47,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L47*Paramètres!$C$3+M47*Paramètres!$C$4+Encodage!N47*Paramètres!$C$5+Encodage!O47*Paramètres!$C$6+P47*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D47,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z47*(1-AA47)+(Z47*AA47*DJ!$D$2/VLOOKUP(Encodage!A47,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D47,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D48,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L48*Paramètres!$C$3+M48*Paramètres!$C$4+Encodage!N48*Paramètres!$C$5+Encodage!O48*Paramètres!$C$6+P48*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D48,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z48*(1-AA48)+(Z48*AA48*DJ!$D$2/VLOOKUP(Encodage!A48,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D48,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D49,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L49*Paramètres!$C$3+M49*Paramètres!$C$4+Encodage!N49*Paramètres!$C$5+Encodage!O49*Paramètres!$C$6+P49*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D49,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z49*(1-AA49)+(Z49*AA49*DJ!$D$2/VLOOKUP(Encodage!A49,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D49,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D50,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L50*Paramètres!$C$3+M50*Paramètres!$C$4+Encodage!N50*Paramètres!$C$5+Encodage!O50*Paramètres!$C$6+P50*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D50,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z50*(1-AA50)+(Z50*AA50*DJ!$D$2/VLOOKUP(Encodage!A50,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D50,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D51,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L51*Paramètres!$C$3+M51*Paramètres!$C$4+Encodage!N51*Paramètres!$C$5+Encodage!O51*Paramètres!$C$6+P51*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D51,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z51*(1-AA51)+(Z51*AA51*DJ!$D$2/VLOOKUP(Encodage!A51,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D51,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D52,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L52*Paramètres!$C$3+M52*Paramètres!$C$4+Encodage!N52*Paramètres!$C$5+Encodage!O52*Paramètres!$C$6+P52*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D52,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z52*(1-AA52)+(Z52*AA52*DJ!$D$2/VLOOKUP(Encodage!A52,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D52,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D53,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L53*Paramètres!$C$3+M53*Paramètres!$C$4+Encodage!N53*Paramètres!$C$5+Encodage!O53*Paramètres!$C$6+P53*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D53,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z53*(1-AA53)+(Z53*AA53*DJ!$D$2/VLOOKUP(Encodage!A53,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D53,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D54,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L54*Paramètres!$C$3+M54*Paramètres!$C$4+Encodage!N54*Paramètres!$C$5+Encodage!O54*Paramètres!$C$6+P54*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D54,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z54*(1-AA54)+(Z54*AA54*DJ!$D$2/VLOOKUP(Encodage!A54,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D54,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2015,"Total",{"$f":"SUM(C43:C54)","v":0},null,null,null,null,{"$f":"SUM(H43:H54)","v":0},{"$f":"SUM(I43:I54)","v":0},{"$f":"SUM(J43:J54)","v":0},{"$f":"SUM(K43:K54)","v":0},{"$f":"SUM(L43:L54)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(U43:U54)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z43:Z54)","v":0},null,{"$f":"SUM(AB43:AB54)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]
[]
[{"$f":"A42+1","v":2016}]
[{"$f":"A57","v":2016},{"$f":"B43","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F43","v":"à encoder"},{"$f":"G43","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R58=0,,R58/R43-1)","v":0},{"$f":"IF(H58<>0,H58,I58+J58)","v":0},{"$f":"IFERROR(J58/U58,\"NA\")","v":"NA"},{"$f":"IF(U58=0,0,U58/U43-1)","v":0},{"$f":"IFERROR(U58/C58,0)","v":0},{"$f":"VLOOKUP(D58,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L58*Paramètres!$C$3+M58*Paramètres!$C$4+Encodage!N58*Paramètres!$C$5+Encodage!O58*Paramètres!$C$6+P58*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D58,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z58*(1-AA58)+(Z58*AA58*DJ!$D$2/VLOOKUP(Encodage!A58,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB58/C58,0)","v":0},{"$f":"IF(AB58=0,,AB58/AB43-1)","v":0},{"$f":"VLOOKUP(D58,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC58/AC$13,\"\")","v":""},{"$f":"AB58*AC58","v":0}]
[{"$f":"A58","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,{"$f":"IF(R59=0,,R59/R44-1)","v":0},0,"NA",{"$f":"IF(U59=0,0,U59/U44-1)","v":0},0,{"$f":"VLOOKUP(D59,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L59*Paramètres!$C$3+M59*Paramètres!$C$4+Encodage!N59*Paramètres!$C$5+Encodage!O59*Paramètres!$C$6+P59*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D59,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z59*(1-AA59)+(Z59*AA59*DJ!$D$2/VLOOKUP(Encodage!A59,DJ!$A$2:$D$14,4)),0)","v":0},0,{"$f":"IF(AB59=0,,AB59/AB44-1)","v":0},{"$f":"VLOOKUP(D59,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A59","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,0,0,"NA",0,0,{"$f":"VLOOKUP(D60,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L60*Paramètres!$C$3+M60*Paramètres!$C$4+Encodage!N60*Paramètres!$C$5+Encodage!O60*Paramètres!$C$6+P60*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D60,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z60*(1-AA60)+(Z60*AA60*DJ!$D$2/VLOOKUP(Encodage!A60,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D60,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D61,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L61*Paramètres!$C$3+M61*Paramètres!$C$4+Encodage!N61*Paramètres!$C$5+Encodage!O61*Paramètres!$C$6+P61*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D61,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z61*(1-AA61)+(Z61*AA61*DJ!$D$2/VLOOKUP(Encodage!A61,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D61,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D62,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L62*Paramètres!$C$3+M62*Paramètres!$C$4+Encodage!N62*Paramètres!$C$5+Encodage!O62*Paramètres!$C$6+P62*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D62,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z62*(1-AA62)+(Z62*AA62*DJ!$D$2/VLOOKUP(Encodage!A62,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D62,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D63,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L63*Paramètres!$C$3+M63*Paramètres!$C$4+Encodage!N63*Paramètres!$C$5+Encodage!O63*Paramètres!$C$6+P63*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D63,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z63*(1-AA63)+(Z63*AA63*DJ!$D$2/VLOOKUP(Encodage!A63,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D63,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D64,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L64*Paramètres!$C$3+M64*Paramètres!$C$4+Encodage!N64*Paramètres!$C$5+Encodage!O64*Paramètres!$C$6+P64*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D64,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z64*(1-AA64)+(Z64*AA64*DJ!$D$2/VLOOKUP(Encodage!A64,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D64,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D65,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L65*Paramètres!$C$3+M65*Paramètres!$C$4+Encodage!N65*Paramètres!$C$5+Encodage!O65*Paramètres!$C$6+P65*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D65,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z65*(1-AA65)+(Z65*AA65*DJ!$D$2/VLOOKUP(Encodage!A65,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D65,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D66,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L66*Paramètres!$C$3+M66*Paramètres!$C$4+Encodage!N66*Paramètres!$C$5+Encodage!O66*Paramètres!$C$6+P66*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D66,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z66*(1-AA66)+(Z66*AA66*DJ!$D$2/VLOOKUP(Encodage!A66,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D66,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D67,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L67*Paramètres!$C$3+M67*Paramètres!$C$4+Encodage!N67*Paramètres!$C$5+Encodage!O67*Paramètres!$C$6+P67*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D67,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z67*(1-AA67)+(Z67*AA67*DJ!$D$2/VLOOKUP(Encodage!A67,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D67,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D68,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L68*Paramètres!$C$3+M68*Paramètres!$C$4+Encodage!N68*Paramètres!$C$5+Encodage!O68*Paramètres!$C$6+P68*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D68,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z68*(1-AA68)+(Z68*AA68*DJ!$D$2/VLOOKUP(Encodage!A68,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D68,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,0,0,"NA",0,0,{"$f":"VLOOKUP(D69,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L69*Paramètres!$C$3+M69*Paramètres!$C$4+Encodage!N69*Paramètres!$C$5+Encodage!O69*Paramètres!$C$6+P69*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D69,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z69*(1-AA69)+(Z69*AA69*DJ!$D$2/VLOOKUP(Encodage!A69,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D69,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2016,"Total",{"$f":"SUM(C58:C69)","v":0},null,null,null,null,{"$f":"SUM(H58:H69)","v":0},{"$f":"SUM(I58:I69)","v":0},{"$f":"SUM(J58:J69)","v":0},{"$f":"SUM(K58:K69)","v":0},{"$f":"SUM(L58:L69)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(U58:U69)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z58:Z69)","v":0},null,{"$f":"SUM(AB58:AB69)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]
[]
[{"$f":"A57+1","v":2017}]
[{"$f":"A72","v":2017},{"$f":"B58","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F58","v":"à encoder"},{"$f":"G58","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R73=0,,R73/R58-1)","v":0},{"$f":"IF(H73<>0,H73,I73+J73)","v":0},{"$f":"IFERROR(J73/U73,\"NA\")","v":"NA"},{"$f":"IF(U73=0,0,U73/U58-1)","v":0},{"$f":"IFERROR(U73/C73,0)","v":0},{"$f":"VLOOKUP(D73,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L73*Paramètres!$C$3+M73*Paramètres!$C$4+Encodage!N73*Paramètres!$C$5+Encodage!O73*Paramètres!$C$6+P73*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D73,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z73*(1-AA73)+(Z73*AA73*DJ!$D$2/VLOOKUP(Encodage!A73,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB73/C73,0)","v":0},{"$f":"IF(AB73=0,,AB73/AB58-1)","v":0},{"$f":"VLOOKUP(D73,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC73/AC$13,\"\")","v":""},{"$f":"AB73*AC73","v":0}]
[{"$f":"A73","v":2017},"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,{"$f":"IF(R74=0,,R74/R59-1)","v":0},0,"NA",{"$f":"IF(U74=0,0,U74/U59-1)","v":0},0,{"$f":"VLOOKUP(D74,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L74*Paramètres!$C$3+M74*Paramètres!$C$4+Encodage!N74*Paramètres!$C$5+Encodage!O74*Paramètres!$C$6+P74*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D74,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z74*(1-AA74)+(Z74*AA74*DJ!$D$2/VLOOKUP(Encodage!A74,DJ!$A$2:$D$14,4)),0)","v":0},0,{"$f":"IF(AB74=0,,AB74/AB59-1)","v":0},{"$f":"VLOOKUP(D74,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A74","v":2017},"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D75,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L75*Paramètres!$C$3+M75*Paramètres!$C$4+Encodage!N75*Paramètres!$C$5+Encodage!O75*Paramètres!$C$6+P75*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D75,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z75*(1-AA75)+(Z75*AA75*DJ!$D$2/VLOOKUP(Encodage!A75,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D75,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D76,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L76*Paramètres!$C$3+M76*Paramètres!$C$4+Encodage!N76*Paramètres!$C$5+Encodage!O76*Paramètres!$C$6+P76*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D76,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z76*(1-AA76)+(Z76*AA76*DJ!$D$2/VLOOKUP(Encodage!A76,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D76,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D77,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L77*Paramètres!$C$3+M77*Paramètres!$C$4+Encodage!N77*Paramètres!$C$5+Encodage!O77*Paramètres!$C$6+P77*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D77,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z77*(1-AA77)+(Z77*AA77*DJ!$D$2/VLOOKUP(Encodage!A77,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D77,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D78,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L78*Paramètres!$C$3+M78*Paramètres!$C$4+Encodage!N78*Paramètres!$C$5+Encodage!O78*Paramètres!$C$6+P78*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D78,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z78*(1-AA78)+(Z78*AA78*DJ!$D$2/VLOOKUP(Encodage!A78,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D78,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D79,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L79*Paramètres!$C$3+M79*Paramètres!$C$4+Encodage!N79*Paramètres!$C$5+Encodage!O79*Paramètres!$C$6+P79*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D79,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z79*(1-AA79)+(Z79*AA79*DJ!$D$2/VLOOKUP(Encodage!A79,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D79,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D80,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L80*Paramètres!$C$3+M80*Paramètres!$C$4+Encodage!N80*Paramètres!$C$5+Encodage!O80*Paramètres!$C$6+P80*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D80,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z80*(1-AA80)+(Z80*AA80*DJ!$D$2/VLOOKUP(Encodage!A80,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D80,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D81,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L81*Paramètres!$C$3+M81*Paramètres!$C$4+Encodage!N81*Paramètres!$C$5+Encodage!O81*Paramètres!$C$6+P81*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D81,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z81*(1-AA81)+(Z81*AA81*DJ!$D$2/VLOOKUP(Encodage!A81,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D81,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D82,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L82*Paramètres!$C$3+M82*Paramètres!$C$4+Encodage!N82*Paramètres!$C$5+Encodage!O82*Paramètres!$C$6+P82*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D82,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z82*(1-AA82)+(Z82*AA82*DJ!$D$2/VLOOKUP(Encodage!A82,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D82,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D83,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L83*Paramètres!$C$3+M83*Paramètres!$C$4+Encodage!N83*Paramètres!$C$5+Encodage!O83*Paramètres!$C$6+P83*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D83,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z83*(1-AA83)+(Z83*AA83*DJ!$D$2/VLOOKUP(Encodage!A83,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D83,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D84,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L84*Paramètres!$C$3+M84*Paramètres!$C$4+Encodage!N84*Paramètres!$C$5+Encodage!O84*Paramètres!$C$6+P84*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D84,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z84*(1-AA84)+(Z84*AA84*DJ!$D$2/VLOOKUP(Encodage!A84,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D84,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2017,"Total",{"$f":"SUM(C73:C84)","v":0},null,null,null,null,{"$f":"SUM(H73:H84)","v":0},{"$f":"SUM(I73:I84)","v":0},{"$f":"SUM(J73:J84)","v":0},{"$f":"SUM(K73:K84)","v":0},{"$f":"SUM(L73:L84)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(U73:U84)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z73:Z84)","v":0},null,{"$f":"SUM(AB73:AB84)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]
[]
[{"$f":"A72+1","v":2018}]
[{"$f":"A87","v":2018},{"$f":"B73","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F73","v":"à encoder"},{"$f":"G73","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R88=0,,R88/R73-1)","v":0},{"$f":"IF(H88<>0,H88,I88+J88)","v":0},{"$f":"IFERROR(J88/U88,\"NA\")","v":"NA"},{"$f":"IF(U88=0,0,U88/U73-1)","v":0},{"$f":"IFERROR(U88/C88,0)","v":0},{"$f":"VLOOKUP(D88,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L88*Paramètres!$C$3+M88*Paramètres!$C$4+Encodage!N88*Paramètres!$C$5+Encodage!O88*Paramètres!$C$6+P88*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D88,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z88*(1-AA88)+(Z88*AA88*DJ!$D$2/VLOOKUP(Encodage!A88,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB88/C88,0)","v":0},{"$f":"IF(AB88=0,,AB88/AB73-1)","v":0},{"$f":"VLOOKUP(D88,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC88/AC$13,\"\")","v":""},{"$f":"AB88*AC88","v":0}]
[{"$f":"A88","v":2018},"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,{"$f":"IF(R89=0,,R89/R74-1)","v":0},0,"NA",{"$f":"IF(U89=0,0,U89/U74-1)","v":0},0,{"$f":"VLOOKUP(D89,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L89*Paramètres!$C$3+M89*Paramètres!$C$4+Encodage!N89*Paramètres!$C$5+Encodage!O89*Paramètres!$C$6+P89*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D89,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z89*(1-AA89)+(Z89*AA89*DJ!$D$2/VLOOKUP(Encodage!A89,DJ!$A$2:$D$14,4)),0)","v":0},0,{"$f":"IF(AB89=0,,AB89/AB74-1)","v":0},{"$f":"VLOOKUP(D89,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A89","v":2018},"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D90,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L90*Paramètres!$C$3+M90*Paramètres!$C$4+Encodage!N90*Paramètres!$C$5+Encodage!O90*Paramètres!$C$6+P90*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D90,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z90*(1-AA90)+(Z90*AA90*DJ!$D$2/VLOOKUP(Encodage!A90,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D90,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D91,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L91*Paramètres!$C$3+M91*Paramètres!$C$4+Encodage!N91*Paramètres!$C$5+Encodage!O91*Paramètres!$C$6+P91*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D91,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z91*(1-AA91)+(Z91*AA91*DJ!$D$2/VLOOKUP(Encodage!A91,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D91,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D92,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L92*Paramètres!$C$3+M92*Paramètres!$C$4+Encodage!N92*Paramètres!$C$5+Encodage!O92*Paramètres!$C$6+P92*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D92,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z92*(1-AA92)+(Z92*AA92*DJ!$D$2/VLOOKUP(Encodage!A92,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D92,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D93,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L93*Paramètres!$C$3+M93*Paramètres!$C$4+Encodage!N93*Paramètres!$C$5+Encodage!O93*Paramètres!$C$6+P93*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D93,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z93*(1-AA93)+(Z93*AA93*DJ!$D$2/VLOOKUP(Encodage!A93,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D93,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D94,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L94*Paramètres!$C$3+M94*Paramètres!$C$4+Encodage!N94*Paramètres!$C$5+Encodage!O94*Paramètres!$C$6+P94*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D94,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z94*(1-AA94)+(Z94*AA94*DJ!$D$2/VLOOKUP(Encodage!A94,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D94,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D95,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L95*Paramètres!$C$3+M95*Paramètres!$C$4+Encodage!N95*Paramètres!$C$5+Encodage!O95*Paramètres!$C$6+P95*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D95,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z95*(1-AA95)+(Z95*AA95*DJ!$D$2/VLOOKUP(Encodage!A95,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D95,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D96,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L96*Paramètres!$C$3+M96*Paramètres!$C$4+Encodage!N96*Paramètres!$C$5+Encodage!O96*Paramètres!$C$6+P96*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D96,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z96*(1-AA96)+(Z96*AA96*DJ!$D$2/VLOOKUP(Encodage!A96,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D96,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D97,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L97*Paramètres!$C$3+M97*Paramètres!$C$4+Encodage!N97*Paramètres!$C$5+Encodage!O97*Paramètres!$C$6+P97*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D97,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z97*(1-AA97)+(Z97*AA97*DJ!$D$2/VLOOKUP(Encodage!A97,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D97,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D98,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L98*Paramètres!$C$3+M98*Paramètres!$C$4+Encodage!N98*Paramètres!$C$5+Encodage!O98*Paramètres!$C$6+P98*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D98,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z98*(1-AA98)+(Z98*AA98*DJ!$D$2/VLOOKUP(Encodage!A98,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D98,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D99,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L99*Paramètres!$C$3+M99*Paramètres!$C$4+Encodage!N99*Paramètres!$C$5+Encodage!O99*Paramètres!$C$6+P99*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D99,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z99*(1-AA99)+(Z99*AA99*DJ!$D$2/VLOOKUP(Encodage!A99,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D99,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2018,"Total",{"$f":"SUM(C88:C99)","v":0},null,null,null,null,{"$f":"SUM(H88:H99)","v":0},{"$f":"SUM(I88:I99)","v":0},{"$f":"SUM(J88:J99)","v":0},{"$f":"SUM(K88:K99)","v":0},{"$f":"SUM(L88:L99)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(U88:U99)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z88:Z99)","v":0},null,{"$f":"SUM(AB88:AB99)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]
[]
[{"$f":"A87+1","v":2019}]
[{"$f":"A102","v":2019},{"$f":"B88","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F88","v":"à encoder"},{"$f":"G88","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R103=0,,R103/R88-1)","v":0},{"$f":"IF(H103<>0,H103,I103+J103)","v":0},{"$f":"IFERROR(J103/U103,\"NA\")","v":"NA"},{"$f":"IF(U103=0,0,U103/U88-1)","v":0},{"$f":"IFERROR(U103/C103,0)","v":0},{"$f":"VLOOKUP(D103,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L103*Paramètres!$C$3+M103*Paramètres!$C$4+Encodage!N103*Paramètres!$C$5+Encodage!O103*Paramètres!$C$6+P103*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D103,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z103*(1-AA103)+(Z103*AA103*DJ!$D$2/VLOOKUP(Encodage!A103,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB103/C103,0)","v":0},{"$f":"IF(AB103=0,,AB103/AB88-1)","v":0},{"$f":"VLOOKUP(D103,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC103/AC$13,\"\")","v":""},{"$f":"AB103*AC103","v":0}]
[{"$f":"A103","v":2019},"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,{"$f":"IF(R104=0,,R104/R89-1)","v":0},0,"NA",{"$f":"IF(U104=0,0,U104/U89-1)","v":0},0,{"$f":"VLOOKUP(D104,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L104*Paramètres!$C$3+M104*Paramètres!$C$4+Encodage!N104*Paramètres!$C$5+Encodage!O104*Paramètres!$C$6+P104*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D104,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z104*(1-AA104)+(Z104*AA104*DJ!$D$2/VLOOKUP(Encodage!A104,DJ!$A$2:$D$14,4)),0)","v":0},0,{"$f":"IF(AB104=0,,AB104/AB89-1)","v":0},{"$f":"VLOOKUP(D104,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A104","v":2019},"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D105,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L105*Paramètres!$C$3+M105*Paramètres!$C$4+Encodage!N105*Paramètres!$C$5+Encodage!O105*Paramètres!$C$6+P105*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D105,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z105*(1-AA105)+(Z105*AA105*DJ!$D$2/VLOOKUP(Encodage!A105,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D105,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D106,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L106*Paramètres!$C$3+M106*Paramètres!$C$4+Encodage!N106*Paramètres!$C$5+Encodage!O106*Paramètres!$C$6+P106*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D106,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z106*(1-AA106)+(Z106*AA106*DJ!$D$2/VLOOKUP(Encodage!A106,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D106,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D107,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L107*Paramètres!$C$3+M107*Paramètres!$C$4+Encodage!N107*Paramètres!$C$5+Encodage!O107*Paramètres!$C$6+P107*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D107,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z107*(1-AA107)+(Z107*AA107*DJ!$D$2/VLOOKUP(Encodage!A107,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D107,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D108,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L108*Paramètres!$C$3+M108*Paramètres!$C$4+Encodage!N108*Paramètres!$C$5+Encodage!O108*Paramètres!$C$6+P108*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D108,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z108*(1-AA108)+(Z108*AA108*DJ!$D$2/VLOOKUP(Encodage!A108,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D108,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D109,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L109*Paramètres!$C$3+M109*Paramètres!$C$4+Encodage!N109*Paramètres!$C$5+Encodage!O109*Paramètres!$C$6+P109*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D109,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z109*(1-AA109)+(Z109*AA109*DJ!$D$2/VLOOKUP(Encodage!A109,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D109,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D110,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L110*Paramètres!$C$3+M110*Paramètres!$C$4+Encodage!N110*Paramètres!$C$5+Encodage!O110*Paramètres!$C$6+P110*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D110,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z110*(1-AA110)+(Z110*AA110*DJ!$D$2/VLOOKUP(Encodage!A110,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D110,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D111,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L111*Paramètres!$C$3+M111*Paramètres!$C$4+Encodage!N111*Paramètres!$C$5+Encodage!O111*Paramètres!$C$6+P111*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D111,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z111*(1-AA111)+(Z111*AA111*DJ!$D$2/VLOOKUP(Encodage!A111,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D111,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D112,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L112*Paramètres!$C$3+M112*Paramètres!$C$4+Encodage!N112*Paramètres!$C$5+Encodage!O112*Paramètres!$C$6+P112*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D112,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z112*(1-AA112)+(Z112*AA112*DJ!$D$2/VLOOKUP(Encodage!A112,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D112,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D113,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L113*Paramètres!$C$3+M113*Paramètres!$C$4+Encodage!N113*Paramètres!$C$5+Encodage!O113*Paramètres!$C$6+P113*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D113,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z113*(1-AA113)+(Z113*AA113*DJ!$D$2/VLOOKUP(Encodage!A113,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D113,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D114,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L114*Paramètres!$C$3+M114*Paramètres!$C$4+Encodage!N114*Paramètres!$C$5+Encodage!O114*Paramètres!$C$6+P114*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D114,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z114*(1-AA114)+(Z114*AA114*DJ!$D$2/VLOOKUP(Encodage!A114,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D114,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2019,"Total",{"$f":"SUM(C103:C114)","v":0},null,null,null,null,{"$f":"SUM(H103:H114)","v":0},{"$f":"SUM(I103:I114)","v":0},{"$f":"SUM(J103:J114)","v":0},{"$f":"SUM(K103:K114)","v":0},{"$f":"SUM(L103:L114)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(U103:U114)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z103:Z114)","v":0},null,{"$f":"SUM(AB103:AB114)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]
[]
[{"$f":"A102+1","v":2020}]
[{"$f":"A117","v":2020},{"$f":"B103","v":"Bâtiment 1"},0,"A sélectionner dans la liste déroulante",0,{"$f":"F103","v":"à encoder"},{"$f":"G103","v":"à encoder"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R118=0,,R118/R103-1)","v":0},{"$f":"IF(H118<>0,H118,I118+J118)","v":0},{"$f":"IFERROR(J118/U118,\"NA\")","v":"NA"},{"$f":"IF(U118=0,0,U118/U103-1)","v":0},{"$f":"IFERROR(U118/C118,0)","v":0},{"$f":"VLOOKUP(D118,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L118*Paramètres!$C$3+M118*Paramètres!$C$4+Encodage!N118*Paramètres!$C$5+Encodage!O118*Paramètres!$C$6+P118*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D118,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z118*(1-AA118)+(Z118*AA118*DJ!$D$2/VLOOKUP(Encodage!A118,DJ!$A$2:$D$14,4)),0)","v":0},{"$f":"IFERROR(AB118/C118,0)","v":0},{"$f":"IF(AB118=0,,AB118/AB103-1)","v":0},{"$f":"VLOOKUP(D118,Paramètres!$A$24:$D$36,2)","v":100},{"$f":"IFERROR(AC118/AC$13,\"\")","v":""},{"$f":"AB118*AC118","v":0}]
[{"$f":"A118","v":2020},"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,{"$f":"IF(R119=0,,R119/R104-1)","v":0},0,"NA",{"$f":"IF(U119=0,0,U119/U104-1)","v":0},0,{"$f":"VLOOKUP(D119,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L119*Paramètres!$C$3+M119*Paramètres!$C$4+Encodage!N119*Paramètres!$C$5+Encodage!O119*Paramètres!$C$6+P119*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D119,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z119*(1-AA119)+(Z119*AA119*DJ!$D$2/VLOOKUP(Encodage!A119,DJ!$A$2:$D$14,4)),0)","v":0},0,{"$f":"IF(AB119=0,,AB119/AB104-1)","v":0},{"$f":"VLOOKUP(D119,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[{"$f":"A119","v":2020},"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D120,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L120*Paramètres!$C$3+M120*Paramètres!$C$4+Encodage!N120*Paramètres!$C$5+Encodage!O120*Paramètres!$C$6+P120*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D120,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z120*(1-AA120)+(Z120*AA120*DJ!$D$2/VLOOKUP(Encodage!A120,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D120,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D121,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L121*Paramètres!$C$3+M121*Paramètres!$C$4+Encodage!N121*Paramètres!$C$5+Encodage!O121*Paramètres!$C$6+P121*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D121,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z121*(1-AA121)+(Z121*AA121*DJ!$D$2/VLOOKUP(Encodage!A121,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D121,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D122,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L122*Paramètres!$C$3+M122*Paramètres!$C$4+Encodage!N122*Paramètres!$C$5+Encodage!O122*Paramètres!$C$6+P122*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D122,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z122*(1-AA122)+(Z122*AA122*DJ!$D$2/VLOOKUP(Encodage!A122,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D122,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D123,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L123*Paramètres!$C$3+M123*Paramètres!$C$4+Encodage!N123*Paramètres!$C$5+Encodage!O123*Paramètres!$C$6+P123*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D123,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z123*(1-AA123)+(Z123*AA123*DJ!$D$2/VLOOKUP(Encodage!A123,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D123,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D124,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L124*Paramètres!$C$3+M124*Paramètres!$C$4+Encodage!N124*Paramètres!$C$5+Encodage!O124*Paramètres!$C$6+P124*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D124,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z124*(1-AA124)+(Z124*AA124*DJ!$D$2/VLOOKUP(Encodage!A124,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D124,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D125,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L125*Paramètres!$C$3+M125*Paramètres!$C$4+Encodage!N125*Paramètres!$C$5+Encodage!O125*Paramètres!$C$6+P125*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D125,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z125*(1-AA125)+(Z125*AA125*DJ!$D$2/VLOOKUP(Encodage!A125,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D125,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D126,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L126*Paramètres!$C$3+M126*Paramètres!$C$4+Encodage!N126*Paramètres!$C$5+Encodage!O126*Paramètres!$C$6+P126*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D126,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z126*(1-AA126)+(Z126*AA126*DJ!$D$2/VLOOKUP(Encodage!A126,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D126,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D127,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L127*Paramètres!$C$3+M127*Paramètres!$C$4+Encodage!N127*Paramètres!$C$5+Encodage!O127*Paramètres!$C$6+P127*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D127,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z127*(1-AA127)+(Z127*AA127*DJ!$D$2/VLOOKUP(Encodage!A127,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D127,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D128,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L128*Paramètres!$C$3+M128*Paramètres!$C$4+Encodage!N128*Paramètres!$C$5+Encodage!O128*Paramètres!$C$6+P128*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D128,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z128*(1-AA128)+(Z128*AA128*DJ!$D$2/VLOOKUP(Encodage!A128,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D128,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"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,0,0,"NA",0,0,{"$f":"VLOOKUP(D129,Paramètres!$A$24:$D$36,3)","v":100},{"$f":"L129*Paramètres!$C$3+M129*Paramètres!$C$4+Encodage!N129*Paramètres!$C$5+Encodage!O129*Paramètres!$C$6+P129*Paramètres!$C$7","v":0},{"$f":"VLOOKUP(D129,Paramètres!$A$24:$E$36,5)","v":0.85},{"$f":"IFERROR(Z129*(1-AA129)+(Z129*AA129*DJ!$D$2/VLOOKUP(Encodage!A129,DJ!$A$2:$D$14,4)),0)","v":0},0,0,{"$f":"VLOOKUP(D129,Paramètres!$A$24:$D$36,2)","v":100},"",0]
[2020,"Total",{"$f":"SUM(C118:C129)","v":0},null,null,null,null,{"$f":"SUM(H118:H129)","v":0},{"$f":"SUM(I118:I129)","v":0},{"$f":"SUM(J118:J129)","v":0},{"$f":"SUM(K118:K129)","v":0},{"$f":"SUM(L118:L129)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(U118:U129)","v":0},null,null,0,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"SUM(Z118:Z129)","v":0},null,{"$f":"SUM(AB118:AB129)","v":0},0,null,{"$f":"VLOOKUP($D$5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},""]

{"sheet":"Resumé","index":4,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,9]]}
[null,"Evolution des consommations totales de tous les bâtiments"]
[]
[null,"Consommations",{"$f":"Encodage!D3","v":2013},{"$f":"C3+1","v":2014},2015,2016,2017,2018,2019,2020]
[null,"Consommation Elec totale [kWh]",{"$f":"Encodage!$U25","v":0},{"$f":"Encodage!U40","v":0},{"$f":"Encodage!U55","v":0},{"$f":"Encodage!$U70","v":0},{"$f":"Encodage!$U85","v":0},{"$f":"Encodage!$U100","v":0},{"$f":"Encodage!$U115","v":0},{"$f":"Encodage!$U130","v":0}]
[null,"Cons. Elec heures pleines [kWh]",{"$f":"Encodage!$I25","v":0},{"$f":"Encodage!I40","v":0},{"$f":"Encodage!I55","v":0},{"$f":"Encodage!$I70","v":0},{"$f":"Encodage!$I85","v":0},{"$f":"Encodage!$I100","v":0},{"$f":"Encodage!$I115","v":0},{"$f":"Encodage!$I130","v":0}]
[null,"Cons. Elec heures creuses [kWh]",{"$f":"Encodage!$J25","v":0},{"$f":"Encodage!J40","v":0},{"$f":"Encodage!J55","v":0},{"$f":"Encodage!$J70","v":0},{"$f":"Encodage!$J85","v":0},{"$f":"Encodage!$J100","v":0},{"$f":"Encodage!$J115","v":0},{"$f":"Encodage!$J130","v":0}]
[null,"Cons. élect spécifique [kWh/m²]",{"$f":"IFERROR(Encodage!$X25,0)","v":0},{"$f":"IFERROR(Encodage!$X40,0)","v":0},{"$f":"IFERROR(Encodage!$X55,0)","v":0},{"$f":"IFERROR(Encodage!$X70,0)","v":0},{"$f":"IFERROR(Encodage!$X85,0)","v":0},{"$f":"IFERROR(Encodage!$X100,0)","v":0},{"$f":"IFERROR(Encodage!$X115,0)","v":0},{"$f":"IFERROR(Encodage!$X130,0)","v":0}]
[null,{"$f":"\"Cons. moyenne du secteur (= \"&C8&\" kWh/m²)\"","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Encodage!D5,Paramètres!$A$24:$D$36,3)","v":{"$error":"#N/A"}},{"$f":"$C$8","v":{"$error":"#N/A"}},{"$f":"$C$8","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Consommation de combustibles [kWhi]",{"$f":"Encodage!$Z25","v":0},{"$f":"Encodage!Z40","v":0},{"$f":"Encodage!Z55","v":0},{"$f":"Encodage!$Z70","v":0},{"$f":"Encodage!$Z85","v":0},{"$f":"Encodage!$Z100","v":0},{"$f":"Encodage!$Z115","v":0},{"$f":"Encodage!$Z130","v":0}]
[null,"Cons. de combustible normalisé [kWhi]",{"$f":"Encodage!$AB25","v":0},{"$f":"Encodage!$AB40","v":0},{"$f":"Encodage!$AB55","v":0},{"$f":"Encodage!$AB70","v":0},{"$f":"Encodage!$AB85","v":0},{"$f":"Encodage!$AB100","v":0},{"$f":"Encodage!$AB115","v":0},{"$f":"Encodage!$AB130","v":0}]
[null,"Cons. combustible spécifique normalisée [kWhi/m²]",{"$f":"IFERROR(Encodage!$AC25,0)","v":0},{"$f":"IFERROR(Encodage!AC40,0)","v":0},{"$f":"IFERROR(Encodage!AC55,0)","v":0},{"$f":"IFERROR(Encodage!$AC70,0)","v":0},{"$f":"IFERROR(Encodage!$AC85,0)","v":0},{"$f":"IFERROR(Encodage!$AC100,0)","v":0},{"$f":"IFERROR(Encodage!$AC115,0)","v":0},{"$f":"IFERROR(Encodage!$AC130,0)","v":0}]
[null,{"$f":"\"Consommation moyenne du secteur (= \"&C12&\" kWh/m²)\"","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Encodage!D5,Paramètres!$A$24:$D$36,2)","v":{"$error":"#N/A"}},{"$f":"$C$12","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Degrés jours (16,5/16,5)",{"$f":"VLOOKUP(C3,DJ!$A$3:$D$14,4)","v":2537},{"$f":"VLOOKUP(D3,DJ!$A$3:$D$14,4)","v":1828},{"$f":"VLOOKUP(E3,DJ!$A$3:$D$14,4)","v":2112},{"$f":"VLOOKUP(F3,DJ!$A$3:$D$14,4)","v":0},{"$f":"VLOOKUP(G3,DJ!$A$3:$D$14,4)","v":0},{"$f":"VLOOKUP(H3,DJ!$A$3:$D$14,4)","v":0},{"$f":"VLOOKUP(I3,DJ!$A$3:$D$14,4)","v":0},{"$f":"VLOOKUP(J3,DJ!$A$3:$D$14,4)","v":0}]
[null,"Eau (m³)",{"$f":"Encodage!$R25","v":0},{"$f":"Encodage!R40","v":0},{"$f":"Encodage!R55","v":0},{"$f":"Encodage!$R70","v":0},{"$f":"Encodage!$R85","v":0},{"$f":"Encodage!$R100","v":0},{"$f":"Encodage!$R115","v":0},{"$f":"Encodage!$R130","v":0}]
[null,"Coût total elec (€)",{"$f":"Encodage!$K$25","v":0},{"$f":"Encodage!$K$40","v":0},{"$f":"Encodage!$K$55","v":0},{"$f":"Encodage!$K$70","v":0},{"$f":"Encodage!$K$85","v":0},{"$f":"Encodage!$K$100","v":0},{"$f":"Encodage!K115","v":0},{"$f":"Encodage!$K$130","v":0}]
[null,"Coût total combustible (€)",{"$f":"Encodage!$Q$25","v":0},{"$f":"Encodage!$Q$40","v":0},{"$f":"Encodage!$Q$55","v":0},{"$f":"Encodage!$Q$70","v":0},{"$f":"Encodage!$Q$85","v":0},{"$f":"Encodage!$Q$100","v":0},{"$f":"Encodage!Q116","v":0},{"$f":"Encodage!$Q$130","v":0}]
[null,"Coût total eau (€)",{"$f":"Encodage!$S$25","v":0},{"$f":"Encodage!$S$40","v":0},{"$f":"Encodage!$S$55","v":0},{"$f":"Encodage!$S$70","v":0},{"$f":"Encodage!$S$85","v":0},{"$f":"Encodage!$S$100","v":0},{"$f":"Encodage!S117","v":0},{"$f":"Encodage!$S$130","v":0}]
[]
[null,"Evolution par rapport à l’année du 1er encodage",{"$f":"C3","v":2013},2014,2015,2016,2017,2018,2019,2020]
[null,{"$f":"B4","v":"Consommation Elec totale [kWh]"},{"$f":"IFERROR(C4/$C4,0)","v":0},{"$f":"IFERROR(D4/$C4,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B5","v":"Cons. Elec heures pleines [kWh]"},{"$f":"IFERROR(C5/$C5,0)","v":0},0,0,0,0,0,0,0]
[null,{"$f":"B6","v":"Cons. Elec heures creuses [kWh]"},{"$f":"IFERROR(C6/$C6,0)","v":0},{"$f":"IFERROR(D6/$C6,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B9","v":"Consommation de combustibles [kWhi]"},{"$f":"IFERROR(C9/$C9,0)","v":0},{"$f":"IFERROR(D9/$C9,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B10","v":"Cons. de combustible normalisé [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. combustible spécifique normalisée [kWhi/m²]"},{"$f":"IFERROR(C11/$C11,0)","v":0},{"$f":"IFERROR(D11/$C11,0)","v":0},0,0,0,0,0,0]
[null,{"$f":"B14","v":"Eau (m³)"},{"$f":"IFERROR(C14/$C14,0)","v":0},{"$f":"IFERROR(D14/$C14,0)","v":0},0,0,0,0,0,0]
[null,"Coût total elec",{"$f":"IFERROR(C15/$C15,0)","v":0},0,0,0,0,0,0,0]
[null,"Coût total combustible",{"$f":"IFERROR(C16/$C16,0)","v":0},0,0,0,0,0,0,0]
[null,"Coût total eau",{"$f":"IFERROR(C17/$C17,0)","v":0},0,0,0,0,0,0,0]
[]
[null,"Evolution par rapport à l'année précédente",{"$f":"C19","v":2013},2014,2015,2016,2017,2018,2019,2020]
[null,{"$f":"B20","v":"Consommation Elec totale [kWh]"},null,{"$f":"IFERROR(IF(D20=0,0,D20/C20-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(D26=0,0,D26/C26-1),\"\")","v":0},0,0,0,0,0,0]
[null,"Coût total elec",null,{"$f":"IFERROR(IF(D27=0,0,D27/C27-1),\"\")","v":0},{"$f":"IFERROR(IF(E27=0,0,E27/D27-1),\"\")","v":0},{"$f":"IFERROR(IF(F27=0,0,F27/E27-1),\"\")","v":0},{"$f":"IFERROR(IF(G27=0,0,G27/F27-1),\"\")","v":0},{"$f":"IFERROR(IF(H27=0,0,H27/G27-1),\"\")","v":0},{"$f":"IFERROR(IF(I27=0,0,I27/H27-1),\"\")","v":0},{"$f":"IFERROR(IF(J27=0,0,J27/I27-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":106,"n_cols":17,"rows_kept":106,"cut":false,"hidden":false,"merged":[[104,16,104,20],[105,16,105,20],[104,0,104,5],[104,6,104,10],[105,0,105,5],[105,6,105,10],[104,11,104,15],[105,11,105,15],[81,0,81,5],[81,6,81,10],[81,11,81,15],[81,16,81,20],[82,0,82,5],[82,6,82,10],[82,11,82,15],[82,16,82,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Consommation d'élec par bâtiment",null,null,null,null,null,{"$f":"$A$105","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$105","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$105","v":"Consommation d'élec par bâtiment"}]
[{"$f":"Encodage!A12","v":2013},null,null,null,null,null,{"$f":"Encodage!A27","v":2014},null,null,null,null,{"$f":"Encodage!A42","v":2015},null,null,null,null,{"$f":"Encodage!A57","v":2016}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Consommation d'élec par bâtiment",null,null,null,null,null,{"$f":"$A$105","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$105","v":"Consommation d'élec par bâtiment"},null,null,null,null,{"$f":"$A$105","v":"Consommation d'élec par bâtiment"}]
[{"$f":"Encodage!A72","v":2017},null,null,null,null,null,{"$f":"Encodage!A87","v":2018},null,null,null,null,{"$f":"Encodage!A102","v":2019},null,null,null,null,{"$f":"Encodage!A117","v":2020}]

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

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

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

{"sheet":"Paramètres","index":9,"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.5555555555555554,"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!A17","v":"A sélectionner dans la liste déroulante"},100,100,"kWh/m²",{"$f":"DJ!B17","v":0.85}]
[{"$f":"DJ!A18","v":"Accueil de jour"},0,0,"kWh/m²",{"$f":"DJ!B18","v":0.85}]
[{"$f":"DJ!A19","v":"Bureau privé HT"},102,138,"kWh/m²",{"$f":"DJ!B19","v":0.85}]
[{"$f":"DJ!A20","v":"Bureau public HT"},165,65,"kWh/m²",{"$f":"DJ!B20","v":0.85}]
[{"$f":"DJ!A21","v":"Centre d’insertion socio-professionnel"},0,0,"kWh/m²",{"$f":"DJ!B21","v":0.85}]
[{"$f":"DJ!A22","v":"Crèche"},0,0,"kWh/m²",{"$f":"DJ!B22","v":0.85}]
[{"$f":"DJ!A23","v":"École"},143,26,"kWh/m²",{"$f":"DJ!B23","v":0.85}]
[{"$f":"DJ!A24","v":"Entreprise de travail adapté"},0,0,"kWh/m²",{"$f":"DJ!B24","v":0.85}]
[{"$f":"DJ!A25","v":"Etablissement culturel"},177,59,"kWh/m²",{"$f":"DJ!B25","v":0.85}]
[{"$f":"DJ!A26","v":"Etablissement sportif"},150,50,"kWh/m²",{"$f":"DJ!B26","v":0.85}]
[{"$f":"DJ!A27","v":"Hébergement"},199,72,"kWh/m²",{"$f":"DJ!B27","v":0.7}]
[{"$f":"DJ!A28","v":"Hôpitaux"},194,122,"kWh/m²",{"$f":"DJ!B28","v":0.7}]
[{"$f":"DJ!A29","v":"autre"},0,0,"kWh/m²",{"$f":"DJ!B29","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":10,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,5,1,9]]}
["Degrés jours","15/15","16,5/16,5",{"$f":"IF(Encodage!$D$4=$B$1,B1,C1)","v":"16,5/16,5"}]
["degré jour normaux",1913,2301,{"$f":"IF(Encodage!$D$4=$B$1,B2,C2)","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$4=$B$1,B3,C3)","v":2212}]
[2010,2309,2703,{"$f":"IF(Encodage!$D$4=$B$1,B4,C4)","v":2703}]
[2011,1514.5,1928,{"$f":"IF(Encodage!$D$4=$B$1,B5,C5)","v":1928}]
[2012,1914.7,2327,{"$f":"IF(Encodage!$D$4=$B$1,B6,C6)","v":2327}]
[2013,2137.6999999999998,2537,{"$f":"IF(Encodage!$D$4=$B$1,B7,C7)","v":2537}]
[2014,1424.1,1828,{"$f":"IF(Encodage!$D$4=$B$1,B8,C8)","v":1828}]
[2015,"1688.3 ",2112,{"$f":"IF(Encodage!$D$4=$B$1,B9,C9)","v":2112}]
[2016,null,null,{"$f":"IF(Encodage!$D$4=$B$1,B10,C10)","v":0}]
[2017,null,null,{"$f":"IF(Encodage!$D$4=$B$1,B11,C11)","v":0}]
[2018,null,null,{"$f":"IF(Encodage!$D$4=$B$1,B12,C12)","v":0}]
[2019,null,null,{"$f":"IF(Encodage!$D$4=$B$1,B13,C13)","v":0}]
[2020,null,null,{"$f":"IF(Encodage!$D$4=$B$1,B14,C14)","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]