{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Weekly Timesheet","Weekly Timesheet BLANK"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Weekly Timesheet","index":0,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,12,3,12],[11,1,11,3],[12,1,12,3],[13,1,13,3],[1,2,1,5],[1,7,1,10],[15,1,15,10]]}
[null,"WEEKLY TIMESHEET TEMPLATE"]
[null,"Employee:",null,null,null,null,"Week of:","2019-07-01",null,null,null,null,"<---- ENTER DATE OF FIRST DAY OF PAY PERIOD; TIMESHEET WILL POPULATE AUTOMATICALLY."]
[]
[null,"DATE","START TIME","FINISH TIME","REGULAR HRS","OVERTIME HRS","SICK","VACATION","HOLIDAY","OTHER","TOTAL HOURS"]
[null,{"$f":"H2","v":"2019-07-01"},"08:00:00","17:00:00",8,1,null,null,null,null,{"$f":"SUM(E5:J5)","v":9}]
[null,{"$f":"H2+1","v":"2019-07-02"},null,null,null,null,null,null,null,8,8]
[null,{"$f":"H2+2","v":"2019-07-03"},"08:00:00","16:00:00",8,null,null,null,null,null,8]
[null,{"$f":"H2+3","v":"2019-07-04"},"08:00:00","16:00:00",8,null,null,null,null,null,8]
[null,{"$f":"H2+4","v":"2019-07-05"},"08:00:00","18:00:00",8,2,null,null,null,null,10]
[null,{"$f":"H2+5","v":"2019-07-06"},null,null,null,null,null,null,null,null,0]
[null,{"$f":"H2+6","v":"2019-07-07"},null,null,null,null,null,null,null,null,0]
[null,"TOTAL HOURS",null,null,{"$f":"SUM(E5:E11)","v":32},{"$f":"SUM(F5:F11)","v":3},0,0,0,8,43]
[null,"RATE PER HOUR",null,null,20,30,20,20,20,20]
[null,"TOTAL PAY",null,null,{"$f":"E13*E12","v":640},90,0,0,0,160,{"$f":"SUM(E14:J14)","v":890}]
[]
[null,"CLICK HERE TO CREATE WEEKLY TIMESHEET TEMPLATES IN SMARTSHEET"]

{"sheet":"Weekly Timesheet BLANK","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,3],[1,12,3,12],[1,2,1,5],[1,7,1,10],[11,1,11,3],[12,1,12,3]]}
[null,"WEEKLY TIMESHEET TEMPLATE"]
[null,"Employee:",null,null,null,null,"Week of:",null,null,null,null,null,"<---- ENTER DATE OF FIRST DAY OF PAY PERIOD; TIMESHEET WILL POPULATE AUTOMATICALLY."]
[]
[null,"DATE","START TIME","FINISH TIME","REGULAR HRS","OVERTIME HRS","SICK","VACATION","HOLIDAY","OTHER","TOTAL HOURS"]
[null,{"$f":"H2","v":"00:00:00"},null,null,null,null,null,null,null,null,{"$f":"SUM(E5:J5)","v":0}]
[null,{"$f":"H2+1","v":"1900-01-01"},null,null,null,null,null,null,null,null,0]
[null,{"$f":"H2+2","v":"1900-01-02"},null,null,null,null,null,null,null,null,0]
[null,{"$f":"H2+3","v":"1900-01-03"},null,null,null,null,null,null,null,null,0]
[null,{"$f":"H2+4","v":"1900-01-04"},null,null,null,null,null,null,null,null,0]
[null,{"$f":"H2+5","v":"1900-01-05"},null,null,null,null,null,null,null,null,0]
[null,{"$f":"H2+6","v":"1900-01-06"},null,null,null,null,null,null,null,null,0]
[null,"TOTAL HOURS",null,null,{"$f":"SUM(E5:E11)","v":0},{"$f":"SUM(F5:F11)","v":0},0,0,0,0,0]
[null,"RATE PER HOUR",null,null,0,0,0,0,0,0]
[null,"TOTAL PAY",null,null,{"$f":"E13*E12","v":0},0,0,0,0,0,{"$f":"SUM(E14:J14)","v":0}]