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

{"sheet":"Summary","index":1,"n_rows":39,"n_cols":4,"rows_kept":39,"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":"Grosvenor House Boiler Replacement"}]
[]
["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<>\"\"),SUM(D10,D11,D12:D13),\"\"),\"\")","v":5000}]
[null,1,"Schedule of Works/Rates",{"$f":"IFERROR(IF(D16<>\"\",SUM(D16),\"\"),\"\")","v":5000}]
[null,2,"Analysis of Tender: Mechanical",{"$f":"IFERROR(IF(OR(Mech!F19<>\"\"),SUM(Mech!F19),\"\"),\"\")","v":""}]
[null,3,"Out-of-Hours Rates",{"$f":"IFERROR(IF(OoH!F172<>\"\",SUM(OoH!F172),\"\"),\"\")","v":""}]
[null,4,"Additional Costs Not Otherwise Specified",{"$f":"IFERROR(IF(Add!I13<>\"\",SUM(Add!I13),\"\"),\"\")","v":""}]
[]
[null,null,"Summary Section Detail","Option Costs"]
[null,"Summary Total carried to Evaluation",null,{"$f":"IFERROR(IF(OR(D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\",D21<>\"\",D22<>\"\",D23<>\"\",D24<>\"\",D25<>\"\",D26<>\"\",D27<>\"\",D28<>\"\",D29<>\"\",D30<>\"\",D31<>\"\",D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\",D38<>\"\",D39<>\"\"),SUM(D17:D39),\"\"),\"\")","v":5000}]
[null,"1.1.1.",{"$f":"IFERROR(IF(B17<>\"\",VLOOKUP(B17,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"For all specified surveys including asbestos refurbishment and CCTV flue inspections, testing and reports, removal of\nall obsolete services and notices and temporary provisions including lockable skips (if required)."},{"$f":"IFERROR(IF(B17<>\"\",VLOOKUP(B17,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.2.1.",{"$f":"IFERROR(IF(B18<>\"\",VLOOKUP(B18,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"New LPHW gas fired boiler plant and new flues to existing shaft as specified including two new boilers, two new flue\nliners and terminals, plus new invertor single head pump sets for each circuit and new sealed system F&E, PLUS new\nduty/standby sump pumps as specified or equal and approved equivalent."},{"$f":"IFERROR(IF(B18<>\"\",VLOOKUP(B18,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.3.1.",{"$f":"IFERROR(IF(B19<>\"\",VLOOKUP(B19,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Extending existing gas supplies with new pipework to serve new boilers including utilising existing safety shut-off\nvalve (allowance for new gas valve to be included and saving option to be offered to client, subject to satisfactory\nsurvey/testing etc)."},{"$f":"IFERROR(IF(B19<>\"\",VLOOKUP(B19,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.3.2.",{"$f":"IFERROR(IF(B20<>\"\",VLOOKUP(B20,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Modify existing LPHW mains, headers and distributing pipework within boiler houses including new Spirocross low\nloss air/dirt separators, new X-Pot c/w auto-controls and connections to existing distribution system retained/reused\nwith new valves on existing mains within boiler room."},{"$f":"IFERROR(IF(B20<>\"\",VLOOKUP(B20,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.3.3.",{"$f":"IFERROR(IF(B21<>\"\",VLOOKUP(B21,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Essential temporaries and modifications to existing heating and electrical services to facilitate new boiler plant."},{"$f":"IFERROR(IF(B21<>\"\",VLOOKUP(B21,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.4.1.",{"$f":"IFERROR(IF(B22<>\"\",VLOOKUP(B22,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"All Pipework Services: FOR PLANT ROOMS PLUS approx. 10m of existing MCW supply at high level of basement to\nOlive restaurant."},{"$f":"IFERROR(IF(B22<>\"\",VLOOKUP(B22,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.5.1.",{"$f":"IFERROR(IF(B23<>\"\",VLOOKUP(B23,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Lighting Installation – alterations."},{"$f":"IFERROR(IF(B23<>\"\",VLOOKUP(B23,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.5.2.",{"$f":"IFERROR(IF(B24<>\"\",VLOOKUP(B24,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Small Power Installation – alterations."},{"$f":"IFERROR(IF(B24<>\"\",VLOOKUP(B24,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.5.3.",{"$f":"IFERROR(IF(B25<>\"\",VLOOKUP(B25,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Earth Bonding – upgrades."},{"$f":"IFERROR(IF(B25<>\"\",VLOOKUP(B25,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.6.1.",{"$f":"IFERROR(IF(B26<>\"\",VLOOKUP(B26,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Supply of upgraded BMS controller, controls, wiring and final commissioning by specialists responsible for\nBMA/controls and fire alarm interfaces."},{"$f":"IFERROR(IF(B26<>\"\",VLOOKUP(B26,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.7.1.",{"$f":"IFERROR(IF(B27<>\"\",VLOOKUP(B27,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Extension and alterations to floor/concrete bases for plant."},{"$f":"IFERROR(IF(B27<>\"\",VLOOKUP(B27,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.7.2.",{"$f":"IFERROR(IF(B28<>\"\",VLOOKUP(B28,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Cleaning and modifying associated floor gulley/sump pump pit and drainage FOR PLANT ROOM."},{"$f":"IFERROR(IF(B28<>\"\",VLOOKUP(B28,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.7.3.",{"$f":"IFERROR(IF(B29<>\"\",VLOOKUP(B29,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Making good and fire stopping around services."},{"$f":"IFERROR(IF(B29<>\"\",VLOOKUP(B29,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.7.4.",{"$f":"IFERROR(IF(B30<>\"\",VLOOKUP(B30,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Flue/terminal structural remedial works and redecoration works as specified."},{"$f":"IFERROR(IF(B30<>\"\",VLOOKUP(B30,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.7.5.",{"$f":"IFERROR(IF(B31<>\"\",VLOOKUP(B31,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"BWIC with replacing/upgrading existing 600mm (approx.) square vent louvres with FOUR new fire damper/thermal\nlinks with fire stopping/making good as appropriate to maintain compartmentation and match existing."},{"$f":"IFERROR(IF(B31<>\"\",VLOOKUP(B31,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.8.1.",{"$f":"IFERROR(IF(B32<>\"\",VLOOKUP(B32,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Existing and New Gas Services."},{"$f":"IFERROR(IF(B32<>\"\",VLOOKUP(B32,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.8.2.",{"$f":"IFERROR(IF(B33<>\"\",VLOOKUP(B33,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Cleansing and final water treatment for all LPHW space heating and only associated domestic pipework systems."},{"$f":"IFERROR(IF(B33<>\"\",VLOOKUP(B33,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.8.3.",{"$f":"IFERROR(IF(B34<>\"\",VLOOKUP(B34,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"All new boiler plant, equipment, pipework services, associated H&V control panel, controls and electrical services."},{"$f":"IFERROR(IF(B34<>\"\",VLOOKUP(B34,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.9.1.",{"$f":"IFERROR(IF(B35<>\"\",VLOOKUP(B35,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Fully co-ordinated detailed working and associated BWIC drawings."},{"$f":"IFERROR(IF(B35<>\"\",VLOOKUP(B35,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.9.2.",{"$f":"IFERROR(IF(B36<>\"\",VLOOKUP(B36,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"‘As Installed’ drawings and details."},{"$f":"IFERROR(IF(B36<>\"\",VLOOKUP(B36,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.9.3.",{"$f":"IFERROR(IF(B37<>\"\",VLOOKUP(B37,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"All Operating and Maintenance Manuals."},{"$f":"IFERROR(IF(B37<>\"\",VLOOKUP(B37,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.9.4.",{"$f":"IFERROR(IF(B38<>\"\",VLOOKUP(B38,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"Handover procedures and practical demonstration to CBC staff and Client representatives."},{"$f":"IFERROR(IF(B38<>\"\",VLOOKUP(B38,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":""}]
[null,"1.10.1.",{"$f":"IFERROR(IF(B39<>\"\",VLOOKUP(B39,SoWR!$B$10:$F$72,2,0),\"\"),\"\")","v":"PC and Provisional Sums"},{"$f":"IFERROR(IF(B39<>\"\",VLOOKUP(B39,SoWR!$B$10:$F$72,5,0),\"\"),\"\")","v":5000}]

{"sheet":"SoWR","index":2,"n_rows":71,"n_cols":6,"rows_kept":71,"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],[52,1,52,2],[59,1,59,2],[67,1,67,2],[19,1,19,2],[26,1,26,2],[31,1,31,2],[38,1,38,2],[43,1,43,2]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Grosvenor House Boiler Replacement"}]
[]
["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.1.","Inspections, Reports, Removal and Temporary Works"]
[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.1.1.","For all specified surveys including asbestos refurbishment and CCTV flue inspections, testing and reports, removal of\nall obsolete services and notices and temporary provisions including lockable skips (if required).",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,"1.2.","New Main Plant"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D18<>\"\"),SUM(D18:D18),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E18<>\"\"),SUM(E18:E18),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F18<>\"\"),SUM(F18:F18),\"\"),\"\")","v":""}]
[null,"1.2.1.","New LPHW gas fired boiler plant and new flues to existing shaft as specified including two new boilers, two new flue\nliners and terminals, plus new invertor single head pump sets for each circuit and new sealed system F&E, PLUS new\nduty/standby sump pumps as specified or equal and approved equivalent.",1,null,{"$f":"IFERROR(IF(AND(D18<>\"\",E18<>\"\"),SUM(D18*E18),\"\"),\"\")","v":""}]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.3.","New Piped Services"]
[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":""},{"$f":"IFERROR(IF(OR(F23<>\"\",F24<>\"\",F25<>\"\"),SUM(F23:F25),\"\"),\"\")","v":""}]
[null,"1.3.1.","Extending existing gas supplies with new pipework to serve new boilers including utilising existing safety shut-off\nvalve (allowance for new gas valve to be included and saving option to be offered to client, subject to satisfactory\nsurvey/testing etc).",1,null,{"$f":"IFERROR(IF(AND(D23<>\"\",E23<>\"\"),SUM(D23*E23),\"\"),\"\")","v":""}]
[null,"1.3.2.","Modify existing LPHW mains, headers and distributing pipework within boiler houses including new Spirocross low\nloss air/dirt separators, new X-Pot c/w auto-controls and connections to existing distribution system retained/reused\nwith new valves on existing mains within boiler room.",1,null,{"$f":"IFERROR(IF(AND(D24<>\"\",E24<>\"\"),SUM(D24*E24),\"\"),\"\")","v":""}]
[null,"1.3.3.","Essential temporaries and modifications to existing heating and electrical services to facilitate new boiler plant.",1,null,""]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.4.","New Thermal Insulation"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D30<>\"\"),SUM(D30:D30),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E30<>\"\"),SUM(E30:E30),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F30<>\"\"),SUM(F30:F30),\"\"),\"\")","v":""}]
[null,"1.4.1.","All Pipework Services: FOR PLANT ROOMS PLUS approx. 10m of existing MCW supply at high level of basement to\nOlive restaurant.",1,null,{"$f":"IFERROR(IF(AND(D30<>\"\",E30<>\"\"),SUM(D30*E30),\"\"),\"\")","v":""}]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.5.","Electrical Services"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D35<>\"\",D36<>\"\",D37<>\"\"),SUM(D35:D37),\"\"),\"\")","v":3},{"$f":"IFERROR(IF(OR(E35<>\"\",E36<>\"\",E37<>\"\"),SUM(E35:E37),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F35<>\"\",F36<>\"\",F37<>\"\"),SUM(F35:F37),\"\"),\"\")","v":""}]
[null,"1.5.1.","Lighting Installation – alterations.",1,null,{"$f":"IFERROR(IF(AND(D35<>\"\",E35<>\"\"),SUM(D35*E35),\"\"),\"\")","v":""}]
[null,"1.5.2.","Small Power Installation – alterations.",1,null,{"$f":"IFERROR(IF(AND(D36<>\"\",E36<>\"\"),SUM(D36*E36),\"\"),\"\")","v":""}]
[null,"1.5.3.","Earth Bonding – upgrades.",1,null,""]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.6.","H&V Control Panel Installations"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D42<>\"\"),SUM(D42:D42),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E42<>\"\"),SUM(E42:E42),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F42<>\"\"),SUM(F42:F42),\"\"),\"\")","v":""}]
[null,"1.6.1.","Supply of upgraded BMS controller, controls, wiring and final commissioning by specialists responsible for\nBMA/controls and fire alarm interfaces.",1,null,{"$f":"IFERROR(IF(AND(D42<>\"\",E42<>\"\"),SUM(D42*E42),\"\"),\"\")","v":""}]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.7.","BWIC Services"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D47<>\"\",D48<>\"\",D49<>\"\",D50<>\"\",D51<>\"\"),SUM(D47:D51),\"\"),\"\")","v":8},{"$f":"IFERROR(IF(OR(E47<>\"\",E48<>\"\",E49<>\"\",E50<>\"\",E51<>\"\"),SUM(E47:E51),\"\"),\"\")","v":""},""]
[null,"1.7.1.","Extension and alterations to floor/concrete bases for plant.",1,null,{"$f":"IFERROR(IF(AND(D47<>\"\",E47<>\"\"),SUM(D47*E47),\"\"),\"\")","v":""}]
[null,"1.7.2.","Cleaning and modifying associated floor gulley/sump pump pit and drainage FOR PLANT ROOM.",1,null,{"$f":"IFERROR(IF(AND(D48<>\"\",E48<>\"\"),SUM(D48*E48),\"\"),\"\")","v":""}]
[null,"1.7.3.","Making good and fire stopping around services.",1,null,""]
[null,"1.7.4.","Flue/terminal structural remedial works and redecoration works as specified.",1,null,""]
[null,"1.7.5.","BWIC with replacing/upgrading existing 600mm (approx.) square vent louvres with FOUR new fire damper/thermal\nlinks with fire stopping/making good as appropriate to maintain compartmentation and match existing.",4,null,{"$f":"IFERROR(IF(AND(D51<>\"\",E51<>\"\"),SUM(D51*E51),\"\"),\"\")","v":""}]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.8.","Testing and Commissioning"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D56<>\"\",D57<>\"\",D58<>\"\"),SUM(D56:D58),\"\"),\"\")","v":3},{"$f":"IFERROR(IF(OR(E56<>\"\",E57<>\"\",E58<>\"\"),SUM(E56:E58),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F56<>\"\",F57<>\"\",F58<>\"\"),SUM(F56:F58),\"\"),\"\")","v":""}]
[null,"1.8.1.","Existing and New Gas Services.",1,null,{"$f":"IFERROR(IF(AND(D56<>\"\",E56<>\"\"),SUM(D56*E56),\"\"),\"\")","v":""}]
[null,"1.8.2.","Cleansing and final water treatment for all LPHW space heating and only associated domestic pipework systems.",1,null,{"$f":"IFERROR(IF(AND(D57<>\"\",E57<>\"\"),SUM(D57*E57),\"\"),\"\")","v":""}]
[null,"1.8.3.","All new boiler plant, equipment, pipework services, associated H&V control panel, controls and electrical services.",1,null,""]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.9.","Drawings and Manuals"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D63<>\"\",D64<>\"\",D65<>\"\",D66<>\"\"),SUM(D63:D66),\"\"),\"\")","v":4},{"$f":"IFERROR(IF(OR(E63<>\"\",E64<>\"\",E65<>\"\",E66<>\"\"),SUM(E63:E66),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F63<>\"\",F64<>\"\",F65<>\"\",F66<>\"\"),SUM(F63:F66),\"\"),\"\")","v":""}]
[null,"1.9.1.","Fully co-ordinated detailed working and associated BWIC drawings.",1,null,{"$f":"IFERROR(IF(AND(D63<>\"\",E63<>\"\"),SUM(D63*E63),\"\"),\"\")","v":""}]
[null,"1.9.2.","‘As Installed’ drawings and details.",1,null,{"$f":"IFERROR(IF(AND(D64<>\"\",E64<>\"\"),SUM(D64*E64),\"\"),\"\")","v":""}]
[null,"1.9.3.","All Operating and Maintenance Manuals.",1,null,""]
[null,"1.9.4.","Handover procedures and practical demonstration to CBC staff and Client representatives.",1,null,""]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"1.10.","PC and Provisional Sums"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D71<>\"\"),SUM(D71),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(OR(E71<>\"\"),SUM(E71),\"\"),\"\")","v":5000},{"$f":"IFERROR(IF(OR(F71<>\"\"),SUM(F71:F71),\"\"),\"\")","v":5000}]
[null,"1.10.1.","PC and Provisional Sums",1,5000,{"$f":"IFERROR(IF(AND(D71<>\"\",E71<>\"\"),SUM(D71*E71),\"\"),\"\")","v":5000}]

{"sheet":"Mech","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,1,17,4],[1,0,1,5],[11,1,11,2],[7,1,7,2]]}
["Previous Page",null,"Contents",null,"Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Grosvenor House Boiler Replacement"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",(SoWR!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Analysis of Tender: Mechanical"]
["Pricing Schedule"]
[]
[null,"Schedule of Day Work Rates\n(Normal Working Hours)",null,"Hours Per Week","Cost Per Hour","Sub-Total"]
[null,{"$f":"IFERROR(IF(C9<>\"\",SUBTOTAL(103,$C$9:$C9),\"\"),\"\")","v":1},"Operative",null,null,{"$f":"IFERROR(IF(AND(D9<>\"\",E9<>\"\"),SUM(D9*E9),\"\"),\"\")","v":""}]
[null,"Sub-Total for information only",null,{"$f":"IFERROR(IF(OR(D9<>\"\"),SUM(D9:D9),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E9<>\"\"),SUM(E9:E9),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F9<>\"\"),SUM(F9:F9),\"\"),\"\")","v":""}]
[]
[null,"Schedule of Day Work Rates\n(% Addition)",null,"Value Excl. Mechanical","Percentage Addition","Cost of % Addition"]
[null,{"$f":"IFERROR(IF(C13<>\"\",SUBTOTAL(103,$C$13:$C13),\"\"),\"\")","v":1},"Labour",{"$f":"IFERROR(IF(OR(Summary!D10<>\"\",Summary!D12<>\"\",Summary!D13<>\"\"),SUM(Summary!D10,Summary!D12,Summary!D13),\"\"),\"\")","v":5000},null,{"$f":"IFERROR(IF(AND(D13<>\"\",E13<>\"\"),SUM(SUM(D13/E13)),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C14<>\"\",SUBTOTAL(103,$C$13:$C14),\"\"),\"\")","v":2},"Material",{"$f":"IFERROR(IF(OR(Summary!D10<>\"\",Summary!D12<>\"\",Summary!D13<>\"\"),SUM(Summary!D10,Summary!D12,Summary!D13),\"\"),\"\")","v":5000},null,{"$f":"IFERROR(IF(AND(D14<>\"\",E14<>\"\"),SUM(SUM(D14/E14)),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C15<>\"\",SUBTOTAL(103,$C$13:$C15),\"\"),\"\")","v":3},"Plant",{"$f":"IFERROR(IF(OR(Summary!D10<>\"\",Summary!D12<>\"\",Summary!D13<>\"\"),SUM(Summary!D10,Summary!D12,Summary!D13),\"\"),\"\")","v":5000},null,""]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D13<>\"\",D14<>\"\",D15<>\"\"),SUM(D13),\"\"),\"\")","v":5000},{"$f":"IFERROR(IF(OR(E13<>\"\",E14<>\"\",E15<>\"\"),SUM(E13:E15),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F13<>\"\",F14<>\"\",F15<>\"\"),SUM(F13:F15),\"\"),\"\")","v":""}]
[]
[null,"Schedule of Day Work Rates",null,null,null,"Total"]
[null,"Page Total of Mechanical carried to Summary",null,null,null,{"$f":"IFERROR(IF(OR(F16<>\"\"),SUM(F16),\"\"),\"\")","v":""}]

{"sheet":"OoH","index":4,"n_rows":172,"n_cols":6,"rows_kept":172,"cut":false,"hidden":false,"merged":[[7,1,7,2],[60,1,60,2],[115,1,115,2],[170,1,170,2],[1,0,1,5]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Grosvenor House Boiler Replacement"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(SoWR!$C$4<>\"\",(SoWR!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Schedule of Out-of-Hours Rates"]
["Pricing Schedule"]
[]
[null,"Out-of-Hours\n(Monday to Friday, 17:00 - 08:59)",null,"Time Required","Cost Per Hour","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D10<>\"\",D11<>\"\",D12<>\"\",D13<>\"\",D14<>\"\",D15<>\"\",D16<>\"\",D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\",D21<>\"\",D22<>\"\",D23<>\"\",D24<>\"\",D25<>\"\",D26<>\"\",D27<>\"\",D28<>\"\",D29<>\"\",D30<>\"\",D31<>\"\",D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\",D38<>\"\",D39<>\"\",D40<>\"\",D41<>\"\",D42<>\"\",D43<>\"\",D44<>\"\",D45<>\"\",D46<>\"\",D47<>\"\",D48<>\"\",D49<>\"\",D50<>\"\",D51<>\"\",D52<>\"\",D53<>\"\",D54<>\"\",D55<>\"\",D56<>\"\",D57<>\"\",D58<>\"\",D59<>\"\",#REF!<>\"\"),SUM(D10:D59),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E10<>\"\",E11<>\"\",E12<>\"\",E13<>\"\",E14<>\"\",E15<>\"\",E16<>\"\",E17<>\"\",E18<>\"\",E19<>\"\",E20<>\"\",E21<>\"\",E22<>\"\",E23<>\"\",E24<>\"\",E25<>\"\",E26<>\"\",E27<>\"\",E28<>\"\",E29<>\"\",E30<>\"\",E31<>\"\",E32<>\"\",E33<>\"\",E34<>\"\",E35<>\"\",E36<>\"\",E37<>\"\",E38<>\"\",E39<>\"\",E40<>\"\",E41<>\"\",E42<>\"\",E43<>\"\",E44<>\"\",E45<>\"\",E46<>\"\",E47<>\"\",E48<>\"\",E49<>\"\",E50<>\"\",E51<>\"\",E52<>\"\",E53<>\"\",E54<>\"\",E55<>\"\",E56<>\"\",E57<>\"\",E58<>\"\",E59<>\"\",#REF!<>\"\"),SUM(E10:E59),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F10<>\"\",F11<>\"\",F12<>\"\",F13<>\"\",F14<>\"\",F15<>\"\",F16<>\"\",F17<>\"\",F18<>\"\",F19<>\"\",F20<>\"\",F21<>\"\",F22<>\"\",F23<>\"\",F24<>\"\",F25<>\"\",F26<>\"\",F27<>\"\",F28<>\"\",F29<>\"\",F30<>\"\",F31<>\"\",F32<>\"\",F33<>\"\",F34<>\"\",F35<>\"\",F36<>\"\",F37<>\"\",F38<>\"\",F39<>\"\",F40<>\"\",F41<>\"\",F42<>\"\",F43<>\"\",F44<>\"\",F45<>\"\",F46<>\"\",F47<>\"\",F48<>\"\",F49<>\"\",F50<>\"\",F51<>\"\",F52<>\"\",F53<>\"\",F54<>\"\",F55<>\"\",F56<>\"\",F57<>\"\",F58<>\"\",F59<>\"\"),SUM(F10:F59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C10<>\"\",SUBTOTAL(103,$C$10:C10),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D10<>\"\",E10<>\"\"),SUM(D10*E10),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C11<>\"\",SUBTOTAL(103,$C$10:C11),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D11<>\"\",E11<>\"\"),SUM(D11*E11),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C12<>\"\",SUBTOTAL(103,$C$10:C12),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C13<>\"\",SUBTOTAL(103,$C$10:C13),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C14<>\"\",SUBTOTAL(103,$C$10:C14),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C15<>\"\",SUBTOTAL(103,$C$10:C15),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C16<>\"\",SUBTOTAL(103,$C$10:C16),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C17<>\"\",SUBTOTAL(103,$C$10:C17),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C18<>\"\",SUBTOTAL(103,$C$10:C18),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C19<>\"\",SUBTOTAL(103,$C$10:C19),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C20<>\"\",SUBTOTAL(103,$C$10:C20),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C21<>\"\",SUBTOTAL(103,$C$10:C21),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C22<>\"\",SUBTOTAL(103,$C$10:C22),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C23<>\"\",SUBTOTAL(103,$C$10:C23),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C24<>\"\",SUBTOTAL(103,$C$10:C24),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$10:C25),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C26<>\"\",SUBTOTAL(103,$C$10:C26),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C27<>\"\",SUBTOTAL(103,$C$10:C27),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C28<>\"\",SUBTOTAL(103,$C$10:C28),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$10:C29),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C30<>\"\",SUBTOTAL(103,$C$10:C30),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C31<>\"\",SUBTOTAL(103,$C$10:C31),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C32<>\"\",SUBTOTAL(103,$C$10:C32),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C33<>\"\",SUBTOTAL(103,$C$10:C33),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C34<>\"\",SUBTOTAL(103,$C$10:C34),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C35<>\"\",SUBTOTAL(103,$C$10:C35),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C36<>\"\",SUBTOTAL(103,$C$10:C36),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C37<>\"\",SUBTOTAL(103,$C$10:C37),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C38<>\"\",SUBTOTAL(103,$C$10:C38),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C39<>\"\",SUBTOTAL(103,$C$10:C39),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C40<>\"\",SUBTOTAL(103,$C$10:C40),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C41<>\"\",SUBTOTAL(103,$C$10:C41),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C42<>\"\",SUBTOTAL(103,$C$10:C42),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C43<>\"\",SUBTOTAL(103,$C$10:C43),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C44<>\"\",SUBTOTAL(103,$C$10:C44),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C45<>\"\",SUBTOTAL(103,$C$10:C45),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C46<>\"\",SUBTOTAL(103,$C$10:C46),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C47<>\"\",SUBTOTAL(103,$C$10:C47),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C48<>\"\",SUBTOTAL(103,$C$10:C48),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$C$10:C49),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C50<>\"\",SUBTOTAL(103,$C$10:C50),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C51<>\"\",SUBTOTAL(103,$C$10:C51),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C52<>\"\",SUBTOTAL(103,$C$10:C52),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C53<>\"\",SUBTOTAL(103,$C$10:C53),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C54<>\"\",SUBTOTAL(103,$C$10:C54),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C55<>\"\",SUBTOTAL(103,$C$10:C55),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$C$10:C56),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C57<>\"\",SUBTOTAL(103,$C$10:C57),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C58<>\"\",SUBTOTAL(103,$C$10:C58),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C59<>\"\",SUBTOTAL(103,$C$10:C59),\"\"),\"\")","v":""},null,null,null,""]
[]
[null,"Out-of-Hours\n(Weekend)",null,"Time Required","Cost Per Hour","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D63<>\"\",D64<>\"\",D65<>\"\",D66<>\"\",D67<>\"\",D68<>\"\",D69<>\"\",D70<>\"\",D71<>\"\",D72<>\"\",D73<>\"\",D74<>\"\",D75<>\"\",D76<>\"\",D77<>\"\",D78<>\"\",D79<>\"\",D80<>\"\",D81<>\"\",D82<>\"\",D83<>\"\",D84<>\"\",D85<>\"\",D86<>\"\",D87<>\"\",D88<>\"\",D89<>\"\",D90<>\"\",D91<>\"\",D92<>\"\",D93<>\"\",D94<>\"\",D95<>\"\",D96<>\"\",D97<>\"\",D98<>\"\",D99<>\"\",D100<>\"\",D101<>\"\",D102<>\"\",D103<>\"\",D104<>\"\",D105<>\"\",D106<>\"\",D107<>\"\",D108<>\"\",D109<>\"\",D110<>\"\",D111<>\"\",D112<>\"\",D113<>\"\"),SUM(D63:D113),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E63<>\"\",E64<>\"\",E65<>\"\",E66<>\"\",E67<>\"\",E68<>\"\",E69<>\"\",E70<>\"\",E71<>\"\",E72<>\"\",E73<>\"\",E74<>\"\",E75<>\"\",E76<>\"\",E77<>\"\",E78<>\"\",E79<>\"\",E80<>\"\",E81<>\"\",E82<>\"\",E83<>\"\",E84<>\"\",E85<>\"\",E86<>\"\",E87<>\"\",E88<>\"\",E89<>\"\",E90<>\"\",E91<>\"\",E92<>\"\",E93<>\"\",E94<>\"\",E95<>\"\",E96<>\"\",E97<>\"\",E98<>\"\",E99<>\"\",E100<>\"\",E101<>\"\",E102<>\"\",E103<>\"\",E104<>\"\",E105<>\"\",E106<>\"\",E107<>\"\",E108<>\"\",E109<>\"\",E110<>\"\",E111<>\"\",E112<>\"\",E113<>\"\"),SUM(E63:E113),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F63<>\"\",F64<>\"\",F65<>\"\",F66<>\"\",F67<>\"\",F68<>\"\",F69<>\"\",F70<>\"\",F71<>\"\",F72<>\"\",F73<>\"\",F74<>\"\",F75<>\"\",F76<>\"\",F77<>\"\",F78<>\"\",F79<>\"\",F80<>\"\",F81<>\"\",F82<>\"\",F83<>\"\",F84<>\"\",F85<>\"\",F86<>\"\",F87<>\"\",F88<>\"\",F89<>\"\",F90<>\"\",F91<>\"\",F92<>\"\",F93<>\"\",F94<>\"\",F95<>\"\",F96<>\"\",F97<>\"\",F98<>\"\",F99<>\"\",F100<>\"\",F101<>\"\",F102<>\"\",F103<>\"\",F104<>\"\",F105<>\"\",F106<>\"\",F107<>\"\",F108<>\"\",F109<>\"\",F110<>\"\",F111<>\"\",F112<>\"\",F113<>\"\",F114<>\"\"),SUM(F63:F114),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C63<>\"\",SUBTOTAL(103,$C$63:C63),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D63<>\"\",E63<>\"\"),SUM(D63*E63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$C$63:C64),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D64<>\"\",E64<>\"\"),SUM(D64*E64),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$C$63:C65),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$C$63:C66),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$C$63:C67),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C68<>\"\",SUBTOTAL(103,$C$63:C68),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C69<>\"\",SUBTOTAL(103,$C$63:C69),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C70<>\"\",SUBTOTAL(103,$C$63:C70),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C71<>\"\",SUBTOTAL(103,$C$63:C71),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C72<>\"\",SUBTOTAL(103,$C$63:C72),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C73<>\"\",SUBTOTAL(103,$C$63:C73),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C74<>\"\",SUBTOTAL(103,$C$63:C74),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C75<>\"\",SUBTOTAL(103,$C$63:C75),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$C$63:C76),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C77<>\"\",SUBTOTAL(103,$C$63:C77),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C78<>\"\",SUBTOTAL(103,$C$63:C78),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C79<>\"\",SUBTOTAL(103,$C$63:C79),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C80<>\"\",SUBTOTAL(103,$C$63:C80),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C81<>\"\",SUBTOTAL(103,$C$63:C81),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C82<>\"\",SUBTOTAL(103,$C$63:C82),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C83<>\"\",SUBTOTAL(103,$C$63:C83),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C84<>\"\",SUBTOTAL(103,$C$63:C84),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C85<>\"\",SUBTOTAL(103,$C$63:C85),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C86<>\"\",SUBTOTAL(103,$C$63:C86),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C87<>\"\",SUBTOTAL(103,$C$63:C87),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C88<>\"\",SUBTOTAL(103,$C$63:C88),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C89<>\"\",SUBTOTAL(103,$C$63:C89),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C90<>\"\",SUBTOTAL(103,$C$63:C90),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C91<>\"\",SUBTOTAL(103,$C$63:C91),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C92<>\"\",SUBTOTAL(103,$C$63:C92),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C93<>\"\",SUBTOTAL(103,$C$63:C93),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C94<>\"\",SUBTOTAL(103,$C$63:C94),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C95<>\"\",SUBTOTAL(103,$C$63:C95),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C96<>\"\",SUBTOTAL(103,$C$63:C96),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C97<>\"\",SUBTOTAL(103,$C$63:C97),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C98<>\"\",SUBTOTAL(103,$C$63:C98),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C99<>\"\",SUBTOTAL(103,$C$63:C99),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C100<>\"\",SUBTOTAL(103,$C$63:C100),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C101<>\"\",SUBTOTAL(103,$C$63:C101),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C102<>\"\",SUBTOTAL(103,$C$63:C102),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C103<>\"\",SUBTOTAL(103,$C$63:C103),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C104<>\"\",SUBTOTAL(103,$C$63:C104),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C105<>\"\",SUBTOTAL(103,$C$63:C105),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C106<>\"\",SUBTOTAL(103,$C$63:C106),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C107<>\"\",SUBTOTAL(103,$C$63:C107),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C108<>\"\",SUBTOTAL(103,$C$63:C108),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C109<>\"\",SUBTOTAL(103,$C$63:C109),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C110<>\"\",SUBTOTAL(103,$C$63:C110),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C111<>\"\",SUBTOTAL(103,$C$63:C111),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C112<>\"\",SUBTOTAL(103,$C$63:C112),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C113<>\"\",SUBTOTAL(103,$C$63:C113),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C114<>\"\",SUBTOTAL(103,$C$63:C114),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D114<>\"\",E114<>\"\"),SUM(D114*E114),\"\"),\"\")","v":""}]
[]
[null,"Out-of-Hours\n(Bank Holiday)",null,"Time Required","Cost Per Hour","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D118<>\"\",D119<>\"\",D120<>\"\",D121<>\"\",D122<>\"\",D123<>\"\",D124<>\"\",D125<>\"\",D126<>\"\",D127<>\"\",D128<>\"\",D129<>\"\",D130<>\"\",D131<>\"\",D132<>\"\",D133<>\"\",D134<>\"\",D135<>\"\",D136<>\"\",D137<>\"\",D138<>\"\",D139<>\"\",D140<>\"\",D141<>\"\",D142<>\"\",D143<>\"\",D144<>\"\",D145<>\"\",D146<>\"\",D147<>\"\",D148<>\"\",D149<>\"\",D150<>\"\",D151<>\"\",D152<>\"\",D153<>\"\",D154<>\"\",D155<>\"\",D156<>\"\",D157<>\"\",D158<>\"\",D159<>\"\",D160<>\"\",D161<>\"\",D162<>\"\",D163<>\"\",D164<>\"\",D165<>\"\",D166<>\"\",D167<>\"\",D168<>\"\"),SUM(D118:D168),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E118<>\"\",E119<>\"\",E120<>\"\",E121<>\"\",E122<>\"\",E123<>\"\",E124<>\"\",E125<>\"\",E126<>\"\",E127<>\"\",E128<>\"\",E129<>\"\",E130<>\"\",E131<>\"\",E132<>\"\",E133<>\"\",E134<>\"\",E135<>\"\",E136<>\"\",E137<>\"\",E138<>\"\",E139<>\"\",E140<>\"\",E141<>\"\",E142<>\"\",E143<>\"\",E144<>\"\",E145<>\"\",E146<>\"\",E147<>\"\",E148<>\"\",E149<>\"\",E150<>\"\",E151<>\"\",E152<>\"\",E153<>\"\",E154<>\"\",E155<>\"\",E156<>\"\",E157<>\"\",E158<>\"\",E159<>\"\",E160<>\"\",E161<>\"\",E162<>\"\",E163<>\"\",E164<>\"\",E165<>\"\",E166<>\"\",E167<>\"\",E168<>\"\"),SUM(E118:E168),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F118<>\"\",F119<>\"\",F120<>\"\",F121<>\"\",F122<>\"\",F123<>\"\",F124<>\"\",F125<>\"\",F126<>\"\",F127<>\"\",F128<>\"\",F129<>\"\",F130<>\"\",F131<>\"\",F132<>\"\",F133<>\"\",F134<>\"\",F135<>\"\",F136<>\"\",F137<>\"\",F138<>\"\",F139<>\"\",F140<>\"\",F141<>\"\",F142<>\"\",F143<>\"\",F144<>\"\",F145<>\"\",F146<>\"\",F147<>\"\",F148<>\"\",F149<>\"\",F150<>\"\",F151<>\"\",F152<>\"\",F153<>\"\",F154<>\"\",F155<>\"\",F156<>\"\",F157<>\"\",F158<>\"\",F159<>\"\",F160<>\"\",F161<>\"\",F162<>\"\",F163<>\"\",F164<>\"\",F165<>\"\",F166<>\"\",F167<>\"\",F168<>\"\",F169<>\"\"),SUM(F118:F169),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C118<>\"\",SUBTOTAL(103,$C$118:C118),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D118<>\"\",E118<>\"\"),SUM(D118*E118),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C119<>\"\",SUBTOTAL(103,$C$118:C119),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D119<>\"\",E119<>\"\"),SUM(D119*E119),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C120<>\"\",SUBTOTAL(103,$C$118:C120),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C121<>\"\",SUBTOTAL(103,$C$118:C121),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C122<>\"\",SUBTOTAL(103,$C$118:C122),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C123<>\"\",SUBTOTAL(103,$C$118:C123),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C124<>\"\",SUBTOTAL(103,$C$118:C124),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C125<>\"\",SUBTOTAL(103,$C$118:C125),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C126<>\"\",SUBTOTAL(103,$C$118:C126),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C127<>\"\",SUBTOTAL(103,$C$118:C127),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C128<>\"\",SUBTOTAL(103,$C$118:C128),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C129<>\"\",SUBTOTAL(103,$C$118:C129),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C130<>\"\",SUBTOTAL(103,$C$118:C130),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C131<>\"\",SUBTOTAL(103,$C$118:C131),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C132<>\"\",SUBTOTAL(103,$C$118:C132),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C133<>\"\",SUBTOTAL(103,$C$118:C133),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C134<>\"\",SUBTOTAL(103,$C$118:C134),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C135<>\"\",SUBTOTAL(103,$C$118:C135),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C136<>\"\",SUBTOTAL(103,$C$118:C136),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C137<>\"\",SUBTOTAL(103,$C$118:C137),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C138<>\"\",SUBTOTAL(103,$C$118:C138),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C139<>\"\",SUBTOTAL(103,$C$118:C139),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C140<>\"\",SUBTOTAL(103,$C$118:C140),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C141<>\"\",SUBTOTAL(103,$C$118:C141),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C142<>\"\",SUBTOTAL(103,$C$118:C142),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C143<>\"\",SUBTOTAL(103,$C$118:C143),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C144<>\"\",SUBTOTAL(103,$C$118:C144),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C145<>\"\",SUBTOTAL(103,$C$118:C145),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C146<>\"\",SUBTOTAL(103,$C$118:C146),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C147<>\"\",SUBTOTAL(103,$C$118:C147),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C148<>\"\",SUBTOTAL(103,$C$118:C148),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C149<>\"\",SUBTOTAL(103,$C$118:C149),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C150<>\"\",SUBTOTAL(103,$C$118:C150),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C151<>\"\",SUBTOTAL(103,$C$118:C151),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C152<>\"\",SUBTOTAL(103,$C$118:C152),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C153<>\"\",SUBTOTAL(103,$C$118:C153),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C154<>\"\",SUBTOTAL(103,$C$118:C154),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C155<>\"\",SUBTOTAL(103,$C$118:C155),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C156<>\"\",SUBTOTAL(103,$C$118:C156),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C157<>\"\",SUBTOTAL(103,$C$118:C157),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C158<>\"\",SUBTOTAL(103,$C$118:C158),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C159<>\"\",SUBTOTAL(103,$C$118:C159),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C160<>\"\",SUBTOTAL(103,$C$118:C160),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C161<>\"\",SUBTOTAL(103,$C$118:C161),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C162<>\"\",SUBTOTAL(103,$C$118:C162),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C163<>\"\",SUBTOTAL(103,$C$118:C163),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C164<>\"\",SUBTOTAL(103,$C$118:C164),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C165<>\"\",SUBTOTAL(103,$C$118:C165),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C166<>\"\",SUBTOTAL(103,$C$118:C166),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C167<>\"\",SUBTOTAL(103,$C$118:C167),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C168<>\"\",SUBTOTAL(103,$C$118:C168),\"\"),\"\")","v":""},null,null,null,""]
[null,{"$f":"IFERROR(IF(C169<>\"\",SUBTOTAL(103,$C$118:C169),\"\"),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AND(D169<>\"\",E169<>\"\"),SUM(D169*E169),\"\"),\"\")","v":""}]
[]
[null,"Out-of-Hours",null,"Time Required","Cost Per Hour","Total Cost"]
[null,"Page Total of Out-of-Hours Rates carried to Summary",null,{"$f":"IFERROR(IF(OR(D9<>\"\",D62<>\"\",D117<>\"\"),SUM(D9,D62,D117),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E9<>\"\",E62<>\"\",E117<>\"\"),SUM(E9,E62,E117),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F9<>\"\",F62<>\"\",F117<>\"\"),SUM(F9,F62,F117),\"\"),\"\")","v":""}]

{"sheet":"Add","index":5,"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":"Grosvenor House Boiler Replacement"}]
[]
["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":""}]