I have been tasked with providing a solution which I thought I could do via VLookup or SUMIF but it appears not to work.
I have a worksheet with Shop names and product codes then in the range amount of products they have sold, this is created by the shops and sadly we can't get them to conform to our output. We have 4 different region codes which also helps identify what has been sold by which shop under which region.
We then have an Overall Sheet with a several columns which identifies the Shop, Product Code and Input Type (Which is the Region either 1, 2, FR or D) This sheet needs to keep the totals for each shop.
I ask if someone can guide me, if a formula will work or if I have to find a resolve via VBA (not so good here).
I am very happy to answer any questions, the team will use Excel 2010 for this.
Some sample layout is shown below from the Weekly sheet.
Next is the Overall sheet (Acts like the Master) where the fields are joined to gain a code which should then be able to look back on the Week 1 Sheet and sum the products. So the code column here Joins Store Code, Product Code and Input Type
I have a worksheet with Shop names and product codes then in the range amount of products they have sold, this is created by the shops and sadly we can't get them to conform to our output. We have 4 different region codes which also helps identify what has been sold by which shop under which region.
We then have an Overall Sheet with a several columns which identifies the Shop, Product Code and Input Type (Which is the Region either 1, 2, FR or D) This sheet needs to keep the totals for each shop.
I ask if someone can guide me, if a formula will work or if I have to find a resolve via VBA (not so good here).
I am very happy to answer any questions, the team will use Excel 2010 for this.
Some sample layout is shown below from the Weekly sheet.
1
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 106px"><COL style="WIDTH: 106px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"><COL style="WIDTH: 54px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #333399; COLOR: #ffffff; FONT-WEIGHT: bold" colSpan=2>week 1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #333399; COLOR: #ffffff; FONT-WEIGHT: bold" colSpan=2>15/06 - 21/06 2011</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="COLOR: #ffffff; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-WEIGHT: bold"></TD><TD></TD><TD></TD><TD>FR</TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 8pt; FONT-WEIGHT: bold">2</TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 25px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="COLOR: #ffffff; FONT-WEIGHT: bold"></TD><TD style="COLOR: #ffffff; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Product Code</TD><TD style="BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #ffff99; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Product Code</TD><TD style="BACKGROUND-COLOR: #ffff99; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #ffff99; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #ffff99; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #ffff99; FONT-SIZE: 8pt"></TD><TD style="BACKGROUND-COLOR: #ffff99; FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="BACKGROUND-COLOR: #333399; COLOR: #ffffff; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #333399; COLOR: #ffffff; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100405</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100407</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100404</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100406</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100412</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100410</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100405</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100407</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100404</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100406</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100412</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 8pt">2100410</TD></TR><TR style="HEIGHT: 50px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="BACKGROUND-COLOR: #333399; COLOR: #ffffff">Shop Code</TD><TD style="BACKGROUND-COLOR: #333399; COLOR: #ffffff">Nazwa sklepu</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 7pt">KUBEK 5 JAMNIK</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 7pt">KUBEK 7 SZNAUCER</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 7pt">KUBEK 4 BEAGLE</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 7pt">KUBEK 6 BULDOG</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 7pt">KUBEK 12 KOT PERSKI</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; FONT-SIZE: 7pt">KUBEK 10 KOT ROSYJSKI</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 7pt">KUBEK 5 JAMNIK </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 7pt">KUBEK 7 SZNAUCER </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 7pt">KUBEK 4 BEAGLE </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 7pt">KUBEK 6 BULDOG </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 7pt">KUBEK 12 KOT PERSKI </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 7pt">KUBEK 10 KOT ROSYJSKI </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center">Z0001</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center">Z0002</TD><TD>Zabka</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">1</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center">Z0004</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center">Z0005</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center">Z0011</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center">Z0013</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center">Z0014</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center">Z0015</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">1</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center">Z0017</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center">Z0019</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: center">Z0020</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">1</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center">Z0022</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center">Z0024</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: center">Z0025</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center">Z0026</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">1</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center">Z0030</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center">Z0032</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center">Z0033</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center">Z0034</TD><TD>Zabka</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
Next is the Overall sheet (Acts like the Master) where the fields are joined to gain a code which should then be able to look back on the Week 1 Sheet and sum the products. So the code column here Joins Store Code, Product Code and Input Type
Overall Results
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 76px"><COL style="WIDTH: 73px"><COL style="WIDTH: 77px"><COL style="WIDTH: 94px"><COL style="WIDTH: 88px"><COL style="WIDTH: 76px"><COL style="WIDTH: 100px"><COL style="WIDTH: 95px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="BACKGROUND-COLOR: #333399; FONT-FAMILY: Tahoma; COLOR: #ffffff; FONT-WEIGHT: bold">Start Date</TD><TD style="BACKGROUND-COLOR: #333399; FONT-FAMILY: Tahoma; COLOR: #ffffff; FONT-WEIGHT: bold">End Date</TD><TD style="BACKGROUND-COLOR: #333399; FONT-FAMILY: Tahoma; COLOR: #ffffff; FONT-WEIGHT: bold">store code</TD><TD style="BACKGROUND-COLOR: #333399; FONT-FAMILY: Tahoma; COLOR: #ffffff; FONT-WEIGHT: bold">Product code</TD><TD style="BACKGROUND-COLOR: #333399; FONT-FAMILY: Tahoma; COLOR: #ffffff; FONT-WEIGHT: bold">Description</TD><TD style="BACKGROUND-COLOR: #333399; FONT-FAMILY: Tahoma; COLOR: #ffffff; FONT-WEIGHT: bold">Input type</TD><TD style="BACKGROUND-COLOR: #333399; FONT-FAMILY: Tahoma; COLOR: #ffffff; FONT-WEIGHT: bold">Units per type</TD><TD style="FONT-FAMILY: Tahoma">Code</TD><TD style="FONT-FAMILY: Tahoma">Sum</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0001</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">1</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z000121004041</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0002</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">1</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z000221004041</TD><TD style="FONT-FAMILY: Tahoma"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0004</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">1</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z000421004041</TD><TD style="FONT-FAMILY: Tahoma"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0005</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">1</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z000521004041</TD><TD style="FONT-FAMILY: Tahoma"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">1</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001121004041</TD><TD style="FONT-FAMILY: Tahoma"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0013</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">1</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001321004041</TD><TD style="FONT-FAMILY: Tahoma"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0034</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">1</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z003421004041</TD><TD style="FONT-FAMILY: Tahoma"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0004</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z000421004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0005</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z000521004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001121004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0013</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001321004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0014</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001421004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0015</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001521004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0017</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001721004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0019</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">2</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z001921004042</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0001</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">FR</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00012100404FR</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0002</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">FR</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00022100404FR</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0004</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">FR</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00042100404FR</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0005</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">FR</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00052100404FR</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">FR</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00112100404FR</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0013</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">FR</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00132100404FR</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0001</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">D</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00012100404D</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0002</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">D</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00022100404D</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0004</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">D</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00042100404D</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0005</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">D</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00052100404D</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">D</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00112100404D</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0013</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">D</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00132100404D</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">15/06/2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Tahoma">21/06/2011</TD><TD style="FONT-FAMILY: Tahoma">Z0014</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">2100404</TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Beagle Mug w/st</TD><TD style="FONT-FAMILY: Tahoma">D</TD><TD style="FONT-FAMILY: Tahoma"></TD><TD style="FONT-FAMILY: Microsoft Sans Serif; FONT-SIZE: 8.25pt">Z00142100404D</TD><TD></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>K2</TD><TD>=D2&G2&I2</TD></TR><TR><TD>K3</TD><TD>=D3&G3&I3</TD></TR><TR><TD>K4</TD><TD>=D4&G4&I4</TD></TR><TR><TD>K5</TD><TD>=D5&G5&I5</TD></TR><TR><TD>K6</TD><TD>=D6&G6&I6</TD></TR><TR><TD>K7</TD><TD>=D7&G7&I7</TD></TR><TR><TD>K8</TD><TD>=D8&G8&I8</TD></TR><TR><TD>K9</TD><TD>=D9&G9&I9</TD></TR><TR><TD>K10</TD><TD>=D10&G10&I10</TD></TR><TR><TD>K11</TD><TD>=D11&G11&I11</TD></TR><TR><TD>K12</TD><TD>=D12&G12&I12</TD></TR><TR><TD>K13</TD><TD>=D13&G13&I13</TD></TR><TR><TD>K14</TD><TD>=D14&G14&I14</TD></TR><TR><TD>K15</TD><TD>=D15&G15&I15</TD></TR><TR><TD>K16</TD><TD>=D16&G16&I16</TD></TR><TR><TD>K17</TD><TD>=D17&G17&I17</TD></TR><TR><TD>K18</TD><TD>=D18&G18&I18</TD></TR><TR><TD>K19</TD><TD>=D19&G19&I19</TD></TR><TR><TD>K20</TD><TD>=D20&G20&I20</TD></TR><TR><TD>K21</TD><TD>=D21&G21&I21</TD></TR><TR><TD>K22</TD><TD>=D22&G22&I22</TD></TR><TR><TD>K23</TD><TD>=D23&G23&I23</TD></TR><TR><TD>K24</TD><TD>=D24&G24&I24</TD></TR><TR><TD>K25</TD><TD>=D25&G25&I25</TD></TR><TR><TD>K26</TD><TD>=D26&G26&I26</TD></TR><TR><TD>K27</TD><TD>=D27&G27&I27</TD></TR><TR><TD>K28</TD><TD>=D28&G28&I28</TD></TR><TR><TD>K29</TD><TD>=D29&G29&I29</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
