How to navigate your crop plan data with the Filter Tool in Google sheets. You can watch the video here. Here are the basic steps 1?? Highlight all your data (CMD-A or CTRL-A) 2?? Click CREATE A FILTER in the menu toolbar 3?? Inverted triangles appear in the headers of your columns 4?? Click on … More fsa tip #74 – Navigate your crop plan with filters
The ultimate Crop Plan spreadsheet tool is Pivot Tables. I’ve mentioned them before and I’m sure I’ll mention them again. Pivot Tables let you turn a spreadsheet full of columns and data into a simple schedule or calendar that is easy to read and easy to share. Here are the basic steps 1?? Highlight all … More fsa tip #73 – Crop Plan: Pivot Tables
Each row in your crop plan spreadsheet should be a distinct planting. A distinct planting means 1 variety planted on the same date. If you plant a lot of varieties and have a lot of succession plantings, you’ll wind up with a bunch of rows. This definitely has the chance to get messy. But if … More fsa tip #72 – Crop Plan: one row equals one planting
If ENTER DATA ONCE is your noble spreadsheet goal, then the journey to get there is the tools and formulas that let you reference that data. In some ways, every spreadsheet formula and tool is all about referencing your original data. But that isn’t very helpful. There are really only a handful of formulas that … More Refer To Data Already In Your Farm Spreadsheets
Imagine if you only had to enter data once into your spreadsheets? Could there be an end to the endless copy/pasting? The 3 cornerstones of The Farmer Spreadsheet Academy will give you tools to create dynamic spreadsheets without that endless copy pasting. The basics are easier than you think! I’ll be posting more about the … More Enter Data Once In Your Farm Spreadsheets
After months of anticipation, my first online spreadsheet course is just about here! This week I’m giving two live webinars that will lead into the course. The webinar is called Build A Better Farm Crop Plan (without all the copy pasting, endless columns, and thousands of open tabs) It is about The 3 Things I … More Build A Better Farm Crop Plan