My life changed when the clock struck midnight. It wasn’t so much that my carriage (a 2004 Toyota Echo with no AC) turned into a giant Cucurbita maxima squash (A Giant Pumpkin, if you will.) But my buddy Syl leaned over and asked “Do you use Pivot Tables?” Not a traditional New Year’s greeting. But … More FSA Tip #34 Turn Your Crop Plan Into A Planting Calendar With Pivot Tables
You need some good SKUs!!! A SKU is a Stock Keeping Unit. It’s a code you can use across all your farm management systems to clearly identify a product. You can use them in your online store your bookkeeping software your spreadsheets anywhere you want Your SKUs should be made up of a Parent SKU … More FSA Tip #33 Use SKUs To Manage Your Farm Store Products
The easiest way to manage a lot of products in your online store is to import them with a CSV file. But that CSV file usually has a ridiculous amount of rows. It can be a hassle to keep them all synced up. The spreadsheet from the Farm Spreadsheet Tip shows you how to manage … More FSA Tip #32 Tools To Create Product CSV Files For Your Online Farm Store
Ahhh, is there anything more beautiful than a well packed CSA share that is labelled with all the contents? No, there is not. (Unless we want to start talking about Radicchio.) Isn’t there anything more irritating than trying to generate clear itemized labels from the CSV file you exported from your online store that has … More FSA Tip #31 Merge A CSV Order Into 1 Row
This one is for all of you who’ve got an online farm store full of order and need to put together a harvest list to fill those orders. In this tip, we’ll see how to … Export your orders from you online store as a CSV. (This one is from Shopify – it would be similar … More FSA Tip #30 From Order CSV To Harvest List
What is a bed foot? A bed foot is a one foot long slice in your growing bed. I like thinking in bed feet rather than square feet because it lays a clear framework for thinking about your fields. Right off the bat you don’t have to worry whether your numbers include your paths or … More Bed Feet should be your BFF
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
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
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
