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

  • Attach the xls(x) file to this thread not a dropbox please. You may get some assistance then.
    People do not like downloading from Dropbox due to Virus etc.

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