{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["I&C","Summary","Rates","AddServ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":16,"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"]
["Licensed Vehicle Inspection 2018"]
[]
["Instructions and Contents"]
[]
["Introduction"]
[{"$f":"IFERROR(IF(Rates!$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 \",(Rates!$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 Licensed Vehicle Inspection 2018 requirement and will be included as an appendix to the Contract between The Supplier and Corby Borough Council."}]
[]
["Instructions"]
[{"$f":"IFERROR(IF(Rates!$C$4<>\"\",CONCATENATE(\"All areas which require \",(Rates!$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"]
["Hackney Carriage and Private Hire Testing Rates"]
["Additional Services"]

{"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":"Licensed Vehicle Inspection 2018"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(Rates!$C$4<>\"\",(Rates!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Pricing Summary Total"]
["Pricing Summary"]
[]
[null,null,"Summary Section Headings","Section Costs"]
[null,"Summary Total",null,{"$f":"IFERROR(IF(OR(D10<>\"\",D11<>\"\"),SUM(D10:D11),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C10<>\"\",SUBTOTAL(103,$C$10:$C10),\"\"),\"\")","v":1},"Hackney Carriage and Private Hire Testing Rates",{"$f":"IFERROR(IF(Rates!F53<>\"\",SUM(Rates!F53),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(C11<>\"\",SUBTOTAL(103,$C$10:$C11),\"\"),\"\")","v":2},"Additional Services",{"$f":"IFERROR(IF(AddServ!F17<>\"\",SUM(AddServ!F17),\"\"),\"\")","v":""}]

{"sheet":"Rates","index":2,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,1,51,4],[1,0,1,5],[3,0,3,1],[3,2,3,5],[4,0,4,1],[9,1,9,5],[7,1,7,5],[8,1,8,5]]}
["Previous Page",null,"Contents","Next Page"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Licensed Vehicle Inspection 2018"}]
[]
["Supplier:"]
["Sub-Heading:",null,"Hackney Carriage and Private Hire Testing Rates"]
["Pricing Schedule"]
[]
["#","Where repair work cannot be undertaken within 5 working days due to unavailability of parts, providing that the 500 miles are not exceeded and the proprietor provides a copy of an order from a main agent specifying reasons for the delay and a date when the work will commence, the re-test will be as prescribed in Section A2."]
[">","Where repair work cannot be undertaken within 5 working days due to unavailability of parts, and the proprietor provides a copy of an order from a main agent specifying reason for the delay and the date when the work will commence, the retest will be as prescribed in Section A2."]
["*","Where repairs to bodywork/paintwork cannot be undertaken within 5 working days due to delays at a garage body/paint shop, and the proprietor provides a copy of an order from the agent specifying the reason for the delay and the date the repair work will commence, the retest will be as prescribed in Section A2."]
[]
[null,"A1.","Initial Test","Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D14<>\"\",D15<>\"\",D16<>\"\",D17<>\"\",D18<>\"\"),SUM(D14:D18),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E14<>\"\",E15<>\"\",E16<>\"\",E17<>\"\",E18<>\"\"),SUM(E14:E18),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F14<>\"\",F15<>\"\",F16<>\"\",F17<>\"\",F18<>\"\"),SUM(F14:F18),\"\"),\"\")","v":""}]
[null,"i.","Annual Vehicle Licence",1,null,{"$f":"IFERROR(IF(AND(D14<>\"\",E14<>\"\"),SUM(D14*E14),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},"ii.","Annual Vehicle Licence with MOT Certificate",1,null,{"$f":"IFERROR(IF(AND(D15<>\"\",E15<>\"\"),SUM(D15*E15),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},"iii.","Spot Check",1,null,""]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},"iv.","Accident Damage",1,null,""]
[{"$f":"IFERROR(IF(#REF!<>\"\",SUBTOTAL(103,#REF!),\"\"),\"\")","v":""},"v.","Meter Check",1,null,""]
[]
[null,"A2.","Retests where key safety systems are involved – vehicle returned within 5 working days and not more than 500 registered miles from previous examination#","Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D22<>\"\",D23<>\"\",D24<>\"\",D25<>\"\",D26<>\"\"),SUM(D22:D26),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E22<>\"\",E23<>\"\",E24<>\"\",E25<>\"\",E26<>\"\"),SUM(E22:E26),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F22<>\"\",F23<>\"\",F24<>\"\",F25<>\"\",F26<>\"\"),SUM(F22:F26),\"\"),\"\")","v":""}]
[null,"i.","Annual Vehicle Licence",1,null,{"$f":"IFERROR(IF(AND(D22<>\"\",E22<>\"\"),SUM(D22*E22),\"\"),\"\")","v":""}]
[null,"ii.","Annual Vehicle Licence with MOT Certificate",1,null,{"$f":"IFERROR(IF(AND(D23<>\"\",E23<>\"\"),SUM(D23*E23),\"\"),\"\")","v":""}]
[null,"iii.","Spot Check",1,null,""]
[null,"iv.","Accident Damage",1,null,""]
[null,"v.","Meter Check",1,null,""]
[]
[null,"A3.","Retests where key safety systems are involved – vehicle returned after 5 working days and/or more than 500 registered miles from previous examination.","Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D30<>\"\",D31<>\"\",D32<>\"\",D33<>\"\",D34<>\"\"),SUM(D30:D34),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E30<>\"\",E31<>\"\",E32<>\"\",E33<>\"\",E34<>\"\"),SUM(E30:E34),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F30<>\"\",F31<>\"\",F32<>\"\",F33<>\"\",F34<>\"\"),SUM(F30:F34),\"\"),\"\")","v":""}]
[null,"i.","Annual Vehicle Licence",1,null,{"$f":"IFERROR(IF(AND(D30<>\"\",E30<>\"\"),SUM(D30*E30),\"\"),\"\")","v":""}]
[null,"ii.","Annual Vehicle Licence with MOT Certificate",1,null,{"$f":"IFERROR(IF(AND(D31<>\"\",E31<>\"\"),SUM(D31*E31),\"\"),\"\")","v":""}]
[null,"iii.","Spot Check",1,null,""]
[null,"iv.","Accident Damage",1,null,""]
[null,"v.","Meter Check",1,null,""]
[]
[null,"A4.","Retests where key safety systems are not involved – vehicle returned within 5 working days.","Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D38<>\"\",D39<>\"\",D40<>\"\",D41<>\"\",D42<>\"\"),SUM(D38:D42),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E38<>\"\",E39<>\"\",E40<>\"\",E41<>\"\",E42<>\"\"),SUM(E38:E42),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F38<>\"\",F39<>\"\",F40<>\"\",F41<>\"\",F42<>\"\"),SUM(F38:F42),\"\"),\"\")","v":""}]
[null,"i.","Annual Vehicle Licence",1,null,{"$f":"IFERROR(IF(AND(D38<>\"\",E38<>\"\"),SUM(D38*E38),\"\"),\"\")","v":""}]
[null,"ii.","Annual Vehicle Licence with MOT Certificate",1,null,{"$f":"IFERROR(IF(AND(D39<>\"\",E39<>\"\"),SUM(D39*E39),\"\"),\"\")","v":""}]
[null,"iii.","Spot Check",1,null,""]
[null,"iv.","Accident Damage",1,null,""]
[null,"v.","Meter Check",1,null,""]
[]
[null,"A5.","Retests where key safety systems are not involved – vehicle returned after 5 working days. > *","Quantity","Cost Per Item","Cost for\nQty Required"]
[null,"Sub-Total carried to Summary",null,{"$f":"IFERROR(IF(OR(D46<>\"\",D47<>\"\",D48<>\"\",D49<>\"\",D50<>\"\"),SUM(D46:D50),\"\"),\"\")","v":5},{"$f":"IFERROR(IF(OR(E46<>\"\",E47<>\"\",E48<>\"\",E49<>\"\",E50<>\"\"),SUM(E46:E50),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F46<>\"\",F47<>\"\",F48<>\"\",F49<>\"\",F50<>\"\"),SUM(F46:F50),\"\"),\"\")","v":""}]
[null,"i.","Annual Vehicle Licence",1,null,{"$f":"IFERROR(IF(AND(D46<>\"\",E46<>\"\"),SUM(D46*E46),\"\"),\"\")","v":""}]
[null,"ii.","Annual Vehicle Licence with MOT Certificate",1,null,{"$f":"IFERROR(IF(AND(D47<>\"\",E47<>\"\"),SUM(D47*E47),\"\"),\"\")","v":""}]
[null,"iii.","Spot Check",1,null,""]
[null,"iv.","Accident Damage",1,null,""]
[null,"v.","Meter Check",1,null,""]
[]
[null,"Schedule Costs",null,null,null,"Total"]
[null,"Sub-Total of Hackney Carriage & Private Hire Testing Rates carried to Summary",null,null,null,{"$f":"IFERROR(IF(OR(F13<>\"\",F21<>\"\",F29<>\"\",F37<>\"\",F45<>\"\"),SUM(F13,F21,F29,F37,F45),\"\"),\"\")","v":""}]

{"sheet":"AddServ","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,0,7,5],[9,1,9,2],[15,1,15,4],[1,0,1,5],[5,0,5,5],[4,2,4,5],[3,2,3,5]]}
["Previous Page",null,"Contents"]
[{"$f":"IFERROR(IF('I&C'!$A$2<>\"\",('I&C'!$A$2),\"\"),\"\")","v":"Licensed Vehicle Inspection 2018"}]
[]
["Supplier:",null,{"$f":"IFERROR(IF(Rates!$C$4<>\"\",(Rates!$C$4),\"\"),\"\")","v":""}]
["Sub-Heading:",null,"Additional Services"]
["Pricing Schedule"]
[]
["The items for which separate quotations* are to be submitted, are as follows:-\n\nPlease complete this Pricing Schedule on a per test basis for each of the categories, as specified on the \"Prescribed Levels of Testing\" table at Appendix 3 of the Specification (Document 2). All prices quoted are to be INCLUSIVE OF VAT.\n\nQuotations should relate to Corby Borough Council’s \"Prescribed Levels of Testing\" table in the Response Document (Document 4). Quotations should also provide an Hourly Rate, INCLUSIVE OF VAT for each of the items identified below."]
[]
[null,"Item",null,"Quantity Required","Cost Each (£ p)","Cost for\nQty Required"]
[null,"Sub-Total carried to Schedule of Costs",null,{"$f":"IFERROR(IF(OR(D12<>\"\",D13<>\"\",D14<>\"\"),SUM(D12:D14),\"\"),\"\")","v":3},{"$f":"IFERROR(IF(OR(E12<>\"\",E13<>\"\",E14<>\"\"),SUM(E12:E14),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(OR(F12<>\"\",F13<>\"\",F14<>\"\"),SUM(F12:F14),\"\"),\"\")","v":""}]
[null,"B.","Undertaking the annual fare revision meter checks and sealing",1,null,{"$f":"IFERROR(IF(AND(D12<>\"\",E12<>\"\"),SUM(D12*E12),\"\"),\"\")","v":""}]
[null,"C.","Attendance of any employee at Court to act as a witness on behalf of the licensing authority",1,null,{"$f":"IFERROR(IF(AND(D13<>\"\",E13<>\"\"),SUM(D13*E13),\"\"),\"\")","v":""}]
[null,"D.","Additional Costs",1,null,""]
[]
[null,"Schedule Costs",null,null,null,"Total"]
[null,"Sub-Total of Additional Services carried to Summary",null,null,null,{"$f":"IFERROR(IF(OR(F11<>\"\"),SUM(F11),\"\"),\"\")","v":""}]