Thinking Like an Engineer: An Active Learning Approach (4th Edition)
4th Edition
ISBN: 9780134639673
Author: Elizabeth A. Stephan, David R. Bowman, William J. Park, Benjamin L. Sill, Matthew W. 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
5670 mm
The apartment in the ground floor of three floors building in Fig. in Baghdad city. The details of
walls, roof, windows and door are shown. The window is a double glazing and air space thickness
is 1.3cm Poorly Fitted-with Storm Sash with wood strip and storm window of 0.6 cm glass
thickness. The thickness of door is 2.5 cm. The door is Poor Installation. There are two peoples
in each room. The height of room is 280 cm. assume the indoor design conditions are 25°C DBT
and 50 RH, and moisture content of 8 gw/kga. The moisture content of outdoor is 10.5 gw/kga.
Calculate heat gain for living room :
الشقة في الطابق الأرضي من مبنى ثلاثة طوابق في مدينة بغداد يظهر في مخطط الشقة تفاصيل الجدران والسقف
والنوافذ والباب. النافذة عبارة عن زجاج مزدوج وسمك الفراغ الهوائي 1.3 سم ضعيف الاحكام مع ساتر حماية مع إطار
خشبي والنافذة بسماكة زجاج 0.6 سم سماكة الباب 2.5 سم. الباب هو تركيب ضعيف هناك شخصان في كل غرفة.
ارتفاع الغرفة 280 سم. افترض أن ظروف التصميم الداخلي هي DBT25 و R50 ، ومحتوى الرطوبة 8…
How do i solve this problem?
Q4/ A compressor is driven motor by mean of a flat belt of thickness 10 mm and a width of
250 mm. The motor pulley is 300 mm diameter and run at 900 rpm and the compressor
pulley is 1500 mm diameter. The shaft center distance is 1.5 m. The angle of contact of
the smaller pulley is 220° and on the larger pulley is 270°. The coefficient of friction
between the belt and the small pulley is 0.3, and between the belt and the large pulley is
0.25. The maximum allowable belt stress is 2 MPa and the belt density is 970 kg/m³.
(a) What is the power capacity of the drive and (b) If the small pulley replaced by
V-grooved pulley of diameter 300 mm, grooved angle of 34° and the coefficient of
friction between belt and grooved pulley is 0.35. What will be the power capacity in this
case, assuming that the diameter of the large pulley remain the same of 1500 mm.
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
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
- You are tasked with designing a power drive system to transmit power between a motor and a conveyor belt in a manufacturing facility as illustrated in figure. The design must ensure efficient power transmission, reliability, and safety. Given the following specifications and constraints, design drive system for this application: Specifications: Motor Power: The electric motor provides 10 kW of power at 1,500 RPM. Output Speed: The output shaft should rotate at 150 rpm. Design Decisions: Transmission ratio: Determine the necessary drive ratio for the system. Shaft Diameter: Design the shafts for both the motor and the conveyor end. Material Selection: Choose appropriate materials for the gears, shafts. Bearings: Select suitable rolling element bearings. Constraints: Space Limitation: The available space for the gear drive system is limited to a 1-meter-long section. Attribute 4 of CEP Depth of knowledge required Fundamentals-based, first principles analytical approach…arrow_forward- | العنوان In non-continuous dieless drawing process for copper tube as shown in Fig. (1), take the following data: Do-20mm, to=3mm, D=12mm, ti/to=0.6 and v.-15mm/s. Calculate: (1) area reduction RA, (2) drawing velocity v. Knowing that: ti: final thickness V. Fig. (1) ofthrearrow_forwardA direct extrusion operation produces the cross section shown in Fig. (2) from an aluminum billet whose diameter 160 mm and length - 700 mm. Determine the length of the extruded section at the end of the operation if the die angle -14° 60 X Fig. (2) Note: all dimensions in mm.arrow_forward
- For hot rolling processes, show that the average strain rate can be given as: = (1+5)√RdIn(+1)arrow_forward: +0 usão العنوان on to A vertical true centrifugal casting process is used to produce bushings that are 250 mm long and 200 mm in outside diameter. If the rotational speed during solidification is 500 rev/min, determine the inside radii at the top and bottom of the bushing if R-2R. Take: -9.81 mis ۲/۱ ostrararrow_forward: +0 العنوان use only In conventional drawing of a stainless steel wire, the original diameter D.-3mm, the area reduction at each die stand r-40%, and the proposed final diameter D.-0.5mm, how many die stands are required to complete this process. онarrow_forward
- In non-continuous dieless drawing process for copper tube as shown in Fig. (1), take the following data: Do-20mm, to=3mm, D=12mm, ti/to=0.6 and vo-15mm/s. Calculate: (1) area reduction RA, (2) drawing velocity v. Knowing that: t₁: final thickness D₁ V. Fig. (1) Darrow_forwardA vertical true centrifugal casting process is used to produce bushings that are 250 mm long and 200 mm in outside diameter. If the rotational speed during solidification is 500 rev/min, determine the inside radii at the top and bottom of the bushing if R-2Rb. Take: 8-9.81 m/sarrow_forwardIn conventional drawing of a stainless steel wire, the original diameter D.-3mm, the area reduction at each die stand r-40%, and the proposed final diameter D₁-0.5mm, how many die stands are required to complete this process.arrow_forward
- A vertical true centrifugal casting process is used to produce bushings that are 250 mm long and 200 mm in outside diameter. If the rotational speed during solidification is 500 rev/min, determine the inside radii at the top and bottom of the bushing if R-2Rb. Take: 8-9.81 m/sarrow_forwardIn non-continuous dieless drawing process for copper tube as shown in Fig. (1), take the following data: Do-20mm, to=3mm, D=12mm, ti/to=0.6 and vo-15mm/s. Calculate: (1) area reduction RA, (2) drawing velocity v. Knowing that: t₁: final thickness D₁ V. Fig. (1) Darrow_forward-6- 8 من 8 Mechanical vibration HW-prob-1 lecture 8 By: Lecturer Mohammed O. attea The 8-lb body is released from rest a distance xo to the right of the equilibrium position. Determine the displacement x as a function of time t, where t = 0 is the time of release. c=2.5 lb-sec/ft wwwww k-3 lb/in. 8 lb Prob. -2 Find the value of (c) if the system is critically damping. Prob-3 Find Meq and Ceq at point B, Drive eq. of motion for the system below. Ш H -7~ + 目 T T & T тт +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