Inventors list

Assignees list

Classification tree browser

Top 100 Inventors

Top 100 Assignees


Spreadsheet

Subclass of:

715 - Data processing: presentation processing of document, operator interface processing, and screen saver display processing

715200000 - PRESENTATION PROCESSING OF DOCUMENT

Patent class list (only not empty are listed)

Deeper subclasses:

Class / Patent application numberDescriptionNumber of patent applications / Date published
715217000 Cell format 41
715219000 Particular calculation of cell content 33
715220000 Particular cell content modification 25
715215000 Including graph or chart of spreadsheet information 9
715213000 Alternative scenario management 6
715214000 Having dimension greater than two 4
20090037803SYSTEM IN AN ELECTRONIC SPREADSHEET FOR PERSISTENTLY SELF-REPLICATING MULTIPLE RANGES OF CELLS THROUGH A COPY-PASTE OPERATION AND A SELF-REPLICATION TABLE - 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.02-05-2009
20100318891PEEKING INTO THE Z-DIMENSIONAL DRAWER - Described herein are methods and systems for analyzing multidimensional data that use tangential exploration of data via a third or Z-dimension to the current two-dimensional view. The tangential exploration allows higher dimensionality to be explored without causing visual clutter.12-16-2010
20090327852APPARATUS AND METHOD FOR NAVIGATING A MULTI-DIMENSIONAL DATABASE - A computer readable storage medium comprises executable instructions to provide a Graphical User Interface for displaying visualizations of a multi-dimensional database. An action is received within a visualization of a table of the multi-dimensional database, the action performed by a user when selecting a cell of the table. A slice in the visualization is populated in response to the action. The visualization is filtered to drill down on dimensions associated with the cell.12-31-2009
20090217147MULTIDIMENSIONAL DATA VISUALIZATION USING FOUR OR MORE DIMENSIONS - A solution is provided wherein multiple instances of source data measures are displayed in individual cells by utilizing a slicing mechanism that allows the user to select a range of values for certain dimensions known as slicers. The source data measures to be displayed in a cell may then be filtered using these ranges of values for the slicers, and then displayed inside the cell.08-27-2009
715216000 Cell protection 1
20090150761Method and apparatus for protecting regions of an electronic document - A method and apparatus for protecting regions of an electronic document are provided. According to the method, the entire electronic document is protected. The selection of a region within the electronic document is received along with identity of one or more users authorized to freely edit the selected region. The identified users are authorized to freely edit only the selected region of the electronic document. A request is then received to edit a region of the electronic document from a current user. In response to the request, a determination is made as to whether the current user is authorized to edit the region. If the user is not authorized to edit the region, the request is denied.06-11-2009
Entries
DocumentTitleDate
20110197117SYSTEMS AND METHODS FOR PROCESSING COLOR INFORMATION IN SPREADSHEETS - Methods to facilitate the processing of color information in spreadsheets described using markup languages are presented. In some embodiments, a method for storing color information for objects in a spreadsheet document described in a markup language may comprise obtaining distinct color values from a plurality of spreadsheet color table objects. The color values in the plurality of spreadsheet color table objects are referenced by spreadsheet objects through a plurality of indexes and each index corresponds to a distinct color table object. The distinct color values are stored in a color palette table object and are accessed using a color palette index. Index values in each of the plurality of color tables are mapped to the color palette index, if the index value and the color palette index value point to the same color value. The mapping permits objects to reference color values in the color palette object table.08-11-2011
20100083082Locking spreadsheet cells - In some embodiments, an option to lock one or more associated cells is provided with respect to each different group of cells in a single sheet of a spreadsheet application. One or more locked cells of a group of cells do not scroll out of view at least while a portion of the group of cells is viewable in a given display view.04-01-2010
20100083081Multi-level naming of grouped data - Multi-level naming of grouped data is disclosed. In some embodiments, a specification of a plurality of levels of headers with respect to at least one dimension of a group of cells is received, and header cell values of header cells comprising the plurality of levels of headers are enabled to refer to one or more associated cells in the group of cells.04-01-2010
20130086459Automatic Scoping of Data Entities - A system for creating a report in a spreadsheet includes a data source module programmed to identify sources of data items associated with the spreadsheet, an active module programmed to identify which of the data items are associated with the report that is generated in the spreadsheet, and a display module programmed to display on a field pane with an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab displaying all of the data items associated with the spreadsheet.04-04-2013
20130086460Automatic Relationship Detection for Reporting on Spreadsheet Data - A system for creating a report in a spreadsheet includes: a central processing unit; and a memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create: a data source module programmed to identify tables associated with the spreadsheet; a relationship module programmed to analyze the tables and identify relationships between the items; and a display module programmed to display the relationships between the tables.04-04-2013
20100100801Router / switch configuration automatic generation method - A method of automating the generation of network element configurations using a single electronic document is disclosed. A plurality of input statements regarding information relating to hardware, operating system, application and locale for each network element in a network are input to the document. A truth table of permitted hardware and operating system combinations is applied to the input statements. The specific sets of input statements are assembled into configuration skeletons, and a listing is generated of all possible configuration statements for specific hardware-operating system combinations.04-22-2010
20100095195Defining spreadsheet functions - Defining spreadsheet function behavior is disclosed. In some embodiments, in response to receiving a selection of a parameterized spreadsheet function behavior to be associated with a spreadsheet function, the parameterized spreadsheet function behavior is associated with the spreadsheet function based at least in part on the selection. In some embodiments, the parameterized spreadsheet function behavior is associated with a behavior of the function with respect to one or more arguments of the function.04-15-2010
20090044091Reference adding behavior in formula editing mode - 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.02-12-2009
20090044089Automatic insertion of a default function - Automatically inserting a default function into a host cell is disclosed. In some embodiments, in response to receiving an indication of a selection and/or a specification of a set of one or more cells while in a formula editing mode, a default function is automatically inserted into a host cell into which a formula is being entered with the set of one or more cells as its arguments.02-12-2009
20090044088Context sensitive delimiter insertion when adding references - Context sensitive delimiter insertion when adding references is disclosed. In some embodiments, a plurality of indications of selections of a cell or cell range while in a formula editing mode in a host cell into which a formula is being entered is successively received, and in response to receiving each indication of selection of the plurality a reference to the selected cell or cell range is successively inserted into the formula, wherein the references inserted into the formula are delimited by a first delimiter type if in a first context and wherein the references inserted into the formula are delimited by a second delimiter type if in a second context.02-12-2009
20130073939Grid Data Management - 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.03-21-2013
20130073938NETWORK-BASED DATA CONSOLIDATION, CALCULATION AND REPORTING ENGINE - 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.03-21-2013
20130073937NETWORK-BASED DATA CONSOLIDATION, CALCULATION AND REPORTING ENGINE - 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.03-21-2013
20130061121Extracting Semantics from Data - 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.03-07-2013
20120117453Computer Systems and Methods for Automatically Viewing Multidimensional Databases - 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.05-10-2012
20120117452Synthetic Navigation Elements for Electronic Documents - 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.05-10-2012
20130124959APPLICATION GENERATION APPARATUS, APPLICATION GENERATION METHOD, AND COMPUTER-READABLE RECORDING MEDIUM - The application generation apparatus of the present invention includes: determination means that determines whether a URL is input into a preset cell among a plurality of cells composing a spreadsheet displayed by executing spreadsheet software; and generation means that causes another terminal to acquire an HTML file based on URL information included in code information, and generates a parameter file for defining an application having a function of displaying a browser based on the HTML file, in a case in which the determination means determines that the URL is input.05-16-2013
20110035652Conditional Cell Execution in Electronic Spreadsheets - An improved electronic spreadsheet is provided for applications requiring conditional expression execution behavior. Each cell having an executable expression is cooperative with an implicit conditional execution wrapper. The execution of each cellular expression is implicitly conditioned on the state of an individually assigned logical switch expression. The improved electronic spreadsheet also includes a user interface by which a user can assign logical switch expressions to a cell, or to a range of cells. The improved electronic spreadsheet facilitates the use of spreadsheets for wider range of applications than was possible with conventional electronic spreadsheets.02-10-2011
20120192050REPRESENTATION OF PEOPLE IN A SPREADSHEET - 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.07-26-2012
20110283176Method and device for processing and analyzing data on a personal computer - 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.11-17-2011
20130185619VALUE-DRIVEN VISUALIZATION PRIMITIVES FOR TABULAR DATA OF SPREADSHEETS - A method for visually enhancing display of tabular data of an electronic spreadsheet is disclosed. The method includes obtaining at least one data value from the tabular data and computing a visual parameter responsive to the at least one data value. The visual parameter is a number within a range of numbers and is determined according to one or more of: a user-specified numerically calculated mathematical function, a user-specified visual effect, a user-specified range of visual effect variation, and a user-specified range of data value. The visual effect of at least a portion of the tabular data is controlled according to the visual parameter and rendered to visually supplement the display of the portion of the tabular data responsive to the value of the numerically calculated mathematical function. One or more variations of the visual effect are automatically calculating without requiring user input, responsive to the at least one data value.07-18-2013
20110289397Displaying Table Data in a Limited Display Area - 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.11-24-2011
20110289396Spreadsheet-Based Graphical User Interface for Dynamic System Modeling and Simulation - 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.11-24-2011
20090044090Referring to cells using header cell values - Referring to cells using header cell values is disclosed. In some embodiments, a header cell value of a header cell is allowed to be used to refer to one or more other cells that are associated with the header cell. The header cell may be included in a header row or column included in a table. A header row cell value may be employed to refer to one or more other cells in a corresponding column, and a header column cell value may be employed to refer to one or more other cells in a corresponding row.02-12-2009
20090031204Stakeholder Matrix - A system implementing a situation-oriented directory for retrieving a stakeholder identification includes a memory storing a relational database corresponding to the situation-oriented directory including a plurality of attribute-value combinations and a plurality of stakeholder identifications, wherein the plurality of attribute-value combinations are mapped to the plurality of stakeholder identifications such that for each attribute-value combination exactly one stakeholder is mapped, and a processor in communication with the memory for receiving a query and retrieving the stakeholder identification from among the plurality of stakeholder identifications based on the attribute-value combinations.01-29-2009
20100169757Filtering Method for Evaluating Patents - A filtering method for evaluating patents comprises loading each unit of text or figure in a portfolio of patents into digital memory then comparing each unit of text or figure with all other units of text or figures in digital memory using digital data processing. The duplicate units of text or figures are determined and the earliest instance of each duplicate unit of text or figure is identified. The duplicate unit of text or figure, other than earliest instance, are marked as duplicate to create a filtered version of each patent in portfolio. The filtered version of each patent in portfolio is evaluated to determine the uniqueness of the patent specification and the interrelationships between the patents in the portfolio are determined. The interrelationships are illustrated in an electronic workspace for analyzing the portfolio of patents.07-01-2010
20100083085SYSTEM AND METHOD FOR MANAGEMENT OF COMMON DECENTRALIZED APPLICATIONS DATA AND LOGIC - Enables a computer-assisted management of enterprise-network files of interest, and trouble-free migration of enterprise-wide business data and processes currently built and maintained in two popular tools, spreadsheets (commonly MICROSOFT® EXCEL®) and desktop/departmental databases (commonly MICROSOFT® ACCESS®). Includes: 04-01-2010
20100083080Whole table referencing - Whole table referencing without explicit cell ranges is disclosed. In some embodiments, an identifier associated with a table may be employed as a table reference that refers to at least all body cells of the table. In some embodiments, such an identifier remains a valid table reference that refers to at least all body cells of the table through table size variations.04-01-2010
20100083084CREATING ELECTRONIC DATA INTERCHANGE RELATIONSHIPS - Disclosed services, methods, systems, networks, and software media for facilitating the creation of data structures to enable a pair of enterprises to exchange documents such as business documents may enable a user to specify values for a set of parameters associated with an exchange of a business document between an entity and a trading partner and enable a user to invoke an envelope creation utility (ECU). When the user invokes the ECU, the specified set of parameter values and a set of one or more predefined business processes are accessed to create set of electronic document envelopes suitable for electronic transmission of a business document.04-01-2010
20110173525Monitoring and Tracking Application Usage - The present description refers to a computer-implemented method, a computer program product and a computer system for monitoring and tracking application usage, the method comprising: determining, during a first interval, a first indication of whether a first user has provided a first input. The method further comprising obtaining, during the first interval, a first identifier of an active window in a first graphical user interface (GUI), and selectively storing the first identifier and the first indication. For this purpose a specific tracking tool may be implemented on the computer on which the first graphical user interface is executed.07-14-2011
20090282324METHOD AND SYSTEM FOR AUTOMATICALLY GENERATING TEMPLATE BASED EXCEL PIVOTS FROM WEB ANALYTICS - For applications of web-based analytics and business intelligence reporting, methods and systems are provided for automatic creation of formatted Excel pivot tables with application specific initial views. The desired views are specified by templates and hence multiple pivot tables in a single Excel book is also allowed. Pivot tables are created by a remote server running the web analytic so that a user running the analytic can save the pre created Excel pivot table in his/her local machine. In one embodiment of the invention, the data table on which a pivot table is subject to the limitation of number of rows of an Excel data sheet and in another embodiment number of rows of data beyond that limit is allowed.11-12-2009
20120297281DOCUMENT ANALYSIS, COMMENTING, AND REPORTING SYSTEM - 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.11-22-2012
20080229184Private sheets in shared spreadsheets - Private sheets are disclosed, in shared computer applications, such as spreadsheets. In one aspect, a public sheet is accessible to a first client and a second client; and, moreover, a private sheet is accessible only to the second client. The private sheet is configured to access content in the public sheet, but the public sheet can't access content in the private sheet. In this way, users can use private sheets to perform calculations or modeling on the side, while collaborating on public sheets with other users. In another aspect, changes made to the public sheet can be reflected in the private sheet, if such changes are referenced by the private sheet to content in the public sheet. However, changes made to the private sheet are not reflected in the public sheet. Numerous other specific aspects are also disclosed, such as private sheets accessing values but not formulas from public sheets.09-18-2008
20080244377ADVANCED SPREADSHEET CELL NAVIGATION - 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.10-02-2008
20110271172TEMPORARY FORMATTING AND CHARTING OF SELECTED DATA - Selected data is temporarily formatted and charted to assist a user in visualizing the selected data without the user having to manually create the display of the charted data. Once the temporary formatting and charting is automatically applied to the selected data, a user may interact with the visual formatting and charts to gain additional information. For example, the chart may be formatted differently, reference lines may be added, the chart may be sorted, the type of chart(s) displayed may be changed, the user may graphically navigate over the chart to obtain more detailed information, and the like. Once the user has completed interacting with the temporarily formatted and created chart(s) the visualizations are removed from the display.11-03-2011
20110209042Information Technology Standard Inventory Utility - A method and system for automating the processes of organizing and analyzing client inventory data. Inventory data in a first worksheet format and user-defined mappings between columns in the first worksheet format and columns in a standard format worksheet are received from a client. The inventory data is organized by copying inventory data columns to corresponding mapped columns in the standard format worksheet. A first set of independent subroutines analyzes the organized data by standardizing text in the data and populating columns in the standard format worksheet with data derived from the inventory data. A second set of independent subroutines is applied to the analyzed inventory data to sort inventory assets listed in the standard format worksheet by asset type and determine a total count of types of assets. The sorted asset type data is displayed to a user.08-25-2011
20090187815USER INTERFACE METHOD AND APPARATUS FOR DATA FROM DATA CUBES AND PIVOT TABLES - 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.07-23-2009
20110231748System and Method for Rendering Data - A method of viewing information associated with data in a spreadsheet, includes providing a document including data and information associated with the data, parsing the document to retrieve the associated information, processing the associated information to break the associated information down into at least one sentence, categorizing the at least one sentence to determine whether the at least one sentence corresponds to at least one category in a taxonomy corresponding to the data, assigning an association strength to the categorized at least one sentence, the association strength indicating a likelihood that the categorized at least one sentence actually corresponds to the at least one category in the taxonomy, filtering the at least one categorized sentence based on the association strength to determine whether to match the categorized at least one sentence with the at least one category in the taxonomy and outputting only the categorized at least one sentence matched with the at least one category in the taxonomy.09-22-2011
20090164880Methods And Systems For Generating A Media Stream Expression For Association With A Cell Of An Electronic Spreadsheet - Methods and systems are described for generating a media stream expression for association with a cell of an electronic spreadsheet. In one embodiment, a method includes receiving a selection including at least one cell included in the electronic spreadsheet. The selection includes a plurality of media streams associated with the at least one cell. The method also includes presenting a graphical user interface including graphical objects presented in a first arrangement representing the plurality of media streams. The method further includes receiving input for manipulating at least one of the graphical objects for presenting the graphical objects in a second arrangement. The method also includes generating a media stream expression based on the second arrangement of graphical objects. The method further includes associating the media stream expression with a cell. The media stream expression for evaluation by the electronic spreadsheet to generate a resultant media stream.06-25-2009
20100169758Extracting Semantics from Data - 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.07-01-2010
20130219256SCROLLING IN LARGE HOSTED DATA SET - 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.08-22-2013
20110066933VALUE-DRIVEN VISUALIZATION PRIMITIVES FOR SPREADSHEETS, TABULAR DATA, AND ADVANCED SPREADSHEET VISUALIZATION - A method for visually enhancing the display of tabular data of an electronic spreadsheet is disclosed. The method includes obtaining data presented in at least one cell of the spreadsheet, computing at least one visual parameter based on the obtained data, using the at least one visual parameter to control a visual effect of the displayed data, and applying the at least one visual effect to the displayed data to visually enhance the displayed data. Each visual parameter is a number within a range of numbers and is determined according to a numerically calculated mathematical function. The visual enhancements include varying the background color or texture or border color, thickness, grouping scope of cells enveloping characters conveying data, as well as font color, type, embellishment, size, format, location, decimal places, rounding or supplemental symbols symbolic or image element rendered within the cell of characters conveying data.03-17-2011
20090113283METHOD FOR CAPTURING DESIGN-TIME AND RUN-TIME FORMULAS ASSOCIATED WITH A CELL - 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.04-30-2009
20090070662DOCUMENTS NOTATION TOOL AND METHOD - A computer-readable medium having computer executable components is disclosed, the components comprising a plurality of staff lines and intervening spaces adapted to display a plurality of documents positioned along the plurality of staffs and intervening spaces.03-12-2009
20130132811Graphical Surface Rendering Data Visualization Tools and Primitives for Tabular Data and Spreadsheets - Graphical tools and primitives are provided for visualization of graphical surfaces from tabular data such as in a spreadsheet. The invention can be used for simple business analysis as well as advanced engineering and science. Visualizations of a two-dimensional surface is rendered from provided data according to position, orientation, and viewpoint, some or all of which can be controlled by a user interface. The surface can also represent interactively controlled filtered or stochastically processed tabular data. The visualization can be displayed together with the display an electronic spreadsheet or other tabular data representation. The surface can suspended over a region of the displayed tabular data or displayed in other ways. The visually rendered surfaces can comprise symbols, colors, textures, or glyphs representing data, and virtual illumination. The surface can be suspended over a region of displayed tabular data. Visual height measuring and level sets slicing tools can be provided.05-23-2013
20130145245METHODS AND SYSTEMS FOR IMPLEMENTING A DYNAMIC HIERARCHICAL DATA VIEWER - 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.06-06-2013
20110029852METADATA CREATION - 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.02-03-2011
20130151939SMART MACROS USING ZONE SELECTION INFORMATION AND PATTERN DISCOVERY - A system and method for assisting a user to enter data are provided. The method includes detecting a user's selection of a moveable input zone on each of one or more input documents displayed on the user's screen and detecting a user's selection of a moveable target zone on a target document displayed on the user's screen. Data in the input zone(s) and the target zone is captured for one or more locations of the respective zones and a pattern is learned automatically for filling additional data in the target document based on the captured data. A fill arrangement for filling the additional data in the target document based on the learned pattern is generated, which can be presented to the user for validation.06-13-2013
20090063947Calendar and spreadsheet user interfaces - Displaying a calendar user interface is disclosed. An indication that a time period associated with a calendar bar in the calendar user interface has been edited is received. It is determined whether a date display element corresponding to a date in the time period in the calendar user interface is full. In the event that the date display element is full, all calendar bars associated with the date are modified.03-05-2009
20090313537MICRO BROWSER SPREADSHEET VIEWER - Various technologies and techniques are disclosed for displaying and managing spreadsheets on mobile devices. An optimized search can be performed. A selection is received from a user to open a spreadsheet. A find selection is received from the use along with keywords for which to the user wishes to search. Any matching keywords are found in the spreadsheet and the cell location of the keywords is retrieved. A results page is constructed that shows search result listings with the keywords along with data surrounding the one or more keywords. The results page is displayed. Navigation options are provided for allowing a user to navigate around the spreadsheet. Right, left, downward, and upward navigation options can be used to change the current view of the spreadsheet by a pre-defined number of cells. Techniques are described for optimizing the display of charts in the spreadsheet.12-17-2009
20100042912REMINDER AND NOTIFICATION SYSTEM FOR A PARENT - Disclosed is a web-based system for providing reminders to mothers for organizing life events. The system provides cues to mothers in a web based application which may be sent via email. The cues may include various checklists and spreadsheets customized to meet the needs of mothers. The system further includes a method of delivering target advertisements and a web-based community.02-18-2010
20110252299Synthetic Navigation Elements for Electronic Documents - 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 on 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.10-13-2011
20120151315USING TEXT MESSAGES TO INTERACT WITH SPREADSHEETS - 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.06-14-2012
20110258525System, method, and computer software for linked window interfaces - Systems, methods, and computer program products are described for providing a graphical user interface (GUI) that may include a first openable window of image features constituting, for example, a pseudo-image of a scanned probe array. The image features each have one or more characteristics representing one or more hybridization reactions associated with a probe of the probe array. The GUI also has a second openable window including data features, each relating to one or more quantifications of one or more hybridization reactions associated with a probe of the probe array. This second window may be, for example, a scatter plot of hybridization intensities of probes to two or more labeled samples. The GUI further includes a third openable window including descriptive features such as rows of a spreadsheet. Each row may include descriptive elements associated with a probe. When a user selects a feature from any of the two or more windows, a corresponding feature in at least one other of the two or more windows is highlighted.10-20-2011
20090106640Scorecard Interface Editor - A user interface is programmed to create a scorecard. The interface includes a scorecard module including a column area and a row area, and a key performance indicator area including a plurality of key performance indicators. A key performance indicator from the key performance indicator area can be dragged and dropped onto one of the column area and the row area to add indicia associated with the key performance indicator to the scorecard.04-23-2009
20080256432System and Method of Defining a Hierarchical Datamodel and Related Computation and Instruction Rules Using Spreadsheet Like User Interface - The present invention relates to the field of information processing involving digital computers, embedded devices and more particularly, to a method and system for defining hierarchical data model and related computation and instructions rules using electronic spreadsheet like interface. The system and method of the invention arc directed to user friendly, fast, development of multi-user, workflow enabled applications using spreadsheet as a tool for application modeling.10-16-2008
20110055680SYSTEMS AND METHODS FOR GENERATING A SET OF LINKED ROTATIONAL VIEWS OF MODEL OBJECTS - Embodiments relate to systems and methods for generating a set of linked rotational views of a model object. A modeling client can host modeling logic and an application programming interface (API) to create, access, manipulate, and import/export modeling objects used in modeling applications, such as engineering, medical, financial, and other modeling platforms. The source data accepted into the modeling client can include consumer or business-level applications, whose spreadsheet, database or other content can be extracted and encapsulated in object-oriented format, such as extensible markup language (XML) format. A set of layers of the model objects can be associated via a set of linkages. A rotator widget or other interface object can be presented to allow a user to traverse the linkages and rapidly rotate through layers in a view, without having to switch tabs, planes, database dimensions, or manually operate other dimensional control, enhancing viewing efficiency of large layers.03-03-2011
20120151316System and Method for the Comparison of Content Within Tables Separate from Form and Structure - 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.06-14-2012
20100115391METHOD AND SYSTEM FOR ASSIGNING SCREEN DESIGNATION CODES - A method and system for assigning screen designation codes is disclosed. A method of assigning screen designation codes includes assigning a first screen designation code to a first spreadsheet object, wherein the first screen designation code is associated with a first display screen of a multi-component display. A second screen designation code is assigned to a second spreadsheet object, wherein the second screen designation code is associated with a second display screen of the multi-component display. The first and second screen designation codes are operable to implement a simultaneous display of the first spreadsheet object on the first display screen and the second spreadsheet object on the second display screen.05-06-2010
20100083083Compressed table format - In some embodiments, the cell content portion of a table definition of a table of cells is specified in a prescribed order such that cell positions do not have to be explicitly specified with cell definitions in the cell content portion of the table definition. The cells of the table to which one or more entries in the cell content portion correspond to are inferred from the prescribed order in which the entries are specified.04-01-2010
20130013993SPREADSHEET-BASED TEMPLATES FOR SUPPORTING THE SYSTEMS ENGINEERING PROCESS - 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.01-10-2013
20100083079Formula display and search - In some embodiments, a spreadsheet application provides an option for collectively displaying the formulas associated with a set of cells in a separate view. In some embodiments, the view provides an option to search within the formulas (and/or other content) provided by the view. In some embodiments, a find and replace user interface of a spreadsheet application includes an option to search only in formulas.04-01-2010
20110307771METHOD FOR GENERATING FINANCIAL REPORT - 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 selecting the report template in the report template selection module is detected. The method of the present invention is easy to operate and use.12-15-2011
20090172514METHOD AND SYSTEM FOR SEARCHING TEXT-CONTAINING DOCUMENTS - The invention relates to a method of presenting search results generated by a search engine, and a search report, in which individual search results are arranged into separate cells of a table with at least 2 columns.07-02-2009
20100115390AMENDING THE DISPLAY PROPERTY OF GRID ELEMENTS - The present invention relates to a method and system for amending a display property of a grid element. The method for amending a display property of a grid element comprises: receiving a command to amend the display property of at least one grid element; searching grid elements associated with said grid element; amending the display property of said grid elements and said associated grid elements. The present invention improves the operation of adjusting the display property of the grid, and enhances the operational efficiency and feasibility05-06-2010
20120159297SYSTEM AND METHOD FOR GENERATING A PIVOT TABLE - 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.06-21-2012
20110072339CHEMICAL WEB BROWSER - The present invention relates to a system, method and program product for a chemical web browser. A chemical web browser including a document system for accessing a document containing at least one chemical name is provided. A chemical annotation system identifies the at least one chemical name within the document. A chemical formulae conversion system associates a chemical structure with the identified chemical name. The chemical structure is displayed.03-24-2011
20110107195SYSTEM AND METHOD FOR MANAGING A SPREADSHEET - A system and method for managing a spreadsheet are disclosed. The method may include determining a portion of a digital image of a data statement, determining data of the data statement based on the portion of the digital image, and mapping a data cell of a standardized spreadsheet to the portion of the digital image based on the data of the data statement. The data of the data statement may be determined by applying an optical character recognition process to the digital image. The data cell may be mapped to the portion of the digital image based on a label or key included in the data of the data statement, a set of coordinate values, a mathematical equation, and/or the like. The method may further include determining a location of a second data statement based on the mapping data.05-05-2011
20120124460System and Method for Allocating, Scheduling, Tracking and Reporting Usage of Training Assets and Facilities - 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.05-17-2012
20100251089DETERMINING AN OBJECT LOCATION RELATIVE TO A DIGITAL DOCUMENT - Systems and methods for determining an object location relative to a digital document are disclosed herein. A marking is applied to at least one cell in at least one row and to at least one cell in at least one column of a digital document. The markings define an axis system for the digital document. Each object has a stored digital address within the digital document. When the digital document is converted into a fixed file format, a location of the object can be determined that will match the location of the object on the printed page. By comparing the digital address of the object to the axis system defined by the markings, after the document has been converted to a fixed document format, the location of the object is defined spatially.09-30-2010
20120166927Creating Cross-Tabular Reports - 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.06-28-2012
20120216104SYSTEM AND METHOD FOR PREPARING EXCEL(TM)-BASED ANALYSIS REPORTS - 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.08-23-2012
20120216103PRIVATE VIEWS OF DATA AND LOCAL CALCULATIONS DURING REAL TIME COLLABORATION - 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.08-23-2012
20100205520GRID PRESENTATION IN WEB-BASED SPREADSHEET SERVICES - Users are enabled to navigate a spreadsheet document presented by a web service in a similar fashion to a locally executed spreadsheet application by retrieving blocks of grid data asynchronously in order to display or refresh the area(s) of the spreadsheet currently being viewed by the user as the user navigates the spreadsheet grid or dynamic updates occur. The blocks are laid out in the browser's user interface to fill the user's viewport as well as a predefined buffer around the edge of the viewport. As such, when the user scrolls or updates occur, data associated with blocks are added, updated, or removed in the browser as required to fill the user's viewport.08-12-2010
20120179956Structured domain specific language and grid valued machine for creating spreadsheets and numerical plans - 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.07-12-2012
20120221933METHOD AND SYSTEM TO BUILD INTERACTIVE DOCUMENTS - 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.08-30-2012
20100306637METHODS AND SYSTEMS FOR AUTOMATED CELL DESIGN IN A PRODUCTION ENVIRONMENT - A system for designing cells in a document production environment may include a computing device and a computer-readable medium in communication with the computing device. The computer-readable medium may include one or more programming instructions for identifying a plurality of jobs associated with the document production environment. Each job may include one or more functions. The computer-readable medium may include one or more programming instructions for generating a representation for each unique job, creating one or more workflows, assigning the workflow to one of a plurality of cells, determining whether one or more of the cells is complex, and splitting at least one workflow within a complex cell. Each cell may include one or more devices.12-02-2010
20120233533CONSTRUCTING AND APPLYING A CONSTRAINT-CHOICE-ACTION MATRIX FOR DECISION MAKING - 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.09-13-2012
20110041048DEMONSTRATION TOOL FOR A BUSINESS INFORMATION ENTERPRISE SYSTEM - According to some embodiments, demonstration data is received via a front-end application associated with a business information enterprise system. The demonstration data may then be interpreted in accordance with at least one rule to generate business data. A query may be received at a back-end application associated with the business information enterprise system. At least a portion of the business data may then be presented in accordance with the received query.02-17-2011
20110276867DATA MINING AND REPORTING - An integrated system is described that allows a user to easily mine and report data maintained by a customer relationship management (CRM) application. In general, the system automates the process of creating electronic reports, such as an electronic worksheet, in a format that can be directly manipulated and viewed from spreadsheet application. In one embodiment, the report is automatically generated to include a pivot table for displaying the data. The system includes a database adapted to store the CRM data. First and second reporting modules execute within the CRM software application and the worksheet software application, respectively. The reporting modules cooperate in order to integrate CRM application and spreadsheet application, thereby automating the process of generating a worksheet based on the CRM database.11-10-2011
20110307772Scrolling in Large Hosted Data Set - 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.12-15-2011
20120151314LOCATION AWARE SPREADSHEET ACTIONS - 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.06-14-2012
20130019153Architecture to Expose Internal Business Data on a Website - 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.01-17-2013
20130024760Personalized Dashboard Architecture - 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.01-24-2013
20130174003System For Combining Datasets And Information Structures By Intercalation - A system for working with data in datasets or information structures, wherein at least some of the data has latent preferences for connection with the data in other datasets or information structures. The data for each of the datasets or information structures is stored into a slice of separable cells having actual connections forming independent relational orderings in one or more dimensions. The cells in each slice are then examined for the latent preferences and the cells having data seeking connection is identified as choosing cells and the cells sought to be connected to are identified as target cells. A latent connection is then added to either the choosing cell or the target cell for each of the latent preferences, thus preparing the slices for potential expression into one or more conglomerate structures.07-04-2013
20080222510METHOD AND SYSTEM FOR GENERATING A HISTORY LOG ASSOCIATED WITH A SPREADSHEET - In one embodiment, the invention provides a method comprising monitoring for activity relating to a spreadsheet; for each activity detected, generating an entry in a history log for the spreadsheet.09-11-2008
20080222509METHOD AND SYSTEM FOR CONVERTING A SOURCE SPREADSHEET TO A TARGET SPREADSHEET - In one embodiment, the invention provides a method, comprising: receiving a source spreadsheet; receiving a target spreadsheet; generating a mapping to transform the source spreadsheet into the target spreadsheet; and saving the mapping.09-11-2008
20080222508METHOD AND SYSTEM FOR COMPARING SPREADSHEETS - In one embodiment, the invention provides a method comprising receiving user-input selecting two spreadsheets; receiving user-input comprising a basis for a comparison between the two spreadsheets; performing a comparison between the two spreadsheets in accordance with the basis and displaying a result of the comparison.09-11-2008
20080222507METHOD AND SYSTEM FOR DECOMPOSING A SPREADSHEET - In one embodiment, the invention provides a method comprising receiving at least one spreadsheet file corresponding to a spreadsheet having at least one constituent spreadsheet object, the spreadsheet file being encoded in a file format capable of being rendered by a spreadsheet program; decomposing the at least one spreadsheet file into its constituent spreadsheet objects; and saving the spreadsheet objects in a database as database objects.09-11-2008
20130179765TEMPLATE BASED FILTERING AND SUMMATIONS FLOW SHEET - Systems and methods are disclosed to provide a moveable summary column and/or row for an electronic medical flow sheet. The summary column and/or row can provide various summations of the patient's data records for any time period depending on where the moveable summation column and/or row is placed. The summation of the various patient data depends on a selected type of patient data. The summary column and/or row can be moved by the user to any spot in the patient data portion of the medical flow sheet to sum up different intervals of data. The moveable summation column and/or row presents summary data for patient parameters depending on the placement of the summation column and/or row.07-11-2013
20130104019Systems and Methods For Generating A Two-Dimensional Graphical Grid Representation Of The Treatment Of A Document - Systems and methods for generating a two-dimensional graphical grid representation of the treatment of a document are disclosed. A method includes receiving a request to generate the two-dimensional graphical grid representation of the treatment of the document with respect to at least one variable. In response to the received request, the method further includes retrieving, by a computer, treatment information associated with the document with respect to the at least one variable from a database. The method further includes generating a message containing the retrieved treatment information of the document with respect to the at least one variable, transmitting the generated message, and providing for display the two-dimensional graphical grid representation of the treatment of the document with respect to the at least one variable based on the transmitted message.04-25-2013
20130124957STRUCTURED MODELING OF DATA IN A SPREADSHEET - Data displayed on a spreadsheet and data from one or more data sources are used to create a model within the spreadsheet. The data may be obtained from many types of data sources, such as: relational databases, multidimensional sources, cloud services, data feeds, spreadsheet files, text files, data from the Web, and the like. A modeling engine of the spreadsheet application creates the model that structures the data, relates different pieces of data, and provides context for the data. The model that may be stored within the spreadsheet includes the raw data and metadata that describes the data and provides the context for the data. The model may be automatically updated based on performed operations of the spreadsheet. The model may be examined using a query language (e.g. MDX, DAX, SQL, Spreadsheet Functions and Formulas, . . . ) to examine the data and the relationships obtained from the spreadsheet and data sources.05-16-2013
20130124958ENRICHMENT OF DATA USING A SEMANTIC AUTO-DISCOVERY OF REFERENCE AND VISUAL DATA - Methods, systems, and computer program products are provided for automatically enriching data in tables of report documents. A table of data contained in a document is received. A category of data stored in a column of the table of data is determined Enhancement information associated with the determined category is retrieved. The enhancement information may include visual enhancements (e.g., symbols, images, etc.) and/or may include reference data that is related to the determined category of column data. A user is enabled to select enhancement information of the retrieved enhancement information. The selected enhancement information is displayed in the document. The user is enabled to accept the selected enhancement information to be stored in the document.05-16-2013
20130145244QUICK ANALYSIS TOOL FOR SPREADSHEET APPLICATION PROGRAMS - A quick analysis tool is configured to present one or more data analysis features that are tailored to the data in a selected portion of a spreadsheet document. The quick analysis tool may provide a quick analysis tool entry button, the selection of which causes a contextual user interface to be displayed. The contextual user interface facilitates a user to easily access one or more data analysis features. The quick analysis tool also provides a mechanism by which a user can preview and/or apply one or more of these data analysis features while bypassing the potentially steep learning curve and traditionally high barrier of entry for new or otherwise less advanced users of the spreadsheet application. Intermediate or otherwise more advanced users of the spreadsheet application will also benefit from the quick analysis tool because of improved efficiency for applying data analysis features to data within a spreadsheet document.06-06-2013
20110219292CONTEXT SENSITIVE DELIMITER INSERTION WHEN ADDING REFERENCES - Context sensitive delimiter insertion when adding references is disclosed. In some embodiments, a plurality of indications of selections of a cell or cell range while in a formula editing mode in a host cell into which a formula is being entered is successively received, and in response to receiving each indication of selection of the plurality a reference to the selected cell or cell range is successively inserted into the formula, wherein the references inserted into the formula are delimited by a first delimiter type if in a first context and wherein the references inserted into the formula are delimited by a second delimiter type if in a second context.09-08-2011
20110225484Cloud based modeling for enhancing spreadsheets - A method and development tool for developing an application over a spreadsheet, the development tool comprising design components for designing a user interface element, a logic-related element that consumes a service from the spreadsheets. and a connector connecting the user interface element and the logic-related element; a communication component; code generation components for generating code associated with the user interface element, code associated with the logic-related element, code associated with the connector, and code associated with communication; and a deployment component for deploying an application based on the code. The method and development tool enable the creation of applications over a spreadsheet, the applications comprising both user interface and business logic. The application can be executed as a web service, and also in a cloud computing environment.09-15-2011
20090083613Reusable data markup language - Methods and systems provide a computer markup language, referred to as Reusable Data Markup Language (“RDML”), and a data viewer for retrieving, manipulating and viewing documents and files in the RDML format that may be stored locally or over a network (e.g., the Internet). Generally, RDML permits the browsing and manipulation of numbers, as opposed to text and images like in HTML, and does so by including attributes describing the meaning of the numbers to be attached to the numbers. Documents compliant with the markup language encapsulate machine-readable documentation with numbers and data, and permit the data viewer to act as a combination web browser and spreadsheet to automatically read, interpret and manipulate the numbers and data.03-26-2009
20100318890Architecture to Expose Internal Business Data on a Website - 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.12-16-2010
20100318889Automatic Insertion of Data from Web Forms into Documents - A host computing system automatically inserts data submitted from web forms into documents. The host computing system stores a document file comprising data that represents a document. The document comprises at least one document element. The host computing system receives a block of web form data. The block of web form data comprises a value assigned to a web form element in a web form. In response to receiving the block of web form data, the host computing system automatically updates the document element to specify the value when the document file comprises element mapping metadata that maps the document element to the web form element.12-16-2010
20120284600PREDICTIVE MODEL APPLICATION PROGRAMMING INTERFACE - Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for utilizing predictive models from an application scripting language.11-08-2012
20110314364GENERATING FINANCIAL DATA DOCUMENTS USING TEMPLATES - 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.12-22-2011
20130191712Surface-Surface Graphical Intersection Tools and Primitives for Data Visualization, Tabular Data, and Advanced Spreadsheets - Graphical tools and primitives are provided for interactively intersecting graphical surfaces in a spreadsheet or visualization to produce surface intersection data. The invention can be used for simple business analysis as well as advanced engineering and science, and provide numerical solution for simultaneous spatially-manipulated interactive equations.07-25-2013
20120030555 SYSTEM AND METHOD FOR PROVIDING DYNAMIC NORMALIZATION OF TERMINAL SOURCE EXCEL FILES - 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.02-02-2012
20120066578ATTRIBUTE VALUE MANAGEMENT SYSTEM AND METHODS - 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.03-15-2012

Patent applications in class Spreadsheet

Patent applications in all subclasses Spreadsheet