Finding data in one sheet to populate data in another sheet based on month

Y

Yanta

Board Regular
Joined
Aug 28, 2011
Messages
59
Hi all,

I am still working on my electricity monitoring project. One more question

Consider this table in sheet "A"..

<TABLE style="WIDTH: 771pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1020><COLGROUP><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" span=12 width=82><TBODY><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 27pt; HEIGHT: 18.95pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl66 height=25 width=36></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl86 width=82 align=right>January</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>February</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>March</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>April</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>May</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>June</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>July</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>August</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>September</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>October</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 width=82 align=right>November</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 62pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl68 width=82 align=right>December</TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69 height=25 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl73></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl74></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl75 align=right>417</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl76 align=right>1285</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl76 align=right>2236</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl76 align=right>3165</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl76 align=right>4040</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl76 align=right>4925</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl74 align=right>5709</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl74></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl74></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl77></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>441</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1313</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2268</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3196</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4063</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4953</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>5730</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>469</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1347</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2302</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3220</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4091</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4979</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>5749</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>496</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1391</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2330</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3251</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4123</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4999</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>5771</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>526</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1423</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2359</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3277</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4161</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5026</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>550</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1455</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2388</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3297</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4194</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5048</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>581</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1486</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2411</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3332</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4228</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5074</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>611</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1518</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2441</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3361</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4260</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5093</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>639</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1549</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2469</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3392</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4291</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5121</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>669</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1579</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2497</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3425</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4314</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5149</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>692</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1621</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2525</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3457</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4346</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5173</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>721</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1657</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2559</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3481</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4379</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5197</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>13</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>748</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1691</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2588</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3510</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4407</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5224</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>14</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>773</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1719</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2620</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3545</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4434</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5247</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>798</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1755</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2654</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3575</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4473</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5271</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>826</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1781</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2684</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3602</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4500</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5294</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>854</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1808</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2720</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3630</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4533</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5325</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>18</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>291</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>881</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1842</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2752</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3660</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4565</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5348</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>19</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>295</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>912</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1873</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2783</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3687</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4593</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5376</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>301</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>944</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1900</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2812</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3719</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4623</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5401</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>306</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>968</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1932</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2841</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3751</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4650</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5423</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>22</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>312</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>994</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1959</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2868</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3785</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4679</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5452</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>319</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1019</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1990</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2898</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3814</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4706</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5476</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>24</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>330</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1046</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2019</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2927</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3847</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4736</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5499</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>341</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1072</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2052</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2956</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3876</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4764</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5524</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>26</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>356</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1107</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2082</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2986</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3905</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4784</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5551</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>27</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>373</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1140</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2115</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3019</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3928</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4811</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5579</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>28</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79 align=right>395</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1170</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2146</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3044</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3953</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4830</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5604</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>29</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1195</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2176</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3073</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3980</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4854</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5631</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70 height=25 align=right>30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a6a6a6; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl81></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>1223</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>2201</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>3105</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>4875</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 align=right>5658</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #0070c0; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl71 height=25 align=right>31</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl82></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a6a6a6; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl83></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl84 align=right>1256</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a6a6a6; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl83></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl84 align=right>3133</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a6a6a6; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl83></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl84 align=right>4904</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl84 align=right>5682</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a6a6a6; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl83></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl84></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a6a6a6; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl83></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD></TR></TBODY></TABLE>

In another sheet the user selects a month from a dropdown list. The format of this list is the full month name, Eg. September.

I want to grab the column of values from the table above and place these into a table in another sheet, lets call it "B"...

<TABLE style="WIDTH: 231pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=307><COLGROUP><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2413" width=66><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 26pt; HEIGHT: 18.95pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl66 height=25 width=35></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 59pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl74 width=78>Date</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl75 width=64>Meter</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 50pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl75 width=66>$/Day</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #0070c0; WIDTH: 48pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl76 width=64>KwH Used</TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl72 height=25 align=right>Thu</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl73 align=right>1/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl67 align=right>5709</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl78 align=right>6.34</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl79 align=right>27</TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Fri</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>2/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5730</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl77 align=right>4.93</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80 align=right>21</TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Sat</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>3/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5749</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl77 align=right>4.46</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80 align=right>19</TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Sun</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>4/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5771</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl77 align=right>5.17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80 align=right>22</TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Mon</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>5/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5793</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl77 align=right>5.17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl80 align=right>22</TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Tue</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>6/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5048</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl65></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Wed</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>7/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5074</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl65></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Thu</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>8/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5093</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl65></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Fri</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>9/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5121</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl65></TD></TR><TR style="HEIGHT: 18.95pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl70 height=25 align=right>Sat</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl71 align=right>10/09/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68 align=right>5149</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt dotted" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl65></TD></TR></TBODY></TABLE>

The cost per day and KWh are calculated, except for the first resulting row. The KWh there is the current reading less the last reading for the previous month. So in this example, 5709-5682=27.

I need to account for the correct number of days in the month and account for leap years.

So, how do I find the correct column to collect values from, and the correct column/row for the last reading of the previous month?

Also, how do I generate the correct date in the second column of the resulting table? I could grab the day column from table in sheet A, concatenate the month and then the current year, but that returns a text value that I cannot simply add 1 to for the next day???

Is this a huge task I'm asking for help on? If so, my apologies.
thanks
Tanya
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
Try this:-
The results start "C2" on sheet "B".
NB :- Data Sheet Named "Data", Results sheet named "B"
NB:- Place Validation List in "B1" of sheet "B" with Full Names of Months i.e :-January, February etc
Select Month from "B2" and run Code.
Code: 
[COLOR=navy]Sub[/COLOR] MG05Sep27
[COLOR=navy]Dim[/COLOR] Rng [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] Dn [COLOR=navy]As[/COLOR] Range
[COLOR=navy]Dim[/COLOR] Temp [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] Rws  [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]Dim[/COLOR] LstVal
[COLOR=navy]Dim[/COLOR] Ac [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
[COLOR=navy]For[/COLOR] Ac = 2 To 13
 With Sheets("Data") '[COLOR=green][B]Change sheet name to Actual Data Sheet Name[/B][/COLOR]
    [COLOR=navy]If[/COLOR] .Cells(1, Ac).Value = Range("B1").Value [COLOR=navy]Then[/COLOR]
        [COLOR=navy]Set[/COLOR] Rng = .Range(.Cells(2, Ac), .Cells(Rows.Count, Ac).End(xlUp))
        LstVal = .Cells(Rows.Count, Rng.Column - 1).End(xlUp).Value
        Temp = Ac
        [COLOR=navy]Exit[/COLOR] For
    [COLOR=navy]End[/COLOR] If
[COLOR=navy]End[/COLOR] With
[COLOR=navy]Next[/COLOR] Ac
With Sheets("B") '[COLOR=green][B]Change sheet name to "Results sheet" Name[/B][/COLOR]
.Range("E2").Resize(Rng.Count).Value = Rng.Value
 [COLOR=navy]With[/COLOR] .Range("D2")
    .Value = "1/" & [b1] & "/2011"
    .AutoFill Destination:=Range("D2").Resize(Rng.Count), Type:=xlFillSeries
[COLOR=navy]End[/COLOR] With
[COLOR=navy]With[/COLOR] .Range("C2")
    .Value = WeekdayName(Weekday(.Offset(, 1)), True)
    .AutoFill Destination:=Range("C2").Resize(Rng.Count), Type:=xlFillSeries
[COLOR=navy]End[/COLOR] With
    LstVal = IIf(Not IsNumeric(LstVal), 0, LstVal)
    .Range("G2") = .Range("E2") - LstVal
        [COLOR=navy]With[/COLOR] .Range("G3").Resize(Rng.Count - 1)
            .FormulaR1C1 = "=RC[-2]-R[-1]C[-2]"
            .Value = .Value
        [COLOR=navy]End[/COLOR] With
[COLOR=navy]With[/COLOR] .Range("F2").Resize(Rng.Count)
    .FormulaR1C1 = "=RC[1]*0.234876"
    .Value = .Value
[COLOR=navy]End[/COLOR] With
[COLOR=navy]End[/COLOR] [COLOR=navy]With[/COLOR]
[COLOR=navy]End[/COLOR] [COLOR=navy]Sub[/COLOR]
Regards Mick
 
Last edited:
Upvote 0
Thanks Mick.
This is way over my head, but I will give it a try.

There are a couple of things I might have noticed in your code.
(1). The year is actually not fixed, as I want this project to be able to be used for many years, so the year is picked up from another sheet, but I could have just as easily used today() to get the year.
(2). The KWh rate of 0.234876 is also not constant. The electricity companies love to hike prices, so this is also stored in another sheet. I have set up a tariff, GST and concession values in a third sheet for each month of the year.

Sorry for not making this clear initially.

Tanya
 
Last edited:
Upvote 0
If you've managed to get anything from the other code, you could try this:-
The code works from the " Worksheet_Change" event so when you select a Month from "B1" the code runs.
Right click your sheet, Select "View Code", Past code in the VBWindow that appears.
This code now Uses cell "B2" for the Rate, you could relate this to you Rate_Sheet using a "Vlookup" function to return the Rate relating to the month in "B1".
Cell "B3" is now the year, you could also relate that in a similar way
Code: 
Private [COLOR="Navy"]Sub[/COLOR] Worksheet_Change(ByVal Target [COLOR="Navy"]As[/COLOR] Range)
[COLOR="Navy"]Dim[/COLOR] Rng [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Temp [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Rws  [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] LstVal
[COLOR="Navy"]Dim[/COLOR] Ac [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Rdn [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]If[/COLOR] Target.Address(0, 0) = "B1" [COLOR="Navy"]Then[/COLOR]
Sheets("B").Range("C2:G35").ClearContents
[COLOR="Navy"]For[/COLOR] Ac = 2 To 13
 With Sheets("Data") '[COLOR="Green"][B]Change sheet name to Actual Data Sheet Name[/B][/COLOR]
    [COLOR="Navy"]If[/COLOR] .Cells(1, Ac).Value = Range("B1").Value [COLOR="Navy"]Then[/COLOR]
   
        [COLOR="Navy"]If[/COLOR] .Cells(1, Ac).End(xlDown).Row = Rows.Count [COLOR="Navy"]Then[/COLOR]
            [COLOR="Navy"]Exit[/COLOR] [COLOR="Navy"]Sub[/COLOR]
        [COLOR="Navy"]Else[/COLOR]
            [COLOR="Navy"]If[/COLOR] .Cells(1, Ac).End(xlDown).Row = .Cells(Rows.Count, Ac).End(xlUp).Row [COLOR="Navy"]Then[/COLOR]
                Rdn = 2
            [COLOR="Navy"]Else[/COLOR]
                Rdn = .Cells(2, Ac).End(xlDown).Row
            [COLOR="Navy"]End[/COLOR] If
       [COLOR="Navy"]End[/COLOR] If
            [COLOR="Navy"]Set[/COLOR] Rng = .Range(.Cells(Rdn, Ac), .Cells(Rows.Count, Ac).End(xlUp))
            LstVal = .Cells(Rows.Count, Rng.Column - 1).End(xlUp).Value
            Temp = Ac
            [COLOR="Navy"]Exit[/COLOR] For
    [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]Next[/COLOR] Ac
With Sheets("B") '[COLOR="Green"][B]Change sheet name to "Results sheet" Name[/B][/COLOR]
[COLOR="Navy"]If[/COLOR] Not IsNumeric(Rng(1).Value) [COLOR="Navy"]Then[/COLOR] [COLOR="Navy"]Exit[/COLOR] [COLOR="Navy"]Sub[/COLOR]
    .Range("E2").Resize(Rng.Count).Value = Rng.Value
 
 [COLOR="Navy"]With[/COLOR] .Range("D2")
    .Value = Sheets("Data").Cells(Rdn, 1) & [b1] & [b3]
    .AutoFill Destination:=Range("D2").Resize(Rng.Count), Type:=xlFillSeries
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]With[/COLOR] .Range("C2")
    .Value = WeekdayName(Weekday(.Offset(, 1)), True)
    .AutoFill Destination:=Range("C2").Resize(Rng.Count), Type:=xlFillSeries
[COLOR="Navy"]End[/COLOR] With
    LstVal = IIf(Not IsNumeric(LstVal), 0, LstVal)
     .Range("G2") = IIf(LstVal = 0, 0, .Range("E2") - LstVal)
        
[COLOR="Navy"]With[/COLOR] .Range("G3").Resize(Rng.Count - 1)
    .FormulaR1C1 = "=RC[-2]-R[-1]C[-2]"
    .Value = .Value
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]With[/COLOR] .Range("F2").Resize(Rng.Count)
    .FormulaR1C1 = "=RC[1]*R2C2" '[COLOR="Green"][B]=* cell "B2"[/B][/COLOR]
    .Value = .Value
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]If[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Hi Mike I am desperate need of your help.

I have these codes. the intention is to copy a group of data from the set up page which is fixed then take it to the sheet based on the date in the set up page as the sheets are labelled with just the dates.

then on the sheet i wish to scroll through range B3 to B110 insearch for the line number. I defined the line number in the previous sheet as cell P6 which is what I am searching for the date sheet. once I find it I select and then paste my values.

I have used the .cell and it refuses to go through saying invalid reference,
I have tried the set find and it could work
can you be of help pls

Sub validate_line()

'transfer line to appropriate date and losses file
' Planning Macro
'

'
Application.ScreenUpdating = False 'speed up macro execution
Application.EnableEvents = False 'turn off other macros for now
Application.DisplayAlerts = False 'turn off system messages for now



On Error Resume Next

With Sheets("SET UP")

'DateID = Format(Range("B2"), "dd.mm.yy")
'LineID = Range("P6").Text

Range("P6").Select
LineID = ActiveCell.Text

Range("B2").Select
Datez = ActiveCell
'
'yearz
'
yearz = Right(Year(Datez), 2)

'
'Numéro de Mois
'
Mois = Month(Datez)
numMois = Mois
If numMois = 1 Then CarMois = "01"
If numMois = 2 Then CarMois = "02"
If numMois = 3 Then CarMois = "03"
If numMois = 4 Then CarMois = "04"
If numMois = 5 Then CarMois = "05"
If numMois = 6 Then CarMois = "06"
If numMois = 7 Then CarMois = "07"
If numMois = 8 Then CarMois = "08"
If numMois = 9 Then CarMois = "09"
If numMois = 10 Then CarMois = "10"
If numMois = 11 Then CarMois = "11"
If numMois = 12 Then CarMois = "12"
'
'Numéro de Semaine
'
numSem = DatePart("ww", Datez)
indexSem = numSem - 1
'
'Numéro du Jour
'
numJour = Day(Datez)
'
'Index du Jour
'
indexj = Weekday(Datez)
indexjour = indexj + 1

Range("C236:D246").Select
Selection.Copy

'

End With

Dim LijnFIND As Range
Dim i As Integer

On Error Resume Next

'Sheets(range("I2")).Select
Sheets("" & numJour & "." & CarMois & "." & yearz & "").Select



'Set LijnFIND = .Range("B3:B110").Find(what:=LineID, _
After:=.Range("B3"), _
LookIn:=xlValues, _
LookAt:=xlWhole)

For i = 3 To 110

If .Cells(i, 2) = LineID Then
Set LijnFIND = .Cells(i, 2)
i = 110
End If
Next i


If Not LijnFIND Is Nothing Then

LijnFIND.Offset(, 1).Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

Application.DisplayAlerts = True 'turn system alerts back on
Application.EnableEvents = True 'turn other macros back on
Application.ScreenUpdating = True 'refreshes the screen

End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
920
epactheactor
E
V
  • Question Question
Issue with scraping with VBA
Replies
1
Views
692
John_w
J

Forum statistics

Threads
1,224,522
Messages
6,179,297
Members
452,903
Latest member
Knuddeluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top