A friend and I recently launched a model rocket. We had installed an altitudemeter that exports all it's data for each quarter second into an Excel document. I want to take the data of the time and height of this document (about 1000 time steps) and use it to have a live altimeter in the top of the screen on the video using Vegas Pro 13. I basically want it to count the height live with the video. Does anyone know if this is possible in Sony Vegas? The best thing for me would be that it follows a graph so that the text doesn't change every quarter second, but every frame. If this can be done, it would be easier, because then I don't have to use every single step of time from Excel, but every 10 steps or so. It will still be accurate and smooth, though less of an annoying job.
I think you want this to be done automatically. But f course you could create 1000 text overlays, each one showing a particular altitude, and place the correct overlay at the correct point in the timeline for the correct duration (1/4 second). That would be a terribly tedious job!
The best way to do it is with Vegas scripting. I have not used it myself but it should be able to accomplish what you're looking for.
If you have Excel, presumably you have PowerPoint? If so, there may be a way to get what you’re looking for that way. The basic idea would be something like this:
- Construct a chart using the Excel data;
- Put that into PowerPoint as a single slide;
- Animate the slide, suppressing the visual items you do not want to appear;
- Capture the actual running of that animation with something like Screenflow;
- Pull the resulting clip into Vegas and stretch it to cover the required time of the rocket flight
- Lie down in a dark room to recover from the effort
The trick is to choose the most appropriate chart to begin with, with the appropriate chart options, and to then suppress the undesired elements in PP. Done right, you could get anything from as complex as the actual chart series lines, all the way down to nothing but the simple numbers you talk about. I’d do as much as possible of the heavy lifting in Excel, and even prior to creating the chart. Consider things like splitting the data points into series that then all use the same x axis values. That’s the kind of thing that would let you get the consecutive numbers to be located at the same point in your video.
Dunno. If you’re strong on Excel and on PowerPoint animations, give it a ponder?