Energy balance in Suzhou

[show] This page is a knowledge crystal of subtype variable. The page identifier is Op_en5816
Moderator:Jouni (see all)
This page is a stub. You may improve it into a full page.
Upload data {{#opasnet_base_link:Op_en5816}}

Question

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

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 Suzhou 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 4
You have invalid number of data cells in row 5
You have invalid number of data cells in row 6
You have invalid number of data cells in row 7
You have invalid number of data cells in row 8
You have invalid number of data cells in row 9
You have invalid number of data cells in row 10
You have invalid number of data cells in row 11
You have invalid number of data cells in row 12
You have invalid number of data cells in row 13
You have invalid number of data cells in row 14
You have invalid number of data cells in row 15
You have invalid number of data cells in row 16
You have invalid number of data cells in row 17
You have invalid number of data cells in row 18
You have invalid number of data cells in row 19
You have invalid number of data cells in row 20
You have invalid number of data cells in row 21
You have invalid number of data cells in row 22
You have invalid number of data cells in row 23
You have invalid number of data cells in row 24
You have invalid number of data cells in row 25
You have invalid number of data cells in row 26
You have invalid number of data cells in row 27
You have invalid number of data cells in row 28
You have invalid number of data cells in row 29
You have invalid number of data cells in row 30
You have invalid number of data cells in row 31
You have invalid number of data cells in row 32
You have invalid number of data cells in row 33
You have invalid number of data cells in row 34
You have invalid number of data cells in row 35
You have invalid number of data cells in row 36
You have invalid number of data cells in row 37
You have invalid number of data cells in row 38
You have invalid number of data cells in row 39
You have invalid number of data cells in row 40
You have invalid number of data cells in row 41
You have invalid number of data cells in row 42
You have invalid number of data cells in row 43
You have invalid number of data cells in row 44
You have invalid number of data cells in row 45
You have invalid number of data cells in row 46
You have invalid number of data cells in row 47
You have invalid number of data cells in row 48
You have invalid number of data cells in row 49
You have invalid number of data cells in row 50
You have invalid number of data cells in row 51
You have invalid number of data cells in row 52
You have invalid number of data cells in row 53
You have invalid number of data cells in row 54
You have invalid number of data cells in row 55
You have invalid number of data cells in row 56
You have invalid number of data cells in row 57
You have invalid number of data cells in row 58
You have invalid number of data cells in row 59
You have invalid number of data cells in row 60
You have invalid number of data cells in row 61
You have invalid number of data cells in row 62
You have invalid number of data cells in row 63
You have invalid number of data cells in row 64
You have invalid number of data cells in row 65
You have invalid number of data cells in row 66
You have invalid number of data cells in row 67
You have invalid number of data cells in row 68
You have invalid number of data cells in row 69
You have invalid number of data cells in row 70
You have invalid number of data cells in row 71
You have invalid number of data cells in row 72
You have invalid number of data cells in row 73
You have invalid number of data cells in row 74
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

Energy balance in Suzhou(-)
Obs	Equation	Col	Result	Description
1	Balance Thermal Power Plants	TP raw coal	-1	In energy balance, inputs and outputs cancle out
2	Balance Thermal Power Plants	TP natural gas	-1
3	Balance Thermal Power Plants	TP oil products	-1
4	4 Balance Thermal Power Plants TP coal products -1
5	5 Balance Thermal Power Plants TP other energy -1
6	6 Balance Thermal Power Plants TP heat -1
7	7 Balance Thermal Power Plants TP electricity 1
8	8 Balance Thermal Power Plants TP loss 1
9	9 Fraction TP raw coal TP natural Gas -1 Sum of other fuels is used as comparison for raw coal
10	10 Fraction TP raw coal TP oil products -1
11	11 Fraction TP raw coal TP coal products -1
12	12 Fraction TP raw coal TP other energy -1
13	13 Fraction TP raw coal TP heat -1
14	14 Fraction TP raw coal TP raw coal 0.12158311 (670,9+21,4+1145,5+198,0+54,7)/17194,0 Others divided by raw coal
15	15 Fraction TP natural gas TP raw coal -1 Sum of other fuels is used as comparison for natural gas
16	16 Fraction TP natural gas TP oil products -1
17	17 Fraction TP natural gas TP coal products -1
18	18 Fraction TP natural gas TP other energy -1
19	19 Fraction TP natural gas TP heat -1
20	20 Fraction TP natural gas TP natural Gas 27.74422418 (17194,0+21,4+1145,5+198,0+54,7)/670,9 Others divided by natural gas
21	21 Fraction TP oil products TP raw coal -1 Sum of other fuels is used as comparison for oil products
22	22 Fraction TP oil products TP natural gas -1
23	23 Fraction TP oil products TP coal products -1
24	24 Fraction TP oil products TP other energy -1
25	25 Fraction TP oil products TP heat -1
26	26 Fraction TP oil products TP oil products 900.1448598 (17194,0+670,9+1145,5+198,0+54,7)/21,4 Others divided by oil products
27	27 Fraction TP coal products TP raw coal -1 Sum of other fuels is used as comparison for coal products
28	28 Fraction TP coal products TP natural gas -1
29	29 Fraction TP coal products TP oil products -1
30	30 Fraction TP coal products TP other energy -1
31	31 Fraction TP coal products TP heat -1
32	32 Fraction TP coal products TP coal products 15.83500655 (17194,0+670,9+21,4+198,0+54,7)/1145,5 Others divided by coal products
33	33 Fraction TP other energy TP raw coal -1 Sum of other fuels is used as comparison for other energy
34	34 Fraction TP other energy TP natural gas -1
35	35 Fraction TP other energy TP oil products -1
36	36 Fraction TP other energy TP coal products -1
37	37 Fraction TP other energy TP heat -1
38	38 Fraction TP other energy TP other energy 96.39646465 (17194,0+670,9+21,4+1145,5+54,7)/198,0 Others divided by other energy
39	39 Fraction TP loss TP electricity -1 Amount of electricity is used as comparison for loss
40	40 Fraction TP loss TP loss 0.630948656 7460,4/11824,1 electricity per loss
41	41 Balance Heating Supply H raw coal -1 In energy balance, inputs and outputs cancle out
42	42 Balance Heating Supply H natural gas -1
43	43 Balance Heating Supply H oil products -1
44	44 Balance Heating Supply H coal products -1
45	45 Balance Heating Supply H other energy -1
46	46 Balance Heating Supply H heat 1
47	47 Balance Heating Supply H loss 1
48	48 Fraction H raw coal H natural gas -1 Sum of other fuels is used as comparison for raw coal
49	49 Fraction H raw coal H oil products -1
50	50 Fraction H raw coal H coal products -1
51	51 Fraction H raw coal H other energy -1
52	52 Fraction H raw coal H raw coal 0.158111641 (88,0+38,6+360,3+27,2)/3251,5 Others divided by raw coal
53	53 Fraction H natural gas H raw coal -1 Sum of other fuels is used as comparison for natural gas
54	54 Fraction H natural gas H oil products -1
55	55 Fraction H natural gas H coal products -1
56	56 Fraction H natural gas H other energy -1
57	57 Fraction H natural gas H natural gas 41.79090909 (3251,5+38,6+360,3+27,2)/88,0 Others divided by natural gas
58	58 Fraction H oil products H raw coal -1 Sum of other fuels is used as comparison for oil products
59	59 Fraction H oil products H natural gas -1
60	60 Fraction H oil products H coal products -1
61	61 Fraction H oil products H other energy -1
62	62 Fraction H oil products H oil products 96.55440415 (3251,5+88,0+360,3+27,2)/38,6 Others divided by oil products
63	63 Fraction H coal products H raw coal -1 Sum of other fuels is used as comparison for coal products
64	64 Fraction H coal products H natural gas -1
65	65 Fraction H coal products H oil products -1
66	66 Fraction H coal products H other energy -1
67	67 Fraction H coal products H coal products 9.451290591 (3251,5+88,0+38,6+27,2)/360,3 Others divided by coal products
68	68 Fraction H loss H heat -1 Amount of heat is used as comparison for loss
69	69 Fraction H loss H loss 4.451715651 3074,8/690,7 heat per loss
70	70 Balance Coal Processing CP raw coal -1 In energy balance, inputs and outputs cancle out
71	71 Balance Coal Processing CP natural gas -1
72	72 Balance Coal Processing CP oil products -1
73	73 Balance Coal Processing CP coal products 1
74	74 Balance Coal Processing CP loss 1
75	75 Fraction CP raw coal CP natural gas -1 Sum of other fuels is used as comparison for raw coal
76	76 Fraction CP raw coal CP oil products -1
77	77 Fraction CP raw coal CP raw coal 0.004725972 (0,007+0,0172)/5,12064 Others divided by raw coal
78	78 Fraction CP natural gas CP oil products -1 Amount of oil products is used as comparison for natural gas
79	79 Fraction CP natural gas CP natural gas 24.57142857 0,01720/0,0007 oil products divided by natural gas
80	80 Fraction CP loss CP coal products -1 Amount of coal products is used as comparison for loss
81	81 Fraction CP loss CP loss 6.341763109 4,4386/0,6999 coal products per loss
82	82 Transmission loss heat Loss heat 1 Known loss divided by production
83	83 Transmission loss heat H heat 0.029823078 91,7/3074,8
84	84 Transmission loss oil products Loss oil products 1 Known loss divided by oil products used in TP
85	85 Transmission loss oil products TP oil products 0.953271028 20,4/21,4
86	86 Transmission loss electricity Loss electricity 1 Known loss divided by production
87	87 Transmission loss electricity TP electricity 0.085276929 636,2/7460,4
88	88 Transmission loss natural gas Loss natural gas 1 Known loss divided by natural gas used in H
89	89 Transmission loss natural gas H natural gas 0.3625 31,9/88,0
90	90 Electricity use balance Bought electricity -1 In energy balance, inputs and outputs cancle out
91	91 Electricity use balance TP electricity -1
92	92 Electricity use balance Loss electricity 1
93	93 Electricity use balance Cons Agri electricity 1
94	94 Electricity use balance Cons Ind electricity 1
95	95 Electricity use balance Cons Transportation electricity 1
96	96 Electricity use balance Cons Commerce electricity 1
97	97 Electricity use balance Cons Households electricity 1
98	98 Heat use balance H heat -1 In energy balance, inputs and outputs cancle out
99	99 Heat use balance Loss heat 1
100	100 Heat use balance Cons Ind heat 1
101	101 Heat use balance Cons Commerce heat 1
102	102 Consumed electricity agriculture Cons Agri electricity 1 This must be given
103	103 Consumed electricity industry Cons Ind electricity 1 This must be given
104	104 Consumed electricity transportation Cons Transportation electricity 1 This must be given
105	105 Consumed electricity commerce Cons Commerce electricity 1 This must be given
106	106 Consumed electricity households Cons Households electricity 1 This must be given
107	107 Consumed heat industry Cons Ind heat 1 This must be given
108	108 Consumed heat commerce Cons Commerce heat 1 This must be given
109
110

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

+ Show code - Hide code

library(OpasnetUtils)
library(xtable)

dependencies <- data.frame(Name = c(
	"Frac_CHP_renew",
	"Ind_process_heat",
	"Cons_Home_electricity",
	"Cons_Ind_electricity",
	"Cons_Commerce_electricity",
	"Cons_Municip_electricity",
	"Cons_Home_heat",
	"Cons_Ind_heat",
	"Cons_Commerce_heat",
	"Cons_Municip_heat"
), Key = "k5NNrR2Q0VCJharl")

formula <- function(dependencies, ...) {

	ComputeDependencies(dependencies, ...)

	## Define the energy transformation matrix ETM.

	# Get the data from Opasnet Base.

	ETM <- tidy(op_baseGetData("opasnet_base", "Op_en5469"), objname = "ETM", direction = "wide")

	# Add user-defined data to it.

	additions <- data.frame(
		Equation = "Fraction CHP renewable",
		Col = "CHP peat",
		ETMResult = Frac_CHP_renew,
		ETMDescription = "Renewable amount divided by peat. BAU: 78.1/1435.7 = 0.0544 Actual number given by user."
	)
	ETM <- rbind(ETM, additions)

	# Reshape the table to make a matrix, and replace NA with 0.

	ETM <- reshape(ETM, timevar = "Col", idvar = "Equation", v.names = "ETMResult", direction = "wide")
	colnames(ETM) <- gsub("ETMResult.", "", colnames(ETM))

	print(xtable(ETM), type = 'html') # Show the matrix with explanations.

	ETM <- as.matrix(ETM[, !colnames(ETM) %in% c("Equation", "ETMDescription")])

	for(i in 1:ncol(ETM)) {
		ETM[is.na(ETM[, i]), i] <- 0
	}

	# Define the outputs for equations (for most equations, it is a zero sum game).

	out <- c(rep(0, 18), # Define the consumptions (and other known variables).
		Ind_process_heat,
		Cons_Home_electricity,
		Cons_Ind_electricity,
		Cons_Commerce_electricity,
		Cons_Municip_electricity,
		Cons_Home_heat,
		Cons_Ind_heat,
		Cons_Commerce_heat,
		Cons_Municip_heat
	)

	out <- solve(ETM, out) # Solve the matrix.
	out <- data.frame(Energy.class = colnames(ETM), Result = out)

	return(out)
}

energy.balance.Kuopio <- new("ovariable",
	name = "energy.balance.Kuopio",
	output = formula(dependencies)
)

print(xtable(energy.balance.Kuopio@output), type = 'html')
#temp <- EvalOutput(energy.balance.Kuopio)
#print(xtable(temp@output), type = 'html')

objects.put(energy.balance.Kuopio)
#	Ind_process_heat,
#	Cons_Home_electricity,
#	Cons_Ind_electricity,
#	Cons_Commerce_electricity,
#	Cons_Municip_electricity,
#	Cons_Home_heat,
#	Cons_Ind_heat,
#	Cons_Commerce_heat,
#	Cons_Municip_heat
#)

cat("Object energy.balance.Kuopio saved. Write down the key of the model run page for further use.\n")

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.

Keywords

References

Related files