Abstract: Systems and methods are provided for managing data in a grid. In one example approach, a method comprises importing data from a data source to a range of cells in a grid, where the range of cells is specified by a notation input associated with the grid, and where the notation input includes a key specifying the data source and security information associated with the data source.

Abstract: Methods and computerized apparatus for shared business modeling involving multiple spreadsheet-based business models in a network of computers, report generation involving consolidation from at least two different spreadsheet-based business models as well as report generation involving multiple different spreadsheet-based business models are described.

Abstract: Methods, systems, and machine-readable mediums are disclosed for viewing multiply-dimensioned data. In one embodiment, a method is disclosed which comprises displaying multiply-dimensioned 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.

Abstract: Touch input is used for multi-selection of cells within a spreadsheet. For example, a user may drag a finger across the cells of the spreadsheet that they would like to select. The multi-selection of cells may include cells within one or more rows and one or more columns of the spreadsheet. The multi-selection may be adjusted to select more or fewer cells within the multi-selection. The multi-selection of cells may be used for different purposes. For example, the cells within the multi-selection may be used to display summary information related to the multi-selection (e.g. sum, average, median, min, max, count, and the like). The multi-selection may also be used to provide input to a formula that is currently being edited (e.g. a range of cells).

Abstract: Embodiments of the invention convert data from atomic tuples found in data sources such as spreadsheets (e.g., raw numbers, words, and formatted dates) into semantically enriched schemas and associated tuples. In addition to the data content, visual content, such as font and background color, is also analyzed as a part of the interpretation process. Embodiments of the invention also provide methods of interacting with the raw data via the semantically enriched schema tuples.

Abstract: Heuristic based feature degradation and/or restoration is disclosed. In some embodiments, providing a feature with respect to a set of cells includes determining that a degradation threshold associated with the feature is satisfied with respect to the set of cells and at least partially degrading the feature for the set of cells.

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: User input can be organized and presented using a multi-dimensional board comprising a plurality of cells where unique messages are displayed in individual cells in the board. In some cases the messages may be accompanied by path indicators indicating which messages on the board are responsive to which other messages. The messages can include text, video, audio, and/or various types of interactive media such as games or applets.

Abstract: In the case of editing document data that has a plurality of fields, by allowing the user to identify a field that is closely related to the selected field, operability of the editing operation of the document data is improved. A selection field detecting unit detects one of the fields according to the operation of the user. An automatic level allocating process executing unit decides the relation degrees between the detected selection field and the other fields. A field enlarging/contracting unit and a display screen control unit switch display control regarding those other fields based on the relation degrees.

Abstract: In an embodiment, a method of providing a personalized display of data is presented. In this method, an identity of each of multiple applications for displaying data is transmitted to a user device, such as, for example, a computer or mobile communication device. Selections of more than one of the multiple applications are received from the user device. Configuration data indicating the selected applications are generated and stored. A request for a presentation application is received from the user device. The presentation application is to display the data via execution of the selected applications. In response to the request, the presentation application is generated based on the configuration data, and includes the selected applications. The presentation application is then transmitted to the user device for execution.

Abstract: A method for importing document data into a website hosted on a server computer includes a block of document data that is received at the server computer. The block of document data includes data from an identified section of a document. In response to receiving the block of document data, the server computer automatically updates a web page component on the website. The web page component is selected via a document widget on the server computer. The document data is mapped to the web page component.

Abstract: A spreadsheet environment is used as a graphical user interface (GUI) for depicting and interacting with the various aspects of a system. In particular, the spreadsheet environment supports using OMG SysML to model a system, and to execute tasks associated with the systems engineering process. The spreadsheet environment also supports the use of pre-defined templates whose contents and features are common to a multiplicity of projects that a company or company unit may undertake, and which can be made specific or modified based on a project's needs.

Abstract: In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. In another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter.

Abstract: Provided are techniques for comparing data. User selection of first data to be compared is received. User input of one or more formulas used in making comparisons is received. The user is allowed to move a Comparative and Analytic (CA) lens window to hover over second data, wherein the CA lens window displays a floating, transparent document. In response to the CA lens hovering over the second data, in real-time, the first data and the second data are compared according to the one or more formulas, and the CA lens window is displayed showing the first data and the comparison between the first data and the second data.

Abstract: A data analysis and display system and method for performing a plurality of operations on data arranged in data tables. One or more of the following data operations are provided: combining separate data together, for example by joining and appending; normalizing and summarizing; copying; calculating and presenting new information from existing data; making corrections in a persistent manner, and analyzing the data, to allow users to work with their data at a high level using a core set of functions that facilitate performance of these operations in a generally simple, intuitive manner.

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: An interface for designing a report is provided, with elements of the report being disposed at intersections of report positions and configured to present information derived from data in a database. A formula is associated with one or more selected elements in the report to generate a result for the one or more selected elements. A tuple identifying the report positions of the one or more selected elements is associated and stored with the formula in a formula list associated with the report. The report is configured so that, when the report is generated, it is determined whether identifying report positions corresponding to an identified element in the report correspond with the tuple in the formula list. Upon determining the tuple corresponds with the identifying report positions for the identified element, the formula associated with the tuple is applied to generate the result.

Abstract: Apparatus, systems, and methods may operate to receive, sequentially, individual lines of information included in a file stored in an electronic storage medium; to locate one or more tables in a spreadsheet when at least two of the lines in a sequence are consecutive lines that begin with a non-empty cell and have a matching length; to determine a vertical orientation or a horizontal orientation of the tables based on an arrangement of the information within the lines and across the lines; and to create metadata from the information, based on the arrangement. The metadata may comprise object label names, object qualifications, and/or object data types. Additional apparatus, systems, and methods are disclosed.

Abstract: A scheduling application prints a portable pocket sized hardcopy of information items such as scheduled items and task lists, and prints the information onto the pocket sized hardcopy in a consistent manner on each visible side of the hardcopy by rotating and inverting the printed material in anticipation of subsequent folding. The consistent manner encompasses inverting and arranging portions of the hardcopy along fold lines to enable folding that results in an upright orientation to the displayed text and figures. Conventional scheduling mechanisms are typically unwieldy to quickly initiate and enter a single item or entry. Electronic mediums need to be powered on, a keystroke, stylus, or pointing device sequence applied to access the corresponding scheduling or notepad application, and the information entered. Conventional paper mediums tend to be bulky and thus typically in a briefcase or purse, and often have binders or covers as well as page tabbing systems that need to be navigated.

Abstract: A cell navigation system is described that allows easy navigation to cells that are likely to be important to a spreadsheet user. The cell navigation system tracks each cell that a user visits and determines the importance of the cell to the user. The system adds important cells to a navigation list. The cell navigation system presents the list to the user as a tool for navigating to the important cells through a user interface. Thus, the cell navigation system provides the user with a quick and easy way of navigating through a potentially large spreadsheet or workbook of spreadsheets to get to those cells that are most important to the user.

Abstract: A method includes identifying a first term in a document structure instance that matches a first permissible term in a glossary and identifying a second term in the document structure instance that matches a second permissible term in the glossary. A determination is made whether the document structure instance establishes an interaction between the first term and the second term. The method also includes generating, with a processor, a relationship map. The relationship map includes a first object that represents the first term, a second object that represents the second term, and an interaction object that represents whether the instance establishes the interaction between the first term and the second term.

Abstract: Tools that can be used to enhance visibility into various business processes, using named calculations and/or configured columns to produce customized display grids for displaying data from a database are presented. Such tools may provide the ability to develop, within a business application (and/or in conjunction with a business application) visibility solutions that are customized to that end user's business, without the need for expensive redevelopment and/or extensive customization of the business application itself.

Abstract: A data analysis program receives a selection of data fields defining multiple row header areas and/or multiple column header areas for display in a summary table. Data is read from a data source containing values for the data fields and transformed into summary level data for building the summary table. A display is rendered in the summary table for each of the multiple row header areas and column header areas defined, with the row header areas being displayed vertically adjacent to one another and the column header areas being displayed horizontally adjacent to one another.

Abstract: Provided is a method for displaying information such as lists of data, files and icons in a window of a graphical user interface (GUI). Unlike a typical display methodology, which arranges items in a “machine-dependent” sorting order, the disclosed technology provides a “natural” sorting order. The list, or names associated with the files or icons are incorporated into a query and the query is transmitted to a web service. The web service parses the query to determine a natural order appropriate to the material represented by the list, files, or icons rearranges the list, files or icons into the natural order and returns a response to the originator of the query. The operating system or GUI that originated the query receives the response, parses the response and displays the list, files or icons in the corresponding natural order.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for utilizing predictive models from an application scripting language.

Abstract: Techniques are provided to improve communication through selective display of attention shifting display elements. A focus of attention is determined, display events located and attention shifting display elements displayed. The attention shifting display elements suggest display events as candidate foci of attention based on the display event, the display event location and the distance from the focus of attention. Attention shifting display elements are composed of attention directing portions, and optional attention attracting and informing portions. The attention directing portions help direct attention across distances and help attract attention to a point. The informing portions indicate availability of information associated with the display event occurring outside the focus of attention.

Abstract: 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.

Abstract: A method, apparatus and program product for focusing the display of tabular data wherein the display has multiple rows and columns of cells. A computer running a tabular data application includes a display for displaying the tabular data. The tabular data application includes a routine for defining a user defined area in the tabular data display in a focused display. The routine places indicators at the top, bottom, right side and left side of the focused display. The indicators may be one of an expand indicator or a collapse indicator. A movable cursor in the tabular data display is used to select at least one of the indicators for focusing the display. The routine in the tabular data application expands or collapses the display of tabular data to give a focused display. The expanding or collapsing of the display is determined by whether the selected indicator is an expand indicator or a collapse indicator.

Abstract: A method for importing document data into a website hosted on a server computer includes a block of document data that is received at the server computer. The block of document data includes data from an identified section of a document. In response to receiving the block of document data, the server computer automatically updates a web page component on the website. The web page component is selected via a document widget on the server computer. The document data is mapped to the web page component.

Abstract: A method of storing information for recorded information and a source document is provided. The method comprises: determining a first piece of information included in the recorded information; determining at least a first source document from one or more source documents that comprises information that matches the first piece of information; and storing information identifying the recorded information, information representative of the first piece of information, and information identifying the first source document such that the information identifying the first source document can be determined given the information identifying the recorded information and the information representative of the first piece of information.

Abstract: Methods, systems, and computer program products for managing a resource include using a first object to obtain data associated with the resource that is being managed. The first object may be embedded in a cell of a spreadsheet running on a spreadsheet application. Formula in the spreadsheet are executed, where at least some of the formulas reference at least some of the data obtained by the first object. The operation of the resource may then be altered based on the results of the executed formula.

Abstract: Systems and techniques for displaying detailed information in the context of a condensed enumeration of information. For example, in one aspect, in one aspect, a display includes a visual rendition of a table that systematically arranges condensed information in a collection of rows and columns for reference by a human user. The table includes information characterizing a collection of items. The visual rendition of the table comprises a region that renders additional detail regarding a first item in the collection. The region is disposed in the midst of the visual rendition of the table.

Abstract: A method for creating a multimedia experience is disclosed. The method includes defining a first cell, defining a first branch selectively associated with the first cell, and defining a second branch selectively associated with the first cell. The method further includes associating a variable with the first cell that is configured to identify one of the first and second branches. The method further includes defining a second cell, associating the second cell to the first cell such that the variable is reflected in the second cell, and generating copies of the first and second branches in response to the association of the variable to the second cell.

Abstract: A word processing or spreadsheet application is augmented by a plug-in and templates for computer aided design of electronic hardware entities. The plug-in utilizes the application programming interface to provide a menu system and executable code which inserts templates, reads and validates data entered into the template, computes addresses, annotates addresses and error messages back to a word processing document for display in the editor of the word processing document, and upon selection and request, generates output files for target simulators or synthesis tools.

Abstract: The present invention is an apparatus and method for constructing a Constraint-Choice-Action Matrix for making decisions based on constraints. Columns (in one matrix orientation) state conditions. The column header presents a partial boolean expression. Such variable expression may be any object or type, e.g., a number, string, or list. An entry in a cell, selected using a GUI pick-list, combines with the column header, to complete the boolean expression. The set of boolean expressions in a row may be combined into an action boolean statement. If that statement evaluates to true, some action, represented as a row header, is recommended or executed. The matrix is applied to an instance of a context domain, for decision-making. The context domain may be represented in a model representing an instance of that domain (e.g., a product specification for configuration of a machine) in data and rules.

Abstract: A tool set is provided that uses a series of modules (e.g. spreadsheet workbooks) for assessing risks/threats to and attacks against a project and developing countermeasures against such risks/threats/attacks. The project may cover a wide berth of functionality from alarm systems, computer security, building projects, etc. The roll up feature of the spreadsheet may be employed to evaluate changing scenarios in a short period of time. Ranked threats and countermeasures operable to defeat such threats may be displayed in a tree diagram generated by one or more of the modules.

Abstract: A spreadsheet environment is used as a graphical user interface for depicting and interacting with the various aspects of a system. In particular, the spreadsheet environment supports using OMG SysML to model a system and to execute tasks associated with the systems engineering process.

Abstract: In one embodiment, during a design mode an editing interface is provided, the interface including a plurality of cells arranged in a layout. An instruction is received to cause binding of a widget to a first cell, and data is received at the first cell. During a production mode, a view of the document is displayed. The first cell is updated to reference changed data when it is detected that data within the widget is changed via user input at the widget. The widget is updated to reference changed data when it is detected that data within the first cell has changed for a reason other than user input at the widget.

Abstract: Heuristic based feature degradation and/or restoration is disclosed. In some embodiments, a feature is provided with respect to a set of spreadsheet cells. The feature consumes processing power. If a degradation threshold associated providing the feature is satisfied, the feature is at least partially degraded so that an expected latency of providing the feature is at least in part avoided. If a restoration threshold associated with providing the feature is satisfied, the feature is at least partially restored for the set of cells.

Abstract: The invention relates to a system and method for preparing Excel™-based analysis reports, which involve processing basic data stored in a database and preparing analysis reports or a screen on the basis of the Excel™ program. The system and method takes an SQL sentence for a database from a user; generates a DB object for the sentence; generates a pivot table cache on the basis of the DB object; and receives an Excel™ display object prepared by the user, wherein data referenced by the Excel™ display object are dependent on the pivot table cache; and generates meta-information for a report, containing the Excel™ display object and the DB object. According to the invention, users may prepare reports using the Excel™ well-known to office workers. Thus, users may easily extract necessary information from the database, and prepare reports and online analytical processing (OLAP) screens having various formats.

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: Generally speaking, systems, methods and media for processing a spreadsheet for storage in a database are disclosed. Embodiments may include a method for processing records of a spreadsheet by receiving a request to process a spreadsheet having a plurality of records for storage in a database. Embodiments may also include accessing a configuration file associated with the spreadsheet and, for each record of the spreadsheet, creating a new business object and populating the new business object based on the record and the configuration file associated with the spreadsheet. Embodiments may also include passing each new business object to a back-end business component for processing. The configuration file may include a name of a business object associated with a record of the spreadsheet, metadata for one or more columns of the spreadsheet, and/or a name of a back-end business component associated with the spreadsheet.

Abstract: First, second, and third sets of spreadsheet cells are defined in a display, the first and second sets being separated by a first boundary having a selected orientation, the second and third sets being separated by a second boundary having the selected orientation. A selected scrolling function is disabled within selected sets among the first, second and third sets of cells in accordance with an alternating pattern.

Abstract: The present invention includes a method and system for persistently self-replicating multiple ranges of cells through a copy-paste operation, in a multi dimensional spreadsheet. A set of ranges of cells is defined, wherein each range of cells has the same size. Each time the content of a range of cells belonging to this set is changed, a self-replication operation is performed automatically. The self-replication operation includes the steps of copying the changed range of cells onto a buffer; determining the set of ranges of cells to which the changed range of cells belongs to; identifying the ranges of cells belonging to the set; and pasting the content of the buffer in each of identified range of cells belonging to the set.

Abstract: First, second, and third sets of spreadsheet cells are defined in a display, the first and second sets being separated by a first boundary having a selected orientation, the second and third sets being separated by a second boundary having the selected orientation. A selected scrolling function is disabled within selected sets among the first, second and third sets of cells in accordance with an alternating pattern.

Abstract: A method and apparatus create a way of controlling alternative values of cell contents of a data flow network. Alternative values are computed from alternative formulas, which may be turned on and off in separate layers. Typically, one formula is provided for each layer for each cell of the data flow network. Layers can be grouped together to model different scenarios and can be added or removed.

Abstract: A spreadsheet user interface accepts a request for at least one fact, the request comprising a user-selected identifier for the desired fact. Responsive to the entry of the request, a fact repository containing information derived from unstructured documents is accessed. The fact or facts corresponding to the request, if any, are retrieved from the repository, and the results are displayed at the location of the spreadsheet that is associated with the request.

Abstract: Embodiments of the invention convert data from atomic tuples found in data sources such as spreadsheets (e.g., raw numbers, words, and formatted dates) into semantically enriched schemas and associated tuples. In addition to the data content, visual content, such as font and background color, is also analyzed as a part of the interpretation process. Embodiments of the invention also provide methods of interacting with the raw data via the semantically enriched schema tuples.

Abstract: Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table.

Abstract: A spreadsheet includes a native spreadsheet object that represents a person. The person object may be used within a spreadsheet just as any other spreadsheet objects are utilized. For example, the person object may be integrated with spreadsheet formulas and other spreadsheet objects such as charts, tables, pivot tables, sheets, and the like. Spreadsheet formulas may perform operations specific to a person object (e.g. send message, get contact information, get status, get other person specific information, sort, and the like). Common actions may be associated with the person object, such as initiating communication with the person represented by the person object (e.g. phone call, email, text message, collaboration invite, and the like). Social networking information may also be associated with a person object. For example, social networking posts may be included within a spreadsheet, a user may post to a social network from the spreadsheet, and the like.