{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Results","chart-data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Data","index":0,"n_rows":508,"n_cols":5,"rows_kept":508,"cut":false,"hidden":false,"merged":[]}
["The \"Calculate results\" button must be clicked in order for the chart to be updated."]
[]
[]
[]
[null,"Data entry"]
[]
[null,"Patient ID"]
[null,"Pretreatment score"]
[null,"Post treatment score"]
[null,"Absolute change score",{"$f":"IF(C8=\"\",\"\",IF(C19=\"Decrease\",C8-C9,C9-C8))","v":""}]
[null,"Reliable change?",{"$f":"IF(C8=\"\",\"\",IF(C10>Results!$C$17,\"Improve\",IF(C10<-Results!$C$17,\"Deteriorate\",\"No Change\")))","v":""}]
[null,"CSC?",{"$f":"'chart-data'!$H$18","v":{"$error":"#DIV/0!"}}]
[]
[null,"Measure"]
[null,"Name of measure"]
[null,"Range of scores permissible"]
[null,"Lowest"]
[null,"Highest"]
[null,"Direction of clinical gain","Increase"]
[]
[]
[]
[null,"Reliability of the measure"]
[]
[null,"Reference data for CSC"]
[null,"Mean of clinical norms"]
[null,"SD for clinical norms"]
[null,"Mean of comparison norms"]
[null,"SD for comparison norms"]
[]
[null,"CSC criteria"]
[null,"Criterion a",{"$f":"IF(C19=\"Decrease\",C26-1.96*C27,C26+1.96*C27)","v":0}]
[null,"Criterion b",{"$f":"IF(C19=\"Decrease\",C28+1.96*C29,C28-1.96*C29)","v":0}]
[null,"Criterion c",{"$f":"(C26*C29+C28*C27)/(C27+C29)","v":{"$error":"#DIV/0!"}}]
[null,"External criterion"]
[]
[null,"Which cut score are you using?","Criterion c"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(B3=\"\",\"\",IF(D507>Results!$C$17,\"Improve\",IF(D507<-Results!$C$17,\"Deteriorate\",\"Nochange\")))","v":""}]
[null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(D508>Results!$C$17,\"Improve\",IF(D508<-Results!$C$17,\"Deteriorate\",\"Nochange\")))","v":{"$error":"#REF!"}}]

{"sheet":"Results","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Results for measure",{"$f":"Data!C15","v":0}]
[null,"and "]
[null,"CSC criterion",{"$f":"Data!C37","v":"Criterion c"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"    "]
[]
[]
[null,"Reliable Change Index"]
[null,"Standard Error of Measurement",{"$f":"Data!C27*SQRT(1-Data!C23)","v":0}]
[null,"RCI value",{"$f":"1.96*SQRT(2*C16*C16)","v":0}]
[]
[]
[]
[]
[null,null," "]

{"sheet":"chart-data","index":2,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["The starting point on the graph",{"$f":"Data!C17","v":0},null,{"$f":"Data!C17-Data!C17","v":0},null,"reliable change","no change","deteriorate",null,"crit a","crit b","crit c","external crit"]
["What is the maximum score on your measure?",{"$f":"Data!C18","v":0},null,{"$f":"Data!C18","v":0},null,{"$f":"IF(Data!C11=\"Improve\",Data!C9,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!C11=\"No Change\",Data!C9,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!$C11=\"Deteriorate\",Data!$C9,NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(Data!$C37=\"Criterion a\",Data!C32,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!$C37=\"Criterion b\",Data!C33,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!$C37=\"Criterion c\",Data!C34,NA())","v":{"$error":"#DIV/0!"}},{"$f":"IF(Data!$C37=\"External Criterion\",Data!C35,NA())","v":{"$error":"#N/A"}}]
["What is the Standard deviation for the Clinical population in the measure?",{"$f":"Data!C27","v":0}]
["Reliability for measure or subscale",{"$f":"Data!C23","v":0}]
["What was the client's score on the measure on initial assessment?",{"$f":"'chart-data'!B20","v":0}]
["What was the client's score on the measure on final assessment?",{"$f":"'chart-data'!B21","v":0}]
["Standard Error of Measurement (SeM)",{"$f":"Results!C16","v":0}]
["Standard Error of Difference (SeDiff)",{"$f":"SQRT(2*((B7*B7)))","v":0}]
["Reliable Change Index (RCI) ",{"$f":"Results!C17","v":0}]
["Upper RCI Confidence limit ",{"$f":"1.96*B8","v":0},null,null,null,null,null,null,"increase","decrease",null,"increase","decrease"]
["Lower RCI confidence limit",{"$f":"-B10","v":0},null,null,null,null,null,"A",{"$f":"IF(Data!$C$19=\"increase\",IF(Data!$C$9>Data!$C$32,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":false},{"$f":"IF(Data!$C$19=\"Decrease\",IF(Data!$C$9<Data!$C$32,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":false},"Criterion a",{"$f":"IF(I11=\"CSC Met\",I11,\"CSC Not Met\")","v":"CSC Not Met"},"CSC Not Met"]
["Upper RCI for plotting tramline display",{"$f":"SUM(B2,B10)","v":0},null,null,null,null,null,"B",{"$f":"IF(Data!$C$19=\"increase\",IF(Data!$C$9>Data!$C$33,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":false},{"$f":"IF(Data!$C$19=\"Decrease\",IF(Data!$C$9<Data!$C$33,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":false},"Criterion b","CSC Not Met","CSC Not Met"]
["Lower RCI for plotting tramline display",{"$f":"SUM(B2,B11)","v":0},null,null,null,null,null,"C",{"$f":"IF(Data!$C$19=\"increase\",IF(Data!$C$9>Data!$C$34,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":{"$error":"#DIV/0!"}},{"$f":"IF(Data!$C$19=\"Decrease\",IF(Data!$C$9<Data!$C$34,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":false},"Criterion c",{"$error":"#DIV/0!"},"CSC Not Met"]
["Criterion ''a' for clinical significance",{"$f":"Data!C32","v":0},null,null,null,null,null,"E",{"$f":"IF(Data!$C$19=\"increase\",IF(Data!$C$9>Data!$C$35,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":false},{"$f":"IF(Data!$C$19=\"Decrease\",IF(Data!$C$9<Data!$C$35,IF(Data!$C$11=\"Improve\",\"CSC Met\",\"CSC Not Met\")))","v":false},"external criterion","CSC Not Met","CSC Not Met"]
["Criterion 'b' for clinical significance",{"$f":"Data!C33","v":0}]
["Criterion 'c' for clinical significance",{"$f":"Data!C34","v":{"$error":"#DIV/0!"}}]
["External criterion",{"$f":"Data!C35","v":0},null,null,null,null,null,"vlookup for inc and dec",null,"vlookup for inc",null,"vlookup for dec"]
["The starting point for the lines of clinical significance",{"$f":"B1-2","v":-2},null,null,null,null,null,{"$f":"IF(Data!$C$19=\"Increase\",J18,L18)","v":{"$error":"#DIV/0!"}},null,{"$f":"VLOOKUP(Data!$C$37,K10:M14,2,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"VLOOKUP(Data!$C$37,K10:M14,3,0)","v":"CSC Not Met"}]
["Chart title",{"$f":"\"Plot for \" &Data!$C15 &\" using \" &Data!$C37","v":"Plot for  using Criterion c"}]
["Client Score Pre",{"$f":"Data!C8","v":0}]
["Client Score Post",{"$f":"Data!C9","v":0}]