How do I make a spread sheet Like the one shown below?my aircraft weight would be 10,323 Ibs and the wing area would be 229 ft^2

1. A 10xxx-lb aircraft has an (L/D)MAX value of 9.8; find its minimum drag. Discussions For aircraft weight, enter the first three numbers of your phone number after "10" (For example, if your phone number starts with 412, enter aircraft Grades 1 weight as 10,412 lb). To find minimum drag, use equation 5.12 from the textbook, also provided here: eople Dmin = W ( 5 ) maz agleVision Zoom 2. If the aircraft in Problem 11 has a wing area S=2xx ft2 and the value of CL=0.5 at L/DMAX, find the sea level airspeed where DMIN occurs. (We eadings and will call this V1.) esources For wing area, enter your age after "2" (for example, if you are 30, then you would enter S=230 ft ). Note: To solve for V1, reference Table 2.1 Standard atmosphere table and Equation 4.4 (Velocity equation derived from the Lift equation). unt Library. 3. For the aircraft in Problem 11, find D; and Do at (L/D)MAX- pokstore 4. For the aircraft in Problem 11, complete the following table and plot Di, Do, and D, in Excel. (V2 : V1) 2 Dp = = Dmin (V2 : V1 )? ( V1 : V2)2 Di = > Dmin (V1 : V2)2 DT = Dp + Di 125 150 172 200 his 300 400 Use Excel to create the table and your total drag curve for question 14