Skip to content

Instantly share code, notes, and snippets.

@jarek

jarek/2018-03-24 analysis of HVDC_RTX_20180302-20180302.csv

Created March 24, 2018 21:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jarek/e8b2c15321da87f754530c39921badbf to your computer and use it in GitHub Desktop.
Save jarek/e8b2c15321da87f754530c39921badbf to your computer and use it in GitHub Desktop.
Download ZIP
Philippines - Visayas electricity on 2018-03-02
Raw
2018-03-24 analysis of HVDC_RTX_20180302-20180302.csv
DATE HOUR ID RUN TYPE HVDC RTX MW scraped: Vis demand generation total MPS load ex-post sum MPS gen ex-post sum Luzon demand generation total
2018/02/03 1 2018/03/02 HVDC RTX 162.33 1309.1 1053 256.0999999999999 1259.2 1440.1 7565 6866 699
2018/02/03 2 2018/03/02 01:00:00 HVDC RTX 198.96 1244.2 979 265.20000000000005 1417 7300 6634 666
2018/02/03 3 2018/03/02 02:00:00 HVDC RTX 219.89 1193.7 1010 183.70000000000005 1417.6 7251 6503 748
2018/02/03 4 2018/03/02 03:00:00 HVDC RTX 237.99 1195.7 1012 183.70000000000005 1419.9 7185 6438 747
2018/02/03 5 2018/03/02 04:00:00 HVDC RTX 201.86 1226.8 1014 212.79999999999995 1422.3 7221 6503 718
2018/02/03 6 2018/03/02 05:00:00 HVDC RTX 161.9 1283.3 1062 221.29999999999995 1427.5 7394 6674 720
2018/02/03 7 2018/03/02 06:00:00 HVDC RTX 247.21 1206 1031 175 1442.4 7073 6318 755
2018/02/03 8 2018/03/02 07:00:00 HVDC RTX 195.92 1307.2 1124 183.20000000000005 1544.1 7609 6627 982
2018/02/03 9 2018/03/02 08:00:00 HVDC RTX 204.76 1578.7 1366 212.70000000000005 1782.7 8573 7462 1111
2018/02/03 10 2018/03/02 09:00:00 HVDC RTX 123.67 1707.2 1454 253.20000000000005 1854.3 9072 7938 1134
2018/02/03 11 2018/03/02 10:00:00 HVDC RTX 124.22 1762.3 1520 242.29999999999995 1925 9377 8244 1133
2018/02/03 12 2018/03/02 11:00:00 HVDC RTX 137.18 1768.3 1522 246.29999999999995 9148 8018 1130
2018/02/03 13 2018/03/02 12:00:00 HVDC RTX 131.14 1750.1 1508 242.0999999999999 9193 8061 1132
2018/02/03 14 2018/03/02 13:00:00 HVDC RTX 68.64 1831.1 1517 314.0999999999999 9661 8578 1083
2018/02/03 15 2018/03/02 14:00:00 HVDC RTX 80.51 1819.7 1465 354.70000000000005 9526 8465 1061
2018/02/03 16 2018/03/02 15:00:00 HVDC RTX 70.32 1779.2 1397 382.20000000000005 9321 8249 1072
2018/02/03 17 2018/03/02 16:00:00 HVDC RTX 110.5 1686.4 1321 365.4000000000001 8909 7805 1104
2018/02/03 18 2018/03/02 17:00:00 HVDC RTX 38.27 1692.8 1264 428.79999999999995 8635 7595 1040
2018/02/03 19 2018/03/02 18:00:00 HVDC RTX -15.83 1776.6 1320 456.5999999999999 8946 8160 786
2018/02/03 20 2018/03/02 19:00:00 HVDC RTX 38.1 1727.5 1282 445.5 8760 8023 737
2018/02/03 21 2018/03/02 20:00:00 HVDC RTX 84.87 1662.9 1276.7 386.20000000000005 8483 7687 796
2018/02/03 22 2018/03/02 21:00:00 HVDC RTX 130.41 1547.7 8180
2018/02/03 23 2018/03/02 22:00:00 HVDC RTX 110.87 1449.2 7861
2018/02/03 24 2018/03/02 23:00:00 HVDC RTX 154.44
Visayas in first reported hour: hour biomass coal gas geothermal hydro oil solar unknown wind sum
MPS gen ex-post sum: 1 50.4 766.9 0 599.8 7.4 1.1 0 0 14.5 1440.1
scraped from pie chart: 46.2 437 0 547.8 7.8 0 0 0 14.5 1053.3 1383.1999999999998
second hour: 2 50.1 746 0 599.8 6.6 0.9 0 0 13.6 1417
scraped: 46.2 365 0 547.8 7 0 0 0 13.6 979.5999999999999 1360.6
Visayas
hour MPS RTX biomass chart biomass MPScoal chart coal MPSgeothermal chart geothermal MPShydro chart hydro MPSoil chart oil MPSsolar chart solar MPSwind chart wind sum MPS RTX sum chart scraped demand HVDC RTX sum chart + HVDC coal difference MPS RTX geothermal difference MPS RTX
1 50.4 46.2 766.9 437 599.8 547.8 7.4 7.8 1.1 0 0 0 14.5 14.5 1440.1 1053.3 1309.1 162.33 1215.6299999999999 -329.9 -52
2 50.1 46.2 746 365 599.8 547.8 6.6 7 0.9 0 0 0 13.6 13.6 1417 979.6 1244.2 198.96 1178.56 -381 -52
3 50 46.2 747 396 599.8 547.8 6.6 7 0.9 0 0 0 13.3 13.3 1417.6 1010.3 1193.7 219.89 1230.19 -351 -52
4 50.3 46.2 749 398 599.8 547.8 6.7 7 0.9 0 0 0 13.2 13.2 1419.9 1012.2 1195.7 237.99 1250.19 -351 -52
5 50.3 46.2 751 400 599.8 547.8 6.7 7 1.1 0 0 0 13.4 13.4 1422.3 1014.4 1226.8 201.86 1216.26 -351 -52
6 50.7 46.7 751 440 599.8 547.8 6.7 7 1 0 2.9 5.2 15.4 15.4 1427.5000000000002 1062.1000000000001 1283.3 161.9 1224.0000000000002 -311 -52
7 50.7 46.7 700 350 599.8 547.8 6.7 7 1.3 0 68.3 64.3 15.6 15.6 1442.3999999999999 1031.3999999999999 1206 247.21 1278.61 -350 -52
8 50.4 46.7 709.9 353.7 599.8 547.8 6.7 7 0.8 0 155.6 148.6 20.9 20.9 1544.1 1124.7 1307.2 195.92 1320.6200000000001 -356.2 -52
9 49.8 47.7 749.3 395 599.8 547.8 6.7 7 130.9 129.5 224.2 217.6 22 22 1782.7 1366.6 1578.7 204.76 1571.36 -354.29999999999995 -52
10 51.6 48.7 780.6 430.6 575.5 545.5 6.6 7 122 121.5 291.4 274.4 26.6 26.6 1854.2999999999997 1454.2999999999997 1707.2 123.67 1577.9699999999998 -350 -30
11 51.9 48.8 776.2 421.2 575.5 545.5 6.6 7 144.1 146.3 341.3 322.1 29.4 29.4 1924.9999999999998 1520.3000000000002 1762.3 124.22 1644.5200000000002 -355.00000000000006 -30
12 51.5 48.2 748.3 419.2 575.5 545.5 6.6 7 144 143.5 337.6 330.1 29 29 1892.5 1522.5 1768.3 137.18 1659.68 -329.09999999999997 -30
13 51.6 48.7 755.3 421.3 575.5 545.5 6.6 7 144 143.5 324.7 313 29.3 29.3 1887 1508.3 1750.1 131.14 1639.44 -333.99999999999994 -30
14 51.9 48.7 818.7 470 575.5 548.8 6.5 7 146.8 146.3 283.6 269.3 27.1 27.1 1910.1 1517.1999999999998 1831.1 68.64 1585.84 -348.70000000000005 -26.700000000000045
15 52.5 48.2 844.3 470 575.5 545.5 6.6 7 144.4 146.3 234.6 221.5 27.3 27.3 1885.1999999999998 1465.8 1819.7 80.51 1546.31 -374.29999999999995 -30
16 51.2 48.2 871.4 470 575.5 547.8 6.6 7 157.7 159.3 136 137.3 28.2 28.2 1826.6 1397.8 1779.2 70.32 1468.12 -401.4 -27.700000000000045
17 51.6 48.2 865.8 470 599.8 547.8 6.6 7 172 164.9 62 59.5 23.9 23.9 1781.6999999999998 1321.3000000000002 1686.4 110.5 1431.8000000000002 -395.79999999999995 -52
18 52.2 48.7 883.4 470 609.3 557.3 6.6 7 154.6 146.9 8.5 10.3 23.8 23.8 1738.3999999999999 1264 1692.8 38.27 1302.27 -413.4 -52
19 52.2 48.7 883.4 470 609.3 557.3 6.6 7 201.4 207.5 3.5 3.5 26.3 26.3 1782.7 1320.3 1776.6 -15.83 1304.47 -413.4 -52
20 52.6 48.7 883.4 470 609.3 557.3 6.6 7 187.3 175.2 0 0 24.5 24.5 1763.6999999999998 1282.7 1727.5 38.1 1320.8 -413.4 -52
21 52.3 48.2 881.3 470 609.3 557.3 6.6 7 172.6 173.8 0 0 20.4 20.4 1742.4999999999998 1276.7 1662.9 84.87 1361.5700000000002 -411.29999999999995 -52
22 52.3 872.8 599.8 6.6 133.9 0 17.4 1682.8 0 1547.7 130.41 130.41
23 51.6 853.2 599.8 6.6 19.6 0 17.9 1548.6999999999998 0 1449.2 110.87 110.87
24 51.5 836.3 599.8 6.6 1.1 0 15.4 1510.6999999999998 0 154.44 154.44
in MPS RTD file:
hour MPS RTD biomass chart biomass MPS RTD coal chart coal MPS RTD geothermal chart geothermal MPS RTD hydro chart hydro MPS RTD oil chart oil MPS RTD solar chart solar MPS RTD wind chart wind sum MPS RTD sum chart scraped demand HVDC RTX sum chart + HVDC coal difference MPS RTD geothermal difference MPS RTD
1 46.2 46.2 813 437 599.8 547.8 7.8 7.8 0 0 0 0 14.5 14.5 1481.3 1053.3 1309.1 162.33 1215.6299999999999 -376 -52
2 46.2 46.2 716 365 599.8 547.8 7 7 0 0 0 0 13.6 13.6 1382.6 979.6 1244.2 198.96 1178.56 -351 -52
3 46.2 46.2 747 396 599.8 547.8 7 7 0 0 0 0 13.3 13.3 1413.3 1010.3 1193.7 219.89 1230.19 -351 -52
4 46.2 46.2 749 398 599.8 547.8 7 7 0 0 0 0 13.2 13.2 1415.2 1012.2 1195.7 237.99 1250.19 -351 -52
5 46.2 46.2 751 400 599.8 547.8 7 7 0 0 0 0 13.4 13.4 1417.4 1014.4 1226.8 201.86 1216.26 -351 -52
6 46.7 46.7 801.8 440 599.8 547.8 7 7 0 0 5.2 5.2 15.4 15.4 1475.9 1062.1000000000001 1283.3 161.9 1224.0000000000002 -361.79999999999995 -52
7 46.7 46.7 701 350 599.8 547.8 7 7 0 0 64.3 64.3 15.6 15.6 1434.3999999999999 1031.3999999999999 1206 247.21 1278.61 -351 -52
8 46.7 46.7 704.7 353.7 599.8 547.8 7 7 0 0 148.6 148.6 20.9 20.9 1527.7 1124.7 1307.2 195.92 1320.6200000000001 -351.00000000000006 -52
9 47.7 47.7 746 395 588.1 547.8 7 7 129.5 129.5 217.6 217.6 22 22 1757.9 1366.6 1578.7 204.76 1571.36 -351 -40.30000000000007
10 48.7 48.7 776.6 430.6 575.5 545.5 7 7 121.5 121.5 274.4 274.4 26.6 26.6 1830.3000000000002 1454.2999999999997 1707.2 123.67 1577.9699999999998 -346 -30
11 48.7 48.8 767.2 421.2 575.5 545.5 7 7 146.3 146.3 322.1 322.1 29.4 29.4 1896.2000000000003 1520.3000000000002 1762.3 124.22 1644.5200000000002 -346.00000000000006 -30
12 48.2 48.2 765.2 419.2 575.5 545.5 7 7 143.5 143.5 330.1 330.1 29 29 1898.5 1522.5 1768.3 137.18 1659.68 -346.00000000000006 -30
13 48.7 48.7 767.3 421.3 575.5 545.5 7 7 143.5 143.5 313 313 29.3 29.3 1884.3 1508.3 1750.1 131.14 1639.44 -345.99999999999994 -30
14 48.7 48.7 819.1 470 587.7 548.8 7 7 146.3 146.3 269.3 269.3 27.1 27.1 1905.1999999999998 1517.1999999999998 1831.1 68.64 1585.84 -349.1 -38.90000000000009
15 48.2 48.2 853 470 575.5 545.5 7 7 146.3 146.3 221.5 221.5 27.3 27.3 1878.8 1465.8 1819.7 80.51 1546.31 -383 -30
16 48.2 48.2 883.4 470 588.2 547.8 7 7 159.3 159.3 137.3 137.3 28.2 28.2 1851.6000000000001 1397.8 1779.2 70.32 1468.12 -413.4 -40.40000000000009
17 48.2 48.2 876.4 470 599.8 547.8 7 7 171.3 164.9 59.5 59.5 23.9 23.9 1786.1000000000001 1321.3000000000002 1686.4 110.5 1431.8000000000002 -406.4 -52
18 48.7 48.7 883.4 470 609.3 557.3 7 7 153.3 146.9 10.3 10.3 23.8 23.8 1735.8 1264 1692.8 38.27 1302.27 -413.4 -52
19 48.7 48.7 883.4 470 609.3 557.3 7 7 213.9 207.5 3.5 3.5 26.3 26.3 1792.1000000000001 1320.3 1776.6 -15.83 1304.47 -413.4 -52
20 48.7 48.7 883.4 470 609.3 557.3 7 7 181.6 175.2 0 0 24.5 24.5 1754.5 1282.7 1727.5 38.1 1320.8 -413.4 -52
21 48.2 48.2 883.4 470 609.3 557.3 7 7 180.2 173.8 0 0 20.4 20.4 1748.5000000000002 1276.7 1662.9 84.87 1361.5700000000002 -413.4 -52
22 48.2 879.8 599.8 7 132.4 0 17.4 1684.6000000000001 0 1547.7 130.41 130.41
23 47.7 852.2 599.8 7 70.9 0 17.9 1595.5000000000002 0 1449.2 110.87 110.87
24 47.2 820.5 599.8 7 0 0 15.4 1489.9 0 154.44 154.44
@jarek
Copy link
Author

jarek commented Mar 24, 2018

See https://github.com/tmrowco/electricitymap/issues/679#issuecomment-375926727 for context

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment