Problem 1 (10 pts): Create an atmospheric spreadsheet (Excel or alike) that calculate theta, sigma, and delta. Use that spreadsheet to plot pressure, temperature, and density as a function of pressure altitude. Make sure to include ∆ISA (Off Standard Atmospheric Temperature) in Celsius as an input. What does that affect? Provide your plot and Excel file with your homework.
∆ISA means the temperature relative to the International Standard Atmosphere, but we assume a standard day condition while ∆ISA is always zero, where the temperature is neither higher or lower than a standard temperature for the certain altitude.
Problem 2 (10 pts): In your atmospheric spreadsheet make sure to calculate:
What do you notice about the lines? Do they follow a particular trend? How do the Differ? What about lines of Equivalent Airspeed? Provide your plot and Excel file with your homework
All the lines have a positive slope with respect to increasing altitude. They follow the same increasing trend in response to increasing pressure altitude. Their differences lie in the slope number and trend shapes while the first graph has a more linear shape with lower slope. The lines of equivalent airspeed decrease with respect to altitude.
Problem 3 (20 pts): In a spreadsheet repeat the time step integration exercise from class using the provided data in Figure 1, Table 1, and Table 2. Assume the aircraft initiates cruise at 75,500 lb and Mach 0.85 at FL410 (41,000 ft) for 5,000 lbs of fuel and the climbs to FL430 (43,000 ft) for the remaining 5,000 lb, assuming the climb happens instantaneously. Compare to the Breguet range equation.
Using Breguet Equation:
Using time integration:
According the graphs above, L/D increases while cruising, and during the instantaneous climb, L/D experiences a sudden drop, and then continues to increase afterwards, exceeding its initial value. SFC follows the similar pattern, where the value drops significantly during the climb, then catches up afterwards.
If the entire cruise happens at FL410, or 41,000 ft, the value for dynamic pressure and airspeed would stay the same throughout the entire trip since the altitude does not change and the ambient properties such as temperature and pressure remain the same.
The aircraft begin cruise at FL430, or 43,000 ft because the total weight is large initially or that the lift coefficient is high, along with the induced drag, which is also high. Thrust cannot overcome the high drag, leading to dangerous flight. High altitude should be reached within a weight limit.
Problem 4 (5 pts): Pick an aircraft and estimate the L/D and SFC using the Breguet Range equation. What assumptions did you have to make to determine SFC and/or L/D?
A380: (Trent 900):
Fuel Fraction ：44.2%
TSFC: 15.5 (g/s)/kN or 0.5 lb/lbf*hr
Max range: 8500 nm or 51646981.6 ft
Cruising speed: 490kt or 827.02683 ft / sec
K = 0.97
Solve for L/D to get 15.34
Assumptions should be made for cruising conditions, and others including maximum range and cruising speed, constant SFC and final weight with exhausted fuel.
Problem 5 (10 pts): Repeat the TOFL analysis from class for landing. What is landing field length proportional to? How is it different from TOFL.
Problem 6 (5 pts): Draw a free body diagram for an aircraft in climb. Label all forces and angles.
Want to order fresh copy of the Sample Create an atmospheric spreadsheet Answers? online or do you need the old solutions for Sample Create an atmospheric spreadsheet, contact our customer support or talk to us to get the answers of it.
Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.
Get reliable and unique assignments by using our 100% plagiarism-free.
Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.
Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.
Get premium service at a pocket-friendly rate at AssignmentHippo
I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.