la-tools-test

Contains Python tools for Load Analytics department - Engie, NA.

1. Cap Tag Report

Found in Cap Tag Directory .

Creates Cap Tag Report given PR and Revision numbers (as "PR_rev").

Pulls from TPPE and outputs .csv file of cap and trans tags for all meters in a PR. Checks start and end dates of tags with start and stop dates of PR. Can be used to batch through multiple PR's.

To Do Add functionality similar to Offer Summary Main tool - check tags with summer and winter peaks.

2. .json to .csv Parser

Found in this file in the main directory.

Parses EWX .json files and outputs forecasts to .csv (can be used if EWX forecasts aren't coming through to ALPS).

To Do Add functionality to parse payloads we send to EWX (can be used for tickets, to recover data, etc.). Add functionality to check heartbeat (time difference) of forecasts.

3. EWX Forecasting Clone

Found in EWX Forecasting Directory

Attempts to replicate EWX Forecasting default flow configs. Goal is to be given Engie's payload to EWX (as .json) and output a similarly forecasted ch. 3 and cap tags

To Do Interpolation, fill time gaps, timeshift usage, etc. etc.

4. NEPOOL IDR Drop

Found in IDR_Drop Directory

1. Email scrape tool - Parses utility emails for accounts, EPO logins and passwords.
2. EPO webscrape tool - Automates downloading of IDR data from EPO portal.
3. IDR filter - splits IDR data into Raw IDR files, filters raw IDR into ch. 1 and/or ch. 3 to be dropped into ALPS.
4. Main code - puts everything together, to be automated.

To Do Fix bug in webscrape, or make workaround where we can drop downloaded raw (groups of ~5) to directory where IDR filter will parse these into IDR_Success, IDR_Error folders