while perusing the various growers forums, i saw a thread about plant tracking software, there were 2 programs mentioned that could be used to help someone keep track of their plants and at what stage they are in
i thought it was a super cool idea, so i decided to put together a little spreadsheet that would help me with this, i'm calling it plantrackit, this little tool has been helping me a lot and since it's just in excel it is super quick and easy to customize, here is a screenshot
the idea is that the user types into the green portion, the calculations take care of themselves everywhere else
this is 0.2, the change was the estimated finish time column (est finish (weeks)), the idea here is that your plants can still be vegging, you can plug in an estimated finish time, then type in a start date for flowering, your stop date is now calculated based on the estimated finish time, i don't think this is done very cleanly so i'll probably redo it for 0.2.1 or something, i feel like it should give an estimated stop date as well as a separate real stop date, hmmm...maybe a progress bar too, can excel do that? hmmm i'm sure there's a way, so flowering will have a progress bar from 0 - 100% depending on how close we are to the estimated finish time
a column for preflowering might be nice also, currently i am just appending an - F or an - M if it's male or female (actually, if it's male, i yank it and delete that plant from the spreadsheet), a preflower column along with another date column for the preflowering
now that i think about it and am rambling, it might be a good idea to add a completely separate schedule somehow for feedings as well, would nested spreadsheets for each plant be the best way? if we're going to delve that deep then i feel excel may no longer be the best option, might be best to just go ahead and write a real program for it, which i would really prefer not to get into
either way, i use this, it helps, i'll keep on updating it as needed, this is a nice way to help keep organized
i thought it was a super cool idea, so i decided to put together a little spreadsheet that would help me with this, i'm calling it plantrackit, this little tool has been helping me a lot and since it's just in excel it is super quick and easy to customize, here is a screenshot
the idea is that the user types into the green portion, the calculations take care of themselves everywhere else
this is 0.2, the change was the estimated finish time column (est finish (weeks)), the idea here is that your plants can still be vegging, you can plug in an estimated finish time, then type in a start date for flowering, your stop date is now calculated based on the estimated finish time, i don't think this is done very cleanly so i'll probably redo it for 0.2.1 or something, i feel like it should give an estimated stop date as well as a separate real stop date, hmmm...maybe a progress bar too, can excel do that? hmmm i'm sure there's a way, so flowering will have a progress bar from 0 - 100% depending on how close we are to the estimated finish time
a column for preflowering might be nice also, currently i am just appending an - F or an - M if it's male or female (actually, if it's male, i yank it and delete that plant from the spreadsheet), a preflower column along with another date column for the preflowering
now that i think about it and am rambling, it might be a good idea to add a completely separate schedule somehow for feedings as well, would nested spreadsheets for each plant be the best way? if we're going to delve that deep then i feel excel may no longer be the best option, might be best to just go ahead and write a real program for it, which i would really prefer not to get into
either way, i use this, it helps, i'll keep on updating it as needed, this is a nice way to help keep organized
No comments:
Post a Comment