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 Approach, Student Value Edition Plus MyLab Engineering with Pearson eText - Access Card Package (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
- Engineering Economy A company has determined the price and the monthly demand of its products are related by the equation D = √775 - p, where p is the price per unit in dollar and D, is the monthly demand. The associated fixed costs are $2,125 per month and the variable costs are $100/ unit. Use this information to answer the following: a)What is the optimal number of units that should be produced and sold each month? b) What is the maximum profit? c)Determine the value of D that represents the break-even point?arrow_forwardTHERMODYNAMICS UPVOTE WILL BE GIVEN. PLEASE WRITE THE COMPLETE SOLUTIONS/DIAGRAMS LEGIBLY. NO LONG EXPLANATION NEEDED. USE 3 DECIMAL PLACES. BOX THE FINAL ANSWER. An airplane is cruising at an elevation of 35,000 feet from sea level. Determine the amount of gage pressure in bars needed to pressurize the airplane to simulate sea level conditions. The average atmospheric pressure on earth is mated as a function of altitude by the relation Patm = 101.325 (1- 0.02256z)5.256, where Patm is the atmospheric pressure in kPa and z is the altitude in km with z = 0 at sea level.arrow_forwardScenario 1:You work as a design engineer in SpaceX which is a space exploration company that produces re-usablespace rockets. Space rockets in the past used to be disposable, the fact that they only serve for one timethen get lost in the space. SpaceX proposed a re-usable rocket, that can go to outer space, deliver someequipment, satellites, or even people to the outer space, and get back to earth to land again in a specifiedparking point. Where it can be re-fuelled, go through careful maintenance, and go through anotherjourney again. You are regularly requested by your manager to provide technical reports andtheoretical explanations about the main components and operational concepts related to these spaceshuttles. [https://www.spacex.com/]Task 1:Concerned with the number of maintenance visits the rocket can undergo before being out of service, you havebeen informed that the recent statics show a that after the first journey to the outer space, the rocket was sentto service once, and…arrow_forward
- Recall the discussion on spacecraft from the chapter opener. The following problems consider a rocket launch from Earth’s surface. The force of gravity on the rocket is given by F(d)=−mk/d2, where m is the mass of the rocket, d is the distance of the rocket from the center of Earth, and k is a constant. 172. As the rocket travels away from Earth’s surface, there is a distance D where the rocket sheds some of its mass, since it no longer needs the excess fuel storage. We can write this function as F(d)=⎨(−m↓1 k / d^2) if d < D (−m↓2 k / d^2) if d ≥ D Is there a D value such that this function is continuous, assuming m1≠m2?arrow_forwardDepartment of Mechanical Engineering PRINCIPLES OF COMPUTER AIDED ENGINEERING – MENG303 Please solve the problem by keupordDepartment of Mechanical Engineering PRINCIPLES OF COMPUTER AIDED ENGINEERING – MENG303 Please solve the problem by keupordarrow_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
- 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 village of Pikachu and Psyducks was hit by a horrible storm. This village is surrounded by mountains and the only way out left is to cross a river. Imagine you are an engineer in a rescue team, and your team has decided to construct a temporary bridge over the river to rescue the villagers. The two bridge stones on both sides of the river have been built, and the river is 10 meters wide. All Pikachu and Psyducks weigh 6 kg and 20 kg, respectively. a) You have selected tempered glass with a facture strength of 120 MPa that has a width of 1 meter and enough length to build the bridge. The manufacturer now awaits your decision on the thickness of the glasses. If the maximum number of Pikachu and Psyducks simultaneously on the bridge is respectively 50 and 20, what is the minimum thickness in millimeters required for the safe crossing of the villagers? (Hint, you can assume all weights only exert a single force at the center of the bridge, don’t overthink this problem!) b) If the…arrow_forward[Engineering Thermodynamics] Please finish the answer with a diagram for reference to me (if needed). Show the answer step by step and clear to see. If you need to answer with words, please type directly. (to avoid cant see clear by handwriting) Thank you. P.S. Use the online software http://www.peacesoftware.de/einigewerte/r134a_e.html or property table and p-h diagram for R134a where necessary.arrow_forward
- 3.) A block of wood to completely submerged requires a suspended anchor, 100 newtons in water and 300 newtons in a liquid (sp. gr. = 1.50). Find the specific gravity of the wood. Write your answer to the nearest two decimal places.arrow_forwardSeawater can be purified by distillation into potable water. If it costs 15 cents per kilowatt-hour for energy, what is the cost of energy to produce 100.0 gallons of drinking water at 100.0 ˚C if the seawater starts at 25.00 ˚C? (1 watt × 1 second = 1 joule). Enter your answer to the nearest penny.arrow_forwardMECHANICAL ENGINEERING UPVOTE WILL BE GIVEN. PLEASE WRITE THE COMPLETE SOLUTIONS LEGIBLY. SHOW THE STEP-BY-STEP PROCESS WITH SHORT COMMENT/EXPLANATION. ANSWER IN 4 DECIMAL PLACES. Two gaseous streams containing the same fluid enters a mixing chamber and leaves as a single stream. For the first gas the entrance conditions are A1=500 cm², v1=230 m/s, p1=1.60 kg/m³. For the second gas the entrance conditions are A2= 300 cm³, m2=8.84 kg/s, v2=0.502 m³/kg. The exit stream conditions is v3=130 m/s and v3=0.437 m3/kg. Determine the following: (a) the total mass flow leaving the chamber (kg/sec) (b) the velocity of the gas at 2. (m/sec)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