ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Pre-Launch Data
2
Air Density (kg/m^3)
yellow means simple data collection or transfer of data
3
Water volume added (mL)
blue means calculation. Enter a formula
4
Dry rocket mass (kg)
red means difficult. rarely correct on the first or second attempt
5
6
Thrust Video Analysis Data
7
Numbering from InstructionsQuantity measuredValue (NO UNITS)
8
6Frame Rate (fps -- frames per second)
9
7eY position at time = 0s [Height of Rocket Tip] (m)
10
7eVideo frame number at t = 0s
11
7fFrame number at end of water thrustInsert Vernier Video Analysis Data Here
12
7fY Position at end of water thrustFrame Rate (fps)
13
8bVy max -- velocity at end of air thrust -- beginning of coasting phase (m/s)
14
8cY position at end of air thrust [height of rocket tip] -- beginning of coasting phase (m)Time, based on Frame RateY positionChange in Y positionMid-Interval Time (s)Average Interval Velocity (m/s)
15
8cTime at end of air thrust -- beginning of coasting phase, from the table (s)0NANANA
16
#DIV/0!0#DIV/0!0
17
Problem NumberWater Thrust Phase Calculations and Problems#DIV/0!0#DIV/0!0
18
1Water mass (kg) [In case you haven't taken chemistry, 1L has a mass of 1kg]#DIV/0!0#DIV/0!0
19
2Time at end of water thrust, based on frame number and frame rate (s)#DIV/0!0#DIV/0!0
20
3Average acceleration during air thrust (m/s^2)#DIV/0!0#DIV/0!0
21
4Y displacement during water thrust (m)#DIV/0!0#DIV/0!0
22
5Average velocity durijng water thrust (m/s)#DIV/0!0#DIV/0!0
23
6Final velocity at end of water thrust (m/s)#DIV/0!0#DIV/0!0
24
7average acceleration during water thrust (m/s^2)#DIV/0!0#DIV/0!0
25
8Total rocket mass just before launch(kg)#DIV/0!0#DIV/0!0
26
9Average rocket mass during water thrust -- assuming, for simplicity, that water flowed out at a constant rate, this is just an average of the rocket's full mass and dry mass (kg)#DIV/0!0#DIV/0!0
27
10Average net force during thrust (N)#DIV/0!0#DIV/0!0
28
11Average rocket weight during thrust (N)#DIV/0!0#DIV/0!0
29
12Average water thrust -- force exerted on rocket by expelled water (N)#DIV/0!0#DIV/0!0
30
13How many of these bottles would it take to suspend a 150 pound person motionless in the air (for just a moment, assuming that they could balance on the bottles). Answer to the nearest 0.1 bottle, which I understand is silly.#DIV/0!0#DIV/0!0
31
14If 60 of these bottles were attached to a person and launched directly upward, powered only by water thrust, how high would the person and bottles go? Assume that the bottles are lifting a total mass of person + straps equal to 86kg. This does not include the bottles' mass. To make this a manageable problem, ignore the effects of air thrust and drag (m). You should assume that the bottles all have the same water thrust burnout time and average thrust as the bottle that powered your rocket.#DIV/0!0#DIV/0!0
32
#DIV/0!0#DIV/0!0
33
#DIV/0!0#DIV/0!0
34
#DIV/0!0#DIV/0!0
35
Full Flight Video Data#DIV/0!0#DIV/0!0
36
Numbering from InstructionsEventsElapsed Time (s)#DIV/0!0#DIV/0!0
37
8Launch Begins (expelled water is first visible)#DIV/0!0#DIV/0!0
38
8Rocket reaches apogee (highest point)#DIV/0!0#DIV/0!0
39
8Parachute fully deployed#DIV/0!0#DIV/0!0
40
8Rocket touches ground#DIV/0!0#DIV/0!0
41
9Y position at apogee (units will be px, unless you changed them)#DIV/0!0#DIV/0!0
42
9Y position at parachute deployment (units will be px, unless you changed them)#DIV/0!0#DIV/0!0
43
10Fractional height at parachute deployment -- expressed as a fraction of the apogee#DIV/0!0#DIV/0!0
44
#DIV/0!0#DIV/0!0
45
#DIV/0!0#DIV/0!0
46
Parachute Drag Coefficient#DIV/0!0#DIV/0!0
47
1Actual height at apogee -- from your "Y Dimension Projectile With Drag" Spreadsheet#DIV/0!0#DIV/0!0
48
2Actual height of full parachute deployment -- based on the fraction found at the end of your full flight video data, above (m)#DIV/0!0#DIV/0!0
49
3Descent time with parachute deployed -- assume this is all at terminal velocity (s)#DIV/0!0#DIV/0!0
50
4Terminal Velocity with parachute
51
5Estimated Parachute Radius (m)
52
5Estimated Parachute Cross-sectional Area (m^2)
53
Estimated Parachute Drag Coefficient
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