Formula Help Find Values

VBABasix

Board Regular
Joined
Aug 15, 2005
Messages
52
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.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
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
Joined
Aug 15, 2005
Messages
52
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">
</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align="middle"><CENTER>A</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align="middle"><CENTER>B</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align="middle"><CENTER>C</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align="middle"><CENTER>D</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>1</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material A</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material Group A</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 1.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Price</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>2</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>3</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material B</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material B</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$813,700</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>4</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material V</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material V</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$9,217</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>5</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>6</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material F</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material F</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Included</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>7</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material G</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material G</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$14,050</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>8</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>9</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Total Price</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$836,967</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>10</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Discount</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$4,500</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>11</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Promo Price</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$832,467</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>12</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>13</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 1.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>14</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material C</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material Group C</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>15</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>16</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: top; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material B</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material B</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$813,700</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>17</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material V</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material V</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$9,217</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>18</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>19</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material F</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material F</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Included</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>20</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Material G</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Description Material G</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$14,050</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>21</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>22</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Total Price</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$836,967</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>23</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Discount</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$3,650</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" width="2%" align="middle"><CENTER>24</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 1.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">Promo Price</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">$833,317</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" colSpan="5"><TABLE width="100%" align=left VALIGN="TOP"><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; WIDTH: 120pt; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff" align=left>Sheet1</TD><TD></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
[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
Joined
Jan 2, 2009
Messages
828
Piece of cake. Give me a second to copy your spreadsheet, fill it with delights and post it back. (smile)
 

Excelestial

Well-known Member
Joined
Jan 2, 2009
Messages
828

ADVERTISEMENT

<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
Joined
Jan 2, 2009
Messages
828
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
Joined
Aug 15, 2005
Messages
52

ADVERTISEMENT

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
Joined
Jan 2, 2009
Messages
828
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
Joined
Aug 15, 2005
Messages
52
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
Joined
Jan 2, 2009
Messages
828
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:

Watch MrExcel Video

Forum statistics

Threads
1,122,477
Messages
5,596,384
Members
414,063
Latest member
N_Bates

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top