to Eliminate row needed for gapup and reoccurance function and data

[zoharb]

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
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/i0yd4yetzzixxr8/forum%402feb.xls?dl=0

PLEASE PLEASE help me
Zohar Batterywala

 

[zoharb]

PLEASE PLEASE help me
Zohar Batterywala