Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




15 posts

Geek


# 66426 18-Aug-2010 22:09
Send private message

Hey there, I'm working on a speed sheet to help me keep record of my
electricity usage. I have 4 meters, I would like to telly up my daily usage
across all 4 meters.
I require a formula in MS Excel to help me achieve this.
Example:
Meter Reading Record                       
Serial Number        59802    59803    59804    59805   
Type                General    General    Range    Hot Water   
Day    Date                 Meter 1 Meter 2  Meter 3   Meter 4    Daily Usage
Thursday    8/19/2010    8290     3714      7148        9738   
Friday    8/20/2010                   
               
So when adding Friday's data under Daily usage only the difference in the
total sum appears under daily usage for that day.

Hope it makes sense. Cheers

Create new topic
2483 posts

Uber Geek

Trusted

  # 369580 18-Aug-2010 22:16
Send private message

Replace C0, F0, C1, F1 with the appropriate cell names (where C0 = Thursday's details, C1 = Friday's details etc.)

Friday's "Daily Usage" -> =SUM(C1:F1)-SUM(C0:F0)


Then just autofill it and Excel should just automatically use the previous day's usage sum to compare to.




Find me on Twitter!

I posted 1, 2 x 10^3 times!



15 posts

Geek


  # 369594 18-Aug-2010 22:38
Send private message

Thanks, I did try that but it's not what I want.





Day
Date
Meter 1
Meter 2
Meter 3
Meter 4
Daily Usage


Thursday
8/19/2010
100
200
300
400
         


Friday
8/20/2010
101
202
303
404
10


Saturday
8/21/2010
 
 
 
 
 





More like this say, by updating the meter reading on a daily basic I can get the daily unit usage for that day

Hope this makes better sense, Also hope it is displayed correctly on post!

 
 
 
 




15 posts

Geek


  # 369596 18-Aug-2010 22:41
Send private message

its hasn't displayed correctly at all, speed sheet should be going across the page.

Any how say the usage on Friday has increased by 10 units over all meters so displays 10 in Daily usage

2483 posts

Uber Geek

Trusted

  # 369598 18-Aug-2010 22:46
Send private message

OK, here's a *spreadsheet* I've done for you on Google Docs, which you can download. :)

https://spreadsheets.google.com/ccc?key=0Aq5tTY_dDHsSdGhvbmpEWXRYb01JalNmOHpmaldnM2c&hl=en

(File > Download as > Excel to download)




Find me on Twitter!

I posted 1, 2 x 10^3 times!



15 posts

Geek


  # 369609 18-Aug-2010 23:17
Send private message

Thanks dude, maybe it's not possible want I want. But I only want the units usage

say Friday I enter on meter1 reading 1025
Then on Saturday enter                    1030
Friday\Saturday usage would read 5 (it's gain if you like.)
but what would make it more complicated is adding 3 more meters and having the total gain not sum of all meter readings.

If your confused I understand..........so am I!

6434 posts

Uber Geek


  # 369613 18-Aug-2010 23:36
Send private message

Manhilni's looks exaclty like I woudlhave done it from your description, but maybe you are just not explaining it very well.
I *think* I know what you want. You want to enter a value into the cell for fridays reading, but have that same cell display NOT friday's reading but just the difference between friday and satruday, right?  If so, I don't know why it has to be that way, but I wouldn't bother with that



I would add an extra set of 4 columns out to the right showing change for each meter individually.

so the first four columns show the actual readings (as you have now), the second four columns show the difference between that days actuals and the previous days, then simply add the 2nd four column together to get your difference






 
             Actual Reading (input values in this section)    Change (this section contains formulas)
             Meter 1 Meter 2 Meter 3 Meter 4                     Meter 1 Meter 2 Meter 3 Meter 4  Daily Usage
Friday     10        105        2050     289
Saturday 15        109        2072     301                         5            4          22       12           43    


sop you enter in your readings in the left hand side, and the right hand side shows you the daily usage per meter, and the total.






15 posts

Geek


# 369625 19-Aug-2010 00:23
Send private message

Yes! That's a Prefect solution!!!  I'll go about doing that?! Cheers and thank you

 
 
 
 


447 posts

Ultimate Geek


  # 369627 19-Aug-2010 00:44
Send private message

This is what NonPrayingMantis was getting at:https://spreadsheets.google.com 
Once you have your sheet set up & working, you can just hide columns F->I.

2483 posts

Uber Geek

Trusted

  # 369898 19-Aug-2010 16:50
Send private message

Ah - so what you wanted was a daily increase in power for each meter.

Why didn't you just say that? :D

But anyway, good luck with your little metering spreadsheet. :)




Find me on Twitter!

I posted 1, 2 x 10^3 times!



15 posts

Geek


  # 369972 19-Aug-2010 19:44
Send private message

Yea should had made my self clearer, truth is I didn't really know what I wanted. Thanks Guys.

4 posts

Wannabe Geek


  # 454956 4-Apr-2011 06:06
Send private message

Hello,

I requested that this forum be reopened because it is similar to a spreadsheet I'm trying to develop.

Here goes:

I read a water meter on 1/15/11. Again on 2/20/11 and again on 3/22/11.

I have an Excel spreadsheet with 5 columns.

A.Date
B.Days between readings
C.Meter Reading
D.Gallons used between meter readings
E.Average gallons per day between readings. (gpd)

Simple.

Here's the catch. I need to report monthly usage. I can calculate it manually by Multiplying the average gpd times 15 in January plus the average gpd of the next reading in February times the 16 days left in January.

The formula would look like this: E1*15 + E2*16.

I need a formula that would do this automatically no matter what day I read the meter.

Any Ideas.

Create new topic



Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Major Japanese retailer partners with smart New Zealand technology IMAGR
Posted 14-Oct-2019 10:29


Ola pioneers one-time passcode feature to fight rideshare fraud
Posted 14-Oct-2019 10:24


Spark Sport new home of NZC matches from 2020
Posted 10-Oct-2019 09:59


Meet Nola, Noel Leeming's new digital employee
Posted 4-Oct-2019 08:07


Registrations for Sprout Accelerator open for 2020 season
Posted 4-Oct-2019 08:02


Teletrac Navman welcomes AI tech leader Jens Meggers as new President
Posted 4-Oct-2019 07:41


Vodafone makes voice of 4G (VoLTE) official
Posted 4-Oct-2019 07:36


2degrees Reaches Milestone of 100,000 Broadband Customers
Posted 1-Oct-2019 09:17


Nokia 1 Plus available in New Zealand from 2nd October
Posted 30-Sep-2019 17:46


Ola integrates Apple Pay as payment method in New Zealand
Posted 25-Sep-2019 09:51


Facebook Portal to land in New Zealand
Posted 19-Sep-2019 18:35


Amazon Studios announces New Zealand as location for its upcoming series based on The Lord of the Rings
Posted 18-Sep-2019 17:24


The Warehouse chooses Elasticsearch service
Posted 18-Sep-2019 13:55


Voyager upgrades core network to 100Gbit
Posted 18-Sep-2019 13:52


Streaming service Acorn TV launches in New Zealand with selection with British shows
Posted 18-Sep-2019 08:55



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.