So, you’re heading out on your boat and you know it’s going to be a few weeks or more before you’ll hit another grocery store. You want to make sure you have all the food you’ll want, but not too much of one thing. And you already have some food on board, and you don’t want to duplicate it when you go to the supermarket. What’s a sailor to do?
That’s exactly the situation this provisioning spreadsheet is designed for!
Although I call this a provisioning spreadsheet, it’s really a combination inventory and provisioning spreadsheet. It is NOT intended to be a recommendation of what you need on any particular trip — that is up to you, what you like to eat, how many people are on board, and how long you’ll be gone.
This spreadsheet will allow you to decide what foods you want, how many units of each you use in an average week, let you inventory how many you already have on hand, and then it will calculate how many you need to buy. Here’s a quick glance — you can download it at the bottom of this article:
It is set up so that you can sort it to print only the items you need, and have those items sorted by category — for example, all the “Baking” items you need will be grouped together so that when you’re in the baking aisle of the store, you’ll know ALL the things to put in the basket. This makes shopping much more efficient. Don’t worry, I explain how to use these features in the instructions.
This is an Excel .xlsx spreadsheet — if you have some other spreadsheet program that will read an .xlsx file, this should also work, but no guarantees.
WHAT YOU GET: The formulas are already in the spreadsheet, and there is also a detailed instruction sheet in PDF format — be sure to download both. You don’t need to be a spreadsheet wizard to use this!
When you click “DOWNLOAD” for the spreadsheet, you’ll be prompted to save it on your device. When you click “Download” for the Instruction PDF, it will immediately open on your computer, tablet or phone.
BE SURE TO SAVE THE PDF ON YOUR DEVICE(S) so you can refer to it when you aren’t connected to the internet. You are welcome to print out a copy, too.
iPAD/iPHONE USERS: To save a PDF document from the browser, tap near the top of the document in the iPad/iPhone browser window and choose “Open in iBooks.”