{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AdvFilt","Code"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"AdvFilt","index":0,"n_rows":208,"n_cols":18,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table2",null,null,null,"Table8",null,null,"Table6"]
[null,"Product","Year",null,null,"Rank",null,null,"Rank",null,null,null,null,null,"For Comparison"]
[null,"B",2009,null,null,{"$f":"COUNTIFS(Table4[BinB],\">\"&INDEX(Table4[BinB],rown))+COUNTIF(INDEX(Table4[BinB],COUNTA(Table4[BinB])):INDEX(Table4[BinB],rown),Table4[BinB])","v":{"$error":"#VALUE!"}},null,null,"<=10",null,null,null,null,null,"no formulas, no code"]
[]
[null,"Table3",null,null,null,"Table4",null,null,null,null,"Table7",null,null,null,"PivotTable1"]
[null,"Product","Year","BinB",null,"Product","Year","BinB","Rank",null,"Product","Year","BinB",null,"Product","Year","BinB","Max"]
[null,"C",2008,65.180000000000007,null,"B",2009,58.78,null,null,"B",2009,65.680000000000007,null,"B",2009,65.680000000000007,65.680000000000007]
[null,"A",2009,80.22,null,"B",2009,76.010000000000005,null,null,"B",2009,69.73,null,null,null,69.73,69.73]
[null,"C",2009,28.56,null,"B",2009,58.14,null,null,"B",2009,76.010000000000005,null,null,null,76.010000000000005,76.010000000000005]
[null,"A",2010,72.34,null,"B",2009,14.63,null,null,"B",2009,78.22,null,null,null,78.22,78.22]
[null,"B",2010,61.08,null,"B",2009,31.35,null,null,"B",2009,79.39,null,null,null,79.39,79.39]
[null,"A",2009,69.55,null,"B",2009,78.22,null,null,"B",2009,85.79,null,null,null,85.79,85.79]
[null,"B",2009,58.78,null,"B",2009,46.94,null,null,"B",2009,94.09,null,null,null,94.09,94.09]
[null,"C",2009,42.98,null,"B",2009,69.73,null,null,"B",2009,97.35,null,null,null,97.35,97.35]
[null,"A",2009,62.8,null,"B",2009,21.6,null,null,"B",2009,98.79,null,null,null,98.79,98.79]
[null,"A",2009,56.25,null,"B",2009,79.39,null,null,"B",2009,99.09,null,null,null,99.09,99.09]
[null,"C",2009,55.53,null,"B",2009,59.76]
[null,"A",2010,70.849999999999994,null,"B",2009,99.09]
[null,"B",2009,76.010000000000005,null,"B",2009,14.98]
[null,"C",2008,31.56,null,"B",2009,38.770000000000003]
[null,"A",2008,92.21,null,"B",2009,98.79]
[null,"B",2008,18.12,null,"B",2009,65.680000000000007]
[null,"B",2008,31.21,null,"B",2009,97.35]
[null,"B",2009,58.14,null,"B",2009,21.88]
[null,"B",2009,14.63,null,"B",2009,94.09]
[null,"A",2010,99.37,null,"B",2009,16.96]
[null,"C",2010,39.799999999999997,null,"B",2009,85.79]
[null,"C",2010,10.92]
[null,"A",2010,62.99]
[null,"A",2009,48.56]
[null,"A",2010,29.88]
[null,"C",2010,69.47]
[null,"B",2008,75.650000000000006]
[null,"A",2009,85.88]
[null,"B",2009,31.35]
[null,"C",2010,15.56]
[null,"C",2009,10.44]
[null,"A",2009,59.9]
[null,"C",2010,65.16]
[null,"B",2010,51.38]
[null,"A",2009,77.08]
[null,"B",2010,50.59]
[null,"B",2010,57.93]
[null,"C",2008,22.39]
[null,"C",2010,36.57]
[null,"B",2009,78.22]
[null,"C",2009,84.39]
[null,"B",2008,85.48]
[null,"B",2009,46.94]
[null,"C",2008,80.38]
[null,"C",2008,80.92]
[null,"B",2008,20.99]
[null,"A",2009,24.49]
[null,"C",2008,78.459999999999994]
[null,"B",2009,69.73]
[null,"C",2008,78.22]
[null,"B",2010,38.14]
[null,"B",2008,69.930000000000007]
[null,"B",2010,46.39]
[null,"C",2008,13.18]
[null,"B",2009,21.6]
[null,"A",2009,92.43]
[null,"B",2010,82.95]
[null,"B",2010,81.459999999999994]
[null,"C",2010,85.54]
[null,"B",2010,41.36]
[null,"C",2010,35.15]
[null,"A",2008,38.93]
[null,"B",2010,51.34]
[null,"B",2008,68.09]
[null,"A",2009,68.430000000000007]
[null,"A",2008,24.55]
[null,"B",2010,27.56]
[null,"A",2008,59.33]
[null,"C",2009,68.48]
[null,"C",2009,56.78]
[null,"B",2010,52.3]
[null,"B",2008,68.41]
[null,"A",2010,89.79]
[null,"C",2009,26.5]
[null,"C",2010,30.19]
[null,"B",2010,79.64]
[null,"C",2010,17.23]
[null,"C",2009,16.059999999999999]
[null,"C",2008,12.45]
[null,"B",2008,89.75]
[null,"C",2008,23.14]
[null,"A",2008,47.28]
[null,"C",2008,92.03]
[null,"C",2009,10.98]
[null,"B",2008,52.81]
[null,"B",2010,38.880000000000003]
[null,"A",2010,22.38]
[null,"B",2010,85.31]
[null,"A",2009,62.4]
[null,"A",2010,91.11]
[null,"C",2009,31.97]
[null,"A",2008,16.329999999999998]
[null,"C",2010,80.290000000000006]
[null,"C",2008,34.979999999999997]
[null,"A",2009,72.13]
[null,"B",2009,79.39]
[null,"C",2008,66.78]
[null,"A",2010,38.11]
[null,"C",2008,62.96]
[null,"B",2008,28.77]
[null,"A",2008,41.7]
[null,"C",2009,14.73]
[null,"B",2009,59.76]
[null,"C",2008,53.19]
[null,"A",2009,83.24]
[null,"B",2008,93.97]
[null,"A",2010,87.95]
[null,"A",2008,17.52]
[null,"A",2009,60.06]
[null,"C",2009,62.36]
[null,"A",2008,17.52]
[null,"C",2010,31.97]
[null,"C",2009,84.36]
[null,"A",2010,36.83]
[null,"C",2010,10.94]
[null,"C",2010,44.21]
[null,"C",2008,97.3]
[null,"C",2009,96.12]
[null,"A",2008,49.67]
[null,"A",2010,64.47]
[null,"C",2010,23.11]
[null,"A",2008,44.35]
[null,"C",2008,32.479999999999997]
[null,"B",2008,37.200000000000003]
[null,"A",2008,64.84]
[null,"A",2008,17.52]
[null,"C",2008,12.62]
[null,"A",2010,89.06]
[null,"A",2008,41.2]
[null,"A",2008,82.35]
[null,"C",2009,91.89]
[null,"C",2010,29.29]
[null,"A",2008,44.33]
[null,"C",2009,78.58]
[null,"A",2008,96.54]
[null,"C",2009,58.62]
[null,"C",2008,39.32]
[null,"C",2008,34.4]
[null,"A",2008,83.34]
[null,"B",2010,99.76]
[null,"B",2009,99.09]
[null,"C",2010,80.45]
[null,"C",2009,84.98]
[null,"B",2010,83.28]
[null,"B",2008,42.36]
[null,"A",2010,58.07]
[null,"A",2010,30.26]
[null,"C",2009,44.67]
[null,"A",2009,53.59]
[null,"A",2010,40.799999999999997]
[null,"C",2009,90.46]
[null,"B",2009,14.98]
[null,"C",2010,54.95]
[null,"B",2009,38.770000000000003]
[null,"B",2008,23.72]
[null,"B",2008,97.62]
[null,"C",2009,33.72]
[null,"B",2009,98.79]
[null,"B",2008,25.34]
[null,"A",2010,61.6]
[null,"C",2009,54.22]
[null,"A",2009,35.200000000000003]
[null,"A",2009,36.450000000000003]
[null,"C",2009,16.7]
[null,"B",2010,18.46]
[null,"A",2010,95.62]
[null,"B",2010,43.72]
[null,"C",2008,90.09]
[null,"C",2009,43.36]
[null,"C",2009,35.979999999999997]
[null,"B",2009,65.680000000000007]
[null,"A",2010,74.97]
[null,"C",2009,88.53]
[null,"A",2009,56.66]
[null,"B",2008,52.72]
[null,"B",2009,97.35]
[null,"B",2008,53.98]
[null,"B",2009,21.88]
[null,"C",2009,17.75]
[null,"C",2008,89.74]
[null,"C",2010,39.11]
[null,"C",2010,28.22]
[null,"A",2009,86.77]
[null,"C",2010,38.29]
[null,"C",2010,21.25]
[null,"C",2010,81.790000000000006]
[null,"A",2009,31.73]
[null,"C",2010,68.84]
[null,"A",2010,92.22]
[null,"A",2008,86.82]
[null,"B",2009,94.09]
[null,"C",2009,39.26]
[null,"B",2009,16.96]
[null,"C",2009,67.27]
[null,"C",2008,74.45]
[null,"C",2008,79.03]
[null,"B",2009,85.79]
[null,"C",2008,12.12]
[null,"B",2008,76.319999999999993]
[null,"A",2008,51.16]
[null,"A",2008,43.65]

{"sheet":"Code","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}