Clear the grey background from the graph
Technical Computations
Overhead Crane
Background:
Mechanical design engineers need to assure that machines that they
create are safe. One method of insuring safety is calculating the amount
of stress that is encountered in different components of a machine. One
common machine is an overhead crane, which is used in factories to
assist lifting heavy objects. Boom width, w
|
σ = | 6 | FL | cos |
|
|||
|---|---|---|---|---|---|---|---|---|
| Assignment: Create a VBA function that can be used in an Excel spreadsheet that calculates the stress for several forces and angles. The yield point, location, height and width should be values easily changed. |
e | wh | ||||||
Also generate a graph of stress versus angle.
The graph should contain 5 lines, one for
each force in the table. Make sure a legend
properly identified each line. Clear the grey
background from the graph. Place both
horizontal and vertical gridlines, and set
them to a dashed style.
