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
A good spreadsheet should play well with other spreadsheets. That means if you enter something into one spreadsheet, then you can easily refer to another spreadsheet that has additional information about that same something. Here’s an example … Say you are setting up a schedule for all the crops you are going to direct seed. … More FSA Tip #19 Refer to things with INDEX MATCH
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
Often, you wind up with a spreadsheet that is a long list made up of the same things repeated over and over. This might happen with your harvest records for the season where there there is a row for each crop you harvested from each day you were harvesting. You might only grow 30-40 crops … More FSA Tip #18 UNIQUE – My Favourite Formula
Last tip we joined things together with the Ampersand. Now we’re going to take them apart. Unfortunately taking them apart is a little more work. Fortunately I’ve got you covered with this tip! In this tip, we’ll see … How to use the MID formula to extract the beginning portion of text in a spreadsheet … More FSA Tip #17 Take Things Apart With The MID And FIND Formulas
What is an Ampersand? An ampersand is the AND symbol. That classic “&” that you can use to save space from all those extra letters that come with AND. You can use the Ampersand just about the same way in spreadsheets! It unites things to make longer things. In this video, I’ll show you how … More FSA Tip #16 Join Things Together With Ampersand And Other Formulas
In many spreadsheets we wind up entering the same date over and over. You can use copy paste to speed up your data entry, but there’s another tool that is even quicker. The FILL HANDLE!!!!! With the fill handle you can quickly drag data to fill cells in your spreadsheets. In this video, I’ll show … More FSA Tip #15 Quickly Fill Your Spreadsheet With The Fill Handle
