Bamboo culms (poles) calculation

[marinpa]

I need to create a spreadsheet able to calculate the necessary material for bamboo furniture.
Considering the exterior diameters of bamboo culms are between 8 cm to 16 cm, I need to calculate how many poles of different diameters can fit in one metric tone, and how many poles (of different diameters) can fit in one container ( in feet) of x cubic meters.

Informative a container capacity is:
20 ft - 33.13 mc
40 ft - 76.20 mc


1) I need to calculate how many poles will fit in one metric tone.
The variables of the culms are:
* "L" length (in meters)
* "D" exterior diameter (in centimeters)
* "d" interior diameter (for most bamboos d = 0.82D)
* "t" wall thickness (in centimeters), where D=d+2t
* "mw" mass weight (xxx kg/cu.m)




2) I need to calculate how much material is needed for a structure in liniar meters and what would be its overall weight
The variables or the culms are:
* L
* D
* mass weight

3) I need to calculate the weight a given bamboo structure can hold, considering the 2.54 cm of bamboo supports 7 1/2 of weight




Thank you!

 

[marinpa]

I rephrase the top part...

I need to to calculate the necessary material for bamboo furniture.
Considering the exterior diameters of bamboo culms are between 8 cm to 16 cm, I need to calculate:
a) how many poles at the same length but different diameters can fit in one metric tone
b) how many poles at the same length but different diameters can fit in a container of L length, W width and H height (in meters)
(Ex. dimensions container LWH in meters 5.89 x 2.3 x 2.38)

Thank you!

 

[Gerald Higgins]

Your request seems quite complicated.
I think I get what you're basically trying to do, but I don't think you're giving us enough information to enable us to help you.

QUESTION - Do you know how to perform these calculations without Excel ?

If YES, how do you do it ?

If NO, then I don't think we're going to be able to help you, I certainly can't.

 

[marinpa]

For calculating a bamboo culm, at the present time, in order to find out the volume in cm/m3, I am using this formula:
V=TT*h*(R² - r²) = TT * h * (D² - d²) / 4



However, I would like to go one step farther and calculate the weight of a culm as well, using the following assumptions:

* the average weight of a bamboo culm (dry) is 300-400 kg/m3
* the wall thickness will also about 10% of the outside diameter (thus making the assumption the inside diameter is 10% less than outside one)

Thank you for your time

 

[Gerald Higgins]

OK, so how are you going to go that "one step farther" ?

If you need help turning your basic formula into an Excel formula, that's fine, we can do that.

If you need help working out what the basic formula should be, I personally can't help you with that.