{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Schedule B","Schedule C"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Schedule B","index":0,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Level","Item","Bill description","Unit","Rate (£)"]
[1,"4.4","1200 - Traffic Signs and Road Markings",""]
[1,"4.5","Lighting",""]
["c","","SWITCHED Lamps (PL-L, PL-S, SOX)",""]
[null,"4.5.1","Bulk lamp clean and change","no."]
["c","","UNSWITCHED Lamps (PL-L, PL-S, SOX)",""]
[null,"4.5.2","Bulk lamp clean and change","no."]
["c","","SWITCHED lamps (CDM-T, CDO, SON/T, CPO, MCF/U, MBF/U)",""]
[null,"4.5.3","Bulk lamp clean and change","no."]
["c","","Unswitched Lamps (CDM-T, CDO, SON/T, CPO, MCF/U, MBF/U)",""]
[null,"4.5.7","Bulk clean","no."]
["c","","LED for illuminated signs and bollards",""]
[null,"4.5.8","Clean translucent surfaces","no."]
["c","","Network cabling and electrical components including feeder pillars",""]
[null,"4.5.9","Electrical testing","no."]
["c","","Lighting columns (<20m in height)",""]
[null,"4.5.10","Structural testing from 15 years old","no."]
[1,"4.6","1500 - Roadside technology",""]
["c","4.6.1","CCTV HSM cameras, including but not limited to camera housing and associated cabling",""]
[null,"4.6.1.1","Re-fill washer fluid bottles in Hard Shoulder camera cabinet and clean camera housing front screen using wash/wipe system","no."]
[null,"4.6.1.2","Manual clean camera housing front screen if wash/wipe system is not installed","no."]
["c","4.6.2","CCTV mast ancillary equipment, Including but not limited to associated cabling, winch systems, pan/tilt/zoom mechanisms and mountings associated with ANPR cameras and CCTV (PTZ and fixed AID) cameras",""]
[null,"4.6.2.1","Inspection of mast ropes and winch mechanism and the condition thereof","no."]
[null,"4.6.2.2","Greasing of winch assembly to manufacturers recommendations","no."]
[null,"4.6.2.3","Check mast breaking system","no."]
["c","","APTR Telephones",""]
[null,"4.6.3","Clean telephone internally and externally","no."]
["c","4.6.4","Emergency Roadside Telephone (ERT)",""]
[null,"4.6.4","Clean telephone internally and externally","no."]
["c","","Environmental Sensor Stations (ESS)",""]
[null,"4.6.5","Test and calibrate sites pre-winter season and mid-winter season","no."]
["c","","Meteorological sites",""]
[null,"4.6.6","Clean fog sensors","no."]
["c","","Fixed Text Message Signs",""]
[null,"4.6.7","Check, clean and grease motor assemblies","no."]
["c","4.6.8","Remotely Operated Temporary Traffic Management Signs",""]
[null,"4.6.8.1","Change Batteries","no."]
[null,"4.6.8.2","Inspect and clean battery connectors","no."]
[null,"4.6.8.3","Clean sign face Midas outstations and detectors","no."]
["c","","Midas outstations and detectors",""]
[null,"4.6.9","Optimisation of MIDAS detectors (loops and radar) in accordance with MCH 2584 [Ref 11.N]","no."]
["c","4.6.10","Road Traffic Signals (RAG)",""]
[null,"4.6.10.1","Check alignment and condition of site and operation of any rotating tactile devices","no."]
[null,"4.6.10.2","Inspection and test in accordance with TD 101 [Ref 43.N] Ramp Metering Traffic Light Signals","no."]
["c","","Ramp Metering Traffic Light Signals",""]
[null,"4.6.11","Check alignment and condition of site","no."]
["c","4.6.12","Electrical supplies, components and distribution cables",""]
[null,"4.6.12.1","Inspection and Test network in accordance with BS7671","no."]
[null,"4.6.12.2","RCD operation and visual inspection of cable terminations","no."]
[null,"4.6.13.1","Clean camera lens","no."]
[null,"4.6.13.2","Check camera functionality","no."]
[null,"4.6.13.3","Check data and power supply cables","no."]
[]
[]
[null,null,"Note: There are no uplifts applicable for Night or Weekend Working for these works"]

{"sheet":"Schedule C","index":1,"n_rows":240,"n_cols":5,"rows_kept":240,"cut":false,"hidden":false,"merged":[]}
["Level","Item","Bill description","Unit","Rate (£)"]
[1,"","Series 1300 ROAD LIGHTING COLUMNS, BRACKETS AND CCTV MASTS (Scope Paragraph 18.8.2)",""]
["c","","Replacement of Road Lighting Columns and Brackets",""]
["c","","Replacement of steel road lighting columns and brackets; single bracket arm with 1.5 metre projection; cut off luminaire; SON-T+ lamp and lamp control gear; planted base;",""]
[null,"1","10 metre nominal height column; 100w lamp.","no"]
[null,"2","12 metre nominal height column; 250w lamp.","no"]
["c","","Replacement of steel road lighting columns and brackets; double bracket arm with 2.5 metre projection; cut off luminaire; SON-T+ lamp and lamp control gear; planted base;",""]
[null,"3","10 metre nominal height column; 150w lamp.","no"]
[null,"4","12 metre nominal height column;  250w lamp.","no"]
["c","","Replacement of Lumaires",""]
["c","","Replacement of single luminaires",""]
[null,"5","Luminaire A Single 76mm","no"]
[null,"6","Luminaire B Single 76mm","no"]
[null,"7","Luminaire B Single 114mm","no"]
["c","","Replacement of double luminaires",""]
[null,"8","Luminaire A Double 76mm","no"]
[null,"9","Luminaire A Double 89mm","no"]
[null,"10","Luminaire B Double 76mm","no"]
[1,"","Series 1400 ELECTRICAL WORK FOR ROAD LIGHTING AND TRAFFIC SIGNS (Scope Paragraphs 18.8.2)",""]
["c","","Cable Joints",""]
["c","","Cable joint; XLPE/SWA/MDPE cable; straight joint;",""]
[null,"1","6mm2 2 core cable to 10mm2 2 core cable.","no"]
[null,"2","6mm2 2 core cable to 16mm2 2 core cable.","no"]
[null,"3","10mm2 2 core cable to 16mm2 2 core cable.","no"]
[null,"4","10mm2 4 core cable to 16mm2 4 core cable.","no"]
["c","","Earth Electrodes",""]
[null,"5","Earth electrode in accordance with MCHW MCX 0509","no"]
["c","","Replacement of Cable",""]
["c","","Replacement of cable; XLPE/SWA/MDPE cable with copper conductors; in duct;",""]
[null,"6","6mm2; 2-core.","m"]
[null,"7","10mm2; 3-core.","m"]
[null,"8","16mm2; 3 core.","m"]
[null,"9","25mm2 3 core.","m"]
["c","","Replacement of Cable Terminations",""]
["c","","Replacement of cable terminations; single way cut-out; in road lighting column;",""]
[null,"10","for 6mm2 2 core XLPE/SWA/MDPE cable.","no"]
[null,"11","for 10mm2 3 core XLPE/SWA/MDPE cable.","no"]
[null,"12","for 16mm2 3 core XLPE/SWA/MDPE cable.","no"]
[null,"13","for 25mm2 3 core XLPE/SWA/MDPE cable.","no"]
["c","","Replacement of cable terminations; single way cut-out; in feeder pillar;",""]
[null,"14","for 6mm2 2 core XLPE/SWA/MDPE cable.","no"]
[null,"15","for 10mm2 3 core XLPE/SWA/MDPE cable.","no"]
[null,"16","for 16mm2 3 core XLPE/SWA/MDPE cable.","no"]
[null,"17","for 25mm2 3 core XLPE/SWA/MDPE cable.","no"]
["c","","Replacement of cable terminations; single way cut-out; in traffic sign;",""]
[null,"18","for 6mm2 2 core XLPE/SWA/MDPE cable.","no"]
[null,"19","for 10mm2 3 core XLPE/SWA/MDPE cable.","no"]
[null,"20","for 16mm2 3 core XLPE/SWA/MDPE cable.","no"]
["c","","Replacement of cable terminations; single way cut-out; in illuminated bollard;",""]
[null,"21","for 6mm2 2 core XLPE/SWA/MDPE cable.","no"]
[null,"22","for 10mm2 3 core XLPE/SWA/MDPE cable.","no"]
["c","","Electrical Testing of Network Cabling, Structural Testing of columns and Condition of Feeder Pillars",""]
[null,"23","Electrical testing of network cabling .","no"]
[null,"24","Structural testing of columns.","no"]
[null,"25","Condition of feeder pillar.","no"]
[1,"","Series 1500 ROADSIDE TECHNOLOGY (Scope paragraphs 18.9.2)",""]
["c","","Attend site and investigate faulty items to be replaced / repaired",""]
[null,"1","Attend site and investigate faulty items to be replaced / repaired (2 hour response)","no"]
[null,"2","Attend site and investigate faulty items to be replaced / repaired (4 hour response)","no"]
[null,"3","Attend site and investigate faulty items to be replaced / repaired (12 hour response)","no"]
[null,"4","Attend site and investigate faulty items to be replaced / repaired (24 hour response)","no"]
[null,"5","Attend site and investigate faulty items to be replaced / repaired (48 hour response)","no"]
[null,"6","Attend site and investigate faulty items to be replaced / repaired (7 day response)","no"]
[null,"7","Attend site and investigate faulty items to be replaced / repaired (56 day response)","no"]
[null,"8","Setup and Replacement of Equipment Configuration Plug","no"]
[null,"9","Replace Local Quad Cable and test","m"]
["c","","Replacement of HSM Cameras, cables and terminations",""]
[null,"10","Replacement of HSM camera Fuse in roadside cabinet and test","no"]
[null,"11","Replacement of HSM Camera termination unit within roadside cabinet, set up and test","no"]
[null,"12","Replacement of HSM camera and housing on verge mounted column or non-access Gantry structure and test","no"]
[null,"13","Replacement of HSM camera within camera housing on verge mounted column or non-access Gantry structure and test","no"]
[null,"14","Replacement of HSM camera cable between Camera termination unit and camera and test","m"]
[null,"15","Re-align HSM cameras on Dynamic Hard Shoulder section, and review with Traffic Officers","no"]
["c","","Replacement of CCTV Cameras, cables and terminations",""]
[null,"16","Replacement of CCTV fixed camera and housing on existing structure and test","no"]
[null,"17","Replacement of Camera termination unit within roadside cabinet and test","no"]
[null,"18","Replacement of camera mast cable between camera and root cable joint at the base of the mast and test","m"]
[null,"19","Replacement of camera root cable between root cable joint and camera termination unit and test","m"]
[null,"20","Remake camera mast cable/camera connector and test","no"]
[null,"21","Remake camera root/mast cable connector and test","no"]
[null,"22","Replacement of TV Outstation within roadside cabinet, set up and test","no"]
[null,"23","Replacement of Infra-red Power tray within roadside cabinet and test","no"]
[null,"24","Replacement of camera and housing on verge mounted 15M, 10M or 8M mast and test","no"]
[null,"25","Replacement of PTZ unit on verge mounted 15 M, 10M or 8M mast and test","no"]
[null,"26","Replacement of camera and housing on verge mounted column or non-access Gantry structure and test","no"]
[null,"27","Replacement of PTZ unit on verge mounted column or non-access Gantry structure and test","no"]
[null,"28","Replacement of Long range infra-red unit on 15M, 10M or 8M mast and test","no"]
[null,"29","Replacement of Long range infra-red unit on verge mounted column or non-access Gantry structure and test","no"]
[null,"30","Replacement of camera cable between TV Outstation and camera and test","m"]
[null,"31","Replacement of infra-red connection cable between roadside cabinet and infra-red unit on mast or structure and test","m"]
["c","","Replacement  and re-configuration of 354 Telephones",""]
[null,"32","Replacement of 354 Pod, set up and test","no"]
[null,"33","Replacement of 354 battery and test","no"]
[null,"34","Re-set 354 telephone with MC75 and test","no"]
[null,"35","Re-load software onto 354 Telephone with MC75 and test","no"]
[null,"36","Replacement of 354 Beacon and charger unit and test","no"]
[null,"37","Replacement of 354 handset","no"]
[null,"38","Clean corroded battery and cable terminations","no"]
[null,"39","Replacement of 354 barrier unit","no"]
["c","","Replacement of Signals, lanterns and associated equipment",""]
[null,"40","Replacement of AMI on Gantry Structure or Post 75 and test","no"]
[null,"41","Replacement of AMI Cable Marshalling Unit on Gantry Structure and test","no"]
[null,"42","Replacement of AMI data cable on Gantry Structure and test","m"]
[null,"43","Replacement of AMI Power cable on Gantry Structure and test","m"]
[null,"44","Replacement of AMI Roadside Controller in Gantry cabinet, set up and test","no"]
[null,"45","Replacement of Ambient Light Monitor on Gantry Structure and test","no"]
[null,"46","Replacement and alignment of MS1 (94xx) signal on accessible Gantry and test","no"]
[null,"47","Replacement and alignment of MS1 (94xx) signal on non-accessible Gantry and test","no"]
[null,"48","Replacement and alignment of MS1 (94xx) on Post 75 and test","no"]
[null,"49","Replacement of lantern on X Frame on accessible Gantry and test","no"]
[null,"50","Replacement of lantern on X Frame on non-accessible Gantry and test","no"]
[null,"51","Replacement of lantern on X Frame on Post 75 and test","no"]
[null,"52","Replacement of Signal PSU on non-accessible Gantry and test","no"]
[null,"53","Replacement of Signal PSU on accessible Gantry and test","no"]
[null,"54","Replacement of Signal PSU in Post 75 and test","no"]
[null,"55","Replacement of Data Link Connection Box on accessible Gantry Structure and test","no"]
[null,"56","Replacement of Data Link Connection Box on non-accessible Gantry Structure and test","no"]
[null,"57","Replacement of Data Link Connection Box in P75 and test","no"]
[null,"58","Replacement of Signal Power cable on accessible Gantry Structure and test","m"]
[null,"59","Replacement of Signal Power cable on non-accessible Gantry Structure and test","m"]
[null,"60","Replacement of Signal Data cable on accessible Gantry Structure and test","m"]
[null,"61","Replacement of Signal Data cable on non-accessible Gantry Structure and test","m"]
["c","","Replacement of Message Signs and component parts",""]
[null,"62","Replacement of character modules in LED Message sign on accessible Gantry Structure and test","no"]
[null,"63","Replacement of sign power supply in LED Message sign on accessible Gantry Structure and test","no"]
[null,"64","Replacement of sign controller in LED message sign on accessible Gantry Structure and test","no"]
[null,"65","Replacement of ribbon cable in LED message sign on accessible Gantry Structure and test","no"]
[null,"66","Replacement of PEC on LED message sign and test","no"]
[null,"67","Replacement of heater in LED message sign on accessible Gantry Structure and test","no"]
[null,"68","Replacement of character modules in LED Message sign on non-accessible Gantry Structure and test","no"]
[null,"69","Replacement of sign power supplies in LED Message sign on non-accessible Gantry Structure and test","no"]
[null,"70","Replacement of sign controller in LED message sign on non-accessible Gantry Structure and test","no"]
[null,"71","Replacement of ribbon cable in LED message sign on non-accessible Gantry Structure and test","no"]
[null,"72","Replacement of heater in LED message sign on non-accessible Gantry Structure and test","no"]
[null,"73","Replacement of sign roadside controller in Gantry cabinet, set up and test","no"]
[null,"74","Replacement of Cat5e cable between LED sign and Gantry cabinet and test","no"]
[null,"75","Replacement of FTMS controller in verge mounted cabinet, set up and test","no"]
[null,"76","Replacement of FTMS sign motor on verge mounted sign and test","no"]
[null,"77","Replacement of FTMS sign motor on non-accessible Gantry mounted sign and test","no"]
[null,"78","Replacement of FTMS sign motor on accessible Gantry mounted sign and test","no"]
[null,"79","Replacement of FTMS sheer pins on verge mounted sign and test","no"]
[null,"80","Replacement of FTMS sheer pins on non-accessible Gantry mounted sign and test","no"]
[null,"81","Replacement of FTMS sheer pins on accessible Gantry mounted sign and test","no"]
[null,"82","Replacement of ROTTM media converter in verge mounted cabinet and test","no"]
[null,"83","Replacement of ROTTM LED sign on verge mounted post and test","no"]
[null,"84","Replacement of character modules in LED Message sign on PVMS and test","no"]
[null,"85","Replacement of power supply in LED Message sign on PVMS and test","no"]
[null,"86","Replacement of sign controller in LED Message sign on PVMS and test","no"]
[null,"87","Replacement of batteries in PVMS and test","no"]
["c","","Replacement of Midas equipment",""]
[null,"88","Re-set Loop detector packs on Midas Outstation and test","no"]
[null,"89","Replacement of Loop bottle joint in verge chamber and test","no"]
[null,"90","Replacement of Radar Head on verge mounted pole and test","no"]
[null,"91","Replacement of Radar Power surge unit on verge mounted pole and test","no"]
[null,"92","Replacement of Radar Power tray in verge mounted cabinet and test","no"]
[null,"93","Replacement of Radar interface card in Midas Outstation in verge mounted cabinet and test","no"]
[null,"94","Replacement of Midas Outstation in verge mounted cabinet and test","no"]
[null,"95","Replacement of Loop Feeder cable between verge mounted cabinet and Loop bottle joint (up to 200M) re-terminate and test","m"]
[null,"96","Re-cut Loops in 2 lane carriageway, test and terminate","no"]
[null,"97","Re-cut Loops in 3 lane carriageway, test and terminate","no"]
[null,"98","Re-cut Loops in 4 lane carriageway, test and terminate","no"]
["c","","Replacement of NTIS equipment and component parts",""]
[null,"99","Replacement of ANPR camera on verge mounted pole or bridge structure and test","no"]
[null,"100","Replacement of ANPR Processor unit in verge located cabinet and test","no"]
[null,"101","Replacement of ANPR antenna and lead and test","no"]
[null,"102","Replacement of TMU processor unit in verge mounted cabinet / pole and test","no"]
[null,"103","Replacement of TAME processor unit in verge mounted cabinet and test","no"]
[null,"104","Replacement of TAME solar panel on TAME cabinet and test","no"]
[null,"105","Replacement of TMU solar panel on TMU cabinet / pole and test","no"]
[null,"106","Replacement of TMU batteries in TMU cabinet and test","no"]
[null,"107","Replacement of TAME batteries in TAME cabinet and test","no"]
[null,"108","Replacement of TMU battery charger in TMU cabinet and test","no"]
[null,"109","Replacement of TAME power inverter in TAME cabinet and test","no"]
[null,"110","Replacement of cable between ANPR camera and ANPR Processor unit and test","m"]
[null,"111","Replacement of TAME cabinet antenna and lead and test","no"]
[null,"112","Re-cut TAME/TMU Loop in 1 lane carriageway, test and terminate","no"]
[null,"113","Re-cut TAME/TMU Loop in 2 lane carriageway, test and terminate","no"]
[null,"114","Re-cut TAME/TMU Loop in 3 lane carriageway, test and terminate","no"]
["c","","Replacement of Traffic Signal equipment and component parts",""]
[null,"115","Replacement of Signal Aspect on 4M signal pole, re-set and re-learn","no"]
[null,"116","Replacement of Signal Aspect on mast arm, re-set and re-learn","no"]
[null,"117","Replacement of Signal Aspect on 6M signal pole, re-set and re-learn","no"]
[null,"118","Replacement of Signal Head on 4M signal pole, re-set and re-learn","no"]
[null,"119","Replacement of Signal Head on mast arm, re-set and re-learn","no"]
[null,"120","Replacement of Signal Head on 6M signal pole, re-set and re-learn","no"]
[null,"121","Replacement of Photo Electric Cell on 4M signal pole and test","no"]
[null,"122","Replacement of Above Ground Detector on 4M Signal pole (vehicle or pedestrian detection), set up and test","no"]
[null,"123","Replacement of Pedestrian detection / display units on Signal pole and test","no"]
[null,"124","Replacement of Loop Joints in verge chamber and test","no"]
[null,"125","Replacement of Traffic Signal Controller power supply and test","no"]
[null,"126","Replacement of Lamp Switch card in Traffic Signal Controller and test","no"]
[null,"127","Replacement of CPU in Traffic Signal Controller and test","no"]
[null,"128","Replacement of remote monitoring / Control unit and test","no"]
[null,"129","Replacement of detector packs within Traffic Signal Controller and test","no"]
[null,"130","Replacement of Traffic Signal CCTV camera and test","no"]
[null,"131","Replacement of video controller within Traffic Signal cabinet, set up and test","no"]
[null,"132","Replacement of microswitch within traffic signal pole for the Safety Isolation system","no"]
[null,"133","Reset Safety Isolation System Circuit breaker in verge mounted cabinet","no"]
[null,"134","Replacement of Safety Isolation System Circuit breaker in verge mounted cabinet","no"]
[null,"135","Replacement of Safety Isolation System sensor card within verge mounted cabinet","no"]
[null,"136","Replacement of Safety Isolation System power supply within verge mounted cabinet","no"]
["c","","Replacement of Ramp Metering equipment and component parts",""]
[null,"137","Replacement of Ramp Metering Controller, set up and test","no"]
[null,"138","Re-cut Ramp Metering Loop in 1 lane carriageway, test and terminate","no"]
[null,"139","Re-cut Ramp Metering Loop in 2 lane carriageway, test and terminate","no"]
[null,"140","Replacement of Signal Aspect on signal pole, re-set and test","no"]
[null,"141","Replacement of Signal Head on signal pole, re-set and test","no"]
[null,"142","Replacement of cable interface board on Signal Pole","no"]
["c","","Replacement of Environmental Sensor Station equipment, Meteorological equipment and component parts",""]
[null,"143","Replacement of Communications Processor and test","no"]
[null,"144","Replacement of Solar Panel and test","no"]
[null,"145","Replacement of Camera set and test","no"]
[null,"146","Replacement of Cyclo Sensor and test","no"]
[null,"147","Replacement of Precipitation Sensor and test","no"]
[null,"148","Replacement of Spectror Sensor and test","no"]
[null,"149","Replacement of Barometer Sensor and test","no"]
[null,"150","Replacement of ROSA Frame and test","no"]
[null,"151","Replacement of Sensor Card and test","no"]
[null,"152","Replacement of Modem and test","no"]
[null,"153","Replacement of Wind Sensor and test","no"]
[null,"154","Replacement of Humidity and Air Sensor probe and test","no"]
[null,"155","Replacement of Battery and test","no"]
[null,"156","Replacement of Visibility Sensor and test","no"]
[null,"157","Replacement of Combined Wind unit and test","no"]
[null,"158","Replacement of Depth Sensor and test","no"]
[null,"159","Replacement of Road Surface Sensor and test","no"]
["c","","Replacement of Gantry Power Safety Isolation equipment and component parts and DNO supplies",""]
[null,"160","Test and reset of Safety Isolation System Cut-out in verge mounted cabinet","no"]
[null,"161","Test and replacement of Safety Isolation System Cut-out in verge mounted cabinet","no"]
[null,"162","Test and reset of Safety Fibre Isolation System Cut-out in verge mounted cabinet","no"]
[null,"163","Test and replacement of Safety Fibre Isolation System Cut-out in verge mounted cabinet","no"]
[null,"164","Test / Confirm power cable failure and report to third party for further action.","no"]
[null,"165","Test / Confirm DNO power supply failure and report to third party for further action.","no"]
["c","","Replacement of Vehicle Activated Signs",""]
[null,"166","Replacement of Vehicle Activated Sign on post in verge","no"]
[]
[null,null,"Note: Above rates are based on Mon to Fri 0700-1900hrs"]
[]
[null,null,"Out of Hours Uplift for Night Working (Mon to Fri 1900-0700hrs)"]
[null,null,"Out of Hours Uplift for Weekend Working (0700hrs on Sat to 0700 on Mon)"]