{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Scoring Methodology"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Scoring Methodology","index":0,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,17,26,18]]}
["Document No. 05b - BD - Scoring Methodology",null,null,null,null,null,null,null,null,null,"OFFICIAL - SENSITIVE COMMERCIAL"]
[]
["Framework Reference: ","CM/PHS/15/5499"]
["Framework Title: ","NHS National Framework Agreement for the supply of products for the treatment of bleeding disorders"]
["Framework Timeframe: ","1st July 2018 to 30th June 2019 with options to extend up to a further 36 months. The total maximum framework period including any extensions will be no more than 48 months"]
[]
["Question  ","Weighting","TAB Reference \nDoc. No 5a","Question Type","Score","Question Type / Maximum Score","Maximum Weighted Score","Response \n0 Marks","Response  \n1 Mark","Response   \n2 Marks","Response   \n3 Marks","Response   \n4 Marks","Response   \n5 Marks","Response   \n6 Marks","Response   \n7 Marks","Response   \n8 Marks","Response   \n9 Marks","Response  \n10 Marks",null,"Question Score as % of Total Tender"]
["Eligibility","n/a"]
["Technical merit/safety",null,"Mandatory Requirements","Pass / Fail",null,"Pass","n/a","Fail","Pass",null,null,null,null,null,null,null,null,null,null,{"$f":"E9","v":0}]
["Terms and conditions",null,"Mandatory Requirements","Pass / Fail",null,"Pass","n/a","Fail","Pass",null,null,null,null,null,null,null,null,null,null,{"$f":"E10","v":0}]
["Service levels",null,"Mandatory Requirements","Pass / Fail",null,"Pass","n/a","Fail","Pass",null,null,null,null,null,null,null,null,null,null,{"$f":"E11","v":0}]
["Price",0.85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T13","v":0}]
["Price per IU",null,"Product Information","Scored",null,10,85,"90.0001% or higher than lowest offer price","80.0001% higher and equal to/less than 90% higher","70.0001% higher and equal to/less than 80% higher","60.0001% higher and equal to/less than 70% higher","50.0001% higher and equal to/less than 60% higher","40.0001% higher and equal to/less than 50% higher","30.0001% higher and equal to/less than 40% higher","20.0001% higher and equal to/less than 30% higher","10.0001% higher and equal to/less than 20% higher","0.001% higher and equal to/less than 10% higher","lowest price",null,{"$f":"(E13/10)*85","v":0}]
["Security of Supply",0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T15:T19)","v":0}]
["Minimum volume of product available \n(% of total market)",null,"Product Information","Scored",null,10,{"$f":"F15/50*10","v":2},null,"<20%","20.1 to 30% ","30.1 to 40%","40.1 to 50%","50.1 to 60%","60.1 to 80%","80.1 to 100","100.1 to 105%","105.1 to 110%",">110%",null,{"$f":"(E15/50)*10","v":0}]
["Drug substance manufacture\npreparation of substances to be used in the manufacture of the final drug",null,"Product Information","Scored",null,10,{"$f":"F16/50*10","v":2},null,"One facility at one geographic location",null,"One geographic location with two or more facilities",null,null,null,"Two geographic locations with facilities",null,null,"Multiple geographic locations with facilities",null,{"$f":"(E16/50)*10","v":0}]
["Production of drug\nthe manufacture of the final drug",null,"Product Information","Scored",null,10,{"$f":"F17/50*10","v":2},null,"One facility at one geographic location",null,"One geographic location with two or more facilities",null,null,null,"Two geographic locations with facilities",null,null,"Multiple geographic locations with facilities",null,{"$f":"(E17/50)*10","v":0}]
["Packaging and labelling\nenclosing and labelling products for distribution, storage, sale and safe use",null,"Product Information","Scored",null,10,{"$f":"F18/50*10","v":2},null,"One facility at one geographic location",null,"One geographic location with two or more facilities",null,null,null,"Two geographic locations with facilities",null,null,"Multiple geographic locations with facilities",null,{"$f":"(E18/50)*10","v":0}]
["Stock holding facility / warehouse \nfacility for storing finished product which is ready for distribution to end user",null,"Product Information","Scored",null,10,{"$f":"F19/50*10","v":2},null,"One facility at one geographic location",null,"One geographic location with two or more facilities",null,null,null,"Two geographic locations with facilities",null,null,"Multiple geographic locations with facilities",null,{"$f":"(E19/50)*10","v":0}]
["Vial Size",0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21","v":0}]
["Number of vials/syringes available",null,"Product Information","Scored",null,10,{"$f":"F21/10*5","v":5},null,1,null,null,null,2,null,null,null,null,"3 or more",null,{"$f":"(E21/10)*5","v":0}]
[null,null,null,"Scored",null,2,0.35,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E22/10)*5","v":0}]
[null,null,null,"Scored",null,1,0.17,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Scored",null,8,1.38,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Scored",null,10,1.72,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Scored",null,4,0.69,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total",{"$f":"B12+B14+B20","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Score",null,{"$f":"T12+T14+T20","v":0}]