AssetTracker

Problem

To provide a method of mapping and attributing newly installed ‘critical assets’ with the functionality to perform a ‘readiness of energisation assessment’ for each electrical section.

Solution

Asset Tracker is a tool based on existing project trackers and is an example of how upgrading existing project tools/tracker is more economical and viable than deploying a new product. An assessment of existing project data/spreadsheets identified that an existing Excel project tracker formed the graphical/schematic backdrop for. In addition, Excel was a platform all users in the project had access to.

 

To guarantee consistency of data the asset data was hosted on a web server which synchronized with Excel. Excel represented the assets in the applicable cells. This provided live real time data for all users and provided the future flexibility of mobile app/remote access.

 

Each asset was assigned to electrical section(s) and a status of ‘installed’ or ‘not installed’. Only when all assets assigned to a specific electrical section are classed as ‘installed’ then the applicable electrical section will be identified as ‘ready for energisation’. Hyperlinks to the evidence of the installed asset (Inspection and Test Plan provided by EviFile) was also provided.

 

This allowed the construction team to focus on non-installed or unverified assets for to ensure the OLE system is complete for energisation.

Benefits
  • Provided evidence to Network Rail the all critical assets were installed in readiness for energisation
     

  • 2000 critical assets uploaded, assessed and evidenced. Single source of truth
     

  • Asset Tracker Identified critical assets which required installation/verification to allow energisation
     

  • Simple Excel schematic/graphical output, a platform familiar with most users
     

  • Easily deployed with multiple users from different suppliers using the tools simultaneously
     

  • Web hosting allowed real time assessments of assets via web API’s.

Asset Tracker Data

ID
Type
Last Update By
WR 1 ID
WR 2 ID
WR 3 ID
ES 1 ID
ES 2 ID
ES 3 ID
Status
BRC-93
BRC
GOYS9622
B01-03
B01-04
Not Set
638D
637C
Installed
BRC-92
BRC
GOYS9622
B01-01
B01-02
Not Set
640A
639C
Installed
BRC-91
BRC
GOYS9622
B01-01
B01-02
Not Set
640A
639C
Installed
BRC-90
BRC
GOYS9622
B01-01
B01-02
Not Set
640A
639C
Installed
BRC-89
BRC
GOYS9622
B01-01
B01-02
Not Set
640A
639C
Installed
BRC-88
BRC
GOYS9622
B17-01
B17-02
Not Set
644B
643A
Installed
BRC-87
BRC
GOYS9622
B17-01
B17-02
Not Set
644B
643A
Installed
BRC-86
BRC
GOYS9622
B15-01
B15-02
Not Set
644B
643A
Installed
BRC-85
BRC
GOYS9622
B13-01
B13-02
Not Set
644B
643A
Installed
IEW-86
IEW
GOYS9622
B13-01
Not Set
Not Set
644B
Installed
BRC-84
BRC
GOYS9622
B03-01
Not Set
Not Set
640B
Installed
IEW-85
IEW
GOYS9622
B02-01
Not Set
Not Set
640B
Installed
BRC-83
BRC
GOYS9622
B03-01
B03-02
Not Set
640B
639B
Installed
IEW-84
IEW
GOYS9622
B02-01
Not Set
Not Set
640B
Installed
BRC-82
BRC
GOYS9622
B23-01
B23-02
Not Set
644B
643A
Installed
IEW-83
IEW
GOYS9622
B23-01
Not Set
Not Set
644B
Installed
BRC-81
BRC
GOYS9622
B23-01
B23-02
Not Set
643A
644B
Installed
JMP-516
JMP
GOYS9622
B17-02
B19-02
Not Set
643A
Installed
JMP-515
JMP
GOYS9622
B17-02
B19-02
Not Set
643A
Installed
JMP-514
JMP
GOYS9622
B17-01
B19-01
Not Set
644B
Installed
JMP-513
JMP
GOYS9622
B21-01
B21-03
Not Set
644B
648A
Installed
JMP-512
JMP
GOYS9622
B21-01
B23-01
Not Set
648A
Installed
JMP-511
JMP
GOYS9622
B21-02
B23-02
Not Set
643A
Installed
JMP-510
JMP
GOYS9622
B22-03
B20-03
Not Set
646A
Installed
JMP-509
JMP
GOYS9622
B03-04
B04-04
Not Set
637B
Installed
JMP-508
JMP
GOYS9622
B03-02
B04-02
Not Set
639B
Installed
JMP-507
JMP
GOYS9622
B03-01
B04-01
Not Set
640B
Installed
JMP-506
JMP
GOYS9622
B03-01
B04-01
Not Set
640B
Installed
ESE-1
ESE
GOYS9622
B11-04
Not Set
Not Set
641B
Installed
RFU-1
RFU
GOYS9622
B11-04
Not Set
Not Set
641B
Installed
FCO-4
FCO
GOYS9622
B22-01
Not Set
Not Set
646A
Installed
FCO-3
FCO
GOYS9622
B22-02
Not Set
Not Set
645C
Installed
FCO-2
FCO
GOYS9622
B23-04
Not Set
Not Set
647C
Installed
FCO-1
FCO
GOYS9622
B23-03
Not Set
Not Set
648A
Installed
JMP-505
JMP
GOYS9622
B04-08
B05-01
Not Set
637A
Installed
JMP-504
JMP
GOYS9622
B04-08
B05-04
Not Set
637A
Installed
BRC-80
BRC
GOYS9622
B05-03
B05-04
Not Set
638F
637A
Installed
BRC-79
BRC
GOYS9622
B05-03
B05-04
Not Set
638F
637A
Installed
SGC-368
SGC
GOYS9622
B05-04
Not Set
Not Set
637A
Installed
IEW-82
IEW
GOYS9622
B05-04
Not Set
Not Set
637A
Installed
JMP-503
JMP
GOYS9622
B05-04
B06-04
Not Set
637A
Installed
JMP-502
JMP
GOYS9622
B06-04
B07-04
Not Set
637A
Installed
JMP-501
JMP
GOYS9622
B07-04
B08-04
Not Set
637A
Installed
JMP-500
JMP
GOYS9622
B08-04
B09-04
Not Set
637A
Installed
JMP-499
JMP
GOYS9622
B09-04
B10-04
Not Set
637A
Installed
PES-12
PES
GOYS9622
B23-02
Not Set
Not Set
643A
Installed
PES-11
PES
GOYS9622
B23-01
Not Set
Not Set
644B
Installed
PES-10
PES
GOYS9622
B23-02
Not Set
Not Set
643A
Installed
PES-9
PES
GOYS9622
B23-02
Not Set
Not Set
644B
Installed
PES-8
PES
GOYS9622
B23-01
Not Set
Not Set
644B
Installed
PES-7
PES
GOYS9622
B23-01
Not Set
Not Set
644B
Installed
PES-6
PES
GOYS9622
B23-03
Not Set
Not Set
647C
Installed
PES-5
PES
GOYS9622
B23-03
Not Set
Not Set
647C
Installed
PES-4
PES
GOYS9622
B23-04
Not Set
Not Set
647C
Installed
PES-3
PES
GOYS9622
B23-04
Not Set
Not Set
647C
Installed
PES-2
PES
GOYS9622
B23-03
Not Set
Not Set
648A
Installed
PES-1
PES
GOYS9622
B23-03
Not Set
Not Set
648A
Installed
JMP-498
JMP
GOYS9622
B03-03
B04-03
Not Set
638E
Installed
JMP-497
JMP
GOYS9622
B03-03
B04-03
Not Set
638E
Installed
IEW-81
IEW
GOYS9622
B24-02
Not Set
Not Set
645C
Installed
IEW-80
IEW
GOYS9622
B35-01
Not Set
Not Set
652A
Installed
JMP-496
JMP
GOYS9622
B01-04
Not Set
Not Set
638D
Installed
CUI-776
CUI
GOYS9622
B01-02
Not Set
Not Set
639C
Installed
JMP-495
JMP
GOYS9622
B01-02
Not Set
Not Set
639C
Installed
JMP-494
JMP
GOYS9622
B01-02
Not Set
Not Set
639C
Installed
CUI-775
CUI
GOYS9622
B01-02
Not Set
Not Set
639C
Installed
CUI-774
CUI
GOYS9622
B01-01
Not Set
Not Set
640A
Installed
JMP-493
JMP
GOYS9622
B01-01
Not Set
Not Set
640A
Installed
JMP-492
JMP
GOYS9622
B01-01
Not Set
Not Set
640A
Installed
CUI-773
CUI
GOYS9622
B01-01
Not Set
Not Set
640A
Installed
SGC-WH475
SGC
GOYS9622
WR28A-01
Not Set
Not Set
637B
Installed
SGC-WH347
SGC
GOYS9622
WR28-01
Not Set
Not Set
637D
Installed
SGC-WG477
SGC
GOYS9622
B01-05
Not Set
Not Set
638D
Installed
SGC-KM3973
SGC
GOYS9622
C07-02
Not Set
Not Set
653A
Installed
CUI-772
CUI
GOYS9622
C07-02
Not Set
Not Set
653A
Installed
CUI-771
CUI
GOYS9622
C07-01
Not Set
Not Set
654A
Installed
SGC-KM3959
SGC
GOYS9622
C06-01
Not Set
Not Set
654A
Installed
CUI-770
CUI
GOYS9622
B32-06
Not Set
Not Set
646B
Installed
CUI-769
CUI
GOYS9622
B33-04
Not Set
Not Set
646B
Installed
JMP-491
JMP
GOYS9622
B33-09
Not Set
Not Set
646C
Installed
CUI-768
CUI
GOYS9622
B33-09
Not Set
Not Set
646B
Installed
CUI-767
CUI
GOYS9622
B40-06
Not Set
Not Set
649B
Installed
JMP-490
JMP
GOYS9622
B40-04
B40-06
Not Set
649B
Installed
SIN-44
SIN
GOYS9622
B40-06
Not Set
Not Set
650B
649B
Installed
JMP-489
JMP
GOYS9622
B40-06
B40-03
Not Set
650B
Installed
CUI-766
CUI
GOYS9622
B40-06
Not Set
Not Set
650B
Installed
CUI-765
CUI
GOYS9622
B40-05
Not Set
Not Set
650B
Installed
JMP-488
JMP
GOYS9622
B40-03
B40-05
Not Set
650B
Installed
SIN-43
SIN
GOYS9622
Not Set
Not Set
Not Set
650B
649B
Installed
JMP-487
JMP
GOYS9622
B40-04
B40-05
Not Set
649B
Installed
CUI-764
CUI
GOYS9622
B40-05
Not Set
Not Set
649B
Installed
CUI-763
CUI
GOYS9622
B40-05
Not Set
Not Set
649B
Installed
CUI-762
CUI
GOYS9622
B39-04
Not Set
Not Set
649B
Installed
JMP-486
JMP
GOYS9622
B39-04
B40-04
Not Set
649B
Installed
CUI-761
CUI
GOYS9622
B40-04
Not Set
Not Set
649B
Installed
CUI-760
CUI
GOYS9622
B39-03
Not Set
Not Set
650B
Installed
JMP-485
JMP
GOYS9622
B39-03
B40-03
Not Set
650B
Installed
JMP-484
JMP
GOYS9622
B40-03
B39-03
Not Set
650B
Installed
JMP-483
JMP
GOYS9622
B39-04
B40-04
Not Set
649B
Installed
CUI-759
CUI
GOYS9622
B40-03
Not Set
Not Set
650B
Installed
CUI-758
CUI
GOYS9622
B39-02
Not Set
Not Set
651B
Installed
JMP-482
JMP
GOYS9622
B39-02
B40-02
Not Set
651B
Installed
JMP-481
JMP
GOYS9622
B40-02
B39-02
Not Set
651B
Installed
CUI-757
CUI
GOYS9622
B40-02
Not Set
Not Set
651B
Installed
CUI-756
CUI
GOYS9622
B39-01
Not Set
Not Set
652B
Installed
JMP-480
JMP
GOYS9622
B39-01
B40-01
Not Set
652B
Installed
JMP-479
JMP
GOYS9622
B40-01
B39-01
Not Set
652B
Installed
CUI-755
CUI
GOYS9622
B40-01
Not Set
Not Set
652B
Installed
JMP-478
JMP
GOYS9622
B39-04
B38-04
Not Set
649B
Installed
CUI-754
CUI
GOYS9622
B38-04
Not Set
Not Set
649B
Installed
JMP-477
JMP
GOYS9622
B39-04
B38-04
Not Set
649B
Installed
CUI-750
CUI
GOYS9622
B38-03
Not Set
Not Set
650B
Installed
JMP-476
JMP
GOYS9622
B38-02
B39-03
Not Set
650B
Installed
JMP-475
JMP
GOYS9622
B38-03
B39-03
Not Set
650B
Installed
CUI-747
CUI
GOYS9622
B38-02
Not Set
Not Set
651C
Installed
JMP-474
JMP
GOYS9622
B39-02
B38-02
Not Set
651C
Installed
CUI-746
CUI
GOYS9622
B38-02
Not Set
Not Set
651C
Installed
CUI-745
CUI
GOYS9622
B39-02
Not Set
Not Set
651B
Installed
JMP-473
JMP
GOYS9622
B38-02
B39-02
Not Set
651B
Installed
JMP-472
JMP
GOYS9622
B38-01
B39-01
Not Set
652B
Installed
CUI-744
CUI
GOYS9622
B38-01
Not Set
Not Set
652A
Installed
CUI-743
CUI
GOYS9622
B38-01
Not Set
Not Set
652A
Installed
CUI-742
CUI
GOYS9622
B39-01
Not Set
Not Set
652B
Installed
JMP-471
JMP
GOYS9622
B38-01
B39-01
Not Set
652B
Installed
CUI-741
CUI
GOYS9622
B39-04
Not Set
Not Set
649B
Installed
CUI-740
CUI
GOYS9622
B39-03
Not Set
Not Set
650B
Installed
CUI-739
CUI
GOYS9622
B39-02
Not Set
Not Set
651B
Installed
CUI-738
CUI
GOYS9622
B39-01
Not Set
Not Set
652B
Installed
SIN-42
SIN
GOYS9622
C07-04
Not Set
Not Set
653A
653B
Installed
SIN-41
SIN
GOYS9622
C07-03
Not Set
Not Set
654A
653A
Installed
CUI-735
CUI
GOYS9622
K03-03
Not Set
Not Set
650C
Installed
CUI-735
CUI
GOYS9622
K03-03
Not Set
Not Set
650C
Installed
CUI-737
CUI
GOYS9622
K03-04
Not Set
Not Set
649A
Installed
CUI-736
CUI
GOYS9622
C01-02
Not Set
Not Set
653A
Installed
CUI-734
CUI
GOYS9622
C01-01
Not Set
Not Set
654A
Installed
CUI-733
CUI
GOYS9622
K03-03
Not Set
Not Set
650C
Installed
JMP-470
JMP
GOYS9622
K03-05
K03-03
Not Set
650C
Installed
SIN-40
SIN
GOYS9622
K03-05
Not Set
Not Set
650C
649A
Installed
JMP-469
JMP
GOYS9622
K03-05
K03-03
Not Set
649A
Installed
CUI-732
CUI
GOYS9622
K03-05
Not Set
Not Set
649A
Installed
CUI-731
CUI
GOYS9622
K02-02
Not Set
Not Set
649A
Installed
CUI-730
CUI
GOYS9622
K03-02
Not Set
Not Set
649A
Installed
CUI-729
CUI
GOYS9622
K02-01
Not Set
Not Set
650C
Installed
CUI-728
CUI
GOYS9622
K03-01
Not Set
Not Set
650C
Installed
CUI-727
CUI
GOYS9622
K01-02
Not Set
Not Set
649A
Installed
CUI-726
CUI
GOYS9622
K01-01
Not Set
Not Set
650C
Installed
CUI-725
CUI
GOYS9622
K02-02
Not Set
Not Set
649A
Installed
CUI-724
CUI
GOYS9622
Not Set
Not Set
Not Set
650C
Installed
CUI-723
CUI
GOYS9622
K01-02
Not Set
Not Set
649A
Installed
CUI-722
CUI
GOYS9622
K01-02
Not Set
Not Set
649A
Installed
CUI-721
CUI
GOYS9622
B40-03
Not Set
Not Set
650B
Installed
CUI-720
CUI
GOYS9622
K01-01
Not Set
Not Set
650C
Installed
CUI-719
CUI
GOYS9622
B38-07
Not Set
Not Set
649B
Installed
JMP-468
JMP
GOYS9622
B38-07
B38-04
Not Set
649B
Installed
SIN-39
SIN
GOYS9622
B38-07
Not Set
Not Set
650B
649B
Installed
JMP-467
JMP
GOYS9622
B38-07
Not Set
Not Set
650B
Installed
CUI-718
CUI
GOYS9622
B38-07
Not Set
Not Set
649B
650B
Installed
JMP-466
JMP
GOYS9622
B38-07
B38-04
Not Set
649B
Installed
CUI-717
CUI
GOYS9622
B38-07
Not Set
Not Set
649B
Installed
CUI-716
CUI
GOYS9622
B38-06
Not Set
Not Set
650B
Installed
JMP-465
JMP
GOYS9622
B38-03
B38-06
Not Set
650B
Installed
JMP-464
JMP
GOYS9622
B38-01
B38-05
Not Set
652A
Installed
SIN-38
SIN
GOYS9622
B38-06
Not Set
Not Set
651C
650B
Installed
JMP-463
JMP
GOYS9622
B38-02
B38-06
Not Set
651C
Installed
CUI-715
CUI
GOYS9622
B38-06
Not Set
Not Set
651C
Installed
CUI-714
CUI
GOYS9622
B38-05
Not Set
Not Set
652A
Installed
CUI-713
CUI
GOYS9622
B38-05
Not Set
Not Set
651C
652A
Installed
JMP-462
JMP
GOYS9622
B38-05
B38-02
Not Set
651C
Installed
SIN-37
SIN
GOYS9622
B38-05
Not Set
Not Set
652A
651C
Installed
JMP-461
JMP
GOYS9622
B38-01
B38-05
Not Set
652A
Installed
CUI-712
CUI
GOYS9622
B38-05
Not Set
Not Set
652A
Installed
CUI-711
CUI
GOYS9622
B37-04
Not Set
Not Set
649C
Installed
JMP-460
JMP
GOYS9622
B37-04
Not Set
Not Set
649C
Installed
CUI-710
CUI
GOYS9622
B37-04
Not Set
Not Set
649C
Installed
CUI-709
CUI
GOYS9622
B38-04
Not Set
Not Set
649B
Installed
JMP-459
JMP
GOYS9622
B37-04
B38-04
Not Set
649B
Installed
CUI-708
CUI
GOYS9622
B37-03
Not Set
Not Set
650A
Installed
JMP-458
JMP
GOYS9622
B37-03
B38-03
Not Set
650B
Installed
CUI-707
CUI
GOYS9622
B37-03
Not Set
Not Set
650A
Installed
CUI-706
CUI
GOYS9622
B38-03
Not Set
Not Set
650B
Installed
JMP-457
JMP
GOYS9622
B37-03
B38-03
Not Set
650B
Installed
CUI-705
CUI
GOYS9622
B37-02
Not Set
Not Set
651C
Installed
JMP-456
JMP
GOYS9622
B37-02
B38-02
Not Set
651C
Installed
JMP-455
JMP
GOYS9622
B37-02
B38-02
Not Set
651C
Installed
CUI-704
CUI
GOYS9622
B37-01
Not Set
Not Set
652A
Installed
JMP-454
JMP
GOYS9622
B37-01
B38-01
Not Set
652A
Installed
JMP-453
JMP
GOYS9622
B38-01
B37-01
Not Set
652A
Installed
CUI-703
CUI
GOYS9622
B38-04
Not Set
Not Set
649B
Installed
CUI-702
CUI
GOYS9622
B38-03
Not Set
Not Set
650B
Installed
CUI-701
CUI
GOYS9622
B37-02
Not Set
Not Set
651C
Installed
CUI-700
CUI
GOYS9622
B37-01
Not Set
Not Set
652A
Installed
CUI-699
CUI
GOYS9622
B36-04
Not Set
Not Set
649C
Installed
JMP-452
JMP
GOYS9622
B36-04
B37-04
Not Set
649C
Installed
JMP-451
JMP
GOYS9622
B37-04
B36-04
Not Set
649C
Installed
CUI-698
CUI
GOYS9622
B36-03
Not Set
Not Set
650A
Installed
JMP-450
JMP
GOYS9622
B37-03
B36-03
Not Set
650A
Installed
JMP-449
JMP
GOYS9622
B36-03
B37-03
Not Set
650A
Installed
CUI-697
CUI
GOYS9622
B36-02
Not Set
Not Set
651C
Installed
JMP-448
JMP
GOYS9622
B36-02
B37-02
Not Set
651C
Installed
JMP-447
JMP
GOYS9622
B37-01
B36-01
Not Set
652A
Installed