{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Cancer-Required","Diabetes-Required","Depression-Required","HIV-Required","Additional-Option (1)","Additional-Option (2)","Data List","Description of Proposed Changes","Data"],"not_rendered":{"macros":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":69,"n_cols":2,"rows_kept":69,"merged":[[0,1,0,17],[2,1,2,15],[4,1,4,15],[5,1,5,15],[8,1,8,15],[10,1,10,15],[12,1,12,17],[14,1,14,15],[16,1,16,17],[18,1,18,17],[20,1,20,17],[23,1,23,15],[25,1,25,15],[27,1,27,15],[30,1,30,15],[32,1,32,15],[33,1,33,15],[34,1,34,15],[37,1,37,15],[39,1,39,15],[41,1,41,15],[43,1,43,15],[45,1,45,15],[47,1,47,15],[48,1,48,15],[50,1,50,15],[52,1,52,15],[54,1,54,15],[56,1,56,15],[58,1,58,15],[60,1,60,15],[64,1,64,16],[66,1,66,17],[68,1,68,17]]}
[null,"Instructions for Completing the Annual Chronic Disease Management Report                                                                                                                                                       Do not make any entries other than those specified below. Do not alter the template or formulas."]
[]
[null,"This report is due annually by the first (1st) calendar day of the month of June following the year being reported. The Managed Care Plan must have a process in place to identify every new individual with special health care needs within ninety (90) calendar days of enrollment, beginning the first of the month after the month of enrollment.\nPlease click \"Enable Content\" to utilize all functions of the template."]
[]
[]
[null,"\nThe Managed Care Plan shall offer CDM programs for the following four chronic conditions:                                                                                                                                                                                          (1) Cancer and cancer prevention. (2) Diabetes and diabetes prevention. (3) Depression and depression prevention (including suicide prevention). (4) Human Immunodeficiency Virus (HIV) acquired immunodeficiency syndrome (AIDS), and HIV prevention.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    The Managed Care Plan shall offer two (2) additional Chronic Disease Management programs to be selected from: (a) chronic kidney disease (CKD). (b) Dementia. (c) End State Renal Disease (ESRD). (d) Hypertension. (e) Osteoporosis.  (f) Parkinson’s Disease.                                                                                                                                                                                                                                                For the Managed Care Plan not offering Enhanced Case Management or a Specialty enhancement, one or more of the following: Anxiety, ADHD, Bipolar disorder, and SUD.  "]
[]
[]
[null,"Managed Care Plan Information"]
[]
[null,"Column B4 - Health Plan Name: Enter the complete managed care plan name."]
[]
[null,"Column B5 - Benefit Type: Enter the managed care plan's benefit type. (\"LTC\", \"MMA\", \"Specialty Product\")"]
[]
[null,"Column B6 - Managed Care Plan 7-Digit Medicaid ID: Enter the managed care plan's seven (7)-digit Medicaid identification number."]
[]
[null,"Column B7 - Reporting Year: Enter the reporting year."]
[]
[null,"Column B8 - Report Submission Date: Enter the date the managed care plan submitted the report in the following format: MM/DD/YYYY."]
[]
[null,"Column B9 - Report Submitted By: Enter the first name and last name (ONLY) of the managed care plan's contact individual for this report. Exclude titles, \"Sr\", \"Jr\", \"2nd\", etc."]
[]
[]
[null,"Column K4 - Total Number of Enrollees with chronic conditions by type: (Cancer, Diabetes, Depression, HIV/AIDS, and Optional CDM Programs)."]
[]
[null,"Column K5 - Total number of enrollees with chronic conditions by type participating in the CDM program: (Cancer, Diabetes, Depression, HIV/AIDS, Optional Programs), how many of each disease group are participating in the CDM program."]
[]
[null,"Column K6 - Percent of enrollees with chronic conditions by type participating in the CDM program: (Cancer, Diabetes, Depression, HIV/AIDS, Optional Programs). PLEASE DO NOT ALTER THE FORMULA. This column automatically calculates the percentage of enrollees with cancer participating in the CDM program"]
[]
[]
[null,"Column K7 - Total number of enrollees with chronic conditions by type receiving interventions: (Cancer, Diabetes, Depression, HIV/AIDS, Optional Programs),  how many of each disease group are receiving interventions.  "]
[]
[null,"Column K8 - Total number of providers participating in the program:  Count the total number of providers participating in the program. e.g.; add oncologists plus nurses plus psychiatrist plus endocrinologists to obtain the total number of providers."]
[null,"Column K9 - Total number of providers by type participating in the CDM program:  Add the total number of the selected providers in the column N row 6 to 17."]
[null,"Column K10 - Percent of providers by type participating in the CDM program: PLEASE DO NOT ALTER THE FORMULA. This column automatically calculates the percentage of providers by type participating in the CDM program"]
[]
[]
[null,"Column A - Enrollee Last Name: Enter the enrollee's last name."]
[]
[null,"Column B - Enrollee First Name: Enter the enrollee's first name."]
[]
[null,"Column C - Medicaid ID: Enter the enrollee's ten (10)-digit Medicaid ID number."]
[]
[null,"Column D - Program Enrollment Date (Cancer, Diabetes, Depression, HIV/AIDS, Optional Programs): Enter the enrollment date in the following format: MM/DD/YYYY."]
[]
[null,"Column E, F & G - Participants Clinical and Demographic Characteristics: Clinical and demographic characteristics of the CDM participants compared to the CDM target population (e.g., age group, gender, geographic region).Use drop-down menu."]
[]
[null,"Column H - Enrollees Receiving Interventions Y/N: Enter Yes or No and make the notation in the comments for specific reasons if no interventions."]
[null," Column I - Intervention Types Implemented: Interventions may include: provider education, enrollee education, medication adherence, rewards and incentives program, care coordination, enrollee outreach, caregiver engagement, outreach to providers, home visits, case management, promotion of lifestyle changes, community partnerships. Use drop-down menu. Choose all that are applicable.  (If you do not see the Intervention Types Implemented listed in the drop-down menu, please choose \"Other\" and type the Intervention Types Implemented in Column Q under \"Comments.\" )"]
[]
[null,"Column J - Enrollees Barriers: Health care team issues, communication issues, non-adherence, technology issues, medication issues, support system issues, transportation issues, financial issues, decline in clinical condition, external factors, knowledge deficit. Use drop-down menu. Choose all that are applicable. (If you do not see the Enrollee Barriers listed in the drop-down menu, please choose \"Other\" and type the Enrollee Barriers in Column Q under \"Comments.\" )"]
[]
[null,"Column K - Strategies Used to Address/Mitigate Barriers: Culturally appropriate materials, new provider relationships or communication methods, new information technology solutions or new relationships with CBOs. Use drop-down menu. Choose all that are applicable.(If you do not see the Strategies Used to Address/Mitigate Barriers listed in the drop-down menu, please choose \"Other\" and type the Strategies Used to Address/Mitigate Barriers in Column Q under \"Comments.\" )"]
[]
[null,"Column L -Changes to Best Practices Producing Health Outcome Improvements: Any changes to best practices producing positive health outcomes that the Managed Care Plan learned in conducting the CDM program. Provide additional documents if needed. Naming Convention for additional documentation: XXXyyyyCDMAttachment#“, where “XXX” is the managed care plan’s three-character identifier, “yyyy” corresponds to the four-digit year and two-digit month of the submission, “CDM” is the three-character identifier for this report, and Attachment #(1,2,3, etc...)"]
[]
[null,"Column M, N, O, P - Summarize the quantitative and qualitative results from the CDM program quarterly reports (Quarter 1,2,3,4): Use the results of the quantitative and qualitative data from the CDM quarterly report showing trends in quality indicators, comparison of quality indicators to target goal, and comparison of quality indicators to state or national standards or benchmarks."]
[]
[null,"Column N-4 - Total number of providers by type participating in the program-Enter in the table beginning column N rows 6 to 17 the providers by type participating in the program. The percentage of these providers will be automatically calculated. Please make sure the total number in the column K row 9 be the same as in the column O row 18."]
[]
[null,"Column Q - Comments: Use this column to provide any clarification if the member is not receiving CDM interventions."]
[]
[]
[]
[null,"Additional Option (1): Use this tab to name one of the two additional chronic diseases selected. See descriptive chart at the top of this instruction page. Change the name of the Worksheet tab and replace the Additional Option wording to the condition chosen (Ex:Anxiety disorders, Bipolar disorder, Cardiovascular Disease, etc...) "]
[]
[null,"Additional Option (2): Use this tab to name the second additional chronic disease selected. See descriptive chart at the top of this instruction page. Change the name of the Worksheet tab and replace the Additional Option wording to the condition chosen (Ex:Anxiety disorders, Bipolar disorder, Cardiovascular Disease, etc...) "]
[]
[null,"Description of the Changes Tab: Provide a description of proposed changes to the CDM program for the upcoming year. For each disease description entry is 250 characters only. Provide additional documents if needed. Naming Convention for additional documentation: XXXyyyyCDMAttachment#“, where “XXX” is the managed care plan’s three-character identifier, “yyyy” corresponds to the four-digit reporting year of the submission, “CDM” is the three-character identifier for this report, and Attachment #(1,2,3, etc...)"]

{"sheet":"Cancer-Required","index":1,"n_rows":21,"n_cols":17,"rows_kept":21,"merged":[[0,0,0,10],[1,0,1,10],[3,1,3,2],[3,6,3,9],[3,13,4,14],[4,1,4,2],[4,6,4,9],[5,1,5,2],[5,6,5,9],[6,1,6,2],[6,6,6,9],[7,1,7,2],[7,6,7,9],[8,1,8,2],[8,6,8,9],[9,6,9,9],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,19,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,19,15],[19,16,20,16],[21,12,36,12],[21,13,36,13],[21,14,36,14],[21,15,36,15]]}
["Chronic Disease Management Program (CDM) Annual Report"]
["Cancer"]
[]
["Health Plan Name:",{"$nulls":5},"Total number of enrollees with cancer",{"$nulls":6},"Total number of providers by type participating in the CDM program",null,"Percent of providers by type participating in the CDM program"]
["Benefit Type:",{"$nulls":5},"Total number of enrollees with cancer participating in the CDM program"]
["Plan 7-Digit Medicaid ID:",{"$nulls":5},"Percent of enrollees with cancer participating in the CDM program",{"$nulls":3},{"$f":"IF(K4=\"\",\"\",K5/K4)","v":""},null,null,"Oncology Dr",null,{"$f":"IF(O6=\"\",\"\",O6/O18)","v":""}]
["Reporting Year:",{"$nulls":5},"Total number of enrollees with cancer receiving interventions",{"$nulls":6},"Psychiatrist",null,{"$f":"IF(O7=\"\",\"\",O7/O18)","v":""}]
["Report Submission Date:",{"$nulls":5},"Total number of providers participating in the program",{"$nulls":6},"Therapist"]
["Report Submitted By:",{"$nulls":5},"Total number of providers by type participating in the CDM program",{"$nulls":6},"Endocrinology",null,{"$f":"IF(O9=\"\",\"\",O9/O18)","v":""}]
[{"$nulls":6},"Percent of providers by type participating in the CDM program",{"$nulls":3},{"$f":"IF(K8=\"\",\"\",K9/K8)","v":""},null,null,"Psychology",null,{"$f":"IF(O10=\"\",\"\",O10/O18)","v":""}]
[{"$nulls":13},"Nurses",null,{"$f":"IF(O11=\"\",\"\",O11/O18)","v":""}]
[{"$nulls":13},"Radiology",null,{"$f":"IF(O12=\"\",\"\",O12/O18)","v":""}]
[{"$nulls":13},"Internal Medicine Dr",null,{"$f":"IF(O13=\"\",\"\",O13/O18)","v":""}]
[{"$nulls":13},"Infectious Disease",null,{"$f":"IF(O14=\"\",\"\",O14/O18)","v":""}]
[{"$nulls":13},"PCP",null,{"$f":"IF(O15=\"\",\"\",O15/O18)","v":""}]
[{"$nulls":13},"Mental Health ",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Other",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Total",{"$f":"IF(SUM(O6:O17)=0,\"\",SUM(O6:O17))","v":""}]
[]
["Enrollee Last Name","Enrollee First Name","Medicaid ID    ","Enrollment Date","Participants' Clinical and Demographic Characteristics ",null,null,"Enrollees Receiving Interventions Y/N"," Intervention Types Implemented","Barriers","Strategies Used to Address/Mitigate Barriers","Changes to Best Practices Producing Health Outcome Improvements","Summarize the quantitative and qualitative results from the CDM Program quarterly reports",{"$nulls":3},"Comments "]
[{"$nulls":4},"Gender","Age Group","Region",{"$nulls":5},"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]

{"sheet":"Diabetes-Required","index":2,"n_rows":21,"n_cols":17,"rows_kept":21,"merged":[[0,0,0,10],[1,0,1,10],[3,1,3,2],[3,6,3,9],[3,13,4,14],[4,1,4,2],[4,6,4,9],[5,1,5,2],[5,6,5,9],[6,1,6,2],[6,6,6,9],[7,1,7,2],[7,6,7,9],[8,1,8,2],[8,6,8,9],[9,6,9,9],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,19,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,19,15],[19,16,20,16],[21,12,36,12],[21,13,36,13],[21,14,36,14],[21,15,36,15]]}
["Chronic Disease Management Program (CDM) Annual Report"]
["Diabetes"]
[]
["Specialty Plan Name:",{"$nulls":5},"Total number of enrollees with diabetes",{"$nulls":6},"Total number of providers by type participating in the CDM program",null,"Percent of providers by type participating in the CDM program"]
["Benefit Type:",{"$nulls":5},"Total number of enrollees with diabetes participating in the CDM program"]
["Plan 7-Digit Medicaid ID:",{"$nulls":5},"Percent of enrollees with diabetes participating in the CDM program",{"$nulls":3},{"$f":"IF(K4=\"\",\"\",K5/K4)","v":""},null,null,"Oncology Dr",null,{"$f":"IF(O6=\"\",\"\",O6/O18)","v":""}]
["Reporting Year:",{"$nulls":5},"Total number of enrollees with diabetes receiving interventions",{"$nulls":6},"Psychiatrist",null,{"$f":"IF(O7=\"\",\"\",O7/O18)","v":""}]
["Report Submission Date:",{"$nulls":5},"Total number of providers participating in the program",{"$nulls":6},"Therapist",null,{"$f":"IF(O8=\"\",\"\",O8/O18)","v":""}]
["Report Submitted By:",{"$nulls":5},"Total number of providers by type participating in the CDM program",{"$nulls":6},"Endocrinology",null,{"$f":"IF(O9=\"\",\"\",O9/O18)","v":""}]
[{"$nulls":6},"Percent of providers by type participating in the CDM program",{"$nulls":3},{"$f":"IF(K8=\"\",\"\",K9/K8)","v":""},null,null,"Psychology",null,{"$f":"IF(O10=\"\",\"\",O10/O18)","v":""}]
[{"$nulls":13},"Nurses",null,{"$f":"IF(O11=\"\",\"\",O11/O18)","v":""}]
[{"$nulls":13},"Radiology",null,{"$f":"IF(O12=\"\",\"\",O12/O18)","v":""}]
[{"$nulls":13},"Internal Medicine Dr",null,{"$f":"IF(O13=\"\",\"\",O13/O18)","v":""}]
[{"$nulls":13},"Infectious Disease",null,{"$f":"IF(O14=\"\",\"\",O14/O18)","v":""}]
[{"$nulls":13},"PCP",null,{"$f":"IF(O15=\"\",\"\",O15/O18)","v":""}]
[{"$nulls":13},"Mental Health ",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Other",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Total"]
[]
["Enrollee Last Name","Enrollee First Name","Medicaid ID    ","Enrollment Date","Participants' Clinical and Demographic Characteristics ",null,null,"Enrollees Receiving Interventions Y/N"," Intervention Types Implemented","Barriers","Strategies Used to Address/Mitigate Barriers","Changes to Best Practices Producing Health Outcome Improvements","Summarized the quantitative and qualitative results from the CDM Proram quarterly reports",{"$nulls":3},"Comments "]
[{"$nulls":4},"Gender","Age Group","Region",{"$nulls":5},"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]

{"sheet":"Depression-Required","index":3,"n_rows":21,"n_cols":17,"rows_kept":21,"merged":[[0,0,0,10],[1,0,1,10],[3,1,3,2],[3,6,3,9],[3,13,4,14],[4,1,4,2],[4,6,4,9],[5,1,5,2],[5,6,5,9],[6,1,6,2],[6,6,6,9],[7,1,7,2],[7,6,7,9],[8,1,8,2],[8,6,8,9],[9,6,9,9],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,19,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,19,15],[19,16,20,16],[21,12,36,12],[21,13,36,13],[21,14,36,14],[21,15,36,15]]}
["Chronic Disease Management Program (CDM) Annual Report"]
["Depression"]
[]
["Specialty Plan Name:",{"$nulls":5},"Total number of enrollees with depression",{"$nulls":6},"Total number of providers by type participating in the CDM program",null,"Percent of providers by type participating in the CDM program"]
["Benefit Type:",{"$nulls":5},"Total number of enrollees with depression participating in the CDM program"]
["Plan 7-Digit Medicaid ID:",{"$nulls":5},"Percent of enrollees with depression participating in the CDM program",{"$nulls":3},{"$f":"IF(K4=\"\",\"\",K5/K4)","v":""},null,null,"Oncology Dr",null,{"$f":"IF(O6=\"\",\"\",O6/O18)","v":""}]
["Reporting Year:",{"$nulls":5},"Total number of enrollees with depression receiving interventions",{"$nulls":6},"Psychiatrist",null,{"$f":"IF(O7=\"\",\"\",O7/O18)","v":""}]
["Report Submission Date:",{"$nulls":5},"Total number of providers participating in the program",{"$nulls":6},"Therapist",null,{"$f":"IF(O8=\"\",\"\",O8/O18)","v":""}]
["Report Submitted By:",{"$nulls":5},"Total number of providers by type participating in the CDM program",{"$nulls":6},"Endocrinology",null,{"$f":"IF(O9=\"\",\"\",O9/O18)","v":""}]
[{"$nulls":6},"Percent of providers by type participating in the CDM program",{"$nulls":3},{"$f":"IF(K8=\"\",\"\",K9/K8)","v":""},null,null,"Psychology",null,{"$f":"IF(O10=\"\",\"\",O10/O18)","v":""}]
[{"$nulls":13},"Nurses",null,{"$f":"IF(O11=\"\",\"\",O11/O18)","v":""}]
[{"$nulls":13},"Radiology",null,{"$f":"IF(O12=\"\",\"\",O12/O18)","v":""}]
[{"$nulls":13},"Internal Medicine Dr",null,{"$f":"IF(O13=\"\",\"\",O13/O18)","v":""}]
[{"$nulls":13},"Infectious Disease",null,{"$f":"IF(O14=\"\",\"\",O14/O18)","v":""}]
[{"$nulls":13},"PCP",null,{"$f":"IF(O15=\"\",\"\",O15/O18)","v":""}]
[{"$nulls":13},"Mental Health ",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Other",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Total",{"$f":"IF(SUM(O6:O17)=0,\"\",SUM(O6:O17))","v":""}]
[]
["Enrollee Last Name","Enrollee First Name","Medicaid ID    ","Enrollment Date","Participants' Clinical and Demographic Characteristics ",null,null,"Enrollees Receiving Interventions Y/N"," Intervention Types Implemented","Barriers","Strategies Used to Address/Mitigate Barriers","Changes to Best Practices Producing Health Outcome Improvements","Summarized the quantitative and qualitative results from the CDM Proram quarterly reports",{"$nulls":3},"Comments "]
[{"$nulls":4},"Gender","Age Group","Region",{"$nulls":5},"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]

{"sheet":"HIV-Required","index":4,"n_rows":21,"n_cols":17,"rows_kept":21,"merged":[[0,0,0,10],[1,0,1,10],[3,1,3,2],[3,6,3,9],[3,13,4,14],[4,1,4,2],[4,6,4,9],[5,1,5,2],[5,6,5,9],[6,1,6,2],[6,6,6,9],[7,1,7,2],[7,6,7,9],[8,1,8,2],[8,6,8,9],[9,6,9,9],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,19,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,19,15],[19,16,20,16],[21,12,36,12],[21,13,36,13],[21,14,36,14],[21,15,36,15]]}
["Chronic Disease Management Program (CDM) Annual Report"]
["HIV"]
[]
["Specialty Plan Name:",{"$nulls":5},"Total number of enrollees with HIV",{"$nulls":6},"Total number of providers by type participating in the CDM program",null,"Percent of providers by type participating in the CDM program"]
["Benefit Type:",{"$nulls":5},"Total number of enrollees with HIV participating in the CDM program"]
["Plan 7-Digit Medicaid ID:",{"$nulls":5},"Percent of enrollees with HIV participating in the CDM program",{"$nulls":3},{"$f":"IF(K4=\"\",\"\",K5/K4)","v":""},null,null,"Oncology Dr",null,{"$f":"IF(O6=\"\",\"\",O6/O18)","v":""}]
["Reporting Year:",{"$nulls":5},"Total number of enrollees with HIV receiving interventions",{"$nulls":6},"Psychiatrist",null,{"$f":"IF(O7=\"\",\"\",O7/O18)","v":""}]
["Report Submission Date:",{"$nulls":5},"Total number of providers participating in the program",{"$nulls":6},"Therapist",null,{"$f":"IF(O8=\"\",\"\",O8/O18)","v":""}]
["Report Submitted By:",{"$nulls":5},"Total number of providers by type participating in the CDM program",{"$nulls":6},"Endocrinology",null,{"$f":"IF(O9=\"\",\"\",O9/O18)","v":""}]
[{"$nulls":6},"Percent of providers by type participating in the CDM program",{"$nulls":3},{"$f":"IF(K8=\"\",\"\",K9/K8)","v":""},null,null,"Psychology",null,{"$f":"IF(O10=\"\",\"\",O10/O18)","v":""}]
[{"$nulls":13},"Nurses",null,{"$f":"IF(O11=\"\",\"\",O11/O18)","v":""}]
[{"$nulls":13},"Radiology",null,{"$f":"IF(O12=\"\",\"\",O12/O18)","v":""}]
[{"$nulls":13},"Internal Medicine Dr",null,{"$f":"IF(O13=\"\",\"\",O13/O18)","v":""}]
[{"$nulls":13},"Infectious Disease",null,{"$f":"IF(O14=\"\",\"\",O14/O18)","v":""}]
[{"$nulls":13},"PCP",null,{"$f":"IF(O15=\"\",\"\",O15/O18)","v":""}]
[{"$nulls":13},"Mental Health ",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Other",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Total",{"$f":"IF(SUM(O6:O17)=0,\"\",SUM(O6:O17))","v":""}]
[]
["Enrollee Last Name","Enrollee First Name","Medicaid ID    ","Enrollment Date","Participants' Clinical and Demographic Characteristics ",null,null,"Enrollees Receiving Interventions Y/N"," Intervention Types Implemented","Barriers","Strategies Used to Address/Mitigate Barriers","Changes to Best Practices Producing Health Outcome Improvements","Summarized the quantitative and qualitative results from the CDM Proram quarterly reports",{"$nulls":3},"Comments "]
[{"$nulls":4},"Gender","Age Group","Region",{"$nulls":5},"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]

{"sheet":"Additional-Option (1)","index":5,"n_rows":24,"n_cols":17,"rows_kept":24,"merged":[[0,0,0,10],[1,0,1,10],[3,1,3,2],[3,6,3,9],[3,13,4,14],[4,1,4,2],[4,6,4,9],[5,1,5,2],[5,6,5,9],[6,1,6,2],[6,6,6,9],[7,1,7,2],[7,6,7,9],[8,1,8,2],[8,6,8,9],[9,6,9,9],[19,0,20,10],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,22,6],[22,7,23,7],[22,8,23,8],[22,9,23,9],[22,10,23,10],[22,11,23,11],[22,12,22,15],[22,16,23,16],[24,12,39,12],[24,13,39,13],[24,14,39,14],[24,15,39,15]]}
["Chronic Disease Management Program (CDM) Annual Report"]
["\"Additional Option (1)\""]
[]
["Specialty Plan Name:",{"$nulls":5},"Total number of enrollees with \"Additional Option (1)\"",{"$nulls":6},"Total number of providers by type participating in the CDM program",null,"Percent of providers by type participating in the CDM program"]
["Benefit Type:",{"$nulls":5},"Total number of enrollees with Additional Option (1) participating in the CDM program"]
["Plan 7-Digit Medicaid ID:",{"$nulls":5},"Percent of enrollees with \"Additional Option (1)\" participating in the CDM program",{"$nulls":3},{"$f":"IF(K4=\"\",\"\",K5/K4)","v":""},null,null,"Oncology Dr",null,{"$f":"IF(O6=\"\",\"\",O6/O18)","v":""}]
["Reporting Year:",{"$nulls":5},"Total number of enrollees with \"Additional Option (1)\" receiving interventions",{"$nulls":6},"Psychiatrist",null,{"$f":"IF(O7=\"\",\"\",O7/O18)","v":""}]
["Report Submission Date:",{"$nulls":5},"Total number of providers participating in the program",{"$nulls":6},"Therapist",null,{"$f":"IF(O8=\"\",\"\",O8/O18)","v":""}]
["Report Submitted By:",{"$nulls":5},"Total number of providers by type participating in the CDM program",{"$nulls":6},"Endocrinology",null,{"$f":"IF(O9=\"\",\"\",O9/O18)","v":""}]
[{"$nulls":6},"Percent of providers by type participating in the CDM program",{"$nulls":3},{"$f":"IF(K8=\"\",\"\",K9/K8)","v":""},null,null,"Psychology",null,{"$f":"IF(O10=\"\",\"\",O10/O18)","v":""}]
[{"$nulls":13},"Nurses",null,{"$f":"IF(O11=\"\",\"\",O11/O18)","v":""}]
[{"$nulls":13},"Radiology",null,{"$f":"IF(O12=\"\",\"\",O12/O18)","v":""}]
[{"$nulls":13},"Internal Medicine Dr",null,{"$f":"IF(O13=\"\",\"\",O13/O18)","v":""}]
[{"$nulls":13},"Infectious Disease",null,{"$f":"IF(O14=\"\",\"\",O14/O18)","v":""}]
[{"$nulls":13},"PCP",null,{"$f":"IF(O15=\"\",\"\",O15/O18)","v":""}]
[{"$nulls":13},"Mental Health ",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Other",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Total",{"$f":"IF(SUM(O6:O17)=0,\"\",SUM(O6:O17))","v":""}]
[]
["Select a minimum of two (2) additional CDM: (1) Anxiety disorders. (2) Bipolar disorder.(3) Cardiovascular Disease.(4) Chronic Kidney Disease.(5) Chronic Obstructive Pulmonary Disease.(6) Dementia.(7) End State Renal Disease.(8) Hypertension. (9) Osteoporosis. (10) Parkinson’s Disease. (11) Substance use disorders.  See instructions for the Managed Care Plan not offering Enhanced Case Management or a Specialty enhancement.    "]
[]
[]
["Enrollee Last Name","Enrollee First Name","Medicaid ID    ","Enrollment Date","Participants' Clinical and Demographic Characteristics ",null,null,"Enrollees Receiving Interventions Y/N"," Intervention Types Implemented","Barriers","Strategies Used to Address/Mitigate Barriers","Changes to Best Practices Producing Health Outcome Improvements","Summarized the quantitative and qualitative results from the CDM Proram quarterly reports",{"$nulls":3},"Comments "]
[{"$nulls":4},"Gender","Age Group","Region",{"$nulls":5},"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]

{"sheet":"Additional-Option (2)","index":6,"n_rows":24,"n_cols":17,"rows_kept":24,"merged":[[0,0,0,10],[1,0,1,10],[3,1,3,2],[3,6,3,9],[3,13,4,14],[4,1,4,2],[4,6,4,9],[5,1,5,2],[5,6,5,9],[6,1,6,2],[6,6,6,9],[7,1,7,2],[7,6,7,9],[8,1,8,2],[8,6,8,9],[9,6,9,9],[19,0,20,10],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,22,6],[22,7,23,7],[22,8,23,8],[22,9,23,9],[22,10,23,10],[22,11,23,11],[22,12,22,15],[22,16,23,16],[24,12,39,12],[24,13,39,13],[24,14,39,14],[24,15,39,15]]}
["Chronic Disease Management Program (CDM) Annual Report"]
["\"Additional Option (2)\""]
[]
["Specialty Plan Name:",{"$nulls":5},"Total number of enrollees with \"Additional Option (2)\"",{"$nulls":6},"Total number of providers by type participating in the CDM program",null,"Percent of providers by type participating in the CDM program"]
["Benefit Type:",{"$nulls":5},"Total number of enrollees with \"Additional Option (2)\" participating in the CDM program"]
["Plan 7-Digit Medicaid ID:",{"$nulls":5},"Percent of enrollees with \"Additional Option (2)\" participating in the CDM program",{"$nulls":3},{"$f":"IF(K4=\"\",\"\",K5/K4)","v":""},null,null,"Oncology Dr",null,{"$f":"IF(O6=\"\",\"\",O6/O18)","v":""}]
["Reporting Year:",{"$nulls":5},"Total number of enrollees with \"Additional Option (2)\" receiving interventions",{"$nulls":6},"Psychiatrist",null,{"$f":"IF(O7=\"\",\"\",O7/O18)","v":""}]
["Report Submission Date:",{"$nulls":5},"Total number of providers participating in the program",{"$nulls":6},"Therapist",null,{"$f":"IF(O8=\"\",\"\",O8/O18)","v":""}]
["Report Submitted By:",{"$nulls":5},"Total number of providers by type participating in the CDM program",{"$nulls":6},"Endocrinology",null,{"$f":"IF(O9=\"\",\"\",O9/O18)","v":""}]
[{"$nulls":6},"Percent of providers by type participating in the CDM program",{"$nulls":3},{"$f":"IF(K8=\"\",\"\",K9/K8)","v":""},null,null,"Psychology",null,{"$f":"IF(O10=\"\",\"\",O10/O18)","v":""}]
[{"$nulls":13},"Nurses",null,{"$f":"IF(O11=\"\",\"\",O11/O18)","v":""}]
[{"$nulls":13},"Radiology",null,{"$f":"IF(O12=\"\",\"\",O12/O18)","v":""}]
[{"$nulls":13},"Internal Medicine Dr",null,{"$f":"IF(O13=\"\",\"\",O13/O18)","v":""}]
[{"$nulls":13},"Infectious Disease",null,{"$f":"IF(O14=\"\",\"\",O14/O18)","v":""}]
[{"$nulls":13},"PCP",null,{"$f":"IF(O15=\"\",\"\",O15/O18)","v":""}]
[{"$nulls":13},"Mental Health ",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Other",null,{"$f":"IF(O17=\"\",\"\",O17/O18)","v":""}]
[{"$nulls":13},"Total",{"$f":"IF(SUM(O6:O17)=0,\"\",SUM(O6:O17))","v":""}]
[]
["Select a minimum of two (2) additional CDM: (1) Anxiety disorders. (2) Bipolar disorder.(3) Cardiovascular Disease.(4) Chronic Kidney Disease.(5) Chronic Obstructive Pulmonary Disease.(6) Dementia.(7) End State Renal Disease.(8) Hypertension. (9) Osteoporosis. (10) Parkinson’s Disease. (11) Substance use disorders.  See instructions for the Managed Care Plan not offering Enhanced Case Management or a Specialty enhancement.    "]
[]
[]
["Enrollee Last Name","Enrollee First Name","Medicaid ID    ","Enrollment Date","Participants' Clinical and Demographic Characteristics ",null,null,"Enrollees Receiving Interventions Y/N"," Intervention Types Implemented","Barriers","Strategies Used to Address/Mitigate Barriers","Changes to Best Practices Producing Health Outcome Improvements","Summarized the quantitative and qualitative results from the CDM Proram quarterly reports",{"$nulls":3},"Comments "]
[{"$nulls":4},"Gender","Age Group","Region",{"$nulls":5},"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]

{"sheet":"Data List","index":7,"n_rows":74,"n_cols":1,"rows_kept":74,"hidden":true}
["Name"]
["Endocrinology"]
["Infectious Disease"]
["Internal Medicine Dr"]
["Mental Health "]
["Nurses"]
["Oncology Dr"]
["Other"]
["PCP"]
["Providers by Type"]
["Psychiatrist"]
["Psychology"]
["Radiology"]
["Therapist"]
[]
[]
["M"]
["F"]
["Other"]
[]
["0-21"]
["22-44"]
["45 & Older"]
[]
[]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
["I"]
[]
["Y"]
["N"]
[]
[]
["Name"]
["Care coordination"]
["Caregiver engagement"]
["Case management"]
["Community partnerships"]
["Enrollee education"]
["Enrollee outreach"]
["Home visits"]
["Medication adherence"]
["Outreach to providers"]
["Promotion of lifestyle changes"]
["Provider education"]
["Rewards and incentives program"]
["Other"]
[]
["Name"]
["Communication issues"]
["Decline in clinical condition"]
["External factors"]
["Financial issues"]
["Healthcare team issues"]
["Knowledge deficit"]
["Medication issues"]
["Non-adherence"]
["Support system issues"]
["Technology issues"]
["Transportation issues"]
["Other"]
[]
["Name"]
["Culturally appropriate materials"]
["Information technology solutions"]
["Provider relationships"]
["Relationships with CBOs"]
["Other"]

{"sheet":"Description of Proposed Changes","index":8,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[0,0,1,16],[2,0,3,4],[2,5,3,16],[4,0,5,4],[4,5,5,16],[6,0,7,4],[6,5,7,16],[8,0,9,4],[8,5,9,16],[10,0,11,4],[10,5,11,16],[12,0,13,4],[12,5,13,16],[14,0,15,4],[14,5,15,16],[16,0,17,4],[16,5,17,16],[18,0,19,4],[18,5,19,16],[20,0,21,4],[20,5,21,16],[22,0,23,4],[22,5,23,16],[24,0,25,4],[24,5,25,16],[26,0,27,4],[26,5,27,16],[28,0,29,4],[28,5,29,16],[30,0,31,4],[30,5,31,16]]}
["Description of Proposed Changes to the CDM for the Upcoming year."]
[]
[" Chronic Conditions",{"$nulls":4},"Description"]
[]
["Cancer and cancer prevention"]
[]
["Diabetes and diabetes prevention"]
[]
["Depression and depression prevention (including suicide prevention)."]
[]
["HIV, AIDS, and HIV prevention."]
[]
["Chronic Kidney Disease"]
[]
["Dementia"]
[]
["End State Renal Disease (ESRD)"]
[]
["Hypertension"]
[]
["Osteoporosis"]
[]
["Parkinson’s Disease"]
[]
["Anxiety disorders"]
[]
[" (ADHD)"]
[]
["Bipolar disorder"]
[]
["Substance use disorders"]

{"sheet":"Data","index":9,"n_rows":5,"n_cols":2,"rows_kept":5,"hidden":true}
[]
[]
[null,"Comprehensive LTC Plan/LTC Plus Plan"]
[null,"MMA HMO, MMA Capitated PSN, MMA Specialty Plan"]
[null,"Dental Health Plan"]