This spreadsheet tip follows up my post about our seed room. In it I look at the basics of how we manage our seed inventory through a spreadsheet. It is easy to try to make a spreadsheet row do too much. But by breaking down one row into multiple rows, you can get more detail … More FSA Tip #6 Every Row Tells A Story
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
Farmer Spreadsheet Survey I want to hear about how you use spreadsheets on your farm! I’ve put together this quick survey so you can tell me what you love and hate about spreadsheets. It would be amazing if you could fill it out!!!! I want to make sure the Farmer Spreadsheet Academy is meeting farmer’s … More I want to hear about your Spreadsheets!
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