{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Help"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":116,"n_cols":11,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Table1"]
[null,"wk_1",null,"NName","DDate","VVeek","Qty",null,"NName","VVeek","Sum"]
[null,{"$f":"WEEKNUM(TODAY())","v":20},null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},{"$f":"TODAY()-RANDBETWEEN(-30,30)","v":"2010-04-14"},{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},{"$f":"RANDBETWEEN(1,30)","v":7},null,"James",null,16.25]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Thomas"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},1,null,null,16,24]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-04-13",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},24,null,null,17,45]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-06-11",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},26,null,null,19,19]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Joseph"},"2010-05-06",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},4,null,null,20,68]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-17",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},2,null,null,22,14]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-04-30",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},1,null,null,23,54]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-05-05",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},21,null,null,24,36]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-24",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},28,null,"John",null,14.071428571428571]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-04-25",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},13,null,null,16,9]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-04-19",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},25,null,null,17,38]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-05-09",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},5,null,null,18,62]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-10",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},15,null,null,19,29]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-18",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},26,null,null,20,12]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-05-14",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},16,null,null,21,28]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-04-25",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},3,null,null,22,19]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-04-29",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},17,null,"Michael",null,14.6]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-06-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},26,null,null,16,19]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-25",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},17,null,null,17,35]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-04-22",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},22,null,null,18,20]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-04-18",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},2,null,null,19,40]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-29",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},4,null,null,20,50]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-06-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},18,null,null,21,40]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-05-09",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},20,null,null,22,43]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-06-11",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},19,null,null,23,45]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},16,null,"William",null,20.733333333333334]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Charles"},"2010-05-14",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},12,null,null,16,68]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-05-17",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},13,null,null,17,19]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Charles"},"2010-06-05",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},10,null,null,19,46]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-04-28",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},9,null,null,20,40]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-05-22",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},26,null,null,22,46]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-06-03",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},23,null,null,23,68]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},{"$f":"TODAY()-RANDBETWEEN(-30,30)","v":"2010-05-21"},{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},27,null,null,24,24]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-04-16",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},26,null,"Robert",null,10.666666666666666]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},{"$f":"RANDBETWEEN(1,30)","v":26},null,null,16,14]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-06-08",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},27,null,null,17,15]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},29,null,null,18,2]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-05-26",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},12,null,null,19,1]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-06-07",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},25,null,null,20,27]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-31",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},23,null,null,21,30]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-06-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},5,null,null,24,7]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-28",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},5,null,"Charles",null,14]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-05-15",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},29,null,null,20,11]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-31",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},16,null,null,21,8]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-12",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},7,null,null,22,66]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-04-26",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},5,null,null,24,13]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-06-01",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},18,null,"Richard",null,11.6]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-04-22",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},20,null,null,16,25]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Charles"},"2010-06-07",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},9,null,null,17,30]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-06-06",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},15,null,null,20,6]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-05-06",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},29,null,null,21,27]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Charles"},"2010-05-30",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},11,null,null,23,28]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-27",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},5,null,"David",null,19.733333333333334]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Thomas"},"2010-06-07",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},6,null,null,17,24]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-05-10",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},1,null,null,18,13]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-05-14",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},19,null,null,19,50]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-05-25",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},12,null,null,20,59]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-06-11",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},27,null,null,21,82]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-05-03",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},14,null,null,22,57]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-04-25",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},13,null,null,23,11]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Charles"},"2010-05-24",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},8,null,"Joseph",null,22.25]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-05-18",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},19,null,null,16,29]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-04-17",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},3,null,null,18,2]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-27",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},1,null,null,19,30]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},{"$f":"TODAY()-RANDBETWEEN(-30,30)","v":"2010-06-08"},{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},30,null,null,20,28]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},8,null,"Thomas",null,15]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-04-24",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},20,null,null,17,15]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-04-15",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},11]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-06-05",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},5]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},30]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-06-03",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},7]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-21",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},12]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Joseph"},"2010-06-09",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},23]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-04-21",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},25]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-04-15",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},8]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},9]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-04-22",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},7]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-06-09",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},20]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-16",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},18]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-16",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},2]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-15",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},4]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-15",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},5]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-30",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},12]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-05-31",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},27]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-04-20",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},15]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-04-13",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},27]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-05-11",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},30]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-05-20",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":21},28]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},18]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-24",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},23]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-04-20",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},19]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-04-23",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},23]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-04-17",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},15]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-04-18",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},25]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},"2010-06-07",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},2]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-05",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},3]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Richard"},{"$f":"TODAY()-RANDBETWEEN(-30,30)","v":"2010-04-21"},{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},14]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-03",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},15]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-06-10",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},{"$f":"RANDBETWEEN(1,30)","v":25}]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Thomas"},"2010-04-23",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":17},28]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-30",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":23},4]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-04-15",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},12]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"James"},"2010-06-08",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":24},22]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Michael"},"2010-04-15",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},8]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-05-04",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},7]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-09",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},8]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"David"},"2010-04-16",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":16},3]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"John"},"2010-05-02",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":19},19]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Joseph"},"2010-04-28",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":18},8]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"William"},"2010-05-28",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":22},15]
[null,null,null,{"$f":"INDEX(Table2[NName],RANDBETWEEN(1,RANDBETWEEN(5,10)))","v":"Robert"},"2010-05-11",{"$f":"WEEKNUM(Table1[[#This Row],[DDate]],1)","v":20},19]

{"sheet":"Help","index":1,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"NName",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," I would like to apply a conditional format to the last"]
[null,"James",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"two weeks (the two most current weeks) and highlight cells that are 2 times"]
[null,"John",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"greater than the Average."]
[null,"Robert"]
[null,"Michael"]
[null,"William"]
[null,"David"]
[null,"Richard"]
[null,"Charles"]
[null,"Joseph"]
[null,"Thomas"]
[null,"Christopher"]
[null,"Daniel"]
[null,"Paul"]
[null,"Mark"]
[null,"Donald"]
[null,"George"]
[null,"Kenneth"]
[null,"Steven"]
[null,"Edward"]
[null,"Brian"]
[null,"Ronald"]
[null,"Anthony"]
[null,"Kevin"]
[null,"Jason"]