VERY simple bottling spreadsheet

[thedidey]

Hey all,

Did a search and didn't see anything like this. It's a very simple spreadsheet that converts your gallons/oz of beer to ounces. Then you can input the number of 22 oz or 12 oz and it will calculate how many you need of the other. Inputs are in blue.

Like I said, pretty simple, but it's handy.

Note: It rounds down for number of bottles and up for number of caps. And I did this in open office (and don't have Microsoft Office) so I'm not sure how it will look in excel.

http://www.mediafire.com/?sharekey=7e6e2913ef2eb7a708f8df73f2072ed602787ab556b17186947708e37b913e74

Cheers.

 

[homebrewer_99]

Too many cookies to get there and it asks for a login...

Sorry, but I've limited my log-ins and passwords to 999...j/k...

 

[thedidey]

http://www.mediafire.com/download.php?iz1mikeoziz


Guess this might be the one. Sorry

 

[homebrewer_99]

All I get is this message:

Your user identity is invalid, please login or use a supported browser to save files.

Must be my cookies...

 

[UnaBonger]

Worked for me, thanks

 

[homebrewer_99]

Definitely a cookie problem...I would not allow it...

 

[Brewin_CRAZY]

Its cool but seems like a little bit of overkill to me. 1 gal =128 fl oz, 5 gal = 640 fl oz, 10 is 1280 (I do 10 gal batches). Use the crap calculator in my brew stuff to divide 640 or 1280 by 22 or 12 whatever you have handy. But I gotta give it to ya, if you just want an easy spreadsheet for it, nicely done. BTW the only math I use is 10 gal/2 yup, it will fit in my kegs :cross::cross: