{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Control","Data Input","Standard t Comparisons","Paired-T Comparisons","Variance Reduction"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":15,"comments":0,"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":"Instructions","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Comparison of Multiple Scenarios"]
[]
["Instructions for use"]
[]
["1. Enter data from your scenarios into \"Data Input\" "]
["2. Choose either to compare all cases to the base case or all cases against each other"]
["3. Click on compare"]
["4. Check if common random numbers are reducing variances (details shown automatically)"]
["5. For those comparisons where common random numbers work review Paired-T Comparisons Sheet"]
["6. For those comparisons where common random numbers do not work review Standard comparisons sheet"]
[]
[]
["Author: Dr Thomas Monks, University of Exeter"]

{"sheet":"Control","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Input Parameters"]
[]
["Scenarios",{"$f":"COUNTIF('Data Input'!B7:K7, \"<>0\")","v":4}]
["Replications",{"$f":"COUNTA('Data Input'!B10:B1006)","v":10}]
[]
[]
["Bonferroni Inequality"]
[]
["Corrected Sig",{"$f":"IF('Data Input'!D4=\"To Base\", 'Data Input'!D5/(B3-1), 'Data Input'!D5/(TotalScenarios*(TotalScenarios-1)/2))","v":1.6666666666666666E-2}]
["Corrected CI",{"$f":"1-B9","v":0.98333333333333328}]

{"sheet":"Data Input","index":2,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Comparison of Multiple Scenarios: Data Input"]
[]
["1. Enter your scenario data into the columns below"]
["2. Choose comparison type here:",null,null,"Pairwise"]
["3. Choose an overall significance:",null,null,0.1]
["4. Click on Compare"]
["Mean",{"$f":"IF(COUNT(B$10:B$1006) <> 0, AVERAGE(B$10:B$1006), 0)","v":28.026767071936387},{"$f":"IF(COUNT(C$10:C$1006) <> 0, AVERAGE(C$10:C$1006), 0)","v":31.210788836786396},28.804315621005166,31.398896586012096,0,0,0,0,0,0]
["Var",{"$f":"IF(COUNT(B$10:B$1006) <> 0, VAR(B$10:B$1006), 0)","v":6.3812889764773324},{"$f":"IF(COUNT(C$10:C$1006) <> 0, VAR(C$10:C$1006), 0)","v":3.986067782488683},13.194216125795517,15.507869592772598,0,0,0,0,0,0]
["Replication","Sc1 (Base)","Sc2","Sc3","Sc4","Sc5","Sc6","Sc7","Sc8","Sc9","Sc10"]
[1,27.762880740255017,29.886941235933548,30.798407138704039,31.134466012326918]
[2,30.344269931744563,34.271177979374961,33.152839293182133,36.185097879605046]
[3,30.210400428840572,31.268862754940272,31.267599044322431,32.458279448236262]
[4,31.321911625868363,33.48580100615402,31.392702556597925,36.226945476566272]
[5,26.339517682864656,30.32709234667157,27.106831192416166,27.346566028483483]
[6,27.607609485266767,29.363917798280262,28.25285856107444,27.155069452440415]
[7,28.319178067979969,33.167176553851533,24.513426497230761,34.744888544189038]
[8,24.830332893145901,29.177524532339074,23.563397749747885,27.132604534915934]
[9,23.61462943973989,28.759397577879895,24.877159412952079,27.08626603194784]
[10,29.916940423658158,32.399996582438781,33.117934763823818,34.51878245140977]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Standard t Comparisons","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Results: Confidence Intervals for Mean Difference (use if common random numbers are not working)"]
["Mean Differences"]
["Scenarios",2,3,4]
[1,-3.184021764850006,-0.77754854906878212,-3.3721295140757119]
[2,null,2.4064732157812241,-0.18810774922570594]
[3,null,null,-2.59458096500693]
[]
[]
["Confidence Intervals for Mean Differences (Bonferroni Correction)"]
["Scenarios",2,3,4]
[1,"(-5.87, -0.5]","(-4.47, 2.91]","(-7.28, 0.53]"]
[2,null,"(-1.05, 5.87]","(-3.87, 3.5]"]
[3,null,null,"(-7.07, 1.88]"]
[]
["Significance Conclusions (Bonferroni Correction)"]
["Scenarios",2,3,4]
[1,"S1< S2","No difference","No difference"]
[2,null,"No difference","No difference"]
[3,null,null,"No difference"]

{"sheet":"Paired-T Comparisons","index":4,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Results: Paired-T Confidence Intervals for Mean Difference"]
["Mean Differences"]
["Scenarios",2,3,4]
[1,-3.184021764850006,-0.77754854906878212,-3.3721295140757119]
[2,null,2.4064732157812241,-0.18810774922570594]
[3,null,null,-2.59458096500693]
[]
[]
["Paired-t Confidence Intervals for Mean Differences (Bonferroni Correction)"]
["Scenarios",2,3,4]
[1,"(-4.51, -1.86]","(-2.76, 1.21]","(-5.37, -1.37]"]
[2,null,"(-0.4, 5.21]","(-2.18, 1.8]"]
[3,null,null,"(-5.57, 0.38]"]
[]
["Paired-t Significance Conclusions (Bonferroni Correction)"]
["Scenarios",2,3,4]
[1,"S1< S2","No difference","S1< S4"]
[2,null,"No difference","No difference"]
[3,null,null,"No difference"]

{"sheet":"Variance Reduction","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Variance Reduction: Common Random Numbers Check"]
["Variance Reduction Conclusion"]
["Scenarios",2,3,4]
[1,"Reduced","Reduced","Reduced"]
[2,null,"Reduced","Reduced"]
[3,null,null,"Reduced"]
[]
[]
["Sum of Variances"]
["Scenarios",2,3,4]
[1,10.367356758966014,19.575505102272849,21.889158569249929]
[2,null,17.180283908284199,19.493937375261282]
[3,null,null,28.702085718568114]
[]
["Variance of Differences"]
["Scenarios",2,3,4]
[1,2.0417550776560627,4.5681864385763395,4.6578844770789773]
[2,null,9.1276592608771256,4.6129101193531614]
[3,null,null,10.255982333938283]