Abstract: A search option input by a user is obtained through a user interface and a search term is determined based on the search option. A document database is searched to obtain a document that matches the search term and a search result is generated, including document information identifying the document that matches the search term and relevancy information indicating a degree of relevancy between the search term and the document. A display device displays the search result in a format indicating the correspondence relationship of the document information, the search term, and the relevancy information.

Abstract: The new invention is a system for specifying spreadsheets, business plans or other numerical plans using a structured text format, also known as a domain specific language (DSL), and a grid-valued machine. The DSL is both human-readable and can be interpreted by a computing system to create a spreadsheet or related outputs, including the calculation of business metrics. The grid-valued machine is a new model for a computer fitted to this purpose, where a grid of values is used as the underlying data model (i.e., as opposed to the normal register machine model). The language can include terms for describing uncertainty, allowing the specification and presentation of stochastic plans, e.g. for risk analysis. This can be supported in the grid-valued machine using a Monte Carlo approach with multiple grids.

Abstract: Cross-tabular reports may be automatically created by a computer from received source data. After receiving the source data, the computer may determine different information types associated with fields contained in the source data. The computer may then score each field based on the information types. A score describes a suitable placement of each field as a cross-tabular report row, a cross-tabular report column or a cross-tabular report value field. The computer may then select the fields having the highest score for placement as cross-tabular report rows, cross-tabular report columns or cross-tabular report value fields in a cross-tabular report. Finally, the computer may build the cross-tabular report with the selected fields.

Abstract: A computer system is disclosed herein that surveys numerous legal documents which memorialize business or legal transactions and then determines common provisions in such documents. The forms of these “core provisions” are then stored in a knowledge base of the system. The system then allows attorney users to apply the system to analyze unsurveyed documents and use the knowledge base to recognize the core provisions that are most similar to the text of these unsurveyed documents. The user can then edit these unsurveyed documents in a rapid accurate fashion by automated means to revise text to match these core provisions. Document editing functionality is also present, along with means to use correlations to determine the likelihood of the presence/absence of specific provisions and the presence/absence of various particular documents in groups of documents used to memorialize certain types of transactions.

Abstract: A system including spreadsheet sheets, makes calculations and data transformations, which is available through a programming interface, and conforms to the grammar and syntax of a target software development language is presented. The system includes an Object Model with Data Structures representing entities involved in spreadsheets. The system includes a Parser and Code Generator that extracts data from a body of spreadsheet data, instantiates instances of Data Structures of the Object Model to represent the spreadsheet data, parses the data and formulas contained in the cells of the spreadsheets, iterates through the instantiated instances of the Data Structures, and generates source code that performs the calculations and data transformations embodied in the spreadsheet data. The system includes a Calculation Engine with software base classes that implement the common structural and data access features of spreadsheet data, and further implement the operations of common spreadsheet functions and operators.

Abstract: Embodiments of the present invention may provide a method for generating a meaningful pivot table. In one embodiment, the method may comprise receiving a command to generate a pivot table for a plurality of related data fields. The data fields may be related to each other in a hierarchy or other relationships. The method may further comprise generating a plurality of pivot table layouts based on a variety of combinations of the related data fields. The combinations may keep an order to maintain the hierarchy of the data fields. The method may further comprising displaying the plurality of pivot table layouts to a user, receiving a user input selecting one particular pivot table layout from the plurality of layouts, and displaying a pivot table according to the selected pivot table layout.

Abstract: Descried herein are various technologies to visualizing data in a spreadsheet application. Customized visualizations are generated by binding a user-defined equation with a parameter of a primitive visual shape that has been selected by the user to visualized a dataset. The user-defined equation takes as input a value of data in a cell of the spreadsheet application, and the primitive visual shape is displayed to the user as a function of the output of the user-defined equation.

Abstract: An enhanced find and replace feature for a spreadsheet program module is disclosed. The enhanced find and replace feature allows users to search for terms and attributes across multiple sheets of a workbook. The find and replace feature also allows searches to be performed based on the formatting attributes of a cell as well as the textual or numerical contents of a cell. The enhanced find and replace feature also allows users to perform bulk formatting of cells (even cells without text) in a spreadsheet. In another aspect, the enhanced find and replace feature lists all the results of the find operation in a results list so that the user may choose which result(s) to view and edit. In another aspect, the find and replace feature is modeless so that a user can search for terms or attributes, view a results list, exit the find and replace feature, perform editing functions in the document and then return to the find and replace feature.

Abstract: A system, method and computer program product for comparison of content within tables, separate from the form and structure of those tables; including identifying tables in a first and second document, creating respective text arrays of content of the tables from the first and second documents, comparing the content of the respective text arrays to determine differences between the content of the tables, and displaying the determined differences between the content of the tables, regardless of form or structure of the tables.

Abstract: Location information is integrated with spreadsheet formulas and operations. Location information may be used in filtering data, detecting data sources, performing calculations, and the like. The data may be filtered by location, individuals, places, and other location based information. The location information may be integrated into native spreadsheet formulas to perform calculations, trigger alerts, or drive other spreadsheet business logic. The location information may also be used to detect and use nearby data sources that are published near the spreadsheet user.

Abstract: Text messages are used to interact with objects in a spreadsheet. For example, text messages may be used to enter/receive data in the spreadsheet. One or more text messages may be associated with a spreadsheet. Text messages may be associated with cells, tables, charts and other objects of the spreadsheet. When the spreadsheet receives a text message, the text message is parsed and information that is contained within the text message is used to interact with one or more objects within the spreadsheet. The spreadsheet may also generate and send text messages that provide information about the spreadsheet and/or request information to be entered within the spreadsheet. For example, the spreadsheet may send out an update of one or more values/objects within a spreadsheet and/or send a request within a text message requesting information to update a table.

Abstract: Techniques for performing a process during a real time collaboration by multiple users or clients on a spreadsheet file are disclosed herein which may permit calculations to be performed locally by at least one of the clients. By doing so, increases in performance are realized since only data updates need to be provided to the host machine. As such, a determination is preferably made whether calculations performed locally can result in different data. If conflicting data is a possibility, then the calculations for the spreadsheet file will usually be performed remotely by a host machine. If not, then each client capable of doing so will perform the calculations locally and then provide only the updated data to the host machine. The determination of whether to perform the calculations locally or not may also be made dynamically, such as when one or more new formulas are added to the spreadsheet file.

Abstract: Providing visual structuring of multivariable data sets in records includes: defining a key field for sorting the records; sorting the records by the key field to find patterns; grouping equivalent field values of the key field in an equivalent field value group; forming corresponding blocks for each equivalent field value group, displaying only one field value for each block, and masking all other field values of the block.

Abstract: A system and method for scheduling, managing and reporting usage of two or more training facilities by two or more grade levels xl of instruction with two or more classifications of instruction defining typical student experience and hours including user defined multi-criteria queries, using a computer and a spreadsheet with single cell data entry and specified formulas to generate particular scheduling, tracking and reporting of facilities scheduled and educational hours' completed with infinite levels of classification.

Abstract: A computer-implemented method for managing the display of items in a web-based document application includes providing an electronic document that includes a plurality of content items, anchoring a plurality of base layers to different discrete positions of the electronic document, and anchoring ones of the plurality of content items to particular ones of the base layers so that when the spreadsheet is scrolled an a computer display, the content items move with the spreadsheet by virtue of the anchoring of the content items to the base layers and the anchoring of the base layers to the spreadsheet.

Abstract: A method for automatically forming the clearest and most useful visual plot for a given dataset of tuples. A best view type is selected for a view that includes a subsequently added new field. The visual plot is populated with the data in the view and then automatically rendered for the user. A dataset that is retrieved from a storage is analyzed to identify all the data types found in the dataset, and to determine the best view type to assign to the dataset's views. The visual plot is then populated with the data according to this best view type, and is automatically rendered for the user.

Abstract: A DataGrid user interface (UI) control is presented that is configured to display a table that includes columns corresponding to fields in a data source and rows corresponding to records in the data source. The DataGrid UI control is also configured to display a details section associated with each row in the table. One or all of the details sections can be displayed or hidden based upon properties specified by a developer or input made by a user. A property may also be set to cause the details section for a row to be displayed only when a user interface cursor is hovering over the row associated with the details section. A property may also be set to cause a details section for a row to be displayed only when the associated row is selected.

Abstract: Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a user defined value type that is incorporated into the spreadsheet as a supported data type. Generally, the extensible data types provide support for types that are not internally defined by a spreadsheet. When the extensible value type is defined, an associated set of functions are developed to operate on the type. These functions are added to the set of base functions supported by the spreadsheet. The functions, therefore, behave in a substantially similar manner to the set of base spreadsheet functions. The extensible values that are contained within the cells may be acted upon in the same way that supported base types are acted upon.

Abstract: A method for multi-dimensional performance analysis may be provided. A plurality of data may be displayed in a butterfly diagram comprising a data grid, a histogram associated with column sorting criteria, and a histogram associated with row-sorting criteria. Additional information depth may be provided with conditional formatting of the cells of the data grid.

Abstract: Preventing the inclusion of a reference to a host cell in a formula to avoid a circular reference in the formula is disclosed. In some embodiments, an indication of a selection or an attempted selection of a host cell into which a formula is being entered is received wherein the selection or attempted selection is made by a user via a user gesture associated with adding to a formula a reference to a selected cell or range of cells with respect to which the user gesture is made, and a reference to the host cell is not inserted into the formula in response to the indication. In some embodiments, a host cell is not allowed to be selected.

Abstract: Various embodiments include apparatus, methods, and systems for column navigation within a view of a table or other source of two-dimensional data. Various embodiments include method comprising displaying a first column of data from a plurality of columns of data included in table and having one or more rows across each of the plurality of columns of data, displaying a second column of data from of the plurality of columns of data directly beside the first column of data so that the one or more rows in the second column of data align with the same one or more rows in the first column and displaying with the second column of data a symbol that when actuated provides an overview menu including a list of selectable columns of data included in the plurality of columns of data included in the table.

Abstract: Implementing a digital contact sheet generator includes receiving input parameters from a remotely located user to create a table. The table includes one or more table cells, each of which comprises a text cell and an image cell. The input parameters define an appearance of the contact sheet and the table. Each table cell is formatted by selecting an image from a set of source media and calculating a size of the image cell associated with the particular table cell. A location of the image cell within the particular table cell is then determined and the image is resized. The image cell is repositioned and the resized image is drawn in the image cell.

Abstract: According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multi-dimensional data source. Some embodiments include receiving, at an analyzer module, a change indication from the spreadsheet application, the change indication being associated with an identifier entered by a user into a spreadsheet cell. In response to the change indication, a member associated with the identifier in a multi-dimensional data source may be dynamically determined. Information in the spreadsheet may then be replaced with a formula based at least in part on the determined member.

Abstract: A method and a computer program for estimating item quantities in a building project that includes one or more items. The method includes steps for providing a spreadsheet template including a summary worksheet and one or more input worksheets with a plurality of cells for estimating a quantity of an item in a building project comprising one or more items, receiving a value of a parameter inputted by a user in a predetermined cell of an input worksheet, calculating the quantity of the item based on the value and a formula for the item, and generating a list including the quantity of the item on the summary worksheet. The program includes codes for performing the method and the spreadsheet template may be used by a spreadsheet program such as MICROSOFT EXCEL.

Abstract: A system, method and program product for synchronizing spreadsheet data. A system is provided having: a scheduling system for scheduling a first import time, a second import time, a first export time and a second export time; an import system for obtaining a first spreadsheet from a first entity at the first import time, and for obtaining a second spreadsheet from a second entity at the second import time; a synchronization system for synchronizing the first spreadsheet and the second spreadsheet to obtain a first revised spreadsheet and a second revised spreadsheet; and an export system for providing the first revised spreadsheet to the first entity at the first export time, and for providing the second revised spreadsheet to the second entity at the second export time.

Abstract: In many environments such as municipal, military and construction the use of digital pen and paper systems permits end users to create or modify features on digital document, attributes associated with those features, or attribute values associated with those features. The attribute value management system includes a digital pen, at least one digital document, one or more computing devices, and a number of software programs for creating data relationships between the digital documents (e.g., features on maps and their underlying attribute values), interpreting voice or handwritten data, validating the interpreted data, and uploading the validated data to a geo-database. The attribute value management system functions to create, update or otherwise change the attribute values associated with the features by a temporal association method; a linked identification method; or a direct handwriting method.

Abstract: A system, method and computer program product for comparison of content within tables, separate from the form and structure of those tables; including identifying tables in a first and second document, creating respective text arrays of content of the tables from the first and second documents, comparing the content of the respective text arrays to determine differences between the content of the tables, and displaying the determined differences between the content of the tables, regardless of form or structure of the tables.

Abstract: A trading application can receive price and quantity information for tradeable objects. The trading application can compute implied price and quantity information for spreads of the tradeable objects. Direct and indirect price and quantity information for the spreads can be displayed in a manner that shows the relationship with each other and with the price and quantity information for the tradeable objects.

Abstract: A method, computer-readable storage medium, and computer system for modeling a dynamic system comprising a plurality of components are disclosed. A computing device is used to provide a spreadsheet environment and a plurality of shape objects within the spreadsheet environment. The shape objects represent the physical components of the dynamic system. At least one shape object has a behavioral characteristic that is associated with a physical component of the dynamic system. A connector in the spreadsheet environment is used to specify a connection between at least two of the shape objects. The connection represents a relationship between the physical components represented by the connected shape objects.

Abstract: Systems, methods, and computer readable media provide space-efficient user interfaces to data cubes and pivot table information. Because the user interfaces are more efficient in usage of display area, smaller displays can be used more effectively in reviewing such data. The user interfaces provide a multi-dimensional navigation approach among dimensions represented in the data, which allows users to more easily maintain context when reviewing large pivot table reports, and the like. Other user interface features that ease review of such reports on smaller devices also are disclosed.

Abstract: Reference adding behavior in a formula editing mode is disclosed. In some embodiments, in response to receiving an indication of a selection of a cell, a reference to the selected cell is inserted into a formula being entered into a host cell if the host cell is not a header cell, and a reference to a row or column with which the selected cell is associated is inserted into a formula being entered into a host cell if the host cell is a header cell.

Abstract: A system and method are disclosed for providing dynamic normalization of terminal source Excel files. Embodiments of the system and method automatically, continually and non-destructively transform terminal source Excel files from formats that are simple to use by end users into a format that is optimized for automated analysis. Embodiments of the system and method enable businesses to efficiently and effectively analyze corporate data stored and/or managed in Microsoft Excel.

Abstract: In a database application executing on a computer system, a database table view is represented by a structured object located on a storage device coupled to the computer system. Responsive to a user pasting content (e.g., spreadsheet data) onto the view of the table, the database application determines if the content to be pasted extends beyond the number of rows (records in a database) or columns (database fields) currently displayed in the table view. If the content extends beyond the number of rows or columns currently displayed, the database application automatically adds one or more records or fields to the structured object on the storage device, and updates the table view to display one or more rows or columns corresponding to the records or fields added to the structured object.

Abstract: A computer readable storage medium includes executable instructions to define a report part with a report part element and a report part identifier. A report part computation context including a report identifier, a report part element identifier and a context data path is identified. The report part is associated with the report part computation context. The report part is evaluated according to the report part computation context. A report part value is returned.

Abstract: A graphical user interface for creating a data summary table includes a data summary table including a plurality of fields, and a filtering pane programmed to apply filters to items in the fields of the data summary table, the filtering pane including a field selector control, wherein the field selector control is programmed to allow for selection of a field of the fields in the data summary table to define filtering for the field.

Abstract: The present invention is related to displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells including one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells including one or more cells along one or more of the spreadsheet dimensions.

Abstract: A computer-implemented method and system for creating and implementing dynamic clip art images in a software module. Clip art images are typically static in nature and cannot be modified by a user. This limitation with conventional clip art images makes them inflexible and inefficient. In contrast, a dynamic clip art image can be used to represent several similar static clip art images. Those elements of the similar static images that are distinct can be represented by dynamic properties that can be customized by a user. Dynamic clip art images can be modified by a user while inserted in an electronic document thereby eliminating the need to locate new static clip art images to replace existing static images in a document.

Abstract: A method and system are provided for inferring a schema from an electronic document containing hierarchical data for use in a spreadsheet application program. The electronic document containing the hierarchical data is received into an application program. The application program may be a spreadsheet application program. The format of the hierarchical data structure may be XML. The hierarchical data includes a set of nodes making up the structure of the hierarchical data. The nodes may be XML elements and attributes. The hierarchical data is then parsed to discover one of the nodes in the hierarchical data. Once the node has been discovered, content associated with the discovered node is saved to a memory location in the computer system. The content may include data associated with the discovered node and the type of data associated with the node. The hierarchical data is then parsed again to discover subsequent nodes until the content for all of the nodes has been saved to the memory location.

Abstract: A computing system is disclosed including a computer processor configured to receive a selection of a template and identify a data field in the template. The data field indicates financial data to fill in the data field. The computer processor is configured to retrieve the financial data for the data field from stored financial data and generate a document according to the selected template. The generated document has the financial data within the data field.

Abstract: This disclosure is directed to novel solutions for processing data in a manner similar to that employed by traditional spreadsheet applications (including, merely by way of example, evaluating expressions, producing reports and the like) without the need for a spreadsheet application. In an aspect, a spreadsheet calculation engine might be emulated in a Java environment, allowing for enhanced data input/output flexibility while still maintaining the ease with which traditional spreadsheet applications allow users to design a calculation model. In another aspect, the spreadsheet engine might be provided on a web server, database server and/or application server, allowing for data (including, for instance, reports comprising data processed and/or produced by the spreadsheet calculation engine) to be published easily (and, in some cases dynamically) on the web.

Abstract: The present invention relates to data query technologies, and provides a method for generating a financial report, comprising: generating a query instance module in an operation window when a user dragging and dropping a query instance button in the operation window is detected; generating a query condition input module which is then inserted into the query instance module when the user dragging and dropping a query condition button to said generated query instance module is detected; generating a report template selection module which is then inserted into the query instance module when the user dragging and dropping a report template button to the query instance module is detected; searching data which satisfies a query condition when the user inputting the query condition into the query condition input module is detected; and organizing the searched data to generate a financial report through a selected report template and displaying the generated financial report in a resulting window when the user select

Abstract: A computer-implemented method of presenting an electronic document via a web browser includes maintaining on a computing device a client data model of the electronic document, the client data model comprising data that defines content of the electronic document and formatting of the content of the electronic document, and rendering a first sub-portion of content of the electronic document from the client data model to a document object model (DOM) for the web browser. The method also includes providing the DOM to the web browser, for the web browser to display a view of the electronic document from the DOM.

Abstract: An image processing method of forming images of data onto a plurality of recording media each having an obverse surface and a reverse surface is disclosed. This method has a recognizing step of recognizing a delimiter of the data in document data and a recognizing step of, in the case where the delimiter of the data is recognized in the recognizing step when an image process is executed so as to form the image onto the obverse surface of a predetermined recording medium, recognizing an instruction showing either a mode to continue the image forming operation to the reverse surface of the recording medium or a mode to exchange the recording medium and continue the image forming operation from the obverse surface of another recording medium.

Abstract: A system that facilitates a grid-based approach to defining styles for a table. During operation, the system allows a user to define a new table style by specifying styles for cells in a two-dimensional grid of table cells, wherein a style for a given cell specifies one or more attributes for the given cell. The system then applies the new table style to a target table, wherein applying the new table style involves repeating or tiling a pattern of cell styles defined in the two-dimensional grid across the target table.

Abstract: A method and system for helping a user efficiently browse an electronic document using data-driven tabs. A datasheet providing technical details of a corresponding user module is scanned for indicators (e.g., embedded anchors), wherein a user module is a pre-configured circuit design operating on a microcontroller. The indicators are for indicating a predetermined location within the datasheet. The datasheet description is read and graphic elements (e.g., tabs) are automatically rendered for each corresponding indicator, wherein a graphic element is rendered according to information within the indicator. Interacting with one of the graphic elements allows a user to jump to a predetermined location within the datasheet. The graphic elements are operable for efficient navigation of the datasheet, allowing for a large datasheet to be easily viewed in a small area of a display.

Abstract: A system and method for managing data repositories may include providing techniques for end users to access and manipulate reports stored in the repositories. Text-based, image-based, or other types of reports may be stored in online and/or offline repositories, and in response to a search request, reports stored in the online and/or offline repositories may be retrieved. End users may export report data from text-based and/or image-based formats by converting the data into a spreadsheet format using various customization techniques. Thus, end users may edit, modify, analyze, or otherwise manipulate information in online and/or offline reports, while maintaining integrity of the information in the repositories.

Abstract: Embodiments display table data in formats that are suitable for presentation in a limited display area. The columns can be presented in numeric/text format as well as chart format. User input allows conversion of a column displayed using numeric format to a chart format and back, for example, by double tapping on a touch sensitive screen. A key column is displayed with the chart column. Depending on the screen size, other columns may be displayed along with the chart column. Embodiments determine whether text data is displayed using a single line or multiple lines, based on percentage of labels of the column that fit within the width of the column. Various criteria determine width of columns displayed using collapsed width or expanded width. User input allows conversion of column display from collapsed width to expanded width or back, for example, by double tapping on the screen.

Abstract: A method, computer-readable storage medium, and computer system for modeling a dynamic system comprising a plurality of components are disclosed. A computer is used to provide a spreadsheet environment. A plurality of shape objects are defined within the spreadsheet environment. The shape objects represent the components of the dynamic system, and at least one shape object has a behavioral characteristic that is associated with a physical property of a component of the dynamic system. The spreadsheet environment is used to define relationships between the components of the dynamic system using connectors that define connections between the shape objects.

Abstract: A method and device for processing and analyzing data on a personal computer which can be implemented using software which works in a Microsoft Excel environment or as a standalone software which allows users to import, filter and/or analyze a large quantity of data in an Excel worksheet; the data can be imported from disparate sources (including text files, SQL databases and Excel files) and, once imported and stored in the computer's memory, can be displayed in a single columnar table (even if they come from different columnar tables which have disparate ordering), as well as filtered, ordered, grouped, summed and/or manipulated mathematically extremely quickly with the possibility of creating dynamic graphics and/or tables relative to various parameters; the software is compatible with Microsoft Excel 2003, Microsoft Excel 2007 and Microsoft Excel 2010 and can be used within the Windows XP, Windows Vista and Windows 7 operating systems.

Abstract: Methods, systems, and machine readable mediums are disclosed for viewing multidimensional data. In one embodiment, a method is disclosed which comprises displaying multidimensional data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column of the plurality of columns including data having at least two hierarchical levels. Data for at least a first set of the plurality of cells is displayed in a graphical format, the first set including cells in the first column, the graphical format of the cells in the first set in the first column indicating a hierarchical level associated with the cell data and a mechanism is displayed for a first one of the rows to display at least one additional row having data in the first column associated with a lower hierarchical level of the first row data.