Spreadsheet: 89171d1288917293-conditional-formatting-date-ranges-sample-training
Sheet: Training Detail

 |  |  | 2010-11-05 00:00:00
New Start | Dept Code | In Dept |  | Names |  | 12 wk time line | Date of Joining Company | [NAME] to be Completed by | Bronze FE Completed on(Date of Completion) | Bronze FE total | Silver FE to be completed by | Silver FECompleted on(Date of Completion) | Silver FE total | Gold For Dept to be Completed by | Gold Completed on(Date of Completion) | Gold Total | [NAME] to be Completed by | [NAME] For dept Completed on(Date of Completion) | Bronze FE total | Silver for dept to be completed by | Silver for dept Completed on(Date of Completion) | Silver Dept | Legal 1 | [NAME] | Legal 2 | [NAME] | Legal 3 | [NAME] | Legal 4 | [NAME] | Legal5 | [NAME] | Lehal 6 | [NAME] |  | Names | 4 wk review completed on | 12 Wk Completed on | Annual to  be completed | Annual Review Completed on | Review Completed | Review Grade |  | [NAME] | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  | P1 Due | [NAME] | [NAME] | P4 Due | P5 Due | P6 Due | P7 Due | [NAME] | P9 Due | P 10 Due | P 11 Due | [NAME] | Total Planned |  | P1 actual | P2 Actual | P3 Actual | P4 Actual | P5 Actual | P6 Actual | P7 Actual | P8 Actual | P9 Actual | P10 Actual | P11 Actual | P12 Actual | Total Comp
 | [NAME] | 1 | 0 | D | test1 | 2008-06-03 00:00:00 | 2008-03-04 00:00:00 | 2008-04-01 00:00:00 | 2008-03-10 00:00:00 | 1 | 2008-06-03 00:00:00 | 2010-04-23 00:00:00 | 1 |  |  | 0 | 2008-04-29 00:00:00 | 2009-04-22 00:00:00 | 1 | 2008-08-19 00:00:00 | 2009-04-23 00:00:00 | 1 | 2010-03-03 00:00:00 | 0 | 2009-11-24 00:00:00 | 0 | 2010-04-23 00:00:00 | 0 | 2010-01-27 00:00:00 | 1 | 2009-07-16 00:00:00 | 1 | 2009-02-07 00:00:00 | 0 |  | Dtest1 |  |  | 2010-11-09 00:00:00 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Dtest1 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 075a | 1 | 0 | P | test2 | 2010-09-13 00:00:00 | 2010-06-14 00:00:00 | 2010-07-12 00:00:00 | 2010-06-08 00:00:00 | 1 | 2010-09-13 00:00:00 |  | 0 |  |  | 0 | 2010-08-09 00:00:00 |  | 0 | 2010-11-29 00:00:00 |  | 0 | 2010-10-02 00:00:00 | 1 | 2010-10-02 00:00:00 | 1 | 2010-10-20 00:00:00 | 1 |  | 0 |  | 0 |  | 0 |  | Ptest2 | 2010-08-27 00:00:00 |  | 2010-08-27 00:00:00 | 2010-08-28 00:00:00 | 1 | g |  | 0 | 0 | 0 | 0 | 0 | Ptest2 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | 015a | 1 | 0 | K | test3 | 2007-12-11 00:00:00 | 2007-09-11 00:00:00 | 2007-10-09 00:00:00 | 2007-10-09 00:00:00 | 1 | 2007-12-11 00:00:00 | 2007-11-13 00:00:00 | 1 |  |  | 0 | 2007-11-06 00:00:00 | 2007-11-06 00:00:00 | 1 | 2008-02-26 00:00:00 | 2007-11-13 00:00:00 | 1 | 2010-09-20 00:00:00 | 1 | 2010-09-15 00:00:00 | 1 | 2010-10-10 00:00:00 | 1 | 2010-01-26 00:00:00 | 1 | 2009-07-31 00:00:00 | 1 | 2009-10-05 00:00:00 | 1 |  | Ktest3 |  |  | 2010-11-24 00:00:00 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Ktest3 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | [NAME] | 1 | 1 | M | test4 | 2010-12-07 00:00:00 | 2010-09-07 00:00:00 | 2010-10-05 00:00:00 | 2010-09-07 00:00:00 | 1 | 2010-12-07 00:00:00 | 2010-09-07 00:00:00 | 1 |  |  | 0 | 2010-11-02 00:00:00 |  | 0 | 2011-02-22 00:00:00 |  | 0 | 2010-09-07 00:00:00 | 1 | 2010-09-07 00:00:00 | 1 | 2010-09-07 00:00:00 | 0 |  | 0 | 2010-09-07 00:00:00 | 1 |  | 0 |  | Mtest4 |  |  | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 1 | a |  | 0 | 0 | 0 | Mtest4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | [NAME] | 1 | 0 | J | test5 | 2007-04-16 00:00:00 | 2007-01-15 00:00:00 | 2007-02-12 00:00:00 | 2007-02-12 00:00:00 | 1 | 2007-04-16 00:00:00 | 2007-07-02 00:00:00 | 1 |  |  | 0 | 2007-03-12 00:00:00 | 2007-03-12 00:00:00 | 1 | 2007-07-02 00:00:00 | 2007-07-02 00:00:00 | 1 | 2010-04-08 00:00:00 | 0 | 2009-10-21 00:00:00 | 0 | 2010-04-26 00:00:00 | 0 | 2010-01-28 00:00:00 | 1 | 2009-06-08 00:00:00 | 1 | 2010-04-08 00:00:00 | 1 |  | Jtest5 |  |  | 2010-05-02 00:00:00 | 2010-04-30 00:00:00 | 1 |  |  | 0 | Jtest5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | [NAME] | 1 | 0 | M | test6 | 2004-12-09 00:00:00 | 2004-09-09 00:00:00 | 2004-10-07 00:00:00 | 2004-10-07 00:00:00 | 1 | 2004-12-09 00:00:00 | 2005-02-24 00:00:00 | 1 |  |  | 0 | 2004-11-04 00:00:00 | 2004-11-04 00:00:00 | 1 | 2005-02-24 00:00:00 | 2005-02-24 00:00:00 | 1 | 2010-09-21 00:00:00 | 1 | 2010-09-21 00:00:00 | 1 | 2010-04-27 00:00:00 | 0 | 2010-01-26 00:00:00 | 1 | 2009-08-08 00:00:00 | 1 | 2010-04-10 00:00:00 | 1 |  | Mtest6 |  |  | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 1 | a |  | 0 | 0 | 0 | Mtest6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
1 | [NAME] | 1 | 1 | E | [NAME] | 2010-12-07 00:00:00 | 2010-09-07 00:00:00 | 2010-10-05 00:00:00 | 2010-09-07 00:00:00 | 1 | 2010-12-07 00:00:00 | 2010-09-07 00:00:00 | 1 |  |  | 0 | 2010-11-02 00:00:00 |  | 0 | 2011-02-22 00:00:00 |  | 0 | 2010-09-07 00:00:00 | 1 | 2010-09-07 00:00:00 | 1 | 2010-09-07 00:00:00 | 0 |  | 0 | 2010-09-07 00:00:00 | 1 |  | 0 |  | Etest7 |  |  | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 1 | a |  | 0 | 0 | 0 | Etest7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | [NAME] | 1 | 0 | I | test8 | 2007-01-16 00:00:00 | 2006-10-17 00:00:00 | 2006-11-14 00:00:00 | 2006-11-14 00:00:00 | 1 | 2007-01-16 00:00:00 | 2010-04-24 00:00:00 | 1 |  |  | 0 | 2006-12-12 00:00:00 | 2006-12-12 00:00:00 | 1 | 2007-04-03 00:00:00 | 2007-04-03 00:00:00 | 1 | 2010-09-21 00:00:00 | 1 | 2010-09-21 00:00:00 | 1 | 2010-04-13 00:00:00 | 0 | 2010-02-01 00:00:00 | 1 | 2009-07-14 00:00:00 | 1 | 2010-02-01 00:00:00 | 1 |  | Itest8 |  |  | 2010-11-02 00:00:00 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Itest8 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 011c | 1 | 0 | K | test9 | 2003-12-13 00:00:00 | 2003-09-13 00:00:00 | 2003-10-11 00:00:00 | 2003-10-11 00:00:00 | 1 | 2003-12-13 00:00:00 | 2004-02-28 00:00:00 | 1 |  |  | 0 | 2003-11-08 00:00:00 | 2003-11-08 00:00:00 | 1 | 2004-02-28 00:00:00 | 2004-02-28 00:00:00 | 1 | 2010-10-08 00:00:00 | 1 | 2010-10-08 00:00:00 | 1 | 2010-04-22 00:00:00 | 0 | 2010-04-22 00:00:00 | 1 | 2009-08-14 00:00:00 | 1 | 2010-10-08 00:00:00 | 1 |  | Ktest9 |  |  | 2010-03-26 00:00:00 | 2010-04-03 00:00:00 | 1 | a |  | Ktest9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2 |  | 9 | 2 |  |  |  |  |  |  | 9 |  |  | 8 |  |  | 0 |  |  | 6 |  |  | 6 |  | 7 |  | 7 |  | 2 |  | 6 |  | 8 |  | 5 |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 3 | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 9 |  | 1 | 1 | 0 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 2 | 5 | 5 | 6 | 6 | 6 | 9 | 9 | 9 | 9 |  |  | 1 | 2 | 2 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6