Excel phyc

Extra Credit – MSExcel – Part 1

· You are asked to prepare a MS-excel file, to be emailed to me ([email protected]) in an attachment by Wednesday 04/15.

· The file should be called PS103_Part1_xxx where xxx stands for your last name. Also, because we have a few people with the same last name, please write your full first and last name in the email you send me.

· The file should consist of two Excel sheets (in the same file).

First sheet – Horizontal_Flyer

· The user can enter the altitude and the speed of a horizontally flying airplane, and the program will calculate the range, the time of flight, the final horizontal and final vertical velocities and the final speed of a bomb dropped by the airplane.

· In the sheet there should be two columns labeled as ‘Altitude [m]’ and ‘Speed [m/s]’. These are where the user enters the values.

· The value of gravity acceleration g, must be entered in a single cell (not a column!) labeled as ‘g [m/s^2]’.

· There should be five columns labeled as ‘Range [m]’ ; ‘tflight [s]’ ; ‘vf-hor [m/s]’ ; ‘vf-ver [m/s]’ ; ‘vf [m/s]’. These values the program will calculate by using the values in the Altitude and Speed columns, and the value in the g cell (and the formulas for parabolic motion given in class and on the textbook).

· The program should look like in the figure below.

g
[m/s^2]		Altitude	Speed		Range	t-flight	vf-hor	vf-ver	vf
9.8		[m]	[m/s]		[m]	[s]	[m/s]	[m/s]	[m/s]
		10	100		142.8571	1.428571	100	14	100.9752
		10	200		285.7143	1.428571	200	14	200.4894
		100	10		45.1754	4.51754	10	44.27189	45.38722
		200	10		63.88766	6.388766	10	62.6099	63.40347

Second sheet – Vectors

· The user will enter the magnitude of a vector and the angle it forms with the x-axis, and the program will return the two vector components.

· The angle with the x-axis will be entered in degrees by the user.

· The program should have two columns labeled as ‘Magnitude’ and ‘x-angle [deg]’.

· The program will first convert the entered angle from degrees into radians (rad = deg*Pi/180). Then it will calculate the x-component and the y-component of the vector. These three quantities will be reported in three separate columns labeled as ‘x-angle [rad]’ ; ‘x-comp’ ; ‘y-comp’.

· The program should look like in the figure below.

Magnitude	x-angle		x-angle	x-comp	y-comp
	[deg]		[rad]
100	0		0	100	0
100	30		0.523599	86.60254	50
100	45		0.785398	70.71068	70.71068
100	60		1.047198	50	86.60254
100	90		1.570796	6.13E-15	100

· Please notice that for both sheets, the values in the Range, t-flight, x-angle, x-comp etc. columns must be calculated by the program, not entered by the user! If one changes for example the values of Amplitude or Speed, the Range, t-flight etc. should change automatically on that row. If you send me a file where the program does not calculate Range, t-flight etc. and you simply enter the numerical values from the table, you will get no credit points!