Spreadsheet: 454939d1460038904-if-word-appears-in-column-b-within-date-range-in-column-q-test
Sheet: BM Tracker

Site | Status | Postcode | Actions | Access comments | Special Delivery/Problem | Survey required | sent to RT | Received from RT | WO ID | Task No. | Remedy INC | ANOC Closure Code | Shields Order Date | Site Survey | Reason for Survey | Team | Planned/Actual Completion | Survey | Aborted | Aborted 2 | Battery type | Quantity | Fault Report | Comments
3084 | Active | GU151SP | Shields | require surry Police vetting |  |  |  |  | 45586888 | tas000000888467 |  |  | 2015-05-31 00:00:00 |  |  |  |  |  |  |  | 12V62F | 8 | NONE | 0
394 | Complete | NW87HS |  | Hotel Danubius |  |  |  |  | 49401774 | 1066894 |  |  | 2015-10-08 00:00:00 |  |  |  |  |  |  |  | 12V170F | 24 | Replace stolen batts in Delta PSUs
10916 | Active | BT22 1NB |  | Arqiva |  |  |  |  |  |  | INC000001858930 |  | 2015-11-23 00:00:00 |  |  |  |  |  |  |  | 12V62F | 8
4402 | Complete | PE68SD |  |  |  |  |  |  | 58610647 | 1503811 | INC000001982759 |  | 2016-01-25 00:00:00 |  |  | Newts & Morris | 07.03.16 |  |  |  | 12V62F | 4 |  | 12x62f installed
5377 | Active | CF623BD |  | require airport clearance |  |  |  |  | 58698649 | 1504585 | INC000001985090 |  | 2016-01-25 00:00:00 |  |  |  |  |  |  |  | 12V62F | 4
17076 | aborted | EX348NW | CTIL | 24hr key broken in lock on attendance |  |  |  |  | 59536882 |  |  |  | 2016-02-24 00:00:00 |  |  | Newts & Morris |  |  | 2016-03-15 00:00:00 |  | 12V30F | 4 | The batteries are old and not holding charge-This is a Ericsson 2103 BTS
37155 | aborted | MK439LN | VF | streetworks |  |  |  |  | 58290955 |  |  |  | 2016-02-25 00:00:00 |  |  | Newts & Morris |  |  | 2016-03-07 00:00:00 |  | 170a link bars only | 2 | Batteries sent are correct but unable to install as there are no copper Link bars x2 with the cab to give 2 sets of 24v across 4 batteries. Batteries have been placed in cab but not connected . | site been beaconised no longer required when returning.
734 | Complete | ML119QA |  |  |  |  |  |  | 57645401 |  |  |  | 2016-03-01 00:00:00 |  |  | [NAME] | 2016-03-09 00:00:00 |  |  |  | 12V170F | 28 | Delta 48v batteries missing, stollen | installed 28x 170a batts into Delta PSUs. TOK all alarms cleared.
10199 | Complete | TN162EH |  |  |  |  |  |  | 58804368 |  |  |  | 2016-03-01 00:00:00 |  |  |  | 2016-03-03 00:00:00 |  |  |  | 4 X 12V170FS ACCESSORY KIT | 2 | fixing kits only
60536 | aborted | SP12SR | VF |  |  |  |  |  | 59619309 |  |  |  | 2016-03-01 00:00:00 |  |  | Newts & Morris |  |  | 2016-03-08 00:00:00 |  | 12V30F | 1 | Batteries are leaking, corroded. | incorrect batteries ordered
10831 | Active | PA318QA |  | ATV require approval | specialist delivery/ATV |  |  |  | 59536882 |  |  |  | 2016-02-25 00:00:00 |  |  |  |  |  |  |  | SBS60 | 12 | All the batteries are split or blown. All need replaced
40633 | Complete | OX145TJ |  | require site specific RAMS required |  |  |  |  | 58915218 | 1520501 | INC000001995289 |  | 2016-01-27 00:00:00 |  |  | [NAME] | 2016-03-17 00:00:00 |  |  |  | 12V62F | 4 |  | replaced batts in3g cab
439 | Active | SW6 2BN |  |  |  |  |  |  | 55310260 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V170F | 4 | String 4 batteries range from 12v to 15v there was a power outage late 2015 for some reason the 3 other string came back in norm voltages but 4th string mid point is way off
6130 | Active | BT324LD |  |  |  |  |  |  | 59774179 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V62F | 4 | batteries are split
6736 | Complete | RG61JU |  |  |  |  |  |  | 57775924 |  |  |  | 2016-03-10 00:00:00 |  |  | Newts & Morris | 2016-03-17 00:00:00 |  |  |  | 12V170F | 24 | Batteries were stolen. | 24x12v170ah installed alarms cleared cc in app
3045 | Active | B322LX |  |  |  |  |  |  | 59967858 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V170F | 16 | no batteries fitted
85239 | Active | RG73QE |  | orange abloy key required |  |  |  |  | 60633397 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V170F | 16 | Batteries have been stolen
46649 | Active | SL68TR |  |  |  |  |  |  | 60814484 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V30F | 4 | Batteries have low voltage
35862 | Active | [NAME] |  |  |  |  |  |  | 60749731 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V30F | 4 | Batteries are split and leaking
5798 | Active | NN72BX |  |  |  |  |  |  | 60853720 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V30F | 4 | Batteries are split and leaking
6152 | Active | BT474SB |  |  |  |  |  |  | 59777792 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V30F | 4 | Batteries are split but not leaking
22356 | Complete | OX201HJ |  |  |  |  |  |  | 59944116 |  |  |  | 2016-03-10 00:00:00 |  |  | [NAME] | 2016-03-17 00:00:00 |  |  |  | 12V30F | 4 | Batteries are failing charge test | replaced 4x 62s with 30s in PSC1000 as this is what VF have ordered.
21001 | Active | YO74DE |  |  |  |  |  |  | 60437689 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V30F | 4 | Batteries are failing charge test
35160 | Active | NE137BA |  |  |  |  |  |  | 60564283 |  |  |  | 2016-03-10 00:00:00 |  |  |  |  |  |  |  | 12V30F | 4 | Batteries are split, these are dry cell batteries, white phosphorous visible
45114 | Active | [NAME] |  | SW cab |  |  |  |  | 59556916 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V92F | 12 | Stolen batteries
65171 | Active | G613RP |  | SW cab |  |  |  |  | 60284759 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V92F | 4 | Batteries are not holding charge
5789 | Active | NN100SA |  | WIG | Track barrow |  |  |  | 59737025 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V92F | 8 | One battery corroded and the others won't hold charge
77749 | Active | E145GL |  | KPMG, notice required |  |  |  |  | 60598471 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V92F | 8 | Batteries are not charging, also visible damage like white phosphorous
78604 | Active | E14UJ |  | Survey necessary, see access notes on POWTRAC |  | Yes |  |  | 61155414 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V92F | 4 | Batteries missing
6236 | Active | PA345XD |  | 4x4 & TB | Track barrow |  |  |  | 61133888 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | SBS60 | 12 | Batteries failing conductance testing and require replacing
6265 | Active | IV568FY |  | ATV |  |  |  |  | 59497799 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | SBS60 | 12 | All 3 strings have failed causing rectifiers to high volts disconn so currently no backup at site
5378 | Active | DH87LQ |  | CellCM |  |  |  |  | 61374091 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V92F | 4 | All batteries failing conductance test
96610 | Active | TW167EY |  | Temp site |  |  |  |  | 61358482 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Low voltage on batteries
8432 | Active | CF838QD |  | 4WD |  |  |  |  | 61769541 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | 2 x Hawker energy batteries have split within the [NAME]
72530 | Active | SA732HJ |  |  |  |  |  |  | 59144732 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries are split
38079 | Active | CO109PE |  | WIG | Savills escorted access |  |  |  | 61229284 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | The batteries are Northstar 100FT, they are split and leaking and need to be replaced
85864 | Active | RH136BY |  | Reservoir | Arqiva? |  |  |  | 61769353 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Low voltage on whole string of batteries
37848 | Active | ML117SF |  | 4WD |  |  |  |  | 61835617 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries are failing and showing evidence of damage
36589 | Active | SA311BH |  | BT Tower |  |  |  |  | 61883768 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries show low/no voltage. PSU = [NAME]
36614 | Active | CF402JB |  | Arqiva |  |  |  |  | 61658423 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries are failing. PSU = [NAME]
4016 | Active | TR147LH |  | Veterinary surgery |  |  |  |  | 61769731 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries low voltage. RBS2106 & 3103 keys.
334 | Active | BT356JP |  | NI [NAME] |  |  |  |  | 62250121 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 8 | Replace 16x6v batts in H&S PSU
6891 | Active | CV93ER |  | 4WD | 48h notice, water tower |  |  |  | 62176648 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Site has a symmetry fault, batteries failing
11579 | Active | DE552ED |  | 4WD |  |  |  |  | 62417535 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries faulty no power. PSU = Delta XL48
30742 | Active | LS29EA |  | [NAME] |  |  |  |  | 59460467 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 16 | Batteries are split. PSU = Delta
4395 | Active | B781HD |  | East mids elec |  |  |  |  | 58804368 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries are old and don't hold charge, not split or leaking. PSU = Powec
21000 | Active | YO737BW |  | 4WD |  |  |  |  | 59707053 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Batteries are split and leaking. PSU = RBS2106
1289 | Active | CB97UD |  | WIG |  |  |  |  | 59405701 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | Split and leaking. H&S PSU
1141 | Active | [NAME] |  | 24h access, car park |  |  |  |  | 59747513 |  |  |  | 2016-04-05 00:00:00 |  |  |  |  |  |  |  | 12V62F BATTERY | 4 | All batteries failing conductance test