{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TimeCard","Data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":3,"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":"TimeCard","index":0,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[27,7,33,17],[4,14,5,17],[8,7,8,8],[8,13,22,13],[9,7,9,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[9,15,10,15],[9,16,10,16],[9,17,10,17],[10,7,10,8],[13,14,14,14],[11,7,11,8],[11,15,12,15],[11,16,12,16],[11,17,12,17],[12,7,12,8],[13,7,13,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[11,9,12,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,14,12,14],[13,15,14,15],[13,16,14,16],[13,17,14,17],[14,7,14,8],[15,7,15,8],[15,9,16,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,14,16,14],[15,15,16,15],[15,16,16,16],[15,17,16,17],[16,7,16,8],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[17,17,18,17],[18,7,18,8],[19,7,19,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,20,12],[20,7,20,8],[19,14,20,14],[17,14,18,14],[17,7,17,8],[17,9,18,9],[17,10,18,10],[17,11,18,11],[17,12,18,12],[21,17,22,17],[22,7,22,8],[31,2,32,3],[2,14,3,17],[19,15,20,15],[19,16,20,16],[19,17,20,17],[26,7,26,8],[15,2,16,3],[23,10,23,12],[24,10,24,12],[21,15,22,15],[21,16,22,16],[21,14,22,14],[17,15,18,15],[17,16,18,16]]}
[]
[]
[null,null,null,null,null,null,null,null,"Timecard",null,null,null,null,null,"2021-09-03"]
[null,null,null,null,null,null,null,null,"FAX TIMECARD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Must be completed to process timecard    Please Select Week Ended Friday"]
[]
[]
[]
[null,null,null,null,null,null,null,"Day",null,"Start Time","Lunch Out","Lunch In","Finish Time",null,"Regular","Over Time","2X Time","Total Time"]
[null,null,"Last Name",null,null,null,null,"Saturday",null,null,null,null,null,null,{"$f":"ROUND(IF(((O27+ROUND(R10,6))>=Data!E41),Data!E41-O27,IF((ROUND(R10,6)>=Data!E9),IF(((Data!E41-O27)>ROUND(R10,6)),Data!E9,IF(((Data!E41-O27)>=Data!E9),Data!E9,Data!E41-O27)),ROUND(R10,6))),6)","v":"00:00:00"},{"$f":"ROUND(IF(((ROUND(R10,6)+O27)>=ROUND(Data!E41,6)),IF(((ROUND(R10,6)+O27)>=ROUND(Data!E49,6)),ROUND(Data!E9,6),(ROUND(R10,6)-ROUND(O10,6))), IF(((ROUND(R10,6)-ROUND(O10,6))>=ROUND(Data!E9,6)),ROUND(Data!E9,6),ROUND(R10,6)-ROUND(O10,6))),6)","v":"00:00:00"},{"$f":"ROUND(IF(((ROUND(R10,6)+O27)>=ROUND(Data!E49,6)),(ROUND(R10,6)-ROUND(O10,6)-ROUND(P10,6)),(ROUND(R10,6)-ROUND(O10,6)-ROUND(P10,6))),6)","v":"00:00:00"},{"$f":"(ROUND(K10,6)-ROUND(J10,6))+(ROUND(M10,6)-ROUND(L10,6))","v":"00:00:00"}]
[null,null,null,null,null,null,null,{"$f":"H23-6","v":"2021-08-28"}]
[null,null,"First Name",null,null,null,null,"Sunday",null,null,null,null,null,null,{"$f":"ROUND(IF(((O26+ROUND(R12,6))>=Data!E41),Data!E41-O26,IF((ROUND(R12,6)>=Data!E9),IF(((Data!E41-O26)>ROUND(R12,6)),Data!E9,IF(((Data!E41-O26)>=Data!E9),Data!E9,Data!E41-O26)),ROUND(R12,6))),6)","v":"00:00:00"},{"$f":"ROUND(IF(((ROUND(R12,6)+O26)>=Data!E41),IF(((ROUND(R12,6)+O26)>=Data!E49),Data!E9,(ROUND(R12,6)-ROUND(O12,6))), IF(((ROUND(R12,6)-ROUND(O12,6))>=Data!E9),Data!E9,ROUND(R12,6)-ROUND(O12,6))),6)","v":"00:00:00"},{"$f":"ROUND(IF(((ROUND(R12,6)+O26)>=Data!E49),(ROUND(R12,6)-ROUND(O12,6)-ROUND(P12,6)),(ROUND(R12,6)-ROUND(O12,6)-ROUND(P12,6))),6)","v":"00:00:00"},{"$f":"(ROUND(K12,6)-ROUND(J12,6))+(ROUND(M12,6)-ROUND(L12,6))","v":"00:00:00"}]
[null,null,null,null,null,null,null,{"$f":"H23-5","v":"2021-08-29"}]
[null,null,"Assignment No.",null,null,null,null,"Monday",null,null,null,null,null,null,{"$f":"IF((R14>=Data!$E$9),Data!$E$9, R14)","v":"00:00:00"},{"$f":"IF(((R14-O14)>=Data!$E$5), Data!$E$5, (R14-O14))","v":"00:00:00"},{"$f":"IF((R14>=Data!$E$13), (R14-Data!$E$13), 0)","v":"00:00:00"},{"$f":"(K14-J14)+(M14-L14)","v":"00:00:00"}]
[null,null,null,null,null,null,null,{"$f":"H23-4","v":"2021-08-30"}]
[null,null,"X       ",null,null,null,null,"Tuesday",null,null,null,null,null,null,{"$f":"IF((R16>=Data!$E$9),Data!$E$9, R16)","v":"00:00:00"},{"$f":"IF(((R16-O16)>=Data!$E$5), Data!$E$5, (R16-O16))","v":"00:00:00"},{"$f":"IF((R16>=Data!$E$13), (R16-Data!$E$13), 0)","v":"00:00:00"},{"$f":"(K16-J16)+(M16-L16)","v":"00:00:00"}]
[null,null,null,null,null,null,null,{"$f":"H23-3","v":"2021-08-31"}]
[null,null,null,null,null,null,null,"Wednesday",null,null,null,null,null,null,{"$f":"IF((R18>=Data!$E$9),Data!$E$9, R18)","v":"00:00:00"},{"$f":"IF(((R18-O18)>=Data!$E$5), Data!$E$5, (R18-O18))","v":"00:00:00"},{"$f":"IF((R18>=Data!$E$13), (R18-Data!$E$13), 0)","v":"00:00:00"},{"$f":"(K18-J18)+(M18-L18)","v":"00:00:00"}]
[null,null,null,null,null,null,null,{"$f":"H23-2","v":"2021-09-01"}]
[null,null,null,null,null,null,null,"Thusday",null,null,null,null,null,null,{"$f":"IF((R20>=Data!$E$9),Data!$E$9, R20)","v":"00:00:00"},{"$f":"IF(((R20-O20)>=Data!$E$5), Data!$E$5, (R20-O20))","v":"00:00:00"},{"$f":"IF((R20>=Data!$E$13), (R20-Data!$E$13), 0)","v":"00:00:00"},{"$f":"(K20-J20)+(M20-L20)","v":"00:00:00"}]
[null,null,null,null,null,null,null,{"$f":"H23-1","v":"2021-09-02"}]
[null,null,null,null,null,null,null,"Friday",null,null,null,null,null,null,{"$f":"IF((R22>=Data!$E$9),Data!$E$9, R22)","v":"00:00:00"},{"$f":"IF(((R22-O22)>=Data!$E$5), Data!$E$5, (R22-O22))","v":"00:00:00"},{"$f":"IF((R22>=Data!$E$13), (R22-Data!$E$13), 0)","v":"00:00:00"},{"$f":"(K22-J22)+(M22-L22)","v":"00:00:00"}]
[null,null,null,null,null,null,null,{"$f":"O3","v":"2021-09-03"}]
[null,null,"Company Name",null,null,null,null,null,null,null,"Grand Total (Actual Hours)",null,null,null,{"$f":"O10+O12+O14+O16+O18+O20+O22","v":0},{"$f":"P10+P12+P14+P16+P18+P20+P22","v":0},{"$f":"Q10+Q12+Q14+Q16+Q18+Q20+Q22","v":0},{"$f":"R10+R12+R14+R16+R18+R20+R22","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Grand Total (Fractional Hours)",null,null,null,{"$f":"O24*24","v":0},{"$f":"P24*24","v":0},{"$f":"Q24*24","v":0},{"$f":"R24*24","v":0}]
[null,null,"Address",null,null,null,null,null,null,null,null,null,"M-S Total",null,{"$f":"O10+O14+O16+O18+O20+O22","v":0},{"$f":"P10+P14+P16+P18+P20+P22","v":0},{"$f":"Q10+Q14+Q16+Q18+Q20+Q22","v":0},{"$f":"R10+R14+R16+R18+R20+R22","v":0}]
[null,null,null,null,null,null,null,"NOTE:",null,null,null,null,"M-F Total",null,{"$f":"O14+O16+O18+O20+O22","v":0},{"$f":"P14+P16+P18+P20+P22","v":0},{"$f":"Q14+Q16+Q18+Q20+Q22","v":0},{"$f":"R14+R16+R18+R20+R22","v":0}]
[null,null,"City / State"]
[]
[null,null,"Supervisor Name"]
[]
[null,null,"X              "]
[]
[]
[null,null,"Approved By"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KULA CONSULTING INC."]
[null,null,"Date",null,null,null,null,null,null,null,null,null,"1735 North 1st Street, Suite #109"]
[null,null,null,null,null,null,null,null,null,null,null,null,"San Jose, CA 95112"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Main: 408-329-4300"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Please fill in the BLUE & GREEN areas only."]

{"sheet":"Data","index":1,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
[null,null,null,0,0]
["06:00:00",0.25,null,4.1666666666666664E-2,4.1666666666666699E-2]
["06:15:00",0.26041666666666669,null,8.3333333333333329E-2,8.3333333333333329E-2]
["06:30:00",0.27083333333333331,null,0.125,0.125]
["06:45:00",0.28125,null,0.16666666666666666,0.16666666666666666]
["07:00:00",0.29166666666666669,null,0.20833333333333401,0.20833333333333401]
["07:15:00",0.30208333333333298,null,0.25,0.25]
["07:30:00",0.3125,null,0.29166666666666702,0.29166666666666702]
["07:45:00",0.32291666666666702,null,0.33333333333333398,0.33333333333333398]
["08:00:00",0.33333333333333298,null,0.375,0.375]
["08:15:00",0.34375,null,0.41666666666666702,0.41666666666666702]
["08:30:00",0.35416666666666702,null,0.45833333333333398,0.45833333333333398]
["08:45:00",0.36458333333333398,null,0.5,0.5]
["09:00:00",0.375,null,0.54166666666666696,0.54166666666666696]
["09:15:00",0.38541666666666702,null,0.58333333333333404,0.58333333333333404]
["09:30:00",0.39583333333333398,null,0.625,0.625]
["09:45:00",0.40625,null,0.66666666666666696,0.66666666666666696]
["10:00:00",0.41666666666666702,null,0.70833333333333404,0.70833333333333404]
["10:15:00",0.42708333333333398,null,0.75,0.75]
["10:30:00",0.4375,null,0.79166666666666696,0.79166666666666696]
["10:45:00",0.44791666666666702,null,0.83333333333333404,0.83333333333333404]
["11:00:00",0.45833333333333398,null,0.875,0.875]
["11:15:00",0.46875,null,0.91666666666666696,0.91666666666666696]
["11:30:00",0.47916666666666702,null,0.95833333333333404,0.95833333333333404]
["11:45:00",0.48958333333333398,null,1,1]
["12:00:00",0.5,null,1.0416666666666701,1.0416666666666701]
["12:15:00",0.51041666666666696,null,1.0833333333333399,1.0833333333333399]
["12:30:00",0.52083333333333404,null,1.125,1.125]
["12:45:00",0.53125,null,1.1666666666666701,1.1666666666666701]
["13:00:00",0.54166666666666696,null,1.2083333333333399,1.2083333333333399]
["13:15:00",0.55208333333333404,null,1.25,1.25]
["13:30:00",0.562500000000001,null,1.2916666666666701,1.2916666666666701]
["13:45:00",0.57291666666666696,null,1.3333333333333399,1.3333333333333399]
["14:00:00",0.58333333333333404,null,1.375,1.375]
["14:15:00",0.593750000000001,null,1.4166666666666701,1.4166666666666701]
["14:30:00",0.60416666666666696,null,1.4583333333333399,1.4583333333333399]
["14:45:00",0.61458333333333404,null,1.5,1.5]
["15:00:00",0.625000000000001,null,1.5416666666666701,1.5416666666666701]
["15:15:00",0.63541666666666696,null,1.5833333333333399,1.5833333333333399]
["15:30:00",0.64583333333333404,null,1.625,1.625]
["15:45:00",0.656250000000001,null,1.6666666666666701,1.6666666666666701]
["16:00:00",0.66666666666666696,null,1.7083333333333599,1.7083333333333499]
["16:15:00",0.67708333333333404,null,1.75000000000003,1.75000000000002]
["16:30:00",0.687500000000001,null,1.7916666666667,1.7916666666666901]
["16:45:00",0.69791666666666696,null,1.8333333333333699,1.8333333333333599]
["17:00:00",0.70833333333333404,null,1.87500000000004,1.87500000000003]
["17:15:00",0.718750000000001,null,1.91666666666671,1.9166666666667]
["17:30:00",0.72916666666666796,null,1.9583333333333801,1.9583333333333699]
["17:45:00",0.73958333333333404,null,2.0000000000000502,2.00000000000004]
["18:00:00",0.750000000000001]
["18:15:00",0.76041666666666796]
["18:30:00",0.77083333333333404]
["18:45:00",0.781250000000001]
["19:00:00",0.79166666666666796]
["19:15:00",0.80208333333333404]
["19:30:00",0.812500000000001]
["19:45:00",0.82291666666666796]
["20:00:00",0.83333333333333404]
["20:15:00",0.843750000000001]
["20:30:00",0.85416666666666796]
["20:45:00",0.86458333333333404]
["21:00:00",0.875000000000001]
["21:15:00",0.88541666666666796]
["21:30:00",0.89583333333333404]
["21:45:00",0.906250000000001]
["22:00:00",0.91666666666666796]
["22:15:00",0.92708333333333504]
["22:30:00",0.937500000000001]
["22:45:00",0.94791666666666796]
["23:00:00",0.95833333333333504]
["23:15:00",0.968750000000001]
["23:30:00",0.97916666666666796]
["23:45:00",0.98958333333333504]
[1,1]