Energy Dashboard for Community Hall

​Hi all,

 I’m a volunteer for a small village hall, and I wanted to share how we've been using the glowmarket api, and say thanks to all who have unknowingly contributed.

We rent the hall to a number of user groups and private users, and charge them for their hourly usage of the hall plus electric used. Since we have electric heating this is the larger part of the bill in the winter months. ​Before this, we were still using a paper diary for bookings and asking users to manually record meter readings on a sheet of paper, for our treasurer to reconcile monthly.

​I’m not a developer by trade; I’ve relied almost entirely on "vibe coding" to cobble this together. a Google Apps Scripts that connects the Glowmarkt API to our Google Calendar. It pulls our 30-minute readings nightly and attributes the energy usage to specific bookings. It then populates a dashboard so we can make some analysis of where usage has been attributed, or not and helps inform our billing as well as check for usage outside of bookings.

​It’s been working for us for the last 6 months or so, so I’ve shared a limited version of the code on github here:

https://github.com/BasslineSurvey/HallEnergyDashboard/

in case it helps another volunteer out there.

I'm very keen for suggested improvements or any feedback from the more technically minded folks here on how to make it more robust. Or suggested improvements particularly in making any assessment of energy efficiency performance.

​Huge thanks to the Glowmarkt team for the API and associated guides and to the community here for the previous discussions that made this possible!