Formula Help Find Values

V

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.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
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
 
Upvote 0
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>
 
Upvote 0
Piece of cake. Give me a second to copy your spreadsheet, fill it with delights and post it back. (smile)
 
Upvote 0
<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>
 
Upvote 0
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>
 
Upvote 0
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
 
Upvote 0
VBABasix said:
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
Click to expand...

<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>
 
Upvote 0
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.
 
Upvote 0
VBABasix said:
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.
Click to expand...

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:
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
#REF! error when using INDEX MATCH
Replies
5
Views
106
Fluff
Fluff
S
  • Solved
How to Rotate Rows to Columns with Large Data Set
Replies
8
Views
233
kevin9999
K
M
  • Question
Trouble with a formula returning duplicate values
2
Replies
19
Views
309
Cubist
Cubist
S
  • Solved
Rotating Data from Horizontal to Vertical using VBA Code
Replies
3
Views
144
kevin9999
K
K
  • Question
Looking for assistance using MS Excel VBA to hide rows
Replies
4
Views
342
kcampbell675
K

Forum statistics

Threads
1,214,861
Messages
6,121,973
Members
449,059
Latest member
oculus

Share this page

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
Back
Top