jbergenudd
New Member
- Joined
- Apr 24, 2014
- Messages
- 6
I'm trying to construct a sheet where I can log my electricity use. Around the first of the month i record what my meter specifies.
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]2016-01-02[/TD]
[TD]67523[/TD]
[/TR]
[TR]
[TD]2016-02-01
[/TD]
[TD]69230[/TD]
[/TR]
[TR]
[TD]2016-02-28[/TD]
[TD]71456[/TD]
[/TR]
[TR]
[TD]2016-04-10[/TD]
[TD]73810[/TD]
[/TR]
[TR]
[TD]2016-05-02[/TD]
[TD]74996[/TD]
[/TR]
[TR]
[TD]2016-06-01[/TD]
[TD]77120[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to approx. calculate monthly usage? In april I was away and couldn't check until 10 days into the month so that reading should be recalculated to what it "should" have been on 2016-04-01. From that I can calculate average monthly usage.
Anybody that have tackled this problem?
Regards,
/Jonas
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]2016-01-02[/TD]
[TD]67523[/TD]
[/TR]
[TR]
[TD]2016-02-01
[/TD]
[TD]69230[/TD]
[/TR]
[TR]
[TD]2016-02-28[/TD]
[TD]71456[/TD]
[/TR]
[TR]
[TD]2016-04-10[/TD]
[TD]73810[/TD]
[/TR]
[TR]
[TD]2016-05-02[/TD]
[TD]74996[/TD]
[/TR]
[TR]
[TD]2016-06-01[/TD]
[TD]77120[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to approx. calculate monthly usage? In april I was away and couldn't check until 10 days into the month so that reading should be recalculated to what it "should" have been on 2016-04-01. From that I can calculate average monthly usage.
Anybody that have tackled this problem?
Regards,
/Jonas