Concept explainers
ICA 10-5
The worksheet shown here was designed to calculate the total pressure felt by an object submerged in a fluid as a function of the depth to which the object is submerged. The user will enter the surface pressure (in units of atmospheres), specific gravity of the fluid, and the gravity of the planet (in units of meters per second squared). All user input is shown in red. The worksheet will calculate the surface pressure in units of pascals, the density of the fluid in kilograms per cubic meter, and depth in units of feet. All conversions are shown in orange. Finally, the worksheet will calculate the total pressure in units of atmospheres.
- a. What formula should be typed in cell C8 to convert the surface pressure in cell C4 from atmospheres to pascals?
- b. What formula should be typed in cell C9 to determine the density in units of kilograms per cubic meter?
- c. What formula should be typed into cell B12 that can then be copied clown column B to convert the depth from units of feet to units of meters?
- d. What formula should be typed into cell C12 that can then be copied down column C to calculate the total pressure in units of atmospheres?
a.
Write the formula to be entered in cell C8 to convert the atmospheres surface pressure entered in cell C4 to Pascal.
Answer to Problem 1ICA
The formula to be entered in cell C8 to convert the atmospheres surface pressure entered in cell C4 to Pascal is “
Explanation of Solution
Given data:
The worksheet is given as follows.
Calculation:
Consider the conversion factor for atmospheres to Pascal.
Step 1:
Using equation (1), enter the formula “
Conclusion:
Hence, the formula to be entered in cell C8 to convert the atmospheres surface pressure entered in cell C4 to Pascal is “
b.
Write the formula to be entered in cell C9 to determine the density in units of kilograms per cubic meter.
Answer to Problem 1ICA
The formula to be entered in cell C9 to determine the density in units of kilograms per cubic meter is “
Explanation of Solution
Calculation:
Write the expression for density.
Step 1:
Using equation (2), enter the formula “
Conclusion:
Hence, the formula to be entered in cell C9 to determine the density in units of kilograms per cubic meter is “
c.
Write the formula to be entered in cell B12 that can be then be copied down column B to convert the depth in feet to meters.
Answer to Problem 1ICA
The formula to be entered in cell B12 that can be then be copied down column B to convert the depth in feet to meters is “
Explanation of Solution
Calculation:
Write the conversion factor for feet to meter.
Step 1:
Using equation (3), enter the formula “
Drag the same formula for remaining cells in the column to obtain the value of depth in terms of m as shown in Figure 4.
Conclusion:
Hence, the formula to be entered in cell B12 that can be then be copied down column B to convert the depth in feet to meters is “
d.
Write the formula to be entered in cell C12 that can be then be copied down column C to calculate the total pressure in atmospheres.
Answer to Problem 1ICA
The formula to be entered in cell C12 that can be then be copied down column C to calculate the total pressure in atmospheres is “
Explanation of Solution
Calculation:
Write the expression for total pressure.
Re-arrange equation (1) as follows.
Step 1:
Since, the content of cell C8 is in Pascal, the result obtained for total pressure using cell C8, C9, C6 and B12 is divided by 101,325 to convert the result from Pascal to atmosphere.
Using equation (4) and (5), enter the formula “
Drag the same formula for remaining cells in the column to obtain the total pressure value as shown in Figure 6.
Since, the content of cell C4 is in atmosphere, the result obtained for
Using equation (4) and (5), enter the formula “
Drag the same formula for remaining cells in the column to obtain the total pressure value as shown in Figure 8.
Compare Figure 5 with Figure 7 and Figure 6 with Figure 8, the result obtained for total pressure using formula
Conclusion:
Hence, the formula to be entered in cell C12 that can be then be copied down column C to calculate the total pressure in atmospheres is “
Want to see more full solutions like this?
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
Additional Engineering Textbook Solutions
Mechanics of Materials
Applied Fluid Mechanics (7th Edition)
EBK FUNDAMENTALS OF THERMODYNAMICS, ENH
Fundamentals of Aerodynamics
Fluid Mechanics Fundamentals And Applications
DeGarmo's Materials and Processes in Manufacturing
- Engr 215 Matlab Fahrenheit to Celsius using multiple statements Given a Fahrenheit value temperatureFahrenheit, write a statement that assigns temperatureCelsius with the equivalent Celsius value. While the equation is C = 5/9 * (F - 32), as an exercise use two statements, the first of which is "fractionalMultiplier = 5/9;"]arrow_forward2:01 ul 4G 4. A sulms.su.edu.om While constructing a building, an engineer need to fix two steel beams together using a bracket as shown in Figure 1. Using absolute coordinate system, construct a G-code program for drilling hole number 3 only. To remove the metal chips the hole should be done in three equal steps. During the drilling, coolant should be on before spindle starts and stop after spindle stops. The spindle speed set to 1750 RPM. Drilling bit in rack number 2 and it should be 1 mm over the work piece. Drilling feed rate is 20 mm/min. Explain each code used in the program in a column 57.5- 12.5 Hole (4) Hole (3) 30 Hole (1) Hole (2) ΧΟ Υ0ΖΟ All dimensions shown are in mm Figure 1 B. -> 28 •..arrow_forward3) Body mass index (BMI) of a person is a measure of body fat based on height and weight. In U.S. customary units it is calculated by: BMI = 703" %D where W is the person's weight in pounds and h is the heights in inches. Write a MATLAB program in a script file that calculates the BMI. For input the program asks the user to enter his/her weight and height. The pro- gram then calculates the BMI rounded to the nearest tenth. For output the program displays the message: "The BMI is: XX." where XX is the value of the BMI. Determine the BMI of a 68-in.-tall person that weigh162 lb.arrow_forward
- A company finds that if they price their product at $ 65, they can sell 690 items of it. For every dollar increase in the price, the number of items sold will decrease by 10. What is the maximum revenue possible in this situation? (Do not use commas when entering the answer) $ What price will guarantee the maximum revenue? $ Submit Question 國山品 12 MacBook Air esc 吕口 F3 F2 F4 F7arrow_forwardFor Questions 3 and 4: A cup of water was heated to a temperature of 90°. It was placed in a refrigerator that had a temperature of 11°C. The water cooled to a temperature of 17°C in 30 minutes. Let the following variables represent the relevant quantities. L = Temperature of the liquid S= Temperature of the surroundings t = Time B = Initial temperature of the liquid (Temperature at t = 0 k = Cooling constant 3. Using the Equation Solver, find the value of k in the equation L = (B - S)e -kt + S. Remember to set the equation equal to zero and then enter it into the Solver.arrow_forwardsample calculations 目 File Edit View Insert Format Data To 100% $ % .0 .00 12: fx | A 1 Variable Value Units diameter height m 4 volume m^3 3 The image above shows a section of a Google sheet. What formula should be written in cell B4 to calculate the volume of a cylinder with a diameter value in B2 and height in B3? a) =0.25*PI()*B2^2 * B3 b) =PI()*B2^2 * B3 c) =pi*diameter^2 * height d) =PI*B2^2 * B3 3 5arrow_forward
- 7. When you work for a company that studies the performance of car engines, you are tasked with accurately measuring the amount of air intake by car engines. A gas flow meter was introduced from the United States to measure the amount of air. This flow meter measures the flow rate using the pressure difference. Looking at the instruction manual of this flow meter, the following equations were found for the pressure difference head and volume flow [unit, volume/time]. ▷ Volumetric Flow Rate[ft°/min]: =(55.3658* DP-0.143168* DP^ 2)) However, DP is the head (water height) of the manometer, and the unit is inch to be. In the above equation, if you insert DP[inch], the air volume flow rate can be calculated and the unit of the volume flow rate is ft/min. Complex unit conversion is included in the constant in front of DP, so you don't need to worry about it. Before the experiment to measure the amount of air inhaled into the engine, the current atmospheric pressure and temperature were…arrow_forwardQ4: Create a Visual Basic Project to find the value of the following series: h? h4 h3 cos(h) = h – 2! 3! 4! Write the code program so that the value of angle (h) is entered into inputbox. Estimate the value of series (cos(h)) so that the absolute value of any term is greater or equal to 10-6. Display the required number of terms (N) which it used in this series in a text box and display the result of series (cos(h)) in another separate text box.arrow_forwardYou have three springs. You conduct several tests and determine the following data. Click the icon to view the provided graph. Choose one correct spring or spring combination that will meet the following criteria as closely as possible. Assume you have one of each spring available for use. List the spring or spring combination and the resulting spring constant. (a) You want the spring or spring system to hold 71 grams [g] and displace approximately 0.75 centimeters [cm]. The appropriate system is spring 2 and spring 3 in parallel with the stiffness of N/m. (Round your answer to the nearest whole number.) More Info Force (F) [N] F = 0.075x F = 0.035x F = 0.02x Spring #1 Spring #2 ▲ Spring #3 Elongation (x) [mm] Xarrow_forward
- A member of your team gives you the following MATLAB program. Your job is to create the function used in the program. H = 30; % height [cm] V = 50; % volume [cm^3] % calculates the radius [cm] of a cone R2 = RadiusCone(H,V);arrow_forwardEngineering Mechanics IIA man shooting a ball to ring 19.68 ft high from the ground has a velocity of 16.2 m/s. If the angle made by the man is 38 degrees, determine the distance (in m) from where the man is shooting.you can download the book we are using through this link (it should help in getting the right answer) :https://drive.google.com/file/d/1Ws-HdkaO4OAfTMa1crhsf63rbClZUCl5/view?usp=sharingarrow_forwardThe elevations of the ski jumping hill shown below are as follows: hA = 37 mhB = 2.4 mhC = 5.5 m If the velocity of a ski jumper is measured to be 25.3 m/s at position B, what will be the launch velocity (in m/s) at position C [round your final answer to one decimal place]?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