A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Meter Readings



 
 
Thread Tools Display Modes
  #21  
Old April 21st, 2006, 08:44 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Meter Readings


"Sandy Mann" wrote in message
...
I had noticed *empty* posts like the one above before and wondered why. I
posted a reply this morning at work through Google and all that has shown
up is Pete's original post. I must have done something wrong I suppose.

Anyway what I posted was:

"Pete_UK" wrote in message
oups.com...

adding back in 10 raised to the power (number of dials). The formula
from Sandy seems to be getting very complex.


It's would not be so bad if it was just complex but it is wrong to boot!

What I should have posted was:

=MOD(LOOKUP(10^LEN(C2),D2:IV2)-LOOKUP(10^LEN(C2),D2:IV2,C2:IV2),10^LEN(C2))*B2+(( LOOKUP(10^LEN(C2),C2:IV2,C1:IV1)"")*10^LEN(C2))

But I would think that if there was any chance of the meter turning over
more than its capacity then Maria should be looking at replacing the meter
with one of greater capacity.


I couldn't get this one to work Sandy - sorry !

It just gives me a zero for an answer each time.

The meters never go round more than once, quite often not going all the way
round for many many months

Thanks again.

Tracey


  #22  
Old April 21st, 2006, 09:09 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Meter Readings

Hi Maria,

Well......... If the meter is never going to go round more than once then
I would just forget about the last formula I posted and just use the one
that you did get to work which was:

=MOD(LOOKUP(10^LEN(C2),D2:IV2)-LOOKUP(10^LEN(C2),D2:IV2,C2:IV2),10^LEN(C2))*B10

or use Pete's formula

Remember that C2 needs to have the the full number of real characters even
if some of them are leading zeros and B10 must have a number in it even if
it is 1.

If you still are having trouble then do post back.

--

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Maria Tracey" wrote in message
...

"Sandy Mann" wrote in message
...
I had noticed *empty* posts like the one above before and wondered why. I
posted a reply this morning at work through Google and all that has shown
up is Pete's original post. I must have done something wrong I suppose.

Anyway what I posted was:

"Pete_UK" wrote in message
oups.com...

adding back in 10 raised to the power (number of dials). The formula
from Sandy seems to be getting very complex.


It's would not be so bad if it was just complex but it is wrong to boot!

What I should have posted was:

=MOD(LOOKUP(10^LEN(C2),D2:IV2)-LOOKUP(10^LEN(C2),D2:IV2,C2:IV2),10^LEN(C2))*B2+(( LOOKUP(10^LEN(C2),C2:IV2,C1:IV1)"")*10^LEN(C2))

But I would think that if there was any chance of the meter turning over
more than its capacity then Maria should be looking at replacing the
meter with one of greater capacity.


I couldn't get this one to work Sandy - sorry !

It just gives me a zero for an answer each time.

The meters never go round more than once, quite often not going all the
way round for many many months

Thanks again.

Tracey




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Select query - only one-to-many records? AndyK Running & Setting Up Queries 4 March 27th, 2006 05:52 AM
Latest meter reading Dan Johnson Running & Setting Up Queries 2 April 25th, 2005 09:53 PM
Need to create a progress meter while an Access module runs Brent E General Discussion 5 January 29th, 2005 12:25 AM
query progress meter Bob White General Discussion 8 December 6th, 2004 12:57 PM
Trying to get difference in Meter readings between rows Mike S. Running & Setting Up Queries 2 June 8th, 2004 07:05 PM


All times are GMT +1. The time now is 12:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.