{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Goal"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":3},"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":"Data","index":0,"n_rows":703,"n_cols":23,"rows_kept":703,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Table1"]
[null,"Consultant","Category","Hours","Week",null,"Consultant","Bebko",null,null,null,null,null,null,null,null,null,null,null,"Consultant","Bebko"]
[null,"Bebko","Edison",6,"2011-06-27",null,"PivotTable2",null,null,null,null,null,null,null,null,null,null,null,null,"PivotTable3"]
[null,"Bebko","PTO",0,"2011-06-27",null,"Sum of Hours","Category",null,null,null,null,null,null,null,null,null,null,null,"Sum of Hours","Category"]
[null,"Bebko","Other",2,"2011-06-27",null,"Week","Comm","Edison","Dummy","Dummy2","Dummy3","Dummy4","PTO","Other",null,null,null,null,"Week","Comm","Edison","Grand Total"]
[null,"Bebko","Comm",0,"2011-06-27",null,"2011-06-27",0,6,0,0,0,0,0,2,null,null,null,null,"2011-06-27",0,6,6]
[null,"Bebko","PTO",20,"2011-07-04",null,"2011-07-04",0,2,0,0,0,0,20,18,null,null,null,null,"2011-07-04",0,2,2]
[null,"Bebko","Other",18,"2011-07-04",null,"2011-07-11",40,0,0,0,0,0,0,0,null,null,null,null,"2011-07-11",40,0,40]
[null,"Bebko","Edison",2,"2011-07-04",null,"2011-07-18",40,0,0,0,0,0,0,1,null,null,null,null,"2011-07-18",40,0,40]
[null,"Bebko","Comm",0,"2011-07-04",null,"2011-07-25",28.5,0,0,0,0,0,8,3.5,null,null,null,null,"2011-07-25",28.5,0,28.5]
[null,"Bebko","PTO",0,"2011-07-11",null,"2011-08-01",19.5,0,0,0,0,0,0,20.5,null,null,null,null,"2011-08-01",19.5,0,19.5]
[null,"Bebko","Other",0,"2011-07-11",null,"2011-08-08",14.5,16.5,0,0,0,0,0,9,null,null,null,null,"2011-08-08",14.5,16.5,31]
[null,"Bebko","Comm",40,"2011-07-11",null,"2011-08-15",20,4,0,0,0,0,0,19.5,null,null,null,null,"2011-08-15",20,4,24]
[null,"Bebko","Edison",0,"2011-07-11",null,"2011-08-22",8,8.5,0,0,0,0,8,15.5,null,null,null,null,"2011-08-22",8,8.5,16.5]
[null,"Bebko","Comm",40,"2011-07-18",null,"2011-08-29",35,4,0,0,0,0,0,4.5,null,null,null,null,"2011-08-29",35,4,39]
[null,"Bebko","PTO",0,"2011-07-18",null,"2011-09-05",9.5,2,0,0,0,0,16,12.5,null,null,null,null,"2011-09-05",9.5,2,11.5]
[null,"Bebko","Edison",0,"2011-07-18",null,"2011-09-12",3.5,30.5,0,0,0,0,0,10,null,null,null,null,"2011-09-12",3.5,30.5,34]
[null,"Bebko","Other",1,"2011-07-18",null,"Grand Total",218.5,73.5,0,0,0,0,52,116]
[null,"Bebko","Edison",0,"2011-07-25"]
[null,"Bebko","PTO",8,"2011-07-25"]
[null,"Bebko","Comm",28.5,"2011-07-25"]
[null,"Bebko","Other",3.5,"2011-07-25"]
[null,"Bebko","PTO",0,"2011-08-01"]
[null,"Bebko","Comm",19.5,"2011-08-01"]
[null,"Bebko","Other",20.5,"2011-08-01"]
[null,"Bebko","Edison",0,"2011-08-01"]
[null,"Bebko","Other",9,"2011-08-08"]
[null,"Bebko","PTO",0,"2011-08-08"]
[null,"Bebko","Comm",14.5,"2011-08-08"]
[null,"Bebko","Edison",16.5,"2011-08-08"]
[null,"Bebko","Comm",20,"2011-08-15"]
[null,"Bebko","Other",19.5,"2011-08-15"]
[null,"Bebko","PTO",0,"2011-08-15"]
[null,"Bebko","Edison",4,"2011-08-15"]
[null,"Bebko","Comm",8,"2011-08-22"]
[null,"Bebko","Edison",8.5,"2011-08-22"]
[null,"Bebko","Other",15.5,"2011-08-22"]
[null,"Bebko","PTO",8,"2011-08-22"]
[null,"Bebko","PTO",0,"2011-08-29"]
[null,"Bebko","Other",4.5,"2011-08-29"]
[null,"Bebko","Edison",4,"2011-08-29"]
[null,"Bebko","Comm",35,"2011-08-29"]
[null,"Bebko","Other",12.5,"2011-09-05"]
[null,"Bebko","Comm",9.5,"2011-09-05"]
[null,"Bebko","PTO",16,"2011-09-05"]
[null,"Bebko","Edison",2,"2011-09-05"]
[null,"Bebko","Dummy4",0,"2011-09-12"]
[null,"Bebko","Dummy2",0,"2011-09-12"]
[null,"Bebko","Comm",3.5,"2011-09-12"]
[null,"Bebko","Dummy",0,"2011-09-12"]
[null,"Bebko","Dummy3",0,"2011-09-12"]
[null,"Bebko","Other",10,"2011-09-12"]
[null,"Bebko","Edison",30.5,"2011-09-12"]
[null,"Brewer","Comm",0,"2011-06-27"]
[null,"Brewer","Other",0,"2011-06-27"]
[null,"Brewer","PTO",0,"2011-06-27"]
[null,"Brewer","PTO",8,"2011-07-04"]
[null,"Brewer","Comm",0,"2011-07-04"]
[null,"Brewer","Other",0,"2011-07-04"]
[null,"Brewer","Other",0,"2011-07-11"]
[null,"Brewer","Comm",16,"2011-07-11"]
[null,"Brewer","PTO",0,"2011-07-11"]
[null,"Brewer","Other",41.5,"2011-07-18"]
[null,"Brewer","PTO",0,"2011-07-18"]
[null,"Brewer","Comm",0,"2011-07-18"]
[null,"Brewer","Other",20.8,"2011-07-25"]
[null,"Brewer","PTO",0,"2011-07-25"]
[null,"Brewer","Comm",21,"2011-07-25"]
[null,"Brewer","PTO",0,"2011-08-01"]
[null,"Brewer","Comm",45,"2011-08-01"]
[null,"Brewer","Other",8,"2011-08-01"]
[null,"Brewer","Comm",4.5,"2011-08-08"]
[null,"Brewer","Other",0,"2011-08-08"]
[null,"Brewer","PTO",0,"2011-08-08"]
[null,"Brewer","Other",0,"2011-08-15"]
[null,"Brewer","Comm",0,"2011-08-15"]
[null,"Brewer","PTO",24,"2011-08-15"]
[null,"Brewer","Comm",0,"2011-08-22"]
[null,"Brewer","Other",0,"2011-08-22"]
[null,"Brewer","PTO",16,"2011-08-22"]
[null,"Brewer","PTO",0,"2011-08-29"]
[null,"Brewer","Other",1,"2011-08-29"]
[null,"Brewer","Comm",17,"2011-08-29"]
[null,"Brewer","Comm",25.25,"2011-09-05"]
[null,"Brewer","PTO",8,"2011-09-05"]
[null,"Brewer","Other",9,"2011-09-05"]
[null,"Brewer","Dummy",0,"2011-09-12"]
[null,"Brewer","Other",4,"2011-09-12"]
[null,"Brewer","Comm",48.5,"2011-09-12"]
[null,"Brewer","Dummy4",0,"2011-09-12"]
[null,"Brewer","Dummy2",0,"2011-09-12"]
[null,"Brewer","Dummy3",0,"2011-09-12"]
[null,"Bunn","Comm",0,"2011-06-27"]
[null,"Bunn","PTO",8,"2011-06-27"]
[null,"Bunn","Edison",0,"2011-06-27"]
[null,"Bunn","Other",0,"2011-06-27"]
[null,"Bunn","Other",32,"2011-07-04"]
[null,"Bunn","Edison",0,"2011-07-04"]
[null,"Bunn","PTO",8,"2011-07-04"]
[null,"Bunn","Comm",0,"2011-07-04"]
[null,"Bunn","Comm",0,"2011-07-11"]
[null,"Bunn","PTO",12,"2011-07-11"]
[null,"Bunn","Edison",0,"2011-07-11"]
[null,"Bunn","Other",28,"2011-07-11"]
[null,"Bunn","Edison",8,"2011-07-18"]
[null,"Bunn","Comm",6,"2011-07-18"]
[null,"Bunn","Other",26,"2011-07-18"]
[null,"Bunn","PTO",0,"2011-07-18"]
[null,"Bunn","PTO",0,"2011-07-25"]
[null,"Bunn","Other",16,"2011-07-25"]
[null,"Bunn","Comm",18,"2011-07-25"]
[null,"Bunn","Edison",6,"2011-07-25"]
[null,"Bunn","PTO",0,"2011-08-01"]
[null,"Bunn","Edison",0,"2011-08-01"]
[null,"Bunn","Other",14,"2011-08-01"]
[null,"Bunn","Comm",26,"2011-08-01"]
[null,"Bunn","PTO",0,"2011-08-08"]
[null,"Bunn","Comm",33,"2011-08-08"]
[null,"Bunn","Edison",0,"2011-08-08"]
[null,"Bunn","Other",7,"2011-08-08"]
[null,"Bunn","Comm",12,"2011-08-15"]
[null,"Bunn","PTO",0,"2011-08-15"]
[null,"Bunn","Other",28,"2011-08-15"]
[null,"Bunn","Edison",0,"2011-08-15"]
[null,"Bunn","Other",31,"2011-08-22"]
[null,"Bunn","Comm",1,"2011-08-22"]
[null,"Bunn","Edison",8,"2011-08-22"]
[null,"Bunn","PTO",0,"2011-08-22"]
[null,"Bunn","Comm",7,"2011-08-29"]
[null,"Bunn","Other",32,"2011-08-29"]
[null,"Bunn","Edison",1,"2011-08-29"]
[null,"Bunn","PTO",0,"2011-08-29"]
[null,"Bunn","PTO",8,"2011-09-05"]
[null,"Bunn","Comm",2,"2011-09-05"]
[null,"Bunn","Edison",8,"2011-09-05"]
[null,"Bunn","Other",22,"2011-09-05"]
[null,"Bunn","Dummy2",0,"2011-09-12"]
[null,"Bunn","PTO",4,"2011-09-12"]
[null,"Bunn","Dummy3",0,"2011-09-12"]
[null,"Bunn","Dummy",0,"2011-09-12"]
[null,"Bunn","Comm",24,"2011-09-12"]
[null,"Bunn","Other",12,"2011-09-12"]
[null,"Bunn","Dummy4",0,"2011-09-12"]
[null,"Byers","Edison",10,"2011-09-12"]
[null,"Byers","Other",40,"2011-09-12"]
[null,"Byers","Dummy4",0,"2011-09-12"]
[null,"Byers","Dummy",0,"2011-09-12"]
[null,"Byers","Dummy3",0,"2011-09-12"]
[null,"Byers","Dummy2",0,"2011-09-12"]
[null,"Dillion","Other",4,"2011-06-27"]
[null,"Dillion","PTO",4,"2011-06-27"]
[null,"Dillion","Comm",0,"2011-06-27"]
[null,"Dillion","Edison",0,"2011-06-27"]
[null,"Dillion","Other",28,"2011-07-04"]
[null,"Dillion","PTO",8,"2011-07-04"]
[null,"Dillion","Edison",4,"2011-07-04"]
[null,"Dillion","Comm",0,"2011-07-04"]
[null,"Dillion","Comm",0,"2011-07-11"]
[null,"Dillion","Edison",0,"2011-07-11"]
[null,"Dillion","Other",22,"2011-07-11"]
[null,"Dillion","PTO",18,"2011-07-11"]
[null,"Dillion","Comm",0,"2011-07-18"]
[null,"Dillion","PTO",0,"2011-07-18"]
[null,"Dillion","Edison",0,"2011-07-18"]
[null,"Dillion","Other",42,"2011-07-18"]
[null,"Dillion","Edison",0,"2011-07-25"]
[null,"Dillion","Other",36.5,"2011-07-25"]
[null,"Dillion","PTO",1,"2011-07-25"]
[null,"Dillion","Comm",2.5,"2011-07-25"]
[null,"Dillion","Comm",4,"2011-08-01"]
[null,"Dillion","PTO",0,"2011-08-01"]
[null,"Dillion","Edison",0,"2011-08-01"]
[null,"Dillion","Other",37,"2011-08-01"]
[null,"Dillion","Edison",0,"2011-08-08"]
[null,"Dillion","PTO",6,"2011-08-08"]
[null,"Dillion","Comm",9,"2011-08-08"]
[null,"Dillion","Other",25,"2011-08-08"]
[null,"Dillion","Edison",0,"2011-08-15"]
[null,"Dillion","PTO",0,"2011-08-15"]
[null,"Dillion","Other",34,"2011-08-15"]
[null,"Dillion","Comm",8,"2011-08-15"]
[null,"Dillion","Edison",0,"2011-08-22"]
[null,"Dillion","Comm",21,"2011-08-22"]
[null,"Dillion","PTO",0,"2011-08-22"]
[null,"Dillion","Other",19,"2011-08-22"]
[null,"Dillion","Other",16.5,"2011-08-29"]
[null,"Dillion","Comm",25,"2011-08-29"]
[null,"Dillion","PTO",0,"2011-08-29"]
[null,"Dillion","Edison",0,"2011-08-29"]
[null,"Dillion","Comm",8.5,"2011-09-05"]
[null,"Dillion","Other",16,"2011-09-05"]
[null,"Dillion","PTO",12.5,"2011-09-05"]
[null,"Dillion","Edison",3,"2011-09-05"]
[null,"Dillion","Dummy3",0,"2011-09-12"]
[null,"Dillion","Edison",0,"2011-09-12"]
[null,"Dillion","Dummy",0,"2011-09-12"]
[null,"Dillion","PTO",38,"2011-09-12"]
[null,"Dillion","Dummy2",0,"2011-09-12"]
[null,"Dillion","Other",2,"2011-09-12"]
[null,"Dillion","Comm",0,"2011-09-12"]
[null,"Dillion","Dummy4",0,"2011-09-12"]
[null,"D'Silva","Comm",0,"2011-06-27"]
[null,"D'Silva","Other",3,"2011-06-27"]
[null,"D'Silva","PTO",0,"2011-06-27"]
[null,"D'Silva","PTO",8,"2011-07-04"]
[null,"D'Silva","Other",12.5,"2011-07-04"]
[null,"D'Silva","Comm",22.5,"2011-07-04"]
[null,"D'Silva","Comm",27.5,"2011-07-11"]
[null,"D'Silva","PTO",0,"2011-07-11"]
[null,"D'Silva","Other",37,"2011-07-11"]
[null,"D'Silva","Other",21,"2011-07-18"]
[null,"D'Silva","PTO",0,"2011-07-18"]
[null,"D'Silva","Comm",24.5,"2011-07-18"]
[null,"D'Silva","Comm",0,"2011-07-25"]
[null,"D'Silva","PTO",40,"2011-07-25"]
[null,"D'Silva","Other",0,"2011-07-25"]
[null,"D'Silva","PTO",0,"2011-08-01"]
[null,"D'Silva","Other",19,"2011-08-01"]
[null,"D'Silva","Comm",30,"2011-08-01"]
[null,"D'Silva","Other",0,"2011-08-08"]
[null,"D'Silva","PTO",0,"2011-08-08"]
[null,"D'Silva","Comm",53,"2011-08-08"]
[null,"D'Silva","Comm",31,"2011-08-15"]
[null,"D'Silva","Other",15,"2011-08-15"]
[null,"D'Silva","PTO",0,"2011-08-15"]
[null,"D'Silva","Other",16.5,"2011-08-22"]
[null,"D'Silva","PTO",0,"2011-08-22"]
[null,"D'Silva","Comm",26.5,"2011-08-22"]
[null,"D'Silva","Other",9,"2011-08-29"]
[null,"D'Silva","PTO",0,"2011-08-29"]
[null,"D'Silva","Comm",45,"2011-08-29"]
[null,"D'Silva","Comm",18.5,"2011-09-05"]
[null,"D'Silva","PTO",8,"2011-09-05"]
[null,"D'Silva","Other",23,"2011-09-05"]
[null,"D'Silva","Dummy4",0,"2011-09-12"]
[null,"D'Silva","Dummy2",0,"2011-09-12"]
[null,"D'Silva","Comm",54.5,"2011-09-12"]
[null,"D'Silva","Other",1,"2011-09-12"]
[null,"D'Silva","Dummy3",0,"2011-09-12"]
[null,"D'Silva","Dummy",0,"2011-09-12"]
[null,"Furlow","Dummy3",0,"2011-09-12"]
[null,"Furlow","Dummy",0,"2011-09-12"]
[null,"Furlow","Edison",40,"2011-09-12"]
[null,"Furlow","Dummy2",0,"2011-09-12"]
[null,"Furlow","Dummy4",0,"2011-09-12"]
[null,"Hume","Other",6.5,"2011-06-27"]
[null,"Hume","Comm",0,"2011-06-27"]
[null,"Hume","PTO",0,"2011-06-27"]
[null,"Hume","Edison",0,"2011-06-27"]
[null,"Hume","Edison",0,"2011-07-04"]
[null,"Hume","Other",26,"2011-07-04"]
[null,"Hume","PTO",8,"2011-07-04"]
[null,"Hume","Comm",6,"2011-07-04"]
[null,"Hume","Edison",0,"2011-07-11"]
[null,"Hume","PTO",0,"2011-07-11"]
[null,"Hume","Other",21,"2011-07-11"]
[null,"Hume","Comm",19,"2011-07-11"]
[null,"Hume","Edison",0,"2011-07-18"]
[null,"Hume","Other",29,"2011-07-18"]
[null,"Hume","PTO",0,"2011-07-18"]
[null,"Hume","Comm",15,"2011-07-18"]
[null,"Hume","Comm",55,"2011-07-25"]
[null,"Hume","Edison",0,"2011-07-25"]
[null,"Hume","PTO",0,"2011-07-25"]
[null,"Hume","Other",1.5,"2011-07-25"]
[null,"Hume","Edison",0,"2011-08-01"]
[null,"Hume","PTO",0,"2011-08-01"]
[null,"Hume","Other",0,"2011-08-01"]
[null,"Hume","Comm",44,"2011-08-01"]
[null,"Hume","PTO",0,"2011-08-08"]
[null,"Hume","Comm",44.5,"2011-08-08"]
[null,"Hume","Edison",0,"2011-08-08"]
[null,"Hume","Other",5,"2011-08-08"]
[null,"Hume","Edison",0,"2011-08-15"]
[null,"Hume","Other",18,"2011-08-15"]
[null,"Hume","Comm",22,"2011-08-15"]
[null,"Hume","PTO",0,"2011-08-15"]
[null,"Hume","Edison",7,"2011-08-22"]
[null,"Hume","Comm",19.5,"2011-08-22"]
[null,"Hume","PTO",0,"2011-08-22"]
[null,"Hume","Other",13.5,"2011-08-22"]
[null,"Hume","PTO",0,"2011-08-29"]
[null,"Hume","Edison",0,"2011-08-29"]
[null,"Hume","Other",16,"2011-08-29"]
[null,"Hume","Comm",24,"2011-08-29"]
[null,"Hume","Comm",0,"2011-09-05"]
[null,"Hume","Other",0,"2011-09-05"]
[null,"Hume","PTO",40,"2011-09-05"]
[null,"Hume","Edison",0,"2011-09-05"]
[null,"Hume","Dummy2",0,"2011-09-12"]
[null,"Hume","Dummy4",0,"2011-09-12"]
[null,"Hume","Dummy3",0,"2011-09-12"]
[null,"Hume","Edison",5,"2011-09-12"]
[null,"Hume","Comm",7,"2011-09-12"]
[null,"Hume","Other",4,"2011-09-12"]
[null,"Hume","Dummy",0,"2011-09-12"]
[null,"Hume","PTO",24,"2011-09-12"]
[null,"Jones","PTO",0,"2011-06-27"]
[null,"Jones","Other",0,"2011-06-27"]
[null,"Jones","Comm",8.5,"2011-06-27"]
[null,"Jones","Other",0,"2011-07-04"]
[null,"Jones","Comm",44,"2011-07-04"]
[null,"Jones","PTO",8,"2011-07-04"]
[null,"Jones","Comm",50,"2011-07-11"]
[null,"Jones","Other",7.5,"2011-07-11"]
[null,"Jones","PTO",0,"2011-07-11"]
[null,"Jones","Other",16,"2011-07-18"]
[null,"Jones","PTO",0,"2011-07-18"]
[null,"Jones","Comm",29,"2011-07-18"]
[null,"Jones","Comm",32,"2011-07-25"]
[null,"Jones","Other",9.5,"2011-07-25"]
[null,"Jones","PTO",0,"2011-07-25"]
[null,"Jones","PTO",0,"2011-08-01"]
[null,"Jones","Comm",44,"2011-08-01"]
[null,"Jones","Other",9.5,"2011-08-01"]
[null,"Jones","Comm",52,"2011-08-08"]
[null,"Jones","Other",0,"2011-08-08"]
[null,"Jones","PTO",0,"2011-08-08"]
[null,"Jones","Comm",42.5,"2011-08-15"]
[null,"Jones","PTO",0,"2011-08-15"]
[null,"Jones","Other",7.5,"2011-08-15"]
[null,"Jones","Other",2,"2011-08-22"]
[null,"Jones","PTO",0,"2011-08-22"]
[null,"Jones","Comm",40,"2011-08-22"]
[null,"Jones","Comm",46,"2011-08-29"]
[null,"Jones","PTO",0,"2011-08-29"]
[null,"Jones","Other",0,"2011-08-29"]
[null,"Jones","PTO",8,"2011-09-05"]
[null,"Jones","Other",11,"2011-09-05"]
[null,"Jones","Comm",29.5,"2011-09-05"]
[null,"Jones","Dummy4",0,"2011-09-12"]
[null,"Jones","Comm",18,"2011-09-12"]
[null,"Jones","PTO",7,"2011-09-12"]
[null,"Jones","Dummy2",0,"2011-09-12"]
[null,"Jones","Dummy3",0,"2011-09-12"]
[null,"Jones","Other",15,"2011-09-12"]
[null,"Jones","Dummy",0,"2011-09-12"]
[null,"Kauflin","PTO",0,"2011-06-27"]
[null,"Kauflin","Comm",0,"2011-06-27"]
[null,"Kauflin","Other",4.5,"2011-06-27"]
[null,"Kauflin","Other",33,"2011-07-04"]
[null,"Kauflin","Comm",0,"2011-07-04"]
[null,"Kauflin","PTO",8,"2011-07-04"]
[null,"Kauflin","PTO",0,"2011-07-11"]
[null,"Kauflin","Other",40.5,"2011-07-11"]
[null,"Kauflin","Comm",0,"2011-07-11"]
[null,"Kauflin","Other",40,"2011-07-18"]
[null,"Kauflin","PTO",0,"2011-07-18"]
[null,"Kauflin","Comm",0,"2011-07-18"]
[null,"Kauflin","Other",41,"2011-07-25"]
[null,"Kauflin","Comm",0,"2011-07-25"]
[null,"Kauflin","PTO",0,"2011-07-25"]
[null,"Kauflin","Comm",0,"2011-08-01"]
[null,"Kauflin","PTO",0,"2011-08-01"]
[null,"Kauflin","Other",42.5,"2011-08-01"]
[null,"Kauflin","Comm",0,"2011-08-08"]
[null,"Kauflin","PTO",0,"2011-08-08"]
[null,"Kauflin","Other",48,"2011-08-08"]
[null,"Kauflin","Other",53.5,"2011-08-15"]
[null,"Kauflin","Comm",0,"2011-08-15"]
[null,"Kauflin","PTO",0,"2011-08-15"]
[null,"Kauflin","Comm",0,"2011-08-22"]
[null,"Kauflin","PTO",0,"2011-08-22"]
[null,"Kauflin","Other",45.3,"2011-08-22"]
[null,"Kauflin","Other",40,"2011-08-29"]
[null,"Kauflin","Comm",0,"2011-08-29"]
[null,"Kauflin","PTO",0,"2011-08-29"]
[null,"Kauflin","Comm",18.25,"2011-09-05"]
[null,"Kauflin","Other",20,"2011-09-05"]
[null,"Kauflin","PTO",8,"2011-09-05"]
[null,"Kauflin","Comm",8,"2011-09-12"]
[null,"Kauflin","PTO",0,"2011-09-12"]
[null,"Kauflin","Dummy3",0,"2011-09-12"]
[null,"Kauflin","Dummy2",0,"2011-09-12"]
[null,"Kauflin","Dummy4",0,"2011-09-12"]
[null,"Kauflin","Dummy",0,"2011-09-12"]
[null,"Kauflin","Other",32,"2011-09-12"]
[null,"Kozlowski","PTO",0,"2011-06-27"]
[null,"Kozlowski","Other",2,"2011-06-27"]
[null,"Kozlowski","Comm",0,"2011-06-27"]
[null,"Kozlowski","Comm",4,"2011-07-04"]
[null,"Kozlowski","PTO",36,"2011-07-04"]
[null,"Kozlowski","Other",0,"2011-07-04"]
[null,"Kozlowski","Other",8,"2011-07-11"]
[null,"Kozlowski","PTO",0,"2011-07-11"]
[null,"Kozlowski","Comm",46,"2011-07-11"]
[null,"Kozlowski","PTO",0,"2011-07-18"]
[null,"Kozlowski","Comm",28,"2011-07-18"]
[null,"Kozlowski","Other",15.5,"2011-07-18"]
[null,"Kozlowski","Comm",38,"2011-07-25"]
[null,"Kozlowski","PTO",0,"2011-07-25"]
[null,"Kozlowski","Other",17,"2011-07-25"]
[null,"Kozlowski","Other",0,"2011-08-01"]
[null,"Kozlowski","Comm",58.5,"2011-08-01"]
[null,"Kozlowski","PTO",0,"2011-08-01"]
[null,"Kozlowski","Other",14.5,"2011-08-08"]
[null,"Kozlowski","Comm",32.5,"2011-08-08"]
[null,"Kozlowski","PTO",0,"2011-08-08"]
[null,"Kozlowski","Other",13,"2011-08-15"]
[null,"Kozlowski","Comm",37,"2011-08-15"]
[null,"Kozlowski","PTO",0,"2011-08-15"]
[null,"Kozlowski","PTO",0,"2011-08-22"]
[null,"Kozlowski","Comm",3.5,"2011-08-22"]
[null,"Kozlowski","Other",43,"2011-08-22"]
[null,"Kozlowski","PTO",0,"2011-08-29"]
[null,"Kozlowski","Comm",57.5,"2011-08-29"]
[null,"Kozlowski","Other",4,"2011-08-29"]
[null,"Kozlowski","Comm",31.5,"2011-09-05"]
[null,"Kozlowski","PTO",8,"2011-09-05"]
[null,"Kozlowski","Other",11,"2011-09-05"]
[null,"Kozlowski","Other",21,"2011-09-12"]
[null,"Kozlowski","Dummy",0,"2011-09-12"]
[null,"Kozlowski","Dummy3",0,"2011-09-12"]
[null,"Kozlowski","Comm",26,"2011-09-12"]
[null,"Kozlowski","Dummy2",0,"2011-09-12"]
[null,"Kozlowski","Dummy4",0,"2011-09-12"]
[null,"Mills","Comm",0,"2011-06-27"]
[null,"Mills","PTO",8,"2011-06-27"]
[null,"Mills","Other",0,"2011-06-27"]
[null,"Mills","PTO",8,"2011-07-04"]
[null,"Mills","Other",30,"2011-07-04"]
[null,"Mills","Comm",2,"2011-07-04"]
[null,"Mills","PTO",0,"2011-07-11"]
[null,"Mills","Other",40,"2011-07-11"]
[null,"Mills","Comm",0,"2011-07-11"]
[null,"Mills","PTO",0,"2011-07-18"]
[null,"Mills","Comm",2,"2011-07-18"]
[null,"Mills","Other",38,"2011-07-18"]
[null,"Mills","PTO",19,"2011-07-25"]
[null,"Mills","Other",21,"2011-07-25"]
[null,"Mills","Comm",0,"2011-07-25"]
[null,"Mills","Comm",18,"2011-08-01"]
[null,"Mills","PTO",0,"2011-08-01"]
[null,"Mills","Other",22,"2011-08-01"]
[null,"Mills","Comm",12,"2011-08-08"]
[null,"Mills","Other",28,"2011-08-08"]
[null,"Mills","PTO",0,"2011-08-08"]
[null,"Mills","Other",34,"2011-08-15"]
[null,"Mills","PTO",0,"2011-08-15"]
[null,"Mills","Comm",6,"2011-08-15"]
[null,"Mills","PTO",8,"2011-08-22"]
[null,"Mills","Comm",15,"2011-08-22"]
[null,"Mills","Other",21,"2011-08-22"]
[null,"Mills","PTO",0,"2011-08-29"]
[null,"Mills","Comm",5,"2011-08-29"]
[null,"Mills","Other",35,"2011-08-29"]
[null,"Mills","Comm",15,"2011-09-05"]
[null,"Mills","PTO",8,"2011-09-05"]
[null,"Mills","Other",18,"2011-09-05"]
[null,"Mills","Comm",15,"2011-09-12"]
[null,"Mills","Other",25,"2011-09-12"]
[null,"Mills","Dummy",0,"2011-09-12"]
[null,"Mills","Dummy3",0,"2011-09-12"]
[null,"Mills","Dummy4",0,"2011-09-12"]
[null,"Mills","Dummy2",0,"2011-09-12"]
[null,"Newman","PTO",0,"2011-07-18"]
[null,"Newman","Other",0,"2011-07-18"]
[null,"Newman","PTO",0,"2011-08-29"]
[null,"Newman","Other",40,"2011-08-29"]
[null,"Newman","PTO",8,"2011-09-05"]
[null,"Newman","Other",32,"2011-09-05"]
[null,"Newman","Other",40,"2011-09-12"]
[null,"Newman","Dummy4",0,"2011-09-12"]
[null,"Newman","Comm",0,"2011-09-12"]
[null,"Newman","Dummy3",0,"2011-09-12"]
[null,"Newman","Dummy2",0,"2011-09-12"]
[null,"Newman","Dummy",0,"2011-09-12"]
[null,"Paik","Other",8,"2011-06-27"]
[null,"Paik","PTO",0,"2011-06-27"]
[null,"Paik","Comm",0,"2011-06-27"]
[null,"Paik","Comm",0,"2011-07-04"]
[null,"Paik","Other",16,"2011-07-04"]
[null,"Paik","PTO",24,"2011-07-04"]
[null,"Paik","PTO",4,"2011-07-11"]
[null,"Paik","Other",36,"2011-07-11"]
[null,"Paik","Comm",0,"2011-07-11"]
[null,"Paik","Comm",0,"2011-07-18"]
[null,"Paik","Other",40,"2011-07-18"]
[null,"Paik","PTO",0,"2011-07-18"]
[null,"Paik","Other",40,"2011-07-25"]
[null,"Paik","Comm",0,"2011-07-25"]
[null,"Paik","PTO",0,"2011-07-25"]
[null,"Paik","PTO",0,"2011-08-01"]
[null,"Paik","Comm",0,"2011-08-01"]
[null,"Paik","Other",40,"2011-08-01"]
[null,"Paik","Other",40,"2011-08-08"]
[null,"Paik","PTO",0,"2011-08-08"]
[null,"Paik","Comm",0,"2011-08-08"]
[null,"Paik","PTO",0,"2011-08-15"]
[null,"Paik","Other",40,"2011-08-15"]
[null,"Paik","Comm",0,"2011-08-15"]
[null,"Paik","Other",40,"2011-08-22"]
[null,"Paik","PTO",0,"2011-08-22"]
[null,"Paik","Comm",0,"2011-08-22"]
[null,"Paik","Other",29.5,"2011-08-29"]
[null,"Paik","Comm",0,"2011-08-29"]
[null,"Paik","PTO",10.5,"2011-08-29"]
[null,"Paik","Other",30,"2011-09-05"]
[null,"Paik","PTO",8,"2011-09-05"]
[null,"Paik","Comm",2,"2011-09-05"]
[null,"Paik","Other",30,"2011-09-12"]
[null,"Paik","Dummy4",0,"2011-09-12"]
[null,"Paik","PTO",8,"2011-09-12"]
[null,"Paik","Dummy3",0,"2011-09-12"]
[null,"Paik","Comm",2,"2011-09-12"]
[null,"Paik","Dummy",0,"2011-09-12"]
[null,"Paik","Dummy2",0,"2011-09-12"]
[null,"Scherrer","Other",6.5,"2011-06-27"]
[null,"Scherrer","PTO",1.5,"2011-06-27"]
[null,"Scherrer","Comm",0,"2011-06-27"]
[null,"Scherrer","Comm",19,"2011-07-04"]
[null,"Scherrer","PTO",8,"2011-07-04"]
[null,"Scherrer","Other",14.5,"2011-07-04"]
[null,"Scherrer","Other",14.5,"2011-07-11"]
[null,"Scherrer","PTO",24,"2011-07-11"]
[null,"Scherrer","Comm",6,"2011-07-11"]
[null,"Scherrer","Other",21.3,"2011-07-18"]
[null,"Scherrer","Comm",19.3,"2011-07-18"]
[null,"Scherrer","PTO",1,"2011-07-18"]
[null,"Scherrer","Comm",9.8000000000000007,"2011-07-25"]
[null,"Scherrer","PTO",20,"2011-07-25"]
[null,"Scherrer","Other",10.3,"2011-07-25"]
[null,"Scherrer","Other",23.5,"2011-08-01"]
[null,"Scherrer","PTO",0,"2011-08-01"]
[null,"Scherrer","Comm",16.5,"2011-08-01"]
[null,"Scherrer","Comm",17.8,"2011-08-08"]
[null,"Scherrer","Other",24,"2011-08-08"]
[null,"Scherrer","PTO",0,"2011-08-08"]
[null,"Scherrer","PTO",0,"2011-08-15"]
[null,"Scherrer","Comm",22.8,"2011-08-15"]
[null,"Scherrer","Other",26.8,"2011-08-15"]
[null,"Scherrer","Comm",19.8,"2011-08-22"]
[null,"Scherrer","PTO",0,"2011-08-22"]
[null,"Scherrer","Other",22.8,"2011-08-22"]
[null,"Scherrer","Other",25.5,"2011-08-29"]
[null,"Scherrer","PTO",0,"2011-08-29"]
[null,"Scherrer","Comm",26.25,"2011-08-29"]
[null,"Scherrer","Other",20.5,"2011-09-05"]
[null,"Scherrer","Comm",16,"2011-09-05"]
[null,"Scherrer","PTO",8,"2011-09-05"]
[null,"Scherrer","Dummy3",0,"2011-09-12"]
[null,"Scherrer","Comm",28.25,"2011-09-12"]
[null,"Scherrer","Dummy2",0,"2011-09-12"]
[null,"Scherrer","Dummy4",0,"2011-09-12"]
[null,"Scherrer","Dummy",0,"2011-09-12"]
[null,"Scherrer","Other",22.75,"2011-09-12"]
[null,"Spicer","Comm",0,"2011-06-27"]
[null,"Spicer","PTO",0,"2011-06-27"]
[null,"Spicer","Other",0,"2011-06-27"]
[null,"Spicer","Other",0,"2011-07-04"]
[null,"Spicer","Comm",32,"2011-07-04"]
[null,"Spicer","PTO",24,"2011-07-04"]
[null,"Spicer","Other",8,"2011-07-11"]
[null,"Spicer","Comm",42.5,"2011-07-11"]
[null,"Spicer","PTO",0,"2011-07-11"]
[null,"Spicer","Other",7,"2011-07-18"]
[null,"Spicer","Comm",36,"2011-07-18"]
[null,"Spicer","PTO",0,"2011-07-18"]
[null,"Spicer","PTO",18,"2011-07-25"]
[null,"Spicer","Other",2,"2011-07-25"]
[null,"Spicer","Comm",21,"2011-07-25"]
[null,"Spicer","PTO",0,"2011-08-01"]
[null,"Spicer","Other",1.5,"2011-08-01"]
[null,"Spicer","Comm",62,"2011-08-01"]
[null,"Spicer","PTO",0,"2011-08-08"]
[null,"Spicer","Other",2.5,"2011-08-08"]
[null,"Spicer","Comm",61,"2011-08-08"]
[null,"Spicer","PTO",0,"2011-08-15"]
[null,"Spicer","Comm",51.5,"2011-08-15"]
[null,"Spicer","Other",3.5,"2011-08-15"]
[null,"Spicer","PTO",0,"2011-08-22"]
[null,"Spicer","Comm",43,"2011-08-22"]
[null,"Spicer","Other",5,"2011-08-22"]
[null,"Spicer","Comm",46.5,"2011-08-29"]
[null,"Spicer","PTO",0,"2011-08-29"]
[null,"Spicer","Other",5,"2011-08-29"]
[null,"Spicer","Other",13,"2011-09-05"]
[null,"Spicer","PTO",14,"2011-09-05"]
[null,"Spicer","Comm",13,"2011-09-05"]
[null,"Spicer","Other",16.5,"2011-09-12"]
[null,"Spicer","Dummy4",0,"2011-09-12"]
[null,"Spicer","Dummy3",0,"2011-09-12"]
[null,"Spicer","Dummy2",0,"2011-09-12"]
[null,"Spicer","Other",46,"2011-09-12"]
[null,"Spicer","Dummy",0,"2011-09-12"]
[null,"Spicer","Comm",29.5,"2011-09-12"]
[null,"Stacy","Other",0,"2011-06-27"]
[null,"Stacy","Comm",0,"2011-06-27"]
[null,"Stacy","Comm",6.8,"2011-07-04"]
[null,"Stacy","Other",1.5,"2011-07-04"]
[null,"Stacy","Other",6.5,"2011-07-11"]
[null,"Stacy","Comm",18.3,"2011-07-11"]
[null,"Stacy","Comm",14.8,"2011-07-18"]
[null,"Stacy","Other",8.8000000000000007,"2011-07-18"]
[null,"Stacy","Other",1.3,"2011-07-25"]
[null,"Stacy","Comm",17,"2011-07-25"]
[null,"Stacy","Other",10.3,"2011-08-01"]
[null,"Stacy","Comm",10.3,"2011-08-01"]
[null,"Stacy","Other",10,"2011-08-08"]
[null,"Stacy","Comm",8,"2011-08-08"]
[null,"Stacy","Other",18.8,"2011-08-15"]
[null,"Stacy","Comm",14.3,"2011-08-15"]
[null,"Stacy","Comm",4.5,"2011-08-22"]
[null,"Stacy","Other",14,"2011-08-22"]
[null,"Stacy","Other",11.25,"2011-08-29"]
[null,"Stacy","Comm",6.5,"2011-08-29"]
[null,"Stacy","Other",17.25,"2011-09-05"]
[null,"Stacy","Comm",3.75,"2011-09-05"]
[null,"Stacy","Dummy",0,"2011-09-12"]
[null,"Stacy","Other",16.25,"2011-09-12"]
[null,"Stacy","Comm",2,"2011-09-12"]
[null,"Stacy","Dummy4",0,"2011-09-12"]
[null,"Stacy","Dummy3",0,"2011-09-12"]
[null,"Stacy","Dummy2",0,"2011-09-12"]
[null,"Steinberg","Dummy3",0,"2011-09-12"]
[null,"Steinberg","Dummy2",0,"2011-09-12"]
[null,"Steinberg","Dummy",0,"2011-09-12"]
[null,"Steinberg","Other",41.25,"2011-09-12"]
[null,"Steinberg","Dummy4",0,"2011-09-12"]
[null,"Steinberg","PTO",8.75,"2011-09-12"]
[null,"Steinberg","Other",32.5,"2011-09-12"]
[null,"Stuart","PTO",0,"2011-06-27"]
[null,"Stuart","Comm",3,"2011-06-27"]
[null,"Stuart","Other",0,"2011-06-27"]
[null,"Stuart","Comm",12,"2011-07-04"]
[null,"Stuart","Other",12,"2011-07-04"]
[null,"Stuart","PTO",8,"2011-07-04"]
[null,"Stuart","Comm",33,"2011-07-11"]
[null,"Stuart","PTO",0,"2011-07-11"]
[null,"Stuart","Other",10,"2011-07-11"]
[null,"Stuart","Comm",28.8,"2011-07-18"]
[null,"Stuart","PTO",0,"2011-07-18"]
[null,"Stuart","Other",17.3,"2011-07-18"]
[null,"Stuart","PTO",0,"2011-07-25"]
[null,"Stuart","Other",22.5,"2011-07-25"]
[null,"Stuart","Comm",23,"2011-07-25"]
[null,"Stuart","PTO",0,"2011-08-01"]
[null,"Stuart","Comm",54.3,"2011-08-01"]
[null,"Stuart","Other",2,"2011-08-01"]
[null,"Stuart","Comm",48.3,"2011-08-08"]
[null,"Stuart","PTO",0,"2011-08-08"]
[null,"Stuart","Other",2,"2011-08-08"]
[null,"Stuart","PTO",0,"2011-08-15"]
[null,"Stuart","Comm",47,"2011-08-15"]
[null,"Stuart","Other",6,"2011-08-15"]
[null,"Stuart","PTO",0,"2011-08-22"]
[null,"Stuart","Other",43.8,"2011-08-22"]
[null,"Stuart","Comm",0,"2011-08-22"]
[null,"Stuart","Comm",25.75,"2011-08-29"]
[null,"Stuart","PTO",0,"2011-08-29"]
[null,"Stuart","Other",14.25,"2011-08-29"]
[null,"Stuart","Comm",8,"2011-09-05"]
[null,"Stuart","Other",24.75,"2011-09-05"]
[null,"Stuart","PTO",8,"2011-09-05"]
[null,"Stuart","Dummy4",0,"2011-09-12"]
[null,"Stuart","Dummy",0,"2011-09-12"]
[null,"Stuart","Dummy3",0,"2011-09-12"]
[null,"Stuart","Comm",19,"2011-09-12"]
[null,"Stuart","Other",19.75,"2011-09-12"]
[null,"Stuart","Dummy2",0,"2011-09-12"]
[null,"Via","PTO",0,"2011-06-27"]
[null,"Via","Other",4,"2011-06-27"]
[null,"Via","Comm",4,"2011-06-27"]
[null,"Via","Comm",17.5,"2011-07-04"]
[null,"Via","Other",25.5,"2011-07-04"]
[null,"Via","PTO",8,"2011-07-04"]
[null,"Via","Comm",32,"2011-07-11"]
[null,"Via","Other",22.8,"2011-07-11"]
[null,"Via","PTO",0,"2011-07-11"]
[null,"Via","PTO",0,"2011-07-18"]
[null,"Via","Comm",24,"2011-07-18"]
[null,"Via","Other",28,"2011-07-18"]
[null,"Via","Comm",21,"2011-07-25"]
[null,"Via","Other",34.5,"2011-07-25"]
[null,"Via","PTO",0,"2011-07-25"]
[null,"Via","Other",25,"2011-08-01"]
[null,"Via","PTO",16,"2011-08-01"]
[null,"Via","Comm",1,"2011-08-01"]
[null,"Via","PTO",8,"2011-08-08"]
[null,"Via","Other",20.5,"2011-08-08"]
[null,"Via","Comm",24,"2011-08-08"]
[null,"Via","Comm",28.5,"2011-08-15"]
[null,"Via","Other",20,"2011-08-15"]
[null,"Via","PTO",0,"2011-08-15"]
[null,"Via","PTO",0,"2011-08-22"]
[null,"Via","Other",25,"2011-08-22"]
[null,"Via","Comm",32,"2011-08-22"]
[null,"Via","PTO",0,"2011-08-29"]
[null,"Via","Comm",25,"2011-08-29"]
[null,"Via","Other",27,"2011-08-29"]
[null,"Via","Comm",11.5,"2011-09-05"]
[null,"Via","Other",27,"2011-09-05"]
[null,"Via","PTO",8,"2011-09-05"]
[null,"Via","Comm",11.5,"2011-09-12"]
[null,"Via","Dummy4",0,"2011-09-12"]
[null,"Via","Dummy",0,"2011-09-12"]
[null,"Via","Dummy3",0,"2011-09-12"]
[null,"Via","PTO",4,"2011-09-12"]
[null,"Via","Dummy2",0,"2011-09-12"]
[null,"Via","Other",34,"2011-09-12"]

{"sheet":"Goal","index":1,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Table2"]
[null,"Consultant","Week","Goal","Avg",null,"Consultant","Bebko"]
[null,"Bebko",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},22,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":24.333333333333332},null,"PivotTable1",null,null,null,{"$f":"((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":12}]
[null,"Bebko",{"$f":"MAX(Table1[Week])","v":"2011-09-12"},null,null,null,"Week","_Goal","_Avg"]
[null,"Brewer",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},16,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":14.770833333333334},null,"6/27/2011 - 7/3/2011",22,24.333333333333332]
[null,"Brewer",{"$f":"MAX(Table1[Week])","v":"2011-09-12"},null,null,null,"7/4/2011 - 7/10/2011",22,24.333333333333332]
[null,"Bunn",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},10,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":13.333333333333334},null,"7/11/2011 - 7/17/2011",22,24.333333333333332]
[null,"Bunn",{"$f":"MAX(Table1[Week])","v":"2011-09-12"},null,null,null,"7/18/2011 - 7/24/2011",22,24.333333333333332]
[null,"Byers",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},1,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":0.83333333333333337},null,"7/25/2011 - 7/31/2011",22,24.333333333333332]
[null,"Byers",{"$f":"MAX(Table1[Week])","v":"2011-09-12"},null,null,null,"8/1/2011 - 8/7/2011",22,24.333333333333332]
[null,"Dillion",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},8,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":7.083333333333333},null,"8/8/2011 - 8/14/2011",22,24.333333333333332]
[null,"Dillion",{"$f":"MAX(Table1[Week])","v":"2011-09-12"},null,null,null,"8/15/2011 - 8/21/2011",22,24.333333333333332]
[null,"D'Silva",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},30,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":27.75},null,"8/22/2011 - 8/28/2011",22,24.333333333333332]
[null,"D'Silva",{"$f":"MAX(Table1[Week])","v":"2011-09-12"},null,null,null,"8/29/2011 - 9/4/2011",22,24.333333333333332]
[null,"Furlow",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},4,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":3.3333333333333335},null,"9/5/2011 - 9/11/2011",22,24.333333333333332]
[null,"Furlow",{"$f":"MAX(Table1[Week])","v":"2011-09-12"},null,null,null,"9/12/2011 - 9/13/2011",22,24.333333333333332]
[null,"Hume",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},24,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":22.333333333333332},null,"Grand Total"]
[null,"Hume",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Jones",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},32,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":36.291666666666664}]
[null,"Jones",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Kauflin",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},4,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":2.1875}]
[null,"Kauflin",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Kozlowski",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},33,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":30.208333333333332}]
[null,"Kozlowski",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Mills",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},8,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":7.5}]
[null,"Mills",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Newman",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},1,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":0}]
[null,"Newman",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Paik",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},1,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":0.33333333333333331}]
[null,"Paik",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Scherrer",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},18,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":16.791666666666668}]
[null,"Scherrer",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Spicer",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},38,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":36.5}]
[null,"Spicer",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Stacy",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},10,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":8.8541666666666661}]
[null,"Stacy",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Steinberg",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},1,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":0}]
[null,"Steinberg",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Stuart",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},28,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":25.179166666666664}]
[null,"Stuart",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]
[null,"Via",{"$f":"MIN(Table1[Week])","v":"2011-06-27"},22,{"$f":"(SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Comm\")+SUMIFS(Table1[Hours],Table1[Consultant],Table2[[#This Row],[Consultant]],Table1[Category],\"Edison\"))/((MAX(Table1[Week])-MIN(Table1[Week]))/7+1)","v":19.333333333333332}]
[null,"Via",{"$f":"MAX(Table1[Week])","v":"2011-09-12"}]