Spreadsheet: 464687d1465268746-excel-2013-how-to-remove-the-column-behind-column-a-example
Sheet: Sheet1

My Tasks (Enquiry)
Task | Activity Code | Task Stage | Responsible Person | Create Date | Work Stage | Source | Task Description | Task Status | Work Type | Start Date | Finish Date | Start Time | Finish Time | Work System | Task | Record Navigator Key | TaskStatus_Code | TaskStage_Code | TaskSource_Code
002808 | PLANNED | Approved | CIVILCON1 | 2016-01-19 00:00:00 | COMP | Property | RM16/00623 - Defect Inspection of Asset | Active | FOOTPASS | 2016-06-07 00:00:00 | 2016-06-07 00:00:00 | 07:31:09 | 09:06:00 | OP.WORKS | 002808 | 002808 | A | A | P1
 |  |  |  |  |  |  |  |  | FOOTPASS Total
 |  |  |  |  |  | Property Total
 |  |  | CIVILCON1 Total
003229 | UNPLANNED | Approved | CIVILG2 | 2016-02-03 00:00:00 | SCHED | Work System | Old Tree location 45 & 73 Partridge St | Active | DEPGENAS | 2016-05-30 00:00:00 |  | 00:00:00 | 00:00:00 | OP.WORKS | 003229 | 003229 | A | A | WS
 |  |  |  |  |  |  |  |  | DEPGENAS Total
005906 | UNPLANNED | Approved | CIVILG2 | 2016-05-19 00:00:00 | INPRG | Work System | RM16/00390 - Civil Work Group Leader | Active | KWTEXCAV | 2016-05-20 00:00:00 | 2016-06-07 00:00:00 | 11:32:11 | 11:32:18 | OP.WORKS | 005906 | 005906 | A | A | WS
 |  |  |  |  |  |  |  |  | KWTEXCAV Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILG2 Total
004209 | PLANNED | Approved | [NAME] | 2016-03-09 00:00:00 | SCHED | Property | RM16/01690 - Side Entry Pit Dislodgement | Active | DEPGENAS | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 11:59:27 | 12:08:37 | OP.WORKS | 004209 | 004209 | A | A | P1
 |  |  |  |  |  |  |  |  | DEPGENAS Total
 |  |  |  |  |  | Property Total
 |  |  | CIVILPAV1 Total
003025 | PLANNED | Approved | CIVILWGL | 2016-01-27 00:00:00 | COMP | Property | RM16/00824 - Defect Inspection of Asset | Active | FOOTPASS | 2016-06-06 00:00:00 | 2016-06-06 00:00:00 | [NAME] | 13:32:20 | OP.WORKS | 003025 | 003025 | A | A | P1
004944 | PLANNED | Approved | CIVILWGL | 2016-04-11 00:00:00 | DEFER | Property | RM16/02179 - Defect Inspection Required | Active | FOOTPASS | 2016-05-18 00:00:00 | 2016-05-19 00:00:00 | [NAME] | 07:14:36 | OP.WORKS | 004944 | 004944 | A | A | P1
 |  |  |  |  |  |  |  |  | FOOTPASS Total
 |  |  |  |  |  | Property Total
006164 | UNPLANNED | Approved | CIVILWGL | 2016-05-31 00:00:00 | COMP | Work System | GenMaint - | Active | FOOTEX | 2016-06-02 00:00:00 | 2016-06-02 00:00:00 | 15:30:28 | 15:30:29 | OP.WORKS | 006164 | 006164 | A | A | WS
 |  |  |  |  |  |  |  |  | FOOTEX Total
006018 | PLANNED | Approved | CIVILWGL | 2016-05-25 00:00:00 | COMP | Work System | Vertical Displacement of Concrete Footpa | Active | FOOTPOUR | 2016-05-30 00:00:00 | 2016-06-01 00:00:00 | 07:34:25 | 08:49:59 | OP.WORKS | 006018 | 006018 | A | A | WS
006187 | PLANNED | Approved | CIVILWGL | 2016-06-01 00:00:00 | INPRG | Work System | RM16/01386 - Defect Inspection Required | Active | FOOTPOUR | 2016-06-01 00:00:00 | 2016-06-01 00:00:00 | 14:23:22 | 14:23:26 | OP.WORKS | 006187 | 006187 | A | A | WS
 |  |  |  |  |  |  |  |  | FOOTPOUR Total
005904 | UNPLANNED | Approved | CIVILWGL | 2016-05-19 00:00:00 | COMP | Work System | RM16/00390 - Civil Work Group Leader | Active | KWTBOXUP | 2016-05-31 00:00:00 | 2016-06-06 00:00:00 | 07:39:55 | 11:21:08 | OP.WORKS | 005904 | 005904 | A | A | WS
 |  |  |  |  |  |  |  |  | KWTBOXUP Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILWGL Total
 |  | Approved Total
002891 | UNPLANNED | Work Complete | CIVILCON1 | 2016-01-21 00:00:00 | COMP | Mobility | Footpath, Road or [NAME] trip haz | Active | FOOTPASS | 2016-05-30 00:00:00 | 2016-05-30 00:00:00 | 14:45:46 | 14:45:48 | OP.WORKS | 002891 | 002891 | A | W | MO
 |  |  |  |  |  |  |  |  | FOOTPASS Total
 |  |  |  |  |  | Mobility Total
002973 | PLANNED | Work Complete | CIVILCON1 | 2016-01-25 00:00:00 | COMP | Property | RM16/00761 - Defect Inspection Required | Active | FOOTPASS | 2016-05-16 00:00:00 | 2016-05-19 00:00:00 | 13:00:29 | 10:53:17 | OP.WORKS | 002973 | 002973 | A | W | P1
002992 | PLANNED | Work Complete | CIVILCON1 | 2016-01-27 00:00:00 | COMP | Property | RM16/00785 - Defect Inspection of Asset | Active | FOOTPASS | 2016-05-24 00:00:00 | 2016-05-24 00:00:00 | 11:24:55 | 11:24:55 | OP.WORKS | 002992 | 002992 | A | W | P1
005260 | PLANNED | Work Complete | CIVILCON1 | 2016-04-22 00:00:00 | COMP | Property | RM16/02363 - Defect Inspection of Asset | Active | FOOTPASS | 2016-05-19 00:00:00 | 2016-05-27 00:00:00 | 12:38:53 | 07:57:22 | OP.WORKS | 005260 | 005260 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPASS Total
002780 | PLANNED | Work Complete | CIVILCON1 | 2016-01-18 00:00:00 | COMP | Property | RM16/00598 - Defect Inspection of Asset | Active | FOOTPOUR | 2016-05-30 00:00:00 | 2016-05-30 00:00:00 | 07:10:30 | [NAME] | OP.WORKS | 002780 | 002780 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPOUR Total
 |  |  |  |  |  | Property Total
001655 | PLANNED | Work Complete | CIVILCON1 | 2015-11-30 00:00:00 | COMP | Work System | Uplifted footpath at 16-18 Marlborough S | Active | FOOTPASS | 2016-05-24 00:00:00 | 2016-05-24 00:00:00 | 12:45:24 | 13:24:56 | OP.WORKS | 001655 | 001655 | A | W | WS
003301 | PLANNED | Work Complete | CIVILCON1 | 2016-02-04 00:00:00 | COMP | Work System | Subsided footpath at 38 [NAME] Glenelg | Active | FOOTPASS | 2016-05-24 00:00:00 | 2016-05-24 00:00:00 | 07:31:36 | 07:31:36 | OP.WORKS | 003301 | 003301 | A | W | WS
 |  |  |  |  |  |  |  |  | FOOTPASS Total
001658 | PLANNED | Work Complete | CIVILCON1 | 2015-11-30 00:00:00 | COMP | Work System | 120 122 b Augusta Street Glenelg East | Active | FOOTPAV | 2016-05-16 00:00:00 | 2016-05-16 00:00:00 | [NAME] | [NAME] | OP.WORKS | 001658 | 001658 | A | W | WS
 |  |  |  |  |  |  |  |  | FOOTPAV Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILCON1 Total
004658 | PLANNED | Work Complete | [NAME] | 2016-03-30 00:00:00 | COMP | Property | RM16/01994 - Defect Inspection of Asset | Active | FOOTPASS | 2016-05-18 00:00:00 | 2016-05-25 00:00:00 | 15:10:57 | 10:31:22 | OP.WORKS | 004658 | 004658 | A | W | P1
005143 | PLANNED | Work Complete | [NAME] | 2016-04-19 00:00:00 | COMP | Property | RM16/02292 - Defect Inspection of Asset | Active | FOOTPASS | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 07:35:35 | 12:54:53 | OP.WORKS | 005143 | 005143 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPASS Total
003361 | PLANNED | Work Complete | [NAME] | 2016-02-08 00:00:00 | COMP | Property | 15 dumbar tce  lifted pavers | Active | FOOTPAV | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 07:43:54 | 08:44:08 | OP.WORKS | 003361 | 003361 | A | W | P1
004296 | PLANNED | Work Complete | [NAME] | 2016-03-15 00:00:00 | COMP | Property | RM16/01757 - Defect Inspection Required | Active | FOOTPAV | 2016-05-24 00:00:00 | 2016-05-26 00:00:00 | 07:29:05 | 14:29:23 | OP.WORKS | 004296 | 004296 | A | W | P1
004578 | PLANNED | Work Complete | [NAME] | 2016-03-24 00:00:00 | COMP | Property | RM16/01931 - Defect Inspection of Asset | Active | FOOTPAV | 2016-05-27 00:00:00 | 2016-05-30 00:00:00 | 11:38:41 | 11:31:56 | OP.WORKS | 004578 | 004578 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPAV Total
001617 | PLANNED | Work Complete | [NAME] | 2015-11-27 00:00:00 | COMP | Property | RM15/05495 - Pot Hole Repairs | Active | ROADASS | 2016-05-17 00:00:00 | 2016-05-17 00:00:00 | 09:00:00 | 15:05:29 | OP.WORKS | 001617 | 001617 | A | W | P1
 |  |  |  |  |  |  |  |  | ROADASS Total
 |  |  |  |  |  | Property Total
000052 | PLANNED | Work Complete | [NAME] | 2015-10-08 00:00:00 | COMP | Work System | Uplifted paved footpath | Active | FOOTPASS | 2016-05-18 00:00:00 | 2016-05-18 00:00:00 | 10:07:55 | 14:34:10 | OP.WORKS | 000052 | 000052 | A | W | WS
003181 | PLANNED | Work Complete | [NAME] | 2016-02-02 00:00:00 | COMP | Work System | Footpath: 43 Scarborough St | Active | FOOTPASS | 2016-05-25 00:00:00 | 2016-05-25 00:00:00 | 12:46:50 | [NAME] | OP.WORKS | 003181 | 003181 | A | W | WS
003780 | PLANNED | Work Complete | [NAME] | 2016-02-23 00:00:00 | COMP | Work System | Tree removed at 5 Ferguson St Glenelg Nt | Active | FOOTPASS | 2016-05-30 00:00:00 | 2016-05-30 00:00:00 | 10:17:07 | 10:37:51 | OP.WORKS | 003780 | 003780 | A | W | WS
004906 | PLANNED | Work Complete | [NAME] | 2016-04-11 00:00:00 | COMP | Work System | Trip hazards in Davey Ave Glenelg North | Active | FOOTPASS | 2016-06-06 00:00:00 | 2016-06-06 00:00:00 | 08:24:31 | 15:20:43 | OP.WORKS | 004906 | 004906 | A | W | WS
005257 | PLANNED | Work Complete | [NAME] | 2016-04-22 00:00:00 | COMP | Work System | Yuill Street Glenelg | Active | FOOTPASS | 2016-05-30 00:00:00 | 2016-06-02 00:00:00 | 14:20:04 | 07:23:49 | OP.WORKS | 005257 | 005257 | A | W | WS
 |  |  |  |  |  |  |  |  | FOOTPASS Total
006087 | PLANNED | Work Complete | [NAME] | 2016-05-27 00:00:00 | COMP | Work System | 62 Bowker Street kerbing | Active | KWTBOXUP | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 09:13:54 | [NAME] | OP.WORKS | 006087 | 006087 | A | W | WS
 |  |  |  |  |  |  |  |  | KWTBOXUP Total
 |  |  |  |  |  | Work System Total
 |  |  | [NAME]
005147 | PLANNED | Work Complete | CIVILG1 | 2016-04-19 00:00:00 | COMP | Property | RM16/02295 - Side Entry Pit Dislodgement | Active | DEPGENAS | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 09:19:16 | 09:19:19 | OP.WORKS | 005147 | 005147 | A | W | P1
005212 | UNPLANNED | Work Complete | CIVILG1 | 2016-04-20 00:00:00 | COMP | Property | RM16/02325 - Create a Work Order 27/4 | Active | DEPGENAS | 2016-05-17 00:00:00 | 2016-05-17 00:00:00 | 14:56:54 | 14:56:57 | OP.WORKS | 005212 | 005212 | A | W | P1
 |  |  |  |  |  |  |  |  | DEPGENAS Total
 |  |  |  |  |  | Property Total
005305 | UNPLANNED | Work Complete | CIVILG1 | 2016-04-26 00:00:00 | COMP | Work System | Drinking Fountain Install | Active | DEPGENAS | 2016-05-17 00:00:00 | 2016-05-17 00:00:00 | [NAME] | 12:34:48 | OP.WORKS | 005305 | 005305 | A | W | WS
 |  |  |  |  |  |  |  |  | DEPGENAS Total
003783 | PLANNED | Work Complete | CIVILG1 | 2016-02-23 00:00:00 | COMP | Work System | RM15/04478 - Pot Hole Repairs | Active | ROADBIT | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 13:03:44 | 13:03:57 | OP.WORKS | 003783 | 003783 | A | W | WS
 |  |  |  |  |  |  |  |  | ROADBIT Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILG1 Total
006086 | PLANNED | Work Complete | CIVILG2 | 2016-05-27 00:00:00 | COMP | Work System | 62 Bowker Street kerbing | Active | KWTBFBIT | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 09:17:14 | 09:17:15 | OP.WORKS | 006086 | 006086 | A | W | WS
 |  |  |  |  |  |  |  |  | KWTBFBIT Total
005346 | PLANNED | Work Complete | CIVILG2 | 2016-04-27 00:00:00 | COMP | Work System | 62 Bowker Street kerbing | Active | KWTEXCAV | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 09:12:12 | 09:12:13 | OP.WORKS | 005346 | 005346 | A | W | WS
 |  |  |  |  |  |  |  |  | KWTEXCAV Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILG2 Total
005121 | PLANNED | Work Complete | [NAME] | 2016-04-19 00:00:00 | COMP | Property | RM16/01799 - Side Entry Pit Dislodgement | Active | DEPGENAS | 2016-05-30 00:00:00 | 2016-05-30 00:00:00 | 09:22:34 | 09:22:35 | OP.WORKS | 005121 | 005121 | A | W | P1
 |  |  |  |  |  |  |  |  | DEPGENAS Total
001422 | PLANNED | Work Complete | [NAME] | 2015-11-20 00:00:00 | COMP | Property | RM15/05377 - Defect Inspection Required | Active | FOOTPASS | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 10:00:56 | 12:00:56 | OP.WORKS | 001422 | 001422 | A | W | P1
005757 | PLANNED | Work Complete | [NAME] | 2016-05-13 00:00:00 | COMP | Property | Danger - 2A Chester Street GLENELG SOUTH | Active | FOOTPASS | 2016-06-03 00:00:00 | 2016-06-03 00:00:00 | 09:59:29 | 10:59:28 | OP.WORKS | 005757 | 005757 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPASS Total
001029 | PLANNED | Work Complete | [NAME] | 2015-11-06 00:00:00 | COMP | Property | RM15/05118 - Defect Inspection Required | Active | FOOTPAV | 2016-05-16 00:00:00 | 2016-05-17 00:00:00 | 07:26:22 | 12:13:49 | OP.WORKS | 001029 | 001029 | A | W | P1
001419 | UNPLANNED | Work Complete | [NAME] | 2015-11-20 00:00:00 | COMP | Property | wigley reserve  wheelchair sports | Active | FOOTPAV | 2016-05-17 00:00:00 | 2016-05-17 00:00:00 | 09:14:17 | 09:34:17 | OP.WORKS | 001419 | 001419 | A | W | P1
004828 | PLANNED | Work Complete | [NAME] | 2016-04-06 00:00:00 | COMP | Property | Beck's Bakehouse lady tripped on pavers | Active | FOOTPAV | 2016-05-27 00:00:00 | 2016-05-30 00:00:00 | 12:07:10 | 12:07:00 | OP.WORKS | 004828 | 004828 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPAV Total
 |  |  |  |  |  | Property Total
005394 | UNPLANNED | Work Complete | [NAME] | 2016-04-29 00:00:00 | COMP | Work System | Drinking Fountain Install | Active | DEPGENAS | 2016-05-20 00:00:00 | 2016-05-23 00:00:00 | 07:26:12 | [NAME] | OP.WORKS | 005394 | 005394 | A | W | WS
 |  |  |  |  |  |  |  |  | DEPGENAS Total
004799 | PLANNED | Work Complete | [NAME] | 2016-04-06 00:00:00 | COMP | Work System | 4 Grosvenor Street Somerton Park | Active | FOOTPAV | 2016-05-18 00:00:00 | 2016-05-23 00:00:00 | [NAME] | 13:44:00 | OP.WORKS | 004799 | 004799 | A | W | WS
005842 | PLANNED | Work Complete | [NAME] | 2016-05-18 00:00:00 | COMP | Work System | Install Bay Sheffield Paver | Active | FOOTPAV | 2016-05-30 00:00:00 | 2016-05-30 00:00:00 | 08:52:21 | 09:04:22 | OP.WORKS | 005842 | 005842 | A | W | WS
 |  |  |  |  |  |  |  |  | FOOTPAV Total
005775 | UNPLANNED | Work Complete | [NAME] | 2016-05-16 00:00:00 | COMP | Work System | Please deliver half pallet of Pavers | Active | NA | 2016-05-17 00:00:00 | 2016-05-17 00:00:00 | 15:38:02 | 15:38:02 | OP.WORKS | 005775 | 005775 | A | W | WS
 |  |  |  |  |  |  |  |  | NA Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILPAV1 Total
002205 | PLANNED | Work Complete | [NAME] | 2015-12-22 00:00:00 | COMP | Property | RM15/05945 - Defect Inspection of Asset | Active | FOOTPASS | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 08:01:40 | 08:23:53 | OP.WORKS | 002205 | 002205 | A | W | P1
004690 | PLANNED | Work Complete | [NAME] | 2016-03-31 00:00:00 | COMP | Property | RM16/02012 - Defect Inspection Required | Active | FOOTPASS | 2016-05-25 00:00:00 | 2016-05-25 00:00:00 | 13:02:50 | 13:36:02 | OP.WORKS | 004690 | 004690 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPASS Total
001978 | PLANNED | Work Complete | [NAME] | 2015-12-10 00:00:00 | COMP | Property | RM15/05759 - Defect Inspection of Asset | Active | FOOTPAV | 2016-05-16 00:00:00 | 2016-05-16 00:00:00 | 12:38:03 | 12:38:05 | OP.WORKS | 001978 | 001978 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPAV Total
 |  |  |  |  |  | Property Total
000063 | PLANNED | Work Complete | [NAME] | 2015-10-09 00:00:00 | COMP | Work System | Uplifted concrete footpath | Active | FOOTPAV | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 08:06:04 | 13:06:06 | OP.WORKS | 000063 | 000063 | A | W | WS
005959 | PLANNED | Work Complete | [NAME] | 2016-05-23 00:00:00 | COMP | Work System | grand hotel , remove bollard  and pave | Active | FOOTPAV | 2016-05-23 00:00:00 | 2016-05-24 00:00:00 | 11:50:46 | 11:50:46 | OP.WORKS | 005959 | 005959 | A | W | WS
 |  |  |  |  |  |  |  |  | FOOTPAV Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILPAV2 Total
005921 | PLANNED | Work Complete | CIVILWGL | 2016-05-20 00:00:00 | COMP | Property | BeachOut - 171 Esplanade BRIGHTON  SA  5 | Active | DEPGENAS | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 10:40:14 | 10:40:15 | OP.WORKS | 005921 | 005921 | A | W | P1
 |  |  |  |  |  |  |  |  | DEPGENAS Total
002807 | PLANNED | Work Complete | CIVILWGL | 2016-01-19 00:00:00 | COMP | Property | RM16/00622 - Defect Inspection of Asset | Active | FOOTPASS | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | 13:45:22 | 14:33:33 | OP.WORKS | 002807 | 002807 | A | W | P1
 |  |  |  |  |  |  |  |  | FOOTPASS Total
003999 | PLANNED | Work Complete | CIVILWGL | 2016-03-02 00:00:00 | COMP | Property | RM16/01565 - Pot Hole Repairs | Active | ROADASS | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | [NAME] | 11:11:15 | OP.WORKS | 003999 | 003999 | A | W | P1
 |  |  |  |  |  |  |  |  | ROADASS Total
 |  |  |  |  |  | Property Total
005302 | UNPLANNED | Work Complete | CIVILWGL | 2016-04-26 00:00:00 | COMP | Work System | Drinking Fountain - Install Slab | Active | DEPGENAS | 2016-05-18 00:00:00 | 2016-05-19 00:00:00 | 07:20:48 | 11:20:57 | OP.WORKS | 005302 | 005302 | A | W | WS
005805 | ROUTINE | Work Complete | CIVILWGL | 2016-05-17 00:00:00 | COMP | Work System | Wattle Reserve - install BBQ | Active | DEPGENAS | 2016-05-17 00:00:00 | 2016-05-17 00:00:00 | 08:20:47 | 10:42:10 | OP.WORKS | 005805 | 005805 | A | W | WS
 |  |  |  |  |  |  |  |  | DEPGENAS Total
 |  |  |  |  |  | Work System Total
 |  |  | CIVILWGL Total
 |  | Work Complete Total
 |  | Grand Total