Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 22nd 13, 11:09 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2013
Posts: 1
Default Water meter readings

Hello I need help if you can with inputting and calculating meter readings. This would help cut down on multiple inputs manually. Any help would be greatly appreciated. Here is what I do.

I read several different meters on different days and subtract new readings from previous and average between the days. These days are not consistent so I manually subtract readings and divide by number of days. Sorry if this is confusing maybe this will help.
MeterA Usage MeterB Usage MeterC Usage
Day1 0 0 877654 0 432 432
Day2 76543 76543 617 111.2
Day3 883.25 878888 617 111.2
Day4 883.25 10893.5 111.2
Day5 883.25 900675 10893.5 111.2
Day6 80076 883.25 988 111.2

  #2   Report Post  
Old July 23rd 13, 12:18 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
Default Water meter readings

Hi,

Am Mon, 22 Jul 2013 23:09:45 +0100 schrieb IVjcsud:

MeterA Usage MeterB Usage MeterC
Usage
Day1 0 0 877654 0 432
432
Day2 76543 76543 617


I don't know if I understood you correctly.
Please have a look:
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "WaterMeter"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Occasional meter readings chart [email protected] Charts and Charting in Excel 1 February 23rd 13 07:22 PM
Formula for subtracting multiple meter readings for usage totals? ttam78ouch Excel Discussion (Misc queries) 5 February 13th 08 06:10 PM
how to get readings in the form of degrees saidulu New Users to Excel 1 July 29th 06 08:38 AM
Meter Readings Maria Tracey New Users to Excel 21 April 21st 06 09:09 PM
Daily water meter readings Jon Berenson Excel Worksheet Functions 1 July 15th 05 11:04 PM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017