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,849
Default Water meter readings


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

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

I don't know if I understood you correctly.
Please have a look:
for the workbook "WaterMeter"

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

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 08:22 PM
Formula for subtracting multiple meter readings for usage totals? ttam78ouch Excel Discussion (Misc queries) 5 February 13th 08 07: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 05:50 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017