Calculating three most efficient lengths

[Nanaia]

What formula, or combination of formulae, would be uses to look at all the numbers in a column and calculate the three sheet lengths they would fit best on. (does that make sense?)
Goal: To determine which three sheet lengths would be most efficient for the part lengths to nest into for a given job (metal coil industry). Minimum sheet length 86”, maximum 150”. Sheets are cuts in increments of 6”.
I understand which formulas to use to find out the largest number in the column, the shortest number in the column, and the number that occurs the most often. I’m not sure if I can accomplish my goal on this, but I figured this is Excel, there’s a way to do this.

 

[Nanaia]

Sorry - I lacked some information (what I want) on that last post and the chart proved to be larger than expected. My apologies.

I don't know how to word what I'm looking for beyond what I've posted.

I have another idea floating around my foggy brain that might be incorporated into this... Our sheets are cut from coils that are typically 60" wide, we cut the length of the blanks as needed. Would it be easier to calculate the sheet lengths if we included the panel widths too? Since it's a fixed dimension, it's easier to figure out what fits the width than it is to pick what length works best with the mix of panel lengths that're needed.

 

[markmzz]

Sorry - I lacked some information (what I want) on that last post and the chart proved to be larger than expected. My apologies.

I don't know how to word what I'm looking for beyond what I've posted.

I have another idea floating around my foggy brain that might be incorporated into this... Our sheets are cut from coils that are typically 60" wide, we cut the length of the blanks as needed. Would it be easier to calculate the sheet lengths if we included the panel widths too? Since it's a fixed dimension, it's easier to figure out what fits the width than it is to pick what length works best with the mix of panel lengths that're needed.

Hi!

I’m sorry, but your tables didn't help.

Where is the column of the default sheet sizes (that you said is exact)?

Try to make something like my table of the post #5. If possible, something like this:


[TABLE="class: grid, width: 643"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]I have this[/TD]
[TD][/TD]
[TD]I have this[/TD]
[TD]I have this[/TD]
[TD]I have this[/TD]
[TD][/TD]
[TD][/TD]
[TD]I want this[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Default sheets[/TD]
[TD][/TD]
[TD]Sheet1[/TD]
[TD]Sheet2[/TD]
[TD]Sheet3[/TD]
[TD]Total[/TD]
[TD][/TD]
[TD]Best Default Sheet[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]84[/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD="align: right"]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]124[/TD]
[TD][/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]96[/TD]
[TD][/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD="align: right"]138[/TD]
[TD][/TD]
[TD="align: right"]144[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]102[/TD]
[TD][/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD="align: right"]113[/TD]
[TD][/TD]
[TD="align: right"]114[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]108[/TD]
[TD][/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]67[/TD]
[TD][/TD]
[TD="align: right"]138[/TD]
[TD][/TD]
[TD="align: right"]144[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]114[/TD]
[TD][/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]27[/TD]
[TD][/TD]
[TD="align: right"]128[/TD]
[TD][/TD]
[TD="align: right"]132[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD="align: right"]145[/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]132[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]147[/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]138[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]144[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]***[/TD]
[TD]**************[/TD]
[TD]**[/TD]
[TD]********[/TD]
[TD]********[/TD]
[TD]********[/TD]
[TD]*******[/TD]
[TD]********[/TD]
[TD]*****************[/TD]
[TD]**[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz

 

[Nanaia]

Ok. Thank you.