{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INDEX CALCULATOR","VAS","TTO","notes","Charts"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"INDEX CALCULATOR","index":0,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,2,1,8]]}
[]
[]
[]
[null,null,"Please enter health state description:"]
[]
[null,null,"Mobility",null,3]
[]
[null,null,"Self-care",null,3]
[]
[null,null,"Usual activities",null,3]
[]
[null,null,"Pain/Discomfort",null,3]
[]
[null,null,"Anxiety/Discomfort",null,3]
[]
[]
[null,null,"Select country/survey of interest:",null,null,"New Zealand",null,null,null,null,null,null,null,null,null,"Belgium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Denmark"]
[null,null,"TTO Score",null,null,"VAS Score",null,null,null,null,null,null,null,null,null,"Finland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Germany"]
[{"$f":"F17","v":"New Zealand"},null,{"$f":"VLOOKUP(F17,Table,3,FALSE)","v":"Not available"},null,null,{"$f":"VLOOKUP(F17,Table,6,FALSE)","v":-8.4799999999999959E-2},null,null,null,null,null,null,null,null,null,"Japan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netherlands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Zealand"]
[null,null,"Results for all countries/surveys:",null,null,null,null,null,null,null,null,null,null,null,null,"Slovenia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spain"]
[null,null,"TTO Score",null,null,"VAS Score",null,null,null,null,null,null,null,null,null,"UK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USA"]
["Belgium",null,{"$f":"TTO!J27","v":"Not available"},null,null,{"$f":"VAS!B22","v":-0.15800000000000008},null,null,null,null,null,null,null,null,null,"Zimbabwe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Europe"]
["Denmark",null,{"$f":"TTO!B27","v":-0.624},null,null,{"$f":"VAS!C22","v":-0.16699999999999995}]
[]
["Finland",null,{"$f":"TTO!K27","v":"Not available"},null,null,{"$f":"VAS!E22","v":-1.1000000000000038E-2}]
[]
["Germany",null,{"$f":"TTO!C27","v":-0.20700000000000007},null,null,{"$f":"VAS!F22","v":2.0699559336655401E-2}]
[]
["Japan",null,{"$f":"TTO!D27","v":-0.111},null,null,{"$f":"VAS!K22","v":"Not available"}]
[]
["Netherlands",null,{"$f":"TTO!E27","v":-0.32900000000000001},null,null,{"$f":"VAS!L22","v":"Not available"}]
[]
["New Zealand",null,{"$f":"TTO!L27","v":"Not available"},null,null,{"$f":"VAS!G22","v":-8.4799999999999959E-2}]
[]
["Slovenia",null,{"$f":"TTO!M27","v":"Not available"},null,null,{"$f":"VAS!H22","v":-0.24199999999999997}]
[]
["Spain",null,{"$f":"TTO!F27","v":-0.65400000000000003},null,null,{"$f":"VAS!I22","v":-7.5700000000000031E-2}]
[]
["UK",null,{"$f":"TTO!G27","v":-0.59399999999999997},null,null,{"$f":"VAS!J22","v":-7.2999999999999982E-2}]
[]
["USA",null,{"$f":"TTO!H27","v":-0.10907070000000005},null,null,{"$f":"VAS!M22","v":"Not available"}]
[]
["Zimbabwe",null,{"$f":"TTO!I27","v":-0.14499999999999991},null,null,{"$f":"VAS!N22","v":"Not available"}]
[]
["Europe",null,{"$f":"TTO!N27","v":"Not available"},null,null,{"$f":"VAS!D22","v":-7.4200000000000016E-2}]

{"sheet":"VAS","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["VAS value sets","Belgium","Denmark","Europe","Finland","Germany ","New Zealand","Slovenia","Spain","UK","Japan","Netherlands","USA","Zimbabwe"]
["Full health (11111)",1,1,1,1,1,1,1,1,1]
[]
["At least one 2 or 3 (constant)",-0.152,-0.22500000000000001,-0.12790000000000001,-0.158,0.92559999999999998,-0.2041,-0.128,-0.1502,-0.155]
["At least one 3 (N3)",-0.25600000000000001,"-",-0.2288,"-","-",-0.2165,"-",-0.21190000000000001,-0.215]
[]
["Mobility = 2",-7.3999999999999996E-2,-0.126,-6.59E-2,-5.8000000000000003E-2,0.94469999999999998,-7.5300000000000006E-2,-0.20599999999999999,-8.9700000000000002E-2,-7.0999999999999994E-2]
["Mobility = 3",-0.14799999999999999,-0.252,-0.18290000000000001,-0.23,0.39269999999999999,-0.15060000000000001,-0.41199999999999998,-0.1794,-0.182]
[]
["Self care = 2",-8.3000000000000004E-2,-0.112,-0.1173,-9.8000000000000004E-2,0.80800000000000005,-7.1400000000000005E-2,-9.2999999999999999E-2,-0.1012,-9.2999999999999999E-2]
["Self care = 3",-0.16600000000000001,-0.224,-0.15590000000000001,-0.14299999999999999,0.47020000000000001,-0.14280000000000001,-0.186,-0.2024,-0.14499999999999999]
[]
["Usual activities = 2",-3.1E-2,-6.4000000000000001E-2,-2.64E-2,-4.7E-2,0.88029999999999997,-1.3599999999999999E-2,-5.3999999999999999E-2,-5.5100000000000003E-2,-3.1E-2]
["Usual activities = 3",-6.2E-2,-0.128,-8.5999999999999993E-2,-0.13100000000000001,0.55379999999999996,-2.7199999999999998E-2,-0.108,-0.11020000000000001,-8.1000000000000003E-2]
[]
["Pain/discomfort = 2",-8.4000000000000005E-2,-7.8E-2,-9.2999999999999999E-2,-0.111,0.97450000000000003,-7.9799999999999996E-2,-0.111,-5.96E-2,-8.4000000000000005E-2]
["Pain/discomfort = 3",-0.16800000000000001,-0.156,-0.16370000000000001,-0.153,0.46710000000000002,-0.15959999999999999,-0.222,-0.1192,-0.17100000000000001]
[]
["Anxiety/depression = 2",-0.10299999999999999,-9.0999999999999998E-2,-8.9099999999999999E-2,-0.16,0.81740000000000002,-9.1999999999999998E-2,-9.2999999999999999E-2,-5.1200000000000002E-2,-6.3E-2]
["Anxiety/depression = 3",-0.20599999999999999,-0.182,-0.129,-0.19600000000000001,0.46820000000000001,-0.184,-0.186,-0.1024,-0.124]
[null,null,null,null,null,"multiplicative"]
[null,{"$f":"VAS!B2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!B4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*VAS!B5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!B7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!B8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!B10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!B11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!B13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!B14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!B16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!B17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!B19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!B20)","v":-0.15800000000000008},{"$f":"VAS!C2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!C4)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!C7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!C8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!C10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!C11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!C13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!C14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!C16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!C17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!C19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!C20)","v":-0.16699999999999995},{"$f":"VAS!D2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!D4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*VAS!D5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!D7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!D8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!D10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!D11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!D13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!D14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!D16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!D17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!D19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!D20)","v":-7.4200000000000016E-2},{"$f":"VAS!E2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!E4)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!E7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!E8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!E10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!E11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!E13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!E14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!E16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!E17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!E19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!E20)","v":-1.1000000000000038E-2},{"$f":"VAS!F2*(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,F4,1))*(IF('INDEX CALCULATOR'!$E$6=2,F7,1))*(IF('INDEX CALCULATOR'!$E$6=3,F8,1))*(IF('INDEX CALCULATOR'!$E$8=2,F10,1))*(IF('INDEX CALCULATOR'!$E$8=3,F11,1))*(IF('INDEX CALCULATOR'!$E$10=2,F13,1))*(IF('INDEX CALCULATOR'!$E$10=3,F14,1))*(IF('INDEX CALCULATOR'!$E$12=2,F16,1))*(IF('INDEX CALCULATOR'!$E$12=3,F17,1))*(IF('INDEX CALCULATOR'!$E$14=2,F19,1))*(IF('INDEX CALCULATOR'!$E$14=3,F20,1))","v":2.0699559336655401E-2},{"$f":"VAS!G2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!G4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*VAS!G5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!G7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!G8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!G10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!G11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!G13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!G14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!G16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!G17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!G19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!G20)","v":-8.4799999999999959E-2},{"$f":"VAS!H2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!H4)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!H7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!H8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!H10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!H11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!H13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!H14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!H16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!H17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!H19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!H20)","v":-0.24199999999999997},{"$f":"VAS!I2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!I4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*VAS!I5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!I7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!I8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!I10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!I11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!I13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!I14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!I16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!I17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!I19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!I20)","v":-7.5700000000000031E-2},{"$f":"VAS!J2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*VAS!J4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*VAS!J5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*VAS!J7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*VAS!J8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*VAS!J10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*VAS!J11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*VAS!J13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*VAS!J14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*VAS!J16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*VAS!J17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*VAS!J19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*VAS!J20)","v":-7.2999999999999982E-2},"Not available","Not available","Not available","Not available"]

{"sheet":"TTO","index":2,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["TTO value sets","Denmark","Germany","Japan","Netherlands","Spain","UK","USA","Zimbabwe","Belgium","Finland","New Zealand","Slovenia","Europe"]
["Full health (11111)",1,1,1,1,1,1,1,1]
[]
["At least one 2 or 3 (constant)",-0.114,-1E-3,-0.152,-7.0999999999999994E-2,-2.4E-2,-8.1000000000000003E-2,"-",-0.1]
["At least one 3 (N3)","-",-0.32300000000000001,"-",-0.23400000000000001,-0.29099999999999998,-0.26900000000000002,"-","-"]
[]
["Mobility = 2",-5.2999999999999999E-2,-9.9000000000000005E-2,-7.4999999999999997E-2,-3.5999999999999997E-2,-0.106,-6.9000000000000006E-2,-0.14601600000000001,-5.6000000000000001E-2]
["Mobility = 3",-0.41099999999999998,-0.32900000000000001,-0.41799999999999998,-0.161,-0.43,-0.314,-0.55768499999999999,-0.20399999999999999]
[]
["Self care = 2",-6.3E-2,-8.6999999999999994E-2,-5.3999999999999999E-2,-8.2000000000000003E-2,-0.13400000000000001,-0.104,-0.17534250000000001,-9.1999999999999998E-2]
["Self care = 3",-0.192,-0.17399999999999999,-0.10199999999999999,-0.152,-0.309,-0.214,-0.47118959999999999,-0.23100000000000001]
[]
["Usual activities = 2",-4.8000000000000001E-2,"-",-4.3999999999999997E-2,-3.2000000000000001E-2,-7.0999999999999994E-2,-3.5999999999999997E-2,-0.13972950000000001,-4.2999999999999997E-2]
["Usual activities = 3",-0.14399999999999999,"-",-0.13300000000000001,-5.7000000000000002E-2,-0.19500000000000001,-9.4E-2,-0.37425940000000002,-0.13500000000000001]
[]
["Pain/discomfort = 2",-6.2E-2,-0.112,-0.08,-8.5999999999999993E-2,-8.8999999999999996E-2,-0.123,-0.17289070000000001,-6.7000000000000004E-2]
["Pain/discomfort = 3",-0.39600000000000002,-0.315,-0.19400000000000001,-0.32900000000000001,-0.26100000000000001,-0.38600000000000001,-0.5371011,-0.30199999999999999]
[]
["Anxiety/depression = 2",-6.8000000000000005E-2,"-",-6.3E-2,-0.124,-6.2E-2,-7.0999999999999994E-2,-0.156223,-4.5999999999999999E-2]
["Anxiety/depression = 3",-0.36699999999999999,-6.5000000000000002E-2,-0.112,-0.32500000000000001,-0.14399999999999999,-0.23599999999999999,-0.45018760000000002,-0.17299999999999999]
[]
["D1",null,null,null,null,null,null,0.13959489999999999]
["I2-square",null,null,null,null,null,null,-1.06868E-2]
["I3",null,null,null,null,null,null,0.1215579]
["I3-square",null,null,null,null,null,null,1.47963E-2]
[]
[null,{"$f":"TTO!B2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*TTO!B4)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!B7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!B8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!B10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!B11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*TTO!B13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*TTO!B14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!B16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!B17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*TTO!B19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!B20)","v":-0.624},{"$f":"TTO!C2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*TTO!C4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*TTO!C5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!C7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!C8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!C10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!C11)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!C16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!C17)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!C20)","v":-0.20700000000000007},{"$f":"TTO!D2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*TTO!D4)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!D7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!D8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!D10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!D11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*TTO!D13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*TTO!D14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!D16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!D17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*TTO!D19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!D20)","v":-0.111},{"$f":"TTO!E2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*TTO!E4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*TTO!E5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!E7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!E8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!E10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!E11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*TTO!E13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*TTO!E14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!E16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!E17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*TTO!E19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!E20)","v":-0.32900000000000001},{"$f":"TTO!F2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*TTO!F4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*TTO!F5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!F7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!F8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!F10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!F11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*TTO!F13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*TTO!F14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!F16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!F17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*TTO!F19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!F20)","v":-0.65400000000000003},{"$f":"TTO!G2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*TTO!G4)+(IF('INDEX CALCULATOR'!$E$6=3,1,IF('INDEX CALCULATOR'!$E$8=3,1,IF('INDEX CALCULATOR'!$E$10=3,1,IF('INDEX CALCULATOR'!$E$12=3,1,IF('INDEX CALCULATOR'!$E$14=3,1,0)))))*TTO!G5)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!G7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!G8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!G10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!G11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*TTO!G13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*TTO!G14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!G16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!G17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*TTO!G19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!G20)","v":-0.59399999999999997},{"$f":"TTO!H2+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!H7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!H8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!H10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!H11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*TTO!H13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*TTO!H14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!H16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!H17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*TTO!H19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!H20)+G29*H22+G45*H23+G36*H24+G43*H25","v":-0.10907070000000005},{"$f":"TTO!I2+(IF('INDEX CALCULATOR'!$E$6+'INDEX CALCULATOR'!$E$8+'INDEX CALCULATOR'!$E$10+'INDEX CALCULATOR'!$E$12+'INDEX CALCULATOR'!$E$14>5,1,0)*TTO!I4)+(IF('INDEX CALCULATOR'!$E$6=2,1,0)*TTO!I7)+(IF('INDEX CALCULATOR'!$E$6=3,1,0)*TTO!I8)+(IF('INDEX CALCULATOR'!$E$8=2,1,0)*TTO!I10)+(IF('INDEX CALCULATOR'!$E$8=3,1,0)*TTO!I11)+(IF('INDEX CALCULATOR'!$E$10=2,1,0)*TTO!I13)+(IF('INDEX CALCULATOR'!$E$10=3,1,0)*TTO!I14)+(IF('INDEX CALCULATOR'!$E$12=2,1,0)*TTO!I16)+(IF('INDEX CALCULATOR'!$E$12=3,1,0)*TTO!I17)+(IF('INDEX CALCULATOR'!$E$14=2,1,0)*TTO!I19)+(IF('INDEX CALCULATOR'!$E$14=3,1,0)*TTO!I20)","v":-0.14499999999999991},"Not available","Not available","Not available","Not available","Not available"]
[]
[null,null,null,null,null,"D1 crieteria",{"$f":"IF(F30+F31+F32+F33+F34-1>0,F30+F31+F32+F33+F34-1,0)","v":4}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E6>1,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E8>1,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E10>1,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E12>1,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E14>1,1,0)","v":1}]
[]
[null,null,null,null,null,"I3 criteria",{"$f":"IF(F37+F38+F39+F40+F41-1>0,F37+F38+F39+F40+F41-1,0)","v":4}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E6=3,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E8=3,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E10=3,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E12=3,1,0)","v":1}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E14=3,1,0)","v":1}]
[]
[null,null,null,null,null,"I3 square",{"$f":"G36*G36","v":16}]
[]
[null,null,null,null,null,"I2 square",{"$f":"F51*F51","v":0}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E6=2,1,0)","v":0}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E8=2,1,0)","v":0}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E10=2,1,0)","v":0}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E12=2,1,0)","v":0}]
[null,null,null,null,null,{"$f":"IF('INDEX CALCULATOR'!E14=2,1,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(F46+F47+F48+F49+F50-1>0,F46+F47+F48+F49+F50-1,0)","v":0}]

{"sheet":"notes","index":3,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,0,24,4]]}
[]
["Europe","raw","resc mean dead","resc median dead"]
["Full health (11111)",97.66,1,1]
[]
["At least one 2 or 3 (constant)",-11.21,{"$f":"$B5/($B$3-10)","v":-0.12788044718229524},{"$f":"$B5/($B$3-2)","v":-0.11718586661091367}]
["At least one 3 (N3)",-20.059999999999999,{"$f":"$B6/($B$3-10)","v":-0.22883869495779147},{"$f":"$B6/($B$3-2)","v":-0.20970102446163494}]
[]
["Mobility = 2",-5.78,-6.5936573123431444E-2,-6.0422329082166007E-2]
["Mobility = 3",-16.03,-0.18286561715719829,-0.16757265314656075]
[]
["Self care = 2",-10.28,-0.11727127538215834,-0.10746393476897345]
["Self care = 3",-13.67,-0.15594341775039927,-0.14290194438636838]
[]
["Usual activities = 2",-2.31,-2.6351813826146476E-2,-2.4148024252561157E-2]
["Usual activities = 3",-7.54,-8.6014145562400182E-2,-7.882082375078403E-2]
[]
["Pain/discomfort = 2",-8.15,-9.2972849646360947E-2,-8.5197574743884605E-2]
["Pain/discomfort = 3",-14.35,-0.16370066164727357,-0.15001045369015262]
[]
["Anxiety/depression = 2",-7.81,-8.90942276979238E-2,-8.1643320091992475E-2]
["Anxiety/depression = 3",-11.31,-0.12902121834360028,-0.11823123562617605]
[]
[]
["Germany (1998)"]
["in the model when a dimension is at level 3, you have to multiply by both level 2 and level 3. The adjusted level 3 values have incorporated this."]
["dimension","level 1","level 2","level 3","adjusted level 3"]
["MO",1,0.94469999999999998,0.41570000000000001,{"$f":"C27*D27","v":0.39271179000000001}]
["SC",1,0.80800000000000005,0.58189999999999997,{"$f":"C28*D28","v":0.47017520000000002}]
["UA",1,0.88029999999999997,0.62909999999999999,{"$f":"C29*D29","v":0.55379672999999996}]
["PD",1,0.97450000000000003,0.4793,{"$f":"C30*D30","v":0.46707785000000002}]
["AD",1,0.81740000000000002,0.57279999999999998,{"$f":"C31*D31","v":0.46820671999999997}]

{"sheet":"Charts","index":4,"n_rows":94,"n_cols":10,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Figure 2: Value of selected EQ-5D health states based on TTO surveys"]
[]
[null,null,"Denmark","Germany","Japan","Netherlands","Spain","UK","USA","Zimbabwe"]
[null,11111,1,1,1,1,1,1,1,1]
[null,21111,0.83299999999999996,0.9,0.77300000000000002,0.89300000000000002,0.87,0.85,0.85398399999999997,0.84399999999999997]
[null,12111,0.82299999999999995,0.91200000000000003,0.79399999999999993,0.84700000000000009,0.84199999999999997,0.81499999999999995,0.82465750000000004,0.80800000000000005]
[null,11211,0.83799999999999997,0.999,0.80399999999999994,0.89700000000000002,0.90500000000000003,0.88300000000000001,0.86027049999999994,0.85699999999999998]
[null,11121,0.82400000000000007,0.88700000000000001,0.76800000000000002,0.84300000000000008,0.88700000000000001,0.79600000000000004,0.82710930000000005,0.83299999999999996]
[null,11112,0.81800000000000006,0.999,0.78500000000000003,0.80500000000000005,0.91399999999999992,0.84800000000000009,0.843777,0.85399999999999998]
[null,11122,0.75600000000000001,0.88700000000000001,0.70499999999999996,0.71900000000000008,0.82499999999999996,0.72499999999999998,0.79979440000000002,0.78699999999999992]
[null,21232,0.3209999999999999,0.26199999999999996,0.47199999999999992,0.17399999999999999,0.185,8.7999999999999926E-2,0.39696790000000004,0.45299999999999996]
[null,32211,0.36400000000000005,0.26,0.33200000000000002,0.42,5.0000000000000058E-2,0.19600000000000004,0.39574599999999999,0.56100000000000005]
[null,22323,0.19700000000000006,0.313,0.39400000000000002,0.10900000000000004,1.7000000000000071E-2,2.4000000000000021E-2,0.33329039999999982,0.37700000000000006]
[null,22233,-4.1000000000000036E-2,0.11,0.36899999999999994,-0.10899999999999999,-3.0999999999999944E-2,-0.18099999999999999,0.20360989999999982,0.23399999999999999]
[null,33321,7.7000000000000041E-2,6.0999999999999929E-2,0.115,0.23900000000000002,-0.33799999999999997,-9.5000000000000001E-2,0.14506099999999994,0.26300000000000007]
[null,33333,-0.624,-0.20700000000000007,-0.111,-0.32900000000000001,-0.65400000000000003,-0.59399999999999997,-0.10907070000000005,-0.14499999999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 3: Value of selected EQ-5D health states based on VAS surveys"]
[]
[null,null,"Belgium","Denmark","Finland","New Zealand","Slovenia","Spain","UK","Europe"]
[null,11111,1,1,1,1,1,1,1,1]
[null,21111,0.77400000000000002,0.64900000000000002,0.78399999999999992,0.72060000000000002,0.66600000000000004,0.7601,0.77400000000000002,0.80620000000000003]
[null,12111,0.76500000000000001,0.66300000000000003,0.74399999999999999,0.72450000000000003,0.77900000000000003,0.74860000000000004,0.752,0.75480000000000003]
[null,11211,0.81699999999999995,0.71100000000000008,0.79500000000000004,0.78230000000000011,0.81799999999999995,0.79469999999999996,0.81399999999999995,0.84570000000000001]
[null,11121,0.76400000000000001,0.69700000000000006,0.73099999999999998,0.71610000000000007,0.76100000000000001,0.79020000000000001,0.76100000000000001,0.77910000000000001]
[null,11112,0.745,0.68400000000000005,0.68199999999999994,0.70390000000000008,0.77900000000000003,0.79859999999999998,0.78200000000000003,0.78300000000000003]
[null,11122,0.66100000000000003,0.60600000000000009,0.57099999999999995,0.6241000000000001,0.66800000000000004,0.73899999999999999,0.69799999999999995,0.69]
[null,21232,0.21599999999999997,0.33799999999999997,0.42399999999999982,0.23889999999999997,0.29700000000000004,0.32269999999999999,0.29399999999999998,0.29820000000000002]
[null,32211,0.33,0.34700000000000003,0.46700000000000003,0.34379999999999999,0.313,0.30220000000000002,0.32399999999999995,0.31669999999999998]
[null,22323,8.299999999999999E-2,0.14900000000000002,0.24799999999999994,0.14169999999999999,0.16800000000000009,0.17480000000000001,0.17700000000000005,0.15210000000000001]
[null,22233,0.03,0.13500000000000001,0.28999999999999998,7.5499999999999956E-2,0.11100000000000004,0.17030000000000006,0.14000000000000001,0.14100000000000001]
[null,33321,0.1319999999999999,9.3000000000000041E-2,0.22699999999999998,0.17900000000000005,5.5E-2,8.6299999999999974E-2,0.13800000000000001,0.1255]
[null,33333,-0.15800000000000008,-0.16699999999999995,-1.1000000000000038E-2,-8.4799999999999959E-2,-0.24199999999999997,-7.5700000000000031E-2,-7.2999999999999982E-2,-7.4200000000000016E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 4: Value of selected EQ-5D health states based on TTO and VAS surveys"]
[]
[null,null,"Denmark-TTO","Denmark-VAS","Spain-TTO","Spain-VAS","UK-TTO","UK-VAS"]
[null,11111,1,1,1,1,1,1]
[null,21111,0.83299999999999996,0.64900000000000002,0.87,0.7601,0.85,0.77400000000000002]
[null,12111,0.82299999999999995,0.66300000000000003,0.84199999999999997,0.74860000000000004,0.81499999999999995,0.752]
[null,11211,0.83799999999999997,0.71100000000000008,0.90500000000000003,0.79469999999999996,0.88300000000000001,0.81399999999999995]
[null,11121,0.82400000000000007,0.69700000000000006,0.88700000000000001,0.79020000000000001,0.79600000000000004,0.76100000000000001]
[null,11112,0.81800000000000006,0.68400000000000005,0.91399999999999992,0.79859999999999998,0.84800000000000009,0.78200000000000003]
[null,11122,0.75600000000000001,0.60600000000000009,0.82499999999999996,0.73899999999999999,0.72499999999999998,0.69799999999999995]
[null,21232,0.3209999999999999,0.33799999999999997,0.185,0.32269999999999999,8.7999999999999926E-2,0.29399999999999998]
[null,32211,0.36400000000000005,0.34700000000000003,5.0000000000000058E-2,0.30220000000000002,0.19600000000000004,0.32399999999999995]
[null,22323,0.19700000000000006,0.14900000000000002,1.7000000000000071E-2,0.17480000000000001,2.4000000000000021E-2,0.17700000000000005]
[null,22233,-4.1000000000000036E-2,0.13500000000000001,-3.0999999999999944E-2,0.17030000000000006,-0.18099999999999999,0.14000000000000001]
[null,33321,7.7000000000000041E-2,9.3000000000000041E-2,-0.33799999999999997,8.6299999999999974E-2,-9.5000000000000001E-2,0.13800000000000001]
[null,33333,-0.624,-0.16699999999999995,-0.65400000000000003,-7.5700000000000031E-2,-0.59399999999999997,-7.2999999999999982E-2]