Particular Calculation Of Cell Content Patents (Class 715/219)
  • Patent number: 10289672
    Abstract: A system for threading spreadsheet calculations includes an input interface and a processor. The input interface is to receive a request to perform spreadsheet calculations. The processor is to determine a data flow graph based at least in part on formulas of a spreadsheet, determine one or more spreadsheet threads based at least in part on the data flow graph, and indicate to execute the one or more spreadsheet threads to determine the spreadsheet calculation results.
    Type: Grant
    Filed: December 21, 2015
    Date of Patent: May 14, 2019
    Assignee: Workday, Inc.
    Inventor: Terry M. Olkin
  • Patent number: 10289673
    Abstract: A method for obtaining server-side and client-side calculations performed in a document includes presenting, on a client computer, the document stored on a server and receiving an input, where the input causes a calculation in the document. The client computer performs the calculation on the client computer and sends the input to the server to concurrently perform the calculation on the server. The client computer obtains a first result from the calculation performed on the client computer and a second result from the calculation performed on the server, selects the first result or the second result as a selected result based on which of the first result or the second result is obtained quicker from the calculation performed on the client computer and the calculation performed on the server, and presents, in the document, the selected result to the user.
    Type: Grant
    Filed: December 13, 2017
    Date of Patent: May 14, 2019
    Assignee: GOOGLE LLC
    Inventors: Daniel Gundrum, Zachary Erik Lloyd, Joshua Ari Danziger, Amod Karve
  • Patent number: 10255261
    Abstract: A processor obtains a table that contains numerical values or character strings in its cells. The processor then replaces each numerical value with a first constant value, and each character string with a second constant value. The two constant values have opposite signs. The processor generates area datasets each including first to third rectangular areas. The right side of the second rectangular area coincides with the left side of the first rectangular area. The bottom side of the third rectangular area coincides with the top side of the first rectangular area. With respect to each generated area dataset, the processor compares a sum of first and second constant values in the first rectangular area with a sum of first and second constant values in the second and third rectangular areas. The processor outputs at least one of the area datasets according to the comparison result.
    Type: Grant
    Filed: February 3, 2017
    Date of Patent: April 9, 2019
    Assignee: FUJITSU LIMITED
    Inventors: Keisuke Goto, Yuiko Ohta, Hiroya Inakoshi, Kento Uemura
  • Patent number: 10255262
    Abstract: A method, system and computer readable program product are disclosed for encoding a function in a spreadsheet program to execute stream processing on a computing system. In embodiments of the invention, the method comprises encoding one or more formulas in one or more cells of the spreadsheet program, each of the formulas supporting data windows and stream partitioning; designating a first group of cells of the spreadsheet program as input cells for holding input values for the one or more formulas; and designating a second group of cells of the spreadsheet program as output cells for holding output values of the one or more formulas. In embodiments of the invention, the stream partitioning includes partitioning a defined stream of data into a plurality of data stream partitions, and the one or more formulas are encoded to operate on the plurality of data stream partitions.
    Type: Grant
    Filed: February 8, 2016
    Date of Patent: April 9, 2019
    Assignee: International Business Machines Corporation
    Inventors: Martin J. Hirzel, Rodric Rabbah, Philippe Suter, Olivier Tardieu, Mandana Vaziri
  • Patent number: 10120852
    Abstract: A data processing method executed by a computer, the data processing method including specifying a first region range among from a data table, a first region range including a plurality of numerical value regions which are continuously disposed in a first direction, a plurality of numerical values in the plurality of numerical value regions having a relationship with a specified numerical value in an adjacent region, specifying a second region range, the second region range being specified by shifting the first region range in a second direction, the second region range including at least one character string region and at least one blank region, associating a character string in the at least one character string region and the plurality of numerical values, and outputting data that indicates an association between the character string in the at least one character string region and the plurality of numerical values.
    Type: Grant
    Filed: August 8, 2016
    Date of Patent: November 6, 2018
    Assignee: FUJITSU LIMITED
    Inventors: Keisuke Goto, Yuiko Ohta, Hiroaki Morikawa, Hiroya Inakoshi
  • Patent number: 9986038
    Abstract: Systems, methods and apparatus for managing machine-to-machine (M2M) entities are disclosed. Included herein is a method that may include implementing one or more management layers for managing M2M entities in an M2M environment. The method may also include using a plurality of management layers to manage a M2M area network, wherein the M2M area network may include one or more M2M end devices. The M2M end devices may include, for example, an M2M gateway and/or an M2M device. The management layers may include any of an application management layer, service management layer, network management layer and a device management layer. The management layers may provide any of configuration management, fault management, and performance management of the M2M entities.
    Type: Grant
    Filed: July 15, 2016
    Date of Patent: May 29, 2018
    Assignee: IoT Holdings, Inc.
    Inventors: Chonggang Wang, Paul L. Russell, Jr., Guang Lu, Dale N. Seed, Lijun Dong, Michael F. Starsinic
  • Patent number: 9922018
    Abstract: A user interface control is presented for assisting the computer user in viewing cells with a data table. In particular, a vector viewing control is presented which enables the computer user to view cells within a data table. The vector viewing control comprises a plurality of cell elements, each cell element corresponding to one or more cells in the data table. The cell elements correspond to a vector of cells in the data table that is represented by the vector viewing control. Upon user interaction with the vector viewing control, an expanded view is presented showing the contents of the data cell corresponding to the location of the interaction point on the control. The computer user can move the expanded view up and down the vector to view the contents of the data table.
    Type: Grant
    Filed: November 12, 2012
    Date of Patent: March 20, 2018
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Wai Chan, Salvador Celis
  • Patent number: 9787857
    Abstract: A display control apparatus is configured to display on a display unit a user interface screen for an image data generating apparatus configured to generate image data using an image sensor. The display control apparatus includes a setting acquiring unit which is configured to acquire a setting value for generating the image data, a display determining unit which is configured to determine whether to display an update reception screen based on the acquired setting value, a display control unit which is configured to display the update reception screen on the display unit if the display determining unit determines to display the update reception screen, and is configured not to display the update reception screen on the display unit if the display determining unit determines not to display the update reception screen, and an instruction receiving unit which is configured to receive the update instruction through the update reception screen.
    Type: Grant
    Filed: September 25, 2012
    Date of Patent: October 10, 2017
    Assignee: BROTHER KOGYO KABUSHIKI KAISHA
    Inventor: Mayumi Kuraya
  • Patent number: 9721030
    Abstract: A user interface that when selected triggers the automatic sharing of a spreadsheet object in a spreadsheet with a chosen network service (e.g. social network, blog, or some other network location). For example, cells, tables, charts and other objects of the spreadsheet may be selected to be shared using the user interface. When a spreadsheet object is selected and indicated to be shared using the user interface, the spreadsheet is automatically saved to a network share, permissions are set for the spreadsheet to share the spreadsheet object, and the spreadsheet object is shared with the network service. Changes made to the spreadsheet after the spreadsheet object is shared are reflected in the spreadsheet object on the network service.
    Type: Grant
    Filed: December 9, 2010
    Date of Patent: August 1, 2017
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Daniel Parish, Daniel Battagin
  • Patent number: 9715487
    Abstract: 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.
    Type: Grant
    Filed: September 30, 2008
    Date of Patent: July 25, 2017
    Assignee: APPLE INC.
    Inventor: Peter William Rapp
  • Patent number: 9582599
    Abstract: A page update handler enables a browser to update the display of a page with data received from a server. For example, a server may predictively retrieve data in anticipation of a user performing a particular action on a page, and may send this data to the browser in a hidden format; if the user subsequently performs the action, the page update handler may update the displayed page with the predictively retrieved data. As another example, a page may initially be displayed with a visual display object that serves as a placeholder for data being retrieved by the server; once the server retrieves the data and sends it to the browser, the page update hander may populate the display object with the data.
    Type: Grant
    Filed: December 22, 2011
    Date of Patent: February 28, 2017
    Assignee: Amazon Technologies, Inc.
    Inventor: Nigel Green
  • Patent number: 9558173
    Abstract: Systems and methods of pasting a discontinuous selection from a first document are provided, comprising receiving, at a processor, the discontinuous selection modeling the selection as a data structure, and pasting each of the plurality of portions including contextual formatting for each portion. The discontinuous selection includes a plurality of portions of the first document and the portions are discontinuous. The portions may include one or more cells from a table, and pasting the one or more cells includes pasting at least borders of the cell, a background color of the cell, and text contained in the cell.
    Type: Grant
    Filed: February 5, 2013
    Date of Patent: January 31, 2017
    Assignee: Google Inc.
    Inventors: Kevin Markman, Olga Sergeyevna Saviano, Luiz Amaral Franca Pereira Filho, Isabella Ip
  • Patent number: 9542629
    Abstract: An image processing apparatus according to the present invention includes an image forming unit configured to form an image, a measuring unit configured to measure the formed image, a control unit configured to control execution of a single-color calibration to be performed to correct reproduction characteristics of a single-color formed by the image forming unit based on a measuring result of a single-color image formed with a single-color recording agent and execution of a multi-color calibration to be performed to correct reproduction characteristics of a multi-color image formed by the image forming unit based on a measuring result of a multi-color formed with a plurality of recording agents, and a selection unit configured to select whether to cause the control unit to perform the multi-color calibration after completing the single-color calibration or cause the control unit to perform any one of the single-color calibration and the multi-color calibration.
    Type: Grant
    Filed: July 9, 2013
    Date of Patent: January 10, 2017
    Assignee: Canon Kabushiki Kaisha
    Inventor: Masanori Matsuzaki
  • Patent number: 9507788
    Abstract: A distributed heterogeneous or homogeneous file storage system divides logical responsibility for data from actual control of the data by using separate file and storage managers. Each file manager provides access to stored files and stores metadata associated with each of the files for which it is responsible. A file manager control component allocates responsibilities among file managers, assigns management responsibilities for individual files, and maintains a record of which files are assigned to each manager. Each storage manager is responsible for managing storage of files on data storage devices and maintains a record of the location of each stored file. A storage manager control component allocates responsibilities among storage managers, assigns responsibilities for individual files, and maintains a record of which files and storage devices are assigned to each manager.
    Type: Grant
    Filed: August 2, 2015
    Date of Patent: November 29, 2016
    Assignee: Impossible Objects, LLC
    Inventors: Elan Pavlov, Stephen Ness, Roger Critchlow, Robert Swartz, Timothy S. Murphy, Ronald Lachman
  • Patent number: 9483525
    Abstract: Aspects of the subject matter described herein relate to reducing update conflicts when maintaining views. In aspects, a transaction in snapshot isolation may update a materialized view. Instead of being able to view the update within the transaction, the update is hidden to prevent the transaction from obtaining inconsistent data. When a transaction is not supposed to see an update to a materialized view that occurs within the transaction, additional information associated with the materialized view may indicate this. When a query of the materialized view is made within the transaction, the query engine may use the additional information to exclude data from the update in the result.
    Type: Grant
    Filed: April 30, 2007
    Date of Patent: November 1, 2016
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Tengiz Kharatishvili, Wei Xiao, Stefano Stefani
  • Patent number: 9355085
    Abstract: A data cell included in a document supporting cell structured data is conditionally formatted according to data that is stored in a separate location from the document. A user is allowed to select from a drop-down menu of related data sets a particular data set for conditionally formatting the data cell. The data cell is formatted according to the data set and the condition without requiring that the data set be stored locally in the document.
    Type: Grant
    Filed: November 30, 2009
    Date of Patent: May 31, 2016
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Eric Barber Vigesaa, Benjamin C. Chamberlain, Christopher M. Street, Bruce Cordell Jones
  • Patent number: 9275031
    Abstract: Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.
    Type: Grant
    Filed: October 9, 2009
    Date of Patent: March 1, 2016
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
  • Patent number: 9108890
    Abstract: A method for manufacturing training aid materials for detecting homemade explosives includes spreading an explosive powder on a porous surface, storing the surface in a container that facilitates sublimation of the explosive powder such that the explosive powder redeposits onto the surface and into the pores over a period of time, and removing the surface from the container after the period of time to yield training aid materials. An additional method includes preparing a dilute solution of an explosive reaction mixture, and depositing the dilute solution on a surface prior to formation of an explosive product by the explosive reaction mixture. The surface is stored in a contain that facilitates formation of the explosive product, and removed after a period of time and cleaned to remove unreacted precursors to yield training aid materials.
    Type: Grant
    Filed: February 25, 2013
    Date of Patent: August 18, 2015
    Assignee: The Johns Hopkins University
    Inventor: Doan-Trang T. Vu
  • Patent number: 9075661
    Abstract: Objects are placed on hosts using hard constraints and soft constraints. The objects to be placed on the host may be many different types of objects. For example, the objects to place may include tenants in a database, virtual machines on a physical machine, databases on a virtual machine, tenants in directory forests, tenants in farms, and the like. When determining a host for an object, a pool of hosts is filtered through a series of hard constraints. The remaining pool of hosts is further filtered through soft constraints to help in selection of a host. A host is then chosen from the remaining hosts.
    Type: Grant
    Filed: October 20, 2010
    Date of Patent: July 7, 2015
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Alexander Hopmann, Marc Keith Windle, Patrick Simek, Erick Raymundo Lerma, Dan Rosenthal
  • Patent number: 9026897
    Abstract: An integrated, configurable, sensitivity, analytical, temporal, visual system for an electronic plan system including stored in a memory and configured to be executed by one or more processors. The programs include instructions to generate: an electronic plan including one or more row descriptors each including a plurality of row descriptor properties, one or more column descriptors each including a plurality of column descriptor properties, one or more cells mapped to one of the row descriptors by a unique row descriptor identifier and to one of the of one of the column descriptors by a unique column descriptor identifier, and each of the one or more cells including a numeric formula or a user-defined formula that references one or more other cells. An interpreter is configured to read each formula of the one or more cells and determine dependency data associated with each cell.
    Type: Grant
    Filed: July 9, 2014
    Date of Patent: May 5, 2015
    Assignee: Logic9s, LLC
    Inventor: Dean Zarras
  • Patent number: 9021347
    Abstract: An information processing method comprises the steps of: inputting an input information of a multi-dimensional array; calculating an accumulated information value corresponding to a position of each element of the input information; and holding the accumulated information value in a buffer having a size of predetermined bits, wherein in the holding step, when an accumulated information value calculated in the calculating step overflows with respect to the size, a part not more than the predetermined bits of the calculated accumulated information value is held as the accumulated information value.
    Type: Grant
    Filed: May 27, 2008
    Date of Patent: April 28, 2015
    Assignee: Canon Kabushiki Kaisha
    Inventors: Yoshinori Ito, Kan Torii, Takahisa Yamamoto, Masami Kato
  • Publication number: 20150113378
    Abstract: Various embodiments are generally directed to techniques and apparatuses to present a dynamic formula bar in a spreadsheet application. Some embodiments are particularly directed to presenting a dynamic formula bar in a spreadsheet application that may improve usability in particular with large display sizes and/or touchscreen interfaces. In one embodiment, for example, an apparatus may comprise a processor circuit and a spreadsheet user interface (UI) component executing on the processor circuit to present a grid comprising cells arranged in rows and columns. The spreadsheet UI component may include a formula bar interface component operative to display a formula bar UI element adjacent to a first cell in response to receiving a control directive selecting the first cell. Other embodiments are described and claimed.
    Type: Application
    Filed: October 22, 2013
    Publication date: April 23, 2015
    Inventors: CARLOS OTERO, JOHN CAMPBELL, UHL ALBERT
  • Patent number: 8959424
    Abstract: Provided are techniques for comparing data. User selection of first data to be compared is received. User input of one or more formulas used in making comparisons is received. The user is allowed to move a Comparative and Analytic (CA) lens window to float over second data, wherein the CA lens window displays a floating, transparent document. In response to the CA lens floating 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.
    Type: Grant
    Filed: June 28, 2011
    Date of Patent: February 17, 2015
    Assignee: International Business Machines Corporation
    Inventor: Amer Hammoud
  • Patent number: 8954838
    Abstract: Some embodiments provide a system for displaying cells of a table. During operation, the system can receive a sort-and-merge request for sorting the rows of the table using a sort column. Next, the system can sort the rows of the table based at least on cell values in the sort column to obtain a sorted table. The system can then merge a set of consecutive cells in a merge column of the sorted table to obtain a merged cell, wherein the set of consecutive cells are associated with the same cell value. Note that the sort column and the merge column can be the same column, or they can be different columns. Next, the system can display the merged cell and other cells in the sorted-and-merged table. Displaying a cell can involve positioning the cell's value in a visible area of the cell.
    Type: Grant
    Filed: December 4, 2009
    Date of Patent: February 10, 2015
    Assignee: Synopsys, Inc.
    Inventors: Anil P. Balaram, Takashi Toyooka
  • Patent number: 8954837
    Abstract: 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.
    Type: Grant
    Filed: May 16, 2011
    Date of Patent: February 10, 2015
    Assignee: Apple Inc.
    Inventor: Peter William Rapp
  • Patent number: 8949705
    Abstract: Optimal presentation and editing of business data in a browser-based user interface of an integrated web-based business information system is described, including a browser at a user computer in dynamic communication with a web server allowing database editing and updating without browser page refreshes.
    Type: Grant
    Filed: October 29, 2012
    Date of Patent: February 3, 2015
    Assignee: NetSuite Inc.
    Inventors: Luke A. Braud, Baruch Goldwasser, Evan M. Goldberg
  • Publication number: 20150019946
    Abstract: An integrated, configurable, sensitivity, analytical, temporal, visual system for an electronic plan system including stored in a memory and configured to be executed by one or more processors. The programs include instructions to generate: an electronic plan including one or more row descriptors each including a plurality of row descriptor properties, one or more column descriptors each including a plurality of column descriptor properties, one or more cells mapped to one of the row descriptors by a unique row descriptor identifier and to one of the of one of the column descriptors by a unique column descriptor identifier, and each of the one or more cells including a numeric formula or a user-defined formula that references one or more other cells. An interpreter is configured to read each formula of the one or more cells and determine dependency data associated with each cell.
    Type: Application
    Filed: July 9, 2014
    Publication date: January 15, 2015
    Inventor: Dean Zarras
  • Publication number: 20150019945
    Abstract: Systems, methods and machine-readable mediums for defining and executing new commands in a spreadsheet application are provided. A method may include receiving a declaration command in a first spreadsheet cell. The declaration command identifying a command name for the new command and operations performed for the command name based on a plurality of second spreadsheet cells. A system may include a processor programmed to evaluate the declaration command in the first spreadsheet cell according to the instructions stored in a storage device, receive the command name and at least two parameters identifying at least one input spreadsheet cell and at least one output spreadsheet cell of the spreadsheet application, create a new command for the spreadsheet application, and evaluate the new command as identified by the command name in a second spreadsheet cell for execution. The computer readable mediums provide instructions to cause the processor to perform the operations above.
    Type: Application
    Filed: January 2, 2014
    Publication date: January 15, 2015
    Applicant: EXIGEN PROPERTIES, INC.
    Inventor: Gregory Dorman
  • Publication number: 20150019947
    Abstract: Tools and techniques for providing multi-client collaboration to access and update structured data elements are disclosed. Client systems may present user interfaces that provide libraries of published data elements that are available for collaboration. The clients may request selected data elements, while referencing unique identifiers associated with the selected data elements. Those clients that publish data elements for collaboration by others may present user interfaces that provide representations of candidate structured data elements, and receive selections of those data elements chosen for publication. The publishing clients may then send the selected data elements for publication. The client systems may interact with servers or collaboration services, which may receive structured data elements that the clients have published for access by others.
    Type: Application
    Filed: September 30, 2014
    Publication date: January 15, 2015
    Inventor: Robert G. Hawking
  • Publication number: 20140372854
    Abstract: A smart selection engine is provided. The smart selection engine may run in the context of a spreadsheet application on any device, service, or general endpoint capable of running the spreadsheet application. The smart selection engine reduces the cognitive load and complexity for performing spreadsheet operations by clearly presenting the user with easy to use and understand options that are big, simple, and lend themselves nicely to natural user interfaces, touch enabled devices, and devices with small displays as well as with graphical user interfaces, larger displays, and traditional input devices. By making contextually based suggestions, the smart selection engine reduces or eliminates the need for the user to be aware of the available operations or how to perform the operations. Further, the smart selection engine improves the consistency and efficiency of working with a spreadsheet.
    Type: Application
    Filed: June 14, 2013
    Publication date: December 18, 2014
    Inventors: Carlos Augusto Otero, John Campbell, Uhl Albert, Pablo Rochat
  • Publication number: 20140337704
    Abstract: A system and a method for converting between data formats converts air flow data from a thermal simulation tool into a format readable by a DC power analyzing tool. Air flow data associated with the locations of certain points on a printed circuit board are taken and an EXCEL document including Main, Data, and Final worksheets is created. The data to be converted is obtained, and the data imported into the Data worksheet. Parameters in the Main worksheet to set an analysis area of the printed circuit board are set, and air flow data associated with the analysis areas from the Data worksheet are obtained and divided into groups, according to the parameters set in the Main worksheet. An equivalence value for each group of data is calculated and the equivalence values are saved in the Final worksheet for reading by the DC power analyzing tool.
    Type: Application
    Filed: May 9, 2014
    Publication date: November 13, 2014
    Applicant: HON HAI PRECISION INDUSTRY CO., LTD.
    Inventors: SHAO-YOU TANG, PO-CHUAN HSIEH, WEI-CHIEH CHOU
  • Patent number: 8875028
    Abstract: A user collaboration system providing for the efficient utilization of an organization's resources, such as the bandwidth associated with call center activity. At the same time, the user collaboration system enables users to quickly and easily receive help in a particular subject matter area, without requiring the user to know who within the organization may be able to provide that assistance. The user collaboration system also maintains an organization's user profile information that tracks employee subject matter expertise and allows users to request assistance from an anonymous expert. The assistance may be provided via a collaboration session which may be optimized based on available network resources.
    Type: Grant
    Filed: September 21, 2006
    Date of Patent: October 28, 2014
    Assignee: Accenture Global Services Limited
    Inventors: Antonio Samele, Timothy J. Schneider
  • Publication number: 20140237340
    Abstract: Dynamic data loading of tabular data includes identifying a plurality of formulas within tabular data of a document, wherein the tabular data is arranged in cells. Using a processor, a hierarchy for the tabular data is determined according to cell dependencies defined in the formulas. Each of a plurality of different portions of the document is sent from a first computing system to a second computing system in an order determined from the hierarchy.
    Type: Application
    Filed: February 19, 2013
    Publication date: August 21, 2014
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Paul R. Bastide, Matthew E. Broomhall, Robert E. Loredo
  • Publication number: 20140229813
    Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.
    Type: Application
    Filed: April 15, 2014
    Publication date: August 14, 2014
    Applicant: MICROSOFT CORPORATION
    Inventors: Roy Simkhay, Charles D. Ellis, Alexander Babanov, David F. Gainer, Daniel P. Cory, Matthew J. Androski, Andrew J. Becker, Jeremy R. Pankratz, Monica McAmis, Simon Loftus Peyton Jones
  • Patent number: 8793566
    Abstract: A system and method for scheduling, managing and reporting usage of two or more training facilities by two or more grade levels xl of instruction with two or more classifications of instruction defining typical student experience and hours including user defined multi-criteria queries, using a computer and a spreadsheet with single cell data entry and specified formulas to generate particular scheduling, tracking and reporting of facilities scheduled and educational hours' completed with infinite levels of classification.
    Type: Grant
    Filed: November 9, 2011
    Date of Patent: July 29, 2014
    Assignee: Duquesne University of the Holy Spirit
    Inventor: Carole M. Brletic
  • Patent number: 8788928
    Abstract: A system and methodology for data processing combining stream processing and spreadsheet computation comprises: one or more Cloudscale Stream Processors (CSPs), a Cloudscale-enabled spreadsheet (including a plug-in module), a web services architecture, and one or more data sources. Each CSP takes a set of streams of input data and outputs a set of streams of data. Each stream is a time-ordered stream of files which when concatenated together comprise the stream. The Cloudscale-enabled spreadsheet is includes a plug in module that operates in conjunction with a spreadsheet program and one or more stream processors. The Cloudscale-enabled spreadsheet provides tools and technologies for user authentication, stream discovery, data source extraction and new stream design. It includes features for design of new stream processors, as well as features for checking and validation, cycle and synchronization controls for stream processors and spreadsheets.
    Type: Grant
    Filed: July 9, 2010
    Date of Patent: July 22, 2014
    Assignee: Clandscale, Inc.
    Inventors: William Finlay McColl, Antony Azio Faustini
  • Patent number: 8782508
    Abstract: A method is disclosed for data entry into the content of cells belonging to an output field, said data being expressed as a mathematical expression of the cell contents of at least one input field in a data multidimensional table used by a data management application.
    Type: Grant
    Filed: March 18, 2004
    Date of Patent: July 15, 2014
    Assignee: International Business Machines Corporation
    Inventor: Frederic Bauchot
  • Publication number: 20140173402
    Abstract: A computer system receives a request to combine tabular data of a first table with tabular data of a second table. The computer system creates a profile for the second table indicating organization of types of data within the second table. The computer system determines a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table indicated by the profile. The computer system adds the at least one data element to the second table based on the determined placement.
    Type: Application
    Filed: December 18, 2012
    Publication date: June 19, 2014
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Paul R. Bastide, Matthew E. Broomhall, Robert E. Loredo
  • Publication number: 20140173403
    Abstract: A computer system receives a request to combine tabular data of a first table with tabular data of a second table. The computer system creates a profile for the second table indicating organization of types of data within the second table. The computer system determines a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table indicated by the profile. The computer system adds the at least one data element to the second table based on the determined placement.
    Type: Application
    Filed: October 25, 2013
    Publication date: June 19, 2014
    Applicant: International Business Machines Corporation
    Inventors: Paul R. Bastide, Matthew E. Broomhall, Robert E. Loredo
  • Publication number: 20140164897
    Abstract: The present invention is an apparatus and method for constructing a Constraint-Choice-Action Matrix for making decisions based on constraints. Columns (in one matrix orientation) state conditions. The column header presents a partial boolean expression. Such variable expression may be any object or type, e.g., a number, string, or list. An entry in a cell, selected using a GUI pick-list, combines with the column header, to complete the boolean expression. The set of boolean expressions in a row may be combined into an action boolean statement. If that statement evaluates to true, some action, represented as a row header, is recommended or executed. The matrix is applied to an instance of a context domain, for decision-making. The context domain may be represented in a model representing an instance of that domain (e.g., a product specification for configuration of a machine) in data and rules.
    Type: Application
    Filed: May 30, 2013
    Publication date: June 12, 2014
    Applicant: CERTUSOFT, INC.
    Inventors: Sermet Yucel, William D. Headrick, Samuel E. Martin, M. Germana Paterlini
  • Publication number: 20140157098
    Abstract: By means of this system, the interaction among spreadsheets is completely integrated within the Spreadsheet Management System whereas it does not require the usage of other tools supporting the communication over a network such as web browsers, mailers, and file transfer clients. The interaction is implemented by the Enabling Platform, integrated within the Spreadsheet Management System, and by the Service Platform, located on a computing system that can be reached over the Internet or on a different private network making the Service Platform's intervention not visible to users.
    Type: Application
    Filed: December 2, 2013
    Publication date: June 5, 2014
    Inventor: Massimo Maresca
  • Patent number: 8726143
    Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.
    Type: Grant
    Filed: January 14, 2005
    Date of Patent: May 13, 2014
    Assignee: Microsoft Corporation
    Inventors: Roy Simkhay, Charles D. Ellis, Alexander Babanov, David F. Gainer, Daniel P. Cory, Matthew J. Androski, Andrew J. Becker, Jeremy R. Pankratz, Monica McAmis, Simon Loftus Peyton Jones
  • Patent number: 8713423
    Abstract: A request for differential data relative to a first data element within a group of data elements is received via a user input device. A first differential data value for each of the group of data elements relative to the first data element is calculated. The first differential data value for each of the group of data elements relative to the first data element are displayed on a display in response to the received request. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
    Type: Grant
    Filed: March 28, 2009
    Date of Patent: April 29, 2014
    Assignee: International Business Machines Corporation
    Inventor: Frank Lawrence Jania
  • Patent number: 8707156
    Abstract: A render engine for a spreadsheet application is described. The render engine facilitates the rendering of cell regions containing data that are maintained by both a spreadsheet application (user-defined cell region) and/or a third-party application (application-defined cell region). In particular, an embodiment of the render engine facilitates the repositioning of one or more existing cell regions within a spreadsheet interface, when the insertion of a new cell region is determined to cause a layout conflict with one or more existing cell regions. Repositioning of the existing cell regions is achieved without overwriting any cell information, and without breaking any formulas contained within an affected cell.
    Type: Grant
    Filed: April 2, 2009
    Date of Patent: April 22, 2014
    Assignee: Business Objects, S.A.
    Inventors: Wei Xue, Shuai Zhao, Leo Chi-Lok Yu
  • Patent number: 8677230
    Abstract: Methods and computerized apparatus for shared business modeling involving multiple spreadsheet-based business models in a network of computers, report generation involving consolidation from at least two different spreadsheet-based business models as well as report generation involving multiple different spreadsheet-based business models are described.
    Type: Grant
    Filed: September 15, 2011
    Date of Patent: March 18, 2014
    Assignee: Morgan Stanley
    Inventors: Milliken Fernandes, Robert I. Lee, Jr., Dragan Masnikosa, Supriya Samanta
  • Patent number: 8656271
    Abstract: A method for use with a spreadsheet includes storing a cell object, where the cell object includes a location in the spreadsheet of a cell to which the cell object relates and a process associated with the cell, and performing the process on a complex object to produce a result, where the complex object includes a construct comprised of data and code. A display is generated for the cell that is based on the result.
    Type: Grant
    Filed: July 31, 2006
    Date of Patent: February 18, 2014
    Assignee: SAP AG
    Inventors: Julien Jean-Pierre Vayssiere, Regis Francois Bernard Saint-Paul, Boualem Benatallah
  • Patent number: 8656270
    Abstract: The invention discloses a data organization method for a change oriented spreadsheet application. In one embodiment, the valid updates to cells and the update times are stored with the cell positions as the primary index, and the valid updates to the same cell are arranged in the order of time. In another embodiment, the valid updates to cells are stored with the update time points of the valid updates of the cells as the primary index, and all the valid updates at the same valid update time point are arranged into an update table, the update table having the same cell structure as the spreadsheet file. In yet another embodiment, data structures organized in both manners are maintained at the same time.
    Type: Grant
    Filed: August 16, 2007
    Date of Patent: February 18, 2014
    Assignee: International Business Machines Corporation
    Inventors: SuYing Rui, FengLi Wang, Jin Yu, Li Yu
  • Patent number: 8656348
    Abstract: A system including spreadsheet sheets, makes calculations and data transformations, which is available through a programming interface, and conforms to the grammar and syntax of a target software development language is presented. The system includes an Object Model with Data Structures representing entities involved in spreadsheets. The system includes a Parser and Code Generator that extracts data from a body of spreadsheet data, instantiates instances of Data Structures of the Object Model to represent the spreadsheet data, parses the data and formulas contained in the cells of the spreadsheets, iterates through the instantiated instances of the Data Structures, and generates source code that performs the calculations and data transformations embodied in the spreadsheet data. The system includes a Calculation Engine with software base classes that implement the common structural and data access features of spreadsheet data, and further implement the operations of common spreadsheet functions and operators.
    Type: Grant
    Filed: May 4, 2012
    Date of Patent: February 18, 2014
    Assignee: Knowledge Dynamics, Inc.
    Inventors: Michael R. Smialek, Michael H. Rubin
  • Patent number: 8621340
    Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.
    Type: Grant
    Filed: December 20, 2004
    Date of Patent: December 31, 2013
    Assignee: Microsoft Corporation
    Inventors: Joseph M. Chirilov, Dennis R. Newland, Eoin J. Burke, Hannah W. Zhou, John C. Haymond, Juha P. Niemisto, Robert C. Collie, Robert W. Coffen, Thao Moua
  • Publication number: 20130346844
    Abstract: Checking and/or completing for data grids is described such as for grids having rows and columns of cells at least some of which contain data values such as numbers or categories. In various embodiments predictive probability distributions are obtained from an inference engine for one or more of the cells and the predictive probability distributions are used for various tasks such as to suggest values to complete blank cells, highlight cells having outlying values, identify potential errors, suggest corrections to potential errors, identify similarities between cells, identify differences between cells, cluster rows of the data grid, and other tasks. In various embodiments a graphical user interface displays a data grid and provides facilities for completing, error checking/correcting, and analyzing data in the data grid.
    Type: Application
    Filed: June 22, 2012
    Publication date: December 26, 2013
    Applicant: MICROSOFT CORPORATION
    Inventors: Thore Graepel, Filip Radlinski, Andrew Donald Gordon, Pushmeet Kohli, John Winn, Lucas Bordeaux, Yoram Bachrach