{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Client Demographics","Enhanced or Exceptional","Enh+Excp Summary","Raw Scoring","Control"],"not_rendered":{"images":8,"macros":1,"external_links":1,"defined_names":75},"read":"whole","date_system":"1900"}

{"sheet":"Client Demographics","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,16],[1,0,1,12],[2,0,2,2],[2,3,2,8],[2,9,2,10],[2,11,2,12],[3,0,3,2],[3,3,3,8],[3,9,3,10],[3,11,3,12],[4,0,4,3],[4,4,4,7],[4,8,4,9],[4,10,4,12],[4,14,4,16],[5,0,5,3],[5,4,5,7],[5,8,5,9],[5,10,5,12],[5,14,5,16],[11,0,11,2]]}
["Enhanced or Exception Addendum"]
["WARNING: Macros are currently disabled.  If this message persists after workbook initialization, please close this file, then reopen it and select either [Enable Macros] or [Enable Content], whichever option is displayed.\n\n* If you believe you have already enabled Macros/Content then:\n   1. First, select the Ribbon's File tab and, if you see a security warning, select the large [Enable Content v] shield button, \n        then \"Enable All Content\".\n   2. If you don't find a security warning then select the [Enable Macros] button on the right, on this sheet, if it is visible."]
["(Legal Name) \nName of Individual",{"$nulls":8},"Date of Birth",{"$nulls":5},"Age",{"$f":"IF(OR(L3=\"\",AssessmentDate=\"\"),\n       \"\",\n       IF(DATEDIF(L3,AssessmentDate,\"Y\")=0,\n            DATEDIF(L3,AssessmentDate,\"YM\") & \" Month\" & IF(DATEDIF(L3,AssessmentDate,\"YM\")=1,\"\",\"s\"),\n            IF(DATEDIF(L3,AssessmentDate,\"Y\")=1,\n                 DATEDIF(L3,AssessmentDate,\"M\") & \" Months\",\n                 DATEDIF(L3,AssessmentDate,\"Y\"))))","v":""}]
["Prime #",{"$nulls":8},"Today's Date"]
["CDDP Services Coordinator or\nBrokerage Personal Agent",{"$nulls":7},"CDDP/County or\nBrokerage",null,"(Select)",null,null,"Phone"]
["Assessor's Name",{"$nulls":7},"Assessor Affiliation",null,"(Select)",null,null,"Phone"]
[]
[]
[]
[]
[]
["Enh+Excp version C.21",{"$nulls":12},"Auto-save every ",10," minutes"]

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

{"sheet":"Enh+Excp Summary","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"merged":[[0,0,0,5],[1,1,1,2],[2,1,2,2],[34,0,35,1],[36,0,36,5],[36,6,36,11],[37,1,37,2],[39,0,40,0],[39,1,40,5]]}
["Enhanced or Exception Addendum Summary"]
["Name of Individual ",{"$f":"IF(ClientName=0,\"\",ClientName)","v":""},null,"Date of Birth ",{"$f":"IF(ClientDOB=0,\"\",ClientDOB)","v":""}]
["Today's Date",{"$f":"IF(AssessmentDate=0,\"\",AssessmentDate)","v":""},null,"Age ",{"$f":"ClientAge","v":""}]
[]
["Med. Enh./Except.","(None)"]
[null,"Ventilator monitoring and care"]
[null,"CPAP/BiPAP assistance and monitoring"]
[null,"Oxygen administration and monitoring"]
[null,"Extensive respiratory treatment"]
[null,"Tracheotomy care"]
[null,"Suctioning airway"]
[null,"Stoma care"]
[null,"Tube feeding"]
[null,"Diabetes management"]
[null,"Injections/infusions"]
[null,"Dialysis (by the caregiver in the home)"]
[null,"Shunt (cerebral) monitoring and care"]
[null,"Monitoring of vital signs"]
[null,"Seizure interventions"]
[null,"Baclofen pump monitoring and assistance"]
[null,"Wound care/ulcer care"]
[null,"Stump care for new amputation"]
[null,"Colostomy/urostomy/ileostomy care"]
[null,"Impaction removal"]
[null,"Urinary catheterization"]
[null,"Mechanical lift, stander, sidelyer, or bodyJacket"]
[null,"Awake caregiver required 20 or more hours per day"]
["Behav. Enh./Except.","(None)"]
[null,"Behavior support plan, implementation "]
[null,"Behavior documentation data"]
[null,"Behavior support plan, multiple revisions"]
[null,"Protective physical interventions"]
[null,"Awake caregiver required 20 or more hours per day"]
[]
["Enhanced/Exceptional Status",null,"Behavioral","Medical"]
[null,null,{"$f":"EE_BehavIsEnhExc","v":"N/A"},{"$f":"EE_MedIsEnhExc","v":"N/A"}]
[]
["Completed by:",{"$f":"IF(ISBLANK(AssessorName),\"\",AssessorName)","v":""}]
[]
["Comments: "]

{"sheet":"Raw Scoring","index":3,"n_rows":53,"n_cols":43,"rows_kept":53,"hidden":true,"merged":[[10,7,10,9],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[15,7,15,9],[16,7,16,9],[17,7,17,9]]}
["ADL\nGroup ID","Selection\nValue","Adjusted\nValue","Add-On\nor Value\nException","Add-On\nException","Hours","Nighttime\nGroup ID","Selection\nValue","Adjusted\nValue","Add-On\nor Value\nException","Add-On\nException","Hours","Medical\nGroup ID","Selection\nValue","Adjusted\nValue","Add-On\nor Value\nException","Add-On\nException","Hours","Behavior\nGroup ID","Selection\nValue","Adjusted\nValue","Add-On\nor Value\nException","Add-On\nException","Hours","Behavior\nDuplication\nAdjustments","Dup. Calc","Exception?","Social\nGroup ID","Selection\nValue","Adjusted\nValue","(Add-On\nor Value)\nException","Add-On\nException","Hours",null,"EE_Nursing\nGroup ID","Selection\nValue",null,"EE_Behav\nGroup ID","Selection\nValue"]
["ADL1",0,{"$f":"IF(B2=5,4,B2)","v":0},{"$f":"IF(E2<>\"N/A\",E2,IF(B2>=D$16,\"Yes\",\"No\"))","v":"No"},"N/A",null,"Nighttime1",0,{"$f":"(IF(H2=5,4,H2))","v":0},{"$f":"IF(K2<>\"N/A\",K2,IF(H2>=J$6,\"Yes\",\"No\"))","v":"No"},"N/A",null,"Medical1",0,{"$f":"(IF(N2=5,4,N2))","v":0},{"$f":"IF(Q2<>\"N/A\",Q2,IF(N2>=P$21,\"Yes\",\"No\"))","v":"No"},"N/A",null,"Behavior1",0,{"$f":"(IF((U4+U5)>1,0,T2))","v":0},{"$f":"IF(W2<>\"N/A\",W2,IF(T2>=V$9,\"Yes\",\"No\"))","v":"No"},"N/A",null,"(what was this?)",0,{"$f":"IF(Z2=0,\"No\",\"Yes\")","v":"No"},"Social1",0,{"$f":"AC2","v":0},{"$f":"IF(AF2<>\"N/A\",AF2,IF(AC2>=AE$7,\"Yes\",\"No\"))","v":"No"},"N/A",null,null,"Ventilator1",0,null,"SupPlanImpl1",0,null,"EE_MedIsEnh:",{"$f":"IF(EE_NursingComplete,IF(EE_NursingEnh,$AP$9,$AP$11),IF(MedShEnh,$AP$12,$AP$11))","v":"N/A"},"6/27/16: Rearranged the EE_MedIsEnhExc/EE_BehavIsEnhExc table to be consistent with ANA (and now CNA)"]
["ADL2",0,{"$f":"IF(B3=5,4,B3)","v":0},"No","N/A",null,"Nighttime2",0,{"$f":"(IF(H3=5,4,H3))","v":0},{"$f":"IF(K3<>\"N/A\",K3,IF(H3>=J$6,\"Yes\",\"No\"))","v":"No"},"N/A",null,"Medical2",0,{"$f":"(IF(N3=5,4,N3))","v":0},"No","N/A",null,"Behavior2",0,{"$f":"(IF(T3=5,4,T3))","v":0},{"$f":"IF(W3<>\"N/A\",W3,IF(T3>=V$9,\"Yes\",\"No\"))","v":"No"},"N/A",null,"BehaviorDupCheck 1",0,"N/A","Social2",0,{"$f":"AC3","v":0},{"$f":"IF(AF3<>\"N/A\",AF3,IF(AC3>=AE$7,\"Yes\",\"No\"))","v":"No"},"N/A",null,null,"CPAP2",0,null,"SupPlanRevised2",0,null,"EE_MedIsExc:",{"$f":"IF(EE_NursingComplete,IF(EE_NursingExc,$AP$10,$AP$11),IF(OR(MedShEnh,MedShExc),$AP$12,$AP$11))","v":"N/A"}]
["ADL3",0,0,"No","N/A",null,"Totals",{"$f":"H2+H3","v":0},{"$f":"MAX(I2:I3)","v":0},{"$f":"COUNTIF(J2:J3,\"Yes\")","v":0},{"$f":"COUNTIF(K2:K3,\"Yes\")","v":0},{"$f":"SUM(L2:L3)","v":{"v":0,"d":"0.00"}},"Medical3",0,0,"No","N/A",null,"Behavior3",0,{"$f":"IF(Z4 = 4,2,IF(Z4>4,3,IF(T4=5,4,T4)))","v":0},{"$f":"IF(W4<>\"N/A\",W4,IF(T4>=V$9,\"Yes\",\"No\"))","v":"No"},"N/A",null,"BehaviorDupCheck 2",{"$f":"T2+T4","v":0},"N/A","Social3",{"$f":"T6","v":0},{"$f":"AC4","v":0},{"$f":"IF(AF4<>\"N/A\",AF4,IF(AC4>=AE$7,\"Yes\",\"No\"))","v":"No"},"N/A",null,null,"Oxygen3",0,null,"CmplxTools3",0,null,"EE_MedIsEnhExc:",{"$f":"IF(EE_MedIsExc<>$AP$11,EE_MedIsExc,EE_MedIsEnh)","v":"N/A"}]
["ADL4",0,0,"No","N/A",{"$nulls":3},"2-to-1 Review:",{"$f":"IF(J4>0,\"Yes\",\"No\")","v":"No"},null,null,"Medical4",0,0,"No","N/A",null,"Behavior4",0,{"$f":"(IF(T5=7,6,T5))","v":0},{"$f":"IF(W5<>\"N/A\",W5,IF(T5>=V$9,\"Yes\",\"No\"))","v":"No"},"No",{"$nulls":4},"Totals",{"$f":"SUM(AC2:AC4)","v":0},{"$f":"SUM(AD2:AD4)","v":0},{"$f":"COUNTIF(AE2:AE4,\"Yes\")","v":0},{"$f":"COUNTIF(AF2:AF4,\"Yes\")","v":0},{"$f":"SUM(AG2:AG4)","v":{"v":0,"d":"0.00"}},null,"Resp4",0,null,"PPI4",0,null,"EE_BehavIsEnh:",{"$f":"IF(EE_BehavComplete,IF(EE_BehavEnh,$AP$9,$AP$11),IF(BehavShEnh,$AP$12,$AP$11))","v":"N/A"}]
["ADL5",0,0,"No","N/A",{"$nulls":3},"Excep. Threshold:",5,null,null,"Medical5",0,0,"No","N/A",null,"Behavior5",0,{"$f":"IF(Z3>6,IF(Z3 = 7,2,4),IF(T6=5,4,T6))","v":0},{"$f":"IF(W6<>\"N/A\",W6,IF(T6>=V$9,\"Yes\",\"No\"))","v":"No"},"No",{"$nulls":6},"2-to-1 Review:",{"$f":"IF(AE5>0,\"Yes\",\"No\")","v":"No"},{"$nulls":3},"Trach5",0,null,"TwentyHrs5",0,null,"EE_BehavIsExc:",{"$f":"IF(EE_BehavComplete,IF(EE_BehavExc,$AP$10,$AP$11),IF(OR(BehavShEnh,BehavShExc),$AP$12,$AP$11))","v":"N/A"}]
["ADL6",0,0,"No","N/A",{"$nulls":7},"Medical6",0,0,"No","N/A",null,"Totals",{"$f":"SUM(T2:T6)","v":0},{"$f":"SUM(U2:U6)","v":0},{"$f":"COUNTIF(V2:V6,\"Yes\")","v":0},{"$f":"COUNTIF(W2:W6,\"Yes\")","v":0},{"$f":"SUM(X2:X6)","v":{"v":0,"d":"0.00"}},{"$nulls":5},"Excep. Threshold:",6,{"$nulls":3},"Suction6",0,null,"None6",0,null,"EE_BehavIsEnhExc:",{"$f":"IF(EE_BehavIsExc<>$AP$11,EE_BehavIsExc,EE_BehavIsEnh)","v":"N/A"}]
["ADL7",0,null,"No","N/A",null,"If ADL6 > partial-assist and ADL7 > partial-assist then limits ADL7 to partial-assist score",{"$nulls":5},"Medical7",0,0,"No","N/A",null,"Enhanced",{"$f":"AND(T3 >= 1, T4 >= 2, T6 >= 3)","v":false},"2-to-1 Review:",{"$f":"IF(V7>0,\"Yes\",\"No\")","v":"No"},{"$nulls":12},"Stoma7",0,null,"Total",{"$f":"SUM(AM2:AM5)","v":0}]
["ADL8",0,0,"No","N/A",null,"If BLADDER+BOWEL > partial-assist and TOILET > partial-assist then limits TOILET to partial-assist score",{"$nulls":5},"Medical8",0,0,"No","N/A",null,"Exceptional",{"$f":"AND(T3 >= 2, T4 >= 3, T6 >= 4)","v":false},"Excep. Threshold:",4,{"$nulls":12},"FeedingTube8",0,null,"Enhanced",{"$f":"AM2>0","v":false},null,"Text:","Enhanced"]
["ADL9",0,0,"No","N/A",{"$nulls":7},"Medical9",0,0,"No","No",{"$nulls":17},"Diabetes9",0,null,"Exceptional",{"$f":"AND(EE_BehavEnh,AM6,SUM(AM3:AM5)>0)","v":false},null,null,"Exceptional"]
["ADL10",0,0,"No","N/A",null,null,"ADL/IADL Hourly Supports",null,null,{"$f":"IF($D$45>$G$25,$D$45-($K$12+$K$13+$K$15),$B$25)","v":0},null,"Medical10",null,"N/A","No","N/A",null,"(Old, unused \"Nursing\" section removed!)",{"$nulls":15},"Injection10",0,null,"Complete",{"$f":"OR(AM7, AM8>0)","v":false},null,null,"N/A"]
["ADL11",0,0,"No","N/A",null,null,"Behavior Hourly Supports",null,null,{"$f":"$E$25","v":0},null,"Medical11",0,0,"No","N/A",{"$nulls":17},"Dialysis11",0,{"$nulls":5},"Please fill out \"Enhanced or Exception\" sheet"]
["ADL12",0,0,"No","N/A",null,null,"Medical & Safety Hourly Supports",null,null,{"$f":"$D$25","v":0},null,"Medical12",0,0,"No","N/A",{"$nulls":17},"Shunt12",0]
["Totals",{"$f":"SUM(B2:B13)","v":0},{"$f":"SUM(C2:C13)","v":0},{"$f":"COUNTIF(D2:D13,\"Yes\")","v":0},{"$f":"COUNTIF(E2:E13,\"Yes\")","v":0},{"$f":"SUM(F2:F13)","v":{"v":0,"d":"0.00"}},null,"Community Access/Social Hourly Support",null,null,{"$f":"$F$25","v":0},null,"Medical13",0,0,"No","N/A",{"$nulls":17},"VitalSigns13",0]
[null,null,"2-to-1 Review:",{"$f":"IF(D14>0,\"Yes\",\"No\")","v":"No"},{"$nulls":3},"Nighttime Hourly Supports",null,null,{"$f":"$C$25","v":0},null,"Medical14",0,0,"No","N/A",{"$nulls":17},"Seisure14",0]
[null,null,"Excep. Threshold:",5,{"$nulls":3},"Daily Average Attendant Care Hours",null,null,{"$f":"SUM($K$11:$K$15)","v":0},null,"Medical15",0,0,"No","N/A",{"$nulls":17},"MedPump15",0]
[{"$nulls":7},"Monthly Attendant Care Hours",null,null,{"$f":"ROUNDUP($K$16*DaysPerMo,0)","v":0},null,"Medical16",0,{"$f":"(IF(N17=5,4,N17))","v":0},"No","N/A",{"$nulls":17},"WoundCare16",0]
[{"$nulls":7},"Monthly + 2:1 Hrs.",{"$nulls":4},"Medical17",0,{"$f":"(IF(N18=5,4,N18))","v":0},"No","N/A",{"$nulls":17},"SumpCare17",0]
[{"$nulls":12},"Totals",{"$f":"SUM(N2:N18)","v":0},{"$f":"SUM(O2:O18)","v":0},{"$f":"COUNTIF(P2:P18,\"Yes\")","v":0},{"$f":"COUNTIF(Q2:Q18,\"Yes\")","v":0},{"$f":"SUM(R2:R18)","v":{"v":0,"d":"0.00"}},{"$nulls":16},"Ostomy18",0]
[null,"ADL","Nighttime","Medical","Behavior","SocComm","Total","DayTime Total",{"$nulls":4},"Enhanced",{"$f":"OR(N10 >= 1, AND(N9 >= 2, OR(N7 >= 2, N8 >= 3, N18 >= 2, B5 >= 4)))","v":false},"2-to-1 Review:",{"$f":"IF(P19>0,\"Yes\",\"No\")","v":"No"},{"$nulls":18},"ImpactionCare19",0]
["Hours",{"$f":"F14","v":{"v":0,"d":"0.00"}},{"$f":"L4","v":{"v":0,"d":"0.00"}},{"$f":"R19","v":{"v":0,"d":"0.00"}},{"$f":"X7","v":{"v":0,"d":"0.00"}},{"$f":"AG5","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B21:F21)","v":{"v":0,"d":"0.00"}},{"$f":"B21+D21+E21+F21","v":{"v":0,"d":"0.00"}},{"$nulls":4},"Exceptional",{"$f":"AND(MedShEnh, N11 >= 2)","v":false},"Excep. Threshold:",5,{"$nulls":18},"Cath20",0]
["Hours Adjusted",{"$f":"IF((D21+E21)>11, IF(B21>5, 5, B21), IF(B21>6,6,B21))","v":{"v":0,"d":"0.00"}},{"$f":"IF(C21>7,7,C21)","v":{"v":0,"d":"0.00"}},{"$f":"IF((E21+F21)>8, IF(D21>7, 7, D21), IF(D21>12,12,D21))","v":{"v":0,"d":"0.00"}},{"$f":"IF((D21+F21)>8, IF(E21>7, 7, E21), IF(E21>10,10,E21))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F21>3.2,3.2,F21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B22:F22)","v":{"v":0,"d":"0.00"}},{"$f":"B22+D22+E22+F22","v":{"v":0,"d":"0.00"}},{"$nulls":26},"Positioning21",0]
["Hours Adjusted 2",{"$f":"B22","v":{"v":0,"d":"0.00"}},{"$f":"IF((C22/7)>((B23+D23+E23+F23)/17),(((B23+D23+E23+F23)/17)*7), C22)","v":{"v":0,"d":"0.00"}},{"$f":"D22","v":{"v":0,"d":"0.00"}},{"$f":"E22","v":{"v":0,"d":"0.00"}},{"$f":"F22","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B23:F23)","v":{"v":0,"d":"0.00"}},{"$f":"B23+D23+E23+F23","v":{"v":0,"d":"0.00"}},null,"adl ltd","nt ltd","med ltd","beh","AVG Daily",null,"Mo'y Hrs",{"$nulls":18},"TwentyHrs22",0]
["Hours Adjusted 3",{"$f":"IF($H$23>17,(B23/$H$23)*17,B23)","v":{"v":0,"d":"0.00"}},{"$f":"C23","v":{"v":0,"d":"0.00"}},{"$f":"IF($H$23>17,(D23/$H$23)*17,D23)","v":{"v":0,"d":"0.00"}},{"$f":"IF($H$23>17,(E23/$H$23)*17,E23)","v":{"v":0,"d":"0.00"}},{"$f":"IF($H$23>17,(F23/$H$23)*17,F23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B24:F24)","v":{"v":0,"d":"0.00"}},{"$f":"B24+D24+E24+F24","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(D25>3,B25-(((D25-3)/17)*$B25),B25)","v":0},{"$f":"IF(($C25/7)>(J24+L24+M24)/17, (7*((J24+L24+M24)/17)), $C25)","v":{"v":0,"d":"0.0"}},{"$f":"$D25","v":0},{"$f":"E25-((((J24+L24)/17))*E25)","v":0},{"$f":"SUM(M24:M24)","v":0},null,{"$f":"N24*DaysPerMo","v":0},{"$nulls":18},"None23",0]
["Hours Adjusted 4",{"$f":"IF($G$24>24,(B24/$G$24)*24,B24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(C24/$G$24)*24,C24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(D24/$G$24)*24,D24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(E24/$G$24)*24,E24)","v":{"v":0,"d":"0.00"}},{"$f":"IF($G$24>24,(F24/$G$24)*24,F24)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B25:F25)","v":{"v":0,"d":"0.00"}},{"$nulls":27},"Total",{"$f":"SUM(AJ2:AJ22)","v":0}]
["Adult Rate",{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"$nulls":27},"Enhanced",{"$f":"AJ25>=2","v":false}]
["Kid Rate",{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"v":9.5,"d":"9.50"},{"$nulls":27},"Exceptional",{"$f":"AND(AJ25>=4,AJ23)","v":false}]
["Days",{"$f":"DaysPerMo","v":30.41},30.41,30.41,30.41,30.41,30.41,{"$nulls":27},"Complete",{"$f":"OR(AJ24, AJ25>0)","v":false}]
["Total Adult",{"$f":"ROUND(B25*B26*B28,0)","v":0},0,0,0,0,0]
["Total Kid",{"$f":"B25*B27*B28","v":0},0,0,0,0,0]
[]
["Age LookUp",{"$nulls":4},"Montly Total ",{"$f":"G28*ScoreTotalHours","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(ClientDOB=\"\",\n       \"\",\n       IF(DATEDIF(ClientDOB,AssessmentDate,\"Y\")=0,\n            ROUND(DATEDIF(ClientDOB,AssessmentDate,\"YM\")/12, 1),\n            IF(DATEDIF(ClientDOB,AssessmentDate,\"Y\")=1,\n                 ROUND(DATEDIF(ClientDOB,AssessmentDate,\"M\")/12, 1),\n                 DATEDIF(ClientDOB,AssessmentDate,\"Y\"))))","v":""},{"$nulls":4},"2-to-1 Locally Approved Total "]
[{"$nulls":5},"Total ",{"$f":"G32+G33","v":{"v":0,"d":"0.00"}}]
[" Avg. Days/Month"]
[30.41,{"$nulls":4},"Interim Tier:",{"$f":"VLOOKUP($G$34,F$38:G$43,2,TRUE)","v":"Interim Tier 1"}]
[]
[{"$nulls":5},0,"Interim Tier 1"]
[{"$nulls":5},160.01,"Interim Tier 2",null,"Non Adjusted Rate","Adjusted Rate"]
[{"$nulls":5},275.01,"Interim Tier 3","0-5",{"$f":"$G$30+539","v":{"v":539,"d":"$539.00"}},{"$f":"IF(I40>3000,3000,I40)","v":{"v":539,"d":"$539.00"}}]
[{"$nulls":5},390.01,"Interim Tier 4","6-9",{"$f":"$G$30+539","v":{"v":539,"d":"$539.00"}},{"$f":"IF(I41>3500,3500,I41)","v":{"v":539,"d":"$539.00"}}]
[{"$nulls":5},510.01,"Interim Tier 5","10-17",{"$f":"$G$30+539","v":{"v":539,"d":"$539.00"}},{"$f":"I42","v":{"v":539,"d":"$539.00"}}]
[{"$nulls":5},630.01,"Interim Tier 6","18+",{"$f":"$G$29+799","v":{"v":799,"d":"$799.00"}},{"$f":"I43","v":{"v":799,"d":"$799.00"}}]
[null,null,"Personal Care Minimum",{"$f":"20/DaysPerMo","v":{"v":0.6576783952647155,"d":"0.66"}}]
[null,null,"Pers Care Applicability",{"$f":"IF(F3+F4+F5+F7+F10+F11>0,D44,0)","v":0}]
[]
[]
[]
[{"$nulls":6},"9/1/10 Rate",1000]
[{"$nulls":6},"Less 6% Rate Reduction",{"$f":"H49*0.06","v":60}]
[{"$nulls":6},"Equals Rate as of 10/1/10",{"$f":"H49-H50","v":940}]
[{"$nulls":6},"Less 4.255% rate Reduction effective 10/1/11",{"$f":"H51*0.04255","v":39.997}]
[{"$nulls":6},"Equals Rate as of 10/1/11",{"$f":"H51-H52","v":900.003}]

{"sheet":"Control","index":4,"n_rows":52,"n_cols":4,"rows_kept":52,"hidden":true}
[null,"Before-Save\nActive Sheet",null,"County/Brokerage LookUp"]
[null,"Client Demographics",null,"(Select)"]
[{"$nulls":3},"Community Pathways"]
[null,"Keep Current File Name",null,"CSI"]
[{"$nulls":3},"EOSSB"]
[{"$nulls":3},"Full Access"]
[{"$nulls":3},"Inclusion"]
[{"$nulls":3},"Ind NW"]
[{"$nulls":3},"ISN"]
[{"$nulls":3},"Mentor Metro"]
[{"$nulls":3},"Mid Valley"]
[{"$nulls":3},"RCO"]
[{"$nulls":3},"SDRI"]
[{"$nulls":3},"SORB"]
[{"$nulls":3},"UCP"]
[{"$nulls":3},"----------------------------------"]
[{"$nulls":3},"BAKER"]
[{"$nulls":3},"BENTON"]
[{"$nulls":3},"CLACKAMAS"]
[{"$nulls":3},"CLATSOP"]
[{"$nulls":3},"COLUMBIA"]
[{"$nulls":3},"COOS"]
[{"$nulls":3},"CROOK"]
[{"$nulls":3},"CURRY"]
[{"$nulls":3},"DESCHUTES"]
[{"$nulls":3},"DOUGLAS"]
[{"$nulls":3},"GILLIAM"]
[{"$nulls":3},"GRANT"]
[{"$nulls":3},"HARNEY"]
[{"$nulls":3},"HOOD RIVER"]
[{"$nulls":3},"JACKSON"]
[{"$nulls":3},"JEFFERSON"]
[{"$nulls":3},"JOSEPHINE"]
[{"$nulls":3},"KLAMATH"]
[{"$nulls":3},"LAKE"]
[{"$nulls":3},"LANE"]
[{"$nulls":3},"LINCOLN"]
[{"$nulls":3},"LINN"]
[{"$nulls":3},"MALHEUR"]
[{"$nulls":3},"MARION"]
[{"$nulls":3},"MORROW"]
[{"$nulls":3},"MULTNOMAH"]
[{"$nulls":3},"POLK"]
[{"$nulls":3},"SHERMAN"]
[{"$nulls":3},"TILLAMOOK"]
[{"$nulls":3},"UMATILLA"]
[{"$nulls":3},"UNION"]
[{"$nulls":3},"WALLOWA"]
[{"$nulls":3},"WASCO"]
[{"$nulls":3},"WASHINGTON"]
[{"$nulls":3},"WHEELER"]
[{"$nulls":3},"YAMHILL"]