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
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
This week, we take a break from our regularly scheduled Farmer Spreadsheet Tip to announce the A 4-part online mini course for market gardeners who dream about saving some of their own seeds. The first class is just before the new year. Just in time to plan your 2020 growing season! Dec. 30 Why Grow … More Announcing the Seed Saving for Market Growers FREE Mini Course
Anchoring cells in a formula ensures that you are referring to the right cells when you reuse the same formulas elsewhere in your spreadsheet. … More FSA Tip #5 Anchoring Cells
SUMIF let’s you SUM up certain cells IF they meet certain conditions. … More FSA Tip #4 Sumif and Sumifs!
This week’s farmer spreadsheet tip is about using week numbers instead of dates in your spreadsheets. Week numbers are a critical piece of how I crop plan. They make it much easier to sort and look at information on a weekly basis rather then get bogged down with how there are 7 different days in each week. Are … More FSA Tip #3 Week Numbers
I’ve been working on a secret project. I call it the the Farmer Spreadsheet Academy and it just went public! Step one of this new venture is a series of weekly farmer spreadsheet tip videos. The first video is about the formula SUMPRODUCT. Tip#1 SUMPRODUCT I chose SUMPRODUCT for the first video because it was … More The Farmer Spreadsheet Academy
After reading a few Going To Seed posts, you’ve decided “I want to be a seed saver!” But wait, there are so many seeds out there. What seed should you save? Let me guide you through a reflection and evaluation process to determine what seeds to save. Over the next couple of posts I will … More What Seed Should You Save?