Displaying temporal information in a spreadsheet application
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06F-017/00
G06T-011/20
G06F-003/0484
G06F-003/0482
G06T-015/10
G06T-013/00
G06F-017/30
G06F-017/24
G06F-003/0481
G06F-003/01
G06F-003/0488
G06T-019/00
G06F-003/048
G06T-015/00
출원번호
US-0856116
(2013-04-03)
등록번호
US-9881396
(2018-01-30)
발명자
/ 주소
Ruble, B. Scott
Wong, Curtis G.
Peev, Igor Borisov
Fan, Kevin
Srinivasan, Jai
Sobhy, Ehab
Fay, Jonathan Edgar
출원인 / 주소
Microsoft Technology Licensing, LLC
대리인 / 주소
Schwegman Lundberg & Woessner, P.A.
인용정보
피인용 횟수 :
0인용 특허 :
65
초록▼
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 informatio
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.
대표청구항▼
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, t
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, andin 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; andoutputting, 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; andin 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; andrendering 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; andobtaining, 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, anda 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, andin 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; andoutput 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; andin 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; andrendering 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 visualization 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, andin 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; andoutput the visualization to a user computing device in communication with the computer. 17. The computer storage medium of claim 16, 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; andin response to a determination that the visualization is to include time accumulation, generating the animation frames using time accumulation, 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, andrendering a visualization of the cumulative value in each of the animation frames. 18. The computer storage medium of claim 16, wherein determining the time range, the animation speed, and the determination comprises obtaining data from the user computing device, the data comprising input obtained via at least one user interface presented at the user computing device. 19. The computer storage medium of claim 16, wherein determining the time range, the animation speed, and the determination comprises obtaining data from the user computing device, the data comprising input obtained via at least one user interface presented at the user computing device, the user interface comprising: a time control window having a time scrubber for displaying the animation frames;a link to a layer properties window comprising an option to enable time accumulation whereby a plurality of data values are visually accumulated; anda further link to a time properties window comprising a control for specifying the animation speed and a further control for specifying the time range.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (65)
Fong, Jeffrey Cheng-Yao; Barnett, Donald Allen; Braff, Eric Neal, 3D layering of map metadata.
Margaret Gardner MacPhail, Arrangement of information to allow three-dimensional navigation through information displays with indication of intended starting point.
Puttick, Randy W.; Lewis, William M.; Burroughs, John K.; Gentzkow, Hauke A.; Stein, Steven F., Automatically performing varying levels of summarization of geographic data points in response to a user's selection of zoom level.
McCormack,Michael J.; Coffen,Robert W.; Dickinson,Richard L.; Chauhan,Sumit; Wu,Su Piao Bill; Patterson,Eric W.; Hafner,Paul A.; Tseng,Larry; Pan,Xiaohui; Eatough,Michael J., Data source write back and offline data editing and storage in a spreadsheet.
Bandt-Horn, Benjamin D., Device and user interface for visualizing, navigating, and manipulating hierarchically structured information on host electronic devices.
Holl, James E.; Cheng, Yao-Chou; Dobin, Mark W.; Schuette, John F.; Kim, Chul-Sung; Schmidtke, Eric A., Functional-based knowledge analysis in a 2D and 3D visual environment.
Ruble, B. Scott; Sobhy, Ehab; Peev, Igor Borisov; Wong, Curtis G.; Payne, John Alfred; Fay, Jonathan Edgar; Fan, Kevin, Generating scenes and tours in a spreadsheet application.
Anthony,Colin Ray; St Michel,St챕phane; Odins Lucas,Zeke Book; Schwartz,Jordan Luther King; Banks,Richard Malcolm; Harvey,Marcus Simon Howell; Cummins,Charles; Stabb,Charles W.; Ligameri,Mark Richard, Graphical user interface for 3-dimensional view of a data collection based on an attribute of the data.
Becker,Andrew J.; Ellis,Charles D.; Chirilov,Joseph M.; Niemisto,Juha P.; Androski,Matthew J.; Collie,Robert C.; Hawking,Robert G.; Peyton Jones,Simon; Zhong,Weide, Method and implementation for referencing of dynamic data within spreadsheet formulas.
Maoz, Hillel; Libicki, Daniel; Fink, Michael; Ho, Ronald; Lee, Dennis Julian; Matias, Yossi; Weinstein, Amit; David, Yoah Bar; Raz, Itai, Ranking graphical visualizations of a data set according to data attributes.
Amir Weinberg IL; Eran Leshem IL; Maxim Kholmyansky IL; Amos Garri IL; Nisim Tapiro IL; Meni Hillel, Software system and methods for testing the functionality of a transactional server.
Weinberg, Amir; Leshem, Eran; Kholmyansky, Maxim; Garri, Amos; Tapiro, Nisim; Hillel, Meni, Software system and methods for testing the functionality of a transactional server.
Barg, Timothy A.; Burkwald, Susan K.; Eick, Stephen G.; Garity, Brenda A.; Hackborn, Dianne K.; Mirel, Barbara R.; Swanson, William C.; Tatelman, Michael S., Systems and methods for visualizing multi-dimensional data in spreadsheets and other data structures.
Hunter, Sean; Kumar, Aditya; Albertson, Jacob, Systems and user interfaces for holistic, data-driven investigation of bad actor behavior based on clustering and scoring of related data.
Russell ; Jr. Sanford H. (San Mateo CA) Dennis Douglas S. (San Jose CA) Carey Richard J. (Los Altos CA), Three dimensional model with three dimensional pointers and multimedia functions linked to the pointers.
Albertson, Jacob C.; Arnold, Kenneth C.; Goldman, Steven D.; Paolini, Michael A.; Sessa, Anthony J., Tracking a range of body movement based on 3D captured image streams of a user.
Cota Dan E. (Los Angeles CA) Charter Ted R. (Santa Ana CA) Beeson Robert M. (Palos Verdes Estates CA) Kinkead Robin D. (Dallas TX), Transcriber system for the automatic generation and editing of text from shorthand machine outlines.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.