{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VAGUS_SR","VAGUS_CR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"VAGUS_SR","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,5,4,11]]}
["Question","Response","Val","Div",null,"Instructions: Enter responses into the gray response column. IMPORTANT!! For the equations to work properly, if the subject left the question unasnwered or is not applicable, leave cell blank, DO NOT enter a zero unless the subject answered zero (especially #3, #4 and #10)"]
[1,null,{"$f":"IF(B2=\"\",\"0\",B2)","v":"0"},{"$f":"IF(B2=\"\",\"0\",1)","v":"0"}]
[2,null,{"$f":"IF(B3=\"\",\"10\",B3)","v":"10"},{"$f":"IF(B3=\"\",\"0\",1)","v":"0"}]
[3,null,{"$f":"IF(B4=\"\",\"10\",B4)","v":"10"},"0"]
[4,null,{"$f":"IF(B5=\"\",\"0\",B5)","v":"0"},"0"]
[5,null,{"$f":"IF(B6=\"\",\"0\",B6)","v":"0"},"0"]
[6,null,{"$f":"IF(B7=\"\",\"0\",B7)","v":"0"},"0"]
[7,null,{"$f":"IF(B8=\"\",\"10\",B8)","v":"10"},"0"]
[8,null,{"$f":"IF(B9=\"\",\"10\",B9)","v":"10"},"0"]
[9,null,{"$f":"IF(B10=\"\",\"0\",B10)","v":"0"},"0"]
[10,null,{"$f":"IF(B11=\"\",\"0\",B11)","v":"0"},"0"]
[]
[null,"Awareness Category","Score","Div"]
[null,"Illness Awareness =",{"$f":"IF(SUM(D6+D8)=0,0,SUM((C6+(10-C8))/(D6+D8)))","v":0},{"$f":"IF(AND(B6=\"\",B8=\"\"),0,1)","v":0}]
[null,"Symptom Attribution=",{"$f":"IF(SUM(D2+D3+D4+D5)=0,0,SUM((C2+(10-C3)+(10-C4)+C5)/(D2+D3+D4+D5)))","v":0},{"$f":"IF(AND(B2=\"\",B3=\"\",B4=\"\",B5=\"\"),0,1)","v":0}]
[null,"Awareness of Need=",{"$f":"IF(SUM(D7+D9+D11)=0,0,SUM((C7+(10-C9)+C11)/(D7+D9+D11)))","v":0},{"$f":"IF(AND(B7=\"\",B9=\"\",B11=\"\"),0,1)","v":0}]
[null,"Awareness of Consequences=",{"$f":"SUM(C10)","v":0},{"$f":"IF(B10=\"\",0,1)","v":0}]
[null,"VAGUS-SR Average Score=",{"$f":"IF(D18=0,0,SUM(C14:C17)/D18)","v":0},{"$f":"SUM(D14:D17)","v":0}]

{"sheet":"VAGUS_CR","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[7,5,14,8]]}
["Question","Response","Val","Div"]
[1,null,{"$f":"SUM(B2)","v":0},{"$f":"IF(B2=\"\",\"0\",1)","v":"0"}]
[2,null,{"$f":"SUM(B3)","v":0},{"$f":"IF(B3=\"\",\"0\",1)","v":"0"}]
[3,null,0,{"$f":"IF(B4=\"\",\"0\",1)","v":"0"}]
[4,null,0,{"$f":"IF(B5=\"\",\"0\",1)","v":"0"}]
[5,null,0,{"$f":"IF(B6=\"\",\"0\",1)","v":"0"}]
[]
[null,"Awareness Catergory","Score","Div",null,"Instructions: Enter responses into the gray response column. IMPORTANT!! For the equations to work properly, if the subject left the question unasnwered or is not applicable, leave cell blank, DO NOT enter a zero unless the subject answered zero (especially #2)"]
[null,"Illness Awareness =",{"$f":"SUM(B2)","v":0},{"$f":"IF(B2=\"\",\"0\",1)","v":"0"}]
[null,"Symptom Attribution=",{"$f":"IF(SUM(D3+D4)=0,\"0\",SUM((B3+B4)/(D3+D4)))","v":"0"},{"$f":"IF(AND(B3=\"\",B4=\"\"),\"0\",1)","v":"0"}]
[null,"Awareness of Need=",{"$f":"IF(B5=\"\",\"0\",SUM(10-B5))","v":"0"},{"$f":"IF(B5=\"\",\"0\",1)","v":"0"}]
[null,"Awareness of Consequences=",{"$f":"SUM(B6)","v":0},{"$f":"IF(B6=\"\",\"0\",1)","v":"0"}]
[null,"VAGUS-CR Average Score=",{"$f":"IF(D13=0,\"0\",SUM(C9:C12)/D13)","v":"0"},{"$f":"SUM(D9:D12)","v":0}]