Generating scenes and tours in a spreadsheet application

• US 10,008,015 B2
• Filed: 03/14/2016
• Issued: 06/26/2018
• Est. Priority Date: 08/10/2012
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Ruble, B. Scott, Sobhy, Ehab, Peev, Igor Borisov, Wong, Curtis G., Payne, John Alfred, Fay, Jonathan Edgar, Fan, Kevin
• Primary Examiner(s): KELLS, ASHER
• Application Number:
  US15/069,166
• Publication Number:
  US 20160196674A1
• Time in Patent Office: 834 Days
• Field of Search: None
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06F 16/4393 Multimedia presentations, e.g. slide shows, multimedia albums
• CPC Class Codes: G06F 16/444 Spatial browsing, e.g. 2D maps, 3D or virtual spaces
• CPC Class Codes: G06F 16/50 of still image data
• CPC Class Codes: G06F 16/9038 Presentation of query results
• CPC Class Codes: G06F 16/9537 Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
• CPC Class Codes: G06F 3/01 Input arrangements or combined input and output arrangements for interaction between user and computer G06F3/16 takes precedence
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 3/04815 Interaction with a metaphor-based environment or interaction object displayed as three-dimensional, e.g. changing the user viewpoint with respect to the environment or object
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 3/0488 using a touch-screen or digitiser, e.g. input of commands through traced gestures
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06F 40/169 Annotation, e.g. comment data or footnotes
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06T 11/206 : Drawing of charts or graphs
• CPC Class Codes: G06T 13/00 : Animation
• CPC Class Codes: G06T 15/00 : 3D [Three Dimensional] image rendering
• CPC Class Codes: G06T 15/10 : Geometric effects
• CPC Class Codes: G06T 19/00 : Manipulating 3D models or images for computer graphics

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

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

creating a tour at a computer system executing a visualization component, wherein the tour includes an animated sequence of scenes, the creating comprising;

generating the scenes to visualize respective views of a data set based on location information included in the data set; and

establishing the scenes as the respective views within the tour, wherein timing of the respective views in the tour is based on temporal information included in the data set;

generating an additional scene, the additional scene comprising an additional view of the data set, the data set comprising spreadsheet data obtained from a data source in communication with the computer system, wherein the additional scene indicates a set of values of location information from the additional view;

adding the additional scene to the tour, wherein the additional scene is added at a position in the animated sequence based on the temporal information from the additional view; 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 (UI) comprising a tour explorer window, the tour explorer window comprising a UI control which, when selected, will cause the tour to be created, another UI control which, when selected, will cause the scene to be added to the tour, and a play control for playing the tour.

3. The method of claim 2, further comprising:

detecting selection of the play control;

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.

4. The method of claim 1, wherein the scene further comprises an effect, the effect comprising a still effect, an orbit effect, a fly-by effect, a figure eight idle effect, a fly-over effect, or a push-in effect.

5. The method of claim 2, wherein the tour explorer window comprises:

a thumbnail corresponding to the scene;

a further thumbnail corresponding to a 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.

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, wherein the transition comprises an arc transition.

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

8. 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;

create a tour, wherein the tour includes an animated sequence of scenes, and wherein the operations to create the tour;

generate the scenes to visualize respective views of a data set based on location information included in the data set, and

establish the scenes as the respective views within the tour, wherein timing of the respective views in the tour is based on temporal information included in the data set,

generate an additional scene, the scene comprising an additional view of the data set, the data set comprising spreadsheet data obtained from a data source in communication with the apparatus, wherein the scene indicates a set of values of location information from the additional view,

add the additional scene to the tour, wherein the additional scene is added at a position in the animated sequence based on the temporal information from the additional view, and

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

9. The apparatus of claim 8, wherein the computer storage medium has further computer readable instructions stored thereupon to detect a selection of a start time and an end time of the tour.

10. The apparatus of claim 8, wherein the scene further comprises an effect, the effect adjusted based on the analysis of the data.

11. The apparatus of claim 8, wherein the computer storage medium has further computer readable instructions stored thereupon to generate a user interface (IA) comprising a tour explorer window, the tour explorer window comprising a Iii control which, when selected, will cause the tour to be created, another UI control which, when selected, will cause the scene to be added to the tour, and a play control for playing the tour.

12. The apparatus of claim 11, wherein the computer storage medium has further computer readable instructions stored thereupon to:

detect selection of the play control;

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

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

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

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

13. The apparatus of claim 8, wherein the tour is automatically generated based upon an analysis of the spreadsheet data.

14. The apparatus of claim 8, wherein the computer storage medium has further computer readable instructions stored thereupon to:

analyze the spreadsheet data to determine a nexus of the data; and

start the tour at the nexus of the data.

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

create a tour, wherein the tour includes an animated sequence of scenes, and wherein the operations to create the tour;

generate the scenes to visualize respective views of a data set based on location information included in the data set; and

establish the scenes as the respective views within the tour, wherein timing of the respective views in the tour is based on temporal information included in the data set;

generate a first scene, the first scene comprising a first view of the data set, the data set comprising spreadsheet data obtained from a data source in communication with the computer, wherein the first scene indicates a set of values of location information from the first view;

add the first scene to the tour, wherein the first scene is added at a position in the animated sequence based on the temporal information from the first view; and

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

16. The computer storage medium of claim 15, having further computer readable instructions stored thereupon to determine a tour time that specifies a duration of the tour.

17. The computer storage medium of claim 16, having further computer readable instructions stored thereupon to adjust a time component of the spreadsheet data based on the determination of the tour time.

18. The computer storage medium of claim 15, wherein the scene comprises an effect, the effect comprising a still effect, an orbit effect, a fly-by effect, a figure eight idle effect, a fly-over effect, or a push-in effect.

19. The computer storage medium of claim 15, wherein the tour is automatically generated based upon an analysis of the spreadsheet data.

20. The computer storage medium of claim 19, having further computer readable instructions stored thereupon to:

analyze the spreadsheet data to determine a nexus of the data; and

start the tour at the nexus of the data.