{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vendor Worksheet Instructions","Vendor Worksheet","Certification Instructions","Vendor Summary & Certification"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Vendor Worksheet Instructions","index":0,"n_rows":85,"n_cols":2,"rows_kept":85,"cut":false,"hidden":false,"merged":[[40,1,40,8],[36,1,36,8],[3,0,3,8],[30,1,30,8],[38,0,39,8],[15,1,15,8],[13,1,13,8],[21,1,22,8],[24,1,25,8],[19,1,19,8],[4,0,4,8],[69,1,69,8],[52,1,52,8],[59,1,59,8],[42,1,42,8],[44,1,44,8],[46,1,46,8],[56,1,56,8],[58,1,58,8],[67,1,67,8],[63,1,63,8],[65,1,65,8],[84,0,84,8],[74,1,74,8],[76,1,76,8],[78,1,78,8],[80,1,80,8],[82,0,82,8]]}
["SB 3 MINIMUM WAGE 2022 RATE ADJUSTMENT - NEGOTIATED RATE SERVICES"]
["WORKSHEET INSTRUCTIONS "]
[]
["These instructions are for the Vendor Worksheet.  After you read these instructions, please go to the “Vendor Worksheet” tab to begin.  You will ONLY be able to fill-in and select from the shaded fields on this worksheet.  The information you submit on this worksheet will be reviewed by Alta California Regional Center.  If additional information is needed, ACRC will contact you.  After the review, ACRC will respond to your request accordingly."]
["100% Traditional Services or Traditional/Alternative Services Mix Workbook"]
["SECTION A:  PROGRAM INFORMATION"]
[]
["Row 1","Please enter the Service Provider Name."]
[]
["Row 2","Please enter the Vendor Number."]
[]
["Row 3","Please enter the three-digit Service Code."]
[]
["Row 4","Please enter the dates for the beginning and end of a review period of 3 consecutive months from January through December 2021.  If you have been recently vendored and have less than 3 months of payroll and billing data, please enter the dates for an applicable review period of up to 3 months from January through December 2021."]
[]
["Row 5","Employers with 25 or less employees are required to pay the increased minimum wage of 14.00 per hour and Employers with 26 or more employees are required to pay the increased minimum wage of 15.00 per hour, both effective January 1, 2022.  Make selection to indicate that you employ either 25 or less employees or 26 or more employees in total, factoring in all locations and services.  However, only employees/hours worked delivering services under the vendor number/service code above can be included in this rate adjustment request.   Vendors that operate multiple services must submit separate rate adjustment requests for each service and must ensure there is no duplication of reported employment hours across different services.\n\n"]
[]
["Row 6","Please enter the Staffing Ratio."]
[]
["Row 7","Using the drop down select Yes or No if you provided 100% traditional services during the 3 month review period. If Yes is selected, the rows related to Alternative Services will be blocked as they are not applicable."]
[]
["Row 8 (A through C)","Please enter the number of enrolled consumers who received services using the Traditional Services rate during the selected three month period."]
[]
[]
["Row 9 (A through C)","If applicable, please enter the number of enrolled consumers who received services using the Alternative Services rate during the selected three month period. "]
[]
[]
["Row 10","Consumer count information will populate automatically here."]
[]
[]
["Rows 11 & 14","Please enter the current Traditional Services and Alternative Services (if applicable) rate and select the Unit Type, either Daily or Hourly, from the drop-down list in Column \"H\" for the Traditional rate."]
[]
["Rows 12,13, 15,16","Rate information will populate automatically here."]
[]
["Row 17","Select the Vendoring Regional Center from the drop-down list."]
[]
["Row 18-21","Select the User Regional Center(s), if applicable, from the drop-down list.  If you need to list additional user regional centers, please add rows by clicking as instructed on the designated button."]
[]
["SECTION B:  EMPLOYEE WAGE INFORMATION"]
[]
["Column A","Please enter the name or initials of the employed staff who were paid during the review period, followed by their position title.  For any employee/position who received two or more different hourly wages during the review period being reported, please list only the most current wage paid with the requested information in columns B through I.  If additional rows are needed, please click on the designated button.  PLEASE NOTE:  Only employees of the vendor number and service code listed above in Rows 2 and 3 above are to be listed in Section B: Employee Wage Information."]
[]
[null,"DO NOT include staff who are providing these services that are funded by another source, such as through a contract with a school district.  Also, DO NOT include wages paid to consumers while receiving these services or any worker who is paid through other sources such as contract funding. Additionally, DO NOT include supplemental staff hours that are spent with non-mobile consumers, these hours are reimbursed through the supplemental rate. "]
[]
["Column B","Please enter the Position Title of the Employee."]
[]
["Column C","Please enter the current Hourly Wage paid to the employee(s) reported during the Review Period."]
[]
["Columns D - G","Wage information will calculate automatically here."]
[]
["Column H","Please enter the Workers' Compensation Insurance Employer Rate as a percentage."]
[]
["Column I","Please enter your Total Unemployment Insurance contribution rate as a percentage, including the net Federal and State rates, and the Employment Training Tax.  (Refer to your Form DE-2088 that you receive from the State of California Employment Development Department (EDD) for your contribution rates for Unemployment Insurance and Employment Training Tax.) "]
[]
["Column J","Wage information will calculate automatically here."]
[]
["Column K","Please enter the actual Total Hours Worked or Paid During the Review Period by each of the reported employee(s)."]
[]
["Column L","The cost of the rate adjustment will calculate automatically here."]
[null,"If less than a 3 month period, Section A Row 4,  Department Staff will adjust the calculation as needed."]
[]
["SECTIONS C:  RATE ADJUSTMENT CALCULATION (Tradtional Services Rate)"]
[]
["Row 1","Total wages, payroll taxes, workers' compensation, and other mandated employer costs applicable to the Traditional Services rate will calculate automatically here. "]
[]
["Row 2","Total Number of Units of Services Billed to all Regional Centers during the 3 month period will calculate automatically here."]
[]
["Rows 3 - 9","Please select the individual regional center(s) billed in the Review Period and enter the total units billed (USING THE TRADITIONAL SERVICES RATE) in the Review Period for the selected regional center(s).  If you need to list additional regional centers, please click the designated button."]
[]
["Row 10","The rate change will calculate automatically here and populate Row 12 in Section A, Program Information."]
[]
[]
["SECTION D:  RATE ADJUSTMENT CALCULATION  (Alternative Services Rate)"]
[]
["Row 1","Total wages, payroll taxes, workers' compensation, and other mandated employer costs applicable to the Alternative Services rate will calculate automatically here."]
[]
["Row 2","Total Number of Units of Services Billed to all Regional Centers during the 3 month period will calculate automatically here."]
[]
["Rows 3 - 9","Please select the individual regional center(s) billed in the Review Period and enter the total units billed (USING THE ALTERNATIVE SERVICES RATE) in the Review Period for the selected regional center(s).  If you need to list additional regional centers, please click the designated button."]
[]
["Row 10","The rate change will calculate automatically here and populate Row 15 in Section A, Program Information."]
[]
["Please review ALL the information you have entered on the worksheet, and specifically rows 4 - 14 in Section A, and rows 10 in Section C & D.  These rows should have calculated rate information based on the data you have entered.  If there is an error message in these rows, you may need to re-enter the information in Sections B, C, and/or D."]
[]
["Before submitting, please save your workbook using the vendor number in the title of the file.  Failure to do so results in the submission of an empty workbook."]

{"sheet":"Vendor Worksheet","index":1,"n_rows":267,"n_cols":13,"rows_kept":267,"cut":false,"hidden":false,"merged":[[16,2,16,7],[14,2,14,7],[29,2,29,7],[30,2,30,7],[7,2,7,7],[13,2,13,7],[12,2,12,7],[20,3,20,6],[21,3,21,6],[22,3,22,6],[18,2,18,7],[17,2,17,7],[26,2,26,7],[27,2,27,7],[28,2,28,7],[10,2,10,7],[4,2,4,7],[5,2,5,7],[6,2,6,7],[9,2,9,7],[8,2,8,7],[23,3,23,6],[36,10,39,10],[36,11,39,11],[36,12,39,12],[38,1,39,1],[36,9,39,9],[36,8,39,8],[36,2,39,2],[36,3,39,3],[36,4,39,4],[36,5,39,5],[36,6,39,6],[36,7,39,7]]}
["SB 3 MINIMUM WAGE 2022 RATE ADJUSTMENT - NEGOTIATED RATE SERVICES"]
["Effective January 1, 2022 - California Minimum Wage Increases to $14.00 per hour for Service Providers Employing 25 or less Employees AND $15.00 for Service Providers Employing 26 or more Employees"]
[]
["SECTION A:  PROGRAM INFORMATION",null,"(You will ONLY be able to fill-in and select from the shaded fields on this worksheet)"]
[1,"Service Provider Name"]
[2,"Vendor Number"]
[3,"Service Code"]
[4,"Three month review period between January-December 2021: (Enter Beginning & End) "]
[5,"Select 25 or Less OR 26 or More Employees from Drop Down:"]
[6,"Staffing Ratio"," "]
[7,"Were 100% of services provided using the Traditional Services rate?"]
[8,"Avg. Number of Enrolled Consumers - Traditional Services",{"$f":"ROUND(SUM(C13:C15)/3,2)","v":0},"Cost Allocation:",{"$f":"ROUND(C12/SUM(C12,C16),3)","v":{"$error":"#DIV/0!"}}]
["8A","Consumers Served Month 1 "]
["8B","Consumers Served Month 2"]
["8C","Consumers Served Month 3"]
[9,"Avg. Number of Enrolled Consumers - Alternative Services",{"$f":"ROUND(SUM(C17:C19)/3,2)","v":0},"Cost Allocation:",{"$f":"ROUND(C16/SUM(C16,C12),3)","v":{"$error":"#DIV/0!"}}]
["9A","Consumers Served Month 1 "]
["9B","Consumers Served Month 2"]
["9C","Consumers Served Month 3"]
[10,"Total:",{"$f":"SUM(C16,C12)","v":0},null,{"$f":"SUM(E12,E16)","v":{"$error":"#DIV/0!"}}]
[11,"Current Traditional Services Rate:",null,"Select Unit Type: "]
[12," Rate Adjustment:",{"$f":"H201","v":0}]
[13," New Traditional Rate:",{"$f":"C21+C22","v":0}]
[14,"Current Alternative Services Rate:",null,"Unit Type: ",null,null,null,"Monthly"]
[15," Rate Adjustment:",{"$f":"H213","v":0}]
[16," New Alternative Rate:",{"$f":"+C24+C25","v":0}]
[17,"Select Vendoring Regional Center from Drop Down Menu"]
[18,"Select User Regional Centers from Drop Down Menu"]
[19,"Select User Regional Centers"]
[20,"Select User Regional Centers"]
[21,"Select User Regional Centers"]
[]
[]
[]
["SECTION B:  EMPLOYEE WAGE INFORMATION"]
[null,"A","B","C","D","E ","F","G","H","I","J","K","L"]
[null,"Name or Initials of Staff Employee(s)","Position Title","Current Hourly Wage","New Hourly Wage","Hourly Wage Change","Employer Social Security Tax @ 6.2%","Employer Medicare Tax @1.45%","Workers Compensation as a %","Unemploy. Insurance \nas a %","Wage Adjustment plus Mandated Payroll Costs","Hours Worked/Paid During \n3 Month Review Period","Cost of Rate Adjustment \n(3 Month Period)"]
[]
["Row","(Please See Instructions for Listing Employees Receiving more than One Wage)"]
["#"]
[1,null,null,null,{"$f":"IF($C$9=\"25 or less\",IF(AND(D41>=12,D41<=13.99),14,0),IF($C$9=\"26 or more\",IF(AND(D41>=14,D41<=14.99),15,0),0))","v":0},{"$f":"IF(E41-D41>0,E41-D41,0)","v":0},{"$f":"F41*0.062","v":0},{"$f":"F41*0.0145","v":0},null,null,{"$f":"ROUND((SUM(F41+G41+H41)+(F41*I41)+(F41*J41)),2)","v":0},null,{"$f":"SUM(K41*L41)","v":0}]
[2,null,null,null,0,0,0,0,null,null,0,null,0]
[3,null,null,null,0,0,0,0,null,null,0,null,0]
[4,null,null,null,0,0,0,0,null,null,0,null,0]
[5,null,null,null,0,0,0,0,null,null,0,null,0]
[6,null,null,null,0,0,0,0,null,null,0,null,0]
[7,null,null,null,0,0,0,0,null,null,0,null,0]
[8,null,null,null,0,0,0,0,null,null,0,null,0]
[9,null,null,null,0,0,0,0,null,null,0,null,0]
[10,null,null,null,0,0,0,0,null,null,0,null,0]
[11,null,null,null,0,0,0,0,null,null,0,null,0]
[12,null,null,null,0,0,0,0,null,null,0,null,0]
[13,null,null,null,0,0,0,0,null,null,0,null,0]
[14,null,null,null,0,0,0,0,null,null,0,null,0]
[15,null,null,null,0,0,0,0,null,null,0,null,0]
[16,null,null,null,0,0,0,0,null,null,0,null,0]
[17,null,null,null,0,0,0,0,null,null,0,null,0]
[18,null,null,null,0,0,0,0,null,null,0,null,0]
[19,null,null,null,0,0,0,0,null,null,0,null,0]
[20,null,null,null,0,0,0,0,null,null,0,null,0]
[21,null,null,null,0,0,0,0,null,null,0,null,0]
[22,null,null,null,{"$f":"IF($C$9=\"25 or less\",IF(AND(D62>=12,D62<=13.99),14,0),IF($C$9=\"26 or more\",IF(AND(D62>=14,D62<=14.99),15,0),0))","v":0},{"$f":"IF(E62-D62>0,E62-D62,0)","v":0},{"$f":"F62*0.062","v":0},{"$f":"F62*0.0145","v":0},null,null,{"$f":"ROUND((SUM(F62+G62+H62)+(F62*I62)+(F62*J62)),2)","v":0},null,{"$f":"SUM(K62*L62)","v":0}]
[23,null,null,null,0,0,0,0,null,null,0,null,0]
[24,null,null,null,0,0,0,0,null,null,0,null,0]
[25,null,null,null,0,0,0,0,null,null,0,null,0]
[26,null,null,null,0,0,0,0,null,null,0,null,0]
[27,null,null,null,0,0,0,0,null,null,0,null,0]
[28,null,null,null,0,0,0,0,null,null,0,null,0]
[29,null,null,null,0,0,0,0,null,null,0,null,0]
[30,null,null,null,0,0,0,0,null,null,0,null,0]
[31,null,null,null,0,0,0,0,null,null,0,null,0]
[32,null,null,null,0,0,0,0,null,null,0,null,0]
[33,null,null,null,0,0,0,0,null,null,0,null,0]
[34,null,null,null,0,0,0,0,null,null,0,null,0]
[35,null,null,null,0,0,0,0,null,null,0,null,0]
[36,null,null,null,0,0,0,0,null,null,0,null,0]
[37,null,null,null,0,0,0,0,null,null,0,null,0]
[38,null,null,null,0,0,0,0,null,null,0,null,0]
[39,null,null,null,0,0,0,0,null,null,0,null,0]
[40,null,null,null,0,0,0,0,null,null,0,null,0]
[41,null,null,null,0,0,0,0,null,null,0,null,0]
[42,null,null,null,0,0,0,0,null,null,0,null,0]
[43,null,null,null,0,0,0,0,null,null,0,null,0]
[44,null,null,null,0,0,0,0,null,null,0,null,0]
[45,null,null,null,0,0,0,0,null,null,0,null,0]
[46,null,null,null,0,0,0,0,null,null,0,null,0]
[47,null,null,null,0,0,0,0,null,null,0,null,0]
[48,null,null,null,0,0,0,0,null,null,0,null,0]
[49,null,null,null,0,0,0,0,null,null,0,null,0]
[50,null,null,null,0,0,0,0,null,null,0,null,0]
[51,null,null,null,0,0,0,0,null,null,0,null,0]
[52,null,null,null,0,0,0,0,null,null,0,null,0]
[53,null,null,null,0,0,0,0,null,null,0,null,0]
[54,null,null,null,0,0,0,0,null,null,0,null,0]
[55,null,null,null,0,0,0,0,null,null,0,null,0]
[56,null,null,null,0,0,0,0,null,null,0,null,0]
[57,null,null,null,0,0,0,0,null,null,0,null,0]
[58,null,null,null,0,0,0,0,null,null,0,null,0]
[59,null,null,null,0,0,0,0,null,null,0,null,0]
[60,null,null,null,0,0,0,0,null,null,0,null,0]
[61,null,null,null,0,0,0,0,null,null,0,null,0]
[62,null,null,null,0,0,0,0,null,null,0,null,0]
[63,null,null,null,{"$f":"IF($C$9=\"25 or less\",IF(AND(D103>=12,D103<=13.99),14,0),IF($C$9=\"26 or more\",IF(AND(D103>=14,D103<=14.99),15,0),0))","v":0},{"$f":"IF(E103-D103>0,E103-D103,0)","v":0},{"$f":"F103*0.062","v":0},{"$f":"F103*0.0145","v":0},null,null,{"$f":"ROUND((SUM(F103+G103+H103)+(F103*I103)+(F103*J103)),2)","v":0},null,{"$f":"SUM(K103*L103)","v":0}]
[64,null,null,null,0,0,0,0,null,null,0,null,0]
[65,null,null,null,0,0,0,0,null,null,0,null,0]
[66,null,null,null,0,0,0,0,null,null,0,null,0]
[67,null,null,null,0,0,0,0,null,null,0,null,0]
[68,null,null,null,0,0,0,0,null,null,0,null,0]
[69,null,null,null,0,0,0,0,null,null,0,null,0]
[70,null,null,null,0,0,0,0,null,null,0,null,0]
[71,null,null,null,0,0,0,0,null,null,0,null,0]
[72,null,null,null,0,0,0,0,null,null,0,null,0]
[73,null,null,null,0,0,0,0,null,null,0,null,0]
[74,null,null,null,0,0,0,0,null,null,0,null,0]
[75,null,null,null,0,0,0,0,null,null,0,null,0]
[76,null,null,null,0,0,0,0,null,null,0,null,0]
[77,null,null,null,0,0,0,0,null,null,0,null,0]
[78,null,null,null,0,0,0,0,null,null,0,null,0]
[79,null,null,null,0,0,0,0,null,null,0,null,0]
[80,null,null,null,0,0,0,0,null,null,0,null,0]
[81,null,null,null,0,0,0,0,null,null,0,null,0]
[82,null,null,null,0,0,0,0,null,null,0,null,0]
[83,null,null,null,0,0,0,0,null,null,0,null,0]
[84,null,null,null,{"$f":"IF($C$9=\"25 or less\",IF(AND(D124>=12,D124<=13.99),14,0),IF($C$9=\"26 or more\",IF(AND(D124>=14,D124<=14.99),15,0),0))","v":0},{"$f":"IF(E124-D124>0,E124-D124,0)","v":0},{"$f":"F124*0.062","v":0},{"$f":"F124*0.0145","v":0},null,null,{"$f":"ROUND((SUM(F124+G124+H124)+(F124*I124)+(F124*J124)),2)","v":0},null,{"$f":"SUM(K124*L124)","v":0}]
[85,null,null,null,0,0,0,0,null,null,0,null,0]
[86,null,null,null,0,0,0,0,null,null,0,null,0]
[87,null,null,null,0,0,0,0,null,null,0,null,0]
[88,null,null,null,0,0,0,0,null,null,0,null,0]
[89,null,null,null,0,0,0,0,null,null,0,null,0]
[90,null,null,null,0,0,0,0,null,null,0,null,0]
[91,null,null,null,0,0,0,0,null,null,0,null,0]
[92,null,null,null,0,0,0,0,null,null,0,null,0]
[93,null,null,null,0,0,0,0,null,null,0,null,0]
[94,null,null,null,0,0,0,0,null,null,0,null,0]
[95,null,null,null,0,0,0,0,null,null,0,null,0]
[96,null,null,null,0,0,0,0,null,null,0,null,0]
[97,null,null,null,0,0,0,0,null,null,0,null,0]
[98,null,null,null,0,0,0,0,null,null,0,null,0]
[99,null,null,null,0,0,0,0,null,null,0,null,0]
[100,null,null,null,0,0,0,0,null,null,0,null,0]
[101,null,null,null,0,0,0,0,null,null,0,null,0]
[102,null,null,null,0,0,0,0,null,null,0,null,0]
[103,null,null,null,0,0,0,0,null,null,0,null,0]
[104,null,null,null,0,0,0,0,null,null,0,null,0]
[105,null,null,null,0,0,0,0,null,null,0,null,0]
[106,null,null,null,0,0,0,0,null,null,0,null,0]
[107,null,null,null,0,0,0,0,null,null,0,null,0]
[108,null,null,null,0,0,0,0,null,null,0,null,0]
[109,null,null,null,0,0,0,0,null,null,0,null,0]
[110,null,null,null,0,0,0,0,null,null,0,null,0]
[111,null,null,null,0,0,0,0,null,null,0,null,0]
[112,null,null,null,0,0,0,0,null,null,0,null,0]
[113,null,null,null,0,0,0,0,null,null,0,null,0]
[114,null,null,null,0,0,0,0,null,null,0,null,0]
[115,null,null,null,{"$f":"IF($C$9=\"25 or less\",IF(AND(D155>=12,D155<=13.99),14,0),IF($C$9=\"26 or more\",IF(AND(D155>=14,D155<=14.99),15,0),0))","v":0},{"$f":"IF(E155-D155>0,E155-D155,0)","v":0},{"$f":"F155*0.062","v":0},{"$f":"F155*0.0145","v":0},null,null,{"$f":"ROUND((SUM(F155+G155+H155)+(F155*I155)+(F155*J155)),2)","v":0},null,{"$f":"SUM(K155*L155)","v":0}]
[116,null,null,null,{"$f":"IF($C$9=\"25 or less\",IF(AND(D156>=12,D156<=13.99),14,0),IF($C$9=\"26 or more\",IF(AND(D156>=14,D156<=14.99),15,0),0))","v":0},{"$f":"IF(E156-D156>0,E156-D156,0)","v":0},{"$f":"F156*0.062","v":0},{"$f":"F156*0.0145","v":0},null,null,{"$f":"ROUND((SUM(F156+G156+H156)+(F156*I156)+(F156*J156)),2)","v":0},null,{"$f":"SUM(K156*L156)","v":0}]
[117,null,null,null,0,0,0,0,null,null,0,null,0]
[118,null,null,null,0,0,0,0,null,null,0,null,0]
[119,null,null,null,0,0,0,0,null,null,0,null,0]
[120,null,null,null,0,0,0,0,null,null,0,null,0]
[121,null,null,null,0,0,0,0,null,null,0,null,0]
[122,null,null,null,0,0,0,0,null,null,0,null,0]
[123,null,null,null,0,0,0,0,null,null,0,null,0]
[124,null,null,null,0,0,0,0,null,null,0,null,0]
[125,null,null,null,0,0,0,0,null,null,0,null,0]
[126,null,null,null,0,0,0,0,null,null,0,null,0]
[127,null,null,null,0,0,0,0,null,null,0,null,0]
[128,null,null,null,0,0,0,0,null,null,0,null,0]
[129,null,null,null,0,0,0,0,null,null,0,null,0]
[130,null,null,null,0,0,0,0,null,null,0,null,0]
[131,null,null,null,0,0,0,0,null,null,0,null,0]
[132,null,null,null,0,0,0,0,null,null,0,null,0]
[133,null,null,null,0,0,0,0,null,null,0,null,0]
[134,null,null,null,0,0,0,0,null,null,0,null,0]
[135,null,null,null,0,0,0,0,null,null,0,null,0]
[136,null,null,null,0,0,0,0,null,null,0,null,0]
[137,null,null,null,0,0,0,0,null,null,0,null,0]
[138,null,null,null,0,0,0,0,null,null,0,null,0]
[139,null,null,null,0,0,0,0,null,null,0,null,0]
[140,null,null,null,0,0,0,0,null,null,0,null,0]
[141,null,null,null,0,0,0,0,null,null,0,null,0]
[142,null,null,null,0,0,0,0,null,null,0,null,0]
[143,null,null,null,0,0,0,0,null,null,0,null,0]
[144,null,null,null,0,0,0,0,null,null,0,null,0]
[145,null,null,null,0,0,0,0,null,null,0,null,0]
[" ",null,null,null,null,null,null,null,"Totals",null,{"$f":"SUM(K41:K185)","v":0},{"$f":"SUM(L41:L185)","v":0},{"$f":"SUM(M41:M185)","v":0}]
[null," "]
[]
[]
[]
["SECTION C:  RATE ADJUSTMENT CALCULATION (Traditional Services Rate)"]
[1,null,null,null,null,null,"Total Cost of the Minimum Wage Adjustment for the Review Period:",{"$f":"ROUND((E12*M186),2)","v":{"$error":"#DIV/0!"}}]
[2,null,null,null,null,null,"Number of Units of Services Billed to all Regional Centers for the Review Period:",{"$f":"IF(C12=0,0,SUM(H194:H200))","v":0}]
[3,"Select Regional Center from Drop Down Menu:",null,null,null,null,"Enter Total No. of Traditional Service Units for Review Period"]
[4,"Select Regional Center:",null,null,null,null,"Enter Total No. of Traditional Service Units for Review Period"]
[5,"Select Regional Center:",null,null,null,null,"Enter Total No. of Traditional Service Units for Review Period"]
[6,"Select Regional Center:",null,null,null,null,"Enter Total No. of Traditional Service Units for Review Period"]
[7,"Select Regional Center:",null,null,null,null,"Enter Total No. of Traditional Service Units for Review Period"]
[8,"Select Regional Center:",null,null,null,null,"Enter Total No. of Traditional Service Units for Review Period"]
[9,"Select Regional Center:",null,null,null,null,"Enter Total No. of Traditional Service Units for Review Period"]
[10,"Rate Change (Section C, Row 1: Total Cost of Minimum Wage Adjustment/Section C, Row 2: Units of Service Billed to all Regional Centers)",null,null,null,null,null,{"$f":"IFERROR(ROUND(H192/H193,2),0)","v":0}]
[]
["SECTION D:  RATE ADJUSTMENT CALCULATION (Alternative Services Rate)"]
[1,null,null,null,null,null,"Total Cost of the Minimum Wage Adjustment for the Review Period:",{"$f":"ROUND((E16*M186),2)","v":{"$error":"#DIV/0!"}}]
[2,null,null,null,null,null,"Number of Units of Services Billed to all Regional Centers for the Review Period:",{"$f":"IF(C16=0,0,SUM(H206:H212))","v":0}]
[3,"Select Regional Center:",null,null,null,null,"Enter Total No. of Alt Services Units for Review Period"]
[4,"Select Regional Center:",null,null,null,null,"Enter Total No. of Alt Services Units for Review Period"]
[5,"Select Regional Center:",null,null,null,null,"Enter Total No. of Alt Services Units for Review Period"]
[6,"Select Regional Center:",null,null,null,null,"Enter Total No. of Alt Services Units for Review Period"]
[7,"Select Regional Center:",null,null,null,null,"Enter Total No. of Alt Services Units for Review Period"]
[8,"Select Regional Center:",null,null,null,null,"Enter Total No. of Alt Services Units for Review Period"]
[9,"Select Regional Center:",null,null,null,null,"Enter Total No. of Alt Services Units for Review Period"]
[10,"Rate Change (Section D, Row 1: Total Cost of Minimum Wage Adjustment/Section C, Row 2: Units of Service Billed to all Regional Centers)",null,null,null,null,null,{"$f":"IFERROR(+ROUND(H204/H205,2),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["25 or less"]
["26 or more"]
[]
["Daily","Daily"]
["Hourly","Hourly"]
["Monthly","Monthly"]
["Other","Other"]
[]
["ACRC","ACRC"]
["CVRC","CVRC"]
["ELARC","ELARC"]
["FDLRC","FDLRC"]
["FNRC","FNRC"]
["GGRC","GGRC"]
["HRC","HRC"]
["IRC","IRC"]
["KRC","KRC"]
["NBRC","NBRC"]
["NLACRC","NLACRC"]
["RCEB","RCEB"]
["RCOC","RCOC"]
["RCRC","RCRC"]
["SARC","SARC"]
["SCLARC","SCLARC"]
["SDRC","SDRC"]
["SGPRC","SGPRC"]
["TCRC","TCRC"]
["VMRC","VMRC"]
["WRC","WRC"]
[]
["Yes","Yes"]
["No","No"]

{"sheet":"Certification Instructions","index":2,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[[24,0,24,8],[25,0,25,8],[27,0,27,8],[13,0,13,8],[16,0,16,8],[18,0,18,8],[21,0,21,8],[22,0,22,8],[23,0,23,8],[11,0,11,8],[3,0,3,8],[5,0,5,8],[7,0,7,8],[9,0,9,8]]}
["SB 3 MINIMUM WAGE 2022 RATE ADJUSTMENT - COMMUNITY-BASED DAY and WORK ACTIVITY PROGRAMS"]
["SUMMARY & CERTIFICATION INSTRUCTIONS "]
[]
["These instructions are for the Vendor Summary & Certification.   After you read these instructions, please go to the “Vendor Summary & Certification” tab.  Please review the Program Information and enter the service address associated with the information submitted on this workbook.  If your program has a different mailing address than the service address, please enter this information."]
[]
["Please enter the requested Contact Information for the individual responsible for completing this workbook.  This information will include Contact Name, Contact Phone Number, Email Address, and Executive Director/Owner."]
[]
["Please review the current rate, proposed rate change, and the proposed new rate, which are calculated based on the information you have entered on the worksheet.  If there is an error message in the rate information, go back and review the information in the worksheet. "]
[]
["We ask that you save this workbook using your vendor number and service code in the title of the file name.  For example, \"H12345 510.xlsm\", then email the workbook to ACRC at \"minwage@altaregional.org” "]
[]
["PLEASE NOTE:  By clicking the “I AGREE” checkbox near the bottom of the “Vendor Summary & Certification” worksheet, you certify that the information provided to the Department is specific to payroll costs necessary to meet the requirements of the minimum wage increase effective January 1, 2022.  You additionally certify to the best of your knowledge and belief that the information submitted is true and correct, and subject to verification by all record keeping and audit processes, procedures, and guidelines under the Lanterman Act and Title 17 of the California Code of Regulations (CCR)."]
[]
["You must retain ALL backup documentation which supports the information being submitted in this workbook.  The backup information for the information provided on this workbook is subject to all record keeping and audit processes, procedures, and guidelines under the Lanterman Act and Title 17, CCR.  "]
[" "]
["EMAIL ADDRESS:"]
["minwage@altaregional.org"]

{"sheet":"Vendor Summary & Certification","index":3,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[22,2,22,5],[23,2,23,5],[2,0,2,8],[25,2,25,5],[34,0,39,8],[43,4,43,6],[44,0,44,3],[44,5,44,7],[24,2,24,5],[5,2,5,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5]]}
["SB 3 MINIMUM WAGE 2022 RATE ADJUSTMENT - NEGOTIATED RATE SERVICES"]
["SUMMARY & CERTIFICATION SHEET "]
["100% Traditional Services or Traditional/Alternative Services Mix Workbook"]
["PROGRAM INFORMATION"]
[]
["Service Provider Name:",null,{"$f":"'Vendor Worksheet'!C5:H5","v":0}]
["Vendor Number:",null,{"$f":"'Vendor Worksheet'!C6:H6","v":0}]
["Service Code:",null,{"$f":"'Vendor Worksheet'!C7:H7","v":0}]
["Number of Employees:",null,{"$f":"'Vendor Worksheet'!C9:H9","v":0}]
[]
["Service Address:"]
[]
[]
[]
[]
["Mailing Address:"]
["(if different than service address)"]
[]
[]
[]
["CONTACT INFORMATION"]
[null,null,"Individual Responsible for Completing Worksheet:"]
["Contact Name:"]
["Contact Phone Number:"]
["Email Address:"]
["Executive Director/Owner:"]
[]
["Alternative Services Rate",null,null,null,"Traditional Services Rate"]
["Current Rate:",null,{"$f":"'Vendor Worksheet'!C24","v":0},null,"Current Rate:",null,{"$f":"'Vendor Worksheet'!C21","v":0}]
["Proposed Rate Change:",null,{"$f":"'Vendor Worksheet'!C25","v":0},null,"Proposed Rate Change:",null,{"$f":"'Vendor Worksheet'!C22","v":0}]
["Proposed New Rate:",null,{"$f":"'Vendor Worksheet'!C26","v":0},null,"Proposed New Rate:",null,{"$f":"'Vendor Worksheet'!C23","v":0}]
["Unit Type:",null,{"$f":"'Vendor Worksheet'!H24","v":"Monthly"},null,"Unit Type:",null,{"$f":"Daily","v":0}]
[]
[]
["By checking the box below, I certify that the information provided to ACRC is specific to payroll costs necessary to meet the requirements of the minimum wage increase effective January 1, 2022.  I additionally certify to the best of my knowledge and belief the information submitted is true and correct, and subject to verification by all record keeping and audit processes, procedures, and guidelines under the Lanterman Act and Title 17 of the California Code of Regulations.  "]
[]
[]
[]
[]
[]
[null,null,null,"I AGREE"]
[]
[]
[]
[]
[]
["Please keep a copy for your records."]