{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Front Sheet","PE EST","PE SITE SUM","PE SOW","PE SOW SUM","New PE EST","New PE EST (2)","New PE EST (3)","New PE SUM","queries AND VERSION CONTROL","Sheet1","BARR EST","BARR EST (2)","BARR EST (3)","BARR SUM","PE Rates","Rates"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"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":"Front Sheet","index":0,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,5,21],[16,2,16,20],[17,2,17,21],[18,2,18,20]]}
[]
[null,"Calculate your estimated charges for mains requisition work\nEstimation based on Severn Trent new connection charges 2025/26\nLast updated:  February 2025\n"]
[]
[]
[]
[]
[]
[null,"Before you get started there are a few things you'll need to understand…"]
[]
[null,"l","The estimated charges are calculated using Severn Trent's 2025/26 new connections charges."]
[null,"l","The estimated charges relate to mains requisitions work completed by Severn Trent."]
[null,"l","This estimator can be used to estimate the cost of the onsite mains scheme that needs to be paid based on the site information you provide."]
[null,"l","The estimated charges should not be taken as a final quote, agreed terms or an offer to carry out works at an agreed price."]
[null,"l","The estimated charges can be calculated for PE (polyethylene) sites and protective pipe sites. "]
[null,"l","PE sites refer to standard pipework used when the ground is not contaminated and our estimation is based on a bespoke build up of a schedule of rates."]
[null,"l","The estimated costs for onsite ground is unmade."]
[null,"l","Protective pipework refers to sites where protective pipework is required because the ground is contaminated and our estimation is based on a bespoke build up of a schedule of rates."]
[null,"l","Figures for total cost are Gross estimated values, this figure represents the total onsite cost of construction required for this site. Any work that Severn Trent will be required to carry out, (whether contestable or non-contestable) has not been deducted, deferred or 'netted' off this figure."]
[null,"l","To provide a simple estimate of likely charges we have had to make a number of assumptions about your site. A formal quote, based on full information provided by you about your site, may therefore differ."]
[null,"l","The protective pipe & PE pipe estimated charges allows you to select onsite pipework with three lengths of different pipe diameters. Offsite pipework can only be selected as a single length of one diameter."]
[null,"l","The estimated charges assume temporary two way traffic lights within each scheme, however, in reality some schemes will require more expensive traffic management (eg road closures)."]
[null,"l","The estimated charges assume the diameters of the valves, hydrants and wash outs based on the information you provide under question 1 of your protective pipe charges."]
[null,"l","The estimated charges  assume there are no PRV requirements - quotes including PRVs are likely to be higher than the estimates shown in this tool"]
[null,"l","The  estimated charges assume that one pressure test per 100m of onsite mains is required."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Severn Trent Water 2022"]

{"sheet":"PE EST","index":1,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[[35,28,35,31],[36,28,36,31],[9,2,9,4],[13,2,13,4],[19,2,19,4],[33,2,33,4],[33,6,33,9],[34,6,34,9],[35,6,35,9],[118,6,120,6],[1,1,3,21],[4,4,4,5],[4,2,4,3],[36,6,36,9],[96,5,96,8],[97,5,97,8],[98,5,98,8],[99,5,99,8],[100,5,100,8],[33,10,33,20],[34,10,34,20],[35,10,35,20],[36,10,37,20]]}
[]
[null,"Calculate your estimated PE charges\nThis estimation should only be used for standard PE schemes where sites have between 5 and 250 plots.\n"]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"Question 1",null,"How many plots do you have on your site?"]
[null,null,"* Our standard and fixed charges only apply to schemes with between 5 and 250 plots. If your scheme is outside of this you will require a bespoke quote for your site."]
[]
[null,"Answer 1",null,null,null,"Plots"]
[]
[null,"Question 2",null,"Do you require us to simply lay your new main (lay only) or excavate the trench and lay the main (open cut)?"]
[]
[null,"Answer 2","Open cut"]
[]
[null,"Question 3",null,"What is the estimated length of main from the edge of your development site to our existing network? (ie distance to the SOW connection)"]
[null,null,"* If you're unsure of the length at this stage enter the width of the adjacent road"]
[null,null,"* The length we are referring to here is shown in the diagram on the right"]
[]
[null,"Answer 3",null,null,null,"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question 4",null,"What are the excavation requirements for the connection pipework?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Question 5","What are the excavation requirements for the connection pipework?"]
[null,null,"* These excavation requirements are for the length of main shown in Question 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* These excavation requirements are for the length of main shown in Question 4"]
[]
[null,"Answer 4","Excavation in the highway",null,null,null,"Options",null,null,null,"Descriptions",null,null,null,null,null,null,null,null,null,null,null,null,"Answer 5","Excavation in the highway",null,null,"Options","Descriptions"]
[null,null,null,null,null,null,"No excavation",null,null,null,"You do not require Severn Trent or a Self Lay Provider to excavate the trench for the pipework",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No excavation","You do not require Severn Trent or a Self Lay Provider to excavate the trench for the pipework"]
[null,null,null,null,null,null,"Excavation in unmade ground",null,null,null,"You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in unmade ground. Unmade ground typically covers areas like grass verges where soft digs are required (ie there is no tarmac on the surface)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excavation in unmade ground","You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in unmade ground. Unmade ground typically covers areas like grass verges where soft digs are required (ie there is no tarmac on the surface)"]
[null,null,null,null,null,null,"Excavation in the highway",null,null,null,"You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in the highway. This option covers footpaths and types 3/4 and 1/2 carriageway.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excavation in the highway","You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in the highway. This option covers footpaths and types 3/4 and 1/2 carriageway."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Severn Trent Water 2019"]

{"sheet":"PE SITE SUM","index":2,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[73,4,73,8],[74,4,74,8],[92,5,94,5],[70,4,70,8],[71,4,71,8],[1,1,3,21],[4,2,4,3],[4,4,4,5],[6,1,7,21],[72,4,72,8],[9,4,10,6],[15,4,16,6],[21,4,22,6],[25,4,26,6],[9,1,9,3],[15,1,15,3],[21,1,21,3],[25,1,25,3]]}
[]
[null,"Summary of your total site estimated charges\nThe total cost estimate for your scheme is based on the information you have provided\n"]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"This is shown as a single figure because our simplified PE 'per plot' charges include the cost of all contributing elements (eg pipework, connection, fittings, traffic management etc) "]
[]
[]
[null,"Total cost",null,null,{"$f":"(IF('PE EST'!C14=\"Lay only\",U15,U16)*'PE EST'!C10)+((VLOOKUP('PE EST'!C34,Q19:U21,5,FALSE))*MAX(0,'PE EST'!C20-22))","v":0}]
[]
[]
[]
[null,"If you are choosing a self lay provider to lay your new main the total asset payment is below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per plot charges (PE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lay only",null,null,null,620.58000000000004]
[null,"Asset payment",null,null,{"$f":"E10*0.9","v":0},null,null,null,null,null,null,null,null,null,null,null,"Open cut",null,null,null,896.3]
[null,null,null,null,null,null,null,"(equivalent to 90% of total construction costs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per metre charges >22m (PE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No excavation",null,null,null,24.27]
[null,"If you are choosing Severn Trent to lay your new main the income offset and developer contribution are below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excavation in unmade ground",null,null,null,48.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excavation in the highway",null,null,null,122.46]
[null,"Income offset",null,null,{"$f":"E16","v":0}]
[null,null,null,null,null,null,null,"(equivalent to 90% of total construction costs)"]
[]
[]
[null,"Developer Contribution",null,null,{"$f":"E10*0.1","v":0},null,null,"(equivalent to 10% of total construction costs)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Severn Trent Water 2019"]

{"sheet":"PE SOW","index":3,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,2,36,4],[20,8,21,19],[1,1,3,21],[4,2,4,3],[4,4,4,5],[19,2,19,4],[30,2,30,4],[30,7,30,9],[22,8,22,19],[23,8,23,19],[24,8,24,19],[19,6,19,7],[19,8,19,19],[20,6,21,7]]}
[]
[null,"Calculate your source of water charges\nIf you would like to understand the specific cost of the connection between the new main and the existing main (otherwise known as the source of water connection) we just need a little more information"]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"The SOW estimate covers the assets shown in the diagram"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question 1",null,"What are the excavation requirements offsite?"]
[null,null,"* If you are unsure what your excavation requirements will be select the worst case scenario. This is likely to be 'type 1/2 carriageway' for self lay providers (highest charge)"]
[]
[null,"Answer 1","Type 1/2 CW",null,null,null,"Option",null,"Description"]
[null,null,null,null,null,null,"Unmade",null,"You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in unmade ground. Unmade ground typically covers areas like grass verges where soft digs are required (ie there is no tarmac on the surface)"]
[]
[null,null,null,null,null,null,"Footpath",null,"You require excavation of the trench in a footpath by either Severn Trent or a Self Lay Provider"]
[null,null,null,null,null,null,"Type 3/4 CW",null,"You require excavation of the trench in a type 3/4 carriageway by either Severn Trent or a Self Lay Provider"]
[null,null,null,null,null,null,"Type 1/2 CW",null,"You require excavation of the trench in a type 1/2 carriageway by either Severn Trent or a Self Lay Provider"]
[]
[null,"Question 2",null,"What length and diameter of main do you require Severn Trent to lay into the SOW connection?"]
[null,null,"* If you are unsure of your pipework diameter at this stage please select 126 to 180mm"]
[]
[null,null,"Length",null,null,null,null,"Diameter"]
[null,"Answer 2",null,null,null,"m",null,"126 to 180",null,null,"mm"]
[]
[null,"Question 3",null,"What diameter connection do you need between the new mains and our existing mains (also known as SOW connection)?"]
[null,null,"* If you're unsure of the length at this stage enter the width of the adjacent road"]
[null,null,"* The length we are referring to here is shown in the diagram above"]
[]
[null,"Answer 3","150-200",null,null,"mm"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Severn Trent Water 2019"]

{"sheet":"PE SOW SUM","index":4,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,3,21],[4,2,4,3],[4,4,4,5],[9,1,9,3],[9,4,10,6],[9,8,11,20],[71,4,71,8],[72,4,72,8],[73,4,73,8],[74,4,74,8],[92,5,94,5],[17,8,19,20],[22,8,24,20],[23,0,23,3],[18,0,18,3],[70,4,70,8],[17,1,17,3],[17,4,18,6],[22,1,22,3],[22,4,23,6]]}
[]
[null,"Summary of source of water estimated charges\nThe total cost estimate for your scheme is based on the information you have provided\n"]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV"]
[]
[]
[null,null,null,null,null,null,null,null,"Specific assumptions"]
[]
[null,"Total SOW cost",null,null,{"$f":"SUM(E18+E23)","v":9531.7415000000019},null,null,null,"The SOW cost includes an allowance for valves, wash outs and trial holes. This SOW cost does include the length of main connecting into the connection itself based on the answer to Question 2. The SOW cost assumes temporary two way traffic lights are required."]
[]
[]
[]
[]
[]
[null,"This total SOW cost is split by contestable and non-contestable elements below:"]
[]
[null,"Off-site pipework cost",null,null,{"$f":"(Rates!C345+Rates!C353+Rates!C354)*0.1","v":125.495},null,null,null,"This pipework cost is solely the cost of the length of pipework specified in response to Question 2. It does not include any valves or other fittings."]
[" (laying of main into SOW)"]
[null,null,null,null,null,null,"Contestable"]
[]
[]
[null,"Physical connection",null,null,{"$f":"SUM(Rates!C342+Rates!C346+Rates!C347+Rates!C348+Rates!C355)*1.05","v":9406.2465000000011},null,null,null,"This connection cost includes the physical connection, traffic management and fittings."]
[" includes valves and traffic management"]
[null,null,null,null,null,null,"Non contestable"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Severn Trent Water 2019"]

{"sheet":"New PE EST","index":5,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[25,2,25,4],[25,6,25,8],[25,10,27,19],[26,2,26,4],[26,6,26,8],[1,1,3,21],[4,2,4,3],[4,4,4,5],[6,1,6,20],[7,1,9,7],[88,5,88,8],[89,5,89,8],[90,5,90,8],[108,6,110,6],[27,2,27,4],[27,6,27,8],[34,2,34,4],[86,5,86,8],[87,5,87,8],[34,8,34,19],[35,8,36,19],[28,2,28,4],[28,6,28,8]]}
[]
[null,"Calculate your estimated PE pipe charges\nThis estimate should be used for PE pipework schemes. "]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[]
[null,"The diagram to the right shows a typical mains site and highlights which assets are being referenced in each question."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ASSETS WITHIN YOUR SITE BOUNDARY"]
[]
[null,"Question 1",null,"What is the estimated length of main on your development site (within the boundaries of your site)?"]
[null,null,"Often development sites require mains pipework of two or three different diameters, if you require more than one diameter of mains please specify the lengths of each below."]
[null,null,"* If you only require one diameter of on-site pipework within this estimate simply enter the total length & relevant diameter in the top row of three below"]
[null,null,"* If you are unsure of your pipework diameter at this stage please select 126 to 180mm and enter the full length of mains within your development site alongside this diameter"]
[]
[null,null,"Diameter of pipe",null,null,null,"Length of each diameter"]
[null,"Answer 1",null,null,null,"mm",null,null,null,"m","Please ensure at least one of the three pairs of answer cells have been populated. If a diameter has been selected but a length hasn't been entered or vice versa the 'on-site mains laying cost' shown in your estimate will be zero."]
[null,null,null,null,null,"mm",null,null,null,"m"]
[null,null,null,null,null,"mm",null,null,null,"m"]
[null,null,null,null,null,"mm",null,null,null,"m"]
[]
[null,"Question 2",null,"What are the excavation requirements onsite?"]
[null,null,"* This is solely for the length of mains within your development site"]
[]
[null,null,null,null,null,null,"Option",null,"Description"]
[null,"Answer 2","Unmade",null,null,null,"No Excavation",null,"You do not require Severn Trent or a Self Lay Provider to excavate the trench for the pipework"]
[null,null,null,null,null,null,"Unmade",null,"You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in unmade ground. Unmade ground typically covers areas like grass verges where soft digs are required (ie there is no tarmac on the surface)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"New PE EST (2)","index":6,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[20,2,21,18],[1,1,3,21],[4,2,4,3],[4,4,4,5],[11,2,11,4],[16,2,16,4],[27,9,27,20],[28,9,28,20],[23,2,23,4],[23,7,23,8],[23,9,23,20],[24,7,25,8],[24,9,25,20],[26,9,26,20]]}
[]
[null,"Calculate your estimated PE pipe charges\nThis estimate should be used for PE pipe schemes. "]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"OFF-STE MAINS 'CONNECTION' LENGTH"]
[]
[null,"Question 1",3,"What is the estimated length of offsite main (from the edge of your development site to our existing network? ie distance to the SOW connection)"]
[null,null,"* If you're unsure of the length at this stage enter the width of the adjacent road"]
[]
[null,"Answer 3",null,null,null,"m"]
[]
[null,"Question 2",4,"What diameter of mains pipework do you require off-site?"]
[null,null,"* If you're unsure of the diameter at this stage please select 126 to 180mm"]
[]
[null,"Answer 4",null,null,null,"mm"]
[]
[null,"Question 2",5,"What are the excavation requirements off-site?"]
[null,null,"* This is solely for the length of mains between the edge of your development site and our existing network"]
[null,null,"* If you are unsure what your excavation requirements will be select the worst case scenario. This is likely to 'type 1/2 carriageway' (highest charge)"]
[]
[]
[null,"Answer 5",null,null,null,null,null,"Option",null,"Description"]
[null,null,null,null,null,null,null,"Unmade",null,"You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in unmade ground. Unmade ground typically covers areas like grass verges where soft digs are required (ie there is no tarmac on the surface)"]
[]
[null,null,null,null,null,null,null,"Footpath",null,"You require excavation of the trench in a footpath by either Severn Trent or a Self Lay Provider"]
[null,null,null,null,null,null,null,"Type 3/4 CW",null,"You require excavation of the trench in a type 3/4 carriageway by either Severn Trent or a Self Lay Provider"]
[null,null,null,null,null,null,null,"Type 1/2 CW",null,"You require excavation of the trench in a type 1/2 carriageway by either Severn Trent or a Self Lay Provider"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"New PE EST (3)","index":7,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,3,21],[4,2,4,3],[4,4,4,5],[11,2,11,4]]}
[]
[null,"Calculate your estimated PE pipe charges\nThis estimate should be used for PE pipe schemes. "]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"PHYSICAL SOW CONNECTION"]
[]
[null,"Question 1",6,"What diameter connection do you need between the new mains and our existing mains (also known as SOW connection)?"]
[null,null,"* If you are unsure of your pipework diameter at this stage please select 150-200mm"]
[]
[null,"Answer 6",null,null,null,"mm"]
[]
[]
[]
[null,"EXISTING MAINS"]
[]
[null,"Question 2",7,"Are there any existing mains on site which need to be abandoned? (We refer to this as 'capping off')."]
[null,null,"* Please enter the number of each type of asset below"]
[]
[null,"Answer 7",null,"Asset to be capped off",null,null,null,null,null,"Quantity"]
[null,null,null,"Cap off Abandoned main up to 4\" in Tarmac/Footway"]
[null,null,null,"Cap off Abandoned main 4-6\" in Unmade"]
[null,null,null,"Cap off Abandoned main up to 4-6\" in Tarmac/Footway"]
[null,null,null,"Cap off Abandoned main up to 6-9\" in Tarmac/Footway"]
[null,null,null,"Cap off Abandoned main 6-9\" in Verge/Footway"]
[null,null,null,"Cap off Abandoned main 9-12\" in Tarmac/Footway"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"New PE SUM","index":8,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[21,1,23,7],[23,9,24,11],[1,1,3,21],[4,2,4,3],[4,4,4,5],[8,5,9,7],[7,9,9,20],[25,5,26,7],[25,9,27,20],[27,5,28,7],[146,6,148,6],[29,5,30,7],[29,9,31,20],[124,5,124,8],[125,5,125,8],[126,5,126,8],[127,5,127,8],[128,5,128,8],[30,3,30,4],[31,5,32,7],[33,5,34,7],[33,9,35,20],[34,3,34,4]]}
[]
[null,"Summary of PE pipe estimated charges\nThe total estimated cost for your scheme based on the information you've entered is shown below."]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM('New PE EST'!G26+'New PE EST'!G27+'New PE EST'!G28+'New PE EST (2)'!C12)","v":0}]
[null,"Total cost (including SOW)",null,null,null,{"$f":"'PE Rates'!B244+'PE Rates'!B241+'PE Rates'!B222+'PE Rates'!B227","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[null,"The SOW estimate covers the assets shown in the diagram:"]
[]
[]
[]
[]
[]
[]
[]
[null,"This total SOW cost is split by contestable and non-contestable elements below:"]
[]
[null,null,null,null,null,null,null,null,null,"Specific assumptions"]
[]
[null,"Total SOW cost",null,null,null,{"$f":"F30+F34","v":0},null,null,null,"The SOW cost includes an allowance for valves, wash outs and trial holes. This SOW cost does include the length of main connecting into the connection itself based on the answer to Question 3. The SOW cost assumes temporary two way traffic lights are required."]
[]
[]
[]
[null,"Offsite pipework cost",null,null,null,{"$f":"'PE Rates'!C223","v":0},null,null,null,"This pipework cost includes the cost of the length of pipework specified in response to Question 3 as well as the cost of sampling and a pressure test. It does not include any valves or other fittings. When Question 3 has been answered with zero, this cost assumes 2m of pipework is required."]
[null,null,null,"Contestable"]
[]
[]
[null,"Physical connection cost",null,null,null,{"$f":"'PE Rates'!B244","v":0},null,null,null,"This connection cost includes the physical connection, traffic management and fittings. This connection assumes you are connecting into an existing barrier main which is more expensive than connecting into a PE main, to understand the connection costs of connecting into a PE main please use the PE estimator."]
[null,null,null,"Non-contestable"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"queries AND VERSION CONTROL","index":9,"n_rows":101,"n_cols":11,"rows_kept":101,"cut":false,"hidden":false,"merged":[[65,1,65,19],[69,1,69,20],[70,1,70,20]]}
[]
[null,"PE RATES","check with steve first, as i dont think we can convert it if we dont have a published charge"]
[]
[null,"phase 2 tests - designers tested"]
[]
[null,"changed titles on PE Pipes pages"]
[]
[null,"Changed dates"]
[]
[null,"Changed prices to 2021-22"]
[]
[null,"corrected errors in RATES alignment "]
[]
[null,"developer contact"]
[]
[null,"break-down of add-ons"]
[null,"old price",null,"new price"]
[null,154.9546463586,null,170.44,null,"Rates B204"]
[]
[null,588.70000000000005,null,661.28,null,"Rates B203"]
[]
[]
["Rates B203/4","UPT Average",null,null,3995.33,{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,E23*0.9,IF(SUM('BARR EST'!$G$27:$I$29)>=500,E23*1))","v":3595.797},null,"Does this exist"]
[]
[null,"Connection valves Average",{"$f":"1297.02*3","v":3891.06},null,"1297.02  Where is this price from",null,null,null,null,null,"question 5 and 6"]
[]
[null,"added turnkey attendance price into RATES (previously blank) - there are no dependant cells yet"]
[]
["Rates B206","Added thrust block cost into SOW connection"]
[]
["Rates C194:C210","10% discount for sites where total meterage removed as not substantiated"]
["Rates B212:B213","10% discount for sites where total meterage removed as not substantiated"]
[]
["BARR SUMM page"]
[]
["SOW to include","Lights, Top T, Washout etc, B2B, Trial Hole, Spade Valve, thrust block",null,null,null,null,null,null,null,"this was after steer from Lee Harding and design team"]
[null,"SOW connection + thrustblock and lights + Trial hole + b2b + UPT ave",null,null,null,null,null,null,null,"AMMENDED 20/04/2021 TO EXCLUDE TRIAL HOLE IF NO EXCAVATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"changed version",null,"same as last year"]
["2020-21","The estimated charges are calculated using Severn Trent's 2021/22 new connections charges."]
[null,"The estimated charges are calculated using Severn Trent's 2020/21 new connections charges."]
["2020-21","The estimated charges relate to mains requisitions work completed by Severn Trent."]
[null,"The estimated charges relate to mains requisitions work completed by Severn Trent."]
["2020-21","This estimator can be used to estimate the cost of the onsite mains scheme that needs to be paid based on the site information you provide."]
[null,"This estimator can be used to estimate the cost of the onsite mains scheme that needs to be paid based on the site information you provide."]
["2020-21","The estimated charges should not be taken as a final quote, agreed terms or an offer to carry out works at an agreed price."]
[null,"The estimated charges should not be taken as a final quote, agreed terms or an offer to carry out works at an agreed price."]
["2020-21","The estimated charges can be calculated for PE (polyethylene) sites and protective pipe sites. "]
[null,"The estimated charges can be calculated for PE (polyethylene) sites and protective pipe sites. "]
["2020-21","PE sites refer to standard pipework used when the ground is not contaminated and our estimation is based on a bespoke build up of a schedule of rates."]
[null,"PE sites refer to standard pipework used when the ground is not contaminated and our estimation is based on a bespoke build up of a schedule of rates."]
["2020-21","The estimated costs for onsite ground is unmade."]
[]
["2020-21","Barrier sites refer to sites where protective pipework is required because the ground is contaminated and our estimation is based on a bespoke build up of a schedule of rates."]
[]
["2020-21","Figures shown are 'gross' values ie this figure represents the total onsite cost of construction required for this site. Any work that Severn Trent will be required to carry out \n(whether contestable or non-contestable) has not been deducted, deferred or 'netted' off this figure."]
[]
["2020-21","The estimated charges assumes temporary two way traffic lights within the SOW (source of water) cost however in reality some schemes may require more expensive traffic management (eg road closures)."]
[]
["2020-21","To provide a simple estimate of likely charges we have had to make a number of assumptions about your site, particularly for the estimation of protective pipe charges. A formal quote, based on full information provided by you about your site, may therefore differ."]
[null,"To provide a simple estimate of likely charges we have had to make a number of assumptions about your site. A formal quote, based on full information provided by you about your site, may therefore differ."]
["2020-21","The protective pipe & PE pipe estimated charges allows you to select onsite pipework with three lengths of different pipe diameters. Offsite pipework can only be selected as a single length of one diameter."]
[null,"The protective pipe & PE pipe estimated charges allows you to select onsite pipework with three lengths of different pipe diameters. Offsite pipework can only be selected as a single length of one diameter."]
["2020-21","The protective pipe & PE pipe estimated charges assumes temporary two way traffic lights within each scheme however in reality some schemes may require more expensive traffic management (eg road closures)."]
[null,"The estimated charges assume temporary two way traffic lights within each scheme, however, in reality some schemes will require more expensive traffic management (eg road closures)."]
["2020-21","The protective pipe & PE pipe estimated charges assumes the diameters of the valves, hydrants and wash outs based on the information you provide under question 1 of your protective pipe charges."]
[null,"The estimated charges assume the diameters of the valves, hydrants and wash outs based on the information you provide under question 1 of your protective pipe charges."]
["2020-21","The protective pipe & PE pipe estimated charges assumes that one pressure test per 100m of onsite mains is required."]
[null,"The  estimated charges assume that one pressure test per 100m of onsite mains is required."]
["2020-21","The protective pipework estimated charges do not assume that there are any PRV requirements - quotes including PRVs are likely to be higher than the estimates shown in this tool"]
[null,"The estimated charges do not assume that there are any PRV requirements - quotes including PRVs are likely to be higher than the estimates shown in this tool"]
["2020-21","This estimate does not include any mains extension needed to serve the site."]
[]
[null,"PUT PE AND PROTECTIVE TOGETHER TO ALLOW 2 CONNECTIONS AND NO #N/A"]
[]
["REMOVED","10/90 SPLIT ON CONTESTABLE/NON CONTESTABLE"]
[null,"VALVES SPLIT CHANGED TO MATCH LEE HARDING AND DESIGN TEAM'S SPEC"]
[null,"ADDED TMA COSTS, ADDED THRUST BLOCK"]
["2021-03-30","VERSION 1","ABOVE AMMENDMENTS"]
["2021-03-31","VERSION 2","PE CHANGED TO REPLICATE BARRIER IN VALVES AND WASHOUTS"]
["2021-04-16","VERSION 3","VALVES CALCULATION AMMENDED IN PE RATES"]
["2021-04-20","VERSION 4","NO EXCAVATION ON PE Q5 CHANGED TO RESULT IN NO TRIAL HOLE REQUIRED"]
["2021-04-21","VERSION 5","NO ONSITE MAINS GENERATES ERROR CODE - CORRECTED"]
[]
[]
[]
[]
[null,"changed from","to","reason",null,null,null,"agreed with"]
["B2B average",588.70000000000005,917.55,"we have introduced a new larger size price"]

{"sheet":"Sheet1","index":10,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'BARR EST'!C33","v":0}]
[]
[null,null,{"$f":"'New PE EST'!C35","v":"Unmade"}]

{"sheet":"BARR EST","index":11,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[88,5,88,8],[89,5,89,8],[90,5,90,8],[108,6,110,6],[86,5,86,8],[87,5,87,8],[34,8,35,19],[1,1,3,21],[4,2,4,3],[4,4,4,5],[26,2,26,4],[32,2,32,4],[28,6,28,8],[6,1,7,20],[8,1,10,7],[26,10,28,19],[27,2,27,4],[28,2,28,4],[26,6,26,8],[27,6,27,8]]}
[]
[null,"Calculate your estimated protective pipe charges\nThis estimate should be used for protective pipe schemes. "]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"Our charging structure for protective pipe schemes is bespoke and therefore we ask you a few more questions here than we do in the PE estimator so we can put together an estimate based on our more granular protective pipe charges."]
[]
[null,"The diagram to the right shows a typical mains site and highlights which assets are being referenced in each question."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ASSETS WITHIN YOUR SITE BOUNDARY"]
[]
[null,"Question 1",null,"What is the estimated length of main on your development site (within the boundaries of your site)?"]
[null,null,"Often development sites require mains pipework of two or three different diameters, if you require more than one diameter of mains please specify the lengths of each below."]
[null,null,"* If you only require one diameter of on-site pipework within this estimate simply enter the total length & relevant diameter in the top row of three below"]
[null,null,"* If you are unsure of your pipework diameter at this stage please select 126 to 180mm and enter the full length of mains within your development site alongside this diameter"]
[]
[null,null,"Diameter of pipe",null,null,null,"Length of each diameter"]
[null,"Answer 1",null,null,null,"mm",null,null,null,"m","Please ensure at least one of the three pairs of answer cells have been populated. If a diameter has been selected but a length hasn't been entered or vice versa the 'on-site mains laying cost' shown in your estimate will be zero."]
[null,null,null,null,null,"mm",null,null,null,"m"]
[null,null,null,null,null,"mm",null,null,null,"m"]
[]
[null,"Question 2",null,"Do you require us to simply lay your new main (lay only) or excavate the trench and lay the main (open cut)?"]
[]
[null,"Answer 2",null,null,null,null,"Option",null,"Description"]
[null,null,null,null,null,null,"No Excavation",null,"You do not require Severn Trent or a Self Lay Provider to excavate the trench for the pipework"]
[null,null,null,null,null,null,"Unmade",null,"You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in unmade ground. Unmade ground typically covers areas like grass verges where soft digs are required (ie there is no tarmac on the surface)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"BARR EST (2)","index":12,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[27,9,27,20],[28,9,28,20],[11,2,11,4],[23,2,23,4],[20,2,21,18],[23,7,23,8],[23,9,23,20],[24,7,25,8],[16,2,16,4],[1,1,3,21],[4,2,4,3],[4,4,4,5],[24,9,25,20],[26,9,26,20]]}
[]
[null,"Calculate your estimated protective pipe charges\nThis estimate should be used for protective pipe schemes. "]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"OFF-STE MAINS 'CONNECTION' LENGTH"]
[]
[null,"Question 1",3,"What is the estimated length of offsite main (from the edge of your development site to our existing network? ie distance to the SOW connection)"]
[null,null,"* If you're unsure of the length at this stage enter the width of the adjacent road"]
[]
[null,"Answer 3",null,null,null,"m"]
[]
[null,"Question 2",4,"What diameter of mains pipework do you require off-site?"]
[null,null,"* If you're unsure of the diameter at this stage please select 126 to 180mm"]
[]
[null,"Answer 4",null,null,null,"mm"]
[]
[null,"Question 2",5,"What are the excavation requirements off-site?"]
[null,null,"* This is solely for the length of mains between the edge of your development site and our existing network"]
[null,null,"* If you are unsure what your excavation requirements will be select the worst case scenario. This is likely to be 'type 1/2 carriageway' for developers (highest charge)"]
[]
[]
[null,"Answer 5",null,null,null,null,null,"Option",null,"Description"]
[null,null,null,null,null,null,null,"Unmade",null,"You require Severn Trent or a Self Lay Provider to excavate the trench for the pipework in unmade ground. Unmade ground typically covers areas like grass verges where soft digs are required (ie there is no tarmac on the surface)"]
[]
[null,null,null,null,null,null,null,"Footpath",null,"You require excavation of the trench in a footpath by either Severn Trent or a Self Lay Provider"]
[null,null,null,null,null,null,null,"Type 3/4 CW",null,"You require excavation of the trench in a type 3/4 carriageway by either Severn Trent or a Self Lay Provider"]
[null,null,null,null,null,null,null,"Type 1/2 CW",null,"You require excavation of the trench in a type 1/2 carriageway by either Severn Trent or a Self Lay Provider"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"BARR EST (3)","index":13,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,3,21],[4,2,4,3],[4,4,4,5],[11,2,11,4]]}
[]
[null,"Calculate your estimated protective pipe charges\nThis estimate should be used for protective pipe schemes. "]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV","NEXT>>"]
[]
[null,"PHYSICAL SOW CONNECTION"]
[]
[null,"Question 1",6,"What diameter connection do you need between the new mains and our existing mains (also known as SOW connection)?"]
[null,null,"* If you are unsure of your pipework diameter at this stage please select 150-200mm"]
[]
[null,"Answer 6",null,null,null,"mm"]
[]
[]
[]
[null,"EXISTING MAINS"]
[]
[null,"Question 2",7,"Are there any existing mains on site which need to be abandoned? (We refer to this as 'capping off')."]
[null,null,"* Please enter the number of each type of asset below"]
[]
[null,"Answer 7",null,"Asset to be capped off",null,null,null,null,null,"Quantity"]
[null,null,null,"Cap off Abandoned main up to 4\" in Tarmac/Footway"]
[null,null,null,"Cap off Abandoned main 4-6\" in Unmade"]
[null,null,null,"Cap off Abandoned main up to 4-6\" in Tarmac/Footway"]
[null,null,null,"Cap off Abandoned main up to 6-9\" in Tarmac/Footway"]
[null,null,null,"Cap off Abandoned main 6-9\" in Verge/Footway"]
[null,null,null,"Cap off Abandoned main 9-12\" in Tarmac/Footway"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"BARR SUM","index":14,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[27,5,28,7],[31,5,32,7],[30,3,30,4],[34,3,34,4],[25,9,27,20],[29,9,31,20],[33,9,35,20],[25,5,26,7],[29,5,30,7],[33,5,34,7],[128,5,128,8],[146,6,148,6],[124,5,124,8],[125,5,125,8],[126,5,126,8],[127,5,127,8],[1,1,3,21],[4,2,4,3],[4,4,4,5],[23,9,23,11],[7,5,8,7],[7,9,9,20]]}
[]
[null,"Summary of protective pipe estimated charges\nThe total estimated cost for your scheme based on the information you've entered is shown below."]
[]
[]
[null,"HOME","PE CHARGES",null,"PROTECTIVE PIPE CHARGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<PREV"]
[]
[]
[null,"Total cost (including SOW)",null,null,null,{"$f":"IF(I8=0,\"£0.00\",SUM(Rates!C195+SUM(Rates!B216:B218)+SUM(Rates!C200:C205)))","v":"£0.00"},null,null,{"$f":"SUM('BARR EST'!G27+'BARR EST'!G28+'BARR EST'!G29+'BARR EST (2)'!C12)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This total SOW cost is split by contestable and non-contestable elements below:",null,null,null,null,null,null,null,null,"Specific assumptions"]
[]
[null,"Total SOW cost",null,null,null,{"$f":"F30+F34","v":0},null,null,null,"The SOW cost includes an allowance for valves, wash outs and trial holes. This SOW cost does include the length of main connecting into the connection itself based on the answer to Question 3. The SOW cost assumes temporary two way traffic lights are required."]
[]
[]
[]
[null,"Offsite pipework cost",null,null,null,{"$f":"IF(F8=\"£0.00\",\"£0.00\",Rates!B196)","v":"£0.00"},null,null,null,"This pipework cost includes the cost of the length of pipework specified in response to Question 3 as well as the cost of sampling and a pressure test. It does not include any valves or other fittings. When Question 3 has been answered with zero, this cost assumes 2m of pipework is required."]
[null,null,null,"Contestable"]
[]
[]
[null,"Physical connection cost",null,null,null,{"$f":"IF(F8=\"£0.00\",\"£0.00\",Rates!B218)","v":"£0.00"},null,null,null,"This connection cost includes the physical connection, traffic management and fittings. This connection assumes you are connecting into an existing barrier main which is more expensive than connecting into a PE main, to understand the connection costs of connecting into a PE main please use the PE estimator."]
[null,null,null,"Non-contestable"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Front Sheet'!T38","v":"© Severn Trent Water 2022"}]

{"sheet":"PE Rates","index":15,"n_rows":245,"n_cols":8,"rows_kept":245,"cut":false,"hidden":true,"merged":[[225,4,225,6],[226,4,226,6],[228,4,228,6],[229,4,229,6]]}
["Full description of required works",null,null,null,"CONCATENATE","ST charge (£)","Diameter","Excavation requirement"]
["Mains laying rates"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,{"$f":"CONCATENATE(G3,H3)","v":"No excavation"},0,null,"No excavation"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Unmade",0,null,"Unmade"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Footpath",0,null,"Footpath"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Type 3/4 CW",0,null,"Type 3/4 CW"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Type 1/2 CW",0,null,"Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 63mm NB No excavation",null,null,null,"up to 63No excavation",20.23,"up to 63","No excavation"]
["PE main laying, n.e 2m depth, up to 63mm NB in Unmade",null,null,null,"up to 63Unmade",50.36,"up to 63","Unmade"]
["PE main laying, n.e 2m depth, up to 63mm NB in Footpath",null,null,null,"up to 63Footpath",118.57,"up to 63","Footpath"]
["PE main laying, n.e 2m depth, up to 63mm NB in Type 3/4 CW",null,null,null,"up to 63Type 3/4 CW",156.08000000000001,"up to 63","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 63mm NB in Type 1/2 CW",null,null,null,"up to 63Type 1/2 CW",180.83,"up to 63","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 90mm NB No excavation",null,null,null,"64 to 90No excavation",22.18,"64 to 90","No excavation"]
["PE main laying, n.e 2m depth, up to 90mm NB in Unmade",null,null,null,"64 to 90Unmade",52.32,"64 to 90","Unmade"]
["PE main laying, n.e 2m depth, up to 90mm NB in Footpath",null,null,null,"64 to 90Footpath",120.63,"64 to 90","Footpath"]
["PE main laying, n.e 2m depth, up to 90mm NB in Type 3/4 CW",null,null,null,"64 to 90Type 3/4 CW",158.22999999999999,"64 to 90","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 90mm NB in Type 1/2 CW",null,null,null,"64 to 90Type 1/2 CW",182.95,"64 to 90","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 125mm NB No excavation",null,null,null,"91 to 125No excavation",26.35,"91 to 125","No excavation"]
["PE main laying, n.e 2m depth, up to 125mm NB in Unmade",null,null,null,"91 to 125Unmade",56.47,"91 to 125","Unmade"]
["PE main laying, n.e 2m depth, up to 125mm NB in Footpath",null,null,null,"91 to 125Footpath",124.86,"91 to 125","Footpath"]
["PE main laying, n.e 2m depth, up to 125mm NB in Type 3/4 CW",null,null,null,{"$f":"CONCATENATE(G21,H21)","v":"91 to 125Type 3/4 CW"},162.56,"91 to 125","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 125mm NB in Type 1/2 CW",null,null,null,"91 to 125Type 1/2 CW",187.3,"91 to 125","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 180mm NB No excavation",null,null,null,"126 to 180No excavation",39.21,"126 to 180","No excavation"]
["PE main laying, n.e 2m depth, up to 180mm NB in Unmade",null,null,null,"126 to 180Unmade",75.83,"126 to 180","Unmade"]
["PE main laying, n.e 2m depth, up to 180mm NB in Footpath",null,null,null,"126 to 180Footpath",147.06,"126 to 180","Footpath"]
["PE main laying, n.e 2m depth, up to 180mm NB in Type 3/4 CW",null,null,null,"126 to 180Type 3/4 CW",191.58,"126 to 180","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 180mm NB in Type 1/2 CW",null,null,null,"126 to 180Type 1/2 CW",197.37,"126 to 180","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 200mm NB No excavation",null,null,null,"181 to 200No excavation",50.04,"181 to 200","No excavation"]
["PE main laying, n.e 2m depth, up to 200mm NB in Unmade",null,null,null,"181 to 200Unmade",91.7,"181 to 200","Unmade"]
["PE main laying, n.e 2m depth, up to 200mm NB in Footpath",null,null,null,"181 to 200Footpath",162.51,"181 to 200","Footpath"]
["PE main laying, n.e 2m depth, up to 200mm NB in Type 3/4 CW",null,null,null,"181 to 200Type 3/4 CW",218.11,"181 to 200","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 200mm NB in Type 1/2 CW",null,null,null,"181 to 200Type 1/2 CW",232.43,"181 to 200","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 250 mm NB No excavation",null,null,null,"201 to 250No excavation",62.8,"201 to 250","No excavation"]
["PE main laying, n.e 2m depth, up to 250mm NB in Unmade",null,null,null,"201 to 250Unmade",107.37,"201 to 250","Unmade"]
["PE main laying, n.e 2m depth, up to 250mm NB in Footpath",null,null,null,"201 to 250Footpath",178.43,"201 to 250","Footpath"]
["PE main laying, n.e 2m depth, up to 250mm NB in Type 3/4 CW",null,null,null,"201 to 250Type 3/4 CW",244,"201 to 250","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 250mm NB in Type 1/2 CW",null,null,null,"201 to 250Type 1/2 CW",259.52999999999997,"201 to 250","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 355mm NB No excavation",null,null,null,"251 to 355No excavation",123.91,"251 to 355","No excavation"]
["PE main laying, n.e 2m depth, up to 355mm NB in Unmade",null,null,null,"251 to 355Unmade",177.91,"251 to 355","Unmade"]
["PE main laying, n.e 2m depth, up to 355mm NB in Footpath",null,null,null,"251 to 355Footpath",283.73,"251 to 355","Footpath"]
["PE main laying, n.e 2m depth, up to 355mm NB in Type 3/4 CW",null,null,null,"251 to 355Type 3/4 CW",344.15,"251 to 355","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 355mm NB in Type 1/2 CW",null,null,null,"251 to 355Type 1/2 CW",395.35,"251 to 355","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 450mm NB No excavation",null,null,null,"356 to 450No excavation",181.64,"356 to 450","No excavation"]
["PE main laying, n.e 2m depth, up to 450mm NB in Unmade",null,null,null,"356 to 450Unmade",252.87,"356 to 450","Unmade"]
["PE main laying, n.e 2m depth, up to 450mm NB in Footpath",null,null,null,"356 to 450Footpath",363.83,"356 to 450","Footpath"]
["PE main laying, n.e 2m depth, up to 450mm NB in Type 3/4 CW",null,null,null,"356 to 450Type 3/4 CW",431.35,"356 to 450","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 450mm NB in Type 1/2 CW",null,null,null,"356 to 450Type 1/2 CW",537.37,"356 to 450","Type 1/2 CW"]
["Under pressure connections"]
["Under pressure connection. Body not exceeding 100mm NB.  No Excavation",null,null,null,{"$f":"CONCATENATE(G49,H49)","v":"up to 100No excavation"},2356.7800000000002,"up to 100","No excavation"]
["Under pressure connection body not exceeding 100mm NB.  Unmade",null,null,null,"up to 100Unmade",2121.96,"up to 100","Unmade"]
["Under pressure connection. Body not exceeding 100mm NB.  Footpath",null,null,null,"up to 100Footpath",2706.26,"up to 100","Footpath"]
["Under pressure connection Body not exceeding 100mm NB.  Type 3/4 carriageway",null,null,null,"up to 100Type 3/4 CW",3423.42,"up to 100","Type 3/4 CW"]
["Under pressure connection Body not exceeding 100mm NB.  Type 1/2 carriageway",null,null,null,"up to 100Type 1/2 CW",3569.28,"up to 100","Type 1/2 CW"]
["Under pressure connection Body 150-200mm NB.  No Excavation",null,null,null,"150-200No excavation",2314.02,"150-200","No excavation"]
["Under pressure connection Body 150-200mm NB.  Unmade",null,null,null,"150-200Unmade",3009.93,"150-200","Unmade"]
["Under pressure connection Body 150-200mm NB.  Footpath",null,null,null,"150-200Footpath",3873.58,"150-200","Footpath"]
["Under pressure connection Body 150-200mm NB.  Type 3/4 carriageway",null,null,null,"150-200Type 3/4 CW",4518.1099999999997,"150-200","Type 3/4 CW"]
["Under pressure connection Body 150-200mm NB.  Type 1/2 carriageway",null,null,null,"150-200Type 1/2 CW",4693.13,"150-200","Type 1/2 CW"]
["Under pressure connection Body 225-300 NB.  No Excavation",null,null,null,"225-300No excavation",3964.72,"225-300","No excavation"]
["Under pressure connection Body 225-300 NB.  Unmade",null,null,null,"225-300Unmade",4963.97,"225-300","Unmade"]
["Under pressure connection Body 225-300 NB.  Footpath",null,null,null,"225-300Footpath",5882.6,"225-300","Footpath"]
["Under pressure connection Body 225-300 NB.  Type 3/4 carriageway",null,null,null,"225-300Type 3/4 CW",6867.23,"225-300","Type 3/4 CW"]
["Under pressure connection Body 225-300 NB.  Type 1/2 carriageway",null,null,null,"225-300Type 1/2 CW",7124.65,"225-300","Type 1/2 CW"]
["Under pressure connection Body 375-450 NB.  No Excavation",null,null,null,"375-450No excavation",10106.030000000001,"375-450","No excavation"]
["Under pressure connection Body 375-450 NB.  Unmade",null,null,null,"375-450Unmade",12007.75,"375-450","Unmade"]
["Under pressure connection Body 375-450 NB.  Footpath",null,null,null,"375-450Footpath",14159.52,"375-450","Footpath"]
["Under pressure connection Body 375-450 NB.  Type 3/4 carriageway",null,null,null,"375-450Type 3/4 CW",17637.45,"375-450","Type 3/4 CW"]
["Under pressure connection Body 375-450 NB.  Type 1/2 carriageway",null,null,null,"375-450Type 1/2 CW",18098.16,"375-450","Type 1/2 CW"]
["Valves, hydrants, wash outs"]
["Install SV/FH/WO/Tee up to 4\" No Excavation",null,null,null,{"$f":"CONCATENATE(G70,H70)","v":"up to 63No excavation"},441.25,"up to 63","No excavation"]
["Install SV/FH/WO/Tee up to 4\" in Unmade",null,null,null,"up to 63Unmade",616.16,"up to 63","Unmade"]
["Install SV/FH/WO/Tee up to 4\" in Footpath",null,null,null,"up to 63Footpath",754.27,"up to 63","Footpath"]
["Install SV/FH/WO/Tee up to 4\" in Type 3/4 carriageway",null,null,null,"up to 63Type 3/4 CW",798.18,"up to 63","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 4\" in Type 1/2 carriageway",null,null,null,"up to 63Type 1/2 CW",839.09,"up to 63","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 4\" No Excavation",null,null,null,"64 to 90No excavation",441.25,"64 to 90","No excavation"]
["Install SV/FH/WO/Tee up to 4\" in Unmade",null,null,null,"64 to 90Unmade",616.16,"64 to 90","Unmade"]
["Install SV/FH/WO/Tee up to 4\" in Footpath",null,null,null,"64 to 90Footpath",754.27,"64 to 90","Footpath"]
["Install SV/FH/WO/Tee up to 4\" in Type 3/4 carriageway",null,null,null,"64 to 90Type 3/4 CW",798.18,"64 to 90","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 4\" in Type 1/2 carriageway",null,null,null,"64 to 90Type 1/2 CW",839.09,"64 to 90","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 4\" No Excavation",null,null,null,"91 to 125No excavation",441.25,"91 to 125","No excavation"]
["Install SV/FH/WO/Tee up to 4\" in Unmade",null,null,null,"91 to 125Unmade",616.16,"91 to 125","Unmade"]
["Install SV/FH/WO/Tee up to 4\" in Footpath",null,null,null,"91 to 125Footpath",754.27,"91 to 125","Footpath"]
["Install SV/FH/WO/Tee up to 4\" in Type 3/4 carriageway",null,null,null,"91 to 125Type 3/4 CW",798.18,"91 to 125","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 4\" in Type 1/2 carriageway",null,null,null,"91 to 125Type 1/2 CW",839.09,"91 to 125","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 6\" No Excavation",null,null,null,"126 to 180No excavation",680.02,"126 to 180","No excavation"]
["Install SV/FH/WO/Tee up to 6\" in Unmade",null,null,null,"126 to 180Unmade",681.6,"126 to 180","Unmade"]
["Install SV/FH/WO/Tee up to 6\" in Footpath",null,null,null,"126 to 180Footpath",821.94,"126 to 180","Footpath"]
["Install SV/FH/WO/Tee up to 6\" in Type 3/4 carriageway",null,null,null,"126 to 180Type 3/4 CW",871.73,"126 to 180","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 6\" in Type 1/2 carriageway",null,null,null,"126 to 180Type 1/2 CW",914.68,"126 to 180","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 9\" No Excavation",null,null,null,"181 to 200No excavation",1043.9100000000001,"181 to 200","No excavation"]
["Install SV/FH/WO/Tee up to 9\" in Unmade",null,null,null,"181 to 200Unmade",1044.97,"181 to 200","Unmade"]
["Install SV/FH/WO/Tee up to 9\" in Footpath",null,null,null,"181 to 200Footpath",1197.3900000000001,"181 to 200","Footpath"]
["Install SV/FH/WO/Tee up to 9\" in Type 3/4 carriageway",null,null,null,"181 to 200Type 3/4 CW",1255.81,"181 to 200","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 9\" in Type 1/2 carriageway",null,null,null,"181 to 200Type 1/2 CW",1301.19,"181 to 200","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 9\" No Excavation",null,null,null,"201 to 250No excavation",1043.9100000000001,"201 to 250","No excavation"]
["Install SV/FH/WO/Tee up to 9\" in Unmade",null,null,null,"201 to 250Unmade",1044.97,"201 to 250","Unmade"]
["Install SV/FH/WO/Tee up to 9\" in Footpath",null,null,null,"201 to 250Footpath",1197.3900000000001,"201 to 250","Footpath"]
["Install SV/FH/WO/Tee up to 9\" in Type 3/4 carriageway",null,null,null,"201 to 250Type 3/4 CW",1255.81,"201 to 250","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 9\" in Type 1/2 carriageway",null,null,null,"201 to 250Type 1/2 CW",1301.19,"201 to 250","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 12\" No Excavation",null,null,null,"251 to 355No excavation",2156.1,"251 to 355","No excavation"]
["Install SV/FH/WO/Tee up to 12\" in Unmade",null,null,null,"251 to 355Unmade",2371.79,"251 to 355","Unmade"]
["Install SV/FH/WO/Tee up to 12\" in Footpath",null,null,null,"251 to 355Footpath",2554.67,"251 to 355","Footpath"]
["Install SV/FH/WO/Tee up to 12\" in Type 3/4 carriageway",null,null,null,"251 to 355Type 3/4 CW",2638.34,"251 to 355","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 12\" in Type 1/2 carriageway",null,null,null,"251 to 355Type 1/2 CW",2688.38,"251 to 355","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 18\" No Excavation",null,null,null,"356 to 450No excavation",7673.99,"356 to 450","No excavation"]
["Install SV/FH/WO/Tee up to 18\" in Unmade",null,null,null,"356 to 450Unmade",8262.5300000000007,"356 to 450","Unmade"]
["Install SV/FH/WO/Tee up to 18\" in Footpath",null,null,null,"356 to 450Footpath",8714.08,"356 to 450","Footpath"]
["Install SV/FH/WO/Tee up to 18\" in Type 3/4 carriageway",null,null,null,"356 to 450Type 3/4 CW",8815.06,"356 to 450","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 18\" in Type 1/2 carriageway",null,null,null,"356 to 450Type 1/2 CW",11274.92,"356 to 450","Type 1/2 CW"]
["Cap offs"]
["Cap off Abandoned main up to 4\" in Tarmac/Footway",null,null,null,null,755.08,"4\"","Tarmac/footway"]
["Cap off Abandoned main 4-6\" in Unmade",null,null,null,null,580.59,"4 - 6\"","Unmade"]
["Cap off Abandoned main up to 4-6\" in Tarmac/Footway",null,null,null,null,859.18,"4 - 6\"","Tarmac/footway"]
["Cap off Abandoned main up to 6-9\" in Tarmac/Footway",null,null,null,null,1126.9000000000001,"6 - 9\"","Tarmac/footway"]
["Cap off Abandoned main 6-9\" in Verge/Footway",null,null,null,null,1029.55,"6 - 9\"","Verge/footway"]
["Cap off Abandoned main 9-12\" in Tarmac/Footway",null,null,null,null,1456.13,"9 - 12\"","Tarmac/footway"]
["Pressure Test  & Chlorination"]
["Pressure Test  & Chlorination",null,null,null,null,874.53]
["Trial hole"]
["Trial hole in unmade",null,null,null,"Unmade",149.38,null,"Unmade"]
["Trial hole in Footpath",null,null,null,"Footpath",278.29000000000002,null,"Footpath"]
["Trial hole in type 3/4",null,null,null,"Type 3/4 CW",405.99,null,"Type 3/4 CW"]
["Trial hole in type 2/1",null,null,null,"Type 1/2 CW",594.05999999999995,null,"Type 1/2 CW"]
["Shut off"]
["Shut off (Turnkey attendance)",null,null,null,null,638.73]
["B2B"]
["Back to back connection; includes removal of end hydrants, maximum connection distance 2m; not exceeding 125mm diameter",null,null,null,null,945.68]
["Back to back connection; includes removal of end hydrants, maximum connection distance 2m; not exceeding 180mm diameter",null,null,null,null,986.6]
["Back to back connection; includes removal of end hydrants, maximum connection distance 2m; not exceeding 250mm diameter",null,null,null,null,1726.53]
["Sampling"]
["Sampling; where not included within a turnkey operation - applies to separate site visit solely for the purpose of sampling, as instructed",null,null,null,null,252.92]
["Traffic lights"]
["2 way temporary traffic lights",null,null,null,null,883.48]
["3 way temporary traffic lights",null,null,null,null,1008.75]
["4 way temporary traffic lights",null,null,null,null,1118.77]
[]
[]
["Pipe diameter drop down options"]
[]
["up to 63"]
["64 to 90"]
["91 to 125"]
["126 to 180"]
["181 to 200"]
["201 to 250"]
["251 to 355"]
["356 to 450"]
[]
["Excavation drop down options"]
[]
["No excavation"]
["Unmade"]
["Footpath"]
["Type 3/4 CW"]
["Type 1/2 CW"]
[]
["Traffic management drop down options"]
["2 way temporary traffic lights"]
["3 way temporary traffic lights"]
["4 way temporary traffic lights"]
[]
["PE lay type drop down options"]
["Lay only"]
["Open cut"]
[]
["PE offsite excavation drop down options"]
["No excavation"]
["Excavation in unmade ground"]
["Excavation in the highway"]
[]
["Pop up for PE <5 or >250 plots"]
["You have selected a number of plots which is less than 5 or over 250, this estimator tool is not applicable for this number of plots so you will require a bespoke quote for your site."]
[]
["Concatenate for PE onsite mains laying rate 1"]
[{"$f":"CONCATENATE(New PE [1]EST!C26,New PE [1]EST!C35)","v":{"$error":"#NAME?"}},null,"Cost of onsite barrier length 1",null,{"$f":"(VLOOKUP(A175,E3:F47,2,FALSE))*'New PE EST'!G26","v":{"$error":"#NAME?"}}]
[]
["Concatenate for PE onsite mains laying rate 2"]
[{"$f":"CONCATENATE('New PE EST'!C27,'New PE EST'!C35)","v":"Unmade"},null,"Cost of onsite barrier length 2",null,{"$f":"(VLOOKUP(A178,E3:F47,2,FALSE))*'New PE EST'!G27","v":0}]
[]
["Concatenate for PE onsite mains laying rate 3"]
[{"$f":"CONCATENATE('New PE EST'!C28,'New PE EST'!C35)","v":"Unmade"},null,"Cost of onsite barrier length 3",null,{"$f":"(VLOOKUP(A181,E3:F47,2,FALSE))*'New PE EST'!G28","v":0}]
[]
["Concatenate for PE onsite mains laying rate 4"]
[{"$f":"CONCATENATE('New PE EST'!C29,'New PE EST'!C35)","v":"Unmade"},null,"Cost of onsite barrier length 3",null,{"$f":"(VLOOKUP(A184,E3:F47,2,FALSE))*'New PE EST'!G29","v":0}]
["Concatenate for PE offsite mains laying rate"]
[{"$f":"CONCATENATE('New PE EST (2)'!C17,'New PE EST (2)'!C24)","v":""}]
[]
["Concatenate for PE under pressure connections"]
[{"$f":"CONCATENATE('New PE EST (3)'!C12,'New PE EST (2)'!C24)","v":""}]
[]
["Valves and uplift at SOW barrier (adjustment post audit and testing)"]
["Concatenate for offsite valve"]
[{"$f":"CONCATENATE('New PE EST (2)'!C17,'New PE EST (2)'!C24)","v":""}]
["SOW valve charge (per unit)",{"$f":"VLOOKUP(A193,E70:F109,2,FALSE)","v":{"$error":"#N/A"}}]
["SOW valve charge for 3 (assume 3 at SOW)",{"$f":"B194*3","v":{"$error":"#N/A"}}]
[]
["Flat uplift as per audit/sample averages (16.77% increase)",1.1677]
[]
["SOW cost for simply UPT",{"$f":"(VLOOKUP('PE Rates'!A189,'PE Rates'!E49:F68,2,FALSE))","v":{"$error":"#N/A"}}]
["Traffic mgt",{"$f":"F133","v":883.48}]
["Adding valves",{"$f":"B199+B200+B195","v":{"$error":"#N/A"}}]
[]
["Concatenate for Barrier under pressure connections"]
["up to 100"]
["150-200",null,"Number of pressure tests - ensuring no less than 0",null,null,{"$f":"MAX(1,('New PE EST'!G26+'New PE EST'!G27+'New PE EST'!G28+'New PE EST'!G29)/100)","v":1}]
["225-300",null,"Ensure rounding to a single figure",null,null,{"$f":"ROUND(F205,0)","v":1}]
["375-450"]
[]
["Concatenate for valves, hydrants and wash outs",null,"Length",null,"Divided by 100m",null,"Rounding to a single figure","Add two"]
[{"$f":"CONCATENATE('New PE EST'!C26,'New PE EST'!C35)","v":"Unmade"},{"$f":"IF(ISNA(VLOOKUP('PE Rates'!A210,'PE Rates'!$E$70:$F$109,2,FALSE)*H210),\"0.00\",VLOOKUP('PE Rates'!A210,'PE Rates'!$E$70:$F$109,2,FALSE)*H210)","v":"0.00"},{"$f":"'New PE EST'!G26","v":0},"m",{"$f":"C210/50","v":0},null,{"$f":"ROUND(E210,0)","v":0},{"$f":"G210+2","v":2}]
[{"$f":"CONCATENATE('New PE EST'!C27,'New PE EST'!C35)","v":"Unmade"},{"$f":"IF(ISNA(VLOOKUP('PE Rates'!A211,'PE Rates'!$E$70:$F$109,2,FALSE)*H211),\"0.00\",VLOOKUP('PE Rates'!A211,'PE Rates'!$E$70:$F$109,2,FALSE)*H211)","v":"0.00"},{"$f":"'New PE EST'!G27","v":0},"m",{"$f":"C211/50","v":0},null,{"$f":"ROUND(E211,0)","v":0},{"$f":"G211+2","v":2}]
[{"$f":"CONCATENATE('New PE EST'!C28,'New PE EST'!C35)","v":"Unmade"},{"$f":"IF(ISNA(VLOOKUP('PE Rates'!A212,'PE Rates'!$E$70:$F$109,2,FALSE)*H212),\"0.00\",VLOOKUP('PE Rates'!A212,'PE Rates'!$E$70:$F$109,2,FALSE)*H212)","v":"0.00"},{"$f":"'New PE EST'!G28","v":0},"m",{"$f":"C212/50","v":0},null,0,2]
[{"$f":"CONCATENATE('New PE EST'!C29,'New PE EST'!C35)","v":"Unmade"},{"$f":"IF(ISNA(VLOOKUP('PE Rates'!A213,'PE Rates'!$E$70:$F$109,2,FALSE)*H213),\"0.00\",VLOOKUP('PE Rates'!A213,'PE Rates'!$E$70:$F$109,2,FALSE)*H213)","v":"0.00"},{"$f":"'New PE EST'!G29","v":0},"m",{"$f":"C213/50","v":0},null,0,2]
[null,null,{"$f":"SUM(C210:C213)","v":0},"m",{"$f":"SUM(E210:E213)","v":0},null,{"$f":"SUM(G210:G213)","v":0},{"$f":"SUM(H210:H213)","v":8}]
[]
["How many required (1 per 100m + 2)"]
[]
[]
[]
[null,{"$f":"IFERROR((B237+B238)*1,0)","v":0},null,"Includes SOW costs"]
[]
["Onsite mains laying cost",{"$f":"IFERROR('PE Rates'!E175+'PE Rates'!E178+'PE Rates'!E181+E184+B229,0)","v":0},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B222*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B222*1))","v":0}]
["Offsite mains laying cost - if above 2m",{"$f":"IFERROR(VLOOKUP('PE Rates'!A186,'PE Rates'!E8:F47,2,FALSE)*'New PE EST (2)'!C12,0)","v":0},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B223*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B223*1))","v":0}]
["Offsite mains laying cost - if below 2m",{"$f":"(VLOOKUP('PE Rates'!A186,'PE Rates'!E8:F47,2,FALSE))*2","v":{"$error":"#N/A"}},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B224*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B224*1))","v":{"$error":"#N/A"}}]
["Offsite mains laying cost - pull through cell",{"$f":"IF('New PE EST (2)'!C12<2,'PE Rates'!B224,'PE Rates'!B223)","v":{"$error":"#N/A"}},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B225*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B225*1))","v":{"$error":"#N/A"}}]
["SOW connection cost + TM + valves",{"$f":"IFERROR(B201*1,0)","v":0},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B226*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B226*1))","v":0},null,"This does not include any length of main connecting into the connection itself (this would shown within the total 'offsite mains laying cost'). This does include the physical connection, traffic mgt and valves at the SOW connection. This estimator assumes a SOW cost in each estimate rather than a 'back-to-back'."]
["Valves, hydrants, wash outs along the length of the mains",{"$f":"SUM(B210:B213)*1.5","v":0},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B227*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B227*1))","v":0},null,"This estimator assumes 1.5 valve for every 100m of onsite mains plus two extra at each end of the total mains length"]
["Cap offs",{"$f":"('New PE EST (3)'!J22*'PE Rates'!F111)+('New PE EST (3)'!J23*'PE Rates'!F112)+('New PE EST (3)'!J24*'PE Rates'!F113)+('New PE EST (3)'!J25*'PE Rates'!F114)+('New PE EST (3)'!J26*'PE Rates'!F115)+('New PE EST (3)'!J27*'PE Rates'!F116)","v":0},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B228*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B228*1))","v":0}]
["Pressure test",{"$f":"'PE Rates'!F118*'PE Rates'!F206","v":874.53},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B229*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B229*1))","v":874.53},null,"This estimator assumes 1 pressure test per 100m of onsite mains"]
["Trial holes",{"$f":"IFERROR(VLOOKUP('New PE EST (2)'!C24,'PE Rates'!E120:F123,2,FALSE),0)","v":0},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B230*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B230*1))","v":0},null,"This estimator assumes 1 trial hole within each estimate"]
["B2B average",917.55,{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B231*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B231*1))","v":917.55},null,"there is a new b2b charge for upto 250mm in 22-23 charges, ave goes from £588.70 to £917.55"]
["Sampling",187.47,{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B232*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B232*1))","v":187.47}]
["UPT Average",3995.33,{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B233*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B233*1))","v":3995.33},null,"Under Pressure T"]
["Connection valves Average",{"$f":"1297.02*3","v":3891.06},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B234*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B234*1))","v":3891.06}]
[null,null,{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B235*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B235*1))","v":0}]
["SOW totals",null,{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B236*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B236*1))","v":0}]
["Physical connection total",{"$f":"C223+B226+B230+B231","v":917.55},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B237*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B237*1))","v":917.55}]
["Offsite mains total",{"$f":"B225+B229+B232+B233+B234","v":{"$error":"#N/A"}},{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B238*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B238*1))","v":{"$error":"#N/A"}}]
[]
["Physical connection total V1",{"$f":"IF(SUM('New PE EST'!$G$26:$I$29)<500,B237*1,IF(SUM('New PE EST'!$G$26:$I$29)>=500,B237*1))","v":917.55},null,null,"10% reduction made for schemes <500"]
["Offsite mains total V1",{"$f":"IF(SUM('New PE EST'!G26:I29)<500,B238*1,IF(SUM('New PE EST'!G26:I29)>=500,B238*1))","v":{"$error":"#N/A"}},null,null,"10% reduction made for schemes <500"]
[]
["Thrust Block",1451.24]
["connection (c225) (c232) + trial hole and thrust block ",{"$f":"IF(LEN(A189)>2,C226+C231+C230+B243,0)","v":0},null,"same logic as for barrier"]
["2 way temporary traffic lights",338.4]

{"sheet":"Rates","index":16,"n_rows":366,"n_cols":8,"rows_kept":366,"cut":false,"hidden":true,"merged":[[198,4,198,6],[199,4,199,6],[201,4,201,6],[202,4,202,6]]}
["Full description of required works","Code","Unit of measure",null,"CONCATENATE","ST charge (£)","Diameter","Excavation requirement"]
["Mains laying rates"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,{"$f":"CONCATENATE(G3,H3)","v":"No excavation"},0,null,"No excavation"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Unmade",0,null,"Unmade"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Footpath",0,null,"Footpath"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Type 3/4 CW",0,null,"Type 3/4 CW"]
["Blank dummy lines to enable formula for onsite mains cost to work",null,null,null,"Type 1/2 CW",0,null,"Type 1/2 CW"]
["Puriton main laying, n.e 2m depth, up to 125mm NB No excavation","DR051","m",null,"up to 125No excavation",68.38,"up to 125","No excavation"]
["Puriton main laying, n.e 2m depth, up to 125mm NB in Unmade","DR052","m",null,"up to 125Unmade",88.78,"up to 125","Unmade"]
["Puriton main laying, n.e 2m depth, up to 125mm NB in Footpath","DR053","m",null,"up to 125Footpath",158.09,"up to 125","Footpath"]
["Puriton main laying, n.e 2m depth, up to 125mm NB in Type 3/4 CW","DR054","m",null,"up to 125Type 3/4 CW",189.85,"up to 125","Type 3/4 CW"]
["Puriton main laying, n.e 2m depth, up to 125mm NB in Type 1/2 CW","DR055","m",null,"up to 125Type 1/2 CW",220.88,"up to 125","Type 1/2 CW"]
["Puriton main laying, n.e 2m depth, up to 180mm NB No excavation","DR056","m",null,"126 to 180No excavation",89.38,"126 to 180","No excavation"]
["Puriton main laying, n.e 2m depth, up to 180mm NB in Unmade","DR057","m",null,"126 to 180Unmade",115.39,"126 to 180","Unmade"]
["Puriton main laying, n.e 2m depth, up to 180mm NB in Footpath","DR058","m",null,"126 to 180Footpath",191.88,"126 to 180","Footpath"]
["Puriton main laying, n.e 2m depth, up to 180mm NB in Type 3/4 CW","DR059","m",null,"126 to 180Type 3/4 CW",229.54,"126 to 180","Type 3/4 CW"]
["Puriton main laying, n.e 2m depth, up to 180mm NB in Type 1/2 CW","DR060","m",null,"126 to 180Type 1/2 CW",287.69,"126 to 180","Type 1/2 CW"]
["Puriton main laying, n.e 2m depth, up to 200 mm NB No excavation","DR061","m",null,"181 to 200No excavation",154.18,"181 to 200","No excavation"]
["Puriton main laying, n.e 2m depth, up to 200 mm NB in Unmade","DR062","m",null,"181 to 200Unmade",190.94,"181 to 200","Unmade"]
["Puriton main laying, n.e 2m depth, up to 200mm NB in Footpath","DR063","m",null,"181 to 200Footpath",326.77999999999997,"181 to 200","Footpath"]
["Puriton main laying, n.e 2m depth, up to 200mm NB in Type 3/4 CW","DR064","m",null,"181 to 200Type 3/4 CW",375.26,"181 to 200","Type 3/4 CW"]
["Puriton main laying, n.e 2m depth, up to 200mm NB in Type 1/2 CW","DR065","m",null,"181 to 200Type 1/2 CW",481.24,"181 to 200","Type 1/2 CW"]
["Puriton main laying, n.e 2m depth, up to 250 mm NB No excavation","DR066","m",null,"201 to 250No excavation",199.57,"201 to 250","No excavation"]
["Puriton main laying, n.e 2m depth, up to 250 mm NB in Unmade","DR067","m",null,"201 to 250Unmade",244.56,"201 to 250","Unmade"]
["Puriton main laying, n.e 2m depth, up to 250mm NB in Footpath","DR068","m",null,"201 to 250Footpath",384.51,"201 to 250","Footpath"]
["Puriton main laying, n.e 2m depth, up to 250mm NB in Type 3/4 CW","DR069","m",null,"201 to 250Type 3/4 CW",439.02,"201 to 250","Type 3/4 CW"]
["Puriton main laying, n.e 2m depth, up to 250mm NB in Type 1/2 CW","DR070","m",null,"201 to 250Type 1/2 CW",526.07000000000005,"201 to 250","Type 1/2 CW"]
["Puriton main laying, n.e 2m depth, up to 355mm NB No excavation","DR071","m",null,"251 to 355No excavation",269.64,"251 to 355","No excavation"]
["Puriton main laying, n.e 2m depth, up to 355mm NB in Unmade","DR072","m",null,"251 to 355Unmade",325.37,"251 to 355","Unmade"]
["Puriton main laying, n.e 2m depth, up to 355mm NB in Footpath","DR073","m",null,"251 to 355Footpath",520.41,"251 to 355","Footpath"]
["Puriton main laying, n.e 2m depth, up to 355mm NB in Type 3/4 CW","DR074","m",null,"251 to 355Type 3/4 CW",393.78,"251 to 355","Type 3/4 CW"]
["Puriton main laying, n.e 2m depth, up to 355mm NB in Type 1/2 CW","DR075","m",null,"251 to 355Type 1/2 CW",611.79,"251 to 355","Type 1/2 CW"]
["Puriton main laying, n.e 2m depth, up to 450mm NB No excavation","DR076","m",null,"356 to 450No excavation",394.15,"356 to 450","No excavation"]
["Puriton main laying, n.e 2m depth, up to 450mm NB in Unmade","DR077","m",null,"356 to 450Unmade",463.3,"356 to 450","Unmade"]
["Puriton main laying, n.e 2m depth, up to 450mm NB in Footpath","DR078","m",null,"356 to 450Footpath",661.46,"356 to 450","Footpath"]
["Puriton main laying, n.e 2m depth, up to 450mm NB in Type 3/4 CW","DR079","m",null,"356 to 450Type 3/4 CW",521.85,"356 to 450","Type 3/4 CW"]
["Puriton main laying, n.e 2m depth, up to 450mm NB in Type 1/2 CW","DR080","m",null,"356 to 450Type 1/2 CW",781.25,"356 to 450","Type 1/2 CW"]
["Under pressure connections"]
["Under pressure connection. Body not exceeding 100mm NB.  No Excavation","DR086","nr",null,{"$f":"CONCATENATE(G39,H39)","v":"up to 100No excavation"},1586.69,"up to 100","No excavation"]
["Under pressure connection body not exceeding 100mm NB.  Unmade","DR087","nr",null,"up to 100Unmade",2121.96,"up to 100","Unmade"]
["Under pressure connection. Body not exceeding 100mm NB.  Footpath","DR088","nr",null,"up to 100Footpath",2706.26,"up to 100","Footpath"]
["Under pressure connection Body not exceeding 100mm NB.  Type 3/4 carriageway","DR089","nr",null,"up to 100Type 3/4 CW",3423.42,"up to 100","Type 3/4 CW"]
["Under pressure connection Body not exceeding 100mm NB.  Type 1/2 carriageway","DR090","nr",null,"up to 100Type 1/2 CW",3569.28,"up to 100","Type 1/2 CW"]
["Under pressure connection Body 150-200mm NB.  No Excavation","DR092","nr",null,"150-200No excavation",2314.02,"150-200","No excavation"]
["Under pressure connection Body 150-200mm NB.  Unmade","DR093","nr",null,"150-200Unmade",3009.93,"150-200","Unmade"]
["Under pressure connection Body 150-200mm NB.  Footpath","DR094","nr",null,"150-200Footpath",3873.58,"150-200","Footpath"]
["Under pressure connection Body 150-200mm NB.  Type 3/4 carriageway","DR095","nr",null,"150-200Type 3/4 CW",4518.1099999999997,"150-200","Type 3/4 CW"]
["Under pressure connection Body 150-200mm NB.  Type 1/2 carriageway","DR096","nr",null,"150-200Type 1/2 CW",4693.13,"150-200","Type 1/2 CW"]
["Under pressure connection Body 225-300 NB.  No Excavation","DR098","nr",null,"225-300No excavation",3964.72,"225-300","No excavation"]
["Under pressure connection Body 225-300 NB.  Unmade","DR099","nr",null,"225-300Unmade",4963.97,"225-300","Unmade"]
["Under pressure connection Body 225-300 NB.  Footpath","DR100","nr",null,"225-300Footpath",5882.6,"225-300","Footpath"]
["Under pressure connection Body 225-300 NB.  Type 3/4 carriageway","DR101","nr",null,"225-300Type 3/4 CW",6867.23,"225-300","Type 3/4 CW"]
["Under pressure connection Body 225-300 NB.  Type 1/2 carriageway","DR102","nr",null,"225-300Type 1/2 CW",7124.65,"225-300","Type 1/2 CW"]
["Under pressure connection Body 375-450 NB.  No Excavation","DR104","nr",null,"375-450No excavation",10106.030000000001,"375-450","No excavation"]
["Under pressure connection Body 375-450 NB.  Unmade","DR105","nr",null,"375-450Unmade",12007.75,"375-450","Unmade"]
["Under pressure connection Body 375-450 NB.  Footpath","DR106","nr",null,"375-450Footpath",14159.52,"375-450","Footpath"]
["Under pressure connection Body 375-450 NB.  Type 3/4 carriageway","DR107","nr",null,"375-450Type 3/4 CW",17637.45,"375-450","Type 3/4 CW"]
["Under pressure connection Body 375-450 NB.  Type 1/2 carriageway","DR108","nr",null,"375-450Type 1/2 CW",18098.16,"375-450","Type 1/2 CW"]
["Valves, hydrants, wash outs"]
["Install SV/FH/WO/Tee up to 4\" No Excavation","DR110","nr",null,"up to 125No excavation",441.25,"up to 125","No excavation"]
["Install SV/FH/WO/Tee up to 4\" in Unmade","DR111","nr",null,"up to 125Unmade",616.16,"up to 125","Unmade"]
["Install SV/FH/WO/Tee up to 4\" in Footpath","DR112","nr",null,"up to 125Footpath",754.27,"up to 125","Footpath"]
["Install SV/FH/WO/Tee up to 4\" in Type 3/4 carriageway","DR113","nr",null,"up to 125Type 3/4 CW",798.18,"up to 125","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 4\" in Type 1/2 carriageway","DR114","nr",null,"up to 125Type 1/2 CW",839.09,"up to 125","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 6\" No Excavation","DR115","nr",null,"126 to 180No excavation",680.02,"126 to 180","No excavation"]
["Install SV/FH/WO/Tee up to 6\" in Unmade","DR116","nr",null,"126 to 180Unmade",681.6,"126 to 180","Unmade"]
["Install SV/FH/WO/Tee up to 6\" in Footpath","DR117","nr",null,"126 to 180Footpath",821.94,"126 to 180","Footpath"]
["Install SV/FH/WO/Tee up to 6\" in Type 3/4 carriageway","DR118","nr",null,"126 to 180Type 3/4 CW",871.73,"126 to 180","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 6\" in Type 1/2 carriageway","DR119","nr",null,"126 to 180Type 1/2 CW",914.68,"126 to 180","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 9\" No Excavation","DR120","nr",null,"181 to 200No excavation",1043.9100000000001,"181 to 200","No excavation"]
["Install SV/FH/WO/Tee up to 9\" in Unmade","DR121","nr",null,"181 to 200Unmade",1044.97,"181 to 200","Unmade"]
["Install SV/FH/WO/Tee up to 9\" in Footpath","DR122","nr",null,"181 to 200Footpath",1197.3900000000001,"181 to 200","Footpath"]
["Install SV/FH/WO/Tee up to 9\" in Type 3/4 carriageway","DR123","nr",null,"181 to 200Type 3/4 CW",1255.81,"181 to 200","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 9\" in Type 1/2 carriageway","DR124","nr",null,"181 to 200Type 1/2 CW",1301.19,"181 to 200","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 9\" No Excavation","DR120","nr",null,"201 to 250No excavation",1043.9100000000001,"201 to 250","No excavation"]
["Install SV/FH/WO/Tee up to 9\" in Unmade","DR121","nr",null,"201 to 250Unmade",1044.97,"201 to 250","Unmade"]
["Install SV/FH/WO/Tee up to 9\" in Footpath","DR122","nr",null,"201 to 250Footpath",1197.3900000000001,"201 to 250","Footpath"]
["Install SV/FH/WO/Tee up to 9\" in Type 3/4 carriageway","DR123","nr",null,"201 to 250Type 3/4 CW",1255.81,"201 to 250","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 9\" in Type 1/2 carriageway","DR124","nr",null,"201 to 250Type 1/2 CW",1301.19,"201 to 250","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 12\" No Excavation","DR125","nr",null,"251 to 355No excavation",2156.1,"251 to 355","No excavation"]
["Install SV/FH/WO/Tee up to 12\" in Unmade","DR126","nr",null,"251 to 355Unmade",2371.79,"251 to 355","Unmade"]
["Install SV/FH/WO/Tee up to 12\" in Footpath","DR127","nr",null,"251 to 355Footpath",2554.67,"251 to 355","Footpath"]
["Install SV/FH/WO/Tee up to 12\" in Type 3/4 carriageway","DR128","nr",null,"251 to 355Type 3/4 CW",2638.34,"251 to 355","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 12\" in Type 1/2 carriageway","DR129","nr",null,"251 to 355Type 1/2 CW",2688.38,"251 to 355","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 18\" No Excavation","DR130","nr",null,"356 to 450No excavation",7673.99,"356 to 450","No excavation"]
["Install SV/FH/WO/Tee up to 18\" in Unmade","DR131","nr",null,"356 to 450Unmade",8262.5300000000007,"356 to 450","Unmade"]
["Install SV/FH/WO/Tee up to 18\" in Footpath","DR132","nr",null,"356 to 450Footpath",8714.08,"356 to 450","Footpath"]
["Install SV/FH/WO/Tee up to 18\" in Type 3/4 carriageway","DR133","nr",null,"356 to 450Type 3/4 CW",8815.06,"356 to 450","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 18\" in Type 1/2 carriageway","DR134","nr",null,"356 to 450Type 1/2 CW",11274.92,"356 to 450","Type 1/2 CW"]
["Cap offs"]
["Cap off Abandoned main up to 4\" in Tarmac/Footway","DR135","nr",null,null,755.08,"4\"","Tarmac/footway"]
["Cap off Abandoned main 4-6\" in Unmade","DR140","nr",null,null,580.59,"4 - 6\"","Unmade"]
["Cap off Abandoned main up to 4-6\" in Tarmac/Footway","DR136","nr",null,null,859.18,"4 - 6\"","Tarmac/footway"]
["Cap off Abandoned main up to 6-9\" in Tarmac/Footway","DR137","nr",null,null,1126.9000000000001,"6 - 9\"","Tarmac/footway"]
["Cap off Abandoned main 6-9\" in Verge/Footway","DR138","nr",null,null,1029.55,"6 - 9\"","Verge/footway"]
["Cap off Abandoned main 9-12\" in Tarmac/Footway","DR139","nr",null,null,1456.13,"9 - 12\"","Tarmac/footway"]
["Pressure Test  & Chlorination"]
["Pressure Test  & Chlorination","DR141","nr",null,null,874.53]
["Trial hole",null,null,null,null,0]
["Trial hole in unmade","DR142","m3",null,"Unmade",149.38,null,"Unmade"]
["Trial hole in Footpath","DR143","m3",null,"Footpath",278.29000000000002,null,"Footpath"]
["Trial hole in type 3/4","DR144","m3",null,"Type 3/4 CW",405.99,null,"Type 3/4 CW"]
["Trial hole in type 2/1","DR145","m3",null,"Type 1/2 CW",594.05999999999995,null,"Type 1/2 CW"]
["Shut off"]
["Shut off (Turnkey attendance)","DR146","day",null,null,638.73]
["B2B"]
["Back to back connection; includes removal of end hydrants, maximum connection distance 2m; not exceeding 125mm diameter","DR149","sum",null,null,945.68]
["Back to back connection; includes removal of end hydrants, maximum connection distance 2m; not exceeding 180mm diameter","DR150","sum",null,null,986.6]
["Back to back connection; includes removal of end hydrants, maximum connection distance 2m; not exceeding 250mm diameter","dr150.5","sum",null,null,1726.53]
["Sampling",null,null,null,null,0]
["Sampling; where not included within a turnkey operation - applies to separate site visit solely for the purpose of sampling, as instructed","DR151","sum",null,null,252.92]
["Traffic lights"]
["2 way temporary traffic lights","TL2","sum",null,null,883.48,"confirmed with ZH"]
["3 way temporary traffic lights","TL3","sum",null,null,1008.75,"confirmed with ZH"]
["4 way temporary traffic lights","TL4","sum",null,null,1118.77,"confirmed with ZH"]
[]
[]
["Pipe diameter drop down options"]
[]
["up to 125","up to 63"]
["126 to 180","64 to 90"]
["181 to 200","91 to 125"]
["201 to 250","126 to 180"]
["251 to 355","181 to 200"]
["356 to 450","201 to 250"]
[null,"251 to 355"]
[null,"356 to 450"]
[]
["Excavation drop down options"]
["No excavation"]
["Unmade"]
["Footpath"]
["Type 3/4 CW"]
["Type 1/2 CW"]
[]
["Traffic management drop down options"]
["2 way temporary traffic lights"]
["3 way temporary traffic lights"]
["4 way temporary traffic lights"]
[]
["PE lay type drop down options"]
["Lay only"]
["Open cut"]
[]
["PE offsite excavation drop down options"]
["No excavation"]
["Excavation in unmade ground"]
["Excavation in the highway"]
[]
["Pop up for PE <5 or >250 plots"]
["You have selected a number of plots which is less than 5 or over 250, this estimator tool is not applicable for this number of plots so you will require a bespoke quote for your site."]
[]
["Concatenate for Barrier onsite mains laying rate 1"]
[{"$f":"CONCATENATE('BARR EST'!C27,'BARR EST'!C33)","v":""},null,"Cost of onsite barrier length 1",null,{"$f":"(VLOOKUP(A154,E3:F37,2,FALSE))*'BARR EST'!G27","v":{"$error":"#N/A"}}]
[]
["Concatenate for Barrier onsite mains laying rate 2"]
[{"$f":"CONCATENATE('BARR EST'!C28,'BARR EST'!C33)","v":""},null,"Cost of onsite barrier length 2",null,{"$f":"(VLOOKUP(A157,E3:F37,2,FALSE))*'BARR EST'!G28","v":{"$error":"#N/A"}}]
[]
["Concatenate for Barrier onsite mains laying rate 1"]
[{"$f":"CONCATENATE('BARR EST'!C29,'BARR EST'!C33)","v":""},null,"Cost of onsite barrier length 3",null,{"$f":"(VLOOKUP(A160,E3:F37,2,FALSE))*'BARR EST'!G29","v":{"$error":"#N/A"}}]
[]
["Concatenate for Barrier offsite mains laying rate"]
[{"$f":"CONCATENATE('BARR EST (2)'!C17,'BARR EST (2)'!C24)","v":""},"question 4 and 5"]
[]
["Concatenate for Barrier under pressure connections"]
[{"$f":"CONCATENATE('BARR EST (3)'!C12,'BARR EST (2)'!C24)","v":""}]
[]
["Valves and uplift at SOW barrier (adjustment post audit and testing)"]
["Concatenate for offsite valve"]
[{"$f":"CONCATENATE('BARR EST (2)'!C17,'BARR EST (2)'!C24)","v":""}]
["SOW valve charge (per unit)",{"$f":"VLOOKUP(A170,E60:F89,2,FALSE)","v":{"$error":"#N/A"}}]
["SOW valve charge for 3 (assume 3 at SOW)",{"$f":"B171*3","v":{"$error":"#N/A"}},"ok"]
[]
["Flat uplift as per audit/sample averages (16.77% increase)",1.1677]
[]
["SOW cost for simply UPT",{"$f":"VLOOKUP(A166,E39:F58,2,FALSE)","v":{"$error":"#N/A"}},"question 6, question 5"]
["Traffic mgt",{"$f":"F113","v":883.48}]
["Adding valves",{"$f":"B176+B177+B172","v":{"$error":"#N/A"}}]
[]
["Concatenate for Barrier under pressure connections"]
["up to 100"]
["150-200",null,"Number of pressure tests - ensuring no less than 0",null,null,{"$f":"MAX(1,('BARR EST'!G27+'BARR EST'!G28+'BARR EST'!G29)/100)","v":1}]
["225-300",null,"Ensure rounding to a single figure",null,null,{"$f":"ROUND(F182,0)","v":1}]
["375-450"]
[]
["Concatenate for valves, hydrants and wash outs"]
[{"$f":"CONCATENATE('BARR EST'!C27,'BARR EST'!C33)","v":""}]
[null,null,"Length",null,"Divided by 100m",null,"Rounding to a single figure"]
["How many required (1 per 100m + 2)",null,{"$f":"'BARR EST'!G27+'BARR EST'!G28+'BARR EST'!G29","v":0},"m",{"$f":"(C189/100)*1.5","v":0},null,{"$f":"ROUND(E189,0)","v":0}]
[]
[null,null,null,null,null,null,"Add two"]
[null,null,null,null,null,null,{"$f":"G189+2","v":2}]
[]
[]
["Onsite mains laying cost",{"$f":"E154+E157+E160","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B195*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B195*1))","v":{"$error":"#N/A"}},null,"barriers"]
["Offsite mains laying cost - if above 2m",{"$f":"VLOOKUP(A163,E8:F37,2,FALSE)*'BARR EST (2)'!C12","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B196*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B196*1))","v":{"$error":"#N/A"}},null,"puritan oioe"]
["Offsite mains laying cost - if below 2m",{"$f":"VLOOKUP(A163,E8:F37,2,FALSE)*2","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B197*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B197*1))","v":{"$error":"#N/A"}},null,"same"]
["Offsite mains laying cost - pull through cell",{"$f":"IF('BARR EST (2)'!C12<2,B197,B196)","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B198*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B198*1))","v":{"$error":"#N/A"}},null,"minimum 2m charge offsite"]
["SOW connection cost + TM + valves",{"$f":"B178","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B199*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B199*1))","v":{"$error":"#N/A"}},null,"This does not include any length of main connecting into the connection itself (this would shown within the total 'offsite mains laying cost'). This does include the physical connection, traffic mgt and valves at the SOW connection. This estimator assumes a SOW cost in each estimate rather than a 'back-to-back'."]
["Valves, hydrants, wash outs along the length of the mains",{"$f":"_xlfn.IFNA((VLOOKUP(A187,E60:F89,2,FALSE)*G192),\"Please select a diameter\")*1.5","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(B200*1,0)","v":0},null,"This estimator assumes 1.5 valve for every 100m of onsite mains plus one extra at each end of the total mains length"]
["Cap offs",{"$f":"('BARR EST (3)'!J22*F91)+('BARR EST (3)'!J23*F92)+('BARR EST (3)'!J24*F93)+('BARR EST (3)'!J25*F94)+('BARR EST (3)'!J26*F95)+('BARR EST (3)'!J27*F96)","v":0},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B201*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B201*1))","v":0}]
["Pressure test",{"$f":"F98*F183","v":874.53},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B202*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B202*1))","v":874.53},null,"This estimator assumes 1 pressure test per 100m of onsite mains"]
["Trial holes",{"$f":"VLOOKUP('BARR EST (2)'!C24,E100:F103,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B203*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B203*1))","v":{"$error":"#N/A"}},null,"This estimator assumes 1 trial hole within each estimate"]
["B2B max price",727.34,{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B204*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B204*1))","v":727.34}]
["Sampling",187.47,{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B205*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B205*1))","v":187.47}]
["UPT Average",3995.33,{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B206*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B206*1))","v":3995.33}]
["Connection valves Average",{"$f":"1297.02*3+1451.24","v":5342.3},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B207*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B207*1))","v":5342.3},null,{"$f":"CONCATENATE('BARR EST (3)'!C12:E12,'BARR EST (2)'!C24:E24)","v":""},"","","added thrust block to SOW connection"]
[null,null,{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B208*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B208*1))","v":0},null,null,null,null,"[4/20 9:59 AM] Fathimath, Nishana"]
["SOW totals",null,{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B209*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B209*1))","v":0},null,null,null,null,"hi Chris "]
["Physical connection total",{"$f":"B199+B203+B204","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B210*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B210*1))","v":{"$error":"#N/A"}},null,null,null,null,"yes all's good here. hope the same with u. yes the price of a thrust block for AMP 7 is a fixed rate of £1,143.52 (this is only the basic rate. there are 2 sets of uplifts amey add to this where the % depends on type of scheme. and on top of that, there are 2 sets of uplifts from STW too) hope this helps"]
["Offsite mains total",{"$f":"B198+B202+B205+B206+B207","v":{"$error":"#N/A"}},{"$f":"IF(SUM('BARR EST'!$G$27:$I$29)<500,B211*1,IF(SUM('BARR EST'!$G$27:$I$29)>=500,B211*1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"kept thrustblock at last years price - but it now varies"]
["Physical connection total V1",{"$f":"IF(SUM('BARR EST'!G27:I29)<200,B210*1,IF(SUM('BARR EST'!G27:I29)>200,B210*1))","v":{"$error":"#N/A"}},null,null,"10% reduction made for schemes <500 no longer applies"]
["Offsite mains total V1",{"$f":"IF(SUM('BARR EST'!G27:I29)<200,B211*1,IF(SUM('BARR EST'!G27:I29)>200,B211*1))","v":{"$error":"#N/A"}},null,null,"10% reduction made for schemes <500 no longer applies"]
["total offsite connection metres (-2m) - question 3 (contestable)",{"$f":"IF('BARR EST (2)'!C12>2,'BARR EST (2)'!C12-2,2)","v":2}]
["offsite pipework cost (contestable)",{"$f":"IFERROR(VLOOKUP(A163,E8:F37,2,FALSE)*'BARR EST (2)'!C12,0)","v":0},null,{"$f":"A163","v":""},{"$f":"'BARR EST (2)'!C12","v":0},"metres"]
[{"$f":"A113","v":"2 way temporary traffic lights"},{"$f":"F113","v":883.48}]
["SOW connection + thrustblock (1451.24) and lights + Trial hole + b2b + UPT ave + valves",{"$f":"IFERROR(B210+1451.24,0)","v":0}]
["PE rates for PE SOW calculation"]
["Full description of required works","Code","Unit of measure","Amey rate (£)","CONCATENATE","ST charge (£)","Diameter","Excavation requirement"]
["Mains laying rates"]
["PE main laying, n.e 2m depth, up to 63mm NB No excavation","DR001","m",null,{"$f":"CONCATENATE(G222,H222)","v":"up to 63No excavation"},20.23,"up to 63","No excavation"]
["PE main laying, n.e 2m depth, up to 63mm NB in Unmade","DR002","m",null,{"$f":"CONCATENATE(G223,H223)","v":"up to 63Unmade"},50.36,"up to 63","Unmade"]
["PE main laying, n.e 2m depth, up to 63mm NB in Footpath","DR003","m",null,"up to 63Footpath",118.57,"up to 63","Footpath"]
["PE main laying, n.e 2m depth, up to 63mm NB in Type 3/4 CW","DR004","m",null,"up to 63Type 3/4 CW",156.08000000000001,"up to 63","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 63mm NB in Type 1/2 CW","DR005","m",null,"up to 63Type 1/2 CW",180.83,"up to 63","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 90mm NB No excavation","DR006","m",null,"64 to 90No excavation",22.18,"64 to 90","No excavation"]
["PE main laying, n.e 2m depth, up to 90mm NB in Unmade","DR007","m",null,"64 to 90Unmade",52.32,"64 to 90","Unmade"]
["PE main laying, n.e 2m depth, up to 90mm NB in Footpath","DR008","m",null,"64 to 90Footpath",120.63,"64 to 90","Footpath"]
["PE main laying, n.e 2m depth, up to 90mm NB in Type 3/4 CW","DR009","m",null,"64 to 90Type 3/4 CW",158.22999999999999,"64 to 90","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 90mm NB in Type 1/2 CW","DR010","m",null,"64 to 90Type 1/2 CW",182.95,"64 to 90","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 125mm NB No excavation","DR011","m",null,"91 to 125No excavation",26.35,"91 to 125","No excavation"]
["PE main laying, n.e 2m depth, up to 125mm NB in Unmade","DR012","m",null,"91 to 125Unmade",56.47,"91 to 125","Unmade"]
["PE main laying, n.e 2m depth, up to 125mm NB in Footpath","DR013","m",null,"91 to 125Footpath",124.86,"91 to 125","Footpath"]
["PE main laying, n.e 2m depth, up to 125mm NB in Type 3/4 CW","DR014","m",null,"91 to 125Type 3/4 CW",162.56,"91 to 125","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 125mm NB in Type 1/2 CW","DR015","m",null,"91 to 125Type 1/2 CW",187.3,"91 to 125","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 180mm NB No excavation","DR016","m",null,"126 to 180No excavation",39.21,"126 to 180","No excavation"]
["PE main laying, n.e 2m depth, up to 180mm NB in Unmade","DR017","m",null,"126 to 180Unmade",75.83,"126 to 180","Unmade"]
["PE main laying, n.e 2m depth, up to 180mm NB in Footpath","DR018","m",null,"126 to 180Footpath",147.06,"126 to 180","Footpath"]
["PE main laying, n.e 2m depth, up to 180mm NB in Type 3/4 CW","DR019","m",null,"126 to 180Type 3/4 CW",191.58,"126 to 180","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 180mm NB in Type 1/2 CW","DR020","m",null,"126 to 180Type 1/2 CW",197.37,"126 to 180","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 200 mm NB No excavation","DR021","m",null,"181 to 200No excavation",50.04,"181 to 200","No excavation"]
["PE main laying, n.e 2m depth, up to 200mm NB in Unmade","DR022","m",null,"181 to 200Unmade",91.7,"181 to 200","Unmade"]
["PE main laying, n.e 2m depth, up to 200mm NB in Footpath","DR023","m",null,"181 to 200Footpath",162.51,"181 to 200","Footpath"]
["PE main laying, n.e 2m depth, up to 200mm NB in Type 3/4 CW","DR024","m",null,"181 to 200Type 3/4 CW",218.11,"181 to 200","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 200mm NB in Type 1/2 CW","DR025","m",null,"181 to 200Type 1/2 CW",232.43,"181 to 200","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 250 mm NB No excavation","DR026","m",null,"201 to 250No excavation",62.8,"201 to 250","No excavation"]
["PE main laying, n.e 2m depth, up to 250mm NB in Unmade","DR027","m",null,"201 to 250Unmade",107.37,"201 to 250","Unmade"]
["PE main laying, n.e 2m depth, up to 250mm NB in Footpath","DR028","m",null,"201 to 250Footpath",178.43,"201 to 250","Footpath"]
["PE main laying, n.e 2m depth, up to 250mm NB in Type 3/4 CW","DR029","m",null,"201 to 250Type 3/4 CW",244,"201 to 250","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 250mm NB in Type 1/2 CW","DR030","m",null,"201 to 250Type 1/2 CW",259.52999999999997,"201 to 250","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 355mm NB No excavation","DR031","m",null,"251 to 355No excavation",123.91,"251 to 355","No excavation"]
["PE main laying, n.e 2m depth, up to 355mm NB in Unmade","DR032","m",null,"251 to 355Unmade",177.91,"251 to 355","Unmade"]
["PE main laying, n.e 2m depth, up to 355mm NB in Footpath","DR033","m",null,"251 to 355Footpath",283.73,"251 to 355","Footpath"]
["PE main laying, n.e 2m depth, up to 355mm NB in Type 3/4 CW","DR034","m",null,"251 to 355Type 3/4 CW",344.15,"251 to 355","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 355mm NB in Type 1/2 CW","DR035","m",null,"251 to 355Type 1/2 CW",395.35,"251 to 355","Type 1/2 CW"]
["PE main laying, n.e 2m depth, up to 450mm NB No excavation","DR036","m",null,"356 to 450No excavation",181.64,"356 to 450","No excavation"]
["PE main laying, n.e 2m depth, up to 450mm NB in Unmade","DR037","m",null,"356 to 450Unmade",252.87,"356 to 450","Unmade"]
["PE main laying, n.e 2m depth, up to 450mm NB in Footpath","DR038","m",null,"356 to 450Footpath",363.83,"356 to 450","Footpath"]
["PE main laying, n.e 2m depth, up to 450mm NB in Type 3/4 CW","DR039","m",null,"356 to 450Type 3/4 CW",431.35,"356 to 450","Type 3/4 CW"]
["PE main laying, n.e 2m depth, up to 450mm NB in Type 1/2 CW","DR040","m",null,"356 to 450Type 1/2 CW",537.37,"356 to 450","Type 1/2 CW"]
["UPT rates"]
["Under pressure connection. Body not exceeding 100mm NB.  No Excavation","DR086","nr",null,"up to 100No excavation",1586.69,"up to 100","No excavation"]
["Under pressure connection body not exceeding 100mm NB.  Unmade","DR087","nr",null,"up to 100Unmade",2121.96,"up to 100","Unmade"]
["Under pressure connection. Body not exceeding 100mm NB.  Footpath","DR088","nr",null,"up to 100Footpath",2706.26,"up to 100","Footpath"]
["Under pressure connection Body not exceeding 100mm NB.  Type 3/4 carriageway","DR089","nr",null,"up to 100Type 3/4 CW",3423.42,"up to 100","Type 3/4 CW"]
["Under pressure connection Body not exceeding 100mm NB.  Type 1/2 carriageway","DR090","nr",null,"up to 100Type 1/2 CW",3569.28,"up to 100","Type 1/2 CW"]
["Under pressure connection Body 150-200mm NB.  No Excavation","DR092","nr",null,"150-200No excavation",2314.02,"150-200","No excavation"]
["Under pressure connection Body 150-200mm NB.  Unmade","DR093","nr",null,"150-200Unmade",3009.93,"150-200","Unmade"]
["Under pressure connection Body 150-200mm NB.  Footpath","DR094","nr",null,"150-200Footpath",3873.58,"150-200","Footpath"]
["Under pressure connection Body 150-200mm NB.  Type 3/4 carriageway","DR095","nr",null,"150-200Type 3/4 CW",4518.1099999999997,"150-200","Type 3/4 CW"]
["Under pressure connection Body 150-200mm NB.  Type 1/2 carriageway","DR096","nr",null,"150-200Type 1/2 CW",4693.13,"150-200","Type 1/2 CW"]
["Under pressure connection Body 225-300 NB.  No Excavation","DR098","nr",null,"225-300No excavation",3964.72,"225-300","No excavation"]
["Under pressure connection Body 225-300 NB.  Unmade","DR099","nr",null,"225-300Unmade",4963.97,"225-300","Unmade"]
["Under pressure connection Body 225-300 NB.  Footpath","DR100","nr",null,"225-300Footpath",5882.6,"225-300","Footpath"]
["Under pressure connection Body 225-300 NB.  Type 3/4 carriageway","DR101","nr",null,"225-300Type 3/4 CW",6867.23,"225-300","Type 3/4 CW"]
["Under pressure connection Body 225-300 NB.  Type 1/2 carriageway","DR102","nr",null,"225-300Type 1/2 CW",7124.65,"225-300","Type 1/2 CW"]
["Under pressure connection Body 375-450 NB.  No Excavation","DR104","nr",null,"375-450No excavation",10106.030000000001,"375-450","No excavation"]
["Under pressure connection Body 375-450 NB.  Unmade","DR105","nr",null,"375-450Unmade",12007.75,"375-450","Unmade"]
["Under pressure connection Body 375-450 NB.  Footpath","DR106","nr",null,"375-450Footpath",14159.52,"375-450","Footpath"]
["Under pressure connection Body 375-450 NB.  Type 3/4 carriageway","DR107","nr",null,"375-450Type 3/4 CW",17637.45,"375-450","Type 3/4 CW"]
["Under pressure connection Body 375-450 NB.  Type 1/2 carriageway","DR108","nr",null,"375-450Type 1/2 CW",18098.16,"375-450","Type 1/2 CW"]
["Valves, hydrants and wash outs"]
["Install SV/FH/WO/Tee up to 4\" No Excavation'","DR110","nr",null,{"$f":"CONCATENATE(G284,H284)","v":"up to 63No excavation"},441.25,"up to 63","No excavation"]
["Install SV/FH/WO/Tee up to 4\" in Unmade","DR111","nr",null,"up to 63Unmade",616.16,"up to 63","Unmade"]
["Install SV/FH/WO/Tee up to 4\" in Footpath","DR112","nr",null,"up to 63Footpath",754.27,"up to 63","Footpath"]
["Install SV/FH/WO/Tee up to 4\" in Type 3/4 carriageway","DR113","nr",null,"up to 63Type 3/4 CW",798.18,"up to 63","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 4\" in Type 1/2 carriageway","DR114","nr",null,"up to 63Type 1/2 CW",839.09,"up to 63","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 4\" No Excavation'","DR110","nr",null,"64 to 90No excavation",441.25,"64 to 90","No excavation"]
["Install SV/FH/WO/Tee up to 4\" in Unmade","DR111","nr",null,"64 to 90Unmade",616.16,"64 to 90","Unmade"]
["Install SV/FH/WO/Tee up to 4\" in Footpath","DR112","nr",null,"64 to 90Footpath",754.27,"64 to 90","Footpath"]
["Install SV/FH/WO/Tee up to 4\" in Type 3/4 carriageway","DR113","nr",null,"64 to 90Type 3/4 CW",798.18,"64 to 90","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 4\" in Type 1/2 carriageway","DR114","nr",null,"64 to 90Type 1/2 CW",839.09,"64 to 90","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 4\" No Excavation'","DR110","nr",null,"91 to 125No excavation",441.25,"91 to 125","No excavation"]
["Install SV/FH/WO/Tee up to 4\" in Unmade","DR111","nr",null,"91 to 125Unmade",616.16,"91 to 125","Unmade"]
["Install SV/FH/WO/Tee up to 4\" in Footpath","DR112","nr",null,"91 to 125Footpath",754.27,"91 to 125","Footpath"]
["Install SV/FH/WO/Tee up to 4\" in Type 3/4 carriageway","DR113","nr",null,{"$f":"CONCATENATE(G297,H297)","v":"91 to 125Type 3/4 CW"},798.18,"91 to 125","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 4\" in Type 1/2 carriageway","DR114","nr",null,"91 to 125Type 1/2 CW",839.09,"91 to 125","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 6\" No Excavation","DR115","nr",null,"126 to 180No excavation",680.02,"126 to 180","No excavation"]
["Install SV/FH/WO/Tee up to 6\" in Unmade","DR116","nr",null,"126 to 180Unmade",681.6,"126 to 180","Unmade"]
["Install SV/FH/WO/Tee up to 6\" in Footpath","DR117","nr",null,"126 to 180Footpath",821.94,"126 to 180","Footpath"]
["Install SV/FH/WO/Tee up to 6\" in Type 3/4 carriageway","DR118","nr",null,"126 to 180Type 3/4 CW",871.73,"126 to 180","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 6\" in Type 1/2 carriageway","DR119","nr",null,"126 to 180Type 1/2 CW",914.68,"126 to 180","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 9\" No Excavation","DR120","nr",null,"181 to 200No excavation",1043.9100000000001,"181 to 200","No excavation"]
["Install SV/FH/WO/Tee up to 9\" in Unmade","DR121","nr",null,"181 to 200Unmade",1044.97,"181 to 200","Unmade"]
["Install SV/FH/WO/Tee up to 9\" in Footpath","DR122","nr",null,"181 to 200Footpath",1197.3900000000001,"181 to 200","Footpath"]
["Install SV/FH/WO/Tee up to 9\" in Type 3/4 carriageway","DR123","nr",null,"181 to 200Type 3/4 CW",1255.81,"181 to 200","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 9\" in Type 1/2 carriageway","DR124","nr",null,"181 to 200Type 1/2 CW",1301.19,"181 to 200","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 9\" No Excavation","DR120","nr",null,"201 to 250No excavation",1043.9100000000001,"201 to 250","No excavation"]
["Install SV/FH/WO/Tee up to 9\" in Unmade","DR121","nr",null,"201 to 250Unmade",1044.97,"201 to 250","Unmade"]
["Install SV/FH/WO/Tee up to 9\" in Footpath","DR122","nr",null,"201 to 250Footpath",1197.3900000000001,"201 to 250","Footpath"]
["Install SV/FH/WO/Tee up to 9\" in Type 3/4 carriageway","DR123","nr",null,"201 to 250Type 3/4 CW",1255.81,"201 to 250","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 9\" in Type 1/2 carriageway","DR124","nr",null,"201 to 250Type 1/2 CW",1301.19,"201 to 250","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 12\" No Excavation","DR125","nr",null,"251 to 355No excavation",2156.1,"251 to 355","No excavation"]
["Install SV/FH/WO/Tee up to 12\" in Unmade","DR126","nr",null,"251 to 355Unmade",2371.79,"251 to 355","Unmade"]
["Install SV/FH/WO/Tee up to 12\" in Footpath","DR127","nr",null,"251 to 355Footpath",2554.67,"251 to 355","Footpath"]
["Install SV/FH/WO/Tee up to 12\" in Type 3/4 carriageway","DR128","nr",null,"251 to 355Type 3/4 CW",2638.34,"251 to 355","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 12\" in Type 1/2 carriageway","DR129","nr",null,"251 to 355Type 1/2 CW",2688.38,"251 to 355","Type 1/2 CW"]
["Install SV/FH/WO/Tee up to 18\" No Excavation","DR130","nr",null,"356 to 450No excavation",7673.99,"356 to 450","No excavation"]
["Install SV/FH/WO/Tee up to 18\" in Unmade","DR131","nr",null,"356 to 450Unmade",8262.5300000000007,"356 to 450","Unmade"]
["Install SV/FH/WO/Tee up to 18\" in Footpath","DR132","nr",null,"356 to 450Footpath",8714.08,"356 to 450","Footpath"]
["Install SV/FH/WO/Tee up to 18\" in Type 3/4 carriageway","DR133","nr",null,"356 to 450Type 3/4 CW",8815.06,"356 to 450","Type 3/4 CW"]
["Install SV/FH/WO/Tee up to 18\" in Type 1/2 carriageway","DR134","nr",null,"356 to 450Type 1/2 CW",11274.92,"356 to 450","Type 1/2 CW"]
["Pressure Test  & Chlorination"]
["Pressure Test  & Chlorination","DR141","nr",null,null,874.53]
["Trial hole"]
["Trial hole in unmade","DR142","m3",null,"Unmade",149.38,null,"Unmade"]
["Trial hole in Footpath","DR143","m3",null,"Footpath",278.29000000000002,null,"Footpath"]
["Trial hole in type 3/4","DR144","m3",null,"Type 3/4 CW",405.99,null,"Type 3/4 CW"]
["Trial hole in type 2/1","DR145","m3",null,"Type 1/2 CW",594.05999999999995,null,"Type 1/2 CW"]
["Traffic lights"]
["2 way temporary traffic lights","TL2","sum",null,null,338.4]
[]
["Concatenate for PE SOW connection"]
[]
[{"$f":"CONCATENATE('PE SOW'!C37,'PE SOW'!C20)","v":"150-200Type 1/2 CW"}]
[]
["Concatenate for PE SOW mains length"]
[]
[{"$f":"CONCATENATE('PE SOW'!H31,'PE SOW'!C20)","v":"126 to 180Type 1/2 CW"}]
[]
["UPT cost",null,{"$f":"VLOOKUP(A336,E263:F282,2,FALSE)","v":4693.13}]
["Mains length cost if above 2m",null,{"$f":"(VLOOKUP(A340,E222:F261,2,FALSE))*'PE SOW'!C31","v":0}]
["Mains length cost if below 2m",null,{"$f":"(VLOOKUP(A340,E222:F261,2,FALSE))*2","v":394.74}]
["Mains length cost - pull through cell",null,{"$f":"IF(C343<2,C344,C343)","v":394.74}]
["Traffic management cost",null,{"$f":"F332","v":338.4}]
["Valve/wash out cost",null,{"$f":"VLOOKUP(A340,E284:F323,2,FALSE)*3","v":2744.04},null,"(3 assumed)"]
["Trial hole cost",null,{"$f":"VLOOKUP('PE SOW'!C20,E327:F330,2,FALSE)","v":594.05999999999995}]
[]
["B2B, pressure test and sampling uplift (adjustment post audit and testing)"]
[]
["Total of charges above",null,{"$f":"C342+SUM(C345:C348)","v":8764.369999999999}]
["Pressure test charge",null,672.74]
["Sampling charge",null,187.47]
["B2B average",null,588.70000000000005]
["Total",null,{"$f":"C352+C353+C354+C355","v":10213.279999999999}]
[]
["Pipe diameter drop down options"]
["up to 63"]
["64 to 90"]
["91 to 125"]
["126 to 180"]
["181 to 200"]
["201 to 250"]
["251 to 355"]
["356 to 450"]