HP IDOL OnDemand Analytics Web App for Excel Online

Hewlett Packard has developed a set of JSON-based REST API’s which enable “Big Data”-type processing capabilities allowing developers to process information embedded in unstructured text and images in previously inaccessible formats.  This platform is called IDOL OnDemand and at this point is in the Early Access release phase, open for all Innovators to use.   

http://www.idolondemand.com

New HP IDOL OnDemand challenges launched weekly! Check http://idolondemand.topcoder.com for a complete list of HP IDOL OnDemand topcoder challenges.

Requirements

These are the requirements:  

1. develop a Web App for Excel Online using "Napa" Office 365 Development Tools that uses the HP IDOL OnDemand API to perform analysis on the text from the Excel document

   1. we will provide the Excel Add-in that has the functionality required here for the desktop version of Excel. The behavior of this Web App should be similar.

   2. a sample Excel document will be provided in the forums (hotel-reviews.xlsx)

2. the Web App will be tested only in development environment at this stage. It will be added eventually to the "INSERT / Apps for Office" menu from Excel Online web application (under the name "HP IDOL OnDemand")

   1. you need to obtain an Office 365 Developer Subscription, which is free for 30 days, in order to have access to an Office 365 Developer Site

   2. then, in the Developer Site, you can install "Napa" Office 365 Development Tools, to create your first apps right within the browser

3. the Web App will be a "Task pane app for Office" and this panel should have should have 2 menu items: "Sentiment \n Analysis" and "IDOL OnDemand \n API Key", in this order. The title should be "HP IDOL OnDemand"

4. the "IDOL OnDemand API Key" button opens a dialog to input the IDOL OnDemand API Key:

   1. the user will be able to input the "API Key"

      1. mask the key characters with * characters.

      2. provide a checkbox to show the keys (should be unchecked by default)

      3. the keys should be stored.

   2. add a "Get API Key" link below, which will open a Help dialog that presents the steps required to obtain the API Key. Provide the Help page content, with instructions: text, links, screenshots

      1. Create and activate an account on www.idolondemand.com

      2. Login to account to get API Key. This can be found under the “Account” menu item.

      3. Paste the key into the API Key text field.

5. the "Sentiment Analysis" menu item fills the panel at the right side with the required controls that allow the user to create analysis tasks and to view them in a list. For a task, the user will input:

6. 1. the Task name

   2. the range of cells to be analyzed

      1. by using the mouse; if a Get Range button is used, put it on the same line with the Range input field, to the right side

      2. or by setting the cell range manually (i.e.: "C2:C6")

   3. the language (default to English);

      1. limit the language selection options to languages supported by the IDOL OnDemand. The input should be a dropdown, with configurable languages (default to English)

      2. the first letter should be a capital one

   4. the Tasks can be executed (using a button from the pane, or by double-clicking them).

      1. execute selected task button executes only if one record is selected. Should show a proper error message if the selection is different, using an alert dialog

      2. if the IDOL OnDemand Key is not set, show an alert dialog that informs the user about this

   5. add a button to remove the tasks

7. The task execution will trigger the analysis of the text from the selected cells:

   1. perform a request to IDOL OnDemand Language Identification API using the External API to identify the language of the texts from the selected cells (from Range).

      1. analyze the text only if the returned language fits the selected language 

   2. perform IDOL OnDemand Sentiment Analysis API calls on the texts that match the selected language

   3. a new Worksheet is created as the last Worksheet:

      1. the name of worksheet is based on task name that was specified;

         1. if the worksheet name already exists, create a new one with the name of "<task name> (#)" (if task name is "abc", create worksheet "abc", then "abc (1)", then "abc (2)", ...).

      2. the worksheet will contain these columns (space the columns properly):

         1. the Text column with the selected text,

         2. the Aggregate Sentiment column with the aggregated sentiment from the responses: "positive", "negative", "neutral"

         3. the Aggregate Sentiment Score column with the score from the responses

      3. color Negative / Positive rows, using green background for positive and red background for negative. Use different shades for the background, with green for +1 or larger, going to lighter green for smaller score. Neutral rows should be white.

      4. display the aggregate sentiment in a table, with the count of positive / negative / neutral responses

      5. the worksheet will contain a Pie Chart showing the share of positive / negative / neutral responses; the charts should hook into the Chart tools to allow to change the themes, etc for different colors.

      6. display the breakdown of words/phrases that come back from the IDOL OnDemand API call

         1. group the topics for all requests

         2. count the total responses for each topic

         3. count the positive / negative / neutral responses for each topic

         4. compute an average score for each topic

         5. present the breakdown in a table, to the right of the existing Aggregate table

 

Getting Started with HP IDOL OnDemand

Before you can use the API’s you’ll need to sign up for an IDOL OnDemand developer account:

http://www.idolondemand.com/signup.html

Please indicate that you heard about IDOL OnDemand through [topcoder] in the “How did you hear about IDOL OnDemand?” field:

Once your account has been verified you’ll be assigned a developer account and API Key that will allow you to make API calls.   Complete information about available IDOL OnDemand API’s can be found here: 

https://www.idolondemand.com/developer/apis

You’ll need to register for a developer account with HP in order to get access to additional Try functionality in the API console.  Use of the APIs is free and restricted to non-commercial use at this time. Commercial use and pricing will be announced in the near future.

Before you compete in an IDOL-related challenge on [topcoder] please create a topcoder-specific key in your IDOL OnDemand Account.  You can do this by Clicking on Account->API Keys from the developer home page.

Simply generate a new key and rename it to “topcoder” as shown above.   This should be the key that you use in [topcoder] challenge completion.  This will also give you visibility to Preview API’s which may not yet be in public release. 

You should be all set!

Final Submission Guidelines

1. A video which describes the Google Sheets Add-on (a link to your video: Screenshare, Jing, or Youtube.com). Describe these aspects

   1. the source code

   2. the usage.

2. A document which describes how to deploy your code.

3. The source code as a development project

4. Submit your code and the deployment guide files as a ZIP package.