Entries |
Document | Title | Date |
20080222507 | METHOD 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 |
20080222508 | METHOD 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 |
20080222509 | METHOD 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 |
20080222510 | METHOD 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 |
20080229184 | Private 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 |
20080244377 | ADVANCED 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 |
20080256432 | System 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 |
20090031204 | Stakeholder 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 |
20090044088 | Context 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 |
20090044089 | Automatic 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 |
20090044090 | Referring 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 |
20090044091 | Reference 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 |
20090063947 | Calendar 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 |
20090070662 | DOCUMENTS 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 |
20090083613 | Reusable 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 |
20090106640 | Scorecard 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 |
20090113283 | METHOD 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 |
20090164880 | Methods 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 |
20090172514 | METHOD 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 |
20090187815 | USER 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 |
20090282324 | METHOD 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 |
20090313537 | MICRO 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 |
20100042912 | REMINDER 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 |
20100083079 | Formula 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 |
20100083080 | Whole 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 |
20100083081 | Multi-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 |
20100083082 | Locking 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 |
20100083083 | Compressed 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 |
20100083084 | CREATING 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 |
20100083085 | SYSTEM 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 |
20100095195 | Defining 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 |
20100100801 | Router / 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 |
20100115390 | AMENDING 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 feasibility | 05-06-2010 |
20100115391 | METHOD 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 |
20100169757 | Filtering 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 |
20100169758 | Extracting 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 |
20100205520 | GRID 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 |
20100251089 | DETERMINING 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 |
20100306637 | METHODS 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 |
20100318889 | Automatic 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 |
20100318890 | Architecture 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 |
20110029852 | METADATA 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 |
20110035652 | Conditional 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 |
20110041048 | DEMONSTRATION 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 |
20110055680 | SYSTEMS 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 |
20110066933 | VALUE-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 |
20110072339 | CHEMICAL 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 |
20110107195 | SYSTEM 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 |
20110173525 | Monitoring 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 |
20110197117 | SYSTEMS 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 |
20110209042 | Information 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 |
20110219292 | CONTEXT 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 |
20110225484 | Cloud 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 |
20110231748 | System 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 |
20110252299 | Synthetic 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 |
20110258525 | System, 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 |
20110271172 | TEMPORARY 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 |
20110276867 | DATA 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 |
20110283176 | Method 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 |
20110289396 | Spreadsheet-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 |
20110289397 | Displaying 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 |
20110307771 | METHOD 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 |
20110307772 | Scrolling 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 |
20110314364 | GENERATING 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 |
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 |
20120066578 | ATTRIBUTE 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 |
20120117452 | Synthetic 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 |
20120117453 | Computer 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 |
20120124460 | System 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 |
20120151314 | LOCATION 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 |
20120151315 | USING 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 |
20120151316 | System 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 |
20120159297 | SYSTEM 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 |
20120166927 | Creating 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 |
20120179956 | Structured 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 |
20120192050 | REPRESENTATION 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 |
20120216103 | PRIVATE 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 |
20120216104 | SYSTEM 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 |
20120221933 | METHOD 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 |
20120233533 | CONSTRUCTING 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 |
20120284600 | PREDICTIVE 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 |
20120297281 | DOCUMENT 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 |
20130007583 | COMPARATIVE AND ANALYTIC LENS - 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. | 01-03-2013 |
20130013993 | SPREADSHEET-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 |
20130019153 | Architecture 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 |
20130024760 | Personalized 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 |
20130055057 | PROVIDING SPREADSHEET FEATURES - 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. | 02-28-2013 |
20130061121 | Extracting 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 |
20130073937 | NETWORK-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 |
20130073938 | NETWORK-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 |
20130073939 | Grid 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 |
20130086459 | Automatic 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 |
20130086460 | Automatic 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 |
20130104019 | Systems 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 |
20130111320 | SLICER ELEMENTS FOR FILTERING TABULAR DATA | 05-02-2013 |
20130117648 | SPREADSHEET DATA PROCESSING METHOD AND SYSTEM - A Method carried out in a computer system including a spreadsheet file having a sheet with lines and columns, wherein columns represent fields, the sheet having a header portion having a designation line with a field designation for each column, a data portion, wherein each line includes a record, the method including: | 05-09-2013 |
20130117649 | REPORT DATA JUSTIFIERS - A method includes providing a source report for display that includes a first plurality of data values each associated with a first context, the first context comprising an intersection of dimensions of a multidimensional database. The method includes receiving a selection of a first data value of the first plurality, and providing a drill-through report for display generated based at least in part on the selected data value. The drill-through report includes a second plurality of data values each associated with a second context comprising an intersection of at least one dimension of the first context and at least one other dimension not in the first context. The method includes receiving an indication of a relationship between the selected data value and the drill-through report, updating the source report to include a graphical representation of the relationship, and providing the updated source report having the graphical representation for display. | 05-09-2013 |
20130124957 | STRUCTURED 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 |
20130124958 | ENRICHMENT 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 |
20130124959 | APPLICATION 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 |
20130132811 | Graphical 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 |
20130145244 | QUICK 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 |
20130145245 | METHODS 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 |
20130151939 | SMART 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 |
20130174003 | System 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 |
20130179765 | TEMPLATE 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 |
20130185619 | VALUE-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 |
20130191712 | Surface-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 |
20130219256 | SCROLLING 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 |
20130254644 | COLLABORATIVE ONLINE SPREADSHEET APPLICATION - A distributed spreadsheet application executes at a server and a client in a network. The networked spreadsheet application can generally be used without requiring a user to install any specific spreadsheet software prior to using the application. In one implementation, the spreadsheet application may include a client engine that executes within browser programs of a plurality of client computing devices and server logic. The server logic may be configured to distribute the client engines to the plurality of client computing devices of the spreadsheet application when requested through the browser programs of each of the plurality of client computing devices. The server logic synchronizes a single spreadsheet document that is simultaneously open at the plurality of client computing devices. | 09-26-2013 |
20130290822 | SPREADSHEET-BASED PROGRAMMING LANGUAGE ADAPTED FOR REPORT GENERATION - Computer-based systems, software, and methods for implementing a spreadsheet-based programming language adapted for report generation, said system comprising: an optionally networked computer comprising a processor, an operating system configured to perform executable instructions, and a memory device; a computer program including instructions executable by the digital processing device to create an environment to implement a spreadsheet-based programming language for report generation, wherein said environment comprises: a software module for storing the structure of one or more designated, external datasets within a spreadsheet, wherein references to each dataset are created through cell-based formulas; a software module to interpret procedural functions, wherein procedural functions are designated via tags in a report design template; and a software module for generating reports. | 10-31-2013 |
20130311864 | Intelligent and robust context based XML data parsing from spreadsheets - This invention is for a method to make sense of XML (Extensible Markable Language) data when it is imported into spreadsheets without the use of a stylesheet and to accurately capture that data automatically into the appropriate fields. When it is imported into spreadsheets without a stylesheet, the rows and columns are unspecifiable, and even for similar XML files having different sets of data, the rows and columns may not always correspond exactly, as it would with form data where each data field always has a place holder. The method developed by this claim uniquely addresses the issue of absorbing this data by cross indexing all descendant elements and attributes pillared around a mandatory element and attribute for one direction, and keeping an open spring like data sensing mechanism in the vertical direction, with resulting data read being instantly captured accurately, associated with the proper data field and validated. | 11-21-2013 |
20130332809 | WINE CLASSIFICATION SYSTEMS AND METHODS OF DISPLAYING WINES - Disclosed are systems for and methods of categorizing wines, recommending sipping wines, pairing wines with foods, and arranging wines in a systematic display. In some embodiments, the disclosed systems and methods evaluate and incorporate individual taste profiles. Defining a set of wine flavor characteristics facilitates comparisons and categorization. Recommendations are facilitated by substantially correlating the individual taste profiles to the wine flavor characteristics. Likewise, wine-food pairings are facilitated by substantially correlating the known food flavors to the wine flavor characteristics. Computer-implemented embodiments allow authorized user input and consumer access via wireless devices. | 12-12-2013 |
20130332810 | MANAGING OBJECTS IN PANORAMA DISPLAY TO NAVIGATE SPREADSHEET - A panorama display application shows objects from a spreadsheet such as charts in primary screen of a mobile device adjoined by left and right virtual screens. The application overlays interaction controls such as sort and filter functions on the object. The application also provides additional interaction controls for the object on the left virtual screen and associated objects links on the right virtual screen. The application may expose the additional interaction controls and the associated objects links by overlaying portions of the virtual screens on the primary screen. The application fluidly shifts content from virtual screens to the primary screen subsequent to detected user action on the overlaid portions. | 12-12-2013 |
20130346843 | DISPLAYING DOCUMENTS BASED ON AUTHOR PREFERENCES - An author of a document may be enabled to specify viewing preferences for displaying a document in a reading view. The author may be enabled to define or select among available options for document viewing preferences such as transitions, animations, display of selected elements, layout features, embedded objects, and comparable ones. A reader of the document may be enabled to specify similar viewing preferences on their end. The author's preferences may also include customization of viewing rules based on a device, application, or version of application through which the document is viewed. In case of conflict between the author's and reader's preferences, one may prevail depending on permission levels and similar attributes. | 12-26-2013 |
20140033009 | METHOD AND SYSTEM FOR CONDITIONALLY TRANSMITTING CHANGES TO INFORMATION IN A COLLABORATIVE ENVIRONMENT - Method and system for conditionally transmitting changes to information in a collaborative environment are provided. A system comprises a display, a change tracking module, and a rendering module. The change tracking module is configured to detect changes by a modifying user to information as a propagating or a non-propagating change. The rendering module transmits first view data to enable altering a first view based on the modification as part of a graphical user interface on the display presented to the modifying user and transmits second view data to enable altering a second view presented to a group of users, not including the modifying user, based on the modification if the modification comprises the propagating change. The second view data is not transmitted if the modification comprises the non-propagating change. | 01-30-2014 |
20140047312 | Displaying Temporal Information in a Spreadsheet Application - Concepts and technologies are described herein for displaying temporal information in a spreadsheet application. In accordance with the concepts and technologies disclosed herein, spreadsheet data can be obtained at a computer system. The spreadsheet data can include data values, temporal information, and geographic information. The computer system can generate a visualization of the spreadsheet data based, at least partially, upon the data values, the temporal information, and the geographic location information. The computer system also can output the visualization. | 02-13-2014 |
20140059412 | USER INTERFACE FOR CREATING A SPREADSHEET DATA SUMMARY TABLE - A graphical user interface for creating a data summary table includes a field pane including a list of a plurality of fields, and a layout pane including a plurality of zones. The zones represent areas of the data summary table, and the layout pane allows a field of the plurality of fields from the field pane to be added to a first zone of the zones. A data summary table is updated upon the field being added to the layout pane. | 02-27-2014 |
20140059413 | APPLICATION MODULE FOR MANAGING JOBS ASYNCHRONOUSLY - A method to synchronize data between a spreadsheet application and a marketplace application is disclosed. The method includes receiving a request to synchronize data items between the spreadsheet application and the marketplace application, the data items relating to a type of listing of items associated with the marketplace application. Additionally, the method includes executing a process to synchronize the data items between the spreadsheet application and the marketplace application, the process to include at least one of downloading one of the data items from the spreadsheet application and uploading one of the plurality of data items to the marketplace application, the executing of the process to occur independently of the executing of the spreadsheet application. Furthermore, the method includes displaying a status of the executing of the process in a native user interface element of the spreadsheet application. | 02-27-2014 |
20140068403 | CELL VIEW MODE FOR OUTSIZED CELLS - Embodiments provide electronic spreadsheet viewing and interaction features and functionalities, but the embodiments are not so limited. In an embodiment, a computer-implemented method can be configured to provide a cell view launch indicator or interface that alerts a user that a selected cell includes additional content not being currently displayed. The cell view launch indicator can be activated and use a cell view mode to launch a separately controllable cell view window or portion. Other embodiments are included. | 03-06-2014 |
20140075278 | SPREADSHEET SCHEMA EXTRACTION - Aspects of the present invention provide a tool for extracting schema from a spreadsheet. In an embodiment, a set of data that is stored in an uncataloged tabular format, such as a spreadsheet, is retrieved. The structure of the retrieved set of data is surveyed to determine the dataset schema thereof. Then, data elements within the dataset schema are analyzed to obtain information regarding the data elements. Based on dataset schema and the element information, an interface can be constructed that allows remote access to the set of data. | 03-13-2014 |
20140108903 | METHODS AND SYSTEMS FOR CORPORATE PERFORMANCE MANAGEMENT - A computing module and method for corporate performance management (CPM) is disclosed. A spreadsheet is determined for inclusion in a CPM software application. Dimensional members associated with the spreadsheet are captured, and hierarchies associated with the spreadsheet based on the captured dimensional members and formulas in the spreadsheet are determined. A spreadsheet template associated with the spreadsheet is determined and data from the spreadsheet is obtained. The spreadsheet template, dimensional members, hierarchies, and data are then published into the CPM software application. | 04-17-2014 |
20140122986 | TEXT IMPORT TOOL FOR A TECHNICAL COMPUTING ENVIRONMENT - A device receives text that includes data values, and parses the text to identify data types associated with the data values. The device generates, based on the data values and the data types, a graphical representation of the text that includes data cells corresponding to the data values, and provides the graphical representation for display. The device receives one or more selections of one or more data cells in the graphical representation, stores the one or more selections as a selection history, and provides the selection history for display. | 05-01-2014 |
20140136936 | SPREADSHEET FUNCTIONS TO CALL REST API SOURCES - Spreadsheet functions are provided that enable interactivity with web services and manipulation of data retrieved from a web service call. One function takes a URL as an argument and performs an HTTP GET request asynchronously to return the response into the spreadsheet application. Another function URL encodes its argument. The URL encoded argument can then be used as part of the URL of the web service call. Yet another function is a filtering function that takes XML, JSON, HTML, and other forms of data that may be returned via a web service call to obtain specific data such as via an XPath standard when XML is used. These functions may be used together or separately. | 05-15-2014 |
20140136937 | PROVIDING AND PROCURING WORKSHEET FUNCTIONS THROUGH AN ONLINE MARKETPLACE - Methods and systems are provided for procuring functions, including Web service functions, for use in a spreadsheet application. A Web service function manifest can be managed by a function marketplace. A client device running a spreadsheet application can request available functions from the function marketplace. Information about available functions can be received by the client device. A selection of a function can be made in order to receive the manifest associated with the selected function. A local copy of the manifest may be stored for repeated invocation. | 05-15-2014 |
20140136938 | LIST MANAGEMENT IN A DOCUMENT MANAGEMENT SYSTEM - A document management system includes a list management application that manages one or more lists stored by the document management system. The list management application exposes list management functionality to users that access the lists in the document management system. The lists are stored as list management application files. | 05-15-2014 |
20140149836 | Dashboard Visualizations Using Web Technologies - Dashboard files such as dashboard structure files and spreadsheet files are converted into text-based, language-independent data interchange format files (such as JSON files) to allow dashboards to be rendered using varying web technologies such as HTML5 and JavaScript. Related apparatus, systems, techniques and articles are also described. | 05-29-2014 |
20140149837 | Spreadsheet Cell Dependency Management - A spreadsheet file and a dashboard structure file characterizing a dashboard are received. These files are then analyzed to determine dependencies. Subsequently, for each determined dependency, an event listener is registered for a dependent component that corresponds to the determined dependency. These event listeners are notified of an event from an event source when a corresponding dependee is changed. Dependent components are then updated using data from a corresponding dependee in response to event notifications so that each updated dependent component can be rendered within the dashboard. Related apparatus, systems, techniques and articles are also described. | 05-29-2014 |
20140164895 | SYSTEMS AND METHODS FOR MANAGING SPREADSHEET MODELS - A method and computing device for managing models. The method and computing device receive a spreadsheet model, receive template management instructions on how to manage evaluations, create, from the spreadsheet model and the template management instructions, a model template, and deploy, in response to user action, an instance of the model template into a model relationship structure relating one or more spreadsheet model instances. | 06-12-2014 |
20140173400 | DYNAMIC FUNCTION BUILDER - Systems and techniques are disclosed for dynamically generating functions. The systems and techniques may be utilized to access and display information from a data store accessible to a spreadsheet-based application or program over a network. A web service is also provided that interprets data requests received from the spreadsheet-based application or program in one format, such as a natural language format, and translates the requests into syntactically correct functions with parameters for automatic execution by the spreadsheet-based application or program. | 06-19-2014 |
20140173401 | Management Data Processing System and Method - A data management system operating within a third-party spreadsheet application environment includes a plurality of template worksheets within the third-party spreadsheet application. The plurality of template worksheets comprise at least a dashboard interface worksheet, and at least one settings interface, generated by at least one processor, comprising at least one worksheet within the third-party spreadsheet application. The at least one settings interface further comprising a plurality of selectable settings options configured to modify at least one parameter of the dashboard interface worksheet, wherein the dashboard interface worksheet comprises a plurality of selectable dashboard options comprising at least one of the following: a choose columns to display option, an insert contact option, a delete contact option, a sort ascending option, a sort descending option, a hide averages option, a hide totals option, an import contacts option, an export contacts option, and/or a clear sorting option. | 06-19-2014 |
20140189482 | METHOD FOR MANIPULATING TABLES ON AN INTERACTIVE INPUT SYSTEM AND INTERACTIVE INPUT SYSTEM EXECUTING THE METHOD - A method is provide for manipulating a table comprising a plurality of cells, at least one row header and at least one column header. Input events representing a pointer contacting an interactive surface are received. An ink annotation is displayed on the interactive surface in response to the input events. It is determined that the ink annotation corresponds with an ink gesture by comparing the ink annotation with a plurality of predefined ink gestures. The ink annotation is deleted and one or more commands associated with the ink gesture are executed. A system configured to implement the method and a computer readable medium storing instructions to implement the method are also provided. | 07-03-2014 |
20140189483 | SPREADSHEET VIEWER FACILITY - In embodiments of the present invention improved capabilities are described for providing, on a server-based computing device, a spreadsheet viewer facility configured to render a spreadsheet document created by a spreadsheet application as an actively rendered spreadsheet document in a client spreadsheet viewer running on a client computing device without the use of the spreadsheet application running on the client computing device. | 07-03-2014 |
20140195887 | FILTER AND SORT BY FORMAT - The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format. | 07-10-2014 |
20140223276 | METHODS, SYSTEMS AND COMPUTER PROGRAM PRODUCTS FOR FACILITATING VISUALIZATION OF INTERRELATIONSHIPS IN A SPREADSHEET - Methods, systems and computer program products are provided for visually indicating relationships among cells in a spreadsheet. Each of a first graphical linking element extending between cells in a first branch of a dependency tree of a root cell and a second graphical linking element extending between cells in a second branch of the dependency tree of the root cell is independently displayed and hidden. | 08-07-2014 |
20140245118 | ACTIONABLE EMAIL DOCUMENTS - A received reply email document enables some action to be effectuated using data included in the email document responsive to field identifiers associated with the data and corresponding to fields of metadata. The associated field identifiers that correspond to known fields of the metadata provide some expectation as to the semantic meaning and/or syntactic constraints of the data to which the field identifiers are associated. In a described implementation, an actionable email documents module creates an email document having blocks that are mapped to fields of metadata. The email document is transmitted to one or more recipients. Each recipient adds data to the blocks so that the data becomes mapped to the fields of the metadata. The recipients return a reply email document having the field-mapped data. Upon receipt, the module can effectuate some action using the field-mapped data responsive to the mappings. | 08-28-2014 |
20140281867 | VIEWING EFFECTS OF PROPOSED CHANGE IN DOCUMENT BEFORE COMMITING CHANGE - A tweak and view mode may be used by a user to see an effect of a proposed change to a document before the change is committed to the document. The application may automatically navigate to different portions of the document and/or display different sections of the document. Instead of the user having to search for the portion of the document affected by the change, the changed portions are determined for the user. The portions may be automatically displayed to the user and/or the user may determine when to move to each different portion that changed as a result of the proposed change. The proposed change may be accepted/rejected by the user. For example, a User Interface (UI) element may be selected by the user to either accept the change or reject the change. | 09-18-2014 |
20140281868 | SEMANTIC ZOOM-BASED NAVIGATION OF DISPLAYED CONTENT - Semantic zoom based navigation may be used to navigate content, such as content related to spreadsheets. Different gestures (e.g. pinch/stretch, pan, swipe) may be used while navigating the content. For example, while viewing data from a particular sheet in a workbook a pinch gesture may be received that changes the displayed content to a thumbnail view showing thumbnails that each represent a different sheet within the workbook. A gesture may also be received to change a view of an object. For example, a user may perform a stretch gesture near an object (e.g. a chart, graph, . . . ) that changes the current view to a view showing underlying data for the object. A user may also perform a gesture (e.g. a stretch gesture) on a portion of a displayed object that changes the current view to a view showing the underlying data for a specific portion of the object. | 09-18-2014 |
20140289600 | MANIPULATING OF LABELLED DATA FOR DATA ENTRY IN MANAGEMENT APPLICATIONS - A method and system for entry of data into content of cells belonging to an output field. Entered into cells of a multidimensional table located within a header record in the table are: input field labels respectively corresponding to input fields in the table entered into a respective unique cell within the header record; and an output label corresponding to the output field entered into a specifically unique cell within the header record and expressed as a mathematical expression of input field labels. The mathematical expressions are translated into the cell address of the cell containing each input field label and then pasted in each cell of the output field. The cell address of the cell containing each input field label is replaced in the pasted mathematical expression by the corresponding cell address of each input field in the same record that contains each cell of the output field. | 09-25-2014 |
20140359417 | SYSTEMS AND METHODS FOR GRAPHICALLY MODULATING STRUCTURED DATA - Generally described, embodiments of the present invention provide the ability to graphically modulating structured data, in a spreadsheet application and other applications, by applying any kind of cell formatting properties or design features to a given cell. Graphical modulation is determined based on formulae characteristics. In embodiments of the present invention, formula characteristics include various types of formula contained in a given cell. Formula types include, but are not limited to the following formula types, “workbook linked formula”, “sheet linked formula”, “cell linked formula”, “sensitivity formula”, “array formula”, “retrieving formula”, “calculative formula”, “computed input formula”, and “input formula”. In other embodiments of the present invention, formula characteristics include calculation complexity levels in formula contained in a given cell. In another embodiment of the present invention, applying graphical modulations can be presented on a surface display, above the cells surface, in the form of layers, for each formula characteristic. | 12-04-2014 |
20140372850 | Telling Interactive, Self-Directed Stories with Spreadsheets - A spreadsheet storytelling engine is provided. The spreadsheet storytelling engine may run in the context of a spreadsheet application on any device, service, or general endpoint capable of running the spreadsheet application. The spreadsheet storytelling engine allows for the authoring and telling of a story. The story is a collection of operations that guide the consumer through a spreadsheet. The story allows the spreadsheet to be used to convey visualizations, data, calculations, or other objects in a spreadsheet in a way that may be simple, pleasant to look at, and/or visually engaging to help a consumer understand the information and internalize it in a way that is actionable without requiring the real time availability of the spreadsheet author. The spreadsheet storytelling engine is useful for purposes including, but not limited to, making presentations, creating tutorials, validating data, explaining how a model works, and generating interactive business intelligence dashboards. | 12-18-2014 |
20140372851 | Conversion of Data Ranges to Table Objects - Conversion of data ranges to table objects in an electronic spreadsheet document is provided. When an electronic spreadsheet document is being utilized, data ranges may be automatically converted to tables to allow the user to enjoy the full benefits of the table properties and functionalities. When a data range is automatically converted to a table object, a user will be given an opportunity to revert the table object back to the data range from which it was converted. Instead of automatic conversion, a suggestion may be provided to a user before a data range is converted to a table object. If the user accepts the suggestion, then the data range may be automatically converted to a table object. | 12-18-2014 |
20140372852 | Showing Presence of Multiple Authors in a Spreadsheet - Dynamic collaborative presence information is provided. A plurality of users may access a document concurrently. Presence information associated with each of the users may be communicated to a server, collected, and communicated to a client application running on each user's client device. The client application may dynamically show where other users are editing a cell or a range of cells to help avoid collisions of edits in the document. Various interface elements may be provided for indicating presence and for indicating whether a single user or multiple users have selected or are editing the cell or range of cells. | 12-18-2014 |
20140372853 | SPREAD MATRIX WITH STATISTICS - Systems, methods and user interfaces are provided for displaying spread product market data and statistics. Market data may be arranged in a matrix and statistical information is inserted in the matrix in available space. In some cases, a computer system may receive market data for a plurality of spread products, receive and/or compute statistical information for the plurality of spread products, and generate a user interface screen that includes the market data for the plurality of spread products and the statistical information associated with the plurality of spread products, where the market data and the statistical information are arranged in a matrix. | 12-18-2014 |
20140380139 | EMBEDDED EXPERIENCE THROUGH BIDIRECTIONAL INTEGRATION OF CRM APPLICATIONS AND SPREADSHEET APPLICATIONS - Technologies are generally provided for providing an embedded experience through integrating a spreadsheet application with a customer relationship management (CRM) application to enable bi-directional functionality such that access to at least some of the functionality and data of the CRM application may be provided through the spreadsheet application, and spreadsheet application functionality for manipulating CRM application data may be provided within the CRM application. A spreadsheet application may be opened within the CRM application and columns and fields may be customized, columns may be sorted, new columns and fields may be created, data may be changed, and calculations may be performed automatically employing native spreadsheet capabilities to analyze CRM data. Similarly, an external spreadsheet application may be automatically populated with synchronized CRM data, and data manipulated in the spreadsheet application may be continuously updated at the CRM application. | 12-25-2014 |
20150026554 | DEVICE, METHOD, AND GRAPHICAL USER INTERFACE FOR MANIPULATING TABLES USING MULTICONTACT GESTURES - An electronic device having a display and a touch-sensitive surface, displays a table having a plurality of rows, a plurality of columns, and a plurality of cells. The device detects a gesture on the touch-sensitive surface that includes movement of one or more of a first contact and a second contact. When the detected gesture is a pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device decreases the width of the one or more respective columns. When the detected gesture is a de-pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device increases the width of the one or more respective columns. | 01-22-2015 |
20150033105 | System and Method of translation management, including concurrent user-directed presentation and execution of normalised and Romanised function and function parameter names, within Microsoft Excel for Windows (Excel) for non-English and non-Roman script languages. - A method to create and to permit multilingual cell formulas to be written and translated concurrently into any human language within Microsoft Excel, including those that are not representable in ANSI. This method enables multiple ad-hoc concurrent semantically complete and extensible non-Roman and non-English natural language function sets and function names available for presentation and execution within cell formulas within MS Excel and to provide real-time translation of presentation and execution between nominated language function sets. This process provides for a user-directed in-cell language nomination for the presentation and execution as well as the direction and target of the in-cell translation | 01-29-2015 |
20150039985 | ASSOCIATING MENTIONED ITEMS BETWEEN DOCUMENTS - A document processor for associating mentioned items with each other in two documents. A conversion unit converts at least a portion of mentioned items expressed in table format among the mentioned items included in the two documents. An association processing unit associates mentioned items with each other in the two documents including at least some mentioned items converted to text format. The conversion unit converts each of a plurality of cells included in the mentioned items expressed in table format to separate mentioned items in text format. | 02-05-2015 |
20150067463 | METHOD OF DISPLAYING DATA IN A TABLE WHILE RETAINING A FIXED HEADER - A method and computer-executable program code for displaying data in a table having columns, rows and a plurality of cells defined by the columns and rows. The method involves the steps of creating a first and a second sub-tables positioned one above another or side-by-side. The top sub-table defines a non-scrollable, fixed header, while the bottom table defines a scrollable data table. The top table has a visible part and a hidden part, which contains records copied, without re-positioning or re-ordering, from a maximum width cell in the top or bottom table corresponding to each individual column. To form a fixed sidebar, the code computer-executable program code adjusts the height of the rows based on the parameters of a maximum height cell in the row. | 03-05-2015 |
20150082137 | CREATING MEASURES FROM FORMULA ON OTHER MEASURES - Methods, systems, and computer-readable storage media for providing a calculated measure from one or more existing measures of a data object. Actions include receiving data associated with the data object, displaying a data visualization based on the data, the data visualization being displayed within a graphical user interface (GUI), receiving user input, the user input defining the calculated measure, the calculated measure being a function of at least one existing measure of the data object, at least one dimension of the data object, and an aggregation schema, and providing a modified data visualization for display, the modified data visualization including the calculated measure. | 03-19-2015 |
20150089340 | AUTOMATIC COLUMN RESIZING - In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to provide automatic column resizing in spreadsheet software using a desktop integration framework. The width of a column usually can only be set at or to hard-wired widths or manually adjusted to fit (even with a manually triggered auto adjustment function). This feature adds the ability to control column widths in tables at run time. | 03-26-2015 |
20150089341 | DATE PICKER IN EXCEL - In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to place date pickers on columns, rows, and cells using a desktop integration framework. The date picker can be tied to components, forms, or model metadata. In one aspect, date picker metadata is provided separately from the document to which one or more date pickers will eventually be added. | 03-26-2015 |
20150089342 | MODEL-DRIVEN TOOLTIPS IN EXCEL - In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to place tooltips on components and columns headers using a desktop integration framework. The tooltips can be tied to translatable resources or model metadata. In one aspect, the tool tip metadata is provided separately from the document to which the tool tip will eventually be tied. | 03-26-2015 |
20150089343 | USE OF TEMPORARY OPTIMIZED SETTINGS TO REDUCE CYCLE TIME OF AUTOMATICALLY CREATED SPREADSHEETS - Aspects of the present invention provide a solution for reducing cycle time of automatically created spreadsheets. Specifically, an embodiment of the present invention provides a way to create a spreadsheet from data that is in a native format more quickly and/or efficiently. To do so, the invention accesses a control file using optimized settings to create the spreadsheet. Then, after creation of the spreadsheet, the invention uses a second control file having the final settings to modify the spreadsheet in preparation for output. The invention may use agents to perform all or a portion of these activities. | 03-26-2015 |
20150095752 | EVALUATING RULES APPLIED TO DATA - Specifying rules for processing data included in fields of elements of a dataset includes rendering user interface elements associated with a respective condition. The user interface elements include: first subsets of user interface elements, at least some of which are associated with an input value derived from at least one field, and second subsets of user interface elements, each configured to receive user input associated with a respective condition. Conditions are applied to at least a first element of the dataset based on user input received from at least some of the user interface elements, in response to receiving user input for a first user interface element associated with a first field. Instructions are generated for applying one or more selected conditions associated with fewer than all of the user interface elements, the selected conditions including at least a condition associated with the first user interface element. | 04-02-2015 |
20150113377 | Micro 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. | 04-23-2015 |
20150121185 | PORTFOLIO MANAGEMENT SYSTEM - A method for displaying a graphical representation of a classification of a set of patent applications into a plurality of categories according to an attribute includes receiving, by a processor, a request to generate the graphical representation of the classification of the set of patent applications into the plurality of categories according to the attribute. The method further includes, in response to receiving the request, automatically displaying the graphical representation of the classification of the set of patent applications into the plurality of categories according to the attribute on a display device. The graphical representation includes a plurality of patent document icons. Each of the plurality of patent document icons corresponds to one of the set of patent applications. Each of the plurality of patent document icons graphically represents that the patent application associated with the patent document icon is classified in a category of the plurality of categories. | 04-30-2015 |
20150128018 | METHOD AND SYSTEM FOR FORMATTING DATA FROM ONE SOFTWARE APPLICATION SOURCE INTO A FORMAT COMPATIBLE FOR IMPORTING INTO ANOTHER SOFTWARE APPLICATION - A method and system electronically pull, using an extension of a launched program, accounting data from a launched accounting software application. The pulled data is converted, by the extension, into a format compatible with a second accounting software application. The converted data is written into the launched application associated with the extension. The written data is converted, by another extension, into a format compatible for importing into another accounting software application. The format compatible data is pushed into the second accounting software application by the extension. | 05-07-2015 |
20150149876 | STATUS VIEWER - In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to providing spreadsheets in a desktop integration framework that include error reports for validations. In various embodiments, a modeless error viewer is provided that allows end users to view an errors list for any failed row at the same time as the user corrects these errors. | 05-28-2015 |
20150309967 | METHOD FOR LOGICAL ORGANIZATION OF WORKSHEETS - According to one embodiment of the present invention, methods, systems and computer-readable media of accessing data within a spreadsheet are provided. A set of attributes is assigned to each worksheet of a plurality of worksheets within the spreadsheet. One or more worksheets may be identified by comparing the set of attributes for each worksheet to one or more attributes specified within a request for data, and the identified worksheets may be displayed. | 10-29-2015 |
20150309979 | METHOD FOR LOGICAL ORGANIZATION OF WORKSHEETS - According to one embodiment of the present invention, methods, systems and computer-readable media of accessing data within a spreadsheet are provided. A set of attributes is assigned to each worksheet of a plurality of worksheets within the spreadsheet. One or more worksheets may be identified by comparing the set of attributes for each worksheet to one or more attributes specified within a request for data, and the identified worksheets may be displayed. | 10-29-2015 |
20150317297 | SYSTEM AND METHOD FOR MANAGING DATA AND DATA MODELS - An exemplary embodiment of the present system and method provides a non-transitory, tangible computer readable storage medium having stored thereon computer-executable instructions. When executed by a computer, the instructions cause the computer to perform a number of steps of, which include: receiving a spreadsheet model; analyzing the spreadsheet model to determine one or more properties of the spreadsheet model; providing a first user interface on the basis of the determined properties, the first user interface enables configuration information to be specified for one or more cells of the spreadsheet model; receiving configuration information for the cells; and storing the spreadsheet model and the configuration information. | 11-05-2015 |
20150324346 | COMPOSITE DATA CREATION WITH REFINEMENT SUGGESTIONS - A data profiling module receives user selection of spreadsheets, and the data from the selected spreadsheets is profiled. At least one matching column is identified among the spreadsheets selected. The data profiling module calculates a match metric for the at least one matching column, and unifies the spreadsheets into a single composite spreadsheet using the at least one identified matching column. A preview view of a composite spreadsheet is generated, visually indicating the at least one matching column, any non-matching columns between the spreadsheets, and the match metric for the matching columns. An action history module identifies spreadsheets for use in the procedure, and stores any action applied to the spreadsheets as a procedure template that can be applied to a plurality of other spreadsheets. | 11-12-2015 |
20150347371 | USER INTERFACES FOR DISPLAYING RELATIONSHIPS BETWEEN CELLS IN A GRID - User interfaces for displaying visual representations of relationships between cells in a grid. In one example embodiment, a user interface includes a grid including rows and columns, a viewport that displays only a portion of the grid, and a plurality of cells each having a specific position in one of the rows and one of the columns of the grid. A first one of the cells is related to a second one of the cells that is positioned in a different one of the rows and a different one of the columns of the grid from the first cell such that the first cell and the second cell are not capable of being displayed in the viewport at the same time. The viewport is configured to display, upon selection of the first cell displayed in the viewport, a completely visible visual representation in the viewport of the relationship between the first cell and the second cell. | 12-03-2015 |
20150363378 | MANAGING DOCUMENT UNIT REFERENCES TO IMPROVE COLLABORATIVE DOCUMENT EDITING - An approach is provided for managing a display of document unit references. Units of an original version of a document and original references to the units are stored in nodes of a data structure. Responsive to an insertion of a new unit at a location in the document, a new node is inserted into the data structure at a corresponding location, or responsive to a deletion of a unit at the location in the document, a node is deleted from the data structure at the corresponding location. Unit(s) of the updated document resulting from the insertion or deletion are associated to respective original reference(s) in the data structure. During a conference between an editor and other participant(s), a display is generated and presented to the editor. The display includes the unit(s) of the updated document, current reference(s) to the unit(s), and the original reference(s) associated with the unit(s). | 12-17-2015 |
20160004683 | BLOCK DATA WORKSHEETS - A display structure that includes data items mapped based on relationships among the data items is visually presented on a user interface. The displayed data includes blocks of data received over a block data interface. The display structure may include a first portion indicative of availability of multiple 2-dimensional views of the data items and a second portion for the user to select one of the multiple 2-dimensional views to become an active view that is viewable by the user. | 01-07-2016 |
20160026356 | CLIENT-SIDE DYNAMIC CONTROL OF VISUALIZATION OF FROZEN REGION IN A DATA TABLE - A method, system, and/or computer program product visualizes tabular data with dynamically-generated frozen regions. A control and coordination mechanism oversees modification of a visualization of a browser-based main data table. A cloning and sizing process recursively traverses regions of the browser-based main data table to selectively clone and size regions of the browser-based main data table to be frozen, wherein the regions of the browser-based main data table to be frozen are selectable from any area of the browser-based main data table. An element insertion and positioning process positions and makes visible each newly cloned frozen region, wherein each newly cloned frozen region overlays a region of the browser-based main data table. A responsiveness process uses event listeners and polling mechanisms to detect actions and changes in a table viewport of a visible portion of the browser-based main data table to trigger regeneration of each newly cloned frozen region. | 01-28-2016 |
20160026374 | CHECKBOX MASS EDITING - Methods and systems for selecting multiple rows, columns, and/or cells are described. A user opens or otherwise accesses a file or document containing multiple rows, columns, and/or cells. The user hover a cursor or pointer over a particular row, column, or cell, or the user touches a particular row, column, or cell on a touchscreen. A single checkbox appears for that particular row, column, or cell. When the user selects that checkbox, unselected checkboxes for the other rows, columns, or cells appear. From there, the user can choose to select all the checkboxes or just some of the checkboxes to perform a mass action on the selected rows, columns, or cells. | 01-28-2016 |
20160055140 | PEER TO PEER SPREADSHEET PROCESSING - A distributed system and process for sharing a spreadsheet model. A spreadsheet to be shared is configured by defining input fields, processing parameters for the input fields, and output fields, and a template including the input and output fields is created. The template is shared with a remote user, who enters data into the input fields of the template. The input data is transferred for processing, after which results are provided to the remote user in the defined output fields of the template. | 02-25-2016 |
20160078015 | REPRESENTATION OF DATA RECORDS IN GRAPHIC TABLES - Various arrangements for creating a pivot table are presented. A set of stored records may be accessed. A plurality of stored records from the set of stored records may be selected to be represented in a plurality of cells of the pivot table. A graphical representation may be generated for display for each stored record of the plurality of stored records. Each graphical representation may be generated for display within a cell of the plurality of cells of the pivot table. Each graphical representation of the pivot table is actively linked with the corresponding stored record. | 03-17-2016 |
20160085739 | SYSTEMS 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. | 03-24-2016 |
20160098385 | Statistics Value Chart Interface Cell Mode Drill Down - In embodiments of statistics value chart interface cell mode drill down, a first interface displays in a table format that includes columns each with field values of an event field, and each column having a column heading of a different one of the event fields, and includes rows each with one or more of the field values, each field value in a row associated with a different one of the event fields, and having an aggregated metric that represents a number of events with field-value pairs that match all of the field values listed in a respective row and the corresponding event fields listed in the respective columns. A cell can be emphasized that includes one of the field values in a row that corresponds to one of the different event fields in a column, and in response, a menu displays options to transition to a second interface. | 04-07-2016 |
20160117307 | RECURSIVE EXTRACTION AND NARRATION OF NESTED TABLES - Machine logic (for example, software) that performs the following steps: (i) providing a parent table including a set of nested table(s) so that the parent table has N levels of nestedness, with N being an integer greater than one; and (ii) extracting a first nested table at the Nth level of nestedness where N is an integer equal to or greater than one, with a value of one representing the root table, and with greater values representing tables nested within the root table; and (iii) replacing the first nested table with equivalent narration text. Software is agnostic with respect to parent tables having different structural patterns, different file formats, and/or different cell layouts. | 04-28-2016 |
20160170954 | DATA FILTERING BASED ON A CELL ENTRY | 06-16-2016 |
20160173541 | PRESENTATION OF CONTENT FROM WITHIN SPREADSHEET APPLICATION | 06-16-2016 |
20160179780 | ANALYTICAL CHARTING | 06-23-2016 |
20160188561 | METHOD AND SYSTEM FOR INFORMATION RETRIEVAL AND PROCESSING - A computer-implemented system for the retrieval and manipulation of information available via an information network includes an information retrieval and processing component. The information retrieval and processing component includes: (a) search query means for conducting a search of the information network to obtain references to the information relevant to a search query; (b) information retrieval means for retrieving information available from sources on the information network, and an information store, for storage of retrieved information; and (c) processing means for processing of information retrieved from sources on the information network, and of information stored in the information store, to produce corresponding processed information. The system includes a cell-based user interface, and an intermediate storage layer, which permits a user, who may be unfamiliar with sophisticated computer programming languages, to develop automated processes for information transfer and manipulation based on present and historical information available via the information network. | 06-30-2016 |
20160196255 | AGGREGATION AND TRACKED CHANGES OF INFORMATION FROM MULTIPLE DATABASES USING UNIQUE IDENTIFICATION METHOD | 07-07-2016 |
20160253307 | FINDING UNIQUE FORMULA SETS IN SPREADSHEETS | 09-01-2016 |
20160378284 | DATA ENTRY SYSTEM AND ACCOMPANYING INTERFACE - A data entry system is disclosed. Some embodiments of the data entry system utilize an input device and a user interface. In some embodiments, a user can actuate keys on an input device to activate and/or select from the user interface cells associated with symbols, such as letters. A user can input different symbols quickly and efficiently. In some embodiments, users can input the most common letters of a given alphabet using only a single actuation of one of four keys. | 12-29-2016 |
20190147032 | DATA FLOW VIEW FOR A SPREADSHEET | 05-16-2019 |