{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Guidance","Pricing schedule - yr 1 and 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Guidance","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Guidance on completing this pricing schedule"]
[]
[null,null,null,"1.1 Basis of price evaluation/value for money assessment"]
[null,null,null,"Supplier price will be evaluated on the basis of: "]
[null,null,null,"1. The total price for the initial 2 year term of the contract for delivery of the Core Specification "]
[]
[null,null,null,"1.2 Price Variation "]
[null,null,null," Day rates and prices for delivery of the Core Specification shall remain fixed for the full term of the contract.  "]
[]
[null,null,null,"1.3 Time of payment"]
[null,null,null,"The timing for payments will be made quarterly in line with the specification. "]
[]
[null,null,null,"1.4 General instructions for completion of Price submission "]
[null,null,null,"All costs submitted must be exclusive of VAT and VAT calculated sepeartely- please include the VAT rate in cell F:15"]
[null,null,null,"All costs specified must be in GBP."]
[]
[null,null,null,"1.5 What is in scope of the price"]
[null,null,null,"The cost quoted must be a total cost for the delivery of the specification in full and must include (but is not limited to) costs arising from: All products, tools, hardware, storage, software packages, licences, application fees supplied to the customer, staff (including specialists and sub contractors and any products, tools, software packages, licences, application fees required for the staff to deliver the Service), travel and subsistence costs and any other cost required to deliver the Service as outlined in the Specification."]
[]
[null,null,null,"1.6 Format of Price Submission"]
[null,null,null,"Suppliers are required to provide their pricing within the Pricing Schedule (Excel document) provided in this document  "]
[null,null,null,"Suppliers must complete all cells with the information as requested and in accordance with the instructions further provided here"]
[null,null,null,"Where a price does not apply, Suppliers should note this by leaving blank"]
[null,null,null,"Cells highlighted in grey will be auto filled"]
[null,null,null,"Completed pricing schedules should be submitted along with your bid via Atamis"]
[]
[null,null,null,"1.7 Approach to evaluation "]
[null,null,null,"The price evaluation/ value for money assessment is worth 30% of the overall evaluation of the ITT assessment. "]
[]
[null,null,null,"Lowest total cost for delivery offered x Financial weighting ÷ the Tendered total cost for delivery "]
[null,null,null,"For example, where Supplier A submits the lowest price for delivery out of all suppliers at a price of £160,000 for the core specification and Supplier B submits a price of £170,000 for total cost of delivery, each Supplier would score as follows: "]
[null,null,null,"Supplier A = 160,000 x 30 /160,000 = 30% "]
[null,null,null,"Supplier B = 160,000 x 30 /170,000 = 28.24%  (rounded to two decimal places)"]

{"sheet":"Pricing schedule - yr 1 and 2","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,1],[15,0,15,7],[14,0,14,1]]}
[null,"Improvement Analytics Unit (AIU) Healthcare Initiatives Evaluation"]
[]
["Job Role/ Service Item",null,"Day Rate/ individual cost (fixed for the duration of the contract)(£) exclusive of VAT","Number of Days/Quantity e.g. 1,2,3 etc.","Year 1\nEXC VAT (£)","Year 1 VAT Costs (£)","Number of Days/Quantity e.g. 1,2,3 etc.","Year 2\nEXC VAT (£)","Year  2 VAT Costs (£)","Total \ninc VAT For 2 Years  (£)"]
[1,"data processing",null,null,{"$f":"SUM(C4*D4)","v":0},{"$f":"SUM(E4/100)*$F$15","v":0},null,{"$f":"SUM(C4*G4)","v":0},{"$f":"SUM(H4/100)*$F$15","v":0},{"$f":"SUM(E4+F4+H4+I4)","v":0}]
[2,"data evaluation",null,null,{"$f":"SUM(C5*D5)","v":0},{"$f":"SUM(E5/100)*$F$15","v":0},null,{"$f":"SUM(C5*G5)","v":0},{"$f":"SUM(H5/100)*$F$15","v":0},{"$f":"SUM(E5+F5+H5+I5)","v":0}]
[3,"oversight",null,null,{"$f":"SUM(C6*D6)","v":0},0,null,0,0,0]
[4,"project management ",null,null,{"$f":"SUM(C7*D7)","v":0},0,null,0,0,0]
[5,"senior oversight ",null,null,{"$f":"SUM(C8*D8)","v":0},0,null,0,0,0]
[6,"[Add additional items as required]",null,null,0,0,null,0,0,0]
[7,"[Add additional items as required]",null,null,0,0,null,0,0,0]
[8,"[Add additional items as required]",null,null,0,0,null,0,0,0]
[9,"[Add additional items as required]",null,null,{"$f":"SUM(C12*D12)","v":0},0,null,0,0,0]
[null,"Total ",null,null,{"$f":"SUM(E4:E12)","v":0},{"$f":"SUM(E13/100)*F15","v":0},null,{"$f":"SUM(H4:H12)","v":0},{"$f":"SUM(H13/100)*F15","v":0},{"$f":"SUM(E13+F13+H13+I13)","v":0}]
[]
[null,null,null,null,"Please add VAT % in cell F:15"]