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 (3rd 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
- A session.masteringphysics.com an Canvas Login - Santa Monica College e https://session.masteringphysics.com/m. e MasteringPhysics: Homework 11 A 3180 - kg spacecraft is in a circular or. Chat I Review I Constants The Dyson sphere is an hypothetical spherical structure centered around a star. Inspired by a science fiction story, physicist Freeman Dyson described such a structure for the first time in a scientific paper in 1959. His basic idea consisted of an artificial spherical structure of matter built around a star at a distance comparable to a planetary orbit, with the purpose of capturing the energy radiated by the star and reusing it for industrial purposes Assume the mass of the sun to be 2.00x1030 kg Part A Consider a solid, rigid spherical shell with a thickness of 100 m and a density of 3900 kg/m. The sphere is centered around the sun so that its inner surface is at a distance of 1.50x1011 m from the center of the sun. What is the net force that the sun would exert on such a…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_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_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_forwarddocs.google.com a The acceleration of an object is proportional to * its velocity its mass its position its displacement the net force acting on it When we say that light objects and heavy objects fall at the same rate, what assumption are we making? * They are falling in a vacuum. all of them They are made of the same material. They have the same shape. They have the same size. What does this graph indicate about the motion of an object ? * O O Oarrow_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_forward
- O 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_forwardMechanical Engineering The following table shows the kinetic energy and potential energy according to the speed of an object descending along a frictionless rain surface. What is the potential energy when the speed is 3/2v ? (It satisfies energy conservation) velocity kinetic energy 1500J potential energy V 3/2 * v 2v 1. 1400 J 2. 1000 J 3. 800 J 4. 600 J Please solve step by step. Thanks in advance! 1600 Jarrow_forwardSuppose a flu epidemic has broken out in all math 1215 courses at your school. Assume a total of 24 people have the flu as of today and that each day the total number people who have the flu double. Let f(t) represent the number of people who have the flu at t days since today. Estimate numerically when the number of people will reach 768. {your final answer just number}arrow_forward
- A Team of Engineers asked for an internal combustion engine to use it in a designed car. Your role is to describe the operation sequence of different types of available engines, explain their mechanical efficiency, and deliver a detailed technical report to show your approach in solving and discussing the following tasks and issues. You must follow the following steps to help the team: STEP 1 Describe the operational sequence of four-stroke spark ignition and four-stroke compression ignition engines with the aid of sketches by constructing simple sketch representing the operation and plotting the P-V diagrams for each process during the cycle to show the following: The input and output heat and net output work The air-fuel mixture intake and exhaust gasses The spark plug when it is in the active modearrow_forwardA Team of Engineers asked for an internal combustion engine to use it in a designed car. Your role is to describe the operation sequence of different types of available engines, explain their mechanical efficiency, and deliver a detailed technical report to show your approach in solving and discussing the following tasks and issues. You must follow the following steps to help the team: STEP 1 Describe the operational sequence of four-stroke spark ignition and four-stroke compression ignition engines with the aid of sketches by constructing simple sketch representing the operation and plotting the P-V diagrams for each process during the cycle to show the following: The input and output heat and net output work The expansion and compression strokes The air-fuel mixture intake and exhaust gasses The spark plug when it is in the active mode The complete cycle of ideal Otto and Diesel cycles that shows the input and output heat and net output work. STEP 2 Explain the mechanical…arrow_forwardNewton’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_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