Forum Discussion
Calculated planting week
My knowledge about planting is very limited, even if I like to eat vegetables :).
Here is some information I was able to put together that may help you.
- You can use Excel formulas to calculate the planting dates based on your last frost date and the growing time of each plant. For example, one website suggests using this formula: = CELL ID of last frost date + CELL ID planting (weeks) * 7
- You can also use a template that has already been created for seed starting and planting schedules. For example, one website offers a downloadable template that you can adjust according to your location and crops.
- You can also use online tools and calculators that are designed for garden planning. For example, one website provides a fall-harvest planting calculator workbook that works backward from your first fall frost date to determine the best seeding date for each crop.
- You can also use a garden planning spreadsheet that allows you to track all your gardening activities. For example, one website shares a garden planning spreadsheet that includes a seed/plant tracker, a garden map, and notes for plant care and companion planting.
Or lastly, you create your own plan as you wish and you can always come back to this forum for whatever steps you get stuck on.
Otherwise, if you are not sure yourself with Excel, I recommend giving this to commission work. There are enough users who could possibly take over this (not me please, I don't generally take on commissioned work :).
I hope this information are helpful for you.
Thank you so much for your reply.
I have a lot to learn still about Excel and every little bit of information brings me closer to the answers I am looking for.
Would love to pass this to someone willing to take it on as commisioned work but have tried this in the past and have had very dissapointing results as I didn't understand Excel well enough to explain what I wanted and the excel experts didn't understand the desired outcome well enough.
Therefor trying to further educate myself.
Your suggestions are great but I need a solution that allows for changing crop growing times throughout the year with multiple planting dates for the same crop so we have continues flowering over a much larger period of time.
You can combine data from two sheets in Excel by using the Consolidate feature.
You can also create a dynamic list in Excel based on criteria by using the FILTER and OFFSET functions.
To create a list of when plants should be planted, you can use Excel formulas to calculate the planting dates based on your last frost date and the growing time of each plant. You can also use a template that has already been created from Mr. Patrick2788 for seed starting and planting schedules.
To create a dynamic list of when plants should be planted, you can use INDEX - MATCH with other functions. This will allow you to create a list that changes as you add new data to your spreadsheet.
Furthermore, if I may recommend, insert a file (without sensitive data) and explain your project step by step on the basis of this file. At the same time, it would be an advantage if the digital environment was known, such as Excel version, operating system, storage medium, etc..
Thank you for your patience and understanding