{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["I&C","Summary","SoWR","OE","AC","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"I&C","index":0,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Next Page"]
["Shire Lodge Cemetery Extension - Civil Works"]
[]
["Instructions and Contents"]
[]
["Introduction"]
[{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",CONCATENATE(\"This document forms the Pricing Schedule for Corby Borough Council’s \",('I&C'!$A$2),\" requirement and will be included as an appendix to the Contract between \",(SoWR!$C$4),\" and Corby Borough Council.\"),CONCATENATE(\"This document forms the Pricing Schedule for Corby Borough Council’s \",('I&C'!$A$2),\" requirement and will be included as an appendix to the Contract between The Supplier and Corby Borough Council.\")),\"\")","v":"This document forms the Pricing Schedule for Corby Borough Council’s Shire Lodge Cemetery Extension - Civil Works requirement and will be included as an appendix to the Contract between The Supplier and Corby Borough Council."}]
[]
["Instructions"]
[{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",CONCATENATE(\"All areas which require \",(SoWR!$C$4),\" to provide information are clearly identified by a yellow highlight, as indicated below. Please note, the yellow highlight will disapear once data has been entered.\"),CONCATENATE(\"All areas which require The Supplier to provide information are clearly identified by a yellow highlight, as indicated below. Please note, the yellow highlight will disapear once data has been entered.\")),\"\")","v":"All areas which require The Supplier to provide information are clearly identified by a yellow highlight, as indicated below. Please note, the yellow highlight will disapear once data has been entered."}]
[]
[]
["You can move between the different pages of this document by clicking on text which is underlined in blue, as indicated in the example below."]
["Example Text"]
[]
["You can return to this Contents page at any time by clicking on the word Contents and to the next or previous page by clicking on the words Next Page or Previous Page at the top of each page.\n\nWhere a section of underlined blue text references a specific page, as in the Contents list below (e.g. Pricing Summary), clicking on that text will take you directly to that page.\n\nPlease make sure to fill in all the relevant details and we look forward to receiving your submission."]
[]
["Contents (click the relevant word to go to that page)"]
["Pricing Summary"]
["Schedule of Works/Rates"]
["Optional Extras"]
["Additional Costs"]

{"sheet":"Summary","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Shire Lodge Cemetery Extension - Civil Works"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",(SoWR!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Pricing Summary Total carried to Evaluation"]
["Pricing Summary"]
[]
[null,null,"Summary Section Headings","Section Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(#REF!<>\"\",D10<>\"\",D11<>\"\",D12<>\"\"),SUM(D10:D12)*D13+SUM(D10:D12),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C10<>\"\",SUBTOTAL(103,$C$10:$C10),\"\"),\"\")","v":1},"Schedule of Works/Rates - Detailed Bill of Quantities",{"$f":"IFERROR(IF(SoWR!G15<>\"\",SUM(SoWR!G15),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C11<>\"\",SUBTOTAL(103,$C$10:$C11),\"\"),\"\")","v":2},"Optional Extras",{"$f":"IFERROR(IF(OE!G15<>\"\",SUM(OE!G15),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C12<>\"\",SUBTOTAL(103,$C$10:$C12),\"\"),\"\")","v":3},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!I13<>\"\",SUM(AC!I13),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C13<>\"\",SUBTOTAL(103,$C$10:$C13),\"\"),\"\")","v":4},"Contingency",0.15]

{"sheet":"SoWR","index":2,"n_rows":139,"n_cols":7,"rows_kept":139,"cut":false,"hidden":false,"merged":[[106,1,106,2],[112,1,112,2],[121,1,121,2],[125,1,125,2],[135,1,135,2],[33,1,33,2],[40,1,40,2],[51,1,51,2],[70,1,70,2],[78,1,78,2],[11,0,11,6],[16,1,16,2],[13,1,13,5],[1,0,1,6],[5,0,5,6],[4,2,4,6],[3,2,3,6],[7,0,7,6],[9,0,9,6]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Shire Lodge Cemetery Extension - Civil Works"}]
[]
["Supplier:"]
["Sub-Heading:",null,"Schedule of Works/Rates - Detailed Bill of Quantities"]
["Pricing Schedule"]
[]
["The total of this Schedule will be carried to the Summary."]
[]
["The Cost (ex VAT) is to include for all labour and materials necessary for carrying out the works described during working hours defined in the Council's Specification and associated documents and is to include a proportion for preliminary costs, overheads and profit."]
[]
["Each item is to be priced, thereafter the spreadsheet will extend this rate out, for the quantity required by the Council."]
[]
[null,"Schedule Costs",null,null,null,null,"Total"]
[null,"Sub-Total of Schedule Costs carried to Summary",null,null,null,null,{"$f":"IFERROR(IF(OR(G18<>\"\",G35<>\"\",G42<>\"\",G53<>\"\",G72<>\"\",G80<>\"\",G108<>\"\",G114<>\"\",G123<>\"\",G127<>\"\",G137<>\"\"),SUM(G18,G35,G42,G53,G72,G80,G108,G114,G123,G127,G137),\"\"),\"\")","v":""}]
[]
[null,"Preparatory Works",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D19<>\"\",D20<>\"\",D21<>\"\",D22<>\"\",D23<>\"\",D24<>\"\",D25<>\"\",D26<>\"\",D27<>\"\",D28<>\"\",D29<>\"\",D30<>\"\",D31<>\"\",D32<>\"\"),SUM(D19:D32),\"\"),\"\")","v":2730},{"$f":"IFERROR(IF(OR(E19<>\"\",E20<>\"\",E21<>\"\",E22<>\"\",E23<>\"\",E24<>\"\",E25<>\"\",E26<>\"\",E27<>\"\",E28<>\"\",E29<>\"\",E30<>\"\",E31<>\"\",E32<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F19<>\"\",F20<>\"\",F21<>\"\",F22<>\"\",F23<>\"\",F24<>\"\",F25<>\"\",F26<>\"\",F27<>\"\",F28<>\"\",F29<>\"\",F30<>\"\",F31<>\"\",F32<>\"\"),SUM(F19:F32),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G19<>\"\",G20<>\"\",G21<>\"\",G22<>\"\",G23<>\"\",G24<>\"\",G25<>\"\",G26<>\"\",G27<>\"\",G28<>\"\",G29<>\"\",G30<>\"\",G31<>\"\",G32<>\"\"),SUM(G19:G32),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C19<>\"\",SUBTOTAL(103,$C$19:$C19),\"\"),\"\")","v":1},"Prior to commencement the Contractor is to arrange their own photographic condition survey to all work areas surrounding the location of the works. Including but not limited to buildings and structures, other boundaries, fixtures and fittings, highways and hardstandings, utilities and services, trees and soft landscaping. A copy of this survey is to be provided to the Project Manager at commencement of the contract, to be relied on should any dilapidation or claim arise over the course of the works.",1,"Sum",null,{"$f":"IFERROR(IF(AND(D19<>\"\",F19<>\"\"),SUM(D19*F19),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C20<>\"\",SUBTOTAL(103,$C$19:$C20),\"\"),\"\")","v":2},"Allow to identify and uncover, as necessary, all live services disclosed in the Pre-construction information pertinent to the works locations, CAT scanning as required.",1,"Sum",null,{"$f":"IFERROR(IF(AND(D20<>\"\",F20<>\"\"),SUM(D20*F20),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C21<>\"\",SUBTOTAL(103,$C$19:$C21),\"\"),\"\")","v":3},"Works directly over or nearby to live services are to be undertaken in accordance with the utility providers working practices as closely as possible. The Contractor's approach generally with services must ensure, as a minimum, the access to or protection around existing services is not made any worse than it is in its existing arrangement across the site.",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C22<>\"\",SUBTOTAL(103,$C$19:$C22),\"\"),\"\")","v":4},"Allow for all reasonable and foreseeable temporary works and traffic management, including but not limited to, key items discussed below:",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C23<>\"\",SUBTOTAL(103,$C$19:$C23),\"\"),\"\")","v":5},"Necessary diversion signage to divert existing pedestrian and vehicular routes as necessary.",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C24<>\"\",SUBTOTAL(103,$C$19:$C24),\"\"),\"\")","v":6},"Excavations around retained existing buildings and structures so as to not undermine foundations.",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$19:$C25),\"\"),\"\")","v":7},"Temporary shoring and use of excavation boxes in trenches, as required.",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C26<>\"\",SUBTOTAL(103,$C$19:$C26),\"\"),\"\")","v":8},"Excavation, storage of excavated material and construction of 5m wide access link road of 200mm deep compacted MOT Type 1 on geotextile between two \"working areas\".",260,"m2",null,""]
[null,{"$f":"IFERROR(IF(C27<>\"\",SUBTOTAL(103,$C$19:$C27),\"\"),\"\")","v":9},"Upon completion of works removal of complete link road and reinstatement of ground to generally an equal standard to that prior to the works being undertaken. ",260,"m2",null,""]
[null,{"$f":"IFERROR(IF(C28<>\"\",SUBTOTAL(103,$C$19:$C28),\"\"),\"\")","v":10},"Provide, install, maintain and remove upon completion 2.0m high \"Heras\" style fencing around the two working areas and link road",1200,"m",null,""]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$19:$C29),\"\"),\"\")","v":11},"Provision of temporary welfare facilities for the duration of the works for use by Principal Contractor and any sub-contractors",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C30<>\"\",SUBTOTAL(103,$C$19:$C30),\"\"),\"\")","v":12},"Excavation, preparation, cable and pipe laying and installation of appropriate termination point and or cabinet for temporary water and electricity supplies all to the statutory undertakers requirements. ",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C31<>\"\",SUBTOTAL(103,$C$19:$C31),\"\"),\"\")","v":13},"Allowance for all excavation, ducting and works to transfer any temporary supplies to the new welfare facility ",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C32<>\"\",SUBTOTAL(103,$C$19:$C32),\"\"),\"\")","v":14},"Allowance for ditch clearance to original levels and grade adjacent to existing cemetery and two way lights and all other traffic management, arisings to be deposited adjacent to ditch",1000,"m",null,""]
[]
[null,"Strip Out and Removal",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D36<>\"\",D37<>\"\",D38<>\"\",D39<>\"\"),SUM(D36:D39),\"\"),\"\")","v":401},{"$f":"IFERROR(IF(OR(E36<>\"\",E37<>\"\",E38<>\"\",E39<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F36<>\"\",F37<>\"\",F38<>\"\",F39<>\"\"),SUM(F36:F39),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G36<>\"\",G37<>\"\",G38<>\"\",G39<>\"\"),SUM(G36:G39),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C36<>\"\",SUBTOTAL(103,$C$36:$C36),\"\"),\"\")","v":1},"Remove existing boundary fencing at three locations (two new road accesses and one pedestrian) to permit the proposed works to proceed as shown on tender specification drawings. Fence to be left on-site for future use by Council ",30,"m",null,{"$f":"IFERROR(IF(AND(D36<>\"\",F36<>\"\"),SUM(D36*F36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C37<>\"\",SUBTOTAL(103,$C$36:$C37),\"\"),\"\")","v":2},"Carefully remove existing goal wall fencing and break out posts as shown on tender specification drawings for future use by Council ",120,"m",null,{"$f":"IFERROR(IF(AND(D37<>\"\",F37<>\"\"),SUM(D37*F37),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C38<>\"\",SUBTOTAL(103,$C$36:$C38),\"\"),\"\")","v":3},"Allow to carefully excavate shrubs and bund at three locations (two new road accesses and one pedestrian) to permit the proposed works to proceed as shown on tender specification drawings. Allow for battering bund that remains either side of access. Shrubs to be shredded and retained on-site in location agreed with client. As dug bund material to be retained on site and used to create perimeter bund.",250,"m3",null,""]
[null,{"$f":"IFERROR(IF(C39<>\"\",SUBTOTAL(103,$C$36:$C39),\"\"),\"\")","v":4},"Removal of surplus as dug material off-site to licensed facility (provisional) ",1,"per m2",null,""]
[]
[null,"Site Entrance Alterations",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D43<>\"\",D44<>\"\",D45<>\"\",D46<>\"\",D47<>\"\",D48<>\"\",D49<>\"\",D50<>\"\"),SUM(D43:D50),\"\"),\"\")","v":2594},{"$f":"IFERROR(IF(OR(E43<>\"\",E44<>\"\",E45<>\"\",E46<>\"\",E47<>\"\",E48<>\"\",E49<>\"\",E50<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F43<>\"\",F44<>\"\",F45<>\"\",F46<>\"\",F47<>\"\",F48<>\"\",F49<>\"\",F50<>\"\"),SUM(F43:F50),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G43<>\"\",G44<>\"\",G45<>\"\",G46<>\"\",G47<>\"\",G48<>\"\",G49<>\"\",G50<>\"\"),SUM(G43:G50),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C43<>\"\",SUBTOTAL(103,$C$43:$C43),\"\"),\"\")","v":1},"Breakout tarmac and kerbs to install close boarded fence on timber posts and double gates to create perimeter fence around stonemasons yard as shown on tender specification drawings. ",35,"m",null,{"$f":"IFERROR(IF(AND(D43<>\"\",F43<>\"\"),SUM(D43*F43),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C44<>\"\",SUBTOTAL(103,$C$43:$C44),\"\"),\"\")","v":2},"Install new kerbs as shown on tender specification to accommodate stonemasons perimeter fencing. ",30,"m",null,{"$f":"IFERROR(IF(AND(D44<>\"\",F44<>\"\"),SUM(D44*F44),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C45<>\"\",SUBTOTAL(103,$C$43:$C45),\"\"),\"\")","v":3},"Fell and remove Poplar tree (T19 on Ramms Sanderson tree report) and remove timber and chippings from site",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C46<>\"\",SUBTOTAL(103,$C$43:$C46),\"\"),\"\")","v":4},"Provide and install 100mm diameter 2.8m long posts and securely affix sign provided by the Council.",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C47<>\"\",SUBTOTAL(103,$C$43:$C47),\"\"),\"\")","v":5},"Install new signs and road markings at site entrance as shown on tender specification Drg No 25264_02_090_01 ",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C48<>\"\",SUBTOTAL(103,$C$43:$C48),\"\"),\"\")","v":6},"Excavate and install 50mm duct with draw cord at 600mm depth and 3 draw pits for CCTV extension. ",400,"m",null,""]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$C$43:$C49),\"\"),\"\")","v":7},"Plane off 50mm of existing wearing course, sweep and clean as necessary, apply bit tac coat and lay 50mm wearing course",2125,"m2",null,""]
[null,{"$f":"IFERROR(IF(C50<>\"\",SUBTOTAL(103,$C$43:$C50),\"\"),\"\")","v":8},"Mark out 45 car parking bays inc 1 disabled bay in accordance with LHA standards apart from the disabled bays which should be a total of 3.6 x 6.2m with no hatching ",1,"Sum",null,""]
[]
[null,"Car Park Extension",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D54<>\"\",D55<>\"\",D56<>\"\",D57<>\"\",D58<>\"\",D59<>\"\",D60<>\"\",D61<>\"\",D62<>\"\",D63<>\"\",D64<>\"\",D65<>\"\",D66<>\"\",D67<>\"\",D68<>\"\",D69<>\"\"),SUM(D54:D69),\"\"),\"\")","v":4023},{"$f":"IFERROR(IF(OR(E54<>\"\",E55<>\"\",E56<>\"\",E57<>\"\",E58<>\"\",E59<>\"\",E60<>\"\",E61<>\"\",E62<>\"\",E63<>\"\",E64<>\"\",E65<>\"\",E66<>\"\",E67<>\"\",E68<>\"\",E69<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F54<>\"\",F55<>\"\",F56<>\"\",F57<>\"\",F58<>\"\",F59<>\"\",F60<>\"\",F61<>\"\",F62<>\"\",F63<>\"\",F64<>\"\",F65<>\"\",F66<>\"\",F67<>\"\",F68<>\"\",F69<>\"\"),SUM(F54:F69),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G54<>\"\",G55<>\"\",G56<>\"\",G57<>\"\",G58<>\"\",G59<>\"\",G60<>\"\",G61<>\"\",G62<>\"\",G63<>\"\",G64<>\"\",G65<>\"\",G66<>\"\",G67<>\"\",G68<>\"\",G69<>\"\"),SUM(G54:G69),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C54<>\"\",SUBTOTAL(103,$C$54:$C54),\"\"),\"\")","v":1},"Carry out excavation works for the proposed car park and footpath(s) as shown on tender specification drawings. Material to be stored in working area and used to create perimeter bund.",1440,"m3",null,{"$f":"IFERROR(IF(AND(D54<>\"\",F54<>\"\"),SUM(D54*F54),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C55<>\"\",SUBTOTAL(103,$C$54:$C55),\"\"),\"\")","v":2},"Break out existing footway, inc bin, and dispose of arisings at licensed waste facility",36,"m3",null,{"$f":"IFERROR(IF(AND(D55<>\"\",F55<>\"\"),SUM(D55*F55),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$C$54:$C56),\"\"),\"\")","v":3},"Review car park design and provide a setting out drawing for car park and associated drainage to agree with existing levels ",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C57<>\"\",SUBTOTAL(103,$C$54:$C57),\"\"),\"\")","v":4},"Excavate and install 1.8m wide bitumous footpath with timber edgings as shown on tender specification drawings around outside of car park extension and tie into existing and make good.",145,"m",null,""]
[null,{"$f":"IFERROR(IF(C58<>\"\",SUBTOTAL(103,$C$54:$C58),\"\"),\"\")","v":5},"Excavate and install 1.8m wide bitumous footpath with concrete edgings as shown on tender specification drawings from car park to cemetery and tie into existing and make good.",45,"m",null,""]
[null,{"$f":"IFERROR(IF(C59<>\"\",SUBTOTAL(103,$C$54:$C59),\"\"),\"\")","v":6},"Excavate and install 1.8m wide bitumous footpath and concrete edgings adjacent to new access road as shown on tender specification drawings from car park to cemetery and tie into existing and make good.",20,"m",null,""]
[null,{"$f":"IFERROR(IF(C60<>\"\",SUBTOTAL(103,$C$54:$C60),\"\"),\"\")","v":7},"Break out existing kerbs and dispose of arisings at licenced waste facility, create access road and kerbs into new car park and tie into existing road as shown on tender specification drawings",75,"m2",null,""]
[null,{"$f":"IFERROR(IF(C61<>\"\",SUBTOTAL(103,$C$54:$C61),\"\"),\"\")","v":8},"Undertake additional excavation and install car park 150mm sewer with s class bed and surround, backfill with MOT Type 1 and ancillaries inc control chamber as shown on tender specification drawings",35,"m",null,""]
[null,{"$f":"IFERROR(IF(C62<>\"\",SUBTOTAL(103,$C$54:$C62),\"\"),\"\")","v":9},"Undertake additional excavation and install car park 180m3 of modular storage as per manufacturers specification with bed and surround, backfill with MOT Type 1 and ancillaries to connect to existing cemetery drainage as shown on tender specification drawings",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C63<>\"\",SUBTOTAL(103,$C$54:$C63),\"\"),\"\")","v":10},"Undertake additional excavation and install gully traps, covers and associated 100mm diameter drainage with class s bed and surround, backfill with MOT type 1 and connection to main sewer as shown on tender specification drawings and bidders drawing",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$C$54:$C64),\"\"),\"\")","v":11},"Prepare and lay bitumous car park surface as shown on tender specification drawings",900,"m2",null,""]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$C$54:$C65),\"\"),\"\")","v":12},"Prepare and lay block paving to create car parking spaces with markings in accordance with LHA standards apart from the disabled bays which should be a total of 3.6 x 6.2m with no hatching and associated kerbs as shown on tender specification drawings",1125,"m2",null,""]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$C$54:$C66),\"\"),\"\")","v":13},"Install advisory signs on 75mm posts as per tender specification drawings",5,"nr",null,""]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$C$54:$C67),\"\"),\"\")","v":14},"Install 2.1m high palisade security fencing as shown on tender specification drawings around car park extension allowing for 1no. double gates and 2no. pedestrian gates with stays",140,"m",null,""]
[null,{"$f":"IFERROR(IF(C68<>\"\",SUBTOTAL(103,$C$54:$C68),\"\"),\"\")","v":15},"Excavate and install 0.6m deep x 1.2m x 1.2m concrete pad and anchor points for CCTV column . Include 100mm duct through pad all as per manufacturers requirements",2,"nr",null,{"$f":"IFERROR(IF(AND(D68<>\"\",F68<>\"\"),SUM(D68*F68),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C69<>\"\",SUBTOTAL(103,$C$54:$C69),\"\"),\"\")","v":16},"Excavate and install 500mm high 100mm post and knee rail as shown on tender specification drawings.",52,"m",null,""]
[]
[null,"Gas Main Diversion",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D73<>\"\",D74<>\"\",D75<>\"\",D76<>\"\",D77<>\"\"),SUM(D73:D77),\"\"),\"\")","v":392},{"$f":"IFERROR(IF(OR(E73<>\"\",E74<>\"\",E75<>\"\",E76<>\"\",E77<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F73<>\"\",F74<>\"\",F75<>\"\",F76<>\"\",F77<>\"\"),SUM(F73:F77),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G73<>\"\",G74<>\"\",G75<>\"\",G76<>\"\",G77<>\"\"),SUM(G73:G77),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C73<>\"\",SUBTOTAL(103,$C$73:$C73),\"\"),\"\")","v":1},"Excavate for gas main diversion with 600mm wide trench all as per Cadent requirements",130,"m",null,{"$f":"IFERROR(IF(AND(D73<>\"\",F73<>\"\"),SUM(D73*F73),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C74<>\"\",SUBTOTAL(103,$C$73:$C74),\"\"),\"\")","v":2},"Provide bed and surround and connection pits all as per Cadent requirements",130,"m",null,{"$f":"IFERROR(IF(AND(D74<>\"\",F74<>\"\"),SUM(D74*F74),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C75<>\"\",SUBTOTAL(103,$C$73:$C75),\"\"),\"\")","v":3},"Backfill as dug material and compact all as per Cadent requirements",130,"m",null,""]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$C$73:$C76),\"\"),\"\")","v":4},"Upon completion of works and working area reinstatement of ground to generally an equal standard to that prior to the works being undertaken. ",1,"sum",null,""]
[null,{"$f":"IFERROR(IF(C77<>\"\",SUBTOTAL(103,$C$73:$C77),\"\"),\"\")","v":5},"Excavate for and remove abandoned gas service",1,"sum",null,""]
[]
[null,"Cemetery Extension",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D81<>\"\",D82<>\"\",D83<>\"\",D84<>\"\",D85<>\"\",D86<>\"\",D87<>\"\",D88<>\"\",D89<>\"\",D90<>\"\",D91<>\"\",D92<>\"\",D93<>\"\",D94<>\"\",D95<>\"\",D96<>\"\",D97<>\"\",D98<>\"\",D99<>\"\",D100<>\"\",D101<>\"\",D102<>\"\",D103<>\"\",D104<>\"\",D105<>\"\"),SUM(D81:D105),\"\"),\"\")","v":9022},{"$f":"IFERROR(IF(OR(E81<>\"\",E82<>\"\",E83<>\"\",E84<>\"\",E85<>\"\",E86<>\"\",E87<>\"\",E88<>\"\",E89<>\"\",E90<>\"\",E91<>\"\",E92<>\"\",E93<>\"\",E94<>\"\",E95<>\"\",E96<>\"\",E97<>\"\",E98<>\"\",E99<>\"\",E100<>\"\",E101<>\"\",E102<>\"\",E103<>\"\",E104<>\"\",E105<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F81<>\"\",F82<>\"\",F83<>\"\",F84<>\"\",F85<>\"\",F86<>\"\",F87<>\"\",F88<>\"\",F89<>\"\",F90<>\"\",F91<>\"\",F92<>\"\",F93<>\"\",F94<>\"\",F95<>\"\",F96<>\"\",F97<>\"\",F98<>\"\",F99<>\"\",F100<>\"\",F101<>\"\",F102<>\"\",F103<>\"\",F104<>\"\",F105<>\"\"),SUM(F81:F105),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G81<>\"\",G82<>\"\",G83<>\"\",G84<>\"\",G85<>\"\",G86<>\"\",G87<>\"\",G88<>\"\",G89<>\"\",G90<>\"\",G91<>\"\",G92<>\"\",G93<>\"\",G94<>\"\",G95<>\"\",G96<>\"\",G97<>\"\",G98<>\"\",G99<>\"\",G100<>\"\",G101<>\"\",G102<>\"\",G103<>\"\",G104<>\"\",G105<>\"\"),SUM(G81:G105),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C81<>\"\",SUBTOTAL(103,$C$81:$C81),\"\"),\"\")","v":1},"Carry out excavation works for the proposed roads and parking bays as shown on tender specification drawings to 600mm depth. Material to be stored in working area and used to create perimeter bund not exceeding 1.6m",1650,"m3",null,{"$f":"IFERROR(IF(AND(D81<>\"\",F81<>\"\"),SUM(D81*F81),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C82<>\"\",SUBTOTAL(103,$C$81:$C82),\"\"),\"\")","v":2},"Carry out excavation works for the proposed cemetery paths and footpath(s) as shown on tender specification drawings to 250mm depth. Material to be stored in working area and used to create perimeter bund.",290,"m3",null,{"$f":"IFERROR(IF(AND(D82<>\"\",F82<>\"\"),SUM(D82*F82),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C83<>\"\",SUBTOTAL(103,$C$81:$C83),\"\"),\"\")","v":3},"Retain excavated top soil in location within site and agreed with client for use by Council upon completion of works ",1,"per m3",null,""]
[null,{"$f":"IFERROR(IF(C84<>\"\",SUBTOTAL(103,$C$81:$C84),\"\"),\"\")","v":4},"Break out existing kerbs and dispose of arisings at licenced waste facility, create access roads and kerbs and tie into existing road as shown on tender specification drawings",50,"m2",null,""]
[null,{"$f":"IFERROR(IF(C85<>\"\",SUBTOTAL(103,$C$81:$C85),\"\"),\"\")","v":5},"Review extension design and provide a setting out drawing for car park and associated drainage to agree with existing levels ",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C86<>\"\",SUBTOTAL(103,$C$81:$C86),\"\"),\"\")","v":6},"Break out existing kerbs, create cemetery roads and kerbs including rumble strips and tie into existing road as shown on tender specification drawings",2750,"m2",null,""]
[null,{"$f":"IFERROR(IF(C87<>\"\",SUBTOTAL(103,$C$81:$C87),\"\"),\"\")","v":7},"Install 2m wide 50mm deep breedon gravel cemetery paths with crossfall on top of 150mm MOT Type 1 contained within Metal Edging through cemetery areas and memorial garden and as shown on tender specification drawings",925,"m2",null,""]
[null,{"$f":"IFERROR(IF(C88<>\"\",SUBTOTAL(103,$C$81:$C88),\"\"),\"\")","v":8},"Prepare and lay block paving to create visitor car parking spaces with associated kerbs as shown on tender specification drawings",420,"m2",null,""]
[null,{"$f":"IFERROR(IF(C89<>\"\",SUBTOTAL(103,$C$81:$C89),\"\"),\"\")","v":9},"Undertake additional excavation and install extension 150mm sewer with class s bed and surround, type 1 backfill and ancillaries to connect to existing cemetery drainage as shown on tender specification drawings",265,"m",null,""]
[null,{"$f":"IFERROR(IF(C90<>\"\",SUBTOTAL(103,$C$81:$C90),\"\"),\"\")","v":10},"Undertake additional excavation and install extension 225mm sewer with class s bed and surround, type 1 backfill and ancillaries to connect to existing cemetery drainage as shown on tender specification drawings",210,"m",null,""]
[null,{"$f":"IFERROR(IF(C91<>\"\",SUBTOTAL(103,$C$81:$C91),\"\"),\"\")","v":11},"Undertake additional excavation and install extension 300mm sewer with class s bed and surround, type 1 backfill and ancillaries including control chamber to connect to existing cemetery drainage as shown on tender specification drawings",28,"m",null,""]
[null,{"$f":"IFERROR(IF(C92<>\"\",SUBTOTAL(103,$C$81:$C92),\"\"),\"\")","v":12},"Undertake additional excavation and install cemetery 240m3 storage as per manufacturers specification with bed and surround and ancillaries to connect to existing cemetery drainage as shown on tender specification drawings",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C93<>\"\",SUBTOTAL(103,$C$81:$C93),\"\"),\"\")","v":13},"Undertake additional excavation and install gully traps, covers and associated 100mm diameter drainage with class s bed and surround, type 1 backfill and connection to main sewer as shown on tender specification drawings",44,"nr",null,""]
[null,{"$f":"IFERROR(IF(C94<>\"\",SUBTOTAL(103,$C$81:$C94),\"\"),\"\")","v":14},"Undertake additional excavation and install 150mm diameter land drains and ancillaries under proposed headstone strip and tie into trench soakaway and location agreed with client",300,"m",null,""]
[null,{"$f":"IFERROR(IF(C95<>\"\",SUBTOTAL(103,$C$81:$C95),\"\"),\"\")","v":15},"Undertake additional excavation and install 100m3 trench soakaway using Type 1 contained in geotextile under southern boundary to receive land drains under proposed headstone strip",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C96<>\"\",SUBTOTAL(103,$C$81:$C96),\"\"),\"\")","v":16},"Undertake additional excavation and install 32mm water pipework and tails with mechanical cap ends for standpipes",750,"m",null,""]
[null,{"$f":"IFERROR(IF(C97<>\"\",SUBTOTAL(103,$C$81:$C97),\"\"),\"\")","v":17},"Install Tower Standpipe or similar approved, reinstate and commission ",12,"nr",null,""]
[null,{"$f":"IFERROR(IF(C98<>\"\",SUBTOTAL(103,$C$81:$C98),\"\"),\"\")","v":18},"Install 100mm deep 1.5m x 1.2m concrete pads with timber edgings on 150mm MOT Type 1 to form bases for bins",6,"nr",null,""]
[null,{"$f":"IFERROR(IF(C99<>\"\",SUBTOTAL(103,$C$81:$C99),\"\"),\"\")","v":19},"Set out headstone strips and provide granite sett, bedded on concrete and flush with finished surface, at either end of headstone strip.",60,"nr",null,""]
[null,{"$f":"IFERROR(IF(C100<>\"\",SUBTOTAL(103,$C$81:$C100),\"\"),\"\")","v":20},"Install advisory signs on 75mm posts as per tender specification drawings",7,"nr",null,""]
[null,{"$f":"IFERROR(IF(C101<>\"\",SUBTOTAL(103,$C$81:$C101),\"\"),\"\")","v":21},"Install 2.1m high palisade security fencing as shown on tender specification drawings around extension allowing for 2no. double gates and 2no. pedestrian gates with stays",550,"m",null,""]
[null,{"$f":"IFERROR(IF(C102<>\"\",SUBTOTAL(103,$C$81:$C102),\"\"),\"\")","v":22},"Excavate and storage of excavated material and construction of Geosynthetics - Golpla Reinforced Pre-grown\nGrass or similar approved maintenance access installed in accordance with suppliers specification as shown on tender specification drawings.",75,"m2",null,""]
[null,{"$f":"IFERROR(IF(C103<>\"\",SUBTOTAL(103,$C$81:$C103),\"\"),\"\")","v":23},"Excavate and install 500mm high 100mm post and knee rail as shown on tender specification drawings.",575,"m",null,""]
[null,{"$f":"IFERROR(IF(C104<>\"\",SUBTOTAL(103,$C$81:$C104),\"\"),\"\")","v":24},"Install Broxap Derby Cemetery Recycling Bin\nor similar approved as per manufacturers installation guidance with paving and as shown on tender specification drawings",6,"nr",null,""]
[null,{"$f":"IFERROR(IF(C105<>\"\",SUBTOTAL(103,$C$81:$C105),\"\"),\"\")","v":25},"Install Stuart Garden Architecture - Barrington\ntimber bench or similar approved as per manufacturers installation guidance with paving and as shown on tender specification drawings",45,"nr",null,""]
[]
[null,"Access Road",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D109<>\"\",D110<>\"\",D111<>\"\"),SUM(D109:D111),\"\"),\"\")","v":580},{"$f":"IFERROR(IF(OR(E109<>\"\",E110<>\"\",E111<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F109<>\"\",F110<>\"\",F111<>\"\"),SUM(F109:F111),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G109<>\"\",G110<>\"\",G111<>\"\"),SUM(G109:G111),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C109<>\"\",SUBTOTAL(103,$C$109:$C109),\"\"),\"\")","v":1},"Break out existing knee rail fencing, car parking bays, excavation, storage of excavated material and construction of Geosynthetics - Golpla Reinforced Pre-grown\nGrass or similar approved access road installed in accordance with suppliers specification as shown on tender specification drawings.",442,"m2",null,{"$f":"IFERROR(IF(AND(D109<>\"\",F109<>\"\"),SUM(D109*F109),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C110<>\"\",SUBTOTAL(103,$C$109:$C110),\"\"),\"\")","v":2},"Excavation, storage of excavated material and installation of 2m wide 50mm deep breedon gravel cemetery paths with crossfall on top of 150mm MOT Type 1 and timber edgings adjacent to access road as shown on tender specification drawings. ",85,"m",null,{"$f":"IFERROR(IF(AND(D110<>\"\",F110<>\"\"),SUM(D110*F110),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C111<>\"\",SUBTOTAL(103,$C$109:$C111),\"\"),\"\")","v":3},"Remove existing timber post and rail fence and install new 3 rail post and rail fencing and install 1no pedestrian gate and 1no. vehicular gate with stays",53,"m",null,""]
[]
[null,"Welfare Facility",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D115<>\"\",D116<>\"\",D117<>\"\",D118<>\"\",D119<>\"\",D120<>\"\"),SUM(D115:D120),\"\"),\"\")","v":172},{"$f":"IFERROR(IF(OR(E115<>\"\",E116<>\"\",E117<>\"\",E118<>\"\",E119<>\"\",E120<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F115<>\"\",F116<>\"\",F117<>\"\",F118<>\"\",F119<>\"\",F120<>\"\"),SUM(F115:F120),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G115<>\"\",G116<>\"\",G117<>\"\",G118<>\"\",G119<>\"\",G120<>\"\"),SUM(G115:G120),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C115<>\"\",SUBTOTAL(103,$C$115:$C115),\"\"),\"\")","v":1},"Excavate to a depth of 600mm depth and construct bitumous surfaced staff car parking spaces as shown on tender specification drawings",42,"m2",null,{"$f":"IFERROR(IF(AND(D115<>\"\",F115<>\"\"),SUM(D115*F115),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C116<>\"\",SUBTOTAL(103,$C$115:$C116),\"\"),\"\")","v":2},"Construct welfare facility as shown on tender specification drawings and Development Specification\nfor New Welfare Building to approval of building regulations",1,"Sum",null,{"$f":"IFERROR(IF(AND(D116<>\"\",F116<>\"\"),SUM(D116*F116),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C117<>\"\",SUBTOTAL(103,$C$115:$C117),\"\"),\"\")","v":3},"Provide welfare facility with all services, heating and ensure all incoming connections are undertaken to specification and approval of the relevant utility company and building regs",1,"Sum",null,""]
[null,{"$f":"IFERROR(IF(C118<>\"\",SUBTOTAL(103,$C$115:$C118),\"\"),\"\")","v":4},"Excavate and install 100mm foul water drainage, manhole, ancillaries and connect to existing drainage to meet building regs requirements ",100,"m",null,""]
[null,{"$f":"IFERROR(IF(C119<>\"\",SUBTOTAL(103,$C$115:$C119),\"\"),\"\")","v":5},"Excavate and install 100mm surface water drainage, manhole, ancillaries and connect to existing drainage to meet building regs requirements ",20,"m",null,""]
[null,{"$f":"IFERROR(IF(C120<>\"\",SUBTOTAL(103,$C$115:$C120),\"\"),\"\")","v":6},"Prepare and lay bitumous footpath to create access to welfare facility with associated kerbs as shown on tender specification drawings",8,"m2",null,""]
[]
[null,"Building Refurbishment",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D124<>\"\"),SUM(D124:D124),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E124<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F124<>\"\"),SUM(F124:F124),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G124<>\"\"),SUM(G124:G124),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C124<>\"\",SUBTOTAL(103,$C$124:$C124),\"\"),\"\")","v":1},"Undertake refurbishment and alterations of existing toilets in accordance with Corporate Architects Development Specification for the Refurbishment of Existing Toilets ",1,"Sum",null,{"$f":"IFERROR(IF(AND(D124<>\"\",F124<>\"\"),SUM(D124*F124),\"\"),\"\")","v":""}]
[]
[null,"Open Space Corridor Hard Landscaping",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D128<>\"\",D129<>\"\",D130<>\"\",D131<>\"\",D132<>\"\",D133<>\"\",D134<>\"\"),SUM(D128:D134),\"\"),\"\")","v":565},{"$f":"IFERROR(IF(OR(E128<>\"\",E129<>\"\",E130<>\"\",E131<>\"\",E132<>\"\",E133<>\"\",E134<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F128<>\"\",F129<>\"\",F130<>\"\",F131<>\"\",F132<>\"\",F133<>\"\",F134<>\"\"),SUM(F128:F134),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G128<>\"\",G129<>\"\",G130<>\"\",G131<>\"\",G132<>\"\",G133<>\"\",G134<>\"\"),SUM(G128:G134),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C128<>\"\",SUBTOTAL(103,$C$128:$C128),\"\"),\"\")","v":1},"Excavate and Install 2m wide 50mm deep breedon gravel paths with crossfall on top of 150mm MOT Type 1 contained within timber edging and as shown on tender specification drawings",520,"m",null,{"$f":"IFERROR(IF(AND(D128<>\"\",F128<>\"\"),SUM(D128*F128),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C129<>\"\",SUBTOTAL(103,$C$128:$C129),\"\"),\"\")","v":2},"Install Timber Nature Trail Rubbing Posts -\nwww.naturesigndesign.co.uk or similar approved as per manufacturers installation guidance with and as shown on tender specification drawings",11,"nr",null,{"$f":"IFERROR(IF(AND(D129<>\"\",F129<>\"\"),SUM(D129*F129),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C130<>\"\",SUBTOTAL(103,$C$128:$C130),\"\"),\"\")","v":3},"Install Broxap Edale Rustic 3 Slat timber bench or similar approved as per manufacturers installation guidance with paving and as shown on tender specification drawings",13,"nr",null,""]
[null,{"$f":"IFERROR(IF(C131<>\"\",SUBTOTAL(103,$C$128:$C131),\"\"),\"\")","v":4},"Install Broxap K-Nine Post Mounted Dog Waste Bin as per manufacturers installation guidance with paving and as shown on tender specification drawings",2,"nr",null,""]
[null,{"$f":"IFERROR(IF(C132<>\"\",SUBTOTAL(103,$C$128:$C132),\"\"),\"\")","v":5},"Install Bat Boxes as shown on tender specification drawings",3,"nr",null,""]
[null,{"$f":"IFERROR(IF(C133<>\"\",SUBTOTAL(103,$C$128:$C133),\"\"),\"\")","v":6},"Install Bird Boxes as shown on tender specification drawings",15,"nr",null,""]
[null,{"$f":"IFERROR(IF(C134<>\"\",SUBTOTAL(103,$C$128:$C134),\"\"),\"\")","v":7},"Install Broxap Derby Standard Litter Bin or similar approved as per manufacturers installation guidance with paving and as shown on tender specification drawings",1,"nr",null,""]
[]
[null,"Cemetery and Open Space Corridor Soft Landscaping",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D138<>\"\",D139<>\"\"),SUM(D138:D139),\"\"),\"\")","v":2},{"$f":"IFERROR(IF(OR(E138<>\"\",E139<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F138<>\"\",F139<>\"\"),SUM(F138:F139),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G138<>\"\",G139<>\"\"),SUM(G138:G139),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C138<>\"\",SUBTOTAL(103,$C$138:$C138),\"\"),\"\")","v":1},"Allow for supply and plant and maintain for 3 months after substantial completion of the soft landscaping as per the schedule and planting requirements as shown on tender specification drawings (3 of 7 N0681(96)003A) ",1,"Sum",null,{"$f":"IFERROR(IF(AND(D138<>\"\",F138<>\"\"),SUM(D138*F138),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C139<>\"\",SUBTOTAL(103,$C$138:$C139),\"\"),\"\")","v":2},"Provide an itemised cost schedule with unit cost for each line of the soft landscape schedule. Total soft landscape schedule cost ",1,"Sum",null,{"$f":"IFERROR(IF(AND(D139<>\"\",F139<>\"\"),SUM(D139*F139),\"\"),\"\")","v":""}]

{"sheet":"OE","index":3,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,6],[16,1,16,2],[21,1,21,2],[26,1,26,2],[30,1,30,2],[13,1,13,5],[7,0,7,6],[9,0,9,6],[11,0,11,6]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Shire Lodge Cemetery Extension - Civil Works"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",(SoWR!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Optional Extras"]
["Pricing Schedule"]
[]
["The total of this Schedule will be carried to the Summary."]
[]
["The Cost (ex VAT) is to include for all labour and materials necessary for carrying out the works described during working hours defined in the Council's Specification and associated documents and is to include a proportion for preliminary costs, overheads and profit."]
[]
["Each item is to be priced, thereafter the spreadsheet will extend this rate out, for the quantity required by the Council."]
[]
[null,"Schedule Costs",null,null,null,null,"Total"]
[null,"Sub-Total of Schedule Costs carried to Summary",null,null,null,null,{"$f":"IFERROR(IF(OR(G18<>\"\",G23<>\"\",G28<>\"\",G32<>\"\"),SUM(G18,G23,G28,G32),\"\"),\"\")","v":""}]
[]
[null,"Preparatory Works",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried forward to Summary",null,{"$f":"IFERROR(IF(OR(D19<>\"\",D20<>\"\"),SUM(D19:D20),\"\"),\"\")","v":884},{"$f":"IFERROR(IF(OR(E19<>\"\",E20<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F19<>\"\",F20<>\"\"),SUM(F19:F20),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G19<>\"\",G20<>\"\"),SUM(G19:G20),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C19<>\"\",SUBTOTAL(103,$C$19:C19),\"\"),\"\")","v":1},"Break out existing knee rail fencing, car parking bays, excavation, storage of excavated material and construction of site access road using, MOT type 1 compacted and contained within timber edgings, to working area as shown on tender specification drawings. ",442,"m2",null,{"$f":"IFERROR(IF(AND(D19<>\"\",F19<>\"\"),SUM(D19*F19),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C20<>\"\",SUBTOTAL(103,$C$19:C20),\"\"),\"\")","v":2},"Upon completion of works removal of access road and reinstatement of ground, car parking bays and fencing to generally an equal standard to that prior to the works being undertaken.",442,"m2",null,{"$f":"IFERROR(IF(AND(D20<>\"\",F20<>\"\"),SUM(D20*F20),\"\"),\"\")","v":""}]
[]
[null,"Strip Out and Removal",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried forward to Summary",null,{"$f":"IFERROR(IF(OR(D24<>\"\",D25<>\"\"),SUM(D24:D25),\"\"),\"\")","v":2},{"$f":"IFERROR(IF(OR(E24<>\"\",E25<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F24<>\"\",F25<>\"\"),SUM(F24:F25),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G24<>\"\",G25<>\"\"),SUM(G24:G25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C24<>\"\",SUBTOTAL(103,$C$24:C24),\"\"),\"\")","v":1},"Isolate existing services and remove obsolete automatic toilet and break out base as shown on tender specification drawings and disposed of at licensed waste facility. Reinstate with imported graded top soil",1,"Sum",null,{"$f":"IFERROR(IF(AND(D24<>\"\",F24<>\"\"),SUM(D24*F24),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$24:C25),\"\"),\"\")","v":2},"Isolate existing services, construct brick plant cabinet with tamper proof door and remove office building and remove all arisings to licensed waste facility. Create planting bed in cleared area. Ensure toilet block walls and roof are protected and made good generally to an equal standard to that prior to the works being undertaken. Install fence panels and post with gate stay to the similar standard as existing and written approval of the client.",1,"Sum",null,{"$f":"IFERROR(IF(AND(D25<>\"\",F25<>\"\"),SUM(D25*F25),\"\"),\"\")","v":""}]
[]
[null,"Welfare Facility",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried forward to Summary",null,{"$f":"IFERROR(IF(OR(D29<>\"\"),SUM(D29:D29),\"\"),\"\")","v":15},{"$f":"IFERROR(IF(OR(E29<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F29<>\"\"),SUM(F29:F29),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G29<>\"\"),SUM(G29:G29),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$29:C29),\"\"),\"\")","v":1},"Excavate and construct block wall for spoil heap as shown on tender specification drawings",15,"m",null,{"$f":"IFERROR(IF(AND(D29<>\"\",F29<>\"\"),SUM(D29*F29),\"\"),\"\")","v":""}]
[]
[null,"Building Refurbishment",null,"Quantity Required","Unit","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried forward to Summary",null,{"$f":"IFERROR(IF(OR(D33<>\"\"),SUM(D33:D33),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E33<>\"\"),\"N/A\",\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F33<>\"\"),SUM(F33:F33),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G33<>\"\"),SUM(G33:G33),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C33<>\"\",SUBTOTAL(103,$C33:C$33),\"\"),\"\")","v":1},"Undertake refurbishment and alterations of existing storage area in accordance with Corporate Architects Development Specification for the Refurbishment of Existing Storage Area to form Welfare Area",1,"Sum",null,{"$f":"IFERROR(IF(AND(D33<>\"\",F33<>\"\"),SUM(D33*F33),\"\"),\"\")","v":""}]

{"sheet":"AC","index":4,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":false,"merged":[[73,2,73,4],[73,5,73,6],[74,2,74,4],[74,5,74,6],[75,2,75,4],[75,5,75,6],[70,2,70,4],[70,5,70,6],[71,2,71,4],[71,5,71,6],[72,2,72,4],[72,5,72,6],[67,2,67,4],[67,5,67,6],[68,2,68,4],[68,5,68,6],[69,2,69,4],[69,5,69,6],[64,2,64,4],[64,5,64,6],[65,2,65,4],[65,5,65,6],[66,2,66,4],[66,5,66,6],[61,2,61,4],[61,5,61,6],[62,2,62,4],[62,5,62,6],[63,2,63,4],[63,5,63,6],[58,2,58,4],[58,5,58,6],[59,2,59,4],[59,5,59,6],[60,2,60,4],[60,5,60,6],[55,2,55,4],[55,5,55,6],[56,2,56,4],[56,5,56,6],[57,2,57,4],[57,5,57,6],[52,2,52,4],[52,5,52,6],[53,2,53,4],[53,5,53,6],[54,2,54,4],[54,5,54,6],[49,2,49,4],[49,5,49,6],[50,2,50,4],[50,5,50,6],[51,2,51,4],[51,5,51,6],[46,1,46,4],[46,5,46,6],[47,2,47,4],[47,5,47,6],[48,2,48,4],[48,5,48,6],[43,2,43,4],[43,5,43,6],[44,2,44,4],[44,5,44,6],[45,2,45,4],[45,5,45,6],[40,2,40,4],[40,5,40,6],[41,2,41,4],[41,5,41,6],[42,2,42,4],[42,5,42,6],[37,2,37,4],[37,5,37,6],[38,2,38,4],[38,5,38,6],[39,2,39,4],[39,5,39,6],[34,2,34,4],[34,5,34,6],[35,2,35,4],[35,5,35,6],[36,2,36,4],[36,5,36,6],[31,2,31,4],[31,5,31,6],[32,2,32,4],[32,5,32,6],[33,2,33,4],[33,5,33,6],[28,2,28,4],[28,5,28,6],[29,2,29,4],[29,5,29,6],[30,2,30,4],[30,5,30,6],[25,2,25,4],[25,5,25,6],[26,2,26,4],[26,5,26,6],[27,2,27,4],[27,5,27,6],[22,2,22,4],[22,5,22,6],[23,2,23,4],[23,5,23,6],[24,2,24,4],[24,5,24,6],[19,2,19,4],[19,5,19,6],[20,2,20,4],[20,5,20,6],[21,2,21,4],[21,5,21,6],[16,2,16,4],[16,5,16,6],[17,2,17,4],[17,5,17,6],[18,2,18,4],[18,5,18,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[14,1,14,4],[14,5,14,6],[15,2,15,4],[15,5,15,6],[1,0,1,8],[7,1,7,8],[9,1,9,7]]}
["Previous Page",null,"Contents"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Shire Lodge Cemetery Extension - Civil Works"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",(SoWR!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Additional Costs Not Otherwise Specified"]
["Pricing Schedule"]
[]
[null,{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",CONCATENATE((SoWR!$C$4),\" is to detail, below, any items of additional cost, not otherwise specified, for which they require reimbursement.\",\" The items should be related to particular Specification and/or Contract clause references and the costs idetified as ''Fixed'' or ''Time Related'' charges.\"&CHAR(10)&CHAR(10)&\" Items which are not included herein WILL NOT BE covered by the Council.\"),CONCATENATE(\"The Supplier is to detail, below, any items of additional cost, not otherwise specified, for which they require reimbursement.\",\" The items should be related to particular Specification and/or Contract clause references and the costs idetified as ''Fixed'' or ''Time Related'' charges.\"&CHAR(10)&CHAR(10)&\" Items which are not included herein WILL NOT BE covered by the Council.\")),\"\")","v":"The Supplier is to detail, below, any items of additional cost, not otherwise specified, for which they require reimbursement. The items should be related to particular Specification and/or Contract clause references and the costs idetified as ''Fixed'' or ''Time Related'' charges.\n\n Items which are not included herein WILL NOT BE covered by the Council."}]
[]
[null,"Additional Costs Not Otherwise Specified",null,null,null,null,null,null,"Cost"]
[null,"Sub-Total (Fixed Charges)",null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(I16<>\"\",I17<>\"\",I18<>\"\",I19<>\"\",I20<>\"\",I21<>\"\",I22<>\"\",I23<>\"\",I24<>\"\",I25<>\"\",I26<>\"\",I27<>\"\",I28<>\"\",I29<>\"\",I30<>\"\",I31<>\"\",I32<>\"\",I33<>\"\",I34<>\"\",I35<>\"\",I36<>\"\",I37<>\"\",I38<>\"\",I39<>\"\",I40<>\"\",I41<>\"\",I42<>\"\",I43<>\"\",I44<>\"\",I45<>\"\",I46<>\"\",I48<>\"\",I49<>\"\",I50<>\"\",I51<>\"\",I52<>\"\",I53<>\"\",I54<>\"\",I55<>\"\",I56<>\"\",I57<>\"\",I58<>\"\",I59<>\"\",I60<>\"\",I61<>\"\",I62<>\"\",I63<>\"\",I64<>\"\",I65<>\"\",I66<>\"\",I67<>\"\",I68<>\"\",I69<>\"\",I70<>\"\",I71<>\"\",I72<>\"\",I73<>\"\",I74<>\"\",I75<>\"\",I76<>\"\"),SUMIF(H16:H76,\"Fixed\",I16:I76),\"\"),\"\")","v":""}]
[null,"Sub-Total (Time Related Charges)",null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(I16<>\"\",I17<>\"\",I18<>\"\",I19<>\"\",I20<>\"\",I21<>\"\",I22<>\"\",I23<>\"\",I24<>\"\",I25<>\"\",I26<>\"\",I27<>\"\",I28<>\"\",I29<>\"\",I30<>\"\",I31<>\"\",I32<>\"\",I33<>\"\",I34<>\"\",I35<>\"\",I36<>\"\",I37<>\"\",I38<>\"\",I39<>\"\",I40<>\"\",I41<>\"\",I42<>\"\",I43<>\"\",I44<>\"\",I45<>\"\",I46<>\"\",I48<>\"\",I49<>\"\",I50<>\"\",I51<>\"\",I52<>\"\",I53<>\"\",I54<>\"\",I55<>\"\",I56<>\"\",I57<>\"\",I58<>\"\",I59<>\"\",I60<>\"\",I61<>\"\",I62<>\"\",I63<>\"\",I64<>\"\",I65<>\"\",I66<>\"\",I67<>\"\",I68<>\"\",I69<>\"\",I70<>\"\",I71<>\"\",I72<>\"\",I73<>\"\",I74<>\"\",I75<>\"\",I76<>\"\"),SUMIF(H16:H76,\"Time Related\",I16:I76),\"\"),\"\")","v":""}]
[null,"Sub-Total of Additional Costs carried to Summary",null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(I16<>\"\",I17<>\"\",I18<>\"\",I19<>\"\",I20<>\"\",I21<>\"\",I22<>\"\",I23<>\"\",I24<>\"\",I25<>\"\",I26<>\"\",I27<>\"\",I28<>\"\",I29<>\"\",I30<>\"\",I31<>\"\",I32<>\"\",I33<>\"\",I34<>\"\",I35<>\"\",I36<>\"\",I37<>\"\",I38<>\"\",I39<>\"\",I40<>\"\",I41<>\"\",I42<>\"\",I43<>\"\",I44<>\"\",I45<>\"\",I46<>\"\",I48<>\"\",I49<>\"\",I50<>\"\",I51<>\"\",I52<>\"\",I53<>\"\",I54<>\"\",I55<>\"\",I56<>\"\",I57<>\"\",I58<>\"\",I59<>\"\",I60<>\"\",I61<>\"\",I62<>\"\",I63<>\"\",I64<>\"\",I65<>\"\",I66<>\"\",I67<>\"\",I68<>\"\",I69<>\"\",I70<>\"\",I71<>\"\",I72<>\"\",I73<>\"\",I74<>\"\",I75<>\"\",I76<>\"\"),SUM(I16:I76),\"\"),\"\")","v":""}]
[]
[null,"Items of Additional Cost Not Otherwise Specified",null,null,null,"Specification and/or Contract Clause Ref:",null,"Fixed or\nTime Related","Cost"]
[null,{"$f":"IFERROR(IF(C16<>\"\",SUBTOTAL(103,$C$16:$C16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C17<>\"\",SUBTOTAL(103,$C$16:$C17),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C18<>\"\",SUBTOTAL(103,$C$16:$C18),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C19<>\"\",SUBTOTAL(103,$C$16:$C19),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C20<>\"\",SUBTOTAL(103,$C$16:$C20),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C21<>\"\",SUBTOTAL(103,$C$16:$C21),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C22<>\"\",SUBTOTAL(103,$C$16:$C22),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C23<>\"\",SUBTOTAL(103,$C$16:$C23),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C24<>\"\",SUBTOTAL(103,$C$16:$C24),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$16:$C25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C26<>\"\",SUBTOTAL(103,$C$16:$C26),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C27<>\"\",SUBTOTAL(103,$C$16:$C27),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C28<>\"\",SUBTOTAL(103,$C$16:$C28),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$16:$C29),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C30<>\"\",SUBTOTAL(103,$C$16:$C30),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C31<>\"\",SUBTOTAL(103,$C$16:$C31),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C32<>\"\",SUBTOTAL(103,$C$16:$C32),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C33<>\"\",SUBTOTAL(103,$C$16:$C33),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C34<>\"\",SUBTOTAL(103,$C$16:$C34),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C35<>\"\",SUBTOTAL(103,$C$16:$C35),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C36<>\"\",SUBTOTAL(103,$C$16:$C36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C37<>\"\",SUBTOTAL(103,$C$16:$C37),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C38<>\"\",SUBTOTAL(103,$C$16:$C38),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C39<>\"\",SUBTOTAL(103,$C$16:$C39),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C40<>\"\",SUBTOTAL(103,$C$16:$C40),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C41<>\"\",SUBTOTAL(103,$C$16:$C41),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C42<>\"\",SUBTOTAL(103,$C$16:$C42),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C43<>\"\",SUBTOTAL(103,$C$16:$C43),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C44<>\"\",SUBTOTAL(103,$C$16:$C44),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C45<>\"\",SUBTOTAL(103,$C$16:$C45),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C46<>\"\",SUBTOTAL(103,$C$16:$C46),\"\"),\"\")","v":""}]
[null,"Items of Additional Cost Not Otherwise Specified",null,null,null,"Specification and/or Contract Clause Ref:",null,"Fixed or\nTime Related","Cost"]
[null,{"$f":"IFERROR(IF(C48<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C48),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C49),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C50<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C50),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C51<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C51),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C52<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C52),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C53<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C53),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C54<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C54),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C55<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C55),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C56),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C57<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C57),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C58<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C58),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C59<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C60<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C60),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C61<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C61),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C62<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C62),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C63<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C64),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C65),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C66),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C67),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C68<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C68),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C69<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C69),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C70<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C71<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C71),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C72<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C72),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C73<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C73),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C74<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C74),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C75<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$B$16:$B$46,$C$48:$C76),\"\"),\"\")","v":""}]

{"sheet":"Data","index":5,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["%","Charge Type"]
[0.01,"Fixed"]
[1.4999999999999999E-2,"Time Related"]
[0.02]
[2.5000000000000001E-2]
[0.03]
[3.5000000000000003E-2]
[0.04]
[4.4999999999999998E-2]
[0.05]
[5.5E-2]
[0.06]
[6.5000000000000002E-2]
[7.0000000000000007E-2]
[7.4999999999999997E-2]
[0.08]
[8.5000000000000006E-2]
[0.09]
[9.5000000000000001E-2]
[0.1]