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