Cruisers Forum
 


Join CruisersForum Today

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 22-12-2016, 19:51   #16
Registered User
 
sy_gilana's Avatar

Join Date: Jan 2005
Location: On board
Boat: Van de Stadt 50'
Posts: 1,187
Send a message via Skype™ to sy_gilana
Re: Inventory/storage location spreadsheet

Excellent work, just wish I could see it in action, however I decided some time ago to never have Microsoft on any of the machines I actually own. Still ahead.

Incidentally the choice you have about location sort, vs. item sort is really important. Heres why... When you are doing a stock-up you usually pack locker by locker, and when you are consuming, you choose by item not location.

Agree that EOQ etc are overkill, but min qty is a good alt.

Can access do a predictive search?

Another idea, perhaps put to a poll, is the addition of photos, I have links in my SS to pictures of certain items like spare parts, pumps, etc, obviously not jelly jars and beercans. Not a necessity.

VERY important for all users is the reverse notation, for users who have not read the intro on our web page. You enter stock backwards, so Pink Rubber Gloves MUST be entered Gloves Rubber Pink. Shirt working blue, Fruit Mixed Syrup Can, Fruit Mixed Syrup Jar, Pump Jabsco Water Puppy 24v 1/2" NPT, Pump March 220v A/C.
The reasons are obvious when a sort is done.

NICE WORK StuM
__________________

__________________
Tight sheets to ya.
http://gilana.org
sy_gilana is offline   Reply With Quote
Old 23-12-2016, 08:02   #17
Registered User

Join Date: Jul 2014
Posts: 136
Re: Inventory/storage location spreadsheet

Thanks Stu.

Good and simple.

I'll bang away at it and see what pops up.

nice job.
__________________

scherzoja is offline   Reply With Quote
Old 23-12-2016, 10:35   #18
Registered User
 
rwidman's Avatar

Join Date: Feb 2008
Location: North Charleston, SC
Boat: Camano Troll
Posts: 4,669
Re: Inventory/storage location spreadsheet

Quote:
Originally Posted by StuM View Post
If you're trying to cross link stores and equipment in various categories over various locations, a simple database would be much better than a spreadsheet..........


It takes just one click of the mouse to corrupt a "database" created in a spreadsheet. That's not what a spreadsheet is made fore.

An actual database program is what should be used. The downside of course is that few people understand the concept of a database so they don't make effective use of the software.
__________________
Ron
HIGH COTTON
Sent from my laptop using Windows 7
rwidman is offline   Reply With Quote
Old 23-12-2016, 10:38   #19
Registered User
 
rwidman's Avatar

Join Date: Feb 2008
Location: North Charleston, SC
Boat: Camano Troll
Posts: 4,669
Re: Inventory/storage location spreadsheet

Quote:
Originally Posted by sy_gilana View Post
Spreadsheet is good enough, and it allows you to sort by name or location, ...............

And if you make the simple mistake of not including all the columns in the sort, the spreadsheet is corrupted. That's the point I tried to make in my post above.
__________________
Ron
HIGH COTTON
Sent from my laptop using Windows 7
rwidman is offline   Reply With Quote
Old 23-12-2016, 11:01   #20
Registered User
 
rwidman's Avatar

Join Date: Feb 2008
Location: North Charleston, SC
Boat: Camano Troll
Posts: 4,669
Re: Inventory/storage location spreadsheet

The real problem with any sort of system is convincing the users to actually use it and use it in real time. How many times have you gone to a vendor and the guy says "The computer says we have one but the bin is empty."

I have a hard time believing that someone is going to start a computer, open a database program and record one can of tomato sauce used. It might happen if the computer and database were running 24/7 and was bar code capable.

There was a time many years ago when I developed a database to record the activities of a maintenance staff of over 300 people maintaining over 200 public school buildings. This recorded and reported on time and materials. The database worked fine. The employees did not. Time and materials did not get entered correctly and sometimes were not entered at all.

If you want to do it and can convince everyone involved to follow procedures, fine. We just "wing it".
__________________
Ron
HIGH COTTON
Sent from my laptop using Windows 7
rwidman is offline   Reply With Quote
Old 23-12-2016, 13:01   #21
Senior Cruiser
 
StuM's Avatar

Cruisers Forum Supporter

Join Date: Nov 2013
Location: Port Moresby,Papua New Guinea
Boat: FP Belize Maestro 43
Posts: 7,574
Re: Inventory/storage location spreadsheet

Quote:
Originally Posted by rwidman View Post
The real problem with any sort of system is convincing the users to actually use it and use it in real time. How many times have you gone to a vendor and the guy says "The computer says we have one but the bin is empty."
Earlier this year in a hardware store, I took something off a shelf to the checkout and was told that I couldn't buy it because the computer said there were none in stock.

Quote:
I have a hard time believing that someone is going to start a computer, open a database program and record one can of tomato sauce used. It might happen if the computer and database were running 24/7 and was bar code capable.
Me too If you are going to track consumables such as food to that degree, I'd do an inventory check periodically and/or update it daily with items used. (well, actually I personally wouldn't do the latter - I'm just not that organised )

Quote:
There was a time many years ago when I developed a database to record the activities of a maintenance staff of over 300 people maintaining over 200 public school buildings. This recorded and reported on time and materials. The database worked fine. The employees did not. Time and materials did not get entered correctly and sometimes were not entered at all.

If you want to do it and can convince everyone involved to follow procedures, fine. We just "wing it".
Me too, that's why I built one for this thread, I didn't have one already.

But I think I might use it now for things other than food and clothing that tend to sit in out of the way places for months or years.
StuM is offline   Reply With Quote
Old 23-12-2016, 15:39   #22
Registered User
 
sy_gilana's Avatar

Join Date: Jan 2005
Location: On board
Boat: Van de Stadt 50'
Posts: 1,187
Send a message via Skype™ to sy_gilana
Re: Inventory/storage location spreadsheet

Well, some might find it hard to believe, but we actually DO open the spreadsheet and subtract one can of Tomatoes, or indeed anything, when it is used, every time without fail. Going on 19 years now, it works and we know what we have and how old it is.
__________________
Tight sheets to ya.
http://gilana.org
sy_gilana is offline   Reply With Quote
Old 23-12-2016, 22:42   #23
CF Adviser
 
Pelagic's Avatar

Cruisers Forum Supporter

Join Date: Oct 2007
Boat: Van Helleman Schooner 65ft StarGazer
Posts: 7,684
Re: Inventory/storage location spreadsheet

An important thing to remember is that your inventory/location and linked receipt/disbursement worksheets must be easy to follow for those who are learning to use it

That usually means linear entries of set columns in reverse notations as mentioned, so that it is easy to sort and present in whatever order you wish from the data entered.

Excel has worked well for me in teaching Superyacht officers how to manage their inventories

i separate into 4 identical Sheets ..Hotel / Deck / Catering / Engineering and use the same codes for Location / Consumables / Spares/ Capital Expenditures / and the Generic name in one column for Alphabetical sorting.

It is easy to maintain the inventory because you tend to move popular consumable stock from one deep storage location to a daily cupboard, so we just adjust inventory as what remains in the Deep location and only add what is left in the daily location, when ready to go shopping.

By reducing the sheets down to 4 departments, all with the same format, it is easy to find and update smaller individual worksheets.
Pelagic is offline   Reply With Quote
Old 24-12-2016, 07:35   #24
Registered User
 
Stu Jackson's Avatar

Join Date: Jan 2011
Location: Cowichan Bay, BC (Maple Bay Marina)
Posts: 6,845
Re: Inventory/storage location spreadsheet

Quote:
Originally Posted by rwidman View Post
And if you make the simple mistake of not including all the columns in the sort, the spreadsheet is corrupted. That's the point I tried to make in my post above.
That's true, and a reason for maintaining a discipline of keeping the last update as a separate file before you move on.

If folks who are running (complicated) sailboats that require a certain amount of discipline for both seakeeping and safety, and who choose to develop any kind of inventory, then this should be the easy part, because once you save the spreadsheet, the sort "comes with it," doesn't it?

I have maintained both a fuel log AND an inventory for the past 18 years. My inventory includes part numbers, (but not locations) which I shared and posted on the separate "spreadsheet" thread earlier this week. Yup, it takes time to do it.

I chose to use a spreadsheet because I know how to work them, even though I've used databases in my work. I just personally find them too cumbersome, but Stu seems to be as quick with a database as I am with a spreadsheet.

But when my autopilot belt needed to be replaced in the middle of Monterey Bay one time, I was able to look up the part number, call it in and have it delivered to my next port of call. Even the Raymarine manual didn't have the West Marine part number in it, so was essentially useless for purchasing. My inventory did have it.

Which reminds me: I have to update the inventory with all the stuff we bought on our six week trip up the coast last summer.

Bummer...
__________________
Stu Jackson
Catalina 34 #224 (1986) C34IA Secretary
Cowichan Bay, BC, (Maple Bay Marina) SR/FK, M25, Rocna 10 (22#) (NZ model)
Stu Jackson is offline   Reply With Quote
Old 19-04-2017, 16:35   #25
Registered User

Join Date: Nov 2016
Location: Toronto - ON - Canada
Boat: Bayfield 36 Cutter
Posts: 52
Re: Inventory/storage location spreadsheet

This is amazing.......

Thank you very much

Tafa
Tafa is offline   Reply With Quote
Old 20-04-2017, 00:50   #26
Registered User

Join Date: Jul 2006
Location: Underway in the Med -
Boat: Jeanneau 40 DS SoulMates
Posts: 1,993
Images: 1
Re: Inventory/storage location spreadsheet

We do a complete boat inventory about every other year - just did one

we use Microsoft spreadsheet

here is our last one
Attached Files
File Type: xls parts inventory2.xls (68.5 KB, 52 views)
__________________
just our thoughts and opinions
chuck and svsoulmates
Underway along the Turkish coast eastbound
chuckr is offline   Reply With Quote
Old 26-04-2017, 08:29   #27
Registered User

Join Date: Apr 2017
Location: Alaska
Boat: 1989 Catalina 36
Posts: 236
Re: Inventory/storage location spreadsheet

I'm new (<2yrs) to cruising life but absolutely started an inventory. The process dragged along until I realized how much money is saved without compromising refit quality by knowing where to find (and the part numbers of) the affordable alternatives to manufacturer-direct gaskets and expensive bits and pieces. (Bless internet forums and differential diagnosis&#129303. I (and we) also now keep a super-detailed work log, especially on topics related to propulsion.

I keep having to relearn the value of activity logs and inventories--every time I switch lifestyles or big hobbies, it seems. Pretty handy for hiking, rving, car trips, international travel, business, and farm life too😍
__________________

__________________
…being able to swim in the deep sea; and having a home that's a shell…

turtletraveling.com
Meanderthal is offline   Reply With Quote
Reply

Tags
storage

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inventory and Provisioning Spreadsheet The Boat Galley Provisioning: Food & Drink 7 16-01-2011 06:37
Excel Provisioning Spreadsheet MV Provisioning: Food & Drink 52 27-07-2009 15:14
Spreadsheet for Boat-Buying Comparison? outthere09 The Sailor's Confessional 7 25-03-2009 14:03
Homework using a spreadsheet Redbull addict Monohull Sailboats 6 15-06-2007 10:03



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -7. The time now is 21:40.


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

ShowCase vBulletin Plugins by Drive Thru Online, Inc.