Water Parameters Spreadsheet - Free
I was showing someone my (excel 2007) water parameters spreadsheet and they suggested I share it, so here it is (click to download). I got the idea from another guy's spreadsheet but his used automatic colour grading, fixed parameters and a few other things I didn't like. Enter your dates & parameters on the front sheet and over time it will automatically graph each parameters' stability or lack of.
The mustard coloured line show recommended parameter ranges and really shouldn't need changing. the green line shows ideal targets withing the range and you can change this to suit your preferences. All formulae will update automatically. Feel free to change anything you want BUT if you start making changes please don't share the modified file or ask me for help. It works well as is if you only change (or not) the target number in the green row on the front page. Important- if you don't test for something, just leave it blank.
Samples from my own sheet below.
The mustard coloured line show recommended parameter ranges and really shouldn't need changing. the green line shows ideal targets withing the range and you can change this to suit your preferences. All formulae will update automatically. Feel free to change anything you want BUT if you start making changes please don't share the modified file or ask me for help. It works well as is if you only change (or not) the target number in the green row on the front page. Important- if you don't test for something, just leave it blank.
Samples from my own sheet below.