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

1. ## 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

2. ohps i did not look properly ... posted it in the wrong category ..
Moderators please change it to relevant topic