S3 Series

Noflyz,

Here is what I am working on. I am just trying to get to the 5.6 cross. I know I am doing something wrong here.

https://docs.google.com/spreadsheets/d/1M14ZsVsyCZg_jeUQ-GOnnwGMhKSA4t0KVVC2EDoZu9Y/pubhtml

I think you need to make it a text file, then convert to .dtf when you want to run it.
I am not sure if you can convert a spreadsheet.

First off the 0,0 cross is at 42300x42300 you get this by flying to that location and noting down the numbers.

given that the x and y for this point is 42300 all we need is this.

Next find out how much distance it is in feet across and high is each grid. Again in the case of this map this is 105600 feet or 20 miles. (Not all terrains are exactly what they say, measure it if in doubt.)

Now say you want position of field 69, so it's pretty close to the 3,4 cross..

then the 3,4 cross is at:


Simple.. but this only get's you to the 3,4 point shown as below..




To be accurate we want 3,4,8,5 or if you want to be anal 3,4,8,5,1

So you want to add small fractions to 3 and 4 so that we get a position fairly near F69.

Using our popular grid reference system we take the numbers 8,5,1 and break them down further. For the lack of a better name I am calling these the first ninth, the second ninth etc.

The first ninth divides up the grind into 9 parts, the second into 81 parts the third into 729 parts etc. i.e.
or simpler each row or column is divided into thirds, ninths, eighty oneths etc. (3 raised to 1, 2, 4 etc.)

let's break down the first ninth i.e. 8 - it's 2/3rd of the way up and 1/3rd across so simply add 0.3333333 & 0.66666666.... to 3 & 4

so you would multiply by 3.3333333.... or 4.666666



This get's you to 3,4,8 much closer to F69.. still not close enough.. so now let's break down the next 9th or 5.

Same technique... 5 is now a third of a way up from 3,5,8 and third of the way across also. i.e. .333333 but the squares are also now 3 times smaller in height and width.. hence we divide .33333 by 3 to get .111111 and we add this to 3.3333333 and 4.666666 accordingly.. now doing the math



Let's test this... open up warbirds, select Free Flight, load up New Guinea map.. hit fly.. get the map open.
type in
.mapcircle 406033.2864 546833.2512 5280

you should see..



In my books that's close enough If not then proceed to break it down further... find the subdivision, this time divide by 9 instead of 3 and add it to the 3.444444 and 4.777777... In this case the third ninth is 1 which does nothing for you, so you would take a fourth nine of 5 (which we said is .666666666 and dividing by 81 you get 0.00823044444444) adding this to our 3.44... 4.7777 we do the math..



If you actually tried this you will see it's closer.. Bottom line is if it's not accurate to your taste, simply add or remove a few feet from the final answer, in a few tries you will be guessing these fairly accurately. for example you could simply look at the picture and say the field is at 3.5x4.8! Go try it.

As to putting this in a spread sheet, yeah I'm sure it can be done but i'll leave that up to you spread sheet types One of these days I'll get around to writing a app that can be used off the web to do these easily.

Till then hope this helps!

Btw Im copyrighting this and calling it the NO FLY method of creating DTFs as it saves you flying around from one WP to another

Noflyz

Thanks again for the help and it is beginning to make sense. The only reason for the spreadsheet is just to do the calculations only. Once I get the numbers I want, I will put this into my text DFT file.

<S>