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.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-general/1227194-calculating-three-most-efficient-lengths.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Nanaia]

My apologies. I didn't realize the two sites were connected. I'll add the links.

 

[Nanaia]

https://www.excelforum.com/excel-general/1227194-calculating-three-most-efficient-lengths.html

 

[markmzz]

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.

Hi!

Some thing like this:


[TABLE="class: grid, width: 608"]
<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]1[/TD]
[TD]Default sheets[/TD]
[TD][/TD]
[TD]Sheet1[/TD]
[TD]Sheet2[/TD]
[TD]Sheet3[/TD]
[TD]Sheet4[/TD]
[TD]Total[/TD]
[TD]Best Default Sheet[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]84[/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]35[/TD]
[TD][/TD]
[TD="align: right"]124[/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]96[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]102[/TD]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]84[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]108[/TD]
[TD][/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]144[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]114[/TD]
[TD][/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]114[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]67[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]144[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: right"]132[/TD]
[TD][/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]27[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]132[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]138[/TD]
[TD][/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]145[/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]144[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/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]14[/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]


If not, give to us more details. With a example (what you have and what you want) like the table above.

Markmzz

 

[Nanaia]

markmzz - Your table is very close to what I'm looking for...providing I'm understanding what I'm viewing. The default sheet sizes is exact. I'm not sure I understand how the rest of it is organized or what the relevance of the numbers are though.
Thank you for helping.

 

[markmzz]

If not, give to us more details. With a example (what you have and what you want) like the table above.

markmzz - Your table is very close to what I'm looking for...providing I'm understanding what I'm viewing. The default sheet sizes is exact. I'm not sure I understand how the rest of it is organized or what the relevance of the numbers are though.
Thank you for helping.

Ok.

The default sheet sizes is exact.​

But, we need more details. With a example (what you have and what you want).

Markmzz

 

[Nanaia]

I'm trying to figure out how to word it...
Part of our job is to chose what three sheet lengths need to be cut from the coil for the job that have the least amount of waste and tell our compiler. We make panels that vary in length and we have a program that "elaborates" (nests? compiles? groups?) the panels for job onto the three sheet sizes we tell it to use. The CSV for the job has all the flat lengths listed in one column (column S). I wanted to be able to have another worksheet in the background (meaning it is in the same file and references the CSV worksheet) that looks at column S from the CSV says (somehow) what three sheet length sizes would be best suited for the job so we have the least amount of waste. Some of our sheets are painted with metallic paint, so to keep it so all pieces look right when installed we keep it so the length is always going to be the length, never the width so when two pieces are side by side they are the same colour. Looking at this I see I may need to have several steps involved, which is fine. I'm asking for help to narrow down what the steps are.
Please correct me if I'm wrong, regarding the table Markmzz posted - are the "sheet 1", "sheet 2" column headings referring to the part lengths and the totals in the cells listed in the "sheet" columns are the number of times the part fit on the sheet? Just looking for clarification.
Thank you.

 

[markmzz]

I'm trying to figure out how to word it...
Part of our job is to chose what three sheet lengths need to be cut from the coil for the job that have the least amount of waste and tell our compiler. We make panels that vary in length and we have a program that "elaborates" (nests? compiles? groups?) the panels for job onto the three sheet sizes we tell it to use. The CSV for the job has all the flat lengths listed in one column (column S). I wanted to be able to have another worksheet in the background (meaning it is in the same file and references the CSV worksheet) that looks at column S from the CSV says (somehow) what three sheet length sizes would be best suited for the job so we have the least amount of waste. Some of our sheets are painted with metallic paint, so to keep it so all pieces look right when installed we keep it so the length is always going to be the length, never the width so when two pieces are side by side they are the same colour. Looking at this I see I may need to have several steps involved, which is fine. I'm asking for help to narrow down what the steps are.
Please correct me if I'm wrong, regarding the table Markmzz posted - are the "sheet 1", "sheet 2" column headings referring to the part lengths and the totals in the cells listed in the "sheet" columns are the number of times the part fit on the sheet? Just looking for clarification.
Thank you.

Hi!

To make the table of the post #5, I used the below text (post for you in another forum):

"For example, if the part is 90" long it would fit on a 96" sheet more efficiently than on a 150" sheet. Also, a 44"plus a 45" and a 35" would bit better on a 126" sheet than144" sheet or even a 120" sheet because there is less waste."

You're last post help a little, now post a table with examples (what you have and what you want - 5 examples or more).

Markmzz

 

[Nanaia]

I'll try.


This is from my Ref2 (reference) sheet
[TABLE="class: grid, width: 178"]
<tbody>[TR]
[TD="colspan: 2"]Panel Lengths[/TD]
[/TR]
[TR]
[TD="align: right"]124.209[/TD]
[TD]1st most common[/TD]
[/TR]
[TR]
[TD="align: right"]106.709[/TD]
[TD]2nd most common[/TD]
[/TR]
[TR]
[TD="align: right"]31.709[/TD]
[TD]3rd most common[/TD]
[/TR]
[TR]
[TD="align: right"]70.549[/TD]
[TD]4th most common[/TD]
[/TR]
[TR]
[TD="align: right"]63.709[/TD]
[TD]5th most common[/TD]
[/TR]
[TR]
[TD="align: right"]124.209[/TD]
[TD]Longest[/TD]
[/TR]
[TR]
[TD="align: right"]9.049[/TD]
[TD]Shortest[/TD]
[/TR]
[TR]
[TD="align: right"]31.439[/TD]
[TD]Widest[/TD]
[/TR]
[TR]
[TD="align: right"]14.417[/TD]
[TD]Narrowest[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]




This is columns S and T in the CSV worksheet
[TABLE="class: grid, width: 118"]
<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2673;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2929;"> <tbody>[TR]
[TD="width: 75, bgcolor: transparent"]Face Len[/TD]
[TD="width: 82, bgcolor: transparent"]Face Width[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.625[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]102.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]78.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]45.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]26.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]107.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]19.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]96.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]34.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]77.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]37.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]104.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]115.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]64.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]84.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]101.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]67.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]58.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]42.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]111.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]58.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.625[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]102.125[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.625[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]102.125[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]32.75[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]60.5[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]29.75[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15.5[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]39.5[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.625[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]102.125[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.625[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]102.125[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.625[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]102.125[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]66[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]83.5[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]83.5[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]83.5[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]47.125[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]47.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]66[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]83.5[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]93.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]93.125[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]93.125[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]93.125[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]93.125[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]93.125[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]66[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]24.125[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]66[/TD]
[TD="bgcolor: transparent, align: right"]24.125[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]24.125[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]63.125[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]63.125[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]63.125[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]63.125[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]63.125[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]63.125[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]63.125[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.625[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.875[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]66[/TD]
[TD="bgcolor: transparent, align: right"]23.875[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="align: right"]9.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="bgcolor: transparent, align: right"]24.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="bgcolor: transparent, align: right"]18.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="align: right"]12.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="bgcolor: transparent, align: right"]26.75[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]71.375[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]59.75[/TD]
[TD="bgcolor: transparent, align: right"]23.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="align: right"]11.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]119.25[/TD]
[TD="bgcolor: transparent, align: right"]23.875[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]59.75[/TD]
[TD="align: right"]10.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]93.125[/TD]
[TD="bgcolor: transparent, align: right"]22.25[/TD]
[/TR]
</tbody>[/TABLE]