IP Library Granted Patent US 9,317,963
Granted Patent B2
US 9,317,963 · App. 13/898,469 · Granted Apr 19, 2016

Generating scenes and tours in a spreadsheet application

Inventors: B. Scott Ruble (Bellevue, WA); Ehab Sobhy (Redmond, WA); Igor Borisov Peev (Arlington, WA); Curtis G. Wong (Medina, WA); John Alfred Payne (Seattle, WA); Jonathan Edgar Fay (Woodinville, WA); Kevin Fan (Seattle, WA)
Assignee: Microsoft Technology Licensing, LLC
G06T15/10G06F3/01G06F3/048G06F3/0488G06F3/04815G06F3/04842G06F17/24G06F17/241G06F17/246G06F17/30056G06F17/30061G06F17/3087G06F17/30241G06F17/30244G06F17/30551G06F17/30554G06F17/30572G06F17/30991G06T11/206G06T13/00G06T15/00G06T19/00
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,317,963
App. No.
13/898,469
Granted
Apr 19, 2016
Kind
B2
Abstract

Concepts and technologies are described herein for generating scenes and tours in a spreadsheet application. In accordance with the concepts and technologies disclosed herein, a computer system executes a visualization component. Selection of an option to create a tour can be detected by the computer system. In response to detecting selection of the option, the computer system can create a tour. The computer system also can detect selection of an option to add a scene to the tour. The tour can be saved. Playback of the tour can be started in response to detecting selection of a play option. If the playback is paused, changes made to the tour and/or the scenes can be tracked by the computer system, and an updated version of the tour can be saved.

Claims (54)

1. A computer-implemented method for creating a visualization of data, the computer-implemented method comprising performing computer-implemented operations for:

detecting, at a computer system executing a visualization component, selection of an option to create a tour;

in response to detecting the selection of the option, creating, at the computer system, the tour;

detecting, at the computer system, selection of a further option to add a scene to the tour, the scene comprising a view of data having data values, temporal information, an effect, and location information, the data comprising spreadsheet data obtained from a data source in communication with the computer system;

in response to detecting the selection of the further option, adding the scene to the tour; and

saving, by the computer system, the tour as an updated version of the spreadsheet data.

2. The method of claim 1 , further comprising generating a user interface comprising a tour explorer window, the tour explorer window comprising:

a thumbnail corresponding to the scene;

a caption that is editable to modify a name of the tour; and

a thumbnail caption that is editable to modify a name of the scene.

3. The method of claim 2 , wherein the user interface further comprises the option to create the tour, the option to add the scene to the tour, and a play control for playing the tour.

4. The method of claim 3 , further comprising:

in response to detecting selection of the play control, beginning playing of the tour;

presenting playback controls during playing of the tour, the playback controls comprising a back control;

detecting selection of the back control to initiate an edit mode; and

in response to determining that changes are made to the tour during the edit mode, saving an updated version of the tour.

5. The method of claim 1 , wherein the effect comprises one or more of a still effect, an orbit effect, a fly-by effect, a figure 8 idle effect, a fly-over effect, and a push-in effect.

6. The method of claim 1 , further comprising:

determining if a further scene is to be added to the tour;

in response to determining that the further scene is to be added, adding the further scene to the tour; and

adding a transition between the scene and the further scene.

7. The method of claim 6 , further comprising generating a user interface comprising a tour explorer window, the tour explorer window comprising:

a thumbnail corresponding to the scene;

a further thumbnail corresponding to the further scene;

a caption that is editable to modify a name of the tour; and

thumbnail captions that are editable to modify a name of at least one of the scene or the further scene.

8. The method of claim 7 , further comprising detecting, at the user interface, input for reordering scenes of the tour, the scenes comprising the scene and the further scene.

9. The method of claim 6 , wherein the transition comprises a cut transition and an arc transition.

10. The method of claim 1 , wherein saving the tour comprises exporting a video file corresponding to the tour.

11. An apparatus comprising:

a processor; and

a computer storage medium having computer readable instructions stored thereon that, when executed by the processor, cause the apparatus to

detect selection of an option to create an auto tour,

in response to detecting the selection of the option, create the auto tour by adding a scene to the tour, the scene comprising a view of data having data values, temporal information, an effect, and location information, the data comprising spreadsheet data obtained from a data source in communication with the apparatus, and

save the tour as an updated version of the spreadsheet data.

12. The apparatus of claim 11 , further comprising computer readable instructions that, when executed by the processor, cause the apparatus to detect a selection of a start time and an end time of the auto tour.

13. The apparatus of claim 11 , further comprising computer readable instructions that, when executed by the processor, cause the apparatus to analyze the data to determine a start location.

14. The apparatus of claim 13 , further comprising computer readable instructions that, when executed by the processor, cause the apparatus to adjust the effect based on the analysis of the data.

15. The apparatus of claim 11 , further comprising computer readable instructions that, when executed by the processor, cause the apparatus to:

determine if a further scene is to be added to the tour;

in response to determining that the further scene is to be added, add the further scene to the tour;

add a transition between the scene and the further scene; and

save an updated version of the tour.

16. A computer storage medium having computer readable instructions stored thereon that, when executed by a computer, cause the computer to:

detect selection of an option to create a tour;

in response to detecting the selection of the option, create the tour; generate a user interface comprising a further option to add a first scene and a second scene to the tour, the first scene and the second scene comprising a view of spreadsheet data having data values, temporal information, and location information;

present the user interface;

detect a selection of the further option;

in response to detecting the selection of the further option, add the first scene and the second scene to the tour, generate a tour explorer window comprising a thumbnail corresponding to the first scene and the second scene, add an effect to the first scene and the second scene, add a transition between the first scene and the second scene, and present the tour explorer window; and

save the tour.

17. The computer storage medium of claim 16 , further comprising computer readable instructions that, when executed by the computer, cause the computer to determine a tour time that specifies the duration of the tour.

18. The computer storage medium of claim 17 , further comprising computer readable instructions that, when executed by the computer, cause the computer to adjust a data time based on the determination of the tour time.

19. The computer storage medium of claim 16 , wherein the effect comprises one or more of a still effect, an orbit effect, a fly-by effect, a figure eight idle effect, a fly-over effect, or a push-in effect.

20. The computer storage medium of claim 16 , wherein the transition comprises a cut transition or an arc transition.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 9, 2014
From: MICROSOFT CORPORATION
To: MICROSOFT TECHNOLOGY LICENSING, LLC
Reel/Frame 034544/0541 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 21, 2013
From: RUBLE, B. SCOTT; SOBHY, EHAB; PEEV, IGOR BORISOV; WONG, CURTIS G.; PAYNE, JOHN ALFRED; FAY, JONATHAN EDGAR; FAN, KEVIN
To: MICROSOFT CORPORATION
Reel/Frame 030453/0215 →
Continuity (2)
Provisional Application 61681851 · Aug 10, 2012
Related Publication 20140047328A1 · Feb 13, 2014