{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Data","Conditions Compared","Methods Compared","EQ-5D Calcs","TTO and SG Calcs","Chart Data","Literature"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"Conditions Compared","index":2,"reason":"not_a_worksheet"},{"sheet":"Methods Compared","index":3,"reason":"not_a_worksheet"}],"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":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Quality Adjusted Life Years Exercise"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Students (max 500):",null,1]

{"sheet":"Data","index":1,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[1,"Visual Analogue Scale",null,null,"EQ-5D-3L",null,null,"Standard Gamble",null,null,"Time Trade Off (TTO)"]
["Respondent","A","B","C","A","B","C","A","B","C","A","B","C"]
[1,10,40,50,21121,23122,11112,0.5,0.8,0.1,2,5,0.5]

{"sheet":"EQ-5D Calcs","index":4,"n_rows":11,"n_cols":49,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Blind (A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quadriplegia (B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eczema (C) "]
[null,"Mobility",null,null,"Self-Care",null,null,"Usual Activities",null,null,"Pain",null,null,"Anxiety",null,null,null,"Mobility",null,null,"Self-Care",null,null,"Usual Activities",null,null,"Pain",null,null,"Anxiety",null,null,null,"Mobility",null,null,"Self-Care",null,null,"Usual Activities",null,null,"Pain",null,null,"Anxiety"]
["Respondent",1,2,3,1,2,3,1,2,3,1,2,3,1,2,3,"Utility",1,2,3,1,2,3,1,2,3,1,2,3,1,2,3,"Utility",1,2,3,1,2,3,1,2,3,1,2,3,1,2,3,"Utility"]
[1,{"$f":"IF(MID(Data!$E3,1,1)=\"1\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,1,1)=\"2\",1,0)","v":1},{"$f":"IF(MID(Data!$E3,1,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,2,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$E3,2,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,2,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,3,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$E3,3,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,3,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,4,1)=\"1\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,4,1)=\"2\",1,0)","v":1},{"$f":"IF(MID(Data!$E3,4,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,5,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$E3,5,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$E3,5,1)=\"3\",1,0)","v":0},{"$f":"IF(SUM(B4:P4)>0,1-IF(SUM(B4,E4,H4,K4,N4)=5,0,$A$12)-SUMPRODUCT(B4:P4,$B$12:$P$12)-IF(SUM(D4,G4,J4,M4,P4)>=1,$Q$12,0),0)","v":1},{"$f":"IF(MID(Data!$F3,1,1)=\"1\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,1,1)=\"2\",1,0)","v":1},{"$f":"IF(MID(Data!$F3,1,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,2,1)=\"1\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,2,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,2,1)=\"3\",1,0)","v":1},{"$f":"IF(MID(Data!$F3,3,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$F3,3,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,3,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,4,1)=\"1\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,4,1)=\"2\",1,0)","v":1},{"$f":"IF(MID(Data!$F3,4,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,5,1)=\"1\",1,0)","v":0},{"$f":"IF(MID(Data!$F3,5,1)=\"2\",1,0)","v":1},{"$f":"IF(MID(Data!$F3,5,1)=\"3\",1,0)","v":0},{"$f":"IF(SUM(R4:AF4)>0,1-IF(SUM(R4,U4,X4,AA4,AD4)=5,0,$A$12)-SUMPRODUCT(R4:AF4,$B$12:$P$12)-IF(SUM(T4,W4,Z4,AC4,AF4)>=1,$Q$12,0),0)","v":1},{"$f":"IF(MID(Data!$G3,1,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$G3,1,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,1,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,2,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$G3,2,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,2,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,3,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$G3,3,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,3,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,4,1)=\"1\",1,0)","v":1},{"$f":"IF(MID(Data!$G3,4,1)=\"2\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,4,1)=\"3\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,5,1)=\"1\",1,0)","v":0},{"$f":"IF(MID(Data!$G3,5,1)=\"2\",1,0)","v":1},{"$f":"IF(MID(Data!$G3,5,1)=\"3\",1,0)","v":0},{"$f":"IF(SUM(AH4:AV4)>0,1-IF(SUM(AH4,AK4,AN4,AQ4,AT4)=5,0,$A$12)-SUMPRODUCT(AH4:AV4,$B$12:$P$12)-IF(SUM(AJ4,AM4,AP4,AS4,AV4)>=1,$Q$12,0),0)","v":1}]
[]
["Average",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(Q4:Q4)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AG4:AG4)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AW4:AW4)","v":1}]
[]
["Insert tariff algorithm"]
["Coefficient values"]
[null,"Mobility",null,null,"Self-Care",null,null,"Usual Activities",null,null,"Pain",null,null,"Anxiety"]
["Constant",1,2,3,1,2,3,1,2,3,1,2,3,1,2,3,"Any = most severe"]

{"sheet":"TTO and SG Calcs","index":5,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Standard Gamble",null,null,"Time Trade Off (TTO)"]
["Respondent","A","B","C","A","B","C"]
[1,{"$f":"1-Data!H3","v":0.5},{"$f":"1-Data!I3","v":0.19999999999999996},{"$f":"1-Data!J3","v":0.9},{"$f":"(10-Data!K3)/10","v":0.8},{"$f":"(10-Data!L3)/10","v":0.5},{"$f":"(10-Data!M3)/10","v":0.95}]
[]
["AVERAGE",{"$f":"AVERAGE(B3:B3)","v":0.5},0.19999999999999996,0.9,0.8,0.5,0.95]

{"sheet":"Chart Data","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"UTILITY"]
[null,"EQ-5D","VAS","SG","TTO","Live",1]
["Blind (A)",{"$f":"'EQ-5D Calcs'!$Q$6","v":1},{"$f":"AVERAGE(Data!B3:B5)/100","v":0.1},{"$f":"'TTO and SG Calcs'!$B$5","v":0.5},{"$f":"'TTO and SG Calcs'!$E$5","v":0.8},{"$f":"INDEX(B3:E3,1,$G$2)","v":1}]
["Quadriplegia (B)",{"$f":"'EQ-5D Calcs'!$AG$6","v":1},{"$f":"AVERAGE(Data!C3:C5)/100","v":0.4},{"$f":"'TTO and SG Calcs'!$C$5","v":0.19999999999999996},{"$f":"'TTO and SG Calcs'!$F$5","v":0.5},{"$f":"INDEX(B4:E4,1,$G$2)","v":1}]
["Eczema (C) ",{"$f":"'EQ-5D Calcs'!$AW$6","v":1},{"$f":"AVERAGE(Data!D3:D5)/100","v":0.5},{"$f":"'TTO and SG Calcs'!$D$5","v":0.9},{"$f":"'TTO and SG Calcs'!$G$5","v":0.95},{"$f":"INDEX(B5:E5,1,$G$2)","v":1}]
["LIVE",{"$f":"INDEX(B3:B5,$A$7)","v":1},{"$f":"INDEX(C3:C5,$A$7)","v":0.1},{"$f":"INDEX(D3:D5,$A$7)","v":0.5},{"$f":"INDEX(E3:E5,$A$7)","v":0.8}]
[1]
[]
["EQ-5D"]
["VAS"]
["SG"]
["TTO"]

{"sheet":"Literature","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["EXAMPLE HEALTH STATE UTILITIES IN THE LITERATURE"]
[]
["Condition","Health State Utilities"]
["Blind","0.33 (SD = 0.27, RS or VAS)\n0.26 (95% CI, 0.19-0.33, TTO)"]
["Quadraplegia","0.09 (SD= 0.15, TTO)\n0.29 (SD = 0.33, SG)"]
["Eczema","0.73 (VAS)\n0.93 (TTO)\n0.98 (SG)"]
[]
["Sources:"]
["Lundberg L, Johannesson M, Silverdahl M, Hermansson C, Lindberg M. Quality of life, health-state utilities and willingness to pay in patients with psoriasis and atopic eczema. Br J Dermatol. 1999 Dec;141(6):1067-75.\n\n"]
["Tengs, T and Wallace A. One Thousand Health-Related Quality of Life Estimates Medical Care 38(6) 583-637, 2000"]
["Brown MM, Brown GC, Sharma S, Kistler J, Brown H. Utility values associated with blindness in an adult population. Br J Ophthalmol. 2001 Mar;85(3):327-31.\n\n"]