{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Guide","Données_de_base","Input_TIC_individuel","Resultats_TIC_individuel","Calculs_TIC_individuel","Input_TIC_complet","Resultats__TIC_complet","Calculs__TIC_complet","Annexe"],"not_rendered":{"charts":4,"images":3,"macros":1,"external_links":0,"defined_names":42,"comments":8,"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":"Guide","index":0,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,23,8],[17,3,18,8],[19,3,19,8],[4,1,4,8],[20,1,20,8],[7,3,7,8],[8,3,8,8],[9,3,9,8],[10,3,10,8],[13,3,14,8]]}
[null,"GUIDE"]
[]
[null,"Introduction"]
[]
[null,"Le présent outil Excel permet de calculer les coûts du cycle de vie (cf. définition en annexe) des appareils TIC sous forme d'achats individuels (p. ex. X tablettes) ou d'achats groupés (p. ex. X ordinateurs portables avec écran et souris). Cet outil a été développé par le secrétariat Exemplarité Énergie et Climat et vient en aide aux acteurs dans la mise en œuvre de la mesure commune 'No 10 Considération des coûts du cycle de vie'.\n\nCet outil s'adresse en premier lieu aux acheteurs, mais peut aussi être utile à d'autres groupes d'utilisateurs. En cas d'acquisitions complexes, la collaboration avec des spécialistes a pour but d'aider à remplir les renseignements demandés. Dans l'onglet « Annexe », vous trouverez des sources et des informations complémentaires concernant cet outil, ainsi que les définitions de certains termes employés."]
[null,"Procédure"]
[]
[null,null,"1)","Sélectionnez le groupe de produits (tant qu'aucun groupe de produits n'est sélectionné, tout s'affiche).\nSaisissez des données générales comme le taux d'intérêt de calcul et les prix de l'énergie si vous ne souhaitez pas calculer avec les valeurs par défaut."]
[null,null,"2)","Complétez les renseignements demandés au sujet du produit."]
[null,null,"3)","Comparez les coûts des cycles de vie des variantes."]
[null,null,"4)","Si vous souhaitez visualiser les calculs, vous pouvez les trouver dans l'onglet « Calculs_Produit »."]
[null,"Utilisation"]
[]
[null,null,null,"Champs de saisie et remplacement des valeurs par défaut. Si des valeurs par défaut sont disponibles, il n'est pas nécessaire d'introduire des données personnelles; les calculs seront faits sur la base des valeurs par défaut."]
[]
[null,"VEUILLEZ SÉLECTIONNER",null,"Champs de sélection: Si on clique, un menu déroulant s'ouvre."]
[]
[null,"K",null,"Champs de commentaires avec des aides pour la saisie de données, des sources, etc.\nLes champs de commentaires se situent dans la mesure du possible sur le côté gauche."]
[]
[null,null,null,"Tous les calculs peuvent être consultés. Pour une meilleure vue d'ensemble, les calculs sont en partie regroupés et masqués. Il est possible de les afficher à tout moment en cliquant sur le «+» dans le titre de la ligne ou de la colonne."]
[null,"L'outil Excel est protégé, sans mot de passe. Pour annuler la protection de la feuille, il faut aller dans «Révision -> Ôter la protection de la feuille».\nVous pouvez en principe adapter cet outil à vos propres besoins. Toutefois, il faut savoir que cela peut engendrer des erreurs de calcul. Il est possible que le code Visual Basic doive également être adapté."]
[null,"Informations concernant l'outil"]
[]
[null,"Le secrétariat Exemplarité Énergie et Climat n'assume aucune responsabilité quant à l'exactitude des calculs."]

{"sheet":"Données_de_base","index":1,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[10,1,10,3],[7,2,7,3],[7,4,7,5],[4,2,4,5],[7,6,7,7]]}
[null,"DONNÉES DE BASE"]
[]
[null,"Sélection du groupe de produit"]
[]
["K","Groupe de produit","VEUILLEZ SÉLECTIONNER"]
[]
[null,"Données relatives à l'électricité et aux gaz à effet de serre",null,null,null,null,null,null,null,"Valeurs calculées"]
["K",null,"Prix de l'énergie [ct/kWh]",null,"Gaz à effet de serre\n[g CO2eq/kWh]",null,"Unités de charge écologique UCE'13 [UCE/kWh]",null,null,"Prix de l'énergie [ct./kWh]","Gaz à effet de serre\n[g CO2eq/kWh]","UCE'13 [UCE/kWh]"]
[null,"Électricité",null,"Remplacer valeur par défaut",null,"Remplacer valeur par défaut",null,"Remplacer valeur par défaut",null,0,0,0]
["K","VEUILLEZ SÉLECTIONNER LE PRODUIT ÉLECTRIQUE",{"$f":"VLOOKUP($B$10,$B$26:$H$32,2,0)","v":0},null,{"$f":"VLOOKUP($B$10,$B$26:$H$32,5,0)","v":0},null,{"$f":"VLOOKUP($B$10,$B$26:$H$32,6,0)","v":0},null,null,{"$f":"IF(ISNUMBER(D10),D10,C10)","v":0},{"$f":"IF(ISNUMBER(F10),F10,E10)","v":0},{"$f":"IF(ISNUMBER(H10),H10,G10)","v":0}]
[null,"Comment les coûts externes des émissions de gaz à effet de serre (GES) doivent-ils être inclus dans le calcul LCC?",null,null,"Remplacer valeur par défaut"]
["K","VEUILLEZ SÉLECTIONNER","CHF/tCO2eq",{"$f":"VLOOKUP(B12,B36:C39,2,0)","v":0},null,null,null,null,null,{"$f":"IF(ISNUMBER(E12),E12,D12)","v":0}]
[]
[null,"Données relatives aux taux d'intérêt et hausses de prix"]
[null,null,null,null,"Remplacer valeur par défaut"]
["K","Hausse du prix de l'énergie",null,0.01,null,null,null,null,null,{"$f":"IF(ISNUMBER(E16),E16,D16)","v":0.01}]
["K","Taux d'intérêt de calcul",null,2.5000000000000001E-2,null,null,null,null,null,{"$f":"IF(ISNUMBER(E17),E17,D17)","v":2.5000000000000001E-2}]
["K","Hausse de prix",null,0.01,null,null,null,null,null,{"$f":"IF(ISNUMBER(E18),E18,D18)","v":0.01}]
[]
[]
[]
[]
[null,"Listes déroulantes"]
[null,"Liste déroulante Mix électrique et valeurs par défaut"]
[null,"Produit électrique","Prix de l'énergie [ct./kWh]","Haut tarif\n[ct./kWh]","Bas tarif\n[ct./kWh]","Gaz à effet de serre [gCO2eq/ kWh]","UCE'13 [UCE/kWh]","Prix de puissance [CHF/kW]"]
[null,"VEUILLEZ SÉLECTIONNER LE PRODUIT ÉLECTRIQUE",0,0,0,0,0,0]
[null,"Mix produits électriques issus d’énergies renouvelables",{"$f":"1.5*C28","v":13.5},{"$f":"1.5*D28","v":15},12,15,47.8,10]
[null,"Mix de consommation CH (prix de l'électricité non renouvelable) ",9,10,8,102,347,10]
[null,"Mix ENTSO-E (électricité issue du réseau européen)",9,10,8,524,548,10]
[null,"Photovoltaïque",{"$f":"2*C28","v":18},{"$f":"2*D28","v":20},16,96,174,10]
[null,"Énergie hydraulique",{"$f":"1.5*C28","v":13.5},{"$f":"1.5*D28","v":15},12,12,43.8,10]
[null,"Autres","n.a.","n.a.","n.a.","n.a.","n.a.",10]
[]
[null,"Liste déroulante Coûts gaz à effet de serre"]
[null,"Coûts","CHF/tCO2eq","Affichage","Unité","Affichage avec unité"]
[null,"VEUILLEZ SÉLECTIONNER",0,"Coûts pour GES: pas sélectionné",null,{"$f":"D36","v":"Coûts pour GES: pas sélectionné"}]
[null,"Ne prendre en compte aucun coût pour les GES",0,"Coûts pour GES: pas pris en compte",null,{"$f":"D37","v":"Coûts pour GES: pas pris en compte"}]
[null,"Coûts externes émissions de gaz à effet de serre",121.5,"Coûts externes émissions de gaz à effet de serre","[CHF]",{"$f":"D38&\" \"&E38","v":"Coûts externes émissions de gaz à effet de serre [CHF]"}]
[null,"Frais de compensation gaz à effet de serre",30,"Frais de compensation gaz à effet de serre","[CHF]",{"$f":"D39&\" \"&E39","v":"Frais de compensation gaz à effet de serre [CHF]"}]
[]
["K","Liste déroulante Groupe de produits"]
[null,"VEUILLEZ SÉLECTIONNER"]
[null,"Produit individuel TIC"]
[null,"Aménagement complet TIC"]

{"sheet":"Input_TIC_individuel","index":2,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[4,2,4,4],[6,2,6,4],[11,2,11,4],[5,2,5,4]]}
[null,"SAISIE DES DONNÉES PRODUIT INDIVIDUEL TIC"]
[]
[null,"Données générales"]
[]
[null,"Projet"]
[null,"Entreprise"]
[null,"Responsable"]
[null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liste déroulante Méthode de calcul de la consommation d'énergie"]
[]
["K","Nombre d'unités",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
["K","Période considérée pour calculer le coût du cycle de vie",null,"années",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consommation d'énergie selon la valeur TEC de Energy Star"]
["K","Méthode de calcul consommation d'énergie","VEUILLEZ SÉLECTIONNER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculer la consommation d'énergie à l'aide de la puissance électrique"]
[]
["K","Ordinateurs, ordinateurs portables, tablettes, stations de travail","Part des états de fonctionnement","Remplacer valeurs par défaut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeurs calculées"]
[null,"Mode idle",0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(D15),D15,C15)","v":0.3}]
[null,"Mode sleep",0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(D16),D16,C16)","v":0.1}]
[null,"Mode OFF",0.6,null,{"$f":"IF(OR(SUM(D15:D17)=0,SUM(D15:D17)=1),\"\",\"Attention : la somme doit être 100%.\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(D17),D17,C17)","v":0.6}]
["K","Moniteur","Part des états de fonctionnement","Remplacer valeurs par défaut"]
[null,"Mode ON",0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(D19),D19,C19)","v":0.35}]
[null,"Mode sleep/standby",0.65,null,{"$f":"IF(OR(SUM(D19:D20)=0,SUM(D19:D20)=1),\"\",\"Attention : la somme doit être 100%\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(D20),D20,C20)","v":0.65}]
[]
[null,"Produit"]
[null,"Variante",null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Désignation du produit Fabriquant"]
[null,"Fournisseur"]
["K","Désignation de variantes"]
[]
[null,"Coûts d'acquisition"]
[]
[null,"Prix de l'offre brut","CHF/unité"]
[null,"Rabais","%"]
[null,"Prix d'achat négocié","CHF",{"$f":"D30*(1-D31)","v":0},{"$f":"E30*(1-E31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Frais de transport","CHF/unité"]
[null,"Frais d'installation uniques","CHF/unité"]
[]
[null,"Consommation d'énergie et émissions de gaz à effet de serre (données relatives au calcul des coûts de l'énergie et coûts externes)"]
[]
["K","Product Carbon Footprint (sans phase \"Use\")","kgCO2eq/unité"]
["K","Consommation d'énergie selon Energy Star (valeur TEC)","kWh/unité/an"]
[null,"Ordinateurs, ordinateurs portables, tablettes, stations de travail"]
[null,"Puissance en mode idle (PIDLE)","W/unité"]
[null,"Puissance en mode sleep (PSLEEP)","W/unité"]
[null,"Puissance en mode OFF (POFF)","W/unité"]
[null,"Moniteur"]
[null,"Puissance en mode ON (PON)","W/unité"]
[null,"Puissance en mode sleep/standby (PSLEEP)","W/unité"]
[]
[null,"Coûts d'exploitation"]
[]
[null,"Installation de remplacement","CHF/unité/an"]
[null,"Frais de stockage","CHF/unité/an"]
[null,"Entretien interne (frais de service et de matériel)","CHF/unité/an"]
[null,"Entretien externe (frais de service et de matériel)","CHF/unité/an"]
[null,"Assurances, impôts et taxes","CHF/unité/an"]
[null,"Coûts d'exploitation supplémentaires","CHF/unité/an"]
[]
[null,"Coûts pour l'élimination"]
[]
["K","Coûts pour l'élimination","CHF/unité"]
["K","Valeur résiduelle à la fin du calcul du cycle de vie","CHF/unité"]

{"sheet":"Resultats_TIC_individuel","index":3,"n_rows":77,"n_cols":23,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[null,"RÉSULTATS PRODUIT INDIVIDUEL TIC"]
[]
[null,"Coûts du cycle de vie"]
[null,"Coûts des différentes variantes, considérés sur l'ensemble du cycle de vie (sous forme de valeur actuelle nette)."]
[null,null,null,{"$f":"Input_TIC_individuel!D$23&IF(ISBLANK(Input_TIC_individuel!D$26),\"\",\" (\"&LEFT(Input_TIC_individuel!D$26,MIN(8,LEN(Input_TIC_individuel!D$26)))&\")\")","v":"V1"},{"$f":"Input_TIC_individuel!E$23&IF(ISBLANK(Input_TIC_individuel!E$26),\"\",\" (\"&LEFT(Input_TIC_individuel!E$26,MIN(8,LEN(Input_TIC_individuel!E$26)))&\")\")","v":"V2"},{"$f":"Input_TIC_individuel!F$23&IF(ISBLANK(Input_TIC_individuel!F$26),\"\",\" (\"&LEFT(Input_TIC_individuel!F$26,MIN(8,LEN(Input_TIC_individuel!F$26)))&\")\")","v":"V3"},{"$f":"Input_TIC_individuel!G$23&IF(ISBLANK(Input_TIC_individuel!G$26),\"\",\" (\"&LEFT(Input_TIC_individuel!G$26,MIN(8,LEN(Input_TIC_individuel!G$26)))&\")\")","v":"V4"},{"$f":"Input_TIC_individuel!H$23&IF(ISBLANK(Input_TIC_individuel!H$26),\"\",\" (\"&LEFT(Input_TIC_individuel!H$26,MIN(8,LEN(Input_TIC_individuel!H$26)))&\")\")","v":"V5"},{"$f":"Input_TIC_individuel!I$23&IF(ISBLANK(Input_TIC_individuel!I$26),\"\",\" (\"&LEFT(Input_TIC_individuel!I$26,MIN(8,LEN(Input_TIC_individuel!I$26)))&\")\")","v":"V6"},{"$f":"Input_TIC_individuel!J$23&IF(ISBLANK(Input_TIC_individuel!J$26),\"\",\" (\"&LEFT(Input_TIC_individuel!J$26,MIN(8,LEN(Input_TIC_individuel!J$26)))&\")\")","v":"V7"},{"$f":"Input_TIC_individuel!K$23&IF(ISBLANK(Input_TIC_individuel!K$26),\"\",\" (\"&LEFT(Input_TIC_individuel!K$26,MIN(8,LEN(Input_TIC_individuel!K$26)))&\")\")","v":"V8"},{"$f":"Input_TIC_individuel!L$23&IF(ISBLANK(Input_TIC_individuel!L$26),\"\",\" (\"&LEFT(Input_TIC_individuel!L$26,MIN(8,LEN(Input_TIC_individuel!L$26)))&\")\")","v":"V9"},{"$f":"Input_TIC_individuel!M$23&IF(ISBLANK(Input_TIC_individuel!M$26),\"\",\" (\"&LEFT(Input_TIC_individuel!M$26,MIN(8,LEN(Input_TIC_individuel!M$26)))&\")\")","v":"V10"},{"$f":"Input_TIC_individuel!N$23&IF(ISBLANK(Input_TIC_individuel!N$26),\"\",\" (\"&LEFT(Input_TIC_individuel!N$26,MIN(8,LEN(Input_TIC_individuel!N$26)))&\")\")","v":"V11"},{"$f":"Input_TIC_individuel!O$23&IF(ISBLANK(Input_TIC_individuel!O$26),\"\",\" (\"&LEFT(Input_TIC_individuel!O$26,MIN(8,LEN(Input_TIC_individuel!O$26)))&\")\")","v":"V12"},{"$f":"Input_TIC_individuel!P$23&IF(ISBLANK(Input_TIC_individuel!P$26),\"\",\" (\"&LEFT(Input_TIC_individuel!P$26,MIN(8,LEN(Input_TIC_individuel!P$26)))&\")\")","v":"V13"},{"$f":"Input_TIC_individuel!Q$23&IF(ISBLANK(Input_TIC_individuel!Q$26),\"\",\" (\"&LEFT(Input_TIC_individuel!Q$26,MIN(8,LEN(Input_TIC_individuel!Q$26)))&\")\")","v":"V14"},{"$f":"Input_TIC_individuel!R$23&IF(ISBLANK(Input_TIC_individuel!R$26),\"\",\" (\"&LEFT(Input_TIC_individuel!R$26,MIN(8,LEN(Input_TIC_individuel!R$26)))&\")\")","v":"V15"},{"$f":"Input_TIC_individuel!S$23&IF(ISBLANK(Input_TIC_individuel!S$26),\"\",\" (\"&LEFT(Input_TIC_individuel!S$26,MIN(8,LEN(Input_TIC_individuel!S$26)))&\")\")","v":"V16"},{"$f":"Input_TIC_individuel!T$23&IF(ISBLANK(Input_TIC_individuel!T$26),\"\",\" (\"&LEFT(Input_TIC_individuel!T$26,MIN(8,LEN(Input_TIC_individuel!T$26)))&\")\")","v":"V17"},{"$f":"Input_TIC_individuel!U$23&IF(ISBLANK(Input_TIC_individuel!U$26),\"\",\" (\"&LEFT(Input_TIC_individuel!U$26,MIN(8,LEN(Input_TIC_individuel!U$26)))&\")\")","v":"V18"},{"$f":"Input_TIC_individuel!V$23&IF(ISBLANK(Input_TIC_individuel!V$26),\"\",\" (\"&LEFT(Input_TIC_individuel!V$26,MIN(8,LEN(Input_TIC_individuel!V$26)))&\")\")","v":"V19"},{"$f":"Input_TIC_individuel!W$23&IF(ISBLANK(Input_TIC_individuel!W$26),\"\",\" (\"&LEFT(Input_TIC_individuel!W$26,MIN(8,LEN(Input_TIC_individuel!W$26)))&\")\")","v":"V20"}]
[null,"Valeur actuelle nette",null,{"$f":"Input_TIC_individuel!D24","v":0},{"$f":"Input_TIC_individuel!E24","v":0},{"$f":"Input_TIC_individuel!F24","v":0},{"$f":"Input_TIC_individuel!G24","v":0},{"$f":"Input_TIC_individuel!H24","v":0},{"$f":"Input_TIC_individuel!I24","v":0},{"$f":"Input_TIC_individuel!J24","v":0},{"$f":"Input_TIC_individuel!K24","v":0},{"$f":"Input_TIC_individuel!L24","v":0},{"$f":"Input_TIC_individuel!M24","v":0},{"$f":"Input_TIC_individuel!N24","v":0},{"$f":"Input_TIC_individuel!O24","v":0},{"$f":"Input_TIC_individuel!P24","v":0},{"$f":"Input_TIC_individuel!Q24","v":0},{"$f":"Input_TIC_individuel!R24","v":0},{"$f":"Input_TIC_individuel!S24","v":0},{"$f":"Input_TIC_individuel!T24","v":0},{"$f":"Input_TIC_individuel!U24","v":0},{"$f":"Input_TIC_individuel!V24","v":0},{"$f":"Input_TIC_individuel!W24","v":0}]
[null,"Acquisition: Coûts d'acquisition déduction faite de la valeur résiduelle","CHF",{"$f":"Calculs_TIC_individuel!Y24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Z24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AA24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AB24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AC24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AD24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AE24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AF24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AG24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AH24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AI24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AJ24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AK24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AL24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AM24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AN24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AO24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AP24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AQ24*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AR24*Anzahl_IKT","v":0}]
[null,"Coûts énergétiques","CHF",{"$f":"Calculs_TIC_individuel!Y47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Z47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AA47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AB47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AC47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AD47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AE47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AF47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AG47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AH47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AI47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AJ47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AK47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AL47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AM47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AN47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AO47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AP47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AQ47*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AR47*Anzahl_IKT","v":0}]
[null,"Coûts d'exploitation","CHF",{"$f":"Calculs_TIC_individuel!Y71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Z71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AA71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AB71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AC71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AD71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AE71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AF71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AG71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AH71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AI71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AJ71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AK71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AL71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AM71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AN71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AO71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AP71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AQ71*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AR71*Anzahl_IKT","v":0}]
["K",{"$f":"VLOOKUP(Données_de_base!$B$12,Données_de_base!$B$36:$D$39,3,0)","v":"Coûts pour GES: pas sélectionné"},"CHF",{"$f":"Calculs_TIC_individuel!Y95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Z95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AA95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AB95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AC95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AD95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AE95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AF95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AG95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AH95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AI95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AJ95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AK95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AL95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AM95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AN95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AO95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AP95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AQ95*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AR95*Anzahl_IKT","v":0}]
[null,"Élimination: Coûts pour l'élimination","CHF",{"$f":"Calculs_TIC_individuel!Y114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Z114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AA114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AB114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AC114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AD114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AE114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AF114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AG114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AH114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AI114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AJ114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AK114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AL114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AM114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AN114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AO114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AP114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AQ114*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!AR114*Anzahl_IKT","v":0}]
[null,"Total","CHF",{"$f":"SUM(D7:D11)","v":0},{"$f":"SUM(E7:E11)","v":0},{"$f":"SUM(F7:F11)","v":0},{"$f":"SUM(G7:G11)","v":0},{"$f":"SUM(H7:H11)","v":0},{"$f":"SUM(I7:I11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["K","Unités de charge écologique UCE'13 exploitation","UCE",{"$f":"Calculs_TIC_individuel!C76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!D76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!E76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!F76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!G76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!H76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!I76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!J76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!K76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!L76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!M76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!N76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!O76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!P76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Q76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!R76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!S76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!T76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!U76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!V76*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0}]
[null,"Émissions de gaz à effet de serre exploitation (Scope 2)","tCO2eq",{"$f":"Calculs_TIC_individuel!C77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!D77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!E77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!F77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!G77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!H77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!I77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!J77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!K77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!L77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!M77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!N77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!O77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!P77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Q77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!R77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!S77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!T77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!U77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!V77*Betrachtungszeit_IKT_Einzel*Anzahl_IKT","v":0}]
[null,"Émissions de gaz à effet de serre fabrication (Scope 3)","tCO2eq",{"$f":"Calculs_TIC_individuel!C80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!D80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!E80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!F80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!G80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!H80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!I80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!J80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!K80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!L80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!M80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!N80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!O80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!P80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!Q80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!R80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!S80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!T80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!U80*Anzahl_IKT","v":0},{"$f":"Calculs_TIC_individuel!V80*Anzahl_IKT","v":0}]
[]
[null,"Diagramme coûts du cycle de vie"]
[]
[]
[null,"Coûts additionnés (valeurs actuelles) des différentes variantes sur la période considérée"]
[]
[]
[null,null,null,null,null,null,null,null,"Variantes représentées"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Auswahlfeld Dastellung Variante"]
[null,"VEUILLEZ SÉLECTIONNER"]
[null,{"$f":"D$5","v":"V1"}]
[null,{"$f":"E$5","v":"V2"}]
[null,{"$f":"F$5","v":"V3"}]
[null,{"$f":"G$5","v":"V4"}]
[null,{"$f":"H$5","v":"V5"}]
[null,{"$f":"I$5","v":"V6"}]
[null,{"$f":"J$5","v":"V7"}]
[null,{"$f":"K$5","v":"V8"}]
[null,{"$f":"L$5","v":"V9"}]
[null,{"$f":"L$5","v":"V9"}]
[null,{"$f":"M$5","v":"V10"}]
[null,{"$f":"N$5","v":"V11"}]
[null,{"$f":"O$5","v":"V12"}]
[null,{"$f":"P$5","v":"V13"}]
[null,{"$f":"Q$5","v":"V14"}]
[null,{"$f":"R$5","v":"V15"}]
[null,{"$f":"S$5","v":"V16"}]
[null,{"$f":"T$5","v":"V17"}]
[null,{"$f":"U$5","v":"V18"}]
[null,{"$f":"V$5","v":"V19"}]
[null,{"$f":"W$5","v":"V20"}]

{"sheet":"Calculs_TIC_individuel","index":4,"n_rows":145,"n_cols":44,"rows_kept":145,"cut":false,"hidden":false,"merged":[[115,23,115,43],[132,28,133,28],[2,1,2,6],[72,1,72,6],[96,1,96,6],[25,1,25,6],[2,23,2,28],[25,23,25,28],[48,23,48,28]]}
[null,"CALCULS PAR UNITÉ (PRODUIT INDIVIDUEL TIC)"]
[]
[null,"Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B3","v":"Valeur actuelle Acquisition"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Coûts d'acquisition [CHF]",{"$f":"Input_TIC_individuel!D32","v":0},{"$f":"Input_TIC_individuel!E32","v":0},{"$f":"Input_TIC_individuel!F32","v":0},{"$f":"Input_TIC_individuel!G32","v":0},{"$f":"Input_TIC_individuel!H32","v":0},{"$f":"Input_TIC_individuel!I32","v":0},{"$f":"Input_TIC_individuel!J32","v":0},{"$f":"Input_TIC_individuel!K32","v":0},{"$f":"Input_TIC_individuel!L32","v":0},{"$f":"Input_TIC_individuel!M32","v":0},{"$f":"Input_TIC_individuel!N32","v":0},{"$f":"Input_TIC_individuel!O32","v":0},{"$f":"Input_TIC_individuel!P32","v":0},{"$f":"Input_TIC_individuel!Q32","v":0},{"$f":"Input_TIC_individuel!R32","v":0},{"$f":"Input_TIC_individuel!S32","v":0},{"$f":"Input_TIC_individuel!T32","v":0},{"$f":"Input_TIC_individuel!U32","v":0},{"$f":"Input_TIC_individuel!V32","v":0},{"$f":"Input_TIC_individuel!W32","v":0}]
[null,"Frais de transport [CHF]",{"$f":"Input_TIC_individuel!D33","v":0},{"$f":"Input_TIC_individuel!E33","v":0},{"$f":"Input_TIC_individuel!F33","v":0},{"$f":"Input_TIC_individuel!G33","v":0},{"$f":"Input_TIC_individuel!H33","v":0},{"$f":"Input_TIC_individuel!I33","v":0},{"$f":"Input_TIC_individuel!J33","v":0},{"$f":"Input_TIC_individuel!K33","v":0},{"$f":"Input_TIC_individuel!L33","v":0},{"$f":"Input_TIC_individuel!M33","v":0},{"$f":"Input_TIC_individuel!N33","v":0},{"$f":"Input_TIC_individuel!O33","v":0},{"$f":"Input_TIC_individuel!P33","v":0},{"$f":"Input_TIC_individuel!Q33","v":0},{"$f":"Input_TIC_individuel!R33","v":0},{"$f":"Input_TIC_individuel!S33","v":0},{"$f":"Input_TIC_individuel!T33","v":0},{"$f":"Input_TIC_individuel!U33","v":0},{"$f":"Input_TIC_individuel!V33","v":0},{"$f":"Input_TIC_individuel!W33","v":0}]
[null,"Frais d'installation uniques [CHF]",{"$f":"Input_TIC_individuel!D34","v":0},{"$f":"Input_TIC_individuel!E34","v":0},{"$f":"Input_TIC_individuel!F34","v":0},{"$f":"Input_TIC_individuel!G34","v":0},{"$f":"Input_TIC_individuel!H34","v":0},{"$f":"Input_TIC_individuel!I34","v":0},{"$f":"Input_TIC_individuel!J34","v":0},{"$f":"Input_TIC_individuel!K34","v":0},{"$f":"Input_TIC_individuel!L34","v":0},{"$f":"Input_TIC_individuel!M34","v":0},{"$f":"Input_TIC_individuel!N34","v":0},{"$f":"Input_TIC_individuel!O34","v":0},{"$f":"Input_TIC_individuel!P34","v":0},{"$f":"Input_TIC_individuel!Q34","v":0},{"$f":"Input_TIC_individuel!R34","v":0},{"$f":"Input_TIC_individuel!S34","v":0},{"$f":"Input_TIC_individuel!T34","v":0},{"$f":"Input_TIC_individuel!U34","v":0},{"$f":"Input_TIC_individuel!V34","v":0},{"$f":"Input_TIC_individuel!W34","v":0}]
[null,"Total [CHF]",{"$f":"SUM(C6:C8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["K","Valeur résiduelle à la fin du cycle de vie [CHF]",{"$f":"Input_TIC_individuel!D60","v":0},{"$f":"Input_TIC_individuel!E60","v":0},{"$f":"Input_TIC_individuel!F60","v":0},{"$f":"Input_TIC_individuel!G60","v":0},{"$f":"Input_TIC_individuel!H60","v":0},{"$f":"Input_TIC_individuel!I60","v":0},{"$f":"Input_TIC_individuel!J60","v":0},{"$f":"Input_TIC_individuel!K60","v":0},{"$f":"Input_TIC_individuel!L60","v":0},{"$f":"Input_TIC_individuel!M60","v":0},{"$f":"Input_TIC_individuel!N60","v":0},{"$f":"Input_TIC_individuel!O60","v":0},{"$f":"Input_TIC_individuel!P60","v":0},{"$f":"Input_TIC_individuel!Q60","v":0},{"$f":"Input_TIC_individuel!R60","v":0},{"$f":"Input_TIC_individuel!S60","v":0},{"$f":"Input_TIC_individuel!T60","v":0},{"$f":"Input_TIC_individuel!U60","v":0},{"$f":"Input_TIC_individuel!V60","v":0},{"$f":"Input_TIC_individuel!W60","v":0}]
[null,"Coûts d'acquisition déduction faite de la valeur résiduelle [CHF] en prenant compte de la hausse de prix de l'année..."]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,{"$f":"C9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"D13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"E13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"F13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"G13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"H13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"I13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"J13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"K13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"L13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"M13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"N13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"O13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"P13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"Q13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"R13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"S13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"T13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"U13*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"V13*(1+Kalkulationszinssatz)^-$X13","v":0}]
[null,1,{"$f":"IF($B14=Betrachtungszeit_IKT_Einzel,C$10*(1+Inflationsindex)^$B14,0)","v":0},{"$f":"IF($B14=Betrachtungszeit_IKT_Einzel,D$10*(1+Inflationsindex)^$B14,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($B14=Betrachtungszeit_IKT_Einzel,S$10*(1+Inflationsindex)^$B14,0)","v":0},0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,{"$f":"IF($B15=Betrachtungszeit_IKT_Einzel,C$10*(1+Inflationsindex)^$B15,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y13:Y23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Coûts énergétiques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B26","v":"Valeur actuelle Coûts énergétiques"}]
[]
["K","Méthode de calcul de la consommation d'énergie","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,{"$f":"Input_TIC_individuel!AA10","v":"VEUILLEZ SÉLECTIONNER"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Input_TIC_individuel!AA11","v":"Consommation d'énergie selon la valeur TEC de Energy Star"},{"$f":"Input_TIC_individuel!D39","v":0},{"$f":"Input_TIC_individuel!E39","v":0},{"$f":"Input_TIC_individuel!F39","v":0},{"$f":"Input_TIC_individuel!G39","v":0},{"$f":"Input_TIC_individuel!H39","v":0},{"$f":"Input_TIC_individuel!I39","v":0},{"$f":"Input_TIC_individuel!J39","v":0},{"$f":"Input_TIC_individuel!K39","v":0},{"$f":"Input_TIC_individuel!L39","v":0},{"$f":"Input_TIC_individuel!M39","v":0},{"$f":"Input_TIC_individuel!N39","v":0},{"$f":"Input_TIC_individuel!O39","v":0},{"$f":"Input_TIC_individuel!P39","v":0},{"$f":"Input_TIC_individuel!Q39","v":0},{"$f":"Input_TIC_individuel!R39","v":0},{"$f":"Input_TIC_individuel!S39","v":0},{"$f":"Input_TIC_individuel!T39","v":0},{"$f":"Input_TIC_individuel!U39","v":0},{"$f":"Input_TIC_individuel!V39","v":0},{"$f":"Input_TIC_individuel!W39","v":0}]
[null,{"$f":"Input_TIC_individuel!AA12","v":"Calculer la consommation d'énergie à l'aide de la puissance électrique"},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!D41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!D42+IKT_ZustandComputer_Off*Input_TIC_individuel!D43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!D45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!D46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!E41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!E42+IKT_ZustandComputer_Off*Input_TIC_individuel!E43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!E45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!E46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!F41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!F42+IKT_ZustandComputer_Off*Input_TIC_individuel!F43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!F45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!F46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!G41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!G42+IKT_ZustandComputer_Off*Input_TIC_individuel!G43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!G45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!G46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!H41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!H42+IKT_ZustandComputer_Off*Input_TIC_individuel!H43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!H45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!H46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!I41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!I42+IKT_ZustandComputer_Off*Input_TIC_individuel!I43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!I45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!I46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!J41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!J42+IKT_ZustandComputer_Off*Input_TIC_individuel!J43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!J45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!J46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!K41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!K42+IKT_ZustandComputer_Off*Input_TIC_individuel!K43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!K45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!K46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!L41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!L42+IKT_ZustandComputer_Off*Input_TIC_individuel!L43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!L45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!L46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!M41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!M42+IKT_ZustandComputer_Off*Input_TIC_individuel!M43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!M45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!M46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!N41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!N42+IKT_ZustandComputer_Off*Input_TIC_individuel!N43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!N45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!N46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!O41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!O42+IKT_ZustandComputer_Off*Input_TIC_individuel!O43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!O45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!O46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!P41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!P42+IKT_ZustandComputer_Off*Input_TIC_individuel!P43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!P45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!P46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!Q41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!Q42+IKT_ZustandComputer_Off*Input_TIC_individuel!Q43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!Q45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!Q46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!R41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!R42+IKT_ZustandComputer_Off*Input_TIC_individuel!R43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!R45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!R46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!S41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!S42+IKT_ZustandComputer_Off*Input_TIC_individuel!S43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!S45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!S46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!T41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!T42+IKT_ZustandComputer_Off*Input_TIC_individuel!T43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!T45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!T46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!U41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!U42+IKT_ZustandComputer_Off*Input_TIC_individuel!U43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!U45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!U46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!V41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!V42+IKT_ZustandComputer_Off*Input_TIC_individuel!V43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!V45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!V46)","v":0},{"$f":"8760/1000*(IKT_ZustandComputer_Idle*Input_TIC_individuel!W41+IKT_ZustandComputer_Sleep*Input_TIC_individuel!W42+IKT_ZustandComputer_Off*Input_TIC_individuel!W43)+8760/1000*(IKT_ZustandMonitor_On*Input_TIC_individuel!W45+IKT_ZustandMonitor_Sleep*Input_TIC_individuel!W46)","v":0}]
[null,"Consommation d'énergie [kWh/an]",{"$f":"SUMIF($B$29:$B$31,vba_ICT_EnergieMethode,C29:C31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coûts de l'énergie [CHF/an]",{"$f":"C32*Strompreis/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coûts de l'énergie [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"D36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"E36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"F36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"G36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"H36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"I36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"J36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"K36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"L36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"M36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"N36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"O36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"P36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"Q36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"R36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"S36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"T36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"U36*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"V36*(1+Kalkulationszinssatz)^-$X13","v":0}]
[null,1,{"$f":"IF($B37<=Betrachtungszeit_IKT_Einzel,C33*(1+Energiepreissteigerung),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,C37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,D37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,E37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,F37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,G37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,H37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,I37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,J37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,K37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,L37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,M37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,N37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,O37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,P37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,Q37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,R37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,S37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,T37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,U37*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B38<=Betrachtungszeit_IKT_Einzel,V37*(1+Energiepreissteigerung),0)","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y36:Y46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Coûts d'exploitation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B49","v":"Valeur actuelle Coûts d'exploitation"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Installation de remplacement [CHF/an]",{"$f":"Input_TIC_individuel!D50","v":0},{"$f":"Input_TIC_individuel!E50","v":0},{"$f":"Input_TIC_individuel!F50","v":0},{"$f":"Input_TIC_individuel!G50","v":0},{"$f":"Input_TIC_individuel!H50","v":0},{"$f":"Input_TIC_individuel!I50","v":0},{"$f":"Input_TIC_individuel!J50","v":0},{"$f":"Input_TIC_individuel!K50","v":0},{"$f":"Input_TIC_individuel!L50","v":0},{"$f":"Input_TIC_individuel!M50","v":0},{"$f":"Input_TIC_individuel!N50","v":0},{"$f":"Input_TIC_individuel!O50","v":0},{"$f":"Input_TIC_individuel!P50","v":0},{"$f":"Input_TIC_individuel!Q50","v":0},{"$f":"Input_TIC_individuel!R50","v":0},{"$f":"Input_TIC_individuel!S50","v":0},{"$f":"Input_TIC_individuel!T50","v":0},{"$f":"Input_TIC_individuel!U50","v":0},{"$f":"Input_TIC_individuel!V50","v":0},{"$f":"Input_TIC_individuel!W50","v":0}]
[null,"Frais de stockage [CHF/an]",{"$f":"Input_TIC_individuel!D51","v":0},{"$f":"Input_TIC_individuel!E51","v":0},{"$f":"Input_TIC_individuel!F51","v":0},{"$f":"Input_TIC_individuel!G51","v":0},{"$f":"Input_TIC_individuel!H51","v":0},{"$f":"Input_TIC_individuel!I51","v":0},{"$f":"Input_TIC_individuel!J51","v":0},{"$f":"Input_TIC_individuel!K51","v":0},{"$f":"Input_TIC_individuel!L51","v":0},{"$f":"Input_TIC_individuel!M51","v":0},{"$f":"Input_TIC_individuel!N51","v":0},{"$f":"Input_TIC_individuel!O51","v":0},{"$f":"Input_TIC_individuel!P51","v":0},{"$f":"Input_TIC_individuel!Q51","v":0},{"$f":"Input_TIC_individuel!R51","v":0},{"$f":"Input_TIC_individuel!S51","v":0},{"$f":"Input_TIC_individuel!T51","v":0},{"$f":"Input_TIC_individuel!U51","v":0},{"$f":"Input_TIC_individuel!V51","v":0},{"$f":"Input_TIC_individuel!W51","v":0}]
[null,"Entretien interne et externe [CHF/an]",{"$f":"Input_TIC_individuel!D52+Input_TIC_individuel!D53","v":0},{"$f":"Input_TIC_individuel!E52+Input_TIC_individuel!E53","v":0},{"$f":"Input_TIC_individuel!F52+Input_TIC_individuel!F53","v":0},{"$f":"Input_TIC_individuel!G52+Input_TIC_individuel!G53","v":0},{"$f":"Input_TIC_individuel!H52+Input_TIC_individuel!H53","v":0},{"$f":"Input_TIC_individuel!I52+Input_TIC_individuel!I53","v":0},{"$f":"Input_TIC_individuel!J52+Input_TIC_individuel!J53","v":0},{"$f":"Input_TIC_individuel!K52+Input_TIC_individuel!K53","v":0},{"$f":"Input_TIC_individuel!L52+Input_TIC_individuel!L53","v":0},{"$f":"Input_TIC_individuel!M52+Input_TIC_individuel!M53","v":0},{"$f":"Input_TIC_individuel!N52+Input_TIC_individuel!N53","v":0},{"$f":"Input_TIC_individuel!O52+Input_TIC_individuel!O53","v":0},{"$f":"Input_TIC_individuel!P52+Input_TIC_individuel!P53","v":0},{"$f":"Input_TIC_individuel!Q52+Input_TIC_individuel!Q53","v":0},{"$f":"Input_TIC_individuel!R52+Input_TIC_individuel!R53","v":0},{"$f":"Input_TIC_individuel!S52+Input_TIC_individuel!S53","v":0},{"$f":"Input_TIC_individuel!T52+Input_TIC_individuel!T53","v":0},{"$f":"Input_TIC_individuel!U52+Input_TIC_individuel!U53","v":0},{"$f":"Input_TIC_individuel!V52+Input_TIC_individuel!V53","v":0},{"$f":"Input_TIC_individuel!W52+Input_TIC_individuel!W53","v":0}]
[null,"Assurances, impôts et taxes [CHF/an]",{"$f":"Input_TIC_individuel!D54","v":0},{"$f":"Input_TIC_individuel!E54","v":0},{"$f":"Input_TIC_individuel!F54","v":0},{"$f":"Input_TIC_individuel!G54","v":0},{"$f":"Input_TIC_individuel!H54","v":0},{"$f":"Input_TIC_individuel!I54","v":0},{"$f":"Input_TIC_individuel!J54","v":0},{"$f":"Input_TIC_individuel!K54","v":0},{"$f":"Input_TIC_individuel!L54","v":0},{"$f":"Input_TIC_individuel!M54","v":0},{"$f":"Input_TIC_individuel!N54","v":0},{"$f":"Input_TIC_individuel!O54","v":0},{"$f":"Input_TIC_individuel!P54","v":0},{"$f":"Input_TIC_individuel!Q54","v":0},{"$f":"Input_TIC_individuel!R54","v":0},{"$f":"Input_TIC_individuel!S54","v":0},{"$f":"Input_TIC_individuel!T54","v":0},{"$f":"Input_TIC_individuel!U54","v":0},{"$f":"Input_TIC_individuel!V54","v":0},{"$f":"Input_TIC_individuel!W54","v":0}]
[null,"Coûts d'exploitation supplémentaires [CHF/an]",{"$f":"Input_TIC_individuel!D55","v":0},{"$f":"Input_TIC_individuel!E55","v":0},{"$f":"Input_TIC_individuel!F55","v":0},{"$f":"Input_TIC_individuel!G55","v":0},{"$f":"Input_TIC_individuel!H55","v":0},{"$f":"Input_TIC_individuel!I55","v":0},{"$f":"Input_TIC_individuel!J55","v":0},{"$f":"Input_TIC_individuel!K55","v":0},{"$f":"Input_TIC_individuel!L55","v":0},{"$f":"Input_TIC_individuel!M55","v":0},{"$f":"Input_TIC_individuel!N55","v":0},{"$f":"Input_TIC_individuel!O55","v":0},{"$f":"Input_TIC_individuel!P55","v":0},{"$f":"Input_TIC_individuel!Q55","v":0},{"$f":"Input_TIC_individuel!R55","v":0},{"$f":"Input_TIC_individuel!S55","v":0},{"$f":"Input_TIC_individuel!T55","v":0},{"$f":"Input_TIC_individuel!U55","v":0},{"$f":"Input_TIC_individuel!V55","v":0},{"$f":"Input_TIC_individuel!W55","v":0}]
[null,"Total [CHF/an]",{"$f":"SUM(C52:C56)","v":0},{"$f":"SUM(D52:D56)","v":0},{"$f":"SUM(E52:E56)","v":0},{"$f":"SUM(F52:F56)","v":0},{"$f":"SUM(G52:G56)","v":0},{"$f":"SUM(H52:H56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coûts d'exploitation [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"D60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"E60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"F60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"G60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"H60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"I60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"J60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"K60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"L60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"M60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"N60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"O60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"P60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"Q60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"R60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"S60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"T60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"U60*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"V60*(1+Kalkulationszinssatz)^-$X13","v":0}]
[null,1,{"$f":"IF($B61<=Betrachtungszeit_IKT_Einzel,C57*(1+Inflationsindex),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,C61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,D61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,E61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,F61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,G61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,H61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,I61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,J61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,K61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,L61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,M61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,N61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,O61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,P61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,Q61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,R61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,S61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,T61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,U61*(1+Inflationsindex),0)","v":0},{"$f":"IF($B62<=Betrachtungszeit_IKT_Einzel,V61*(1+Inflationsindex),0)","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y60:Y70)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Coûts externes des émissions de gaz à effet de serre (émissions de GES)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B73","v":"Valeur actuelle Coûts externes des émissions de gaz à effet de serre (émissions de GES)"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Unités de charge écologique [UCE'13/an]",{"$f":"C32*UBP_Strom","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Émissions de GES (Scope 2) [tCO2eq/an]",{"$f":"C32*EF_Strom/1000000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["K",{"$f":"VLOOKUP(Données_de_base!B12,Données_de_base!B36:F39,5,0)","v":"Coûts pour GES: pas sélectionné"},{"$f":"C77*Kosten_THG","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Émissions de GES (Scope 3) [tCO2eq]",{"$f":"Input_TIC_individuel!D38/1000","v":0},{"$f":"Input_TIC_individuel!E38/1000","v":0},{"$f":"Input_TIC_individuel!F38/1000","v":0},{"$f":"Input_TIC_individuel!G38/1000","v":0},{"$f":"Input_TIC_individuel!H38/1000","v":0},{"$f":"Input_TIC_individuel!I38/1000","v":0},{"$f":"Input_TIC_individuel!J38/1000","v":0},{"$f":"Input_TIC_individuel!K38/1000","v":0},{"$f":"Input_TIC_individuel!L38/1000","v":0},{"$f":"Input_TIC_individuel!M38/1000","v":0},{"$f":"Input_TIC_individuel!N38/1000","v":0},{"$f":"Input_TIC_individuel!O38/1000","v":0},{"$f":"Input_TIC_individuel!P38/1000","v":0},{"$f":"Input_TIC_individuel!Q38/1000","v":0},{"$f":"Input_TIC_individuel!R38/1000","v":0},{"$f":"Input_TIC_individuel!S38/1000","v":0},{"$f":"Input_TIC_individuel!T38/1000","v":0},{"$f":"Input_TIC_individuel!U38/1000","v":0},{"$f":"Input_TIC_individuel!V38/1000","v":0},{"$f":"Input_TIC_individuel!W38/1000","v":0}]
["K",{"$f":"VLOOKUP(Données_de_base!B12,Données_de_base!B36:F39,5,0)","v":"Coûts pour GES: pas sélectionné"},{"$f":"C80*Kosten_THG","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coûts externes [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,{"$f":"C81","v":0},{"$f":"D81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"D84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"E84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"F84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"G84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"H84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"I84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"J84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"K84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"L84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"M84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"N84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"O84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"P84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"Q84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"R84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"S84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"T84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"U84*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"V84*(1+Kalkulationszinssatz)^-$X13","v":0}]
[null,1,{"$f":"IF($B85<=Betrachtungszeit_IKT_Einzel,C78*(1+Inflationsindex),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,C85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,D85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,E85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,F85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,G85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,H85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,I85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,J85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,K85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,L85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,M85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,N85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,O85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,P85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,Q85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,R85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,S85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,T85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,U85*(1+Inflationsindex),0)","v":0},{"$f":"IF($B86<=Betrachtungszeit_IKT_Einzel,V85*(1+Inflationsindex),0)","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y84:Y94)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Élimination à la fin de la période considérée pour le cycle de vie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B97","v":"Valeur actuelle Élimination à la fin de la période considérée pour le cycle de vie"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Coûts d'élimination [CHF]",{"$f":"Input_TIC_individuel!D59","v":0},{"$f":"Input_TIC_individuel!E59","v":0},{"$f":"Input_TIC_individuel!F59","v":0},{"$f":"Input_TIC_individuel!G59","v":0},{"$f":"Input_TIC_individuel!H59","v":0},{"$f":"Input_TIC_individuel!I59","v":0},{"$f":"Input_TIC_individuel!J59","v":0},{"$f":"Input_TIC_individuel!K59","v":0},{"$f":"Input_TIC_individuel!L59","v":0},{"$f":"Input_TIC_individuel!M59","v":0},{"$f":"Input_TIC_individuel!N59","v":0},{"$f":"Input_TIC_individuel!O59","v":0},{"$f":"Input_TIC_individuel!P59","v":0},{"$f":"Input_TIC_individuel!Q59","v":0},{"$f":"Input_TIC_individuel!R59","v":0},{"$f":"Input_TIC_individuel!S59","v":0},{"$f":"Input_TIC_individuel!T59","v":0},{"$f":"Input_TIC_individuel!U59","v":0},{"$f":"Input_TIC_individuel!V59","v":0},{"$f":"Input_TIC_individuel!W59","v":0}]
[null,"Coûts d'élimination [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,{"$f":"IF($B103=Betrachtungszeit_IKT_Einzel,C$100*(1+Inflationsindex)^$B103,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($B103=Betrachtungszeit_IKT_Einzel,M$100*(1+Inflationsindex)^$B103,0)","v":0},0,0,0,0,0,0,0,0,0,null,0,{"$f":"C103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"D103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"E103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"F103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"G103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"H103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"I103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"J103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"K103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"L103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"M103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"N103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"O103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"P103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"Q103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"R103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"S103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"T103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"U103*(1+Kalkulationszinssatz)^-$X13","v":0},{"$f":"V103*(1+Kalkulationszinssatz)^-$X13","v":0}]
[null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y103:Y113)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coûts additionnés (valeur actuelle) sur la période considérée et pour chaque unité"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année",{"$f":"Resultats_TIC_individuel!D5","v":"V1"},{"$f":"Resultats_TIC_individuel!E5","v":"V2"},{"$f":"Resultats_TIC_individuel!F5","v":"V3"},{"$f":"Resultats_TIC_individuel!G5","v":"V4"},{"$f":"Resultats_TIC_individuel!H5","v":"V5"},{"$f":"Resultats_TIC_individuel!I5","v":"V6"},{"$f":"Resultats_TIC_individuel!J5","v":"V7"},{"$f":"Resultats_TIC_individuel!K5","v":"V8"},{"$f":"Resultats_TIC_individuel!L5","v":"V9"},{"$f":"Resultats_TIC_individuel!M5","v":"V10"},{"$f":"Resultats_TIC_individuel!N5","v":"V11"},{"$f":"Resultats_TIC_individuel!O5","v":"V12"},{"$f":"Resultats_TIC_individuel!P5","v":"V13"},{"$f":"Resultats_TIC_individuel!Q5","v":"V14"},{"$f":"Resultats_TIC_individuel!R5","v":"V15"},{"$f":"Resultats_TIC_individuel!S5","v":"V16"},{"$f":"Resultats_TIC_individuel!T5","v":"V17"},{"$f":"Resultats_TIC_individuel!U5","v":"V18"},{"$f":"Resultats_TIC_individuel!V5","v":"V19"},{"$f":"Resultats_TIC_individuel!W5","v":"V20"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(Y13,Y36,Y60,Y84,Y103)*Anzahl_IKT","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(Y14,Y37,Y61,Y85,Y104)*Anzahl_IKT+Y119","v":0},{"$f":"SUM(Z14,Z37,Z61,Z85,Z104)*Anzahl_IKT+Z119","v":0},{"$f":"SUM(AA14,AA37,AA61,AA85,AA104)*Anzahl_IKT+AA119","v":0},{"$f":"SUM(AB14,AB37,AB61,AB85,AB104)*Anzahl_IKT+AB119","v":0},{"$f":"SUM(AC14,AC37,AC61,AC85,AC104)*Anzahl_IKT+AC119","v":0},{"$f":"SUM(AD14,AD37,AD61,AD85,AD104)*Anzahl_IKT+AD119","v":0},{"$f":"SUM(AE14,AE37,AE61,AE85,AE104)*Anzahl_IKT+AE119","v":0},{"$f":"SUM(AF14,AF37,AF61,AF85,AF104)*Anzahl_IKT+AF119","v":0},{"$f":"SUM(AG14,AG37,AG61,AG85,AG104)*Anzahl_IKT+AG119","v":0},{"$f":"SUM(AH14,AH37,AH61,AH85,AH104)*Anzahl_IKT+AH119","v":0},{"$f":"SUM(AI14,AI37,AI61,AI85,AI104)*Anzahl_IKT+AI119","v":0},{"$f":"SUM(AJ14,AJ37,AJ61,AJ85,AJ104)*Anzahl_IKT+AJ119","v":0},{"$f":"SUM(AK14,AK37,AK61,AK85,AK104)*Anzahl_IKT+AK119","v":0},{"$f":"SUM(AL14,AL37,AL61,AL85,AL104)*Anzahl_IKT+AL119","v":0},{"$f":"SUM(AM14,AM37,AM61,AM85,AM104)*Anzahl_IKT+AM119","v":0},{"$f":"SUM(AN14,AN37,AN61,AN85,AN104)*Anzahl_IKT+AN119","v":0},{"$f":"SUM(AO14,AO37,AO61,AO85,AO104)*Anzahl_IKT+AO119","v":0},{"$f":"SUM(AP14,AP37,AP61,AP85,AP104)*Anzahl_IKT+AP119","v":0},{"$f":"SUM(AQ14,AQ37,AQ61,AQ85,AQ104)*Anzahl_IKT+AQ119","v":0},{"$f":"SUM(AR14,AR37,AR61,AR85,AR104)*Anzahl_IKT+AR119","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Représentation diagramme feuille résultats"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année",{"$f":"Resultats_TIC_individuel!I25","v":"VEUILLEZ SÉLECTIONNER"},{"$f":"Resultats_TIC_individuel!I26","v":"VEUILLEZ SÉLECTIONNER"},{"$f":"Resultats_TIC_individuel!I27","v":"VEUILLEZ SÉLECTIONNER"},{"$f":"Resultats_TIC_individuel!I28","v":"VEUILLEZ SÉLECTIONNER"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X135+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X135+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X135+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X135+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X136+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X136+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X136+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X136+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X137+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X137+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X137+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X137+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X138+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X138+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X138+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X138+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X139+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X139+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X139+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X139+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X140+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X140+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X140+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X140+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X141+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X141+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X141+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X141+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X142+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X142+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X142+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X142+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X143+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X143+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X143+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X143+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X144+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X144+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X144+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X144+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$25,Calculs_TIC_individuel!$Y$118:$AR$129,$X145+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$26,Calculs_TIC_individuel!$Y$118:$AR$129,$X145+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$27,Calculs_TIC_individuel!$Y$118:$AR$129,$X145+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats_TIC_individuel!$I$28,Calculs_TIC_individuel!$Y$118:$AR$129,$X145+2,0)","v":{"$error":"#N/A"}}]

{"sheet":"Input_TIC_complet","index":5,"n_rows":125,"n_cols":23,"rows_kept":125,"cut":false,"hidden":false,"merged":[[4,2,4,4],[6,2,6,4],[5,2,5,4]]}
[null,"SAISIE DE DONNÉES AMÉNAGEMENT COMPLET TIC"]
[]
[null,"Données générales"]
[]
[null,"Projet"]
[null,"Entreprise"]
[null,"Responsable"]
[null,"Date"]
[]
["K","Période considérée pour calculer le coût du cycle de vie",null,"années"]
["K","Appareils TIC annoncés"]
[null,"Désignation","Nombre d'unités"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Produit"]
[null,"Variante",null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
["K","Désignation de variantes"]
[null,"Fournisseur"]
["K","Nombre d'unités proposées (y compris remplacement durant la période de garantie)"]
[null,{"$f":"IF(B13=\"\",\"Saisir la désignation sous Données générales\",B13)","v":"Saisir la désignation sous Données générales"},{"$f":"IF(B13=\"\",\"\",IF(MIN(D40:W40)<C13,\"Quantité d'au moins une variante < quantité annoncés\",\"\"))","v":""}]
[null,"Saisir la désignation sous Données générales",{"$f":"IF(B14=\"\",\"\",IF(MIN(D41:W41)<C14,\"Quantité d'au moins une variante < quantité annoncés\",\"\"))","v":""}]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[null,"Saisir la désignation sous Données générales",""]
[]
[null,"Coûts d'acquisition"]
[]
[null,"Prix de l'offre brut","CHF"]
[null,"Rabais","%"]
[null,"Prix d'achat négocié","CHF",{"$f":"D63*(1-D64)","v":0},{"$f":"E63*(1-E64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Frais de transport","CHF"]
[null,"Coûts initiaux uniques","CHF"]
[]
[null,"Consommation d'énergie et émissions de gaz à effet de serre (données relatives au calcul des coûts de l'énergie et coûts externes)"]
[]
["K","Product Carbon Footprint (sans phase \"Use\")",null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,{"$f":"IF(B13=\"\",\"Saisir la désignation sous Données générales\",B13)","v":"Saisir la désignation sous Données générales"},"kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,{"$f":"IF(B25=\"\",\"Saisir la désignation sous Données générales\",B25)","v":"Saisir la désignation sous Données générales"},"kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
[null,"Saisir la désignation sous Données générales","kgCO2eq/unité"]
["K","Consommation d'énergie selon Energy Star (valeur TEC)"]
[null,{"$f":"IF(B13=\"\",\"Saisir la désignation sous Données générales\",B13)","v":"Saisir la désignation sous Données générales"},"kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,{"$f":"IF(B19=\"\",\"Saisir la désignation sous Données générales\",B19)","v":"Saisir la désignation sous Données générales"},"kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[null,"Saisir la désignation sous Données générales","kWh/unité/an"]
[]
[null,"Coûts d'exploitation"]
[null,null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Frais de stockage","CHF/an"]
[null,"Frais de service","CHF/an"]
[null,"Coûts d'exploitation internes","CHF/an"]
[null,"Assurances, impôts et taxes","CHF/an"]
[null,"Coûts d'exploitation supplémentaires","CHF/an"]
[]
[null,"Coûts pour l'élimination"]
[]
["K","Coûts pour l'élimination","CHF"]
["K","Valeur résiduelle à la fin du calcul du cycle de vie","CHF"]

{"sheet":"Resultats__TIC_complet","index":6,"n_rows":77,"n_cols":23,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[null,"RÉSULTATS AMÉNAGEMENT COMPLET TIC"]
[]
[null,"Coûts du cycle de vie"]
[null,"Coûts des différentes variantes, considérés sur l'ensemble du cycle de vie (sous forme de valeur actuelle nette)."]
[null,null,null,{"$f":"Input_TIC_complet!D$36&IF(ISBLANK(Input_TIC_complet!D$37),\"\",\" (\"&LEFT(Input_TIC_complet!D$37,MIN(8,LEN(Input_TIC_complet!D$37)))&\")\")","v":"V1"},{"$f":"Input_TIC_complet!E$36&IF(ISBLANK(Input_TIC_complet!E$37),\"\",\" (\"&LEFT(Input_TIC_complet!E$37,MIN(8,LEN(Input_TIC_complet!E$37)))&\")\")","v":"V2"},{"$f":"Input_TIC_complet!F$36&IF(ISBLANK(Input_TIC_complet!F$37),\"\",\" (\"&LEFT(Input_TIC_complet!F$37,MIN(8,LEN(Input_TIC_complet!F$37)))&\")\")","v":"V3"},{"$f":"Input_TIC_complet!G$36&IF(ISBLANK(Input_TIC_complet!G$37),\"\",\" (\"&LEFT(Input_TIC_complet!G$37,MIN(8,LEN(Input_TIC_complet!G$37)))&\")\")","v":"V4"},{"$f":"Input_TIC_complet!H$36&IF(ISBLANK(Input_TIC_complet!H$37),\"\",\" (\"&LEFT(Input_TIC_complet!H$37,MIN(8,LEN(Input_TIC_complet!H$37)))&\")\")","v":"V5"},{"$f":"Input_TIC_complet!I$36&IF(ISBLANK(Input_TIC_complet!I$37),\"\",\" (\"&LEFT(Input_TIC_complet!I$37,MIN(8,LEN(Input_TIC_complet!I$37)))&\")\")","v":"V6"},{"$f":"Input_TIC_complet!J$36&IF(ISBLANK(Input_TIC_complet!J$37),\"\",\" (\"&LEFT(Input_TIC_complet!J$37,MIN(8,LEN(Input_TIC_complet!J$37)))&\")\")","v":"V7"},{"$f":"Input_TIC_complet!K$36&IF(ISBLANK(Input_TIC_complet!K$37),\"\",\" (\"&LEFT(Input_TIC_complet!K$37,MIN(8,LEN(Input_TIC_complet!K$37)))&\")\")","v":"V8"},{"$f":"Input_TIC_complet!L$36&IF(ISBLANK(Input_TIC_complet!L$37),\"\",\" (\"&LEFT(Input_TIC_complet!L$37,MIN(8,LEN(Input_TIC_complet!L$37)))&\")\")","v":"V9"},{"$f":"Input_TIC_complet!M$36&IF(ISBLANK(Input_TIC_complet!M$37),\"\",\" (\"&LEFT(Input_TIC_complet!M$37,MIN(8,LEN(Input_TIC_complet!M$37)))&\")\")","v":"V10"},{"$f":"Input_TIC_complet!N$36&IF(ISBLANK(Input_TIC_complet!N$37),\"\",\" (\"&LEFT(Input_TIC_complet!N$37,MIN(8,LEN(Input_TIC_complet!N$37)))&\")\")","v":"V11"},{"$f":"Input_TIC_complet!O$36&IF(ISBLANK(Input_TIC_complet!O$37),\"\",\" (\"&LEFT(Input_TIC_complet!O$37,MIN(8,LEN(Input_TIC_complet!O$37)))&\")\")","v":"V12"},{"$f":"Input_TIC_complet!P$36&IF(ISBLANK(Input_TIC_complet!P$37),\"\",\" (\"&LEFT(Input_TIC_complet!P$37,MIN(8,LEN(Input_TIC_complet!P$37)))&\")\")","v":"V13"},{"$f":"Input_TIC_complet!Q$36&IF(ISBLANK(Input_TIC_complet!Q$37),\"\",\" (\"&LEFT(Input_TIC_complet!Q$37,MIN(8,LEN(Input_TIC_complet!Q$37)))&\")\")","v":"V14"},{"$f":"Input_TIC_complet!R$36&IF(ISBLANK(Input_TIC_complet!R$37),\"\",\" (\"&LEFT(Input_TIC_complet!R$37,MIN(8,LEN(Input_TIC_complet!R$37)))&\")\")","v":"V15"},{"$f":"Input_TIC_complet!S$36&IF(ISBLANK(Input_TIC_complet!S$37),\"\",\" (\"&LEFT(Input_TIC_complet!S$37,MIN(8,LEN(Input_TIC_complet!S$37)))&\")\")","v":"V16"},{"$f":"Input_TIC_complet!T$36&IF(ISBLANK(Input_TIC_complet!T$37),\"\",\" (\"&LEFT(Input_TIC_complet!T$37,MIN(8,LEN(Input_TIC_complet!T$37)))&\")\")","v":"V17"},{"$f":"Input_TIC_complet!U$36&IF(ISBLANK(Input_TIC_complet!U$37),\"\",\" (\"&LEFT(Input_TIC_complet!U$37,MIN(8,LEN(Input_TIC_complet!U$37)))&\")\")","v":"V18"},{"$f":"Input_TIC_complet!V$36&IF(ISBLANK(Input_TIC_complet!V$37),\"\",\" (\"&LEFT(Input_TIC_complet!V$37,MIN(8,LEN(Input_TIC_complet!V$37)))&\")\")","v":"V19"},{"$f":"Input_TIC_complet!W$36&IF(ISBLANK(Input_TIC_complet!W$37),\"\",\" (\"&LEFT(Input_TIC_complet!W$37,MIN(8,LEN(Input_TIC_complet!W$37)))&\")\")","v":"V20"}]
[null,"Valeur actuelle nette",null,{"$f":"Input_TIC_complet!D38","v":0},{"$f":"Input_TIC_complet!E38","v":0},{"$f":"Input_TIC_complet!F38","v":0},{"$f":"Input_TIC_complet!G38","v":0},{"$f":"Input_TIC_complet!H38","v":0},{"$f":"Input_TIC_complet!I38","v":0},{"$f":"Input_TIC_complet!J38","v":0},{"$f":"Input_TIC_complet!K38","v":0},{"$f":"Input_TIC_complet!L38","v":0},{"$f":"Input_TIC_complet!M38","v":0},{"$f":"Input_TIC_complet!N38","v":0},{"$f":"Input_TIC_complet!O38","v":0},{"$f":"Input_TIC_complet!P38","v":0},{"$f":"Input_TIC_complet!Q38","v":0},{"$f":"Input_TIC_complet!R38","v":0},{"$f":"Input_TIC_complet!S38","v":0},{"$f":"Input_TIC_complet!T38","v":0},{"$f":"Input_TIC_complet!U38","v":0},{"$f":"Input_TIC_complet!V38","v":0},{"$f":"Input_TIC_complet!W38","v":0}]
[null,"Acquisition: Coûts d'acquisition déduction faite de la valeur résiduelle","CHF",{"$f":"Calculs__TIC_complet!Y25","v":0},{"$f":"Calculs__TIC_complet!Z25","v":0},{"$f":"Calculs__TIC_complet!AA25","v":0},{"$f":"Calculs__TIC_complet!AB25","v":0},{"$f":"Calculs__TIC_complet!AC25","v":0},{"$f":"Calculs__TIC_complet!AD25","v":0},{"$f":"Calculs__TIC_complet!AE25","v":0},{"$f":"Calculs__TIC_complet!AF25","v":0},{"$f":"Calculs__TIC_complet!AG25","v":0},{"$f":"Calculs__TIC_complet!AH25","v":0},{"$f":"Calculs__TIC_complet!AI25","v":0},{"$f":"Calculs__TIC_complet!AJ25","v":0},{"$f":"Calculs__TIC_complet!AK25","v":0},{"$f":"Calculs__TIC_complet!AL25","v":0},{"$f":"Calculs__TIC_complet!AM25","v":0},{"$f":"Calculs__TIC_complet!AN25","v":0},{"$f":"Calculs__TIC_complet!AO25","v":0},{"$f":"Calculs__TIC_complet!AP25","v":0},{"$f":"Calculs__TIC_complet!AQ25","v":0},{"$f":"Calculs__TIC_complet!AR25","v":0}]
[null,"Coûts énergétiques","CHF",{"$f":"Calculs__TIC_complet!Y46","v":0},{"$f":"Calculs__TIC_complet!Z46","v":0},{"$f":"Calculs__TIC_complet!AA46","v":0},{"$f":"Calculs__TIC_complet!AB46","v":0},{"$f":"Calculs__TIC_complet!AC46","v":0},{"$f":"Calculs__TIC_complet!AD46","v":0},{"$f":"Calculs__TIC_complet!AE46","v":0},{"$f":"Calculs__TIC_complet!AF46","v":0},{"$f":"Calculs__TIC_complet!AG46","v":0},{"$f":"Calculs__TIC_complet!AH46","v":0},{"$f":"Calculs__TIC_complet!AI46","v":0},{"$f":"Calculs__TIC_complet!AJ46","v":0},{"$f":"Calculs__TIC_complet!AK46","v":0},{"$f":"Calculs__TIC_complet!AL46","v":0},{"$f":"Calculs__TIC_complet!AM46","v":0},{"$f":"Calculs__TIC_complet!AN46","v":0},{"$f":"Calculs__TIC_complet!AO46","v":0},{"$f":"Calculs__TIC_complet!AP46","v":0},{"$f":"Calculs__TIC_complet!AQ46","v":0},{"$f":"Calculs__TIC_complet!AR46","v":0}]
[null,"Coûts d'exploitation","CHF",{"$f":"Calculs__TIC_complet!Y66","v":0},{"$f":"Calculs__TIC_complet!Z66","v":0},{"$f":"Calculs__TIC_complet!AA66","v":0},{"$f":"Calculs__TIC_complet!AB66","v":0},{"$f":"Calculs__TIC_complet!AC66","v":0},{"$f":"Calculs__TIC_complet!AD66","v":0},{"$f":"Calculs__TIC_complet!AE66","v":0},{"$f":"Calculs__TIC_complet!AF66","v":0},{"$f":"Calculs__TIC_complet!AG66","v":0},{"$f":"Calculs__TIC_complet!AH66","v":0},{"$f":"Calculs__TIC_complet!AI66","v":0},{"$f":"Calculs__TIC_complet!AJ66","v":0},{"$f":"Calculs__TIC_complet!AK66","v":0},{"$f":"Calculs__TIC_complet!AL66","v":0},{"$f":"Calculs__TIC_complet!AM66","v":0},{"$f":"Calculs__TIC_complet!AN66","v":0},{"$f":"Calculs__TIC_complet!AO66","v":0},{"$f":"Calculs__TIC_complet!AP66","v":0},{"$f":"Calculs__TIC_complet!AQ66","v":0},{"$f":"Calculs__TIC_complet!AR66","v":0}]
["K",{"$f":"VLOOKUP(Données_de_base!$B$12,Données_de_base!$B$36:$D$39,3,0)","v":"Coûts pour GES: pas sélectionné"},"CHF",{"$f":"Calculs__TIC_complet!Y90","v":0},{"$f":"Calculs__TIC_complet!Z90","v":0},{"$f":"Calculs__TIC_complet!AA90","v":0},{"$f":"Calculs__TIC_complet!AB90","v":0},{"$f":"Calculs__TIC_complet!AC90","v":0},{"$f":"Calculs__TIC_complet!AD90","v":0},{"$f":"Calculs__TIC_complet!AE90","v":0},{"$f":"Calculs__TIC_complet!AF90","v":0},{"$f":"Calculs__TIC_complet!AG90","v":0},{"$f":"Calculs__TIC_complet!AH90","v":0},{"$f":"Calculs__TIC_complet!AI90","v":0},{"$f":"Calculs__TIC_complet!AJ90","v":0},{"$f":"Calculs__TIC_complet!AK90","v":0},{"$f":"Calculs__TIC_complet!AL90","v":0},{"$f":"Calculs__TIC_complet!AM90","v":0},{"$f":"Calculs__TIC_complet!AN90","v":0},{"$f":"Calculs__TIC_complet!AO90","v":0},{"$f":"Calculs__TIC_complet!AP90","v":0},{"$f":"Calculs__TIC_complet!AQ90","v":0},{"$f":"Calculs__TIC_complet!AR90","v":0}]
[null,"Élimination: Coûts pour l'élimination","CHF",{"$f":"Calculs__TIC_complet!Y109","v":0},{"$f":"Calculs__TIC_complet!Z109","v":0},{"$f":"Calculs__TIC_complet!AA109","v":0},{"$f":"Calculs__TIC_complet!AB109","v":0},{"$f":"Calculs__TIC_complet!AC109","v":0},{"$f":"Calculs__TIC_complet!AD109","v":0},{"$f":"Calculs__TIC_complet!AE109","v":0},{"$f":"Calculs__TIC_complet!AF109","v":0},{"$f":"Calculs__TIC_complet!AG109","v":0},{"$f":"Calculs__TIC_complet!AH109","v":0},{"$f":"Calculs__TIC_complet!AI109","v":0},{"$f":"Calculs__TIC_complet!AJ109","v":0},{"$f":"Calculs__TIC_complet!AK109","v":0},{"$f":"Calculs__TIC_complet!AL109","v":0},{"$f":"Calculs__TIC_complet!AM109","v":0},{"$f":"Calculs__TIC_complet!AN109","v":0},{"$f":"Calculs__TIC_complet!AO109","v":0},{"$f":"Calculs__TIC_complet!AP109","v":0},{"$f":"Calculs__TIC_complet!AQ109","v":0},{"$f":"Calculs__TIC_complet!AR109","v":0}]
[null,"Total","CHF",{"$f":"SUM(D7:D11)","v":0},{"$f":"SUM(E7:E11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["K","Unités de charge écologique UCE'13 exploitation","UCE",{"$f":"Calculs__TIC_complet!C71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!D71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!E71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!F71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!G71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!H71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!I71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!J71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!K71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!L71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!M71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!N71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!O71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!P71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!Q71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!R71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!S71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!T71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!U71*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!V71*Betrachtungszeit_IKT_Gesamt","v":0}]
[null,"Émissions de gaz à effet de serre exploitation (Scope 2)","tCO2eq",{"$f":"Calculs__TIC_complet!C72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!D72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!E72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!F72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!G72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!H72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!I72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!J72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!K72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!L72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!M72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!N72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!O72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!P72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!Q72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!R72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!S72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!T72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!U72*Betrachtungszeit_IKT_Gesamt","v":0},{"$f":"Calculs__TIC_complet!V72*Betrachtungszeit_IKT_Gesamt","v":0}]
[null,"Émissions de gaz à effet de serre fabrication (Scope 3)","tCO2eq",{"$f":"Calculs__TIC_complet!C75","v":0},{"$f":"Calculs__TIC_complet!D75","v":0},{"$f":"Calculs__TIC_complet!E75","v":0},{"$f":"Calculs__TIC_complet!F75","v":0},{"$f":"Calculs__TIC_complet!G75","v":0},{"$f":"Calculs__TIC_complet!H75","v":0},{"$f":"Calculs__TIC_complet!I75","v":0},{"$f":"Calculs__TIC_complet!J75","v":0},{"$f":"Calculs__TIC_complet!K75","v":0},{"$f":"Calculs__TIC_complet!L75","v":0},{"$f":"Calculs__TIC_complet!M75","v":0},{"$f":"Calculs__TIC_complet!N75","v":0},{"$f":"Calculs__TIC_complet!O75","v":0},{"$f":"Calculs__TIC_complet!P75","v":0},{"$f":"Calculs__TIC_complet!Q75","v":0},{"$f":"Calculs__TIC_complet!R75","v":0},{"$f":"Calculs__TIC_complet!S75","v":0},{"$f":"Calculs__TIC_complet!T75","v":0},{"$f":"Calculs__TIC_complet!U75","v":0},{"$f":"Calculs__TIC_complet!V75","v":0}]
[]
[null,"Diagramme coûts du cycle de vie"]
[]
[]
[null,"Coûts additionnés (valeurs actuelles) des différentes variantes sur la période considérée"]
[]
[]
[null,null,null,null,null,null,null,null,"Variantes représentées"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[null,null,null,null,null,null,null,null,"VEUILLEZ SÉLECTIONNER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Auswahlfeld Dastellung Variante"]
[null,"BITTE WÄHLEN"]
[null,{"$f":"D$5","v":"V1"}]
[null,{"$f":"E$5","v":"V2"}]
[null,{"$f":"F$5","v":"V3"}]
[null,{"$f":"G$5","v":"V4"}]
[null,{"$f":"H$5","v":"V5"}]
[null,{"$f":"I$5","v":"V6"}]
[null,{"$f":"J$5","v":"V7"}]
[null,{"$f":"K$5","v":"V8"}]
[null,{"$f":"L$5","v":"V9"}]
[null,{"$f":"L$5","v":"V9"}]
[null,{"$f":"M$5","v":"V10"}]
[null,{"$f":"N$5","v":"V11"}]
[null,{"$f":"O$5","v":"V12"}]
[null,{"$f":"P$5","v":"V13"}]
[null,{"$f":"Q$5","v":"V14"}]
[null,{"$f":"R$5","v":"V15"}]
[null,{"$f":"S$5","v":"V16"}]
[null,{"$f":"T$5","v":"V17"}]
[null,{"$f":"U$5","v":"V18"}]
[null,{"$f":"V$5","v":"V19"}]
[null,{"$f":"W$5","v":"V20"}]

{"sheet":"Calculs__TIC_complet","index":7,"n_rows":140,"n_cols":44,"rows_kept":140,"cut":false,"hidden":false,"merged":[[110,23,110,43],[127,28,128,28],[2,1,2,6],[48,1,48,6],[67,1,67,6],[27,23,27,28],[48,23,48,28],[91,23,91,28]]}
[null,"CALCULS AMÉNAGEMENT COMPLET TIC"]
[]
[null,"Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B3","v":"Valeur actuelle Acquisition"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Coûts d'acquisition [CHF]",{"$f":"Input_TIC_complet!D65","v":0},{"$f":"Input_TIC_complet!E65","v":0},{"$f":"Input_TIC_complet!F65","v":0},{"$f":"Input_TIC_complet!G65","v":0},{"$f":"Input_TIC_complet!H65","v":0},{"$f":"Input_TIC_complet!I65","v":0},{"$f":"Input_TIC_complet!J65","v":0},{"$f":"Input_TIC_complet!K65","v":0},{"$f":"Input_TIC_complet!L65","v":0},{"$f":"Input_TIC_complet!M65","v":0},{"$f":"Input_TIC_complet!N65","v":0},{"$f":"Input_TIC_complet!O65","v":0},{"$f":"Input_TIC_complet!P65","v":0},{"$f":"Input_TIC_complet!Q65","v":0},{"$f":"Input_TIC_complet!R65","v":0},{"$f":"Input_TIC_complet!S65","v":0},{"$f":"Input_TIC_complet!T65","v":0},{"$f":"Input_TIC_complet!U65","v":0},{"$f":"Input_TIC_complet!V65","v":0},{"$f":"Input_TIC_complet!W65","v":0}]
[null,"Frais de transport [CHF]",{"$f":"Input_TIC_complet!D66","v":0},{"$f":"Input_TIC_complet!E66","v":0},{"$f":"Input_TIC_complet!F66","v":0},{"$f":"Input_TIC_complet!G66","v":0},{"$f":"Input_TIC_complet!H66","v":0},{"$f":"Input_TIC_complet!I66","v":0},{"$f":"Input_TIC_complet!J66","v":0},{"$f":"Input_TIC_complet!K66","v":0},{"$f":"Input_TIC_complet!L66","v":0},{"$f":"Input_TIC_complet!M66","v":0},{"$f":"Input_TIC_complet!N66","v":0},{"$f":"Input_TIC_complet!O66","v":0},{"$f":"Input_TIC_complet!P66","v":0},{"$f":"Input_TIC_complet!Q66","v":0},{"$f":"Input_TIC_complet!R66","v":0},{"$f":"Input_TIC_complet!S66","v":0},{"$f":"Input_TIC_complet!T66","v":0},{"$f":"Input_TIC_complet!U66","v":0},{"$f":"Input_TIC_complet!V66","v":0},{"$f":"Input_TIC_complet!W66","v":0}]
[null,"Coûts initiaux uniques [CHF]",{"$f":"Input_TIC_complet!D67","v":0},{"$f":"Input_TIC_complet!E67","v":0},{"$f":"Input_TIC_complet!F67","v":0},{"$f":"Input_TIC_complet!G67","v":0},{"$f":"Input_TIC_complet!H67","v":0},{"$f":"Input_TIC_complet!I67","v":0},{"$f":"Input_TIC_complet!J67","v":0},{"$f":"Input_TIC_complet!K67","v":0},{"$f":"Input_TIC_complet!L67","v":0},{"$f":"Input_TIC_complet!M67","v":0},{"$f":"Input_TIC_complet!N67","v":0},{"$f":"Input_TIC_complet!O67","v":0},{"$f":"Input_TIC_complet!P67","v":0},{"$f":"Input_TIC_complet!Q67","v":0},{"$f":"Input_TIC_complet!R67","v":0},{"$f":"Input_TIC_complet!S67","v":0},{"$f":"Input_TIC_complet!T67","v":0},{"$f":"Input_TIC_complet!U67","v":0},{"$f":"Input_TIC_complet!V67","v":0},{"$f":"Input_TIC_complet!W67","v":0}]
[null,"Total [CHF]",{"$f":"SUM(C6:C8)","v":0},{"$f":"SUM(D6:D8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["K","Valeur résiduelle à la fin du cycle de vie [CHF]",{"$f":"Input_TIC_complet!D125","v":0},{"$f":"Input_TIC_complet!E125","v":0},{"$f":"Input_TIC_complet!F125","v":0},{"$f":"Input_TIC_complet!G125","v":0},{"$f":"Input_TIC_complet!H125","v":0},{"$f":"Input_TIC_complet!I125","v":0},{"$f":"Input_TIC_complet!J125","v":0},{"$f":"Input_TIC_complet!K125","v":0},{"$f":"Input_TIC_complet!L125","v":0},{"$f":"Input_TIC_complet!M125","v":0},{"$f":"Input_TIC_complet!N125","v":0},{"$f":"Input_TIC_complet!O125","v":0},{"$f":"Input_TIC_complet!P125","v":0},{"$f":"Input_TIC_complet!Q125","v":0},{"$f":"Input_TIC_complet!R125","v":0},{"$f":"Input_TIC_complet!S125","v":0},{"$f":"Input_TIC_complet!T125","v":0},{"$f":"Input_TIC_complet!U125","v":0},{"$f":"Input_TIC_complet!V125","v":0},{"$f":"Input_TIC_complet!W125","v":0}]
[]
[null,"Coûts d'acquisition déduction faite de la valeur résiduelle [CHF] en prenant compte de la hausse de prix de l'année..."]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,{"$f":"C9","v":0},{"$f":"D9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"D14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"E14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"F14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"G14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"H14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"I14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"J14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"K14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"L14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"M14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"N14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"O14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"P14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"Q14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"R14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"S14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"T14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"U14*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"V14*(1+Kalkulationszinssatz)^-$X14","v":0}]
[null,1,{"$f":"IF($B15=Betrachtungszeit_IKT_Gesamt,C$10*(1+Inflationsindex)^$B15,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($B15=Betrachtungszeit_IKT_Gesamt,M$10*(1+Inflationsindex)^$B15,0)","v":0},0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y14:Y24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Coûts énergétiques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B28","v":"Valeur actuelle Coûts énergétiques"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Consommation d'énergie [kWh/an]",{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!D$93:D$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!E$93:E$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!F$93:F$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!G$93:G$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!H$93:H$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!I$93:I$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!J$93:J$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!K$93:K$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!L$93:L$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!M$93:M$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!N$93:N$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!O$93:O$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!P$93:P$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!Q$93:Q$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!R$93:R$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!S$93:S$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!T$93:T$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!U$93:U$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!V$93:V$112)","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!$C$13:$C$32,Input_TIC_complet!W$93:W$112)","v":0}]
[null,"Coûts de l'énergie [CHF/an]",{"$f":"C31*Strompreis/100","v":0},{"$f":"D31*Strompreis/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coûts de l'énergie [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"D35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"E35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"F35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"G35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"H35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"I35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"J35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"K35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"L35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"M35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"N35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"O35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"P35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"Q35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"R35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"S35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"T35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"U35*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"V35*(1+Kalkulationszinssatz)^-$X14","v":0}]
[null,1,{"$f":"IF($B36<=Betrachtungszeit_IKT_Gesamt,C32*(1+Energiepreissteigerung),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,C36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,D36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,E36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,F36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,G36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,H36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,I36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,J36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,K36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,L36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,M36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,N36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,O36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,P36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,Q36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,R36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,S36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,T36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,U36*(1+Energiepreissteigerung),0)","v":0},{"$f":"IF($B37<=Betrachtungszeit_IKT_Gesamt,V36*(1+Energiepreissteigerung),0)","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y35:Y45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Coûts d'exploitation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B49","v":"Valeur actuelle Coûts d'exploitation"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Coûts d'exploitation totaux [CHF/an]",{"$f":"SUM(Input_TIC_complet!D116:D120)","v":0},{"$f":"SUM(Input_TIC_complet!E116:E120)","v":0},{"$f":"SUM(Input_TIC_complet!F116:F120)","v":0},{"$f":"SUM(Input_TIC_complet!G116:G120)","v":0},{"$f":"SUM(Input_TIC_complet!H116:H120)","v":0},{"$f":"SUM(Input_TIC_complet!I116:I120)","v":0},{"$f":"SUM(Input_TIC_complet!J116:J120)","v":0},{"$f":"SUM(Input_TIC_complet!K116:K120)","v":0},{"$f":"SUM(Input_TIC_complet!L116:L120)","v":0},{"$f":"SUM(Input_TIC_complet!M116:M120)","v":0},{"$f":"SUM(Input_TIC_complet!N116:N120)","v":0},{"$f":"SUM(Input_TIC_complet!O116:O120)","v":0},{"$f":"SUM(Input_TIC_complet!P116:P120)","v":0},{"$f":"SUM(Input_TIC_complet!Q116:Q120)","v":0},{"$f":"SUM(Input_TIC_complet!R116:R120)","v":0},{"$f":"SUM(Input_TIC_complet!S116:S120)","v":0},{"$f":"SUM(Input_TIC_complet!T116:T120)","v":0},{"$f":"SUM(Input_TIC_complet!U116:U120)","v":0},{"$f":"SUM(Input_TIC_complet!V116:V120)","v":0},{"$f":"SUM(Input_TIC_complet!W116:W120)","v":0}]
[null,"Coûts d'exploitation [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"D55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"E55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"F55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"G55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"H55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"I55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"J55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"K55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"L55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"M55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"N55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"O55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"P55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"Q55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"R55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"S55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"T55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"U55*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"V55*(1+Kalkulationszinssatz)^-$X14","v":0}]
[null,1,{"$f":"IF($B56<=Betrachtungszeit_IKT_Gesamt,C52*(1+Inflationsindex),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,C56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,D56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,E56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,F56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,G56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,H56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,I56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,J56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,K56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,L56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,M56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,N56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,O56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,P56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,Q56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,R56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,S56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,T56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,U56*(1+Inflationsindex),0)","v":0},{"$f":"IF($B57<=Betrachtungszeit_IKT_Gesamt,V56*(1+Inflationsindex),0)","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y55:Y65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Coûts externes des émissions de gaz à effet de serre (émissions de GES)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B68","v":"Valeur actuelle Coûts externes des émissions de gaz à effet de serre (émissions de GES)"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Unités de charge écologique [UCE'13/an]",{"$f":"C31*UBP_Strom","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Émissions de GES (Scope 2) [tCO2eq/an]",{"$f":"C31*EF_Strom/1000000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["K",{"$f":"VLOOKUP(Données_de_base!B12,Données_de_base!B36:F39,5,0)","v":"Coûts pour GES: pas sélectionné"},{"$f":"C72*Kosten_THG","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Émissions de GES (Scope 3) [tCO2eq]",{"$f":"SUMPRODUCT(Input_TIC_complet!D40:D59,Input_TIC_complet!D72:D91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!E40:E59,Input_TIC_complet!E72:E91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!F40:F59,Input_TIC_complet!F72:F91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!G40:G59,Input_TIC_complet!G72:G91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!H40:H59,Input_TIC_complet!H72:H91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!I40:I59,Input_TIC_complet!I72:I91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!J40:J59,Input_TIC_complet!J72:J91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!K40:K59,Input_TIC_complet!K72:K91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!L40:L59,Input_TIC_complet!L72:L91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!M40:M59,Input_TIC_complet!M72:M91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!N40:N59,Input_TIC_complet!N72:N91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!O40:O59,Input_TIC_complet!O72:O91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!P40:P59,Input_TIC_complet!P72:P91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!Q40:Q59,Input_TIC_complet!Q72:Q91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!R40:R59,Input_TIC_complet!R72:R91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!S40:S59,Input_TIC_complet!S72:S91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!T40:T59,Input_TIC_complet!T72:T91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!U40:U59,Input_TIC_complet!U72:U91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!V40:V59,Input_TIC_complet!V72:V91)/1000","v":0},{"$f":"SUMPRODUCT(Input_TIC_complet!W40:W59,Input_TIC_complet!W72:W91)/1000","v":0}]
["K",{"$f":"VLOOKUP(Données_de_base!B12,Données_de_base!B36:F39,5,0)","v":"Coûts pour GES: pas sélectionné"},{"$f":"C75*Kosten_THG","v":0},{"$f":"D75*Kosten_THG","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Coûts externes [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,{"$f":"C76","v":0},{"$f":"D76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"C79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"D79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"E79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"F79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"G79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"H79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"I79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"J79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"K79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"L79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"M79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"N79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"O79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"P79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"Q79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"R79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"S79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"T79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"U79*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"V79*(1+Kalkulationszinssatz)^-$X14","v":0}]
[null,1,{"$f":"IF($B80<=Betrachtungszeit_IKT_Gesamt,C73*(1+Inflationsindex),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,C80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,D80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,E80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,F80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,G80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,H80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,I80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,J80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,K80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,L80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,M80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,N80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,O80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,P80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,Q80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,R80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,S80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,T80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,U80*(1+Inflationsindex),0)","v":0},{"$f":"IF($B81<=Betrachtungszeit_IKT_Gesamt,V80*(1+Inflationsindex),0)","v":0},null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y79:Y89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Élimination à la fin de la période considérée pour le cycle de vie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Valeur actuelle \"&B92","v":"Valeur actuelle Élimination à la fin de la période considérée pour le cycle de vie"}]
[]
[null,null,"V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,"Coûts d'élimination [CHF]",{"$f":"Input_TIC_complet!D124","v":0},{"$f":"Input_TIC_complet!E124","v":0},{"$f":"Input_TIC_complet!F124","v":0},{"$f":"Input_TIC_complet!G124","v":0},{"$f":"Input_TIC_complet!H124","v":0},{"$f":"Input_TIC_complet!I124","v":0},{"$f":"Input_TIC_complet!J124","v":0},{"$f":"Input_TIC_complet!K124","v":0},{"$f":"Input_TIC_complet!L124","v":0},{"$f":"Input_TIC_complet!M124","v":0},{"$f":"Input_TIC_complet!N124","v":0},{"$f":"Input_TIC_complet!O124","v":0},{"$f":"Input_TIC_complet!P124","v":0},{"$f":"Input_TIC_complet!Q124","v":0},{"$f":"Input_TIC_complet!R124","v":0},{"$f":"Input_TIC_complet!S124","v":0},{"$f":"Input_TIC_complet!T124","v":0},{"$f":"Input_TIC_complet!U124","v":0},{"$f":"Input_TIC_complet!V124","v":0},{"$f":"Input_TIC_complet!W124","v":0}]
[null,"Coûts d'élimination [CHF] en tenant compte de la hausse de prix à la fin de l'année..."]
[null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20",null,"Année","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20"]
[null,0,{"$f":"IF($B98=Betrachtungszeit_IKT_Gesamt,C$95*(1+Inflationsindex)^$B98,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($B98=Betrachtungszeit_IKT_Gesamt,M$95*(1+Inflationsindex)^$B98,0)","v":0},0,0,0,0,0,0,0,0,0,null,0,{"$f":"C98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"D98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"E98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"F98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"G98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"H98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"I98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"J98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"K98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"L98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"M98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"N98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"O98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"P98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"Q98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"R98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"S98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"T98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"U98*(1+Kalkulationszinssatz)^-$X14","v":0},{"$f":"V98*(1+Kalkulationszinssatz)^-$X14","v":0}]
[null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Y98:Y108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coûts additionnés (valeur actuelle) sur la période considérée"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année",{"$f":"Resultats__TIC_complet!D5","v":"V1"},{"$f":"Resultats__TIC_complet!E5","v":"V2"},{"$f":"Resultats__TIC_complet!F5","v":"V3"},{"$f":"Resultats__TIC_complet!G5","v":"V4"},{"$f":"Resultats__TIC_complet!H5","v":"V5"},{"$f":"Resultats__TIC_complet!I5","v":"V6"},{"$f":"Resultats__TIC_complet!J5","v":"V7"},{"$f":"Resultats__TIC_complet!K5","v":"V8"},{"$f":"Resultats__TIC_complet!L5","v":"V9"},{"$f":"Resultats__TIC_complet!M5","v":"V10"},{"$f":"Resultats__TIC_complet!N5","v":"V11"},{"$f":"Resultats__TIC_complet!O5","v":"V12"},{"$f":"Resultats__TIC_complet!P5","v":"V13"},{"$f":"Resultats__TIC_complet!Q5","v":"V14"},{"$f":"Resultats__TIC_complet!R5","v":"V15"},{"$f":"Resultats__TIC_complet!S5","v":"V16"},{"$f":"Resultats__TIC_complet!T5","v":"V17"},{"$f":"Resultats__TIC_complet!U5","v":"V18"},{"$f":"Resultats__TIC_complet!V5","v":"V19"},{"$f":"Resultats__TIC_complet!W5","v":"V20"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(Y14,Y35,Y55,Y79,Y98)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(Y15,Y36,Y56,Y80,Y99)+Y114","v":0},{"$f":"SUM(Z15,Z36,Z56,Z80,Z99)+Z114","v":0},{"$f":"SUM(AA15,AA36,AA56,AA80,AA99)+AA114","v":0},{"$f":"SUM(AB15,AB36,AB56,AB80,AB99)+AB114","v":0},{"$f":"SUM(AC15,AC36,AC56,AC80,AC99)+AC114","v":0},{"$f":"SUM(AD15,AD36,AD56,AD80,AD99)+AD114","v":0},{"$f":"SUM(AE15,AE36,AE56,AE80,AE99)+AE114","v":0},{"$f":"SUM(AF15,AF36,AF56,AF80,AF99)+AF114","v":0},{"$f":"SUM(AG15,AG36,AG56,AG80,AG99)+AG114","v":0},{"$f":"SUM(AH15,AH36,AH56,AH80,AH99)+AH114","v":0},{"$f":"SUM(AI15,AI36,AI56,AI80,AI99)+AI114","v":0},{"$f":"SUM(AJ15,AJ36,AJ56,AJ80,AJ99)+AJ114","v":0},{"$f":"SUM(AK15,AK36,AK56,AK80,AK99)+AK114","v":0},{"$f":"SUM(AL15,AL36,AL56,AL80,AL99)+AL114","v":0},{"$f":"SUM(AM15,AM36,AM56,AM80,AM99)+AM114","v":0},{"$f":"SUM(AN15,AN36,AN56,AN80,AN99)+AN114","v":0},{"$f":"SUM(AO15,AO36,AO56,AO80,AO99)+AO114","v":0},{"$f":"SUM(AP15,AP36,AP56,AP80,AP99)+AP114","v":0},{"$f":"SUM(AQ15,AQ36,AQ56,AQ80,AQ99)+AQ114","v":0},{"$f":"SUM(AR15,AR36,AR56,AR80,AR99)+AR114","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Représentation diagramme feuille résultats"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Année",{"$f":"Resultats__TIC_complet!I25","v":"VEUILLEZ SÉLECTIONNER"},{"$f":"Resultats__TIC_complet!I26","v":"VEUILLEZ SÉLECTIONNER"},{"$f":"Resultats__TIC_complet!I27","v":"VEUILLEZ SÉLECTIONNER"},{"$f":"Resultats__TIC_complet!I28","v":"VEUILLEZ SÉLECTIONNER"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X130+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X130+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X130+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X130+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X131+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X131+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X131+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X131+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X132+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X132+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X132+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X132+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X133+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X133+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X133+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X133+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X134+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X134+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X134+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X134+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X135+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X135+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X135+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X135+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X136+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X136+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X136+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X136+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X137+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X137+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X137+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X137+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X138+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X138+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X138+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X138+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X139+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X139+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X139+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X139+2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"HLOOKUP(Resultats__TIC_complet!$I$25,Calculs__TIC_complet!$Y$113:$AR$124,$X140+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$26,Calculs__TIC_complet!$Y$113:$AR$124,$X140+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$27,Calculs__TIC_complet!$Y$113:$AR$124,$X140+2,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Resultats__TIC_complet!$I$28,Calculs__TIC_complet!$Y$113:$AR$124,$X140+2,0)","v":{"$error":"#N/A"}}]

{"sheet":"Annexe","index":8,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[17,1,17,7],[23,1,23,7],[16,1,16,7],[25,1,25,7],[22,1,22,7],[20,1,20,7],[19,1,19,7],[21,1,21,7],[24,1,24,7],[18,1,18,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,3,31,7],[32,3,32,7],[33,3,33,7],[34,3,34,7],[35,3,35,7],[36,3,36,7],[37,3,37,7],[38,3,38,7],[39,3,39,7],[40,3,40,7],[41,3,41,7],[42,3,42,7],[48,3,48,7],[49,3,49,7],[50,3,50,7],[43,3,43,7],[44,3,44,7],[45,3,45,7],[46,3,46,7],[47,3,47,7],[9,1,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7]]}
[null,"ANNEXE"]
[]
[null,"Références des sources"]
[]
[null,"ARE (2019): Effets externes des transports 2015, Office fédéral du développement territorial ARE, 2019"]
[null,"OFS (2019): Prix à la consommation pour l'énergie, OFS, 2019"]
[null,"OFS (2019): IPC, indice total sur toutes les bases de l'indice,  Indice national des prix à la consommation en juin 2019,  Office fédéral de la statistique OFS, 2019"]
[null,"Energy Star (2020): Program Requirements for Displays, Version 8.0, Energy Star, 2020"]
[null,"UE (2013): Ordonnance (UE) no 617/2013 de la commission du 26 juin 2013 sur la mise en œuvre de la directive 2009/125/CE du Parlement européen et du Conseil en vue de la fixation d'exigences en matière d'écoconception applicables aux ordinateurs et aux serveurs informatiques, UE, 2013"]
[null,"UPIC (2019): P025 - Normes énergétiques et environnementales pour l'acquisition de l'infrastructure TIC ,Unité de pilotage informatique de la Confédération UPIC, mars 2019"]
[null,"KBOB (2016): Données des écobilans dans la construction, 2009/1:2016, KBOB, 2016"]
[null,"myclimate (2019): www.myclimate.org"]
[null,"Ville de Zurich, Office des constructions (2011): Rentabilité des investissements dédiés aux nouvelles constructions et aux rénovations dans la société à 2000 watts, Ville de Zurich, Office des constructions, 2011"]
[]
[null,"Glossaire"]
[]
[null,"Valeur actuelle: valeur escomptée des dépenses (et des recettes) au moment de l'investissement (année de départ), au taux d'intérêt de calcul."]
[null,"Coûts externes: on entend par coûts externes les dommages non compensés résultant de décisions économiques sur des parties non impliquées, c'est-à-dire les dommages pour lesquelles personne ne paie. On peut citer comme exemple les conséquences du changement climatique supportées par la collectivité, non comprises dans le prix d'un billet d'avion, alors que les voyages en avion contribuent considérablement au réchauffement climatique de par les émissions de CO2 qu'ils engendrent. La tarification CO2 constitue un moyen d'internaliser ces coûts externes. "]
[null,"TIC: abréviation de Technologies de l'information et de la communication. La forme anglophone «ICT» est aussi employée régulièrement."]
[null,"Taux d'intérêt de calcul: dans le contexte de l'analyse de rentabilité, les frais d'intérêt représentent les intérêts sur la totalité du capital investi. Il ne s'agit donc pas uniquement des intérêts sur les capitaux de tiers, mais aussi d'un intérêt sur la part des investissements financée par le capital propre. L'investisseur s'attend en effet aussi à recevoir des intérêts pour son capital propre, d'un montant au moins équivalent aux recettes d'intérêts qu'il aurait reçues en plaçant son capital d'une autre manière. Le choix du taux d'intérêt de calcul est, dans une certaine mesure, une affaire d'appréciation."]
[null,"Valeur en capital (valeur actuelle nette): somme des valeurs actuelles de toutes les dépenses (et recettes) d'un projet sur la période considérée (=valeur actuelle nette)"]
[null,"Coûts du cycle de vie: outre les coûts d'acquisition, d'exploitation et d'entretien, les coûts du cycle de vie au sens de la norme ISO 20400 concernent également les coûts indirects que la production, l'exploitation et l'élimination font subir à l'environnement/la société et qui peuvent être monétisés. La monétisation des coûts externes est complexe et est actuellement promue par la Confédération. Le présent outil permet de prendre en compte les coûts externes des gaz à effet de serre déjà monétisés. Les autres coûts externes répercutés sur l'environnement/la société seront intégrés aussitôt que les données correspondantes seront disponibles.\n\nLe calcul des coûts du cycle de vie s'effectue à l'aide de la méthode de la valeur actuelle nette. La méthode de la valeur actuelle nette est une procédure dynamique de calcul des investissements, c'est-à-dire que tous les flux financiers sont rapportés au moment où ils sont encourus et peuvent être comparés, à une même date, à l'aide d'un facteur d'intérêt. \nCela permet de déterminer la valeur actuelle totale d'un investissement (la valeur en capital). Cela est intéressant si l'on part du principe que les alternatives respectueuses de l'environnement présentent souvent des coûts d'acquisition plus élevés, mais des frais d'exploitation plus faibles. Cependant, le fait de dépenser plus d'argent au début d'un investissement mène aussi à payer plus d'intérêts, ou réduit les possibilités de placer de l'argent ailleurs (de manière rentable). Ces circonstances sont prises en compte grâce à l'actualisation (ou l’escompte) des flux financiers futurs à une date donnée."]
[null,"TVA: les coûts doivent être indiqués de manière cohérente - soit tous avec TVA, soit tous sans TVA"]
[null,"Valeur actuelle nette: cf. valeur en capital."]
[null,"Scopes 1, 2 et 3: le concept de périmètre d'émissions du protocole GES (scopes 1, 2 et 3) s'est imposé et est utilisé dans le présent outil. Définitions:\nScope 1: émissions directes de gaz à effet de serre dans le périmètre de l'entreprise, induites par exemple par la combustion de carburants et combustibles fossiles.\nScope 2: émissions induites par l'approvisionnement énergétique, mais qui ne sont pas générées dans le périmètre de l'entreprise (p. ex. électricité et chaleur à distance).\nScope 3: émissions induites par tous les processus en amont et en aval. Par exemple, les émissions générées par la fabrication et l'élimination d'un produit acheté par l'entreprise appartiennent au scope 3."]
[null,"Unités de charge écologique: les unités de charge écologique 2013 (UCE'13) quantifient les impacts environnementaux générés par l'utilisation des ressources énergétiques et matérielles, l'utilisation de terrain et d'eau douce, les émissions dans l'air, les eaux et les sols, les dépôts de résidus issus du traitement des déchets et le bruit du trafic routier. Les unités de charge écologique dues à la consommation d'énergie en entreprise, et le cas échéant à la fabrication/l'élimination de produits, sont indiquées mais ne sont pas prises en compte dans le calcul des coûts du cycle de vie."]
[null,"Journal des modifications"]
[]
[null,"Version, date","Feuille de calcul","Modification"]
[null,"Version bêta, 15.09.2020"]
[null,"Version bêta, 01.02.2021","tous","Textes"]