Cruisers Forum
 


Join CruisersForum Today

Reply
 
Thread Tools Rate Thread Display Modes
Old 06-01-2013, 06:12   #1
Sponsoring Vendor
 
The Boat Galley's Avatar

Join Date: Sep 2010
Location: Now in Central Illinois
Boat: Formerly S/V Que Tal, Tayana 37
Posts: 74
FREE Provisioning Spreadsheet

If you're heading out for more than just a couple of days, you're probably trying to figure out what you need to buy and what you already have on board.

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.

It's downloadable in Excel .xls format, and you can edit it to your heart's content. There's an instruction sheet to download, too.

Get the FREE Downloadable Inventory & Provisioning Spreadsheet
__________________

__________________
Carolyn Shearlock
Formerly S/V Que Tal, a Tayana 37
The Boat Galley
[SIGPIC][/SIGPIC]
The Boat Galley is offline   Reply With Quote
Old 06-01-2013, 10:50   #2
********* Emeritus
 
SaucySailoress's Avatar

Cruisers Forum Supporter

Join Date: Apr 2010
Posts: 8,236
Re: FREE Provisioning Spreadsheet

This is a great resource, thanks! I am always making spreadsheets, and this is pretty much along the lines of how I would have made one for provisioning, AND it already has loads of victuals in there! Thanks!
__________________

__________________

SaucySailoress is offline   Reply With Quote
Old 06-01-2013, 12:06   #3
Nearly an old salt
 
goboatingnow's Avatar

Cruisers Forum Supporter

Join Date: Jun 2009
Posts: 13,649
Images: 3
How come no fresh vegetables ?


Dave
__________________
Check out my new blog on smart boat technology, networking and gadgets for the connected sailor! - http://smartboats.tumblr.com
goboatingnow is offline   Reply With Quote
Old 06-01-2013, 12:16   #4
Marine Service Provider
 
banyandah's Avatar

Join Date: Jun 2010
Location: North Coast NSW
Boat: 38' cutter
Posts: 254
Images: 35
Send a message via Skype™ to banyandah
Re: FREE Provisioning Spreadsheet

Hi Carolyn,
I will download your spreadsheet and show it Jude. She made her own Excel sheet many years ago, much to my rolling of eyes and tut-tutting. But by golly, it works wonders when we can't find that last can of baked beans, or small bag of spice. A good idea that also makes reprovisioning faster and more efficient.
Goodonya,
__________________
Jack and Jude
Sailing stories and guides
banyandah is offline   Reply With Quote
Old 06-01-2013, 12:30   #5
Marine Service Provider
 
banyandah's Avatar

Join Date: Jun 2010
Location: North Coast NSW
Boat: 38' cutter
Posts: 254
Images: 35
Send a message via Skype™ to banyandah
Re: FREE Provisioning Spreadsheet

Just had a quick peek, and back again with a suggestion, one that makes Jude's inventory spreadsheet so handy.
We have at least 6 lockers where dry good, cans, etc are stored. Another for fresh. And in Jude's spreadsheet is a column for "WHERE" the item is. You might want to incorporate that in yours... What do you think?
__________________
Jack and Jude
Sailing stories and guides
banyandah is offline   Reply With Quote
Old 06-01-2013, 16:46   #6
Sponsoring Vendor
 
The Boat Galley's Avatar

Join Date: Sep 2010
Location: Now in Central Illinois
Boat: Formerly S/V Que Tal, Tayana 37
Posts: 74
Re: FREE Provisioning Spreadsheet

Goboatingnow -- I buy fresh veggies according to what I find as opposed to what's on a list (where we cruised, it was far better that way). But you can add more rows and put veggies in if you wish.

Banyandah -- You can definitely add a column for where -- I tried all sorts of systems to record where things were and found that I just never actually did the recording no matter WHAT the system . . . so I stopped and found that I really just knew what I had where. I usually have things in several places (a week stash in one handy locker and the big stock might get split between a couple locations), so that's why there are multiple columns for the inventory for each item.

One of the reasons that I like a spreadhseet is that it's easy to add rows and columns and customize it as you want it and most people know how to do basic spreadsheet things like adding another item or changing one.
__________________
Carolyn Shearlock
Formerly S/V Que Tal, a Tayana 37
The Boat Galley
[SIGPIC][/SIGPIC]
The Boat Galley is offline   Reply With Quote
Old 06-01-2013, 17:08   #7
Marine Service Provider
 
banyandah's Avatar

Join Date: Jun 2010
Location: North Coast NSW
Boat: 38' cutter
Posts: 254
Images: 35
Send a message via Skype™ to banyandah
Re: FREE Provisioning Spreadsheet

Excel is such a powerful program, and so versatile.
Jude loves knowing where she's put something. So, after a shop, as she stores the item, she records it on her laptop. She says it's easy to do that. We're long distant sailors and normally provision for 4 months. That's a lot of stuff to remember where it is....

Your spreadsheet could easily cater for that. Columns I,J,K,L could be different storage lockers, or something like that. It all comes down to what works for the individual.

Thanks for sharing yours.
__________________
Jack and Jude
Sailing stories and guides
banyandah is offline   Reply With Quote
Old 08-01-2013, 12:44   #8
********* Emeritus
 
SaucySailoress's Avatar

Cruisers Forum Supporter

Join Date: Apr 2010
Posts: 8,236
Re: FREE Provisioning Spreadsheet

Quote:
Originally Posted by The Boat Galley View Post
so I stopped and found that I really just knew what I had where. I usually have things in several places (a week stash in one handy locker and the big stock might get split between a couple locations), so that's why there are multiple columns for the inventory for each item.
I think it might be a man thing. I might know where everything is in the freezer after I've packed it, but once Marc comes along and repacks it in what he *thinks* is a more logical order, neither of us know what we have or where it is!!!
__________________

SaucySailoress is offline   Reply With Quote
Old 08-01-2013, 15:25   #9
Marine Service Provider
 
banyandah's Avatar

Join Date: Jun 2010
Location: North Coast NSW
Boat: 38' cutter
Posts: 254
Images: 35
Send a message via Skype™ to banyandah
Re: FREE Provisioning Spreadsheet

Quote:
Originally Posted by SaucySailoress View Post
I think it might be a man thing.
SaucySailoress you are cheeky.
A man thing indeed....

Here's Jude wondering where to store all this, and find it after a few months!

__________________

__________________
Jack and Jude
Sailing stories and guides
banyandah is offline   Reply With Quote
Reply

Tags
provisioning

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -7. The time now is 03:52.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.