Video on charts
Systems and methods for charting videos and/or attributes of videos associated with a spreadsheet are provided. For instance, when a video is associated with a spreadsheet, the video may be treated as a new type of data within the spreadsheet. In some aspects, a plurality of videos may be associated with a spreadsheet, e.g., within a single cell or a range of cells. In aspects, the videos themselves, as well as video data (e.g., raw pixel data for each video frame, modulated data representing soundwaves of an audio file, etc.), video attributes (e.g., frame rate, aspect ratio, duration, resolution, bits per frame, video size, synchronization data, etc.), frame attributes (e.g., aspect ratio, color space, bitrate, etc.), audio attributes (e.g., pitch, volume, speed, etc.), and/or spreadsheet data (e.g., values in cells, user comments, etc.) may be incorporated into a chart using a spreadsheet charting function, either automatically or by user selection.
1. A system comprising:
at least one processing unit; and
at least one memory storing computer executable instructions that, when executed by the at least one processing unit, cause the system to perform a method, the method comprising:
receiving a selection of one or more cells within a spreadsheet;
identifying at least one video associated with the selected one or more cells, wherein the at least one video is associated with one or more parameters;
extracting one or more values for at least one parameter from the at least one video;
receiving a selection of a charting function; and
creating a chart by charting the one or more values of the at least one parameter of the at least one video.
2. The system of claim 1 , wherein the at least one video is associated with at least one cell within the selected one or more cells.
3. The system of claim 1 , wherein the at least one video is associated with at least one cell related to the selected one or more cells.
4. The system of claim 3 , wherein the at least one cell related to the selected one or more cells is in the same row or column as at least one cell within the selected one or more cells.
5. The system of claim 1 , wherein the one or more parameters comprise one or more video attributes selected from the group consisting of:
a frame rate;
an aspect ratio;
a duration;
a resolution;
bits per frame;
video size;
audio synchronization data;
subtitle data;
a color space;
a frequency;
an amplitude;
a sampling rate;
a codec;
a bitrate;
a volume;
a pitch;
a speed;
a channel;
an audio effect;
an artist;
a creation date;
a creation time;
a file size; and
a duration.
6. The system of claim 1 , wherein the one or more parameters comprise video data comprising one or more of:
an array of pixel values for rendering each frame of the at least one video; and
modulated data for reproducing soundwaves of an audio track.
7. The system of claim 1 , the computer executable instructions further causing the system to incorporate the at least one video into the chart, wherein incorporating the at least one video into the chart further comprises:
incorporating a visual representation of the at least one video into the chart; and
in response to receiving a selection of the visual representation, playing the at least one video within the chart.
8. The system of claim 7 , further comprising:
receiving a selection of the visual representation; and
in response to receiving a selection of the visual representation, providing one or more play controls comprising one or more of:
a control for playing the at least one video;
a control for skipping back within the at least one video;
a control for skipping forward within the at least one video;
a control for pausing the at least one video;
a control for rewinding the at least one video;
a control for fast forwarding the at least one video; and
a control for stopping the at least one video.
9. The system of claim 1 , wherein the at least one video includes subtitles.
10. The system of claim 9 , further comprising incorporating the subtitles into the chart.
11. A system comprising:
at least one processing unit; and
at least one memory storing computer executable instructions that, when executed by the at least one processing unit, cause the system to:
receive a selection of one or more cells within a spreadsheet, wherein the one or more cells contain data;
identify at least one video associated with the selected one or more cells, wherein the video relates to the data;
receive a selection of a charting function;
create a chart based on the data; and
incorporate a visual representation of the at least one video into the chart, wherein the visual representation includes a play control for playing the video from the chart.
12. The system of claim 11 , wherein the at least one video is associated with one or more parameters, the computer executable instructions further causing the system to:
receive a change to at least one parameter of the at least one video within the spreadsheet; and
automatically apply the change to the at least one video incorporated into the chart.
13. The system of claim 12 , wherein incorporating the at least one video into the chart comprises at least one of:
displaying a visual representation of the at least one video as a data point within the chart; and
displaying a visual representation of the at least one video within at least a portion of a bar within the chart.
14. The system of claim 13 , further comprising:
receiving a selection of the visual representation; and
in response to receiving a selection of the visual representation, displaying one or more play controls comprising one or more of:
a control for playing the at least one video;
a control for skipping back within the at least one video;
a control for skipping forward within the at least one video;
a control for pausing the at least one video;
a control for rewinding the at least one video;
a control for fast forwarding the at least one video; and
a control for stopping the at least one video.
15. The system of claim 14 , further comprising:
receiving a selection of the visual representation; and
in response to receiving a selection of the visual representation, displaying at least one parameter associated with the at least one video.
16. A method implemented by a computer system for charting one or more parameters of a video, the method comprising:
receiving a selection of one or more cells within a spreadsheet;
identifying at least one video associated with the selected one or more cells;
receiving a selection of a charting function;
extracting one or more values for one or more parameters from the at least one video; and
creating a chart based at least in part on the one or more values of the one or more parameters.
17. The method of claim 16 , wherein the one or more parameters comprise one or more video attributes selected from the group consisting of:
a frame rate;
an aspect ratio;
a duration;
a resolution;
bits per frame;
video size;
audio synchronization data;
subtitle data;
a color space;
a frequency;
an amplitude;
a sampling rate;
a codec;
a bitrate;
a volume;
a pitch;
a speed;
a channel;
an audio effect;
an artist;
a creation date;
a creation time;
a file size; and
a duration.
18. The method of claim 16 , wherein the one or more parameters comprise video data comprising one or more of:
an array of pixel values for rendering each frame of the at least one video; and
modulated data for reproducing soundwaves of an audio track.
19. The method of claim 16 , wherein at least two videos are associated with the selected one or more cells, further comprising:
charting at least one parameter of a first video versus at least one parameter of a second video.
20. The method of claim 16 , wherein the one or more parameters are retrieved from metadata associated with the at least one video.
21. The method of claim 16 , wherein the one or more parameters are retrieved from a compound data type associated with the at least one video.
22. The method of claim 21 , wherein the compound data type comprises the at least one video and the one or more parameters in a structured format.
23. The method of claim 16 , wherein the one or more parameters are not displayed within the spreadsheet.