fsa tip #75 – Highlight when your crops are available in your sales plan

You can watch the video ere.

One of the first steps to start Crop Planning for your farm is to make a sales plan.

You want to set up a table with your crops along the left side and the weeks you’ll be at market or CSA along the top of the table. Then you can plan out how much of each crop you’d like to sell each week.

One thing I added to the Sales Plan sheet in my full Crop Plan framework is orange background colour to indicate what weeks crops are available.

I’m currently reviewing all the formulas in the Crop Plan spreadsheets of my online course and last week I went over the Sales Plan formulas.

Here’s behind the scenes of how I used Conditional Formatting to turn the cells orange to indicate when the crop is available.

  • Use FIND() to look up the week number is a list of available weeks
  • Use IFERROR() to show 0 when the week number is not in that list
  • Use RIGHT() to make sure week numbers with 1 digit show the availability
  • Put the complete formula in Conditional Formatting to turn those cells orange

Note that this is just a few steps in how the Sales Plan links up with the rest of the Crop Plan framework. There’s a lot more to it in my Farm Spreadsheets For All Seasons course

You can download the spreadsheets here.

Watch The Crop Plan Workshop


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 )

Connecting to %s