Spreadsheet: 98455d1297350198-add-and-count-dates-and-summarize-results-cathal78-scheduling-employee-appraisals
Sheet: Summary

[NAME] |  |  |  |  |  |  | These columns are just for determining the date and can be hidden
Year | 2011
Date | 2011-02-08 00:00:00
Employee No | First Name | Surname | Department | Contract Start | Next Appraisal | [NAME] | 2012 Appraisal | Year Appraisal | 6 Month Appraisal | 3 Month Appraisal
0 | First47 | Last47 | 0 | 2010-11-11 00:00:00 | 2011-02-11 00:00:00 | 3 Month Appraisal | 2012-11-11 00:00:00 | 2011-11-11 00:00:00 | 2011-05-11 00:00:00 | 2011-02-11 00:00:00
0 | First87 | Last87 | 0 | 2008-02-20 00:00:00 | 2011-02-20 00:00:00 | Year Appraisal | 2012-02-20 00:00:00 | 2011-02-20 00:00:00
0 | First92 | Last92 | 0 | 2010-02-22 00:00:00 | 2011-02-22 00:00:00 | Year Appraisal | 2012-02-22 00:00:00 | 2011-02-22 00:00:00 | 2010-08-22 00:00:00 | 2010-05-22 00:00:00
0 | First82 | Last82 | 0 | 2009-02-27 00:00:00 | 2011-02-27 00:00:00 | Year Appraisal | 2012-02-27 00:00:00 | 2011-02-27 00:00:00
0 | First58 | Last58 | 0 | 2008-02-29 00:00:00 | 2011-03-01 00:00:00 | Year Appraisal | 2012-02-29 00:00:00 | 2011-03-01 00:00:00
0 | First53 | Last53 | 0 | 2009-03-02 00:00:00 | 2011-03-02 00:00:00 | Year Appraisal | 2012-03-02 00:00:00 | 2011-03-02 00:00:00
0 | First9 | [NAME] | 0 | 2006-03-06 00:00:00 | 2011-03-06 00:00:00 | Year Appraisal | 2012-03-06 00:00:00 | 2011-03-06 00:00:00
0 | First103 | Last103 | 0 | 2005-03-06 00:00:00 | 2011-03-06 00:00:00 | Year Appraisal | 2012-03-06 00:00:00 | 2011-03-06 00:00:00
0 | First88 | Last88 | 0 | 2007-03-07 00:00:00 | 2011-03-07 00:00:00 | Year Appraisal | 2012-03-07 00:00:00 | 2011-03-07 00:00:00
0 | [NAME] | Last77 | 0 | 2010-09-09 00:00:00 | 2011-03-09 00:00:00 | 6 Month Appraisal | 2012-09-09 00:00:00 | 2011-09-09 00:00:00 | 2011-03-09 00:00:00 | 2010-12-09 00:00:00
0 | First101 | Last101 | 0 | 2010-03-12 00:00:00 | 2011-03-12 00:00:00 | Year Appraisal | 2012-03-12 00:00:00 | 2011-03-12 00:00:00 | 2010-09-12 00:00:00 | 2010-06-12 00:00:00
0 | First67 | Last67 | 0 | 2007-03-14 00:00:00 | 2011-03-14 00:00:00 | Year Appraisal | 2012-03-14 00:00:00 | 2011-03-14 00:00:00
0 | First70 | Last70 | 0 | 2010-03-17 00:00:00 | 2011-03-17 00:00:00 | Year Appraisal | 2012-03-17 00:00:00 | 2011-03-17 00:00:00 | 2010-09-17 00:00:00 | 2010-06-17 00:00:00
0 | First57 | Last57 | 0 | 2009-03-18 00:00:00 | 2011-03-18 00:00:00 | Year Appraisal | 2012-03-18 00:00:00 | 2011-03-18 00:00:00
0 | First49 | Last49 | 0 | 2010-03-19 00:00:00 | 2011-03-19 00:00:00 | Year Appraisal | 2012-03-19 00:00:00 | 2011-03-19 00:00:00 | 2010-09-19 00:00:00 | 2010-06-19 00:00:00
0 | First95 | Last95 | 0 | 2006-03-20 00:00:00 | 2011-03-20 00:00:00 | Year Appraisal | 2012-03-20 00:00:00 | 2011-03-20 00:00:00
0 | First98 | Last98 | 0 | 2010-09-20 00:00:00 | 2011-03-20 00:00:00 | 6 Month Appraisal | 2012-09-20 00:00:00 | 2011-09-20 00:00:00 | 2011-03-20 00:00:00 | 2010-12-20 00:00:00
0 | First50 | Last50 | 0 | 2005-03-26 00:00:00 | 2011-03-26 00:00:00 | Year Appraisal | 2012-03-26 00:00:00 | 2011-03-26 00:00:00
0 | First15 | Last15 | 0 | 2007-03-30 00:00:00 | 2011-03-30 00:00:00 | Year Appraisal | 2012-03-30 00:00:00 | 2011-03-30 00:00:00
0 | First17 | Last17 | 0 | 2005-03-31 00:00:00 | 2011-03-31 00:00:00 | Year Appraisal | 2012-03-31 00:00:00 | 2011-03-31 00:00:00
0 | First61 | Last61 | 0 | 2005-03-31 00:00:00 | 2011-03-31 00:00:00 | Year Appraisal | 2012-03-31 00:00:00 | 2011-03-31 00:00:00
0 | First23 | Last23 | 0 | 2009-04-02 00:00:00 | 2011-04-02 00:00:00 | Year Appraisal | 2012-04-02 00:00:00 | 2011-04-02 00:00:00
0 | First66 | [NAME] | 0 | 2010-10-02 00:00:00 | 2011-04-02 00:00:00 | 6 Month Appraisal | 2012-10-02 00:00:00 | 2011-10-02 00:00:00 | 2011-04-02 00:00:00 | 2011-01-02 00:00:00
0 | First60 | Last60 | 0 | 2009-04-04 00:00:00 | 2011-04-04 00:00:00 | Year Appraisal | 2012-04-04 00:00:00 | 2011-04-04 00:00:00
0 | First56 | Last56 | 0 | 2006-04-05 00:00:00 | 2011-04-05 00:00:00 | Year Appraisal | 2012-04-05 00:00:00 | 2011-04-05 00:00:00
0 | First12 | [NAME] | 0 | 2010-10-12 00:00:00 | 2011-04-12 00:00:00 | 6 Month Appraisal | 2012-10-12 00:00:00 | 2011-10-12 00:00:00 | 2011-04-12 00:00:00 | 2011-01-12 00:00:00
0 | First55 | Last55 | 0 | 2010-04-16 00:00:00 | 2011-04-16 00:00:00 | Year Appraisal | 2012-04-16 00:00:00 | 2011-04-16 00:00:00 | 2010-10-16 00:00:00 | 2010-07-16 00:00:00
0 | First89 | Last89 | 0 | 2007-04-18 00:00:00 | 2011-04-18 00:00:00 | Year Appraisal | 2012-04-18 00:00:00 | 2011-04-18 00:00:00
0 | First81 | Last81 | 0 | 2010-04-24 00:00:00 | 2011-04-24 00:00:00 | Year Appraisal | 2012-04-24 00:00:00 | 2011-04-24 00:00:00 | 2010-10-24 00:00:00 | 2010-07-24 00:00:00
0 | First93 | Last93 | 0 | 2010-04-24 00:00:00 | 2011-04-24 00:00:00 | Year Appraisal | 2012-04-24 00:00:00 | 2011-04-24 00:00:00 | 2010-10-24 00:00:00 | 2010-07-24 00:00:00
0 | First80 | Last80 | 0 | 2005-04-28 00:00:00 | 2011-04-28 00:00:00 | Year Appraisal | 2012-04-28 00:00:00 | 2011-04-28 00:00:00
0 | First42 | Last42 | 0 | 2007-05-02 00:00:00 | 2011-05-02 00:00:00 | Year Appraisal | 2012-05-02 00:00:00 | 2011-05-02 00:00:00
0 | First52 | Last52 | 0 | 2009-05-03 00:00:00 | 2011-05-03 00:00:00 | Year Appraisal | 2012-05-03 00:00:00 | 2011-05-03 00:00:00
0 | First65 | Last65 | 0 | 2006-05-03 00:00:00 | 2011-05-03 00:00:00 | Year Appraisal | 2012-05-03 00:00:00 | 2011-05-03 00:00:00
0 | [NAME] | Smith | 0 | 2011-02-05 00:00:00 | 2011-05-05 00:00:00 | 3 Month Appraisal | 2012-02-05 00:00:00 | 2012-02-05 00:00:00 | 2011-08-05 00:00:00 | 2011-05-05 00:00:00
0 | First26 | Last26 | 0 | 2007-05-06 00:00:00 | 2011-05-06 00:00:00 | Year Appraisal | 2012-05-06 00:00:00 | 2011-05-06 00:00:00
0 | First18 | Last18 | 0 | 2007-05-20 00:00:00 | 2011-05-20 00:00:00 | Year Appraisal | 2012-05-20 00:00:00 | 2011-05-20 00:00:00
0 | First96 | Last96 | 0 | 2007-05-21 00:00:00 | 2011-05-21 00:00:00 | Year Appraisal | 2012-05-21 00:00:00 | 2011-05-21 00:00:00
0 | First86 | Last86 | 0 | 2005-05-23 00:00:00 | 2011-05-23 00:00:00 | Year Appraisal | 2012-05-23 00:00:00 | 2011-05-23 00:00:00
0 | First24 | Last24 | 0 | 2007-05-30 00:00:00 | 2011-05-30 00:00:00 | Year Appraisal | 2012-05-30 00:00:00 | 2011-05-30 00:00:00
0 | [NAME] | [NAME] | 0 | 2008-06-02 00:00:00 | 2011-06-02 00:00:00 | Year Appraisal | 2012-06-02 00:00:00 | 2011-06-02 00:00:00
0 | First43 | Last43 | 0 | 2008-06-02 00:00:00 | 2011-06-02 00:00:00 | Year Appraisal | 2012-06-02 00:00:00 | 2011-06-02 00:00:00
0 | First85 | Last85 | 0 | 2008-06-09 00:00:00 | 2011-06-09 00:00:00 | Year Appraisal | 2012-06-09 00:00:00 | 2011-06-09 00:00:00
0 | First73 | Last73 | 0 | 2006-06-10 00:00:00 | 2011-06-10 00:00:00 | Year Appraisal | 2012-06-10 00:00:00 | 2011-06-10 00:00:00
0 | First54 | Last54 | 0 | 2008-06-14 00:00:00 | 2011-06-14 00:00:00 | Year Appraisal | 2012-06-14 00:00:00 | 2011-06-14 00:00:00
0 | First14 | Last14 | 0 | 2008-06-17 00:00:00 | 2011-06-17 00:00:00 | Year Appraisal | 2012-06-17 00:00:00 | 2011-06-17 00:00:00
0 | First19 | Last19 | 0 | 2010-06-23 00:00:00 | 2011-06-23 00:00:00 | Year Appraisal | 2012-06-23 00:00:00 | 2011-06-23 00:00:00 | 2010-12-23 00:00:00 | 2010-09-23 00:00:00
0 | First40 | [NAME] | 0 | 2008-06-25 00:00:00 | 2011-06-25 00:00:00 | Year Appraisal | 2012-06-25 00:00:00 | 2011-06-25 00:00:00
0 | First94 | Last94 | 0 | 2005-06-28 00:00:00 | 2011-06-28 00:00:00 | Year Appraisal | 2012-06-28 00:00:00 | 2011-06-28 00:00:00
0 | First74 | [NAME] | 0 | 2006-07-10 00:00:00 | 2011-07-10 00:00:00 | Year Appraisal | 2012-07-10 00:00:00 | 2011-07-10 00:00:00
0 | First20 | Last20 | 0 | 2005-07-21 00:00:00 | 2011-07-21 00:00:00 | Year Appraisal | 2012-07-21 00:00:00 | 2011-07-21 00:00:00
0 | First68 | Last68 | 0 | 2010-08-04 00:00:00 | 2011-08-04 00:00:00 | Year Appraisal | 2012-08-04 00:00:00 | 2011-08-04 00:00:00 | 2011-02-04 00:00:00 | 2010-11-04 00:00:00
0 | First90 | Last90 | 0 | 2005-08-08 00:00:00 | 2011-08-08 00:00:00 | Year Appraisal | 2012-08-08 00:00:00 | 2011-08-08 00:00:00
0 | First27 | Last27 | 0 | 2007-08-10 00:00:00 | 2011-08-10 00:00:00 | Year Appraisal | 2012-08-10 00:00:00 | 2011-08-10 00:00:00
0 | First37 | Last37 | 0 | 2005-08-11 00:00:00 | 2011-08-11 00:00:00 | Year Appraisal | 2012-08-11 00:00:00 | 2011-08-11 00:00:00
0 | First99 | Last99 | 0 | 2005-08-11 00:00:00 | 2011-08-11 00:00:00 | Year Appraisal | 2012-08-11 00:00:00 | 2011-08-11 00:00:00
0 | First25 | [NAME] | 0 | 2005-08-13 00:00:00 | 2011-08-13 00:00:00 | Year Appraisal | 2012-08-13 00:00:00 | 2011-08-13 00:00:00
0 | First63 | [NAME] | 0 | 2007-08-13 00:00:00 | 2011-08-13 00:00:00 | Year Appraisal | 2012-08-13 00:00:00 | 2011-08-13 00:00:00
0 | First13 | [NAME] | 0 | 2005-08-14 00:00:00 | 2011-08-14 00:00:00 | Year Appraisal | 2012-08-14 00:00:00 | 2011-08-14 00:00:00
0 | First72 | Last72 | 0 | 2009-08-21 00:00:00 | 2011-08-21 00:00:00 | Year Appraisal | 2012-08-21 00:00:00 | 2011-08-21 00:00:00
0 | First45 | [NAME] | 0 | 2006-08-22 00:00:00 | 2011-08-22 00:00:00 | Year Appraisal | 2012-08-22 00:00:00 | 2011-08-22 00:00:00
0 | First78 | Last78 | 0 | 2009-09-05 00:00:00 | 2011-09-05 00:00:00 | Year Appraisal | 2012-09-05 00:00:00 | 2011-09-05 00:00:00
0 | First29 | Last29 | 0 | 2009-09-15 00:00:00 | 2011-09-15 00:00:00 | Year Appraisal | 2012-09-15 00:00:00 | 2011-09-15 00:00:00
0 | First10 | Last10 | 0 | 2009-09-16 00:00:00 | 2011-09-16 00:00:00 | Year Appraisal | 2012-09-16 00:00:00 | 2011-09-16 00:00:00
0 | First22 | Last22 | 0 | 2008-09-29 00:00:00 | 2011-09-29 00:00:00 | Year Appraisal | 2012-09-29 00:00:00 | 2011-09-29 00:00:00
0 | First71 | [NAME] | 0 | 2006-10-04 00:00:00 | 2011-10-04 00:00:00 | Year Appraisal | 2012-10-04 00:00:00 | 2011-10-04 00:00:00
0 | First102 | Last102 | 0 | 2005-10-08 00:00:00 | 2011-10-08 00:00:00 | Year Appraisal | 2012-10-08 00:00:00 | 2011-10-08 00:00:00
0 | First7 | Last7 | 0 | 2009-10-09 00:00:00 | 2011-10-09 00:00:00 | Year Appraisal | 2012-10-09 00:00:00 | 2011-10-09 00:00:00
0 | First16 | Last16 | 0 | 2007-10-15 00:00:00 | 2011-10-15 00:00:00 | Year Appraisal | 2012-10-15 00:00:00 | 2011-10-15 00:00:00
0 | First8 | Last8 | 0 | 2005-10-17 00:00:00 | 2011-10-17 00:00:00 | Year Appraisal | 2012-10-17 00:00:00 | 2011-10-17 00:00:00
0 | First35 | [NAME] | 0 | 2007-10-20 00:00:00 | 2011-10-20 00:00:00 | Year Appraisal | 2012-10-20 00:00:00 | 2011-10-20 00:00:00
0 | First34 | Last34 | 0 | 2008-10-25 00:00:00 | 2011-10-25 00:00:00 | Year Appraisal | 2012-10-25 00:00:00 | 2011-10-25 00:00:00
0 | First59 | [NAME] | 0 | 2008-10-27 00:00:00 | 2011-10-27 00:00:00 | Year Appraisal | 2012-10-27 00:00:00 | 2011-10-27 00:00:00
0 | First32 | Last32 | 0 | 2006-11-04 00:00:00 | 2011-11-04 00:00:00 | Year Appraisal | 2012-11-04 00:00:00 | 2011-11-04 00:00:00
0 | First38 | [NAME] | 0 | 2006-11-14 00:00:00 | 2011-11-14 00:00:00 | Year Appraisal | 2012-11-14 00:00:00 | 2011-11-14 00:00:00
0 | First69 | Last69 | 0 | 2005-11-20 00:00:00 | 2011-11-20 00:00:00 | Year Appraisal | 2012-11-20 00:00:00 | 2011-11-20 00:00:00
0 | First76 | Last76 | 0 | 2006-11-22 00:00:00 | 2011-11-22 00:00:00 | Year Appraisal | 2012-11-22 00:00:00 | 2011-11-22 00:00:00
0 | First97 | Last97 | 0 | 2007-11-26 00:00:00 | 2011-11-26 00:00:00 | Year Appraisal | 2012-11-26 00:00:00 | 2011-11-26 00:00:00
0 | First79 | Last79 | 0 | 2005-11-29 00:00:00 | 2011-11-29 00:00:00 | Year Appraisal | 2012-11-29 00:00:00 | 2011-11-29 00:00:00
0 | First30 | Last30 | 0 | 2007-11-30 00:00:00 | 2011-11-30 00:00:00 | Year Appraisal | 2012-11-30 00:00:00 | 2011-11-30 00:00:00
0 | First21 | Last21 | 0 | 2006-12-12 00:00:00 | 2011-12-12 00:00:00 | Year Appraisal | 2012-12-12 00:00:00 | 2011-12-12 00:00:00
0 | First36 | Last36 | 0 | 2005-12-13 00:00:00 | 2011-12-13 00:00:00 | Year Appraisal | 2012-12-13 00:00:00 | 2011-12-13 00:00:00
0 | First41 | Last41 | 0 | 2005-12-13 00:00:00 | 2011-12-13 00:00:00 | Year Appraisal | 2012-12-13 00:00:00 | 2011-12-13 00:00:00
0 | First83 | Last83 | 0 | 2006-12-15 00:00:00 | 2011-12-15 00:00:00 | Year Appraisal | 2012-12-15 00:00:00 | 2011-12-15 00:00:00
0 | First48 | [NAME] | 0 | 2006-12-20 00:00:00 | 2011-12-20 00:00:00 | Year Appraisal | 2012-12-20 00:00:00 | 2011-12-20 00:00:00
0 | First11 | [NAME] | 0 | 2009-12-24 00:00:00 | 2011-12-24 00:00:00 | Year Appraisal | 2012-12-24 00:00:00 | 2011-12-24 00:00:00
0 | First51 | Last51 | 0 | 2005-12-30 00:00:00 | 2011-12-30 00:00:00 | Year Appraisal | 2012-12-30 00:00:00 | 2011-12-30 00:00:00
0 | First62 | Last62 | 0 | 2005-01-07 00:00:00 | 2012-01-07 00:00:00 | 2012 Appraisal | 2012-01-07 00:00:00 | 2011-01-07 00:00:00
0 | First28 | Last28 | 0 | 2011-01-09 00:00:00 | 2012-01-09 00:00:00 | 2012 Appraisal | 2012-01-09 00:00:00 | 2011-01-09 00:00:00 | 2011-07-09 00:00:00 | 2011-04-09 00:00:00
0 | First33 | Last33 | 0 | 2011-01-10 00:00:00 | 2012-01-10 00:00:00 | 2012 Appraisal | 2012-01-10 00:00:00 | 2011-01-10 00:00:00 | 2011-07-10 00:00:00 | 2011-04-10 00:00:00
0 | First84 | Last84 | 0 | 2010-01-14 00:00:00 | 2012-01-14 00:00:00 | 2012 Appraisal | 2012-01-14 00:00:00 | 2011-01-14 00:00:00
0 | First46 | Last46 | 0 | 2006-01-17 00:00:00 | 2012-01-17 00:00:00 | 2012 Appraisal | 2012-01-17 00:00:00 | 2011-01-17 00:00:00
0 | First64 | [NAME] | 0 | 2009-01-19 00:00:00 | 2012-01-19 00:00:00 | 2012 Appraisal | 2012-01-19 00:00:00 | 2011-01-19 00:00:00
0 | First39 | Last39 | 0 | 2006-01-23 00:00:00 | 2012-01-23 00:00:00 | 2012 Appraisal | 2012-01-23 00:00:00 | 2011-01-23 00:00:00
0 | First91 | Last91 | 0 | 2006-01-26 00:00:00 | 2012-01-26 00:00:00 | 2012 Appraisal | 2012-01-26 00:00:00 | 2011-01-26 00:00:00
0 | First100 | Last100 | 0 | 2007-01-27 00:00:00 | 2012-01-27 00:00:00 | 2012 Appraisal | 2012-01-27 00:00:00 | 2011-01-27 00:00:00
0 | First31 | Last31 | 0 | 2010-01-30 00:00:00 | 2012-01-30 00:00:00 | 2012 Appraisal | 2012-01-30 00:00:00 | 2011-01-30 00:00:00
0 | First75 | Last75 | 0 | 2009-01-30 00:00:00 | 2012-01-30 00:00:00 | 2012 Appraisal | 2012-01-30 00:00:00 | 2011-01-30 00:00:00
0 | First44 | Last44 | 0 | 2010-01-31 00:00:00 | 2012-01-31 00:00:00 | 2012 Appraisal | 2012-01-31 00:00:00 | 2011-01-31 00:00:00