DOC PREVIEW
PSU METBD 050 - Tension In Cables Graphing

This preview shows page 1 out of 2 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

METBD 050 Homework 9 Tension in Cables: A common problem in Statics is to find the force in two cables that hold up a load as shown in the figure below. The force in each of the cables AB and AC are given by the following formulas: )()(θθCosFFSinWFACABAC== Create a worksheet to compute the force in the cables if W is a variable input and the angle, q, varies from 20° to 80° in 5° intervals. Use W = 200 pounds. A B C D 1 Your Name 2 METBD 050.n 3 Date 4 Force in Wire Activity 5 6 Load, W = 200 lbs 7 8 Angle, θ (degrees) FAB (pounds) FAC (pounds) 9 20 Cell formula 1 Cell formula 2 10 25 11 30 12 35 … 70 75 80 What to do: 1. Write Cell formula 1 and copy it down the column. 2. Write Cell formula 2 and copy it down the column. 3. Make sure your name and section are in the worksheet and print the worksheet. Be sure to print the row and column headings with the gridlines. 4. Use a pencil and write the your version of Cell formula 1 and Cell formula 2 below: Cell Formula 1: ___________________________________________________ Cell Formula 2: ___________________________________________________ W C A Bθ Name: ______________________________________ Copy Copy5. Make an XY(Scatter) chart of the force in cable AB. Use the following parameters when formatting your chart: a. Plot area is white b. Bold red line for the data series. c. Y-axis ranges from 0 to 600 lbs and x-axis ranges from 0 to 80 degrees. 20 is the major unit and 5 is the minor unit for the x-axis. Use 100 for major units and 50 for minor units on the y-axis. Use crossing tick marks for major divisions and outside tick marks for minor division. d. No decimals on either axis. Use 10 point text. e. Chart title is “Force in a Cable.” Chart title is 14 point Arial. The axis titles should be “Angle, θ (degrees)” and “Force in AB, FAB (lbs)” Axis titles are 12 point Arial font. f. No legend g. Save the chart on its own sheet. Add a header with your name to this sheet. h. Print your chart 6. Add the data series for the force in AC. Change the formatting as follows. a. Chart title becomes “Forces in Cables” b. The y-axis title becomes “Force in AB and AC (lbs)” c. BC is a bold blue data series line. d. Add a legend – Indicate FAB and FAC in the legend. e. Print your chart. 7. Add a second axis to the chart. The secondary axis will be measured in Newtons. The title for this axis is “Force in AB and AC (N)”. A pound is equal to 4.448 Newtons. a. Add a data point having any coordinates you wish. b. Right click on the point and select Format Data Series. Select Secondary Axis from the Axis tab. c. Format the new axis like before. The minimum value should be 0 like the other axis. The maximum value should be equivalent to the other axis maximum. 600 lbs = 600 lbs(4.448 N/lb) = 2668.8 N d. The major unit for the secondary axis is 500 N and the minor units should be 100 N. Use crossing and outside tick marks. e. Print your chart again. 8. Staple the three charts to the back of the first sheet of this


View Full Document

PSU METBD 050 - Tension In Cables Graphing

Download Tension In Cables Graphing
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Tension In Cables Graphing and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Tension In Cables Graphing 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?