{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Year-to-date summary","1st Q","2nd Q","3rd Q","4th Q"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Year-to-date summary","index":0,"n_rows":37,"n_cols":13,"rows_kept":37}
[null,"Olson Harris Ltd. | Confidential"]
[null,"Attendance tracking: "]
[null,"Year-to-date summary"]
[null,"Date"]
[]
[null,"Last name","First name","Vacation","Personal","Sick","SSN","Position","Supervisor","Hire date","Comments","Vacation days \nper year","Vacation days \nremaining"]
[null,"Hughes","Shawn",{"$f":"SUM('1st Q:4th Q'!D7)","v":3},{"$f":"SUM('1st Q:4th Q'!E7)","v":1},{"$f":"SUM('1st Q:4th Q'!F7)","v":1},"xxx-xx-4321","Manager","Name",null,null,10,{"$f":"L7-D7","v":7}]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D8)","v":0},{"$f":"SUM('1st Q:4th Q'!E8)","v":0},{"$f":"SUM('1st Q:4th Q'!F8)","v":0},{"$nulls":6},{"$f":"L8-D8","v":0}]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D9)","v":0},{"$f":"SUM('1st Q:4th Q'!E9)","v":0},{"$f":"SUM('1st Q:4th Q'!F9)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D10)","v":0},{"$f":"SUM('1st Q:4th Q'!E10)","v":0},{"$f":"SUM('1st Q:4th Q'!F10)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D11)","v":0},{"$f":"SUM('1st Q:4th Q'!E11)","v":0},{"$f":"SUM('1st Q:4th Q'!F11)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D12)","v":0},{"$f":"SUM('1st Q:4th Q'!E12)","v":0},{"$f":"SUM('1st Q:4th Q'!F12)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D13)","v":0},{"$f":"SUM('1st Q:4th Q'!E13)","v":0},{"$f":"SUM('1st Q:4th Q'!F13)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D14)","v":0},{"$f":"SUM('1st Q:4th Q'!E14)","v":0},{"$f":"SUM('1st Q:4th Q'!F14)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D15)","v":0},{"$f":"SUM('1st Q:4th Q'!E15)","v":0},{"$f":"SUM('1st Q:4th Q'!F15)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D16)","v":0},{"$f":"SUM('1st Q:4th Q'!E16)","v":0},{"$f":"SUM('1st Q:4th Q'!F16)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D17)","v":0},{"$f":"SUM('1st Q:4th Q'!E17)","v":0},{"$f":"SUM('1st Q:4th Q'!F17)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D18)","v":0},{"$f":"SUM('1st Q:4th Q'!E18)","v":0},{"$f":"SUM('1st Q:4th Q'!F18)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D19)","v":0},{"$f":"SUM('1st Q:4th Q'!E19)","v":0},{"$f":"SUM('1st Q:4th Q'!F19)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D20)","v":0},{"$f":"SUM('1st Q:4th Q'!E20)","v":0},{"$f":"SUM('1st Q:4th Q'!F20)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D21)","v":0},{"$f":"SUM('1st Q:4th Q'!E21)","v":0},{"$f":"SUM('1st Q:4th Q'!F21)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D22)","v":0},{"$f":"SUM('1st Q:4th Q'!E22)","v":0},{"$f":"SUM('1st Q:4th Q'!F22)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D23)","v":0},{"$f":"SUM('1st Q:4th Q'!E23)","v":0},{"$f":"SUM('1st Q:4th Q'!F23)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D24)","v":0},{"$f":"SUM('1st Q:4th Q'!E24)","v":0},{"$f":"SUM('1st Q:4th Q'!F24)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D25)","v":0},{"$f":"SUM('1st Q:4th Q'!E25)","v":0},{"$f":"SUM('1st Q:4th Q'!F25)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D26)","v":0},{"$f":"SUM('1st Q:4th Q'!E26)","v":0},{"$f":"SUM('1st Q:4th Q'!F26)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D27)","v":0},{"$f":"SUM('1st Q:4th Q'!E27)","v":0},{"$f":"SUM('1st Q:4th Q'!F27)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D28)","v":0},{"$f":"SUM('1st Q:4th Q'!E28)","v":0},{"$f":"SUM('1st Q:4th Q'!F28)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D29)","v":0},{"$f":"SUM('1st Q:4th Q'!E29)","v":0},{"$f":"SUM('1st Q:4th Q'!F29)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D30)","v":0},{"$f":"SUM('1st Q:4th Q'!E30)","v":0},{"$f":"SUM('1st Q:4th Q'!F30)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D31)","v":0},{"$f":"SUM('1st Q:4th Q'!E31)","v":0},{"$f":"SUM('1st Q:4th Q'!F31)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D32)","v":0},{"$f":"SUM('1st Q:4th Q'!E32)","v":0},{"$f":"SUM('1st Q:4th Q'!F32)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D33)","v":0},{"$f":"SUM('1st Q:4th Q'!E33)","v":0},{"$f":"SUM('1st Q:4th Q'!F33)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D34)","v":0},{"$f":"SUM('1st Q:4th Q'!E34)","v":0},{"$f":"SUM('1st Q:4th Q'!F34)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D35)","v":0},{"$f":"SUM('1st Q:4th Q'!E35)","v":0},{"$f":"SUM('1st Q:4th Q'!F35)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D36)","v":0},{"$f":"SUM('1st Q:4th Q'!E36)","v":0},{"$f":"SUM('1st Q:4th Q'!F36)","v":0},{"$nulls":6},0]
[{"$nulls":3},{"$f":"SUM('1st Q:4th Q'!D37)","v":0},{"$f":"SUM('1st Q:4th Q'!E37)","v":0},{"$f":"SUM('1st Q:4th Q'!F37)","v":0},{"$nulls":6},0]

{"sheet":"1st Q","index":1,"n_rows":37,"n_cols":96,"rows_kept":37}
[null,{"$f":"Company_Name","v":"Olson Harris Ltd. | Confidential"}]
[null,"Attendance tracking: "]
[null,"1st quarter"]
[null,"Date"]
[]
[null,"Last Name","First Name","Vacation","Personal","Sick","1/1","1/2","1/3","1/4","1/5","1/6","1/7","1/8","1/9","1/10","1/11","1/12","1/13","1/14","1/15","1/16","1/17","1/18","1/19","1/20","1/21","1/22","1/23","1/24","1/25","1/26","1/27","1/28","1/29","1/30","1/31","2/1","2/2","2/3","2/4","2/5","2/6","2/7","2/8","2/9","2/10","2/11","2/12","2/13","2/14","2/15","2/16","2/17","2/18","2/19","2/20","2/21","2/22","2/23","2/24","2/25","2/26","2/27","2/28","3/1","3/2","3/3","3/4","3/5","3/6","3/7","3/8","3/9","3/10","3/11","3/12","3/13","3/14","3/15","3/16","3/17","3/18","3/19","3/20","3/21","3/22","3/23","3/24","3/25","3/26","3/27","3/28","3/29","3/30","3/31"]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B7),\"\",'Year-to-date summary'!B7)","v":"Hughes"},{"$f":"IF(ISBLANK('Year-to-date summary'!C7),\"\",'Year-to-date summary'!C7)","v":"Shawn"},{"$f":"COUNTIF($G7:$CR7, \"V\")","v":3},{"$f":"COUNTIF($G7:$CR7, \"P\")","v":1},{"$f":"COUNTIF($G7:$CR7, \"S\")","v":1},"v","v","v",null,null,"p",null,"s"]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B8),\"\",'Year-to-date summary'!B8)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C8),\"\",'Year-to-date summary'!C8)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B9),\"\",'Year-to-date summary'!B9)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C9),\"\",'Year-to-date summary'!C9)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B10),\"\",'Year-to-date summary'!B10)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C10),\"\",'Year-to-date summary'!C10)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B11),\"\",'Year-to-date summary'!B11)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C11),\"\",'Year-to-date summary'!C11)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B12),\"\",'Year-to-date summary'!B12)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C12),\"\",'Year-to-date summary'!C12)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B13),\"\",'Year-to-date summary'!B13)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C13),\"\",'Year-to-date summary'!C13)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B14),\"\",'Year-to-date summary'!B14)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C14),\"\",'Year-to-date summary'!C14)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B15),\"\",'Year-to-date summary'!B15)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C15),\"\",'Year-to-date summary'!C15)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B16),\"\",'Year-to-date summary'!B16)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C16),\"\",'Year-to-date summary'!C16)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B17),\"\",'Year-to-date summary'!B17)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C17),\"\",'Year-to-date summary'!C17)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B18),\"\",'Year-to-date summary'!B18)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C18),\"\",'Year-to-date summary'!C18)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B19),\"\",'Year-to-date summary'!B19)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C19),\"\",'Year-to-date summary'!C19)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B20),\"\",'Year-to-date summary'!B20)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C20),\"\",'Year-to-date summary'!C20)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B21),\"\",'Year-to-date summary'!B21)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C21),\"\",'Year-to-date summary'!C21)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B22),\"\",'Year-to-date summary'!B22)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C22),\"\",'Year-to-date summary'!C22)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B23),\"\",'Year-to-date summary'!B23)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C23),\"\",'Year-to-date summary'!C23)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B24),\"\",'Year-to-date summary'!B24)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C24),\"\",'Year-to-date summary'!C24)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B25),\"\",'Year-to-date summary'!B25)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C25),\"\",'Year-to-date summary'!C25)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B26),\"\",'Year-to-date summary'!B26)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C26),\"\",'Year-to-date summary'!C26)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B27),\"\",'Year-to-date summary'!B27)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C27),\"\",'Year-to-date summary'!C27)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B28),\"\",'Year-to-date summary'!B28)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C28),\"\",'Year-to-date summary'!C28)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B29),\"\",'Year-to-date summary'!B29)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C29),\"\",'Year-to-date summary'!C29)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B30),\"\",'Year-to-date summary'!B30)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C30),\"\",'Year-to-date summary'!C30)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B31),\"\",'Year-to-date summary'!B31)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C31),\"\",'Year-to-date summary'!C31)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B32),\"\",'Year-to-date summary'!B32)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C32),\"\",'Year-to-date summary'!C32)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B33),\"\",'Year-to-date summary'!B33)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C33),\"\",'Year-to-date summary'!C33)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B34),\"\",'Year-to-date summary'!B34)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C34),\"\",'Year-to-date summary'!C34)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B35),\"\",'Year-to-date summary'!B35)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C35),\"\",'Year-to-date summary'!C35)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B36),\"\",'Year-to-date summary'!B36)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C36),\"\",'Year-to-date summary'!C36)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B37),\"\",'Year-to-date summary'!B37)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C37),\"\",'Year-to-date summary'!C37)","v":""},0,0,0]

{"sheet":"2nd Q","index":2,"n_rows":37,"n_cols":97,"rows_kept":37}
[null,{"$f":"Company_Name","v":"Olson Harris Ltd. | Confidential"}]
[null,"Attendance tracking: "]
[null,"2nd quarter"]
[null,"Date"]
[]
[null,"Last Name","First Name","Vacation","Personal","Sick","4/1","4/2","4/3","4/4","4/5","4/6","4/7","4/8","4/9","4/10","4/11","4/12","4/13","4/14","4/15","4/16","4/17","4/18","4/19","4/20","4/21","4/22","4/23","4/24","4/25","4/26","4/27","4/28","4/29","4/30","5/1","5/2","5/3","5/4","5/5","5/6","5/7","5/8","5/9","5/10","5/11","5/12","5/13","5/14","5/15","5/16","5/17","5/18","5/19","5/20","5/21","5/22","5/23","5/24","5/25","5/26","5/27","5/28","5/29","5/30","5/31","6/1","6/2","6/3","6/4","6/5","6/6","6/7","6/8","6/9","6/10","6/11","6/12","6/13","6/14","6/15","6/16","6/17","6/18","6/19","6/20","6/21","6/22","6/23","6/24","6/25","6/26","6/27","6/28","6/29","6/30"]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B7),\"\",'Year-to-date summary'!B7)","v":"Hughes"},{"$f":"IF(ISBLANK('Year-to-date summary'!C7),\"\",'Year-to-date summary'!C7)","v":"Shawn"},{"$f":"COUNTIF($G7:$CS7, \"V\")","v":0},{"$f":"COUNTIF($G7:$CS7, \"P\")","v":0},{"$f":"COUNTIF($G7:$CS7, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B8),\"\",'Year-to-date summary'!B8)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C8),\"\",'Year-to-date summary'!C8)","v":""},{"$f":"COUNTIF($G8:$CS8, \"V\")","v":0},{"$f":"COUNTIF($G8:$CS8, \"P\")","v":0},{"$f":"COUNTIF($G8:$CS8, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B9),\"\",'Year-to-date summary'!B9)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C9),\"\",'Year-to-date summary'!C9)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B10),\"\",'Year-to-date summary'!B10)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C10),\"\",'Year-to-date summary'!C10)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B11),\"\",'Year-to-date summary'!B11)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C11),\"\",'Year-to-date summary'!C11)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B12),\"\",'Year-to-date summary'!B12)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C12),\"\",'Year-to-date summary'!C12)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B13),\"\",'Year-to-date summary'!B13)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C13),\"\",'Year-to-date summary'!C13)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B14),\"\",'Year-to-date summary'!B14)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C14),\"\",'Year-to-date summary'!C14)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B15),\"\",'Year-to-date summary'!B15)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C15),\"\",'Year-to-date summary'!C15)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B16),\"\",'Year-to-date summary'!B16)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C16),\"\",'Year-to-date summary'!C16)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B17),\"\",'Year-to-date summary'!B17)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C17),\"\",'Year-to-date summary'!C17)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B18),\"\",'Year-to-date summary'!B18)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C18),\"\",'Year-to-date summary'!C18)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B19),\"\",'Year-to-date summary'!B19)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C19),\"\",'Year-to-date summary'!C19)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B20),\"\",'Year-to-date summary'!B20)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C20),\"\",'Year-to-date summary'!C20)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B21),\"\",'Year-to-date summary'!B21)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C21),\"\",'Year-to-date summary'!C21)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B22),\"\",'Year-to-date summary'!B22)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C22),\"\",'Year-to-date summary'!C22)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B23),\"\",'Year-to-date summary'!B23)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C23),\"\",'Year-to-date summary'!C23)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B24),\"\",'Year-to-date summary'!B24)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C24),\"\",'Year-to-date summary'!C24)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B25),\"\",'Year-to-date summary'!B25)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C25),\"\",'Year-to-date summary'!C25)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B26),\"\",'Year-to-date summary'!B26)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C26),\"\",'Year-to-date summary'!C26)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B27),\"\",'Year-to-date summary'!B27)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C27),\"\",'Year-to-date summary'!C27)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B28),\"\",'Year-to-date summary'!B28)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C28),\"\",'Year-to-date summary'!C28)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B29),\"\",'Year-to-date summary'!B29)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C29),\"\",'Year-to-date summary'!C29)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B30),\"\",'Year-to-date summary'!B30)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C30),\"\",'Year-to-date summary'!C30)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B31),\"\",'Year-to-date summary'!B31)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C31),\"\",'Year-to-date summary'!C31)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B32),\"\",'Year-to-date summary'!B32)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C32),\"\",'Year-to-date summary'!C32)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B33),\"\",'Year-to-date summary'!B33)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C33),\"\",'Year-to-date summary'!C33)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B34),\"\",'Year-to-date summary'!B34)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C34),\"\",'Year-to-date summary'!C34)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B35),\"\",'Year-to-date summary'!B35)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C35),\"\",'Year-to-date summary'!C35)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B36),\"\",'Year-to-date summary'!B36)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C36),\"\",'Year-to-date summary'!C36)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B37),\"\",'Year-to-date summary'!B37)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C37),\"\",'Year-to-date summary'!C37)","v":""},0,0,0]

{"sheet":"3rd Q","index":3,"n_rows":37,"n_cols":98,"rows_kept":37}
[null,{"$f":"Company_Name","v":"Olson Harris Ltd. | Confidential"}]
[null,"Attendance tracking: "]
[null,"3rd quarter"]
[null,"Date"]
[]
[null,"Last Name","First Name","Vacation","Personal","Sick","7/1","7/2","7/3","7/4","7/5","7/6","7/7","7/8","7/9","7/10","7/11","7/12","7/13","7/14","7/15","7/16","7/17","7/18","7/19","7/20","7/21","7/22","7/23","7/24","7/25","7/26","7/27","7/28","7/29","7/30","7/31","8/1","8/2","8/3","8/4","8/5","8/6","8/7","8/8","8/9","8/10","8/11","8/12","8/13","8/14","8/15","8/16","8/17","8/18","8/19","8/20","8/21","8/22","8/23","8/24","8/25","8/26","8/27","8/28","8/29","8/30","8/31","9/1","9/2","9/3","9/4","9/5","9/6","9/7","9/8","9/9","9/10","9/11","9/12","9/13","9/14","9/15","9/16","9/17","9/18","9/19","9/20","9/21","9/22","9/23","9/24","9/25","9/26","9/27","9/28","9/29","9/30"]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B7),\"\",'Year-to-date summary'!B7)","v":"Hughes"},{"$f":"IF(ISBLANK('Year-to-date summary'!C7),\"\",'Year-to-date summary'!C7)","v":"Shawn"},{"$f":"COUNTIF($G7:$CT7, \"V\")","v":0},{"$f":"COUNTIF($G7:$CT7, \"P\")","v":0},{"$f":"COUNTIF($G7:$CT7, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B8),\"\",'Year-to-date summary'!B8)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C8),\"\",'Year-to-date summary'!C8)","v":""},{"$f":"COUNTIF($G8:$CT8, \"V\")","v":0},{"$f":"COUNTIF($G8:$CT8, \"P\")","v":0},{"$f":"COUNTIF($G8:$CT8, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B9),\"\",'Year-to-date summary'!B9)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C9),\"\",'Year-to-date summary'!C9)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B10),\"\",'Year-to-date summary'!B10)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C10),\"\",'Year-to-date summary'!C10)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B11),\"\",'Year-to-date summary'!B11)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C11),\"\",'Year-to-date summary'!C11)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B12),\"\",'Year-to-date summary'!B12)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C12),\"\",'Year-to-date summary'!C12)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B13),\"\",'Year-to-date summary'!B13)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C13),\"\",'Year-to-date summary'!C13)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B14),\"\",'Year-to-date summary'!B14)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C14),\"\",'Year-to-date summary'!C14)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B15),\"\",'Year-to-date summary'!B15)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C15),\"\",'Year-to-date summary'!C15)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B16),\"\",'Year-to-date summary'!B16)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C16),\"\",'Year-to-date summary'!C16)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B17),\"\",'Year-to-date summary'!B17)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C17),\"\",'Year-to-date summary'!C17)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B18),\"\",'Year-to-date summary'!B18)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C18),\"\",'Year-to-date summary'!C18)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B19),\"\",'Year-to-date summary'!B19)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C19),\"\",'Year-to-date summary'!C19)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B20),\"\",'Year-to-date summary'!B20)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C20),\"\",'Year-to-date summary'!C20)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B21),\"\",'Year-to-date summary'!B21)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C21),\"\",'Year-to-date summary'!C21)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B22),\"\",'Year-to-date summary'!B22)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C22),\"\",'Year-to-date summary'!C22)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B23),\"\",'Year-to-date summary'!B23)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C23),\"\",'Year-to-date summary'!C23)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B24),\"\",'Year-to-date summary'!B24)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C24),\"\",'Year-to-date summary'!C24)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B25),\"\",'Year-to-date summary'!B25)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C25),\"\",'Year-to-date summary'!C25)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B26),\"\",'Year-to-date summary'!B26)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C26),\"\",'Year-to-date summary'!C26)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B27),\"\",'Year-to-date summary'!B27)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C27),\"\",'Year-to-date summary'!C27)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B28),\"\",'Year-to-date summary'!B28)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C28),\"\",'Year-to-date summary'!C28)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B29),\"\",'Year-to-date summary'!B29)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C29),\"\",'Year-to-date summary'!C29)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B30),\"\",'Year-to-date summary'!B30)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C30),\"\",'Year-to-date summary'!C30)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B31),\"\",'Year-to-date summary'!B31)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C31),\"\",'Year-to-date summary'!C31)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B32),\"\",'Year-to-date summary'!B32)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C32),\"\",'Year-to-date summary'!C32)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B33),\"\",'Year-to-date summary'!B33)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C33),\"\",'Year-to-date summary'!C33)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B34),\"\",'Year-to-date summary'!B34)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C34),\"\",'Year-to-date summary'!C34)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B35),\"\",'Year-to-date summary'!B35)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C35),\"\",'Year-to-date summary'!C35)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B36),\"\",'Year-to-date summary'!B36)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C36),\"\",'Year-to-date summary'!C36)","v":""},0,0,0]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B37),\"\",'Year-to-date summary'!B37)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C37),\"\",'Year-to-date summary'!C37)","v":""},0,0,0]

{"sheet":"4th Q","index":4,"n_rows":37,"n_cols":98,"rows_kept":37}
[null,{"$f":"Company_Name","v":"Olson Harris Ltd. | Confidential"}]
[null,"Attendance tracking:"]
[null,"4th quarter"]
[null,"Date"]
[]
[null,"Last Name","First Name","Vacation","Personal","Sick","10/1","10/2","10/3","10/4","10/5","10/6","10/7","10/8","10/9","10/10","10/11","10/12","10/13","10/14","10/15","10/16","10/17","10/18","10/19","10/20","10/21","10/22","10/23","10/24","10/25","10/26","10/27","10/28","10/29","10/30","10/31","11/1","11/2","11/3","11/4","11/5","11/6","11/7","11/8","11/9","11/10","11/11","11/12","11/13","11/14","11/15","11/16","11/17","11/18","11/19","11/20","11/21","11/22","11/23","11/24","11/25","11/26","11/27","11/28","11/29","11/30","12/1","12/2","12/3","12/4","12/5","12/6","12/7","12/8","12/9","12/10","12/11","12/12","12/13","12/14","12/15","12/16","12/17","12/18","12/19","12/20","12/21","12/22","12/23","12/24","12/25","12/26","12/27","12/28","12/29","12/30","12/31"]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B7),\"\",'Year-to-date summary'!B7)","v":"Hughes"},{"$f":"IF(ISBLANK('Year-to-date summary'!C7),\"\",'Year-to-date summary'!C7)","v":"Shawn"},{"$f":"COUNTIF($G7:$CT7, \"V\")","v":0},{"$f":"COUNTIF($G7:CT7, \"P\")","v":0},{"$f":"COUNTIF($G7:CT7, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B8),\"\",'Year-to-date summary'!B8)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C8),\"\",'Year-to-date summary'!C8)","v":""},0,{"$f":"COUNTIF($G8:CT8, \"P\")","v":0},{"$f":"COUNTIF($G8:CT8, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B9),\"\",'Year-to-date summary'!B9)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C9),\"\",'Year-to-date summary'!C9)","v":""},0,{"$f":"COUNTIF($G9:CT9, \"P\")","v":0},{"$f":"COUNTIF($G9:CT9, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B10),\"\",'Year-to-date summary'!B10)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C10),\"\",'Year-to-date summary'!C10)","v":""},0,{"$f":"COUNTIF($G10:CT10, \"P\")","v":0},{"$f":"COUNTIF($G10:CT10, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B11),\"\",'Year-to-date summary'!B11)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C11),\"\",'Year-to-date summary'!C11)","v":""},0,{"$f":"COUNTIF($G11:CT11, \"P\")","v":0},{"$f":"COUNTIF($G11:CT11, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B12),\"\",'Year-to-date summary'!B12)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C12),\"\",'Year-to-date summary'!C12)","v":""},0,{"$f":"COUNTIF($G12:CT12, \"P\")","v":0},{"$f":"COUNTIF($G12:CT12, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B13),\"\",'Year-to-date summary'!B13)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C13),\"\",'Year-to-date summary'!C13)","v":""},0,{"$f":"COUNTIF($G13:CT13, \"P\")","v":0},{"$f":"COUNTIF($G13:CT13, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B14),\"\",'Year-to-date summary'!B14)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C14),\"\",'Year-to-date summary'!C14)","v":""},0,{"$f":"COUNTIF($G14:CT14, \"P\")","v":0},{"$f":"COUNTIF($G14:CT14, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B15),\"\",'Year-to-date summary'!B15)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C15),\"\",'Year-to-date summary'!C15)","v":""},0,{"$f":"COUNTIF($G15:CT15, \"P\")","v":0},{"$f":"COUNTIF($G15:CT15, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B16),\"\",'Year-to-date summary'!B16)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C16),\"\",'Year-to-date summary'!C16)","v":""},0,{"$f":"COUNTIF($G16:CT16, \"P\")","v":0},{"$f":"COUNTIF($G16:CT16, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B17),\"\",'Year-to-date summary'!B17)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C17),\"\",'Year-to-date summary'!C17)","v":""},0,{"$f":"COUNTIF($G17:CT17, \"P\")","v":0},{"$f":"COUNTIF($G17:CT17, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B18),\"\",'Year-to-date summary'!B18)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C18),\"\",'Year-to-date summary'!C18)","v":""},0,{"$f":"COUNTIF($G18:CT18, \"P\")","v":0},{"$f":"COUNTIF($G18:CT18, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B19),\"\",'Year-to-date summary'!B19)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C19),\"\",'Year-to-date summary'!C19)","v":""},0,{"$f":"COUNTIF($G19:CT19, \"P\")","v":0},{"$f":"COUNTIF($G19:CT19, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B20),\"\",'Year-to-date summary'!B20)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C20),\"\",'Year-to-date summary'!C20)","v":""},0,{"$f":"COUNTIF($G20:CT20, \"P\")","v":0},{"$f":"COUNTIF($G20:CT20, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B21),\"\",'Year-to-date summary'!B21)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C21),\"\",'Year-to-date summary'!C21)","v":""},0,{"$f":"COUNTIF($G21:CT21, \"P\")","v":0},{"$f":"COUNTIF($G21:CT21, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B22),\"\",'Year-to-date summary'!B22)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C22),\"\",'Year-to-date summary'!C22)","v":""},0,{"$f":"COUNTIF($G22:CT22, \"P\")","v":0},{"$f":"COUNTIF($G22:CT22, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B23),\"\",'Year-to-date summary'!B23)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C23),\"\",'Year-to-date summary'!C23)","v":""},0,{"$f":"COUNTIF($G23:CT23, \"P\")","v":0},{"$f":"COUNTIF($G23:CT23, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B24),\"\",'Year-to-date summary'!B24)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C24),\"\",'Year-to-date summary'!C24)","v":""},0,{"$f":"COUNTIF($G24:CT24, \"P\")","v":0},{"$f":"COUNTIF($G24:CT24, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B25),\"\",'Year-to-date summary'!B25)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C25),\"\",'Year-to-date summary'!C25)","v":""},0,{"$f":"COUNTIF($G25:CT25, \"P\")","v":0},{"$f":"COUNTIF($G25:CT25, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B26),\"\",'Year-to-date summary'!B26)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C26),\"\",'Year-to-date summary'!C26)","v":""},0,{"$f":"COUNTIF($G26:CT26, \"P\")","v":0},{"$f":"COUNTIF($G26:CT26, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B27),\"\",'Year-to-date summary'!B27)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C27),\"\",'Year-to-date summary'!C27)","v":""},0,{"$f":"COUNTIF($G27:CT27, \"P\")","v":0},{"$f":"COUNTIF($G27:CT27, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B28),\"\",'Year-to-date summary'!B28)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C28),\"\",'Year-to-date summary'!C28)","v":""},0,{"$f":"COUNTIF($G28:CT28, \"P\")","v":0},{"$f":"COUNTIF($G28:CT28, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B29),\"\",'Year-to-date summary'!B29)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C29),\"\",'Year-to-date summary'!C29)","v":""},0,{"$f":"COUNTIF($G29:CT29, \"P\")","v":0},{"$f":"COUNTIF($G29:CT29, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B30),\"\",'Year-to-date summary'!B30)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C30),\"\",'Year-to-date summary'!C30)","v":""},0,{"$f":"COUNTIF($G30:CT30, \"P\")","v":0},{"$f":"COUNTIF($G30:CT30, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B31),\"\",'Year-to-date summary'!B31)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C31),\"\",'Year-to-date summary'!C31)","v":""},0,{"$f":"COUNTIF($G31:CT31, \"P\")","v":0},{"$f":"COUNTIF($G31:CT31, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B32),\"\",'Year-to-date summary'!B32)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C32),\"\",'Year-to-date summary'!C32)","v":""},0,{"$f":"COUNTIF($G32:CT32, \"P\")","v":0},{"$f":"COUNTIF($G32:CT32, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B33),\"\",'Year-to-date summary'!B33)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C33),\"\",'Year-to-date summary'!C33)","v":""},0,{"$f":"COUNTIF($G33:CT33, \"P\")","v":0},{"$f":"COUNTIF($G33:CT33, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B34),\"\",'Year-to-date summary'!B34)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C34),\"\",'Year-to-date summary'!C34)","v":""},0,{"$f":"COUNTIF($G34:CT34, \"P\")","v":0},{"$f":"COUNTIF($G34:CT34, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B35),\"\",'Year-to-date summary'!B35)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C35),\"\",'Year-to-date summary'!C35)","v":""},0,{"$f":"COUNTIF($G35:CT35, \"P\")","v":0},{"$f":"COUNTIF($G35:CT35, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B36),\"\",'Year-to-date summary'!B36)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C36),\"\",'Year-to-date summary'!C36)","v":""},0,{"$f":"COUNTIF($G36:CT36, \"P\")","v":0},{"$f":"COUNTIF($G36:CT36, \"S\")","v":0}]
[null,{"$f":"IF(ISBLANK('Year-to-date summary'!B37),\"\",'Year-to-date summary'!B37)","v":""},{"$f":"IF(ISBLANK('Year-to-date summary'!C37),\"\",'Year-to-date summary'!C37)","v":""},0,{"$f":"COUNTIF($G37:CT37, \"P\")","v":0},{"$f":"COUNTIF($G37:CT37, \"S\")","v":0}]