{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Calculator","Vendor Summary & Certification"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,0,3,1],[6,0,6,1]]}
[null,"                                                                                                                                                                                                                                                                               Prepared by"]
[]
[]
["Coronavirus Under-Utilization Calculator\nUtilization Rate By Consumer: Sample Data"]
[]
["DDS Statement"]
["DDS has reviewed the worksheets and, if calculations work as intended, they can be used as an option for documenting the average number of absences/utilization to help support claiming in response to the State of Emergency declared by the Governor on March 4, 2020.  Use of these worksheets is not required, however the provider must keep supporting documentation that is subject to audit.  See the DDS website for further information.  "]
[]
["General Instructions"]
[1,"Spreadsheet applies to one service code only. If multiple service codes are needed, multiple spreadsheets have to be completed."]
[2,"It is assumed that any POS with zero utilization or unissued will receive no emergency funding. These POS's utilization rates cannot be established."]
[3,"One-time POS's are excluded."]
[4,"Assumes Regional Centers (RCs) will track units for the applicable service months over their normal billing period. For instance, if a vendor bills the 30 units provided on a given POS for the service month of March, 2020 and attempts to later bill 23 units on the same POS and service month, it is assumed the RC will reject the 23 units as they've already paid 30."]
[5,"It is assumed RCs can track POS's issued, allotted POS units for a given service month and units utilized."]
[]
["Calculator"]
["A","Number of lines populates automatically."]
["B","Enter Consumer UCI No."]
["C","Enter initials of consumer."]
["D","Enter all POS's for a given consumer and given service code covering the period of March 2019 - February 2020. This is the period that will be used to establish your utilization rate. If you prefer to use a different lookback period, please consult your Regional Center. If the vendor has POS #123 for 3/1/19-6/30/19 and POS #456 that runs from 7/1/19-2/29/20, vendor will include both POS's here. If you wish to use the 2019 calendar year, please notify your Regional Center that you are using this lookback period."]
["E","Add up all units of service on all applicable POS's for the lookback period and enter here. For ILS, Respite and Day Care services 1 Unit = 1 Hour. For Day Programs 1 Unit = 1 Day. NOTE: Do not include units for canceled POS's. For instance, POS #123 is for January-December and allotted 30 units a month, with total annual units of 360. POS #123 is cancelled and replaced by POS #456 for July-December with 10 units per month. Report total allotted units as 240, that is report 180 units for POS #123 and report 60 units for POS #456. Ignore POS #123 for service months July-December, because it was cancelled and replaced by POS #456."]
["F","Enter utilized units in the lookback period."]
["G","Utilization Rate is calculated as Total Utilized Units/Total Allotted Units (F/E) on a per consumer basis."]
["H","Enter POS covering March 2020. If a consumer has multiple POS's enter one POS per row, and enter multiple lines for the same consumer."]
["I","Period of POS is selected (Monthly or Quarterly)."]
["J","POS allotted units per Period."]
["K","Months in Quarter calculates the month in the quarter, to be used to calculate Projected Units in N. For January, April, July, and October, the cell returns a 1. For February, May, August, November, the cell returns a 2. For March, June, September, and December the cell returns a 3."]
["L","Enter the units billed previously in the Quarter. For instance, if the vendor billed service units for January and February and are currently billing the service month of March, enter those January and February units here."]
["M","Calculates the Utilization Rate x Allotted Units."]
["N","Projected Units are calculated differently depending on the POS Period. For monthly POSs, the Projected Units are Allotted Units * Utilization Rate (J x G). For Quarterly POS's we determine the month of the quarter (1st, 2nd or 3rd) in I. The calculator then prorates the units based on the month of the quarter. The first month of the quarter is allocated 33% of the total units on the POS, the second month of the quarter is allocated 66%, and the third 100%."]
["O","eBill units are completed by the vendor. These are the units that would have billed without emergency funding and are the units of service provided by a DSP. For quarterly POS's, include all units that have been billed earlier in the quarter. For instance, if there were units billed in January and February, include those units here."]
["P","SOE Units (State of Emergency Units) calculates the number of units that are being billed, over and above the eBill units. Please bill all SOE Units on the last day of the month."]
["Q","Remittable Units takes the greater of Projected Units (N) or eBill Units (O). "]
["R","Enter the billable rate provided by the Regional Center."]
["S","Remittance takes the Billable Rate and multiplies it by the Remittable Units."]

{"sheet":"Calculator","index":1,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,0,1,18],[3,0,3,18],[5,3,5,6],[5,1,5,2],[5,0,6,0],[5,10,5,12],[5,7,5,9],[5,13,5,18]]}
["Sample Agency Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly","January"]
["Coronavirus Under-Utilization Calculator\nUtilization Rate by Consumer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quarterly","February"]
[null,null,null,null,null,null,null,null,"ENTER Service Code","862","ENTER Service Month","January",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April"]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S",null,null,null,null,null,null,null,null,"May"]
["No.","Consumer Information",null,"Utilization Rate Calculation",null,null,null,"POS",null,null,"Complete for Quarterly POS's Only",null,null,"Remittance",null,null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,"UCI","Consumer Initials","All POS's for Consumer in Utilization Period","Total Allotted Units (all POS's) for Lookback Period\nSee Instructions","Total Actual Utilized Units for Lookback Period","Utilization Rate","POS per Period","Period\n(Select Monthly or Quarterly)"," POS Allotted Units per Period","Month in Quarter \n(1st, 2nd or 3rd)","Quarterly POS's:\nPreviously Billed Units for Current Quarter","Utilization Rate x Allotted\nUnits\n(G x J) ","Projected Units","eBill Units for Current Service Month (Actual Service)","SOE Units","Remittable Units","Bill Rate","Remittance",null,null,null,null,null,null,null,null,"July"]
[1,9994444,"MS","19011111, 19455566",200,100,{"$f":"+IF(F8>0,F8/E8,0)","v":0.5},20455566,"Monthly",30,{"$f":"+IF($L$3=\"January\",1,IF($L$3=\"February\",2,IF($L$3=\"March\",3,IF($L$3=\"April\",1,IF($L$3=\"May\",2,IF($L$3=\"June\",3,IF($L$3=\"July\",1,IF($L$3=\"August\",2,IF($L$3=\"September\",3,IF($L$3=\"October\",1,IF($L$3=\"November\",2,IF($L$3=\"December\",3,0))))))))))))","v":1},100,{"$f":"+J8*G8","v":15},{"$f":"+IF(IF(I8=\"Monthly\",G8*J8,IF(I8=\"Quarterly\",IF(IF(K8=1,M8*0.333,IF(K8=2,M8*0.66666,M8))>(M8-L8),(M8-L8),IF(K8=1,M8*0.333,IF(K8=2,M8*0.66666,M8)))))<0,0,IF(I8=\"Monthly\",G8*J8,IF(I8=\"Quarterly\",IF(IF(K8=1,M8*0.333,IF(K8=2,M8*0.66666,1*M8))>(M8-L8),(M8-L8),IF(K8=1,M8*0.333,IF(K8=2,M8*0.66666,1*M8))))))","v":15},10,{"$f":"+IF(AND((N8-O8)>0,N8>O8),N8-O8,0)","v":5},{"$f":"+IF(O8<N8,N8,O8)","v":15},25,{"$f":"+Q8*R8","v":375},null,null,null,null,null,null,null,null,"August"]
[2,9995555,"YZ","19022222, 19055555",200,100,{"$f":"+IF(F9>0,F9/E9,0)","v":0.5},20055555,"Monthly",90,{"$f":"+IF($L$3=\"January\",1,IF($L$3=\"February\",2,IF($L$3=\"March\",3,IF($L$3=\"April\",1,IF($L$3=\"May\",2,IF($L$3=\"June\",3,IF($L$3=\"July\",1,IF($L$3=\"August\",2,IF($L$3=\"September\",3,IF($L$3=\"October\",1,IF($L$3=\"November\",2,IF($L$3=\"December\",3,0))))))))))))","v":1},null,{"$f":"+J9*G9","v":45},{"$f":"+IF(IF(I9=\"Monthly\",G9*J9,IF(I9=\"Quarterly\",IF(IF(K9=1,M9*0.333,IF(K9=2,M9*0.66666,M9))>(M9-L9),(M9-L9),IF(K9=1,M9*0.333,IF(K9=2,M9*0.66666,M9)))))<0,0,IF(I9=\"Monthly\",G9*J9,IF(I9=\"Quarterly\",IF(IF(K9=1,M9*0.333,IF(K9=2,M9*0.66666,1*M9))>(M9-L9),(M9-L9),IF(K9=1,M9*0.333,IF(K9=2,M9*0.66666,1*M9))))))","v":45},50,{"$f":"+IF(AND((N9-O9)>0,N9>O9),N9-O9,0)","v":0},{"$f":"+IF(O9<N9,N9,O9)","v":50},25,{"$f":"+Q9*R9","v":1250},null,null,null,null,null,null,null,null,"September"]
[3,null,null,null,200,100,{"$f":"+IF(F10>0,F10/E10,0)","v":0.5},20055556,"Quarterly",90,1,5,45,14.985000000000001,5,9.9850000000000012,14.985000000000001,25,374.62500000000006,null,null,null,null,null,null,null,null,"October"]
[4,null,null,null,null,null,{"$f":"+IF(F11>0,F11/E11,0)","v":0},null,null,null,1,null,{"$f":"+J11*G11","v":0},{"$f":"+IF(IF(I11=\"Monthly\",G11*J11,IF(I11=\"Quarterly\",IF(IF(K11=1,M11*0.333,IF(K11=2,M11*0.66666,M11))>(M11-L11),(M11-L11),IF(K11=1,M11*0.333,IF(K11=2,M11*0.66666,M11)))))<0,0,IF(I11=\"Monthly\",G11*J11,IF(I11=\"Quarterly\",IF(IF(K11=1,M11*0.333,IF(K11=2,M11*0.66666,1*M11))>(M11-L11),(M11-L11),IF(K11=1,M11*0.333,IF(K11=2,M11*0.66666,1*M11))))))","v":false},null,{"$f":"+IF(AND((N11-O11)>0,N11>O11),N11-O11,0)","v":0},{"$f":"+IF(O11<N11,N11,O11)","v":0},null,{"$f":"+Q11*R11","v":0},null,null,null,null,null,null,null,null,"November"]
[5,null,null,null,null,null,{"$f":"+IF(F12>0,F12/E12,0)","v":0},null,null,null,{"$f":"+IF($L$3=\"January\",1,IF($L$3=\"February\",2,IF($L$3=\"March\",3,IF($L$3=\"April\",1,IF($L$3=\"May\",2,IF($L$3=\"June\",3,IF($L$3=\"July\",1,IF($L$3=\"August\",2,IF($L$3=\"September\",3,IF($L$3=\"October\",1,IF($L$3=\"November\",2,IF($L$3=\"December\",3,0))))))))))))","v":1},null,0,false,null,0,0,null,0,null,null,null,null,null,null,null,null,"December"]
[6,null,null,null,null,null,0,null,null,null,1,null,0,false,null,0,0,null,0]
[7,null,null,null,null,null,0,null,null,null,1,null,0,false,null,0,0,null,0]
[8,null,null,null,null,null,0,null,null,null,1,null,0,false,null,0,0,null,0]
[9,null,null,null,null,null,0,null,null,null,1,null,0,false,null,0,0,null,0]
[10,null,null,null,null,null,0,null,null,null,1,null,0,false,null,0,0,null,0]
[11,null,null,null,null,null,0,null,null,null,1,null,0,false,null,0,0,null,0]
[null,null,null,null,{"$f":"SUM(E8:E18)","v":600},{"$f":"SUM(F8:F18)","v":300},null,null,null,{"$f":"SUM(J8:J18)","v":210},null,{"$f":"SUM(L8:L18)","v":105},105,74.984999999999999,65,14.985000000000001,79.984999999999999,null,{"$f":"SUM(S8:S18)","v":1999.625}]
[]
[null,"Vendor to enter grayed cells."]
[null,"Vendor to enter yellow cells."]

{"sheet":"Vendor Summary & Certification","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,0,21,2],[21,3,21,6],[25,0,28,7],[18,3,18,6],[19,3,19,6],[20,3,20,6],[18,0,18,2],[19,0,19,2],[20,0,20,2],[16,0,16,2],[6,3,6,6],[8,3,8,6],[5,0,5,2],[6,0,6,2],[9,3,9,6],[10,3,10,6],[8,0,8,2],[12,0,12,2],[12,3,12,6],[13,3,13,6],[14,3,14,6],[0,0,0,7],[1,0,1,7],[4,0,4,2],[4,3,4,6],[5,3,5,6],[3,0,3,2]]}
["Coronavirus Under-Utilization Calculator\nUtilization Rate by Consumer"]
["Summary & Certification Sheet"]
[]
["PROGRAM INFORMATION"]
["Service Provider Name:"]
["Vendor Number:"]
["Service Code:"]
[]
["Service Address:"]
[]
[]
[]
["Mailing Address:"]
[]
[]
[]
["CONTACT INFORMATION"]
[null,null,null,"Individual Responsible for Completing Worksheet"]
["Contact Name:"]
["Contact Phone Number:"]
["Email Address:"]
["Executive Director/Owner"]
[]
[]
[]
["By checking the box above, I agree that for each unit of State of Emergency (SOE) remittance received, there will be a wage payment to the Direct Service Professional(s) that would have provided the service, and that wage equals or is greater than the previous wage paid to these employees. I understand that these wage payments to Direct Service Professional(s), as well as all information contained within this calculator is 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. I additionally certify that the information provided to the Department is true and correct to the best of my knowledge."]