search

OSeMOSYS / osemosys_global

A global power system model generator for OSeMOSYS
https://osemosys-global.readthedocs.io/
GNU Affero General Public License v3.0
27 stars 17 forks source link

Duplicate Transmission Technology Values Being Created #48

Closed trevorb1 closed 3 years ago

trevorb1 commented 3 years ago

The following transmission technology has duplicate Output Activity Ratio values being created

OutputActivityRatio := GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2015 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2015 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2015 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2015 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2016 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2016 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2016 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2016 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2017 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2017 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2017 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2017 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2018 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2018 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2018 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2018 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2019 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2019 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2019 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2019 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2020 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2020 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2020 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2020 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2021 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2021 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2021 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2021 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2022 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2022 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2022 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2022 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2023 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2023 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2023 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2023 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2024 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2024 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2024 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2024 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2025 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2025 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2025 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2025 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2026 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2026 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2026 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2026 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2027 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2027 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2027 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2027 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2028 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2028 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2028 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2028 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2029 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2029 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2029 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2029 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2030 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2030 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2030 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2030 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2031 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2031 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2031 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2031 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2032 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2032 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2032 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2032 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2033 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2033 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2033 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2033 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2034 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2034 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2034 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2034 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2035 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2035 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2035 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2035 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2036 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2036 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2036 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2036 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2037 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2037 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2037 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2037 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2038 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2038 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2038 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2038 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2039 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2039 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2039 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2039 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2040 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2040 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2040 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2040 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2041 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2041 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2041 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2041 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2042 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2042 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2042 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2042 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2043 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2043 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2043 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2043 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2044 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2044 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2044 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2044 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2045 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2045 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2045 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2045 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2046 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2046 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2046 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2046 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2047 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2047 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2047 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2047 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2048 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2048 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2048 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2048 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2049 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2049 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2049 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2049 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2050 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSI01 1 2050 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2050 0.966 GLOBAL TRNCHNSCCHNSI ELCCHNSC01 2 2050 0.966

tniet commented 3 years ago

Hey All - found the error. In the Costs Line Expansion.xlsx we have two entries for this line, so the script enters it twice to match. I can remove duplicates in the script but before doing so thought I would check with @maartenbrinkerink to make sure it isn't better to update the source data. @maartenbrinkerink or @abhishek0208 - let me know if you want to update the source or if I should remove this in the OPG_powerplantsdata.py script. image

maartenbrinkerink commented 3 years ago

Thanks @tniet. I've updated the source file on the Harvard Dataverse. Correct link is; https://dataverse.harvard.edu/api/access/datafile/4551443?format=original&gbrecs=true

Also note that the duplicate entry was not on the 'Interface' sheet but only on the 'Lines' sheet. The 'Interface' sheet is the sheet you want to be working with given it provides costs per MW.

trevorb1 commented 3 years ago

I have updated the Costs Line Expansion.xlsx file to the link above and updated the OPG_powerplant_data.py script to read from the Interface sheet in pull request #49