{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lab1_demo3

# lab1_demo3 - and used in formulas on the Trajectory sheet...

This preview shows pages 1–3. Sign up to view the full content.

Comments Page 1 Flight of an Arrow In this model the distance an arrow flies in a horizontal direction from the position of the archer, given an initial velocity, is calculated for a number of different launch angles. The archer is assumed to have zero height! And the ground is assumed to be perfectly horizontal plane Note that if the launch angle is 0 (the arrow is fired horizontally) the distance it travels is 0; and if the arrow is fired straight up (launch angle 90) the distance it travels is also zero. Notice that the  arrow travels the greatest distance if the launch angle is 45 degrees. The workbook demonstrates the use of a number of new spreadsheet features. Firstly, parameters of the model are entered on a separate worksheet (called the Parameters sheet), given names (in this case g for the gravitational constant, and V for the initial velocity of the arrow,

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: and used in formulas on the Trajectory sheet. Try changing the value of the initial velocity and observe that the graph changes accordingly. Do not change the gravitational constant - that is constant throughout the (known) Universe! Secondly, a graph is incorporated into the Trajectory worksheet. Graphs are clearly very useful for visual presentation of information. Parameters Page 2 Model Parameters Initial velocity: 11 m/sec Gravitational constant: 9.8 m/sec 2 5 10 15 20 25 3035 4045 5055 60 65 70 75 80 85 90 0.0 2.0 4.0 6.0 8.0 10.0 12.0 14.0 Column B Launch Angle Distance Travelled by Arrow Launched at Various Angles Distance (meters) Trajectory Page 3 Launch Angle Distance 5 2.1440234 10 4.2229018 15 6.1734694 20 7.9364593 25 9.4583038 30 10.692763 35 11.602327 40 12.159361 45 12.346939 50 12.159361 55 11.602327 60 10.692763 65 9.4583038 70 7.9364593 75 6.1734694 80 4.2229018 85 2.1440234 90 1.51E-015...
View Full Document

{[ snackBarMessage ]}