{"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.3,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",0.9]
[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.05,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":[[9,3,9,4],[8,3,8,4],[5,0,5,1],[8,0,8,1],[9,0,9,1],[4,0,4,1],[7,0,7,1],[4,3,4,4],[7,3,7,4],[5,3,5,4]]}
[]
[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.3},0.1,0.9,{"$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":0.9},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,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.05},-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.3,0.8,0.65]
[null,null,null,null,null,"X1(e) ",0.9]
[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.05,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.3},{"$f":"'Upper and Lower Limits'!H6","v":0.1},{"$f":"'Upper and Lower Limits'!I6","v":0.9},0.2,0.60000000000000009,0.08,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,{"$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":0.9},{"$f":"'Upper and Lower Limits'!H7","v":0.3},{"$f":"'Upper and Lower Limits'!I7","v":1},0.6,0.95,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,0.9]
["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":5},{"$f":"$F11-(($F11-$G11)/2)","v":3},{"$f":"$F11+(($H11-$F11)/2)","v":4.5},{"$f":"(H11-G11)/10","v":0.3},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.05},{"$f":"'Upper and Lower Limits'!H9","v":-0.1},{"$f":"'Upper and Lower Limits'!I9","v":0.2},-2.5000000000000008E-2,0.125,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,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,-2.5000000000000008E-2,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,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.0526315789473684},0.90909090909090906,1.25,0.97560975609756106,1.1428571428571428,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.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,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":0.9}]
[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.0526315789473684},{"$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.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!J18,'Sensitivity Analysis'!J19)","v":1.1428571428571428},{"$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.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!X18,'Sensitivity Analysis'!X19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Y18,'Sensitivity Analysis'!Y19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!Z18,'Sensitivity Analysis'!Z19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AA18,'Sensitivity Analysis'!AA19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AB18,'Sensitivity Analysis'!AB19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AC18,'Sensitivity Analysis'!AC19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AD18,'Sensitivity Analysis'!AD19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AE18,'Sensitivity Analysis'!AE19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AF18,'Sensitivity Analysis'!AF19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AG18,'Sensitivity Analysis'!AG19)","v":0.97560975609756106},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AH18,'Sensitivity Analysis'!AH19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AI18,'Sensitivity Analysis'!AI19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AJ18,'Sensitivity Analysis'!AJ19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AK18,'Sensitivity Analysis'!AK19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AL18,'Sensitivity Analysis'!AL19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AM18,'Sensitivity Analysis'!AM19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AN18,'Sensitivity Analysis'!AN19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AO18,'Sensitivity Analysis'!AO19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AP18,'Sensitivity Analysis'!AP19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AQ18,'Sensitivity Analysis'!AQ19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AR18,'Sensitivity Analysis'!AR19)","v":1.0526315789473684},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AS18,'Sensitivity Analysis'!AS19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AT18,'Sensitivity Analysis'!AT19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AU18,'Sensitivity Analysis'!AU19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AV18,'Sensitivity Analysis'!AV19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AW18,'Sensitivity Analysis'!AW19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AX18,'Sensitivity Analysis'!AX19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AY18,'Sensitivity Analysis'!AY19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!AZ18,'Sensitivity Analysis'!AZ19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BA18,'Sensitivity Analysis'!BA19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BB18,'Sensitivity Analysis'!BB19)","v":1.1428571428571428},{"$f":"IF(AltCon_txt=\"e-consult first\",'Sensitivity Analysis'!BC18,'Sensitivity Analysis'!BC19)","v":1.1428571428571428},{"$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.0526315789473684},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.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,0.97560975609756106,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,1.0526315789473684,{"$f":"IF(AltCon_txt=\"e-consult first\",AR21*AR8,0)","v":1.0526315789473684},1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,1.1428571428571428,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":7.3684210526315769E-2},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.44545454545454544},0.40090909090909088,0.35636363636363638,0.31181818181818183,0.26727272727272727,0.22272727272727277,0.17818181818181819,0.13363636363636369,8.9090909090909165E-2,4.4545454545454582E-2,0,0.47804878048780486,0.43024390243902444,0.38243902439024396,0.33463414634146343,0.28682926829268296,0.23902439024390251,0.19121951219512198,0.14341463414634154,9.5609756097561074E-2,4.7804878048780537E-2,0,0.51578947368421046,0.46421052631578946,0.41263157894736846,0.36105263157894735,0.30947368421052635,0.25789473684210529,0.20631578947368423,0.1547368421052632,0.10315789473684218,5.1578947368421092E-2,{"$f":"IF(AltCon_txt=\"e-consult first\",(((1-AR8)*(1-AR39))+(AR8*AR21*(1-AR9)*(1-AR10))),(1-AR13))","v":0},0.55999999999999994,0.504,0.44800000000000001,0.39199999999999996,0.33600000000000002,0.28000000000000003,0.224,0.16800000000000004,0.11200000000000009,5.6000000000000043E-2,0,0.61249999999999993,0.55125000000000002,0.49000000000000005,0.42874999999999996,0.36750000000000005,0.30625000000000008,0.24500000000000002,0.18375000000000008,0.12250000000000011,6.1250000000000054E-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.66315789473684206},null,null,null,null,null,{"$f":"IF(AltCon_txt=\"e-consult first\",((1-L8)*L39)+(L8*L21*(1-L9)*L10),(L21*L13))","v":0.19090909090909089},0.23545454545454544,0.27999999999999997,0.32454545454545453,0.36909090909090908,0.41363636363636358,0.45818181818181813,0.50272727272727269,0.54727272727272713,0.5918181818181818,0.63636363636363635,0.20487804878048782,0.2526829268292683,0.30048780487804877,0.3482926829268293,0.39609756097560977,0.44390243902439019,0.49170731707317072,0.53951219512195125,0.58731707317073167,0.6351219512195122,0.68292682926829273,0.22105263157894736,0.27263157894736839,0.32421052631578939,0.37578947368421051,0.42736842105263151,0.47894736842105257,0.53052631578947362,0.58210526315789468,0.63368421052631563,0.6852631578947368,{"$f":"IF(AltCon_txt=\"e-consult first\",((1-AR8)*AR39)+(AR8*AR21*(1-AR9)*AR10),(AR21*AR13))","v":0.73684210526315785},0.23999999999999996,0.29599999999999999,0.35199999999999992,0.40799999999999997,0.46399999999999991,0.51999999999999991,0.57599999999999996,0.6319999999999999,0.68799999999999983,0.74399999999999988,0.79999999999999993,0.26250000000000001,0.32374999999999998,0.38499999999999995,0.44625000000000004,0.50749999999999995,0.56874999999999987,0.63,0.69124999999999992,0.75249999999999995,0.81374999999999997,0.875]
[null,"Process 3 * X2",null,"Process 4","GP F2F after GP Alt-Con",{"$f":"F27*(1-F14)","v":0.13263157894736838},null,null,null,null,null,{"$f":"L27*(1-L14)","v":3.8181818181818171E-2},4.7090909090909079E-2,5.599999999999998E-2,6.4909090909090889E-2,7.3818181818181797E-2,8.2727272727272691E-2,9.1636363636363613E-2,0.10054545454545452,0.1094545454545454,0.11836363636363634,0.12727272727272723,4.0975609756097556E-2,5.0536585365853648E-2,6.009756097560974E-2,6.9658536585365846E-2,7.9219512195121938E-2,8.8780487804878017E-2,9.8341463414634123E-2,0.10790243902439023,0.11746341463414631,0.12702439024390241,0.13658536585365852,4.4210526315789464E-2,5.4526315789473666E-2,6.4842105263157868E-2,7.515789473684209E-2,8.5473684210526285E-2,9.5789473684210494E-2,0.1061052631578947,0.11642105263157891,0.12673684210526309,0.13705263157894734,0.14736842105263154,4.799999999999998E-2,5.9199999999999982E-2,7.0399999999999963E-2,8.1599999999999978E-2,9.2799999999999966E-2,0.10399999999999995,0.11519999999999997,0.12639999999999996,0.13759999999999994,0.14879999999999993,0.15999999999999995,5.2499999999999991E-2,6.4749999999999988E-2,7.6999999999999971E-2,8.9249999999999982E-2,0.10149999999999997,0.11374999999999995,0.12599999999999997,0.13824999999999996,0.15049999999999997,0.16274999999999995,0.17499999999999996]
[]
[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.2105263157894735},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.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,3.9024390243902443,4.2105263157894735,4.2105263157894735,4.2105263157894735,4.2105263157894735,4.2105263157894735,4.2105263157894735,4.2105263157894735,4.2105263157894735,4.2105263157894735,4.2105263157894735,{"$f":"AR25*AR11","v":4.2105263157894735},4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,4.5714285714285712,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.66315789473684195},null,null,null,null,null,{"$f":"L26*L17","v":4.0090909090909088},3.6081818181818179,3.2072727272727275,2.8063636363636366,2.4054545454545453,2.0045454545454549,1.6036363636363637,1.2027272727272733,0.80181818181818243,0.40090909090909121,0,4.3024390243902442,3.8721951219512198,3.4419512195121955,3.0117073170731707,2.5814634146341469,2.1512195121951225,1.7209756097560978,1.2907317073170739,0.86048780487804966,0.43024390243902483,0,4.6421052631578945,4.1778947368421049,3.7136842105263161,3.2494736842105261,2.7852631578947369,2.3210526315789477,1.8568421052631581,1.3926315789473689,0.9284210526315797,0.46421052631578985,{"$f":"AR26*AR17","v":0},5.0399999999999991,4.5359999999999996,4.032,3.5279999999999996,3.024,2.5200000000000005,2.016,1.5120000000000005,1.0080000000000007,0.50400000000000034,0,5.5124999999999993,4.9612499999999997,4.41,3.8587499999999997,3.3075000000000006,2.7562500000000005,2.2050000000000001,1.6537500000000007,1.1025000000000009,0.55125000000000046,0]
[null,null,null,"Process 3","workload cost managed through tele or video as first real time contact (always GP)",{"$f":"F27*F15","v":3.3157894736842102},null,null,null,null,null,{"$f":"L27*L15","v":0.95454545454545447},1.1772727272727272,1.4,1.6227272727272726,1.8454545454545455,2.0681818181818179,2.2909090909090906,2.5136363636363637,2.7363636363636354,2.959090909090909,3.1818181818181817,1.024390243902439,1.2634146341463415,1.5024390243902439,1.7414634146341466,1.9804878048780488,2.219512195121951,2.4585365853658536,2.6975609756097563,2.9365853658536585,3.1756097560975611,3.4146341463414638,1.1052631578947367,1.3631578947368419,1.6210526315789471,1.8789473684210525,2.1368421052631574,2.3947368421052628,2.6526315789473682,2.9105263157894736,3.1684210526315781,3.426315789473684,{"$f":"AR27*AR15","v":3.6842105263157894},1.1999999999999997,1.48,1.7599999999999996,2.04,2.3199999999999994,2.5999999999999996,2.88,3.1599999999999993,3.4399999999999991,3.7199999999999993,3.9999999999999996,1.3125,1.6187499999999999,1.9249999999999998,2.2312500000000002,2.5374999999999996,2.8437499999999991,3.15,3.4562499999999998,3.7624999999999997,4.0687499999999996,4.375]
[null,null,null,"Process 4","workload cost through f2f following new route by doctor",{"$f":"F28*F17","v":1.1936842105263155},null,null,null,null,null,{"$f":"L28*L17","v":0.34363636363636352},0.42381818181818171,0.50399999999999978,0.58418181818181802,0.66436363636363616,0.74454545454545418,0.82472727272727253,0.90490909090909066,0.98509090909090857,1.0652727272727271,1.1454545454545451,0.36878048780487799,0.45482926829268283,0.54087804878048762,0.62692682926829257,0.71297560975609742,0.79902439024390215,0.8850731707317071,0.97112195121951206,1.0571707317073167,1.1432195121951216,1.2292682926829266,0.39789473684210519,0.49073684210526297,0.58357894736842075,0.67642105263157881,0.76926315789473654,0.86210526315789449,0.95494736842105232,1.0477894736842102,1.1406315789473678,1.2334736842105261,{"$f":"AR28*AR17","v":1.3263157894736839},0.43199999999999983,0.53279999999999983,0.63359999999999972,0.73439999999999983,0.83519999999999972,0.93599999999999961,1.0367999999999997,1.1375999999999995,1.2383999999999995,1.3391999999999995,1.4399999999999995,0.47249999999999992,0.58274999999999988,0.69299999999999973,0.8032499999999998,0.91349999999999965,1.0237499999999995,1.1339999999999997,1.2442499999999996,1.3544999999999998,1.4647499999999996,1.5749999999999997]
[]
[null,null,null,null,"Total minutes, adjusted for cost",{"$f":"SUM(F31:F35)","v":9.3831578947368417},{"$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":8.9436363636363634},8.8456363636363644,8.7476363636363637,8.6496363636363647,8.5516363636363621,8.4536363636363632,8.3556363636363642,8.2576363636363634,8.1596363636363627,8.0616363636363637,7.963636363636363,9.5980487804878063,9.4928780487804882,9.387707317073172,9.2825365853658539,9.1773658536585376,9.0721951219512196,8.9670243902439015,8.861853658536587,8.756682926829269,8.6515121951219527,8.5463414634146346,10.355789473684208,10.242315789473684,10.128842105263159,10.01536842105263,9.9018947368421042,9.7884210526315787,9.6749473684210514,9.5614736842105259,9.4479999999999986,9.3345263157894731,9.2210526315789458,11.24342857142857,11.120228571428571,10.99702857142857,10.87382857142857,10.750628571428571,10.62742857142857,10.50422857142857,10.381028571428569,10.257828571428572,10.134628571428571,10.011428571428571,12.297499999999999,12.162749999999999,12.028,11.89325,11.7585,11.623749999999999,11.489000000000001,11.354249999999999,11.2195,11.08475,10.95]
[]
[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.0795165548477728},{"$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.0289503409613856},1.0176756055725225,1.0064008701836589,0.99512613479479572,0.98385139940593214,0.97257666401706888,0.96130192862820574,0.95002719323934226,0.93875245785047889,0.92747772246161564,0.91620298707275227,1.1042393903000236,1.0921396742729508,1.080039958245878,1.0679402422188051,1.0558405261917323,1.0437408101646595,1.0316410941375864,1.0195413781105138,1.007441662083441,0.99534194605636817,0.98324223002929523,1.1914161842710778,1.1783612275050257,1.1653062707389736,1.1522513139729209,1.1391963572068688,1.1261414004408166,1.1130864436747643,1.1000314869087122,1.0869765301426597,1.0739215733766077,1.0608666166105551,1.2935375714943131,1.279363618434028,1.2651896653737424,1.2510157123134571,1.236841759253172,1.2226678061928866,1.2084938531326013,1.1943199000723157,1.1801459470120308,1.1659719939517454,1.1517980408914601,1.4148067188219051,1.3993039576622179,1.3838011965025312,1.368298435342844,1.3527956741831568,1.3372929130234699,1.3217901518637829,1.3062873907040955,1.2907846295444085,1.2752818683847216,1.2597791072250344]
[null,null,null,null,null,{"$f":"F60-1","v":7.9516554847772758E-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.0289503409613856},{"$f":"M60","v":1.0176756055725225},{"$f":"N60","v":1.0064008701836589},{"$f":"O60","v":0.99512613479479572},{"$f":"P60","v":0.98385139940593214},{"$f":"Q60","v":0.97257666401706888},{"$f":"R60","v":0.96130192862820574},{"$f":"S60","v":0.95002719323934226},{"$f":"T60","v":0.93875245785047889},0.92747772246161564,0.91620298707275227]
[null,null,null,null,null,"lower mid",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,6,FALSE)","v":-2.5000000000000008E-2},{"$f":"W60","v":1.1042393903000236},{"$f":"X60","v":1.0921396742729508},{"$f":"Y60","v":1.080039958245878},{"$f":"Z60","v":1.0679402422188051},{"$f":"AA60","v":1.0558405261917323},1.0437408101646595,1.0316410941375864,1.0195413781105138,1.007441662083441,{"$f":"AF60","v":0.99534194605636817},0.98324223002929523]
[null,null,null,null,null,"baseline estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,3,FALSE)","v":0.05},{"$f":"AH60","v":1.1914161842710778},1.1783612275050257,{"$f":"AJ60","v":1.1653062707389736},{"$f":"AK60","v":1.1522513139729209},{"$f":"AL60","v":1.1391963572068688},1.1261414004408166,1.1130864436747643,1.1000314869087122,1.0869765301426597,{"$f":"AQ60","v":1.0739215733766077},1.0608666166105551]
[null,null,null,null,null,"upper mid",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,7,FALSE)","v":0.125},{"$f":"AS60","v":1.2935375714943131},{"$f":"AT60","v":1.279363618434028},{"$f":"AU60","v":1.2651896653737424},{"$f":"AV60","v":1.2510157123134571},{"$f":"AW60","v":1.236841759253172},1.2226678061928866,1.2084938531326013,1.1943199000723157,1.1801459470120308,{"$f":"BB60","v":1.1659719939517454},1.1517980408914601]
[null,null,null,null,null,"upper estimate",{"$f":"VLOOKUP(\"S\",$D$7:$K$17,5,FALSE)","v":0.2},{"$f":"BD60","v":1.4148067188219051},{"$f":"BE60","v":1.3993039576622179},{"$f":"BF60","v":1.3838011965025312},{"$f":"BG60","v":1.368298435342844},{"$f":"BH60","v":1.3527956741831568},1.3372929130234699,1.3217901518637829,1.3062873907040955,1.2907846295444085,{"$f":"BM60","v":1.2752818683847216},1.2597791072250344]
[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":2.8950340961385601E-2},{"$f":"I65-1","v":1.7675605572522457E-2},6.4008701836588688E-3,-4.8738652052042752E-3,-1.6148600594067863E-2,-2.7423335982931119E-2,-3.8698071371794263E-2,-4.997280676065774E-2,-6.1247542149521106E-2,-7.2522277538384361E-2,-8.3797012927247727E-2]
[null,null,null,null,null,"lower mid",{"$f":"G66","v":-2.5000000000000008E-2},{"$f":"H66-1","v":0.1042393903000236},9.2139674272950778E-2,8.0039958245877951E-2,6.7940242218805125E-2,5.5840526191732298E-2,4.3740810164659472E-2,3.1641094137586423E-2,1.9541378110513818E-2,7.4416620834409919E-3,-4.6580539436318347E-3,-1.6757769970704772E-2]
[null,null,null,null,null,"baseline estimate",{"$f":"G67","v":0.05},0.19141618427107776,0.1783612275050257,0.16530627073897364,0.15225131397292091,0.13919635720686885,0.12614140044081656,0.11308644367476428,0.10003148690871222,8.6976530142659714E-2,7.3921573376607652E-2,6.0866616610555146E-2]
[null,null,null,null,null,"upper mid",{"$f":"G68","v":0.125},0.29353757149431314,0.27936361843402802,0.26518966537374244,0.2510157123134571,0.23684175925317197,0.22266780619288662,0.20849385313260127,0.1943199000723157,0.18014594701203079,0.16597199395174544,0.1517980408914601]
[null,null,null,null,null,"upper estimate",{"$f":"G69","v":0.2},0.41480671882190512,0.39930395766221793,0.38380119650253119,0.36829843534284401,0.35279567418315683,0.33729291302346986,0.3217901518637829,0.3062873907040955,0.29078462954440853,0.27528186838472157,0.25977910722503439]

{"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":7.9516554847772758E-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":0.9}]