{"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"]
["Improvement Works to Shopping Parades across Corby"]
[]
["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 Improvement Works to Shopping Parades across Corby 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"]
["Additional Costs"]

{"sheet":"Summary","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"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":"Improvement Works to Shopping Parades across Corby"}]
[]
["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<>\"\"),SUM(D10:D11),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C10<>\"\",SUBTOTAL(103,$C$10:$C10),\"\"),\"\")","v":1},"Schedule of Works/Rates",{"$f":"IFERROR(IF(SoWR!F11<>\"\",SUM(SoWR!F11),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C11<>\"\",SUBTOTAL(103,$C$10:$C11),\"\"),\"\")","v":2},"Additional Costs not otherwise specified",{"$f":"IFERROR(IF(Add!I13<>\"\",SUM(Add!I13),\"\"),\"\")","v":""}]

{"sheet":"SoWR","index":2,"n_rows":129,"n_cols":6,"rows_kept":129,"cut":false,"hidden":false,"merged":[[105,1,105,2],[112,1,112,2],[121,1,121,2],[33,1,33,2],[45,1,45,2],[59,1,59,2],[71,1,71,2],[93,1,93,2],[7,0,7,5],[12,1,12,2],[21,1,21,2],[9,1,9,4],[1,0,1,5],[5,0,5,5],[4,2,4,5],[3,2,3,5]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Improvement Works to Shopping Parades across Corby"}]
[]
["Supplier:"]
["Sub-Heading:",null,"Schedule of Works/Rates"]
["Pricing Schedule"]
[]
["The rate is to include for all labour and materials necessary for carrying out the installation described, during normal working hours. Preliminary costs should be included in the cells identified for each Parade.\n\nEach item is to be priced and the spreadsheet will extend the rate out for the quantities required."]
[]
[null,"Schedule Costs",null,null,null,"Total"]
[null,"Sub-Total of Schedule Costs carried to Summary",null,null,null,{"$f":"IFERROR(IF(OR(F14<>\"\",F23<>\"\",F35<>\"\",F47<>\"\",F61<>\"\",F73<>\"\",F95<>\"\",F107<>\"\",F114<>\"\",F123<>\"\"),SUM(F14,F23,F35,F47,F61,F73,F95,F107,F114,F123),\"\"),\"\")","v":""}]
[]
[null,"Boden Close",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D15<>\"\",D16<>\"\",D17<>\"\",D18<>\"\",D19<>\"\",D20<>\"\"),SUM(D15:D20),\"\"),\"\")","v":6},{"$f":"IFERROR(IF(OR(E15<>\"\",E16<>\"\",E17<>\"\",E18<>\"\",E19<>\"\",E20<>\"\"),SUM(E15:E20),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F15<>\"\",F16<>\"\",F17<>\"\",F18<>\"\",F19<>\"\",F20<>\"\"),SUM(F15:F20),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C15<>\"\",SUBTOTAL(103,$C$15:$C15),\"\"),\"\")","v":1},"Tarmac works",1,null,{"$f":"IFERROR(IF(AND(D15<>\"\",E15<>\"\"),SUM(D15*E15),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C16<>\"\",SUBTOTAL(103,$C$15:$C16),\"\"),\"\")","v":2},"New drop kerbs",1,null,{"$f":"IFERROR(IF(AND(D16<>\"\",E16<>\"\"),SUM(D16*E16),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C17<>\"\",SUBTOTAL(103,$C$15:$C17),\"\"),\"\")","v":3},"Work to railings",1,null,""]
[null,{"$f":"IFERROR(IF(C18<>\"\",SUBTOTAL(103,$C$15:$C18),\"\"),\"\")","v":4},"Painting and decorating works",1,null,""]
[null,{"$f":"IFERROR(IF(C19<>\"\",SUBTOTAL(103,$C$15:$C19),\"\"),\"\")","v":5},"Provision of new signage and installation",1,null,""]
[null,{"$f":"IFERROR(IF(C20<>\"\",SUBTOTAL(103,$C$15:$C20),\"\"),\"\")","v":6},"Preliminaries",1,null,""]
[]
[null,"Burghley Drive",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D24<>\"\",D25<>\"\",D26<>\"\",D27<>\"\",D28<>\"\",D29<>\"\",D30<>\"\",D31<>\"\",D32<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),SUM(D24:D32),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(E24<>\"\",E25<>\"\",E26<>\"\",E27<>\"\",E28<>\"\",E29<>\"\",E30<>\"\",E31<>\"\",E32<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),SUM(E24:E32),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F24<>\"\",F25<>\"\",F26<>\"\",F27<>\"\",F28<>\"\",F29<>\"\",F30<>\"\",F31<>\"\",F32<>\"\",#REF!<>\"\",#REF!<>\"\",#REF!<>\"\"),SUM(F24:F32),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C24<>\"\",SUBTOTAL(103,$C$24:$C24),\"\"),\"\")","v":1},"Block paving raising works",1,null,{"$f":"IFERROR(IF(AND(D24<>\"\",E24<>\"\"),SUM(D24*E24),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C25<>\"\",SUBTOTAL(103,$C$24:$C25),\"\"),\"\")","v":2},"Tarmac works",1,null,{"$f":"IFERROR(IF(AND(D25<>\"\",E25<>\"\"),SUM(D25*E25),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C26<>\"\",SUBTOTAL(103,$C$24:$C26),\"\"),\"\")","v":3},"Additional section of tarmac works shown green",1,null,""]
[null,{"$f":"IFERROR(IF(C27<>\"\",SUBTOTAL(103,$C$24:$C27),\"\"),\"\")","v":4},"UPVC repairing works",1,null,""]
[null,{"$f":"IFERROR(IF(C28<>\"\",SUBTOTAL(103,$C$24:$C28),\"\"),\"\")","v":5},"Pebble dash repairs",1,null,""]
[null,{"$f":"IFERROR(IF(C29<>\"\",SUBTOTAL(103,$C$24:$C29),\"\"),\"\")","v":6},"Redecoration",1,null,""]
[null,{"$f":"IFERROR(IF(C30<>\"\",SUBTOTAL(103,$C$24:$C30),\"\"),\"\")","v":7},"Jet washing",1,null,""]
[null,{"$f":"IFERROR(IF(C31<>\"\",SUBTOTAL(103,$C$24:$C31),\"\"),\"\")","v":8},"White lining",1,null,""]
[null,{"$f":"IFERROR(IF(C32<>\"\",SUBTOTAL(103,$C$24:$C32),\"\"),\"\")","v":9},"Preliminaries",1,null,""]
[null,null,null,null,null,""]
[null,"Danesholme",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D36<>\"\",D37<>\"\",D38<>\"\",D39<>\"\",D40<>\"\",D41<>\"\",D42<>\"\",D43<>\"\",D44<>\"\"),SUM(D36:D44),\"\"),\"\")","v":9},{"$f":"IFERROR(IF(OR(E36<>\"\",E37<>\"\",E38<>\"\",E39<>\"\",E40<>\"\",E41<>\"\",E42<>\"\",E43<>\"\",E44<>\"\"),SUM(E36:E44),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F36<>\"\",F37<>\"\",F38<>\"\",F39<>\"\",F40<>\"\",F41<>\"\",F42<>\"\",F43<>\"\",F44<>\"\"),SUM(F36:F44),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C36<>\"\",SUBTOTAL(103,$C$36:$C36),\"\"),\"\")","v":1},"Works to planter",1,null,{"$f":"IFERROR(IF(AND(D36<>\"\",E36<>\"\"),SUM(D36*E36),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C37<>\"\",SUBTOTAL(103,$C$36:$C37),\"\"),\"\")","v":2},"Jet washing",1,null,{"$f":"IFERROR(IF(AND(D37<>\"\",E37<>\"\"),SUM(D37*E37),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C38<>\"\",SUBTOTAL(103,$C$36:$C38),\"\"),\"\")","v":3},"Works to hooped rails",1,null,""]
[null,{"$f":"IFERROR(IF(C39<>\"\",SUBTOTAL(103,$C$36:$C39),\"\"),\"\")","v":4},"New lighting and installation",1,null,""]
[null,{"$f":"IFERROR(IF(C40<>\"\",SUBTOTAL(103,$C$36:$C40),\"\"),\"\")","v":5},"Works to laminated beams",1,null,""]
[null,{"$f":"IFERROR(IF(C41<>\"\",SUBTOTAL(103,$C$36:$C41),\"\"),\"\")","v":6},"Works to fascia",1,null,""]
[null,{"$f":"IFERROR(IF(C42<>\"\",SUBTOTAL(103,$C$36:$C42),\"\"),\"\")","v":7},"New pier and foundation",1,null,""]
[null,{"$f":"IFERROR(IF(C43<>\"\",SUBTOTAL(103,$C$36:$C43),\"\"),\"\")","v":8},"Scaffolding and licenses",1,null,""]
[null,{"$f":"IFERROR(IF(C44<>\"\",SUBTOTAL(103,$C$36:$C44),\"\"),\"\")","v":9},"Preliminaries",1,null,""]
[]
[null,"Farmstead Road",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D48<>\"\",D49<>\"\",D50<>\"\",D51<>\"\",D52<>\"\",D53<>\"\",D54<>\"\",D55<>\"\",D56<>\"\",D57<>\"\",D58<>\"\"),SUM(D48:D58),\"\"),\"\")","v":11},{"$f":"IFERROR(IF(OR(E48<>\"\",E49<>\"\",E50<>\"\",E51<>\"\",E52<>\"\",E53<>\"\",E54<>\"\",E55<>\"\",E56<>\"\",E57<>\"\",E58<>\"\"),SUM(E48:E58),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F48<>\"\",F49<>\"\",F50<>\"\",F51<>\"\",F52<>\"\",F53<>\"\",F54<>\"\",F55<>\"\",F56<>\"\",F57<>\"\",F58<>\"\"),SUM(F48:F58),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C48<>\"\",SUBTOTAL(103,$C$48:$C48),\"\"),\"\")","v":1},"Block paving raising works",1,null,{"$f":"IFERROR(IF(AND(D48<>\"\",E48<>\"\"),SUM(D48*E48),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$C$48:$C49),\"\"),\"\")","v":2},"Concrete repairs to canopy",1,null,{"$f":"IFERROR(IF(AND(D49<>\"\",E49<>\"\"),SUM(D49*E49),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C50<>\"\",SUBTOTAL(103,$C$48:$C50),\"\"),\"\")","v":3},"Staircase modifications",1,null,""]
[null,{"$f":"IFERROR(IF(C51<>\"\",SUBTOTAL(103,$C$48:$C51),\"\"),\"\")","v":4},"Tarmac works",1,null,""]
[null,{"$f":"IFERROR(IF(C52<>\"\",SUBTOTAL(103,$C$48:$C52),\"\"),\"\")","v":5},"Gully clearing works",1,null,""]
[null,{"$f":"IFERROR(IF(C53<>\"\",SUBTOTAL(103,$C$48:$C53),\"\"),\"\")","v":6},"Relocation of lighting column",1,null,""]
[null,{"$f":"IFERROR(IF(C54<>\"\",SUBTOTAL(103,$C$48:$C54),\"\"),\"\")","v":7},"Removal of grassed area and walling",1,null,""]
[null,{"$f":"IFERROR(IF(C55<>\"\",SUBTOTAL(103,$C$48:$C55),\"\"),\"\")","v":8},"Redecoration",1,null,""]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$C$48:$C56),\"\"),\"\")","v":9},"Electrical works",1,null,""]
[null,{"$f":"IFERROR(IF(C57<>\"\",SUBTOTAL(103,$C$48:$C57),\"\"),\"\")","v":10},"White Lining",1,null,""]
[null,{"$f":"IFERROR(IF(C58<>\"\",SUBTOTAL(103,$C$48:$C58),\"\"),\"\")","v":11},"Preliminaries",1,null,""]
[]
[null,"Gainsborough Road",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D62<>\"\",D63<>\"\",D64<>\"\",D65<>\"\",D66<>\"\",D67<>\"\",D68<>\"\",D69<>\"\",D70<>\"\"),SUM(D62:D70),\"\"),\"\")","v":9},{"$f":"IFERROR(IF(OR(E62<>\"\",E63<>\"\",E64<>\"\",E65<>\"\",E66<>\"\",E67<>\"\",E68<>\"\",E69<>\"\",E70<>\"\"),SUM(E62:E70),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F62<>\"\",F63<>\"\",F64<>\"\",F65<>\"\",F66<>\"\",F67<>\"\",F68<>\"\",F69<>\"\",F70<>\"\"),SUM(F62:F70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C62<>\"\",SUBTOTAL(103,$C$62:$C62),\"\"),\"\")","v":1},"Paving works",1,null,{"$f":"IFERROR(IF(AND(D62<>\"\",E62<>\"\"),SUM(D62*E62),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C63<>\"\",SUBTOTAL(103,$C$62:$C63),\"\"),\"\")","v":2},"Work to staircase",1,null,{"$f":"IFERROR(IF(AND(D63<>\"\",E63<>\"\"),SUM(D63*E63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$C$62:$C64),\"\"),\"\")","v":3},"New knee rail fencing",1,null,""]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$C$62:$C65),\"\"),\"\")","v":4},"Fencing works",1,null,""]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$C$62:$C66),\"\"),\"\")","v":5},"Wall repairs",1,null,""]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$C$62:$C67),\"\"),\"\")","v":6},"Drainage clearing",1,null,""]
[null,{"$f":"IFERROR(IF(C68<>\"\",SUBTOTAL(103,$C$62:$C68),\"\"),\"\")","v":7},"Electrical works",1,null,""]
[null,{"$f":"IFERROR(IF(C69<>\"\",SUBTOTAL(103,$C$62:$C69),\"\"),\"\")","v":8},"Jet washing",1,null,""]
[null,{"$f":"IFERROR(IF(C70<>\"\",SUBTOTAL(103,$C$62:$C70),\"\"),\"\")","v":9},"Preliminaries",1,null,""]
[]
[null,"Greenhill Rise",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D74<>\"\",D75<>\"\",D76<>\"\",D77<>\"\",D78<>\"\",D79<>\"\",D80<>\"\",D81<>\"\",D82<>\"\",D83<>\"\",D84<>\"\",D85<>\"\",D86<>\"\",D87<>\"\",D88<>\"\",D89<>\"\",D90<>\"\",D91<>\"\",D92<>\"\"),SUM(D74:D92),\"\"),\"\")","v":19},{"$f":"IFERROR(IF(OR(E74<>\"\",E75<>\"\",E76<>\"\",E77<>\"\",E78<>\"\",E79<>\"\",E80<>\"\",E81<>\"\",E82<>\"\",E83<>\"\",E84<>\"\",E85<>\"\",E86<>\"\",E87<>\"\",E88<>\"\",E89<>\"\",E90<>\"\",E91<>\"\",E92<>\"\"),SUM(E74:E92),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F74<>\"\",F75<>\"\",F76<>\"\",F77<>\"\",F78<>\"\",F79<>\"\",F80<>\"\",F81<>\"\",F82<>\"\",F83<>\"\",F84<>\"\",F85<>\"\",F86<>\"\",F87<>\"\",F88<>\"\",F89<>\"\",F90<>\"\",F91<>\"\",F92<>\"\"),SUM(F74:F92),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C74<>\"\",SUBTOTAL(103,$C$74:$C74),\"\"),\"\")","v":1},"Block paving raising works",1,null,{"$f":"IFERROR(IF(AND(D74<>\"\",E74<>\"\"),SUM(D74*E74),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C75<>\"\",SUBTOTAL(103,$C$74:$C75),\"\"),\"\")","v":2},"Tree removal and making good",1,null,{"$f":"IFERROR(IF(AND(D75<>\"\",E75<>\"\"),SUM(D75*E75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$C$74:$C76),\"\"),\"\")","v":3},"Wall repairs",1,null,""]
[null,{"$f":"IFERROR(IF(C77<>\"\",SUBTOTAL(103,$C$74:$C77),\"\"),\"\")","v":4},"New handrails",1,null,""]
[null,{"$f":"IFERROR(IF(C78<>\"\",SUBTOTAL(103,$C$74:$C78),\"\"),\"\")","v":5},"New tarmac to ramped section",1,null,""]
[null,{"$f":"IFERROR(IF(C79<>\"\",SUBTOTAL(103,$C$74:$C79),\"\"),\"\")","v":6},"Gully clearing works",1,null,""]
[null,{"$f":"IFERROR(IF(C80<>\"\",SUBTOTAL(103,$C$74:$C80),\"\"),\"\")","v":7},"Works to sloped paving section",1,null,""]
[null,{"$f":"IFERROR(IF(C81<>\"\",SUBTOTAL(103,$C$74:$C81),\"\"),\"\")","v":8},"Timber soffit repairs",1,null,""]
[null,{"$f":"IFERROR(IF(C82<>\"\",SUBTOTAL(103,$C$74:$C82),\"\"),\"\")","v":9},"Redecoration",1,null,""]
[null,{"$f":"IFERROR(IF(C83<>\"\",SUBTOTAL(103,$C$74:$C83),\"\"),\"\")","v":10},"Electrical works",1,null,""]
[null,{"$f":"IFERROR(IF(C84<>\"\",SUBTOTAL(103,$C$74:$C84),\"\"),\"\")","v":11},"Raising block paving",1,null,""]
[null,{"$f":"IFERROR(IF(C85<>\"\",SUBTOTAL(103,$C$74:$C85),\"\"),\"\")","v":12},"White-lining",1,null,""]
[null,{"$f":"IFERROR(IF(C86<>\"\",SUBTOTAL(103,$C$74:$C86),\"\"),\"\")","v":13},"New parking bay creation",1,null,""]
[null,{"$f":"IFERROR(IF(C87<>\"\",SUBTOTAL(103,$C$74:$C87),\"\"),\"\")","v":14},"New tarmacadam below canopy",1,null,""]
[null,{"$f":"IFERROR(IF(C88<>\"\",SUBTOTAL(103,$C$74:$C88),\"\"),\"\")","v":15},"New paving",1,null,""]
[null,{"$f":"IFERROR(IF(C89<>\"\",SUBTOTAL(103,$C$74:$C89),\"\"),\"\")","v":16},"New knee railing",1,null,""]
[null,{"$f":"IFERROR(IF(C90<>\"\",SUBTOTAL(103,$C$74:$C90),\"\"),\"\")","v":17},"Landscaping works",1,null,""]
[null,{"$f":"IFERROR(IF(C91<>\"\",SUBTOTAL(103,$C$74:$C91),\"\"),\"\")","v":18},"Removal of railings",1]
[null,{"$f":"IFERROR(IF(C92<>\"\",SUBTOTAL(103,$C$74:$C92),\"\"),\"\")","v":19},"Preliminaries",1,null,""]
[]
[null,"Pytchley Court",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D96<>\"\",D97<>\"\",D98<>\"\",D99<>\"\",D100<>\"\",D101<>\"\",D102<>\"\",D103<>\"\",D104<>\"\"),SUM(D96:D104),\"\"),\"\")","v":9},{"$f":"IFERROR(IF(OR(E96<>\"\",E97<>\"\",E98<>\"\",E99<>\"\",E100<>\"\",E101<>\"\",E102<>\"\",E103<>\"\",E104<>\"\"),SUM(E96:E104),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F96<>\"\",F97<>\"\",F98<>\"\",F99<>\"\",F100<>\"\",F101<>\"\",F102<>\"\",F103<>\"\",F104<>\"\"),SUM(F96:F104),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C96<>\"\",SUBTOTAL(103,$C$96:$C96),\"\"),\"\")","v":1},"Block paving raising works",1,null,{"$f":"IFERROR(IF(AND(D96<>\"\",E96<>\"\"),SUM(D96*E96),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C97<>\"\",SUBTOTAL(103,$C$96:$C97),\"\"),\"\")","v":2},"Low level brickwork repairs",1,null,{"$f":"IFERROR(IF(AND(D97<>\"\",E97<>\"\"),SUM(D97*E97),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C98<>\"\",SUBTOTAL(103,$C$96:$C98),\"\"),\"\")","v":3},"Removal of wall/railings and making good",1,null,""]
[null,{"$f":"IFERROR(IF(C99<>\"\",SUBTOTAL(103,$C$96:$C99),\"\"),\"\")","v":4},"Painting works",1,null,""]
[null,{"$f":"IFERROR(IF(C100<>\"\",SUBTOTAL(103,$C$96:$C100),\"\"),\"\")","v":5},"Clearing gullies",1,null,""]
[null,{"$f":"IFERROR(IF(C101<>\"\",SUBTOTAL(103,$C$96:$C101),\"\"),\"\")","v":6},"Electrical works",1,null,""]
[null,{"$f":"IFERROR(IF(C102<>\"\",SUBTOTAL(103,$C$96:$C102),\"\"),\"\")","v":7},"New footpath",1,null,""]
[null,{"$f":"IFERROR(IF(C103<>\"\",SUBTOTAL(103,$C$96:$C103),\"\"),\"\")","v":8},"UPVC repairs",1,null,""]
[null,{"$f":"IFERROR(IF(C104<>\"\",SUBTOTAL(103,$C$96:$C104),\"\"),\"\")","v":9},"Preliminaries",1,null,""]
[]
[null,"Rockingham Road",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D108<>\"\",D109<>\"\",D110<>\"\",D111<>\"\"),SUM(D108:D111),\"\"),\"\")","v":4},{"$f":"IFERROR(IF(OR(E108<>\"\",E109<>\"\",E110<>\"\",E111<>\"\"),SUM(E108:E111),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F108<>\"\",F109<>\"\",F110<>\"\",F111<>\"\"),SUM(F108:F111),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C108<>\"\",SUBTOTAL(103,$C$108:$C108),\"\"),\"\")","v":1},"Timber repairs",1,null,{"$f":"IFERROR(IF(AND(D108<>\"\",E108<>\"\"),SUM(D108*E108),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C109<>\"\",SUBTOTAL(103,$C$108:$C109),\"\"),\"\")","v":2},"Redecoration",1,null,{"$f":"IFERROR(IF(AND(D109<>\"\",E109<>\"\"),SUM(D109*E109),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C110<>\"\",SUBTOTAL(103,$C$108:$C110),\"\"),\"\")","v":3},"Jet washing",1,null,""]
[null,{"$f":"IFERROR(IF(C111<>\"\",SUBTOTAL(103,$C$108:$C111),\"\"),\"\")","v":4},"Preliminaries",1,null,""]
[]
[null,"Studfall Avenue",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D115<>\"\",D116<>\"\",D117<>\"\",D118<>\"\",D119<>\"\",D120<>\"\"),SUM(D115:D120),\"\"),\"\")","v":6},{"$f":"IFERROR(IF(OR(E115<>\"\",E116<>\"\",E117<>\"\",E118<>\"\",E119<>\"\",E120<>\"\"),SUM(E115:E120),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F115<>\"\",F116<>\"\",F117<>\"\",F118<>\"\",F119<>\"\",F120<>\"\"),SUM(F115:F120),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C115<>\"\",SUBTOTAL(103,$C$115:$C115),\"\"),\"\")","v":1},"Timber repairs",1,null,{"$f":"IFERROR(IF(AND(D115<>\"\",E115<>\"\"),SUM(D115*E115),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C116<>\"\",SUBTOTAL(103,$C$115:$C116),\"\"),\"\")","v":2},"Cladding replacement",1,null,{"$f":"IFERROR(IF(AND(D116<>\"\",E116<>\"\"),SUM(D116*E116),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C117<>\"\",SUBTOTAL(103,$C$115:$C117),\"\"),\"\")","v":3},"New soffit lighting",1,null,""]
[null,{"$f":"IFERROR(IF(C118<>\"\",SUBTOTAL(103,$C$115:$C118),\"\"),\"\")","v":4},"New lighting columns",1,null,""]
[null,{"$f":"IFERROR(IF(C119<>\"\",SUBTOTAL(103,$C$115:$C119),\"\"),\"\")","v":5},"Scaffolding and licence",1,null,""]
[null,{"$f":"IFERROR(IF(C120<>\"\",SUBTOTAL(103,$C$115:$C120),\"\"),\"\")","v":6},"Preliminaries",1,null,""]
[]
[null,"The Jamb",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D124<>\"\",D125<>\"\",D126<>\"\",D127<>\"\",D128<>\"\",D129<>\"\"),SUM(D124:D129),\"\"),\"\")","v":6},{"$f":"IFERROR(IF(OR(E124<>\"\",E125<>\"\",E126<>\"\",E127<>\"\",E128<>\"\",E129<>\"\"),SUM(E124:E129),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F124<>\"\",F125<>\"\",F126<>\"\",F127<>\"\",F128<>\"\",F129<>\"\"),SUM(F124:F129),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C124<>\"\",SUBTOTAL(103,$C$124:$C124),\"\"),\"\")","v":1},"Timber repairs",1,null,{"$f":"IFERROR(IF(AND(D124<>\"\",E124<>\"\"),SUM(D124*E124),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C125<>\"\",SUBTOTAL(103,$C$124:$C125),\"\"),\"\")","v":2},"Redecoration of piers",1,null,{"$f":"IFERROR(IF(AND(D125<>\"\",E125<>\"\"),SUM(D125*E125),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C126<>\"\",SUBTOTAL(103,$C$124:$C126),\"\"),\"\")","v":3},"Redecoration of side section",1,null,""]
[null,{"$f":"IFERROR(IF(C127<>\"\",SUBTOTAL(103,$C$124:$C127),\"\"),\"\")","v":4},"High-level wall painting",1,null,""]
[null,{"$f":"IFERROR(IF(C128<>\"\",SUBTOTAL(103,$C$124:$C128),\"\"),\"\")","v":5},"Scaffolding and licence",1,null,""]
[null,{"$f":"IFERROR(IF(C129<>\"\",SUBTOTAL(103,$C$124:$C129),\"\"),\"\")","v":6},"Preliminaries",1,null,""]

{"sheet":"Add","index":3,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":false,"merged":[[68,2,68,4],[68,5,68,6],[69,2,69,4],[69,5,69,6],[70,2,70,4],[70,5,70,6],[65,2,65,4],[65,5,65,6],[66,2,66,4],[66,5,66,6],[67,2,67,4],[67,5,67,6],[74,2,74,4],[74,5,74,6],[75,2,75,4],[75,5,75,6],[71,2,71,4],[71,5,71,6],[72,2,72,4],[72,5,72,6],[73,2,73,4],[73,5,73,6],[62,2,62,4],[62,5,62,6],[63,2,63,4],[63,5,63,6],[64,2,64,4],[64,5,64,6],[59,2,59,4],[59,5,59,6],[60,2,60,4],[60,5,60,6],[61,2,61,4],[61,5,61,6],[56,2,56,4],[56,5,56,6],[57,2,57,4],[57,5,57,6],[58,2,58,4],[58,5,58,6],[53,2,53,4],[53,5,53,6],[54,2,54,4],[54,5,54,6],[55,2,55,4],[55,5,55,6],[50,2,50,4],[50,5,50,6],[51,2,51,4],[51,5,51,6],[52,2,52,4],[52,5,52,6],[47,2,47,4],[47,5,47,6],[48,2,48,4],[48,5,48,6],[49,2,49,4],[49,5,49,6],[44,2,44,4],[44,5,44,6],[45,2,45,4],[45,5,45,6],[46,5,46,6],[41,2,41,4],[41,5,41,6],[42,2,42,4],[42,5,42,6],[43,2,43,4],[43,5,43,6],[46,1,46,4],[38,2,38,4],[38,5,38,6],[39,2,39,4],[39,5,39,6],[40,2,40,4],[40,5,40,6],[35,2,35,4],[35,5,35,6],[36,2,36,4],[36,5,36,6],[37,2,37,4],[37,5,37,6],[32,2,32,4],[32,5,32,6],[33,2,33,4],[33,5,33,6],[34,2,34,4],[34,5,34,6],[29,2,29,4],[29,5,29,6],[30,2,30,4],[30,5,30,6],[31,2,31,4],[31,5,31,6],[26,2,26,4],[26,5,26,6],[27,2,27,4],[27,5,27,6],[28,2,28,4],[28,5,28,6],[23,2,23,4],[23,5,23,6],[24,2,24,4],[24,5,24,6],[25,2,25,4],[25,5,25,6],[20,2,20,4],[20,5,20,6],[21,2,21,4],[21,5,21,6],[22,2,22,4],[22,5,22,6],[17,2,17,4],[17,5,17,6],[18,2,18,4],[18,5,18,6],[19,2,19,4],[19,5,19,6],[1,0,1,8],[7,1,7,8],[14,5,14,6],[15,2,15,4],[15,5,15,6],[16,2,16,4],[16,5,16,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[9,1,9,7],[14,1,14,4]]}
["Previous Page",null,"Contents"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Improvement Works to Shopping Parades across Corby"}]
[]
["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, the preliminary 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 be deemed to be covered by the rates for work items included in the price breakdown.\"),CONCATENATE(\"The Supplier is to detail, below, the preliminary 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 be deemed to be covered by the rates for work items included in the price breakdown.\")),\"\")","v":"The Supplier is to detail, below, the preliminary 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 be deemed to be covered by the rates for work items included in the price breakdown."}]
[]
[null,"Additional Items 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 Preliminary Charges 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,"List of Additional Items not otherwise specified",null,null,null,"Specification and/or Contract 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,"List of Additional Items not otherwise specified",null,null,null,"Specification and/or Contract Ref:",null,"Fixed or\nTime Related","Cost"]
[null,{"$f":"IFERROR(IF(C48<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C48),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C49<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C49),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C50<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C50),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C51<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C51),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C52<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C52),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C53<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C53),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C54<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C54),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C55<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C55),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C56<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C56),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C57<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C57),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C58<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C58),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C59<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C59),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C60<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C60),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C61<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C61),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C62<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C62),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C63<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C63),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C64<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C64),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C65<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C65),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C66<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C66),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C67<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C67),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C68<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C68),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C69<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C69),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C70<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C70),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C71<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C71),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C72<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C72),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C73<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C73),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C74<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C74),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C75<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C75),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C76<>\"\",SUBTOTAL(103,$C$16:$C$46,$C$48:$C76),\"\"),\"\")","v":""}]