I am new to being able to create lines from data. I am a pilot. I have a
section on my navigational logsheet (in excel 2002) that I want to draw the
runways based on the runway number(heading) I enter.

The section set aside for this is S3-V9. I want the orientation, when
looking at the sheet to be as follows:
Up = North (360 degrees), Down = South (180 degrees)
East = Right (090 degrees), Left = West (270 degrees)

FYI: Runway numbers drop the last digit of the 3-digit heading. So runway
09 = heading of 090 and runway 27 = heading of 270. Obviously, the
reciprocal (other end of the runway is 180 degrees difference. EX: Runway
09 & 27 (090 & 270), Runway 11 & 29 (110 & 290).

If I enter two different runway numbers, 09 and 36, then I would like to
draw two lines that represent the runways within the space indicated. In
this example, Runway 09 would be horizontal (east-west) and Runway 36 would
be vertical (North-South).

I would appreciate any help on this problem.

Thanks and have a Happy Thanksgiving!!

Les

WLMPilot

Thanks for an interesting question.

Here's a post I made to plot your lines.

http://processtrends.com/toc_chart_d...om_Runway_Name

Kelly O'Day
http://processtrends.com



"WLMPilot" wrote in message
...
I am new to being able to create lines from data. I am a pilot. I have a
section on my navigational logsheet (in excel 2002) that I want to draw
the
runways based on the runway number(heading) I enter.

The section set aside for this is S3-V9. I want the orientation, when
looking at the sheet to be as follows:
Up = North (360 degrees), Down = South (180 degrees)
East = Right (090 degrees), Left = West (270 degrees)

FYI: Runway numbers drop the last digit of the 3-digit heading. So
runway
09 = heading of 090 and runway 27 = heading of 270. Obviously, the
reciprocal (other end of the runway is 180 degrees difference. EX:
Runway
09 & 27 (090 & 270), Runway 11 & 29 (110 & 290).

If I enter two different runway numbers, 09 and 36, then I would like to
draw two lines that represent the runways within the space indicated. In
this example, Runway 09 would be horizontal (east-west) and Runway 36
would
be vertical (North-South).

I would appreciate any help on this problem.

Thanks and have a Happy Thanksgiving!!

Les

Thanks for what you have done. This is close to what I need. However, it is
not calculating (drawing) correctly. If you note in my original question,
Rwy 09 (heading 090 degrees) would be a horizontal line. The line that is
drawn by your calculations starts at the bottom (south end).

Let me further explain directions (which may confuse you more) but I will
give it a try. Draw a big circle on a piece of blank paper. While looking
at it, do the following:

- write an "N" at the top and "S" at the bottom of the circle for North &
South
- write an "W" on the left side and an "E" on the right side for West & East.
- Draw a line in the circle connecting the N and S side (vertically divide
circle in half)

Pretend that line is a runway. As you look at the paper, you are on the
south end of the runway. But you are "heading" north. So, the runway number
that would appear on the south end of the runway is 36 (for 360 degrees or a
heading of NORTH). THe heading on the compass would also be 360 degrees.
NOTE: 000 (zeros) are not utilized to represent north.

Likewise, the heading on the north side of the runway would be 18 (for 180
degrees) if you were flying a SOUTH heading (180 degrees).

An east heading (flying from the left side of the paper to the right) would
be 090 or Rwy 09.
A west heading (flying from the right side of the paper to the left) would
be 270 or Rwy 27.

I hope this helps and I did not confuse you too much.

Thanks again,
Les



"Kelly O'Day" wrote:

WLMPilot

Thanks for an interesting question.

Here's a post I made to plot your lines.

http://processtrends.com/toc_chart_d...om_Runway_Name

Kelly O'Day
http://processtrends.com



"WLMPilot" wrote in message
...
I am new to being able to create lines from data. I am a pilot. I have a
section on my navigational logsheet (in excel 2002) that I want to draw
the
runways based on the runway number(heading) I enter.

The section set aside for this is S3-V9. I want the orientation, when
looking at the sheet to be as follows:
Up = North (360 degrees), Down = South (180 degrees)
East = Right (090 degrees), Left = West (270 degrees)

FYI: Runway numbers drop the last digit of the 3-digit heading. So
runway
09 = heading of 090 and runway 27 = heading of 270. Obviously, the
reciprocal (other end of the runway is 180 degrees difference. EX:
Runway
09 & 27 (090 & 270), Runway 11 & 29 (110 & 290).

If I enter two different runway numbers, 09 and 36, then I would like to
draw two lines that represent the runways within the space indicated. In
this example, Runway 09 would be horizontal (east-west) and Runway 36
would
be vertical (North-South).

I would appreciate any help on this problem.

Thanks and have a Happy Thanksgiving!!

Les

Les

Take a look at the revised version.

http://processtrends.com/toc_chart_doctor.htm

Kelly




"WLMPilot" wrote in message
...
Thanks for what you have done. This is close to what I need. However, it
is
not calculating (drawing) correctly. If you note in my original
question,
Rwy 09 (heading 090 degrees) would be a horizontal line. The line that is
drawn by your calculations starts at the bottom (south end).

Let me further explain directions (which may confuse you more) but I will
give it a try. Draw a big circle on a piece of blank paper. While
looking
at it, do the following:

- write an "N" at the top and "S" at the bottom of the circle for North &
South
- write an "W" on the left side and an "E" on the right side for West &
East.
- Draw a line in the circle connecting the N and S side (vertically divide
circle in half)

Pretend that line is a runway. As you look at the paper, you are on the
south end of the runway. But you are "heading" north. So, the runway
number
that would appear on the south end of the runway is 36 (for 360 degrees or
a
heading of NORTH). THe heading on the compass would also be 360 degrees.
NOTE: 000 (zeros) are not utilized to represent north.

Likewise, the heading on the north side of the runway would be 18 (for 180
degrees) if you were flying a SOUTH heading (180 degrees).

An east heading (flying from the left side of the paper to the right)
would
be 090 or Rwy 09.
A west heading (flying from the right side of the paper to the left) would
be 270 or Rwy 27.

I hope this helps and I did not confuse you too much.

Thanks again,
Les



"Kelly O'Day" wrote:

WLMPilot

Thanks for an interesting question.

Here's a post I made to plot your lines.

http://processtrends.com/toc_chart_d...om_Runway_Name

Kelly O'Day
http://processtrends.com



"WLMPilot" wrote in message
...
I am new to being able to create lines from data. I am a pilot. I have
a
section on my navigational logsheet (in excel 2002) that I want to draw
the
runways based on the runway number(heading) I enter.

The section set aside for this is S3-V9. I want the orientation, when
looking at the sheet to be as follows:
Up = North (360 degrees), Down = South (180 degrees)
East = Right (090 degrees), Left = West (270 degrees)

FYI: Runway numbers drop the last digit of the 3-digit heading. So
runway
09 = heading of 090 and runway 27 = heading of 270. Obviously, the
reciprocal (other end of the runway is 180 degrees difference. EX:
Runway
09 & 27 (090 & 270), Runway 11 & 29 (110 & 290).

If I enter two different runway numbers, 09 and 36, then I would like
to
draw two lines that represent the runways within the space indicated.
In
this example, Runway 09 would be horizontal (east-west) and Runway 36
would
be vertical (North-South).

I would appreciate any help on this problem.

Thanks and have a Happy Thanksgiving!!

Les

THAT IS GREAT!!!!!

Can I ask a couple of more things more favor? Most airports have two
runways. I tried to plot a second runway, but nothing happened (cell A3). I
would like to be able to plot the 2nd rwy also.
The other item is to label the opposite end of each rwy plotted. Ex: If I
plot Rwy 27, you have it labelling Rwy 27. Can you also get it to label the
recipricol, ie Rwy 09?

One this is completed, how do I go about getting it into my spreadsheet?

You have done a wonderful job. Thanks a million!!!!

Les

"Kelly O'Day" wrote:

Les

Take a look at the revised version.

http://processtrends.com/toc_chart_doctor.htm

Kelly




"WLMPilot" wrote in message
...
Thanks for what you have done. This is close to what I need. However, it
is
not calculating (drawing) correctly. If you note in my original
question,
Rwy 09 (heading 090 degrees) would be a horizontal line. The line that is
drawn by your calculations starts at the bottom (south end).

Let me further explain directions (which may confuse you more) but I will
give it a try. Draw a big circle on a piece of blank paper. While
looking
at it, do the following:

- write an "N" at the top and "S" at the bottom of the circle for North &
South
- write an "W" on the left side and an "E" on the right side for West &
East.
- Draw a line in the circle connecting the N and S side (vertically divide
circle in half)

Pretend that line is a runway. As you look at the paper, you are on the
south end of the runway. But you are "heading" north. So, the runway
number
that would appear on the south end of the runway is 36 (for 360 degrees or
a
heading of NORTH). THe heading on the compass would also be 360 degrees.
NOTE: 000 (zeros) are not utilized to represent north.

Likewise, the heading on the north side of the runway would be 18 (for 180
degrees) if you were flying a SOUTH heading (180 degrees).

An east heading (flying from the left side of the paper to the right)
would
be 090 or Rwy 09.
A west heading (flying from the right side of the paper to the left) would
be 270 or Rwy 27.

I hope this helps and I did not confuse you too much.

Thanks again,
Les



"Kelly O'Day" wrote:

WLMPilot

Thanks for an interesting question.

Here's a post I made to plot your lines.

http://processtrends.com/toc_chart_d...om_Runway_Name

Kelly O'Day
http://processtrends.com



"WLMPilot" wrote in message
...
I am new to being able to create lines from data. I am a pilot. I have
a
section on my navigational logsheet (in excel 2002) that I want to draw
the
runways based on the runway number(heading) I enter.

The section set aside for this is S3-V9. I want the orientation, when
looking at the sheet to be as follows:
Up = North (360 degrees), Down = South (180 degrees)
East = Right (090 degrees), Left = West (270 degrees)

FYI: Runway numbers drop the last digit of the 3-digit heading. So
runway
09 = heading of 090 and runway 27 = heading of 270. Obviously, the
reciprocal (other end of the runway is 180 degrees difference. EX:
Runway
09 & 27 (090 & 270), Runway 11 & 29 (110 & 290).

If I enter two different runway numbers, 09 and 36, then I would like
to
draw two lines that represent the runways within the space indicated.
In
this example, Runway 09 would be horizontal (east-west) and Runway 36
would
be vertical (North-South).

I would appreciate any help on this problem.

Thanks and have a Happy Thanksgiving!!

Les

Les:

I've updated the workbook, download the new file to see if it meets your
needs.

Kelly


"WLMPilot" wrote in message
...
THAT IS GREAT!!!!!

Can I ask a couple of more things more favor? Most airports have two
runways. I tried to plot a second runway, but nothing happened (cell A3).
I
would like to be able to plot the 2nd rwy also.
The other item is to label the opposite end of each rwy plotted. Ex: If
I
plot Rwy 27, you have it labelling Rwy 27. Can you also get it to label
the
recipricol, ie Rwy 09?

One this is completed, how do I go about getting it into my spreadsheet?

You have done a wonderful job. Thanks a million!!!!

Les

"Kelly O'Day" wrote:

Les

Take a look at the revised version.

http://processtrends.com/toc_chart_doctor.htm

Kelly




"WLMPilot" wrote in message
...
Thanks for what you have done. This is close to what I need. However,
it
is
not calculating (drawing) correctly. If you note in my original
question,
Rwy 09 (heading 090 degrees) would be a horizontal line. The line that
is
drawn by your calculations starts at the bottom (south end).

Let me further explain directions (which may confuse you more) but I
will
give it a try. Draw a big circle on a piece of blank paper. While
looking
at it, do the following:

- write an "N" at the top and "S" at the bottom of the circle for North
&
South
- write an "W" on the left side and an "E" on the right side for West &
East.
- Draw a line in the circle connecting the N and S side (vertically
divide
circle in half)

Pretend that line is a runway. As you look at the paper, you are on
the
south end of the runway. But you are "heading" north. So, the runway
number
that would appear on the south end of the runway is 36 (for 360 degrees
or
a
heading of NORTH). THe heading on the compass would also be 360
degrees.
NOTE: 000 (zeros) are not utilized to represent north.

Likewise, the heading on the north side of the runway would be 18 (for
180
degrees) if you were flying a SOUTH heading (180 degrees).

An east heading (flying from the left side of the paper to the right)
would
be 090 or Rwy 09.
A west heading (flying from the right side of the paper to the left)
would
be 270 or Rwy 27.

I hope this helps and I did not confuse you too much.

Thanks again,
Les



"Kelly O'Day" wrote:

WLMPilot

Thanks for an interesting question.

Here's a post I made to plot your lines.

http://processtrends.com/toc_chart_d...om_Runway_Name

Kelly O'Day
http://processtrends.com



"WLMPilot" wrote in message
...
I am new to being able to create lines from data. I am a pilot. I
have
a
section on my navigational logsheet (in excel 2002) that I want to
draw
the
runways based on the runway number(heading) I enter.

The section set aside for this is S3-V9. I want the orientation,
when
looking at the sheet to be as follows:
Up = North (360 degrees), Down = South (180 degrees)
East = Right (090 degrees), Left = West (270 degrees)

FYI: Runway numbers drop the last digit of the 3-digit heading. So
runway
09 = heading of 090 and runway 27 = heading of 270. Obviously, the
reciprocal (other end of the runway is 180 degrees difference. EX:
Runway
09 & 27 (090 & 270), Runway 11 & 29 (110 & 290).

If I enter two different runway numbers, 09 and 36, then I would
like
to
draw two lines that represent the runways within the space
indicated.
In
this example, Runway 09 would be horizontal (east-west) and Runway
36
would
be vertical (North-South).

I would appreciate any help on this problem.

Thanks and have a Happy Thanksgiving!!

Les