Cambium API and GREET Excel Integration #380
Conversation
…class, added another test for processing and saving GREET data to non-default filename
…_init__, added cambium_data.py, updated pyproject.toml to include pytest-dependency, added test_cambium_resource.py, updated tests/hopp/utils.py with default cambium file
…g any tests which make API calls
|
After thought for the cambium api integration, it will likely be useful to allow users to input the specific data columns / variables they want to pull from the API as an argument instead of pulling a preset list of "most" variables available. However, this can be added as a follow up PR, I'd prefer to get this in as is for now given the NAWEA release. Open to other's opinions. |
hopp/simulation/resource_files/greet/2023/ccs_central_h2_prod/GREET1_2023_Rev1.xlsm
Outdated
Show resolved
Hide resolved
hopp/simulation/resource_files/greet/2023/no_ccs_central_h2_prod/GREET1_2023_Rev1.xlsm
Outdated
Show resolved
Hide resolved
|
Flagging dates of possible Cambium API slow downs due to database updates (James Morris): "Late-Nov or early-Dec we'll be uploading the new Standard Scenarios which might make the db a little slow as we're bulk writing records. January will be Cambium which is larger and will almost definitely slow the db down a bit during the couple of days/week we're ingesting that project." |
Co-authored-by: John Jasa <[email protected]>
Co-authored-by: John Jasa <[email protected]>
Co-authored-by: John Jasa <[email protected]>
Co-authored-by: John Jasa <[email protected]>
…o hopp_lca_pr pulling latest updates into branch
Cambium and GREET integration
Added:
cambium_data.py: to manage the Cambium API call and parsing of data
greet_data.py: to handle manipulation and extraction of data from GREET excel docs
resource_files/cambium/: directory that stores cambium resource files, files currently in this folder are defaults for testing
resource_files/greet/: directory that stores 2023 versions of GREET, a preprocessed yaml file with relevant data points to be used in GreenHEART LCA analysis, and associated README.md
tests/hopp/test_cambium_resource.py: pytests for cambium integration
tests/hopp/test_greet_resource.py: pytests for greet integration
Edited:
tests/hopp/utils.py: created default file paths for cambium and greet testing
hopp/simulation/technologies/resource/init.py: made cambium and greet data classes importable
pyproject.toml: added "pytest-dependency" under develop dependencies, used in cambium pytests
Related issue
#375
Impacted areas of the software
pyproject.toml, pytest suite, and resources
Additional supporting information
This work is being completed for the LCA integration, the data pulling and parsing will live in HOPP, the LCA calculations with that data will live in GreenHEART
NOTE:
Additional variables can possibly be added to the Cambium API call to pull curtailment, end use costs, busbar costs, clean energy fractions, distribution losses, transmissions totals, and various load values if needed.
Spoke with Cambium API folks (James Morris). 1) they do not have any plans in FY25 to add a bulk requests functionality to the API but will let us know when it becomes available. 2) Communicated possible increased API requests from this integration so they can monitor system health / computational resources needed.
Many more data points can be extracted from GREET excel, but requires time and effort to interpret GREET calculations and determine proper values.
Test results, if applicable
tests/hopp/test_cambium_resource.py .....
tests/hopp/test_greet_resource.py ...