{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Main Data","Unconnected Tables","Power of Values","Change Calculate Behaviour"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Main Data","index":0,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["http://www.topendsports.com/world/lists/earnings/world-10-2009.htm"]
[]
["Year","Name","Country","Sport","earnings (USD mil)"]
[2013,"Floyd Mayweather Jr.","USA","Boxing",90000000]
[2013,"LeBron James","USA","Basketball",56500000]
[2013,"David Beckham","UK","Soccer",48300000]
[2013,"Drew Brees","USA","American Football",47800000]
[2013,"Kobe Bryant","USA","Basketball",46850000]
[2013,"Roger Federer","Switzerland","Tennis",43400000]
[2013,"Fernando Alonso","Spain","Auto Racing",42800000]
[2013,"Tiger Woods","USA","Golf",40800000]
[2013,"Phil Mickelson","USA","Golf",39500000]
[2013,"Cristiano Ronaldo","Portugal","Soccer",35300000]
[2012,"Floyd Mayweather Jr.","USA","Boxing",85000000]
[2012,"Phil Mickelson","USA","Golf",60700000]
[2012,"Tiger Woods","USA","Golf",56400000]
[2012,"Roger Federer","Switzerland","Tennis",51400000]
[2012,"Kobe Bryant","USA","Basketball",48200000]
[2012,"David Beckham","UK","Soccer",46000000]
[2012,"LeBron James","USA","Basketball",45900000]
[2012,"Lionel Messi","Argentina","Soccer",41250000]
[2012,"Cristiano Ronaldo","Portugal","Soccer",40250000]
[2012,"Fernando Alonso","Spain","Auto Racing",40000000]
[2011,"Tiger Woods","USA","Golf",62294116]
[2011,"Phil Mickelson","USA","Golf",61185933]
[2011,"Roger Federer","Switzerland","Tennis",52781940]
[2011,"Manny Pacquiao","Philippines","Boxing",52500000]
[2011,"Fernando Alonso","Spain","Auto Racing",45000000]
[2011,"LeBron James","USA","Basketball",44500000]
[2011,"Lionel Messi","Argentina","Soccer",43800000]
[2011,"Cristiano Ronaldo","Portugal","Soccer",38800000]
[2011,"Peyton Manning","USA","American Football",38070000]
[2011,"Alex Rodriguez","USA","Baseball",36000000]
[2010,"Tiger Woods","USA","Golf",90500000]
[2010,"Roger Federer","Switzerland","Tennis",61800000]
[2010,"Phil Mickelson","USA","Golf",61700000]
[2010,"Floyd Mayweather Jr.","USA","Boxing",60300000]
[2010,"LeBron James","USA","Basketball",45800000]
[2010,"Lionel Messi","Argentina","Soccer",44000000]
[2010,"David Beckham","Great Britain","Soccer",40500000]
[2010,"Cristiano Ronaldo","Portugal","Soccer",40000000]
[2010,"Manny Pacquiao","Philippines","Boxing",38000000]
[2010,"Alex Rodriguez","USA","Baseball",37000000]
[2010,"Ichiro Suzuki","Japan","Baseball",37000000]
[2009,"Tiger Woods","USA","Golf",99700000]
[2009,"Phil Mickelson","USA","Golf",53000000]
[2009,"David Beckham","Great Britain","Soccer",45200000]
[2009,"LeBron James","USA","Basketball",42400000]
[2009,"Kimi Räikkönen","Finland","Auto Racing",40100000]
[2009,"Manny Pacquiao","Philippines","Boxing",40000000]
[2009,"Lionel Messi","Argentina","Soccer",39900000]
[2009,"Alex Rodriguez","USA","Baseball",39000000]
[2009,"Valentino Rossi","Italy","Motor Sports",35000000]
[2009,"Fernando Alonso","Spain","Auto Racing",35000000]
[2009,"Shaquille O'Neal","USA","Basketball",35000000]

{"sheet":"Unconnected Tables","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["Names",null,"Benchmarks"]
["LeBron James",null,"Benchmark against same sport same country"]
["Cristiano Ronaldo",null,"Benchmark against same Country"]
["Roger Federer",null,"Benchmark against same Sport"]
["Floyd Mayweather Jr."]

{"sheet":"Power of Values","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Using unconnected table as an interactive benchmark"]
["=Sum of earnings (USD mil) /CALCULATE([Sum of earnings (USD mil)],Table1[Name]=VALUES(Names[Names]))"]
[null,"Sum of earnings (USD mil)","Benchmark Against Player"]
["Floyd Mayweather Jr.",90000000,2.5495750708215299]
["LeBron James",56500000,1.6005665722379603]
["David Beckham",48300000,1.368271954674221]
["Drew Brees",47800000,1.3541076487252124]
["Kobe Bryant",46850000,1.3271954674220963]
["Roger Federer",43400000,1.2294617563739376]
["Fernando Alonso",42800000,1.2124645892351276]
["Tiger Woods",40800000,1.1558073654390935]
["Phil Mickelson",39500000,1.1189801699716715]
["Cristiano Ronaldo",35300000,1]
["Grand Total",491250000,13.91643059490085]
[]
[]
[]
[]
[]
[null,null,null,"Player"]

{"sheet":"Change Calculate Behaviour","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["=calculate([Sum of earnings (USD mil)],Table1[Name]=values(Names[Names]))",null,"Instead of creating separate Benchmarks as in red below, you can set up a PARAMETER TABLE and use it alongwith VALUES function to select different benchmarks (as in blue below) using slicer"]
[]
[null,null,null,"Sum of earnings (USD mil)","Benchmark against same sport same country","Benchmark against same Country","Benchmark against same Sport","Select Benchmark"]
["Portugal","Soccer","Cristiano Ronaldo",35300000,35300000,35300000,83600000,83600000]
["Spain","Auto Racing","Fernando Alonso",42800000,42800000,42800000,42800000,42800000]
["Switzerland","Tennis","Roger Federer",43400000,43400000,43400000,43400000,43400000]
["UK","Soccer","David Beckham",48300000,48300000,48300000,83600000,83600000]
["USA","American Football","Drew Brees",47800000,47800000,321450000,47800000,47800000]
["USA","Basketball","Kobe Bryant",46850000,103350000,321450000,103350000,103350000]
["USA","Basketball","LeBron James",56500000,103350000,321450000,103350000,103350000]
["USA","Boxing","Floyd Mayweather Jr.",90000000,90000000,321450000,90000000,90000000]
["USA","Golf","Phil Mickelson",39500000,80300000,321450000,80300000,80300000]
["USA","Golf","Tiger Woods",40800000,80300000,321450000,80300000,80300000]
["Grand Total",null,null,491250000,491250000,491250000,491250000,491250000]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Column","Filter"]
[null,null,null,null,null,null,null,null,"Table1[Name]","Kobe Bryant"]
[null,null,null,null,null,null,null,null,"Table1[Name]","Roger Federer"]