{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Biweekly time sheet"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Biweekly time sheet","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[1,1,1,7],[2,1,2,7],[4,2,4,3],[4,6,4,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,2,8,3],[8,6,8,7]]}
[]
[null,"BI-WEEKLY TIME SHEET"]
[null,"Woodgrove Bank"]
[]
[null,"Street address:","432 1st Ave",null,null,"Pay period start date: "]
[null,"Address 2:",{"$nulls":3},"Pay period end date: "]
[null,"City, State ZIP:","Saint Paul, MN 91011"]
[null,"Employee:","Aneela Mohan",null,null,"Employee phone: "]
[null,"Manager:","Gerd Simonsen",null,null,"Employee email: "]
[]
[null,"Day","Date","Regular hours","Overtime hours","Sick","Vacation","Total"]
[null,"Monday",{"$f":"IFERROR(IF($G$5=\"\",\"\",$G$5),\"\")","v":""},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(D12:G12), \"\")","v":{"v":8,"d":"8.00"}}]
[null,"Tuesday",{"$f":"IF($G$5=\"\",\"\",C12+1)","v":""},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(D13:G13), \"\")","v":{"v":8,"d":"8.00"}}]
[null,"Wednesday","",{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,"Thursday","",{"v":8,"d":"8.00"},{"v":2.5,"d":"2.50"},null,null,{"v":10.5,"d":"10.50"}]
[null,"Friday","",{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"v":10,"d":"10.00"}]
[null,"Saturday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"Sunday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"Monday","",{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
[null,"Tuesday","",null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
[null,"Wednesday","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"Thursday","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"Friday","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"Saturday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"Sunday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"Total hours",{"$f":"IFERROR(SUM(D12:D25), \"\")","v":{"v":64,"d":"64.00"}},{"$f":"IFERROR(SUM(E12:E25), \"\")","v":{"v":7.5,"d":"7.50"}},{"$f":"IFERROR(SUM(F12:F25), \"\")","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(SUM(G12:G25), \"\")","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(SUM(H12:H25), \"\")","v":{"v":87.5,"d":"87.50"}}]
[null,null,"Rate per hour",{"v":10,"d":"$10.00"},{"$f":"D27*1.5","v":{"v":15,"d":"$15.00"}},{"$f":"D27","v":{"v":10,"d":"$10.00"}},{"$f":"D27","v":{"v":10,"d":"$10.00"}}]
[null,null,"Total pay",{"$f":"IFERROR(D26*D27, \"\")","v":{"v":640,"d":"$640.00"}},{"$f":"IFERROR(E26*E27, \"\")","v":{"v":112.5,"d":"$112.50"}},{"v":80,"d":"$80.00"},{"v":80,"d":"$80.00"},{"$f":"IFERROR(SUM(D28:G28), \"\")","v":{"v":912.5,"d":"$912.50"}}]
[]
[{"$nulls":3},"Employee signature"]
[]
[{"$nulls":3},"Manager signature"]