{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","InputSheetOp1","Iputsheet1Dashboard","RecordSheet1","InputSheetOp2","Inputsheet2Dashboard","Piv1","Table","RecordSheet2"],"not_rendered":{"charts":8,"images":5,"macros":1,"external_links":1,"defined_names":3,"comments":3,"pivot_tables":2},"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"InputSheetOp1","index":1,"n_rows":141,"n_cols":17,"rows_kept":141,"cut":false,"hidden":false,"merged":[[93,7,93,8],[93,10,93,13],[58,1,65,1],[68,2,82,2]]}
[]
[null,null,null,"Red cells CAN'T be amended by the user"]
[null,null,null,"Orange cells CAN be amended by the user"]
[null,null,null,"Yellow cells must equal 100%"]
[null,null,"Hover your cursor over cells with a red triangle in top right corner for an explanation of its purpose"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Forecast Years (1-5)",5]
[null,null,"STP",{"$f":"IF(AND('Piv1'!$B$2=\"(All)\",'Piv1'!$B$1=\"(All)\"),\"(All)\",'Piv1'!$M$5)","v":"NWL"},null,null," Borough population ",{"$f":"'Piv1'!$A$5","v":226344},null,"Population growth",{"$f":"(1+(('Piv1'!$J$5/'Piv1'!$A$5)^(1/5)-1))^K18-1","v":4.8122249136356876E-2},null," 1 - 5  year population",{"$f":"H19*(1+K19)","v":237236.18235851955},"Whole Borough"]
[null,null,null,null,null,null," Population override ",null,null,"Population growth override",null,null," 1 - 5  year population",{"$f":"IF(OR(K20=\"\",K20=0),(H20*(1+K19)),(H20*(1+K20)))","v":0},"Overwritten"]
[null,null,"Borough",{"$f":"'Piv1'!$B$2","v":"Hammersmith and Fulham "}]
[]
[]
[]
[]
[]
[null,null,"Option 1"]
[]
[null,null,"Activity","Activity Proportion","Consultations per person per year","% growth in consultations per person per year","Total primary care consultations 2017","Total primary care consultations in future (1-5 years)"]
[null,null,"General activity",1,5.4,2.98E-2,{"$f":"IF(H20>0,E30*H20*D30,E30*H19*D30)","v":1222257.6000000001},{"$f":"IF(N20>0,N20*E30*(1+F30)^$K$18*D30,N19*E30*(1+F30)^$K$18*D30)","v":1483676.178954103}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Voluntary Sector",0]
[null,null,null,"Self Care",0]
[null,null,null,"Patient Led Group",0]
[null,null,null,"Social Prescribing",0]
[null,null,null,"Care Navigation",0]
[null,null,null,"Add New",0]
[null,null,null,"Add New",0]
[null,null,null,"Add New",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Clinical Time per consultation(mins)"]
[null,"Consultation medium","Face to Face",10,null,0.77]
[null,null,"e-consultation",10,null,0]
[null,null,"Telephone",5,null,0.2]
[null,null,"Group consultation",10,null,0]
[null,null,"Home Visit",20,null,0.03]
[null,null,"Email",5,null,0]
[null,null,"Add New",0,null,0]
[null,null,"Add New",0,null,0]
[null,null,null,null,null,{"$f":"SUM(F59:F66)","v":1}]
[]
[null,null,"Role Type","GP",null,0.7]
[null,null,null,"Nurse",null,0.27]
[null,null,null,"Consultant",null,0]
[null,null,null,"Pharmacist ",null,0]
[null,null,null,"Dietician",null,0]
[null,null,null,"HCA",null,0.03]
[null,null,null,"Psychologist",null,0]
[null,null,null,"Physician Associate",null,0]
[null,null,null,"Physiotherapist",null,0]
[null,null,null,"Podiatrist",null,0]
[null,null,null,"DSN",null,0]
[null,null,null,"Add New",null,0]
[null,null,null,"Add New",null,0]
[null,null,null,"Add New",null,0]
[null,null,null,"Add New",null,0]
[null,null,null,null,null,{"$f":"SUM(F69:F83)","v":1}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"National GP : Patient Ratio Avg",2100,"National Nurse : Patient Ratio Avg",4500]
[]
[]
[null,null,null,"System Cost",null,null,null,"Model Demand",null,null,"Current Capacity",null,null,null,"to be hidden"]
[null,null,null,"(£) Per FTE P/A",null,"Non Clinical Time",null,"Model FTE required to meet demand in general activity - Guide","Ratio Scaled Population - Guide",null,"NHS Digital Data Total - Guide","Ratio Borough Population - Guide","Ratio Scaled Population - Guide","Baseline","Input"]
[null,null,{"$f":"D69","v":"GP"},100000,null,0.3,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F69/Table!Y31),0)","v":117.48832744186046},{"$f":"MROUND((IFERROR((IF($H$20>0,$H$20/H96,$H$19/H96)),0)),100)","v":1900},null,{"$f":"'Piv1'!$E$5","v":124.226682305336},{"$f":"IF($H$20>0,$H$20/$H$19*K96,\"\")","v":""},{"$f":"IF($H$20>0,MROUND($H$20/L96,100),MROUND($H$19/K96,100))","v":1800},124,{"$f":"IF(OR(N96=\"\",N96=0),H96,N96)","v":124},null,"O96 to O110 will be hidden: the idea is: if they do not fill anything into the baseline column we will use the number suggested by the model (Paul suggested)"]
[null,null,{"$f":"D70","v":"Nurse"},40000,null,0.3,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F70/Table!Y32),0)","v":45.31692629900332},{"$f":"MROUND((IFERROR((IF($H$20>0,$H$20/H97,$H$19/H97)),0)),100)","v":5000},null,{"$f":"'Piv1'!$F$5","v":45.3899995684624},{"$f":"IF($H$20>0,$H$20/$H$19*K97,\"\")","v":""},{"$f":"IF($H$20>0,MROUND($H$20/L97,100),MROUND($H$19/K97,100))","v":5000},45,{"$f":"IF(OR(N97=\"\",N97=0),H97,N97)","v":45}]
[null,null,"Consultant",120000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F71/Table!Y33),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Pharmacist ",50000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F72/Table!Y34),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Dietician",45000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F73/Table!Y35),0)","v":0},null,null,null,null,null,null,0]
[null,null,"HCA",30000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F74/Table!Y36),0)","v":4.1466468508891925},null,null,null,null,null,4,4]
[null,null,"Psychologist",50000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F75/Table!Y37),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Physician Associate",40000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F76/Table!Y38),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Physiotherapist",40000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F77/Table!Y39),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Podiatrist",40000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F78/Table!Y40),0)","v":0},null,null,null,null,null,null,0]
[null,null,"DSN",50000,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F79/Table!Y41),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Add New",null,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F80/Table!Y42),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Add New",null,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F81/Table!Y43),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Add New",null,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F82/Table!Y44),0)","v":0},null,null,null,null,null,null,0]
[null,null,"Add New",null,null,0.15,null,{"$f":"IFERROR(((((1-SUM($E$41:$E$48))*$G$30)*($D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65+$D$66*$F$66))/60*F83/Table!Y45),0)","v":0},null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N111=\"\",N111=0),H111,N111)","v":0}]
[null,null,"Administrator ",25000,null,null,null,{"$f":"SUM(H96:H110)/Table!Y26","v":20.868987573969122}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Roles","Input",null,"Future Capacity (1-5 years)","Future Demand (1-5 years)",null,"Baseline","Future - Do Nothing","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
[null,null,{"$f":"D69","v":"GP"},124,null,{"$f":"Table!$Z$51","v":131.07171853848143},{"$f":"Table!$Z$52","v":150.52133542905258},null,124,150.52133542905258]
[null,null,{"$f":"D70","v":"Nurse"},45,null,{"$f":"Table!$Z$53","v":43.116811610893734},{"$f":"Table!$Z$54","v":54.624678179898112},null,45,54.624678179898112]
[null,null,"Consultant",0,null,null,{"$f":"D125*(1+$K$19)*(1+$F$30)^5","v":0},null,0,0]
[null,null,"Pharmacist ",0,null,null,{"$f":"D126*(1+$K$19)*(1+$F$30)^5","v":0},null,0,0]
[null,null,"Dietician",0,null,null,0,null,0,0]
[null,null,"HCA",4,null,null,4.8555269493242763,null,4,4.8555269493242763]
[null,null,"Psychologist",0,null,null,0,null,0,0]
[null,null,"Physician Associate",0,null,null,0,null,0,0]
[null,null,"Physiotherapist",0,null,null,0,null,0,0]
[null,null,"Podiatrist",0,null,null,0,null,0,0]
[null,null,"DSN",0,null,null,0,null,0,0]
[null,null,"Add New",0,null,null,0,null,0,0]
[null,null,"Add New",0,null,null,0,null,0,0]
[null,null,"Add New",0,null,null,0,null,0,0]
[null,null,"Add New",0,null,null,0,null,0,0]
[]
[]
[null,null,null,null,null,null,null,"System Cost",{"$f":"I123*$D96+I124*$D97+I125*$D98+I126*$D99+I127*$D100+I128*$D101+I129*$D102+I130*$D103+I131*$D104+I132*$D105+I133*$D106+I134*$D107+I135*$D108+I136*$D109+I137*$D110","v":14320000},{"$f":"J123*$D96+J124*$D97+J125*$D98+J126*$D99+J127*$D100+J128*$D101+J129*$D102+J130*$D103+J131*$D104+J132*$D105+J133*$D106+J134*$D107+J135*$D108+J136*$D109+J137*$D110","v":17382786.478580911},{"$f":"K123*$D96+K124*$D97+K125*$D98+K126*$D99+K127*$D100+K128*$D101+K129*$D102+K130*$D103+K131*$D104+K132*$D105+K133*$D106+K134*$D107+K135*$D108+K136*$D109+K137*$D110","v":0},{"$f":"L123*$D96+L124*$D97+L125*$D98+L126*$D99+L127*$D100+L128*$D101+L129*$D102+L130*$D103+L131*$D104+L132*$D105+L133*$D106+L134*$D107+L135*$D108+L136*$D109+L137*$D110","v":0},0,0,0]
[null,null,null,null,null,null,null,"Per head of population cost ",{"$f":"IF($H$20>0,I140/$H$20,I140/$H$19)","v":63.266532357827025},{"$f":"IF($H$20>0,J140/$H$20,J140/$H$19)","v":76.79808821343137},{"$f":"IF($H$20>0,K140/$H$20,K140/$H$19)","v":0},0,0,0,0]

{"sheet":"Iputsheet1Dashboard","index":2,"n_rows":72,"n_cols":17,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Skill Mix Scenarios"]
[null,{"$f":"[1]InputSheetOp1!I122","v":"Baseline"},{"$f":"[1]InputSheetOp1!J122","v":"Future - Do Nothing"},{"$f":"[1]InputSheetOp1!K122","v":"Scenario 1"},{"$f":"[1]InputSheetOp1!L122","v":"Scenario 2"},{"$f":"[1]InputSheetOp1!M122","v":"Scenario 3"},{"$f":"[1]InputSheetOp1!N122","v":"Scenario 4"},{"$f":"[1]InputSheetOp1!O122","v":"Scenario 5"},null,null,{"$f":"InputSheetOp1!I122","v":"Baseline"},{"$f":"InputSheetOp1!J122","v":"Future - Do Nothing"},{"$f":"InputSheetOp1!K122","v":"Scenario 1"},{"$f":"InputSheetOp1!L122","v":"Scenario 2"},{"$f":"InputSheetOp1!M122","v":"Scenario 3"},{"$f":"InputSheetOp1!N122","v":"Scenario 4"},{"$f":"InputSheetOp1!O122","v":"Scenario 5"}]
[{"$f":"[1]InputSheetOp1!D69","v":"GP"},{"$f":"InputSheetOp1!I123","v":124},{"$f":"InputSheetOp1!J123","v":150.52133542905258},{"$f":"InputSheetOp1!K123","v":0},{"$f":"InputSheetOp1!L123","v":0},{"$f":"InputSheetOp1!M123","v":0},{"$f":"InputSheetOp1!N123","v":0},{"$f":"InputSheetOp1!O123","v":0},null,null,{"$f":"InputSheetOp1!I123","v":124},{"$f":"InputSheetOp1!J123","v":150.52133542905258},{"$f":"InputSheetOp1!K123","v":0},{"$f":"InputSheetOp1!L123","v":0},{"$f":"InputSheetOp1!M123","v":0},{"$f":"InputSheetOp1!N123","v":0},{"$f":"InputSheetOp1!O123","v":0}]
[{"$f":"[1]InputSheetOp1!D70","v":"Nurse"},{"$f":"InputSheetOp1!I124","v":45},{"$f":"InputSheetOp1!J124","v":54.624678179898112},{"$f":"InputSheetOp1!K124","v":0},{"$f":"InputSheetOp1!L124","v":0},{"$f":"InputSheetOp1!M124","v":0},{"$f":"InputSheetOp1!N124","v":0},{"$f":"InputSheetOp1!O124","v":0},null,null,{"$f":"InputSheetOp1!I124","v":45},{"$f":"InputSheetOp1!J124","v":54.624678179898112},{"$f":"InputSheetOp1!K124","v":0},{"$f":"InputSheetOp1!L124","v":0},{"$f":"InputSheetOp1!M124","v":0},{"$f":"InputSheetOp1!N124","v":0},{"$f":"InputSheetOp1!O124","v":0}]
[{"$f":"[1]InputSheetOp1!D71","v":"Consultant"},{"$f":"InputSheetOp1!I125","v":0},{"$f":"InputSheetOp1!J125","v":0},{"$f":"InputSheetOp1!K125","v":0},{"$f":"InputSheetOp1!L125","v":0},{"$f":"InputSheetOp1!M125","v":0},{"$f":"InputSheetOp1!N125","v":0},{"$f":"InputSheetOp1!O125","v":0},null,null,{"$f":"InputSheetOp1!I125","v":0},{"$f":"InputSheetOp1!J125","v":0},{"$f":"InputSheetOp1!K125","v":0},{"$f":"InputSheetOp1!L125","v":0},{"$f":"InputSheetOp1!M125","v":0},{"$f":"InputSheetOp1!N125","v":0},{"$f":"InputSheetOp1!O125","v":0}]
[{"$f":"[1]InputSheetOp1!D72","v":"Pharmacist "},{"$f":"InputSheetOp1!I126","v":0},{"$f":"InputSheetOp1!J126","v":0},{"$f":"InputSheetOp1!K126","v":0},{"$f":"InputSheetOp1!L126","v":0},{"$f":"InputSheetOp1!M126","v":0},{"$f":"InputSheetOp1!N126","v":0},{"$f":"InputSheetOp1!O126","v":0},null,null,{"$f":"InputSheetOp1!I126","v":0},{"$f":"InputSheetOp1!J126","v":0},{"$f":"InputSheetOp1!K126","v":0},{"$f":"InputSheetOp1!L126","v":0},{"$f":"InputSheetOp1!M126","v":0},{"$f":"InputSheetOp1!N126","v":0},{"$f":"InputSheetOp1!O126","v":0}]
[{"$f":"[1]InputSheetOp1!D73","v":"Dietician"},{"$f":"InputSheetOp1!I127","v":0},{"$f":"InputSheetOp1!J127","v":0},{"$f":"InputSheetOp1!K127","v":0},{"$f":"InputSheetOp1!L127","v":0},{"$f":"InputSheetOp1!M127","v":0},{"$f":"InputSheetOp1!N127","v":0},{"$f":"InputSheetOp1!O127","v":0},null,null,{"$f":"InputSheetOp1!I127","v":0},{"$f":"InputSheetOp1!J127","v":0},{"$f":"InputSheetOp1!K127","v":0},{"$f":"InputSheetOp1!L127","v":0},{"$f":"InputSheetOp1!M127","v":0},{"$f":"InputSheetOp1!N127","v":0},{"$f":"InputSheetOp1!O127","v":0}]
[{"$f":"[1]InputSheetOp1!D74","v":"HCA"},{"$f":"InputSheetOp1!I128","v":4},{"$f":"InputSheetOp1!J128","v":4.8555269493242763},{"$f":"InputSheetOp1!K128","v":0},{"$f":"InputSheetOp1!L128","v":0},{"$f":"InputSheetOp1!M128","v":0},{"$f":"InputSheetOp1!N128","v":0},{"$f":"InputSheetOp1!O128","v":0},null,null,{"$f":"InputSheetOp1!I128","v":4},{"$f":"InputSheetOp1!J128","v":4.8555269493242763},{"$f":"InputSheetOp1!K128","v":0},{"$f":"InputSheetOp1!L128","v":0},{"$f":"InputSheetOp1!M128","v":0},{"$f":"InputSheetOp1!N128","v":0},{"$f":"InputSheetOp1!O128","v":0}]
[{"$f":"[1]InputSheetOp1!D75","v":"Psychologist"},{"$f":"InputSheetOp1!I129","v":0},{"$f":"InputSheetOp1!J129","v":0},{"$f":"InputSheetOp1!K129","v":0},{"$f":"InputSheetOp1!L129","v":0},{"$f":"InputSheetOp1!M129","v":0},{"$f":"InputSheetOp1!N129","v":0},{"$f":"InputSheetOp1!O129","v":0},null,null,{"$f":"InputSheetOp1!I129","v":0},{"$f":"InputSheetOp1!J129","v":0},{"$f":"InputSheetOp1!K129","v":0},{"$f":"InputSheetOp1!L129","v":0},{"$f":"InputSheetOp1!M129","v":0},{"$f":"InputSheetOp1!N129","v":0},{"$f":"InputSheetOp1!O129","v":0}]
[{"$f":"[1]InputSheetOp1!D76","v":"Physician Associate"},{"$f":"InputSheetOp1!I130","v":0},{"$f":"InputSheetOp1!J130","v":0},{"$f":"InputSheetOp1!K130","v":0},{"$f":"InputSheetOp1!L130","v":0},{"$f":"InputSheetOp1!M130","v":0},{"$f":"InputSheetOp1!N130","v":0},{"$f":"InputSheetOp1!O130","v":0},null,null,{"$f":"InputSheetOp1!I130","v":0},{"$f":"InputSheetOp1!J130","v":0},{"$f":"InputSheetOp1!K130","v":0},{"$f":"InputSheetOp1!L130","v":0},{"$f":"InputSheetOp1!M130","v":0},{"$f":"InputSheetOp1!N130","v":0},{"$f":"InputSheetOp1!O130","v":0}]
[{"$f":"[1]InputSheetOp1!D77","v":"Physiotherapist"},{"$f":"InputSheetOp1!I131","v":0},{"$f":"InputSheetOp1!J131","v":0},{"$f":"InputSheetOp1!K131","v":0},{"$f":"InputSheetOp1!L131","v":0},{"$f":"InputSheetOp1!M131","v":0},{"$f":"InputSheetOp1!N131","v":0},{"$f":"InputSheetOp1!O131","v":0},null,null,{"$f":"InputSheetOp1!I131","v":0},{"$f":"InputSheetOp1!J131","v":0},{"$f":"InputSheetOp1!K131","v":0},{"$f":"InputSheetOp1!L131","v":0},{"$f":"InputSheetOp1!M131","v":0},{"$f":"InputSheetOp1!N131","v":0},{"$f":"InputSheetOp1!O131","v":0}]
[{"$f":"[1]InputSheetOp1!D78","v":"Podiatrist"},{"$f":"InputSheetOp1!I132","v":0},{"$f":"InputSheetOp1!J132","v":0},{"$f":"InputSheetOp1!K132","v":0},{"$f":"InputSheetOp1!L132","v":0},{"$f":"InputSheetOp1!M132","v":0},{"$f":"InputSheetOp1!N132","v":0},{"$f":"InputSheetOp1!O132","v":0},null,null,{"$f":"InputSheetOp1!I132","v":0},{"$f":"InputSheetOp1!J132","v":0},{"$f":"InputSheetOp1!K132","v":0},{"$f":"InputSheetOp1!L132","v":0},{"$f":"InputSheetOp1!M132","v":0},{"$f":"InputSheetOp1!N132","v":0},{"$f":"InputSheetOp1!O132","v":0}]
[{"$f":"[1]InputSheetOp1!D79","v":"DSN"},{"$f":"InputSheetOp1!I133","v":0},{"$f":"InputSheetOp1!J133","v":0},{"$f":"InputSheetOp1!K133","v":0},{"$f":"InputSheetOp1!L133","v":0},{"$f":"InputSheetOp1!M133","v":0},{"$f":"InputSheetOp1!N133","v":0},{"$f":"InputSheetOp1!O133","v":0},null,null,{"$f":"InputSheetOp1!I133","v":0},{"$f":"InputSheetOp1!J133","v":0},{"$f":"InputSheetOp1!K133","v":0},{"$f":"InputSheetOp1!L133","v":0},{"$f":"InputSheetOp1!M133","v":0},{"$f":"InputSheetOp1!N133","v":0},{"$f":"InputSheetOp1!O133","v":0}]
[{"$f":"[1]InputSheetOp1!D80","v":"Add New"},{"$f":"InputSheetOp1!I134","v":0},{"$f":"InputSheetOp1!J134","v":0},{"$f":"InputSheetOp1!K134","v":0},{"$f":"InputSheetOp1!L134","v":0},{"$f":"InputSheetOp1!M134","v":0},{"$f":"InputSheetOp1!N134","v":0},{"$f":"InputSheetOp1!O134","v":0},null,null,{"$f":"InputSheetOp1!I134","v":0},{"$f":"InputSheetOp1!J134","v":0},{"$f":"InputSheetOp1!K134","v":0},{"$f":"InputSheetOp1!L134","v":0},{"$f":"InputSheetOp1!M134","v":0},{"$f":"InputSheetOp1!N134","v":0},{"$f":"InputSheetOp1!O134","v":0}]
[{"$f":"[1]InputSheetOp1!D81","v":"Add New"},{"$f":"InputSheetOp1!I135","v":0},{"$f":"InputSheetOp1!J135","v":0},{"$f":"InputSheetOp1!K135","v":0},{"$f":"InputSheetOp1!L135","v":0},{"$f":"InputSheetOp1!M135","v":0},{"$f":"InputSheetOp1!N135","v":0},{"$f":"InputSheetOp1!O135","v":0},null,null,{"$f":"InputSheetOp1!I135","v":0},{"$f":"InputSheetOp1!J135","v":0},{"$f":"InputSheetOp1!K135","v":0},{"$f":"InputSheetOp1!L135","v":0},{"$f":"InputSheetOp1!M135","v":0},{"$f":"InputSheetOp1!N135","v":0},{"$f":"InputSheetOp1!O135","v":0}]
[{"$f":"[1]InputSheetOp1!D82","v":"Add New"},{"$f":"InputSheetOp1!I136","v":0},{"$f":"InputSheetOp1!J136","v":0},{"$f":"InputSheetOp1!K136","v":0},{"$f":"InputSheetOp1!L136","v":0},{"$f":"InputSheetOp1!M136","v":0},{"$f":"InputSheetOp1!N136","v":0},{"$f":"InputSheetOp1!O136","v":0},null,null,{"$f":"InputSheetOp1!I136","v":0},{"$f":"InputSheetOp1!J136","v":0},{"$f":"InputSheetOp1!K136","v":0},{"$f":"InputSheetOp1!L136","v":0},{"$f":"InputSheetOp1!M136","v":0},{"$f":"InputSheetOp1!N136","v":0},{"$f":"InputSheetOp1!O136","v":0}]
[{"$f":"[1]InputSheetOp1!D83","v":"Add New"},{"$f":"InputSheetOp1!I137","v":0},{"$f":"InputSheetOp1!J137","v":0},{"$f":"InputSheetOp1!K137","v":0},{"$f":"InputSheetOp1!L137","v":0},{"$f":"InputSheetOp1!M137","v":0},{"$f":"InputSheetOp1!N137","v":0},{"$f":"InputSheetOp1!O137","v":0},null,null,{"$f":"InputSheetOp1!I137","v":0},{"$f":"InputSheetOp1!J137","v":0},{"$f":"InputSheetOp1!K137","v":0},{"$f":"InputSheetOp1!L137","v":0},{"$f":"InputSheetOp1!M137","v":0},{"$f":"InputSheetOp1!N137","v":0},{"$f":"InputSheetOp1!O137","v":0}]
[]
[null,"Rise in Demand"]
[null,{"$f":"[1]InputSheetOp1!$G$29","v":"Total primary care consultations 2017"},{"$f":"[1]InputSheetOp1!$H$29","v":"Total primary care consultations in future (1-5 years)"}]
[null,{"$f":"InputSheetOp1!$G$30","v":1222257.6000000001},{"$f":"InputSheetOp1!$H$30","v":1483676.178954103}]
[]
[]
[null,"Costs"]
[null,{"$f":"[1]InputSheetOp1!I122","v":"Baseline"},{"$f":"[1]InputSheetOp1!J122","v":"Future - Do Nothing"},{"$f":"[1]InputSheetOp1!K122","v":"Scenario 1"},{"$f":"[1]InputSheetOp1!L122","v":"Scenario 2"},{"$f":"[1]InputSheetOp1!M122","v":"Scenario 3"},{"$f":"[1]InputSheetOp1!N122","v":"Scenario 4"},{"$f":"[1]InputSheetOp1!O122","v":"Scenario 5"}]
[{"$f":"[1]InputSheetOp1!H140","v":"System Cost"},{"$f":"InputSheetOp1!I140","v":14320000},{"$f":"InputSheetOp1!J140","v":17382786.478580911},{"$f":"InputSheetOp1!K140","v":0},{"$f":"InputSheetOp1!L140","v":0},{"$f":"InputSheetOp1!M140","v":0},{"$f":"InputSheetOp1!N140","v":0},{"$f":"InputSheetOp1!O140","v":0}]
[{"$f":"[1]InputSheetOp1!H141","v":"Per head of population cost "},{"$f":"InputSheetOp1!I141","v":63.266532357827025},{"$f":"InputSheetOp1!J141","v":76.79808821343137},{"$f":"InputSheetOp1!K141","v":0},{"$f":"InputSheetOp1!L141","v":0},{"$f":"InputSheetOp1!M141","v":0},{"$f":"InputSheetOp1!N141","v":0},{"$f":"InputSheetOp1!O141","v":0}]

{"sheet":"RecordSheet1","index":3,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,0,8,0],[9,0,16,0],[18,0,32,0],[36,0,50,0]]}
[null,null,"Future - Do Nothing","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
["Non-Clinical","Voluntary Sector",0]
[null,"Self Care",0]
[null,"Patient Led Group",0]
[null,"Social Prescribing",0]
[null,"Care Navigation",0]
[null,"Add New",0]
[null,"Add New",0]
[null,"Add New",0]
["Consultation medium","Face to Face",0.77]
[null,"e-consultation",0]
[null,"Telephone",0.2]
[null,"Group consultation",0]
[null,"Home Visit",0.03]
[null,"Email",0]
[null,"Add New",0]
[null,"Add New",0]
[]
["Role Type","GP",0.7]
[null,"Nurse",0.27]
[null,"Consultant",0]
[null,"Pharmacist ",0]
[null,"Dietician",0]
[null,"HCA",0.03]
[null,"Psychologist",0]
[null,"Physician Associate",0]
[null,"Physiotherapist",0]
[null,"Podiatrist",0]
[null,"DSN",0]
[null,"Add New",0]
[null,"Add New",0]
[null,"Add New",0]
[null,"Add New",0]
[]
[]
[]
["Input summary","GP",150.52133542905258]
[null,"Nurse",54.624678179898112]
[null,"Consultant",0]
[null,"Pharmacist ",0]
[null,"Dietician",0]
[null,"HCA",4.8555269493242763]
[null,"Psychologist",0]
[null,"Physician Associate",0]
[null,"Physiotherapist",0]
[null,"Podiatrist",0]
[null,"DSN",0]
[null,"Add New",0]
[null,"Add New",0]
[null,"Add New",0]
[null,"Add New",0]

{"sheet":"InputSheetOp2","index":4,"n_rows":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[52,5,52,12],[53,5,53,12],[57,1,64,1],[67,2,81,2]]}
[]
[null,null,null,"Red cells CAN'T be amended by the user"]
[null,null,null,"Orange cells CAN be amended by the user"]
[null,null,null,"Yellow cells must equal 100%"]
[null,null,"Hover your cursor over cells with a red triangle in top right corner for an explanation of its purpose"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Forecast Years (1-5)",5]
[null,null,"STP",{"$f":"IF(AND('Piv1'!$B$2=\"(All)\",'Piv1'!$B$1=\"(All)\"),\"(All)\",'Piv1'!$M$5)","v":"NWL"},null,null," Borough population ",{"$f":"'Piv1'!$A$5","v":226344},null,"Population growth",{"$f":"(1+(('Piv1'!$J$5/'Piv1'!$A$5)^(1/5)-1))^K18-1","v":4.8122249136356876E-2},null," 1 - 5  year population",{"$f":"H19*(1+K19)","v":237236.18235851955}]
[null,null,null,null,null,null," Population override ",null,null,"Population growth override",null,null," 1 - 5  year population",{"$f":"IF(OR(K20=\"\",K20=0),(H20*(1+K19)),(H20*(1+K20)))","v":0}]
[null,null,"Borough",{"$f":"'Piv1'!$B$2","v":"Hammersmith and Fulham "}]
[]
[]
[]
[]
[]
[null,null,"Option 2"]
[]
[null,null,null,"Activity Proportion","Consultations per person per year","% growth in consultations per person per year","Total primary care consultations 2017","Total primary care consultations +X years"]
[null,null,null,0.12,8,2.98E-2,{"$f":"IF(H20>0,E30*H20*D30,E30*H19*D30)","v":217290.23999999999},{"$f":"IF(N20>0,N20*E30*(1+F30)^$K$18*D30,N19*E30*(1+F30)^$K$18*D30)","v":263764.65403628495}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Voluntary Sector",0]
[null,null,null,"Self Care",0.5]
[null,null,null,"Patient Led Group",0]
[null,null,null,"Social Prescribing",0]
[null,null,null,"Care Navigation",0]
[null,null,null,"Add New",0]
[null,null,null,"Add New",0]
[null,null,null,"Add New",0]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Option 2"]
[null,null,null,null,null,"Focussed activity"]
[null,null,null,null,null,"Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,null,null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0,{"$f":"SUM(F56:M56)","v":1}]
[null,null,null,"Clinical Time per consultation(mins)"]
[null,"Consultation medium","Face to Face",10,null,0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,null,"e-consultation",10,null,0,0,0,0,0,0,0,0]
[null,null,"Telephone",5,null,0.1,0.1,0.1,0.1,0.1,0.1,0,0]
[null,null,"Group consultation",10,null,0,0,0,0,0,0,0,0]
[null,null,"Home Visit",20,null,0,0,0,0,0,0,0,0]
[null,null,"Email",5,null,0,0,0,0,0,0,0,0]
[null,null,"Add New",5,null,0,0,0,0,0,0,0,0]
[null,null,"Add New",0,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F58:F65)","v":1},1,1,1,1,1,0,0]
[]
[null,null,"Role Type","GP",null,0.55000000000000004,0.1,0.4,0.5,0.45,0.5,0,0]
[null,null,null,"Nurse",null,0.35,0.35,0.5,0.4,0.35,0.5,0,0]
[null,null,null,"Consultant",null,0,0,0,0,0,0,0,0]
[null,null,null,"Pharmacist ",null,0,0,0,0,0.1,0,0,0]
[null,null,null,"Dietician",null,0,0,0,0,0,0,0,0]
[null,null,null,"HCA",null,0.1,0.1,0.1,0.1,0.1,0,0,0]
[null,null,null,"Psychologist",null,0,0,0,0,0,0,0,0]
[null,null,null,"Physician Associate",null,0,0,0,0,0,0,0,0]
[null,null,null,"Physiotherapist",null,0,0,0,0,0,0,0,0]
[null,null,null,"Podiatrist",null,0,0,0,0,0,0,0,0]
[null,null,null,"DSN",null,0,0.45,0,0,0,0,0,0]
[null,null,null,"Add New",null,0,0,0,0,0,0,0,0]
[null,null,null,"Add New",null,0,0,0,0,0,0,0,0]
[null,null,null,"Add New",null,0,0,0,0,0,0,0,0]
[null,null,null,"Add New",null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F68:F82)","v":1},{"$f":"SUM(G68:G82)","v":1},1,1,1,1,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"System Cost",null,null,null,"Model Demand"]
[null,null,null,"(£) Per FTE P/A",null,"Non_Clinical_Time",null,"Model FTE required to meet demand in general activity - Guide",null,"Baseline"]
[null,null,"GP",100000,null,0.25,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F68/Table!Z31*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G68/Table!Z31*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H68/Table!Z31*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I68/Table!Z31*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J68/Table!Z31*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K68/Table!Z31*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L68/Table!Z31*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M68/Table!Z31*M$56)),0)","v":5.2984381519379848},null,10.6,{"$f":"IF(OR(J96=\"\",J96=0),H96,J96)","v":10.6}]
[null,null,"Nurse",40000,null,0.25,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F69/Table!Z32*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G69/Table!Z32*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H69/Table!Z32*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I69/Table!Z32*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J69/Table!Z32*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K69/Table!Z32*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L69/Table!Z32*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M69/Table!Z32*M$56)),0)","v":5.9029579410852708},null,11.8,{"$f":"IF(OR(J97=\"\",J97=0),H97,J97)","v":11.8}]
[null,null,"Consultant",120000,null,0.15,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F70/Table!Z33*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G70/Table!Z33*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H70/Table!Z33*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I70/Table!Z33*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J70/Table!Z33*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K70/Table!Z33*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L70/Table!Z33*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M70/Table!Z33*M$56)),0)","v":0},null,null,0]
[null,null,"Pharmacist ",50000,null,0.09,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F71/Table!Z34*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G71/Table!Z34*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H71/Table!Z34*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I71/Table!Z34*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J71/Table!Z34*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K71/Table!Z34*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L71/Table!Z34*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M71/Table!Z34*M$56)),0)","v":0.117230728341426},null,0.2,0.2]
[null,null,"Dietician",45000,null,7.0000000000000007E-2,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F72/Table!Z35*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G72/Table!Z35*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H72/Table!Z35*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I72/Table!Z35*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J72/Table!Z35*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K72/Table!Z35*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L72/Table!Z35*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M72/Table!Z35*M$56)),0)","v":0},null,null,0]
[null,null,"HCA",30000,null,0.06,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F73/Table!Z36*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G73/Table!Z36*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H73/Table!Z36*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I73/Table!Z36*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J73/Table!Z36*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K73/Table!Z36*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L73/Table!Z36*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M73/Table!Z36*M$56)),0)","v":1.0214038990598713},null,2,2]
[null,null,"Psychologist",50000,null,0.08,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F74/Table!Z37*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G74/Table!Z37*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H74/Table!Z37*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I74/Table!Z37*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J74/Table!Z37*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K74/Table!Z37*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L74/Table!Z37*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M74/Table!Z37*M$56)),0)","v":0},null,null,0]
[null,null,"Physician Associate",40000,null,0.09,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F75/Table!Z38*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G75/Table!Z38*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H75/Table!Z38*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I75/Table!Z38*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J75/Table!Z38*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K75/Table!Z38*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L75/Table!Z38*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M75/Table!Z38*M$56)),0)","v":0},null,null,0]
[null,null,"Physiotherapist",40000,null,0.1,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F76/Table!Z39*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G76/Table!Z39*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H76/Table!Z39*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I76/Table!Z39*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J76/Table!Z39*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K76/Table!Z39*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L76/Table!Z39*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M76/Table!Z39*M$56)),0)","v":0},null,null,0]
[null,null,"Podiatrist",40000,null,0.11,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F77/Table!Z40*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G77/Table!Z40*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H77/Table!Z40*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I77/Table!Z40*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J77/Table!Z40*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K77/Table!Z40*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L77/Table!Z40*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M77/Table!Z40*M$56)),0)","v":0},null,null,0]
[null,null,"DSN",50000,null,0.115,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F78/Table!Z41*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G78/Table!Z41*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H78/Table!Z41*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I78/Table!Z41*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J78/Table!Z41*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K78/Table!Z41*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L78/Table!Z41*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M78/Table!Z41*M$56)),0)","v":1.3561012219156483},null,3,3]
[null,null,"Add New",null,null,0,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F79/Table!Z42*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G79/Table!Z42*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H79/Table!Z42*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I79/Table!Z42*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J79/Table!Z42*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K79/Table!Z42*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L79/Table!Z42*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M79/Table!Z42*M$56)),0)","v":0},null,null,0]
[null,null,"Add New",null,null,0,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F80/Table!Z43*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G80/Table!Z43*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H80/Table!Z43*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I80/Table!Z43*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J80/Table!Z43*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K80/Table!Z43*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L80/Table!Z43*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M80/Table!Z43*M$56)),0)","v":0},null,null,0]
[null,null,"Add New",null,null,0,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F81/Table!Z44*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G81/Table!Z44*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H81/Table!Z44*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I81/Table!Z44*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J81/Table!Z44*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K81/Table!Z44*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L81/Table!Z44*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M81/Table!Z44*M$56)),0)","v":0},null,null,0]
[null,null,"Add New",null,null,0,null,{"$f":"IFERROR((((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$F$58+$D$59*$F$59+$D$60*$F$60+$D$61*$F$61+$D$62*$F$62+$D$63*$F$63+$D$64*$F$64+$D$65*$F$65))/60*F82/Table!Z45*F$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$G$58+$D$59*$G$59+$D$60*$G$60+$D$61*$G$61+$D$62*$G$62+$D$63*$G$63+$D$64*$G$64+$D$65*$G$65))/60*G82/Table!Z45*G$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$H$58+$D$59*$H$59+$D$60*$H$60+$D$61*$H$61+$D$62*$H$62+$D$63*$H$63+$D$64*$H$64+$D$65*$H$65))/60*H82/Table!Z45*H$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$I$58+$D$59*$I$59+$D$60*$I$60+$D$61*$I$61+$D$62*$I$62+$D$63*$I$63+$D$64*$I$64+$D$65*$I$65))/60*I82/Table!Z45*I$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$J$58+$D$59*$J$59+$D$60*$J$60+$D$61*$J$61+$D$62*$J$62+$D$63*$J$63+$D$64*$J$64+$D$65*$J$65))/60*J82/Table!Z45*J$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$K$58+$D$59*$K$59+$D$60*$K$60+$D$61*$K$61+$D$62*$K$62+$D$63*$K$63+$D$64*$K$64+$D$65*$K$65))/60*K82/Table!Z45*K$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$L$58+$D$59*$L$59+$D$60*$L$60+$D$61*$L$61+$D$62*$L$62+$D$63*$L$63+$D$64*$L$64+$D$65*$L$65))/60*L82/Table!Z45*L$56)+((((1-SUM($E$40:$E$47))*$G$30)*($D$58*$M$58+$D$59*$M$59+$D$60*$M$60+$D$61*$M$61+$D$62*$M$62+$D$63*$M$63+$D$64*$M$64+$D$65*$M$65))/60*M82/Table!Z45*M$56)),0)","v":0},null,null,0]
[]
[null,null,"Administrator ",25000,null,null,null,{"$f":"SUM(H96:H110)/Table!Y26","v":1.7120164927925252}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Roles","Input",null,null,"Future Demand (1-5 years)",null,"Baseline","Future - Do Nothing","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5","Scenario 6","Scenario 7","Scenario 8","Scenario 9"]
[null,null,"GP",5.2984381519379848,null,null,{"$f":"Table!$AB$52","v":6.4316773090156998},null,10.6,12.867146415709332,6.4316773090156998]
[null,null,"Nurse",5.9029579410852708,null,null,{"$f":"Table!$AB$54","v":7.1654928409168193},null,11.8,14.323804500506615,7.1654928409168193]
[null,null,"Consultant",0,null,null,{"$f":"D126*(1+$K$19)*(1+$F$30)^$K$18","v":0},null,0,0,0]
[null,null,"Pharmacist ",0.117230728341426,null,null,{"$f":"D127*(1+$K$19)*(1+$F$30)^$K$18","v":0.14230424018767679},null,0.2,0.24277634746621382,0.14230424018767679]
[null,null,"Dietician",0,null,null,0,null,0,0,0]
[null,null,"HCA",1.0214038990598713,null,null,{"$f":"D129*(1+$K$19)*(1+$F$30)^$K$18","v":1.2398635395075246},null,2,2.4277634746621382,1.2398635395075246]
[null,null,"Psychologist",0,null,null,0,null,0,0,0]
[null,null,"Physician Associate",0,null,null,0,null,0,0,0]
[null,null,"Physiotherapist",0,null,null,0,null,0,0,0]
[null,null,"Podiatrist",0,null,null,0,null,0,0,0]
[null,null,"DSN",1.3561012219156483,null,null,1.6461465072557528,null,3,3.641645211993207,1.6461465072557528]
[null,null,"Add New",0,null,null,0,null,0,0,0]
[null,null,"Add New",0,null,null,0,null,0,0,0]
[null,null,"Add New",0,null,null,0,null,0,0,0]
[null,null,"Add New",0,null,null,0,null,0,0,0]
[]
[]
[null,null,null,null,null,null,null,"System Cost",{"$f":"I124*$D96+I125*$D97+I126*$D98+I127*$D99+I128*$D100+I129*$D101+I130*$D102+I131*$D103+I132*$D104+I133*$D105+I134*$D106+I135*$D107+I136*$D108+I137*$D109+I138*$D110","v":1752000},{"$f":"J124*$D96+J125*$D97+J126*$D98+J127*$D99+J128*$D100+J129*$D101+J130*$D102+J131*$D103+J132*$D104+J133*$D105+J134*$D106+J135*$D107+J136*$D108+J137*$D109+J138*$D110","v":2126720.803804033},1056405.8880956399,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Per head of population cost ",{"$f":"IF($H$20>0,I141/$H$20,I141/$H$19)","v":7.7404304951754854},{"$f":"IF($H$20>0,J141/$H$20,J141/$H$19)","v":9.3959672171740056},4.6672581914945388,0,0,0,0,0,0,0,0]

{"sheet":"Inputsheet2Dashboard","index":5,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Baseline","Future - Do Nothing","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5","Scenario 6","Scenario 7","Scenario 8","Scenario 9"]
[null,{"$f":"[1]InputSheetOp2!D68","v":"GP"},{"$f":"InputSheetOp2!I124","v":10.6},{"$f":"InputSheetOp2!J124","v":12.867146415709332},{"$f":"InputSheetOp2!K124","v":6.4316773090156998},{"$f":"InputSheetOp2!L124","v":0},{"$f":"InputSheetOp2!M124","v":0},{"$f":"InputSheetOp2!N124","v":0},{"$f":"InputSheetOp2!O124","v":0},{"$f":"InputSheetOp2!P124","v":0},{"$f":"InputSheetOp2!Q124","v":0},{"$f":"InputSheetOp2!R124","v":0},{"$f":"InputSheetOp2!S124","v":0}]
[null,{"$f":"[1]InputSheetOp2!D69","v":"Nurse"},{"$f":"InputSheetOp2!I125","v":11.8},{"$f":"InputSheetOp2!J125","v":14.323804500506615},{"$f":"InputSheetOp2!K125","v":7.1654928409168193},{"$f":"InputSheetOp2!L125","v":0},{"$f":"InputSheetOp2!M125","v":0},{"$f":"InputSheetOp2!N125","v":0},{"$f":"InputSheetOp2!O125","v":0},{"$f":"InputSheetOp2!P125","v":0},{"$f":"InputSheetOp2!Q125","v":0},{"$f":"InputSheetOp2!R125","v":0},{"$f":"InputSheetOp2!S125","v":0}]
[null,{"$f":"[1]InputSheetOp2!D70","v":"Consultant"},{"$f":"InputSheetOp2!I126","v":0},{"$f":"InputSheetOp2!J126","v":0},{"$f":"InputSheetOp2!K126","v":0},{"$f":"InputSheetOp2!L126","v":0},{"$f":"InputSheetOp2!M126","v":0},{"$f":"InputSheetOp2!N126","v":0},{"$f":"InputSheetOp2!O126","v":0},{"$f":"InputSheetOp2!P126","v":0},{"$f":"InputSheetOp2!Q126","v":0},{"$f":"InputSheetOp2!R126","v":0},{"$f":"InputSheetOp2!S126","v":0}]
[null,{"$f":"[1]InputSheetOp2!D71","v":"Pharmacist "},{"$f":"InputSheetOp2!I127","v":0.2},{"$f":"InputSheetOp2!J127","v":0.24277634746621382},{"$f":"InputSheetOp2!K127","v":0.14230424018767679},{"$f":"InputSheetOp2!L127","v":0},{"$f":"InputSheetOp2!M127","v":0},{"$f":"InputSheetOp2!N127","v":0},{"$f":"InputSheetOp2!O127","v":0},{"$f":"InputSheetOp2!P127","v":0},{"$f":"InputSheetOp2!Q127","v":0},{"$f":"InputSheetOp2!R127","v":0},{"$f":"InputSheetOp2!S127","v":0}]
[null,{"$f":"[1]InputSheetOp2!D72","v":"Dietician"},{"$f":"InputSheetOp2!I128","v":0},{"$f":"InputSheetOp2!J128","v":0},{"$f":"InputSheetOp2!K128","v":0},{"$f":"InputSheetOp2!L128","v":0},{"$f":"InputSheetOp2!M128","v":0},{"$f":"InputSheetOp2!N128","v":0},{"$f":"InputSheetOp2!O128","v":0},{"$f":"InputSheetOp2!P128","v":0},{"$f":"InputSheetOp2!Q128","v":0},{"$f":"InputSheetOp2!R128","v":0},{"$f":"InputSheetOp2!S128","v":0}]
[null,{"$f":"[1]InputSheetOp2!D73","v":"HCA"},{"$f":"InputSheetOp2!I129","v":2},{"$f":"InputSheetOp2!J129","v":2.4277634746621382},{"$f":"InputSheetOp2!K129","v":1.2398635395075246},{"$f":"InputSheetOp2!L129","v":0},{"$f":"InputSheetOp2!M129","v":0},{"$f":"InputSheetOp2!N129","v":0},{"$f":"InputSheetOp2!O129","v":0},{"$f":"InputSheetOp2!P129","v":0},{"$f":"InputSheetOp2!Q129","v":0},{"$f":"InputSheetOp2!R129","v":0},{"$f":"InputSheetOp2!S129","v":0}]
[null,{"$f":"[1]InputSheetOp2!D74","v":"Psychologist"},{"$f":"InputSheetOp2!I130","v":0},{"$f":"InputSheetOp2!J130","v":0},{"$f":"InputSheetOp2!K130","v":0},{"$f":"InputSheetOp2!L130","v":0},{"$f":"InputSheetOp2!M130","v":0},{"$f":"InputSheetOp2!N130","v":0},{"$f":"InputSheetOp2!O130","v":0},{"$f":"InputSheetOp2!P130","v":0},{"$f":"InputSheetOp2!Q130","v":0},{"$f":"InputSheetOp2!R130","v":0},{"$f":"InputSheetOp2!S130","v":0}]
[null,{"$f":"[1]InputSheetOp2!D75","v":"Physician Associate"},{"$f":"InputSheetOp2!I131","v":0},{"$f":"InputSheetOp2!J131","v":0},{"$f":"InputSheetOp2!K131","v":0},{"$f":"InputSheetOp2!L131","v":0},{"$f":"InputSheetOp2!M131","v":0},{"$f":"InputSheetOp2!N131","v":0},{"$f":"InputSheetOp2!O131","v":0},{"$f":"InputSheetOp2!P131","v":0},{"$f":"InputSheetOp2!Q131","v":0},{"$f":"InputSheetOp2!R131","v":0},{"$f":"InputSheetOp2!S131","v":0}]
[null,{"$f":"[1]InputSheetOp2!D76","v":"Physiotherapist"},{"$f":"InputSheetOp2!I132","v":0},{"$f":"InputSheetOp2!J132","v":0},{"$f":"InputSheetOp2!K132","v":0},{"$f":"InputSheetOp2!L132","v":0},{"$f":"InputSheetOp2!M132","v":0},{"$f":"InputSheetOp2!N132","v":0},{"$f":"InputSheetOp2!O132","v":0},{"$f":"InputSheetOp2!P132","v":0},{"$f":"InputSheetOp2!Q132","v":0},{"$f":"InputSheetOp2!R132","v":0},{"$f":"InputSheetOp2!S132","v":0}]
[null,{"$f":"[1]InputSheetOp2!D77","v":"Podiatrist"},{"$f":"InputSheetOp2!I133","v":0},{"$f":"InputSheetOp2!J133","v":0},{"$f":"InputSheetOp2!K133","v":0},{"$f":"InputSheetOp2!L133","v":0},{"$f":"InputSheetOp2!M133","v":0},{"$f":"InputSheetOp2!N133","v":0},{"$f":"InputSheetOp2!O133","v":0},{"$f":"InputSheetOp2!P133","v":0},{"$f":"InputSheetOp2!Q133","v":0},{"$f":"InputSheetOp2!R133","v":0},{"$f":"InputSheetOp2!S133","v":0}]
[null,{"$f":"[1]InputSheetOp2!D78","v":"DSN"},{"$f":"InputSheetOp2!I134","v":3},{"$f":"InputSheetOp2!J134","v":3.641645211993207},{"$f":"InputSheetOp2!K134","v":1.6461465072557528},{"$f":"InputSheetOp2!L134","v":0},{"$f":"InputSheetOp2!M134","v":0},{"$f":"InputSheetOp2!N134","v":0},{"$f":"InputSheetOp2!O134","v":0},{"$f":"InputSheetOp2!P134","v":0},{"$f":"InputSheetOp2!Q134","v":0},{"$f":"InputSheetOp2!R134","v":0},{"$f":"InputSheetOp2!S134","v":0}]
[null,{"$f":"[1]InputSheetOp2!D79","v":"Add New"},{"$f":"InputSheetOp2!I135","v":0},{"$f":"InputSheetOp2!J135","v":0},{"$f":"InputSheetOp2!K135","v":0},{"$f":"InputSheetOp2!L135","v":0},{"$f":"InputSheetOp2!M135","v":0},{"$f":"InputSheetOp2!N135","v":0},{"$f":"InputSheetOp2!O135","v":0},{"$f":"InputSheetOp2!P135","v":0},{"$f":"InputSheetOp2!Q135","v":0},{"$f":"InputSheetOp2!R135","v":0},{"$f":"InputSheetOp2!S135","v":0}]
[null,{"$f":"[1]InputSheetOp2!D80","v":"Add New"},{"$f":"InputSheetOp2!I136","v":0},{"$f":"InputSheetOp2!J136","v":0},{"$f":"InputSheetOp2!K136","v":0},{"$f":"InputSheetOp2!L136","v":0},{"$f":"InputSheetOp2!M136","v":0},{"$f":"InputSheetOp2!N136","v":0},{"$f":"InputSheetOp2!O136","v":0},{"$f":"InputSheetOp2!P136","v":0},{"$f":"InputSheetOp2!Q136","v":0},{"$f":"InputSheetOp2!R136","v":0},{"$f":"InputSheetOp2!S136","v":0}]
[null,{"$f":"[1]InputSheetOp2!D81","v":"Add New"},{"$f":"InputSheetOp2!I137","v":0},{"$f":"InputSheetOp2!J137","v":0},{"$f":"InputSheetOp2!K137","v":0},{"$f":"InputSheetOp2!L137","v":0},{"$f":"InputSheetOp2!M137","v":0},{"$f":"InputSheetOp2!N137","v":0},{"$f":"InputSheetOp2!O137","v":0},{"$f":"InputSheetOp2!P137","v":0},{"$f":"InputSheetOp2!Q137","v":0},{"$f":"InputSheetOp2!R137","v":0},{"$f":"InputSheetOp2!S137","v":0}]
[null,{"$f":"[1]InputSheetOp2!D82","v":"Add New"},{"$f":"InputSheetOp2!I138","v":0},{"$f":"InputSheetOp2!J138","v":0},{"$f":"InputSheetOp2!K138","v":0},{"$f":"InputSheetOp2!L138","v":0},{"$f":"InputSheetOp2!M138","v":0},{"$f":"InputSheetOp2!N138","v":0},{"$f":"InputSheetOp2!O138","v":0},{"$f":"InputSheetOp2!P138","v":0},{"$f":"InputSheetOp2!Q138","v":0},{"$f":"InputSheetOp2!R138","v":0},{"$f":"InputSheetOp2!S138","v":0}]
[]
[]
[null,null,{"$f":"[1]InputSheetOp2!G29","v":"Total primary care consultations 2017"},{"$f":"[1]InputSheetOp2!H29","v":"Total primary care consultations +X years"}]
[null,null,{"$f":"InputSheetOp2!G30","v":217290.23999999999},{"$f":"InputSheetOp2!H30","v":263764.65403628495}]
[]
[null,null,"Baseline","Future - Do Nothing","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5","Scenario 6","Scenario 7","Scenario 8","Scenario 9"]
[null,{"$f":"InputSheetOp2!H141","v":"System Cost"},{"$f":"InputSheetOp2!I141","v":1752000},{"$f":"InputSheetOp2!J141","v":2126720.803804033},{"$f":"InputSheetOp2!K141","v":1056405.8880956399},{"$f":"InputSheetOp2!L141","v":0},{"$f":"InputSheetOp2!M141","v":0},{"$f":"InputSheetOp2!N141","v":0},{"$f":"InputSheetOp2!O141","v":0},{"$f":"InputSheetOp2!P141","v":0},{"$f":"InputSheetOp2!Q141","v":0},{"$f":"InputSheetOp2!R141","v":0},{"$f":"InputSheetOp2!S141","v":0}]
[null,{"$f":"InputSheetOp2!H142","v":"Per head of population cost "},{"$f":"InputSheetOp2!I142","v":7.7404304951754854},{"$f":"InputSheetOp2!J142","v":9.3959672171740056},{"$f":"InputSheetOp2!K142","v":4.6672581914945388},{"$f":"InputSheetOp2!L142","v":0},{"$f":"InputSheetOp2!M142","v":0},{"$f":"InputSheetOp2!N142","v":0},{"$f":"InputSheetOp2!O142","v":0},{"$f":"InputSheetOp2!P142","v":0},{"$f":"InputSheetOp2!Q142","v":0},{"$f":"InputSheetOp2!R142","v":0},{"$f":"InputSheetOp2!S142","v":0}]

{"sheet":"Piv1","index":6,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["STP","NWL"]
["CCG","Hammersmith and Fulham ",null,null,null,null,null,null,null,null,null,null,"CCG","Hammersmith and Fulham "]
[]
["Average of 2017Dec pop","Average of 5 year %Growth-from GPFV paper","Average of ST3 trainees in practice","Average of %staff over 55","Average of Total Staff FTE GP numbers","Average of FTE nurses","Average of Number of ST3 trainees in each CCG (correct as of July 2017)","Average of new Other Nurse joiner","Average of new Other GP joiner","Average of Population in +5yrs",null,null,"Row Labels","Average of 2017Dec pop","Average of 5 year %Growth-from GPFV paper"]
[226344,4.8122249136356654E-2,14,0.18292682926829268,124.226682305336,45.3899995684624,14,2.9983623221787474,4.9972705369645789,237236.18235851952,null,null,"NWL",226344,4.8122249136356654E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",226344,4.8122249136356654E-2]

{"sheet":"Table","index":7,"n_rows":82,"n_cols":48,"rows_kept":82,"cut":false,"hidden":true,"merged":[[0,23,0,24]]}
["Staff type","CCG","STP","2017Dec pop","2016 Pops","Population in +5yrs","ST3 trainees in practice","%staff over 55","Number of ST3 trainees in each CCG (correct as of July 2017)","5 year %Growth-from GPFV paper","Total Staff FTE GP numbers","new Other GP joiner","new Other Nurse joiner","FTE nurses","a","b","c","d","e","f","g","h",null,"Assumptions-Question to Paul shouldwe put these on the input sheet? Since we are making assumption here-orange/changing cells"]
["GP","Barking and Dagenham ","NEL",222517,203575.06099999999,{"$f":"D2*(1+J2)","v":236288.60825418102},5,0.38095238095238093,5,6.1890139873272743E-2,92.827595941722393,{"$f":"E2/AVERAGE($E$2:$E$33)*$Y$27","v":3.7143226970717431},{"$f":"E2/AVERAGE($E$2:$E$33)*$Y$28","v":2.2285936182430457},39.9499996751547,null,null,null,null,null,null,null,null,null,"ST3 trainees in practice",{"$f":"IF(OR(InputSheetOp1!H20=\"\",InputSheetOp1!H20=0),'Piv1'!$C$5,InputSheetOp1!H20/InputSheetOp1!H19*'Piv1'!$C$5)","v":14},null,"(takes a portion of the trainees if the population is overriden -If not overridden-use the total number of trainees for the chosen borough) The formula  =IF(OR(InputSheetOp1!H20=\"\",InputSheetOp1!H20=0),'Piv1'!$C$5,InputSheetOp1!H20/InputSheetOp1!H19*'Piv1'!$C$5)  "]
["GP","Barnet ","NCL",422435,384204.85399999999,447109.41018383129,22,0.26881720430107525,22,5.8409956996535062E-2,200.858227618039,7.0099981919560141,4.2059989151736081,77.079999193549199,null,null,null,null,null,null,null,null,null,"Total Current Staff FTE-Current GP Supply",{"$f":"InputSheetOp1!$O$96","v":124},null,"InputSheetOp1!$I$123 (picks up baseline figure which they can choose or use the figure calculated by the model)"]
["GP","Bexley ","SEL",240515,244155.81899999999,251673.8035356839,13,0.2592592592592593,13,4.6395457812127727E-2,103.097397956997,4.4547377054885926,2.6728426232931559,56.179999992251403,null,null,null,null,null,null,null,null,null,"%staff over 55",{"$f":"'Piv1'!$D$5","v":0.18292682926829268},null,"Picks the data up directly from the table on the left (through a pivot table) {'Piv1'!$D$5}"]
["GP","Brent ","NWL",377950,328675.07500000001,397717.77804492781,23,0.30569948186528495,23,5.2302627450530048E-2,187.42846643179701,5.9968312672359092,3.5980987603415455,62.329999268054998,null,null,null,null,null,null,null,null,null,"Other GP Leavers (non retirees)",{"$f":"Y3*Y7","v":9.2999999999999989},null,"Y3*Y7 {no need for further weighting as the baseline is picked up from the imput sheet which should already cater for a smaller population if the ppulatin is overriden}"]
["GP","Bromley ","SEL",348410,326803.91399999999,364036.44272228639,17,0.19444444444444442,17,4.4850729664149602E-2,169.48049418395399,5.9626910550800813,3.5776146330480492,59.579998973757,null,null,null,null,null,null,null,null,null,"Percentage over 55 retiring per year",0.18,null,"This is assumed -I think this should/could come to the input sheet as this may vary from borough to borough or from profession to profession (eg when when population is overridden)"]
["GP","Camden ","NCL",283781,238550.26800000001,293388.67898013425,38,0.15942028985507245,38,3.3855962802774808E-2,168.95774500072,4.3524617920902759,2.6114770752541654,51.549999777227598,null,null,null,null,null,null,null,null,null,"Percentage staff (GP or nurse) leaving for other reasons",7.4999999999999997E-2,null,"This is assumed -I think this should/could come to the input sheet as this may vary from borough to borough or from profession to profession (eg when when population is overridden)"]
["GP","Central London (Westminster) ","NWL",227808,314497,236549.66098850357,7,0.22471910112359553,7,3.8372932418982542E-2,101.21242835372701,5.7381456231565222,3.442887373893913,47.109999656677203,null,null,null,null,null,null,null,null,null,"Working Weeks",43,null,"could be made orange-But Paul does not want this to be changeable for now -any assumption on headcount requirement will assume GPs only work43 weeks per year"]
["GP","City and Hackney ","NEL",317246,383532.17700000003,336280.76,19,0.2099,19,0.06,189.26062592864,6.9977248838375017,4.198634930302501,52.43,null,null,null,null,null,null,null,null,null,"Hours worked per week",37.5,null,"could be made orange-But Paul does not want this to be changeable for now-any assumption on headcount requirement will assume GPs only work 37.5 hrs a weeks"]
["GP","Croydon ","SWL",410551,351025.359,430385.85726193187,23,0.27225130890052357,23,4.8312772985407149E-2,201.01133517920999,6.4046227066165873,3.8427736239699524,88.079999580979305,null,null,null,null,null,null,null,null,null,"GP NQ joining per year FTE for borough - HEE Data - Guide",{"$f":"Y2*Y25","v":9.7999999999999989},null,"not referenced/Unused -this formula/info in corporated in other formulas when used"]
["GP","Ealing ","NWL",435566,332075.69199999998,458925.67756067449,13,0.22613065326633167,13,5.36306267263158E-2,196.11204854399,6.0588771231727909,3.6353262739036749,86.889999710023403,null,null,null,null,null,null,null,null,null,"GP NQ joining per year FTE for borough - HEE Data - Guide - Amended to population scale",{"$f":"(InputSheetOp1!$H$20/GETPIVOTDATA(\"Average of 2017Dec pop\",'Piv1'!$A$4))*Y10","v":0},null,"not referenced/Unused -this formula/info in corporated in other formulas when used-not sure if correct anyway"]
["GP","Enfield ","NCL",337683,276090.13900000002,356229.93331974145,10,0.31578947368421051,10,5.4924095437855813E-2,154.985629670322,5.0373943875443192,3.0224366325265919,52.769999608397498,null,null,null,null,null,null,null,null,null,"Other new GP joiners per year FTE",{"$f":"IF(OR(InputSheetOp1!H20=\"\",InputSheetOp1!H20=0),'Piv1'!$I$5,InputSheetOp1!H20/InputSheetOp1!H19*'Piv1'!$I$5)","v":4.9972705369645789},null,"This picks the figure up from the table-average other new joiner per borough is 25 for GPs (and 20 for Nurses) -this then gets apportioned for over-riden population"]
["GP","Greenwich ","SEL",295364,183221.777,313482.27913923428,13,0.328125,13,6.1342205344030676E-2,135.98965106532,3.3429674615640543,2.0057804769384324,59.1199995167553,null,null,null,null,null,null,null,null,null,"CurrentGPCapacity-Baseline",{"$f":"InputSheetOp1!$N$96","v":124},"Stewart just amended these 1May at 14.39pm","(duplicated from Y2) InputSheetOp1!$I$123 (picks up baseline figure which they can choose or use the figure calculated by the model)"]
["GP","Hammersmith and Fulham ","NWL",226344,273891.02600000001,237236.18235851952,14,0.18292682926829268,14,4.8122249136356654E-2,124.226682305336,4.9972705369645789,2.9983623221787474,45.3899995684624,null,null,null,null,null,null,null,null,null,"GP Supply in Year +1",{"$f":"Y13+Z14","v":125.41434370769629},{"$f":"(($Y$2*$Y$25)+Y$12-Y$5)-($Y$13*$Y$4*$Y$6)","v":1.414343707696287},"Stewart said this formula should be [(($Y$2*$Y$21)+Y$12-Y$5)]-however I think it is incorrect as the retirees should also be accounted for-SO-So these supply figures are calculated as; [Trainee count (apportioned if population is overridden) ] multiplied by the [trainee retention rate] PLUS [other joiners (apportioned if population is overridden)] MINUS [other leavers (apportioned if population is overridden)] MINUS [retirees (current/baseline staff multiplied by %staff over 55 multiplied by Percentage over 55 retiring per year]"]
["GP","Haringey ","NCL",316492,252971.07,331888.76679495152,12,0.31818181818181818,12,4.8648202150296083E-2,144.08626034483299,4.6155761044007484,2.7693456626404491,62.149998918175697,null,null,null,null,null,null,null,null,null,"GP Supply in Year +2",{"$f":"Y14+Z14","v":126.82868741539258},{"$f":"(($Y$2*$Y$25)+Y$12-Y$5)-($Y$13*$Y$4*$Y$6)","v":1.414343707696287},"Stewart said this formula should be [(($Y$2*$Y$21)+Y$12-Y$5)]-however I think it is incorrect as the retirees should also be accounted for-SO-So these supply figures are calculated as; [Trainee count (apportioned if population is overridden) ] multiplied by the [trainee retention rate] PLUS [other joiners (apportioned if population is overridden)] MINUS [other leavers (apportioned if population is overridden)] MINUS [retirees (current/baseline staff multiplied by %staff over 55 multiplied by Percentage over 55 retiring per year]"]
["GP","Harrow ","NWL",265538,250935.008,282312.70148877497,15,0.24427480916030536,15,6.317250822396403E-2,136.272930063307,4.5784271959730836,2.7470563175838505,55.529999990016201,null,null,null,null,null,null,null,null,null,"GP Supply in Year +3",{"$f":"Y15+Z15","v":128.24303112308885},1.414343707696287,"Stewart said this formula should be [(($Y$2*$Y$21)+Y$12-Y$5)]-however I think it is incorrect as the retirees should also be accounted for-SO-So these supply figures are calculated as; [Trainee count (apportioned if population is overridden) ] multiplied by the [trainee retention rate] PLUS [other joiners (apportioned if population is overridden)] MINUS [other leavers (apportioned if population is overridden)] MINUS [retirees (current/baseline staff multiplied by %staff over 55 multiplied by Percentage over 55 retiring per year]"]
["GP","Havering ","NEL",277244,298900.85499999998,291885.55530405702,12,0.39215686274509809,12,5.2811080867600557E-2,142.588130421937,5.4535866252332843,3.2721519751399706,61.839999616146102,null,null,null,null,null,null,null,null,null,"GP Supply in Year +4",129.65737483078513,1.414343707696287,"Stewart said this formula should be [(($Y$2*$Y$21)+Y$12-Y$5)]-however I think it is incorrect as the retirees should also be accounted for-SO-So these supply figures are calculated as; [Trainee count (apportioned if population is overridden) ] multiplied by the [trainee retention rate] PLUS [other joiners (apportioned if population is overridden)] MINUS [other leavers (apportioned if population is overridden)] MINUS [retirees (current/baseline staff multiplied by %staff over 55 multiplied by Percentage over 55 retiring per year]"]
["GP","Hillingdon ","NWL",311828,271874.32400000002,327549.57686348545,12,0.28571428571428575,12,5.0417463677044472E-2,128.14292012155099,4.9604748608388576,2.9762849165033147,57.479999758303201,null,null,null,null,null,null,null,null,null,"GP Supply in Year +5",131.07171853848141,{"$f":"(($Y$2*$Y$25)+Y$12-Y$5)-($Y$13*$Y$4*$Y$6)","v":1.414343707696287},"Stewart said this formula should be [(($Y$2*$Y$21)+Y$12-Y$5)]-however I think it is incorrect as the retirees should also be accounted for-SO-So these supply figures are calculated as; [Trainee count (apportioned if population is overridden) ] multiplied by the [trainee retention rate] PLUS [other joiners (apportioned if population is overridden)] MINUS [other leavers (apportioned if population is overridden)] MINUS [retirees (current/baseline staff multiplied by %staff over 55 multiplied by Percentage over 55 retiring per year]"]
["GP","Hounslow ","NWL",313844,222886.848,330788.78762000339,8,0.31683168316831684,8,5.3991115394920408E-2,163.37255097180599,4.0666753301632541,2.4400051980979525,65.019998859614105,null,null,null,null,null,null,null,null,null,"Total Current Staff FTE-Current NURSE Supply",{"$f":"InputSheetOp1!$O$97","v":45}]
["GP","Islington ","NCL",251474,159617.11499999999,259115.49683060707,11,0.18548387096774191,11,3.0386826592836869E-2,141.335729807615,2.9122893058379606,1.7473735835027764,47.6899997889996,null,null,null,null,null,null,null,null,null,"Nurse Other Joiners ",{"$f":"IF(OR(InputSheetOp1!H20=\"\",InputSheetOp1!H20=0),'Piv1'!$H$5,InputSheetOp1!H20/InputSheetOp1!H19*'Piv1'!$H$5)","v":2.9983623221787474},null,"This picks the figure up from the table-average other new joiner per borough is 20 for Nurses (25 for GPs) -this then gets apportioned for over-riden population"]
["GP","Kingston ","SWL",209112,173060.85800000001,218336.8855576574,6,0.19626168224299065,6,4.4114568067147752E-2,111.845867834985,3.1575767173372475,1.8945460304023487,45.169999822974198,null,null,null,null,null,null,null,null,null,"Nurse Other Leavers",{"$f":"Y19*Y7","v":3.375},null,"Y19*Y7  {no need for further weighting as the baseline is picked up from the imput sheet which should already cater for a smaller population if the ppulatin is overriden}"]
["GP","Lambeth ","SEL",410340,324131.00300000003,427262.11452170153,24,0.15217391304347827,24,4.1239251649124009E-2,220.178523242474,5.9139225372381414,3.5483535223428846,74.160000070929499,null,null,null,null,null,null,null,null,null,"Nurse Supply (constant every year)",{"$f":"Y20-Y21","v":-0.37663767782125257}]
["GP","Lewisham ","SEL",329022,298744.56400000001,346865.50987591525,16,0.28089887640449435,16,5.4231965874364851E-2,162.433233961463,5.4507350224593667,3.2704410134756197,66.3899996727705,null,null,null,null,null,null,null,null,null,"BaselineNursePopulation",9,null,"not yet used/referenced for any purpose but it was on the original model`s data back sheet"]
["GP","Merton ","SWL",226428,207868.00099999999,237529.19613498377,12,0.16800000000000001,12,4.9027488362674898E-2,111.531075768173,3.7926494056618836,2.2755896433971303,47.239999756217003,null,null,null,null,null,null,null,null,null,"BaselineHCAPopulation",2,null,"not yet used/referenced for any purpose but it was on the original model`s data back sheet"]
["GP","Newham ","NEL",398140,332321.07699999999,419447.02466542617,11,0.32317073170731708,11,5.351641298394072E-2,173.27943336218601,6.0633542878635138,3.6380125727181083,74.259999111294704,null,null,null,null,null,null,null,null,null,"TraineeRetentionRate",0.7,null,"Paul said may come to the front at some stage - as this may vary from borough to borough or from profession to profession (eg when when population is overridden)"]
["GP","Redbridge ","NEL",318732,302081.81300000002,341380.8947809512,19,0.29268292682926833,19,7.1059368939896839E-2,132.56116823107001,5.5116246994443099,3.3069748196665856,47.7199996039271,null,null,null,null,null,null,null,null,null,"Admin Apportioning",8,null,"Referenced/Used in cell H112 on both input sheets (1/X of the time is spent on admin)-not sure why this info was put on the face of the input sheet though-not used in any other further calculations beside H112 (H112 is not refernced or used further elsewhere). Also non clinical time has already be taken out -so not sure why additional admin time should be shown...I just find the logic strange"]
["GP","Richmond ","SWL",216808,198405.514,228657.89872767348,19,0.22608695652173913,19,5.4656187629946729E-2,115.68869536370001,3.6200018816370907,2.1720011289822541,35.689999848604202,null,null,null,null,null,null,null,null,null,"Average new GP joiner per borough",5,null,"Average new GP joiner per borough AND Average new Nurse joiner per borough are assumed figures and these numbers are picked up by the main table columns L and M-it is weighed across boroughs"]
["GP","Southwark ","SEL",328996,308188.76,343362.01577627944,15,0.2013888888888889,15,4.366623234409972E-2,160.489265888929,5.6230488185897984,3.3738292911538794,70.049999654293103,null,null,null,null,null,null,null,null,null,"Average new Nurse joiner per borough",3,"Op2"]
["GP","Sutton ","SWL",194371,201880.88,203788.67101144005,17,0.25225225225225228,17,4.8452037657058078E-2,95.844801142811804,3.6834115682215951,2.2100469409329571,40.939999908208797,null,null,null,null,null,null,null,null,null,"Overriden Population 5yr growth-assume constant rate",{"$f":"IF(OR(InputSheetOp1!K20=0,InputSheetOp1!K20=\"\",InputSheetOp1!K20=\"-\"),InputSheetOp1!K19,InputSheetOp1!K20)","v":4.8122249136356876E-2},{"$f":"IF(OR(InputSheetOp2!K20=0,InputSheetOp2!K20=\"\",InputSheetOp2!K20=\"-\"),InputSheetOp2!K19,InputSheetOp2!K20)","v":4.8122249136356876E-2},"This number comes from the input sheet(s) (K19 and K20)-if the growth percentage cell for the overridden population growth rate is left blank then use the borough population growth rate WHEN POPULATION IS OVERRIDDEN IT WAS SAID IT HAS TO BE A CONSTANT ASSUMED GROWTH RATE-NOT THE BOROUGH POPULATION GROWTH"]
["GP","Tower Hamlets ","NEL",321811,290632.35800000001,338399.9317942154,15,0.17391304347826086,15,5.1548678554230287E-2,184.851203102618,5.3027240101029882,3.1816344060617929,77.329999990761294,null,null,null,null,null,null,null,null,null,"Appointments per person",6.46,null,"not yet used/referenced for any purpose but it was on the original model`s data back sheet"]
["GP","Waltham Forest ","NEL",310524,275693.36499999999,330102.71991976304,15,0.33035714285714285,15,6.3050585203601184E-2,141.745796069503,5.0301550593743141,3.0180930356245881,55.7699994593859,null,null,null,null,null,null,null,null,null,"Total Patient Facing time per year (hours) -GP",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F96)","v":1128.75},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F96)","v":1209.375},"number of hours of work a GP can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
["GP","Wandsworth ","SWL",401519,320371.32500000001,422168.26962431171,25,0.19502074688796683,25,5.1427876699014829E-2,208.79770061373699,5.8453254445467078,3.5071952667280244,82.109999641776099,null,null,null,null,null,null,null,null,null,"Nurse Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F97)","v":1128.75},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F97)","v":1209.375},"number of hours of work a Nurse can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
["GP","West London ","NWL",248924,238437.02900000001,259709.39098862928,12,0.31578947368421051,12,4.3328047872560616E-2,141.09087927639499,4.3503956932968988,2.6102374159781396,52.959999658167398,null,null,null,null,null,null,null,null,null,"Consultant Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F98)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F98)","v":1370.625},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y3-(Y3*Y7)","v":114.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacist Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F99)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F99)","v":1467.375},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y3*Y7","v":9.2999999999999989}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dietcian  Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F100)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F100)","v":1499.625},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HCA  Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F101)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F101)","v":1515.75},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Psychologist  Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F102)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F102)","v":1483.5},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physician Associate Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F103)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F103)","v":1467.375},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physiotherapist Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F104)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F104)","v":1451.25},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Podiatrist Total Patient Facing time per year (hours)",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F105)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F105)","v":1435.125},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Care Nav Total Patient Facing time per year (hours) DSN",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F106)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F106)","v":1427.0625},"number of hours of work this profesional can dedicate to clinical work per year (Excluding non clinical time -non clinical time is being picked up from the input sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add New",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F107)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F107)","v":1612.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add New",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F108)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F108)","v":1612.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add New",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F109)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F109)","v":1612.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add New",{"$f":"($Y$8*$Y$9)*(1-InputSheetOp1!F110)","v":1370.625},{"$f":"($Y$8*$Y$9)*(1-InputSheetOp2!F110)","v":1612.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These rows were hidden on the input sheet- formulas are ready for checking now"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supply v Demand","Option 1","Option 1","Option 2","Option 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,2021,{"$f":"Y50","v":2016},{"$f":"Z50","v":2021}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gp supply",{"$f":"InputSheetOp1!$D$123","v":124},{"$f":"Y51-(Y51*Y4*Y6)*InputSheetOp1!K18+Y12*InputSheetOp1!K18-Y5*InputSheetOp1!K18+Y2*InputSheetOp1!K18*Y25","v":131.07171853848143},{"$f":"InputSheetOp2!$D$124","v":5.2984381519379848},null,"no supply for Option2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gp demand",{"$f":"InputSheetOp1!$D$123","v":124},{"$f":"IF(OR(InputSheetOp1!H20=0,InputSheetOp1!H20=\"\"),(Y52*(1+Y29)*(1+InputSheetOp1!F30)^InputSheetOp1!K18),Y52*(1+InputSheetOp1!K19)*(1+InputSheetOp1!F30)^InputSheetOp1!K18)","v":150.52133542905258},{"$f":"InputSheetOp2!$D$124","v":5.2984381519379848},{"$f":"IF(OR(InputSheetOp2!H20=0,InputSheetOp2!H20=\"\"),(AA52*(1+Z29)*(1+InputSheetOp2!F30)^InputSheetOp2!K18),AA52*(1+InputSheetOp2!K19)*(1+InputSheetOp2!F30)^InputSheetOp2!K18)","v":6.4316773090156998},"WHEN POPULATION IS OVERRIDDEN IT WAS SAID IT HAS TO BE A CONSTANT ASSUMED GROWTH RATE-NOT THE BOROUGH POPULATION GROWTH (if left blank then use borough rate)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nurse supply",{"$f":"InputSheetOp1!$D$124","v":45},{"$f":"Y53-(Y21*InputSheetOp1!$K$18)+(Y20*InputSheetOp1!$K$18)","v":43.116811610893734},{"$f":"InputSheetOp2!$D$125","v":5.9029579410852708},null,"no supply for Option2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nurse demand",{"$f":"InputSheetOp1!$D$124","v":45},{"$f":"IF(OR(InputSheetOp1!H20=0,InputSheetOp1!H20=\"\"),Y54*(1+Y29)*(1+InputSheetOp1!F30)^InputSheetOp1!$K$18,Y54*(1+InputSheetOp1!K19)*(1+InputSheetOp1!F30)^InputSheetOp1!$K$18)","v":54.624678179898112},{"$f":"InputSheetOp2!$D$125","v":5.9029579410852708},{"$f":"IF(OR(InputSheetOp2!H20=0,InputSheetOp2!H20=\"\"),AA54*(1+Z29)*(1+InputSheetOp2!F30)^InputSheetOp2!$K$18,AA54*(1+InputSheetOp2!K19)*(1+InputSheetOp2!F30)^InputSheetOp2!$K$18)","v":7.1654928409168193},"WHEN POPULATION IS OVERRIDDEN IT WAS SAID IT HAS TO BE A CONSTANT ASSUMED GROWTH RATE-NOT THE BOROUGH POPULATION GROWTH (if left blank then use borough rate)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointments by GP",{"$f":"Y62","v":0.73879679700907575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointments by Nurse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appointments by Other Roles"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total GP Time available",{"$f":"Y51*Y31","v":139965},"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average GP appointment Time (hours)",{"$f":"(InputSheetOp1!D59*InputSheetOp1!F59+InputSheetOp1!D60*InputSheetOp1!F60+InputSheetOp1!D61*InputSheetOp1!F61+InputSheetOp1!D62*InputSheetOp1!F62+InputSheetOp1!D63*InputSheetOp1!F63+InputSheetOp1!D64*InputSheetOp1!F64+InputSheetOp1!D65*InputSheetOp1!F65+InputSheetOp1!D66*InputSheetOp1!F66)/60","v":0.15499999999999997},"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total GP Apps available",{"$f":"Y59/Y60","v":903000.00000000012},"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prop of apps can be taken by GP",{"$f":"Y61/InputSheetOp1!G30","v":0.73879679700907575},"do we need this???-delete it if not needed in the future"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Role","General"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GP",6.69,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diabetes Nurse",8,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consultant",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacist ",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dietcian",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HCA",3,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Psychologist",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physician Associate",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physiotherapist",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Podiatrist",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Care Nav",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Role 12",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Role 13",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Role 14",0,"do we need this???-delete it if not needed in the future"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Role 15",0,"do we need this???-delete it if not needed in the future"]

{"sheet":"RecordSheet2","index":8,"n_rows":189,"n_cols":23,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Future Do Nothing","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5","Scenario 6","Scenario 7","Scenario 8","Scenario 9"]
[null,"Non-Clinical"]
[null,"Voluntary Sector",null,0,0,0,0,0,0,null,null,0]
[null,"Self Care",null,0.5,0.5,0,0,0.5,0,null,null,0.5]
[null,"Patient Led Group",null,0,0,0,0,0,0,null,null,0]
[null,"Social Prescribing",null,0,0,0,0,0,0,null,null,0]
[null,"Care Navigation",null,0,0,0,0,0,0,null,null,0]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[null,"Clinical Time per consultation(mins);"]
[null,"Face to Face",null,10,10,10,10,10,10,null,null,10]
[null,"e-consultation",null,10,10,10,10,10,10,null,null,10]
[null,"Telephone",null,5,5,5,5,5,5,null,null,5]
[null,"Group consultation",null,10,10,10,10,10,10,null,null,10]
[null,"Home Visit",null,20,20,20,20,20,20,null,null,20]
[null,"Email",null,5,5,5,5,5,5,null,null,5]
[null,"Add New",null,5,5,5,5,5,5,null,null,5]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[]
[]
[]
[null,"Roles"]
[null,"GP",null,12.867146415709332,6.4316773090156998,10.857776045186561,20.358330084724802,6.4316773090156998,26.056064090765368,null,null,6.4316773090156998]
[null,"Nurse",null,14.323804500506615,7.1654928409168193,12.096582708060197,22.681092577612866,7.1654928409168193,22.681092577612866,null,null,7.1654928409168193]
[null,"Consultant",null,0,0,0,0,0,0,null,null,0]
[null,"Pharmacist ",null,0.24277634746621382,0.14230424018767679,0.2402340005572659,0.45043875104487358,0.14230424018767679,0.45043875104487358,null,null,0.14230424018767679]
[null,"Dietician",null,0,0,0,0,0,0,null,null,0]
[null,"HCA",null,2.4277634746621382,1.2398635395075246,2.0931026218766045,3.9245674160186321,1.2398635395075246,3.9245674160186321,null,null,1.2398635395075246]
[null,"Psychologist",null,0,0,0,0,0,0,null,null,0]
[null,"Physician Associate",null,0,0,0,0,0,0,null,null,0]
[null,"Physiotherapist",null,0,0,0,0,0,0,null,null,0]
[null,"Podiatrist",null,0,0,0,0,0,0,null,null,0]
[null,"DSN",null,3.641645211993207,1.6461465072557528,2.7789780572937963,5.2105838574258687,1.6461465072557528,5.2105838574258687,null,null,1.6461465072557528]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[null,"Add New",null,0,0,0,0,0,0,null,null,0]
[]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Future Do Nothing","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0]
[]
[null,"Face to Face",0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,"e-consultation",0,0,0,0,0,0,0,0]
[null,"Telephone",0.1,0.1,0.1,0.1,0.1,0.1,0,0]
[null,"Group consultation",0,0,0,0,0,0,0,0]
[null,"Home Visit",0,0,0,0,0,0,0,0]
[null,"Email",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 1","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0]
[]
[null,"Face to Face",0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,"e-consultation",0,0,0,0,0,0,0,0]
[null,"Telephone",0.1,0.1,0.1,0.1,0.1,0.1,0,0]
[null,"Group consultation",0,0,0,0,0,0,0,0]
[null,"Home Visit",0,0,0,0,0,0,0,0]
[null,"Email",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 2","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0]
[]
[null,"Face to Face",0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,"e-consultation",0,0,0,0,0,0,0,0]
[null,"Telephone",0.1,0.1,0.1,0.1,0.1,0.1,0,0]
[null,"Group consultation",0,0,0,0,0,0,0,0]
[null,"Home Visit",0,0,0,0,0,0,0,0]
[null,"Email",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 3","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0]
[]
[null,"Face to Face",0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,"e-consultation",0,0,0,0,0,0,0,0]
[null,"Telephone",0.1,0.1,0.1,0.1,0.1,0.1,0,0]
[null,"Group consultation",0,0,0,0,0,0,0,0]
[null,"Home Visit",0,0,0,0,0,0,0,0]
[null,"Email",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 4","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0]
[]
[null,"Face to Face",0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,"e-consultation",0,0,0,0,0,0,0,0]
[null,"Telephone",0.1,0.1,0.1,0.1,0.1,0.1,0,0]
[null,"Group consultation",0,0,0,0,0,0,0,0]
[null,"Home Visit",0,0,0,0,0,0,0,0]
[null,"Email",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 5","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0]
[]
[null,"Face to Face",0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,"e-consultation",0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0]
[null,"Telephone",0.1,0.1,0.1,0.1,0.1,0.1,0,0,null,null,null,null,null,0.1,0.1,0.1,0.1,null,null,null,6]
[null,"Group consultation",0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0]
[null,"Home Visit",0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0]
[null,"Email",0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0,null,null,null,null,null,0,0,0,0]
[]
[]
[null,null,"Focussed activity","Risk Management"]
[null,"Scenario 6","Diagnostic",0.1,"Maintenance","Treatment","Medicines Optimisation","Risk Management","-",null,null,null,null,null,"Medicines Optimisation","Medicines Optimisation","Medicines Optimisation","Medicines Optimisation","Medicines Optimisation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.1,0.1]
[]
[null,"Face to Face",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,0.9,0.9,null,null,null,7]
[null,"e-consultation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Telephone"]
[null,"Group consultation"]
[null,"Home Visit"]
[null,"Email"]
[null,"Add New"]
[null,"Add New"]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 7","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[]
[]
[null,"Face to Face"]
[null,"e-consultation"]
[null,"Telephone"]
[null,"Group consultation"]
[null,"Home Visit"]
[null,"Email"]
[null,"Add New"]
[null,"Add New"]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 8","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[null,null,0.05,0.25,0.25,0.25,0.1,0.1,0,0]
[]
[null,"Face to Face",0.9,0.9,0.9,0.9,0.9,0.9,0,0]
[null,"e-consultation",0,0,0,0,0,0,0,0]
[null,"Telephone",0.1,0.1,0.1,0.1,0.1,0.1,0,0]
[null,"Group consultation",0,0,0,0,0,0,0,0]
[null,"Home Visit",0,0,0,0,0,0,0,0]
[null,"Email",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[null,"Add New",0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,"Focussed activity"]
[null,"Scenario 9","Diagnostic","Education","Maintenance","Treatment","Medicines Optimisation","Risk Management","-","-"]
[]
[]
[null,"Face to Face"]
[null,"e-consultation"]
[null,"Telephone"]
[null,"Group consultation"]
[null,"Home Visit"]
[null,"Email"]
[null,"Add New"]
[null,"Add New"]