PI2 Data Processing Macro
At Nuvera Fuel Cells, the original PI2 processing macro was written in Excel 2010. When running the macro on the newest version, Excel 2019, data from the PI2 test bench got scrambled and was improperly graphed. I was tasked with adapting and upgrading the macro to a more robust python environment.
-
Recreated functionality of original code while adding QOL changes, such as processing multiple files
-
Created menu option where one could select how the data should be processed, which could allow for the macro to be the go-to for most processing needs
-
Complied code into a standalone executable, where someone could just click on an icon and have the macro run
-
Authored documentation describing how to use the executable, including directions on how to convert code into executable if changes have been made
File dialog
Example output
The final executable was easier to access, as one didn't have to navigate a specific Excel document to find the macro. It also allowed for batch processing which required less attention from the user.