First off Bearcat, thank you for your efforts in creating this spreadsheet!! Your spreadsheet looks like a solution I need... but I'm afraid I can't figure out how to use it. I'm plugging in the numbers but I'm not exactly sure how to fill out a couple of them... I'd greatly appreciate any answers dumbed down as much as possible:
ID of my beer line: I measured and am getting about 3.5/16 with my tape measure but on beverage factory.com it says my tower came with 3/16
I've read quite a few things on CO2 volume, and they all make me feel pretty stupid. Currently I have a keg of Stone IPA, I don't understand how to figure out this part for the spreadsheet... Do I control this, or did Stone? it makes not sense to me.
Shank bore: I can't find this info on beverage factory, and don't know how to tell??? I assume i would be 3/16 too?
So the figures I plugged in are
Am i reading this right? I'd have to go up to 40 degrees for a good pour?
I have about $1000 invested into my kegerator, wasted so much beer and time, and honestly I just want to enjoy a cold foam free glass and just enjoy the fruits of this labor
When I decrease the last figure from 40" to 25.5" it looks like I can have it at 34 degrees at 7.5 psi for frosty perfection? before I go cutting my beer line to 2 feet and potentially shooting myself in the foot. Could you help me out?
Thanks again, can't wait to use this thing