EBK THINKING LIKE AN ENGINEER
4th Edition
ISBN: 8220103633512
Author: OHLAND
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 16ICA
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)_)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
6. Determine the coordinates x, y of the centroid of the area shaded in Figure 6.
y
y=x³
Figure 6
3
3. Use the method of sections to determine the forces in the members BD, CD, CE in the struc-
ture of Figure 3.
A
B
D
4 kN
6 kN
all dimensions in meters.
Figure 3
A pipeline engineer is considering alternative natural gas pipeline routings. The first route is mostly over land and the second is primarily undersea. Both pipelines will need some valve and fitting replacements in year 25. Cost data for each route is shown in Table P2.21. Notice that the undersea route has a higher initial cost due to higher installation costs and extra corrosion protection for the pipeline. However, the undersea route has cheaper security and maintenance costs which substantially reduces annual costs. The MARR for the project is 15%. Determine which route should be pursued based on a present worth analysis.
Chapter 10 Solutions
EBK THINKING LIKE AN ENGINEER
Ch. 10.1 - Type 5 in cell E22 and 13 in cell E23; type =E22 +...Ch. 10.1 - Type 45 into cell G22 and =G22 + 10 in cell H22....Ch. 10.1 - Type 40 into cell A28 and =A28 + 10 in cell D28....Ch. 10.1 - Type 40 into cell A28 and =A28 + 5 in cell G28....Ch. 10.2 - Launch a new worksheet. Type the following Excel...Ch. 10.2 - As part of the design of a high-performance...Ch. 10.3 - Evaluate the following expressions. What is the...Ch. 10.3 - Prob. 8CCCh. 10.4 - This is a continuation of the worksheet you...Ch. 10.5 - Prob. 11CC
Ch. 10.6 - In 1980, the Environmental Protection Agency (EPA)...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...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. 14ICACh. 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. 2RQCh. 10 - 3. 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 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 16RQ
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
?.1 Define the different reference meridians that can be used for the direction ofa line.
Elementary Surveying: An Introduction To Geomatics (15th Edition)
What is an object?
Starting Out With Visual Basic (8th Edition)
(Attributes of Hybrid Vehicles) In this chapter you learned the basics of classes. Now youll begin fleshing out...
Java How to Program, Early Objects (11th Edition) (Deitel: How to Program)
In Exercises 55 through 60, find the value of the given function where a and b are numeric variables of type Do...
Introduction To Programming Using Visual Basic (11th Edition)
Describe a method that can be used to gather a piece of data such as the users age.
Web Development and Design Foundations with HTML5 (8th Edition)
Male and Female Percentages Design a program that asks the user for the number of males and the number of femal...
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
Knowledge Booster
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
- The state of stress at a point is σ = -4.00 kpsi, σy Tyz = 8.000 kpsi, and T₂ = -14.00 kpsi. What is the maximum shear stress for this case? The maximum shear stress is kpsi. = 16.00 kpsi, σ = -14.00 kpsi, Try = 11.00 kpsi,arrow_forwardThe initial cost of a proposed heat recovery system is $375,000. The annual operation andmaintenance costs are projected to be $12,000. The salvage value of the system at the end of itsuseful life (projected to be 30 years) is $60,000. The annual savings in fuel costs resulting fromthis system are estimated to be $55,000 per year.a. Assuming annual compounding, determine the rate of return for this heat recovery system.b. If management has set the MARR to be 15% for a heat recovery system like this, what is themaximum initial cost that can be spent on the system (assuming that all other costs and incomesare the same)?arrow_forwardThe initial cost of a machine for a production facility is $225,000. The machine is expected tolast for 10 years with no salvage value. The company’s tax rate is 49% and SLD is used todepreciate the machine. For this type of depreciation, the tax life of the machine is considered 8years and its salvage value is $5,000. The after-tax rate of return is 14.3%. Determine the uniformannual before-tax cash flow.arrow_forward
- Three alternatives are being considered for an air cleaning system. All three systems have a lifeof 10 years with no salvage value. System A has an initial cost of $29,000. During the first fiveyears of operation, the annual costs to operate system A are $5,000. During the second five years,the annual cost of system A increases to $16,000. System B has an initial cost of $43,000. Theannual cost to operate system B is $4,000, however, after the first year, this cost increases by$1,600 per year. System C has an initial cost of $58,000 with an annual cost of $2,400. System Crequires two upgrades: one during year 4 which costs $6,000, and the other during year 8 whichcosts $3,000. The MARR for this project is 17%. Determine which air cleaning system should beinstalled based on an economic analysis.arrow_forwardShow all work as much as you can and box out answersarrow_forwardShow as much work as possible and box out answers pleasearrow_forward
- on-the-job conditions. 9 ±0.2- 0.5 M Application questions 1-7 refer to the drawing above. 1. What does the flatness tolerance labeled "G" apply to? Surface F A. B. Surfaces E and F C. Surfaces D, E, H, and I D. The derived median plane of 12 +0.2 0.5 0.5 CF) 20 ±0.2 0.1 7. O 12 ±0.2- H 0.3 ASME Y14.5-2009arrow_forwardelements, each with a length of 1 m. Determine the temperature on node 1, 2, 3, 4. 3. Solve the strong form analytically (you may choose Maple, MATLAB or Mathematica to help you solve this ODE). Compare the FE approximate temperature distribution through the block against the analytical solution. 1 (1) 200 °C 2 (2) 3 m 3 (3)arrow_forwardCompute the horizontal and vertical components of the reaction at the pin A. B A 30° 0.75 m 1 m 60 N 0.5 m 90 N-marrow_forward
- A particle is held and then let go at the edge of a circular shaped hill of radius R = shown below. The angular motion of the particle is governed by the following ODE: + 0.4 02 - 2 cos 0 + 0.8 sin 0 = 0 where is the angle in rad measured from the top (CCW: +), ė 5m, as = wis the velocity in rad/s, ==a is the angular acceleration in rad/s². Use MATLAB to numerically integrate the second order ODE and predict the motion of the particle. (a) Plot and w vs. time (b) How long does it take for the particle to fall off the ring at the bottom? (c) What is the particle speed at the bottom. Hint v = Rw. in de all questions the particles inside the tube. /2/07/25 Particle R 0 0 R eled witharrow_forwardIf FA = 40 KN and FB = 35 kN, determine the magnitude of the resultant force and specify the location of its point of application (x, y) on the slab. 30 kN 0.75 m 90 kN FB 2.5 m 20 kN 2.5 m 0.75 m FA 0.75 m 3 m 3 m 0.75 marrow_forwardThe elastic bar from Problem 1 spins with angular velocity ω about an axis, as shown in the figure below. The radial acceleration at a generic point x along the bar is a(x) = ω 2 x. Under this radial acceleration, the bar stretches along x with displacement function u(x). The displacement u(x) is governed by the following equations: ( d dx (σ(x)) + ρa(x) = 0 PDE σ(x) = E du dx Hooke’s law (2) where σ(x) is the axial stress in the rod, ρ is the mass density, and E is the (constant) Young’s modulus. The bar is pinned on the rotation axis at x = 0 and it is also pinned at x = L. Determine:1. Appropriate BCs for this physical problem.2. The displacement function u(x).3. The stress function σ(x).arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University Press
Mechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSON
Thermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEY
Mechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage Learning
Engineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
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