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.
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.
- 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.
- 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)_)
- 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)_)
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
THINKING LIKE AN ENGINEER W/ACCESS
Additional Engineering Textbook Solutions
Engineering Mechanics: Statics & Dynamics (14th Edition)
Engineering Mechanics: Dynamics (14th Edition)
Applied Fluid Mechanics (7th Edition)
Engineering Mechanics: Statics
Mechanics of Materials (10th Edition)
Applied Statics and Strength of Materials (6th Edition)
- Parameters Mass 5kg A=2 B=7 C(m)=3 D(m)=4.583arrow_forwardA spring has an unstretched length of 12 cm. When an 80 g ball is hung from it, the length increases by 4.0 cm. Then the ball is pulled down another 4.0 cm and released.a. What is the spring constant of the spring?b. What is the period of the oscillation?c. Draw a position-versus-time graph showing the motion of the ball for three cycles of the oscillation. Let the equilibrium position of the ball be y = 0. Be sure to include appropriate units on the axes so that the period and the amplitude of the motion can be determined from your graph.arrow_forwardA weight is attached to a spring suspended from a beam. At time t = 0, it is pulled down to a point 8 cm above the ground and released. After that, it bounces up and down between its minimum height of 8 cm and a maximum height of 24 cm, and its height h(t) is a sinusoidal function of time t. It first reaches a maximum height 1.4 seconds after starting. (a) Follow the procedure outlined in this section to sketch a rough graph of h(t). Draw at least two complete cycles of the oscillation, indicating where the maxima and minima occur. (b) What are the mean, amplitude, phase shift and period for this function? (Use a phase shift with an absolute value less than the period.) mean 16 amplitude 8 phase shift ___ period 2.8 (c) Give four different possible values for the phase shift. (Enter your answers as a comma-separated list.) _______ (d) Write down a formula for the function h(t) in standard sinusoidal form; i.e. as in the…arrow_forward
- A spring-mass system is shown in the following figure. Use m=3.5 kg and k=100 N/m. a. Determine the static deflection δst . Insert your answer in meters correct up to at least a third decimal place. b. Determine the system period τ. Insert your answer in seconds correct up to at least a third decimal place. c. Determine the maximum velocity vmax which results if the cylinder is displaced 140mm downward from its equilibrium position and released from rest. Insert your answer in m/s correct up to at least a third decimal place.arrow_forwardA device with a mass of 1000 kg is placed on top of the suspension, whereby the springs are compressed into a pile a distance of 4 mm. What is the system specific angle frequency (rad / s) to one decimal place?arrow_forwardA mechanical sine wave causes a displacement of 2,91 m after 1.15 sec. The wave has an amplitude of 3m. 1) draw the graph 2)determine equation 3)determine displacement after 3 secondsarrow_forward
- Her foot pivots as a single structure about a single pivot in her ankle. When she stands on tiptoe, her foot pivots about her ankle. As shown in the foot diagram and the free-body diagram below, the forces on one foot are an upward force on her toes from the floor, a downward force on her ankle from the lower leg bone (called the Tibia), and an upward force on the heel of her foot from her Achilles Tendon. Suppose a 61.3 kg woman stands on one foot, on tiptoe, with the sole of her foot making a 25.0 degree angle with the floor, and with the distances are as shown in the figure.arrow_forwardVibrations Engineering: r = 0.25 m initial angle = 1.25 radians initial angular speed = 4 radians per second Calculate: (Express the final answer in 4 significant digits) -the amplitude in radians -the phase angle in radians -the natural period in secondarrow_forwardPlease answer the following question A cigarettes dispenser requires a south African five-rand (R5) coin with a mass of 9.5 g to dispense one cigarette with a mass of 0.2 g. The design of such a cigarette dispenser is based on a helical spring, of negligible mass, which is found to extend 0.1 mm under a mass of 0.2 g. The spring can support a total mass of a coin. As the customer place money on the dispenser, the spring and coin system displace vertically through 4 mm and release. 1.1. Provide a schematic representation of the mass and spring system. 1.2. Calculate the frequency of natural vibration of the dispenser. 1.3. Determine the velocity of the coin when it is 2 mm below its resting position.arrow_forward
- An 8 bits absolute binary encoder is used to measure the distance traveled by the material in the conveyor. It is connected in the shaft (d=40cm) where the belt rotates. In the initial location of material the encoder reading is 11010110 as the conveyor rotates, the encoder created 2 complete rotation clockwise and end up with the value of 10001101. What is the distance travelled by the material.arrow_forwardVibration Engineering: Mass = 10 kilogramsSpring constant = 400 Newtons per meterPeriodic Force = 6 KilonewtonsForcing Frequency = 5 radians per secondDamping coefficient = 200 Newton second per meter Calculate: (Express the final answer in 4 significant digits) -the phase angle in radians -the natural frequency in radians per second -the amplitude of steady-state vibration in metersarrow_forwardUse of Infinite Sequences and Series in Problem Solving of Special Theory of Relativity. A spacecraft travels fast the earth has a greater velocity (ⱱ) which approximates the speed of light. The time (to) measured in the spacecraft is different from the time (t) measured on earth. The time difference is given, to = t √1- ⱱ 2/c2 = t (1 – ⱱ 2/c2)1/2.arrow_forward
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY