{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Client Demographics","ADLs","Medical Needs","Nursing Assessment Indicators","Nighttime Needs","Social and Behavioral Needs","Enhanced or Exceptional","Support Needs Summary","Summary of In-Home Hours","2-1 Review and Approval","Raw Scoring","New Scoring","Control"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":228,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Client Demographics","index":0,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,14,6,16],[12,13,12,15],[13,13,13,15],[11,13,11,15],[7,14,7,16],[8,14,8,16],[6,11,6,13],[7,10,7,12],[10,13,10,16],[9,8,9,10],[9,11,9,16],[4,0,4,2],[2,3,2,8],[4,9,4,10],[4,11,4,16],[4,3,4,8],[3,3,3,8],[2,11,2,12],[2,9,2,10],[3,9,3,10],[3,11,3,12],[0,0,0,16],[3,13,3,14],[2,0,2,2],[3,0,3,2],[3,15,3,16],[1,13,1,16],[1,0,1,12],[16,13,16,15],[17,0,17,2],[17,3,17,4],[16,8,16,12],[17,8,17,9],[17,12,17,13],[16,1,16,7],[7,0,7,3],[11,1,11,7],[17,5,17,7],[15,1,15,7],[13,1,13,7],[10,0,10,7],[14,1,14,7],[8,0,9,3],[8,4,9,7],[15,13,15,15],[11,8,11,12],[12,8,12,12],[13,8,13,12],[14,13,14,15],[5,0,5,5],[5,6,5,8],[23,0,23,2],[5,11,5,12],[10,8,10,12],[8,10,8,12],[15,8,15,12],[14,8,14,12],[6,3,6,4],[12,1,12,7],[8,8,8,9],[6,5,6,10],[5,9,5,10],[6,0,6,2],[7,8,7,9],[7,4,7,7]]}
["Child In-Home Support Needs Assessment"]
["WARNING: Macros are currently disabled.  If this message persists after workbook initialization, please close this file, then reopen it and select either [Enable Macros] or [Enable Content], whichever option is displayed.\n\n* If you believe you have already enabled Macros/Content then:\n   1. First, select the Ribbon's File tab and, if you see a security warning, select the large [Enable Content v] shield button, \n        then \"Enable All Content\".\n   2. If you don't find a security warning then select the [Fix Me] button to the right, on this sheet.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ClientDOB<AssessmentDate,IFERROR(DATEDIF(ClientDOB,EffectiveAssmtDate,\"YD\") < 60,FALSE)),\"(\" & AssmtGracePeriod & \"-day grace period is in effect)\",\"\")","v":""}]
["(Legal Name) \nName of Individual",null,null,null,null,null,null,null,null,"Date of Birth",null,null,null,"Assess.\nAge",{"$f":"IF(OR(L3=\"\",AssessmentDate=\"\",L3>=AssessmentDate),\n       \"\",\n       IF(DATEDIF(L3,AssessmentDate,\"Y\")=0,\n            DATEDIF(L3,AssessmentDate,\"YM\") & \" Month\" & IF(DATEDIF(L3,AssessmentDate,\"YM\")=1,\"\",\"s\"),\n            IF(DATEDIF(L3,AssessmentDate,\"Y\")=1,\n                 DATEDIF(L3,AssessmentDate,\"M\") & \" Months\",\n                 DATEDIF(L3,AssessmentDate,\"Y\"))))","v":""},"Adjust.\nAge",{"$f":"IF(OR(L3=\"\",EffectiveAssmtDate=\"\",L3>=AssessmentDate),\n       \"\",\n       IF(DATEDIF(L3,EffectiveAssmtDate,\"Y\")=0,\n            DATEDIF(L3,EffectiveAssmtDate,\"YM\") & \" Month\" & IF(DATEDIF(L3,EffectiveAssmtDate,\"YM\")=1,\"\",\"s\"),\n            IF(DATEDIF(L3,EffectiveAssmtDate,\"Y\")=1,\n                 DATEDIF(L3,EffectiveAssmtDate,\"M\") & \" Months\",\n                 DATEDIF(L3,EffectiveAssmtDate,\"Y\"))))","v":""}]
["Prime #",null,null,null,null,null,null,null,null,"Height",null,null,null,"Weight"]
["Service Setting",null,null,"(Select)",null,null,null,null,null,"Service Element",null,"(Select)"]
["Did the individual participate in the Assessment?",null,null,null,null,null,"(Select)",null,null,"Gender",null,"(Select)"]
["Assessment Type",null,null,"(Select)",null,null,null,null,null,null,null,"              Date of Assessment"]
["CDDP Services Coordinator or\nBrokerage Personal Agent",null,null,null,null,null,null,null,"CDDP/County or\nBrokerage",null,"(Select)",null,null,"Phone"]
["Assessor's Name",null,null,null,null,null,null,null,"Assessor Affiliation",null,"(Select)",null,null,"Phone"]
[null,null,null,null,null,null,null,null,"Assessor e-mail Address"]
["Name of Assessment Participants",null,null,null,null,null,null,null,"Relationship to Individual",null,null,null,null,"Phone"]
["1.",null,null,null,null,null,null,null,"(Select)"]
["2.",null,null,null,null,null,null,null,"(Select)"]
["3.",null,null,null,null,null,null,null,"(Select)"]
["4.",null,null,null,null,null,null,null,"(Select)"]
["5.",null,null,null,null,null,null,null,"(Select)"]
["6.",null,null,null,null,null,null,null,"(Select)"]
["Start Time",null,null,null,null,"End Time",null,null,null,null,null,null,"Completion Time",null,{"$f":"IF(D18 = \"\",\"\",IF(I18=\"\",\"\",24*(IF(D18<=I18,I18-D18,I18+1-D18))))","v":""},"hrs.",true]
[]
[]
[]
[]
[]
["CNA version C.106",null,null,null,null,null,null,null,null,null,null,null,null,"Auto-save every ",10," minutes"]

{"sheet":"ADLs","index":1,"n_rows":140,"n_cols":14,"rows_kept":140,"cut":false,"hidden":false,"merged":[[139,0,139,1],[140,0,140,1],[98,0,98,1],[99,0,99,1],[106,0,106,1],[107,0,107,1],[110,0,110,1],[111,0,111,1],[117,0,117,1],[118,0,118,1],[132,0,132,1],[133,0,133,1],[121,0,121,1],[122,0,122,1],[128,0,128,1],[129,0,129,1],[46,0,46,1],[47,0,47,1],[95,0,95,1],[74,0,74,1],[75,0,75,1],[82,0,82,1],[83,0,83,1],[50,0,50,1],[52,0,52,1],[58,0,58,1],[59,0,59,1],[62,0,62,1],[94,0,94,1],[64,0,64,1],[70,0,70,1],[71,0,71,1],[86,0,86,1],[87,0,87,1],[14,0,14,1],[15,0,15,1],[2,0,2,1],[3,0,3,1],[10,0,10,1],[11,0,11,1],[22,0,22,1],[23,0,23,1],[37,0,37,1],[38,0,38,1],[26,0,26,1],[27,0,27,1],[33,0,33,1],[34,0,34,1]]}
[null,null,null,"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Mismatch\nTrace"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["AMBULATION / MOBILITY IN THE HOME AND COMMUNITY"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J4:J10)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's physical ability to move around in familiar places with or without mechanical aids.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can ambulate in familiar surroundings without assistance from another individual with or without mechanical aids.\n",null,"Independent or Age Appropriate Supports Provided","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K7),VALUE(IF(ISERROR(VALUE((MID(K7,LEN(K7)-1,1)))),0,MID(K7,LEN(K7)-1,1))&IF(ISERROR(VALUE(MID(K7,LEN(K7)-0,1))),0,MID(K7,LEN(K7)-0,1))),J8)","v":1},"ADL1","HomeAmb1",true,false]
[null,"Partial Assist: The child is dependent on assistance from another person for some aspect of \nambulation/mobility.\n",null,"Partial Assist","No","None",1,"N/A",null,{"$f":"IF(ISTEXT(K8),VALUE(IF(ISERROR(VALUE((MID(K8,LEN(K8)-1,1)))),0,MID(K8,LEN(K8)-1,1))&IF(ISERROR(VALUE(MID(K8,LEN(K8)-0,1))),0,MID(K8,LEN(K8)-0,1))),J9)","v":1},"ADL1","HomeAmb2",false,false]
[null,"Full Assist: The child is dependent on assistance from another person for all aspects of \nambulation/mobility.\n",null,"Full Assist","No","None",4,"N/A",null,{"$f":"IF(ISTEXT(K9),VALUE(IF(ISERROR(VALUE((MID(K9,LEN(K9)-1,1)))),0,MID(K9,LEN(K9)-1,1))&IF(ISERROR(VALUE(MID(K9,LEN(K9)-0,1))),0,MID(K9,LEN(K9)-0,1))),J10)","v":1},"ADL1","HomeAmb3",false,false]
[null,"Two-Person Assist: The child requires assistance of two people for all aspects of ambulation/mobility. Documentation of caregivers' schedule and duties are required.\n",null,"Two-Person Assist","Yes","None",4,"N/A",null,{"$f":"IF(ISTEXT(K10),VALUE(IF(ISERROR(VALUE((MID(K10,LEN(K10)-1,1)))),0,MID(K10,LEN(K10)-1,1))&IF(ISERROR(VALUE(MID(K10,LEN(K10)-0,1))),0,MID(K10,LEN(K10)-0,1))),J11)","v":1},"ADL1","HomeAmb4",false,false]
["NOTES"]
[]
[]
[]
["TRANSFERRING / POSITIONING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J16:J22)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's physical ability to transfer to and from positioning equipment, bathtub, toilet, chair, bed, wheelchair, auto, etc.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can transfer without assistance from another individual with or without mechanical aids.\n",null,"Independent or Age Appropriate Supports Provided","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K19),VALUE(IF(ISERROR(VALUE((MID(K19,LEN(K19)-1,1)))),0,MID(K19,LEN(K19)-1,1))&IF(ISERROR(VALUE(MID(K19,LEN(K19)-0,1))),0,MID(K19,LEN(K19)-0,1))),J20)","v":2},"ADL2","Transfer1",true,false]
[null,"Partial Assist: The child can perform the transfer with or without mechanical aids, but requires some assistance by another person for some aspect of transferring.\n",null,"Partial Assist","No","None",1,"N/A",null,{"$f":"IF(ISTEXT(K20),VALUE(IF(ISERROR(VALUE((MID(K20,LEN(K20)-1,1)))),0,MID(K20,LEN(K20)-1,1))&IF(ISERROR(VALUE(MID(K20,LEN(K20)-0,1))),0,MID(K20,LEN(K20)-0,1))),J21)","v":2},"ADL2","Transfer2",false,false]
[null,"Full Assist: The child is dependent on another person for all aspects of transferring and positioning.\n",null,"Full Assist","No","None",4,"N/A",null,{"$f":"IF(ISTEXT(K21),VALUE(IF(ISERROR(VALUE((MID(K21,LEN(K21)-1,1)))),0,MID(K21,LEN(K21)-1,1))&IF(ISERROR(VALUE(MID(K21,LEN(K21)-0,1))),0,MID(K21,LEN(K21)-0,1))),J22)","v":2},"ADL2","Transfer3",false,false]
[null,"Two-Person Assist: The child requires assistance of two people for all aspects of transferring and positioning. Documentation of caregivers' schedule and duties are required.\n",null,"Two-Person Assist","Yes","None",4,"N/A",null,{"$f":"IF(ISTEXT(K22),VALUE(IF(ISERROR(VALUE((MID(K22,LEN(K22)-1,1)))),0,MID(K22,LEN(K22)-1,1))&IF(ISERROR(VALUE(MID(K22,LEN(K22)-0,1))),0,MID(K22,LEN(K22)-0,1))),J23)","v":2},"ADL2","Transfer4",false,false]
["NOTES"]
[]
[]
[]
["FOOD PREPARATION"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J28:J34)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the ability of a child age 15 or older to prepare food to eat, including a simple meal.   A \"simple meal\" means a meal that does not require use of sharp knives, a stovetop or range other than a microwave.      Examples foods items that might be included in a  simple meal include a sandwich, frozen entrees, cereal or toast.  (Clean-up is not included in the ability or support need scoring.) \nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability and exceeds the amount of support that is typically provided to a child of this age.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child is younger than 15, or the child can prepare simple foods without assistance from another individual with or without mechanical aids beyond what is appropriate for a child of the same age.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K31),VALUE(IF(ISERROR(VALUE((MID(K31,LEN(K31)-1,1)))),0,MID(K31,LEN(K31)-1,1))&IF(ISERROR(VALUE(MID(K31,LEN(K31)-0,1))),0,MID(K31,LEN(K31)-0,1))),J32)","v":3},"ADL3","Meal1",true,false]
[null,"Partial Assist: The child requires cueing or some physical assistance from another person to prepare foods for a simple meal beyond what is appropriate for a child of the same age.\n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K32),VALUE(IF(ISERROR(VALUE((MID(K32,LEN(K32)-1,1)))),0,MID(K32,LEN(K32)-1,1))&IF(ISERROR(VALUE(MID(K32,LEN(K32)-0,1))),0,MID(K32,LEN(K32)-0,1))),J33)","v":3},"ADL3","Meal2",false,false]
[null,"Full Assist: The child requires full assistance from another person to prepare all meals, including foods for a simple meal.\n",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K33),VALUE(IF(ISERROR(VALUE((MID(K33,LEN(K33)-1,1)))),0,MID(K33,LEN(K33)-1,1))&IF(ISERROR(VALUE(MID(K33,LEN(K33)-0,1))),0,MID(K33,LEN(K33)-0,1))),J34)","v":3},"ADL3","Meal3",false,false]
["NOTES"]
[]
[]
[]
["EATING / DRINKING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J39:J45)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's physical ability to safely eat or drink, either orally or via tube, and maintain their nutrition and hydration in their home or community.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\nRecord tube feeding as constant/aspiration risk.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can eat and drink safely and requires no assistance or monitoring while eating or drinking.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K42),VALUE(IF(ISERROR(VALUE((MID(K42,LEN(K42)-1,1)))),0,MID(K42,LEN(K42)-1,1))&IF(ISERROR(VALUE(MID(K42,LEN(K42)-0,1))),0,MID(K42,LEN(K42)-0,1))),J43)","v":4},"ADL4","EatDrink1",true,false]
[null,"Partial Assist - food cut up: The child requires intermittent assistance and monitoring while eating and drinking, and may require their food to be cut up for them by another person. \n",null,"Partial Assist - food cut up","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K43),VALUE(IF(ISERROR(VALUE((MID(K43,LEN(K43)-1,1)))),0,MID(K43,LEN(K43)-1,1))&IF(ISERROR(VALUE(MID(K43,LEN(K43)-0,1))),0,MID(K43,LEN(K43)-0,1))),J44)","v":4},"ADL4","EatDrink2",false,false]
[null,"Partial Assist - intermittent: The child requires intermittent assistance and monitoring with eating and drinking but requires food or fluid texture to be altered, per doctor's order, by another person.  *\n",null,"Partial Assist - intermittent","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K44),VALUE(IF(ISERROR(VALUE((MID(K44,LEN(K44)-1,1)))),0,MID(K44,LEN(K44)-1,1))&IF(ISERROR(VALUE(MID(K44,LEN(K44)-0,1))),0,MID(K44,LEN(K44)-0,1))),J45)","v":4},"ADL4","EatDrink3",false,false]
[null,"Full Assist - constant: The child requires constant assistance and monitoring with eating and drinking to maintain proper nutrition and hydration but does not require food or fluid texture to be altered. \n",null,"Full Assist - constant","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K45),VALUE(IF(ISERROR(VALUE((MID(K45,LEN(K45)-1,1)))),0,MID(K45,LEN(K45)-1,1))&IF(ISERROR(VALUE(MID(K45,LEN(K45)-0,1))),0,MID(K45,LEN(K45)-0,1))),J46)","v":4},"ADL4","EatDrink4",false,false]
[null,"Full Assist - constant/aspiration risk: The child requires constant assistance and monitoring with eating and drinking to maintain proper nutrition and hydration, and/or to prevent the individual from gagging, choking, and aspirating.  The individual may require alteration in food or fluid texture for safety.  The individual may require medication administration through their tube feeding route. *\n\n*See individual indicators for a Nursing Assessment Referral",null,"Full Assist - constant/aspiration risk","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K46),VALUE(IF(ISERROR(VALUE((MID(K46,LEN(K46)-1,1)))),0,MID(K46,LEN(K46)-1,1))&IF(ISERROR(VALUE(MID(K46,LEN(K46)-0,1))),0,MID(K46,LEN(K46)-0,1))),J47)","v":4},"ADL4","EatDrink5",false,false]
["NOTES"]
[]
[]
[]
["BLADDER CONTROL"]
[null,"Care for Incontinence"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J53:J59)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to care for incontinence of bladder.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child is independent with incontinence care. Mark independent if not applicable.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"Toilet4+",null,{"$f":"IF(ISTEXT(K56),VALUE(IF(ISERROR(VALUE((MID(K56,LEN(K56)-1,1)))),0,MID(K56,LEN(K56)-1,1))&IF(ISERROR(VALUE(MID(K56,LEN(K56)-0,1))),0,MID(K56,LEN(K56)-0,1))),J57)","v":5},"ADL5","Bladder1",true,false]
[null,"Partial Assist: The child requires assistance from another person to manage incontinency, catheter, or sheath changes, including assistance changing incontinence garments, soiled clothing or equipment. * \n",null,"Partial Assist","N/A","None",3,"Toilet4+",null,{"$f":"IF(ISTEXT(K57),VALUE(IF(ISERROR(VALUE((MID(K57,LEN(K57)-1,1)))),0,MID(K57,LEN(K57)-1,1))&IF(ISERROR(VALUE(MID(K57,LEN(K57)-0,1))),0,MID(K57,LEN(K57)-0,1))),J58)","v":5},"ADL5","Bladder2",false,false]
[null,"Full Assist: The child is totally incontinent and dependent on another person for incontinence or catheter \ncare. *\n\n*See individual indicators for a Nursing Assessment Referral",null,"Full Assist","N/A","None",4,"Toilet4-",null,{"$f":"IF(ISTEXT(K58),VALUE(IF(ISERROR(VALUE((MID(K58,LEN(K58)-1,1)))),0,MID(K58,LEN(K58)-1,1))&IF(ISERROR(VALUE(MID(K58,LEN(K58)-0,1))),0,MID(K58,LEN(K58)-0,1))),J59)","v":5},"ADL5","Bladder3",false,false]
["NOTES"]
[]
[]
[]
["BOWEL CONTROL"]
[null,"Care for Incontinence"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J65:J71)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to care for incontinence of the bowel.  (Ineffective cleansing after use of the toilet for elimination should be recorded in \"Toileting\" and is not recorded in this section.)\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child is independent with bowel control issues, whether the individual is continent, incontinent or has an ostomy. Mark independent if not applicable.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"Toilet4+",null,{"$f":"IF(ISTEXT(K68),VALUE(IF(ISERROR(VALUE((MID(K68,LEN(K68)-1,1)))),0,MID(K68,LEN(K68)-1,1))&IF(ISERROR(VALUE(MID(K68,LEN(K68)-0,1))),0,MID(K68,LEN(K68)-0,1))),J69)","v":6},"ADL6","Bowel1",true,false]
[null,"Partial Assist: The child requires assistance managing incontinence of the bowel, changing incontinence garments, soiled clothing or ostomy care. * \n",null,"Partial Assist","N/A","None",3,"Toilet4+",null,{"$f":"IF(ISTEXT(K69),VALUE(IF(ISERROR(VALUE((MID(K69,LEN(K69)-1,1)))),0,MID(K69,LEN(K69)-1,1))&IF(ISERROR(VALUE(MID(K69,LEN(K69)-0,1))),0,MID(K69,LEN(K69)-0,1))),J70)","v":6},"ADL6","Bowel2",false,false]
[null,"Full Assist: The child is incontinent of the bowel and dependent on another person to complete all incontinence care. * \n\n*See individual indicators for a Nursing Assessment Referral",null,"Full Assist","N/A","None",4,"Toilet4-",null,{"$f":"IF(ISTEXT(K70),VALUE(IF(ISERROR(VALUE((MID(K70,LEN(K70)-1,1)))),0,MID(K70,LEN(K70)-1,1))&IF(ISERROR(VALUE(MID(K70,LEN(K70)-0,1))),0,MID(K70,LEN(K70)-0,1))),J71)","v":6},"ADL6","Bowel3",false,false]
["NOTES"]
[]
[]
[]
[{"$f":"\"TOILETING\"&IF(ISBLANK(I79),\"\",\" -- Unavailable when \"\"Full Assist\"\" is selected for bladder or bowel control (above)\")","v":"TOILETING"}]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J76:J82)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to independently use the toilet (including commode, bedpan, and/or urinal), to cleanse after elimination and to adjust clothing.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can manage toileting independently and may use mechanical aids, if required. Mark independent if not applicable.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K79),VALUE(IF(ISERROR(VALUE((MID(K79,LEN(K79)-1,1)))),0,MID(K79,LEN(K79)-1,1))&IF(ISERROR(VALUE(MID(K79,LEN(K79)-0,1))),0,MID(K79,LEN(K79)-0,1))),J80)","v":7},"ADL7","Toilet1",true,false]
[null,"Partial Assist - cueing: The child requires verbal cueing and monitoring to complete toileting activities.\n",null,"Partial Assist - cueing","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K80),VALUE(IF(ISERROR(VALUE((MID(K80,LEN(K80)-1,1)))),0,MID(K80,LEN(K80)-1,1))&IF(ISERROR(VALUE(MID(K80,LEN(K80)-0,1))),0,MID(K80,LEN(K80)-0,1))),J81)","v":7},"ADL7","Toilet2",false,false]
[null,"Partial Assist - assistance: The child requires assistance from another person for some aspects of using the toilet for elimination. \n",null,"Partial Assist - assistance","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K81),VALUE(IF(ISERROR(VALUE((MID(K81,LEN(K81)-1,1)))),0,MID(K81,LEN(K81)-1,1))&IF(ISERROR(VALUE(MID(K81,LEN(K81)-0,1))),0,MID(K81,LEN(K81)-0,1))),J82)","v":7},"ADL7","Toilet3",false,false]
[null,"Full Assist: The child is dependent on another person, even with mechanical aids, to assist with some or all parts of using the toilet for elimination. \n",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K82),VALUE(IF(ISERROR(VALUE((MID(K82,LEN(K82)-1,1)))),0,MID(K82,LEN(K82)-1,1))&IF(ISERROR(VALUE(MID(K82,LEN(K82)-0,1))),0,MID(K82,LEN(K82)-0,1))),J83)","v":7},"ADL7","Toilet4",false,false]
["NOTES"]
[]
[null,null," "]
[]
["HYGIENE (INCLUDING ORAL HYGIENE)"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J88:J94)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to complete personal hygiene tasks such as facial care, shaving, menses care, and oral care.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can manage personal hygiene tasks, oral hygiene, without reminders, assistance or supervision or with a level of support appropriate for the age of the child.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K91),VALUE(IF(ISERROR(VALUE((MID(K91,LEN(K91)-1,1)))),0,MID(K91,LEN(K91)-1,1))&IF(ISERROR(VALUE(MID(K91,LEN(K91)-0,1))),0,MID(K91,LEN(K91)-0,1))),J92)","v":8},"ADL8","Hygiene1",true,false]
[null,"Partial Assist - cueing: The child requires monitoring, reminders and minor cueing from another person for some aspects of personal hygiene/oral hygiene.\n",null,"Partial Assist - cueing","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K92),VALUE(IF(ISERROR(VALUE((MID(K92,LEN(K92)-1,1)))),0,MID(K92,LEN(K92)-1,1))&IF(ISERROR(VALUE(MID(K92,LEN(K92)-0,1))),0,MID(K92,LEN(K92)-0,1))),J93)","v":8},"ADL8","Hygiene2",false,false]
[null,"Partial Assist - assistance: The child requires monitoring, step by step cueing or physical assistance from another person for some aspects of personal hygiene/oral hygiene.\n",null,"Partial Assist - assistance","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K93),VALUE(IF(ISERROR(VALUE((MID(K93,LEN(K93)-1,1)))),0,MID(K93,LEN(K93)-1,1))&IF(ISERROR(VALUE(MID(K93,LEN(K93)-0,1))),0,MID(K93,LEN(K93)-0,1))),J94)","v":8},"ADL8","Hygiene3",false,false]
[null,"Full Assist: The child is dependent on another person to perform personal hygiene/oral hygiene tasks for them.\n",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K94),VALUE(IF(ISERROR(VALUE((MID(K94,LEN(K94)-1,1)))),0,MID(K94,LEN(K94)-1,1))&IF(ISERROR(VALUE(MID(K94,LEN(K94)-0,1))),0,MID(K94,LEN(K94)-0,1))),J95)","v":8},"ADL8","Hygiene4",false,false]
["NOTES"]
[]
[]
[]
["BATHING"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J100:J106)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to bathe and wash their hair.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can bathe and wash hair without assistance or supervision.\n",null,"Independent or Age Appropriate Supports Provided","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K103),VALUE(IF(ISERROR(VALUE((MID(K103,LEN(K103)-1,1)))),0,MID(K103,LEN(K103)-1,1))&IF(ISERROR(VALUE(MID(K103,LEN(K103)-0,1))),0,MID(K103,LEN(K103)-0,1))),J104)","v":9},"ADL9","Bath1",true,false]
[null,"Partial Assist: The child requires minor physical assistance, standby monitoring, and/or cueing from another person to bathe and wash their hair.\n",null,"Partial Assist","No","None",2,"N/A",null,{"$f":"IF(ISTEXT(K104),VALUE(IF(ISERROR(VALUE((MID(K104,LEN(K104)-1,1)))),0,MID(K104,LEN(K104)-1,1))&IF(ISERROR(VALUE(MID(K104,LEN(K104)-0,1))),0,MID(K104,LEN(K104)-0,1))),J105)","v":9},"ADL9","Bath2",false,false]
[null,"Full Assist: The child is dependent on assistance from another person to bathe them and wash their hair.\n",null,"Full Assist","No","None",4,"N/A",null,{"$f":"IF(ISTEXT(K105),VALUE(IF(ISERROR(VALUE((MID(K105,LEN(K105)-1,1)))),0,MID(K105,LEN(K105)-1,1))&IF(ISERROR(VALUE(MID(K105,LEN(K105)-0,1))),0,MID(K105,LEN(K105)-0,1))),J106)","v":9},"ADL9","Bath3",false,false]
[null,"Two-Person Assist: The child requires assistance of two people while bathing and washing their \nhair. Documentation of caregivers' schedule and duties are required.\n",null,"Two-Person Assist","Yes","None",5,"N/A",null,{"$f":"IF(ISTEXT(K106),VALUE(IF(ISERROR(VALUE((MID(K106,LEN(K106)-1,1)))),0,MID(K106,LEN(K106)-1,1))&IF(ISERROR(VALUE(MID(K106,LEN(K106)-0,1))),0,MID(K106,LEN(K106)-0,1))),J107)","v":9},"ADL9","Bath4",false,false]
["NOTES"]
[]
[]
[]
["LAUNDRY AND HOUSEKEEPING "]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J112:J118)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the ability of a child age 12 and older to participate in the care of their own clothing and living space.  For a child age 12 - 14, this means the ability of the child to complete the following types of tasks, with or without instructions or picture cues:  put away objects the child has used, deposit dirty clothes into a receptacle, putting away the child's own clothing and completing one or more simple household chores such as drying dishes or emptying trash.   For a child 15 - 17, this means the ability of the child to complete the following types of tasks, with or without instructions or picture cues: clean the child's own room, complete a load of laundry, and complete one of more household chores.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability and exceeds the amount of support that is typically provided to a child of this age.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can complete laundry and housekeeping tasks appropriate for the age of the child.  Score here if the child completes the task independently but needs reminding to initiate the task.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K115),VALUE(IF(ISERROR(VALUE((MID(K115,LEN(K115)-1,1)))),0,MID(K115,LEN(K115)-1,1))&IF(ISERROR(VALUE(MID(K115,LEN(K115)-0,1))),0,MID(K115,LEN(K115)-0,1))),J116)","v":10},"ADL10","Laundry1",true,false]
[null,"Partial Assist: The child requires monitoring, frequent cueing, or some physical assistance to complete housekeeping and laundry tasks beyond supports that are typical for the age of the child. \n",null,"Partial Assist","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K116),VALUE(IF(ISERROR(VALUE((MID(K116,LEN(K116)-1,1)))),0,MID(K116,LEN(K116)-1,1))&IF(ISERROR(VALUE(MID(K116,LEN(K116)-0,1))),0,MID(K116,LEN(K116)-0,1))),J117)","v":10},"ADL10","Laundry2",false,false]
[null,"Full Assist: The child requires another person to complete all or most housekeeping and laundry tasks for them.  Score here if the child participates, but participation does not contribute to the completion of the task.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K117),VALUE(IF(ISERROR(VALUE((MID(K117,LEN(K117)-1,1)))),0,MID(K117,LEN(K117)-1,1))&IF(ISERROR(VALUE(MID(K117,LEN(K117)-0,1))),0,MID(K117,LEN(K117)-0,1))),J118)","v":10},"ADL10","Laundry3",false,false]
["NOTES"]
[]
[]
[]
["DRESSING & HAIR CARE"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J123:J129)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to dress, undress and/or comb hair.\nChoose the option that most accurately reflects the supports required by the child, which are not due to behaviors.\nCheck an option only if the support needed is due to the child's disability.\n\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can dress, undress and/or comb hair independently or with reminding.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K126),VALUE(IF(ISERROR(VALUE((MID(K126,LEN(K126)-1,1)))),0,MID(K126,LEN(K126)-1,1))&IF(ISERROR(VALUE(MID(K126,LEN(K126)-0,1))),0,MID(K126,LEN(K126)-0,1))),J127)","v":11},"ADL11","Dress1",true,false]
[null,"Partial Assist: The child requires assistance from another person, which may include frequent monitoring and cueing for completing some aspect of dressing, undressing and/or combing hair.\n",null,"Partial Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K127),VALUE(IF(ISERROR(VALUE((MID(K127,LEN(K127)-1,1)))),0,MID(K127,LEN(K127)-1,1))&IF(ISERROR(VALUE(MID(K127,LEN(K127)-0,1))),0,MID(K127,LEN(K127)-0,1))),J128)","v":11},"ADL11","Dress2",false,false]
[null,"Full Assist: The child requires total assistance from another person to dress, undress and/or comb hair.\n",null,"Full Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K128),VALUE(IF(ISERROR(VALUE((MID(K128,LEN(K128)-1,1)))),0,MID(K128,LEN(K128)-1,1))&IF(ISERROR(VALUE(MID(K128,LEN(K128)-0,1))),0,MID(K128,LEN(K128)-0,1))),J129)","v":11},"ADL11","Dress3",false,false]
["NOTES"]
[]
[]
[]
["SHOPPING AND MONEY MANAGEMENT"]
[{"$f":"IF(INDEX('Raw Scoring'!D1:D13,MAX(J134:J140)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the ability of a child age 12 and older to participate in the management of their own resources.   For a child age 12 -14 this means the child the child has the ability to handle small amounts (up to $5) of pocket money  and participate in the selection of personal goods such as clothing or recreational items.  For a child age 15 - 17 this means the child has the ability to handle pocket money (up to $20), create a plan to save for larger purchases, and participate in selection of both personal and household goods.  \nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors. \nCheck an option only if the support needed is due to the child's disability and exceeds the amount of support that is typically provided to a child of this age."]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can handle money and participate in shopping as appropriate for the age of the child.  \n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K137),VALUE(IF(ISERROR(VALUE((MID(K137,LEN(K137)-1,1)))),0,MID(K137,LEN(K137)-1,1))&IF(ISERROR(VALUE(MID(K137,LEN(K137)-0,1))),0,MID(K137,LEN(K137)-0,1))),J138)","v":12},"ADL12","Money1",true,false]
[null,"Partial Assist: The child  requires assistance from another person, which may include frequent monitoring and cueing for some aspect of shopping and money management that is beyond the level of support that is typical for a child of the same age.\n",null,"Partial Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K138),VALUE(IF(ISERROR(VALUE((MID(K138,LEN(K138)-1,1)))),0,MID(K138,LEN(K138)-1,1))&IF(ISERROR(VALUE(MID(K138,LEN(K138)-0,1))),0,MID(K138,LEN(K138)-0,1))),J139)","v":12},"ADL12","Money2",false,false]
[null,"Full Assist: The child requires total assistance from another person to manage their money for them and shop on their behalf.\n",null,"Full Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K139),VALUE(IF(ISERROR(VALUE((MID(K139,LEN(K139)-1,1)))),0,MID(K139,LEN(K139)-1,1))&IF(ISERROR(VALUE(MID(K139,LEN(K139)-0,1))),0,MID(K139,LEN(K139)-0,1))),J140)","v":12},"ADL12","Money3",false,false]
["NOTES"]

{"sheet":"Medical Needs","index":2,"n_rows":160,"n_cols":14,"rows_kept":160,"cut":false,"hidden":false,"merged":[[70,0,70,1],[80,0,80,1],[81,0,81,1],[14,0,14,1],[20,0,20,1],[21,0,21,1],[46,0,46,1],[47,0,47,1],[24,0,24,1],[25,0,25,1],[42,0,42,1],[43,0,43,1],[59,0,59,1],[65,0,65,1],[66,0,66,1],[69,0,69,1],[2,0,2,1],[3,0,3,1],[9,0,9,1],[10,0,10,1],[13,0,13,1],[159,0,159,1],[160,0,160,1],[76,0,76,1],[77,0,77,1],[108,0,108,1],[109,0,109,1],[92,0,92,1],[93,0,93,1],[104,0,104,1],[105,0,105,1],[88,0,88,1],[89,0,89,1],[31,0,31,1],[32,0,32,1],[35,0,35,1],[36,0,36,1],[58,0,58,1],[54,0,54,1],[55,0,55,1]]}
[null,null,null,"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Mismatch\nTrace"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["COMMUNICATION - EXPRESSIVE"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J4:J10)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to verbally, or through adaptive means, understandably express to others their needs in their home or community.\nChoose the option that most accurately reflects the supports required by the individual.\nCheck an option only if the support needed is due to the child's \ndisability.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can communicate their needs with or without the use of adaptive equipment and requires no assistance from another person.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K7),VALUE(IF(ISERROR(VALUE((MID(K7,LEN(K7)-1,1)))),0,MID(K7,LEN(K7)-1,1))&IF(ISERROR(VALUE(MID(K7,LEN(K7)-0,1))),0,MID(K7,LEN(K7)-0,1))),J8)","v":1},"Medical1","CommExp1",true,false]
[null,"Partial Assist: The child requires assistance from another person intermittently to express their needs so others will understand them, with or without adaptive communication devices or systems. \n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K8),VALUE(IF(ISERROR(VALUE((MID(K8,LEN(K8)-1,1)))),0,MID(K8,LEN(K8)-1,1))&IF(ISERROR(VALUE(MID(K8,LEN(K8)-0,1))),0,MID(K8,LEN(K8)-0,1))),J9)","v":1},"Medical1","CommExp2",false,false]
[null,"Full Assist: The child requires ongoing assistance from another person every day to express \ntheir needs so others will understand them, with or without adaptive communication devices or \nsystems.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K9),VALUE(IF(ISERROR(VALUE((MID(K9,LEN(K9)-1,1)))),0,MID(K9,LEN(K9)-1,1))&IF(ISERROR(VALUE(MID(K9,LEN(K9)-0,1))),0,MID(K9,LEN(K9)-0,1))),J10)","v":1},"Medical1","CommExp3",false,false]
["NOTES"]
[]
[]
[]
["COMMUNICATION -  RECEPTIVE"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J15:J21)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to understand information and directions from another\nperson.\nChoose the option that most accurately reflects the supports required by the child.\nCheck an option only if the support needed is due to the child's \ndisability.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The child can understand information conveyed to them.\n\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K18),VALUE(IF(ISERROR(VALUE((MID(K18,LEN(K18)-1,1)))),0,MID(K18,LEN(K18)-1,1))&IF(ISERROR(VALUE(MID(K18,LEN(K18)-0,1))),0,MID(K18,LEN(K18)-0,1))),J19)","v":2},"Medical2","CommAst1",true,false]
[null,"Partial Assist: The child requires intermittent assistance from another person to provide guidance, reminders and direction in order to understand information or directions from another person. \n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K19),VALUE(IF(ISERROR(VALUE((MID(K19,LEN(K19)-1,1)))),0,MID(K19,LEN(K19)-1,1))&IF(ISERROR(VALUE(MID(K19,LEN(K19)-0,1))),0,MID(K19,LEN(K19)-0,1))),J20)","v":2},"Medical2","CommAst2",false,false]
[null,"Full Assist: The child requires continual assistance from another person to provide guidance, reminders and direction in order to understand information or directions from another person.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K20),VALUE(IF(ISERROR(VALUE((MID(K20,LEN(K20)-1,1)))),0,MID(K20,LEN(K20)-1,1))&IF(ISERROR(VALUE(MID(K20,LEN(K20)-0,1))),0,MID(K20,LEN(K20)-0,1))),J21)","v":2},"Medical2","CommAst3",false,false]
["NOTES"]
[]
[]
[]
["SAFETY"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J26:J32)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the ability of a child, age 12 or older, to recognize, understand and protect themselves from potential hazards or harmful situations in their home or community, which are not due to behaviors.\nChoose the option that most accurately reflects the supports required by the child."]
[]
[null,"Independent or Age Appropriate Supports Provided: The child requires no assistance from another person.\n\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K29),VALUE(IF(ISERROR(VALUE((MID(K29,LEN(K29)-1,1)))),0,MID(K29,LEN(K29)-1,1))&IF(ISERROR(VALUE(MID(K29,LEN(K29)-0,1))),0,MID(K29,LEN(K29)-0,1))),J30)","v":3},"Medical3","Safe1",true,false]
[null,"Partial Assist: The child requires intermittent assistance/monitoring from another person to recognize, understand and protect themselves from hazards or harmful situations or people at home or in the community.\n ",null,"Partial Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K30),VALUE(IF(ISERROR(VALUE((MID(K30,LEN(K30)-1,1)))),0,MID(K30,LEN(K30)-1,1))&IF(ISERROR(VALUE(MID(K30,LEN(K30)-0,1))),0,MID(K30,LEN(K30)-0,1))),J31)","v":3},"Medical3","Safe2",false,false]
[null,"Full Assist: The child requires continual assistance/monitoring to recognize, understand and protect themselves from hazards or harmful situations or people at home or in the community.\n",null,"Full Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K31),VALUE(IF(ISERROR(VALUE((MID(K31,LEN(K31)-1,1)))),0,MID(K31,LEN(K31)-1,1))&IF(ISERROR(VALUE(MID(K31,LEN(K31)-0,1))),0,MID(K31,LEN(K31)-0,1))),J32)","v":3},"Medical3","Safe3",false,false]
["NOTES"]
[]
[]
[]
["FIRE EVACUATION"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J37:J43)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to evacuate the home in an emergency.\nChoose the option that most accurately reflects the supports required by the child."]
[]
[null,"Independent or Age Appropriate Supports Provided: The child evacuates with no assistance.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K40),VALUE(IF(ISERROR(VALUE((MID(K40,LEN(K40)-1,1)))),0,MID(K40,LEN(K40)-1,1))&IF(ISERROR(VALUE(MID(K40,LEN(K40)-0,1))),0,MID(K40,LEN(K40)-0,1))),J41)","v":4},"Medical4","Fire1",true,false]
[null,"Partial Assist: The child requires verbal assistance from another person to safely evacuate during an emergency.\n\n",null,"Partial Assist","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K41),VALUE(IF(ISERROR(VALUE((MID(K41,LEN(K41)-1,1)))),0,MID(K41,LEN(K41)-1,1))&IF(ISERROR(VALUE(MID(K41,LEN(K41)-0,1))),0,MID(K41,LEN(K41)-0,1))),J42)","v":4},"Medical4","Fire2",false,false]
[null,"Full Assist: The child must be physically assisted by another person in order to safely evacuate during \nan emergency.\n",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K42),VALUE(IF(ISERROR(VALUE((MID(K42,LEN(K42)-1,1)))),0,MID(K42,LEN(K42)-1,1))&IF(ISERROR(VALUE(MID(K42,LEN(K42)-0,1))),0,MID(K42,LEN(K42)-0,1))),J43)","v":4},"Medical4","Fire3",false,false]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - ORAL"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J48:J54)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's oral medication regimen.\nChoose the option that most accurately reflects the supports required by the child.\nCheck an option only if medication support is due to the child's disability,"]
[]
[null,"Independent or Age Appropriate Supports Provided: Individual does not take any medication or self administers medication with or without provider oversight.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K51),VALUE(IF(ISERROR(VALUE((MID(K51,LEN(K51)-1,1)))),0,MID(K51,LEN(K51)-1,1))&IF(ISERROR(VALUE(MID(K51,LEN(K51)-0,1))),0,MID(K51,LEN(K51)-0,1))),J52)","v":5},"Medical5","MedOral1",true,false]
[null,"Full Assist - 1 to 4: The individual's medication regimen is totally administered and monitored by another \nperson for their 1 to 4 or less medications. \n",null,"Full Assist - 1 to 4","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K52),VALUE(IF(ISERROR(VALUE((MID(K52,LEN(K52)-1,1)))),0,MID(K52,LEN(K52)-1,1))&IF(ISERROR(VALUE(MID(K52,LEN(K52)-0,1))),0,MID(K52,LEN(K52)-0,1))),J53)","v":5},"Medical5","MedOral2",false,false]
[null,"Full Assist - 5 or 6: The individual's medication regimen is totally administered and monitored by another \nperson for their 5 or 6 medications.* \n",null,"Full Assist - 5 or 6","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K53),VALUE(IF(ISERROR(VALUE((MID(K53,LEN(K53)-1,1)))),0,MID(K53,LEN(K53)-1,1))&IF(ISERROR(VALUE(MID(K53,LEN(K53)-0,1))),0,MID(K53,LEN(K53)-0,1))),J54)","v":5},"Medical5","MedOral3",false,false]
[null,"Full Assist - 7 or more: The individual's medication regimen is totally administered and monitored by \nanother person for their 7 or more medications.* \n\n*See individual indicators for a Nursing Assessment Referral",null,"Full Assist - 7 or more","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K54),VALUE(IF(ISERROR(VALUE((MID(K54,LEN(K54)-1,1)))),0,MID(K54,LEN(K54)-1,1))&IF(ISERROR(VALUE(MID(K54,LEN(K54)-0,1))),0,MID(K54,LEN(K54)-0,1))),J55)","v":5},"Medical5","MedOral4",false,false]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - INHALANTS, TOPICALS, SUPPOSITORIES"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J60:J66)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's inhalants, topicals and suppositories regimen.\nChoose the option that most accurately reflects the supports required by the child.  Do not record supports if the child's medication regimen does not include inhalants, topicals or suppositories."]
[]
[null,"Independent or Age Appropriate Supports Provided:  Individual does not require any inhalants, topicals or suppository regimen or self administers medication, with or without provider support.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K63),VALUE(IF(ISERROR(VALUE((MID(K63,LEN(K63)-1,1)))),0,MID(K63,LEN(K63)-1,1))&IF(ISERROR(VALUE(MID(K63,LEN(K63)-0,1))),0,MID(K63,LEN(K63)-0,1))),J64)","v":6},"Medical6","MedInhale1",true,false]
[null,"Partial Assist: The individual's inhalants, topicals, suppository regimen can be administered by the individual, but some aspects must be monitored or completed by another person.* \n",null,"Partial Assist","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K64),VALUE(IF(ISERROR(VALUE((MID(K64,LEN(K64)-1,1)))),0,MID(K64,LEN(K64)-1,1))&IF(ISERROR(VALUE(MID(K64,LEN(K64)-0,1))),0,MID(K64,LEN(K64)-0,1))),J65)","v":6},"Medical6","MedInhale2",false,false]
[null,"Full Assist: The individual's inhalants, topicals, suppository regimen must be administered by another \nperson.* \n\n*See individual indicators for a Nursing Assessment Referral",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K65),VALUE(IF(ISERROR(VALUE((MID(K65,LEN(K65)-1,1)))),0,MID(K65,LEN(K65)-1,1))&IF(ISERROR(VALUE(MID(K65,LEN(K65)-0,1))),0,MID(K65,LEN(K65)-0,1))),J66)","v":6},"Medical6","MedInhale3",false,false]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - INJECTIONS"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J71:J77)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's medication regimen administered by injecting a medication.\nChoose the option that most accurately reflects the supports required by the child.  Do not record supports if the child's medication regimen does not include medications delivered by injection or if the child's injections are administered in a clinical setting."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual does not have any medication administered by injection or self-administers medication, with or without provider support.\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K74),VALUE(IF(ISERROR(VALUE((MID(K74,LEN(K74)-1,1)))),0,MID(K74,LEN(K74)-1,1))&IF(ISERROR(VALUE(MID(K74,LEN(K74)-0,1))),0,MID(K74,LEN(K74)-0,1))),J75)","v":7},"Medical7","MedInject1",true,false]
[null,"Partial Assist: The individual administers their regimen of injection by themselves, but some aspects must be monitored or completed by another person. (e.g. insulin) * \n",null,"Partial Assist","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K75),VALUE(IF(ISERROR(VALUE((MID(K75,LEN(K75)-1,1)))),0,MID(K75,LEN(K75)-1,1))&IF(ISERROR(VALUE(MID(K75,LEN(K75)-0,1))),0,MID(K75,LEN(K75)-0,1))),J76)","v":7},"Medical7","MedInject2",false,false]
[null,"Full Assist: The individual's regimen by injection is totally administered and monitored by another person. (e.g. insulin). * \n\n*See individual indicators for a Nursing Assessment Referral",null,"Full Assist","N/A","None",4,"N/A",null,{"$f":"IF(ISTEXT(K76),VALUE(IF(ISERROR(VALUE((MID(K76,LEN(K76)-1,1)))),0,MID(K76,LEN(K76)-1,1))&IF(ISERROR(VALUE(MID(K76,LEN(K76)-0,1))),0,MID(K76,LEN(K76)-0,1))),J77)","v":7},"Medical7","MedInject3",false,false]
["NOTES"]
[]
[]
[]
["HEALTH MANAGEMENT SUPPORTS - GENERAL"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J82:J88)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to identify and self-direct their physical health \nsupports.  This includes their ability to assist with routine health care decisions and treatments that are not ADL or Medication Management Supports.  \nChoose the option that most accurately reflects the supports required by the child."]
[]
[null,"Independent or Age Appropriate Supports Provided: The child is under age 15, or the child can identify and communicate pain, discomfort or medical needs; access health care in the community independently and follow through with prescribed medication, treatments and dietary requirements. \n\n",null,"Independent or Age Appropriate Supports Provided","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K85),VALUE(IF(ISERROR(VALUE((MID(K85,LEN(K85)-1,1)))),0,MID(K85,LEN(K85)-1,1))&IF(ISERROR(VALUE(MID(K85,LEN(K85)-0,1))),0,MID(K85,LEN(K85)-0,1))),J86)","v":8},"Medical8","HealthSup1",true,false]
[null,"Individual-Directed Care:  The individual can fully self-direct or manage their care, even though the individual is not physically able to provide their own care.  Care that may be individually directed includes physical care, medication administration, treatments and dietary requirements.  \n",null,"Individual-Directed Care","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K86),VALUE(IF(ISERROR(VALUE((MID(K86,LEN(K86)-1,1)))),0,MID(K86,LEN(K86)-1,1))&IF(ISERROR(VALUE(MID(K86,LEN(K86)-0,1))),0,MID(K86,LEN(K86)-0,1))),J87)","v":8},"Medical8","HealthSup2",false,false]
[null,"Partial Assist and Monitoring:  The individual has difficulty recognizing or explaining if they are having pain, discomfort, and/or they require assistance with medication and routine medical/health care needs therefore requiring periodic or weekly monitoring.  They may require assistance with implementation of medical interventions, treatments or dietary requirements.\n\n",null,"Partial Assist and Monitoring","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K87),VALUE(IF(ISERROR(VALUE((MID(K87,LEN(K87)-1,1)))),0,MID(K87,LEN(K87)-1,1))&IF(ISERROR(VALUE(MID(K87,LEN(K87)-0,1))),0,MID(K87,LEN(K87)-0,1))),J88)","v":8},"Medical8","HealthSup3",false,false]
[null,"Full Assist: The individual's health care is managed through a community health care team, which may include the individual's provider and health care professionals such as primary care physicians, dentist, dietician and psychiatrist.  The individual is not able to explain their health care needs or implement the care plan as outlined by the physician, and has current routine medical/health care order(s) that require daily monitoring and assistance to implement medical interventions, treatments and dietary requirements. *\n\n*See individual indicators for a Nursing Assessment Referral",null,"Full Assist","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K88),VALUE(IF(ISERROR(VALUE((MID(K88,LEN(K88)-1,1)))),0,MID(K88,LEN(K88)-1,1))&IF(ISERROR(VALUE(MID(K88,LEN(K88)-0,1))),0,MID(K88,LEN(K88)-0,1))),J89)","v":8},"Medical8","HealthSup4",false,false]
["NOTES"]
[]
[]
[]
["COMPLEX HEALTH MANAGEMENT SUPPORTS"]
[{"$f":"IF(INDEX('Raw Scoring'!R1:R18,MAX(J94:J100)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to self-direct their medical care, intervention or treatment needs for complex medical condition(s) which impact all aspects of their care. This section also assesses the individual's ability to assist with, explain and recognize their need for medical care, interventions or treatments for their complex condition(s).\nChoose the option that most accurately reflects the supports required by the child."]
[]
[null,"Not Applicable:  The individual does not have complex medical conditions.\n",null,"Not Applicable","No","None",0,"HealthCmplx2to1-",null,{"$f":"IF(ISTEXT(K97),VALUE(IF(ISERROR(VALUE((MID(K97,LEN(K97)-1,1)))),0,MID(K97,LEN(K97)-1,1))&IF(ISERROR(VALUE(MID(K97,LEN(K97)-0,1))),0,MID(K97,LEN(K97)-0,1))),J98)","v":9},"Medical9","HealthCmplx1",true,false]
[null,"Independent: The individual can identify and communicate pain, discomfort and/or complex nursing and medical needs; access health care in the community independently and follow through with prescribed medication and treatment plan and dietary requirements.  Their health care needs are stable and predictable.\n",null,"Independent","No","None",0,"HealthCmplx2to1-",null,9,"Medical9","HealthCmplx2",false,false]
[null,"Individual-Directed Care: The individual can fully self-direct or manage their complex medical condition even though they are not physically able to perform the care.  Care that may be directed by the individual includes necessary medical care, medications, treatments, activities of daily living, nutrition and nursing interventions. Their health care needs are stable and predictable.\n",null,"Individual-Directed Care","No","None",1,"HealthCmplx2to1-",null,9,"Medical9","HealthCmplx3",false,false]
[null,"Partial Assist - weekly:  The individual has difficulty explaining and does not recognize the need for care, intervention or treatments for their condition(s).  They require monitoring and direct assistance throughout the week by another person to provide their necessary medical care. Their health care needs are stable and predictable.*\n\n",null,"Partial Assist - weekly","No","None",2,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx4",false,false]
[null,"Partial Assist - 1 to 3 per day:  The individual has difficulty explaining and does not recognize the need for care, intervention or treatments for their condition(s).  They require monitoring and direct assistance 1 to 3 times throughout the day by another person to provide their necessary medical care. Their health care needs are stable and predictable. *\n\n",null,"Partial Assist - 1 to 3 per day","No","None",3,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx5",false,false]
[null,"Full Assist - more than 3 per day: The individual is unable to explain or does not recognize the need for care, intervention or treatments for their condition(s).  They require frequent monitoring and direct assistance more than 3 times throughout the day by another person to provide the necessary medical care. Their health care needs are stable and predictable.* \n",null,"Full Assist - more than 3 per day","No","None",4,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx6",false,false]
[null,"Full Assistance and Monitoring - exclusive focus: The individual is unable to communicate or recognize the need for care, intervention or treatments for their condition(s).  They require exclusive focus by another person for continuous observation and physical assessment throughout the day to provide necessary medical care, medications, treatments, activities of daily living, nutrition and nursing interventions.  This individual requires the establishment of the nursing process to outline treatment plans and establish parameters of care. Their medical condition is unstable. * \n\n* See individual indicators for a Nursing Assessment Referral\n*** OIS training may be required.",null,"Full Assistance and Monitoring - exclusive focus","No","None",5,"HealthCmplx2to1+",null,9,"Medical9","HealthCmplx7",false,false]
[null,"Two-Person Assist: Mark this box when the individual has planned medical treatments that require exclusive focus with physical intervention by 2 people to complete the treatments that assure the health and safety of the individual between the hours of 5 A.M. and 10 P.M. * & *** \n\n",null,"Two-Person Assist","Yes","None","N/A","N/A","Medical9.\n",9,"Medical9","HealthCmplx2to1",false,false]
["NOTES"]
[]
[null,null,null,"** Old, unused \"Nursing\" section removed! **",null,null,null,null,null,null,"Medical10"]
[]
["EQUIPMENT"]
[]
[null,"This section records the individual's use of equipment essential to the individual. \nCheck the boxes for equipment used by the individual."]
[null,null,null,null,null,null,"(Max of…)"]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,"Not Applicable","N/A",null,0,null,null,null,"Medical11","Mobility1",true,false]
[null,"Cane",null,{"$f":"TRIM(B114)","v":"Cane"},"N/A",null,0,null,null,null,"Medical11","Mobility2",false,false]
[null,"Leg braces",null,{"$f":"TRIM(B115)","v":"Leg braces"},"N/A",null,2,null,null,null,"Medical11","Mobility3",false,false]
[null,"Walker",null,"Walker","N/A",null,0,null,null,null,"Medical11","Mobility4",false,false]
[null,"Ankle or foot orthotics",null,"Ankle or foot orthotics","N/A",null,2,null,null,null,"Medical11","Mobility5",false,false]
[null,"Arm splints",null,"Arm splints","N/A",null,2,null,null,null,"Medical11","Mobility6",false,false]
[null,"Adaptive eating equipment (not tube feeding equipment)\n",null,"Adaptive eating equipment\n","N/A",null,1,null,null,null,"Medical11","Mobility7",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,"Not Applicable","N/A",null,0,null,null,null,"Medical12","Bed1",true,false]
[null,"Hospital bed",null,{"$f":"TRIM(B122)","v":"Hospital bed"},"N/A",null,1,null,null,null,"Medical12","Bed2",false,false]
[null,"Grab bars by bed",null,"Grab bars by bed","N/A",null,1,null,null,null,"Medical12","Bed3",false,false]
[null,"Hanging bar above bed\n",null,"Hanging bar above bed\n","N/A",null,1,null,null,null,"Medical12","Bed4",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,"Not Applicable","N/A",null,0,null,null,null,"Medical13","Bath1",true,false]
[null,"Shower chair",null,{"$f":"TRIM(B127)","v":"Shower chair"},"N/A",null,1,null,null,null,"Medical13","Bath2",false,false]
[null,"Grab bars in bathroom",null,"Grab bars in bathroom","N/A",null,3,null,null,null,"Medical13","Bath3",false,false]
[null,"Shower gurney",null,"Shower gurney","N/A",null,4,null,null,null,"Medical13","Bath4",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,"Not Applicable","N/A",null,0,null,null,null,"Medical14","Comm1",true,false]
[null,"Non-electronic communication boards",null,{"$f":"TRIM(B132)","v":"Non-electronic communication boards"},"N/A",null,2,null,null,null,"Medical14","Comm2",false,false]
[null,"Electronic communication boards\n",null,"Electronic communication boards\n","N/A",null,2,null,null,null,"Medical14","Comm3",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,"Not Applicable","N/A",null,0,null,null,null,"Medical15","Transfer1",true,false]
[null,"Hoyer lift",null,{"$f":"TRIM(B136)","v":"Hoyer lift"},"N/A",null,3,null,null,null,"Medical15","Transfer2",false,false]
[null,"Transfer equipment (transfer board)\n",null,"Transfer equipment (transfer board)\n","N/A",null,2,null,null,null,"Medical15","Transfer3",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,"Not Applicable","N/A",null,0,null,null,null,"Medical16","Motion1",true,false]
[null,"Body jacket",null,{"$f":"TRIM(B140)","v":"Body jacket"},"N/A",null,3,null,null,null,"Medical16","Motion2",false,false]
[null,"Manual wheel chair",null,"Manual wheel chair","N/A",null,1,null,null,null,"Medical16","Motion3",false,false]
[null,"Electric power wheel chair",null,"Electric power wheel chair","N/A",null,2,null,null,null,"Medical16","Motion4",false,false]
[null,"Prone stander",null,"Prone stander","N/A",null,2,null,null,null,"Medical16","Motion5",false,false]
[null,"Sidelyer\n",null,"Sidelyer\n","N/A",null,2,null,null,null,"Medical16","Motion6",false,false]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.",null,"Not Applicable","N/A",null,0,null,null,null,"Medical17","Mechan1",true,false]
[null,"Specialized tube feeding equipment*",null,{"$f":"SUBSTITUTE(TRIM(B147),\"*\",\"\")","v":"Specialized tube feeding equipment"},"N/A",null,4,null,null,null,"Medical17","Mechan2",false,false]
[null,"Nebulizer*",null,{"$f":"SUBSTITUTE(TRIM(B148),\"*\",\"\")","v":"Nebulizer"},"N/A",null,3,null,null,null,"Medical17","Mechan3",false,false]
[null,"C-PAP*",null,"C-PAP","N/A",null,3,null,null,null,"Medical17","Mechan4",false,false]
[null,"Oxygen",null,"Oxygen","N/A",null,3,null,null,null,"Medical17","Mechan5",false,false]
[null,"Ventilator",null,"Ventilator","N/A",null,4,null,null,null,"Medical17","Mechan6",false,false]
[null,"Pulse oxymeter*",null,"Pulse oxymeter","N/A",null,2,null,null,null,"Medical17","Mechan7",false,false]
[null,"Heart monitor*",null,"Heart monitor","N/A",null,2,null,null,null,"Medical17","Mechan8",false,false]
[null,"Suctioning equipment",null,"Suctioning equipment","N/A",null,4,null,null,null,"Medical17","Mechan9",false,false]
[null,"Vagus nerve stimulator (VNS)",null,"Vagus nerve stimulator (VNS)","N/A",null,3,null,null,null,"Medical17","Mechan10",false,false]
[null,"Diabetic insulin pump",null,"Diabetic insulin pump","N/A",null,3,null,null,null,"Medical17","Mechan11",false,false]
[null,"Baclofen pump",null,"Baclofen pump","N/A",null,2,null,null,null,"Medical17","Mechan12",false,false]
[null,"Prosthetics",null,"Prosthetics","N/A",null,1,null,null,null,"Medical17","Mechan13",false,false]
[null," * See individual indicators for a Nursing Assessment Referral"]
["NOTES"]

{"sheet":"Nursing Assessment Indicators","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Nighttime Needs","index":4,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[14,0,14,1],[15,0,15,1]]}
[null,null,null,"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Mismatch\nTrace"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["NIGHTTIME NEEDS "]
[{"$f":"IF(INDEX('Raw Scoring'!K1:K3,MAX(J4:J10)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's need for disability related supports and monitoring during nighttime hours.\nChoose the option that most accurately reflects the supports required by the child due to the child's disability.\n"]
[]
[null,"Not Applicable\n",null,"Not Applicable","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K7),VALUE(IF(ISERROR(VALUE((MID(K7,LEN(K7)-1,1)))),0,MID(K7,LEN(K7)-1,1))&IF(ISERROR(VALUE(MID(K7,LEN(K7)-0,1))),0,MID(K7,LEN(K7)-0,1))),J8)","v":1},"Nighttime1","NightAst1",true,false]
[null,"Independent: The child may or may not have difficulty sleeping but requires no assistance from another person during the hours of 10:00 P.M. and 5:00 A.M.\n",null,"Independent","No","None",0,"N/A",null,{"$f":"IF(ISTEXT(K8),VALUE(IF(ISERROR(VALUE((MID(K8,LEN(K8)-1,1)))),0,MID(K8,LEN(K8)-1,1))&IF(ISERROR(VALUE(MID(K8,LEN(K8)-0,1))),0,MID(K8,LEN(K8)-0,1))),J9)","v":1},"Nighttime1","NightAst2",false,false]
[null,"Child Requires Nighttime Assistance - monthly: The child requires occasional monitoring or assistance throughout the month between the hours of 10:00 P.M. and 5:00 A.M.\n",null,"Nighttime Assist - monthly","No","None",0,"N/A",null,1,"Nighttime1","NightAst3",false,false]
[null,"Child Requires Nighttime Assistance - weekly: The child requires occasional monitoring or assistance throughout the week between the hours of 10:00 P.M. and 5:00 A.M.\n",null,"Nighttime Assist - weekly","No","None",1,"N/A",null,1,"Nighttime1","NightAst4",false,false]
[null,"Child Requires Nighttime Assistance - intermittent nightly: The child requires intermittent nightly assistance from another person 1 or more times per night between the hours of 10:00 P.M. and 5:00 A.M.  \n",null,"Nighttime Assist - intermittent nightly","No","None",2,"N/A",null,1,"Nighttime1","NightAst5",false,false]
[null,"Child Requires Nighttime Assistance - ongoing nightly: The child requires ongoing assistance from another person who must remain awake and available to respond between the hours of 10:00 P.M. and 5:00 A.M. ",null,"Nighttime Assist - ongoing nightly","No","None",3,"N/A",null,1,"Nighttime1","NightAst6",false,false]
[null,"Child Requires Nighttime Exclusive Focus: The child requires ongoing exclusive focus assistance from another person between the hours of 10:00 P.M. and 5:00 A.M.   Exclusive focus means that the caregiver must remain awake and provide close monitoring and assistance throughout the night.\n\n",null,"Nighttime 1:1 Assist","No","None",4,"N/A",null,1,"Nighttime1","NightAst7",false,false]
[null,"Child Requires Nighttime 2:1 Assistance: The child requires ongoing exclusive focus assistance from 2 people between the hours of 10:00 P.M. and 5:00 A.M. Assistance can include prompting, physical assistance, repositioning and implementation of medical treatments. \n\n",null,"Nighttime 2:1 Assist","Yes","None",4,"N/A",null,1,"Nighttime1","NightAst8",false,false]
["NOTES"]

{"sheet":"Social and Behavioral Needs","index":5,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[54,0,54,1],[24,0,24,1],[25,0,25,1],[2,0,2,1],[11,0,11,1],[12,0,12,1],[15,0,15,1],[4,0,4,1],[17,0,17,1],[28,0,28,1],[30,0,30,1],[43,0,43,1],[37,0,37,1],[38,0,38,1],[41,0,41,1],[69,0,69,1],[55,0,55,1],[58,0,58,1],[68,0,68,1],[60,0,60,1]]}
[null,null,null,"Support Need","No","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Mismatch\nTrace"]
[null,"Rating selections must be applied in accordance with the “ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["BEHAVIORAL SUPPORTS - NO FORMAL PLAN - SUPERVISON AND MONITORING"]
[null,"Supervision and monitoring for behavior and mental health"]
[{"$f":"IF(INDEX('Raw Scoring'!Y1:Y6,MAX(J5:J11)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to function in a home and community environment with behavioral supports from another person to maintain safety of self and/or others.  \nThese behaviors do not require a formal behavior support plan and are not addressed in a formal BSP.\nChoose the option that most accurately reflects the behavior supports required by the child.  Do not record supervision needed to address non-behavioral safety or health issues.  Check an option only if supports are needed due to the child's disability."]
[]
[null,"Not Applicable or Age-Appropriate Supervision:  The child does not require supervision or monitoring from another person for behavioral issues or, for a child, age-appropriate supervision or monitoring is provided.\n",null,"Not Applicable or Age-Appropriate Supervision","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K8),VALUE(IF(ISERROR(VALUE((MID(K8,LEN(K8)-1,1)))),0,MID(K8,LEN(K8)-1,1))&IF(ISERROR(VALUE(MID(K8,LEN(K8)-0,1))),0,MID(K8,LEN(K8)-0,1))),J9)","v":1},"Behavior1","BehavMin1",true,false]
[null,"Redirecting:  The child has a transition plan, ISP or mental health guidelines that require redirection \nduring waking hours, to assure the safety of the child.  This behavior does not require a formal \nbehavior support plan and is not addressed in any formal BSP.\n",null,"Redirecting","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K9),VALUE(IF(ISERROR(VALUE((MID(K9,LEN(K9)-1,1)))),0,MID(K9,LEN(K9)-1,1))&IF(ISERROR(VALUE(MID(K9,LEN(K9)-0,1))),0,MID(K9,LEN(K9)-0,1))),J10)","v":1},"Behavior1","BehavMin2",false,false]
[null,"Within Hearing or Visual Distance:  The child has a transition plan, ISP or mental health \nguidelines that require supervision for safety, within hearing distance or visual range, during waking hours.  \nThis behavior does not require a formal behavior support plan and is not addressed in any formal BSP.\n",null,"Within Hearing or Visual Distance","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K10),VALUE(IF(ISERROR(VALUE((MID(K10,LEN(K10)-1,1)))),0,MID(K10,LEN(K10)-1,1))&IF(ISERROR(VALUE(MID(K10,LEN(K10)-0,1))),0,MID(K10,LEN(K10)-0,1))),J11)","v":1},"Behavior1","BehavMin3",false,false]
[null,"Within Hearing and Visual Distance:  The child has a transition plan, ISP or mental health \nguidelines requiring visual range and hearing distance supervision during waking hours.  This behavior \ndoes not require a formal behavior support plan and is not addressed in any formal BSP.\n",null,"Within Hearing and Visual Distance","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K11),VALUE(IF(ISERROR(VALUE((MID(K11,LEN(K11)-1,1)))),0,MID(K11,LEN(K11)-1,1))&IF(ISERROR(VALUE(MID(K11,LEN(K11)-0,1))),0,MID(K11,LEN(K11)-0,1))),J12)","v":1},"Behavior1","BehavMin4",false,false]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - PLANS - HOME AND COMMUNITY"]
[null,"Supervision, monitoring and plans for behavior and mental health"]
[{"$f":"IF(INDEX('Raw Scoring'!Y1:Y6,MAX(J18:J24)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to function in a home and community environment with behavioral supports and intervention from another person to maintain safety of self and/or others.  \nChoose the option that most accurately reflects the supports required by the child."]
[]
[null,"Not Applicable:  The child does not have behavioral or mental health needs that require a plan.\n",null,"Not Applicable","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K21),VALUE(IF(ISERROR(VALUE((MID(K21,LEN(K21)-1,1)))),0,MID(K21,LEN(K21)-1,1))&IF(ISERROR(VALUE(MID(K21,LEN(K21)-0,1))),0,MID(K21,LEN(K21)-0,1))),J22)","v":2},"Behavior2","BehavFormal1",true,false]
[null,"Behavior Plan - No Physical Interventions:  The child has a behavior support need that requires a formal behavior plan, which does not include physical intervention(s). **\n",null,"Behavior Plan - No Physical Interventions","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K22),VALUE(IF(ISERROR(VALUE((MID(K22,LEN(K22)-1,1)))),0,MID(K22,LEN(K22)-1,1))&IF(ISERROR(VALUE(MID(K22,LEN(K22)-0,1))),0,MID(K22,LEN(K22)-0,1))),J23)","v":2},"Behavior2","BehavFormal2",false,false]
[null,"Behavior Plan:  The child has a behavior support need that requires a formal behavior plan, which does include physical intervention(s). ** &***\n",null,"Behavior Plan - Physical Interventions","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K23),VALUE(IF(ISERROR(VALUE((MID(K23,LEN(K23)-1,1)))),0,MID(K23,LEN(K23)-1,1))&IF(ISERROR(VALUE(MID(K23,LEN(K23)-0,1))),0,MID(K23,LEN(K23)-0,1))),J24)","v":2},"Behavior2","BehavFormal3",false,false]
[null,"Mental Health Plan:  The child has a mental health support need that requires mental health guidelines written by a mental health professional.  The mental health plan may include a crisis response plan. ***\n\nIf you check any questions in the behavioral section marked with a ** then the ISP team must meet and discuss the necessity of a functional assessment (FA) and/or a formal behavior support plan.\n*** OIS training is required for all paid providers.",null,"Mental Health Plan","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K24),VALUE(IF(ISERROR(VALUE((MID(K24,LEN(K24)-1,1)))),0,MID(K24,LEN(K24)-1,1))&IF(ISERROR(VALUE(MID(K24,LEN(K24)-0,1))),0,MID(K24,LEN(K24)-0,1))),J25)","v":2},"Behavior2","BehavFormal4",false,false]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISON - HOME"]
[null,"Supervision and monitoring for behavior, mental health or legally mandated supervision in the home environment."]
[{"$f":"IF(INDEX('Raw Scoring'!Y1:Y6,MAX(J31:J37)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to function in the home with supports and interventions from another person to maintain safety of self and/or others. Choose the option that most accurately reflects the behavior supports required by the child.  Do not record supervision needed to address non-behavioral safety or health issues.  Check an option only if supports are needed due to the child's disability.\n"]
[]
[null,"Not Applicable or Age-Appropriate Supervision:  The child does not require supervision or monitoring from another person for behavioral issues or, for a child, age-appropriate supervision or monitoring is provided.\n",null,"Not Applicable or Age-Appropriate Supervision","N/A","None",0,"N/A",null,{"$f":"IF(ISTEXT(K34),VALUE(IF(ISERROR(VALUE((MID(K34,LEN(K34)-1,1)))),0,MID(K34,LEN(K34)-1,1))&IF(ISERROR(VALUE(MID(K34,LEN(K34)-0,1))),0,MID(K34,LEN(K34)-0,1))),J35)","v":3},"Behavior3","BehavPlan1",true,false]
[null,"Redirecting:  The child has or needs a formal behavior plan, a legal order, or mental health guidelines that require redirection during waking hours, to assure the safety of the child. **\n",null,"Redirecting","N/A","None",1,"N/A",null,{"$f":"IF(ISTEXT(K35),VALUE(IF(ISERROR(VALUE((MID(K35,LEN(K35)-1,1)))),0,MID(K35,LEN(K35)-1,1))&IF(ISERROR(VALUE(MID(K35,LEN(K35)-0,1))),0,MID(K35,LEN(K35)-0,1))),J36)","v":3},"Behavior3","BehavPlan2",false,false]
[null,"Within Hearing or Visual Distance:  The child has or needs a formal behavior plan, a legal order, or mental health guidelines that require supervision of the child to be within hearing or visual distance. **\n",null,"Within Hearing or Visual Distance","N/A","None",2,"N/A",null,{"$f":"IF(ISTEXT(K36),VALUE(IF(ISERROR(VALUE((MID(K36,LEN(K36)-1,1)))),0,MID(K36,LEN(K36)-1,1))&IF(ISERROR(VALUE(MID(K36,LEN(K36)-0,1))),0,MID(K36,LEN(K36)-0,1))),J37)","v":3},"Behavior3","BehavPlan3",false,false]
[null,"Within Hearing and Visual Distance:  The child has or needs a formal behavior plan, a legal order, or mental health guidelines that require supervision of the child to be within hearing and visual distance. **\n\nIf you check any questions in the behavioral section marked with a ** and the child has or needs a formal behavior plan, then a functional assessment (FA) must be completed and a formal behavior support plan must be developed, if indicated by the FA.",null,"Within Hearing and Visual Distance","N/A","None",3,"N/A",null,{"$f":"IF(ISTEXT(K37),VALUE(IF(ISERROR(VALUE((MID(K37,LEN(K37)-1,1)))),0,MID(K37,LEN(K37)-1,1))&IF(ISERROR(VALUE(MID(K37,LEN(K37)-0,1))),0,MID(K37,LEN(K37)-0,1))),J38)","v":3},"Behavior3","BehavPlan4",false,false]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISION - HOME - EXCLUSIVE FOCUS"]
[null,"Supervision and monitoring for behavior, mental health or legally mandated supervision in the home environment."]
[{"$f":"IF(INDEX('Raw Scoring'!Y1:Y6,MAX(J44:J50)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child’s need for supervision and monitoring requiring the “exclusive focus” of a caregiver to maintain safety of self and/or others.\n\nExclusive focus means that the caregiver must provide complete and uninterrupted attention to the child to the degree that no other task can completed while the caregiver is responsible for the supervision of the child including supervision of other children or adults requiring care, household tasks, or personal social or recreational activity.\n\nThe need for exclusive focus supervision and monitoring must be based on a pattern of behavior that either a) has resulted in injury to the child or others that required professional medical attention; or b) presents a direct and significant risk of injury severe enough to require professional medical attention.\n\nNOTE REQUIRED:  If Exclusive Focus hours are recorded in this section, the type of behavior(s), history of injury, and frequency/duration of episodes of behavior of an intensity likely to result in injury must be recorded in the notes field. \n\nChoose the option that most accurately reflects the behavior supports required by the child.\nDo not record supervision needed to address non-behavioral safety or health issues.\nCheck an option only if supports are needed due to the child's disability.\n"]
[]
[null,"Not Applicable: The child does not require Exclusive Focus or two-on-one supervision in the home.\n",null,"Not Applicable","No","None",0,"InHome2to1-",null,{"$f":"IF(ISTEXT(K47),VALUE(IF(ISERROR(VALUE((MID(K47,LEN(K47)-1,1)))),0,MID(K47,LEN(K47)-1,1))&IF(ISERROR(VALUE(MID(K47,LEN(K47)-0,1))),0,MID(K47,LEN(K47)-0,1))),J48)","v":4},"Behavior4","BehavInHome1",true,false]
[null,"Exclusive Focus - 2:  The child has or needs a formal behavior plan, has a legal order or mental health guidelines that require \"exclusive focus\" supervision.  A caregiver must maintain an exclusive focus on the child between the hours of 5:00 A.M. and 10:00 P.M. up to 2 hours a day.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"Exclusive Focus - 2","No","None",1,"InHome2to1+",null,4,"Behavior4","BehavInHome2",false,false]
[null,"Exclusive Focus - 4: The child has or needs a formal behavior plan, has a legal order or mental health guidelines that require \"exclusive focus\" supervision.  A caregiver must maintain an exclusive focus on the child between the hours of 5:00 A.M. and 10:00 P.M. up to 4 hours a day.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"Exclusive Focus - 4","No","None",2,"InHome2to1+",null,4,"Behavior4","BehavInHome3",false,false]
[null,"Exclusive Focus - 6: The child has or needs a formal behavior plan, has a legal order or mental health guidelines that require \"exclusive focus\" supervision.  A caregiver must maintain an exclusive focus on the child between the hours of 5:00 A.M. and 10:00 P.M. up to 6 hours a day.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"Exclusive Focus - 6","No","None",3,"InHome2to1+",null,4,"Behavior4","BehavInHome4",false,false]
[null,"Exclusive Focus - 8: The child has or needs a formal behavior plan, has a legal order or mental health guidelines that require \"exclusive focus\" supervision.  A caregiver must maintain an exclusive focus on the child between the hours of 5:00 A.M. and 10:00 P.M. up to 8 hours a day.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"Exclusive Focus - 8","No","None",4,"InHome2to1+",null,4,"Behavior4","BehavInHome5",false,false]
[null,"Exclusive Focus - 10: The child has or needs a formal behavior plan, has a legal order or mental health guidelines that require \"exclusive focus\" supervision.  A caregiver must maintain an exclusive focus on the child between the hours of 5:00 A.M. and 10:00 P.M. up to 10 hours a day.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"Exclusive Focus - 10","No","None",5,"InHome2to1+",null,4,"Behavior4","BehavInHome6",false,false]
[null,"Exclusive Focus - 12: The child has or needs a formal behavior plan, has a legal order or mental health guidelines that require \"exclusive focus\" supervision.  A caregiver must maintain an exclusive focus on the child between the hours of 5:00 A.M. and 10:00 P.M. up to 12 hours a day.  ** See nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"Exclusive Focus - 12","No","None",6,"InHome2to1+",null,4,"Behavior4","BehavInHome7",false,false]
[null,"Two-Person Assist: The child has or needs a formal behavior plan, has a legal order or mental health guidelines that require 2:1 exclusive focus on the child between the hours of  5:00 A.M. and 10:00 P.M.  **\nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of Caregivers' schedule and duties is required.\n\nIf you check any questions in the behavioral section marked with a ** and the child has or needs a formal behavior plan, then a functional assessment (FA) must be completed and a formal behavior support plan must be developed, if indicated by the FA.",null,"Two-Person Assist","Yes","None","N/A","N/A","Behavior4.\n",4,"Behavior4","InHome2to1",false,false]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISION - COMMUNITY"]
[null,"Supervision and monitoring for behavior, mental health or legally mandated supervision in the \ncommunity."]
[{"$f":"IF(INDEX('Raw Scoring'!Y1:Y6,MAX(J61:J67)+1)=\"Yes\",\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the child's ability to function in the community with supports and interventions from another person to maintain safety of self and/or others.\nChoose the option that most accurately reflects the behavior supports required by the child.  Do not record supervision needed to address non-behavioral safety or health issues.  Check an option only if supports are needed due to the child's disability."]
[]
[null,"Not Applicable: The child does not require supervision or monitoring from another person for behavioral issues in the community.\n",null,"Not Applicable","No","None",0,"Cmty2to1-",null,{"$f":"IF(ISTEXT(K64),VALUE(IF(ISERROR(VALUE((MID(K64,LEN(K64)-1,1)))),0,MID(K64,LEN(K64)-1,1))&IF(ISERROR(VALUE(MID(K64,LEN(K64)-0,1))),0,MID(K64,LEN(K64)-0,1))),J65)","v":5},"Behavior5","BehavCmty1",true,false]
[null,"Within Hearing or Visual Distance: The child has or needs a formal behavior plan, legal order, or mental health guidelines that require supervision of the child to be within hearing or visual distance while in the community.  **\n\n",null,"Within Hearing or Visual Distance","No","None",3,"Cmty2to1+",null,{"$f":"IF(ISTEXT(K65),VALUE(IF(ISERROR(VALUE((MID(K65,LEN(K65)-1,1)))),0,MID(K65,LEN(K65)-1,1))&IF(ISERROR(VALUE(MID(K65,LEN(K65)-0,1))),0,MID(K65,LEN(K65)-0,1))),J66)","v":5},"Behavior5","BehavCmty2",false,false]
[null,"Within Hearing and Visual Distance: The child has or needs a formal behavior plan, legal order, or mental health guidelines that require supervision of the child to be within hearing and visual distance while in the community.  **\n\n",null,"Within Hearing and Visual Distance","No","None",4,"Cmty2to1+",null,{"$f":"IF(ISTEXT(K66),VALUE(IF(ISERROR(VALUE((MID(K66,LEN(K66)-1,1)))),0,MID(K66,LEN(K66)-1,1))&IF(ISERROR(VALUE(MID(K66,LEN(K66)-0,1))),0,MID(K66,LEN(K66)-0,1))),J67)","v":5},"Behavior5","BehavCmty3",false,false]
[null,"Exclusive Focus:  The child has or needs a formal behavior plan, has a legal order or mental health \nguidelines that require exclusive focus supervision in the community.  A caregiver must maintain an exclusive \nfocus on the child while in the community.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n",null,"Exclusive Focus","No","None",4,"Cmty2to1+",null,{"$f":"IF(ISTEXT(K67),VALUE(IF(ISERROR(VALUE((MID(K67,LEN(K67)-1,1)))),0,MID(K67,LEN(K67)-1,1))&IF(ISERROR(VALUE(MID(K67,LEN(K67)-0,1))),0,MID(K67,LEN(K67)-0,1))),J68)","v":5},"Behavior5","BehavCmty4",false,false]
[null,"Two-Person Assist: The child has or needs a formal behavior plan, has a legal order or mental health \nguidelines that require 2:1 exclusive focus on the child while in the community.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' schedule and duties is required.\n\nIf you check any questions in the behavioral section marked with a * then the ISP team must meet and discuss the necessity of a functional assessment (FA) and/or a formal behavior support plan.",null,"Two-Person Assist","Yes","None","N/A","N/A","Behavior5.\n",{"$f":"IF(ISTEXT(K68),VALUE(IF(ISERROR(VALUE((MID(K68,LEN(K68)-1,1)))),0,MID(K68,LEN(K68)-1,1))&IF(ISERROR(VALUE(MID(K68,LEN(K68)-0,1))),0,MID(K68,LEN(K68)-0,1))),J69)","v":5},"Behavior5","Cmty2to1",false,false]
["NOTES"]

{"sheet":"Enhanced or Exceptional","index":6,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[31,0,31,1],[42,0,42,1]]}
[null,null,null,"Support Need","2:1 Review?","Documentation Needed","Selection\nValue","En/Dis-able\nOther","Disabled\nBy","Group #","Group","Name","Current\nState","Mismatch\nTrace"]
[null,"Rating selections must be applied in accordance with “Enhanced/Exceptional Insert to the ANA/CNA Manual version 3”, available at http://www.dhs.state.or.us/spd/tools/dd/cm/"]
["ENHANCED or EXCEPTIONAL NEEDS "]
[]
[]
[null,"Nursing Tasks:  check the box for all nursing tasks for which the individual requires physical assistance from a caregiver.  Do not include tasks that the individual completes independently and for which the individual requires only monitoring, reminders or cuing.  Do not include tasks which are performed in a clinical setting by professional staff or which are performed by home health nurse."]
[]
[null,"Ventilator -- Mechanical ventilation monitoring and care (does not include CPAP/BiPAP).",null,null,null,null,4,null,null,null,"EE_Nursing1","Ventilator1",false,false]
[null,"CPAP/BiPAP -- Individual requires daily assistance and monitoring use of CPAP or BiPAP.",null,null,null,null,2,null,null,null,"EE_Nursing1","CPAP2",false,false]
[null,"Oxygen -- Administration and monitoring of oxygen on a daily or near daily basis.",null,null,null,null,1,null,null,null,"EE_Nursing1","Oxygen3",false,false]
[null,"Extensive respiratory treatment - respiratory treatment, one or more times daily, such as: chest percussion (including use of percussion vest), postural drainage, nebulizer or tracheal aerosol therapy.  Do not include use of inhaler(s), oxygen or suctioning.",null,null,null,null,2,null,null,null,"EE_Nursing1","Resp4",false,false]
[null,"Tracheotomy care - includes maintenance/cuff inflation.",null,null,null,null,2,null,null,null,"EE_Nursing1","Trach5",false,false]
[null,"Suctioning airway, tracheal or nasopharyngeal suctioning one or more times daily to prevent aspiration.  Do not check when suctioning is limited to the oral cavity.",null,null,null,null,2,null,null,null,"EE_Nursing1","Suction6",false,false]
[null,"Stoma care -- includes cleansing and dressing changes at the opening where the tube (e.g. tracheostomy, colostomy, gastrostomy or urostomy) enter the body.",null,null,null,null,1,null,null,null,"EE_Nursing1","Stoma7",false,false]
[null,"Tube feeding -- Feedings administered via nasogastric, gastrostomy or jejunostomy tube one or more times every day.",null,null,null,null,2,null,null,null,"EE_Nursing1","FeedingTube8",false,false]
[null,"Diabetes management which includes all of the following components: daily blood glucose testing and administration of sliding scale insulin by the caregiver and management of diabetic diet.",null,null,null,null,1,null,null,null,"EE_Nursing1","Diabetes9",false,false]
[null,"Central Line, Intravenous (IV) injections/infusions; and/or daily intramuscular or subcutaneous injections -- include only those injections/infusions administered by a caregiver.  Do not include injections/infusions administered by a medical professional in a clinical setting or providing support through a hospice or outpatient program.",null,null,null,null,2,null,null,null,"EE_Nursing1","Injection10",false,false]
[null,"Dialysis -- peritoneal dialysis or hemodialysis administered by the caregiver in the home.  Do not include dialysis treatments administered in a clinical setting.",null,null,null,null,3,null,null,null,"EE_Nursing1","Dialysis11",false,false]
[null,"Shunt (cerebral) -- Includes daily documented neuro-checks.",null,null,null,null,2,null,null,null,"EE_Nursing1","Shunt12",false,false]
[null,"Vital sign monitoring (temperature, respiration, heart rate and blood pressure) one or more times per day when results are recorded as ordered by the primary care provider.  Do not include monitoring that does not include documentation of results or was not ordered by the primary care provider.",null,null,null,null,1,null,null,null,"EE_Nursing1","VitalSigns13",false,false]
[null,"Seizure interventions (treatments) required on 2 or more days per month, not including scheduled medications.  Count only medical treatments ordered to stop the seizure(s).  Do not include monitoring, timing of seizures, removing dangerous objects or other actions a caregiver may perform but which are not a treatment to stop the seizure(s).",null,null,null,null,2,null,null,null,"EE_Nursing1","Seisure14",false,false]
[null,"Baclofen pump -- close monitoring for adverse effects. ",null,null,null,null,1,null,null,null,"EE_Nursing1","MedPump15",false,false]
[null,"Wound care/ulcer care other than amputation site  care -- Include open wounds which require assessment by a medical professional to evaluate appropriate treatment, and stage III or IV ulcers ( a skin ulcer, including pressure sores, which results in full loss of skin and tissue and may extend into muscle or bone.)    Do not include minor injuries requiring only first aid, or preventative treatment for an individual who is at risk, but does not currently have a stage III or IV skin ulcer.",null,null,null,null,2,null,null,null,"EE_Nursing1","WoundCare16",false,false]
[null,"Amputation site care for new amputation.  Includes monitoring for infection, application and monitoring of compression bandage.  ",null,null,null,null,2,null,null,null,"EE_Nursing1","SumpCare17",false,false]
[null,"Colostomy/Urostomy/Ileostomy care -- monitoring, tracking and disposal of output, and maintenance of ostomy device/tubing.",null,null,null,null,1,null,null,null,"EE_Nursing1","Ostomy18",false,false]
[null,"Digital Stimulation/Impaction removal -- Individual requires digital stimulation of the bowel or digital removal of stool lodged in the rectum on a daily or near daily basis.  Do not include other bowel care.  Do not include care performed by a medical professional other than the caregiver.",null,null,null,null,1,null,null,null,"EE_Nursing1","ImpactionCare19",false,false]
[null,"Urinary Catheterization --Care must be daily or more frequently.  Includes care for indwelling catheter or suprapubic catheter or insertion of a catheter (intermittent catheterization.).  Does not include use of a condom catheter.",null,null,null,null,1,null,null,null,"EE_Nursing1","Cath20",false,false]
[null,"Mechanical Lift/Stander/Sidelyer/Body Jacket -- individual requires use of a mechanical lift for all transfers or requires a stander, sidelyer and/or body jacket on a daily basis. ",null,null,null,null,1,null,null,null,"EE_Nursing1","Positioning21",false,false]
[null,"Requires awake caregiver 20 or more hours per day to monitor medical status and complete nursing tasks.\n*Count only if an awake caregiver is required 20 or more hours per day on a daily basis.\n*Do not check if awake caregiver is occasionally required 20 or more hours per day.\n*Do not check if the individual has an altered sleep schedule but routinely has a period of more than 4\n   hours during day during which an awake caregiver is not required.\n*Count only if medical needs include a risk to health and safety and cannot safely be addressed through\n   adaptations such as medical alarms. \n",null,null,null,null,true,null,null,null,"EE_Nursing1","TwentyHrs22",false,false]
[null,"None of the above",null,null,null,null,true,null,null,null,"EE_Nursing1","None23",false,false]
["NOTES"]
[]
[]
[null,"Behavior Supports:  Check all that are true.  Record only plans and interventions that are actually in place at the time of this assessment.  (Note: this is a different basis than is applied to the similar questions on the behavior tab.)"]
[]
[null,"Behavior Support Plan implementation - individual has a Behavior Support Plan (or Mental Health Plan) which includes specific proactive supports, reactive supports and crisis supports.  The plan is currently being implemented by caregivers and caregivers document the incidence of behaviors.  Include only behavior support plans or mental health plans which address behaviors that are dangerous or have a significant negative impact to the individual's ability to complete or receive support for ADL, IADL or health related activities.\n\n* Do not include behavior guideline, interaction guideline or safety guideline documents that are not a full BSP.\n\n* Do not include behavior documents that are designed to be implemented by the individual rather than by the caregiver.",null,null,null,null,3,"SupPlanRevised2\nCmplxTools3\nPPI4\nTwentyHrs5",null,null,"EE_Behav1","SupPlanImpl1",false,false]
[null,"Behavior Support Plan Revision -- the individual's Behavior Support Plan has been revised 2 or more times in the last 12 months to address new behaviors, or to address significant changes in behavior or significant changes in the effectiveness of the behavior support strategies.  A significant change is one which results in the addition or substitution of a behavior support strategy not previously contained in the plan.  Significant changes do not include adjustments to existing strategies such as changing the type of reward provided when a behavior goal is met or adjustment of visual tools used to implement the plan.",null,null,null,null,1,null,"SupPlanImpl1.\n",null,"EE_Behav1","SupPlanRevised2",false,false]
[null,"Development of complex tools used in BSP -- the individual’s BSP includes complex behavior support tools that must be developed and significantly altered by a caregiver one or more times per month.  Complex behavior support tools are tools that require specific training to develop and adapt such as social stories or visual structure systems.  These tools must be developed and adapted by the caregiver as new triggers are encountered or changes in behavior occur.  Do not include tools developed by someone other than the caregiver or minor changes to existing or prefabricated tools.",null,null,null,null,1,null,"SupPlanImpl1.\n",null,"EE_Behav1","CmplxTools3",false,false]
[null,"Protective Physical Interventions -- the individual has a behavior support plan which includes protective physical interventions;  AND protective physical interventions have been used to keep the individual safe in crisis situations at one of the following intervals:\n-PPIs (not including deflection, evasion or body positioning) have been needed 3 or more times in the last 6 months; OR\n-PPIs (not including deflection, evasion or body positioning) have been needed 5 or more times in the last 12 months; OR\n-PPIs, including deflection, evasion , or body positioning maneuvers have been needed at least weekly throughout the last 6 months; OR \n-Individual has had a BSP which includes PPIs for less than 6 months AND the emergency services, crisis intervention services or protective services were utilized to address  a dangerous behavior 2 or more times in the past 12 months.",null,null,null,null,1,null,"SupPlanImpl1.\n",null,"EE_Behav1","PPI4",false,false]
[null,"Requires awake caregiver 20 or more hours per day to provide behavior supports.  Individual has behaviors which occur during both day and nighttime hours and could not be safely addressed without active supervision by an awake caregiver.\n\n*Count only if an awake caregiver is required 20 or more hours per day on a daily basis.\n*Do not check if awake caregiver is occasionally required 20 or more hours per day.\n*Do not check if the individual has an altered sleep schedule but routinely has a sleep period of more than 4\n   hours per day during which an awake caregiver is not required.\n*Count only if behaviors include a risk to health and safety and cannot safely be addressed through\n   environmental adaptations. \n",null,null,null,null,true,null,"SupPlanImpl1.\n",null,"EE_Behav1","TwentyHrs5",false,false]
[null,"None of the above",null,null,null,null,true,null,null,null,"EE_Behav1","None6",false,false]
["NOTES"]

{"sheet":"Support Needs Summary","index":7,"n_rows":173,"n_cols":4,"rows_kept":173,"cut":false,"hidden":false,"merged":[]}
["SUPPORT NEEDS SUMMARY"]
[]
["ADLs","Support Needs Category"]
[null,{"$f":"ADLs!$A3","v":"AMBULATION / MOBILITY IN THE HOME AND COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A15","v":"TRANSFERRING / POSITIONING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A27","v":"FOOD PREPARATION"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A38","v":"EATING / DRINKING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A51","v":"BLADDER CONTROL"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A63","v":"BOWEL CONTROL"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A75","v":"TOILETING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A87","v":"HYGIENE (INCLUDING ORAL HYGIENE)"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A99","v":"BATHING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A111","v":"LAUNDRY AND HOUSEKEEPING "}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A122","v":"DRESSING & HAIR CARE"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!$A133","v":"SHOPPING AND MONEY MANAGEMENT"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
["Medical Needs","Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A3","v":"COMMUNICATION - EXPRESSIVE"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A14","v":"COMMUNICATION -  RECEPTIVE"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A25","v":"SAFETY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A36","v":"FIRE EVACUATION"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A47","v":"MEDICATION MANAGEMENT SUPPORTS - ORAL"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A59","v":"MEDICATION MANAGEMENT SUPPORTS - INHALANTS, TOPICALS, SUPPOSITORIES"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A70","v":"MEDICATION MANAGEMENT SUPPORTS - INJECTIONS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A81","v":"HEALTH MANAGEMENT SUPPORTS - GENERAL"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Medical Needs'!$A93","v":"COMPLEX HEALTH MANAGEMENT SUPPORTS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
["Med. Enh./Except.","(None)"]
[null,"Ventilator monitoring and care"]
[null,"CPAP/BiPAP assistance and monitoring"]
[null,"Oxygen administration and monitoring"]
[null,"Extensive respiratory treatment"]
[null,"Tracheotomy care"]
[null,"Suctioning airway"]
[null,"Stoma care"]
[null,"Tube feeding"]
[null,"Diabetes management"]
[null,"Injections/infusions"]
[null,"Dialysis (by the caregiver in the home)"]
[null,"Shunt (cerebral) monitoring and care"]
[null,"Monitoring of vital signs"]
[null,"Seizure interventions"]
[null,"Baclofen pump monitoring and assistance"]
[null,"Wound care/ulcer care"]
[null,"Stump care for new amputation"]
[null,"Colostomy/urostomy/ileostomy care"]
[null,"Impaction removal"]
[null,"Urinary catheterization"]
[null,"Mechanical lift, stander, sidelyer, or bodyJacket"]
[null,"Awake caregiver required 20 or more hours per day"]
["Equipment","(None)"]
[null,"Cane"]
[null,"Leg braces"]
[null,"Walker"]
[null,"Ankle or foot orthotics"]
[null,"Arm splints"]
[null,"Adaptive eating equipment (not tube feeding equipment)"]
[null,"Hospital bed"]
[null,"Grab bars by bed"]
[null,"Hanging bar above bed"]
[null,"Shower chair"]
[null,"Grab bars in bathroom"]
[null,"Shower gurney"]
[null,"Non-electronic communication boards"]
[null,"Electronic communication boards"]
[null,"Hoyer lift"]
[null,"Transfer equipment (transfer board)"]
[null,"Body jacket"]
[null,"Manual wheel chair"]
[null,"Electric power wheel chair"]
[null,"Prone stander"]
[null,"Sidelyer"]
[null,"Specialized tube feeding equipment"]
[null,"Nebulizer"]
[null,"C-PAP"]
[null,"Oxygen"]
[null,"Ventilator"]
[null,"Pulse oxymeter"]
[null,"Heart monitor"]
[null,"Suctioning equipment"]
[null,"Vagus nerve stimulator (VNS)"]
[null,"Diabetic insulin pump"]
[null,"Baclofen pump"]
[null,"Prosthetics"]
["Nighttime Needs","Support Needs Category"]
[null,{"$f":"'Nighttime Needs'!A3","v":"NIGHTTIME NEEDS "}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
["Behavior Needs","Support Needs Category","No","None"]
[null,{"$f":"'Social and Behavioral Needs'!A3","v":"BEHAVIORAL SUPPORTS - NO FORMAL PLAN - SUPERVISON AND MONITORING"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable or Age-Appropriate Supervision","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A16","v":"BEHAVIORAL SUPPORTS - PLANS - HOME AND COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A29","v":"BEHAVIORAL SUPPORTS - SUPERVISON - HOME"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable or Age-Appropriate Supervision","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A42","v":"BEHAVIORAL SUPPORTS - SUPERVISION - HOME - EXCLUSIVE FOCUS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
[null,"Support Needs Category"]
[null,{"$f":"'Social and Behavioral Needs'!A59","v":"BEHAVIORAL SUPPORTS - SUPERVISION - COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","N/A","N/A"]
["Behav. Enh./Except.","(None)"]
[null,"Behavior support plan, implementation "]
[null,"Behavior documentation data"]
[null,"Behavior support plan, multiple revisions"]
[null,"Protective physical interventions"]
[null,"Awake caregiver required 20 or more hours per day"]

{"sheet":"Summary of In-Home Hours","index":8,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,0,24,0],[23,1,24,5],[21,4,21,5],[12,0,12,2],[9,4,12,5],[15,0,15,1],[11,0,11,2],[21,1,21,2],[20,0,20,5],[13,0,13,2],[17,0,18,2],[19,0,19,5],[13,3,13,4],[16,3,16,5],[0,0,0,5],[4,0,4,2],[1,4,1,5],[2,4,2,5],[1,1,1,2],[2,1,2,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[5,0,5,2],[3,0,3,2],[6,0,6,2],[7,0,7,2],[10,0,10,2],[8,0,8,2],[9,0,9,2]]}
["In Home Needs Summary - Children"]
["Name of Individual ",{"$f":"IF(ClientName=0,\"\",ClientName)","v":""},null,"Date of Birth ",{"$f":"IF(ClientDOB=0,\"\",ClientDOB)","v":""}]
["Date of Assessment ",{"$f":"IF(AssessmentDate=0,\"\",AssessmentDate)","v":""},null,"Age ",{"$f":"ClientAge","v":""}]
[null,null,null,"Assessed Hours\nPer Day","2:1 Review Required?",{"$f":"IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"\",\"Approved Monthly 2:1 Hours\")","v":""}]
[]
["ADL/IADL Hourly Supports",null,null,{"$f":"IF(ServiceSetting=CNA_GroupHome,\"N/A (SE 50 or 141)\",IF(ServiceElement=SE_FosterCare,\"N/A (SE 58)\",'Raw Scoring'!$L11))","v":0},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",ADLs2to1Rev)","v":"No"},{"$f":"IF(OR(E6=\"No\",E6=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(SUM('2-1 Review and Approval'!L6:L8)>0,SUM('2-1 Review and Approval'!L6:L8),0)))","v":" "}]
["Behavior Hourly Supports",null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L12)","v":0},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",Behav2to1Rev)","v":"No"},{"$f":"IF(OR(E7=\"No\",E7=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(SUM('2-1 Review and Approval'!L11:L12)>0,SUM('2-1 Review and Approval'!L11:L12),0)))","v":" "}]
["Medical & Safety Hourly Supports",null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L13)","v":0},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",Med2to1Rev)","v":"No"},{"$f":"IF(OR(E8=\"No\",E8=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(('2-1 Review and Approval'!L9)>0,('2-1 Review and Approval'!L9),0)))","v":" "}]
["Nighttime Hourly Supports",null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L14)","v":0},{"$f":"IF(NOT(ISNUMBER($D$6)),\"N/A\",Night2to1Rev)","v":"No"},{"$f":"IF(OR(E9=\"No\",E9=\"N/A\"),\" \",IF(AND(ISBLANK('2-1 Review and Approval'!$A$23),ISBLANK('2-1 Review and Approval'!$F$23)),\"Approval Required\",IF(('2-1 Review and Approval'!L10)>0,('2-1 Review and Approval'!L10),0)))","v":" "}]
["Daily Average Attendant Care Hours (Sept - May)",null,null,{"$f":"IF(NOT(ClientDemComplete),\"Incomplete Demographics\",IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L15))","v":0},{"$f":"FifthBdayNotificationMsg","v":" "}]
["Monthly Attendant Care Hours (Sept - May)",null,null,{"$f":"IF(NOT(ClientDemComplete),$D$10,IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L16))","v":0}]
["Daily Average Attendant Care Hours (June - Aug)",null,null,{"$f":"IF(NOT(ClientDemComplete),\"Incomplete Demographics\",IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L17))","v":0}]
["Monthly Attendant Care Hours (June - Aug)",null,null,{"$f":"IF(NOT(ClientDemComplete),$D$12,IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L18))","v":0}]
["Additional Monthly Attendant Care Hours for 2:1 Support ",null,null,null,null,{"$f":"Approved2to1HoursQualified","v":0}]
[]
[" 2:1 hours included in the totals shown on this line may be used ONLY for a second caregiver working during the Attendant care hours shown above, for provision of supports assessed as requiring 2 caregivers.",null,"Total Approved Monthly Attendant Care hours, including 2:1 hours (Sept - May)",{"$f":"IF(NOT(ISNUMBER($D$11)),$D$11,IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$J22))","v":0},"Total Approved Monthly Attendant Care hours, including 2:1 hours (June - Aug)",{"$f":"IF(NOT(ISNUMBER($D$12)),$D$12,IF(NOT(ISNUMBER($D$6)),$D$6,'Raw Scoring'!$L22))","v":0}]
[null,null,null,{"$f":"IF(AND(ISNUMBER($D$11),OR(MinLT14HrRdcnOvrrd,Min14to20HrRdcnOvrrd>0,Min14to20HrRdcnOvrrdWntr>0)),\"(Partial or no reduction due to minimum-hour limits)\",\"\")","v":""}]
["Enhanced/Exceptional Status",null,null,"Behavioral","Medical"]
[null,null,null,{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,EE_BehavIsEnhExc)","v":"N/A"},{"$f":"IF(NOT(ISNUMBER($D$6)),$D$6,EE_MedIsEnhExc)","v":"N/A"}]
[{"$f":"IF(ServiceElement = SE_CIIS, \"(Enhanced and Exceptional status are not applicable to children enrolled in CIIS.)\",\"\")","v":""}]
["My signature verifies I have completed the In Home Support Needs Assessment using all available information\nobtained through observation, interview and the individual's records. The assessment accurately reflects the individual's\nsupport needs according to the interpretations contained in the ANA/CNA Manual."]
["Completed by:",{"$f":"IF(ISBLANK(AssessorName),\"\",AssessorName)","v":""},null,"Signature:","________________________________"]
[]
["Comments: "]
[]
[]
[]
[]
[]
[]
[{"$f":"EffectivePreRedn*100","v":0}]
[{"$f":"EffectivePostRedn*100","v":0}]

{"sheet":"2-1 Review and Approval","index":9,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,1,12,2],[1,0,1,1],[1,5,1,6],[3,0,3,3],[1,2,1,3],[3,6,3,10],[22,5,22,7],[22,8,22,10],[20,5,20,10],[14,5,14,10],[15,5,15,10],[17,5,17,10],[18,5,18,10],[24,0,24,3],[14,0,14,3],[15,0,15,3],[17,0,17,3],[18,0,18,3],[22,0,22,1],[22,2,22,3],[20,0,20,3]]}
[]
["Review and Approval of 2 Person Supports",null,{"$f":"IF(ISBLANK('Client Demographics'!D3),\"\",'Client Demographics'!D3&\" - \"&'Client Demographics'!D4)","v":""},null,null,"DHS Review - 2:1 Exception",null,null,null,"Date of Review/Determination: "]
[]
["1.  Determine the amount of 2 person hours that are necessary to safely provide the support.",null,null,null,null,"ODDS Review Team: "]
[null,"Maximum Monthly \n2:1 Hours*","\nMonthly 2:1 Hours\nNeeded",null,null,null,"\nMonthly 2:1 Hours\nApproved"]
["Mobility",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!D2=\"Yes\", 30, 0))","v":0},0,null,null,"Mobility",null,null,null,null,null,{"$f":"IF(G6<>0,G6,IF(ISBLANK(C6),0,MIN(B6,C6)))","v":0}]
["Transfer/Positioning",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!D3=\"Yes\",30, 0))","v":0},0,null,null,"Transfer/Positioning",null,null,null,null,null,0]
["Bathing",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!D10=\"Yes\", 20, 0))","v":0},0,null,null,"Bathing",null,null,null,null,null,0]
["Complex Medical Interventions",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF(MedSupCmplx=\"Yes\", 90, 0))","v":0},0,null,null,"Complex Medical Interventions",null,null,null,null,null,0]
["Night",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF('Raw Scoring'!K2=\"Yes\", 90, 0))","v":0},0,null,null,"Night",null,null,null,null,null,0]
["Behavior - Home",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF(BehavSupvsnExclFocus=\"Yes\", 90, 0))","v":0},0,null,null,"Behavior - Home",null,null,null,null,null,0]
["Behavior - Community",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),0,IF(BehavSupvsnCmty=\"Yes\", 30, 0))","v":0},0,null,null,"Behavior - Community",null,null," ",null,null,0]
["Locally Approved 2:1 hours",{"$f":"IF(NOT(ISNUMBER('Summary of In-Home Hours'!$D$6)),'Summary of In-Home Hours'!$D$6,Approved2to1Hours)","v":0},null,null,null,"ODDS Approved 2:1 hours",{"$f":"IF(NOT(ISNUMBER(Approved2to1HoursQualified)),Approved2to1HoursQualified,SUM(G6:G12))","v":0},null,null,null,null,{"$f":"SUM(L6:L12)","v":0}]
[]
["2. Confirm that the 2:1 support assessed is necessary.  There is no means of safely performing the support with a single, qualified caregiver.  \n- The 2:1 support is needed in all or almost all cases where the activity is performed and is not a need only in specific situations.  \n- The amount authorized is based on the actual frequency and duration of the activity(ies) that require 2:1 support.  \nInclude brief comment regarding rationale for approval or non-approval, below.   ",null,null,null,null,"2. Does the information provided support the assessment that 2:1 support is necessary in the categories recorded?"]
[]
[]
["3.  Confirm that the individual's file includes documentation that supports the need for the 2:1 support by identifying the type of documentation, below.  If 2:1 is support is not approved, enter \"N/A\".    (Examples:  Physical Therapy evaluation dated 2/5/11, Physician's note dated 3/8/12, Case note 1/12/13 re: Service Coordinator's observation.) ",null,null,null,null,"3.  Support tasks, reported frequency, usual duration of 2:1 need:"]
[]
[null,null,null,null,null,"Additional Information:"]
["4. Authorized Signature.   Review and approval may only be completed by the Brokerage Director or CDDP Manager  or  their designee.   The Personal Agent or Services Coordinator may not authorize 2:1 support for an individual on their caseload.  \nTo complete the electronic file, the authorized signer enters their name and the date into the boxes, below.   A copy of this page retained in the client file."]
["SIGNATURE",null,"DATE",null,null,"ODDS SIGNATURE",null,null,"DATE"]
[]
[]
["*\"Maximum Monthly 2:1 Hours\" are the highest allocations of 2:1 support which may be authorized by a CDDP or Support Services Brokerage.   When support is needed in excess of the amounts shown above, an Exception Request may be submitted to ODDS for review.  \nFax a copy of this completed worksheet to:   503-373-7274, ATTN: In-Home 2:1 Exception Request"]

{"sheet":"Raw Scoring","index":10,"n_rows":67,"n_cols":37,"rows_kept":67,"cut":false,"hidden":true,"merged":[[20,8,20,10],[18,9,18,11],[19,9,19,11],[10,8,10,10],[17,8,17,10],[16,8,16,10],[15,8,15,10],[14,8,14,10],[13,8,13,10],[12,8,12,10],[11,8,11,10]]}
["ADL\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","New\nScoring\nColumn*","Hours","Nighttime\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","New\nScoring\nColumn","Hours","Medical\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","New\nScoring\nColumn","Hours","Behavior\nGroup ID","Selection\nValue","Adjusted\nValue","2:1 Review","New\nScoring\nRow","New\nScoring\nColumn*","Hours",null,"EE_Nursing\nGroup ID","Selection\nValue",null,"EE_Behav\nGroup ID","Selection\nValue"]
["ADL1",0,{"$f":"B2","v":0},"No",{"$f":"MATCH(A2,'New Scoring'!$A:$A,0)+C2","v":3},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(D2=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge<4,0,OFFSET(NS_Values,E2-1,F2-1,1,1))","v":0},"Nighttime1",0,{"$f":"I2","v":0},"No",{"$f":"MATCH(H2,'New Scoring'!$A:$A,0)+J2","v":75},{"$f":"Default_NS_AgeCol+IF(K2=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,L2-1,M2-1,1,1))","v":0},"Medical1",0,{"$f":"P2","v":0},"N/A",{"$f":"MATCH(O2,'New Scoring'!$A:$A,0)+Q2","v":81},{"$f":"Default_NS_AgeCol+IF(R2=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,S2-1,T2-1,1,1))","v":0},"Behavior1",0,{"$f":"IF($W$4>1,0,W2)","v":0},"N/A",{"$f":"MATCH(V2,'New Scoring'!$A:$A,0)+X2","v":183},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(Y2=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge<3.5,0,OFFSET(NS_Values,Z2-1,AA2-1,1,1))","v":0},null,"Ventilator1",0,null,"SupPlanImpl1",0,null,"EE_MedIsEnh:",{"$f":"IF(EE_NursingComplete,IF(EE_NursingEnh,$AK$9,$AK$11),IF(MedShEnh,$AK$12,$AK$11))","v":"N/A"}]
["ADL2",0,0,"No",{"$f":"MATCH(A3,'New Scoring'!$A:$A,0)+C3","v":9},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(D3=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge<4,0,OFFSET(NS_Values,E3-1,F3-1,1,1))","v":0},"Totals",{"$f":"SUM(I2:I2)","v":0},{"$f":"SUM(J2:J2)","v":0},{"$f":"IF(COUNTIF(K1:K2,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,{"$f":"SUM(N2:N2)","v":0},"Medical2",0,{"$f":"P3","v":0},"N/A",{"$f":"MATCH(O3,'New Scoring'!$A:$A,0)+Q3","v":87},3,0,"Behavior2",0,{"$f":"W3","v":0},"N/A",{"$f":"MATCH(V3,'New Scoring'!$A:$A,0)+X3","v":189},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(Y3=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,Z3-1,AA3-1,1,1))","v":0},null,"CPAP2",0,null,"SupPlanRevised2",0,null,"EE_MedIsExc:",{"$f":"IF(EE_NursingComplete,IF(EE_NursingExc,$AK$10,$AK$11),IF(OR(MedShEnh,MedShExc),$AK$12,$AK$11))","v":"N/A"}]
["ADL3",0,0,"N/A",{"$f":"MATCH(A4,'New Scoring'!$A:$A,0)+C4","v":15},{"$f":"Default_NS_AgeCol+IF(D4=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge<15,0,IF(EffectiveAge<4,0,OFFSET(NS_Values,E4-1,F4-1,1,1)))","v":0},null,null,null,null,null,null,null,"Medical3",0,0,"N/A",{"$f":"MATCH(O4,'New Scoring'!$A:$A,0)+Q4","v":93},3,0,"Behavior3",0,0,"N/A",{"$f":"MATCH(V4,'New Scoring'!$A:$A,0)+X4","v":195},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(Y4=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,Z4-1,AA4-1,1,1))","v":0},null,"Oxygen3",0,null,"CmplxTools3",0,null,"EE_MedIsEnhExc:",{"$f":"IF(EE_MedIsExc<>$AK$11,EE_MedIsExc,EE_MedIsEnh)","v":"N/A"}]
["ADL4",0,0,"N/A",{"$f":"MATCH(A5,'New Scoring'!$A:$A,0)+C5","v":21},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(D5=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge<3,0,OFFSET(NS_Values,E5-1,F5-1,1,1))","v":0},null,null,null,null,null,null,null,"Medical4",0,0,"N/A",{"$f":"MATCH(O5,'New Scoring'!$A:$A,0)+Q5","v":99},3,0,"Behavior4",0,0,"No",{"$f":"MATCH(V5,'New Scoring'!$A:$A,0)+X5","v":201},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(Y5=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,Z5-1,AA5-1,1,1))","v":0},null,"Resp4",0,null,"PPI4",0,null,"EE_BehavIsEnh:",{"$f":"IF(EE_BehavComplete,IF(EE_BehavEnh,$AK$9,$AK$11),IF(BehavShEnh,$AK$12,$AK$11))","v":"N/A"}]
["ADL5",0,0,"N/A",{"$f":"MATCH(A6,'New Scoring'!$A:$A,0)+C6","v":27},3,{"$f":"IF(EffectiveAge<4,0,OFFSET(NS_Values,E6-1,F6-1,1,1))","v":0},null,null,null,null,null,null,null,"Medical5",0,0,"N/A",{"$f":"MATCH(O6,'New Scoring'!$A:$A,0)+Q6","v":105},3,0,"Behavior5",0,0,"No",{"$f":"MATCH(V6,'New Scoring'!$A:$A,0)+X6","v":209},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(Y6=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,Z6-1,AA6-1,1,1))","v":0},null,"Trach5",0,null,"TwentyHrs5",0,null,"EE_BehavIsExc:",{"$f":"IF(EE_BehavComplete,IF(EE_BehavExc,$AK$10,$AK$11),IF(OR(BehavShEnh,BehavShExc),$AK$12,$AK$11))","v":"N/A"}]
["ADL6",0,0,"N/A",{"$f":"MATCH(A7,'New Scoring'!$A:$A,0)+C7","v":33},3,{"$f":"IF(EffectiveAge<4,0,OFFSET(NS_Values,E7-1,F7-1,1,1))","v":0},null,null,null,null,null,null,null,"Medical6",0,0,"N/A",{"$f":"MATCH(O7,'New Scoring'!$A:$A,0)+Q7","v":111},3,0,"Totals",{"$f":"SUM(V2:V6)","v":0},{"$f":"SUM(W2:W6)","v":0},{"$f":"IF(COUNTIF(Y1:Y6,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,{"$f":"SUM(AB2:AB6)","v":0},null,"Suction6",0,null,"None6",0,null,"EE_BehavIsEnhExc:",{"$f":"IF(EE_BehavIsExc<>$AK$11,EE_BehavIsExc,EE_BehavIsEnh)","v":"N/A"}]
["ADL7",0,0,"N/A",{"$f":"MATCH(A8,'New Scoring'!$A:$A,0)+C8","v":39},3,{"$f":"IF(EffectiveAge<4,0,OFFSET(NS_Values,E8-1,F8-1,1,1))","v":0},null,null,null,null,null,null,null,"Medical7",0,0,"N/A",{"$f":"MATCH(O8,'New Scoring'!$A:$A,0)+Q8","v":117},3,0,"Enhanced",{"$f":"AND(W3 >= 1, W4 >= 2, W6 >= 3)","v":false},null,null,null,"*Values can differ from default for some ages",null,null,"Stoma7",0,null,"Total",{"$f":"SUM(AH2:AH5)","v":0}]
["ADL8",0,0,"N/A",{"$f":"MATCH(A9,'New Scoring'!$A:$A,0)+C9","v":45},3,{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,E9-1,F9-1,1,1))","v":0},null,null,null,null,null,null,null,"Medical8",0,0,"N/A",{"$f":"MATCH(O9,'New Scoring'!$A:$A,0)+Q9","v":123},3,0,"Exceptional",{"$f":"AND(W3 >= 2, W4 >= 3, W6 >= 4)","v":false},null,null,null,null,null,null,"FeedingTube8",0,null,"Enhanced",{"$f":"AH2>0","v":false},null,"Text:","Enhanced"]
["ADL9",0,0,"No",{"$f":"MATCH(A10,'New Scoring'!$A:$A,0)+C10","v":51},3,{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,E10-1,F10-1,1,1))","v":0},"5 can be valid",null,null,null,null,null,null,"Medical9",0,0,"No",{"$f":"MATCH(O10,'New Scoring'!$A:$A,0)+Q10","v":129},3,0,"5 can be valid",null,null,null,null,null,null,null,"Diabetes9",0,null,"Exceptional",{"$f":"AND(EE_BehavEnh,AH6,SUM(AH3:AH5)>0)","v":false},null,null,"Exceptional"]
["ADL10",0,0,"N/A",{"$f":"MATCH(A11,'New Scoring'!$A:$A,0)+C11","v":57},{"$f":"Default_NS_AgeCol+IF(D11=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge<15,0,IF(EffectiveAge<4,0,OFFSET(NS_Values,E11-1,F11-1,1,1)))","v":0},null,"ADL/IADL Hourly Supports",null,null,{"$f":"IF(ConstlMinTotal>ScoreTotalHours,$D$64,$B$26)","v":0},null,null,"Medical10",null,null,"N/A",{"$f":"MATCH(O11,'New Scoring'!$A:$A,0)+Q11","v":135},3,null,"(Old, unused \"Nursing\" section removed!)",null,null,null,null,null,null,null,"Injection10",0,null,"Complete",{"$f":"OR(AH6,AH7, AH8>0)","v":false},null,null,"N/A"]
["ADL11",0,0,"N/A",{"$f":"MATCH(A12,'New Scoring'!$A:$A,0)+C12","v":63},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(D12=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,E12-1,F12-1,1,1))","v":0},null,"Behavior Hourly Supports",null,null,{"$f":"IF(ConstlMinTotal>ScoreTotalHours,$D$66,$E$26)","v":0},null,null,"Medical11",0,0,"N/A",{"$f":"MATCH(O12,'New Scoring'!$A:$A,0)+Q12","v":141},3,{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,S12-1,T12-1,1,1))","v":0},"Equip.: No score",null,null,null,null,null,null,null,"Dialysis11",0,null,null,null,null,null,"Please fill out \"Enhanced or Exception\" sheet"]
["ADL12",0,0,"N/A",{"$f":"MATCH(A13,'New Scoring'!$A:$A,0)+C13","v":69},{"$f":"IF(EffectiveAge<5,COLUMN(NS_Age5),IF(EffectiveAge<12,COLUMN(NS_Age6to9),Default_NS_AgeCol))+IF(D13=\"Yes\",Unreduced_NS_Offset,0)","v":3},{"$f":"IF(EffectiveAge=0,0,OFFSET(NS_Values,E13-1,F13-1,1,1))","v":0},null,"Medical & Safety Hourly Supports",null,null,{"$f":"IF(ConstlMinTotal>ScoreTotalHours,$D$65,$D$26)","v":0},null,null,"Medical12",0,0,"N/A",{"$f":"MATCH(O13,'New Scoring'!$A:$A,0)+Q13","v":147},3,0,null,null,null,null,null,null,null,null,"Shunt12",0]
["Totals",{"$f":"SUM(B2:B13)","v":0},{"$f":"SUM(C2:C13)","v":0},{"$f":"IF(COUNTIF(D1:D13,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,{"$f":"SUM(G2:G13)","v":0},null,"Nighttime Hourly Supports",null,null,{"$f":"IF(ConstlMinTotal>ScoreTotalHours,ScoreNighttimeHours*ConstlMinTotal/17,$C$26)","v":0},null,null,"Medical13",0,0,"N/A",{"$f":"MATCH(O14,'New Scoring'!$A:$A,0)+Q14","v":153},3,0,null,null,null,null,null,null,null,null,"VitalSigns13",0]
[null,null,null,null,null,"*Values can differ, by row, for some ages",null,null,"Daily Average Attendant Care Hours (Sept - May)",null,null,{"$f":"IF(PersCareEquiv>SchlAgeVal,PersCareEquiv,IF(ConstlMinTotal>SummerHrs,SUM($L$11:$L$14),IF(IsSchlAge,SUM($L$11:$L$14),SummerHrs)))","v":0},"(C.101: Constellation bug fixed)",null,"Medical14",0,0,"N/A",{"$f":"MATCH(O15,'New Scoring'!$A:$A,0)+Q15","v":159},3,0,null,null,null,null,null,null,null,null,"Seisure14",0]
[null,null,null,null,null,null,null,null,"Monthly Attendant Care Hours (Sept - May)",null,null,{"$f":"ROUNDUP($L$15*DaysPerMo,0)","v":0},null,null,"Medical15",0,0,"N/A",{"$f":"MATCH(O16,'New Scoring'!$A:$A,0)+Q16","v":165},3,0,null,null,null,null,null,null,null,null,"MedPump15",0]
[null,null,null,null,null,null,null,null,"Daily Average Attendant Care Hours (June - Aug)",null,null,{"$f":"IF(PersCareEquiv>SummerHrs,PersCareEquiv,IF(ConstlMinTotal>SummerHrs,SUM($L$11:$L$14),SummerHrs))","v":0},"(C.101: Constellation bug fixed)",null,"Medical16",0,0,"N/A",{"$f":"MATCH(O17,'New Scoring'!$A:$A,0)+Q17","v":171},3,0,null,null,null,null,null,null,null,null,"WoundCare16",0]
[null,null,null,null,null,null,null,null,"Monthly Attendant Care Hours (June - Aug)",null,null,{"$f":"ROUNDUP($L$17*DaysPerMo,0)","v":0},null,null,"Medical17",0,0,"N/A",{"$f":"MATCH(O18,'New Scoring'!$A:$A,0)+Q18","v":177},3,0,"Equip.: Does score",null,null,null,null,null,null,null,"SumpCare17",0]
[null,"ADL","Nighttime","Medical","Behavior","Total","DayTime Total","Set by VBA",false,"< 14 hr Min. Score Reduction Override (Winter & Summer)",null,null,null,null,"Totals",{"$f":"SUM(O2:O16)","v":0},{"$f":"SUM(P2:P18)","v":0},{"$f":"IF(COUNTIF(R1:R18,\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,{"$f":"SUM(U2:U18)","v":0},null,null,null,null,null,null,null,null,"Ostomy18",0]
["Hours",{"$f":"G14","v":0},{"$f":"N3","v":0},{"$f":"U19","v":0},{"$f":"AB7","v":0},{"$f":"SUM(B20:E20)","v":0},{"$f":"B20+D20+E20","v":0},"code1,2",0,"14 to 20 hr Min. Score Reduction Override (Winter)",null,null,null,null,"Enhanced",{"$f":"OR(P10 >= 1, AND(P9 >= 2, OR(P7 >= 2, P8 >= 3, P18 >= 2, B5 >= 4)))","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,"ImpactionCare19",0]
["Hours Adjusted",{"$f":"IF(EffectiveAge>4,IF(B20>5,5,B20),IF(B20>3,3, B20))","v":0},{"$f":"IF(C20>7,7,C20)","v":0},{"$f":"IF(EffectiveAge<12,IF(D20>8,8,D20),IF(D20>10,10,D20))","v":0},{"$f":"IF(EffectiveAge<12,IF(E20>8,8,E20),IF(E20>10,10,E20))","v":0},0,{"$f":"B21+D21+E21","v":0},null,"14 to 20 hr Min. Score Reduction Override (Summer)",null,null,0,"Set by VBA",null,"Exceptional",{"$f":"AND(MedShEnh, P11 >= 2)","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,"Cath20",0]
["Hours Adjusted 2",{"$f":"IF(D21>3,(17-(D21-3))*$B21/17,B21)","v":0},{"$f":"IF(($C21/7)>(G21/17), (7*(G21/17)), $C21)","v":0},{"$f":"D21","v":0},{"$f":"IF($G$21>17,(E21/$G$21)*17,E21)","v":0},0,{"$f":"B22+D22+E22","v":0},null,"Winter + 2:1 Hrs.",{"$f":"IF(Min14to20HrRdcnOvrrdWntr>0,Min14to20HrRdcnOvrrdWntr,ROUNDUP($L$16+Approved2to1Hours,0))","v":0},"Summer + 2:1 Hrs.",{"$f":"IF(Min14to20HrRdcnOvrrd>0,Min14to20HrRdcnOvrrd,ROUNDUP($L$18+Approved2to1Hours,0))","v":0},"code2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Positioning21",0]
["Summer Hrs.",{"$f":"IF($G$22>17,(B22/$G$22)*17,B22)","v":0},{"$f":"C22","v":0},{"$f":"IF($G$22>17,(D22/$G$22)*17,D22)","v":0},{"$f":"IF($G$22>17,(E22/$G$22)*17,E22)","v":0},0,{"$f":"B23+D23+E23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TwentyHrs22",0]
["School Year Hrs.",{"$f":"B23*$I$28","v":0},{"$f":"C23","v":0},{"$f":"D23*$I$28","v":0},{"$f":"E23*$I$28","v":0},0,null,null,null,null,null,null,"1For reduced scores < 14 hrs/mo (equiv. to < 20 hrs in version-C), the final, displayed score should be same as version-C score (i.e.  unreduced).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None23",0]
["Summer Hrs. (Reduced)",{"$f":"B23-(B23*$E$32)","v":0},0,0,0,0,{"$f":"B25+D25+E25","v":0},null,null,null,null,null,"2For reduced scores between 14-20 hrs/mo (equiv. to 20-28.57 hrs in version-C),  the final, displayed score should be a minimum of 20 hrs/mo.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AE2:AE22)","v":0}]
["School Year Hrs. (Reduced)",0,0,0,0,0,null,null,null,null,null,null,"(see the CheckMinScoringValues routine)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enhanced",{"$f":"AE25>=2","v":false}]
["Pers Care Min Adj",null,null,null,null,null,"(Obsolete SNAP)",null,"School Adj",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exceptional",{"$f":"AND(AE25>=4,AE23)","v":false}]
["Constellation Adj",null,null,null,null,null,"(Obsolete SNAP)",null,{"$f":"1-((6/17)*0.588)","v":0.79247058823529415}," = 1-((6/17)*.588))",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete",{"$f":"OR(AE23,AE24, AE25>0)","v":false}]
["Days",null,null,null,null,null,"(Obsolete SNAP)",null,null,"6/17 = six school hrs. per 17 waking hrs."]
["Total Adult",null,null,null,null,null,"(Obsolete SNAP)",null,null,".588 = 58.8% school time per month = 17.88/30.41"]
["Total Kid",null,null,null,null,null,"(Obsolete SNAP)",null,null,"17.88 = avg. school days/month = 161/9"]
[null,null,"Post-Reduction:",0,{"$f":"IF(OR(ServiceElement=SE51SelectionStr,MinLT14HrRdcnOvrrd),0,$D$32)","v":0},null,null,null,null,"161 = avg. school days per year (ct halfdays as 0.5)"]
["Effective Assmt Date",null,null,null,null,null,null,null,null,"30.41 = average days per month"]
[{"$f":"IF(AssessmentDate=0,0,DATE(YEAR(AssessmentDate),MONTH((AssessmentDate)),DAY((AssessmentDate))+AssmtGracePeriod))","v":"00:00:00"}]
[]
["Effective Age","New Scoring","Unreduced","Unreduced",null,null,"School-Age Check:",null,{"$f":"OR(EffectiveAge>=5,AND(EffectiveAge=4,FifthBday<NextSept1Date))","v":true},"True if age 5 or older, or if 4, then if b-day is prior to Sept. 1 of the (effective) assessment-date year, otherwise False"]
["(Year.Fraction)","Age Column","Age Column","Col. Offset",null,null,null,null,{"$f":"IF(IsSchlAge,WinterHrs,SummerHrs)","v":0},"Either Winter or Summer hours, depending on school-age cutoff status"]
[{"$f":"IF(ClientDOB=\"\",\n       \"\",\n       IF(DATEDIF(ClientDOB,EffectiveAssmtDate,\"Y\")=0,\n            ROUND(DATEDIF(ClientDOB,EffectiveAssmtDate,\"YM\")/12, 2),\n            IF(DATEDIF(ClientDOB,EffectiveAssmtDate,\"Y\")=1,\n                 ROUND(DATEDIF(ClientDOB,EffectiveAssmtDate,\"M\")/12, 2),\n                 DATEDIF(ClientDOB,EffectiveAssmtDate,\"Y\"))))","v":""},{"$f":"IF(OR(NOT(ISNUMBER(EffectiveAge)),EffectiveAge<=2),\n COLUMN(NS_Age0to2),\n IF(EffectiveAge=3,\n  COLUMN(NS_Age3),\n  IF(EffectiveAge=4,\n   COLUMN(NS_Age4),\n   IF(EffectiveAge=5,\n    COLUMN(NS_Age5),\n    IF(EffectiveAge<=9,\n     COLUMN(NS_Age6to9),\n     IF(EffectiveAge<=11,\n      COLUMN(NS_Age10to11),\n      IF(EffectiveAge<=14,\n       COLUMN(NS_Age12to14),\n       COLUMN(NS_Age15to17))))))))","v":3},{"$f":"IF(OR(NOT(ISNUMBER(EffectiveAge)),EffectiveAge<=2),\n COLUMN(UR_Age0to2),\n IF(EffectiveAge=3,\n  COLUMN(UR_Age3),\n  IF(EffectiveAge=4,\n   COLUMN(UR_Age4),\n   IF(EffectiveAge=5,\n    COLUMN(UR_Age5),\n    IF(EffectiveAge<=9,\n     COLUMN(UR_Age6to9),\n     IF(EffectiveAge<=11,\n      COLUMN(UR_Age10to11),\n      IF(EffectiveAge<=14,\n       COLUMN(UR_Age12to14),\n       COLUMN(UR_Age15to17))))))))","v":15},{"$f":"Unreduced_NS_AgeCol-Default_NS_AgeCol","v":12},null,null,"5th bday","Sept of assmt yr","Next assmt by"]
[null,null,null,null,null,null,{"$f":"DATE(YEAR(ClientDOB)+5,MONTH(ClientDOB),DAY(ClientDOB))","v":"1904-12-31"},{"$f":"DATE(YEAR(EffectiveAssmtDate),9,1)","v":"1900-09-01"},{"$f":"DATE(YEAR(AssessmentDate)+1,MONTH(AssessmentDate),DAY(AssessmentDate))","v":"1900-12-31"}]
[" Avg. Days/Month",null,null,null,null,null,{"$f":"IF(AND(NextSept1Date > EffectiveAssmtDate, NextSept1Date < NextAsmtDate), IF(OR(ClientAge=4,ClientAge=5), \"School year hours must be implemeted in the month of September following the child's 5th birthday.  Summer hours may be used in all months until the September following the child's 5th birthday.\",\" \"), \" \")","v":" "}]
[30.41,null,null,null,null,null,"^ 5th birthday notification message"]
[]
[null,null,"Personal Care Equivalent"]
[null,null,{"$f":"IF((G2+G3+G5+G6+G7+G8>0),1,0)","v":0},{"$f":"(20/DaysPerMo)*C44","v":0},"Hrs. per day at 20 Hrs. per month"]
[]
[null,null,"Constellation of minor supports"]
[null,null,"ADL1",{"$f":"IF(B2>0,1,0)","v":0}]
[null,null,"ADL2",{"$f":"IF(B3>0,1,0)","v":0}]
[null,null,"ADL4",{"$f":"IF(B5>1,1,0)","v":0}]
[null,null,"ADL5",{"$f":"IF(B6>2,1,0)","v":0}]
[null,null,"ADL6",{"$f":"IF(B7>2,1,0)","v":0}]
[null,null,"ADL7",{"$f":"IF(B8>2,1,0)","v":0}]
[null,null,"ADL8",{"$f":"IF(B9>2,1,0)","v":0}]
[null,null,"ADL9",{"$f":"IF(B10>2,1,0)","v":0},{"$f":"SUM(D47:D54)","v":0}]
[null,null,"Med1",{"$f":"IF(P2>0,1,0)","v":0}]
[null,null,"Med3",{"$f":"IF(P4>0,1,0)","v":0}]
[null,null,"Med6",{"$f":"IF(P7>2,1,0)","v":0}]
[null,null,"Med7",{"$f":"IF(P8>0,1,0)","v":0},{"$f":"SUM(D55:D58)","v":0}]
[null,null,"Beh1",{"$f":"IF(W2>2,1,0)","v":0}]
[null,null,"Beh3",{"$f":"IF(W4>2,2,IF(W4>1,1,0))","v":0}]
[null,null,"Beh5",{"$f":"IF(W6>4,2,IF(W6>2,1,0))","v":0},{"$f":"SUM(D59:D61)","v":0}]
[null,null,"total",{"$f":"SUM(D47:D61)","v":0}]
[null,null,"MIN hours",{"$f":"IF(D62>10.9,20/DaysPerMo,IF(D62>6.9,15/DaysPerMo,IF(D62>2.9,10/DaysPerMo,0)))","v":0}]
[null,null,"minADLhours",{"$f":"(E54/D62)*D63","v":{"$error":"#DIV/0!"}},{"$f":"20*I28","v":15.849411764705883}]
[null,null,"minMedhours",{"$f":"(E58/D62)*D63","v":{"$error":"#DIV/0!"}},{"$f":"14*I28","v":11.094588235294118}]
[null,null,"min Beh Hours",{"$f":"(E61/D62)*D63","v":{"$error":"#DIV/0!"}}]
[null,null,"ck total",{"$f":"SUM(D64:D66)","v":{"$error":"#DIV/0!"}}]

{"sheet":"New Scoring","index":11,"n_rows":214,"n_cols":32,"rows_kept":214,"cut":false,"hidden":true,"merged":[[0,24,0,26],[0,2,0,10],[0,14,0,22],[2,12,3,12]]}
["Pre-Reduction:",0,"CNA - BREAKPOINTS WITH OVERRIDE",null,null,null,null,null,null,null,null,{"$f":"IF(OR(ServiceElement=SE51SelectionStr,MinLT14HrRdcnOvrrd),0,$B$1)","v":0},"<< SE51 doesn't apply to",null,"CNA - NEW BREAKPOINTS (Same scores)",null,null,null,null,null,null,null,null,null,"CNA - OLD BREAKPOINTS"]
["Category","Selection\nValue","0-2",3,4,5,"6-9","10-11","12-14","15-17","18+","Topic","CNA but is included for consistency.",null,"0-2",3,4,5,"6-9","10-11","12-14","15-17","18+",null,"Hours for\nAges 0 to 5","Hours for\nAges 6 to 9","Hours for\nAges > 9",null,"Last updated",null,"Score\nRange Names","Unreduced\nRange Names"]
["ADL1",0,{"$f":"O3-(O3*$L$1)","v":0},{"$f":"P3-(P3*$L$1)","v":0},{"$f":"Q3-(Q3*$L$1)","v":0},{"$f":"R3-(R3*$L$1)","v":0},{"$f":"S3-(S3*$L$1)","v":0},{"$f":"T3-(T3*$L$1)","v":0},{"$f":"U3-(U3*$L$1)","v":0},{"$f":"V3-(V3*$L$1)","v":0},{"$f":"W3-(W3*$L$1)","v":0},"Ambulation/Mobility","NOTE: Blue font items are formulas!",null,0,0,0,0,0,0,0,0,0,null,0,0,0,null,null,null,"NS_Age0to2","UR_Age0to2"]
["ADL1",1,0.1,0.1,0.1,0.1,0.5,0.5,0.5,0.5,0,null,null,null,0.1,0.1,0.1,0.1,0.5,0.5,0.5,0.5,0,null,0.1,0.5,0.5,null,null,null,"NS_Age3","UR_Age3"]
["ADL1",2,0.1,0.1,0.1,0.1,0.5,0.5,0.5,0.5,0,null,"Not an avaiable score",null,0.1,0.1,0.1,0.1,0.5,0.5,0.5,0.5,0,null,0.1,0.5,0.5,null,null,null,"NS_Age4","UR_Age4"]
["ADL1",3,0.1,0.1,0.1,0.1,0.5,0.5,0.5,0.5,0,null,"Not an avaiable score",null,0.1,0.1,0.1,0.1,0.5,0.5,0.5,0.5,0,null,0.1,0.5,0.5,null,null,null,"NS_Age5","UR_Age5"]
["ADL1",4,0.25,0.25,0.25,0.25,1.25,1.5,1.5,1.5,0,null,null,null,0.25,0.25,0.25,0.25,1.25,1.5,1.5,1.5,0,null,0.25,1.25,1.5,null,null,null,"NS_Age6to9","UR_Age6to9"]
["ADL1",5,0.5,0.5,0.5,0.5,1.25,1.5,1.5,1.5,0,null,"Not an avaiable score",null,0.5,0.5,0.5,0.5,1.25,1.5,1.5,1.5,0,null,0.5,1.25,1.5,null,null,null,"NS_Age10to11","UR_Age10to11"]
["ADL2",0,0,0,0,0,0,0,0,0,0,"Transferring/Positioning",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0,null,null,null,"NS_Age12to14","UR_Age12to14"]
["ADL2",1,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,0.05,0.25,0.5,null,null,null,"NS_Age15to17","UR_Age15to17"]
["ADL2",2,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,0.05,0.25,0.5,null,null,null,"NS_AgeGE18","UR_AgeGE18"]
["ADL2",3,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,0.05,0.25,0.5]
["ADL2",4,0.25,0.25,0.25,0.25,1,1,1,1,0,null,null,null,0.25,0.25,0.25,0.25,1,1,1,1,0,null,0.25,1,1]
["ADL2",5,0.25,0.25,0.25,0.25,1,1,1,1,0,null,null,null,0.25,0.25,0.25,0.25,1,1,1,1,0,null,0.25,1,1]
["ADL3",0,0,0,0,0,0,0,0,0,0,"Food Preparation",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL3",1,0,0,0,0,0,6.25E-2,6.25E-2,6.25E-2,0,null,null,null,0,0,0,0,0,6.25E-2,6.25E-2,6.25E-2,0,null,0,0,6.25E-2]
["ADL3",2,0,0,0,0,0,6.25E-2,6.25E-2,6.25E-2,0,null,null,null,0,0,0,0,0,6.25E-2,6.25E-2,6.25E-2,0,null,0,0,{"$f":"0.125/2","v":6.25E-2}]
["ADL3",3,0,0,0,0,0,6.25E-2,6.25E-2,6.25E-2,0,null,null,null,0,0,0,0,0,6.25E-2,6.25E-2,6.25E-2,0,null,0,0,{"$f":"0.125/2","v":6.25E-2}]
["ADL3",4,0,0,0,0,0,0.125,0.125,0.125,0,null,null,null,0,0,0,0,0,0.125,0.125,0.125,0,null,0,0,0.125]
["ADL3",5,0,0,0,0,0,0.125,0.125,0.125,0,null,null,null,0,0,0,0,0,0.125,0.125,0.125,0,null,0,0,0.125]
["ADL4",0,0,0,0,0,0,0,0,0,0,"Eating/Drinking",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL4",1,0,0,0,0,0,0.25,0.25,0.25,0,null,null,null,0,0,0,0,0,0.25,0.25,0.25,0,null,0,0,0.25]
["ADL4",2,0.05,0.05,0.05,0.05,0.25,0.75,0.75,0.75,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.75,0.75,0.75,0,null,0.05,0.25,0.75]
["ADL4",3,0.5,0.5,0.5,0.5,1,1.25,1.25,1.25,0,null,null,null,0.5,0.5,0.5,0.5,1,1.25,1.25,1.25,0,null,0.5,1,1.25]
["ADL4",4,0.75,0.75,0.75,0.75,1.25,1.5,1.5,1.5,0,null,null,null,0.75,0.75,0.75,0.75,1.25,1.5,1.5,1.5,0,null,0.75,1.25,1.5]
["ADL4",5,0.75,0.75,0.75,0.75,1.25,1.5,1.5,1.5,0,null,null,null,0.75,0.75,0.75,0.75,1.25,1.5,1.5,1.5,0,null,0.75,1.25,1.5]
["ADL5",0,0,0,0,0,0,0,0,0,0,"Bladder Control",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL5",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL5",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL5",3,0.25,0.25,0.25,0.25,0.5,0.5,0.5,0.5,0,null,null,null,0.25,0.25,0.25,0.25,0.5,0.5,0.5,0.5,0,null,0.25,0.5,0.5]
["ADL5",4,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,null,null,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,0.5,0.75,0.75]
["ADL5",5,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,null,null,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,0.5,0.75,0.75]
["ADL6",0,0,0,0,0,0,0,0,0,0,"Bowel Control",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL6",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL6",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL6",3,0.25,0.25,0.25,0.25,0.5,0.5,0.5,0.5,0,null,null,null,0.25,0.25,0.25,0.25,0.5,0.5,0.5,0.5,0,null,0.25,0.5,0.5]
["ADL6",4,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,null,null,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,0.5,0.75,0.75]
["ADL6",5,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,null,null,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,0.5,0.75,0.75]
["ADL7",0,0,0,0,0,0,0,0,0,0,"Toileting",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL7",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL7",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL7",3,0.125,0.125,0.125,0.125,0.125,0.5,0.5,0.5,0,null,null,null,0.125,0.125,0.125,0.125,0.125,0.5,0.5,0.5,0,null,0.125,0.125,0.5]
["ADL7",4,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,null,null,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,0.5,0.75,0.75]
["ADL7",5,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,null,null,0.5,0.5,0.5,0.5,0.75,0.75,0.75,0.75,0,null,0.5,0.75,0.75]
["ADL8",0,0,0,0,0,0,0,0,0,0,"Hygiene",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL8",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL8",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL8",3,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,0.05,0.1,0.1,0.1,0,null,null,null,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,0.05,0.1,0.1,0.1,0,null,1.2500000000000001E-2,0.05,0.1]
["ADL8",4,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,0.1,0.125,0.125,0.125,0,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,0.1,0.125,0.125,0.125,0,null,2.5000000000000001E-2,0.1,0.125]
["ADL8",5,0.05,0.05,0.05,0.05,0.125,0.15,0.15,0.15,0,null,null,null,0.05,0.05,0.05,0.05,0.125,0.15,0.15,0.15,0,null,0.05,0.125,0.15]
["ADL9",0,0,0,0,0,0,0,0,0,0,"Bathing",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL9",1,0,0,0,0,0,0.25,0.25,0.25,0,null,null,null,0,0,0,0,0,0.25,0.25,0.25,0,null,0,0,0.25]
["ADL9",2,0.1,0.1,0.1,0.1,0.25,0.25,0.25,0.25,0,null,null,null,0.1,0.1,0.1,0.1,0.25,0.25,0.25,0.25,0,null,0.1,0.25,0.25]
["ADL9",3,0.1,0.1,0.1,0.1,0.25,0.25,0.25,0.25,0,null,null,null,0.1,0.1,0.1,0.1,0.25,0.25,0.25,0.25,0,null,0.1,0.25,0.25]
["ADL9",4,0.25,0.25,0.25,0.25,0.5,0.75,0.75,0.75,0,null,null,null,0.25,0.25,0.25,0.25,0.5,0.75,0.75,0.75,0,null,0.25,0.5,0.75]
["ADL9",5,0.25,0.25,0.25,0.25,0.5,0.75,0.75,0.75,0,null,null,null,0.25,0.25,0.25,0.25,0.5,0.75,0.75,0.75,0,null,0.25,0.5,0.75]
["ADL10",0,0,0,0,0,0,0,0,0,0,"Laundry/Housekeeping",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL10",1,0,0,0,0,0,3.2883999999999997E-2,3.2883999999999997E-2,3.2883999999999997E-2,0,null,null,null,0,0,0,0,0,3.2883999999999997E-2,3.2883999999999997E-2,3.2883999999999997E-2,0,null,0,0,3.2883999999999997E-2]
["ADL10",2,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,null,null,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,0,0,6.5767999999999993E-2]
["ADL10",3,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,null,null,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,0,0,6.5767999999999993E-2]
["ADL10",4,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,null,null,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,0,0,6.5767999999999993E-2]
["ADL10",5,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,null,null,0,0,0,0,0,6.5767999999999993E-2,6.5767999999999993E-2,6.5767999999999993E-2,0,null,0,0,6.5767999999999993E-2]
["ADL11",0,0,0,0,0,0,0,0,0,0,"Dressing/Hair Care",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL11",1,0,0,0,0,0,0.16700000000000001,0.16700000000000001,0.16700000000000001,0,null,null,null,0,0,0,0,0,0.16700000000000001,0.16700000000000001,0.16700000000000001,0,null,0,0,0.16700000000000001]
["ADL11",2,0,0,0,0,0,0.16700000000000001,0.16700000000000001,0.16700000000000001,0,null,null,null,0,0,0,0,0,0.16700000000000001,0.16700000000000001,0.16700000000000001,0,null,0,0,0.16700000000000001]
["ADL11",3,8.3299999999999999E-2,8.3299999999999999E-2,8.3299999999999999E-2,8.3299999999999999E-2,0.33300000000000002,0.66700000000000004,0.66700000000000004,0.66700000000000004,0,null,null,null,8.3299999999999999E-2,8.3299999999999999E-2,8.3299999999999999E-2,8.3299999999999999E-2,0.33300000000000002,0.66700000000000004,0.66700000000000004,0.66700000000000004,0,null,8.3299999999999999E-2,0.33300000000000002,0.66700000000000004]
["ADL11",4,{"$f":"O67-(O67*$L$1)","v":0.16669999999999999},{"$f":"P67-(P67*$L$1)","v":0.16669999999999999},{"$f":"Q67-(Q67*$L$1)","v":0.16669999999999999},{"$f":"R67-(R67*$L$1)","v":0.16669999999999999},{"$f":"S67-(S67*$L$1)","v":0.33300000000000002},{"$f":"T67-(T67*$L$1)","v":0.66700000000000004},{"$f":"U67-(U67*$L$1)","v":0.66700000000000004},{"$f":"V67-(V67*$L$1)","v":0.66700000000000004},{"$f":"W67-(W67*$L$1)","v":0},null,null,null,0.16669999999999999,0.16669999999999999,0.16669999999999999,0.16669999999999999,0.33300000000000002,0.66700000000000004,0.66700000000000004,0.66700000000000004,0,null,0.16669999999999999,0.33300000000000002,0.66700000000000004]
["ADL11",5,0.16669999999999999,0.16669999999999999,0.16669999999999999,0.16669999999999999,0.33300000000000002,0.66700000000000004,0.66700000000000004,0.66700000000000004,0,null,null,null,0.16669999999999999,0.16669999999999999,0.16669999999999999,0.16669999999999999,0.33300000000000002,0.66700000000000004,0.66700000000000004,0.66700000000000004,0,null,0.16669999999999999,0.33300000000000002,0.66700000000000004]
["ADL12",0,0,0,0,0,0,0,0,0,0,"Shopping/Money Mgmt.",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL12",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL12",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL12",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL12",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["ADL12",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Nighttime1",0,0,0,0,0,0,0,0,0,0,"Nighttime",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Nighttime1",1,0,0,0,0,0,1,1,1,0,null,null,null,0,0,0,0,0,1,1,1,0,null,0,0,1]
["Nighttime1",2,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,1,2,2,2,0,null,null,null,0.66700000000000004,0.66700000000000004,0.66700000000000004,0.66700000000000004,1,2,2,2,0,null,0.66700000000000004,1,2]
["Nighttime1",3,7,7,7,7,7,7,7,7,0,null,null,null,7,7,7,7,7,7,7,7,0,null,7,7,7]
["Nighttime1",4,7,7,7,7,7,7,7,7,0,null,null,null,7,7,7,7,7,7,7,7,0,null,7,7,7]
["Nighttime1",5,7,7,7,7,7,7,7,7,0,null,null,null,7,7,7,7,7,7,7,7,0,null,7,7,7]
["Medical1",0,0,0,0,0,0,0,0,0,0,"Communication, Expressive",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical1",1,0.04,0.04,0.04,0.04,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999,0,null,null,null,0.04,0.04,0.04,0.04,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999,0,null,0.04,0.17499999999999999,0.17499999999999999]
["Medical1",2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,null,null,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,8.7499999999999994E-2,0.25,0.25]
["Medical1",3,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,null,null,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,8.7499999999999994E-2,0.25,0.25]
["Medical1",4,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,null,null,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,8.7499999999999994E-2,0.25,0.25]
["Medical1",5,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,null,null,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,8.7499999999999994E-2,0.25,0.25,0.25,0.25,0,null,8.7499999999999994E-2,0.25,0.25]
["Medical2",0,0,0,0,0,0,0,0,0,0,"Communication, Receptive",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical2",1,3.125E-2,3.125E-2,3.125E-2,3.125E-2,0.125,0.17499999999999999,0.17499999999999999,0.17499999999999999,0,null,null,null,3.125E-2,3.125E-2,3.125E-2,3.125E-2,0.125,0.17499999999999999,0.17499999999999999,0.17499999999999999,0,null,3.125E-2,0.125,0.17499999999999999]
["Medical2",2,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,null,null,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,6.25E-2,0.25,0.25]
["Medical2",3,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,null,null,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,6.25E-2,0.25,0.25]
["Medical2",4,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,null,null,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,6.25E-2,0.25,0.25]
["Medical2",5,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,null,null,6.25E-2,6.25E-2,6.25E-2,6.25E-2,0.25,0.25,0.25,0.25,0,null,6.25E-2,0.25,0.25]
["Medical3",0,0,0,0,0,0,0,0,0,0,"Safety",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical3",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical3",2,0,0,0,0,0,0.25,0.25,0.25,0,null,null,null,0,0,0,0,0,0.25,0.25,0.25,0,null,0,0,0.25]
["Medical3",3,0,0,0,0,0,1,1,1,0,null,null,null,0,0,0,0,0,1,1,1,0,null,0,0,1]
["Medical3",4,0,0,0,0,0,1,1,1,0,null,null,null,0,0,0,0,0,1,1,1,0,null,0,0,1]
["Medical3",5,0,0,0,0,0,1,1,1,0,null,null,null,0,0,0,0,0,1,1,1,0,null,0,0,1]
["Medical4",0,0,0,0,0,0,0,0,0,0,"Fire Evacuation",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical4",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical4",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical4",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical4",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical4",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical5",0,0,0,0,0,0,0,0,0,0,"Medication - Oral",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical5",1,0,0,0,0,0,0.125,0.125,0.125,0,null,null,null,0,0,0,0,0,0.125,0.125,0.125,0,null,0,0,0.125]
["Medical5",2,0,0,0,0,0,0.125,0.125,0.125,0,null,null,null,0,0,0,0,0,0.125,0.125,0.125,0,null,0,0,0.125]
["Medical5",3,0,0,0,0,0.125,0.25,0.25,0.25,0,null,null,null,0,0,0,0,0.125,0.25,0.25,0.25,0,null,0,0.125,0.25]
["Medical5",4,0,0,0,0,0.125,0.25,0.25,0.25,0,null,null,null,0,0,0,0,0.125,0.25,0.25,0.25,0,null,0,0.125,0.25]
["Medical5",5,0,0,0,0,0.125,0.25,0.25,0.25,0,null,null,null,0,0,0,0,0.125,0.25,0.25,0.25,0,null,0,0.125,0.25]
["Medical6",0,0,0,0,0,0,0,0,0,0,"Meds - Inhalants, Topicals, Supp.",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical6",1,0,0,0,0,0.125,0.125,0.125,0.125,0,null,null,null,0,0,0,0,0.125,0.125,0.125,0.125,0,null,0,0.125,0.125]
["Medical6",2,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,0.05,0.25,0.5]
["Medical6",3,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,0.05,0.25,0.5]
["Medical6",4,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,0.05,0.25,0.5]
["Medical6",5,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,null,null,0.05,0.05,0.05,0.05,0.25,0.5,0.5,0.5,0,null,0.05,0.25,0.5]
["Medical7",0,0,0,0,0,0,0,0,0,0,"Meds - Injections",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical7",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical7",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical7",3,0.25,0.25,0.25,0.25,0.25,0.5,0.5,0.5,0,null,null,null,0.25,0.25,0.25,0.25,0.25,0.5,0.5,0.5,0,null,0.25,0.25,0.5]
["Medical7",4,0.5,0.5,0.5,0.5,0.5,1,1,1,0,null,null,null,0.5,0.5,0.5,0.5,0.5,1,1,1,0,null,0.5,0.5,1]
["Medical7",5,0.5,0.5,0.5,0.5,0.5,1,1,1,0,null,null,null,0.5,0.5,0.5,0.5,0.5,1,1,1,0,null,0.5,0.5,1]
["Medical8",0,0,0,0,0,0,0,0,0,0,"Health Supports - General",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical8",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical8",2,0,0,0,0,0,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,null,null,null,0,0,0,0,0,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,null,0,0,5.0000000000000001E-3]
["Medical8",3,0,0,0,0,0,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,null,null,null,0,0,0,0,0,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,null,0,0,5.0000000000000001E-3]
["Medical8",4,0,0,0,0,0,0.02,0.02,0.02,0,null,null,null,0,0,0,0,0,0.02,0.02,0.02,0,null,0,0,0.02]
["Medical8",5,0,0,0,0,0,0.04,0.04,0.04,0,null,null,null,0,0,0,0,0,0.04,0.04,0.04,0,null,0,0,0.04]
["Medical9",0,0,0,0,0,0,0,0,0,0,"Complex Health Supports",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical9",1,0.2,0.2,0.2,0.2,0.35,0.5,0.5,0.5,0,null,null,null,0.2,0.2,0.2,0.2,0.35,0.5,0.5,0.5,0,null,0.2,0.35,0.5]
["Medical9",2,{"$f":"O131-(O131*$L$1)","v":0.4},{"$f":"P131-(P131*$L$1)","v":0.4},{"$f":"Q131-(Q131*$L$1)","v":0.4},{"$f":"R131-(R131*$L$1)","v":0.4},{"$f":"S131-(S131*$L$1)","v":0.45},{"$f":"T131-(T131*$L$1)","v":0.5},{"$f":"U131-(U131*$L$1)","v":0.5},{"$f":"V131-(V131*$L$1)","v":0.5},{"$f":"W131-(W131*$L$1)","v":0},null,null,null,0.4,0.4,0.4,0.4,0.45,0.5,0.5,0.5,0,null,0.4,0.45,0.5]
["Medical9",3,1.125,1.125,1.125,1.125,1.2,1.25,1.25,1.25,0,null,null,null,1.125,1.125,1.125,1.125,1.2,1.25,1.25,1.25,0,null,1.125,1.2,1.25]
["Medical9",4,2.5,2.5,2.5,2.5,2.6749999999999998,2.75,2.75,2.75,0,null,null,null,2.5,2.5,2.5,2.5,2.6749999999999998,2.75,2.75,2.75,0,null,2.5,2.6749999999999998,2.75]
["Medical9",5,4,4,4,4,4,4,4,4,0,null,null,null,4,4,4,4,4,4,4,4,0,null,4,4,4]
["Medical10",0,0,0,0,0,0,0,0,0,0,"(Unused \"Nursing\" section removed!)",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical10",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical10",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical10",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical10",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical10",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical11",0,0,0,0,0,0,0,0,0,0,"Equipment","Equip.: No score…",null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical11",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical11",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical11",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical11",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical11",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical12",0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical12",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical12",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical12",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical12",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical12",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical13",0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical13",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical13",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical13",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical13",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical13",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical14",0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical14",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical14",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical14",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical14",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical14",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical15",0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical15",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical15",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical15",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical15",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical15",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical16",0,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical16",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical16",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical16",3,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical16",4,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical16",5,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical17",0,0,0,0,0,0,0,0,0,0,null,"Equip.: Does score…",null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Medical17",1,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0,null,null,null,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0,null,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2]
["Medical17",2,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0,null,null,null,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0,null,0.09,0.09,0.09]
["Medical17",3,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0," ",null,null,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0,null,0.4,0.4,0.4]
["Medical17",4,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0,null,null,null,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0,null,0.75,0.75,0.75]
["Medical17",5,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0,null,null,null,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0,null,0.75,0.75,0.75]
["Behavior1",0,0,0,0,0,0,0,0,0,0,"Supervison - No Formal Plan",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Behavior1",1,0,0,0,0,0,0.25,0.25,0.25,0,null,null,null,0,0,0,0,0,0.25,0.25,0.25,0,null,0,0,0.25]
["Behavior1",2,0,0,0,0,0.05,1,1,1,0,null,null,null,0,0,0,0,0.05,1,1,1,0,null,0,0.05,1]
["Behavior1",3,0.125,0.125,0.125,0.125,0.125,1.25,1.25,1.25,0,null,null,null,0.125,0.125,0.125,0.125,0.125,1.25,1.25,1.25,0,null,0.125,0.125,1.25]
["Behavior1",4,0.125,0.125,0.125,0.125,0.125,1.25,1.25,1.25,0,null,null,null,0.125,0.125,0.125,0.125,0.125,1.25,1.25,1.25,0,null,0.125,0.125,1.25]
["Behavior1",5,0.125,0.125,0.125,0.125,0.25,1.25,1.25,1.25,0,null,null,null,0.125,0.125,0.125,0.125,0.25,1.25,1.25,1.25,0,null,0.125,0.25,1.25]
["Behavior2",0,0,0,0,0,0,0,0,0,0,"Support plans, Home & Comm.",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Behavior2",1,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,0,null,null,null,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2,0,null,6.5780000000000005E-2,6.5780000000000005E-2,6.5780000000000005E-2]
["Behavior2",2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,null,null,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,{"$f":"Y190*1.5","v":9.8670000000000008E-2},{"$f":"Z190*1.5","v":9.8670000000000008E-2},{"$f":"AA190*1.5","v":9.8670000000000008E-2}]
["Behavior2",3,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,null,null,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2]
["Behavior2",4,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,null,null,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2]
["Behavior2",5,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,null,null,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2,0,null,9.8670000000000008E-2,9.8670000000000008E-2,9.8670000000000008E-2]
["Behavior3",0,{"$f":"O195-(O195*$L$1)","v":0},{"$f":"P195-(P195*$L$1)","v":0},{"$f":"Q195-(Q195*$L$1)","v":0},{"$f":"R195-(R195*$L$1)","v":0},{"$f":"S195-(S195*$L$1)","v":0},{"$f":"T195-(T195*$L$1)","v":0},{"$f":"U195-(U195*$L$1)","v":0},{"$f":"V195-(V195*$L$1)","v":0},{"$f":"W195-(W195*$L$1)","v":0},"Supervison, Home",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Behavior3",1,0,0,0,0,0,0.2,0.2,0.2,0,null,null,null,0,0,0,0,0,0.2,0.2,0.2,0,null,0,0,0.2]
["Behavior3",2,0,0,0,0,0.75,0.8,0.8,0.8,0,null,null,null,0,0,0,0,0.75,0.8,0.8,0.8,0,null,0,0.75,0.8]
["Behavior3",3,0.125,0.125,0.125,0.125,1,1,1,1,0,null,null,null,0.125,0.125,0.125,0.125,1,1,1,1,0,null,0.125,1,1]
["Behavior3",4,0.125,0.125,0.125,0.125,1,1,1,1,0,null,null,null,0.125,0.125,0.125,0.125,1,1,1,1,0,null,0.125,1,1]
["Behavior3",5,0.125,0.125,0.125,0.125,1,1,1,1,0,null,null,null,0.125,0.125,0.125,0.125,1,1,1,1,0,null,0.125,1,1]
["Behavior4",0,0,0,0,0,0,0,0,0,0,"Supervision, Exclusive Focus",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Behavior4",1,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0,null,null,null,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0,null,0.9,0.9,0.9]
["Behavior4",2,1.8,1.8,1.8,1.8,1.8,1.8,1.8,1.8,0,null,null,null,1.8,1.8,1.8,1.8,1.8,1.8,1.8,1.8,0,null,1.8,1.8,1.8]
["Behavior4",3,2.5,2.5,2.5,2.5,2.5,2.75,2.75,2.75,0,null,null,null,2.5,2.5,2.5,2.5,2.5,2.75,2.75,2.75,0,null,2.5,2.5,2.75]
["Behavior4",4,3.25,3.25,3.25,3.25,3.375,3.5,3.5,3.5,0,null,null,null,3.25,3.25,3.25,3.25,3.375,3.5,3.5,3.5,0,null,3.25,3.375,3.5]
["Behavior4",5,3.75,3.75,3.75,3.75,3.875,4,4,4,0,null,null,null,3.75,3.75,3.75,3.75,3.875,4,4,4,0,null,3.75,3.875,4]
["Behavior4",6,4,4,4,4,4.125,4.25,4.25,4.25,0,null,null,null,4,4,4,4,4.125,4.25,4.25,4.25,0,null,4,4.125,4.25]
["Behavior4",7,6,6,6,6,6,6,6,6,0,null,null,null,6,6,6,6,6,6,6,6,0,null,6,6,6]
["Behavior5",0,0,0,0,0,0,0,0,0,0,"Supervision, Community",null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Behavior5",1,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Behavior5",2,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0,0,null,0,0,0]
["Behavior5",3,0.05,0.05,0.05,0.05,0.1,0.75,0.75,0.75,0,null,null,null,0.05,0.05,0.05,0.05,0.1,0.75,0.75,0.75,0,null,0.05,0.1,0.75]
["Behavior5",4,1,1,1,1,1,1,1,1,0,null,null,null,1,1,1,1,1,1,1,1,0,null,1,1,1]
["Behavior5",5,1,1,1,1,1,1,1,1,0,null,null,null,1,1,1,1,1,1,1,1,0,null,1,1,1]

{"sheet":"Control","index":12,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[null,"Before-Save\nActive Sheet",null,"County/Brokerage LookUp",null,"Relationships",null,"Support Need Options - ADL (CNA)","Support Need Options - Medical  (CNA)","Support Need Options - Nighttime","Support Need Options - Behavior","Documentation Needed Options","Documentation Needed Options - Behavior",null,"This\nTool-Type","Tool-Type\nIndex",null,"ANA\nService Settings","ANA\nSE Mapping","CNA\nService Settings","CNA\nSE Mapping",null,"SE No Options","ANA\nSE Non-Group Home","CNA\nSE Non-Group Home","CNA\nSE C-W Foster Care","SE Foster Care","ANA\nSE Group Home","CNA\nSE Group Home","SE Other"]
[null,"Client Demographics",null,"(Select)",null,"(Select)",null,"Independent or Age Appropriate Supports Provided","Independent","Independent","Not Applicable or Age-Appropriate Supervision","None","None",null,{"$f":"LEFT(TRIM(VersionDisplay), FIND(\" \",TRIM(VersionDisplay)) - 1)","v":"CNA"},{"$f":"IF(O2=\"ANA\",0,IF(O2=\"CNA\",1,\"#VALUE!\"))","v":1},null,"(Select)","SE_NoOptions","(Select)","SE_NoOptions",null,"(Select)","(Select)","(Select)","(Select)","Foster Care (SE 58)","24hr Residential (SE 50)","24hr Residential (SE 50)","(Explain in comment field of \"Summary of In-Home Hours\" sheet)"]
[null,null,null,"Community Pathways",null,"Self",null,"Partial Assist","Independent or Age Appropriate Supports Provided","Nighttime Assist - monthly","Independent or Age Appropriate Supports Provided","Caregivers' schedule and duties","OIS Training",null,null,null,null,"Family Home","SE_NonGroupHome_ANA","Family Home","SE_NonGroupHome_CNA",null,null,"Comp In-Home (SE 49)","Child Long-term Support (SE 151)","Child Long-term Support (SE 151)",null,"SACU (SE 141)","Child Residential (SE 142)"]
[null,"Keep Current File Name",null,"CSI",null,"Legal Guardian",null,"Partial Assist - assistance","Individual-Directed Care","Nighttime Assist - weekly","Within Hearing or Visual Distance","Not Applicable","Functional Assessment and Formal Behavior Support Plan",null,null,null,null,"Own Home","SE_NonGroupHome_ANA","Child-welfare Foster","SE_CW_FosterCare",null,null,"Brokerage In-Home (SE 149)","CIIS (SE 145)","CIIS (SE 145)",null,null,"SACU (SE 141)"]
[null,true,null,"EOSSB",null,"Parent",null,"Partial Assist - cueing","Partial Assist","Nighttime Assist - intermittent nightly","Within Hearing and Visual Distance",null,"Functional Assessment and Formal Behavior Support Plan, OIS Training",null,null,null,null,"Foster Care","SE_FosterCare","DD Foster","SE_FosterCare",null,null,"Supported Living (SE 51)",null,"Foster Care (SE 58)","^ NOTE: Shaded cell's named-range SE_FosterCare is also referenced by CNA's \"Summary of In-Home Hours\" sheet formula"]
[null,null,null,"Full Access",null,"Provider/Staff",null,"Partial Assist - food cut up","Partial Assist - 1 to 3 per day","Nighttime Assist - ongoing nightly","Redirecting",null,"Functional Assessment and Formal Behavior Support Plan if indicated by the FA",null,null,null,null,"24-hr. Group Home","SE_GroupHome_ANA","24-hr. Group Home","SE_GroupHome_CNA",null,null,"* BEWARE: Shaded cell is referenced by the \"New Scoring\" sheet",null,"* Shaded cell is same CNA value as SE_FosterCare so SE_FosterCare is referenced, for both cases, by CNA's \"Summary of In-Home Hours\" formula"]
[null,"Assessment Grace-\nPeriod Days",null,"Full Access High Desert",null,"Behavior Specialist",null,"Partial Assist - intermittent","Partial Assist - weekly","Nighttime 1:1 Assist","Behavior Plan - No Physical Interventions",null,"Functional Assessment and Formal Behavior Support Plan if indicated by the FA, Caregivers' schedule and duties",null,null,null,null,"Other","SE_Other","Other","SE_Other"]
[null,60,null,"Inclusion",null,"Nursing Professional",null,"Full Assist","Partial Assist and Monitoring","Nighttime 2:1 Assist","Behavior Plan - Physical Interventions",null,null,null,null,null,null,"* NOTE: Shaded cells are named-ranges referenced by \"Summary of In-Home Hours\" sheet formula"]
[null,null,null,"Ind NW",null,"Services Coordinator",null,"Full Assist - constant","Full Assist","Not Applicable","Mental Health Plan"]
[null,null,null,"ISN",null,"Regional MCL/Crisis Staff",null,"Full Assist - constant/aspiration risk","Full Assist - 1 to 4",null,"Exclusive Focus"]
[null,null,null,"Mentor Metro",null,"Child Welfare Staff",null,"Two-Person Assist","Full Assist - 5 or 6",null,"Exclusive Focus - 2"]
[null,null,null,"Mid Valley",null,"SPD Kids’ Residential Coordinator",null,"Not Applicable","Full Assist - 7 or more",null,"Exclusive Focus - 4"]
[null,null,null,"RCO",null,"Other",null,null,"Full Assist - more than 3 per day",null,"Exclusive Focus - 6"]
[null,null,null,"SDRI",null,null,null,null,"Full Assist and Monitoring - exclusive focus",null,"Exclusive Focus - 8"]
[null,null,null,"SORB",null,null,null,null,"Delegated Nursing Tasks, < 50",null,"Exclusive Focus - 10"]
[null,null,null,"UCP",null,null,null,null,"Delegated Nursing Tasks, >= 50",null,"Exclusive Focus - 12"]
[null,null,null,"-----------------------------",null,null,null,null,"Direct Nursing by a Licensed Nurse",null,"Two-Person Assist"]
[null,null,null,"BAKER",null,null,null,null,"Two-Person Assist",null,"Not Applicable"]
[null,null,null,"BENTON",null,null,null,null,"Not Applicable"]
[null,null,null,"CLACKAMAS"]
[null,null,null,"CLATSOP"]
[null,null,null,"COLUMBIA"]
[null,null,null,"COOS"]
[null,null,null,"CROOK"]
[null,null,null,"CURRY"]
[null,null,null,"DESCHUTES"]
[null,null,null,"DOUGLAS"]
[null,null,null,"GILLIAM"]
[null,null,null,"GRANT"]
[null,null,null,"HARNEY"]
[null,null,null,"HOOD RIVER"]
[null,null,null,"JACKSON"]
[null,null,null,"JEFFERSON"]
[null,null,null,"JOSEPHINE"]
[null,null,null,"KLAMATH"]
[null,null,null,"LAKE"]
[null,null,null,"LANE"]
[null,null,null,"LINCOLN"]
[null,null,null,"LINN"]
[null,null,null,"MALHEUR"]
[null,null,null,"MARION"]
[null,null,null,"MORROW"]
[null,null,null,"MULTNOMAH"]
[null,null,null,"POLK"]
[null,null,null,"SHERMAN"]
[null,null,null,"TILLAMOOK"]
[null,null,null,"UMATILLA"]
[null,null,null,"UNION"]
[null,null,null,"WALLOWA"]
[null,null,null,"WASCO"]
[null,null,null,"WASHINGTON"]
[null,null,null,"WHEELER"]
[null,null,null,"YAMHILL"]
[null,null,null,"-----------------------------"]
[null,null,null,"CIIS"]
[null,null,null,"(Type in other…)"]