dresdner353 / energyutils

Collection of utility scripts for energy monitoring

energyutils

This is a collection of scripts for use in energy monitoring. Each script or series of scripts may be focussed on specific applications, data sources or products. It's a work and in progress in the very early stages and will come together over time.

Specific Guides:

• ESB HDF Reader (Ireland)
• Shelly EM Utility
• Solis Inverter Utility
• Report Generator Utility
• Battery Simulator
• Solar Monitor Dashboard
• more to come..

energyutils's Issues

gen_report.py

Hi
I would like to remove some of the columns in the spreadsheet can I do this using a filter
if so can you give me an example
Regards

Shelly EM

Hi I am trying to get the data from the Shelly EM using your script.
It created the Shelly directory but doesn't put any files in it
Can you help
Out put from CMD Shell

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET PYTHON=python3.exe

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SHELLY_DATA=shelly_data

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SHELLY_SCRIPT=..\shelly_em_data_util.py

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET GEN_REPORT_SCRIPT=..\gen_report.py

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET REPORTS=day week month year hour tariff 24h weekday

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM Shelly API config

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SET SHELLY_HOST=shelly-36-eu.shelly.cloud

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SET SHELLY_AUTH_KEY=YTUyZGZ1aWQXXXXXXXXXXX

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SET SHELLY_DEVICE_ID=485XXXXXXXX
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM prepare directory for parsed SHELLY JSON data

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>IF not exist shelly_data (mkdir shelly_data )

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM Retrieve data from Shelly Cloud

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>python3.exe ..\shelly_em_data_util.py --host --id --auth_key --odir "shelly_data" --days 30
usage: shelly_em_data_util.py [-h] --host HOST [--odir ODIR] [--days DAYS] [--solar_discard SOLAR_DISCARD] --id ID
--auth_key AUTH_KEY [--verbose]
shelly_em_data_util.py: error: argument --host: expected one argument

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM Example EV report

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>python3.exe ..\gen_report.py --idir shelly_data --file shelly_report_ev.xlsx --reports day week month year hour tariff 24h weekday --tariff_rate Day:0.4320 Night:0.2086 Boost:0.1225 --tariff_interval 08-23:Day 23-08:Night 02-04:Boost --annual_standing_charge 303 --fit_rate 0.21
Sun Feb 25 16:16:39 2024 Generating report shelly_report_ev.xlsx
Sun Feb 25 16:16:39 2024 Loaded 0 files, 0 records

C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>pause
Press any key to continue . . .

Report Start and end

REM Example EV report
%PYTHON% %GEN_REPORT_SCRIPT% ^
--idir %SHELLY_DATA% ^
--start START Calculation Start Date (20230302)
--end END Calculation End Date (20230303)
--file shelly_report_ev.xlsx ^
--reports %REPORTS% ^
--hide_columns year month week ts ^
--tariff_rate Day:0.2692 Night:0.1576 ^
--tariff_interval 08-23:Day 23-08:Night ^
--annual_standing_charge 226 ^
--fit_rate 0.12

C:\AAAShelly\ESB Report Program\energyutils-main\windows_workflow>--end END Calculation End Date (20230303)
'--end' is not recognized as an internal or external command,
operable program or batch file.
What am I not doing correctly
PJM