{"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":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,17,27,18]]}
["Document No. 5b - rFVIII - Scoring Methodology",null,null,null,null,null,null,null,null,null,"OFFICIAL - SENSITIVE COMMERCIAL"]
[]
["Framework Reference: ","CM/PHS/15/5498"]
["Framework Title: ","NHS National Framework Agreement for the supply of Recombinant Factor VIII products for the treatment of bleeding disorders"]
["Framework Timeframe: ","1st February 2018 to 31st January 2019 with options to extend up to a further 17 months. The total maximum framework period including any extensions will be no more than 29 months"]
[]
["Question  ","Weighting","Reference Number\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,"5B-1 a","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,"5B-1 b","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,"5B-1 c","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,"5C-1a / b","Scored",null,10,85,null,"40.0001% or higher than lowest offer price","35.0001% higher and equal to/less than 40% higher","30.0001% higher and equal to/less than 35% higher","25.0001% higher and equal to/less than 30% higher","20.0001% higher and equal to/less than 25% higher","15.0001% higher and equal to/less than 20% higher","10.0001% higher and equal to/less than 15% higher","5.0001% higher and equal to/less than 10% higher","0.0001% higher and equal to/less than 5% higher","lowest price",null,{"$f":"(E13/10)*85","v":0}]
["Security of Supply",0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T15:T18)","v":0}]
["Drug substance manufacture\npreparation of substances to be used in the manufacture of the final drug",null,"5C-5a / b","Scored",null,5,{"$f":"F15/4","v":1.25},null,"One facility at one geographic location","One geographic location with two or more facilities",null,"Two geographic locations with facilities","Multiple geographic locations with facilities",null,null,null,null,null,null,{"$f":"(E15/20)*5","v":0}]
["Production of drug\nthe manufacture of the final drug",null,"5C-5a / b","Scored",null,5,{"$f":"F16/4","v":1.25},null,"One facility at one geographic location","One geographic location with two or more facilities",null,"Two geographic locations with facilities","Multiple geographic locations with facilities",null,null,null,null,null,null,{"$f":"(E16/20)*5","v":0}]
["Packaging and labelling\nenclosing and labelling products for distribution, storage, sale and safe use",null,"5C-5a / b","Scored",null,5,1.25,null,"One facility at one geographic location","One geographic location with two or more facilities",null,"Two geographic locations with facilities","Multiple geographic locations with facilities",null,null,null,null,null,null,0]
["Stock holding facility / warehouse \nfacility for storing finished product which is ready for distribution to end user",null,"5C-5a / b","Scored",null,5,1.25,null,"One facility at one geographic location","One geographic location with two or more facilities",null,"Two geographic locations with facilities","Multiple geographic locations with facilities",null,null,null,null,null,null,0]
["Vial Size",0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T20","v":0}]
["Size of the vials supplied and number of different vial sizes available",null,"5C-2a / b","Scored",null,10,5,null,null,"One vial option not incl. 250 or 500 IU vial"," Two vial options not incl. 250 or 500 IU vials\nor\nOne vial option which incl. either a 250 or 500 IU vial"," Three vial options not incl. 250 or 500 IU vials\nor\nTwo vial options which incl. either a 250 or 500 IU vial","Four vial options not incl. 250 or 500 IU vials\nor\n Three vial options which incl. either a 250 or 500 IU vial\nor\nTwo vial options which incl. 250 & 500 IU vials","Four vial options which incl. either a 250 or 500 IU vial\nor\nThree vial options which incl. 250 & 500 IU vials","Four vial options which incl. 250 & 500 IU vials","Five vial options which include either a 250 or 500 IU vial","Five vial options which include 250 & 500 IU vials","All vial options",null,{"$f":"(E20/10)*5","v":0}]
["Ease of Use",0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T22:T27)","v":0}]
["Does ancillary pack allow for sterile administrations via portacath with a syringe which is 10ml or greater?",null,"5C-7a / b","Scored",null,4,0.69,"No",null,null,null,"Yes",null,null,null,null,null,null,null,{"$f":"(E22/29)*5","v":0}]
["Does ancillary pack allow for administration of multiple vials with one syringe?",null,"5C-7a / b","Scored",null,2,0.35,"No","No but extra syringe can be provided","Yes",null,null,null,null,null,null,null,null,null,0]
["Is there an option to add an ancillary pack to the purchase order without packs automatically being supplied?",null,"5C-7a / b","Scored",null,1,0.17,"No","Yes",null,null,null,null,null,null,null,null,null,null,0]
["How environmentally friendly is packaging i.e. amount of packaging, plastic v cardboard, bulkiness of packaging?",null,"5C-7a / b","Scored",null,8,1.38,"Bulky waste which includes all non-recycling material",null,"Bulky waste which includes some non-recycling material",null,null,"Bulky waste which includes all recyclable material",null,null,"Least amount of waste all of which is recyclable",null,null,null,0]
["How many steps are required to prepare product for administration?",null,"5C-7a / b","Scored",null,10,1.72,"Most number of steps","Tenth number of steps","Ninth least number of steps","Eighth least number of steps","Seventh least number of steps","Sixth least number of steps","Fifth least number of steps","Fourth least number of steps","Third least number of steps","Second least number of steps ","Least steps",null,0]
["How easily can a 750 IU dose be prepared and infused",null,"5C-7a / b","Scored",null,4,0.69,"Very Difficult","Difficult",null,"Easy ","Very easy",null,null,null,null,null,null,null,0]
["Total",{"$f":"B21+B19+B14+B12","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Score",null,{"$f":"T12+T14+T19+T21","v":0}]