{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Intro","queries about studies","Inputs","Scenario 1","Scenario 2","Scenario 3","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":62,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Worksheet key"]
[null,"Worksheet",null,"Description"]
[]
[null,"Inputs",null,"Contains the inputs for all the scenario analyses "]
[null,"Scenario 1",null,"Scenario 1 analysis"]
[null,"Scenario 2",null,"Scenario 2 analysis"]
[null,"Scenario 3",null,"Scenario 3 analysis"]
[]
[null,"Analysis key"]
[null,null,"Analyses","Description"]
[null,"Scenario 1","Base case ","Scenario 1 - base case results"]
[null,null,"SA1","Varying SWL retreatment/ancillary rates"]
[null,null,"SA2a","Assume have two initial sessions"]
[null,null,"SA2b","Threshold analysis: the cost of 1 session of SWL to make the comparators cost neutral"]
[null,null,"SA3","Pooling retreatment and ancillary procedures"]
[null,null,"SA4","Varying proportion of URS that get stents"]
[null,null,"SA5","Omitting readmission from the analysis"]
[null,null,"SA6","Pooled readmission and major adverse events"]
[null,null,"SA7","Pooled minor and major adverse events (readmissions also excluded)"]
[]
[null,"Scenario 2","Base case","Scenario 2 - base case results"]
[null,null,"QALY threshold analysis","Incremental QALY needed per patient to make URS cost effective"]
[null,null,"QoL gain exploratory analyses","Determining QoL difference needed between stone free and non-stone free patient to make URS cost effective"]
[null,null,"SA8","Varying initial effectiveness of SWL, two way sensitivity analysis varying time and effectiveness"]
[null,null,"SA9a","Assume have two initial sessions"]
[null,null,"SA9b","Threshold analysis: the cost of 1 session of SWL to make the comparators cost neutral"]
[null,null,"SA10","Pooling retreatment and ancillary procedures"]
[null,null,"SA11","Varying proportion of URS that get stents"]
[]
[null,"Scenario 3","Base case","Scenario 3 - base case results"]
[null,null,"Exploratory cost utility analysis","Calculating what the QoL of a non-stone free person needs to be to make URS cost effective"]
[null,null,"SA12","Including fourth line treatments"]
[null,null,"SA13","Varying the effectiveness of the primary SWL"]
[null,null,"SA14","Omitting readmission from the analysis"]
[null,null,"SA15","Pooled readmission and major adverse events"]
[null,null,"SA16","Pooled minor and major adverse events (readmissions also excluded)"]
[null,null,"SA17","Varying proportion of URS that get stents"]
[null,null,"SA18a","Assume have two initial sessions"]
[null,null,"SA18b","Threshold analysis: the cost of 1 session of SWL to make the comparators cost neutral"]

{"sheet":"queries about studies","index":1,"n_rows":158,"n_cols":39,"rows_kept":158,"cut":false,"hidden":true,"merged":[[1,0,2,0],[5,17,5,26],[154,2,154,3],[154,4,154,5],[154,6,154,7],[154,8,154,9],[154,10,154,11],[154,12,154,13]]}
[null,"when is stone free rate being measured?","interventional details","what are ancillary procedures?","any other resource use to consider?","adverse event info","avergae no. of sessions of intervention","notes","queries for sophie",null,"more info about SWL group secondary treatments","more information about UrS group secondary treatments",null,"further info"]
["Hendrix 1999\n\nthe netherlands\n\n3 months","INITIAL STONE FREE RATE","seems to imply after 1 SWL session.\n\nRefers to a mobile lithotriptor.","review is treating ancillary procedures as anything that isnt a repeat of the interventional procedures, so could be URS, PCNL, SWL. But this doesnt include stents (checked this with sophie). \nHow will we cost this up? Maybe take an average of procedure costs? would things like stents after a URS be included in teh NHS ref cost anyway?","what about imaging after an SWL as another appointment to confirm stone has gone? This is probably not included in NHS ref SWL cost as would be a seprate follow up.\n","reports minor (bleeding) and major (perforation)",1,"No. of procedures is the outcome. But also states that 31 of 69 people after SWL needed frther treatment, and 8 of 87 after URS.\n31 patients in SWL required 37 extra treatments, and the 8 in URS needed 9 extra treatments. definition of auxillary procedure quite open as can be anyhting from stent/catheter to open surgery/PCNL.","should the effectiveness of the initial SWL be 38 rather than 35? (this would be for all the groups together",null,"the 31 patients that needed further treatment in SWL required 37 extra treatments","the 8 pateitns that needed further treatment needed 9 extra treatments",null,null,null,null,null,"changed this"]
[null,null,null,null,null,null,null,null,"\"the outcome was determined on a regularly planned outpatient visit 2 weeks after treatment in 77.5%, and 12 weeks after treatment in 16.6%, and during an intercurrent visit or after calling in 5.7%\". The outcome must be stone free as this is being talked about in teh prior sentence.",null,null,null,null,null,"do we need to rethink the outcome timeframe of this study?",null,null,"leave as is"]
[null,null,null,null,null,null,null,null,"is this study too old - maybe SWL machines have changed?",null,null,null,null,null,null,null,null,"sophie to check"]
[null,null,null,null,null,null,null,null,null,null,"from the study;"]
[null,null,null,null,null,null,null,null,null,"total number of procedures per treatment sequence","1st Tx ","2nd Tx","3rd Tx","no. of people",null,"total stone free",null,"the 'total stone free' doesn’t match the resource use, so can I assume that those who don’t go onto a third suquence are stone free, but some of those who have a third line treatment must not be stone free. But I don’t know who from either the third line following a second line retreatmetn or a second line ancillary are the ones that failed."]
[null,null,null,null,null,null,null,null,"SWL",1,"SWL","-","-",38]
[null,null,null,null,null,null,null,null,null,2,"SWL","SWL","-",5,null,null,null,null,"initial Tx",null,"2nd Tx",null,"3rd Tx",null,"people","prob",null,null,null,null,"initial Tx",null,"2nd Tx",null,"3rd Tx",null,"people","prob"]
[null,null,null,null,null,null,null,null,null,3,"SWL","SWL","URS",2,null,null,{"$f":"N16","v":69},"SWL","SF",null,null,null,null,null,{"$f":"N7","v":38},{"$f":"Y9/Q9","v":0.55072463768115942},"first line SF",null,{"$f":"N22","v":87},"URS","SF",null,null,null,null,null,{"$f":"N18","v":79},{"$f":"AK9/AC9","v":0.90804597701149425},"first line SF"]
[null,null,null,null,null,null,null,null,null,3,"SWL","SWL","open surgery",1,null,null,null,null,"NSF",null,null,null,null,null,{"$f":"Q9-Y9","v":31},{"$f":"Y10/Q9","v":0.44927536231884058},null,null,null,null,"NSF",null,null,null,null,null,{"$f":"AC9-AK9","v":8},{"$f":"AK10/AC9","v":9.1954022988505746E-2}]
[null,null,null,null,null,null,null,null,null,2,"SWL","URS","-",16,null,null,null,null,null,"retreat",null,null,null,null,{"$f":"SUM(N8:N10)","v":8},{"$f":"Y11/Y10","v":0.25806451612903225},null,null,null,null,null,"retreat",null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,3,"SWL","URS","URS",1,null,null,null,null,null,null,"SF",null,null,null,{"$f":"N8","v":5},{"$f":"Y12/Y11","v":0.625},"retreatment SF",null,null,null,null,null,"SF",null,null,null,0,0,"no retreatment"]
[null,null,null,null,null,null,null,null,null,3,"SWL","URS","open surgery",2,null,null,null,null,null,null,"NSF",null,null,null,{"$f":"SUM(N9:N10)","v":3},{"$f":"Y13/Y11","v":0.375},null,null,null,null,null,null,"NSF",null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,2,"SWL","open surgery","-",1,null,null,null,null,null,null,null,"anc",null,null,{"$f":"(N9+N10)","v":3},null,null,null,null,null,null,null,null,"anc"]
[null,null,null,null,null,null,null,null,null,2,"SWL","PNL","-",3,null,null,null,null,null,null,null,null,"SF",null,"?","?","3rd line ancillary SF",null,null,null,null,null,null,null,"SF"]
[null,null,null,null,null,null,null,null,"total",{"$f":"SUMPRODUCT(J7:J15,N7:N15)","v":106},null,null,null,{"$f":"SUM(N7:N15)","v":69},"patients",64,{"$f":"P16/N16","v":0.92753623188405798},null,null,null,null,null,"NSF",null,"?","?",null,null,null,null,null,null,null,null,"NSF"]
[]
[null,null,null,null,null,null,null,null,"URS",1,"URS","-","-",79,null,null,null,null,null,"anc",null,null,null,null,{"$f":"SUM(N11:N15)","v":23},{"$f":"Y18/Y10","v":0.74193548387096775},null,null,null,null,null,"anc",null,null,null,null,{"$f":"SUM(N19:N21)","v":8},{"$f":"AK18/AC9","v":9.1954022988505746E-2}]
[null,null,null,null,null,null,null,null,null,2,"URS","SWL","-",5,null,null,null,null,null,null,"SF",null,null,null,{"$f":"(N11+N14+N15)","v":20},{"$f":"Y19/Y18","v":0.86956521739130432},"ancillary stone free",null,null,null,null,null,"SF",null,null,null,{"$f":"SUM(N19+N21)","v":7},{"$f":"AK19/AK18","v":0.875},"ancillary stone free"]
[null,null,null,null,null,null,null,null,null,3,"URS","SWL","URS",1,null,null,null,null,null,null,"NSF",null,null,null,{"$f":"SUM(N12+N13)","v":3},{"$f":"Y20/Y18","v":0.13043478260869565},null,null,null,null,null,null,"NSF",null,null,null,{"$f":"N20","v":1},{"$f":"AK20/AK18","v":0.125}]
[null,null,null,null,null,null,null,null,null,2,"URS","PNL","-",2,null,null,null,null,null,null,null,"anc",null,null,null,null,null,null,null,null,null,null,null,"anc",null,null,{"$f":"N20","v":1}]
[null,null,null,null,null,null,null,null,"total",{"$f":"SUMPRODUCT(J18:J21,N18:N21)","v":96},null,null,null,{"$f":"SUM(N18:N21)","v":87},"patients",86,{"$f":"P22/N22","v":0.9885057471264368},null,null,null,null,null,"SF",null,"?","?","3rd line ancillary SF",null,null,null,null,null,null,null,"SF",null,"?","?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NSF",null,"?","?",null,null,null,null,null,null,null,null,"NSF",null,"?","?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SWL","URS"]
[null,null,null,null,null,null,null,null,null,null,"initial stone free",null,{"$f":"N7","v":38},{"$f":"N18","v":79},null,null,null,null,null,"separate out PCNL as well?"]
[null,null,null,null,null,null,null,null,null,null,"retreatments reported in review",null,{"$f":"N8+N9+N10","v":8},{"$f":"N20","v":1}]
[null,null,null,null,null,null,null,null,"if someone had an ancillary twice (so both second and third line then should we count this - I think this is what I meant to ask sophie about)",null,"ancillaries reported in review",null,{"$f":"N9+N10+N11+N12+N13++N14+N15","v":26},{"$f":"N19+N20+N21","v":8}]
[null,null,null,null,null,null,null,null,"As with above we are double counting people for retreatments and ancillaries, but not within the same outcome e.g. ancillares",null,"number of people",null,{"$f":"SUM(M25:M27)","v":72},{"$f":"SUM(N25:N27)","v":88},"over counting people here for SWL!",null,"But maybe that way the assumption will still stand that everyone will end up stone free if we overestimate costs a bit instead of underestimate?"]
[null,null,null,null,null,null,null,null,null,null,"ancillaries that could be reported? - ",null,{"$f":"N9+N10+N11+(N12*2)+(N13*2)+N14+N15","v":29},{"$f":"N19+N20+N21","v":8},"if counting number of procedures"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M25+(69-M25)+M26+M29","v":106},{"$f":"N25+(87-N25)+N26+N29","v":96},"total number of procedures"]
[]
[]
["Kumar 2015\n\n3 months","IMPLIES INTIAL STONE FREE RATE AS SAYS 'STONE FREE AFTER INITIAL SWL SESSION OR URS WAS DEFINED AS RADIOLOGIC ABSENCE OF A STONE…AT 3 MONTHS'","a max of 4 sessions of SWL were given so unclear. 'retreatment SWL given for incomplete clearance' - so can we assume 1 was given initally and up to 3 more could be retreatment?","URS and PCNL were auxillary procedures performed after failed SWL","all URS's had a stent. May not need to consider insertion cost but probably removal cost?\n\nWould some SWL's have a stent?","reports a minor of UTI. No majors.","?","retreatment rate as a percentage is the outcome rather than number of people that had a retreatment",null,null,null,null,null,"\"modified EQ was used to distinguish between patients who became stone free by SWL/URS alone and those who were stone free by an auxillary procedure\"","can we back calculate from this?"]
[]
[null,null,null,null,null,null,null,null,null,null,"EQ is calculated using the formula: Stone free (%) × 100/(100 + retreatment rate (%) + auxiliary procedures (%)."]
[null,null,null,null,null,null,null,null,null,null,"EQ modified = % stone-free patients -\n% of curative auxiliary measures/100% + %\nof repeat SWL +  % of pre-SWL auxiliary measures  \n+ % of post-SWL adjuvant measures"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"SWL","URS"]
[null,null,null,null,null,null,null,null,null,"no. of poeple",53,49]
[null,null,null,null,null,null,null,null,null,"retreatment rate",{"$f":"25/53","v":0.47169811320754718},{"$f":"3/L41","v":6.1224489795918366E-2}]
[null,null,null,null,null,null,null,null,null,"auxillary rate",{"$f":"9/K41","v":0.16981132075471697},{"$f":"4/L41","v":8.1632653061224483E-2}]
[null,null,null,null,null,null,null,null,null,"stone free rate 3 months",{"$f":"45/K41","v":0.84905660377358494},{"$f":"43/L41","v":0.87755102040816324},45,43]
[null,null,null,null,null,null,null,null,"does sophie know how they get this?","modified EQ",0.69099999999999995,0.89200000000000002]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K42:K44)","v":1.4905660377358489},{"$f":"SUM(L42:L44)","v":1.0204081632653061}]
[]
[null,null,null,null,null,null,null,null,"EQ equation:","denominator",{"$f":"1+K42+K43","v":1.6415094339622642},{"$f":"1+L42+L43","v":1.142857142857143}]
[null,null,null,null,null,null,null,null,null,"modified EQ",0.69099999999999995,{"$f":"L45","v":0.89200000000000002}]
[null,null,null,null,null,null,null,null,null,"stone free?",{"$f":"K50*K49","v":1.1342830188679245},{"$f":"L50*L49","v":1.0194285714285716},null,"doesn’t make sense"]
[]
[null,null,null,null,null,null,null,null,"if assume stone free rate is the initial one",null,{"$f":"K44/(1+K42+K43)","v":0.51724137931034486},{"$f":"L44/(1+L42+L43)","v":0.76785714285714268}]
[]
[null,null,null,null,null,null,null,null,"modified EQ"]
[null,null,null,null,null,null,null,null,"don’t have all the other parts of the equation?",null,{"$f":"(K44+K42)/(1+K43)","v":1.1290322580645162},{"$f":"(L44+L42)/(1+L43)","v":0.86792452830188671}]
[null,null,null,null,null,null,null,null,"but text in kumar implies retreatments are included in the numerator? "]
[]
[null,null,null,null,null,null,null,null,"or does this mean stone free rate includes retreatments?",null,{"$f":"K44/(1+K43)","v":0.72580645161290325},{"$f":"L44/(1+L43)","v":0.81132075471698106}]
[]
[null,null,null,null,null,null,null,null,"checking assumption that adding resource use will get everyone stone free if it’s the initial stone free rate;"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K42:K44)","v":1.4905660377358489},{"$f":"SUM(L42:L44)","v":1.0204081632653061},null,"sort of applies to URS, bt not so much to SWL, and this may be to do with the number of session of SWL"]
[]
[null,"unclear if people could have had more than one retreatment/ancillary."]
[null,"unclear if everyone is stone free at end"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"SWL","URS"]
["Zhang 2011","SAYS INITIAL STONE FREE RATE","seems to imply 1 SWL",null,"stent left after URS. Seems to be stent or SWL done as ancillary after failed URS.","need to double check classifications of major and minor",1,"number of peole reported that had retreatment/ancillaries not number of procedures.\nRetreat and ancillary seem to be different not seqeuntial.",null,null,"URS is the ancillary for SWL.","SWL is the auxillary procedure. So if anyhting we have overestimted costs for that in the costing?"]
[null,null,null,null,null,null,null,null,null,"no of people",257,269]
[null,null,null,null,null,null,null,null,null,"initial SF",227,250]
[null,"2 wk timeframe",null,null,null,null,null,null,null,"non SF",{"$f":"K71-K72","v":30},{"$f":"L71-L72","v":19}]
[]
[null,null,null,null,null,null,null,null,null,"second SWL",20,null,null,{"$f":"K75/K71","v":7.7821011673151752E-2}]
[null,null,null,null,null,null,null,null,null,"second URS",null,0]
[null,null,null,null,null,null,null,null,null,"ancillary = SWL",null,11]
[null,null,null,null,null,null,null,null,null,"ancillary URS",4,null,null,{"$f":"K78/K71","v":1.556420233463035E-2},{"$f":"(K72/K71)","v":0.88326848249027234},{"$f":"O78/(1+N75+N78)","v":0.80782918149466199}]
[null,null,null,null,null,null,null,null,null,"total procedures",{"$f":"(K71*1)+SUM(K75:K78)","v":281},{"$f":"(L71*1)+SUM(L75:L78)","v":280}]
[null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(K75:K78)","v":24},{"$f":"SUM(L75:L78)","v":11}]
[]
[null,null,null,null,null,null,null,null,null,null,"extra 6 just had fever","extra 8 were either managed with stents or drugs",null,null,"I am already assuming a certain proportion of stent use, so I can just vary that in an SA?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"but the study aslo says DJ stent was left universally for 2-4 weeks after URL."]
[null,"ASSUMPTION STANDS OF EVERYONE BEING STONE FREE AFTER RESOURCE USE"]
[]
[]
["Sarica 2017","doesn’t actually say but implied initial because describes how the failures were treated.","says a 'single session' in the discussion.","not relevant if after the outcome measured?\n\nStates that \"patients requiring stent and/or auxillaries were excluded due to possible effects of these o QoL\" - bias _ oversteimate effectiveness and underestimate ancillaries?",null,null,1,"Number of people needing retreatments that is reported rather than number of procedures.\nEach arm had either all retreatment for failures or all ancillareis so confusion between these being sequential or not is a not a problem.",null,null,"SWL","URS"]
[null,null,null,null,null,null,null,null,null,"no of people",34,31]
[null,"4 wk timeframe",null,null,null,null,null,null,null,"initial SF",25,26]
[null,null,null,null,null,null,null,null,null,"non SF",{"$f":"K88-K89","v":9},{"$f":"L88-L89","v":5}]
[]
[null,null,null,null,null,null,null,null,null,"second SWL"]
[null,null,null,null,null,null,null,null,null,"second URS",null,5,null,null,{"$f":"L93/L88","v":0.16129032258064516}]
[null,null,null,null,null,null,null,null,null,"ancillary = SWL"]
[null,null,null,null,null,null,null,null,null,"ancillary URS",9,null,null,{"$f":"K95/K88","v":0.26470588235294118}]
[null,null,null,null,null,null,null,null,null,"total procedures",{"$f":"(K88*1)+SUM(K92:K95)","v":43},{"$f":"(L88*1)+SUM(L92:L95)","v":36}]
[null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(K92:K95)+K89","v":34},{"$f":"SUM(L92:L95)+L89","v":31}]
[]
[]
[null,"ASSUMPTION STANDS OF EVERYONE BEING STONE FREE AFTER RESOURCE USE"]
[]
[]
[]
["Salem 2009","says stone free rate after primary procedure","as outcomes are after initial procedure then can we assume 1 SWL?","not relevant if after the outcome measured?","stents left in pateints with large stones/extravasations","has some complication outcomes but doesnt say what stone size group relates to? - check with sophie",1,"Number of people needing retreatments that is reported rather than number of procedures.\nRetreat and ancillaries talked about as if they are separate and not seequential.",null,null,"SWL","URS"]
[null,null,null,null,null,null,null,null,null,"no of people",58,52]
[null,null,null,null,null,null,null,null,null,"initial SF",46,52]
[null,"2 wk timeframe",null,null,null,null,null,null,null,"non SF",{"$f":"K105-K106","v":12},{"$f":"L105-L106","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"second SWL",10,null,null,{"$f":"K109/K105","v":0.17241379310344829}]
[null,null,null,null,null,null,null,null,null,"second URS"]
[null,null,null,null,null,null,null,null,null,"ancillary = SWL"]
[null,null,null,null,null,null,null,null,null,"ancillary URS",2,null,null,{"$f":"K112/K105","v":3.4482758620689655E-2}]
[null,null,null,null,null,null,null,null,null,"total procedures",{"$f":"(K105*1)+SUM(K109:K112)","v":70},{"$f":"(L105*1)+SUM(L109:L112)","v":52}]
[null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(K109:K112)+K106","v":58},{"$f":"SUM(L109:L112)+L106","v":52}]
[]
[]
[null,"ASSUMPTION STANDS OF EVERYONE BEING STONE FREE AFTER RESOURCE USE"]
[]
[]
[]
["Verze 2010","stone free rate AFTER retreatments/ancillaries","retreatments are reported and included so doesn’t need to be factored into average number of sessions.","ancillary procedures reported as stenting so shouldn’t be inlcuded as reviewers arent coungting that as ancillary. It does talk about the failed SWL's having URS but that seems to be the same number that werent stone free so that would be double counting again.\nSays \"the need for SWL or ureterolithotomy in URS group and need for URS and ureterolith... in SWL groups were considered failures.\" so are these the ancilllary procedures being defined?",null,"has some complication outcomes but desont say what stone size group relates to? - check with sophie","1.5823 average number of sessions to clear the stone?","reported for the whole study not just the small stone group; 'in 70 cases (55.11%) one SWL session was enough to clear stone, in 31.49% it was 2, and in 13.38% it was 3. = average of around 1.5 sessions. Number of people needing retreatments that is reported rather than number of procedures.\nancillaries not extracted from here anyway as its about stents",null,null,"SWL","URS",null,"the study reports outcomes of 'overall stone free', 'stone free requiring retreatments', and 'stone free requiring auxillary procedures'.\nCould the initial stone free rate be backcalculated from this?"]
[" ",null,null,null,null,null,null,null,null,"no of people",69,66]
[]
[null,null,null,null,null,null,null,null,null,"overall SF (at 3 months)",66,63]
[null,null,null,null,null,null,null,null,null,"SF requiring retreat",8,3,null,"could also include people that had more than 2 sessions"]
[null,null,null,null,null,null,null,null,null,"SF requiring ancillaries",null,null,null,"stents"]
[]
[null,null,null,null,null,null,null,null,null,"still need Tx at 3 months",{"$f":"K122-K124","v":3},{"$f":"L122-L124","v":3}]
[]
[null,null,null,null,null,null,null,null,null,"=retreat + ancill",{"$f":"SUM(K125:K126)","v":8},{"$f":"SUM(L125:L126)","v":3},null,"assuming no overlap between ancillaries and retreatments (i.e. assume mutually exclusive)"]
[null,null,null,null,null,null,null,null,null,"initial effectiveness",{"$f":"K124-K130","v":58},{"$f":"L124-L130","v":60}]
[null,null,null,null,null,null,null,null,null,"%",{"$f":"K131/K122","v":0.84057971014492749},{"$f":"L131/L122","v":0.90909090909090906},null,"don’t know how many stone free, one reason is because don’t count stents procedures as ancillaries, and secondly"]
[]
[null,null,null,null,null,null,null,null,null,"3 month SF %",{"$f":"K124/K122","v":0.95652173913043481},{"$f":"L124/L122","v":0.95454545454545459}]
[null,"NOT EVERYONE STONE FREE AT END OF TRIAL"]
[]
[]
[]
["Pearle 2001","must be included as timepoint of 3 months but no retreatment or ancillary procedures reported. Unless primary treatments effective for all.","doesn’t mention any","most URS's had stents after (91%)","1 minor of a fever.","?"]
[null,"there is no retreatment/ancillaries reported so this study has no secondary treatment outcomes."]
[null,null,null,null,null,null,null,null,"is this study too old - maybe SWL machines have changed?"]
[]
[null,"unclear if initial stone free rates or how many procedures"]
[]
[]
[]
["Study summaries for report"]
[]
["study ",null,"Hendrikx 1999",null,"Salem 2009",null,"Sarica 2017",null,"Zhang 2011",null,"Kumar 2015A",null,"Verze 2010",null,"Pearle 2001"]
["timeframe",null,"3 months",null,"2 weeks",null,"4 weeks",null,"2 weeks",null,"3 months",null,"3 months",null,"3 months"]
["reporting number initial SF ",null,"yes",null,"yes",null,"yes",null,"yes",null,"unclear",null,"no",null,"unclear"]
["reporting retreatments",null,"yes",null,"yes",null,"yes",null,"yes",null,"yes",null,"yes",null,"no"]
["reporting ancillary procedures",null,"yes",null,"yes",null,"yes",null,"yes",null,"yes",null,"no",null,"no"]
["reporting outcome as people or procedure numbers",null,"both",null,"people",null,"people",null,"people",null,"unclear",null,"unclear",null,"people"]
["protocol for further treatment",null,"no special criteria. ",null,"no criteria stated. ",null,"no criteria stated. "]
[null,null,"SWL","URS","SWL","URS","SWL","URS","SWL","URS","SWL","URS","SWL","URS","SWL","URS"]
[null,null,"most people failing SWL had ancillaries.","most people failing primary URS got other procedures except for 1. ","mostly retreatments",null,"those in SWL arm that failed were treated with URS","those in URS arm that failed were treated with URS again.","repeat SWL or URS were performed when residual fragments remained.","URS patients had auxiliary SWL when there were residual fragments.","Retreatment of SWL given for incomplete clearance. URS and PCNL were auxiliary procedures after failed SWL.","not specified","If significant fragments remained after first treatment of SWL, patients were instructed to return for a further session. The need for URS or ureterolithotomy in SWL group were recorded as treatmet failures.","The need for SWL or ureterolithotomy in URS group were recorded as treatmet failures.","NA","NA"]
["SWL intervention information",null,"Seems to imply after 1 SWL session from the use of the word ‘initial’.\nRefers to a mobile lithotriptor.\n",null,"Seems to imply after 1 SWL session from the use of the word ‘initial’.",null,"Says a 'single session' in the discussion.",null,"Seems to imply after 1 SWL session from the use of the word ‘initial’.",null,"Unclear how many sessions on average. States a max of 4 sessions of were given. 'retreatment SWL given for incomplete clearance'.",null,"1.5823 average number of sessions to clear the stone?\nreported for the whole study not just the small stone group; 'in 70 cases (55.11%) one SWL session was enough to clear stone, in 31.49% it was 2, and in 13.38% it was 3. = average of around 1.5 sessions. Number of people needing retreatments that is reported rather than number of procedures.",null,"no mention of number of session"]

{"sheet":"Inputs","index":2,"n_rows":238,"n_cols":42,"rows_kept":238,"cut":false,"hidden":false,"merged":[[108,0,108,1],[69,6,69,7],[69,8,69,9],[69,10,69,11],[74,0,76,0],[77,0,79,0],[86,8,86,15],[105,14,110,15],[106,0,106,1],[105,5,110,6],[71,0,73,0],[86,2,86,3],[86,5,86,6],[69,12,69,13],[69,14,69,15],[119,36,119,53],[119,18,119,35],[150,18,154,18],[144,10,144,15],[145,10,145,12],[145,13,145,15],[144,19,144,24],[145,19,145,21],[145,22,145,24],[144,28,144,33],[145,28,145,30],[145,31,145,33],[150,0,154,0],[144,1,144,6],[145,1,145,3],[145,4,145,6],[88,0,88,1],[109,0,109,1],[110,0,110,1],[119,0,119,17],[98,5,100,6],[98,14,100,15],[89,8,90,8],[91,8,96,8],[90,0,92,0],[104,0,104,1],[105,0,105,1],[107,0,107,1],[51,0,53,0],[68,2,68,3],[68,4,68,5],[68,6,68,7],[68,8,68,9],[67,6,67,7],[67,8,67,9],[68,10,68,11],[68,12,68,13],[68,14,68,15],[9,18,9,20],[9,21,9,23],[67,10,67,11],[67,12,67,13],[67,14,67,15],[9,24,9,26],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[13,0,16,0],[17,0,19,0],[20,0,22,0],[23,0,25,0],[26,0,28,0],[29,0,31,0],[67,0,69,0],[67,2,67,3],[67,4,67,5],[69,2,69,3],[69,4,69,5],[33,0,35,0],[36,0,38,0],[42,0,44,0],[39,0,41,0],[45,0,47,0],[54,0,56,0],[57,0,59,0],[60,0,62,0],[63,0,65,0],[48,0,50,0]]}
["CLINICAL DATA"]
[]
["Original Data"]
[]
[null,"Raw trial data"]
[null,"feeding into model"]
[]
[]
[null,"Study","Hendrikx 1999",null,"Salem 2009",null,"Sarica 2017",null,"Zhang 2011",null,"Kumar 2015A",null,"Verze 2010",null,"Pearle 2001",null,null,null,"Pooled data"]
[null,"Timeframe","3 months",null,"2 weeks",null,"4 weeks",null,"2 weeks",null,"3 months",null,"3 months",null,"3 months",null,null,null,"Scenario 1",null,null,"Scenario 2",null,null,"Scenario 3"]
[null,"Intervention","SWL","URS","SWL","URS","SWL","URS","SWL","URS","SWL","URS","SWL","URS","SWL","URS",null,null,"URS","RR","SWL","URS","RR","SWL","URS","RR","SWL"]
[null,"Total participants",69,87,58,52,34,31,257,269,53,49,69,66,29,29,null,null,null,null,null,{"$f":"SUM(F12,H12,J12)","v":352}]
["OUTCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,32,32]
["STONE FREE","Events",38,79,46,52,25,26,227,250,45,43,66,63,29,29,null,null,null,null,null,{"$f":"SUM(F14,H14,J14)","v":328}]
[null,"Probability",{"$f":"C14/C12","v":0.55072463768115942},0.90804597701149425,0.7931034482758621,1,0.73529411764705888,0.83870967741935487,0.88326848249027234,0.92936802973977695,0.84905660377358494,0.87755102040816324,0.95652173913043481,0.95454545454545459,1,1,null,null,null,null,null,{"$f":"V14/V12","v":0.93181818181818177},0.88,{"$f":"V15*W15","v":0.82}]
[null,"What outcome is it reporting?","initial stone free",null,"initial stone free",null,"initial stone free",null,"initial stone free",null,"unclear",null,"NOT initial stone free",null,"unclear - but no retreat/anc reported"]
[null,"% stone free at end of study",0.93,0.99,1,1,1,1,1,1,"Unclear","Unclear",0.96,0.95,1,1]
["RETREATMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"SUM(D12,F12,H12,J12,L12,N12)","v":554},null,null,{"$f":"V12","v":352}]
[null,"Events",8,1,10,0,0,5,20,0,25,3,8,3,"NR","NR",null,null,{"$f":"SUM(D19,F19,H19,J19,L19,N19)","v":12},null,null,{"$f":"SUM(F19,H19,J19)","v":5}]
[null,"Probability",{"$f":"C19/C12","v":0.11594202898550725},{"$f":"D19/D12","v":1.1494252873563218E-2},0.17241379310344829,0,0,0.16129032258064516,7.7821011673151752E-2,0,0.47169811320754718,6.1224489795918366E-2,0.11594202898550725,4.5454545454545456E-2,null,null,null,null,{"$f":"S19/S18","v":2.1660649819494584E-2},5.01,{"$f":"S20*T20","v":0.10851985559566786},{"$f":"V19/V18","v":1.4204545454545454E-2},4.0999999999999996,{"$f":"V20*W20","v":5.8238636363636354E-2}]
["ANCILLARY PROCEDURES ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"SUM(D12,F12,H12,J12,L12,N12)","v":554},null,null,{"$f":"V12","v":352}]
[null,"Events",29,8,2,0,9,0,4,11,9,4,0,0,"NR","NR",null,null,{"$f":"SUM(D22,F22,H22,J22,L22,N22)","v":23},null,null,{"$f":"SUM(F22,H22,J22)","v":11}]
[null,"Probability",{"$f":"C22/C12","v":0.42028985507246375},{"$f":"D22/D12","v":9.1954022988505746E-2},3.4482758620689655E-2,0,0.26470588235294118,0,1.556420233463035E-2,4.0892193308550186E-2,0.16981132075471697,8.1632653061224483E-2,{"$f":"M22/M12","v":0},{"$f":"N22/N12","v":0},null,null,null,null,{"$f":"S22/S21","v":4.1516245487364621E-2},2.38,{"$f":"S23*T23","v":9.8808664259927792E-2},{"$f":"V22/V21","v":3.125E-2},2.44,{"$f":"V23*W23","v":7.6249999999999998E-2}]
["READMISSIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"P13","v":32}]
[null,"Events","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR",2,4,null,null,{"$f":"P25","v":4}]
[null,"Probability",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O25/O13","v":6.25E-2},{"$f":"P25/P13","v":0.125},null,null,{"$f":"S25/S24","v":0.125},0.5,{"$f":"S26*T26","v":6.25E-2},{"$f":"S26","v":0.125},null,{"$f":"U26","v":6.25E-2}]
["MINOR ADVERSE EVENTS","Total participants",null,null,100,100,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"SUM(D12,F27,J12,L12,P13)","v":537}]
[null,"Events",1,0,0,6,"NR","NR",6,4,0,1,"NR","NR",0,1,null,null,{"$f":"SUM(D28,F28,J28,L28,P28)","v":12}]
[null,"Probability",{"$f":"C28/C12","v":1.4492753623188406E-2},{"$f":"D28/D12","v":0},{"$f":"E28/E27","v":0},{"$f":"F28/F27","v":0.06},null,null,{"$f":"I28/I12","v":2.3346303501945526E-2},{"$f":"J28/J12","v":1.4869888475836431E-2},0,2.0408163265306121E-2,null,null,{"$f":"O28/O13","v":0},{"$f":"P28/P13","v":3.125E-2},null,null,{"$f":"S28/S27","v":2.23463687150838E-2},0.67,{"$f":"S29*T29","v":1.4972067039106146E-2},{"$f":"S29","v":2.23463687150838E-2},null,{"$f":"U29","v":1.4972067039106146E-2}]
["MAJOR ADVERSE EVENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"SUM(D12,J12)","v":356}]
[null,"Events",0,9,"NR","NR","NR","NR",0,3,"NR","NR","NR","NR","NR","NR",null,null,{"$f":"SUM(D31,J31)","v":12}]
[null,"Probability",{"$f":"C31/C12","v":0},{"$f":"D31/D12","v":0.10344827586206896},null,null,null,null,{"$f":"I31/I12","v":0},{"$f":"J31/J12","v":1.1152416356877323E-2},null,null,null,null,null,null,null,null,{"$f":"S31/S30","v":3.3707865168539325E-2},0.15,{"$f":"S32*T32","v":5.0561797752808986E-3},{"$f":"S32","v":3.3707865168539325E-2},null,{"$f":"U32","v":5.0561797752808986E-3}]
["FOR SCENARIO 3 ONLY:"]
["stone free from first line treatment only"]
[null,"Events",38,79,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C35/C12","v":0.55072463768115942},{"$f":"D35/D12","v":0.90804597701149425},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D36","v":0.90804597701149425},null,{"$f":"C36","v":0.55072463768115942}]
["second line retreatment if primary treatment failure"]
[null,"Events",8,0,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C38/(C12-C35)","v":0.25806451612903225},{"$f":"D38/(D12-D35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D39","v":0},null,{"$f":"C39","v":0.25806451612903225}]
["stone free after second line retreatment"]
[null,"Events",5,0,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C41/C38","v":0.625},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D42","v":0},null,{"$f":"C42","v":0.625}]
["second line ancillary if primary treatment failure"]
[null,"Events",23,8,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C44/(C12-C35)","v":0.74193548387096775},{"$f":"D44/(D12-D35)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D45","v":1},null,{"$f":"C45","v":0.74193548387096775}]
["stone free after second line ancillary"]
[null,"Events",20,7,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C47/C44","v":0.86956521739130432},{"$f":"D47/D44","v":0.875},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D48","v":0.875},null,{"$f":"C48","v":0.86956521739130432}]
["third line treatment "]
[null,"Events",6,1,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability"]
["stone free after third line treatment","stone free at end of trial",64,86,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Events",{"$f":"C12-C52","v":5},{"$f":"D12-D52","v":1},"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"(C50-C53)/C50","v":0.16666666666666666},{"$f":"(D50-D53)/D50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D54","v":0},null,{"$f":"C54","v":0.16666666666666666}]
["Proportion of second line ancillary treatments that are PCNL"]
[null,"Events",3,2,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C56/C44","v":0.13043478260869565},{"$f":"D56/D44","v":0.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D57","v":0.25},null,{"$f":"C57","v":0.13043478260869565}]
["Proportion of second line ancillary treatments that are URS"]
[null,"Events",20,0,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C59/C44","v":0.86956521739130432},{"$f":"0/D44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D60","v":0},null,{"$f":"C60","v":0.86956521739130432}]
["Proportion of second line ancillary treatments that are SWL"]
[null,"Events",0,6,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C62/C44","v":0},{"$f":"D62/D44","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D63","v":0.75},null,{"$f":"C63","v":0}]
["Proportion of third line procedures  that are URS"]
[null,"Events",6,1,"NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR","NR"]
[null,"Probability",{"$f":"C65/C50","v":1},{"$f":"D65/D50","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D66","v":1},null,{"$f":"C66","v":1}]
[]
["STUDIES USED IN EACH SCENARIO (for retreatment and ancillary outcomes)","Scenario 1","y",null,"y",null,"y",null,"y",null,"y",null,"y",null,"y"]
[null,"Scenario 2","n",null,"y",null,"y",null,"y",null,"n",null,"n",null,"n"]
[null,"Scenario 3","y",null,"n",null,"n",null,"n",null,"n",null,"n",null,"n"]
[]
["POOLED RETREATMENT AND ANCILLARY PROCEDURES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"SUM(D12,F12,H12,J12,L12,N12)","v":554},null,null,{"$f":"V12","v":352}]
[null,"Events",{"$f":"C19+C22","v":37},9,12,0,9,5,24,11,34,7,8,{"$f":"N19+N22","v":3},"NR","NR",null,null,{"$f":"SUM(D73,F73,H73,J73,L73,N73)","v":35},null,null,{"$f":"SUM(F73,H73,J73)","v":16}]
[null,"Probability",{"$f":"C73/C12","v":0.53623188405797106},0.10344827586206896,0.20689655172413793,0,0.26470588235294118,0.16129032258064516,9.3385214007782102E-2,4.0892193308550186E-2,0.64150943396226412,0.14285714285714285,0.11594202898550725,4.5454545454545456E-2,null,null,null,null,{"$f":"S73/S72","v":6.3176895306859202E-2},3.64,{"$f":"S74*T74","v":0.2299638989169675},{"$f":"V73/V72","v":4.5454545454545456E-2},2.72,{"$f":"V74*W74","v":0.12363636363636366}]
["POOLED READMISSION AND MAJOR ADVERSE EVENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"SUM(D12,J12,P13)","v":388}]
[null,"Events",0,9,"NR","NR","NR","NR",0,3,"NR","NR","NR","NR",2,4,null,null,{"$f":"SUM(D76,J76,P76)","v":16}]
[null,"Probability",{"$f":"C76/C12","v":0},{"$f":"D76/D12","v":0.10344827586206896},null,null,null,null,{"$f":"I76/I12","v":0},{"$f":"J76/J12","v":1.1152416356877323E-2},null,null,null,null,{"$f":"O76/O13","v":6.25E-2},{"$f":"P76/P13","v":0.125},null,null,{"$f":"S76/S75","v":4.1237113402061855E-2},0.19,{"$f":"S77*T77","v":7.8350515463917522E-3}]
["POOLED MINOR AND MAJOR ADVERSE EVENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total participants",{"$f":"SUM(D12,F27,J12,L12,P13)","v":537}]
[null,"Events",{"$f":"C28+C31","v":1},{"$f":"D28+D31","v":9},{"$f":"E28","v":0},{"$f":"F28","v":6},"NR","NR",{"$f":"I28+I31","v":6},{"$f":"J28+J31","v":7},{"$f":"K28","v":0},{"$f":"L28","v":1},"NR","NR",{"$f":"O28","v":0},{"$f":"P28","v":1},null,null,{"$f":"SUM(D79,F79,J79,L79,P79)","v":24}]
[null,"Probability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S79/S78","v":4.4692737430167599E-2},0.36,{"$f":"S80*T80","v":1.6089385474860336E-2}]
[]
[]
["LIVE DATA"]
[]
[]
["Summary (contain vlookup formulas):"]
[null,null,"SCENARIO 1",null,null,"SCENARIO 2",null,null,"SCENARIO 3"]
[]
[null,null,"URS","SWL",null,"URS","SWL",null,null,null,null,null,null,null,"URS","SWL"]
["Retreatment ",null,{"$f":"IF('Scenario 1'!$H$47=3,VLOOKUP(SA3_switch,Inputs!$J$147:$P$155,5,FALSE),Inputs!$S$20)","v":2.1660649819494584E-2},{"$f":"IF('Scenario 1'!$H$47=2,VLOOKUP(SA1_switch,Inputs!$B$125:$D$135,2,FALSE),IF('Scenario 1'!$H$47=3,VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,2,FALSE),Inputs!$U$20))","v":0.10851985559566786},null,{"$f":"IF('Scenario 2'!$F$119=3,VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,5,FALSE),Inputs!$V$20)","v":1.4204545454545454E-2},{"$f":"IF('Scenario 2'!$F$119=2,VLOOKUP(SA8_switch,Inputs!$T$125:$W$135,3,FALSE),IF('Scenario 2'!$F$119=3,VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,2,FALSE),Inputs!$X$20))","v":5.8238636363636354E-2},null,"first line","primary treatment success",null,null,null,null,{"$f":"Y36","v":0.90804597701149425},{"$f":"IF('Scenario 3'!$R$80=2,VLOOKUP(SA13_switch,$AM$125:$AN$135,2,FALSE),AA36)","v":0.55072463768115942}]
["Ancillary procedures","is a URS",null,{"$f":"IF('Scenario 1'!$H$47=2,VLOOKUP(SA1_switch,Inputs!$B$125:$D$135,3,FALSE),IF('Scenario 1'!$H$47=3,VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,3,FALSE),Inputs!$U$23))","v":9.8808664259927792E-2},null,null,{"$f":"IF('Scenario 2'!$F$119=2,VLOOKUP(SA8_switch,Inputs!$T$125:$W$135,4,FALSE),IF('Scenario 2'!$F$119=3,VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,3,FALSE),Inputs!$X$23))","v":7.6249999999999998E-2},null,null,"primary treatemnt failure",null,null,null,null,{"$f":"1-O90","v":9.1954022988505746E-2},{"$f":"1-P90","v":0.44927536231884058}]
[null,"is a PCNL",{"$f":"IF('Scenario 1'!$H$47=3,VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,7,FALSE),Inputs!$S$23)","v":4.1516245487364621E-2},{"$f":"IF('Scenario 1'!$H$47=3,VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,4,FALSE),0)","v":0},null,{"$f":"IF('Scenario 2'!$F$119=3,VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,7,FALSE),Inputs!$V$23)","v":3.125E-2},{"$f":"IF('Scenario 2'!$F$119=3,VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,4,FALSE),0)","v":0},null,"second line","probability of having a retreatment",null,null,null,null,{"$f":"Y39","v":0},{"$f":"AA39","v":0.25806451612903225}]
[null,"is an SWL",{"$f":"IF('Scenario 1'!$H$47=3,VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,6,FALSE),0)","v":0},null,null,{"$f":"IF('Scenario 2'!$F$119=3,VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,6,FALSE),0)","v":0},null,null,null,"probability of retreatment success",null,null,null,null,{"$f":"Y42","v":0},{"$f":"AA42","v":0.625}]
[null,null,null,null,null,null,null,null,null,"probability of retreatment failure",null,null,null,null,{"$f":"1-URS_2ndline_retreat_success","v":1},{"$f":"1-SWL_2ndline_retreat_success","v":0.375}]
[null,null,null,null,null,{"$f":"$V$15+SUM(F90:F93)","v":0.97727272727272718},{"$f":"$X$15+SUM(G90:G93)","v":0.95448863636363623},"initial success prob + retreatment prob + ancillary probability",null,"probability of having an ancillary procedure",null,null,null,null,{"$f":"Y45","v":1},{"$f":"AA45","v":0.74193548387096775}]
[null,null,null,null,null,{"$f":"1-F95","v":2.2727272727272818E-2},{"$f":"1-G95","v":4.5511363636363766E-2},"passed stone without procedures (SWL value used in SA8)",null,"probability of ancillary procedure success",null,null,null,null,{"$f":"Y48","v":0.875},{"$f":"AA48","v":0.86956521739130432}]
[null,null,null,null,null,null,null,null,null,"probability of ancillary procedure failure",null,null,null,null,{"$f":"1-URS_2ndline_ancillary_success","v":0.125},{"$f":"1-SWL_2ndline_ancillary_success","v":0.13043478260869568}]
[null,null,null,null,null,null,null,null,"third line","success of third line treatment",null,null,null,null,{"$f":"Y54","v":0},{"$f":"AA54","v":0.16666666666666666}]
["readmissions",null,{"$f":"IF('Scenario 1'!H47=4,0,IF('Scenario 1'!H47=5,0,S26))","v":0.125},{"$f":"IF('Scenario 1'!H47=4,0,IF('Scenario 1'!H47=5,0,U26))","v":6.25E-2},null,"As in scenario 1",null,null,null,null,null,null,null,null,"As in scenario 1"]
["minor adverse events",null,{"$f":"IF('Scenario 1'!H47=5,0,S29)","v":2.23463687150838E-2},{"$f":"IF('Scenario 1'!H47=5,0,U29)","v":1.4972067039106146E-2}]
["major adverse events",null,{"$f":"IF('Scenario 1'!H47=4,Inputs!S77,IF('Scenario 1'!H47=5,S80,S32))","v":3.3707865168539325E-2},{"$f":"IF('Scenario 1'!H47=4,Inputs!U77,IF('Scenario 1'!H47=5,U80,U32))","v":5.0561797752808986E-3}]
[]
[]
["Resource use assumptions:"]
[null,null,"URS","SWL",null,"URS","SWL",null,null,null,null,null,null,null,"URS","SWL"]
["Number of initial sessions of SWL",null,null,1,null,"As in scenario 1",null,null,null,null,null,null,null,null,"As in scenario 1"]
["Number of repeat sessions of SWL",null,null,1]
["Proportion requiring stent insertion",null,0,1.0000000000000002E-2]
["Proportion requiring stent removal",null,{"$f":"IF(E109=1,VLOOKUP(SA4_switch,Inputs!$B$161:$C$167,2,FALSE),IF(E109=2,VLOOKUP(SA11_switch,Inputs!$B$161:$C$167,2,FALSE),VLOOKUP(SA17_switch,Inputs!$B$161:$C$167,2,FALSE)))","v":0.7},{"$f":"prop_requiring_stent_insertion_SWL","v":1.0000000000000002E-2},3]
["Proportion requiring confirmation of stone passing",null,1,1]
["Proportion requiring ultrasound to confirm stone passing",null,0.1,0.1]
[null,null,null,null,null,null,null,null,null,"Proportion of second line ancillaries that are PCNL",null,null,null,null,{"$f":"Y57","v":0.25},{"$f":"AA57","v":0.13043478260869565}]
[null,null,null,null,null,null,null,null,null,"Proportion of second line ancillaries that are URS",null,null,null,null,{"$f":"Y60","v":0},{"$f":"AA60","v":0.86956521739130432}]
[null,null,null,null,null,null,null,null,null,"Proportion of second line ancillaries that are SWL",null,null,null,null,{"$f":"Y63","v":0.75},{"$f":"AA63","v":0}]
[null,null,null,null,null,null,null,null,null,"Proportion of third line procedures that are URS",null,null,null,null,{"$f":"Y66","v":1},{"$f":"AA66","v":1}]
[]
[]
["SA inputs"]
[]
["SCENARIO 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCENARIO 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCENARIO 3"]
[]
["SA1. Varying SWL retreatment/ancillary rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA8. Varying initial effectiveness of SWL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA13. Varying the effectiveness of the primary SWL"]
[]
[null,null,"probability of needing retreatment","probability of needing ancillary procedure","test effectiveness SWL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"initial effectiveness","probability of needing retreatment","probability of needing ancillary procedure","no further treatment","effectiveness difference","test ",null,null,null,null,null,null,null,null,null,null,null,null,null,"initial effectiveness"]
["base case values",0,{"$f":"Inputs!U20","v":0.10851985559566786},{"$f":"Inputs!U23","v":9.8808664259927792E-2},{"$f":"1-SUM(C125:D125)","v":0.79267148014440436},null,null,null,null,null,null,null,null,null,null,null,null,null,"base case values",0,{"$f":"Inputs!$X$15","v":0.82},{"$f":"Inputs!$X$20","v":5.8238636363636354E-2},{"$f":"Inputs!$X$23","v":7.6249999999999998E-2},{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},{"$f":"$V$15-U125","v":0.11181818181818182},{"$f":"SUM(Inputs!U125:X125)","v":1},null,null,null,null,null,null,null,null,null,null,"same as URS",null,0,{"$f":"Y36","v":0.90804597701149425}]
[null,1,{"$f":"C125+(($C$135-$C$125)/10)","v":0.1290730589617497},{"$f":"D125+(($D$135-$D$125)/10)","v":0.11752260890828639},{"$f":"1-SUM(C126:D126)","v":0.75340433212996394},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"U125-(($U$125-$U$135)/10)","v":0.77799999999999991},{"$f":"V125+(($V$135-$V$125)/10)","v":7.6426215577831524E-2},{"$f":"W125+(($W$135-$W$125)/10)","v":0.1000624207858048},{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.15381818181818185,{"$f":"SUM(Inputs!U126:X126)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM125+1","v":1},{"$f":"AN125-(($AN$125-$AN$130)/5)","v":0.83658170914542729}]
[null,2,0.14962626232783152,0.13623655355664499,0.71413718411552352,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.73599999999999988,9.4613794792026695E-2,0.12387484157160959,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.19581818181818189,{"$f":"SUM(Inputs!U127:X127)","v":0.99999999999999989},null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"AN126-(($AN$125-$AN$130)/5)","v":0.76511744127936032}]
[null,3,0.17017946569391335,0.15495049820500359,0.67487003610108309,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.69399999999999984,0.11280137400622187,0.14768726235741439,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.23781818181818193,{"$f":"SUM(Inputs!U128:X128)","v":0.99999999999999978},null,null,null,null,null,null,null,null,null,null,null,null,3,0.69365317341329336]
[null,4,0.19073266905999517,0.17366444285336219,0.63560288808664267,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.6519999999999998,0.13098895322041704,0.1714996831432192,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.27981818181818197,{"$f":"SUM(Inputs!U129:X129)","v":0.99999999999999978},null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"AN128-(($AN$125-$AN$130)/5)","v":0.62218890554722639}]
[null,5,0.21128587242607699,0.19237838750172079,0.59633574007220225,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0.60999999999999976,0.14917653243461221,0.19531210392902401,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.321818181818182,{"$f":"SUM(Inputs!U130:X130)","v":0.99999999999999978},null,null,null,null,null,null,null,null,null,null,"base case",null,5,{"$f":"AA36","v":0.55072463768115942}]
[null,6,0.23183907579215882,0.21109233215007939,0.55706859205776182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0.56799999999999973,0.16736411164880738,0.21912452471482882,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.36381818181818204,{"$f":"SUM(Inputs!U131:X131)","v":0.99999999999999967},null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"AN130-(($AN$130-$AN$135)/5)","v":0.52057971014492754}]
[null,7,0.25239227915824064,0.22980627679843799,0.5178014440433214,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.52599999999999969,0.18555169086300255,0.24293694550063363,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.40581818181818208,{"$f":"SUM(Inputs!U132:X132)","v":0.99999999999999956},null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"AN131-(($AN$130-$AN$135)/5)","v":0.49043478260869566}]
[null,8,0.27294548252432249,0.24852022144679659,0.47853429602888098,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.48399999999999971,0.20373927007719772,0.26674936628643842,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.44781818181818206,{"$f":"SUM(Inputs!U133:X133)","v":0.99999999999999956},null,null,null,null,null,null,null,null,null,null,null,null,8,0.46028985507246378]
[null,9,0.29349868589040434,0.26723416609515521,0.43926714801444045,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.44199999999999973,{"$f":"V133+(($V$135-$V$125)/10)","v":0.22192684929139289},{"$f":"W133+(($W$135-$W$125)/10)","v":0.29056178707224323},{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.48981818181818204,{"$f":"SUM(Inputs!U134:X134)","v":0.99999999999999956},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM133+1","v":9},0.4301449275362319]
["uk practice values",10,{"$f":"D135*(C125/D125)","v":0.31405188925648614},0.28594811074351384,0.4,"equates to effectiveness as low as 40% (100% - 40% retreatment - 20% ancillary)",null,null,null,null,null,null,null,null,null,null,null,null,"uk practice",10,0.4,{"$f":"W135*(V125/W125)","v":0.24011442850558803},0.31437420785804798,{"$f":"Inputs!$G$96","v":4.5511363636363766E-2},0.53181818181818175,{"$f":"SUM(U135:X135)","v":0.99999999999999978},"Testing effectiveness as low as 40%",null,null,null,null,null,null,null,null,null,"low effectiveness",null,10,0.4,null,"Testing effectiveness as low as 40%"]
[]
[]
["SA3. Pooling retreatment and ancillary procedures - inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA10. Pooling retreatment and ancillary procedures"]
[]
["ratio SWL retreatmetn vs ancillaries",null,null,{"$f":"U20/U23","v":1.0982827913774205},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ratio SWL retreatment vs ancillaries",null,null,{"$f":"X20/X23","v":0.76378539493293585}]
["ratio URS retreatment versus ancillaries",null,null,{"$f":"S20/S23","v":0.52173913043478259},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ratio URS retreatment versus ancillaries",null,null,{"$f":"V20/V23","v":0.45454545454545453}]
[]
["Proportional divide between retreatments and ancillaries:",null,null,null,null,null,null,null,null,null,"Proportion associated with each type of secondary procedure:",null,null,null,null,null,null,null,"Proportional divide between retreatments and ancillaries:",null,null,null,null,null,null,null,null,null,"Proportion associated with each type of secondary procedure:"]
[]
[null,"Interventions",null,null,null,null,null,null,null,null,"Interventions",null,null,null,null,null,null,null,null,"Interventions",null,null,null,null,null,null,null,null,"Interventions"]
[null,"SWL",null,null,"URS",null,null,null,null,null,"SWL",null,null,"URS",null,null,null,null,null,"SWL",null,null,"URS",null,null,null,null,null,"SWL",null,null,"URS"]
["Secondary procedure","SWL (retreat)","URS (anc)","PCNL (anc)","URS (retreat)","SWL (anc)","PCNL (anc)","checking sum to 1",null,null,"SWL (retreat)","URS (anc)","PCNL (anc)","URS (retreat)","SWL (anc)","PCNL (anc)",null,null,"Procedure","SWL (retreat)","URS (anc)","PCNL (anc)","URS (retreat)","SWL (anc)","PCNL (anc)","checking sum to 1",null,null,"SWL (retreat)","URS (anc)","PCNL (anc)","URS (retreat)","SWL (anc)","PCNL (anc)"]
["base case proportions",{"$f":"U20/(U20+U23)","v":0.52341981542747695},{"$f":"B148/D140","v":0.4765801845725231},null,{"$f":"S20/(S20+S23)","v":0.34285714285714286},null,{"$f":"E148/D141","v":0.65714285714285714},{"$f":"SUM(B148:D148)","v":1},{"$f":"SUM(E148:G148)","v":1},0,{"$f":"Inputs!B148*Inputs!$U$74","v":0.12036766152610209},{"$f":"Inputs!C148*Inputs!$U$74","v":0.10959623739086542},{"$f":"Inputs!D148*Inputs!$U$74","v":0},{"$f":"Inputs!E148*Inputs!$S$74","v":2.1660649819494584E-2},{"$f":"Inputs!F148*Inputs!$S$74","v":0},{"$f":"Inputs!G148*Inputs!$S$74","v":4.1516245487364621E-2},null,null,"base case proportions",{"$f":"X20/(X20+X23)","v":0.43303760033798055},{"$f":"T148/V140","v":0.56696239966201945},null,{"$f":"V20/(V20+V23)","v":0.3125},null,{"$f":"W148/V141","v":0.6875},{"$f":"SUM(T148:V148)","v":1},{"$f":"SUM(W148:Y148)","v":1},0,{"$f":"Inputs!T148*Inputs!$X$74","v":5.3539194223604876E-2},{"$f":"Inputs!U148*Inputs!$X$74","v":7.0097169412758772E-2},{"$f":"Inputs!V148*Inputs!$X$74","v":0},{"$f":"Inputs!W148*Inputs!$V$74","v":1.4204545454545456E-2},{"$f":"Inputs!X148*Inputs!$V$74","v":0},{"$f":"Inputs!Y148*Inputs!$V$74","v":3.125E-2}]
["assuming different ancillary",{"$f":"B148","v":0.52341981542747695},null,{"$f":"C148","v":0.4765801845725231},{"$f":"E148","v":0.34285714285714286},{"$f":"G148","v":0.65714285714285714},null,{"$f":"SUM(B149:D149)","v":1},{"$f":"SUM(E149:G149)","v":1},1,{"$f":"Inputs!B149*Inputs!$U$74","v":0.12036766152610209},{"$f":"Inputs!C149*Inputs!$U$74","v":0},{"$f":"Inputs!D149*Inputs!$U$74","v":0.10959623739086542},{"$f":"Inputs!E149*Inputs!$S$74","v":2.1660649819494584E-2},{"$f":"Inputs!F149*Inputs!$S$74","v":4.1516245487364621E-2},{"$f":"Inputs!G149*Inputs!$S$74","v":0},null,null,"assuming different ancillary",{"$f":"T148","v":0.43303760033798055},null,{"$f":"U148","v":0.56696239966201945},{"$f":"W148","v":0.3125},{"$f":"Y148","v":0.6875},null,{"$f":"SUM(T149:V149)","v":1},{"$f":"SUM(W149:Y149)","v":1},1,{"$f":"Inputs!T149*Inputs!$X$74","v":5.3539194223604876E-2},{"$f":"Inputs!U149*Inputs!$X$74","v":0},{"$f":"Inputs!V149*Inputs!$X$74","v":7.0097169412758772E-2},{"$f":"Inputs!W149*Inputs!$V$74","v":1.4204545454545456E-2},{"$f":"Inputs!X149*Inputs!$V$74","v":3.125E-2},{"$f":"Inputs!Y149*Inputs!$V$74","v":0}]
["assuming different ancillaries",{"$f":"B148","v":0.52341981542747695},{"$f":"D149/2","v":0.23829009228626155},{"$f":"D149/2","v":0.23829009228626155},{"$f":"E148","v":0.34285714285714286},{"$f":"F149/2","v":0.32857142857142857},{"$f":"F149/2","v":0.32857142857142857},1,1,2,{"$f":"Inputs!B150*Inputs!$U$74","v":0.12036766152610209},{"$f":"Inputs!C150*Inputs!$U$74","v":5.4798118695432711E-2},{"$f":"Inputs!D150*Inputs!$U$74","v":5.4798118695432711E-2},{"$f":"Inputs!E150*Inputs!$S$74","v":2.1660649819494584E-2},{"$f":"Inputs!F150*Inputs!$S$74","v":2.0758122743682311E-2},{"$f":"Inputs!G150*Inputs!$S$74","v":2.0758122743682311E-2},null,null,"assuming different ancillaries",{"$f":"T148","v":0.43303760033798055},{"$f":"V149/2","v":0.28348119983100972},{"$f":"V149/2","v":0.28348119983100972},{"$f":"W148","v":0.3125},{"$f":"X149/2","v":0.34375},{"$f":"X149/2","v":0.34375},1,1,2,{"$f":"Inputs!T150*Inputs!$X$74","v":5.3539194223604876E-2},{"$f":"Inputs!U150*Inputs!$X$74","v":3.5048584706379386E-2},{"$f":"Inputs!V150*Inputs!$X$74","v":3.5048584706379386E-2},{"$f":"Inputs!W150*Inputs!$V$74","v":1.4204545454545456E-2},{"$f":"Inputs!X150*Inputs!$V$74","v":1.5625E-2},{"$f":"Inputs!Y150*Inputs!$V$74","v":1.5625E-2}]
["increasing proportion that have URS as secondary treatment in increments until 100%",{"$f":"1-C151","v":0.41873585234198152},{"$f":"$C$148+($B$148/5)*1","v":0.58126414765801848},null,{"$f":"$E$150+($G$148/5)*1","v":0.47428571428571431},null,{"$f":"1-E151","v":0.52571428571428569},1,1,3,{"$f":"Inputs!B151*Inputs!$U$74","v":9.6294129220881666E-2},{"$f":"Inputs!C151*Inputs!$U$74","v":0.13366976969608582},{"$f":"Inputs!D151*Inputs!$U$74","v":0},{"$f":"Inputs!E151*Inputs!$S$74","v":2.9963898916967508E-2},{"$f":"Inputs!F151*Inputs!$S$74","v":0},{"$f":"Inputs!G151*Inputs!$S$74","v":3.321299638989169E-2},null,null,"increasing proportion that have URS as secondary treatment in increments until 100%",{"$f":"1-U151","v":0.41873585234198152},{"$f":"$C$148+($B$148/5)*1","v":0.58126414765801848},null,{"$f":"$E$150+($G$148/5)*1","v":0.47428571428571431},null,{"$f":"1-W151","v":0.52571428571428569},1,1,3,{"$f":"Inputs!T151*Inputs!$X$74","v":5.1770978107735906E-2},{"$f":"Inputs!U151*Inputs!$X$74","v":7.1865385528627757E-2},{"$f":"Inputs!V151*Inputs!$X$74","v":0},{"$f":"Inputs!W151*Inputs!$V$74","v":2.1558441558441561E-2},{"$f":"Inputs!X151*Inputs!$V$74","v":0},{"$f":"Inputs!Y151*Inputs!$V$74","v":2.3896103896103894E-2}]
[null,{"$f":"1-C152","v":0.31405188925648608},{"$f":"$C$148+($B$148/5)*2","v":0.68594811074351392},null,{"$f":"$E$150+($G$148/5)*2","v":0.60571428571428565},null,{"$f":"1-E152","v":0.39428571428571435},1,1,4,{"$f":"Inputs!B152*Inputs!$U$74","v":7.2220596915661239E-2},{"$f":"Inputs!C152*Inputs!$U$74","v":0.15774330200130626},{"$f":"Inputs!D152*Inputs!$U$74","v":0},{"$f":"Inputs!E152*Inputs!$S$74","v":3.8267148014440429E-2},{"$f":"Inputs!F152*Inputs!$S$74","v":0},{"$f":"Inputs!G152*Inputs!$S$74","v":2.4909747292418776E-2},null,null,null,{"$f":"1-U152","v":0.31405188925648608},{"$f":"$C$148+($B$148/5)*2","v":0.68594811074351392},null,{"$f":"$E$150+($G$148/5)*2","v":0.60571428571428565},null,{"$f":"1-W152","v":0.39428571428571435},1,1,4,{"$f":"Inputs!T152*Inputs!$X$74","v":3.8828233580801924E-2},{"$f":"Inputs!U152*Inputs!$X$74","v":8.4808130055561731E-2},{"$f":"Inputs!V152*Inputs!$X$74","v":0},{"$f":"Inputs!W152*Inputs!$V$74","v":2.753246753246753E-2},{"$f":"Inputs!X152*Inputs!$V$74","v":0},{"$f":"Inputs!Y152*Inputs!$V$74","v":1.7922077922077926E-2}]
[null,0.20936792617099065,{"$f":"$C$148+($B$148/5)*3","v":0.79063207382900935},null,{"$f":"$E$150+($G$148/5)*3","v":0.7371428571428571},null,0.2628571428571429,1,1,5,{"$f":"Inputs!B153*Inputs!$U$74","v":4.8147064610440805E-2},{"$f":"Inputs!C153*Inputs!$U$74","v":0.1818168343065267},{"$f":"Inputs!D153*Inputs!$U$74","v":0},{"$f":"Inputs!E153*Inputs!$S$74","v":4.6570397111913353E-2},{"$f":"Inputs!F153*Inputs!$S$74","v":0},{"$f":"Inputs!G153*Inputs!$S$74","v":1.6606498194945848E-2},null,null,null,0.20936792617099065,{"$f":"$C$148+($B$148/5)*3","v":0.79063207382900935},null,{"$f":"$E$150+($G$148/5)*3","v":0.7371428571428571},null,0.2628571428571429,1,1,5,{"$f":"Inputs!T153*Inputs!$X$74","v":2.5885489053867939E-2},{"$f":"Inputs!U153*Inputs!$X$74","v":9.775087458249572E-2},{"$f":"Inputs!V153*Inputs!$X$74","v":0},{"$f":"Inputs!W153*Inputs!$V$74","v":3.3506493506493505E-2},{"$f":"Inputs!X153*Inputs!$V$74","v":0},{"$f":"Inputs!Y153*Inputs!$V$74","v":1.1948051948051951E-2}]
[null,0.10468396308549532,{"$f":"$C$148+($B$148/5)*4","v":0.89531603691450468},null,{"$f":"$E$150+($G$148/5)*4","v":0.86857142857142855},null,0.13142857142857145,1,1,6,{"$f":"Inputs!B154*Inputs!$U$74","v":2.4073532305220403E-2},{"$f":"Inputs!C154*Inputs!$U$74","v":0.20589036661174709},{"$f":"Inputs!D154*Inputs!$U$74","v":0},{"$f":"Inputs!E154*Inputs!$S$74","v":5.4873646209386277E-2},{"$f":"Inputs!F154*Inputs!$S$74","v":0},{"$f":"Inputs!G154*Inputs!$S$74","v":8.3032490974729242E-3},null,null,null,0.10468396308549532,{"$f":"$C$148+($B$148/5)*4","v":0.89531603691450468},null,{"$f":"$E$150+($G$148/5)*4","v":0.86857142857142855},null,0.13142857142857145,1,1,6,{"$f":"Inputs!T154*Inputs!$X$74","v":1.2942744526933969E-2},{"$f":"Inputs!U154*Inputs!$X$74","v":0.11069361910942968},{"$f":"Inputs!V154*Inputs!$X$74","v":0},{"$f":"Inputs!W154*Inputs!$V$74","v":3.9480519480519484E-2},{"$f":"Inputs!X154*Inputs!$V$74","v":0},{"$f":"Inputs!Y154*Inputs!$V$74","v":5.9740259740259753E-3}]
[null,0,{"$f":"$C$148+($B$148/5)*5","v":1},null,{"$f":"$E$150+($G$148/5)*5","v":1},null,{"$f":"1-E155","v":0},1,1,7,{"$f":"Inputs!B155*Inputs!$U$74","v":0},{"$f":"Inputs!C155*Inputs!$U$74","v":0.2299638989169675},{"$f":"Inputs!D155*Inputs!$U$74","v":0},{"$f":"Inputs!E155*Inputs!$S$74","v":6.3176895306859202E-2},{"$f":"Inputs!F155*Inputs!$S$74","v":0},{"$f":"Inputs!G155*Inputs!$S$74","v":0},null,null,null,0,{"$f":"$C$148+($B$148/5)*5","v":1},null,{"$f":"$E$150+($G$148/5)*5","v":1},0,{"$f":"1-W155","v":0},1,1,7,{"$f":"Inputs!T155*Inputs!$X$74","v":0},{"$f":"Inputs!U155*Inputs!$X$74","v":0.12363636363636366},{"$f":"Inputs!V155*Inputs!$X$74","v":0},{"$f":"Inputs!W155*Inputs!$V$74","v":4.5454545454545456E-2},{"$f":"Inputs!X155*Inputs!$V$74","v":0},{"$f":"Inputs!Y155*Inputs!$V$74","v":0}]
[]
[]
["SA4 & SA11 & SA17. Varying proportion of URS that get stents",null,null,null,null,"(same values tested in all three scenarios)"]
[]
[null,null,"Proportion"]
["base case",0,0.7]
[null,1,0]
[null,2,0.2]
[null,3,0.4]
[null,4,0.6]
[null,5,0.8]
[null,6,1]
[]
[]
["COSTS"]
[]
["Interventions"]
[null,null,"National Schedule of Reference Costs - Year 2016-17 - NHS trusts and NHS foundation trusts"]
["SWL COST per session"]
[null,null,"DAY CASE"]
[null,null,"Currency Code","Currency Description","Number of FCE's","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions"]
[null,null,"LB36Z","Extracorporeal Lithotripsy",20064,451.62261463317401,221.24,571.05999999999995,114]
[]
[]
["URS COST per procedure",null,"National average cost (including complications and excess bed days) - from elective",null,null,null,null,null,null,null,"ELECTIVE",null,null,null,null,null,null,null,null,null,"ELECTIVE EXCESS BED DAYS"]
[null,null,"Currency Code","Currency Description","Activity","WA Unit Cost (deterministic)","WA Unit Cost (probabilistic)","Average Length of Stay - Days",null,null,"Currency Code","Currency Description","Number of FCEs\n","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","Number of Inlier Bed Days\n","Average Length of Stay - Days","No. Data Submissions",null,"Currency Code","Currency Description","Excess Bed days","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions"]
[null,null,"LB65C, LB65D and LB65E","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, ",{"$f":"SUM(M182:M184)","v":8560},{"$f":"(SUMPRODUCT($M$182:$M$184,N182:N184)+(SUMPRODUCT($W$182:$W$184,X182:X184)))/E182","v":2604.8104018691583},null,{"$f":"(SUMPRODUCT($M$182:$M$184,R182:R184)+SUM(W182:W184))/E182","v":1.5475467289719651},null,null,"LB65C","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 5+",548,3320.4036678832099,2562.645,3765.75,1668,3.0437956204379599,134,null,"LB65C","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 5+",39,437.60871794871798,244.38,653.48,7]
[null,null,null,null,null,null,null,null,null,null,"LB65D","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 3-4",1139,2681.4369885864799,2244.11,2940.5,1911,1.67778753292362,145,null,"LB65D","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 3-4",257,289.44856031128398,257.75,257.75,23]
[null,null,null,null,null,null,null,null,null,null,"LB65E","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 0-2",6873,2500.314279063,2146.5,2746.5453124999999,8973,1.3055434308162399,163,null,"LB65E","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 0-2",399,369.23318295739301,270.89499999999998,428.98,62]
[]
[null,null,"National average cost (weighted average of all complication categories)",null,null,null,null,null,null,null,"DAY CASE"]
[null,null,"Currency Code","Currency Description","Activity","WA Unit Cost (deterministic)","WA Unit Cost (probabilistic)","Average Length of Stay - Days",null,null,"Currency Code","Currency Description","Number of FCE's","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions"]
[null,null,"LB65C, LB65D and LB65E","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, ",5785,1739.2000570440814,null,null,null,null,"LB65C","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 5+",112,1683.2855357142901,1266.9100000000001,2025.6624999999999,55]
[null,null,null,null,null,null,null,null,null,null,"LB65D","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 3-4",438,1760.7553424657499,1431.72,1924.22,110]
[null,null,null,null,null,null,null,null,null,null,"LB65E","Major Endoscopic, Kidney or Ureter Procedures, 19 years and over, with CC Score 0-2",5235,1738.5928385864399,1456.1,1958.92,162]
[]
[null,null,"% elective","% day case"]
[null,null,0.5,0.5,null,{"$f":"(C193*F182)+(D193*F188)","v":2172.0052294566199},null,null,null,null,"assume 50% elective cost and 50% day case cost"]
[]
[]
["PCNL cost",null,"National average cost (including complications and excess bed days)",null,null,null,null,null,null,null,"ELECTIVE",null,null,null,null,null,null,null,null,null,"ELECTIVE EXCESS BED DAYS"]
[null,null,"Currency Code","Currency Description","Activity","WA Unit Cost (deterministic)","WA Unit Cost (probabilistic)","Average Length of Stay - Days",null,null,"Currency Code","Currency Description","Number of FCEs\n","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","Number of Inlier Bed Days\n","Average Length of Stay - Days","No. Data Submissions",null,"Currency Code","Currency Description","Excess Bed days","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions"]
[null,null,"LB75A, LB75B and 0","percutaneous nephrolithotomy",{"$f":"SUM(M198:M199)","v":1317},{"$f":"(SUMPRODUCT($M$198:$M$199,N198:N199)+(SUMPRODUCT($W$198:$W$199,X198:X199)))/E198","v":5195.1162946089607},null,{"$f":"(SUMPRODUCT($M$198:$M$199,R198:R199)+SUM(W198:W199))/E198","v":3.2095671981776781},null,null,"LB75A","Percutaneous Nephrolithotomy with CC Score 2+",448,5516.3282812500001,4224.75,6055.06,1706,3.80803571428571,90,null,"LB75A","Percutaneous Nephrolithotomy with CC Score 2+",114,348.01657894736798,209.55,321.24,16]
[null,null,null,null,null,null,null,null,null,null,"LB75B","Percutaneous Nephrolithotomy with CC Score 0-1",869,4981.7750287687004,3842,5376.49,2398,2.75949367088608,103,null,"LB75B","Percutaneous Nephrolithotomy with CC Score 0-1",9,201.85555555555601,98.72,271.7,5]
[]
[]
["Other resource use"]
[]
["Stent insertion cost",null,"DAY CASE"]
[null,null,"Currency Code","Currency Description","Number of FCE's","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions"]
[null,null,"LB09D","Intermediate Endoscopic Ureter Procedures, 19 years and over",14015,1017.52913378523,668.05,1239.48504424779,207,null,"this has been mapped from OPCS code M292"]
[]
["Stent removal cost",null,null,null,null,1017.52913378523,null,null,null,null,"same HRG as above, mapped from OPCS code M293"]
[]
[]
["Follow up - consultant led",null,"Currency Code","Currency Description","Service Code","Service Description","No. of attendances","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions"]
[null,null,"WF01A","Non-Admitted Face-to-Face Attendance, Follow-up","101","Urology",1063865,103.048156251028,80.3,120.05,142]
[]
[]
["Imaging ",null,"Department Code","Department Description","Currency Code","Currency Description","No. of examinations","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions",null,"An x-ray is bundled and therefore no cost applies so only the cost of ultrasound is included. "]
[null,null,"IMAGOP","Imaging: Outpatient","RD40Z","Ultrasound Scan with duration of less than 20 minutes, without Contrast",2122656,51.777673716325097,36.776926693737998,59.834267605633798,4800]
[]
[]
["Adverse events/re-hospitalisation"]
[]
["Minor AE's",null,"EMERGENCY MEDICINE SCHEDULE"]
[null,null,"Service Code","Service Description","Currency Code","Currency Description","Attendances","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions"]
[null,null,"T01NA","Type 01 non admitted","VB09Z","Emergency Medicine, Category 1 Investigation with Category 1-2 Treatment",3484576,119.074431755829,93.78,139.24,137]
[]
["Major AE's",null,"same as below"]
[]
[]
["Rehospitalisation",null,"EMERGENCY MEDICINE SCHEDULE"]
[null,null,"Service Code","Service Description","Currency Code","Currency Description","Attendances","National Average Unit Cost","Lower Quartile Unit Cost","Upper Quartile Unit Cost","No. Data Submissions",null,"category 3 investigation e.g. ultrasound"]
[null,null,"T01A","Type 01 admitted","VB03Z","Emergency Medicine, Category 3 Investigation with Category 1-3 Treatment",368944,307.09653931219901,249.12,358.38,135,null,"category 3 treatment e.g. urinary catheter, minor surgery"]
[]
[]
["QUALITY OF LIFE","(only used in exploratory work in scenarios 2 and 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source"]
[]
["UK general population utility from the health survey for England 2014",null,null,null,null,null,0.874,null,null,null,null,null,null,null,null,null,null,"EQ5D","http://nesstar.ukdataservice.ac.uk/webview/index.jsp?v=2&mode=documentation&submode=abstract&study=http://nesstar.ukdataservice.ac.uk:80/obj/fStudy/7919&top=yes"]
[]
["Utility with a stone",null,null,null,null,null,{"$f":"((0.677*383)+(383*0.674)+(384*0.701))/(383+383+384)","v":0.68401478260869564},null,null,null,null,null,null,null,null,null,null,"EQ5D, calculated as a weighted average of the baseline utility of each arm of Pickard 2015 study on MET."]

{"sheet":"Scenario 1","index":3,"n_rows":139,"n_cols":17,"rows_kept":139,"cut":false,"hidden":false,"merged":[[91,1,91,2],[91,3,92,3],[22,15,22,16],[22,13,22,14],[85,4,85,9],[86,4,86,6],[86,7,86,9]]}
["LIVE ANALYSIS",null,null,null,null,null,null,null,null,null,null,"NOTES"]
[]
[null,null,null,null,null,"%","no. people","cost"]
[1000,"URS","primary intervention cost",null,null,1,{"$f":"$A$4*F4","v":1000},{"$f":"G4*URS_cost","v":2172005.2294566198}]
[null,null,null,"removing stent ",null,{"$f":"prop_requiring_stent_removal_URS","v":0.7},{"$f":"$A$4*F5","v":700},{"$f":"G5*Stent_removal_cost","v":712270.39364966098}]
[null,null,"retreatment",null,null,{"$f":"Scen1_retreatment_URS","v":2.1660649819494584E-2},{"$f":"$A$4*F6","v":21.660649819494584},{"$f":"G6*URS_cost","v":47047.044681370826}]
[null,null,null,"removing stent ",null,{"$f":"prop_requiring_stent_removal_URS","v":0.7},{"$f":"G6*F7","v":15.162454873646208},{"$f":"G7*Stent_removal_cost","v":15428.239573638864}]
[null,null,"ancillary procedures",null,null,{"$f":"SUM(Scen1_URS_ancillary_PCNL,Scen1_URS_ancillary_SWL)","v":4.1516245487364621E-2},{"$f":"$A$4*F8","v":41.516245487364621},{"$f":"(A4*Scen1_URS_ancillary_PCNL*PCNL_cost)+(A4*((Scen1_URS_ancillary_SWL*SWL_cost_per_session)+(Scen1_URS_ancillary_SWL*(prop_requiring_stent_insertion_SWL*stent_insertion_cost+prop_requiring_stent_insertion_SWL*Stent_removal_cost))))","v":215681.72342239367}]
[null,null,"Follow up (consult + imaging)"]
[null,null,null,"primary intvn follow up",null,{"$f":"Inputs!C110","v":1},{"$f":"$A$4*F10","v":1000},{"$f":"G10*follow_up+(G10*Inputs!C111*Ultrasound_cost)","v":108225.92362266051}]
[null,null,null,"retreatment follow up",null,{"$f":"F6*Inputs!C110","v":2.1660649819494584E-2},21.660649819494584,{"$f":"G11*follow_up+(G11*Inputs!C111*Ultrasound_cost)","v":2344.243832981816}]
[null,null,null,"ancillary follow up",null,{"$f":"F8*Inputs!C110","v":4.1516245487364621E-2},41.516245487364621,{"$f":"G12*follow_up+(G12*Inputs!C111*Ultrasound_cost)","v":4493.1340132151481}]
[null,null,"readmission to hospital",null,null,{"$f":"readmin_URS","v":0.125},125,{"$f":"G13*Rehosp_cost","v":38387.067414024874}]
[null,null,"Minor adverse events",null,null,{"$f":"minorAE_URS","v":2.23463687150838E-2},22.346368715083798,{"$f":"G14*minorAE_cost","v":2660.8811565548381}]
[null,null,"Major adverse events",null,null,{"$f":"majorAE_URS","v":3.3707865168539325E-2},33.707865168539328,{"$f":"G15*majorAE_cost","v":10351.568740860641}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H4:H15)","v":3328895.4495639815},"TOTAL COST",null,null,"assume that  100% of people would be stone free as including resource use from the review (we can make that assumption because we know most of the studies reported outcomes after the primary procedure, and so considering the retreatment they said would occur we could assume this would mean most people would end up stone free)"]
[]
[1000,"SWL","primary intervention cost",null,null,1,{"$f":"$A$20*F20","v":1000},{"$f":"G20*SWL_cost_per_session*No_initial_sessions","v":451622.61463317403}]
[null,null,null,"inserting + removing stent",null,{"$f":"prop_requiring_stent_insertion_SWL","v":1.0000000000000002E-2},{"$f":"G20*F21","v":10.000000000000002},{"$f":"(G21*stent_insertion_cost)+(G21*Stent_removal_cost)","v":20350.582675704602}]
[null,null,"retreatment",null,null,{"$f":"Scen1_retreatment_SWL","v":0.10851985559566786},{"$f":"$A$20*F22","v":108.51985559566786},{"$f":"G22*No_repeat_sessions*SWL_cost_per_session","v":49010.020923730001},null,null,null,null,"Results breakdown for report"]
[null,null,null,"inserting + removing stent",null,{"$f":"prop_requiring_stent_insertion_SWL","v":1.0000000000000002E-2},{"$f":"G22*F23","v":1.0851985559566788},{"$f":"(G23*stent_insertion_cost)+(G23*Stent_removal_cost)","v":2208.4422932551638},null,null,null,null,"Parameter","URS strategy cost (per 1000)",null,"SWL strategy cost (per 1000)"]
[null,null,"ancillary procedures",null,null,{"$f":"SUM(Scen1_SWL_ancillary_URS,Scen1_SWL_ancillary_PCNL)","v":9.8808664259927792E-2},{"$f":"$A$20*F24","v":98.808664259927795},{"$f":"(A20*Scen1_SWL_ancillary_URS*URS_cost)+(A20*Scen1_SWL_ancillary_PCNL*PCNL_cost)","v":214612.93548818657},null,null,null,null,"Primary intervention cost",{"$f":"H4+H5","v":2884275.6231062808},null,{"$f":"H20+H21","v":471973.19730887865}]
[null,null,null,"removing stent (if URS)",null,{"$f":"prop_requiring_stent_removal_URS","v":0.7},{"$f":"A20*Scen1_SWL_ancillary_URS*F25","v":69.166064981949447},{"$f":"G25*Stent_removal_cost","v":70378.486188415947},null,null,null,null,null,{"$f":"H5","v":712270.39364966098},"= stent costs",{"$f":"H21","v":20350.582675704602},"= stent costs) "]
[null,null,"Follow up (consult + imaging)",null,null,null,null,null,null,null,null,null,"Retreatment",{"$f":"H6+H7","v":62475.28425500969},null,{"$f":"H22+H23","v":51218.463216985161}]
[null,null,null,"primary intvn follow up",null,{"$f":"Inputs!D110","v":1},{"$f":"$A$20*F27","v":1000},{"$f":"G27*follow_up+(G27*Inputs!D111*Ultrasound_cost)","v":108225.92362266051},null,null,null,null,null,{"$f":"H7","v":15428.239573638864},"= stent costs",{"$f":"H23","v":2208.4422932551638},"= stent costs) "]
[null,null,null,"retreatment follow up",null,{"$f":"F22*Inputs!D110","v":0.10851985559566786},108.51985559566786,{"$f":"G28*follow_up+(G28*Inputs!D111*Ultrasound_cost)","v":11744.661603238899},null,null,null,null,"Ancillary procedures",{"$f":"H8","v":215681.72342239367},null,{"$f":"H24+H25","v":284991.42167660251}]
[null,null,null,"ancillary follow up",null,{"$f":"F24*Inputs!D110","v":9.8808664259927792E-2},98.808664259927795,{"$f":"G29*follow_up+(G29*Inputs!D111*Ultrasound_cost)","v":10693.658951452051},null,null,null,null,null,null,null,{"$f":"H25","v":70378.486188415947},"= stent costs)"]
[null,null,"readmission to hospital",null,null,{"$f":"readmin_SWL","v":6.25E-2},62.5,{"$f":"G30*Rehosp_cost","v":19193.533707012437},null,null,null,null,"Follow up (consultation + imaging) ",{"$f":"SUM(H10:H12)","v":115063.30146885748},null,{"$f":"SUM(H27:H29)","v":130664.24417735146}]
[null,null,"Minor adverse events",null,null,{"$f":"minorAE_SWL","v":1.4972067039106146E-2},14.972067039106145,{"$f":"G31*minorAE_cost","v":1782.7903748917413},null,null,null,null,"Readmission",{"$f":"H13","v":38387.067414024874},null,{"$f":"H30","v":19193.533707012437}]
[null,null,"Major adverse events",null,null,{"$f":"majorAE_SWL","v":5.0561797752808986E-3},5.0561797752808983,{"$f":"G32*majorAE_cost","v":1552.7353111290959},null,null,null,null,"Minor adverse events",{"$f":"H14","v":2660.8811565548381},null,{"$f":"H31","v":1782.7903748917413}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Major adverse events",{"$f":"H15","v":10351.568740860641},null,{"$f":"H32","v":1552.7353111290959}]
[null,null,null,null,null,null,null,{"$f":"SUM(H20:H32)","v":961376.38577285095},"TOTAL COST",null,null,null,"TOTAL",{"$f":"H18","v":3328895.4495639815},null,{"$f":"H34","v":961376.38577285095}]
[]
[]
["LIVE RESULTS"]
[]
[null,null,null,null,null,null,null,"Cost per patient"]
[null,null,null,null,null,null,"URS ",{"$f":"H18/1000","v":3328.8954495639814}]
[null,null,null,null,null,null,"SWL ",{"$f":"H34/1000","v":961.37638577285099}]
[null,null,"Analysis selected:",null,{"$f":"IF(H47=1,\"base case\",IF(H47=2,\"SA1\",IF(H47=3,\"SA3\",IF(H47=4,\"SA6\",\"SA7\"))))","v":"base case"},null,"incremental",{"$f":"H40-H41","v":2367.5190637911305}]
[]
["SENSITIVITY ANALYSES"]
[]
[]
[null,null,null,null,null,null,null,1]
[]
[]
[]
["SA1. Varying SWL retreatment/ancillary rates"]
[]
[null,"SA switch",0,null,null,null,null,null,null,null,null,"SET RADIO BUTTONS TO SA1 AND FILL IN SA SWITCH WITH A VALUE TO TEST LIVE RESULTS MANUALLY (use numbers 0 to 10)"]
[]
[null,null,null,null,"probability of retreatment","probability of ancillary procedure"]
[null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA1_switch,Inputs!$B$125:$D$135,2,FALSE)","v":0.10851985559566786},{"$f":"VLOOKUP(SA1_switch,Inputs!$B$125:$D$135,3,FALSE)","v":9.8808664259927792E-2},null,null,null,null,null,"change value in SA switch (between 0 and 10) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,null,"Total cost of SWL strategy per pt","Incremental cost (URS - SWL)",null,null,null,null,null,null,null,"be careful if move cells then have to change the cell values in the macro"]
[null,0,961.37638577285099,{"$f":"$H$40-C60","v":2367.5190637911305}]
[null,1,1029.3028446037918,{"$f":"$H$40-C61","v":2299.5926049601894}]
[null,2,1097.2293034347326,{"$f":"$H$40-C62","v":2231.6661461292488}]
[null,3,1165.1557622656733,2163.7396872983081]
[null,4,1233.0822210966144,2095.813228467367]
[null,5,1301.0086799275546,2027.8867696364268]
[null,6,1368.9351387584954,1959.960310805486]
[null,7,1436.8615975894365,1892.0338519745449]
[null,8,1504.788056420377,1824.1073931436044]
[null,9,1572.7145152513181,{"$f":"$H$40-C69","v":1756.1809343126633}]
[null,10,1640.6409740822589,{"$f":"$H$40-C70","v":1688.2544754817225}]
[]
[]
["SA2. Varying cost of SWL"]
[null,null,null,null,null,null,null,null,"incremental cost"]
["SA2.a","If assume have two initial sessions?",null,null,null,null,null,null,1915.8964491579561]
[]
[]
["SA2.b","threshold analysis: what is the cost of 1 session of SWL to make the comparators cost neutral?",null,null,null,null,null,null,2587,null,null,"ONLY CALCULATED USING GOAL SEEK. IF MAKE CHANGES TO ANALYSIS THEN WILL NEED TO DO THIS AGAIN "]
[]
[]
["SA3. Pooling retreatment and ancillary procedures"]
[]
[null,"SA switch",0,null,null,null,null,null,null,null,null,"SET RADIO BUTTONS TO SA3 AND FILL IN SA SWITCH WITH A VALUE TO TEST LIVE RESULTS MANUALLY (use numbers 0 to 7)"]
[]
[null,null,null,null,"Proportion associated with each type of secondary procedure:"]
[null,null,null,null,"Interventions"]
[null,null,null,null,"SWL",null,null,"URS"]
[null,null,null,null,"SWL (retreat)","URS (anc)","PCNL (anc)","URS (retreat)","SWL (anc)","PCNL (anc)"]
[null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,2,FALSE)","v":0.12036766152610209},{"$f":"VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,3,FALSE)","v":0.10959623739086542},{"$f":"VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,4,FALSE)","v":0},{"$f":"VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,5,FALSE)","v":2.1660649819494584E-2},{"$f":"VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,6,FALSE)","v":0},{"$f":"VLOOKUP(SA3_switch,Inputs!$J$148:$P$155,7,FALSE)","v":4.1516245487364621E-2},null,"change value in SA switch (between 0 and 7) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,"Total cost",null,"Incremental cost"]
[null,"URS","SWL"]
[0,3328.8954495639814,1000.5323016384389,{"$f":"B94-C94","v":2328.3631479255428}]
[1,3132.8082812645198,1253.7917444449138,1879.016536819606]
[2,3230.8518654142508,1127.1620230416763,2103.6898423725743]
[3,3309.7079638439236,1058.6049420158345,2251.1030218280894]
[4,3290.5204781238649,1116.6775823932298,2173.8428957306351]
[5,3271.3329924038071,1174.750222770625,2096.5827696331821]
[6,3252.1455066837484,1232.8228631480201,2019.3226435357283]
[7,3232.9580209636897,1290.895503525416,1942.0625174382737]
[]
[]
["SA4. Varying proportion of URS that get stents"]
[]
[null,"SA switch",0,null,null,null,null,null,null,null,null,"SET RADIO BUTTONS TO BASE CASE AND FILL IN SA SWITCH WITH A VALUE TO TEST LIVE RESULTS MANUALLY (use numbers 0 to 6)"]
[]
[null,null,null,null,"Proportion having stent"]
[null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA4_switch,Inputs!$B$161:$C$167,2,FALSE)","v":0.7},null,null,null,null,null,null,"change value in SA switch (between 0 and 6) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,"total cost URS","total cost SWL","incremental cost"]
[0,3328.8954495639814,961.37638577285099,{"$f":"B113-C113","v":2367.5190637911305}]
[1,2601.1968163406818,890.997899584435,{"$f":"B114-C114","v":1710.1989167562469}]
[2,2809.1107115473387,911.1060384954111,1898.0046730519275]
[3,3017.0246067539956,931.21417740638708,2085.8104293476085]
[4,3224.938501960653,951.32231631736306,2273.61618564329]
[5,3432.8523971673103,971.43045522833904,2461.421941938971]
[6,3640.7662923739672,991.53859413931502,2649.2276982346521]
[]
[]
["SA5. Omitting readmission from the analysis"]
[null,null,null,"Cost per patient"]
[null,null,"URS ",{"$f":"(SUM(H4:H15)-H13)/1000","v":3290.5083821499566}]
[null,null,"SWL ",{"$f":"(SUM(H20:H32)-H30)/1000","v":942.18285206583857}]
[null,null,"incremental",{"$f":"D124-D125","v":2348.3255300841179},null,null,null,null,null,null,null,"BASED ON CALCULATIONS OMMITTING THE READMISSION OUTCOME FROM THE LIVE RESULTS. DOES NOT USE A BUTTON."]
[]
[]
["SA6. Pooled readmission and major adverse events"]
[null,null,null,"Cost per patient"]
[null,null,"URS ",3292.8205882260941]
[null,null,"SWL ",943.03623396993896]
[null,null,"incremental",2349.784354256155]
[]
["SA7. Pooled minor and major adverse events (readmissions also excluded)"]
[null,null,null,"Cost per patient"]
[null,null,"URS ",3291.2209172497346]
[null,null,"SWL ",943.78832097880729]
[null,null,"incremental",2347.4325962709272]

{"sheet":"Scenario 2","index":4,"n_rows":210,"n_cols":17,"rows_kept":210,"cut":false,"hidden":false,"merged":[[22,13,22,14],[22,15,22,16],[164,1,164,2],[164,3,165,3],[158,4,158,9],[159,4,159,6],[159,7,159,9]]}
["LIVE ANALYSIS",null,null,null,null,null,null,null,null,null,null,"NOTES"]
[]
[null,null,null,null,null,"%","no. people","cost"]
[1000,"URS","primary intervention cost",null,null,1,{"$f":"$A$4*F4","v":1000},{"$f":"G4*URS_cost","v":2172005.2294566198}]
[null,null,null,"removing stent ",null,{"$f":"prop_requiring_stent_removal_URS","v":0.7},{"$f":"$A$4*F5","v":700},{"$f":"G5*Stent_removal_cost","v":712270.39364966098}]
[null,null,"retreatment",null,null,{"$f":"Scen2_retreatment_URS","v":1.4204545454545454E-2},{"$f":"$A$4*F6","v":14.204545454545453},{"$f":"G6*URS_cost","v":30852.347009326983}]
[null,null,null,"removing stent ",null,{"$f":"prop_requiring_stent_removal_URS","v":0.7},{"$f":"G6*F7","v":9.9431818181818166},{"$f":"G7*Stent_removal_cost","v":10117.477182523591}]
[null,null,"ancillary procedures",null,null,{"$f":"SUM(Scen2_URS_ancillary_PCNL,Scen2_URS_ancillary_SWL)","v":3.125E-2},{"$f":"$A$4*F8","v":31.25},{"$f":"(A4*Scen2_URS_ancillary_PCNL*PCNL_cost)+(A4*((Scen2_URS_ancillary_SWL*SWL_cost_per_session)+(Scen2_URS_ancillary_SWL*(prop_requiring_stent_insertion_SWL*stent_insertion_cost+prop_requiring_stent_insertion_SWL*Stent_removal_cost))))","v":162347.38420653003}]
[null,null,"Follow up (consult + imaging)"]
[null,null,null,"primary intvn follow up",null,{"$f":"Inputs!C110","v":1},{"$f":"$A$4*F10","v":1000},{"$f":"G10*follow_up+(G10*Inputs!C111*Ultrasound_cost)","v":108225.92362266051}]
[null,null,null,"retreatment follow up",null,{"$f":"F6*Inputs!C110","v":1.4204545454545454E-2},14.204545454545453,{"$f":"G11*follow_up+(G11*Inputs!C111*Ultrasound_cost)","v":1537.3000514582457}]
[null,null,null,"ancillary follow up",null,{"$f":"F8*Inputs!C110","v":3.125E-2},31.25,{"$f":"G12*follow_up+(G12*Inputs!C111*Ultrasound_cost)","v":3382.060113208141}]
[null,null,"readmission to hospital",null,null,{"$f":"readmin_URS","v":0.125},125,{"$f":"G13*Rehosp_cost","v":38387.067414024874}]
[null,null,"Minor adverse events",null,null,{"$f":"minorAE_URS","v":2.23463687150838E-2},22.346368715083798,{"$f":"G14*minorAE_cost","v":2660.8811565548381}]
[null,null,"Major adverse events",null,null,{"$f":"majorAE_URS","v":3.3707865168539325E-2},33.707865168539328,{"$f":"G15*majorAE_cost","v":10351.568740860641}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H4:H15)","v":3252137.6326034288},"TOTAL COST"]
[]
[1000,"SWL","primary intervention cost",null,null,1,{"$f":"$A$20*F20","v":1000},{"$f":"G20*SWL_cost_per_session*No_initial_sessions","v":451622.61463317403}]
[null,null,null,"inserting + removing stent",null,{"$f":"prop_requiring_stent_insertion_SWL","v":1.0000000000000002E-2},{"$f":"G20*F21","v":10.000000000000002},{"$f":"(G21*stent_insertion_cost)+(G21*Stent_removal_cost)","v":20350.582675704602}]
[null,null,"retreatment",null,null,{"$f":"Scen2_retreatment_SWL","v":5.8238636363636354E-2},{"$f":"$A$20*F22","v":58.238636363636353},{"$f":"G22*No_repeat_sessions*SWL_cost_per_session","v":26301.885227216095},null,null,null,null,"Results breakdown for report"]
[null,null,null,"inserting + removing stent",null,{"$f":"prop_requiring_stent_insertion_SWL","v":1.0000000000000002E-2},{"$f":"G22*F23","v":0.58238636363636365},{"$f":"(G23*stent_insertion_cost)+(G23*Stent_removal_cost)","v":1185.1901842384782},null,null,null,null,"Parameter","URS strategy cost (per 1000)",null,"SWL strategy cost (per 1000)"]
[null,null,"ancillary procedures",null,null,{"$f":"SUM(Scen2_SWL_ancillary_URS,Scen2_SWL_ancillary_PCNL)","v":7.6249999999999998E-2},{"$f":"$A$20*F24","v":76.25},{"$f":"(A20*Scen2_SWL_ancillary_URS*URS_cost)+(A20*Scen2_SWL_ancillary_PCNL*PCNL_cost)","v":165615.39874606728},null,null,null,null,"Primary intervention cost",{"$f":"H4+H5","v":2884275.6231062808},null,{"$f":"H20+H21","v":471973.19730887865}]
[null,null,null,"removing stent (if URS)",null,{"$f":"prop_requiring_stent_removal_URS","v":0.7},{"$f":"A20*Scen2_SWL_ancillary_URS*F25","v":53.375},{"$f":"G25*Stent_removal_cost","v":54310.617515786653},null,null,null,null,null,{"$f":"H5","v":712270.39364966098},"= stent costs",{"$f":"H21","v":20350.582675704602},"= stent costs) "]
[null,null,"Follow up (consult + imaging)",null,null,null,null,null,null,null,null,null,"Retreatment",{"$f":"H6+H7","v":40969.824191850574},null,{"$f":"H22+H23","v":27487.075411454574}]
[null,null,null,"primary intvn follow up",null,{"$f":"Inputs!D110","v":1},{"$f":"$A$20*F27","v":1000},{"$f":"G27*follow_up+(G27*Inputs!D111*Ultrasound_cost)","v":108225.92362266051},null,null,null,null,null,{"$f":"H7","v":10117.477182523591},"= stent costs",{"$f":"H23","v":1185.1901842384782},"= stent costs) "]
[null,null,null,"retreatment follow up",null,{"$f":"F22*Inputs!D110","v":5.8238636363636354E-2},58.238636363636353,{"$f":"G28*follow_up+(G28*Inputs!D111*Ultrasound_cost)","v":6302.9302109788077},null,null,null,null,"Ancillary procedures",{"$f":"H8","v":162347.38420653003},null,{"$f":"H24+H25","v":219926.01626185392}]
[null,null,null,"ancillary follow up",null,{"$f":"F24*Inputs!D110","v":7.6249999999999998E-2},76.25,{"$f":"G29*follow_up+(G29*Inputs!D111*Ultrasound_cost)","v":8252.226676227865},null,null,null,null,null,null,null,{"$f":"H25","v":54310.617515786653},"= stent costs)"]
[null,null,"readmission to hospital",null,null,{"$f":"readmin_SWL","v":6.25E-2},62.5,{"$f":"G30*Rehosp_cost","v":19193.533707012437},null,null,null,null,"Follow up (consultation + imaging) ",{"$f":"SUM(H10:H12)","v":113145.2837873269},null,{"$f":"SUM(H27:H29)","v":122781.08050986718}]
[null,null,"Minor adverse events",null,null,{"$f":"minorAE_SWL","v":1.4972067039106146E-2},14.972067039106145,{"$f":"G31*minorAE_cost","v":1782.7903748917413},null,null,null,null,"Readmission",{"$f":"H13","v":38387.067414024874},null,{"$f":"H30","v":19193.533707012437}]
[null,null,"Major adverse events",null,null,{"$f":"majorAE_SWL","v":5.0561797752808986E-3},5.0561797752808983,{"$f":"G32*majorAE_cost","v":1552.7353111290959},null,null,null,null,"Minor adverse events",{"$f":"H14","v":2660.8811565548381},null,{"$f":"H31","v":1782.7903748917413}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Major adverse events",{"$f":"H15","v":10351.568740860641},null,{"$f":"H32","v":1552.7353111290959}]
[null,null,null,null,null,null,null,{"$f":"SUM(H20:H32)","v":864696.42888508772},"TOTAL COST",null,null,null,"TOTAL",{"$f":"H18","v":3252137.6326034288},null,{"$f":"H34","v":864696.42888508772}]
[]
[]
["LIVE RESULTS"]
[]
[null,null,null,null,null,null,null,"Cost per patient"]
[null,null,null,null,null,null,"URS ",{"$f":"H18/1000","v":3252.1376326034288}]
[null,null,null,null,null,null,"SWL ",{"$f":"H34/1000","v":864.6964288850877}]
[null,null,"Analysis selected:",null,{"$f":"IF(F119=1,\"base case\",IF(F119=2,\"SA8\",\"SA10\"))","v":"base case"},null,"incremental",{"$f":"H40-H41","v":2387.4412037183411}]
[]
[]
["QALY THRESHOLD ANALYSIS"]
[]
[null,null,null,null,null,null,"Threshold",20000]
["incremental QALY needed per patient to make URS cost effective",null,null,null,{"$f":"H42/H47","v":0.11937206018591705},null,null,null,null,null,null,"Incremental cost divided by threshold"]
["timeframe of 2 weeks (based on the studies)",null,null,null,{"$f":"IF($I$54=1,$D$54,IF($I$54=2,$D$55,$D$56))","v":3.8461538461538464E-2},null,null,null,null,null,null,"Timeframe of 2 weeks as a proportion of a year"]
["QoL difference needed per patient to make URS cost effective",null,null,null,{"$f":"E48/E49","v":3.1036735648338429},null,null,null,null,null,null,"Dividing the incremental QALY needed by the timeframe, to be left with the QoL part of the QALY"]
[]
["Testing timeframes until further treatments"]
[null,null,null,"timeframe","QoL difference needed per patient to make URS cost effective",null,"use dropdown to change timeframe, and see the effect on SA8 final column",null,null,null,null,null,"2 weeks"]
[null,null,"2 weeks",{"$f":"2/52","v":3.8461538461538464E-2},{"$f":"E48/D54","v":3.1036735648338429},null,null,null,1,null,null,null,"2 months"]
[null,null,"2 months",{"$f":"8/52","v":0.15384615384615385},{"$f":"E48/D55","v":0.77591839120846073},null,null,null,null,null,null,null,"4 months"]
[null,null,"4 months",{"$f":"16/52","v":0.30769230769230771},{"$f":"E48/D56","v":0.38795919560423037}]
[]
[]
["QoL GAIN exploratory analyses"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Using effectiveness of initial treatments (from the 3 studies informing the analysis), to back-calculate difference in QoL needed between a stone free and non-stone free health state"]
[]
[null,null,null,null,null,"URS","SWL"]
[null,"effectiveness of initial treatments",null,null,null,{"$f":"Inputs!V15","v":0.93181818181818177},{"$f":"Inputs!X15","v":0.82}]
[null,"difference in initial effectiveness",null,null,null,null,null,{"$f":"F75-G75","v":0.11181818181818182}]
[]
[null,null,null,null,null,"QoL difference needed between stone free and non stone free health states to make URS cost effective",null,"QoL difference needed per patient to make URS cost effective"]
[null,null,null,{"$f":"1-D80","v":0.88818181818181818},"*",0,"=",0,null,null,null,"Assuming no QoL gain in those successfully treated"]
[null,null,null,{"$f":"H76","v":0.11181818181818182},"*",{"$f":"H80/D80","v":27.756430254611605},"=",{"$f":"E50","v":3.1036735648338429},null,null,null,"Apportioning the QoL difference needed per patient on average (already calculated), to only those that are stone free with a URS that wouldn’t be with SWL, gives the figure in the red box."]
[null,null,null,null,null,null,null,{"$f":"SUM(H79:H80)","v":3.1036735648338429}]
[]
[null,"is this difference in QoL between a stone free health state and a non stone free health state achievable?"]
[]
[null,"worst possible health state on EQ-5D",null,null,null,-0.59399999999999997]
[null,"best possible health state on the EQ-5D",null,null,null,1]
[null,"maximum possible gain",null,null,null,{"$f":"-F85+F86","v":1.5939999999999999},null,null,null,null,null,"This is the maximum change in EQ5D QoL possible using the worst possible and best possible health states"]
[]
[null,null,null,null,"hence",{"$f":"F80","v":27.756430254611605},{"$f":"IF(F89>F87,\">\",\"<\")","v":">"},{"$f":"F87","v":1.5939999999999999},{"$f":"IF(F89>F87,\"= QoL difference not feasible\",\"= QoL difference feasible\")","v":"= QoL difference not feasible"}]
[]
["Using the same initial effectiveness as above, and sourced QoL values, to calculate QALY gain of URS over SWL"]
[]
[null,"probability"]
["effectiveness with URS",{"$f":"F75","v":0.93181818181818177}]
["effectiveness with SWL",{"$f":"G75","v":0.82}]
["differences in effectiveness",{"$f":"B94-B95","v":0.11181818181818182}]
[]
[null," QoL (EQ-5D)"]
["no stone",{"$f":"Inputs!G236","v":0.874},null,"From the health survey for England (see inputs sheet)"]
["stone",{"$f":"Inputs!G238","v":0.68401478260869564},null,"From a study included in the clinical review (see inputs sheet)"]
["utility gain",{"$f":"B99-B100","v":0.18998521739130436}]
[]
[]
["for 2 weeks still have a stone while wait for retreatment",{"$f":"2/52","v":3.8461538461538464E-2},null,"timeframe of studies"]
[]
["Qaly gain",{"$f":"B101*B96*B104","v":8.1706929157798736E-4},null,"Utility gain multiplied by timeframe (to generate QALYs) and then multiplied by the difference in effectiveness; to apportion the QoL gain only to those incrementally stone free with URS."]
[]
[]
["what would the cost difference have to be to reach this level? (rearranging ICER equation)"]
[]
[null,"Incremental cost","incremental QALY","Threshold"]
[null,{"$f":"C112*D112","v":16.341385831559748},{"$f":"B106","v":8.1706929157798736E-4},{"$f":"H47","v":20000}]
[]
[]
[]
["SENSITIVITY ANALYSES"]
[]
[]
[null,null,null,null,null,1]
[]
[]
[]
[]
["SA8. Varying initial effectiveness of SWL"]
[null,null,null,null,null,null,null,null,null,null,null,"SET RADIO BUTTONS TO SA8 AND FILL IN SA SWITCH WITH A VALUE TO TEST LIVE RESULTS MANUALLY (use numbers 0 to 10)"]
[null,"SA switch",0]
[]
[null,null,null,null,"initial effectiveness","probability of needing retreatment","probability of needing ancillary procedure","no further treatment"]
[null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA8_switch,Inputs!$T$125:$X$135,2,FALSE)","v":0.82},{"$f":"VLOOKUP(SA8_switch,Inputs!$T$125:$X$135,3,FALSE)","v":5.8238636363636354E-2},{"$f":"VLOOKUP(SA8_switch,Inputs!$T$125:$X$135,4,FALSE)","v":7.6249999999999998E-2},{"$f":"VLOOKUP(SA8_switch,Inputs!$T$125:$X$135,5,FALSE)","v":4.5511363636363766E-2},null,null,null,"change value in SA switch (between 0 and 10) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,null,"Total cost of SWL strategy per pt","Incremental cost (URS - SWL)","QALY gain needed","QoL gain needed ","Effectiveness difference with URS (I.e. proportion that QoL gain applies to)","difference in QoL needed between a stone free and non stone free person ",null,null,null,"be careful if move cells then have to change the cell values in the macro"]
[null,0,864.6964288850877,{"$f":"$H$40-C133","v":2387.4412037183411},{"$f":"D133/$H$47","v":0.11937206018591705},{"$f":"E133/$E$49","v":3.1036735648338429},{"$f":"Inputs!Y125","v":0.11181818181818182},{"$f":"F133/G133","v":27.756430254611605},null,null,null,"conditional formatting used - red background with dark red text shows that QoL between a stone free and non-stone free state is more than the maximum EQ-5D difference."]
[null,1,946.50755238991758,{"$f":"$H$40-C134","v":2305.6300802135111},{"$f":"D134/$H$47","v":0.11528150401067555},{"$f":"E134/$E$49","v":2.997319104277564},{"$f":"Inputs!Y126","v":0.15381818181818185},{"$f":"F134/G134","v":19.486117108187468}]
[null,2,1028.3186758947477,{"$f":"$H$40-C135","v":2223.8189567086811},0.11119094783543405,2.890964643721285,{"$f":"Inputs!Y127","v":0.19581818181818189},14.763514893655582]
[null,3,1110.1297993995777,2142.0078332038511,0.10710039166019256,2.7846101831650065,{"$f":"Inputs!Y128","v":0.23781818181818193},{"$f":"F136/G136","v":11.708987773247346}]
[null,4,1191.9409229044079,2060.1967096990211,0.10300983548495106,2.6782557226087276,{"$f":"Inputs!Y129","v":0.27981818181818197},9.5714142133515239]
[null,5,1273.7520464092381,1978.3855861941906,9.8919279309709535E-2,2.5719012620524477,{"$f":"Inputs!Y130","v":0.321818181818182},7.9917835826488446]
[null,6,1355.5631699140681,1896.5744626893606,9.4828723134468038E-2,2.4655468014961688,{"$f":"Inputs!Y131","v":0.36381818181818204},6.7768652714787203]
[null,7,1437.3742934188986,1814.7633391845302,9.0738166959226513E-2,2.3591923409398894,{"$f":"Inputs!Y132","v":0.40581818181818208},5.813421987083057]
[null,8,1519.1854169237283,1732.9522156797004,8.6647610783985016E-2,2.2528378803836104,{"$f":"Inputs!Y133","v":0.44781818181818206},5.0306976622451689]
[null,9,1600.9965404285581,{"$f":"$H$40-C142","v":1651.1410921748707},8.2557054608743533E-2,2.1464834198273319,{"$f":"Inputs!Y134","v":0.48981818181818204},4.3822044577024206]
[null,10,1682.8076639333881,{"$f":"$H$40-C143","v":1569.3299686700407},7.8466498433502035E-2,2.040128959271053,{"$f":"Inputs!Y135","v":0.53181818181818175},3.8361399234156557]
[]
[]
["SA9. Varying cost of SWL"]
[null,null,null,null,null,null,null,null,"incremental cost"]
["SA9.a","If assume have two initial sessions?",null,null,null,null,null,null,1935.8185890851673]
[]
[]
["SA9.b","threshold analysis: what is the cost of 1 session of SWL to make the comparators cost neutral?",null,null,null,null,null,null,2708,null,null,"ONLY CALCULATED USING GOAL SEEK. IF MAKE CHANGES TO ANALYSIS THEN WILL NEED TO DO THIS AGAIN "]
[]
[]
["SA10. Pooling retreatment and ancillary procedures"]
[]
[null,"SA switch",0,null,null,null,null,null,null,null,null,"SET RADIO BUTTONS TO SA10 AND FILL IN SA SWITCH WITH A VALUE TO TEST LIVE RESULTS MANUALLY (use numbers 0 to 7)"]
[]
[null,null,null,null,"Proportion associated with each type of secondary procedure:"]
[null,null,null,null,"Interventions"]
[null,null,null,null,"SWL",null,null,"URS"]
[null,null,null,null,"SWL (retreat)","URS (anc)","PCNL (anc)","URS (retreat)","SWL (anc)","PCNL (anc)"]
[null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,2,FALSE)","v":5.3539194223604876E-2},{"$f":"VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,3,FALSE)","v":7.0097169412758772E-2},{"$f":"VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,4,FALSE)","v":0},{"$f":"VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,5,FALSE)","v":1.4204545454545456E-2},{"$f":"VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,6,FALSE)","v":0},{"$f":"VLOOKUP(SA10_switch,Inputs!$AB$148:$AH$155,7,FALSE)","v":3.125E-2},null,"change value in SA switch (between 0 and 7) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,"Total cost",null,"Incremental cost"]
[null,"URS","SWL"]
[0,3252.1376326034288,843.55746163749234,{"$f":"B167-C167","v":2408.5801709659363}]
[1,3104.5394108128012,1005.5408516737087,2098.9985591390923]
[2,3178.338521708115,924.54915665560054,2253.7893650525143]
[3,3235.1439503925403,847.82293366313706,2387.3210167294033]
[4,3221.3389281991476,879.04474768193586,2342.2941805172118]
[5,3207.5339060057549,910.26656170073477,2297.2673443050203]
[6,3193.7288838123623,941.48837571953345,2252.2405080928288]
[7,3179.92386161897,972.71018973833247,2207.2136718806378]
[]
["SA11. Varying proportion of URS that get stents"]
[]
[null,"SA switch",0,null,null,null,null,null,null,null,null,"SET RADIO BUTTONS TO BASE CASE AND FILL IN SA SWITCH WITH A VALUE TO TEST LIVE RESULTS MANUALLY (use numbers 0 to 6)"]
[]
[null,null,null,null,"Proportion having stent"]
[null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA11_switch,Inputs!$B$161:$C$167,2,FALSE)","v":0.7},null,null,null,null,null,null,"change value in SA switch (between 0 and 6) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,"total cost URS","total cost SWL","incremental cost"]
[0,3252.1376326034288,864.6964288850877,{"$f":"B185-C185","v":2387.4412037183411}]
[1,2529.7497617712438,810.38581136930088,{"$f":"B186-C186","v":1719.3639504019429}]
[2,2736.1462962947248,825.90313065952591,1910.2431656351989]
[3,2942.5428308182063,841.4204499497506,2101.1223808684558]
[4,3148.9393653416878,856.9377692399753,2292.0015961017125]
[5,3355.3358998651697,872.45508853019999,2482.8808113349696]
[6,3561.7324343886507,887.97240782042491,2673.7600265682258]
[]
["SA8 continued: Two way sensitivity analysis exploring QoL differences - varying time between treatments and initial SWL effectiveness"]
[]
[]
[null,"QoL difference between stone free and not stone free health state"]
[null,null,"time to retreatments"]
[null,null,{"$f":"2/52","v":3.8461538461538464E-2},{"$f":"4/52","v":7.6923076923076927E-2},{"$f":"8/52","v":0.15384615384615385},{"$f":"12/52","v":0.23076923076923078},{"$f":"16/52","v":0.30769230769230771},{"$f":"20/52","v":0.38461538461538464}]
[null,"cost difference","2 weeks","4 weeks","8 weeks","12 weeks","16 weeks","20 weeks","Difference in effectiveness between primary URS and SWL that corresponds to the cost difference"]
[null,{"$f":"D133","v":2387.4412037183411},{"$f":"(($B200/20000)/C$198)/$I200","v":27.756430254611605},{"$f":"(($B200/20000)/D$198)/$I200","v":13.878215127305802},6.9391075636529012,4.6260717091019341,3.4695537818264506,2.7756430254611604,{"$f":"G133","v":0.11181818181818182}]
[null,2305.6300802135111,{"$f":"(($B201/20000)/C$198)/$I201","v":19.486117108187468},9.743058554093734,4.871529277046867,3.2476861846979115,2.4357646385234335,1.9486117108187471,0.15381818181818185,null,null,"values in red are above the feasible range on the EQ-5D"]
[null,2223.8189567086811,14.763514893655582,7.3817574468277911,3.6908787234138956,2.4605858156092637,1.8454393617069478,1.4763514893655585,0.19581818181818189]
[null,2142.0078332038511,11.708987773247346,5.8544938866236729,2.9272469433118364,1.951497962207891,1.4636234716559182,1.1708987773247344,0.23781818181818193,null,null,"the longer you wait for retreatments, the longer that the additional people with a stone who failed SWL have to wait and therefore the more favourable URS appears because more people are initially stone free and avoided that length of time with a stone."]
[null,2060.1967096990211,9.5714142133515239,4.7857071066757619,2.392853553337881,1.5952357022252537,1.1964267766689405,0.95714142133515223,0.27981818181818197]
[null,1978.3855861941906,7.9917835826488446,3.9958917913244223,1.9979458956622111,1.3319639304414741,0.99897294783110557,0.79917835826488448,0.321818181818182]
[null,1896.5744626893606,6.7768652714787203,3.3884326357393602,1.6942163178696801,1.1294775452464534,0.84710815893484004,0.67768652714787203,0.36381818181818204]
[null,1814.7633391845302,5.813421987083057,2.9067109935415285,1.4533554967707643,0.9689036645138428,0.72667774838538213,0.58134219870830572,0.40581818181818208]
[null,1732.9522156797004,5.0306976622451689,2.5153488311225844,1.2576744155612922,0.83844961037419474,0.62883720778064611,0.50306976622451682,0.44781818181818206]
[null,1651.1410921748707,4.3822044577024206,2.1911022288512103,1.0955511144256052,0.73036740961706992,0.54777555721280258,0.438220445770242,0.48981818181818204]
[null,1569.3299686700407,{"$f":"(($B210/20000)/C$198)/$I210","v":3.8361399234156557},1.9180699617078278,0.95903498085391392,0.63935665390260921,0.47951749042695696,0.38361399234156551,0.53181818181818175]

{"sheet":"Scenario 3","index":5,"n_rows":152,"n_cols":29,"rows_kept":152,"cut":false,"hidden":false,"merged":[[32,25,32,28],[42,25,42,28]]}
["ANALYSIS"]
[null,"KEY: SF = stone free, NSF = non stone free"]
[]
[null,"first line",null,null,"second line",null,null,null,"third line",null,null,"end of trial","fourth line"]
[null,null,null,null,"(4 weeks)",null,null,null,"(8 weeks)",null,null,"(12 weeks)",null,null,null,null,null,null,null,"Total costs"]
[null,null,null,null,{"$f":"1/12","v":8.3333333333333329E-2},null,null,null,{"$f":"2/12","v":0.16666666666666666},null,null,{"$f":"3/12","v":0.25},null,null,"QALY assumptions",null,null,null,null,"1st line","2nd line","3rd line","4th line"]
[null,null,"SF",null,null,null,null,null,null,null,null,null,null,null,null,null,"primary intervention cost",null,null,{"$f":"A13*URS_cost","v":2172005.2294566198}]
[null,null,{"$f":"Primary_URS_success*A13","v":908.0459770114943},null,null,null,null,null,null,null,null,null,null,null,{"$f":"C8*$E$69*$L$6","v":198.40804597701151},null,null,"removing stent ",null,{"$f":"prop_requiring_stent_removal_URS*A13*Stent_removal_cost","v":712270.39364966098}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"retreatment",null,null,null,{"$f":"E16*URS_cost","v":0},{"$f":"I23*URS_cost","v":24965.577350076088},{"$f":"M25*URS_cost","v":24965.577350076088}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"removing stent ",null,null,{"$f":"E16*prop_requiring_stent_removal_URS*Stent_removal_cost","v":0},{"$f":"I23*prop_requiring_stent_removal_URS*Stent_removal_cost","v":8187.016018961619},{"$f":"M25*prop_requiring_stent_removal_URS*Stent_removal_cost","v":8187.016018961619}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W10:W11)","v":33152.593369037706}]
[1000,"URS",null,null,null,null,"SF",null,null,null,null,null,null,null,null,null,"ancillary procedures",null,null,null,{"$f":"(E21*Scen3_URS_proportion_PCNL_2nd_line*PCNL_cost)+(E21*((Scen3_URS_proportion_SWL_2nd_line*SWL_cost_per_session)+(Scen3_URS_proportion_SWL_2nd_line*(prop_requiring_stent_insertion_SWL*stent_insertion_cost+prop_requiring_stent_insertion_SWL*Stent_removal_cost))))","v":151977.83647208268}]
[null,null,null,null,null,null,{"$f":"URS_2ndline_retreat_success*'Scenario 3'!E16","v":0},null,null,null,"SF",null,null,null,{"$f":"G14*((($E$69-$E$68)*$E$6)+($E$69*($L$6-$E$6)))","v":0}]
[null,null,null,null,"retreat",null,null,null,null,null,{"$f":"URS_3rdline_success*I17","v":0},null,null,null,{"$f":"K15*((($E$69-$E$68)*$I$6)+($E$69*($L$6-$I$6)))","v":0}]
[null,null,"NSF",null,{"$f":"URS_2ndline_retreat_prob*C17","v":0},null,"NSF",null,"ancillary",null,null,null,null,null,null,null,"Follow up (consult + imaging)"]
[null,null,{"$f":"Primary_URS_failure*A13","v":91.954022988505741},null,null,null,{"$f":"URS_2ndline_retreat_failure*E16","v":0},null,{"$f":"1*G17","v":0},null,"NSF",null,null,null,null,null,null,"primary intvn follow up",null,{"$f":"A13*(Inputs!$C$110*follow_up+Inputs!$C$111*Ultrasound_cost)","v":108225.92362266051}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G17-K15","v":0},null,null,null,{"$f":"K18*(($E$69-$E$68)*$L$6)","v":0},null,null,"retreatment follow up",null,null,{"$f":"E16*(Inputs!$C$110*follow_up+Inputs!$C$111*Ultrasound_cost)","v":0},{"$f":"I23*(Inputs!$C$110*follow_up+Inputs!$C$111*Ultrasound_cost)","v":1243.976133593799},{"$f":"M25*(Inputs!$C$110*follow_up+Inputs!$C$111*Ultrasound_cost)","v":1243.976133593799}]
[null,null,null,null,null,null,"SF",null,null,null,null,null,null,null,null,null,null,"ancillary follow up",null,null,{"$f":"E21*(Inputs!$C$110*follow_up+Inputs!$C$111*Ultrasound_cost)","v":9951.8090687503918}]
[null,null,null,null,"ancillary",null,{"$f":"URS_2ndline_ancillary_success*E21","v":80.459770114942529},null,null,null,null,null,null,null,{"$f":"G20*((($E$69-$E$68)*$E$6)+($E$69*($L$6-$E$6)))","v":16.306612527069799},null,null,null,null,null,null,null,null,{"$f":"SUM(W17:W19)","v":1243.976133593799}]
[null,null,null,null,{"$f":"URS_2ndline_ancillary_prob*C17","v":91.954022988505741},null,null,null,null,null,"SF",null,null,null,null,null,"readmission to hospital",null,null,{"$f":"IF($R$80=3,0,IF($R$80=4,0,A13*readmin_URS*Rehosp_cost))","v":38387.067414024874}]
[null,null,null,null,null,null,"NSF",null,"retreat",null,{"$f":"URS_3rdline_success*'Scenario 3'!G23","v":0},null,null,null,{"$f":"K22*((($E$69-$E$68)*$I$6)+($E$69*($L$6-$I$6)))","v":0},null,"Minor adverse events",null,null,{"$f":"IF($R$80=4,0,A13*minorAE_URS*minorAE_cost)","v":2660.8811565548381}]
[null,null,null,null,null,null,{"$f":"URS_2ndline_ancillary_failure*'Scenario 3'!E21","v":11.494252873563218},null,{"$f":"1*G23","v":11.494252873563218},null,null,null,null,null,null,null,"Major adverse events",null,null,{"$f":"IF($R$80=3,A13*Inputs!S77*majorAE_cost,IF($R$80=4,A13*Inputs!S80*majorAE_cost,A13*majorAE_URS*majorAE_cost))","v":10351.568740860641}]
[null,null,null,null,null,null,null,null,null,null,"NSF",null,"retreat"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I23-K22","v":11.494252873563218},null,{"$f":"K25","v":11.494252873563218},null,{"$f":"K25*(($E$69-$E$68)*$L$6)","v":1.96555972013993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(T7:V23)","v":3240227.2790838466}]
["sum",null,{"$f":"SUM(C8:C25)","v":1000},null,{"$f":"SUM(E8:E25)","v":91.954022988505741},null,{"$f":"SUM(G8:G25)","v":91.954022988505741},null,{"$f":"SUM(I8:I25)","v":11.494252873563218},null,{"$f":"SUM(K8:K25)","v":11.494252873563218},null,null,"total",{"$f":"SUM(O7:O25)","v":216.68021822422125},null,null,null,null,null,null,"with 4th line",{"$f":"SUM(T7:W23)","v":3274623.8485864783}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total costs",null,null,null,null,null,"Results breakdown for report"]
[null,"first line",null,null,"second line",null,null,null,"third line",null,null,null,null,null,null,null,null,null,null,"1st line","2nd line","3rd line","4th line",null,null,null,"First line","Second line","Third line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"URS"]
[null,null,"SF",null,null,null,null,null,null,null,null,null,null,null,null,null,"primary intervention",null,null,{"$f":"A40*No_initial_sessions*SWL_cost_per_session","v":451622.61463317403},null,null,null,null,null,"primary intervention",{"$f":"SUM(T7:T8)","v":2884275.6231062808}]
[null,null,{"$f":"Primary_SWL_success*A40","v":550.72463768115938},null,null,null,null,null,null,null,null,null,null,null,{"$f":"C35*$E$69*$L$6","v":120.33333333333333},null,"inserting + removing stent",null,null,{"$f":"prop_requiring_stent_insertion_SWL*A40*(stent_insertion_cost+Stent_removal_cost)","v":20350.582675704602},null,null,null,null,null,"retreatment",null,{"$f":"SUM(U10:U11)","v":0},{"$f":"SUM(V10:V11)","v":33152.593369037706}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ancillary procedures",null,{"$f":"U13","v":151977.83647208268}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"retreatment",null,null,null,{"$f":"E43*No_repeat_sessions*SWL_cost_per_session","v":52362.042276310029},null,null,null,null,"Follow up (consult + imaging)",{"$f":"T17","v":108225.92362266051},{"$f":"SUM(U18:U19)","v":9951.8090687503918},{"$f":"V18","v":1243.976133593799}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inserting + removing stent",null,null,{"$f":"E43*prop_requiring_stent_insertion_SWL*(stent_insertion_cost+Stent_removal_cost)","v":2359.4878464585045},null,null,null,null,"readmission to hospital",{"$f":"T21","v":38387.067414024874}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor adverse events",{"$f":"T22","v":2660.8811565548381}]
[1000,"SWL",null,null,null,null,"SF",null,null,null,null,null,null,null,null,null,"ancillary procedures",null,null,null,{"$f":"E48*(scen3_SWL_proportion_PCNL_2nd_line*PCNL_cost + Scen3_SWL_proportion_URS_2nd_line*URS_cost)","v":855441.35468056926},{"$f":"(I44+I50)*URS_cost","v":188870.01995274957},{"$f":"(M45+M52)*URS_cost","v":157391.68329395796},null,null,"Major adverse events",{"$f":"T23","v":10351.568740860641}]
[null,null,null,null,null,null,{"$f":"SWL_2ndline_retreat_success*'Scenario 3'!E43","v":72.463768115942017},null,null,null,"SF",null,null,null,{"$f":"G41*((($E$69-$E$68)*$E$6)+($E$69*($L$6-$E$6)))","v":14.686079605124972},null,null,"removing stent (if URS)",null,null,{"$f":"E48*(Scen3_SWL_proportion_URS_2nd_line*prop_requiring_stent_removal_URS*Stent_removal_cost)","v":206455.1865651191},{"$f":"(I44+I50)*prop_requiring_stent_removal_URS*Stent_removal_cost","v":61936.555969535737},{"$f":"(M45+M52)*prop_requiring_stent_removal_URS*Stent_removal_cost","v":51613.796641279783},null,null,null,null,"TOTAL",{"$f":"W26","v":3240227.2790838466}]
[null,null,null,null,"retreat",null,null,null,null,null,{"$f":"SWL_3rdline_success*'Scenario 3'!I44","v":7.2463768115942013},null,null,null,{"$f":"K42*((($E$69-$E$68)*$I$6)+($E$69*($L$6-$I$6)))","v":1.3538825876916611},null,null,null,null,null,null,null,null,{"$f":"SUM(W40:W41)","v":209005.47993523773}]
[null,null,"NSF",null,{"$f":"SWL_2ndline_retreat_prob*C44","v":115.94202898550724},null,"NSF",null,"ancillary",null,null,null,null,null,null,null,"Follow up (consult + imaging)",null,null,null,null,null,null,null,null,"SWL"]
[null,null,{"$f":"Primary_SWL_failure*A40","v":449.27536231884056},null,null,null,{"$f":"SWL_2ndline_retreat_failure*E43","v":43.478260869565212},null,{"$f":"1*G44","v":43.478260869565212},null,"NSF",null,"ancillary",null,null,null,null,"primary intvn follow up",null,{"$f":"A40*(Inputs!$D$110*follow_up+Inputs!$D$111*Ultrasound_cost)","v":108225.92362266051},null,null,null,null,null,"primary intervention",{"$f":"SUM(T34:T35)","v":471973.19730887865}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G44-K42","v":36.231884057971008},null,{"$f":"K45","v":36.231884057971008},null,{"$f":"K45*(($E$69-$E$68)*$L$6)","v":6.1957860743541264},null,null,"retreatment follow up",null,null,{"$f":"E43*(Inputs!$D$110*follow_up+Inputs!$D$111*Ultrasound_cost)","v":12547.933173641797},null,null,null,null,"retreatment",null,{"$f":"SUM(U37:U38)","v":54721.530122768534}]
[null,null,null,null,null,null,"SF",null,null,null,null,null,null,null,null,null,null,"ancillary follow up",null,null,{"$f":"E48*(Inputs!$D$110*follow_up+Inputs!$D$111*Ultrasound_cost)","v":36075.307874220169},{"$f":"(I44+I50)*(Inputs!$D$110*follow_up+Inputs!$D$111*Ultrasound_cost)","v":9410.9498802313501},{"$f":"(M45+M52)*(Inputs!$D$110*follow_up+Inputs!$D$111*Ultrasound_cost)","v":7842.4582335261248},null,null,"ancillary procedures",null,{"$f":"SUM(U40:U41)","v":1061896.5412456885},{"$f":"SUM(V40:V41)","v":250806.57592228532}]
[null,null,null,null,"ancillary",null,{"$f":"SWL_2ndline_ancillary_success*E48","v":289.85507246376807},null,null,null,null,null,null,null,{"$f":"G47*((($E$69-$E$68)*$E$6)+($E$69*($L$6-$E$6)))","v":58.744318420499887},null,null,null,null,null,null,null,null,{"$f":"SUM(W45:W46)","v":7842.4582335261248},null,"Follow up (consult + imaging)",{"$f":"T44","v":108225.92362266051},{"$f":"SUM(U45:U46)","v":48623.241047861964},{"$f":"V46","v":9410.9498802313501}]
[null,null,null,null,{"$f":"SWl_2ndline_ancillary_prob*C44","v":333.33333333333331},null,null,null,null,null,"SF",null,null,null,null,null,"readmission to hospital",null,null,{"$f":"IF($R$80=3,0,IF($R$80=4,0,A40*readmin_SWL*Rehosp_cost))","v":19193.533707012437},null,null,null,null,null,"readmission to hospital",{"$f":"T48","v":19193.533707012437}]
[null,null,null,null,null,null,"NSF",null,"ancillary",null,{"$f":"SWL_3rdline_success*'Scenario 3'!I50","v":7.246376811594204},null,null,null,{"$f":"K49*((($E$69-$E$68)*$I$6)+($E$69*($L$6-$I$6)))","v":1.3538825876916616},null,"Minor adverse events",null,null,{"$f":"IF($R$80=4,0,A40*minorAE_SWL*minorAE_cost)","v":1782.7903748917413},null,null,null,null,null,"Minor adverse events",{"$f":"T49","v":1782.7903748917413}]
[null,null,null,null,null,null,{"$f":"SWL_2ndline_ancillary_failure*'Scenario 3'!E48","v":43.478260869565226},null,{"$f":"1*G50","v":43.478260869565226},null,null,null,null,null,null,null,"Major adverse events",null,null,{"$f":"IF($R$80=3,A40*Inputs!U77*majorAE_cost,IF($R$80=4,A40*Inputs!U80*majorAE_cost,A40*majorAE_SWL*majorAE_cost))","v":1552.7353111290959},null,null,null,null,null,"Major adverse events",{"$f":"T50","v":1552.7353111290959}]
[null,null,null,null,null,null,null,null,null,null,"NSF",null,"ancillary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"W53","v":2028187.0185434083}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G50-K49","v":36.231884057971023},null,{"$f":"K52","v":36.231884057971023},null,{"$f":"K52*(($E$69-$E$68)*$L$6)","v":6.1957860743541282}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(T33:V50)","v":2028187.0185434083}]
["sum",null,{"$f":"SUM(C35:C52)","v":1000},null,{"$f":"SUM(E35:E52)","v":449.27536231884056},null,{"$f":"SUM(G35:G52)","v":449.27536231884051},null,{"$f":"SUM(I35:I52)","v":86.956521739130437},null,{"$f":"SUM(K35:K52)","v":86.956521739130437},null,null,"total",{"$f":"SUM(O34:O52)","v":208.86306868304973},null,null,null,null,null,null,"with 4th line",{"$f":"SUM(T34:W50)","v":2245034.9567121714}]
[]
[]
[]
["RESULTS"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost per patient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"URS ",{"$f":"W26/1000","v":3240.2272790838465}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SWL ",{"$f":"W53/1000","v":2028.1870185434082}]
[null,null,null,null,null,null,null,null,"Analysis selected:",null,{"$f":"IF(R80=1,\"base case\",IF(R80=2,\"SA13\",IF(R80=3,\"SA15\",\"SA16\")))","v":"base case"},null,null,"incremental",{"$f":"O62-O63","v":1212.0402605404383}]
[]
["QALY/QoL exploratory analyses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES"]
[]
[null,"utility decrement from stone",null,null,{"$f":"E69-Inputs!G238","v":0.18998521739130436},null,"what would utility decrement have to be to make URS cost effective?",null,null,null,null,null,null,1.47,null,"uses Goal seek",null,null,"INSERT ALTERNATIVE VALUES INTO GREY CELL (E68) TO SEE IMPACT ON ICER"]
[null,"uk general population utility",null,null,{"$f":"Inputs!G236","v":0.874}]
[null,null,null,null,null,null,"this would make the utility of not having a stone of:",null,null,null,null,null,null,{"$f":"E69-N68","v":-0.59599999999999997}]
[]
[null,null,null,null,"QALY per patient"]
[null,"URS",null,null,{"$f":"O27/1000","v":0.21668021822422126}]
[null,"SWL",null,null,{"$f":"O54/1000","v":0.20886306868304974}]
[null,"incremental ",null,null,{"$f":"E73-E74","v":7.8171495411715197E-3}]
[null,"ICER",null,null,{"$f":"O64/E75","v":155048.87736339704}]
[]
["SENSITIVITY ANALYSES"]
[]
["SA12. Including fourth line treatments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,"Cost per patient"]
[null,null,null,"URS ",{"$f":"W27/1000","v":3274.6238485864783}]
[null,null,null,"SWL ",{"$f":"W54/1000","v":2245.0349567121716}]
[null,null,null,"incremental",{"$f":"E83-E84","v":1029.5888918743067}]
[]
["SA13. Varying the effectiveness of the primary SWL"]
[]
[null,null,null,"SA switch",10]
[]
[null,null,null,null,null,null,"effectiveness of primary SWL"]
[null,null,null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA13_switch,Inputs!$AM$125:$AN$135,2,FALSE)","v":0.4},null,null,null,null,null,null,null,null,null,null,null,"change value in SA switch (between 0 and 10) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,null,null,null,"Total cost of SWL strategy per pt","Incremental cost (URS - SWL)","Total QALY SWL per pt","Incremental QALY (URS - SWL)","ICER"]
[null,null,null,0,894.47948870306607,{"$f":"$O$62-E96","v":2345.7477903807803},0.21652759136560751,{"$f":"$E$73-G96","v":1.5262685861375247E-4},{"$f":"F96/H96","v":15369167.731592271}]
[null,null,null,{"$f":"D96+1","v":1},1121.2209946711346,2119.0062844127119,0.214994686829096,{"$f":"$E$73-G97","v":1.685531395125256E-3},{"$f":"F97/H97","v":1257174.0227094633}]
[null,null,null,2,1347.962500639203,1892.2647784446435,0.21346178229258442,3.2184359316368427E-3,587945.45507148537]
[null,null,null,3,1574.7040066072716,1665.5232724765749,0.21192887775607283,4.7513404681484295E-3,350537.55537868664]
[null,null,null,4,1801.4455125753398,1438.7817665085067,0.2103959732195613,6.2842450046599607E-3,228950.61625407758]
[null,null,null,5,2028.1870185434082,1212.0402605404383,0.20886306868304974,7.8171495411715197E-3,155048.87736339704]
[null,null,null,6,2123.8307083335753,1116.3965707502712,0.20821646167855762,8.4637565456636421E-3,131903.19980579434]
[null,null,null,7,2219.4743981237425,1020.752880960104,0.20756985467406552,9.1103635501557367E-3,112043.04584998199]
[null,null,null,8,2315.1180879139092,925.10919116993728,0.20692324766957335,{"$f":"$E$73-G104","v":9.7569705546479146E-3},94815.207854577806]
[null,null,null,{"$f":"D104+1","v":9},2410.7617777040764,{"$f":"$O$62-E105","v":829.4655013797701},0.20627664066508117,{"$f":"$E$73-G105","v":1.0403577559140093E-2},{"$f":"F105/H105","v":79728.871790938952}]
[null,null,null,10,2506.4054674942427,733.82181158960384,0.20563003366058907,{"$f":"$E$73-G106","v":1.1050184563632187E-2},{"$f":"F106/H106","v":66408.104531097284}]
[]
[]
["SA14. Omitting readmission from the analysis"]
[]
[null,null,null,null,"Cost per patient"]
[null,null,null,"URS ",{"$f":"SUM(T7:V19)/1000","v":3188.8277617724061}]
[null,null,null,"SWL ",{"$f":"SUM(T34:V46)/1000","v":2005.6579591503748}]
[null,null,null,"incremental",{"$f":"E112-E113","v":1183.1698026220313},null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated through calculations rather than macro"]
[]
["SA15. Pooled readmission and major adverse events"]
[]
[null,null,null,null,"Cost per patient"]
[null,null,null,"URS ",3204.1524177459592]
[null,null,null,"SWL ",2009.8468667404964]
[null,null,null,"incremental",{"$f":"E119-E120","v":1194.3055510054628}]
[]
["SA16. Pooled minor and major adverse events (readmissions also excluded)"]
[]
[null,null,null,null,"Cost per patient"]
[null,null,null,"URS ",3202.5527467695997]
[null,null,null,"SWL ",2010.5989537493645]
[null,null,null,"incremental",{"$f":"E126-E127","v":1191.9537930202353}]
[]
["SA17. Varying proportion of URS that get stents"]
[]
[null,null,null,"SA switch",0]
[]
[null,null,null,null,null,null,"Proportion having stent"]
[null,null,null,"Corresponding input values being tested",null,null,{"$f":"VLOOKUP(SA17_switch,Inputs!$B$161:$C$167,2,FALSE)","v":0.7},null,null,null,null,null,null,null,null,null,null,null,"change value in SA switch (between 0 and 6) to see inputs that led to the results in the corresponding number row"]
[]
[]
[null,null,null,null,"total cost URS","total cost SWL","incremental cost"]
[null,null,null,0,3240.2272790838465,2028.1870185434082,{"$f":"E139-F139","v":1212.0402605404383}]
[null,null,null,1,2519.7698694152241,1759.7952760087533,{"$f":"E140-F140","v":759.97459340647083}]
[null,null,null,2,2725.614843606259,1836.4786310186548,889.13621258760418]
[null,null,null,3,2931.4598177972939,1913.1619860285559,1018.297831768738]
[null,null,null,4,3137.3047919883288,1989.8453410384575,1147.4594509498713]
[null,null,null,5,3343.1497661793642,2066.5286960483591,1276.6210701310051]
[null,null,null,6,3548.9947403703995,2143.2120510582599,1405.7826893121396]
[]
["SA18. Varying cost of SWL"]
[null,null,null,null,null,null,null,null,"incremental cost"]
["SA18.a","If assume have two initial sessions?",null,null,null,null,null,null,760.41764590726461]
[null,"this leads to an ICER of….",null,null,null,null,null,null,{"$f":"I149/E75","v":97275.565972261596}]
[]
["SA18.b","threshold analysis: what is the cost of 1 session of SWL to make the comparators cost neutral?",null,null,null,null,null,null,1609,null,null,null,null,null,null,null,null,null,"Uses goal seek"]

{"sheet":"Sheet1","index":6,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["ROUGH CALCS"]
[]
[]
["best case scenario assuming extreme utilities",null,null,null,null,null,null,null,null,"TOTAL",3238872.2605612809]
[null,null,null,null,null,null,null,null,null,"with 4th line",3273268.8300639126]
[null,null,null,null,1000,null,null,null,null,"TOTAL",2028172.8423319603]
[null,null,"utility","ly","qaly","qaly gain",null,null,null,"with 4th line",2245020.7805007235]
[null,"no stone",1,{"$f":"3/12","v":0.25},{"$f":"D8*C8","v":0.25}]
[null,"renal stone",{"$f":"-'Scenario 1'!#REF!","v":{"$error":"#REF!"}},{"$f":"3/12","v":0.25},{"$f":"D9*C9","v":{"$error":"#REF!"}},{"$f":"E8-E9","v":{"$error":"#REF!"}}]
[]
[]
["n",1000]
[null,"probability of success","success","failure","success qaly","failure qaly","total qalys"]
["URS",0.93,{"$f":"B12*B14","v":930},{"$f":"B12-C14","v":70},{"$f":"C14*E8","v":232.5},{"$f":"D14*E9","v":{"$error":"#REF!"}},{"$f":"SUM(E14:F14)","v":{"$error":"#REF!"}}]
["SWL",{"$f":"B14-15%","v":0.78},{"$f":"B12*B15","v":780},{"$f":"B12-C15","v":220},{"$f":"C15*E8","v":195},{"$f":"D15*E9","v":{"$error":"#REF!"}},{"$f":"SUM(E15:F15)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"G14-G15","v":{"$error":"#REF!"}},"qaly gain"]
[null,null,null,null,null,null,{"$f":"G16/E6","v":{"$error":"#REF!"}},"qaly gain per person"]
[null,null,null,null,null,"cost diff.",{"$f":"'Scenario 1'!H42","v":2367.5190637911305}]
[null,null,null,null,null,null,{"$f":"G18/20000","v":0.11837595318955653},"qaly gain to make cost effective"]
[]
[null,null,null,null,null,null,{"$f":"G18/G17","v":{"$error":"#REF!"}},"ICER from calculated QALY gain",null,null,"so URS not cost effective at even very extreme utilities. And assuming only become stone free at the end of the 3 months. So very extreme assumptions"]
[]
[]
["pcnl vs swl rough calc"]
[]
[null,null,null,null,null,"sf","nsf",null,"cost"]
[null,null,"pcnl",{"$f":"857/1000","v":0.85699999999999998},null,{"$f":"1000*D27","v":857},{"$f":"1000-F27","v":143},null,{"$f":"1000*Inputs!F198","v":5195116.2946089609},null,{"$f":"G27*Inputs!#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(I27:K27)","v":{"$error":"#REF!"}}]
[null,null,"swl",{"$f":"D27*0.17","v":0.14569000000000001},null,{"$f":"1000*D28","v":145.69000000000003},{"$f":"1000-F28","v":854.31},null,{"$f":"1000*Inputs!F177","v":451622.61463317403},null,{"$f":"G28*Inputs!#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(I28:K28)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M27-M28)/1000","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M30/20000","v":{"$error":"#REF!"}},"QALY gain needed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"even bigger than URS needs"]