I know, it's a weird title, but I cannot explain any better ; here's what I'm looking for.
I have flexible plates with specific dimensions
They need to be rolled up into a spiral and packed in a box.
And I need to figure out how many rolls fit into that box.
The dimensions are
* plate length = 120 cm
* plate width = 30 cm
* plate thickness = 1 cm
They need to be wrapped around a tube of 3 cm diameter
* box width = 33 cm
* box length = 60 cm
* box height = 40 cm
To calculate how many rolls I need to know the diameter of the rolled up plate.
With that info, I can calculate the number of rolls in a layer and the number of layers in the box height.
Does anyone have a clue how I can calculate this diameter?SpiralDiameter.xlsb
Bookmarks