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
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
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
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
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 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?
Things are. a bit slow these days on regular weekly farmer spreadsheet tips. But I have put together this spreadsheet recipe for you, I’m sure it will be very helpful. Ingredients: 1/4 cup sugar 1/3 cup water 2 cups spreadsheet Directions: Bring water and sugar to a boil. Then add spreadsheet. Make sure cells are … More Quick Spreadsheet Sauce
CSV files, CSV files, CSV files! When you start importing and exporting data from online stores or bookkeeping programs, you start to run into CSV files. In this tip, we’ll see … What are the differences between a CSV file and a spreadsheet Why CSV files are a great way to share information How to … More FSA Tip #22 What Is A CSV File?
This past week, the Tourne-Sol online seed store had 3 times the regular number of seed sales. In any normal year, we would be ecstatic for this increase in orders. This year, we are a little too distracted to do any serious celebrating. Also, with recent self isolation recommendations and daycares being closed, we are down to … More FSA Tip #21 Line Breaks In Spreadsheet Cells
When you’re setting up your crop plan, there comes a time when you need to calculate how many seeds you will need to have on hand.. That seems simple, just multiply the number of beds by the number of rows per bed by your seed rate, and voilà! #beds x rows/bed x seed rate = … More FSA Tip #20 Counting Seeds With The IF Formula