Combine data from multiple QAs

[dorten75 7]

So I have a some QA with both price data and power usage data I want to get more out of with combining them.
Is there someone that has the knowledge or allready something like that who can help me?

1. Calculate cost -
Have a kWh QA showing data from power outage to tenants electric car, by using Qubino Smart meter 1-phase.

Also have the hour cost for electricity using Tibber (electric company)
How can I calculate this cost using this different QAs, so that it is added up every whole hour when the cost changes?

 

The perfect setup would be to start calculating the cost when charging starts, and send the final cost when charging is stopped by push og email.

2. Calculate power usage in the different parts of the house.

Have kWh power for the entire home using data from my electric company in one QA (Lets call this A)
This measures my part of the house, as well as my tenants part.

An Qubino Smart meter 3-phase (B) measures my part of the house, and the Qubino Smart meter 1-phase (C) measures the tenants electric car.
These are connected to the same fuse cabinet, so B also include usage at C.

How can I calculate kWh usage automaticly on these parts, to see what I use, and what my tenant uses?
Want:
1) B-C = D (My part of the usage)
2) A-D = E (Tenants usage)
3) E+C = F (Tenants usage + her car charging)

 

I am not great at LUA script, so hoping someone have something I easily can adjust

Edited January 27, 2022 by dorten75

[Tim__ 114]

Sounds like you want some custom coding in order to charge your tenant. I don't think your requirements are a common scenario. If I were you I'd pay a Fibaro installer (or maybe someone here) to develop it for you.

 

BTW I think your third equation is incorrect. Should be E + C.

[dorten75 7]

Yes, it is to charge my tenant car charging correctly. The rest is included in the rent for now, but good to have control over. 
Now I just can give a monthly average cost, that can be wrong both ways. 

 

I am willing to pay to get this in place, anyone up for it?

Or can point me in a direction to someone that can create this?

 

1 hour ago, Tim__ said:

BTW I think your third equation is incorrect. Should be E + C.

Thanx, corrected!