A spreadsheet template was provided in the video description which could be used to perform the function described above, but it was very labour intensive to use. The temperature and energy data needed to be provided in csv files and manually copied into the spreadsheet, and the “Solver” function of the spreadsheet program, such a Libra Office, used to generate the final result. No-one did this to my knowledge, so the CoolRater app was created to make the task quick and easy.
To achieve this, temperature data is loaded straight from thermometers via USB, and the energy data loaded from your energy provider’s website using their API service. Currently the thermometers used must be Elitech RC-5+ devices, and the energy provider must be Octopus Energy.