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. Guest




  3. viper357

    viper357 Admin MASA Contributor

    Joined:
    4 May 2007
    Posts:
    28,750
    Likes Received:
    1,015
    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,204
    Likes Received:
    9
    Location:
    Under the sea
    very nice thanks for sharing :yeahdude:
     
  5. Tobes

    Tobes Retired Moderator

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

    dallasg Moderator

    Joined:
    14 Dec 2008
    Posts:
    16,802
    Likes Received:
    591
    Location:
    Sandton
    thanks, very cool
     
  7. OP
    Sammy

    Sammy

    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,052
    Likes Received:
    52
    Location:
    Westville, Durban
    Cool, thanks for sharing!
     
  9. Seabass

    Seabass

    Joined:
    28 Jul 2009
    Posts:
    2,382
    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. OP
    Sammy

    Sammy

    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 media Wanted 8 Jul 2017
[wtd] Calcium reactor wanted Wanted 27 Jun 2017
Dosing alk and calcium battle Water Parameters and Additives 31 May 2017
Calcium reactor help needed. Protein Skimmers, Mechanical Filtration 27 May 2017
[wtd] Media for Calcium reactor Wanted 9 Apr 2017
bulk calcium question Chemical Filtration / Low Nutrient Systems - LNS 2 Apr 2017
[wtd] Calcium and phosphate test kit Wanted 4 Feb 2017