This program automates the creation of weekly energy lab reports for Princeton's The Power is Ours campaign, scraping input CSV files and creating a PowerPoint deliverable. You can read more about Princeton's net zero efforts and lab fume hoods here.
-
Download the files in this repository. This can be done by navigating to releases and downloading the .zip file containing everything.
-
Make sure that Python is installed. A great guide for installing Python can be found here.
-
Unpack the downloaded zip of Evidn Lab Generator.
-
Using a terminal or CLI on your computer (i.e Terminal on Mac, Powershell on Windows), navigate to the folder that was created by unpacking the zip. A guide for this can be found here
-
Install the necessary packages from requirements.txt. This can be done using the command
pip install -r requirements.txt
-
Download the lab .csv files and put them in a folder. Title this folder the name of the lab building (ex. Icahn). You should run this program seperately if you're dealing with multiple buildings.
- Make sure this folder is in the same location as the program files
-
Open template.pptx and duplicate the slides for the amount of labs you have.
- For example, if you wanted to make 4 lab reports, there should be 4 slides.
-
Using a terminal or CLI on your computer (i.e Terminal on Mac, Powershell on Windows), navigate to the folder that was created by unpacking the zip. A guide for this can be found here
-
Run the program with the command
python main.py -
Upon completion, the output files will appear, named "output.pptx" and "data.csv"