{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Client Demographics","ADLs","Medical Needs","Nursing Assessment Indicators","Nighttime Needs","Behavior Needs","Foster Care Budget Summary","Host Home Budget Summary","Children Rate Information","Support Needs Summary","MFCU Use Only","Raw Scoring","New Scoring","HHRawScoring","HHScoring"],"not_rendered":{"images":22,"macros":1,"defined_names":61},"read":"whole","date_system":"1900"}

{"sheet":"Client Demographics","index":0,"n_rows":26,"n_cols":15,"rows_kept":26,"merged":[[0,0,0,16],[2,0,2,2],[2,3,2,8],[2,9,2,10],[2,11,2,12],[2,14,2,16],[3,0,3,2],[3,3,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[4,0,4,5],[4,6,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,5],[5,6,5,8],[5,11,5,13],[5,14,5,16],[6,0,6,3],[6,4,6,12],[6,14,6,16],[7,0,7,3],[7,4,7,16],[8,0,8,3],[8,4,8,16],[9,0,9,3],[9,4,9,7],[9,8,9,9],[9,10,9,12],[9,14,9,16],[10,0,10,3],[10,4,10,12],[10,14,10,16],[11,0,11,7],[11,8,11,12],[11,13,11,16],[12,1,12,7],[12,8,12,12],[12,13,12,15],[13,1,13,7],[13,8,13,12],[13,13,13,15],[14,1,14,7],[14,8,14,12],[14,13,14,15],[15,1,15,7],[15,8,15,12],[15,13,15,15],[16,1,16,7],[16,8,16,12],[16,13,16,15],[17,1,17,7],[17,8,17,12],[17,13,17,15],[18,0,18,16],[19,0,19,2],[19,3,19,4],[19,5,19,7],[19,8,19,9],[19,10,19,13],[19,14,19,16]]}
["Profile for Foster Care Support Needs Assessment Children"]
[]
["Name of Child\n(Legal Name) ",{"$nulls":8},"Date of Birth",{"$nulls":3},"Age",{"$f":"ClientAge","v":""}]
["Prime #",{"$nulls":8},"Height",{"$nulls":3},"Weight"]
["Did the individual participate in the Assessment?",{"$nulls":8},"Gender"]
["Is this an early process assessment?",{"$nulls":10},"Date of Assessment"]
["Provider Name",{"$nulls":12},"Phone"]
["Provider Address - Street"]
["Provider Address - City, State, Zip"]
["CDDP Services Coordinator",{"$nulls":7},"CDDP/County of Case Mgt.",{"$nulls":4},"Phone"]
["Assessor's Name",{"$nulls":12},"Phone"]
["Name of Assessment Participants",{"$nulls":7},"Relationship to Individual",{"$nulls":4},"Phone"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
[]
["Assessment Start Time",{"$nulls":4},"Assessment End Time",{"$nulls":4},"Duration of Assessment",{"$nulls":3},{"$f":"IF(D20 = \"\",\"\",IF(I20=\"\",\"\",24*(IF(D20>I20,I20+1-D20,I20-D20))))","v":""}]
[]
[]
[]
[]
[]
["SNAP-Child version 22.12C"]

{"sheet":"ADLs","index":1,"n_rows":143,"n_cols":4,"rows_kept":143,"merged":[[1,0,1,1],[2,0,2,1],[9,0,9,1],[10,0,10,1],[13,0,13,1],[14,0,14,1],[21,0,21,1],[22,0,22,1],[25,0,25,1],[26,0,26,1],[33,0,33,1],[34,0,34,1],[37,0,37,1],[38,0,38,1],[47,0,47,1],[48,0,48,1],[51,0,51,1],[52,0,52,1],[59,0,59,1],[60,0,60,1],[63,0,63,1],[65,0,65,1],[72,0,72,1],[73,0,73,1],[76,0,76,1],[78,0,78,1],[85,0,85,1],[86,0,86,1],[89,0,89,1],[90,0,90,1],[97,0,97,1],[98,0,98,1],[101,0,101,1],[102,0,102,1],[109,0,109,1],[110,0,110,1],[113,0,113,1],[114,0,114,1],[120,0,120,1],[121,0,121,1],[124,0,124,1],[125,0,125,1],[131,0,131,1],[132,0,132,1],[135,0,135,1],[136,0,136,1],[142,0,142,1],[143,0,143,1]]}
[]
["AMBULATION / MOBILITY IN THE HOME"]
[{"$f":"IF('Raw Scoring'!B2=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's physical ability to move around in the individual's home with or without mechanical aids.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\nFor children age 4 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 4 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can ambulate in familiar surroundings without assistance from another individual with or without mechanical aids.\n","ADL1","HomeAmb1"]
[null,"Partial Assist: The individual is dependent on assistance from another person for some aspect of \nambulation/mobility.\n","ADL1","HomeAmb2"]
[null,"Full Assist: The individual is dependent on assistance from another person for all aspects of \nambulation/mobility.\n","ADL1","HomeAmb3"]
[null,"Two-Person Assist: The individual requires assistance of two people for all aspects of ambulation/mobility. Documentation of caregivers' schedule and duties are required.\n","ADL1","HomeAmb4"]
["NOTES"]
[]
[]
[]
["AMBULATION / MOBILITY IN THE COMMUNITY"]
[{"$f":"IF('Raw Scoring'!B3=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's physical ability to move around in the individual's community with or without mechanical aids.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\nFor children age 5 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 5 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can ambulate in familiar surroundings without assistance from another individual with or without mechanical aids.\n","ADL2","ComAmb1"]
[null,"Partial Assist: The individual is dependent on assistance from another person for some aspect of \nambulation/mobility. \n","ADL2","ComAmb2"]
[null,"Full Assist: The individual is dependent on assistance from another person for all aspects of \nambulation/mobility.\n","ADL2","ComAmb3"]
[null,"Two-Person Assist: The individual requires assistance of two people for all aspects of ambulation/mobility. Documentation of caregivers' schedules and duties are required.\n","ADL2","ComAmb4"]
["NOTES"]
[]
[]
[]
["TRANSFERRING / POSITIONING"]
[{"$f":"IF('Raw Scoring'!B4=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual'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 individual, which are not due to behaviors.\nFor children age 4 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 4 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can transfer without assistance from another individual with or without mechanical aids.\n","ADL3","Trans1"]
[null,"Partial Assist: The individual can perform the transfer with or without mechanical aids, but requires some assistance by another person for some aspect of transferring.\n","ADL3","Trans2"]
[null,"Full Assist: The individual is dependent on another person for all aspects of transferring and positioning.\n","ADL3","Trans3"]
[null,"Two-Person Assist: The individual requires assistance of two people for all aspects of transferring and positioning. Documentation of caregivers' schedule and duties are required.\n","ADL3","Trans4"]
["NOTES"]
[]
[]
[]
["EATING / DRINKING"]
[]
[null,"This section assesses the individual'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 individual, which are not due to behaviors.\nFor children age 4 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 4 years, unless the child needs the support of Full Assist - constant/aspiration risk.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can eat and drink safely and requires no assistance or monitoring while eating or drinking.\n","ADL4","Eatdrink1"]
[null,"Partial Assist - food cut up: The individual requires intermittent assistance and monitoring while eating and drinking, and may require their food to be cut up for them by another person. \n","ADL4","Eatdrink2"]
[null,"Partial Assist - intermittent: The individual 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","ADL4","Eatdrink3"]
[null,"Full Assist - constant: The individual 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","ADL4","Eatdrink4"]
[null,"Full Assist - constant/aspiration risk: The individual 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","ADL4","Eatdrink5"]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["TOILETING"]
[]
[null,"This section assesses the individual'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 individual, which are not due to behaviors.\nFor children age 4 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 4 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can manage toileting independently and may use mechanical aids, if required. Mark independent if not applicable.\n","ADL5","Toilet1"]
[null,"Partial Assist - cueing: The individual requires verbal cueing and monitoring to complete toileting activities.\n","ADL5","Toilet2"]
[null,"Partial Assist - assistance: The individual requires assistance from another person for some aspects of using the toilet for elimination. \n","ADL5","Toilet3"]
[null,"Full Assist: The individual is dependent on another person, even with mechanical aids, to assist with some or all parts of using the toilet for elimination. \n","ADL5","Toilet4"]
["NOTES"]
[]
[]
[]
["BLADDER CONTROL"]
[null,"Care for Incontinence"]
[]
[null,"This section assesses the individual's ability to care for incontinence of bladder.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\nFor children age 3 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 3 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual is independent with incontinence care. Mark independent if not applicable.\n","ADL6","Bladder1"]
[null,"Partial Assist: The individual requires assistance from another person to manage incontinency, catheter, or sheath changes, including assistance changing incontinence garments, soiled clothing or equipment. * \n","ADL6","Bladder2"]
[null,"Full Assist: The individual is totally incontinent and dependent on another person for incontinence or catheter \ncare. *\n","ADL6","Bladder3"]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["BOWEL CONTROL"]
[null,"Care for Incontinence"]
[]
[null,"This section assesses the individual's ability to care for incontinence of the bowel.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\nFor children age 3 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 3 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual is independent with bowel control issues, whether the individual is continent, incontinent or has an ostomy. Mark independent if not applicable.\n","ADL7","Bowel1"]
[null,"Partial Assist: The individual requires assistance managing incontinence of the bowel, changing incontinence garments, soiled clothing or ostomy care. * \n","ADL7","Bowel2"]
[null,"Full Assist: The individual is incontinent of the bowel and dependent on another person to complete all incontinence care. * \n","ADL7","Bowel3"]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["MENSES"]
[]
[null,"This section assesses the individual's ability to care for feminine hygiene needs during menses.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors."]
[]
[null,"Not Applicable\n","ADL8","Menses1"]
[null," Independent: The individual can manage her own feminine hygiene/menses care.\n","ADL8","Menses2"]
[null,"Partial Assist: The individual requires monitoring and some assistance from another person for some aspects of feminine hygiene/menses care.\n","ADL8","Menses3"]
[null,"Full Assist: The individual is dependent on another person, to assist with feminine hygiene/menses \ncare.\n","ADL8","Menses4"]
["NOTES"]
[]
[]
[]
["BATHING"]
[{"$f":"IF('Raw Scoring'!B10=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to bathe and wash their hair.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\nFor children age 4 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 4 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can bathe and wash hair without assistance or supervision.\n","ADL9","Bath1"]
[null,"Partial Assist: The individual requires minor physical assistance, standby monitoring, and/or cueing from another person to bathe and wash their hair.\n","ADL9","Bath2"]
[null,"Full Assist: The individual is dependent on assistance from another person to bathe them and wash their hair.\n","ADL9","Bath3"]
[null,"Two-Person Assist: The individual requires assistance of two people while bathing and washing their \nhair. Documentation of caregivers' schedule and duties are required.\n","ADL9","Bath4"]
["NOTES"]
[]
[]
[]
["ORAL HYGIENE"]
[]
[null,"This section assesses the individual's ability to clean and care for the individual's teeth, gums, and/or dentures in a healthy and safe manner.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\nFor children age 5 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 5 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can manage oral hygiene, without reminders, assistance or supervision.\n","ADL10","Oral1"]
[null,"Partial Assist: The individual requires assistance with oral hygiene, which may include prompting and cues to complete some aspect of oral hygiene activities.\n","ADL10","Oral2"]
[null,"Full Assist: The individual requires assistance from another person to complete oral hygiene \nactivities.\n","ADL10","Oral3"]
["NOTES"]
[]
[]
[]
["DRESSING & HAIR CARE"]
[]
[null,"This section assesses the individual's ability to dress, undress and/or comb hair.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors.\nFor children age 4 years and older, check an option only if the support needed is due to the child's disability.\nDo not check an option for children under age 4 years.\n"]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can dress, undress and/or comb hair independently or with reminding.\n","ADL11","Dress1"]
[null,"Partial Assist: The individual requires assistance from another person, which may include frequent monitoring and cueing for completing some aspect of dressing, undressing and/or combing hair.\n","ADL11","Dress2"]
[null,"Full Assist: The individual requires full assistance from another person for ALL aspects of dressing, undressing and/or combing hair.","ADL11","Dress3"]
["NOTES"]
[]
[]
[]
["SHAVING"]
[]
[null,"This section assesses the individual's ability to shave.\nChoose the option that most accurately reflects the supports required by the individual, which are not due to behaviors."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can shave independently or with reminding.\n\n","ADL12","Shave1"]
[null,"Partial Assist: The individual requires assistance from another person, which may include frequent monitoring and cueing for completing some aspect of shaving.\n","ADL12","Shave2"]
[null,"Full Assist: The individual requires total assistance from another person to shave.","ADL12","Shave3"]
["NOTES"]

{"sheet":"Medical Needs","index":2,"n_rows":167,"n_cols":4,"rows_kept":167,"merged":[[1,0,1,1],[2,0,2,1],[8,0,8,1],[9,0,9,1],[12,0,12,1],[13,0,13,1],[19,0,19,1],[20,0,20,1],[23,0,23,1],[24,0,24,1],[30,0,30,1],[31,0,31,1],[34,0,34,1],[35,0,35,1],[41,0,41,1],[42,0,42,1],[45,0,45,1],[46,0,46,1],[54,0,54,1],[55,0,55,1],[58,0,58,1],[59,0,59,1],[66,0,66,1],[67,0,67,1],[70,0,70,1],[71,0,71,1],[78,0,78,1],[79,0,79,1],[82,0,82,1],[83,0,83,1],[91,0,91,1],[92,0,92,1],[95,0,95,1],[96,0,96,1],[108,0,108,1],[109,0,109,1],[112,0,112,1],[113,0,113,1],[138,0,138,1],[139,0,139,1],[166,0,166,1],[167,0,167,1]]}
[]
["COMMUNICATION - EXPRESSIVE"]
[]
[null,"This section assesses the individual'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.\nFor children age 2 years and older check an option only if the support needed is due to the child's \ndisability.\nDo not check an option for children under age 2 years."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can communicate their needs with or without the use of adaptive equipment and requires no assistance from another person.\n","Medical1","Commexp1"]
[null,"Partial Assist: The individual requires assistance from another person intermittently to express their needs so others will understand them, with or without adaptive communication devices or systems. \n","Medical1","Commexp2"]
[null,"Full Assist: The individual 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","Medical1","Commexp3"]
["NOTES"]
[]
[]
[]
["COMMUNICATION -  RECEPTIVE"]
[]
[null,"This section assesses the individual's ability to understand information and directions from another\nperson.\nChoose the option that most accurately reflects the supports required by the individual.\nFor children age 2 years and older check an option only if the support needed is due to the child's \ndisability.\nDo not check an option for children under age 2 years."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can understand information conveyed to them.\n\n","Medical2","Commrec1"]
[null,"Partial Assist: The individual requires intermittent assistance from another person to provide guidance, reminders and direction in order to understand information or directions from another person. \n","Medical2","Commrec2"]
[null,"Full Assist: The individual requires continual assistance from another person to provide guidance, reminders and direction in order to understand information or directions from another person.\n","Medical2","Commrec3"]
["NOTES"]
[]
[]
[]
["SAFETY"]
[]
[null,"This section assesses the individual's ability 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 individual."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual requires no assistance from another person.\n\n","Medical3","Safe1"]
[null,"Partial Assist: The individual 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 ","Medical3","Safe2"]
[null,"Full Assist: The individual requires continual assistance/monitoring to recognize, understand and protect themselves from hazards or harmful situations or people at home or in the community.\n","Medical3","Safe3"]
["NOTES"]
[]
[]
[]
["FIRE EVACUATION"]
[]
[null,"This section assesses the individual's ability to evacuate the home in an emergency.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual evacuates with no assistance.\n","Medical4","Fire1"]
[null,"Partial Assist: The individual requires verbal assistance from another person to safely evacuate during an emergency.\n\n","Medical4","Fire2"]
[null,"Full Assist: The individual must be physically assisted by another person in order to safely evacuate during \nan emergency.\n","Medical4","Fire3"]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - ORAL"]
[]
[null,"This section assesses the individual's oral medication regimen.\nChoose the option that most accurately reflects the supports required by the individual.\nFor children, check an option only if medication is due to the child's disability or disability-related medical condition(s)."]
[]
[null,"Independent or Age Appropriate Supports Provided: Individual does not take any medication or self administers medication with or without provider oversight.\n","Medical5","Medoral1"]
[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","Medical5","Medoral2"]
[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","Medical5","Medoral3"]
[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","Medical5","Medoral4"]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - INHALANTS, TOPICALS, SUPPOSITORIES"]
[]
[null,"This section assesses the individual's inhalants, topicals and suppositories regimen.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[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","Medical6","Medinhale1"]
[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","Medical6","Medinhale2"]
[null,"Full Assist: The individual's inhalants, topicals, suppository regimen must be administered by another \nperson.* \n","Medical6","Medinhale3"]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["MEDICATION MANAGEMENT SUPPORTS - INJECTIONS"]
[]
[null,"This section assesses the individual's medication regimen administered by injecting a medication.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[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","Medical7","Medinject1"]
[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","Medical7","Medinject2"]
[null,"Full Assist: The individual's regimen by injection is totally administered and monitored by another person. (e.g. insulin). * \n","Medical7","Medinject3"]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["HEALTH MANAGEMENT SUPPORTS - GENERAL"]
[]
[null,"This section assesses the individual'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 individual."]
[]
[null,"Independent or Age Appropriate Supports Provided: The individual can identify and communicate pain, discomfort or medical needs.  The individual can access health care in the community independently and follow through with prescribed medication, treatments and dietary requirements. \nCheck Independent for all children under the age of 15 years and move to the next Health Management section.\n","Medical8","Healthsup1"]
[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","Medical8","Healthsup2"]
[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","Medical8","Healthsup3"]
[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","Medical8","Healthsup4"]
[null,"*See individual indicators for a Nursing Assessment Referral"]
["NOTES"]
[]
[]
[]
["COMPLEX HEALTH MANAGEMENT SUPPORTS"]
[{"$f":"IF('Raw Scoring'!Q11=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual'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 individual."]
[]
[null,"Not Applicable:  The individual does not have complex medical conditions.\n","Medical9","Healthcomp1"]
[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","Medical9","Healthcomp2"]
[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","Medical9","Healthcomp3"]
[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","Medical9","Healthcomp4"]
[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","Medical9","Healthcomp5"]
[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.* Documentation of caregivers' schedule and duties required.\n","Medical9","Healthcomp6"]
[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. * \nDocumentation of caregivers' schedule and duties required.\n\n","Medical9","Healthcomp7"]
[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. * & *** \nDocumentation of caregivers' schedules and duties required.\n","Medical9","Healthcomp2to1"]
[null,"* See individual indicators for a Nursing Assessment Referral\n*** OIS training, level IF-M. for physical intervention during a medical procedure is required."]
["NOTES"]
[]
[]
[]
["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,"Not applicable:  The individual does not use any of the equipment listed below.","Mobility","Mobility1"]
[null,"Cane","Mobility","Mobility2"]
[null,"Leg braces","Mobility","Mobility3"]
[null,"Walker","Mobility","Mobility4"]
[null,"Ankle or foot orthotics","Mobility","Mobility5"]
[null,"Arm splints","Mobility","Mobility6"]
[null,"Adaptive eating equipment (not tube feeding equipment)\n","Mobility","Mobility7"]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.","Bed","Bed1"]
[null,"Hospital bed","Bed","Bed2"]
[null,"Grab bars by bed","Bed","Bed3"]
[null,"Hanging bar above bed\n","Bed","Bed4"]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.","Bath","Bath1"]
[null,"Shower chair","Bath","Bath2"]
[null,"Grab bars in bath room","Bath","Bath3"]
[null,"Shower gurney","Bath","Bath4"]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.","Comm","Comm1"]
[null,"Non electronic communication boards","Comm","Comm2"]
[null,"Electronic communication boards\n","Comm","Comm3"]
[]
["EQUIPMENT - Continued"]
[]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.","Transfer","Transfer1"]
[null,"Hoyer lift","Transfer","Transfer2"]
[null,"Transfer equipment (transfer board)\n","Transfer","Transfer3"]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.","Motion","Motion1"]
[null,"Body jacket","Motion","Motion2"]
[null,"Manual wheel chair","Motion","Motion3"]
[null,"Electric power wheel chair","Motion","Motion4"]
[null,"Prone stander","Motion","Motion5"]
[null,"Sidelyer\n","Motion","Motion6"]
[]
[null,"Not applicable:  The individual does not use any of the equipment listed below.","Mechan","Mechan1"]
[null,"Specialized tube feeding equipment*","Mechan","Mechan2"]
[null,"Nebulizers*","Mechan","Mechan3"]
[null,"C-PAP*","Mechan","Mechan4"]
[null,"Oxygen","Mechan","Mechan5"]
[null,"Ventilator","Mechan","Mechan6"]
[null,"Pulse oxymeter*","Mechan","Mechan7"]
[null,"Heart monitor*","Mechan","Mechan8"]
[null,"Suctioning equipment","Mechan","Mechan9"]
[null,"Vegal stimulator","Mechan","Mechan10"]
[null,"Diabetic insulin pump","Mechan","Mechan11"]
[null,"Baclofen pump","Mechan","Mechan12"]
[null,"Prosthetics\n","Mechan","Mechan13"]
[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}

{"sheet":"Nighttime Needs","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"merged":[[1,0,1,1],[2,0,2,1],[13,0,13,1],[14,0,14,1],[17,0,17,1],[18,0,18,1],[29,0,29,1],[30,0,30,1]]}
[]
["NIGHTTIME NEEDS - MEDICAL SUPPORTS"]
[{"$f":"IF('Raw Scoring'!G2=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's need for MEDICAL supports and monitoring during nighttime hours.\nChoose the option that most accurately reflects the supports required by the individual.\n"]
[]
[null,"Not Applicable\n","Nighttime1","Nightmed1"]
[null,"Independent: The individual 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","Nighttime1","Nightmed2"]
[null,"Individual Requires Nighttime Assistance - monthly: The individual requires occasional monitoring throughout the month between the hours of 10:00 P.M. and 5:00 A.M.\n","Nighttime1","Nightmed3"]
[null,"Individual Requires Nighttime Assistance - weekly: The individual requires occasional monitoring throughout the week between the hours of 10:00 P.M. and 5:00 A.M.\n","Nighttime1","Nightmed4"]
[null,"Individual Requires Nighttime Assistance - intermittent nightly: The individual requires intermittent nightly assistance from another person 1 to 3 times per night between the hours of 10:00 P.M. and 5:00 A.M. Assistance includes physical assistance and/or treatments. \n","Nighttime1","Nightmed5"]
[null,"Individual Requires Nighttime Assistance - ongoing nightly: The individual requires ongoing assistance from another person available to respond between the hours of 10:00 P.M. and 5:00 A.M. Assistance includes physical assistance and/or repositioning, but exclusive focus is not required throughout the night.\n","Nighttime1","Nightmed6"]
[null,"Individual Requires Nighttime 1:1 Assistance: The individual requires ongoing 1:1 exclusive focus assistance from another person between the hours of 10:00 P.M. and 5:00 A.M. Assistance can include: prompting, physical assistance, repositioning, medical monitoring and implementation of medical treatments. \nDocumentation of caregivers' schedule and duties are required. \n","Nighttime1","Nightmed7"]
[null,"Individual Requires Nighttime 2:1 Assistance: The individual requires ongoing 2:1 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. \nDocumentation of caregivers' schedules and duties are required.\n","Nighttime1","Nightmed8"]
["NOTES"]
[]
[]
[]
["NIGHTTIME NEEDS - BEHAVIOR SUPPORTS"]
[{"$f":"IF('Raw Scoring'!G3=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's need for BEHAVIOR supports and monitoring during \nnighttime hours.\nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable\n","Nighttime2","NightBehav1"]
[null,"Independent: The individual 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","Nighttime2","NightBehav2"]
[null,"Individual Requires Nighttime Assistance - monthly: The individual requires occasional monitoring throughout the month between the hours of 10:00 P.M. and 5:00 A.M.\n","Nighttime2","NightBehav3"]
[null,"Individual Requires Nighttime Assistance - weekly: The individual requires occasional verbal cues or monitoring throughout the week between the hours of 10:00 P.M. and 5:00 A.M. \n","Nighttime2","NightBehav4"]
[null,"Individual Requires Nighttime Assistance - intermittent nightly: The individual requires intermittent nightly assistance from another person 1 to 3 times per night between the hours of 10:00 P.M. and 5:00 A.M. Assistance includes any behavior supports.\n","Nighttime2","NightBehav5"]
[null,"Individual Requires Nighttime Assistance - ongoing nightly: The individual requires ongoing assistance from another person available to respond between the hours of 10:00 P.M. and 5:00 A.M. Assistance includes any behavior supports, but exclusive focus is not required throughout the night.\n","Nighttime2","NightBehav6"]
[null,"Individual Requires Nighttime 1:1 Assistance: The individual requires ongoing 1:1 exclusive focus from another person between the hours of 10:00 P.M. and 5:00 A.M. Assistance can include prompting, physical interventions, monitoring and behavior supports and interventions. \nDocumentation of caregivers' schedule and duties are required.\n","Nighttime2","NightBehav7"]
[null,"Individual Requires Nighttime 2:1 Assistance: The individual requires ongoing 2:1 exclusive focus from 2 people between the hours of 10:00 P.M. and 5:00 A.M. Assistance can include prompting, physical interventions, monitoring and/or behavior supports and interventions. \nDocumentation of caregivers' schedules and duties are required.\n","Nighttime2","NightBehav8"]
["NOTES"]

{"sheet":"Behavior Needs","index":5,"n_rows":77,"n_cols":4,"rows_kept":77,"merged":[[1,0,1,1],[2,0,2,1],[10,0,10,1],[11,0,11,1],[14,0,14,1],[15,0,15,1],[24,0,24,1],[25,0,25,1],[28,0,28,1],[29,0,29,1],[38,0,38,1],[39,0,39,1],[42,0,42,1],[43,0,43,1],[54,0,54,1],[62,0,62,1],[63,0,63,1],[66,0,66,1],[67,0,67,1],[77,0,77,1],[78,0,78,1]]}
[]
["BEHAVIORAL SUPPORTS - NO FORMAL PLAN - SUPERVISON AND MONITORING"]
["Supervision and monitoring for behavior and mental health"]
[]
[null,"This section assesses the individual'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 supports required by the individual."]
[]
[null,"Not Applicable or Age-Appropriate Supervision:  The individual does not require supervision or monitoring from another person for behavioral issues or, for a child, age-appropriate supervision or monitoring is provided.\n","Behavior1","BehavMin1"]
[null,"Redirecting:  The individual has a transition plan, ISP or mental health guidelines that require redirection \nduring waking hours, to assure the safety of the individual.  This behavior does not require a formal \nbehavior support plan and is not addressed in any formal BSP.\n","Behavior1","BehavMin2"]
[null,"Within Hearing or Visual Distances:  The individual 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","Behavior1","BehavMin3"]
[null,"Within Hearing and Visual Distances:  The individual 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","Behavior1","BehavMin4"]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - PLANS - HOME AND COMMUNITY"]
["Supervision, monitoring and plans for behavior and mental health"]
[]
[null,"This section assesses the individual'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 individual."]
[]
[null,"Not Applicable:  The individual does not have behavioral or mental health needs that require a plan.\n","Behavior2","Behavform1"]
[null,"Behavior Plan - No Physical Interventions:  The individual has a behavior support need that may require a formal behavior plan, which does not include physical intervention(s). *\n","Behavior2","Behavform2"]
[null,"Behavior Plan:  The individual has a behavior support need that requires a formal behavior plan, which does include physical intervention(s). **&***\n","Behavior2","Behavform3"]
[null,"Mental Health Plan:  The individual has a mental health support need that requires mental health guidelines that include a crisis response plan that may include emergency physical intervention(s). ***\n","Behavior2","Behavform4"]
[null,"If 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, ** then a functional assessment (FA) must be completed and a formal behavior support plan must be developed, if indicated by the FA. ***OIS training is required for provider, resident manager and all substitute caregiver(s)."]
["NOTES"]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISON - HOME"]
["Supervision and monitoring for behavior, mental health or legally mandated supervision in the home environment."]
[]
[null,"This section assesses the individual's ability to function in the home with supports and interventions from another person to maintain safety of self and/or others. \nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable or Age-Appropriate Supervision:  The individual does not require supervision or monitoring from another person for behavioral issues or, for a child, age-appropriate supervision or monitoring is provided.\n","Behavior3","BehavPlan1"]
[null,"Redirecting:  The individual has or may need a formal behavior plan, a legal order, or mental health guidelines that require redirection during waking hours, to assure the safety of the individual. *\n","Behavior3","BehavPlan2"]
[null,"Within Hearing or Visual Distances:  The individual has or may need a formal behavior plan, a legal order, or mental health guidelines that require supervision of the individual to be within hearing or visual distance. *\n","Behavior3","BehavPlan3"]
[null,"Within Hearing and Visual Distances:  The individual has or may need a formal behavior plan, a legal order, or mental health guidelines that require supervision of the individual to be within hearing and visual distance. *\n","Behavior3","BehavPlan4"]
[null,"If 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."]
[]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISION - HOME - ONE ON ONE"]
["Supervision and monitoring for behavior, mental health or legally mandated supervision in the home environment."]
[null,{"$f":"IF('Raw Scoring'!Q5=7,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual's ability to function in the home with supports and interventions from another person to maintain safety of self and/or others. \nChoose the option that most accurately reflects the supports required by the individual."]
[]
[null,"Not Applicable: The individual does not require one-on-one or two-on-one supervision in the home.\n","Behavior4","Behavinhome1"]
[null,"One-on-One - 2:  The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require 1:1 supervision.  A caregiver must maintain an exclusive focus on the individual 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 are required.\n","Behavior4","Behavinhome2"]
[null,"One-on-One - 4: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require 1:1 supervision.  A caregiver must maintain an exclusive focus on the individual 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 are required.\n","Behavior4","Behavinhome3"]
[null,"One-on-One - 6: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require 1:1 supervision.  A caregiver must maintain an exclusive focus on the individual 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 are required.\n","Behavior4","Behavinhome4"]
[null,"Continued on next page"]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISION - HOME continued"]
[]
[]
[null,"One-on-One - 8: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require 1:1 supervision.  A caregiver must maintain an exclusive focus on the individual 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 are required.\n","Behavior4","Behavinhome5"]
[null,"One-on-One - 10: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require 1:1 supervision.  A caregiver must maintain an exclusive focus on the individual 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 are required.\n","Behavior4","Behavinhome6"]
[null,"One-on-One - 12: The individual has or may need a formal behavior plan, has a legal order or mental health guidelines that require 1:1 supervision.  A caregiver must maintain an exclusive focus on the individual 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 are required.\n","Behavior4","Behavinhome7"]
[null,"Two-Person Assist: The individual has or needs a formal behavior plan, has a legal order or mental health guidelines that require 2:1 exclusive focus on the individual 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' schedules and duties are required.\n","Behavior4","Behavinhome8"]
[null,"If 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, and if marked with ** and the individual 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."]
[]
[]
[]
[]
["BEHAVIORAL SUPPORTS - SUPERVISION - COMMUNITY"]
["Supervision and monitoring for behavior, mental health or legally mandated supervision in the \ncommunity."]
[null,{"$f":"IF('Raw Scoring'!Q6=5,\"2:1 Review\",\"\")","v":""}]
[null,"This section assesses the individual'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 supports required by the individual."]
[]
[null,"Not Applicable: The individual does not require one-on-one or two-on-one supervision in the community.\n","Behavior5","BehavComm1"]
[null,"Within Hearing or Visual Distance: The individual has or may need a formal behavior plan, legal order, or mental health guidelines that require supervision of the individual to be within hearing or visual distance while in the community.  *\n\n","Behavior5","BehavComm2"]
[null,"Within Hearing and Visual Distance: The individual has or may need a formal behavior plan, legal order, or mental health guidelines that require supervision of the individual to be within hearing and visual distance while in the community.  *\n\n","Behavior5","BehavComm3"]
[null,"One-on-One:  The individual has or may need a formal behavior plan, has a legal order or mental health \nguidelines that require 1:1 supervision in the community.  A caregiver must maintain an exclusive \nfocus on the individual while in the community.  * \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of caregivers' \nschedule and duties are required.\n","Behavior5","BehavComm4"]
[null,"Two-Person Assist: The individual has or needs a formal behavior plan, has a legal order or mental health \nguidelines that require 2:1 exclusive focus on the individual while in the community.  ** \nSee nighttime section for hours between 10:00 P.M. and 5:00 A.M. Documentation of \ncaregivers' schedule and duties are required.\n","Behavior5","BehavComm5"]
[null,"If 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 and if marked with ** and the individual 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."]

{"sheet":"Foster Care Budget Summary","index":6,"n_rows":25,"n_cols":24,"rows_kept":25,"merged":[[0,1,0,2],[1,1,1,2],[1,4,1,5],[2,1,2,2],[2,4,2,5],[3,1,3,2],[3,4,3,5],[4,0,4,2],[4,4,4,5],[5,0,5,2],[5,4,5,5],[6,0,6,2],[6,4,6,5],[7,0,7,2],[7,4,7,5],[8,0,8,2],[8,4,8,5],[9,0,9,2],[9,4,9,5],[10,0,10,2],[10,4,10,5],[11,4,11,5],[14,0,14,5],[15,0,15,5],[23,0,23,2],[24,0,24,5]]}
[null,"Foster Care Budget Summary - ",null,"CHILD","SNAP Version:",22]
["Name of Individual",{"$f":"IF('Client Demographics'!D3=\"\",\"\",'Client Demographics'!D3)","v":""},null,"Date of Birth",{"$f":"IF('Client Demographics'!L3=\"\",\"\",'Client Demographics'!L3)","v":""},{"$nulls":18},"No"]
["Prime #",{"$f":"IF('Client Demographics'!D4=\"\",\"\",'Client Demographics'!D4)","v":""},null,"Age",{"$f":"IF('Client Demographics'!O3=\"\",\"\",'Client Demographics'!O3)","v":""},{"$nulls":18},"No"]
["Date of Assessment",{"$f":"IF(AsmtDate=\"\",\"\",AsmtDate)","v":""},null,"Assessed Rate","2:1 Review?",{"$nulls":18},"No"]
["Foster Care Initial Support Rate",null,null,{"$f":"IF(E2=\"\",0,IF(DATEDIF(E2,AsmtDate,\"Y\")>=18,\" - \",BaseRate))","v":0},"N/A",{"$nulls":18},"No"]
["ADL Supports",{"$nulls":3},{"$f":"'Raw Scoring'!B15","v":"No"},{"$nulls":18},"No"]
["Behavior Supports",{"$nulls":3},{"$f":"'Raw Scoring'!Q8","v":"No"},{"$nulls":18},"No"]
["Medical Supports",{"$nulls":3},{"$f":"'Raw Scoring'!L19","v":"No"},{"$nulls":18},"No"]
["Nighttime Supports",{"$nulls":3},{"$f":"'Raw Scoring'!G5","v":"No"},{"$nulls":18},"No"]
[{"$nulls":23},"No"]
["Total Foster Care Service Rate Per Assessment",null,null,{"$f":"IF(ISNUMBER(E11),E11,0)","v":0},{"$f":"IF(ClientAgeWithInfantFracs<6,CappedRate0to5,IF(ClientAgeWithInfantFracs<10,CappedRate6to9,IF(ClientAgeWithInfantFracs<18,CappedRate10to17,IF(ClientAgeWithInfantFracs<99,CappedRateError,0))))","v":0},{"$nulls":14},"No"]
[{"$nulls":3},"Approved Rate ",{"$nulls":19},"No"]
[{"$nulls":23},"No"]
[]
["Assessor: Provide a copy of this Foster Care Support Needs Assessment Profile to the CDDP services coordinator."]
["Service coordinator: Provide a copy of the Foster Care Budget Summary to the foster care provider."]
{"$rows_empty":7}
["For the \"Provider General Information\" sheet, see:"]
["http://www.oregon.gov/DHS/SENIORS-DISABILITIES/DD/PROVIDERS-PARTNERS/Pages/provider-resources.aspx"]

{"sheet":"Host Home Budget Summary","index":7,"n_rows":22,"n_cols":24,"rows_kept":22,"hidden":true,"merged":[[0,0,0,5],[1,1,1,2],[1,4,1,5],[2,1,2,2],[2,4,2,5],[4,0,4,1],[6,0,6,5],[7,1,7,2],[9,0,10,0],[9,1,10,5],[12,1,12,2],[14,1,14,2],[16,0,16,5],[18,1,18,5],[19,1,19,2],[21,0,21,5]]}
["Host Home Budget Summary"]
["Name of Individual",{"$f":"IF('Client Demographics'!D3=\"\",\"\",'Client Demographics'!D3)","v":""},null,"Date of Birth",{"$f":"IF('Client Demographics'!L3=\"\",\"\",'Client Demographics'!L3)","v":""}]
["Date of Assessment",{"$f":"IF('Client Demographics'!O6=\"\",\"\",'Client Demographics'!O6)","v":""},null,"Age",{"$f":"IF('Client Demographics'!O3=\"\",\"\",'Client Demographics'!O3)","v":""}]
[]
[{"$nulls":3},"Approved Rate",{"$f":"HHRawScoring!F36","v":{"v":2153,"d":"$2,153.00"}}]
[]
["My signature verifies I have completed the Support Needs Assessment Profile using all available information\nobtained through observation, interview and the individual's records. The assessment accurately reflects the individual's\nsupport needs."]
["Completed by:",{"$f":"IF('Client Demographics'!E11=\"\",\"\",'Client Demographics'!E11)","v":""},null,"Signature:__________________________",null,"Date:____________"]
[]
["Comments: "]
[]
[]
["Review Date:",null,null,{"$f":"IF(B13=\"\",\"Ongoing\",\"\")","v":"Ongoing"}]
[]
["Approved by:",null,null,"Signature:__________________________",null,"Date:____________",{"$nulls":17},"No"]
[null,"Name of County/ Regional/ SPD Staff",{"$nulls":21},"No"]
["This signature shows that the County/ Regional/ SPD Staff has reviewed the support needs and approved rate for this individual in a Host Home site.  If the Approved Rate changes, a new budget summary must be completed and signed by the County/ Regional/ SPD Staff.  "]
[]
["Host Home Agency Name:"]
["Approved by:",null,null,"Signature:__________________________",null,"Date:____________"]
[null,"Name of Host Home Agency Staff"]
["This signature shows that the agency has reviewed the support needs and approved rate for this individual in a Host Home site.  If the Approved Rate changes, a new budget summary must be completed and signed by the Agency.  "]

{"sheet":"Children Rate Information","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Support Needs Summary","index":9,"n_rows":149,"n_cols":4,"rows_kept":149}
["SUPPORT NEEDS SUMMARY"]
[]
["ADLs","Support Needs Category"]
[null,{"$f":"ADLs!A2","v":"AMBULATION / MOBILITY IN THE HOME"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent or Age Appropriate Supports Provided","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A14","v":"AMBULATION / MOBILITY IN THE 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!A26","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!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!A52","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!A64","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!A77","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!A90","v":"MENSES"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"ADLs!A102","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!A114","v":"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!A125","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!A136","v":"SHAVING"}]
[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'!A2","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'!A13","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'!A24","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'!A35","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'!A46","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'!A71","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'!A83","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'!A96","v":"COMPLEX HEALTH MANAGEMENT SUPPORTS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Independent","No","None"]
["Equipment"]
[null,"Cane",null,"Notes"]
[null,"Leg Braces",null,{"$f":"IF('Medical Needs'!A168 = \"\",\"\", 'Medical Needs'!A168)","v":""}]
[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,"Nebulizers"]
[null,"C-PAP"]
[null,"Oxygen"]
[null,"Ventilator"]
[null,"Pulse Oxymeter"]
[null,"Heart Monitor"]
[null,"Suctioning Equipment"]
[null,"Vegal Stimulator"]
[null,"Diabetic Insulin Pump"]
[null,"Bacoflem Pump"]
[null,"Prosthetics"]
[]
["Nighttime Needs","Support Needs Category"]
[null,{"$f":"'Nighttime Needs'!A2","v":"NIGHTTIME NEEDS - MEDICAL SUPPORTS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","No","None"]
[null,"Support Needs Category","No","None"]
[null,{"$f":"'Nighttime Needs'!A18","v":"NIGHTTIME NEEDS - BEHAVIOR SUPPORTS"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","No","None"]
["Behavior Needs","Support Needs Category"]
[null,{"$f":"'Behavior Needs'!A2","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":"'Behavior Needs'!A15","v":"BEHAVIORAL SUPPORTS - PLANS - HOME AND COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Behavior 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":"'Behavior Needs'!A43","v":"BEHAVIORAL SUPPORTS - SUPERVISION - HOME - ONE ON ONE"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","No","None"]
[null,"Support Needs Category"]
[null,{"$f":"'Behavior Needs'!A67","v":"BEHAVIORAL SUPPORTS - SUPERVISION - COMMUNITY"}]
[null,"Support Need","2:1 Review?","Documentation Needed"]
[null,"Not Applicable","No","None"]

{"sheet":"MFCU Use Only","index":10,"n_rows":23,"n_cols":2,"rows_kept":23,"hidden":true,"merged":[[0,0,0,2],[2,0,2,1]]}
["Medically Fragile Children Served in Foster Care"]
[]
["Instructions"]
["Complete Support Needs Assessment Profile normally with"]
["the exception of Consultant Hours. "]
["The consultant section in the Budget Summary should be left blank and filled in below."]
[]
[]
["Enter number of non-licensed staff hours authorized per month.",0]
["Enter hourly rate for non-licensed staff.",0]
[]
["Enter number of RN Staff Hours authorized per month.",0]
["Enter hourly rate for RN staff.",0]
[]
["Enter other consultant hours authorized per month.",0]
["Enter hourly rate for Other Consultants",0]
[]
[]
["Final Adjusted Foster Care Rate",{"$f":"'Raw Scoring'!K41","v":{"$error":"#N/A"}}]
[]
[null,"The Adjusted Foster Care Rate replaces the authorized rate on the Budget Summary document."]
[null,"The Foster Care provider will be expected to cover and pay 100% of all non-licensed staff time."]
[null,"RN hours will continue to be paid by submitting claims to the MMIS."]

{"sheet":"Raw Scoring","index":11,"n_rows":86,"n_cols":25,"rows_kept":86,"hidden":true,"merged":[[20,14,20,15],[33,7,33,8],[33,9,33,10],[36,1,36,3]]}
[null,"From Assessment","Real Scoring","Exception?","Hours",null,"From Assessment","Real Scoring","Exception?","Hours",null,"From Assessment","Real Scoring","Exception?","Hours",null,"From Assessment","Real Scoring","Exception?","Hours","DPAdjustment","Exception?","HostHomeConsideration#","HostHome","HHResult"]
["ADL1",0,{"$f":"(IF(B2=5,4,B2))","v":0},{"$f":"IF(B2=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(C2,'New Scoring'!B2:H7,5),IF($C$36<10,VLOOKUP(C2,'New Scoring'!B2:H7,7),VLOOKUP(C2,'New Scoring'!B2:H7,2)))","v":0},"Nighttime1",0,{"$f":"(IF(G2=5,4,G2))","v":0},{"$f":"IF(G2=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(H2,'New Scoring'!B74:H79,5),IF($C$36<10,VLOOKUP(H2,'New Scoring'!B74:H79,7),VLOOKUP(H2,'New Scoring'!B74:H79,2)))","v":0},"Medical1",0,{"$f":"(IF(L2=5,4,L2))","v":0},{"$f":"IF(L2=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(M2,'New Scoring'!B86:H91,5),IF($C$36<10,VLOOKUP(M2,'New Scoring'!B86:H91,7),VLOOKUP(M2,'New Scoring'!B86:H91,2)))","v":0},"Behavior1",0,{"$f":"(IF(R4>1,0,Q2))","v":0},{"$f":"IF(Q2=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(R2,'New Scoring'!B182:H187,5),IF($C$36<10,VLOOKUP(R2,'New Scoring'!B182:H187,7),VLOOKUP(R2,'New Scoring'!B182:H187,2)))","v":0},0,{"$f":"IF(U2=0,\"No\",\"Yes – Approval Required (see eXPRS)\")","v":"No"},1,"No",{"$f":"IF(COUNTIF(X2:X36,\"Yes\")>0,\"Yes\",\"No\")","v":"No"}]
["ADL2",0,{"$f":"(IF(R6 > 2, 0, IF(B3=5,4,B3)))","v":0},{"$f":"IF(B3=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(C3,'New Scoring'!B8:H13,5),IF($C$36<10,VLOOKUP(C3,'New Scoring'!B8:H13,7),VLOOKUP(C3,'New Scoring'!B8:H13,2)))","v":0},"Nighttime2",0,{"$f":"(IF(G3=5,4,G3))","v":0},{"$f":"IF(G3=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(H3,'New Scoring'!B80:H85,5),IF($C$36<10,VLOOKUP(H3,'New Scoring'!B80:H85,7),VLOOKUP(H3,'New Scoring'!B80:H85,2)))","v":0},"Medical2",0,{"$f":"(IF(L3=5,4,L3))","v":0},{"$f":"IF(L3=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(M3,'New Scoring'!B92:H97,5),IF($C$36<10,VLOOKUP(M3,'New Scoring'!B92:H97,7),VLOOKUP(M3,'New Scoring'!B92:H97,2)))","v":0},"Behavior2",0,{"$f":"(IF(Q3=5,4,Q3))","v":0},{"$f":"IF(Q3=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(R3,'New Scoring'!B188:H193,5),IF($C$36<10,VLOOKUP(R3,'New Scoring'!B188:H193,7),VLOOKUP(R3,'New Scoring'!B188:H193,2)))","v":0},null,null,2,"No",{"$f":"COUNTIF(X2:X36,\"Yes\")","v":0}]
["ADL3",0,{"$f":"(IF(B4=5,4,B4))","v":0},"No",{"$f":"IF($C$36<6,VLOOKUP(C4,'New Scoring'!B14:H19,5),IF($C$36<10,VLOOKUP(C4,'New Scoring'!B14:H19,7),VLOOKUP(C4,'New Scoring'!H14:BB19,2)))","v":0},"Totals",{"$f":"G2+G3","v":0},{"$f":"MAX(H2:H3)","v":0},{"$f":"COUNTIF(I2:I3,\"Yes\")","v":0},{"$f":"SUM(J2:J3)","v":0},"Medical3",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M4,'New Scoring'!B98:H103,5),IF($C$36<10,VLOOKUP(M4,'New Scoring'!B98:H103,7),VLOOKUP(M4,'New Scoring'!B98:H103,2)))","v":0},"Behavior3",0,{"$f":"IF(V5 = 4,2,IF(V5>4,3,IF(Q4=5,4,Q4)))","v":0},{"$f":"IF(Q4=7,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(R4,'New Scoring'!B194:H199,5),IF($C$36<10,VLOOKUP(R4,'New Scoring'!B194:H199,7),VLOOKUP(R4,'New Scoring'!B194:H199,2)))","v":0},"BehaviorDupChecks",{"$f":"Q6+B3","v":0},3,"No"]
["ADL4",0,{"$f":"(IF(B5=5,4,B5))","v":0},"No",{"$f":"IF($C$36<6,VLOOKUP(C5,'New Scoring'!B20:H25,5),IF($C$36<10,VLOOKUP(C5,'New Scoring'!B20:H25,7),VLOOKUP(C5,'New Scoring'!B20:H25,2)))","v":0},"Exception?",{"$f":"IF(I4>0,\"Yes – Approval Required (see eXPRS)\",\"No\")","v":"No"},{"$nulls":3},"Medical4",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M5,'New Scoring'!B104:H109,5),IF($C$36<10,VLOOKUP(M5,'New Scoring'!B104:H109,7),VLOOKUP(M5,'New Scoring'!B104:H109,2)))","v":0},"Behavior4",0,{"$f":"(IF(Q5=7,6,Q5))","v":0},{"$f":"IF(Q5=7,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(R5,'New Scoring'!B200:H207,5),IF($C$36<10,VLOOKUP(R5,'New Scoring'!B200:H207,7),VLOOKUP(R5,'New Scoring'!B200:H207,2)))","v":0},null,{"$f":"Q2+Q4","v":0},4,"No"]
["ADL5",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(C6,'New Scoring'!B26:H31,5),IF($C$36<10,VLOOKUP(C6,'New Scoring'!B26:H31,7),VLOOKUP(C6,'New Scoring'!B26:H31,2)))","v":0},{"$nulls":5},"Medical5",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M6,'New Scoring'!B110:H115,5),IF($C$36<10,VLOOKUP(M6,'New Scoring'!B110:H115,7),VLOOKUP(M6,'New Scoring'!B110:H115,2)))","v":0},"Behavior5",0,{"$f":"IF(V4>6,IF(V4 = 7,2,4),IF(Q6=5,4,Q6))","v":0},{"$f":"IF(Q6=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(R6,'New Scoring'!B208:H213,5),IF($C$36<10,VLOOKUP(R6,'New Scoring'!B208:H213,7),VLOOKUP(R6,'New Scoring'!B208:H213,2)))","v":0},null,null,5,"No"]
["ADL6",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(C7,'New Scoring'!B32:H37,5),IF($C$36<10,VLOOKUP(C7,'New Scoring'!B32:H37,7),VLOOKUP(C7,'New Scoring'!B32:H37,2)))","v":0},{"$nulls":5},"Medical6",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M7,'New Scoring'!B116:H121,5),IF($C$36<10,VLOOKUP(M7,'New Scoring'!B116:H121,7),VLOOKUP(M7,'New Scoring'!B116:H121,2)))","v":0},"Totals",{"$f":"SUM(Q2:Q6)","v":0},{"$f":"SUM(R2:R6)","v":0},{"$f":"COUNTIF(S2:S6,\"Yes\")","v":0},{"$f":"SUM(T2:T6)","v":0},null,null,6,"No"]
["ADL7",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(C8,'New Scoring'!B38:H43,5),IF($C$36<10,VLOOKUP(C8,'New Scoring'!B38:H43,7),VLOOKUP(C8,'New Scoring'!B38:H43,2)))","v":0},{"$nulls":5},"Medical7",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M8,'New Scoring'!B122:H127,5),IF($C$36<10,VLOOKUP(M8,'New Scoring'!B122:H127,7),VLOOKUP(M8,'New Scoring'!B122:H127,2)))","v":0},"Exception?",{"$f":"IF(S7>0,\"Yes – Approval Required (see eXPRS)\",\"No\")","v":"No"},{"$nulls":5},7,"No"]
["ADL8",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(C9,'New Scoring'!B44:H49,5),IF($C$36<10,VLOOKUP(C9,'New Scoring'!B44:H49,7),VLOOKUP(C9,'New Scoring'!B44:H49,2)))","v":0},{"$nulls":5},"Medical8",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M9,'New Scoring'!B128:H133,5),IF($C$36<10,VLOOKUP(M9,'New Scoring'!B128:H133,7),VLOOKUP(M9,'New Scoring'!B128:H133,2)))","v":0},{"$nulls":7},8,"No"]
["ADL9",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(C10,'New Scoring'!B50:H55,5),IF($C$36<10,VLOOKUP(C10,'New Scoring'!B50:H55,7),VLOOKUP(C10,'New Scoring'!B50:H55,2)))","v":0},{"$nulls":5},"Medical9",0,0,{"$f":"IF(Q11=5,\"Yes\",\"No\")","v":"No"},{"$f":"IF($C$36<6,VLOOKUP(M10,'New Scoring'!B134:H139,5),IF($C$36<10,VLOOKUP(M10,'New Scoring'!B134:H139,7),VLOOKUP(M10,'New Scoring'!B134:H139,2)))","v":0},{"$nulls":7},9,"No"]
["ADL10",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(C11,'New Scoring'!B56:H61,5),IF($C$36<10,VLOOKUP(C11,'New Scoring'!B56:H61,7),VLOOKUP(C11,'New Scoring'!B56:H61,2)))","v":0},{"$nulls":5},"Medical10",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M11,'New Scoring'!B140:H145,5),IF($C$36<10,VLOOKUP(M11,'New Scoring'!B140:H145,7),VLOOKUP(M11,'New Scoring'!B140:H145,2)))","v":0},"2 person",0,{"$nulls":5},10,"No"]
["ADL11",0,{"$f":"(IF(B12=5,4,B12))","v":0},"No",{"$f":"IF($C$36<6,VLOOKUP(C12,'New Scoring'!B62:H67,5),IF($C$36<10,VLOOKUP(C12,'New Scoring'!B62:H67,7),VLOOKUP(C12,'New Scoring'!B62:H67,2)))","v":0},{"$nulls":5},"Medical11",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M12,'New Scoring'!B146:H151,5),IF($C$36<10,VLOOKUP(M12,'New Scoring'!B146:H151,7),VLOOKUP(M12,'New Scoring'!B146:H151,2)))","v":0},{"$nulls":7},11,"No"]
["ADL12",0,{"$f":"(IF(B13=5,4,B13))","v":0},"No",{"$f":"IF($C$36<6,VLOOKUP(C13,'New Scoring'!B68:H73,5),IF($C$36<10,VLOOKUP(C13,'New Scoring'!B68:H73,7),VLOOKUP(C13,'New Scoring'!B68:H73,2)))","v":0},{"$nulls":5},"Medical12",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M13,'New Scoring'!B152:H157,5),IF($C$36<10,VLOOKUP(M13,'New Scoring'!B152:H157,7),VLOOKUP(M13,'New Scoring'!B152:H157,2)))","v":0},{"$nulls":7},12,"No"]
["Totals",{"$f":"SUM(B2:B13)","v":0},{"$f":"SUM(C2:C13)","v":0},{"$f":"COUNTIF(D2:D13,\"Yes\")","v":0},{"$f":"SUM(E2:E13)","v":0},{"$nulls":5},"Medical13",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M14,'New Scoring'!B158:H163,5),IF($C$36<10,VLOOKUP(M14,'New Scoring'!B158:H163,7),VLOOKUP(M14,'New Scoring'!B158:H163,2)))","v":0},{"$nulls":7},13,"No"]
["Exception?",{"$f":"IF(D14>0,\"Yes – Approval Required (see eXPRS)\",\"No\")","v":"No"},{"$nulls":8},"Medical14",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M15,'New Scoring'!B164:H169,5),IF($C$36<10,VLOOKUP(M15,'New Scoring'!B164:H169,7),VLOOKUP(M15,'New Scoring'!B164:H169,2)))","v":0},{"$nulls":7},14,"No"]
[{"$nulls":10},"Medical15",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M16,'New Scoring'!B170:H175,5),IF($C$36<10,VLOOKUP(M16,'New Scoring'!B170:H175,7),VLOOKUP(M16,'New Scoring'!B170:H175,2)))","v":0},{"$nulls":7},15,"No"]
[{"$nulls":10},"Medical16",0,0,"No",{"$f":"IF($C$36<6,VLOOKUP(M17,'New Scoring'!B176:H181,5),IF($C$36<10,VLOOKUP(M17,'New Scoring'!B176:H181,7),VLOOKUP(M17,'New Scoring'!B176:H181,2)))","v":0},{"$nulls":7},16,"No"]
[null,"ADL","Nighttime","Medical","Behavior","Total","DayTime Total",{"$nulls":3},"Totals",{"$f":"SUM(L2:L17)","v":0},{"$f":"SUM(M2:M17)","v":0},{"$f":"COUNTIF(N2:N17,\"Yes\")","v":0},{"$f":"SUM(O2:O17)","v":0},{"$nulls":7},17,"No"]
["Hours",{"$f":"E14","v":{"v":0,"d":"0.00"}},{"$f":"J4","v":{"v":0,"d":"0.00"}},{"$f":"O18","v":{"v":0,"d":"0.00"}},{"$f":"T7","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B19:E19)","v":{"v":0,"d":"0.00"}},{"$f":"B19+D19+E19","v":{"v":0,"d":"0.00"}},{"$nulls":3},"Exception?",{"$f":"IF(N18>0,\"Yes – Approval Required (see eXPRS)\",\"No\")","v":"No"},{"$nulls":10},18,"No"]
["Hours Adjusted",{"$f":"IF(B19>6,6,B19)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C19>7,7,C19)","v":{"v":0,"d":"0.00"}},{"$f":"IF(D19>12,12,D19)","v":{"v":0,"d":"0.00"}},{"$f":"IF(E19>12,12,E19)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B20:E20)","v":{"v":0,"d":"0.00"}},{"$f":"B20+D20+E20","v":{"v":0,"d":"0.00"}},{"$nulls":15},19,"No"]
["Hours Adjusted 2",{"$f":"IF($G$20>17,(B20/$G$20)*17,B20)","v":{"v":0,"d":"0.00"}},{"$f":"C20","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$20>17,(D20/$G$20)*17,D20)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$20>17,(E20/$G$20)*17,E20)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B21:E21)","v":{"v":0,"d":"0.00"}},{"$f":"B21+D21+E21","v":{"v":0,"d":"0.00"}},{"$nulls":7},"Temporary Increases",null,"Restored Rate",{"$nulls":5},20,"No"]
["Hours Adjusted 3",{"$f":"IF($F$21>24,(B21/$F$21)*24,B21)","v":{"v":0,"d":"0.00"}},{"$f":"IF($F$21>24,(C21/$F$21)*24,C21)","v":{"v":0,"d":"0.00"}},{"$f":"IF($F$21>24,(D21/$F$21)*24,D21)","v":{"v":0,"d":"0.00"}},{"$f":"IF($F$21>24,(E21/$F$21)*24,E21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B22:E22)","v":{"v":0,"d":"0.00"}},{"$f":"B22+D22+E22","v":{"v":0,"d":"0.00"}},{"$nulls":3},"Effectivity Date:","(Original)","2015-12-08","2019-10-01","2020-07-01","2021-07-01","2023-07-01","Effective Rate",{"$nulls":4},21,"No"]
["Hours Adjusted 4",{"$f":"IF($F$22>1.55,($F$22-1.55)/($F$22)*B22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($F$22>1.55,($F$22-1.55)/($F$22)*C22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($F$22>1.55,($F$22-1.55)/($F$22)*D22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($F$22>1.55,($F$22-1.55)/($F$22)*E22,0)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B23:E23)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"% Rate Increase:","--",{"v":0.04,"d":"4.0%"},{"v":0.04,"d":"4.0%"},{"v":0.05,"d":"5.0%"},{"v":0.032,"d":"3.2%"},{"$f":"\"3.2% (only)*\"","v":"3.2% (only)*"},{"$f":"HLOOKUP(AsmtDate,$L$22:$Q23,ROWS($L$22:$Q23),TRUE)","v":{"$error":"#N/A"}},{"$nulls":4},22,"No"]
["Kid Rate",{"$f":"HourlyRate","v":{"$error":"#N/A"}},{"$f":"HourlyRate","v":{"$error":"#N/A"}},{"$f":"HourlyRate","v":{"$error":"#N/A"}},{"$f":"HourlyRate","v":{"$error":"#N/A"}},{"$f":"HourlyRate","v":{"$error":"#N/A"}},{"$nulls":4},"Child Hourly Rate:",{"v":9.5,"d":"$9.50"},{"$f":"L24*(1+$M$23)","v":{"v":9.88,"d":"$9.88"}},{"$f":"ROUNDUP(M24*(1+N$23),2)","v":{"v":10.28,"d":"$10.28"}},{"$f":"ROUNDUP(N24*(1+O$23),2)","v":{"v":10.799999999999999,"d":"$10.80"}},{"$f":"ROUNDUP(O24*(1+P$23),2)","v":{"v":11.15,"d":"$11.15"}},{"$f":"ROUNDUP(N24*(1+P$23),2)","v":{"v":10.61,"d":"$10.61"}},{"$f":"HLOOKUP(AsmtDate,$L$22:$Q24,ROWS($L$22:$Q24),TRUE)","v":{"$error":"#N/A"}},{"$nulls":4},23,"No"]
["Days",30.41,30.41,30.41,30.41,30.41,{"$nulls":4},"Child Base Rate:",{"v":539,"d":"$539.00"},{"$f":"L25*(1+$M$23)","v":{"v":560.5600000000001,"d":"$560.56"}},{"$f":"ROUNDUP(M25*(1+N$23),0)","v":{"v":583,"d":"$583.00"}},{"$f":"ROUNDUP(N25*(1+O$23),0)","v":{"v":613,"d":"$613.00"}},{"$f":"ROUNDUP(O25*(1+P$23),0)","v":{"v":633,"d":"$633.00"}},{"$f":"ROUNDUP(N25*(1+P$23),0)","v":{"v":602,"d":"$602.00"}},{"$f":"HLOOKUP(AsmtDate,$L$22:$Q25,ROWS($L$22:$Q25),TRUE)","v":{"$error":"#N/A"}},{"$nulls":4},24,"No"]
["Total Kid",{"$f":"B23*B24*B25","v":{"$error":"#N/A"}},{"$f":"C23*C24*C25","v":{"$error":"#N/A"}},{"$f":"D23*D24*D25","v":{"$error":"#N/A"}},{"$f":"E23*E24*E25","v":{"$error":"#N/A"}},{"$f":"F23*F24*F25","v":{"$error":"#N/A"}},null,"Age","Uncapped Rate","Capped Rate","Orig Cap",null,{"$f":"TEXT(M23,\"0%\")&\" Adj. Cap\"","v":"4% Adj. Cap"},{"$f":"TEXT(N23,\"0%\")&\" Adj. Cap\"","v":"4% Adj. Cap"},{"$f":"TEXT(O23,\"0%\")&\" Adj. Cap\"","v":"5% Adj. Cap"},{"$f":"TEXT(P23,\"0.0%\")&\" Adj. Cap\"","v":"3.2% Adj. Cap"},{"$f":"TEXT(Q23,\"0.0%\")&\" Adj. Cap\"","v":"3.2% (only)* Adj. Cap"},{"$f":"HLOOKUP(AsmtDate,$L$22:$Q26,ROWS($L$22:$Q26),TRUE)","v":{"$error":"#N/A"}},{"$nulls":4},25,"No"]
[{"$nulls":7},"0-5",{"$f":"$F$26+BaseRate","v":{"$error":"#N/A"}},{"$f":"IF(I27<=R27,I27,R27)","v":{"$error":"#N/A"}},{"v":3000,"d":"$3,000.00"},null,{"$f":"K27*(1+M$23)","v":{"v":3120,"d":"$3,120.00"}},{"$f":"ROUNDUP(M27*(1+N$23),0)","v":{"v":3245,"d":"$3,245.00"}},{"v":3408,"d":"$3,408.00"},{"v":3518,"d":"$3,518.00"},{"$f":"ROUNDUP(N27*(1+P$23),0)","v":{"v":3349,"d":"$3,349.00"}},{"$f":"HLOOKUP(AsmtDate,$L$22:$Q27,ROWS($L$22:$Q27),TRUE)","v":{"$error":"#N/A"}},{"$nulls":4},26,"No"]
[{"$nulls":7},"6-9",{"$f":"$F$26+BaseRate","v":{"$error":"#N/A"}},{"$f":"IF(I28<=R28,I28,R28)","v":{"$error":"#N/A"}},{"v":3500,"d":"$3,500.00"},null,{"$f":"K28*(1+M$23)","v":{"v":3640,"d":"$3,640.00"}},{"v":3786,"d":"$3,786.00"},{"v":3976,"d":"$3,976.00"},{"v":4104,"d":"$4,104.00"},{"$f":"ROUNDUP(N28*(1+P$23),0)","v":{"v":3908,"d":"$3,908.00"}},{"$f":"HLOOKUP(AsmtDate,$L$22:$Q28,ROWS($L$22:$Q28),TRUE)","v":{"$error":"#N/A"}},{"$nulls":4},27,"No"]
[{"$nulls":7},"10-17",{"$f":"$F$26+BaseRate","v":{"$error":"#N/A"}},{"$f":"IF(I29<=R29,I29,R29)","v":{"$error":"#N/A"}},{"v":7285,"d":"$7,285.00"},null,{"$f":"K29*(1+M$23)","v":{"v":7576.400000000001,"d":"$7,576.40"}},{"v":7880,"d":"$7,880.00"},{"v":8274,"d":"$8,274.00"},{"v":8539,"d":"$8,539.00"},{"$f":"ROUNDUP(N29*(1+P$23),0)","v":{"v":8133,"d":"$8,133.00"}},{"$f":"HLOOKUP(AsmtDate,$L$22:$Q29,ROWS($L$22:$Q29),TRUE)","v":{"$error":"#N/A"}},{"$nulls":4},28,"No"]
[{"$nulls":7},"18+","Check Birthdate,\nif over 18 use adult SNAP!","Check Birthdate,\nif over 18 use adult SNAP!",{"$nulls":12},29,"No"]
[{"$nulls":8},"Note: in an empty assessment (hours = 0) these Rate columns will show the base rate only!",{"$nulls":7},"*The restored rate ia a 3.2% (only) increase relative to the 10/1/2019 rate",{"$nulls":5},30,"No"]
[{"$nulls":22},31,"No"]
[{"$nulls":22},32,"No"]
[{"$nulls":7},"Kid's Consultant Adjustment",null,"MFCU Adjustment",{"$nulls":12},33,"No"]
["County LookUp","Age Calc","Age LookUp",{"$nulls":4},"Consultants",null,"Hours Authorized via SNAP",{"$f":"ROUND('Foster Care Budget Summary'!D11/F24,0)","v":{"$error":"#N/A"}},{"$nulls":11},34,"No"]
["BAKER",{"$f":"IF(OR(ClientDOB=\"\",AsmtDate=\"\",ClientDOB>=AsmtDate),\n       \"\",\n       IF(DATEDIF(ClientDOB,AsmtDate,\"Y\")=0,\n            DATEDIF(ClientDOB,AsmtDate,\"YM\") & \" Month\" & IF(DATEDIF(ClientDOB,AsmtDate,\"YM\")=1,\"\",\"s\"),\n            IF(DATEDIF(ClientDOB,AsmtDate,\"Y\")=1,\n                 DATEDIF(ClientDOB,AsmtDate,\"M\") & \" Months\",\n                 DATEDIF(ClientDOB,AsmtDate,\"Y\"))))","v":""},{"$f":"IF(OR(ClientDOB=\"\",AND(ISNUMBER(ClientAgeCalc),ClientAgeCalc>=18)),\n       \"\",\n       IF(DATEDIF(ClientDOB,AsmtDate,\"Y\")=0,\n            ROUND(DATEDIF(ClientDOB,AsmtDate,\"YM\")/12, 1),\n            IF(DATEDIF(ClientDOB,AsmtDate,\"Y\")=1,\n                ROUND(DATEDIF(ClientDOB,AsmtDate,\"M\")/12, 1),\n                DATEDIF(ClientDOB,AsmtDate,\"Y\"))))","v":""},{"$nulls":4},"Consultant 1",{"$f":"'Foster Care Budget Summary'!#REF!","v":{"$error":"#REF!"}},"Hours Authorized via MFCU (Assume 80% of authorized hours will be worked)",{"$f":"('MFCU Use Only'!B9)+('MFCU Use Only'!B12*0.8)","v":0},{"$nulls":11},35,"No"]
["BENTON",{"$f":"IF(AND(ISNUMBER(ClientAgeCalc),ClientAgeCalc>=18),\"If 18 or older, must use Adult tool.\",ClientAgeCalc)","v":""},{"$nulls":5},"Consultant 2",{"$f":"'Foster Care Budget Summary'!#REF!","v":{"$error":"#REF!"}},"Remaining Hours",{"$f":"K35-K36","v":{"$error":"#N/A"}}]
["CLACKAMAS",{"$nulls":6},"Consultant 3",{"$f":"'Foster Care Budget Summary'!#REF!","v":{"$error":"#REF!"}},"Personal Care",{"$f":"'MFCU Use Only'!B9*'MFCU Use Only'!B10","v":0}]
["CLATSOP",{"$nulls":6},"Total Consultants",{"$f":"SUM(I36:I38)","v":{"$error":"#REF!"}},"RN",{"$f":"'MFCU Use Only'!B12*'MFCU Use Only'!B13*0.8","v":0}]
["COLUMBIA",{"$nulls":6},"Times 90%",{"$f":"I39*0.9","v":{"$error":"#REF!"}},"Other Consultants",{"$f":"'MFCU Use Only'!B15*'MFCU Use Only'!B16","v":0}]
["COOS",{"$nulls":8},"Total Rate",{"$f":"ROUND((K37*F24)+K38+K40,0)","v":{"$error":"#N/A"}}]
["CROOK"]
["CURRY"]
["DESCHUTES"]
["DOUGLAS"]
["GILLIAM"]
["GRANT"]
["HARNEY"]
["HOOD RIVER"]
["JACKSON"]
["JEFFERSON"]
["JOSEPHINE"]
["KLAMATH"]
["LAKE"]
["LANE"]
["LINCOLN"]
["LINN"]
["MALHEUR"]
["MARION"]
["MORROW"]
["MULTNOMAH"]
["POLK"]
["SHERMAN"]
["TILLAMOOK"]
["UMATILLA"]
["UNION"]
["WALLOWA"]
["WASCO"]
["WASHINGTON"]
["WHEELER"]
["YAMHILL"]
[]
["Relationships"]
["Legal Guardian"]
["Parent"]
["Foster Care Provider"]
["Foster Care Provider Staff"]
["Vocational Provider Staff"]
["Vocational Provider Manager"]
["Behavior Specialist"]
["Nursing Professional"]
["Services Coordinator"]
["Regional MCL/Crisis Staff"]
["Child Welfare Staff"]
["SPD Kids’ Residential Coordinator"]
["Other"]

{"sheet":"New Scoring","index":12,"n_rows":213,"n_cols":9,"rows_kept":213,"hidden":true}
["Category","Assessment Score ","Corresponding Hours >9","Pricing",null,"Hours 0 to 5","Pricing 0 to 5","Hours 6 to 9","Pricing 6 to 9"]
["ADL1",0,0,{"$f":"ROUND(C2*30.41*9.5,0)","v":0},null,0,{"$f":"ROUND(F2*30.41*9.5,0)","v":0},0,{"$f":"ROUND(H2*30.41*9.5,0)","v":0}]
["ADL1",1,1,{"$f":"ROUND(C3*30.41*9.5,0)","v":289},null,0,0,0,0]
["ADL1",2,1,289,null,0,0,0,0]
["ADL1",3,1,289,null,0,0,0,0]
["ADL1",4,2,578,null,0,0,1,289]
["ADL1",5,2,578,null,0,0,1,289]
["ADL2",0,0,0,null,0,0,0,0]
["ADL2",1,1,289,null,0,0,0,0]
["ADL2",2,1,289,null,0,0,0,0]
["ADL2",3,1,289,null,0,0,0,0]
["ADL2",4,2,578,null,0,0,1,289]
["ADL2",5,2,578,null,0,0,1,289]
["ADL3",0,0,0,null,0,0,0,0]
["ADL3",1,1,289,null,0,0,0,0]
["ADL3",2,1,289,null,0,0,0,0]
["ADL3",3,1,289,null,0,0,0,0]
["ADL3",4,2,578,null,0,0,1,289]
["ADL3",5,2,578,null,0,0,1,289]
["ADL4",0,0,0,null,0,0,0,0]
["ADL4",1,0.5,144,null,0,0,0,0]
["ADL4",2,2,578,null,0,0,1,289]
["ADL4",3,3,867,null,2,578,2,578]
["ADL4",4,3,867,null,2,578,2,578]
["ADL4",5,3,867,null,2,578,2,578]
["ADL5",0,0,0,null,0,0,0,0]
["ADL5",1,0,0,null,0,0,0,0]
["ADL5",2,0,0,null,0,0,0,0]
["ADL5",3,0.5,144,null,0,0,0,0]
["ADL5",4,1,289,null,0,0,1,289]
["ADL5",5,1,289,null,0,0,1,289]
["ADL6",0,0,0,null,0,0,0,0]
["ADL6",1,0,0,null,0,0,0,0]
["ADL6",2,0,0,null,0,0,0,0]
["ADL6",3,0.5,144,null,0,0,0.5,144]
["ADL6",4,2,578,null,0,0,1,289]
["ADL6",5,2,578,null,0,0,1,289]
["ADL7",0,0,0,null,0,0,0,0]
["ADL7",1,0,0,null,0,0,0,0]
["ADL7",2,0,0,null,0,0,0,0]
["ADL7",3,0.5,144,null,0.5,144,0.5,144]
["ADL7",4,2,578,null,1,289,1,289]
["ADL7",5,2,578,null,1,289,1,289]
["ADL8",0,0,0,null,0,0,0,0]
["ADL8",1,0,0,null,0,0,0,0]
["ADL8",2,0,0,null,0,0,0,0]
["ADL8",3,0.25,72,null,0,0,0,0]
["ADL8",4,0.5,144,null,0,0,0,0]
["ADL8",5,0.5,144,null,0,0,0,0]
["ADL9",0,0,0,null,0,0,0,0]
["ADL9",1,0,0,null,0,0,0,0]
["ADL9",2,0.25,72,null,0,0,0,0]
["ADL9",3,0.25,72,null,0,0,0,0]
["ADL9",4,1,289,null,0,0,0.5,144]
["ADL9",5,1,289,null,0,0,0.5,144]
["ADL10",0,0,0,null,0,0,0,0]
["ADL10",1,0,0,null,0,0,0,0]
["ADL10",2,0.25,72,null,0,0,0,0]
["ADL10",3,0.25,72,null,0,0,0,0]
["ADL10",4,0.25,72,null,0,0,0,0]
["ADL10",5,0.25,72,null,0,0,0,0]
["ADL11",0,0,0,null,0,0,0,0]
["ADL11",1,0,0,null,0,0,0,0]
["ADL11",2,0.167,48,null,0,0,0,0]
["ADL11",3,0.667,193,null,0,0,0,0]
["ADL11",4,0.667,193,null,0,0,0,0]
["ADL11",5,0.667,{"$f":"ROUND(C67*30.41*9.5,0)","v":193},null,0,{"$f":"ROUND(F67*30.41*9.5,0)","v":0},0,{"$f":"ROUND(H67*30.41*9.5,0)","v":0}]
["ADL12",0,0,0,null,0,0,0,0]
["ADL12",1,0,0,null,0,0,0,0]
["ADL12",2,0.083,24,null,0,0,0,0]
["ADL12",3,0.333,96,null,0,0,0,0]
["ADL12",4,0.333,96,null,0,0,0,0]
["ADL12",5,0.333,96,null,0,0,0,0]
["Nighttime1",0,0,0,null,0,0,0,0]
["Nighttime1",1,1,289,null,0,0,0,0]
["Nighttime1",2,3,867,null,1,289,1,289]
["Nighttime1",3,6,1733,null,3,867,3,867]
["Nighttime1",4,7,2022,null,4,1156,4,1156]
["Nighttime1",5,7,2022,null,4,1156,4,1156]
["Nighttime2",0,0,0,null,0,0,0,0]
["Nighttime2",1,1,289,null,0,0,0,0]
["Nighttime2",2,3,867,null,1,289,1,289]
["Nighttime2",3,6,1733,null,3,867,3,867]
["Nighttime2",4,7,2022,null,4,1156,4,1156]
["Nighttime2",5,7,2022,null,4,1156,4,1156]
["Medical1",0,0,0,null,0,0,0,0]
["Medical1",1,0,0,null,0,0,0,0]
["Medical1",2,1,289,null,0,0,0,0]
["Medical1",3,1,289,null,0,0,0,0]
["Medical1",4,1,289,null,0,0,0,0]
["Medical1",5,1,289,null,0,0,0,0]
["Medical2",0,0,0,null,0,0,0,0]
["Medical2",1,0,0,null,0,0,0,0]
["Medical2",2,1,289,null,0,0,0,0]
["Medical2",3,1,289,null,0,0,0,0]
["Medical2",4,1,289,null,0,0,0,0]
["Medical2",5,1,289,null,0,0,0,0]
["Medical3",0,0,0,null,0,0,0,0]
["Medical3",1,0,{"$f":"ROUND(C99*30.41*9.5,0)","v":0},null,0,{"$f":"ROUND(F99*30.41*9.5,0)","v":0},0,{"$f":"ROUND(H99*30.41*9.5,0)","v":0}]
["Medical3",2,1.5,433,null,0,0,0,0]
["Medical3",3,1.5,433,null,0,0,0,0]
["Medical3",4,1.5,433,null,0,0,0,0]
["Medical3",5,1.5,433,null,0,0,0,0]
["Medical4",0,0,0,null,0,0,0,0]
["Medical4",1,0,0,null,0,0,0,0]
["Medical4",2,0.05,14,null,0,0,0,0]
["Medical4",3,0.05,14,null,0,0,0,0]
["Medical4",4,0.05,14,null,0,0,0,0]
["Medical4",5,0.05,14,null,0,0,0,0]
["Medical5",0,0,0,null,0,0,0,0]
["Medical5",1,0.5,144,null,0.5,144,0.5,144]
["Medical5",2,1,289,null,1,289,1,289]
["Medical5",3,1,289,null,1,289,1,289]
["Medical5",4,1,289,null,1,289,1,289]
["Medical5",5,1,289,null,1,289,1,289]
["Medical6",0,0,0,null,0,0,0,0]
["Medical6",1,0.5,144,null,0.5,144,0.5,144]
["Medical6",2,1,289,null,1,289,1,289]
["Medical6",3,1,289,null,1,289,1,289]
["Medical6",4,1,289,null,1,289,1,289]
["Medical6",5,1,289,null,1,289,1,289]
["Medical7",0,0,0,null,0,0,0,0]
["Medical7",1,0,0,null,0,0,0,0]
["Medical7",2,0,0,null,0,0,0,0]
["Medical7",3,0.5,144,null,0.5,144,0.5,144]
["Medical7",4,1,289,null,1,289,1,289]
["Medical7",5,1,289,null,1,289,1,289]
["Medical8",0,0,0,null,0,0,0,0]
["Medical8",1,0.25,72,null,0,0,0,0]
["Medical8",2,0.5,144,null,0.25,72,0.25,72]
["Medical8",3,0.5,{"$f":"ROUND(C131*30.41*9.5,0)","v":144},null,0.25,{"$f":"ROUND(F131*30.41*9.5,0)","v":72},0.25,{"$f":"ROUND(H131*30.41*9.5,0)","v":72}]
["Medical8",4,0.5,144,null,0.25,72,0.25,72]
["Medical8",5,0.5,144,null,0.25,72,0.25,72]
["Medical9",0,0,0,null,0,0,0,0]
["Medical9",1,1,289,null,0,0,0,0]
["Medical9",2,2,578,null,1,289,1,289]
["Medical9",3,6,1733,null,6,1733,6,1733]
["Medical9",4,12,3467,null,6,1733,6,1733]
["Medical9",5,12,3467,null,6,1733,6,1733]
["Medical10",0,0,0,null,0,0,0,0]
["Medical10",1,0.035,10,null,0,0,0,0]
["Medical10",2,0.0877,25,null,0,0,0,0]
["Medical10",3,0.0877,25,null,0,0,0,0]
["Medical10",4,0.0877,25,null,0,0,0,0]
["Medical10",5,0.0877,25,null,0,0,0,0]
["Medical11",0,0,0,null,0,0,0,0]
["Medical11",1,0,0,null,0,0,0,0]
["Medical11",2,0,0,null,0,0,0,0]
["Medical11",3,0,0,null,0,0,0,0]
["Medical11",4,0,0,null,0,0,0,0]
["Medical11",5,0,0,null,0,0,0,0]
["Medical12",0,0,0,null,0,0,0,0]
["Medical12",1,0,0,null,0,0,0,0]
["Medical12",2,0,0,null,0,0,0,0]
["Medical12",3,0.1747,50,null,0,0,0,0]
["Medical12",4,0.1747,50,null,0,0,0,0]
["Medical12",5,0.1747,50,null,0,0,0,0]
["Medical13",0,0,0,null,0,0,0,0]
["Medical13",1,0,0,null,0,0,0,0]
["Medical13",2,0.1747,50,null,0,0,0,0]
["Medical13",3,0.1747,50,null,0,0,0,0]
["Medical13",4,0.1747,50,null,0,0,0,0]
["Medical13",5,0.1747,{"$f":"ROUND(C163*30.41*9.5,0)","v":50},null,0,{"$f":"ROUND(F163*30.41*9.5,0)","v":0},0,{"$f":"ROUND(H163*30.41*9.5,0)","v":0}]
["Medical14",0,0,0,null,0,0,0,0]
["Medical14",1,0,0,null,0,0,0,0]
["Medical14",2,0.0877,25,null,0,0,0,0]
["Medical14",3,0.346,100,null,0,0,0,0]
["Medical14",4,0.346,100,null,0,0,0,0]
["Medical14",5,0.346,100,null,0,0,0,0]
["Medical15",0,0,0,null,0,0,0,0]
["Medical15",1,0.0877,25,null,0,0,0,0]
["Medical15",2,0.0877,25,null,0,0,0,0]
["Medical15",3,0.1747,50,null,0,0,0,0]
["Medical15",4,0.1747,50,null,0,0,0,0]
["Medical15",5,0.1747,50,null,0,0,0,0]
["Medical16",0,0,0,null,0,0,0,0]
["Medical16",1,0.035,10,null,0,0,0,0]
["Medical16",2,0.0877,25,null,0,0,0,0]
["Medical16",3,0.1747,50,null,0,0,0,0]
["Medical16",4,0.346,100,null,0,0,0,0]
["Medical16",5,0.346,100,null,0,0,0,0]
["Behavior1",0,0,0,null,0,0,0,0]
["Behavior1",1,0.25,72,null,0,0,0,0]
["Behavior1",2,1.5,433,null,0,0,0,0]
["Behavior1",3,2,578,null,0,0,0,0]
["Behavior1",4,2,578,null,0,0,0,0]
["Behavior1",5,2,578,null,0,0,0,0]
["Behavior2",0,0,0,null,0,0,0,0]
["Behavior2",1,1,289,null,0,0,0,0]
["Behavior2",2,2,578,null,2,578,2,578]
["Behavior2",3,2,578,null,2,578,2,578]
["Behavior2",4,2,578,null,2,578,2,578]
["Behavior2",5,2,578,null,2,578,2,578]
["Behavior3",0,0,{"$f":"ROUND(C194*30.41*9.5,0)","v":0},null,0,0,0,0]
["Behavior3",1,0.25,72,null,0,0,0,0]
["Behavior3",2,1.5,433,null,0,0,1,289]
["Behavior3",3,2,578,null,0,0,1,289]
["Behavior3",4,2,578,null,0,0,1,289]
["Behavior3",5,2,578,null,0,0,1,289]
["Behavior4",0,0,{"$f":"ROUND(C200*30.41*9.5,0)","v":0},null,0,{"$f":"ROUND(F200*30.41*9.5,0)","v":0},0,{"$f":"ROUND(H200*30.41*9.5,0)","v":0}]
["Behavior4",1,2,578,null,2,578,2,578]
["Behavior4",2,4,1156,null,4,1156,4,1156]
["Behavior4",3,6,1733,null,6,1733,6,1733]
["Behavior4",4,8,2311,null,8,2311,8,2311]
["Behavior4",5,10,2889,null,10,2889,10,2889]
["Behavior4",6,12,3467,null,12,3467,12,3467]
["Behavior4",7,12,3467,null,12,3467,12,3467]
["Behavior5",0,0,0,null,0,0,0,0]
["Behavior5",1,0,0,null,0,0,0,0]
["Behavior5",2,0,0,null,0,0,0,0]
["Behavior5",3,1.5,433,null,0,0,0,0]
["Behavior5",4,2,578,null,1,289,1.5,433]
["Behavior5",5,2,578,null,1,289,1.5,433]

{"sheet":"HHRawScoring","index":13,"n_rows":36,"n_cols":25,"rows_kept":36,"hidden":true,"merged":[[26,7,26,8],[26,11,26,12]]}
[null,"From Assessment","Real Scoring","Exception?","Hours",null,"From Assessment","Real Scoring","Exception?","Hours",null,"From Assessment","Real Scoring","Exception?","Hours",null,"From Assessment","Real Scoring","Exception?","Hours",null,null,"HostHomeConsideration#","HostHome","HHResult"]
["ADL1",{"$f":"'Raw Scoring'!B2","v":0},{"$f":"(IF(B2=5,4,B2))","v":0},{"$f":"IF(B2=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(C2,'New Scoring'!B2:B7,'New Scoring'!C2:C7)","v":0},"Nighttime1",{"$f":"'Raw Scoring'!G2","v":0},{"$f":"(IF(G2=5,4,G2))","v":0},{"$f":"IF(G2=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(H2,'New Scoring'!B74:B79,'New Scoring'!C74:C79)","v":0},"Medical1",{"$f":"'Raw Scoring'!L2","v":0},{"$f":"(IF(L2=5,4,L2))","v":0},{"$f":"IF(L2=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(M2,'New Scoring'!B86:B91,'New Scoring'!C86:C91)","v":0},"Behavior1",{"$f":"'Raw Scoring'!Q2","v":0},{"$f":"(IF(R4>1,0,Q2))","v":0},{"$f":"IF(Q2=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(R2,'New Scoring'!B182:B187,'New Scoring'!C182:C187)","v":0},null,null,1,{"$f":"'Raw Scoring'!X2","v":"No"},{"$f":"IF(COUNTIF(X2:X36,\"Yes\")>0,\"Yes\",\"No\")","v":"No"}]
["ADL2",{"$f":"'Raw Scoring'!B3","v":0},{"$f":"(IF(R6 > 2, 0, IF(B3=5,4,B3)))","v":0},{"$f":"IF(B3=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(C3,'New Scoring'!B8:B13,'New Scoring'!C8:C13)","v":0},"Nighttime2",{"$f":"'Raw Scoring'!G3","v":0},{"$f":"(IF(G3=5,4,G3))","v":0},{"$f":"IF(G3=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(H3,'New Scoring'!B80:B85,'New Scoring'!C80:C85)","v":0},"Medical2",{"$f":"'Raw Scoring'!L3","v":0},{"$f":"(IF(L3=5,4,L3))","v":0},{"$f":"IF(L3=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(M3,'New Scoring'!B92:B97,'New Scoring'!C92:C97)","v":0},"Behavior2",{"$f":"'Raw Scoring'!Q3","v":0},{"$f":"(IF(Q3=5,4,Q3))","v":0},{"$f":"IF(Q3=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(R3,'New Scoring'!B188:B193,'New Scoring'!C188:C193)","v":0},null,null,2,{"$f":"'Raw Scoring'!X3","v":"No"},{"$f":"COUNTIF(X2:X36,\"Yes\")","v":0}]
["ADL3",{"$f":"'Raw Scoring'!B4","v":0},{"$f":"(IF(B4=5,4,B4))","v":0},"No",{"$f":"LOOKUP(C4,'New Scoring'!B14:B19,'New Scoring'!C14:C19)","v":0},"Totals",{"$f":"G2+G3","v":0},{"$f":"MAX(H2:H3)","v":0},{"$f":"COUNTIF(I2:I3,\"Yes\")","v":0},{"$f":"SUM(J2:J3)","v":0},"Medical3",{"$f":"'Raw Scoring'!L4","v":0},0,"No",{"$f":"LOOKUP(M4,'New Scoring'!B98:B103,'New Scoring'!C98:C103)","v":0},"Behavior3",{"$f":"'Raw Scoring'!Q4","v":0},{"$f":"IF(V5 = 4,2,IF(V5>4,3,IF(Q4=5,4,Q4)))","v":0},{"$f":"IF(Q4=7,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(R4,'New Scoring'!B194:B199,'New Scoring'!C194:C199)","v":0},"BehaviorDupChecks",{"$f":"Q6+B3","v":0},3,{"$f":"'Raw Scoring'!X4","v":"No"}]
["ADL4",{"$f":"'Raw Scoring'!B5","v":0},{"$f":"(IF(B5=5,4,B5))","v":0},"No",{"$f":"LOOKUP(C5,'New Scoring'!B20:B25,'New Scoring'!C20:C25)","v":0},"Exception?",{"$f":"IF(I4>0,\"Yes\",\"No\")","v":"No"},{"$nulls":3},"Medical4",{"$f":"'Raw Scoring'!L5","v":0},0,"No",{"$f":"LOOKUP(M5,'New Scoring'!B104:B109,'New Scoring'!C104:C109)","v":0},"Behavior4",{"$f":"'Raw Scoring'!Q5","v":0},{"$f":"(IF(Q5=7,6,Q5))","v":0},{"$f":"IF(Q5=7,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(R5,'New Scoring'!B200:B207,'New Scoring'!C200:C207)","v":0},null,{"$f":"Q2+Q4","v":0},4,{"$f":"'Raw Scoring'!X5","v":"No"}]
["ADL5",{"$f":"'Raw Scoring'!B6","v":0},0,"No",{"$f":"LOOKUP(C6,'New Scoring'!B26:B31,'New Scoring'!C26:C31)","v":0},{"$nulls":5},"Medical5",{"$f":"'Raw Scoring'!L6","v":0},0,"No",{"$f":"LOOKUP(M6,'New Scoring'!B110:B115,'New Scoring'!C110:C115)","v":0},"Behavior5",{"$f":"'Raw Scoring'!Q6","v":0},{"$f":"IF(V4>6,IF(V4 = 7,2,4),IF(Q6=5,4,Q6))","v":0},{"$f":"IF(Q6=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(R6,'New Scoring'!B208:B213,'New Scoring'!C208:C213)","v":0},null,null,5,{"$f":"'Raw Scoring'!X6","v":"No"}]
["ADL6",{"$f":"'Raw Scoring'!B7","v":0},0,"No",{"$f":"LOOKUP(C7,'New Scoring'!B32:B37,'New Scoring'!C32:C37)","v":0},{"$nulls":5},"Medical6",{"$f":"'Raw Scoring'!L7","v":0},0,"No",{"$f":"LOOKUP(M7,'New Scoring'!B116:B121,'New Scoring'!C116:C121)","v":0},"Totals",{"$f":"SUM(Q2:Q6)","v":0},{"$f":"SUM(R2:R6)","v":0},{"$f":"COUNTIF(S2:S6,\"Yes\")","v":0},{"$f":"SUM(T2:T6)","v":0},null,null,6,{"$f":"'Raw Scoring'!X7","v":"No"}]
["ADL7",{"$f":"'Raw Scoring'!B8","v":0},0,"No",{"$f":"LOOKUP(C8,'New Scoring'!B38:B43,'New Scoring'!C38:C43)","v":0},{"$nulls":5},"Medical7",{"$f":"'Raw Scoring'!L8","v":0},0,"No",{"$f":"LOOKUP(M8,'New Scoring'!B122:B127,'New Scoring'!C122:C127)","v":0},"Exception?",{"$f":"IF(S7>0,\"Yes\",\"No\")","v":"No"},{"$nulls":5},7,{"$f":"'Raw Scoring'!X8","v":"No"}]
["ADL8",{"$f":"'Raw Scoring'!B9","v":0},0,"No",{"$f":"LOOKUP(C9,'New Scoring'!B44:B49,'New Scoring'!C44:C49)","v":0},{"$nulls":5},"Medical8",{"$f":"'Raw Scoring'!L9","v":0},0,"No",{"$f":"LOOKUP(M9,'New Scoring'!B128:B133,'New Scoring'!C128:C133)","v":0},{"$nulls":7},8,{"$f":"'Raw Scoring'!X9","v":"No"}]
["ADL9",{"$f":"'Raw Scoring'!B10","v":0},0,"No",{"$f":"LOOKUP(C10,'New Scoring'!B50:B55,'New Scoring'!C50:C55)","v":0},{"$nulls":5},"Medical9",{"$f":"'Raw Scoring'!L10","v":0},0,{"$f":"IF(Q11=5,\"Yes\",\"No\")","v":"No"},{"$f":"LOOKUP(M10,'New Scoring'!B134:B139,'New Scoring'!C134:C139)","v":0},{"$nulls":7},9,{"$f":"'Raw Scoring'!X10","v":"No"}]
["ADL10",{"$f":"'Raw Scoring'!B11","v":0},0,"No",{"$f":"LOOKUP(C11,'New Scoring'!B56:B61,'New Scoring'!C56:C61)","v":0},{"$nulls":5},"Medical10",{"$f":"'Raw Scoring'!L11","v":0},0,"No",{"$f":"LOOKUP(M11,'New Scoring'!B140:B145,'New Scoring'!C140:C145)","v":0},"2 person",{"$f":"'Raw Scoring'!Q11","v":0},{"$nulls":5},10,{"$f":"'Raw Scoring'!X11","v":"No"}]
["ADL11",{"$f":"'Raw Scoring'!B12","v":0},{"$f":"(IF(B12=5,4,B12))","v":0},"No",{"$f":"LOOKUP(C12,'New Scoring'!B62:B67,'New Scoring'!C62:C67)","v":0},{"$nulls":5},"Medical11",{"$f":"'Raw Scoring'!L12","v":0},0,"No",{"$f":"LOOKUP(M12,'New Scoring'!B146:B151,'New Scoring'!C146:C151)","v":0},{"$nulls":7},11,{"$f":"'Raw Scoring'!X12","v":"No"}]
["ADL12",{"$f":"'Raw Scoring'!B13","v":0},{"$f":"(IF(B13=5,4,B13))","v":0},"No",{"$f":"LOOKUP(C13,'New Scoring'!B68:B73,'New Scoring'!C68:C73)","v":0},{"$nulls":5},"Medical12",{"$f":"'Raw Scoring'!L13","v":0},0,"No",{"$f":"LOOKUP(M13,'New Scoring'!B152:B157,'New Scoring'!C152:C157)","v":0},{"$nulls":7},12,{"$f":"'Raw Scoring'!X13","v":"No"}]
["Totals",{"$f":"SUM(B2:B13)","v":0},{"$f":"SUM(C2:C13)","v":0},{"$f":"COUNTIF(D2:D13,\"Yes\")","v":0},{"$f":"SUM(E2:E13)","v":0},{"$nulls":5},"Medical13",{"$f":"'Raw Scoring'!L14","v":0},0,"No",{"$f":"LOOKUP(M14,'New Scoring'!B158:B163,'New Scoring'!C158:C163)","v":0},{"$nulls":7},13,{"$f":"'Raw Scoring'!X14","v":"No"}]
["Exception?",{"$f":"IF(D14>0,\"Yes\",\"No\")","v":"No"},{"$nulls":8},"Medical14",{"$f":"'Raw Scoring'!L15","v":0},0,"No",{"$f":"LOOKUP(M15,'New Scoring'!B164:B169,'New Scoring'!C164:C169)","v":0},{"$nulls":7},14,{"$f":"'Raw Scoring'!X15","v":"No"}]
[{"$nulls":10},"Medical15",{"$f":"'Raw Scoring'!L16","v":0},0,"No",{"$f":"LOOKUP(M16,'New Scoring'!B170:B175,'New Scoring'!C170:C175)","v":0},{"$nulls":7},15,{"$f":"'Raw Scoring'!X16","v":"No"}]
[{"$nulls":5},"Total","DayTime Total",{"$nulls":3},"Medical16",{"$f":"'Raw Scoring'!L17","v":0},0,"No",{"$f":"LOOKUP(M17,'New Scoring'!B176:B181,'New Scoring'!C176:C181)","v":0},{"$nulls":7},16,{"$f":"'Raw Scoring'!X17","v":"No"}]
[null,"ADL","Nighttime","Medical","Behavior",{"$f":"SUM(B19:E19)","v":0},{"$f":"B19+D19+E19","v":0},{"$nulls":3},"Totals",{"$f":"SUM(L2:L17)","v":0},{"$f":"SUM(M2:M17)","v":0},{"$f":"COUNTIF(N2:N17,\"Yes\")","v":0},{"$f":"SUM(O2:O17)","v":0},{"$nulls":7},17,{"$f":"'Raw Scoring'!X18","v":"No"}]
["Hours",{"$f":"E14","v":0},{"$f":"J4","v":0},{"$f":"O18","v":0},{"$f":"T7","v":0},{"$f":"SUM(B20:E20)","v":0},{"$f":"B20+D20+E20","v":0},{"$nulls":15},18,{"$f":"'Raw Scoring'!X19","v":"No"}]
["Hours Adjusted",{"$f":"IF(B19>6,6,B19)","v":0},{"$f":"IF(C19>7,7,C19)","v":0},{"$f":"IF(D19>12,12,D19)","v":0},{"$f":"IF(E19>12,12,E19)","v":0},{"$f":"SUM(B21:E21)","v":0},{"$f":"B21+D21+E21","v":0},{"$nulls":3},"Exception?",{"$f":"IF(N18>0,\"Yes\",\"No\")","v":"No"},{"$nulls":10},19,{"$f":"'Raw Scoring'!X20","v":"No"}]
["Hours Adjusted 2",{"$f":"IF($G$19>17,(B20/$G$19)*17,B20)","v":0},{"$f":"C20","v":0},{"$f":"IF($G$19>17,(D20/$G$19)*17,D20)","v":0},{"$f":"IF($G$19>17,(E20/$G$19)*17,E20)","v":0},{"$f":"SUM(B22:E22)","v":0},{"$f":"B22+D22+E22","v":0},{"$nulls":15},20,{"$f":"'Raw Scoring'!X21","v":"No"}]
["Hours Adjusted 3",{"$f":"IF($F$20>24,(B21/$F$20)*24,B21)","v":0},{"$f":"IF($F$20>24,(C21/$F$20)*24,C21)","v":0},{"$f":"IF($F$20>24,(D21/$F$20)*24,D21)","v":0},{"$f":"IF($F$20>24,(E21/$F$20)*24,E21)","v":0},13.11,{"$nulls":16},21,{"$f":"'Raw Scoring'!X22","v":"No"}]
["Rate",13.82,13.82,13.82,13.82,30.41,{"$nulls":16},22,{"$f":"'Raw Scoring'!X23","v":"No"}]
["Days",30.41,30.41,30.41,30.41,{"$f":"ROUND(F20*F22*F23,0)","v":0},{"$nulls":16},23,{"$f":"'Raw Scoring'!X24","v":"No"}]
["Total",{"$f":"ROUND(B21*B23*B24,0)","v":0},{"$f":"ROUND(C21*C23*C24,0)","v":0},{"$f":"ROUND(D21*D23*D24,0)","v":0},{"$f":"ROUND(E21*E23*E24,0)","v":0},{"$nulls":17},24,{"$f":"'Raw Scoring'!X25","v":"No"}]
[{"$nulls":22},25,{"$f":"'Raw Scoring'!X26","v":"No"}]
["Rates",{"$nulls":3},"Exception Price",{"$f":"(D14+I4+N18+S7)*2*F22*F23","v":0},null,"Behavior Spec Criteria",null,"Hours",null,"RN Criteria",null,"Hours",{"$nulls":8},26,{"$f":"'Raw Scoring'!X27","v":"No"}]
["Program Mngr",24.6,null,null,"Respit",{"$f":"24*F22","v":314.64},null,"Q3 = 1",{"$f":"IF(Q3=1, \"Yes\", \"No\")","v":"No"},{"$f":"IF(I28 = \"Yes\", 2,0)","v":0},null,"L9 = 2",{"$f":"IF(L9 = 2, \"Yes\", \"No\")","v":"No"},{"$f":"IF(M28 = \"Yes\", 2,0)","v":0},{"$nulls":8},27,{"$f":"'Raw Scoring'!X28","v":"No"}]
["Program Crrd",21.21,null,null,"Program Mngr",{"$f":"4*B28","v":98.4},null,"Q3 = 2",{"$f":"IF(Q3=2, \"Yes\", \"No\")","v":"No"},{"$f":"IF(I29 = \"Yes\",4,0)","v":0},null,"L10 = 1",{"$f":"IF(L10 = 1, \"Yes\", \"No\")","v":"No"},{"$f":"IF(M29 = \"Yes\", 2,0)","v":0},{"$nulls":8},28,{"$f":"'Raw Scoring'!X29","v":"No"}]
["Behavior Spec",32.94,null,null,"Program Crrd",{"$f":"8*B29","v":169.68},null,"Q3 = 3",{"$f":"IF(Q3=3, \"Yes\", \"No\")","v":"No"},{"$f":"IF(I30 = \"Yes\", 4,0)","v":0},null,"L10 = 2",{"$f":"IF(L10 = 2, \"Yes\", \"No\")","v":"No"},{"$f":"IF(M30 = \"Yes\", 2,0)","v":0},{"$nulls":8},29,{"$f":"'Raw Scoring'!X30","v":"No"}]
["RN",32.77,null,null,"Behavior Spec",{"$f":"J31*B30","v":0},null,null,"Total",{"$f":"SUM(J28:J30)","v":0},null,"L10 = 3",{"$f":"IF(L10 = 3, \"Yes\", \"No\")","v":"No"},{"$f":"IF(M31 = \"Yes\", 4,0)","v":0},{"$nulls":8},30,{"$f":"'Raw Scoring'!X31","v":"No"}]
["Initial Support",1500,null,null,"RN",{"$f":"N33*B31","v":0},{"$nulls":5},"L10 = 4",{"$f":"IF(L10 = 4, \"Yes\", \"No\")","v":"No"},{"$f":"IF(M32 = \"Yes\", 4,0)","v":0},{"$nulls":8},31,{"$f":"'Raw Scoring'!X32","v":"No"}]
[{"$nulls":4},{"v":0.12,"d":"12%"},{"$f":"SUM(F27:F32,F24)*0.12","v":69.9264},{"$nulls":6},"Total",{"$f":"SUM(N28:N32)","v":0},{"$nulls":8},32,{"$f":"'Raw Scoring'!X33","v":"No"}]
[{"$nulls":4},"sub-Total",{"$f":"ROUND(SUM(F27:F33,F24),0)","v":653},{"$nulls":16},33,{"$f":"'Raw Scoring'!X34","v":"No"}]
[{"$nulls":4},"Initial Support",{"$f":"B32","v":1500},{"$nulls":16},34,{"$f":"'Raw Scoring'!X35","v":"No"}]
[{"$nulls":4},"Total",{"$f":"SUM(F34:F35)","v":2153},{"$nulls":16},35,{"$f":"'Raw Scoring'!X36","v":"No"}]

{"sheet":"HHScoring","index":14,"n_rows":213,"n_cols":5,"rows_kept":213,"hidden":true}
["Category","Assessment Score","Corresponding Hours",null,"Pricing"]
["ADL1",0,0,null,{"$f":"ROUND(C2*30.41*9.5,0)","v":0}]
["ADL1",1,1,null,{"$f":"ROUND(C3*30.41*9.5,0)","v":289}]
["ADL1",2,1,null,289]
["ADL1",3,1,null,289]
["ADL1",4,2,null,578]
["ADL1",5,2,null,578]
["ADL2",0,0,null,0]
["ADL2",1,1,null,289]
["ADL2",2,1,null,289]
["ADL2",3,1,null,289]
["ADL2",4,2,null,578]
["ADL2",5,2,null,578]
["ADL3",0,0,null,0]
["ADL3",1,1,null,289]
["ADL3",2,1,null,289]
["ADL3",3,1,null,289]
["ADL3",4,2,null,578]
["ADL3",5,2,null,578]
["ADL4",0,0,null,0]
["ADL4",1,0.5,null,144]
["ADL4",2,2,null,578]
["ADL4",3,3,null,867]
["ADL4",4,3,null,867]
["ADL4",5,3,null,867]
["ADL5",0,0,null,0]
["ADL5",1,0,null,0]
["ADL5",2,0,null,0]
["ADL5",3,0.5,null,144]
["ADL5",4,1,null,289]
["ADL5",5,1,null,289]
["ADL6",0,0,null,0]
["ADL6",1,0,null,0]
["ADL6",2,0,null,0]
["ADL6",3,0.5,null,144]
["ADL6",4,2,null,578]
["ADL6",5,2,null,578]
["ADL7",0,0,null,0]
["ADL7",1,0,null,0]
["ADL7",2,0,null,0]
["ADL7",3,0.5,null,144]
["ADL7",4,2,null,578]
["ADL7",5,2,null,578]
["ADL8",0,0,null,0]
["ADL8",1,0,null,0]
["ADL8",2,0,null,0]
["ADL8",3,0.25,null,72]
["ADL8",4,0.5,null,144]
["ADL8",5,0.5,null,144]
["ADL9",0,0,null,0]
["ADL9",1,0,null,0]
["ADL9",2,0.25,null,72]
["ADL9",3,0.25,null,72]
["ADL9",4,1,null,289]
["ADL9",5,1,null,289]
["ADL10",0,0,null,0]
["ADL10",1,0,null,0]
["ADL10",2,0.25,null,72]
["ADL10",3,0.25,null,72]
["ADL10",4,0.25,null,72]
["ADL10",5,0.25,null,72]
["ADL11",0,0,null,0]
["ADL11",1,0,null,0]
["ADL11",2,0.167,null,48]
["ADL11",3,0.667,null,193]
["ADL11",4,0.667,null,193]
["ADL11",5,0.667,null,{"$f":"ROUND(C67*30.41*9.5,0)","v":193}]
["ADL12",0,0,null,0]
["ADL12",1,0,null,0]
["ADL12",2,0.083,null,24]
["ADL12",3,0.333,null,96]
["ADL12",4,0.333,null,96]
["ADL12",5,0.333,null,{"$f":"ROUND(C73*30.41*9.5,0)","v":96}]
["Nighttime1",0,0,null,0]
["Nighttime1",1,1,null,289]
["Nighttime1",2,3,null,867]
["Nighttime1",3,6,null,1733]
["Nighttime1",4,7,null,2022]
["Nighttime1",5,7,null,2022]
["Nighttime2",0,0,null,0]
["Nighttime2",1,1,null,289]
["Nighttime2",2,3,null,867]
["Nighttime2",3,6,null,1733]
["Nighttime2",4,7,null,2022]
["Nighttime2",5,7,null,2022]
["Medical1",0,0,null,0]
["Medical1",1,0,null,0]
["Medical1",2,1,null,289]
["Medical1",3,1,null,289]
["Medical1",4,1,null,289]
["Medical1",5,1,null,289]
["Medical2",0,0,null,0]
["Medical2",1,0,null,0]
["Medical2",2,1,null,289]
["Medical2",3,1,null,289]
["Medical2",4,1,null,289]
["Medical2",5,1,null,289]
["Medical3",0,0,null,0]
["Medical3",1,0,null,0]
["Medical3",2,1.5,null,433]
["Medical3",3,1.5,null,433]
["Medical3",4,1.5,null,433]
["Medical3",5,1.5,null,433]
["Medical4",0,0,null,0]
["Medical4",1,0,null,0]
["Medical4",2,0.05,null,14]
["Medical4",3,0.05,null,14]
["Medical4",4,0.05,null,14]
["Medical4",5,0.05,null,14]
["Medical5",0,0,null,0]
["Medical5",1,0.5,null,144]
["Medical5",2,1,null,289]
["Medical5",3,1,null,289]
["Medical5",4,1,null,289]
["Medical5",5,1,null,289]
["Medical6",0,0,null,0]
["Medical6",1,0.5,null,144]
["Medical6",2,1,null,289]
["Medical6",3,1,null,289]
["Medical6",4,1,null,289]
["Medical6",5,1,null,289]
["Medical7",0,0,null,0]
["Medical7",1,0,null,0]
["Medical7",2,0,null,0]
["Medical7",3,0.5,null,144]
["Medical7",4,1,null,289]
["Medical7",5,1,null,289]
["Medical8",0,0,null,0]
["Medical8",1,0.25,null,72]
["Medical8",2,0.5,null,144]
["Medical8",3,0.5,null,144]
["Medical8",4,0.5,null,144]
["Medical8",5,0.5,null,144]
["Medical9",0,0,null,0]
["Medical9",1,1,null,289]
["Medical9",2,2,null,578]
["Medical9",3,6,null,{"$f":"ROUND(C137*30.41*9.5,0)","v":1733}]
["Medical9",4,12,null,3467]
["Medical9",5,12,null,3467]
["Medical10",0,0,null,0]
["Medical10",1,0.035,null,10]
["Medical10",2,0.0877,null,25]
["Medical10",3,0.0877,null,25]
["Medical10",4,0.0877,null,25]
["Medical10",5,0.0877,null,25]
["Medical11",0,0,null,0]
["Medical11",1,0,null,0]
["Medical11",2,0,{"$f":"(10/30)/9.5","v":0.03508771929824561},0]
["Medical11",3,0,null,0]
["Medical11",4,0,null,0]
["Medical11",5,0,null,0]
["Medical12",0,0,null,0]
["Medical12",1,0,null,0]
["Medical12",2,0,null,0]
["Medical12",3,0.1747,null,50]
["Medical12",4,0.1747,null,50]
["Medical12",5,0.1747,null,50]
["Medical13",0,0,null,0]
["Medical13",1,0,null,0]
["Medical13",2,0.1747,null,50]
["Medical13",3,0.1747,null,50]
["Medical13",4,0.1747,null,50]
["Medical13",5,0.1747,null,50]
["Medical14",0,0,null,0]
["Medical14",1,0,null,0]
["Medical14",2,0.0877,null,25]
["Medical14",3,0.346,null,100]
["Medical14",4,0.346,null,100]
["Medical14",5,0.346,null,100]
["Medical15",0,0,null,0]
["Medical15",1,0.0877,null,25]
["Medical15",2,0.0877,null,25]
["Medical15",3,0.1747,null,50]
["Medical15",4,0.1747,null,50]
["Medical15",5,0.1747,null,50]
["Medical16",0,0,null,0]
["Medical16",1,0.035,null,10]
["Medical16",2,0.0877,null,25]
["Medical16",3,0.1747,null,50]
["Medical16",4,0.346,null,100]
["Medical16",5,0.346,null,100]
["Behavior1",0,0,null,0]
["Behavior1",1,0.25,null,72]
["Behavior1",2,1.5,null,433]
["Behavior1",3,2,null,578]
["Behavior1",4,2,null,578]
["Behavior1",5,2,null,578]
["Behavior2",0,0,null,0]
["Behavior2",1,1,null,289]
["Behavior2",2,2,null,578]
["Behavior2",3,2,null,578]
["Behavior2",4,2,null,578]
["Behavior2",5,2,null,578]
["Behavior3",0,0,null,0]
["Behavior3",1,0.25,null,72]
["Behavior3",2,1.5,null,433]
["Behavior3",3,2,null,578]
["Behavior3",4,2,null,578]
["Behavior3",5,2,null,578]
["Behavior4",0,0,null,0]
["Behavior4",1,2,null,578]
["Behavior4",2,4,null,1156]
["Behavior4",3,6,null,1733]
["Behavior4",4,8,null,2311]
["Behavior4",5,10,null,2889]
["Behavior4",6,12,null,{"$f":"ROUND(C206*30.41*9.5,0)","v":3467}]
["Behavior4",7,12,null,{"$f":"ROUND(C207*30.41*9.5,0)","v":3467}]
["Behavior5",0,0,null,0]
["Behavior5",1,0,null,{"$f":"ROUND(C209*30.41*9.5,0)","v":0}]
["Behavior5",2,0,null,{"$f":"ROUND(C210*30.41*9.5,0)","v":0}]
["Behavior5",3,1.5,null,{"$f":"ROUND(C211*30.41*9.5,0)","v":433}]
["Behavior5",4,2,null,{"$f":"ROUND(C212*30.41*9.5,0)","v":578}]
["Behavior5",5,2,null,{"$f":"ROUND(C213*30.41*9.5,0)","v":578}]