One of the biggest challenges in crop plan spreadsheets is how to create a clear crop map that is easy to consult but also automatically updates when things change. Here is my latest version – a combo made up of the formulas JOIN(), CHAR(10), and FILTER(). This combo displays your crop plan for 1 bed … More Dynamic Crop Maps For Your Crop Plan
You know how there are times in your farming career when you can grow more crop than you can sell? For a number of years, we were growing much more garlic than our clients were able to buy. So we started braiding garlic, and we were able to sell more of our garlic that way. Then we started … More FSA Tip #38 How To Price Garlic Braids
This was the last Live Farm Spreadsheet from May. How long does it take you to harvest 1 bed of arugula? How about to handweed a bed of carrots? Or wash and pack 100 bunches of beets? If you want to find out there are two approaches: Track everything last thing you do, or better … More FSA Tip #37 How To Track Harvest Rates
This was another Live Farm Spreadsheet from May. It’s about how to manage pictures for your online store. It’s heavier on the planning and organising with a little spreadsheet sprinkled in. In this tip, we’ll see how to … Organise your pictures on your desktop Label those pictures with a SKU and the image name … More FSA Tip #36 How To Manage Pictures For Your Online Store
This was a Live Farm Spreadsheet from May. And it’s all about running some of your spreadsheets in more than one language. At Tourne-Sol co-operative farm, we run operations in speaks both English and French. We also run our website and online store in English and French. So there are times when we need spreadsheets … More FSA Tip #35 Setting Up Spreadsheet For More Than One Language
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
