{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sentiment Analysis - United","Sentiment Analysis - Southwest"],"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":"Sentiment Analysis - United","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Tweet","Location","Score"]
["This is the best hotel ever.",null,{"$f":"GetSentimentValue(A2)","v":3},null,"Averge",{"$f":"AVERAGE(C:C)","v":0.55874999999999997},null,"Column C uses the GetSentimentValue function.   The purpose of this Function is to produce a score that roughly represents the sentiment of a given text string.  You can us it to quantify subjective survey comments or social media feedback.  Try changing the comment in Cell A2 to something negative."]
["The staff was extremely friendly and helpful but I would like to recommend that management get creative and add a kids program and some excitement around the pool like music or interactive games. With summer rainy season challenges this property really needs to offer parents more family friendly FUN right on the campus! ",null,{"$f":"GetSentimentValue(A3)","v":2},null,"Postive\nTweets",null,null,"This Function returns a score between -5 and 5.  The lowest score indicates that there were words associated with unhappiness or dissatisfaction.  A score of zero either means that no charged words were found, or that the positive and negative words balanced themselves out.  A high score shows that there were one or more 'positive' words that occur in pleased, happy comments.  For example, \"Great trip. Thanks for the warm welcome\" gets a score of +2 because \"great\" has a weight of +3, and \"warm\" gives +1, so the average is +2."]
["This may be the worse hotel service I have received in the last 5 years.  Have waited over an hour for room service menu.  Manager said they are busy nothing they can do will have someone send when can.  Don't plan on staying here if you need to do business in your room and want to eat.  DIsappointing for full service hotel.",null,-1.33,null,"Negative\nTweets",null,null," -5=Extremely Negative     -4=Very Negative     -3=Negative     -2=Somewhat Negative     -1=Mildly Negative\n  0=Neutral\n  5=Extremely Positive        4=Very Positive        3=Positive        2=Somewhat Positive        1=Mildly Positive"]
["I have to say I just had the worst experience with one of their hotels ever.  I will definitely be finding another group of hotels to stay with for all of our future stays. Worst hotel experience and customer service ever.",null,{"$f":"GetSentimentValue(A5)","v":-3},null,"Negative\n/Positive"]
["I called to move my prepaid reservation because I just had a heart attack and can't travel and am told that is not your issue? Wonderful.  Such lovely customer service. It's best if I take my business elsewhere.",null,{"$f":"GetSentimentValue(A6)","v":2.25},null,null,null,null,"Developed by Mike Alexander:  www.datapigtechnologies.com"]
["I just want to say, that I stayed at your hotel last night for a wedding.  I was not happy what so ever. I did not have any power in my room from 8:30- until I got so disgusted I checked out and drove home.  I am very dissapointed at my horrific stay.",null,-1.2,null,null,null,null,"Based on ideas presented at www.datasciencetoolkit.org"]
["I'm on Grand Rapids, MI this week, and I'm so so happy with my room, the front desk service, and the in-house restaurant. I thought nothing could beat the food in Dallas, but the walleye, combined with the wonderful service of Devon, the bartender (thank you for the suggestion of Michigan gin!) has calmed the insanity that came from driving over from East Lansing. Thank you, again!",null,2]
["After being a XX customer for over ten years and 150 nights per year I am switching to your hotel because XX customer service is horrible. They don't even care to respond when a case has been opened with corporate. I am confident your hotel would like my business!",null,0.75]

{"sheet":"Sentiment Analysis - Southwest","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Tweet","Location","Score"]
["This is the best hotel ever.",null,{"$f":"GetSentimentValue(A2)","v":3},null,"Averge",{"$f":"AVERAGE(C:C)","v":0.55874999999999997},null,"Column C uses the GetSentimentValue function.   The purpose of this Function is to produce a score that roughly represents the sentiment of a given text string.  You can us it to quantify subjective survey comments or social media feedback.  Try changing the comment in Cell A2 to something negative."]
["The staff was extremely friendly and helpful but I would like to recommend that management get creative and add a kids program and some excitement around the pool like music or interactive games. With summer rainy season challenges this property really needs to offer parents more family friendly FUN right on the campus! ",null,{"$f":"GetSentimentValue(A3)","v":2},null,"Postive\nTweets",null,null,"This Function returns a score between -5 and 5.  The lowest score indicates that there were words associated with unhappiness or dissatisfaction.  A score of zero either means that no charged words were found, or that the positive and negative words balanced themselves out.  A high score shows that there were one or more 'positive' words that occur in pleased, happy comments.  For example, \"Great trip. Thanks for the warm welcome\" gets a score of +2 because \"great\" has a weight of +3, and \"warm\" gives +1, so the average is +2."]
["This may be the worse hotel service I have received in the last 5 years.  Have waited over an hour for room service menu.  Manager said they are busy nothing they can do will have someone send when can.  Don't plan on staying here if you need to do business in your room and want to eat.  DIsappointing for full service hotel.",null,-1.33,null,"Negative\nTweets",null,null," -5=Extremely Negative     -4=Very Negative     -3=Negative     -2=Somewhat Negative     -1=Mildly Negative\n  0=Neutral\n  5=Extremely Positive        4=Very Positive        3=Positive        2=Somewhat Positive        1=Mildly Positive"]
["I have to say I just had the worst experience with one of their hotels ever.  I will definitely be finding another group of hotels to stay with for all of our future stays. Worst hotel experience and customer service ever.",null,{"$f":"GetSentimentValue(A5)","v":-3},null,"Negative\n/Positive"]
["I called to move my prepaid reservation because I just had a heart attack and can't travel and am told that is not your issue? Wonderful.  Such lovely customer service. It's best if I take my business elsewhere.",null,{"$f":"GetSentimentValue(A6)","v":2.25},null,null,null,null,"Developed by Mike Alexander:  www.datapigtechnologies.com"]
["I just want to say, that I stayed at your hotel last night for a wedding.  I was not happy what so ever. I did not have any power in my room from 8:30- until I got so disgusted I checked out and drove home.  I am very dissapointed at my horrific stay.",null,-1.2,null,null,null,null,"Based on ideas presented at www.datasciencetoolkit.org"]
["I'm on Grand Rapids, MI this week, and I'm so so happy with my room, the front desk service, and the in-house restaurant. I thought nothing could beat the food in Dallas, but the walleye, combined with the wonderful service of Devon, the bartender (thank you for the suggestion of Michigan gin!) has calmed the insanity that came from driving over from East Lansing. Thank you, again!",null,2]
["After being a XX customer for over ten years and 150 nights per year I am switching to your hotel because XX customer service is horrible. They don't even care to respond when a case has been opened with corporate. I am confident your hotel would like my business!",null,0.75]