{"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,"Phone via e-consult"]
[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 supply-related demand"]
[]
[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,1,1,0.9]
[null,null,"Completion rate: % of digital consultations completed without needing a subsequent consultation",null,0.2,0.8,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",1]
[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 additional demand compared with a conventional appointment system",null,0,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":1},1E-4,1,{"$f":"'User Inputs'!F8","v":1},1E-4,1,{"$f":"'User Inputs'!G8","v":0.9},1E-4,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":1},1E-4,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.2},0.05,0.7,{"$f":"'User Inputs'!F9","v":0.8},0.1,0.9,{"$f":"'User Inputs'!G9","v":0.65},0.1,0.9,{"$f":"J6","v":0.8},{"$f":"K6","v":0.1},{"$f":"L6","v":0.9},"e-consult completion rate",0.8,0.1,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":1},0.3,1,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},2,6,{"$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},-0.1,0.2,{"$f":"'User Inputs'!F12","v":0},-0.1,0.2,{"$f":"'User Inputs'!G12","v":0},-0.1,0.2,0,0,0,"e-consult supply-related demand",0,-0.1,0.2]
["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",1,1,0.9]
[null,null,null,"No",null,"X2",0.2,0.8,0.65]
[null,null,null,null,null,"X1(e) ",1]
[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,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":1},{"$f":"'Upper and Lower Limits'!H5","v":1E-4},{"$f":"'Upper and Lower Limits'!I5","v":1},{"$f":"$F8-(($F8-$G8)/2)","v":0.50004999999999999},{"$f":"$F8+(($H8-$F8)/2)","v":1},{"$f":"(H8-G8)/10","v":9.9989999999999996E-2},{"$f":"IF($D8=\"X\",($G8+($K8*(L$7-1))),IF($D8=\"S\",($G8),$F8))","v":1},1,1,1,1,1,1,1,1,1,1,{"$f":"IF($D8=\"X\",($G8+($K8*(W$7-1))),IF($D8=\"S\",($I8),$F8))","v":1},1,1,1,1,1,1,1,1,1,1,{"$f":"IF($D8=\"X\",($G8+($K8*(AH$7-1))),IF($D8=\"S\",($F8),$F8))","v":1},1,1,1,1,1,1,1,1,1,1,{"$f":"IF($D8=\"X\",($G8+($K8*(AS$7-1))),IF($D8=\"S\",($J8),$F8))","v":1},1,1,1,1,1,1,1,1,1,1,{"$f":"IF($D8=\"X\",($G8+($K8*(BD$7-1))),IF($D8=\"S\",($H8),$F8))","v":1},1,1,1,1,1,1,1,1,1,1,{"$f":"IF($D8=\"X\",F8,)","v":0}]
["E2","e-consulation completion rate","percent","",{"$f":"'Upper and Lower Limits'!S6","v":"e-consult completion rate"},{"$f":"'Upper and Lower Limits'!G6","v":0.2},{"$f":"'Upper and Lower Limits'!H6","v":0.05},{"$f":"'Upper and Lower Limits'!I6","v":0.7},0.125,0.44999999999999996,6.4999999999999988E-2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,{"$f":"IF($D9=\"X\",F9,)","v":0}]
["X1(e)",null,"percent","X",{"$f":"'Upper and Lower Limits'!S7","v":"Phone via e-consult"},{"$f":"'Upper and Lower Limits'!G7","v":1},{"$f":"'Upper and Lower Limits'!H7","v":0.3},{"$f":"'Upper and Lower Limits'!I7","v":1},0.65,1,6.9999999999999993E-2,0.3,0.37,0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1,0.3,0.37,0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1,0.3,0.37,0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1,0.3,0.37,0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1,0.3,0.37,0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1,1]
["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":2},{"$f":"'Upper and Lower Limits'!I8","v":6},{"$f":"$F11-(($F11-$G11)/2)","v":3},{"$f":"$F11+(($H11-$F11)/2)","v":5},{"$f":"(H11-G11)/10","v":0.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,4,{"$f":"IF($D11=\"X\",F11,)","v":0}]
["E4","e-consulation completion rate","percent","S",{"$f":"'Upper and Lower Limits'!S9","v":"e-consult supply-related demand"},{"$f":"'Upper and Lower Limits'!G9","v":0},{"$f":"'Upper and Lower Limits'!H9","v":-0.1},{"$f":"'Upper and Lower Limits'!I9","v":0.2},-0.05,0.1,3.0000000000000006E-2,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,0,0,0,0,0,0,0,0,0,0,0,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0]
["X1","Alt-Con access rate","percent","",{"$f":"'Upper and Lower Limits'!F5","v":"Tel/video Access Rate"},{"$f":"'Upper and Lower Limits'!T5","v":1},{"$f":"'Upper and Lower Limits'!U5","v":1E-4},{"$f":"'Upper and Lower Limits'!V5","v":1},0.50004999999999999,1,9.9989999999999996E-2,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,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.8},{"$f":"'Upper and Lower Limits'!U6","v":0.1},{"$f":"'Upper and Lower Limits'!V6","v":0.9},0.45,0.85000000000000009,0.08,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,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.2},-0.05,0.1,3.0000000000000006E-2,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},0.90909090909090906,1.25,0.95238095238095233,1.1111111111111112,1.0309278350515465,{"$f":"1/(1-L12)","v":0.90909090909090906},0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,1,1,1,1,1,1,1,1,1,1,1,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25]
[null,null,null,null,"tel/video: Supply induced demand compared with original",{"$f":"1/(1-(F16))","v":1},0.90909090909090906,1.25,0.95238095238095233,1.1111111111111112,1.0309278350515465,{"$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":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},{"$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.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!I18,'Sensitivity Analysis'!I19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!J18,'Sensitivity Analysis'!J19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!K18,'Sensitivity Analysis'!K19)","v":1.0309278350515465},{"$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.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!N18,'Sensitivity Analysis'!N19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!O18,'Sensitivity Analysis'!O19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!P18,'Sensitivity Analysis'!P19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Q18,'Sensitivity Analysis'!Q19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!R18,'Sensitivity Analysis'!R19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!S18,'Sensitivity Analysis'!S19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!T18,'Sensitivity Analysis'!T19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!U18,'Sensitivity Analysis'!U19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!V18,'Sensitivity Analysis'!V19)","v":0.90909090909090906},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!W18,'Sensitivity Analysis'!W19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!X18,'Sensitivity Analysis'!X19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Y18,'Sensitivity Analysis'!Y19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Z18,'Sensitivity Analysis'!Z19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AA18,'Sensitivity Analysis'!AA19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AB18,'Sensitivity Analysis'!AB19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AC18,'Sensitivity Analysis'!AC19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AD18,'Sensitivity Analysis'!AD19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AE18,'Sensitivity Analysis'!AE19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AF18,'Sensitivity Analysis'!AF19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AG18,'Sensitivity Analysis'!AG19)","v":0.95238095238095233},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AH18,'Sensitivity Analysis'!AH19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AI18,'Sensitivity Analysis'!AI19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AJ18,'Sensitivity Analysis'!AJ19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AK18,'Sensitivity Analysis'!AK19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AL18,'Sensitivity Analysis'!AL19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AM18,'Sensitivity Analysis'!AM19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AN18,'Sensitivity Analysis'!AN19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AO18,'Sensitivity Analysis'!AO19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AP18,'Sensitivity Analysis'!AP19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AQ18,'Sensitivity Analysis'!AQ19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AR18,'Sensitivity Analysis'!AR19)","v":1},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AS18,'Sensitivity Analysis'!AS19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AT18,'Sensitivity Analysis'!AT19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AU18,'Sensitivity Analysis'!AU19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AV18,'Sensitivity Analysis'!AV19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AW18,'Sensitivity Analysis'!AW19)","v":1.1111111111111112},{"$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.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AZ18,'Sensitivity Analysis'!AZ19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BA18,'Sensitivity Analysis'!BA19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BB18,'Sensitivity Analysis'!BB19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BC18,'Sensitivity Analysis'!BC19)","v":1.1111111111111112},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BD18,'Sensitivity Analysis'!BD19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BE18,'Sensitivity Analysis'!BE19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BF18,'Sensitivity Analysis'!BF19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BG18,'Sensitivity Analysis'!BG19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BH18,'Sensitivity Analysis'!BH19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BI18,'Sensitivity Analysis'!BI19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BJ18,'Sensitivity Analysis'!BJ19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BK18,'Sensitivity Analysis'!BK19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BL18,'Sensitivity Analysis'!BL19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BM18,'Sensitivity Analysis'!BM19)","v":1.25},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BN18,'Sensitivity Analysis'!BN19)","v":1.25}]
[]
[]
[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.90909090909090906},0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,0.95238095238095233,1,1,1,1,1,1,1,1,1,1,{"$f":"IF(AltCon_txt=\"e-consult first\",AR21*AR8,0)","v":1},1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.1111111111111112,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25]
[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},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.50909090909090904},0.45818181818181819,0.40727272727272734,0.35636363636363638,0.30545454545454548,0.25454545454545463,0.20363636363636367,0.15272727272727279,0.1018181818181819,5.0909090909090952E-2,0,0.53333333333333321,0.48,0.42666666666666669,0.37333333333333329,0.32,0.26666666666666672,0.21333333333333335,0.16000000000000006,0.10666666666666676,5.3333333333333378E-2,0,0.55999999999999994,0.504,0.44800000000000006,0.39200000000000002,0.33600000000000008,0.28000000000000008,0.22400000000000003,0.16800000000000007,0.1120000000000001,5.600000000000005E-2,{"$f":"IF(AltCon_txt=\"e-consult first\",(((1-AR8)*(1-AR39))+(AR8*AR21*(1-AR9)*(1-AR10))),(1-AR13))","v":0},0.62222222222222223,0.56000000000000005,0.49777777777777787,0.43555555555555558,0.37333333333333341,0.31111111111111123,0.24888888888888894,0.18666666666666676,0.12444444444444457,6.2222222222222283E-2,0,0.7,0.63,0.56000000000000005,0.49,0.42000000000000004,0.35000000000000009,0.28000000000000003,0.21000000000000008,0.14000000000000012,7.0000000000000062E-2,0]
[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.8},null,null,null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",((1-L8)*L39)+(L8*L21*(1-L9)*L10),(L21*L13))","v":0.21818181818181817},0.2690909090909091,0.31999999999999995,0.37090909090909091,0.42181818181818181,0.47272727272727266,0.52363636363636368,0.57454545454545447,0.62545454545454537,0.67636363636363639,0.72727272727272729,0.22857142857142854,0.28190476190476188,0.33523809523809517,0.38857142857142857,0.44190476190476186,0.49523809523809514,0.54857142857142849,0.60190476190476183,0.65523809523809506,0.70857142857142852,0.76190476190476186,0.24,0.29599999999999999,0.35199999999999998,0.40800000000000003,0.46399999999999997,0.51999999999999991,0.57599999999999996,0.63200000000000001,0.68799999999999994,0.74399999999999999,{"$f":"IF(AltCon_txt=\"e-consult first\",((1-AR8)*AR39)+(AR8*AR21*(1-AR9)*AR10),(AR21*AR13))","v":0.8},0.26666666666666666,0.3288888888888889,0.39111111111111108,0.45333333333333337,0.51555555555555554,0.57777777777777772,0.64,0.70222222222222219,0.76444444444444437,0.82666666666666666,0.88888888888888895,0.3,0.37,0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1]
[null,"Process 3 * X2",null,"Process 4","GP F2F after GP Alt-Con",{"$f":"F27*(1-F14)","v":0.15999999999999998},null,null,null,null,null,{"$f":"L27*(1-L14)","v":4.3636363636363626E-2},5.3818181818181807E-2,6.3999999999999974E-2,7.4181818181818168E-2,8.4363636363636349E-2,9.4545454545454516E-2,0.10472727272727271,0.11490909090909086,0.12509090909090906,0.13527272727272724,0.14545454545454542,4.57142857142857E-2,5.6380952380952365E-2,6.7047619047619023E-2,7.7714285714285694E-2,8.8380952380952352E-2,9.9047619047619009E-2,0.10971428571428567,0.12038095238095234,0.131047619047619,0.14171428571428568,0.15238095238095234,4.7999999999999987E-2,5.9199999999999982E-2,7.0399999999999976E-2,8.1599999999999992E-2,9.279999999999998E-2,0.10399999999999995,0.11519999999999997,0.12639999999999998,0.13759999999999994,0.14879999999999996,0.15999999999999998,5.3333333333333323E-2,6.5777777777777768E-2,7.8222222222222193E-2,9.0666666666666659E-2,0.10311111111111108,0.11555555555555552,0.12799999999999997,0.1404444444444444,0.15288888888888885,0.1653333333333333,0.17777777777777776,5.9999999999999984E-2,7.3999999999999982E-2,8.7999999999999967E-2,0.10199999999999998,0.11599999999999996,0.12999999999999995,0.14399999999999996,0.15799999999999995,0.17199999999999993,0.18599999999999994,0.19999999999999996]
[]
[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.6363636363636362},3.6363636363636362,3.6363636363636362,3.6363636363636362,3.6363636363636362,3.6363636363636362,3.6363636363636362,3.6363636363636362,3.6363636363636362,3.6363636363636362,3.6363636363636362,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,3.8095238095238093,4,4,4,4,4,4,4,4,4,4,{"$f":"AR25*AR11","v":4},4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,4.4444444444444446,5,5,5,5,5,5,5,5,5,5,5]
[null,null,null,"Process 1"," workload cost managed through GP f2f as first real time contact by doctor",{"$f":"F26*F17","v":0},null,null,null,null,null,{"$f":"L26*L17","v":4.5818181818181811},4.123636363636364,3.665454545454546,3.2072727272727275,2.7490909090909095,2.2909090909090919,1.832727272727273,1.3745454545454552,0.91636363636363716,0.45818181818181858,0,4.7999999999999989,4.32,3.8400000000000003,3.3599999999999994,2.88,2.4000000000000004,1.9200000000000002,1.4400000000000006,0.96000000000000085,0.48000000000000043,0,5.0399999999999991,4.5359999999999996,4.0320000000000009,3.528,3.0240000000000009,2.5200000000000009,2.0160000000000005,1.5120000000000007,1.0080000000000009,0.50400000000000045,{"$f":"AR26*AR17","v":0},5.6,5.0400000000000009,4.4800000000000004,3.9200000000000004,3.3600000000000008,2.8000000000000012,2.2400000000000002,1.6800000000000008,1.120000000000001,0.5600000000000005,0,6.3,5.67,5.0400000000000009,4.41,3.7800000000000002,3.1500000000000008,2.5200000000000005,1.8900000000000006,1.2600000000000011,0.63000000000000056,0]
[null,null,null,"Process 3","workload cost managed through tele or video as first real time contact (always GP)",{"$f":"F27*F15","v":4},null,null,null,null,null,{"$f":"L27*L15","v":1.0909090909090908},1.3454545454545455,1.5999999999999996,1.8545454545454545,2.1090909090909089,2.3636363636363633,2.6181818181818182,2.8727272727272721,3.127272727272727,3.3818181818181818,3.6363636363636367,1.1428571428571428,1.4095238095238094,1.6761904761904758,1.9428571428571428,2.2095238095238092,2.4761904761904758,2.7428571428571424,3.009523809523809,3.2761904761904752,3.5428571428571427,3.8095238095238093,1.2,1.48,1.7599999999999998,2.04,2.3199999999999998,2.5999999999999996,2.88,3.16,3.4399999999999995,3.7199999999999998,{"$f":"AR27*AR15","v":4},1.3333333333333333,1.6444444444444444,1.9555555555555553,2.2666666666666666,2.5777777777777775,2.8888888888888884,3.2,3.5111111111111111,3.822222222222222,4.1333333333333329,4.4444444444444446,1.5,1.85,2.1999999999999997,2.5499999999999998,2.9,3.2499999999999996,3.5999999999999996,3.9499999999999997,4.2999999999999989,4.6499999999999995,5]
[null,null,null,"Process 4","workload cost through f2f following new route by doctor",{"$f":"F28*F17","v":1.4399999999999997},null,null,null,null,null,{"$f":"L28*L17","v":0.39272727272727265},0.48436363636363627,0.57599999999999973,0.66763636363636347,0.7592727272727271,0.85090909090909062,0.94254545454545435,1.0341818181818179,1.1258181818181816,1.2174545454545451,1.3090909090909089,0.41142857142857131,0.50742857142857134,0.6034285714285712,0.69942857142857129,0.79542857142857115,0.89142857142857113,0.98742857142857099,1.083428571428571,1.179428571428571,1.2754285714285711,1.371428571428571,0.43199999999999988,0.53279999999999983,0.63359999999999983,0.73439999999999994,0.83519999999999983,0.93599999999999961,1.0367999999999997,1.1375999999999999,1.2383999999999995,1.3391999999999997,{"$f":"AR28*AR17","v":1.4399999999999997},0.47999999999999993,0.59199999999999986,0.70399999999999974,0.81599999999999995,0.92799999999999971,1.0399999999999996,1.1519999999999997,1.2639999999999996,1.3759999999999997,1.4879999999999998,1.5999999999999999,0.53999999999999981,0.66599999999999981,0.7919999999999997,0.91799999999999982,1.0439999999999996,1.1699999999999995,1.2959999999999996,1.4219999999999995,1.5479999999999994,1.6739999999999995,1.7999999999999996]
[]
[null,null,null,null,"Total minutes, adjusted for cost",{"$f":"SUM(F31:F35)","v":9.44},{"$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.7018181818181812},9.5898181818181811,9.4778181818181828,9.3658181818181827,9.2538181818181808,9.1418181818181807,9.0298181818181806,8.9178181818181823,8.8058181818181822,8.6938181818181821,8.581818181818182,10.163809523809521,10.046476190476191,9.9291428571428568,9.8118095238095222,9.6944761904761894,9.5771428571428565,9.4598095238095237,9.3424761904761908,9.225142857142858,9.1078095238095234,8.9904761904761905,10.671999999999999,10.5488,10.425599999999999,10.302400000000002,10.179200000000002,10.056000000000001,9.9328000000000003,9.8095999999999997,9.686399999999999,9.5632000000000001,9.44,11.857777777777779,11.72088888888889,11.584,11.447111111111111,11.310222222222222,11.173333333333332,11.036444444444443,10.899555555555555,10.762666666666666,10.625777777777778,10.488888888888889,13.34,13.186,13.032,12.878,12.724,12.57,12.416,12.261999999999999,12.108000000000001,11.954000000000001,11.799999999999999]
[]
[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.8},{"$f":"'Upper and Lower Limits'!Q6","v":0.1},{"$f":"'Upper and Lower Limits'!R6","v":0.9},{"$f":"$F41-(($F41-$G41)/2)","v":0.45},{"$f":"$F41+(($H41-$F41)/2)","v":0.85000000000000009},{"$f":"(H41-G41)/10","v":0.08},0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
[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":2.7999999999999997E-2},{"$f":"G48*(1-G41)","v":0.12600000000000003},{"$f":"H48*(1-H41)","v":1.3999999999999999E-2},{"$f":"I48*(1-I41)","v":7.7000000000000013E-2},{"$f":"J48*(1-J41)","v":2.0999999999999991E-2},null,{"$f":"L48*(1-L41)","v":2.7999999999999997E-2},2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-2,2.7999999999999997E-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.252},{"$f":"G49*G42","v":1.1340000000000003},0.126,0.69300000000000006,0.18899999999999992,null,{"$f":"L49*L42","v":0.252},0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252,0.252]
[]
[null,null,null,null,"Total minutes of conventional, without any additional access inflation",{"$f":"SUM(F54:F56)","v":8.6920000000000002},{"$f":"SUM(G54:G56)","v":9.4340000000000011},8.7059999999999995,9.0630000000000006,8.6989999999999998,{"$f":"SUM(K54:K56)","v":0},8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002,8.6920000000000002]
[]
[null,null,null,null,"workload cost of new model as % of conventional",{"$f":"F36/F58","v":1.0860561435803036},{"$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.1161778856210516},1.1032924737480649,1.0904070618750785,1.0775216500020919,1.064636238129105,1.0517508262561184,1.0388654143831317,1.0259800025101453,1.0130945906371585,1.0002091787641718,0.98732376689118517,1.1693292135077682,1.1558302105932112,1.1423312076786536,1.128832204764096,1.1153332018495385,1.1018341989349811,1.0883351960204237,1.0748361931058663,1.0613371901913089,1.0478381872767515,1.0343391843621941,1.2277956741831568,1.2136217211228715,1.1994477680625861,1.1852738150023012,1.1710998619420159,1.1569259088817303,1.142751955821445,1.1285780027611596,1.1144040497008743,1.1002300966405891,1.0860561435803036,1.3642174157590634,1.348468579025413,1.3327197422917625,1.3169709055581122,1.3012220688244618,1.2854732320908113,1.2697243953571609,1.2539755586235106,1.2382267218898604,1.2224778851562099,1.2067290484225597,1.534744592728946,1.5170271514035896,1.4993097100782329,1.4815922687528762,1.4638748274275195,1.4461573861021628,1.4284399447768064,1.4107225034514494,1.393005062126093,1.3752876208007363,1.3575701794753796]
[null,null,null,null,null,{"$f":"F60-1","v":8.6056143580303557E-2},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.3},0.37,0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1]
[null,null,null,null,{"$f":"VLOOKUP(\"S\",$D$7:$W$17,2,FALSE)","v":"e-consult supply-related demand"},"lower estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,4,FALSE)","v":-0.1},{"$f":"L60","v":1.1161778856210516},{"$f":"M60","v":1.1032924737480649},{"$f":"N60","v":1.0904070618750785},{"$f":"O60","v":1.0775216500020919},{"$f":"P60","v":1.064636238129105},{"$f":"Q60","v":1.0517508262561184},{"$f":"R60","v":1.0388654143831317},{"$f":"S60","v":1.0259800025101453},{"$f":"T60","v":1.0130945906371585},1.0002091787641718,0.98732376689118517]
[null,null,null,null,null,"lower mid",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,6,FALSE)","v":-0.05},{"$f":"W60","v":1.1693292135077682},{"$f":"X60","v":1.1558302105932112},{"$f":"Y60","v":1.1423312076786536},{"$f":"Z60","v":1.128832204764096},{"$f":"AA60","v":1.1153332018495385},1.1018341989349811,1.0883351960204237,1.0748361931058663,1.0613371901913089,{"$f":"AF60","v":1.0478381872767515},1.0343391843621941]
[null,null,null,null,null,"baseline estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,3,FALSE)","v":0},{"$f":"AH60","v":1.2277956741831568},1.2136217211228715,{"$f":"AJ60","v":1.1994477680625861},{"$f":"AK60","v":1.1852738150023012},{"$f":"AL60","v":1.1710998619420159},1.1569259088817303,1.142751955821445,1.1285780027611596,1.1144040497008743,{"$f":"AQ60","v":1.1002300966405891},1.0860561435803036]
[null,null,null,null,null,"upper mid",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,7,FALSE)","v":0.1},{"$f":"AS60","v":1.3642174157590634},{"$f":"AT60","v":1.348468579025413},{"$f":"AU60","v":1.3327197422917625},{"$f":"AV60","v":1.3169709055581122},{"$f":"AW60","v":1.3012220688244618},1.2854732320908113,1.2697243953571609,1.2539755586235106,1.2382267218898604,{"$f":"BB60","v":1.2224778851562099},1.2067290484225597]
[null,null,null,null,null,"upper estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,5,FALSE)","v":0.2},{"$f":"BD60","v":1.534744592728946},{"$f":"BE60","v":1.5170271514035896},{"$f":"BF60","v":1.4993097100782329},{"$f":"BG60","v":1.4815922687528762},{"$f":"BH60","v":1.4638748274275195},1.4461573861021628,1.4284399447768064,1.4107225034514494,1.393005062126093,{"$f":"BM60","v":1.3752876208007363},1.3575701794753796]
[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.3},{"$f":"I64","v":0.37},0.43999999999999995,0.51,0.57999999999999996,0.64999999999999991,0.72,0.78999999999999992,0.85999999999999988,0.92999999999999994,1]
[null,null,null,null,null,"lower estimate",{"$f":"G65","v":-0.1},{"$f":"H65-1","v":0.11617788562105158},{"$f":"I65-1","v":0.10329247374806494},9.040706187507852E-2,7.752165000209188E-2,6.4636238129105017E-2,5.1750826256118376E-2,3.8865414383131736E-2,2.5980002510145317E-2,1.3094590637158454E-2,2.0917876417181347E-4,-1.2676233108814827E-2]
[null,null,null,null,null,"lower mid",{"$f":"G66","v":-0.05},{"$f":"H66-1","v":0.16932921350776819},0.15583021059321123,0.14233120767865359,0.12883220476409596,0.11533320184953855,0.10183419893498113,8.8335196020423723E-2,7.4836193105866311E-2,6.1337190191308899E-2,4.7838187276751487E-2,3.4339184362194075E-2]
[null,null,null,null,null,"baseline estimate",{"$f":"G67","v":0},0.22779567418315683,0.21362172112287148,0.19944776806258613,0.18527381500230122,0.17109986194201587,0.1569259088817303,0.14275195582144495,0.1285780027611596,0.11440404970087426,0.10023009664058913,8.6056143580303557E-2]
[null,null,null,null,null,"upper mid",{"$f":"G68","v":0.1},0.36421741575906341,0.34846857902541295,0.33271974229176249,0.31697090555811225,0.30122206882446179,0.28547323209081132,0.26972439535716086,0.25397555862351062,0.23822672188986038,0.22247788515620992,0.20672904842255968]
[null,null,null,null,null,"upper estimate",{"$f":"G69","v":0.2},0.53474459272894603,0.51702715140358957,0.49930971007823288,0.4815922687528762,0.46387482742751951,0.44615738610216282,0.42843994477680636,0.41072250345144945,0.39300506212609299,0.3752876208007363,0.35757017947537961]

{"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":"Phone via e-consult"}]
[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 supply-related demand"}]
[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":8.6056143580303557E-2}]
[]
[]
[]
[]
[]
[]
[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":"Phone via e-consult"},{"$f":"'Sensitivity Analysis'!BO19","v":1}]