{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["A.1. Provider Information","B.1. Trial Balance","B.2. Trial Balance Crisis","B.3. Trial Balance Reclass","B.4. Trial Balance Adjustments","C.1. Anticipated Costs","D.1. Indirect Cost Allocation","A.2. Allocation Descriptions","E.1. Daily Visits PPS-1","E.2. Monthly Visits PPS-2","E.3. Daily Visits PPS-3","E.4. Monthly Visits PPS-4","A.3. Services Provided","A.4. Comments","F.1. CC PPS-1 Rate","F.2. CC PPS-2 Rate","F.3. CC PPS-3 Rate","F.4. CC PPS-4 Rate","A.5. Certification"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":74,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"A.1. Provider Information","index":0,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,0,1,10],[69,0,69,6],[0,0,0,10],[15,5,15,6],[16,2,16,10],[15,2,15,3],[39,7,39,8],[7,0,7,2],[15,8,15,10],[14,8,14,10],[17,3,17,10],[13,2,13,10],[14,2,14,6],[25,1,25,9],[31,7,31,10],[20,6,20,10],[8,0,8,10],[33,7,33,8],[34,7,34,8],[35,7,35,8],[4,6,4,10],[5,6,5,10],[7,3,7,10],[10,0,10,2],[87,0,87,10],[2,3,2,10],[3,3,3,10],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[6,3,6,10],[12,0,12,10],[55,0,55,10],[22,0,22,9],[18,3,18,10],[66,5,66,10],[54,0,54,10],[40,7,40,8],[43,7,43,8],[37,7,37,8],[83,7,83,8],[2,0,2,2],[85,7,85,8],[79,7,79,8],[80,7,80,8],[86,0,86,10],[11,0,11,10],[53,0,53,10],[72,7,72,8],[71,7,71,8],[70,7,70,8],[69,7,69,8],[51,9,51,10],[47,7,47,8],[48,7,48,8],[49,7,49,8],[62,3,62,10],[60,2,60,10],[59,8,59,10],[59,2,59,3],[59,5,59,6],[52,6,52,10],[56,0,56,9],[45,2,45,6],[46,2,46,6],[47,2,47,6],[63,6,63,10],[64,6,64,10],[76,7,76,8],[44,2,44,6],[84,7,84,8],[50,7,50,10],[50,1,50,6],[65,6,65,10],[81,7,81,8],[78,0,78,6],[61,3,61,10],[75,7,75,8],[74,7,74,8],[73,7,73,8],[58,8,58,10],[82,7,82,8],[78,7,78,8],[57,2,57,10],[58,2,58,6],[48,2,48,6],[49,2,49,6],[46,7,46,8],[67,7,67,10],[38,7,38,8],[42,7,42,8],[45,7,45,8],[19,6,19,10],[28,0,28,10],[44,7,44,8],[33,0,33,6],[36,7,36,8],[43,2,43,6],[23,1,23,9],[24,1,24,9],[26,1,26,9],[27,1,27,9],[29,6,29,10],[29,1,29,5],[30,1,30,4],[31,1,31,6],[32,1,32,10],[34,2,34,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[9,7,9,10],[9,0,9,3],[42,0,42,6],[30,5,30,10],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,1,41,10],[10,3,10,10],[17,1,17,2]]}
["CCBHC Cost Report"]
["This top section is for Medicaid ID, NPI, reporting period, and rate period, and will be automatically populated in all other tabs. Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:"]
["NPI:"]
["REPORTING PERIOD:",null,null,"From:",null,"To:"]
["RATE PERIOD:",null,null,"From:",null,"To:"]
["WORKSHEET:",null,null,"Provider Information"]
["PPS METHODOLOGY:"]
["This box for state use only - LEAVE BLANK"]
["Select type of oversight:",null,null,null,null," Audited ",null,"Desk Reviewed"]
["Date reviewed:"]
["Part 1 is for single site or consolidated information.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - PROVIDER INFORMATION (Consolidated)"]
[1,"Name:"]
[2,"Street:",null,null,null,null,null,"P.O. Box: "]
[3,"City:",null,null,"State: ",null,null,"Zip Code:"]
[4,"County:"]
[5,"Medicaid ID:",null,{"$f":"IF(D3=\"\",\"\",D3)","v":""}]
[6,"NPI:",null,{"$f":"IF(D4=\"\",\"\",D4)","v":""}]
[7,"Location designation (see Cost Report Instructions):"]
[8,"Organizational authority (see Cost Report Instructions):"]
[9,"Behavioral health professionals (see Cost Report Instructions):"]
["Name\n    1",null,null,null,null,null,null,null,null,null,"NPI\n2"]
["9a"]
["9b"]
["9c"]
["9d"]
["9e"]
[]
[10,"Is the CCBHC dually certified as a 1905(a)(9) clinic?"]
[11,"Does the site operate as other than CCBHC?"]
[12,"If line 11 is \"Yes\", specify the type of operation (e.g., clinic, FQHC, other):"]
[13,"Identify days and hours the site operates as a CCBHC by listing the time next to the applicable day:"]
["Days",null,null,null,null,null,null,"Hours of Operation \nFrom",null,"Hours of Operation \nTo","Total Hours"]
["13a                     ",null,"Sunday"]
["13b                     ",null,"Monday"]
["13c                     ",null,"Tuesday"]
["13d                     ",null,"Wednesday"]
["13e                     ",null,"Thursday"]
["13f                       ",null,"Friday"]
["13g                     ",null,"Saturday"]
[14,"Identify days and hours the site operates as other than a CCBHC by listing the time next to the applicable day: "]
["Days",null,null,null,null,null,null,"Hours of Operation \nFrom",null,"Hours of Operation \nTo","Total Hours"]
["14a                     ",null,"Sunday"]
["14b                     ",null,"Monday"]
["14c                     ",null,"Tuesday"]
["14d                     ",null,"Wednesday"]
["14e                     ",null,"Thursday"]
["14f                       ",null,"Friday"]
["14g                     ",null,"Saturday"]
[15,"List any excluded satellite facilities and reasons for exclusion. Use the Comments Sheet for additional details."]
["16.      Is this site filing a consolidated cost report for multiple locations?  If yes, see Cost Report Instructions. "]
["17.      How many sites are reported for the consolidated entity?",null,null,null,null,null," "]
["Part 2 is for reporting specific information for each site.  Copy and complete this section for each site reported and include as an attachment.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - PROVIDER INFORMATION FOR CLINICS FILING UNDER CONSOLIDATED COST REPORTING (For additional satellite sites, create new tab and copy and paste Part 2 for each additional site included)"]
["Site-Specific Information"]
["1.        Was this site in existence before April 1, 2014?  (No payment will be made to satellite facilities of CCBHCs established \n            after April 1, 2014)."]
["2.        Name:"]
["3.        Street:",null,null,null,null,null,null,"P.O. Box: "]
["4.        City:",null,null,null,"State: ",null,null,"Zip Code:"]
["5.        County:"]
["6.        Medicaid ID:"]
["7.        NPI:"]
["8.        Location designation (see Cost Report Instructions):"]
["9.        Organizational authority  (see Cost Report Instructions):"]
["10.      Is the CCBHC dually certified as a 1905(a)(9) clinic?"]
["11.      Does the site operate as other than CCBHC? "]
["12.      If line 11 is \"Yes\", specify the type of operation (e.g., clinic, FQHC, other):"]
["13.      Identify days and hours the site operates as a CCBHC by listing the time next to the applicable day"]
["Days",null,null,null,null,null,null,"Hours of Operation \nFrom",null,"Hours of Operation \nTo","Total Hours"]
["13a                     Sunday"]
["13b                     Monday"]
["13c                     Tuesday"]
["13d                     Wednesday"]
["13e                     Thursday"]
["13f                       Friday"]
["13g                     Saturday"]
["14.      Identify days and hours the site operates as other than a CCBHC by listing the time next to the applicable day"]
["Days",null,null,null,null,null,null,"Hours of Operation \nFrom",null,"Hours of Operation \nTo","Total Hours"]
["14a                     Sunday"]
["14b                     Monday"]
["14c                     Tuesday"]
["14d                     Wednesday"]
["14e                     Thursday"]
["14f                       Friday"]
["14g                     Saturday"]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"B.1. Trial Balance","index":1,"n_rows":104,"n_cols":12,"rows_kept":104,"cut":false,"hidden":false,"merged":[[54,0,54,11],[48,0,48,11],[49,1,49,2],[50,0,50,11],[67,1,67,2],[70,0,70,11],[51,1,51,2],[52,1,52,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[90,1,90,2],[72,0,72,2],[80,0,80,11],[98,1,98,2],[97,0,97,11],[68,0,68,11],[91,0,91,11],[76,1,76,2],[77,1,77,2],[69,1,69,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[0,0,0,11],[8,0,8,11],[2,2,2,11],[3,2,3,11],[6,2,6,11],[4,5,4,11],[5,5,5,11],[1,0,1,11],[7,0,7,11],[103,0,103,11],[11,0,11,2],[95,0,95,11],[33,0,33,11],[41,0,41,11],[57,0,57,2],[56,0,56,11],[71,0,71,11],[89,0,89,2],[86,0,86,11],[34,0,34,2],[42,0,42,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[85,0,85,11],[87,0,87,11],[94,0,94,11],[82,0,82,11],[102,0,102,11],[29,1,29,2],[36,0,36,11],[37,1,37,2],[38,0,38,11],[9,0,9,11],[40,0,40,11],[53,0,53,11],[55,0,55,11],[32,0,32,11],[30,0,30,11],[10,0,10,11],[81,1,81,2],[92,1,92,2],[93,0,93,11],[99,0,99,11],[96,0,96,2],[88,0,88,11],[78,1,78,2],[79,1,79,2],[83,1,83,2],[84,1,84,2],[100,1,100,2],[101,1,101,2],[31,1,31,2],[35,1,35,2],[39,1,39,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Trial Balance"]
["Part 1 is for entering direct costs for CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - DIRECT CCBHC EXPENSES"]
["Part 1A is for entering direct CCBHC staff costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1A - CCBHC STAFF COSTS"]
["Description",null,null,"\nCompensation\n\n1","\nOther\n\n2","Total\n(Col. 1 + 2)\n\n3","Reclassifications\n\n4","Reclassified Trial Balance \n(Col. 3 + 4)\n5","Adjustments\nIncreases\n(Decreases)\n6","Adjusted Amount\n(Col. 5 + 6)\n7","Adjustments for Anticipated Cost Changes\n8","Net \nExpenses\n(Col. 7 + 8)\n9"]
[1,"Psychiatrist",null,null,null,{"$f":"SUM(D13:E13)","v":0},null,{"$f":"F13+G13","v":0},null,{"$f":"H13+I13","v":0},{"$f":"'C.1. Anticipated Costs'!E13-'C.1. Anticipated Costs'!F13","v":0},{"$f":"J13+K13","v":0}]
[2,"Psychiatric nurse",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E14-'C.1. Anticipated Costs'!F14","v":0},0]
[3,"Child psychiatrist",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E15-'C.1. Anticipated Costs'!F15","v":0},0]
[4,"Adolescent psychiatrist",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E16-'C.1. Anticipated Costs'!F16","v":0},0]
[5,"Substance abuse specialist",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E17-'C.1. Anticipated Costs'!F17","v":0},0]
[6,"Case manager",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E18-'C.1. Anticipated Costs'!F18","v":0},0]
[7,"Recovery coach",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E19-'C.1. Anticipated Costs'!F19","v":0},0]
[8,"Peer specialist",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E20-'C.1. Anticipated Costs'!F20","v":0},0]
[9,"Family support specialist",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E21-'C.1. Anticipated Costs'!F21","v":0},0]
[10,"Licensed clinical social worker",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E22-'C.1. Anticipated Costs'!F22","v":0},0]
[11,"Licensed mental health counselor",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E23-'C.1. Anticipated Costs'!F23","v":0},0]
[12,"Mental health professional (trained and credentialed for psychological testing)",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E24-'C.1. Anticipated Costs'!F24","v":0},0]
[13,"Licensed marriage and family therapist",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E25-'C.1. Anticipated Costs'!F25","v":0},0]
[14,"Occupational therapist",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E26-'C.1. Anticipated Costs'!F26","v":0},0]
[15,"Interpreter or linguistic counselor",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E27-'C.1. Anticipated Costs'!F27","v":0},0]
[16,"General practice (performing CCBHC services)",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E28-'C.1. Anticipated Costs'!F28","v":0},0]
[17,"Subtotal other staff costs (specify details in Comments tab)"]
["17a",null,null,null,null,{"$f":"SUM(D30:E30)","v":0},null,{"$f":"F30+G30","v":0},null,{"$f":"H30+I30","v":0},{"$f":"'C.1. Anticipated Costs'!E30-'C.1. Anticipated Costs'!F30","v":0},{"$f":"J30+K30","v":0}]
["      "]
[18,"Subtotal staff costs (sum of lines 1-17)",null,{"$f":"SUM(D13:D31)","v":0},0,0,0,0,0,0,0,0]
["Part 1B is for entering direct CCBHC costs under agreement.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1B - CCBHC COSTS UNDER AGREEMENT"]
["Description",null,null,"\nCompensation\n\n1","\nOther\n\n2","Total\n(Col. 1 + 2)\n\n3","\nReclassifications\n\n4","Reclassified Trial Balance \n(Col. 3 + 4)\n5","Adjustments\nIncreases\n(Decreases)\n6","Adjusted Amount\n(Col. 5 + 6)\n7","Adjustments for Anticipated Cost Changes\n8","Net \nExpenses\n(Col. 7 + 8)\n9"]
[19,"CCBHC costs from DCO",null,"This cell is left intentionally blank.",null,{"$f":"SUM(D36:E36)","v":0},null,{"$f":"F36+G36","v":0},null,{"$f":"H36+I36","v":0},{"$f":"'C.1. Anticipated Costs'!E36-'C.1. Anticipated Costs'!F36","v":0},{"$f":"J36+K36","v":0}]
["20.       Other CCBHC costs (specify details below)",null,null,"This cell is left intentionally blank.",null,{"$f":"SUM(D37:E37)","v":0},null,{"$f":"F37+G37","v":0},null,{"$f":"H37+I37","v":0},null,{"$f":"J37+K37","v":0}]
["20a",null,null,null,null,{"$f":"SUM(D38:E38)","v":0},null,{"$f":"F38+G38","v":0},null,{"$f":"H38+I38","v":0},{"$f":"'C.1. Anticipated Costs'!E38-'C.1. Anticipated Costs'!F38","v":0},{"$f":"J38+K38","v":0}]
["      "]
[21,"Subtotal costs under agreement (sum of lines 19-20)",null,"This cell is left intentionally blank.",{"$f":"SUM(E36:E39)","v":0},0,0,0,0,0,0,0]
["Part 1C is for entering other direct CCBHC costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1C - OTHER DIRECT CCBHC COSTS"]
["Description",null,null,"\nCompensation\n\n1","\nOther\n\n2","Total\n(Col. 1 + 2)\n\n3","\nReclassifications\n\n4","Reclassified Trial Balance \n(Col. 3 + 4)\n5","Adjustments\nIncreases\n(Decreases)\n6","Adjusted Amount\n(Col. 5 + 6)\n7","Adjustments for Anticipated Cost Changes\n8","Net \nExpenses\n(Col. 7 + 8)\n9"]
[22,"Medical supplies",null,"This cell is left intentionally blank.",null,{"$f":"SUM(D44:E44)","v":0},null,{"$f":"F44+G44","v":0},null,{"$f":"H44+I44","v":0},{"$f":"'C.1. Anticipated Costs'!E44-'C.1. Anticipated Costs'!F44","v":0},{"$f":"J44+K44","v":0}]
[23,"Transportation (health care staff)",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E45-'C.1. Anticipated Costs'!F45","v":0},0]
[24,"Depreciation - medical equipment",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E46-'C.1. Anticipated Costs'!F46","v":0},0]
[25,"Professional liability insurance",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E47-'C.1. Anticipated Costs'!F47","v":0},0]
[26,"Telehealth ",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E48-'C.1. Anticipated Costs'!F48","v":0},0]
["27.       Other direct costs not already included (specify details below)",null,null,"This cell is left intentionally blank.",null,0,null,0,null,0,null,0]
["27a",null,null,"This cell is left intentionally blank.",null,{"$f":"SUM(D50:E50)","v":0},null,{"$f":"F50+G50","v":0},null,{"$f":"H50+I50","v":0},{"$f":"'C.1. Anticipated Costs'!E50-'C.1. Anticipated Costs'!F50","v":0},0]
["      "]
[28,"Subtotal other direct CCBHC costs (sum of lines 22-27)",null,"This cell is left intentionally blank.",{"$f":"SUM(E44:E51)","v":0},0,0,0,0,0,0,0]
[29,"Total cost of CCBHC services (other than overhead) \n(sum of lines 18, 21, and 28)",null,{"$f":"SUM(D32,D40,D52)","v":0},0,0,0,0,0,0,0,0]
["Part 2 is for entering indirect costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - INDIRECT COSTS"]
["Part 2A is for entering indirect facility costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2A - SITE COSTS"]
["Description",null,null,"\nCompensation\n\n1","\nOther\n\n2","Total\n(Col. 1 + 2)\n\n3","\nReclassifications\n\n4","Reclassified Trial Balance \n(Col. 3 + 4)\n5","Adjustments\nIncreases\n(Decreases)\n6","Adjusted Amount\n(Col. 5 + 6)\n7","Adjustments for Anticipated Cost Changes\n8","Net \nExpenses\n(Col. 7 + 8)\n9"]
[30,"Rent",null,"This cell is left intentionally blank.",null,{"$f":"SUM(D59:E59)","v":0},null,{"$f":"F59+G59","v":0},null,{"$f":"H59+I59","v":0},{"$f":"'C.1. Anticipated Costs'!E59-'C.1. Anticipated Costs'!F59","v":0},{"$f":"J59+K59","v":0}]
[31,"Insurance",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E60-'C.1. Anticipated Costs'!F60","v":0},0]
[32,"Interest on mortgage or loans",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E61-'C.1. Anticipated Costs'!F61","v":0},0]
[33,"Utilities",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E62-'C.1. Anticipated Costs'!F62","v":0},0]
[34,"Depreciation - buildings and fixtures",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E63-'C.1. Anticipated Costs'!F63","v":0},0]
[35,"Depreciation - equipment",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E64-'C.1. Anticipated Costs'!F64","v":0},0]
[36,"Housekeeping and maintenance",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E65-'C.1. Anticipated Costs'!F65","v":0},0]
[37,"Property tax",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E66-'C.1. Anticipated Costs'!F66","v":0},0]
[38,"Subtotal other site costs (specify details in Comments tab)"]
["38a",null,null,null,null,{"$f":"SUM(D68:E68)","v":0},null,{"$f":"F68+G68","v":0},null,{"$f":"H68+I68","v":0},{"$f":"'C.1. Anticipated Costs'!E68-'C.1. Anticipated Costs'!F68","v":0},{"$f":"J68+K68","v":0}]
[]
[39,"Subtotal site costs \n(sum of lines 30-38)",null,{"$f":"SUM(D59:D69)","v":0},0,0,0,0,0,0,0,0]
["Part 2B is for entering indirect administrative costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2B - ADMINISTRATIVE COSTS"]
["Description",null,null,"\nCompensation\n\n1","\nOther\n\n2","Total\n(Col. 1 + 2)\n\n3","\nReclassifications\n\n4","Reclassified Trial Balance \n(Col. 3 + 4)\n5","Adjustments\nIncreases\n(Decreases)\n6","Adjusted Amount\n(Col. 5 + 6)\n7","Adjustments for Anticipated Cost Changes\n8","Net \nExpenses\n(Col. 7 + 8)\n9"]
[40,"Office salaries ",null,null,null,{"$f":"SUM(D74:E74)","v":0},null,{"$f":"F74+G74","v":0},null,{"$f":"H74+I74","v":0},{"$f":"'C.1. Anticipated Costs'!E74-'C.1. Anticipated Costs'!F74","v":0},{"$f":"J74+K74","v":0}]
[41,"Depreciation - office equipment",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E75-'C.1. Anticipated Costs'!F75","v":0},0]
[42,"Office supplies",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E76-'C.1. Anticipated Costs'!F76","v":0},0]
[43,"Legal",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E77-'C.1. Anticipated Costs'!F77","v":0},0]
[44,"Accounting",null,null,null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E78-'C.1. Anticipated Costs'!F78","v":0},0]
[45,"Insurance",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E79-'C.1. Anticipated Costs'!F79","v":0},0]
[46,"Telephone",null,"This cell is left intentionally blank.",null,0,null,0,null,0,{"$f":"'C.1. Anticipated Costs'!E80-'C.1. Anticipated Costs'!F80","v":0},0]
["47.       Other administrative costs (specify details below)",null,null,null,null,0,null,0,null,0,null,0]
["47a",null,null,null,null,{"$f":"SUM(D82:E82)","v":0},null,{"$f":"F82+G82","v":0},null,{"$f":"H82+I82","v":0},{"$f":"'C.1. Anticipated Costs'!E82-'C.1. Anticipated Costs'!F82","v":0},{"$f":"J82+K82","v":0}]
[]
[48,"Subtotal administrative costs \n(sum of lines 40-47)",null,{"$f":"SUM(D74:D83)","v":0},0,0,0,0,0,0,0,0]
[49,"Total overhead \n(sum of lines 39 and 48)",null,{"$f":"SUM(D70,D84)","v":0},0,0,0,0,0,0,0,0]
["Part 3 is for entering direct costs for non-CCBHC services. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 3 - DIRECT COSTS FOR NON-CCBHC SERVICES"]
["Part 3A is for entering direct costs for non-CCBHC services. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 3A - DIRECT COSTS FOR SERVICES OTHER THAN CCHBC SERVICES"]
["Description",null,null,"\nCompensation\n\n1","\nOther\n\n2","Total\n(Col. 1 + 2)\n\n3","\nReclassifications\n\n4","Reclassified Trial Balance \n(Col. 3 + 4)\n5","Adjustments\nIncreases\n(Decreases)\n6","Adjusted Amount\n(Col. 5 + 6)\n7","Adjustments for Anticipated Cost Changes\n8","Net \nExpenses\n(Col. 7 + 8)\n9"]
[50,"998 costs outside the reimbursement rate",null,null,null,{"$f":"SUM(D91:E91)","v":0},null,{"$f":"F91+G91","v":0},null,{"$f":"H91+I91","v":0},{"$f":"'C.1. Anticipated Costs'!E91-'C.1. Anticipated Costs'!F91","v":0},{"$f":"J91+K91","v":0}]
["51.       Direct costs for non-CCBHC services covered by Medicaid  (specify details below)",null,null,null,null,{"$f":"SUM(D92:E92)","v":0},null,{"$f":"F92+G92","v":0},null,{"$f":"H92+I92","v":0},null,{"$f":"J92+K92","v":0}]
["51a",null,null,null,null,{"$f":"SUM(D93:E93)","v":0},null,{"$f":"F93+G93","v":0},null,{"$f":"H93+I93","v":0},{"$f":"'C.1. Anticipated Costs'!E93-'C.1. Anticipated Costs'!F93","v":0},{"$f":"J93+K93","v":0}]
[]
["Part 3B is for entering direct costs that are for non-reimbursable services. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 3B - NON-REIMBURSABLE COSTS"]
["Description",null,null,"\nCompensation\n\n1","\nOther\n\n2","Total\n(Col. 1 + 2)\n\n3","\nReclassifications\n\n4","Reclassified Trial Balance \n(Col. 3 + 4)\n5","Adjustments\nIncreases\n(Decreases)\n6","Adjusted Amount\n(Col. 5 + 6)\n7","Adjustments for Anticipated Cost Changes\n8","Net \nExpenses\n(Col. 7 + 8)\n9"]
["52.       Direct costs for non-CCBHC services not covered by Medicaid (specify details below)",null,null,null,null,{"$f":"SUM(D98:E98)","v":0},null,{"$f":"F98+G98","v":0},null,{"$f":"H98+I98","v":0},null,{"$f":"J98+K98","v":0}]
["52a",null,null,null,null,{"$f":"SUM(D99:E99)","v":0},null,{"$f":"F99+G99","v":0},null,{"$f":"H99+I99","v":0},{"$f":"'C.1. Anticipated Costs'!E99-'C.1. Anticipated Costs'!F99","v":0},{"$f":"J99+K99","v":0}]
[]
[53,"Total costs for non-CCBHC services (sum of lines 50-52)",null,{"$f":"SUM(D91:D100)","v":0},{"$f":"SUM(E91:E100)","v":0},0,0,0,0,0,0,0]
[54,"Total costs \n(sum of lines 29, 49, and 53)",null,{"$f":"+D101+D85+D53","v":0},0,0,0,0,0,0,0,0]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"B.2. Trial Balance Crisis","index":2,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,0,11,2],[0,0,0,7],[1,0,1,7],[2,2,2,7],[3,2,3,7],[4,5,4,7],[5,5,5,7],[6,2,6,7],[7,0,7,7],[8,0,8,7],[9,0,9,7],[10,0,10,7],[23,1,23,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[29,1,29,2],[30,0,30,7],[31,1,31,2],[32,0,32,7],[33,0,33,7],[34,0,34,2],[28,0,28,7],[47,1,47,2],[36,0,36,7],[37,1,37,2],[38,0,38,7],[39,1,39,2],[40,0,40,7],[41,0,41,7],[42,0,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[54,0,54,7],[55,0,55,7],[48,0,48,7],[49,1,49,2],[50,0,50,7],[51,1,51,2],[52,1,52,2],[53,1,53,2]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Trial Balance"]
["Part 1 is for entering direct costs for CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - DIRECT CCBHC EXPENSES"]
["Part 1A is for entering direct CCBHC staff costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1A - CCBHC STAFF COSTS"]
["Description",null,null,"Mobile Crisis 9813\n\n1","Mobile Crisis Non-9813\n\n2","Crisis Stabilization\n\n3","Non-Crisis PPS\n\n4","Total\n(Col. 1 + 2 + 3 + 4)\n\n5"]
[1,"Psychiatrist",null,null,null,null,null,{"$f":"SUM(D13:G13)","v":0}]
[2,"Psychiatric nurse",null,null,null,null,null,0]
[3,"Child psychiatrist",null,null,null,null,null,0]
[4,"Adolescent psychiatrist",null,null,null,null,null,0]
[5,"Substance abuse specialist",null,null,null,null,null,0]
[6,"Case manager",null,null,null,null,null,0]
[7,"Recovery coach",null,null,null,null,null,0]
[8,"Peer specialist",null,null,null,null,null,0]
[9,"Family support specialist",null,null,null,null,null,0]
[10,"Licensed clinical social worker",null,null,null,null,null,0]
[11,"Licensed mental health counselor",null,null,null,null,null,0]
[12,"Mental health professional (trained and credentialed for psychological testing)",null,null,null,null,null,0]
[13,"Licensed marriage and family therapist",null,null,null,null,null,0]
[14,"Occupational therapist",null,null,null,null,null,0]
[15,"Interpreter or linguistic counselor",null,null,null,null,null,0]
[16,"General practice (performing CCBHC services)",null,null,null,null,null,0]
["17.       Subtotal other staff costs (specify details in Comments tab)"]
["17a",{"$f":"IF('B.1. Trial Balance'!B30=\"\",\"\",'B.1. Trial Balance'!B30)","v":""},null,null,null,null,null,{"$f":"SUM(D30:G30)","v":0}]
["      Additional lines inserted via Trial Balance tab"]
[18,"Subtotal staff costs (sum of lines 1-17)",null,{"$f":"SUM(D13:D31)","v":0},0,0,0,{"$f":"SUM(H13:H31)","v":0}]
["Part 1B is for entering direct CCBHC costs under agreement.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1B - CCBHC COSTS UNDER AGREEMENT"]
["Description",null,null,"Mobile Crisis 9813\n\n1","Mobile Crisis Non-9813\n\n2","Crisis Stabilization\n\n3","Non-Crisis PPS\n\n4","Total\n(Col. 1 + 2 + 3 + 4)\n\n5"]
[19,"CCBHC costs from DCO",null,null,null,null,null,{"$f":"SUM(D36:G36)","v":0}]
["20.       Other CCBHC costs (specify details below)",null,null,"This cell is left intentionally blank.",null,{"$f":"SUM(D37:E37)","v":0},null,{"$f":"F37+G37","v":0}]
["20a",{"$f":"IF('B.1. Trial Balance'!B38=\"\",\"\",'B.1. Trial Balance'!B38)","v":""},null,null,null,null,null,{"$f":"SUM(D38:G38)","v":0}]
["      Additional lines inserted via Trial Balance tab"]
[21,"Subtotal costs under agreement (sum of lines 19-20)",null,{"$f":"SUM(D36:D39)","v":0},{"$f":"SUM(E36:E39)","v":0},{"$f":"SUM(F36:F39)","v":0},{"$f":"SUM(G36:G39)","v":0},{"$f":"SUM(H36:H39)","v":0}]
["Part 1C is for entering other direct CCBHC costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1C - OTHER DIRECT CCBHC COSTS"]
["Description",null,null,"Mobile Crisis 9813\n\n1","Mobile Crisis Non-9813\n\n2","Crisis Stabilization\n\n3","Non-Crisis PPS\n\n4","Total\n(Col. 1 + 2 + 3 + 4)\n\n5"]
[22,"Medical supplies",null,null,null,null,null,{"$f":"SUM(D44:G44)","v":0}]
[23,"Transportation (health care staff)",null,null,null,null,null,0]
[24,"Depreciation - medical equipment",null,null,null,null,null,0]
[25,"Professional liability insurance",null,null,null,null,null,0]
[26,"Telehealth ",null,null,null,null,null,0]
["27.       Other direct costs not already included (specify details below)",null,null,"This cell is left intentionally blank.",null,{"$f":"SUM(D49:E49)","v":0},null,{"$f":"F49+G49","v":0}]
["27a",{"$f":"IF('B.1. Trial Balance'!B50=\"\",\"\",'B.1. Trial Balance'!B50)","v":""},null,null,null,null,null,{"$f":"SUM(D50:G50)","v":0}]
["      Additional lines inserted via Trial Balance tab"]
[28,"Subtotal other direct CCBHC costs (sum of lines 22-27)",null,{"$f":"SUM(D44:D51)","v":0},{"$f":"SUM(E44:E51)","v":0},{"$f":"SUM(F44:F51)","v":0},{"$f":"SUM(G44:G51)","v":0},{"$f":"SUM(H44:H51)","v":0}]
[29,"Total cost of CCBHC services (other than overhead) \n(sum of lines 18, 21, and 28)",null,{"$f":"SUM(D32,D40,D52)","v":0},{"$f":"SUM(E32,E40,E52)","v":0},{"$f":"SUM(F32,F40,F52)","v":0},{"$f":"SUM(G32,G40,G52)","v":0},{"$f":"SUM(H32,H40,H52)","v":0}]
[30,"Percentage of Costs by Service",null,{"$f":"IFERROR(D53/$H$53,0)","v":0},{"$f":"IFERROR(E53/$H$53,0)","v":0},{"$f":"IFERROR(F53/$H$53,0)","v":0},{"$f":"IFERROR(G53/$H$53,0)","v":0},{"$f":"SUM(D54:G54)","v":0}]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"B.3. Trial Balance Reclass","index":3,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[44,0,44,9],[43,1,43,3],[45,0,45,3],[26,1,26,3],[33,1,33,3],[42,1,42,3],[41,1,41,3],[40,1,40,3],[39,1,39,3],[38,1,38,3],[27,1,27,3],[32,1,32,3],[31,1,31,3],[30,1,30,3],[29,1,29,3],[28,1,28,3],[48,0,48,9],[2,0,2,1],[46,0,46,9],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[9,1,9,3],[10,1,10,3],[8,0,8,3],[16,1,16,3],[17,1,17,3],[7,0,7,9],[18,1,18,3],[19,1,19,3],[2,2,2,9],[3,2,3,9],[4,5,4,9],[5,5,5,9],[0,0,0,9],[1,0,1,9],[47,0,47,9],[20,1,20,3],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[6,2,6,9],[37,1,37,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[36,1,36,3],[35,1,35,3],[34,1,34,3]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Trial Balance Reclassifications"]
["The bottom section is for entering detail to support the reclassification of expenses.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["Explanation of Entry",null,null,null,"Increase: Expense Category \n1","Increase: \n\nLine Number\n2","Increase: \n\nAmount*\n3","Decrease: \nExpense Category \n4","Decrease: \n\nLine Number\n5","Decrease: \n\nAmount*\n6"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["11."]
["12."]
["13."]
["14."]
["15."]
["16."]
["17."]
["18."]
["19."]
["20."]
["21."]
["22."]
["23."]
["24."]
["25."]
["26."]
["27."]
["28."]
["29."]
["30."]
["31."]
["32."]
["33."]
["34."]
["35a"]
[]
["36.       Total reclassifications \n             (sum of column 3 must equal sum of column 6)",null,null,null,"This cell is left intentionally blank.","This cell is left intentionally blank.",{"$f":"SUM(G10:G45)","v":0},"This cell is left intentionally blank.","This cell is left intentionally blank.",{"$f":"SUM(J10:J45)","v":0}]
["* Transfer to Trial Balance worksheet, column 4 as appropriate"]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"B.4. Trial Balance Adjustments","index":4,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,7],[9,0,9,3],[2,2,2,7],[3,2,3,7],[4,5,4,7],[5,5,5,7],[6,2,6,7],[3,0,3,1],[4,0,4,1],[2,0,2,1],[5,0,5,1],[6,0,6,1],[8,0,8,7],[1,0,1,7],[7,0,7,7],[45,0,45,7],[41,0,41,7],[26,0,26,3],[24,0,24,7],[42,0,42,7],[38,0,38,7],[36,0,36,7],[37,1,37,3],[43,0,43,7],[33,1,33,3],[34,1,34,3],[35,1,35,3],[39,1,39,3],[40,1,40,3],[10,1,10,3],[44,0,44,7],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[23,1,23,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[20,0,20,7],[22,0,22,7],[25,0,25,7],[32,1,32,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Trial Balance Adjustments"]
["Part 1 is for entering common adjustments.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - COMMON ADJUSTMENTS"]
["Description",null,null,null,"Basis for Adjustment*\n\n1","Amount**\n\n2","Expense Classification***\n\n3","Line Number\n\n4"]
[1,"Investment income on commingled restricted and unrestricted funds"]
[2,"Trade, quantity, and time discounts on purchases"]
[3,"Rebates and refunds of expenses"]
[4,"Rental of building or office space to others"]
[5,"Home office costs"]
[6,"Adjustment resulting from transactions with related organizations"]
[7,"Vending machines"]
[8,"Practitioner assigned by National Health Service Corps"]
[9,"Depreciation - buildings and fixtures"]
[10,"Depreciation - equipment"]
["11.       Other common adjustments (specify details below)"]
["11a"]
[]
[12,"Subtotal of common adjustments (sum of lines 1-11)",null,null,"This cell is left intentionally blank.",{"$f":"SUM(F11:F23)","v":0},"This cell is left intentionally blank.","This cell is left intentionally blank."]
["Part 2 is for entering costs not allowed.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - COSTS  NOT ALLOWED (Must be removed from allowable costs)"]
["Description",null,null,null,"Basis for Adjustment*\n\n1","Amount**\n\n2","Expense Classification***\n\n3","Line Number\n\n4"]
[13,"Bad debts",null,null,"A"]
[14,"Charitable contributions",null,null,"A"]
[15,"Entertainment costs, including costs of alcoholic beverages",null,null,"A"]
[16,"Federal, state, or local sanctions or fines",null,null,"A"]
[17,"Fund-raising costs",null,null,"A"]
[18,"Goodwill, organization costs, or other amortization",null,null,"A"]
[19,"Legal fees related to criminal investigations",null,null,"A"]
[20,"Lobbying costs",null,null,"A"]
[21,"Selling and marketing costs",null,null,"A"]
["22.       Subtotal of other costs not allowed (specify details below)",null,null,null,"A",null,"This cell is left intentionally blank.","This cell is left intentionally blank."]
["22a",null,null,null,{"$f":"E28","v":"A"}]
[]
[23,"Subtotal of costs not allowed (sum of lines 13-22)",null,null,"A",{"$f":"SUM(F28:F39)","v":0},"This cell is left intentionally blank.","This cell is left intentionally blank."]
[24,"Total Adjustments (sum of lines 12 and 23)",null,null,"This cell is left intentionally blank.",{"$f":"F40+F24","v":0},"This cell is left intentionally blank.","This cell is left intentionally blank."]
["*Basis for adjustment\nA. Costs - if cost (including applicable overhead) can be determined\nB. Amount received - if cost cannot be determined"]
["** Transfer to Trial Balance worksheet, column 6 as appropriate"]
["*** Expense classification on Trial Balance worksheet from which amount is to be deducted or to which the amount is to be added"]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"C.1. Anticipated Costs","index":5,"n_rows":105,"n_cols":7,"rows_kept":105,"cut":false,"hidden":false,"merged":[[38,0,38,6],[36,0,36,6],[37,1,37,2],[50,0,50,6],[48,0,48,6],[71,0,71,6],[72,0,72,2],[0,0,0,6],[8,0,8,6],[11,0,11,2],[10,0,10,6],[1,0,1,6],[7,0,7,6],[9,0,9,6],[30,0,30,6],[29,1,29,2],[28,0,28,6],[33,0,33,6],[6,2,6,6],[2,2,2,6],[3,2,3,6],[4,5,4,6],[5,5,5,6],[12,1,12,2],[104,0,104,6],[102,0,102,6],[88,0,88,6],[96,0,96,2],[70,0,70,6],[57,0,57,2],[56,0,56,6],[41,0,41,6],[34,0,34,2],[42,0,42,2],[54,0,54,6],[94,0,94,6],[93,0,93,6],[91,0,91,6],[103,0,103,6],[86,0,86,6],[99,0,99,6],[97,0,97,6],[98,1,98,2],[101,1,101,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[90,1,90,2],[84,1,84,2],[39,1,39,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[51,1,51,2],[52,1,52,2],[58,1,58,2],[49,1,49,2],[40,0,40,6],[53,0,53,6],[55,0,55,6],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[31,1,31,2],[35,1,35,2],[32,0,32,6],[100,1,100,2],[66,0,66,6],[67,1,67,2],[82,0,82,6],[80,0,80,6],[81,1,81,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[69,1,69,2],[73,1,73,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[83,1,83,2],[89,0,89,2],[95,0,95,6],[85,0,85,6],[87,0,87,6],[92,1,92,2],[68,0,68,6],[74,1,74,2],[75,1,75,2],[76,1,76,2]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Anticipated Costs"]
["Part 1 is for entering direct CCBHC expenses.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - DIRECT CCBHC EXPENSES"]
["Part 1A is for entering anticipated direct CCBHC staff costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1A - CCBHC STAFF COSTS"]
["Description",null,null,"Additional Required \nFull-Time Equivalent (FTE) Staff\n\n1","Additional Expense Amount\n\n2","Reduced Expense Amount\n\n3","Anticipated Changes in Costs Due to Addition of CCBHC Services*\n(Col. 2 - 3)\n\n4"]
[1,"Psychiatrist",null,null,null,null,{"$f":"E13-F13","v":0}]
[2,"Psychiatric nurse",null,null,null,null,{"$f":"E14-F14","v":0}]
[3,"Child psychiatrist",null,null,null,null,0]
[4,"Adolescent psychiatrist",null,null,null,null,0]
[5,"Substance abuse specialist",null,null,null,null,0]
[6,"Case manager",null,null,null,null,0]
[7,"Recovery coach",null,null,null,null,0]
[8,"Peer specialist",null,null,null,null,0]
[9,"Family support specialist",null,null,null,null,0]
[10,"Licensed clinical social worker",null,null,null,null,0]
[11,"Licensed mental health counselor",null,null,null,null,0]
[12,"Mental health professional (trained and credebtuaked for psychological testing)",null,null,null,null,0]
[13,"Licensed marriage and family therapist",null,null,null,null,0]
[14,"Occupational therapist",null,null,null,null,0]
[15,"Interpreters or linguistic counselor",null,null,null,null,0]
[16,"General practice (performing CCBHC services)",null,null,null,null,0]
["17.       Other staff costs (specify details below)"]
["17a",{"$f":"IF('B.1. Trial Balance'!B30=\"\",\"\",'B.1. Trial Balance'!B30)","v":""},null,null,null,null,0]
["Additional lines inserted via Trial Balance tab"]
[18,"Subtotal staff costs \n(sum of lines 1-17)",null,{"$f":"SUM(D13:D31)","v":0},{"$f":"SUM(E13:E31)","v":0},{"$f":"SUM(F13:F31)","v":0},{"$f":"SUM(G13:G31)","v":0}]
["Part 1B is for entering anticipated direct CCBHC costs under agreement.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1B - CCBHC COSTS UNDER AGREEMENT"]
["Description",null,null,"Additional Required \nFull-Time Equivalent (FTE) Staff\n\n1","Additional Expense Amount\n\n2","Reduced Expense Amount\n\n3","Anticipated Changes in Costs Due to Addition of CCBHC Services*\n(Col. 2 - 3)\n\n4"]
[19,"CCBHC costs from DCO",null,"This cell is left intentionally blank.",null,null,{"$f":"E36-F36","v":0}]
["20.       Other CCBHC costs (specify details below)",null,null,"This cell is left intentionally blank.",null,null,{"$f":"E37-F37","v":0}]
["20a",{"$f":"IF('B.1. Trial Balance'!B38=\"\",\"\",'B.1. Trial Balance'!B38)","v":""},null,"This cell is left intentionally blank.",null,null,{"$f":"E38-F38","v":0}]
["Additional lines inserted via Trial Balance tab"]
[21,"Subtotal costs under agreement \n(sum of lines 19-20)",null,"This cell is left intentionally blank.",{"$f":"SUM(E36:E39)","v":0},{"$f":"SUM(F36:F39)","v":0},{"$f":"SUM(G36:G39)","v":0}]
["Part 1C is for entering anticipated other direct CCBHC costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1C - OTHER DIRECT CCBHC COSTS"]
["Description",null,null,"Additional Required \nFull-Time Equivalent (FTE) Staff\n\n1","Additional Expense Amount\n\n2","Reduced Expense Amount\n\n3","Anticipated Changes in Costs Due to Addition of CCBHC Services*\n(Col. 2 - 3)\n\n4"]
[22,"Medical supplies",null,"This cell is left intentionally blank.",null,null,{"$f":"E44-F44","v":0}]
[23,"Transportation (health care staff)",null,"This cell is left intentionally blank.",null,null,0]
[24,"Depreciation - medical equipment",null,"This cell is left intentionally blank.",null,null,0]
[25,"Professional liability insurance",null,"This cell is left intentionally blank.",null,null,0]
[26,"Telehealth ",null,"This cell is left intentionally blank.",null,null,0]
["27.       Other direct costs not already included (specify details below)"]
["27a",{"$f":"IF('B.1. Trial Balance'!B50=\"\",\"\",'B.1. Trial Balance'!B50)","v":""},null,null,null,null,{"$f":"E50-F50","v":0}]
["Additional lines inserted via Trial Balance tab"]
[28,"Subtotal other direct CCBHC costs (sum of lines 22-27)",null,"This cell is left intentionally blank.",{"$f":"SUM(E44:E51)","v":0},{"$f":"SUM(F44:F51)","v":0},{"$f":"SUM(G44:G51)","v":0}]
[29,"Total cost of CCBHC services \n(other than overhead)\n(sum of lines 18, 21, 28)",null,{"$f":"SUM(D32,D40,D52)","v":0},{"$f":"SUM(E32,E40,E52)","v":0},{"$f":"SUM(F32,F40,F52)","v":0},{"$f":"SUM(G32,G40,G52)","v":0}]
["Part 2 is for entering indirect costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - INDIRECT COSTS"]
["Part 2A is for entering anticipated indirect facility costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2A - SITE COSTS"]
["Description",null,null,"Additional Required \nFull-Time Equivalent (FTE) Staff\n\n1","Additional Expense Amount\n\n2","Reduced Expense Amount\n\n3","Anticipated Changes in Costs Due to Addition of CCBHC Services*\n(Col. 2 - 3)\n\n4"]
[30,"Rent",null,"This cell is left intentionally blank.",null,null,{"$f":"E59-F59","v":0}]
[31,"Insurance",null,"This cell is left intentionally blank.",null,null,0]
[32,"Interest on mortgage or loans",null,"This cell is left intentionally blank.",null,null,0]
[33,"Utilities",null,"This cell is left intentionally blank.",null,null,0]
[34,"Depreciation - buildings and fixtures",null,"This cell is left intentionally blank.",null,null,0]
[35,"Depreciation - equipment",null,"This cell is left intentionally blank.",null,null,0]
[36,"Housekeeping and maintenance",null,"This cell is left intentionally blank.",null,null,0]
[37,"Property tax",null,"This cell is left intentionally blank.",null,null,0]
["38.       Other site costs (specify details below)",null,null,"This cell is left intentionally blank.",null,null,0]
["38a",{"$f":"IF('B.1. Trial Balance'!B68=\"\",\"\",'B.1. Trial Balance'!B68)","v":""},null,"This cell is left intentionally blank.",null,null,0]
["Additional lines inserted via Trial Balance tab"]
[39,"Subtotal site costs \n(sum of lines 30-38)",null,"This cell is left intentionally blank.",{"$f":"SUM(E59:E69)","v":0},{"$f":"SUM(F59:F69)","v":0},{"$f":"SUM(G59:G69)","v":0}]
["Part 2B is for entering anticipated indirect administrative costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2B - ADMINISTRATIVE COSTS"]
["Description",null,null,"Additional Required \nFull-Time Equivalent (FTE) Staff\n\n1","Additional Expense Amount\n\n2","Reduced Expense Amount\n\n3","Anticipated Changes in Costs Due to Addition of CCBHC Services*\n(Col. 2 - 3)\n\n4"]
[40,"Office salaries ",null,"This cell is left intentionally blank.",null,null,{"$f":"E74-F74","v":0}]
[41,"Depreciation - office equipment",null,"This cell is left intentionally blank.",null,null,{"$f":"E75-F75","v":0}]
[42,"Office supplies",null,"This cell is left intentionally blank.",null,null,0]
[43,"Legal",null,"This cell is left intentionally blank.",null,null,0]
[44,"Accounting",null,"This cell is left intentionally blank.",null,null,0]
[45,"Insurance",null,"This cell is left intentionally blank.",null,null,0]
[46,"Telephone",null,"This cell is left intentionally blank.",null,null,0]
["47.       Other administrative costs (specify details below)"]
["47a",{"$f":"IF('B.1. Trial Balance'!B82=\"\",\"\",'B.1. Trial Balance'!B82)","v":""},null,"This cell is left intentionally blank.",null,null,0]
["Additional lines inserted via Trial Balance tab"]
[48,"Subtotal administrative costs\n(sum of lines 40-47)",null,"This cell is left intentionally blank.",{"$f":"SUM(E74:E83)","v":0},{"$f":"SUM(F74:F83)","v":0},{"$f":"SUM(G74:G83)","v":0}]
[49,"Total overhead \n(sum of lines 39 and 48)",null,"This cell is left intentionally blank.",{"$f":"E70+E84","v":0},{"$f":"F70+F84","v":0},{"$f":"G70+G84","v":0}]
["Part 3 is for entering anticipated direct costs for non-CCBHC services. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 3 - DIRECT COSTS FOR NON-CCBHC SERVICES"]
["Part 3a is for entering anticipated direct costs for non-CCBHC services. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 3A - DIRECT COSTS FOR SERVICES OTHER THAN CCHBC SERVICES"]
["Description",null,null,"Additional Required \nFull-Time Equivalent (FTE) Staff\n\n1","Additional Expense Amount\n\n2","Reduced Expense Amount\n\n3","Anticipated Changes in Costs Due to Addition of CCBHC Services*\n(Col. 2 - 3)\n\n4"]
[50,"998 costs outside the reimbursement rate",null,null,null,null,{"$f":"E91-F91","v":0}]
["51.       Direct costs for non-CCBHC services covered by Medicaid (specify details below)"]
["51a",{"$f":"IF('B.1. Trial Balance'!B93=\"\",\"\",'B.1. Trial Balance'!B93)","v":""},null,null,null,null,{"$f":"E93-F93","v":0}]
["Additional lines inserted via Trial Balance tab"]
["Part 3B is for entering anticipated direct costs that are for non-reimbursable services. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 3B - NON-REIMBURSABLE COSTS"]
["Description",null,null,"Additional Required \nFull-Time Equivalent (FTE) Staff\n\n1","Additional Expense Amount\n\n2","Reduced Expense Amount\n\n3","Anticipated Changes in Costs Due to Addition of CCBHC Services*\n(Col. 2 - 3)\n\n4"]
["52.       Direct costs for non-CCBHC services not covered by Medicaid (specify details below)"]
["52a",{"$f":"IF('B.1. Trial Balance'!B99=\"\",\"\",'B.1. Trial Balance'!B99)","v":""},null,null,null,null,{"$f":"E99-F99","v":0}]
["Additional lines inserted via Trial Balance tab"]
[53,"Subtotal costs for non-CCBHC services (sum of 50-51)",null,"This cell is left intentionally blank.",{"$f":"SUM(E91:E94,E98:E100)","v":0},{"$f":"SUM(F91:F94,F98:F100)","v":0},{"$f":"SUM(G91:G94,G99:G100)","v":0}]
[54,"Total costs \n(sum of lines 29, 49, and 53)",null,{"$f":"SUM(D101,D85,D53)","v":0},{"$f":"+E101+E85+E53","v":0},{"$f":"+F101+F85+F53","v":0},{"$f":"+G101+G85+G53","v":0}]
["* Transfer to Trial Balance worksheet, column 8 as appropriate"]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"D.1. Indirect Cost Allocation","index":6,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,1],[3,0,3,1],[1,0,1,7],[4,0,4,1],[25,0,25,7],[26,0,26,7],[10,4,10,7],[11,5,11,7],[2,2,2,7],[3,2,3,7],[4,5,4,7],[5,0,5,1],[6,2,6,7],[6,0,6,1],[5,5,5,7],[7,0,7,7],[8,0,8,6],[9,1,9,6],[10,1,10,3],[11,1,11,4],[12,1,12,6],[13,1,13,6],[24,1,24,6],[23,1,23,6],[22,1,22,6],[21,1,21,6],[20,1,20,6],[19,1,19,6],[18,1,18,6],[17,1,17,6],[16,1,16,6],[15,1,15,6],[14,1,14,6]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Indirect Cost Allocation"]
["The bottom section is used for identifying the method for allocating indirect costs.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["Description",null,null,null,null,null,null,"This cell is left intentionally blank."]
[1,"Does the CCBHC have a indirect cost rate approved by a cognizant agency (see Cost Report Instructions)?  If no, go to line 7. "]
[2,"Which cognizant agency approved the rate?"]
[3,"Describe the base rate with respect to the indirect cost rate"]
[4,"Enter the basis amount subject to the rate agreement"]
[5,"Enter the approved rate amount"]
[6,"Calculated indirect costs allocable to CCBHC services (line 4 multiplied by line 5)",null,null,null,null,null,{"$f":"IF(H10=\"Yes\",+H13*H14,0)","v":0}]
[7,"Does the CCBHC qualify to use the federal minimum rate and elect to use the rate for all federal awards?  See instructions for qualifications.  If no, go to line 11."]
[8,"Direct costs for CCBHC services (Trial Balance, column 9, line 29)",null,null,null,null,null,{"$f":"IF(H16=\"Yes\",'B.1. Trial Balance'!L53,0)","v":0}]
[9,"Minimum rate",null,null,null,null,null,0.1]
[10,"Calculated indirect costs allocable to CCBHC services (line 8 multiplied by line 9)",null,null,null,null,null,{"$f":"IF(H16=\"Yes\",+H17*H18,0)","v":0}]
[11,"Will the CCBHC allocate indirect costs proportionally by the percentage of direct costs for CCBHC services versus total allowable costs less indirect costs?  If no, go to line 15."]
[12,"Percentage of direct costs versus total allowable direct costs (Trial Balance, column 9, line 29 divided by the sum of Trial Balance, column 9, line 29 and Trial Balance, column 9, line 52)",null,null,null,null,null,{"$f":"IF(H20=\"Yes\",IF(SUM('B.1. Trial Balance'!L53+'B.1. Trial Balance'!L101)=0,0,'B.1. Trial Balance'!L53/SUM('B.1. Trial Balance'!L53+'B.1. Trial Balance'!L101)),0)","v":0}]
[13,"Indirect costs to be allocated (Trial Balance, column 9, line 49)",null,null,null,null,null,{"$f":"+'B.1. Trial Balance'!L85","v":0}]
[14,"Calculated indirect costs allocable to CCBHC services (line 12 multiplied by line 13)",null,null,null,null,null,{"$f":"IF(H20=\"Yes\",H21*H22,0)","v":0}]
[15,"If none of the lines 1, 7, or 11 are entered as Yes, provide a thorough description of the cost allocation method used. Include attachments for descriptions and calculations. Include references to line items included in the Trial Balance tab.  Enter the amount of indirect costs allocated to providing CCBHC services here:"]
[16,"Total indirect costs allocated to CCBHC services",null,null,null,null,null,{"$f":"IF(H10=\"Yes\", H15,IF(H16=\"Yes\",H19,IF(H20=\"Yes\",H23,H24)))","v":0}]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"A.2. Allocation Descriptions","index":7,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[10,0,10,8],[11,0,18,8],[19,0,19,8],[9,0,9,8],[0,0,0,8],[8,0,8,8],[2,1,2,8],[3,1,3,8],[4,4,4,8],[5,4,5,8],[6,1,6,8],[1,0,1,8],[7,0,7,8],[20,0,27,8],[28,0,28,8],[29,0,36,8],[37,0,37,8],[38,0,45,8],[46,0,46,8],[47,0,54,8],[56,0,63,8],[64,0,64,8],[65,0,65,8],[55,0,55,8]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:","From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:","From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:","Allocation Descriptions"]
["The bottom section is used for entering the description of allocations.  The descriptions should include the tab in which the allocation is referenced, the method for allocation and the amounts allocated.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PLEASE EXPLAIN METHODS USED FOR ALLOCATING RESOURCES TO DIRECT OR INDIRECT COSTS"]
["Please describe your allocation method:"]
["PART 1A - CCBHC STAFF COSTS"]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 1B - CCBHC COSTS UNDER AGREEMENT"]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 1C - OTHER DIRECT CCBHC COSTS"]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 2A - SITE COSTS"]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 2B - ADMINISTRATIVE COSTS"]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 3A/B - DIRECT COSTS FOR SERVICES OTHER THAN CCHBC SERVICES & NON-REIMBURSABLE COSTS"]
[]
[]
[]
[]
[]
[]
[]
[]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"E.1. Daily Visits PPS-1","index":8,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,0,4,2],[4,6,4,8],[5,0,5,2],[5,6,5,8],[6,0,6,2],[6,3,6,8],[0,0,0,8],[2,3,2,8],[2,0,2,2],[3,0,3,2],[3,3,3,8],[1,0,1,8],[7,0,7,8],[8,0,8,8],[15,0,15,8],[9,0,9,7],[14,0,14,8],[10,1,10,7],[11,1,11,7],[12,1,12,7],[13,1,13,7]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,null,"Daily Visits"]
["The bottom section is used for identifying the number of days patients received CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PATIENT DEMOGRAPHICS CONSOLIDATED"]
["Include ALL visits for CCBHC services; do not limit it to those covered by Medicaid.",null,null,null,null,null,null,null,"Total Daily\nPatient Visits\n1"]
[1,"Number of daily visits for patients receiving CCBHC services provided directly from staff"]
[2,"Number of daily visits for patients receiving CCBHC services directly from DCO \n(not included above)"]
[3,"Number of additional anticipated daily visits for patients receiving CCBHC services"]
[4,"Total daily visits for patients receiving CCBHC services (sum of lines 1-3)",null,null,null,null,null,null,{"$f":"SUM(I11:I13)","v":0}]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"E.2. Monthly Visits PPS-2","index":9,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,10],[8,0,8,10],[10,0,10,2],[10,9,15,9],[16,0,16,10],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[0,0,0,10],[9,0,9,10],[2,2,2,10],[3,2,3,10],[5,5,5,10],[4,5,4,10],[6,2,6,10],[1,0,1,10],[7,0,7,10],[6,0,6,1],[5,0,5,1],[4,0,4,1],[3,0,3,1],[2,0,2,1]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Monthly Visits"]
["The bottom section is used for identifying the number of months each patient received CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PATIENT DEMOGRAPHICS CONSOLIDATED"]
["Patient demographics should be analyzed to identify Certain Conditions.  Because CC PPS-2 requires monthly detail, patient data must be aggregated by patient by month to determine eligibility for Certain Conditions.  Months should be captured for ALL CCBHC services provided; do not limit the information to Medicaid members."]
["Description",null,null,"Standard Population\nVisit Months\nAll\n1a","Standard Population\nVisit Months\nAbove the Outlier Threshold\n1b","Certain Conditions 1\nVisit Months\nAll\n2a","Certain Conditions 1\nVisit Months\nAbove the Outlier Threshold\n2b","Certain Conditions 2\nVisit Months\nAll\n3a","Certain Conditions 2\nVisit Months\nAbove the Outlier Threshold\n3b",null,"Monthly\nPatient Visit\n(Sum of col. a's)\n\nTotal"]
[1,"Describe population",null,"This cell is left intentionally blank.","This cell is left intentionally blank.",null,"This cell is left intentionally blank.",null,"This cell is left intentionally blank.",null,"This cell is left intentionally blank."]
[2,"Number of months patients received CCBHC services directly from staff",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((MOD(COLUMN(D13:J13)+1,2)>0)*(D13:J13))","v":0}]
[3,"Number of months patients received CCBHC services directly from DCO (not included above)",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((MOD(COLUMN(D14:J14)+1,2)>0)*(D14:J14))","v":0}]
[4,"Number of additional anticipated months patients received CCBHC services (not included above)",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((MOD(COLUMN(D15:J15)+1,2)>0)*(D15:J15))","v":0}]
[5,"Total months patients received CCBHC services \n(sum of lines 2-4)",null,{"$f":"SUM(D13:D15)","v":0},{"$f":"SUM(E13:E15)","v":0},{"$f":"SUM(F13:F15)","v":0},{"$f":"SUM(G13:G15)","v":0},{"$f":"SUM(H13:H15)","v":0},{"$f":"SUM(I13:I15)","v":0},null,{"$f":"SUM(K13:K15)","v":0}]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"E.3. Daily Visits PPS-3","index":10,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,2],[2,3,2,11],[3,0,3,2],[3,3,3,11],[4,0,4,2],[4,6,4,11],[5,0,5,2],[5,6,5,11],[6,0,6,2],[6,3,6,11],[13,1,13,7],[14,0,14,11],[15,0,15,11],[7,0,7,11],[8,0,8,11],[9,0,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,7]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,null,"Daily Visits"]
["The bottom section is used for identifying the number of days patients received CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PATIENT DEMOGRAPHICS CONSOLIDATED"]
["Include ALL visits for CCBHC services; do not limit it to those covered by Medicaid.",null,null,null,null,null,null,null,"Mobile Crisis \n9813\n1","Mobile Crisis \nNon-9813\n2","Crisis Stabilization\n3","Non-Crisis PPS\n4"]
[1,"Number of daily visits for patients receiving CCBHC services provided directly from staff"]
[2,"Number of daily visits for patients receiving CCBHC services directly from DCO \n(not included above)"]
[3,"Number of additional anticipated daily visits for patients receiving CCBHC services"]
[4,"Total daily visits for patients receiving CCBHC services (sum of lines 1-3)",null,null,null,null,null,null,{"$f":"SUM(I11:I13)","v":0},{"$f":"SUM(J11:J13)","v":0},{"$f":"SUM(K11:K13)","v":0},{"$f":"SUM(L11:L13)","v":0}]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"E.4. Monthly Visits PPS-4","index":11,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,1],[2,2,2,13],[3,0,3,1],[3,2,3,13],[4,0,4,1],[4,5,4,13],[5,0,5,1],[5,5,5,13],[6,0,6,1],[6,2,6,13],[7,0,7,13],[8,0,8,13],[12,0,12,2],[12,9,17,9],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[10,3,10,9],[18,0,18,13],[19,0,19,13],[9,0,9,13],[10,0,10,2],[11,0,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Monthly Visits"]
["The bottom section is used for identifying the number of months each patient received CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PATIENT DEMOGRAPHICS CONSOLIDATED"]
["Patient demographics should be analyzed to identify Certain Conditions.  Because CC PPS-2 requires monthly detail, patient data must be aggregated by patient by month to determine eligibility for Certain Conditions.  Months should be captured for ALL CCBHC services provided; do not limit the information to Medicaid members."]
[null,null,null,"Non-Crisis\n",null,null,null,null,null,null,"Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3"]
["Population",null,null,"Standard Population",null,"Condition 1",null,"Condition 2",null,null,"All","All","All"]
["Description",null,null,"Standard Population\nVisit Months\nAll\n1a","Standard Population\nVisit Months\nAbove the Outlier Threshold\n1b","Certain Conditions 1\nVisit Months\nAll\n2a","Certain Conditions 1\nVisit Months\nAbove the Outlier Threshold\n2b","Certain Conditions 2\nVisit Months\nAll\n3a","Certain Conditions 2\nVisit Months\nAbove the Outlier Threshold\n3b",null,"Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3","Monthly\nPatient Visit\n(Sum of col. a's and SCS)\n\nTotal"]
[1,"Describe population",null,"This cell is left intentionally blank.","This cell is left intentionally blank.",null,"This cell is left intentionally blank.",null,"This cell is left intentionally blank.",null,null,null,null,"This cell is left intentionally blank."]
[2,"Number of months patients received CCBHC services directly from staff",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((MOD(COLUMN(D15:J15)+1,2)>0)*(D15:J15))+SUM(K15:M15)","v":0}]
[3,"Number of months patients received CCBHC services directly from DCO (not included above)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((MOD(COLUMN(D16:J16)+1,2)>0)*(D16:J16))+SUM(K16:M16)","v":0}]
[4,"Number of additional anticipated months patients received CCBHC services (not included above)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((MOD(COLUMN(D17:J17)+1,2)>0)*(D17:J17))+SUM(K17:M17)","v":0}]
[5,"Total months patients received CCBHC services \n(sum of lines 2-4)",null,{"$f":"SUM(D15:D17)","v":0},{"$f":"SUM(E15:E17)","v":0},{"$f":"SUM(F15:F17)","v":0},{"$f":"SUM(G15:G17)","v":0},{"$f":"SUM(H15:H17)","v":0},{"$f":"SUM(I15:I17)","v":0},null,{"$f":"SUM(K15:K17)","v":0},0,0,{"$f":"SUM(N15:N17)","v":0}]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"A.3. Services Provided","index":12,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,0,76,4],[42,0,42,4],[44,0,44,4],[45,0,45,2],[72,0,72,4],[63,1,63,2],[71,1,71,2],[67,0,67,4],[75,0,75,4],[70,0,70,4],[66,0,66,4],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[28,0,28,6],[33,0,33,6],[27,1,27,2],[68,0,68,2],[34,0,34,2],[29,1,29,2],[38,0,38,6],[37,1,37,2],[32,0,32,6],[62,0,62,4],[41,0,41,4],[43,0,43,4],[36,0,36,6],[64,0,64,4],[30,0,30,6],[31,1,31,2],[0,0,0,6],[8,0,8,6],[11,0,11,2],[10,0,10,6],[2,2,2,6],[3,2,3,6],[4,5,4,6],[5,5,5,6],[1,0,1,6],[7,0,7,6],[9,0,9,6],[6,2,6,6],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[35,1,35,2],[39,1,39,2],[40,1,40,2],[46,1,46,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[65,1,65,2],[73,1,73,2],[74,1,74,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Services Provided"]
["Part 1 is for single site or consolidated information for services provided.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - SERVICES PROVIDED (Consolidated)"]
["Part 1A is for consolidated information for services provided by CCBHC staff.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1A - CCBHC STAFF SERVICES"]
["Description",null,null,"Number of Full-Time Equivalent (FTE) Staff\n\n1","Total Number of Services Provided for CCBHC Services\n\n2","\nDirect Cost \n(from Trial Balance, Col. 9)\n\n3","Average Cost per Service by Position (Col. 3 divided by Col. 2)\n\n4"]
[1,"Psychiatrist",null," ",null,{"$f":"'B.1. Trial Balance'!L13","v":0},{"$f":"IF(SUM(E13)=0,0,F13/E13)","v":0}]
[2,"Psychiatric nurse",null," ",null,{"$f":"'B.1. Trial Balance'!L14","v":0},0]
[3,"Child psychiatrist",null,null,null,{"$f":"'B.1. Trial Balance'!L15","v":0},0]
[4,"Adolescent psychiatrist",null,null,null,{"$f":"'B.1. Trial Balance'!L16","v":0},0]
[5,"Substance abuse specialist",null,null,null,{"$f":"'B.1. Trial Balance'!L17","v":0},0]
[6,"Case manager",null,null,null,{"$f":"'B.1. Trial Balance'!L18","v":0},0]
[7,"Recovery coach",null,null,null,{"$f":"'B.1. Trial Balance'!L19","v":0},0]
[8,"Peer specialist",null,null,null,{"$f":"'B.1. Trial Balance'!L20","v":0},0,null,"`"]
[9,"Family support specialist",null,null,null,{"$f":"'B.1. Trial Balance'!L21","v":0},0]
[10,"Licensed clinical social worker",null,null,null,{"$f":"'B.1. Trial Balance'!L22","v":0},0]
[11,"Licensed mental health counselor",null,null,null,{"$f":"'B.1. Trial Balance'!L23","v":0},0]
[12,"Mental health professional (trained and credentialed for psychological testing)",null,null,null,{"$f":"'B.1. Trial Balance'!L24","v":0},0]
[13,"Licensed marriage and family therapist",null,null,null,{"$f":"'B.1. Trial Balance'!L25","v":0},0]
[14,"Occupational therapist",null,null,null,{"$f":"'B.1. Trial Balance'!L26","v":0},0]
[15,"Interpreters or linguistic counselor",null,null,null,{"$f":"'B.1. Trial Balance'!L27","v":0},0]
[16,"General practice \n(performing CCBHC services)",null,"  ",null,{"$f":"'B.1. Trial Balance'!L28","v":0},0]
["17.       Other staff services (specify details below)"]
["17a",{"$f":"IF('B.1. Trial Balance'!B30=\"\",\"\",'B.1. Trial Balance'!B30)","v":""},null,null,null,{"$f":"'B.1. Trial Balance'!L30","v":0},{"$f":"IF(SUM(E30)=0,0,F30/E30)","v":0}]
["Additional lines inserted via Trial Balance tab"]
[18,"Subtotal staff services \n(sum of lines 1-17)",null,{"$f":"SUM(D13:D31)","v":0},{"$f":"SUM(E13:E31)","v":0},{"$f":"'B.1. Trial Balance'!L32","v":0},{"$f":"IF(SUM(E32)=0,0,F32/E32)","v":0}]
["Part 1B is for consolidated information for services provided under agreement.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1B - CCBHC SERVICES UNDER AGREEMENT"]
["Description",null,null,"Number of Full-Time Equivalent (FTE) Staff\n\n1","Total Number of Services Provided for CCBHC Services\n\n2","\nDirect Cost \n(from Trial Balance, Col. 9)\n\n3","Average Cost per Service by Position (Col. 3 divided by Col. 2)\n\n4"]
[19,"CCBHC services from DCO",null,"This cell is left intentionally blank.",null,{"$f":"'B.1. Trial Balance'!L36","v":0},{"$f":"IF(SUM(E36)=0,0,F36/E36)","v":0}]
["20.       Other CCBHC services (specify details below)",null,null,"This cell is left intentionally blank.",null,{"$f":"'B.1. Trial Balance'!L37","v":0},0]
["20a",{"$f":"IF('B.1. Trial Balance'!B38=\"\",\"\",'B.1. Trial Balance'!B38)","v":""},null,"This cell is left intentionally blank.",null,{"$f":"'B.1. Trial Balance'!L38","v":0},{"$f":"IF(SUM(E38)=0,0,F38/E38)","v":0}]
["Additional lines inserted via Trial Balance tab"]
[21,"Subtotal services under agreement (sum of lines 19-20)",null,"This cell is left intentionally blank.",{"$f":"SUM(E36:E39)","v":0},{"$f":"'B.1. Trial Balance'!L40","v":0},{"$f":"IF(SUM(E40)=0,0,F40/E40)","v":0}]
[22,"Total services \n(sum of lines 18 and 21)",null,{"$f":"SUM(D40,D32)","v":0},{"$f":"E32+E40","v":0},{"$f":"F32+F40","v":0},{"$f":"IF(SUM(E41)=0,0,F41/E41)","v":0}]
["Part 2 is for reporting specific information for each site.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - SERVICES PROVIDED BY SITE (For additional satellite sites, create new tab and copy and paste Part 2 for each additional site included)"]
["Part 2A is for site-specific information for services provided by CCBHC staff.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2A - CCBHC STAFF SERVICES"]
["Description",null,null,"Number of Full-Time Equivalent (FTE) Staff\n\n1","Total Number of Services Provided for CCBHC Services\n\n2"]
[1,"Psychiatrist"]
[2,"Psychiatric nurse"]
[3,"Child psychiatrist"]
[4,"Adolescent psychiatrist"]
[5,"Substance abuse specialist"]
[6,"Case manager"]
[7,"Recovery coach"]
[8,"Peer specialist"]
[9,"Family support specialist"]
[10,"Licensed clinical social worker"]
[11,"Licensed mental health counselor"]
[12,"Mental health professional (trained and credentialed for psychological testing)"]
[13,"Licensed marriage and family therapist"]
[14,"Occupational therapist"]
[15,"Interpreters or linguistic counselor"]
[16,"General practice \n(performing CCBHC services)"]
["17.       Other staff services (specify details below)"]
["17a",{"$f":"IF('B.1. Trial Balance'!B30=\"\",\"\",'B.1. Trial Balance'!B30)","v":""}]
["Additional lines inserted via Trial Balance tab"]
[18,"Subtotal staff services \n(sum of lines 1-17)",null,{"$f":"SUM(D47:D65)","v":0},{"$f":"SUM(E47:E65)","v":0}]
["Part 2B is for site-specific information for services provided under agreement.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2B - CCBHC SERVICES UNDER AGREEMENT"]
["Description",null,null,"Number of Full-Time Equivalent (FTE) Staff\n\n1","Total Number of Services Provided for CCBHC Services\n\n2"]
[19,"CCBHC services from DCO",null,"This cell is left intentionally blank."]
["20.       Other CCBHC services (specify details below)",null,null,"This cell is left intentionally blank."]
["20a",{"$f":"IF('B.1. Trial Balance'!B38=\"\",\"\",'B.1. Trial Balance'!B38)","v":""},null,"This cell is left intentionally blank."]
["Additional lines inserted via Trial Balance tab"]
[21,"Subtotal services under agreement (sum of lines 19-20)",null,"This cell is left intentionally blank.",{"$f":"SUM(E70:E73)","v":0}]
[22,"Total services \n(sum of lines 18 and 21)",null,{"$f":"SUM(D74,D66)","v":0},{"$f":"E66+E74","v":0}]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"A.4. Comments","index":13,"n_rows":273,"n_cols":11,"rows_kept":273,"cut":false,"hidden":false,"merged":[[0,0,0,10],[5,0,5,1],[1,0,1,10],[7,0,7,10],[2,0,2,1],[2,2,2,10],[3,0,3,1],[3,2,3,10],[4,0,4,1],[4,5,4,10],[271,0,271,10],[272,0,272,10],[8,0,8,10],[5,5,5,10],[6,0,6,1],[6,2,6,10]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Comments"]
["The bottom section is used to identify the worksheet, line and comments.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["Please explain or comment on any additional considerations that should be taken into account in determining the appropriate payment rate"]
["Worksheet","Line","Comment 1","Comment 2","Comment 3","Comment 4","Comment 5","Comment 6","Comment 7","Comment 8","Comment 9"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"F.1. CC PPS-1 Rate","index":14,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,6],[9,0,9,5],[15,0,15,5],[8,0,8,6],[0,0,0,6],[21,0,21,6],[14,0,14,6],[22,0,22,6],[7,0,7,6],[13,0,13,6],[1,0,1,6],[2,2,2,6],[3,2,3,6],[6,2,6,6],[4,5,4,6],[5,5,5,6],[6,0,6,1],[5,0,5,1],[4,0,4,1],[3,0,3,1],[2,0,2,1],[18,1,18,5],[19,1,19,5],[20,1,20,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[16,1,16,5],[17,1,17,5]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"CC PPS-1 Rate"]
["Part 1 is automatically populated with the direct and indirect costs for CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - DETERMINATION OF TOTAL ALLOWABLE COST APPLICABLE TO THE CCBHC "]
["Description",null,null,null,null,null,"Amount\n1"]
[1,"Total direct cost of CCBHC services (Trial Balance, column 9, line 29)",null,null,null,null,{"$f":"'B.1. Trial Balance'!L53","v":0}]
[2,"Indirect cost applicable to CCBHC services (Indirect Cost Allocation, line 16)",null,null,null,null,{"$f":"+'D.1. Indirect Cost Allocation'!H25","v":0}]
[3,"Total allowable CCBHC costs (sum of lines 1-2)",null,null,null,null,{"$f":"G12+G11","v":0}]
["Part 2 calculates the CC PPS 1 rate after the MEI is entered in line 7.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - DETERMINATION OF CC PPS-1 RATE"]
["Description",null,null,null,null,null,"Amount\n1"]
[4,"Total allowable CCBHC costs (line 3)",null,null,null,null,{"$f":"+G13","v":0}]
[5,"Total CCBHC visits* (Daily Visits, column 1, line 4)",null,null,null,null,{"$f":"'E.1. Daily Visits PPS-1'!I14","v":0}]
[6,"Unadjusted PPS rate (line 4 divided by line 5)",null,null,null,null,{"$f":"IF(G18=0,0,G17/G18)","v":0}]
[7,"Medicare Economic Index (MEI) adjustment from midpoint of the cost period to the midpoint of the rate period",null,null,null,null,0]
[8,"CC PPS-1 rate (line 6 adjusted by factor from line 7)",null,null,null,null,{"$f":"G19*(1+G20)","v":0}]
["* Total should reflect the total count of CCBHC visits provided and not be restricted to Medicaid visits"]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"F.2. CC PPS-2 Rate","index":15,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,30,10],[28,0,28,10],[21,0,21,2],[20,0,20,10],[21,9,27,9],[29,0,29,10],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[1,0,1,10],[7,0,7,10],[0,0,0,10],[8,0,8,10],[9,9,17,9],[9,0,9,2],[2,2,2,10],[3,2,3,10],[4,5,4,10],[5,5,5,10],[6,2,6,10],[6,0,6,1],[5,0,5,1],[4,0,4,1],[3,0,3,1],[2,0,2,1],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[22,1,22,2],[23,1,23,2],[19,0,19,10],[18,0,18,8]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"CC PPS-2 Rate"]
["Part 1 is used to determine the cost-to-charge ratio allocation by population group. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - COST-TO-CHARGE RATIO ALLOCATION"]
["Description",null,null,"Standard Population\nCharges and Costs for CCBHC Services:\nAt or Below the Outlier Threshold\n1a","Standard Population\nCharges and Costs for CCBHC Services:\nAbove the Outlier Threshold\n1b","Certain Conditions 1\nCharges and Costs for CCBHC Services:\nAt or Below the Outlier Threshold\n2a","Certain Conditions 1\nCharges and Costs for CCBHC Services:\nAbove the Outlier Threshold\n2b","Certain Conditions 2\nCharges and Costs for CCBHC Services:\nAt or Below the Outlier Threshold\n3a","Certain Conditions 2\nCharges and Costs for CCBHC Services:\nAbove the Outlier Threshold\n3b","\nAdditional columns inserted via Monthly Visits tab","Total Population Charges and Costs\n(Sum of all Columns) \n\n\nTotal"]
[1,"Actual charges",null,null,null,null,null,null,null,null,{"$f":"SUM(D11:J11)","v":0}]
[2,"Anticipated additional charges (DY1 only)",null,null,null,null,null,null,null,null,{"$f":"SUM(D12:J12)","v":0}]
[3,"Total charges (sum of lines 1-2)",null,{"$f":"SUM(D11:D12)","v":0},0,0,0,{"$f":"SUM(H11:H12)","v":0},0,null,{"$f":"SUM(K11:K12)","v":0}]
[4,"Total direct costs (Trial Balance, column 9, line 29)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"'B.1. Trial Balance'!L53","v":0}]
[5,"Indirect cost applicable to CCBHC services (Indirect Cost Allocation, line 16)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"+'D.1. Indirect Cost Allocation'!H25","v":0}]
[6,"Total allowable costs for CCBHC services (sum of lines 4-5)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"K14+K15","v":0}]
[7,"Cost-to-charge ratio services (line 6 divided by line 3)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"IF(K13=0,0,+K16/K13)","v":0}]
[8,"Total cost of CCBHC services \n(line 3 times line 7)",null,{"$f":"+D13*$K$17","v":0},0,0,0,0,0,null,{"$f":"+K13*$K$17","v":0}]
["Cross Check:  Total costs should tie to the total direct and indirect costs applicable to CCBHC services (line 6)",null,null,null,null,null,null,null,null,"Difference",{"$f":"+K18-K16","v":0}]
["Part 2 is used to calculate preliminary CC PPS-2 rates after MEI is entered in line 12.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - DETERMINATION OF CC PPS-2 RATE"]
["Description",null,null,"Standard Population\nCosts for CCBHC Services:\nAt or Below the Outlier Threshold\n1a","Standard Population\nCosts for CCBHC Services:\nAbove the Outlier Threshold\n1b","Certain Conditions 1\nCosts for CCBHC Services:\nAt or Below the Outlier Threshold\n2a","Certain Conditions 1\nCosts for CCBHC Services:\nAbove the Outlier Threshold\n2b","Certain Conditions 2\nCosts for CCBHC Services:\nAt or Below the Outlier Threshold\n3a","Certain Conditions 2\nCosts for CCBHC Services:\nAbove the Outlier Threshold\n3b","\nAdditional columns inserted via Monthly Visits tab","Total Population Costs\n(Sum of all Columns) \n\n\nTotal"]
[9,"Total allowable CCBHC costs \n(line 8)",null,{"$f":"+D18","v":0},{"$f":"+E18","v":0},0,0,{"$f":"+H18","v":0},0,null,{"$f":"+K18","v":0}]
[10,"Total months patients received CCBHC services \n(Monthly Visits, line 5)*",null,{"$f":"'E.2. Monthly Visits PPS-2'!D16","v":0},"This cell is left intentionally blank.",{"$f":"'E.2. Monthly Visits PPS-2'!F16","v":0},"This cell is left intentionally blank.",{"$f":"'E.2. Monthly Visits PPS-2'!H16","v":0},"This cell is left intentionally blank.",null,{"$f":"'E.2. Monthly Visits PPS-2'!K16","v":0}]
[11,"Total allowable cost per visit \n(line 9 divided by line 10)",null,{"$f":"IF(D24=0,0,D23/D24)","v":0},"This cell is left intentionally blank.",{"$f":"IF(F24=0,0,F23/F24)","v":0},"This cell is left intentionally blank.",{"$f":"IF(H24=0,0,H23/H24)","v":0},"This cell is left intentionally blank.",null,{"$f":"IF(K24=0,0,K23/K24)","v":0}]
[12,"Medicare Economic Index (MEI) adjustment from midpoint of the cost period to the midpoint of the rate period",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,0]
[13,"CC PPS-2 rate (line 11 adjusted by factor from column Total, line 12)",null,{"$f":"D25*(1+$K$26)","v":0},"This cell is left intentionally blank.",{"$f":"F25*(1+$K$26)","v":0},"This cell is left intentionally blank.",{"$f":"H25*(1+$K$26)","v":0},"This cell is left intentionally blank.",null,{"$f":"K25*(1+K26)","v":0}]
[14,"Outlier pool (line 9)",null,"This cell is left intentionally blank.",{"$f":"E23","v":0},"This cell is left intentionally blank.",{"$f":"G23","v":0},"This cell is left intentionally blank.",{"$f":"I23","v":0},null,{"$f":"SUM(D28:J28)","v":0}]
["* Column \"a\" reflects the count for All visits. The total reflects the sum of \"a\" columns."]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"F.3. CC PPS-3 Rate","index":16,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,1],[2,2,2,9],[3,0,3,1],[3,2,3,9],[4,0,4,1],[4,5,4,9],[5,0,5,1],[5,5,5,9],[6,0,6,1],[6,2,6,9],[18,1,18,5],[7,0,7,9],[8,0,8,9],[9,0,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,0,13,9],[14,0,14,9],[15,0,15,5],[16,1,16,5],[17,1,17,5],[19,1,19,5],[20,1,20,5],[21,0,21,9],[22,0,22,9],[23,0,23,9]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"CC PPS-3 Rate"]
["Part 1 is automatically populated with the direct and indirect costs for CCBHC services.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - DETERMINATION OF TOTAL ALLOWABLE COST APPLICABLE TO THE CCBHC "]
["Description",null,null,null,null,null,"Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3","Non-Crisis PPS\n4"]
[1,"Total direct cost of CCBHC services (Trial Balance Crisis, columns 1-4, line 29)",null,null,null,null,{"$f":"'B.2. Trial Balance Crisis'!D47","v":0},{"$f":"'B.2. Trial Balance Crisis'!E47","v":0},{"$f":"'B.2. Trial Balance Crisis'!F47","v":0},{"$f":"'B.2. Trial Balance Crisis'!G47","v":0}]
[2,"Indirect cost applicable to CCBHC services (Indirect Cost Allocation, line 16 times Trial Balance Crisis, colums 1-4, line 30)",null,null,null,null,{"$f":"+'D.1. Indirect Cost Allocation'!$I$25*'B.2. Trial Balance Crisis'!D48","v":0},{"$f":"+'D.1. Indirect Cost Allocation'!$I$25*'B.2. Trial Balance Crisis'!E48","v":0},{"$f":"+'D.1. Indirect Cost Allocation'!$I$25*'B.2. Trial Balance Crisis'!F48","v":0},{"$f":"+'D.1. Indirect Cost Allocation'!$I$25*'B.2. Trial Balance Crisis'!G48","v":0}]
[3,"Total allowable CCBHC costs (sum of lines 1-2)",null,null,null,null,{"$f":"G12+G11","v":0},0,0,{"$f":"J12+J11","v":0}]
["Part 2 calculates the CC PPS 1 rate after the MEI is entered in line 7.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - DETERMINATION OF CC PPS-3 RATE"]
["Description",null,null,null,null,null,"Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3","Non-Crisis PPS\n4"]
[4,"Total allowable CCBHC costs (line 3)",null,null,null,null,{"$f":"+G13","v":0},{"$f":"+H13","v":0},0,{"$f":"+J13","v":0}]
[5,"Total CCBHC visits* (Daily Visits, column 1, line 4)",null,null,null,null,{"$f":"'E.3. Daily Visits PPS-3'!I14","v":0},{"$f":"SUM('E.3. Daily Visits PPS-3'!I14)","v":0},{"$f":"SUM('E.3. Daily Visits PPS-3'!J14)","v":0},{"$f":"SUM('E.3. Daily Visits PPS-3'!K14)","v":0}]
[6,"Unadjusted PPS rate (line 4 divided by line 5)",null,null,null,null,{"$f":"IF(G18=0,0,G17/G18)","v":0},{"$f":"IF(H18=0,0,H17/H18)","v":0},0,{"$f":"IF(J18=0,0,J17/J18)","v":0}]
[7,"Medicare Economic Index (MEI) adjustment from midpoint of the cost period to the midpoint of the rate period",null,null,null,null,0,{"$f":"G20","v":0},{"$f":"H20","v":0},{"$f":"I20","v":0}]
[8,"CC PPS-1 rate (line 6 adjusted by factor from line 7)",null,null,null,null,{"$f":"G19*(1+G20)","v":0},{"$f":"H19*(1+H20)","v":0},{"$f":"I19*(1+I20)","v":0},{"$f":"J19*(1+J20)","v":0}]
["* Total should reflect the total count of CCBHC visits provided and not be restricted to Medicaid visits"]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"F.4. CC PPS-4 Rate","index":17,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,1],[2,2,2,14],[3,0,3,1],[3,2,3,14],[9,3,9,4],[9,5,9,6],[9,7,9,8],[4,0,4,1],[4,5,4,14],[5,0,5,1],[5,5,5,14],[6,0,6,1],[6,2,6,14],[23,3,23,4],[23,5,23,6],[23,7,23,8],[7,0,7,14],[8,0,8,14],[10,0,10,2],[10,9,19,9],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[9,0,9,2],[15,1,15,2],[31,0,31,14],[32,0,32,14],[33,0,33,14],[24,9,30,9],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[24,0,24,2],[20,0,20,8],[21,0,21,14],[22,0,22,14],[29,1,29,2],[30,1,30,2],[23,0,23,2]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!E5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"CC PPS-4 Rate"]
["Part 1 is used to determine the cost-to-charge ratio allocation by population group. Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 1 - COST-TO-CHARGE RATIO ALLOCATION"]
["Population",null,null,"Standard Population",null,"Condition 1",null,"Condition 2",null,null,null,"Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3"]
["Description",null,null,"Standard Population\nCharges and Costs for CCBHC Services:\nAt or Below the Outlier Threshold\n1a","Standard Population\nCharges and Costs for CCBHC Services:\nAbove the Outlier Threshold\n1b","Certain Conditions 1\nCharges and Costs for CCBHC Services:\nAt or Below the Outlier Threshold\n2a","Certain Conditions 1\nCharges and Costs for CCBHC Services:\nAbove the Outlier Threshold\n2b","Certain Conditions 2\nCharges and Costs for CCBHC Services:\nAt or Below the Outlier Threshold\n3a","Certain Conditions 2\nCharges and Costs for CCBHC Services:\nAbove the Outlier Threshold\n3b","\nAdditional columns inserted via Monthly Visits tab","Total Population Charges and Costs\n(Sum of non-SCS Columns) \n\n\nTotal","Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3","Total Population Charges and Costs\n(Sum of all Columns) \n\n\nTotal"]
[1,"Actual charges",null,null,null,null,null,null,null,null,{"$f":"SUM(D12:I12)","v":0},null,null,null,{"$f":"SUM(K12:N12)","v":0}]
[2,"Anticipated additional charges (DY1 only)",null,null,null,null,null,null,null,null,{"$f":"SUM(D13:I13)","v":0},null,null,null,{"$f":"SUM(K13:N13)","v":0}]
[3,"Total charges (sum of lines 1-2)",null,{"$f":"SUM(D12:D13)","v":0},0,0,0,0,0,null,{"$f":"SUM(D14:I14)","v":0},{"$f":"SUM(L12:L13)","v":0},0,0,{"$f":"SUM(O12:O13)","v":0}]
[4,"Total direct costs (Trial Balance Crisis, column 1-4, line 29)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"'B.2. Trial Balance Crisis'!G53","v":0},{"$f":"'B.2. Trial Balance Crisis'!D53","v":0},{"$f":"'B.2. Trial Balance Crisis'!E53","v":0},{"$f":"'B.2. Trial Balance Crisis'!F53","v":0},{"$f":"SUM(K15:N15)","v":0}]
[5,"Variance\n(difference of lines 3-4)",null,null,null,null,null,null,null,null,{"$f":"K14-K15","v":0},{"$f":"L14-L15","v":0},0,0,{"$f":"O14-O15","v":0}]
[6,"Indirect cost applicable to CCBHC services (Indirect Cost Allocation, \nline 16)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"'D.1. Indirect Cost Allocation'!$H$25*'B.2. Trial Balance Crisis'!G54","v":0},{"$f":"'D.1. Indirect Cost Allocation'!$H$25*'B.2. Trial Balance Crisis'!D54","v":0},{"$f":"'D.1. Indirect Cost Allocation'!$H$25*'B.2. Trial Balance Crisis'!E54","v":0},{"$f":"'D.1. Indirect Cost Allocation'!$H$25*'B.2. Trial Balance Crisis'!F54","v":0},{"$f":"SUM(K17:N17)","v":0}]
[7,"Total allowable costs for CCBHC services (sum of lines 4 & 6)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"K15+K17","v":0},{"$f":"L15+L17","v":0},0,0,{"$f":"SUM(K18:N18)","v":0}]
[8,"Cost-to-charge ratio services \n(line 7 divided by line 3)",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,{"$f":"IF(K14=0,0,K18/K14)","v":0}]
[9,"Total cost of CCBHC services \n(line 3 times line 8)",null,{"$f":"+D14*$K$19","v":0},0,0,0,0,0,null,{"$f":"K14*K19","v":0},{"$f":"L18","v":0},{"$f":"M18","v":0},0,{"$f":"SUM(K20:N20)","v":0}]
["Cross Check:  Total costs should tie to the total direct and indirect costs applicable to CCBHC services (line 6)",null,null,null,null,null,null,null,null,null,null,null,null,"Difference",{"$f":"+O20-O18","v":0}]
["Part 2 is used to calculate preliminary CC PPS-2 rates after MEI is entered in line 12.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["PART 2 - DETERMINATION OF CC PPS-4 RATE"]
["Population",null,null,"Standard Population",null,"Condition 1",null,"Condition 2",null,null,null,"Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3"]
["Description",null,null,"Standard Population\nCosts for CCBHC Services:\nAt or Below the Outlier Threshold\n1a","Standard Population\nCosts for CCBHC Services:\nAbove the Outlier Threshold\n1b","Certain Conditions 1\nCosts for CCBHC Services:\nAt or Below the Outlier Threshold\n2a","Certain Conditions 1\nCosts for CCBHC Services:\nAbove the Outlier Threshold\n2b","Certain Conditions 2\nCosts for CCBHC Services:\nAt or Below the Outlier Threshold\n3a","Certain Conditions 2\nCosts for CCBHC Services:\nAbove the Outlier Threshold\n3b","\nAdditional columns inserted via Monthly Visits tab","Total Population Charges and Costs\n(Sum of non-SCS Columns) \n\n\nTotal","Mobile Crisis 9813\n1","Mobile Crisis Non-9813\n2","Crisis Stabilization\n3","Total Population Costs\n(Sum of all Columns) \n\n\nTotal"]
[9,"Total allowable CCBHC costs \n(line 8)",null,{"$f":"+D20","v":0},{"$f":"+E20","v":0},0,0,0,0,null,{"$f":"+K20","v":0},0,0,0,0]
[10,"Total months patients received CCBHC services \n(Monthly Visits, line 5)*",null,{"$f":"+'E.4. Monthly Visits PPS-4'!D18","v":0},"This cell is left intentionally blank.",{"$f":"+'E.4. Monthly Visits PPS-4'!F18","v":0},"This cell is left intentionally blank.",{"$f":"+'E.4. Monthly Visits PPS-4'!H18","v":0},"This cell is left intentionally blank.",null,{"$f":"SUM(D27:J27)","v":0},{"$f":"'E.4. Monthly Visits PPS-4'!K18","v":0},{"$f":"'E.4. Monthly Visits PPS-4'!L18","v":0},{"$f":"'E.4. Monthly Visits PPS-4'!M18","v":0},{"$f":"SUM(D27:N27)","v":0}]
[11,"Total allowable cost per visit \n(line 9 divided by line 10)",null,{"$f":"IF(D27=0,0,D26/D27)","v":0},"This cell is left intentionally blank.",{"$f":"IF(F27=0,0,F26/F27)","v":0},"This cell is left intentionally blank.",{"$f":"IF(H27=0,0,H26/H27)","v":0},"This cell is left intentionally blank.",null,{"$f":"IF(K27=0,0,K26/K27)","v":0},0,0,0,{"$f":"IF(O27=0,0,O26/O27)","v":0}]
[12,"Medicare Economic Index (MEI) adjustment from midpoint of the cost period to the midpoint of the rate period",null,"This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.","This cell is left intentionally blank.",null,0,{"$f":"+K29","v":0},{"$f":"+L29","v":0},{"$f":"+M29","v":0},{"$f":"+N29","v":0}]
[13,"CC PPS-2 rate (line 11 adjusted by factor from column Total, line 12)",null,{"$f":"D28*(1+$O$29)","v":0},"This cell is left intentionally blank.",{"$f":"F28*(1+$O$29)","v":0},"This cell is left intentionally blank.",{"$f":"H28*(1+$O$29)","v":0},"This cell is left intentionally blank.",null,{"$f":"K28*(1+K29)","v":0},0,0,0,{"$f":"O28*(1+O29)","v":0}]
[14,"Outlier pool (line 9)",null,"This cell is left intentionally blank.",{"$f":"E26","v":0},"This cell is left intentionally blank.",{"$f":"G26","v":0},"This cell is left intentionally blank.",{"$f":"I26","v":0},null,{"$f":"SUM(D31:J31)","v":0},null,null,null,{"$f":"SUM(D31:J31)","v":0}]
["* Column \"a\" reflects the count for All visits. The total reflects the sum of \"a\" columns."]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]

{"sheet":"A.5. Certification","index":18,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[2,2,2,11],[3,2,3,11],[4,5,4,11],[5,5,5,11],[1,0,1,11],[14,3,14,11],[15,0,15,2],[15,3,15,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[11,0,11,11],[13,0,13,2],[13,3,13,11],[6,0,6,1],[6,2,6,11],[21,0,21,11],[16,0,16,2],[16,3,16,11],[17,0,17,2],[17,3,17,11],[18,0,18,2],[18,3,18,11],[20,0,20,11],[7,0,7,11],[19,0,19,2],[19,3,19,11],[12,0,12,2],[12,3,12,11],[14,0,14,2]]}
["CCBHC Cost Report"]
["This is the top section.  It is the Medicaid ID, NPI, reporting period, and rate period, automatically inserted from the provider information tab.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID ID:",null,{"$f":"IF('A.1. Provider Information'!$D$3=\"\",\"\",'A.1. Provider Information'!$D$3)","v":""}]
["NPI:",null,{"$f":"IF('A.1. Provider Information'!$D$4=\"\",\"\",'A.1. Provider Information'!$D$4)","v":""}]
["REPORTING PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$5=\"\",\"\",'A.1. Provider Information'!$E$5)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$5=\"\",\"\",'A.1. Provider Information'!$G$5)","v":""}]
["RATE PERIOD:",null,"From:",{"$f":"IF('A.1. Provider Information'!$E$6=\"\",\"\",'A.1. Provider Information'!$E$6)","v":""},"To:",{"$f":"IF('A.1. Provider Information'!$G$6=\"\",\"\",'A.1. Provider Information'!$G$6)","v":""}]
["WORKSHEET:",null,"Certification"]
["The bottom section is used to certify the completeness and accuracy of the data in this workbook.  Use tab to move to input areas. Use the arrow keys to read through the document."]
["MEDICAID COST REPORT"]
["for Certified Community Behavioral Health Clinics"]
["MISREPRESENTATION OR FALSIFICATION OF ANY INFORMATION CONTAINED IN THIS COST REPORT MAY BE\nPUNISHABLE BY CRIMINAL, CIVIL, AND ADMINISTRATIVE ACTION; FINE; AND/OR IMPRISONMENT UNDER \nFEDERAL LAW.  FURTHERMORE, IF SERVICES IDENTIFIED IN THIS REPORT WERE PROVIDED OR PROCURED \nDIRECTLY OR INDIRECTLY THROUGH THE PAYMENT OF A KICKBACK OR WERE OTHERWISE ILLEGAL, \nCRIMINAL, CIVIL, AND ADMINISTRATIVE ACTION; FINES; AND/OR IMPRISONMENT MAY RESULT. CERTIFICATION\nBY OFFICER OR ADMINISTRATOR IS REQUIRED."]
["I HEREBY CERTIFY that I have read the above certification statement and that I have examined the \naccompanying electronically filed or manually submitted cost report and that to the best of my \nknowledge and belief, this report and statement are true, correct, complete, and prepared from the \nbooks and records of the Provider in accordance with applicable instructions, except as noted. I \nfurther certify that I am familiar with the laws and regulations regarding the provision of health care \nservices, and that the services identified in the cost report were provided in compliance with such \nlaws and regulations.\n\n"]
["Signature of Officer: "]
["Date:","Date:"]
["Title: "]
["Clinic: "]
["Medicaid ID: "]
["From Period: "]
["To Period: "]
["Preparer (If other than Officer): "]
["OMB #0398-1148   CMS-10398 (#43)"]
["End of Worksheet"]