ALK and Calcium predictor spreadsheet for manual dosing

Discussion in 'Water Parameters and Additives' started by Sammy, 27 Jul 2011.

  1. Sammy

    Sammy

    Joined:
    19 Apr 2008
    Posts:
    1,191
    Likes Received:
    6
    Location:
    Tokai, Cape Town
    Hi Guys,

    Thought I share my basic spreadsheet with anyone that might find this handy, It helps me quite a bit as I'm manual doising at the moment - ALK, Ca, Mg

    The spreadsheets helps predict what the levels of ALK and Ca should be on a daily basis.
    So when you miss a few days you could easily see what you need to add and what the change should be.

    The predictors takes into account daily tank usage and supplement additions and give a predicted water parameters.

    All you have to know is: (Below is for ALK only, Ca basically the same idea)

    1) What amount of supplement adds to your tank. In my e.g 1tsp of Alk (Seachem Reefbuilder) adds 0.7dkh

    2) Alk consumption p\day, my tank consumes on average 0.5dKh p/day

    Put this in the spreadsheet and your ALK will be tracked whether you supplement or not your ALK should be predicted.

    Every time you measure and insert measured ALK the predicted ALK is updated.

    Miss a few days and you should know what to add and how much your ALK should be.

    Very basic but does the trick in helping me.
     

    Attached Files:

    Tobes likes this.
  2. AdS Guest




    to hide all adverts.
  3. viper357

    viper357 Admin MASA Contributor

    Joined:
    4 May 2007
    Posts:
    27,983
    Likes Received:
    777
    Wow, that's quite a nice piece of work, got graphs and everything, very cool, thanks for sharing it with us. :)
     
  4. Pete

    Pete

    Joined:
    3 Apr 2008
    Posts:
    1,196
    Likes Received:
    6
    Location:
    Under the sea
    very nice thanks for sharing :yeahdude:
     
  5. Tobes

    Tobes Retired Moderator

    Joined:
    30 Nov 2007
    Posts:
    9,482
    Likes Received:
    118
    Location:
    A Beautiful place!
    Thanks for sharing :)
     
  6. dallasg

    dallasg Moderator MASA Contributor

    Joined:
    14 Dec 2008
    Posts:
    16,769
    Likes Received:
    582
    Location:
    Sandton
    thanks, very cool
     
  7. Sammy

    Sammy Thread Starter

    Joined:
    19 Apr 2008
    Posts:
    1,191
    Likes Received:
    6
    Location:
    Tokai, Cape Town
    No probs, glad you figured it out, It's always difficult when someone else done it !
     
  8. lIghty

    lIghty

    Joined:
    3 Nov 2007
    Posts:
    5,053
    Likes Received:
    52
    Location:
    Westville, Durban
    Cool, thanks for sharing!
     
  9. Seabass

    Seabass

    Joined:
    28 Jul 2009
    Posts:
    2,383
    Likes Received:
    21
    Location:
    Gonubie
    Thanks
     
  10. pXius

    pXius

    Joined:
    31 Mar 2011
    Posts:
    1,170
    Likes Received:
    22
    Location:
    Weltevreden Park, JHB
    dankie!
     
  11. Sammy

    Sammy Thread Starter

    Joined:
    19 Apr 2008
    Posts:
    1,191
    Likes Received:
    6
    Location:
    Tokai, Cape Town
    Don't be shy to use the thx button, I need some help with my sad rep
     
    Last edited: 28 Jul 2011
Recent Posts

Loading...
Similar Threads - Calcium predictor spreadsheet Forum Date
[wtd] calcium reactor Wanted 23 Oct 2016
[wtd] Complete Aqua Medic KR 5000 Calcium Reactor Wanted 1 Oct 2016
[wtd] Calcium Reactor Complete Setup Wanted 28 Sep 2016
[wtd] Complete calcium reactor unit will all bells and whistles Wanted 22 Sep 2016
[wtd] Calcium needed Wanted 17 Sep 2016
[wtd] Calcium Reactor media - Course Wanted 30 May 2016
[wtd] calcium reactor Wanted 12 May 2016