{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Implementing PLICS","Sharing PLICS"],"not_rendered":{"charts":3,"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Implementing PLICS","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[0,1,0,12]]}
[null,"Number of Organisations implemented or implementing PLICS"]
["Acute"]
["Mental Health","Reference Costs Year / Type","2006-07","2007-08","2008-09","2009-10","2010-11","2011-12","2012-13"]
["Other","Acute Trust",13,56,59,96,115,126,132]
["Total","Mental Health Trust",0,2,5,6,10,13,18]
[null,"Other",1,3,2,3,1,3,4]
[null,"Total",{"$f":"SUM(C4:C6)","v":14},{"$f":"SUM(D4:D6)","v":61},{"$f":"SUM(E4:E6)","v":66},{"$f":"SUM(F4:F6)","v":105},{"$f":"SUM(G4:G6)","v":126},142,154]

{"sheet":"Sharing PLICS","index":1,"n_rows":107,"n_cols":10,"rows_kept":107,"merged":[[0,2,0,7]]}
[null,null,"Does your organisation share PLICS data with any of the following?"]
[]
[]
[null,"Patient Groups","Commissioners","Governors","Department of Health","Monitor","Other Organisations","Directly with Clinicians","Senior management/directors"]
["Count",{"$f":"SUM(D48:D107)","v":1},3,3,8,8,17,{"$f":"SUM(B48:B107)","v":53},{"$f":"SUM(C48:C107)","v":59}]
["Total Unique respondants to this question",60,60,60,60,60,60,60,60]
["Percentage",{"$f":"B5/B6","v":{"v":0.016666666666666666,"d":"2%"}},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.13333333333333333,"d":"13%"},{"v":0.13333333333333333,"d":"13%"},{"v":0.2833333333333333,"d":"28%"},{"v":0.8833333333333333,"d":"88%"},{"v":0.9833333333333333,"d":"98%"}]
{"$rows_empty":21}
[null,"Qualtrics answer table",{"$nulls":5},"Qualtrics answer graph"]
[null,"#","Answer","Bar","Response","%"]
[null,1,"Patient groups (as part of service consultation, for example)",{"v":0.016666666666667,"d":"1.67%"},1,{"v":0.016666666666667,"d":"1.67%"}]
[null,2,"Directly with clinicians",{"v":0.88333333333333,"d":"88.33%"},53,{"v":0.88333333333333,"d":"88.33%"}]
[null,3,"Commissioners",{"v":0.05,"d":"5.00%"},3,{"v":0.05,"d":"5.00%"}]
[null,5,"Senior management / directors",{"v":0.98333333333333,"d":"98.33%"},59,{"v":0.98333333333333,"d":"98.33%"}]
[null,6,"Governors  ",{"v":0.05,"d":"5.00%"},3,{"v":0.05,"d":"5.00%"}]
[null,8,"Other organisations (please detail)",{"v":0.28333333333333,"d":"28.33%"},17,{"v":0.28333333333333,"d":"28.33%"}]
[null,9,"Department of health",{"v":0.13333333333333,"d":"13.33%"},8,{"v":0.13333333333333,"d":"13.33%"}]
[null,10,"Monitor",{"v":0.13333333333333,"d":"13.33%"},8,{"v":0.13333333333333,"d":"13.33%"}]
[null,null,"Total",{"v":0,"d":"0.00%"},152,{"v":1,"d":"100.00%"}]
[]
[null,"Qualtrics main stats"]
[null,"Min Value","Max Value","Average Value","Variance","Standard Deviation","Total Responses","Total Respondents"]
[null,1,10,4.7171052631579,6.4691094457999,2.5434444058795,152,60]
[]
[]
[null,"Q41_2","Q41_5","Q41_1","Q41_3","Q41_6","Q41_9","Q41_10","Q41_8","Q41"]
["#","Does your organisation share PLICS data with any of the\\ following?-Directly with clinicians","Does your organisation share PLICS data with any of the\\ following?-Senior management / directors","Does your organisation share PLICS data with any of the\\ following?-Patient groups (as part of service consultation, for example)","Does your organisation share PLICS data with any of the\\ following?-Commissioners","Does your organisation share PLICS data with any of the\\ following?-Governors  ","Does your organisation share PLICS data with any of the\\ following?-Department of health","Does your organisation share PLICS data with any of the\\ following?-Monitor","Does your organisation share PLICS data with any of the\\ following?-Other organisations (please detail)","Does your organisation share PLICS data with any of the\\ following?"]
[1,1,1]
[2,1,1]
[3,1,1]
[4,1,1]
[5,1,1]
[6,1,1]
[7,1,1,null,null,1,1,1]
[8,1,1,{"$nulls":5},1,"Benchmarking Groups"]
[9,1,1]
[10,1,1]
[11,1,1,null,null,1,1,null,1,"Benchmarking club"]
[12,1,1]
[13,1,1]
[14,1,1]
[15,1,1,{"$nulls":4},1,1,"Benchmarking"]
[16,1,1,{"$nulls":4},1,1,"\"Patient Cost Benchmarking Club, Specific cost sharing for Year of Care tariff project,\""]
[17,1,1,{"$nulls":3},1]
[18,1,1]
[19,null,1,{"$nulls":5},1,"Internal steering group which includes clinicians - but not all clinicians access the data"]
[20,1,1]
[21,1,1]
[22,1,1]
[23,1,1]
[24,1,1,{"$nulls":5},1,"Patient Level Costing Benchmarking Groups"]
[25,1,1]
[26,1,1,{"$nulls":3},1,1]
[27,1,1]
[28,1,1,null,1,1,1]
[29,1,1]
[30,1,1,{"$nulls":5},1,"Departmental Managers/Service Leads"]
[31,{"$nulls":7},1,"Drectorate Finance and information managers and some clinicians"]
[32,1,1,{"$nulls":5},1,"Albatross Financial Solutions as part of Patient Cost Benchmarking"]
[33,1,1]
[34,1,1]
[35,1,1]
[36,1,1,{"$nulls":5},1,"Albatross PCB Benchmarking Groupl"]
[37,null,1]
[38,1,1,{"$nulls":5},1,"Another local FT"]
[39,1,1]
[40,1,1]
[41,1,1]
[42,1,1]
[43,1,1,{"$nulls":3},1,1,1,"\"Part of project Diamond, PCB group and adhoc requests from Ardentia user group\""]
[44,1,1,{"$nulls":5},1,"Albatross Financial Services - Patient Cost Benchmarking Service"]
[45,1,1,{"$nulls":4},1,1,"OFT as part of merger proposal"]
[46,1,1,{"$nulls":5},1,"Patient Cost Benchmark User Group"]
[47,1,1]
[48,1,1]
[49,1,1,{"$nulls":3},1,1,1,"Benchmarking group hosted by Albatross Financial Solutions Ltd"]
[50,1,1]
[51,1,1]
[52,1,1,{"$nulls":5},1,"we participate in patient cost benchmarking facilitated by Albatross"]
[53,null,1]
[54,null,1]
[55,null,1,null,1]
[56,1,1]
[57,1,1,1,1]
[58,null,1]
[59,1,1,{"$nulls":3},1,1]
[60,1,1]