0
gs8613

Exit separation spreadsheet

Recommended Posts

I read through the latest "45 degree rule" thread recently and remembered that I did the maths for exit separation a while ago for a piece of coursework.

I've attached an excel spreadsheet if anybody's interested. It shows how much separation you'll have on opening with different times between exits, and the different speeds of each group.
All the green cells are editable. All units are in metres and seconds, but I've added a unit converter.
Group 1/2 TV is the terminal velocity of each group. This is used to estimate their coefficient of drag.
Total throw is your horizontal distance between exit and pull.
K1 and K2 are the 2 groups coefficients of drag.


If anybody wants to check the maths or have a look at how it's done, I can upload the write up.

Share this post


Link to post
Share on other sites
Sorry but I cannot open your file. Could you change it in simple XLS.

I am into mathematics therefore I am interested to see more details.

I made a program a couple of years ago on my graphing calculator HP 48 GX to calculate the spot based on wind direction and speed at 0, 3000, 6000, 9000 and 12000 ft. In this program I took in account the forward throw due to the ground speed of the airplane at altitude. In summary, this program makes a sum of 4 vectors (direction and length) and the result is like : 3500 ft at 340. We can really fast find out the spot on an aerial picture of the DZ on which I have drawn circles every 500, 1000, 1500, 2000, 2500 ft ...etc including geographic radials from 0 to 180 to 360 degrees by increments of 10 degrees. If intersted just tell me. My program let you know each operation and tell you what it actually does. I have also a sample calculation by hand to validate the program.
Learn from others mistakes, you will never live long enough to make them all.

Share this post


Link to post
Share on other sites
Erdnarob - I'd be interested to see that program. Did the excel file open okay for you in the end?


I've attached part of the write up for this. It's too big to upload as 1 document so I've split it into 2 PDF's

If anybody wants to use this I can easily modify the excel doc to include wind speeds and directions, and therefore actual throw from the aircraft

Share this post


Link to post
Share on other sites
Thanks for your calultaions. In my calculation the jumper forward speed at exit due to airplane speed (provided it is flying horizontally against the wind at altitude over the calulated spot) is the : (ground speed of the airplane x 5 seconds)/2 which represents the horizontal distance made by the jumper at exit. See explanations.
Learn from others mistakes, you will never live long enough to make them all.

Share this post


Link to post
Share on other sites
Quote

Quote

Education isn't like it was in our day, eh Mike?


So you're saying the standard of teaching has gone down since you were a boy...




Fortunately by the time graduate school comes around it seems to be OK.;)
...

The only sure way to survive a canopy collision is not to have one.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

0