This preview shows page 1. Sign up to view the full content.
EGR 102 Introduction to Engineering Modeling
Lab 01B Homework
A quarterback is about to throw a pass to his wide receiver. He is standing still and is
supposed to hit the receiver straight down the field 50 ft away. The path of the football
through the air can be calculated using the following equation:
± ²(³´µ ¶) ·
¸
¹
º »
²
¼
½
¾¿À ¶
Á
Â
where
g
= 32.174 ft/s
2
,
is the vertical distance of the ball (ft) and
²
is the horizontal
distance from the quarterback (ft). The quarterback releases the ball with an initial
velocity
¼
½
(ft/s) and at an angle
¶
from the horizontal (rad).
Build an Excel spreadsheet to implement this equation. If the quarterback first attempts
to throw the ball with an initial velocity
v
0
= 50 ft/s and at an angle
¶
= 40°, calculate and
plot the path of the ball from
x
= 0 to 60 ft, using 5 ft increments. Use proper annotations
within the sheet and label your plot appropriately. Your sheet must use both absolute
and relative references. Structure your program so that the sheet updates automatically
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 04/02/2012 for the course EGR 100 taught by Professor Hinds during the Fall '08 term at Michigan State University.
 Fall '08
 HINDS

Click to edit the document details