Meter Readings

M

Maria Tracey

Sandy Mann said:
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:



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
 
S

Sandy Mann

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top