{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Master","Main  Database","Changeable Sheet","Display sheet template","New display sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Master","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,8,9,10]]}
[]
[null,"Surname",null,"Age"]
[null,"Firstname",null,"Gender"]
[null,"ID code (e.g NHS, Hospital Number",null,"Date goal set",null,null,null,null,null,null,"A lot more achieved = 2"]
[null,"Diagnosis",null,"Date goal achieved",null,null,null,null,null,null,"A little more achieved = 1"]
[null,null,null,null,null,null,null,null,null,null,"Achieved as expected = 0"]
[null,null,null,null,null,null,null,null,null,null,"Partially achieved = -1"]
[null,null,null,null,"1 = Important","1 = doubtful",null,null,"Some funtion = -1",null,"Unchanged = baseline score"]
[null,null,null,null,"2 =Very important","2 = possible",null,null,"No function = -2",null,"Worse = -2"]
[null,null,null,null,"3 = Extremely important","3 = probable",null,null,"SCORES"]
["Goals","Baseline description","Patient Goals","SMART Goals","Importance","Probability","Weight","WSq","Baseline","W x base","Achieved","W x Ach","Variance"]
[1,null,null,null,null,null,{"$f":"F12","v":0},{"$f":"G12*G12","v":0},null,{"$f":"I12*G12","v":0},null,{"$f":"K12*G12","v":0}]
[2,null,null,null,null,null,0,0,null,{"$f":"I13*G13","v":0},null,0]
[3,null,null,null,null,null,0,0,null,0,null,0]
[4,null,null,null,null,null,0,0,null,0,null,0]
[5,null,null,null,null,null,0,0,null,0,null,0]
[6,null,null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,null,"SumW",{"$f":"SUM(G12:G17)","v":0},0,null,{"$f":"SUM(J12:J17)","v":0},null,{"$f":"SUM(L12:L17)","v":0}]
[null,null,null,null,null,"Sum (Wsq)",null,{"$f":"H12+H13+H14+H15+H16+H17","v":0}]
[null,null,null,null,null,"Factor",{"$f":"(0.7*H19)+(0.3*H18)","v":0}]
[null,null,null,null,null,"Sqrtfactor",{"$f":"SQRT(G20)","v":0}]
[]
[null,null,null,null,"Baseline","Achieved","Change"]
[null,null,null,"GAS calculation",{"$f":"50+((10*J18)/G21)","v":{"$error":"#DIV/0!"}},{"$f":"50+((10*L18)/G21)","v":{"$error":"#DIV/0!"}},{"$f":"F24-E24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Main  Database","index":1,"n_rows":2,"n_cols":91,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Patient Surname","Patient Firstname","ID Number","Age","Gender","Diagnosis","Date goals set","Date goal achieved","Time from goal set to achieved","Baseline Description1","Patient Goal 1","SMART Goal 1","Importance1","Probability1","Weight1","Square1","Baseline1","WxBase1","Achieved1","WxAch1","Variance1","Baseline Description2","Patient Goal 2","SMART Goal 2","Importance","Probability","Weight2","Square2","Baseline2","WxBase2","Achieved2","WxAch2","Variance2","Baseline Description3","Patient Goal 3","SMART Goal 3","Importance3","Probability3","Weight3","Square3","Baseline3","WxBase3","Achieved3","WxAch3","Variance3","Baseline Description4","Patient Goal 4","SMART Goal 4","Importance4","Probability4","Weight4","Square4","Baseline4","WxBase4","Achieved4","WxAch4","Variance4","Baseline Description5","Patient Goal 5","SMART Goal 5","Importance5","Probability5","Weight5","Square5","Baseline5","WxBase5","Achieved5","WxAch5","Variance5","Baseline Description6","Patient Goal 6","SMART Goal 6","Importance6","Probability6","Weight6","Square6","Baseline6","WxBase6","Achieved6","WxAch6","Variance6","Sum wgt","Sqrsum wgt","SumwgtSq","Factor","SqrFactor","Sum W x Base","Sum W xAch","Baseline","Achieved","Change"]
[{"$f":"Master!$C$2","v":0},{"$f":"Master!$C$3","v":0},{"$f":"Master!$C$4","v":0},{"$f":"Master!$E$2","v":0},{"$f":"Master!$E$3","v":0},{"$f":"Master!$C$5","v":0},{"$f":"Master!$E$4","v":"00:00:00"},{"$f":"Master!$E$5","v":"00:00:00"},{"$f":"H2-G2","v":0},{"$f":"Master!$B$12","v":0},{"$f":"Master!$C$12","v":0},{"$f":"Master!$D$12","v":0},{"$f":"Master!$E$12","v":0},{"$f":"Master!$F$12","v":0},{"$f":"Master!$G$12","v":0},{"$f":"Master!$H$12","v":0},{"$f":"Master!$I$12","v":0},{"$f":"Master!$J$12","v":0},{"$f":"Master!$K$12","v":0},{"$f":"Master!$L$12","v":0},{"$f":"Master!$M$12","v":0},{"$f":"Master!$B$13","v":0},{"$f":"Master!$C$13","v":0},{"$f":"Master!$D$13","v":0},{"$f":"Master!$E$13","v":0},{"$f":"Master!$F$13","v":0},{"$f":"Master!$G$13","v":0},{"$f":"Master!$H$13","v":0},{"$f":"Master!$I$13","v":0},{"$f":"Master!$J$13","v":0},{"$f":"Master!$K$13","v":0},{"$f":"Master!$L$13","v":0},{"$f":"Master!$M$13","v":0},{"$f":"Master!$B$14","v":0},{"$f":"Master!$C$14","v":0},{"$f":"Master!$D$14","v":0},{"$f":"Master!$E$14","v":0},{"$f":"Master!$F$14","v":0},{"$f":"Master!$G$14","v":0},{"$f":"Master!$H$14","v":0},{"$f":"Master!$I$14","v":0},{"$f":"Master!$J$14","v":0},{"$f":"Master!$K$14","v":0},{"$f":"Master!$L$14","v":0},{"$f":"Master!$M$14","v":0},{"$f":"Master!$B$15","v":0},{"$f":"Master!$C$15","v":0},{"$f":"Master!$D$15","v":0},{"$f":"Master!$E$15","v":0},{"$f":"Master!$F$15","v":0},{"$f":"Master!$G$15","v":0},{"$f":"Master!$H$15","v":0},{"$f":"Master!$I$15","v":0},{"$f":"Master!$J$15","v":0},{"$f":"Master!$K$15","v":0},{"$f":"Master!$L$15","v":0},{"$f":"Master!$M$15","v":0},{"$f":"Master!$B$16","v":0},{"$f":"Master!$C$16","v":0},{"$f":"Master!$D$16","v":0},{"$f":"Master!$E$16","v":0},{"$f":"Master!$F$16","v":0},{"$f":"Master!$G$16","v":0},{"$f":"Master!$H$16","v":0},{"$f":"Master!$I$16","v":0},{"$f":"Master!$J$16","v":0},{"$f":"Master!$K$16","v":0},{"$f":"Master!$L$16","v":0},{"$f":"Master!$M$16","v":0},{"$f":"Master!$B$17","v":0},{"$f":"Master!$C$17","v":0},{"$f":"Master!$D$17","v":0},{"$f":"Master!$E$17","v":0},{"$f":"Master!$F$17","v":0},{"$f":"Master!$G$17","v":0},{"$f":"Master!$H$17","v":0},{"$f":"Master!$I$17","v":0},{"$f":"Master!$J$17","v":0},{"$f":"Master!$K$17","v":0},{"$f":"Master!$L$17","v":0},{"$f":"Master!$M$17","v":0},{"$f":"Master!$G$18","v":0},{"$f":"Master!$H$18","v":0},{"$f":"Master!$H$19","v":0},{"$f":"Master!$G$20","v":0},{"$f":"Master!$G$21","v":0},{"$f":"Master!$J$18","v":0},{"$f":"Master!$L$18","v":0},{"$f":"Master!$E$24","v":{"$error":"#DIV/0!"}},{"$f":"Master!$F$24","v":{"$error":"#DIV/0!"}},{"$f":"Master!$G$24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Changeable Sheet","index":2,"n_rows":2,"n_cols":91,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Patient Surname","Patient Firstname","ID Number","Age","Gender","Diagnosis","Date goals set","Date goal achieved","Time from goal set to achieved","Baseline Description1","Patient Goal 1","SMART Goal 1","Importance1","Probability1","Weight1","Square1","Baseline1","WxBase1","Achieved1","WxAch1","Variance1","Baseline Description2","Patient Goal 2","SMART Goal 2","Importance","Probability","Weight2","Square2","Baseline2","WxBase2","Achieved2","WxAch2","Variance2","Baseline Description3","Patient Goal 3","SMART Goal 3","Importance3","Probability3","Weight3","Square3","Baseline3","WxBase3","Achieved3","WxAch3","Variance3","Baseline Description4","Patient Goal 4","SMART Goal 4","Importance4","Probability4","Weight4","Square4","Baseline4","WxBase4","Achieved4","WxAch4","Variance4","Baseline Description5","Patient Goal 5","SMART Goal 5","Importance5","Probability5","Weight5","Square5","Baseline5","WxBase5","Achieved5","WxAch5","Variance5","Baseline Description6","Patient Goal 6","SMART Goal 6","Importance6","Probability6","Weight6","Square6","Baseline6","WxBase6","Achieved6","WxAch6","Variance6","Sum wgt","Sqrsum wgt","SumwgtSq","Factor","SqrFactor","Sum W x Base","Sum W xAch","Baseline","Achieved","Change"]
[{"$f":"Master!$C$2","v":0},{"$f":"Master!$C$3","v":0},{"$f":"Master!$C$4","v":0},{"$f":"Master!$E$2","v":0},{"$f":"Master!$E$3","v":0},{"$f":"Master!$C$5","v":0},{"$f":"Master!$E$4","v":"00:00:00"},{"$f":"Master!$E$5","v":"00:00:00"},{"$f":"H2-G2","v":0},{"$f":"Master!$B$12","v":0},{"$f":"Master!$C$12","v":0},{"$f":"Master!$D$12","v":0},{"$f":"Master!$E$12","v":0},{"$f":"Master!$F$12","v":0},{"$f":"Master!$G$12","v":0},{"$f":"Master!$H$12","v":0},{"$f":"Master!$I$12","v":0},{"$f":"Master!$J$12","v":0},{"$f":"Master!$K$12","v":0},{"$f":"Master!$L$12","v":0},{"$f":"Master!$M$12","v":0},{"$f":"Master!$B$13","v":0},{"$f":"Master!$C$13","v":0},{"$f":"Master!$D$13","v":0},{"$f":"Master!$E$13","v":0},{"$f":"Master!$F$13","v":0},{"$f":"Master!$G$13","v":0},{"$f":"Master!$H$13","v":0},{"$f":"Master!$I$13","v":0},{"$f":"Master!$J$13","v":0},{"$f":"Master!$K$13","v":0},{"$f":"Master!$L$13","v":0},{"$f":"Master!$M$13","v":0},{"$f":"Master!$B$14","v":0},{"$f":"Master!$C$14","v":0},{"$f":"Master!$D$14","v":0},{"$f":"Master!$E$14","v":0},{"$f":"Master!$F$14","v":0},{"$f":"Master!$G$14","v":0},{"$f":"Master!$H$14","v":0},{"$f":"Master!$I$14","v":0},{"$f":"Master!$J$14","v":0},{"$f":"Master!$K$14","v":0},{"$f":"Master!$L$14","v":0},{"$f":"Master!$M$14","v":0},{"$f":"Master!$B$15","v":0},{"$f":"Master!$C$15","v":0},{"$f":"Master!$D$15","v":0},{"$f":"Master!$E$15","v":0},{"$f":"Master!$F$15","v":0},{"$f":"Master!$G$15","v":0},{"$f":"Master!$H$15","v":0},{"$f":"Master!$I$15","v":0},{"$f":"Master!$J$15","v":0},{"$f":"Master!$K$15","v":0},{"$f":"Master!$L$15","v":0},{"$f":"Master!$M$15","v":0},{"$f":"Master!$B$16","v":0},{"$f":"Master!$C$16","v":0},{"$f":"Master!$D$16","v":0},{"$f":"Master!$E$16","v":0},{"$f":"Master!$F$16","v":0},{"$f":"Master!$G$16","v":0},{"$f":"Master!$H$16","v":0},{"$f":"Master!$I$16","v":0},{"$f":"Master!$J$16","v":0},{"$f":"Master!$K$16","v":0},{"$f":"Master!$L$16","v":0},{"$f":"Master!$M$16","v":0},{"$f":"Master!$B$17","v":0},{"$f":"Master!$C$17","v":0},{"$f":"Master!$D$17","v":0},{"$f":"Master!$E$17","v":0},{"$f":"Master!$F$17","v":0},{"$f":"Master!$G$17","v":0},{"$f":"Master!$H$17","v":0},{"$f":"Master!$I$17","v":0},{"$f":"Master!$J$17","v":0},{"$f":"Master!$K$17","v":0},{"$f":"Master!$L$17","v":0},{"$f":"Master!$M$17","v":0},{"$f":"Master!$G$18","v":0},{"$f":"Master!$H$18","v":0},{"$f":"Master!$H$19","v":0},{"$f":"Master!$G$20","v":0},{"$f":"Master!$G$21","v":0},{"$f":"Master!$J$18","v":0},{"$f":"Master!$L$18","v":0},{"$f":"Master!$E$24","v":{"$error":"#DIV/0!"}},{"$f":"Master!$F$24","v":{"$error":"#DIV/0!"}},{"$f":"Master!$G$24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Display sheet template","index":3,"n_rows":1,"n_cols":91,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Patient Surname","Patient Firstname","RRU number","Age","Gender","Diagnosis","Date goals set","Date goal achieved","Time from goal set to achieved","Category","Patient Goal 1","SMART Goal 1","Importance1","Probability1","Weight1","Square1","Baseline1","WxBase1","Achieved1","WxAch1","Variance1","Category2","Patient Goal 2","SMART Goal 2","Importance","Probability","Weight2","Square2","Baseline2","WxBase2","Achieved2","WxAch2","Variance2","Category3","Patient Goal 3","SMART Goal 3","Importance3","Probability3","Weight3","Square3","Baseline3","WxBase3","Achieved3","WxAch3","Variance3","Category4","Patient Goal 4","SMART Goal 4","Importance4","Probability4","Weight4","Square4","Baseline4","WxBase4","Achieved4","WxAch4","Variance4","Category5","Patient Goal 5","SMART Goal 5","Importance5","Probability5","Weight5","Square5","Baseline5","WxBase5","Achieved5","WxAch5","Variance5","Category6","Patient Goal 6","SMART Goal 6","Importance6","Probability6","Weight6","Square6","Baseline6","WxBase6","Achieved6","WxAch6","Variance6","Sum wgt","Sqrsum wgt","SumwgtSq","Factor","SqrFactor","Sum W x Base","Sum W xAch","Baseline","Achieved","Change"]

{"sheet":"New display sheet","index":4,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":true,"merged":[[9,8,9,10]]}
[]
[null,"Surname",{"$f":"'Display sheet template'!A2","v":0}]
[null,"Firstname",{"$f":"'Display sheet template'!B2","v":0}]
[null,"RRU Code",{"$f":"'Display sheet template'!C2","v":0}]
[null,"Age",{"$f":"'Display sheet template'!D2","v":0}]
[null,"Gender",{"$f":"'Display sheet template'!E2","v":0},null,null,"1 = doubtful"]
[null,"Diagnosis",{"$f":"'Display sheet template'!F2","v":0},null,null,"2 = possible"]
[null,"Date goal set",{"$f":"'Display sheet template'!G2","v":"00:00:00"},null,null,"3 = probable"]
[null,"Date goal achieved",{"$f":"'Display sheet template'!H2","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"SCORES"]
["Goals","Category","Patient Goals","SMART Goals","Importance","Probability","Weight","WSq","Baseline","W x base","Achieved","W x Ach","Variance"]
[1,{"$f":"'Display sheet template'!J2","v":0},{"$f":"'Display sheet template'!K2","v":0},{"$f":"'Display sheet template'!L2","v":0},{"$f":"'Display sheet template'!M2","v":0},{"$f":"'Display sheet template'!N2","v":0},{"$f":"F12","v":0},{"$f":"G12*G12","v":0},{"$f":"'Display sheet template'!Q2","v":0},{"$f":"I12*G12","v":0},{"$f":"'Display sheet template'!S2","v":0},{"$f":"K12*G12","v":0},{"$f":"'Display sheet template'!U2","v":0}]
[2,{"$f":"'Display sheet template'!V2","v":0},{"$f":"'Display sheet template'!W2","v":0},{"$f":"'Display sheet template'!X2","v":0},{"$f":"'Display sheet template'!Y2","v":0},{"$f":"'Display sheet template'!Z2","v":0},0,0,{"$f":"'Display sheet template'!AC2","v":0},0,{"$f":"'Display sheet template'!AE2","v":0},0,{"$f":"'Display sheet template'!AG2","v":0}]
[3,{"$f":"'Display sheet template'!AH2","v":0},{"$f":"'Display sheet template'!AI2","v":0},{"$f":"'Display sheet template'!AJ2","v":0},{"$f":"'Display sheet template'!AK2","v":0},{"$f":"'Display sheet template'!AL2","v":0},0,0,{"$f":"'Display sheet template'!AO2","v":0},0,{"$f":"'Display sheet template'!AQ2","v":0},0,{"$f":"'Display sheet template'!AS2","v":0}]
[4,{"$f":"'Display sheet template'!AT2","v":0},{"$f":"'Display sheet template'!AU2","v":0},{"$f":"'Display sheet template'!AV2","v":0},{"$f":"'Display sheet template'!AW2","v":0},{"$f":"'Display sheet template'!AX2","v":0},0,0,{"$f":"'Display sheet template'!BA2","v":0},0,{"$f":"'Display sheet template'!BC2","v":0},0,{"$f":"'Display sheet template'!BE2","v":0}]
[5,{"$f":"'Display sheet template'!BF2","v":0},{"$f":"'Display sheet template'!BG2","v":0},{"$f":"'Display sheet template'!BH2","v":0},{"$f":"'Display sheet template'!BI2","v":0},{"$f":"'Display sheet template'!BJ2","v":0},0,0,{"$f":"'Display sheet template'!BM2","v":0},0,{"$f":"'Display sheet template'!BO2","v":0},0,{"$f":"'Display sheet template'!BQ2","v":0}]
[6,{"$f":"'Display sheet template'!BR2","v":0},{"$f":"'Display sheet template'!BS2","v":0},{"$f":"'Display sheet template'!BT2","v":0},{"$f":"'Display sheet template'!BU2","v":0},{"$f":"'Display sheet template'!BV2","v":0},0,0,{"$f":"'Display sheet template'!BY2","v":0},0,{"$f":"'Display sheet template'!CA2","v":0},0,{"$f":"'Display sheet template'!CC2","v":0}]
[null,null,null,null,null,"SumW",{"$f":"SUM(G12:G17)","v":0},0,null,{"$f":"SUM(J12:J17)","v":0},null,{"$f":"SUM(L12:L17)","v":0}]
[null,null,null,null,null,"Sum (Wsq)",null,{"$f":"H12+H13+H14+H15+H16+H17","v":0}]
[null,null,null,null,null,"Factor",{"$f":"(0.7*H19)+(0.3*H18)","v":0}]
[null,null,null,null,null,"Sqrtfactor",{"$f":"SQRT(G20)","v":0}]
[]
[null,null,null,null,"Baseline","Achieved","Change"]
[null,null,null,"GAS calculation",{"$f":"50+((10*J18)/G21)","v":{"$error":"#DIV/0!"}},{"$f":"50+((10*L18)/G21)","v":{"$error":"#DIV/0!"}},{"$f":"F24-E24","v":{"$error":"#DIV/0!"}}]