Patents by Inventor Howard J. Dickerman

Howard J. Dickerman has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Patent number: 11366960
    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: August 3, 2020
    Date of Patent: June 21, 2022
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
  • Publication number: 20210019472
    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: Application
    Filed: August 3, 2020
    Publication date: January 21, 2021
    Inventors: Howard J. DICKERMAN, Marius DUMITRU, Akshai MIRCHANDANI, Yutong (Jeffrey) WANG, Amir NETZ, Paul J. SANDERS
  • Patent number: 10853040
    Abstract: Systems and devices for coordinating heterogeneous processes of a software application to comply with multiple address spaces or other computing system constraints are disclosed. In an example, operations for coordinating data processing among multiple processes of a software application include: executing a first process of the software application, as the first process operates with a first capability that is limited to an operational constraint of the computing system; initiating a second process of the software application, as the second process is initiated as a child of the first process, and as the second process operates with a second capability that exceeds the operational constraint of the computing system; communicating data from the first process of the software application to the second process; and receiving data from the second process of the software application, in response to the data being processed by the data analysis operations of the second process.
    Type: Grant
    Filed: March 31, 2017
    Date of Patent: December 1, 2020
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Anatoly V. Grabar, Howard J. Dickerman, Venkata S. Irava, Joshua J. Burkholder
  • Patent number: 10846289
    Abstract: In various embodiments, methods and systems for cross-filtering based on configurable direct relationships are provided. A selection of a first endpoint of a first table and a second endpoint of a second table is received. A direct relationship object is configured between the first table and the second table based on the first endpoint and the second endpoint. A cross-filtering direction and endpoint cardinality settings can also be configured for the direct relationship object. The direct relationship object may be configured as a many-to-one, one-to-many, or one-to-one. Automatic cross-filtering is configurable and can be set to cross-filter in one direction, the reverse direction, or both directions, with bidirectional cross filtering being a default configuration. The direct relationship object between the first endpoint and the second is configurable, such that, cross-filtering the first table and the second table to select rows for cross-filtering results is based on the cross-filtering direction.
    Type: Grant
    Filed: February 20, 2018
    Date of Patent: November 24, 2020
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Yutong Wang, Anand Bheemarajaiah, Xiaoqing Tang, Srinivasan S. Turuvekere, Howard J. Dickerman, Marius Dumitru
  • Patent number: 10762289
    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: May 11, 2017
    Date of Patent: September 1, 2020
    Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
  • Publication number: 20180285152
    Abstract: Systems and devices for coordinating heterogeneous processes of a software application to comply with multiple address spaces or other computing system constraints are disclosed. In an example, operations for coordinating data processing among multiple processes of a software application include: executing a first process of the software application, as the first process operates with a first capability that is limited to an operational constraint of the computing system; initiating a second process of the software application, as the second process is initiated as a child of the first process, and as the second process operates with a second capability that exceeds the operational constraint of the computing system; communicating data from the first process of the software application to the second process; and receiving data from the second process of the software application, in response to the data being processed by the data analysis operations of the second process.
    Type: Application
    Filed: March 31, 2017
    Publication date: October 4, 2018
    Inventors: Anatoly V. Grabar, Howard J. Dickerman, Venkata S. Irava, Joshua J. Burkholder
  • Publication number: 20180173752
    Abstract: In various embodiments, methods and systems for cross-filtering based on configurable direct relationships are provided. A selection of a first endpoint of a first table and a second endpoint of a second table is received. A direct relationship object is configured between the first table and the second table based on the first endpoint and the second endpoint. A cross-filtering direction and endpoint cardinality settings can also be configured for the direct relationship object. The direct relationship object may be configured as a many-to-one, one-to-many, or one-to-one. Automatic cross-filtering is configurable and can be set to cross-filter in one direction, the reverse direction, or both directions, with bidirectional cross filtering being a default configuration. The direct relationship object between the first endpoint and the second is configurable, such that, cross-filtering the first table and the second table to select rows for cross-filtering results is based on the cross-filtering direction.
    Type: Application
    Filed: February 20, 2018
    Publication date: June 21, 2018
    Inventors: Yutong WANG, Anand BHEEMARAJAIAH, Xiaoqing TANG, Srinivasan S. TURUVEKERE, Howard J. DICKERMAN, Marius DUMITRU
  • Patent number: 9922081
    Abstract: In various embodiments, methods and systems for cross-filtering based on configurable direct relationships are provided. A selection of a first endpoint of a first table and a second endpoint of a second table is received. A direct relationship object is configured between the first table and the second table based on the first endpoint and the second endpoint. A cross-filtering direction and endpoint cardinality settings can also be configured for the direct relationship object. The direct relationship object may be configured as a many-to-one, one-to-many, or one-to-one. Automatic cross-filtering is configurable and can be set to cross-filter in one direction, the reverse direction, or both directions, with bidirectional cross filtering being a default configuration. The direct relationship object between the first endpoint and the second is configurable, such that, cross-filtering the first table and the second table to select rows for cross-filtering results is based on the cross-filtering direction.
    Type: Grant
    Filed: June 11, 2015
    Date of Patent: March 20, 2018
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Yutong Wang, Anand Bheemarajaiah, Xiaoqing Tang, Srinivasan S. Turuvekere, Howard J. Dickerman, Marius Dumitru
  • Publication number: 20180032498
    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: Application
    Filed: May 11, 2017
    Publication date: February 1, 2018
    Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
  • Patent number: 9665555
    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: January 15, 2016
    Date of Patent: May 30, 2017
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
  • Publication number: 20160364448
    Abstract: In various embodiments, methods and systems for cross-filtering based on configurable direct relationships are provided. A selection of a first endpoint of a first table and a second endpoint of a second table is received. A direct relationship object is configured between the first table and the second table based on the first endpoint and the second endpoint. A cross-filtering direction and endpoint cardinality settings can also be configured for the direct relationship object. The direct relationship object may be configured as a many-to-one, one-to-many, or one-to-one. Automatic cross-filtering is configurable and can be set to cross-filter in one direction, the reverse direction, or both directions, with bidirectional cross filtering being a default configuration. The direct relationship object between the first endpoint and the second is configurable, such that, cross-filtering the first table and the second table to select rows for cross-filtering results is based on the cross-filtering direction.
    Type: Application
    Filed: June 11, 2015
    Publication date: December 15, 2016
    Inventors: YUTONG WANG, ANAND BHEEMARAJAIAH, XIAOQING TANG, SRINIVASAN S. TURUVEKERE, HOWARD J. DICKERMAN, MARIUS DUMITRU
  • Publication number: 20160132481
    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: Application
    Filed: January 15, 2016
    Publication date: May 12, 2016
    Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
  • 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: 8234293
    Abstract: An autocomplete method and system provides suggested completions for partial data entries based upon predefined coordinates, operands and/or commands. In one embodiment, the partial data entry may be in an active cell of a spreadsheet and the predefined coordinates may be queried from a separate, preconfigured, multi-dimensional database linked to the active cell or the spreadsheet.
    Type: Grant
    Filed: September 8, 2005
    Date of Patent: July 31, 2012
    Assignee: Microsoft Corporation
    Inventors: Alexander Martynov, David F. Gainer, Howard J. Dickerman
  • Publication number: 20110087954
    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: Application
    Filed: October 9, 2009
    Publication date: April 14, 2011
    Applicant: Microsoft Corporation
    Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
  • Publication number: 20100312748
    Abstract: Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
    Type: Application
    Filed: August 6, 2010
    Publication date: December 9, 2010
    Applicant: MICROSOFT CORPORATION
    Inventors: Howard J. Dickerman, Brian W. Boon, Charles D. Ellis, Kaicheng Hu, Robert G. Hawking
  • Patent number: 7805433
    Abstract: Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
    Type: Grant
    Filed: October 14, 2005
    Date of Patent: September 28, 2010
    Assignee: Microsoft Corporation
    Inventors: Howard J. Dickerman, Brian W. Boon, Charles D. Ellis, Kaicheng Hu, Robert G. Hawking
  • Patent number: 7792847
    Abstract: Data corresponding to a structured report or multi-dimensional presentation is converted to formulas within cells of a spreadsheet. The cell formulas operate on a multi-dimension database that was the data source for the structured report. Therefore the layout of the data in the cells is similar to the layout of the data in structured report. The user is able to move the formulas around in the spreadsheet resulting in any custom layout the user desires. Because the data is no longer in a structured report, it is no longer subject to the layout restrictions of the report.
    Type: Grant
    Filed: November 7, 2005
    Date of Patent: September 7, 2010
    Assignee: Microsoft Corporation
    Inventors: Howard J. Dickerman, Kaicheng Hu, Robert G. Hawking
  • Patent number: 7693860
    Abstract: The present invention generally relates to new and improved embodiments of methods and systems for capturing and providing arbitrarily rich data to be stored or manipulated within a spreadsheet. In one embodiment of the present invention, a method for creating spreadsheet metadata comprises receiving an item in a spreadsheet, receiving item metadata about the item, and associating the item metadata with the item to create spreadsheet metadata.
    Type: Grant
    Filed: March 18, 2005
    Date of Patent: April 6, 2010
    Assignee: Microsoft Corporation
    Inventors: Alexander A. Babanov, Charles D. Ellis, Howard J. Dickerman, Robert G. Hawking
  • Patent number: 7653731
    Abstract: Embodiments of present application treat Connection Information Files contained in an instance of an application, such as a workbook, as independent objects and multiple data objects, such as data summary tables, may link to one Connection Information File. Maintaining Connection Information Files as independent objects within an instance of an application provides the ability to modify a connection to an external data source and have that modification applied to all linked data objects without having to modify each data object individually. Additionally, a user may view a complete list of all Connection Information Files that exist within a workbook and easily add, delete, or modify those Connection Information Files.
    Type: Grant
    Filed: February 24, 2006
    Date of Patent: January 26, 2010
    Assignee: Microsoft Corporation
    Inventors: Alexander Martynov, Brian Boon, Howard J Dickerman, Patrick J King