Displaying temporal information in a spreadsheet application

Patent metadata

Field	Value
Publication number	US-9881396-B2
Application number	US-201313856116-A
Country	US
Kind code	B2
Filing date	Apr 3, 2013
Priority date	Aug 10, 2012
Publication date	Jan 30, 2018
Grant date	Jan 30, 2018

Abstract

Concepts and technologies are described herein for displaying temporal information in a spreadsheet application. In accordance with the concepts and technologies disclosed herein, spreadsheet data can be obtained at a computer system. The spreadsheet data can include data values, temporal information, and geographic information. The computer system can generate a visualization of the spreadsheet data based, at least partially, upon the data values, the temporal information, and the geographic location information. The computer system also can output the visualization.

First claim

We claim:

1. A computer-implemented method for displaying temporal information in a spreadsheet application, the computer-implemented method comprising performing computer-implemented operations for:
obtaining, at a computer system executing a visualization component, spreadsheet data including data values, the temporal information, and geographic location information;
generating, by the computer system, a visualization of the spreadsheet data based, at least partially, upon the data values, the geographic location information, and the temporal information by
determining if the visualization is to include a time decay in which a data point of the spreadsheet data is persisted beyond a time associated with the data point, and
in response to a determination that the visualization is to include the time decay, determining a duration of the time decay and generating animation frames of the visualization with the time decay;

determining, by the computer system, a time range for the visualization, the time range comprising a duration of time between a start time and an end time;
determining, based upon the time range, an animation speed for the visualization; and
outputting, by the computer system, the visualization.

2. The method of claim 1 , wherein the animation speed is bound to the time range, and wherein generating the visualization based upon the temporal information comprises generating animation frames of the visualization based, at least partially, upon the time range and the animation speed.

3. The method of claim 1 , wherein generating the visualization based upon the temporal information comprises:
determining if the visualization is to include time accumulation whereby a plurality of data values are visually accumulated; and
in response to a determination that the visualization is to include time accumulation, generating animation frames of the visualization using time accumulation.

4. The method of claim 3 , wherein generating the animation frames comprises:
rendering a visualization of data points associated with a location in each of the animation frames;
determining a cumulative value associated with the data points at each of the animation frames; and
rendering a visualization of the cumulative value in each of the animation frames.

5. The method of claim 1 , further comprising:
obtaining geographic mapping data from a geocoding service, the geographic mapping data comprising data mapping the geographic location information to geocoded information; and
obtaining, from a map server, map data corresponding to the geocoded information.

6. The method of claim 5 , wherein generating the visualization comprises generating the visualization based, at least partially, upon the geographic mapping data and the map data.

7. The method of claim 1 , further comprising:
determining if time accumulation is to be shown in the visualization, whereby a plurality of data values are visually accumulated, and wherein generating the visualization comprises generating the visualization based, at least partially, upon the time range, the animation speed, and a determination regarding the time accumulation.

8. The method of claim 7 , wherein determining the time range, the animation speed, and the determination comprises obtaining data from a user computing device, the data comprising input obtained via at least one user interface presented at the user computing device.

9. The method of claim 8 , wherein the user interface comprises
a time control window,
a link to a layer properties window, and
a further link to a time properties window.

10. A computer storage medium having computer readable instructions stored thereon that, when executed by a computer, cause the computer to:
obtain spreadsheet data including data values, temporal information, and geographic location information;
determining, by the computer system, a time range for the visualization, the time range comprising a duration of time between a start time and an end time associated with the temporal information included in the spreadsheet data;
determining, based upon the time range, an animation speed for the visualization, wherein the animation speed is determined, at least partially, based upon the time range;
generate a visualization of the spreadsheet data based, at least partially, upon the data values, the time range, the animation speed, the geographic location information and the temporal information by
determining if the visualization is to include a time decay in which a data point of the spreadsheet data is persisted beyond a time associated with the data point, and
in response to a determination that the visualization is to include the time decay, determining a duration of the time decay and generating animation frames of the visualization with the time decay; and

output the visualization, the visualization comprising the animation frames.

11. The computer storage medium of claim 10 , wherein generating the visualization based upon the temporal information comprises:
determining if the visualization is to include time accumulation whereby a plurality of data values are visually accumulated; and
in response to a determination that the visualization is to include time accumulation, generating the animation frames using time accumulation.

12. The computer storage medium of claim 11 , wherein generating the animation frames using time accumulation comprises:
rendering a visualization of the data values at the data points in each of the animation frames;
determining a cumulative value associated with the data values of the data points at each of the animation frames; and
rendering a visualization of the cumulative value in each of the animation frames.

13. The computer storage medium of claim 10 , further comprising computer readable instructions that, when executed by the computer, cause the computer to generate a user interface comprising a temporal tower visualization of the data in a stacked relationship that represents multiple types of data included in the spreadsheet data.

14. The computer storage medium of claim 10 , further comprising computer readable instructions that, when executed by the computer, cause the computer to:
determine if time accumulation is to be shown in the visualization, whereby a plurality of data values are visually accumulated, and wherein generating the visualization comprises generating the visualization based, at least partially, upon the time range, the animation speed, and a determination regarding the time accumulation.

15. The computer storage medium of claim 14 , wherein determining the time range, the animation speed, and the determination comprises obtaining data from a user computing device, the data comprising input obtained via at least one user interface presented at the user computing device.

16. A computer storage medium having computer readable instructions stored thereon that, when executed by a computer, cause the computer to:
obtain spreadsheet data including data values, temporal information, and geographic location information;
determine a time range for a visualization of the spreadsheet data based upon the spreadsheet data, the time range being defined as a duration of time between a start time and end time associated with the spreadsheet data, the visualization comprising animation frames;
determine, based upon the time range, an animation speed for the visualization, the animation speed being at least partially bound to the time range, wherein changing the time range results in a change to the animation speed;
generate the visualizat

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Ruble B Scott
• Wong Curtis G
• Peev Igor Borisov
• Fan Kevin
• Srinivasan Jai
• Sobhy Ehab
• Fay Jonathan Edgar

Classifications

• G06T11/26 Primary

  Drawing of charts or graphs · CPC title

• G06F40/18

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F40/166

  Editing, e.g. inserting or deleting · CPC title

• G06F40/169

  Annotation, e.g. comment data or footnotes · CPC title

• G06F16/4393

  Multimedia presentations, e.g. slide shows, multimedia albums · CPC title