Generating a time-table

J

jamshoot

Board Regular
Joined
Oct 15, 2009
Messages
199
Hi
I need some help on a macro that can help me to extract the Data Input into Data Output time-table format as shown below.
Right now, I am doing it manually.


<table style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" border="0" cellpadding="0" cellspacing="0"> <colgroup> <col style="FONT-WEIGHT: bold; WIDTH: 30px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 90px"> <col style="WIDTH: 93px"> <col style="WIDTH: 82px"> <col style="WIDTH: 82px"> <col style="WIDTH: 82px"></colgroup> <tbody> <tr style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"> <td> </td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</td> <td style="BORDER-TOP-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000">Data Input</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="FONT-SIZE: 8pt"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Day</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Start Time</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">End Time</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Purpose</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Description</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Book For</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">John</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">History</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Grace</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 2</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mary</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Science</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 3</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">David</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Wed</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Physics</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">David</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Thu</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">History</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 2</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Grace</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Wed</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Maths</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Smith</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Tue</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Maths</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 3</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Smith</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Tue</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">1:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">1:30 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Chemistry</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 3</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">David</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:30 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Chemistry</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">David</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:30 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">1:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 3</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mary</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Fri</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 2</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">John</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Fri</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:30 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">1:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Maths</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 2</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Smith</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Thu</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 3</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">John</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Thu</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mary</td> <td style="FONT-SIZE: 8pt; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 17px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td></tr> <tr style="HEIGHT: 17px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td> <td style="FONT-SIZE: 8pt"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</td> <td style="BORDER-TOP-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000">Data Output</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Time From</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Time To</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Tue</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Wed</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Thu</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Fri</td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English Level 1
John</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Maths Level 3
Smith</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English Level 2
John</td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English Level 1
John</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">History Level 2
Grace</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English Level 1
John</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">History Level 2
Grace</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">History Level 1
Grace</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">History Level 1
Grace</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Physics Level 1
David</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English Level 3
John</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">History Level 1
Grace</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Physics Level 1
David</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English Level 3
John</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art Level 2
Mary</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Maths Level 1
Smith</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art Level 2
Mary</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Maths Level 1
Smith</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art Level 2
Mary</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art Level 1
Mary</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 3 Science
David</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art Level 1
Mary</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:30 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1 Chemistry
David</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:30 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">1:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Art Level 3
Mary</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Maths Level 2
Smith</td></tr> <tr style="HEIGHT: 34px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">1:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">1:30 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Chemistry Level 3
David</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr></tbody></table>
Cheers
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
Greetings Jams,

A little sloppy and not well tested, but see if this is close:
Rich (BB code): 
Option Explicit
    
Sub exa()
Dim wksSource                   As Worksheet
Dim wksDest                     As Worksheet
Dim lRow                        As Long
Dim i                           As Long
Dim n                           As Long
Dim ColNum                      As Long
Dim StartRow                    As Long
Dim EndRow                      As Long
Dim NewTime                     As Date
Dim arySETimes(1 To 25, 1 To 2) As Date
    
'// I wasn't sure of start/end times, for 0600-1800...                                  //
Const START_TIME As Date = #6:00:00 AM#
Const INCREMENT As Double = 2.08333333333334E-02
    
    '// Change sheetname to suit                                                        //
    Set wksSource = ThisWorkbook.Worksheets("Input")
    Set wksDest = ThisWorkbook.Worksheets.Add(After:=wksSource, Type:=xlWorksheet)
    
    With wksDest
        '// Plunk in header                                                             //
        With .Range("A1:G1")
            .Value = Array("Time From", "Time To", "Mon", "Tue", "Wed", "Thu", "Fri")
            .Font.Bold = True
            .HorizontalAlignment = xlCenter
        End With
        
        For lRow = 2 To 50 Step 2
            i = i + 1
            '// Fill array and destination sheet with times                             //
            arySETimes(i, 1) = START_TIME + NewTime
            arySETimes(i, 2) = START_TIME + NewTime + INCREMENT
            .Cells(lRow, "A").Value = START_TIME + NewTime
            .Cells(lRow, "B").Value = CDate(.Cells(lRow, "A").Value + INCREMENT)
            NewTime = NewTime + INCREMENT
        Next
    End With
    
    With wksSource
    
        lRow = .Cells(.Rows.Count, "F").End(xlUp).Row
        
        '// Rudimentary and untested, but we want to catch if there's a bad day name    //
        On Error GoTo Explain
        For i = 2 To lRow
            Select Case UCase(.Cells(i, "A").Text)
            Case "MON": ColNum = 3
            Case "TUE": ColNum = 4
            Case "WED": ColNum = 5
            Case "THU": ColNum = 6
            Case "FRI": ColNum = 7
            Case Else: Err.Raise 550
            End Select
            
            '// .Match to find what row in the array (in the column returned by .Index) //
            '// has the time we're looking for... * 2, to get what rows we want to plunk//
            '// stuff into.                                                             //
            StartRow = Application.Match(CDate(.Cells(i, "B").Value), Application.Index(arySETimes, 0, 1), 0) * 2
            EndRow = Application.Match(CDate(.Cells(i, "C").Value), Application.Index(arySETimes, 0, 2), 0) * 2
            
            For n = StartRow To EndRow Step 2
                wksDest.Cells(n, ColNum).Value = .Cells(i, 4).Value & Chr(32) & .Cells(i, 5).Value
                wksDest.Cells(n + 1, ColNum).Value = .Cells(i, 6).Value
            Next
JumpLoop:
        Next
        On Error GoTo 0
    End With
    
    '// 'Pretty' it up  //
    With wksDest
        .Range("A:G").Columns.AutoFit
        With .Range("A1:G51")
            .BorderAround , xlMedium, xlColorIndexAutomatic
            .Borders(xlInsideVertical).LineStyle = xlContinuous
            .Rows(1).Borders(xlEdgeBottom).LineStyle = xlContinuous
            .Rows(1).Borders(xlEdgeBottom).Weight = xlMedium
            For n = 3 To 49 Step 2
                .Rows(n).Borders(xlEdgeBottom).LineStyle = xlContinuous
                .Rows(n).Borders(xlEdgeBottom).Weight = xlMedium
            Next
        End With
    End With
Exit Sub
Explain:
    If Err.Number = 550 Then
        MsgBox "A bad val in day names...row: " & i, 0, vbNullString
        Err.Clear
        GoTo JumpLoop
    Else
        MsgBox Err.Number & vbTab & Err.Description
    End If
End Sub
Hope that helps,

Mark
 
Last edited:
Upvote 0
GTO said:
Greetings Jams,

A little sloppy and not well tested, but see if this is close:
Rich (BB code): 
Option Explicit
    
Sub exa()
Dim wksSource                   As Worksheet
Dim wksDest                     As Worksheet
Dim lRow                        As Long
Dim i                           As Long
Dim n                           As Long
Dim ColNum                      As Long
Dim StartRow                    As Long
Dim EndRow                      As Long
Dim NewTime                     As Date
Dim arySETimes(1 To 25, 1 To 2) As Date
    
'// I wasn't sure of start/end times, for 0600-1800...                                  //
Const START_TIME As Date = #6:00:00 AM#
Const INCREMENT As Double = 2.08333333333334E-02
    
    '// Change sheetname to suit                                                        //
    Set wksSource = ThisWorkbook.Worksheets("Input")
    Set wksDest = ThisWorkbook.Worksheets.Add(After:=wksSource, Type:=xlWorksheet)
    
    With wksDest
        '// Plunk in header                                                             //
        With .Range("A1:G1")
            .Value = Array("Time From", "Time To", "Mon", "Tue", "Wed", "Thu", "Fri")
            .Font.Bold = True
            .HorizontalAlignment = xlCenter
        End With
        
        For lRow = 2 To 50 Step 2
            i = i + 1
            '// Fill array and destination sheet with times                             //
            arySETimes(i, 1) = START_TIME + NewTime
            arySETimes(i, 2) = START_TIME + NewTime + INCREMENT
            .Cells(lRow, "A").Value = START_TIME + NewTime
            .Cells(lRow, "B").Value = CDate(.Cells(lRow, "A").Value + INCREMENT)
            NewTime = NewTime + INCREMENT
        Next
    End With
    
    With wksSource
    
        lRow = .Cells(.Rows.Count, "F").End(xlUp).Row
        
        '// Rudimentary and untested, but we want to catch if there's a bad day name    //
        On Error GoTo Explain
        For i = 2 To lRow
            Select Case UCase(.Cells(i, "A").Text)
            Case "MON": ColNum = 3
            Case "TUE": ColNum = 4
            Case "WED": ColNum = 5
            Case "THU": ColNum = 6
            Case "FRI": ColNum = 7
            Case Else: Err.Raise 550
            End Select
            
            '// .Match to find what row in the array (in the column returned by .Index) //
            '// has the time we're looking for... * 2, to get what rows we want to plunk//
            '// stuff into.                                                             //
            StartRow = Application.Match(CDate(.Cells(i, "B").Value), Application.Index(arySETimes, 0, 1), 0) * 2
            EndRow = Application.Match(CDate(.Cells(i, "C").Value), Application.Index(arySETimes, 0, 2), 0) * 2
            
            For n = StartRow To EndRow Step 2
                wksDest.Cells(n, ColNum).Value = .Cells(i, 4).Value & Chr(32) & .Cells(i, 5).Value
                wksDest.Cells(n + 1, ColNum).Value = .Cells(i, 6).Value
            Next
JumpLoop:
        Next
        On Error GoTo 0
    End With
    
    '// 'Pretty' it up  //
    With wksDest
        .Range("A:G").Columns.AutoFit
        With .Range("A1:G51")
            .BorderAround , xlMedium, xlColorIndexAutomatic
            .Borders(xlInsideVertical).LineStyle = xlContinuous
            .Rows(1).Borders(xlEdgeBottom).LineStyle = xlContinuous
            .Rows(1).Borders(xlEdgeBottom).Weight = xlMedium
            For n = 3 To 49 Step 2
                .Rows(n).Borders(xlEdgeBottom).LineStyle = xlContinuous
                .Rows(n).Borders(xlEdgeBottom).Weight = xlMedium
            Next
        End With
    End With
Exit Sub
Explain:
    If Err.Number = 550 Then
        MsgBox "A bad val in day names...row: " & i, 0, vbNullString
        Err.Clear
        GoTo JumpLoop
    Else
        MsgBox Err.Number & vbTab & Err.Description
    End If
End Sub
Hope that helps,

Mark
Click to expand...


Hi GTO

Thanks for the reply & help. Have try it ...but 3 errors.
1. I noticed those time around 10:30am & Friday is not extract to the time-table.
2. When I click the macro, the following errors appear:-

"A bad val in day names .... Row:2"

3. After that ....

" Run-time error in '550' :
Application-defined or object-defined error"

Other than that - it does generate out a time-table format in new sheet.
Pardon me - my VBA knowledge is limited, hence I really cannot figure those
VBA u wrote ... I hope to spend time to digest. In the meantime, hope u can fine-tune for me.
Cheers
 
Upvote 0
Hi all

Can anyone help me fix the above error code that provided by kind GTO ... i am in need of this macro.

Thks alot

Cheers
 
Upvote 0
jamshoot said:
Hi GTO

Thanks for the reply & help. Have try it ...but 3 errors.
1. I noticed those time around 10:30am & Friday is not extract to the time-table.
2. When I click the macro, the following errors appear:-

"A bad val in day names .... Row:2"
Click to expand...

I didn't get to test for #1 (sorry, I'm running a bit late). For #2, that means that in row 2 it didn't find 'Mon' or 'Tue' or so on. How many header rows do you have?

jamshoot said:
3. After that ....

" Run-time error in '550' :
Application-defined or object-defined error"

Cheers
Click to expand...

My bad. I goofed in my error handling. Try:
Rich (BB code): 
Option Explicit
    
Sub exa()
Dim wksSource                   As Worksheet
Dim wksDest                     As Worksheet
Dim lRow                        As Long
Dim i                           As Long
Dim n                           As Long
Dim ColNum                      As Long
Dim StartRow                    As Long
Dim EndRow                      As Long
Dim NewTime                     As Date
Dim arySETimes(1 To 25, 1 To 2) As Date
Dim SheetName                   As String
Dim OldSheetName                As String
    
'// I wasn't sure of start/end times, for 0600-1800...                                  //
Const START_TIME As Date = #6:00:00 AM#
Const INCREMENT As Double = 2.08333333333334E-02
    
    Application.ScreenUpdating = False
    '// Change sheetname to suit                                                        //
    Set wksSource = ThisWorkbook.Worksheets("Input")
    Set wksDest = ThisWorkbook.Worksheets.Add(After:=wksSource, Type:=xlWorksheet)
    
    With wksDest
        '// Plunk in header                                                             //
        With .Range("A1:G1")
            .ColumnWidth = 16
            .Value = Array("Time From", "Time To", "Mon", "Tue", "Wed", "Thu", "Fri")
            .Font.Bold = True
            .HorizontalAlignment = xlCenter
        End With
        
        For lRow = 2 To 50 Step 2
            i = i + 1
            '// Fill array and destination sheet with times                             //
            arySETimes(i, 1) = START_TIME + NewTime
            arySETimes(i, 2) = START_TIME + NewTime + INCREMENT
            .Cells(lRow, "A").Value = START_TIME + NewTime
            .Cells(lRow, "B").Value = CDate(.Cells(lRow, "A").Value + INCREMENT)
            NewTime = NewTime + INCREMENT
        Next
    End With
    
    With wksSource
    
        lRow = .Cells(.Rows.Count, "F").End(xlUp).Row
        
        '// Rudimentary and untested, but we want to catch if there's a bad day name    //
        On Error GoTo Explain
        For i = 2 To lRow
            Select Case UCase(.Cells(i, "A").Text)
            Case "MON": ColNum = 3
            Case "TUE": ColNum = 4
            Case "WED": ColNum = 5
            Case "THU": ColNum = 6
            Case "FRI": ColNum = 7
            Case Else: Err.Raise 550
            End Select
            
            '// .Match to find what row in the array (in the column returned by .Index) //
            '// has the time we're looking for... * 2, to get what rows we want to plunk//
            '// stuff into.                                                             //
            StartRow = Application.Match(CDate(.Cells(i, "B").Value), Application.Index(arySETimes, 0, 1), 0) * 2
            EndRow = Application.Match(CDate(.Cells(i, "C").Value), Application.Index(arySETimes, 0, 2), 0) * 2
            
            For n = StartRow To EndRow Step 2
                wksDest.Cells(n, ColNum).Value = .Cells(i, 4).Value & Chr(32) & .Cells(i, 5).Value
                wksDest.Cells(n + 1, ColNum).Value = .Cells(i, 6).Value
            Next
JumpLoop:
        Next
        On Error GoTo 0
    End With
    
    '// 'Pretty' it up  //
    With wksDest
        .Range("A:G").Columns.AutoFit
        With .Range("A1:G51")
            .HorizontalAlignment = xlCenter
            .BorderAround , xlMedium, xlColorIndexAutomatic
            .Borders(xlInsideVertical).LineStyle = xlContinuous
            .Borders(xlInsideVertical).Weight = xlMedium
            .Rows(1).Borders(xlEdgeBottom).LineStyle = xlContinuous
            .Rows(1).Borders(xlEdgeBottom).Weight = xlMedium
            For n = 3 To 49 Step 2
                .Rows(n).Borders(xlEdgeBottom).LineStyle = xlContinuous
                .Rows(n).Borders(xlEdgeBottom).Weight = xlThin
            Next
            .Parent.Parent.Windows(1).DisplayGridlines = False
            
            For n = 1 To 7
                .Columns(n).ColumnWidth = .Columns(n).ColumnWidth + 1.5
            Next
            
        End With
    End With
    
    '// Name the destination sheet like: Output, Output_01, Output_02 and so on         //
    SheetName = "Output"
    OldSheetName = SheetName
    
    On Error Resume Next
    Set wksSource = Nothing
    Set wksSource = ThisWorkbook.Worksheets(SheetName)
    n = 0
    Do While Not wksSource Is Nothing
        n = n + 1
        If Not SheetName = vbNullString Then OldSheetName = SheetName
        SheetName = "Output_" & Format(n, "00")
        Set wksSource = Nothing
        Set wksSource = ThisWorkbook.Worksheets(SheetName)
    Loop
    On Error GoTo 0
    
    wksDest.Name = SheetName
    wksDest.Move After:=ThisWorkbook.Worksheets(OldSheetName)
    
    Application.ScreenUpdating = True
Exit Sub
Explain:
    If Err.Number = 550 Then
        MsgBox Err.Number & vbCrLf & Err.Description & vbCrLf & "A bad val in day names...row: " & i, 0, vbNullString
        Err.Clear
        '// ACK!  A big oopsie on my part.  I definitely need more skills in error      //
        '// handling (I am quite gifted at creating the errors though!).
        Resume JumpLoop
    Else
        MsgBox Err.Number & vbTab & Err.Description
    End If
    Application.ScreenUpdating = True
End Sub
 
Upvote 0
Hi GTO

I'm pleased that u can help me again. The new revised macro works better than the 1st one .... very fast & neat .... except it still give me the error msg as below:-

"Application-defined or object defined error. A bad val in day names... row:2"
.... the last error flash from row 2 to 31. I've to click the cancel button 15 times to end the error msg. After that, everything was perfect !!
U asked me ...
"For #2, that means that in row 2 it didn't find 'Mon' or 'Tue' or so on. How many header rows do you have?".
I'm not sure what that means ... I interpret it as in each time slot row, I've 2 headers:-
- 1st header is to show the subject & level
- 2nd header to show the teacher's name under each column day.

However, do note that there are some day or time slot whereby, there is no schedule for lesson for the teacher. Pls refer to my previous Input Data.
I hope I've given u the correct answer.
Pls help me as your macro really will help me alot.
Cheers

Regards
jamshoot
 
Upvote 0
jamshoot said:
Hi GTO

I'm pleased that u can help me again. The new revised macro works better than the 1st one .... very fast & neat .... except it still give me the error msg as below:-

"Application-defined or object defined error. A bad val in day names... row:2"
.... the last error flash from row 2 to 31. I've to click the cancel button 15 times to end the error msg. After that, everything was perfect !!
Click to expand...
I am sorry, but I am not understanding. Here is the sample data I ran against:
Excel Workbook
ABCDEF
1DayStart TimeEnd TimePurposeDescriptionBook For
2Mon7:00 AM8:30 AMEnglishLevel 1John
3Mon8:30 AM10:00 AMHistoryLevel 1Grace
4Mon10:00 AM11:30 AMArtLevel 2Mary
5Mon0.4812:00 PMScienceLevel 3David
6Wed9:00 AM10:00 AMPhysicsLevel 1David
7Thu7:30 AM8:30 AMHistoryLevel 2Grace
8Wed10:00 AM11:00 AMMathsLevel 1Smith
9Tue7:00 AM7:30 AMMathsLevel 3Smith
10Tue1:00 PM1:30 PMChemistryLevel 3David
11Mon12:00 PM12:30 PMChemistryLevel 1David
12Mon12:30 PM1:00 PMArtLevel 3Mary
13Fri7:00 AM9:00 AMEnglishLevel 2John
14Fri12:30 PM1:00 PMMathsLevel 2Smith
15Thu9:00 AM10:00 AMEnglishLevel 3John
16Thu11:00 AM12:00 PMArtLevel 1Mary
Input
Excel 2003

As you can see, I included only one header row. Regardless, I am not understanding how it can be 'working great' if it is erroring on each row. If it does not find the day name (abbreviated) it would skip that row.

jamshoot said:
U asked me

"For #2, that means that in row 2 it didn't find 'Mon' or 'Tue' or so on. How many header rows do you have?".
I'm not sure what that means ... I interpret it as in each time slot row, I've 2 headers:-
- 1st header is to show the subject & level
- 2nd header to show the teacher's name under each column day.

However, do note that there are some day or time slot whereby, there is no schedule for lesson for the teacher. Pls refer to my previous Input Data.
Click to expand...

This I am not following.

Could you post sample input data, that is layed out exactly as in your actual wb?

Thanks,

Mark
 
Upvote 0
Hi GTO

After reading your reply, I spend many times running the macro over & over again .... finally, I realized where goes wrong. My original "Data Input" has this header "Data Input" in Cell A1. (see below) My actual data starts in Cell A2.
Hence when I run your macro in this sheet- the error msg appears. I have since removed the header in cell A1 & now the macro run perfectly.

<table style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" border="0" cellpadding="0" cellspacing="0"> <tbody> <tr style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</td> <td style="BORDER-TOP-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000">Data Input</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Day</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Start Time</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">End Time</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Purpose</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Description</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-WEIGHT: bold; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; COLOR: #ff0000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow">Book For</td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">7:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">English</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">John</td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">8:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Mon</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">11:30 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">12:00 PM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow"> </td></tr> <tr style="HEIGHT: 18px"> <td style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Wed</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">9:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">10:00 AM</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Physics</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">Level 1</td> <td style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 8pt; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Arial Narrow; TEXT-ALIGN: center">David</td></tr></tbody></table>
I appreciate your help & patience. A million thanks !!
Cheers.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA code clean up
Replies
9
Views
573
mumps
mumps
E
  • Question Question
Adding a custom message.
Replies
1
Views
659
Micron
M

Forum statistics

Threads
1,224,522
Messages
6,179,292
Members
452,902
Latest member
Knuddeluff

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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