{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["I&C","Summary","Schedule","AC","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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"]
[" Mechanical and Electrical Replacement Works at Corby East Midlands International Pool"]
[]
["Instructions and Contents"]
[]
["Introduction"]
[{"$f":"IFERROR(IF(Schedule!$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 \",(Schedule!$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  Mechanical and Electrical Replacement Works at Corby East Midlands International Pool requirement and will be included as an appendix to the Contract between The Supplier and Corby Borough Council."}]
[]
["Instructions"]
[{"$f":"IFERROR(IF(Schedule!$C$4<>\"\",CONCATENATE(\"All areas which require \",(Schedule!$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"]
["Pricing Schedule"]
["Additional Costs"]

{"sheet":"Summary","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"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":" Mechanical and Electrical Replacement Works at Corby East Midlands International Pool"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(Schedule!$C$4<>\"\",(Schedule!$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<>\"\"),SUM(D10:D15),\"\"),\"\")","v":15000}]
[null,{"$f":"IFERROR(IF(C10<>\"\",SUBTOTAL(103,$C$10:$C10),\"\"),\"\")","v":1},"Summary and Contract Preliminaries",{"$f":"IFERROR(IF(Schedule!F16<>\"\",SUM(Schedule!F16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C11<>\"\",SUBTOTAL(103,$C$10:$C11),\"\"),\"\")","v":2},"Standard Specifications",{"$f":"IFERROR(IF(Schedule!F20<>\"\",CONCATENATE(\"Included in Works\"),\"\"),\"\")","v":"Included in Works"}]
[null,{"$f":"IFERROR(IF(C12<>\"\",SUBTOTAL(103,$C$10:$C12),\"\"),\"\")","v":3},"Provisional Sums and Contingencies",{"$f":"IFERROR(IF(Schedule!F24<>\"\",SUM(Schedule!F24),\"\"),\"\")","v":15000}]
[null,{"$f":"IFERROR(IF(C13<>\"\",SUBTOTAL(103,$C$10:$C13),\"\"),\"\")","v":4},"Specific Mechanical Works",{"$f":"IFERROR(IF(Schedule!F30<>\"\",SUM(Schedule!F30),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C14<>\"\",SUBTOTAL(103,$C$10:$C14),\"\"),\"\")","v":5},"Specific Electrical Works",{"$f":"IFERROR(IF(Schedule!F45<>\"\",SUM(Schedule!F45),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C15<>\"\",SUBTOTAL(103,$C$10:$C15),\"\"),\"\")","v":6},"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(AC!I13<>\"\",SUM(AC!I13),\"\"),\"\")","v":""}]

{"sheet":"Schedule","index":2,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[43,1,43,2],[36,2,36,5],[41,2,41,5],[50,2,50,5],[22,1,22,2],[28,1,28,2],[9,0,9,5],[14,1,14,2],[18,1,18,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]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":" Mechanical and Electrical Replacement Works at Corby East Midlands International Pool"}]
[]
["Supplier:"]
["Sub-Heading:",null,"Pricing Schedule"]
["Pricing Schedule"]
[]
["The total of this Schedule will be carried to the Summary."]
[]
["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<>\"\",F20<>\"\",F24<>\"\",F30<>\"\",F45<>\"\"),SUM(F16,F20,F24,F30,F45),\"\"),\"\")","v":15000}]
[]
[null,"Summary and Contract Preliminaries",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D17<>\"\"),SUM(D17:D17),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E17<>\"\"),SUM(E17:E17),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F17<>\"\"),SUM(F17:F17),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C17<>\"\",SUBTOTAL(103,$C$17:$C17),\"\"),\"\")","v":1},"Contract Preliminaries",1,null,{"$f":"IFERROR(IF(AND(D17<>\"\",E17<>\"\"),SUM(D17*E17),\"\"),\"\")","v":""}]
[]
[null,"Standard Specifications",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D21<>\"\"),SUM(D21:D21),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E21<>\"\"),CONCATENATE(\"N/A\"),\"\"),\"\")","v":"N/A"},{"$f":"IFERROR(IF(OR(F21<>\"\"),CONCATENATE(\"Included in Works\"),\"\"),\"\")","v":"Included in Works"}]
[null,{"$f":"IFERROR(IF(C21<>\"\",SUBTOTAL(103,$C$21:$C21),\"\"),\"\")","v":1},"Workmanship Clauses (included in the works)",1,"N/A",{"$f":"IFERROR(IF(AND(D21<>\"\",E21<>\"\"),CONCATENATE(\"Included in Works\"),\"\"),\"\")","v":"Included in Works"}]
[]
[null,"Provisional Sums and Contingencies",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D25<>\"\"),SUM(D25:D25),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E25<>\"\",E26<>\"\",E27<>\"\"),SUM(E25:E27),\"\"),\"\")","v":15000},{"$f":"IFERROR(IF(OR(F25<>\"\",F26<>\"\",F27<>\"\"),SUM(F25:F27),\"\"),\"\")","v":15000}]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$25:$C25),\"\"),\"\")","v":1},"For unseen Mechanical Works",1,11000,{"$f":"IFERROR(IF(AND(D25<>\"\",E25<>\"\"),SUM(D25*E25),\"\"),\"\")","v":11000}]
[null,{"$f":"IFERROR(IF(C26<>\"\",SUBTOTAL(103,$C$25:$C26),\"\"),\"\")","v":2},"Allow for provisional sum for steel cage installation around ventilation terminal",1,2000,{"$f":"IFERROR(IF(AND(D26<>\"\",E26<>\"\"),SUM(D26*E26),\"\"),\"\")","v":2000}]
[null,{"$f":"IFERROR(IF(C27<>\"\",SUBTOTAL(103,$C$25:$C27),\"\"),\"\")","v":3},"For unseen Electrical Works",1,2000,2000]
[]
[null,"Specific Mechanical Works",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D31<>\"\",D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\",D38<>\"\",D39<>\"\",D40<>\"\",D41<>\"\",D42<>\"\"),SUM(D31:D42),\"\"),\"\")","v":10},{"$f":"IFERROR(IF(OR(E31<>\"\",E32<>\"\",E33<>\"\",E34<>\"\",E35<>\"\",E36<>\"\",E37<>\"\",E38<>\"\",E39<>\"\",E40<>\"\",E41<>\"\",E42<>\"\"),SUM(E31:E42),\"\"),\"\")","v":""},""]
[null,{"$f":"IFERROR(IF(C31<>\"\",SUBTOTAL(103,$C$31:$C31),\"\"),\"\")","v":1},"Undercroft mechanical ventilation installation complete works - except controls installation by BMS specialists.",1,null,{"$f":"IFERROR(IF(AND(D31<>\"\",E31<>\"\"),SUM(D31*E31),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C32<>\"\",SUBTOTAL(103,$C$31:$C32),\"\"),\"\")","v":2},"Undercroft mechanical ventilation BMS controls installations.",1,null,{"$f":"IFERROR(IF(AND(D32<>\"\",E32<>\"\"),SUM(D32*E32),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C33<>\"\",SUBTOTAL(103,$C$31:$C33),\"\"),\"\")","v":3},"Calorex units refurbishment works by specialists including all required services within tender documentation.",1,null,""]
[null,{"$f":"IFERROR(IF(C34<>\"\",SUBTOTAL(103,$C$31:$C34),\"\"),\"\")","v":4},"Re-commissioning and balancing of the existing AHU's secondary systems servicing the pool hall, wet change village and the spectator areas to ensure the systems are balanced to design flow rates and overall pool hall is under negative pressure.",1,null,""]
[null,{"$f":"IFERROR(IF(C35<>\"\",SUBTOTAL(103,$C$31:$C35),\"\"),\"\")","v":5},"Employ building existing BMS controls specialists to visit full day to adjust the head end operational times and train the systems end users.",1,null,""]
[null,{"$f":"IFERROR(IF(C36<>\"\",SUBTOTAL(103,$C$31:$C36),\"\"),\"\")","v":6},"Installation of thermal insulation to the existing LPHW plate heat exchangers within the Undercroft plant room area.",1,null,{"$f":"IFERROR(IF(AND(D36<>\"\",E36<>\"\"),SUM(D36*E36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C37<>\"\",SUBTOTAL(103,$C$31:$C37),\"\"),\"\")","v":7},"Employ specialists to provide custom made pool covers to Main pool area."]
[null,"7a.","Main pool only pool cover installation.",1,null,""]
[null,"7b.","Learner pool only pool cover installation.",1,null,""]
[null,8,"Builder’s Work including, cutting holes, making good walls, ceiling, modification to suit new fans etc.",1,null,""]
[null,9,"Provision of O&M Manuals for the whole project including H&S information, test and commissioning certificates, as built drawings all in accordance with tender.",1,null,""]
[null,10,"Allow for any other works detailed on the drawings but not listed above, in the Additional Costs (AC) tab. If no items are listed, the tenderer agrees that the full works are included within the above rates and form an all-inclusive tender."]
[]
[null,"Specific Electrical Works",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D46<>\"\",D47<>\"\",D48<>\"\",D49<>\"\",D50<>\"\",D51<>\"\"),SUM(D46:D51),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E46<>\"\",E47<>\"\",E48<>\"\",E49<>\"\",E50<>\"\",E51<>\"\"),SUM(E46:E51),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F46<>\"\",F47<>\"\",F48<>\"\",F49<>\"\",F50<>\"\",F51<>\"\"),SUM(F46:F51),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C46<>\"\",SUBTOTAL(103,$C$46:$C46),\"\"),\"\")","v":1},"Undercroft Ventilation Distribution board and electrical distribution cabling.",1,null,{"$f":"IFERROR(IF(AND(D46<>\"\",E46<>\"\"),SUM(D46*E46),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C47<>\"\",SUBTOTAL(103,$C$46:$C47),\"\"),\"\")","v":2},"Undercroft Ventilation Electrical supplies installation.",1,null,{"$f":"IFERROR(IF(AND(D47<>\"\",E47<>\"\"),SUM(D47*E47),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C48<>\"\",SUBTOTAL(103,$C$46:$C48),\"\"),\"\")","v":3},"Pool cover Electrical Supplies complete installation.",1,null,""]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$C$46:$C49),\"\"),\"\")","v":4},"Builder’s Work including, cutting holes, making good walls,Fire Proofing, ceiling, etc.",1,null,""]
[null,{"$f":"IFERROR(IF(C50<>\"\",SUBTOTAL(103,$C$46:$C50),\"\"),\"\")","v":5},"Provision of design calculations, O&M Manuals for the whole project including H&S information, test and commissioning certificates, as built drawings in accordance with standard clauses.",1,null,""]
[null,{"$f":"IFERROR(IF(C51<>\"\",SUBTOTAL(103,$C$46:$C51),\"\"),\"\")","v":6},"Allow for any other works detailed on the drawings but not listed above, in the Additional Costs (AC) tab. If no items are listed, the tenderer agrees that the full works are included within the above rates and form an all-inclusive tender."]

{"sheet":"AC","index":3,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
["Previous Page",null,"Contents"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":" Mechanical and Electrical Replacement Works at Corby East Midlands International Pool"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(Schedule!$C$4<>\"\",(Schedule!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Additional Costs Not Otherwise Specified"]
["Pricing Schedule"]
[]
[null,{"$f":"IFERROR(IF(Schedule!$C$4<>\"\",CONCATENATE((Schedule!$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":4,"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]