ME232w 18Weei9HWGui Saved Scott Agostini - File Home Insert Design Layout References Mailings Review View Help Te Problem 1 Concepts-Do While loop Complete this problem in Sheet2. Neglecting air friction, the projectile motion equations are yyo t sin(0)1 +0.5 g r where x and y are the current position at time t, xo and yo are the projectile's initial position, sw is the projectile's initial speed, 0 is the initial firing angle of the projectile, and g is the gravitational acceleration which is-9.81 m/s2 near Earth's surface. The user (me) will input the initialx position (m), y position (m), speed (m/s), the firing angle (in degrees) in cells F2-F5 on Sheet2. Create a run button that executes a macro named problem2. This macro solves the following problem Obtain the input data from cells F2-F5 Using a Do While loop (not a For loop nor a Do Until loop), calculate the x- and y-position of the projectile every 0.1 seconds and output the time, x-position, and y- position to columns A, B, and C until the projectile hits the ground. The first entries for the time, xposition, and y-position should be in cells A2, B2, and C2. For example, if the initial x-position is 10 m, the initial y position is 20 m, the initial speed is 100 m's and the firing angle is 30, the first five lines of output should similar to the data below: 0 10 20 01 18.66 24.95 02 27.32 29.80 3 35.98 34.56 0.4 44.64 39.22 (m/s) ni If the last y-position output to the workbook is negative, remove the data from that entire row (the projectile will not enter the ground) "Important of Cleair all data in columns A C before using the Do While loop. If you don't, you may have a lot extra data on your screen after running your program. For example, try running your program with an initial speed of 100 m/s. Then lower the initial speed to 25 m/s and rerun the program. If you do not clear your data from the previous run, there will be a lot of extra lines of output leftover ni O Type here to search