ncjefffl
New Member
- Joined
- May 5, 2010
- Messages
- 22
I am trying to eliminate some repetitive copy/pasting in a monthly worksheet. I have two columns. One contains a single occurence of a day name (Monday thru Sunday) with timeslots for each day (but also empty spaces and other info because it comes from a report pasted into the sheets). A sample is below, just of Monday and part of Tuesday, but it goes on down.<TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=512 border=0><COLGROUP><COL style="WIDTH: 359pt; mso-width-source: userset; mso-width-alt: 12262" width=479><COL style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 844" width=33><TBODY><TR style="HEIGHT: 4.5pt; mso-height-source: userset" height=6><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 4.5pt; BACKGROUND-COLOR: transparent" width=479 height=6></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: gray 2pt double; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=479 height=18>MONDAY</TD><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: gray 2pt double; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 5.25pt; mso-height-source: userset" height=7><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 5.25pt; BACKGROUND-COLOR: transparent" height=7></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Period Start</TD><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33>SCH</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=479 height=22></TD><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>8</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>18</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>19</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>15:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>21</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>15:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>21</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>16:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>18</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>16:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>17:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>13</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>17:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>18:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>18:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>11</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>19:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>11</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>19:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>9</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>20:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>8</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>20:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>9</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>21:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>8</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>21:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>7</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>22:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>6</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>22:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>5</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>23:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>5</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>23:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>5</TD></TR><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 2.25pt; mso-height-source: userset" height=3><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 2.25pt; BACKGROUND-COLOR: transparent" height=3></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Summary</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>197</TD></TR><TR style="HEIGHT: 3pt; mso-height-source: userset" height=4><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 3pt; BACKGROUND-COLOR: transparent" height=4></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: gray 2pt double; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=479 height=18>TUESDAY</TD><TD class=xl68 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: gray 2pt double; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 5.25pt; mso-height-source: userset" height=7><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 5.25pt; BACKGROUND-COLOR: transparent" height=7></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=479 height=17>Period Start</TD><TD class=xl65 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" width=33>SCH</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=479 height=22></TD><TD class=xl69 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" width=33></TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>08:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>09:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>10:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>14</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>18</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>11:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>19</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>12:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>15</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>16</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>13:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>23</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>22</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>14:30</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>23</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 359pt; BORDER-BOTTOM: windowtext; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=479 height=15>15:00</TD><TD class=xl66 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent" align=right width=33>23</TD></TR><TR style="HEIGHT: 1.5pt; mso-height-source: userset" height=2><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; HEIGHT: 1.5pt; BACKGROUND-COLOR: transparent" height=2></TD><TD class=xl67 style="BORDER-RIGHT: windowtext; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
What I want to do is put a formula in column C that will populate with the days, changing when they do. In other words, it will return "Monday" until it encounters "Tuesday", then "Tuesday" until it encounters "Wednesday", etc. I haven't been able to come up with anything. Does anyone know how I can do it (or if it can't be done)?
Just in case I'm getting too baroque in what I'm attempting, I'll further explain my ultimate goal in case anyone has a better idea:
What I want to do is create a vlookup based on a daily list of times from 12:30am through 11:30pm. It will go into the report above, and for each day pull the SCH number for any timeslot that appears in the report for that day. The only way I can think to do that, since each day will have a different number of timeslots from month to month, is to create a column tagging every cell between each day with the day name (ie, every cell in column C would say "Monday" until Tuesday appears in column A, then "Tuesday" until "Wednesday" appears in column A, etc thru Sunday. I just can't figure out a way to say, "vlookup the time value in the range of cells between cells containing the day names". I thought I had it by naming the ranges, until I realized that the range for each day might fluctuate monthly, depending on how many timeslots each day has, which can vary. Monday may have more one month and less another which will change the range of cells between Monday and Tuesday from one month to another, making the named range invalid (unless there's a way to make the named range variable?).
I hope this makes sense. Any help, as always, is much appreciated!
(I'm using Excel 2007, btw)
