{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Version 1","Input Instructions","Input Client Status","CS_Int_Data","Edit Instructions","Review-Edit Existing Record","Client Status Data","Output Instructions","Single Assessment Summary","Client Change Over Time","Program Summary","Program_Chart_Output","VE_Int_Data"],"not_rendered":{"charts":3,"images":6,"macros":1,"external_links":1,"defined_names":90,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Version 1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input Instructions","index":1,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,6,17,6],[34,1,34,11],[32,1,32,11],[23,1,23,11],[0,1,0,9],[3,1,3,11],[5,1,5,11],[10,1,10,11],[7,1,7,9],[13,2,13,6],[16,7,17,7],[19,1,19,6],[14,1,15,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,17,5]]}
[null,"Input Instructions - Outcomes for Human Trafficking Survivors"]
[null,"  "]
[null,"Introduction "]
[null,"This assessment is designed to describe a client’s status at a specific point in time. Information from this assessment can help programs identify service needs and strategies for each client.  When used over time it can document a client’s progress towards positive outcomes related to 14 categories addressing specific aspects of safety, well-being, social connectedness, and self-sufficiency.  "]
[]
[null,"Case managers should complete this client assessment based on their knowledge of a specific client. The assessment should not be completed with or by the client. "]
[]
[null,"Before completing the instrument on the next tab titled “Input Client Status,” please read all the instructions below.   "]
[]
[null,"Instructions "]
[null,"Each of the 14 categories consists of several rows within the category. Within each row, read the description in each column, and check the one box next to the text that best describes the client at this time. "]
[]
[null,"Example: "]
[]
[]
[]
[]
[]
[]
[]
[null,"Step by Step Instructions: "]
[null,"Enter the client’s ID and the date of the assessment. "]
[]
[null,"Complete each category independently of other categories. For example, a behavioral health issue such as intravenous drug use should be reflected in the Behavioral Health category, while a specific physical health impact of the drug use, such as Hepatitis C, would be reflected in the Physical Health category."]
[]
[null,"Within each category: "]
[null,"·   Read the important definitions provided in the left-hand column."]
[null,"·  If client has identified this category as a priority, check the “Client Priority Goal” box in the left column. "]
[null,"·  If the category includes a “Not Applicable” box, read the corresponding footnote and check “Not Applicable” if appropriate for that category."]
[null,"·  Complete each row by checking the box next to the description that best applies to the client at this point in time."]
[null,"            ·  Notice that the text in each row describes situations ranging from most vulnerable (at the left) towards thriving (at the right)"]
[null,"·  If you do not have enough information about the client to make an informed decision about how to score the client within a given row, select \"Intentionally Skipped.\" "]
[null,"·  If you do not have enough information about the client to make an informed decision about how to score the client within the entire category, leave every row blank, and \n   check the  “Don’t know” box in the left column."]
[null,"·  For minor clients, consider age-appropriate expectations. Several categories have items specifically designated for minors. "]
[null,"·  Complete each row independently of the other rows, describing a distinct aspect of the client. For example, if one row describes client health issues and another row describes\n   client access to healthcare, think about those two issues separately, to the extent possible."]
[null,"·  When you have completed all rows in a category, the instrument will calculate a summary rating for that category, based on the boxes that you checked. "]
[]
[null,"When you have completed all categories, please select “Add Status Record.” The information you entered will be saved on the “Client Status Data” tab.  "]
[null,"You can now add data for another client if you like. Remember to save the Excel file before closing the file."]

{"sheet":"Input Client Status","index":2,"n_rows":80,"n_cols":26,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,1,79,7],[77,1,77,2],[71,1,72,2],[68,7,70,7],[68,8,70,8],[73,1,73,2],[75,1,75,2],[78,1,78,2],[75,3,78,3],[75,4,78,4],[75,5,78,5],[75,6,78,6],[75,7,78,7],[75,8,78,8],[61,1,62,2],[61,5,61,7],[67,1,67,2],[68,3,70,3],[68,4,70,4],[68,5,70,5],[68,6,70,6],[68,1,68,2],[17,8,18,8],[19,1,19,7],[20,1,20,2],[22,1,22,2],[17,4,18,4],[17,5,18,5],[17,6,18,6],[23,1,24,2],[17,7,18,7],[21,1,21,2],[27,1,27,2],[33,1,33,2],[35,7,36,7],[35,8,36,8],[35,3,36,3],[35,4,36,4],[31,1,31,2],[32,1,32,2],[16,1,16,2],[17,3,18,3],[0,2,0,6],[8,1,8,2],[7,1,7,2],[11,1,11,2],[15,1,15,2],[9,4,10,4],[9,5,10,5],[9,6,10,6],[12,1,12,2],[9,7,10,7],[9,8,10,8],[25,8,26,8],[28,1,28,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[28,6,30,6],[28,7,30,7],[28,8,30,8],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[9,3,10,3],[35,5,36,5],[35,6,36,6],[63,3,65,3],[63,4,65,4],[63,5,65,5],[63,6,65,6],[63,7,65,7],[63,8,65,8],[66,1,66,7],[64,1,64,2],[43,1,43,2],[44,1,44,2],[45,3,47,3],[45,4,47,4],[45,5,47,5],[45,6,47,6],[45,7,47,7],[45,8,47,8],[46,1,46,2],[48,1,48,7],[49,1,49,2],[50,7,52,7],[50,8,52,8],[51,1,51,2],[53,1,53,7],[54,1,54,2],[50,3,52,3],[50,4,52,4],[50,5,52,5],[50,6,52,6],[55,8,56,8],[57,1,57,2],[58,1,58,2],[55,3,56,3],[55,4,56,4],[55,5,56,5],[55,6,56,6],[55,7,56,7],[42,1,42,7],[37,1,37,2],[38,1,38,2],[39,3,41,3],[39,4,41,4],[39,5,41,5],[39,6,41,6],[39,7,41,7],[39,8,41,8],[40,1,40,2]]}
[null,null,"Outcomes for Human Trafficking Survivors"]
[null,null,null,null,null,"Client Priority Goals"]
[]
[]
[null,null,"Client ID:",null,null,"Number of priority goals:",{"$f":"IF(S6=0,\"\",S6)","v":""},null,null,{"$f":"IF(U6>0,\"Missing Data!\",\"\")","v":""},null,null,null,null,null,null,null,"Don't know","P Goals",null,null,null,null,null,"P Goals>0"]
[null,null,"Date Completed:",null,null,"Average priority goal rating:",{"$f":"IF(X6=0,\"\",X6)","v":""},null,null,null,null,null,null,null,"Checks","Questions",{"$f":"COUNTIF(Q9:Q76,\">0\")+rngDoNotKnow","v":0},{"$f":"COUNTIF(R9:R80,TRUE)+COUNTIF(T9:T80,TRUE)","v":0},{"$f":"COUNTIF(S9:S80,TRUE)","v":0},"Missing",{"$f":"SUM(U9:U76)","v":0},null,"Priority",{"$f":"IF(Y6>0,SUM(X9:X80)/Y6,\"\")","v":""},{"$f":"COUNTIF(X9:X80,\">0\")","v":0}]
[]
[null,"Outcome Categories",null,"Check the one box within each row that best applies to the client at this point in time.",null,null,null,null,"Intentionally Skipped",null,"In Crisis (1)","Vulnerable (2)","Stable (3)","Growing (4)","Thriving (5)","Skipped","Total","Don't know","Priority Goals","Not Applicable","Missing","Score","Average Score","PG Score","Skipped"]
[null,"Behavioral Health\nBehavioral health may include mental health, emotional health, and substance use.",null,"Behavioral health issues seriously affect daily functioning","Behavioral health issues moderately affect daily functioning","Behavioral health issues mildly affect daily functioning","Behavioral health issues mildly and rarely affect daily functioning ","Behavioral health issues do not affect, or minimally affect, daily functioning",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K9:P9,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$11=FALSE,Q9=0,P9=FALSE),1,0)","v":0},{"$f":"(K9*1+L9*2+M9*3+N9*4+O9*5)","v":0},null,null,null,1]
[null,"Summary Rating:",{"$f":"W10","v":""},"Relies primarily on coping strategies that make one vulnerable and unsafe","Limited use of healthy coping or harm reduction strategies; frequent use of unhealthy strategies","Alternates among use of healthy coping, harm reduction, and unhealthy strategies","Frequent use of healthy coping strategies; limited use of harm reduction or unhealthy strategies","Relies primarily on healthy coping strategies; takes steps to implement self-care",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K10:P10,TRUE)","v":0},null,false,null,{"$f":"IF(AND(rngNSelections>0,R$11=FALSE,Q10=0,P10=FALSE),1,0)","v":0},{"$f":"(K10*1+L10*2+M10*3+N10*4+O10*5)","v":0},{"$f":"IF(OR(R11=TRUE,(U9+U10)>0,(Q9+Q10)=0,(COUNTIF(P9:P10,TRUE)=SUM(Q9:Q10))),\"\",SUM(V9:V10)/((Q9+Q10)-COUNTIF(P9:P10,TRUE)))","v":""},{"$f":"IF(W10=\"\",\"\",W10*S10)","v":""},2,2]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,{"$f":"IF(COUNTIF(P9:P10,TRUE)=Y10,1,0)","v":0},3]
[null,"Physical Health\nPhysical health includes physical, sexual, reproductive, vision and dental health.",null,"Health issues seriously affect daily functioning ","Health issues moderately affect daily functioning","Health issues mildly affect daily functioning ","Health issues mildly and rarely affect daily functioning ","Health issues do not affect, or minimally affect, daily functioning",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K12:P12,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$15=FALSE,Q12=0,P12=FALSE),1,0)","v":0},{"$f":"(K12*1+L12*2+M12*3+N12*4+O12*5)","v":0},null,null,null,4]
[null,"\nDo not include behavioral health issues, including substance use, when rating a client in this category; behavioral health issues affecting the client should be included within the behavioral health category.",null,"No treatment or significant gaps in treatment and management of health issues","Health issues occasionally treated and managed","Health issues usually treated and managed ","Health issues consistently treated and managed","Health issues proactively treated and managed",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R$15=FALSE,Q13=0,P13=FALSE),1,0)","v":0},0,null,null,null,5]
[null,"Summary Rating:",{"$f":"W15","v":""},"Does not understand basic health needs","Limited understanding of basic health needs ","Understands basic health needs ","Understands how to maintain health; can locate additional information as needed ","Understands how to maintain and improve health; can locate additional information as needed",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$15=FALSE,Q14=0,P14=FALSE),1,0)","v":0},0,null,null,4,6]
[null,"Don't know",null,"No access to health care or access through ER only","Limited access to health care","Access to basic health care","Access to basic health care and additional needed services (e.g. vision, dental)","Consistent and reliable access to basic health care and additional needed services (e.g. vision, dental)",null,null,false,false,false,false,false,false,0,false,null,null,{"$f":"IF(AND(rngNSelections>0,R$15=FALSE,Q15=0,P15=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R15=TRUE,(U12+U13+U14+U15)>0,(Q12+Q13+Q14+Q15)=0,COUNTIF(P12:P15,TRUE)=4),\"\",SUM(V12:V15)/(SUM(Q12:Q15)-COUNTIF(P12:P15,TRUE)))","v":""},{"$f":"IF(W15=\"\",\"\",W15*S13)","v":""},{"$f":"IF(COUNTIF(P12:P15,TRUE)=Y14,1,0)","v":0},7]
[null,"Safety\nThreats to physical, emotional, and financial safety and freedom can come from any source, including but not limited to a trafficker. ",null,"Serious and immediate threats to safety or freedom are known to exist","Moderate threats to safety or freedom are known to exist","Limited threats to safety are known to exist","Limited threats to safety are possible ","Threats to safety do not appear to exist 1",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K16:P16,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$19=FALSE,Q16=0,P16=FALSE),1,0)","v":0},0,null,null,null,8]
[null,"Safety plans and responses to threats do not necessarily include leaving trafficking or the abusive situation.",null,"No plans in place to protect safety or plans exist but cannot be implemented","Inadequate plans to protect safety or plans exist but uncertain whether they can be implemented","Adequate plans to protect safety ","Strong plans to protect safety ","Strong and flexible plans to protect safety ",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R$19=FALSE,Q17=0,P17=FALSE),1,0)","v":0},0,null,null,3,9]
[null,"Summary Rating:",{"$f":"W18","v":""},"Does not recognize or consider threats to safety","Occasionally recognizes and considers threats to safety","Usually recognizes threats to safety and makes choices accordingly when possible","Consistently recognizes threats to safety and makes choices accordingly when possible","Takes steps to reduce or avoid threats to safety",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$19=FALSE,Q18=0,P18=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R19=TRUE,(U16+U17+U18)>0,(Q16+Q17+Q18)=0,COUNTIF(P16:P18,TRUE)=3),\"\",SUM(V16:V18)/(SUM(Q16:Q18)-COUNTIF(P16:P18,TRUE)))","v":""},{"$f":"IF(W18=\"\",\"\",W18*S17)","v":""},{"$f":"IF(COUNTIF(P16:P18,TRUE)=Y17,1,0)","v":0},10]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,11]
[null,"1Wording here reflects the understanding that victims and survivors may always experience the possibility of threats to safety.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,"Housing",null,"Adults:","Adults:","Adults:","Adults:","Adults:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,"Adequate housing is safe, habitable, accessible and affordable (approximately one-third of income or less, including vouchers).",null,"Chronic homelessness or seriously inadequate shelter or housing","Intermittent homelessness, short-term shelter, or inadequate housing","Adequate time-limited housing available for at least the next 6 months  ","Adequate housing that is not time-limited","Housing is more than adequate, and is not time-limited",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K22:P22,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$27=FALSE,Q22=0,P22=FALSE),1,0)","v":0},{"$f":"(K22*1+L22*2+M22*3+N22*4+O22*5)","v":0},null,null,null,14]
[null,"Time-limited housing has a pre-determined maximum length of time that the client is allowed to live there.",null,"Unable to manage housing needs ","Manages housing needs and issues with significant help ","Manages housing needs and issues with occasional help ","Manages housing needs and issues independently","Manages housing needs and issues proactively; could find other suitable housing",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$27=FALSE,Q23=0,P23=FALSE),1,0)","v":0},0,null,null,null,15]
[null,"Minors: answer based on housing with parent/ guardian or other adult, child welfare placement, or independent living arrangement. ",null,"Minors:","Minors:","Minors:","Minors:","Minors:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,"Chronic homelessness, seriously inadequate shelter or housing ","Intermittent homelessness, short-term shelter, or inadequate housing ","Adequate time-limited housing available for at least the next 6 months","Adequate housing that is not time-limited ","Housing is more than adequate, and is not time-limited",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K25:P25,TRUE)","v":0},null,false,null,{"$f":"IF(AND(rngNSelections>0,R$27=FALSE,Q25=0,P25=FALSE),1,0)","v":0},0,null,null,4,17]
[null,"Summary Rating:",{"$f":"W26","v":""},"Frequently lacks adequate housing owing to runaway/kickout episodes","Occasionally lacks adequate housing owing to runaway/kickout episodes","Parent/guardian manages housing needs and issues with occasional help","Parent/guardian manages housing needs and issues ","Parent/guardian manages housing needs and issues proactively; could find other suitable housing",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$27=FALSE,Q26=0,P26=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R27=TRUE,(U22+U23+U25+U26)>0,(Q22+Q23+Q25+Q26)=0,(SUM(Q22:Q23,Q25:Q26)=COUNTIF(P22:P26,TRUE))),\"\",SUM(V22:V23,V25:V26)/(SUM(Q22:Q23,Q25:Q26)-COUNTIF(P22:P26,TRUE)))","v":""},{"$f":"IF(W26=\"\",\"\",W26*S25)","v":""},{"$f":"IF(COUNTIF(P22:P26,TRUE)=Y25,1,0)","v":0},18]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,19]
[null,"Language and Literacy\nLanguage refers to functional speaking ability. \n\nLiteracy refers to the ability to read and write.\n",null,"Language seriously impedes daily activities or access to services","Language moderately impedes daily activities or access to services","Language mildly impedes daily activities or access to services, or limits ability to achieve short-term goals","Language is adequate for daily activities or access to services, and for achievement of short-term goals","Language is at least adequate for daily activities or access to services, and achievement of long-term goals.",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K28:P28,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$31=FALSE,Q28=0,P28=FALSE),1,0)","v":0},{"$f":"(K28*1+L28*2+M28*3+N28*4+O28*5)","v":0},null,null,2,20]
[null,"Language and literacy both refer to the language that the client needs to meet needs and achieve goals.",null,"Literacy seriously impedes daily activities or access to services","Literacy moderately impedes daily activities or access to services","Literacy mildly impedes daily activities or access to services, or limits ability to achieve short-term goals","Literacy is adequate for daily activities or access to services, and for achievement of short-term goals","Literacy is at least adequate for daily activities or access to services, and achievement of long-term goals",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R$31=FALSE,Q29=0,P29=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R31=TRUE,(U28+U29)>0,(Q28+Q29)=0,(SUM(Q28:Q29)=COUNTIF(P28:P29,TRUE))),\"\",SUM(V28:V29)/(SUM(Q28:Q29)-COUNTIF(P28:P29,TRUE)))","v":""},{"$f":"IF(W29=\"\",\"\",W29*S29)","v":""},{"$f":"IF(COUNTIF(P28:P29,TRUE)=Y28,1,0)","v":0},21]
[null,"Summary Rating:",{"$f":"W29","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,23]
[null,"Education",null,"Adult:","Adult:","Adult:","Adult:","Adult:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,"Education includes traditional and vocational school, GED, other vocational training, or language courses to improve employment or functioning in daily life. ",null,"No high school diploma or equivalent; educational status limits current employment ","No high school diploma or equivalent; educational status does not limit current employment ","High school equivalent (GED) ","High school diploma ","Some post-secondary education or training",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K33:P33,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$37=FALSE,Q33=0,P33=FALSE),1,0)","v":0},{"$f":"(K33*1+L33*2+M33*3+N33*4+O33*5)","v":0},null,null,null,25]
[null,"Stop out is an absence from school of more than 20 consecutive days for reasons other than illness, vacation, or injury.",null,"If the client is not working toward educational goals, select ‘Intentionally Skipped’ for this row","Working toward any educational goals with major assistance","Working toward any educational goals with moderate assistance","Working toward any educational goals with minor assistance","Manages any educational goals independently  ",null,null,null,false,false,false,false,false,{"$f":"COUNTIF(L34:P34,TRUE)","v":0},null,false,null,{"$f":"IF(AND(rngNSelections>0,R$37=FALSE,Q34=0,P34=FALSE),1,0)","v":0},{"$f":"(L34*0.25+M34*0.5+N34*0.75+O34*1)","v":0},null,null,null,26]
[null,null,null,"Minor:","Minor:","Minor:","Minor:","Minor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,"Summary Rating:",{"$f":"W36","v":""},"Current core course enrollment is 3 or more grades below expected grade level; or current stop out, dropped out, pattern of chronic absenteeism, or other high risk of dropping out","Current core course enrollment is 1-2 grades below expected grade level; or recent stop out, frequent absenteeism, or other moderate risk of dropping out","Currently enrolled at expected grade level with passing grades in most core courses","Currently enrolled at expected grade level with passing grades in all core courses","Graduated or currently enrolled at expected grade level with passing grades in all courses and a C average or greater",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K36:P36,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$37=FALSE,Q36=0,P36=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R37=TRUE,(U33+U34+U36)>0,(Q33+Q34+Q36)=0,AND(P33=TRUE,P34=TRUE,P36=TRUE)),\"\",IF(V33=5,V33,SUM(V33:V34,V36)))","v":""},{"$f":"IF(W36=\"\",\"\",W36*S34)","v":""},{"$f":"IF(AND(P33=TRUE,P34=TRUE,P36=TRUE),1,0)","v":0},28]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,29]
[null,"Employment\nSufficient employment consistently provides adequate income to meet basic needs.\n\nWork readiness skills include personal characteristics and behavioral skills that enhance interactions and job performance, such as adaptability, integrity, cooperation, and task focus.",null,"Chronic unemployment, exploitive or risky work ","Frequently unemployed, or relies primarily on exploitive or risky work ","Usually employed with minimally sufficient income ","Usually employed with sufficient income ","Stable employment with sufficient income, possible opportunities for growth",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K38:P38,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R42=FALSE,T41=FALSE,Q38=0,P38=FALSE),1,0)","v":0},{"$f":"(K38*1+L38*2+M38*3+N38*4+O38*5)","v":0},null,null,null,30]
[null,"You may select “Intentionally  Skipped” for the first row if:\n• The client is a foreign national without work authorization\n• The client is in a full-time education or training program",null,"Insufficient work readiness skills","Work readiness skills are limited and a barrier to sustained employment","Work readiness sufficient to sustain a job","Work readiness skills to function well in a job ","Work readiness skills to obtain different job if needed",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R42=FALSE,T41=FALSE,Q39=0,P39=FALSE),1,0)","v":0},0,null,null,3,31]
[null,"Summary Rating:",{"$f":"W40","v":""},"No defined job skills","Job skills are limited","Job skills sufficient to sustain a job","Job skills to function well in a job","Job skills to advance within a work setting",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R42=FALSE,T41=FALSE,Q40=0,P40=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R42=TRUE,T41=TRUE,(U38+U39+U40)>0,(Q38+Q39+Q40)=0,(SUM(Q38:Q40)=COUNTIF(P38:P40,TRUE))),\"\",SUM(V38:V40)/(SUM(Q38:Q40)-COUNTIF(P38:P40,TRUE)))","v":""},{"$f":"IF(W40=\"\",\"\",W40*S39)","v":""},{"$f":"IF(COUNTIF(P38:P40,TRUE)=Y39,1,0)","v":0},32]
[null,"Not Applicable2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,33]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,34]
[null,"2Employment: Not Applicable if client is under 16.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,"Resource Management\nBasic needs can include shelter, food, clothing, hygiene, transportation, etc. These may be met through resources such as wages, family, community, benefits or other ways.",null,"Frequently goes without basic needs being met, or frequently meets needs through exploitive or risky means","Occasionally meets basic needs; may occasionally meet needs through exploitive or risky means","Usually meets basic needs through safe, legal means","Consistently meets basic needs and manages occasional crises through safe, legal means","Meets basic needs and beyond, with resources for occasional crises through safe, legal means",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K44:P44,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$48=FALSE,T$47=FALSE,Q44=0,P44=FALSE),1,0)","v":0},0,null,null,null,36]
[null,"Although clients may have to make the best decision possible within limited options, the last row of boxes refers to decisions that can make a situation worse.",null,"Lacks skills to manage resources","Limited skills to manage resources","Basic skills to manage resources","Has skills to consistently manage resources","Has skills to manage resources for current and future needs; maintains some reserves",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R$48=FALSE,T$47=FALSE,Q45=0,P45=FALSE),1,0)","v":0},0,null,null,3,37]
[null,"Summary Rating:",{"$f":"W46","v":""},"Often makes decisions that make financial challenges worse","Sometimes makes decisions that make financial challenges worse","Occasionally makes decisions that make financial challenges worse","Usually makes decisions consistent with predictable needs","Routinely makes decisions consistent with predictable needs",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$48=FALSE,T$47=FALSE,Q46=0,P46=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R48=TRUE,T47=TRUE,(U44+U45+U46)>0,(Q44+Q45+Q46)=0,(SUM(Q44:Q46)=COUNTIF(P44:P46,TRUE))),\"\",SUM(V44:V46)/(SUM(Q44:Q46)-COUNTIF(P44:P46,TRUE)))","v":""},{"$f":"IF(W46=\"\",\"\",W46*S45)","v":""},{"$f":"IF(COUNTIF(P44:P46,TRUE)=Y45,1,0)","v":0},38]
[null,"Not Applicable3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,39]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,40]
[null,"3Resources Management: Not applicable if client is under 18 and supported by parent or caregiver.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,"Public Benefits\nPublic benefits include programs the client needs and qualifies for, such as food stamps, cash assistance, WIC, disability, childcare, or housing subsidies.\n\nLanguage assistance may be needed by any client regardless of ability to navigate benefits processes.",null,"Not receiving any needed public benefits","Receiving few needed public benefits","Receiving some needed public benefits","Receiving most needed public benefits","Receiving all needed public benefits, or does not need public benefits",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K50:P50,TRUE)","v":0},null,false,null,{"$f":"IF(AND(rngNSelections>0,R$53=FALSE,T$52=FALSE,Q50=0,P50=FALSE),1,0)","v":0},{"$f":"(K50*1+L50*2+M50*3+N50*4+O50*5)","v":0},null,null,2,42]
[null,"Summary Rating:",{"$f":"W51","v":""},"Unaware of or unable to take steps to obtain benefits, with or without assistance","Participates in benefit application processes, but relies heavily upon assistance","Navigates benefit application processes with some assistance  ","Navigates benefit application processes with minimal assistance","Applies for and maintains needed benefits with minimal assistance",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$53=FALSE,T$52=FALSE,Q51=0,P51=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R53=TRUE,T52=TRUE,(U50+U51)>0,(Q50+Q51)=0,(SUM(Q50:Q51)=COUNTIF(P50:P51,TRUE))),\"\",SUM(V50:V51)/(SUM(Q50:Q51)-COUNTIF(P50:P51,TRUE)))","v":""},{"$f":"IF(W51=\"\",\"\",W51*S50)","v":""},{"$f":"IF(COUNTIF(P50:P51,TRUE)=Y50,1,0)","v":0},43]
[null,"Not Applicable4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,44]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,45]
[null,"4Public benefits: Not applicable if client is under 18 and supported by parent or caregiver, is in foster care, or does not qualify for public benefits (for example, is a foreign national).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,"Life Skills\nLife skills are the age-appropriate skills to meet daily tasks of independent living (for example, making purchases, preparing food, using transportation) in one’s current environment.",null,"Requires assistance with many basic tasks","Manages some basic tasks; does not seek assistance when needed ","Manages most tasks; sometime seeks assistance when needed","Manages most tasks; usually seeks assistance when needed ","Full functioning on tasks; seeks assistance when needed; builds new skills when needed",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K55:P55,TRUE)","v":0},null,false,null,{"$f":"IF(AND(rngNSelections>0,R$57=FALSE,Q55=0,P55=FALSE),1,0)","v":0},{"$f":"(K55*1+L55*2+M55*3+N55*4+O55*5)","v":0},null,null,2,47]
[null,"Summary Rating:",{"$f":"W56","v":""},"Takes steps based on immediate survival needs","Responds to crises, but may not address non-urgent problems","Addresses problems before they become more serious, to the extent possible","Takes steps to avoid problems, to the extent possible","Takes proactive steps to improve circumstances, to the extent possible",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$57=FALSE,Q56=0,P56=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R57=TRUE,(U55+U56)>0,(Q55+Q56)=0,(SUM(Q55:Q56)=COUNTIF(P55:P56,TRUE))),\"\",SUM(V55:V56)/(SUM(Q55:Q56)-COUNTIF(P55:P56,TRUE)))","v":""},{"$f":"IF(W56=\"\",\"\",W56*S55)","v":""},{"$f":"IF(COUNTIF(P55:P56,TRUE)=Y55,1,0)","v":0},48]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,49]
[null,"Legal\nLegal issues may include criminal or juvenile justice offenses; expungement of previous offenses; civil issues that impact well-being; or rights as a crime victim. ",null,"Felony or serious juvenile charges; no legal assistance","Felony or serious juvenile charges; receiving legal assistance ","Misdemeanor criminal or juvenile charges; receiving legal assistance OR felony or serious juvenile charges with favorable resolution likely","Misdemeanor criminal or juvenile charges with favorable resolution likely","No outstanding criminal or juvenile charges",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K58:P58,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$61=FALSE,Q58=0,P58=FALSE),1,0)","v":0},0,null,null,null,50]
[null,"Favorable resolution to charges may consist of outcomes such as dismissal, diversion, or deferred prosecution. ",null,"Not compliant with probation, parole, or court orders","Some probation, parole, or court order concerns","No more than minor probation, parole, or court order issues","Full compliance with probation, parole, or court orders ","No probation, parole, or court ordered conditions",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R$61=FALSE,Q59=0,P59=FALSE),1,0)","v":0},0,null,null,null,51]
[null,"Summary Rating:",{"$f":"W61","v":""},"Does not understand legal issues","Has a limited understanding of legal issues","Somewhat understands legal issues as they apply to current circumstances","Understands most legal issues as they apply to current circumstances","Understands legal options and knows how to obtain more information if needed",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$61=FALSE,Q60=0,P60=FALSE),1,0)","v":0},0,null,null,4,52]
[null,"Don't know",null,"Major unresolved civil or victim’s rights issues","Significant civil or victim’s rights issues","Minor or moderate unresolved civil or victim’s rights issues ","Addressing most civil or victim’s rights issues","Addressing any civil or victim’s rights issues",null,null,false,false,false,false,false,false,0,false,null,null,{"$f":"IF(AND(rngNSelections>0,R$61=FALSE,Q61=0,P61=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R61=TRUE,(U58+U59+U60+U61)>0,(Q58+Q59+Q60+Q61)=0,(SUM(Q58:Q61)=COUNTIF(P58:P61,TRUE))),\"\",SUM(V58:V61)/(SUM(Q58:Q61)-COUNTIF(P58:P61,TRUE)))","v":""},{"$f":"IF(W61=\"\",\"\",W61*S59)","v":""},{"$f":"IF(COUNTIF(P58:P61,TRUE)=Y60,1,0)","v":0},53]
[null,"Immigration\nTemporary statuses include those directly related to trafficking victimization (for example, T or U Visa, Continued Presence), and others (for example, H-2A, fiancé visa). ",null,"Currently detained, or in imminent danger of detention or deportation","Risk of detention or deportation ","If the client is not at risk of detention or deportation, \nselect ‘Intentionally Skipped’ for this row.",null,null,null,"Complete each row in category.",false,false,null,null,null,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$66=FALSE,T$65=FALSE,Q62=0,P62=FALSE),1,0)","v":0},{"$f":"(K62*1+L62*2)","v":0},null,null,null,54]
[null,null,null,"Undocumented status, or imminently expiring temporary status, and not receiving assistance with immigration issues","Undocumented status, or imminently expiring temporary status, and receiving assistance with immigration issues","Temporary status; application for longer term status has not yet been initiated","Temporary status; application for longer term status has been initiated ","Long term status, or application for long term status submitted",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R$66=FALSE,T$65=FALSE,Q63=0,P63=FALSE),1,0)","v":0},{"$f":"(K63*1+L63*2+M63*3+N63*4+O63*5)","v":0},null,null,3,55]
[null,"Summary Rating:",{"$f":"W64","v":""},"No understanding of immigration-related rights or requirements ","Limited understanding of immigration-related rights and requirements","Understands immigration-related rights and requirements; can advocate for rights with some assistance","Understands immigration-related rights and requirements; can advocate for rights with limited assistance","Understands immigration-related rights and requirements; able to advocate for rights independently or with limited assistance",null,null,false,false,false,false,false,false,0,null,null,null,{"$f":"IF(AND(rngNSelections>0,R$66=FALSE,T$65=FALSE,Q64=0,P64=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R66=TRUE,T65=TRUE,(U62+U63+U64)>0,(Q62+Q63+Q64)=0,(SUM(Q62:Q64)=COUNTIF(P62:P64,TRUE))),\"\",SUM(V62:V64)/(SUM(Q62:Q64)-COUNTIF(P62:P64,TRUE)))","v":""},{"$f":"IF(W64=\"\",\"\",W64*S63)","v":""},{"$f":"IF(COUNTIF(P62:P64,TRUE)=Y63,1,0)","v":0},56]
[null,"Not Applicable5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,57]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,58]
[null,"5Immigration: Not Applicable if client is a citizen, or is a non-citizen/non-legal permanent resident who does not want to stay in the US.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59]
[null,"Social Support\nSocial support may include support from family, friends, or others.",null,"No current social support or only social support that facilitates risky behavior or exploitation","Limited and inconsistent social support ","Limited but reliable social support ","Reliable and growing social support ","Diverse and reliable social support",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K68:P68,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$71=FALSE,Q68=0,P68=FALSE),1,0)","v":0},{"$f":"(K68*1+L68*2+M68*3+N68*4+O68*5)","v":0},null,null,2,60]
[null,"Positive social support is emotional, material, or practical support that does not expose client to harm or exploitation.",null,"Does not seek positive social support; unable to engage or maintain positive relationships; or socially isolated","Intermittently seeks positive social support but has limited ability to engage or maintain positive relationships; or somewhat socially isolated","Usually seeks positive social support; learning to cultivate positive relationship(s)","Cultivates positive relationship(s)","Cultivates and maintains positive relationship(s)",null,null,false,false,false,false,false,false,0,null,false,null,{"$f":"IF(AND(rngNSelections>0,R$71=FALSE,Q69=0,P69=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R71=TRUE,(U68+U69)>0,(Q68+Q69)=0,(SUM(Q68:Q69)=COUNTIF(P68:P69,TRUE))),\"\",SUM(V68:V69)/(SUM(Q68:Q69)-COUNTIF(P68:P69,TRUE)))","v":""},{"$f":"IF(W69=\"\",\"\",W69*S69)","v":""},{"$f":"IF(COUNTIF(P68:P69,TRUE)=Y68,1,0)","v":0},61]
[null,"Summary Rating:",{"$f":"W69","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,63]
[null,"Parenting\nChild(ren)’s needs include age-appropriate material, developmental, educational, and emotional needs. ",null,"Often has difficulty meeting child(ren)’s needs, requires substantial assistance","Sometimes has difficulty meeting child(ren)’s needs, may require substantial assistance","Usually able to meet child(ren)’s needs, may require moderate assistance ","Consistently able to meet child(ren)’s needs, may require moderate assistance ","Consistently able to meet child(ren)’s needs, may require minor assistance ",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K72:P72,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$79=FALSE,T$78=FALSE,Q72=0,P72=FALSE),1,0)","v":0},{"$f":"(K72*1+L72*2+M72*3+N72*4+O72*5)","v":0},null,null,null,64]
[null,null,null,"If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]
[null,"Selecting a box that includes \"does not meet needs\" is not a statement of child abuse or neglect.   ",null,"Desires, but does not have, access to non-custodial child(ren) ","Significantly less than desired contact with non-custodial child(ren)","Somewhat less than desired contact with non-custodial child(ren)","Typically has desired amount of contact with non-custodial child(ren)","Consistently has desired amount of contact with non-custodial child(ren)",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K74:P74,TRUE)","v":0},null,null,null,{"$f":"IF(AND(rngNSelections>0,R$79=FALSE,T$78=FALSE,Q74=0,P74=FALSE),1,0)","v":0},{"$f":"(K74*1+L74*2+M74*3+N74*4+O74*5)","v":0},null,null,null,66]
[null,null,null,"If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,67]
[null,"Complete all applicable rows if client’s children are in different situations (for example, one living with client and one with another parent or caregiver).",null,"Consistently non-compliant with requirements of child welfare agency ","Inconsistently meets requirements of child welfare agency ","Meets requirements of child welfare agency with occasional setbacks","Consistently meeting requirements of child welfare agency ","Involvement with child welfare agency moving steadily toward resolution",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K76:P76,TRUE)","v":0},null,false,null,{"$f":"IF(AND(rngNSelections>0,R$79=FALSE,T$78=FALSE,Q76=0,P76=FALSE),1,0)","v":0},{"$f":"(K76*1+L76*2+M76*3+N76*4+O76*5)","v":0},{"$f":"IF(OR(R79=TRUE,T78=TRUE,(U72+U74+U76)>0,(Q72+Q74+Q76)=0,(SUM(Q72,Q74,Q76)=COUNTIF(P72:P76,TRUE))),\"\",SUM(V72,V74,V76)/(SUM(Q72,Q74,Q76)-COUNTIF(P72:P76,TRUE)))","v":""},{"$f":"IF(W76=\"\",\"\",W76*S76)","v":""},{"$f":"IF(COUNTIF(P72:P76,TRUE)=Y75,1,0)","v":0},68]
[null,"Summary Rating:",{"$f":"W76","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69]
[null,"Not Applicable6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,70]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,71]
[null,"6Parenting: Not applicable if client has no children or does not intend to be involved with children in custody of another caregiver or child welfare system.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]

{"sheet":"CS_Int_Data","index":3,"n_rows":3,"n_cols":91,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["RecordID","ClientID","DateCompleted","client_priority_rating","behavior_health_priority","behavior_health_dk","behavior_health_rating","behavior_health_q1","behavior_health_q2","physical_health_priority","physical_health_dk","physical_health_rating","physical_health_q1","physical_health_q2","physical_health_q3","physical_health_q4","safety_priority","safety_dk","safety_rating","safety_q1","safety_q2","safety_q3","housing_priority","housing_dk","housing_rating","housing_q1","housing_q2","housing_q3","housing_q4","language_priority","language_dk","language_rating","language_q1","language_q2","education_priority","education_dk","education_rating","education_q1","education_q2","education_q3","employment_priority","employment_na","employment_dk","employment_rating","employment_q1","employment_q2","employment_q3","resource_priority","resource_na","resource_dk","resource_rating","resource_q1","resource_q2","resource_q3","public_benefits_priority","public_benefits_na","public_benefits_dk","public_benefits_rating","public_benefits_q1","public_benefits_q2","life_skills_priority","life_skills_dk","life_skills_rating","life_skills_q1","life_skills_q2","legal_priority","legal_dk","legal_rating","legal_q1","legal_q2","legal_q3","legal_q4","immigration_priority","immigration_na","immigration_dk","immigration_rating","immigration_q1","immigration_q2","immigration_q3","social_support_priority","social_support_dk","social_support_rating","social_support_q1","social_support_q2","parenting_priority","parenting_na","parenting_dk","parenting_rating","parenting_q1","parenting_q2","parenting_q3"]
[null,null,null,null,2,3,null,1,2,5,7,null,4,5,6,7,9,11,null,8,9,10,17,19,null,14,15,17,18,21,23,null,20,21,26,29,null,25,26,28,31,33,34,null,30,31,32,37,39,40,null,36,37,38,42,44,45,null,42,43,47,49,null,47,48,51,53,null,50,51,52,53,55,57,58,null,54,55,56,61,63,null,60,61,68,70,71,null,64,66,68]
[{"$f":"MAX('Client Status Data'!A:A)+1","v":1},{"$f":"rngCS_ClientID","v":0},{"$f":"IF(ISBLANK(rngCS_Months),NOW(),rngCS_Months)","v":"2020-09-21T15:11:48.150"},{"$f":"'Input Client Status'!X6","v":""},{"$f":"IF(AND(F3=1,INT(OFFSET('Input Client Status'!$K$8,E2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,E2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,F2,7))","v":0},{"$f":"'Input Client Status'!C10","v":""},{"$f":"IF(AND($F3<>1,INT(OFFSET('Input Client Status'!$K$8,H2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,H2,11)),\"\")","v":0},{"$f":"IF(AND($F3<>1,INT(OFFSET('Input Client Status'!$K$8,I2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,I2,11)),\"\")","v":0},{"$f":"IF(AND(K3=1,INT(OFFSET('Input Client Status'!$K$8,J2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,J2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,K2,7))","v":0},{"$f":"'Input Client Status'!C14","v":""},{"$f":"IF(AND($K3<>1,INT(OFFSET('Input Client Status'!$K$8,M2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,M2,11)),\"\")","v":0},{"$f":"IF(AND($K3<>1,INT(OFFSET('Input Client Status'!$K$8,N2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,N2,11)),\"\")","v":0},{"$f":"IF(AND($K3<>1,INT(OFFSET('Input Client Status'!$K$8,O2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,O2,11)),\"\")","v":0},{"$f":"IF(AND($K3<>1,INT(OFFSET('Input Client Status'!$K$8,P2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,P2,11)),\"\")","v":0},{"$f":"IF(AND(R3=1,INT(OFFSET('Input Client Status'!$K$8,Q2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,Q2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,R2,7))","v":0},{"$f":"'Input Client Status'!C18","v":""},{"$f":"IF(AND($R3<>1,INT(OFFSET('Input Client Status'!$K$8,T2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,T2,11)),\"\")","v":0},{"$f":"IF(AND($R3<>1,INT(OFFSET('Input Client Status'!$K$8,U2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,U2,11)),\"\")","v":0},{"$f":"IF(AND($R3<>1,INT(OFFSET('Input Client Status'!$K$8,V2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,V2,11)),\"\")","v":0},{"$f":"IF(AND(X3=1,INT(OFFSET('Input Client Status'!$K$8,W2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,W2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,X2,7))","v":0},{"$f":"'Input Client Status'!C26","v":""},{"$f":"IF(AND($X3<>1,INT(OFFSET('Input Client Status'!$K$8,Z2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,Z2,11)),\"\")","v":0},{"$f":"IF(AND($X3<>1,INT(OFFSET('Input Client Status'!$K$8,AA2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,AA2,11)),\"\")","v":0},{"$f":"IF(AND($X3<>1,INT(OFFSET('Input Client Status'!$K$8,AB2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,AB2,11)),\"\")","v":0},{"$f":"IF(AND($X3<>1,INT(OFFSET('Input Client Status'!$K$8,AC2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,AC2,11)),\"\")","v":0},{"$f":"IF(AND(AE3=1,INT(OFFSET('Input Client Status'!$K$8,AD2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,AD2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,AE2,7))","v":0},{"$f":"'Input Client Status'!C30","v":""},{"$f":"IF(AND($AE3<>1,INT(OFFSET('Input Client Status'!$K$8,AG2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,AG2,11)),\"\")","v":0},{"$f":"IF(AND($AE3<>1,INT(OFFSET('Input Client Status'!$K$8,AH2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,AH2,11)),\"\")","v":0},{"$f":"IF(AND(AJ3=1,INT(OFFSET('Input Client Status'!$K$8,AI2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,AI2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,AJ2,7))","v":0},{"$f":"'Input Client Status'!C36","v":""},{"$f":"IF(AND($AJ3<>1,INT(OFFSET('Input Client Status'!$K$8,AL2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,AL2,11)),\"\")","v":0},{"$f":"IF(AND($AJ3<>1,INT(OFFSET('Input Client Status'!$K$8,AM2,5))<>1),OFFSET('Input Client Status'!$K$8,AM2,11),\"\")","v":0},{"$f":"IF(AND($AJ3<>1,INT(OFFSET('Input Client Status'!$K$8,AN2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,AN2,11)),\"\")","v":0},{"$f":"IF(AP3=1,\"\",IF(AND(AQ3=1,INT(OFFSET('Input Client Status'!$K$8,AO2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,AO2,8))))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,AP2,9))","v":0},{"$f":"IF(AP3=1,\"\",INT(OFFSET('Input Client Status'!$K$8,AQ2,7)))","v":0},{"$f":"'Input Client Status'!C40","v":""},{"$f":"IF(AND($AQ3<>1,INT(OFFSET('Input Client Status'!$K$8,AS2,5))<>1,$AP3<>1),INT(OFFSET('Input Client Status'!$K$8,AS2,11)),\"\")","v":0},{"$f":"IF(AND($AQ3<>1,INT(OFFSET('Input Client Status'!$K$8,AT2,5))<>1,$AP3<>1),INT(OFFSET('Input Client Status'!$K$8,AT2,11)),\"\")","v":0},{"$f":"IF(AND($AQ3<>1,INT(OFFSET('Input Client Status'!$K$8,AU2,5))<>1,$AP3<>1),INT(OFFSET('Input Client Status'!$K$8,AU2,11)),\"\")","v":0},{"$f":"IF(OR(AW3=1,AND(AX3=1,INT(OFFSET('Input Client Status'!$K$8,AV2,8))=0)),\"\",INT(OFFSET('Input Client Status'!$K$8,AV2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,AW2,9))","v":0},{"$f":"IF(AW3=1,\"\",INT(OFFSET('Input Client Status'!$K$8,AX2,7)))","v":0},{"$f":"'Input Client Status'!C46","v":""},{"$f":"IF(AND($AX3<>1,INT(OFFSET('Input Client Status'!$K$8,AZ2,5))<>1,$AW3<>1),INT(OFFSET('Input Client Status'!$K$8,AZ2,11)),\"\")","v":0},{"$f":"IF(AND($AX3<>1,INT(OFFSET('Input Client Status'!$K$8,BA2,5))<>1,$AW3<>1),INT(OFFSET('Input Client Status'!$K$8,BA2,11)),\"\")","v":0},{"$f":"IF(AND($AX3<>1,INT(OFFSET('Input Client Status'!$K$8,BB2,5))<>1,$AW3<>1),INT(OFFSET('Input Client Status'!$K$8,BB2,11)),\"\")","v":0},{"$f":"IF(OR(BD3=1,AND(BE3=1,INT(OFFSET('Input Client Status'!$K$8,BC2,8))=0)),\"\",INT(OFFSET('Input Client Status'!$K$8,BC2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,BD2,9))","v":0},{"$f":"IF(BD3=1,\"\",INT(OFFSET('Input Client Status'!$K$8,BE2,7)))","v":0},{"$f":"'Input Client Status'!C51","v":""},{"$f":"IF(AND($BE3<>1,INT(OFFSET('Input Client Status'!$K$8,BG2,5))<>1,$BD3<>1),INT(OFFSET('Input Client Status'!$K$8,BG2,11)),\"\")","v":0},{"$f":"IF(AND($AX3<>1,INT(OFFSET('Input Client Status'!$K$8,BH2,5))<>1,$AW3<>1),INT(OFFSET('Input Client Status'!$K$8,BH2,11)),\"\")","v":0},{"$f":"IF(AND(BJ3=1,INT(OFFSET('Input Client Status'!$K$8,BI2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,BI2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,BJ2,7))","v":0},{"$f":"'Input Client Status'!C56","v":""},{"$f":"IF(AND($BJ3<>1,INT(OFFSET('Input Client Status'!$K$8,BL2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,BL2,11)),\"\")","v":0},{"$f":"IF(AND($BJ3<>1,INT(OFFSET('Input Client Status'!$K$8,BM2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,BM2,11)),\"\")","v":0},{"$f":"IF(AND(BO3=1,INT(OFFSET('Input Client Status'!$K$8,BN2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,BN2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,BO2,7))","v":0},{"$f":"'Input Client Status'!C60","v":""},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Input Client Status'!$K$8,BQ2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,BQ2,11)),\"\")","v":0},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Input Client Status'!$K$8,BR2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,BR2,11)),\"\")","v":0},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Input Client Status'!$K$8,BS2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,BS2,11)),\"\")","v":0},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Input Client Status'!$K$8,BT2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,BT2,11)),\"\")","v":0},{"$f":"IF(OR(BV3=1,AND(BW3=1,INT(OFFSET('Input Client Status'!$K$8,BU2,8))=0)),\"\",INT(OFFSET('Input Client Status'!$K$8,BU2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,BV2,9))","v":0},{"$f":"IF(BV3=1,\"\",INT(OFFSET('Input Client Status'!$K$8,BW2,7)))","v":0},{"$f":"'Input Client Status'!C64","v":""},{"$f":"IF(AND($BW3<>1,INT(OFFSET('Input Client Status'!$K$8,BY2,5))<>1,$BV3<>1),INT(OFFSET('Input Client Status'!$K$8,BY2,11)),\"\")","v":0},{"$f":"IF(AND($BW3<>1,INT(OFFSET('Input Client Status'!$K$8,BZ2,5))<>1,$BV3<>1),INT(OFFSET('Input Client Status'!$K$8,BZ2,11)),\"\")","v":0},{"$f":"IF(AND($BW3<>1,INT(OFFSET('Input Client Status'!$K$8,CA2,5))<>1,$BV3<>1),INT(OFFSET('Input Client Status'!$K$8,CA2,11)),\"\")","v":0},{"$f":"IF(AND(CC3=1,INT(OFFSET('Input Client Status'!$K$8,CB2,8))=0),\"\",INT(OFFSET('Input Client Status'!$K$8,CB2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,CC2,7))","v":0},{"$f":"'Input Client Status'!C70","v":""},{"$f":"IF(AND($CC3<>1,INT(OFFSET('Input Client Status'!$K$8,CE2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,CE2,11)),\"\")","v":0},{"$f":"IF(AND($CC3<>1,INT(OFFSET('Input Client Status'!$K$8,CF2,5))<>1),INT(OFFSET('Input Client Status'!$K$8,CF2,11)),\"\")","v":0},{"$f":"IF(OR(CH3=1,AND(CI3=1,INT(OFFSET('Input Client Status'!$K$8,CG2,8))=0)),\"\",INT(OFFSET('Input Client Status'!$K$8,CG2,8)))","v":0},{"$f":"INT(OFFSET('Input Client Status'!$K$8,CH2,9))","v":0},{"$f":"IF(CH3=1,\"\",INT(OFFSET('Input Client Status'!$K$8,CI2,7)))","v":0},{"$f":"'Input Client Status'!C77","v":""},{"$f":"IF(AND($CI3<>1,INT(OFFSET('Input Client Status'!$K$8,CK2,5))<>1,$CH3<>1),INT(OFFSET('Input Client Status'!$K$8,CK2,11)),\"\")","v":0},{"$f":"IF(AND($CI3<>1,INT(OFFSET('Input Client Status'!$K$8,CL2,5))<>1,$CH3<>1),INT(OFFSET('Input Client Status'!$K$8,CL2,11)),\"\")","v":0},{"$f":"IF(AND($CI3<>1,INT(OFFSET('Input Client Status'!$K$8,CM2,5))<>1,$CH3<>1),INT(OFFSET('Input Client Status'!$K$8,CM2,11)),\"\")","v":0}]

{"sheet":"Edit Instructions","index":4,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[33,1,33,15],[34,1,34,15],[35,1,35,15],[36,1,36,15],[28,1,28,15],[29,1,29,15],[30,1,30,15],[31,1,31,15],[32,1,32,15],[25,1,25,15],[26,1,26,15],[27,1,27,15],[22,1,22,15],[23,1,23,15],[24,1,24,15],[17,1,17,15],[18,1,18,15],[19,1,19,15],[20,1,20,15],[21,1,21,15],[12,1,12,15],[13,1,13,15],[14,1,14,15],[15,1,15,15],[16,1,16,15],[11,1,11,15],[0,1,0,15],[1,1,1,15],[3,1,3,15],[4,1,4,15],[5,1,5,15],[6,1,6,15],[7,1,7,15],[8,1,8,15],[9,1,9,15],[10,1,10,15]]}
[null,"Review, Edit, and Delete Instructions"]
[null,"These functions are currently available only using Excel® on Windows®. They are not available using Excel® on macOS® and IOS®. "]
[]
[null,"Review a record "]
[null,"If you would like to review a client record previously submitted:"]
[null,"·   Navigate to the blue “Review-Edit Existing Record” tab."]
[null,"·   From the “Client ID” drop-down box at the top of the screen, select the Client ID and date of assessment that you would like to review."]
[]
[]
[]
[]
[]
[]
[]
[null,"·   Once selected, the completed assessment for the given client and date will populate on the page."]
[]
[null,"Edit a record"]
[null,"If you would like to edit a client record previously submitted, follow the steps above for reviewing a record and then:"]
[null,"·   Click the “Edit Record” button at the top middle of the screen. You will see the red text above the button to change from “Read-only Mode” to “Edit Mode,” indicating you can now change previously submitted responses. Please note that while you can change the date for a given assessment, you are not able to change the Client ID."]
[null,"·   Edit your previously submitted responses as necessary."]
[null,"·  When you are satisfied with your selected responses, click “Submit Edited Record” button at the top of the page."]
[null,"·   This will overwrite the previously saved version of this Client ID record with your newly edited version. At this point, you cannot navigate back to the previously saved version of the assessment."]
[null,"·   Remember to save the Excel file after revising a record."]
[]
[null,"Delete a record "]
[null,"If you need to delete a client record, follow the steps above for reviewing a record and then:"]
[null,"·   Click the “Delete Record” button at the top right of the screen."]
[null,"·   A notice will pop-up reminding you that this action will permanently delete this record. Once you delete a record, it cannot be recovered.  Select OK to confirm this is an action you want to take.  "]
[null,"·   Remember to save the Excel file after deleting a record."]
[]
[null,"Tip: If you recently added client record(s) and you do not see the record(s) in the drop-down menu, try saving, closing and reopening the Excel file. "]

{"sheet":"Review-Edit Existing Record","index":5,"n_rows":80,"n_cols":51,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,2,0,6],[7,1,7,2],[8,1,8,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[9,7,10,7],[9,8,10,8],[11,1,11,2],[12,1,12,2],[15,1,15,2],[16,1,16,2],[19,1,19,7],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,24,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[31,1,31,2],[32,1,32,2],[33,1,33,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[25,8,26,8],[27,1,27,2],[28,1,28,2],[28,3,30,3],[28,4,30,4],[28,5,30,5],[28,6,30,6],[28,7,30,7],[28,8,30,8],[35,6,36,6],[35,7,36,7],[35,8,36,8],[37,1,37,2],[38,1,38,2],[39,3,41,3],[39,4,41,4],[39,5,41,5],[39,6,41,6],[39,7,41,7],[39,8,41,8],[40,1,40,2],[42,1,42,7],[43,1,43,2],[44,1,44,2],[45,3,47,3],[45,4,47,4],[45,5,47,5],[45,6,47,6],[45,7,47,7],[51,1,51,2],[53,1,53,7],[54,1,54,2],[55,3,56,3],[55,4,56,4],[55,5,56,5],[55,6,56,6],[55,7,56,7],[45,8,47,8],[46,1,46,2],[48,1,48,7],[49,1,49,2],[50,3,52,3],[50,4,52,4],[50,5,52,5],[50,6,52,6],[50,7,52,7],[50,8,52,8],[55,8,56,8],[57,1,57,2],[58,1,58,2],[61,1,62,2],[61,5,61,7],[63,3,65,3],[63,4,65,4],[63,5,65,5],[63,6,65,6],[63,7,65,7],[63,8,65,8],[64,1,64,2],[66,1,66,7],[67,1,67,2],[68,1,68,2],[68,3,70,3],[68,4,70,4],[68,5,70,5],[68,6,70,6],[68,7,70,7],[77,1,77,2],[78,1,78,2],[79,1,79,7],[68,8,70,8],[71,1,72,2],[73,1,73,2],[75,1,75,2],[75,3,78,3],[75,4,78,4],[75,5,78,5],[75,6,78,6],[75,7,78,7],[75,8,78,8]]}
[null,null,"Review/Edit Existing Record"]
[null,null,null,null,{"$f":"IF(L6=0,\"Edit Mode\",\"Read-Only Mode\")","v":"Read-Only Mode"},"Client Priority Goals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RecordID","ClientID","Date"]
[]
[]
[null,null,"Client ID:",null,null,"Number of priority goals:",{"$f":"IF(S6=0,\"\",S6)","v":""},null,null,{"$f":"IF(U6>0,\"Missing Data!\",\"\")","v":""},null,null,null,null,null,null,null,"Don't know","P Goals",null,null,null,null,null,"P Goals>0",null,null,null,{"$error":"#N/A"},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,2)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,3)),\"\",INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,3))","v":""}]
[null,null,"Date Completed:",null,null,"Average priority goal rating:",{"$f":"IF(X6=0,\"\",X6)","v":""},null,null,null,"Read-only",1,null,null,"Checks","Questions",{"$f":"COUNTIF(Q9:Q76,\">0\")+rngVEDoNotKnow","v":0},{"$f":"COUNTIF(R9:R80,TRUE)+COUNTIF(T9:T80,TRUE)","v":0},{"$f":"COUNTIF(S9:S80,TRUE)","v":0},"Missing",{"$f":"IF(ISERROR(SUM(U9:U76)),0,SUM(U9:U76))","v":0},null,"Priority",{"$f":"IF(Y6>0,SUM(X9:X80)/Y6,\"\")","v":""},{"$f":"COUNTIF(X9:X80,\">0\")","v":0},null,null,null,null,null,"Old values",null,null,null,null,null,null,null,null,"Offsets"]
[]
[null,"Outcome Categories",null,"Check the one box within each row that best applies to the client at this point in time.",null,null,null,null,"Intentionally Skipped",null,"In Crisis (1)","Vulnerable (2)","Stable (3)","Growing (4)","Thriving (5)","Skipped","Total","Don't know","Priority Goals","Not Applicable","Missing","Score","Average Score","PG Score","Skipped",null,null,null,"In Crisis (1)","Vulnerable (2)","Stable (3)","Growing (4)","Thriving (5)","Skipped",null,"Don't know","Priority Goals","Not Applicable",null,"Questions","Don't know","Priority Goals","Not Applicable",null,null,null,null,null,"RecordID","ClientID","DateCompleted"]
[null,"Behavioral Health\nBehavioral health may include mental health, emotional health, and substance use.",null,"Behavioral health issues seriously affect daily functioning","Behavioral health issues moderately affect daily functioning","Behavioral health issues mildly affect daily functioning","Behavioral health issues mildly and rarely affect daily functioning ","Behavioral health issues do not affect, or minimally affect, daily functioning",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K9:P9,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$11=FALSE,Q9=0,P9=FALSE),1,0)","v":0},{"$f":"(K9*1+L9*2+M9*3+N9*4+O9*5)","v":0},null,null,null,1,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN9)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN9)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN9)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN9)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN9)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN9)=0","v":{"$error":"#N/A"}},null,null,null,null,null,8]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W10),\"\",W10)","v":""},"Relies primarily on coping strategies that make one vulnerable and unsafe","Limited use of healthy coping or harm reduction strategies; frequent use of unhealthy strategies","Alternates among use of healthy coping, harm reduction, and unhealthy strategies","Frequent use of healthy coping strategies; limited use of harm reduction or unhealthy strategies","Relies primarily on healthy coping strategies; takes steps to implement self-care",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K10:P10,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$11=FALSE,Q10=0,P10=FALSE),1,0)","v":0},{"$f":"(K10*1+L10*2+M10*3+N10*4+O10*5)","v":0},{"$f":"IF(OR(R11=TRUE,(U9+U10)>0,(Q9+Q10)=0,(COUNTIF(P9:P10,TRUE)=SUM(Q9:Q10))),\"\",SUM(V9:V10)/((Q9+Q10)-COUNTIF(P9:P10,TRUE)))","v":""},{"$f":"IF(W10=\"\",\"\",W10*S10)","v":""},2,2,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN10)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN10)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN10)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN10)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN10)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN10)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP10)=1","v":{"$error":"#N/A"}},null,null,9,null,5]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,{"$f":"IF(COUNTIF(P9:P10,TRUE)=Y10,1,0)","v":0},3,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO11)=1","v":{"$error":"#N/A"}},null,null,null,null,6]
[null,"Physical Health\nPhysical health includes physical, sexual, reproductive, vision and dental health.",null,"Health issues seriously affect daily functioning ","Health issues moderately affect daily functioning","Health issues mildly affect daily functioning ","Health issues mildly and rarely affect daily functioning ","Health issues do not affect, or minimally affect, daily functioning",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K12:P12,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$15=FALSE,Q12=0,P12=FALSE),1,0)","v":0},{"$f":"(K12*1+L12*2+M12*3+N12*4+O12*5)","v":0},null,null,null,4,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN12)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN12)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN12)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN12)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN12)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN12)=0","v":{"$error":"#N/A"}},null,null,null,null,null,13]
[null,"\nDo not include behavioral health issues, including substance use, when rating a client in this category; behavioral health issues affecting the client should be included within the behavioral health category.",null,"No treatment or significant gaps in treatment and management of health issues","Health issues occasionally treated and managed","Health issues usually treated and managed ","Health issues consistently treated and managed","Health issues proactively treated and managed",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$15=FALSE,Q13=0,P13=FALSE),1,0)","v":0},0,null,null,null,5,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN13)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN13)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN13)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN13)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN13)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN13)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP13)=1","v":{"$error":"#N/A"}},null,null,14,null,10]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W15),\"\",W15)","v":""},"Does not understand basic health needs","Limited understanding of basic health needs ","Understands basic health needs ","Understands how to maintain health; can locate additional information as needed ","Understands how to maintain and improve health; can locate additional information as needed",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$15=FALSE,Q14=0,P14=FALSE),1,0)","v":0},0,null,null,4,6,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN14)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN14)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN14)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN14)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN14)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN14)=0","v":{"$error":"#N/A"}},null,null,null,null,null,15]
[null,"Don't know",null,"No access to health care or access through ER only","Limited access to health care","Access to basic health care","Access to basic health care and additional needed services (e.g. vision, dental)","Consistent and reliable access to basic health care and additional needed services (e.g. vision, dental)",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$15=FALSE,Q15=0,P15=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R15=TRUE,(U12+U13+U14+U15)>0,(Q12+Q13+Q14+Q15)=0,COUNTIF(P12:P15,TRUE)=4),\"\",SUM(V12:V15)/(SUM(Q12:Q15)-COUNTIF(P12:P15,TRUE)))","v":""},{"$f":"IF(W15=\"\",\"\",W15*S13)","v":""},{"$f":"IF(COUNTIF(P12:P15,TRUE)=Y14,1,0)","v":0},7,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN15)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN15)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN15)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN15)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN15)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN15)=0","v":{"$error":"#N/A"}},null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO15)=1","v":{"$error":"#N/A"}},null,null,null,16,11]
[null,"Safety\nThreats to physical, emotional, and financial safety and freedom can come from any source, including but not limited to a trafficker. ",null,"Serious and immediate threats to safety or freedom are known to exist","Moderate threats to safety or freedom are known to exist","Limited threats to safety are known to exist","Limited threats to safety are possible ","Threats to safety do not appear to exist 1",null,"Complete each row in category.",false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$19=FALSE,Q16=0,P16=FALSE),1,0)","v":0},0,null,null,null,8,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN16)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN16)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN16)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN16)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN16)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN16)=0","v":{"$error":"#N/A"}},null,null,null,null,null,20]
[null,"Safety plans and responses to threats do not necessarily include leaving trafficking or the abusive situation.",null,"No plans in place to protect safety or plans exist but cannot be implemented","Inadequate plans to protect safety or plans exist but uncertain whether they can be implemented","Adequate plans to protect safety ","Strong plans to protect safety ","Strong and flexible plans to protect safety ",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$19=FALSE,Q17=0,P17=FALSE),1,0)","v":0},0,null,null,3,9,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN17)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN17)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN17)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN17)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN17)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN17)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP17)=1","v":{"$error":"#N/A"}},null,null,21,null,17]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W18),\"\",W18)","v":""},"Does not recognize or consider threats to safety","Occasionally recognizes and considers threats to safety","Usually recognizes threats to safety and makes choices accordingly when possible","Consistently recognizes threats to safety and makes choices accordingly when possible","Takes steps to reduce or avoid threats to safety",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$19=FALSE,Q18=0,P18=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R19=TRUE,(U16+U17+U18)>0,(Q16+Q17+Q18)=0,COUNTIF(P16:P18,TRUE)=3),\"\",SUM(V16:V18)/(SUM(Q16:Q18)-COUNTIF(P16:P18,TRUE)))","v":""},{"$f":"IF(W18=\"\",\"\",W18*S17)","v":""},{"$f":"IF(COUNTIF(P16:P18,TRUE)=Y17,1,0)","v":0},10,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN18)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN18)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN18)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN18)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN18)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN18)=0","v":{"$error":"#N/A"}},null,null,null,null,null,22]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO19)=1","v":{"$error":"#N/A"}},null,null,null,null,18]
[null,"1Wording here reflects the understanding that victims and survivors may always experience the possibility of threats to safety.",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,12]
[null,"Housing",null,"Adults:","Adults:","Adults:","Adults:","Adults:",null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,13]
[null,"Adequate housing is safe, habitable, accessible and affordable (approximately one-third of income or less, including vouchers).",null,"Chronic homelessness or seriously inadequate shelter or housing","Intermittent homelessness, short-term shelter, or inadequate housing","Adequate time-limited housing available for at least the next 6 months  ","Adequate housing that is not time-limited","Housing is more than adequate, and is not time-limited",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K22:P22,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$27=FALSE,Q22=0,P22=FALSE),1,0)","v":0},{"$f":"(K22*1+L22*2+M22*3+N22*4+O22*5)","v":0},null,null,null,14,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN22)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN22)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN22)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN22)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN22)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN22)=0","v":{"$error":"#N/A"}},null,null,null,null,null,26]
[null,"Time-limited housing has a pre-determined maximum length of time that the client is allowed to live there.",null,"Unable to manage housing needs ","Manages housing needs and issues with significant help ","Manages housing needs and issues with occasional help ","Manages housing needs and issues independently","Manages housing needs and issues proactively; could find other suitable housing",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$27=FALSE,Q23=0,P23=FALSE),1,0)","v":0},0,null,null,null,15,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN23)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN23)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN23)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN23)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN23)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN23)=0","v":{"$error":"#N/A"}},null,null,null,null,null,27]
[null,"Minors: answer based on housing with parent/ guardian or other adult, child welfare placement, or independent living arrangement. ",null,"Minors:","Minors:","Minors:","Minors:","Minors:",null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,16]
[null,null,null,"Chronic homelessness, seriously inadequate shelter or housing ","Intermittent homelessness, short-term shelter, or inadequate housing ","Adequate time-limited housing available for at least the next 6 months","Adequate housing that is not time-limited ","Housing is more than adequate, and is not time-limited",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K25:P25,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$27=FALSE,Q25=0,P25=FALSE),1,0)","v":0},0,null,null,4,17,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN25)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN25)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN25)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN25)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN25)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN25)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP25)=1","v":{"$error":"#N/A"}},null,null,28,null,23]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W26),\"\",W26)","v":""},"Frequently lacks adequate housing owing to runaway/kickout episodes","Occasionally lacks adequate housing owing to runaway/kickout episodes","Parent/guardian manages housing needs and issues with occasional help","Parent/guardian manages housing needs and issues ","Parent/guardian manages housing needs and issues proactively; could find other suitable housing",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$27=FALSE,Q26=0,P26=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R27=TRUE,(U22+U23+U25+U26)>0,(Q22+Q23+Q25+Q26)=0,(SUM(Q22:Q23,Q25:Q26)=COUNTIF(P22:P26,TRUE))),\"\",SUM(V22:V23,V25:V26)/(SUM(Q22:Q23,Q25:Q26)-COUNTIF(P22:P26,TRUE)))","v":""},{"$f":"IF(W26=\"\",\"\",W26*S25)","v":""},{"$f":"IF(COUNTIF(P22:P26,TRUE)=Y25,1,0)","v":0},18,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN26)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN26)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN26)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN26)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN26)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN26)=0","v":{"$error":"#N/A"}},null,null,null,null,null,29]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO27)=1","v":{"$error":"#N/A"}},null,null,null,null,24]
[null,"Language and Literacy\nLanguage refers to functional speaking ability. \n\nLiteracy refers to the ability to read and write.\n",null,"Language seriously impedes daily activities or access to services","Language moderately impedes daily activities or access to services","Language mildly impedes daily activities or access to services, or limits ability to achieve short-term goals","Language is adequate for daily activities or access to services, and for achievement of short-term goals","Language is at least adequate for daily activities or access to services, and achievement of long-term goals.",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K28:P28,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$31=FALSE,Q28=0,P28=FALSE),1,0)","v":0},{"$f":"(K28*1+L28*2+M28*3+N28*4+O28*5)","v":0},null,null,2,20,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN28)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN28)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN28)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN28)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN28)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN28)=0","v":{"$error":"#N/A"}},null,null,null,null,null,33]
[null,"Language and literacy both refer to the language that the client needs to meet needs and achieve goals.",null,"Literacy seriously impedes daily activities or access to services","Literacy moderately impedes daily activities or access to services","Literacy mildly impedes daily activities or access to services, or limits ability to achieve short-term goals","Literacy is adequate for daily activities or access to services, and for achievement of short-term goals","Literacy is at least adequate for daily activities or access to services, and achievement of long-term goals",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$31=FALSE,Q29=0,P29=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R31=TRUE,(U28+U29)>0,(Q28+Q29)=0,(SUM(Q28:Q29)=COUNTIF(P28:P29,TRUE))),\"\",SUM(V28:V29)/(SUM(Q28:Q29)-COUNTIF(P28:P29,TRUE)))","v":""},{"$f":"IF(W29=\"\",\"\",W29*S29)","v":""},{"$f":"IF(COUNTIF(P28:P29,TRUE)=Y28,1,0)","v":0},21,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN29)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN29)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN29)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN29)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN29)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN29)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP29)=1","v":{"$error":"#N/A"}},null,null,34,null,30]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W29),\"\",W29)","v":""},null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,22]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,23,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO31)=1","v":{"$error":"#N/A"}},null,null,null,null,31]
[null,"Education",null,"Adult:","Adult:","Adult:","Adult:","Adult:",null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,24]
[null,"Education includes traditional and vocational school, GED, other vocational training, or language courses to improve employment or functioning in daily life. ",null,"No high school diploma or equivalent; educational status limits current employment ","No high school diploma or equivalent; educational status does not limit current employment ","High school equivalent (GED) ","High school diploma ","Some post-secondary education or training",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K33:P33,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$37=FALSE,Q33=0,P33=FALSE),1,0)","v":0},{"$f":"(K33*1+L33*2+M33*3+N33*4+O33*5)","v":0},null,null,null,25,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN33)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN33)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN33)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN33)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN33)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN33)=0","v":{"$error":"#N/A"}},null,null,null,null,null,38]
[null,"Stop out is an absence from school of more than 20 consecutive days for reasons other than illness, vacation, or injury.",null,"If the client is not working toward educational goals, select ‘Intentionally Skipped’ for this row","Working toward any educational goals with major assistance","Working toward any educational goals with moderate assistance","Working toward any educational goals with minor assistance","Manages any educational goals independently  ",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(L34:P34,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$37=FALSE,Q34=0,P34=FALSE),1,0)","v":0},{"$f":"(L34*0.25+M34*0.5+N34*0.75+O34*1)","v":0},null,null,null,26,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN34)=0.25","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN34)=0.5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN34)=0.75","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN34)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN34)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP34)=1","v":{"$error":"#N/A"}},null,null,39,null,35]
[null,null,null,"Minor:","Minor:","Minor:","Minor:","Minor:",null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,27]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W36),\"\",W36)","v":""},"Current core course enrollment is 3 or more grades below expected grade level; or current stop out, dropped out, pattern of chronic absenteeism, or other high risk of dropping out","Current core course enrollment is 1-2 grades below expected grade level; or recent stop out, frequent absenteeism, or other moderate risk of dropping out","Currently enrolled at expected grade level with passing grades in most core courses","Currently enrolled at expected grade level with passing grades in all core courses","Graduated or currently enrolled at expected grade level with passing grades in all courses and a C average or greater",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K36:P36,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$37=FALSE,Q36=0,P36=FALSE),1,0)","v":0},{"$f":"(K36*1+L36*2+M36*3+N36*4+O36*5)","v":0},{"$f":"IF(OR(R37=TRUE,(U33+U34+U36)>0,(Q33+Q34+Q36)=0,AND(P33=TRUE,P34=TRUE,P36=TRUE)),\"\",IF(V33=5,V33,SUM(V33:V34,V36)))","v":""},{"$f":"IF(W36=\"\",\"\",W36*S34)","v":""},{"$f":"IF(AND(P33=TRUE,P34=TRUE,P36=TRUE),1,0)","v":0},28,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN36)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN36)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN36)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN36)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN36)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN36)=0","v":{"$error":"#N/A"}},null,null,null,null,null,40]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO37)=1","v":{"$error":"#N/A"}},null,null,null,null,36]
[null,"Employment\nSufficient employment consistently provides adequate income to meet basic needs.\n\nWork readiness skills include personal characteristics and behavioral skills that enhance interactions and job performance, such as adaptability, integrity, cooperation, and task focus.",null,"Chronic unemployment, exploitive or risky work ","Frequently unemployed, or relies primarily on exploitive or risky work ","Usually employed with minimally sufficient income ","Usually employed with sufficient income ","Stable employment with sufficient income, possible opportunities for growth",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K38:P38,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R42=FALSE,T41=FALSE,Q38=0,P38=FALSE),1,0)","v":0},{"$f":"(K38*1+L38*2+M38*3+N38*4+O38*5)","v":0},null,null,null,30,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN38)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN38)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN38)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN38)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN38)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN38)=0","v":{"$error":"#N/A"}},null,null,null,null,null,45]
[null,"You may select “Intentionally  Skipped” for the first row if:\n• The client is a foreign national without work authorization\n• The client is in a full-time education or training program",null,"Insufficient work readiness skills","Work readiness skills are limited and a barrier to sustained employment","Work readiness sufficient to sustain a job","Work readiness skills to function well in a job ","Work readiness skills to obtain different job if needed",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R42=FALSE,T41=FALSE,Q39=0,P39=FALSE),1,0)","v":0},0,null,null,3,31,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN39)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN39)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN39)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN39)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN39)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN39)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP39)=1","v":{"$error":"#N/A"}},null,null,46,null,41]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W40),\"\",W40)","v":""},"No defined job skills","Job skills are limited","Job skills sufficient to sustain a job","Job skills to function well in a job","Job skills to advance within a work setting",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R42=FALSE,T41=FALSE,Q40=0,P40=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R42=TRUE,T41=TRUE,(U38+U39+U40)>0,(Q38+Q39+Q40)=0,(SUM(Q38:Q40)=COUNTIF(P38:P40,TRUE))),\"\",SUM(V38:V40)/(SUM(Q38:Q40)-COUNTIF(P38:P40,TRUE)))","v":""},{"$f":"IF(W40=\"\",\"\",W40*S39)","v":""},{"$f":"IF(COUNTIF(P38:P40,TRUE)=Y39,1,0)","v":0},32,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN40)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN40)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN40)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN40)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN40)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN40)=0","v":{"$error":"#N/A"}},null,null,null,null,null,47]
[null,"Not Applicable2",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,33,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AQ41)=1","v":{"$error":"#N/A"}},null,null,null,null,42]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,34,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO42)=1","v":{"$error":"#N/A"}},null,null,null,null,43]
[null,"2Employment: Not Applicable if client is under 16.",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,35]
[null,"Resource Management\nBasic needs can include shelter, food, clothing, hygiene, transportation, etc. These may be met through resources such as wages, family, community, benefits or other ways.",null,"Frequently goes without basic needs being met, or frequently meets needs through exploitive or risky means","Occasionally meets basic needs; may occasionally meet needs through exploitive or risky means","Usually meets basic needs through safe, legal means","Consistently meets basic needs and manages occasional crises through safe, legal means","Meets basic needs and beyond, with resources for occasional crises through safe, legal means",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K44:P44,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$48=FALSE,T$47=FALSE,Q44=0,P44=FALSE),1,0)","v":0},0,null,null,null,36,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN44)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN44)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN44)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN44)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN44)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN44)=0","v":{"$error":"#N/A"}},null,null,null,null,null,52]
[null,"Although clients may have to make the best decision possible within limited options, the last row of boxes refers to decisions that can make a situation worse.",null,"Lacks skills to manage resources","Limited skills to manage resources","Basic skills to manage resources","Has skills to consistently manage resources","Has skills to manage resources for current and future needs; maintains some reserves",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$48=FALSE,T$47=FALSE,Q45=0,P45=FALSE),1,0)","v":0},0,null,null,3,37,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN45)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN45)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN45)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN45)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN45)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN45)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP45)=1","v":{"$error":"#N/A"}},null,null,53,null,48]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W46),\"\",W46)","v":""},"Often makes decisions that make financial challenges worse","Sometimes makes decisions that make financial challenges worse","Occasionally makes decisions that make financial challenges worse","Usually makes decisions consistent with predictable needs","Routinely makes decisions consistent with predictable needs",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$48=FALSE,T$47=FALSE,Q46=0,P46=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R48=TRUE,T47=TRUE,(U44+U45+U46)>0,(Q44+Q45+Q46)=0,(SUM(Q44:Q46)=COUNTIF(P44:P46,TRUE))),\"\",SUM(V44:V46)/(SUM(Q44:Q46)-COUNTIF(P44:P46,TRUE)))","v":""},{"$f":"IF(W46=\"\",\"\",W46*S45)","v":""},{"$f":"IF(COUNTIF(P44:P46,TRUE)=Y45,1,0)","v":0},38,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN46)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN46)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN46)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN46)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN46)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN46)=0","v":{"$error":"#N/A"}},null,null,null,null,null,54]
[null,"Not Applicable3",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,39,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AQ47)=1","v":{"$error":"#N/A"}},null,null,null,null,49]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO48)=1","v":{"$error":"#N/A"}},null,null,null,null,50]
[null,"3Resources Management: Not applicable if client is under 18 and supported by parent or caregiver.",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,41]
[null,"Public Benefits\nPublic benefits include programs the client needs and qualifies for, such as food stamps, cash assistance, WIC, disability, childcare, or housing subsidies.\n\nLanguage assistance may be needed by any client regardless of ability to navigate benefits processes.",null,"Not receiving any needed public benefits","Receiving few needed public benefits","Receiving some needed public benefits","Receiving most needed public benefits","Receiving all needed public benefits, or does not need public benefits",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K50:P50,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$53=FALSE,T$52=FALSE,Q50=0,P50=FALSE),1,0)","v":0},{"$f":"(K50*1+L50*2+M50*3+N50*4+O50*5)","v":0},null,null,2,42,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN50)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN50)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN50)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN50)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN50)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN50)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP50)=1","v":{"$error":"#N/A"}},null,null,59,null,55]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W51),\"\",W51)","v":""},"Unaware of or unable to take steps to obtain benefits, with or without assistance","Participates in benefit application processes, but relies heavily upon assistance","Navigates benefit application processes with some assistance  ","Navigates benefit application processes with minimal assistance","Applies for and maintains needed benefits with minimal assistance",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$53=FALSE,T$52=FALSE,Q51=0,P51=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R53=TRUE,T52=TRUE,(U50+U51)>0,(Q50+Q51)=0,(SUM(Q50:Q51)=COUNTIF(P50:P51,TRUE))),\"\",SUM(V50:V51)/(SUM(Q50:Q51)-COUNTIF(P50:P51,TRUE)))","v":""},{"$f":"IF(W51=\"\",\"\",W51*S50)","v":""},{"$f":"IF(COUNTIF(P50:P51,TRUE)=Y50,1,0)","v":0},43,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN51)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN51)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN51)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN51)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN51)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN51)=0","v":{"$error":"#N/A"}},null,null,null,null,null,60]
[null,"Not Applicable4",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,44,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AQ52)=1","v":{"$error":"#N/A"}},null,null,null,null,56]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,45,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO53)=1","v":{"$error":"#N/A"}},null,null,null,null,57]
[null,"4Public benefits: Not applicable if client is under 18 and supported by parent or caregiver, is in foster care, or does not qualify for public benefits (for example, is a foreign national).",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,46]
[null,"Life Skills\nLife skills are the age-appropriate skills to meet daily tasks of independent living (for example, making purchases, preparing food, using transportation) in one’s current environment.",null,"Requires assistance with many basic tasks","Manages some basic tasks; does not seek assistance when needed ","Manages most tasks; sometime seeks assistance when needed","Manages most tasks; usually seeks assistance when needed ","Full functioning on tasks; seeks assistance when needed; builds new skills when needed",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K55:P55,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$57=FALSE,Q55=0,P55=FALSE),1,0)","v":0},{"$f":"(K55*1+L55*2+M55*3+N55*4+O55*5)","v":0},null,null,2,47,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN55)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN55)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN55)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN55)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN55)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN55)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP55)=1","v":{"$error":"#N/A"}},null,null,64,null,61]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W56),\"\",W56)","v":""},"Takes steps based on immediate survival needs","Responds to crises, but may not address non-urgent problems","Addresses problems before they become more serious, to the extent possible","Takes steps to avoid problems, to the extent possible","Takes proactive steps to improve circumstances, to the extent possible",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$57=FALSE,Q56=0,P56=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R57=TRUE,(U55+U56)>0,(Q55+Q56)=0,(SUM(Q55:Q56)=COUNTIF(P55:P56,TRUE))),\"\",SUM(V55:V56)/(SUM(Q55:Q56)-COUNTIF(P55:P56,TRUE)))","v":""},{"$f":"IF(W56=\"\",\"\",W56*S55)","v":""},{"$f":"IF(COUNTIF(P55:P56,TRUE)=Y55,1,0)","v":0},48,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN56)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN56)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN56)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN56)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN56)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN56)=0","v":{"$error":"#N/A"}},null,null,null,null,null,65]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,49,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO57)=1","v":{"$error":"#N/A"}},null,null,null,null,62]
[null,"Legal\nLegal issues may include criminal or juvenile justice offenses; expungement of previous offenses; civil issues that impact well-being; or rights as a crime victim. ",null,"Felony or serious juvenile charges; no legal assistance","Felony or serious juvenile charges; receiving legal assistance ","Misdemeanor criminal or juvenile charges; receiving legal assistance OR felony or serious juvenile charges with favorable resolution likely","Misdemeanor criminal or juvenile charges with favorable resolution likely","No outstanding criminal or juvenile charges",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K58:P58,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$61=FALSE,Q58=0,P58=FALSE),1,0)","v":0},0,null,null,null,50,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN58)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN58)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN58)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN58)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN58)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN58)=0","v":{"$error":"#N/A"}},null,null,null,null,null,69]
[null,"Favorable resolution to charges may consist of outcomes such as dismissal, diversion, or deferred prosecution. ",null,"Not compliant with probation, parole, or court orders","Some probation, parole, or court order concerns","No more than minor probation, parole, or court order issues","Full compliance with probation, parole, or court orders ","No probation, parole, or court ordered conditions",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$61=FALSE,Q59=0,P59=FALSE),1,0)","v":0},0,null,null,null,51,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN59)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN59)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN59)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN59)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN59)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN59)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP59)=1","v":{"$error":"#N/A"}},null,null,70,null,66]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W61),\"\",W61)","v":""},"Does not understand legal issues","Has a limited understanding of legal issues","Somewhat understands legal issues as they apply to current circumstances","Understands most legal issues as they apply to current circumstances","Understands legal options and knows how to obtain more information if needed",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$61=FALSE,Q60=0,P60=FALSE),1,0)","v":0},0,null,null,4,52,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN60)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN60)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN60)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN60)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN60)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN60)=0","v":{"$error":"#N/A"}},null,null,null,null,null,71]
[null,"Don't know",null,"Major unresolved civil or victim’s rights issues","Significant civil or victim’s rights issues","Minor or moderate unresolved civil or victim’s rights issues ","Addressing most civil or victim’s rights issues","Addressing any civil or victim’s rights issues",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$61=FALSE,Q61=0,P61=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R61=TRUE,(U58+U59+U60+U61)>0,(Q58+Q59+Q60+Q61)=0,(SUM(Q58:Q61)=COUNTIF(P58:P61,TRUE))),\"\",SUM(V58:V61)/(SUM(Q58:Q61)-COUNTIF(P58:P61,TRUE)))","v":""},{"$f":"IF(W61=\"\",\"\",W61*S59)","v":""},{"$f":"IF(COUNTIF(P58:P61,TRUE)=Y60,1,0)","v":0},53,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN61)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN61)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN61)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN61)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN61)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN61)=0","v":{"$error":"#N/A"}},null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO61)=1","v":{"$error":"#N/A"}},null,null,null,72,67]
[null,"Immigration\nTemporary statuses include those directly related to trafficking victimization (for example, T or U Visa, Continued Presence), and others (for example, H-2A, fiancé visa). ",null,"Currently detained, or in imminent danger of detention or deportation","Risk of detention or deportation ","If the client is not at risk of detention or deportation, \nselect ‘Intentionally Skipped’ for this row.",null,null,null,"Complete each row in category.",false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$66=FALSE,T$65=FALSE,Q62=0,P62=FALSE),1,0)","v":0},{"$f":"(K62*1+L62*2)","v":0},null,null,null,54,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN62)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN62)=2","v":{"$error":"#N/A"}},null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN62)=0","v":{"$error":"#N/A"}},null,null,null,null,null,77]
[null,null,null,"Undocumented status, or imminently expiring temporary status, and not receiving assistance with immigration issues","Undocumented status, or imminently expiring temporary status, and receiving assistance with immigration issues","Temporary status; application for longer term status has not yet been initiated","Temporary status; application for longer term status has been initiated ","Long term status, or application for long term status submitted",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$66=FALSE,T$65=FALSE,Q63=0,P63=FALSE),1,0)","v":0},{"$f":"(K63*1+L63*2+M63*3+N63*4+O63*5)","v":0},null,null,3,55,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN63)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN63)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN63)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN63)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN63)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN63)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP63)=1","v":{"$error":"#N/A"}},null,null,78,null,73]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W64),\"\",W64)","v":""},"No understanding of immigration-related rights or requirements ","Limited understanding of immigration-related rights and requirements","Understands immigration-related rights and requirements; can advocate for rights with some assistance","Understands immigration-related rights and requirements; can advocate for rights with limited assistance","Understands immigration-related rights and requirements; able to advocate for rights independently or with limited assistance",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$66=FALSE,T$65=FALSE,Q64=0,P64=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R66=TRUE,T65=TRUE,(U62+U63+U64)>0,(Q62+Q63+Q64)=0,(SUM(Q62:Q64)=COUNTIF(P62:P64,TRUE))),\"\",SUM(V62:V64)/(SUM(Q62:Q64)-COUNTIF(P62:P64,TRUE)))","v":""},{"$f":"IF(W64=\"\",\"\",W64*S63)","v":""},{"$f":"IF(COUNTIF(P62:P64,TRUE)=Y63,1,0)","v":0},56,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN64)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN64)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN64)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN64)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN64)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN64)=0","v":{"$error":"#N/A"}},null,null,null,null,null,79]
[null,"Not Applicable5",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,57,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AQ65)=1","v":{"$error":"#N/A"}},null,null,null,null,74]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,58,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO66)=1","v":{"$error":"#N/A"}},null,null,null,null,75]
[null,"5Immigration: Not Applicable if client is a citizen, or is a non-citizen/non-legal permanent resident who does not want to stay in the US.",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,59]
[null,"Social Support\nSocial support may include support from family, friends, or others.",null,"No current social support or only social support that facilitates risky behavior or exploitation","Limited and inconsistent social support ","Limited but reliable social support ","Reliable and growing social support ","Diverse and reliable social support",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K68:P68,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$71=FALSE,Q68=0,P68=FALSE),1,0)","v":0},{"$f":"(K68*1+L68*2+M68*3+N68*4+O68*5)","v":0},null,null,2,60,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN68)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN68)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN68)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN68)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN68)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN68)=0","v":{"$error":"#N/A"}},null,null,null,null,null,83]
[null,"Positive social support is emotional, material, or practical support that does not expose client to harm or exploitation.",null,"Does not seek positive social support; unable to engage or maintain positive relationships; or socially isolated","Intermittently seeks positive social support but has limited ability to engage or maintain positive relationships; or somewhat socially isolated","Usually seeks positive social support; learning to cultivate positive relationship(s)","Cultivates positive relationship(s)","Cultivates and maintains positive relationship(s)",null,null,false,false,false,false,false,false,0,false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$71=FALSE,Q69=0,P69=FALSE),1,0)","v":0},0,{"$f":"IF(OR(R71=TRUE,(U68+U69)>0,(Q68+Q69)=0,(SUM(Q68:Q69)=COUNTIF(P68:P69,TRUE))),\"\",SUM(V68:V69)/(SUM(Q68:Q69)-COUNTIF(P68:P69,TRUE)))","v":""},{"$f":"IF(W69=\"\",\"\",W69*S69)","v":""},{"$f":"IF(COUNTIF(P68:P69,TRUE)=Y68,1,0)","v":0},61,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN69)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN69)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN69)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN69)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN69)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN69)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP69)=1","v":{"$error":"#N/A"}},null,null,84,null,80]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W69),\"\",W69)","v":""},null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,62]
[null,"Don't know",null,null,null,null,null,null,null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,63,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO71)=1","v":{"$error":"#N/A"}},null,null,null,null,81]
[null,"Parenting\nChild(ren)’s needs include age-appropriate material, developmental, educational, and emotional needs. ",null,"Often has difficulty meeting child(ren)’s needs, requires substantial assistance","Sometimes has difficulty meeting child(ren)’s needs, may require substantial assistance","Usually able to meet child(ren)’s needs, may require moderate assistance ","Consistently able to meet child(ren)’s needs, may require moderate assistance ","Consistently able to meet child(ren)’s needs, may require minor assistance ",null,"Complete each row in category.",false,false,false,false,false,false,{"$f":"COUNTIF(K72:P72,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$79=FALSE,T$78=FALSE,Q72=0,P72=FALSE),1,0)","v":0},{"$f":"(K72*1+L72*2+M72*3+N72*4+O72*5)","v":0},null,null,null,64,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN72)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN72)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN72)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN72)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN72)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN72)=0","v":{"$error":"#N/A"}},null,null,null,null,null,89]
[null,null,null,"If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ","If child(ren) cared for by another parent/caregiver (not in custody of child welfare): ",null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,null,65]
[null,"Selecting a box that includes \"does not meet needs\" is not a statement of child abuse or neglect.   ",null,"Desires, but does not have, access to non-custodial child(ren) ","Significantly less than desired contact with non-custodial child(ren)","Somewhat less than desired contact with non-custodial child(ren)","Typically has desired amount of contact with non-custodial child(ren)","Consistently has desired amount of contact with non-custodial child(ren)",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K74:P74,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$79=FALSE,T$78=FALSE,Q74=0,P74=FALSE),1,0)","v":0},{"$f":"(K74*1+L74*2+M74*3+N74*4+O74*5)","v":0},null,null,null,66,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN74)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN74)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN74)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN74)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN74)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN74)=0","v":{"$error":"#N/A"}},null,null,null,null,null,90]
[null,null,null,"If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ","If child(ren) in child welfare custody: ",null,null,false,false,false,false,false,false,null,false,false,false,null,null,null,null,3,67]
[null,"Complete all applicable rows if client’s children are in different situations (for example, one living with client and one with another parent or caregiver).",null,"Consistently non-compliant with requirements of child welfare agency ","Inconsistently meets requirements of child welfare agency ","Meets requirements of child welfare agency with occasional setbacks","Consistently meeting requirements of child welfare agency ","Involvement with child welfare agency moving steadily toward resolution",null,null,false,false,false,false,false,false,{"$f":"COUNTIF(K76:P76,TRUE)","v":0},false,false,false,{"$f":"IF(AND(rngVENSelections>0,R$79=FALSE,T$78=FALSE,Q76=0,P76=FALSE),1,0)","v":0},{"$f":"(K76*1+L76*2+M76*3+N76*4+O76*5)","v":0},{"$f":"IF(OR(R79=TRUE,T78=TRUE,(U72+U74+U76)>0,(Q72+Q74+Q76)=0,(SUM(Q72,Q74,Q76)=COUNTIF(P72:P76,TRUE))),\"\",SUM(V72,V74,V76)/(SUM(Q72,Q74,Q76)-COUNTIF(P72:P76,TRUE)))","v":""},{"$f":"IF(W76=\"\",\"\",W76*S76)","v":""},{"$f":"IF(COUNTIF(P72:P76,TRUE)=Y75,1,0)","v":0},68,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN76)=1","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN76)=2","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN76)=3","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN76)=4","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN76)=5","v":{"$error":"#N/A"}},{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AN76)=0","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AP76)=1","v":{"$error":"#N/A"}},null,null,91,null,85]
[null,"Summary Rating:",{"$f":"IF(ISERROR(W76),\"\",W76)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,null,null,null,null,null,69]
[null,"Not Applicable6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,null,null,null,null,null,70,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AQ78)=1","v":{"$error":"#N/A"}},null,null,null,null,86]
[null,"Don't know",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,null,null,null,null,null,71,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(rngCS_DataTable,MATCH(rngVE_RecID,'Client Status Data'!$A:$A,0)-1,$AO79)=1","v":{"$error":"#N/A"}},null,null,null,null,87]
[null,"6Parenting: Not applicable if client has no children or does not intend to be involved with children in custody of another caregiver or child welfare system.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]

{"sheet":"Client Status Data","index":6,"n_rows":1,"n_cols":91,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["RecordID","ClientID","DateCompleted","client_priority_rating","behavior_health_priority","behavior_health_dk","behavior_health_rating","behavior_health_q1","behavior_health_q2","physical_health_priority","physical_health_dk","physical_health_rating","physical_health_q1","physical_health_q2","physical_health_q3","physical_health_q4","safety_priority","safety_dk","safety_rating","safety_q1","safety_q2","safety_q3","housing_priority","housing_dk","housing_rating","housing_q1","housing_q2","housing_q3","housing_q4","language_priority","language_dk","language_rating","language_q1","language_q2","education_priority","education_dk","education_rating","education_q1","education_q2","education_q3","employment_priority","employment_na","employment_dk","employment_rating","employment_q1","employment_q2","employment_q3","resource_priority","resource_na","resource_dk","resource_rating","resource_q1","resource_q2","resource_q3","public_benefits_priority","public_benefits_na","public_benefits_dk","public_benefits_rating","public_benefits_q1","public_benefits_q2","life_skills_priority","life_skills_dk","life_skills_rating","life_skills_q1","life_skills_q2","legal_priority","legal_dk","legal_rating","legal_q1","legal_q2","legal_q3","legal_q4","immigration_priority","immigration_na","immigration_dk","immigration_rating","immigration_q1","immigration_q2","immigration_q3","social_support_priority","social_support_dk","social_support_rating","social_support_q1","social_support_q2","parenting_priority","parenting_na","parenting_dk","parenting_rating","parenting_q1","parenting_q2","parenting_q3"]

{"sheet":"Output Instructions","index":7,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,1,39,15],[40,1,40,15],[35,1,35,15],[36,1,36,15],[37,1,37,15],[38,1,38,15],[30,1,30,15],[31,1,31,15],[32,1,32,15],[33,1,33,15],[34,1,34,15],[12,1,12,15],[13,1,13,15],[14,1,14,15],[28,1,28,15],[29,1,29,15],[21,1,21,15],[24,1,24,15],[27,1,27,14],[26,1,26,15],[25,1,25,15],[7,1,7,15],[8,1,8,15],[9,1,9,15],[10,1,10,15],[11,1,11,15],[6,1,6,15],[0,1,0,15],[1,1,1,15],[3,1,3,15],[4,1,4,15],[5,1,5,15]]}
[null,"Output Instructions and Interpretation"]
[null,"These functions are currently available only using Excel® on Windows®. They are not available using Excel® on macOS® and IOS®. "]
[]
[null,"Client Single Assessment Summary –  Rating by Outcome Category"]
[null,"Instructions: "]
[null,"·   Navigate to the green “Single Assessment Summary” tab."]
[null,"·   From the “Client ID” drop-down box at the top left of the screen, select the client ID and date of assessment you are interested in."]
[null,"·   Once selected, the data for that client on that date will automatically populate."]
[]
[null,"Use and Interpretation:"]
[null,"·    This tab provides summary data on the outcomes for an individual client on the selected date of assessment. This summary may assist you in identifying areas in which the client is doing well or experiencing challenges, and may help in comparing the client’s progress at different points in time."]
[]
[null,"·   The Box at middle left provides the average and range of the client’s summary ratings across all outcome categories on a scale from 1 to 5."]
[null,"·   The Table at lower left provides the client’s summary ratings for each outcome category on a scale from 1 to 5. Categories the client identified as priority are denoted with an asterisk (*) new to the summary rating. The Graph at right provides data visualization of the same information. All categories are represented in blue. Categories that the client identified as priority are represented in orange."]
[]
[null,"Client Change Over Time –  Multiple Assessment Summary, Overall Average Ratings Over Time"]
[null,"Instructions:"]
[null,"·   Navigate to the green “Client Change Over Time”  tab."]
[null,"·   From the “Client ID” drop-down box at the top left of the screen, select the client ID you are interested in."]
[null,"·   Once the Client ID is selected, the data for assessments for that client will automatically populate."]
[]
[null,"·  Note: This display can show summaries of a maximum of ten assessments.  If this client’s data includes more than ten assessments, the summary will show the first assessment followed by the nine most recent assessments."]
[]
[null,"Use and Interpretation: "]
[null,"·   This tab provides summary data on the outcomes for an individual client over time.  The summary may assist you in identifying  areas in which the client’s circumstances are changing over time."]
[null,"·   Summary scores may increase over time as clients make progress toward outcomes.  However, it is not unusual for summary scores to decrease as clients encounter new challenges.  "]
[null,"·   The Table at the bottom provides the client’s summary ratings for each outcome category on a scale from 1 to 5, for each assessment. Categories the client identified as a priority are denoted with an asterisk (*) next to the summary rating.  The Graph at the top plots of the overall average at each assessment over time. "]
[]
[null,"Program-Level Summary –  Average Summary Ratings Across Clients by Outcome Category"]
[null,"Instructions: "]
[null,"·   Navigate to the green “Program Summary” tab."]
[null,"·   Select the date range of interested by inputting your preferred start date and preferred end date."]
[]
[null,"· Note: The populated data will include only the most recent assessment for each client during the selected time range.  No assessments completed outside of this date range will be included in this summary."]
[]
[null,"Use and Interpretation:"]
[null,"·   This tab provides summary data on the most recent rating for all clients with assessments during the chosen date range. No assessments completed outside of this date range will be included in this summary."]
[null,"·   This tool may help you understand average outcome ratings across all clients. "]
[]
[null,"·   The Box at the middle left provides the number of included clients who received at least one assessment during the selected date range, and the average and range of summary ratings across all clients and all outcome categories on a scale from 1 to 5."]
[null,"·   The Table at the lower left provides the average summary ratings across all included clients for each outcome category on a scale from 1 to 5. The Graph at right provides a visualization of the same information."]
[]
[null,"Tip: If you recently added client record(s) and you do not see the record(s) in the drop-down menu, try saving, closing and reopening the Excel file. "]

{"sheet":"Single Assessment Summary","index":8,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,11]]}
[null,"Client Single Assessment Summary – Rating by Outcome Category"]
[null,"Client ID",{"$error":"#N/A"}]
[null,"Record Date",{"$f":"IF(ISERROR(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,3)),\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,3))","v":""}]
[]
[]
[null,null,"All Categories","Client Priority Categories"]
[null,"Average rating",{"$f":"ROUND(AVERAGE(D12:D25),1)","v":0},{"$f":"IF(ISERROR(AVERAGEIF(O12:O25,\"=1\",D12:D25)),\"\",ROUND(AVERAGEIF(O12:O25,\"=1\",D12:D25),1))","v":""}]
[null,"Range",{"$f":"TEXT(MIN(D12:D25),\"0.0\")&\" to \"&TEXT(MAX(D12:D25),\"0.0\")","v":"0.0 to 0.0"},{"$f":"IF(D7=\"\",\"\",TEXT(MIN(F12:F25),\"0.0\")&\" to \"&TEXT(MAX(F12:F25),\"0.0\"))","v":""}]
[]
[]
[null,"Outcome Category",null,"Summary Rating",null,null,null,null,null,null,null,null,null,"Rating","Priority"]
[null,"Behavioral Health ",null,{"$f":"IF(ISERROR(N12),0,N12)","v":0},{"$f":"IF(ISERROR(O12),\"\",IF(O12=1,\"*\",\"\"))","v":""},{"$f":"IF(E12=\"*\",D12,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,7)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,7))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,5)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Physical Health",null,{"$f":"IF(ISERROR(N13),0,N13)","v":0},{"$f":"IF(ISERROR(O13),\"\",IF(O13=1,\"*\",\"\"))","v":""},{"$f":"IF(E13=\"*\",D13,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,12)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,12))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,10)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Safety",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,19)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,19))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,17)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Housing",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,25)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,25))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,23)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Language and Literacy",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,32)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,32))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,30)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Education",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,37)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,37))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,35)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Employment",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,44)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,44))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,41)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Resource Management",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,51)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,51))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,48)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Public Benefits",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,58)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,58))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,55)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Life Skills",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,63)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,63))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,61)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Legal",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,68)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,68))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,66)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Immigration",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,76)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,76))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,73)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Social Support ",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,82)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,82))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,80)=1,1,\"\")","v":{"$error":"#N/A"}}]
[null,"Parenting",null,0,"","",null,null,null,null,null,null,null,{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,88)=\"\",\"\",INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,88))","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(rngCS_DataTable,MATCH(rngChart1RecID,'Client Status Data'!$A:$A,0)-1,85)=1,1,\"\")","v":{"$error":"#N/A"}}]
[]
[null,"* Indicates client-identified priority category"]

{"sheet":"Client Change Over Time","index":9,"n_rows":39,"n_cols":26,"rows_kept":39,"cut":false,"hidden":false,"merged":[[18,3,18,21],[0,1,0,23],[38,1,38,23]]}
[null,"Client Multiple Assessment Summary- Average Ratings over Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ClientID"]
[null,"Client ID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Client Summary Ratings by Outcome Categories"]
[null,"Outcome Category",null,"2020-09-02"]
[null,"Behavioral Health "]
[null,"Physical Health"]
[null,"Safety"]
[null,"Housing"]
[null,"Language and Literacy"]
[null,"Education"]
[null,"Employment"]
[null,"Resource Management"]
[null,"Public Benefits"]
[null,"Life Skills"]
[null,"Legal"]
[null,"Immigration"]
[null,"Social Support "]
[null,"Parenting"]
[]
[null,"OVERALL Average",null,{"$f":"IF(ISERROR(AVERAGE(D21:D34)),\"\",AVERAGE(D21:D34))","v":""},null,{"$f":"IF(ISERROR(AVERAGE(F21:F34)),\"\",AVERAGE(F21:F34))","v":""},null,{"$f":"IF(ISERROR(AVERAGE(H21:H34)),\"\",AVERAGE(H21:H34))","v":""},null,{"$f":"IF(ISERROR(AVERAGE(J21:J34)),\"\",AVERAGE(J21:J34))","v":""},null,{"$f":"IF(ISERROR(AVERAGE(L21:L34)),\"\",AVERAGE(L21:L34))","v":""},null,"",null,"",null,"",null,"",null,""]
[]
[]
[null,"Note: This display can show summaries of a maximum of ten assessments.  If this client’s data includes more than ten assessments, the summary will show the first assessment followed by the nine most recent assessments."]

{"sheet":"Program Summary","index":10,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[11,4,12,4],[0,1,0,13]]}
[null,"Program-Level Summary – Average Summary Ratings Across Clients by Outcome Category"]
[null,"Includes the most recent assessment for each client seen during the selected date range. "]
[]
[null,null,"Input Start Date",null,"Input End Date"]
[null,"Date range",null,"to"]
[null,"Number of clients",{"$f":"IF(ISERROR(R14),0,R14)","v":0}]
[null,"Average rating",{"$f":"ROUND(IF(R14=0,0,IF(ISERROR(AVERAGE(Q14:Q27)),0,AVERAGE(Q14:Q27))),1)","v":0}]
[null,"Range",{"$f":"TEXT(MIN(E14:E27),\"0.0\")&\" to \"&TEXT(MAX(E14:E27),\"0.0\")","v":"0.0 to 0.0"}]
[]
[]
[]
[null,null,null,null,"Average Summary Rating"]
[null,"Outcome Category",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ratings","# clients"]
[null,"Behavioral Health ",null,null,{"$f":"Q14","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!G:G),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!G:G),1))","v":""},{"$f":"IF(COUNTA(Program_Chart_Output!A:A)-1<0,0,COUNTA(Program_Chart_Output!A:A)-1)","v":0}]
[null,"Physical Health",null,null,{"$f":"Q15","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!L:L),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!L:L),1))","v":""}]
[null,"Safety",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!S:S),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!S:S),1))","v":""}]
[null,"Housing",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!Y:Y),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!Y:Y),1))","v":""}]
[null,"Language and Literacy",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!AF:AF),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!AF:AF),1))","v":""}]
[null,"Education",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!AK:AK),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!AK:AK),1))","v":""}]
[null,"Employment",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!AR:AR),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!AR:AR),1))","v":""}]
[null,"Resource Management",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!AY:AY),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!AY:AY),1))","v":""}]
[null,"Public Benefits",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!BF:BF),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!BF:BF),1))","v":""}]
[null,"Life Skills",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!BK:BK),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!BK:BK),1))","v":""}]
[null,"Legal",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!BP:BP),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!BP:BP),1))","v":""}]
[null,"Immigration",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!BX:BX),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!BX:BX),1))","v":""}]
[null,"Social Support ",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!CD:CD),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!CD:CD),1))","v":""}]
[null,"Parenting",null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(AVERAGE(Program_Chart_Output!CJ:CJ),1)),\"\",ROUND(AVERAGE(Program_Chart_Output!CJ:CJ),1))","v":""}]

{"sheet":"Program_Chart_Output","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"VE_Int_Data","index":12,"n_rows":3,"n_cols":91,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["RecordID","ClientID","DateCompleted","client_priority_rating","behavior_health_priority","behavior_health_dk","behavior_health_rating","behavior_health_q1","behavior_health_q2","physical_health_priority","physical_health_dk","physical_health_rating","physical_health_q1","physical_health_q2","physical_health_q3","physical_health_q4","safety_priority","safety_dk","safety_rating","safety_q1","safety_q2","safety_q3","housing_priority","housing_dk","housing_rating","housing_q1","housing_q2","housing_q3","housing_q4","language_priority","language_dk","language_rating","language_q1","language_q2","education_priority","education_dk","education_rating","education_q1","education_q2","education_q3","employment_priority","employment_na","employment_dk","employment_rating","employment_q1","employment_q2","employment_q3","resource_priority","resource_na","resource_dk","resource_rating","resource_q1","resource_q2","resource_q3","public_benefits_priority","public_benefits_na","public_benefits_dk","public_benefits_rating","public_benefits_q1","public_benefits_q2","life_skills_priority","life_skills_dk","life_skills_rating","life_skills_q1","life_skills_q2","legal_priority","legal_dk","legal_rating","legal_q1","legal_q2","legal_q3","legal_q4","immigration_priority","immigration_na","immigration_dk","immigration_rating","immigration_q1","immigration_q2","immigration_q3","social_support_priority","social_support_dk","social_support_rating","social_support_q1","social_support_q2","parenting_priority","parenting_na","parenting_dk","parenting_rating","parenting_q1","parenting_q2","parenting_q3"]
[null,null,null,null,2,3,null,1,2,5,7,null,4,5,6,7,9,11,null,8,9,10,17,19,null,14,15,17,18,21,23,null,20,21,26,29,null,25,26,28,31,33,34,null,30,31,32,37,39,40,null,36,37,38,42,44,45,null,42,43,47,49,null,47,48,51,53,null,50,51,52,53,55,57,58,null,54,55,56,61,63,null,60,61,68,70,71,null,64,66,68]
[{"$f":"rngVE_RecID","v":{"$error":"#N/A"}},{"$f":"'Review-Edit Existing Record'!rngVE_ClientID","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK('Review-Edit Existing Record'!rngVE_Months),NOW(),'Review-Edit Existing Record'!rngVE_Months)","v":"2020-09-21T15:11:48.150"},{"$f":"'Review-Edit Existing Record'!X6","v":""},{"$f":"IF(AND(F3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,E2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,E2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,F2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C10","v":""},{"$f":"IF(AND($F3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,H2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,H2,11)),\"\")","v":0},{"$f":"IF(AND($F3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,I2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,I2,11)),\"\")","v":0},{"$f":"IF(AND(K3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,J2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,J2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,K2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C14","v":""},{"$f":"IF(AND($K3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,M2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,M2,11)),\"\")","v":0},{"$f":"IF(AND($K3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,N2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,N2,11)),\"\")","v":0},{"$f":"IF(AND($K3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,O2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,O2,11)),\"\")","v":0},{"$f":"IF(AND($K3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,P2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,P2,11)),\"\")","v":0},{"$f":"IF(AND(R3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,Q2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,Q2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,R2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C18","v":""},{"$f":"IF(AND($R3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,T2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,T2,11)),\"\")","v":0},{"$f":"IF(AND($R3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,U2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,U2,11)),\"\")","v":0},{"$f":"IF(AND($R3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,V2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,V2,11)),\"\")","v":0},{"$f":"IF(AND(X3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,W2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,W2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,X2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C26","v":""},{"$f":"IF(AND($X3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,Z2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,Z2,11)),\"\")","v":0},{"$f":"IF(AND($X3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AA2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AA2,11)),\"\")","v":0},{"$f":"IF(AND($X3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AB2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AB2,11)),\"\")","v":0},{"$f":"IF(AND($X3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AC2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AC2,11)),\"\")","v":0},{"$f":"IF(AND(AE3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AD2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,AD2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,AE2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C30","v":""},{"$f":"IF(AND($AE3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AG2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AG2,11)),\"\")","v":0},{"$f":"IF(AND($AE3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AH2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AH2,11)),\"\")","v":0},{"$f":"IF(AND(AJ3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AI2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,AI2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,AJ2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C36","v":""},{"$f":"IF(AND($AJ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AL2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AL2,11)),\"\")","v":0},{"$f":"IF(AND($AJ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AM2,5))<>1),OFFSET('Review-Edit Existing Record'!$K$8,AM2,11),\"\")","v":0},{"$f":"IF(AND($AJ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AN2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AN2,11)),\"\")","v":0},{"$f":"IF(AP3=1,\"\",IF(AND(AQ3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AO2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,AO2,8))))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,AP2,9))","v":0},{"$f":"IF(AP3=1,\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,AQ2,7)))","v":0},{"$f":"'Review-Edit Existing Record'!C40","v":""},{"$f":"IF(AND($AQ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AS2,5))<>1,$AP3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AS2,11)),\"\")","v":0},{"$f":"IF(AND($AQ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AT2,5))<>1,$AP3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AT2,11)),\"\")","v":0},{"$f":"IF(AND($AQ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AU2,5))<>1,$AP3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AU2,11)),\"\")","v":0},{"$f":"IF(AW3=1,\"\",IF(AND(AX3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AV2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,AV2,8))))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,AW2,9))","v":0},{"$f":"IF(AW3=1,\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,AX2,7)))","v":0},{"$f":"'Review-Edit Existing Record'!C46","v":""},{"$f":"IF(AND($AX3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,AZ2,5))<>1,$AW3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,AZ2,11)),\"\")","v":0},{"$f":"IF(AND($AX3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BA2,5))<>1,$AW3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BA2,11)),\"\")","v":0},{"$f":"IF(AND($AX3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BB2,5))<>1,$AW3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BB2,11)),\"\")","v":0},{"$f":"IF(BD3=1,\"\",IF(AND(BE3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BC2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,BC2,8))))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,BD2,9))","v":0},{"$f":"IF(BD3=1,\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,BE2,7)))","v":0},{"$f":"'Review-Edit Existing Record'!C51","v":""},{"$f":"IF(AND($BE3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BG2,5))<>1,$BD3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BG2,11)),\"\")","v":0},{"$f":"IF(AND($BE3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BH2,5))<>1,$BD3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BH2,11)),\"\")","v":0},{"$f":"IF(AND(BJ3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BI2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,BI2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,BJ2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C56","v":""},{"$f":"IF(AND($BJ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BL2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BL2,11)),\"\")","v":0},{"$f":"IF(AND($BJ3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BM2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BM2,11)),\"\")","v":0},{"$f":"IF(AND(BO3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BN2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,BN2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,BO2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C60","v":""},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BQ2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BQ2,11)),\"\")","v":0},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BR2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BR2,11)),\"\")","v":0},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BS2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BS2,11)),\"\")","v":0},{"$f":"IF(AND($BO3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BT2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BT2,11)),\"\")","v":0},{"$f":"IF(BV3=1,\"\",IF(AND(BW3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BU2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,BU2,8))))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,BV2,9))","v":0},{"$f":"IF(BV3=1,\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,BW2,7)))","v":0},{"$f":"'Review-Edit Existing Record'!C64","v":""},{"$f":"IF(AND($BW3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BY2,5))<>1,$BV3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BY2,11)),\"\")","v":0},{"$f":"IF(AND($BW3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,BZ2,5))<>1,$BV3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,BZ2,11)),\"\")","v":0},{"$f":"IF(AND($BW3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CA2,5))<>1,$BV3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,CA2,11)),\"\")","v":0},{"$f":"IF(AND(CC3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CB2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,CB2,8)))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,CC2,7))","v":0},{"$f":"'Review-Edit Existing Record'!C70","v":""},{"$f":"IF(AND($CC3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CE2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,CE2,11)),\"\")","v":0},{"$f":"IF(AND($CC3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CF2,5))<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,CF2,11)),\"\")","v":0},{"$f":"IF(CH3=1,\"\",IF(AND(CI3=1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CG2,8))=0),\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,CG2,8))))","v":0},{"$f":"INT(OFFSET('Review-Edit Existing Record'!$K$8,CH2,9))","v":0},{"$f":"IF(CH3=1,\"\",INT(OFFSET('Review-Edit Existing Record'!$K$8,CI2,7)))","v":0},{"$f":"'Review-Edit Existing Record'!C77","v":""},{"$f":"IF(AND($CI3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CK2,5))<>1,$CH3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,CK2,11)),\"\")","v":0},{"$f":"IF(AND($CI3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CL2,5))<>1,$CH3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,CL2,11)),\"\")","v":0},{"$f":"IF(AND($CI3<>1,INT(OFFSET('Review-Edit Existing Record'!$K$8,CM2,5))<>1,$CH3<>1),INT(OFFSET('Review-Edit Existing Record'!$K$8,CM2,11)),\"\")","v":0}]