Need help with Microsoft Excel

[blipblop]

I am taking readings and they are like 1 degree and 30 seconds or 1deg and 30'.
How do I input this into excel? I will have to later graph them as these are antenna patterns. thanks

 

[bruceb]

When you open a new excel sheet leave the default formats as is ... just size the column width
Enter your data by: '1 degree 30' .. it will display as: 1 degree 30'
the leading ' tells excel not to format your data .. it stays as you typed it
Now if you need to do calculations on that .. you will need someone with more expertise than me
You might try Scientific for the Cell Formats

 

[blipblop]

alright, that will be a start. I will eventually have two columns.. the angle vs the dBm. Then I will just graph them to see the peaks and the null of the antenna pattern. This gets me started, thank you.

 

[imported_IndyJoe]

This website should help you. You can actually display this stuff correctly. Doiing it the way mentioned above won't allow you to graph it easily.

http://www.cpearson.com/excel/latlong.htm

 

[BlueWeasel]

If you need to run calculations or graph them, then Excel may require the numbers to be in decimal degrees.

You could set it up so that degrees, minutes, seconds are each in a separate column, and then use the following formula to convert to DD.

Degrees + (Minutes/60) + (Seconds/3600) --> Decimal Degrees