Microsoft Technology Licensing, LLC

Other

Energysavvy Inc.

Microsoft Corporation

Charles David Ellis

David Francis Gainer

Robert G Hawking

Matthew John Androski

Samuel C Radakovitz

Brandon G Weber

Andrew James Becker

Simon Peyton-Jones

Dave McDonald

Carlos Augusto Otero

Dominique Fortier

Alexander A Babanov

Liyin Xue

Roy Simkhay

Yonghong Zeng

Eran Megiddo

Daniel Cory

Benjamin C Chamberlain

Robert C Collie

Juha P Niemisto

Howard J Dickerman

Liviu Asnash

Catherine William Neylan

Jakob Peter Nielsen

Joseph M Chirilov

Ira Levin

Dan Y Khen

Simon Loftus Peyton Jones

Ashvini Sharma

Chris L Rae

Jeremy R Pankratz

Monica McAmis

Simon James Jones

Eric Barber Vigesaa

Allan Folting

Bruce Cordell Jones

Ravi Chandru Shahani

Michael V Calcagno

Nicholas Caldwell

Su Chin Chang

Aaron Ross Goldfeder

Christopher M Street

Jeffrey James Duzak

Michael Joe Woolf

Ehab Sobhy Deraz

Safiya Bhojawala

Weide Zhong

Charles Strempler

Brian W Boon

Tom Hoke

Kaicheng Hu

Paavany Jayanty

Matthew Willem Asplund

Sameer Surendra Jagdale

Leonid Borisovich Shklovskii

Mark Louis Ghazal

Brett Clouser

Mark Dalin Parris

Minggiang Xu

Yonghong Zhen

Robert Stumberger

David E Gainer

Mathew B Olinger

Andrew J Becker

Matthew J Androski

Systems, methods, and software for mobile data visualization frameworks are provided herein. An exemplary method includes, determining data insight candidates for presentation on the mobile computing device that describe analysis of a target dataset, determined based at least on data analysis preferences associated with processing one or more past datasets, and where each of the data insight candidates includes at least one insight object directed to the target dataset and is described by object metadata that indicates at least a processing lineage used to produce the at least one insight object. The method includes selecting a presentation detail level for displaying the data insight candidates on the mobile computing device based at least on properties of the mobile computing device, and generating one or more insight views for presentation on the mobile computing device.

Mobile data insight platforms for data analysis

Systems, methods, and software for developing application usage information are provided herein. An exemplary method includes identifying data sources that relate to application usage activity of one or more users, determining activity signals related to at least data analysis by the one or more users from among the application usage activity, and applying the activity signals to a knowledge graphing service that infers data analysis preferences from among the activity signals. The method also includes providing ones of the data analysis preferences for use by data insight services that establish data insight objects visualizing target datasets based at least on the ones of the data analysis preferences.

Application usage signal inference and repository

In non-limiting examples of the present disclosure, systems, methods and devices for assisting with providing dataset insights associated with datasets are presented. A dataset and a query relating to the dataset may be received. The dataset may be processed to determine metadata that describes one or more properties of the dataset. The dataset, the determined metadata, and the user query may be provided to one or more modular recommendation elements for processing into an insight result that indicates a result from data analysis directed to the query. The insight result may be transferred in a portable format for use by the productivity application in displaying one or more insight objects based on the insight result.

Modular data insight handling for user application data

Systems, methods, and software for data visualization frameworks are provided herein. An exemplary method includes identifying a target dataset from which to determine data insights for presentation in an insight interface to the user application. The method includes determining data insight candidates for the target dataset based at least on usage modalities associated with processing one or more past datasets, and establishing content of the data insight candidates according to at least the target dataset and the usage modalities, where the content of each of the data insight candidates includes at least one insight object described by object metadata that indicates at least a processing lineage used to produce the at least one insight object.

Insight objects as portable user application objects

The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.

Filter and sort by format

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.

System and method for a spreadsheet application supporting diverse formulaic functions

A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

Method, system, and apparatus for providing access to workbook models through remote function calls

Embodiments are directed towards automatic provisional evaluation of utility program performance. Treatment facilities may be determined depending characteristics of a project. A performance profile corresponding to each treatment facility may be generated based on historical information corresponding to each treatment facility. Current usage information and current weather information for each treatment facility may be determined. Pre-treatment usage information that corresponds to each treatment facility may be determined based on the performance profile and the current usage information and the current weather information. A program evaluation report may be generated that includes program realization information. Program realization information may be based on an aggregation of project savings information that corresponds to the treatment facilities. Project savings information may be modified based on confidence weights. A program evaluation report may include information from one or more comparison facilities.

Real time provisional evaluation of utility program performance

Sorting spreadsheet data by format

A framework for enabling users to create User Defined Functions (UDFs), which can run simultaneously without using multiple calculation threads, is provided. A calculation engine continues a remainder of calculation operations independent of a pending asynchronous function upon starting to run the asynchronous function without waiting to receive a result. The result value is introduced to the computation at a later time during the calculation cycle, when it is received or completed by the calculation engine. When the results are received, downstream operations such as dependent functions are calculated without changing a flow of dependencies within the operations.

Asynchronous user defined functions

Method, system, and apparatus for providing access to workbook models through remote function cells

Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included in one or more spreadsheets. A graphical user interface is also described that provides simple user access to existing table styles that can be modified according to the user's requirements.

Customizable spreadsheet table styles

Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a user defined value type that is incorporated into the spreadsheet as a supported data type. Generally, the extensible data types provide support for types that are not internally defined by a spreadsheet. When the extensible value type is defined, an associated set of functions are developed to operate on the type. These functions are added to the set of base functions supported by the spreadsheet. The functions, therefore, behave in a substantially similar manner to the set of base spreadsheet functions. The extensible values that are contained within the cells may be acted upon in the same way that supported base types are acted upon.

Extensible value types in cells

Growing community of inventors

Seattle, WA, United States of America

Charles David Ellis