to Eliminate row needed for gapup and reoccurance function and data

Respected,
Had posted in two other groups but cant get the solution so posting here

https://www.excelforum.com/exc…and-data.html#post5056937
https://www.mrexcel.com/forum/…reoccurance+function+data

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)

xls file with data is in dropbox
https://www.dropbox.com/s/i0yd…xr8/forum%402feb.xls?dl=0

PLEASE PLEASE help me
Zohar Batterywala

PLEASE PLEASE help me
Zohar Batterywala

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)
-----------------------------------------