Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
3rd Edition
ISBN: 9780133593211
Author: Elizabeth A. Stephan, David R. Bowman, William J. Park, Benjamin L. Sill, Matthew W. Ohland
Publisher: PEARSON
bartleby

Videos

Textbook Question
Book Icon
Chapter 10, Problem 12ICA

Refer to the Worksheet shown, set up to calculate the displacement of a spring. Hooke's law states that the force (F, in newtons) applied to a spring is equal to the stiffness of the spring (k, in newtons per meter) times the displacement {x, in meters): F = kx.

Chapter 10, Problem 12ICA, Refer to the Worksheet shown, set up to calculate the displacement of a spring. Hooke's law states

Cell A3 contains a data validation list of springs. The stiffness (cell 83) and maximum displacement (cell C3) values are found using a VLOOKUP function linked to the table shown at the right side of the worksheet. These data are then used to determine the displacement of the spring at various mass values. A warning is issued if the displacement determined is greater than the maximum displacement for the spring. Use this information to determine the answers to the following questions.

  1. a. Write the expression, in Excel notation, that you would type into cell 86 to determine the displacement of the spring. Assume you will copy this expression to cells 87 to B 17.
  2. b. Fill in the following information in the VLOOKUP function used to determine the maximum displacement in cell C3 based on the choice of spring in cell A3.

    =VLOOKUP(_(1)__,_(2)_,_(3)_,_(4)_)

  3. c. Fill in the following information in the IF function used to determine the warning given in cell C6, using the maximum displacement in cell C3. Assume you will copy this expression to cells C7 to C17.

    =IF(_(1)_,_(2)_,_(3)_)

Blurred answer
Students have asked these similar questions
You and a friend are raising a beam, but your friend's rope is too short so you lift him off the ground. At the current time, everything is static. The tension in your cord is 1045.6 N, the mass of the beam is 15 kg, and the mass of your friend is 85 kg. The length of the beam is 4.9 m, d = 3.9 m, theta = 43.5 degrees, phi = 62.5 degrees. If you choose the base of the beam as the origin, and the positive torque direction as counter-clockwise, what is the torque from your cord on the friend+beam system?
A four-bar mechanism is used to transmit power to slider E. Link AC rotates counterclockwise at 100 rpm. A and B are fixed points. The following linkages are measured in cm: AC=35, AB=70, CD=45, BD=45, DE=40. Find the instantaneous velocity of slider E in cm/s 1.Draw the mechanism in appropriate scale on your paper2. Find the instantaneous linear velocity of C3. Find a point on your paper to draw the velocity polygon and scale the magnitude of the computed linearvelocity4. Use the relative velocity equation for finding the linearvelocity of D; ? = ? + ?? ? ?/?5. Remember that although the magnitudes are unknown, their directions can be identified6. Obtain the magnitudes of the unknown velocities from the velocity polygon7. For Link DE, repeat the process by using ? = ? + ??the line as much as needed8. Remember that E is a SLIDER therefore it can only goin the direction where its movement is not constrained? . Add the vector ? to the head of ? and extend?/? ?/??
The complete slide- back and forth motion of a single reciprocating compressor piston completes in a 2-sec period. The volume displacement of the piston though the piston cylinder is 8,902.63 in3. The stiffness of crank is said to be equal to 65.5N/m and the mass of the said piston is at 10kgs. Obtain the following  1. Plot the graph of the following relationship: A) Position vs Time graph B) Velocity vs Time C) Acceleration vs Time

Chapter 10 Solutions

Thinking Like an Engineer: An Active Learning Approach (3rd Edition)

Ch. 10.6 - In 1980, the Environmental Protection Agency (EPA)...Ch. 10 - ICA 10-5 The worksheet shown here was designed to...Ch. 10 - The worksheet provided was designed to calculate...Ch. 10 - Some alternate energy technologies, such as wind...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - Refer to the following worksheet. The following...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Refer to the following worksheet. In all...Ch. 10 - Prob. 10ICACh. 10 - A bioengineer conducts clinical trials on...Ch. 10 - Refer to the Worksheet shown, set up to calculate...Ch. 10 - You are interested in analyzing different implant...Ch. 10 - You have a large stock of several values of...Ch. 10 - We accidentally drop a tomato from the balcony of...Ch. 10 - You are interested in calculating the best place...Ch. 10 - 1. A history major of your acquaintance is...Ch. 10 - Prob. 3RQCh. 10 - 4. A phase diagram for carbon and platinum is...Ch. 10 - 4. A simplified phase diagram for cobalt and...Ch. 10 - 5. You enjoy drinking coffee but are particular...Ch. 10 - 6. In the 1950s, a team at Los Alamos National...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - 11. When liquid and vapor coexist in a container...Ch. 10 - 12. The ideal gas law assumes that molecules...Ch. 10 - One of the NAE Grand Challenges for Engineering is...Ch. 10 - 16. A substance used to remove the few remaining...Ch. 10 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 18RQ
Knowledge Booster
Background pattern image
Mechanical Engineering
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Text book image
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Text book image
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Text book image
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Text book image
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Text book image
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Mechanical SPRING DESIGN Strategy and Restrictions in Under 15 Minutes!; Author: Less Boring Lectures;https://www.youtube.com/watch?v=dsWQrzfQt3s;License: Standard Youtube License