Question: INSTRUCTIONS: You may use MS Excel or Google Sheets to accomplish this Machine Problem. The contents of the write - up are listed below. Start

INSTRUCTIONS:
You may use MS Excel or Google Sheets to accomplish this Machine Problem.
The contents of the write-up are listed below. Start each problem on a new page.
a) Problem Title
Write an appropriate title at the top of the first page.
b) Problem Statement
Summarize the problem statement (in paragraph form).
c) Results and Discussion
Provide a short discussion of results. Explain and show your complete solution, including derivations (if necessary) and equations used. BOX your final answers.
d) Problems Encountered
Write a paragraph about the problems you have encountered in accomplishing this Machine Problem. It may involve the statement of the problem and/or difficulty of the problem. Also, narrate how you responded to these problems.
e) References
Make a list of references (books, internet sources, etc.) used to solve the problems.
Write-up should be written in letter-sized paper and should be saved in PDF format. All files (PDF, MS Excel, or Google Sheets) shall be submitted in your respective MS Teams.
Submission date will be as indicated in the MS Teams. Late submissions will not be accepted for whatever reason.
PROBLEM NO.1
An L-shaped rod's position is controlled by a cable attached at B as shown in Figure 1. The rod supports a load of P=50lb, create a worksheet or spreadsheet to calculate the tension T in the cable for values of from 0 to 120 using 10 increments. Using appropriate smaller increments, calculate the maximum tension T and the corresponding value of .
PROBLEM NO.2
The position of the 10-kg rod AB is controlled by the block shown in Figure 2 which is slowly moved to the left by the force P. Create a worksheet or spreadsheet that can be used to calculate the magnitude of P for values of x decreasing from 750mm to 0 using 50-mm increments. Using appropriate smaller increments, determine the maximum value of P and the corresponding value of x. Neglect the effect of friction.
PROBLEM NO.3
The derrick shown in Figure 3 supports a 2000-kg crate. It is held by a ball-and-socket joint at A and by two cables attached at D and E. Knowing that the derrick stands in a vertical plane forming an angle O? with the xy plane, create a worksheet or spreadsheet that can be used to calculate the tension in each cable for values of O? from 0 to 60 using 5 increments. Using appropriate smaller increments, determine the value of O? for which the tension in cable BE is maximum.
INSTRUCTIONS: You may use MS Excel or Google

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Civil Engineering Questions!