{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["I&C","Summary","SoWR","Add"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":18,"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":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Next Page"]
["Replacement of Heating Systems at Community Centres"]
[]
["Instructions and Contents"]
[]
["Introduction"]
[{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",CONCATENATE(\"This document forms the Pricing Schedule for Corby Borough Council’s requirement for \",('I&C'!$A$2),\" 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 requirement for \",('I&C'!$A$2),\" 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 requirement for Replacement of Heating Systems at Community Centres 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"]
["Additional Costs Not Otherwise Specified"]

{"sheet":"Summary","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"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":"Replacement of Heating Systems at Community Centres"}]
[]
["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(D10<>\"\",D11<>\"\",D12<>\"\",D13<>\"\",D14<>\"\",D15<>\"\",D16<>\"\"),SUM(D10:D16),\"\"),\"\")","v":17930}]
[null,1,"Summary and Contract Preliminaries",{"$f":"IFERROR(IF(SoWR!F12<>\"\",SUM(SoWR!F12),\"\"),\"\")","v":""}]
[null,2,"Standard Specifications","Included in Works"]
[null,3,"Provisional Sums and Contingencies",{"$f":"IFERROR(IF(SoWR!F22<>\"\",SUM(SoWR!F22),\"\"),\"\")","v":17930}]
[null,"4.1.","Specific Mechanical Works - Kingswood Neighbourhood Centre",{"$f":"IFERROR(IF(SoWR!F29<>\"\",SUM(SoWR!F29),\"\"),\"\")","v":""}]
[null,"4.2.","Specific Mechanical Works - Danesholme Communicare Centre",{"$f":"IFERROR(IF(SoWR!F45<>\"\",SUM(SoWR!F45),\"\"),\"\")","v":""}]
[null,"4.3.","Specific Mechanical Works - The Autumn Centre",{"$f":"IFERROR(IF(SoWR!F61<>\"\",SUM(SoWR!F61),\"\"),\"\")","v":""}]
[null,5,"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(Add!I13<>\"\",SUM(Add!I13),\"\"),\"\")","v":""}]

{"sheet":"SoWR","index":2,"n_rows":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":false,"merged":[[7,0,7,5],[9,1,9,2],[14,1,14,2],[1,0,1,5],[5,0,5,5],[4,2,4,5],[19,1,19,2],[26,1,26,2],[42,1,42,2],[58,1,58,2]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Replacement of Heating Systems at Community Centres"}]
[]
["Supplier:"]
["Sub-Heading:",null,"Schedule of Works/Rates"]
["Pricing Schedule"]
[]
["For the complete supply and installation, testing, commissioning and setting to work, as indicated and specified."]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,1,"Summary and Contract Preliminaries"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D13<>\"\"),SUM(D13:D13),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E13<>\"\"),SUM(E13:E13),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F13<>\"\"),SUM(F13:F13),\"\"),\"\")","v":""}]
[null,1.1000000000000001,"Contract Preliminaries",1,null,{"$f":"IFERROR(IF(AND(D13<>\"\",E13<>\"\"),SUM(D13*E13),\"\"),\"\")","v":""}]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,2,"Standard Specifications"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D18<>\"\"),SUM(D18:D18),\"\"),\"\")","v":1},"N/A","N/A"]
[null,1,"Workmanship Clauses",1,"Included in Works","Included in Works"]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,3,"Provisional Sums and Contingencies"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D23<>\"\",D24<>\"\",D25<>\"\"),SUM(D23:D25),\"\"),\"\")","v":3},{"$f":"IFERROR(IF(OR(E23<>\"\",E24<>\"\",E25<>\"\"),SUM(E23:E25),\"\"),\"\")","v":17930},{"$f":"IFERROR(IF(OR(F23<>\"\",F24<>\"\",F25<>\"\"),SUM(F23:F25),\"\"),\"\")","v":17930}]
[null,1,"For unforeseen mechanical works",1,5430,{"$f":"IFERROR(IF(AND(D23<>\"\",E23<>\"\"),SUM(D23*E23),\"\"),\"\")","v":5430}]
[null,2,"Provision cost of asbestos removal works",1,10000,{"$f":"IFERROR(IF(AND(D24<>\"\",E24<>\"\"),SUM(D24*E24),\"\"),\"\")","v":10000}]
[null,3,"Provisional sum for Kingswood Children’s Centre investigative works on site for balancing of heating system and radiators, TRV’s replacement if required served by Boiler Room 01.",1,2500,2500]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"4.1.","Specific Mechanical Works - Kingswood Neighbourhood Centre"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D30<>\"\",D31<>\"\",D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\",D38<>\"\",D39<>\"\",D40<>\"\",D41<>\"\"),SUM(D30:D41),\"\"),\"\")","v":12},{"$f":"IFERROR(IF(OR(E30<>\"\",E31<>\"\",E32<>\"\",E33<>\"\",E34<>\"\",E35<>\"\",E36<>\"\",E37<>\"\",E38<>\"\",E39<>\"\",E40<>\"\",E41<>\"\"),SUM(E30:E41),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F30<>\"\",F31<>\"\",F32<>\"\",F33<>\"\",F34<>\"\",F35<>\"\",F36<>\"\",F37<>\"\",F38<>\"\",F39<>\"\",F40<>\"\",F41<>\"\"),SUM(F30:F41),\"\"),\"\")","v":""}]
[null,"4.1.1.","Removal of existing plant equipment gas fired boilers, pipework, flue, circulation pump, controls in Boiler Room 02, 04.",1,null,{"$f":"IFERROR(IF(AND(D30<>\"\",E30<>\"\"),SUM(D30*E30),\"\"),\"\")","v":""}]
[null,"4.1.2.","Provision and installation of new gas fired condensing boilers including new flue kit, shunt pumps, circulation pump, manufacturer controls on like for like sizing basis in Boiler room 02, 04. ",1]
[null,"4.1.3.","Supply and installation of new DHWF&R, CWMS pipework connections to boilers including all necessary valves, sensors, gauges.  ",1]
[null,"4.1.4.","Supply and installation of new LTHW pipework to connect from the boiler to the existing HTG pipework and to the new fan convectors including all necessary valves, sensors, gauges.",1]
[null,"4.1.5.","Supply and installation of new thermal insulation including fire-rated collars to new pipework in the Boiler room 02, 04 and new fan convectors area.",1]
[null,"4.1.6.","Supply and installation of new Gas pipework connections to boilers including gas cocks, solenoid valves.",1]
[null,"4.1.7.","Supply and installation of new fan convectors with all necessary valves, controls.",1]
[null,"4.1.8.","Builder’s Work including, cutting holes, making good floor, walls, ceiling, modification to suit a new flue kit, new fan convectors area etc.",1]
[null,"4.1.9.","Pressure tests of the gas, LTHW, DHWF&R and CWMS pipework's, chemical dosing of LTHW heating system, Commissioning and Balancing.",1]
[null,"4.1.10.","Chlorination of the existing Domestic water services.",1]
[null,"4.1.11.","Removal of existing controls, supply and installation of new manufacturer controller including electrical wiring in the Boiler Room 02, 04.",1]
[null,"4.1.12.","Removal of existing fan convectors thermostat controls, electrical wiring. Supply and installation of new controls including electrical wiring to the FC's.",1]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"4.2.","Specific Mechanical Works - Danesholme Communicare Centre"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D46<>\"\",D47<>\"\",D48<>\"\",D49<>\"\",D50<>\"\",D51<>\"\",D52<>\"\",D53<>\"\",D54<>\"\",D55<>\"\",D56<>\"\",D57<>\"\"),SUM(D46:D57),\"\"),\"\")","v":12},{"$f":"IFERROR(IF(OR(E46<>\"\",E47<>\"\",E48<>\"\",E49<>\"\",E50<>\"\",E51<>\"\",E52<>\"\",E53<>\"\",E54<>\"\",E55<>\"\",E56<>\"\",E57<>\"\"),SUM(E46:E57),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F46<>\"\",F47<>\"\",F48<>\"\",F49<>\"\",F50<>\"\",F51<>\"\",F52<>\"\",F53<>\"\",F54<>\"\",F55<>\"\",F56<>\"\",F57<>\"\"),SUM(F46:F57),\"\"),\"\")","v":""}]
[null,"4.2.1.","Removal of existing plant equipment gas fired floor standing redundant boilers, pipework, flue, circulation pump, controls in Boiler Room 01. ",1,null,{"$f":"IFERROR(IF(AND(D46<>\"\",E46<>\"\"),SUM(D46*E46),\"\"),\"\")","v":""}]
[null,"4.2.2.","Provision and installation of new and existing gas fired condensing boilers including new frame kit, gas and heating header, flue kit, modulating controls kit, twin head pump on like for like sizing basis.",1]
[null,"4.2.3.","Supply and installation of new DHWF&R, CWMS pipework and connections to boilers including all necessary valves, sensors, gauges.  ",1]
[null,"4.2.4.","Supply and installation of new LTHW pipework to connect from the boiler to the existing HTG pipework and to the new fan convectors including all necessary valves, sensors, gauges.",1]
[null,"4.2.5.","Supply and installation of new thermal insulation including fire-rated collars to new pipework in the Boiler room 01 and new fan convectors area.",1]
[null,"4.2.6.","Supply and installation of new Gas pipework to boilers including gas cocks, solenoid valves linked to MCP.",1]
[null,"4.2.7.","Supply and installation of new fan convectors with all necessary valves, controls.",1]
[null,"4.2.8.","Builder’s Work including, cutting holes, making good floor, walls, ceiling, modification to suit a new flue kit, new fan convectors area etc.",1]
[null,"4.2.9.","Pressure tests of the gas, LTHW, DHWF&R and CWMS pipework's, chemical dosing of LTHW heating system, Commissioning and Balancing.",1]
[null,"4.2.10.","Chlorination of the existing Domestic water services.",1]
[null,"4.2.11.","Removal of existing controls, supply and installation of new Mechanical Control Panel including electrical wiring in the Boiler Room 01 by contractor's appointed and approved controls specialist.",1]
[null,"4.2.12.","Removal of existing fan convectors thermostat controls, electrical wiring. Supply and installation of new controls including electrical wiring to the FC's.",1]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"4.3.","Specific Mechanical Works - The Autumn Centre"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D62<>\"\",D63<>\"\",D64<>\"\",D65<>\"\",D66<>\"\",D67<>\"\",D68<>\"\",D69<>\"\",D70<>\"\",D71<>\"\",D72<>\"\",D73<>\"\",D74<>\"\",D75<>\"\"),SUM(D62:D75),\"\"),\"\")","v":14},{"$f":"IFERROR(IF(OR(E62<>\"\",E63<>\"\",E64<>\"\",E65<>\"\",E66<>\"\",E67<>\"\",E68<>\"\",E69<>\"\",E70<>\"\",E71<>\"\",E72<>\"\",E73<>\"\",E74<>\"\",E75<>\"\"),SUM(E62:E75),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F62<>\"\",F63<>\"\",F64<>\"\",F65<>\"\",F66<>\"\",F67<>\"\",F68<>\"\",F69<>\"\",F70<>\"\",F71<>\"\",F72<>\"\",F73<>\"\",F74<>\"\",F75<>\"\"),SUM(F62:F75),\"\"),\"\")","v":""}]
[null,"4.3.1.","Removal of existing plant equipment gas fired boilers, pipework, flue, circulation pump, controls in Boiler Room 02, 03.",1,null,{"$f":"IFERROR(IF(AND(D62<>\"\",E62<>\"\"),SUM(D62*E62),\"\"),\"\")","v":""}]
[null,"4.3.2.","Provision and installation of new gas fired condensing boilers including new flue kit, shunt pumps, circulation pumps, manufacturer controls on like for like sizing basis in Boiler room 02, 03. ",1]
[null,"4.3.3.","Supply and installation of new DHWF&R, CWMS pipework connections to boilers including all necessary valves, sensors, gauges.  ",1]
[null,"4.3.4.","Supply and installation of new LTHW pipework to connect from the boiler to the existing HTG pipework and to the new fan convectors including all necessary valves, sensors, gauges.",1]
[null,"4.3.5.","Supply and installation of new thermal insulation including fire-rated collars to new pipework in the Boiler room 02, 03 and new fan convectors area.",1]
[null,"4.3.6.","Supply and installation of new Gas pipework connections to boilers including gas cocks, solenoid valves.",1]
[null,"4.3.7.","Supply and installation of new fan convectors with all necessary valves, controls.",1]
[null,"4.3.8.","Builder’s Work including, cutting holes, making good floor, walls, ceiling, modification to suit a new flue kit, new fan convectors area etc.",1]
[null,"3.3.9.","Pressure tests of the gas, LTHW, DHWF&R and CWMS pipework's, chemical dosing of LTHW heating system, Commissioning and Balancing.",1]
[null,"4.3.10.","Chlorination of the existing Domestic water services.",1]
[null,"4.3.11.","Removal of existing controls, supply and installation of new manufacturer controller including electrical wiring in the Boiler Room 02, 03.",1]
[null,"4.3.12.","Removal of existing fan convectors thermostat controls, electrical wiring. Supply and installation of new controls including electrical wiring to the FC's.",1]
[null,"4.3.13.","Water systems specialists Laboratory testing and checking of centres DWS and updating of centres existing water risk assessments.",1]
[null,"4.3.14.","Provision of O&M Manuals for the whole project including H&S information, test and commissioning certificates, as built drawings in accordance with standard clauses. ",1]

{"sheet":"Add","index":3,"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":"Replacement of Heating Systems at Community Centres"}]
[]
["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 and all additional items for which they require reimbursement. The items should be related to particular 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 paid by the Council.\"),CONCATENATE(\"The Supplier is to detail, below, any and all additional items for which they require reimbursement. The items should be related to particular 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 paid by the Council.\")),\"\")","v":"The Supplier is to detail, below, any and all additional items for which they require reimbursement. The items should be related to particular clause references and the costs idetified as ''Fixed'' or ''Time Related'' charges.\n\n Items which are not included herein will not be paid 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,"Page 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,"Additional Item List",null,null,null,"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,"Preliminary Item List",null,null,null,"Clause Ref:",null,"Fixed or\nTime Related","Cost"]
[null,{"$f":"IFERROR(IF(C48<>\"\",SUBTOTAL(103,$C$48:$C48),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$C$48:$C49),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C50<>\"\",SUBTOTAL(103,$C$48:$C50),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C51<>\"\",SUBTOTAL(103,$C$48:$C51),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C52<>\"\",SUBTOTAL(103,$C$48:$C52),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C53<>\"\",SUBTOTAL(103,$C$48:$C53),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C54<>\"\",SUBTOTAL(103,$C$48:$C54),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C55<>\"\",SUBTOTAL(103,$C$48:$C55),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$C$48:$C56),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C57<>\"\",SUBTOTAL(103,$C$48:$C57),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C58<>\"\",SUBTOTAL(103,$C$48:$C58),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C59<>\"\",SUBTOTAL(103,$C$48:$C59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C60<>\"\",SUBTOTAL(103,$C$48:$C60),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C61<>\"\",SUBTOTAL(103,$C$48:$C61),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C62<>\"\",SUBTOTAL(103,$C$48:$C62),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C63<>\"\",SUBTOTAL(103,$C$48:$C63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$C$48:$C64),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$C$48:$C65),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$C$48:$C66),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$C$48:$C67),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C68<>\"\",SUBTOTAL(103,$C$48:$C68),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C69<>\"\",SUBTOTAL(103,$C$48:$C69),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C70<>\"\",SUBTOTAL(103,$C$48:$C70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C71<>\"\",SUBTOTAL(103,$C$48:$C71),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C72<>\"\",SUBTOTAL(103,$C$48:$C72),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C73<>\"\",SUBTOTAL(103,$C$48:$C73),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C74<>\"\",SUBTOTAL(103,$C$48:$C74),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C75<>\"\",SUBTOTAL(103,$C$48:$C75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$C$48:$C76),\"\"),\"\")","v":""}]