{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Time Record","Split Position Time Record","Pay Period Schedule","Time Off Request - Calculated","Time Off Request - Blank"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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 Record","index":0,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":false,"merged":[[21,16,21,17],[22,13,22,14],[22,7,22,8],[21,11,21,12],[21,9,21,10],[17,3,17,4],[17,5,17,6],[17,7,17,8],[18,7,18,8],[18,3,18,4],[19,13,19,14],[18,11,18,12],[21,13,21,14],[21,5,21,6],[22,11,22,12],[22,9,22,10],[22,16,22,17],[15,1,15,2],[15,3,15,4],[18,9,18,10],[18,5,18,6],[8,11,8,12],[8,7,8,8],[14,1,14,2],[14,9,14,10],[14,11,14,12],[17,9,17,10],[17,11,17,12],[16,1,16,2],[16,3,16,4],[16,7,16,8],[13,3,13,4],[14,3,14,4],[14,7,14,8],[13,11,13,12],[17,1,17,2],[16,5,16,6],[18,1,18,2],[16,11,16,12],[16,9,16,10],[30,1,30,2],[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[22,1,22,2],[21,1,21,2],[31,1,31,2],[21,7,21,8],[28,1,28,2],[27,1,27,2],[27,3,27,4],[28,3,28,4],[28,5,28,6],[28,7,28,8],[21,3,21,4],[22,3,22,4],[22,5,22,6],[29,1,29,2],[36,5,36,10],[5,5,5,6],[15,11,15,12],[29,13,29,14],[15,5,15,6],[15,7,15,8],[6,5,6,6],[13,13,13,14],[8,13,8,14],[7,13,7,14],[32,13,32,14],[15,13,15,14],[15,9,15,10],[31,9,31,10],[31,11,31,12],[31,13,31,14],[29,11,29,12],[18,13,18,14],[17,13,17,14],[16,13,16,14],[14,13,14,14],[13,7,13,8],[13,9,13,10],[14,5,14,6],[35,5,35,10],[27,9,27,10],[30,3,30,4],[30,5,30,6],[30,7,30,8],[29,3,29,4],[32,9,32,10],[30,13,30,14],[29,9,29,10],[31,3,31,4],[31,5,31,6],[31,7,31,8],[30,11,30,12],[27,11,27,12],[28,9,28,10],[28,11,28,12],[27,13,27,14],[27,5,27,6],[27,7,27,8],[28,13,28,14],[29,5,29,6],[29,7,29,8],[32,11,32,12],[30,9,30,10],[3,1,3,6],[13,1,13,2],[7,11,7,12],[8,9,8,10],[4,1,4,3],[13,5,13,6],[7,9,7,10],[8,1,8,2],[8,3,8,4],[7,5,7,6],[7,7,7,8],[7,3,7,4],[8,5,8,6],[7,1,7,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"Total Jury/Spc Hrs",null,null,{"$f":"P15+P29","v":0},"Allocated Benefit Hrs\nper Fund","Holiday","Jury Duty Spec.","PTO"]
[null,null,null,null,null,null,null,null,null,null,null,"Total Hol Hrs",null,null,{"$f":"P16+P30","v":0},{"$f":"'Split Position Time Record'!I2","v":"GHT-OP"},{"$f":"'Split Position Time Record'!Q2","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!R2","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!T2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Reg Hrs",null,null,{"$f":"P14+P28","v":0},{"$f":"'Split Position Time Record'!I3","v":"GHT-VR"},{"$f":"'Split Position Time Record'!Q3","v":0},{"$f":"'Split Position Time Record'!R3","v":0},{"$f":"'Split Position Time Record'!T3","v":0}]
["NAME:","Your Name Here",null,null,null,null,null,null,null,"Salary",null,"Total Hol + Jury + Reg",null,null,{"$f":"SUM(O1:O3)","v":0},{"$f":"'Split Position Time Record'!I4","v":"GHT-FA"},{"$f":"'Split Position Time Record'!Q4","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!R4","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!T4","v":0}]
["Emp #:","XX222222",null,null,null,"Pay Period Dates:",null,null,null,"Hourly",null,"PTO Hrs",null,null,{"$f":"P17+P31","v":0},{"$f":"'Split Position Time Record'!I5","v":"WFD-NS"},{"$f":"'Split Position Time Record'!Q5","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!R5","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!T5","v":0}]
[null,null,null,null,"Begin:",{"$f":"B8","v":"00:00:00"},null,null,null,null,null,null,null,null,null,{"$f":"'Split Position Time Record'!I6","v":"WFD-MH"},{"$f":"'Split Position Time Record'!Q6","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!R6","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!T6","v":0}]
["Time Record Ver 02/10/2013",null,null,null,"End:",{"$f":"N22","v":"1900-01-13"},null,null,null,null,null,"Total Paid Hrs",null,null,{"$f":"O5+O4+O6","v":0},{"$f":"'Split Position Time Record'!I7","v":"WFD-YO"},{"$f":"'Split Position Time Record'!Q7","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!R7","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!T7","v":0}]
[null,null,null,{"$f":"B8+1","v":"1900-01-01"},null,{"$f":"D8+1","v":"1900-01-02"},null,{"$f":"F8+1","v":"1900-01-03"},null,{"$f":"H8+1","v":"1900-01-04"},null,{"$f":"J8+1","v":"1900-01-05"},null,{"$f":"L8+1","v":"1900-01-06"},null,{"$f":"'Split Position Time Record'!I8","v":"WFD-NP"},{"$f":"'Split Position Time Record'!Q8","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!R8","v":{"$error":"#DIV/0!"}},{"$f":"'Split Position Time Record'!T8","v":0}]
[null,"THURSDAY",null,"FRIDAY",null,"SATURDAY",null,"SUNDAY",null,"MONDAY",null,"TUESDAY",null,"WEDNESDAY",null,"Total PTOHours",{"$f":"SUM(Q2:Q6)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R2:R6)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(S2:S6)","v":"00:00:00"}]
["In/Out"]
["In/Out",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Hours"]
["In/Out"]
["In/Out"]
["Total hrs worked",{"$f":"SUM((C10-B10)+(C11-B11)+(C12-B12)+(C13-B13))","v":"00:00:00"},null,{"$f":"SUM((E10-D10)+(E11-D11)+(E12-D12)+(E13-D13))","v":"00:00:00"},null,{"$f":"SUM((G10-F10)+(G11-F11)+(G12-F12)+(G13-F13))","v":"00:00:00"},null,{"$f":"SUM((I10-H10)+(I11-H11)+(I12-H12)+(I13-H13))","v":"00:00:00"},null,{"$f":"SUM((K10-J10)+(K11-J11)+(K12-J12)+(K13-J13))","v":"00:00:00"},null,{"$f":"SUM((M10-L10)+(M11-L11)+(M12-L12)+(M13-L13))","v":"00:00:00"},null,{"$f":"SUM((O10-N10)+(O11-N11)+(O12-N12)+(O13-N13))","v":"00:00:00"},null,{"$f":"SUM(B14:O14)","v":0}]
["Jury Duty/Spec",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Holiday Hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["PTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Total paid hours",{"$f":"B14+B17+B16+B18+B15","v":"00:00:00"},null,{"$f":"D14+D17+D16+D18+D15","v":"00:00:00"},null,{"$f":"F14+F17+F16+F18+F15","v":"00:00:00"},null,{"$f":"H14+H17+H16+H18+H15","v":"00:00:00"},null,{"$f":"J14+J17+J16+J18+J15","v":"00:00:00"},null,{"$f":"L14+L17+L16+L18+L15","v":"00:00:00"},null,{"$f":"N14+N17+N16+N18+N15","v":"00:00:00"},null,0]
[]
[]
["DATE",{"$f":"N8+1","v":"1900-01-07"},null,{"$f":"B22+1","v":"1900-01-08"},null,{"$f":"D22+1","v":"1900-01-09"},null,{"$f":"F22+1","v":"1900-01-10"},null,{"$f":"H22+1","v":"1900-01-11"},null,{"$f":"J22+1","v":"1900-01-12"},null,{"$f":"L22+1","v":"1900-01-13"},null,null,2013]
[null,"THURSDAY",null,"FRIDAY",null,"SATURDAY",null,"SUNDAY",null,"MONDAY",null,"TUESDAY",null,"WEDNESDAY",null,null,"Ver 03/25/2013"]
["In/Out"]
["In/Out"]
["In/Out"]
["In/Out",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Hours"]
["Total hrs worked",{"$f":"SUM((C24-B24)+(C25-B25)+(C26-B26)+(C27-B27))","v":"00:00:00"},null,{"$f":"SUM((E24-D24)+(E25-D25)+(E26-D26)+(E27-D27))","v":"00:00:00"},null,{"$f":"SUM((G24-F24)+(G25-F25)+(G26-F26)+(G27-F27))","v":"00:00:00"},null,{"$f":"SUM((I24-H24)+(I25-H25)+(I26-H26)+(I27-H27))","v":"00:00:00"},null,{"$f":"SUM((K24-J24)+(K25-J25)+(K26-J26)+(K27-J27))","v":"00:00:00"},null,{"$f":"SUM((M24-L24)+(M25-L25)+(M26-L26)+(M27-L27))","v":"00:00:00"},null,{"$f":"SUM((O24-N24)+(O25-N25)+(O26-N26)+(O27-N27))","v":"00:00:00"},null,{"$f":"SUM(B28:O28)","v":0}]
["Jury Duty/Spec",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Holiday Hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["PTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Total paid hours",{"$f":"B28+B31+B30+B32+B29","v":"00:00:00"},null,{"$f":"D28+D31+D30+D32+D29","v":"00:00:00"},null,{"$f":"F28+F31+F30+F32+F29","v":"00:00:00"},null,{"$f":"H28+H31+H30+H32+H29","v":"00:00:00"},null,{"$f":"J28+J31+J30+J32+J29","v":"00:00:00"},null,{"$f":"L28+L31+L30+L32+L29","v":"00:00:00"},null,{"$f":"N28+N31+N30+N32+N29","v":"00:00:00"},null,0]
[]
[]
[null,null,"Employee Signature:",null,null,null,null,null,null,null,null,null,"Date:",null,null,{"$f":"P33+P19","v":0}]
[null,null,"Supervisor Signature:",null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[]
[]
[]
[{"$f":"'Pay Period Schedule'!A4","v":"2013-02-07"}]
[{"$f":"'Pay Period Schedule'!A5","v":"2013-02-21"}]
[{"$f":"'Pay Period Schedule'!A6","v":"2013-03-07"}]
[{"$f":"'Pay Period Schedule'!A7","v":"2013-03-21"}]
[{"$f":"'Pay Period Schedule'!A8","v":"2013-04-04"}]
[{"$f":"'Pay Period Schedule'!A9","v":"2013-04-18"}]
[{"$f":"'Pay Period Schedule'!A10","v":"2013-05-02"}]
[{"$f":"'Pay Period Schedule'!A11","v":"2013-05-16"}]
[{"$f":"'Pay Period Schedule'!A12","v":"2013-05-30"}]
[{"$f":"'Pay Period Schedule'!A13","v":"2013-06-13"}]
[{"$f":"'Pay Period Schedule'!A14","v":"2013-06-27"}]
[{"$f":"'Pay Period Schedule'!A15","v":"2013-07-11"}]
[{"$f":"'Pay Period Schedule'!A16","v":"2013-07-25"}]
[{"$f":"'Pay Period Schedule'!A17","v":"2013-08-08"}]
[{"$f":"'Pay Period Schedule'!A18","v":"2013-08-22"}]
[{"$f":"'Pay Period Schedule'!A19","v":"2013-09-05"}]
[{"$f":"'Pay Period Schedule'!A20","v":"2013-09-19"}]
[{"$f":"'Pay Period Schedule'!A21","v":"2013-10-03"}]
[{"$f":"'Pay Period Schedule'!A22","v":"2013-10-17"}]
[{"$f":"'Pay Period Schedule'!A23","v":"2013-10-31"}]
[{"$f":"'Pay Period Schedule'!A24","v":"2013-11-14"}]
[{"$f":"'Pay Period Schedule'!A25","v":"2013-11-28"}]
[{"$f":"'Pay Period Schedule'!A26","v":"2013-12-12"}]
[{"$f":"'Pay Period Schedule'!A27","v":"2013-12-26"}]
[{"$f":"'Pay Period Schedule'!A28","v":"2014-01-09"}]
[{"$f":"'Pay Period Schedule'!A29","v":"2014-01-23"}]
[{"$f":"'Pay Period Schedule'!A30","v":"2014-02-06"}]

{"sheet":"Split Position Time Record","index":1,"n_rows":79,"n_cols":21,"rows_kept":79,"cut":false,"hidden":false,"merged":[[2,1,2,6],[6,5,6,6],[9,1,9,2],[9,3,9,4],[0,13,0,14],[0,0,1,4],[46,5,46,10],[5,5,5,6],[4,1,4,3],[45,5,45,10],[28,9,28,10],[10,5,10,6],[40,0,40,1],[36,0,36,1],[9,5,9,6],[9,7,9,8],[27,3,27,4],[27,5,27,6],[9,9,9,10],[39,0,39,1],[37,0,37,1],[38,0,38,1],[19,0,19,1],[20,0,20,1],[10,9,10,10],[10,7,10,8],[27,1,27,2],[22,0,22,1],[27,7,27,8],[18,0,18,1],[28,11,28,12],[28,13,28,14],[9,11,9,12],[27,9,27,10],[21,0,21,1],[9,13,9,14],[10,11,10,12],[27,11,27,12],[27,13,27,14],[10,13,10,14],[10,1,10,2],[10,3,10,4],[28,1,28,2],[28,3,28,4],[28,5,28,6],[28,7,28,8]]}
["Guinn Healthcare Technologies, LLC - Split Position Time Record",null,null,null,null,null,null,null,null,"Hrs Wrkd Ratio","Prjctd Hrs/Min per day","Prjctd Hrs per Week","Prjctd Per Pay Period","Fund Category",null,{"$f":"'Time Record'!O3","v":0},{"$f":"'Time Record'!O2","v":0},{"$f":"'Time Record'!O1","v":0},{"$f":"'Time Record'!O4","v":0},{"$f":"'Time Record'!O5","v":0},{"$f":"'Time Record'!O7","v":0}]
[null,null,null,null,null,null,null,null,"GHT-OP",{"$f":"(P2+P3)/P10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"I2","v":"GHT-OP"},null,{"$f":"P12+P30","v":0},{"$f":"'Time Record'!$O$2*J2","v":{"$error":"#DIV/0!"}},{"$f":"'Time Record'!$O$1*$J2","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P2:R2)","v":{"$error":"#DIV/0!"}},null,{"$f":"S2+T2","v":{"$error":"#DIV/0!"}}]
["NAME:",{"$f":"'Time Record'!B4:G4","v":"Your Name Here"},null,null,null,null,null,null,"GHT-VR",null,null,null,null,"GHT-VR",null,{"$f":"P13+P31","v":0},null,null,{"$f":"P3","v":0},null,{"$f":"S3","v":0}]
[null,null,null,null,null,null,null,null,"GHT-FA",{"$f":"P4/P10","v":{"$error":"#DIV/0!"}},null,null,null,"GHT-FA",null,{"$f":"P14+P32","v":0},{"$f":"'Time Record'!$O$2*J4","v":{"$error":"#DIV/0!"}},{"$f":"'Time Record'!$O$1*$J4","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P4:R4)","v":{"$error":"#DIV/0!"}},null,{"$f":"S4+T4","v":{"$error":"#DIV/0!"}}]
["Emp #:",{"$f":"'Time Record'!B5:D5","v":"XX222222"},null,null,null,"Pay Period Dates:",null,null,"WFD-NS",{"$f":"P5/P10","v":{"$error":"#DIV/0!"}},null,null,null,"WFD-NS",null,{"$f":"P15+P33","v":0},{"$f":"'Time Record'!$O$2*J5","v":{"$error":"#DIV/0!"}},{"$f":"'Time Record'!$O$1*$J5","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P5:R5)","v":{"$error":"#DIV/0!"}},null,{"$f":"S5+T5","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Begin:",{"$f":"'Time Record'!F6:G6","v":"00:00:00"},null,null,"WFD-MH",{"$f":"P6/P10","v":{"$error":"#DIV/0!"}},null,null,null,"WFD-MH",null,{"$f":"P16+P34","v":0},{"$f":"'Time Record'!$O$2*J6","v":{"$error":"#DIV/0!"}},{"$f":"'Time Record'!$O$1*$J6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$f":"'Time Record'!A7","v":"Time Record Ver 02/10/2013"},null,null,null,"End:",{"$f":"'Time Record'!F7:G7","v":"1900-01-13"},null,null,"WFD-YO",{"$f":"P7/P10","v":{"$error":"#DIV/0!"}},null,null,null,"WFD-YO",null,{"$f":"P17+P35","v":0},{"$f":"'Time Record'!$O$2*J7","v":{"$error":"#DIV/0!"}},{"$f":"'Time Record'!$O$1*$J7","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P7:R7)","v":{"$error":"#DIV/0!"}},null,{"$f":"S7+T7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"WFD-NP",{"$f":"P8/P10","v":{"$error":"#DIV/0!"}},null,null,null,"WFD-NP",null,{"$f":"P18+P36","v":0},{"$f":"'Time Record'!$O$2*J8","v":{"$error":"#DIV/0!"}},{"$f":"'Time Record'!$O$1*$J8","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P8:R8)","v":{"$error":"#DIV/0!"}},null,{"$f":"S8+T8","v":{"$error":"#DIV/0!"}}]
["Only enter Program Hours; PTO will be drawn from the preceeding worksheet automatically.",null,null,null,null,null,null,null,"Vac/PTO",{"$f":"SUM(J2:J8)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(L2:L6)","v":0},{"$f":"SUM(M2:M6)","v":0},"Vac/PTO",null,null,null,null,null,{"$f":"P22+P40","v":0},{"$f":"S9+T9","v":0}]
["DATE",{"$f":"'Time Record'!B8:C8","v":"00:00:00"},null,{"$f":"'Time Record'!D8:E8","v":"1900-01-01"},null,{"$f":"'Time Record'!F8:G8","v":"1900-01-02"},null,{"$f":"'Time Record'!H8:I8","v":"1900-01-03"},null,{"$f":"'Time Record'!J8:K8","v":"1900-01-04"},null,{"$f":"'Time Record'!L8:M8","v":"1900-01-05"},null,{"$f":"'Time Record'!N8:O8","v":"1900-01-06"},null,{"$f":"SUM(P2:P9)","v":0},{"$f":"SUM(Q2:Q9)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R2:R9)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(S2:S9)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(T2:T9)","v":0},{"$f":"SUM(U2:U9)","v":{"$error":"#DIV/0!"}}]
[null,"THURSDAY",null,"FRIDAY",null,"SATURDAY",null,"SUNDAY",null,"MONDAY",null,"TUESDAY",null,"WEDNESDAY",null,"Wrkd Per Pgm","Holiday Allocated","JD/Spec Allocated","Total Direct Hrs","PTO Allocated","Total Time"]
["Pgm Hrs",{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"C12+E12+G12+I12+K12+M12+O12","v":0}]
["Pgm Hrs",{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"C13+E13+G13+I13+K13+M13+O13","v":0}]
["Pgm Hrs",{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,0]
["Pgm Hrs",{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,0]
["Pgm Hrs",{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"C16+E16+G16+I16+K16+M16+O16","v":0}]
["Pgm Hrs",{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,0]
["Pgm Hrs",{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"C18+E18+G18+I18+K18+M18+O18","v":0}]
["Total Pgm Dir Hrs",null,{"$f":"SUM(C12:C18)","v":"00:00:00"},null,{"$f":"SUM(E12:E18)","v":0},null,{"$f":"SUM(G12:G18)","v":"00:00:00"},null,{"$f":"SUM(I12:I18)","v":"00:00:00"},null,{"$f":"SUM(K12:K18)","v":"00:00:00"},null,{"$f":"SUM(M12:M18)","v":"00:00:00"},null,{"$f":"SUM(O12:O18)","v":"00:00:00"},{"$f":"SUM(C19:O19)","v":0}]
[{"$f":"'Time Record'!A15","v":"Jury Duty/Spec"},null,{"$f":"'Time Record'!B15","v":"00:00:00"},null,{"$f":"'Time Record'!D15","v":"00:00:00"},null,{"$f":"'Time Record'!F15","v":"00:00:00"},null,{"$f":"'Time Record'!H15","v":"00:00:00"},null,{"$f":"'Time Record'!J15","v":"00:00:00"},null,{"$f":"'Time Record'!L15","v":"00:00:00"},null,{"$f":"'Time Record'!N15","v":"00:00:00"},{"$f":"SUM(C20:O20)","v":0}]
[{"$f":"'Time Record'!A16","v":"Holiday Hrs"},null,{"$f":"'Time Record'!B16","v":"00:00:00"},null,{"$f":"'Time Record'!D16","v":"00:00:00"},null,{"$f":"'Time Record'!F16","v":"00:00:00"},null,{"$f":"'Time Record'!H16","v":"00:00:00"},null,{"$f":"'Time Record'!J16","v":"00:00:00"},null,{"$f":"'Time Record'!L16","v":"00:00:00"},null,{"$f":"'Time Record'!N16","v":"00:00:00"},0]
[{"$f":"'Time Record'!A17","v":"PTO"},null,{"$f":"'Time Record'!B17","v":"00:00:00"},null,{"$f":"'Time Record'!D17","v":"00:00:00"},null,{"$f":"'Time Record'!F17","v":"00:00:00"},null,{"$f":"'Time Record'!H17","v":"00:00:00"},null,{"$f":"'Time Record'!J17","v":"00:00:00"},null,{"$f":"'Time Record'!L17","v":"00:00:00"},null,{"$f":"'Time Record'!N17","v":"00:00:00"},0]
["Hrs from Timesheet",null,{"$f":"'Time Record'!B19","v":"00:00:00"},null,{"$f":"'Time Record'!D19","v":0},null,{"$f":"'Time Record'!F19","v":"00:00:00"},null,{"$f":"'Time Record'!H19","v":"00:00:00"},null,{"$f":"'Time Record'!J19","v":"00:00:00"},null,{"$f":"'Time Record'!L19","v":"00:00:00"},null,{"$f":"'Time Record'!N19","v":"00:00:00"},0]
["Ovr/Under Error",null,{"$f":"SUM(C19:C22)-C23","v":"00:00:00"},null,{"$f":"SUM(E19:E22)-E23","v":"00:00:00"},null,{"$f":"SUM(G19:G22)-G23","v":"00:00:00"},null,{"$f":"SUM(I19:I22)-I23","v":"00:00:00"},null,{"$f":"SUM(K19:K22)-K23","v":"00:00:00"},null,{"$f":"SUM(M19:M22)-M23","v":"00:00:00"},null,{"$f":"SUM(O19:O22)-O23","v":"00:00:00"},0]
[]
[]
[]
["DATE",{"$f":"'Time Record'!B22:C22","v":"1900-01-07"},null,{"$f":"'Time Record'!D22:E22","v":"1900-01-08"},null,{"$f":"'Time Record'!F22:G22","v":"1900-01-09"},null,{"$f":"'Time Record'!H22:I22","v":"1900-01-10"},null,{"$f":"'Time Record'!J22:K22","v":"1900-01-11"},null,{"$f":"'Time Record'!L22:M22","v":"1900-01-12"},null,{"$f":"'Time Record'!N22:O22","v":"1900-01-13"}]
[null,"THURSDAY",null,"FRIDAY",null,"SATURDAY",null,"SUNDAY",null,"MONDAY",null,"TUESDAY",null,"WEDNESDAY"]
["Pgm Hrs",{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"$I$2","v":"GHT-OP"},null,{"$f":"C30+E30+G30+I30+K30+M30+O30","v":0}]
["Pgm Hrs",{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"$I$3","v":"GHT-VR"},null,{"$f":"C31+E31+G31+I31+K31+M31+O31","v":0}]
["Pgm Hrs",{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,{"$f":"$I$4","v":"GHT-FA"},null,0]
["Pgm Hrs",{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,{"$f":"$I$5","v":"WFD-NS"},null,0]
["Pgm Hrs",{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"$I$6","v":"WFD-MH"},null,{"$f":"C34+E34+G34+I34+K34+M34+O34","v":0}]
["Pgm Hrs",{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,{"$f":"$I$7","v":"WFD-YO"},null,0]
["Pgm Hrs",{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"$I$8","v":"WFD-NP"},null,{"$f":"C36+E36+G36+I36+K36+M36+O36","v":0}]
["Total Pgm Dir Hrs",null,{"$f":"SUM(C30:C36)","v":"00:00:00"},null,{"$f":"SUM(E30:E36)","v":"00:00:00"},null,{"$f":"SUM(G30:G36)","v":"00:00:00"},null,{"$f":"SUM(I30:I36)","v":"00:00:00"},null,{"$f":"SUM(K30:K36)","v":"00:00:00"},null,{"$f":"SUM(M30:M36)","v":"00:00:00"},null,{"$f":"SUM(O30:O36)","v":"00:00:00"},{"$f":"SUM(C37:O37)","v":0}]
[{"$f":"'Time Record'!A29","v":"Jury Duty/Spec"},null,{"$f":"'Time Record'!B29","v":"00:00:00"},null,{"$f":"'Time Record'!D29","v":"00:00:00"},null,{"$f":"'Time Record'!F29","v":"00:00:00"},null,{"$f":"'Time Record'!H29","v":"00:00:00"},null,{"$f":"'Time Record'!J29","v":"00:00:00"},null,{"$f":"'Time Record'!L29","v":"00:00:00"},null,{"$f":"'Time Record'!N29","v":"00:00:00"},{"$f":"SUM(C38:O38)","v":0}]
[{"$f":"'Time Record'!A30","v":"Holiday Hrs"},null,{"$f":"'Time Record'!B30","v":"00:00:00"},null,{"$f":"'Time Record'!D30","v":"00:00:00"},null,{"$f":"'Time Record'!F30","v":"00:00:00"},null,{"$f":"'Time Record'!H30","v":"00:00:00"},null,{"$f":"'Time Record'!J30","v":"00:00:00"},null,{"$f":"'Time Record'!L30","v":"00:00:00"},null,{"$f":"'Time Record'!N30","v":"00:00:00"},0]
[{"$f":"'Time Record'!A31","v":"PTO"},null,{"$f":"'Time Record'!B31","v":"00:00:00"},null,{"$f":"'Time Record'!D31","v":"00:00:00"},null,{"$f":"'Time Record'!F31","v":"00:00:00"},null,{"$f":"'Time Record'!H31","v":"00:00:00"},null,{"$f":"'Time Record'!J31","v":"00:00:00"},null,{"$f":"'Time Record'!L31","v":"00:00:00"},null,{"$f":"'Time Record'!N31","v":"00:00:00"},0]
["Hrs from Timesheet",null,{"$f":"'Time Record'!B33","v":"00:00:00"},null,{"$f":"'Time Record'!D33","v":"00:00:00"},null,{"$f":"'Time Record'!F33","v":"00:00:00"},null,{"$f":"'Time Record'!H33","v":"00:00:00"},null,{"$f":"'Time Record'!J33","v":"00:00:00"},null,{"$f":"'Time Record'!L33","v":"00:00:00"},null,{"$f":"'Time Record'!N33","v":"00:00:00"},0]
["Ovr/Under Error",null,{"$f":"SUM(C37:C40)-C41","v":"00:00:00"},null,{"$f":"SUM(E37:E40)-E41","v":"00:00:00"},null,{"$f":"SUM(G37:G40)-G41","v":"00:00:00"},null,{"$f":"SUM(I37:I40)-I41","v":"00:00:00"},null,{"$f":"SUM(K37:K40)-K41","v":"00:00:00"},null,{"$f":"SUM(M37:M40)-M41","v":"00:00:00"},null,{"$f":"SUM(O37:O40)-O41","v":"00:00:00"},0]
[]
[]
[]
[null,null,"Employee Signature:",null,null,null,null,null,null,null,null,null,"Date:",null,null,{"$f":"P23+P41","v":0}]
[null,null,"Supervisor Signature:",null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[]
[]
[]
[{"$f":"'Pay Period Schedule'!A4","v":"2013-02-07"}]
[{"$f":"'Pay Period Schedule'!A5","v":"2013-02-21"}]
[{"$f":"'Pay Period Schedule'!A6","v":"2013-03-07"}]
[{"$f":"'Pay Period Schedule'!A7","v":"2013-03-21"}]
[{"$f":"'Pay Period Schedule'!A8","v":"2013-04-04"}]
[{"$f":"'Pay Period Schedule'!A9","v":"2013-04-18"}]
[{"$f":"'Pay Period Schedule'!A10","v":"2013-05-02"}]
[{"$f":"'Pay Period Schedule'!A11","v":"2013-05-16"}]
[{"$f":"'Pay Period Schedule'!A12","v":"2013-05-30"}]
[{"$f":"'Pay Period Schedule'!A13","v":"2013-06-13"}]
[{"$f":"'Pay Period Schedule'!A14","v":"2013-06-27"}]
[{"$f":"'Pay Period Schedule'!A15","v":"2013-07-11"}]
[{"$f":"'Pay Period Schedule'!A16","v":"2013-07-25"}]
[{"$f":"'Pay Period Schedule'!A17","v":"2013-08-08"}]
[{"$f":"'Pay Period Schedule'!A18","v":"2013-08-22"}]
[{"$f":"'Pay Period Schedule'!A19","v":"2013-09-05"}]
[{"$f":"'Pay Period Schedule'!A20","v":"2013-09-19"}]
[{"$f":"'Pay Period Schedule'!A21","v":"2013-10-03"}]
[{"$f":"'Pay Period Schedule'!A22","v":"2013-10-17"}]
[{"$f":"'Pay Period Schedule'!A23","v":"2013-10-31"}]
[{"$f":"'Pay Period Schedule'!A24","v":"2013-11-14"}]
[{"$f":"'Pay Period Schedule'!A25","v":"2013-11-28"}]
[{"$f":"'Pay Period Schedule'!A26","v":"2013-12-12"}]
[{"$f":"'Pay Period Schedule'!A27","v":"2013-12-26"}]
[{"$f":"'Pay Period Schedule'!A28","v":"2014-01-09"}]
[{"$f":"'Pay Period Schedule'!A29","v":"2014-01-23"}]
[{"$f":"'Pay Period Schedule'!A30","v":"2014-02-06"}]

{"sheet":"Pay Period Schedule","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Pay Periods - Guinn Healthcare Technologies - 2013"]
["Period Begin","Begin Wk 2","Period End","Payday"]
["Thursday","Thursday","Wednesday","Tuesday"]
["2013-02-07","2013-02-14","2013-02-20","2013-02-26"]
[{"$f":"A4+14","v":"2013-02-21"},{"$f":"B4+14","v":"2013-02-28"},{"$f":"C4+14","v":"2013-03-06"},{"$f":"D4+14","v":"2013-03-12"}]
[{"$f":"A5+14","v":"2013-03-07"},{"$f":"B5+14","v":"2013-03-14"},{"$f":"C5+14","v":"2013-03-20"},{"$f":"D5+14","v":"2013-03-26"}]
["2013-03-21","2013-03-28","2013-04-03","2013-04-09"]
["2013-04-04","2013-04-11","2013-04-17","2013-04-23"]
["2013-04-18","2013-04-25","2013-05-01","2013-05-07"]
["2013-05-02","2013-05-09","2013-05-15","2013-05-21"]
["2013-05-16","2013-05-23","2013-05-29","2013-06-04"]
["2013-05-30","2013-06-06","2013-06-12","2013-06-18"]
["2013-06-13","2013-06-20","2013-06-26","2013-07-02"]
["2013-06-27","2013-07-04","2013-07-10","2013-07-16"]
["2013-07-11","2013-07-18","2013-07-24","2013-07-30"]
["2013-07-25","2013-08-01","2013-08-07","2013-08-13"]
["2013-08-08","2013-08-15","2013-08-21","2013-08-27"]
["2013-08-22","2013-08-29","2013-09-04","2013-09-10"]
["2013-09-05","2013-09-12","2013-09-18","2013-09-24"]
["2013-09-19","2013-09-26","2013-10-02","2013-10-08"]
["2013-10-03","2013-10-10","2013-10-16","2013-10-22"]
["2013-10-17","2013-10-24","2013-10-30","2013-11-05"]
["2013-10-31","2013-11-07","2013-11-13","2013-11-19"]
["2013-11-14","2013-11-21","2013-11-27","2013-12-03"]
["2013-11-28","2013-12-05","2013-12-11","2013-12-17"]
["2013-12-12","2013-12-19","2013-12-25","2013-12-31"]
["2013-12-26","2014-01-02","2014-01-08","2014-01-14"]
["2014-01-09","2014-01-16","2014-01-22","2014-01-28"]
["2014-01-23","2014-01-30","2014-02-05","2014-02-11"]
["2014-02-06","2014-02-13","2014-02-19","2014-02-25"]
["2014-02-20","2014-02-27","2014-03-05","2014-03-11"]
["2014-03-06","2014-03-13","2014-03-19","2014-03-25"]
["2014-03-20","2014-03-27","2014-04-02","2014-04-08"]
["2014-04-03","2014-04-10","2014-04-16","2014-04-22"]
["2014-04-17","2014-04-24","2014-04-30","2014-05-06"]
["2014-05-01","2014-05-08","2014-05-14","2014-05-20"]
["2014-05-15","2014-05-22","2014-05-28","2014-06-03"]
["2014-05-29","2014-06-05","2014-06-11","2014-06-17"]

{"sheet":"Time Off Request - Calculated","index":3,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4],[30,3,30,6],[35,1,35,6],[4,1,4,2],[4,3,4,4],[6,1,6,6],[31,3,31,6],[32,3,32,6],[33,3,33,4]]}
[null,null,null,null,null,"Tot # Hrs"]
[null,"Employee Name:",null,{"$f":"'Time Record'!B4","v":"Your Name Here"},null,"06:45:00","(PTO) Vacation"]
[null,"Employee Number:",null,{"$f":"'Time Record'!B5","v":"XX222222"},null,{"$f":"SUMIF($G$10:$G$29,$G3,$F$10:$F$29)","v":"00:00:00"}]
[null,null,null,null,null,{"$f":"SUMIF($G$10:$G$29,$G4,$F$10:$F$29)","v":"00:00:00"},"(UPTO) Unpaid"]
[null,"Date of request:",null,null,null,{"$f":"SUMIF($G$10:$G$29,$G5,$F$10:$F$29)","v":"00:00:00"},"(JDTO) Jury"]
[]
[null,"I am requesting time off on the following days and times"]
[]
[null,"Date:","Day of Week","Time Begin","Time End","# of Hours","Type of Time Requested"]
[null,null,null,null,null,{"$f":"E10-D10","v":"00:00:00"}]
[null,null,null,null,null,{"$f":"E11-D11","v":"00:00:00"}]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,"00:00:00"]
[]
[null,"Requestor Signature"]
[null,"Approval Signature/Title: "]
[]
[null,"Approval Date:"]
[]
[null,"Complete the time off request and submit to supervisor for approval no later than 10 working days before requested time off.  In the event of time off due to sickness or other unusual circumstances, inform the supervisor of your absence immediately and submit request form to the supervisor at the first available opportunity."]

{"sheet":"Time Off Request - Blank","index":4,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4],[30,3,30,6],[35,1,35,6],[4,1,4,2],[4,3,4,4],[6,1,6,6],[31,3,31,6],[32,3,32,6],[33,3,33,4]]}
[null,null,null,null,null,"Tot # Hrs"]
[null,"Employee Name:",null,{"$f":"'Time Record'!B4","v":"Your Name Here"},null,null,"(PTO) Vacation"]
[null,"Employee Number:",null,{"$f":"'Time Record'!B5","v":"XX222222"},null,null,"(PTO) Sick"]
[null,null,null,null,null,null,"(UPTO) Unpaid"]
[null,"Date of request:",null,null,null,null,"(JDTO) Jury"]
[]
[null,"I am requesting time off on the following days and times"]
[]
[null,"Date:","Day of Week","Time Begin","Time End","# of Hours","Type of Time Requested"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Requestor Signature"]
[null,"Approval Signature/Title: "]
[]
[null,"Approval Date:"]
[]
[null,"Complete the time off request and submit to supervisor for approval no later than 10 working days before requested time off.  In the event of time off due to sickness or other unusual circumstances, inform the supervisor of your absence immediately and submit request form to the supervisor at the first available opportunity."]