You are interested in analyzing different implant parts being made in a bioengineering production facility. The company can make nine different parts for shoulder, knee, or hip replacement.
On the worksheet shown, you have created a place for the user to choose the body location (shoulder, knee, or hip) in cell B5 using a data validation list. Once the body location is set, a list of material choices will appear in cells D5 to F5. The user can choose a material in cell B6 using a data validation list. If the material chosen does not match one of the possible choices in cells D5 to F5, a warning will be issued for the user to choose another material.
In cell B9, the user will choose if the part is size small (S), medium (M), or large (L) using a data validation list. Based upon body location and size, the part number will adjust automatically using a VLOOKUP function. After the part number has been determined, the material weight (cell B11) and part volume (cell B12) will adjust automatically using a VLOOKUP function.
The user will enter the number of desired parts in cell B14. If the user requests more than 250 parts, a warning of “Too Many” will be issued; if the user requests fewer than 20 parts, a warning of “Too Small” will be issued in cell C14.
The amount of material to be ordered will be determined in cell B16 by multiplying the number of pans and the material weight. The cost of the material to be ordered will be determined in cell B17. If the order cost is greater than $1000, a request to “Check with Purchasing” will appear, otherwise, the cost of the order will appear. Finally, in cell B18 the amount of boxes needed for shipping will appear determined by the number of parts requested and the number of pans per box, based on the pan number chosen in cell B10.
Lookup functions in Excel contain four parts.
=VLOOKUP (__ (1) __,__(2) __,__ (3) __,__ (4) __)
- a. Fill in the following information in the VLOOKUP function used to determine the third possible material choice in cell F5 based on the choice of body location in cell B5
An IF statement in Excel contains three pans. Fill in the following information in the IF function used to determine the following conditions:
= IF(__ (1) __,__ (2) __,__ (3) __)
- b. In cell C6, a warning is issued to the user if the material chosen in cell B6 does not match the list of materials provided in cells D5 to F5. Fill in the IF statement used to create this error message, containing a complex IF test using AND or OR.
A nested IF statement in Excel contains three parts per IF statement. Fill in the following information in the IF function used to determine the following conditions:
=IF (__ (1a) __,__ (2a) __, IF(__ (1b) __,__ (2b) __,__ (3b) __))
- c. In cell B14, the user can enter the number of parts needed in production. If this value is more than 250 parts, a warning will appear in cell C14 telling the user the quantity is too high; if the value is less than 20, a warring will tell the user the quantity is too small; otherwise, the cell remains blank.
- d. In order for Excel to display the correct number of boxes needed, the following functions are tried. Which one will correctly display the number of boxes needed to ship the parts?
- A. = B14/VLOOKUP(B10, J1:L10, 3, FALSE)
- B. = ROUND(B14/VLOOKUP(B10, J1:L10, 3, FALSE), 0)
- C. = ROUNDDOWN(B14/VLOOKUP(B10, J1:L10, 3, FALSE),0)
- D. = ROUNDUP(B14/VLOOKUP(B10, J1:L10, 3, FALSE), 0)
- E. = TRUNC(B14 VLOOKUP(B10, J1:L10, 3, FALSE), 0)
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
Additional Engineering Textbook Solutions
Engineering Mechanics: Statics
Shigley's Mechanical Engineering Design (McGraw-Hill Series in Mechanical Engineering)
DESIGN OF MACHINERY
Introduction to Heat Transfer
Heat and Mass Transfer: Fundamentals and Applications
Fluid Mechanics: Fundamentals and Applications
- I wanted to create two spheres that overlap each other in MATLAB. The image has my code and results. I only see one sphere in the results. Why is that? Can you give me the code that will create two overlaying spheres in one plot?arrow_forwardI downloaded this question multiple times but I had no answerarrow_forward2. There were 42 mangoes in each crate. 12 such crates of mangoes were delivered to a factory. 4 mangoes were rotten and had to be thrown away. The remaining mangoes were packed into boxes of 10 mangoes each. Write a numerical expression in MATLAB syntax to represent this situation and then find how many boxes of mangoes were there? OFocus 4:20 AM 28°C Mostly clear 3/26/2022 LG CVENUENS THANOS BOBBLEHEAD AMANLANTE A ON CABIA ANn POCKET YOP! AVENGES KEYCHAIN INFINITY WAR Handy Fan THANOS BOBBLE HEAD IGENA ERANLIA P COs CA ANarrow_forward
- You own a wheat warehouse with a capacity of 20,000bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at theprice per 1000 bushels given in Table 46.The sequence of events during each month is as follows:a You observe your initial stock of wheat.b You can sell any amount of wheat up to your initialstock at the current month’s selling price.c You can buy (at the current month’s buying price) asmuch wheat as you want, subject to the warehouse sizelimitation.Your goal is to formulate an LP that can be used to determine how to maximize the profit earned over the next 10monthsarrow_forwardA nearsighted eye is corrected by placing a diverging lens in front of the eye. The lens will create a virtual image of a distant object at the far point (the farthest an object can be from the eye and still be in focus) of the myopic viewer where it will be clearly seen. In the traditional treatment of myopia, an object at infinity is focused to the far point of the eye. If an individual has a far point of 39.5 cm, prescribe the correct power of the lens that is needed. Assume that the distance from the eye to the lens is negligible.arrow_forwardPlease make this on MATLAB, make the graph shown on the picture, copy the orange and blue circles and the line please make sure that they are on the exact same spots. Make the exact copy of the graph please. Nothing different, just make the same graph and put the orange and blue circles on the exact spots and make sure the lines are the same and make sure the title of the graph is their as well. They rest of the pictures that has numbers are the data that is believed to be the orange and blue dots . Take your time please. I need help with this.arrow_forward
- My professor said that I need to use the numbers as shown on the picture and make the exact graph that is also shown on the picture. But I don’t know how to put this in to MATLAB. Please send the code that makes the graph that is shown in the picture. Make it 100% exactly the same.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_forwardO You are running an industrial research study together with your project team to improve energy efficiency in a combustion process. The purpose of the research is to identify the optimum air-fuel ratio for the combustion process in a boiler under varying conditions of air supply and quality of fuel. The study would involve design of experiments, data collection and analysis, simulation of the different variables and validation of the optimum parameters. There is a lot of pressure to improve the energy efficiency as there is a forecast of fuel price rise in the forthcoming month. Based on the CRPE code of ethics, explain two critical precautions which the engineers have to consider before implementation of the data collection process for the industrial experiment. to be taken during the Describe briefly five ethical measures experimentaldata collection in order to ensure validity of results. Explain two precautions to be taken during the report writing on the research study carried out…arrow_forward
- Newton’s 2nd Law Lab (Modeling friendly lab) Go to the PhET simulation Forces & Motion. https://phet.colorado.edu/sims/html/forcesandmotionbasics/latest/forcesandmotionbasics_en.html Select “Acceleration” Click to show Forces, Sum of Forces, Values, Mass, and Acceleration. There are two experiments for this activity – make sure you include both. Experiment #1: Acceleration vs. Force In this lab you will determine the relationship between acceleration and net force. Choose a mass at the beginning, and keep it constant for this entire experiment. Set the friction to zero. This will make your Applied Force equal to the net force. Record data for five different values of Applied Force. Graph Acceleration vs. Net Force. Graph this in Google sheets(you want a line graph - it should only have one line). Make sure that Applied Force information is used as the x value Make sure that Acceleration information is used as the y value Add a trendline – see what fits best –…arrow_forwardThe Weather Monitor. Your South American expedition splits into two groups: one that stays at home base, and yours that goes off to set up a sensor that will monitor precipitation, temperature, and sunlight through the upcoming winter. The sensor must link up to a central communications system at base camp that simultaneously uploads the data from numerous sensors to a satellite. In order to set up and calibrate the sensor, you will have to communicate with base camp to give them specific location information. Unfortunately, the group's communication and navigation equipment has dwindled to walkie-talkies and a compass due to a river-raft mishap, which means your group must not exceed the range of the walkie-talkies (3.0 miles). However, you do have a laser rangefinder to help you measure distances as you navigate with the compass. After a few hours of hiking, you find the perfect plateau on which to mount the sensor. You have carefully mapped your path from base camp around lakes and…arrow_forwardHow to find the degrees of freedom using matlabarrow_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