I trying to convert the following formula (I, II, III) and add criteria of Name and Date to the count values of “c”
CURRENT FORMULA
I: “=COUNTIF(C2:C3100,"<=6")” versley (B) and today to last 7 days (A)
II: “=COUNTA(C2:C3100)” versley (B) and today to last 7 days (A)
III: “=AVERAGE(C2:C3100)” versley (B) and today to last 7 days (A)
Additional criteria
Date (A ): (A2:A3100<=TODAY())*(CA:A3100>=TODAY()-7))
Name (B): B2:B3100="vensley"
Count (C): Less than conditions
Sorry if I was not clear enough and appreciate any help
Thank you,
Wm…
<TABLE style="WIDTH: 261pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=346 border=0 x:str><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5046" width=138><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><TBODY><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: #003366" width=102 height=27>Date Received</TD><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: #003366" width=138>Team</TD><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: #003366" width=106>Grade</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Susan</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40200">22-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>William</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Mike</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40220">11-Feb-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Mike</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>7</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40184">6-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>0</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40185">7-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>6</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>3</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>8</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40198">20-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40203">25-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR></TBODY></TABLE>
CURRENT FORMULA
I: “=COUNTIF(C2:C3100,"<=6")” versley (B) and today to last 7 days (A)
II: “=COUNTA(C2:C3100)” versley (B) and today to last 7 days (A)
III: “=AVERAGE(C2:C3100)” versley (B) and today to last 7 days (A)
Additional criteria
Date (A ): (A2:A3100<=TODAY())*(CA:A3100>=TODAY()-7))
Name (B): B2:B3100="vensley"
Count (C): Less than conditions
Sorry if I was not clear enough and appreciate any help
Thank you,
Wm…
<TABLE style="WIDTH: 261pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=346 border=0 x:str><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5046" width=138><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><TBODY><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: #003366" width=102 height=27>Date Received</TD><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: #003366" width=138>Team</TD><TD class=xl24 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc 0.5pt solid; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: #003366" width=106>Grade</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Susan</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40200">22-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>William</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Mike</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40220">11-Feb-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>Mike</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>7</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40184">6-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>0</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40185">7-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>6</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>3</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40193">15-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>vensley</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>8</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40198">20-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40203">25-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>9</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR><TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27><TD class=xl25 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc 0.5pt solid; WIDTH: 77pt; BORDER-BOTTOM: #0066cc 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: white" width=102 height=27 x:num="40205">27-Jan-10</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 104pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=138>FGreene</TD><TD class=xl26 style="BORDER-RIGHT: #0066cc 0.5pt solid; BORDER-TOP: #0066cc; BORDER-LEFT: #0066cc; WIDTH: 80pt; BORDER-BOTTOM: #0066cc 0.5pt solid; BACKGROUND-COLOR: white" width=106 x:num>10</TD></TR></TBODY></TABLE>