{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Summary","Data - Historical","Data - Cumulative"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":26,"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":"Summary","index":0,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[28,0,31,2],[28,4,31,6],[1,4,2,4],[1,6,2,6],[1,10,2,10],[2,0,3,0],[2,2,3,2],[4,4,5,4],[4,6,5,6],[4,10,5,10],[6,0,7,0],[6,2,7,2],[7,4,8,4],[7,6,8,6],[7,10,8,10],[40,7,41,10],[34,7,35,7],[34,8,35,10],[36,7,37,7],[36,8,37,10],[38,7,39,7],[38,8,39,10]]}
["Client:",null,"Walmart",null,null,null,"Mentions"]
["Yelp Reviews URL:","http://www.yelp.com/biz/walmart-springville-3",null,null,"Positive",null,{"$f":"INDEX(sentimentPosValues, 1, COUNTA(sentimentPosValues))","v":138},null,null,null,874]
[0.31,null,"2:1"]
[]
["strength",null,"sentiment",null,"Neutral",null,{"$f":"INDEX(sentimentNeuValues, 1, COUNTA(sentimentNeuValues))","v":691},null,null,null,420]
[]
[0.25,null,0.42]
[null,null,null,null,"Negative",null,{"$f":"INDEX(sentimentNegValues, 1, COUNTA(sentimentNegValues))","v":45},null,null,null,218]
["passion",null,"reach"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sample Reviews"]
["Yelp Review",null,{"$f":"INDEX(reviewsRatings, COUNTA(reviewsRatings)-1,1)&\"/5\"","v":"3/5"},null,"Yelp Review",null,{"$f":"INDEX(reviewsRatings, COUNTA(reviewsRatings),1)&\"/5\"","v":"4/5"}]
[{"$f":"\"'\"&INDEX(reviewsReviews, COUNTA(reviewsReviews)-1,1)&\"' - \"&INDEX(reviewsReviewer, COUNTA(reviewsReviewer)-1,1)","v":"'Much less crowded than the Orem location, though seemingly a little smaller.' - Morgan V"},null,null,null,{"$f":"\"'\"&INDEX(reviewsReviews, COUNTA(reviewsReviews),1)&\"' - \"&INDEX(reviewsReviewer, COUNTA(reviewsReviewer),1)","v":"'Awesome Walmart!' - John Gugenhi"}]
[]
[]
[]
[]
["Top Keywords of All Time",null,null,null,"Top Hashtags"]
[{"$f":"INDEX(topKeywords, 2, 1)","v":"walmart"},null,{"$f":"INDEX(topKeywordsCount, 2, 1)","v":1956},null,{"$f":"INDEX(topHashtags, 2, 1)","v":"deal"},null,{"$f":"INDEX(topHashtagsCount, 2, 1)","v":207}]
[{"$f":"INDEX(topKeywords, 3, 1)","v":"mart"},null,{"$f":"INDEX(topKeywordsCount, 3, 1)","v":1834},null,{"$f":"INDEX(topHashtags, 3, 1)","v":"walmart"},null,{"$f":"INDEX(topHashtagsCount, 3, 1)","v":201}]
[{"$f":"INDEX(topKeywords, 4, 1)","v":"store"},null,{"$f":"INDEX(topKeywordsCount, 4, 1)","v":1193},null,{"$f":"INDEX(topHashtags, 4, 1)","v":"web"},null,{"$f":"INDEX(topHashtagsCount, 4, 1)","v":92}]
[{"$f":"INDEX(topKeywords, 5, 1)","v":"court"},null,{"$f":"INDEX(topKeywordsCount, 5, 1)","v":756},null,{"$f":"INDEX(topHashtags, 5, 1)","v":"car"},null,{"$f":"INDEX(topHashtagsCount, 5, 1)","v":48}]
[{"$f":"INDEX(topKeywords, 6, 1)","v":"people"},null,{"$f":"INDEX(topKeywordsCount, 6, 1)","v":754},null,{"$f":"INDEX(topHashtags, 6, 1)","v":"top"},null,{"$f":"INDEX(topHashtagsCount, 6, 1)","v":48}]
[{"$f":"INDEX(topKeywords, 7, 1)","v":"price"},null,{"$f":"INDEX(topKeywordsCount, 7, 1)","v":527},null,{"$f":"INDEX(topHashtags, 7, 1)","v":"newsjp"},null,{"$f":"INDEX(topHashtagsCount, 7, 1)","v":41}]
[{"$f":"INDEX(topKeywords, 8, 1)","v":"coupons"},null,{"$f":"INDEX(topKeywordsCount, 8, 1)","v":503},null,{"$f":"INDEX(topHashtags, 8, 1)","v":"usa"},null,{"$f":"INDEX(topHashtagsCount, 8, 1)","v":35}]
[{"$f":"INDEX(topKeywords, 9, 1)","v":"stores"},null,{"$f":"INDEX(topKeywordsCount, 9, 1)","v":499},null,{"$f":"INDEX(topHashtags, 9, 1)","v":"asus"},null,{"$f":"INDEX(topHashtagsCount, 9, 1)","v":26}]
[{"$f":"INDEX(topKeywords, 10, 1)","v":"defendant"},null,{"$f":"INDEX(topKeywordsCount, 10, 1)","v":304},null,{"$f":"INDEX(topHashtags, 10, 1)","v":"android"},null,{"$f":"INDEX(topHashtagsCount, 10, 1)","v":25}]
[{"$f":"INDEX(topKeywords, 11, 1)","v":"parking"},null,{"$f":"INDEX(topKeywordsCount, 11, 1)","v":276},null,{"$f":"INDEX(topHashtags, 11, 1)","v":"hot"},null,{"$f":"INDEX(topHashtagsCount, 11, 1)","v":16}]
[]
[null,null,"Compiled by Spark Genius LLC"]

{"sheet":"Data - Historical","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"2011-03-20","2011-03-22","2011-03-24","2011-03-26","2011-03-28","2011-04-04T14:57:21","2011-04-06T16:04:15","2011-04-11T10:23:32","2011-04-13T13:26:46","2011-04-13T13:28:37","2011-04-13T13:29:24","2011-04-13T13:55:20"]
["Sentiment"]
["Positive",89,56,30,65,70,120,152,144,114,114,114,138]
["Neutral",389,380,403,417,400,665,668,687,637,637,637,691]
["Negative",30,17,14,15,26,43,57,41,49,49,49,45]
[]
["Strength",0.49,0.5,0.47,0.55000000000000004,0.51,0.24,0.31,0.32,0.27,0.27,0.27,0.27]
[]
["Passion",0.35,0.4,0.3,0.31,0.32,0.21,0.25,0.25,0.3,0.3,0.3,0.26]
[]
["Reach",0.64,0.64,0.65,0.62,0.65,0.43,0.42,0.45,0.34,0.34,0.34,0.41]
[]
["Unique Authors",300,341,320,289,321,488,504,510,406,406,406,484]
[]
["Retweets",49,10,122,39,28,29,26,34,15,15,15,24]

{"sheet":"Data - Cumulative","index":2,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,7,0],[0,4,7,4],[0,8,7,8]]}
["Top Keywords","Keyword","Count",null,"Top Hashtags","Hashtag","Count",null,"Reviews","Rating","Reviewer","Review"]
[null,"walmart",1956,null,null,"deal",207,null,null,3,"Morgan V","Much less crowded than the Orem location, though seemingly a little smaller."]
[null,"mart",1834,null,null,"walmart",201,null,null,4,"John Gugenhi","Awesome Walmart!"]
[null,"store",1193,null,null,"web",92]
[null,"court",756,null,null,"car",48]
[null,"people",754,null,null,"top",48]
[null,"price",527,null,null,"newsjp",41]
[null,"coupons",503,null,null,"usa",35]
[null,"stores",499,null,null,"asus",26]
[null,"defendant",304,null,null,"android",25]
[null,"parking",276,null,null,"hot",16]
[null,"free",266,null,null,"izcalli",14]
[null,"coupon",205,null,null,"apple",14]
[null,"tractor",160,null,null,"uknowlifehardwhen",9]
[null,"news",143,null,null,"plus",8]
[null,"trailer",108,null,null,"wal-mart",8]
[null,"time",104,null,null,"familymovie",7]
[null,"police",92,null,null,"scientificallyproven",7]
[null,"online",76,null,null,"giveaway",6]
[null,"game",46,null,null,"mbjobs",6]
[null,"book",18,null,null,"jobs",6]
[null,"champ904",17,null,null,"npr",5]
[null,"deluxe",15,null,null,"v12",5]
[null,"edition",15,null,null,"nascar",4]
[null,"exclusively",15,null,null,"ipad2",3]
[null,"releasing",15,null,null,"nwo",3]
[null,"rumor",15,null,null,"china",3]
[null,"gaga",15,null,null,"boycott",3]
[null,"born",15,null,null,"dhs",3]
[null,"powell",8,null,null,"activist",3]
[null,"wlbt",6,null,null,"win",3]
[null,"dkenney",6,null,null,"arsenal",3]
[null,"love",6,null,null,"news",3]
[null,"brownsuga0880",6,null,null,"teamtarget",3]
[null,"reminds",6,null,null,"new",2]
[null,"live",6]
[null,"dertyboyscola",3]
[null,"south",3]
[null,"depressing",3]
[null,"batch",3]
[null,"stuff",3]
[null,"place",3]
[null,"commit",3]
[null,"suicide",3]
[null,"great",1]
[null,"bergsiefromkfr",1]
[null,"read",1]
[null,"tips",1]
[null,"shop",1]
[null,"asianparents",1]
[null,"abortions",1]
[null,"mizsp",1]
[null,"quit",1]