S is for Spreadsheet
October 30, 2020
Category: Farmer Spreadsheet Academy
FSA Tip #29 A Conditional Formatting Primer
October 24, 2020
You want your spreadsheet cells to change colour based on what’s going on inside? Conditional Formatting is the thing for you! This is the first a few Conditional Formatting tips. This one is the basics so we can get more complicated next time. In this tip, we’ll see … How to get to the Conditional … More FSA Tip #29 A Conditional Formatting Primer
FSA Tip #28 Merging Lists In Google Sheets
October 15, 2020
Today’s tip was inspired by an email I received wondering if there was a way to merge the crops lists from 3 separate crop plan into one list. Well there is a pretty quick way to merge lists. And if you throw in the UNIQUE and SORT formulas you can organize your merged list to … More FSA Tip #28 Merging Lists In Google Sheets
FSA Tip #27 Crop Profit Calculator
October 5, 2020
Here’s a Profit Calculator I put together to get ready for week 3 of the Season Review Challenge. You can evaluate each of your crops against your profit benchmarks to see what crops you should grow more of on your farm, and what crops you should drop. Step 1: How much do you want to … More FSA Tip #27 Crop Profit Calculator
FSA Tip #26 Working With Google Form Answers
September 25, 2020
This is the second in a series of Farm Spreadsheet Tips about Google Forms. Last tip we set up a Google Form to gather harvest data during your harvest mornings. In this tip, we’ll link that form to one of your farm spreadsheets so you can work with the answers. This works for all Google … More FSA Tip #26 Working With Google Form Answers
FSA Tip #25 Setting Up Google Forms
September 18, 2020
This is the first in a series of Farm Spreadsheet Tips about Google Forms. Next week will be the beginning of the Farm Season Review Challenge. And one of my key season review tools is Google Forms. I want all of you to make sure you understand Google Form Basics to be able to use … More FSA Tip #25 Setting Up Google Forms
The Farm Season Review Challenge
September 10, 2020
I know you know that it is a good idea to stop and reflect on the past growing season to make sure you learn all the lessons you’re supposed to learn. And from year one at Tourne-Sol, where I farm, we always made a point of doing a season review every fall. But it wasn’t until year … More The Farm Season Review Challenge
FSA Tip #24 Understanding Date Formats
September 6, 2020
When do you need to plant your lettuce so that it’s ready to harvest on time? When did we actually harvest the lettuce and send it to market? When did we do some other incredible significant farm activity, and was it done at the right time? Dates are a key component of a good farm … More FSA Tip #24 Understanding Date Formats
FSA Tip #23 Hiding Errors With IFERROR
August 27, 2020
Is there anything as ugly an a farm spreadsheet full of #DIV/0! or #N/A or some other error message? Yes, these messages tell you what might be going wrong in your spreadsheet but sometimes it doesn’t matter. You already know you can’t divide by zero, let’s move on to something else! Error messages can make … More FSA Tip #23 Hiding Errors With IFERROR
Remember that farm store you wanted to start?
August 10, 2020
Remember last spring, when the world got real crazy on March 13? And you decided to pivot everything and drop the farmers market and any in person sales and instead you would set up an online store and only take online orders? And then spring moved forward and your plants got bigger and everybody in … More Remember that farm store you wanted to start?
