Patents by Inventor Jeffrey James Duzak
Jeffrey James Duzak 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: 11886916Abstract: A method may include receiving an indication that a recalculation operation is to be completed for data stored in a data file; determining that a currently assigned number of threads for execution of the recalculation operation is lower than a target number of threads for the recalculation operation; requesting an additional thread for execution of the recalculation operation; beginning execution of the recalculation operation using the currently assigned number of threads; receiving an indication that the additional thread is available for execution of the recalculation operation; updating the currently assigned number of threads to include the additional thread; and continuing execution of the recalculation operation using the updated currently assigned number of threads.Type: GrantFiled: June 30, 2020Date of Patent: January 30, 2024Assignee: Microsoft Technology Licensing, LLCInventors: Prashant Anand Shirolkar, Bradley Scott Prugar, Jeffrey James Duzak, Qusai Bassam Saleam Al-Rabadi, Chae Seong Lim
-
Patent number: 11709993Abstract: Systems and methods are directed to providing efficient and fast invocation of concurrent sheet defined functions (SDFs) including dynamic arrays by front-loading the work. At SDF creation time, a SDF cell table, a formula table, and a spill area table are generated. The SDF cell table represents cells from a worksheet that are used for the SDF. The formula table comprises an index of formulas used by the SDF, whereby index identifiers are stored in cells of the SDF cell table. The spill area table comprises an index of spill areas where each dynamic array may automatically spill into. The SDF cell table, formula table, and spill area table are shared between a plurality of invocations of the SDF during invocation time.Type: GrantFiled: May 27, 2021Date of Patent: July 25, 2023Assignee: Microsoft Technology Licensing, LLCInventor: Jeffrey James Duzak
-
Patent number: 11699032Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for identifying a target value in a data set are presented. A request for a first target value in a data array may be received, wherein the request comprises first reference value. The data array may comprise a plurality of values and a plurality of value types included in one or more tables in a computer-implemented spreadsheet application. An index comprising a plurality of sorted reference numbers corresponding to a plurality of values in the data array may be generated based on the request. The index may be searched, and based at least on the search, the first reference value may be identified. In additional examples, the index may be cached and utilized to process additional target value requests that reference an overlapping range value with the first request.Type: GrantFiled: November 3, 2017Date of Patent: July 11, 2023Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Prashant Anand Shirolkar, George Randell Dong, Henry Nathan Shomber, Jeffrey James Duzak
-
Publication number: 20220382970Abstract: Systems and methods are directed to providing efficient and fast invocation of concurrent sheet defined functions (SDFs) including dynamic arrays by front-loading the work. At SDF creation time, a SDF cell table, a formula table, and a spill area table are generated. The SDF cell table represents cells from a worksheet that are used for the SDF. The formula table comprises an index of formulas used by the SDF, whereby index identifiers are stored in cells of the SDF cell table. The spill area table comprises an index of spill areas where each dynamic array may automatically spill into. The SDF cell table, formula table, and spill area table are shared between a plurality of invocations of the SDF during invocation time.Type: ApplicationFiled: May 27, 2021Publication date: December 1, 2022Inventor: Jeffrey James Duzak
-
Publication number: 20220318232Abstract: In various implementations, a calculation manger identifies one or more external references within a workbook, wherein the workbook resides in a spreadsheet environment comprising multiple workbooks. The recalculation manager then identifies a scope of a recalculation, triggered by an event in the workbook, based on one or more factors comprising the one or more external references. A recalculation engine then performs the recalculation within the identified scope.Type: ApplicationFiled: June 8, 2021Publication date: October 6, 2022Inventors: Prashant Anand SHIROLKAR, George Randell DONG, Alexander Yuryevich NOVOKHODKO, Jeffrey James DUZAK
-
Publication number: 20210406080Abstract: A method may include receiving an indication that a recalculation operation is to be completed for data stored in a data file; determining that a currently assigned number of threads for execution of the recalculation operation is lower than a target number of threads for the recalculation operation; requesting an additional thread for execution of the recalculation operation; beginning execution of the recalculation operation using the currently assigned number of threads; receiving an indication that the additional thread is available for execution of the recalculation operation; updating the currently assigned number of threads to include the additional thread; and continuing execution of the recalculation operation using the updated currently assigned number of threads.Type: ApplicationFiled: June 30, 2020Publication date: December 30, 2021Inventors: Prashant Anand Shirolkar, Bradley Scott Prugar, Jeffrey James Duzak, Qusai Bassam Saleam Al-Rabadi, Chae Seong Lim
-
Patent number: 10726201Abstract: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. As discussed herein, lambdas are user defined functions (UDFs) that are natively creatable and maintainable through the use of a lambda registry in the spreadsheet application. In an implementation, a method of handling lambdas in a spreadsheet application is disclosed. The method includes detecting that a cell of a spreadsheet is populated with an expression that defines a lambda function and registering the lambda function with a lambda registry corresponding to the spreadsheet. The registration includes recording a home cell that identifies a location of the cell of the spreadsheet where the lambda function is defined. The method further includes replacing the expression that defines the lambda function with a reference to the registered lambda function.Type: GrantFiled: June 29, 2018Date of Patent: July 28, 2020Assignee: Microsoft Technology Licensing, LLCInventors: Christopher John Gross, Jeffrey James Duzak, Andrew James Becker, Claudio Vittorio Russo, Andrew Donald Gordon
-
Patent number: 10496740Abstract: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. As discussed herein, lambdas are user defined functions (UDFs) that are natively creatable and maintainable through the use of a lambda registry in the spreadsheet application. In an implementation, a method of handling lambdas in a spreadsheet application is disclosed. The method includes detecting that a cell of a spreadsheet is populated with an expression that defines a lambda function and registering the lambda function with a lambda registry corresponding to the spreadsheet. The registration includes recording a home cell that identifies a location of the cell of the spreadsheet where the lambda function is defined. The method further includes replacing the expression that defines the lambda function with a reference to the registered lambda function.Type: GrantFiled: June 29, 2018Date of Patent: December 3, 2019Assignee: Microsoft Technology Licensing, LLCInventors: Christopher John Gross, Jeffrey James Duzak, Andrew James Becker, Claudio Vittorio Russo, Andrew Donald Gordon
-
Publication number: 20190138590Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for identifying a target value in a data set are presented. A request for a first target value in a data array may be received, wherein the request comprises first reference value. The data array may comprise a plurality of values and a plurality of value types included in one or more tables in a computer-implemented spreadsheet application. An index comprising a plurality of sorted reference numbers corresponding to a plurality of values in the data array may be generated based on the request. The index may be searched, and based at least on the search, the first reference value may be identified. In additional examples, the index may be cached and utilized to process additional target value requests that reference an overlapping range value with the first request.Type: ApplicationFiled: November 3, 2017Publication date: May 9, 2019Inventors: Prashant Anand Shirolkar, George Randell Dong, Henry Nathan Shomber, Jeffrey James Duzak
-
Publication number: 20090006466Abstract: Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a third party user defined value type that is incorporated into the spreadsheet as a supported data type. When the extensible value type is defined, an associated set of functions are developed to operate on the type. The spreadsheet manages instances of these extensible values such that they are properly maintained by the spreadsheet application while in use and released from memory when they are no longer in use.Type: ApplicationFiled: June 9, 2008Publication date: January 1, 2009Applicant: Microsoft CorporationInventors: Charles D. Ellis, Simon Loftus Petyon Jones, Jeffrey James Duzak, Joseph Matthew Chirilov, Andrew Becker