{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["README","Explanatory notes","Input data","Heat price","Results","Interpretation"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":286,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["This excel-tool is a translation based on the Wirtschaflichkeitsrechnung tool - profitability calculation tool - developed by the Austrian \"klimaaktiv QM Heizwerke\" program."]
["The translation was carried out within the European project ENhancing renewable heaT planning for improving the aiR quAlity of commuNities (ENTRAIN)."]
[]
[]
["Please contact Sabrina Metz at s.metz@aee.at for any suggestion or bug-report of this tool."]
[]
["\"klimaaktiv QM Heizwerke\" is a quality management program throughout Austria in order to improve the technical quality and efficiency of biomass heating plants and district heating grids. This is achieved by accompanying quality control during the planning, construction and operation phase. For consulting and further information see www.klimaaktiv.at/qmheizwerke "]
[]
["\"klimaaktiv QM Heizwerke\" is supported by the Austrian Federal Ministry for Climate Protection, Environment, Energy, Mobility, Innovation and Technology (BMK)."]

{"sheet":"Explanatory notes","index":1,"n_rows":140,"n_cols":2,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[null,"Explanatory notes"]
[null,"Basic information of this tool:\nDisclaimer\nThis Excel-tool was created very carefully. Nevertheless, the authors cannot guarantee nor warrant the results and conclusions derived from them. The simplifications may result in certain \"errors\" due to the type of calculation, e.g. it is not taken into account whether a payment is made at the beginning or end of a year since a year is regarded as one period.\n! Attention: Even if warning feedbacks regarding various input limits are issued by the tool, it cannot be ruled out that incorrect input values may lead to an inaccurate representation of the final results. The correct assessment of the consequences of certain assumptions is the responsibility of the user of the tool.\n\nCalculation process: \nBased on the actual annual heat demand, the annual efficiency rates of the network and the boiler plants, the necessary fuel consumption and the associated annual costs are calculated. \n\nFormulas:\nAll formulas and calculations are shown in this tool. Please note that changes to the tool may result in errors and thus to incorrect results.\n\nSensitivity analysis / What-if calculation:\nBy varying the input parameters and storing the individual results of the profitability assessment, it is possible to evaluate the influence of individual parameters on the positive economic development of the heating plant."]
[null,"The presentation in the results table is made at the end of the respective period of the year; developments during the year are not taken into account. The column present value (reference year 0) is discounted to the start of the project = BEFORE period 1. The net present value is obtained in the same way. "]
[100,"All € - amounts must be indicated without value-added tax (VAT). Input fields are highlighted in light yellow. "]
[101,"Warnings: A short explanatory text appears in the Warnings field if implausible values are introduced in the input sheet (e.g. efficiency = zero or similar)."]
[102,"Enter values for the heat sale, the heat price and heat consumption. These and subsidiues/connection fees are essential income components of a biomass heating plant."]
[103,"Total planned heat sale in MWh /a at the end of the project (current enlargemend phase) This corresponds to a heat sale development of 100% [107]. The fuel consumption is calculated based on the annual efficiency of the district heating network and the annual efficiency of the boiler."]
[104,"Internal heat consumption. I.e. amount of heat taken from the pressureless manifold and not sold, e.g. heat for the heating control room, deicing ramp, etc."]
[105,"Annual efficiency of the biomass boiler(s). The ratio between the amount of heat generated and the amount of fuel heat used. Does NOT correspond to the achievable instantaneous efficiency of the boiler! Excessively optimistic assumptions lead to significantly lower fuel consumption and thus to the assumption that fuel costs are too low."]
[106,"Annual efficiency of the district heating network (40 ... 98%). The ratio of  the heat sold (delivered) from the grid to the  heat fed into the grid. It Does NOT correspond to the instantaneous efficiency of the district heating network at the design operation point! "]
[107,"Development of heat sale in % of the total annual heat sale defined in [103] This information can be used to consider network enlargements that will take place in several stages over the first 3 years. In year no. 3 100% must be reached!"]
[108,"Annual increase of the district heating network’s heat sale after the 3rd year. Through consistent network enlargement/densification (connection of additional customers), the heat consumption  can exceed 100 % in relation to the value originally taken into account for the third year. Any necessary investments that occur should be entered under \"Additional disbursements \" in the \"Results\" sheet in the years in which they occur."]
[109,"Net heat sales price. It can be calculated in the sheet \"Heat price\" from a basic charge, meter charge, energy charge and graduation of prices based on yearly heat consumption ."]
[110,"Average annual price adjustment of the heat sales price in percent: If linked to a standard consumer price index, rates of between 1 % and 3 % are to be expected. (This should not be higher than the adjustment values for electricity, fuel or personnel costs ). "]
[111,"Connection fees, if the heat transfer station is owned by the network operator and not the consumer. One-time fees paid  by heat customers for the installation of connections (piping + heat transfer stations). These lead to positive current income, but at the same time, investment costs for the district heating transfer station have the be considered .  The value corresponds to a heating network’s heat consumption factor of 100%.  "]
[112,"Other Incomes (e.g. fuel sales from heating plant, etc.)."]
[113,"Average annual price adjustment for other incomes (e.g. consumer price index)."]
[114,"Base year for the investments - used as year no. 0 for the profitability assessment "]
[120,"Fuel price and operating costs, significant expenditure positions for a biomass heating plant."]
[121,"Biomass price in € per MWh energy content. "]
[122,"Percentage of heat sale produced with biomass. 100% stands for biomass only, 90% if 10% of the annual heat demand is produced with fossil fuels."]
[123,"Average annual price adjustment for the biomass fuel. In any case, an increase between the consumer price index and the assumed price increases for fossil fuels should be included in the calculation."]
[124,"Price of fossil fuels (e.g. heating oil or natural gas) used. If a non-fossil fuel is used to cover peak loads, it must be included here."]
[125,"Average annual price adjustment of fossil fuel in per cent  . (check out the assessments on the expected fuel price development of your national energy agency)"]
[126,"Specific electricity consumption in kWh electric per MWh heat sale. This value should include all main electrical  components of the heating plant (boilers, pumps, network pumps, fan, electric precipitator, ...). "]
[127,"Electricity price in € per kWhel of the power supply company"]
[128,"Average annual price adjustment of the electricity price as annual percentage"]
[130,"Personnel costs for the operation and management of the heating plant and network in euros per year."]
[131,"Average annual price adjustment of personnel expenses."]
[132,"Annual costs for accounting and (tax) consulting."]
[133,"Average annual price adjustment for accounting and consulting."]
[134,"Annual maintenance costs."]
[135,"Average annual price adjustment for maintenance."]
[136,"Annual costs for rent or leasehold or the property."]
[137,"Average annual price adjustment for rent/lease/property."]
[138,"Other annual costs (insurance, homepage, telephone, public fees, ... etc.)"]
[139,"Average annual price adjustment for \"other costs\"."]
[140,"Upper limit of the annual heat sale increase. This value is used to limit the growth of heat sale using the third year as a reference. The maximum increase should be limited considering local constraints so that the heat sales after the four year does not grow unlimited.E.g. if the max. posible heat sale in the area (e.g. assuming all buildings connected to the network) is 110% of the defined heat sale, this factor should be set to 10% (or lower)."]
[150,"Investment costs of the heating plant."]
[151,"Consider here only investment costs eligible for subsidies according to your national funding scheme"]
[152,"Investment costs of the district heating network."]
[153,"Construction costs for the boiler house and wood chip storage."]
[154,"Costs for the planning of the heating plant and the district heating network and (if applicable) implementation of a quality management program (e.g. qm heizwerke). "]
[155,"Costs non-eligible for subsidies (vehicles, etc.) - according to your national funding scheme"]
[156,"Total investment costs, calculated from eligible and non-eligible costs. The amount that the client (plant owner) initially has to spend to build the heating plant and district heating grid."]
[160,"Available own funds for the project, external financing share, subsidies and subsidy rate. It is recommended to achieve a minimum equity ratio of 10-30% if possible. The higher the equity ratio, the lower the ongoing burden on liquidity from loan interest rates and loan repayments."]
[161,"Equity contributed to the company by owner/shareholders."]
[162,"Loan period, in this calculation constant rates are assumed over the entire loan period. The loan period should be agreed with the bank as long as possible (ideally 20, 25 years), and the possibility of early free repayment should be included in the loan agreement. Thus, the agreed repayment remains as low as possible, but in the case of higher revenues, the operator can pay in advance and therefore repay the loan more quickly."]
[163,"Average gross loan interest rate for the entire loan period (e.g. reference interest rate (Euribor) + surcharge + additional costs)."]
[164,"Assumed subsidy rate as a percentage of eligible costs. Eligible investment costs, multiplied with subisidy rate results in the the total sum of subsidies granted."]
[165,"Year in which the subsidy is disbursed. Choose according to your national funding scheme. It is recommended to include year 2 at the earliest, since additional interest has to be paid for the borrowed capital required in the meantime due to a delayed payment."]
[166,"Check box for ongoing subsidy, which is paid out per year. Click to un/activate. If activated (check mark visible), the subsidy is considered. The subsidy is entered in the column 'Additional income / additional subsidy'. The method of calculation: base amount + increase amount + percentage increase should make it possible to map individual subsidy models with this information."]
[167,"Ongoing subsidy: Amount in 1st year."]
[168,"Ongoing subsidy: Annual increase of the amount"]
[169,"Ongoing subsidy: Annual percentage of increase of the amount"]
[170,"Net present value calculation - this calculation of profitability is based on a dynamic method of investment calculation. The net present value of an investment is the sum of the present values of all payments (payments and collections) caused by this investment. The prerequisite, however, is that accumulated surpluses are created immediately at the costing interest rate. (Also net present value method)"]
[171,"Calculated interest rate that is used to calculate the net present value. In the case of debt financing, at least close to the highest average interest rate on debt capital."]
[180,"Calculated values: Numerical values that can be calculated from the above inputs and serve to control the input and display of the calculation of energy quantities."]
[181,"Share of  heat sale in precent that is generated with fossil fuels."]
[182,"The amount of heat generated is calculated from the heat sale, the network utilisation rate and the self consumptionm of the heating plant."]
[183,"The amount of fuel heat used to generate the heat is calculated from the heat generated using the annual utilisation factor of the boiler."]
[184,"The biomass fuel heat used corresponds to the amount of heat generated with biomass. The remainder is generated with fossil or other energy sources."]
[185,"The fossil fuel heat used corresponds to the amount of heat generated with fossil fuel. The remaining part is generated with biomass."]
[186,"Electricity consumption of the heating plant in year no. 1 - Calculated from the specific electricity consumption per MWh of heat sold and the amount of heat sold in MWh."]
[190,"Total investment costs for heating plant, heating network and additional required investments."]
[191,"Costs eligible for subsidies. Total amount of investment costs eligible for subsides. These are calculated using positions 151 - 155.  "]
[192,"Subsidies are calculated from the eligible costs and the subsidy rate"]
[193,"Maximum loan that must be financed with debt capital (before disbursement of investment subsidies in years 1-5, value at cell position 165).  "]
[194,"Loan that must be financed long-term with debt capital (after payment of the amount of the investment subsidies)."]
[195,"Interest on loans in the first year."]
[196,"Annuity: Annual payment to repay the loan within the loan period including interest."]
[197,"Intermetiade financing if investments (temporary annuity) until  disbursement of the investment subsidy. This annuity is relatively high, since it has to be financed with debt capital and the respective interest rate. Notice that investment subsidies are usually paid out in years 1-3 after the realization of the investments. "]
[null,"Additional sheet Heat price:                                                                                                                                                                            This sheet is used to calculate the average heat sales price in differend ways. It can be calculated from the base price, measurement price and fuel price for three different consumer types. Furthermore, the calculation of a heat price graduation based on heat demand/customer size is possible. Alternatively, the heat price can be indicated directly. The result is displayed in grey on the \"Input\" page next to the \"Heat sales price\" input field."]
[401,"Check box. Click on the box to de/activate it; If activated (check mark visible), Calculation from basic charge, meter charge and energy charge is used. Depending on the weighting of the heat consumers, a weighted, averaged heat price is calculated from small, medium and large consumers, each with their own basic, meter and energy charges."]
[402,"Check box. Click on the box to de/activate it; If activated (check mark visible), Heat price based on graduation is used: With higher quantities of heat demand, the heat sales price per MWh decreases."]
[403,"Determined heat price, if nothing is checked in 401, then the value is directly taken from 414. If the calculation is based on the basic charge, the meter charge and the energy charge, a weighted heat price with the correct factors per MWh is calculated. If, in addition, graduation of price is selected (pos. 402), the price is reduced by the price discounts and weighted according to heat quantity."]
[404,"Calculation from basic charge, meter charge and energy charge. With this calculation sheet different calculations of the heat price can be made. The calculated heat price is displayed in the \"Input\" worksheet as a comparison to the input value for the economic profitability assessment."]
[405,"Customer type 1 - corresponds to private or small customers with very low heat consumption and installed capacity requirements, e.g. single-family houses, individual apartments, small office buildings, etc."]
[406,"Basic charge in € per kW of installed heat transfer capacity; to calculate without a basic charge, this field must be set to zero. Usually, the basic charge per kW of installed power decreases with increasing with increasing capacity of the connection."]
[407,"Meter charge - Price in € per year. "]
[408,"Energy charge in € per kWh of heat sold"]
[409,"Average installed heat capacity of the individual consumer type (1-3). This must be determined correctly as an average over all customers belonging to the type of customer so that the resulting heat price calculation delivers a correct result."]
[410,"Average heat consumption of each type of consumer (1-3). This must be determined correctly as an average over all customers belonging to the type of customer so that the resulting heat price calculation delivers a correct result."]
[411,"Determined heat price per customer type 1-3. For larger consumers, the proportion of fixed costs for the basic charge and the meter charge is reduced, whereby a lower heat price per kWh is to be invoiced."]
[412,"Customer type 2 - corresponds to customers with medium heat consumption and average installed capacity requirements, e.g. commercial enterprises, larger office buildings, etc."]
[413,"Customer type 3 - corresponds to customers with large heat demand and high installed capacity requirements, such as industrial plants, process heat customers, large residential buildings, ..."]
[414,"Direct input value for the average heat price across all consumers and the total amount of heat sold. The calculation can deviate from the scheme presented here, e.g. different individual prices can be used by weighting with the quantity of heat purchased."]
[415,"Graduation of prices for larger customers: By varying the limits \"from kWh/a\" and \"to kWh/a\", limits can be defined above which discounts on the heat price are granted. Notice that the discount is granted to customers-cluster, i.e. the customer types 1 to 3, and not the individual customers.  "]
[416,"Discount level 1 - Enter the value \"up to kWh/a\" and the price graduation (decrease) in percent. Here the price discount should always be 100%. All data between 0 and the upper limit for the discount levels are multiplied by the percentage factor. The next discount level starts 1kWh above the previous level."]
[417,"Discount level 2 - Enter the value \"up to kWh/a\" and the price graduation (degrease) in percent. The lower limit is taken from discount level 1. All data between the lower limit and the upper limit for the discount levels are multiplied by the percentage factor. The next  discount level starts 1kWh above the previous level."]
[418,"Discount level 3 - Enter the value \"up to kWh/a\" and the price graduation (degrease) in percent. The lower limit is taken from discount level 2. All data between the lower limit and the upper limit for the discount levels are multiplied by the percentage factor.The next  discount level starts 1kWh above the previous level."]
[419,"Discount level 4 - Enter the value \"up to kWh/a\" and the  price graduation (degrease) in percent. The lower limit is taken from discount level 3. All data between the lower limit and the upper limit for the discount levels are multiplied by the percentage factor. The next  discount level starts 1kWh above the previous level."]
[420,"Discount level 5 - Enter the value \"up to kWh/a\" and the  price graduation (degrease) in percent. Upper limit is assumed to be infinite. All data between the lower limit and the upper limit for the discount levels are multiplied by the percentage factor. The next higher discount level starts 1kWh above the next lower level."]
[500,"Sheet \"Interpretation\" allows  to comment/explanation  the results of the current economic profitability assessment and the introduced data so that it is possible to add additional information to the input values and calculated results, as well as the graphic representations are possible."]
[900,"\"Results\" sheet: Summary of the simplified financial development of the project within 25 years. The sections operating costs and revenues refer to the operating year 1 and 100% connected capacity (which is usually not yet achieved!). These should help to estimate the expected costs and revenues better. The procedures of dynamic investment calculation take into account the accrual (time of payment) of individual revenues and expenses. The sooner an expense takes place, the worse it is. Revenues are worse the later they take place."]
[901,"Summary of operating costs (including its price development trend) for the reference year"]
[905,"Revenues: All revenues of the heating plant related to operating year 1 and 100% connected capacity. The indicated price adjustemend index is a weighted mixed index from all revenues."]
[910,"The Net Present Values are calculated for the periods 1-10, 1-15, 1-20, 1-25. In any case, the NPV  should be positive and should at least not deteriorate over longer periods. Projects with larger investment sums are not directly comparable with projects with smaller investment sums."]
[920,"Concerning the calculation of Net Present Value (NPV), \"revenues\" must be compared with \"expenses\" of the individual periods."]
[930,"Year - the periodisation of this calculation tool is 1 period = 1 operating year."]
[931,"Heat sale development - The development of the district heating system in relation to the quantity of heat sold assuming a factor of 100% as targed value (see pos. 103).   "]
[932,"Payments for biomass fuel."]
[933,"Payments for fossil fuel."]
[934,"Payments for personnel costs, bookkeeping and consulting."]
[935,"Payments for electricity."]
[936,"Payments for maintenance."]
[null,"Additional disbursements. Column for free entry. Here other expenditures can be taken into account, e.g. expected reinvestment costs, additional investments for enlargements occurring at a later date and investments due to DH network densification from year no. 4 onwards."]
[937,"Payments for land rent or lease and other costs (e.g. insurance, homepage, telephone, public costs, ...)"]
[938,"Payments for investments - loan interest and account redemption. The investment from equity is also booked in this column in the first year. If there is an investment subsidy, then the interest expense for the subsidy amount must be paid additionally until the public funding is paid out (entry: Year of subsidy payment, see sheet “input”).    "]
[939,"Total annual disbursements, i.e. \"operating costs\". Sum of columns 2 - 9  ."]
[940,"Inpayments - Revenue from heat sales."]
[941,"Inpayments - Payment of connection fees and subsidies. "]
[942,"Inpayments - Deposits - Additional revenues/current subsidy - column for free entry. If you enter the amounts for current subsidy freely, the formulas are overwritten irrevocably. You should first save the Excel workbook under a different file name."]
[943,"Inpayments - Other revenues - Revenue from other sources such as fuel sales, etc."]
[944,"Total revenue - Sum of columns 11 - 1 4."]
[945,"Payment surplus/deficit - economic result of the heating plant operation in the current period."]
[946,"Present value of the payment surplus/deficit. Amount of the future payment surplus/deficit discounted to year 0. "]
[947,"Cumulative payment surplus - sum of payment surpluses/deficits of previous years. If this amount is negative, the company requires additional capital (through deposits, current account, etc.)."]
[948,"Loan balance (informative) - pure net calculation of the loan balance, without costs for bank charges, establishment etc. It is used to specify an order of magnitude. The loan status takes into account the year  of the subsidy disbursement, until then the interest on the loan amount has to be paid additionally. "]
[949,"Subsidy (informative) - Amount of public funding and when it will be disbursed (years 1-5)"]
[980,"Diagram of the economic development over the periods 1-25. "]
[981,"Diagram of the Net Present Value (NPV) for the periods 1-10, 1-15, 1-20 and 1-25. "]
[]
[null,"Units"]
[null,"MWh = Megawatt hour thermal"]
[null,"kWh = Kilowatt hour thermal"]
[null,"a = Year (anno)"]
[null,"€ = Euro "]
[null,"% = Percent"]
[null,"MWhel = Megawatt hour electric"]
[null,"kWhel = Kilowatt hour electric"]
[]
[null,"Abbreviations"]
[null,"cur. = Current"]
[null,"DH = District heating"]
[null,"DHN = District heating network"]
[null,"NPV = Net Present Value"]
[null,"PY = Previous year"]
[null,"sur.= Surplus"]
[null,"VAT = Value-added tax"]

{"sheet":"Input data","index":2,"n_rows":105,"n_cols":36,"rows_kept":105,"cut":false,"hidden":false,"merged":[[90,13,90,15],[104,13,104,15],[103,13,103,15],[74,13,74,15],[102,13,102,15],[76,13,76,15],[94,13,94,15],[97,13,97,15],[99,13,99,15],[101,13,101,15],[98,13,98,15],[100,13,100,15],[93,13,93,15],[91,13,91,15],[96,13,96,15],[92,13,92,15],[80,13,80,15],[81,13,81,15],[89,13,89,15],[56,13,56,15],[65,13,65,15],[62,13,62,15],[63,13,63,15],[84,13,84,15],[78,13,78,15],[79,13,79,15],[70,13,70,15],[61,13,61,15],[75,13,75,15],[71,13,71,15],[69,13,69,15],[64,13,64,15],[7,1,7,3],[18,13,18,15],[22,13,22,15],[7,4,7,22],[13,13,13,15],[16,13,16,15],[14,13,14,15],[17,13,17,15],[19,13,19,15],[20,13,20,15],[3,5,3,22],[11,13,11,15],[12,13,12,15],[22,18,22,19],[25,13,25,15],[23,13,23,15],[22,8,22,12],[27,13,27,15],[28,13,28,15],[30,13,30,15],[50,13,50,15],[49,13,49,15],[41,13,41,15],[38,13,38,15],[34,13,34,15],[35,13,35,15],[36,13,36,15],[53,13,53,15],[40,13,40,15],[37,13,37,15],[42,13,42,15],[60,13,60,15],[52,13,52,15],[55,13,55,15],[45,13,45,15],[47,13,47,15],[46,13,46,15],[48,13,48,15]]}
[null,"Economic Profitability Calculation - Input data"]
[]
[]
[null,"Project title:",null,null,null,"Example project"]
[]
[100,"(excl. VAT)",null,null,null,"Input cell"]
[]
[101,"Warnings:",null,null,{"$f":"IF(AD8>10,\"Mehr als 10 Warnungen oder Fehler!\",IF(AD8>0,AE8,\"\"))","v":""},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":"SUM(AB11:AD131)","v":0},{"$f":"AE11&AE27&AE34&AE45&AE60&AE69&AE74","v":""}]
[]
[102,"Quantity of heat, heat price and connection fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min","Max","Undercut","Surpass","S. Error","Warning","SumSp","MinText","MaxText","OtherText"]
[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,null,null,null,{"$f":"AE12&AE13&AE14&AE17&AE18&AE19&AE23&AE26&AE15&AE20&AE24&AE21","v":""},"x"]
[103,null,null,null,null,null,null,null,null,null,null,null,"Annual heat sale",7750,null,null,"MWh/a",null,null,null,null,null,null,null,null,10,9999999999,{"$f":"IF($N12<Z12,1,0)","v":0},{"$f":"IF($N12>AA12,1,0)","v":0},0,{"$f":"IF(AB12=1,AG12,IF(AC12=1,AH12,IF(AD12=1,AI12,\"\")))","v":""},null,"The amont of heat sold is too small! ","The amont of heat sold is too large!"]
[104,null,null,null,null,null,null,null,null,null,null,null,"Internal heat consumption",0,null,null,"MWh/a",null,null,null,null,null,null,null,null,0,9999999999,{"$f":"IF($N13<Z13,1,0)","v":0},{"$f":"IF($N13>AA13,1,0)","v":0},{"$f":"IF(InternalHeatCons>HeatQuantitySold,1,0)","v":0},{"$f":"IF(AB13=1,AG13,IF(AC13=1,AH13,IF(AD13=1,AI13,\"\")))","v":""},null,"The internal heat consumption is negativ!","The internal heat consumption is too large!","The internal heat consumption is greater than the amount of heat sold!"]
[105,null,null,null,null,null,null,null,null,null,null,null,"Annual efficiency of the biomass boiler(s)",85,null,null,"%",null,null,null,null," ",null,null,null,40,98,{"$f":"IF($N14<Z14,1,0)","v":0},{"$f":"IF($N14>AA14,1,0)","v":0},{"$f":"IF(InternalHeatCons>HeatQuantitySold,1,0)","v":0},{"$f":"IF(AB14>0,AG14,\"\")&IF(AC14>0,AH14,\"\")&IF(AD14>0,AI14,\"\")","v":""},null,"The annual utilisation rate of the biomass boiler(s) is below 40 %.","The annual utilisation rate of the biomass boiler(s) is over 98 %."]
[106,null,null,null,null,null,null,null,null,null,null,null,"Annual efficiency of the District Heating Network (DHN)",70,null,null,"%",null,null,null,null,null,null,null,null,40,99,{"$f":"IF($N15<Z15,1,0)","v":0},{"$f":"IF($N15>AA15,1,0)","v":0},{"$f":"IF(N15=\"\",1,0)","v":0},{"$f":"IF(AB15>0,AG15,\"\")&IF(AC15>0,AH15,\"\")&IF(AD15>0,AI15,\"\")","v":""},null,"The annual utilisation rate of the district heating network is too low!","The annual utilisation rate of the district heating network is too large!","Kein Jahresnutzungsgrad Netz angegeben! "]
[]
[107,null,null,null,null,null,null,null,null,null,null,null,"Development of heat sale - year 1",60,null,null,"% of total annual heat sale",null,null,null,null,null,null,null,null,0,100,{"$f":"IF($N17<Z17,1,0)","v":0},{"$f":"IF($N17>AA17,1,0)","v":0},{"$f":"IF(N17=\"\",1,0)","v":0},{"$f":"IF(AB17>0,AG17,\"\")&IF(AC17>0,AH17,\"\")&IF(AD17>0,AI17,\"\")","v":""},null,"The heat sale of the first year is too low"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Development of heat sale - year 2",80,null,null,"% of total annual heat sale",null,null,null,null,null,null,null,null,1,100,{"$f":"IF($N18<Z18,1,0)","v":0},{"$f":"IF($N18>AA18,1,0)","v":0},{"$f":"IF(ConsFactor_y2<ConsFactor_y1,1,0)","v":0},{"$f":"IF(AB18>0,AG18,\"\")&IF(AC18>0,AH18,\"\")&IF(AD18>0,AI18,\"\")","v":""},null,"The heat sale of the second year is too low","The heat consumption factor of the second year is too large","The heat consumption factor of the second year is smaller than in the first year."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Development of heat sale - year 3",100,null,null,"% of total annual heat sale",null,null,null,null,null,null,null,null,2,100,{"$f":"IF($N19<Z19,1,0)","v":0},{"$f":"IF($N19>AA19,1,0)","v":0},{"$f":"IF(ConsFactor_y3<ConsFactor_y2,1,0)","v":0},{"$f":"IF(AB19>0,AG19,\"\")&IF(AC19>0,AH19,\"\")&IF(AD19>0,AI19,\"\")","v":""},null,"The heat sale development of the third year is too low","The heat sale development of  year 3 is too high","The heat consumption factor of the third year is smaller than in the second year."]
[108,null,null,null,null,null,null,null,null,null,null,null,"Annual increase of the heat sale from year 4 onwards",0,null,null,"%",null,null,null,null,null,null,null,null,0,5,{"$f":"IF($N20<Z20,1,0)","v":0},{"$f":"IF($N20>AA20,1,0)","v":0},{"$f":"IF(ConsFactor_y4onwards=\"\",1,0)","v":0},{"$f":"IF(AB20>0,AG20,\"\")&IF(AC20>0,AH20,\"\")&IF(AD20>0,AI20,\"\")","v":""},null,"The increase of the heat sale of  year 4 and onwards is negativ!","The annual increase of the heat sale from year 4 onwards is too high!","The increase of the heat consumption factor of the 4 year onwards is not defined."]
[140,null,null,null,null,null,null,null,null,null,null,null,"Upper limit of the annual heat sale increase ",16,null,null,"%",null,null,null,null,null,null,null,null,0,100,{"$f":"IF($N21<Z21,1,0)","v":0},{"$f":"IF($N21>AA21,1,0)","v":0},{"$f":"IF(ConsFactorMax=\"\",1,0)","v":0},{"$f":"IF(AB21>0,AG21,\"\")&IF(AC21>0,AH21,\"\")&IF(AD21>0,AI21,\"\")","v":""},null,"The upper limit of the heat heat sale increase (see pos 140) is negativ. ","The upper limit of the heat consumption factor (see pos 140) is too high","The upper limit of the heat consumption factor (see pos 140) is not defined"]
[]
[109,null,null,null,null,null,null,null,"Net heat sales price",null,null,null,null,65,null,null,"€/MWh",null,{"$f":"DeterminedHeatPrice","v":57.210454545454553},null,"€/MWh",null,null,null,null,0,1000,{"$f":"IF($N23<Z23,1,0)","v":0},{"$f":"IF($N23>AA23,1,0)","v":0},{"$f":"IF(HeatSalesPrice<0,1,0)","v":0},{"$f":"IF(AB23>0,AG23,\"\")&IF(AC23>0,AH23,\"\")&IF(AD23>0,AI23,\"\")","v":""},null,"The net heat sales price is very low.","The net heat sales price is too high","The net heat sales price is negativ!","The net heat sales price is negativ!"]
[110,null,null,null,null,null,null,null,null,null,null,null,"Annual  adjustment of the heat sales price",2.5,null,0.5,"%",null,null,null,null,null,null,null,null,0,10,{"$f":"IF($N24<Z24,1,0)","v":0},{"$f":"IF($N24>AA24,1,0)","v":0},0,{"$f":"IF(AB24>0,AG24,\"\")&IF(AC24>0,AH24,\"\")&IF(AD24>0,AI24,\"\")","v":""},null,"The annual adjustment of the heat sales price is assumed to be lower than 10%. ","The price adjustment of the heat sales price is too high"]
[]
[111,null,null,null,null,null,null,null,null,null,null,null,"Connection fees (Building costs subsidy) Year 1-3",350000,null,null,"€",null,null,null,null,null,null,null,null,0,{"$f":"TotalInvestment","v":2355000},{"$f":"IF($N26<Z26,1,0)","v":0},{"$f":"IF($N26>AA26,1,0)","v":0},0,{"$f":"IF(AB26>0,AG26,\"\")&IF(AC26>0,AH26,\"\")&IF(AD26>0,AI26,\"\")","v":""},null,"The connection fees (Building costs subsidy) are negativ!","The connection fees (Building costs subsidy) exceed the total investment (compare pos. 111 with pos. 156) "]
[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,null,null,null,{"$f":"AE28&AE29&AE31","v":""},"x"]
[112,null,null,null,null,null,null,null,null,null,null,null,"Other yearly incomes",0,null,null,"€/a",null,null,null,null,null,null,null,null,0,9999999999,{"$f":"IF($N28<Z28,1,0)","v":0},{"$f":"IF($N28>AA28,1,0)","v":0},0,{"$f":"IF(AB28>0,AG28,\"\")&IF(AC28>0,AH28,\"\")&IF(AD28>0,AI28,\"\")","v":""},null,"The \"other yearly revenues\" are assumed to be negativ!","The \"other yearly revenues\" are too high!"]
[113,null,null,null,null,null,null,null,null,null,null,null,"Average price adjustment  of \"other yearly incomes\"",9.9,null,null,"%",null,null,null,null,null,null,null,null,0,10,{"$f":"IF($N29<Z29,1,0)","v":0},{"$f":"IF($N29>AA29,1,0)","v":0},0,{"$f":"IF(AB29>0,AG29,\"\")&IF(AC29>0,AH29,\"\")&IF(AD29>0,AI29,\"\")","v":""},null,"The price adjustment of the \"other yearly revenues\" is negativ!","Th eprice adjustment  of \"other yearly revenues\" is too high!"]
[]
[114,null,null,null,null,null,null,null,null,null,null,null,"Project start",2009,null,null,null,null,null,null,null,null,null,null,null,2000,2100,{"$f":"IF($N31<Z31,1,0)","v":0},{"$f":"IF($N31>AA31,1,0)","v":0},0,{"$f":"IF(AB31>0,AG31,\"\")&IF(AC31>0,AH31,\"\")&IF(AD31>0,AI31,\"\")","v":""},null,"The project start is assumed to be after the year 2000.","The project start is assumed to be before 2100"]
[]
[120,"Fuel price, Operating and Mainteinance costs"]
[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,null,null,null,{"$f":"AE35&AE36&AE37&AE38&AE39&AE41&AE42&AE43","v":""},"x"]
[121,null,null,null,null,null,null,null,null,null,null,null,"Biomass fuel price",26,null,null,"€/MWh",null,null,null,null,null,null,null,null,0,100,{"$f":"IF($N35<Z35,1,0)","v":0},{"$f":"IF($N35>AA35,1,0)","v":0},{"$f":"IF(BiomassFuelPrice<0,1,0)","v":0},{"$f":"IF(AB35>0,AG35,\"\")&IF(AC35>0,AH35,\"\")&IF(AD35>0,AI35,\"\")","v":""},null,"The biomass fuel price is assumed to be negativ.","The biomass fuel price is too high."]
[122,null,null,null,null,null,null,null,null,null,null,null,"Share of heat produced with biomass",95,null,95,"%",null,null,null,null,null,null,null,null,70,100,{"$f":"IF($N36<Z36,1,0)","v":0},{"$f":"IF($N36>AA36,1,0)","v":0},0,"",null,"The amount of heat produced with biomass is low.","The amount of heat produced with biomass is too high."]
[123,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of biomass fuel",2,null,null,"%/a",null,null,null,null,null,null,null,null,0,5,{"$f":"IF($N37<Z37,1,0)","v":0},{"$f":"IF($N37>AA37,1,0)","v":0},0,"",null,"The assumed price development for biomass fuel is negativ!","The assumed price development for biomass fuel is very high."]
[124,null,null,null,null,null,null,null,null,null,null,null,"Fossil fuel price",56,null,null,"€/MWh",null,null,null,null,null,null,null,null,30,300,{"$f":"IF($N38<Z38,1,0)","v":0},{"$f":"IF($N38>AA38,1,0)","v":0},{"$f":"IF(FossilFuelPrice<BiomassFuelPrice,1,0)","v":0},"",null,"The price of fossil fuel is too low. ","The assumed price of fossil fuel is high. ","The price of fossil fuel is lower than the price of biomass. "]
[125,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of  fossil fuels",5,null,null,"%/a",null,null,null,null,null,null,null,null,0,10,{"$f":"IF($N39<Z39,1,0)","v":0},{"$f":"IF($N39>AA39,1,0)","v":0},{"$f":"IF(FossilFuelPriceTrend<BiomassFuelPriceTrend,1,0)","v":0},"",null,"The price development of fossil fuel was assumed to be negative. ","The assumed price development of fossil fuel is high. ","The price development of fossil fuel is lower than for biomass."]
[]
[126,null,null,null,null,null,null,null,null,null,null,null,"Specific electricity consumption",10,null,null,"kWhel/MWhth",null,null,null,null,null,null,null,null,2,20,{"$f":"IF($N41<Z41,1,0)","v":0},{"$f":"IF($N41>AA41,1,0)","v":0},{"$f":"IF(SpecificElectCons=0,1,0)","v":0},"",null,"The specific electricity consumption was assumed to be very low. ","The specific electricity consumption was assumed to be very high.","The specific electricity consumption was set to zero."]
[127,null,null,null,null,null,null,null,null,null,null,null,"Electricity price",0.13,null,null,"€/kWhel",null,null,null,null,null,null,null,null,4.0000000000000001E-3,0.8,{"$f":"IF($N42<Z42,1,0)","v":0},{"$f":"IF($N42>AA42,1,0)","v":0},{"$f":"IF(ElectricityPrice=0,1,0)","v":0},"",null,"The electricity price was assumed to be very low. ","The electricity price was assumed to be very high. ","The electricity price is set to zero."]
[128,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of electricity",5,null,null,"%/a",null,null,null,null,null,null,null,null,1,10,{"$f":"IF($N43<Z43,1,0)","v":0},{"$f":"IF($N43>AA43,1,0)","v":0},0,"",null,"The price development of the electricity price was assumed to be very small.","The price development of the electricity price was assumed to be very high."]
[]
[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,null,null,null,{"$f":"AE46&AE47&AE48&AE49&AE50&AE52&AE53&AE54&AE56&AE57","v":""},"x"]
[130,null,null,null,null,null,null,null,null,null,null,null,"Personnel costs",15000,null,null,"€/a",null,null,null,null,null,null,null,null,0,999999,{"$f":"IF($N46<Z46,1,0)","v":0},{"$f":"IF($N46>AA46,1,0)","v":0},0,{"$f":"IF(AB46>0,AG46,\"\")&IF(AC46>0,AH46,\"\")&IF(AD46>0,AI46,\"\")","v":""},null,"The annual personnel expenses are very low.","The annual personnel expenses are too high."]
[131,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of personnel costs",2,null,null,"%",null,null,null,null,null,null,null,null,0,10,0,0,0,"",null,"The price development of personnel expenses was assumed to be very low.","The price development of personnel expenses was assumed to be very high."]
[132,null,null,null,null,null,null,null,null,null,null,null,"Accounting and (tax) consulting costs",0,null,null,"€/a",null,null,null,null,null,null,null,null,0,999999,0,0,0,"",null,"The annual accounting and consulting expenses are very low.","The annual accounting and consulting expenses are too high."]
[133,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of accounting and (tax) consulting",2,null,null,"%",null,null,null,null,null,null,null,null,0,10,0,0,0,"",null,"The price development of accounting and consulting services was assumed to be very low.","The price development of accounting and consulting services was assumed to be very high."]
[134,null,null,null,null,null,null,null,null,null,null,null,"Maintenance costs",9000,null,null,"€/a",null,null,null,null,null,null,null,null,0,999999,0,0,0,"",null,"The annual expenses for maintenance is very low.","The annual expenses for maintenance is too high."]
[135,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of maintenance costs",2,null,null,"%",null,null,null,null,null,null,null,null,0,10,0,0,0,"",null,"The price development for maintenance was assumed to be very low.","The price development for maintenance was assumed to be very high."]
[]
[136,null,null,null,null,null,null,null,null,null,null,null,"Cost fors rent / leasehold / land",3500,null,null,"€/a",null,null,null,null,null,null,null,null,0,{"$f":"TotalInvestment/20","v":117750},{"$f":"IF($N53<Z53,1,0)","v":0},{"$f":"IF($N53>AA53,1,0)","v":0},0,{"$f":"IF(AB53>0,AG53,\"\")&IF(AC53>0,AH53,\"\")&IF(AD53>0,AI53,\"\")","v":""},null,"The annual rent / leasehold / land costs were assumed to be very low. ","The annual  rent / leasehold / land costs are very high. "]
[137,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of rent / leasehold / land costs",2.5,null,null,"%",null,null,null,null,null,null,null,null,0,5,{"$f":"IF($N54<Z54,1,0)","v":0},{"$f":"IF($N54>AA54,1,0)","v":0},0,{"$f":"IF(AB54>0,AG54,\"\")&IF(AC54>0,AH54,\"\")&IF(AD54>0,AI54,\"\")","v":""},null,"The price trend for  rent / leasehold / land costs was assumed to be very low.","The price trend for  rent / leasehold / land costs was assumed to be very high."]
[]
[138,null,null,null,null,null,null,null,null,null,null,null,"Other costs (insurance, etc.)",1500,null,null,"€/a",null,null,null,null,null,null,null,null,1000,999999,{"$f":"IF($N56<Z56,1,0)","v":0},{"$f":"IF($N56>AA56,1,0)","v":0},{"$f":"IF(OtherCosts=0,1,0)","v":0},{"$f":"IF(AB56>0,AG56,\"\")&IF(AC56>0,AH56,\"\")&IF(AD56>0,AI56,\"\")","v":""},null,"The \"other costs\" are very low. ","The \"other costs\" are very high. ","The \"other costs\" were assumed to be zero. "]
[139,null,null,null,null,null,null,null,null,null,null,null,"Annual price adjustment of other costs",3,null,null,"%",null,null,null,null,null,null,null,null,0.5,5,{"$f":"IF($N57<Z57,1,0)","v":0},{"$f":"IF($N57>AA57,1,0)","v":0},0,{"$f":"IF(AB57>0,AG57,\"\")&IF(AC57>0,AH57,\"\")&IF(AD57>0,AI57,\"\")","v":""},null,"The price development for \"other costs\" was assumed to be very low.","The price development for \"other costs\" was assumed to be very high."]
[]
[150,"Investment costs"]
[151,null,null,null,null,null,null,null,null,null,null,null,"Costs eligible for subsidies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE61&AE62&AE63&AE64&AE65&AE66","v":""},"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Installation",520000,null,null,"€",null,null,null,null,null,null,null,null,10000,999999999,{"$f":"IF($N61<Z61,1,0)","v":0},{"$f":"IF($N61>AA61,1,0)","v":0},0,{"$f":"IF(AB61>0,AG61,\"\")&IF(AC61>0,AH61,\"\")&IF(AD61>0,AI61,\"\")","v":""},null,"The installation investment costs are very low.","The installation investment costs are too high."]
[152,null,null,null,null,null,null,null,null,null,null,null,"District heating network",1200000,null,null,"€",null,null,null,null,null,null,null,null,10000,999999999,0,0,0,{"$f":"IF(AB62>0,AG62,\"\")&IF(AC62>0,AH62,\"\")&IF(AD62>0,AI62,\"\")","v":""},null,"The costs for the district heating network are very low.","The costs for the district heating network are too high."]
[153,null,null,null,null,null,null,null,null,null,null,null,"Construction",450000,null,null,"€",null,null,null,null,null,null,null,null,10000,999999999,0,0,0,{"$f":"IF(AB63>0,AG63,\"\")&IF(AC63>0,AH63,\"\")&IF(AD63>0,AI63,\"\")","v":""},null,"The construction costs are very low.","The construction costs are very high. "]
[154,null,null,null,null,null,null,null,null,null,null,null,"Planning and quality management",120000,null,null,"€",null,null,null,null,null,null,null,null,1000,999999999,0,0,{"$f":"IF(PlanningQMCosts<TotalInvestment/50,1,0)","v":0},{"$f":"IF(AB64>0,AG64,\"\")&IF(AC64>0,AH64,\"\")&IF(AD64>0,AI64,\"\")","v":""},null,"The planning and QM-programm costs are very low.","The planning and QM-programm costs are very high. ","The planning and QM-programm costs are less than 2% of the investment costs. "]
[155,null,null,null,null,null,null,null,null,null,null,null,"Costs NON-eligible for subsidies",65000,null,null,"€",null,null,null,null,null,null,null,null,0,999999999,0,0,0,null,null,"The non-eligible costs for subsidies are negative.","The non-eligible costs for subsidies are very high. "]
[156,null,null,null,null,null,null,null,null,null,null,null,"Total investment",{"$f":"SUM(N61:P65)","v":2355000},null,null,"€",null,null,null,null,null,null,null,null,0,999999999,0,0,0]
[]
[160,"Equity, external financing, subsidy quota"]
[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,null,null,null,{"$f":"AE70&AE71&AE72","v":""},"x"]
[161,null,null,null,null,null,null,null,null,null,null,null,"Equity",300000,null,null,"€",null,null,null,null,null,null,null,null,0,{"$f":"TotalInvestment","v":2355000},{"$f":"IF($N70<=Z70,1,0)","v":0},{"$f":"IF($N70>AA70,1,0)","v":0},0,{"$f":"IF(AB70>0,AG70,\"\")&IF(AC70>0,AH70,\"\")&IF(AD70>0,AI70,\"\")","v":""},null,"The own funds (equity) is zero or negative.","The own capital contribution (equity) is higher than the total investment costs. "]
[162,null,null,null,null,null,null,null,null,null,null,null,"Loan period",20,null,null,"years",null,null,null,null,null,null,null,null,5,25,{"$f":"IF($N71<=Z71,1,0)","v":0},{"$f":"IF($N71>AA71,1,0)","v":0},0,{"$f":"IF(AB71>0,AG71,\"\")&IF(AC71>0,AH71,\"\")&IF(AD71>0,AI71,\"\")","v":""},null,"The loan period is too short","The loan period must not exceed 25 years! "]
[163,null,null,null,null,null,null,null,null,null,null,null,"Average gross loan interest",5.5,null,null,"%",null,null,null,null,null,null,null,null,3,10,{"$f":"IF($N72<=Z72,1,0)","v":0},{"$f":"IF($N72>AA72,1,0)","v":0},0,{"$f":"IF(AB72>0,AG72,\"\")&IF(AC72>0,AH72,\"\")&IF(AD72>0,AI72,\"\")","v":""},null,"The indicated loan interest rate is very low.","The loan interest rate is very high."]
[]
[null,"Subsidy",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,null,{"$f":"AE76&AE77&AE80&AE81&AE85","v":""},"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investment subsidy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[164,null,null,null,null,null,null,null,null,null,null,null,"Subsidy rate",30,null,null,"%",null,null,null,null,null,null,null,null,0,60,{"$f":"IF($N76<Z76,1,0)","v":0},{"$f":"IF($N76>AA76,1,0)","v":0},0,{"$f":"IF(AB76>0,AG76,\"\")&IF(AC76>0,AH76,\"\")&IF(AD76>0,AI76,\"\")","v":""},null,"The stated subsidy quote is too low.","The stated subsidy quote is too high."]
[165,null,null,null,null,null,null,null,null,null,null,null,"Year of the subsidy disbursment",5,null,null,"Year (1-5)",null,null,null,null,null,null,null,null,1,5,{"$f":"IF($N77<Z77,1,0)","v":0},{"$f":"IF($N77>AA77,1,0)","v":0},{"$f":"IF(SubsidyDisbursementYear=0,1,IF(SubsidyDisbursementYear/(INT(SubsidyDisbursementYear))<>1,1,0))","v":0},{"$f":"IF(AB77>0,AG77,\"\")&IF(AC77>0,AH77,\"\")&IF(AD77>0,AI77,\"\")","v":""},null,"The public funding amount may be disbursed in year 1 at the earliest!","The public funding amount may be disbursed in year 5 at the latest!","The year of the subsidy disbursement may only be set to a single specific year (year 1, 2, 3, 4 or 5, decimal points are not permitted)."]
[]
[166,null,null,null,null,null,null,null,null,null,null,null,"Ongoing subsisdy per year (e.g. climate cent)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[167,null,null,null,null,null,null,null,null,null,null,null,"Amount in 1st year",3500,null,null,"€",null,null,null,null,null,null,null,null,0,999999999,{"$f":"IF($N80<Z80,1,0)","v":0},{"$f":"IF($N80>AA80,1,0)","v":0},0,{"$f":"IF(AB80>0,AG80,\"\")&IF(AC80>0,AH80,\"\")&IF(AD80>0,AI80,\"\")","v":""},null,"The amount of the ongoing subsidy in year 1 is negativ. ","The amount of the ongoing subsidy in year 1 is too high. "]
[168,null,null,null,null,null,null,null,null,null,null,null,"Increase in the amount per year",1000,null,null,"€",null,null,null,null,null,null,null,null,0,999999999,{"$f":"IF($N81<Z81,1,0)","v":0},{"$f":"IF($N81>AA81,1,0)","v":0},0,{"$f":"IF(AB81>0,AG81,\"\")&IF(AC81>0,AH81,\"\")&IF(AD81>0,AI81,\"\")","v":""},null,"The yearly increase in the amount of public funding is negative.","The yearly increase in the amount of public funding is very high."]
[169,null,null,null,null,null,null,null,null,null,null,null,"Percentage increase in the amount per year",3,null,null,"%",null,null,null,null,null,null,null,null,0,10,{"$f":"IF($N82<Z82,1,0)","v":0},{"$f":"IF($N82>AA82,1,0)","v":0},0,{"$f":"IF(AB82>0,AG82,\"\")&IF(AC82>0,AH82,\"\")&IF(AD82>0,AI82,\"\")","v":""},null,"The percentage increase in the yearly increase of ongoing subsidy is negative.","The percentage increase in the yearly increase of ongoing subsidy is very high."]
[]
[170,"Net Present Value (NPV) calculation"]
[171,null,null,null,null,null,null,null,null,null,null,null,"Imputed interest rate",6,null,null,"%",null,null,null,null,null,null,null,null,2,10,{"$f":"IF($N85<Z85,1,0)","v":0},{"$f":"IF($N85>AA85,1,0)","v":0},{"$f":"IF(SubsidyDisbursementYear=0,1,IF(SubsidyDisbursementYear/(INT(SubsidyDisbursementYear))<>1,1,0))","v":0},{"$f":"IF(AB85>0,AG85,\"\")&IF(AC85>0,AH85,\"\")&IF(AD85>0,AI85,\"\")","v":""},null,"The assumed interest rate is very low.","The assumed interest rate is very high."]
[]
[]
[180,"Calculated values"]
[]
[181,null,null,null,null,null,null,null,null,null,null,null,"Percentage of heat produced with fossil fuels",{"$f":"100-ShareBiomass","v":5},null,95,"%"]
[182,null,null,null,null,null,null,null,null,null,null,null,"Produced heat",{"$f":"HeatQuantitySold/UtilisationRateDHN*100+N13","v":11071.428571428571},null,95,"MWh"]
[183,null,null,null,null,null,null,null,null,null,null,null,"Fuel heat used",{"$f":"N91/UtilisationRateBiomassBoiler*100","v":13025.210084033612},null,95,"MWh"]
[184,null,null,null,null,null,null,null,null,null,null,null,"Biomass fuel used",{"$f":"N92*ShareBiomass/100","v":12373.949579831929},null,95,"MWh"]
[185,null,null,null,null,null,null,null,null,null,null,null,"Fossil fuel used",{"$f":"N92*(ShareFossilFuels/100)","v":651.26050420168065},null,95,"MWh"]
[186,null,null,null,null,null,null,null,null,null,null,null,"Electricity costs",{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice","v":10075},null,null,"€"]
[]
[190,null,null,null,null,null,null,null,null,null,null,null,"Total investment costs",{"$f":"TotalInvestment","v":2355000},null,null,"€"]
[191,null,null,null,null,null,null,null,null,null,null,null,"Costs eligible for subsidies",{"$f":"N66-NonEligibleCosts","v":2290000},null,null,"€"]
[192,null,null,null,null,null,null,null,null,null,null,null,"Subsidies",{"$f":"IF(AG75,N98*SubsidyQuote/100,0)","v":687000},null,null,"€"]
[193,null,null,null,null,null,null,null,null,null,null,null,"Total (maximal) loan amount to be financed",{"$f":"N66-Equity","v":2055000},null,null,"€"]
[194,null,null,null,null,null,null,null,null,null,null,null,"Longterm loan amount to be financed (after subsidy disbursement)",{"$f":"LoanAmount-SubsidyAmount","v":1368000},null,null,"€"]
[]
[195,null,null,null,null,null,null,null,null,null,null,null,"Loan interest year 1 (subsidy)",{"$f":"N100*GrossLoanInterest/100","v":113025},null,null,"€"]
[196,null,null,null,null,null,null,null,null,null,null,null,"Annuity (annual repayment and loan interest)",{"$f":"-PMT(GrossLoanInterest/100,LoanPeriod,N101)","v":114473.3234877886},null,{"$f":"PMT(LoanAmount,GrossLoanInterest,LoanPeriod)","v":-41100000},"€"]
[197,null,null,null,null,null,null,null,null,null,null,null,"Annuity until subsidy disbursement",{"$f":"Annuity+SubsidyAmount*GrossLoanInterest/100","v":152258.32348778861},null,{"$f":"PMT(LoanAmount,GrossLoanInterest,LoanPeriod)","v":-41100000},"€"]

{"sheet":"Heat price","index":3,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[11,2,11,8],[2,3,2,8],[62,8,62,13],[15,3,15,4],[25,3,25,4],[35,3,35,4]]}
[null,"Economic Profitability Calculation - Heat price"]
[]
[null,"Project title:",null,{"$f":"IF('Input data'!F4<>\"\",'Input data'!F4,\"\")","v":"Example project"}]
[null,null,null,null,null,null,null,null,null,true]
[100,"(excl. VAT)",null,"Input cell",null,null,null,null,null,true]
[]
[401,"Option",null,"Calculation from basic, meter and energy charge",null,null,null,null,null,{"$f":"IF(J4,(G23*G16+G26*G33+G36*G43)/100*1000,G48)","v":61.863636363636367}]
[402,null,null,"Heat price graduation according to heat sale",null,null,null,null,null,{"$f":"IF(J5,(J60+K60+L60)/100*1000,0)","v":57.210454545454553}]
[]
[403,"Determined heat price:",null,null,{"$f":"IF(AND(J4,J5),J8,J7)","v":57.210454545454553},"€/MWh",null,{"$f":"E10/1000","v":5.721045454545455E-2},"€/kWh","Error","Warning"]
[]
[null,"Warnings:",{"$f":"IF(J12>0,K12,\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(J14:J43)","v":0},{"$f":"K14&K16&K17&K18&K19&K20&K21&K23&K26&K27&K28&K29&K30&K31&K33&K36&K37&K38&K39&K40&K41&K43&K7","v":""}]
[]
[404,"Calculation from basic, meter and energy charge",null,null,null,null,null,null,null,{"$f":"IF(G16+G26+G36>100,1,0)","v":0},{"$f":"IF(J14>0,L14,\"\")","v":""},"Sum of heat consumption of all consumers types is higher than 100%. Correct it! Check position 405, 412 & 413."]
[]
[405,"Customer type 1",null,"Private customer",null,null,15,"% of the heat sale",null,{"$f":"IF(G16+G26+G36<100,1,0)","v":0},{"$f":"IF(J16>0,L16,\"\")","v":""},"Sum of heat consumption of all consumers type is lower than 100%. Correct it! Check position 405, 412 & 413."]
[406,null,null,null,null,"Basic charge",60,"€/kW",null,null,{"$f":"IF(J17>0,L17,\"\")","v":""}]
[407,null,null,null,null,"Meter charge",60,"€/a",null,null,""]
[408,null,null,null,null,"Energy charge",4.4999999999999998E-2,"€/kWh",null,null,""]
[409,null,null,null,null,"Average installed capacity",14,"kW",null,{"$f":"IF(G20>G30,1,0)","v":0},"","Installed capacity (i.e. expected connected load) for private consumers is higher than for commercial consumers! "]
[410,null,null,null,null,"Average heat consumption",24000,"kWh",null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[411,null,null,null,null,"Determined heat price",{"$f":"(G17*G20+G18+G19*G21)/G21","v":8.2500000000000004E-2},"€/kWh",null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[412,"Customer type 2",null,"Commercial customer",null,null,25,"% of the heat sale",null,null,""]
[406,null,null,null,null,"Basic charge",50,"€/kW",null,null,""]
[407,null,null,null,null,"Meter charge",90,"€/a",null,null,""]
[408,null,null,null,null,"Energy charge",0.04,"€/kWh",null,null,""]
[409,null,null,null,null,"Average installed capacity",35,"kW",null,{"$f":"IF(G30>G40,1,0)","v":0},"","Installed capacity (i.e. expected connected load) of commercial customers is higher than for large-scale consumers! "]
[410,null,null,null,null,"Average heat consumption",55000,"kWh",null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[411,null,null,null,null,"Determined heat price",{"$f":"(G27*G30+G28+G29*G31)/G31","v":7.3454545454545453E-2},"€/kWh",null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[413,"Customer type 3",null,"Large-scale consumer",null,null,60,"% of the heat sale",null,null,""]
[406,null,null,null,null,"Basic charge",10,"€/kW",null,null,""]
[407,null,null,null,null,"Meter charge",250,"€/a",null,null,""]
[408,null,null,null,null,"Energy charge",0.03,"€/kWh",null,null,""]
[409,null,null,null,null,"Average installed capacity",500,"kW",null,null,""]
[410,null,null,null,null,"Average heat consumption",240000,"kWh",null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[411,null,null,null,null,"Determined heat price",{"$f":"(G37*G40+G38+G39*G41)/G41","v":5.1874999999999998E-2},"€/kWh",null,null,""]
[]
[]
[414,"Direct input of the heat price"]
[]
[414,null,null,null,null,"Average heat price",55,"€/MWh"]
[]
[415,"Graduation of price according to heat sale"]
[]
[]
[null,null,null,"Lower limit","Upper limit"]
[null,"Discount",null,"from kWh/a","to kWh/a",null,"graduation factor",null,null,"Price 1","Price 2","Price 3"]
[416,"Level 1",null,0,50000,"kWh/a",1,null,null,{"$f":"IF($G$21<$E55,$G$23*$G55*$G$16,0)","v":1.2375},{"$f":"IF($G$31<$E55,$G$33*$G55*$G$26,0)","v":0},{"$f":"IF($G$41<$E55,$G$43*$G55*$G$36,0)","v":0}]
[417,"Level 2",null,{"$f":"E55+1","v":50001},120000,"kWh/a",0.95,null,null,{"$f":"IF(J55>0,0,IF($G$21<$E56,$G$23*$G56*$G$16,0))","v":0},{"$f":"IF(K55>0,0,IF($G$31<$E56,$G$33*$G56*$G$26,0))","v":1.7445454545454546},{"$f":"IF(L55>0,0,IF($G$41<$E56,$G$43*$G56*$G$36,0))","v":0}]
[418,"Level 3",null,{"$f":"E56+1","v":120001},180000,"kWh/a",0.92,null,null,{"$f":"IF(J56+J55>0,0,IF($G$21<$E57,$G$23*$G57*$G$16,0))","v":0},{"$f":"IF(K55+K56>0,0,IF($G$31<$E57,$G$33*$G57*$G$26,0))","v":0},{"$f":"IF(L56+L55>0,0,IF($G$41<$E57,$G$43*$G57*$G$36,0))","v":0}]
[419,"Level 4",null,{"$f":"E57+1","v":180001},350000,"kWh/a",0.88,null,null,{"$f":"IF(J55+J56+J57>0,0,IF($G$21<$E58,$G$23*$G58*$G$16,0))","v":0},{"$f":"IF(K55+K56+K57>0,0,IF($G$31<$E58,$G$33*$G58*$G$26,0))","v":0},{"$f":"IF(L55+L56+L57>0,0,IF($G$41<$E58,$G$43*$G58*$G$36,0))","v":2.7389999999999999}]
[420,"Level 5",null,{"$f":"E58+1","v":350001},{"$f":"1E+99","v":9.9999999999999997E+98},"kWh/a",0.85,null,null,{"$f":"IF(J55+J56+J57+J58>0,0,IF($G$21<$E59,$G$23*$G59*$G$16,0))","v":0},{"$f":"IF(K55+K56+K57+K58>0,0,IF($G$31<$E59,$G$33*$G59*$G$26,0))","v":0},{"$f":"IF(L55+L56+L57+L58>0,0,IF($G$41<$E59,$G$43*$G59*$G$36,0))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J55:J59)","v":1.2375},{"$f":"SUM(K55:K59)","v":1.7445454545454546},{"$f":"SUM(L55:L59)","v":2.7389999999999999}]

{"sheet":"Results","index":4,"n_rows":89,"n_cols":23,"rows_kept":89,"cut":false,"hidden":false,"merged":[[19,3,19,11],[19,12,19,16],[2,3,2,8],[3,7,3,8],[4,7,4,8]]}
[900,"Economic Profitability Calculation - Results"]
[]
[null,"Project title:",null,{"$f":"IF('Input data'!F4<>\"\",'Input data'!F4,\"\")","v":"Example project"},null,null,null,null,null,null,null,{"$f":"IF('Input data'!E8&'Heat price'!C12<>\"\",\"Es existieren Warnungen\",\"\")","v":""}]
[156,"Investment:",null,{"$f":"TotalInvestment","v":2355000},"€",null,"Subsidies:",{"$f":"IF('Input data'!AG75,SubsidyAmount,0)","v":687000},null,"€"]
[161,"Equity",null,{"$f":"Equity","v":300000},"€",null,"Project start",{"$f":"ProjectStart","v":2009}]
[]
[901,"Operating costs (100% heat sale in year 1)",null,null,null,null,"Amount [€]","Index [%]","Basis [a]",null,905,"Revenues (100% heat sale in year 1)",null,null,null,"Amount [€]","Index [%]","Basis [a]"]
[null,null,null,null,null,null,{"$f":"SUM(G10:G17)","v":397268.27731092426},{"$f":"(G10*H10+G11*H11+G12*H12+G13*H13+G14*H14+G15*H15+G16*H16+G17*H17)/(SUM(G10:G17))","v":2.3596732305762518E-2},{"$f":"ProjectStart","v":2009},null,null,null,null,null,null,{"$f":"SUM(P10:P12)","v":507250},{"$f":"(P10*Q10+P11*Q11+P12*Q12)/(SUM(P10:P12))","v":2.5034499753573188E-2},{"$f":"ProjectStart","v":2009}]
[]
[null,"Biomass fuel",null,null,null,null,{"$f":"BiomassFuelPrice*BiomassFuelUsed","v":321722.68907563016},{"$f":"BiomassFuelPriceTrend/100","v":0.02},2009,null,null,"Heat sale",null,null,null,{"$f":"HeatQuantitySold*HeatSalesPrice","v":503750},{"$f":"HeatSalesPriceTrend/100","v":2.5000000000000001E-2},{"$f":"ProjectStart","v":2009}]
[null,"Fossil fuel",null,null,null,null,{"$f":"FossilFuelUsed*FossilFuelPrice","v":36470.588235294119},{"$f":"FossilFuelPriceTrend/100","v":0.05},2009,null,null,"Ongoing subsidy",null,null,null,{"$f":"IF('Input data'!$AG$79,OngoingSubsidyYear1,0)","v":3500},{"$f":"IF(P11=0,0,OngoingSubsidyTrend/100)","v":0.03},{"$f":"IF(P11=0,\"\",ProjectStart)","v":2009}]
[null,"Personnel costs",null,null,null,null,{"$f":"PersonnelExpenses","v":15000},{"$f":"PersonnelExpensesTrend/100","v":0.02},2009,null,null,"Additional revenues",null,null,null,{"$f":"OtherRevenues","v":0},{"$f":"IF(P12=0,0,OtherRevenuesTrend/100)","v":0},{"$f":"IF(P12=0,\"\",ProjectStart)","v":""}]
[null,"Electricity",null,null,null,null,{"$f":"'Input data'!N95","v":10075},{"$f":"ElectricityPriceTrend/100","v":0.05},2009,null,910,"Results:",null,null,null,"Amount [€]"]
[null,"Bookkeeping and consulting",null,null,null,null,{"$f":"AccountingConsultingExp","v":0},{"$f":"IF(G14=0,0,AccountingConsultingExpTrend/100)","v":0},{"$f":"IF(G14=0,\"\",ProjectStart)","v":""},null,null,"NPV (Period 1-10)",null,null,null,{"$f":"NPV(InterestRate/100,R25:R$34)","v":-69025.991397296588}]
[null,"Maintenance",null,null,null,null,{"$f":"MaintenanceCosts","v":9000},{"$f":"MaintenanceCostsTrend/100","v":0.02},2009,null,null,"NPV (Period 1-15)",null,null,null,{"$f":"NPV(InterestRate/100,R25:R$39)","v":55082.915814229418}]
[null,"Rent / leasehold / land",null,null,null,null,{"$f":"LandCosts","v":3500},{"$f":"IF(G16=0,0,LandCostsTrend/100)","v":2.5000000000000001E-2},{"$f":"IF(G16=0,\"\",ProjectStart)","v":2009},null,null,"NPV (Period 1-20)",null,null,null,{"$f":"NPV(InterestRate/100,R25:R$44)","v":196416.82715755884}]
[null,"Others (insurance etc.)",null,null,null,null,{"$f":"OtherCosts","v":1500},{"$f":"IF(G17=0,0,OtherCostsTrend/100)","v":0.03},{"$f":"IF(G17=0,\"\",ProjectStart)","v":2009},null,null,"NPV (Period 1-25)",null,null,null,{"$f":"NPV(InterestRate/100,R25:R$49)","v":491013.60457796452}]
[]
[]
[920,null,null,"Disbursements",null,null,null,null,null,null,null,null,"Inpayments"]
[]
["930- \n950","Year","Heat sale","Biomass fuel","Fossil fuel","Personnel, Bookkeeping and consulting","Electricity","Mainte-nance","Others (rent, etc.)","Additional disbursements","Annuity + equity","Total operating costs + repayment","Heat sales","BCS /\nSubsidy","Additional revenues/ current subsidy","Other revenues","Total revenue","Sum of (in-) payments: NPV","Cumulative (in-) payments",null,"year","Loan balance (informative)","Subsidy (informative)"]
[null,null,1,2,3,4,5,6,7,8,9,"10=2+3+4+ 5+6+7+8+9",11,12,13,14," 15 = 11+12 +13+14"," 17 = 15 - 10","18 = 17 + 18(PY)",null,null,18,19]
[null,"[yyyy]","%","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a","€/a",null,null,null,"€","€"]
[null,{"$f":"ProjectStart","v":2009},{"$f":"ConsFactor_y1","v":60},{"$f":"BiomassFuelUsed*C25/100*BiomassFuelPrice","v":193033.61344537808},{"$f":"FossilFuelUsed*FossilFuelPrice*C25/100","v":21882.352941176472},{"$f":"PersonnelExpenses+AccountingConsultingExp","v":15000},{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*C25/100","v":6045},{"$f":"'Input data'!N50","v":9000},{"$f":"LandCosts+OtherCosts","v":5000},0,{"$f":"IF(SubsidyDisbursementYear=1,Annuity,AnnuityTillSubsidyDisb)+Equity","v":452258.32348778861},{"$f":"SUM(D25:K25)","v":702219.2898743432},{"$f":"HeatQuantitySold*C25/100*HeatSalesPrice","v":302250},{"$f":"ConnectionFees*C25/100","v":210000},{"$f":"IF('Input data'!$AG$79,OngoingSubsidyYear1,0)","v":3500},{"$f":"P12","v":0},{"$f":"SUM(M25:P25)","v":515750},{"$f":"-L25+Q25","v":-186469.2898743432},null,null,1,{"$f":"IF(ISNUMBER(-LoanAmount-PPMT(GrossLoanInterest/100,$U25,LoanPeriod,LongtermLoanAmount,0)+$W25),-LoanAmount-PPMT(GrossLoanInterest/100,$U25,LoanPeriod,LongtermLoanAmount,0)+$W25,0)","v":-2015766.6765122113},{"$f":"IF(SubsidyDisbursementYear=1,IstFörderBetrag,0)","v":0}]
[null,{"$f":"B25+1","v":2010},{"$f":"ConsFactor_y2","v":80},{"$f":"BiomassFuelUsed*C26/100*BiomassFuelPrice*(1+$H$10)^1","v":262525.7142857142},{"$f":"FossilFuelUsed*FossilFuelPrice*C26/100*(1+$H$11)^1","v":30635.294117647063},{"$f":"$G$12*(1+$H$12)^(B26-B$25)+$G$14*(1+$H$14)^(B26-B$25)","v":15300},{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C26/100)*(1+$H$13)","v":8463},{"$f":"H25*(1+$H$15)","v":9180},{"$f":"$G$16*(1+$H$16)^(B26-B$25)+$G$17*(1+$H$17)^(B26-B$25)","v":5132.5},0,{"$f":"IF(SubsidyDisbursementYear<=2,Annuity,AnnuityTillSubsidyDisb)","v":152258.32348778861},{"$f":"SUM(D26:K26)","v":483494.83189114986},{"$f":"HeatQuantitySold*C26/100*HeatSalesPrice*(1+$Q$10)","v":413074.99999999994},{"$f":"ConnectionFees*(C26-C25)/100","v":70000},{"$f":"IF('Input data'!$AG$79,O25+OngoingSubsidyIncrease+OngoingSubsidyTrend*O25/100,0)","v":4605},{"$f":"$P$25*(1+$Q$12)^1","v":0},{"$f":"SUM(M26:P26)","v":487679.99999999994},{"$f":"-L26+Q26","v":4185.1681088500773},{"$f":"R25+R26","v":-182284.12176549312},null,2,{"$f":"IF(ISNUMBER(V25-PPMT(GrossLoanInterest/100,$U26,LoanPeriod,LongtermLoanAmount,0)+$W26),V25-PPMT(GrossLoanInterest/100,$U26,LoanPeriod,LongtermLoanAmount,0)+$W26,0)","v":-1974375.5202325943},{"$f":"IF(SubsidyDisbursementYear=2,SubsidyAmount,0)","v":0}]
[null,{"$f":"B26+1","v":2011},{"$f":"ConsFactor_y3","v":100},{"$f":"BiomassFuelUsed*C27/100*BiomassFuelPrice*(1+$H$10)^2","v":334720.28571428562},{"$f":"FossilFuelUsed*FossilFuelPrice*C27/100*(1+$H$11)^2","v":40208.823529411769},15606,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C27/100)*(1+$H$13)^2","v":11107.6875},{"$f":"H26*(1+$H$15)","v":9363.6},{"$f":"$G$16*(1+$H$16)^(B27-B$25)+$G$17*(1+$H$17)^(B27-B$25)","v":5268.5374999999995},0,{"$f":"IF(SubsidyDisbursementYear<=3,Annuity,AnnuityTillSubsidyDisb)","v":152258.32348778861},568533.25773148588,{"$f":"HeatQuantitySold*C27/100*HeatSalesPrice*(1+$Q$10)^2","v":529252.34375},{"$f":"ConnectionFees*(C27-C26)/100","v":70000},{"$f":"IF('Input data'!$AG$79,O26+OngoingSubsidyIncrease+OngoingSubsidyTrend*O26/100,0)","v":5743.15},{"$f":"$P$25*(1+$Q$12)^2","v":0},{"$f":"SUM(M27:P27)","v":604995.49375000002},36462.236018514144,{"$f":"S26+R27","v":-145821.88574697898},null,3,-1930707.8503575984,{"$f":"IF(SubsidyDisbursementYear=3,SubsidyAmount,0)","v":0}]
[null,2012,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^1)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^1))","v":100},{"$f":"BiomassFuelUsed*C28/100*BiomassFuelPrice*(1+$H$10)^3","v":341414.6914285713},{"$f":"FossilFuelUsed*FossilFuelPrice*C28/100*(1+$H$11)^3","v":42219.264705882357},15918.119999999999,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C28/100)*(1+$H$13)^3","v":11663.071875000001},{"$f":"H27*(1+$H$15)","v":9550.8720000000012},5408.2076874999993,0,{"$f":"IF(SubsidyDisbursementYear<=4,Annuity,AnnuityTillSubsidyDisb)","v":152258.32348778861},578432.55118474225,{"$f":"HeatQuantitySold*C28/100*HeatSalesPrice*(1+$Q$10)^3","v":542483.65234374988},{"$f":"ConnectionFees*(C28-C27)/100","v":0},{"$f":"IF('Input data'!$AG$79,O27+OngoingSubsidyIncrease+OngoingSubsidyTrend*O27/100,0)","v":6915.4444999999996},{"$f":"$P$25*(1+$Q$12)^3","v":0},549399.09684374987,-29033.454340992379,-174855.34008797136,null,4,-1884638.4586394776,{"$f":"IF(SubsidyDisbursementYear=4,SubsidyAmount,0)","v":0}]
[null,2013,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^2)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^2))","v":100},{"$f":"BiomassFuelUsed*C29/100*BiomassFuelPrice*(1+$H$10)^4","v":348242.98525714275},{"$f":"FossilFuelUsed*FossilFuelPrice*C29/100*(1+$H$11)^4","v":44330.227941176476},16236.482399999999,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C29/100)*(1+$H$13)^4","v":12246.225468750001},{"$f":"H28*(1+$H$15)","v":9741.8894400000008},5551.6083321874994,0,{"$f":"IF(SubsidyDisbursementYear<=5,Annuity,AnnuityTillSubsidyDisb)","v":114473.3234877886},550822.7423270453,{"$f":"HeatQuantitySold*C29/100*HeatSalesPrice*(1+$Q$10)^4","v":556045.74365234363},{"$f":"ConnectionFees*(C29-C28)/100","v":0},{"$f":"IF('Input data'!$AG$79,O28+OngoingSubsidyIncrease+OngoingSubsidyTrend*O28/100,0)","v":8122.907835},{"$f":"$P$25*(1+$Q$12)^4","v":0},564168.6514873436,13345.909160298295,-161509.43092767306,null,5,-1149035.2503768604,{"$f":"IF(SubsidyDisbursementYear=5,SubsidyAmount,0)","v":687000}]
[null,2014,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^3)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^3))","v":100},{"$f":"BiomassFuelUsed*C30/100*BiomassFuelPrice*(1+$H$10)^5","v":355207.8449622856},{"$f":"FossilFuelUsed*FossilFuelPrice*C30/100*(1+$H$11)^5","v":46546.739338235304},16561.212048000001,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C30/100)*(1+$H$13)^5","v":12858.536742187502},{"$f":"H29*(1+$H$15)","v":9936.7272288000004},5698.839856567186,0,{"$f":"IF(B30-$B$25<LoanPeriod,Annuity,0)","v":114473.3234877886},561283.22366386419,{"$f":"HeatQuantitySold*C30/100*HeatSalesPrice*(1+$Q$10)^5","v":569946.88724365213},{"$f":"ConnectionFees*(C30-C29)/100","v":0},{"$f":"IF('Input data'!$AG$79,O29+OngoingSubsidyIncrease+OngoingSubsidyTrend*O29/100,0)","v":9366.5950700499998},{"$f":"$P$25*(1+$Q$12)^5","v":0},579313.48231370212,18030.258649837924,-143479.17227783514,null,6,-1097758.8656597992,{"$f":"IF(SubsidyDisbursementYear=6,SubsidyAmount,0)","v":0}]
[null,2015,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^4)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^4))","v":100},{"$f":"BiomassFuelUsed*C31/100*BiomassFuelPrice*(1+$H$10)^6","v":362312.00186153135},{"$f":"FossilFuelUsed*FossilFuelPrice*C31/100*(1+$H$11)^6","v":48874.076305147057},16892.436288960002,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C31/100)*(1+$H$13)^6","v":13501.463579296875},10135.461773376001,5850.0054085386155,0,114473.3234877886,572038.76870463847,{"$f":"HeatQuantitySold*C31/100*HeatSalesPrice*(1+$Q$10)^6","v":584195.55942474341},0,{"$f":"IF('Input data'!$AG$79,O30+OngoingSubsidyIncrease+OngoingSubsidyTrend*O30/100,0)","v":10647.5929221515},{"$f":"$P$25*(1+$Q$12)^6","v":0},594843.15234689496,22804.383642256493,-120674.78863557865,null,7,-1043662.2797832995,{"$f":"IF(SubsidyDisbursementYear=7,SubsidyAmount,0)","v":0}]
[null,2016,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^5)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^5))","v":100},{"$f":"BiomassFuelUsed*C32/100*BiomassFuelPrice*(1+$H$10)^7","v":369558.24189876189},{"$f":"FossilFuelUsed*FossilFuelPrice*C32/100*(1+$H$11)^7","v":51317.780120404423},17230.285014739198,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C32/100)*(1+$H$13)^7","v":14176.536758261722},10338.171008843521,6005.2109359760489,0,114473.3234877886,583099.5492247754,{"$f":"HeatQuantitySold*C32/100*HeatSalesPrice*(1+$Q$10)^7","v":598800.44841036201},0,{"$f":"IF('Input data'!$AG$79,O31+OngoingSubsidyIncrease+OngoingSubsidyTrend*O31/100,0)","v":11967.020709816044},{"$f":"$P$25*(1+$Q$12)^7","v":0},610767.46912017802,27667.919895402621,-93006.868740176025,null,8,-986590.38168359245,{"$f":"IF(SubsidyDisbursementYear=8,SubsidyAmount,0)","v":0}]
[null,2017,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^6)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^6))","v":100},{"$f":"BiomassFuelUsed*C33/100*BiomassFuelPrice*(1+$H$10)^8","v":376949.40673673718},{"$f":"FossilFuelUsed*FossilFuelPrice*C33/100*(1+$H$11)^8","v":53883.66912642464},17574.890715033984,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C33/100)*(1+$H$13)^8","v":14885.363596174806},10544.934429020392,6164.5652633661357,0,114473.3234877886,594476.15335454571,{"$f":"HeatQuantitySold*C33/100*HeatSalesPrice*(1+$Q$10)^8","v":613770.45962062106},0,{"$f":"IF('Input data'!$AG$79,O32+OngoingSubsidyIncrease+OngoingSubsidyTrend*O32/100,0)","v":13326.031331110526},{"$f":"$P$25*(1+$Q$12)^8","v":0},627096.49095173157,32620.337597185862,-60386.531142990163,null,9,-926379.52918840142,{"$f":"IF(SubsidyDisbursementYear=9,SubsidyAmount,0)","v":0}]
[null,2018,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^7)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^7))","v":100},{"$f":"BiomassFuelUsed*C34/100*BiomassFuelPrice*(1+$H$10)^9","v":384488.39487147192},{"$f":"FossilFuelUsed*FossilFuelPrice*C34/100*(1+$H$11)^9","v":56577.852582745872},17926.388529334661,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C34/100)*(1+$H$13)^9","v":15629.631775983546},10755.8331176008,6328.1801705606958,0,114473.3234877886,606179.6045354862,{"$f":"HeatQuantitySold*C34/100*HeatSalesPrice*(1+$Q$10)^9","v":629114.72111113649},0,{"$f":"IF('Input data'!$AG$79,O33+OngoingSubsidyIncrease+OngoingSubsidyTrend*O33/100,0)","v":14725.812271043842},{"$f":"$P$25*(1+$Q$12)^9","v":0},643840.53338218038,37660.92884669418,-22725.602296295983,null,10,-862857.07980597496,{"$f":"IF(SubsidyDisbursementYear=10,SubsidyAmount,0)","v":0}]
[null,2019,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^8)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^8))","v":100},{"$f":"BiomassFuelUsed*C35/100*BiomassFuelPrice*(1+$H$10)^10","v":392178.16276890138},{"$f":"FossilFuelUsed*FossilFuelPrice*C35/100*(1+$H$11)^10","v":59406.745211883164},18284.916299921355,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C35/100)*(1+$H$13)^10","v":16411.113364782723},10970.949779952816,6496.1704737034324,0,114473.3234877886,618221.38138693338,{"$f":"HeatQuantitySold*C35/100*HeatSalesPrice*(1+$Q$10)^10","v":644842.58913891483},0,{"$f":"IF('Input data'!$AG$79,O34+OngoingSubsidyIncrease+OngoingSubsidyTrend*O34/100,0)","v":16167.586639175157},{"$f":"$P$25*(1+$Q$12)^10","v":0},661010.17577809002,42788.79439115664,20063.192094860657,null,11,-795840.89570751507,{"$f":"IF(SubsidyDisbursementYear=11,SubsidyAmount,0)","v":0}]
[null,2020,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^9)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^9))","v":100},{"$f":"BiomassFuelUsed*C36/100*BiomassFuelPrice*(1+$H$10)^11","v":400021.72602427931},{"$f":"FossilFuelUsed*FossilFuelPrice*C36/100*(1+$H$11)^11","v":62377.082472477327},18650.614625919781,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C36/100)*(1+$H$13)^11","v":17231.669033021863},11190.368775551873,6668.6541083910997,0,114473.3234877886,630613.43852742983,{"$f":"HeatQuantitySold*C36/100*HeatSalesPrice*(1+$Q$10)^11","v":660963.65386738779},0,{"$f":"IF('Input data'!$AG$79,O35+OngoingSubsidyIncrease+OngoingSubsidyTrend*O35/100,0)","v":17652.614238350408},{"$f":"$P$25*(1+$Q$12)^11","v":0},678616.26810573821,48002.829578308389,68066.021673169045,null,12,-725138.82148363977,{"$f":"IF(SubsidyDisbursementYear=12,SubsidyAmount,0)","v":0}]
[null,2021,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^10)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^10))","v":100},{"$f":"BiomassFuelUsed*C37/100*BiomassFuelPrice*(1+$H$10)^12","v":408022.16054476495},{"$f":"FossilFuelUsed*FossilFuelPrice*C37/100*(1+$H$11)^12","v":65495.936596101186},19023.626918438178,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C37/100)*(1+$H$13)^12","v":18093.25248467295},11414.176151062911,6845.7522151313096,0,114473.3234877886,643368.22839796008,{"$f":"HeatQuantitySold*C37/100*HeatSalesPrice*(1+$Q$10)^12","v":677487.74521407241},0,{"$f":"IF('Input data'!$AG$79,O36+OngoingSubsidyIncrease+OngoingSubsidyTrend*O36/100,0)","v":19182.192665500919},{"$f":"$P$25*(1+$Q$12)^12","v":0},696669.93787957332,53301.709481613245,121367.73115478229,null,13,-650548.13317745132,{"$f":"IF(SubsidyDisbursementYear=13,SubsidyAmount,0)","v":0}]
[null,2022,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^11)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^11))","v":100},{"$f":"BiomassFuelUsed*C38/100*BiomassFuelPrice*(1+$H$10)^13","v":416182.60375566024},{"$f":"FossilFuelUsed*FossilFuelPrice*C38/100*(1+$H$11)^13","v":68770.733425906263},19404.09945680694,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C38/100)*(1+$H$13)^13","v":18997.915108906604},11642.45967408417,7027.5892271609373,0,114473.3234877886,656498.72413631377,{"$f":"HeatQuantitySold*C38/100*HeatSalesPrice*(1+$Q$10)^13","v":694424.93884442421},0,{"$f":"IF('Input data'!$AG$79,O37+OngoingSubsidyIncrease+OngoingSubsidyTrend*O37/100,0)","v":20757.658445465946},{"$f":"$P$25*(1+$Q$12)^13","v":0},715182.59728989017,58683.873153576395,180051.60430835868,null,14,-571854.95701442251,{"$f":"IF(SubsidyDisbursementYear=14,SubsidyAmount,0)","v":0}]
[null,2023,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^12)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^12))","v":100},{"$f":"BiomassFuelUsed*C39/100*BiomassFuelPrice*(1+$H$10)^14","v":424506.2558307735},{"$f":"FossilFuelUsed*FossilFuelPrice*C39/100*(1+$H$11)^14","v":72209.270097201559},19792.181445943083,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C39/100)*(1+$H$13)^14","v":19947.81086435193},11875.308867565853,7214.2929606908474,0,114473.3234877886,670018.44355431525,{"$f":"HeatQuantitySold*C39/100*HeatSalesPrice*(1+$Q$10)^14","v":711785.56231553468},0,{"$f":"IF('Input data'!$AG$79,O38+OngoingSubsidyIncrease+OngoingSubsidyTrend*O38/100,0)","v":22380.388198829925},{"$f":"$P$25*(1+$Q$12)^14","v":0},734165.95051436464,64147.506960049388,244199.11126840807,null,15,-488833.65616242716,{"$f":"IF(SubsidyDisbursementYear=15,SubsidyAmount,0)","v":0}]
[null,2024,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^13)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^13))","v":100},{"$f":"BiomassFuelUsed*C40/100*BiomassFuelPrice*(1+$H$10)^15","v":432996.38094738883},{"$f":"FossilFuelUsed*FossilFuelPrice*C40/100*(1+$H$11)^15","v":75819.733602061649},20188.02507486194,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C40/100)*(1+$H$13)^15","v":20945.20140756953},12112.81504491717,7405.9947076445333,0,114473.3234877886,683941.47427223227,{"$f":"HeatQuantitySold*C40/100*HeatSalesPrice*(1+$Q$10)^15","v":729580.20137342322},0,{"$f":"IF('Input data'!$AG$79,O39+OngoingSubsidyIncrease+OngoingSubsidyTrend*O39/100,0)","v":24051.799844794823},{"$f":"$P$25*(1+$Q$12)^15","v":0},753632.00121821801,69690.526945985737,313889.63821439381,null,16,-401246.18376357207,{"$f":"IF(SubsidyDisbursementYear=16,SubsidyAmount,0)","v":0}]
[null,2025,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^14)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^14))","v":100},{"$f":"BiomassFuelUsed*C41/100*BiomassFuelPrice*(1+$H$10)^16","v":441656.30856633669},{"$f":"FossilFuelUsed*FossilFuelPrice*C41/100*(1+$H$11)^16","v":79610.720282164722},20591.78557635918,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C41/100)*(1+$H$13)^16","v":21992.461477948007},12355.071345815513,7602.8293309601513,0,114473.3234877886,698282.50006737281,{"$f":"HeatQuantitySold*C41/100*HeatSalesPrice*(1+$Q$10)^16","v":747819.70640775864},0,{"$f":"IF('Input data'!$AG$79,O40+OngoingSubsidyIncrease+OngoingSubsidyTrend*O40/100,0)","v":25773.353840138669},{"$f":"$P$25*(1+$Q$12)^16","v":0},773593.06024789729,75310.560180524481,389200.19839491829,null,17,-308841.40038277995,{"$f":"IF(SubsidyDisbursementYear=17,SubsidyAmount,0)","v":0}]
[null,2026,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^15)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^15))","v":100},{"$f":"BiomassFuelUsed*C42/100*BiomassFuelPrice*(1+$H$10)^17","v":450489.43473766348},{"$f":"FossilFuelUsed*FossilFuelPrice*C42/100*(1+$H$11)^17","v":83591.256296272972},21003.621287886366,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C42/100)*(1+$H$13)^17","v":23092.084551845408},12602.172772731823,7804.9353625273952,0,114473.3234877886,713056.8284967161,{"$f":"HeatQuantitySold*C42/100*HeatSalesPrice*(1+$Q$10)^17","v":766515.19906795258},0,{"$f":"IF('Input data'!$AG$79,O41+OngoingSubsidyIncrease+OngoingSubsidyTrend*O41/100,0)","v":27546.55445534283},{"$f":"$P$25*(1+$Q$12)^17","v":0},794061.7535232954,81004.925026579294,470205.12342149758,null,18,-211354.35391604426,{"$f":"IF(SubsidyDisbursementYear=18,SubsidyAmount,0)","v":0}]
[null,2027,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^16)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^16))","v":100},{"$f":"BiomassFuelUsed*C43/100*BiomassFuelPrice*(1+$H$10)^18","v":459499.22343241668},{"$f":"FossilFuelUsed*FossilFuelPrice*C43/100*(1+$H$11)^18","v":87770.819111086617},21423.69371364409,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C43/100)*(1+$H$13)^18","v":24246.688779437678},12854.21622818646,8012.455103832619,0,114473.3234877886,728280.41985639278,{"$f":"HeatQuantitySold*C43/100*HeatSalesPrice*(1+$Q$10)^18","v":785678.07904465136},0,{"$f":"IF('Input data'!$AG$79,O42+OngoingSubsidyIncrease+OngoingSubsidyTrend*O42/100,0)","v":29372.951089003116},{"$f":"$P$25*(1+$Q$12)^18","v":0},815051.03013365448,86770.610277261701,556975.73369875923,null,19,-108505.51989363811,{"$f":"IF(SubsidyDisbursementYear=19,SubsidyAmount,0)","v":0}]
[null,2028,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^17)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^17))","v":100},{"$f":"BiomassFuelUsed*C44/100*BiomassFuelPrice*(1+$H$10)^19","v":468689.207901065},{"$f":"FossilFuelUsed*FossilFuelPrice*C44/100*(1+$H$11)^19","v":92159.360066640962},21852.167587916971,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C44/100)*(1+$H$13)^19","v":25459.023218409562},13111.30055275019,8225.534729387733,0,114473.3234877886,743969.91754395899,{"$f":"HeatQuantitySold*C44/100*HeatSalesPrice*(1+$Q$10)^19","v":805320.03102076764},0,{"$f":"IF('Input data'!$AG$79,O43+OngoingSubsidyIncrease+OngoingSubsidyTrend*O43/100,0)","v":31254.13962167321},{"$f":"$P$25*(1+$Q$12)^19","v":0},836574.17064244091,92604.253098481917,649579.98679724114,null,20,3.7834979593753815E-10,{"$f":"IF(SubsidyDisbursementYear=20,SubsidyAmount,0)","v":0}]
[null,2029,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^18)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^18))","v":100},{"$f":"BiomassFuelUsed*C45/100*BiomassFuelPrice*(1+$H$10)^20","v":478062.99205908633},{"$f":"FossilFuelUsed*FossilFuelPrice*C45/100*(1+$H$11)^20","v":96767.328069972995},22289.210939675315,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C45/100)*(1+$H$13)^20","v":26731.97437933004},13373.526563805193,8444.3243930205044,0,0,645669.35640489042,{"$f":"HeatQuantitySold*C45/100*HeatSalesPrice*(1+$Q$10)^20","v":825453.03179628681},0,{"$f":"IF('Input data'!$AG$79,O44+OngoingSubsidyIncrease+OngoingSubsidyTrend*O44/100,0)","v":33191.763810323406},{"$f":"$P$25*(1+$Q$12)^20","v":0},858644.79560661025,212975.43920171983,862555.42599896097,null,21,0,{"$f":"IF(SubsidyDisbursementYear=21,SubsidyAmount,0)","v":0}]
[null,2030,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^19)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^19))","v":100},{"$f":"BiomassFuelUsed*C46/100*BiomassFuelPrice*(1+$H$10)^21","v":487624.25190026802},{"$f":"FossilFuelUsed*FossilFuelPrice*C46/100*(1+$H$11)^21","v":101605.69447347165},22734.995158468817,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C46/100)*(1+$H$13)^21","v":28068.573098296543},13640.997095081297,8668.9783371060366,0,0,662343.49006269232,{"$f":"HeatQuantitySold*C46/100*HeatSalesPrice*(1+$Q$10)^21","v":846089.35759119387},0,{"$f":"IF('Input data'!$AG$79,O45+OngoingSubsidyIncrease+OngoingSubsidyTrend*O45/100,0)","v":35187.516724633111},{"$f":"$P$25*(1+$Q$12)^21","v":0},881276.87431582692,218933.3842531346,1081488.8102520956,null,22,0,{"$f":"IF(SubsidyDisbursementYear=22,SubsidyAmount,0)","v":0}]
[null,2031,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^20)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^20))","v":100},{"$f":"BiomassFuelUsed*C47/100*BiomassFuelPrice*(1+$H$10)^22","v":497376.73693827342},{"$f":"FossilFuelUsed*FossilFuelPrice*C47/100*(1+$H$11)^22","v":106685.97919714522},23189.695061638195,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C47/100)*(1+$H$13)^22","v":29472.001753211367},13913.817036982922,8899.6550048215086,0,0,679537.88499207259,{"$f":"HeatQuantitySold*C47/100*HeatSalesPrice*(1+$Q$10)^22","v":867241.59153097367},0,{"$f":"IF('Input data'!$AG$79,O46+OngoingSubsidyIncrease+OngoingSubsidyTrend*O46/100,0)","v":37243.142226372103},{"$f":"$P$25*(1+$Q$12)^22","v":0},904484.73375734582,224946.84876527323,1306435.6590173687,null,23,0,{"$f":"IF(SubsidyDisbursementYear=23,SubsidyAmount,0)","v":0}]
[null,2032,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^21)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^21))","v":100},{"$f":"BiomassFuelUsed*C48/100*BiomassFuelPrice*(1+$H$10)^23","v":507324.27167703881},{"$f":"FossilFuelUsed*FossilFuelPrice*C48/100*(1+$H$11)^23","v":112020.27815700251},23653.488962870957,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C48/100)*(1+$H$13)^23","v":30945.601840871943},14192.09337772258,9136.5171555085035,0,0,697272.2511710152,{"$f":"HeatQuantitySold*C48/100*HeatSalesPrice*(1+$Q$10)^23","v":888922.631319248},0,{"$f":"IF('Input data'!$AG$79,O47+OngoingSubsidyIncrease+OngoingSubsidyTrend*O47/100,0)","v":39360.436493163266},{"$f":"$P$25*(1+$Q$12)^23","v":0},928283.06781241123,231010.81664139603,1537446.4756587646,null,24,0,{"$f":"IF(SubsidyDisbursementYear=24,SubsidyAmount,0)","v":0}]
[null,2033,{"$f":"$C$27*(IF(((1+'Input data'!$N$20/100)^22)>(1+ConsFactorMax/100),(1+ConsFactorMax/100),(1+'Input data'!$N$20/100)^22))","v":100},{"$f":"BiomassFuelUsed*C49/100*BiomassFuelPrice*(1+$H$10)^24","v":517470.75711057958},{"$f":"FossilFuelUsed*FossilFuelPrice*C49/100*(1+$H$11)^24","v":117621.29206485262},24126.558742128374,{"$f":"SpecificElectCons*HeatQuantitySold*ElectricityPrice*(C49/100)*(1+$H$13)^24","v":32492.881932915534},14475.935245277033,9379.7319832296635,0,0,715567.1570789828,{"$f":"HeatQuantitySold*C49/100*HeatSalesPrice*(1+$Q$10)^24","v":911145.69710222911},0,{"$f":"IF('Input data'!$AG$79,O48+OngoingSubsidyIncrease+OngoingSubsidyTrend*O48/100,0)","v":41541.249587958162},{"$f":"$P$25*(1+$Q$12)^24","v":0},952686.94669018732,237119.78961120453,1774566.2652699691,null,25,0,{"$f":"IF(SubsidyDisbursementYear=25,SubsidyAmount,0)","v":0}]
[]
[]
[980,"Economic Profitability Calculation - Diagrams"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[981]

{"sheet":"Interpretation","index":5,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,7,22],[3,5,3,22]]}
[null,"Economic Profitability Calculation - Interpretation"]
[]
[]
[null,"Project title:",null,null,null,"Musterprojekt Mustermann"]
[]
[null,"Comments on the profitability assessment results (Interpretation)"]
[]
[500]