Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Mechanisms to auto-generate web dashboards using existing spreadsheet data

IP.com Disclosure Number: IPCOM000238588D
Publication Date: 2014-Sep-04
Document File: 5 page(s) / 138K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method of automatically processing spreadsheet data to create a web archive file. The web archive file will contain auto-generated summary view and user selected detailed level views. The web archive file will also have capability to support different views for the different personas.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 01 of 5

Mechanisms to auto-generate web dashboards using existing spreadsheet data

Spreadsheets are widely used as data stores for a wide variety of data. The spreadsheets allow users to group information in tabs within one spreadsheet document. Thus the data in spreadsheets can be really huge. The users are also allowed to add some graphs/figures which allows them to display their data visually in an easily digestible form. This feature is of enormous value when presenting data to an audience that do not have in-depth knowledge of the data.

Problem Statement

However, there are several limitations in the way spreadsheets data can be displayed today. Some of the existing limitations that this invention addresses are:
1. There is no easy way to automatically convert the spreadsheet data in a dashboard with separate summary and details view.

2. There is no way to convert the spreadsheet data into a web archive file which can then be easily deployed by the users in a light weight web server and used to view the data in a much more user-friendly web format.

3. There is no existing framework to report dynamic data that is platform independent - is not dependent on any reporting tools, for example Cognos*, BIRT**.

4. By converting the information to a web application format - the user an also gets to use the powerful navigation capabilities to get a better and faster understanding on the relationship between the data elements.

5. User can also get views based on personas for their spreadsheet data - Executive, SME, Operator view.

Disclosed is a method of automatically processing spreadsheet data and creating summary and detailed level view for the data which can be exported as web archive files. This will be achieved by integratin...