Including Graph Or Chart Of Spreadsheet Information Patents (Class 715/215)
-
Patent number: 7921371Abstract: A system and method of multi-objective visualization utilize a multiple-objective optimizer approach to multi-objective optimization and specifically utilize a method for exploring and visualizing Pareto surfaces for any number of dimensions using an interactive graphical user interface. The general solution is to maintain all natural problem objectives separately and use a special multiple-objective optimizer to solve the problem. In this case there is no single solution point. Rather, the solution is a hyper dimensional surface in an objective space with various surface points representing different tradeoffs between objectives.Type: GrantFiled: March 22, 2007Date of Patent: April 5, 2011Assignee: Versata Development Group, Inc.Inventors: Vladimir Roubtsov, Abhiman Chatra, Asif Ahmed Sheikh
-
Patent number: 7895511Abstract: A system and method for copying and pasting cells in a multi-dimensional spreadsheet. The method is implemented by execution of program code by a processor of a computer system. A source range of cells is copied and pasted in a multi-dimensional spreadsheet onto a destination range of cells in the spreadsheet by performance of a comprehensive paste of the source range of cells onto the destination range of cells. A graphical object in the source range of cells has an associated fastened range of cells, and an associated working range of cells identified by a first relative offset. The copying and pasting results in: the graphical object being within the destination range of cells; and the fastened range of cells and the working range of cells being respectively pasted into an associated fastened range of cells and an associated working range of cells in the destination range of cells.Type: GrantFiled: August 17, 2007Date of Patent: February 22, 2011Assignee: International Business Machines CorporationInventors: Jean-Jacques Aureglia, Frederic Bauchot, Catherine Soler
-
Publication number: 20110029853Abstract: A method and apparatus is disclosed for enabling advanced visualization techniques for conveying analytics information to a user. For the presentation of analytics data within a natural language statement or series of statements, a template is stored in a template database and includes natural language statements with data fields embedded within the statements. The data fields are populated with the appropriate analytics data such that the resulting reporting statement reads like a conversational statement of data and trends. Other advanced data visualizations of analytics helps one to quickly understand changes in key metrics for an entire account, compare the performance of reports across profiles, plot RSS feed events against metrics, and easily share data with others in ones organization.Type: ApplicationFiled: August 3, 2010Publication date: February 3, 2011Applicant: WEBTRENDS, INC.Inventors: Justin Garrity, Ryan Parr, David Stewart, Nicholas Fedoroff, Adam Keene
-
Patent number: 7844892Abstract: The invention provides improved mechanisms for the construction and rendering of graphical results sets for business intelligence reports derived from large volumes of data. This is achieved by various means including, determining the amount of useful data that can be rendered within the available display space while still being legible, determining the most effective way of displaying that data within the display space, and providing for limited control of the format and quantity of data displayed.Type: GrantFiled: August 17, 2006Date of Patent: November 30, 2010Assignee: International Business Machines CorporationInventors: Nadia Shewchenko, Henning Hoffmann, Roger Chang, Lesley Grignon
-
Systems and methods for interactively creating, customizing, and executing reports over the internet
Patent number: 7840600Abstract: The present invention enables users to interactively create, customize, and execute reports on data stored in databases using only a web browser. The user can create, customize, and execute reports by selecting various report elements including, for example, data sources, fields, filters, labels, charts, dashboards, and the like. Advantageously, the present invention enables users to create the reports through an Internet connection, without any special software, such as web browser plug-ins, database applications, and the like, without knowledge of data access languages, such as SQL, and without direct access to a database server. The present invention can directly connect to a plurality of different database types through a virtual or physical network connection. It fully functions without requiring the creation of additional configuration items like catalogs, models or secondary schemas by a programmer or database administrator (DBA).Type: GrantFiled: December 29, 2007Date of Patent: November 23, 2010Assignee: Izenda, LLCInventor: Sanjay Bhatia -
Publication number: 20100257116Abstract: In a method for estimating a complexity of a computing job, selected data objects relevant to a data repository are retrieved. In addition, points are assigned to multiple elements of the selected data objects according to a predefined schedule and scores for the selected data objects are calculated by applying a mathematical function to the multiple elements and complexities of the data objects are estimated based upon the calculated scores and the predefined schedule. In addition, a complexity of the computing job is estimated based upon the estimated complexities of the data objects and the estimated complexity of the computing job is stored.Type: ApplicationFiled: April 5, 2010Publication date: October 7, 2010Applicant: Accenture Global Services, GmbHInventors: Dharmesh Rajendra Mehta, Sudha Sahasrabudhe, Shagufta Shashank Kohli, Anu Tayal, Vineet Tiyagi, Shalini Agarwal, Santosh Ray, Satyendra Chauhan, Kalamalla Basha
-
Publication number: 20100251090Abstract: Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.Type: ApplicationFiled: June 7, 2010Publication date: September 30, 2010Applicant: MICROSOFT CORPORATIONInventors: Benjamin C. Chamberlain, Bruce Cordell Jones, Christopher M. Street, Eric B. Vigesaa
-
Patent number: 7805667Abstract: A system and method to identify target node graphs from predetermined seed node subsets are described. A one-sided constrained spectral embedding of a graph using a predetermined set of seed nodes within the graph is computed. Next, a threshold boundary is identified to define a target area for a target subgraph within the embedded graph using predetermined network-flow calculations, the target subgraph including the predetermined set of seed nodes. Finally, the target subgraph is identified based on the calculated threshold boundary.Type: GrantFiled: December 6, 2006Date of Patent: September 28, 2010Assignee: Yahoo! Inc.Inventors: Kevin J. Lang, Vivek B. Tawde
-
Patent number: 7779344Abstract: There is provided a system and method for creating a value-based stacked bar chart. More specifically, in one embodiment, there is provided a computer readable medium comprising code adapted to sort a plurality of data entries by transaction value, wherein the plurality of data entries correspond to a stack type; code adapted to assign each of the plurality of data entries to one or more cells associated with the stack type, code adapted to assign a color to the one or more cells, and code adapted to shade the color of a subset of the one or more cells based on the transaction value of the data entries assigned to the cells in the subset.Type: GrantFiled: October 31, 2006Date of Patent: August 17, 2010Assignee: Hewlett-Packard Development Company, L.P.Inventors: Ming C. Hao, Umeshwar Dayal, Martha Lyons
-
Patent number: 7770100Abstract: Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.Type: GrantFiled: February 27, 2006Date of Patent: August 3, 2010Assignee: Microsoft CorporationInventors: Benjamin C Chamberlain, Bruce Cordell Jones, Christopher M Street, Eric B Vigesaa
-
Patent number: 7757179Abstract: A display method wherein a labeled scatter chart is displayed on a graphical user interface, the scatter chart having a plurality of labels. A first modification of one of the labels is entered via a graphical user interface by a user. Execution of labeling instructions that implement a labeling algorithm for generating a first modified labeled scatter chart in response to the entry of the first modification is started. The first modified labeled scatter chart is displayed.Type: GrantFiled: September 14, 2006Date of Patent: July 13, 2010Assignee: Think-Cell Software GmbHInventors: Sebastian Theophil, Arno Schoedl, Markus Hannebauer
-
Patent number: 7673247Abstract: Control limit values may be related to noncomplying points by receiving a user selection indicating one or more datapoints to be used in a control limit operation, calculating control limit values based on the datapoints, wherein the control limit values indicate one or more noncomplying points that are not within an expected range, generating a display relating the control limit values to the noncomplying points, and identifying the noncomplying points in the generated display.Type: GrantFiled: November 27, 2002Date of Patent: March 2, 2010Assignee: Hewlett-Packard Development Company, L.P.Inventor: Donald J. Nicholson
-
Patent number: 7669115Abstract: A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e. non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.Type: GrantFiled: October 25, 2005Date of Patent: February 23, 2010Assignee: OutlookSoft CorporationInventors: Charles J. Cho, Perlie E. Voshell
-
Publication number: 20100042913Abstract: Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value). Formats can include color-scale backgrounds, in-cell elements (e.g., icons and data bars), and other cell formats that can be varied with a value.Type: ApplicationFiled: August 26, 2009Publication date: February 18, 2010Applicant: Microsoft CorporationInventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
-
Publication number: 20100037126Abstract: Methods, systems, and storage mediums for database management services for a telecommunications system are provided. A method includes transferring, via a managed language application, raw data extracted from a legacy system to a first spreadsheet application macro. The method also includes merging, via the first spreadsheet application macro, selected portions of the raw data, and creating a first spreadsheet file that includes the merged data. The merged data relates each physical and virtual fiber of the telecommunications system to the merged data. The method further includes transferring, via the managed language application, the first spreadsheet file to another spreadsheet application macro, and generating, via the other spreadsheet application macro, a graphical drawing comprising a cable ring that includes fiber routes and telecommunications equipment. The graphical drawing is generated using the merged data.Type: ApplicationFiled: September 29, 2009Publication date: February 11, 2010Applicant: AT&T Intellectual Property I, L.P. f/k/a BellSouth Intellectual Property CorporationInventors: Elisa Andrews, Cynthia Hoffner, Stanley Greenstein
-
Patent number: 7617444Abstract: File formats, methods, and computer program products are provided for representing a workbook in a modular content framework. The modular content framework may include a file format container associated with modular parts. A file format includes logically separate modular parts that are associated with each other by one or more relationships where each modular part is associated with a relationship type. The modular parts include a workbook part operative as a guide for properties of the workbook and a worksheet part associated with the workbook part and operative to specify a definition of cells within a worksheet associated with the worksheet part. The modular parts may also include a document properties part containing built-in properties associated with the file format and a thumbnail part containing associated thumbnails. Each modular part is capable of being interrogated separately, extracted from the workbook, and/or reused in a different workbook.Type: GrantFiled: December 20, 2004Date of Patent: November 10, 2009Assignee: Microsoft CorporationInventors: Chad B. Rothschillwe, Su-Piao B. Wu
-
Patent number: 7610549Abstract: A method and system for Java Gantt/bar chart rendering includes an extractor to receive project data, a table generator to generate a project table suitable for representing the project data, and a dynamic page component to generate a Gantt chart image utilizing the project table. The system further includes a cell rendering component to render at least one cell of the project table by identifying a suitable graphical image and by applying the graphical image to the cell.Type: GrantFiled: May 20, 2004Date of Patent: October 27, 2009Assignee: SAP AGInventor: Peter Vignet
-
Patent number: 7584415Abstract: A method for rendering a chart associated with a document includes translating a chart object into a shape-based chart definition, wherein the chart object defines the chart with chart elements, and the shape-based shape definition defines the chart with shapes, and maintaining the chart object in the document to enable access to underlying chart data contained in the chart. A system includes a chart object defining a chart with chart elements, a graphics module operable to render shapes, a charting module generating a shape-based chart definition based on the chart object, wherein the shape-based chart definition defines the chart with shapes that can be rendered by the graphics module.Type: GrantFiled: September 15, 2004Date of Patent: September 1, 2009Assignee: Microsoft CorporationInventors: Daniel P. Cory, Miltos Vafiadis, Sissie Ling-le Hsiao
-
Patent number: 7581165Abstract: A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e., non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.Type: GrantFiled: October 25, 2005Date of Patent: August 25, 2009Assignee: OutlookSoft CorporationInventors: Charles J. Cho, Perlie E. Voshell
-
Patent number: 7580944Abstract: The present disclosure describes a standardized logical model architecture, for use in building a business intelligent systems, and a system and method of using the logical model architecture to populate a data repository (e.g., a data mart/warehouse) with the data to satisfy reporting and data analysis needs.Type: GrantFiled: July 27, 2006Date of Patent: August 25, 2009Assignee: Yahoo! Inc.Inventors: Yue Zhuge, Mahmoud Alnahlawi
-
Patent number: 7581168Abstract: A method, system, and computer-readable medium are provided for determining whether to reproduce a chart image from the contents of a spreadsheet application workbook on a server. A calculation server calculates chart data for defining a chart image from workbook data retrieved from the spreadsheet application workbook, generates a representation of the chart data, and calculates an identifier for the representation of the chart data. A charting component receives the representation of the chart data and the identifier from the calculation server and compares the calculated identifier to a previously stored identifier on the server. If the calculated identifier is equal to the previously stored identifier, then the charting component retrieves a previously produced chart image from the representation of the chart data from the server. If the calculated identifier is not equal to the previously stored identifier, then the charting component produces a chart image from the representation of the chart data.Type: GrantFiled: December 20, 2004Date of Patent: August 25, 2009Assignee: Microsoft CorporationInventor: Sean M. Boon
-
Patent number: 7555731Abstract: A method of navigating and creating hierarchical documents is disclosed. The illustrative embodiments of the present invention enable a user to navigate quickly through multiple levels and sub-levels of hierarchichal documents without having to manually change the displayed view. Additionally, the method enables a user to create connections between objects in different levels and sub-levels of hierarchical documents without manually changing the view. A user is able to start connections on one level and continue the connection into a sub-level that was initially hidden or collapsed without stopping.Type: GrantFiled: February 22, 2006Date of Patent: June 30, 2009Assignee: The Math Works, Inc.Inventor: Jay Ryan Torgerson
-
Publication number: 20090150758Abstract: A system and method for creating a template configured to generate reports for reporting medical information. The method allows a user to generate a single template that may be then utilized in order to create a plurality of reports for numerous patients. The template is created by dragging and dropping the desired information onto a blank report. Once the desired format of the template has been set by the user, the user may save the template for future use.Type: ApplicationFiled: December 7, 2007Publication date: June 11, 2009Applicants: Roche Diagnostics Operations, Inc.Inventors: Igor Gejdos, Morris J. Young, Jason Bush, Scott W. Leahy, Schuyler Buck, Ryan Scott McKinney
-
Patent number: 7546522Abstract: A method, system, and computer-readable medium are provided for applying a global formatting scheme to a chart in an electronic document. According to a system, a chart application program receives a selection of a chart object in the electronic document and a document theme. The document theme includes a combination of formatting schemes including a color scheme, a font scheme, and a style matrix. The chart application program then automatically applies the selected document theme to the selected chart object in the electronic document. In applying the selected document theme to the selected chart object, the chart application program automatically updates a number of properties of the chart object including color, font, line, effect, and fill.Type: GrantFiled: December 20, 2004Date of Patent: June 9, 2009Assignee: Microsoft CorporationInventors: Kristin M. Tolle, Brian S. Ruble, Miltiadis Vafiadis, Sander Viegers, Daniel P. Cory
-
Patent number: 7512875Abstract: Methods and systems provide a “chart view” for a markup language referred to as Reusable Data Markup Language (“RDML”). Generally, a chart view comprises the components necessary for automatically manipulating and displaying a graphical display of numerical data contained in RDML markup documents. RDML is a markup language, such as the Hypertext Markup Language (“HTML”) or the Extensible Markup Language (“XML”). Generally, RDML facilitates the browsing and manipulation of numbers, as opposed to text as in HTML, and does so by requiring attributes describing the meaning of the numbers to be attached to the numbers. Upon receiving RDML markup documents, the chart view transforms, formats, manipulates and displays data stored in the markup documents using the attributes describing the meaning of the data.Type: GrantFiled: May 3, 2005Date of Patent: March 31, 2009Assignee: E-Numerate Solutions, Inc.Inventor: Russell T. Davis
-
Publication number: 20090024911Abstract: Disclosed herein are systems and methods where a time-stamped graphical parameter is displayed in one portion of a display window with a period of relevance highlighted and textual log entries from one or more of various selected logs corresponding to the highlighted time period are displayed in a second portion of the display window. In one embodiment of the invention, the period of relevance on the graph may be manipulated by using GUI controls. As the period of relevance on the graph is changed, the displayed textual log entries are updated to reflect those entries within the current period of relevance.Type: ApplicationFiled: January 29, 2008Publication date: January 22, 2009Applicant: APPLE INC.Inventor: MICHAEL RYAN MARGOLIS
-
Patent number: 7430710Abstract: A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e., non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.Type: GrantFiled: October 25, 2005Date of Patent: September 30, 2008Assignee: OutlookSoft CorporationInventors: Charles J. Cho, Perlie E. Voshell
-
Patent number: 7421652Abstract: A document summary which includes an assemblage of a plurality of summary entries is generated for an electronic document. In the generation of the document summary, a content structure or properties within the electronic document are analyzed. The plurality of summary entries are selected from the contents of the electronic document based on the analysis of the content structure or properties. The content structure within the electronic document may include a table of contents, a plurality of spreadsheet worksheets, a plurality of document pages, etc. The content properties within the electronic document may include text formatting, paragraph formatting, paragraph sizing, etc. Preferably, the best available content structure or properties within the electronic document is identified and utilized in the selection of the plurality of summary entries. The document summary is provided to a mobile communication device in response to a request for the electronic document.Type: GrantFiled: October 24, 2003Date of Patent: September 2, 2008Assignee: Arizan CorporationInventors: Jianwei Yuan, Olav A. Sylthe
-
Publication number: 20080195928Abstract: Disclosed are a method, information processing system, and computer readable medium for graphically representing data in a spreadsheet. The method includes displaying a set of tabular data visually arranged at least in rows and columns. A user selection of a first dimension and second dimension of data in a series of a first column and second column, respectively, in the set of tabular data is received. A user selection of at least one series identifier in a third column is received. Each distinct set of data entries within the third column is found automatically and without manual intervention. A graphical representation of the user selected tabular data is automatically created without manual intervention. The graphical representation is based on the selected first dimension of data in the series, the selected second dimension of data in the series, and the selected series identifier.Type: ApplicationFiled: February 8, 2007Publication date: August 14, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Moshe E. Matsa, Eric Perkins
-
Publication number: 20080163041Abstract: The invention refers to a system of recording the activities carried out by an individual person during specific time intervals. This system will normally be on an electronic device, but the initial method of recording may be paper-based. This system involves recording activity and associated attributes as a function of time on a grid, using lines to define the activity recorded in each grin interval. The invention is an intuitive data entry system, principally but not exclusively via touchscreen. The system will preferably be deployed on a handheld digital device with touchscreen entry capability. The activity recording system may also record values, attributes or files associated with specific time intervals. It may generate charts, tables, alerts and reminders. It may synchronize with other devices and applications and may import or export data from them.Type: ApplicationFiled: October 3, 2007Publication date: July 3, 2008Inventor: Katrina Delargy
-
Publication number: 20080148140Abstract: An object of the present invention is to conveniently visualize data represented as a ratio or range in a cell of a spreadsheet. A ratio graph image having the length of the ratio to the width of the cell to which the ratio data is input is created and the ratio graph image is located in a predetermined cell. When the size of the ratio graph is changed, the size of the ratio graph is accordingly drawn again to represent the accurate ratio at all times. By registering data in various units in ratio data definition information, the type of data which can be represented in a graphic form is extended.Type: ApplicationFiled: December 21, 2005Publication date: June 19, 2008Inventor: Kimiyasu Nakano
-
Publication number: 20080104529Abstract: A computer program product for providing a graphical user interface for graphing results of a Structured Query Language (SQL) is presented and calls for displaying fields identified by the query; identifying selected fields from the query for graphing; and graphing the data from the selected fields.Type: ApplicationFiled: October 31, 2006Publication date: May 1, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Larry J. Cravens, Ron T. McCargar
-
Publication number: 20080082908Abstract: A computer implemented method of processing data includes creating a data table characterizing data values, receiving a data selection from within the data table, and automatically generating a data chart based on the data selection. A specified preference may be recorded. The specified preference may be applied to create a revised data chart.Type: ApplicationFiled: September 29, 2006Publication date: April 3, 2008Applicant: Business Objects, S.A.Inventor: John Malcolm MacGregor
-
Publication number: 20080046805Abstract: The invention provides improved mechanisms for the construction and rendering of graphical results sets for business intelligence reports derived from large volumes of data. This is achieved by various means including, determining the amount of useful data that can be rendered within the available display space while still being legible, determining the most effective way of displaying that data within the display space, and providing for limited control of the format and quantity of data displayed.Type: ApplicationFiled: August 17, 2006Publication date: February 21, 2008Applicant: Cognos IncorporatedInventors: Nadia Shewchenko, Henning Hoffmann, Roger Chang, Lesley Grignon
-
Publication number: 20080010589Abstract: A chart data layout system and method of processing chart data in a report is provided. The chart data layout system comprises a query module for decomposing required data into required data queries, a chart layout module for rendering a chart based upon chart data received from the queries, a category module for displaying category aggregate information in a category location of a chart, and a series module for displaying series aggregate information in a series location of the chart. The method comprises the steps of decomposing required data into queries, retrieving queried data, rendering a chart based upon the queried data, rendering category information on a category label of the chart based upon queried data, and rendering series information on a series label of the chart based upon queried data.Type: ApplicationFiled: June 22, 2006Publication date: January 10, 2008Applicant: Cognos IncorporatedInventor: Stephen Gibson