ERTAC EGU Code v2.2 Available

It is exciting that the new version of the ERTAC EGU code, v2.2, is now available. I have worked on developing the new features for this open source python codebase, that uses EPA and state data to project future emissions from power plants. It was great to work with partners in several states and regional organizations to then test and evaluate the new code.

Full details of the new features are in a README, but some of the things I am particularly excited about are the so called “HIZG” hours and the new fuel/unit types and state input files.

We have found in previous versions that in projections, emissions from startup and shutdowns don’t get maintained. This because in the hourly Clean Air Markets Data (CAMD) that ERTAC EGU relies upon startups and shutdowns have heat input and emissions, but no gross load, though Heat Input Zero Gross load (HIZG). Since there ERTAC EGU projects by growing or shrinking generations due to supplied changes in demand, hours with no generation were simply dropped from consideration. With ERTAC v2.2 those hours can now be maintained. This not only allows startups and shutdowns to be projected to future years, it also is one of two necessary requirements to allow ERTAC EGU to process so called “non-EGUs,” essentially units in CAMD that do not generate power (e.g., oil refineries, steel mills, pulp mills).

The other major improvement is the ability to add new fuel unit types. The code was originally written to limit the user to five fuel/unit types. However, a new input allows users to add fuel/unit types. This was particularly useful to the group to allow non-EGUs to be processed. It also allows some types of power generators to be projected, such as various biomass facilities that were ignored in the original code. With incorporation of other data sources and extensive use of the “demand transfer” functionality one might be able to include renewables, though this was never tested. Also the ability to override the default state.csv file was included, which could allow this tool to be used to subdivide states (for instance to include EGUs within, and outside of, a nonattainment area in a state) or allow this tool to be used in other countries where hourly power plant data can be found.

This is all quite exciting. The new code base is available on github: https://github.com/bukim1/ERTAC-EGU-Emission-Projection-Tool. I hope others can put the code to good use.

Development of a Fuel Economy Based Vehicle Excise Tax in the District of Columbia

Development of a Fuel Economy Based Vehicle Excise Tax in the District of Columbia
2nd Annual Transportation, Air Quality, and Health Symposium – CARTEEH
May 18, 2021
A presentation given to the 2nd Annual Transportation, Air Quality, and Health Symposium – CARTEEH on a project I completed in R.

View the Presentation

Add Birthday Song to Google Contacts R Script

One of my favorite music columns of the past several years is The Number Ones on Stereogum.  The column is reviewing every single Billboard Hot 100 Number of Hit of all time.  I was looking through my contacts and thought it would be nice to know what someone’s #1 Birthday Song was, because that is the type of person I am (mine was Blondie’s “Call Me” – Tom Breihan gave it a 10/10). 

I thought it would be interesting to have that available for my friends and other network folks,  but I would never want to manually add that information.  So using rvest, I threw together a script that takes a csv downloaded from google contacts, finds every entry with a complete birth date (month, date, and year), and adds a custom field with the song’s name and title.  This data is then exported to a new csv. 

One then needs to make a minor edit to the header so that it looks like the next image (the single “.”s need to be replaced with a ” ” and a the “…”s need to be replaced with a ” – “).  Then the file can be re-imported into google contacts.  You then need to run “merge and fix” on all of these “new” contacts and voila you now can tell your friends what their #1 Birthday Song is.

The script is available here.

Code!!!!!

I was able to make a little time to post links to the code repositories that are up on Git Hub that I have been working on.  The first is ERTAC EGU, which is a python-based power plant projection tool that I contribute code to.  The second is r4movess, which is an R library I developed for accessing data from EPA’s MOVES model.

You can check out the code through here.