Find start and end date and divide results

lebahye · Nov 4, 2011

Hello All

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5CGTAVIT%7E1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CGTAVIT%7E1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CGTAVIT%7E1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style> I have a unique request. The table below list date /time and data. I need help with a VB script to find start and end of each day (column 1) and subtract data (column 2).

For example:<o

></o

>
<o

> </o

>10/19/2011 =678223000<o></o>
10/18/2011 =675619800<o></o>
Result = 2603200<o

></o

>
<o

> </o

>
Hope you can help. This is what I have so far. It only subtract at 23:45 and the previous date. <o

></o

>
<o

> </o

>
Sub KWh()<o

></o

>
<o

> </o

>
rowCnt = ThisWorkbook.Worksheets(4).UsedRange.Rows.Count<o

></o

>
colCnt = ThisWorkbook.Worksheets(4).UsedRange.Columns.Count<o

></o

>
<o

> </o

>
Dim prev As Date<o

></o

>
Dim curr As Date<o

></o

>
<o

> </o

>
For cnt = 2 To rowCnt<o

></o

>
<o

> </o

>
prev = curr<o

></o

>
curr = ThisWorkbook.Worksheets(4).Cells(cnt, 1).Value<o

></o

>
<o

></o

>
prev = Format(prev, "dd")<o

></o

>
curr = Format(curr, "dd")<o

></o

>
<o

></o

>
If (DateDiff("d", prev, curr) = 0) Then<o

></o

>
ThisWorkbook.Worksheets(4).Cells(cnt, 3).Value = DateDiff("d", prev, curr)<o

></o

>
<o

></o

>
ThisWorkbook.Worksheets(4).Cells(cnt, 4).Value = ThisWorkbook.Worksheets(4).Cells(cnt - 1, 2).Value - ThisWorkbook.Worksheets(4).Cells(cnt, 2).Value<o

></o

>
<o

> </o

>
End If<o

></o

>
<o

></o

>
Next cnt<o

></o

>
<o

> </o

>
End Sub<o

></o

>
<o

> </o

>
<o

> </o

>
<o

> Sample data to use
</o

>
<o

> </o

>
<table class="MsoNormalTable" style="width: 274pt; margin-left: -0.6pt; border-collapse: collapse;" width="365" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/19/2011<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678223000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 23:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678197800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 23:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678171600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 23:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678144300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 23:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678117900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 22:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678091400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 22:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678062900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 22:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678036600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 22:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

678010500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 21:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677982400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 21:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677953800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 21:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677926500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 21:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677897700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 20:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677868200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 20:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677839300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 20:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677809300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 20:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677779200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 19:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677751400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 19:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677721200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 19:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677691300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 19:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677661500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 18:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677631700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 18:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677599200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 18:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677569100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 18:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677538600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 17:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677507800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 17:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677477900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 17:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677446500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 17:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677413600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 16:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677383100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 16:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677350100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 16:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677316900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 16:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677284500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 15:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677253100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 15:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677219200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 15:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677186500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 15:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677153000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 14:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677119000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 14:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677086500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 14:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677055300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 14:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

677023700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 13:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676992400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 13:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676961400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 13:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676929200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 13:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676896700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 12:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676864200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 12:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676833400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 12:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676799600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 12:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676768900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 11:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676737200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 11:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676703300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 11:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676671100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 11:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676639800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 10:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676610900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 10:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676585600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 10:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676560600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 10:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676536400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 9:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676511100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 9:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676486000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 9:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676461000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 9:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676437100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 8:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676413400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 8:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676388900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 8:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676365000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 8:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676341400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 7:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676318700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 7:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676295000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 7:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676271500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 7:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676248100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 6:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676225600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 6:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676202800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 6:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676179100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 6:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676155600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 5:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676133000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 5:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676110900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 5:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676087700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 5:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676064800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 4:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676041700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 4:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

676019800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 4:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675997200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 4:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675974600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 3:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675952100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 3:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675929900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 3:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675908500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 3:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675886000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 2:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675863400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 2:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675840800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 2:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675819400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 2:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675797600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 1:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675775100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 1:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675752600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 1:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675730700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 1:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675709100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 0:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675686600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 0:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675664300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011 0:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675641800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/18/2011<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675619800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 23:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675598000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 23:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675575400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 23:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675552700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 23:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675529900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 22:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675507300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 22:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675485200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 22:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675462500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 22:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675439900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 21:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675417100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 21:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675392300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 21:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675365900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 21:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675338500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 20:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675309300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 20:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675280600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 20:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675252200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 20:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675223800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 19:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675194100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 19:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675163800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 19:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675133100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 19:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675104500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 18:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675076800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 18:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675048900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 18:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

675021600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 18:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674990800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 17:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674958700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 17:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674925700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 17:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674892500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 17:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674859800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 16:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674827300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 16:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674797500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 16:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674763400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 16:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674729900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 15:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674697500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 15:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674663500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 15:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674629000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 15:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674595600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 14:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674562800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 14:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674527600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 14:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674493100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 14:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674460300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 13:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674426600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 13:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674390500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 13:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674354900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 13:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674319200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 12:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674283700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 12:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674248300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 12:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674212600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 12:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674179300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 11:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674146400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 11:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674117600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 11:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674088600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 11:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674060600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 10:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674034100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 10:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

674006700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 10:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673979800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 10:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673952600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 9:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673926500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 9:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673900500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 9:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673874600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 9:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673850100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 8:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673827100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 8:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673805500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 8:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673782800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 8:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673759900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 7:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673736600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 7:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673714100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 7:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673691900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 7:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673669000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 6:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673646200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 6:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673623500<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 6:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673601800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 6:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673579200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 5:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673556100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 5:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673526900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 5:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673501900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 5:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673478000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 4:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673452400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 4:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673422700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 4:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673399600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 4:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673374000<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 3:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673345400<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 3:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673322700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 3:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673294800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 3:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673269700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 2:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673244600<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 2:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673218800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 2:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673191700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 2:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673166900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 1:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673140700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 1:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673115800<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 1:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673089900<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 1:00<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673063700<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 0:45<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673037300<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 0:30<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

673010200<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011 0:15<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

672985100<o

></o

>

</td> </tr> <tr style="height: 15pt;"> <td style="width: 95pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="127" nowrap="nowrap">

10/17/2011<o

></o

>

</td> <td style="width: 179pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="239" nowrap="nowrap">

672959400<o

></o

>

</td> </tr> </tbody></table>

b.downey · Nov 5, 2011

Based on your example, it appears that you are looking to calulated the difference from Midnight each day. If this this is the case, the follow code should work.

Code:

Option Explicit
Sub KWh()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1")
    
    Dim Cnt As Long
    Dim PrevReading As Long
    For Cnt = 2 To ws.UsedRange.Rows.Count
        If Format(CDate(ws.Cells(Cnt, 1)), "HH:MM:SS") = "00:00:00" Then
            ws.Cells(Cnt, 4) = PrevReading - ws.Cells(Cnt, 2)
            PrevReading = ws.Cells(Cnt, 2)
        End If
    Next Cnt
End Sub

lebahye · Nov 7, 2011

b.downey - Thank you for your quick response. I entered the code as written and returned "run time error 13" - type mismatch. on the following line:

Option Explicit
Sub KWh()
Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets("Sheet1")

Dim Cnt As Long
Dim PrevReading As Long
For Cnt = 2 To ws.UsedRange.Rows.Count
If Format(CDate(ws.Cells(Cnt, 1)), "HH:MM:SS") = "00:00:00" Then
ws.Cells(Cnt, 4) = PrevReading - ws.Cells(Cnt, 2)
PrevReading = ws.Cells(Cnt, 2)
End If
Next Cnt
End Sub

b.downey · Nov 7, 2011

What version of Excel are you using?

The issue may be that the vaule in the cell is not covertable to a date. If that is the case, the following code will check the cell to determine if it can be converted to date prior to making the conversion.

This should elimanate the Run Time Error

Code:

Sub KWh()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Worksheets("Sheet1")
    
    Dim Cnt As Long
    Dim PrevReading As Long
    For Cnt = 2 To ws.UsedRange.Rows.Count
        If IsDate(CDate(ws.Cells(Cnt, 1))) Then
            If Format(CDate(ws.Cells(Cnt, 1)), "HH:MM:SS") = "00:00:00" Then
                ws.Cells(Cnt, 4) = PrevReading - ws.Cells(Cnt, 2)
                PrevReading = ws.Cells(Cnt, 2)
            End If
        End If
    Next Cnt
End Sub

lebahye · Nov 9, 2011

Thank you very much, GT

lebahye · Dec 8, 2011

Hello - Thank you for your previous help. Need help with formula (non VBA). I'm trying to automate a chart by specific date range and ignoring other dates. i've tried pivot point and find it more work than needed.

I'm looking to filter the date range of the data listed above. for example; I would like to find only data that include 9th through the 8th of every month and graph it. I was thinking of scanning and adding "A" to the included date range and "B" to excluded. maybe pivot point may work.

Find start and end date and divide results

lebahye

New Member

Excel Facts

b.downey

Active Member

lebahye

New Member

b.downey

Active Member

lebahye

New Member

lebahye

New Member

Similar threads

Forum statistics

Share this page

Find start and end date and divide results

lebahye

New Member

Excel Facts

b.downey

Active Member

lebahye

New Member

b.downey

Active Member

lebahye

New Member

lebahye

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock