{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Time Computation","Printout","Printout (Spanish)","Week Day Calculation","WD Printout","WD Printout SP","Proration","Days Worked"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Time Computation","index":0,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,12,5,12],[6,12,7,12],[3,10,3,12],[14,4,14,8],[15,4,15,8],[16,4,16,8],[17,4,17,8],[2,5,2,8],[2,0,2,1],[0,0,1,8]]}
["Time Calculator Sheet"]
[]
["(Enter time as hh:mm)",null,null,null,null,"(Enter time as hh:mm)"]
["Total monthly hours",11.791666666666666,null,null,"Claimed",null,null,null,null,null,"Possible Overtime",null,null,null,1.6666666666666667]
["Weekly hours",{"$f":"IF(B4=0,\"\",B4/4)","v":2.9479166666666665},null,null,"Day 1",null,null,null,null,null,"Week 1",{"$f":"IF(F12>O4,F12-O4,\"\")","v":""},{"$f":"SUM(L5:L6)","v":0}]
[null,null,null,null,"Day 2",null,null,null,null,null,"Week 2",{"$f":"IF(G12>O4,G12-O4,\"\")","v":""}]
["30-Day Computation",{"$f":"B4/30","v":0.39305555555555555},null,null,"Day 3",null,null,null,null,null,"Week 3",{"$f":"IF(H12>O4,H12-O4,\"\")","v":""},{"$f":"SUM(L7:L8)","v":0}]
["Entry for 29 days",{"$f":"INT(B7*1440)/1440","v":0.39305555555555555},null,null,"Day 4",null,null,null,null,null,"Week 4",{"$f":"IF(I12>O4,I12-O4,\"\")","v":""}]
["Entry for 1 day",{"$f":"B4-(B8*29)","v":0.39305555555555571},null,null,"Day 5"]
[null,null,null,null,"Day 6"]
["31-Day Computation",{"$f":"B4/31","v":0.3803763440860215},null,null,"Day 7",null,null,null,null,null,"Grand total"]
["Entry for 30 days",{"$f":"INT(B11*1440)/1440","v":0.37986111111111109},null,null,"Total",{"$f":"SUM(F4:F11)","v":0},0,0,0,null,{"$f":"SUM(F12:I12)","v":0}]
["Entry for 1 day",{"$f":"B4-(B12*30)","v":0.39583333333333393}]
[]
["28- Day Computation",{"$f":"B4/28","v":0.42113095238095238},null,null,{"$f":"IF(F12=0,\"\",IF(F12>B5,\"Week 1 total exceeds allowable claimed hours\",\"\"))","v":""}]
["Entry for 27 days",{"$f":"INT(B15*1440)/1440","v":0.42083333333333334},null,null,{"$f":"IF(G12=0,\"\",IF(G12>B5,\"Week 2 total exceeds allowable claimed hours\",\"\"))","v":""}]
["Entry for 1 day",{"$f":"B4-(B16*27)","v":0.42916666666666536},null,null,{"$f":"IF(H12=0,\"\",IF(H12>B5,\"Week 3 total exceeds allowable claimed hours\",\"\"))","v":""}]
[null,null,null,null,{"$f":"IF(I12=0,\"\",IF(I12>B5,\"Week 4 total exceeds allowable claimed hours\",\"\"))","v":""}]
[]
["Enter daily hours"]
["Hours for the workweek",{"$f":"IF(B20=0,\"\",B20*7)","v":""}]
["Less: Previously claimed hours"]
["Net hours for the workweek",{"$f":"IF(B21=\"\",\"\",B21-B22)","v":""}]
["Actual days worked per week"]
["Work hours per day",{"$f":"IF(AND(B23=\"\",B24=\"\"),\"\",B23/B24)","v":""}]

{"sheet":"Printout","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[18,0,18,5],[4,3,13,5],[13,0,13,1],[5,0,5,1],[9,0,9,1],[17,0,17,5],[0,0,0,5],[30,0,30,5],[29,0,29,5],[28,0,28,5],[27,0,27,5],[26,0,26,5],[25,0,25,5],[24,0,24,5],[23,0,23,5],[22,0,22,5],[21,0,21,5],[20,0,20,5],[19,0,19,5]]}
["Time Calculation"]
[]
["Total monthly hours",{"$f":"'Time Computation'!B4","v":11.791666666666666},null,"Note:"]
["Weekly hours",{"$f":"'Time Computation'!B5","v":2.9479166666666665}]
[null,null,null,"• This computation is based on working 7 days/week\n• A workweek starts on Sunday and ends Saturday"]
["30-Day Computation"]
["Entry for 1st Day",{"$f":"'Time Computation'!B9","v":0.39305555555555571}]
["Entry for Remaining Days",{"$f":"'Time Computation'!B8","v":0.39305555555555555}]
[]
["31-Day Computation"]
["Entry for 1st Day",{"$f":"'Time Computation'!B13","v":0.39583333333333393}]
["Entry for Remaining Days",{"$f":"'Time Computation'!B12","v":0.37986111111111109}]
[]
["28- Day Computation",{"$f":"B3/28","v":0.42113095238095238}]
["Entry for 1st Day",{"$f":"'Time Computation'!B17","v":0.42916666666666536}]
["Entry for Remaining Days",{"$f":"'Time Computation'!B16","v":0.42083333333333334}]
[]
["Instructions:"]

{"sheet":"Printout (Spanish)","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[23,0,23,5],[0,0,0,5],[4,3,13,5],[5,0,5,1],[9,0,9,1],[13,0,13,1],[17,0,17,5],[18,0,18,5],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[30,0,30,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[29,0,29,5]]}
["Time Calculation"]
[]
["Horas total por mes",{"$f":"'Time Computation'!B4","v":11.791666666666666},null,"Note:"]
["Horas por semana",{"$f":"'Time Computation'!B5","v":2.9479166666666665}]
[null,null,null,"• Esta calculación es para cuando trabaja 7 días por semana\n• La semana laboral empieza el Domingo y termina el Sábado"]
["Calculación para 30 días"]
["Entrada para Primer Día",{"$f":"'Time Computation'!B9","v":0.39305555555555571}]
["Entrada para Días Restantes",{"$f":"'Time Computation'!B8","v":0.39305555555555555}]
[]
["Calculación para 31 días"]
["Entrada para Primer Día",{"$f":"'Time Computation'!B13","v":0.39583333333333393}]
["Entrada para Días Restantes",{"$f":"'Time Computation'!B12","v":0.37986111111111109}]
[]
["Calculación para 28 días",{"$f":"B3/28","v":0.42113095238095238}]
["Entrada para Primer Día",{"$f":"'Time Computation'!B17","v":0.42916666666666536}]
["Entrada para Días Restantes",{"$f":"'Time Computation'!B16","v":0.42083333333333334}]
[]
["Instrucciones"]

{"sheet":"Week Day Calculation","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[6,0,6,1],[1,0,1,3]]}
["Weekday Calculation"]
["(Enter time as hh:mm)"]
["Auth. Hours",11.791666666666666]
["Weekly Hours",{"$f":"B3/4","v":2.9479166666666665}]
["Schedule","M-F"]
[]
["Days Worked Each Month",null,"1 Day","Remaining Days"]
["January",{"$f":"VLOOKUP($B$5,Year_2017,2,FALSE)","v":23},{"$f":"$B$3-(D8*(B8-1))","v":0.5166666666666675},{"$f":"INT(E8*1440)/1440","v":0.51249999999999996},{"$f":"B3/B8","v":0.5126811594202898}]
["February",{"$f":"VLOOKUP($B$5,Year_2017,3,FALSE)","v":20},{"$f":"$B$3-(D9*(B9-1))","v":0.58958333333333179},{"$f":"INT(E9*1440)/1440","v":0.58958333333333335},{"$f":"B3/B9","v":0.58958333333333335}]
["March",{"$f":"VLOOKUP($B$5,Year_2017,4,FALSE)","v":22},0.54791666666666572,0.53541666666666665,{"$f":"B3/B10","v":0.53598484848484851}]
["April",{"$f":"VLOOKUP($B$5,Year_2017,5,FALSE)","v":21},0.56944444444444464,0.56111111111111112,{"$f":"B3/B11","v":0.56150793650793651}]
["May",{"$f":"VLOOKUP($B$5,Year_2017,6,FALSE)","v":23},0.5166666666666675,0.51249999999999996,{"$f":"B3/B12","v":0.5126811594202898}]
["June",{"$f":"VLOOKUP($B$5,Year_2017,7,FALSE)","v":21},0.56944444444444464,0.56111111111111112,{"$f":"B3/B13","v":0.56150793650793651}]
["July",{"$f":"VLOOKUP($B$5,Year_2017,8,FALSE)","v":22},0.54791666666666572,0.53541666666666665,{"$f":"B3/B14","v":0.53598484848484851}]
["August",{"$f":"VLOOKUP($B$5,Year_2017,9,FALSE)","v":23},0.5166666666666675,0.51249999999999996,{"$f":"B3/B15","v":0.5126811594202898}]
["September",{"$f":"VLOOKUP($B$5,Year_2017,10,FALSE)","v":20},0.58958333333333179,0.58958333333333335,{"$f":"B3/B16","v":0.58958333333333335}]
["October",{"$f":"VLOOKUP($B$5,Year_2017,11,FALSE)","v":23},0.5166666666666675,0.51249999999999996,{"$f":"B3/B17","v":0.5126811594202898}]
["November",{"$f":"VLOOKUP($B$5,Year_2017,12,FALSE)","v":22},0.54791666666666572,0.53541666666666665,{"$f":"B3/B18","v":0.53598484848484851}]
["December",{"$f":"VLOOKUP($B$5,Year_2017,13,FALSE)","v":21},0.56944444444444464,0.56111111111111112,{"$f":"B3/B19","v":0.56150793650793651}]

{"sheet":"WD Printout","index":4,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[16,0,16,1],[0,0,0,3],[2,0,9,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3]]}
["Entries for IHSS Time Sheet"]
[]
["Please note that the following computation was made based on the information available on the date this was printed.  Should your work schedule or hours change please have your hours recalculated to ensure the entries are correct."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Auth. Hours",{"$f":"'Week Day Calculation'!B3:D3","v":11.791666666666666}]
["Weekly Hours",{"$f":"'Week Day Calculation'!B4:D4","v":2.9479166666666665}]
["Schedule",{"$f":"'Week Day Calculation'!B5:D5","v":"M-F"}]
[]
["Days Worked Each Month",null,"1st Day","Remaining Days"]
["January",{"$f":"'Week Day Calculation'!B8","v":23},{"$f":"'Week Day Calculation'!C8","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D8","v":0.51249999999999996}]
["February",{"$f":"'Week Day Calculation'!B9","v":20},{"$f":"'Week Day Calculation'!C9","v":0.58958333333333179},{"$f":"'Week Day Calculation'!D9","v":0.58958333333333335}]
["March",{"$f":"'Week Day Calculation'!B10","v":22},{"$f":"'Week Day Calculation'!C10","v":0.54791666666666572},{"$f":"'Week Day Calculation'!D10","v":0.53541666666666665}]
["April",{"$f":"'Week Day Calculation'!B11","v":21},{"$f":"'Week Day Calculation'!C11","v":0.56944444444444464},{"$f":"'Week Day Calculation'!D11","v":0.56111111111111112}]
["May",{"$f":"'Week Day Calculation'!B12","v":23},{"$f":"'Week Day Calculation'!C12","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D12","v":0.51249999999999996}]
["June",{"$f":"'Week Day Calculation'!B13","v":21},{"$f":"'Week Day Calculation'!C13","v":0.56944444444444464},{"$f":"'Week Day Calculation'!D13","v":0.56111111111111112}]
["July",{"$f":"'Week Day Calculation'!B14","v":22},{"$f":"'Week Day Calculation'!C14","v":0.54791666666666572},{"$f":"'Week Day Calculation'!D14","v":0.53541666666666665}]
["August",{"$f":"'Week Day Calculation'!B15","v":23},{"$f":"'Week Day Calculation'!C15","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D15","v":0.51249999999999996}]
["September",{"$f":"'Week Day Calculation'!B16","v":20},{"$f":"'Week Day Calculation'!C16","v":0.58958333333333179},{"$f":"'Week Day Calculation'!D16","v":0.58958333333333335}]
["October",{"$f":"'Week Day Calculation'!B17","v":23},{"$f":"'Week Day Calculation'!C17","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D17","v":0.51249999999999996}]
["November",{"$f":"'Week Day Calculation'!B18","v":22},{"$f":"'Week Day Calculation'!C18","v":0.54791666666666572},{"$f":"'Week Day Calculation'!D18","v":0.53541666666666665}]
["December",{"$f":"'Week Day Calculation'!B19","v":21},{"$f":"'Week Day Calculation'!C19","v":0.56944444444444464},{"$f":"'Week Day Calculation'!D19","v":0.56111111111111112}]
[]
[]
["Instructions:"]

{"sheet":"WD Printout SP","index":5,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[16,0,16,1],[0,0,0,3],[2,0,9,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[42,0,42,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3]]}
["Entrada Para IHSS Time Sheet"]
[]
["Tenga en cuenta que el cálculo siguiente se realizó sobre la base de la información disponible en la fecha en que se imprimió. En caso de que su horario de trabajo o las horas cambien, por favor tenga sus horas recalculadas para asegurar que las entradas son correctas"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Auth. Hours",{"$f":"'Week Day Calculation'!B3:D3","v":11.791666666666666}]
["Horas por semana",{"$f":"'Week Day Calculation'!B4:D4","v":2.9479166666666665}]
["Horario",{"$f":"'Week Day Calculation'!B5:D5","v":"M-F"}]
[]
["Días Trabajandos Cada Mes",null,"Primer Dia","Días Resantes"]
["Enero",{"$f":"'Week Day Calculation'!B8","v":23},{"$f":"'Week Day Calculation'!C8","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D8","v":0.51249999999999996}]
["Febrero",{"$f":"'Week Day Calculation'!B9","v":20},{"$f":"'Week Day Calculation'!C9","v":0.58958333333333179},{"$f":"'Week Day Calculation'!D9","v":0.58958333333333335}]
["Marzo",{"$f":"'Week Day Calculation'!B10","v":22},{"$f":"'Week Day Calculation'!C10","v":0.54791666666666572},{"$f":"'Week Day Calculation'!D10","v":0.53541666666666665}]
["Abril",{"$f":"'Week Day Calculation'!B11","v":21},{"$f":"'Week Day Calculation'!C11","v":0.56944444444444464},{"$f":"'Week Day Calculation'!D11","v":0.56111111111111112}]
["Mayo",{"$f":"'Week Day Calculation'!B12","v":23},{"$f":"'Week Day Calculation'!C12","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D12","v":0.51249999999999996}]
["Junio",{"$f":"'Week Day Calculation'!B13","v":21},{"$f":"'Week Day Calculation'!C13","v":0.56944444444444464},{"$f":"'Week Day Calculation'!D13","v":0.56111111111111112}]
["Julio",{"$f":"'Week Day Calculation'!B14","v":22},{"$f":"'Week Day Calculation'!C14","v":0.54791666666666572},{"$f":"'Week Day Calculation'!D14","v":0.53541666666666665}]
["Agosto",{"$f":"'Week Day Calculation'!B15","v":23},{"$f":"'Week Day Calculation'!C15","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D15","v":0.51249999999999996}]
["Septiembre",{"$f":"'Week Day Calculation'!B16","v":20},{"$f":"'Week Day Calculation'!C16","v":0.58958333333333179},{"$f":"'Week Day Calculation'!D16","v":0.58958333333333335}]
["Octubre",{"$f":"'Week Day Calculation'!B17","v":23},{"$f":"'Week Day Calculation'!C17","v":0.5166666666666675},{"$f":"'Week Day Calculation'!D17","v":0.51249999999999996}]
["Noviembre",{"$f":"'Week Day Calculation'!B18","v":22},{"$f":"'Week Day Calculation'!C18","v":0.54791666666666572},{"$f":"'Week Day Calculation'!D18","v":0.53541666666666665}]
["Deciembre",{"$f":"'Week Day Calculation'!B19","v":21},{"$f":"'Week Day Calculation'!C19","v":0.56944444444444464},{"$f":"'Week Day Calculation'!D19","v":0.56111111111111112}]
[]
[]
["Instrucciones:"]

{"sheet":"Proration","index":6,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Total Hours",null,"Enter time as hh:mm"]
["Date out",null,"Date client was out (mm/dd/yy)"]
["Date in",null,"Date client returned (mm/dd/yy)"]
["Days/month",{"$f":"IF(AND(B2<>0,B3<>0), DAY(DATE(YEAR(B2),MONTH(B2)+1,1)-1), \"\")","v":""}]
["No. of days out",{"$f":"B3-B2","v":0}]
["Prorated hours",{"$f":"IF(B5=0,\" \",Total_hours-(Total_hours/Days_per_month)*Days_out)","v":" "}]

{"sheet":"Days Worked","index":7,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,12]]}
["Days Worked Each Month"]
["Month","January","February","March","April","May","June","July","August","September","October","November","December"]
["M-F",23,20,22,21,23,21,22,23,20,23,22,21]
["MWF",14,12,13,13,13,13,13,14,12,14,13,13]
["M-Sat",27,24,27,25,27,26,26,27,25,27,26,26]
["Sun-F",27,24,26,26,27,25,27,27,25,27,26,26]
["Tue,Thu",9,8,9,8,10,8,9,9,8,9,9,8]
["Sat,Sun,Mon",13,12,13,14,12,13,14,12,14,13,12,15]
["Sat&Sun",8,8,9,9,8,9,9,8,10,8,8,10]
["Mo,Th,Fr",13,12,14,13,13,13,13,14,12,13,14,13]
["Tue, Thu, Fri",13,12,14,12,14,13,13,14,12,13,14,12]
["Sat, Mon, Tue",14,12,13,13,13,13,14,12,13,14,12,14]
["Sat, Sun, Wed, Thu",17,15,18,17,18,17,17,18,18,17,17,18]
["Tue, Wed, Thu",14,12,13,12,15,12,13,14,12,14,13,12]
["Tu, We, Th, Sa, Su",22,20,22,21,23,21,22,22,22,22,21,22]
["Fri, Sat, Sun",12,12,14,12,12,14,13,13,14,12,13,14]
["Mo-Thu",19,16,17,17,19,16,18,18,16,19,17,17]
["Mo, Tu, We, Fr",19,16,17,17,18,17,18,18,16,19,17,17]
["M, W, F, Sa",18,16,18,17,17,18,17,18,17,18,17,18]
["Thurs, Sun",8,8,9,9,9,8,9,9,9,8,9,9]
["Thu-Sun",17,16,19,17,17,18,17,18,18,16,18,18]