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: 11366960Abstract: 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: GrantFiled: August 3, 2020Date of Patent: June 21, 2022Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
-
Publication number: 20210019472Abstract: 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: ApplicationFiled: August 3, 2020Publication date: January 21, 2021Inventors: Howard J. DICKERMAN, Marius DUMITRU, Akshai MIRCHANDANI, Yutong (Jeffrey) WANG, Amir NETZ, Paul J. SANDERS
-
Patent number: 10853040Abstract: 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: GrantFiled: March 31, 2017Date of Patent: December 1, 2020Assignee: Microsoft Technology Licensing, LLCInventors: Anatoly V. Grabar, Howard J. Dickerman, Venkata S. Irava, Joshua J. Burkholder
-
Patent number: 10846289Abstract: 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: GrantFiled: February 20, 2018Date of Patent: November 24, 2020Assignee: Microsoft Technology Licensing, LLCInventors: Yutong Wang, Anand Bheemarajaiah, Xiaoqing Tang, Srinivasan S. Turuvekere, Howard J. Dickerman, Marius Dumitru
-
Patent number: 10762289Abstract: 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: GrantFiled: May 11, 2017Date of Patent: September 1, 2020Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
-
Publication number: 20180285152Abstract: 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: ApplicationFiled: March 31, 2017Publication date: October 4, 2018Inventors: Anatoly V. Grabar, Howard J. Dickerman, Venkata S. Irava, Joshua J. Burkholder
-
Publication number: 20180173752Abstract: 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: ApplicationFiled: February 20, 2018Publication date: June 21, 2018Inventors: Yutong WANG, Anand BHEEMARAJAIAH, Xiaoqing TANG, Srinivasan S. TURUVEKERE, Howard J. DICKERMAN, Marius DUMITRU
-
Patent number: 9922081Abstract: 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: GrantFiled: June 11, 2015Date of Patent: March 20, 2018Assignee: Microsoft Technology Licensing, LLCInventors: Yutong Wang, Anand Bheemarajaiah, Xiaoqing Tang, Srinivasan S. Turuvekere, Howard J. Dickerman, Marius Dumitru
-
Publication number: 20180032498Abstract: 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: ApplicationFiled: May 11, 2017Publication date: February 1, 2018Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
-
Patent number: 9665555Abstract: 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: GrantFiled: January 15, 2016Date of Patent: May 30, 2017Assignee: Microsoft Technology Licensing, LLCInventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
-
Publication number: 20160364448Abstract: 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: ApplicationFiled: June 11, 2015Publication date: December 15, 2016Inventors: YUTONG WANG, ANAND BHEEMARAJAIAH, XIAOQING TANG, SRINIVASAN S. TURUVEKERE, HOWARD J. DICKERMAN, MARIUS DUMITRU
-
Publication number: 20160132481Abstract: 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: ApplicationFiled: January 15, 2016Publication date: May 12, 2016Inventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
-
Patent number: 9275031Abstract: 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: GrantFiled: October 9, 2009Date of Patent: March 1, 2016Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
-
Patent number: 8234293Abstract: 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: GrantFiled: September 8, 2005Date of Patent: July 31, 2012Assignee: Microsoft CorporationInventors: Alexander Martynov, David F. Gainer, Howard J. Dickerman
-
Publication number: 20110087954Abstract: 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: ApplicationFiled: October 9, 2009Publication date: April 14, 2011Applicant: Microsoft CorporationInventors: Howard J. Dickerman, Marius Dumitru, Akshai Mirchandani, Yutong (Jeffrey) Wang, Amir Netz, Paul J. Sanders
-
Publication number: 20100312748Abstract: 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: ApplicationFiled: August 6, 2010Publication date: December 9, 2010Applicant: MICROSOFT CORPORATIONInventors: Howard J. Dickerman, Brian W. Boon, Charles D. Ellis, Kaicheng Hu, Robert G. Hawking
-
Patent number: 7805433Abstract: 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: GrantFiled: October 14, 2005Date of Patent: September 28, 2010Assignee: Microsoft CorporationInventors: Howard J. Dickerman, Brian W. Boon, Charles D. Ellis, Kaicheng Hu, Robert G. Hawking
-
Patent number: 7792847Abstract: 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: GrantFiled: November 7, 2005Date of Patent: September 7, 2010Assignee: Microsoft CorporationInventors: Howard J. Dickerman, Kaicheng Hu, Robert G. Hawking
-
Patent number: 7693860Abstract: 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: GrantFiled: March 18, 2005Date of Patent: April 6, 2010Assignee: Microsoft CorporationInventors: Alexander A. Babanov, Charles D. Ellis, Howard J. Dickerman, Robert G. Hawking
-
Patent number: 7653731Abstract: 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: GrantFiled: February 24, 2006Date of Patent: January 26, 2010Assignee: Microsoft CorporationInventors: Alexander Martynov, Brian Boon, Howard J Dickerman, Patrick J King