{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Acuity Level Calculator","Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Acuity Level Calculator","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[1,1,3,3],[19,1,20,1]]}
[]
[null,"Instructions: For each category, use the drop-down menu to select one criterion that best fits the member's current status. The tool will automatically calculate the member's total score and display the Acuity Level at the bottom of the form."]
[]
[]
[]
[null,"Categories","Criteria","Points"]
[null,"1. Clinical Complexity",null,{"$f":"_xlfn.XLOOKUP(C7,Sheet1!C7:C10,Sheet1!D7:D10,0)","v":0}]
[null,"2. Behavioral Health",null,{"$f":"_xlfn.XLOOKUP(C8,Sheet1!C11:C14,Sheet1!D11:D14,0)","v":0}]
[null,"3. Utilization (past 6–12 months)",null,{"$f":"_xlfn.XLOOKUP(C9,Sheet1!C15:C18,Sheet1!D15:D18,0)","v":0}]
[null,"4. Medication Management",null,{"$f":"_xlfn.XLOOKUP(C10,Sheet1!C19:C22,Sheet1!D19:D22,0)","v":0}]
[null,"5. Housing Stability (SDOH)",null,{"$f":"_xlfn.XLOOKUP(C11,Sheet1!C23:C25,Sheet1!D23:D25,0)","v":0}]
[null,"6. Access Barriers (SDOH)",null,{"$f":"_xlfn.XLOOKUP(C12,Sheet1!C26:C29,Sheet1!D26:D29,0)","v":0}]
[null,"7. Social Support",null,{"$f":"_xlfn.XLOOKUP(C13,Sheet1!C30:C33,Sheet1!D30:D33,0)","v":0}]
[null,"8. Functional Status (ADLs/IADLs)",null,{"$f":"_xlfn.XLOOKUP(C14,Sheet1!C34:C37,Sheet1!D34:D37,0)","v":0}]
[null,"9. Engagement Level",null,{"$f":"_xlfn.XLOOKUP(C15,Sheet1!C38:C41,Sheet1!D38:D41,0)","v":0}]
[null,"10. Recent Care Transitions",null,{"$f":"_xlfn.XLOOKUP(C16,Sheet1!C42:C45,Sheet1!D42:D45,0)","v":0}]
[]
[null,"Total Score",null,{"$f":"SUM(D7:D16)","v":0}]
[]
[null,"Acuity Level \n& Interpretation",null,{"$f":"IF(AND('Acuity Level Calculator'!D18>0,'Acuity Level Calculator'!D18<10),\"Low Acuity\",IF(AND('Acuity Level Calculator'!D18>9,'Acuity Level Calculator'!D18<20),\"Moderate Acuity\",IF('Acuity Level Calculator'!D18>19,\"High Acuity\",\"\")))","v":""}]
[{"$nulls":3},{"$f":"IF(D20=\"Low Acuity\",Sheet1!D3,IF(D20=\"Moderate Acuity\",Sheet1!D4,IF(D20=\"High Acuity\",Sheet1!D5,\"\")))","v":""}]

{"sheet":"Sheet1","index":1,"n_rows":45,"n_cols":4,"rows_kept":45,"hidden":true,"merged":[[0,1,0,4]]}
[null,"Acuity Level Thresholds"]
[null,"Total Score","Acuity Level","Interpretation"]
[null,"0–9","Low Acuity","Stable, minimal ECM support needed (self-sufficient)"]
[null,"10–19","Moderate Acuity","At risk, requires monitoring and coordination"]
[null,"20–30","High Acuity","Unstable, requires intensive ECM intervention"]
[null,"Categories","Criteria","Points"]
[null,"1. Clinical Complexity","Stable or no chronic conditions",0]
[null,null,"1–2 conditions, controlled",1]
[null,null,"Multiple conditions or partially controlled",2]
[null,null,"Multiple conditions, uncontrolled/unstable",3]
[null,"2. Behavioral Health","No behavioral health conditions",0]
[null,null,"Mild (anxiety, depression)",1]
[null,null,"Moderate (interferes with functioning)",2]
[null,null,"SMI or active SUD impacting care",3]
[null,"3. Utilization (past 6–12 months)","No ED/IP use",0]
[null,null,"1 ED visit",1]
[null,null,"2–3 ED visits OR 1 hospitalization",2]
[null,null,"≥2 hospitalizations OR ≥3 ED visits",3]
[null,"4. Medication Management","Adherent, stable regimen",0]
[null,null,"Minor adherence issues",1]
[null,null,"Multiple meds, some non-adherence",2]
[null,null,"Polypharmacy + frequent changes / poor adherence",3]
[null,"5. Housing Stability (SDOH)","Stable housing",0]
[null,null,"At risk (temporary/doubled up)",2]
[null,null,"Homeless or unstable housing",3]
[null,"6. Access Barriers (SDOH)","No barriers",0]
[null,null,"One barrier (transportation, food, cost)",1]
[null,null,"Multiple barriers",2]
[null,null,"Severe barriers preventing care access",3]
[null,"7. Social Support","Strong support system",0]
[null,null,"Limited support",1]
[null,null,"Minimal or unreliable support",2]
[null,null,"No support system",3]
[null,"8. Functional Status (ADLs/IADLs)","Fully independent",0]
[null,null,"Needs some assistance",1]
[null,null,"Moderate impairment",2]
[null,null,"Dependent in ADLs/IADLs",3]
[null,"9. Engagement Level","Highly engaged",0]
[null,null,"Occasionally misses contact",1]
[null,null,"Inconsistent engagement",2]
[null,null,"Difficult to reach / disengaged",3]
[null,"10. Recent Care Transitions","No recent transitions",0]
[null,null,"Routine follow-up needed",1]
[null,null,"Recent discharge, moderate risk",2]
[null,null,"High-risk discharge / poor follow-up",3]