{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Data","index":0,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[61,0,61,1],[101,2,101,3],[102,2,102,3],[90,6,90,7],[89,6,89,7],[93,6,93,7],[94,6,94,7],[95,6,95,7],[94,2,94,3],[95,2,95,3],[93,2,93,3],[101,6,101,7],[102,6,102,7],[96,6,96,7],[98,6,98,7],[97,6,97,7],[99,6,99,7],[106,6,106,7],[103,6,103,7],[105,2,105,3],[106,2,106,3],[103,2,103,3],[105,6,105,7],[104,6,104,7],[104,2,104,3],[92,6,92,7],[92,2,92,3],[1,0,1,8],[100,6,100,7],[91,6,91,7],[91,2,91,3],[100,2,100,3],[96,2,96,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[21,3,21,4],[55,0,57,8],[49,3,49,4],[29,3,29,4],[88,2,88,3],[90,2,90,3],[88,6,88,7],[31,3,31,4],[48,3,48,4],[47,3,47,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[46,3,46,4],[61,3,61,6],[87,2,87,3],[86,6,86,7],[87,6,87,7],[45,3,45,4],[86,2,86,3],[22,3,22,4],[23,3,23,4],[24,3,24,4],[26,3,26,4],[89,2,89,3],[39,3,39,4],[27,3,27,4],[28,3,28,4],[35,3,35,4],[41,3,41,4],[61,8,61,9],[25,3,25,4],[62,0,62,1],[62,7,62,8],[2,6,2,7],[2,1,2,4],[54,7,54,8],[3,1,3,2],[58,0,58,1],[32,3,32,4],[34,3,34,4],[36,3,36,4],[33,3,33,4],[37,3,37,4],[38,3,38,4],[3,6,3,7]]}
[null,null,null,"REGIONAL CENTER OF THE EAST BAY"]
["Specialized Day Care (Adult) Hours Calculation Sheet"]
["Name of CLIENT",null,null,null,null,"UCI",null,null,null,null,"Age of client at POS start date"]
["Start date of POS  (m/dd/yyyy)",null,null,null,null,"DOB",null,null,null,null,{"$f":"DATEDIF($G$4,$B$4,\"y\")&\" years, \"&DATEDIF($G$4,$B$4,\"ym\")&\" months, \"&DATEDIF($G$4,$B$4,\"md\")&\" days \"","v":"0 years, 0 months, 0 days "}]
[]
["Basic Information Needed for Calculation",null,null,"(AM and PM required)",null,null,"Time PARENT leaves for work (enter time AM or PM)"]
["Time Client LEAVES home for (regular) program:",null,null,null,null,null,"Time PARENT arrives home  (enter time AM or PM)"]
["Time Client ARRIVES home from (regular) program:"]
["Time Client ARRIVES home (minimum day):"]
["Time Client ARRIVES home (miscellaneous day):"]
[]
[]
["Calculated Adult Care Need Hourly"]
["Morning Hours  (if parents leave home )",null,null,{"$f":"IF(D7<K6,0,((D7-K6)*1440)/60)","v":0},null,null,"CASEMANAGERS: ONLY COMPLETE THE GREY SHADED CELLS"]
["Regular Program Day hours",null,null,{"$f":"IF(D8=\"\",0, (IF(K7<D8,0,((K7-D8)*1440/60))))","v":0},"per day"]
["Minimum Day Hours",null,null,{"$f":"IF(D9=\"\",0,(K7-D9)*1440)/60","v":0},"per day"]
["Miscellaneous Minimum Program Day ",null,null,{"$f":"IF(D10=\"\",0,(K7-D10)*1440)/60","v":0},"per day"," "]
["Program Closure ",null,null,{"$f":"((K7-K6)*1440)/60","v":0},"per day"]
[]
[]
[null,"ENTER DAYS BASED ON PROGRAM SCHEDULE in GREY BOXES FOR EACH MONTH.  DO NOT USE NEGATIVE NUMBERS"]
["Month/Year",{"$f":"B4","v":"00:00:00"},null,"Month/Year",null,{"$f":"EOMONTH(B22,1)","v":"1900-02-28"},null,"Month/Year",{"$f":"EOMONTH(F22,1)","v":"1900-03-31"},null,"Month/Year",{"$f":"EOMONTH(I22,1)","v":"1900-04-30"}]
["Morning",null,null,"Morning",null,null,null,"Morning",null,null,"Morning"]
["Regular Program Day ",null,null,"Regular Program Day ",null,null,null,"Regular Program Day ",null,null,"Regular Program Day "]
["Minimum Day",null,null,"Minimum Day",null,null,null,"Minimum Day",null,null,"Minimum Day"]
["Misc Minimum Program Day",null,null,"Misc Minimum Program Day",null,null,null,"Misc Minimum Program Day",null,null,"Misc Minimum Program Day"]
["Program Closed",null,null,"Program Closed",null,null,null,"Program Closed",null,null,"Program Closed"]
["Parent Vacation Day",null,null,"Parent Vacation Day",null,null,null,"Parent Vacation Day",null,null,"Parent Vacation Day"]
["Federal Holiday",null,null,"Federal Holiday",null,null,null,"Federal Holiday",null,null,"Federal Holiday"]
["TOTAL Monthly HOURS ",{"$f":"ROUND(((B23*$D$14)+(B24*$D$15)+(B25*$D$16)+(B26*$D$17)+(B27*$D$18)-((B28*$D$14)+(B28*$D$15))-(B29*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",null,{"$f":"ROUND(((F23*$D$14)+(F24*$D$15)+(F25*$D$16)+(F26*$D$17)+(F27*$D$18)-(F28*$D$14)-(F28*$D$15)-(F29*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",{"$f":"ROUND(((I23*$D$14)+(I24*$D$15)+(I25*$D$16)+(I26*$D$17)+(I27*$D$18)-(I28*$D$14)-(I28*$D$15)-(I29*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",{"$f":"ROUND(((L23*$D$14)+(L24*$D$15)+(L25*$D$16)+(L26*$D$17)+(L27*$D$18)-(L28*$D$14)-(L28*$D$15)-(L29*$D$18)),0)","v":0}]
[]
["Month/Year",{"$f":"EOMONTH(L22,1)","v":"1900-05-31"},null,"Month/Year",null,{"$f":"EOMONTH(B32,1)","v":"1900-06-30"},null,"Month/Year",{"$f":"EOMONTH(F32,1)","v":"1900-07-31"},null,"Month/Year",{"$f":"EOMONTH(I32,1)","v":"1900-08-31"}]
["Morning",null,null,"Morning",null,null,null,"Morning",null,null,"Morning"]
["Regular School Day ",null,null,"Regular School Day ",null,null,null,"Regular School Day",null,null,"Regular School Day "]
["Minimum Day",null,null,"Minimum Day",null,null,null,"Minimum Day",null,null,"Minimum Day"]
["Misc Minimum Program Day",null,null,"Misc Minimum Program Day",null,null,null,"Misc Minimum Program Day",null,null,"Misc Minimum Program Day"]
["Program Closed",null,null,"Program Closed",null,null,null,"Program Closed",null,null,"Program Closed"]
["Parent Vacation Day",null,null,"Parent Vacation Day",null,null,null,"Parent Vacation Day",null,null,"Parent Vacation Day"]
["Federal Holiday",null,null,"Federal Holiday",null,null,null,"Federal Holiday",null,null,"Federal Holiday"]
["TOTAL Monthly HOURS ",{"$f":"ROUND(((B33*$D$14)+(B34*$D$15)+(B35*$D$16)+(B36*$D$17)+(B37*$D$18)-(B38*$D$14)-(B38*$D$15)-(B39*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",null,{"$f":"ROUND(((F33*$D$14)+(F34*$D$15)+(F35*$D$16)+(F36*$D$17)+(F37*$D$18)-(F38*$D$14)-(F38*$D$15)-(F39*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",{"$f":"ROUND(((I33*$D$14)+(I34*$D$15)+(I35*$D$16)+(I36*$D$17)+(I37*$D$18)-(I38*$D$14)-(I38*$D$15)-(I39*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",{"$f":"ROUND(((L33*$D$14)+(L34*$D$15)+(L35*$D$16)+(L36*$D$17)+(L37*$D$18)-(L38*$D$14)-(L38*$D$15)-(L39*$D$18)),0)","v":0}]
[]
["Month/Year",{"$f":"EOMONTH(L32,1)","v":"1900-09-30"},null,"Month/Year",null,{"$f":"EOMONTH(B42,1)","v":"1900-10-31"},null,"Month/Year",{"$f":"EOMONTH(F42,1)","v":"1900-11-30"},null,"Month/Year",{"$f":"EOMONTH(I42,1)","v":"1900-12-31"}]
["Morning",null,null,"Morning",null,null,null,"Morning",null,null,"Morning"]
["Regular School Day ",null,null,"Regular School Day ",null,null,null,"Regular School Day ",null,null,"Regular School Day "]
["Minimum Day",null,null,"Minimum Day",null,null,null,"Minimum Day",null,null,"Minimum Day"]
["Misc Minimum Program Day",null,null,"Misc Minimum Program Day",null,null,null,"Misc Minimum Program Day",null,null,"Misc Minimum Program Day"]
["Program Closed",null,null,"Program Closed",null,null,null,"Program Closed",null,null,"Program Closed"]
["Parent Vacation Day",null,null,"Parent Vacation Day",null,null,null,"Parent Vacation Day",null,null,"Parent Vacation Day"]
["Federal Holiday",null,null,"Federal Holiday",null,null,null,"Federal Holiday",null,null,"Federal Holiday"]
["TOTAL Monthly HOURS ",{"$f":"ROUND(((B43*$D$14)+(B44*$D$15)+(B45*$D$16)+(B46*$D$17)+(B47*$D$18)-(B48*$D$14)-(B48*$D$15)-(B49*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",null,{"$f":"ROUND(((F43*$D$14)+(F44*$D$15)+(F45*$D$16)+(F46*$D$17)+(F47*$D$18)-(F48*$D$14)-(F48*$D$15)-(F49*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",{"$f":"ROUND(((I43*$D$14)+(I44*$D$15)+(I45*$D$16)+(I46*$D$17)+(I47*$D$18)-(I48*$D$14)-(I48*$D$15)-(I49*$D$18)),0)","v":0},null,"TOTAL Monthly HOURS ",{"$f":"ROUND(((L43*$D$14)+(L44*$D$15)+(L45*$D$16)+(L46*$D$17)+(L47*$D$18)-(L48*$D$14)-(L48*$D$15)-(L49*$D$18)),0)","v":0}]
[]
["Parents' Vacation cannot be less then 10 days PER YEAR",null,null,null,null,{"$f":"IF((B28+F28+I28+L28+B38+F38+I38+L38+B48+F48+I48+L48)<10, \"EXPLAIN\", (B28+F28+I28+L28+B38+F38+I38+L38+B48+F48+I48+L48))","v":"EXPLAIN"},null,null,null,null,"Max hours for POS =",{"$f":"ROUNDDOWN((+B30+F30+I40+L40+B40+F40+I40+L40+B50+F50+I50+L50),0)","v":0}]
["FEDERAL HOLIDAYS cannot be less then 10 days PER YEAR",null,null,null,null,{"$f":"IF((B29+F29+I29+L29+B39+F39+I39+L39+B49+F49+I49+L49)<10, \"EXPLAIN\", (B29+F29+I29+L29+B39+F39+I39+L39+B49+F49+I49+L49))","v":"EXPLAIN"}]
["If \"EXPLAIN\" appears in boxes, please indicate below why vacation/holidays is less than 10 days/year.  Prorated # of vacation/holiday days if POS is  "]
["for less than 12 months .  10 days/12 months= .83 day per month"]
[]
[]
[]
[]
[]
[]
[" "]
["CASE MANAGER Signature",null,null,"CM SUPERVISOR Signature",null,null,null,"Date"]