KolorBlind
Well-Known Member
So I have used the free grow software here, (which I LOVE by the way) and I fully support the use of it. However, I am a bit of an Excel junkie and I already had a crappy spreadsheet setup before the free software became available. I used the software for a while because it was much easier, but then I found a couple formulas (one mainly) that changed everything for me.
Im really a control freak when it comes to my hobby, so being able to completely tweak and modify and perfect a password protected excel file is what I have always really wanted. I just didnt have the right formula to make it all fairly easy to use.
Here is how my basic layout is. Oh and for paranoia and security reasons I will not share the actual file or a template of it. Sorry, made a promise to the wife
HOME TAB - This is where all the info is displayed. no information is ever entered on this tab, it gathers information from other tabs to tell you everything you need to know in one tab. It has 5 sections; Flower, Veg Clones, Veg Seedlings, Moms and Harvest. The information displayed for each section is the name and age of the plant as well as how long it has been in veg, flower, since cloned, etc. Under the harvest section I have all my plants that have been chopped. It displays how long they have been drying or curing. All of these results are based on information I enter on the other tabs.
PLANTS TAB - Here is where I have all of my plants listed. I have a 4 stage (including moms) perpetual setup so I just leave room for the max amount of plants. I enter description, date cloned/sprouted, date of veg start, date of flower start, and last fed for each plant as required.
HARVEST TAB - When I chop, the plant gets copied from the PLANTS TAB over to the HARVEST TAB where I input final height, date of harvest, and eventually date of cure start and final weight. I leave the plants in the top half of the page that are still drying or curing. Once everything is smoked the plant gets moved down to a RIP section which is pretty much a log of previous harvests.
Other tabs are just for notes and data for dropdown lists and other random stuff i have added over the years.
What puts this whole thing into motion is basically this formula:
=IF(A1<>"",TODAY()-(A1)&" days","")
What this does is displays the number of days since the date entered in cell A1 with " days" afterward (ie: 35 days). If there is no text in cell A1, the cell in which the formula is entered will display nothing (instead of VALUE###).
The way to use this formula is to input dates into one part of the page or another tab as you plant, clone, transplant, etc. Just start a list of named of numbered plants. Then figure out where you want the amount of days since planted, days of veg, days of flower, etc to be displayed and type the formula into that cell accordingly.
Another handy formula to use is this one:
=IF(ISTEXT(A1),A1,"")
This will display the contents of cell A1, unless there is nothing in A1 then it will display nothing (instead of VALUE###). This is the formula I use to copy over the names of each entry from my PLANTS TAB to my HOME TAB. That way i enter it once in the PLANTS TAB and thats it.
Here are some examples of actual formulas Im using which use date from another tab:
=IF('PLANTS'!D4<>"",TODAY()-('PLANTS'!D4)&" days","")
This is currently displaying "56 Days" which is how long that plant has been in flower.
Here is the formula I am using for that same plant to show the description on the HOME TAB:
=IF(ISTEXT('PLANTS'!A4),'PLANTS'!A4,"")
This is currently grabbing the word "Bubblicious" from cell A4 on the PLANTS TAB. So if I delete the entry on the PLANTS TAB and enter a new plant, the section on the HOME TAB will change accordingly.
Well hopefully this has been helpful to at least someone. I searched and searched for this solution for years and I finally stumbled across it after I had given up. If anyone has any questions Im all ears. Im no pro but I do love to tinker and tweak my spreadsheets!!
Peace
KB
Im really a control freak when it comes to my hobby, so being able to completely tweak and modify and perfect a password protected excel file is what I have always really wanted. I just didnt have the right formula to make it all fairly easy to use.
Here is how my basic layout is. Oh and for paranoia and security reasons I will not share the actual file or a template of it. Sorry, made a promise to the wife
HOME TAB - This is where all the info is displayed. no information is ever entered on this tab, it gathers information from other tabs to tell you everything you need to know in one tab. It has 5 sections; Flower, Veg Clones, Veg Seedlings, Moms and Harvest. The information displayed for each section is the name and age of the plant as well as how long it has been in veg, flower, since cloned, etc. Under the harvest section I have all my plants that have been chopped. It displays how long they have been drying or curing. All of these results are based on information I enter on the other tabs.
PLANTS TAB - Here is where I have all of my plants listed. I have a 4 stage (including moms) perpetual setup so I just leave room for the max amount of plants. I enter description, date cloned/sprouted, date of veg start, date of flower start, and last fed for each plant as required.
HARVEST TAB - When I chop, the plant gets copied from the PLANTS TAB over to the HARVEST TAB where I input final height, date of harvest, and eventually date of cure start and final weight. I leave the plants in the top half of the page that are still drying or curing. Once everything is smoked the plant gets moved down to a RIP section which is pretty much a log of previous harvests.
Other tabs are just for notes and data for dropdown lists and other random stuff i have added over the years.
What puts this whole thing into motion is basically this formula:
=IF(A1<>"",TODAY()-(A1)&" days","")
What this does is displays the number of days since the date entered in cell A1 with " days" afterward (ie: 35 days). If there is no text in cell A1, the cell in which the formula is entered will display nothing (instead of VALUE###).
The way to use this formula is to input dates into one part of the page or another tab as you plant, clone, transplant, etc. Just start a list of named of numbered plants. Then figure out where you want the amount of days since planted, days of veg, days of flower, etc to be displayed and type the formula into that cell accordingly.
Another handy formula to use is this one:
=IF(ISTEXT(A1),A1,"")
This will display the contents of cell A1, unless there is nothing in A1 then it will display nothing (instead of VALUE###). This is the formula I use to copy over the names of each entry from my PLANTS TAB to my HOME TAB. That way i enter it once in the PLANTS TAB and thats it.
Here are some examples of actual formulas Im using which use date from another tab:
=IF('PLANTS'!D4<>"",TODAY()-('PLANTS'!D4)&" days","")
This is currently displaying "56 Days" which is how long that plant has been in flower.
Here is the formula I am using for that same plant to show the description on the HOME TAB:
=IF(ISTEXT('PLANTS'!A4),'PLANTS'!A4,"")
This is currently grabbing the word "Bubblicious" from cell A4 on the PLANTS TAB. So if I delete the entry on the PLANTS TAB and enter a new plant, the section on the HOME TAB will change accordingly.
Well hopefully this has been helpful to at least someone. I searched and searched for this solution for years and I finally stumbled across it after I had given up. If anyone has any questions Im all ears. Im no pro but I do love to tinker and tweak my spreadsheets!!
Peace
KB
