1 / 14

Timing Analysis Spreadsheet for Pre/Post Time Stamped Videos

Timing Analysis Spreadsheet for Pre/Post Time Stamped Videos. Presented to 2013 IOTA Annual Meeting Brad Timerson, Tony George. Background. Technique pioneered by Scotty Degenhardt for his multi-station deployments Makes use of scripting in AviSynth

whitney
Download Presentation

Timing Analysis Spreadsheet for Pre/Post Time Stamped Videos

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Timing Analysis Spreadsheet forPre/Post Time Stamped Videos Presented to 2013 IOTA Annual Meeting Brad Timerson, Tony George

  2. Background • Technique pioneered by Scotty Degenhardt for his multi-station deployments • Makes use of scripting in AviSynth • Uses time stamp on many commonly used digital camcorders

  3. Why do this?It became necessary for others to learn these techniques when observations were received and no one was available to do the analysis

  4. Brad Timerson and Tony George worked together using Scotty’s original spreadsheet as a template to create a new form. We received help from John Talbot on the final product. A Word document describing the procedures is available along with the new spreadsheet. This presentation provides a brief overview of the process.

  5. Basic Steps • Download and install AviSynth 2.5 • Install PlugIn called: DVInfo • Create/Receive video file for Pre-, Post-, and Event (the pre- and post- videos are time stamped and have time insertion on them) • Create AVS script. • Use AVS scripts with LiMovie to get input needed for spreadsheet. • Complete spreadsheet

  6. Associate time stamp with UTC Open Pre- video in LiMovie. Find UTC associated with next whole second of the time stamp. Here we incremented video until next second (:21) to get UTC from time inserter (18:26:21.7536). You need the time stamp (06:26:21 PM) and the UTC.

  7. Associate time stamp with UTC Next, open Post- video in LiMovie. Find UTC associated with next whole second of the time stamp. Here we incremented video until next second (:30) to get UTC from time inserter (9:13:31.7897). You need the time stamp (09:13:30 AM) and the UTC.

  8. Analyze Event Video Analyze video to obtain CSV file Get fractional event times(from Occular, for example) Open video in LiMovie. Move to location before the frame. Find frame where time stamp increments to next second. Record time stamp time. Find number of frames from that location until the event.

  9. Location of the D event Occular showed D at frame 284.8 At frame 255, time stamp incremented to next whole second. Record 07:13:30 AM. Next record (284.8 - 255) or 29.8 frames.

  10. Repeat for R event Occular showed R at frame 554.1 At frame 525, time stamp incremented to next whole second. Record 07:13:39 AM. Next record (554.1 - 525) or 29.1 frames.

  11. Spreadsheet Entry Open spreadsheet. Be sure the yellow cell at Step 9 is empty.

  12. Spreadsheet with Entries Last step is to enter value in green cell of Step 9 into the yellow cell for that step.

  13. Files Needed or Available • Blank Spreadsheet • Word document outlining procedures • AVS script • Sample completed Spreadsheet (for date/time format which is critical) Links for download sites are in the Word file. All files will be placed within a zipfile on the North American Asteroidal Occultation webpage.

  14. Acknowledgements The authors acknowledge and thank Scotty Degenhardt for pioneering the use of the time stamping technique and for his original spreadsheet. We also thank John Talbot for fixing formatting issues within the spreadsheet and for verifying that it works as expected. Brad Timerson, Tony George October 2013

More Related