{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Home","About","Content","Description","Investment volume","Externalities - Implementation","Operating results","Externalities - Operation","Indirect Externalities","Result table","Result chart","List of abbr. and definitions","Sources","Imprint | Disclaimer","Appendix - Input data","VBA"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":101,"comments":0,"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":"Home","index":0,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DUAL Ports - Developing Low carbon Utilities, Abilities and potential of regional entrepreneurial Ports"]
[null,"Developing low carbon port potential: Cost benefit & carbon footprint analyses "]
[]
[null,"Please fill in all red cells!"]
[]
[null,"Version 3.5"]
[null,{"$f":"DATE(2018,10,16)","v":"2018-10-16"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hamburg Institute of International Economics (HWWI) | 2018"]
[]
[null,"DUAL Ports is co-funded by the North Sea Region Programme 2014-2020 (Priority Eco-innovation priority | J-No: 38-2-7-15)"]
[null,"www.northsearegion.eu/dual-ports"]

{"sheet":"About","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,11,6,12],[7,11,7,12],[8,11,8,12],[6,1,9,10]]}
["Home ⌂"]
[null,"About"]
[]
[null,"Developing low carbon port potential: "]
[null,"Cost benefit & carbon footprint analyses "]
[]
[null,"A cost-benefit analysis - CBA - is tool used to evaluate an investment decision in order to assess the welfare change attributable to it. It gives further information to the relevance of the contribution to EU cohesion policy objectives. The overall purpose of CBA is to facilitate a more efficient allocation of resources. A CBA demonstrates further the convenience for society of a particular (political) intervention (EC 2014, 15).\n\nThis CBA tool focuses to calculate the carbon footprint of investment projects. \n\nThe instrument shall be:\n- simple and transparent;\n- capable of being integrated into  and transfered to other projects; and\n- comply with existent and upcoming standards.\n\nFurther requirements of this CBA-tool is to have a self-explanatory character with a simple and understanding design.\n\nUsual problems with CBA tools are:\n- the overreliance on data from past projects;\n- the use of subjective impressions in assessment;\n- inappropriate use of heuristics to derive money cost of the intangible elements; and\n- confirmation bias among project supporters.\n\nThe cost benefit and carbon footprint tool measures if the project's aim of 20% operation cost reduction, of 20% total cost reduction, and 10% emission reduction is fullfilled. In result, it further differentiate between the project realized performance (do-someting scenario) and the project target (reference scenario)."]

{"sheet":"Content","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Home ⌂"]
[null,"Content"]
[null,null,"Description","INPUT sheet"]
[null,"Home"]
[null,"About"]
[null,"Description","Short investment description.","Yes"]
[null,"Investment volume","Quantification of the investment costs and financing structure.","Yes"]
[null,"Externalities - Implementation","Quantification of energy and resource consumption and structure.","Yes"]
[null,"Operating results","Quantification of operating costs and revenues of the project.","Yes"]
[null,"Externalities - Operation","Environmental Impacts.","Yes"]
[null,"Indirect Externalities","Energy consumption","Yes"]
[null,"Result table","The main results of the calculation summerized in a table."]
[null,"Result chart","The main results of the calculation summerized in several charts."]
[null,"List of abbreviation and definitions","In the list of abbreviation and definitions useful hints relevant for the input data can be found."]
[null,"Sources","Used sources."]
[null,"Imprint and Disclaimer","Contact, imprint, and disclaimer"]
[null,"Appendix Input Data","Further input data needed for the calculation of the cost/benefit analysis. "]

{"sheet":"Description","index":3,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":false,"merged":[[28,1,36,2],[39,1,47,2],[7,2,8,2],[13,1,13,2]]}
["Home ⌂"]
["Content &","Project- INPUT"]
[]
[null,"Project information",{"$f":"IF(C5<>\"\",\"\",\"<< PLEASE, FILL IN >>\")","v":"<< PLEASE, FILL IN >>"}]
[null,"Beneficiary"]
[null,"Project name"]
[null,"Project country                      (please select from dropdown-list)","Belgium"]
[null,"Year of reporting",2017]
[null,"Click for further information"]
[]
[null,"General information",{"$f":"IF(C12<>\"\",\"\",\"<< PLEASE, FILL IN >>\")","v":"<< PLEASE, FILL IN >>"}]
[null,"Year of establishment"]
[null,"Type of port:                                (please select from dropdown-list)","Private Service Port (if Infrastructure (private); suprastructure (private); workers (private))"]
[null,"Information on your activities and services (please select):"]
[null,"Provided directly","Sub contracted"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Short description of the green investment",{"$f":"IF(B29<>\"\",\"\",\"<< PLEASE, FILL IN >>\")","v":"<< PLEASE, FILL IN >>"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(B40<>\"\",\"\",\"<< PLEASE, FILL IN >>\")","v":"<< PLEASE, FILL IN >>"}]
[null,"Short description of the economic and environmental benefits of the green investment (e.g. expected CO2e reduction) in short and long term"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Are you a "]
[null,"Public Service Port (if infrastructure (public); suprastructure; workers (public))"]
[null,"Tool Port (if Infrastructure (public); suprastructure (public); workers (private))"]
[null,"Landlord Port (if Infrastructure (public); suprastructure (private); workers (private))"]
[null,"Private Service Port (if Infrastructure (private); suprastructure (private); workers (private))"]
[null,"none of these / others"]

{"sheet":"Investment volume","index":4,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,3,18,4],[15,1,15,2]]}
["Home ⌂"]
["Content &","Investment volume - INPUT"]
[null,"This is only assigned to the project itself. If your project does not include investments. Only affects operating costs/revenues, skip this sheet."]
[]
[null,"Financial investment volume","Short description","Conventional investment\n(Click for further information)","Green investment\n(Click for further information)"]
[null,"Total investment costs - in Euro","Amount of financial resources needed to implement the project (over the whole implementation period)",0,0]
[null,"Scrap value after operation - in Euro\n(Click for further information)","Scrap value after the appraisal period/operation period. The operation period has to be entered on the sheet \"Operating results\".",0,0]
[]
[null,"Sources of finance\n(Click for further information)",null,"Conventional investment","Green investment"]
[]
[null,"EU co-financing  - in %",null,0,0]
[null,"Norwegian co-financing - in %",null,0,0]
[null,"Further public contribution - in %",null,0,0]
[null,"Loans - in %",null,1,1]
[null,"Equity - in %",null,0,0]
[null,null,null,{"$f":"IF(SUM(D11:D15)<>1,\"The provided financial information is implausible!\",\"\")","v":""},{"$f":"IF(SUM(E11:E15)<>1,\"The provided financial information is implausible!\",\"\")","v":""}]
[]
[null,"Interest rate on loans"]
[null,"interest rate (per annum) - in %","effective interest rate (p.a.) relevant for the project (no difference between conventional and green investment allowed)",0]

{"sheet":"Externalities - Implementation","index":5,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,2,12,2],[28,2,29,2],[30,2,31,2]]}
["Home ⌂"]
["Content &","Implementation/Construction: Environmental Impacts - INPUT"]
[null,"This sheet only refers to the implementation/construction of the investment, NOT to the operation."]
[]
[null,"Environmental Factors","Short description","Conventional investment","Green investment","Result"]
["A","Energy consumption for implementation\n(Click for further information)","Only energy consumption is relvevant here, not production (for others). "]
[null,"electricity (grid) - in kWh","Does not include consumed electricity from own production. National energymix assumed.",0,0]
[null,"optional: share of green grid electricity - in %","If the share of green (hydro, geothermal, wind, solar) electricity differs from the national mix, this can be entered here.",0,0]
[null,"electricity (own production)"]
[null,"hydropower - in kWh",null,0,0]
[null,"geothermal - in kWh",null,0,0]
[null,"wind - in kWh",null,0,0]
[null,"solar - in kWh",null,0,0]
[null,"fuel consumption"]
[null,"(truck) diesel - in kWh",null,0,0]
[null,"marine diesel - in kWh",null,0,0]
[null,"gasoline - in kWh",null,0,0]
[null,"heating oil - in kWh",null,0,0]
[null,"natural gas - in kWh",null,0,0]
[null,"liquid gas - in kWh",null,0,0]
[null,"lignite - in kWh",null,0,0]
[null,"stone coal (brikets) - in kWh",null,0,0]
[null,"stone coal (koks) - in kWh",null,0,0]
[null,"wood (peaces) - in kWh",null,0,0]
[null,"wood (pellets) - in kWh",null,0,0]
[null,"Total energy consumption for implementation - in kWh","Click for further information",{"$f":"SUM(D15:D25)+SUM(D10:D13)+D7","v":0},{"$f":"SUM(E15:E25)+SUM(E10:E13)+E7","v":0},{"$f":"IF(D26=0,\"\",CONCATENATE(\"Reduction in engery use under green investment in comparison with conventional investment: \",ROUND(-(E26-D26)/D26*100,2),\" %\"))","v":""}]
[null,"thereof energy from (own) renewable sources - in kWh",null,{"$f":"SUM(D10:D13,D24:D25)","v":0},{"$f":"SUM(E10:E13,E24:E25)","v":0},{"$f":"IF(D27=0,\"\",CONCATENATE(\"Increase in energy use from renewable sources under green investment in comparison with conventional investment: \",ROUND((E27-D27)/D27*100,2),\" %\"))","v":""}]
["B","Waste treatment during implementation","Only amounts that remain for final treatment (filling) after possible incineration are relevant."]
[null,"use of waste"]
[null,"as alternative to landfill - in t",null,0,0]
[null,"production of waste"]
[null,"for landfill- in t",null,0,0]
[null,"Total net production of waste - in t",null,{"$f":"D32-D30","v":0},{"$f":"E32-E30","v":0},{"$f":"IF(D33=0,\"\",CONCATENATE(\"Reduction in net waste production under green investment in comparison with conventional investment: \",ROUND(-(E33-D33)/D33*100,2),\" %\"))","v":""}]

{"sheet":"Operating results","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,3,7,3],[6,4,7,4],[8,1,9,1],[8,3,9,3],[8,4,9,4]]}
["Home ⌂"]
["Content &","Operating Revenues and Costs - INPUT"]
[null,"This sheet uses the concept of business units. A business unit is a part of the business providing a certain service for which it makes sense to define indivdual costs and revenues."]
[]
[null,null,"Short description","Conventional investment","Green investment"]
[null,"Appraisal period - in years","The appraisal period is usually the lifetime/operation period of the investment (max. 50 years).",{"$f":"E6","v":0},0]
[null,"Average annual operating revenue of the project-relevant business unit - in Euro","The revenues refer to the smallest business unit which still covers the whole project. The annual average refers to the appraisal period.",0,0]
[]
[null,"Average annual operating cost of the project-relevant business unit - in Euro","Operating costs include all the costs to operate and maintain (O&M) the new or upgraded service. Does not include capital costs.",0,0]
[null,null,"Click for further information"]
[null,"Average annual operating surplus - in Euro",null,{"$f":"D7-D9","v":0},{"$f":"E7-E9","v":0}]

{"sheet":"Externalities - Operation","index":7,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,2,12,2],[13,2,24,2]]}
["Home ⌂"]
["Content &","Operation: Environmental Impacts - INPUT"]
[null,"This refers again to the smallest business unit which still covers the whole project."]
[]
[null,"Environmental Factors","Short description","Conventional investment","Green investment","Result"]
["A","Energy consumption of business unit\n(Click for further information)","Only energy consumption is relvevant here, not production (for others). To be entered as annual averages."]
[null,"electricity (grid) - in kWh","Does not include consumed electricity from own production. National energymix assumed.",0,0]
[null,"share of green grid electricity - in %","automatically equal to the corresponding figure from the sheet \"Exernalities -  Implementation\"",{"$f":"'Externalities - Implementation'!D8","v":0},{"$f":"'Externalities - Implementation'!E8","v":0}]
[null,"electricity (own production)"]
[null,"hydropower - in kWh",null,0,0]
[null,"geothermal - in kWh",null,0,0]
[null,"wind - in kWh",null,0,0]
[null,"solar - in kWh",null,0,0]
[null,"fuel consumption"]
[null,"(truck) diesel - in kWh",null,0,0]
[null,"marine diesel - in kWh",null,0,0]
[null,"gasoline - in kWh",null,0,0]
[null,"heating oil - in kWh",null,0,0]
[null,"natural gas - in kWh",null,0,0]
[null,"liquid gas - in kWh",null,0,0]
[null,"lignite - in kWh",null,0,0]
[null,"stone coal (brikets) - in kWh",null,0,0]
[null,"stone coal (koks) - in kWh",null,0,0]
[null,"wood (peaces) - in kWh",null,0,0]
[null,"wood (pellets) - in kWh",null,0,0]
[null,"Total average annual energy consumption - in kWh","Click for further information",{"$f":"SUM(D15:D25)+SUM(D10:D13)+D7","v":0},{"$f":"SUM(E15:E25)+SUM(E10:E13)+E7","v":0},{"$f":"IF(D26=0,\"\",CONCATENATE(\"Reduction in engery use under green investment in comparison with conventional investment: \",ROUND(-(E26-D26)/D26*100,2),\" %\"))","v":""}]
[null,"thereof energy from (own) renewable sources - in kWh",null,{"$f":"SUM(D10:D13,D24:D25)","v":0},{"$f":"SUM(E10:E13,E24:E25)","v":0},{"$f":"IF(D27=0,\"\",CONCATENATE(\"Increase in energy use from renewable sources under green investment in comparison with conventional investment: \",ROUND((E27-D27)/D27*100,2),\" %\"))","v":""}]
["B","Waste treatment of business unit","Only amounts that remain for final treatment (filling) after possible incineration are relevant. Annual averages over appraisal period."]
[null,"use of waste"]
[null,"as alternative to landfill - in t",null,0,0]
[null,"production of waste"]
[null,"for landfill- in t",null,0,0]
[null,"Average annual net production of waste - in t",null,{"$f":"D32-D30","v":0},{"$f":"E32-E31","v":0},{"$f":"IF(D33=0,\"\",CONCATENATE(\"Reduction in net waste production under green investment in comparison with conventional investment: \",ROUND(-(E33-D33)/D33*100,2),\" %\"))","v":""}]

{"sheet":"Indirect Externalities","index":8,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Home ⌂"]
["Content &","Indirect Environmental Impacts - INPUT"]
[]
[]
[null,"Environmental Factors","Short description","Conventional investment","Green investment","Result"]
[null,"Customers: Energy consumption\n","Consumption of all relevant customers. Annual average over the appraisal period."]
[null,"fuel consumption"]
[null,"(truck) diesel - in kWh",null,0,0]
[null,"marine diesel - in kWh",null,0,0]
[null,"gasoline - in kWh",null,0,0]
[null,"heating oil - in kWh",null,0,0]
[null,"natural gas - in kWh",null,0,0]
[null,"liquid gas - in kWh",null,0,0]
[null,"lignite - in kWh",null,0,0]
[null,"stone coal (brikets) - in kWh",null,0,0]
[null,"stone coal (koks) - in kWh",null,0,0]
[null,"wood (peaces) - in kWh",null,0,0]
[null,"wood (pellets) - in kWh",null,0,0]
[null,"Sum of indirect annual energy consumption - in kWh","Click for further information",{"$f":"SUM(D8:D18)","v":0},{"$f":"SUM(E8:E18)","v":0}]

{"sheet":"Result table","index":9,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,1,4,2],[10,1,10,2],[11,1,11,2],[14,1,14,2],[12,1,12,2],[13,1,13,2]]}
["Home ⌂"]
["Content &","Result table"]
[]
[null,"CBA overview",null,"Conventional investment","Green investment"]
[null,"present value of financial inflows\n(Click for further information)",null,{"$f":"SUM('Appendix - Input data'!C159:BD159,'Appendix - Input data'!C162:BD162)","v":0},{"$f":"SUM('Appendix - Input data'!C172:BD172,'Appendix - Input data'!C175:BD175)","v":0}]
[null,"present value of financial outflows",null,{"$f":"SUM('Appendix - Input data'!C160:BD160,'Appendix - Input data'!C163:BD163)","v":0},{"$f":"SUM('Appendix - Input data'!C173:BD173,'Appendix - Input data'!C176:BD176)","v":0}]
[null,"net present value (private)",null,{"$f":"D5-D6","v":0},{"$f":"E5-E6","v":0}]
[null,"present value of evnironmental costs",null,{"$f":"SUM('Appendix - Input data'!C164:BE167)","v":0},{"$f":"SUM('Appendix - Input data'!C177:BE180)","v":0}]
[]
[null,"Benefit Cost Ratios and targets",null,"Conventional investment","Green investment","Result"]
[null,"Benefit Cost Ratio\n(Click for further information)",null,{"$f":"IF(D6<>0,D5/D6,0)","v":0},{"$f":"IF(E6<>0,E5/E6,0)","v":0},{"$f":"IF(E11>=1,CONCATENATE(\"With a BCR equal to \",ROUND(E11,2),\", the green investment is expected to be beneficial.\"),CONCATENATE(\"With a BCR equal to \",ROUND(E11,2),\", the benefits do not exceed the costs.\"))","v":"With a BCR equal to 0, the benefits do not exceed the costs."}]
[null,"Social Benefit-Cost Ratio \n(Click for further information)",null,{"$f":"IF(D6<>0,D5/(D6+D8),0)","v":0},{"$f":"IF(E6<>0,E5/(E6+E8),0)","v":0},{"$f":"IF(E12>=1,CONCATENATE(\"With a Social BCR equal to \",ROUND(E12,2),\", the green investment is expected to be beneficial.\"),CONCATENATE(\"With a Social BCR equal to \",ROUND(E12,2),\", the benefits do not exceed the costs.\"))","v":"With a Social BCR equal to 0, the benefits do not exceed the costs."}]
[null,"Target 1a: 20% operating cost reduction (€/a)",null,{"$f":"IF('Operating results'!D6>0,'Operating results'!D9,0)","v":0},{"$f":"IF('Operating results'!E6>0,'Operating results'!E9,0)","v":0},{"$f":"IF(D13<>0,IF(E13/D13<=0.8,CONCATENATE(\"Target is fulfilled (\",100*ROUND(1-E13/D13,2),\" %)\"),CONCATENATE(\"Target is not fulfilled (\",100*ROUND(1-E13/D13,2),\" %)\")),\"Target is not fulfilled\")","v":"Target is not fulfilled"}]
[null,"Target 1b: 20% total cost reduction (€)",null,{"$f":"D6","v":0},{"$f":"E6","v":0},{"$f":"IF(D14<>0,IF(E14/D14<=0.8,CONCATENATE(\"Target is fulfilled (\",100*ROUND(1-E14/D14,2),\" %)\"),CONCATENATE(\"Target is not fulfilled (\",100*ROUND(1-E14/D14,2),\" %)\")),\"Target is not fulfilled\")","v":"Target is not fulfilled"}]
[null,"Target 2: 10% carbon emission reduction (t CO2e)",null,{"$f":"'Operating results'!D6*('Appendix - Input data'!D58+'Appendix - Input data'!E85)+'Appendix - Input data'!H58+'Appendix - Input data'!E88","v":0},{"$f":"'Operating results'!E6*('Appendix - Input data'!E58+'Appendix - Input data'!E86)+'Appendix - Input data'!H77+'Appendix - Input data'!E89","v":0},{"$f":"IF(D15<>0,IF(E15/D15<=0.9,CONCATENATE(\"Target is fulfilled (\",100*ROUND(1-E15/D15,2),\" %)\"),CONCATENATE(\"Target is not fulfilled (\",100*ROUND(1-E15/D15,2),\" %)\")),\"Target is not fulfilled\")","v":"Target is not fulfilled"}]
[]
[null,"Direct environmental impacts",null,"Conventional investment","Green investment"]
[null,"CO2e [t]",null,{"$f":"('Appendix - Input data'!$D$58+'Appendix - Input data'!$E$85)*'Operating results'!D6+'Appendix - Input data'!$E$88+'Appendix - Input data'!$H$58","v":0},{"$f":"('Appendix - Input data'!$D$77+'Appendix - Input data'!$E$86)*'Operating results'!E6+'Appendix - Input data'!$E$89+'Appendix - Input data'!$H$77","v":0}]
[null,"sulphur [kg]",null,{"$f":"('Appendix - Input data'!$E$58*'Operating results'!D6+'Appendix - Input data'!$I$58)/1000","v":0},{"$f":"('Appendix - Input data'!$E$77*'Operating results'!E6+'Appendix - Input data'!$I$77)/1000","v":0}]
[null,"nitrogen [kg]",null,{"$f":"('Appendix - Input data'!$F$58*'Operating results'!D6+'Appendix - Input data'!$J$58)/1000","v":0},{"$f":"('Appendix - Input data'!$F$77*'Operating results'!E6+'Appendix - Input data'!$J$77)/1000","v":0}]
[null,"waste [t]",null,{"$f":"'Externalities - Operation'!D33*'Operating results'!D6+'Externalities - Implementation'!D33","v":0},{"$f":"'Externalities - Operation'!E33*'Operating results'!E6+'Externalities - Implementation'!E33","v":0}]
[]
[null,"Indirect environmental impacts"]
[null,"CO2e [t]",null,{"$f":"'Appendix - Input data'!L58","v":0},{"$f":"'Appendix - Input data'!L77","v":0}]
[null,"sulphur [kg]",null,{"$f":"'Appendix - Input data'!M58/1000","v":0},{"$f":"'Appendix - Input data'!M77/1000","v":0}]
[null,"nitrogen [kg]",null,{"$f":"'Appendix - Input data'!N58/1000","v":0},{"$f":"'Appendix - Input data'!N77/1000","v":0}]

{"sheet":"Result chart","index":10,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Home ⌂"]
["Content &","Result chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"conventional","green","target"]
[null,"operating cost reduction",100,{"$f":"IF('Result table'!D13<>0,'Result table'!E13/'Result table'!D13*100,100)","v":100},80]
[null,"total cost reduction",100,{"$f":"IF('Result table'!D14<>0,'Result table'!E14/'Result table'!D14*100,100)","v":100},80]
[null,"emissions reduction",100,{"$f":"IF('Result table'!D15<>0,'Result table'!E15/'Result table'!D15*100,100)","v":100},90]

{"sheet":"List of abbr. and definitions","index":11,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
["Home ⌂"]
["Content &","List of abbreviation and definitions"]
[]
[null,"Abbrivation",null,"Definition","Source"]
["A",null,"Additional costs of investment","These costs are composed of start-up and planning costs (incl. costs of construction phase, tender off etc.), land costs, buildings costs and damage to properties/compensation payment (inlc. for compensation area)."]
["top ↑",null,"(Annual average) energy consumption","The energy consumption that can be directly attributed to the investment project (e. g. indirect GHG emissions caused by e. g. transportation, heating, electricity). Lower overall consumption might therefore reduce indirect GHG emissions. To quantify the reduction in GHG emissions that is due to a change in the energy mix (e. g. wind instead of diesel) we require detailed information on the sources of energy consumption."]
[null,null,"Annual average GHGe savings that are not already included in category A and B","Values entered here indicate a reduction in GHG emissions that is not attributed to a lower (or greener) energy consumption of the project itself. This includes for example spillovers from the new investment project to other port areas that are not included in A or saving measures of the Green Officer."]
[null,null,"Avoided municipal cleaning costs by using polluted materials","It is seen as a positive social benefit if cleaning costs, that would otherwise accrue to the public (the municipality), are privatised. Cleaning costs are already part of the operating costs. Therefore we explicitly count cleaning costs, that would accrue to the municipality without the project, as internalisation of external effects on the benefit side. "]
["B","BCR","Benefit-cost ratio","A benefit-cost ratio (BCR)/Profitability Index Rate is an indicator, used in the formal discipline of cost-benefit analysis, that attempts to summarize the overall value for money of a project or proposal. A BCR is the ratio of the benefits of a project or proposal, expressed in monetary terms, relative to its costs, also expressed in monetary terms. All benefits and costs should be expressed in discounted present values. The higher the BCR the better the investment. General rule of thumb is that if the benefit is higher than the cost the project is a good investment."]
["top ↑",null,"Benefit-cost ratio including social benefit (Social-Benefit-Cost Ratio)","Same rationale as for the regular benefit-cost-ratio. Additionally social costs are explicitly quantified and their monetary value is included in the calculation. The internalisation of external effects is quantified and included as a benefit.  "]
[null,"BAU","Business-As-Usual (do-nothing)","The objectives of the project remains as it would be with no project (counterfactual scenario). The objective of the project includes costs (and revenues) to operate and maintain the service."]
["C","CO2e","CO2-equivalent"]
["top ↑","CI","Conventional investment","An investment project that would be realised if no green investment was implemented. This could possibly include investments that are needed to ensure the maintenance of the business as usual (see also BAU)."]
[null,"CBA","Cost-Benefit-Analysis"]
["D",null,"Damage of properties","Damage of properties of other "]
["top ↑","do-minimum","Do-minimum scenario","The objectives of the do-minimus scenario remains as it would be with no project (counterfactual scenario). The do-minimum scenario includes necessary improvment work/small adaptation investments."]
[null,"do-something","Do-something scenario","Represents changes to the objectives of the project (concentional/green investment)."]
["E","ECB","European central bank"]
["top ↑","EC","European Commission"]
[null,"EIB","European Investment Bank"]
["F","FDR","Financial Discount Rate","An appropriate Financial Discount Rate (FDR) is adopted in order to calculate the present value of the future cash flows. The financial discount rate reflects the opportunity cost of capital. The practical ways of estimating the reference rate to use for discounting are discussed in Annex I, while the box below reminds the European Commission’s reference parameter suggested for the programming period 2014-2020. According to Article 19 (Discounting of cash flows) of Commission Delegated Regulation (EU) No 480/2014, for the programming period 2014-2020, the European Commission recommends that a 4 % discount rate in real terms is considered as the reference parameter for the real opportunity cost of capital in the long term. Values differing from the 4 % benchmark may, however, be justified on the grounds of international macroeconomic trends and conjunctures, the Member State’s specific macroeconomic conditions and the nature of the investor and/or the sector concerned. To ensure consistency amongst the discount rates used for similar projects in the same country, the Commission encourages the Member States to provide their own benchmark for the financial discount rate in their guidance documents and then to apply it consistently in project appraisal at national level.","European Commission (2014)"]
["top ↑",null,"Financial Net Present Value (cumulative)","The sum of the discounted net cash-flows over the appraisal period. Equal to Present Value of Benefits less Present Value of Costs."]
[null,"FNPV(K)","Financial Net Present Value on capital","The financial net present value of capital, FNPV(K), in this case, is the sum of the net discounted cash flows that accrue to the national beneficiaries (public and private combined) due to the implementation of the project.","European Commission (2014)"]
[null,"FNPV(C)","Financial Net Present Value on investment","The FNPV on investment is defined as the sum that results when the expected investment and operating costs of the project (discounted) are deducted from the discounted value of the expected revenues.","European Commission (2014)"]
[null,"FRR(K)","Financial rate of return on capital (K)"]
[null,"FRR(C)","Financial rate of return on investment (C)","The financial rate of return on investment is defined as the discount rate that produces a zero FNPV.","European Commission (2014)"]
["G","GI","Green investment","An investment project that realised a green investment to avoid social costs (of emissions). "]
["top ↑",null,"Green Officer","The Green Officer pilot is implementing and coordinating the sustainability management of ports and initiating sustainability projects throughout the ports. The pilot will test innovative management solutions, that can help the ports promote greener services and operations.","DUAL Ports (2017)"]
[null,"GHG","Greenhouse gases emissions","Diferent GHG types (e.g. CO2, N2O, CH4, SF6), activities (e.g. combustion for energy, municipal solid waste landfills) and potential sources of emission (e.g. energey related GHG emissions from combusition, process CO2 from flue gas de-sulphurisation)","European Investment Bank (2014)"]
["I",null,"Initial investment","Initial investment: it includes the capital costs of all the fixed assets (e.g. land, constructions buildings, plant and machinery, equipment, etc.) and non‑fixed assets (e.g. start up and technical costs such as design/planning, project management and technical assistance, construction supervision, publicity, etc.). Where appropriate, changes in net working capital should also be included. Information must be taken from the technical feasibility study(ies)34 and the data to consider are the incremental cash disbursements encountered in the single accounting periods (usually years) to acquire the various types of assets (see box). Cost breakdown over the years should be consistent with the physical realisations envisaged and the time‑plan for implementation (see section 2.7.4)35. Where relevant, the initial investment shall also include environmental and/or climate change mitigating costs during the construction, as usually defined in the EIA or in other appraisal procedures.","European Commission (2014)"]
["top ↑",null,"Internalisation of Externalities \n(Avoided social costs)","Since the GHG emission reduction leads to lower social costs we do not include the reduction explicitly as internalisation on the benefit side. This would lead to a double accounting (reduction is a benefit and a cost reduction of the same amount at the same time). However, for the graphical representation, we inlcude the amount of GHG reduction (compared to the CI) and the reduction in wasted materials in this category."]
["L","Productivity","Labor productivity","With regards to labour costs, any assumed increase in real salaries and wages can be partially offset by increases in labour productivity throughout the time horizon.","European Commission (2014)"]
["top ↑",null,"Land usage (consumption)","Consumption' of land cover means: (a) The expansion of built-up area which can be directly measured; (b) the absolute extent of land that is subject to exploitation by agriculture, forestry or other economic activities; and (c) the over-intensive exploitation of land that is used for agriculture and forestry. ","European Environment Agency (1997)"]
[null,null,"Long-term perspective","A long‑term outlook is adopted, ranging from a minimum of 10 to a maximum of 30 years or  more, depending on the sector of intervention.","European Commission (2014)"]
["M","max.","Maximum"]
["top ↑","t","Metric tonne"]
[null,null,"MFI interest rates","MFI interest rate statistics cover all interest rates that monetary financial institutions (MFIs) resident in the euro area – except central banks and money market funds – apply to euro-denominated deposits from and loans to households and non-financial corporations resident in the euro area countries.","European Central Bank (2017)."]
[null,null,"Microeconomic approach","CBA is typically a microeconomic approach enabling the assessment of the project’s impact on society as a whole via the calculation of economic performance indicators, thereby providing an assessment of expected welfare changes.","European Commission (2014)"]
[null,"min.","Minimum"]
["O",null,"Operating costs","Operating costs include all the costs to operate and maintain (O&M) the new or upgraded service. Cost forecasts can be based on historic unit costs, when patterns of expenditures on operations and maintenance ensured adequate quality standards. Although the actual composition is project‑specific, typical O&M costs include: labour costs for the employer; materials needed for maintenance and repair of assets; consumption of raw materials, fuel, energy, and other process consumables; services purchased from third parties, rent of buildings or sheds, rental of machinery; general management and administration; insurance cost; quality control; waste disposal costs; and emission charges (including. environmental taxes, if applicable).","European Commission (2014)"]
["top ↑",null,"Opportunity costs","The opportunity cost of a good or service is defined as the potential gain from the best alternative forgone, when a choice needs to be made between several mutually exclusive alternatives.","European Commission (2014)"]
["P",null,"Personnel costs","Personnel costs (average)"]
["top ↑",null,"Present value of financial inflows","The sum of the discounted financial inflows over the appraisal period."]
[null,null,"Private equity\n(source of financing)","Use  of own equity to finance the project. It is not counted as inflow and needs not to be payed back nor payed interest on. In a financing calculation one would need to compute opportunity costs of using own equity but this is not included in this tool. "]
[null,null,"Private/public contribution\n(Source of financing)","The part of the investment that is not covered by European Union assistance/co-financing or Norwegian co-financing. It can be divided in the parts own equity, private equity and public contribution. "]
[null,"P","Probabiltiy ","Probabiltiy or likelihood of occurence"]
[null,null,"Public contribution","Sources of financing like grants that do not need to be payed back nor payed interest on, from financiers other than the European Union. "]
["R",null,"Reference period","A reference period is the time period for which statistical results are collected or calculated and to which, as a result, these values refer. The time period may be either a calendar year (reference year), a fiscal year, a semester, a quarter, a month and even a day."]
["top ↑",null,"Replacement costs","Replacement costs: includes costs occurring during the reference period to replace short‑life machinery and/or equipment, e.g. engineering plants, filters and instruments, vehicles, furniture, office and IT equipment, etc. Replacement costs are treated together with operating costs for the purpose of calculating the prorata application of discounted net revenue, as set out in Section E.1.2 of Annex II to the Implementing Regulation on application form and CBA methodology.","European Commission (2014)"]
["S",null,"shadow prices","The key concept is the use of shadow prices to reflect the social opportunity cost of goods and services. (For manpower, shadow wage).","European Commission (2014)"]
[null,null,"Scrap value / residual value","A residual value of the investment is considered at the end of the reference period. The residual value is calculated on the basis of the residual non‑depreciated accounting value. But, the residual value is maybe excluded because in many PPP contracts the infrastructure is returned to the public sector at the end of the period.","European Commission (2014)"]
["top ↑",null,"Social benefit","Benefits are defined as increases in human wellbeing (utility) and costs are defined as reductions in human wellbeing. For a project or policy to qualify on cost-benefit grounds, its social benefits must exceed its social costs. “Society” is simply the sum of individuals. If individuals’ preferences can be aggregated, social benefit is simply the sum of all individuals’ benefits.","David Pearce, D.; Atkinson, G.; Mourato, S. (2006)"]
[null,null,"Sources of financing","The main sources can be: \n- Union assistance (the EU grant/co-financing);\n- (national) public contribution (including, always, the counterpart funding from the OP plus additional grants or capital subsidies at central, regional or local government level, if any);\n- private contribution (under a PPP), (equity and loans) if any. The loan is an inflow and it is treated as a financial resource coming from third parties.","European Commission (2014)"]
[null,null,"Start-up and planning costs ","Start-up and planning costs can include costs, e.g. for feasibility studies, borne before the start of the evaluation period, although not eligable for EU funding."]
["V","VAT","Value Added Tax"]
["W",null,"Water usage (consumption)","Refers to freshwater taken from\nground or surface water sources, either permanently\nor temporarily, and conveyed to the place of use.","David Pearce, D.; Atkinson, G.; Mourato, S. (2006)"]
["top ↑","WTP","Willingness-to-pay","Measures the maximum amount consumers are willing to pay for a unit of a given good, is used to estimate the direct benefit(s) related to the use of the goods or services rendered by the project.","European Commission (2014)"]
["Y",null,"Year of reporting","Year of reporting (e.g. fiscal or business year, business plan) and year of investment are for reasons of simplications and data imputations the same years."]
["top ↑"]

{"sheet":"Sources","index":12,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Home ⌂"]
["Content &","Sources"]
[]
[null,"David Pearce, D.; Atkinson, G.; Mourato, S. (2006): Cost-Benefit Analysis and the Environment - Recent Developments, OECD (eds.), Paris."]
[null,"Dijkgraaf, E.; Vollebergh, H. (2004): Burn or bury? A social cost comparison of final waste disposal methods, Ecological Economics 50 (2004) 233– 247."]
[null,"DUAL Ports (2017), Green officer, www.dualports.eu [access 11.10.2017]"]
[null,"European Central Bank (2017): MFI interest rate statistics, www.ecb.europa.eu, access 03.02.2017"]
[null,"European Commission (2014): Guide to Cost-Benefit-Analysis of Investment Projects, \nEconomic appraisal tool for Cohesion Policy 2014-2020, Brussels."]
[null,"European Environment Agency (1997): The Concept of Environmental Space - Implications for Policies, Environmental Reporting and Assessments, Copenhagen."]
[null,"European Investment Bank (2013): The Economic Appraisal of Investment Projects at the EIB, Projects Directorate, Luxemburg."]
[null,"European Investment Bank (2014): Induced GHG Footprint, Methodologies for the Assessment of Project GHG Emissions, Version 10.0, Luxemburg."]
[null,"Eurostat (2017): Diverse data, http://ec.europa.eu/eurostat/web/main/home [access 03.02.2017]"]
[null,"Internationale Institut für Nachhaltigkeitsanalysen und -strategien (IINAS) (2017): GEMIS - Globales Emissions-Modell integrierter Systeme, Version 4.95, http://iinas.org [access 01.06.2017]"]
[null,"Umweltbundesamt (2017): Prozessorientierte Basisdaten für Umweltmanagementsysteme, www.probas.umweltbundesamt.de [access 01.06.2017]"]

{"sheet":"Imprint | Disclaimer","index":13,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,26,12]]}
["Home ⌂"]
["Content &","DUAL Ports - Developing Low carbon Utilities, Abilities and potential of regional entrepreneurial Ports"]
[null,"Developing low carbon port potential: Cost benefit & carbon footprint analyses "]
[null,"Dr. Malte Jahn and Dr. Jan Wedemeier"]
[null,"Hamburg Institute of International Economics (HWWI) | 2018"]
[]
[null,"Corresponding author / Contact:"]
[]
[null,"Dr. Jan Wedemeier"]
[null,"Hamburg Institute of International Economics (HWWI)"]
[null,"Fahrenheitstr. 1                            "]
[null,"28359 Bremen | Germany"]
[null,"Phone +49 (0)421-2208 – 243 | +49 (0)40-340576 – 663"]
[null,"wedemeier@hwwi.org"]
[]
[null,"Hamburg Institute of International Economics (HWWI)"]
[null,"Baumwall 7"]
[null,"20459 Hamburg | Germany                              "]
[null,"Phone +49 (0)40-340576 – 0"]
[null,"info@hwwi.org | www.hwwi.org "]
[]
[null,"© by the author(s)",null,"October 2018"]
[]
[null,"Disclaimer of liability"]
[null,"The author(s) are solely responsible for the contents which do not necessarily represent the opinion of the HWWI"]
[null,"The author(s) tried to ensure the validity and reliability of the sources and the information contained in this tool as good as possible. The author(s) is not responsibility for any errors or omissions, or for the results obtained from the use of this tool. All information in this tool is provided “as is” with no guarantees of completeness, accuracy, timeliness or of the results obtained from the use of this information."]

{"sheet":"Appendix - Input data","index":14,"n_rows":181,"n_cols":57,"rows_kept":181,"cut":false,"hidden":false,"merged":[[59,1,59,2],[15,2,15,7],[40,1,40,2]]}
["Home ⌂"]
["Content &","Appendix input data"]
[]
[null,"Public sector discount rate"]
[null,"top ↑","Definition →"]
[null,"Rate in %"]
[null,"Recommended financial discount rate according to article 19 of Commission Delegated Regulation (EU) No 480/2014, for the programming period 2014-2020. ",0]
[null,"Source: European Commission (2014)"]
[]
[null,"GHGe emissions"]
[null,"top ↑"]
[null,"Unit cost GHGe emissions in t"]
[null,"Description / Application"]
[null,"Cost of GHG emissions = VGHG*CGHG"]
[null,"where: ","VGHG ist the incremental volume of GHG emissions produced by the project, expressed in CO2 equivalents"]
[null,null,"CGHG is the damage cost of CO2"]
[null,null,"Value 2010 (Euro/t-CO2e)","Annual adders 2011-30 (in Euro)"]
[null,"High",40,2]
[null,"Central",25,1]
[null,"Low",10,0.5]
[null,"Source: European Commission (2014)"]
[]
[null,"Specific emissions from energy use (wihtout grid electricity)","CO2e g/kWh","CO2e t/kWh","S g/kWh","N g/kWh"]
[null,"(truck) diesel",{"$f":"2975.64420801229/9.86","v":301.7894734292384},{"$f":"C24/10^6","v":3.0178947342923842E-4},1E-3,0.05]
[null,"marine diesel",301.7894734292384,{"$f":"C25/10^6","v":3.0178947342923842E-4},0.1,2]
[null,"gasoline",{"$f":"2695.58439498223/8.77","v":307.36424116102967},3.0736424116102964E-4,1E-3,5.0000000000000001E-3]
[null,"heating oil",319.42972006373645,{"$f":"C27/10^6","v":3.1942972006373643E-4},5.0000000000000001E-3,0.12]
[null,"natural gas ",249.98145931989569,{"$f":"C28/10^6","v":2.4998145931989568E-4},5.0000000000000001E-4,0.08]
[null,"liquid gas",276.72764249132211,2.7672764249132213E-4,0,0.08]
[null,"lignite",678.95239224473994,6.7895239224473997E-4,2,1]
[null,"stone coal (brikets)",678.95239224473994,6.7895239224473997E-4,1,1.4]
[null,"stone coal (koks)",441.34807756780958,4.4134807756780959E-4,0.8,1.4]
[null,"wood (peaces)",18.890833851572268,1.8890833851572267E-5,0,0.3]
[null,"wood (pellets)",26.589440009446591,2.6589440009446592E-5,0,0.3]
[null,"hydropower",2.7871321171316299,2.7871321171316301E-6,0,0]
[null,"geothermal",95.498166002880893,9.5498166002880888E-5,0,0]
[null,"wind (onshore)",9.33509200236435,9.3350920023643497E-6,0,0]
[null,"solar",{"$f":"AVERAGE(60.8098095664209,48.5802085817093)","v":54.695009074065098},{"$f":"C38/10^6","v":5.4695009074065098E-5},0,0]
[null,"Source: IINAS (2017) (for CO2)"]
[]
[null,null,null,null,"operation",null,null,null,"implementation",null,null,null,"indirect"]
[null,"Conventional investment: Emissions",null,"CO2e [t]","S [g]","N [g]",null,"CO2e [t]","S [g]","N [g]",null,"CO2e [t]","S [g]","N [g]"]
[null,"(truck) diesel",null,{"$f":"D24*'Externalities - Operation'!D15","v":0},{"$f":"E24*'Externalities - Operation'!D15","v":0},{"$f":"F24*'Externalities - Operation'!D15","v":0},null,{"$f":"D24*'Externalities - Implementation'!D15","v":0},{"$f":"E24*'Externalities - Implementation'!D15","v":0},{"$f":"F24*'Externalities - Implementation'!D15","v":0},null,{"$f":"D24*'Indirect Externalities'!D8","v":0},{"$f":"E24*'Indirect Externalities'!D8","v":0},{"$f":"F24*'Indirect Externalities'!D8","v":0}]
[null,"marine diesel",null,{"$f":"D25*'Externalities - Operation'!D16","v":0},{"$f":"E25*'Externalities - Operation'!D16","v":0},{"$f":"F25*'Externalities - Operation'!D16","v":0},null,{"$f":"D25*'Externalities - Implementation'!D16","v":0},{"$f":"E25*'Externalities - Implementation'!D16","v":0},{"$f":"F25*'Externalities - Implementation'!D16","v":0},null,{"$f":"D25*'Indirect Externalities'!D9","v":0},{"$f":"E25*'Indirect Externalities'!D9","v":0},{"$f":"F25*'Indirect Externalities'!D9","v":0}]
[null,"gasoline",null,{"$f":"D26*'Externalities - Operation'!D17","v":0},{"$f":"E26*'Externalities - Operation'!D17","v":0},{"$f":"F26*'Externalities - Operation'!D17","v":0},null,{"$f":"D26*'Externalities - Implementation'!D17","v":0},{"$f":"E26*'Externalities - Implementation'!D17","v":0},{"$f":"F26*'Externalities - Implementation'!D17","v":0},null,{"$f":"D26*'Indirect Externalities'!D10","v":0},{"$f":"E26*'Indirect Externalities'!D10","v":0},{"$f":"F26*'Indirect Externalities'!D10","v":0}]
[null,"heating oil",null,{"$f":"D27*'Externalities - Operation'!D18","v":0},{"$f":"E27*'Externalities - Operation'!D18","v":0},{"$f":"F27*'Externalities - Operation'!D18","v":0},null,{"$f":"D27*'Externalities - Implementation'!D18","v":0},{"$f":"E27*'Externalities - Implementation'!D18","v":0},{"$f":"F27*'Externalities - Implementation'!D18","v":0},null,{"$f":"D27*'Indirect Externalities'!D11","v":0},{"$f":"E27*'Indirect Externalities'!D11","v":0},{"$f":"F27*'Indirect Externalities'!D11","v":0}]
[null,"natural gas ",null,{"$f":"D28*'Externalities - Operation'!D19","v":0},{"$f":"E28*'Externalities - Operation'!D19","v":0},{"$f":"F28*'Externalities - Operation'!D19","v":0},null,{"$f":"D28*'Externalities - Implementation'!D19","v":0},{"$f":"E28*'Externalities - Implementation'!D19","v":0},{"$f":"F28*'Externalities - Implementation'!D19","v":0},null,{"$f":"D28*'Indirect Externalities'!D12","v":0},{"$f":"E28*'Indirect Externalities'!D12","v":0},{"$f":"F28*'Indirect Externalities'!D12","v":0}]
[null,"liquid gas",null,{"$f":"D29*'Externalities - Operation'!D20","v":0},{"$f":"E29*'Externalities - Operation'!D20","v":0},{"$f":"F29*'Externalities - Operation'!D20","v":0},null,{"$f":"D29*'Externalities - Implementation'!D20","v":0},{"$f":"E29*'Externalities - Implementation'!D20","v":0},{"$f":"F29*'Externalities - Implementation'!D20","v":0},null,{"$f":"D29*'Indirect Externalities'!D13","v":0},{"$f":"E29*'Indirect Externalities'!D13","v":0},{"$f":"F29*'Indirect Externalities'!D13","v":0}]
[null,"lignite",null,{"$f":"D30*'Externalities - Operation'!D21","v":0},{"$f":"E30*'Externalities - Operation'!D21","v":0},{"$f":"F30*'Externalities - Operation'!D21","v":0},null,{"$f":"D30*'Externalities - Implementation'!D21","v":0},{"$f":"E30*'Externalities - Implementation'!D21","v":0},{"$f":"F30*'Externalities - Implementation'!D21","v":0},null,{"$f":"D30*'Indirect Externalities'!D14","v":0},{"$f":"E30*'Indirect Externalities'!D14","v":0},{"$f":"F30*'Indirect Externalities'!D14","v":0}]
[null,"stone coal (brikets)",null,{"$f":"D31*'Externalities - Operation'!D22","v":0},{"$f":"E31*'Externalities - Operation'!D22","v":0},{"$f":"F31*'Externalities - Operation'!D22","v":0},null,{"$f":"D31*'Externalities - Implementation'!D22","v":0},{"$f":"E31*'Externalities - Implementation'!D22","v":0},{"$f":"F31*'Externalities - Implementation'!D22","v":0},null,{"$f":"D31*'Indirect Externalities'!D15","v":0},{"$f":"E31*'Indirect Externalities'!D15","v":0},{"$f":"F31*'Indirect Externalities'!D15","v":0}]
[null,"stone coal (koks)",null,{"$f":"D32*'Externalities - Operation'!D23","v":0},{"$f":"E32*'Externalities - Operation'!D23","v":0},{"$f":"F32*'Externalities - Operation'!D23","v":0},null,{"$f":"D32*'Externalities - Implementation'!D23","v":0},{"$f":"E32*'Externalities - Implementation'!D23","v":0},{"$f":"F32*'Externalities - Implementation'!D23","v":0},null,{"$f":"D32*'Indirect Externalities'!D16","v":0},{"$f":"E32*'Indirect Externalities'!D16","v":0},{"$f":"F32*'Indirect Externalities'!D16","v":0}]
[null,"wood (peaces)",null,{"$f":"D33*'Externalities - Operation'!D24","v":0},{"$f":"E33*'Externalities - Operation'!D24","v":0},{"$f":"F33*'Externalities - Operation'!D24","v":0},null,{"$f":"D33*'Externalities - Implementation'!D24","v":0},{"$f":"E33*'Externalities - Implementation'!D24","v":0},{"$f":"F33*'Externalities - Implementation'!D24","v":0},null,{"$f":"D33*'Indirect Externalities'!D17","v":0},{"$f":"E33*'Indirect Externalities'!D17","v":0},{"$f":"F33*'Indirect Externalities'!D17","v":0}]
[null,"wood (pellets)",null,{"$f":"D34*'Externalities - Operation'!D25","v":0},{"$f":"E34*'Externalities - Operation'!D25","v":0},{"$f":"F34*'Externalities - Operation'!D25","v":0},null,{"$f":"D34*'Externalities - Implementation'!D25","v":0},{"$f":"E34*'Externalities - Implementation'!D25","v":0},{"$f":"F34*'Externalities - Implementation'!D25","v":0},null,{"$f":"D34*'Indirect Externalities'!D18","v":0},{"$f":"E34*'Indirect Externalities'!D18","v":0},{"$f":"F34*'Indirect Externalities'!D18","v":0}]
[null,"hydropower",null,{"$f":"C35*'Externalities - Operation'!D10","v":0},{"$f":"E35*'Externalities - Operation'!D10","v":0},{"$f":"F35*'Externalities - Operation'!D10","v":0},null,{"$f":"D35*'Externalities - Implementation'!D10","v":0},{"$f":"E35*'Externalities - Implementation'!D10","v":0},{"$f":"F35*'Externalities - Implementation'!D10","v":0}]
[null,"geothermal",null,{"$f":"C36*'Externalities - Operation'!D11","v":0},{"$f":"E36*'Externalities - Operation'!D11","v":0},{"$f":"F36*'Externalities - Operation'!D11","v":0},null,{"$f":"D36*'Externalities - Implementation'!D11","v":0},{"$f":"E36*'Externalities - Implementation'!D11","v":0},{"$f":"F36*'Externalities - Implementation'!D11","v":0}]
[null,"wind (onshore)",null,{"$f":"C37*'Externalities - Operation'!D12","v":0},{"$f":"E37*'Externalities - Operation'!D12","v":0},{"$f":"F37*'Externalities - Operation'!D12","v":0},null,{"$f":"D37*'Externalities - Implementation'!D12","v":0},{"$f":"E37*'Externalities - Implementation'!D12","v":0},{"$f":"F37*'Externalities - Implementation'!D12","v":0}]
[null,"solar",null,{"$f":"C38*'Externalities - Operation'!D13","v":0},{"$f":"E38*'Externalities - Operation'!D13","v":0},{"$f":"F38*'Externalities - Operation'!D13","v":0},null,{"$f":"D38*'Externalities - Implementation'!D13","v":0},{"$f":"E38*'Externalities - Implementation'!D13","v":0},{"$f":"F38*'Externalities - Implementation'!D13","v":0}]
[null,null,"total",{"$f":"SUM(D43:D57)","v":0},{"$f":"SUM(E43:E57)","v":0},0,null,{"$f":"SUM(H43:H57)","v":0},{"$f":"SUM(I43:I57)","v":0},{"$f":"SUM(J43:J57)","v":0},null,{"$f":"SUM(L43:L57)","v":0},{"$f":"SUM(M43:M57)","v":0},{"$f":"SUM(N43:N57)","v":0}]
[]
[null,null,null,null,"operation",null,null,null,"implementation",null,null,null,"indirect"]
[null,"Green investment: Emissions",null,"CO2e [t]","S [g]","N [g]",null,"CO2e [t]","S [g]","N [g]",null,"CO2e [t]","S [g]","N [g]"]
[null,"(truck) diesel",null,{"$f":"D24*'Externalities - Operation'!E15","v":0},{"$f":"E24*'Externalities - Operation'!E15","v":0},{"$f":"F24*'Externalities - Operation'!E15","v":0},null,{"$f":"D24*'Externalities - Implementation'!E15","v":0},{"$f":"E24*'Externalities - Implementation'!E15","v":0},{"$f":"F24*'Externalities - Implementation'!E15","v":0},null,{"$f":"D24*'Indirect Externalities'!E8","v":0},{"$f":"E24*'Indirect Externalities'!E8","v":0},{"$f":"F24*'Indirect Externalities'!E8","v":0}]
[null,"marine diesel",null,{"$f":"D25*'Externalities - Operation'!E16","v":0},{"$f":"E25*'Externalities - Operation'!E16","v":0},{"$f":"F25*'Externalities - Operation'!E16","v":0},null,{"$f":"D25*'Externalities - Implementation'!E16","v":0},{"$f":"E25*'Externalities - Implementation'!E16","v":0},{"$f":"F25*'Externalities - Implementation'!E16","v":0},null,{"$f":"D25*'Indirect Externalities'!E9","v":0},{"$f":"E25*'Indirect Externalities'!E9","v":0},{"$f":"F25*'Indirect Externalities'!E9","v":0}]
[null,"gasoline",null,{"$f":"D26*'Externalities - Operation'!E17","v":0},{"$f":"E26*'Externalities - Operation'!E17","v":0},{"$f":"F26*'Externalities - Operation'!E17","v":0},null,{"$f":"D26*'Externalities - Implementation'!E17","v":0},{"$f":"E26*'Externalities - Implementation'!E17","v":0},{"$f":"F26*'Externalities - Implementation'!E17","v":0},null,{"$f":"D26*'Indirect Externalities'!E10","v":0},{"$f":"E26*'Indirect Externalities'!E10","v":0},{"$f":"F26*'Indirect Externalities'!E10","v":0}]
[null,"heating oil",null,{"$f":"D27*'Externalities - Operation'!E18","v":0},{"$f":"E27*'Externalities - Operation'!E18","v":0},{"$f":"F27*'Externalities - Operation'!E18","v":0},null,{"$f":"D27*'Externalities - Implementation'!E18","v":0},{"$f":"E27*'Externalities - Implementation'!E18","v":0},{"$f":"F27*'Externalities - Implementation'!E18","v":0},null,{"$f":"D27*'Indirect Externalities'!E11","v":0},{"$f":"E27*'Indirect Externalities'!E11","v":0},{"$f":"F27*'Indirect Externalities'!E11","v":0}]
[null,"natural gas ",null,{"$f":"D28*'Externalities - Operation'!E19","v":0},{"$f":"E28*'Externalities - Operation'!E19","v":0},{"$f":"F28*'Externalities - Operation'!E19","v":0},null,{"$f":"D28*'Externalities - Implementation'!E19","v":0},{"$f":"E28*'Externalities - Implementation'!E19","v":0},{"$f":"F28*'Externalities - Implementation'!E19","v":0},null,{"$f":"D28*'Indirect Externalities'!E12","v":0},{"$f":"E28*'Indirect Externalities'!E12","v":0},{"$f":"F28*'Indirect Externalities'!E12","v":0}]
[null,"liquid gas",null,{"$f":"D29*'Externalities - Operation'!E20","v":0},{"$f":"E29*'Externalities - Operation'!E20","v":0},{"$f":"F29*'Externalities - Operation'!E20","v":0},null,{"$f":"D29*'Externalities - Implementation'!E20","v":0},{"$f":"E29*'Externalities - Implementation'!E20","v":0},{"$f":"F29*'Externalities - Implementation'!E20","v":0},null,{"$f":"D29*'Indirect Externalities'!E13","v":0},{"$f":"E29*'Indirect Externalities'!E13","v":0},{"$f":"F29*'Indirect Externalities'!E13","v":0}]
[null,"lignite",null,{"$f":"D30*'Externalities - Operation'!E21","v":0},{"$f":"E30*'Externalities - Operation'!E21","v":0},{"$f":"F30*'Externalities - Operation'!E21","v":0},null,{"$f":"D30*'Externalities - Implementation'!E21","v":0},{"$f":"E30*'Externalities - Implementation'!E21","v":0},{"$f":"F30*'Externalities - Implementation'!E21","v":0},null,{"$f":"D30*'Indirect Externalities'!E14","v":0},{"$f":"E30*'Indirect Externalities'!E14","v":0},{"$f":"F30*'Indirect Externalities'!E14","v":0}]
[null,"stone coal (brikets)",null,{"$f":"D31*'Externalities - Operation'!E22","v":0},{"$f":"E31*'Externalities - Operation'!E22","v":0},{"$f":"F31*'Externalities - Operation'!E22","v":0},null,{"$f":"D31*'Externalities - Implementation'!E22","v":0},{"$f":"E31*'Externalities - Implementation'!E22","v":0},{"$f":"F31*'Externalities - Implementation'!E22","v":0},null,{"$f":"D31*'Indirect Externalities'!E15","v":0},{"$f":"E31*'Indirect Externalities'!E15","v":0},{"$f":"F31*'Indirect Externalities'!E15","v":0}]
[null,"stone coal (koks)",null,{"$f":"D32*'Externalities - Operation'!E23","v":0},{"$f":"E32*'Externalities - Operation'!E23","v":0},{"$f":"F32*'Externalities - Operation'!E23","v":0},null,{"$f":"D32*'Externalities - Implementation'!E23","v":0},{"$f":"E32*'Externalities - Implementation'!E23","v":0},{"$f":"F32*'Externalities - Implementation'!E23","v":0},null,{"$f":"D32*'Indirect Externalities'!E16","v":0},{"$f":"E32*'Indirect Externalities'!E16","v":0},{"$f":"F32*'Indirect Externalities'!E16","v":0}]
[null,"wood (peaces)",null,{"$f":"D33*'Externalities - Operation'!E24","v":0},{"$f":"E33*'Externalities - Operation'!E24","v":0},{"$f":"F33*'Externalities - Operation'!E24","v":0},null,{"$f":"D33*'Externalities - Implementation'!E24","v":0},{"$f":"E33*'Externalities - Implementation'!E24","v":0},{"$f":"F33*'Externalities - Implementation'!E24","v":0},null,{"$f":"D33*'Indirect Externalities'!E17","v":0},{"$f":"E33*'Indirect Externalities'!E17","v":0},{"$f":"F33*'Indirect Externalities'!E17","v":0}]
[null,"wood (pellets)",null,{"$f":"D34*'Externalities - Operation'!E25","v":0},{"$f":"E34*'Externalities - Operation'!E25","v":0},{"$f":"F34*'Externalities - Operation'!E25","v":0},null,{"$f":"D34*'Externalities - Implementation'!E25","v":0},{"$f":"E34*'Externalities - Implementation'!E25","v":0},{"$f":"F34*'Externalities - Implementation'!E25","v":0},null,{"$f":"D34*'Indirect Externalities'!E18","v":0},{"$f":"E34*'Indirect Externalities'!E18","v":0},{"$f":"F34*'Indirect Externalities'!E18","v":0}]
[null,"hydropower",null,{"$f":"D35*'Externalities - Operation'!E10","v":0},{"$f":"E35*'Externalities - Operation'!E10","v":0},{"$f":"F35*'Externalities - Operation'!E10","v":0},null,{"$f":"D35*'Externalities - Implementation'!E10","v":0},{"$f":"E35*'Externalities - Implementation'!E10","v":0},{"$f":"F35*'Externalities - Implementation'!E10","v":0}]
[null,"geothermal",null,{"$f":"D36*'Externalities - Operation'!E11","v":0},{"$f":"E36*'Externalities - Operation'!E11","v":0},{"$f":"F36*'Externalities - Operation'!E11","v":0},null,{"$f":"D36*'Externalities - Implementation'!E11","v":0},{"$f":"E36*'Externalities - Implementation'!E11","v":0},{"$f":"F36*'Externalities - Implementation'!E11","v":0}]
[null,"wind (onshore)",null,{"$f":"D37*'Externalities - Operation'!E12","v":0},{"$f":"E37*'Externalities - Operation'!E12","v":0},{"$f":"F37*'Externalities - Operation'!E12","v":0},null,{"$f":"D37*'Externalities - Implementation'!E12","v":0},{"$f":"E37*'Externalities - Implementation'!E12","v":0},{"$f":"F37*'Externalities - Implementation'!E12","v":0}]
[null,"solar",null,{"$f":"D38*'Externalities - Operation'!E13","v":0},{"$f":"E38*'Externalities - Operation'!E13","v":0},{"$f":"F38*'Externalities - Operation'!E13","v":0},null,{"$f":"D38*'Externalities - Implementation'!E13","v":0},{"$f":"E38*'Externalities - Implementation'!E13","v":0},{"$f":"F38*'Externalities - Implementation'!E13","v":0}]
[null,null,"total",{"$f":"SUM(D62:D76)","v":0},{"$f":"SUM(E62:E76)","v":0},{"$f":"SUM(F62:F76)","v":0},null,{"$f":"SUM(H62:H76)","v":0},{"$f":"SUM(I62:I76)","v":0},{"$f":"SUM(J62:J76)","v":0},null,{"$f":"SUM(L62:L76)","v":0},{"$f":"SUM(M62:M76)","v":0},{"$f":"SUM(N62:N76)","v":0}]
[]
[null,"Purchased electricity: country grid emission factos"]
[null,null,null,null,null,null,"country","Grid emission factor"]
[null,"Conversion factor in t CO2",null,null,null,null,"Belgium",237]
[null,"in t CO2/ kWh",null,null,{"$f":"VLOOKUP(Description!C7,'Appendix - Input data'!$G$81:$H$87,2,FALSE)/1000000","v":2.3699999999999999E-4},null,"Denmark",401]
[null," adjusted for share of green grid electricity",null,null,{"$f":"IF('Externalities - Implementation'!D8>0,(1-'Externalities - Implementation'!D8)*E82+0.000025,E82)","v":2.3699999999999999E-4},null,"Germany",527]
[null,"Operating emissions from grid electricity (t CO2/a)",null,null,null,null,"Netherlands",462]
[null,"operation: conventional investment",null,null,{"$f":"E83*'Externalities - Operation'!D7","v":0},null,"Sweden",274]
[null,"operation: green investment",null,null,{"$f":"E83*'Externalities - Operation'!E7","v":0},null,"United Kingdom",504]
[null,"Implementation emissions from grid electrictiy (t CO2)",null,null,null,null,"EU27",328]
[null,"implementation: conventional investment",null,null,{"$f":"E83*'Externalities - Implementation'!D7","v":0},null,"Source: EIB (2014)"]
[null,"implementation: green investment",null,null,{"$f":"E83*'Externalities - Implementation'!E7","v":0}]
[null,"Source: EIB (2014)"]
[]
[]
[]
[null,null,{"$f":"Description!C8","v":2017},{"$f":"C94+1","v":2018},{"$f":"D94+1","v":2019},{"$f":"E94+1","v":2020},{"$f":"F94+1","v":2021},{"$f":"G94+1","v":2022},{"$f":"H94+1","v":2023},2024,{"$f":"J94+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,{"$f":"AZ94+1","v":2067},{"$f":"BA94+1","v":2068},{"$f":"BB94+1","v":2069},{"$f":"BC94+1","v":2070},{"$f":"BD94+1","v":2071}]
[null,"Social cost of CO2 (Euro/t-CO2e)",{"$f":"MIN(C94-1985,45)","v":32},{"$f":"MIN(D94-1985,45)","v":33},34,35,36,37,38,39,40,41,42,43,44,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45]
[]
[null,"Operation: CO2 costs in Euro/a"]
[null,"Conventional investment",{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*C95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*D95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*E95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*F95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*G95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*H95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*I95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*J95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*K95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*L95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*M95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*N95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*O95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*P95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*Q95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*R95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*S95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*T95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*U95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*V95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*W95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*X95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*Y95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*Z95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AA95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AB95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AC95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AD95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AE95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AF95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AG95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AH95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AI95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AJ95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AK95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AL95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AM95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AN95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AO95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AP95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AQ95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AR95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AS95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AT95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AU95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AV95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AW95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AX95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AY95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*AZ95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*BA95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*BB95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*BC95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*BD95,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,($D$58+$E$85)*BE95,0)","v":0}]
[null,"Green investment",{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*C95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*D95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*E95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*F95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*G95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*H95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*I95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*J95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*K95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*L95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*M95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*N95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*O95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*P95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*Q95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*R95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*S95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*T95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*U95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*V95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*W95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*X95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*Y95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*Z95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AA95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AB95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AC95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AD95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AE95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AF95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AG95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AH95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AI95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AJ95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AK95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AL95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AM95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AN95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AO95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AP95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AQ95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AR95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AS95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AT95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AU95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AV95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AW95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AX95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AY95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*AZ95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*BA95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*BB95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*BC95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*BD95,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,($D$77+$E$86)*BE95,0)","v":0}]
[]
[null,"Indirect: CO2 costs in Euro/a"]
[null,"Conventional investment",{"$f":"C95*$L$58","v":0},{"$f":"D95*$L$58","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Green investment",{"$f":"C95*$L$77","v":0},{"$f":"D95*$L$77","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Implementation: CO2 costs in Euro"]
[null,"Conventional investment",null,{"$f":"($H$58+$E$88)*D95","v":0}]
[null,"Green investment",null,{"$f":"($H$77+$E$89)*D95","v":0}]
[]
[null,"Waste treatment"]
[null,"top ↑"]
[null,"Landfill: Social costs of land use (Euro/t)",17.64]
[null,"Source: Dijkgraaf and Vollebergh (2004)"]
[]
[null,"Operation: Net external costs from waste treatment (Euro/a)",{"$f":"Description!C8","v":2017},{"$f":"C114+1","v":2018},{"$f":"D114+1","v":2019},{"$f":"E114+1","v":2020},{"$f":"F114+1","v":2021},{"$f":"G114+1","v":2022},{"$f":"H114+1","v":2023},2024,{"$f":"J114+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,{"$f":"AZ114+1","v":2067},{"$f":"BA114+1","v":2068},{"$f":"BB114+1","v":2069},{"$f":"BC114+1","v":2070},{"$f":"BD114+1","v":2071}]
[null,"Conventional investment",{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,$C$111*'Externalities - Operation'!$D$33,0)","v":0}]
[null,"Green investment",{"$f":"IF('Operating results'!$E$6>0,C111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,D111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,E111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,F111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,G111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,H111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,I111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,J111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,K111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,L111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,M111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,N111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,O111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,P111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,Q111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,R111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,S111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,T111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,U111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,V111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,W111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,X111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,Y111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,Z111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AA111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AB111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AC111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AD111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AE111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AF111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AG111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AH111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AI111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AJ111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AK111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AL111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AM111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AN111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AO111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AP111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AQ111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AR111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AS111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AT111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AU111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AV111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AW111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AX111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AY111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,AZ111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,BA111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,BB111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,BC111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,BD111*'Externalities - Operation'!$E$33,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,BE111*'Externalities - Operation'!$E$33,0)","v":0}]
[]
[null,"Implementation: Net external costs from waste treatment (Euro)"]
[null,"Conventional investment",null,{"$f":"C111*'Externalities - Implementation'!D33","v":0}]
[null,"Green investment",null,{"$f":"C111*'Externalities - Implementation'!E33","v":0}]
[]
[null,"Operating costs and revenues"]
[null,"top ↑"]
[null,null,{"$f":"Description!C8","v":2017},{"$f":"C124+1","v":2018},{"$f":"D124+1","v":2019},{"$f":"E124+1","v":2020},{"$f":"F124+1","v":2021},{"$f":"G124+1","v":2022},{"$f":"H124+1","v":2023},{"$f":"I124+1","v":2024},{"$f":"J124+1","v":2025},{"$f":"K124+1","v":2026},{"$f":"L124+1","v":2027},{"$f":"M124+1","v":2028},{"$f":"N124+1","v":2029},{"$f":"O124+1","v":2030},{"$f":"P124+1","v":2031},{"$f":"Q124+1","v":2032},{"$f":"R124+1","v":2033},{"$f":"S124+1","v":2034},{"$f":"T124+1","v":2035},{"$f":"U124+1","v":2036},{"$f":"V124+1","v":2037},{"$f":"W124+1","v":2038},{"$f":"X124+1","v":2039},{"$f":"Y124+1","v":2040},{"$f":"Z124+1","v":2041},{"$f":"AA124+1","v":2042},{"$f":"AB124+1","v":2043},{"$f":"AC124+1","v":2044},{"$f":"AD124+1","v":2045},{"$f":"AE124+1","v":2046},{"$f":"AF124+1","v":2047},{"$f":"AG124+1","v":2048},{"$f":"AH124+1","v":2049},{"$f":"AI124+1","v":2050},{"$f":"AJ124+1","v":2051},{"$f":"AK124+1","v":2052},{"$f":"AL124+1","v":2053},{"$f":"AM124+1","v":2054},{"$f":"AN124+1","v":2055},{"$f":"AO124+1","v":2056},{"$f":"AP124+1","v":2057},{"$f":"AQ124+1","v":2058},{"$f":"AR124+1","v":2059},{"$f":"AS124+1","v":2060},{"$f":"AT124+1","v":2061},{"$f":"AU124+1","v":2062},{"$f":"AV124+1","v":2063},{"$f":"AW124+1","v":2064},{"$f":"AX124+1","v":2065},{"$f":"AY124+1","v":2066},{"$f":"AZ124+1","v":2067},{"$f":"BA124+1","v":2068},{"$f":"BB124+1","v":2069},{"$f":"BC124+1","v":2070},{"$f":"BD124+1","v":2071}]
[null,"Conventional investment"]
[null,"Operating revenue",{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$7,0)","v":0}]
[null,"Operating costs",{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0},{"$f":"IF('Operating results'!$D$6>0,'Operating results'!$D$9,0)","v":0}]
[null,"Operating surplus",{"$f":"C126-C127","v":0},{"$f":"D126-D127","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BA126-BA127","v":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,null,null,null,null,{"$f":"AB115*AB117","v":0}]
[null,"Green investment"]
[null,"Operating revenue",{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$7,0)","v":0}]
[null,"Operating costs",{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0},{"$f":"IF('Operating results'!$E$6>0,'Operating results'!$E$9,0)","v":0}]
[null,"Operating surplus",{"$f":"C131-C132","v":0},{"$f":"D131-D132","v":0},{"$f":"E131-E132","v":0},{"$f":"F131-F132","v":0},{"$f":"G131-G132","v":0},{"$f":"H131-H132","v":0},{"$f":"I131-I132","v":0},{"$f":"J131-J132","v":0},{"$f":"K131-K132","v":0},{"$f":"L131-L132","v":0},{"$f":"M131-M132","v":0},{"$f":"N131-N132","v":0},{"$f":"O131-O132","v":0},{"$f":"P131-P132","v":0},{"$f":"Q131-Q132","v":0},{"$f":"R131-R132","v":0},{"$f":"S131-S132","v":0},{"$f":"T131-T132","v":0},{"$f":"U131-U132","v":0},{"$f":"V131-V132","v":0},{"$f":"W131-W132","v":0},{"$f":"X131-X132","v":0},{"$f":"Y131-Y132","v":0},{"$f":"Z131-Z132","v":0},{"$f":"AA131-AA132","v":0},{"$f":"AB131-AB132","v":0},{"$f":"AC131-AC132","v":0},{"$f":"AD131-AD132","v":0},{"$f":"AE131-AE132","v":0},{"$f":"AF131-AF132","v":0},{"$f":"AG131-AG132","v":0},{"$f":"AH131-AH132","v":0},{"$f":"AI131-AI132","v":0},{"$f":"AJ131-AJ132","v":0},{"$f":"AK131-AK132","v":0},{"$f":"AL131-AL132","v":0},{"$f":"AM131-AM132","v":0},{"$f":"AN131-AN132","v":0},{"$f":"AO131-AO132","v":0},{"$f":"AP131-AP132","v":0},{"$f":"AQ131-AQ132","v":0},{"$f":"AR131-AR132","v":0},{"$f":"AS131-AS132","v":0},{"$f":"AT131-AT132","v":0},{"$f":"AU131-AU132","v":0},{"$f":"AV131-AV132","v":0},{"$f":"AW131-AW132","v":0},{"$f":"AX131-AX132","v":0},{"$f":"AY131-AY132","v":0},{"$f":"AZ131-AZ132","v":0},0,0,0,0,0]
[]
[]
[null,"Financing"]
[null,"top ↑"]
[null,null,{"$f":"Description!C8","v":2017},{"$f":"C138+1","v":2018},{"$f":"D138+1","v":2019},{"$f":"E138+1","v":2020},2021,2022,2023,2024,{"$f":"J138+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071]
[null,"Conventional investment"]
[null,"Inflows (without equity)",{"$f":"'Investment volume'!$D$6*SUM('Investment volume'!$D$11:$D$14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Capital costs",{"$f":"IF('Operating results'!D6<=1,C140*(1+'Investment volume'!D19),'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0},{"$f":"IF('Operating results'!$D$6>1,'Investment volume'!$D$6*'Investment volume'!$D$14*(1+'Investment volume'!$D$19)/'Operating results'!$D$6,0)","v":0}]
[null,"Net financial flow",{"$f":"C140-C141","v":0},{"$f":"D140-D141","v":0},{"$f":"E140-E141","v":0},{"$f":"F140-F141","v":0},{"$f":"G140-G141","v":0},{"$f":"H140-H141","v":0},{"$f":"I140-I141","v":0},{"$f":"J140-J141","v":0},{"$f":"K140-K141","v":0},{"$f":"L140-L141","v":0},{"$f":"M140-M141","v":0},{"$f":"N140-N141","v":0},{"$f":"O140-O141","v":0},{"$f":"P140-P141","v":0},{"$f":"Q140-Q141","v":0},{"$f":"R140-R141","v":0},{"$f":"S140-S141","v":0},{"$f":"T140-T141","v":0},{"$f":"U140-U141","v":0},{"$f":"V140-V141","v":0},{"$f":"W140-W141","v":0},{"$f":"X140-X141","v":0},{"$f":"Y140-Y141","v":0},{"$f":"Z140-Z141","v":0},{"$f":"AA140-AA141","v":0},{"$f":"AB140-AB141","v":0},{"$f":"AC140-AC141","v":0},{"$f":"AD140-AD141","v":0},{"$f":"AE140-AE141","v":0},{"$f":"AF140-AF141","v":0},{"$f":"AG140-AG141","v":0},{"$f":"AH140-AH141","v":0},{"$f":"AI140-AI141","v":0},{"$f":"AJ140-AJ141","v":0},{"$f":"AK140-AK141","v":0},{"$f":"AL140-AL141","v":0},{"$f":"AM140-AM141","v":0},{"$f":"AN140-AN141","v":0},{"$f":"AO140-AO141","v":0},{"$f":"AP140-AP141","v":0},{"$f":"AQ140-AQ141","v":0},{"$f":"AR140-AR141","v":0},{"$f":"AS140-AS141","v":0},{"$f":"AT140-AT141","v":0},{"$f":"AU140-AU141","v":0},{"$f":"AV140-AV141","v":0},{"$f":"AW140-AW141","v":0},{"$f":"AX140-AX141","v":0},{"$f":"AY140-AY141","v":0},0,0,0,0,0,0]
[]
[null,"Green investment"]
[null,"Inflows (without equity)",{"$f":"'Investment volume'!$E$6*SUM('Investment volume'!$E$11:$E$14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Capital costs",{"$f":"IF('Operating results'!E6<=1,C145*(1+'Investment volume'!D19),'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0},{"$f":"IF('Operating results'!$E$6>1,'Investment volume'!$E$6*'Investment volume'!$E$14*(1+'Investment volume'!$D$19)/'Operating results'!$E$6,0)","v":0}]
[null,"Net financial flow",{"$f":"C145-C146","v":0},{"$f":"D145-D146","v":0},{"$f":"E145-E146","v":0},{"$f":"F145-F146","v":0},{"$f":"G145-G146","v":0},{"$f":"H145-H146","v":0},{"$f":"I145-I146","v":0},{"$f":"J145-J146","v":0},{"$f":"K145-K146","v":0},{"$f":"L145-L146","v":0},{"$f":"M145-M146","v":0},{"$f":"N145-N146","v":0},{"$f":"O145-O146","v":0},{"$f":"P145-P146","v":0},{"$f":"Q145-Q146","v":0},{"$f":"R145-R146","v":0},{"$f":"S145-S146","v":0},{"$f":"T145-T146","v":0},{"$f":"U145-U146","v":0},{"$f":"V145-V146","v":0},{"$f":"W145-W146","v":0},{"$f":"X145-X146","v":0},{"$f":"Y145-Y146","v":0},{"$f":"Z145-Z146","v":0},{"$f":"AA145-AA146","v":0},{"$f":"AB145-AB146","v":0},{"$f":"AC145-AC146","v":0},{"$f":"AD145-AD146","v":0},{"$f":"AE145-AE146","v":0},{"$f":"AF145-AF146","v":0},{"$f":"AG145-AG146","v":0},{"$f":"AH145-AH146","v":0},{"$f":"AI145-AI146","v":0},{"$f":"AJ145-AJ146","v":0},{"$f":"AK145-AK146","v":0},{"$f":"AL145-AL146","v":0},{"$f":"AM145-AM146","v":0},{"$f":"AN145-AN146","v":0},{"$f":"AO145-AO146","v":0},{"$f":"AP145-AP146","v":0},{"$f":"AQ145-AQ146","v":0},{"$f":"AR145-AR146","v":0},{"$f":"AS145-AS146","v":0},{"$f":"AT145-AT146","v":0},{"$f":"AU145-AU146","v":0},{"$f":"AV145-AV146","v":0},{"$f":"AW145-AW146","v":0},{"$f":"AX145-AX146","v":0},{"$f":"AY145-AY146","v":0},0,0,0,0,0,0]
[]
[null,"Discounted Figures"]
[null,"top ↑"]
[null,null,{"$f":"Description!C8","v":2017},{"$f":"C151+1","v":2018},{"$f":"D151+1","v":2019},{"$f":"E151+1","v":2020},2021,2022,2023,2024,{"$f":"J151+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071]
[null,"conventional: Within appraisal period (yes/no)",1,{"$f":"IF(D151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(E151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(F151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(G151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(H151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(I151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(J151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(K151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(L151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(M151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(N151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(O151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(P151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(Q151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(R151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(S151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(T151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(U151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(V151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(W151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(X151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(Y151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(Z151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AA151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AB151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AC151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AD151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AE151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AF151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AG151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AH151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AI151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AJ151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AK151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AL151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AM151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AN151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AO151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AP151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AQ151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AR151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AS151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AT151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AU151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AV151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AW151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AX151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AY151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(AZ151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(BA151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(BB151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(BC151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(BD151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0},{"$f":"IF(BE151<Description!$C$8+'Operating results'!$D$6,1,0)","v":0}]
[null,"conventional: Discount factor",{"$f":"(1+$C$7)^(-C151+2016)*C152","v":1},{"$f":"(1+$C$7)^(-D151+2016)*D152","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"green: Within appraisal period (yes/no)",1,{"$f":"IF(D151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(E151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(F151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(G151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(H151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(I151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(J151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(K151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(L151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(M151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(N151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(O151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(P151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(Q151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(R151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(S151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(T151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(U151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(V151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(W151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(X151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(Y151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(Z151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AA151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AB151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AC151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AD151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AE151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AF151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AG151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AH151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AI151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AJ151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AK151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AL151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AM151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AN151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AO151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AP151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AQ151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AR151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AS151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AT151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AU151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AV151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AW151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AX151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AY151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(AZ151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(BA151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(BB151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(BC151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(BD151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0},{"$f":"IF(BE151<Description!$C$8+'Operating results'!$E$6,1,0)","v":0}]
[null,"green: Discount factor",{"$f":"(1+$C$7)^(-C$151+2016)*C154","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(1+$C$7)^(-AI$151+2016)*AI154","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Conventional investment"]
[null,"Operating results"]
[null,"Operating revenue",{"$f":"C126*C153","v":0},{"$f":"D126*D153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operating cost",{"$f":"C127*C153","v":0},{"$f":"D127*D153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Financial flows"]
[null,"Inflows",{"$f":"C140*C153","v":0},{"$f":"D140*D153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Capital cost",{"$f":"C141*C153","v":0},{"$f":"D141*D153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Social costs of emissions",{"$f":"C98*C153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI98*AI153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Social costs of waste treatment",{"$f":"C115*C153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI115*AI153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Implementation: social costs of emissions",{"$f":"D106*C153","v":0}]
[null,"Implementation: social costs of waste treatment",{"$f":"D119*C153","v":0}]
[null,"Social costs of indirect emissions",{"$f":"C153*C102","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI153*AI102","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Green investment"]
[null,"Operating results"]
[null,"Operating revenue",{"$f":"C131*C155","v":0},{"$f":"D131*D155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operating cost",{"$f":"C132*C155","v":0},{"$f":"D132*D155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Financial flows"]
[null,"Inflows",{"$f":"C145*C155","v":0},{"$f":"D145*D155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Capital cost",{"$f":"C146*C155","v":0},{"$f":"D146*D155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Social costs of emissions",{"$f":"C99*C155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI99*AI155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Social costs of waste treatment",{"$f":"C116*C155","v":0},{"$f":"D116*D155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Implementation: social costs of emissions",{"$f":"D107*C155","v":0}]
[null,"Implementation: social costs of waste treatment",{"$f":"D120*C155","v":0}]
[null,"Social costs of indirect emissions",{"$f":"C155*C103","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI155*AI103","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"VBA","index":15,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,"Zelleninhalte löschen"]
[null,null,null,null,"Range gibt dabei die Zellen an"]
[null,null,null,null,"Option Explicit\n\nSub Zellinhalte_löschen()\nRange(\"b46,C15,c16,c26,d26,c30,c31,c36,d36,e36,f36,c37,d37,e37,f37,d41:d43,d30:d31,g48,g47,c61,c62\").ClearContents\nEnd Sub"]
[]
[]
[null,null,null,null,"Scroll Area beschränken"]
[]
[null,null,null,null,"VBA starten, oben links die Tabelle auswählen und dann Zeile 1 bis X eingeben wie folgt: 1:X"]