Appealing to greater minds; This question deals with conditional formatting.
Column “O” conditions are as follows:
1- =J11=”” (White text / White background)
2- =(H11 < N11) (Black text / Yellow background)
<N11) font Yellow text (Black < background)>3- =(H11>=N11) (Black text / Green background)
I need a fourth condition that essentially says this; If D11 is within 180 days of today and H11 is < J divided by 3 then (White text / Red background)
Any help would be greatly appreciated.
Column “O” conditions are as follows:
1- =J11=”” (White text / White background)
2- =(H11 < N11) (Black text / Yellow background)
<N11) font Yellow text (Black < background)>3- =(H11>=N11) (Black text / Green background)
I need a fourth condition that essentially says this; If D11 is within 180 days of today and H11 is < J divided by 3 then (White text / Red background)
Any help would be greatly appreciated.
<TABLE style="WIDTH: 695pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=923 border=0 x:str><COLGROUP><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4790" width=131><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" span=2 width=78><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768" width=21><COL style="WIDTH: 18pt; mso-width-source: userset; mso-width-alt: 877" width=24><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768" width=21><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><COL style="WIDTH: 161pt; mso-width-source: userset; mso-width-alt: 7826" width=214><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl47 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 98pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ccffff" width=131 height=17>A
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>New Hires</TD><TD class=xl27 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD class=xl24 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; WIDTH: 98pt; BORDER-BOTTOM: #eae6dd; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=131 height=17>TPE Progress</TD><TD class=xl29 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; WIDTH: 70pt; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent" width=93></TD><TD class=xl24 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 89.25pt" height=119><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 98pt; BORDER-BOTTOM: #eae6dd; HEIGHT: 89.25pt; BACKGROUND-COLOR: transparent" width=131 height=119>Employee</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=93>CRAFT M=Maint O=Ops E=Elect Y=Yard IC=Inst & Ctrls</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>Date in Position</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>Expected Completion Date</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78></TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=61>Modules this Month</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=56>Monthly 3317</TD><TD class=xl43 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=66 colSpan=3>Modules Complete / Total Modules</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=68>% Complete</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 161pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=214>Comments</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 98pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=131 height=17>Billy Bob</TD><TD class=xl34 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=93>M</TD><TD class=xl39 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39517">3/10/2008</TD><TD class=xl40 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78 x:num="40057">9/1/2009</TD><TD class=xl40 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78 x:num="39877">3/5/2009</TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=61 x:num>0</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=56>X</TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 16pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=21 x:num>9</TD><TD class=xl33 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; WIDTH: 18pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=24 x:str="'/">/</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; WIDTH: 16pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=21 x:num>18</TD><TD class=xl42 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:num="0.5">50.00%</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 161pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=214></TD></TR></TBODY></TABLE>
</TD><TD class=xl47 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=93>B
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=78>C
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=78>D
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=78>E
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=61>F
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=56>G
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 16pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=21>H
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 18pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=24>I
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 16pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=21>J
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=68>O
</TD><TD class=xl48 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 161pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff" width=214>P</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>New Hires</TD><TD class=xl27 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD class=xl24 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl29 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; WIDTH: 98pt; BORDER-BOTTOM: #eae6dd; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=131 height=17>TPE Progress</TD><TD class=xl29 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; WIDTH: 70pt; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent" width=93></TD><TD class=xl24 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 89.25pt" height=119><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 98pt; BORDER-BOTTOM: #eae6dd; HEIGHT: 89.25pt; BACKGROUND-COLOR: transparent" width=131 height=119>Employee</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=93>CRAFT M=Maint O=Ops E=Elect Y=Yard IC=Inst & Ctrls</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>Date in Position</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>Expected Completion Date</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78></TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=61>Modules this Month</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=56>Monthly 3317</TD><TD class=xl43 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=66 colSpan=3>Modules Complete / Total Modules</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=68>% Complete</TD><TD class=xl31 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 161pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=214>Comments</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl28 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 98pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=131 height=17>Billy Bob</TD><TD class=xl34 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=93>M</TD><TD class=xl39 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="39517">3/10/2008</TD><TD class=xl40 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78 x:num="40057">9/1/2009</TD><TD class=xl40 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78 x:num="39877">3/5/2009</TD><TD class=xl37 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=61 x:num>0</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext; WIDTH: 42pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=56>X</TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 16pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=21 x:num>9</TD><TD class=xl33 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; WIDTH: 18pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=24 x:str="'/">/</TD><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; WIDTH: 16pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=21 x:num>18</TD><TD class=xl42 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" x:num="0.5">50.00%</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 161pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=214></TD></TR></TBODY></TABLE>