Spreadsheet: 64351d1265221136-excel-2007-2007-graph-help-raw
Sheet: PIPs

Performance Improvement Plan (PIP) data
First Name | Last Name | Title | Department | Manager | Date Hired | PIP start date | PIP end date |  | Length of completed PIP (days) | Notes | Ongoing PIP from Previous Quarters | New PIP | Successfully Completed PIP | [NAME] on PIP | [NAME] on PIP
2007
Q1, 2007
 |  | Mfg Planner/Buyer | Manufacturing |  | 2000-06-01 00:00:00 | 2007-02-06 00:00:00 | Ongoing | 1 |  | Estimated end: 6-07 |  | 1
 |  | Technical Support Online Engineer | Customer Support |  | 2004-08-30 00:00:00 |  | 2007-03-31 00:00:00 | 1 |  | on PIP, now OFF as of April 2007. There is no information in his file on this. He can off PIP as [NAME] started at Tomo but we don't know the start date |  | 1 | 1
 |  |  |  |  |  |  | Total PIPS | 2 |  |  | 0 | 2 | 1 | 0 | 0
Q2, 2007
 |  | Mfg Planner/Buyer | Manufacturing |  | 2000-06-01 00:00:00 | 2007-02-06 00:00:00 | 2007-06-01 00:00:00 | 1 | 115 | PIP:  2/6/07, now OFF | 1 |  | 1
 |  |  |  |  |  |  | Total PIPS | 1 |  |  | 1 | 0 | 1 | 0 | 0
Q3, 2007
 |  | Service Logistics Specialist | Customer Support |  | 2006-02-06 00:00:00 | 2007-08-27 00:00:00 | Ongoing | 1 |  | Estimated end: 4/9/08 |  | 1
 |  | Associate Software Engineer | Product Development |  | 2006-06-06 00:00:00 |  |  | 1 |  | Disciplinary memo on Aug. 28, 2007 regarding poor attendance |  | 1
 |  | Technical Support Online Engineer | Customer Support |  | 2004-08-30 00:00:00 |  |  | 1 |  | First Formal Warning - attendance 9-19-07 |  | 1
 |  | Facilities Manager | Manufacturing |  | 2003-10-27 00:00:00 | 2007-09-10 00:00:00 | 2007-10-19 00:00:00 | 1 | 39 | PIP 9/10-10/19, now OFF |  | 1
 |  | Receptionist/Operations Admin Assistant | General and Administration |  | 2006-08-28 00:00:00 |  |  | 1 |  | 9/13/07 documented oral warning from [NAME] re: absenteeism, no actual PIP |  | 1
 |  | Technical Support Online Engineer | Customer Support |  | 2004-03-29 00:00:00 | 2007-09-27 00:00:00 | 2007-10-27 00:00:00 | 1 | 30 | was on PIP, now OFF |  | 1
 |  |  |  |  |  |  | Total PIPS | 6 |  |  | 0 | 6 | 0 | 0 | 0
Q4, 2007
 |  | Service Logistics Specialist | Customer Support |  | 2006-02-06 00:00:00 | 2007-08-27 00:00:00 | Ongoing | 1 |  | Estimated end: 4/9/08 | 1
 |  | Facilities Manager | Manufacturing |  | 2003-10-27 00:00:00 | 2007-09-10 00:00:00 | 2007-10-19 00:00:00 | 1 | 39 | PIP 9/10-10/19, now OFF | 1 |  | 1
 |  | Technical Support Online Engineer | Customer Support |  | 2004-03-29 00:00:00 | 2007-09-27 00:00:00 | 2007-10-27 00:00:00 | 1 | 30 | was on PIP, now OFF | 1 |  | 1
 |  | Inventory Control Clerk | Manufacturing |  | 2003-02-17 00:00:00 | 2007-10-19 00:00:00 | 2007-11-30 00:00:00 | 1 | 41 | PIP 10/19/07, with monthly updates, possibly through 2007 ([NAME] is the contact); is now OFF |  | 1 | 1
 |  | [NAME] | Manufacturing |  | 2005-03-21 00:00:00 | 2007-10-19 00:00:00 | Ongoing | 1 |  | PIP 10/19/07-April 2008, then moving to updated every 2-3 months on attendance, is still ON |  | 1
 |  | FSE | Customer Support |  | 2006-11-27 00:00:00 | 2007-11-13 00:00:00 | Ongoing | 1 |  | Estmated end: Jan 2008 |  | 1
 |  | Logistics Expeditor | EU Customer Support |  | 2006-12-15 00:00:00 | 2007-11-15 00:00:00 | Ongoing | 1 |  | Estimated end: April 2008 |  | 1
 |  | Staff Attorney | Legal |  | 2007-01-01 00:00:00 | 2007-12-20 00:00:00 | Ongoing | 1 |  | Estimated end 2/28/08 |  | 1
 |  |  |  |  |  |  | Total PIPS | 8 |  |  | 3 | 5 | 3 | 0 | 0
 |  |  |  |  |  |  | Total PIPS started in 2007 | 10
 |  |  |  |  |  |  | Average length of PIP | 49 | days
2008
Q1, 2008
 |  | Service Logistics Specialist | Customer Support |  | 2006-02-06 00:00:00 | 2007-08-27 00:00:00 | Ongoing | 1 |  | Estimated end: 4/9/08 | 1
 |  | [NAME] | Manufacturing |  | 2005-03-21 00:00:00 | 2007-10-19 00:00:00 | Ongoing | 1 |  | PIP 10/19/07-April 2008, then moving to updated every 2-3 months on attendance, is still ON | 1
 |  | FSE | Customer Support |  | 2006-11-27 00:00:00 | 2007-11-13 00:00:00 | 2008-01-25 00:00:00 | 1 | 72 | Terminated 1-25-08 | 1 |  |  | 1
 |  | Logistics Expeditor | EU Customer Support |  | 2006-12-15 00:00:00 | 2007-11-15 00:00:00 | Ongoing | 1 |  | Estimated end: April 2008 | 1
 |  | Staff Attorney | Legal |  | 2007-01-01 00:00:00 | 2007-12-20 00:00:00 | 2008-02-28 00:00:00 | 1 | 68 | ???????Nothing noted in file if she is off of this PIP or not, scheduled to end 2/28/08 | 1 |  | 1
 |  | Service Logistics Manager | Customer Support |  | 2007-02-20 00:00:00 | 2008-01-02 00:00:00 | Ongoing | 1 |  |  |  | 1
 |  | learning Solutions Coordinator | HR/Training |  | 2008-09-15 00:00:00 | 2008-03-01 00:00:00 | Ongoing | 1 |  | Estimated end : may 31st |  | 1
 |  | Sr Installation Engineer | Customer Support |  | 2002-02-11 00:00:00 | 2008-03-10 00:00:00 | Ongoing | 1 |  | Estimated end: April 25 |  | 1
 |  | IT Systems Administrator | IT |  | 2006-04-18 00:00:00 | 2008-03-14 00:00:00 | Ongoing | 1 |  | Estimated end: April 14 |  | 1
 |  | Quality  Assurance Engineer | Regulatory & Quality |  | 2006-04-11 00:00:00 | 2008-03-17 00:00:00 | Ongoing | 1 |  | Estimated end : 7/17/2008 |  | 1
 |  | International Marketing Manager | Marketing - Europe |  | 2007-07-25 00:00:00 | 2008-03-26 00:00:00 | Ongoing | 1 |  | Estimated end: 6/13/2008 |  | 1
 |  |  |  |  |  |  | Total PIPS | 11 |  |  | 5 | 6 | 1 | 1 | 0
Q2, 2008
 |  | Service Logistics Specialist | Customer Support |  | 2006-02-06 00:00:00 | 2007-08-27 00:00:00 | 2008-04-09 00:00:00 | 1 | 222 | Successfully came off of PIP | 1 |  | 1
 |  | [NAME] | Manufacturing |  | 2005-03-21 00:00:00 | 2007-10-19 00:00:00 | 2008-05-12 00:00:00 | 1 | 203 | Invol term | 1 |  |  |  | 1
 |  | Logistics Expeditor | EU Customer Support |  | 2006-12-15 00:00:00 | 2007-11-15 00:00:00 | 2008-04-30 00:00:00 | 1 | 165 | Terminated - Quentin's LDW is April 30, 2008 | 1 |  |  | 1
 |  | Service Logistics Manager | Customer Support |  | 2007-02-20 00:00:00 | 2008-01-02 00:00:00 | Ongoing | 1 |  |  | 1
 |  | learning Solutions Coordinator | HR/Training |  | 2008-09-15 00:00:00 | 2008-03-01 00:00:00 | 2008-06-30 00:00:00 | 1 | 119 | Successfully came off of PIP | 1 |  | 1
 |  | Sr Installation Engineer | Customer Support |  | 2002-02-11 00:00:00 | 2008-03-10 00:00:00 | Ongoing | 1 |  | Working on a demotion | 1
 |  | IT Systems Administrator | IT |  | 2006-04-18 00:00:00 | 2008-03-14 00:00:00 | 2008-04-14 00:00:00 | 1 | 30 | Successfully came off of PIP |  |  | 1
 |  | Quality  Assurance Engineer | Regulatory & Quality |  | 2006-04-11 00:00:00 | 2008-03-17 00:00:00 | Ongoing | 1 |  | Estimated end : 7/17/2008 | 1
 |  | International Marketing Manager | Marketing - Europe |  | 2007-07-25 00:00:00 | 2008-03-26 00:00:00 | 2008-06-09 00:00:00 | 1 | 73 | vol term 6-9-08 | 1 |  |  | 1
 |  | Facilities Manager | Manufacturing |  | 2003-10-27 00:00:00 |  | 2008-06-11 00:00:00 | 1 |  | Final Written Warning 4/19/08 , not formal PIP. Termed June 11 |  | 1 |  |  | 1
 |  | Group Lead Software Eng. | Product Development |  | 2004-12-06 00:00:00 | 2008-05-01 00:00:00 | 2008-06-17 00:00:00 | 1 | 46 | Invol term |  | 1 |  |  | 1
 |  | Receptionist/Operations Admin Assistant | General and Administration |  | 2006-08-28 00:00:00 |  | 2008-08-21 00:00:00 | 1 |  | Verbal warning 9-13-07. Formal written warning 5-28-08. |  | 1
 |  |  |  |  |  |  | Total PIPS | 12 |  |  | 8 | 3 | 3 | 2 | 3
Q3, 2008
 |  | Service Logistics Manager | Customer Support |  | 2007-02-20 00:00:00 | 2008-01-02 00:00:00 | 2008-09-02 00:00:00 | 1 | 240 | Termed as of October | 1 |  |  |  | 1
 |  | Sr Installation Engineer | Customer Support |  | 2002-02-11 00:00:00 | 2008-03-10 00:00:00 | Ongoing | 1 |  | Working on a demotion | 1
 |  |  | Customer Support |  |  |  | 2008-07-17 00:00:00 | 1 |  | Written Warning/Terminated LDW 7/17/08 |  | 1 |  |  | 1
 |  |  | Customer Support |  |  |  | 2008-08-22 00:00:00 | 1 |  | Written Warning Terminated LDW 8/22/08 |  | 1 |  |  | 1
 |  | Receptionist/Operations Admin Assistant | General and Administration |  | 2006-08-28 00:00:00 |  | 2008-08-21 00:00:00 | 1 |  | Verbal warning 9-13-07. Formal written warning 5-28-08. Final written warning 7-8-08 LDW 8/21/08 | 1 |  |  |  | 1
 |  | Group Lead-Product Integration Engineer | PD |  | 2005-01-03 00:00:00 | 2008-06-05 00:00:00 | 2008-08-15 00:00:00 | 1 | 70 |  |  | 1 | 1
 |  | Quality  Assurance Engineer | Regulatory & Quality |  | 2006-04-11 00:00:00 | 2008-03-17 00:00:00 | Ongoing | 1 |  | Up for review in late october | 1
 |  | Installation Technician | Customer Support |  | 2007-02-06 00:00:00 | 2008-09-24 00:00:00 | Ongoing | 1 |  | Up for review in late october |  | 1
 |  | Field Service Engineer | Customer Support |  | 2005-08-15 00:00:00 | 2008-09-18 00:00:00 | 2008-10-17 00:00:00 | 1 | 29 |  |  | 1
 |  |  |  |  |  |  | Total PIPS | 9 |  |  | 4 | 5 | 1 | 0 | 4
Q4, 2008
 |  | Sr Installation Engineer | Customer Support |  | 2002-02-11 00:00:00 | 2008-03-10 00:00:00 | Ongoing | 1 |  | demotion complete.  Off of PIP | 1 |  | 1
 |  | Quality  Assurance Engineer | Regulatory & Quality |  | 2006-04-11 00:00:00 | 2008-03-17 00:00:00 | Ongoing | 1 |  | Up for review in late october.  Termed | 1 |  |  |  | 1
 |  | Installation Technician | Customer Support |  | 2007-02-06 00:00:00 | 2008-09-24 00:00:00 | Ongoing | 1 |  | Up for review in late october. Termed | 1 |  |  |  | 1
 |  | Field Service Engineer | Customer Support |  | 2007-10-29 00:00:00 | 2008-11-03 00:00:00 | 2009-01-03 00:00:00 | 1 | 60 | Will review in 60 days.  Termed |  | 1 |  |  | 1
 |  | Sr. Field Service Engineer | Customer Support |  | 2005-06-27 00:00:00 | 2008-11-17 00:00:00 | 2009-01-17 00:00:00 | 1 | 60 | Will review in 60 days.  Resigned |  | 1 |  | 1
 |  | Field Service Engineer | Customer Support |  | 2008-02-04 00:00:00 | 2008-12-10 00:00:00 | Ongoing | 1 |  | Written Warning |  | 1
 |  |  |  |  |  |  |  | 1 |  | Termed 11/15/2008 | 1 |  |  | 1
 |  |  |  |  |  |  | Total PIPS | 7 |  |  | 4 | 3 | 1 | 2 | 3
 |  |  |  |  |  |  | Total PIPS started in 2008 | 17
 |  |  |  |  |  |  | Average length of PIP | 104.0714285714286 | days
2009
Q1, 2009
 |  | Sales Manager - SE | Sales |  | 2008-01-13 00:00:00 | 2009-03-01 00:00:00 | 2009-04-05 00:00:00 | 1 | 30 | Termed 4/4/09 |  | 1 |  |  | 1
 |  | Field Service Engineer | Customer Support |  | 2008-02-04 00:00:00 | 2008-12-10 00:00:00 | Ongoing | 1 |  | Written Warning | 1
 |  | Clinical Marketing Manager | Marketing |  | 2008-10-01 00:00:00 | 2009-01-15 00:00:00 |  | 1 |  | on final warning he quit | 0 | 1 |  | 1
 |  | Technical Support Engineer | Customer Support |  | 2004-03-29 00:00:00 | 2009-03-18 00:00:00 | 2009-05-18 00:00:00 | 1 |  | Written Warning - PIP Complete |  | 1 | 1
 |  | Field Service Engineer | Customer Support |  | 2006-11-06 00:00:00 | 2009-03-20 00:00:00 | 2009-05-20 00:00:00 | 1 |  | Written Warning |  | 1
 |  | Field Service Engineer | Customer Support |  | 2008-01-08 00:00:00 | 2009-03-18 00:00:00 | 2009-05-18 00:00:00 | 1 |  | Written Warning -  Final warning in July 2009 |  | 1
 |  | Sr. CAD Designer | Customer Support |  | 2006-10-24 00:00:00 | 2009-03-31 00:00:00 | 2009-05-31 00:00:00 | 1 |  | Written Warning  - Final warning in July 2009 |  | 1
 |  | Field Service Engineer | Customer Support |  | 2008-09-22 00:00:00 | 2009-03-16 00:00:00 |  | 1 |  | Written Warning - Termed |  | 1 |  |  | 1
 |  | Field Service Engineer | Customer Support |  | 2004-03-29 00:00:00 | 2009-03-18 00:00:00 | 2009-05-18 00:00:00 | 1 |  | Written Warning - |  | 1
 |  | QA Engineer | Regulatory |  | 2004-09-20 00:00:00 | 2009-03-31 00:00:00 | 2009-05-31 00:00:00 | 1 |  | Written Warning - |  | 1
 |  |  |  |  |  |  | Total PIPS | 10 |  |  | 1 | 9 | 1 | 1 | 2
Q2, 2009
 |  | Field Service Engineer | Customer Support |  | 2005-02-21 00:00:00 | 2009-05-04 00:00:00 | 2009-07-04 00:00:00 | 1 |  | Written Warning |  | 1
 |  | Field Service Engineer | Customer Support |  | 2008-02-04 00:00:00 | 2008-12-10 00:00:00 | Ongoing | 1 |  | PIP Complete | 1 |  | 1
 |  | Field Service Engineer | Customer Support |  | 2006-11-06 00:00:00 | 2009-03-20 00:00:00 | 2009-05-20 00:00:00 | 1 |  | Termed 5/21/09 | 1 |  |  |  | 1
 |  | Field Service Engineer | Customer Support |  | 2008-01-08 00:00:00 | 2009-03-18 00:00:00 | 2009-05-18 00:00:00 | 1 |  | Written Warning -  Final warning in July 2009 | 1
 |  | Sr. CAD Designer | Customer Support |  | 2006-10-24 00:00:00 | 2009-03-31 00:00:00 | 2009-05-31 00:00:00 | 1 |  | Written Warning  - Final warning in July 2009 | 1
 |  | Field Service Engineer | Customer Support |  | 2004-03-29 00:00:00 | 2009-03-18 00:00:00 | 2009-05-18 00:00:00 | 1 | 60 | PIP Complete | 1 |  | 1
 |  | QA Engineer | Regulatory |  | 2004-09-20 00:00:00 | 2009-03-31 00:00:00 | 2009-05-31 00:00:00 | 1 | 60 | PIP Complete | 1 |  | 1
 |  | Field Service Engineer | Customer Support |  | 2005-05-16 00:00:00 | 2009-05-01 00:00:00 | 2009-08-01 00:00:00 | 1 |  | Written Warning |  | 1
 |  |  |  |  |  |  | Total PIPS | 8 |  |  | 6 | 2 | 3 | 0 | 1
Q3, 2009
 |  | Field Service Engineer | Customer Support |  | 2005-02-21 00:00:00 | 2009-05-04 00:00:00 | 2009-07-04 00:00:00 | 1 |  | Termed 07/04/2009 | 1 |  |  | 1
 |  | Field Service Engineer | Customer Support |  | 2008-01-08 00:00:00 | 2009-03-18 00:00:00 | 2009-09-01 00:00:00 | 1 | 60 | PIP Complete | 1 |  | 1
 |  | Sr. CAD Designer | Customer Support |  | 2006-10-24 00:00:00 | 2009-03-31 00:00:00 | 2009-09-01 00:00:00 | 1 | 60 | PIP Complete | 1 |  | 1
 |  | Field Service Engineer | Customer Support |  | 2005-05-16 00:00:00 | 2009-05-01 00:00:00 | 2009-09-01 00:00:00 | 1 | 30 | PIP Complete | 1 |  | 1
 |  | Regional Service Manager | Customer Support |  | 2008-11-17 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 1 | 30 | PIP Complete |  |  | 1
 |  |  |  |  |  |  | Total PIPS | 5 |  |  | 4 | 0 | 4 | 1 | 0
Q4, 2009
 |  | Service Tools Developer | Customer Support |  | 2008-12-09 00:00:00 | 2009-12-04 00:00:00 |  | 1 | 5 | Written warning |  | 1
 |  | Sr. Cost Analyst | Finance |  | 2009-03-31 00:00:00 | 2009-10-12 00:00:00 | 2009-11-13 00:00:00 | 1 | 30 | Written warning- Termed 11/09 |  | 1 |  |  | 1
 |  |  |  |  |  |  | Total PIPS | 2 |  |  | 0 | 2 | 0 | 0 | 1
Q1, 2010
 |  | Service Tools Developer | Customer Support |  | 2008-12-09 00:00:00 | 2009-12-04 00:00:00 |  | 1 | 36 | PIP will be reviewed in 02/10 | 1
 |  |  |  |  |  |  | Total PIPS | 1 |  |  | 1 | 0 | 0 | 0 | 0
Q2, 2010
 |  |  |  |  |  |  | Total PIPS | 0 |  |  | 0 | 0 | 0 | 0 | 0