Video analysis for moving camera

	A	B	C	D	E
1	Make sure that this spreadsheet matches your video. Check the frame rate. If you used bricks (or some other "ruler"), change the data and cell titles accordingly.
2	Delete the data in the yellow cells and replace it with your own. You may also need to change the green cells.
3
4	Video Frame Rate (fps)	240
5	Seconds/frame	0.004166666667
6	Floor Tile width (m)	0.305
7
8
9
10	Frame #	Elapsed Time (s)	Floor tiles reached	Position (m)	Speed (m/s)
11	79	0	0	0	14.64
12	84	0.02083333333	1	0.305	12.2
13	90	0.04583333333	2	0.61	10.45714286
14	97	0.075	3	0.915	9.15
15	105	0.1083333333	4	1.22	9.15
16	113	0.1416666667	5	1.525	-0.6477876106
17		-0.3291666667	6	1.83	#DIV/0!
18		-0.3291666667	7	2.135	#DIV/0!
19		-0.3291666667	8	2.44	#DIV/0!
20		-0.3291666667	9	2.745	#DIV/0!
21		-0.3291666667	10	3.05	#DIV/0!
22		-0.3291666667	11	3.355	#DIV/0!
23		-0.3291666667	12	3.66	#DIV/0!
24		-0.3291666667	13	3.965	#DIV/0!
25		-0.3291666667	14	4.27	#DIV/0!
26		-0.3291666667	15	4.575	#DIV/0!
27		-0.3291666667	16	4.88	#DIV/0!
28		-0.3291666667	17	5.185	#DIV/0!
29		-0.3291666667	18	5.49	#DIV/0!
30		-0.3291666667	19	5.795	#DIV/0!
31		-0.3291666667	20	6.1	#DIV/0!
32		-0.3291666667	21	6.405	#DIV/0!
33		-0.3291666667	22	6.71	#DIV/0!
34		-0.3291666667	23	7.015	#DIV/0!
35		-0.3291666667	24	7.32	#DIV/0!
36		-0.3291666667	25	7.625	-23.16455696
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100