{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["User Inputs","Upper and Lower Limits","Sensitivity Analysis","Output - Chart"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":1,"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":"User Inputs","index":0,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,8,1,15],[14,2,14,3],[15,2,15,3],[13,2,13,3],[3,2,3,3],[4,2,4,3],[3,4,3,6],[4,4,4,6],[1,4,1,6],[8,2,8,3],[6,2,6,3],[1,2,1,3],[10,2,10,3],[11,2,11,3],[7,2,7,3]]}
[]
[null,null,"Which access route do you wish to model?  (select drop-down)",null,"e-consult first",null,null,null,{"$f":"'Output - Chart'!$O$2","v":"e-consult first compared to conventional: Impact on primary care workload"}]
[]
[null,null,{"$f":"\"Select the x-axis for the chart (\" &E2 &\" variables in blue)\"","v":"Select the x-axis for the chart (e-consult first variables in blue)"},null,"e-consult supply-related demand"]
[null,null,{"$f":"\"Select the legend for the chart (\" &E2 &\" variables in blue)\"","v":"Select the legend for the chart (e-consult first variables in blue)"},null,"e-consult completion rate"]
[]
[null,null,"Alternative Access Route Variables",null,"e-consult first","telephone first","video first"]
[null,null,"Access rate: % of consultations initially requested in this way",null,0.9,0.93,0.9]
[null,null,"Completion rate: % of digital consultations completed without needing a subsequent consultation",null,0.3,0.52,0.65]
[null,null,"n","Phone via e-consult: Of those having a real-time consultation after e-consult, % having phone rather than F2F consultation",0.46]
[null,null,"Consultation Duration: Average time spent by GP on this type of consultation (minutes)",null,4,5,9]
[null,null,"Supply-related demand: % of digital consultations which are new demand",null,0.1,0,0]
[]
[null,null,"Conventional care Variables"]
[null,null,"% of conventional consultations managed by telephone",null,0.14000000000000001]
[null,null,"Duration of face to face consultation (minutes)",null,9]

{"sheet":"Upper and Lower Limits","index":1,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":true,"merged":[[4,0,4,1],[7,0,7,1],[4,3,4,4],[7,3,7,4],[5,3,5,4],[9,3,9,4],[8,3,8,4],[5,0,5,1],[8,0,8,1],[9,0,9,1]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,2]
[null,null,null,null,null,null,"e-consult first",null,null,"Telephone first",null,null,"Video first",null,null,"Conventional (telephone as exception)",null,null,null,{"$f":"MATCH(AltCon_txt,$J$3:$O$3,0)+T2","v":{"$error":"#N/A"}},{"$f":"MATCH(AltCon_txt,$J$3:$O$3,0)+U2","v":{"$error":"#N/A"}},{"$f":"MATCH(AltCon_txt,$J$3:$O$3,0)+V2","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Row headings for tel/video","base case","lower estimate","upper estimate","base case","lower estimate","upper estimate","base case","lower estimate","upper estimate","base case","lower estimate","upper estimate","Row headings for e-consult","base case","lower estimate","upper estimate"]
["Alt-Con Access rate: % of consultations managed using the new access route",null,"E1/X1","Access Rate",null,{"$f":"\"Tel/video \" &D5","v":"Tel/video Access Rate"},{"$f":"'User Inputs'!E8","v":0.9},1E-4,1,{"$f":"'User Inputs'!F8","v":0.93},0.1,1,{"$f":"'User Inputs'!G8","v":0.9},0.5,1,{"$f":"'User Inputs'!E15","v":0.14000000000000001},{"$f":"P5","v":0.14000000000000001},{"$f":"Q5","v":0.14000000000000001},"e-consult access rate",{"$f":"IF(AltCon_txt=\"e-consult first\", J5,INDEX($J5:$O5,1,T$3))","v":0.93},0.1,1]
["Alt-con completion rate: % of consultations managed in new way without any further assessment",null,"E3/X3","Completion Rate",null,"Tel/video Completion Rate",{"$f":"'User Inputs'!E9","v":0.3},0.28000000000000003,0.7,{"$f":"'User Inputs'!F9","v":0.52},0.4,0.9,{"$f":"'User Inputs'!G9","v":0.65},0.5,0.83,{"$f":"J6","v":0.52},{"$f":"K6","v":0.4},{"$f":"L6","v":0.9},"e-consult completion rate",0.52,0.4,0.9]
["Of those having a real-time consultation after e-consult, % having phone consultation",null,"(X1)e","Phone via e-consult",null,null,{"$f":"'User Inputs'!E10","v":0.46},0.2,0.9,null,null,null,null,null,null,null,null,null,{"$f":"D7","v":"Phone via e-consult"}]
["Alt-con time: Average time spent by GP on alternative format",null,"E2/X2","Consultation Duration",null,"Tel/video Consultation Duration",{"$f":"'User Inputs'!E11","v":4},3,5,{"$f":"'User Inputs'!F11","v":5},4,6,{"$f":"'User Inputs'!G11","v":9},6,15,{"$f":"J8","v":5},{"$f":"K8","v":4},{"$f":"L8","v":6},"e-consult consultation duration",{"$f":"IF(AltCon_txt=\"e-consult first\", J8,INDEX($J8:$O8,1,T$3))","v":5},4,6]
["Supply-induced demand: % of alternative form consultations which are new demand",null,"E5/X5","Supply-related demand",null,"Tel/video Supply-related demand",{"$f":"'User Inputs'!E12","v":0.1},-0.1,0.3,{"$f":"'User Inputs'!F12","v":0},-0.1,0.3,{"$f":"'User Inputs'!G12","v":0},-0.1,0.3,0,0,0,"e-consult supply-related demand",0,-0.1,0.3]
["GP F2F time: Average time spent by GP on conventional face to face consultation (minutes)",null,"F1","GP F2F time",null,null,{"$f":"$P10","v":9},{"$f":"$P10","v":9},9,9,9,9,9,9,9,{"$f":"'User Inputs'!E16","v":9},{"$f":"P10","v":9},{"$f":"P10","v":9},null,9,9,9]
[]
[]
[null,null,null,"e-consult first"]
[null,null,null,{"$f":"J3","v":"Telephone first"}]
[null,null,null,{"$f":"M3","v":"Video first"}]
["Named ranges and contents of drop-downs ---->",null,null,null,null,"Default variables","e-consult first","telephone first","video first"]
[null,null,null,"Yes",null,"X1",0.9,0.93,0.9]
[null,null,null,"No",null,"X2",0.3,0.52,0.65]
[null,null,null,null,null,"X1(e) ",0.46]
[null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",'Upper and Lower Limits'!S5,'Upper and Lower Limits'!F5)","v":"e-consult access rate"},null,"X3",4,5,9]
[null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",'Upper and Lower Limits'!S6,'Upper and Lower Limits'!F6)","v":"e-consult completion rate"},null,"X4",0.1,0,0]
[null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",'Upper and Lower Limits'!S7,'Upper and Lower Limits'!F8)","v":"Phone via e-consult"}]
[null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",'Upper and Lower Limits'!S8,'Upper and Lower Limits'!F9)","v":"e-consult consultation duration"}]
[null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",'Upper and Lower Limits'!S9,\"\")","v":"e-consult supply-related demand"},null,"F1",0.14000000000000001]
[null,null,null,null,null,"F2",9]

{"sheet":"Sensitivity Analysis","index":2,"n_rows":80,"n_cols":67,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"s=lower estimate",null,null,null,null,null,null,null,null,null,null,"s=lower mid estimate",null,null,null,null,null,null,null,null,null,null,"s=base case estimate",null,null,null,null,null,null,null,null,null,null,"s=upper mid",null,null,null,null,null,null,null,null,null,null,"s=upper"]
[null,null,null,"variable","Alternative Consultation Variables","base case","lower estimate","upper estimate","lower-mid estimate","upper-mid estimate","increment",1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11,"base case if x"]
["E1","e-consulation access rate","percent",{"$f":"IF(E8=X_axis_txt,\"X\", IF(E8=legend_txt,\"S\",\"\"))","v":""},{"$f":"'Upper and Lower Limits'!S5","v":"e-consult access rate"},{"$f":"'Upper and Lower Limits'!G5","v":0.9},{"$f":"'Upper and Lower Limits'!H5","v":1E-4},{"$f":"'Upper and Lower Limits'!I5","v":1},{"$f":"$F8-(($F8-$G8)/2)","v":0.45005000000000001},{"$f":"$F8+(($H8-$F8)/2)","v":0.95},{"$f":"(H8-G8)/10","v":9.9989999999999996E-2},{"$f":"IF($D8=\"X\",($G8+($K8*(L$7-1))),IF($D8=\"S\",($G8),$F8))","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,{"$f":"IF($D8=\"X\",($G8+($K8*(W$7-1))),IF($D8=\"S\",($I8),$F8))","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,{"$f":"IF($D8=\"X\",($G8+($K8*(AH$7-1))),IF($D8=\"S\",($F8),$F8))","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,{"$f":"IF($D8=\"X\",($G8+($K8*(AS$7-1))),IF($D8=\"S\",($J8),$F8))","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,{"$f":"IF($D8=\"X\",($G8+($K8*(BD$7-1))),IF($D8=\"S\",($H8),$F8))","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,{"$f":"IF($D8=\"X\",F8,)","v":0}]
["E2","e-consulation completion rate","percent","S",{"$f":"'Upper and Lower Limits'!S6","v":"e-consult completion rate"},{"$f":"'Upper and Lower Limits'!G6","v":0.3},{"$f":"'Upper and Lower Limits'!H6","v":0.28000000000000003},{"$f":"'Upper and Lower Limits'!I6","v":0.7},0.29000000000000004,0.5,4.1999999999999996E-2,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,{"$f":"IF($D9=\"X\",F9,)","v":0}]
["X1(e)",null,"percent","",{"$f":"'Upper and Lower Limits'!S7","v":"Phone via e-consult"},{"$f":"'Upper and Lower Limits'!G7","v":0.46},{"$f":"'Upper and Lower Limits'!H7","v":0.2},{"$f":"'Upper and Lower Limits'!I7","v":0.9},0.33,0.68,6.9999999999999993E-2,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0]
["E3","e-consultation clincian time (mins)","number",{"$f":"IF(E11=X_axis_txt,\"X\", IF(E11=legend_txt,\"S\",\"\"))","v":""},{"$f":"'Upper and Lower Limits'!S8","v":"e-consult consultation duration"},{"$f":"'Upper and Lower Limits'!G8","v":4},{"$f":"'Upper and Lower Limits'!H8","v":3},{"$f":"'Upper and Lower Limits'!I8","v":5},{"$f":"$F11-(($F11-$G11)/2)","v":3.5},{"$f":"$F11+(($H11-$F11)/2)","v":4.5},{"$f":"(H11-G11)/10","v":0.2},4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,{"$f":"IF($D11=\"X\",F11,)","v":0}]
["E4","e-consulation completion rate","percent","X",{"$f":"'Upper and Lower Limits'!S9","v":"e-consult supply-related demand"},{"$f":"'Upper and Lower Limits'!G9","v":0.1},{"$f":"'Upper and Lower Limits'!H9","v":-0.1},{"$f":"'Upper and Lower Limits'!I9","v":0.3},0,0.2,0.04,-0.1,-6.0000000000000005E-2,-2.0000000000000004E-2,1.999999999999999E-2,0.06,0.1,0.13999999999999999,0.18000000000000002,0.22,0.26,0.30000000000000004,-0.1,-6.0000000000000005E-2,-2.0000000000000004E-2,1.999999999999999E-2,0.06,0.1,0.13999999999999999,0.18000000000000002,0.22,0.26,0.30000000000000004,-0.1,-6.0000000000000005E-2,-2.0000000000000004E-2,1.999999999999999E-2,0.06,0.1,0.13999999999999999,0.18000000000000002,0.22,0.26,0.30000000000000004,-0.1,-6.0000000000000005E-2,-2.0000000000000004E-2,1.999999999999999E-2,0.06,0.1,0.13999999999999999,0.18000000000000002,0.22,0.26,0.30000000000000004,-0.1,-6.0000000000000005E-2,-2.0000000000000004E-2,1.999999999999999E-2,0.06,0.1,0.13999999999999999,0.18000000000000002,0.22,0.26,0.30000000000000004,0.1]
["X1","Alt-Con access rate","percent","",{"$f":"'Upper and Lower Limits'!F5","v":"Tel/video Access Rate"},{"$f":"'Upper and Lower Limits'!T5","v":0.93},{"$f":"'Upper and Lower Limits'!U5","v":0.1},{"$f":"'Upper and Lower Limits'!V5","v":1},0.51500000000000001,0.96500000000000008,0.09,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0]
["X2","Alt-con completion rate","percent","",{"$f":"'Upper and Lower Limits'!F6","v":"Tel/video Completion Rate"},{"$f":"'Upper and Lower Limits'!T6","v":0.52},{"$f":"'Upper and Lower Limits'!U6","v":0.4},{"$f":"'Upper and Lower Limits'!V6","v":0.9},0.46,0.71,0.05,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0]
["X3","Alt-con time","number",{"$f":"IF(E15=X_axis_txt,\"X\", IF(E15=legend_txt,\"S\",\"\"))","v":""},{"$f":"'Upper and Lower Limits'!F8","v":"Tel/video Consultation Duration"},{"$f":"'Upper and Lower Limits'!T8","v":5},{"$f":"'Upper and Lower Limits'!U8","v":4},{"$f":"'Upper and Lower Limits'!V8","v":6},{"$f":"$F15-(($F15-$G15)/2)","v":4.5},{"$f":"$F15+(($H15-$F15)/2)","v":5.5},{"$f":"(H15-G15)/10","v":0.2},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"$f":"IF($D15=\"X\",F15,)","v":0}]
["X4","Supply induced demand","percent","",{"$f":"'Upper and Lower Limits'!F9","v":"Tel/video Supply-related demand"},{"$f":"'Upper and Lower Limits'!T9","v":0},{"$f":"'Upper and Lower Limits'!U9","v":-0.1},{"$f":"'Upper and Lower Limits'!V9","v":0.3},-0.05,0.15,0.04,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["F1","GP F2F time","number","",{"$f":"'Upper and Lower Limits'!D10","v":"GP F2F time"},{"$f":"'Upper and Lower Limits'!T10","v":9},{"$f":"'Upper and Lower Limits'!U10","v":9},{"$f":"'Upper and Lower Limits'!V10","v":9},9,9,0,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,0]
[null,null,null,null,"digital: supply-induced demand compared with original",{"$f":"1/(1-F12)","v":1.1111111111111112},0.90909090909090906,1.4285714285714286,1,1.25,1.0416666666666667,{"$f":"1/(1-L12)","v":0.90909090909090906},0.94339622641509424,0.98039215686274506,1.0204081632653061,1.0638297872340425,1.1111111111111112,1.1627906976744187,1.2195121951219512,1.2820512820512819,1.3513513513513513,1.4285714285714286,0.90909090909090906,0.94339622641509424,0.98039215686274506,1.0204081632653061,1.0638297872340425,1.1111111111111112,1.1627906976744187,1.2195121951219512,1.2820512820512819,1.3513513513513513,1.4285714285714286,0.90909090909090906,0.94339622641509424,0.98039215686274506,1.0204081632653061,1.0638297872340425,1.1111111111111112,1.1627906976744187,1.2195121951219512,1.2820512820512819,1.3513513513513513,1.4285714285714286,0.90909090909090906,0.94339622641509424,0.98039215686274506,1.0204081632653061,1.0638297872340425,1.1111111111111112,1.1627906976744187,1.2195121951219512,1.2820512820512819,1.3513513513513513,1.4285714285714286,0.90909090909090906,0.94339622641509424,0.98039215686274506,1.0204081632653061,1.0638297872340425,1.1111111111111112,1.1627906976744187,1.2195121951219512,1.2820512820512819,1.3513513513513513,1.4285714285714286]
[null,null,null,null,"tel/video: Supply induced demand compared with original",{"$f":"1/(1-(F16))","v":1},0.90909090909090906,1.4285714285714286,0.95238095238095233,1.1764705882352942,1.0416666666666667,{"$f":"1/(1-(L16))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"MAX(BO8:BO17)","v":0.1}]
[null,null,null,null,"The is the total additional demand routed into the system at the very beginning"]
["ArrivalProportion",null,null,null,"Supply-induced demand",{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!F18,'Sensitivity Analysis'!F19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!G18,'Sensitivity Analysis'!G19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!H18,'Sensitivity Analysis'!H19)","v":1.4285714285714286},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!I18,'Sensitivity Analysis'!I19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!J18,'Sensitivity Analysis'!J19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!K18,'Sensitivity Analysis'!K19)","v":1.0416666666666667},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!L18,'Sensitivity Analysis'!L19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!M18,'Sensitivity Analysis'!M19)","v":0.94339622641509424},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!N18,'Sensitivity Analysis'!N19)","v":0.98039215686274506},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!O18,'Sensitivity Analysis'!O19)","v":1.0204081632653061},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!P18,'Sensitivity Analysis'!P19)","v":1.0638297872340425},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Q18,'Sensitivity Analysis'!Q19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!R18,'Sensitivity Analysis'!R19)","v":1.1627906976744187},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!S18,'Sensitivity Analysis'!S19)","v":1.2195121951219512},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!T18,'Sensitivity Analysis'!T19)","v":1.2820512820512819},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!U18,'Sensitivity Analysis'!U19)","v":1.3513513513513513},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!V18,'Sensitivity Analysis'!V19)","v":1.4285714285714286},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!W18,'Sensitivity Analysis'!W19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!X18,'Sensitivity Analysis'!X19)","v":0.94339622641509424},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Y18,'Sensitivity Analysis'!Y19)","v":0.98039215686274506},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Z18,'Sensitivity Analysis'!Z19)","v":1.0204081632653061},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AA18,'Sensitivity Analysis'!AA19)","v":1.0638297872340425},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AB18,'Sensitivity Analysis'!AB19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AC18,'Sensitivity Analysis'!AC19)","v":1.1627906976744187},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AD18,'Sensitivity Analysis'!AD19)","v":1.2195121951219512},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AE18,'Sensitivity Analysis'!AE19)","v":1.2820512820512819},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AF18,'Sensitivity Analysis'!AF19)","v":1.3513513513513513},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AG18,'Sensitivity Analysis'!AG19)","v":1.4285714285714286},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AH18,'Sensitivity Analysis'!AH19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AI18,'Sensitivity Analysis'!AI19)","v":0.94339622641509424},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AJ18,'Sensitivity Analysis'!AJ19)","v":0.98039215686274506},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AK18,'Sensitivity Analysis'!AK19)","v":1.0204081632653061},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AL18,'Sensitivity Analysis'!AL19)","v":1.0638297872340425},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AM18,'Sensitivity Analysis'!AM19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AN18,'Sensitivity Analysis'!AN19)","v":1.1627906976744187},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AO18,'Sensitivity Analysis'!AO19)","v":1.2195121951219512},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AP18,'Sensitivity Analysis'!AP19)","v":1.2820512820512819},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AQ18,'Sensitivity Analysis'!AQ19)","v":1.3513513513513513},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AR18,'Sensitivity Analysis'!AR19)","v":1.4285714285714286},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AS18,'Sensitivity Analysis'!AS19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AT18,'Sensitivity Analysis'!AT19)","v":0.94339622641509424},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AU18,'Sensitivity Analysis'!AU19)","v":0.98039215686274506},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AV18,'Sensitivity Analysis'!AV19)","v":1.0204081632653061},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AW18,'Sensitivity Analysis'!AW19)","v":1.0638297872340425},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AX18,'Sensitivity Analysis'!AX19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AY18,'Sensitivity Analysis'!AY19)","v":1.1627906976744187},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AZ18,'Sensitivity Analysis'!AZ19)","v":1.2195121951219512},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BA18,'Sensitivity Analysis'!BA19)","v":1.2820512820512819},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BB18,'Sensitivity Analysis'!BB19)","v":1.3513513513513513},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BC18,'Sensitivity Analysis'!BC19)","v":1.4285714285714286},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BD18,'Sensitivity Analysis'!BD19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BE18,'Sensitivity Analysis'!BE19)","v":0.94339622641509424},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BF18,'Sensitivity Analysis'!BF19)","v":0.98039215686274506},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BG18,'Sensitivity Analysis'!BG19)","v":1.0204081632653061},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BH18,'Sensitivity Analysis'!BH19)","v":1.0638297872340425},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BI18,'Sensitivity Analysis'!BI19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BJ18,'Sensitivity Analysis'!BJ19)","v":1.1627906976744187},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BK18,'Sensitivity Analysis'!BK19)","v":1.2195121951219512},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BL18,'Sensitivity Analysis'!BL19)","v":1.2820512820512819},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BM18,'Sensitivity Analysis'!BM19)","v":1.3513513513513513},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BN18,'Sensitivity Analysis'!BN19)","v":1.4285714285714286}]
[]
[]
[null,null,null,null,"Patient proprtions - alternative route (proportions inflated)"]
[null,"E1 x Arrival proprtion",null,"Process 1","proportion managed through digital first",{"$f":"IF(AltCon_txt=\"e-consult first\",F21*F8,0)","v":1},null,null,null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",L21*L8,0)","v":0.81818181818181812},0.84905660377358483,0.88235294117647056,0.91836734693877553,0.95744680851063835,1,1.0465116279069768,1.0975609756097562,1.1538461538461537,1.2162162162162162,1.2857142857142858,0.81818181818181812,0.84905660377358483,0.88235294117647056,0.91836734693877553,0.95744680851063835,1,1.0465116279069768,1.0975609756097562,1.1538461538461537,1.2162162162162162,1.2857142857142858,0.81818181818181812,0.84905660377358483,0.88235294117647056,0.91836734693877553,0.95744680851063835,1,1.0465116279069768,1.0975609756097562,1.1538461538461537,1.2162162162162162,{"$f":"IF(AltCon_txt=\"e-consult first\",AR21*AR8,0)","v":1.2857142857142858},0.81818181818181812,0.84905660377358483,0.88235294117647056,0.91836734693877553,0.95744680851063835,1,1.0465116279069768,1.0975609756097562,1.1538461538461537,1.2162162162162162,1.2857142857142858,0.81818181818181812,0.84905660377358483,0.88235294117647056,0.91836734693877553,0.95744680851063835,1,1.0465116279069768,1.0975609756097562,1.1538461538461537,1.2162162162162162,1.2857142857142858]
[null,"e-consult=(1-E1)*(1-X1-conventional) + ArrivalProportion*E1*(1-E2)*X1e  : tel/video = 1-X1",null,"Process 2","GP F2F appt as first real time contact",{"$f":"IF(AltCon_txt=\"e-consult first\",(((1-F8)*(1-F39))+(F8*F21*(1-F9)*(1-F10))),(1-F13))","v":0.46399999999999997},null,null,null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",(((1-L8)*(1-L39))+(L8*L21*(1-L9)*(1-L10))),(1-L13))","v":0.40410909090909086},0.41611320754716979,0.42905882352941171,0.44306122448979585,0.45825531914893614,0.4748,0.49288372093023258,0.51273170731707318,0.5346153846153846,0.55886486486486486,0.58588571428571434,0.39969090909090904,0.4115283018867924,0.42429411764705882,0.43810204081632648,0.45308510638297866,0.46939999999999998,0.48723255813953492,0.50680487804878049,0.52838461538461534,0.55229729729729726,0.5789428571428572,0.39527272727272722,0.40694339622641501,0.41952941176470582,0.43314285714285711,0.4479148936170213,0.46399999999999997,0.4815813953488372,0.50087804878048781,0.52215384615384608,0.54572972972972977,{"$f":"IF(AltCon_txt=\"e-consult first\",(((1-AR8)*(1-AR39))+(AR8*AR21*(1-AR9)*(1-AR10))),(1-AR13))","v":0.57200000000000006},0.30690909090909091,0.31524528301886789,0.32423529411764707,0.33395918367346938,0.34451063829787232,0.35599999999999998,0.3685581395348837,0.38234146341463415,0.39753846153846151,0.41437837837837838,0.43314285714285716,0.21854545454545454,0.22354716981132072,0.22894117647058826,0.23477551020408166,0.24110638297872344,0.248,0.25553488372093025,0.2638048780487805,0.27292307692307693,0.28302702702702703,0.29428571428571432]
[null,"e-consult=(1-E1)*(X1-conventional) + ArrivalProportion*E1*(1-E2)*(1-X1e)  : tel/video = ArrivalRate*X1 + (1-X1)*X1-conventional",null,"Process 3","GP tele or video as first real time contact",{"$f":"IF(AltCon_txt=\"e-consult first\",((1-F8)*F39)+(F8*F21*(1-F9)*F10),(F21*F13))","v":0.33600000000000002},null,null,null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",((1-L8)*L39)+(L8*L21*(1-L9)*L10),(L21*L13))","v":0.28498181818181817},0.29520754716981135,0.30623529411764705,0.31816326530612243,0.33110638297872341,0.34520000000000001,0.36060465116279078,0.37751219512195128,0.39615384615384613,0.41681081081081084,0.43982857142857146,0.28121818181818181,0.29130188679245284,0.30217647058823532,0.3139387755102041,0.32670212765957446,0.34060000000000001,0.35579069767441868,0.37246341463414639,0.39084615384615379,0.41121621621621623,0.43391428571428575,0.27745454545454545,0.28739622641509432,0.29811764705882354,0.30971428571428572,0.32229787234042556,0.33600000000000002,0.35097674418604652,0.36741463414634151,0.3855384615384615,0.40562162162162163,{"$f":"IF(AltCon_txt=\"e-consult first\",((1-AR8)*AR39)+(AR8*AR21*(1-AR9)*AR10),(AR21*AR13))","v":0.42800000000000005},0.20218181818181818,0.2092830188679245,0.21694117647058825,0.22522448979591836,0.23421276595744683,0.24399999999999999,0.25469767441860469,0.26643902439024397,0.2793846153846154,0.29372972972972977,0.30971428571428578,0.12690909090909092,0.13116981132075473,0.13576470588235295,0.14073469387755105,0.14612765957446811,0.15200000000000002,0.15841860465116281,0.16546341463414638,0.17323076923076924,0.18183783783783786,0.19142857142857145]
[null,"Process 3 * X2",null,"Process 4","GP F2F after GP Alt-Con",{"$f":"F27*(1-F14)","v":0.16128000000000001},null,null,null,null,null,{"$f":"L27*(1-L14)","v":0.13679127272727271},0.14169962264150945,0.14699294117647058,0.15271836734693875,0.15893106382978722,0.16569600000000001,0.17309023255813957,0.18120585365853661,0.19015384615384615,0.2000691891891892,0.2111177142857143,0.13498472727272726,0.13982490566037736,0.14504470588235294,0.15069061224489796,0.15681702127659575,0.16348799999999999,0.17077953488372097,0.17878243902439026,0.18760615384615381,0.19738378378378379,0.20827885714285715,0.13317818181818181,0.13795018867924527,0.1430964705882353,0.14866285714285715,0.15470297872340427,0.16128000000000001,0.16846883720930234,0.17635902439024392,0.18505846153846151,0.19469837837837839,0.20544000000000001,9.7047272727272732E-2,0.10045584905660375,0.10413176470588235,0.10810775510204081,0.11242212765957448,0.11711999999999999,0.12225488372093024,0.1278907317073171,0.13410461538461538,0.14099027027027028,0.14866285714285718,6.0916363636363637E-2,6.2961509433962268E-2,6.5167058823529411E-2,6.7552653061224502E-2,7.0141276595744692E-2,7.2960000000000011E-2,7.6040930232558146E-2,7.9422439024390265E-2,8.3150769230769236E-2,8.7282162162162169E-2,9.1885714285714293E-2]
[]
[null,null,null,null,"Minutes per patient contact - alternative route: adjusted for cost"]
[null,null,null,"Process 0","Workload cost managed through digital first",{"$f":"F25*F11","v":4},null,null,null,null,null,{"$f":"L25*L11","v":3.2727272727272725},3.3962264150943393,3.5294117647058822,3.6734693877551021,3.8297872340425534,4,4.1860465116279073,4.3902439024390247,4.615384615384615,4.8648648648648649,5.1428571428571432,3.2727272727272725,3.3962264150943393,3.5294117647058822,3.6734693877551021,3.8297872340425534,4,4.1860465116279073,4.3902439024390247,4.615384615384615,4.8648648648648649,5.1428571428571432,3.2727272727272725,3.3962264150943393,3.5294117647058822,3.6734693877551021,3.8297872340425534,4,4.1860465116279073,4.3902439024390247,4.615384615384615,4.8648648648648649,{"$f":"AR25*AR11","v":5.1428571428571432},3.2727272727272725,3.3962264150943393,3.5294117647058822,3.6734693877551021,3.8297872340425534,4,4.1860465116279073,4.3902439024390247,4.615384615384615,4.8648648648648649,5.1428571428571432,3.2727272727272725,3.3962264150943393,3.5294117647058822,3.6734693877551021,3.8297872340425534,4,4.1860465116279073,4.3902439024390247,4.615384615384615,4.8648648648648649,5.1428571428571432]
[null,null,null,"Process 1"," workload cost managed through GP f2f as first real time contact by doctor",{"$f":"F26*F17","v":4.1760000000000002},null,null,null,null,null,{"$f":"L26*L17","v":3.6369818181818179},3.7450188679245282,3.8615294117647054,3.9875510204081626,4.1242978723404251,4.2732000000000001,4.4359534883720935,4.6145853658536584,4.8115384615384613,5.0297837837837838,5.2729714285714291,3.5972181818181812,3.7037547169811318,3.8186470588235295,3.9429183673469383,4.0777659574468084,4.2245999999999997,4.3850930232558145,4.5612439024390241,4.755461538461538,4.9706756756756754,5.2104857142857153,3.557454545454545,3.6624905660377349,3.7757647058823522,3.8982857142857141,4.0312340425531916,4.1760000000000002,4.3342325581395347,4.5079024390243898,4.6993846153846146,4.9115675675675678,{"$f":"AR26*AR17","v":5.1480000000000006},2.7621818181818183,2.8372075471698111,2.9181176470588235,3.0056326530612245,3.100595744680851,3.2039999999999997,3.3170232558139534,3.4410731707317073,3.5778461538461537,3.7294054054054055,3.8982857142857146,1.9669090909090909,2.0119245283018863,2.0604705882352943,2.1129795918367349,2.1699574468085112,2.2320000000000002,2.2998139534883721,2.3742439024390247,2.4563076923076923,2.5472432432432432,2.648571428571429]
[null,null,null,"Process 3","workload cost managed through tele or video as first real time contact (always GP)",{"$f":"F27*F15","v":1.6800000000000002},null,null,null,null,null,{"$f":"L27*L15","v":1.4249090909090909},1.4760377358490566,1.5311764705882354,1.5908163265306121,1.6555319148936172,1.726,1.8030232558139538,1.8875609756097564,1.9807692307692306,2.0840540540540542,2.1991428571428573,1.4060909090909091,1.4565094339622642,1.5108823529411766,1.5696938775510205,1.6335106382978724,1.7030000000000001,1.7789534883720934,1.8623170731707319,1.954230769230769,2.0560810810810812,2.1695714285714289,1.3872727272727272,1.4369811320754717,1.4905882352941178,1.5485714285714285,1.6114893617021278,1.6800000000000002,1.7548837209302326,1.8370731707317076,1.9276923076923076,2.0281081081081083,{"$f":"AR27*AR15","v":2.14},1.010909090909091,1.0464150943396224,1.0847058823529412,1.1261224489795918,1.1710638297872342,1.22,1.2734883720930235,1.3321951219512198,1.3969230769230769,1.468648648648649,1.5485714285714289,0.63454545454545452,0.65584905660377357,0.67882352941176483,0.70367346938775532,0.73063829787234047,0.76000000000000012,0.7920930232558141,0.82731707317073189,0.86615384615384627,0.90918918918918923,0.9571428571428573]
[null,null,null,"Process 4","workload cost through f2f following new route by doctor",{"$f":"F28*F17","v":1.4515200000000001},null,null,null,null,null,{"$f":"L28*L17","v":1.2311214545454543},1.2752966037735851,1.3229364705882352,1.3744653061224488,1.4303795744680849,1.4912640000000001,1.5578120930232562,1.6308526829268295,1.7113846153846153,1.8006227027027029,1.9000594285714287,1.2148625454545452,1.2584241509433962,1.3054023529411765,1.3562155102040816,1.4113531914893618,1.471392,1.5370158139534886,1.6090419512195122,1.6884553846153842,1.7764540540540541,1.8745097142857143,1.1986036363636363,1.2415516981132075,1.2878682352941178,1.3379657142857144,1.3923268085106384,1.4515200000000001,1.5162195348837211,1.5872312195121954,1.6655261538461534,1.7522854054054056,{"$f":"AR28*AR17","v":1.8489600000000002},0.87342545454545462,0.90410264150943376,0.9371858823529412,0.9729697959183673,1.0117991489361702,1.0540799999999999,1.1002939534883722,1.1510165853658538,1.2069415384615385,1.2689124324324326,1.3379657142857146,0.54824727272727269,0.56665358490566042,0.58650352941176465,0.6079738775510205,0.63127148936170219,0.65664000000000011,0.68436837209302337,0.7148019512195124,0.74835692307692314,0.78553945945945958,0.82697142857142869]
[]
[null,null,null,null,"Total minutes, adjusted for cost",{"$f":"SUM(F31:F35)","v":11.30752},{"$f":"SUM(G31:G35)","v":0},{"$f":"SUM(H31:H35)","v":0},{"$f":"SUM(I31:I35)","v":0},{"$f":"SUM(J31:J35)","v":0},null,{"$f":"SUM(L31:L35)","v":9.5657396363636344},9.8925796226415095,10.245054117647058,10.626302040816325,11.039996595744679,11.490463999999999,11.982835348837211,12.523242926829269,13.119076923076921,13.779325405405405,14.515030857142857,9.4908989090909071,9.8149147169811322,10.164343529411765,10.542297142857144,10.952417021276595,11.398991999999998,11.887108837209304,12.422846829268293,13.013532307692305,13.668075675675675,14.397424000000003,9.4160581818181797,9.7372498113207531,10.08363294117647,10.458292244897958,10.864837446808512,11.30752,11.791382325581395,12.322450731707319,12.907987692307691,13.556825945945947,14.279817142857144,7.9192436363636363,8.1839516981132068,8.469421176470588,8.7781942857142852,9.113245957446809,9.4780799999999985,9.8768520930232562,10.314528780487805,10.797095384615385,11.331831351351353,11.927680000000002,6.4224290909090911,6.6306535849056605,6.8552094117647053,7.0980963265306132,7.3616544680851073,7.6486400000000003,7.9623218604651163,8.3066068292682935,8.6862030769230767,9.1068367567567563,9.5755428571428585]
[]
[null,null,null,null,"Conventional Consultation Variables"]
[null,null,null,null,{"$f":"\"Proportion of conventional GP consultations who have telephone first\"","v":"Proportion of conventional GP consultations who have telephone first"},{"$f":"'Upper and Lower Limits'!P5","v":0.14000000000000001},{"$f":"'Upper and Lower Limits'!Q5","v":0.14000000000000001},{"$f":"'Upper and Lower Limits'!R5","v":0.14000000000000001},{"$f":"$F39-(($F39-$G39)/2)","v":0.14000000000000001},{"$f":"$F39+(($H39-$F39)/2)","v":0.14000000000000001},{"$f":"(H39-G39)/10","v":0},{"$f":"IF($D39=\"X\",($G39+($K39*(L$7-1))),IF($D39=\"S\",($G39),$F39))","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,{"$f":"IF($D39=\"X\",($G39+($K39*(W$7-1))),IF($D39=\"S\",($I39),$F39))","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,{"$f":"IF($D39=\"X\",($G39+($K39*(AH$7-1))),IF($D39=\"S\",($F39),$F39))","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,{"$f":"IF($D39=\"X\",($G39+($K39*(AS$7-1))),IF($D39=\"S\",($J39),$F39))","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,{"$f":"IF($D39=\"X\",($G39+($K39*(BD$7-1))),IF($D39=\"S\",($H39),$F39))","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[null,null,null,{"$f":"IF(E40=X_axis_txt,\"X\", IF(E40=legend_txt,\"S\",\"\"))","v":""},{"$f":"IF(AltCon_txt='Upper and Lower Limits'!$D$14,'Sensitivity Analysis'!E15,\"Time on telephone call\")","v":"Time on telephone call"},{"$f":"'Upper and Lower Limits'!P8","v":5},{"$f":"'Upper and Lower Limits'!Q8","v":4},{"$f":"'Upper and Lower Limits'!R8","v":6},4.5,5.5,{"$f":"(H40-G40)/10","v":0.2},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[null,null,null,"",{"$f":"IF(AltCon_txt='Upper and Lower Limits'!$D$14,E14,\"Percent conventional phone calls managed without further assessment\")","v":"Percent conventional phone calls managed without further assessment"},{"$f":"'Upper and Lower Limits'!P6","v":0.52},{"$f":"'Upper and Lower Limits'!Q6","v":0.4},{"$f":"'Upper and Lower Limits'!R6","v":0.9},{"$f":"$F41-(($F41-$G41)/2)","v":0.46},{"$f":"$F41+(($H41-$F41)/2)","v":0.71},{"$f":"(H41-G41)/10","v":0.05},0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52,0.52]
[null,null,null,null,{"$f":"E17","v":"GP F2F time"},{"$f":"F17","v":9},{"$f":"G17","v":9},{"$f":"H17","v":9},9,9,{"$f":"(H42-G42)/10","v":0},9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]
[]
[]
[null,null,null,null,"conventional route (telephone as exception)"]
[null,"Always zero for conventional",null,"Process 1","% going through digital triage"]
[null,null,null,"Process 2","proportion managed through conventional route by doctor",{"$f":"(1-F39)","v":0.86},{"$f":"(1-G39)","v":0.86},{"$f":"(1-H39)","v":0.86},{"$f":"(1-I39)","v":0.86},{"$f":"(1-J39)","v":0.86},null,{"$f":"(1-L39)","v":0.86},0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86]
[null,null,null,"Process 3","Proportion managed through new route (always GP)",{"$f":"F39","v":0.14000000000000001},{"$f":"G39","v":0.14000000000000001},{"$f":"H39","v":0.14000000000000001},{"$f":"I39","v":0.14000000000000001},{"$f":"J39","v":0.14000000000000001},null,{"$f":"L39","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[null,null,null,"Process 4","proportion managed through f2f following telephone  by doctor (or following nurse consultation)",{"$f":"F48*(1-F41)","v":6.720000000000001E-2},{"$f":"G48*(1-G41)","v":8.4000000000000005E-2},{"$f":"H48*(1-H41)","v":1.3999999999999999E-2},{"$f":"I48*(1-I41)","v":7.5600000000000014E-2},{"$f":"J48*(1-J41)","v":4.0600000000000011E-2},null,{"$f":"L48*(1-L41)","v":6.720000000000001E-2},6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2,6.720000000000001E-2]
[]
[]
[null,null,null,null,"Minutes per patient contact - conventional route: adjusted for cost"]
[null,null,null,"Process 0","% going through digital triage"]
[null,null,null,"Process 1","proportion managed through conventional route by doctor",{"$f":"F47*F42","v":7.74},{"$f":"G47*G42","v":7.74},7.74,7.74,7.74,null,{"$f":"L47*L42","v":7.74},7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74,7.74]
[null,null,null,"Process 3","Proportion managed through new route (always GP)",{"$f":"F48*F40","v":0.70000000000000007},{"$f":"G48*G40","v":0.56000000000000005},0.84000000000000008,0.63000000000000012,0.77,null,{"$f":"L48*L40","v":0.70000000000000007},0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007,0.70000000000000007]
[null,null,null,"Process 4","proportion managed through f2f following new route by doctor",{"$f":"F49*F42","v":0.60480000000000012},{"$f":"G49*G42","v":0.75600000000000001},0.126,0.68040000000000012,0.36540000000000011,null,{"$f":"L49*L42","v":0.60480000000000012},0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012,0.60480000000000012]
[]
[null,null,null,null,"Total minutes of conventional, without any additional access inflation",{"$f":"SUM(F54:F56)","v":9.0448000000000004},{"$f":"SUM(G54:G56)","v":9.0560000000000009},8.7059999999999995,9.0504000000000016,8.8753999999999991,{"$f":"SUM(K54:K56)","v":0},9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004,9.0448000000000004]
[]
[null,null,null,null,"workload cost of new model as % of conventional",{"$f":"F36/F58","v":1.2501680523615779},{"$f":"G36/G58","v":0},{"$f":"H36/H58","v":0},{"$f":"I36/I58","v":0},{"$f":"J36/J58","v":0},null,{"$f":"L36/L58","v":1.0575954842963509},1.0937311629490436,1.1327010124764569,1.1748520742101898,1.2205904603467936,1.2703944808066512,1.3248314334023097,1.3845793082024223,1.4504551701615205,1.5234527469270083,1.6047929038942659,1.0493210362960934,1.0851444716280219,1.1237775881624541,1.1655644284956157,1.2109075956656417,1.2602812665841143,1.3142478371229107,1.3734794389337843,1.4387860768278242,1.5111528917914907,1.5917901998938619,1.0410465882958362,1.0765577803069999,1.114854163848451,1.1562767827810407,1.2012247309844895,1.2501680523615779,1.3036642408435117,1.3623795696651466,1.4271169834941282,1.4988530366559731,1.5787874958934573,0.87555762829069028,0.90482395388656534,0.93638567756839153,0.9705238684895503,1.0075674373614463,1.0479037679108436,1.0919923152555342,1.1403821842923896,1.1937351168202044,1.2528559339456209,1.3187334158853707,0.71006866828554427,0.73309012746613089,0.75791719128833202,0.78477095419805998,0.81391014373840298,0.84563948346010964,0.88032038966755655,0.91838479891963265,0.96035325014628037,1.0068588312352684,1.0586793358772839]
[null,null,null,null,null,{"$f":"F60-1","v":0.25016805236157791},null,null,null,null,null,"s=lower estimate",null,null,null,null,null,null,null,null,null,null,"s=lower mid estimate",null,null,null,null,null,null,null,null,null,null,"s=base case estimate",null,null,null,null,null,null,null,null,null,null,"s=upper mid",null,null,null,null,null,null,null,null,null,null,"s=upper"]
[null,null,null,null,null,null,"X axis"]
[null,null,null,null,null,null,null,9,10,11,12,13,14,15,16,17,18,19]
[null,null,null,null,"data series lines",null,null,{"$f":"VLOOKUP(\"X\",$D$7:$W$17,H63,FALSE)","v":-0.1},-6.0000000000000005E-2,-2.0000000000000004E-2,1.999999999999999E-2,0.06,0.1,0.13999999999999999,0.18000000000000002,0.22,0.26,0.30000000000000004]
[null,null,null,null,{"$f":"VLOOKUP(\"S\",$D$7:$W$17,2,FALSE)","v":"e-consult completion rate"},"lower estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,4,FALSE)","v":0.28000000000000003},{"$f":"L60","v":1.0575954842963509},{"$f":"M60","v":1.0937311629490436},{"$f":"N60","v":1.1327010124764569},{"$f":"O60","v":1.1748520742101898},{"$f":"P60","v":1.2205904603467936},{"$f":"Q60","v":1.2703944808066512},{"$f":"R60","v":1.3248314334023097},{"$f":"S60","v":1.3845793082024223},{"$f":"T60","v":1.4504551701615205},1.5234527469270083,1.6047929038942659]
[null,null,null,null,null,"lower mid",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,6,FALSE)","v":0.29000000000000004},{"$f":"W60","v":1.0493210362960934},{"$f":"X60","v":1.0851444716280219},{"$f":"Y60","v":1.1237775881624541},{"$f":"Z60","v":1.1655644284956157},{"$f":"AA60","v":1.2109075956656417},1.2602812665841143,1.3142478371229107,1.3734794389337843,1.4387860768278242,{"$f":"AF60","v":1.5111528917914907},1.5917901998938619]
[null,null,null,null,null,"baseline estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,3,FALSE)","v":0.3},{"$f":"AH60","v":1.0410465882958362},1.0765577803069999,{"$f":"AJ60","v":1.114854163848451},{"$f":"AK60","v":1.1562767827810407},{"$f":"AL60","v":1.2012247309844895},1.2501680523615779,1.3036642408435117,1.3623795696651466,1.4271169834941282,{"$f":"AQ60","v":1.4988530366559731},1.5787874958934573]
[null,null,null,null,null,"upper mid",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,7,FALSE)","v":0.5},{"$f":"AS60","v":0.87555762829069028},{"$f":"AT60","v":0.90482395388656534},{"$f":"AU60","v":0.93638567756839153},{"$f":"AV60","v":0.9705238684895503},{"$f":"AW60","v":1.0075674373614463},1.0479037679108436,1.0919923152555342,1.1403821842923896,1.1937351168202044,{"$f":"BB60","v":1.2528559339456209},1.3187334158853707]
[null,null,null,null,null,"upper estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,5,FALSE)","v":0.7},{"$f":"BD60","v":0.71006866828554427},{"$f":"BE60","v":0.73309012746613089},{"$f":"BF60","v":0.75791719128833202},{"$f":"BG60","v":0.78477095419805998},{"$f":"BH60","v":0.81391014373840298},0.84563948346010964,0.88032038966755655,0.91838479891963265,0.96035325014628037,{"$f":"BM60","v":1.0068588312352684},1.0586793358772839]
[null,null,null,null,"highlight base case on x axis"]
[null,null,null,null,"Legend format",{"$f":"INDEX($C$8:$C$17,MATCH(\"S\",$D$8:$D$17,0),1)","v":"percent"}]
[null,null,null,null,"X-axis format",{"$f":"INDEX($C$8:$C$17,MATCH(\"X\",$D$8:$D$17,0),1)","v":"percent"}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H64","v":-0.1},{"$f":"I64","v":-6.0000000000000005E-2},-2.0000000000000004E-2,1.999999999999999E-2,0.06,0.1,0.13999999999999999,0.18000000000000002,0.22,0.26,0.30000000000000004]
[null,null,null,null,null,"lower estimate",{"$f":"G65","v":0.28000000000000003},{"$f":"H65-1","v":5.7595484296350863E-2},{"$f":"I65-1","v":9.37311629490436E-2},0.13270101247645694,0.17485207421018978,0.22059046034679364,0.27039448080665118,0.32483143340230969,0.38457930820242225,0.45045517016152048,0.52345274692700827,0.60479290389426588]
[null,null,null,null,null,"lower mid",{"$f":"G66","v":0.29000000000000004},{"$f":"H66-1","v":4.9321036296093412E-2},8.5144471628021856E-2,0.1237775881624541,0.1655644284956157,0.21090759566564166,0.26028126658411432,0.31424783712291071,0.37347943893378432,0.43878607682782422,0.5111528917914907,0.59179019989386195]
[null,null,null,null,null,"baseline estimate",{"$f":"G67","v":0.3},4.1046588295836184E-2,7.655778030699989E-2,0.11485416384845104,0.15627678278104074,0.20122473098448945,0.25016805236157791,0.30366424084351173,0.36237956966514662,0.42711698349412819,0.49885303665597314,0.57878749589345735]
[null,null,null,null,null,"upper mid",{"$f":"G68","v":0.5},-0.12444237170930972,-9.5176046113434665E-2,-6.3614322431608472E-2,-2.9476131510449699E-2,7.567437361446272E-3,4.7903767910843609E-2,9.1992315255534196E-2,0.14038218429238958,0.19373511682020439,0.25285593394562089,0.31873341588537074]
[null,null,null,null,null,"upper estimate",{"$f":"G69","v":0.7},-0.28993133171445573,-0.26690987253386911,-0.24208280871166798,-0.21522904580194002,-0.18608985626159702,-0.15436051653989036,-0.11967961033244345,-8.161520108036735E-2,-3.9646749853719632E-2,6.8588312352684255E-3,5.8679335877283911E-2]

{"sheet":"Output - Chart","index":3,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'User Inputs'!C2","v":"Which access route do you wish to model?  (select drop-down)"},{"$f":"AltCon_txt & \" compared to conventional: Impact on primary care workload\"","v":"e-consult first compared to conventional: Impact on primary care workload"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'User Inputs'!C4","v":"Select the x-axis for the chart (e-consult first variables in blue)"},{"$f":"X_axis_txt","v":"e-consult supply-related demand"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'User Inputs'!C5","v":"Select the legend for the chart (e-consult first variables in blue)"},{"$f":"legend_txt","v":"e-consult completion rate"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Y axis variable","Workload compared to conventional care"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Workload compared to conventional care, value",{"$f":"'Sensitivity Analysis'!F61","v":0.25016805236157791}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"base case variable and value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O3","v":"e-consult supply-related demand"},{"$f":"'Sensitivity Analysis'!BO19","v":0.1}]