Keeping track of kegs

[jawsfree]

Here ya go

My file is here: https://dl.dropboxusercontent.com/u/...t%20Public.xls

Otherwise, check out KegID - that's what we use now.

Hey Woolsocks. Is the spreadsheet still available? Link now a 404. Thanks for sharing.

[Woolsocks]

I'd have to look over your shoulder - it's a pretty advanced spreadsheet. As far as barcodes, KegID recommended some "industrial" ones which are pretty tough.

[jbell71464]

Barcoding Kegs

I like the idea of the scanner for kegs, my question is what are you using for the bar code tags on the kegs?

Thanks

[YellowHead]

My file is here: https://dl.dropboxusercontent.com/u/...t%20Public.xls

Otherwise, check out KegID - that's what we use now.

Hey Woolsocks, thanks for the file! I'm having a little trouble using it though... it seems like when I put a keg down in the returned sheet, the data doesn't show up again on the main sheet. Am I doing something wrong?

[wailingguitar]

We use a Symbol model CS4070 scanner to read the barcodes on the kegs. It connects to computer via USB. I then open a workbook in excel and transfer the serial numbers into the spread sheet via cut and paste. Takes maybe 10 minutes to do a few pallets worth of kegs.

[Woolsocks]

Here ya go

My file is here: https://dl.dropboxusercontent.com/u/...t%20Public.xls

Otherwise, check out KegID - that's what we use now.

[Kmontgomery24]

Ditto,, link not working,,, If anyone has file to share,,, could you please email to kmontgomery24@yahoo.com

Thanks
Kelly Montgomery
Brewery In Planning

[dbbluest]

keg tracking spreadsheet

Does anyone have the file to share? The dropbox link is no longer active.

Best,

Dan

[ottonut]

except some states (like PA) require a deposit by law...

[Woolsocks]

The question of charging deposits has come up off-forum. Here's a response I just sent about what we do:

We decided not to charge deposits because people then feel entitled to keep the keg if they're willing to lose the deposit. If we charged enough deposit ($150) to cover the lost keg, we'd lose sales because people wouldn't want to lay out the deposit. Add in the accounting challenges, and it just wasn't worth it.

Most people pay for the keg with a credit card, so we make them sign a sheet authorizing us to charge their credit card for lost, stolen, damaged, etc. kegs up to $150. We've never actually had to charge anyone's card, but we've had to threaten it a couple times. Seems to work.

[Woolsocks]

I've sent it out to a bunch of people, so I figured I'd just post a link here instead of continuing to send everybody individual emails:

https://dl.dropbox.com/u/11335021/ho...t%20Public.xls

It's a little complicated with array functions and stuff, but bottom line is when the keg goes out, we enter it into the main sheet. Each keg has a unique number. When a keg comes back, or gets cleaned, we record the number in the "kegs returned" sheet, which in turn updates the main sheet. Then with data filtering, we can easily see what kegs are out, where they are, and how long they've been missing. Once it's set up, it takes maybe 1/2 hour a week to keep it up to date.

Let me know if you have questions!

[Battenkill]

Thanks!

Thanks for the great spreadsheet. It fit perfect with my operation and is in use now.

[Woolsocks]

That's pretty close to what we do. Each has a number and you track who has what number and when you last cleaned each one. Only way to screw it up is to send out a dirty keg, in which case you've got bigger things to worry about...

[Moonlight]

Numbering your kegs is a good place to start. When I started following my kegs, I wrote the keg numbers on the invoices, and kept a list of which was washed when.

[Woolsocks]

Send PM with your email and I'll send you our (efficient) spreadsheet for this purpose.