Hi,
need some help/inspiration for the following project:
I have an annex building that is supposed to be used for rent.
The tennant is supposed to pay for the power, which has variable rate (per hour).
I have a seperate power meter for the building and have made a sensor using the [AI-on-the-edge-device-project](GitHub - jomjol/AI-on-the-edge-device](GitHub - jomjol/AI-on-the-edge-device)
Further, I get the rate per hour using the Nordpool sensor from HACS.
My wish is to make a setup that read the power every hour (like hh:57), add this to a database as well as the present rate from Nordpool (and, if possible, calculate the final price incl. VAT etc.), something like:
- Time, kWh, calculated difference from last reading, raw price per kWh, calculated total price, calculated total cost per hour
As this is supposed to be used for the total amount the tennant has to pay every month, the system has to be pretty failsafe - and if possible also easy for me to get the cummulated values from (and therefore, I guess, in a seprate database than Home Assistant’s native).
Any ideas/advice on how to make this?
Regards,
Chr.