Creating a line

[WLMPilot]

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

 

[Kelly O'Day]

WLMPilot

Thanks for an interesting question.

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

http://processtrends.com/toc_chart_doctor.htm#Request_for_Plotting_a_Line_From_Runway_Name

Kelly O'Day
http://processtrends.com

 

[WLMPilot]

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]

Les

Take a look at the revised version.

http://processtrends.com/toc_chart_doctor.htm

Kelly

 

[WLMPilot]

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]

Les:

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

Kelly

 

[WLMPilot]

Thank you so much!!!!!!! Wonderful job.

Now I just have to figure out how to get it on the worksheet that I have
already created.

Thanks again,
Les

 

[WLMPilot]

Kelly,

I cannot figure out how you get the "label" to appear on the chart, ie
Runway 14. or whatever the actual runway number is. I did get the chart to
plot on my form, but cannot figure out the labeling part. What I tried
placed the acutal Y value of each runway.

Thanks,
Les

 

[Kelly O'Day]

Les:

I used J Walkenbach's Data Label tool which is part of his free Charting
utility. You can download his add-in for free at this link:


http://j-walk.com/ss/excel/files/charttools.htm

Once you install it, select your chart. The Chart menu will include an item
for Chart Tools. Select the Data Label to be able to add your labels.

Kelly

 

[WLMPilot]

Kelly,

Initially, the labeling of the runways worked fine. I don't remember or
know of anything I did to mess things up, but now it is only labeling one end
of the runway (line). If I input runways 09 & 19, it draws the correct
lines, but labels the opposite end, ie labels 27 and 01 respectfully.

Any ideas?

Thanks again for the tremdous help!
Les