{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Information","WAIS-IV","Shares Abilities","GF-GC","Ways to Sort","Composite Graph","Subtest Graph","Order of Admin","Cult. & Linq."],"not_rendered":{"charts":6,"images":0,"macros":0,"external_links":3,"defined_names":52,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Composite Graph","index":5,"reason":"not_a_worksheet"},{"sheet":"Subtest Graph","index":6,"reason":"not_a_worksheet"},{"sheet":"Order of Admin","index":7,"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":"1904"}

{"sheet":"Information","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["These template sheets come with some scores already entered into cells."]
[]
["These scores act as placeholders and demonstrate what scores are necessary. The only sheets that require any user input is the WAIS-IV sheet."]
[]
["All cells, except those requiring entry, are protected.  Use the TAB key to move from input cell to input cell."]
[]
["****Be sure to delete any scores that do not pertain to your particular case.****"]
[]
["We (Ron Dumont and John Willis) and The Psychological Corporation, take no responsibility for any errors made while using these templates."]
[]
["There may be some differences between some of the templates reporting and data in the WAIS-IV Manuals."]
[]
["The Percentiles reported here are simple SS to Percentile lookups.  They are based upon the normal curve distribution."]
[]
["The Composite and FSIQ ranges are based upon a formula (SEe)."]
[]
["Critical Values for subtest differences are approximations - because there are so many subtest combinations available, the template uses the rounded average of all possible critical values."]
[]
["Gf-Gc configurations were adapted from Appendix A, pp. 445 – 453, The Intelligence Test Desk Reference (ITDR): Gf-Gc Cross-Battery Assessment (McGrew & Flanagan, 1998) and Table 8.3, p. 312, The Wechsler Intelligence Scales and Gf-Gc Theory (Flanagan, McGrew & Ortiz, 2000)"]

{"sheet":"WAIS-IV","index":1,"n_rows":434,"n_cols":124,"rows_kept":434,"cut":false,"hidden":false,"merged":[[244,15,245,16],[29,1,36,2],[93,12,93,15],[38,1,38,16],[52,1,52,16],[63,1,63,16],[91,12,92,15],[92,3,92,7],[92,8,92,9],[106,3,106,15],[77,3,77,7],[77,10,77,11],[80,12,81,15],[81,3,81,7],[81,10,81,11],[81,8,81,9],[77,8,77,9],[77,12,77,15],[65,11,65,15],[73,1,73,16],[75,12,76,15],[76,3,76,7],[76,10,76,11],[76,8,76,9],[0,0,0,17],[1,0,1,17],[2,0,2,17],[34,3,34,5],[35,3,35,5],[42,13,43,16],[7,13,10,17],[59,3,60,15],[66,2,66,3],[66,5,66,10],[56,5,56,6],[56,7,56,8],[66,11,66,15],[56,9,56,10],[56,11,56,15],[15,13,16,17],[17,13,18,17],[33,3,33,5],[55,9,55,10],[36,3,36,5],[55,5,55,6],[55,7,55,8],[54,11,55,15],[109,1,109,16],[102,8,102,9],[82,3,82,7],[65,2,65,3],[167,1,167,16],[169,5,169,6],[169,7,169,9],[168,13,169,14],[69,3,70,15],[54,5,54,10],[4,7,4,8],[5,7,5,8],[4,13,4,14],[11,13,12,17],[37,0,37,17],[11,1,25,2],[24,13,25,17],[22,13,23,17],[13,13,14,17],[20,13,21,17],[82,10,82,11],[82,8,82,9],[99,1,99,16],[82,12,82,15],[92,10,92,11],[103,3,103,7],[103,10,103,11],[103,8,103,9],[103,12,103,15],[101,12,102,15],[102,3,102,7],[102,10,102,11],[174,13,174,14],[174,15,174,16],[165,1,165,16],[85,3,86,15],[172,7,172,9],[93,3,93,7],[93,8,93,9],[93,10,93,11],[96,3,96,15],[89,1,89,16],[174,7,174,10],[127,1,129,2],[131,1,133,2],[114,7,114,11],[114,13,114,16],[168,15,169,16],[168,3,168,10],[171,13,171,14],[171,15,171,16],[135,1,135,16],[116,1,120,2],[122,1,126,2],[171,7,171,10],[155,1,155,16],[190,7,190,9],[194,7,194,10],[201,7,201,10],[175,7,175,9],[202,7,202,9],[191,7,191,9],[188,7,188,9],[195,7,195,9],[199,7,199,9],[188,13,188,14],[188,15,188,16],[177,13,177,14],[177,15,177,16],[180,7,180,9],[177,7,177,9],[183,7,183,9],[179,7,179,10],[183,13,183,14],[183,15,183,16],[185,13,185,14],[185,15,185,16],[179,13,179,14],[179,15,179,16],[184,7,184,9],[185,7,185,9],[186,7,186,9],[192,13,192,14],[192,15,192,16],[201,13,201,14],[201,15,201,16],[194,13,194,14],[194,15,194,16],[199,13,199,14],[199,15,199,16],[190,13,190,14],[190,15,190,16],[207,7,207,9],[208,7,208,9],[212,7,212,9],[212,13,212,14],[212,15,212,16],[214,3,216,16],[207,13,207,14],[207,15,207,16],[204,13,204,14],[204,15,204,16],[204,7,204,9],[232,15,234,16],[230,3,230,5],[221,7,222,16],[210,15,210,16],[210,13,210,14],[240,15,242,16],[231,3,231,5],[231,8,231,13],[235,15,236,16],[238,3,238,5],[230,7,230,14],[238,7,238,14],[226,1,226,16],[224,1,224,16]]}
["Wechsler Adult Intelligence Scale - Fourth Edition© The Psychological Corporation., 2008. All Rights Reserved"]
["Dumont-Willis WAIS-IV Interpretive Worksheet"]
["Use the TAB key to navigate to cells requiring input - Text highlighted in red"]
[]
[null,null,"Name: ","M C",null,null,"Date of Test:","2009-02-09",null,null,null,null,"Date Analyzed: ",{"$f":"NOW()","v":"2014-02-11T13:47:10.280"},null,null,null,null,null,null,{"$f":"YEAR(H5)","v":2009},{"$f":"MONTH(H5)","v":2},{"$f":"DAY(H5)","v":9},{"$f":"IF(Y6>Z5,U5-1,U5)","v":2008},{"$f":"IF(Y6>Z5,Z5+12,Z5)","v":14},{"$f":"IF(AA6>W5,V5-1,V5)","v":2},{"$f":"IF(AA6>W5,W5+30,W5)","v":9}]
[null,null,null,null,null,null,"Date of Birth:","1983-11-06",null,null,null,null,"Age:   ",{"$f":"AC7","v":"25 years, 3 months, 3 days"},null,null,null,null,null,null,null,null,null,{"$f":"YEAR(H6)","v":1983},{"$f":"MONTH(H6)","v":11},null,{"$f":"DAY(H6)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X5-X6","v":25},{"$f":"Y5-Y6","v":3},null,{"$f":"AA5-AA6","v":3},null,{"$f":"X7&\" years, \"&Y7&Y8&AA7&AA8","v":"25 years, 3 months, 3 days"}]
[null,null,null,"","","","","","","","",null,null,{"$f":"IF(OR(X7<16,X7>99),\"The age computed is not supported by the WAIS-IV\",\"\")","v":""},null,null,null,null,null,{"$f":"FIND(\" \",D5)","v":2},{"$f":"MID(D5,1,T8-1)","v":"M"},null,null,null,{"$f":"IF(Y7=1,\" month, \",\" months, \")","v":" months, "},null,{"$f":"IF(AA7=1,\" day\",\" days\")","v":" days"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2," ",4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,18,20,25,30,35,45,55,65,70,75,80,85]
[null,null,null,"SUBTESTS",null,"ss","VCI","PRI","WM","PS","Full Scale","PR",null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(N6,W10:AI10,W9:AI9)","v":{"$error":"#N/A"}},"age grp"]
[null,"Check the subtests used in the Full Scale IQ calculation.  Core subtests are those within the border",null,null,null,6,null,{"$f":"IF(bd=\"\",\"\",IF(U12=0,\"(\"&bd&\")\",bd))","v":6},null,null,{"$f":"IF(U12=0,\"\",IF(F12=\"\",\"\",F12))","v":6},{"$f":"IF(F12=\"\",\"\",LOOKUP(F12,$D$344:$W$344,$D$345:$W$345))","v":9},null,{"$f":"IF(W21>3,\"You have selected too many subtests for calculation of a Verbal Comprehension Scale\",IF(W21<3,\"You have selected too few subtests for calculation of a Verbal Comprehension Scale\",\"\"))","v":""},null,null,null,null,"bd",true,{"$f":"IF(T12=TRUE,1,0)","v":1},"p","VCI",null,"PRI","fs","wmi",null,"psi",null,"wmi",null,"ps"]
[null,null,null,null,null,2,{"$f":"IF(F13=\"\",\"\",IF(U13=0,\"(\"&F13&\")\",F13))","v":2},null,null,null,{"$f":"IF(U13=0,\"\",IF(F13=\"\",\"\",F13))","v":2},0.4,null,null,null,null,null,null,"sim",true,{"$f":"IF(T13=TRUE,1,0)","v":1},"v",{"$f":"G28","v":20},null,{"$f":"H28","v":15},{"$f":"K28","v":50},{"$f":"I28","v":5},null,{"$f":"J28","v":10},null,{"$f":"F17+F19+F24","v":9},null,{"$f":"F14+F23","v":3}]
[null,null,null,null,null,3,null,null,{"$f":"IF(F14=\"\",\"\",IF(U14=0,\"(\"&F14&\")\",F14))","v":3},null,3,1,null,{"$f":"IF(W20>3,\"You have selected too many subtests for calculation of a Perceptual Reasoning Scale\",IF(W20<3,\"You have selected too few subtests for calculation of a Perceptual Reasoning Scale\",\"\"))","v":""},null,null,null,null,"ds",true,1,"w"]
[null,null,null,null,null,2,null,{"$f":"IF(F15=\"\",\"\",IF(U15=0,\"(\"&F15&\")\",F15))","v":2},null,null,2,0.4,null,null,null,null,null,null,"mr",true,1,"p",null,null,"ss",null,null,"ss"]
[null,null,null,null,null,9,{"$f":"IF(F16=\"\",\"\",IF(U16=0,\"(\"&F16&\")\",F16))","v":9},null,null,null,9,37,null,{"$f":"IF(W22<2,\"You have too few subtest scores for calculation of a Working Memory Scale\",IF(W22>2,\"You have too many subtest scores for calculation of a Working Memory Scale\",\"\"))","v":""},null,null,null,null,"voc",true,1,"s"]
[null,null,null,null,null,2,null,null,{"$f":"IF(F17=\"\",\"\",IF(U17=0,\"(\"&F17&\")\",F17))","v":2},null,2,0.4,null,null,null,null,null,null,"ar",true,1,"v",null,null,null,"S V I",{"$f":"IF(U13+U16+U20=3,1,0)","v":1},null,"BD MR VP",null,{"$f":"IF(U12+U19+U15=3,1,0)","v":1}]
[null,null,null,null,null,2,null,null,null,{"$f":"IF(F18=\"\",\"\",IF(U18=0,\"(\"&F18&\")\",F18))","v":2},2,0.4,null,{"$f":"IF(W19<2,\"You have too few subtest scores for calculation of a Processing Speed Scale\",IF(W19>2,\"You have too many subtest scores for calculation of a Processing Speed Scale\",\"\"))","v":""},null,null,null,null,"SS",true,1,"w",null,null,null,"C V I",{"$f":"IF(U20+U16+U24=3,2,0)","v":0},null,"FW MR VP",null,{"$f":"IF(U23+U15+U19=3,2,0)","v":0}]
[null,null,null,null,null,7,null,{"$f":"IF(F19=\"\",\"\",IF(U19=0,\"(\"&F19&\")\",F19))","v":7},null,null,7,16,null,null,null,null,null,null,"VP",true,1,"p",{"$f":"U18+U21+U25","v":2},"psi",null,"S C I",{"$f":"IF(U13+U24+U20=3,3,0)","v":0},null,"BD FW VP",null,{"$f":"IF(U12+U19+U23=3,3,0)","v":0}]
[null,null,null,null,null,9,{"$f":"IF(F20=\"\",\"\",IF(U20=0,\"(\"&F20&\")\",F20))","v":9},null,null,null,9,37,null,null,null,null,null,null,"Inf",true,1,"v",{"$f":"U12+U15+U19+U23+U26","v":3},"PRI",null,"S V C",{"$f":"IF(U13+U24+U16=3,4,0)","v":0},null,"BD MR FW",null,{"$f":"IF(U12+U23+U15=3,4,0)","v":0}]
[null,null,null,null,null,8,null,null,null,{"$f":"IF(F21=\"\",\"\",IF(U21=0,\"(\"&F21&\")\",F21))","v":8},{"$f":"IF(U21=0,\"\",IF(F21=\"\",\"\",F21))","v":8},25,null,{"$f":"IF(W23>10,\"You have selected too many subtests for inclusion in a Full Scale IQ\",IF(W23<10,\"You have selected too few subtests for calculation of a Full Scale IQ\",\"\"))","v":""},null,null,null,null,"cd",true,1,"s",{"$f":"U13+U16+U20+U24","v":3},"verbal",null,null,null,null,"PC MR VP",null,{"$f":"IF(U15+U26+U19=3,5,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F22=\"\",\"\",IF(U22=0,\"(\"&F22&\")\",F22))","v":""},null,"","",null,null,null,null,null,null,"lns",false,0,"p",{"$f":"U14+U17+U22","v":2},"wm",null,null,null,null,"BD PC VP",null,{"$f":"IF(U12+U26+U19=3,6,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F23=\"\",\"\",IF(U23=0,\"(\"&F23&\")\",F23))","v":""},null,null,"","",null,{"$f":"IF(AND(W21=3,AA24>0),\"The VCI is based upon the following subtests:                                      \"&CHOOSE(AA24,Z17,Z18,Z19,Z20),IF(AA24=0,\"The combination of VCI subtests chosen cannot be used to compute an IQ.\",\"\"))","v":"The VCI is based upon the following subtests:                                      S V I"},null,null,null,null,"fw",false,{"$f":"IF(T23=TRUE,1,0)","v":0},"s",{"$f":"SUM(U12:U26)","v":10},"total",null,null,null,null,"BD MR PC",null,{"$f":"IF(U12+U26+U15=3,7,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(F24=\"\",\"\",IF(U24=0,\"(\"&F24&\")\",F24))","v":""},null,null,null,"","",null,null,null,null,null,null,"comp",false,0,"v",null,null,null,"v combo",{"$f":"SUM(AA17:AA20)","v":1},null,null,"p combo",{"$f":"SUM(AE17:AE23)","v":1},"cd or ss",{"$f":"IF(U19=1,1,IF(U17=1,2,0))","v":1}]
[null,null,null,null,null,11,null,null,null,{"$f":"IF(F25=\"\",\"\",IF(U25=0,\"(\"&F25&\")\",F25))","v":"(11)"},"",63,null,{"$f":"IF(AND(W20=3,AE24>0),\"The PRI is based upon the following subtests:                      \"&CHOOSE(AE24,AC17,AC18,AC19,AC20,AC21,AC22,AC23),IF(AE24=0,\"The combination of PRI subtests chosen cannot be used to compute an IQ.\",\"\"))","v":"The PRI is based upon the following subtests:                      BD MR VP"},null,null,null,null,"ca",false,0,"w"]
[null,null,null,null,null,null,null,{"$f":"IF(F26=\"\",\"\",IF(U26=0,\"(\"&F26&\")\",F26))","v":""},null,null,"","",null,null,null,null,null,null,"pcm",false,0,"v"]
[]
[null,null,null,null,null,"Sums of Scaled Scores",{"$f":"SUM(G13:G26)","v":20},{"$f":"SUM(H12:H24)","v":15},{"$f":"SUM(I14:I25)","v":5},{"$f":"SUM(J17:J25)","v":10},{"$f":"SUM(K12:K26)","v":50},null,null,"*16 - 69 only"]
[]
[null,"Process Scores",null,"Block Design No Time Bonus",null,14,null,null,null,null,null,{"$f":"IF(F30=\"\",\"\",LOOKUP(F30,$D$344:$W$344,$D$345:$W$345))","v":91}]
[null,null,null,"Digit Span Forward",null,18,null,null,null,null,null,{"$f":"IF(F31=\"\",\"\",LOOKUP(F31,$D$344:$W$344,$D$345:$W$345))","v":99.599999999999}]
[null,null,null,"Digit Span Backward",null,17,null,null,null,null,null,{"$f":"IF(F32=\"\",\"\",LOOKUP(F32,$D$344:$W$344,$D$345:$W$345))","v":99}]
[null,null,null,"Digit Span Sequencing",null,13,null,null,null,null,null,{"$f":"IF(F33=\"\",\"\",LOOKUP(F33,$D$344:$W$344,$D$345:$W$345))","v":84}]
[null,null,null,"Longest Digit Forward (raw score)",null,null,9]
[null,null,null,"Longest Digit Backward (raw score)",null,null,8]
[null,null,null,"Longest Digit Sequencing (raw score)",null,null,7]
[null,null,null,"Longest Letter-Number (raw score)",null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,"s",{"$f":"IF(F13=\"\",\"\",1)","v":1},{"$f":"IF(F13=\"\",\"\",F13)","v":2},"bd",{"$f":"IF(F12=\"\",\"\",1)","v":1},{"$f":"IF(F12=\"\",\"\",F12)","v":6},"cd",{"$f":"IF(F21=\"\",\"\",1)","v":1},{"$f":"IF(F21=\"\",\"\",F21)","v":8},"ds",{"$f":"IF(F14=\"\",\"\",1)","v":1},{"$f":"IF(F14=\"\",\"\",F14)","v":3}]
["WAIS-IV Interpretive Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v",{"$f":"IF(F16=\"\",\"\",1)","v":1},{"$f":"IF(F16=\"\",\"\",F16)","v":9},"mr",{"$f":"IF(F15=\"\",\"\",1)","v":1},{"$f":"IF(F15=\"\",\"\",F15)","v":2},"ss",{"$f":"IF(F18=\"\",\"\",1)","v":1},{"$f":"IF(F18=\"\",\"\",F18)","v":2},"ar",{"$f":"IF(F17=\"\",\"\",1)","v":1},{"$f":"IF(F17=\"\",\"\",F17)","v":2}]
[null,"Evaluate the Full Scale IQ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i",{"$f":"IF(F20=\"\",\"\",1)","v":1},{"$f":"IF(F20=\"\",\"\",F20)","v":9},"vp",{"$f":"IF(F19=\"\",\"\",1)","v":1},{"$f":"IF(F19=\"\",\"\",F19)","v":7},"ca",{"$f":"IF(F25=\"\",\"\",1)","v":1},{"$f":"IF(F25=\"\",\"\",F25)","v":11},"lns",{"$f":"IF(F22=\"\",\"\",1)","v":""},{"$f":"IF(F22=\"\",\"\",F22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fw",{"$f":"IF(F23=\"\",\"\",1)","v":""},{"$f":"IF(F23=\"\",\"\",F23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB37:AB38)","v":2},null,null,{"$f":"SUM(AE37:AE38)","v":2}]
[]
[null,null,"",null,null,null,null,"Obtained",null,"Percentile",null,"Confidence",null,"Narrative Category",null,null,null,null,null,null,"c",{"$f":"IF(F24=\"\",\"\",1)","v":""},{"$f":"IF(F24=\"\",\"\",F24)","v":""},"pcm",{"$f":"IF(F26=\"\",\"\",1)","v":""},{"$f":"IF(F26=\"\",\"\",F26)","v":""},null,{"$f":"SUM(AB37:AB39)","v":3},{"$f":"SUM(AC37:AC39)","v":21},null,{"$f":"SUM(AE37:AE39)","v":2},{"$f":"SUM(AF37:AF39)","v":5}]
[null,null,null,null,null,"  SS Totals",null," IQ",null,"Rank",null,"Bands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,{"$f":"SUM(W37:W44)","v":20},null,null,{"$f":"SUM(Z37:Z44)","v":15}]
[null,null,null,"Verbal Comprehension",null,{"$f":"IF(W21=3,\"(\"&W13&\")\",\"\")","v":"(20)"},null,116,null,{"$f":"IF(H46=\"\",\"\",LOOKUP(H46,B338:BG339))","v":86},null,{"$f":"IF(H46=\"\",\"\",X46&\" - \"&Y46)","v":"111 - 120"},null,{"$f":"IF(H46=\"\",\"\",LOOKUP((LOOKUP(H46,D414:O415)+H46),$D$412:$J$413)&\" to \"&LOOKUP((LOOKUP(H46,D414:O414,D416:O416)+H46),$D$412:$J$413))","v":"Average to Superior"},null,null,null,null,null,0.96,{"$f":"100+T46*(H46-100)","v":115.36},{"$f":"15*T46*SQRT((1-T46))","v":2.8800000000000012},{"$f":"IF(T45=1,V46*1.65,V46*1.96)","v":4.7520000000000016},{"$f":"ROUND(U46-W46,0)","v":111},{"$f":"ROUND(U46+W46,0)","v":120},null,null,null,null,{"$f":"SUM(Y37:Y44)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D46","v":"Verbal Comprehension"},{"$f":"X46","v":111},{"$f":"H46","v":116},{"$f":"Y46","v":120}]
[null,null,null,"Perceptual Reasoning",null,{"$f":"IF(W20=3,\"(\"&Y13&\")\",\"\")","v":"(15)"},null,109,null,{"$f":"IF(H47=\"\",\"\",LOOKUP(H47,B338:BG339))","v":73},null,{"$f":"IF(H47=\"\",\"\",X47&\" - \"&Y47)","v":"103 - 114"},null,{"$f":"IF(H47=\"\",\"\",LOOKUP((LOOKUP(H47,D414:O415)+H47),$D$412:$J$413)&\" to \"&LOOKUP((LOOKUP(H47,D414:O414,D416:O416)+H47),$D$412:$J$413))","v":"Average to High Average"},null,null,null,null,null,0.95,{"$f":"100+T47*(H47-100)","v":108.55},{"$f":"15*T47*SQRT((1-T47))","v":3.1863968679372019},{"$f":"IF(T45=1,V47*1.65,V47*1.96)","v":5.2575548320963827},{"$f":"ROUND(U47-W47,0)","v":103},{"$f":"ROUND(U47+W47,0)","v":114},null,{"$f":"SUM(V37:V44)","v":3},{"$f":"SUM(V37:V45)","v":3},null,{"$f":"SUM(Y37:Y44)","v":3},null,null,null,null,{"$f":"AB47+AD47+AB43+AE43","v":11},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D47","v":"Perceptual Reasoning"},{"$f":"X47","v":103},{"$f":"H47","v":109},{"$f":"Y47","v":114}]
[null,null,null,"Working Memory",null,{"$f":"IF(AB43<2,\"\",\"(\"&AA13&\")\")","v":"(5)"},null,122,null,{"$f":"IF(H48=\"\",\"\",LOOKUP(H48,B338:BG339))","v":93},null,{"$f":"IF(H48=\"\",\"\",X48&\" - \"&Y48)","v":"115 - 126"},null,{"$f":"IF(H48=\"\",\"\",LOOKUP((LOOKUP(H48,D414:O415)+H48),$D$412:$J$413)&\" to \"&LOOKUP((LOOKUP(H48,D414:O414,D416:O416)+H48),$D$412:$J$413))","v":"High Average to Superior"},null,null,null,null,null,0.94,{"$f":"100+T48*(H48-100)","v":120.68},{"$f":"15*T48*SQRT((1-T48))","v":3.4537805373242825},{"$f":"IF(T45=1,V48*1.65,V48*1.96)","v":5.6987378865850662},{"$f":"ROUND(U48-W48,0)","v":115},{"$f":"ROUND(U48+W48,0)","v":126},"Vx=",{"$f":"W45/AA47","v":6.666666666666667},{"$f":"W45/AB47","v":6.666666666666667},{"$f":"SUM(W37:W44)","v":20},"Px=",{"$f":"Z45/AD47","v":5},null,{"$f":"SUM(W45+Z45+AC43+AF43)","v":61},"FSx=",{"$f":"AG48/AI47","v":5.5454545454545459},null,"vp diff",{"$f":"ABS(H46-H47)","v":7},null,null,null,null,null,null,null,null,null,{"$f":"D48","v":"Working Memory"},115,{"$f":"H48","v":122},126]
[null,null,null,"Processing Speed",null,{"$f":"IF(AE43<2,\"\",\"(\"&AC13&\")\")","v":"(10)"},null,86,null,{"$f":"IF(H49=\"\",\"\",LOOKUP(H49,B338:BG339))","v":18},null,{"$f":"IF(H49=\"\",\"\",X49&\" - \"&Y49)","v":"80 - 94"},null,{"$f":"IF(H49=\"\",\"\",LOOKUP((LOOKUP(H49,D414:O415)+H49),$D$412:$J$413)&\" to \"&LOOKUP((LOOKUP(H49,D414:O414,D416:O416)+H49),$D$412:$J$413))","v":"Low Average to Average"},null,null,null,null,null,0.9,{"$f":"100+T49*(H49-100)","v":87.4},{"$f":"15*T49*SQRT((1-T49))","v":4.2690748412273116},{"$f":"IF(T45=1,V49*1.65,V49*1.96)","v":7.0439734880250642},{"$f":"ROUND(U49-W49,0)","v":80},{"$f":"ROUND(U49+W49,0)","v":94},"v max",{"$f":"MAX(W37:W44)","v":9},null,"p max",{"$f":"MAX(Z37:Z44)","v":7},{"$f":"IF(AA49=AD49,AA49,IF(AA49>AD49,AA49,AD49))","v":9},null,null,null,null,null,null,{"$f":"LOOKUP(AL48,D357:AR357,D366:AR366)","v":54},null,null,null,null,null,null,null,null,null,{"$f":"D49","v":"Processing Speed"},80,{"$f":"H49","v":86},94]
[null,null,null," Full Scale",null,{"$f":"IF(W23=10,\"(\"&Z13&\")\",\"\")","v":"(50)"},null,111,null,{"$f":"IF(H50=\"\",\"\",LOOKUP(H50,B338:BG339))","v":77},null,{"$f":"IF(H50=\"\",\"\",X50&\" - \"&Y50)","v":"107 - 114"},null,{"$f":"IF(H50=\"\",\"\",LOOKUP((LOOKUP(H50,D414:O415)+H50),$D$412:$J$413)&\" to \"&LOOKUP((LOOKUP(H50,D414:O414,D416:O416)+H50),$D$412:$J$413))","v":"Average to High Average"},null,null,null,null,null,0.98,{"$f":"100+T50*(H50-100)","v":110.78},{"$f":"15*T50*SQRT((1-T50))","v":2.0788939366884502},{"$f":"IF(T45=1,V50*1.65,V50*1.96)","v":3.4301749955359426},{"$f":"ROUND(U50-W50,0)","v":107},{"$f":"ROUND(U50+W50,0)","v":114},"v min",{"$f":"MIN(W37:W44)","v":2},null,"p min",{"$f":"MIN(Z37:Z44)","v":2},{"$f":"IF(AA50=AD50,AA50,IF(AA50<AD50,AA50,AD50))","v":2},{"$f":"AE49-AE50","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D50","v":" Full Scale"},107,{"$f":"H50","v":111},114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"diff",{"$f":"ABS(AA49-AA50)","v":7},null,"diff",{"$f":"ABS(AD49-AD50)","v":5},null,"fs sc diff",{"$f":"AF50","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v scat",{"$f":"IF(AA47<6,\"\",IF(AA47=6, LOOKUP(AA51,D357:V357,D358:V358),LOOKUP(AA51,D357:V357,D359:V359)))","v":""},null,"p scat",{"$f":"IF(AD47<4,\"\",LOOKUP(AD51,D357:V357,D360:V360))","v":""},null,"11fs scat",{"$f":"LOOKUP(AG51,D357:V357,D362:W362)","v":50.9},null,{"$f":"IF(AI47=14,AE54,IF(AI47=11,AG52,AG53))","v":50.9}]
[null,"Is the VCI versus PRI Significantly Different?                                     Note: See Table B.1 for standardization frequency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1213fs scat",{"$f":"LOOKUP(AG51,D357:V357,D363:W363)","v":58}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14fs scat",{"$f":"LOOKUP(AG51,D357:V357,D364:W364)","v":63.8}]
[null,null,null,null,null,"Significance",null,null,null,null,null,"Is there a significant difference?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H46=H47,0,IF(H46>H47,1,2))","v":1}]
[null,null,null,{"$f":"\"VCI (\"&H46&\") vs PRI (\"&H47&\") Difference\"","v":"VCI (116) vs PRI (109) Difference"},null,"(p <  .01)",null,"(p < .05)",null,"none",null,null,null,null,null,null,null,null,null,{"$f":"ABS(H46-H47)","v":7},{"$f":"IF(T56=1,\" point\",\" points\")","v":" points"},null,null,null,{"$f":"IF(ABS(H46-H47)>8,1,-1)","v":-1}]
[null,null,null,{"$f":"IF(OR(H46=\"\",H47=\"\"),\"\",T56&U56)","v":"7 points"},null,"12 or more",null,9,null,"0 - 8",null,{"$f":"IF(OR(H46=\"\",H47=\"\"),\"\",IF(T56>11, \"YES, p = .01\", IF(T56<9, \"NO\",\"YES, p = .05\")))","v":"NO"},null,null,null,null,null,null,null,{"$f":"IF(L57=\"NO\",0,1)","v":0},null,"Because there is no significant differences between the VCI and PRI, explain the meaning of the scales not being significantly different.",null,null,{"$f":"SUM(Y55+Y56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Because there is a significant difference between the VCI and PRI, interpret the FSIQ with caution.  Examine further steps."]
[]
[null,null,null,{"$f":"IF(L57=\"\",\"\",IF(T57=0,V57,V58))","v":"Because there is no significant differences between the VCI and PRI, explain the meaning of the scales not being significantly different."}]
[]
[]
[]
[null,"Is the VCI versus PRI Difference Abnormally Large?                         Note: See Table B.2 for standardization frequency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[null,null,{"$f":"\"VCI (\"&H46&\") vs PRI (\"&H47&\") Difference\"","v":"VCI (116) vs PRI (109) Difference"},null,null,"Size of Difference needed for abnormality",null,null,null,null,null,"Is Size of Difference Abnormal?",null,null,null,null,null,null,null,{"$f":"IF(H46=H47,0,IF(H46>H47,1,2))","v":1},{"$f":"IF(H50>119,5,IF(H50>109,4,IF(H50>89,3,IF(H50>79,2,1))))","v":4},1,17,16,16,18,20]
[null,null,{"$f":"D57&\" (\"&T67&\")\"","v":"7 points (V > P)"},null,null,{"$f":"INDEX(W66:AA67,T66,U66)","v":18},null,null,null,null,null,{"$f":"IF(D57=\"\",\"\",IF(T56<F67,\"NO\",\"YES\"))","v":"NO"},null,null,null,null,null,null,null,{"$f":"IF(H46=H47,\"V = P\",IF(H46>H47,\"V > P\",\"V < P\"))","v":"V > P"},"IQ group",2,13,15,18,19,20]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L67=\"NO\",0,1)","v":0},null,"Because no abnormal differences are found, determine if the noted differences are interpretable."]
[null,null,null,{"$f":"IF(L67=\"\",\"\",IF(T69=0,V69,V70))","v":"Because no abnormal differences are found, determine if the noted differences are interpretable."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Because an abnormal difference was found, explain the abnormally large VCI vs PRI difference."]
[]
[]
[]
[null,"Are the VCI and PRI composites interpretable?                               Note: See Table B.6 for standardization frequency"]
[]
[null,null,null,"A. Is there abnormal VCI scatter?",null,null,null,null,null,null,null,null,"Is there abnormal scatter?"]
[null,null,null,"Verbal Subtests High-Low Difference",null,null,null,null,"Normal",null,"Abnormal"]
[null,null,null,{"$f":"AA51&U78&\" between \"&AA47&\" subtests\"","v":"7 points between 3 subtests"},null,null,null,null,"0 - 5",null,"6 or more",null,{"$f":"IF(AA51>5,\"YES\",\"NO\")","v":"YES"},null,null,null,null,null,null,null,{"$f":"IF(AA51=1,\" point\",\" points\")","v":" points"}]
[]
[]
[null,null,null,"B. Is there abnormal PRI scatter?",null,null,null,null,null,null,null,null,"Is there abnormal scatter?"]
[null,null,null,"Perceptual Reasoning Subtests High-Low Difference",null,null,null,null,"Normal",null,"Abnormal",null,null,null,null,null,null,null,null,null,{"$f":"IF(M78=\"NO\",0,1)","v":1}]
[null,null,null,{"$f":"AD51&U84&\" between \"&AD47&\" subtests\"","v":"5 points between 3 subtests"},null,null,null,null,{"$f":"IF(AD47<5,\"0 - 6\",\"0 - 7\")","v":"0 - 6"},null,{"$f":"IF(AD47<5,\"7 or more\",\"8 or more\")","v":"7 or more"},null,{"$f":"IF(AND(AD47<5,AD51>6),\"YES\",IF(AND(AD47=5,AD51>7),\"YES\",\"NO\"))","v":"NO"},null,null,null,null,null,null,null,{"$f":"IF(M83=\"NO\",0,1)","v":0},{"$f":"U82+U83","v":1},"Because each answers to A and B was NO, the VCI versus PRI discrepancy is interpretable. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD51=1,\" point\",\" points\")","v":" points"},null,"Because an answer to either A or B was YES, the VCI versus PRI discrepancy differences should probably not be interpreted. "]
[]
[null,null,null,{"$f":"IF(V83=0,W83,W84)","v":"Because an answer to either A or B was YES, the VCI versus PRI discrepancy differences should probably not be interpreted. "}]
[]
[]
[]
[null,"Determine if the Working Memory Index is interpretable.                 Note: See Table B.4 for standardization frequency"]
[]
[null,null,null,"A. Is there a significant difference between the WMI subtests?",null,null,null,null,null,null,null,null,"Is there abnormal scatter?"]
[null,null,null,{"$f":"IF(AB32=1,\"No Index Computed\",\"WMI Subtests [ DS (\"&F14&\") AR (\"&F17&\") ] Difference \")","v":"WMI Subtests [ DS (3) AR (2) ] Difference "},null,null,null,null,"Normal",null,"Abnormal",null,null,null,null,null,null,null,null,null,{"$f":"ABS(AF37-AF38)","v":1}]
[null,null,null,{"$f":"U93&U95","v":"1 point"},null,null,null,null,"0 - 3",null,"4 or more",null,{"$f":"IF(AE41<>2,\"\",IF(U93>4,\"YES\",\"NO\"))","v":"NO"},null,null,null,null,null,null,null,{"$f":"IF(M94=\"NO\",0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U93=1,\" point\",\" points\")","v":" point"}]
[]
[null,null,null,{"$f":"IF(AE41<>2,\"No index computed\",IF(U94=0,\"The WMI may be interpreted.\",\"Because of subtest differences in the WMI, do not interpret WMI.\"))","v":"The WMI may be interpreted."}]
[]
[]
[null,"Determine if the Processing Speed Index is interpretable.                 Note: See Table B.4 for standardization frequency"]
[]
[null,null,null,"A. Is there a significant difference between the PSI subtests?",null,null,null,null,null,null,null,null,"Is there abnormal scatter?"]
[null,null,null,{"$f":"IF(AB43=1,\"No Index Computed\",\"PSI Subtests [ SS (\"&F18&\") Cd (\"&F21&\") ] Difference \")","v":"PSI Subtests [ SS (2) Cd (8) ] Difference "},null,null,null,null,"Normal",null,"Abnormal",null,null,null,null,null,null,null,null,null,{"$f":"ABS(AC37-AC38)","v":6}]
[null,null,null,{"$f":"U103&U105","v":"6 points"},null,null,null,null,"0 - 3",null,"4 or more",null,{"$f":"IF(AB41<>2,\"\",IF(U103>3,\"YES\",\"NO\"))","v":"YES"},null,null,null,null,null,null,null,{"$f":"IF(M104=\"NO\",0,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U103=1,\" point\",\" points\")","v":" points"}]
[]
[null,null,null,{"$f":"IF(AB41<>2,\"No index computed\",IF(U104=0,\"The PSI may be interpreted.\",\"Because of subtest differences in the PSI, do not interpret PSI.\"))","v":"Because of subtest differences in the PSI, do not interpret PSI."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"core mean"]
[]
[null,"Interpret significant strengths and weaknesses.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(sim=\"\",\"\",IF(VOC=\"\",\"\",IF(IN=\"\",\"\",1)))","v":1},{"$f":"IF(sim=\"\",\"\",IF(VOC=\"\",\"\",IF(IN=\"\",\"\",(sim+VOC+IN))))","v":20},{"$f":"IF(sim=\"\",\"\",IF(VOC=\"\",\"\",IF(IN=\"\",\"\",3)))","v":3},{"$f":"IF(AE110=1,(AF110/AG110),\"\")","v":6.666666666666667}]
[null,null,null,null,null,null,null,null,"Verbal Comprehension mean",null,{"$f":"IF(T113=1,AH110,AA48)","v":6.666666666666667},{"$f":"\"   based on \"&IF(T113=1,AG110,AA47)&\" subtests\"","v":"   based on 3 subtests"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(bd=\"\",\"\",IF(MR=\"\",\"\",1))","v":1},{"$f":"IF(bd=\"\",\"\",IF(MR=\"\",\"\",IF(VP=\"\",\"\",(bd+MR+VP))))","v":15},{"$f":"IF(bd=\"\",\"\",IF(MR=\"\",\"\",IF(VP=\"\",\"\",3)))","v":3},{"$f":"IF(AE111=1,(AF111/AG111),\"\")","v":5}]
[null,null,null,null,null,null,null,null,"Perceptual Reasoning mean",null,{"$f":"IF(T113=1,AH111,AE48)","v":5},{"$f":"\"   based on \"&IF(T113=1,AG111,AD47)&\" subtests\"","v":"   based on 3 subtests"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DS=\"\",\"\",IF(AR=\"\",\"\",1))","v":1},{"$f":"IF(DS=\"\",\"\",IF(AR=\"\",\"\",(DS+AR)))","v":5},{"$f":"IF(DS=\"\",\"\",IF(AR=\"\",\"\",2))","v":2},{"$f":"IF(AE112=1,(AF112/AG112),\"\")","v":2.5}]
[null,null,null,null,null,null,null,null,"Full Scale mean",null,{"$f":"IF(T113=1,AH114,AI48)","v":5.5454545454545459},{"$f":"\"   based on \"&IF(T113=1,AG114,AI47)&\" subtests\"","v":"   based on 11 subtests"},null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SS=\"\",\"\",IF(CD=\"\",\"\",1))","v":1},{"$f":"IF(SS=\"\",\"\",IF(CD=\"\",\"\",(SS+CD)))","v":10},{"$f":"IF(SS=\"\",\"\",IF(CD=\"\",\"\",2))","v":2},{"$f":"IF(AE113=1,(AF113/AG113),\"\")","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE110:AE113)","v":4},{"$f":"SUM(AF110:AF113)","v":50},{"$f":"SUM(AG110:AG113)","v":10},{"$f":"IF(AE114=4,(AF114/AG114),\"\")","v":5}]
[null,null,null,null,null,null,null," Verbal / Perceptual  Statistics",null,null,null,null,null,"Full Scale Statistics"]
[null,null,null,null,null,"ss",null,null,"Crit. Value",null,"Deviation",null,null,"Crit. Value",null,"Deviation",null,null,null,null,">CR","sign",">CV","sign",null,null,null,null,null,".05 15"]
[null,"Verbal",null,"Similarities",null,{"$f":"IF(F13=\"\",\"\",F13)","v":2},null,null,1.91,null,{"$f":"IF(F117=\"\",\"\",(F117-$K$111))","v":-4.666666666666667},{"$f":"IF(F117=\"\",\"\",IF(SUM(U117+V117)=4,\"s\",IF(SUM(U117+V117)=2,\"w\",\"\")))","v":"w"},null,{"$f":"IF(compmean=1,2.82,3.09)","v":3.09},null,{"$f":"IF(N117=\"\",\"\",($F117-K$113))","v":-3.5454545454545459},{"$f":"IF(F117=\"\",\"\",IF(SUM(W117+X117)=4,\"s\",IF(SUM(W117+X117)=2,\"w\",\"\")))","v":"w"},null,null,null,{"$f":"IF(ABS(K117)>=I117,3,0)","v":3},{"$f":"SIGN(K117)","v":-1},{"$f":"IF(ABS(P117)>=N117,3,0)","v":3},{"$f":"SIGN(P117)","v":-1},null,null,{"$f":"IF(W117=0,0,1)","v":1},{"$f":"Q117","v":"w"},"Block Design",3.0874942591039747]
[null,null,null,"Vocabulary",null,{"$f":"IF(F16=\"\",\"\",F16)","v":9},null,null,1.58,null,{"$f":"IF(F118=\"\",\"\",(F118-$K$111))","v":2.333333333333333},{"$f":"IF(F118=\"\",\"\",IF(SUM(U118+V118)=4,\"s\",IF(SUM(U118+V118)=2,\"w\",\"\")))","v":"s"},null,{"$f":"IF(compmean=1,2.03,2.18)","v":2.1800000000000002},null,{"$f":"IF(N118=\"\",\"\",($F118-K$113))","v":3.4545454545454541},{"$f":"IF(F118=\"\",\"\",IF(SUM(W118+X118)=4,\"s\",IF(SUM(W118+X118)=2,\"w\",\"\")))","v":"s"},null,null,null,{"$f":"IF(ABS(K118)>=I118,3,0)","v":3},1,{"$f":"IF(ABS(P118)>=N118,3,0)","v":3},{"$f":"SIGN(P118)","v":1},null,null,{"$f":"IF(W118=0,0,1)","v":1},{"$f":"Q118","v":"s"},"Similarities",3.0874942591039747]
[null,null,null,"Information",null,{"$f":"IF(F20=\"\",\"\",F20)","v":9},null,null,1.64,null,{"$f":"IF(F119=\"\",\"\",(F119-$K$111))","v":2.333333333333333},{"$f":"IF(F119=\"\",\"\",IF(SUM(U119+V119)=4,\"s\",IF(SUM(U119+V119)=2,\"w\",\"\")))","v":"s"},null,{"$f":"IF(compmean=1,2.19,2.33)","v":2.33},null,{"$f":"IF(N119=\"\",\"\",($F119-K$113))","v":3.4545454545454541},{"$f":"IF(F119=\"\",\"\",IF(SUM(W119+X119)=4,\"s\",IF(SUM(W119+X119)=2,\"w\",\"\")))","v":"s"},null,null,null,3,1,3,1,null,null,1,{"$f":"Q119","v":"s"},"Digit Span",2.3307063307074953,null,{"$f":"LOOKUP(#REF!,R369:W369,R370:W370)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,R371:W371,R372:W372)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,R373:W373,R374:W374)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,R375:W375,R376:W376)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,R377:W377,R378:W378)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(AJ53,AF119,AG119,AH119,AI119,AJ119)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Comprehension",null,{"$f":"IF(F24=\"\",\"\",F24)","v":""},null,null,{"$f":"IF(OR(F120=\"\",T113=1),\"\",IF($AB$47<3,\"\",2))","v":""},null,{"$f":"IF(OR(F120=\"\",T113=1),\"\",F120-$K$111)","v":""},{"$f":"IF(OR(F120=\"\",T113=1),\"\",IF(SUM(U120+V120)=4,\"s\",IF(SUM(U120+V120)=2,\"w\",\"\")))","v":""},null,{"$f":"IF(OR(F120=\"\",compmean=1),\"\",IF($AI$47<7,\"\",3.09))","v":""},null,{"$f":"IF(OR(F120=\"\",T113=1),\"\",($F120-K$113))","v":""},{"$f":"IF(OR(F120=\"\",T113=1),\"\",IF(SUM(W120+X120)=4,\"s\",IF(SUM(W120+X120)=2,\"w\",\"\")))","v":""},null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$f":"Q120","v":""},"Matrix Reasoning",2.7353987643486275,null,{"$f":"LOOKUP(#REF!,D369:I369,D370:I370)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,D371:I371,D372:I372)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,D373:I373,D374:I374)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,D375:I375,D376:I376)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,D377:I377,D378:I378)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(AJ53,AF120,AG120,AH120,AI120,AJ120)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vocabulary",2.1791712186058265,null,{"$f":"LOOKUP(#REF!,K369:P369,K370:P370)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,K371:P371,K372:P372)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,K373:P373,K374:P374)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,K375:P375,K376:P376)","v":{"$error":"#REF!"}},{"$f":"LOOKUP(#REF!,K377:P377,K378:P378)","v":{"$error":"#REF!"}},{"$f":"CHOOSE(AJ53,AF121,AG121,AH121,AI121,AJ121)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Block Design",null,{"$f":"IF(F12=\"\",\"\",F12)","v":6},null,null,2.0499999999999998,null,{"$f":"IF(F122=\"\",\"\",(F122-$K$112))","v":1},{"$f":"IF(F122=\"\",\"\",IF(SUM(U122+V122)=4,\"s\",IF(SUM(U122+V122)=2,\"w\",\"\")))","v":""},null,{"$f":"IF(compmean=1,2.85,3.09)","v":3.09},null,{"$f":"IF(N122=\"\",\"\",($F122-K$113))","v":0.45454545454545414},{"$f":"IF(F122=\"\",\"\",IF(SUM(W122+X122)=4,\"s\",IF(SUM(W122+X122)=2,\"w\",\"\")))","v":""},null,null,null,0,1,0,1,null,null,0,{"$f":"Q122","v":""},"Arithmetic",2.9747631838517838]
[null,"Perceptual",null,"Matrix Reasoning",null,{"$f":"IF(F15=\"\",\"\",F15)","v":2},null,null,1.92,null,{"$f":"IF(F123=\"\",\"\",(F123-$K$112))","v":-3},{"$f":"IF(F123=\"\",\"\",IF(SUM(U123+V123)=4,\"s\",IF(SUM(U123+V123)=2,\"w\",\"\")))","v":"w"},null,{"$f":"IF(compmean=1,2.54,2.74)","v":2.74},null,{"$f":"IF(N123=\"\",\"\",($F123-K$113))","v":-3.5454545454545459},{"$f":"IF(F123=\"\",\"\",IF(SUM(W123+X123)=4,\"s\",IF(SUM(W123+X123)=2,\"w\",\"\")))","v":"w"},null,null,null,3,-1,3,-1,null,null,1,{"$f":"Q123","v":"w"},"Symbols Search",3.6922959794686014]
[null,null,null,"Visual Puzzles",null,{"$f":"IF(F19=\"\",\"\",F19)","v":7},null,null,1.99,null,{"$f":"IF(F124=\"\",\"\",(F124-$K$112))","v":2},{"$f":"IF(F124=\"\",\"\",IF(SUM(U124+V124)=4,\"s\",IF(SUM(U124+V124)=2,\"w\",\"\")))","v":"s"},null,{"$f":"IF(compmean=1,2.71,2.86)","v":2.86},null,{"$f":"IF(N124=\"\",\"\",($F124-K$113))","v":1.4545454545454541},{"$f":"IF(F124=\"\",\"\",IF(SUM(W124+X124)=4,\"s\",IF(SUM(W124+X124)=2,\"w\",\"\")))","v":""},null,null,null,3,1,0,1,null,null,0,{"$f":"Q124","v":""},"Visual Puzzles",2.8575883538396498]
[null,null,null,"Figure Weights",null,{"$f":"IF(F23=\"\",\"\",F23)","v":""},null,null,{"$f":"IF(OR(F125=\"\",T113=1),\"\",IF($AB$47<3,\"\",2))","v":""},null,{"$f":"IF(OR(F125=\"\",T113=1),\"\",(F125-$K$112))","v":""},{"$f":"IF(OR(F125=\"\",T113=1),\"\",IF(SUM(U125+V125)=4,\"s\",IF(SUM(U125+V125)=2,\"w\",\"\")))","v":""},null,{"$f":"IF(OR(F125=\"\",T113=1),\"\",IF($AI$47<7,\"\",2.74))","v":""},null,{"$f":"IF(OR(F125=\"\",T113=1),\"\",($F125-K$113))","v":""},{"$f":"IF(OR(F125=\"\",T113=1),\"\",IF(SUM(W125+X125)=4,\"s\",IF(SUM(W125+X125)=2,\"w\",\"\")))","v":""},null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$f":"Q125","v":""},"Information",2.3307063307074953]
[null,null,null,"Picture Completion",null,{"$f":"IF(F26=\"\",\"\",F26)","v":""},null,null,{"$f":"IF(OR(F126=\"\",T113=1),\"\",IF($AB$47<3,\"\",2))","v":""},null,{"$f":"IF(OR(F126=\"\",T113=1),\"\",(F126-$K$112))","v":""},{"$f":"IF(OR(F126=\"\",T113=1),\"\",IF(SUM(U126+V126)=4,\"s\",IF(SUM(U126+V126)=2,\"w\",\"\")))","v":""},null,{"$f":"IF(OR(F126=\"\",T113=1),\"\",IF($AI$47<7,\"\",3.4))","v":""},null,{"$f":"IF(OR(F126=\"\",T113=1),\"\",($F126-K$113))","v":""},{"$f":"IF(OR(F126=\"\",T113=1),\"\",IF(SUM(W126+X126)=4,\"s\",IF(SUM(W126+X126)=2,\"w\",\"\")))","v":""},null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$f":"Q126","v":""},"Coding",3.1962518048489237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q129","v":"w"},"Letter-Number Sequence",2.9747631838517838]
[null,"WM",null,"Digit Span",null,{"$f":"IF(F14=\"\",\"\",F14)","v":3},null,null,null,null,null,null,null,{"$f":"IF(compmean=1,2.22,2.33)","v":2.33},null,{"$f":"IF(N128=\"\",\"\",($F128-K$113))","v":-2.5454545454545459},{"$f":"IF(F128=\"\",\"\",IF(SUM(W128+X128)=4,\"s\",IF(SUM(W128+X128)=2,\"w\",\"\")))","v":"w"},null,null,null,null,null,3,-1,null,null,{"$f":"IF(W128=0,0,1)","v":1},null,"Figure Weights",2.7353987643486275]
[null,null,null,"Arithmetic",null,{"$f":"IF(F17=\"\",\"\",F17)","v":2},null,null,null,null,null,null,null,{"$f":"IF(compmean=1,2.73,2.97)","v":2.97},null,{"$f":"IF(N129=\"\",\"\",($F129-K$113))","v":-3.5454545454545459},"w",null,null,null,null,null,3,-1,null,null,{"$f":"IF(W129=0,0,1)","v":1},{"$f":"Q130","v":""},"Comprehension",3.0874942591039747]
[null,null,null,"Letter-Number Sequence",null,{"$f":"IF(F22=\"\",\"\",F22)","v":""},null,null,null,null,null,{"$f":"IF(F130=\"\",\"\",IF(SUM(U129+V129)=4,\"s\",IF(SUM(U129+V129)=2,\"w\",\"\")))","v":""},null,{"$f":"IF(OR(F130=\"\",T113=1),\"\",IF($AI$47<7,\"\",2.97))","v":""},null,{"$f":"IF(OR(F130=\"\",T113=1),\"\",($F130-K$113))","v":""},{"$f":"IF(OR(F130=\"\",T113=1),\"\",IF(SUM(W130+X130)=4,\"s\",IF(SUM(W130+X130)=2,\"w\",\"\")))","v":""},null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},null,"Cancellation",3.9602100954368566]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Picture Completion",3.4033564609073799]
[null,"Pr.  Spd.",null,"Symbol Search",null,{"$f":"IF(F18=\"\",\"\",F18)","v":2},null,null,null,null,null,null,null,{"$f":"IF(F132=\"\",\"\",IF(compmean=1,3.42,3.69))","v":3.69},null,{"$f":"IF(N132=\"\",\"\",($F132-K$113))","v":-3.5454545454545459},"",null,null,null,null,null,0,-1,null,null,0]
[null,null,null,"Coding",null,{"$f":"IF(F21=\"\",\"\",F21)","v":8},null,null,null,null,null,null,null,{"$f":"IF(compmean=1,2.97,3.2)","v":3.2},null,{"$f":"IF(N133=\"\",\"\",($F133-K$113))","v":2.4545454545454541},"",null,null,null,null,null,0,1,null,null,{"$f":"SUM(AA117:AA123)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Cancellation",null,{"$f":"IF(F25=\"\",\"\",F25)","v":11},null,null,null,null,null,null,null,{"$f":"IF(OR(F134=\"\",T113=1),\"\",IF($AI$47<7,\"\",3.96))","v":3.96},null,{"$f":"IF(OR(F134=\"\",T113=1),\"\",($F134-K$113))","v":5.4545454545454541},{"$f":"IF(OR(F134=\"\",T113=1),\"\",IF(SUM(W134+X134)=4,\"s\",IF(SUM(W134+X134)=2,\"w\",\"\")))","v":"s"},null,null,null,null,null,3,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA124:AA132)","v":{"$error":"#VALUE!"}},null,"  I","Ds","V","A","C","S"," PC"," PA"," BD"," OA","Dsm"]
[null,"Compare relevant subtest groupings (.05 level of significance)"]
[]
[null,null,{"$f":"\"Matrix Reasoning (\"&MR&\") \"&V138&\"  Block Design (\"&bd&\")\"","v":"Matrix Reasoning (2) <  Block Design (6)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F123=\"\",F122=\"\"),\"\",W138&\" point \"&X138&\" difference\")","v":"4 point significant difference"},null,null,null,null,null,null,null,null,"mr/bd",{"$f":"IF(F123=F122,1,IF(F123>F122,2,3))","v":3},{"$f":"CHOOSE(U138,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F122-F123)","v":4},{"$f":"IF(W138>2,\"significant\",\"nonsignificant\")","v":"significant"}]
[]
[null,null,{"$f":"\"Matrix Reasoning (\"&MR&\") \"&V140&\"  Figure Weights (\"&FW&\")\"","v":"Matrix Reasoning (2) <  Figure Weights ()"},null,null,null,null,null,null,null,{"$f":"IF(OR(F125=\"\",F124=\"\"),\"\",W140&\" point \"&X140&\" difference\")","v":""},null,null,null,null,null,null,null,null,"mr/fw",{"$f":"IF(F123=F125,1,IF(F123>F125,2,3))","v":3},{"$f":"CHOOSE(U140,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F123-F125)","v":{"$error":"#VALUE!"}},{"$f":"IF(W140>2,\"significant\",\"nonsignificant\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,{"$f":"\"Block Design (\"&bd&\") \"&V142&\"  Visual Puzzles (\"&VP&\")\"","v":"Block Design (6) <  Visual Puzzles (7)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F124=\"\",F122=\"\"),\"\",W142&\" point \"&X142&\" difference\")","v":"1 point nonsignificant difference"},null,null,null,null,null,null,null,null,"BD/VP",{"$f":"IF(F122=F124,1,IF(F122>F124,2,3))","v":3},{"$f":"CHOOSE(U142,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F122-F124)","v":1},{"$f":"IF(W142>2,\"significant\",\"nonsignificant\")","v":"nonsignificant"}]
[]
[null,null,{"$f":"\"Information (\"&IN&\")  \"&V144&\"  Comprehension (\"&COMP&\")\"","v":"Information (9)  <  Comprehension ()"},null,null,null,null,null,null,null,{"$f":"IF(OR(F120=\"\",F119=\"\"),\"\",W144&\" point \"&X144&\" difference\")","v":""},null,null,null,null,null,null,null,null,"i/c",{"$f":"IF(F119=F120,1,IF(F119>F120,2,3))","v":3},{"$f":"CHOOSE(U144,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F120-F119)","v":{"$error":"#VALUE!"}},{"$f":"IF(W144>3,\"significant\",\"nonsignificant\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,{"$f":"\"Digit Span (\"&DS&\")  \"&V146&\"  Arithmetic (\"&AR&\")\"","v":"Digit Span (3)  >  Arithmetic (2)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F128=\"\",F130=\"\"),\"\",W146&\" point \"&X146&\" difference\")","v":""},null,null,null,null,null,null,null,null,"ds/a",{"$f":"IF(F128=F129,1,IF(F128>F129,2,3))","v":2},{"$f":"CHOOSE(U146,\"=\",\">\",\"<\")","v":">"},{"$f":"ABS(F128-F130)","v":{"$error":"#VALUE!"}},{"$f":"IF(W146>2,\"significant\",\"nonsignificant\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,{"$f":"\"Digit Span (\"&DS&\")  \"&V148&\"  Letter Number Sequence (\"&lns&\")\"","v":"Digit Span (3)  <  Letter Number Sequence ()"},null,null,null,null,null,null,null,{"$f":"IF(OR(F128=\"\",F129=\"\"),\"\",W148&\" point \"&X148&\" difference\")","v":"1 point nonsignificant difference"},null,null,null,null,null,null,null,null,"DS/lns",{"$f":"IF(F128=F130,1,IF(F128>F130,2,3))","v":3},{"$f":"CHOOSE(U148,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F128-F129)","v":1},{"$f":"IF(W148>2,\"significant\",\"nonsignificant\")","v":"nonsignificant"}]
[]
[null,null,{"$f":"\"Arithmetic (\"&AR&\")   \"&V150&\"  Letter Number Sequence (\"&lns&\")\"","v":"Arithmetic (2)   <  Letter Number Sequence ()"},null,null,null,null,null,null,null,{"$f":"IF(OR(F129=\"\",F130=\"\"),\"\",W150&\" point \"&X150&\" difference\")","v":""},null,null,null,null,null,null,null,null,"a/lns",{"$f":"IF(F129=F130,1,IF(F129>F130,2,3))","v":3},{"$f":"CHOOSE(U150,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F130-F129)","v":{"$error":"#VALUE!"}},{"$f":"IF(W150>2,\"significant\",\"nonsignificant\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(F129=\"\",F131=\"\"),\"\",#REF!&\" point \"&#REF!&\" difference\")","v":""}]
[null,null,{"$f":"\"Coding (\"&CD&\") \"&V152&\"  Symbol Search (\"&SS&\")\"","v":"Coding (8) >  Symbol Search (2)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F132=\"\",F133=\"\"),\"\",W152&\" point \"&X152&\" difference\")","v":"6 point significant difference"},null,null,null,null,null,null,null,null,"cd/ss",{"$f":"IF(F133=F132,1,IF(F133>F132,2,3))","v":2},{"$f":"CHOOSE(U152,\"=\",\">\",\"<\")","v":">"},{"$f":"ABS(F132-F133)","v":6},{"$f":"IF(W152>3,\"significant\",\"nonsignificant\")","v":"significant"}]
[]
[null,null,{"$f":"\"Coding (\"&CD&\") \"&V154&\"  Cancellation (\"&CA&\")\"","v":"Coding (8) <  Cancellation (11)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F132=\"\",F134=\"\"),\"\",W154&\" point \"&X154&\" difference\")","v":"9 point significant difference"},null,null,null,null,null,null,null,null,"cd/ca",{"$f":"IF(F133=F134,1,IF(F133>F134,2,3))","v":3},{"$f":"CHOOSE(U154,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F132-F134)","v":9},{"$f":"IF(W154>3,\"significant\",\"nonsignificant\")","v":"significant"}]
[]
[null,"Process comparisons (.05 level of significance)"]
[]
[null,null,{"$f":"\"Block Design (\"&F12&\")  \"&V158&\"  Block Design No Time Bonus (\"&F30&\")\"","v":"Block Design (6)  <  Block Design No Time Bonus (14)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F12=\"\",F30=\"\"),\"\",W158&\" point \"&X158&\" difference\")","v":"8 point significant difference"},null,null,null,null,null,null,null,null,"bd/bdnt",{"$f":"IF(F12=F30,1,IF(F12>F30,2,3))","v":3},{"$f":"CHOOSE(U158,\"=\",\">\",\"<\")","v":"<"},{"$f":"ABS(F12-F30)","v":8},{"$f":"IF(W158>3,\"significant\",\"nonsignificant\")","v":"significant"}]
[null,null,{"$f":"\"Digit Span Forward (\"&F31&\")  \"&V159&\"  Digit Span Backward (\"&F32&\")\"","v":"Digit Span Forward (18)  >  Digit Span Backward (17)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F31=\"\",F32=\"\"),\"\",W159&\" point \"&X159&\" difference\")","v":"1 point nonsignificant difference"},null,null,null,null,null,null,null,null,"dsf/dsb",{"$f":"IF(F31=F32,1,IF(F31>F32,2,3))","v":2},">",{"$f":"ABS(F31-F32)","v":1},{"$f":"IF(W159>4,\"significant\",\"nonsignificant\")","v":"nonsignificant"}]
[null,null,{"$f":"\"Digit Span Forward (\"&F31&\")  \"&V160&\"  Digit Span Sequencing (\"&F33&\")\"","v":"Digit Span Forward (18)  >  Digit Span Sequencing (13)"},null,null,null,null,null,null,null,{"$f":"IF(OR(F32=\"\",F33=\"\"),\"\",W160&\" point \"&X160&\" difference\")","v":"5 point significant difference"},null,null,null,null,null,null,null,null,"dsf/dss",{"$f":"IF(F31=F33,1,IF(F31>F33,2,3))","v":2},">",{"$f":"ABS(F31-F33)","v":5},{"$f":"IF(W160>4,\"significant\",\"nonsignificant\")","v":"significant"}]
[null,null,{"$f":"\"Digit Span Backward (\"&F32&\")  \"&V161&\"  Digit Span Sequencing (\"&F33&\")\"","v":"Digit Span Backward (17)  >  Digit Span Sequencing (13)"},null,null,null,null,null,null,null,{"$f":"IF(OR(G35=\"\",G36=\"\"),\"\",W161&\" point \"&X161&\" difference\")","v":"4 point nonsignificant difference"},null,null,null,null,null,null,null,null,"dsb/dss",{"$f":"IF(F32=F33,1,IF(F32>F33,2,3))","v":2},">",{"$f":"ABS(F32-F33)","v":4},{"$f":"IF(W161>4,\"significant\",\"nonsignificant\")","v":"nonsignificant"}]
[null,null,{"$f":"\"Longest Digit Span Forward (\"&G34&\")  \"&V162&\"  Longest Span Backward (\"&G35&\")\"","v":"Longest Digit Span Forward (9)  >  Longest Span Backward (8)"},null,null,null,null,null,null,null,{"$f":"IF(OR(G34=\"\",G35=\"\"),\"\",W162&\" point \"&X162&\" difference\")","v":"1 point nonsignificant difference"},null,null,null,null,null,null,null,null,"ldf/ldb",{"$f":"IF(G34=G35,1,IF(G34>G35,2,3))","v":2},">",{"$f":"ABS(G34-G35)","v":1},{"$f":"IF(W162>3,\"significant\",\"nonsignificant\")","v":"nonsignificant"}]
[null,null,{"$f":"\"Longest Digit Span Forward (\"&G34&\")  \"&V163&\"  Longest Span Sequencing (\"&G36&\")\"","v":"Longest Digit Span Forward (9)  >  Longest Span Sequencing (7)"},null,null,null,null,null,null,null,{"$f":"IF(OR(G34=\"\",G36=\"\"),\"\",W163&\" point \"&X163&\" difference\")","v":"2 point nonsignificant difference"},null,null,null,null,null,null,null,null,"ldf/lds",{"$f":"IF(G34=G36,1,IF(G34>G36,2,3))","v":2},">",{"$f":"ABS(G34-G36)","v":2},{"$f":"IF(W163>3,\"significant\",\"nonsignificant\")","v":"nonsignificant"}]
[null,null,{"$f":"\"Longest Digit Span Backward (\"&G35&\")  \"&V164&\"  Longest Span Sequencing (\"&G36&\")\"","v":"Longest Digit Span Backward (8)  >  Longest Span Sequencing (7)"},null,null,null,null,null,null,null,{"$f":"IF(OR(G35=\"\",G36=\"\"),\"\",W164&\" point \"&X164&\" difference\")","v":"1 point nonsignificant difference"},null,null,null,null,null,null,null,null,"ldb/lds",{"$f":"IF(G35=G36,1,IF(G35>G36,2,3))","v":2},">",{"$f":"ABS(G35-G36)","v":1},{"$f":"IF(W164>3,\"significant\",\"nonsignificant\")","v":"nonsignificant"}]
[]
[null,"Examine \"Ways to Sort\" Tab"]
[]
[null,"WAIS-IV Subtests and Proposed Broad and Narrow Abilities and Cultural and Linguistic Demands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Linguistic Demand",null,"Cultural Loading"]
[null,null,null,null,null,"Broad Abilities",null,"Narrow Abilities",null,null,null,"ss",null,null,null,null,null,null,null,{"$f":"F12","v":6}]
[null,null,null,"Verbal Comprehension"]
[null,null,null,"Similarities",null,"Gc",null,"Language Development",null,null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},null,"high",null,"high"]
[null,null,null,null,null,null,null,"Lexical Knowledge"]
[]
[null,null,null,"Vocabulary",null,"Gc",null,"Language Development",null,null,null,{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},null,"high",null,"high"]
[null,null,null,null,null,null,null,"Lexical Knowledge"]
[]
[null,null,null,"Information",null,"Gc",null,"General Information",null,null,null,{"$f":"IF(IN=\"\",\"\",IN)","v":9},null,"high",null,"high"]
[]
[null,null,null,"Comprehension",null,"Gc",null,"Language Development",null,null,null,{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},null,"high",null,"high"]
[null,null,null,null,null,null,null,"General Information"]
[]
[]
[null,null,null,"Perceptual Reasoning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L184)>8,3,0)","v":0},null,{"$f":"SIGN(L184)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L185)>10,3,0)","v":0},null,{"$f":"SIGN(L185)","v":0}]
[null,null,null,"Block Design",null,"Gv",null,"Spatial Relations",null,null,null,{"$f":"IF(bd=\"\",\"\",bd)","v":6},null,"moderate",null,"low",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(#REF!)>10,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Visualization"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(M70)>9,3,0)","v":0},null,{"$f":"SIGN(M70)","v":0}]
[null,null,null,"Matrix Reasoning",null,"Gf",null,"Induction",null,null,null,{"$f":"IF(MR=\"\",\"\",MR)","v":2},null,"low",null,"low",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(M71)>10,3,0)","v":0},null,{"$f":"SIGN(M71)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(M72)>10,3,0)","v":0},null,{"$f":"SIGN(M72)","v":0}]
[null,null,null,"Visual Puzzles",null,"Gv",null,"Vizualization",null,null,null,{"$f":"IF(VP=\"\",\"\",VP)","v":7},null,"moderate",null,"moderate",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L191)>8,3,0)","v":0},null,{"$f":"SIGN(L191)","v":1}]
[]
[null,null,null,"Figure Weights",null,"Gf",null,"Quantitative Reasoning",null,null,null,{"$f":"IF(FW=\"\",\"\",FW)","v":""},null,"moderate",null,"moderate",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L193)>8,3,0)","v":{"$error":"#VALUE!"}},null,{"$f":"SIGN(L193)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L189)>7,3,0)","v":0},null,{"$f":"SIGN(L189)","v":1}]
[null,null,null,"Picture Completion",null,"Gv",null,"Flexibility of Closure",null,null,null,{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},null,"low",null,"high",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(#REF!)>8,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Gc",null,"General Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I196-I198)>10.5,3,0)","v":0},null,{"$f":"SIGN(L196)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I196-I198)>10.5,3,0)","v":0},null,{"$f":"SIGN(L198)","v":0}]
[null,null,null,"Working Memory"]
[null,null,null,"Digit Span",null,"Gsm",null,"Memory Span",null,null,null,{"$f":"IF(DS=\"\",\"\",DS)","v":3},null,"moderate",null,"low",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J76-L77)>16.5,3,0)","v":0},null,{"$f":"SIGN(M76)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J76-L77)>16.5,3,0)","v":0},null,{"$f":"SIGN(M77)","v":0}]
[null,null,null,"Arithmetic",null,"Gq",null,"Math Achievement",null,null,null,{"$f":"IF(AR=\"\",\"\",AR)","v":2},null,"moderate",null,"moderate",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L78-#REF!)>16.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(M78)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Gf",null,"Quantitative Reasoning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L78-#REF!)>16.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I202-I203)>18,3,0)","v":0},null,{"$f":"SIGN(L202)","v":1}]
[null,null,null,"Letter-Number Sequence",null,"Gsm",null,"Working Memory",null,null,null,{"$f":"IF(lns=\"\",\"\",lns)","v":""},null,"high",null,"low",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I202-I203)>18,3,0)","v":0},null,{"$f":"SIGN(L203)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(#REF!-I207)>16.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,"Processing Speed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(#REF!-I207)>16.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(L207)","v":0}]
[null,null,null,"Symbols Search",null,"Gs",null,"Perceptual Speed",null,null,null,{"$f":"IF(SS=\"\",\"\",SS)","v":2},null,"moderate",null,"low",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J211-#REF!)>18.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(L211)","v":1}]
[null,null,null,null,null,null,null,"Rate of test taking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J211-#REF!)>18.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I208-#REF!)>16.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(L208)","v":1}]
[null,null,null,null,"Coding","Gs",null,"Rate of test taking",null,null,null,{"$f":"IF(CD=\"\",\"\",CD)","v":8},null,"moderate",null,"low",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I208-#REF!)>16.5,3,0)","v":{"$error":"#REF!"}},null,{"$f":"SIGN(M81)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Cancellation",null,"Gs",null,"Perceptual Speed",null,null,null,{"$f":"IF(CA=\"\",\"\",CA)","v":11},null,"low",null,"low",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L83-J84)>15.5,3,0)","v":0},null,{"$f":"SIGN(M83)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(L83-J84)>15.5,3,0)","v":0},null,0]
[null,null,null,"Adapted from Appendix A, pp. 445 – 453, The Intelligence Test Desk Reference (ITDR): Gf-Gc Cross-Battery Assessment (McGrew & Flanagan, 1998) and Table 8.3, p. 312, The Wechsler Intelligence Scales and Gf-Gc Theory (Flanagan, McGrew & Ortiz, 2000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J85-J86)>12.5,3,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J85-J86)>12.5,3,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J87-J88)>16.5,3,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(J87-J88)>16.5,3,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I219-I220)>15.5,3,0)","v":0},null,{"$f":"SIGN(L219)","v":0}]
[null,"GAI and Dumont-Willis Index-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I219-I220)>15.5,3,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(I221-I222)>15,3,0)","v":0},null,0]
[null,null,null,"GAI (VCI + PRI) =",null,{"$f":"(1.0660036*V222)+36.039785","v":73.349910999999992},null,{"$f":"IF(ABS(F222-F223)>=9,\"There is a significant difference between the two Indexes.\",\"There is no difference between the two Indexes.\")","v":"There is a significant difference between the two Indexes."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W21=3,W13)","v":20},{"$f":"U222+U223","v":35},null,null,null,null,null,null,{"$f":"IF(ABS(I221-I222)>15,3,0)","v":0},null,0]
[null,null,null,"DWI-2 (WMI + PSI) =",null,{"$f":"(1.597194*V224)+36.112344","v":60.070253999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W20=3,Y13)","v":15},null,null,null,null,null,null,null,{"$f":"IF(ABS(I223-I224)>17.5,3,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB43<2,\"\",AA13)","v":5},{"$f":"U224+U225","v":15},null,null,null,null,null,null,{"$f":"IF(ABS(I223-I224)>17.5,3,0)","v":0},null,0]
[null,"The General Ability Index (GAI) is computed from the sum of scaled scores for the VCI and PRI subtests.  Unlike the DWI-2 tables, the GAI tables are based directly on the WAIS-IV normative data.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE43<2,\"\",AC13)","v":10}]
[]
[null,"The Dumont-Willis DWI-2 Index is based on the sum of scaled scores for the Digit Span and Arithmetic (WMI) and Symbol Search and Coding (PSI) subtests.   It should be computed and considered only when the four WMI and PSI subtest scores are close to one another and substantially separate from the VCI and PRI subtests.  In those cases, the GAI and DWI-2 scores may be an efficient alternative means of summarizing the 10 WAIS-IV core subtests, but they must never be confused with normative WAIS-IV factor and IQ scores."]
[]
[]
[]
[null,null,null,"Oral / Verbal",null,null,null,"Pictures / Puzzles / Paper"]
[null,null,null,{"$f":"V235","v":9.125},null,null,null,null,{"$f":"V236","v":6}]
[null,null,null,"Similarities",null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},null,null,"Block Design",null,null,null,null,{"$f":"IF(bd=\"\",\"\",bd)","v":6},null,"Higher Level Thinking     DWI-1",null,null,null,{"$f":"SUM(F233:F237)+SUM(N233:N237)","v":35},{"$f":"COUNT(F233:F237)+COUNT(N233:N237)","v":6},{"$f":"T233/U233","v":5.833333333333333}]
[null,null,null,"Vocabulary",null,{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},null,null,"Matrix Reasoning",null,null,null,null,{"$f":"IF(MR=\"\",\"\",MR)","v":2},null,null,null,null,null,{"$f":"SUM(F241:F246)+SUM(N241:N246)","v":74},{"$f":"COUNT(F241:F246)+COUNT(N241:N246)","v":8},{"$f":"T234/U234","v":9.25}]
[null,null,null,"Information",null,{"$f":"IF(IN=\"\",\"\",IN)","v":9},null,null,"Visual Puzzles",null,null,null,null,{"$f":"IF(VP=\"\",\"\",VP)","v":7},null,null,null,null,null,{"$f":"SUM(F233:F237)+SUM(F241:F246)","v":73},{"$f":"COUNT(F233:F237)+COUNT(F241:F246)","v":8},{"$f":"T235/U235","v":9.125}]
[null,null,null,"Comprehension",null,{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},null,null,"Figure Weights",null,null,null,null,{"$f":"IF(FW=\"\",\"\",FW)","v":""},null,{"$f":"V233","v":5.833333333333333},null,null,null,{"$f":"SUM(N233:N237)+SUM(N241:N246)","v":36},{"$f":"COUNT(N233:N237)+COUNT(N241:N246)","v":6},{"$f":"T236/U236","v":6}]
[null,null,null,null,null,null,null,null,"Picture Completion",null,null,null,null,{"$f":"IF(PCm=\"\",\"\",PCm)","v":""}]
[]
[]
[]
[null,null,null,"Digit Span",null,{"$f":"IF(DS=\"\",\"\",DS)","v":3},null,null,"Symbol Search",null,null,null,null,{"$f":"IF(SS=\"\",\"\",SS)","v":2},null,"Processing   DWI-2"]
[null,null,null,"Arithmetic",null,{"$f":"IF(AR=\"\",\"\",AR)","v":2},null,null,"Coding",null,null,null,null,{"$f":"IF(CD=\"\",\"\",CD)","v":8}]
[null,null,null,"Letter-Number Sequence",null,{"$f":"IF(lns=\"\",\"\",lns)","v":""},null,null,"Cancellation",null,null,null,null,{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,null,null,"DS Forward",null,{"$f":"IF(dsf=\"\",\"\",dsf)","v":18}]
[null,null,null,"DS Backward",null,{"$f":"IF(dsb=\"\",\"\",dsb)","v":17},null,null,null,null,null,null,null,null,null,{"$f":"V234","v":9.25}]
[null,null,null,"DS Sequencing",null,{"$f":"IF(dssq=\"\",\"\",dssq)","v":13}]
[]
[]
[]
[null,null,null,"Substitution possibilities:"]
[null,null,null,{"$f":"\"VCI = \"&vci","v":"VCI = 116"}]
[null,null,null,"CO,VC,IN",0.96,null,{"$f":"IF(COMP=\"\",\"\",IF(VOC=\"\",\"\",IF(IN=\"\",\"\",1.86*(COMP+VOC+IN)+44.3)))","v":""}]
[null,null,null,"SI,CO,IN",0.95,null,{"$f":"IF(COMP=\"\",\"\",IF(sim=\"\",\"\",IF(IN=\"\",\"\",1.89*(COMP+sim+IN)+43.4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Block Design",{"$f":"bd","v":6}]
[null,null,null,"SI,VC,CO",0.96,null,{"$f":"IF(COMP=\"\",\"\",IF(VOC=\"\",\"\",IF(sim=\"\",\"\",1.84*(COMP+VOC+sim)+44.8)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Similarities",{"$f":"sim","v":2}]
[null,null,null,{"$f":"\"PRI = \"&poi","v":"PRI = 109"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digit Span",{"$f":"DS","v":3}]
[null,null,null,"FW,MR,VP",0.95,null,{"$f":"IF(FW=\"\",\"\",IF(MR=\"\",\"\",IF(VP=\"\",\"\",1.98*(FW+MR+VP)+40.5)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Digit Span-Forward",{"$f":"dsf","v":18}]
[null,null,null,"BD,FW,VP",0.95,null,{"$f":"IF(FW=\"\",\"\",IF(bd=\"\",\"\",IF(VP=\"\",\"\",1.95*(FW+bd+VP)+41.4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Digit Span-Backward",{"$f":"dsb","v":17}]
[null,null,null,"BD,MR,FW",0.95,null,{"$f":"IF(FW=\"\",\"\",IF(MR=\"\",\"\",IF(bd=\"\",\"\",1.99*(FW+MR+bd)+40.4)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Digit Span-Sequencing",{"$f":"dssq","v":13}]
[null,null,null,"PC,MR,VP",0.94,null,{"$f":"IF(PCm=\"\",\"\",IF(MR=\"\",\"\",IF(VP=\"\",\"\",2.07*(PCm+MR+VP)+38)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrix Reasoning",{"$f":"MR","v":2}]
[null,null,null,"BD,PC,VP",0.94,null,{"$f":"IF(bd=\"\",\"\",IF(PCm=\"\",\"\",IF(VP=\"\",\"\",2*(bd+PCm+VP)+39.9)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Vocabulary",{"$f":"VOC","v":9}]
[null,null,null,"BD,MR,PC",0.93,null,{"$f":"IF(bd=\"\",\"\",IF(PCm=\"\",\"\",IF(MR=\"\",\"\",2.06*(bd+PCm+MR)+38.2)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Arithmetic",{"$f":"AR","v":2}]
[null,null,null,{"$f":"\"WMI = \"&wmi","v":"WMI = 122"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Symbol Search",{"$f":"SS","v":2}]
[null,null,null,"LN,AR",0.7,null,{"$f":"IF(lns=\"\",\"\",IF(AR=\"\",\"\",2.83*(lns+AR)+43.4))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Visual Puzzles",{"$f":"VP","v":7}]
[null,null,null,"DS,LN",0.73,null,{"$f":"IF(lns=\"\",\"\",IF(DS=\"\",\"\",2.72*(lns+DS)+45.6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Information",{"$f":"IN","v":9}]
[null,null,null,{"$f":"\"PSI = \"&psi","v":"PSI = 86"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coding",{"$f":"CD","v":8}]
[null,null,null,"CA,CD",0.65,null,{"$f":"IF(CA=\"\",\"\",IF(CD=\"\",\"\",2.97*(CA+CD)+40.7))","v":97.13000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,"Letter-Number Sequence",{"$f":"lns","v":0}]
[null,null,null,"SS,CA",0.64,null,{"$f":"IF(CA=\"\",\"\",IF(SS=\"\",\"\",2.93*(CA+SS)+41.5))","v":79.59},null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure Weights",{"$f":"FW","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comprehension",{"$f":"COMP","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cancellation",{"$f":"CA","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Picture Completion",{"$f":"PCm","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$I$221","v":0},{"$f":"$I$222","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Aud. Mem.","Rep.",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE($AW$332:$AX$332)","v":0},{"$f":"AVERAGE($AW$332:$AX$332)","v":0}]
[]
[]
[]
["SS",40,62,68,71,73,75,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,126,127,128,129,130,{"$f":"BH338+1","v":131},{"$f":"BI338+1","v":132},133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,{"$f":"CI338+1","v":158},159,160,161]
["%ile",1,1,2,3,4,5,6,7,8,9,10,12,13,14,16,18,19,21,23,25,27,30,32,34,37,39,42,45,47,50,53,55,58,61,63,66,68,70,73,75,77,79,81,82,84,86,87,88,90,91,92,93,94,95,96,96,97,98,98,98,98,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99]
[]
[]
[null,null,"vp",1,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,31,34]
[null,null,"%",50,34,31,28,24,22,18,16,14,12,10,8,7,6,5,4,3,2,1,0.5]
[null,null,"SS",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[null,null,"%",0.1,0.4,1,2,5,9,16,25,37,50,63,75,84,91,95,98,99,99.599999999999,99.9]
[]
[]
[null,null,"%",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,4,4,5,6,7,8,9,10,12,12,16,18,19,21,25,27,30,34,37,40,42,45,50,53,55,58,63,66,68,70,73,77,79,81,82,84,87,66,90,91,93,94,95,96,97,97,98,98,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99]
[null,null,"Pss",9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90]
[null,null,"PRI",45,46,48,49,51,52,54,55,57,58,60,61,63,64,65,67,68,69,70,71,72,73,74,75,77,78,80,81,82,84,85,86,87,88,90,91,92,93,95,96,98,100,101,102,104,105,106,108,109,111,112,114,115,117,118,120,121,123,124,126,128,129,130,131,132,133,135,136,138,139,141,142,143,145,146,147,149,150,151,152,154,155]
[null,null,"%",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,3,3,4,5,5,6,7,9,10,12,14,16,18,19,21,25,27,30,32,36,40,45,50,53,55,61,63,66,70,73,77,79,82,84,87,88,91,92,94,95,96,97,97,98,98,98,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99]
[null,null,"Fss",15,16,18,19,20,22,23,24,26,27,28,30,31,33,34,35,37,38,39,40,42,43,44,45,46,48,49,50,51,53,55,57,59,61,62,64,65,67,68,70,71,73,75,76,77,79,81,82,84,85,87,88,90,92,93,94,95,97,98,99,100,102,104,106,107,108,110,111,112,113,115,116,117,119,120,121,122,123,124,126,127,128,130,131,133,134,135,137,138,140,141,142,143,144,146,147,148,149,150,151,153,154,156,158,159,161,163,164,166,167,168,170,171,173,174,176,177,179,181,182,184]
[null,null,"FIQ",40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,146,147,149,150,151,152,153,154,155,156,157,158,159,160]
[null,null,"%",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,3,3,4,4,5,5,6,7,8,9,10,12,13,14,16,18,19,21,23,25,27,30,32,34,37,40,42,45,47,50,53,55,58,61,63,66,68,70,73,75,77,79,81,82,84,86,87,88,90,91,92,93,94,95,95,96,96,97,97,98,98,98,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99]
[null,null,null,0,70,80,90,111,120,130]
[null,null,null,"ExtLow","BL","LA","AVE","HAVE","SUP","VSUP"]
[null,null,"Scatter",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,"v6 scat%",100,100,98.4,90.3,72.8,50.4,31.3,17.2,7.9,3.7,1.8,0.6,0.2,0,0,0,0,0,0]
[null,null,"v7 scat%",100,100,99.3,95,82.4,61.7,41.4,24.4,11.5,5.0999999999999996,1.8,0.9,0.3,0.2,0.2,0,0,0,0]
[null,null,"p5 Scat%",100,99.9,98.4,90,74.900000000000006,56.5,37.5,23,12.3,5.4,2.2999999999999998,1.1000000000000001,0.4,6,5,3.6,2.6,1.3,0.7]
[null,null,"p7 Scat%",100,100,99.7,96.8,87.3,70.099999999999994,50.7,32.4,18.2,8.9,4.2,1.9,0.8,0.3,0.2,0.2,0,0,0]
[null,null,"IQ 11 scat Scat%",100,100,99.9,99.6,96.7,87.2,71.2,50.9,32.200000000000003,17.399999999999999,8.1,3.1,1.2,0.3,0.1,0,0,0,0,0]
[null,null,"IQ 13 scat Scat%",100,100,100,99.8,98.5,92.3,79,58,37.700000000000003,21.5,10.199999999999999,4.2,1.9,0.8,0.4,0.3,0.2,0.1,0,0]
[null,null,"IQ 14 scat Scat%",100,100,100,100,99,94.6,82.2,63.8,42.5,23.9,11.5,5,2.4,0.8,0.4,0.3,0.2,0.1,0.1,0]
[]
[null,null,"vp diff",100,97,88,81,73,66,60,54,48,43,37,32,28,24,20,19,16,13,11,9,7,6,5,4,3,3,2,2,1,1,1,1,1,1,0.4,0.3,0.3,0.3,0.2,0.2,0.1]
[null,null,"p7 Scat%",100,100,99.7,96.8,87.3,70.099999999999994,50.7,32.4,18.2,8.9,4.2,1.9,0.8,0.3,0.2,0.2,0,0,0]
[null,null,"p7 Scat%",100,100,99.7,96.8,87.3,70.099999999999994,50.7,32.4,18.2,8.9,4.2,1.9,0.8,0.3,0.2,0.2,0,0,0]
[]
[null,null,"Pairs",1,2,5,10,25,50,null,null,null,null,"free rc",1,2,5,10,25,50,null,null,null,null,"copy",1,2,5,10,25,50]
[null,null,16,0,4,7,9,13,15,null,{"$f":"IF($O$12=\"\",\"\",LOOKUP($O$12,D371:I371,$D$370:$I$370))","v":""},{"$f":"LOOKUP(N6,C371:C383,K371:K383)","v":{"$error":"#N/A"}},null,16,0,5,6,6,7,8,null,{"$f":"IF($O$13=\"\",\"\",LOOKUP($O$13,O371:T371,$D$370:$I$370))","v":""},{"$f":"LOOKUP(N6,N371:N383,V371:V383)","v":{"$error":"#N/A"}},null,16,0,63,81,92,109,124,null,{"$f":"IF($O$14=\"\",\"\",LOOKUP($O$14,Z371:AE371,$D$370:$I$370))","v":""},{"$f":"LOOKUP(N6,Y371:Y383,AG371:AG383)","v":{"$error":"#N/A"}}]
[null,null,18,0,4,6,9,12,15,null,"",null,null,18,0,4,5,6,7,8,null,"",null,null,18,0,49,77,102,116,131,null,""]
[null,null,20,0,2,5,7,11,14,null,"",null,null,20,0,4,5,6,7,8,null,"",null,null,20,0,60,82,93,110,130,null,""]
[null,null,25,0,5,6,9,11,14,null,"",null,null,25,0,5,5,6,7,8,null,"",null,null,25,0,77,84,92,111,129,null,""]
[null,null,30,0,4,7,8,10,14,null,"",null,null,30,0,5,5,6,7,8,null,"",null,null,30,0,66,82,93,108,123,null,""]
[null,null,35,0,4,5,6,10,13,null,"",null,null,35,0,5,5,6,6,7,null,"",null,null,35,0,53,75,90,106,124,null,""]
[null,null,45,0,2,4,6,9,12,null,"",null,null,45,0,4,5,5,6,7,null,"",null,null,45,0,43,73,82,99,114,null,""]
[null,null,55,0,2,3,4,8,10,null,"",null,null,55,0,3,4,5,6,7,null,"",null,null,55,0,27,53,65,83,102,null,""]
[null,null,65,0,2,3,4,6,8,null,"",null,null,65,0,2,4,5,6,7,null,"",null,null,65,0,19,39,59,73,93,null,""]
[null,null,70,0,1,3,4,6,8,null,"",null,null,70,0,2,4,5,6,7,null,"",null,null,70,0,45,53,60,74,90,null,""]
[null,null,75,0,2,3,4,6,9,null,"",null,null,75,0,2,4,4,5,6,null,"",null,null,75,0,35,49,55,68,83,null,""]
[null,null,80,0,0,1,2,5,8,null,"",null,null,80,0,2,3,4,5,6,null,"",null,null,80,0,23,32,45,59,77,null,""]
[null,null,85,0,0,1,2,4,8,null,"",null,null,85,0,1,3,4,5,6,null,"",null,null,85,0,20,25,37,45,62,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1,70,80,90,110,120,130]
[null,null,null,"Extremely Low","Borderline","Low Average","Average","High Average","Superior","Very Superior"]
[null,null,"vsc",46,55,67,75,86,95,106,116,127,135,147,155]
[null,null,"vconf-",-4,-4,-5,-5,-6,-6,-7,-7,-8,-8,-9,-9]
[null,null,"vconf+",9,8,8,7,7,6,6,5,5,4,4,3]
[null,null,"psc",45,47,55,63,72,79,88,96,105,114,123,129,140,146,155]
[null,null,"pconf-",-3,-4,-4,-5,-5,-6,-6,-7,-7,-8,-8,-9,-9,-9,-9]
[null,null,"pconf+",10,10,9,9,8,8,7,7,6,6,5,5,4,4,3]
[null,null,"fssc",40,48,53,82,86,112,115,119,148,153]
[null,null,"fsconf-",-3,-3,-4,-4,-5,-5,-5,-6,-6,-7]
[null,null,"fsconf+",7,6,6,5,5,5,4,4,3,3]
[null,null,"psi",46,49,56,60,64,68,73,75,83,85,91,94,100,102,110,113,119,122,128,131,137,140,145,150]
[null,null,"psi",-3,-3,-4,-4,-5,-5,-6,-6,-7,-7,-8,-8,-9,-9,-10,-10,-11,-11,-12,-12,-13,-13,-14,-14]
[null,null,"psi",15,14,14,13,13,12,13,11,11,10,10,9,9,8,8,7,7,6,6,5,5,4,4,3]
[null,null,"GLC",45,50,54,63,67,75,78,86,91,100,103,113,116,125,128,138,141,147,152]
[null,null,"GLC",-3,-4,-4,-5,-5,-6,-6,-7,-7,-8,-8,-9,-9,-10,-10,-11,-11,-12,-12]
[null,null,"GLC",12,12,11,11,10,10,9,9,8,8,7,7,6,6,5,5,4,4,3]
[null,null,"wmi",50,55,63,73,80,88,97,106,113,124,130,139,147]
[null,null,"wmi-",-4,-4,-5,-5,-6,-6,-7,-7,-8,-8,-9,-9,-10]
[null,null,"wmi+",10,9,9,8,8,7,7,6,6,5,5,4,4]
[null,null,"pssc",54,57,63,71,73,79,81,88,96,99,106,114,122,131,140,148]
[null,null,"psconf-",-3,-4,-5,-5,-6,-6,-7,-8,-8,-9,-10,-11,-12,-13,-14,-15]
[null,null,"psconf+",14,14,13,12,12,11,11,10,9,9,8,7,6,5,4,3]

{"sheet":"Shares Abilities","index":2,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,1,36,17],[3,3,3,6],[3,7,3,11],[3,12,3,14],[3,15,3,17],[8,1,8,17],[19,1,19,17]]}
[]
[null,"      The following uses separate Verbal and Perceptual values unless you specify the Full Scale by typing \"F\" here:"]
[]
[null,null,null,"Verbal",null,null,null,"Perceptual Reasoning",null,null,null,null,"Working Memory",null,null,"Processing Speed"]
[null,null,null,"S","V","I","C","BD","MR","VP","FW","PCmp","Ds","A","Ln","SS","Cd","CA"]
[null,null,"Deviation from mean:",{"$f":"IF(O2=\"F\",'WAIS-IV'!P117,'WAIS-IV'!K117)","v":-4.666666666666667},{"$f":"IF(O2=\"F\",'WAIS-IV'!P118,'WAIS-IV'!K118)","v":2.333333333333333},{"$f":"IF(O2=\"F\",'WAIS-IV'!P119,'WAIS-IV'!K119)","v":2.333333333333333},{"$f":"IF(O2=\"F\",'WAIS-IV'!P120,'WAIS-IV'!K120)","v":""},{"$f":"IF(O2=\"F\",'WAIS-IV'!P122,'WAIS-IV'!K122)","v":1},{"$f":"IF(O2=\"F\",'WAIS-IV'!P123,'WAIS-IV'!K123)","v":-3},{"$f":"IF(O2=\"F\",'WAIS-IV'!P124,'WAIS-IV'!K124)","v":2},{"$f":"IF(O2=\"F\",'WAIS-IV'!P125,'WAIS-IV'!K125)","v":""},{"$f":"IF(O2=\"F\",'WAIS-IV'!P126,'WAIS-IV'!K126)","v":""},{"$f":"'WAIS-IV'!P128","v":-2.5454545454545459},{"$f":"'WAIS-IV'!P129","v":-3.5454545454545459},{"$f":"'WAIS-IV'!P130","v":""},{"$f":"'WAIS-IV'!P132","v":-3.5454545454545459},{"$f":"'WAIS-IV'!P133","v":2.4545454545454541},{"$f":"'WAIS-IV'!P134","v":5.4545454545454541}]
[null,null,"Strength or Weakness:",{"$f":"IF(O2=\"F\",'WAIS-IV'!Q117,'WAIS-IV'!L117)","v":"w"},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q118,'WAIS-IV'!L118)","v":"s"},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q120,'WAIS-IV'!L120)","v":""},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q119,'WAIS-IV'!L119)","v":"s"},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q122,'WAIS-IV'!L122)","v":""},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q123,'WAIS-IV'!L123)","v":"w"},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q124,'WAIS-IV'!L124)","v":"s"},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q125,'WAIS-IV'!L125)","v":""},{"$f":"IF(O2=\"F\",'WAIS-IV'!Q126,'WAIS-IV'!L126)","v":""},{"$f":"'WAIS-IV'!Q128","v":"w"},{"$f":"'WAIS-IV'!Q129","v":"w"},{"$f":"'WAIS-IV'!Q130","v":""},{"$f":"'WAIS-IV'!Q132","v":""},{"$f":"'WAIS-IV'!Q133","v":""},{"$f":"'WAIS-IV'!Q134","v":"s"}]
[null,null,"Positive or Negative:",{"$f":"IF(D6=\"\",\"\",IF(SIGN(D6)=1,\"+\",IF(SIGN(D6)=-1,\"-\",\"\")))","v":"-"},"+",{"$f":"IF(F6=\"\",\"\",IF(SIGN(F6)=1,\"+\",IF(SIGN(F6)=-1,\"-\",\"\")))","v":"+"},"",{"$f":"IF(H6=\"\",\"\",IF(SIGN(H6)=1,\"+\",IF(SIGN(H6)=-1,\"-\",\"\")))","v":"+"},{"$f":"IF(I6=\"\",\"\",IF(SIGN(I6)=1,\"+\",IF(SIGN(I6)=-1,\"-\",\"\")))","v":"-"},{"$f":"IF(J6=\"\",\"\",IF(SIGN(J6)=1,\"+\",IF(SIGN(J6)=-1,\"-\",\"\")))","v":"+"},{"$f":"IF(K6=\"\",\"\",IF(SIGN(K6)=1,\"+\",IF(SIGN(K6)=-1,\"-\",\"\")))","v":""},"","-",{"$f":"IF(N6=\"\",\"\",IF(SIGN(N6)=1,\"+\",IF(SIGN(N6)=-1,\"-\",\"\")))","v":"-"},"",{"$f":"IF(P6=\"\",\"\",IF(SIGN(P6)=1,\"+\",IF(SIGN(P6)=-1,\"-\",\"\")))","v":"-"},"+",{"$f":"IF(R6=\"\",\"\",IF(SIGN(R6)=1,\"+\",IF(SIGN(R6)=-1,\"-\",\"\")))","v":"+"}]
[null,"INPUT"]
[null,"Attention-Concentration",null,null,null,null,null,null,null,null,null,{"$f":"IF(L7=\"\",L8,L7)","v":""},"w","w","","-","+","s"]
[null,"Auditory-Vocal Channel",null,{"$f":"IF(D7=\"\",D8,D7)","v":"w"},{"$f":"IF(E7=\"\",E8,E7)","v":"s"},{"$f":"IF(F7=\"\",F8,F7)","v":"+"},{"$f":"IF(G7=\"\",G8,G7)","v":"s"},null,null,null,null,null,{"$f":"M10","v":"w"},{"$f":"N10","v":"w"},{"$f":"O10","v":""}]
[null,"Complex Verbal Directions",null,null,null,null,null,{"$f":"IF(H7=\"\",H8,H7)","v":"+"},{"$f":"IF(I7=\"\",I8,I7)","v":"w"},null,{"$f":"IF(K7=\"\",K8,K7)","v":""},null,null,null,null,{"$f":"P10","v":"-"},{"$f":"Q10","v":"+"},{"$f":"R10","v":"s"}]
[null,"Essential from Non Essential",null,{"$f":"D11","v":"w"},null,null,null,null,{"$f":"I12","v":"w"},null,null,{"$f":"L10","v":""},null,null,null,{"$f":"P12","v":"-"},null,{"$f":"R12","v":"s"}]
[null,"Encoding Information for Processing",null,null,null,null,null,null,null,null,null,null,{"$f":"M11","v":"w"},{"$f":"N11","v":"w"},{"$f":"O11","v":""},{"$f":"P13","v":"-"},{"$f":"Q12","v":"+"},{"$f":"R12","v":"s"}]
[null,"Understanding Long Questions",null,null,null,null,{"$f":"G11","v":"s"},null,null,null,null,null,null,{"$f":"N14","v":"w"}]
[null,"Understanding Words",null,{"$f":"D13","v":"w"},{"$f":"IF(E7=\"\",E8,E7)","v":"s"},null,null,null,null,null,null,null,{"$f":"M14","v":"w"},null,{"$f":"O14","v":""}]
[null,"Visual Motor Channel",null,null,null,null,null,{"$f":"H12","v":"+"},null,null,null,{"$f":"L13","v":""},null,null,null,{"$f":"P14","v":"-"},{"$f":"Q14","v":"+"},{"$f":"R14","v":"s"}]
[null,"Visual Perception-Abstr. Stim.",null,null,null,null,null,{"$f":"H17","v":"+"},{"$f":"I13","v":"w"},{"$f":"IF(J7=\"\",J8,J7)","v":"s"},null,null,null,null,null,{"$f":"P17","v":"-"},{"$f":"Q17","v":"+"},{"$f":"R17","v":"s"}]
[null,"Visual Perception-Cmpl. Mean. Stim.",null,null,null,null,null,null,null,null,{"$f":"K12","v":""},{"$f":"L17","v":""}]
[null,"INTEGRATION/STORAGE"]
[null,"Achievement",null,{"$f":"D16","v":"w"},{"$f":"E16","v":"s"},{"$f":"F11","v":"+"},{"$f":"G15","v":"s"},null,null,null,null,null,null,{"$f":"N15","v":"w"}]
[null,"Acquired Knowledge",null,null,{"$f":"E21","v":"s"},{"$f":"F21","v":"+"},null,null,null,null,null,null,null,{"$f":"N21","v":"w"}]
[null,"Concept Formation",null,{"$f":"D21","v":"w"},{"$f":"E22","v":"s"},null,null,{"$f":"H18","v":"+"}]
[null,"Crystallized Intelligence",null,{"$f":"D23","v":"w"},{"$f":"E23","v":"s"},{"$f":"F22","v":"+"},{"$f":"G21","v":"s"}]
[null,"Culture Loaded Knowledge",null,null,null,{"$f":"F24","v":"+"},{"$f":"G24","v":"s"}]
[null,"Facility with Numbers",null,null,null,null,null,null,null,null,{"$f":"K19","v":""},null,{"$f":"M16","v":"w"},{"$f":"N22","v":"w"},{"$f":"O16","v":""},null,{"$f":"Q18","v":"+"}]
[null,"Fluid Intelligence",null,{"$f":"D24","v":"w"},null,null,null,null,{"$f":"I18","v":"w"},null,{"$f":"K26","v":""},null,null,{"$f":"N26","v":"w"}]
[null,"Fund of Information",null,null,{"$f":"E24","v":"s"},{"$f":"F25","v":"+"}]
[null,"Memory",null,null,null,{"$f":"F28","v":"+"},null,null,null,null,null,null,{"$f":"M16","v":"w"},{"$f":"N27","v":"w"},{"$f":"O26","v":""}]
[null,"Nonverbal Reasoning",null,null,null,null,null,null,{"$f":"I27","v":"w"},null,{"$f":"K27","v":""}]
[null,"Planning Ability",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P18","v":"-"},null,{"$f":"R18","v":"s"}]
[null,"Sequencing",null,null,null,null,null,null,null,null,null,null,{"$f":"M29","v":"w"},{"$f":"N29","v":"w"},{"$f":"O29","v":""},null,{"$f":"Q26","v":"+"}]
[null,"Verbal Reasoning",null,{"$f":"D27","v":"w"},null,null,{"$f":"G25","v":"s"}]
[null,"Visual Memory",null,null,null,null,null,null,null,null,null,{"$f":"L19","v":""},null,null,null,null,{"$f":"Q32","v":"+"}]
[null,"Visual Processing",null,null,null,null,null,{"$f":"H23","v":"+"},{"$f":"I30","v":"w"},{"$f":"J18","v":"s"},{"$f":"K30","v":""},{"$f":"L34","v":""},null,null,null,null,null,{"$f":"R31","v":"s"}]
[null,"Visual Sequencing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q34","v":"+"},{"$f":"R35","v":"s"}]
[null,"OUTPUT"]
[null,"Much Verbal Expression",null,null,{"$f":"E28","v":"s"},null,{"$f":"G33","v":"s"}]
[null,"Simple Verbal expression",null,null,null,{"$f":"F29","v":"+"},null,null,null,null,null,null,{"$f":"M32","v":"w"},{"$f":"N32","v":"w"},{"$f":"O32","v":""}]
[null,"Visual Organization",null,null,null,null,null,null,{"$f":"I35","v":"w"},{"$f":"J35","v":"s"},null,{"$f":"L35","v":""}]
[null,"Visual-Motor Coordination",null,null,null,null,null,{"$f":"H35","v":"+"},null,null,null,null,null,null,null,{"$f":"P31","v":"-"},{"$f":"Q36","v":"+"},{"$f":"R36","v":"s"}]

{"sheet":"GF-GC","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[29,1,29,4],[34,1,34,4],[1,1,1,4],[3,1,3,4],[10,1,10,4],[16,1,16,4],[23,1,23,4]]}
[]
[null,"WAIS-IV Gf-Gc Classifications?"]
[]
[null,"CRYSTALLIZED INTELLIGENCE (Gc) is the breadth and depth of a person’s acquired knowledge of a culture and the effective application of this knowledge. "]
[null,null,"Subtest","Score","Narrow Ability"]
[null,null,"Similarities",{"$f":"IF(sim=\"\",\"\",sim)","v":2},"(Language Development)"]
[null,null,"Information",{"$f":"IF(IN=\"\",\"\",IN)","v":9},"(General (Verbal) Information)"]
[null,null,"Vocabulary",{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},"(Lexical Knowledge)"]
[null,null,"Comprehension",{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},"(Language Development)"]
[]
[null,"VISUAL PROCESSING (Gv) is the ability to generate, perceive, analyze, synthesize, manipulate, transform, and think with visual patterns and stimuli. "]
[null,null,"Subtest","Score","Narrow Ability"]
[null,null,"Block Design",{"$f":"IF(bd=\"\",\"\",bd)","v":6},"(Spatial Relations)"]
[null,null,"Visual Puzzles",{"$f":"IF(VP=\"\",\"\",VP)","v":7},"(Visualization)"]
[null,null,"Picture Completion",{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},"(Flexibility of Closure, General (Verbal) Information)"]
[]
[null,"SHORT-TERM MEMORY (Gsm) is the ability to apprehend and hold information in immediate awareness and then use it within a few seconds."]
[null,null,"Subtest","Score","Narrow Ability"]
[null,null,"Digit Span Forward ",{"$f":"IF(dsf=\"\",\"\",dsf)","v":18},"(Memory Span)"]
[null,null,"Digit Span Backward",{"$f":"IF(dsb=\"\",\"\",dsb)","v":17},"(Working Memory)"]
[null,null,"Digit Span Sequencing",{"$f":"IF(dssq=\"\",\"\",dssq)","v":13},"(Working Memory)"]
[null,null,"Letter-Number Sequencing",{"$f":"IF(lns=\"\",\"\",lns)","v":""},"(Working Memory)"]
[]
[null,"PROCESSING SPEED (Gs) is the ability to perform cognitive tasks fluently and automatically, especially when under pressure to maintain focused attention and concentration."]
[null,null,"Subtest","Score","Narrow Ability"]
[null,null,"Symbol Search",{"$f":"IF(SS=\"\",\"\",SS)","v":2},"(Perceptual Speed)"]
[null,null,"Coding",{"$f":"IF(CD=\"\",\"\",CD)","v":8},"(Rate-of-Test-Taking)"]
[null,null,"Cancellation",{"$f":"IF(CA=\"\",\"\",CA)","v":11},"(Perceptual Speed)"]
[]
[null,"FLUID INTELLIGENCE (Gf) is the ability to use and engage in various mental operations when faced with a relatively novel task that cannot be performed automatically. "]
[null,null,"Subtest","Score","Narrow Ability"]
[null,null,"Matrix Reasoning",{"$f":"IF(MR=\"\",\"\",MR)","v":2},"(Inductive Reasoning)"]
[null,null,"Figure Weights",{"$f":"IF(FW=\"\",\"\",FW)","v":""},"(Quantitative Reasoning)"]
[]
[null,"QUANTITATIVE KNOWLEDGE (Gq) represents an individual’s store of acquired quantitative declarative and procedural knowledge.  It involves the ability to use quantitative information and manipulate numeric symbols. "]
[null,null,"Subtest","Score","Narrow Ability"]
[null,null,"Arithmetic",{"$f":"IF(AR=\"\",\"\",AR)","v":2},"(Math Achievement)"]

{"sheet":"Ways to Sort","index":4,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[12,12,12,17],[13,8,13,9],[13,10,13,11],[12,2,12,10],[0,0,0,19],[1,0,4,0],[4,3,4,17],[6,0,8,0],[8,2,8,9],[8,11,8,18],[9,8,9,9],[9,10,9,11],[10,0,12,0],[14,0,16,0],[16,2,16,5],[16,7,16,11],[16,13,16,15],[16,17,16,19],[18,0,37,0],[18,8,18,9],[18,10,18,11],[21,2,21,3],[21,5,21,6],[21,8,21,10],[26,8,26,9],[29,2,29,5],[29,7,29,8],[35,5,35,6],[35,8,35,9],[35,11,35,12],[33,1,33,3],[33,4,33,5],[17,8,17,9],[17,10,17,11],[37,2,37,12],[21,12,21,13],[21,15,21,17],[25,2,25,3],[25,5,25,6],[25,8,25,10],[25,12,25,13],[25,15,25,19],[35,2,35,3],[29,10,29,11],[29,12,29,15],[33,6,33,13],[34,8,34,9],[34,10,34,11]]}
["Possible Ways of Sorting Out WAIS-IV Scores"]
["FSIQ"]
[null,null,null,"SI","VC","IN","(CO)","BD","MR","VP ","(FW)","(PCm)","DS","AR","(LN)","SS","CD","(CA)"]
[null,null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(IN=\"\",\"\",IN)","v":9},{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},{"$f":"IF(bd=\"\",\"\",bd)","v":6},{"$f":"IF(MR=\"\",\"\",MR)","v":2},{"$f":"IF(VP=\"\",\"\",VP)","v":7},{"$f":"IF(FW=\"\",\"\",FW)","v":""},{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},{"$f":"IF(DS=\"\",\"\",DS)","v":3},{"$f":"IF(AR=\"\",\"\",AR)","v":2},{"$f":"IF(lns=\"\",\"\",lns)","v":""},{"$f":"IF(SS=\"\",\"\",SS)","v":2},{"$f":"IF(CD=\"\",\"\",CD)","v":8},{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,null,null,"Full Scale Intelligence Quotient"]
[]
["MAJOR SCALES",null,"SI","VC","IN","(CO)","DS","AR","LN","(PCm)",null,"(PCm)","BD","MR","VP","(FW)","SS","CD","(CA)"]
[null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(IN=\"\",\"\",IN)","v":9},{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},{"$f":"IF(DS=\"\",\"\",DS)","v":3},{"$f":"IF(AR=\"\",\"\",AR)","v":2},{"$f":"IF(lns=\"\",\"\",lns)","v":""},{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},null,{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},{"$f":"IF(bd=\"\",\"\",bd)","v":6},{"$f":"IF(MR=\"\",\"\",MR)","v":2},{"$f":"IF(VP=\"\",\"\",VP)","v":7},{"$f":"IF(FW=\"\",\"\",FW)","v":""},{"$f":"IF(SS=\"\",\"\",SS)","v":2},{"$f":"IF(CD=\"\",\"\",CD)","v":8},{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,null,"Verbal",null,null,null,null,null,null,null,null,"Nonverbal/Perceptual"]
[]
["GAI / DWI SCORES",null,"SI","VC","IN","(CO)","BD","MR","VP","(FW)","(PCm)",null,"DS","AR","(LN)","SS","CD","(CA)"]
[null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(IN=\"\",\"\",IN)","v":9},{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},{"$f":"IF(CA=\"\",\"\",CA)","v":11},{"$f":"IF(MR=\"\",\"\",MR)","v":2},{"$f":"IF(VP=\"\",\"\",VP)","v":7},{"$f":"IF(FW=\"\",\"\",FW)","v":""},{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},null,{"$f":"IF(DS=\"\",\"\",DS)","v":3},{"$f":"IF(AR=\"\",\"\",AR)","v":2},{"$f":"IF(lns=\"\",\"\",lns)","v":""},{"$f":"IF(SS=\"\",\"\",SS)","v":2},{"$f":"IF(CD=\"\",\"\",CD)","v":8},{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,null,"GAI: Emphasizing verbal and nonverbal thinking",null,null,null,null,null,null,null,null,null,"DWI-2: Emphasizing short-term memory and processing speed"]
[]
["INDICES",null,"SI","VC","IN","(CO)",null,"BD","MR","VP","(FW)","(PCm)",null,"DS","AR","(LN)",null,"SS","CD","(CA)"]
[null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(IN=\"\",\"\",IN)","v":9},{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},null,{"$f":"IF(bd=\"\",\"\",bd)","v":6},{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VP=\"\",\"\",VP)","v":7},{"$f":"IF(FW=\"\",\"\",FW)","v":""},{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},null,{"$f":"IF(DS=\"\",\"\",DS)","v":3},{"$f":"IF(AR=\"\",\"\",AR)","v":2},{"$f":"IF(lns=\"\",\"\",lns)","v":""},null,{"$f":"IF(SS=\"\",\"\",SS)","v":2},{"$f":"IF(CD=\"\",\"\",CD)","v":8},{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,null,"Verbal Comprehension",null,null,null,null,"      Perceptual Reasoning ",null,null,null,null,null,"Working Memory",null,null,null,"Processing Speed"]
[]
["GROUPS TO BE CONTEMPLATED IN GENERATING HYPOTHESES"]
[null,null,"SI","VC",null,"IN ","CO",null,"IN","AR","[VC?]",null,"(FW)","PCm",null,"BD","MR","VP"]
[null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},null,{"$f":"IF(IN=\"\",\"\",IN)","v":9},{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},null,{"$f":"IF(IN=\"\",\"\",IN)","v":9},{"$f":"IF(AR=\"\",\"\",AR)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},null,{"$f":"IF(FW=\"\",\"\",FW)","v":""},{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},null,{"$f":"IF(bd=\"\",\"\",bd)","v":6},{"$f":"IF(MR=\"\",\"\",MR)","v":2},{"$f":"IF(VP=\"\",\"\",VP)","v":7}]
[null,null,"Subtests emphasizing word meanings",null,null,"Subtests emphasizing factual knowledge",null,null,"Subtests emphasizing school-acquired knowledge",null,null,null,"Subtests with pictorial stimuli",null,null,"Subtests with abstract designs"]
[]
[null,null,"SI","CO",null,"VC","IN",null,"SI","VC","IN",null,"CO","AR",null,"SI","MR","FW","SS","CA"]
[null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},null,{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(IN=\"\",\"\",IN)","v":9},null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(IN=\"\",\"\",IN)","v":9},null,{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},{"$f":"IF(AR=\"\",\"\",AR)","v":2},null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(FW=\"\",\"\",FW)","v":""},{"$f":"IF(SS=\"\",\"\",SS)","v":2},{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,null,"Subtests emphasizing reasoning over knowledge",null,null,"Subtests emphasizing knowledge over reasoning",null,null,"Subtests with relatively short questions      ",null,null,null,"Subtests with relatively long questions",null,null,"Subtests emphasizing reasoning"]
[]
[null,null,"SI","VC","IN","AR",null,"VC","CO",null,"DS F",null,"DS B","DS S","LN","[AR?]",null,"CA"]
[null,null,{"$f":"IF(sim=\"\",\"\",sim)","v":2},{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(IN=\"\",\"\",IN)","v":9},{"$f":"IF(AR=\"\",\"\",AR)","v":2},null,{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},null,{"$f":"IF(dsf=\"\",\"\",dsf)","v":18},null,{"$f":"IF(dsb=\"\",\"\",dsb)","v":17},{"$f":"IF(dssq=\"\",\"\",dssq)","v":13},{"$f":"IF(lns=\"\",\"\",lns)","v":""},{"$f":"IF(AR=\"\",\"\",AR)","v":2},null,{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,null,"Subtests with relatively short answers",null,null,null,null,"Subtests with relatively long answers",null,null,"Memory Span",null,"Working Memory",null,null,null,null,"Vigilance"]
[]
[null,null,"BD",null,"MR",null,"BDN","VP","FW","PCm","AR","SS","CD","CA"]
[null,null,{"$f":"IF(CA=\"\",\"\",CA)","v":11},null,{"$f":"IF(MR=\"\",\"\",MR)","v":2},null,{"$f":"IF(bdnt=\"\",\"\",bdnt)","v":14},{"$f":"IF(VP=\"\",\"\",VP)","v":7},{"$f":"IF(FW=\"\",\"\",FW)","v":""},{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},{"$f":"IF(AR=\"\",\"\",AR)","v":2},{"$f":"IF(SS=\"\",\"\",SS)","v":2},{"$f":"IF(CD=\"\",\"\",CD)","v":8},{"$f":"IF(CA=\"\",\"\",CA)","v":11}]
[null,"Speed bonus",null,null,"No time limits",null,"Time limits"]
[]
[null,null,"BD vs BND",null,null,"DS F vs DS B",null,null,"DS F vs DS S",null,null,"DS B vs DS S"]
[null,null,{"$f":"IF(CA=\"\",\"\",CA)","v":11},{"$f":"IF(bdnt=\"\",\"\",bdnt)","v":14},null,{"$f":"IF(dsf=\"\",\"\",dsf)","v":18},{"$f":"IF(dsb=\"\",\"\",dsb)","v":17},null,{"$f":"IF(dsf=\"\",\"\",dsf)","v":18},{"$f":"IF(dssq=\"\",\"\",dssq)","v":13},null,{"$f":"IF(dsb=\"\",\"\",dsb)","v":17},{"$f":"IF(dssq=\"\",\"\",dssq)","v":13}]
[null,null,"Process Comparisons"]

{"sheet":"Cult. & Linq.","index":8,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,2,26,11],[43,2,45,9],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,2,20,2],[5,3,9,3],[10,3,14,3],[21,8,21,9],[17,4,18,4],[17,5,18,5],[21,4,21,5],[21,6,21,7],[12,6,13,6],[12,7,13,7],[7,8,8,8],[7,9,8,9],[16,3,20,3],[1,4,1,9],[3,4,3,9]]}
[]
[null,null,null,null,"WAIS-IV Cultural / Linguistic Matrix"]
[]
[null,null,null,null,"Degree of Linguistic Demands"]
[null,null,null,null,"High",null,"Moderate",null,"Low"]
[null,null,"Level Cultural Loading","High",null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",0,J8)","v":0},{"$f":"IF(J8=\"\",\"\",1)","v":""}]
[null,null,null,null,"Similarities",{"$f":"IF(sim=\"\",\"\",sim)","v":2},null,null,null,null,"High Cultural",null,{"$f":"IF(F7=\"\",0,F7)","v":2},{"$f":"IF(F7=\"\",\"\",1)","v":1}]
[null,null,null,null,"Vocabulary",{"$f":"IF(VOC=\"\",\"\",VOC)","v":9},null,null,"Picture Completion",{"$f":"IF(PCm=\"\",\"\",PCm)","v":""},"Average:",{"$f":"O10/P10","v":5.5},{"$f":"IF(F8=\"\",0,F8)","v":9},{"$f":"IF(F8=\"\",\"\",1)","v":1}]
[null,null,null,null,"Comprehension",{"$f":"IF(COMP=\"\",\"\",COMP)","v":""},null,null,null,null,"Standard Score:",{"$f":"15*(L8-10)/3+100","v":77.5},{"$f":"IF(F9=\"\",0,F9)","v":0},{"$f":"IF(F9=\"\",\"\",1)","v":""}]
[null,null,null,null,"Information",{"$f":"F18","v":""},null,null,null,null,null,null,{"$f":"IF(F10=\"\",0,F10)","v":0},{"$f":"IF(F10=\"\",\"\",1)","v":""},{"$f":"SUM(M6:M10)","v":11},{"$f":"SUM(N6:N10)","v":2}]
[null,null,null,"Moderate"]
[null,null,null,null,null,null,null,null,null,null,"Moderate Cultural"]
[null,null,null,null,null,null,"Arithmetic",{"$f":"IF(AR=\"\",\"\",AR)","v":2},null,null,"Average:",{"$f":"M13/N13","v":2},{"$f":"IF(H13=\"\",0,H13)","v":2},{"$f":"IF(H13=\"\",\"\",1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Standard Score:",{"$f":"15*(L13-10)/3+100","v":60}]
[]
[]
[null,null,null,"Low",null,null,"Block Design",{"$f":"IF(bd=\"\",\"\",bd)","v":6},"Matrix Reasoning",{"$f":"IF(MR=\"\",\"\",MR)","v":2},"Low Cultural",null,{"$f":"IF(H17=\"\",0,H17)","v":6},{"$f":"IF(H17=\"\",\"\",1)","v":1}]
[null,null,null,null,"Letter-Number Sequencing",{"$f":"IF(lns=\"\",\"\",lns)","v":""},"Digit Span",{"$f":"IF(DS=\"\",\"\",DS)","v":3},"Visual Puzzles",{"$f":"IF(VP=\"\",\"\",VP)","v":7},"Average:",{"$f":"O25/P25","v":5.5714285714285712},{"$f":"IF(H18=\"\",0,H18)","v":3},{"$f":"IF(H18=\"\",\"\",1)","v":1}]
[null,null,null,null,null,null,"Symbol Search",{"$f":"IF(SS=\"\",\"\",SS)","v":2},"Figure Weights",{"$f":"IF(FW=\"\",\"\",FW)","v":""},"Standard Score:",{"$f":"15*(L18-10)/3+100","v":77.857142857142861},{"$f":"IF(H19=\"\",0,H19)","v":2},{"$f":"IF(H19=\"\",\"\",1)","v":1}]
[null,null,null,null,null,null,"Coding",{"$f":"IF(CD=\"\",\"\",CD)","v":8},"Cancellation",{"$f":"IF(CA=\"\",\"\",CA)","v":11},null,null,{"$f":"IF(H20=\"\",0,H20)","v":8},{"$f":"IF(H20=\"\",\"\",1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F18=\"\",0,F18)","v":0},{"$f":"IF(F18=\"\",\"\",1)","v":""}]
[null,null,null,null,"High Linguistic",null,"Moderate Linguistic",null,"Low Linguistic",null,null,null,{"$f":"IF(J17=\"\",0,J17)","v":2},{"$f":"IF(J17=\"\",\"\",1)","v":1}]
[null,null,null,null,"Average:",{"$f":"F35/G35","v":5.5},"Average:",{"$f":"H35/I35","v":4.2},"Average:",{"$f":"J35/K35","v":6.666666666666667},null,null,{"$f":"IF(J18=\"\",0,J18)","v":7},{"$f":"IF(J18=\"\",\"\",1)","v":1}]
[null,null,null,null,"Standard Score:",{"$f":"15*(F23-10)/3+100","v":77.5},"Standard Score:",{"$f":"15*(H23-10)/3+100","v":71},"Standard Score:",{"$f":"15*(J23-10)/3+100","v":83.333333333333343},null,null,{"$f":"IF(J19=\"\",0,J19)","v":0},{"$f":"IF(J19=\"\",\"\",1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J20=\"\",0,J20)","v":11},{"$f":"IF(J20=\"\",\"\",1)","v":1},{"$f":"SUM(M17:M25)","v":39},{"$f":"SUM(N17:N25)","v":7}]
[null,null,"Adapted from Dawn Flanagan, Samuel Ortiz, and Vincent Alfonso's Essentials of Cross-Battery Assessment (Wiley, 2007) Append D."]
[]
[]
[null,null,null,null,null,{"$f":"IF(F7=\"\",0,F7)","v":2},{"$f":"IF(F7=\"\",\"\",1)","v":1},null,null,{"$f":"IF(J8=\"\",0,J8)","v":0},{"$f":"IF(J8=\"\",\"\",1)","v":""}]
[null,null,null,null,null,{"$f":"IF(F8=\"\",0,F8)","v":9},{"$f":"IF(F8=\"\",\"\",1)","v":1},{"$f":"IF(H13=\"\",0,H13)","v":2},{"$f":"IF(H13=\"\",\"\",1)","v":1},{"$f":"IF(J17=\"\",0,J17)","v":2},{"$f":"IF(J17=\"\",\"\",1)","v":1}]
[null,null,null,null,null,{"$f":"IF(F9=\"\",0,F9)","v":0},{"$f":"IF(F9=\"\",\"\",1)","v":""},{"$f":"IF(H17=\"\",0,H17)","v":6},{"$f":"IF(H17=\"\",\"\",1)","v":1},{"$f":"IF(J18=\"\",0,J18)","v":7},{"$f":"IF(J18=\"\",\"\",1)","v":1}]
[null,null,null,null,null,{"$f":"IF(F10=\"\",0,F10)","v":0},{"$f":"IF(F10=\"\",\"\",1)","v":""},{"$f":"IF(H18=\"\",0,H18)","v":3},{"$f":"IF(H18=\"\",\"\",1)","v":1},{"$f":"IF(J19=\"\",0,J19)","v":0},{"$f":"IF(J19=\"\",\"\",1)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(H19=\"\",0,H19)","v":2},{"$f":"IF(H19=\"\",\"\",1)","v":1},{"$f":"IF(J20=\"\",0,J20)","v":11},{"$f":"IF(J20=\"\",\"\",1)","v":1}]
[null,null,null,null,null,{"$f":"IF(F18=\"\",0,F18)","v":0},{"$f":"IF(F18=\"\",\"\",1)","v":""},{"$f":"IF(H20=\"\",0,H20)","v":8},{"$f":"IF(H20=\"\",\"\",1)","v":1}]
[null,null,null,null,null,{"$f":"SUM(F29:F34)","v":11},2,21,5,20,3]