{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,0,47,1],[53,7,53,8],[9,0,9,1],[10,0,10,1],[18,0,18,1],[19,0,19,1],[46,0,46,1],[27,0,27,1],[28,0,28,1],[36,0,36,1],[37,0,37,1],[45,0,45,1],[11,0,11,1],[20,0,20,1],[29,0,29,1],[38,0,38,1],[21,0,21,1],[21,2,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[1,3,1,11],[3,0,3,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[2,8,2,9],[2,10,2,11],[3,10,3,11],[2,12,2,13],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[21,10,21,11],[21,12,21,13],[12,10,12,11],[12,12,12,13],[3,12,3,13],[39,10,39,11],[39,12,39,13],[0,3,0,6],[48,7,48,12],[39,0,39,1],[39,2,39,3],[39,4,39,5],[39,6,39,7],[39,8,39,9],[1,12,1,13],[30,10,30,11],[30,12,30,13],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7]]}
["Name",null,null,"Title:"]
[null,null,null,"TBR Monthly Time Sheet",null,null,null,null,null,null,null,null,"Total Time",null,{"$f":"P6+P15+P24+P33+P42","v":0}]
["Sunday",null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday"]
["2012-01-29",null,{"$f":"A4+DAY(1)","v":"2012-01-30"},null,{"$f":"C4+DAY(1)","v":"2012-01-31"},null,{"$f":"E4+DAY(1)","v":"2012-02-01"},null,{"$f":"G4+DAY(1)","v":"2012-02-02"},null,{"$f":"I4+DAY(1)","v":"2012-02-03"},null,{"$f":"K4+DAY(1)","v":"2012-02-04"},null,"Total","Time"]
["In","Out","In","Out","In","Out","In","Out","In ","Out","In","Out","In","Out","Hrs:Min","Elapased"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B9+D9+F9+H9+J9+L9+N9","v":0},{"$f":"(O6-INT(P9))*24","v":0}]
[]
[]
["Total",{"$f":"TEXT((B6-A6)+(B7-A7)+(B8-A8),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((D6-C6)+(D7-C7)+(D8-C8),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((F6-E6)+(F7-E7)+(F8-E8),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((H6-G6)+(H7-G7)+(H8-G8),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((J6-I6)+(J7-I7)+(J8-I8),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((L6-K6)+(L7-K7)+(L8-K8),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((N6-M6)+(N7-M7)+(N8-M8),\"h:mm\")","v":"0:00"}]
["Sick Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10+F10+H10+J10+L10+N10","v":0}]
["Annual Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D11+F11+H11+J11+L11+N11","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D12+F12+H12+J12+L12+N12","v":0}]
[{"$f":"M4+1","v":"2012-02-05"},null,{"$f":"A13+1","v":"2012-02-06"},null,{"$f":"C13+1","v":"2012-02-07"},null,{"$f":"E13+1","v":"2012-02-08"},null,{"$f":"G13+1","v":"2012-02-09"},null,{"$f":"I13+1","v":"2012-02-10"},null,{"$f":"K13+1","v":"2012-02-11"},null,"Total","Time"]
["In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","Hrs:Min","Elapased"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B18+D18+F18+H18+J18+L18+N18","v":0},{"$f":"(O15-INT(P18))*24","v":0}]
[]
[]
["Total",{"$f":"TEXT((B15-A15)+(B16-A16)+(B17-A17),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((D15-C15)+(D16-C16)+(D17-C17),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((F15-E15)+(F16-E16)+(F17-E17),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((H15-G15)+(H16-G16)+(H17-G17),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((J15-I15)+(J16-I16)+(J17-I17),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((L15-K15)+(L16-K16)+(L17-K17),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((N15-M15)+(N16-M16)+(N17-M17),\"h:mm\")","v":"0:00"}]
["Sick Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D19+F19+H19+J19+L19+N19","v":0}]
["Annual Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D20+F20+H20+J20+L20+N20","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D21+F21+H21+J21+L21+N21","v":0}]
[{"$f":"M13+1","v":"2012-02-12"},null,{"$f":"A22+1","v":"2012-02-13"},null,{"$f":"C22+1","v":"2012-02-14"},null,{"$f":"E22+1","v":"2012-02-15"},null,{"$f":"G22+1","v":"2012-02-16"},null,{"$f":"I22+1","v":"2012-02-17"},null,{"$f":"K22+1","v":"2012-02-18"},null,"Total","Time"]
["In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","Hrs:Min","Elapased"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B27+D27+F27+H27+J27+L27+N27","v":0},{"$f":"(O24-INT(P27))*24","v":0}]
[]
[]
["Total",{"$f":"TEXT((B24-A24)+(B25-A25)+(B26-A26),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((D24-C24)+(D25-C25)+(D26-C26),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((F24-E24)+(F25-E25)+(F26-E26),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((H24-G24)+(H25-G25)+(H26-G26),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((J24-I24)+(J25-I25)+(J26-I26),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((L24-K24)+(L25-K25)+(L26-K26),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((N24-M24)+(N25-M25)+(N26-M26),\"h:mm\")","v":"0:00"}]
["Sick Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D28+F28+H28+J28+L28+N28","v":0}]
["Annual Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D29+F29+H29+J29+L29+N29","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D30+F30+H30+J30+L30+N30","v":0}]
[{"$f":"M22+1","v":"2012-02-19"},null,{"$f":"A31+1","v":"2012-02-20"},null,{"$f":"C31+1","v":"2012-02-21"},null,{"$f":"E31+1","v":"2012-02-22"},null,{"$f":"G31+1","v":"2012-02-23"},null,{"$f":"I31+1","v":"2012-02-24"},null,{"$f":"K31+1","v":"2012-02-25"},null,"Total","Time"]
["In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","Hrs:Min","Elapased"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B36+D36+F36+H36+J36+L36+N36","v":0},{"$f":"(O33-INT(P36))*24","v":0}]
[]
[]
["Total",{"$f":"TEXT((B33-A33)+(B34-A34)+(B35-A35),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((D33-C33)+(D34-C34)+(D35-C35),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((F33-E33)+(F34-E34)+(F35-E35),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((H33-G33)+(H34-G34)+(H35-G35),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((J33-I33)+(J34-I34)+(J35-I35),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((L33-K33)+(L34-K34)+(L35-K35),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((N33-M33)+(N34-M34)+(N35-M35),\"h:mm\")","v":"0:00"}]
["Sick Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D37+F37+H37+J37+L37+N37","v":0}]
["Annual Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D38+F38+H38+J38+L38+N38","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D39+F39+H39+J39+L39+N39","v":0}]
[{"$f":"M31+1","v":"2012-02-26"},null,{"$f":"A40+1","v":"2012-02-27"},null,{"$f":"C40+1","v":"2012-02-28"},null,{"$f":"E40+1","v":"2012-02-29"},null,{"$f":"G40+1","v":"2012-03-01"},null,{"$f":"I40+1","v":"2012-03-02"},null,{"$f":"K40+1","v":"2012-03-03"},null,"Total","Time"]
["In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","In","Out","Hrs:Min","Elapased"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B45+D45+F45+H45+J45+L45+N45","v":0},{"$f":"(O42-INT(P45))*24","v":0}]
[]
[]
["Total",{"$f":"TEXT((B42-A42)+(B43-A43)+(B44-A44),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((D42-C42)+(D43-C43)+(D44-C44),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((F42-E42)+(F43-E43)+(F44-E44),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((H42-G42)+(H43-G43)+(H44-G44),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((J42-I42)+(J43-I43)+(J44-I44),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((L42-K42)+(L43-K43)+(L44-K44),\"h:mm\")","v":"0:00"},null,{"$f":"TEXT((N42-M42)+(N43-M43)+(N44-M44),\"h:mm\")","v":"0:00"}]
["Sick Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D46+F46+H46+J46+L46+N46","v":0}]
["Annual Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D47+F47+H47+J47+L47+N47","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D48+F48+H48+J48+L48+N48","v":0}]
[null,null,null,null,null,null,null,"Overtime and Comp Hours",null,null,null,null,null,"Total Annual",null,{"$f":"P47+P38+P29+P20+P11","v":0}]
[null,"Employee Signature :",null,null,null,null,null,null,"OT Hrs","Comp Hrs",null,"OT Hrs","Comp Hrs","Total Sick",null,{"$f":"+P46+P37+P28+P19+P10","v":0}]
[null,null,null,null,null,null,null,"Wk 1",{"$f":"IF(P6<=40,\"0\",P6-40)","v":"0"},{"$f":"IF(P6>=40, 2.5, IF(P6<=37.5, \"0\", P6-37.5))","v":"0"},"Wk 4",{"$f":"IF(P33<=40,\"0\",P33-40)","v":"0"},{"$f":"IF(P33>=40, 2.5, IF(P33<=37.5, \"0\", P33-37.5))","v":"0"},"Total Other",null,{"$f":"P48+P39+P30+P21+P12","v":0}]
[null,"Supervisor Signature :",null,null,null,null,null,"Wk 2",{"$f":"IF(P15<=40,\"0\",P15-40)","v":"0"},{"$f":"IF(P15>=40, 2.5, IF(P15<=37.5, \"0\", P15-37.5))","v":"0"},"Wk 5",{"$f":"IF(P42<=40,\"0\",P42-40)","v":"0"},{"$f":"IF(P42>=40, 2.5, IF(P42<=37.5, \"0\", P42-37.5))","v":"0"},"Total Comp",null,{"$f":"M54+J54","v":0}]
[null,null,null,null,null,null,null,"Wk 3",{"$f":"IF(P24<=40,\"0\",P24-40)","v":"0"},{"$f":"IF(P24>=40, 2.5, IF(P24<=37.5, \"0\", P24-37.5))","v":"0"}]
[null,null,null,null,null,null,null,"Total Overtime Hours",null,{"$f":"(I51+I52+I53+L51+L52)*1.5","v":0},"Total Comp Hours",null,{"$f":"J51+J52+J53+M51+M52","v":0}]