{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":40,"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":"Worksheet","index":0,"n_rows":990,"n_cols":30,"rows_kept":990,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,12,1,23],[0,3,0,4],[2,18,2,20],[2,21,2,23],[1,5,1,11],[2,24,2,26],[2,27,2,29],[1,24,1,29],[10,1,10,3],[2,12,2,14],[2,15,2,17],[9,1,9,3]]}
["2026-03-01","Regional Center"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of staff and full-time equivalents (FTE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Medicaid Waiver ",null,null,"Age 0-5",null,null,"\nMoved from DC, in community less than 12 months",null,null,"All other consumers",null,null,"Complex Conusmers",null,null,"Low/No Pos Consumers"]
["Vacancy Date","Type of staff","Initials","% time worked ","Total consumers    ( Not Including Complex & Low/No)","Medicaid Waiver"," Age 0-5","Moved from DC within last 12 months","All others","Complex","Low/No Pos","C/N T19%","# staff full time ","# staff less than full time","FTE","# staff full time ","# staff less than full time","FTE","# staff full time ","# staff less than full time","FTE","# staff full time ","# staff less than full time","FTE","# staff full time ","# staff less than full time","FTE","# staff full time ","# staff less than full time","FTE"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(D5),ISBLANK(F5),A5<>\"\"),\" \",IF(AND(D5=1,F5>=1),1,\" \"))","v":" "},{"$f":"IF(OR(ISBLANK(D5),ISBLANK(F5),A5<>\"\"),\" \",IF(AND(D5<1,F5>=1),1,\" \"))","v":" "},{"$f":"IF(OR(F5=\"\",E5<1,A5<>\"\"),\"\",(F5/(F5+G5+H5+I5+K5)*D5))","v":""},{"$f":"IF(AND(A5=\"\",D5=1,G5>0),1,IF(AND(G5>1,D5=1,_xlfn.DAYS($A$1,A5)<60),1,\"\"))","v":""},{"$f":"IF(AND(A5=\"\",D5<1,G5>0),1,IF(AND(D5<1,G5>0,_xlfn.DAYS($A$1,A5)<60),1,\"\"))","v":""},{"$f":"IF(OR(AND(A5<>\"\",_xlfn.DAYS($A$1,A5)>60),E5=0,ISBLANK(D5),ISBLANK(G5)),\"\",($G5/(F5+G5+H5+I5+K5)*D5))","v":""},{"$f":"IF(AND(A5=\"\",D5=1,H5>0),1,IF(AND(H5>0,D5=1,_xlfn.DAYS($A$1,A5)<60),1,\"\"))","v":""},{"$f":"IF(AND(A5=\"\",D5<1,H5>0),1,IF(AND(D5<1,H5>0,_xlfn.DAYS($A$1,A5)<60),1,\"\"))","v":""},{"$f":"IF(OR(AND(A5<>\"\",_xlfn.DAYS($A$1,A5)>60),E5=0,ISBLANK(D5),ISBLANK(H5)),\"\",(H5/(F5+G5+H5+I5+K5)*D5))","v":""},{"$f":"IF(AND(A5=\"\",D5=1,I5>0),1,IF(AND(I5>0,D5=1,_xlfn.DAYS($A$1,A5)<60),1,\"\"))","v":""},{"$f":"IF(AND(A5=\"\",D5<1,I5>1),1,IF(AND(D5<1,I5>0,_xlfn.DAYS($A$1,A5)<60),1,\"\"))","v":""},{"$f":"IF(OR(AND(A5<>\"\",_xlfn.DAYS($A$1,A5)>60),E5=0,ISBLANK(D5),ISBLANK(I5)),\"\",(I5/(F5+G5+H5+I5+K5)*D5))","v":""},{"$f":"IF(AND(A5=\"\",D5=1,J5>0),1,IF(AND(J5>0,D5=1,_xlfn.DAYS($A$1,A5)<60),1,\"\"))","v":""},{"$f":"IF(OR(ISBLANK($D5),ISBLANK(J5)),\" \",IF(AND($D5<1,J5>=1),1,\" \"))","v":" "},{"$f":"IF(Y5=\"\",\"\",(L5*D5))","v":""},{"$f":"IF(OR(ISBLANK($D5),ISBLANK(K5)),\" \",IF(AND($D5=1,K5>=1),1,\" \"))","v":" "},{"$f":"IF(OR(ISBLANK($D5),ISBLANK(K5)),\" \",IF(AND($D5<1,K5>=1),1,\" \"))","v":" "},{"$f":"IF(K5<1,\"\",(1*D5)*(K5/(F5+G5+H5+I5+K5)))","v":""}]
[]
["Totals",null,{"$f":"COUNTA(C5:C6)","v":0},null,{"$f":"SUM(E5:E6)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(M5:M6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"COUNTIF(A5:A7,\">1\")","v":0},"Vacancies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O7","v":0},null,null,{"$f":"R8+R7","v":0},null,null,{"$f":"U8+U7","v":0},null,null,{"$f":"X8+X7","v":0},null,null,{"$f":"AA7+AA8","v":0},null,null,{"$f":"AD7+AD8","v":0}]
[null,"Actual ratio",null,null,null,{"$f":"IF(F7=0,0,F7/O9)","v":0},{"$f":"IF(G7=0,0,G7/R9)","v":0},{"$f":"IF(H7=0,0,H7/U9)","v":0},{"$f":"IF(I7=0,0,I7/X9)","v":0},{"$f":"IF(J7=0,0,J7/AA9)","v":0},{"$f":"IF(K7=0,0,K7/AD9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total FTE's",null,{"$f":"O9+R9+U9+X9+AA9+AD9","v":0}]
[null,"Required ratio",null,null,null,62,40,45,66,25,40]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,{"$f":"IF(K984<1,\"\",(1*D984))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(D984),ISBLANK(F984),A984<>\"\"),\" \",IF(AND(D984=1,F984>=1),1,\" \"))","v":" "},{"$f":"IF(OR(ISBLANK(D984),ISBLANK(F984),A984<>\"\"),\" \",IF(AND(D984<1,F984>=1),1,\" \"))","v":" "},{"$f":"IF(OR(F984=\"\",E984<1,A984<>\"\"),\"\",(F984/(F984+G984+H984+I984+K984)*D984))","v":""},{"$f":"IF(AND(A984=\"\",D984=1,G984>0),1,IF(AND(G984>1,D984=1,_xlfn.DAYS($A$1,A984)<60),1,\"\"))","v":""},{"$f":"IF(AND(A984=\"\",D984<1,G984>0),1,IF(AND(D984<1,G984>0,_xlfn.DAYS($A$1,A984)<60),1,\"\"))","v":""},{"$f":"IF(OR(AND(A984<>\"\",_xlfn.DAYS($A$1,A984)>60),E984=0,ISBLANK(D984),ISBLANK(G984)),\"\",($G984/(F984+G984+H984+I984+K984)*D984))","v":""},{"$f":"IF(AND(A984=\"\",D984=1,H984>0),1,IF(AND(H984>0,D984=1,_xlfn.DAYS($A$1,A984)<60),1,\"\"))","v":""},{"$f":"IF(AND(A984=\"\",D984<1,H984>0),1,IF(AND(D984<1,H984>0,_xlfn.DAYS($A$1,A984)<60),1,\"\"))","v":""},{"$f":"IF(OR(AND(A984<>\"\",_xlfn.DAYS($A$1,A984)>60),E984=0,ISBLANK(D984),ISBLANK(H984)),\"\",(H984/(F984+G984+H984+I984+K984)*D984))","v":""},{"$f":"IF(AND(A984=\"\",D984=1,I984>0),1,IF(AND(I984>0,D984=1,_xlfn.DAYS($A$1,A984)<60),1,\"\"))","v":""},{"$f":"IF(AND(A984=\"\",D984<1,I984>1),1,IF(AND(D984<1,I984>0,_xlfn.DAYS($A$1,A984)<60),1,\"\"))","v":""},{"$f":"IF(OR(AND(A984<>\"\",_xlfn.DAYS($A$1,A984)>60),E984=0,ISBLANK(D984),ISBLANK(I984)),\"\",(I984/(F984+G984+H984+I984+K984)*D984))","v":""},{"$f":"IF(OR(ISBLANK($D984),ISBLANK(J984)),\" \",IF(AND($D984=1,J984>=1),1,\" \"))","v":" "},{"$f":"IF(OR(ISBLANK($D984),ISBLANK(J984)),\" \",IF(AND($D984<1,J984>=1),1,\" \"))","v":" "},{"$f":"IF(ISBLANK(J984),\"\",(L984*D984))","v":""},{"$f":"IF(OR(ISBLANK($D984),ISBLANK(K984)),\" \",IF(AND($D984=1,K984>=1),1,\" \"))","v":" "},{"$f":"IF(OR(ISBLANK($D984),ISBLANK(K984)),\" \",IF(AND($D984<1,K984>=1),1,\" \"))","v":" "},{"$f":"IF(K984<1,\"\",(1*D984)*(K984/(F984+G984+H984+I984+K984)))","v":""}]
[]
[]
[]
["SC"]
["CSM"]
["Other"]

{"sheet":"Sheet2","index":1,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
["Alta"]
["Central Valley"]
["East Bay"]
["East Los Angeles"]
["Far Northern"]
["Golden Gate"]
["Harbor"]
["Inland"]
["Kern"]
["Lanterman"]
["North Bay"]
["North Los Angeles"]
["Orange"]
["Redwood Coast"]
["San Andreas"]
["San Diego"]
["San Gabriel/Pomona"]
["South Central LA"]
["Tri Counties"]
["Valley Mountain"]
["Westside"]