{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TimesheetDB","Timesheet"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"TimesheetDB","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Date","Start Time","End Time","Lunch","Break","Code","Hours","Overtime"]
["2016-04-20","09:00:00","17:00:00","00:45:00","00:15:00","Unpaid",{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"07:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":""}]
["2016-04-19","09:00:00","17:00:00","00:30:00","00:30:00","Sick",{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"07:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"00:00:00"}]
["2016-04-18","09:00:00","17:00:00","01:00:00",null,"Holiday",{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"07:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":""}]
["2016-04-17","09:00:00","17:00:00","01:00:00",null,"Holiday",{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"07:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":""}]
["2016-04-16","09:00:00","17:00:00","01:00:00","00:30:00","Holiday",{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"06:30:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":""}]
["2016-04-15","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-14","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-13","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-12","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-11","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-10","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-09","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-08","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-07","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-06","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-05","09:00:00","18:00:00","01:00:00","00:20:00",null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"07:40:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"00:40:00"}]
["2016-04-04","09:00:00","16:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"06:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":""}]
["2016-04-03","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-02","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-04-01","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-03-31","09:00:00","18:00:00","01:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-03-30","09:00:00","18:00:00","00:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"09:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"02:00:00"}]
["2016-03-29","09:00:00","18:00:00","00:00:00",null,null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"09:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"02:00:00"}]
["2016-03-28","09:00:00","18:00:00","01:00:00","00:00:00",null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]
["2016-03-27","09:00:00","18:00:00","01:00:00","00:00:00",null,{"$f":"IF(AND(TimeSheet[[#This Row],[End Time]]<>\"\",TimeSheet[[#This Row],[Start Time]]<>\"\"),TimeSheet[[#This Row],[End Time]]-SUM(TimeSheet[[#This Row],[Start Time]],TimeSheet[[#This Row],[Lunch]],TimeSheet[[#This Row],[Break]]),\"\")","v":"08:00:00"},{"$f":"IFERROR(IF(dd_ot=\"Yes\",IF(TimeSheet[[#This Row],[Hours]]-ot_threshold>0,TimeSheet[[#This Row],[Hours]]-ot_threshold,\"\"),\"\"),\"\")","v":"01:00:00"}]

{"sheet":"Timesheet","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[0,"r/Excel TimeSheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hourly Threshold","07:00:00",null,"Date","Hourly","Overtime","Unpaid Time","Gross Pay","Overtime Pay","Sick","Holiday","Unpaid","Other","Total"]
[null,"Overtime","Yes",null,{"$f":"IF(ViewSelect=\"Day\",E15-1,EDATE(E15,-1))","v":"2016-04-09"},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E14),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E14,TimeSheet[Date],\"<=\"&EOMONTH($E14,0)))","v":0.33333333333333331},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E14),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E14,TimeSheet[Date],\"<=\"&EOMONTH($E14,0)))","v":4.166666666666663E-2},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E14,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E14,TimeSheet[Date],\"<=\"&EOMONTH($E14,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":113.99999999999999},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":17.999999999999986},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":0}]
[null,"Hourly Pay",12,null,"2016-04-10",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E15),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E15,TimeSheet[Date],\"<=\"&EOMONTH($E15,0)))","v":0.33333333333333331},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E15),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E15,TimeSheet[Date],\"<=\"&EOMONTH($E15,0)))","v":4.166666666666663E-2},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E15,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E15,TimeSheet[Date],\"<=\"&EOMONTH($E15,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":113.99999999999999},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":17.999999999999986},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":0}]
[null,"Overtime Pay",18,null,"2016-04-11",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E16),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E16,TimeSheet[Date],\"<=\"&EOMONTH($E16,0)))","v":0.33333333333333331},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E16),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E16,TimeSheet[Date],\"<=\"&EOMONTH($E16,0)))","v":4.166666666666663E-2},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E16,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E16,TimeSheet[Date],\"<=\"&EOMONTH($E16,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":113.99999999999999},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":17.999999999999986},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":0}]
[null,null,null,null,"2016-04-12",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E17),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E17,TimeSheet[Date],\"<=\"&EOMONTH($E17,0)))","v":0.33333333333333331},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E17),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E17,TimeSheet[Date],\"<=\"&EOMONTH($E17,0)))","v":4.166666666666663E-2},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E17,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E17,TimeSheet[Date],\"<=\"&EOMONTH($E17,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":113.99999999999999},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":17.999999999999986},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":0}]
[null,"View","Day",null,"2016-04-13",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E18),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E18,TimeSheet[Date],\"<=\"&EOMONTH($E18,0)))","v":0.33333333333333331},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E18),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E18,TimeSheet[Date],\"<=\"&EOMONTH($E18,0)))","v":4.166666666666663E-2},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E18,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E18,TimeSheet[Date],\"<=\"&EOMONTH($E18,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":113.99999999999999},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":17.999999999999986},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":0}]
[null,null,null,null,"2016-04-14",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E19),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E19,TimeSheet[Date],\"<=\"&EOMONTH($E19,0)))","v":0.33333333333333331},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E19),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E19,TimeSheet[Date],\"<=\"&EOMONTH($E19,0)))","v":4.166666666666663E-2},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E19,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E19,TimeSheet[Date],\"<=\"&EOMONTH($E19,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":113.99999999999999},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":17.999999999999986},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":0}]
[null,null,null,null,"2016-04-15",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E20),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E20,TimeSheet[Date],\"<=\"&EOMONTH($E20,0)))","v":0.33333333333333331},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E20),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E20,TimeSheet[Date],\"<=\"&EOMONTH($E20,0)))","v":4.166666666666663E-2},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E20,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E20,TimeSheet[Date],\"<=\"&EOMONTH($E20,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":113.99999999999999},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":17.999999999999986},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":0}]
[null,null,null,null,"2016-04-16",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E21),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E21,TimeSheet[Date],\"<=\"&EOMONTH($E21,0)))","v":0.27083333333333337},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E21),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E21,TimeSheet[Date],\"<=\"&EOMONTH($E21,0)))","v":0},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E21,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E21,TimeSheet[Date],\"<=\"&EOMONTH($E21,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":78.000000000000014},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":1},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":1}]
[null,null,null,null,"2016-04-17",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E22),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E22,TimeSheet[Date],\"<=\"&EOMONTH($E22,0)))","v":0.29166666666666669},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E22),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E22,TimeSheet[Date],\"<=\"&EOMONTH($E22,0)))","v":0},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E22,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E22,TimeSheet[Date],\"<=\"&EOMONTH($E22,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":84},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":1},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":1}]
[null,null,null,null,"2016-04-18",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E23),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E23,TimeSheet[Date],\"<=\"&EOMONTH($E23,0)))","v":0.29166666666666669},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E23),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E23,TimeSheet[Date],\"<=\"&EOMONTH($E23,0)))","v":0},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E23,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E23,TimeSheet[Date],\"<=\"&EOMONTH($E23,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":84},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":1},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":1}]
[null,null,null,null,"2016-04-19",{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E24),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E24,TimeSheet[Date],\"<=\"&EOMONTH($E24,0)))","v":0.29166666666666674},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E24),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E24,TimeSheet[Date],\"<=\"&EOMONTH($E24,0)))","v":5.5511151231257827E-17},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E24,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E24,TimeSheet[Date],\"<=\"&EOMONTH($E24,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":84.000000000000057},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":2.3980817331903381E-14},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":1},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":1}]
[null,null,null,null,{"$f":"IF(ViewSelect=\"Month\",EDATE(EOMONTH(MAX(TimeSheet[Date]),-1)+1,-$A$1),IF(ViewSelect=\"Year\",DATE(YEAR(MAX(TimeSheet[Date]))-$A$1,12,1),MAX(TimeSheet[Date])-$A$1))","v":"2016-04-20"},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E25),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E25,TimeSheet[Date],\"<=\"&EOMONTH($E25,0)))","v":0.29166666666666669},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Overtime],TimeSheet[Date],$E25),SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&$E25,TimeSheet[Date],\"<=\"&EOMONTH($E25,0)))","v":0},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E25,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E25,TimeSheet[Date],\"<=\"&EOMONTH($E25,0),TimeSheet[Code],\"Unpaid\"))","v":0.29166666666666669},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":84},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],K$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],L$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],M$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":1},{"$f":"IF(ViewSelect=\"Day\",COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],HourPay[[#This Row],[Date]]),COUNTIFS(TimeSheet[Code],N$13,TimeSheet[Date],\">=\"&HourPay[[#This Row],[Date]],TimeSheet[Date],\"<=\"&EOMONTH(HourPay[[#This Row],[Date]],0)))","v":0},{"$f":"SUM(HourPay[[#This Row],[Sick]:[Other]])","v":1}]
[null,null,null,null,"Total",{"$f":"SUM(F14:F25)","v":3.7708333333333326},{"$f":"SUM(G14:G25)","v":0.29166666666666646},{"$f":"IF(ViewSelect=\"day\",SUMIFS(TimeSheet[Hours],TimeSheet[Date],$E26,TimeSheet[Code],\"Unpaid\"),SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&$E26,TimeSheet[Date],\"<=\"&EOMONTH($E26,0),TimeSheet[Code],\"Unpaid\"))","v":0},{"$f":"((HourPay[[#This Row],[Hourly]])*24*$C$15)+((HourPay[[#This Row],[Overtime]])*24*$C$16)","v":1211.9999999999998},{"$f":"(HourPay[[#This Row],[Overtime]])*24*$C$16","v":125.9999999999999},{"$f":"SUBTOTAL(109,Timesheet!$K$14:$K$25)","v":1},{"$f":"SUBTOTAL(109,Timesheet!$L$14:$L$25)","v":3},{"$f":"SUBTOTAL(109,Timesheet!$M$14:$M$25)","v":1},{"$f":"SUBTOTAL(109,Timesheet!$N$14:$N$25)","v":0},{"$f":"SUBTOTAL(109,Timesheet!$O$14:$O$25)","v":5}]
[]
[null,null,null,null,"Quarter","Hourly","Overtime","Unpaid Time","Gross Pay","Overtime Pay","Sick","Holiday","Unpaid","Other","Total"]
[null,null,null,null,{"$f":"\"1st Quarter \" & YEAR($E$25)","v":"1st Quarter 2016"},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),1,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),3,1),0)))","v":1.7499999999999998},{"$f":"SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),1,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),3,1),0)))","v":0.29166666666666652},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),1,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),3,1),0)),TimeSheet[Code],\"Unpaid\")","v":0},{"$f":"((F29)*24*$C$15)+((F29)*24*$C$16)","v":1259.9999999999998},{"$f":"(G29)*24*$C$16","v":125.99999999999994},{"$f":"COUNTIFS(TimeSheet[Code],K$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),1,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),3,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],L$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),1,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),3,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],M$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),1,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),3,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],N$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),1,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),3,1),0)))","v":0},{"$f":"SUM(K29:N29)","v":0}]
[null,null,null,null,{"$f":"\"2nd Quarter \" & YEAR($E$25)","v":"2nd Quarter 2016"},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),4,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),6,1),0)))","v":6.3402777777777777},{"$f":"SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),4,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),6,1),0)))","v":0.56944444444444398},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),4,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),6,1),0)),TimeSheet[Code],\"Unpaid\")","v":0.29166666666666669},{"$f":"((F30)*24*$C$15)+((F30)*24*$C$16)","v":4565},{"$f":"(G30)*24*$C$16","v":245.9999999999998},{"$f":"COUNTIFS(TimeSheet[Code],K$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),4,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),6,1),0)))","v":1},{"$f":"COUNTIFS(TimeSheet[Code],L$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),4,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),6,1),0)))","v":3},{"$f":"COUNTIFS(TimeSheet[Code],M$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),4,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),6,1),0)))","v":1},{"$f":"COUNTIFS(TimeSheet[Code],N$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),4,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),6,1),0)))","v":0},{"$f":"SUM(K30:N30)","v":5}]
[null,null,null,null,{"$f":"\"3rd Quarter \" & YEAR($E$25)","v":"3rd Quarter 2016"},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),7,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),9,1),0)))","v":0},{"$f":"SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),7,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),9,1),0)))","v":0},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),7,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),9,1),0)),TimeSheet[Code],\"Unpaid\")","v":0},0,0,{"$f":"COUNTIFS(TimeSheet[Code],K$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),7,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),9,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],L$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),7,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),9,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],M$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),7,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),9,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],N$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),7,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),9,1),0)))","v":0},0]
[null,null,null,null,{"$f":"\"4th Quarter \" & YEAR($E$25)","v":"4th Quarter 2016"},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),10,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),12,1),0)))","v":0},{"$f":"SUMIFS(TimeSheet[Overtime],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),10,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),12,1),0)))","v":0},{"$f":"SUMIFS(TimeSheet[Hours],TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),10,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),12,1),0)),TimeSheet[Code],\"Unpaid\")","v":0},0,0,{"$f":"COUNTIFS(TimeSheet[Code],K$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),10,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),12,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],L$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),10,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),12,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],M$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),10,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),12,1),0)))","v":0},{"$f":"COUNTIFS(TimeSheet[Code],N$28,TimeSheet[Date],\">=\"&DATE((YEAR($E$25)),10,1),TimeSheet[Date],\"<=\"&(EOMONTH(DATE(YEAR($E$25),12,1),0)))","v":0},0]
[null,null,null,null,"Total",{"$f":"SUM(F29:F32)","v":8.0902777777777768},0.86111111111111049,0.29166666666666669,5825,371.99999999999977,1,{"$f":"SUM(L29:L32)","v":3},1,0,5]