{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Data","Sheet4","Runsby","Sheet10","custidAmt","customerReport","Country","instrxns","Output","Output1","Output2","Runsby (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Data",null,null,null,"UniqueName",null,null,null,"Data"]
["Akash"]
["Mohan"]
["Sonah"]
["Aman"]
["Akash"]
["Mohan"]
["Sonah"]
["Aman"]
["Akash"]
["Mohan"]
["Sonah"]
["Aman"]
["Akash"]
["Mohan"]
["Sonah"]
["Aman"]
["Rajesh",null,null,null,null,null,null,"Column 1","Column 2","Column 3","Column 4","Column 5","Column 6"]
[null,null,null,null,null,null,null,"xxt1","xxt2","xxt3","xxt4","xxt5","six1"]
[null,null,null,null,null,null,null,"xxt2","xxt3","xxt4","xxt5","xxt6","six2"]
[null,null,null,null,null,null,null,"xxt3","xxt4","xxt5","xxt6","xxt7","six3"]
[null,null,null,null,null,null,null,"xxt4","xxt5","xxt6","xxt7","xxt8","six4"]
[null,null,null,null,null,null,null,"xxt5","xxt6","xxt7","xxt8","xxt9","six5"]

{"sheet":"Sheet4","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Highest grossing films of 2012"]
["ID","Title","Release Date","Length","Genre"]
[1,"Avengers","2012-04-05",143,"Action"]
[2,"DK Rises","2012-04-06",144,"Action"]
[3,"Hunger","2012-04-07",145,"Adventure"]
[4,"Skyfall","2012-04-08",146,"Action"]
[5,"Hobbit","2012-04-09",147,"Fantasy"]
[6,"Twilight","2012-04-10",148,"Awful"]
[7,"Spider","2012-04-11",149,"Action"]
[8,"Brave","2012-04-12",150,"Animation"]
[9,"Ted","2012-04-13",151,"Comedy"]
[10,"Madagascar","2012-04-14",152,"Animation"]
[11,"Lorax","2012-04-15",153,"Animation"]
[12,"Wreck","2012-04-16",154,"Animation"]
[13,"Lincoln","2012-04-17",155,"Biography"]

{"sheet":"Runsby","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Player","Yr","Mat","Inns","NO","Runs","HS","HS1","HS2","Country"]
["India 2",1990,190,289,33,21550,"aa1","aa1","aa1","India"]
["Jones 3",1991,191,290,34,11551,"aa2","aa2","aa2","Aus"]
["Jones 4",1992,192,291,35,9552,"aa3","aa3","aa3","SA"]
["India 5",1993,193,292,36,8553,"aa4","aa4","aa4","India"]
["Jones 6",1994,194,293,37,7554,"aa5","aa5","aa5","Eng"]
["Jones 7",1995,195,294,38,1555,"aa6","aa6","aa6","SL"]
["Jones 8",1996,196,295,39,1556,"aa7","aa7","aa7","Aus"]
["India 9",1997,197,296,40,1557,"aa8","aa8","aa8","India"]
["Jones 10",1998,198,297,41,1558,"aa9","aa9","aa9","Eng"]
["Jones 11",1999,199,298,42,1559,"aa10","aa10","aa10","PAK"]
["Jones 12",2000,200,299,43,1560,"aa11","aa11","aa11","Aus"]
["Jones 13",2001,201,300,44,1561,"aa12","aa12","aa12","PAK"]
["Jones 14",2002,202,301,45,1562,"aa13","aa13","aa13","USA"]
["Jones 15",2003,203,302,46,1563,"aa14","aa14","aa14","Aus"]
["Jones 16",2004,204,303,47,1564,"aa15","aa15","aa15","Aus"]
["Jones 17",2005,205,304,48,1565,"aa16","aa16","aa16","Aus"]
["Jones 18",2006,206,305,49,1566,"aa17","aa17","aa17","Aus"]
["Jones 19",2007,207,306,50,1567,"aa18","aa18","aa18","Aus"]

{"sheet":"Sheet10","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Name","Salary"]
["Dave",25000]
["Aslam",35000]
["Krishna",45000]

{"sheet":"custidAmt","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Customer ID","Amount"]
["A1",25000]
["A2",30000]
["A3",32000]
["A2",35000]
["A1",30000]
["A4",40000]
["A3",40000]
["A4",20000]

{"sheet":"customerReport","index":5,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Customer ID","Amount"]
["A1",55000]
["A2",65000]
["A3",72000]
["A4",60000]

{"sheet":"Country","index":6,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Player","Country"]
["India 2","India"]
["India 9","India"]
["India 5","India"]
["Jones 4","SA"]
["Jones 7","SL"]
["Jones 8","Aus"]
["Jones 10","Eng"]
["Jones 15","Aus"]
["Jones 16","Aus"]
["Jones 17","Aus"]
["Jones 18","Aus"]
["Jones 19","Aus"]
["Jones 14","USA"]
["Jones 13","PAK"]
["Jones 11","PAK"]
["Jones 6","Eng"]
["Jones 3","Aus"]
["Jones 12","Aus"]

{"sheet":"instrxns","index":7,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["use custidAmt with customerReport tabs to:  sum the totals spent by each customer"]
["use modules:  gettotals, writedictionary"]
["Source: dinesh at https://www.youtube.com/watch?v=A22C4DGW6vc"]
[]
["If goals are to:  find unique values(eg, countries), total sums, print keys-items,"]
["use modules: initialsetup, findUniqueVals, findSumRuns(country & how many runs for each unique country), findsumcount(unique country,# of times),"]
["use tabs:  Runsby, Output"]
[]
["If goals are to:  Copy select columns & paste into another sheet"]
["use modules: copypasteintoColumns"]
["use tabs: Runsby, Output1"]
[]
["if goal is to do Vlookup equivalent using dictionary,"]
["use module: doLookups"]
["use tabs: Runsby(but delete the data in column J 1st), Country"]

{"sheet":"Output","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Country","TotalRuns","Player"]
["India",31660]
["Aus",22492]
["SA",9552]
["Eng",9112]
["SL",1555]
["PAK",3120]
["USA",1562]

{"sheet":"Output1","index":9,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Country","Player","Highest Test Rank","Runs"]
["India","India 2",null,21550]
["Aus","Jones 3",null,11551]
["SA","Jones 4",null,9552]
["India","India 5",null,8553]
["Eng","Jones 6",null,7554]
["SL","Jones 7",null,1555]
["Aus","Jones 8",null,1556]
["India","India 9",null,1557]
["Eng","Jones 10",null,1558]
["PAK","Jones 11",null,1559]
["Aus","Jones 12",null,1560]
["PAK","Jones 13",null,1561]
["USA","Jones 14",null,1562]
["Aus","Jones 15",null,1563]
["Aus","Jones 16",null,1564]
["Aus","Jones 17",null,1565]
["Aus","Jones 18",null,1566]
["Aus","Jones 19",null,1567]

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

{"sheet":"Runsby (2)","index":11,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Player","Yr","Mat","Inns","NO","Runs","HS","HS1","HS2","Country"]
["Jones 2",1990,190,289,33,21550,"aa1","aa1","aa1","India"]
["Jones 3",1991,191,290,34,11551,"aa2","aa2","aa2","Aus"]
["Jones 4",1992,192,291,35,9552,"aa3","aa3","aa3","SA"]
["Jones 5",1993,193,292,36,8553,"aa4","aa4","aa4","India"]
["Jones 6",1994,194,293,37,7554,"aa5","aa5","aa5","Eng"]
["Jones 7",1995,195,294,38,1555,"aa6","aa6","aa6","SL"]
["Jones 8",1996,196,295,39,1556,"aa7","aa7","aa7","Aus"]
["Jones 9",1997,197,296,40,1557,"aa8","aa8","aa8","India"]
["Jones 10",1998,198,297,41,1558,"aa9","aa9","aa9","Eng"]
["Jones 11",1999,199,298,42,1559,"aa10","aa10","aa10","PAK"]
["Jones 12",2000,200,299,43,1560,"aa11","aa11","aa11","Aus"]
["Jones 13",2001,201,300,44,1561,"aa12","aa12","aa12","PAK"]
["Jones 14",2002,202,301,45,1562,"aa13","aa13","aa13","USA"]
["Jones 15",2003,203,302,46,1563,"aa14","aa14","aa14","Aus"]
["Jones 16",2004,204,303,47,1564,"aa15","aa15","aa15","Aus"]
["Jones 17",2005,205,304,48,1565,"aa16","aa16","aa16","Aus"]
["Jones 18",2006,206,305,49,1566,"aa17","aa17","aa17","Aus"]
["Jones 19",2007,207,306,50,1567,"aa18","aa18","aa18","Aus"]