Water use meter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a water softener intsalled for boiler use. our control meter counts backwards. We can set the regeneration gallons. to what ever we like
Setting is 650 at this time
Having trouble in excel with nesting. log sheet looks something like this
A1 softener setting 65

day 1 2 3 4 5 6 7
#1 softener 650 650 350 150 650 650 37
Tota
#2 softener 340 110 650 650 360 150 65
Tota
As you can see one softener is running while the other is in standby
I can get my totals to look at A1 and disregard 650 and give me a correct answer at one end of the 650 but not the other or vice versa????
 
Hi
this is probably me but I don't know what you want to calculate. Could
you post your expected result based on your example data
 
if your setting is in A1 and your first row of data is in B2:H2 you can
enter an array formula like this

=SUM(IF((B2:G2=C2:H2)*B2:G2=$A$1,0,B2:G2)-IF(C2:H2=$A$1,0,C2:H2))

Enter with Ctrl+Shift+Enter

for the second row with data in B4:H4

=SUM(IF((B4:G4=C4:H4)*B4:G4=A1,0,B4:G4)-IF(C4:H4=A1,0,C4:H4))

Enter with Ctrl+Shift+Enter

I doubt this will give you the correct answer, because I am not sure of
exactly what your data represents. Does it represent the meter reading at
the beginning or the end. When you have 150 650, is 150 consumed
between these two numbers or is the tank reset while the other tank is
used - or does it go to zero and the other tank is put in use so there is an
overlap. What to do with the first number is also not clear. It would be
easier if you have a start number and an end number so if you want 7 days of
data, you would have 8 columns of entry.

--
Regards,
Tom Ogilvy

Steve G said:
I have a water softener intsalled for boiler use. our control meter counts
Click to expand...
backwards. We can set the regeneration gallons. to what ever we like.
Setting is 650 at this time.
Having trouble in excel with nesting. log sheet looks something like this.
A1 softener setting 650

day 1 2 3 4 5 6 7
#1 softener 650 650 350 150 650 650 370
Total
#2 softener 340 110 650 650 360 150 650
Total
As you can see one softener is running while the other is in standby.
I can get my totals to look at A1 and disregard 650 and give me a correct
Click to expand...
answer at one end of the 650 but not the other or vice versa?????
 
I do something very similar at my plant Tom, and I must say, that if what
you did here was a guess, it was a pretty good one.

I total my boiler stats on a daily basis to keep a tighter control on the
softeners' water usage, so I never really needed this type of formula.
And, you are correct, in that there must be an additional column included
into the calculations to complete a seven day cycle.

I revised your formula to include the eighth number, and it worked, as I'm
sure the OP would be content with (if he posts back).
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------



if your setting is in A1 and your first row of data is in B2:H2 you can
enter an array formula like this

=SUM(IF((B2:G2=C2:H2)*B2:G2=$A$1,0,B2:G2)-IF(C2:H2=$A$1,0,C2:H2))

Enter with Ctrl+Shift+Enter

for the second row with data in B4:H4

=SUM(IF((B4:G4=C4:H4)*B4:G4=A1,0,B4:G4)-IF(C4:H4=A1,0,C4:H4))

Enter with Ctrl+Shift+Enter

I doubt this will give you the correct answer, because I am not sure of
exactly what your data represents. Does it represent the meter reading at
the beginning or the end. When you have 150 650, is 150 consumed
between these two numbers or is the tank reset while the other tank is
used - or does it go to zero and the other tank is put in use so there is an
overlap. What to do with the first number is also not clear. It would be
easier if you have a start number and an end number so if you want 7 days of
data, you would have 8 columns of entry.

--
Regards,
Tom Ogilvy

Steve G said:
I have a water softener intsalled for boiler use. our control meter counts
Click to expand...
backwards. We can set the regeneration gallons. to what ever we like.
Setting is 650 at this time.
Having trouble in excel with nesting. log sheet looks something like this.
A1 softener setting 650

day 1 2 3 4 5 6 7
#1 softener 650 650 350 150 650 650 370
Total
#2 softener 340 110 650 650 360 150 650
Total
As you can see one softener is running while the other is in standby.
I can get my totals to look at A1 and disregard 650 and give me a correct
Click to expand...
answer at one end of the 650 but not the other or vice versa?????
 
RD

Small world. Stationary Engineering my career also.

Pulp and Paper and Gas Plants mainly.

Gord
 
As you may have surmised, I dye for a living (literally).<g>

Do you ever get involved in the dyeing of the paper and/or the pulp?

Since there are many dyestuffs that are common to both textiles and paper,
we might have mutual acquantinces among the vendors or suppliers.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
RD

Small world. Stationary Engineering my career also.

Pulp and Paper and Gas Plants mainly.

Gord
 
No involvement with that side.

Steam and Power generation and the processing of cooking chemicals for the
wood chip cooking.

Gord
 
Back
Top