Recalculating channel history with corrected CT type?
Posted: Tue Oct 01, 2019 2:00 am
A while back, I discovered that I had accidentally misconfigured the CT type on two channels on my GEM. The CTs are Micro-100s but I accidentally left them as micro-40s when I initially set it up.
This GEM is connected to a Dashbox and the readings are stored in its database.
I fixed the issue a few months later when I realized that things weren't adding up but of course that doesn't change the data captured previously. That makes sense and I think I understand why it works that way but I would love to be able to go back and correct the history if possible.
Is there a handy formula for converting KW and/or KWhr values between various sets of CT parameters?
From what I've read about the CT parameters, they effectively describe how the raw signals are converted to current. I'm hoping those parameters have a fairly straightforward relationship with the final computed power and energy values.
It would be wonderful if there's a way to apply this change to the misconfigured data in the database even if I have to write a script to handle it. If that isn't realistic, being able to do it manually outside the database for select KWhr totals would still be very useful.
I'm getting a new HVAC system and want to compare my consumption between old and new. Part of this power was on those channels.
This GEM is connected to a Dashbox and the readings are stored in its database.
I fixed the issue a few months later when I realized that things weren't adding up but of course that doesn't change the data captured previously. That makes sense and I think I understand why it works that way but I would love to be able to go back and correct the history if possible.
Is there a handy formula for converting KW and/or KWhr values between various sets of CT parameters?
From what I've read about the CT parameters, they effectively describe how the raw signals are converted to current. I'm hoping those parameters have a fairly straightforward relationship with the final computed power and energy values.
It would be wonderful if there's a way to apply this change to the misconfigured data in the database even if I have to write a script to handle it. If that isn't realistic, being able to do it manually outside the database for select KWhr totals would still be very useful.
I'm getting a new HVAC system and want to compare my consumption between old and new. Part of this power was on those channels.