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 (4th 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
- Can i get help with these questionsarrow_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_forwardMy 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_forward
- There is a small space between the orange and purple line could you please connect the two lines together also can you please make the purple line shorter and then connect the purple line to the orange line, please take out the box that says “Diesel, petrol, Diesel best fit, petrol best fit”. Also when ever I run this code the graph shows up but there are still errors that comes up could you please fix them when you are running this on MATLAB. Please use this code on MATLAB and fix it. % Sample data for Diesel and Petrol cars carPosition = linspace(1, 60, 50); % Assumed positions of cars % Fix the random seed for reproducibility rng(50); % Assumed CO2 emissions for Diesel and Petrol CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol % Fit polynomial curves pDiesel = polyfit(carPosition, CO2Diesel, 3); pPetrol = polyfit(carPosition, CO2Petrol, 3); % Generate…arrow_forwardMECT361 Mechatronics Components and Instrumentation PLEASE GIVE ME THE short answer and wite it by keyword thanksarrow_forwardRead the summary below and answer the questions that follow: The Orange Girl – all the juice and nutrition you can ask for Growing up on a citrus farm in Mpumalanga, Yoliswa always wanted to escape to the city. In her little mind, she saw the farm life as the hardest endurance test any individual can be subjected to. She qualified with a mechanical engineering degree and started working in food manufacturing facilities in the city of Jo’burg. The conventional rat race in the city wore Yoliswa down a lot, she started escaping to the farm whenever she got a chance. One day, five years ago, on one of these visits, she found herself wandering on the farm, carried away in childhood memories of how she used to eat oranges directly from trees when they were in season. The farm owner had allowed Yoliswa’s parents to use a section of the farm to grow their own oranges for themselves. Her father decided to follow indigenous ways of growing oranges – his oranges always tasted sweeter, juicier…arrow_forward
- Please copy the graph that you see on the picture. I keep on sending this graph in but I get different graphs. Please generate the exact graph with the orange and blue dots along this the two lines the goes across the graph and overlaps each other. Make sure you use MATLAB and the no errors comes up when you run it. Please send the code with no errors or warring signs. Please make it 100 % accurate to the graph that you see in the picture along with the data.arrow_forwardI thought the letters represented the connection between the forces and magnitude. Can you help me truly understand how to evaluate this correctly? Thanksarrow_forwardHello I’m trying to make the graph that you see in the picture, I’m trying the exact copy of that graph using this code but I’m having a hard time doing that. Could you change the code so that it looks like the graph that you see on the picture using MATLAB, please send the code when you are finished. % Sample data for Diesel and Petrol cars carPosition = linspace(1, 60, 50); % Assumed positions of cars % Fix the random seed for reproducibility rng(45); % Assumed positions of cars CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol % Fit polynomial curves pDiesel = polyfit(carPosition, CO2Diesel, 3); pPetrol = polyfit(carPosition, CO2Petrol, 3); % Generate points for best fit lines fitDiesel = polyval(pDiesel, carPosition); fitPetrol = polyval(pPetrol, carPosition); % Plotting the data figure; hold on; scatter(carPosition, CO2Diesel, 'o', 'MarkerEdgeColor', [1 0.5…arrow_forward
- Please 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_forwardMULTIPLE CHOICE -The answer is one of the options below please solve carefully and circle the correct option Please write clear .arrow_forwardThis code keeps on generating graphs with different curves. The picture that you see two different graphs comes from the same code but both of them have different curves. I need the curve to look like the picture that only has one graph. I basically need the line to have a slight curve and every time I run the code it will come up as the same graph every time. Use this code on MATLAB and fix it % Sample data for Diesel and Petrol cars carPosition = linspace(1, 60, 50); % Assumed positions of cars % Use the 'seed' function instead of 'rng' seed = 50; % Define your seed here rand('seed',seed); % Assumed CO2 emissions for Diesel and Petrol CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol % Fit polynomial curves with a reduced degree of 2 pDiesel = polyfit(carPosition, CO2Diesel, 2); pPetrol = polyfit(carPosition, CO2Petrol, 2); % Generate points for best fit…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