Spreadsheet: 820739d1678276674-complex-formula-lost-planning-sheet-test
Sheet: Data Sheet

Stage | Work Type | Area | Road Type | Surface Type | TM | Interim/Perm | [NAME] | Fail Countability | Region |  | [NAME] |  | Bands |  | Error Codes |  |  | Stage & Status |  |  | Dig Team |  | Occupying the CW |  |  |  | adjust for W/E working |  | CW Type | Traffic Sensitive |  | Potential 1 Day Overrun Charge |  |  |  |  |  |  |  |  |  |  |  | BH
Backfill | Method A | Central | [NAME] | 6mm Bit Mac | Stop & Go | Interim | 3rd Party Tier 2 | STW | Central | West | [NAME] | 0.35 |  | Band 1 | 1 | no stop date for completed job |  | TO BE DELETED | Unplanned |  | NW+ |  | Stop & Go | Yes |  |  | y |  | Type 1 | TS |  | Yes,Type 1,TS | £5,000 |  | 100 | 1 |  |  |  |  |  |  |  | 2021-01-26 00:00:00
Rein | Method B | Derbys | [NAME] | 10mm Bit Mac | 2 Way - 3rd Party | Perm | Access Issues | NW+ | Wo/Glo | West | [NAME] | 0.32 | 0 | Band 1 | 2 | site code must be > 0 |  | COMPLETED | Completed |  | STW |  | 2 Way - 3rd Party | Yes |  |  |  |  | Type 2 | NTS |  | Yes,Type 2,TS | £3,000 |  | 121 | 2 |  |  |  |  |  |  |  | 2021-01-27 00:00:00
Barriers | Int-Perm | Wo/Glo | CWT2 | HRA 55/10 | 2 Way - Depot |  | [NAME] |  | Derbys | East | CWT2 | 0.285 | 1.21 | Band 2 | 3 | no pareto reason for completed job |  | WAITING INSPECTION | Unplanned |  |  |  | 2 Way - Depot | Yes |  |  |  |  | Type 3 |  |  | Yes,Type 3,TS | £750 |  | 200 | 1
Awaiting TM offhire | Section 81 | Notts | CWT3 | HRA 30/14 | 3 Way |  | Adverse Weather |  | Notts | East | CWT3 | 0.1 | 2.01 | Band 3 | 4 | band change |  | WAITING JOB BUILD | Unplanned |  |  |  | 3 Way | Yes |  |  |  |  | Type 3 |  |  | Yes,Type 4,TS | £750 |  | 221 | 2
Completed | Fire Service | Shrops | CWT4 | HRA 45/6 | 4 Way |  | Con Damage on Site |  |  |  | CWT4 | 0.1 | 4.01 | Band 4 | 5 | collected after promotion date |  | ON HOLD | Unplanned |  |  |  | 4 Way | Yes |  |  |  |  | Type 4 |  |  | Yes,Type 1,NTS | £2,500 |  | 300 | 1
SDR | Con Damage | Staffs | [NAME] | SMA 10mm | 5 Way |  | Damaged Assets |  |  |  | [NAME] |  |  |  | 6 | no pareto reason for fail |  | PLANNED | Planned |  |  |  | 5 Way | Yes |  |  |  |  |  |  |  | Yes,Type 2,NTS | £2,000 |  | 321 | 2
SDR Cancelled | HA Defect |  | FW | SMA 14mm | [NAME] |  | DG3/Prioirty Works |  |  |  | FW | 0.06 |  |  |  |  |  | PLANNED NTC | Planned |  |  |  | [NAME] | Yes |  |  |  |  |  |  |  | Yes,Type 3,NTS | £250 |  | 400 | 1
Long Comm BF | Internal Defect |  | Verge | Block Paving | Road Closure |  | Gang Holiday |  |  |  | Verge | 0.04 |  |  |  |  |  | WAITING PLANNING | Unplanned |  |  |  | Road Closure | Yes |  |  |  |  |  |  |  | Yes,Type 4,NTS | £250 |  | 421 | 4
Long Comm RS | Core Failure |  | Cycleway | Blue Bricks | [NAME] |  | [NAME] |  |  |  | Cycleway | 0.06 |  |  |  |  |  | [NAME] | Planned |  |  |  | [NAME] | Yes |  |  |  |  |  |  |  | No,Type 1,TS | £2,500 |  | 500 | 3
Long Comm Parked | Cust Complaint |  | Bridleway | Concrete | SCWI |  | [NAME] |  |  |  | Bridleway | 0.06 |  |  |  |  |  | RETURN TO STW | Unplanned |  |  |  | SCWI | Yes |  |  |  |  |  |  |  | No,Type 1,NTS | £2,500 |  | 521 | 4
Hold Backfill |  |  | Ped Zone | Flags | NCWI |  | Location Constraint |  |  |  | Ped Zone | 0.06 |  |  |  |  |  | PERMIT MOD SENT | Planned |  |  |  | NCWI | No |  |  |  |  |  |  |  | No,Type 2,TS | £2,000 |  | 600 | 3
Hold Rein |  |  | Private FW | Stone Sets | Give/Take |  | Material Constriants |  |  |  | Private FW | 0.06 |  |  |  |  |  | REFUSED | Planned |  |  |  | Give/Take | Yes |  |  |  |  |  |  |  | No,Type 2,NTS | £2,000 |  | 621 | 3
Hold Barriers |  |  | Private CW | Tactile | Priority Working |  | Not Safe |  |  |  | Private CW | 0.1 |  |  |  |  |  | REJECTED | Unplanned |  |  |  | Priority Working | Yes |  |  |  |  |  |  |  | No,Type 3,TS | £250 |  | 700 | 2
[NAME] |  |  | Private GV | York Paving |  |  | Operational Issues - Dig |  |  |  | Private GV | 0.04 |  |  |  |  |  | MATERIALS REQ ORDERING | Unplanned |  |  |  |  |  |  |  |  |  |  |  |  | No,Type 3,NTS | £250 |  | 721 | 2
Abort RS | Work Type BOPPS |  |  | Grass |  |  | Operational Issues - Rein |  |  |  |  |  |  |  |  |  |  | REQ FULL CHAMBER DIG OUT | Unplanned |  |  |  |  |  |  |  |  |  |  |  |  | No,Type 4,TS | £250
Future Works | BOPPS |  |  | Unmade |  |  | Poor Promotion |  |  |  |  |  |  |  |  |  |  | TM | Completed |  |  |  |  |  |  |  |  |  |  |  |  | No,Type 4,NTS | £250
Adhoc |  |  |  | Red Tarmac |  |  | Still Leaking/Further Burst
[NAME] |  |  |  |  |  |  | System Issue
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Plant Breakdown
 |  |  |  |  |  |  | Rein Scheduling
STW
NW+