Results 1 to 2 of 2

Math Help - I need help with a convertion factor to be used in excel to find out new distance

  1. #1
    Newbie
    Joined
    Apr 2010
    Posts
    2

    Question I need help with a convertion factor to be used in excel to find out new distance

    I am currently using the program Dartfish to measure distance from a target and to my horror I found out half way through that two of the video cameras did not produce the same output.
    one uses 320 x 240 (4:3 aspect ratio) but the other is 720 x
    576 (aspect ratio 5:4) and is looking elongated and measures the distance differently.


    I found out that the video (elongated 5:4) was supposed to be shown in a 16:9 aspect.

    When using Dartfish program I need to calibrate a known distance and I used the width of the poster as I know its 1 meter. But as the height of the poster (video) was elongated the measurements are not matching up to the other video (4:3 and shows correct measurements compare with original poster)
    You can see the difference of measurements on the two pictures (one is the old elongated 4:3 and the other is the new 16:9 aspect ratio.


    The width of the picture is measured as 1 meter on both pictures (set as criterion).
    The distance from the ball to the floor is 0.93m in the converted video (correct according to life size picture) and 1.18m in the elongated picture.
    If the beanbag hits horizontally there is little change but if beanbag hits vertically then there is a big change.
    How can i account for all the different angles?
    When comparing the two videos this is the measurements i get:
    First row = Converted, Second row = Elongated (A 2 indicates that it hits the floor.)

    0.67 - 0.79
    2 - 2
    0.55 - 0.68
    2 - 2
    0.55 - 0.67
    0.43 - 0.52
    1.04 - 1.24
    0.17 - 0.18
    0.39 - 0.39
    2 - 2
    0.12 - 0.11
    0.15 - 0.18
    0.66 - 0.97
    0.26 - 0.33
    0.75 - 0.88

    Is there a way for me to put the new measurements into a formula so i do not have to redo all of them as it's about 56 hours worth of measuring done already
    Attached Thumbnails Attached Thumbnails I need help with a convertion factor to be used in excel to find out new distance-compare-elongated.jpg   I need help with a convertion factor to be used in excel to find out new distance-compare-converted.jpg  
    Last edited by Adventuredad; April 15th 2010 at 08:35 PM. Reason: seperate numbers
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Apr 2010
    Posts
    2
    ohps i did not look properly ... posted it in the wrong category ..
    Moderators please change it to relevant topic
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Find b so that x - 1 is a factor
    Posted in the Pre-Calculus Forum
    Replies: 1
    Last Post: March 6th 2010, 08:59 AM
  2. Need to find a domain, cannot factor.
    Posted in the Pre-Calculus Forum
    Replies: 2
    Last Post: February 7th 2010, 01:57 AM
  3. How do I find the linear factor?
    Posted in the Algebra Forum
    Replies: 2
    Last Post: May 20th 2009, 09:12 AM
  4. Convertion from Multiplication to Addition
    Posted in the Algebra Forum
    Replies: 1
    Last Post: April 1st 2009, 07:23 PM
  5. another convertion question
    Posted in the Calculus Forum
    Replies: 3
    Last Post: April 15th 2008, 03:51 PM

Search Tags


/mathhelpforum @mathhelpforum