DIY BIAB Bag Design Tool

[plan_ahea]

Just posted this over in /r/homebrewing, but thought it belonged here too.
---
So in typical fashion, I started looking into making my own BIAB bag as soon as I ordered one online. (Shout-out to biab-brewing.com - great bags, hands down best prices on custom BIAB bags for Canadian brewers.) After a bit of poking around various forums, it looked like there are two main designs out there: tapered pillow case (simple) and truncated cone (slightly less simple). I saw another spreadsheet to calculate measurements for both designs given one's kettle dimensions (don't remember where, sorry) but thought the spreadsheet could use some redesign/cleaning up.

Link: BIAB Bag Design Tool (Hosted on Google Drive, but needs to be opened in Excel to display properly)
Hopefully this spreadsheet can help someone else on their journey to all-grain brewing. Happy brewing/DIYing!

--
2022-09-26: updated with new link

 

[plan_ahea]

Just realized it might be useful to have a screenshot of the spreadsheet to give an idea of what it looks like without blindly downloading it:

 

[Suicid]

Thanks for sharing, great tool!
Easy math and great visualization

 

[1MadScientist]

plan_ahea -

I see that you joined BIABrewer.info recently.

There is a sticky by "mr.jadkowski" called "instructions for sewing a truncated cone bag" in 2013 and "bionut" posted a spreadsheet on post #24 he wrote; http://biabrewer.info/viewtopic.php?f=53&t=2052#p29520

Thanks for giving credit to the site.

MS

 

[plan_ahea]

Just posted this over in /r/homebrewing, but thought it belonged here too.
---
So in typical fashion, I started looking into making my own BIAB bag as soon as I ordered one online. (Shout-out to biab-brewing.com - great bags, hands down best prices on custom BIAB bags for Canadian brewers.) After a bit of poking around various forums, it looked like there are two main designs out there: tapered pillow case (simple) and truncated cone (slightly less simple). I saw another spreadsheet to calculate measurements for both designs given one's kettle dimensions (don't remember where, sorry) but thought the spreadsheet could use some redesign/cleaning up.

Link: BIAB Bag Design Tool (Hosted on Google Drive, but needs to be opened in Excel to display properly)
Hopefully this spreadsheet can help someone else on their journey to all-grain brewing. Happy brewing/DIYing!

Update - sharing a new link, something about Google's sharing settings changed:
Updated Link Here

 

[Upstate12866]

Thanks, this is awesome for my next attempt to sew one.

 

[tennesseean_87]

I recently made a bag and was planning ot use this, however I couldn't figure out how I would get the conical pattern onto my material in an accurate way. So I did something like a combination where it's mostly cylindrical/pillow-case, though a little larger at the top for getting outside the kettle lip, with a round bottom piece like your fustrum shape. It worked well for my first brew.