{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["I&C","Summary","SoWR","Contingency","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":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Next Page"]
["Lodge Park Sports Centre - All Weather Pitch"]
[]
["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 Lodge Park Sports Centre - All Weather Pitch requirement and will be included as an appendix to the Contract between The Supplier and Corby Borough Council."}]
[]
[{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",CONCATENATE(\"This document should be read alongside the Contract Specification and Work Schedule, which provides greater detail of each of the costing elements, to enable \",(SoWR!$C$4),\" to complete this Schedule.\"),CONCATENATE(\"This document should be read alongside the Contract Specification and Work Schedule, which provides greater detail of each of the costing elements, to enable The Supplier to complete this Schedule.\")),\"\")","v":"This document should be read alongside the Contract Specification and Work Schedule, which provides greater detail of each of the costing elements, to enable The Supplier to complete this Schedule."}]
[]
["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"]
["Contingency"]
["Additional Costs"]

{"sheet":"Summary","index":1,"n_rows":84,"n_cols":4,"rows_kept":84,"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":"Lodge Park Sports Centre - All Weather Pitch"}]
[]
["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 - Option 1","Section Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(D10<>\"\",D11<>\"\",D12<>\"\",D13<>\"\",D14<>\"\",D15<>\"\",D16<>\"\",D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\"),SUM(D10:D20),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C10<>\"\",SUBTOTAL(103,$C$10:$C10),\"\"),\"\")","v":1},"Contract Compliance",{"$f":"IFERROR(IF(SoWR!$F$16<>\"\",SUM(SoWR!$F$16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C11<>\"\",SUBTOTAL(103,$C$10:$C11),\"\"),\"\")","v":2},"Site Establishment",{"$f":"IFERROR(IF(SoWR!$F$25<>\"\",SUM(SoWR!$F$25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C12<>\"\",SUBTOTAL(103,$C$10:$C12),\"\"),\"\")","v":3},"Site Clearance and Base Work",{"$f":"IFERROR(IF(SoWR!$F$36<>\"\",SUM(SoWR!$F$36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C13<>\"\",SUBTOTAL(103,$C$10:$C13),\"\"),\"\")","v":4},"Synthetic Turf 60mm",{"$f":"IFERROR(IF(SoWR!$F$46<>\"\",SUM(SoWR!$F$46),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C14<>\"\",SUBTOTAL(103,$C$10:$C14),\"\"),\"\")","v":5},"Player Signage",{"$f":"IFERROR(IF(SoWR!$F$59<>\"\",SUM(SoWR!$F$59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C15<>\"\",SUBTOTAL(103,$C$10:$C15),\"\"),\"\")","v":6},"Reinstatement",{"$f":"IFERROR(IF(SoWR!$F$63<>\"\",SUM(SoWR!$F$63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C16<>\"\",SUBTOTAL(103,$C$10:$C16),\"\"),\"\")","v":7},"Installation of Football Goals",{"$f":"IFERROR(IF(SoWR!$F$70<>\"\",SUM(SoWR!$F$70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C17<>\"\",SUBTOTAL(103,$C$10:$C17),\"\"),\"\")","v":8},"Fence Repairs",{"$f":"IFERROR(IF(SoWR!$F$75<>\"\",SUM(SoWR!$F$75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C18<>\"\",SUBTOTAL(103,$C$10:$C18),\"\"),\"\")","v":9},"Additional Requirements",{"$f":"IFERROR(IF(SoWR!$F$89<>\"\",SUM(SoWR!$F$89),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C19<>\"\",SUBTOTAL(103,$C$10:$C19),\"\"),\"\")","v":10},"Contingency",{"$f":"IFERROR(IF(Contingency!$F$10<>\"\",SUM(Contingency!$F$10),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C20<>\"\",SUBTOTAL(103,$C$10:$C20),\"\"),\"\")","v":11},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!$I$13<>\"\",SUM(AC!$I$13),\"\"),\"\")","v":""}]
[]
[null,null,"Summary Section Headings - Option 2","Section Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(D24<>\"\",D25<>\"\",D26<>\"\",D27<>\"\",D28<>\"\",D29<>\"\",D30<>\"\",D31<>\"\",D32<>\"\",D33<>\"\",D34<>\"\"),SUM(D24:D34),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C24<>\"\",SUBTOTAL(103,$C$24:$C24),\"\"),\"\")","v":1},"Contract Compliance",{"$f":"IFERROR(IF(SoWR!$F$16<>\"\",SUM(SoWR!$F$16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$24:$C25),\"\"),\"\")","v":2},"Site Establishment",{"$f":"IFERROR(IF(SoWR!$F$25<>\"\",SUM(SoWR!$F$25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C26<>\"\",SUBTOTAL(103,$C$24:$C26),\"\"),\"\")","v":3},"Site Clearance and Base Work",{"$f":"IFERROR(IF(SoWR!$F$36<>\"\",SUM(SoWR!$F$36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C27<>\"\",SUBTOTAL(103,$C$24:$C27),\"\"),\"\")","v":4},"Synthetic Turf 50mm",{"$f":"IFERROR(IF(SoWR!$F$45<>\"\",SUM(SoWR!$F$45),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C28<>\"\",SUBTOTAL(103,$C$24:$C28),\"\"),\"\")","v":5},"Player Signage",{"$f":"IFERROR(IF(SoWR!$F$59<>\"\",SUM(SoWR!$F$59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$24:$C29),\"\"),\"\")","v":6},"Reinstatement",{"$f":"IFERROR(IF(SoWR!$F$63<>\"\",SUM(SoWR!$F$63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C30<>\"\",SUBTOTAL(103,$C$24:$C30),\"\"),\"\")","v":7},"Installation of Football Goals",{"$f":"IFERROR(IF(SoWR!$F$70<>\"\",SUM(SoWR!$F$70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C31<>\"\",SUBTOTAL(103,$C$24:$C31),\"\"),\"\")","v":8},"Fence Repairs",{"$f":"IFERROR(IF(SoWR!$F$75<>\"\",SUM(SoWR!$F$75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C32<>\"\",SUBTOTAL(103,$C$24:$C32),\"\"),\"\")","v":9},"Additional Requirements",{"$f":"IFERROR(IF(SoWR!$F$89<>\"\",SUM(SoWR!$F$89),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C33<>\"\",SUBTOTAL(103,$C$24:$C33),\"\"),\"\")","v":10},"Contingency",{"$f":"IFERROR(IF(Contingency!$F$14<>\"\",SUM(Contingency!$F$14),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C34<>\"\",SUBTOTAL(103,$C$24:$C34),\"\"),\"\")","v":11},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!$I$13<>\"\",SUM(AC!$I$13),\"\"),\"\")","v":""}]
[]
[null,null,"Summary Section Headings - Option 3","Section Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(D38<>\"\",D39<>\"\",D40<>\"\",D41<>\"\",D42<>\"\",D43<>\"\",D44<>\"\",D45<>\"\",D46<>\"\",D47<>\"\"),SUM(D38:D47),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C38<>\"\",SUBTOTAL(103,$C$38:$C38),\"\"),\"\")","v":1},"Contract Compliance",{"$f":"IFERROR(IF(SoWR!$F$16<>\"\",SUM(SoWR!$F$16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C39<>\"\",SUBTOTAL(103,$C$38:$C39),\"\"),\"\")","v":2},"Site Establishment",{"$f":"IFERROR(IF(SoWR!$F$25<>\"\",SUM(SoWR!$F$25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C40<>\"\",SUBTOTAL(103,$C$38:$C40),\"\"),\"\")","v":3},"Site Clearance and Base Work",{"$f":"IFERROR(IF(SoWR!$F$36<>\"\",SUM(SoWR!$F$36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C41<>\"\",SUBTOTAL(103,$C$38:$C41),\"\"),\"\")","v":4},"Synthetic Turf 60mm",{"$f":"IFERROR(IF(SoWR!$F$46<>\"\",SUM(SoWR!$F$46),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C42<>\"\",SUBTOTAL(103,$C$38:$C42),\"\"),\"\")","v":5},"Player Signage",{"$f":"IFERROR(IF(SoWR!$F$59<>\"\",SUM(SoWR!$F$59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C43<>\"\",SUBTOTAL(103,$C$38:$C43),\"\"),\"\")","v":6},"Reinstatement",{"$f":"IFERROR(IF(SoWR!$F$63<>\"\",SUM(SoWR!$F$63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C44<>\"\",SUBTOTAL(103,$C$38:$C44),\"\"),\"\")","v":7},"Installation of Football Goals",{"$f":"IFERROR(IF(SoWR!$F$70<>\"\",SUM(SoWR!$F$70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C45<>\"\",SUBTOTAL(103,$C$38:$C45),\"\"),\"\")","v":8},"Fence Repairs",{"$f":"IFERROR(IF(SoWR!$F$75<>\"\",SUM(SoWR!$F$75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C46<>\"\",SUBTOTAL(103,$C$38:$C46),\"\"),\"\")","v":9},"Contingency",{"$f":"IFERROR(IF(Contingency!$F$17<>\"\",SUM(Contingency!$F$17),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C47<>\"\",SUBTOTAL(103,$C$38:$C47),\"\"),\"\")","v":10},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!$I$13<>\"\",SUM(AC!$I$13),\"\"),\"\")","v":""}]
[]
[null,null,"Summary Section Headings - Option 4","Section Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(D51<>\"\",D52<>\"\",D53<>\"\",D54<>\"\",D55<>\"\",D56<>\"\",D57<>\"\",D58<>\"\",D59<>\"\",D60<>\"\"),SUM(D51:D60),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C51<>\"\",SUBTOTAL(103,$C$51:$C51),\"\"),\"\")","v":1},"Contract Compliance",{"$f":"IFERROR(IF(SoWR!$F$16<>\"\",SUM(SoWR!$F$16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C52<>\"\",SUBTOTAL(103,$C$51:$C52),\"\"),\"\")","v":2},"Site Establishment",{"$f":"IFERROR(IF(SoWR!$F$25<>\"\",SUM(SoWR!$F$25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C53<>\"\",SUBTOTAL(103,$C$51:$C53),\"\"),\"\")","v":3},"Site Clearance and Base Work",{"$f":"IFERROR(IF(SoWR!$F$36<>\"\",SUM(SoWR!$F$36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C54<>\"\",SUBTOTAL(103,$C$51:$C54),\"\"),\"\")","v":4},"Synthetic Turf 50mm",{"$f":"IFERROR(IF(SoWR!$F$45<>\"\",SUM(SoWR!$F$45),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C55<>\"\",SUBTOTAL(103,$C$51:$C55),\"\"),\"\")","v":5},"Player Signage",{"$f":"IFERROR(IF(SoWR!$F$59<>\"\",SUM(SoWR!$F$59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$C$51:$C56),\"\"),\"\")","v":6},"Reinstatement",{"$f":"IFERROR(IF(SoWR!$F$63<>\"\",SUM(SoWR!$F$63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C57<>\"\",SUBTOTAL(103,$C$51:$C57),\"\"),\"\")","v":7},"Installation of Football Goals",{"$f":"IFERROR(IF(SoWR!$F$70<>\"\",SUM(SoWR!$F$70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C58<>\"\",SUBTOTAL(103,$C$51:$C58),\"\"),\"\")","v":8},"Fence Repairs",{"$f":"IFERROR(IF(SoWR!$F$75<>\"\",SUM(SoWR!$F$75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C59<>\"\",SUBTOTAL(103,$C$51:$C59),\"\"),\"\")","v":9},"Contingency",{"$f":"IFERROR(IF(Contingency!$F$21<>\"\",SUM(Contingency!$F$21),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C60<>\"\",SUBTOTAL(103,$C$51:$C60),\"\"),\"\")","v":10},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!$I$13<>\"\",SUM(AC!$I$13),\"\"),\"\")","v":""}]
[]
[null,null,"Summary Section Headings - Option 5","Section Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(D64<>\"\",D65<>\"\",D66<>\"\",D67<>\"\",D68<>\"\",D69<>\"\",D70<>\"\",D71<>\"\",D72<>\"\"),SUM(D64:D72),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$C$64:$C64),\"\"),\"\")","v":1},"Contract Compliance",{"$f":"IFERROR(IF(SoWR!$F$16<>\"\",SUM(SoWR!$F$16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$C$64:$C65),\"\"),\"\")","v":2},"Site Establishment",{"$f":"IFERROR(IF(SoWR!$F$25<>\"\",SUM(SoWR!$F$25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$C$64:$C66),\"\"),\"\")","v":3},"Site Clearance and Base Work",{"$f":"IFERROR(IF(SoWR!$F$36<>\"\",SUM(SoWR!$F$36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$C$64:$C67),\"\"),\"\")","v":4},"Synthetic Turf 60mm",{"$f":"IFERROR(IF(SoWR!$F$46<>\"\",SUM(SoWR!$F$46),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C68<>\"\",SUBTOTAL(103,$C$64:$C68),\"\"),\"\")","v":5},"Player Signage",{"$f":"IFERROR(IF(SoWR!$F$59<>\"\",SUM(SoWR!$F$59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C69<>\"\",SUBTOTAL(103,$C$64:$C69),\"\"),\"\")","v":6},"Reinstatement",{"$f":"IFERROR(IF(SoWR!$F$63<>\"\",SUM(SoWR!$F$63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C70<>\"\",SUBTOTAL(103,$C$64:$C70),\"\"),\"\")","v":7},"Fence Repairs",{"$f":"IFERROR(IF(SoWR!$F$75<>\"\",SUM(SoWR!$F$75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C71<>\"\",SUBTOTAL(103,$C$64:$C71),\"\"),\"\")","v":8},"Contingency",{"$f":"IFERROR(IF(Contingency!$F$25<>\"\",SUM(Contingency!$F$25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C72<>\"\",SUBTOTAL(103,$C$64:$C72),\"\"),\"\")","v":9},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!$I$13<>\"\",SUM(AC!$I$13),\"\"),\"\")","v":""}]
[]
[null,null,"Summary Section Headings - Option 6","Section Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(D76<>\"\",D77<>\"\",D78<>\"\",D79<>\"\",D80<>\"\",D81<>\"\",D82<>\"\",D83<>\"\",D84<>\"\"),SUM(D76:D84),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$C$76:$C76),\"\"),\"\")","v":1},"Contract Compliance",{"$f":"IFERROR(IF(SoWR!$F$16<>\"\",SUM(SoWR!$F$16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C77<>\"\",SUBTOTAL(103,$C$76:$C77),\"\"),\"\")","v":2},"Site Establishment",{"$f":"IFERROR(IF(SoWR!$F$25<>\"\",SUM(SoWR!$F$25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C78<>\"\",SUBTOTAL(103,$C$76:$C78),\"\"),\"\")","v":3},"Site Clearance and Base Work",{"$f":"IFERROR(IF(SoWR!$F$36<>\"\",SUM(SoWR!$F$36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C79<>\"\",SUBTOTAL(103,$C$76:$C79),\"\"),\"\")","v":4},"Synthetic Turf 50mm",{"$f":"IFERROR(IF(SoWR!$F$45<>\"\",SUM(SoWR!$F$45),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C80<>\"\",SUBTOTAL(103,$C$76:$C80),\"\"),\"\")","v":5},"Player Signage",{"$f":"IFERROR(IF(SoWR!$F$59<>\"\",SUM(SoWR!$F$59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C81<>\"\",SUBTOTAL(103,$C$76:$C81),\"\"),\"\")","v":6},"Reinstatement",{"$f":"IFERROR(IF(SoWR!$F$63<>\"\",SUM(SoWR!$F$63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C82<>\"\",SUBTOTAL(103,$C$76:$C82),\"\"),\"\")","v":7},"Fence Repairs",{"$f":"IFERROR(IF(SoWR!$F$75<>\"\",SUM(SoWR!$F$75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C83<>\"\",SUBTOTAL(103,$C$76:$C83),\"\"),\"\")","v":8},"Contingency",{"$f":"IFERROR(IF(Contingency!$F$29<>\"\",SUM(Contingency!$F$29),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C84<>\"\",SUBTOTAL(103,$C$76:$C84),\"\"),\"\")","v":9},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!$I$13<>\"\",SUM(AC!$I$13),\"\"),\"\")","v":""}]

{"sheet":"SoWR","index":2,"n_rows":92,"n_cols":6,"rows_kept":92,"cut":false,"hidden":false,"merged":[[9,0,9,5],[14,1,14,2],[23,1,23,2],[11,1,11,4],[1,0,1,5],[5,0,5,5],[4,2,4,5],[3,2,3,5],[7,0,7,5],[68,1,68,2],[73,1,73,2],[87,1,87,2],[34,1,34,2],[43,1,43,2],[57,1,57,2],[61,1,61,2]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Lodge Park Sports Centre - All Weather Pitch"}]
[]
["Supplier:"]
["Sub-Heading:",null,"Schedule of Works/Rates"]
["Pricing Schedule"]
[]
["The Cost is to include for all labour and materials necessary for carrying out the work described, during normal working hours."]
[]
["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,"Total"]
[null,"Sub-Total of Schedule Costs carried to Summary",null,null,null,{"$f":"IFERROR(IF(OR(F16<>\"\",F25<>\"\",F36<>\"\",F45<>\"\",F59<>\"\",F63<>\"\",F70<>\"\",F75<>\"\"),SUM(F16,F25,F36,F45,F59,F63,F70,F75),\"\"),\"\")","v":""}]
[]
[null,"Description of Work\nContract Compliance",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\",D21<>\"\",D22<>\"\"),SUM(D17:D22),\"\"),\"\")","v":6},{"$f":"IFERROR(IF(OR(E17<>\"\",E18<>\"\",E19<>\"\",E20<>\"\",E21<>\"\",E22<>\"\"),SUM(E17:E22),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F17<>\"\",F18<>\"\",F19<>\"\",F20<>\"\",F21<>\"\",F22<>\"\"),SUM(F17:F22),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C17<>\"\",SUBTOTAL(103,$C$17:$C17),\"\"),\"\")","v":1},"Allow for compliance with the Forms of Contract and Conditions of Contract and all and obligations and requirements stipulated by the Employer.",1,null,{"$f":"IFERROR(IF(AND(D17<>\"\",E17<>\"\"),SUM(D17*E17),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C18<>\"\",SUBTOTAL(103,$C$17:$C18),\"\"),\"\")","v":2},"Allow for the provision of necessary management, supervision and administration of the works in compliance with Construction (Design and Management) Regulations 2015.",1,null,{"$f":"IFERROR(IF(AND(D18<>\"\",E18<>\"\"),SUM(D18*E18),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C19<>\"\",SUBTOTAL(103,$C$17:$C19),\"\"),\"\")","v":3},"Allow for sufficient resources in which to prepare, mobilise and install the scheduled works and to ensure Practical Completion on the planned due date.",1,null,""]
[null,{"$f":"IFERROR(IF(C20<>\"\",SUBTOTAL(103,$C$17:$C20),\"\"),\"\")","v":4},"Allocation for the undertaking of Inspection / Testing procedures (ITPs) for works and materials, to be completed and reported at each critical stage of construction and throughout the sequential programme of works.",1,null,""]
[null,{"$f":"IFERROR(IF(C21<>\"\",SUBTOTAL(103,$C$17:$C21),\"\"),\"\")","v":5},"Provision of Building Manuals (incorporating the Health and Safety Files) in bound hard copy and electronic copy formats at Practical Completion.",1,null,""]
[null,{"$f":"IFERROR(IF(C22<>\"\",SUBTOTAL(103,$C$17:$C22),\"\"),\"\")","v":6},"Allow for the provision of full and detailed demonstration of the operational requirements for the completed facility to the Employer.",1,null,""]
[]
[null,"Description of Work\nSite Estabishment",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D26<>\"\",D27<>\"\",D28<>\"\",D29<>\"\",D30<>\"\",D31<>\"\",D32<>\"\",D33<>\"\"),SUM(D26:D33),\"\"),\"\")","v":8},{"$f":"IFERROR(IF(OR(E26<>\"\",E27<>\"\",E28<>\"\",E29<>\"\",E30<>\"\",E31<>\"\",E32<>\"\",E33<>\"\"),SUM(E26:E33),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F26<>\"\",F27<>\"\",F28<>\"\",F29<>\"\",F30<>\"\",F31<>\"\",F32<>\"\",F33<>\"\"),SUM(F26:F33),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C26<>\"\",SUBTOTAL(103,$C$26:$C26),\"\"),\"\")","v":1},"Appraisal of site approach, entry and movements whilst tendering for the works and make all necessary allowances as required, refer to drawing SSL2593 04 CMP.",1,null,{"$f":"IFERROR(IF(AND(D26<>\"\",E26<>\"\"),SUM(D26*E26),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C27<>\"\",SUBTOTAL(103,$C$26:$C27),\"\"),\"\")","v":2},"Establish an area to be used as the site compound and site access with a hard-standing surface as required, sufficient to withstand all trafficking and haulage for the duration of the works.",1,null,{"$f":"IFERROR(IF(AND(D27<>\"\",E27<>\"\"),SUM(D27*E27),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C28<>\"\",SUBTOTAL(103,$C$26:$C28),\"\"),\"\")","v":3},"Supply and erect temporary security fencing, consisting of 2.0m high open steel weld mesh fencing (Heras or similar approved) to the agreed site compound.",1,null,""]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$26:$C29),\"\"),\"\")","v":4},"Supply a site office and appropriate welfare facilities to comply with Construction (Design and Management) Regulations 2015.",1,null,""]
[null,{"$f":"IFERROR(IF(C30<>\"\",SUBTOTAL(103,$C$26:$C30),\"\"),\"\")","v":5},"Supply temporary storage facilities for any and all fragile / vulnerable building materials as deemed necessary by the contractor during the construction period as required.",1,null,""]
[null,{"$f":"IFERROR(IF(C31<>\"\",SUBTOTAL(103,$C$26:$C31),\"\"),\"\")","v":6},"Supply and erect public health and safety / warning signage to the temporary security fencing as required by Construction (Design and Management) Regulations 2015.",1,null,""]
[null,{"$f":"IFERROR(IF(C32<>\"\",SUBTOTAL(103,$C$26:$C32),\"\"),\"\")","v":7},"Deliver construction machinery and plant to site and allow for removal upon completion of the works.",1,null,""]
[null,{"$f":"IFERROR(IF(C33<>\"\",SUBTOTAL(103,$C$26:$C33),\"\"),\"\")","v":8},"Carry out a comprehensive underground services detection survey of the entire working area and transport routes prior to the commencement of excavation works and then provide suitable temporary protection as necessary to any and all vulnerable utilities, services, manholes and inspection chambers, etc...; capable of withstanding all trafficking and haulage during the works; to avoid damage for the duration of the works.",1,null,""]
[]
[null,"Description of Work\nSite Clearance and Base Work",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D37<>\"\",D38<>\"\",D39<>\"\",D40<>\"\",D41<>\"\",D42<>\"\"),SUM(D37:D42),\"\"),\"\")","v":4},{"$f":"IFERROR(IF(OR(E37<>\"\",E38<>\"\",E39<>\"\",E40<>\"\",E41<>\"\",E42<>\"\"),SUM(E37:E42),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F37<>\"\",F38<>\"\",F39<>\"\",F40<>\"\",F41<>\"\",F42<>\"\"),SUM(F37:F42),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C37<>\"\",SUBTOTAL(103,$C$37:$C37),\"\"),\"\")","v":1},"Carefully remove all existing free-standing and socketed goals from the pitch as necessary and store safely and securely for the duration of the works. Following resurfacing works all goals should be re-erected onto the pitch surface.",1,null,{"$f":"IFERROR(IF(AND(D37<>\"\",E37<>\"\"),SUM(D37*E37),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C38<>\"\",SUBTOTAL(103,$C$37:$C38),\"\"),\"\")","v":2},"Lift, strip and remove the existing pitch surface (3G artificial grass) and top geotextile membrane; carefully and sequentially using vehicles with low-flotation tyres (in order to prevent damage to the underlying sand layer).","5,960m²",null,{"$f":"IFERROR(IF(AND(D38<>\"\",E38<>\"\"),SUM(E38),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C39<>\"\",SUBTOTAL(103,$C$37:$C39),\"\"),\"\")","v":3},"Apply a proprietary residual herbicide treatment over the entire formation level to be occupied by the pitch. During this process, protect surrounding grassed and vegetation areas from damage by the herbicide treatment.\n\nPlease Note: The use of pesticides (inc. Herbicide treatments) is covered by various pieces of legislation primarily The Food and Environment Protection Act 1985 (FEPA), Control of Pesticides Regulations 1986 (COPR) and The Control of Substances Hazardous to Health Regulations 1988(COSHH).\n\nOnly approved products may be used and a Certificate of Competence must be held for all persons applying pesticides (e.g. National Proficiency Test Council (NPTC) PA1, PA2, etc...) and those advising on pesticide use should be registered with BASIS (British Agrochemical Standards Inspection Scheme).",1,null,{"$f":"IFERROR(IF(AND(D39<>\"\",E39<>\"\"),SUM(D39*E39),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C40<>\"\",SUBTOTAL(103,$C$37:$C40),\"\"),\"\")","v":4},"Re-grade, compact and re-level the existing sand layer sufficiently.\n\nInstall a new geotextile membrane to the pitch area, taking note to overlap and adhere the joints.\n\nAll geotextile joints should be overlapped by a minimum of 300mm. The membrane shall be a non-woven type and shall contain a minimum tensile strength of 20kN/m when tested in accordance with BS EN ISO 10319. The membrane shall contain static puncture strength of at least 2.0KN when tested in accordance with BS EN ISO 12236.","5,960m²",null,{"$f":"IFERROR(IF(AND(D40<>\"\",E40<>\"\"),SUM(E40),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C41<>\"\",SUBTOTAL(103,$C$37:$C41),\"\"),\"\")","v":5},"Surfacing Standards Ltd are to undertake a surface regularity test, alongside the Contractor of the exposed geotextile layer following the above works.\n\nAllow time for the survey and await results of the survey before proceeding with the laying of the artificial turf.",1,null,""]
[null,{"$f":"IFERROR(IF(C42<>\"\",SUBTOTAL(103,$C$37:$C42),\"\"),\"\")","v":6},"Locate existing drainage system to pitch and carry our water jetting cleaning of pipe work, inspection chamber’s and rodding eyes.",1,null,""]
[]
[null,"Description of Work\nSynthetic Turf",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total 50mm carried to Summary",null,{"$f":"IFERROR(IF(OR(D47<>\"\",D50<>\"\",D51<>\"\",D53<>\"\",D54<>\"\",D56<>\"\"),SUM(D47,D50:D51,D53:D54,D56),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E47<>\"\",E50<>\"\",E51<>\"\",E53<>\"\",E54<>\"\",E56<>\"\"),SUM(E47,E50:E51,E53:E54,E56),\"\"),\"\")","v":""},""]
[null,"Sub-Total 60mm carried to Summary",null,{"$f":"IFERROR(IF(OR(D48<>\"\",D50<>\"\",D51<>\"\",D53<>\"\",D54<>\"\",D56<>\"\"),SUM(D48:D51,D53:D54,D56),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E48<>\"\",E50<>\"\",E51<>\"\",E53<>\"\",E54<>\"\",E56<>\"\"),SUM(E48:E51,E53:E54,E56),\"\"),\"\")","v":""},""]
[null,{"$f":"IFERROR(IF(C47<>\"\",SUBTOTAL(103,$C$47:$C47),\"\"),\"\")","v":1},"Supply and install 50mm 3G artificial turf playing surface\n","5,960m²",null,{"$f":"IFERROR(IF(AND(D47<>\"\",E47<>\"\"),SUM(E47),\"\"),\"\")","v":""}]
[null,null,"Supply and install 60mm 3G artificial turf playing surface\n","5,960m²",null,{"$f":"IFERROR(IF(AND(D48<>\"\",E48<>\"\"),SUM(E48),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$C$47,$C49),\"\"),\"\")","v":2},"Supply / install permanent markings to comply with FIFA Laws of the Game to produce the following playing lines cut into the surface:",null,null,{"$f":"IFERROR(IF(AND(D49<>\"\",E49<>\"\"),SUM(D49*E49),\"\"),\"\")","v":""}]
[null,"a.","INLAID 11v11 football pitch sized 91.4 x 55m (white 100mm wide) to u15/16 dimensions for boxes and circles including marker nibs for goal locations and corner areas; and",1,null,""]
[null,"b.","INLAID 2no. cross pitches (Red, 80mm) including 7v7 penalty boxes, penalty and centre spots, divisional lines and marking nibs for goal locations.",1,null,""]
[null,{"$f":"IFERROR(IF(C52<>\"\",SUBTOTAL(103,$C$47,$C$49,$C52),\"\"),\"\")","v":3},"Rubber Crumb Requirements",null,null,{"$f":"IFERROR(IF(AND(D52<>\"\",E52<>\"\"),SUM(D52*E52),\"\"),\"\")","v":""}]
[null,"a.","Supply Certificates Pre-Construction",1,null,""]
[null,"b.","Evidence of Testing Carried Out During Production",1,null,{"$f":"IFERROR(IF(AND(D54<>\"\",E54<>\"\"),SUM(D54*E54),\"\"),\"\")","v":""}]
[null,"c.","Testing of Site Samples (Refer to Next Item)",null,null,""]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$C$47,$C$49,$C$52,$C56),\"\"),\"\")","v":4},"Rubber Crumb Sample Testing",1,null,{"$f":"IFERROR(IF(AND(D56<>\"\",E56<>\"\"),SUM(D56*E56),\"\"),\"\")","v":""}]
[]
[null,"Description of Work\nPlayer Signage",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D60<>\"\"),SUM(D60:D60),\"\"),\"\")","v":2},{"$f":"IFERROR(IF(OR(E60<>\"\"),SUM(E60:E60),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F60<>\"\"),SUM(F60:F60),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C60<>\"\",SUBTOTAL(103,$C$60:$C60),\"\"),\"\")","v":1},"Supply and erect player signage (rules of correct pitch use etc...) to be supplied and installed where designated.",2,null,{"$f":"IFERROR(IF(AND(D60<>\"\",E60<>\"\"),SUM(D60*E60),\"\"),\"\")","v":""}]
[]
[null,"Description of Work\nReinstatement",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D64<>\"\",D65<>\"\",D66<>\"\",D67<>\"\"),SUM(D64:D67),\"\"),\"\")","v":4},{"$f":"IFERROR(IF(OR(E64<>\"\"),SUM(E64:E67),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F64<>\"\"),SUM(F64:F67),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$C$64:$C64),\"\"),\"\")","v":1},"Dispose of all arisings, spoils, surplus materials and general waste generated during the entire construction works described above responsibly at a registered tipping site or similar.",1,null,{"$f":"IFERROR(IF(AND(D64<>\"\",E64<>\"\"),SUM(D64*E64),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$C$64:$C65),\"\"),\"\")","v":2},"Reinstate all natural ground affected by the works to fine grass.",1,null,{"$f":"IFERROR(IF(AND(D65<>\"\",E65<>\"\"),SUM(D65*E65),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$C$64:$C66),\"\"),\"\")","v":3},"Clear and clean hard standing areas within the fenced areas. Make good any hard standing surfaces affected by the works.",1,null,""]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$C$64:$C67),\"\"),\"\")","v":4},"Allow for:\n1. Dismantling and removing from site the temporary security fencing;\n2. Remove from site, storage facilities, site office;\n3. Haul road;\n4. Cleaning of welfare facilities etc.; and\n5. Leave site in a tidy condition acceptable to the Employer.",1,null,""]
[]
[null,"Description of Work\nInstallation of Football Goals",null,"Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried forward to Summary",null,{"$f":"IFERROR(IF(OR(D71<>\"\",D72<>\"\"),SUM(D71:D72),\"\"),\"\")","v":6},{"$f":"IFERROR(IF(OR(E71<>\"\",E72<>\"\"),SUM(E71:E72),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F71<>\"\",F72<>\"\"),SUM(F71:F72),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C71<>\"\",SUBTOTAL(103,$C$71:C71),\"\"),\"\")","v":1},"Supply, install and assemble fence fixed aluminium football goals - 3.66m x 1.83m fence folding mini soccer goals",4,null,{"$f":"IFERROR(IF(AND(D71<>\"\",E71<>\"\"),SUM(D71*E71),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C72<>\"\",SUBTOTAL(103,$C$71:C72),\"\"),\"\")","v":2},"Supply, install and assemble fence fixed aluminium football goals - 7.32m x 2.44m fence folding goals",2,null,{"$f":"IFERROR(IF(AND(D72<>\"\",E72<>\"\"),SUM(D72*E72),\"\"),\"\")","v":""}]
[]
[null,"Description of Work\nFence Repairs",null,"Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried forward to Summary",null,{"$f":"IFERROR(IF(OR(D76<>\"\",D77<>\"\",D78<>\"\",D79<>\"\",D80<>\"\",D81<>\"\",D82<>\"\",D83<>\"\",D84<>\"\",D85<>\"\",D86<>\"\"),SUM(D76:D86),\"\"),\"\")","v":18},{"$f":"IFERROR(IF(OR(E76<>\"\",E77<>\"\",E78<>\"\",E79<>\"\",E80<>\"\",E81<>\"\",E82<>\"\",E83<>\"\",E84<>\"\",E85<>\"\",E86<>\"\"),SUM(E76:E86),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F76<>\"\",F77<>\"\",F78<>\"\",F79<>\"\",F80<>\"\",F81<>\"\",F82<>\"\",F83<>\"\",F84<>\"\",F85<>\"\",F86<>\"\"),SUM(F76:F86),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$C$76:C76),\"\"),\"\")","v":1},"Weldmesh patch and connect to clamp rail",1,null,{"$f":"IFERROR(IF(AND(D76<>\"\",E76<>\"\"),SUM(D76*E76),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C77<>\"\",SUBTOTAL(103,$C$76:C77),\"\"),\"\")","v":2},"Existing Weldmesh to be connected into clamp rail. Full height to 2.9m loose ((2) on Existing Site Plan).",1,null,{"$f":"IFERROR(IF(AND(D77<>\"\",E77<>\"\"),SUM(D77*E77),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C78<>\"\",SUBTOTAL(103,$C$76:C78),\"\"),\"\")","v":3},"Rigid panel 200x50mm mesh needs connecting or replacing (1.0m high and 2.52m wide)",1,null,""]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C79<>\"\",SUBTOTAL(103,$C$76:C79),\"\"),\"\")","v":4},"Hole in fencing 1.5m high x 4.6m needs patching to repair wider damage area",1,null,""]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C80<>\"\",SUBTOTAL(103,$C$76:C80),\"\"),\"\")","v":5},"Panel damage to the top behind goal 6 ((5 and 6) on Existing Site Plan)",2,null,""]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C81<>\"\",SUBTOTAL(103,$C$76:C81),\"\"),\"\")","v":6},"Existing Weldmesh to be connected into clamp rail. Full height to 2.9m loose ((7) on Existing Site Plan)",1,null,""]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C82<>\"\",SUBTOTAL(103,$C$76:C82),\"\"),\"\")","v":7},"Existing Weldmesh to be connected into clamp rail. Full height to 2.9m loose ((9) on Existing Site Plan)",1,null,""]
[null,{"$f":"IFERROR(IF(C83<>\"\",SUBTOTAL(103,$C$76:C83),\"\"),\"\")","v":8},"Posts for rigid panels need resetting in concrete foundation",7,null,{"$f":"IFERROR(IF(AND(D83<>\"\",E83<>\"\"),SUM(D83*E83),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C84<>\"\",SUBTOTAL(103,$C$76:C84),\"\"),\"\")","v":9},"Top rail loose and needs reattaching behind goal 1",1,null,""]
[null,{"$f":"IFERROR(IF(C85<>\"\",SUBTOTAL(103,$C$76:C85),\"\"),\"\")","v":10},"Weldmesh clips need replacing, small 1m section",1,null,""]
[null,{"$f":"IFERROR(IF(C86<>\"\",SUBTOTAL(103,$C$76:C86),\"\"),\"\")","v":11},"Timber Kickboarding on surrounding fences, to match existing green kickboard 250m",1,null,""]
[]
[null,"Additional Requirements",null,"Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried forward to Summary",null,{"$f":"IFERROR(IF(OR(D90<>\"\",D91<>\"\",D92<>\"\"),SUM(D90:D92),\"\"),\"\")","v":7},{"$f":"IFERROR(IF(OR(E90<>\"\",E91<>\"\",E92<>\"\"),SUM(E90:E92),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F90<>\"\",F91<>\"\",F92<>\"\"),SUM(F90:F92),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C90<>\"\",SUBTOTAL(103,$C$90:C90),\"\"),\"\")","v":1},"Performance Testing (Field Testing)",1,null,{"$f":"IFERROR(IF(AND(D90<>\"\",E90<>\"\"),SUM(D90*E90),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C91<>\"\",SUBTOTAL(103,$C$90:C91),\"\"),\"\")","v":2},"Litter Bins, fixed to fencing",5,null,{"$f":"IFERROR(IF(AND(D91<>\"\",E91<>\"\"),SUM(D91*E91),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(C92<>\"\",SUBTOTAL(103,$C$90:C92),\"\"),\"\")","v":3},"Aftercare",1,null,""]

{"sheet":"Contingency","index":3,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[23,1,23,2],[27,1,27,2],[1,0,1,5],[11,1,11,2],[7,1,7,2],[15,1,15,2],[19,1,19,2]]}
["Previous Page",null,"Contents",null,"Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Lodge Park Sports Centre - All Weather Pitch"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",(SoWR!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Contingency"]
["Pricing Schedule"]
[]
[null,"Client Contingency - Option 1",null,"Initial Charge","Percentage Addition","Cost of % Addition","Sub-Total"]
[null,{"$f":"IFERROR(IF(C9<>\"\",SUBTOTAL(103,$C$9:$C9),\"\"),\"\")","v":1},"Provisional Sum for Construction Costs",{"$f":"IFERROR(IF(OR(Summary!D11<>\"\",Summary!D12<>\"\",Summary!D15<>\"\",Summary!D16<>\"\"),SUM(Summary!D11,Summary!D12,Summary!D15,Summary!D16),\"\"),\"\")","v":""},5,{"$f":"IFERROR(IF(AND(D9<>\"\",E9<>\"\"),SUM(SUM(D9/E9)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(D9<>\"\",E9<>\"\"),SUM(SUM(D9/E9)+D9),\"\"),\"\")","v":""}]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D9<>\"\"),SUM(D9),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E9<>\"\"),SUM(E9),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(F9<>\"\"),SUM(F9),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(G9<>\"\"),SUM(G9),\"\"),\"\")","v":""}]
[]
[null,"Client Contingency - Option 2",null,"Initial Charge","Percentage Addition","Cost of % Addition"]
[null,{"$f":"IFERROR(IF(C13<>\"\",SUBTOTAL(103,$C$13:$C13),\"\"),\"\")","v":1},"Provisional Sum for Construction Costs",{"$f":"IFERROR(IF(OR(Summary!D25<>\"\",Summary!D26<>\"\",Summary!D29<>\"\",Summary!D30<>\"\"),SUM(Summary!D25,Summary!D26,Summary!D29,Summary!D30),\"\"),\"\")","v":""},5,{"$f":"IFERROR(IF(AND(D13<>\"\",E13<>\"\"),SUM(SUM(D13/E13)),\"\"),\"\")","v":""}]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D13<>\"\"),SUM(D13),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E13<>\"\"),SUM(E13),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(F13<>\"\"),SUM(F13),\"\"),\"\")","v":""}]
[]
[null,"Client Contingency - Option 3",null,"Initial Charge","Percentage Addition","Cost of % Addition"]
[null,{"$f":"IFERROR(IF(C17<>\"\",SUBTOTAL(103,$C$13:$C13),\"\"),\"\")","v":1},"Provisional Sum for Construction Costs",{"$f":"IFERROR(IF(OR(Summary!D39<>\"\",Summary!D40<>\"\",Summary!D43<>\"\",Summary!D44<>\"\"),SUM(Summary!D39,Summary!D40,Summary!D43,Summary!D44),\"\"),\"\")","v":""},5,{"$f":"IFERROR(IF(AND(D17<>\"\",E17<>\"\"),SUM(SUM(D17/E17)),\"\"),\"\")","v":""}]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D17<>\"\"),SUM(D17),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E17<>\"\"),SUM(E17),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(F17<>\"\"),SUM(F17),\"\"),\"\")","v":""}]
[]
[null,"Client Contingency - Option 4",null,"Initial Charge","Percentage Addition","Cost of % Addition"]
[null,{"$f":"IFERROR(IF(C21<>\"\",SUBTOTAL(103,$C$21:$C21),\"\"),\"\")","v":1},"Provisional Sum for Construction Costs",{"$f":"IFERROR(IF(OR(Summary!D52<>\"\",Summary!D53<>\"\",Summary!D56<>\"\",Summary!D57<>\"\"),SUM(Summary!D52,Summary!D53,Summary!D56,Summary!D57),\"\"),\"\")","v":""},5,{"$f":"IFERROR(IF(AND(D21<>\"\",E21<>\"\"),SUM(SUM(D21/E21)),\"\"),\"\")","v":""}]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D21<>\"\"),SUM(D21),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E21<>\"\"),SUM(E21),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(F21<>\"\"),SUM(F21),\"\"),\"\")","v":""}]
[]
[null,"Client Contingency - Option 5",null,"Initial Charge","Percentage Addition","Cost of % Addition"]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$25:$C25),\"\"),\"\")","v":1},"Provisional Sum for Construction Costs",{"$f":"IFERROR(IF(OR(Summary!D65<>\"\",Summary!D66<>\"\",Summary!D69<>\"\"),SUM(Summary!D65,Summary!D66,Summary!D69),\"\"),\"\")","v":""},5,{"$f":"IFERROR(IF(AND(D25<>\"\",E25<>\"\"),SUM(SUM(D25/E25)),\"\"),\"\")","v":""}]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D25<>\"\"),SUM(D25),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E25<>\"\"),SUM(E25),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(F25<>\"\"),SUM(F25),\"\"),\"\")","v":""}]
[]
[null,"Client Contingency - Option 6",null,"Initial Charge","Percentage Addition","Cost of % Addition"]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$29:$C29),\"\"),\"\")","v":1},"Provisional Sum for Construction Costs",{"$f":"IFERROR(IF(OR(Summary!D77<>\"\",Summary!D78<>\"\",Summary!D81<>\"\"),SUM(Summary!D77,Summary!D78,Summary!D81),\"\"),\"\")","v":""},5,{"$f":"IFERROR(IF(AND(D29<>\"\",E29<>\"\"),SUM(SUM(D29/E29)),\"\"),\"\")","v":""}]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D29<>\"\"),SUM(D29),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E29<>\"\"),SUM(E29),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(F29<>\"\"),SUM(F29),\"\"),\"\")","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":"Lodge Park Sports Centre - All Weather Pitch"}]
[]
["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]