Automation of ASHRAE 140 Testing Verification
- Read in tables from RESULTS-2A.xlsx for standard programs (make as a file in 'inputs' folder)
- Format as JSON objects in 'processed' folder
- Make a rendering in jupyter notebook (Fig. B8-9)
- Export rendering to html and save in a 'static' folder.
- User submits file in 'input' folder via pull request.
- Github Actions (GA) detects new files in 'input' folder.
- GA converts any CSVs to json.
- GA runs verification workflow: schema, and sensible outputs.
- GA runs workflow to verify compliance for various tests, creates summaries for visualizations, adds them to json object, and writes file to 'processed' folder.
- GA detects new files in 'processed' folder.
- GA calls html module (e.g. nbconvert with Jupyter notebook) to render report and send html to 'static' folder. Another Jupyter 'interactive' workbook can be created which allows users to change inputs in code for rendering, or have a more detailed diagnostic capability (if time allows).
- GA updates index.html file to include report.
- GA runs cleanup. a. Remove downstream files where the input file was deleted. b. Re-render any files that reference deleted files.
- Tests passed, PR ready for merge.