Creating macros using VBA code

NGNG · Aug 9, 2011

Hi,

I need some help with creating a macro using VBA code. Basically I have a spreadsheet that has transactional data and I would like to aggregate it by date and have one row per each date. What I have is below:

Sales Rep ID, Date Entered, Occurence, Total Revenue
32113, 7/1/2011, 1, $1.00
32113, 7/1/2011, 1, $20.00
32113, 7/1/2011, 2, $5.00
32113, 7/1/2011, 2, $0.00
32113, 6/28/2011, 2, $8.00
32113, 6/28/2011, 2, $0.00

AND the result I need to get to with the VBA code is below:

Sales Rep ID, Date Entered, Occurence , Total Revenue
32113, 7/1/2011, 6, $26.00
32113, 6/28/2011, 4, $8.00

Thank You
NG

NGNG · Aug 12, 2011

Hi - Sorry to bother you a third time but this just keeps getting more complicated. The raw data that I need to begin with is now:

<TABLE style="WIDTH: 1750pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=2331><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4169" width=114><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 132pt; mso-width-source: userset; mso-width-alt: 6436" width=176><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" span=2 width=109><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962" width=81><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3657" width=100><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl72 height=16 width=90>Rep Name</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 67pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=89>Sales Rep ID</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 42pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=56>Site ID</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 86pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=114>Account Number</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 77pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=103>Work Order No</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 87pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=116>Work Order Type</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 132pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=176>Customer Name</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 74pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=99>Dwelling Type</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 69pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=92>Date Entered</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 82pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=109>Processed Date</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 82pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=109>Campaign Code</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 71pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=95>Service Code</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 74pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=99>From Quantity</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=84>To Quantity</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 71pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=95>Transfer Flag</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=71>Spin Flag</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 71pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=95>Past Due Flag</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 88pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=117>Write Off Amount</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 79pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=105>Reconnect Flag</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 61pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=81>Occurence</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 80pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=106>Install Revenue</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 35pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=46>MRR</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 75pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl73 width=100>Total Revenue</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #cfe0f1; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #dddddd 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl74 width=84>Comments</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Doe, John</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>54321</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>570000008</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6629130</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>IN</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>BURGESS INSURANCE INC</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>6/28/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>7/1/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>IC121</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>Y</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$1.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Doe, John</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>54321</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>570000008</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6629130</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>DW</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>BURGESS INSURANCE INC</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>6/28/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>7/1/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>ED201</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>Y</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>2</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$2.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Doe, John</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>54321</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>100000999</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6629130</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>UP</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>BURGESS INSURANCE INC</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>6/28/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>7/1/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>XJ001</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>Y</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>2</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Doe, John</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>54321</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>560000007</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6667607</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>DW</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>BARRETTS FLOOR COVERING CO</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>7/1/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>7/1/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>EZ007</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$7.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Smith, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>12345</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>594800001</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6076036</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>DI</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>SPECTRUM PROPERTIES</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>5/11/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>6/25/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>YA193</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$23.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Smith, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>12345</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>200300002</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6564651</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>UP</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>DOLLAR CENTER PLUS</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>6/23/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>6/23/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>IR034</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>2</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$24.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Smith, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>12345</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>460000004</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6539516</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>IN</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>CAMP CAREFREE</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>6/21/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>6/21/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>EN201</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$26.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Smith, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 67pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=89>12345</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 42pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 86pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=114>460000004</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=103>6539516</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 87pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=116>DW</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 132pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=176>CAMP CAREFREE</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 69pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=92>6/21/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl68 width=109>6/21/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 82pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>XJ001</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 74pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=99>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=84>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 53pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 71pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 88pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 79pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 61pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl66 width=81>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 80pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f7f7f7; WIDTH: 75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #cccccc 1pt solid" dir=ltr class=xl69 width=100>$30.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #dddddd 0.5pt solid; WIDTH: 68pt; FONT-FAMILY: Arial; BACKGROUND: white; HEIGHT: 12pt; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl70 height=16 width=90>Smith, Mary</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 67pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl66 width=89>12345</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 42pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl66 width=56>202</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 86pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl66 width=114>124600000</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 77pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl66 width=103>6159410</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 87pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=116>DI</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 132pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=176>HEELS.COM</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 74pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=99>B</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 69pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl68 width=92>5/19/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 82pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl68 width=109>6/20/2011</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 82pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=109> </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 71pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=95>EZ007</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 74pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl66 width=99>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl66 width=84>0</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 71pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 53pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=71>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 71pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=95>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 88pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl69 width=117>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 79pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl67 width=105>N</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 61pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl66 width=81>1</TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 80pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl69 width=106>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 35pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl69 width=46>$0.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 75pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #cccccc 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl69 width=100>$31.00 </TD><TD style="BORDER-BOTTOM: #cccccc 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; FONT-FAMILY: Arial; BACKGROUND: #f7f7f7; COLOR: black; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #dddddd 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" dir=ltr class=xl71 width=84> </TD></TR></TBODY></TABLE>

But the requirements stay the same from what I sent yesterday. So basically we are only using 5 columns above to get the result set on a different sheet. The result set will only contain 3 columns as mentioned before. I am using Excel 2007. Any idea how I can derive the same result set with this above spreadsheet?

hiker95 · Aug 12, 2011

NGNG,

What is the worksheet name for your raw data?

What is the name of the new worksheet to hold your results?

Can we have a screenshot of what the resulting worksheet should look like (manually formatted by you).

NGNG · Aug 14, 2011

Raw data worksheet is called 'Closed WO Report'
The result set worksheet is called 'OMR WO Report'
Raw Data is:

<TABLE style="WIDTH: 1887pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=2512><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4644" width=127><COL style="WIDTH: 154pt; mso-width-source: userset; mso-width-alt: 7497" width=205><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4022" width=110><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3803" width=104><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 65pt; FONT-FAMILY: Calibri; BACKGROUND: black; HEIGHT: 15pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=20 width=86>Rep Name
</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 73pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=97>Sales Rep ID</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 77pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=103>Site ID</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 96pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=128>Account Number</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 86pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=115>Work Order No</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 95pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=127>Work Order Type</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 154pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=205>Customer Name</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 83pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=110>Dwelling Type</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 77pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=103>Date Entered</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 88pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=117>Processed Date</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 89pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=118>Campaign Code</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 77pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=102>Service Code</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 83pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=111>From Quantity</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 71pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=94>To Quantity</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 76pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=101>Transfer Flag</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 58pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=77>Spin Flag</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 78pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=104>Past Due Flag</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 100pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=133>Write Off Amount</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 86pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=115>Reconnect Flag</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 65pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=87>Occurence</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 89pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=118>Install Revenue</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 38pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=50>MRR</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 83pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=111>Total Revenue</TD></TR><TR style="HEIGHT: 15pt" title="Post 2825668" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" height=20>Doe, John</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>570000008</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>6629130</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">IN</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">BURGESS INSURANCE INC</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>6/28/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">IC121</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">Y</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: #D8D8D8 none" class=xl67 align=right>$1.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" height=20>Doe, John</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>570000008</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>6629130</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">UP</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">BURGESS INSURANCE INC</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>6/28/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">ED201</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">Y</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$2.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" height=20>Doe, John</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>100000999</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>6629130</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">UP</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">BURGESS INSURANCE INC</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>6/29/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">XJ001</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">Y</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" height=20>Doe, John</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>560000007</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>6667607</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">UP</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">BARRETTS FLOOR COVERING CO</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">EZ007</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$7.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" height=20>Smith, Mary</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>594800001</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>6076036</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">DI</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">SPECTRUM PROPERTIES</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>5/11/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>6/25/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">YA193</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: #D8D8D8 none" class=xl67 align=right>$23.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" height=20>Smith, Mary</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>200300002</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>6564651</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">UP</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">DOLLAR CENTER PLUS</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>6/23/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>6/23/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">IR034</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$24.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" height=20>Smith, Mary</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>460000004</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>6539516</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">IN</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">CAMP CAREFREE</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>6/21/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>6/21/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">EN201</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: #D8D8D8 none" class=xl67 align=right>$26.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" height=20>Smith, Mary</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>280000008</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>6539516</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">IN</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">CAMP CAREFREE</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>6/21/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" class=xl66 align=right>6/21/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">XJ001</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: auto; mso-background-source: auto" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: auto; mso-background-source: auto" class=xl67 align=right>$30.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" height=20>Smith, Mary</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>202</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>124600000</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>6159410</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">DI</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">HEELS.COM</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>5/19/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl66 align=right>6/20/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none"></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">EZ007</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>0</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none">N</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-pattern: #D8D8D8 none" class=xl67 align=right>$0.00 </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 0.5pt solid; mso-pattern: #D8D8D8 none" class=xl67 align=right>$31.00 </TD></TR></TBODY></TABLE>

Results should be:

<TABLE style="WIDTH: 246pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=328><COLGROUP><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 73pt; FONT-FAMILY: Calibri; BACKGROUND: black; HEIGHT: 15pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=20 width=97>Sales Rep ID</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 77pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=103>Date Entered</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 96pt; FONT-FAMILY: Calibri; BACKGROUND: black; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: black 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=128>Number of Errors</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" height=20 align=right>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl63 align=right>6/28/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=20 align=right>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl63 align=right>7/1/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" height=20 align=right>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" class=xl63 align=right>6/23/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; FONT-FAMILY: Calibri; BACKGROUND: #d8d8d8; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #D8D8D8 none" align=right>1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=20 align=right>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl63 align=right>6/21/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: black 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>2</TD></TR></TBODY></TABLE>

hiker95 · Aug 14, 2011

NGNG,

Sample raw data on worksheet Closed WO Report (not all columns shown for brevity):

Excel Workbook

B

F

I

W

1

Sales Rep ID

Work Order Type

Date Entered

Total Revenue

2

54321

IN

6/28/2011

$1.00

3

54321

UP

6/28/2011

$2.00

4

54321

UP

6/29/2011

$0.00

5

54321

UP

7/1/2011

$7.00

6

12345

DI

5/11/2011

$23.00

7

12345

UP

6/23/2011

$24.00

8

12345

IN

6/21/2011

$26.00

9

12345

IN

6/21/2011

$30.00

10

12345

DI

5/19/2011

$31.00

11

Closed WO Report

After the macro on worksheet OMR WO Report:

Excel Workbook

A

B

C

1

Sales Rep ID

Date Entered

Number of Errors

2

54321

6/28/2011

2

3

54321

6/29/2011

0

4

54321

7/1/2011

1

5

12345

5/11/2011

0

6

12345

6/23/2011

1

7

12345

6/21/2011

2

8

12345

5/19/2011

0

9

OMR WO Report

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Code:

Option Explicit
Sub ReorgDataV3()
' hiker95, 08/14/2011
' http://www.mrexcel.com/forum/showthread.php?t=570494
Dim w1 As Worksheet, wR As Worksheet
Dim LR As Long, a As Long, LR2 As Long
Application.ScreenUpdating = False
Set w1 = Worksheets("Closed WO Report")
If Not Evaluate("ISREF('OMR WO Report'!A1)") Then Worksheets.Add(After:=w1).Name = "OMR WO Report"
Set wR = Worksheets("OMR WO Report")
wR.UsedRange.Clear
LR = w1.Cells(Rows.Count, 1).End(xlUp).Row
w1.Range("B1:B" & LR).Copy wR.Range("A1")
w1.Range("I1:I" & LR).Copy wR.Range("B1")
wR.Columns("A:B").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=wR.Columns("C:D"), Unique:=True
wR.Columns("A:B").Delete
With wR.Range("A1:C1")
  .Value = [{"Sales Rep ID","Date Entered","Number of Errors"}]
  .Interior.ColorIndex = xlNone
  .Font.ColorIndex = 1
  .Font.Bold = True
End With
LR2 = wR.Cells(Rows.Count, 1).End(xlUp).Row
wR.Range("A1:C" & LR2).Interior.ColorIndex = xlNone
With wR.Range("C2:C" & LR2)
 .FormulaR1C1 = "=SUMPRODUCT(('Closed WO Report'!R2C2:R" & LR & "C2=RC1)*('Closed WO Report'!R2C9:R" & LR & "C9=RC2)*('Closed WO Report'!R2C6:R10C6={""IN"",""UP""})*('Closed WO Report'!R2C23:R" & LR & "C23>0))"
  .Value = .Value
End With
wR.Range("A1:C" & LR2).Columns.AutoFit
wR.Activate
Application.ScreenUpdating = True
End Sub

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgDataV3 macro.

NGNG · Aug 18, 2011

Thank you so much! This worked perfectly, saves me a lot of manual work. Now all I will have to do manually every week is to change the range since the raw data will have different number of rows each week.

NGNG · Aug 18, 2011

Actually one thing didnt work out, I want for per SalesID per date for the Account Number to be counted only once, so if the same account number has multiple rows for the same day for same SalesID then that should only be counted once for number of errors. Any idea how that can be done?

hiker95 · Aug 18, 2011

NGNG,

Thank you so much! This worked perfectly, saves me a lot of manual work.

You are very welcome.

Glad I could help.

Thanks for the feedback.

For my own personal information: How much time in hours do you think my macro will save you per day/week/month?

Now all I will have to do manually every week is to change the range since the raw data will have different number of rows each week.

You should not have to change anything in the macro. It will always find the last row of data in worksheet Closed WO Report in column A.

hiker95 · Aug 18, 2011

NGNG,

Actually one thing didnt work out, I want for per SalesID per date for the Account Number to be counted only once, so if the same account number has multiple rows for the same day for same SalesID then that should only be counted once for number of errors. Any idea how that can be done?

Working with your raw data in worksheet Closed WO Report (Reply #13), I will need to see a screenshot of what the results for worksheet OMR WO Report would be.

NGNG · Aug 18, 2011

Actually the same account number is being counted multiple times. How do we code it so only unique account numbers are counted from the previous result set. So unique account numbers to be counted per SalesID per day for revenue > 0?

This will save me around 2 hours each day of manual work.

NGNG · Aug 18, 2011

The result from Raw Data in Reply#13 should come out to be (see below) and this is based on the filters you have already used in the vb code, the only thing its missing is that for each date per SalesRepID, it should count only unique account numbers. Let me know if this makes sense?

<TABLE style="WIDTH: 251pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=334><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4790" width=131><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: black; WIDTH: 62pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl71 height=20 width=82>Sales Rep ID
</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: black; WIDTH: 91pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl72 width=121>Date Entered</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: black; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl73 width=131>Number of Errors</TD></TR><TR style="HEIGHT: 15pt" title="Post 2827789" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #d8d8d8; WIDTH: 62pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=20 width=82>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; WIDTH: 91pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl74 width=121>6/28/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl66 width=131>1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef; WIDTH: 62pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl67 height=20 width=82>54321</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #efefef; WIDTH: 91pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl75 width=121>7/1/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #efefef; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl68 width=131>1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #d8d8d8; WIDTH: 62pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=20 width=82>12345</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; WIDTH: 91pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl74 width=121>6/23/2011</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl66 width=131>1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: #efefef; WIDTH: 62pt; HEIGHT: 15.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl69 height=21 width=82>12345</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #efefef; WIDTH: 91pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl76 width=121>6/21/2011</TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #efefef; WIDTH: 98pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3867a6 1pt solid" class=xl70 width=131>2
</TD></TR></TBODY></TABLE>

Creating macros using VBA code

NGNG

New Member

NGNG

New Member

Excel Facts

hiker95

Well-known Member

NGNG

New Member

hiker95

Well-known Member

NGNG

New Member

NGNG

New Member

hiker95

Well-known Member

hiker95

Well-known Member

NGNG

New Member

NGNG

New Member

Similar threads

Forum statistics

Share this page

Creating macros using VBA code

New Member

New Member

Excel Facts

Well-known Member

New Member

Well-known Member

New Member

New Member

Well-known Member

Well-known Member

New Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock