{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Timesheet"],"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":"Instructions","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions: "]
[null,"Create a new sheet each month - save this template to use as a base"]
[null,"Enter your name at the top of the Timesheet"]
[null,"Use \"24 hour clock notation\", so 4:00 in the afternoon is entered as \"16:00\""]
[null,"You can have mulitple entries in a day - the daily total is calculated via a fairly complex formula in column J"]
[null,"Add more rows if you need to during the month"]
[null,"Use the dropdown list in the Category column to select your time category"]
[null,"The categories are defined at the bottom of the page - we can easily add new ones. "]
[]
[null,"Call me if you have any questions…"]
[]
[]
[null,"SAVE YOUR WORK AFTER EVERY ENTRY!"]

{"sheet":"Timesheet","index":1,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[12,2,12,4],[61,2,61,4],[50,2,50,4],[51,2,51,4],[52,2,52,4],[55,2,55,4],[58,2,58,4],[59,2,59,4],[60,2,60,4],[57,2,57,4],[56,2,56,4],[34,2,34,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[38,2,38,4],[49,2,49,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[30,2,30,4],[48,2,48,4],[54,2,54,4],[13,21,13,22],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[39,2,39,4],[27,2,27,4],[28,2,28,4],[24,2,24,4],[22,2,22,4],[18,20,18,24],[19,20,19,24],[20,20,20,24],[62,2,62,4],[63,2,63,4],[53,2,53,4],[25,2,25,4],[26,2,26,4],[29,2,29,4],[36,2,36,4],[37,2,37,4],[19,2,19,4],[21,2,21,4],[23,2,23,4],[7,21,7,22],[8,21,11,24],[9,2,9,3],[10,2,10,3],[11,2,11,3],[21,20,21,24],[22,20,22,24],[23,20,23,24],[24,20,24,24],[67,1,67,2],[14,21,15,24],[15,4,15,5],[17,20,17,24],[18,2,18,4],[35,2,35,4],[29,20,29,24],[30,20,30,24],[31,20,31,24],[32,20,32,24],[25,20,25,24],[26,20,26,24],[27,20,27,24],[28,20,28,24],[37,20,37,24],[38,20,38,24],[39,20,39,24],[40,20,40,24],[33,20,33,24],[34,20,34,24],[35,20,35,24],[36,20,36,24],[45,20,45,24],[46,20,46,24],[47,20,47,24],[48,20,48,24],[41,20,41,24],[42,20,42,24],[43,20,43,24],[44,20,44,24],[53,20,53,24],[54,20,54,24],[55,20,55,24],[56,20,56,24],[49,20,49,24],[50,20,50,24],[51,20,51,24],[52,20,52,24]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIMECARD"]
[]
[]
[null,"Employee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous"]
[]
[null,"Name","<Name>"]
[null,"Position","<Position>",null,null,"SSN"]
[]
[null,"Timesheet for ","<Name>"]
[]
[]
[null,"From: ","2013-01-01","To","2013-01-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7]
[null,"Date","Task",null,null,"Begin Time","End Time","Actual Hours","Decimal","Daily Total",null,"Category",{"$f":"OFFSET(Categories,M17,0)","v":"Category 1"},{"$f":"OFFSET(Categories,N17,0)","v":"Category 2"},{"$f":"OFFSET(Categories,O17,0)","v":"Category 3"},{"$f":"OFFSET(Categories,P17,0)","v":"Category 4"},{"$f":"OFFSET(Categories,Q17,0)","v":"Category 5"},{"$f":"OFFSET(Categories,R17,0)","v":"Category 6"},{"$f":"OFFSET(Categories,S17,0)","v":"Other"},"Check","Notes","Notes"]
[null,"1/1/13","Description",null,null,"08:00:00","08:06:00",{"$f":"IF(G19<>\" \",G19-F19,0)","v":"00:06:00"},{"$f":"VALUE(HOUR(H19)+VALUE(MINUTE(H19))/60)","v":0.1},{"$f":"IF(B19=B20,0,SUMIF(B$18:B$64,B19,I$18:I$64))","v":0.1},null,"Select Investor",{"$f":"IF($L19=M$18,$I19,0)","v":0},{"$f":"IF($L19=N$18,$I19,0)","v":0},{"$f":"IF($L19=O$18,$I19,0)","v":0},{"$f":"IF($L19=P$18,$I19,0)","v":0},{"$f":"IF($L19=Q$18,$I19,0)","v":0},null,null,{"$f":"SUM(M19:S19)-I19","v":-0.1}]
[null,null,null,null,null," "," ",{"$f":"IF(G20<>\" \",G20-F20,0)","v":"00:00:00"},0,0,null,null,null,{"$f":"$I20","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I34","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I35","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I36","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I37","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I38","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,null,null,null,{"$f":"$I39","v":0},null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I40","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I41","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I42","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ",{"$f":"IF(G43<>\" \",G43-F43,0)","v":"00:00:00"},0,0,null,null,null,{"$f":"$I43","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I44","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,null,null,null,{"$f":"$I45","v":0},null,null,0]
[null,null,null,null,null,null," ","00:00:00",{"$f":"VALUE(HOUR(H46)+VALUE(MINUTE(H46))/60)","v":0},0,null,null,null,{"$f":"$I46","v":0},null,null,null,null,null,{"$f":"SUM(M46:S46)-I46","v":0}]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I47","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,null,null,null,{"$f":"$I48","v":0},null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,{"$f":"$I49","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,{"$f":"SUM(M51:S51)-I51","v":0}]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,0,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",0,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,null,null,null," ","00:00:00",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M59:S59)-I59","v":0}]
[null,null,null,null,null,null," ","00:00:00",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B63=B64,0,SUMIF(B$18:B$64,B63,I$18:I$64))","v":0},null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"Total Hours",null,null,{"$f":"SUM(I19:I64)","v":0.1},{"$f":"SUM(J19:J64)","v":0.1},null,null,{"$f":"SUM(M19:M64)","v":0},{"$f":"SUM(N19:N64)","v":0},0,0,0,0,0,-0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M65/$I65","v":0},0,0,0,0,0]
[]
[null,"Notes and Remarks"]
[]
[]
[]
[null,"Categories"]
[null,"Category 1"]
[null,"Category 2"]
[null,"Category 3"]
[null,"Category 4"]
[null,"Category 5"]
[null,"Category 6"]
[null,"Other"]