Energy balance in Stuttgart

From Testiwiki
Revision as of 11:13, 21 September 2012 by Marjo (talk | contribs) (→‎Data)
Jump to: navigation, search



Question

What are the amounts of energy produced, consumed, imported, and exported in Stuttgart?

Answer

Rationale

There are several energy transformations that each describe a specific process of energy production or use. Per unit activity, there is a constant amount of different inputs and outputs into and from this process, respectively. These unit processes are used for Stuttgart in such a way that one critical input or output from each relevant energy transformation is listed here; all other inputs and outputs logically follow from the nature of the transformation process.

Data

You have error(s) in your data:

You have invalid number of data cells in row 6
You have invalid number of data cells in row 75
You have invalid number of data cells in row 76
You have invalid number of data cells in row 77
You have invalid number of data cells in row 78
You have invalid number of data cells in row 79
You have invalid number of data cells in row 80
You have invalid number of data cells in row 81
You have invalid number of data cells in row 82
You have invalid number of data cells in row 83
You have invalid number of data cells in row 84
You have invalid number of data cells in row 85
You have invalid number of data cells in row 86
You have invalid number of data cells in row 87
You have invalid number of data cells in row 88
You have invalid number of data cells in row 89
You have invalid number of data cells in row 90
You have invalid number of data cells in row 91
You have invalid number of data cells in row 92
You have invalid number of data cells in row 93
You have invalid number of data cells in row 94
You have invalid number of data cells in row 95
You have invalid number of data cells in row 96
You have invalid number of data cells in row 97
You have invalid number of data cells in row 98
You have invalid number of data cells in row 99
You have invalid number of data cells in row 100
You have invalid number of data cells in row 101
You have invalid number of data cells in row 102
You have invalid number of data cells in row 103
You have invalid number of data cells in row 104
You have invalid number of data cells in row 105
You have invalid number of data cells in row 106
You have invalid number of data cells in row 107
You have invalid number of data cells in row 108
You have invalid number of data cells in row 109
You have invalid number of data cells in row 110
You have invalid number of data cells in row 111
You have invalid number of data cells in row 112
You have invalid number of data cells in row 113
You have invalid number of data cells in row 114
You have invalid number of data cells in row 115
You have invalid number of data cells in row 116
You have invalid number of data cells in row 117
You have invalid number of data cells in row 118
You have invalid number of data cells in row 119
You have invalid number of data cells in row 120
You have invalid number of data cells in row 121
You have invalid number of data cells in row 122
You have invalid number of data cells in row 123
You have invalid number of data cells in row 124
You have invalid number of data cells in row 125
You have invalid number of data cells in row 126
You have invalid number of data cells in row 127
You have invalid number of data cells in row 128
You have invalid number of data cells in row 129
You have invalid number of data cells in row 130
You have invalid number of data cells in row 131
You have invalid number of data cells in row 132
You have invalid number of data cells in row 133
You have invalid number of data cells in row 134
You have invalid number of data cells in row 135
You have invalid number of data cells in row 136
You have invalid number of data cells in row 137
You have invalid number of data cells in row 138
You have invalid number of data cells in row 139
You have invalid number of data cells in row 140
You have invalid number of data cells in row 141
You have invalid number of data cells in row 142
You have invalid number of data cells in row 143
You have invalid number of data cells in row 144
You have invalid number of data cells in row 145
You have invalid number of data cells in row 146
You have invalid number of data cells in row 147
You have invalid number of data cells in row 148
You have invalid number of data cells in row 149
You have invalid number of data cells in row 150
You have invalid number of data cells in row 151
You have invalid number of data cells in row 152
You have invalid number of data cells in row 153
You have invalid number of data cells in row 154
You have invalid number of data cells in row 155
You have invalid number of data cells in row 156
You have invalid number of data cells in row 157
You have invalid number of data cells in row 158
You have invalid number of data cells in row 159
You have invalid number of data cells in row 160
You have invalid number of data cells in row 161
You have invalid number of data cells in row 162
Energy balance in Stuttgart(-)
ObsEquationColResultDescription
1Balance Solar Thermal PumpSTP renewable energy-1In energy balance, inputs and outputs cancel out
2Balance Solar Thermal PumpSTP electricity-1
3Balance Solar Thermal PumpSTP local heating1
4Fraction STP renewable energySTP electricity-1Amount of electricity is used as comparison for renewable energy
5Fraction STP renewable energySTP renewable energy0.3636363648/22 Electricity divided by renewable energy
6Balance CHP PlantsCHP gas-1In energy balance, inputs and outputs cancel out
7Balance CHP PlantsCHP renewable energy-1
8Balance CHP PlantsCHP mineral oil-1
9Balance CHP PlantsCHP local heating1
10Balance CHP PlantsCHP electricity1
11Balance CHP PlantsCHP loss1
12Fraction CHP gasCHP renewable energy-1Sum of other fuels is used as comparison for gas
13Fraction CHP gasCHP mineral oil-1
14Fraction CHP gasCHP gas0.564814815(108+14)/216 Others divided by gas
15Fraction CHP renewable energyCHP gas-1Sum of other fuels is used as comparison for renewable energy
16Fraction CHP renewable energyCHP mineral oil-1
17Fraction CHP renewable energyCHP renewable energy2.12962963(216+14)/108 Others divided by renewable energy
18Fraction CHP local heatingCHP electricity-1Sum of other outputs is used as comparison for local heating
19Fraction CHP local heatingCHP loss-1
20Fraction CHP local heatingCHP local heating1.770491803(84+132)/122 Others divided by local heating
21Fraction CHP electricityCHP local heating-1Sum of other outputs is used as comparison for electricity
22Fraction CHP electricityCHP loss-1
23Fraction CHP electricityCHP electricity3.023809524(122+132)/84 Others divided by electricity
24Balance Water, Wind, PhotovlotaicsWWP renewable energy-1In energy balance, inputs and outputs cancel out
25Balance Water, Wind, PhotovlotaicsWWP electricity1
26Balance Thermal Power Plant PfaffenwaldTPP electricity input-1In energy balance, inputs and outputs cancel out
27Balance Thermal Power Plant PfaffenwaldTPP mineral oil-1
28Balance Thermal Power Plant PfaffenwaldTPP gas-1
29Balance Thermal Power Plant PfaffenwaldTPP local heating1
30Balance Thermal Power Plant PfaffenwaldTPP electricity output1
31Balance Thermal Power Plant PfaffenwaldTPP loss1
32Fraction TPP electricity inputTPP mineral oil-1Sum of other fuels is used as comparison for electricity input
33Fraction TPP electricity inputTPP gas-1
34Fraction TPP electricity inputTPP electricity input23.33333333(43+167)/9 Others divided by electricity input
35Fraction TPP mineral oilTPP electricity input-1Sum of other fuels is used as comparison for mineral oil
36Fraction TPP mineral oilTPP gas-1
37Fraction TPP mineral oilTPP mineral oil4.093023256(9+167)/43 Others divided by mineral oil
38Fraction TPP local heatingTPP electricity output-1Sum of other outputs is used as comparison for local heating
39Fraction TPP local heatingTPP loss-1
40Fraction TPP local heatingTPP local heating0.335365854(50+5)/164 Others divided by local heating
41Fraction TPP electricity outputTPP local heating-1Sum of other outputs is used as comparison for electricity
42Fraction TPP electricity outputTPP loss-1
43Fraction TPP electricity outputTPP electricity output3.38(164+5)/50 Others divided by electricity
44Balance Thermal Power Plant EVUTPE waste-1In energy balance, inputs and outputs cancel out
45Balance Thermal Power Plant EVUTPE gas-1
46Balance Thermal Power Plant EVUTPE coal-1
47Balance Thermal Power Plant EVUTPE mineral oil-1
48Balance Thermal Power Plant EVUTPE electricity1
49Balance Thermal Power Plant EVUTPE district heating1
50Balance Thermal Power Plant EVUTPE loss1
51Fraction TPE wasteTPE gas-1Sum of other fuels is used as comparison for waste
52Fraction TPE wasteTPE coal-1
53Fraction TPE wasteTPE mineral oil-1
54Fraction TPE wasteTPE waste1.04973357(162+1019+1)/1126 Others divided by waste
55Fraction TPE gasTPE waste-1Sum of other fuels is used as comparison for gas
56Fraction TPE gasTPE coal-1
57Fraction TPE gasTPE mineral oil-1
58Fraction TPE gasTPE gas13.24691358(1126+1019+1)/162 Others divided by gas
59Fraction TPE coalTPE waste-1Sum of other fuels is used as comparison for coal
60Fraction TPE coalTPE gas-1
61Fraction TPE coalTPE mineral oil-1
62Fraction TPE coalTPE coal1.264965653(1126+162+1)/1019 Others divided by coal
63Fraction TPE electricityTPE district heating-1Sum of other outputs is used as comparison for electricity
64Fraction TPE electricityTPE loss-1
65Fraction TPE electricityTPE electricity5.089709763(1101+828)/379 Others divided by electricity
66Fraction TPE district heatingTPE electricity-1Sum of other outputs is used as comparison for district heating
67Fraction TPE district heatingTPE loss-1
68Fraction TPE district heatingTPE district heating1.096276113(379 +828)/1101 Others divided by district heating
69Balance Industrial PlantsInd gas-1In energy balance, inputs and outputs cancel out
70Balance Industrial PlantsInd electricity1
71Balance Industrial PlantsInd loss1
72Fraction Ind lossInd electricity-1Amount of district heating is used as comparison for loss
73Fraction Ind lossInd loss0.5333333338/15 district heating per loss
74Fraction local heating producers STP local heating-1CHP local heating production is used as reference
7575 Fraction local heating producers CHP local heating 0.245901639 30/122 STP local heating divided by CHP local heating
7676 Fraction electricity producers 1 Ind electricity -1 CHP electricity production is used as refernce
7777 Fraction electricity producers 1 CHP electricity 0.095238095 8/84 Ind electricity divided by TPE district heating
7878 Fraction electricity producers 2 WWP electricity -1 CHP electricity production is used as refernce
7979 Fraction electricity producers 2 CHP electricity 0.797619048 67/84 WWP electricity divided by CHP electricity
8080 Fraction electricity producers 3 TPP electricity output -1 CHP electricity production is used as refernce
8181 Fraction electricity producers 3 CHP electricity 0.595238095 50/84 TPP electricity divided by CHP electricity
8282 Fraction electricity producers 4 TPE electricity -1 CHP electricity production is used as refernce
8383 Fraction electricity producers 4 CHP electricity 4.511904762 379/84 TPE electricity divided by CHP electricity
8484 Transmission loss local heating Loss local heating 1 Known loss divided by production
8585 Transmission loss local heating STP local heating -0.041139241 13/(30+122+164)
8686 Transmission loss local heating CHP local heating -0.041139241
8787 Transmission loss local heating TPP local heating -0.041139241
8888 Transmission loss electricity Loss electricity 1 Known loss divided by production
8989 Transmission loss electricity CHP electricity -0.221088435 130/(84+67+50+379+8)
9090 Transmission loss electricity WWP electricity -0.221088435
9191 Transmission loss electricity TPP electricity output -0.221088435
9292 Transmission loss electricity TPE electricity -0.221088435
9393 Transmission loss electricity Ind electricity -0.221088435
9494 Transmission loss district heating Loss district heating 1 Known loss divided by production
9595 Transmission loss district heating TPE district heating -0.109900091 121/1101
9696 Consumption in the Energy Sector local heating CES local heating 1 STP local heating is used as reference
9797 Consumption in the Energy Sector local heating STP local heating -0.366666667 11/30
9898 Consumption in the Energy Sector electricity CES electricity 1 CHP electricity is used as reference
9999 Consumption in the Energy Sector electricity CHP electricity -1.392857143 117/84
100100 Vorketten renewable energy V renewable energy 1 STP renewable energy is used as reference
101101 Vorketten renewable energy STP renewable energy -0.272727273 6/22
102102 Vorketten coal V coal 1 TPE coal is used as reference
103103 Vorketten coal TPE coal -0.103042198 105/1019
104104 Vorketten electricity V electricity 1 TPE electricity is used as reference
105105 Vorketten electricity TPE electricity -17.79683377 6745/379
106106 Vorketten gas V gas 1 CHP gas is used as reference
107107 Vorketten gas CHP gas -2.027777778 438/216
108108 Vorketten mineral oil V mineral oil 1 TPP mineral oil is used as reference
109109 Vorketten mineral oil TPP mineral oil -12.3255814 530/43
110110 Electricity use balance Bought electricity -1 In energy balance, inputs and outputs cancel out
111111 Electricity use balance CHP electricity -1
112112 Electricity use balance WWP electricity -1
113113 Electricity use balance TPP electricity output -1
114114 Electricity use balance TPE electricity -1
115115 Electricity use balance Ind electricity -1
116116 Electricity use balance STP electricity 1
117117 Electricity use balance TPP electricity input 1
118118 Electricity use balance Loss electricity 1
119119 Electricity use balance CES electricity 1
120120 Electricity use balance V electricity 1
121121 Electricity use balance Cons Ind electricity 1
122122 Electricity use balance Cons Traffic electricity 1
123123 Electricity use balance Cons Home electricity 1
124124 Electricity use balance Cons Commerce electricity 1
125125 Local heating balance STP local heating -1 In energy balance, inputs and outputs cancel out
126126 Local heating balance CHP local heating -1
127127 Local heating balance TPP local heating -1
128128 Local heating balance Loss local heating 1
129129 Local heating balance CES local heating 1
130130 Local heating balance Cons Ind local heating 1
131131 Local heating balance Cons Home local heating 1
132132 Local heating balance Cons Commerce local heating 1
133133 District heating balance Bought district heating -1 In energy balance, inputs and outputs cancel out
134134 District heating balance TPE district heating -1
135135 District heating balance Loss district heating 1
136136 District heating balance Cons Ind district heating 1
137137 District heating balance Cons Home district heating 1
138138 District heating balance Cons Commerce district heating 1
139139 Consumed electricity industry Cons Ind electricity 1 This must be given
140140 Consumed electricity traffic Cons Traffic electricity 1 This must be given
141141 Consumed electricity households Cons Home electricity 1 This must be given
142142 Consumed electricity commerce Cons Commerce electricity 1 This must be given
143143 Consumed local heating industry Cons Ind local heating 1 This must be given
144144 Consumed local heating households Cons Home local heating 1 This must be given
145145 Consumed local heating commerce Cons Commerce local heating 1 This must be given
146146 Consumed districit heating industry Cons Ind district heating 1 This must be given
147147 Consumed districit heating households Cons Home district heating 1 This must be given
148148 Consumed districit heating commerce Cons Commerce district heating 1 This must be given
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163Fraction CHP electricityCHP electricity2.852(977.7+244.6)/428.6 Others divided by electricity
164Balance H PlantsH biogas-1In energy balance, inputs and outputs cancel out.
165Balance H PlantsH oil-1
166Balance H PlantsH heat1
167Balance H PlantsH loss1
168Fraction H biogasH oil-1Amount of oil is used as comparison for biogas
169Fraction H biogasH biogas18.97370.2/3.7 Oil divided by biogas
170Fraction H lossH heat-1Amount of heat is used as comparison for loss.
171Fraction H lossH loss14.08269/4.9 Heat per loss
172Balance Industrial PlantsInd peat-1In energy balance, inputs and outputs cancel out.
173Balance Industrial PlantsInd oil-1
174Balance Industrial PlantsInd renewable-1
175Balance Industrial PlantsInd electricity1
176Balance Industrial PlantsInd process heat1
177Balance Industrial PlantsInd loss1
178Fraction Industrial peatInd oil-1Sum of other fuels is used as comparison for peat.
179Fraction Industrial peatInd renewable-1
180Fraction Industrial peatInd peat2.014(82.4+527.8)/303 Others divided by peat.
181Fraction Industrial oilInd peat-1
182Fraction Industrial oilInd renewable-1
183Fraction Industrial oilInd oil10.083(303+527.8)/82.4 Others divided by oil.
184Fraction Industrial electricityInd process heat-1Sum of other fuels is used as comparison for electricity
185Fraction Industrial electricityInd loss-1Heat loss = 104 = 303+82.4+527.8-123.8-685.4
186Fraction Industrial electricityInd electricity6.376(685.4+104)/123.8
187Fraction Industrial process heatInd electricity-1Sum of other fuels is used as comparison for process heat.
188Fraction Industrial process heatInd loss-1
189Fraction Industrial process heatInd process heat0.332(123.8+104)/685.4 Sum of other products divided by process heat.
190Fraction heat producersH heat-1CHP heat production is used as reference
191Fraction heat producersCHP heat0.08This number is based on guesswork.
192Transmission loss electricityLoss electricity1Known loss divided by production
193Transmission loss electricityCHP electricity-0.085847.4/(428.6+123.8)
194Transmission loss electricityInd electricity-0.0858
195Transmission loss heatLoss heat1Known loss divided by production
196Transmission loss heatCHP heat-0.085589.5/(977.7+69)
197Transmission loss heatInd process heat-0.0855
198Electricity use balanceBought electricity-1In energy balance, inputs and outputs cancel out.
199Electricity use balanceCHP electricity-1
200Electricity use balanceInd electricity-1
201Electricity use balanceLoss electricity1
202Electricity use balanceCons Home electricity1
203Electricity use balanceCons Ind electricity1
204Electricity use balanceCons Commerce electricity1
205Electricity use balanceCons Municip electricity1
206Heat use balanceCHP heat-1In energy balance, inputs and outputs cancel out.
207Heat use balanceH heat-1
208Heat use balanceLoss heat1
209Heat use balanceCons Home heat1
210Heat use balanceCons Ind heat1
211Heat use balanceCons Commerce heat1
212Heat use balanceCons Municip heat1
213Consumed industrial process heatInd process heat1This must be given.
214Consumed electricity homeCons Home electricity1This must be given.
215Consumed electricity industryCons Ind electricity1This must be given.
216Consumed electricity commerceCons Commerce electricity1This must be given.
217Consumed electricity municipalityCons Municip electricity1This must be given.
218Consumed heat homeCons Home heat1This must be given.
219Consumed heat industryCons Ind heat1This must be given.
220Consumed heat commerceCons Commerce heat1This must be given.
221Consumed heat municipalityCons Municip heat1This must be given.

A data table on an Opasnet page is used to enter the matrix data. This is rather user friendly. As a side effect, the table does not look like a matrix so it might be confusing in the beginning. The matrix is created by using the "Equation" as information about the row of the matrix and "Col" as information about the column of the matrix. "Result" is the actual value, and Description is anything useful for a reader (it is not used in calculations).

Dependencies

Formula

Amount of renewable fuels compared with peat (may be over 1):

Consumption of process heat produced by industry itself:

Consumption of electricity by households:

Consumption of electricity by industry:

Consumption of electricity by commerce:

Consumption of electricity by municipality:

Consumption of district heat by households:

Consumption of district heat by industry:

Consumption of district heat by commerce:

Consumption of district heat by municipality:

+ Show code

The model first creates the matrix and shows it to the user, and then it fills all empty cells with 0 and solves it by using the input values the user has given via the user interface. (The user interface can later be replaced by another model.) All the current input values are final consumptions, and the default values are based on the Kuopio data.

See also

Urgenche research project 2011 - 2014: city-level climate change mitigation
Urgenche pages

Urgenche main page · Category:Urgenche · Urgenche project page (password-protected)

Relevant data
Building stock data in Urgenche‎ · Building regulations in Finland · Concentration-response to PM2.5 · Emission factors for burning processes · ERF of indoor dampness on respiratory health effects · ERF of several environmental pollutions · General criteria for land use · Indoor environment quality (IEQ) factors · Intake fractions of PM · Land use in Urgenche · Land use and boundary in Urgenche · Energy use of buildings

Relevant methods
Building model · Energy balance · Health impact assessment · Opasnet map · Help:Drawing graphs · OpasnetUtils‎ · Recommended R functions‎ · Using summary tables‎

City Kuopio
 Climate change policies and health in Kuopio (assessment) · Climate change policies in Kuopio (plausible city-level climate policies) · Health impacts of energy consumption in Kuopio · Building stock in Kuopio · Cost curves for energy (prioritization of options) · Energy balance in Kuopio (energy data) · Energy consumption and GHG emissions in Kuopio by sector · Energy consumption classes (categorisation) · Energy consumption of heating of buildings in Kuopio · Energy transformations (energy production and use processes) · Fuels used by Haapaniemi energy plant · Greenhouse gas emissions in Kuopio · Haapaniemi energy plant in Kuopio · Land use in Kuopio · Building data availability in Kuopio · Password-protected pages: File:Heat use in Kuopio.csv · Kuopio housing

City Basel
 Buildings in Basel (password-protected)

Energy balances
Energy balance in Basel · Energy balance in Kuopio · Energy balance in Stuttgart · Energy balance in Suzhou


Keywords

References


Related files

<mfanonymousfilelist></mfanonymousfilelist>

Retrieved from "http://www.opasnet.org/testiwiki/index.php?title=Energy_balance_in_Stuttgart&oldid=26404"