# Formula Help Find Values

#### VBABasix

##### Board Regular
I have a series of worksheets that have materials displayed as shown below:

Column A Column B Column C
Material A

material B
Material V
Material F
Total Price 123456

Material C

material B
Material V
Material G
Promo Price 123456

I would like to know if there is a formula can perform a lookup based upon the material in column A and then return the Total price in column C. For each material in column A there is a price but only 1 total price for each grouping. Any help would be greatly appreciated.

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### Andrew Fergus

##### MrExcel MVP
Hi

I don't understand your layout 100% - are you able to use one of the html tools to show the actual data layout? (see the top of the Excel formum - from memory there is a 'sticky' thread on the subject.) Also, what is the significance of a "total price" versus a "promo price"?

Using your sample data, would you be looking up the value for materials A and C? Or are you also expecting to be able to look up the value using materials B,V,F & G? If so, it appears a material can be used in multiple 'materials'?? This is the part I'm not quite understanding......are materials B, V, F & G sub-materials of A & C - or have I misunderstood something?

Andrew

#### VBABasix

##### Board Regular
Andrew:

I have included the html with example data. In the excel file I have a worksheet called PricemasterFile with a listing of all the materials. What I would like to be able to do is pull in all the prices associated with the materials that are promo prices so that in the PriceMasterfile tab I would have a single listing of material and promo price. For example in the pricemasterfile tab I would have a listing for material A and a price of 832467.​

<SCRIPT language=JavaScript src="<a href=" popup.js" colo puremis sun www.interq.or.jp http:></SCRIPT><CENTER><TABLE" target="_blank">http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE< a>cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" colSpan="5" bgColor="#0c266b"><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left>Microsoft Excel - htlm_example.xls</TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 11.0 : OS = Windows XP </TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" colSpan="5" bgColor="#d4d0c8"><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</TD><TD vAlign=center align=right><FORM name=formCb059465><INPUT onclick='window.clipboardData.setData("Text",document.formFb543420.sltNb142651.value);' type=button value="Copy Formula" name=btCb290334></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" colSpan="5" bgColor="white"><TABLE border=0><TBODY><TR><FORM name=formFb543420><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value" name=sltNb142651><OPTION value==SUM(C3:C7) selected>C9<OPTION value==C9-C10>C11<OPTION value==SUM(C16:C20)>C22<OPTION value==C22-C23>C24</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==SUM(C3:C7) name=txbFb965317></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle">
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
</CENTER>

#### Excelestial

##### Well-known Member
Piece of cake. Give me a second to copy your spreadsheet, fill it with delights and post it back. (smile)

#### Excelestial

##### Well-known Member

<TABLE style="WIDTH: 722pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=962 border=0><COLGROUP><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 149pt; mso-width-source: userset; mso-width-alt: 7277" width=199><COL style="WIDTH: 152pt; mso-width-source: userset; mso-width-alt: 7387" width=202><COL style="WIDTH: 141pt; mso-width-source: userset; mso-width-alt: 6875" span=2 width=188><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl82 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=21>

</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=109>A</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=199>B</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=202>C</TD><TD class=xl84 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=188>D</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=188></TD></TR><TR style="HEIGHT: 37.5pt" height=50><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 37.5pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=50>1</TD><TD class=xl65 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material A</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Material Group A</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Price</TD><TD class=xl92 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl94 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 141pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=188>You can create a drop-down to populate cell H4 or you can type it in.</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>2</TD><TD class=xl68 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl93 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Material B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>3</TD><TD class=xl71 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material B</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material B</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$813,700 </TD><TD class=xl93 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 141pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=188>\$1,627,400 </TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>4</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material V</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material V</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$9,217 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>5</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>6</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material F</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material F</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Included</TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>7</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material G</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material G</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$14,050 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>8</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=35>9</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Total Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$836,967 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>10</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Discount</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$4,500 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=35>11</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Promo Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$832,467 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>12</TD><TD class=xl78 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=21>13</TD><TD class=xl79 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl80 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl80 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27pt" height=36><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 27pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=36>14</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material C</TD><TD class=xl81 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Material Group C</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>15</TD><TD class=xl68 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>16</TD><TD class=xl71 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material B</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material B</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$813,700 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>17</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material V</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material V</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$9,217 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>18</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>19</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material F</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material F</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Included</TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>20</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material G</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material G</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$14,050 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>21</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=35>22</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Total Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$836,967 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>23</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Discount</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$3,650 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27pt" height=36><TD class=xl87 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 27pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=36>24</TD><TD class=xl88 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl89 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=199>Promo Price</TD><TD class=xl90 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=202>\$833,317

</TD><TD class=xl91 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white"> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>

#### Excelestial

##### Well-known Member
Oops...forgot you can't see the formulas from the message board. here it is again...formula exposed:

<TABLE style="WIDTH: 722pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=962 border=0><COLGROUP><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 149pt; mso-width-source: userset; mso-width-alt: 7277" width=199><COL style="WIDTH: 152pt; mso-width-source: userset; mso-width-alt: 7387" width=202><COL style="WIDTH: 141pt; mso-width-source: userset; mso-width-alt: 6875" span=2 width=188><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl82 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=21>

</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=109>A</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=199>B</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=202>C</TD><TD class=xl84 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=188>D</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=188></TD></TR><TR style="HEIGHT: 37.5pt" height=50><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 37.5pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=50>1</TD><TD class=xl65 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material A</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Material Group A</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Price</TD><TD class=xl92 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl94 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 141pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=188>You can create a drop-down to populate cell H4 or you can type it in.</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>2</TD><TD class=xl68 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl93 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Material B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>3</TD><TD class=xl71 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material B</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material B</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$813,700 </TD><TD class=xl93 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 141pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=188> =SUMIF(D5:D26,H4,F5:F26)</TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>4</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material V</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material V</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$9,217 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>5</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>6</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material F</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material F</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Included</TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>7</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material G</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material G</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$14,050 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>8</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=35>9</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Total Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$836,967 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>10</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Discount</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$4,500 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=35>11</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Promo Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$832,467 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>12</TD><TD class=xl78 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=21>13</TD><TD class=xl79 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl80 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl80 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27pt" height=36><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 27pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=36>14</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material C</TD><TD class=xl81 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Material Group C</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>15</TD><TD class=xl68 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>16</TD><TD class=xl71 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material B</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material B</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$813,700 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>17</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material V</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material V</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$9,217 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>18</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>19</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material F</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material F</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Included</TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=69>20</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material G</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material G</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$14,050 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>21</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=35>22</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Total Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$836,967 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=20>23</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Discount</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$3,650 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27pt" height=36><TD class=xl87 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 27pt; BACKGROUND-COLOR: #d4d0c8" width=76 height=36>24</TD><TD class=xl88 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl89 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=199>Promo Price</TD><TD class=xl90 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=202>\$833,317

</TD><TD class=xl91 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white"> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>

#### VBABasix

##### Board Regular

I should have explained further that in the example the Material Group A and Material Group C are composed of the materials that are shown under them. So Material Group A has a total price of 836967. Also there are 20+ sheets that have similar data, ideally the lookup function would move across multiple sheets.

Thanks

#### Excelestial

##### Well-known Member
I should have explained further that in the example the Material Group A and Material Group C are composed of the materials that are shown under them. So Material Group A has a total price of 836967. Also there are 20+ sheets that have similar data, ideally the lookup function would move across multiple sheets.

Thanks

<TABLE style="WIDTH: 853pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1137 border=0><COLGROUP><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 149pt; mso-width-source: userset; mso-width-alt: 7277" width=199><COL style="WIDTH: 152pt; mso-width-source: userset; mso-width-alt: 7387" width=202><COL style="WIDTH: 141pt; mso-width-source: userset; mso-width-alt: 6875" span=2 width=188><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 83pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=111 height=21></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=76></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=109></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=199></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=202></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=188></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=188></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21></TD><TD class=xl82 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>

</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=109>A</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=199>B</TD><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=202>C</TD><TD class=xl84 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=188>D</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 37.5pt" height=50><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 37.5pt; BACKGROUND-COLOR: transparent" height=50></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>1</TD><TD class=xl65 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material A</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Material Group A</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Price</TD><TD class=xl92 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl94 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 141pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=188>You can create a drop-down to populate cell H4 or you can type it in.</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>2</TD><TD class=xl68 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl93 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl95 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Material A</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 39pt" height=52><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 39pt; BACKGROUND-COLOR: transparent" height=52> =\$D\$3</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>3</TD><TD class=xl71 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material B</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material B</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$813,700 </TD><TD class=xl93 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD class=xl96 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 141pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=188> =SUMIF(B5:B26,H4,F5:F26)+'Sheet2 (2)'!H5</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" height=69> =\$D\$3</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>4</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material V</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material V</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$9,217 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> =\$D\$3</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>5</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" height=69> =\$D\$3</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>6</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material F</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material F</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Included</TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" height=69></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>7</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material G</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material G</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$14,050 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> =D9</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>8</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" height=35></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>9</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Total Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$836,967 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>10</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Discount</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$4,500 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" height=35></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>11</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Promo Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$832,467 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>12</TD><TD class=xl78 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>13</TD><TD class=xl79 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl80 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl80 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27pt" height=36><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 27pt; BACKGROUND-COLOR: transparent" height=36></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>14</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material C</TD><TD class=xl81 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Material Group C</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> =\$D\$16</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>15</TD><TD class=xl68 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" height=69> =\$D\$16</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>16</TD><TD class=xl71 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material B</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material B</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$813,700 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" height=69> =\$D\$16</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>17</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material V</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material V</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$9,217 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> =\$D\$16</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>18</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" height=69> =\$D\$16</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>19</TD><TD class=xl74 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material F</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material F</TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>Included</TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 51.75pt" height=69><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 51.75pt; BACKGROUND-COLOR: transparent" height=69></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>20</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109>Material G</TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Description Material G</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$14,050 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> =D22</TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>21</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl69 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202> </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" height=35></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>22</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Total Price</TD><TD class=xl77 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$836,967 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD class=xl85 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d4d0c8" width=76>23</TD><TD class=xl75 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl70 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=199>Discount</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=202>\$3,650 </TD><TD class=xl86 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: white" width=188> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 27pt" height=36><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 27pt; BACKGROUND-COLOR: transparent" height=36></TD><TD class=xl87 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: #d4d0c8" width=76>24</TD><TD class=xl88 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=109> </TD><TD class=xl89 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 149pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=199>Promo Price</TD><TD class=xl90 style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 152pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=202>\$833,317

</TD><TD class=xl91 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white"> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>

#### VBABasix

##### Board Regular
I am trying another approach. I have used the code from Ron de Bruin to consolidate all of the sheets that I have so that there is a master listing of materials. My goal is to have a formula that will can identify when there are multiple items, a promo price and then populate column D adjacent to the material description with the promo price so that I have a listing of material, material description, and price on a single line. Once this has been done, I would then be able to delete all lines except for row 2 and row 15 in the below example. The spacing is dynamic as there are multiple tables that the data is combined from so I do not know where the promo price will be in relation to the main material group other than it will always have a promo price and the material id field will be blank.

#### Excelestial

##### Well-known Member
I am trying another approach. I have used the code from Ron de Bruin to consolidate all of the sheets that I have so that there is a master listing of materials. My goal is to have a formula that will can identify when there are multiple items, a promo price and then populate column D adjacent to the material description with the promo price so that I have a listing of material, material description, and price on a single line. Once this has been done, I would then be able to delete all lines except for row 2 and row 15 in the below example. The spacing is dynamic as there are multiple tables that the data is combined from so I do not know where the promo price will be in relation to the main material group other than it will always have a promo price and the material id field will be blank.

The beauty of VLOOKUP, HLOOKUP, INDEX, MATCH and OFFSET functions is that they will look for the rows, columns, and particular cells for you. The table doesn't show clearly how the promo price is applied or what it is applied to. Does the Promo price apply to every material group above it?

Last edited:

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,190
Messages
5,835,896
Members
430,393
Latest member
hetherton

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back