Microsoft Technology Licensing, LLC

Stephen Van De Walker Handy

Allan Folting

Diego M Oppenheimer

Anatoly V Grabar

Amit Velingkar

Peter Birkedal Peterson

Corey James Hulen

Brent Michael Wilson

Scott Walter Bishel

Leif Christian Brenne

Carl Brenn Sutter, Iv

Weng Keong Peter Anthony Leong

Eric Friedrichsen

A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.

Automatic relationship detection for spreadsheet data items

A system and method for creating a report in a spreadsheet is disclosed. The system and method identifies a source of data items associated with the spreadsheet. The data items that are associated with the report that is generated in the spreadsheet are identified. A display including a field pane with an active tab and an all tab. The active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet. The all tab displaying all of the data items associated with the spreadsheet.

Selective generation and display of data items associated with a spreadsheet

Technologies are described herein for generating field sets of a data summary table. Multiple fields in a spreadsheet document are identified. Multiple field scores for each field of the plurality of fields are determined. A field set incorporating two or more of the plurality of fields is generated based on the plurality of field scores. The field set is inserted into the data summary table, thereby transforming the data summary table without the field set to the data summary table with the field set.

Automated suggested summarizations of data

A user interface is programmed to create a scorecard. The interface includes a scorecard module including a column area and a row area, and a key performance indicator area including a plurality of key performance indicators. A key performance indicator from the key performance indicator area can be dragged and dropped onto one of the column area and the row area to add indicia associated with the key performance indicator to the scorecard.

Key performance indicator scorecard editor

A user interface programmed to create a digital dashboard includes a dashboard workspace including one or more zones, and a dashboard elements area including a plurality of dashboard elements. A dashboard element of the dashboard elements is dragged and dropped onto one of the zones to add the dashboard element to the digital dashboard.

Growing community of inventors

Bremerton, WA, United States of America

Stephen Van De Walker Handy