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

{"sheet":"Yearly timesheet","index":0,"n_rows":137,"n_cols":15,"rows_kept":137,"merged":[[0,0,0,16],[2,9,2,14],[6,2,37,2],[39,2,70,2],[72,2,103,2],[105,2,136,2]]}
["EMPLOYEE TIMECARD"]
[]
[{"$nulls":4},"Employee name:","Cristi Grau","E-mail:","cristi@example.com",null,"Year to date totals:"]
[]
[{"$nulls":4},"Manager:","Iris Lepik","Phone:","555-0155",null,"Regular hrs:",{"$f":"SUM(F16,F27,F38,F49,F60,F71,F82,F93,F104,F115,F126,F137)","v":0},"Overtime hrs:",{"$f":"SUM(I16,I27,I38,I49,I60,I71,I82,I93,I104,I115,I126,I137)","v":0},"Total:",{"$f":"SUM(K5:M5)","v":0}]
[]
[null,null,"Q1",null,"JANUARY","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,January[Week 1])","v":0},{"$f":"SUBTOTAL(109,January[Overtime])","v":0},{"$f":"SUBTOTAL(109,January[Week 2])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,January[Week 3])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,January[Week 4])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,January[Week 5])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime    ]])","v":0}]
[{"$nulls":4},"Jan. total: Regular hours",{"$f":"SUM(January[[#Totals],[Week 1]],January[[#Totals],[Week 2]],January[[#Totals],[Week 3]],January[[#Totals],[Week 4]],January[[#Totals],[Week 5]])","v":0},"Jan. total: Overtime",null,{"$f":"SUM(January[[#Totals],[Overtime]],January[[#Totals],[Overtime ]],January[[#Totals],[Overtime  ]],January[[#Totals],[Overtime   ]],January[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"FEBRUARY","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,February[Week 1])","v":0},{"$f":"SUBTOTAL(109,February[Overtime])","v":0},{"$f":"SUBTOTAL(109,February[Week 2])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,February[Week 3])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,February[Week 4])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,February[Week 5])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime    ]])","v":0}]
[{"$nulls":4},"Feb. total: Regular hours",{"$f":"SUM(February[[#Totals],[Week 1]],February[[#Totals],[Week 2]],February[[#Totals],[Week 3]],February[[#Totals],[Week 4]],February[[#Totals],[Week 5]])","v":0},"Feb.  total: Overtime",null,{"$f":"SUM(February[[#Totals],[Overtime]],February[[#Totals],[Overtime ]],February[[#Totals],[Overtime  ]],February[[#Totals],[Overtime   ]],February[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"MARCH","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,March[Week 1])","v":0},{"$f":"SUBTOTAL(109,March[Overtime])","v":0},{"$f":"SUBTOTAL(109,March[Week 2])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,March[Week 3])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,March[Week 4])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,March[Week 5])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime    ]])","v":0}]
[{"$nulls":4},"Mar. total: Regular hours",{"$f":"SUM(March[[#Totals],[Week 1]],March[[#Totals],[Week 2]],March[[#Totals],[Week 3]],March[[#Totals],[Week 4]],March[[#Totals],[Week 5]])","v":0},"Mar. total: Overtime",null,{"$f":"SUM(March[[#Totals],[Overtime]],March[[#Totals],[Overtime ]],March[[#Totals],[Overtime  ]],March[[#Totals],[Overtime   ]],March[[#Totals],[Overtime    ]])","v":0}]
[]
[null,null,"Q2",null,"APRIL","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,April[Week 1])","v":0},{"$f":"SUBTOTAL(109,April[Overtime])","v":0},{"$f":"SUBTOTAL(109,April[Week 2])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 3])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 4])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 5])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime    ]])","v":0}]
[{"$nulls":4},"Apr. total: Regular hours",{"$f":"SUM(April[[#Totals],[Week 1]],April[[#Totals],[Week 2]],April[[#Totals],[Week 3]],April[[#Totals],[Week 4]],April[[#Totals],[Week 5]])","v":0},"Apr. total: Overtime",null,{"$f":"SUM(April[[#Totals],[Overtime]],April[[#Totals],[Overtime ]],April[[#Totals],[Overtime  ]],April[[#Totals],[Overtime   ]],April[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"MAY","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,May[Week 1])","v":0},{"$f":"SUBTOTAL(109,May[Overtime])","v":0},{"$f":"SUBTOTAL(109,May[Week 2])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,May[Week 3])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,May[Week 4])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,May[Week 5])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime    ]])","v":0}]
[{"$nulls":4},"May total: Regular hours",{"$f":"SUM(May[[#Totals],[Week 1]],May[[#Totals],[Week 2]],May[[#Totals],[Week 3]],May[[#Totals],[Week 4]],May[[#Totals],[Week 5]])","v":0},"May total: Overtime",null,{"$f":"SUM(May[[#Totals],[Overtime]],May[[#Totals],[Overtime ]],May[[#Totals],[Overtime  ]],May[[#Totals],[Overtime   ]],May[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"JUNE","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,June[Week 1])","v":0},{"$f":"SUBTOTAL(109,June[Overtime])","v":0},{"$f":"SUBTOTAL(109,June[Week 2])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,June[Week 3])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,June[Week 4])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,June[Week 5])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime    ]])","v":0}]
[{"$nulls":4},"June total: Regular hours",{"$f":"SUM(June[[#Totals],[Week 1]],June[[#Totals],[Week 2]],June[[#Totals],[Week 3]],June[[#Totals],[Week 4]],June[[#Totals],[Week 5]])","v":0},"June total: Overtime",null,{"$f":"SUM(June[[#Totals],[Overtime]],June[[#Totals],[Overtime ]],June[[#Totals],[Overtime  ]],June[[#Totals],[Overtime   ]],June[[#Totals],[Overtime    ]])","v":0}]
[]
[null,null,"Q3",null,"JULY","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,July[Week 1])","v":0},{"$f":"SUBTOTAL(109,July[Overtime])","v":0},{"$f":"SUBTOTAL(109,July[Week 2])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,July[Week 3])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,July[Week 4])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,July[Week 5])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime    ]])","v":0}]
[{"$nulls":4},"July total: Regular hours",{"$f":"SUM(July[[#Totals],[Week 1]],July[[#Totals],[Week 2]],July[[#Totals],[Week 3]],July[[#Totals],[Week 4]],July[[#Totals],[Week 5]])","v":0},"July total: Overtime",null,{"$f":"SUM(July[[#Totals],[Overtime]],July[[#Totals],[Overtime ]],July[[#Totals],[Overtime  ]],July[[#Totals],[Overtime   ]],July[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"AUGUST","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,August[Week 1])","v":0},{"$f":"SUBTOTAL(109,August[Overtime])","v":0},{"$f":"SUBTOTAL(109,August[Week 2])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,August[Week 3])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,August[Week 4])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,August[Week 5])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime    ]])","v":0}]
[{"$nulls":4},"Aug. total: Regular hours",{"$f":"SUM(August[[#Totals],[Week 1]],August[[#Totals],[Week 2]],August[[#Totals],[Week 3]],August[[#Totals],[Week 4]],August[[#Totals],[Week 5]])","v":0},"Aug. total: Overtime",null,{"$f":"SUM(August[[#Totals],[Overtime]],August[[#Totals],[Overtime ]],August[[#Totals],[Overtime  ]],August[[#Totals],[Overtime   ]],August[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"SEPTEMBER","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,September[Week 1])","v":0},{"$f":"SUBTOTAL(109,September[Overtime])","v":0},{"$f":"SUBTOTAL(109,September[Week 2])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 3])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 4])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 5])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime    ]])","v":0}]
[{"$nulls":4},"Sept. total: Regular hours",{"$f":"SUM(September[[#Totals],[Week 1]],September[[#Totals],[Week 2]],September[[#Totals],[Week 3]],September[[#Totals],[Week 4]],September[[#Totals],[Week 5]])","v":0},"Sept. total: Overtime",null,{"$f":"SUM(September[[#Totals],[Overtime]],September[[#Totals],[Overtime ]],September[[#Totals],[Overtime  ]],September[[#Totals],[Overtime   ]],September[[#Totals],[Overtime    ]])","v":0}]
[]
[null,null,"Q4",null,"OCTOBER","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,October[Week 1])","v":0},{"$f":"SUBTOTAL(109,October[Overtime])","v":0},{"$f":"SUBTOTAL(109,October[Week 2])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,October[Week 3])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,October[Week 4])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,October[Week 5])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime    ]])","v":0}]
[{"$nulls":4},"Oct. total: Regular hours",{"$f":"SUM(October[[#Totals],[Week 1]],October[[#Totals],[Week 2]],October[[#Totals],[Week 3]],October[[#Totals],[Week 4]],October[[#Totals],[Week 5]])","v":0},"Oct. total: Overtime",null,{"$f":"SUM(October[[#Totals],[Overtime]],October[[#Totals],[Overtime ]],October[[#Totals],[Overtime  ]],October[[#Totals],[Overtime   ]],October[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"NOVEMBER","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,November[Week 1])","v":0},{"$f":"SUBTOTAL(109,November[Overtime])","v":0},{"$f":"SUBTOTAL(109,November[Week 2])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 3])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 4])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 5])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime    ]])","v":0}]
[{"$nulls":4},"Nov. total: Regular hours",{"$f":"SUM(November[[#Totals],[Week 1]],November[[#Totals],[Week 2]],November[[#Totals],[Week 3]],November[[#Totals],[Week 4]],November[[#Totals],[Week 5]])","v":0},"Nov. total: Overtime",null,{"$f":"SUM(November[[#Totals],[Overtime]],November[[#Totals],[Overtime ]],November[[#Totals],[Overtime  ]],November[[#Totals],[Overtime   ]],November[[#Totals],[Overtime    ]])","v":0}]
[]
[{"$nulls":4},"DECEMBER","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,December[Week 1])","v":0},{"$f":"SUBTOTAL(109,December[Overtime])","v":0},{"$f":"SUBTOTAL(105,December[Week 2])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 3])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 4])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 5])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime    ]])","v":0}]
[{"$nulls":4},"Dec. total: Regular hours",{"$f":"SUM(December[[#Totals],[Week 1]],December[[#Totals],[Week 2]],December[[#Totals],[Week 3]],December[[#Totals],[Week 4]],December[[#Totals],[Week 5]])","v":0},"Dec. total: Overtime",null,{"$f":"SUM(December[[#Totals],[Overtime]],December[[#Totals],[Overtime ]],December[[#Totals],[Overtime  ]],December[[#Totals],[Overtime   ]],December[[#Totals],[Overtime    ]])","v":0}]