{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Time Tracking","Pay sheet","Deadlines"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Instructions"]
[]
["(1)","On Time Tracking sheet, enter employee name in cell D3."]
["(2)","On Time Tracking sheet, enter employee's department in cell Q3."]
["(3)","To enter time worked, list in/out times for the given day on the Time Tracking sheet rounded to the nearest 1/4 hour."]
[null,"For example:"]
[null,"On Monday, January 5, 2009 -"]
[null,"Employee started at 8:10 am."]
[null,"Employee left at 12:30 pm."]
[null,"Employee returned at 3:02 pm."]
[null,"Employee left for the day at 5:30 pm."]
[null,null,"Date","Day","In","Out","In","Out","In","Out"]
[null,"Yellow cells indicate where time would be entered:","2009-01-05","Monday","08:15:00","12:30:00","15:00:00","17:30:00"]
[]
[]
[null,"When entering time, you can either use the 24 hour clock or type \"A\" or \"P\" after the time to designate am/pm."]
[null,"For example:"]
[null,"3:30 PM can be entered as \"15:30\" or \"3:30 P\""]
[]
["(4)","If any sick/vacation/holiday time was taken during that day, enter the amount of hours in the appropriate column."]
[null,"For example:"]
[null,"On Monday, January 5, 2009 -"]
[null,"Employee started at 8:10 am"]
[null,"Employee left at 12:30 pm"]
[null,"Employee took 4 hours of vacation time.",null,null,null,null,null,null,null,null,"week"]
[null,null,"Date","Day","In","Out","In","Out","In","Out","Cumulative","ST","OT","Vac","Sick","Hol","Total Hrs"]
[null,"Yellow cells indicate where time would be entered:","2009-01-05","Monday","08:15:00","12:30:00",null,null,null,null,4.25,4.25,0,4,0,0,8.25]
[]
[]
["(5)","Use \"Comments\" section to indicate where employee was working if off-site."]
[]
["(6)","Continue entering time for each day worked."]
[]
["(7)","To report time worked, go to \"Pay Sheet\" tab."]
["(8)","Using the drop down lists in cells C6 and E6, choose the beginning and ending dates of the pay period.  "]
["(9)","The sheet will fill in all of the data that was previously entered in the \"Time Tracking\" sheet."]
["(10)","Employee should print, sign, and provide the sheet to his/her supervisor for approval."]

{"sheet":"Time Tracking","index":1,"n_rows":740,"n_cols":20,"rows_kept":740,"cut":false,"hidden":false,"merged":[[6,3,6,8],[7,3,7,8]]}
["THE MOUNTAINEERS  "]
["Time Sheet - Non Exempt"]
["Name",null,null,"[enter name here]",null,null,null,null,null,null,null,null,null,null,null,"Dept","[enter department here]"]
[]
[]
[]
[null,null,null,"REGULAR HOURS"]
[null,null,null,"Enter time in nearest 1/4 hour segment (i.e., 8:00, 8:15, 8:30, 8:45)",null,null,null,null,null,null,null,"1/4 hrs","week","Regular"]
[null,"Date","Day","In","Out","In","Out","In","Out","Hrs wk'd",null,"worked","Cumulative","Time","Overtime","Sick","Vac","Hol","Total Hrs","Comments"]
[null,"2014-12-26","Friday",null,null,null,null,null,null,{"$f":"HOUR(I10-H10+G10-F10+E10-D10)","v":0},{"$f":"MINUTE(I10-H10+G10-F10+E10-D10)","v":0},{"$f":"IF(K10=15,0.25,IF(K10=30,0.5,IF(K10=45,0.75,0)))","v":0},null,null,null,null,null,null,{"$f":"SUM(N10:R10)","v":0}]
[null,"2014-12-27","Saturday",null,null,null,null,null,null,0,0,0,{"$f":"+M10+J11+L11","v":0},{"$f":"IF(M11>=40,40-SUM(N10:N10),M11-SUM(N10:N10))","v":0},{"$f":"+J11+L11-N11","v":0},null,null,null,0]
[null,"2014-12-28","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J12+L12","v":0},{"$f":"IF(M12>=40,40,M12)","v":0},0,null,null,null,0]
[null,"2014-12-29","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M12+J13+L13","v":0},{"$f":"IF(M13>=40,40-N12,M13-N12)","v":0},0,null,null,null,{"$f":"SUM(N13:R13)","v":0}]
[null,"2014-12-30","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M14>=40,40-SUM(N12:N13),M14-SUM(N12:N13))","v":0},0,null,null,null,{"$f":"SUM(N14:R14)","v":0}]
[null,"2014-12-31","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M15>=40,40-SUM(N12:N14),M15-SUM(N12:N14))","v":0},0,null,null,null,{"$f":"SUM(N15:R15)","v":0}]
[null,"2015-01-01","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M16>=40,40-SUM(N12:N15),M16-SUM(N12:N15))","v":0},0,null,null,null,0]
[null,"2015-01-02","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M17>=40,40-SUM(N12:N16),M17-SUM(N12:N16))","v":0},0,null,null,null,0]
[null,"2015-01-03","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M18>=40,40-SUM(N12:N17),M18-SUM(N12:N17))","v":0},0,null,null,null,0]
[null,"2015-01-04","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J19+L19","v":0},{"$f":"IF(M19>=40,40,M19)","v":0},0,null,null,null,0]
[null,"2015-01-05","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M19+J20+L20","v":0},{"$f":"IF(M20>=40,40-N19,M20-N19)","v":0},0,null,null,null,{"$f":"SUM(N20:R20)","v":0}]
[null,"2015-01-06","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M21>=40,40-SUM(N19:N20),M21-SUM(N19:N20))","v":0},0,null,null,null,{"$f":"SUM(N21:R21)","v":0}]
[null,"2015-01-07","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M22>=40,40-SUM(N19:N21),M22-SUM(N19:N21))","v":0},0,null,null,null,0]
[null,"2015-01-08","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M23>=40,40-SUM(N19:N22),M23-SUM(N19:N22))","v":0},0,null,null,null,0]
[null,"2015-01-09","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M24>=40,40-SUM(N19:N23),M24-SUM(N19:N23))","v":0},0,null,null,null,0]
[null,"2015-01-10","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M25>=40,40-SUM(N19:N24),M25-SUM(N19:N24))","v":0},0,null,null,null,0]
[null,"2015-01-11","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J26+L26","v":0},{"$f":"IF(M26>=40,40,M26)","v":0},0,null,null,null,0]
[null,"2015-01-12","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M26+J27+L27","v":0},{"$f":"IF(M27>=40,40-N26,M27-N26)","v":0},0,null,null,null,{"$f":"SUM(N27:R27)","v":0}]
[null,"2015-01-13","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M28>=40,40-SUM(N26:N27),M28-SUM(N26:N27))","v":0},0,null,null,null,{"$f":"SUM(N28:R28)","v":0}]
[null,"2015-01-14","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M29>=40,40-SUM(N26:N28),M29-SUM(N26:N28))","v":0},0,null,null,null,{"$f":"SUM(N29:R29)","v":0}]
[null,"2015-01-15","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M30>=40,40-SUM(N26:N29),M30-SUM(N26:N29))","v":0},0,null,null,null,0]
[null,"2015-01-16","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M31>=40,40-SUM(N26:N30),M31-SUM(N26:N30))","v":0},0,null,null,null,0]
[null,"2015-01-17","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M32>=40,40-SUM(N26:N31),M32-SUM(N26:N31))","v":0},0,null,null,null,0]
[null,"2015-01-18","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J33+L33","v":0},{"$f":"IF(M33>=40,40,M33)","v":0},0,null,null,null,0]
[null,"2015-01-19","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M33+J34+L34","v":0},{"$f":"IF(M34>=40,40-N33,M34-N33)","v":0},0,null,null,null,{"$f":"SUM(N34:R34)","v":0}]
[null,"2015-01-20","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M35>=40,40-SUM(N33:N34),M35-SUM(N33:N34))","v":0},0,null,null,null,{"$f":"SUM(N35:R35)","v":0}]
[null,"2015-01-21","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M36>=40,40-SUM(N33:N35),M36-SUM(N33:N35))","v":0},0,null,null,null,0]
[null,"2015-01-22","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M37>=40,40-SUM(N33:N36),M37-SUM(N33:N36))","v":0},0,null,null,null,0]
[null,"2015-01-23","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M38>=40,40-SUM(N33:N37),M38-SUM(N33:N37))","v":0},0,null,null,null,0]
[null,"2015-01-24","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M39>=40,40-SUM(N33:N38),M39-SUM(N33:N38))","v":0},0,null,null,null,0]
[null,"2015-01-25","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J40+L40","v":0},{"$f":"IF(M40>=40,40,M40)","v":0},0,null,null,null,0]
[null,"2015-01-26","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M40+J41+L41","v":0},{"$f":"IF(M41>=40,40-N40,M41-N40)","v":0},0,null,null,null,{"$f":"SUM(N41:R41)","v":0}]
[null,"2015-01-27","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M42>=40,40-SUM(N40:N41),M42-SUM(N40:N41))","v":0},0,null,null,null,{"$f":"SUM(N42:R42)","v":0}]
[null,"2015-01-28","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M43>=40,40-SUM(N40:N42),M43-SUM(N40:N42))","v":0},0,null,null,null,{"$f":"SUM(N43:R43)","v":0}]
[null,"2015-01-29","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M44>=40,40-SUM(N40:N43),M44-SUM(N40:N43))","v":0},0,null,null,null,0]
[null,"2015-01-30","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M45>=40,40-SUM(N40:N44),M45-SUM(N40:N44))","v":0},0,null,null,null,0]
[null,"2015-01-31","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M46>=40,40-SUM(N40:N45),M46-SUM(N40:N45))","v":0},0,null,null,null,0]
[null,"2015-02-01","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J47+L47","v":0},{"$f":"IF(M47>=40,40,M47)","v":0},0,null,null,null,0]
[null,"2015-02-02","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M47+J48+L48","v":0},{"$f":"IF(M48>=40,40-N47,M48-N47)","v":0},0,null,null,null,{"$f":"SUM(N48:R48)","v":0}]
[null,"2015-02-03","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M49>=40,40-SUM(N47:N48),M49-SUM(N47:N48))","v":0},0,null,null,null,{"$f":"SUM(N49:R49)","v":0}]
[null,"2015-02-04","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M50>=40,40-SUM(N47:N49),M50-SUM(N47:N49))","v":0},0,null,null,null,0]
[null,"2015-02-05","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M51>=40,40-SUM(N47:N50),M51-SUM(N47:N50))","v":0},0,null,null,null,0]
[null,"2015-02-06","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M52>=40,40-SUM(N47:N51),M52-SUM(N47:N51))","v":0},0,null,null,null,0]
[null,"2015-02-07","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M53>=40,40-SUM(N47:N52),M53-SUM(N47:N52))","v":0},0,null,null,null,0]
[null,"2015-02-08","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J54+L54","v":0},{"$f":"IF(M54>=40,40,M54)","v":0},0,null,null,null,0]
[null,"2015-02-09","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M54+J55+L55","v":0},{"$f":"IF(M55>=40,40-N54,M55-N54)","v":0},0,null,null,null,{"$f":"SUM(N55:R55)","v":0}]
[null,"2015-02-10","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M56>=40,40-SUM(N54:N55),M56-SUM(N54:N55))","v":0},0,null,null,null,{"$f":"SUM(N56:R56)","v":0}]
[null,"2015-02-11","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M57>=40,40-SUM(N54:N56),M57-SUM(N54:N56))","v":0},{"$f":"+J57+L57-N57","v":0},null,null,null,{"$f":"SUM(N57:R57)","v":0}]
[null,"2015-02-12","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M58>=40,40-SUM(N54:N57),M58-SUM(N54:N57))","v":0},0,null,null,null,0]
[null,"2015-02-13","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M59>=40,40-SUM(N54:N58),M59-SUM(N54:N58))","v":0},0,null,null,null,0]
[null,"2015-02-14","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M60>=40,40-SUM(N54:N59),M60-SUM(N54:N59))","v":0},0,null,null,null,0]
[null,"2015-02-15","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J61+L61","v":0},{"$f":"IF(M61>=40,40,M61)","v":0},0,null,null,null,0]
[null,"2015-02-16","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M61+J62+L62","v":0},{"$f":"IF(M62>=40,40-N61,M62-N61)","v":0},0,null,null,null,{"$f":"SUM(N62:R62)","v":0}]
[null,"2015-02-17","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M63>=40,40-SUM(N61:N62),M63-SUM(N61:N62))","v":0},0,null,null,null,{"$f":"SUM(N63:R63)","v":0}]
[null,"2015-02-18","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M64>=40,40-SUM(N61:N63),M64-SUM(N61:N63))","v":0},0,null,null,null,0]
[null,"2015-02-19","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M65>=40,40-SUM(N61:N64),M65-SUM(N61:N64))","v":0},0,null,null,null,0]
[null,"2015-02-20","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M66>=40,40-SUM(N61:N65),M66-SUM(N61:N65))","v":0},0,null,null,null,0]
[null,"2015-02-21","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M67>=40,40-SUM(N61:N66),M67-SUM(N61:N66))","v":0},0,null,null,null,0]
[null,"2015-02-22","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J68+L68","v":0},{"$f":"IF(M68>=40,40,M68)","v":0},0,null,null,null,0]
[null,"2015-02-23","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M68+J69+L69","v":0},{"$f":"IF(M69>=40,40-N68,M69-N68)","v":0},0,null,null,null,{"$f":"SUM(N69:R69)","v":0}]
[null,"2015-02-24","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M70>=40,40-SUM(N68:N69),M70-SUM(N68:N69))","v":0},0,null,null,null,{"$f":"SUM(N70:R70)","v":0}]
[null,"2015-02-25","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M71>=40,40-SUM(N68:N70),M71-SUM(N68:N70))","v":0},0,null,null,null,{"$f":"SUM(N71:R71)","v":0}]
[null,"2015-02-26","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M72>=40,40-SUM(N68:N71),M72-SUM(N68:N71))","v":0},0,null,null,null,0]
[null,"2015-02-27","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M73>=40,40-SUM(N68:N72),M73-SUM(N68:N72))","v":0},0,null,null,null,0]
[null,"2015-02-28","Saturday",null,null,null,null,null,null,{"$f":"HOUR(I74-H74+G74-F74+E74-D74)","v":0},{"$f":"MINUTE(I74-H74+G74-F74+E74-D74)","v":0},{"$f":"IF(K74=15,0.25,IF(K74=30,0.5,IF(K74=45,0.75,0)))","v":0},0,{"$f":"IF(M74>=40,40-SUM(N68:N73),M74-SUM(N68:N73))","v":0},0,null,null,null,0]
[null,"2015-03-01","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J75+L75","v":0},{"$f":"IF(M75>=40,40,M75)","v":0},0,null,null,null,0]
[null,"2015-03-02","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M75+J76+L76","v":0},{"$f":"IF(M76>=40,40-N75,M76-N75)","v":0},0,null,null,null,{"$f":"SUM(N76:R76)","v":0}]
[null,"2015-03-03","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M77>=40,40-SUM(N75:N76),M77-SUM(N75:N76))","v":0},0,null,null,null,{"$f":"SUM(N77:R77)","v":0}]
[null,"2015-03-04","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M78>=40,40-SUM(N75:N77),M78-SUM(N75:N77))","v":0},0,null,null,null,0]
[null,"2015-03-05","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M79>=40,40-SUM(N75:N78),M79-SUM(N75:N78))","v":0},0,null,null,null,0]
[null,"2015-03-06","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M80>=40,40-SUM(N75:N79),M80-SUM(N75:N79))","v":0},0,null,null,null,0]
[null,"2015-03-07","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M81>=40,40-SUM(N75:N80),M81-SUM(N75:N80))","v":0},0,null,null,null,0]
[null,"2015-03-08","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J82+L82","v":0},{"$f":"IF(M82>=40,40,M82)","v":0},0,null,null,null,0]
[null,"2015-03-09","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M82+J83+L83","v":0},{"$f":"IF(M83>=40,40-N82,M83-N82)","v":0},0,null,null,null,{"$f":"SUM(N83:R83)","v":0}]
[null,"2015-03-10","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M84>=40,40-SUM(N82:N83),M84-SUM(N82:N83))","v":0},0,null,null,null,{"$f":"SUM(N84:R84)","v":0}]
[null,"2015-03-11","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M85>=40,40-SUM(N82:N84),M85-SUM(N82:N84))","v":0},0,null,null,null,{"$f":"SUM(N85:R85)","v":0}]
[null,"2015-03-12","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M86>=40,40-SUM(N82:N85),M86-SUM(N82:N85))","v":0},0,null,null,null,0]
[null,"2015-03-13","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M87>=40,40-SUM(N82:N86),M87-SUM(N82:N86))","v":0},0,null,null,null,0]
[null,"2015-03-14","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M88>=40,40-SUM(N82:N87),M88-SUM(N82:N87))","v":0},0,null,null,null,0]
[null,"2015-03-15","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J89+L89","v":0},{"$f":"IF(M89>=40,40,M89)","v":0},0,null,null,null,0]
[null,"2015-03-16","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M89+J90+L90","v":0},{"$f":"IF(M90>=40,40-N89,M90-N89)","v":0},0,null,null,null,{"$f":"SUM(N90:R90)","v":0}]
[null,"2015-03-17","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M91>=40,40-SUM(N89:N90),M91-SUM(N89:N90))","v":0},0,null,null,null,{"$f":"SUM(N91:R91)","v":0}]
[null,"2015-03-18","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M92>=40,40-SUM(N89:N91),M92-SUM(N89:N91))","v":0},0,null,null,null,0]
[null,"2015-03-19","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M93>=40,40-SUM(N89:N92),M93-SUM(N89:N92))","v":0},0,null,null,null,0]
[null,"2015-03-20","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M94>=40,40-SUM(N89:N93),M94-SUM(N89:N93))","v":0},0,null,null,null,0]
[null,"2015-03-21","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M95>=40,40-SUM(N89:N94),M95-SUM(N89:N94))","v":0},0,null,null,null,0]
[null,"2015-03-22","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J96+L96","v":0},{"$f":"IF(M96>=40,40,M96)","v":0},0,null,null,null,0]
[null,"2015-03-23","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M96+J97+L97","v":0},{"$f":"IF(M97>=40,40-N96,M97-N96)","v":0},0,null,null,null,{"$f":"SUM(N97:R97)","v":0}]
[null,"2015-03-24","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M98>=40,40-SUM(N96:N97),M98-SUM(N96:N97))","v":0},0,null,null,null,{"$f":"SUM(N98:R98)","v":0}]
[null,"2015-03-25","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M99>=40,40-SUM(N96:N98),M99-SUM(N96:N98))","v":0},0,null,null,null,{"$f":"SUM(N99:R99)","v":0}]
[null,"2015-03-26","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M100>=40,40-SUM(N96:N99),M100-SUM(N96:N99))","v":0},0,null,null,null,0]
[null,"2015-03-27","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M101>=40,40-SUM(N96:N100),M101-SUM(N96:N100))","v":0},0,null,null,null,0]
[null,"2015-03-28","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M102>=40,40-SUM(N96:N101),M102-SUM(N96:N101))","v":0},0,null,null,null,0]
[null,"2015-03-29","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J103+L103","v":0},{"$f":"IF(M103>=40,40,M103)","v":0},0,null,null,null,0]
[null,"2015-03-30","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M103+J104+L104","v":0},{"$f":"IF(M104>=40,40-N103,M104-N103)","v":0},0,null,null,null,{"$f":"SUM(N104:R104)","v":0}]
[null,"2015-03-31","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M105>=40,40-SUM(N103:N104),M105-SUM(N103:N104))","v":0},0,null,null,null,{"$f":"SUM(N105:R105)","v":0}]
[null,"2015-04-01","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M106>=40,40-SUM(N103:N105),M106-SUM(N103:N105))","v":0},0,null,null,null,0]
[null,"2015-04-02","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M107>=40,40-SUM(N103:N106),M107-SUM(N103:N106))","v":0},0,null,null,null,0]
[null,"2015-04-03","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M108>=40,40-SUM(N103:N107),M108-SUM(N103:N107))","v":0},0,null,null,null,0]
[null,"2015-04-04","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M109>=40,40-SUM(N103:N108),M109-SUM(N103:N108))","v":0},0,null,null,null,0]
[null,"2015-04-05","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J110+L110","v":0},{"$f":"IF(M110>=40,40,M110)","v":0},0,null,null,null,0]
[null,"2015-04-06","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M110+J111+L111","v":0},{"$f":"IF(M111>=40,40-N110,M111-N110)","v":0},0,null,null,null,{"$f":"SUM(N111:R111)","v":0}]
[null,"2015-04-07","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M112>=40,40-SUM(N110:N111),M112-SUM(N110:N111))","v":0},0,null,null,null,{"$f":"SUM(N112:R112)","v":0}]
[null,"2015-04-08","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M113>=40,40-SUM(N110:N112),M113-SUM(N110:N112))","v":0},0,null,null,null,{"$f":"SUM(N113:R113)","v":0}]
[null,"2015-04-09","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M114>=40,40-SUM(N110:N113),M114-SUM(N110:N113))","v":0},0,null,null,null,0]
[null,"2015-04-10","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M115>=40,40-SUM(N110:N114),M115-SUM(N110:N114))","v":0},0,null,null,null,0]
[null,"2015-04-11","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M116>=40,40-SUM(N110:N115),M116-SUM(N110:N115))","v":0},0,null,null,null,0]
[null,"2015-04-12","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J117+L117","v":0},{"$f":"IF(M117>=40,40,M117)","v":0},0,null,null,null,0]
[null,"2015-04-13","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M117+J118+L118","v":0},{"$f":"IF(M118>=40,40-N117,M118-N117)","v":0},0,null,null,null,{"$f":"SUM(N118:R118)","v":0}]
[null,"2015-04-14","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M119>=40,40-SUM(N117:N118),M119-SUM(N117:N118))","v":0},0,null,null,null,{"$f":"SUM(N119:R119)","v":0}]
[null,"2015-04-15","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M120>=40,40-SUM(N117:N119),M120-SUM(N117:N119))","v":0},0,null,null,null,0]
[null,"2015-04-16","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M121>=40,40-SUM(N117:N120),M121-SUM(N117:N120))","v":0},{"$f":"+J121+L121-N121","v":0},null,null,null,0]
[null,"2015-04-17","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M122>=40,40-SUM(N117:N121),M122-SUM(N117:N121))","v":0},0,null,null,null,0]
[null,"2015-04-18","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M123>=40,40-SUM(N117:N122),M123-SUM(N117:N122))","v":0},0,null,null,null,0]
[null,"2015-04-19","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J124+L124","v":0},{"$f":"IF(M124>=40,40,M124)","v":0},0,null,null,null,0]
[null,"2015-04-20","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M124+J125+L125","v":0},{"$f":"IF(M125>=40,40-N124,M125-N124)","v":0},0,null,null,null,{"$f":"SUM(N125:R125)","v":0}]
[null,"2015-04-21","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M126>=40,40-SUM(N124:N125),M126-SUM(N124:N125))","v":0},0,null,null,null,{"$f":"SUM(N126:R126)","v":0}]
[null,"2015-04-22","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M127>=40,40-SUM(N124:N126),M127-SUM(N124:N126))","v":0},0,null,null,null,{"$f":"SUM(N127:R127)","v":0}]
[null,"2015-04-23","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M128>=40,40-SUM(N124:N127),M128-SUM(N124:N127))","v":0},0,null,null,null,0]
[null,"2015-04-24","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M129>=40,40-SUM(N124:N128),M129-SUM(N124:N128))","v":0},0,null,null,null,0]
[null,"2015-04-25","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M130>=40,40-SUM(N124:N129),M130-SUM(N124:N129))","v":0},0,null,null,null,0]
[null,"2015-04-26","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J131+L131","v":0},{"$f":"IF(M131>=40,40,M131)","v":0},0,null,null,null,0]
[null,"2015-04-27","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M131+J132+L132","v":0},{"$f":"IF(M132>=40,40-N131,M132-N131)","v":0},0,null,null,null,{"$f":"SUM(N132:R132)","v":0}]
[null,"2015-04-28","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M133>=40,40-SUM(N131:N132),M133-SUM(N131:N132))","v":0},0,null,null,null,{"$f":"SUM(N133:R133)","v":0}]
[null,"2015-04-29","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M134>=40,40-SUM(N131:N133),M134-SUM(N131:N133))","v":0},0,null,null,null,0]
[null,"2015-04-30","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M135>=40,40-SUM(N131:N134),M135-SUM(N131:N134))","v":0},0,null,null,null,0]
[null,"2015-05-01","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M136>=40,40-SUM(N131:N135),M136-SUM(N131:N135))","v":0},0,null,null,null,0]
[null,"2015-05-02","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M137>=40,40-SUM(N131:N136),M137-SUM(N131:N136))","v":0},0,null,null,null,0]
[null,"2015-05-03","Sunday",null,null,null,null,null,null,{"$f":"HOUR(I138-H138+G138-F138+E138-D138)","v":0},{"$f":"MINUTE(I138-H138+G138-F138+E138-D138)","v":0},{"$f":"IF(K138=15,0.25,IF(K138=30,0.5,IF(K138=45,0.75,0)))","v":0},{"$f":"+J138+L138","v":0},{"$f":"IF(M138>=40,40,M138)","v":0},0,null,null,null,0]
[null,"2015-05-04","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M138+J139+L139","v":0},{"$f":"IF(M139>=40,40-N138,M139-N138)","v":0},0,null,null,null,{"$f":"SUM(N139:R139)","v":0}]
[null,"2015-05-05","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M140>=40,40-SUM(N138:N139),M140-SUM(N138:N139))","v":0},0,null,null,null,{"$f":"SUM(N140:R140)","v":0}]
[null,"2015-05-06","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M141>=40,40-SUM(N138:N140),M141-SUM(N138:N140))","v":0},0,null,null,null,{"$f":"SUM(N141:R141)","v":0}]
[null,"2015-05-07","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M142>=40,40-SUM(N138:N141),M142-SUM(N138:N141))","v":0},0,null,null,null,0]
[null,"2015-05-08","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M143>=40,40-SUM(N138:N142),M143-SUM(N138:N142))","v":0},0,null,null,null,0]
[null,"2015-05-09","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M144>=40,40-SUM(N138:N143),M144-SUM(N138:N143))","v":0},0,null,null,null,0]
[null,"2015-05-10","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J145+L145","v":0},{"$f":"IF(M145>=40,40,M145)","v":0},0,null,null,null,0]
[null,"2015-05-11","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M145+J146+L146","v":0},{"$f":"IF(M146>=40,40-N145,M146-N145)","v":0},0,null,null,null,{"$f":"SUM(N146:R146)","v":0}]
[null,"2015-05-12","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M147>=40,40-SUM(N145:N146),M147-SUM(N145:N146))","v":0},0,null,null,null,{"$f":"SUM(N147:R147)","v":0}]
[null,"2015-05-13","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M148>=40,40-SUM(N145:N147),M148-SUM(N145:N147))","v":0},0,null,null,null,0]
[null,"2015-05-14","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M149>=40,40-SUM(N145:N148),M149-SUM(N145:N148))","v":0},0,null,null,null,0]
[null,"2015-05-15","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M150>=40,40-SUM(N145:N149),M150-SUM(N145:N149))","v":0},0,null,null,null,0]
[null,"2015-05-16","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M151>=40,40-SUM(N145:N150),M151-SUM(N145:N150))","v":0},0,null,null,null,0]
[null,"2015-05-17","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J152+L152","v":0},{"$f":"IF(M152>=40,40,M152)","v":0},0,null,null,null,0]
[null,"2015-05-18","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M152+J153+L153","v":0},{"$f":"IF(M153>=40,40-N152,M153-N152)","v":0},0,null,null,null,{"$f":"SUM(N153:R153)","v":0}]
[null,"2015-05-19","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M154>=40,40-SUM(N152:N153),M154-SUM(N152:N153))","v":0},0,null,null,null,{"$f":"SUM(N154:R154)","v":0}]
[null,"2015-05-20","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M155>=40,40-SUM(N152:N154),M155-SUM(N152:N154))","v":0},0,null,null,null,{"$f":"SUM(N155:R155)","v":0}]
[null,"2015-05-21","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M156>=40,40-SUM(N152:N155),M156-SUM(N152:N155))","v":0},0,null,null,null,0]
[null,"2015-05-22","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M157>=40,40-SUM(N152:N156),M157-SUM(N152:N156))","v":0},0,null,null,null,0]
[null,"2015-05-23","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M158>=40,40-SUM(N152:N157),M158-SUM(N152:N157))","v":0},0,null,null,null,0]
[null,"2015-05-24","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J159+L159","v":0},{"$f":"IF(M159>=40,40,M159)","v":0},0,null,null,null,0]
[null,"2015-05-25","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M159+J160+L160","v":0},{"$f":"IF(M160>=40,40-N159,M160-N159)","v":0},0,null,null,null,{"$f":"SUM(N160:R160)","v":0}]
[null,"2015-05-26","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M161>=40,40-SUM(N159:N160),M161-SUM(N159:N160))","v":0},0,null,null,null,{"$f":"SUM(N161:R161)","v":0}]
[null,"2015-05-27","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M162>=40,40-SUM(N159:N161),M162-SUM(N159:N161))","v":0},0,null,null,null,0]
[null,"2015-05-28","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M163>=40,40-SUM(N159:N162),M163-SUM(N159:N162))","v":0},0,null,null,null,0]
[null,"2015-05-29","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M164>=40,40-SUM(N159:N163),M164-SUM(N159:N163))","v":0},0,null,null,null,0]
[null,"2015-05-30","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M165>=40,40-SUM(N159:N164),M165-SUM(N159:N164))","v":0},0,null,null,null,0]
[null,"2015-05-31","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J166+L166","v":0},{"$f":"IF(M166>=40,40,M166)","v":0},0,null,null,null,0]
[null,"2015-06-01","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M166+J167+L167","v":0},{"$f":"IF(M167>=40,40-N166,M167-N166)","v":0},0,null,null,null,{"$f":"SUM(N167:R167)","v":0}]
[null,"2015-06-02","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M168>=40,40-SUM(N166:N167),M168-SUM(N166:N167))","v":0},0,null,null,null,{"$f":"SUM(N168:R168)","v":0}]
[null,"2015-06-03","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M169>=40,40-SUM(N166:N168),M169-SUM(N166:N168))","v":0},0,null,null,null,{"$f":"SUM(N169:R169)","v":0}]
[null,"2015-06-04","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M170>=40,40-SUM(N166:N169),M170-SUM(N166:N169))","v":0},0,null,null,null,0]
[null,"2015-06-05","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M171>=40,40-SUM(N166:N170),M171-SUM(N166:N170))","v":0},0,null,null,null,0]
[null,"2015-06-06","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M172>=40,40-SUM(N166:N171),M172-SUM(N166:N171))","v":0},0,null,null,null,0]
[null,"2015-06-07","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J173+L173","v":0},{"$f":"IF(M173>=40,40,M173)","v":0},0,null,null,null,0]
[null,"2015-06-08","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M173+J174+L174","v":0},{"$f":"IF(M174>=40,40-N173,M174-N173)","v":0},0,null,null,null,{"$f":"SUM(N174:R174)","v":0}]
[null,"2015-06-09","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M175>=40,40-SUM(N173:N174),M175-SUM(N173:N174))","v":0},0,null,null,null,{"$f":"SUM(N175:R175)","v":0}]
[null,"2015-06-10","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M176>=40,40-SUM(N173:N175),M176-SUM(N173:N175))","v":0},0,null,null,null,0]
[null,"2015-06-11","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M177>=40,40-SUM(N173:N176),M177-SUM(N173:N176))","v":0},0,null,null,null,0]
[null,"2015-06-12","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M178>=40,40-SUM(N173:N177),M178-SUM(N173:N177))","v":0},0,null,null,null,0]
[null,"2015-06-13","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M179>=40,40-SUM(N173:N178),M179-SUM(N173:N178))","v":0},0,null,null,null,0]
[null,"2015-06-14","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J180+L180","v":0},{"$f":"IF(M180>=40,40,M180)","v":0},0,null,null,null,0]
[null,"2015-06-15","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M180+J181+L181","v":0},{"$f":"IF(M181>=40,40-N180,M181-N180)","v":0},0,null,null,null,{"$f":"SUM(N181:R181)","v":0}]
[null,"2015-06-16","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M182>=40,40-SUM(N180:N181),M182-SUM(N180:N181))","v":0},0,null,null,null,{"$f":"SUM(N182:R182)","v":0}]
[null,"2015-06-17","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M183>=40,40-SUM(N180:N182),M183-SUM(N180:N182))","v":0},0,null,null,null,{"$f":"SUM(N183:R183)","v":0}]
[null,"2015-06-18","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M184>=40,40-SUM(N180:N183),M184-SUM(N180:N183))","v":0},0,null,null,null,0]
[null,"2015-06-19","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M185>=40,40-SUM(N180:N184),M185-SUM(N180:N184))","v":0},{"$f":"+J185+L185-N185","v":0},null,null,null,0]
[null,"2015-06-20","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M186>=40,40-SUM(N180:N185),M186-SUM(N180:N185))","v":0},0,null,null,null,0]
[null,"2015-06-21","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J187+L187","v":0},{"$f":"IF(M187>=40,40,M187)","v":0},0,null,null,null,0]
[null,"2015-06-22","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M187+J188+L188","v":0},{"$f":"IF(M188>=40,40-N187,M188-N187)","v":0},0,null,null,null,{"$f":"SUM(N188:R188)","v":0}]
[null,"2015-06-23","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M189>=40,40-SUM(N187:N188),M189-SUM(N187:N188))","v":0},0,null,null,null,{"$f":"SUM(N189:R189)","v":0}]
[null,"2015-06-24","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M190>=40,40-SUM(N187:N189),M190-SUM(N187:N189))","v":0},0,null,null,null,0]
[null,"2015-06-25","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M191>=40,40-SUM(N187:N190),M191-SUM(N187:N190))","v":0},0,null,null,null,0]
[null,"2015-06-26","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M192>=40,40-SUM(N187:N191),M192-SUM(N187:N191))","v":0},0,null,null,null,0]
[null,"2015-06-27","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M193>=40,40-SUM(N187:N192),M193-SUM(N187:N192))","v":0},0,null,null,null,0]
[null,"2015-06-28","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J194+L194","v":0},{"$f":"IF(M194>=40,40,M194)","v":0},0,null,null,null,0]
[null,"2015-06-29","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M194+J195+L195","v":0},{"$f":"IF(M195>=40,40-N194,M195-N194)","v":0},0,null,null,null,{"$f":"SUM(N195:R195)","v":0}]
[null,"2015-06-30","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M196>=40,40-SUM(N194:N195),M196-SUM(N194:N195))","v":0},0,null,null,null,{"$f":"SUM(N196:R196)","v":0}]
[null,"2015-07-01","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M197>=40,40-SUM(N194:N196),M197-SUM(N194:N196))","v":0},0,null,null,null,{"$f":"SUM(N197:R197)","v":0}]
[null,"2015-07-02","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M198>=40,40-SUM(N194:N197),M198-SUM(N194:N197))","v":0},0,null,null,null,0]
[null,"2015-07-03","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M199>=40,40-SUM(N194:N198),M199-SUM(N194:N198))","v":0},0,null,null,null,0]
[null,"2015-07-04","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M200>=40,40-SUM(N194:N199),M200-SUM(N194:N199))","v":0},0,null,null,null,0]
[null,"2015-07-05","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J201+L201","v":0},{"$f":"IF(M201>=40,40,M201)","v":0},0,null,null,null,0]
[null,"2015-07-06","Monday",null,null,null,null,null,null,{"$f":"HOUR(I202-H202+G202-F202+E202-D202)","v":0},{"$f":"MINUTE(I202-H202+G202-F202+E202-D202)","v":0},{"$f":"IF(K202=15,0.25,IF(K202=30,0.5,IF(K202=45,0.75,0)))","v":0},{"$f":"+M201+J202+L202","v":0},{"$f":"IF(M202>=40,40-N201,M202-N201)","v":0},0,null,null,null,{"$f":"SUM(N202:R202)","v":0}]
[null,"2015-07-07","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M203>=40,40-SUM(N201:N202),M203-SUM(N201:N202))","v":0},0,null,null,null,{"$f":"SUM(N203:R203)","v":0}]
[null,"2015-07-08","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M204>=40,40-SUM(N201:N203),M204-SUM(N201:N203))","v":0},0,null,null,null,0]
[null,"2015-07-09","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M205>=40,40-SUM(N201:N204),M205-SUM(N201:N204))","v":0},0,null,null,null,0]
[null,"2015-07-10","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M206>=40,40-SUM(N201:N205),M206-SUM(N201:N205))","v":0},0,null,null,null,0]
[null,"2015-07-11","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M207>=40,40-SUM(N201:N206),M207-SUM(N201:N206))","v":0},0,null,null,null,0]
[null,"2015-07-12","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J208+L208","v":0},{"$f":"IF(M208>=40,40,M208)","v":0},0,null,null,null,0]
[null,"2015-07-13","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M208+J209+L209","v":0},{"$f":"IF(M209>=40,40-N208,M209-N208)","v":0},0,null,null,null,{"$f":"SUM(N209:R209)","v":0}]
[null,"2015-07-14","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M210>=40,40-SUM(N208:N209),M210-SUM(N208:N209))","v":0},0,null,null,null,{"$f":"SUM(N210:R210)","v":0}]
[null,"2015-07-15","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M211>=40,40-SUM(N208:N210),M211-SUM(N208:N210))","v":0},0,null,null,null,{"$f":"SUM(N211:R211)","v":0}]
[null,"2015-07-16","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M212>=40,40-SUM(N208:N211),M212-SUM(N208:N211))","v":0},0,null,null,null,0]
[null,"2015-07-17","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M213>=40,40-SUM(N208:N212),M213-SUM(N208:N212))","v":0},0,null,null,null,0]
[null,"2015-07-18","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M214>=40,40-SUM(N208:N213),M214-SUM(N208:N213))","v":0},0,null,null,null,0]
[null,"2015-07-19","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J215+L215","v":0},{"$f":"IF(M215>=40,40,M215)","v":0},0,null,null,null,0]
[null,"2015-07-20","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M215+J216+L216","v":0},{"$f":"IF(M216>=40,40-N215,M216-N215)","v":0},0,null,null,null,{"$f":"SUM(N216:R216)","v":0}]
[null,"2015-07-21","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M217>=40,40-SUM(N215:N216),M217-SUM(N215:N216))","v":0},0,null,null,null,{"$f":"SUM(N217:R217)","v":0}]
[null,"2015-07-22","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M218>=40,40-SUM(N215:N217),M218-SUM(N215:N217))","v":0},0,null,null,null,0]
[null,"2015-07-23","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M219>=40,40-SUM(N215:N218),M219-SUM(N215:N218))","v":0},0,null,null,null,0]
[null,"2015-07-24","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M220>=40,40-SUM(N215:N219),M220-SUM(N215:N219))","v":0},0,null,null,null,0]
[null,"2015-07-25","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M221>=40,40-SUM(N215:N220),M221-SUM(N215:N220))","v":0},0,null,null,null,0]
[null,"2015-07-26","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J222+L222","v":0},{"$f":"IF(M222>=40,40,M222)","v":0},0,null,null,null,0]
[null,"2015-07-27","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M222+J223+L223","v":0},{"$f":"IF(M223>=40,40-N222,M223-N222)","v":0},0,null,null,null,{"$f":"SUM(N223:R223)","v":0}]
[null,"2015-07-28","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M224>=40,40-SUM(N222:N223),M224-SUM(N222:N223))","v":0},0,null,null,null,{"$f":"SUM(N224:R224)","v":0}]
[null,"2015-07-29","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M225>=40,40-SUM(N222:N224),M225-SUM(N222:N224))","v":0},0,null,null,null,{"$f":"SUM(N225:R225)","v":0}]
[null,"2015-07-30","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M226>=40,40-SUM(N222:N225),M226-SUM(N222:N225))","v":0},0,null,null,null,0]
[null,"2015-07-31","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M227>=40,40-SUM(N222:N226),M227-SUM(N222:N226))","v":0},0,null,null,null,0]
[null,"2015-08-01","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M228>=40,40-SUM(N222:N227),M228-SUM(N222:N227))","v":0},0,null,null,null,0]
[null,"2015-08-02","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J229+L229","v":0},{"$f":"IF(M229>=40,40,M229)","v":0},0,null,null,null,0]
[null,"2015-08-03","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M229+J230+L230","v":0},{"$f":"IF(M230>=40,40-N229,M230-N229)","v":0},0,null,null,null,{"$f":"SUM(N230:R230)","v":0}]
[null,"2015-08-04","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M231>=40,40-SUM(N229:N230),M231-SUM(N229:N230))","v":0},0,null,null,null,{"$f":"SUM(N231:R231)","v":0}]
[null,"2015-08-05","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M232>=40,40-SUM(N229:N231),M232-SUM(N229:N231))","v":0},0,null,null,null,0]
[null,"2015-08-06","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M233>=40,40-SUM(N229:N232),M233-SUM(N229:N232))","v":0},0,null,null,null,0]
[null,"2015-08-07","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M234>=40,40-SUM(N229:N233),M234-SUM(N229:N233))","v":0},0,null,null,null,0]
[null,"2015-08-08","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M235>=40,40-SUM(N229:N234),M235-SUM(N229:N234))","v":0},0,null,null,null,0]
[null,"2015-08-09","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J236+L236","v":0},{"$f":"IF(M236>=40,40,M236)","v":0},0,null,null,null,0]
[null,"2015-08-10","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M236+J237+L237","v":0},{"$f":"IF(M237>=40,40-N236,M237-N236)","v":0},0,null,null,null,{"$f":"SUM(N237:R237)","v":0}]
[null,"2015-08-11","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M238>=40,40-SUM(N236:N237),M238-SUM(N236:N237))","v":0},0,null,null,null,{"$f":"SUM(N238:R238)","v":0}]
[null,"2015-08-12","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M239>=40,40-SUM(N236:N238),M239-SUM(N236:N238))","v":0},0,null,null,null,{"$f":"SUM(N239:R239)","v":0}]
[null,"2015-08-13","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M240>=40,40-SUM(N236:N239),M240-SUM(N236:N239))","v":0},0,null,null,null,0]
[null,"2015-08-14","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M241>=40,40-SUM(N236:N240),M241-SUM(N236:N240))","v":0},0,null,null,null,0]
[null,"2015-08-15","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M242>=40,40-SUM(N236:N241),M242-SUM(N236:N241))","v":0},0,null,null,null,0]
[null,"2015-08-16","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J243+L243","v":0},{"$f":"IF(M243>=40,40,M243)","v":0},0,null,null,null,0]
[null,"2015-08-17","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M243+J244+L244","v":0},{"$f":"IF(M244>=40,40-N243,M244-N243)","v":0},0,null,null,null,{"$f":"SUM(N244:R244)","v":0}]
[null,"2015-08-18","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M245>=40,40-SUM(N243:N244),M245-SUM(N243:N244))","v":0},0,null,null,null,{"$f":"SUM(N245:R245)","v":0}]
[null,"2015-08-19","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M246>=40,40-SUM(N243:N245),M246-SUM(N243:N245))","v":0},0,null,null,null,0]
[null,"2015-08-20","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M247>=40,40-SUM(N243:N246),M247-SUM(N243:N246))","v":0},0,null,null,null,0]
[null,"2015-08-21","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M248>=40,40-SUM(N243:N247),M248-SUM(N243:N247))","v":0},0,null,null,null,0]
[null,"2015-08-22","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M249>=40,40-SUM(N243:N248),M249-SUM(N243:N248))","v":0},{"$f":"+J249+L249-N249","v":0},null,null,null,0]
[null,"2015-08-23","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J250+L250","v":0},{"$f":"IF(M250>=40,40,M250)","v":0},0,null,null,null,0]
[null,"2015-08-24","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M250+J251+L251","v":0},{"$f":"IF(M251>=40,40-N250,M251-N250)","v":0},0,null,null,null,{"$f":"SUM(N251:R251)","v":0}]
[null,"2015-08-25","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M252>=40,40-SUM(N250:N251),M252-SUM(N250:N251))","v":0},0,null,null,null,{"$f":"SUM(N252:R252)","v":0}]
[null,"2015-08-26","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M253>=40,40-SUM(N250:N252),M253-SUM(N250:N252))","v":0},0,null,null,null,{"$f":"SUM(N253:R253)","v":0}]
[null,"2015-08-27","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M254>=40,40-SUM(N250:N253),M254-SUM(N250:N253))","v":0},0,null,null,null,0]
[null,"2015-08-28","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M255>=40,40-SUM(N250:N254),M255-SUM(N250:N254))","v":0},0,null,null,null,0]
[null,"2015-08-29","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M256>=40,40-SUM(N250:N255),M256-SUM(N250:N255))","v":0},0,null,null,null,0]
[null,"2015-08-30","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J257+L257","v":0},{"$f":"IF(M257>=40,40,M257)","v":0},0,null,null,null,0]
[null,"2015-08-31","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M257+J258+L258","v":0},{"$f":"IF(M258>=40,40-N257,M258-N257)","v":0},0,null,null,null,{"$f":"SUM(N258:R258)","v":0}]
[null,"2015-09-01","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M259>=40,40-SUM(N257:N258),M259-SUM(N257:N258))","v":0},0,null,null,null,{"$f":"SUM(N259:R259)","v":0}]
[null,"2015-09-02","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M260>=40,40-SUM(N257:N259),M260-SUM(N257:N259))","v":0},0,null,null,null,0]
[null,"2015-09-03","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M261>=40,40-SUM(N257:N260),M261-SUM(N257:N260))","v":0},0,null,null,null,0]
[null,"2015-09-04","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M262>=40,40-SUM(N257:N261),M262-SUM(N257:N261))","v":0},0,null,null,null,0]
[null,"2015-09-05","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M263>=40,40-SUM(N257:N262),M263-SUM(N257:N262))","v":0},0,null,null,null,0]
[null,"2015-09-06","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J264+L264","v":0},{"$f":"IF(M264>=40,40,M264)","v":0},0,null,null,null,0]
[null,"2015-09-07","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M264+J265+L265","v":0},{"$f":"IF(M265>=40,40-N264,M265-N264)","v":0},0,null,null,null,{"$f":"SUM(N265:R265)","v":0}]
[null,"2015-09-08","Tuesday",null,null,null,null,null,null,{"$f":"HOUR(I266-H266+G266-F266+E266-D266)","v":0},{"$f":"MINUTE(I266-H266+G266-F266+E266-D266)","v":0},{"$f":"IF(K266=15,0.25,IF(K266=30,0.5,IF(K266=45,0.75,0)))","v":0},0,{"$f":"IF(M266>=40,40-SUM(N264:N265),M266-SUM(N264:N265))","v":0},0,null,null,null,{"$f":"SUM(N266:R266)","v":0}]
[null,"2015-09-09","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M267>=40,40-SUM(N264:N266),M267-SUM(N264:N266))","v":0},0,null,null,null,{"$f":"SUM(N267:R267)","v":0}]
[null,"2015-09-10","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M268>=40,40-SUM(N264:N267),M268-SUM(N264:N267))","v":0},0,null,null,null,0]
[null,"2015-09-11","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M269>=40,40-SUM(N264:N268),M269-SUM(N264:N268))","v":0},0,null,null,null,0]
[null,"2015-09-12","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M270>=40,40-SUM(N264:N269),M270-SUM(N264:N269))","v":0},0,null,null,null,0]
[null,"2015-09-13","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J271+L271","v":0},{"$f":"IF(M271>=40,40,M271)","v":0},0,null,null,null,0]
[null,"2015-09-14","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M271+J272+L272","v":0},{"$f":"IF(M272>=40,40-N271,M272-N271)","v":0},0,null,null,null,{"$f":"SUM(N272:R272)","v":0}]
[null,"2015-09-15","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M273>=40,40-SUM(N271:N272),M273-SUM(N271:N272))","v":0},0,null,null,null,{"$f":"SUM(N273:R273)","v":0}]
[null,"2015-09-16","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M274>=40,40-SUM(N271:N273),M274-SUM(N271:N273))","v":0},0,null,null,null,0]
[null,"2015-09-17","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M275>=40,40-SUM(N271:N274),M275-SUM(N271:N274))","v":0},0,null,null,null,0]
[null,"2015-09-18","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M276>=40,40-SUM(N271:N275),M276-SUM(N271:N275))","v":0},0,null,null,null,0]
[null,"2015-09-19","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M277>=40,40-SUM(N271:N276),M277-SUM(N271:N276))","v":0},0,null,null,null,0]
[null,"2015-09-20","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J278+L278","v":0},{"$f":"IF(M278>=40,40,M278)","v":0},0,null,null,null,0]
[null,"2015-09-21","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M278+J279+L279","v":0},{"$f":"IF(M279>=40,40-N278,M279-N278)","v":0},0,null,null,null,{"$f":"SUM(N279:R279)","v":0}]
[null,"2015-09-22","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M280>=40,40-SUM(N278:N279),M280-SUM(N278:N279))","v":0},0,null,null,null,{"$f":"SUM(N280:R280)","v":0}]
[null,"2015-09-23","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M281>=40,40-SUM(N278:N280),M281-SUM(N278:N280))","v":0},0,null,null,null,{"$f":"SUM(N281:R281)","v":0}]
[null,"2015-09-24","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M282>=40,40-SUM(N278:N281),M282-SUM(N278:N281))","v":0},0,null,null,null,0]
[null,"2015-09-25","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M283>=40,40-SUM(N278:N282),M283-SUM(N278:N282))","v":0},0,null,null,null,0]
[null,"2015-09-26","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M284>=40,40-SUM(N278:N283),M284-SUM(N278:N283))","v":0},0,null,null,null,0]
[null,"2015-09-27","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J285+L285","v":0},{"$f":"IF(M285>=40,40,M285)","v":0},0,null,null,null,0]
[null,"2015-09-28","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M285+J286+L286","v":0},{"$f":"IF(M286>=40,40-N285,M286-N285)","v":0},0,null,null,null,{"$f":"SUM(N286:R286)","v":0}]
[null,"2015-09-29","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M287>=40,40-SUM(N285:N286),M287-SUM(N285:N286))","v":0},0,null,null,null,{"$f":"SUM(N287:R287)","v":0}]
[null,"2015-09-30","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M288>=40,40-SUM(N285:N287),M288-SUM(N285:N287))","v":0},0,null,null,null,0]
[null,"2015-10-01","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M289>=40,40-SUM(N285:N288),M289-SUM(N285:N288))","v":0},0,null,null,null,0]
[null,"2015-10-02","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M290>=40,40-SUM(N285:N289),M290-SUM(N285:N289))","v":0},0,null,null,null,0]
[null,"2015-10-03","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M291>=40,40-SUM(N285:N290),M291-SUM(N285:N290))","v":0},0,null,null,null,0]
[null,"2015-10-04","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J292+L292","v":0},{"$f":"IF(M292>=40,40,M292)","v":0},0,null,null,null,0]
[null,"2015-10-05","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M292+J293+L293","v":0},{"$f":"IF(M293>=40,40-N292,M293-N292)","v":0},0,null,null,null,{"$f":"SUM(N293:R293)","v":0}]
[null,"2015-10-06","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M294>=40,40-SUM(N292:N293),M294-SUM(N292:N293))","v":0},0,null,null,null,{"$f":"SUM(N294:R294)","v":0}]
[null,"2015-10-07","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M295>=40,40-SUM(N292:N294),M295-SUM(N292:N294))","v":0},0,null,null,null,{"$f":"SUM(N295:R295)","v":0}]
[null,"2015-10-08","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M296>=40,40-SUM(N292:N295),M296-SUM(N292:N295))","v":0},0,null,null,null,0]
[null,"2015-10-09","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M297>=40,40-SUM(N292:N296),M297-SUM(N292:N296))","v":0},0,null,null,null,0]
[null,"2015-10-10","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M298>=40,40-SUM(N292:N297),M298-SUM(N292:N297))","v":0},0,null,null,null,0]
[null,"2015-10-11","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J299+L299","v":0},{"$f":"IF(M299>=40,40,M299)","v":0},0,null,null,null,0]
[null,"2015-10-12","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M299+J300+L300","v":0},{"$f":"IF(M300>=40,40-N299,M300-N299)","v":0},0,null,null,null,{"$f":"SUM(N300:R300)","v":0}]
[null,"2015-10-13","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M301>=40,40-SUM(N299:N300),M301-SUM(N299:N300))","v":0},0,null,null,null,{"$f":"SUM(N301:R301)","v":0}]
[null,"2015-10-14","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M302>=40,40-SUM(N299:N301),M302-SUM(N299:N301))","v":0},0,null,null,null,0]
[null,"2015-10-15","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M303>=40,40-SUM(N299:N302),M303-SUM(N299:N302))","v":0},0,null,null,null,0]
[null,"2015-10-16","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M304>=40,40-SUM(N299:N303),M304-SUM(N299:N303))","v":0},0,null,null,null,0]
[null,"2015-10-17","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M305>=40,40-SUM(N299:N304),M305-SUM(N299:N304))","v":0},0,null,null,null,0]
[null,"2015-10-18","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J306+L306","v":0},{"$f":"IF(M306>=40,40,M306)","v":0},0,null,null,null,0]
[null,"2015-10-19","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M306+J307+L307","v":0},{"$f":"IF(M307>=40,40-N306,M307-N306)","v":0},0,null,null,null,{"$f":"SUM(N307:R307)","v":0}]
[null,"2015-10-20","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M308>=40,40-SUM(N306:N307),M308-SUM(N306:N307))","v":0},0,null,null,null,{"$f":"SUM(N308:R308)","v":0}]
[null,"2015-10-21","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M309>=40,40-SUM(N306:N308),M309-SUM(N306:N308))","v":0},0,null,null,null,{"$f":"SUM(N309:R309)","v":0}]
[null,"2015-10-22","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M310>=40,40-SUM(N306:N309),M310-SUM(N306:N309))","v":0},0,null,null,null,0]
[null,"2015-10-23","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M311>=40,40-SUM(N306:N310),M311-SUM(N306:N310))","v":0},0,null,null,null,0]
[null,"2015-10-24","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M312>=40,40-SUM(N306:N311),M312-SUM(N306:N311))","v":0},0,null,null,null,0]
[null,"2015-10-25","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J313+L313","v":0},{"$f":"IF(M313>=40,40,M313)","v":0},{"$f":"+J313+L313-N313","v":0},null,null,null,0]
[null,"2015-10-26","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M313+J314+L314","v":0},{"$f":"IF(M314>=40,40-N313,M314-N313)","v":0},0,null,null,null,{"$f":"SUM(N314:R314)","v":0}]
[null,"2015-10-27","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M315>=40,40-SUM(N313:N314),M315-SUM(N313:N314))","v":0},0,null,null,null,{"$f":"SUM(N315:R315)","v":0}]
[null,"2015-10-28","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M316>=40,40-SUM(N313:N315),M316-SUM(N313:N315))","v":0},0,null,null,null,0]
[null,"2015-10-29","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M317>=40,40-SUM(N313:N316),M317-SUM(N313:N316))","v":0},0,null,null,null,0]
[null,"2015-10-30","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M318>=40,40-SUM(N313:N317),M318-SUM(N313:N317))","v":0},0,null,null,null,0]
[null,"2015-10-31","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M319>=40,40-SUM(N313:N318),M319-SUM(N313:N318))","v":0},0,null,null,null,0]
[null,"2015-11-01","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J320+L320","v":0},{"$f":"IF(M320>=40,40,M320)","v":0},0,null,null,null,0]
[null,"2015-11-02","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M320+J321+L321","v":0},{"$f":"IF(M321>=40,40-N320,M321-N320)","v":0},0,null,null,null,{"$f":"SUM(N321:R321)","v":0}]
[null,"2015-11-03","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M322>=40,40-SUM(N320:N321),M322-SUM(N320:N321))","v":0},0,null,null,null,{"$f":"SUM(N322:R322)","v":0}]
[null,"2015-11-04","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M323>=40,40-SUM(N320:N322),M323-SUM(N320:N322))","v":0},0,null,null,null,{"$f":"SUM(N323:R323)","v":0}]
[null,"2015-11-05","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M324>=40,40-SUM(N320:N323),M324-SUM(N320:N323))","v":0},0,null,null,null,0]
[null,"2015-11-06","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M325>=40,40-SUM(N320:N324),M325-SUM(N320:N324))","v":0},0,null,null,null,0]
[null,"2015-11-07","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M326>=40,40-SUM(N320:N325),M326-SUM(N320:N325))","v":0},0,null,null,null,0]
[null,"2015-11-08","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J327+L327","v":0},{"$f":"IF(M327>=40,40,M327)","v":0},0,null,null,null,0]
[null,"2015-11-09","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M327+J328+L328","v":0},{"$f":"IF(M328>=40,40-N327,M328-N327)","v":0},0,null,null,null,{"$f":"SUM(N328:R328)","v":0}]
[null,"2015-11-10","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M329>=40,40-SUM(N327:N328),M329-SUM(N327:N328))","v":0},0,null,null,null,{"$f":"SUM(N329:R329)","v":0}]
[null,"2015-11-11","Wednesday",null,null,null,null,null,null,{"$f":"HOUR(I330-H330+G330-F330+E330-D330)","v":0},{"$f":"MINUTE(I330-H330+G330-F330+E330-D330)","v":0},{"$f":"IF(K330=15,0.25,IF(K330=30,0.5,IF(K330=45,0.75,0)))","v":0},0,{"$f":"IF(M330>=40,40-SUM(N327:N329),M330-SUM(N327:N329))","v":0},0,null,null,null,0]
[null,"2015-11-12","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M331>=40,40-SUM(N327:N330),M331-SUM(N327:N330))","v":0},0,null,null,null,0]
[null,"2015-11-13","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M332>=40,40-SUM(N327:N331),M332-SUM(N327:N331))","v":0},0,null,null,null,0]
[null,"2015-11-14","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M333>=40,40-SUM(N327:N332),M333-SUM(N327:N332))","v":0},0,null,null,null,0]
[null,"2015-11-15","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J334+L334","v":0},{"$f":"IF(M334>=40,40,M334)","v":0},0,null,null,null,0]
[null,"2015-11-16","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M334+J335+L335","v":0},{"$f":"IF(M335>=40,40-N334,M335-N334)","v":0},0,null,null,null,{"$f":"SUM(N335:R335)","v":0}]
[null,"2015-11-17","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M336>=40,40-SUM(N334:N335),M336-SUM(N334:N335))","v":0},0,null,null,null,{"$f":"SUM(N336:R336)","v":0}]
[null,"2015-11-18","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M337>=40,40-SUM(N334:N336),M337-SUM(N334:N336))","v":0},0,null,null,null,{"$f":"SUM(N337:R337)","v":0}]
[null,"2015-11-19","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M338>=40,40-SUM(N334:N337),M338-SUM(N334:N337))","v":0},0,null,null,null,0]
[null,"2015-11-20","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M339>=40,40-SUM(N334:N338),M339-SUM(N334:N338))","v":0},0,null,null,null,0]
[null,"2015-11-21","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M340>=40,40-SUM(N334:N339),M340-SUM(N334:N339))","v":0},0,null,null,null,0]
[null,"2015-11-22","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J341+L341","v":0},{"$f":"IF(M341>=40,40,M341)","v":0},0,null,null,null,0]
[null,"2015-11-23","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M341+J342+L342","v":0},{"$f":"IF(M342>=40,40-N341,M342-N341)","v":0},0,null,null,null,{"$f":"SUM(N342:R342)","v":0}]
[null,"2015-11-24","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M343>=40,40-SUM(N341:N342),M343-SUM(N341:N342))","v":0},0,null,null,null,{"$f":"SUM(N343:R343)","v":0}]
[null,"2015-11-25","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M344>=40,40-SUM(N341:N343),M344-SUM(N341:N343))","v":0},0,null,null,null,0]
[null,"2015-11-26","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M345>=40,40-SUM(N341:N344),M345-SUM(N341:N344))","v":0},0,null,null,null,0]
[null,"2015-11-27","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M346>=40,40-SUM(N341:N345),M346-SUM(N341:N345))","v":0},0,null,null,null,0]
[null,"2015-11-28","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M347>=40,40-SUM(N341:N346),M347-SUM(N341:N346))","v":0},0,null,null,null,0]
[null,"2015-11-29","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J348+L348","v":0},{"$f":"IF(M348>=40,40,M348)","v":0},0,null,null,null,0]
[null,"2015-11-30","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M348+J349+L349","v":0},{"$f":"IF(M349>=40,40-N348,M349-N348)","v":0},0,null,null,null,{"$f":"SUM(N349:R349)","v":0}]
[null,"2015-12-01","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M350>=40,40-SUM(N348:N349),M350-SUM(N348:N349))","v":0},0,null,null,null,{"$f":"SUM(N350:R350)","v":0}]
[null,"2015-12-02","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M351>=40,40-SUM(N348:N350),M351-SUM(N348:N350))","v":0},0,null,null,null,{"$f":"SUM(N351:R351)","v":0}]
[null,"2015-12-03","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M352>=40,40-SUM(N348:N351),M352-SUM(N348:N351))","v":0},0,null,null,null,0]
[null,"2015-12-04","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M353>=40,40-SUM(N348:N352),M353-SUM(N348:N352))","v":0},0,null,null,null,0]
[null,"2015-12-05","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M354>=40,40-SUM(N348:N353),M354-SUM(N348:N353))","v":0},0,null,null,null,0]
[null,"2015-12-06","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J355+L355","v":0},{"$f":"IF(M355>=40,40,M355)","v":0},0,null,null,null,0]
[null,"2015-12-07","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M355+J356+L356","v":0},{"$f":"IF(M356>=40,40-N355,M356-N355)","v":0},0,null,null,null,{"$f":"SUM(N356:R356)","v":0}]
[null,"2015-12-08","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M357>=40,40-SUM(N355:N356),M357-SUM(N355:N356))","v":0},0,null,null,null,{"$f":"SUM(N357:R357)","v":0}]
[null,"2015-12-09","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M358>=40,40-SUM(N355:N357),M358-SUM(N355:N357))","v":0},0,null,null,null,0]
[null,"2015-12-10","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M359>=40,40-SUM(N355:N358),M359-SUM(N355:N358))","v":0},0,null,null,null,0]
[null,"2015-12-11","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M360>=40,40-SUM(N355:N359),M360-SUM(N355:N359))","v":0},0,null,null,null,0]
[null,"2015-12-12","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M361>=40,40-SUM(N355:N360),M361-SUM(N355:N360))","v":0},0,null,null,null,0]
[null,"2015-12-13","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J362+L362","v":0},{"$f":"IF(M362>=40,40,M362)","v":0},0,null,null,null,0]
[null,"2015-12-14","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M362+J363+L363","v":0},{"$f":"IF(M363>=40,40-N362,M363-N362)","v":0},0,null,null,null,{"$f":"SUM(N363:R363)","v":0}]
[null,"2015-12-15","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M364>=40,40-SUM(N362:N363),M364-SUM(N362:N363))","v":0},0,null,null,null,{"$f":"SUM(N364:R364)","v":0}]
[null,"2015-12-16","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M365>=40,40-SUM(N362:N364),M365-SUM(N362:N364))","v":0},0,null,null,null,{"$f":"SUM(N365:R365)","v":0}]
[null,"2015-12-17","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M366>=40,40-SUM(N362:N365),M366-SUM(N362:N365))","v":0},0,null,null,null,0]
[null,"2015-12-18","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M367>=40,40-SUM(N362:N366),M367-SUM(N362:N366))","v":0},0,null,null,null,0]
[null,"2015-12-19","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M368>=40,40-SUM(N362:N367),M368-SUM(N362:N367))","v":0},0,null,null,null,0]
[null,"2015-12-20","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J369+L369","v":0},{"$f":"IF(M369>=40,40,M369)","v":0},0,null,null,null,0]
[null,"2015-12-21","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M369+J370+L370","v":0},{"$f":"IF(M370>=40,40-N369,M370-N369)","v":0},0,null,null,null,{"$f":"SUM(N370:R370)","v":0}]
[null,"2015-12-22","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M371>=40,40-SUM(N369:N370),M371-SUM(N369:N370))","v":0},0,null,null,null,{"$f":"SUM(N371:R371)","v":0}]
[null,"2015-12-23","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M372>=40,40-SUM(N369:N371),M372-SUM(N369:N371))","v":0},0,null,null,null,0]
[null,"2015-12-24","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M373>=40,40-SUM(N369:N372),M373-SUM(N369:N372))","v":0},0,null,null,null,0]
[null,"2015-12-25","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M374>=40,40-SUM(N369:N373),M374-SUM(N369:N373))","v":0},0,null,null,null,0]
[null,"2015-12-26","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M375>=40,40-SUM(N369:N374),M375-SUM(N369:N374))","v":0},0,null,null,null,0]
[null,"2015-12-27","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J376+L376","v":0},{"$f":"IF(M376>=40,40,M376)","v":0},0,null,null,null,0]
[null,"2015-12-28","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M376+J377+L377","v":0},{"$f":"IF(M377>=40,40-N376,M377-N376)","v":0},{"$f":"+J377+L377-N377","v":0},null,null,null,{"$f":"SUM(N377:R377)","v":0}]
[null,"2015-12-29","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M378>=40,40-SUM(N376:N377),M378-SUM(N376:N377))","v":0},0,null,null,null,{"$f":"SUM(N378:R378)","v":0}]
[null,"2015-12-30","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M379>=40,40-SUM(N376:N378),M379-SUM(N376:N378))","v":0},0,null,null,null,{"$f":"SUM(N379:R379)","v":0}]
[null,"2015-12-31","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M380>=40,40-SUM(N376:N379),M380-SUM(N376:N379))","v":0},0,null,null,null,0]
[null,"2016-01-01","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M381>=40,40-SUM(N376:N380),M381-SUM(N376:N380))","v":0},0,null,null,null,0]
[null,"2016-01-02","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M382>=40,40-SUM(N376:N381),M382-SUM(N376:N381))","v":0},0,null,null,null,0]
[null,"2016-01-03","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J383+L383","v":0},{"$f":"IF(M383>=40,40,M383)","v":0},0,null,null,null,0]
[null,"2016-01-04","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M383+J384+L384","v":0},{"$f":"IF(M384>=40,40-N383,M384-N383)","v":0},0,null,null,null,{"$f":"SUM(N384:R384)","v":0}]
[null,"2016-01-05","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M385>=40,40-SUM(N383:N384),M385-SUM(N383:N384))","v":0},0,null,null,null,{"$f":"SUM(N385:R385)","v":0}]
[null,"2016-01-06","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M386>=40,40-SUM(N383:N385),M386-SUM(N383:N385))","v":0},0,null,null,null,0]
[null,"2016-01-07","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M387>=40,40-SUM(N383:N386),M387-SUM(N383:N386))","v":0},0,null,null,null,0]
[null,"2016-01-08","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M388>=40,40-SUM(N383:N387),M388-SUM(N383:N387))","v":0},0,null,null,null,0]
[null,"2016-01-09","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M389>=40,40-SUM(N383:N388),M389-SUM(N383:N388))","v":0},0,null,null,null,0]
[null,"2016-01-10","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J390+L390","v":0},{"$f":"IF(M390>=40,40,M390)","v":0},0,null,null,null,0]
[null,"2016-01-11","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M390+J391+L391","v":0},{"$f":"IF(M391>=40,40-N390,M391-N390)","v":0},0,null,null,null,{"$f":"SUM(N391:R391)","v":0}]
[null,"2016-01-12","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M392>=40,40-SUM(N390:N391),M392-SUM(N390:N391))","v":0},0,null,null,null,{"$f":"SUM(N392:R392)","v":0}]
[null,"2016-01-13","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M393>=40,40-SUM(N390:N392),M393-SUM(N390:N392))","v":0},0,null,null,null,{"$f":"SUM(N393:R393)","v":0}]
[null,"2016-01-14","Thursday",null,null,null,null,null,null,{"$f":"HOUR(I394-H394+G394-F394+E394-D394)","v":0},{"$f":"MINUTE(I394-H394+G394-F394+E394-D394)","v":0},{"$f":"IF(K394=15,0.25,IF(K394=30,0.5,IF(K394=45,0.75,0)))","v":0},0,{"$f":"IF(M394>=40,40-SUM(N390:N393),M394-SUM(N390:N393))","v":0},0,null,null,null,0]
[null,"2016-01-15","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M395>=40,40-SUM(N390:N394),M395-SUM(N390:N394))","v":0},0,null,null,null,0]
[null,"2016-01-16","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M396>=40,40-SUM(N390:N395),M396-SUM(N390:N395))","v":0},0,null,null,null,0]
[null,"2016-01-17","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J397+L397","v":0},{"$f":"IF(M397>=40,40,M397)","v":0},0,null,null,null,0]
[null,"2016-01-18","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M397+J398+L398","v":0},{"$f":"IF(M398>=40,40-N397,M398-N397)","v":0},0,null,null,null,{"$f":"SUM(N398:R398)","v":0}]
[null,"2016-01-19","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M399>=40,40-SUM(N397:N398),M399-SUM(N397:N398))","v":0},0,null,null,null,{"$f":"SUM(N399:R399)","v":0}]
[null,"2016-01-20","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M400>=40,40-SUM(N397:N399),M400-SUM(N397:N399))","v":0},0,null,null,null,0]
[null,"2016-01-21","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M401>=40,40-SUM(N397:N400),M401-SUM(N397:N400))","v":0},0,null,null,null,0]
[null,"2016-01-22","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M402>=40,40-SUM(N397:N401),M402-SUM(N397:N401))","v":0},0,null,null,null,0]
[null,"2016-01-23","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M403>=40,40-SUM(N397:N402),M403-SUM(N397:N402))","v":0},0,null,null,null,0]
[null,"2016-01-24","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J404+L404","v":0},{"$f":"IF(M404>=40,40,M404)","v":0},0,null,null,null,0]
[null,"2016-01-25","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M404+J405+L405","v":0},{"$f":"IF(M405>=40,40-N404,M405-N404)","v":0},0,null,null,null,{"$f":"SUM(N405:R405)","v":0}]
[null,"2016-01-26","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M406>=40,40-SUM(N404:N405),M406-SUM(N404:N405))","v":0},0,null,null,null,{"$f":"SUM(N406:R406)","v":0}]
[null,"2016-01-27","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M407>=40,40-SUM(N404:N406),M407-SUM(N404:N406))","v":0},0,null,null,null,{"$f":"SUM(N407:R407)","v":0}]
[null,"2016-01-28","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M408>=40,40-SUM(N404:N407),M408-SUM(N404:N407))","v":0},0,null,null,null,0]
[null,"2016-01-29","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M409>=40,40-SUM(N404:N408),M409-SUM(N404:N408))","v":0},0,null,null,null,0]
[null,"2016-01-30","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M410>=40,40-SUM(N404:N409),M410-SUM(N404:N409))","v":0},0,null,null,null,0]
[null,"2016-01-31","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J411+L411","v":0},{"$f":"IF(M411>=40,40,M411)","v":0},0,null,null,null,0]
[null,"2016-02-01","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M411+J412+L412","v":0},{"$f":"IF(M412>=40,40-N411,M412-N411)","v":0},0,null,null,null,{"$f":"SUM(N412:R412)","v":0}]
[null,"2016-02-02","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M413>=40,40-SUM(N411:N412),M413-SUM(N411:N412))","v":0},0,null,null,null,{"$f":"SUM(N413:R413)","v":0}]
[null,"2016-02-03","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M414>=40,40-SUM(N411:N413),M414-SUM(N411:N413))","v":0},0,null,null,null,0]
[null,"2016-02-04","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M415>=40,40-SUM(N411:N414),M415-SUM(N411:N414))","v":0},0,null,null,null,0]
[null,"2016-02-05","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M416>=40,40-SUM(N411:N415),M416-SUM(N411:N415))","v":0},0,null,null,null,0]
[null,"2016-02-06","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M417>=40,40-SUM(N411:N416),M417-SUM(N411:N416))","v":0},0,null,null,null,0]
[null,"2016-02-07","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J418+L418","v":0},{"$f":"IF(M418>=40,40,M418)","v":0},0,null,null,null,0]
[null,"2016-02-08","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M418+J419+L419","v":0},{"$f":"IF(M419>=40,40-N418,M419-N418)","v":0},0,null,null,null,{"$f":"SUM(N419:R419)","v":0}]
[null,"2016-02-09","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M420>=40,40-SUM(N418:N419),M420-SUM(N418:N419))","v":0},0,null,null,null,{"$f":"SUM(N420:R420)","v":0}]
[null,"2016-02-10","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M421>=40,40-SUM(N418:N420),M421-SUM(N418:N420))","v":0},0,null,null,null,{"$f":"SUM(N421:R421)","v":0}]
[null,"2016-02-11","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M422>=40,40-SUM(N418:N421),M422-SUM(N418:N421))","v":0},0,null,null,null,0]
[null,"2016-02-12","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M423>=40,40-SUM(N418:N422),M423-SUM(N418:N422))","v":0},0,null,null,null,0]
[null,"2016-02-13","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M424>=40,40-SUM(N418:N423),M424-SUM(N418:N423))","v":0},0,null,null,null,0]
[null,"2016-02-14","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J425+L425","v":0},{"$f":"IF(M425>=40,40,M425)","v":0},0,null,null,null,0]
[null,"2016-02-15","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M425+J426+L426","v":0},{"$f":"IF(M426>=40,40-N425,M426-N425)","v":0},0,null,null,null,{"$f":"SUM(N426:R426)","v":0}]
[null,"2016-02-16","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M427>=40,40-SUM(N425:N426),M427-SUM(N425:N426))","v":0},0,null,null,null,{"$f":"SUM(N427:R427)","v":0}]
[null,"2016-02-17","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M428>=40,40-SUM(N425:N427),M428-SUM(N425:N427))","v":0},0,null,null,null,0]
[null,"2016-02-18","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M429>=40,40-SUM(N425:N428),M429-SUM(N425:N428))","v":0},0,null,null,null,0]
[null,"2016-02-19","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M430>=40,40-SUM(N425:N429),M430-SUM(N425:N429))","v":0},0,null,null,null,0]
[null,"2016-02-20","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M431>=40,40-SUM(N425:N430),M431-SUM(N425:N430))","v":0},0,null,null,null,0]
[null,"2016-02-21","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J432+L432","v":0},{"$f":"IF(M432>=40,40,M432)","v":0},0,null,null,null,0]
[null,"2016-02-22","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M432+J433+L433","v":0},{"$f":"IF(M433>=40,40-N432,M433-N432)","v":0},0,null,null,null,{"$f":"SUM(N433:R433)","v":0}]
[null,"2016-02-23","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M434>=40,40-SUM(N432:N433),M434-SUM(N432:N433))","v":0},0,null,null,null,{"$f":"SUM(N434:R434)","v":0}]
[null,"2016-02-24","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M435>=40,40-SUM(N432:N434),M435-SUM(N432:N434))","v":0},0,null,null,null,{"$f":"SUM(N435:R435)","v":0}]
[null,"2016-02-25","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M436>=40,40-SUM(N432:N435),M436-SUM(N432:N435))","v":0},0,null,null,null,0]
[null,"2016-02-26","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M437>=40,40-SUM(N432:N436),M437-SUM(N432:N436))","v":0},0,null,null,null,0]
[null,"2016-02-27","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M438>=40,40-SUM(N432:N437),M438-SUM(N432:N437))","v":0},0,null,null,null,0]
[null,"2016-02-28","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J439+L439","v":0},{"$f":"IF(M439>=40,40,M439)","v":0},0,null,null,null,0]
[null,"2016-02-29","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M439+J440+L440","v":0},{"$f":"IF(M440>=40,40-N439,M440-N439)","v":0},0,null,null,null,{"$f":"SUM(N440:R440)","v":0}]
[null,"2016-03-01","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M441>=40,40-SUM(N439:N440),M441-SUM(N439:N440))","v":0},{"$f":"+J441+L441-N441","v":0},null,null,null,{"$f":"SUM(N441:R441)","v":0}]
[null,"2016-03-02","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M442>=40,40-SUM(N439:N441),M442-SUM(N439:N441))","v":0},0,null,null,null,0]
[null,"2016-03-03","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M443>=40,40-SUM(N439:N442),M443-SUM(N439:N442))","v":0},0,null,null,null,0]
[null,"2016-03-04","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M444>=40,40-SUM(N439:N443),M444-SUM(N439:N443))","v":0},0,null,null,null,0]
[null,"2016-03-05","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M445>=40,40-SUM(N439:N444),M445-SUM(N439:N444))","v":0},0,null,null,null,0]
[null,"2016-03-06","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J446+L446","v":0},{"$f":"IF(M446>=40,40,M446)","v":0},0,null,null,null,0]
[null,"2016-03-07","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M446+J447+L447","v":0},{"$f":"IF(M447>=40,40-N446,M447-N446)","v":0},0,null,null,null,{"$f":"SUM(N447:R447)","v":0}]
[null,"2016-03-08","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M448>=40,40-SUM(N446:N447),M448-SUM(N446:N447))","v":0},0,null,null,null,{"$f":"SUM(N448:R448)","v":0}]
[null,"2016-03-09","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M449>=40,40-SUM(N446:N448),M449-SUM(N446:N448))","v":0},0,null,null,null,{"$f":"SUM(N449:R449)","v":0}]
[null,"2016-03-10","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M450>=40,40-SUM(N446:N449),M450-SUM(N446:N449))","v":0},0,null,null,null,0]
[null,"2016-03-11","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M451>=40,40-SUM(N446:N450),M451-SUM(N446:N450))","v":0},0,null,null,null,0]
[null,"2016-03-12","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M452>=40,40-SUM(N446:N451),M452-SUM(N446:N451))","v":0},0,null,null,null,0]
[null,"2016-03-13","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J453+L453","v":0},{"$f":"IF(M453>=40,40,M453)","v":0},0,null,null,null,0]
[null,"2016-03-14","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M453+J454+L454","v":0},{"$f":"IF(M454>=40,40-N453,M454-N453)","v":0},0,null,null,null,{"$f":"SUM(N454:R454)","v":0}]
[null,"2016-03-15","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M455>=40,40-SUM(N453:N454),M455-SUM(N453:N454))","v":0},0,null,null,null,{"$f":"SUM(N455:R455)","v":0}]
[null,"2016-03-16","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M456>=40,40-SUM(N453:N455),M456-SUM(N453:N455))","v":0},0,null,null,null,0]
[null,"2016-03-17","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M457>=40,40-SUM(N453:N456),M457-SUM(N453:N456))","v":0},0,null,null,null,0]
[null,"2016-03-18","Friday",null,null,null,null,null,null,{"$f":"HOUR(I458-H458+G458-F458+E458-D458)","v":0},{"$f":"MINUTE(I458-H458+G458-F458+E458-D458)","v":0},{"$f":"IF(K458=15,0.25,IF(K458=30,0.5,IF(K458=45,0.75,0)))","v":0},0,{"$f":"IF(M458>=40,40-SUM(N453:N457),M458-SUM(N453:N457))","v":0},0,null,null,null,0]
[null,"2016-03-19","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M459>=40,40-SUM(N453:N458),M459-SUM(N453:N458))","v":0},0,null,null,null,0]
[null,"2016-03-20","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J460+L460","v":0},{"$f":"IF(M460>=40,40,M460)","v":0},0,null,null,null,0]
[null,"2016-03-21","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M460+J461+L461","v":0},{"$f":"IF(M461>=40,40-N460,M461-N460)","v":0},0,null,null,null,{"$f":"SUM(N461:R461)","v":0}]
[null,"2016-03-22","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M462>=40,40-SUM(N460:N461),M462-SUM(N460:N461))","v":0},0,null,null,null,{"$f":"SUM(N462:R462)","v":0}]
[null,"2016-03-23","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M463>=40,40-SUM(N460:N462),M463-SUM(N460:N462))","v":0},0,null,null,null,{"$f":"SUM(N463:R463)","v":0}]
[null,"2016-03-24","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M464>=40,40-SUM(N460:N463),M464-SUM(N460:N463))","v":0},0,null,null,null,0]
[null,"2016-03-25","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M465>=40,40-SUM(N460:N464),M465-SUM(N460:N464))","v":0},0,null,null,null,0]
[null,"2016-03-26","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M466>=40,40-SUM(N460:N465),M466-SUM(N460:N465))","v":0},0,null,null,null,0]
[null,"2016-03-27","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J467+L467","v":0},{"$f":"IF(M467>=40,40,M467)","v":0},0,null,null,null,0]
[null,"2016-03-28","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M467+J468+L468","v":0},{"$f":"IF(M468>=40,40-N467,M468-N467)","v":0},0,null,null,null,{"$f":"SUM(N468:R468)","v":0}]
[null,"2016-03-29","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M469>=40,40-SUM(N467:N468),M469-SUM(N467:N468))","v":0},0,null,null,null,{"$f":"SUM(N469:R469)","v":0}]
[null,"2016-03-30","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M470>=40,40-SUM(N467:N469),M470-SUM(N467:N469))","v":0},0,null,null,null,0]
[null,"2016-03-31","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M471>=40,40-SUM(N467:N470),M471-SUM(N467:N470))","v":0},0,null,null,null,0]
[null,"2016-04-01","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M472>=40,40-SUM(N467:N471),M472-SUM(N467:N471))","v":0},0,null,null,null,0]
[null,"2016-04-02","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M473>=40,40-SUM(N467:N472),M473-SUM(N467:N472))","v":0},0,null,null,null,0]
[null,"2016-04-03","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J474+L474","v":0},{"$f":"IF(M474>=40,40,M474)","v":0},0,null,null,null,0]
[null,"2016-04-04","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M474+J475+L475","v":0},{"$f":"IF(M475>=40,40-N474,M475-N474)","v":0},0,null,null,null,{"$f":"SUM(N475:R475)","v":0}]
[null,"2016-04-05","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M476>=40,40-SUM(N474:N475),M476-SUM(N474:N475))","v":0},0,null,null,null,{"$f":"SUM(N476:R476)","v":0}]
[null,"2016-04-06","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M477>=40,40-SUM(N474:N476),M477-SUM(N474:N476))","v":0},0,null,null,null,{"$f":"SUM(N477:R477)","v":0}]
[null,"2016-04-07","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M478>=40,40-SUM(N474:N477),M478-SUM(N474:N477))","v":0},0,null,null,null,0]
[null,"2016-04-08","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M479>=40,40-SUM(N474:N478),M479-SUM(N474:N478))","v":0},0,null,null,null,0]
[null,"2016-04-09","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M480>=40,40-SUM(N474:N479),M480-SUM(N474:N479))","v":0},0,null,null,null,0]
[null,"2016-04-10","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J481+L481","v":0},{"$f":"IF(M481>=40,40,M481)","v":0},0,null,null,null,0]
[null,"2016-04-11","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M481+J482+L482","v":0},{"$f":"IF(M482>=40,40-N481,M482-N481)","v":0},0,null,null,null,{"$f":"SUM(N482:R482)","v":0}]
[null,"2016-04-12","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M483>=40,40-SUM(N481:N482),M483-SUM(N481:N482))","v":0},0,null,null,null,{"$f":"SUM(N483:R483)","v":0}]
[null,"2016-04-13","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M484>=40,40-SUM(N481:N483),M484-SUM(N481:N483))","v":0},0,null,null,null,0]
[null,"2016-04-14","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M485>=40,40-SUM(N481:N484),M485-SUM(N481:N484))","v":0},0,null,null,null,0]
[null,"2016-04-15","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M486>=40,40-SUM(N481:N485),M486-SUM(N481:N485))","v":0},0,null,null,null,0]
[null,"2016-04-16","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M487>=40,40-SUM(N481:N486),M487-SUM(N481:N486))","v":0},0,null,null,null,0]
[null,"2016-04-17","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J488+L488","v":0},{"$f":"IF(M488>=40,40,M488)","v":0},0,null,null,null,0]
[null,"2016-04-18","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M488+J489+L489","v":0},{"$f":"IF(M489>=40,40-N488,M489-N488)","v":0},0,null,null,null,{"$f":"SUM(N489:R489)","v":0}]
[null,"2016-04-19","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M490>=40,40-SUM(N488:N489),M490-SUM(N488:N489))","v":0},0,null,null,null,{"$f":"SUM(N490:R490)","v":0}]
[null,"2016-04-20","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M491>=40,40-SUM(N488:N490),M491-SUM(N488:N490))","v":0},0,null,null,null,{"$f":"SUM(N491:R491)","v":0}]
[null,"2016-04-21","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M492>=40,40-SUM(N488:N491),M492-SUM(N488:N491))","v":0},0,null,null,null,0]
[null,"2016-04-22","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M493>=40,40-SUM(N488:N492),M493-SUM(N488:N492))","v":0},0,null,null,null,0]
[null,"2016-04-23","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M494>=40,40-SUM(N488:N493),M494-SUM(N488:N493))","v":0},0,null,null,null,0]
[null,"2016-04-24","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J495+L495","v":0},{"$f":"IF(M495>=40,40,M495)","v":0},0,null,null,null,0]
[null,"2016-04-25","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M495+J496+L496","v":0},{"$f":"IF(M496>=40,40-N495,M496-N495)","v":0},0,null,null,null,{"$f":"SUM(N496:R496)","v":0}]
[null,"2016-04-26","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M497>=40,40-SUM(N495:N496),M497-SUM(N495:N496))","v":0},0,null,null,null,{"$f":"SUM(N497:R497)","v":0}]
[null,"2016-04-27","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M498>=40,40-SUM(N495:N497),M498-SUM(N495:N497))","v":0},0,null,null,null,0]
[null,"2016-04-28","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M499>=40,40-SUM(N495:N498),M499-SUM(N495:N498))","v":0},0,null,null,null,0]
[null,"2016-04-29","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M500>=40,40-SUM(N495:N499),M500-SUM(N495:N499))","v":0},0,null,null,null,0]
[null,"2016-04-30","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M501>=40,40-SUM(N495:N500),M501-SUM(N495:N500))","v":0},0,null,null,null,0]
[null,"2016-05-01","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J502+L502","v":0},{"$f":"IF(M502>=40,40,M502)","v":0},0,null,null,null,0]
[null,"2016-05-02","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M502+J503+L503","v":0},{"$f":"IF(M503>=40,40-N502,M503-N502)","v":0},0,null,null,null,{"$f":"SUM(N503:R503)","v":0}]
[null,"2016-05-03","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M504>=40,40-SUM(N502:N503),M504-SUM(N502:N503))","v":0},0,null,null,null,{"$f":"SUM(N504:R504)","v":0}]
[null,"2016-05-04","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M505>=40,40-SUM(N502:N504),M505-SUM(N502:N504))","v":0},{"$f":"+J505+L505-N505","v":0},null,null,null,{"$f":"SUM(N505:R505)","v":0}]
[null,"2016-05-05","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M506>=40,40-SUM(N502:N505),M506-SUM(N502:N505))","v":0},0,null,null,null,0]
[null,"2016-05-06","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M507>=40,40-SUM(N502:N506),M507-SUM(N502:N506))","v":0},0,null,null,null,0]
[null,"2016-05-07","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M508>=40,40-SUM(N502:N507),M508-SUM(N502:N507))","v":0},0,null,null,null,0]
[null,"2016-05-08","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J509+L509","v":0},{"$f":"IF(M509>=40,40,M509)","v":0},0,null,null,null,0]
[null,"2016-05-09","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M509+J510+L510","v":0},{"$f":"IF(M510>=40,40-N509,M510-N509)","v":0},0,null,null,null,{"$f":"SUM(N510:R510)","v":0}]
[null,"2016-05-10","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M511>=40,40-SUM(N509:N510),M511-SUM(N509:N510))","v":0},0,null,null,null,{"$f":"SUM(N511:R511)","v":0}]
[null,"2016-05-11","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M512>=40,40-SUM(N509:N511),M512-SUM(N509:N511))","v":0},0,null,null,null,0]
[null,"2016-05-12","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M513>=40,40-SUM(N509:N512),M513-SUM(N509:N512))","v":0},0,null,null,null,0]
[null,"2016-05-13","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M514>=40,40-SUM(N509:N513),M514-SUM(N509:N513))","v":0},0,null,null,null,0]
[null,"2016-05-14","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M515>=40,40-SUM(N509:N514),M515-SUM(N509:N514))","v":0},0,null,null,null,0]
[null,"2016-05-15","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J516+L516","v":0},{"$f":"IF(M516>=40,40,M516)","v":0},0,null,null,null,0]
[null,"2016-05-16","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M516+J517+L517","v":0},{"$f":"IF(M517>=40,40-N516,M517-N516)","v":0},0,null,null,null,{"$f":"SUM(N517:R517)","v":0}]
[null,"2016-05-17","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M518>=40,40-SUM(N516:N517),M518-SUM(N516:N517))","v":0},0,null,null,null,{"$f":"SUM(N518:R518)","v":0}]
[null,"2016-05-18","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M519>=40,40-SUM(N516:N518),M519-SUM(N516:N518))","v":0},0,null,null,null,{"$f":"SUM(N519:R519)","v":0}]
[null,"2016-05-19","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M520>=40,40-SUM(N516:N519),M520-SUM(N516:N519))","v":0},0,null,null,null,0]
[null,"2016-05-20","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M521>=40,40-SUM(N516:N520),M521-SUM(N516:N520))","v":0},0,null,null,null,0]
[null,"2016-05-21","Saturday",null,null,null,null,null,null,{"$f":"HOUR(I522-H522+G522-F522+E522-D522)","v":0},{"$f":"MINUTE(I522-H522+G522-F522+E522-D522)","v":0},{"$f":"IF(K522=15,0.25,IF(K522=30,0.5,IF(K522=45,0.75,0)))","v":0},0,{"$f":"IF(M522>=40,40-SUM(N516:N521),M522-SUM(N516:N521))","v":0},0,null,null,null,0]
[null,"2016-05-22","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J523+L523","v":0},{"$f":"IF(M523>=40,40,M523)","v":0},0,null,null,null,0]
[null,"2016-05-23","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M523+J524+L524","v":0},{"$f":"IF(M524>=40,40-N523,M524-N523)","v":0},0,null,null,null,{"$f":"SUM(N524:R524)","v":0}]
[null,"2016-05-24","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M525>=40,40-SUM(N523:N524),M525-SUM(N523:N524))","v":0},0,null,null,null,{"$f":"SUM(N525:R525)","v":0}]
[null,"2016-05-25","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M526>=40,40-SUM(N523:N525),M526-SUM(N523:N525))","v":0},0,null,null,null,0]
[null,"2016-05-26","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M527>=40,40-SUM(N523:N526),M527-SUM(N523:N526))","v":0},0,null,null,null,0]
[null,"2016-05-27","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M528>=40,40-SUM(N523:N527),M528-SUM(N523:N527))","v":0},0,null,null,null,0]
[null,"2016-05-28","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M529>=40,40-SUM(N523:N528),M529-SUM(N523:N528))","v":0},0,null,null,null,0]
[null,"2016-05-29","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J530+L530","v":0},{"$f":"IF(M530>=40,40,M530)","v":0},0,null,null,null,0]
[null,"2016-05-30","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M530+J531+L531","v":0},{"$f":"IF(M531>=40,40-N530,M531-N530)","v":0},0,null,null,null,{"$f":"SUM(N531:R531)","v":0}]
[null,"2016-05-31","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M532>=40,40-SUM(N530:N531),M532-SUM(N530:N531))","v":0},0,null,null,null,{"$f":"SUM(N532:R532)","v":0}]
[null,"2016-06-01","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M533>=40,40-SUM(N530:N532),M533-SUM(N530:N532))","v":0},0,null,null,null,{"$f":"SUM(N533:R533)","v":0}]
[null,"2016-06-02","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M534>=40,40-SUM(N530:N533),M534-SUM(N530:N533))","v":0},0,null,null,null,0]
[null,"2016-06-03","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M535>=40,40-SUM(N530:N534),M535-SUM(N530:N534))","v":0},0,null,null,null,0]
[null,"2016-06-04","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M536>=40,40-SUM(N530:N535),M536-SUM(N530:N535))","v":0},0,null,null,null,0]
[null,"2016-06-05","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J537+L537","v":0},{"$f":"IF(M537>=40,40,M537)","v":0},0,null,null,null,0]
[null,"2016-06-06","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M537+J538+L538","v":0},{"$f":"IF(M538>=40,40-N537,M538-N537)","v":0},0,null,null,null,{"$f":"SUM(N538:R538)","v":0}]
[null,"2016-06-07","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M539>=40,40-SUM(N537:N538),M539-SUM(N537:N538))","v":0},0,null,null,null,{"$f":"SUM(N539:R539)","v":0}]
[null,"2016-06-08","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M540>=40,40-SUM(N537:N539),M540-SUM(N537:N539))","v":0},0,null,null,null,0]
[null,"2016-06-09","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M541>=40,40-SUM(N537:N540),M541-SUM(N537:N540))","v":0},0,null,null,null,0]
[null,"2016-06-10","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M542>=40,40-SUM(N537:N541),M542-SUM(N537:N541))","v":0},0,null,null,null,0]
[null,"2016-06-11","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M543>=40,40-SUM(N537:N542),M543-SUM(N537:N542))","v":0},0,null,null,null,0]
[null,"2016-06-12","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J544+L544","v":0},{"$f":"IF(M544>=40,40,M544)","v":0},0,null,null,null,0]
[null,"2016-06-13","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M544+J545+L545","v":0},{"$f":"IF(M545>=40,40-N544,M545-N544)","v":0},0,null,null,null,{"$f":"SUM(N545:R545)","v":0}]
[null,"2016-06-14","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M546>=40,40-SUM(N544:N545),M546-SUM(N544:N545))","v":0},0,null,null,null,{"$f":"SUM(N546:R546)","v":0}]
[null,"2016-06-15","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M547>=40,40-SUM(N544:N546),M547-SUM(N544:N546))","v":0},0,null,null,null,{"$f":"SUM(N547:R547)","v":0}]
[null,"2016-06-16","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M548>=40,40-SUM(N544:N547),M548-SUM(N544:N547))","v":0},0,null,null,null,0]
[null,"2016-06-17","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M549>=40,40-SUM(N544:N548),M549-SUM(N544:N548))","v":0},0,null,null,null,0]
[null,"2016-06-18","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M550>=40,40-SUM(N544:N549),M550-SUM(N544:N549))","v":0},0,null,null,null,0]
[null,"2016-06-19","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J551+L551","v":0},{"$f":"IF(M551>=40,40,M551)","v":0},0,null,null,null,0]
[null,"2016-06-20","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M551+J552+L552","v":0},{"$f":"IF(M552>=40,40-N551,M552-N551)","v":0},0,null,null,null,{"$f":"SUM(N552:R552)","v":0}]
[null,"2016-06-21","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M553>=40,40-SUM(N551:N552),M553-SUM(N551:N552))","v":0},0,null,null,null,{"$f":"SUM(N553:R553)","v":0}]
[null,"2016-06-22","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M554>=40,40-SUM(N551:N553),M554-SUM(N551:N553))","v":0},0,null,null,null,0]
[null,"2016-06-23","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M555>=40,40-SUM(N551:N554),M555-SUM(N551:N554))","v":0},0,null,null,null,0]
[null,"2016-06-24","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M556>=40,40-SUM(N551:N555),M556-SUM(N551:N555))","v":0},0,null,null,null,0]
[null,"2016-06-25","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M557>=40,40-SUM(N551:N556),M557-SUM(N551:N556))","v":0},0,null,null,null,0]
[null,"2016-06-26","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J558+L558","v":0},{"$f":"IF(M558>=40,40,M558)","v":0},0,null,null,null,0]
[null,"2016-06-27","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M558+J559+L559","v":0},{"$f":"IF(M559>=40,40-N558,M559-N558)","v":0},0,null,null,null,{"$f":"SUM(N559:R559)","v":0}]
[null,"2016-06-28","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M560>=40,40-SUM(N558:N559),M560-SUM(N558:N559))","v":0},0,null,null,null,{"$f":"SUM(N560:R560)","v":0}]
[null,"2016-06-29","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M561>=40,40-SUM(N558:N560),M561-SUM(N558:N560))","v":0},0,null,null,null,{"$f":"SUM(N561:R561)","v":0}]
[null,"2016-06-30","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M562>=40,40-SUM(N558:N561),M562-SUM(N558:N561))","v":0},0,null,null,null,0]
[null,"2016-07-01","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M563>=40,40-SUM(N558:N562),M563-SUM(N558:N562))","v":0},0,null,null,null,0]
[null,"2016-07-02","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M564>=40,40-SUM(N558:N563),M564-SUM(N558:N563))","v":0},0,null,null,null,0]
[null,"2016-07-03","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J565+L565","v":0},{"$f":"IF(M565>=40,40,M565)","v":0},0,null,null,null,0]
[null,"2016-07-04","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M565+J566+L566","v":0},{"$f":"IF(M566>=40,40-N565,M566-N565)","v":0},0,null,null,null,{"$f":"SUM(N566:R566)","v":0}]
[null,"2016-07-05","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M567>=40,40-SUM(N565:N566),M567-SUM(N565:N566))","v":0},0,null,null,null,{"$f":"SUM(N567:R567)","v":0}]
[null,"2016-07-06","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M568>=40,40-SUM(N565:N567),M568-SUM(N565:N567))","v":0},0,null,null,null,0]
[null,"2016-07-07","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M569>=40,40-SUM(N565:N568),M569-SUM(N565:N568))","v":0},{"$f":"+J569+L569-N569","v":0},null,null,null,0]
[null,"2016-07-08","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M570>=40,40-SUM(N565:N569),M570-SUM(N565:N569))","v":0},0,null,null,null,0]
[null,"2016-07-09","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M571>=40,40-SUM(N565:N570),M571-SUM(N565:N570))","v":0},0,null,null,null,0]
[null,"2016-07-10","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J572+L572","v":0},{"$f":"IF(M572>=40,40,M572)","v":0},0,null,null,null,0]
[null,"2016-07-11","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M572+J573+L573","v":0},{"$f":"IF(M573>=40,40-N572,M573-N572)","v":0},0,null,null,null,{"$f":"SUM(N573:R573)","v":0}]
[null,"2016-07-12","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M574>=40,40-SUM(N572:N573),M574-SUM(N572:N573))","v":0},0,null,null,null,{"$f":"SUM(N574:R574)","v":0}]
[null,"2016-07-13","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M575>=40,40-SUM(N572:N574),M575-SUM(N572:N574))","v":0},0,null,null,null,{"$f":"SUM(N575:R575)","v":0}]
[null,"2016-07-14","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M576>=40,40-SUM(N572:N575),M576-SUM(N572:N575))","v":0},0,null,null,null,0]
[null,"2016-07-15","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M577>=40,40-SUM(N572:N576),M577-SUM(N572:N576))","v":0},0,null,null,null,0]
[null,"2016-07-16","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M578>=40,40-SUM(N572:N577),M578-SUM(N572:N577))","v":0},0,null,null,null,0]
[null,"2016-07-17","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J579+L579","v":0},{"$f":"IF(M579>=40,40,M579)","v":0},0,null,null,null,0]
[null,"2016-07-18","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M579+J580+L580","v":0},{"$f":"IF(M580>=40,40-N579,M580-N579)","v":0},0,null,null,null,{"$f":"SUM(N580:R580)","v":0}]
[null,"2016-07-19","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M581>=40,40-SUM(N579:N580),M581-SUM(N579:N580))","v":0},0,null,null,null,{"$f":"SUM(N581:R581)","v":0}]
[null,"2016-07-20","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M582>=40,40-SUM(N579:N581),M582-SUM(N579:N581))","v":0},0,null,null,null,0]
[null,"2016-07-21","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M583>=40,40-SUM(N579:N582),M583-SUM(N579:N582))","v":0},0,null,null,null,0]
[null,"2016-07-22","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M584>=40,40-SUM(N579:N583),M584-SUM(N579:N583))","v":0},0,null,null,null,0]
[null,"2016-07-23","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M585>=40,40-SUM(N579:N584),M585-SUM(N579:N584))","v":0},0,null,null,null,0]
[null,"2016-07-24","Sunday",null,null,null,null,null,null,{"$f":"HOUR(I586-H586+G586-F586+E586-D586)","v":0},{"$f":"MINUTE(I586-H586+G586-F586+E586-D586)","v":0},{"$f":"IF(K586=15,0.25,IF(K586=30,0.5,IF(K586=45,0.75,0)))","v":0},{"$f":"+J586+L586","v":0},{"$f":"IF(M586>=40,40,M586)","v":0},0,null,null,null,0]
[null,"2016-07-25","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M586+J587+L587","v":0},{"$f":"IF(M587>=40,40-N586,M587-N586)","v":0},0,null,null,null,{"$f":"SUM(N587:R587)","v":0}]
[null,"2016-07-26","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M588>=40,40-SUM(N586:N587),M588-SUM(N586:N587))","v":0},0,null,null,null,{"$f":"SUM(N588:R588)","v":0}]
[null,"2016-07-27","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M589>=40,40-SUM(N586:N588),M589-SUM(N586:N588))","v":0},0,null,null,null,{"$f":"SUM(N589:R589)","v":0}]
[null,"2016-07-28","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M590>=40,40-SUM(N586:N589),M590-SUM(N586:N589))","v":0},0,null,null,null,0]
[null,"2016-07-29","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M591>=40,40-SUM(N586:N590),M591-SUM(N586:N590))","v":0},0,null,null,null,0]
[null,"2016-07-30","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M592>=40,40-SUM(N586:N591),M592-SUM(N586:N591))","v":0},0,null,null,null,0]
[null,"2016-07-31","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J593+L593","v":0},{"$f":"IF(M593>=40,40,M593)","v":0},0,null,null,null,0]
[null,"2016-08-01","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M593+J594+L594","v":0},{"$f":"IF(M594>=40,40-N593,M594-N593)","v":0},0,null,null,null,{"$f":"SUM(N594:R594)","v":0}]
[null,"2016-08-02","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M595>=40,40-SUM(N593:N594),M595-SUM(N593:N594))","v":0},0,null,null,null,{"$f":"SUM(N595:R595)","v":0}]
[null,"2016-08-03","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M596>=40,40-SUM(N593:N595),M596-SUM(N593:N595))","v":0},0,null,null,null,0]
[null,"2016-08-04","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M597>=40,40-SUM(N593:N596),M597-SUM(N593:N596))","v":0},0,null,null,null,0]
[null,"2016-08-05","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M598>=40,40-SUM(N593:N597),M598-SUM(N593:N597))","v":0},0,null,null,null,0]
[null,"2016-08-06","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M599>=40,40-SUM(N593:N598),M599-SUM(N593:N598))","v":0},0,null,null,null,0]
[null,"2016-08-07","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J600+L600","v":0},{"$f":"IF(M600>=40,40,M600)","v":0},0,null,null,null,0]
[null,"2016-08-08","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M600+J601+L601","v":0},{"$f":"IF(M601>=40,40-N600,M601-N600)","v":0},0,null,null,null,{"$f":"SUM(N601:R601)","v":0}]
[null,"2016-08-09","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M602>=40,40-SUM(N600:N601),M602-SUM(N600:N601))","v":0},0,null,null,null,{"$f":"SUM(N602:R602)","v":0}]
[null,"2016-08-10","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M603>=40,40-SUM(N600:N602),M603-SUM(N600:N602))","v":0},0,null,null,null,{"$f":"SUM(N603:R603)","v":0}]
[null,"2016-08-11","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M604>=40,40-SUM(N600:N603),M604-SUM(N600:N603))","v":0},0,null,null,null,0]
[null,"2016-08-12","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M605>=40,40-SUM(N600:N604),M605-SUM(N600:N604))","v":0},0,null,null,null,0]
[null,"2016-08-13","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M606>=40,40-SUM(N600:N605),M606-SUM(N600:N605))","v":0},0,null,null,null,0]
[null,"2016-08-14","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J607+L607","v":0},{"$f":"IF(M607>=40,40,M607)","v":0},0,null,null,null,0]
[null,"2016-08-15","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M607+J608+L608","v":0},{"$f":"IF(M608>=40,40-N607,M608-N607)","v":0},0,null,null,null,{"$f":"SUM(N608:R608)","v":0}]
[null,"2016-08-16","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M609>=40,40-SUM(N607:N608),M609-SUM(N607:N608))","v":0},0,null,null,null,{"$f":"SUM(N609:R609)","v":0}]
[null,"2016-08-17","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M610>=40,40-SUM(N607:N609),M610-SUM(N607:N609))","v":0},0,null,null,null,0]
[null,"2016-08-18","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M611>=40,40-SUM(N607:N610),M611-SUM(N607:N610))","v":0},0,null,null,null,0]
[null,"2016-08-19","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M612>=40,40-SUM(N607:N611),M612-SUM(N607:N611))","v":0},0,null,null,null,0]
[null,"2016-08-20","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M613>=40,40-SUM(N607:N612),M613-SUM(N607:N612))","v":0},0,null,null,null,0]
[null,"2016-08-21","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J614+L614","v":0},{"$f":"IF(M614>=40,40,M614)","v":0},0,null,null,null,0]
[null,"2016-08-22","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M614+J615+L615","v":0},{"$f":"IF(M615>=40,40-N614,M615-N614)","v":0},0,null,null,null,{"$f":"SUM(N615:R615)","v":0}]
[null,"2016-08-23","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M616>=40,40-SUM(N614:N615),M616-SUM(N614:N615))","v":0},0,null,null,null,{"$f":"SUM(N616:R616)","v":0}]
[null,"2016-08-24","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M617>=40,40-SUM(N614:N616),M617-SUM(N614:N616))","v":0},0,null,null,null,{"$f":"SUM(N617:R617)","v":0}]
[null,"2016-08-25","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M618>=40,40-SUM(N614:N617),M618-SUM(N614:N617))","v":0},0,null,null,null,0]
[null,"2016-08-26","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M619>=40,40-SUM(N614:N618),M619-SUM(N614:N618))","v":0},0,null,null,null,0]
[null,"2016-08-27","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M620>=40,40-SUM(N614:N619),M620-SUM(N614:N619))","v":0},0,null,null,null,0]
[null,"2016-08-28","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J621+L621","v":0},{"$f":"IF(M621>=40,40,M621)","v":0},0,null,null,null,0]
[null,"2016-08-29","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M621+J622+L622","v":0},{"$f":"IF(M622>=40,40-N621,M622-N621)","v":0},0,null,null,null,{"$f":"SUM(N622:R622)","v":0}]
[null,"2016-08-30","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M623>=40,40-SUM(N621:N622),M623-SUM(N621:N622))","v":0},0,null,null,null,{"$f":"SUM(N623:R623)","v":0}]
[null,"2016-08-31","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M624>=40,40-SUM(N621:N623),M624-SUM(N621:N623))","v":0},0,null,null,null,0]
[null,"2016-09-01","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M625>=40,40-SUM(N621:N624),M625-SUM(N621:N624))","v":0},0,null,null,null,0]
[null,"2016-09-02","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M626>=40,40-SUM(N621:N625),M626-SUM(N621:N625))","v":0},0,null,null,null,0]
[null,"2016-09-03","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M627>=40,40-SUM(N621:N626),M627-SUM(N621:N626))","v":0},0,null,null,null,0]
[null,"2016-09-04","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J628+L628","v":0},{"$f":"IF(M628>=40,40,M628)","v":0},0,null,null,null,0]
[null,"2016-09-05","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M628+J629+L629","v":0},{"$f":"IF(M629>=40,40-N628,M629-N628)","v":0},0,null,null,null,{"$f":"SUM(N629:R629)","v":0}]
[null,"2016-09-06","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M630>=40,40-SUM(N628:N629),M630-SUM(N628:N629))","v":0},0,null,null,null,{"$f":"SUM(N630:R630)","v":0}]
[null,"2016-09-07","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M631>=40,40-SUM(N628:N630),M631-SUM(N628:N630))","v":0},0,null,null,null,{"$f":"SUM(N631:R631)","v":0}]
[null,"2016-09-08","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M632>=40,40-SUM(N628:N631),M632-SUM(N628:N631))","v":0},0,null,null,null,0]
[null,"2016-09-09","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M633>=40,40-SUM(N628:N632),M633-SUM(N628:N632))","v":0},{"$f":"+J633+L633-N633","v":0},null,null,null,0]
[null,"2016-09-10","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M634>=40,40-SUM(N628:N633),M634-SUM(N628:N633))","v":0},0,null,null,null,0]
[null,"2016-09-11","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J635+L635","v":0},{"$f":"IF(M635>=40,40,M635)","v":0},0,null,null,null,0]
[null,"2016-09-12","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M635+J636+L636","v":0},{"$f":"IF(M636>=40,40-N635,M636-N635)","v":0},0,null,null,null,{"$f":"SUM(N636:R636)","v":0}]
[null,"2016-09-13","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M637>=40,40-SUM(N635:N636),M637-SUM(N635:N636))","v":0},0,null,null,null,{"$f":"SUM(N637:R637)","v":0}]
[null,"2016-09-14","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M638>=40,40-SUM(N635:N637),M638-SUM(N635:N637))","v":0},0,null,null,null,0]
[null,"2016-09-15","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M639>=40,40-SUM(N635:N638),M639-SUM(N635:N638))","v":0},0,null,null,null,0]
[null,"2016-09-16","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M640>=40,40-SUM(N635:N639),M640-SUM(N635:N639))","v":0},0,null,null,null,0]
[null,"2016-09-17","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M641>=40,40-SUM(N635:N640),M641-SUM(N635:N640))","v":0},0,null,null,null,0]
[null,"2016-09-18","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J642+L642","v":0},{"$f":"IF(M642>=40,40,M642)","v":0},0,null,null,null,0]
[null,"2016-09-19","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M642+J643+L643","v":0},{"$f":"IF(M643>=40,40-N642,M643-N642)","v":0},0,null,null,null,{"$f":"SUM(N643:R643)","v":0}]
[null,"2016-09-20","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M644>=40,40-SUM(N642:N643),M644-SUM(N642:N643))","v":0},0,null,null,null,{"$f":"SUM(N644:R644)","v":0}]
[null,"2016-09-21","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M645>=40,40-SUM(N642:N644),M645-SUM(N642:N644))","v":0},0,null,null,null,{"$f":"SUM(N645:R645)","v":0}]
[null,"2016-09-22","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M646>=40,40-SUM(N642:N645),M646-SUM(N642:N645))","v":0},0,null,null,null,0]
[null,"2016-09-23","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M647>=40,40-SUM(N642:N646),M647-SUM(N642:N646))","v":0},0,null,null,null,0]
[null,"2016-09-24","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M648>=40,40-SUM(N642:N647),M648-SUM(N642:N647))","v":0},0,null,null,null,0]
[null,"2016-09-25","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J649+L649","v":0},{"$f":"IF(M649>=40,40,M649)","v":0},0,null,null,null,0]
[null,"2016-09-26","Monday",null,null,null,null,null,null,{"$f":"HOUR(I650-H650+G650-F650+E650-D650)","v":0},{"$f":"MINUTE(I650-H650+G650-F650+E650-D650)","v":0},{"$f":"IF(K650=15,0.25,IF(K650=30,0.5,IF(K650=45,0.75,0)))","v":0},{"$f":"+M649+J650+L650","v":0},{"$f":"IF(M650>=40,40-N649,M650-N649)","v":0},0,null,null,null,{"$f":"SUM(N650:R650)","v":0}]
[null,"2016-09-27","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M651>=40,40-SUM(N649:N650),M651-SUM(N649:N650))","v":0},0,null,null,null,{"$f":"SUM(N651:R651)","v":0}]
[null,"2016-09-28","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M652>=40,40-SUM(N649:N651),M652-SUM(N649:N651))","v":0},0,null,null,null,0]
[null,"2016-09-29","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M653>=40,40-SUM(N649:N652),M653-SUM(N649:N652))","v":0},0,null,null,null,0]
[null,"2016-09-30","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M654>=40,40-SUM(N649:N653),M654-SUM(N649:N653))","v":0},0,null,null,null,0]
[null,"2016-10-01","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M655>=40,40-SUM(N649:N654),M655-SUM(N649:N654))","v":0},0,null,null,null,0]
[null,"2016-10-02","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J656+L656","v":0},{"$f":"IF(M656>=40,40,M656)","v":0},0,null,null,null,0]
[null,"2016-10-03","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M656+J657+L657","v":0},{"$f":"IF(M657>=40,40-N656,M657-N656)","v":0},0,null,null,null,{"$f":"SUM(N657:R657)","v":0}]
[null,"2016-10-04","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M658>=40,40-SUM(N656:N657),M658-SUM(N656:N657))","v":0},0,null,null,null,{"$f":"SUM(N658:R658)","v":0}]
[null,"2016-10-05","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M659>=40,40-SUM(N656:N658),M659-SUM(N656:N658))","v":0},0,null,null,null,{"$f":"SUM(N659:R659)","v":0}]
[null,"2016-10-06","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M660>=40,40-SUM(N656:N659),M660-SUM(N656:N659))","v":0},0,null,null,null,0]
[null,"2016-10-07","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M661>=40,40-SUM(N656:N660),M661-SUM(N656:N660))","v":0},0,null,null,null,0]
[null,"2016-10-08","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M662>=40,40-SUM(N656:N661),M662-SUM(N656:N661))","v":0},0,null,null,null,0]
[null,"2016-10-09","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J663+L663","v":0},{"$f":"IF(M663>=40,40,M663)","v":0},0,null,null,null,0]
[null,"2016-10-10","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M663+J664+L664","v":0},{"$f":"IF(M664>=40,40-N663,M664-N663)","v":0},0,null,null,null,{"$f":"SUM(N664:R664)","v":0}]
[null,"2016-10-11","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M665>=40,40-SUM(N663:N664),M665-SUM(N663:N664))","v":0},0,null,null,null,{"$f":"SUM(N665:R665)","v":0}]
[null,"2016-10-12","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M666>=40,40-SUM(N663:N665),M666-SUM(N663:N665))","v":0},0,null,null,null,0]
[null,"2016-10-13","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M667>=40,40-SUM(N663:N666),M667-SUM(N663:N666))","v":0},0,null,null,null,0]
[null,"2016-10-14","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M668>=40,40-SUM(N663:N667),M668-SUM(N663:N667))","v":0},0,null,null,null,0]
[null,"2016-10-15","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M669>=40,40-SUM(N663:N668),M669-SUM(N663:N668))","v":0},0,null,null,null,0]
[null,"2016-10-16","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J670+L670","v":0},{"$f":"IF(M670>=40,40,M670)","v":0},0,null,null,null,0]
[null,"2016-10-17","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M670+J671+L671","v":0},{"$f":"IF(M671>=40,40-N670,M671-N670)","v":0},0,null,null,null,{"$f":"SUM(N671:R671)","v":0}]
[null,"2016-10-18","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M672>=40,40-SUM(N670:N671),M672-SUM(N670:N671))","v":0},0,null,null,null,{"$f":"SUM(N672:R672)","v":0}]
[null,"2016-10-19","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M673>=40,40-SUM(N670:N672),M673-SUM(N670:N672))","v":0},0,null,null,null,{"$f":"SUM(N673:R673)","v":0}]
[null,"2016-10-20","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M674>=40,40-SUM(N670:N673),M674-SUM(N670:N673))","v":0},0,null,null,null,0]
[null,"2016-10-21","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M675>=40,40-SUM(N670:N674),M675-SUM(N670:N674))","v":0},0,null,null,null,0]
[null,"2016-10-22","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M676>=40,40-SUM(N670:N675),M676-SUM(N670:N675))","v":0},0,null,null,null,0]
[null,"2016-10-23","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J677+L677","v":0},{"$f":"IF(M677>=40,40,M677)","v":0},0,null,null,null,0]
[null,"2016-10-24","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M677+J678+L678","v":0},{"$f":"IF(M678>=40,40-N677,M678-N677)","v":0},0,null,null,null,{"$f":"SUM(N678:R678)","v":0}]
[null,"2016-10-25","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M679>=40,40-SUM(N677:N678),M679-SUM(N677:N678))","v":0},0,null,null,null,{"$f":"SUM(N679:R679)","v":0}]
[null,"2016-10-26","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M680>=40,40-SUM(N677:N679),M680-SUM(N677:N679))","v":0},0,null,null,null,0]
[null,"2016-10-27","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M681>=40,40-SUM(N677:N680),M681-SUM(N677:N680))","v":0},0,null,null,null,0]
[null,"2016-10-28","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M682>=40,40-SUM(N677:N681),M682-SUM(N677:N681))","v":0},0,null,null,null,0]
[null,"2016-10-29","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M683>=40,40-SUM(N677:N682),M683-SUM(N677:N682))","v":0},0,null,null,null,0]
[null,"2016-10-30","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J684+L684","v":0},{"$f":"IF(M684>=40,40,M684)","v":0},0,null,null,null,0]
[null,"2016-10-31","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M684+J685+L685","v":0},{"$f":"IF(M685>=40,40-N684,M685-N684)","v":0},0,null,null,null,{"$f":"SUM(N685:R685)","v":0}]
[null,"2016-11-01","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M686>=40,40-SUM(N684:N685),M686-SUM(N684:N685))","v":0},0,null,null,null,{"$f":"SUM(N686:R686)","v":0}]
[null,"2016-11-02","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M687>=40,40-SUM(N684:N686),M687-SUM(N684:N686))","v":0},0,null,null,null,{"$f":"SUM(N687:R687)","v":0}]
[null,"2016-11-03","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M688>=40,40-SUM(N684:N687),M688-SUM(N684:N687))","v":0},0,null,null,null,0]
[null,"2016-11-04","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M689>=40,40-SUM(N684:N688),M689-SUM(N684:N688))","v":0},0,null,null,null,0]
[null,"2016-11-05","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M690>=40,40-SUM(N684:N689),M690-SUM(N684:N689))","v":0},0,null,null,null,0]
[null,"2016-11-06","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J691+L691","v":0},{"$f":"IF(M691>=40,40,M691)","v":0},0,null,null,null,0]
[null,"2016-11-07","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M691+J692+L692","v":0},{"$f":"IF(M692>=40,40-N691,M692-N691)","v":0},0,null,null,null,{"$f":"SUM(N692:R692)","v":0}]
[null,"2016-11-08","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M693>=40,40-SUM(N691:N692),M693-SUM(N691:N692))","v":0},0,null,null,null,{"$f":"SUM(N693:R693)","v":0}]
[null,"2016-11-09","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M694>=40,40-SUM(N691:N693),M694-SUM(N691:N693))","v":0},0,null,null,null,0]
[null,"2016-11-10","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M695>=40,40-SUM(N691:N694),M695-SUM(N691:N694))","v":0},0,null,null,null,0]
[null,"2016-11-11","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M696>=40,40-SUM(N691:N695),M696-SUM(N691:N695))","v":0},0,null,null,null,0]
[null,"2016-11-12","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M697>=40,40-SUM(N691:N696),M697-SUM(N691:N696))","v":0},{"$f":"+J697+L697-N697","v":0},null,null,null,0]
[null,"2016-11-13","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J698+L698","v":0},{"$f":"IF(M698>=40,40,M698)","v":0},0,null,null,null,0]
[null,"2016-11-14","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M698+J699+L699","v":0},{"$f":"IF(M699>=40,40-N698,M699-N698)","v":0},0,null,null,null,{"$f":"SUM(N699:R699)","v":0}]
[null,"2016-11-15","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M700>=40,40-SUM(N698:N699),M700-SUM(N698:N699))","v":0},0,null,null,null,{"$f":"SUM(N700:R700)","v":0}]
[null,"2016-11-16","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M701>=40,40-SUM(N698:N700),M701-SUM(N698:N700))","v":0},0,null,null,null,{"$f":"SUM(N701:R701)","v":0}]
[null,"2016-11-17","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M702>=40,40-SUM(N698:N701),M702-SUM(N698:N701))","v":0},0,null,null,null,0]
[null,"2016-11-18","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M703>=40,40-SUM(N698:N702),M703-SUM(N698:N702))","v":0},0,null,null,null,0]
[null,"2016-11-19","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M704>=40,40-SUM(N698:N703),M704-SUM(N698:N703))","v":0},0,null,null,null,0]
[null,"2016-11-20","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J705+L705","v":0},{"$f":"IF(M705>=40,40,M705)","v":0},0,null,null,null,0]
[null,"2016-11-21","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M705+J706+L706","v":0},{"$f":"IF(M706>=40,40-N705,M706-N705)","v":0},0,null,null,null,{"$f":"SUM(N706:R706)","v":0}]
[null,"2016-11-22","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M707>=40,40-SUM(N705:N706),M707-SUM(N705:N706))","v":0},0,null,null,null,{"$f":"SUM(N707:R707)","v":0}]
[null,"2016-11-23","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M708>=40,40-SUM(N705:N707),M708-SUM(N705:N707))","v":0},0,null,null,null,0]
[null,"2016-11-24","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M709>=40,40-SUM(N705:N708),M709-SUM(N705:N708))","v":0},0,null,null,null,0]
[null,"2016-11-25","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M710>=40,40-SUM(N705:N709),M710-SUM(N705:N709))","v":0},0,null,null,null,0]
[null,"2016-11-26","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M711>=40,40-SUM(N705:N710),M711-SUM(N705:N710))","v":0},0,null,null,null,0]
[null,"2016-11-27","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J712+L712","v":0},{"$f":"IF(M712>=40,40,M712)","v":0},0,null,null,null,0]
[null,"2016-11-28","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M712+J713+L713","v":0},{"$f":"IF(M713>=40,40-N712,M713-N712)","v":0},0,null,null,null,{"$f":"SUM(N713:R713)","v":0}]
[null,"2016-11-29","Tuesday",null,null,null,null,null,null,{"$f":"HOUR(I714-H714+G714-F714+E714-D714)","v":0},{"$f":"MINUTE(I714-H714+G714-F714+E714-D714)","v":0},{"$f":"IF(K714=15,0.25,IF(K714=30,0.5,IF(K714=45,0.75,0)))","v":0},0,{"$f":"IF(M714>=40,40-SUM(N712:N713),M714-SUM(N712:N713))","v":0},0,null,null,null,{"$f":"SUM(N714:R714)","v":0}]
[null,"2016-11-30","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M715>=40,40-SUM(N712:N714),M715-SUM(N712:N714))","v":0},0,null,null,null,{"$f":"SUM(N715:R715)","v":0}]
[null,"2016-12-01","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M716>=40,40-SUM(N712:N715),M716-SUM(N712:N715))","v":0},0,null,null,null,0]
[null,"2016-12-02","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M717>=40,40-SUM(N712:N716),M717-SUM(N712:N716))","v":0},0,null,null,null,0]
[null,"2016-12-03","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M718>=40,40-SUM(N712:N717),M718-SUM(N712:N717))","v":0},0,null,null,null,0]
[null,"2016-12-04","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J719+L719","v":0},{"$f":"IF(M719>=40,40,M719)","v":0},0,null,null,null,0]
[null,"2016-12-05","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M719+J720+L720","v":0},{"$f":"IF(M720>=40,40-N719,M720-N719)","v":0},0,null,null,null,{"$f":"SUM(N720:R720)","v":0}]
[null,"2016-12-06","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M721>=40,40-SUM(N719:N720),M721-SUM(N719:N720))","v":0},0,null,null,null,{"$f":"SUM(N721:R721)","v":0}]
[null,"2016-12-07","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M722>=40,40-SUM(N719:N721),M722-SUM(N719:N721))","v":0},0,null,null,null,0]
[null,"2016-12-08","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M723>=40,40-SUM(N719:N722),M723-SUM(N719:N722))","v":0},0,null,null,null,0]
[null,"2016-12-09","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M724>=40,40-SUM(N719:N723),M724-SUM(N719:N723))","v":0},0,null,null,null,0]
[null,"2016-12-10","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M725>=40,40-SUM(N719:N724),M725-SUM(N719:N724))","v":0},0,null,null,null,0]
[null,"2016-12-11","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J726+L726","v":0},{"$f":"IF(M726>=40,40,M726)","v":0},0,null,null,null,0]
[null,"2016-12-12","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M726+J727+L727","v":0},{"$f":"IF(M727>=40,40-N726,M727-N726)","v":0},0,null,null,null,{"$f":"SUM(N727:R727)","v":0}]
[null,"2016-12-13","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M728>=40,40-SUM(N726:N727),M728-SUM(N726:N727))","v":0},0,null,null,null,{"$f":"SUM(N728:R728)","v":0}]
[null,"2016-12-14","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M729>=40,40-SUM(N726:N728),M729-SUM(N726:N728))","v":0},0,null,null,null,{"$f":"SUM(N729:R729)","v":0}]
[null,"2016-12-15","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M730>=40,40-SUM(N726:N729),M730-SUM(N726:N729))","v":0},0,null,null,null,0]
[null,"2016-12-16","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M731>=40,40-SUM(N726:N730),M731-SUM(N726:N730))","v":0},0,null,null,null,0]
[null,"2016-12-17","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M732>=40,40-SUM(N726:N731),M732-SUM(N726:N731))","v":0},0,null,null,null,0]
[null,"2016-12-18","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J733+L733","v":0},{"$f":"IF(M733>=40,40,M733)","v":0},0,null,null,null,0]
[null,"2016-12-19","Monday",null,null,null,null,null,null,0,0,0,{"$f":"+M733+J734+L734","v":0},{"$f":"IF(M734>=40,40-N733,M734-N733)","v":0},0,null,null,null,{"$f":"SUM(N734:R734)","v":0}]
[null,"2016-12-20","Tuesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M735>=40,40-SUM(N733:N734),M735-SUM(N733:N734))","v":0},0,null,null,null,{"$f":"SUM(N735:R735)","v":0}]
[null,"2016-12-21","Wednesday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M736>=40,40-SUM(N733:N735),M736-SUM(N733:N735))","v":0},0,null,null,null,0]
[null,"2016-12-22","Thursday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M737>=40,40-SUM(N733:N736),M737-SUM(N733:N736))","v":0},0,null,null,null,0]
[null,"2016-12-23","Friday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M738>=40,40-SUM(N733:N737),M738-SUM(N733:N737))","v":0},0,null,null,null,0]
[null,"2016-12-24","Saturday",null,null,null,null,null,null,0,0,0,0,{"$f":"IF(M739>=40,40-SUM(N733:N738),M739-SUM(N733:N738))","v":0},0,null,null,null,0]
[null,"2016-12-25","Sunday",null,null,null,null,null,null,0,0,0,{"$f":"+J740+L740","v":0},{"$f":"IF(M740>=40,40,M740)","v":0},0,null,null,null,0]

{"sheet":"Pay sheet","index":2,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[7,2,7,7],[28,12,28,13]]}
["THE MOUNTAINEERS  "]
["Time Sheet - Non Exempt"]
[]
["Name",null,{"$f":"+'Time Tracking'!D3","v":"[enter name here]"},null,null,null,null,null,null,null,"Dept",{"$f":"+'Time Tracking'!Q3","v":"[enter department here]"}]
[]
["Pay period",null,"2015-03-11","to","2015-03-25"]
[]
[null,null,"REGULAR HOURS"]
["Day","Date","In","Out","In","Out","In","Out","ST","OT","Sick","Vac","Hol","Total Hrs","Comments"]
[{"$f":"VLOOKUP(B10,'Time Tracking'!$B$10:$C$19270,2)","v":"Wednesday"},{"$f":"+C6","v":"2015-03-11"},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,5)","v":"00:00:00"},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B10,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B11,'Time Tracking'!$B$10:$C$19270,2)","v":"Thursday"},{"$f":"1+B10","v":"2015-03-12"},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"LOOKUP($B11,'Time Tracking'!$B$10:$B$19270,'Time Tracking'!$F$10:$F$19270)","v":"00:00:00"},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B11,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B12,'Time Tracking'!$B$10:$C$19270,2)","v":"Friday"},{"$f":"1+B11","v":"2015-03-13"},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B12,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B13,'Time Tracking'!$B$10:$C$19270,2)","v":"Saturday"},"2015-03-14",{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B13,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B14,'Time Tracking'!$B$10:$C$19270,2)","v":"Sunday"},"2015-03-15",{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B14,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B15,'Time Tracking'!$B$10:$C$19270,2)","v":"Monday"},"2015-03-16",{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B15,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B16,'Time Tracking'!$B$10:$C$19270,2)","v":"Tuesday"},"2015-03-17",{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B16,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B17,'Time Tracking'!$B$10:$C$19270,2)","v":"Wednesday"},"2015-03-18",{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B17,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B18,'Time Tracking'!$B$10:$C$19270,2)","v":"Thursday"},"2015-03-19",{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B18,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B19,'Time Tracking'!$B$10:$C$19270,2)","v":"Friday"},"2015-03-20",{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B19,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B20,'Time Tracking'!$B$10:$C$19270,2)","v":"Saturday"},"2015-03-21",{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B20,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B21,'Time Tracking'!$B$10:$C$19270,2)","v":"Sunday"},"2015-03-22",{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B21,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B22,'Time Tracking'!$B$10:$C$19270,2)","v":"Monday"},"2015-03-23",{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B22,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B23,'Time Tracking'!$B$10:$C$19270,2)","v":"Tuesday"},"2015-03-24",{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B23,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"VLOOKUP(B24,'Time Tracking'!$B$10:$C$19270,2)","v":"Wednesday"},"2015-03-25",{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,5,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,6,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,8,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,13,FALSE)","v":0},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,14,FALSE)","v":0},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,15,FALSE)","v":0},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,16,FALSE)","v":0},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,17,FALSE)","v":0},{"$f":"VLOOKUP($B24,'Time Tracking'!$B$10:$T$19270,18,FALSE)","v":0}]
[{"$f":"IF(ISERROR(VLOOKUP(B25,'Time Tracking'!$B$10:$C$19270,2)),\"\",(VLOOKUP(B25,'Time Tracking'!$B$10:$C$19270,2)))","v":""},{"$f":"IF(B24=E6,,(B24+1))","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,3,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,3,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,4,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,4,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,5,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,5,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,6,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,6,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,7,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,7,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,8,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,8,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,13,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,13,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,14,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,14,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,15,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,15,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,16,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,16,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,17,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,17,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,18,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,18,FALSE)))","v":""},{"$f":"IF(ISERROR(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,19,FALSE)),\"\",(VLOOKUP($B25,'Time Tracking'!$B$10:$T$19270,19,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I10:I25)","v":0},0,0,0,0,0]
[]
[]
["Employee Signature:",null,null,null,null,null,null,null,null,null,null,null,"For PR Use Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Reg hrs",{"$f":"+I26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"OT",{"$f":"+J26","v":0}]
["Supervisor Signature:",null,null,null,null,null,null,null,null,null,null,null,"Sick",{"$f":"K26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vacation",{"$f":"L26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Holiday",{"$f":"+M26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N30:N34)","v":0}]

{"sheet":"Deadlines","index":3,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["PayBegin","PayEnd"]
["2014-12-26","2015-01-10"]
[{"$f":"+B2+1","v":"2015-01-11"},{"$f":"+A3+14","v":"2015-01-25"}]
[{"$f":"+B3+1","v":"2015-01-26"},{"$f":"+A4+15","v":"2015-02-10"}]
["2015-02-11",{"$f":"+A5+14","v":"2015-02-25"}]
["2015-02-26",{"$f":"+A6+12","v":"2015-03-10"}]
["2015-03-11",{"$f":"+A7+14","v":"2015-03-25"}]
["2015-03-26",{"$f":"+A8+15","v":"2015-04-10"}]
["2015-04-11",{"$f":"+A9+14","v":"2015-04-25"}]
["2015-04-26","2015-05-10"]
["2015-05-11","2015-05-25"]
["2015-05-26",{"$f":"+A12+15","v":"2015-06-10"}]
["2015-06-11","2015-06-25"]
["2015-06-26","2015-07-10"]
["2015-07-11","2015-07-25"]
["2015-07-26",{"$f":"+A16+15","v":"2015-08-10"}]
["2015-08-11","2015-08-25"]
["2015-08-26",{"$f":"+A18+15","v":"2015-09-10"}]
["2015-09-11","2015-09-25"]
["2015-09-26","2015-10-10"]
["2015-10-11","2015-10-25"]
["2015-10-26",{"$f":"+A22+15","v":"2015-11-10"}]
["2015-11-11","2015-11-25"]
["2015-11-26","2015-12-10"]
["2015-12-11","2015-12-25"]
["2015-12-26",{"$f":"+A26+15","v":"2016-01-10"}]
["2016-01-11","2016-01-25"]
["2016-01-26",{"$f":"+A28+15","v":"2016-02-10"}]
["2016-02-11","2016-02-25"]
["2016-02-26",{"$f":"+A30+13","v":"2016-03-10"}]
["2016-03-11","2016-03-25"]
["2016-03-26",{"$f":"+A32+15","v":"2016-04-10"}]
[{"$f":"+B32+1","v":"2016-04-11"},{"$f":"+A33+14","v":"2016-04-25"}]
["2016-04-26",{"$f":"+A34+14","v":"2016-05-10"}]
[{"$f":"+B34+1","v":"2016-05-11"},{"$f":"+A35+14","v":"2016-05-25"}]
["2016-05-26",{"$f":"+A36+15","v":"2016-06-10"}]
["2016-06-11","2016-06-25"]
["2016-06-26","2016-07-10"]
["2016-07-11","2016-07-25"]
["2016-07-26",{"$f":"+A40+15","v":"2016-08-10"}]
["2016-08-11","2016-08-25"]
["2016-08-26",{"$f":"+A42+15","v":"2016-09-10"}]
["2016-09-11","2016-09-25"]
["2016-09-26","2016-10-10"]
["2016-10-11","2016-10-25"]
["2016-10-26",{"$f":"+A46+15","v":"2016-11-10"}]
["2016-11-11","2016-11-25"]
["2016-11-26","2016-12-10"]
["2016-12-11","2016-12-25"]