Simply Sentiment 2 Support

Support Topics

System Requirements

Overview of Simply Sentiment

Simply Sentiment is an Excel add-in (.xlam file) that enables you to carry out sentiment analysis on any textual data within an Excel spreadsheet. It turns difficult to analyse, unstructured textual data into numeric data that you can easily incorporate into your day-to-day analysis.

Simply Sentiment supports over 60 langauges, so if your source text isn't in English, no problem! You don't even need to tell Simply Sentiment what language/s your source text is in - Simply Sentiment works it out automatically then translates everything back into English to make it easier for you to see exactly where the sentiment is in your source text.

Because Simply Sentiment is a standard Excel add-in which doesn't make any changes to your system, you can install simply Sentiment without Administrator Priviledges. If you are installing Simply Sentiment on a corporate computer, in most cases you will be able to do this yourself without any involvement from your IT department.

Simply Sentiment will identify positive and negative sentiment in any text that you have in Excel, and generate a set of numeric scores based on this analysis. For every item of text analysed, Simply Sentiment outputs the following information:

In addition, Simply Sentiment can produce a dashboard containing a graphical representation of the overall data processed;

Simply Sentiment can also generate a count of the sentiment words and phrases found in your text that you can use for further analysis or to generate a word cloud using any online cloud service e.g. www.wordle.net or www.wordart.com

You can also take the output from Simply Sentiment into your favourite analysis software.

The design philosophy behind Simply Sentiment is ease of use - everything is done within Excel, you simply select a worksheet range containing the text you want to analyse and click the Extract Sentiment button on the Excel Ribbon.

Simply Sentiment uses an advanced lexicon-based approach to sentiment analysis and has several advantages over other commercial products:

Simply Sentiment is designed to work 'out-of-the-box' with most data, but also has a number of features that allow you to customise the sentiment algorithms to better suite your individual data domains

Simply Sentiment can deal with a wide range of sentiment bearing words and phrases, including negations (e.g. not happy), double negatives (e.g. I don't dislike him), sentiment amplification (e.g. very happy), emoticons, and idioms (e.g. it does what it says on the tin)

These lexical rules are contained in a separate configuration file that is automatically downloaded when you first install Simply Sentiment. Updates to this file are made regularly and your Simply Sentiment add-in will regularly check for newer versions and automatically download them to ensure you always benefit from the latest version

Licence Types

The licence types available for Simply Sentiment are explained below:

Named User Licence - this licence allows a single named user to use Simply Sentiment on any computer. This licence is ideal for individuals or small teams who don't use shared computers. Discounts are available for multiple purchases of this licence

Site Licence - A site licence enables unlimited users on the network at a single site to access the products. Also, individual copies are not locked to an individual user so multiple users can access the products on the same computer. This licence is ideal if you have large teams or teams using shared computers working on the same project

Simply Sentiment is licenced on an annual basis

Discounts are available for educational and non-profit organisations

Installing Simply Sentiment

The Simply Sentiment add-in is installed just like any other Excel add-in:

  1. Extract the files from the SimplySentiment2.zip file to a location on your computer e.g your Desktop
  2. Start Excel and ensure a blank workbook is open
  3. If you already have a version of the Simply Sentiment add-in installed, please uninstall (delete) this before proceeding
  4. Click the File tab, click Options, and then click the Add-Ins category
  5. In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears
  6. Click Browse, locate the SimplySentiment2.xlam add-in file
  7. click Open and then click OK
  8. Excel will ask you if you want to copy the add-in to your add-ins folder. Click Yes

When installed you will see a new item under the CX Data Science tab on the Excel Ribbon called Simply Sentiment

Congratulations! Simply Sentiment is now installed and ready to use

First Use - Licence Activation

The first time you use Simply Sentiment after installation you will be asked to enter your product key:

  1. Ensure that your computer has an internet connection
  2. With any workbook open, click the Simply Sentiment tab, and then click the Extract Sentiment button on the ribbon
  3. Enter your email address / username and product activation key exactly as supplied in the email from us, and then click Activate
  4. The latest configuration file will be downloaded automatically in the background
  5. The configuration file data will be copied into the add-in, this takes a few seconds
  6. The main Simply Sentiment dialog box will appear. Click Cancel

Performing Sentiment Analysis with Simply Sentiment

  1. Select the worksheet cells that contain your textual data. In this example we're going to use Tweets.
  2. Select the Simply Sentiment tab on the Excel Ribbon, and then click the Extract Sentiment button
  3. After a few seconds the main Simply Sentiment dialog box will appear. This may take longer the very first time you use Simply Sentiment as a number of configurations and checks are make in the background
  4. Check that the range you selected is correct
  5. Optionally, you can also select a column containing data categories, to enable Simply Sentiment to produce a grouped summary of the final sentiment analysis. In this example we selected worksheet column A
  6. If any of your source texts are in languages other than English, check the Enable multi-lingual mode checkbox.
  7. Click the Start Processing button
  8. Wait while Simply Sentiment processes your textual data. Progress is displayed in the bottom left status area of the main Excel window
  9. When Simply Sentiment has finished processing your data the "Sentiment Analysis Complete" dialog box will appear
  10. A number of new columns of data will be inserted to the right of your original data
  11. For each item in your original data Simply Sentiment calculates the following:
    • (Optional) a copy of the original text, colour coded to indicate sentiment found
    • Positive Sentiment Score: this represents the strength of positive sentiment in the original data
    • Negative Sentiment Score: this represents the strength of negative sentiment in the original data
    • Overall Score: Positive score minus Negative Score
    • Polarity Label: A text label that indicates whether the Net Score is Positive, Negative or Neutral. Neutral sentiment occurs where there is both positive AND negative sentiment in the original text but the scores for each are very similar. If no sentiment was found in the original text a label of "No Sentiment" will appear here. If no valid data was found in the original text a label of "No Data" is added. You can adjust the neutral threshold to better suit your individual data sets in span class='boldit'>Settings.
    • Total No. Words: A count of the number of individual words (including web and email addresses) in each item of text

The Simply Sentiment Dashboard

The Dashboard contains useful summary information based on the text analysed:

The Dashboard shows the following information:

Note: The number of words and phrases shown in each of these tag clouds can be changed in Settings. This must be done before the Dashboard is generated. Changing these settings will not affect an existing dashboard

To generate the Dashboard automatically each time you extract sentiment with Simply Sentiment, make sure that the Automatically generate output workbook checkbox is checked in Settings

If you don't have this checkbox ticked you can still generate the dashboard immediately after sentiment has been extracted by clicking on the Generate Summary WB button on the ribbon. This will immediately produce the dashboard and wordcount list as a separate Excel workbook.

Sentiment Word Counts

Simply Sentiment can generate a list of all the sentiment bearing words and phrases in your text together with the frequency that they occur. This list can be used to produce further analysis e.g. word frequency histograms and charts etc. You can use this data in many online word cloud generators such as www.wordle.net or www.wordart.com. The list includes a ready formatted string that can be used in the advanced area of www.wordle.net to produce colour coded word clouds for all the sentiment words in your text, just the positive ones or just the negative ones

To use www.wordle.net to produce a word cloud with your data:

  1. Select and copy the appropriate data under the Wordle Advanced String heading
  2. In your web browser, navigate to www.wordle.net
  3. On the Wordle home page click the Advanced menu
  4. Paste your data into the Weighted words with hex colours box
  5. Click Go

Note: Wordle requires a browser that supports Java NPAPI plug-ins (Safari or Internet Explorer) and will not run on Google Chrome

To generate a sentiment word count automatically each time you extract sentiment with Simply Sentiment, make sure that the Automatically generate output workbook checkbox is checked in Settings

If you don't have this checkbox ticked you can still generate the list immediately after sentiment has been extracted by clicking on the Generate Summary WB button on the ribbon. This will immediately produce the dashboard and wordcount list as a separate Excel workbook

Customising The Sentiment Taxonomy

While Simply Sentiment can be used very effectively 'out-of-the-box' you can also add your own custom sentiment words/phrases and associated sentiment scores. This is useful if you are analysing text from a domain where the meaning of words differs from the norm, or if there are sentiment bearing words or phrases in your text that are not being identified correctly by Simply Sentiment

You can even use this feature to override the built-in sentiment scores for individual words & phrases if they are not appropriate to the domain you are analysing

To access this feature click on the View/Modify button in the Custom Rules group on the Simply Sentiment ribbon

To add a new rule, enter the rule and score in the Add a new custom rule section and click Add

Continue to add new rules

To save the new rules you have added click on the Save Changes button

The format for creating custom rules is as follows:

To delete a custom rule, select the rule from the list and click Delete. Click Save Changes when you are finished adding or deleting rules to commit all changes

If you click Cancel any changes will be lost

To delete all custom rules, select click Delete All. Click Save Changes when you are finished adding or deleting rules to commit all changes

You can create different sets of custom rules depending on the data you are analysing. You can easily save these as separate files that can be loaded when needed

To save the current set of custom rules:

  1. Click the Save Rules button in the Custom Rules group on the ribbon
  2. Enter a name for the file and click Save

To load a custom rules file:

  1. Click the Load Rules button in the Custom Rules group on the ribbon
  2. Select the file you want to load and click Open

Updating the Main Sentiment Database

Simply Sentiment will automatically check periodically for any updates to the main sentiment configuration file and download a newer file if one is available

You can manually check for updates at any time by clicking the Update Config File button on the Simply Sentiment ribbon

Settings

Click the Settings button on the Simply Sentiment ribbon to access various settings:

Word Cloud Stop List

You can prevent certain words from appearing on the Dashboard word cloud by entering them in the Word Cloud Stop List dialog box

To access this dialog box, click the Word Cloud Stop List button in the Output Options group on the ribbon

Enter stop words in the Add a new stop word or phrase section and click Add

Note: Word cloud stop words will be applied the next time you run Simply Sentiment. They will not be applied to any existing Dahsboard word clouds

Generate Summary Workbook

After you have run Simply Sentiment against a selection of text, you can click the Generate Summary WB button on the ribbon to generate a new workbook containing:

You can set the summary workbook to be generated automatically in Settings

Grouped Summary

Simply Sentiment can automatically generate a grouped summary of the sentiment from your data if you specify a column containing data to group by. An example of a grouped summary is shown below:

To produce this summary you must specify a grouping column in the main Simply Sentiment dialog

The grouped summary will appear in the separate summary workbook that can be produced automatically or manually after each run of Simply Sentiment

Updating your version of Simply Sentiment

If you already have a version of Simply Sentiment installed on your system, the safest way to update it is to remove the SimplySentiment.xlam file from your system and then install the new one.

Important, if you have created custom sentiment rules, please ensure that you save these before proceeding by clicking on the Save Rules button on the Simply Sentiment Excel Ribbon. Once you have updated Simply Sentiment you can load these rules back into Simply Sentiment by clicking the Load Rules button and selecting the appropriate custom rules file

Uninstall Simply Sentiment

  1. Start Excel
  2. Click the File tab, click Options, and then click the Add-Ins category
  3. Click on the Simply Sentiment entry in the list of Active Application Add-ins
  4. The full file path for the add-in is shown below the Add-ins list. Make a note of this
  5. From Windows Explorer, browse to the location of the add-in and delete the SimplySentiment.xlam file
  6. In Excel, click the File tab, click Options, and then click the Add-Ins category
  7. Click the Go... button next to Manage: Excel Add-ins
  8. Simply Sentiment will still appear in the list of Add-ins. Select Simply Sentiment and a warning message will appear. Click Yes
  9. Simply Sentiment is now removed from your system

Using Simply Sentiment and TOPic CATegoriser together

Using Simply Sentiment and TOPic CATegoriser together, you can extract topics (themes) from your textual data and rate the general sentiment of each topic. This is great for understanding specific pain points in customer journeys, or how your products and services compare with those of your competitors for example.

  1. First create a topic taxonomy for TOPic CATegoriser and run TOPic CATegoriser to categorise the topics in your data
  2. Next, go to the new CATEGORIES tab that TOPic CATegoriser has created and select the textual data in column C
  3. Click the Extract Sentiment button on the Simply Sentiment Ribbon menu and select Column B as the column to create a grouped summary;
  4. Click Start Processing and let Simply Sentiment process your data
  5. When finished, if the summary workbook is not automatically created (you can toggle this in Simply Sentiment Settings), click the Generate Summary WB button on the Simply Sentiment Ribbon menu
  6. Select the GroupedSummary tab. This will show you the sentiment in your textual data, summarised by topic;