Forum Discussion

Cassie_B40's avatar
Cassie_B40
Copper Contributor
Oct 30, 2020

Help with data calculations for a brewery

Hello! I work in the planning department of a local brewery and needed some help with a data sheet we have been trying to create.  I need a spreadsheet to calculate the weight of kegs (empty and ful...
excel
Formulas and Functions
Cassie_B40's avatar
Cassie_B40
Copper Contributor
Nov 02, 2020

NikolinoDE we measure in US Gallons for our kegs, but we weigh all assets by LBS. Cases of beer are 20.6 lbs each, and 100 can go on 1 pallet (which weighs 25 lbs)   1/6 BBL (barrel) kegs weigh 60 lbs each and empty weigh 16 lbs. We can fit 20 of those kegs on 1 pallet when they are full. but they can also stack in stacks of 2. So, 40 1/6 bbl kegs on 1 pallet position, using 2 pallets. 

1/2 BBL kegs are our largest. 160.5 LBS when full, 29.8 LBS when empty, and 8 can fit on one pallet. We generally stack these as well so 16 kegs, one pallet position, using two pallets....

 

I know all the weights and info I need, I just go blank whenever I use Excel ..

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Nov 02, 2020

Cassie_B40 

 

I hope that I do not strain your patience, but I am not a beer brewer and do not know about your products.

Unfortunately not with the American masses either, but there are comparison tables for this.

Although German, I only drink non-alcoholic beer and only on holidays :)) ...Prost!
Maybe I'm not the right person for drinking beer ... but I'll try to offer you a tailor-made solution as far as possible :)...me and many others here in this Community.

Therefore I ask you to open the file, insert the requested information and send it back.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

Resources