Rocket Height Prediction Spreadsheet

Name:
Type of Rocket and Type of Engine =

Mass (of rocket and engine together) =
Drag Coefficient (kd) =
Average
Thrust
Time
Thrust
0.0
0.1
6.0
0.2
14.0
0.3
5.0
0.4
4.7
0.5
4.5
0.6
4.5
0.7
4.5
0.8
4.5
0.9
4.5
4.5
1.1
4.5
1.2
4.5
1.3
4.5
1.4
4.5
1.5
4.5
1.6
4.5
1.7
4.5
1.8
4.5
1.9
0.2
0.0
2.1
0.0
2.2
0.0
2.3
0.0
2.4
0.0
2.5
0.0
2.6
0.0
2.7
0.0
2.8
0.0
2.9
0.0
0.0
3.1
0.0
3.2
0.0
Drag Force
(using prior v f)
0.099
(must be kg)
0.0008
Average
Net Force
Average
Net Impulse
Initial
Velocity
Final
Velocity
Average
Velocity
Initial
Height
Final
Height
Final
Time
(Thr1+Thr2)/2
(Fd = kd*v )
(Thravg - mg - Fd)
(FnetDt)
(= last row's vf)
(vi+FnetDt/m)
(vi + vf)/2
(= last row's hf)
(hi+vavg*Dt)
3.00
0.00
2.03
0.20
0.00
0.21
0.10
0.00
0.01
0.1
10.00
0.00
9.03
0.90
0.21
9.33
4.77
0.01
0.49
0.2
9.50
0.07
8.46
0.85
9.33
17.87
13.60
0.49
1.85
0.3
4.85
0.26
3.62
0.36
17.87
21.53
19.70
1.85
3.82
0.4
4.60
0.37
3.26
0.33
21.53
24.82
23.18
3.82
6.13
0.5
4.50
0.49
3.04
0.30
24.82
27.89
26.36
6.13
8.77
0.6
4.50
0.62
2.91
0.29
27.89
30.83
29.36
8.77
11.71
0.7
4.50
0.76
2.77
0.28
30.83
33.63
32.23
11.71
14.93
0.8
4.50
0.90
2.63
0.26
33.63
36.28
34.95
14.93
18.42
0.9
4.50
1.05
2.48
0.25
36.28
38.78
37.53
18.42
22.18
4.50
1.20
2.33
0.23
38.78
41.13
39.95
22.18
26.17
1.1
4.50
1.35
2.18
0.22
41.13
43.33
42.23
26.17
30.40
1.2
4.50
1.50
2.03
0.20
43.33
45.38
44.35
30.40
34.83
1.3
4.50
1.65
1.88
0.19
45.38
47.28
46.33
34.83
39.46
1.4
4.50
1.79
1.74
0.17
47.28
49.04
48.16
39.46
44.28
1.5
4.50
1.92
1.61
0.16
49.04
50.66
49.85
44.28
49.26
1.6
4.50
2.05
1.48
0.15
50.66
52.15
51.41
49.26
54.41
1.7
4.50
2.18
1.35
0.14
52.15
53.52
52.84
54.41
59.69
1.8
2.35
2.29
-0.91
-0.09
53.52
52.60
53.06
59.69
64.99
1.9
0.10
2.21
-3.08
-0.31
52.60
49.48
51.04
64.99
70.10
0.00
1.96
-2.93
-0.29
49.48
46.52
48.00
70.10
74.90
2.1
0.00
1.73
-2.70
-0.27
46.52
43.80
45.16
74.90
79.42
2.2
0.00
1.53
-2.50
-0.25
43.80
41.27
42.53
79.42
83.67
2.3
0.00
1.36
-2.33
-0.23
41.27
38.91
40.09
83.67
87.68
2.4
0.00
1.21
-2.18
-0.22
38.91
36.71
37.81
87.68
91.46
2.5
0.00
1.08
-2.05
-0.20
36.71
34.64
35.67
91.46
95.02
2.6
0.00
0.96
-1.93
-0.19
34.64
32.69
33.66
95.02
98.39
2.7
0.00
0.85
-1.83
-0.18
32.69
30.84
31.77
98.39
101.57
2.8
0.00
0.76
-1.73
-0.17
30.84
29.10
29.97
101.57
104.56
2.9
0.00
0.68
-1.65
-0.16
29.10
27.43
28.26
104.56
107.39
0.00
0.60
-1.57
-0.16
27.43
25.84
26.64
107.39
110.06
3.1
0.00
0.53
-1.50
-0.15
25.84
24.32
25.08
110.06
112.56
3.2
0.00
0.47
-1.44
-0.14
24.32
22.87
23.59
112.56
114.92
3.3
222855587.xlsx.ms_office
Academy for Math, Engineering and Science
Time
Thrust
3.3
0.0
3.4
0.0
3.5
0.0
3.6
0.0
3.7
0.0
3.8
0.0
3.9
0.0
0.0
4.1
0.0
4.2
0.0
4.3
0.0
4.4
0.0
4.5
0.0
4.6
0.0
4.7
0.0
4.8
0.0
4.9
0.0
0.0
5.1
0.0
5.2
0.0
5.3
0.0
5.4
0.0
5.5
0.0
5.6
0.0
5.7
0.0
5.8
0.0
5.9
0.0
0.0
6.1
0.0
6.2
0.0
6.3
0.0
6.4
0.0
6.5
0.0
6.6
0.0
6.7
0.0
6.8
0.0
6.9
0.0
0.0
Average
Thrust
Drag Force
(using prior v f)
Average
Net Force
Average
Net Impulse
Initial
Velocity
Final
Velocity
Average
Velocity
Initial
Height
Final
Height
(Thr1+Thr2)/2
(Fd = kd*v2)
0.47
(Thravg - mg - Fd)
(FnetDt)
-0.14
(= last row's vf)
(vi+FnetDt/m)
22.87
(vi + vf)/2
23.59
(= last row's hf)
112.56
(hi+vavg*Dt)
114.92
3.3
0.00
0.42
-1.39
-0.14
22.87
21.46
22.16
114.92
117.14
3.4
0.00
0.37
-1.34
-0.13
21.46
20.11
20.79
117.14
119.22
3.5
0.00
0.32
-1.29
-0.13
20.11
18.80
19.46
119.22
121.16
3.6
0.00
0.28
-1.25
-0.13
18.80
17.54
18.17
121.16
122.98
3.7
0.00
0.25
-1.22
-0.12
17.54
16.31
16.92
122.98
124.67
3.8
0.00
0.21
-1.18
-0.12
16.31
15.11
15.71
124.67
126.24
3.9
0.00
0.18
-1.15
-0.12
15.11
13.95
14.53
126.24
127.70
0.00
0.16
-1.13
-0.11
13.95
12.81
13.38
127.70
129.04
4.1
0.00
0.13
-1.10
-0.11
12.81
11.70
12.26
129.04
130.26
4.2
0.00
0.11
-1.08
-0.11
11.70
10.61
11.16
130.26
131.38
4.3
0.00
0.09
-1.06
-0.11
10.61
9.54
10.07
131.38
132.38
4.4
0.00
0.07
-1.04
-0.10
9.54
8.49
9.01
132.38
133.29
4.5
0.00
0.06
-1.03
-0.10
8.49
7.45
7.97
133.29
134.08
4.6
0.00
0.04
-1.01
-0.10
7.45
6.42
6.93
134.08
134.78
4.7
0.00
0.03
-1.00
-0.10
6.42
5.41
5.92
134.78
135.37
4.8
0.00
0.02
-0.99
-0.10
5.41
4.41
4.91
135.37
135.86
4.9
0.00
0.02
-0.99
-0.10
4.41
3.41
3.91
135.86
136.25
0.00
0.01
-0.98
-0.10
3.41
2.42
2.91
136.25
136.54
5.1
0.00
0.00
-0.97
-0.10
2.42
1.44
1.93
136.54
136.73
5.2
0.00
0.00
-0.97
-0.10
1.44
0.45
0.94
136.73
136.83
5.3
0.00
0.00
-0.97
-0.10
0.45
-0.53
-0.04
136.83
136.82
5.4
0.00
0.00
-0.97
-0.10
-0.53
-1.51
-1.02
136.82
136.72
5.5
0.00
0.00
-0.97
-0.10
-1.51
-2.49
-2.00
136.72
136.52
5.6
0.00
0.00
-0.98
-0.10
-2.49
-3.47
-2.98
136.52
136.22
5.7
0.00
0.01
-0.98
-0.10
-3.47
-4.46
-3.97
136.22
135.83
5.8
0.00
0.02
-0.99
-0.10
-4.46
-5.46
-4.96
135.83
135.33
5.9
0.00
0.02
-0.99
-0.10
-5.46
-6.46
-5.96
135.33
134.74
0.00
0.03
-1.00
-0.10
-6.46
-7.48
-6.97
134.74
134.04
6.1
0.00
0.04
-1.01
-0.10
-7.48
-8.50
-7.99
134.04
133.24
6.2
0.00
0.06
-1.03
-0.10
-8.50
-9.54
-9.02
133.24
132.34
6.3
0.00
0.07
-1.04
-0.10
-9.54
-10.59
-10.07
132.34
131.33
6.4
0.00
0.09
-1.06
-0.11
-10.59
-11.66
-11.13
131.33
130.22
6.5
0.00
0.11
-1.08
-0.11
-11.66
-12.75
-12.21
130.22
129.00
6.6
0.00
0.13
-1.10
-0.11
-12.75
-13.87
-13.31
129.00
127.67
6.7
0.00
0.15
-1.12
-0.11
-13.87
-15.00
-14.43
127.67
126.22
6.8
0.00
0.18
-1.15
-0.12
-15.00
-16.16
-15.58
126.22
124.66
6.9
0.00
0.21
-1.18
-0.12
-16.16
-17.35
-16.76
124.66
122.99
0.00
0.24
-1.21
-0.12
-17.35
-18.58
-17.97
122.99
121.19
7.1
0.00
-1.44
24.32
Final
Time
Time
Thrust
7.1
0.0
7.2
0.0
7.3
0.0
7.4
0.0
7.5
0.0
7.6
0.0
7.7
0.0
7.8
0.0
7.9
0.0
0.0
8.1
0.0
8.2
0.0
Average
Thrust
Drag Force
(using prior v f)
Average
Net Force
Average
Net Impulse
Initial
Velocity
Final
Velocity
Average
Velocity
Initial
Height
Final
Height
(Thr1+Thr2)/2
(Fd = kd*v2)
0.24
(Thravg - mg - Fd)
(FnetDt)
-0.12
(= last row's vf)
(vi+FnetDt/m)
-18.58
(vi + vf)/2
-17.97
(= last row's hf)
122.99
(hi+vavg*Dt)
121.19
7.1
0.00
0.28
-1.25
-0.12
-18.58
-19.84
-19.21
121.19
119.27
7.2
0.00
0.31
-1.29
-0.13
-19.84
-21.13
-20.49
119.27
117.22
7.3
0.00
0.36
-1.33
-0.13
-21.13
-22.48
-21.81
117.22
115.04
7.4
0.00
0.40
-1.37
-0.14
-22.48
-23.86
-23.17
115.04
112.72
7.5
0.00
0.46
-1.43
-0.14
-23.86
-25.30
-24.58
112.72
110.27
7.6
0.00
0.51
-1.48
-0.15
-25.30
-26.80
-26.05
110.27
107.66
7.7
0.00
0.57
-1.54
-0.15
-26.80
-28.36
-27.58
107.66
104.90
7.8
0.00
0.64
-1.61
-0.16
-28.36
-29.99
-29.18
104.90
101.99
7.9
0.00
0.72
-1.69
-0.17
-29.99
-31.70
-30.85
101.99
98.90
0.00
0.80
-1.77
-0.18
-31.70
-33.49
-32.60
98.90
95.64
8.1
0.00
0.90
-1.87
-0.19
-33.49
-35.38
-34.43
95.64
92.20
8.2
0.00
-1.21
-17.35
Final
Time
Time
1/2 A3
A8
B6
C6
0.0
0.0
0.0
0.0
0.0
0.1
6.0
5.0
6.0
6.0
0.2
3.0
9.0
10.0
14.0
0.3
0.0
3.0
6.0
5.0
0.4
0.0
2.5
4.8
4.7
0.5
0.0
2.2
4.5
4.5
0.6
0.0
2.2
4.5
4.5
0.7
0.0
0.0
4.5
4.5
0.8
0.0
0.0
3.0
4.5
0.9
0.0
0.0
0.0
4.5
1.0
0.0
0.0
0.0
4.5
1.1
0.0
0.0
0.0
4.5
1.2
0.0
0.0
0.0
4.5
1.3
0.0
0.0
0.0
4.5
1.4
0.0
0.0
0.0
4.5
1.5
0.0
0.0
0.0
4.5
1.6
0.0
0.0
0.0
4.5
1.7
0.0
0.0
0.0
4.5
1.8
0.0
0.0
0.0
4.5
1.9
0.0
0.0
0.0
0.2
2.0
0.0
0.0
0.0
0.0
Masses of Rockets Without Engine

Silver
75 g
Big White
71 g
Small White
23 g
Masses of Engines
C6
B6
A8
1/2 A3
24 g
18 g
15 g
7g
Name:
Type of Rocket Engine =

Mass of Rocket (with engine) =
(must be kg)
Drag Coefficient (kd) =
Time
0
Thrust
Average
Thrust
Drag Force
(using prior vf)
Average
Net Force
Average
Net Impulse
Initial
Velocity
Final
Velocity
Average
Velocity
Final
Height
(Thr1+Thr2)/2
(Fd = kd*v2)
(Thravg - mg - Fd)
(FnetDt)
(= last row's vf)
(vi+FnetDt/m)
(vi + vf)/2
(hi+vavg*Dt)
Final
Time
0.1
0.1
0.2
0.2
0.3
0.3
0.4
0.4
0.5
0.5
0.6
0.6
0.7
0.7
0.8
0.8
0.9
0.9
1
1

Rocket Height Prediction Spreadsheet

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

Rocket Height Prediction Spreadsheet

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Rocket Height Prediction Spreadsheet

Uploaded by

Copyright:

Available Formats

Name:

Type of Rocket and Type of Engine =

(= last row's vf)

(= last row's hf)

Academy for Math, Engineering and Science

(= last row's vf)

(= last row's hf)

Academy for Math, Engineering and Science

(= last row's vf)

(= last row's hf)

Academy for Math, Engineering and Science

Masses of Rockets Without Engine

Type of Rocket Engine =

Drag Coefficient (kd) =

(= last row's vf)

You might also like