{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data Entry","TimeSheet","Exceptions","Tech Maintenance"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":5,"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 Entry","index":0,"n_rows":76,"n_cols":57,"rows_kept":76,"cut":false,"hidden":false,"merged":[[2,10,2,11],[0,13,0,17],[1,13,1,17],[2,13,2,17],[27,16,27,17],[5,14,5,15],[4,14,4,15],[27,14,27,15],[26,14,26,15],[26,16,26,17],[5,11,5,12],[27,12,27,13],[4,11,4,12],[26,10,26,11],[27,10,27,11],[26,12,26,13],[26,8,26,9],[27,2,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[26,2,26,3],[26,4,26,5],[2,6,2,7],[5,6,5,7],[5,1,5,4],[6,4,6,5],[48,4,48,5],[26,6,26,7],[4,1,4,4],[48,2,48,3],[4,6,4,7],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,12,28,13],[28,10,28,11],[48,8,48,17],[28,14,28,15],[28,16,28,17],[28,8,28,9],[49,8,49,17],[73,2,73,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[50,8,50,17],[51,8,51,17],[52,8,52,17],[53,8,53,17]]}
[null,null,null,null,null,null,null,null,"University of Central Florida",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrk Grp Types"]
[null,null,null,null,null,null,null,null,"Employee Time Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APN"]
[null,null,null,null,null,"PP Begin:",null,null,null,"PP End:",{"$f":"IF(G3=\"\",\"\",G3+13)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT USE EXCEL'S File>Print OPTION TO PRINT THE TIMESHEET.",null,null,null,null,null,null,null,null,null,null,null,null,null,"OPSCN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTEAD, USE THE MACRO \"Print\" BUTTON LOCATED ON THE RIGHT OF DATA ENTRY SHEET.",null,null,null,null,null,null,null,null,null,null,null,null,null,"OPSH"]
[null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USNEX"]
[null,"Name  ( Last,  First  MI )",null,null,null,null,"ID",null,null,"Empl Rcd#",null,"Work Group",null,null,"Group",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salaried"]
[null,"Primary Department#:"]
[]
[null,null,null,null,null,null,null,null,"Hours Worked"]
[null,null,{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+1,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+2,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+3,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+4,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+5,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+6,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+7,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+8,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+9,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+10,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+11,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+12,\"ddd\")))","v":""},{"$f":"IF($G3=\"\",\"\",UPPER(TEXT($G3+13,\"ddd\")))","v":""}]
[null,null,{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AC$11=$B$66,$AC$11=$B$67,$AC$11=$B$68,$AC$11=$B$69,$AC$11=$B$70,$AC$11=$B$71,$AC$11=$B$72,$AC$11=$B$73,$AC$11=$B$74),$AA$11,AC11),AC11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AD$11=$B$66,$AD$11=$B$67,$AD$11=$B$68,$AD$11=$B$69,$AD$11=$B$70,$AD$11=$B$71,$AD$11=$B$72,$AD$11=$B$73,$AD$11=$B$74),$AA$11,AD11),AD11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AE$11=$B$66,$AE$11=$B$67,$AE$11=$B$68,$AE$11=$B$69,$AE$11=$B$70,$AE$11=$B$71,$AE$11=$B$72,$AE$11=$B$73,$AE$11=$B$74),$AA$11,AE11),AE11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AF$11=$B$66,$AF$11=$B$67,$AF$11=$B$68,$AF$11=$B$69,$AF$11=$B$70,$AF$11=$B$71,$AF$11=$B$72,$AF$11=$B$73,$AF$11=$B$74),$AA$11,AF11),AF11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AG$11=$B$66,$AG$11=$B$67,$AG$11=$B$68,$AG$11=$B$69,$AG$11=$B$70,$AG$11=$B$71,$AG$11=$B$72,$AG$11=$B$73,$AG$11=$B$74),$AA$11,AG11),AG11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AH$11=$B$66,$AH$11=$B$67,$AH$11=$B$68,$AH$11=$B$69,$AH$11=$B$70,$AH$11=$B$71,$AH$11=$B$72,$AH$11=$B$73,$AH$11=$B$74),$AA$11,AH11),AH11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AI$11=$B$66,$AI$11=$B$67,$AI$11=$B$68,$AI$11=$B$69,$AI$11=$B$70,$AI$11=$B$71,$AI$11=$B$72,$AI$11=$B$73,$AI$11=$B$74),$AA$11,AI11),AI11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AJ$11=$B$66,$AJ$11=$B$67,$AJ$11=$B$68,$AJ$11=$B$69,$AJ$11=$B$70,$AJ$11=$B$71,$AJ$11=$B$72,$AJ$11=$B$73,$AJ$11=$B$74),$AA$11,AJ11),AJ11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AK$11=$B$66,$AK$11=$B$67,$AK$11=$B$68,$AK$11=$B$69,$AK$11=$B$70,$AK$11=$B$71,$AK$11=$B$72,$AK$11=$B$73,$AK$11=$B$74),$AA$11,AK11),AK11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AL$11=$B$66,$AL$11=$B$67,$AL$11=$B$68,$AL$11=$B$69,$AL$11=$B$70,$AL$11=$B$71,$AL$11=$B$72,$AL$11=$B$73,$AL$11=$B$74),$AA$11,AL11),AL11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AM$11=$B$66,$AM$11=$B$67,$AM$11=$B$68,$AM$11=$B$69,$AM$11=$B$70,$AM$11=$B$71,$AM$11=$B$72,$AM$11=$B$73,$AM$11=$B$74),$AA$11,AM11),AM11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AN$11=$B$66,$AN$11=$B$67,$AN$11=$B$68,$AN$11=$B$69,$AN$11=$B$70,$AN$11=$B$71,$AN$11=$B$72,$AN$11=$B$73,$AN$11=$B$74),$AA$11,AN11),AN11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AO$11=$B$66,$AO$11=$B$67,$AO$11=$B$68,$AO$11=$B$69,$AO$11=$B$70,$AO$11=$B$71,$AO$11=$B$72,$AO$11=$B$73,$AO$11=$B$74),$AA$11,AO11),AO11))","v":""},{"$f":"IF($G3=\"\",\"\",IF($AA$12,IF(OR($AP$11=$B$66,$AP$11=$B$67,$AP$11=$B$68,$AP$11=$B$69,$AP$11=$B$70,$AP$11=$B$71,$AP$11=$B$72,$AP$11=$B$73,$AP$11=$B$74),$AA$11,AP11),AP11))","v":""},null,null,null,null,null,null,null,null,null,null,"*Hol*",null,{"$f":"G3","v":"00:00:00"},{"$f":"AC11+1","v":"1900-01-01"},{"$f":"AD11+1","v":"1900-01-02"},{"$f":"AE11+1","v":"1900-01-03"},{"$f":"AF11+1","v":"1900-01-04"},"1900-01-05","1900-01-06","1900-01-07","1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-13",null,"Table to validate if employee worked more than 5 hours straight (see ValidTime function in VBA)"]
[null,"In",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"((INT(C13)*60)+((C13-INT(C13))*100)-(INT(C12)*60)-((C12-INT(C12))*100))/60","v":0},{"$f":"((INT(D13)*60)+((D13-INT(D13))*100)-(INT(D12)*60)-((D12-INT(D12))*100))/60","v":0},{"$f":"((INT(E13)*60)+((E13-INT(E13))*100)-(INT(E12)*60)-((E12-INT(E12))*100))/60","v":0},{"$f":"((INT(F13)*60)+((F13-INT(F13))*100)-(INT(F12)*60)-((F12-INT(F12))*100))/60","v":0},{"$f":"((INT(G13)*60)+((G13-INT(G13))*100)-(INT(G12)*60)-((G12-INT(G12))*100))/60","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF(C12=0,0,IF(C13>C12,AC12,AC13))","v":0},{"$f":"IF(D12=0,0,IF(D13>D12,AD12,AD13))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Out",null,null,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":"(((INT(C13)+12)*60)+((C13-INT(C13))*100)-(INT(C12)*60)-((C12-INT(C12))*100))/60","v":12},{"$f":"(((INT(D13)+12)*60)+((D13-INT(D13))*100)-(INT(D12)*60)-((D12-INT(D12))*100))/60","v":12},{"$f":"(((INT(E13)+12)*60)+((E13-INT(E13))*100)-(INT(E12)*60)-((E12-INT(E12))*100))/60","v":12},{"$f":"(((INT(F13)+12)*60)+((F13-INT(F13))*100)-(INT(F12)*60)-((F12-INT(F12))*100))/60","v":12},{"$f":"(((INT(G13)+12)*60)+((G13-INT(G13))*100)-(INT(G12)*60)-((G12-INT(G12))*100))/60","v":12},12,12,12,12,12,12,12,12,12,null,{"$f":"IF(C13=0,0,IF(C12>C13,AC13,AC12))","v":0},{"$f":"IF(D13=0,0,IF(D12>D13,AD13,AD12))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"In",null,null,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":"((INT(C15)*60)+((C15-INT(C15))*100)-(INT(C14)*60)-((C14-INT(C14))*100))/60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(C14=0,0,IF(C15>C14,AC14,AC15))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Out",null,null,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":"(((INT(C15)+12)*60)+((C15-INT(C15))*100)-(INT(C14)*60)-((C14-INT(C14))*100))/60","v":12},12,12,12,12,12,12,12,12,12,12,12,12,12,null,{"$f":"IF(C15=0,0,IF(C14>C15,AC15,AC14))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"In",null,null,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":"((INT(C17)*60)+((C17-INT(C17))*100)-(INT(C16)*60)-((C16-INT(C16))*100))/60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(C16=0,0,IF(C17>C16,AC16,AC17))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Out",null,null,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":"(((INT(C17)+12)*60)+((C17-INT(C17))*100)-(INT(C16)*60)-((C16-INT(C16))*100))/60","v":12},12,12,12,12,12,12,12,12,12,12,12,12,12,null,{"$f":"IF(C17=0,0,IF(C16>C17,AC17,AC16))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"In",null,null,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":"((INT(C19)*60)+((C19-INT(C19))*100)-(INT(C18)*60)-((C18-INT(C18))*100))/60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(C18=0,0,IF(C19>C18,AC18,AC19))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Out",null,null,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":"(((INT(C19)+12)*60)+((C19-INT(C19))*100)-(INT(C18)*60)-((C18-INT(C18))*100))/60","v":12},12,12,12,12,12,12,12,12,12,12,12,12,12,null,{"$f":"IF(C19=0,0,IF(C18>C19,AC19,AC18))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Hrs",{"$f":"IF(AC21=0,\"\",AC21)","v":""},{"$f":"IF(AD21=0,\"\",AD21)","v":""},"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,"Tot Hrs Wrkd",{"$f":"IF(C12=\"\",0,IF(C12=C13,0,IF(C13>C12,AC12,AC13))+IF(C14=C15,0,IF(C15>C14,AC14,AC15))+IF(C16=C17,0,IF(C17>C16,AC16,AC17))+IF(C18=C19,0,IF(C19>C18,AC18,AC19)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"I21+P21","v":0},null,null,null,null,null,"Total Hours Worked Week 1:   ",{"$f":"SUM(C20:I20)","v":0},null,null,null,null,null,"Total Hours Worked Week 2:   ",{"$f":"SUM(J20:P20)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Round-off",{"$f":"IF(AC20-INT(AC20)<0.125,INT(AC20),(IF(AC20-INT(AC20)<0.375,INT(AC20)+0.25,(IF(AC20-INT(AC20)<0.625,INT(AC20)+0.5,(IF(AC20-INT(AC20)<0.875,INT(AC20)+0.75,INT(AC20)+1)))))))","v":0},{"$f":"IF(AD20-INT(AD20)<0.125,INT(AD20),(IF(AD20-INT(AD20)<0.375,INT(AD20)+0.25,(IF(AD20-INT(AD20)<0.625,INT(AD20)+0.5,(IF(AD20-INT(AD20)<0.875,INT(AD20)+0.75,INT(AD20)+1)))))))","v":0},{"$f":"IF(AE20-INT(AE20)<0.125,INT(AE20),(IF(AE20-INT(AE20)<0.375,INT(AE20)+0.25,(IF(AE20-INT(AE20)<0.625,INT(AE20)+0.5,(IF(AE20-INT(AE20)<0.875,INT(AE20)+0.75,INT(AE20)+1)))))))","v":0},{"$f":"IF(AF20-INT(AF20)<0.125,INT(AF20),(IF(AF20-INT(AF20)<0.375,INT(AF20)+0.25,(IF(AF20-INT(AF20)<0.625,INT(AF20)+0.5,(IF(AF20-INT(AF20)<0.875,INT(AF20)+0.75,INT(AF20)+1)))))))","v":0},{"$f":"IF(AG20-INT(AG20)<0.125,INT(AG20),(IF(AG20-INT(AG20)<0.375,INT(AG20)+0.25,(IF(AG20-INT(AG20)<0.625,INT(AG20)+0.5,(IF(AG20-INT(AG20)<0.875,INT(AG20)+0.75,INT(AG20)+1)))))))","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Leave and Pay Exceptions Report Attached?"]
[]
[null,null,null,null,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(C12>0,1,0)","v":0},{"$f":"IF(D12>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sched Hours",null,"*Actual Hrs",null,"OVT",null,"EXC",null,null,null,"Holiday Hrs.",null,"Wrk+PdOff",null,"UndefXhrs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13>0,-1,0)","v":0},{"$f":"IF(D13>0,-1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Wk 1 Total",40,null,{"$f":"ROUND(I21+M28+AF42+AF43,2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(J35:J39)+I21+M28","v":0},null,{"$f":"IF(O28>C28,(O28-C28)-(G28+I28+K28),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Wk 2 Total",40,null,{"$f":"ROUND(P21+M29+AG42+AG43,2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(R35:R39)+P21+M29","v":0},null,{"$f":"IF(O29>C29,(O29-C29)-(G29+I29+K29),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15>0,-1,0)","v":0},{"$f":"IF(D15>0,-1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"*Represents hours worked + holidays + personal holiday + administrative leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSHelper  Rev. 12/19/2013",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2/01 Fin&Acctg. & HR ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C17>0,-1,0)","v":0},{"$f":"IF(D17>0,-1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"    Show Leave Used for Week 1 Below",null,null,null,null,null,null,null,"    Show Leave Used for Week 2 Below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Leave",{"$f":"C10","v":""},"","","","","","","Wk 1",{"$f":"J10","v":""},"","","","","","","Wk 2",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19>0,-1,0)","v":0},{"$f":"IF(D19>0,-1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Type",{"$f":"C11","v":""},{"$f":"D11","v":""},"","","","","","Total",{"$f":"J11","v":""},{"$f":"K11","v":""},"","","","","","Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC26:AC33)","v":0},{"$f":"SUM(AD26:AD33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C35:I35)=0,\"\",SUM(C35:I35))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(K35:Q35)=0,\"\",SUM(K35:Q35))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C36:I36)=0,\"\",SUM(C36:I36))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(K36:Q36)=0,\"\",SUM(K36:Q36))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"LvTyp","Wk1","Wk2","Total"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C37:I37)=0,\"\",SUM(C37:I37))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(K37:Q37)=0,\"\",SUM(K37:Q37))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C38:I38)=0,\"\",SUM(C38:I38))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(K38:Q38)=0,\"\",SUM(K38:Q38))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"SUMIF($B$35:$B$39,AE38,$J$35:$J$39)","v":0},{"$f":"SUMIF($B$35:$B$39,AE38,$R$35:$R$39)","v":0},{"$f":"SUM(AF38:AG38)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C39:I39)=0,\"\",SUM(C39:I39))","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(K39:Q39)=0,\"\",SUM(K39:Q39))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"S",0,0,0]
[null,"         Please indicate the type of leave being used in the column marked 'Leave Type' and indicate the number of hours in the column(s) with the appropriate date.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPS",0,0,0]
[null,null,"(A)","Annual Leave",null,null,"(DIS)","Disability",null,null,"(LWO)","Leave Without Pay",null,null,"(MIL)","Military",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LWO",0,0,0]
[null,null,"(OCT)","OverTime Comp",null,null,"(PH)","Personal Hol",null,null,"(S)","Sick",null,null,"(S73)","Sick Pre73",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH",0,0,0]
[null,null,"(SCT)","Special Comp",null,null,"(WC)","Work Comp",null,null,"(WCL)","WkCmp Lv/no Pay",null,null,"(AdmLv)","Admin Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AdmLv",0,0,0]
[null,null,"(SPS)","Sick Leave Pool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIL",0,0,0]
[null,"  Leave usage must be requested and approved in advance, except in emergency situations.  Provide justification below for all leave usage.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S73",0,0,0]
[null,"  A Medical or Parental Leave Request Form and Medical Certification Form are required when absent more than 10 business days for",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIS",0,0,0]
[null,"  medical or parental leave, or for a work-related illness or injury.",null,null,null,null,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",0,0,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,"SCT",0,0,0]
[null,null,"From",null,"To",null,"Leave","#","Reason",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WC",0,0,0]
[null,null,"Date","Time","Date","Time","Type","Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WCL",0,0,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,{"$f":"((INT(AD59)*60)+((AD59-INT(AD59))*100)-(INT(AC59)*60)-((AC59-INT(AC59))*100))/60","v":0},{"$f":"(((INT(AD59)+12)*60)+((AD59-INT(AD59))*100)-(INT(AC59)*60)-((AC59-INT(AC59))*100))/60","v":12}]
[null,null,null,null,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":"((INT(AD60)*60)+((AD60-INT(AD60))*100)-(INT(AC60)*60)-((AC60-INT(AC60))*100))/60","v":0},{"$f":"(((INT(AD60)+12)*60)+((AD60-INT(AD60))*100)-(INT(AC60)*60)-((AC60-INT(AC60))*100))/60","v":12}]
[null,null,null,null,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":"((INT(AD61)*60)+((AD61-INT(AD61))*100)-(INT(AC61)*60)-((AC61-INT(AC61))*100))/60","v":0},{"$f":"(((INT(AD61)+12)*60)+((AD61-INT(AD61))*100)-(INT(AC61)*60)-((AC61-INT(AC61))*100))/60","v":12}]
[null,null,null,null,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":"((INT(AD62)*60)+((AD62-INT(AD62))*100)-(INT(AC62)*60)-((AC62-INT(AC62))*100))/60","v":0},{"$f":"(((INT(AD62)+12)*60)+((AD62-INT(AD62))*100)-(INT(AC62)*60)-((AC62-INT(AC62))*100))/60","v":12}]
[]
[]
[null,null,null,null,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(D51-INT(D51)<0.08,INT(D51),(IF(D51-INT(D51)<0.23,INT(D51)+0.15,(IF(D51-INT(D51)<0.38,INT(D51)+0.3,(IF(D51-INT(D51)<0.53,INT(D51)+0.45,INT(D51)+0.6)))))))","v":0},{"$f":"IF(F51-INT(F51)<0.08,INT(F51),(IF(F51-INT(F51)<0.23,INT(F51)+0.15,(IF(F51-INT(F51)<0.38,INT(F51)+0.3,(IF(F51-INT(F51)<0.53,INT(F51)+0.45,INT(F51)+0.6)))))))","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,{"$f":"IF(D52-INT(D52)<0.08,INT(D52),(IF(D52-INT(D52)<0.23,INT(D52)+0.15,(IF(D52-INT(D52)<0.38,INT(D52)+0.3,(IF(D52-INT(D52)<0.53,INT(D52)+0.45,INT(D52)+0.6)))))))","v":0},{"$f":"IF(F52-INT(F52)<0.08,INT(F52),(IF(F52-INT(F52)<0.23,INT(F52)+0.15,(IF(F52-INT(F52)<0.38,INT(F52)+0.3,(IF(F52-INT(F52)<0.53,INT(F52)+0.45,INT(F52)+0.6)))))))","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,{"$f":"IF(D53-INT(D53)<0.08,INT(D53),(IF(D53-INT(D53)<0.23,INT(D53)+0.15,(IF(D53-INT(D53)<0.38,INT(D53)+0.3,(IF(D53-INT(D53)<0.53,INT(D53)+0.45,INT(D53)+0.6)))))))","v":0},{"$f":"IF(F53-INT(F53)<0.08,INT(F53),(IF(F53-INT(F53)<0.23,INT(F53)+0.15,(IF(F53-INT(F53)<0.38,INT(F53)+0.3,(IF(F53-INT(F53)<0.53,INT(F53)+0.45,INT(F53)+0.6)))))))","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,{"$f":"IF(D54-INT(D54)<0.08,INT(D54),(IF(D54-INT(D54)<0.23,INT(D54)+0.15,(IF(D54-INT(D54)<0.38,INT(D54)+0.3,(IF(D54-INT(D54)<0.53,INT(D54)+0.45,INT(D54)+0.6)))))))","v":0},{"$f":"IF(F54-INT(F54)<0.08,INT(F54),(IF(F54-INT(F54)<0.23,INT(F54)+0.15,(IF(F54-INT(F54)<0.38,INT(F54)+0.3,(IF(F54-INT(F54)<0.53,INT(F54)+0.45,INT(F54)+0.6)))))))","v":0}]
[null,"You can mark holidays by checking the \"Mark Holidays\" checkbox. "]
[null,"When enabling this feature, make sure that the dates below are correct."]
[null,"HOLIDAY OBSERVANCE"]
[null,{"$f":"C66","v":"2018-01-01"},"2018-01-01",null,"New Year's Day"]
[null,{"$f":"C67","v":"2018-01-15"},"2018-01-15",null,"Martin Luther King's Birthday"]
[null,"2018-05-28","2018-05-28",null,"Memorial Day"]
[null,"2018-07-04","2018-07-04",null,"Independence Day"]
[null,"2018-09-03","2018-09-03",null,"Labor Day"]
[null,"2018-11-12","2018-11-12",null,"Veteran's Day"]
[null,"2018-11-22","2018-11-22",null,"Thanksgiving Day"]
[null,"2018-11-23","2018-11-23",null,"Day After Thanksgiving"]
[null,"2018-12-25","2018-12-25",null,"Christmas Day"]
[]
[null,null,null,null,null,null,null,null,"Note: Additional days may be announced later in the year."]

{"sheet":"TimeSheet","index":1,"n_rows":51,"n_cols":29,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,15,0,18],[1,15,1,18],[2,15,2,18],[2,13,2,14],[5,1,5,5],[2,9,2,10],[20,8,20,9],[18,8,18,9],[14,5,14,6],[9,1,9,2],[10,1,11,2],[14,1,14,2],[19,8,19,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[13,1,13,2],[11,5,11,6],[10,5,10,6],[12,5,12,6],[13,5,13,6],[21,1,21,2],[19,5,19,6],[20,5,20,6],[20,1,20,2],[19,1,19,2],[10,8,10,9],[11,8,11,9],[12,8,12,9],[12,1,12,2],[18,1,18,2],[17,1,17,2],[16,1,16,2],[15,1,15,2],[16,5,16,6],[17,8,17,9],[17,5,17,6],[18,5,18,6],[15,5,15,6]]}
[null,null,null,null,null,null,null,null,null,null,null,"University of Central Florida",null,null,null,{"$f":"IF('Data Entry'!N1=\"\",\"\",'Data Entry'!N1)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Employee Time Sheet",null,null,null,{"$f":"IF('Data Entry'!N2=\"\",\"\",'Data Entry'!N2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"To print TimeSheet, use the \"Print\" button from the Data Entry sheet."]
[null,null,null,null,null,null,null,null,"PP Begin:",{"$f":"'Data Entry'!G3","v":"00:00:00"},null,null,"PP End:",{"$f":"J3+13","v":"1900-01-13"},null,{"$f":"IF('Data Entry'!N3=\"\",\"\",'Data Entry'!N3)","v":""}]
[]
[]
[null,{"$f":"'Data Entry'!B5","v":0},null,null,null,null,"ID:",{"$f":"'Data Entry'!G5","v":""},null,null,"Empl Rcd#:",{"$f":"'Data Entry'!J5","v":0},null,"Work Group:",{"$f":"'Data Entry'!L5","v":0},null,null,"Group:",{"$f":"'Data Entry'!O5","v":""}]
[]
[null,"Primary Dept:",null,null,{"$f":"'Data Entry'!E7:F7","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Hours Worked"]
[null,null,null,"FRI","SAT","SUN",null,"MON","TUE",null,"WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU"]
[null,null,null,{"$f":"'Data Entry'!C11","v":""},{"$f":"'Data Entry'!D11","v":""},{"$f":"'Data Entry'!E11","v":""},null,{"$f":"'Data Entry'!F11","v":""},{"$f":"'Data Entry'!G11","v":""},null,{"$f":"'Data Entry'!H11","v":""},{"$f":"'Data Entry'!I11","v":""},{"$f":"'Data Entry'!J11","v":""},{"$f":"'Data Entry'!K11","v":""},{"$f":"'Data Entry'!L11","v":""},{"$f":"'Data Entry'!M11","v":""},{"$f":"'Data Entry'!N11","v":""},{"$f":"'Data Entry'!O11","v":""},{"$f":"'Data Entry'!P11","v":""}]
[null,"In",null,{"$f":"IF('Data Entry'!C12=0,\"\",'Data Entry'!C12)","v":""},{"$f":"IF('Data Entry'!D12=0,\"\",'Data Entry'!D12)","v":""},{"$f":"IF('Data Entry'!E12=0,\"\",'Data Entry'!E12)","v":""},null,{"$f":"IF('Data Entry'!F12=0,\"\",'Data Entry'!F12)","v":""},{"$f":"IF('Data Entry'!G12=0,\"\",'Data Entry'!G12)","v":""},null,{"$f":"IF('Data Entry'!H12=0,\"\",'Data Entry'!H12)","v":""},{"$f":"IF('Data Entry'!I12=0,\"\",'Data Entry'!I12)","v":""},{"$f":"IF('Data Entry'!J12=0,\"\",'Data Entry'!J12)","v":""},{"$f":"IF('Data Entry'!K12=0,\"\",'Data Entry'!K12)","v":""},{"$f":"IF('Data Entry'!L12=0,\"\",'Data Entry'!L12)","v":""},{"$f":"IF('Data Entry'!M12=0,\"\",'Data Entry'!M12)","v":""},{"$f":"IF('Data Entry'!N12=0,\"\",'Data Entry'!N12)","v":""},{"$f":"IF('Data Entry'!O12=0,\"\",'Data Entry'!O12)","v":""},{"$f":"IF('Data Entry'!P12=0,\"\",'Data Entry'!P12)","v":""}]
[null,"Out",null,{"$f":"IF('Data Entry'!C13=0,\"\",'Data Entry'!C13)","v":""},{"$f":"IF('Data Entry'!D13=0,\"\",'Data Entry'!D13)","v":""},{"$f":"IF('Data Entry'!E13=0,\"\",'Data Entry'!E13)","v":""},null,{"$f":"IF('Data Entry'!F13=0,\"\",'Data Entry'!F13)","v":""},{"$f":"IF('Data Entry'!G13=0,\"\",'Data Entry'!G13)","v":""},null,{"$f":"IF('Data Entry'!H13=0,\"\",'Data Entry'!H13)","v":""},{"$f":"IF('Data Entry'!I13=0,\"\",'Data Entry'!I13)","v":""},{"$f":"IF('Data Entry'!J13=0,\"\",'Data Entry'!J13)","v":""},{"$f":"IF('Data Entry'!K13=0,\"\",'Data Entry'!K13)","v":""},{"$f":"IF('Data Entry'!L13=0,\"\",'Data Entry'!L13)","v":""},{"$f":"IF('Data Entry'!M13=0,\"\",'Data Entry'!M13)","v":""},{"$f":"IF('Data Entry'!N13=0,\"\",'Data Entry'!N13)","v":""},{"$f":"IF('Data Entry'!O13=0,\"\",'Data Entry'!O13)","v":""},{"$f":"IF('Data Entry'!P13=0,\"\",'Data Entry'!P13)","v":""}]
[null,"In",null,{"$f":"IF('Data Entry'!C14=0,\"\",'Data Entry'!C14)","v":""},{"$f":"IF('Data Entry'!D14=0,\"\",'Data Entry'!D14)","v":""},{"$f":"IF('Data Entry'!E14=0,\"\",'Data Entry'!E14)","v":""},null,{"$f":"IF('Data Entry'!F14=0,\"\",'Data Entry'!F14)","v":""},{"$f":"IF('Data Entry'!G14=0,\"\",'Data Entry'!G14)","v":""},null,{"$f":"IF('Data Entry'!H14=0,\"\",'Data Entry'!H14)","v":""},{"$f":"IF('Data Entry'!I14=0,\"\",'Data Entry'!I14)","v":""},{"$f":"IF('Data Entry'!J14=0,\"\",'Data Entry'!J14)","v":""},{"$f":"IF('Data Entry'!K14=0,\"\",'Data Entry'!K14)","v":""},{"$f":"IF('Data Entry'!L14=0,\"\",'Data Entry'!L14)","v":""},{"$f":"IF('Data Entry'!M14=0,\"\",'Data Entry'!M14)","v":""},{"$f":"IF('Data Entry'!N14=0,\"\",'Data Entry'!N14)","v":""},{"$f":"IF('Data Entry'!O14=0,\"\",'Data Entry'!O14)","v":""},{"$f":"IF('Data Entry'!P14=0,\"\",'Data Entry'!P14)","v":""}]
[null,"Out",null,{"$f":"IF('Data Entry'!C15=0,\"\",'Data Entry'!C15)","v":""},{"$f":"IF('Data Entry'!D15=0,\"\",'Data Entry'!D15)","v":""},{"$f":"IF('Data Entry'!E15=0,\"\",'Data Entry'!E15)","v":""},null,{"$f":"IF('Data Entry'!F15=0,\"\",'Data Entry'!F15)","v":""},{"$f":"IF('Data Entry'!G15=0,\"\",'Data Entry'!G15)","v":""},null,{"$f":"IF('Data Entry'!H15=0,\"\",'Data Entry'!H15)","v":""},{"$f":"IF('Data Entry'!I15=0,\"\",'Data Entry'!I15)","v":""},{"$f":"IF('Data Entry'!J15=0,\"\",'Data Entry'!J15)","v":""},{"$f":"IF('Data Entry'!K15=0,\"\",'Data Entry'!K15)","v":""},{"$f":"IF('Data Entry'!L15=0,\"\",'Data Entry'!L15)","v":""},{"$f":"IF('Data Entry'!M15=0,\"\",'Data Entry'!M15)","v":""},{"$f":"IF('Data Entry'!N15=0,\"\",'Data Entry'!N15)","v":""},{"$f":"IF('Data Entry'!O15=0,\"\",'Data Entry'!O15)","v":""},{"$f":"IF('Data Entry'!P15=0,\"\",'Data Entry'!P15)","v":""}]
[null,"In",null,{"$f":"IF('Data Entry'!C16=0,\"\",'Data Entry'!C16)","v":""},{"$f":"IF('Data Entry'!D16=0,\"\",'Data Entry'!D16)","v":""},{"$f":"IF('Data Entry'!E16=0,\"\",'Data Entry'!E16)","v":""},null,{"$f":"IF('Data Entry'!F16=0,\"\",'Data Entry'!F16)","v":""},{"$f":"IF('Data Entry'!G16=0,\"\",'Data Entry'!G16)","v":""},null,{"$f":"IF('Data Entry'!H16=0,\"\",'Data Entry'!H16)","v":""},{"$f":"IF('Data Entry'!I16=0,\"\",'Data Entry'!I16)","v":""},{"$f":"IF('Data Entry'!J16=0,\"\",'Data Entry'!J16)","v":""},{"$f":"IF('Data Entry'!K16=0,\"\",'Data Entry'!K16)","v":""},{"$f":"IF('Data Entry'!L16=0,\"\",'Data Entry'!L16)","v":""},{"$f":"IF('Data Entry'!M16=0,\"\",'Data Entry'!M16)","v":""},{"$f":"IF('Data Entry'!N16=0,\"\",'Data Entry'!N16)","v":""},{"$f":"IF('Data Entry'!O16=0,\"\",'Data Entry'!O16)","v":""},{"$f":"IF('Data Entry'!P16=0,\"\",'Data Entry'!P16)","v":""}]
[null,"Out",null,{"$f":"IF('Data Entry'!C17=0,\"\",'Data Entry'!C17)","v":""},{"$f":"IF('Data Entry'!D17=0,\"\",'Data Entry'!D17)","v":""},{"$f":"IF('Data Entry'!E17=0,\"\",'Data Entry'!E17)","v":""},null,{"$f":"IF('Data Entry'!F17=0,\"\",'Data Entry'!F17)","v":""},{"$f":"IF('Data Entry'!G17=0,\"\",'Data Entry'!G17)","v":""},null,{"$f":"IF('Data Entry'!H17=0,\"\",'Data Entry'!H17)","v":""},{"$f":"IF('Data Entry'!I17=0,\"\",'Data Entry'!I17)","v":""},{"$f":"IF('Data Entry'!J17=0,\"\",'Data Entry'!J17)","v":""},{"$f":"IF('Data Entry'!K17=0,\"\",'Data Entry'!K17)","v":""},{"$f":"IF('Data Entry'!L17=0,\"\",'Data Entry'!L17)","v":""},{"$f":"IF('Data Entry'!M17=0,\"\",'Data Entry'!M17)","v":""},{"$f":"IF('Data Entry'!N17=0,\"\",'Data Entry'!N17)","v":""},{"$f":"IF('Data Entry'!O17=0,\"\",'Data Entry'!O17)","v":""},{"$f":"IF('Data Entry'!P17=0,\"\",'Data Entry'!P17)","v":""}]
[null,"In",null,{"$f":"IF('Data Entry'!C18=0,\"\",'Data Entry'!C18)","v":""},{"$f":"IF('Data Entry'!D18=0,\"\",'Data Entry'!D18)","v":""},{"$f":"IF('Data Entry'!E18=0,\"\",'Data Entry'!E18)","v":""},null,{"$f":"IF('Data Entry'!F18=0,\"\",'Data Entry'!F18)","v":""},{"$f":"IF('Data Entry'!G18=0,\"\",'Data Entry'!G18)","v":""},null,{"$f":"IF('Data Entry'!H18=0,\"\",'Data Entry'!H18)","v":""},{"$f":"IF('Data Entry'!I18=0,\"\",'Data Entry'!I18)","v":""},{"$f":"IF('Data Entry'!J18=0,\"\",'Data Entry'!J18)","v":""},{"$f":"IF('Data Entry'!K18=0,\"\",'Data Entry'!K18)","v":""},{"$f":"IF('Data Entry'!L18=0,\"\",'Data Entry'!L18)","v":""},{"$f":"IF('Data Entry'!M18=0,\"\",'Data Entry'!M18)","v":""},{"$f":"IF('Data Entry'!N18=0,\"\",'Data Entry'!N18)","v":""},{"$f":"IF('Data Entry'!O18=0,\"\",'Data Entry'!O18)","v":""},{"$f":"IF('Data Entry'!P18=0,\"\",'Data Entry'!P18)","v":""}]
[null,"Out",null,{"$f":"IF('Data Entry'!C19=0,\"\",'Data Entry'!C19)","v":""},{"$f":"IF('Data Entry'!D19=0,\"\",'Data Entry'!D19)","v":""},{"$f":"IF('Data Entry'!E19=0,\"\",'Data Entry'!E19)","v":""},null,{"$f":"IF('Data Entry'!F19=0,\"\",'Data Entry'!F19)","v":""},{"$f":"IF('Data Entry'!G19=0,\"\",'Data Entry'!G19)","v":""},null,{"$f":"IF('Data Entry'!H19=0,\"\",'Data Entry'!H19)","v":""},{"$f":"IF('Data Entry'!I19=0,\"\",'Data Entry'!I19)","v":""},{"$f":"IF('Data Entry'!J19=0,\"\",'Data Entry'!J19)","v":""},{"$f":"IF('Data Entry'!K19=0,\"\",'Data Entry'!K19)","v":""},{"$f":"IF('Data Entry'!L19=0,\"\",'Data Entry'!L19)","v":""},{"$f":"IF('Data Entry'!M19=0,\"\",'Data Entry'!M19)","v":""},{"$f":"IF('Data Entry'!N19=0,\"\",'Data Entry'!N19)","v":""},{"$f":"IF('Data Entry'!O19=0,\"\",'Data Entry'!O19)","v":""},{"$f":"IF('Data Entry'!P19=0,\"\",'Data Entry'!P19)","v":""}]
[null,"Total Hrs",null,{"$f":"IF('Data Entry'!C20=0,\"\",'Data Entry'!C20)","v":""},{"$f":"IF('Data Entry'!D20=0,\"\",'Data Entry'!D20)","v":""},{"$f":"IF('Data Entry'!E20=0,\"\",'Data Entry'!E20)","v":""},null,{"$f":"IF('Data Entry'!F20=0,\"\",'Data Entry'!F20)","v":""},{"$f":"IF('Data Entry'!G20=0,\"\",'Data Entry'!G20)","v":""},null,{"$f":"IF('Data Entry'!H20=0,\"\",'Data Entry'!H20)","v":""},{"$f":"IF('Data Entry'!I20=0,\"\",'Data Entry'!I20)","v":""},{"$f":"IF('Data Entry'!J20=0,\"\",'Data Entry'!J20)","v":""},{"$f":"IF('Data Entry'!K20=0,\"\",'Data Entry'!K20)","v":""},{"$f":"IF('Data Entry'!L20=0,\"\",'Data Entry'!L20)","v":""},{"$f":"IF('Data Entry'!M20=0,\"\",'Data Entry'!M20)","v":""},{"$f":"IF('Data Entry'!N20=0,\"\",'Data Entry'!N20)","v":""},{"$f":"IF('Data Entry'!O20=0,\"\",'Data Entry'!O20)","v":""},{"$f":"IF('Data Entry'!P20=0,\"\",'Data Entry'!P20)","v":""}]
[null,{"$f":"'Data Entry'!B21","v":0},null,null,null,null,null,null,null,null,"Total Hours Worked Week 1:   ",{"$f":"IF(SUM(D21:L21)=0,\"\",SUM(D21:L21))","v":""},null,null,null,null,null,"Total Hours Worked Week 2:   ",{"$f":"IF(SUM(M21:S21)=0,\"\",SUM(M21:S21))","v":""}]
[]
[]
[null,null,"Leave and Pay Exceptions Report Attached?"]
[]
[null,null,"Students: Leave and Pay Exceptions Report not applicable.  Students should not be allowed to work during their scheduled class times."]
[null,null,"USPS: Leave and Pay Exceptions Report is required for extra hours, leave used, and compensatory leave earned."]
[]
[null,null,"I certify that the hours shown on this sheet accurately reflect time worked during the pay period indicated above."]
[]
[null,null,"Employee's Signature",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,"Supervisor's Signature",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[]
[null,null,"Instructions for Completion:  Complete blocks for in and out times vertically under the appropriate date column.  Total the number"]
[null,null,"of hours worked for the day to the nearest quarter hour (see chart below) in the Total Hrs block located under the appropriate date column.  Add all"]
[null,null,"hours worked during Week 1 by adding all the Total Hrs blocks in the Week 1 section.  Place this total in the Total Hours Worked Week 1 block."]
[null,null,"Follow the same steps for Week 2.  Sign and date the form and obtain your supervisor's verification and signature.  Follow your department's policies"]
[null,null,"for time sheet submission."]
[]
[null,null,null,null,null,null,null,null,null,"Minutes Conversion Chart"]
[null,null,null,null,null,null,null,"Minutes",null,null,"Decimal of Hour",null,null,"Quarter Hours"]
[null,null,null,null,null,null,null,"00 - 07",null,null,null,"0 - .1249   ",null,".00"]
[null,null,null,null,null,null,null,"08 - 22",null,null,null,".1250 - .3749   ",null,".25"]
[null,null,null,null,null,null,null,"23 - 37",null,null,null,".3750 - .6249   ",null,".50"]
[null,null,null,null,null,null,null,"38 - 52",null,null,null,".6250 - .8749   ",null,".75"]
[null,null,null,null,null,null,null,"53 - 60",null,null,null,".8750 - .9999   ",null,"1.00",null,null,null,null,{"$f":"'Data Entry'!R30","v":"TSHelper  Rev. 12/19/2013"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!R31","v":"© 2/01 Fin&Acctg. & HR "}]

{"sheet":"Exceptions","index":2,"n_rows":54,"n_cols":27,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,16,1,17],[20,11,20,12],[21,11,21,12],[21,9,21,10],[45,7,45,17],[46,7,46,17],[47,7,47,17],[48,7,48,17],[18,9,18,10],[18,12,18,13],[53,6,53,7],[53,1,53,4],[53,11,53,14],[53,16,53,17],[49,7,49,17],[19,3,19,4],[19,5,19,6],[19,7,19,8],[21,16,21,17],[21,7,21,8],[19,11,19,12],[19,9,19,10],[20,1,20,2],[21,1,21,2],[20,3,20,4],[21,3,21,4],[44,1,44,2],[44,3,44,4],[25,2,25,9],[43,1,43,17],[20,7,20,8],[21,5,21,6],[25,10,25,17],[22,5,22,6],[20,9,20,10],[20,5,20,6],[44,7,44,17]]}
[null,null,null,null,null,null,null,null,"University of Central Florida"]
[null,null,null,null,null,null,null,null,"Leave and Pay Exceptions Report",null,null,null,null,null,null,"Print Date:",{"$f":"NOW()","v":"2018-01-23T07:51:23.570"}]
[]
[]
[null,{"$f":"'Data Entry'!B5:E5","v":0},null,null,null,"ID: ",{"$f":"'Data Entry'!G5:H5","v":""},null,null,"Empl Rcd#: ",{"$f":"'Data Entry'!J5","v":0},null,"Work Grp: ",{"$f":"'Data Entry'!L5","v":0},null,null,"Group: ",{"$f":"'Data Entry'!O5","v":""}]
[null,"Primary Department:",null,null,{"$f":"'Data Entry'!E7:F7","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,"To print Exceptions report, use the \"Print\" button or the"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"Print Exceptions\" button from the Data Entry sheet."]
[null,null,null,null,null,null,"     ( Individual Leave Report not available here )"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!R30","v":"TSHelper  Rev. 12/19/2013"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Entry'!R31","v":"© 2/01 Fin&Acctg. & HR "}]
[]
[]
[null,null,null,null,null,null,null,null,"Current Pay Period - Begin:",{"$f":"'Data Entry'!G3","v":"00:00:00"},null,"End:",{"$f":"'Data Entry'!K3","v":""}]
[null,null,null,"Sched Hours",null,"*Actual Hrs",null,"OVT",null,"EXC",null,null,null,null,null,null,"Enter Biweekly"]
[null,"  Week 1 Total",null,{"$f":"'Data Entry'!C28","v":40},null,{"$f":"IF('Data Entry'!E28=0,\"\",'Data Entry'!E28)","v":""},null,{"$f":"IF('Data Entry'!G28=0,\"\",'Data Entry'!G28)","v":""},null,null,null,null,null,null,null,null,"On-call Amount:"]
[null,"  Week 2 Total",null,{"$f":"'Data Entry'!C29","v":40},null,{"$f":"IF('Data Entry'!E29=0,\"\",'Data Entry'!E29)","v":""},null,{"$f":"IF('Data Entry'!G29=0,\"\",'Data Entry'!G29)","v":""},null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,{"$f":"SUM(F21:G22)","v":0},null,"  *Represents hours worked + holidays + personal holiday + administrative leave"]
[]
[]
[null,null,"Show Leave Used for Week 1 Below",null,null,null,null,null,null,null,"Show Leave Used for Week 2 Below"]
[null,"Leave",{"$f":"'Data Entry'!C33","v":""},{"$f":"'Data Entry'!D33","v":""},{"$f":"'Data Entry'!E33","v":""},{"$f":"'Data Entry'!F33","v":""},{"$f":"'Data Entry'!G33","v":""},{"$f":"'Data Entry'!H33","v":""},{"$f":"'Data Entry'!I33","v":""},"Wk 1",{"$f":"'Data Entry'!K33","v":""},{"$f":"'Data Entry'!L33","v":""},{"$f":"'Data Entry'!M33","v":""},{"$f":"'Data Entry'!N33","v":""},{"$f":"'Data Entry'!O33","v":""},{"$f":"'Data Entry'!P33","v":""},{"$f":"'Data Entry'!Q33","v":""},"Wk 2"]
[null,"Type",{"$f":"'Data Entry'!C34","v":""},{"$f":"'Data Entry'!D34","v":""},{"$f":"'Data Entry'!E34","v":""},{"$f":"'Data Entry'!F34","v":""},{"$f":"'Data Entry'!G34","v":""},{"$f":"'Data Entry'!H34","v":""},{"$f":"'Data Entry'!I34","v":""},"Total",{"$f":"'Data Entry'!K34","v":""},{"$f":"'Data Entry'!L34","v":""},{"$f":"'Data Entry'!M34","v":""},{"$f":"'Data Entry'!N34","v":""},{"$f":"'Data Entry'!O34","v":""},{"$f":"'Data Entry'!P34","v":""},{"$f":"'Data Entry'!Q34","v":""},"Total"]
[null,{"$f":"IF('Data Entry'!B35=\"\",\"\",UPPER('Data Entry'!B35))","v":""},{"$f":"IF('Data Entry'!C35=\"\",\"\",'Data Entry'!C35)","v":""},{"$f":"IF('Data Entry'!D35=\"\",\"\",'Data Entry'!D35)","v":""},{"$f":"IF('Data Entry'!E35=\"\",\"\",'Data Entry'!E35)","v":""},{"$f":"IF('Data Entry'!F35=\"\",\"\",'Data Entry'!F35)","v":""},{"$f":"IF('Data Entry'!G35=\"\",\"\",'Data Entry'!G35)","v":""},{"$f":"IF('Data Entry'!H35=\"\",\"\",'Data Entry'!H35)","v":""},{"$f":"IF('Data Entry'!I35=\"\",\"\",'Data Entry'!I35)","v":""},{"$f":"IF(SUM(C29:I29)=0,\"\",SUM(C29:I29))","v":""},{"$f":"IF('Data Entry'!K35=\"\",\"\",'Data Entry'!K35)","v":""},{"$f":"IF('Data Entry'!L35=\"\",\"\",'Data Entry'!L35)","v":""},{"$f":"IF('Data Entry'!M35=\"\",\"\",'Data Entry'!M35)","v":""},{"$f":"IF('Data Entry'!N35=\"\",\"\",'Data Entry'!N35)","v":""},{"$f":"IF('Data Entry'!O35=\"\",\"\",'Data Entry'!O35)","v":""},{"$f":"IF('Data Entry'!P35=\"\",\"\",'Data Entry'!P35)","v":""},{"$f":"IF('Data Entry'!Q35=\"\",\"\",'Data Entry'!Q35)","v":""},{"$f":"IF(SUM(K29:Q29)=0,\"\",SUM(K29:Q29))","v":""}]
[null,{"$f":"IF('Data Entry'!B36=\"\",\"\",UPPER('Data Entry'!B36))","v":""},{"$f":"IF('Data Entry'!C36=\"\",\"\",'Data Entry'!C36)","v":""},{"$f":"IF('Data Entry'!D36=\"\",\"\",'Data Entry'!D36)","v":""},{"$f":"IF('Data Entry'!E36=\"\",\"\",'Data Entry'!E36)","v":""},{"$f":"IF('Data Entry'!F36=\"\",\"\",'Data Entry'!F36)","v":""},{"$f":"IF('Data Entry'!G36=\"\",\"\",'Data Entry'!G36)","v":""},{"$f":"IF('Data Entry'!H36=\"\",\"\",'Data Entry'!H36)","v":""},{"$f":"IF('Data Entry'!I36=\"\",\"\",'Data Entry'!I36)","v":""},{"$f":"IF(SUM(C30:I30)=0,\"\",SUM(C30:I30))","v":""},{"$f":"IF('Data Entry'!K36=\"\",\"\",'Data Entry'!K36)","v":""},{"$f":"IF('Data Entry'!L36=\"\",\"\",'Data Entry'!L36)","v":""},{"$f":"IF('Data Entry'!M36=\"\",\"\",'Data Entry'!M36)","v":""},{"$f":"IF('Data Entry'!N36=\"\",\"\",'Data Entry'!N36)","v":""},{"$f":"IF('Data Entry'!O36=\"\",\"\",'Data Entry'!O36)","v":""},{"$f":"IF('Data Entry'!P36=\"\",\"\",'Data Entry'!P36)","v":""},{"$f":"IF('Data Entry'!Q36=\"\",\"\",'Data Entry'!Q36)","v":""},{"$f":"IF(SUM(K30:Q30)=0,\"\",SUM(K30:Q30))","v":""}]
[null,{"$f":"IF('Data Entry'!B37=\"\",\"\",UPPER('Data Entry'!B37))","v":""},{"$f":"IF('Data Entry'!C37=\"\",\"\",'Data Entry'!C37)","v":""},{"$f":"IF('Data Entry'!D37=\"\",\"\",'Data Entry'!D37)","v":""},{"$f":"IF('Data Entry'!E37=\"\",\"\",'Data Entry'!E37)","v":""},{"$f":"IF('Data Entry'!F37=\"\",\"\",'Data Entry'!F37)","v":""},{"$f":"IF('Data Entry'!G37=\"\",\"\",'Data Entry'!G37)","v":""},{"$f":"IF('Data Entry'!H37=\"\",\"\",'Data Entry'!H37)","v":""},{"$f":"IF('Data Entry'!I37=\"\",\"\",'Data Entry'!I37)","v":""},{"$f":"IF(SUM(C31:I31)=0,\"\",SUM(C31:I31))","v":""},{"$f":"IF('Data Entry'!K37=\"\",\"\",'Data Entry'!K37)","v":""},{"$f":"IF('Data Entry'!L37=\"\",\"\",'Data Entry'!L37)","v":""},{"$f":"IF('Data Entry'!M37=\"\",\"\",'Data Entry'!M37)","v":""},{"$f":"IF('Data Entry'!N37=\"\",\"\",'Data Entry'!N37)","v":""},{"$f":"IF('Data Entry'!O37=\"\",\"\",'Data Entry'!O37)","v":""},{"$f":"IF('Data Entry'!P37=\"\",\"\",'Data Entry'!P37)","v":""},{"$f":"IF('Data Entry'!Q37=\"\",\"\",'Data Entry'!Q37)","v":""},{"$f":"IF(SUM(K31:Q31)=0,\"\",SUM(K31:Q31))","v":""}]
[null,{"$f":"IF('Data Entry'!B38=\"\",\"\",UPPER('Data Entry'!B38))","v":""},{"$f":"IF('Data Entry'!C38=\"\",\"\",'Data Entry'!C38)","v":""},{"$f":"IF('Data Entry'!D38=\"\",\"\",'Data Entry'!D38)","v":""},{"$f":"IF('Data Entry'!E38=\"\",\"\",'Data Entry'!E38)","v":""},{"$f":"IF('Data Entry'!F38=\"\",\"\",'Data Entry'!F38)","v":""},{"$f":"IF('Data Entry'!G38=\"\",\"\",'Data Entry'!G38)","v":""},{"$f":"IF('Data Entry'!H38=\"\",\"\",'Data Entry'!H38)","v":""},{"$f":"IF('Data Entry'!I38=\"\",\"\",'Data Entry'!I38)","v":""},{"$f":"IF(SUM(C32:I32)=0,\"\",SUM(C32:I32))","v":""},{"$f":"IF('Data Entry'!K38=\"\",\"\",'Data Entry'!K38)","v":""},{"$f":"IF('Data Entry'!L38=\"\",\"\",'Data Entry'!L38)","v":""},{"$f":"IF('Data Entry'!M38=\"\",\"\",'Data Entry'!M38)","v":""},{"$f":"IF('Data Entry'!N38=\"\",\"\",'Data Entry'!N38)","v":""},{"$f":"IF('Data Entry'!O38=\"\",\"\",'Data Entry'!O38)","v":""},{"$f":"IF('Data Entry'!P38=\"\",\"\",'Data Entry'!P38)","v":""},{"$f":"IF('Data Entry'!Q38=\"\",\"\",'Data Entry'!Q38)","v":""},{"$f":"IF(SUM(K32:Q32)=0,\"\",SUM(K32:Q32))","v":""}]
[null,{"$f":"IF('Data Entry'!B39=\"\",\"\",UPPER('Data Entry'!B39))","v":""},{"$f":"IF('Data Entry'!C39=\"\",\"\",'Data Entry'!C39)","v":""},{"$f":"IF('Data Entry'!D39=\"\",\"\",'Data Entry'!D39)","v":""},{"$f":"IF('Data Entry'!E39=\"\",\"\",'Data Entry'!E39)","v":""},{"$f":"IF('Data Entry'!F39=\"\",\"\",'Data Entry'!F39)","v":""},{"$f":"IF('Data Entry'!G39=\"\",\"\",'Data Entry'!G39)","v":""},{"$f":"IF('Data Entry'!H39=\"\",\"\",'Data Entry'!H39)","v":""},{"$f":"IF('Data Entry'!I39=\"\",\"\",'Data Entry'!I39)","v":""},{"$f":"IF(SUM(C33:I33)=0,\"\",SUM(C33:I33))","v":""},{"$f":"IF('Data Entry'!K39=\"\",\"\",'Data Entry'!K39)","v":""},{"$f":"IF('Data Entry'!L39=\"\",\"\",'Data Entry'!L39)","v":""},{"$f":"IF('Data Entry'!M39=\"\",\"\",'Data Entry'!M39)","v":""},{"$f":"IF('Data Entry'!N39=\"\",\"\",'Data Entry'!N39)","v":""},{"$f":"IF('Data Entry'!O39=\"\",\"\",'Data Entry'!O39)","v":""},{"$f":"IF('Data Entry'!P39=\"\",\"\",'Data Entry'!P39)","v":""},{"$f":"IF('Data Entry'!Q39=\"\",\"\",'Data Entry'!Q39)","v":""},{"$f":"IF(SUM(K33:Q33)=0,\"\",SUM(K33:Q33))","v":""}]
[null,"Please indicate the type of leave being used in the column marked 'Leave Type' and indicate the number of hours in the column(s) with the"]
[null,"appropriate date."]
[null,null,"(A)","Annual Leave",null,null,"(DIS)","Disability",null,null,"(LWO)","Leave Without Pay",null,null,"(MIL)","Military"]
[null,null,"(OCT)","OverTime Comp",null,null,"(PH)","Personal Hol",null,null,"(S)","Sick",null,null,"(S73)","Sick Pre73"]
[null,null,"(SCT)","Special Comp",null,null,"(WC)","Work Comp",null,null,"(WCL)","WkCmp Lv/no Pay",null,null,"(AdmLv)","Admin Leave"]
[null,null,"(SPS)","Sick Leave Pool"]
[null,"Leave usage must be requested and approved in advance, except in emergency situations.  Provide justification below for all leave usage."]
[null,"A Medical or Parental Leave Request Form and Medical Certification Form are required when absent more than 10 business days for"]
[null,"medical or parental leave, or for a work-related illness or injury."]
[]
[null,"Explanation of Leave Used (Use Separate Sheet of Paper if necessary)"]
[null,"From",null,"To",null,"Leave","#","Reason"]
[null,"Date","Time","Date","Time","Type","Hours"]
[null,{"$f":"IF('Data Entry'!C51=\"\",\"\",'Data Entry'!C51)","v":""},{"$f":"IF('Data Entry'!D51=\"\",\"\",'Data Entry'!D51)","v":""},{"$f":"IF('Data Entry'!E51=\"\",\"\",'Data Entry'!E51)","v":""},{"$f":"IF('Data Entry'!F51=\"\",\"\",'Data Entry'!F51)","v":""},{"$f":"IF('Data Entry'!G51=\"\",\"\",UPPER('Data Entry'!G51))","v":""},{"$f":"IF('Data Entry'!H51=\"\",\"\",'Data Entry'!H51)","v":""},{"$f":"IF('Data Entry'!I51=\"\",\"\",'Data Entry'!I51)","v":""}]
[null,{"$f":"IF('Data Entry'!C52=\"\",\"\",'Data Entry'!C52)","v":""},{"$f":"IF('Data Entry'!D52=\"\",\"\",'Data Entry'!D52)","v":""},{"$f":"IF('Data Entry'!E52=\"\",\"\",'Data Entry'!E52)","v":""},{"$f":"IF('Data Entry'!F52=\"\",\"\",'Data Entry'!F52)","v":""},{"$f":"IF('Data Entry'!G52=\"\",\"\",UPPER('Data Entry'!G52))","v":""},{"$f":"IF('Data Entry'!H52=\"\",\"\",'Data Entry'!H52)","v":""},{"$f":"IF('Data Entry'!I52=\"\",\"\",'Data Entry'!I52)","v":""}]
[null,{"$f":"IF('Data Entry'!C53=\"\",\"\",'Data Entry'!C53)","v":""},{"$f":"IF('Data Entry'!D53=\"\",\"\",'Data Entry'!D53)","v":""},{"$f":"IF('Data Entry'!E53=\"\",\"\",'Data Entry'!E53)","v":""},{"$f":"IF('Data Entry'!F53=\"\",\"\",'Data Entry'!F53)","v":""},{"$f":"IF('Data Entry'!G53=\"\",\"\",UPPER('Data Entry'!G53))","v":""},{"$f":"IF('Data Entry'!H53=\"\",\"\",'Data Entry'!H53)","v":""},{"$f":"IF('Data Entry'!I53=\"\",\"\",'Data Entry'!I53)","v":""}]
[null,{"$f":"IF('Data Entry'!C54=\"\",\"\",'Data Entry'!C54)","v":""},{"$f":"IF('Data Entry'!D54=\"\",\"\",'Data Entry'!D54)","v":""},{"$f":"IF('Data Entry'!E54=\"\",\"\",'Data Entry'!E54)","v":""},{"$f":"IF('Data Entry'!F54=\"\",\"\",'Data Entry'!F54)","v":""},{"$f":"IF('Data Entry'!G54=\"\",\"\",UPPER('Data Entry'!G54))","v":""},{"$f":"IF('Data Entry'!H54=\"\",\"\",'Data Entry'!H54)","v":""},{"$f":"IF('Data Entry'!I54=\"\",\"\",'Data Entry'!I54)","v":""}]
[null,null," I certify that the hours shown on this form accurately reflect time worked and leave taken during the period indicated."]
[]
[]
[null,"Employee's Signature",null,null,null,null,"Date",null,null,null,null,"Supervisor's Signature",null,null,null,null,"Date"]

{"sheet":"Tech Maintenance","index":3,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Updated by","Date","Reason","Where fixed","New Version #"]
["MR","2018-01-19","Downloaded version from A-Z to fix the Refresh button","code for Refresh button","v4.1mr"]