{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Grammy Bump Chart","Artist Pics"],"not_rendered":{"charts":1,"images":20,"macros":1,"external_links":0,"defined_names":4,"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":"Grammy Bump Chart","index":0,"n_rows":80,"n_cols":45,"rows_kept":80,"cut":false,"hidden":false,"merged":[[20,14,20,22],[27,8,27,17],[26,8,26,22],[25,8,25,18],[24,8,24,19],[23,8,23,19],[22,8,22,19]]}
[null,"Year","Artist","Song","Before","After"]
[null,1992,"Natalie Cole","Unforgettable with Love",98000,135000]
[null,1993,"Eric Clapton","Unplugged",155000,427000]
[null,1994,"Whitney Houston","The Bodyguard",136000,152000]
[null,1995,"Tony Bennett","MTV Unplugged",9000,38000]
[null,1996,"Alanis Morissette","Jagged Little Pill",310000,492000]
[null,1997,"Celine Dion","Falling into you",185000,239000]
[null,1998,"Bob Dylan","Time out of mind",22000,75000]
[null,1999,"Lauryn Hill","The Miseducation of Lauryn Hill",249000,436000]
[null,2000,"Santana","Supernatural",436000,1024000]
[null,2001,"Steely Dan","Two against nature",6000,57000]
[null,2002,"Soundtrack (multiple artists)","O Brother, Where Art Thou?",135000,457000]
[null,2003,"Norah Jones","Come Away With Me",284000,958000]
[null,2004,"Outkast","Speakerboxxx/ The Love Below",196000,397000]
[null,2005,"Ray Charles","Genius Loves Company",117000,235000]
[null,2006,"U2","How to Dismantle an Atomic Bomb",8000,50000]
[null,2007,"Dixie Chicks","Taking the Long Way",19000,153000]
[null,2008,"Herbie Hancock","River: The Joni Letters",10000,80000,null,null,{"$f":"1992","v":1992},null,{"$f":"I18+1","v":1993},null,{"$f":"K18+1","v":1994},null,{"$f":"M18+1","v":1995},null,{"$f":"O18+1","v":1996},null,{"$f":"Q18+1","v":1997},null,{"$f":"S18+1","v":1998},null,{"$f":"U18+1","v":1999},null,{"$f":"W18+1","v":2000},null,{"$f":"Y18+1","v":2001},null,{"$f":"AA18+1","v":2002},null,{"$f":"AC18+1","v":2003},null,{"$f":"AE18+1","v":2004},null,{"$f":"AG18+1","v":2005},null,{"$f":"AI18+1","v":2006},null,{"$f":"AK18+1","v":2007},null,{"$f":"AM18+1","v":2008},null,{"$f":"AO18+1","v":2009},null,{"$f":"AQ18+1","v":2010}]
[null,2009,"Alison Krauss & Robert Plant","Raising Sand",11000,109000]
[null,2010,"Taylor Swift","Fearless",66000,103000]
[null,null,null,null,null,null,null,null,"Source & Inspiration:",null,null,null,null,null,"Washington Post - Grammy Bump"]
[null,null,null,null,null,null,null,null,"Techniques used:"]
[null,"Data for chart",null,"Selected Year",2010,{"$f":"MATCH(valSelectedYear,$B$2:$B$20,0)","v":19},null,null,"Picture links"]
[null,"x","y","Artist",{"$f":"TRANSPOSE(INDEX($C$2:$F$20,$F$23,ROWS($D$24:D24)))","v":"Taylor Swift"},null,null,null,"Dynamic Chart Legends"]
[1,0,{"$f":"INDEX($E$2:$F$20,INT(B25/2)+1,MOD(B25,2)+1)","v":98000},"Song",{"$f":"TRANSPOSE(INDEX($C$2:$F$20,$F$23,ROWS($D$24:D25)))","v":"Fearless"},null,null,null,"INDEX Formula"]
[2,1,{"$f":"INDEX($E$2:$F$20,INT(B26/2)+1,MOD(B26,2)+1)","v":135000},"Before",{"$f":"TRANSPOSE(INDEX($C$2:$F$20,$F$23,ROWS($D$24:D26)))","v":66000},{"$f":"TEXT(E26,\"#,##0\")","v":"66,000"},null,null,"Conditional Formatting"]
[3,null,null,"After",{"$f":"TRANSPOSE(INDEX($C$2:$F$20,$F$23,ROWS($D$24:D27)))","v":103000},{"$f":"TEXT(E27,\"#,##0\")","v":"103,000"},null,null,"Picture Links made dynamic - product catalog in Excel"]
[4,2,{"$f":"INDEX($E$2:$F$20,INT(B28/2)+1,MOD(B28,2)+1)","v":155000},"Change",{"$f":"E27/E26-1","v":0.56060606060606055},{"$f":"TEXT(E28,\"+0%\")","v":"+56%"},null,null,"Worksheet_SelectionChange Event"]
[5,3,{"$f":"INDEX($E$2:$F$20,INT(B29/2)+1,MOD(B29,2)+1)","v":427000}]
[6]
[7,4,{"$f":"INDEX($E$2:$F$20,INT(B31/2)+1,MOD(B31,2)+1)","v":136000}]
[8,5,{"$f":"INDEX($E$2:$F$20,INT(B32/2)+1,MOD(B32,2)+1)","v":152000}]
[9]
[10,6,{"$f":"INDEX($E$2:$F$20,INT(B34/2)+1,MOD(B34,2)+1)","v":9000}]
[11,7,{"$f":"INDEX($E$2:$F$20,INT(B35/2)+1,MOD(B35,2)+1)","v":38000}]
[12]
[13,8,{"$f":"INDEX($E$2:$F$20,INT(B37/2)+1,MOD(B37,2)+1)","v":310000}]
[14,9,{"$f":"INDEX($E$2:$F$20,INT(B38/2)+1,MOD(B38,2)+1)","v":492000}]
[15]
[16,10,{"$f":"INDEX($E$2:$F$20,INT(B40/2)+1,MOD(B40,2)+1)","v":185000}]
[17,11,{"$f":"INDEX($E$2:$F$20,INT(B41/2)+1,MOD(B41,2)+1)","v":239000}]
[18]
[19,12,{"$f":"INDEX($E$2:$F$20,INT(B43/2)+1,MOD(B43,2)+1)","v":22000}]
[20,13,{"$f":"INDEX($E$2:$F$20,INT(B44/2)+1,MOD(B44,2)+1)","v":75000}]
[21]
[22,14,{"$f":"INDEX($E$2:$F$20,INT(B46/2)+1,MOD(B46,2)+1)","v":249000}]
[23,15,{"$f":"INDEX($E$2:$F$20,INT(B47/2)+1,MOD(B47,2)+1)","v":436000}]
[24]
[25,16,{"$f":"INDEX($E$2:$F$20,INT(B49/2)+1,MOD(B49,2)+1)","v":436000}]
[26,17,{"$f":"INDEX($E$2:$F$20,INT(B50/2)+1,MOD(B50,2)+1)","v":1024000}]
[27]
[28,18,{"$f":"INDEX($E$2:$F$20,INT(B52/2)+1,MOD(B52,2)+1)","v":6000}]
[29,19,{"$f":"INDEX($E$2:$F$20,INT(B53/2)+1,MOD(B53,2)+1)","v":57000}]
[30]
[31,20,{"$f":"INDEX($E$2:$F$20,INT(B55/2)+1,MOD(B55,2)+1)","v":135000}]
[32,21,{"$f":"INDEX($E$2:$F$20,INT(B56/2)+1,MOD(B56,2)+1)","v":457000}]
[33]
[34,22,{"$f":"INDEX($E$2:$F$20,INT(B58/2)+1,MOD(B58,2)+1)","v":284000}]
[35,23,{"$f":"INDEX($E$2:$F$20,INT(B59/2)+1,MOD(B59,2)+1)","v":958000}]
[36]
[37,24,{"$f":"INDEX($E$2:$F$20,INT(B61/2)+1,MOD(B61,2)+1)","v":196000}]
[38,25,{"$f":"INDEX($E$2:$F$20,INT(B62/2)+1,MOD(B62,2)+1)","v":397000}]
[39]
[40,26,{"$f":"INDEX($E$2:$F$20,INT(B64/2)+1,MOD(B64,2)+1)","v":117000}]
[41,27,{"$f":"INDEX($E$2:$F$20,INT(B65/2)+1,MOD(B65,2)+1)","v":235000}]
[42]
[43,28,{"$f":"INDEX($E$2:$F$20,INT(B67/2)+1,MOD(B67,2)+1)","v":8000}]
[44,29,{"$f":"INDEX($E$2:$F$20,INT(B68/2)+1,MOD(B68,2)+1)","v":50000}]
[45]
[46,30,{"$f":"INDEX($E$2:$F$20,INT(B70/2)+1,MOD(B70,2)+1)","v":19000}]
[47,31,{"$f":"INDEX($E$2:$F$20,INT(B71/2)+1,MOD(B71,2)+1)","v":153000}]
[48]
[49,32,{"$f":"INDEX($E$2:$F$20,INT(B73/2)+1,MOD(B73,2)+1)","v":10000}]
[50,33,{"$f":"INDEX($E$2:$F$20,INT(B74/2)+1,MOD(B74,2)+1)","v":80000}]
[51]
[52,34,{"$f":"INDEX($E$2:$F$20,INT(B76/2)+1,MOD(B76,2)+1)","v":11000}]
[53,35,{"$f":"INDEX($E$2:$F$20,INT(B77/2)+1,MOD(B77,2)+1)","v":109000}]
[54]
[55,36,{"$f":"INDEX($E$2:$F$20,INT(B79/2)+1,MOD(B79,2)+1)","v":66000}]
[56,37,{"$f":"INDEX($E$2:$F$20,INT(B80/2)+1,MOD(B80,2)+1)","v":103000}]

{"sheet":"Artist Pics","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Artist Name","Image"]
[null,{"$f":"'Grammy Bump Chart'!C2","v":"Natalie Cole"}]
[null,{"$f":"'Grammy Bump Chart'!C3","v":"Eric Clapton"}]
[null,{"$f":"'Grammy Bump Chart'!C4","v":"Whitney Houston"}]
[null,{"$f":"'Grammy Bump Chart'!C5","v":"Tony Bennett"}]
[null,{"$f":"'Grammy Bump Chart'!C6","v":"Alanis Morissette"}]
[null,{"$f":"'Grammy Bump Chart'!C7","v":"Celine Dion"}]
[null,{"$f":"'Grammy Bump Chart'!C8","v":"Bob Dylan"}]
[null,{"$f":"'Grammy Bump Chart'!C9","v":"Lauryn Hill"}]
[null,{"$f":"'Grammy Bump Chart'!C10","v":"Santana"}]
[null,{"$f":"'Grammy Bump Chart'!C11","v":"Steely Dan"}]
[null,{"$f":"'Grammy Bump Chart'!C12","v":"Soundtrack (multiple artists)"}]
[null,{"$f":"'Grammy Bump Chart'!C13","v":"Norah Jones"}]
[null,{"$f":"'Grammy Bump Chart'!C14","v":"Outkast"}]
[null,{"$f":"'Grammy Bump Chart'!C15","v":"Ray Charles"}]
[null,{"$f":"'Grammy Bump Chart'!C16","v":"U2"}]
[null,{"$f":"'Grammy Bump Chart'!C17","v":"Dixie Chicks"}]
[null,{"$f":"'Grammy Bump Chart'!C18","v":"Herbie Hancock"}]
[null,{"$f":"'Grammy Bump Chart'!C19","v":"Alison Krauss & Robert Plant"}]
[null,{"$f":"'Grammy Bump Chart'!C20","v":"Taylor Swift"}]