{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Aux","PlanB"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":2,"pivot_tables":5},"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":194,"n_cols":21,"rows_kept":194,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table1"]
[null,"Name","City","State","Country","Color","Date","Qty",null,"Step1",null,null,"PivotTable1",null,null,null,"PivotTable3",null,null,"PivotTable2"]
[null,"Moore","Kansas City","MO","JPN","Blue","2009-03-16",26,null,"Select State(s) in PivotTable1",null,null,"State","(Multiple Items)",null,null,"Years","2009",null,"Years","(All)"]
[null,"Wilson","San Bernardino","CA","NOR","Brn","2009-03-01",75,null,"Step2",null,null,"City","(Multiple Items)",null,null,"Date","(All)",null,"City","(Multiple Items)"]
[null,"Smith","St. Paul","MN","POL","Yel","2010-01-27",96,null,"Hit this button",null,null,null,null,null,null,"State","(Multiple Items)"]
[null,"Brown","Reno","NV","SWE","Yel","2009-03-31",93,null,null,null,null,"Years","Date","Sum of Qty",null,null,null,null,"State","Sum of Qty"]
[null,"Moore","Lubbock","TX","NED","Yel","2008-12-15",26,null,null,null,null,"2009",null,null,null,"City","Sum of Qty",null,"AZ",53]
[null,"Miller","San Jose","CA","NED","Blue","2008-11-07",15,null,null,"Step3",null,null,"Mar",63,null,"Anaheim",63,null,"CA",63]
[null,"Jones","Worcester","MA","JPN","Red","2009-10-01",49,null,"Table3","Select City",null,null,"Apr",53,null,"Chandler",53,null,"FL",54]
[null,"Jones","Toledo","OH","NOR","Red","2009-05-28",65,null,"State","City",null,null,"Jun",33,null,"Tallahassee",54,null,"Grand Total",170]
[null,"Williams","Shreveport","LA","JPN","Red","2009-12-19",40,null,"AZ","Chandler",null,null,"Dec",21,null,"Grand Total",170]
[null,"Williams","Buffalo","NY","SWE","Blue","2010-03-31",37,null,"CA","Anaheim",null,"Grand Total",null,170]
[null,"Wilson","New Orleans","LA","NED","Blue","2009-08-14",14,null,"FL","Tallahassee"]
[null,"Wilson","Fort Worth","TX","SWE","Blue","2010-03-19",70]
[null,"Brown","Lexington","NH","SWE","Grn","2008-12-21",11]
[null,"Wilson","Newark","NJ","SWE","Brn","2009-03-08",33]
[null,"Smith","Detroit","MI","NED","Red","2009-05-12",64]
[null,"Davis","Akron","OH","NOR","Red","2009-03-22",55]
[null,"Smith","Fort Wayne","TX","MEX","Grn","2009-03-19",82]
[null,"Johnson","Dallas","TX","SWE","Brn","2009-02-06",27]
[null,"Davis","Durham","NC","POL","Blue","2008-11-20",54]
[null,"Johnson","Rochester","NY","SWE","Red","2008-10-26",93]
[null,"Miller","St. Louis","MS","MEX","Blue","2009-09-03",30,null,null,"Step4"]
[null,"Brown","Baton Rouge","LA","POL","Blue","2010-03-25",54,null,null,"Hit this button"]
[null,"Smith","Denver","CO","NOR","Brn","2010-03-26",16]
[null,"Smith","Augusta","GA","SWE","Grn","2009-10-01",59]
[null,"Davis","Fontana","CA","POL","Red","2009-10-05",61]
[null,"Williams","Boston","MA","NOR","Yel","2008-12-10",15]
[null,"Davis","Omaha","NE","NED","Red","2009-02-10",87]
[null,"Jones","Laredo","TX","JPN","Grn","2009-01-31",56]
[null,"Brown","Irvine","CA","SWE","Red","2009-08-17",75]
[null,"Moore","Knoxville","TN","NOR","Red","2010-03-20",92]
[null,"Johnson","Montgomery","AL","SWE","Red","2009-08-02",82]
[null,"Wilson","San Francisco","CA","MEX","Red","2008-11-05",13]
[null,"Williams","Norfolk","VA","JPN","Yel","2009-02-27",23]
[null,"Brown","Louisville","KY","NED","Grn","2009-05-01",83]
[null,"Johnson","San Diego","CA","POL","Brn","2009-08-24",11]
[null,"Brown","Riverside","CA","NED","Yel","2009-09-28",56]
[null,"Miller","Virginia Beach","VA","NOR","Red","2009-05-04",63]
[null,"Davis","Chesapeake","VA","NOR","Grn","2009-06-26",99]
[null,"Johnson","Henderson","CO","POL","Blue","2008-11-20",43]
[null,"Smith","Salt Lake","UT","MEX","Red","2009-01-23",72]
[null,"Jones","Cincinnati","OH","POL","Red","2009-04-09",52]
[null,"Johnson","Nashville","TN","JPN","Yel","2010-02-06",52]
[null,"Miller","Irving","TX","NOR","Grn","2008-12-30",56]
[null,"Johnson","Amarillo","TX","MEX","Grn","2008-10-02",62]
[null,"Miller","Chicago","IL","MEX","Brn","2009-07-28",35]
[null,"Wilson","Miami","FL","POL","Yel","2009-11-29",53]
[null,"Moore","Boise","ID","NED","Grn","2008-10-22",64]
[null,"Moore","Philadelphia","PA","NOR","Grn","2009-03-04",34]
[null,"Brown","Tampa","FL","MEX","Yel","2009-11-03",93]
[null,"Miller","Phoenix","AZ","NOR","Red","2009-07-14",10]
[null,"Miller","Houston","TX","JPN","Red","2010-02-03",48]
[null,"Johnson","Jackson","FL","MEX","Brn","2010-01-30",49]
[null,"Williams","Columbus","OH","MEX","Yel","2009-05-21",63]
[null,"Wilson","Fort Worth","TX","NOR","Grn","2009-01-24",99]
[null,"Brown","Oxnard","CA","NED","Grn","2009-08-11",12]
[null,"Wilson","San Antonio","TX","NED","Blue","2009-10-10",86]
[null,"Moore","Jacksonville","FL","MEX","Red","2009-07-22",75]
[null,"Smith","Anaheim","CA","SWE","Yel","2009-03-27",63]
[null,"Brown","Brownsville","TX","NOR","Grn","2008-08-22",88]
[null,"Johnson","Stockton","CA","NED","Yel","2009-03-09",20]
[null,"Moore","Santa Clarita","CA","POL","Grn","2009-03-03",92]
[null,"Miller","North Lake","WY","JPN","Blue","2009-03-25",38]
[null,"Johnson","Moreno Valley","CA","SWE","Yel","2009-01-28",13]
[null,"Wilson","El Paso","TX","SWE","Brn","2010-04-05",57]
[null,"Miller","Colorado Springs","CO","POL","Red","2009-09-24",88]
[null,"Johnson","Chandler","AZ","POL","Red","2009-04-20",53]
[null,"Williams","Winston-Salem","MA","MEX","Yel","2009-08-10",75]
[null,"Brown","Albuquerque","NM","NED","Blue","2009-04-05",72]
[null,"Johnson","Tacoma","WA","POL","Blue","2009-12-22",55]
[null,"Williams","Jersey City","NJ","JPN","Grn","2010-01-04",66]
[null,"Moore","Des Moines","ID","JPN","Brn","2009-05-13",90]
[null,"Miller","Long Beach","CA","POL","Grn","2009-02-18",88]
[null,"Miller","Pittsburgh","PA","MEX","Brn","2009-08-12",12]
[null,"Moore","Baltimore","MD","MEX","Red","2009-09-05",15]
[null,"Wilson","Greensboro","SC","SWE","Brn","2009-06-02",79]
[null,"Smith","Memphis","TN","JPN","Red","2009-07-19",76]
[null,"Miller","Gilbert","WI","POL","Red","2009-01-25",77]
[null,"Wilson","Grand Rapids","ND","JPN","Brn","2009-08-02",51]
[null,"Davis","Newport News","VA","JPN","Red","2009-01-05",66]
[null,"Moore","Raleigh","NC","SWE","Blue","2009-03-12",97]
[null,"Jones","Madison","WI","MEX","Blue","2009-06-26",99]
[null,"Johnson","Honolulu","HI","JPN","Brn","2009-09-07",48]
[null,"Johnson","Hialeah","HI","NOR","Grn","2009-04-08",50]
[null,"Moore","Modesto","CA","NED","Red","2010-04-04",49]
[null,"Jones","Seattle","WA","SWE","Brn","2009-06-18",27]
[null,"Smith","Tempe","AZ","JPN","Brn","2010-04-01",87]
[null,"Moore","Chattanooga","TN","NOR","Grn","2008-11-29",73]
[null,"Johnson","Scottsdale","AZ","NOR","Red","2009-04-14",12]
[null,"Miller","Ontario","CA","NED","Brn","2009-06-17",10]
[null,"Wilson","Fayetteville","AR","POL","Grn","2010-03-14",65]
[null,"Moore","Atlanta","GA","NOR","Brn","2009-02-03",94]
[null,"Williams","Anchorage","AK","POL","Red","2009-01-24",73]
[null,"Jones","Aurora","KS","SWE","Red","2009-08-16",88]
[null,"Smith","Garland","TX","JPN","Brn","2009-06-20",70]
[null,"Miller","Milwaukee","MN","MEX","Red","2008-11-12",22]
[null,"Moore","Minneapolis","MN","MEX","Red","2008-09-13",39]
[null,"Smith","Vancouver","WA","MEX","Brn","2009-03-25",94]
[null,"Williams","Little Rock","AR","POL","Blue","2010-02-08",37]
[null,"Johnson","Mobile","AL","MEX","Red","2009-01-14",15]
[null,"Williams","Las Vegas","NV","POL","Yel","2010-01-17",15]
[null,"Wilson","Corpus Christi","TX","POL","Yel","2008-11-09",50]
[null,"Wilson","Fresno","CA","SWE","Yel","2009-12-11",89]
[null,"Moore","Birmingham","AL","SWE","Blue","2010-01-16",38]
[null,"Davis","Lincoln","NB","JPN","Yel","2009-01-31",12]
[null,"Wilson","Glendale","CA","NED","Red","2009-01-13",10]
[null,"Smith","Garden Grove","CA","NED","Red","2009-04-06",34]
[null,"Johnson","Plano","TX","SWE","Yel","2009-11-08",96]
[null,"Miller","Oceanside","CA","MEX","Red","2009-08-15",86]
[null,"Moore","Overland","SD","NED","Yel","2009-02-16",96]
[null,"Jones","Chula Vista","CA","NED","Red","2009-08-23",67]
[null,"Miller","Providence","RI","SWE","Blue","2008-08-31",20]
[null,"Miller","Rancho Cucamonga","CA","NED","Grn","2009-11-17",80]
[null,"Brown","Arlington","VT","NED","Brn","2009-05-18",10]
[null,"Williams","Wichita","KS","NOR","Yel","2009-06-01",19]
[null,"Davis","Charlotte","SC","NOR","Yel","2009-07-19",68]
[null,"Smith","Huntsville","AL","POL","Yel","2009-10-22",39]
[null,"Wilson","Tulsa","OK","POL","Blue","2008-09-19",29]
[null,"Miller","Austin","TX","SWE","Blue","2008-10-24",27]
[null,"Smith","Spokane","WA","JPN","Yel","2009-03-19",48]
[null,"Jones","Oakland","CA","MEX","Brn","2008-09-22",28]
[null,"Johnson","Richmond","VA","JPN","Yel","2009-09-14",27]
[null,"Davis","Sacramento","CA","SWE","Yel","2009-12-25",55]
[null,"Wilson","Los Angeles","CA","JPN","Grn","2010-03-31",52]
[null,"Jones","Portland","OR","NED","Grn","2008-09-21",20]
[null,"Jones","St. Petersburg","FL","POL","Red","2009-05-06",97]
[null,"Brown","Santa Ana","CA","SWE","Red","2008-11-07",72]
[null,"Wilson","Tucson","AZ","JPN","Yel","2009-12-10",62]
[null,"Williams","Cleveland","OH","NED","Yel","2008-10-24",16]
[null,"Moore","Oklahoma City","OK","NOR","Grn","2009-03-25",68]
[null,"Davis","Washington","WV","NOR","Grn","2008-09-01",19]
[null,"Williams","Yonkers","NY","JPN","Blue","2009-11-08",51]
[null,"Jones","Mesa","AZ","POL","Grn","2009-04-10",51]
[null,"Smith","Huntington Beach","CA","POL","Brn","2008-12-26",14]
[null,"Miller","Bakersfield","CA","SWE","Red","2009-12-29",69]
[null,"Williams","Orlando","FL","MEX","Yel","2008-08-28",10]
[null,"Brown","Tallahassee","FL","JPN","Grn","2009-06-22",33]
[null,"Johnson","Fremont","IA","MEX","Blue","2008-08-21",86]
[null,"Miller","Indianapolis","IN","POL","Brn","2008-09-08",65]
[null,"Williams","Tempe","AZ","NED","Blue","2009-08-23",29]
[null,"Wilson","Chattanooga","TN","NED","Grn","2009-09-07",10]
[null,"Wilson","Scottsdale","AZ","NED","Brn","2009-07-10",54]
[null,"Jones","Ontario","CA","NED","Brn","2010-01-16",35]
[null,"Williams","Fayetteville","AR","NED","Red","2008-11-25",51]
[null,"Moore","Atlanta","GA","NOR","Red","2009-12-29",62]
[null,"Wilson","Anchorage","AK","MEX","Yel","2009-01-05",98]
[null,"Moore","Aurora","KS","NED","Grn","2009-11-14",35]
[null,"Williams","Garland","TX","NED","Yel","2009-10-24",43]
[null,"Davis","Milwaukee","MN","NOR","Yel","2009-01-12",27]
[null,"Jones","Minneapolis","MN","JPN","Grn","2010-01-08",23]
[null,"Smith","Vancouver","WA","NOR","Blue","2008-11-18",26]
[null,"Wilson","Little Rock","AR","MEX","Grn","2009-08-06",93]
[null,"Smith","Mobile","AL","MEX","Blue","2009-12-10",86]
[null,"Miller","Las Vegas","NV","MEX","Blue","2009-08-12",62]
[null,"Johnson","Corpus Christi","TX","JPN","Blue","2009-07-18",70]
[null,"Davis","Fresno","CA","NED","Brn","2008-10-27",39]
[null,"Williams","Birmingham","AL","POL","Grn","2009-03-22",60]
[null,"Davis","Lincoln","NB","SWE","Red","2009-04-17",88]
[null,"Brown","Glendale","CA","JPN","Red","2009-02-13",26]
[null,"Williams","Garden Grove","CA","MEX","Grn","2010-03-19",51]
[null,"Miller","Plano","TX","JPN","Grn","2008-10-01",63]
[null,"Jones","Oceanside","CA","NOR","Red","2010-01-15",37]
[null,"Moore","Overland","SD","POL","Blue","2009-11-30",71]
[null,"Johnson","Chula Vista","CA","POL","Brn","2010-01-08",89]
[null,"Miller","Providence","RI","JPN","Grn","2009-12-13",81]
[null,"Jones","Rancho Cucamonga","CA","JPN","Grn","2009-05-05",97]
[null,"Smith","Arlington","VT","POL","Blue","2009-04-24",81]
[null,"Jones","Wichita","KS","JPN","Blue","2010-03-24",55]
[null,"Wilson","Charlotte","SC","NOR","Yel","2009-01-10",77]
[null,"Johnson","Huntsville","AL","NED","Red","2008-08-23",16]
[null,"Brown","Tulsa","OK","JPN","Red","2008-12-05",76]
[null,"Brown","Austin","TX","JPN","Blue","2009-04-15",18]
[null,"Moore","Spokane","WA","JPN","Brn","2008-12-04",73]
[null,"Moore","Oakland","CA","JPN","Red","2008-11-08",31]
[null,"Williams","Richmond","VA","MEX","Blue","2009-01-06",62]
[null,"Davis","Sacramento","CA","MEX","Yel","2009-02-14",19]
[null,"Johnson","Los Angeles","CA","NED","Grn","2010-03-15",40]
[null,"Davis","Portland","OR","SWE","Red","2010-04-05",65]
[null,"Moore","St. Petersburg","FL","MEX","Grn","2009-11-19",24]
[null,"Johnson","Santa Ana","CA","SWE","Brn","2010-01-08",92]
[null,"Williams","Tucson","AZ","NOR","Grn","2009-02-20",93]
[null,"Williams","Cleveland","OH","NOR","Blue","2009-07-19",23]
[null,"Smith","Oklahoma City","OK","NED","Grn","2009-09-06",22]
[null,"Wilson","Washington","WV","NED","Blue","2009-11-30",77]
[null,"Moore","Yonkers","NY","JPN","Grn","2009-12-17",77]
[null,"Wilson","Mesa","AZ","NED","Yel","2009-01-05",90]
[null,"Wilson","Huntington Beach","CA","MEX","Red","2010-01-12",31]
[null,"Johnson","Bakersfield","CA","MEX","Yel","2009-03-12",92]
[null,"Williams","Orlando","FL","POL","Brn","2009-04-23",39]
[null,"Wilson","Tallahassee","FL","MEX","Blue","2009-12-19",21]
[null,"Jones","Fremont","IA","NOR","Grn","2009-07-25",34]
[null,"Davis","Indianapolis","IN","SWE","Red","2009-12-09",74]

{"sheet":"Aux","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Table4"]
[null,"State"]
[null,"FL"]
[]
[null,"Table10","Table11","Table12","Table13","Table14","Table15"]
[null,"City","City","City","City","City","City"]
[null,"Phoenix","San Bernardino","Miami"]
[null,"Chandler","San Jose","Tampa"]
[null,"Tempe","Fontana","Jackson"]
[null,"Scottsdale","Irvine","Jacksonville"]
[null,"Tucson","San Francisco","St. Petersburg"]
[null,"Mesa","San Diego","Orlando"]
[null,null,"Riverside","Tallahassee"]
[null,null,"Oxnard"]
[null,null,"Anaheim"]
[null,null,"Stockton"]
[null,null,"Santa Clarita"]
[null,null,"Moreno Valley"]
[null,null,"Long Beach"]
[null,null,"Modesto"]
[null,null,"Ontario"]
[null,null,"Fresno"]
[null,null,"Glendale"]
[null,null,"Garden Grove"]
[null,null,"Oceanside"]
[null,null,"Chula Vista"]
[null,null,"Rancho Cucamonga"]
[null,null,"Oakland"]
[null,null,"Sacramento"]
[null,null,"Los Angeles"]
[null,null,"Santa Ana"]
[null,null,"Huntington Beach"]
[null,null,"Bakersfield"]

{"sheet":"PlanB","index":2,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table6",null,null,null,null,null,null,null,"PivotTable1",null,null,null,"PivotTable3"]
[null,"State","City",null,null,null,null,null,null,"State","(All)",null,null,"Years","2009"]
[null,"AZ","Chandler",null,null,null,null,null,null,"City","(Multiple Items)",null,null,"Date","(All)"]
[null,"CA","Anaheim",null,null,null,null,null,null,null,null,null,null,"State","(All)"]
[null,"FL","Tallahassee",null,null,null,null,null,null,"Years","Date","Sum of Qty"]
[null,"AZ","Phoenix",null,null,null,null,null,null,"2009",null,null,null,"City","Sum of Qty"]
[null,null,null,null,null,null,null,null,null,null,"Mar",63,null,"Anaheim",63]
[null,"Table5",null,null,null,null,null,null,null,null,"Apr",53,null,"Chandler",53]
[null,"Name","City","State","Country","Color","Date","Qty",null,null,"Jun",33,null,"Tallahassee",54]
[null,"Miller","Phoenix","AZ","NOR","Red","2009-07-14",10,null,null,"Dec",21,null,"Grand Total",170]
[null,"Smith","Anaheim","CA","SWE","Yel","2009-03-27",63,null,"Grand Total",null,170]
[null,"Johnson","Chandler","AZ","POL","Red","2009-04-20",53]
[null,"Brown","Tallahassee","FL","JPN","Grn","2009-06-22",33]
[null,"Wilson","Tallahassee","FL","MEX","Blue","2009-12-19",21]