{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PivotTable","Aux","AdvFilter"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":2},"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":"PivotTable","index":0,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Table3"]
[null,"NName",null,null,null,null,null,"Excel 2010",null,null,null,null,"Excel 2007"]
[null,"Scott",null,null,null,null,null,"PivotTable1",null,null,null,null,"PivotTable2"]
[null,null,null,null,null,null,null,"Frank",1,null,null,null,"Scott",1]
[null,"Table2"]
[null,"Tag","Bin_1","Bin_2","Bin_3","Amt",null,"Bin_1","Bin_2","Bin_3","Sum of Amt",null,"Bin_1","Bin_2","Bin_3","Sum of Amt"]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Larry","Jeffrey",64.010000000000005,null,"Eric","Eric","Scott",55.27,null,"Eric","Eric","Scott",55.27]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Eric","Frank",39.39,null,"Eric","Jeffrey","Scott",74.28,null,null,"Jeffrey","Scott",74.28]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Jose","Larry",65.73,null,"Frank","Scott","Jeffrey",33.090000000000003,null,"Frank","Scott","Jeffrey",33.090000000000003]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Jeffrey","Frank",56.95,null,"Jeffrey","Scott","Scott",63.32,null,"Jeffrey","Scott","Scott",63.32]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Jose","Jose","Larry",47.71,null,"Jose","Scott","Frank",48.16,null,"Jose","Scott","Frank",48.16]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Jeffrey","Scott","Scott",63.32,null,"Scott","Eric","Eric",33.479999999999997,null,"Scott","Eric","Eric",33.479999999999997]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Larry","Jose","Frank",44.62,null,"Scott","Frank","Larry",66.36,null,null,"Frank","Larry",66.36]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Larry","Jose","Jeffrey",18.64,null,"Scott","Jose","Eric",96.72,null,null,"Jose","Eric",96.72]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Jose","Larry",46.18,null,"Scott","Jose","Larry",111.91,null,null,null,"Larry",111.91]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Eric","Eric",33.479999999999997,null,"Scott","Larry","Jeffrey",64.010000000000005,null,null,"Larry","Jeffrey",64.010000000000005]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Jeffrey","Larry","Larry",17.95,null,"Scott","Larry","Jose",40.119999999999997,null,null,null,"Jose",40.119999999999997]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Jeffrey","Eric","Larry",74.62,null,"Scott","Scott","Jose",52.68,null,null,"Scott","Jose",52.68]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Jeffrey","Jose",79.930000000000007,null,"Grand Total",null,null,739.4,null,"Grand Total",null,null,739.4]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Frank","Larry",45.36]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Eric","Eric","Scott",55.27]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Eric","Larry",12.02]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Eric","Jeffrey",36.549999999999997]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Larry","Jose",12.11]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Frank","Scott","Jeffrey",33.090000000000003]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Larry","Jeffrey",68.569999999999993]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Jeffrey","Eric",43.28]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Larry","Eric","Larry",83.71]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Larry","Frank",96.56]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Jeffrey","Larry","Eric",53.38]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Frank","Jeffrey",40.04]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Larry","Jeffrey",23.51]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Scott","Jose",52.68]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Frank","Larry",21]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Jeffrey","Larry",24.12]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Jose","Jose","Eric",26.46]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Jose","Scott","Frank",48.16]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Larry","Frank",37.03]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Eric","Jose",61.94]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Jose","Eric",96.72]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Scott","Larry","Jose",40.119999999999997]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Eric","Larry","Larry",61.5]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Jeffrey","Eric","Eric",10.43]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":1},"Eric","Jeffrey","Scott",74.28]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Larry","Jeffrey",39.06]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Jose","Eric","Jeffrey",90.87]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Jose","Jose",50.44]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Jose","Larry",93.68]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Larry","Larry","Frank",59.88]
[null,{"$f":"--(COUNTIF(Table2[[#This Row],[Bin_1]:[Bin_3]],NName)>0)","v":0},"Frank","Jeffrey","Eric",40.450000000000003]

{"sheet":"Aux","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"NName"]
[null,"Jose"]
[null,"Larry"]
[null,"Jeffrey"]
[null,"Frank"]
[null,"Scott"]
[null,"Eric"]

{"sheet":"AdvFilter","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"Table5"]
[null,"Bin_1","Bin_2","Bin_3"]
[null,"Larry"]
[null,null,"Larry"]
[null,null,null,"Larry"]
[]
[]
[null,"Table4",null,null,null,null,"Table6"]
[null,"Bin_1","Bin_2","Bin_3","Amt",null,"Bin_1","Bin_2","Bin_3","Amt"]
[null,"Frank","Frank","Jose",58.61,null,"Larry","Eric","Jose",29.35]
[null,"Larry","Eric","Jose",29.35,null,"Eric","Larry","Scott",25.94]
[null,"Scott","Frank","Eric",87.54,null,"Larry","Scott","Frank",67.72]
[null,"Jose","Frank","Jose",28.89,null,"Scott","Larry","Larry",61.63]
[null,"Jose","Scott","Eric",79.209999999999994,null,"Eric","Jeffrey","Larry",18.97]
[null,"Eric","Larry","Scott",25.94,null,"Larry","Jeffrey","Frank",31.03]
[null,"Scott","Jose","Frank",19.16,null,"Scott","Larry","Scott",90.85]
[null,"Larry","Scott","Frank",67.72,null,"Jose","Scott","Larry",20.84]
[null,"Frank","Eric","Eric",53.17,null,"Jeffrey","Larry","Frank",20.72]
[null,"Jose","Eric","Frank",86.76,null,"Larry","Jeffrey","Jeffrey",68.64]
[null,"Jose","Scott","Scott",20.66,null,"Eric","Scott","Larry",14.58]
[null,"Scott","Larry","Larry",61.63,null,"Frank","Frank","Larry",12.86]
[null,"Eric","Jeffrey","Larry",18.97,null,"Larry","Larry","Frank",15.27]
[null,"Jeffrey","Eric","Frank",71.61,null,"Larry","Eric","Scott",62.42]
[null,"Larry","Jeffrey","Frank",31.03,null,"Larry","Jeffrey","Larry",31.46]
[null,"Jeffrey","Scott","Jeffrey",14.58,null,"Jose","Frank","Larry",30.73]
[null,"Scott","Larry","Scott",90.85,null,"Larry","Larry","Jeffrey",97.8]
[null,"Jose","Scott","Larry",20.84,null,"Jeffrey","Jeffrey","Larry",54.32]
[null,"Jeffrey","Larry","Frank",20.72,null,"Scott","Frank","Larry",45.44]
[null,"Jose","Scott","Scott",57.37]
[null,"Frank","Frank","Eric",90.39]
[null,"Frank","Frank","Jose",30.16]
[null,"Larry","Jeffrey","Jeffrey",68.64]
[null,"Frank","Scott","Jose",93.64]
[null,"Scott","Frank","Jose",27.95]
[null,"Eric","Scott","Larry",14.58]
[null,"Eric","Scott","Eric",73.760000000000005]
[null,"Frank","Frank","Larry",12.86]
[null,"Eric","Eric","Scott",57.08]
[null,"Frank","Frank","Scott",84.14]
[null,"Jeffrey","Jeffrey","Jose",77.31]
[null,"Larry","Larry","Frank",15.27]
[null,"Eric","Jeffrey","Eric",24.22]
[null,"Larry","Eric","Scott",62.42]
[null,"Larry","Jeffrey","Larry",31.46]
[null,"Scott","Eric","Frank",74.36]
[null,"Jose","Frank","Larry",30.73]
[null,"Larry","Larry","Jeffrey",97.8]
[null,"Jeffrey","Jeffrey","Larry",54.32]
[null,"Jose","Frank","Jose",84.94]
[null,"Jose","Jeffrey","Jose",76.55]
[null,"Frank","Jeffrey","Jeffrey",18.96]
[null,"Scott","Frank","Larry",45.44]
[null,"Frank","Frank","Scott",10.44]