Executable that converts the .csv output from EnergyPlus into an .xlsx file and performs common unit conversions along with some formatting.
The program will open a file prompt, in which it is expected that you select an EnergyPlus output .csv file. It then converts that file to an Excel format, .xlsx.
It then
- Word wraps the first row.
- Converts any "Electricity" columns to kWh, and formats with 0 decimal places.
- Converts any "DistrictCooling" or "DistrictHeating" columns to MMBTU, and formats with 0 decimal places.
- Converts any "Temperature" columns to F, and formats with 1 decimal place.
- Adjusts the width of all the columns.
- Saves the file with -convert.xlsx as the new ending in the same folder the original file was in.
After you download the zip file, you can run the program directly without installing any program to your computer by running the executable in \EnergyPlusConverter\EnergyPlusConverter\bin\Debug\EnergyPlusConverter.exe.
The other option is to run the setup.exe file, located at \EnergyPlusConverter\EnergyPlusConverter\publish\setup.exe, which will then install the program on your computer along with a shortcut.
Adding additional features is quite straightforward for this project, so please let me know of other important unit conversions, formatting, etc. that you would like to see!