Gardening — Planting Amounts

Every garden and gardener is different. We each have our goals for the year, whether it is almost complete self-sufficiency to growing a few special plants that we can’t buy at the store. I’ve built a small calculator to help figure out how much of what vegetables you should grow depending on what percentage of your annual intake you’d like to get from your garden. You can download this as n Excel file below or you can have a look at a Google Doc version at the end of the post.:

Garden Calculator.xlsx

Here’s how it works. At the top, you enter the number of people and what percentage of these crops would you like to get from your garden. Obviously it requires some space to grow this many crops, so you’ll have to balance how much you’d like to grow with what space you have available.

Once these values are entered, the sheet below will update to show you an estimated yield, number of plants to be grown, the seed sewing depth, plant spacing, row spacing, total row length and area covered, and days to harvest.

If you want to tweak the spreadsheet, you can easily do so. The number of people and percentage is multiplied by the suggested number of plants to supply 100 percent of one’s needs for the year. For example, 24 cucumber plants are suggested for the entire year’s worth of cucumber consumption. If you think you need less or more cucumbers, go into the Column C cell for that plant and modify the last number in the formula “=F1*(F2/100))*24” to whatever number of cucumbers you think is appropriate for 100 percent of your needs. I like okra, for example, so I’ll double my number, just so we have enough pickled okra to last me into the spring.

Feedback, updates, and results are welcome. Leave us a comment below.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s