One of the NAE Grand Challenges for Engineering is Engineering the Tools of Scientific Discovery.
According to the NAE website: “Grand experiments and missions of exploration always need engineering expertise to design the tools,
Solar sails are a means of interplanetary propulsion using the radiation pressure of the sun to accelerate a spacecraft. The table contained in the starting Excel file shows the radiation pressure at the orbits of the eight planets.
Create a table showing the area in units of square meters of a solar sail needed to achieve various accelerations for various spacecraft masses at the distances from the sun of the various planets. Your solution should use data validation and VLOOKUP to select a planet and the corresponding radiation pressure. The columns of your table should list masses of the spacecraft (including the mass of the sail) ranging from 100 to 1000 kilograms in increments of 100 kilograms. The rows should list accelerations from 0.0001 to 0.001 g in increments of 0.001 g, where g is the acceleration of Earth’s gravity, 9.8 meters per second squared. All constants and conversion factors should be placed in individual cells using appropriate labels, and all formulae should reference these cells and should NOT be directly coded into the formulae. You should use absolute, relative, and mixed addressing as appropriate.
Note
The astronomical unit (AU) is the average distance from Earth to the sun.
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
Vector Mechanics for Engineers: Statics, 11th Edition
Mechanics of Materials, 7th Edition
Statics and Mechanics of Materials (5th Edition)
Heat and Mass Transfer: Fundamentals and Applications
Degarmo's Materials And Processes In Manufacturing
Introduction to Heat Transfer
- Hello tutors, help me. Just answer "Let Us Try"arrow_forwardPlease help with question 2 only.arrow_forwardSimple Machines-Levers, Inclined Planes, and Pulleys Directions: Use the appropriate equation to answer the following questions. All answers should be recorded below or in your Engineering Design journal. Remember to show all work. A lever has an effort arm that is 5 meters long and a resistance (load) arm that is 3.5 meters long. How much effort is needed to lift a 100 Newton weight? 5K i). Draw the figure representing the problem ii). How much effort is needed to lift a 100 Newton weight? iii). What is the Actual Mechanical Advantage 1. 5m i) AOON 5-5marrow_forward
- Read 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_forwardEach bar chart should show the distribution of energy across the categories as well as the total energy for the initial- red and final- blue state. The system includes 3 units of heat energy, and 2 units of radiant energy. All of the energy in the final state will be converted into mechanical energy.arrow_forwardneed some help on this pleasearrow_forward
- Hello I have two pictures with some questions Id like to get answers to! Short and great explanations please thank you !arrow_forwardYou are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial weight bearing activities. Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the yield stress for the Ti-6Al-4V…arrow_forwardQ \Fill in the blank the correct word or phrase which is showing reason or result. 1) Large numbers of people from all over the world visit Petra, in Jordan, its beauty. A).so B).because of C).as a result D).because 2) One of the greatest achievements of Emperor Qin Shi Huang was the building of the first Great Wall of China to protect China from its enemies. Not all of his achievements were military, however, as he . introduced a common form of writing throughout the country. a.)in addition b.)plus c.)add d.)also 3) In ancient China, more than 700,000 workers and craftsmen took 38 years to complete the huge imperial palace, offices, and halls, all surrounded by a wall. Qin Shi Huang ordered an army to be built so that his palace would be protected. Emperor a.)add b.)also c.)plus d.)in addition 4 ) Historians are often required to learn languages such as latin read ancient manuscripts and inscriptions. a.)thus b.)as a result c.)in order to d.)therefore 5) In 79 CE Pompeii was covered…arrow_forward
- You have been asked by your supervisors at A&L Engineering to design a roller coaster for a new theme park. Because this design is in the initial stages, you have been asked to create a track for the ride. Your coaster should have at least two peaks and two valleys, and launch from an initial height of 75 meters. Each peak and valley should represent a vertical change of at least 20 meters. In your design, you should plan for a mass between 400 and 600 kilograms. Once you have designed the track, you have been asked to calculate the kinetic energy, potential energy, momentum, and work done by the cart at various points throughout the track. Unless otherwise stated, you can ignore the effects of friction. Following your calculations, you have been asked to describe the energy transfers detailed by these equations. Directions To complete this roller coaster design report, complete the following: Create a diagram of a roller coaster track containing at least two peaks and two…arrow_forwardDo not round numbersarrow_forwardFollow the instructions carefully.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