Respected Alan

,Gapup means the difference between close of last reading and opening of new reading (In my case its difference in level seen when the last reading is taken 2 hrs ago and now. so we can determine seepage)

In calculated sheet the reading taken by system is in Row 9,12, 15, 18 .......

The difference between last reading taken in previous interval is in B6,B9,B12,B15

The reading taken at opening of interval is in A9, A12,A15, A15

The difference between then B6 & A9 is in a10

similarly

difference between then B9 & A12 is in A13

difference between then B12 & A15 is in A16

difference between then B16 & A18 is in A19

The repeatation of difference(+ve or -ve) is counted in B10, B13, B16

Both of A10 & B10 data has to be included in A11 which also equalize

% difference between last two reading,

average of last 2 reading and

average of last 3 reading

PROBLEM---was able to include B10, B13, B16 calculation in A11,A14, A17

but am NOT ABLE TO USE A10, A13, A16 data in A11,A14, A17

as reference of functions in A11,A14, A17 is in A10, A13, A16

and so give repetative loop error.

THIS HAS TO BE SOLVED.

--------------------------------repeating again-----

Respected ,

(1)Way

in calculation of gapup and reoccurance,

Is there anyway so that formulas done in a10,b10, A13,B13 & A16,b16) can be accomodated in A11, a14 & A17

Results & formula in Row 10,13,16,.......... has to be maintained , as it is referenced by formulas in A11, a14 & A17 which complicates the structure.(has to insert extra row)

(2) way

There is the data that is obtained from the level mapping software that is in Row 9,12,15,18

the calculations of gapup & reoccurance(of gapup) is calcuated in ROW a10,b10, a13,b13, a16,b13

The other calculations based on it are in ROW a11,a14,a17

I was able to display the calculated data of Row 10,13,16 in ROW 11,14,17

but further down calculations can not be done as the data in ROW 10,13.16 are used as input in calculations of Row 11,13,16,17, and there it is mixed with other data , calculation in 11,14,17 is not done.

I am looking the way so that the though the data of ROw 9 gets accommodated in Row 10, but calculation of 11,14,17, can be obtained,

Same repeats further.

Please

(3)way

To put all things again

data in Row 9,12,15 & 18 is the data

-opening(col A) & closing(col B) RAW reading of today

data in Row 10,13,16 is the data that is obtained from formulas

-COL A-gapup-down in % of todays opening compared to previous days close(for calculation Base is previous days closing)

-COL B-reoccurance of thing gapup-down trend

data in ROW 11,14,17,20

difference of previous days; gapup-down-that is in a10,a13,a16, its 2-day and 3-average

(what I need

--at present to correctly use the gapup-down data(Row 10,13,16) , it has to be seperately plaaced,

I want to merge it in calculated data in ROW 11,14,17,20

(purpose-one row will be saved , where I can put other+weekly data)

-----------------------------------------