Wrap Up With Your Crop Plan With Some PIVOT Tables

It’s time to wrap this series of Planning Posts.

(which all began in Part 1)

I want to do that with a little Pivot Table magic.

What’s a Pivot Table?

It is only the most important arrow in your spreadsheet quiver.

As you plan your growing season and generate a Financial Plan and Sales Plan and Field Plan and Nursery Plan and Seed Order, you wind up with a bunch of columns and data in your spreadsheets.

And yes, your spreadsheets are full of great decisions and information to guide your farm.

But wow, can they be a pain to look at and deal with when it’s actually time to get things done.

This is where you can bring in Pivot Tables.

Highlight all the data in your spreadsheet and then choose “Pivot Table” from the appropriate menu. (In Google Sheets, you choose PIVOT TABLE from the Data menu in the toolbar.)

Then select what you would like to display in that Pivot Table.

And voilà! You’ve turned all that data into a Planting Calendar or a Nursery Schedule or whatever Farm List you need at the moment.

If this post and set of pictures isn’t enough for you, I’m giving a workshop today called Build A Better Crop Plan about the 3 cornerstones of effective spreadsheet systems.

Spoiler – all 3 cornerstones lead to Pivot Tables.

If you want to see some Crop Plan Pivot Table action, this is the place to be!!!

Thanks for going on this Planning Journey with me over the last week.

I know it can be overwhelming to think of everything that goes into planning for a successful season but the secret to getting there is to just think of one thing at a time.

Start with where you want to go (in this case, your financial goals) and then work backwards.

If you take it slow and steady, you’ll get there.

Happy Planning!


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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s