create a spreadsheet containing a table of dimensions that are multiples of up to six

**MickElmes** · 10-11-2007, 12:34 AM

I am trying to create a spreadsheet containing a table of dimensions that are multiples of up to six loadable variables.

I work for a stainless steel tank manufacturer. The body of tanks are formed from coil stock of varying widths. Typically these might be 1200mm, 1500mm, 2000mm and possibly 1800mm as well as the imperial equivalents. This could mean up to eight variables but in reality all are unlikely at any one given time.

We are given the volume that the tank is required to contain and a target preferred diameter. The theoretical height is therefore derived from this. But now comes the tricky bit. It is desirable, to minimise cost of welding by minimising the number of strakes or wrappers.

Can anyone give me a formula or whatever that can be used to do this and hopefully generate a table of close heights up to say 40 meters. Thus allowing an operator to select from say five presented options.

I have a table in a spreadsheet that the three principal widths of 1200mm 1500mm and 2000mm generate. It was created for me a while ago by a gentleman working at the Amsterdam Museum that I’m happy to send for perusal. The trouble is he never told me how he did it and no matter how hard I try, I cannot discover the method or formula.
The first column gives the total combined height, the second the number of 1200mm wrappers, the third the number of 1500mm and the last the number of 2000mm. It is that simple

**shg** · 10-11-2007, 12:45 AM

G'day, Mick,

I'm curious, and like math problems. Please post an example and as much supplemental info as possible.

generate a table of close heights up to say 40 meters

Those are honking large tanks.

My first job out of school was working for a company that manufactured textile dyeing and drying equipment. We had a shear that could cut 10 feet of 1/2" stainless stock. When it fired, the entire building shook.

**MickElmes** · 10-11-2007, 04:49 AM

Gidday shg
Very new at this, hope I've done it correctly.
You will find that there are two tables, one includes 2000mm modules called extendedH the other does not called limitedH. If you select Coil in cell K8 it selects from the extendedH table and if you select Sheets from limitedH
This spreadsheet is not adequate now as indicated in mt post. We now need to be able to allow for up to six variables as the wrapper material widths
Hope I make myself clear