{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":9},"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":"Sheet1","index":0,"n_rows":196,"n_cols":23,"rows_kept":196,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Duplicate Reference Report Filter using Slicer"]
[]
[null,null,null,null,null,null,null,null,"Reference"]
[null,"Table2",null,null,null,null,null,null,"PivotTable1",null,null,"PivotTable2",null,null,"PivotTable3",null,null,"PivotTable4",null,null,"PivotTable5"]
[null,"DDate","NName","Src","Dest","Bin","Value",null,"NName","(Multiple Items)",null,"Bin","(Multiple Items)",null,"NName","(Multiple Items)",null,"NName","(Multiple Items)",null,"NName","(Multiple Items)"]
[null,{"$f":"DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2012-05-29"},"Lewis","CHN","CO","F",47,null,"Bin","(Multiple Items)",null,null,null,null,"Bin","(Multiple Items)",null,"DDate","(Multiple Items)",null,"Bin","(Multiple Items)"]
[null,"2012-06-29","Allen","BRA","AZ","B",25,null,"Dest","(Multiple Items)",null,"Dest","_Value",null,"Src","(Multiple Items)"]
[null,"2012-09-24","Rodriguez","CAN","CT","J",46,null,"DDate","(Multiple Items)",null,"AK",509,null,null,null,null,"Dest","_Value",null,"Dest","Src","_Value"]
[null,"2012-06-04","Allen","BRA","AR","D",39,null,null,null,null,"AL",447,null,"Dest","_Value",null,"AK",520,null,"AK"]
[null,"2012-03-18","Lee","CAN","CA","K",81,null,null,null,null,"AZ",764,null,"AK",141,null,"AL",283,null,null,"AUS",32]
[null,"2012-03-28","Young","CHN","AZ","K",74,null,null,null,null,"CA",616,null,"AL",68,null,"AZ",134,null,null,"BEL",20]
[null,"2012-07-09","Rodriguez","ARG","CO","K",99,null,null,null,null,"CT",454,null,"AZ",202,null,"CA",339,null,null,"CAN",51]
[null,"2012-08-27","Clark","CHN","FL","H",15,null,null,null,null,"FL",300,null,"CA",13,null,"CT",135,null,"AL"]
[null,"2012-10-23","Robinson","AUT","DE","H",38,null,null,null,null,null,null,null,"CT",259,null,"FL",115,null,null,"BEL",35]
[null,"2012-08-02","Hall","CAN","AK","G",85,null,null,null,null,null,null,null,"FL",16,null,null,null,null,null,"CAN",151]
[null,"2012-10-23","Walker","AUT","AL","J",47,null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ"]
[null,"2012-02-02","Allen","ARG","AZ","J",26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHN",83]
[null,"2012-02-11","Clark","BRA","CA","D",92,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA"]
[null,"2012-11-04","Walker","CAN","AK","H",93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAN",35]
[null,"2012-02-03","Robinson","CHI","GA","J",48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHN",149]
[null,"2012-08-09","Lee","CHN","CA","J",59,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL"]
[null,"2012-06-12","Lee","AUT","AL","K",73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEL",81]
[null,"2012-10-06","Walker","CHN","GA","J",35]
[null,"2012-09-30","Lewis","CHN","CO","L",57]
[null,"2012-02-15","Robinson","ARG","DE","J",71]
[null,"2012-11-19","Allen","AUT","AL","H",56]
[null,"2012-01-09","Robinson","CHI","CA","K",37]
[null,"2012-06-08","Lee","CHI","DE","K",56]
[null,"2012-03-15","Lee","BRA","FL","D",16]
[null,"2012-11-10","Rodriguez","BEL","CO","D",90]
[null,"2012-04-10","Hall","ARG","AR","H",30]
[null,"2012-05-18","Allen","ARG","AL","K",84]
[null,"2012-04-23","Rodriguez","ARG","AK","H",79]
[null,"2012-01-22","Walker","AUS","GA","B",12]
[null,"2012-02-11","Robinson","CHN","AL","H",90]
[null,"2012-10-15","Walker","BEL","DE","L",85]
[null,"2012-07-01","Rodriguez","AUT","CO","F",71]
[null,{"$f":"DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2012-06-14"},"Hall","AUS","DE","B",58,null,"Duplicate Reference Report Filter using Macro"]
[null,"2012-08-23","Young","BEL","DE","G",48]
[null,"2012-12-12","Walker","CAN","AK","G",51,null,null,null,null,"PivotTable11",null,null,"PivotTable12",null,null,"PivotTable13",null,null,"PivotTable14"]
[null,"2012-03-24","Rodriguez","BRA","CO","K",32,null,null,null,null,"Bin","(Multiple Items)",null,"NName","(Multiple Items)",null,"DDate","(Multiple Items)",null,"NName","(Multiple Items)"]
[null,"2012-10-01","Hall","CHI","AR","K",60,null,null,null,null,null,null,null,"Bin","(Multiple Items)",null,"NName","(Multiple Items)",null,"Bin","(Multiple Items)"]
[null,"2012-07-11","Hall","AUS","AL","B",42,null,null,null,null,"Dest","_Value",null,"Src","(Multiple Items)"]
[null,"2012-11-18","Lewis","ARG","DE","J",89,null,null,null,null,"AK",509,null,null,null,null,"Dest","_Value",null,"Dest","Src","_Value"]
[null,"2012-12-07","Allen","BRA","AK","G",92,null,null,null,null,"AL",447,null,"Dest","_Value",null,"AK",338,null,"AK"]
[null,"2012-04-08","Robinson","AUT","FL","K",65,null,null,null,null,"AZ",764,null,"AK",49,null,"AL",255,null,null,"AUS",32]
[null,"2012-01-15","Robinson","BRA","GA","J",52,null,null,null,null,"CA",616,null,"AL",68,null,"AZ",83,null,null,"CAN",51]
[null,"2012-11-09","Lewis","BRA","FL","B",32,null,null,null,null,"CT",454,null,"CA",105,null,"CA",337,null,"AL"]
[null,"2012-09-26","Rodriguez","AUT","AR","D",88,null,null,null,null,"FL",300,null,"CT",159,null,"CT",135,null,null,"BEL",35]
[null,"2012-02-01","Rodriguez","CAN","DE","L",25,null,null,null,null,null,null,null,"FL",16,null,"FL",162,null,null,"CAN",61]
[null,"2012-04-18","Lewis","ARG","AR","J",37,null,null,null,null,null,null,null,null,null,null,null,null,null,"AZ"]
[null,"2012-06-25","Young","CAN","AK","K",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHN",83]
[null,"2012-07-27","Walker","AUS","CO","F",26,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA"]
[null,"2012-10-28","Lewis","CAN","DE","K",58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAN",35]
[null,"2012-08-13","Hall","CAN","GA","G",89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHN",147]
[null,"2012-01-09","Young","AUS","AK","L",69,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL"]
[null,"2012-02-25","Young","BEL","AK","D",75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAN",32]
[null,"2012-07-21","Young","BRA","GA","K",43]
[null,"2012-11-01","Hall","CAN","AZ","J",66]
[null,"2012-04-23","Robinson","CHI","CA","H",63]
[null,"2012-11-25","Allen","CAN","CO","B",81]
[null,"2012-12-19","Robinson","AUT","CT","F",39]
[null,"2012-02-05","Young","CAN","CO","B",27]
[null,"2012-06-07","Robinson","CAN","AL","D",61]
[null,"2012-10-10","Robinson","AUS","DE","J",67]
[null,"2012-04-21","Hall","ARG","CA","H",53]
[null,"2012-04-29","Rodriguez","ARG","CO","B",74]
[null,"2012-12-24","Walker","CHI","CT","J",16]
[null,"2012-02-29","Lee","BRA","CO","D",81]
[null,{"$f":"DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2012-08-29"},"Robinson","ARG","AR","L",16]
[null,"2012-02-24","Lewis","BEL","FL","L",90]
[null,"2012-05-24","Robinson","BRA","AL","F",87]
[null,"2012-05-01","Young","BRA","DE","L",74]
[null,"2012-12-31","Lee","CHN","AZ","D",83]
[null,"2012-06-30","Allen","AUT","CT","D",17]
[null,"2012-12-08","Hall","CHI","AZ","G",41]
[null,"2012-05-16","Lee","AUS","DE","J",96]
[null,"2012-11-04","Clark","CHI","CO","H",13]
[null,"2012-05-12","Hall","CAN","CT","D",68]
[null,"2012-07-01","Young","AUS","DE","H",89]
[null,"2012-07-21","Walker","BEL","AR","L",49]
[null,"2012-12-28","Clark","ARG","DE","L",34]
[null,"2012-10-11","Clark","CAN","FL","L",32]
[null,"2012-07-30","Young","CHI","AR","G",38]
[null,"2012-04-11","Allen","BEL","AK","G",20]
[null,"2012-11-08","Allen","CAN","AL","L",90]
[null,"2012-07-11","Clark","CHI","CO","K",94]
[null,"2012-08-13","Walker","AUS","DE","B",95]
[null,"2012-06-08","Lewis","AUS","FL","D",37]
[null,"2012-02-21","Lee","AUT","AL","J",21]
[null,"2012-12-30","Lewis","CHN","AL","H",78]
[null,"2012-01-11","Young","AUS","AK","F",88]
[null,"2012-07-23","Hall","CHN","CO","H",62]
[null,"2012-06-27","Young","BEL","AL","L",27]
[null,"2012-07-06","Hall","BRA","CO","F",42]
[null,"2012-09-13","Hall","BRA","AR","B",68]
[null,"2012-03-04","Young","CHI","AR","G",75]
[null,"2012-12-01","Clark","CHN","GA","H",62]
[null,"2012-04-10","Clark","CHN","CT","B",44]
[null,"2012-09-25","Robinson","CHI","GA","B",60]
[null,"2012-09-02","Walker","CAN","DE","B",71]
[null,{"$f":"DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2012-11-12"},"Hall","CHI","AR","L",56]
[null,"2012-01-23","Young","CAN","CO","L",93]
[null,"2012-01-11","Allen","CHN","AK","K",36]
[null,"2012-05-04","Allen","ARG","DE","K",35]
[null,"2012-06-11","Young","CAN","AR","K",67]
[null,"2012-02-02","Lee","CHN","GA","F",87]
[null,"2012-08-02","Lee","BEL","CT","B",95]
[null,"2012-09-09","Lewis","AUT","AL","F",65]
[null,"2012-04-03","Clark","BRA","AL","K",28]
[null,"2012-11-26","Lewis","CHN","AZ","G",39]
[null,"2012-05-17","Hall","ARG","AR","J",69]
[null,"2012-08-19","Lee","CAN","CA","G",35]
[null,"2012-12-30","Lee","BEL","CO","K",36]
[null,"2012-07-20","Hall","ARG","AK","G",36]
[null,"2012-07-02","Hall","CHN","AR","D",28]
[null,"2012-08-17","Clark","AUS","FL","F",39]
[null,"2012-03-11","Robinson","AUT","CO","F",74]
[null,"2012-04-12","Lee","ARG","CO","L",40]
[null,"2012-01-16","Young","AUT","DE","D",35]
[null,"2012-04-30","Clark","BRA","CO","L",16]
[null,"2012-08-21","Lee","AUS","AK","J",32]
[null,"2012-03-28","Rodriguez","BRA","CT","L",49]
[null,"2012-10-06","Allen","CHN","CA","G",90]
[null,"2012-07-18","Walker","CHI","DE","G",96]
[null,"2012-05-03","Robinson","CHI","CO","G",52]
[null,"2012-08-12","Walker","CHI","AR","B",17]
[null,"2012-08-12","Hall","AUT","CO","F",76]
[null,"2012-06-10","Young","BEL","FL","L",44]
[null,"2012-11-27","Rodriguez","CHN","CT","H",33]
[null,"2012-12-04","Lewis","BRA","AZ","L",71]
[null,"2012-10-20","Allen","BEL","FL","D",81]
[null,"2012-11-22","Robinson","ARG","CA","D",13]
[null,{"$f":"DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2012-12-22"},"Young","CHI","CA","H",30]
[null,"2012-07-22","Robinson","AUS","FL","B",22]
[null,"2012-09-22","Hall","CHI","CA","L",99]
[null,"2012-02-29","Clark","CHN","CA","L",88]
[null,"2012-04-20","Robinson","BEL","AK","F",98]
[null,"2012-10-19","Lewis","BRA","CT","H",76]
[null,"2012-05-02","Walker","AUT","AZ","F",51]
[null,"2012-07-25","Lewis","BEL","AK","H",72]
[null,"2012-01-22","Allen","CHI","DE","H",40]
[null,"2012-03-25","Lewis","BEL","AL","G",92]
[null,"2012-01-17","Lee","BRA","AK","H",26]
[null,"2012-02-23","Rodriguez","ARG","AK","H",76]
[null,"2012-09-01","Rodriguez","BEL","AZ","J",82]
[null,"2012-11-29","Robinson","CHI","AK","K",96]
[null,"2012-02-29","Allen","BRA","AZ","G",10]
[null,"2012-03-26","Lewis","ARG","DE","B",79]
[null,"2012-04-29","Walker","AUT","CO","D",59]
[null,"2012-06-27","Young","AUS","CA","L",67]
[null,"2012-02-05","Allen","ARG","AK","B",90]
[null,"2012-08-26","Clark","CHI","GA","D",23]
[null,"2012-06-17","Hall","CAN","AZ","K",27]
[null,"2012-05-26","Clark","CHN","AL","K",86]
[null,"2012-05-09","Robinson","CAN","AR","K",98]
[null,"2012-04-16","Lee","CHN","AL","F",46]
[null,"2012-01-11","Young","ARG","CT","K",77]
[null,"2012-01-31","Allen","CHN","CO","K",32]
[null,"2012-08-06","Lewis","CHN","AR","J",72]
[null,"2012-06-30","Young","BEL","CO","L",91]
[null,"2012-12-09","Lee","BEL","CA","B",33]
[null,"2012-04-08","Rodriguez","CHI","GA","L",84]
[null,"2012-01-07","Allen","BRA","AK","B",53]
[null,"2012-04-06","Walker","BRA","CT","L",57]
[null,{"$f":"DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2012-06-21"},"Allen","BRA","CT","G",83]
[null,"2012-07-14","Hall","BEL","GA","H",73]
[null,"2012-10-15","Hall","CHN","AZ","L",88]
[null,"2012-08-05","Allen","AUS","CO","F",31]
[null,"2012-10-27","Young","BRA","AL","D",74]
[null,"2012-02-02","Lewis","BRA","CT","K",74]
[null,"2012-07-15","Lee","CAN","AR","D",47]
[null,"2012-07-23","Lee","BRA","AK","G",49]
[null,"2012-12-11","Allen","AUT","AZ","J",89]
[null,"2012-01-19","Clark","ARG","AR","J",91]
[null,"2012-02-25","Young","BRA","CA","B",84]
[null,"2012-10-17","Robinson","AUS","CA","F",81]
[null,"2012-03-19","Lewis","CHI","AZ","D",22]
[null,"2012-12-09","Robinson","CHI","CT","K",96]
[null,"2012-04-30","Allen","ARG","AZ","L",77]
[null,"2012-06-22","Lee","BEL","FL","H",77]
[null,"2012-05-15","Rodriguez","ARG","CA","F",82]
[null,"2012-03-02","Robinson","CHN","AR","F",23]
[null,"2012-12-25","Lee","BEL","GA","B",81]
[null,"2012-05-07","Clark","CAN","CO","B",97]
[null,"2012-04-04","Lee","BEL","AL","G",35]
[null,"2012-05-15","Lewis","CHN","GA","F",25]
[null,"2012-04-09","Rodriguez","CAN","AZ","G",70]
[null,"2012-01-16","Walker","CHN","CO","H",37]
[null,"2012-06-13","Lewis","CHN","CA","G",48]
[null,"2012-10-10","Lewis","AUS","CT","J",32]
[null,"2012-12-13","Lee","ARG","CT","L",86]
[null,"2012-02-27","Rodriguez","CHI","DE","G",46]
[null,"2012-08-02","Walker","AUT","AK","F",75]
[null,"2012-04-01","Young","CHN","CA","L",25]

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