This guide demonstrates how to use this spreadsheet to construct a stackable wooden beer crate for your bottles of home-brew. The spreadsheet is fully editable so it can be modified to suit the type of bottles you have in your collection. It also includes instructions on how to construct cardboard dividers to align the bottles in the crate. This is what the finished product will look like:
1. Download the spreadsheet.
2. The yellow fields in the spread sheet are editable. Fill in the bottle diameter, number of bottles and divider thickness. The spreadsheet will suggest the internal dimensions for the crate.
4. In the next table fill in how many crates you want and what material you will be using.
6. Fix the red boards to the blue boards. I used ø3×25 screws but you can use nails or glue. Leave the top blue board down the thickness of the floor board (yellow) so that the crates will be stackable. You need 2 of these frames per crate.
8. Turn the crate upside down and fix the floor boards (yellow). Leave 1mm clearance all around to make them easier to stack.
10. I used some 5mm cardboard for 2 crates and some 4mm mdf for the other 2. The cardboard can be cut with a craft knife. I cut the mdf on a table saw (the cardboard can be cut on the table saw too but mind your fingers! You’ll want them for drinking beer later.)