-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathGR_PRICE_USER.inc
46 lines (45 loc) · 16.3 KB
/
GR_PRICE_USER.inc
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
* -----------------------------------------------------
* XLS2GMS Version 1.5, August 2002
* Erwin Kalvelagen, GAMS Development Corp.
* -----------------------------------------------------
* Application: Microsoft Excel
* Version: 16.0
* Workbook: \\nmbu.no\my\home\Documents\Prosjekter\Flex4RES\taxes\Grid_rent_data.xlsx
* Sheet: 3
* Range: $A$3:$Q$37
* -----------------------------------------------------
TABLE GR_PRICE_USER(CCC,DEUSER,GRDATASET) 'Data on grid tariff rates for user groups'
GRDFC GRDSUBS GRDECW GRDECS GRDTOU1 GRDTOU2 GRDTOU3 GRDTOU4 GRDDCW GRDDCS GRDDC2 GRDDCTOU GRDDCY
*** description Fixed component Subscribed Power Energy charge winter ** Energy charge summer TOU energy charge 1 TOU energy charge 2 TOU energy charge 3 TOU energy charge 4 Demand charge winter ** Demand charge summer Demand charge 2 Demand charge TOU Demand charge with yearly calculation
*** unit €/Y €/kW €/MWh €/MWh €/MWh €/MWh €/MWh €/MWh €/kW-peak/month €/kW-peak/month €/kW-peak/month €/kW-peak/month €/kW-peak/year Source:
DENMARK.RESE 56.415 43.99 !! Lucien data collection
DENMARK.IND 329.07 23.34 !! Lucien data collection
DENMARK.SERV 148.42 36.98 !! Lucien data collection
ESTONIA.RESE 54 !! Lucien data collection
ESTONIA.IND 121 2.04 9.6 34.2 !! https://www.elektrilevi.ee/-/doc/6305157/kliendile/el_hinnakiri_vorguteenused_01112017_est.pdf
ESTONIA.SERV 54 !! Lucien data collection
FINLAND.RESE 80 25.7 !! Average of Helsinki, Oulo and Turku tariff
FINLAND.IND 3524 11.7 8.7 8.7 2.2 !! Average of Helsinki, Oulo and Turku tariff
FINLAND.SERV 80 25.7 !! Average of Helsinki, Oulo and Turku tariff
LATVIA.RESE 56.4 !! Eurostat (2015 data, 5000 to 14999 kWh/y)
LATVIA.IND 21.29 19.56 !! Daniel and Eli data collection
LATVIA.SERV 56.4 !! Eurostat (2015 data, 5000 to 14999 kWh/y)
LITHUANIA.RESE 31.4 !! Eurostat (2015 data, 5000 to 14999 kWh/y)
LITHUANIA.IND 19 6.96 !! Daniel and Eli data collection
LITHUANIA.SERV 31.4 !! Eurostat (2015 data, 5000 to 14999 kWh/y)
NORWAY.RESE 175 19.46 !! https://www.nve.no/reguleringsmyndigheten-for-energi-rme-marked-og-monopol/nettjenester/nettleie/nettleiestatistikk/nettleiestatistikk-for-husholdninger/
NORWAY.IND 2282 6.4 34.18 !! https://www.nve.no/reguleringsmyndigheten-for-energi-rme-marked-og-monopol/nettjenester/nettleie/nettleiestatistikk/nettleiestatistikk-for-naeringskunder/
NORWAY.SERV 175 19.46 !! https://www.nve.no/reguleringsmyndigheten-for-energi-rme-marked-og-monopol/nettjenester/nettleie/nettleiestatistikk/nettleiestatistikk-for-husholdninger/
SWEDEN.RESE 349.2 15.28 !! https://www.ei.se/sv/Publikationer/Arsrapporter/elnatsforetag-arsrapporter/
SWEDEN.IND 12558 32 2.69 !! https://www.ei.se/sv/Publikationer/Arsrapporter/elnatsforetag-arsrapporter/
SWEDEN.SERV 349.2 15.28 !! https://www.ei.se/sv/Publikationer/Arsrapporter/elnatsforetag-arsrapporter/
GERMANY.RESE 165.15375 26.1075 !! Average of Nordic countries
GERMANY.IND 5470.35666666667 11.6075 !! Average of Nordic countries
GERMANY.SERV 165.15375 26.1075 !! Average of Nordic countries
;
* it assumed that an average P2H connection is 10 MW, therefore the fixed component is divided by 10 to get the price per MW
** for the whole year if no entered value for summer
GR_PRICE_USER('NETHERLANDS',DEUSER,GRDATASET) = GR_PRICE_USER('GERMANY',DEUSER,GRDATASET);
GR_PRICE_USER('UNITED_KINGDOM',DEUSER,GRDATASET) = GR_PRICE_USER('GERMANY',DEUSER,GRDATASET);
GR_PRICE_USER('POLAND',DEUSER,GRDATASET) = GR_PRICE_USER('GERMANY',DEUSER,GRDATASET);
* -----------------------------------------------------