1. OzGrid
    1. Excel/VBA Consultancy
    2. OzGrid Store
    3. Training
    4. Freebies
  2. Forum
    1. Unresolved Threads
    2. Forum Rules
  3. Dashboard
  4. Articles
  5. Members
    1. Recent Activities
    2. Users Online
    3. Team
    4. Search Members
  • Login or register

    Login

    Lost Password

    Register

    Don’t have an account yet? Register yourself now and be a part of our community!

    Register Yourself
  • Search
This Thread
  • Everywhere
  • This Thread
  • This Forum
  • Articles
  • Pages
  • Forum
  • More Options
  1. OzGrid Free Excel/VBA Help Forum
  2. HELP FORUMS
  3. Excel Formulas

range

  • zohar
  • Sep 17th 2020
  • zohar
    Intermediate
    Points
    983
    Trophies
    1
    Posts
    151
    • Sep 17th 2020
    • #1

    Respected,

    I am trying to formulate a way so that increasing/decreasing level in a reservoir can be known before hand so controlled flow can be assures.

    Zohar Batterywalarange.xlsx

    • Report Content
  • royUK
    Super Moderator
    Likes Received
    432
    Points
    72,430
    Trophies
    1
    Posts
    23,932
    • Sep 18th 2020
    • #2

    Your thread title gives no idea what you are asking. In fact your title itself is not clear.


    Maybe you need to use Conditional Formatting


    Use conditional formatting to highlight information

    Hope that Helps


    Roy


    New users should read the Forum Rules before posting


    For free Excel tools & articles visit my web site


    Check out my new web site.


    royUK's Database Form


    Where to paste code from the Forum


    About me.

    • Report Content
  • zohar
    Intermediate
    Points
    983
    Trophies
    1
    Posts
    151
    • Sep 19th 2020
    • #3

    Respected Sir ,

    PRACTICAL: The issue is that when the levels in the upper reservoir is too much it is released in the lower reservoir , now normallly it is happening that this release is sometimes more than the capacity the lower reservoir can hold(and the structure is endangered).


    The solution I am trying: to monitor level of the reservoir so that difference(range between the opening and closing) is spotted.

    when the extra level is released from upper reservoir, a step-by-step movement has to be done so that immense flow does not come to lower reservoir which it can handle. So am trying to monitor (daily levels are updated every 4 hours , so 6 in a day). And similar step-by step can be released further.

    And the SECOND case is that if the increaseing levels is spotted in above feeder, lower feeder levels decreased pre-emptively to make way for the incoming future flow.


    OB-Overflow build up is spotted only after 3rd reading as it is normal that levels increase or decrease in normal flow. but 3rd consequence of it do trigger the situation. OB#, OB$, OB5, OB6 do mention that and when the OVERFLOW BUILDUP is released to lower reservoirs, it is flagger by OR

    ORA is flagging of abnormal levels seen(in lower reservoirs) if only one or two reading is too much fluctuating (due to OR from upper reservoir)


    Zohar

    Files

    • range.xlsx

      (13.23 kB, downloaded 22 times, last: Yesterday, 8:04 am)
    • Report Content
  • royUK
    Super Moderator
    Likes Received
    432
    Points
    72,430
    Trophies
    1
    Posts
    23,932
    • Sep 20th 2020
    • #4

    You need to use Conditional Formatting

    Hope that Helps


    Roy


    New users should read the Forum Rules before posting


    For free Excel tools & articles visit my web site


    Check out my new web site.


    royUK's Database Form


    Where to paste code from the Forum


    About me.

    • Report Content
  • zohar
    Intermediate
    Points
    983
    Trophies
    1
    Posts
    151
    • Sep 20th 2020
    • #5

    sir, the total excel file is of 1.3 GB and I have tried using conditional formatting previously but it has slowed even the normal pageup/down thing tremendously. I am looking for logic of this , then I have to convert it to workable formulas in 14 files(each having 8 instances)

    HOPE

    Zohar Batterywala

    • Report Content
  • royUK
    Super Moderator
    Likes Received
    432
    Points
    72,430
    Trophies
    1
    Posts
    23,932
    • Sep 21st 2020
    • #6

    Something must be making that file huge. Try saving it as xlsb. Also, you might need to use 64 bit Office.

    Hope that Helps


    Roy


    New users should read the Forum Rules before posting


    For free Excel tools & articles visit my web site


    Check out my new web site.


    royUK's Database Form


    Where to paste code from the Forum


    About me.

    • Report Content

Share

  • Facebook
  • Twitter
  • Reddit
  • WhatsApp
  • LinkedIn

Similar Threads

  • Automatically hide/unhide row by calling module

    • Xaba
    • Sep 7th 2020
    • Excel VBA / Macros
  • Autofilter in the column with the first character

    • Ottomatic
    • Sep 11th 2020
    • Excel VBA / Macros
  • Need Help with Resetting a Countif Function

    • BDGibson4
    • Aug 26th 2020
    • Excel Formulas
  • Average and Median formula with conditions

    • dejamls
    • Aug 11th 2020
    • Excel Formulas
  1. Privacy Policy
  2. Contact
© OzGrid Business Services. All Rights reserved.
  1. Navigation
  2. OzGrid
    1. Excel/VBA Consultancy
    2. OzGrid Store
    3. Training
    4. Freebies
  3. Forum
    1. Unresolved Threads
    2. Forum Rules
  4. Dashboard
  5. Articles
  6. Members
    1. Recent Activities
    2. Users Online
    3. Team
    4. Search Members
  7. Search
  8. Options
    1. (placeholder)
  9. Current Location
  10. OzGrid Free Excel/VBA Help Forum
  11. HELP FORUMS
  12. Excel Formulas
  1. User Menu
  2. Login
  3. Registration
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close