{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Erweiterte Version","Annexe","Eligibilité","Exemple"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":89,"comments":3,"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":"Erweiterte Version","index":0,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,20]]}
["            Wirtschaftliche Beurteilung einer Photovoltaikanlage (für natürliche Personen)"]
[null,"Technische Angaben ",null,null,null,null,"Finanzielle Angaben ",null,null,null,null,"Steuerwesen ",null,null,null,null,null,"Kauf / Verkauf von Elektrizität ",null,null,null,null,null,"Rétribution unique"]
[null,"Modulfläche (m2)",null,null,40,null,"Gesamte Anlagekosten (CHF)",null,null,20000,null,"Grenzsteuersatz auf Investitionen ",null,null,0.15,null,null,"Eigenverbrauch (kWh/a)",null,null,2300]
[null,"Anlagetyp",null,null,"Ajoutée",null,"Gemeindesubvention (CHF)",null,null,0,null,"Fiskaleffekte berücksichtigt ",null,null,"oui",null,null,"Verkaufsanteil an der produzierten Elektrizität ",null,null,{"$f":"1-U3/production_annuelle","v":0.65151515151515149},null,null,"base",{"$f":"ru_base","v":1400}]
[null,"Installierte Leistung (kWp)",null,null,6,null,"Anfänglicher Investitionsbetrag (CHF)",null,null,{"$f":"cout_total-subvention_communale-subvention_init_avancee","v":13500},null,"Grenzsteuersatz auf Einnahmen ",null,null,0.2,null,null,"KEV-Vergütungstarif für Stromverkauf (Fr./kWh)",null,null,{"$f":"rpc_version_avancee","v":0.26400000000000001},null,null,"puissance",{"$f":"ru_puissance","v":850}]
[null,"Max. Leistung pro m2 (Wp)",null,null,{"$f":"puissance_installee/E3*1000","v":150},null,"Eigenkapital ",null,{"$f":"inv_initial*J6","v":13500},1,null,"Unbesteuertes Produktionsvolumen (kWh)",null,null,10000,null,null,"Tarif Verkauf an Stromverteiler (Fr./kWh)",null,null,0.06]
[null,"Leistungskategorie",null,null,{"$f":"IF(puissance_installee<=2,0,IF(puissance_installee<=10,\"A\",IF(puissance_installee<=30,\"B\",IF(puissance_installee<=100,\"C\",IF(puissance_installee<=1000,\"D\",\"E\")))))","v":"A"},null,"Fremdkapital ",null,{"$f":"inv_initial-fond_propre","v":0},{"$f":"1-J6","v":0},null,"Typ der Finanzhilfe",null,null,null,null,null,"Tarif Ankauf vom Stromverteiler (Fr./kWh)",null,null,0.18]
[null,"Spezifische Produktion (kWh/kWp)",null,null,1100,null,"Zinssatz für Fremdkapital ",null,null,2.75E-2,null,"Verfügbarer Finanzhilfe ",null,null,{"$f":"mode_subvention_dispo","v":"EIV"},null,null,"Jährlicher Anstieg des Strompreises ",null,null,2.5000000000000001E-2]
[null,"Jährliche Produktionsabnahme",null,null,8.0000000000000002E-3,null,"Spezifische Anlagekosten (CHF/kWp)",null,null,{"$f":"cout_total/puissance_installee","v":3333.3333333333335},null,"Wahl der Finanzhilfe  ",null,null,"EIV",null,null,"Ø-Stromtarif (Ankauf) für 25 Jahre (CHF/kWH)",null,null,{"$f":"tarif_achat_elec_distributeur*(1-(1+croissance_prix_elec)^26)/(1-(1+croissance_prix_elec))/26","v":0.24931182483144282}]
[null,"Anfängliche Jahresproduktkion (kWh/a)",null,null,{"$f":"production_specifique*puissance_installee","v":6600},null,"Amortisationsdauer (Jahre)",null,null,25,null,"Anmeldejahr ",null,null,2014,null,null,"Ø-Stromtarif (Ankauf) nach 25 Jahren (CHF/kWh)",null,null,{"$f":"tarif_achat_elec_distributeur*(1+croissance_prix_elec)^(25-1)","v":0.32557067092486597}]
[null,null,null,null,null,null,"Jährliche Kosten (Versicherungen, usw.)",null,null,3.0000000000000001E-3,null,"Datum Inbetriebnahme ",null,null,"2014-06-01",null,null,"Wartezeit für KEV (Jahre)",null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,"Anfängliche Subvention EIV (CHF)",null,null,{"$f":"IF(type_subvention_avancee=\"EIV\",ru_base+ru_puissance*puissance_installee,0)","v":6500},{"$f":"subvention_init_avancee/cout_total","v":0.32500000000000001},null,"Erhalt KEV (Anzahl Jahre)",null,null,{"$f":"IF(date_mise_en_service>DATE(2014,1,1),20,25)","v":20}]
[]
[null,"Ergebnisse ",null,null,null,null,null,null,null,null,null,"Erweiterte Finanzergebnisse "]
[null,"Breakeven / Zeithorizont ",null,null,{"$f":"COUNTIF(Q22:Q47,\"neg\")","v":18},null,"Eigenkapitalrendite pro Jahr",null,null,{"$f":"IF(fond_propre=0,\"-\",((P47/fond_propre+1)^(1/25)-1))","v":1.3753592751139632E-2},null,"Eigenkapitalrendite ",null,null,0]
[null,"Dauer Schuldenabbau (Jahre)",null,null,{"$f":"COUNTIF(N23:N47,\"<>0\")","v":0},null,"Jährliche Rendite des Vorhabens ",null,null,{"$f":"((M49/inv_initial+1)^(1/25)-1)","v":1.3753592751139632E-2},null,"Kapitalkosten (WACC)",null,null,{"$f":"'Erweiterte Version'!J6*O15+'Erweiterte Version'!J7*taux_interet*(1-taux_deduction_fiscale)","v":0}]
[null,{"$f":"CONCATENATE(\"Jährl Schuldenabbau ohne Einnahmen\",duree_amortissement,\" ans\")","v":"Jährl Schuldenabbau ohne Einnahmen25 ans"},null,null,{"$f":"IF(montant_dette_initiale=0,0,PMT(taux_interet,duree_amortissement,-montant_dette_initiale))","v":0},null,"Generiterte Erträge über 25 Jahre ",null,null,{"$f":"SUM(M23:M47)","v":18995.202494546404},null,"Nettobarwert 25 Jahre ",null,null,{"$f":"NPV(taux_actualisation,M23:M47)+M22","v":5495.2024945464036}]
[null,"Gestehungskosten über 25 Jahre (Rp/kWh)",null,null,{"$f":"IF(reinvestissement_effet_fiscal=\"oui\",(-H49-J49-K49)/C49*100,(-H49-J49)/C49*100)","v":8.6987127916331453},null,"Gewinn nach 25 Jahren ",null,null,{"$f":"P47","v":5495.2024945463963},null,"Interner Zinssatz 25 Jahre",null,null,{"$f":"IRR(M22:M47)","v":3.0960046022043386E-2}]
[]
[]
[null,"Jahr","Jährliche Produktion (kWh)","Verkaufspreis (CHF/KWh)","Einnahmen aus Stromproduktion ","Steuern aus Einnahmen ","Einsparungen auf Stromrechnung ","Jährliche Kosten ","Netto Einnahmen ","Gelegentlich anfallende Kosten ","Fiskaleffekt ","Zinsen auf Darlehen ","Cashflow","Schuldenabbau ","Restschuld ","Vermögen ","Break-even"]
[null,0,null,null,0,{"$f":"IF(C22*part_electricite_vendue>production_non_imposee,-(C22*part_electricite_vendue-production_non_imposee)*taux_imposition_revenu*D22,0)","v":0},null,0,{"$f":"E22+F22+H22","v":0},{"$f":"-montant_dette_initiale-fond_propre","v":-13500},null,null,{"$f":"-montant_dette_initiale-fond_propre","v":-13500},null,{"$f":"-montant_dette_initiale","v":0},{"$f":"-fond_propre","v":-13500},{"$f":"IF(P22<0,\"neg\",IF(O22<0,\"neg\",\"pos\"))","v":"neg"}]
[null,1,{"$f":"production_annuelle*(1-reduction_annuelle_prod*(B23-1))","v":6600},{"$f":"IF(type_subvention_avancee=\"KEV\",IF(OR(B23>duree_rpc_annee,(B23-1)<temps_attente),tarif_vente_elec_distributeur,tarif_vente_elec),tarif_vente_elec_distributeur)","v":0.06},{"$f":"C23*part_electricite_vendue*D23","v":258},0,{"$f":"-production_annuelle*(1-reduction_annuelle_prod*(B23-1))*tarif_achat_elec_distributeur*(1-part_electricite_vendue)*(1+croissance_prix_elec)^(B23-1)","v":-414},{"$f":"-frais_annuel*cout_total","v":-60},{"$f":"E23+F23+H23-G23","v":612},0,{"$f":"IF((J22+L22)<0,-(J22+L22)*taux_deduction_fiscale,0)","v":2025},{"$f":"IF(O22<0,O22*taux_interet,0)","v":0},{"$f":"IF(reinvestissement_effet_fiscal=\"oui\",K23+I23+L23+J23,I23+L23+J23)","v":2637},{"$f":"IF(O22<0,IF(O22+M23<0,M23,-O22),0)","v":0},{"$f":"IF(O22<0,IF(O22+N23<0,O22+N23,0),0)","v":0},{"$f":"P22+M23-N23","v":-10863},{"$f":"IF(P23<0,\"neg\",IF(O23<0,\"neg\",\"pos\"))","v":"neg"}]
[null,{"$f":"B23+1","v":2},6547.2,0.06,255.93599999999995,0,-420.95519999999993,-60,616.89119999999991,0,{"$f":"IF((J23+L23)<0,-(J23+L23)*taux_deduction_fiscale,0)","v":0},0,616.89119999999991,{"$f":"IF(O23<0,IF(O23+M24<0,M24,-O23),0)","v":0},0,-10246.1088,"neg"]
[null,{"$f":"B24+1","v":3},6494.4,0.06,253.87199999999999,0,-427.99941000000001,-60,621.87140999999997,0,0,0,621.87140999999997,0,0,-9624.2373900000002,"neg"]
[null,4,6441.5999999999995,0.06,251.80799999999994,0,-435.13273349999992,-60,626.94073349999985,0,0,0,626.94073349999985,0,0,-8997.2966565000006,"neg"]
[null,5,6388.8,0.06,249.74399999999997,0,-442.3552235437499,-60,632.09922354374987,0,0,0,632.09922354374987,0,0,-8365.1974329562509,"neg"]
[null,6,6336,0.06,247.67999999999998,0,-449.66688013124991,-60,637.34688013124992,0,0,0,637.34688013124992,0,0,-7727.8505528250007,"neg"]
[null,7,6283.2,0.06,245.61599999999999,0,-457.06764753340997,-60,642.68364753340995,0,0,0,642.68364753340995,0,0,-7085.1669052915904,"neg"]
[null,8,6230.4,0.06,243.55199999999999,0,-464.55741150559618,-60,648.1094115055962,0,0,0,648.1094115055962,0,0,-6437.0574937859947,"neg"]
[null,9,6177.5999999999995,0.06,241.48799999999994,0,-472.13599639668308,-60,653.62399639668297,0,0,0,653.62399639668297,0,0,-5783.4334973893119,"neg"]
[null,10,6124.7999999999993,0.06,239.42399999999995,0,-479.80316215013346,-60,659.22716215013338,0,0,0,659.22716215013338,0,0,-5124.2063352391788,"neg"]
[null,11,6072,0.06,237.35999999999999,0,-487.55860119350854,-60,664.91860119350849,0,0,0,664.91860119350849,0,0,-4459.2877340456707,"neg"]
[null,12,6019.2,0.06,235.29599999999999,0,-495.40193521270839,-60,670.69793521270844,0,0,0,670.69793521270844,0,0,-3788.5897988329625,"neg"]
[null,13,5966.4000000000005,0.06,233.232,0,-503.33271180712234,-60,676.56471180712231,0,0,0,676.56471180712231,0,0,-3112.0250870258401,"neg"]
[null,14,5913.6,0.06,231.16800000000001,0,-511.35040102174912,-60,682.51840102174913,0,0,0,682.51840102174913,0,0,-2429.5066860040911,"neg"]
[null,15,5860.8,0.06,229.10399999999998,0,-519.45439175222759,-60,688.55839175222764,null,0,0,688.55839175222764,0,0,-1740.9482942518634,"neg"]
[null,16,5808,0.06,227.04,0,-527.6439880185917,-60,694.68398801859166,0,0,0,694.68398801859166,0,0,-1046.2643062332718,"neg"]
[null,17,5755.2,0.06,224.976,0,-535.91840510342854,-60,700.89440510342854,0,0,0,700.89440510342854,0,0,-345.36990112984324,"neg"]
[null,18,5702.4,0.06,222.91199999999998,0,-544.27676554999573,-60,707.18876554999565,0,0,0,707.18876554999565,0,0,361.81886442015241,"pos"]
[null,19,5649.5999999999995,0.06,220.84799999999998,0,-552.71809501570169,-60,713.56609501570165,0,0,0,713.56609501570165,0,0,1075.3849594358539,"pos"]
[null,20,5596.8,0.06,218.78399999999999,0,-561.2413179762242,-60,720.02531797622419,0,0,0,720.02531797622419,0,0,1795.4102774120781,"pos"]
[null,21,5544,0.06,216.72,0,-569.8452532753879,-60,726.56525327538793,0,0,0,726.56525327538793,0,0,2521.9755306874658,"pos"]
[null,22,5491.2,0.06,214.65599999999998,0,-578.52860951577475,-60,733.1846095157747,0,0,0,733.1846095157747,0,0,3255.1601402032406,"pos"]
[null,23,5438.4000000000005,0.06,212.59200000000001,0,-587.28998028488388,-60,739.88198028488387,0,0,0,739.88198028488387,0,0,3995.0421204881245,"pos"]
[null,24,5385.6,0.06,210.52799999999999,0,-596.12783921150105,-60,746.65583921150107,0,0,0,746.65583921150107,0,0,4741.6979596996252,"pos"]
[null,25,5332.8,0.06,208.464,0,-605.04053484677104,-60,753.50453484677109,0,0,0,753.50453484677109,0,0,5495.2024945463963,"pos"]
[]
[null,"Total",{"$f":"SUM(C22:C47)","v":149160},null,5830.7999999999993,0,{"$f":"SUM(G22:G47)","v":-12639.402494546399},-1500,16970.202494546396,-13500,2025,0,{"$f":"SUM(M22:M48)","v":5495.2024945463963},{"$f":"SUM(N22:N48)","v":0}]

{"sheet":"Annexe","index":1,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[40,0,40,2]]}
["RPC"]
[null,null,null,"Indice",2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,{"$f":"IF(date_mise_en_service>=E5,1,0)","v":1},1,1,1,1,1,1,1,{"$f":"IF(date_mise_en_service>=M5,1,0)","v":0},0]
[null,null,null,null,{"$f":"IF(date_mise_en_service<E5,1,0)","v":0},0,0,0,0,0,0,0,1,1]
["Catégorie d'installation","Puissance Installée",null,null,"1900-01-01","2010-01-01","2011-01-01","2012-01-01","2012-03-01","2012-10-01","2013-01-01","2014-01-01","2015-04-01","2015-10-01"]
["A","<=10kW","Isolée",{"$f":"CONCATENATE(A6,C6)","v":"AIsolée"},0,0.53300000000000003,0.42699999999999999,0.39300000000000002,0.36499999999999999,0.33100000000000002,0.30499999999999999,0.23799999999999999,0.23400000000000001,0.20399999999999999]
["B","<=30kW","Isolée","BIsolée",0,0.443,0.39300000000000002,0.36199999999999999,0.33700000000000002,0.27,0.248,0.23799999999999999,0.23400000000000001,0.20399999999999999]
["C","<=100kW","Isolée","CIsolée",0,0.41799999999999998,0.34300000000000003,0.316,0.32,0.248,0.22800000000000001,0.19800000000000001,0.18,0.17699999999999999]
["D","<=1000kW","Isolée","DIsolée",0,0.40200000000000002,0.30499999999999999,0.28100000000000003,0.28999999999999998,0.23100000000000001,0.21299999999999999,0.192,0.188,0.17599999999999999]
["E",">1000kW","Isolée","EIsolée",0,0.40200000000000002,0.28899999999999998,0.26600000000000001,0.28100000000000003,0.216,0.19900000000000001,0.17199999999999999,0.185,0.17599999999999999]
["A","<=10kW","Ajoutée","AAjoutée",0,0.61499999999999999,0.48299999999999998,0.44400000000000001,0.39900000000000002,0.36099999999999999,0.33200000000000002,0.26400000000000001,0.23400000000000001,0.20399999999999999]
["B","<=30kW","Ajoutée","BAjoutée",0,0.53300000000000003,0.46700000000000003,0.43,0.36799999999999999,0.29399999999999998,0.27,0.26400000000000001,0.23400000000000001,0.20399999999999999]
["C","<=100kW","Ajoutée","CAjoutée",0,0.50800000000000001,0.42199999999999999,0.38800000000000001,0.34899999999999998,0.26900000000000002,0.247,0.22,0.185,0.17699999999999999]
["D","<=1000kW","Ajoutée","DAjoutée",0,0.49199999999999999,0.378,0.34799999999999998,0.317,0.251,0.23100000000000001,0.21299999999999999,0.188,0.17599999999999999]
["E",">1000kW","Ajoutée","EAjoutée",0,0.49199999999999999,0.36099999999999999,0.33200000000000002,0.307,0.23499999999999999,0.216,0.191,0.185,0.17599999999999999]
["A","<=10kW","Intégrée","AIntégrée",0,0.73799999999999999,0.59199999999999997,0.54500000000000004,0.48799999999999999,0.42799999999999999,0.39400000000000002,0.30399999999999999,0.27400000000000002,0.24]
["B","<=30kW","Intégrée","BIntégrée",0,0.60699999999999998,0.54200000000000004,0.499,0.439,0.36499999999999999,0.33600000000000002,0.30399999999999999,0.27400000000000002,0.24]
["C","<=100kW","Intégrée","CIntégrée",0,0.54900000000000004,0.45200000000000001,0.42199999999999999,0.39100000000000001,0.33200000000000002,0.30499999999999999,0.253,0.21099999999999999,0.20100000000000001]
["D","<=1000kW","Intégrée","DIntégrée",0,0.50800000000000001,0.41499999999999998,0.38200000000000001,0.34899999999999998,0.315,0.28999999999999998,0.21299999999999999,0.188,0.17599999999999999]
["E",">1000kW","Intégrée","EIntégrée",0,0.50800000000000001,0.39100000000000001,0.36,0.33400000000000002,0.28899999999999998,0.26600000000000001,0.191,0.185,0.17599999999999999]
[]
["Coûts d'investissements [CHF/kW]"]
[null,"Puissance Installée",null,null,{"$f":"E5","v":"1900-01-01"},{"$f":"F5","v":"2010-01-01"},{"$f":"G5","v":"2011-01-01"},"2012-01-01","2012-03-01","2012-10-01","2013-01-01","2014-01-01","2015-04-01","2015-10-01"]
["A","<=10kW","Isolée",{"$f":"CONCATENATE(A24,C24)","v":"AIsolée"},0,null,5391,4083,3632,{"$f":"I24-(1-L24/I24)/3*I24","v":3426.3333333333335},{"$f":"I24-(1-L24/I24)*2/3*I24","v":3220.666666666667},3015]
["B","<=30kW","Isolée","BIsolée",0,null,4806,3711,3089,{"$f":"I25-(1-L25/I25)/3*I25","v":2824.3333333333335},{"$f":"I25-(1-L25/I25)*2/3*I25","v":2559.6666666666665},2295]
["C","<=100kW","Isolée","CIsolée",0,null,4450,3478,2687,2451.3333333333335,2215.666666666667,1980]
["D","<=1000kW","Isolée","DIsolée",0,null,4183,3219,2464,2249.6666666666665,2035.3333333333333,1821]
["E",">1000kW","Isolée","EIsolée",0,null,4094,3154,2372,2156,1940,1724]
["A","<=10kW","Ajoutée","AAjoutée",0,null,5531,4537,4036,3807.3333333333335,3578.666666666667,3350]
["B","<=30kW","Ajoutée","BAjoutée",0,null,5026,4123,3432,3138,2844,2550,1850]
["C","<=100kW","Ajoutée","CAjoutée",0,null,4710,3864,2986,2724,2462,2200,1700]
["D","<=1000kW","Ajoutée","DAjoutée",0,null,4361,3577,2738,2499.6666666666665,2261.3333333333335,2023,1650]
["E",">1000kW","Ajoutée","EAjoutée",0,null,4272,3504,2635,2395.3333333333335,2155.666666666667,1916,1650]
["A","<=10kW","Intégrée","AIntégrée",0,null,6989,5733,4929,4570.333333333333,4211.6666666666661,3853]
["B","<=30kW","Intégrée","BIntégrée",0,null,6184,5073,4363,3886.3333333333335,3409.666666666667,2933]
["C","<=100kW","Intégrée","CIntégrée",0,null,5409,4437,3854,3412.6666666666665,2971.333333333333,2530]
["D","<=1000kW","Intégrée","DIntégrée",0,null,4881,4004,3592,3170,2748,2326]
["E",">1000kW","Intégrée","EIntégrée",0,null,4717,3869,3395,2997.6666666666665,2600.3333333333335,2203]
[]
[]
["RPC",null,null,{"$f":"CONCATENATE(\"Taux de rétribution installation \",B42)","v":"Taux de rétribution installation Ajoutée"}]
["Type installation",{"$f":"type_installation","v":"Ajoutée"},null,"Décalage",{"$f":"SUM(E3:BZ3)+1","v":9}]
["Mise en service",{"$f":"date_mise_en_service","v":"2014-06-01"},null,"A",{"$f":"VLOOKUP(CONCATENATE(D43,$B$42),$D$6:$BZ$20,$E$42,0)","v":0.26400000000000001}]
["Cat. Puissance",{"$f":"'Erweiterte Version'!E7","v":"A"},null,"B",{"$f":"VLOOKUP(CONCATENATE(D44,$B$42),$D$6:$BZ$20,$E$42,0)","v":0.26400000000000001}]
[null,null,null,"C",{"$f":"VLOOKUP(CONCATENATE(D45,$B$42),$D$6:$BZ$20,$E$42,0)","v":0.22}]
["Prix de vente RPC",{"$f":"IF(B44=\"A\",E43,IF(B44=\"B\",(10*E43+(B43-10)*E44)/B43,IF(B44=\"C\",(10*E43+20*E44+(B43-30)*E45)/B43,IF(B44=\"D\",(10*E43+20*E44+70*E45+(B43-100)*E46)/B43,IF(B44=\"E\",(10*E43+20*E44+70*E45+900*E46+(B43-1000)*E47)/B43,0)))))","v":0.26400000000000001},"[CHF]","D",{"$f":"VLOOKUP(CONCATENATE(D46,$B$42),$D$6:$BZ$20,$E$42,0)","v":0.21299999999999999}]
["Cout investiss. ",{"$f":"IF(B44=0,VLOOKUP(CONCATENATE(\"A\",$B$42),$D$24:$BZ$38,$E$42,0),VLOOKUP(CONCATENATE(B44,$B$42),$D$24:$BZ$38,$E$42,0))","v":3350},"[CHF/kW]","E",{"$f":"VLOOKUP(CONCATENATE(D47,$B$42),$D$6:$BZ$20,$E$42,0)","v":0.191}]
[]
[]
["Rétribution Unique"]
[null,null,null,"Base [CHF]"]
[null,null,null,null,{"$f":"E$5","v":"1900-01-01"},{"$f":"F$5","v":"2010-01-01"},"2011-01-01","2012-01-01","2012-03-01","2012-10-01","2013-01-01","2014-01-01","2015-04-01","2015-10-01"]
[null,null,null,"Isolée",0,2450,1900,1600,1600,1600,1500,1400,1400,1400]
[null,null,null,"Ajoutée",0,2450,1900,1600,1600,1600,1500,1400,1400,1400]
[null,null,null,"Intégrée",0,3300,2650,2200,2200,2200,2000,1800,1800,1800]
[]
[null,null,null,"Puissance [CHF/kW]"]
[null,null,null,null,{"$f":"E$5","v":"1900-01-01"},{"$f":"F$5","v":"2010-01-01"},"2011-01-01","2012-01-01","2012-03-01","2012-10-01","2013-01-01","2014-01-01","2015-04-01","2015-10-01"]
[null,null,null,"Isolée",0,1850,1450,1200,1200,1200,1000,850,680,500]
[null,null,null,"Ajoutée",0,1850,1450,1200,1200,1200,1000,850,680,500]
[null,null,null,"Intégrée",0,2100,1700,1400,1400,1400,1200,1050,830,610]
[]
[]
["RU"]
["Type installation",{"$f":"type_installation","v":"Ajoutée"}]
["Mise en service",{"$f":"date_mise_en_service","v":"2014-06-01"}]
[]
["Base",{"$f":"VLOOKUP(B65,$D$53:$BZ$55,E42,0)","v":1400}]
["Puissance",{"$f":"VLOOKUP(B65,$D$59:$BZ$61,E42,0)","v":850}]

{"sheet":"Eligibilité","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,0,13,0],[7,2,7,7]]}
[]
[]
[]
[]
[]
[]
[null,null,"Annonce"]
[null,null,"Catégorie puissance"]
[null,null,"<=2KW","<=10kW","<=30kW","<=100kW","<=1000kW",">1000kW"]
[null,null,0,"A","B","C","D","E"]
["Date annonce",2011,"KEV","KEV ODER EIV","KEV ODER EIV","KEV","KEV","KEV"]
[null,2012,"KEV","KEV ODER EIV","KEV ODER EIV","KEV","KEV","KEV"]
[null,2013,"-","EIV","KEV ODER EIV","KEV","KEV","KEV"]
[null,2014,"-","EIV","KEV ODER EIV","KEV","KEV","KEV"]
[null,2015,"-","EIV","KEV ODER EIV","KEV","KEV","KEV"]
[]
[null,"Année annonce",{"$f":"annee_annonce","v":2014},{"$f":"MATCH(C17,B11:B14)+1","v":5}]
[null,"Catégorie",{"$f":"categorie_puissance","v":"A"},{"$f":"MATCH(C18,C10:G10)+1","v":3}]
[null,"Choix",{"$f":"INDEX(B10:G14,D17,D18)","v":"EIV"}]

{"sheet":"Exemple","index":3,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[null,"A supprimer"]
[]
[null,"Données Techniques",null,null,null,null,"Données Financières",null,null,null,null,"Fiscalité",null,null,null,null,"Achat/Vente electricité"]
[null,"m2 de panneaux solaires",null,null,40,null,"Cout tôtal de l'installation (CHF)",null,null,20000,null,"Taux marginal déduction fiscale",null,null,0.15,null,"Autoconsommation (kWh/an)",null,null,2300]
[null,"Type d'installation",null,null,"Ajoutée",null,"Subvention communale (CHF)",null,null,0,null,"Effet fiscal considéré",null,null,"non",null,"Part de l'électricité produite vendue",null,null,{"$f":"1-T4/E11","v":0.65151515151515149}]
[null,"Puissance installée (kWp)",null,null,6,null,"Investissement initial résultant (CHF)",null,null,{"$f":"J4-J5-O13","v":20000},null,"Taux marginal d'imposition du revenu",null,null,0.2,null,"Tarif de vente électricité RPC (Fr./kWh)",null,null,{"$f":"rpc_version_avancee","v":0.26400000000000001}]
[null,"Puissance max par m2 (Wp)",null,null,{"$f":"E6/E4*1000","v":150},null,"Fonds propres",null,{"$f":"J6*J7","v":20000},1,null,"Volume production non imposé (kWh)",null,null,10000,null,"Tarif vente électricité au distributeur (Fr./kWh)",null,null,0.06]
[null,"Catégorie de puissance",null,null,null,null,"Dette",null,{"$f":"J6-I7","v":0},{"$f":"1-J7","v":0},null,"Type d'aide financière",null,null,null,null,"Tarif achat électricité au distributeur (Fr./kWh)",null,null,0.18]
[null,"Production spécifique (kWh/kWp)",null,null,1100,null,"Taux d'intérêt de la dette",null,null,2.75E-2,null,null,null,null,null,null,"Croissance annuelle prix électicité",null,null,2.5000000000000001E-2]
[null,"Réduction annuelle de production",null,null,8.0000000000000002E-3,null,"Coût spécifique installation (CHF/kWp)",null,null,{"$f":"J4/E6","v":3333.3333333333335},null,"Choisir le type d'aide financière ",null,null,"RU",null,"Prix électricité moyen 25 ans (achat)",null,null,{"$f":"T8*(1-(1+T9)^26)/(1-(1+T9))/26","v":0.24931182483144282}]
[null,"Production annuelle initiale (kWh/an)",null,null,{"$f":"E9*E6","v":6600},null,"Durée d'amortissement (années)",null,null,25,null,"Année d'annonce",null,null,2014,null,"Prix électricité après 25 ans (Fr./kWh) (achat)",null,null,{"$f":"T8*(1+T9)^(25-1)","v":0.32557067092486597}]
[null,null,null,null,null,null,"Frais annuels (assurance, etc.)",null,null,3.0000000000000001E-3,null,"Date de mise en service",null,null,"2014-06-01",null,"Temps d'attente avant RPC (années)",null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,"Subvention initiale RU (CHF)",null,null,{"$f":"IF(type_subvention_avancee=\"RU\",ru_base+ru_puissance*puissance_installee,0)","v":0},{"$f":"subvention_init_avancee/cout_total","v":0.32500000000000001},"Durée max RPC (nombre d'années)",null,null,{"$f":"IF(O12>DATE(2014,1,1),20,25)","v":20}]
[]
[]
[]
[null,"Données Techniques",null,null,null,null,"Données Financières",null,null,null,null,"Fiscalité",null,null,null,null,"Achat/Vente electricité"]
[null,"m2 de panneaux solaires",null,null,130,null,"Cout tôtal de l'installation (CHF)",null,null,51000,null,"Taux marginal déduction fiscale",null,null,0.15,null,"Autoconsommation (kWh/an)",null,null,6000]
[null,"Type d'installation",null,null,"Ajoutée",null,"Subvention communale (CHF)",null,null,0,null,"Effet fiscal considéré",null,null,"non",null,"Part de l'électricité produite vendue",null,null,{"$f":"1-T18/E25","v":0.72727272727272729}]
[null,"Puissance installée (kWp)",null,null,20,null,"Investissement initial résultant (CHF)",null,null,{"$f":"J18-J19-O27","v":51000},null,"Taux marginal d'imposition du revenu",null,null,0.2,null,"Tarif de vente électricité RPC (Fr./kWh)",null,null,{"$f":"rpc_version_avancee","v":0.26400000000000001}]
[null,"Puissance max par m2 (Wp)",null,null,{"$f":"E20/E18*1000","v":153.84615384615387},null,"Fonds propres",null,{"$f":"J20*J21","v":51000},1,null,"Volume production non imposé (kWh)",null,null,10000,null,"Tarif vente électricité au distributeur (Fr./kWh)",null,null,0.06]
[null,"Catégorie de puissance",null,null,null,null,"Dette",null,{"$f":"J20-I21","v":0},{"$f":"1-J21","v":0},null,"Type d'aide financière",null,null,null,null,"Tarif achat électricité au distributeur (Fr./kWh)",null,null,0.18]
[null,"Production spécifique (kWh/kWp)",null,null,1100,null,"Taux d'intérêt de la dette",null,null,2.75E-2,null,"Aide financière disponible",null,null,{"$f":"mode_subvention_dispo","v":"EIV"},null,"Croissance annuelle prix électicité",null,null,2.5000000000000001E-2]
[null,"Réduction annuelle de production",null,null,8.0000000000000002E-3,null,"Coût spécifique installation (CHF/kWp)",null,null,{"$f":"J18/E20","v":2550},null,"Choisir le type d'aide financière ",null,null,"RU",null,"Prix électricité moyen 25 ans (achat)",null,null,{"$f":"T22*(1-(1+T23)^26)/(1-(1+T23))/26","v":0.24931182483144282}]
[null,"Production annuelle initiale (kWh/an)",null,null,{"$f":"E23*E20","v":22000},null,"Durée d'amortissement (années)",null,null,25,null,"Année d'annonce",null,null,2014,null,"Prix électricité après 25 ans (Fr./kWh) (achat)",null,null,{"$f":"T22*(1+T23)^(25-1)","v":0.32557067092486597}]
[null,null,null,null,null,null,"Frais annuels (assurance, etc.)",null,null,3.0000000000000001E-3,null,"Date de mise en service",null,null,"2014-06-01",null,"Temps d'attente avant RPC (années)",null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,"Subvention initiale RU (CHF)",null,null,{"$f":"IF(type_subvention_avancee=\"RU\",ru_base+ru_puissance*puissance_installee,0)","v":0},{"$f":"subvention_init_avancee/cout_total","v":0.32500000000000001},"Durée max RPC (nombre d'années)",null,null,{"$f":"IF(O26>DATE(2014,1,1),20,25)","v":20}]
[]
[]
[]
[null,"Données Techniques",null,null,null,null,"Données Financières",null,null,null,null,"Fiscalité",null,null,null,null,"Achat/Vente electricité"]
[null,"m2 de panneaux solaires",null,null,320,null,"Cout tôtal de l'installation (CHF)",null,null,120000,null,"Taux marginal déduction fiscale",null,null,0.15,null,"Autoconsommation (kWh/an)",null,null,15000]
[null,"Type d'installation",null,null,"Ajoutée",null,"Subvention communale (CHF)",null,null,0,null,"Effet fiscal considéré",null,null,"non",null,"Part de l'électricité produite vendue",null,null,{"$f":"1-T32/E39","v":0.72727272727272729}]
[null,"Puissance installée (kWp)",null,null,50,null,"Investissement initial résultant (CHF)",null,null,{"$f":"J32-J33-O41","v":120000},null,"Taux marginal d'imposition du revenu",null,null,0.2,null,"Tarif de vente électricité RPC (Fr./kWh)",null,null,{"$f":"rpc_version_avancee","v":0.26400000000000001}]
[null,"Puissance max par m2 (Wp)",null,null,{"$f":"E34/E32*1000","v":156.25},null,"Fonds propres",null,{"$f":"J34*J35","v":36000},0.3,null,"Volume production non imposé (kWh)",null,null,10000,null,"Tarif vente électricité au distributeur (Fr./kWh)",null,null,0.06]
[null,"Catégorie de puissance",null,null,null,null,"Dette",null,{"$f":"J34-I35","v":84000},{"$f":"1-J35","v":0.7},null,"Type d'aide financière",null,null,null,null,"Tarif achat électricité au distributeur (Fr./kWh)",null,null,0.18]
[null,"Production spécifique (kWh/kWp)",null,null,1100,null,"Taux d'intérêt de la dette",null,null,2.75E-2,null,"Aide financière disponible",null,null,{"$f":"mode_subvention_dispo","v":"EIV"},null,"Croissance annuelle prix électicité",null,null,2.5000000000000001E-2]
[null,"Réduction annuelle de production",null,null,8.0000000000000002E-3,null,"Coût spécifique installation (CHF/kWp)",null,null,{"$f":"J32/E34","v":2400},null,"Choisir le type d'aide financière ",null,null,"RPC",null,"Prix électricité moyen 25 ans (achat)",null,null,{"$f":"T36*(1-(1+T37)^26)/(1-(1+T37))/26","v":0.24931182483144282}]
[null,"Production annuelle initiale (kWh/an)",null,null,{"$f":"E37*E34","v":55000},null,"Durée d'amortissement (années)",null,null,25,null,"Année d'annonce",null,null,2014,null,"Prix électricité après 25 ans (Fr./kWh) (achat)",null,null,{"$f":"T36*(1+T37)^(25-1)","v":0.32557067092486597}]
[null,null,null,null,null,null,"Frais annuels (assurance, etc.)",null,null,3.0000000000000001E-3,null,"Date de mise en service",null,null,"2014-06-01",null,"Temps d'attente avant RPC (années)",null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,"Subvention initiale RU (CHF)",null,null,{"$f":"IF(type_subvention_avancee=\"RU\",ru_base+ru_puissance*puissance_installee,0)","v":0},{"$f":"subvention_init_avancee/cout_total","v":0.32500000000000001},"Durée max RPC (nombre d'années)",null,null,{"$f":"IF(O40>DATE(2014,1,1),20,25)","v":20}]