{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hourly Time Card","Compatibility Report","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Hourly Time Card","index":0,"n_rows":37,"n_cols":56,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,4,8,5],[8,6,8,7],[14,0,14,14],[15,0,15,1],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,12,15,13],[15,8,15,9],[15,10,15,11],[0,2,0,5],[1,2,1,4],[1,5,1,9],[1,10,1,11],[8,8,8,9],[3,9,3,14],[4,3,4,6],[4,10,4,11],[3,3,3,8],[8,10,8,11],[5,0,5,3],[5,4,5,8],[7,0,7,14],[8,12,8,13],[8,0,8,1],[8,2,8,3],[20,13,20,14],[20,4,20,5],[32,10,32,11],[28,0,28,15],[29,0,29,15],[26,10,26,11],[20,1,20,2],[26,12,26,14],[20,6,20,7],[20,8,20,10],[32,0,32,3],[32,4,32,9],[26,0,26,2],[23,6,23,7],[23,8,23,9],[24,8,24,9],[24,6,24,7],[36,0,36,15],[33,10,33,11],[33,12,33,14],[35,0,35,15],[34,0,34,15]]}
[null,null,"College of Business ",null,null,null,null,null,null,null,null,"Student/Hourly Timesheet",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,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT DELETE"]
[null,null,"  PAY PERIOD:  FROM:",null,null,{"$f":"DATE(IF(BC4=12,N2-1,N2),BC4,16)","v":"2012-12-16"},null,null,null,null,"Jan",null,"15,",2013,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,null,null,null,null,null,null,null,null,null,"Current ",null,"Emp",2]
[null,null,null,null,null,null,"   Month                         Year",null,null,null,null,"Month     ",null,"Year",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,null,null,null,null,null,null,null,null,null,{"$f":"DATE(N2,BA4,1)","v":41275},null,"Previous"]
[null,null,"  Name:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(LEFT(LOWER(K2),3),BA5:BB16,2)","v":1},null,{"$f":"IF(BA4=1, 12,BA4-1)","v":12},{"$f":"RIGHT(LOWER(TEXT($F$2,\"mmm-dd-yyyy\")), 4)","v":"2012"}]
[null,null,null,"                   LAST NAME\n     (PLEASE COMPLETE ONLINE)   ",null,null,null,null,null,null,"FIRST NAME",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,null,null,null,null,null,null,null,null,null,null,null,null,"jan",1,"JANUARY"]
[" University ID Number:  ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"feb",2,"FEBRUARY"]
["  Insert number of hours worked per day",null,null,null,"   Complete Online",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mar",3,"MARCH"]
[{"$f":"VLOOKUP(LEFT(LOWER(TEXT(F2,\"mmm-dd-yyyy\")),3),BA5:BC16,3)","v":"DECEMBER"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"apr",4,"APRIL"]
["Sunday",null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Wkly Total",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,null,null,null,null,null,null,null,null,"may",5,"MAY"]
[null,{"$f":"IF(WEEKDAY($F$2)=1,16,\"\")","v":16},null,{"$f":"IF(WEEKDAY($F$2)=2,16,IF(B10>0,B10+1,\"\"))","v":17},null,{"$f":"IF(WEEKDAY($F$2)=3,16,IF(D10>0,D10+1,\"\"))","v":18},null,{"$f":"IF(WEEKDAY($F$2)=4,16,IF(F10>0,F10+1,\"\"))","v":19},null,{"$f":"IF(WEEKDAY($F$2)=5,16,IF(H10>0,H10+1,\"\"))","v":20},null,{"$f":"IF(WEEKDAY($F$2)=6,16,IF(J10>0,J10+1,\"\"))","v":21},null,{"$f":"IF(WEEKDAY($F$2)=7,16,IF(L10>0,L10+1,\"\"))","v":22},{"$f":"SUM(A10,C10,E10,G10,I10,K10,M10)","v":0},{"$f":"IF(O10>40,O10-40,0)","v":0},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,null,null,null,null,null,null,null,"jun",6,"JUNE"]
[null,{"$f":"N10+1","v":23},null,{"$f":"B11+1","v":24},null,{"$f":"D11+1","v":25},null,{"$f":"F11+1","v":26},null,{"$f":"H11+1","v":27},null,{"$f":"J11+1","v":28},null,{"$f":"L11+1","v":29},{"$f":"SUM(A11,C11,E11,G11,I11,K11,M11)","v":0},{"$f":"IF(O11>40,O11-40,0)","v":0},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,null,null,null,null,null,null,null,"jul",7,"JULY"]
[null,{"$f":"N11+1","v":30},null,{"$f":"B12+1","v":31},null,{"$f":"D12+1","v":32},null,{"$f":"F12+1","v":33},null,{"$f":"H12+1","v":34},null,{"$f":"J12+1","v":35},null,{"$f":"L12+1","v":36},{"$f":"IF(ISERROR(DATE($N$2,$BC$4,N12)),\" See Below\",SUM(A12,C12,E12,G12,I12,K12,M12))","v":" See Below"},{"$f":"IF(O12>40,O12-40,0)","v":0},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,null,null,null,null,null,null,null,"aug",8,"AUGUST"]
[null,{"$f":"N12+1","v":37},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(DATE($N$2,$BC$4,B13)),\"\",\" See Below\")","v":""},{"$f":"IF(O13>40,O13-40,0)","v":0},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,null,null,null,null,null,null,null,"sep",9,"SEPTEMBER"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oct",10,"OCTOBER"]
[{"$f":"VLOOKUP(LEFT(LOWER(K2),3),BA5:BC16,3)","v":"JANUARY"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nov",11,"NOVEMBER"]
["Sunday",null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Wkly Total",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,null,null,null,null,null,null,null,null,"dec",12,"DECEMBER"]
[null,{"$f":"IF(WEEKDAY($BA$3)=1,1,\"\")","v":""},null,{"$f":"IF(WEEKDAY($BA$3)=2,1,IF(B17>0,B17+1,\"\"))","v":""},null,{"$f":"IF(WEEKDAY($BA$3)=3,1,IF(D17>0,D17+1,\"\"))","v":1},null,{"$f":"IF(WEEKDAY($BA$3)=4,1,IF(F17>0,F17+1,\"\"))","v":2},null,{"$f":"IF(WEEKDAY($BA$3)=5,1,IF(H17>0,H17+1,\"\"))","v":3},null,{"$f":"IF(WEEKDAY($BA$3)=6,1,IF(J17>0,J17+1,\"\"))","v":4},null,{"$f":"IF(WEEKDAY($BA$3)=7,1,IF(L17>0,L17+1,\"\"))","v":5},{"$f":"IF(O12=\" See Below\",SUM(A12,A17,C12,C17,E12,E17,G12,G17,I12,I17,K12,K17,M12,M17),SUM(A13,A17,C17,E17,G17,I17,K17,M17))","v":0},{"$f":"IF(O17>40,O17-40,0)","v":0}]
[null,{"$f":"N17+1","v":6},null,{"$f":"B18+1","v":7},null,{"$f":"D18+1","v":8},null,{"$f":"F18+1","v":9},null,{"$f":"H18+1","v":10},null,{"$f":"J18+1","v":11},null,{"$f":"L18+1","v":12},{"$f":"SUM(A18,C18,E18,G18,I18,K18,M18)","v":0},{"$f":"IF(O18>40,O18-40,0)","v":0}]
[null,{"$f":"N18+1","v":13},null,{"$f":"B19+1","v":14},null,{"$f":"D19+1","v":15},null,{"$f":"F19+1","v":16},null,{"$f":"H19+1","v":17},null,{"$f":"J19+1","v":18},null,{"$f":"L19+1","v":19},{"$f":"SUM(A19,C19,E19,G19,I19,K19,M19)","v":0},{"$f":"IF(O19>40,O19-40,0)","v":0}]
[]
["Reg\nHours: ",{"$f":"SUM(O10,O11,O12,O13,O17,O18,O19)-E21","v":0},null,"OT Hours:",{"$f":"SUM(P10:P19)","v":0},null," Hourly Rate: ",null,null,null,null,null,"Gross Pay:",{"$f":"(I21*B21)+(I21*1.5*E21)","v":0}]
[null,null,null,null,null,null,"Minimum wage rate effective Jan 2013: $8.95/hr"]
[null,null,null,null,null,null,"Index",null,"Activity Code"]
[]
[]
[]
[" Employee Signature:  ",null,null,null,null,null,null,null,null,null,"Date: "]
[null,null,null,"Please select radio button above to indicate work study funding"]
["***Time Slips must be in the timesheet box outside 304 Bexell by the 15th of the month. ***"]
["Payday is the last working day of the month."]
[]
[]
[" Supervisor’s printed name:"]
["Supervisor’s Signature:",null,null,null,null,null,null,null,null,null,"Date: "]
[]
["Student Worker Eligibility: To be eligible for work as a regular-student employee during term breaks, the student must have been eligible"]
["                                                for regular-student employment for the term before and must expect to be eligible for the term after the break."]

{"sheet":"Compatibility Report","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Compatibility Report for Student hourly timesheet.xls"]
[null,"Run on 10/7/2009 9:17"]
[]
[null,"The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format."]
[]
[null,"Minor loss of fidelity",null,null,"# of occurrences"]
[]
[null,"Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.",null,null,1]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}