Spreadsheet: 103882d1301550963-extracting-data-from-worksheets-sampleexceldata-mod
Sheet: PA

 | Preventative Actions
 | PA No. | Date Raised | Job No PA Raised on | Operations Area | Category | Description | Priority | Status | Owner | Further Action Reqd? | Action By | Action Target Date | Comments
1 | PA001 | 2006-02-16 00:00:00 |  |  |  |  |  | Closed
 | PA002 |  |  |  |  |  |  | Closed
 | PA003 | 2006-06-26 00:00:00 |  |  |  |  |  | Closed
 | PA004 | 2006-07-19 00:00:00 |  |  |  |  |  | Closed
 | PA005 | 2006-10-12 00:00:00 |  |  |  |  |  | Closed
 | PA006 | 2007-02-11 00:00:00 |  |  |  |  |  | Closed
 | PA007 | 2007-02-11 00:00:00 |  |  |  |  |  | Closed
 | PA008 | 2007-02-11 00:00:00 |  |  |  |  |  | Closed
 | PA009 | 2007-02-11 00:00:00 |  |  |  |  |  | Closed
 | PA010 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA011 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA012 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA013 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA014 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | [NAME] | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA016 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA017 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA018 | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | [NAME] | 2007-05-04 00:00:00 |  |  |  |  |  | Closed
 | PA020 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA021 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA022 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA023 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA024 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA025 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA026 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA027 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA028 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA029 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA030 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA031 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA032 | 2007-05-07 00:00:00 |  |  |  |  |  | Open
 | PA033 | 2007-05-07 00:00:00 |  |  |  |  |  | Closed
 | PA034 | 2007-06-26 00:00:00 |  |  |  |  |  | Closed
 | PA035 | 2007-07-25 00:00:00 |  |  |  |  |  | Closed
 | PA036 | 2007-10-30 00:00:00 |  |  |  |  |  | Closed
 | PA037 | 2007-11-02 00:00:00 |  |  |  |  |  | Closed
 | PA038 | 2007-11-02 00:00:00 |  |  |  |  |  | Closed
 | PA039 | 2007-12-18 00:00:00 |  |  |  |  |  | Closed
 | PA040 | 2008-02-26 00:00:00 |  |  |  |  |  | Closed
 | PA041 | 2008-03-04 00:00:00 |  |  |  |  |  | Closed
 | PA042 | 2008-03-14 00:00:00 |  |  |  |  |  | Closed
 | PA043 | 2008-04-04 00:00:00 |  |  |  |  |  | Closed
 | PA044 | 2008-05-02 00:00:00 |  |  |  |  |  | Closed
 | PA045 | 2008-06-10 00:00:00 |  |  |  |  |  | Closed
 | [NAME] | 2008-07-23 00:00:00 |  |  |  |  |  | Closed
 | PA047 | 2008-07-23 00:00:00 |  |  |  |  |  | Closed
 | PA048 | 2008-07-28 00:00:00 |  |  |  |  |  | Closed
 | PA049 | 2008-07-29 00:00:00 |  |  |  |  |  | Closed
 | PA 050 | 2008-07-30 00:00:00 |  |  |  |  |  | Closed
 | PA 051 | 2008-07-30 00:00:00 |  |  |  |  |  | Closed
 | PA 052 | 2008-07-31 00:00:00 |  |  |  |  |  | Closed
 | PA 053 | 2008-07-31 00:00:00 |  |  |  |  |  | Closed
 | PA 054 | 2008-08-05 00:00:00 |  |  |  |  |  | Closed
 | PA 055 | 2008-08-04 00:00:00 |  |  |  |  |  | Closed
 | PA 056 | 2008-08-06 00:00:00 |  |  |  |  |  | Closed
 | PA 057 | 2008-08-06 00:00:00 |  |  |  |  |  | Closed
 | PA 058 | 2008-08-07 00:00:00 |  |  |  |  |  | Closed
 | PA 059 | 2008-08-08 00:00:00 |  |  |  |  |  | Closed
 | PA 060 | 2008-08-08 00:00:00 |  |  |  |  |  | Closed
 | PA 061 | 2008-08-11 00:00:00 |  |  |  |  |  | Closed
 | PA 062 | 2008-08-11 00:00:00 |  |  |  |  |  | Closed
 | PA 063 | 2008-08-11 00:00:00 |  |  |  |  |  | Closed
 | PA 064 | 2008-08-11 00:00:00 |  |  |  |  |  | Closed
 | PA 065 | 2008-08-13 00:00:00 |  |  |  |  |  | Closed
 | PA 066 | 2008-08-20 00:00:00 |  |  |  |  |  | Closed
 | PA 067 | 2008-08-21 00:00:00 |  |  |  |  |  | Closed
 | PA 068 | 2008-07-30 00:00:00 |  |  |  |  |  | Open
 | PA 069 | 2008-10-03 00:00:00 |  |  |  |  |  | Open
 | PA 070 | 2008-10-03 00:00:00 |  |  |  |  |  | Closed
 | PA 071 | 2008-10-06 00:00:00 |  |  |  |  |  | Closed
 | PA 072 | 2008-10-10 00:00:00 |  |  |  |  |  | Closed
 | PA073 | 2008-10-17 00:00:00 |  |  |  |  |  | Closed
 | PA 074 | 2008-10-22 00:00:00 |  |  |  |  |  | Closed
 | PA 075 | 2008-12-17 00:00:00 |  |  |  |  |  | Closed
 | PA 076 | 2009-01-19 00:00:00 |  |  |  |  |  | Closed
 |  | 2009-02-17 00:00:00 |  |  |  |  |  | Closed
 | PA 078 | 2009-03-10 00:00:00 |  |  |  |  |  | Closed
 | PA 079 | 2009-05-05 00:00:00 |  |  |  |  |  | Closed
 | PA 080 | 2009-05-23 00:00:00 |  |  |  |  |  | Closed
 | PA 081 | 2009-06-03 00:00:00 |  |  |  |  |  | Closed
 | PA 082 | 2009-07-22 00:00:00 |  |  |  |  |  | Closed
 | PA 083 | 2009-08-05 00:00:00 |  |  |  |  |  | Closed
 | PA 084 | 2009-08-13 00:00:00 |  |  |  |  |  | Closed
 | PA 085 | 2009-09-11 00:00:00 |  |  |  |  |  | Closed
 | PA 086 | 2009-11-20 00:00:00 |  |  |  |  |  | Closed
 | PA 087 | 2009-11-20 00:00:00 |  |  |  |  |  | Closed
 | PA 088 | 2009-11-20 00:00:00 |  |  |  |  |  | Closed
 | PA 089 | 2009-11-20 00:00:00 |  |  |  |  |  | Closed
 | PA 90 | 2009-11-25 00:00:00 |  |  |  |  |  | Closed
 | PA 091 | 2009-12-09 00:00:00 |  |  |  |  |  | Closed
 | PA 092 | 2009-12-09 00:00:00 |  |  |  |  |  | Closed
 | PA 093 | 2009-12-03 00:00:00 |  |  |  |  |  | Closed
 | PA 094 | 2009-12-08 00:00:00 |  |  |  |  |  | Closed
 | PA 095 | 2009-12-11 00:00:00 |  |  |  |  |  | Open
 | PA 096 | 2009-12-12 00:00:00 |  |  |  |  |  | Closed
 | PA 097 | 2010-01-29 00:00:00 |  |  |  |  |  | Closed
 | PA 098 | 2010-02-15 00:00:00 |  |  |  |  |  | Closed
 | PA 099 | 2010-03-08 00:00:00 |  |  |  |  |  | Closed
 | PA 100 | 2010-03-19 00:00:00 |  |  |  |  |  | Open
 | PA 101 | 2010-03-19 00:00:00 |  |  |  |  |  | Closed
 | PA 102 | 2010-04-15 00:00:00 |  |  |  |  |  | Closed
 | PA 103 | 2010-04-19 00:00:00 |  |  |  |  |  | Closed
 | PA 104 | 2010-04-19 00:00:00 |  |  |  |  |  | Closed
 | PA 105 | 2010-02-06 00:00:00 |  |  |  |  |  | Closed
 | PA 106 | 2010-01-15 00:00:00 |  |  |  |  |  | Closed
 | PA 107 | 2010-05-18 00:00:00 |  |  |  |  |  | Closed
 | PA 108 | 2010-08-06 00:00:00 |  |  |  |  |  | Open
 | PA 109 | 2010-08-18 00:00:00
 | PA 110 | 2010-08-18 00:00:00 |  |  |  |  |  | Open
 | PA 111 | 2010-09-17 00:00:00 |  |  |  |  |  | Open
 | PA 112 | 2010-09-27 00:00:00 |  |  |  |  |  | Open
 | PA 113 | 2010-09-28 00:00:00 |  |  |  |  |  | Open
 | PA 114
 | PA 115 | 2010-10-18 00:00:00 |  |  |  |  | Low | Open
 | PA 116 | 2010-11-21 00:00:00 |  |  |  |  | Medium | Closed |  | Yes
 | PA 117 | 2011-01-22 00:00:00 |  |  |  |  | Low | Open |  | Yes
 | PA 118 | 2011-02-22 00:00:00 |  |  |  |  | Low | Open |  | Yes
 | PA 119 | 2011-03-18 00:00:00 |  |  |  |  | Medium | Open |  | Yes