Sample Memos - Sample Memos -1-To: Anirudh Patrachari From:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
------------------------------------------------------------------- 1 ------------------------------------------------------------------ To: Anirudh Patrachari From: XXXXX XXXXX Date: 1/27/2010 Subject: Assignment #1 Discussion and Validation Andy, I have completed the regular Assignment #1 for ENGR 1412.701, as well as the honors assignment (the cannon problem). For the first assignment (concerning falling objects), I designed a spreadsheet that would use various input fields, such as initial velocity, gravitational acceleration, etc., to find the height of an object versus the time that the object is falling. The different sheets of the workbook “Homework 1v3.xlsx” are simply the same fields and graphs consisting of different planet’s values for gravitational acceleration. These values were found at the following website: http://www.zyra.org.uk/gravities.htm . This spreadsheet was validated by picking various points (Earth’s gravity at a 35 degree launch angle at .14 seconds and Mars’ gravity at a 55 degree launch angle at .06 seconds) and performing the calculations by hand according to the formula for the height of a falling body with constant acceleration. Both of these values coincided to the spreadsheet’s values with accuracy to at least eight decimals. The second spreadsheet, “Homework 1 Honorsv4.xlsx,” contains the data that I entered to find the angle that a cannon must be fired at to intercept a saucer launched simultaneously, but with varying velocities and angles. After initially reaching a stalemate in this problem, due to an incorrect value of the cannon’s initial velocity, the approach was quite simple. The calculations involve finding the time at which the saucer reaches the x coordinate of intersection, and then solving for the cannon’s firing angle by dividing the x distance by the cannon’s velocity and the said time. These results were also validated using a calculator by solving both the x and y position formulas, as well as using Excels solver tool with the help of XXXXXXXX XXXXX . The values in all three scenarios were accurate to at least two decimal places, most likely due to rounding. The incorrect spreadsheet is given as the second sheet in the workbook, so that my full process can be seen. Both files contain graphs to represent the tables of values that I programmed. Also, I referenced a site ( http://www.techonthenet.com/excel/formulas/if.php ) to learn how to use the IF() function to keep the height value of the first assignment from became negative real numbers and distorting the graphs. XXXXX XXXXX
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/12/2011 for the course ENGR 1412 taught by Professor Staff during the Spring '08 term at Oklahoma State.

Page1 / 4

Sample Memos - Sample Memos -1-To: Anirudh Patrachari From:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online