Spreadsheet Patents (Class 715/212)
-
Publication number: 20130290822Abstract: 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.Type: ApplicationFiled: December 27, 2012Publication date: October 31, 2013Applicant: BIBO LABS, INC.Inventor: BIBO LABS, INC.
-
Patent number: 8572478Abstract: A computer-implemented method for managing row height in an electronic document includes receiving, at a computing device, a request to display a portion of a document that defines a plurality of rows of content and that is represented by a document model; determining heights of the plurality of rows and saving information about the determined heights in a cache that correlates rows to the height information; and using the document model and the cache to generate a view of the document model having the determined row heights.Type: GrantFiled: April 12, 2011Date of Patent: October 29, 2013Assignee: Google Inc.Inventors: Zachary Lloyd, Nick Santos
-
Patent number: 8549392Abstract: Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included in one or more spreadsheets. A graphical user interface is also described that provides simple user access to existing table styles that can be modified according to the user's requirements.Type: GrantFiled: August 30, 2005Date of Patent: October 1, 2013Assignee: Microsoft CorporationInventors: Roy Simkhay, David F. Gainer, Tom J. Hoke, Benjamin C. Chamberlain, Paavany Jayanty, Charles D. Ellis
-
Publication number: 20130254644Abstract: 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.Type: ApplicationFiled: May 20, 2013Publication date: September 26, 2013Applicant: Google Inc.Inventors: Jonathan Rochelle, Micah Lemonik, Farzad Khosrowshahi, John Stephen Danaher
-
Patent number: 8540153Abstract: The present invention provides a system that facilitates the selection of purchasable items for use in an environs defined by the customer. In one aspect, the system includes a processing element capable of proposing a plurality of purchasable items to the customer for selection by the customer. The processing element also is capable of receiving data representing the environs and data representing at least one purchasable item selected by the customer. The processing element is further capable of generating and displaying a three-dimensional graphical representation of the environs and each purchasable item or items selected by the customer so that the customer can visualize the items in the environs.Type: GrantFiled: December 24, 2010Date of Patent: September 24, 2013Assignee: Lowe's Companies, Inc.Inventors: Steven M. Stone, Santosh E Bhasker, Alex C Panzano, John P Mitchell
-
Patent number: 8539339Abstract: 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.Type: GrantFiled: April 12, 2011Date of Patent: September 17, 2013Assignee: Google Inc.Inventors: Zachary Lloyd, Dennis J. Lee, Joseph Schorr
-
Patent number: 8533583Abstract: Disclosed is an application software generation device to generate an application software for a data collection device having a reading unit to read discrimination information to carry out collection of data based on the discrimination information including a table data generation unit to generate table data for defining arbitrary items, an application software generation unit to generate an application software which is executed by the data collection device in order to collect the data based on the item which is defined in the table data and a transfer unit to transfer the generated application software to the data collection device.Type: GrantFiled: January 22, 2010Date of Patent: September 10, 2013Assignee: Casio Computer Co., Ltd.Inventors: Kouji Miyahara, Koji Nishitani, Hideki Takamura, Noriyoshi Katsumura
-
Patent number: 8527866Abstract: To sort data items in a spreadsheet table, data items in the spreadsheet table are divided into a plurality of blocks. Multiple threads are used to sort the data items in the blocks. After the data items in the blocks are sorted, multiple merge threads are used to generate a final result block. The final result block contains each of the data items in the spreadsheet table. Each of the merge threads is a thread that merges two source blocks to generate a result block. Each of the source blocks is either one of the sorted blocks or one of the result blocks generated by another one of the merge threads. A sorted version of the spreadsheet table is then displayed. The data items in the sorted version of the spreadsheet table are ordered according to an order of the data items in the final result block.Type: GrantFiled: April 30, 2010Date of Patent: September 3, 2013Assignee: Microsoft CorporationInventors: Carl B. Sutter, IV, Anatoly V. Grabar, Chad B. Rothschiller
-
Patent number: 8527865Abstract: Architecture includes for translating server calculations into client application formulas. The architecture determines dependencies, performs formulae translation, and processes data retrieval queries using the translated formulae. In one implementation, the architecture translates performance management server calculations into spreadsheet application formulas so that the impact of changes can be reflected immediately. Moreover, this technique does not require updating and querying of the performance management server. An algorithm is provided that allows translation of the backend formula (e.g., MDX—multidimensional expressions) directly into the spreadsheet application such that the impact on calculated values by an input change can be reflected instantaneously in the sheet.Type: GrantFiled: May 23, 2008Date of Patent: September 3, 2013Assignee: Microsoft CorporationInventors: Baomin Li, George Yan, Mark Yang
-
Publication number: 20130219256Abstract: 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.Type: ApplicationFiled: March 18, 2013Publication date: August 22, 2013Applicant: Google Inc.Inventor: Google Inc.
-
Publication number: 20130212455Abstract: A system and method for presenting views into general ledger data of an organization is described. In some examples, the system presents a hierarchy of views that include information associated with journal entries of the general ledger data along with links to other views within the hierarchy.Type: ApplicationFiled: February 10, 2012Publication date: August 15, 2013Inventors: William Roger Titera, Karl Joseph Busch
-
Patent number: 8510645Abstract: Disclosed is a method of applying a function to a set of data. Initially a tabular representation of the set of data is displayed, the representation comprising a plurality of columns. The data in the representation is grouped in each column based upon an order of the at least one column in the tabular representation. The method also generates a new column of data comprising a transform of existing column data contained in the tabular representation, wherein transform data within the new column depends upon a grouping context of the existing column data. Desirably the method further repositions the new column of data in the tabular representation and updates the transform data in the new column in accordance with a destination grouping context of a destination position of the new column in the tabular representation.Type: GrantFiled: October 4, 2006Date of Patent: August 13, 2013Assignee: Canon Kabushiki KaishaInventors: Joel Timothy Beach, Alexander Will
-
Publication number: 20130191712Abstract: 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. Visualizations of two-dimensional surfaces are rendered from provided data according to position, orientation, and viewpoint, some or all of which can be controlled by a user interface so as to create or control the intersection of surfaces. The provided data can be from an electronic spreadsheet, and the overall visualization can be displayed together with the display an electronic spreadsheet or other tabular data representation. Visually rendered surfaces can comprise symbols, colors, textures, or glyphs representing data, and virtual illumination.Type: ApplicationFiled: November 6, 2012Publication date: July 25, 2013Inventor: Lester F. Ludwig
-
Publication number: 20130185619Abstract: 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.Type: ApplicationFiled: November 5, 2012Publication date: July 18, 2013Inventor: Lester F. Ludwig
-
Patent number: 8489982Abstract: 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.Type: GrantFiled: August 15, 2008Date of Patent: July 16, 2013Assignee: E-Numerate Solutions, Inc.Inventor: Russell T. Davis
-
Publication number: 20130179765Abstract: 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.Type: ApplicationFiled: February 28, 2013Publication date: July 11, 2013Applicant: General Electric CompanyInventor: General Electric Company
-
Publication number: 20130174003Abstract: 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.Type: ApplicationFiled: June 29, 2012Publication date: July 4, 2013Inventor: Theodor Holm Nelson
-
Patent number: 8479089Abstract: 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.Type: GrantFiled: March 8, 2011Date of Patent: July 2, 2013Assignee: Certusoft, Inc.Inventors: Sermet Yücel, William D. Headrick, Samuel E. Martin, M. Germana Paterlini
-
Patent number: 8477363Abstract: A printer includes an input unit, a cell-size changing unit, a print data creating unit, and a printing unit. The input unit receives table data describing a table including a plurality of cells. Each of the plurality of cells has a size. The cell-size changing unit is configured to be capable of changing the size of a cell that is associated with a formula. The print data creating unit creates print data for printing a cell-size changed table that includes the size changed cell in a predetermined part of a recording sheet such that the formula fits entirely within the size changed cell, if the cell-size changing unit changes the size of the cell. The printing unit prints the cell-size changed table based on the print data in the predetermined part of the recording sheet.Type: GrantFiled: August 10, 2010Date of Patent: July 2, 2013Assignee: Brother Kogyo Kabushiki KaishaInventors: Norio Mizutani, Hiroshi Hattori
-
Patent number: 8473837Abstract: Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.Type: GrantFiled: July 26, 2010Date of Patent: June 25, 2013Assignee: Microsoft CorporationInventors: Lakshmi N. Thanu, Peter Eberhardy, Dylan Hai Huang, Xiaohong Mark Yang
-
Patent number: 8473389Abstract: Allowability, allocability and adjustment of contract prices are determined using a computer system, based on SERVICE CONTRACT ACT wage determination rules. Upon receiving a request for a contract price adjustment from a contractor, the contractor is required to submit the proposed price adjustment in an electronic spreadsheet format. Information from the spreadsheet is stored and made available electronically to the program. If the proposed price adjustment contains DAVIS BACON ACT hours, then the DBA hours are filtered using a governing wage determination raw data field for separate calculations using applicable rules and regulations. Payroll taxes and appropriate adjustment entitlement values are automatically calculated and the program determines, appropriate price adjustments. Pivot tables are used to summarize and visualize the adjustments and helpful tips are provided on worksheets for ease of understanding and confirming allowability, allocability and accuracy of the request for price adjustment.Type: GrantFiled: January 12, 2009Date of Patent: June 25, 2013Assignee: The United States of America, as represented by the Secretary of the NavyInventor: Laura Kimberly Wade
-
Patent number: 8468441Abstract: A chart is copied from a first application and pasted to a second application. A determination is made for which copy and paste option is selected for the chart. The chart is communicated to the second application using a clipboard application when the copy and paste operation corresponds to providing a link for the chart that is arranged communicating updated data of the chart. The chart is also communicated to the second application using a clipboard application when the copy and paste operation corresponds to representing the chart as a picture of assembled shapes. The chart is communicated to the second application using a separate data transfer interface when the copy and paste operation corresponds to embedding the chart in the second application. Furthermore, the formatting of the chart may be selected according to source formatting or destination formatting depending on the type of copy and paste operation selected.Type: GrantFiled: September 15, 2005Date of Patent: June 18, 2013Assignee: Microsoft CorporationInventor: Daniel P. Cory
-
Patent number: 8468442Abstract: 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 thType: GrantFiled: February 8, 2011Date of Patent: June 18, 2013Assignee: RR Donnelley Financial, Inc.Inventors: Stefan Chopin, Robert Krugman, Marc Strausberg, Leslie Barrett
-
Publication number: 20130151939Abstract: 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.Type: ApplicationFiled: December 8, 2011Publication date: June 13, 2013Applicant: Xerox CorporationInventors: Denys PROUX, Claude Roux
-
Patent number: 8463771Abstract: A method and an apparatus for selecting at least one steel grade from a stock of data, stored in a memory, for a population of a plurality of steel grades using a data processing device, wherein the method has the following steps: (a) a selection device (11) which can be operated by a user is displayed on a display means (12) which can be used to set values for at least two steel grade features which respectively denote the steel grades; (b) the stock of data is queried for a steel grade for which the stock of data stores values for steel grade features which correspond to the set values of the steel grade features or which fulfill conditions which are dependent on the set values, and (c) if said query is satisfied by a steel grade and possibly in so far as said steel grade fulfills one or more further conditions, said steel grade or information representing it is displayed on the display means (12).Type: GrantFiled: July 11, 2011Date of Patent: June 11, 2013Assignee: Abrams Engineering Services GmbH & Co. KGInventor: Jurgen Abrams
-
Publication number: 20130145244Abstract: 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.Type: ApplicationFiled: December 5, 2011Publication date: June 6, 2013Applicant: Microsoft CorporationInventors: Chad Barry Rothschiller, Thomas Scott Constantine, Andrew James Becker, Dafna Chen, Gabhan Berry, Xiaohui Pan, Igor Borisov Peev
-
Publication number: 20130145245Abstract: 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.Type: ApplicationFiled: January 31, 2013Publication date: June 6, 2013Applicant: Oracle International CorporationInventor: Oracle International Corporation
-
Patent number: 8458582Abstract: A computer system includes a processor; and a memory storage device in communication with the processor. The processor is adapted to: receive via a computer communications network a user identification and an identification of an electronic file having user-generated insurance-related data; provide an output signal for display to the user a prompt for the user to provide mapping data mapping a plurality of insurance-related data fields data identifiers in the user-data electronic file; receive mapping data in response to the prompt; access the user electronic file; employing the received mapping data, map data elements identified in the user-data electronic file, to a document in a predetermined format; verify that the received mapped data constitutes complete data to submit in connection with an insurance transaction; and provide an output signal including data constituting the document in a predetermined format to a system for further processing in accordance with an insurance transaction.Type: GrantFiled: November 13, 2009Date of Patent: June 4, 2013Assignee: Hartford Fire Insurance CompanyInventors: James S. Rogers, James Daniel Scott, M. Gary Letscher, Jill Spranzo
-
Publication number: 20130132812Abstract: A spreadsheet is repurposed to save paper and ink. An indication that a printout of a spreadsheet from a printer has been requested is received. The spreadsheet has content with a format that would result in a first quantity of pages being printed. Further, a printable range for the spreadsheet is determined. In addition, an overlap analysis of the spreadsheet is performed to determine if any of the plurality of shapes in the spreadsheet overlap one another. Each print zone is isolated in the spreadsheet. The print zone includes a group of cells. Each print zone is transformed into a transformed print zone. Further, a green spreadsheet is generated, without falling below a predetermined readability threshold, based on each transformed print zone such that the green spreadsheet has a second quantity of pages that is less than the first quantity of pages.Type: ApplicationFiled: August 3, 2010Publication date: May 23, 2013Applicant: ADOBE SYSTEMS INCORPORATEDInventors: Naveen Goel, Mayur Hemani, Himanshu Jindal
-
Publication number: 20130132811Abstract: 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.Type: ApplicationFiled: November 6, 2012Publication date: May 23, 2013Inventor: Lester F. Ludwig
-
Patent number: 8447685Abstract: A trading application can receive price and quantity information for tradable objects. The trading application can compute implied price and quantity information for spreads of the tradable objects. Direct and indirect price and quantity information for the spreads can be displayed in a manner that shows the relationship with each other and with the price and quantity information for the tradable objects.Type: GrantFiled: January 11, 2012Date of Patent: May 21, 2013Assignee: Trading Technologies International, Inc.Inventor: Joel Cohen
-
Publication number: 20130124958Abstract: 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.Type: ApplicationFiled: November 15, 2011Publication date: May 16, 2013Applicant: MICROSOFT CORPORATIONInventors: Meir Mendelovich, Eugene (John) Neystadt, Dany Hoter
-
Publication number: 20130124959Abstract: 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.Type: ApplicationFiled: September 26, 2012Publication date: May 16, 2013Applicant: CASIO COMPUTER CO., LTD.Inventor: Kouji Miyahara
-
Publication number: 20130124957Abstract: 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.Type: ApplicationFiled: November 11, 2011Publication date: May 16, 2013Applicant: MICROSOFT CORPORATIONInventors: Diego M. Oppenheimer, Allan Folting, Anatoly V. Grabar, Stephen Van de Walker Handy
-
Publication number: 20130117648Abstract: 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: /a/ identifying a single reference field, /b/ allocating a field type to fields other than the reference field, the field type belonging to a set of field type including attribute, parent, and flow, /c/ defining a link, for each field with a type, which establishes a link with another linked field, in particular a parent/child link, /d/ building a hierarchical model representing the parent/child links, /f/ generating a graphical hierarchical multilevel representation of the sheet content, with graphical views showing one or more hierarchical levels and displaying the representation on the display.Type: ApplicationFiled: November 3, 2011Publication date: May 9, 2013Applicant: KNOWLEDGE INSIDEInventor: Samuel BOUTIN
-
Publication number: 20130117649Abstract: 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.Type: ApplicationFiled: September 11, 2012Publication date: May 9, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: Amer Hammoud
-
Patent number: 8436871Abstract: A sortable and space efficient graphical user interface and a system for the efficient display of sortable data are disclosed herein. The graphical user interface may include at least one column, at least one row and a data cell defined by the intersection of at least one column and at least one row. First and second data may be displayed in the data cell. A first header is associated with the first column and identifies the first data. A second header is associated with the first column and identifies the second data. In the system for displaying sortable data, a graphical user interface is displayed upon a graphical display. A table is displayed as at least a portion of the graphical user interface, the table having a column with a plurality of rows, each row displaying first and second data and a first header associated with a first data and a second header associated with the second data.Type: GrantFiled: April 18, 2008Date of Patent: May 7, 2013Assignee: General Electric CompanyInventor: Robert Joseph Alberte
-
Publication number: 20130111320Abstract: Slicers are configured to filter tabular data arranged in columns. A user may use the slicers to filter tabular data from a client application and/or a server based application/service. Slicers may be created for one or more columns and for all/portion of the tabular data within a column. Selection of a slicer element filters the associated tabular data and updates a display of the other slicers. Interaction with the slicers may also update other user interface controls that filter the tabular data (e.g. selecting a slicer element changes a value of a filtering setting in a drop down menu and/or selecting the filtering setting in the drop down menu changes a state of a slicer element). A slicer element may be associated with other objects in the spreadsheet and/or included within one or more functions of a spreadsheet.Type: ApplicationFiled: October 31, 2011Publication date: May 2, 2013Applicant: MICROSOFT CORPORATIONInventors: Johnny Sterling Campbell, Jenefer Monroe, Konrad Tupaj, Amarinder Singh Grewal, Robert George Hawking, Allan Folting
-
Publication number: 20130104019Abstract: 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.Type: ApplicationFiled: May 16, 2012Publication date: April 25, 2013Applicant: LEXISNEXIS, A DIVISION OF REED ELSEVIER INC.Inventors: Thomas J. Goedde, Richard D. Miller, Jacob Aaron Myers, Gaurav Mehra, Lisa Peterson
-
Publication number: 20130104020Abstract: Inserting a formula at a location on a content surface in a user interface is provided. A user interface showing a status bar which includes one or more predetermined calculations may be displayed on a computer. The computer may receive a selection of a predetermined calculation from the status bar in the user interface. The selected predetermined calculation may then be dragged from the status bar and inserted at a drop location on the content surface in the user interface. The computer may then automatically generate a formula corresponding to the selected predetermined calculation in the user interface.Type: ApplicationFiled: October 25, 2011Publication date: April 25, 2013Applicant: Microsoft CorporationInventors: Eric W. Patterson, Karen X. Cheng, Benjamin Edward Rampson
-
Patent number: 8429521Abstract: 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.Type: GrantFiled: April 12, 2011Date of Patent: April 23, 2013Assignee: Google Inc.Inventors: Zachary Lloyd, Dennis J. Lee, Nick Santos, Yoah Bar-David
-
Patent number: 8429518Abstract: 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.Type: GrantFiled: May 13, 2011Date of Patent: April 23, 2013Assignee: MasterMine Software, Inc.Inventor: Robert Machalek
-
Patent number: 8423909Abstract: A system applies an interactive filter. The system includes a data storage device, a display device, a user interface input device, and a processor. The data storage device stores data. The display device displays an initial representation of the data. The user interface input device facilitates a localized selection of a portion of the initial representation displayed on the display device. The localized selection is determined by hovering a navigation icon in alignment with a selection area corresponding to the portion of the initial representation. The processor dynamically applies a filter parameter to the portion of the initial representation based on the localized selection from the user interface input device.Type: GrantFiled: July 26, 2010Date of Patent: April 16, 2013Assignee: International Business Machines CorporationInventor: Robert S Zabielski
-
Patent number: 8421803Abstract: This invention facilitates monitoring operation for checking whether or not quality of a substrate deteriorates as well as operation for identifying a cause of deterioration in quality. Identification information of constituent elements related to measurement target sections (pads) on a component-mounted substrate is arranged into hierarchal structure data. A first axis is arranged with the measurement target sections associated with this arrangement. A second axis is arranged with information (identification information of lots and squeegees) representing production conditions of the substrates according to an order of the substrates being processed. A two-dimensional area defined by the first axis and the second axis is set. A color map is generated, in which measured data of the measurement target sections on the substrates are arranged in colors at corresponding positions within the two-dimensional area.Type: GrantFiled: January 22, 2010Date of Patent: April 16, 2013Assignee: Omron CorporationInventors: Kazuto Kojitani, Keiji Otaka, Hiroyuki Mori
-
Patent number: 8418049Abstract: 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.Type: GrantFiled: July 23, 2007Date of Patent: April 9, 2013Inventors: Ying Huang, Jim Laredo, Markus Gero Stolze, Piyawadee Sukaviriya, Brian White, Kuo Zhang
-
Publication number: 20130086459Abstract: 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.Type: ApplicationFiled: October 4, 2011Publication date: April 4, 2013Applicant: MICROSOFT CORPORATIONInventors: Allan Folting, Stephen Van de Walker Handy, Diego M. Oppenheimer, Anatoly V. Grabar, Amit A. Velingkar
-
Publication number: 20130086460Abstract: 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.Type: ApplicationFiled: October 4, 2011Publication date: April 4, 2013Applicant: MICROSOFT CORPORATIONInventors: Allan Folting, Stephen Van de Walker Handy, Diego M. Oppenheimer, Anatoly V. Grabar
-
Patent number: 8407578Abstract: 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.Type: GrantFiled: September 23, 2009Date of Patent: March 26, 2013Assignee: International Business Machines CorporationInventors: Stephen K Boyer, James Rhodes
-
Patent number: 8407579Abstract: 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.Type: GrantFiled: December 16, 2010Date of Patent: March 26, 2013Assignee: Balenz Software, Inc.Inventors: Ramkumar N. Raja, Christopher A. Pomerantz, Murali Ramachandran, Jeffrey R. Duke
-
Publication number: 20130073937Abstract: 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.Type: ApplicationFiled: September 15, 2011Publication date: March 21, 2013Inventors: Milliken FERNANDES, Robert I. LEE, Dragan MASNIKOSA, Supriya SAMANTA