top of page
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 | ||
bottom of page