Mobile Crossing WayPoint Map Loader Instrukcja Operatora Pobierz pdf (Strona 29)

SeaMarks manual V. Additional Information •

••

• 29

be created may be about twice as tall as the screen (unless you use landscape orientation) and may show more waypoints.

Also use the MAP>Show All Maps feature. It shows all your saved maps as outlines on one chart. From this you can

see where more maps are needed or where you need to make adjustments to maps to get the best coverage.

If you try to make a map of an area that encompasses one of the Loran stations being used, or if the lines are highly

curved, the Loran to Lat/Lon computations may fail, which means that the map will have some missing Loran lines.

You will be able to see this when you Map>View Map. Changing chains or map areas may rectify the situation.

4. How to Import a File Using Excel

The program comes with many capable importing routines, but it can't handle all possible situations. Microsoft's

EXCEL is an excellent tool for importing and exporting between the program and arbitrary text and formatted files like

found on the Internet. What you need to do in Excel is reformat the information into the right sort of data and save the

file as "CSV (comma delimited) (*.CSV)". If the description fields have commas then replace them with something else

like dashes. Having extra commas in a CSV file will cause the waypoint data to be read incorrectly.

1. Open the source data in Excel

2. Start by making sure the latitude and longitude data (if available) is in the right format. Some data

on the Internet separates the E/W and N/S indicators and/or the degree and minute data into

different columns. It is necessary for this numeric data (degrees and minutes) to be in two

adjacent columns for latitude and longitude. The acceptable formats for Lat/Lon are listed

elsewhere in this document. If the degree and minute data is in separate columns, that needs to be

fixed. One way to accomplish this is to create two new columns and fill them with the degree data

plus the minute data divided by 60. You do this by placing the cursor in the first cell and typing

"=". Then click the degrees column (in the same row) followed by "+", click the minutes column

(in the same row) followed by "/" followed by "60". Then push "Enter". The E/W and N/S stuff

is not necessary, so if it is in separate columns, that is no problem unless it is between the latitude

and longitude columns. The latitude and longitude columns must be adjacent with latitude first.

3. If the data is in Loran, the preferred format is to have the loran numbers such that column 1 is the

first number we will call TD1. The second column is TD2, and any other data is likewise in its

own column(s). There should be no extraneous data breaking this pattern. There should be no

blank rows or any rows with any other data except maybe the first row can have column headers

like: TD1, TD2, Name, Description, Source, etc. Excel is very good at propagating data into other

rows. For example, if you want the data to be named as a numerical sequence, you could set

numbers in column 3 as 001, 002, 003. Then select all 3 rows of column 3 and look for the small

square dot at the lower right cormer of the selection box. Grab that dot and pull it down to fill the

rest of the column with sucessive numbers. Then, later after sorting the data by TD1 or TD2, you

can return it the original order by sorting on this column. If you don't use the leading zeros, the

sort on that column will be screwy like: 1,10,100,1000,11,110,1100, etc.

4. When you are done, highlight all the columns used and choose Data>Sort and sort on the column

containing TD1 (or Lat). Scan the list to eliminate duplicates and find major errors. Use

Edit>Delete to get rid of rows you highlited. The delete key will not get rid of the row, just

remove the data from it. Edit any numbers that fall at either end of the column that indicate data

entry errors. These will show up if the first 1 or 2 digits are very different from the other

waypoints. Unfortunately, this will not help if less significant digits are wrong. Do the same for

TD2 (or Lon). Always make sure that you highlight all columns containing data before sorting as

you can scramble the data into a useless mess where the TD1 column is sorted, but not the TD2

column.

1 2 ... 24 25 26 27 28 29 30 31 32 33 34 ... 129 130

Komentarze do niniejszej Instrukcji

Brak uwag

Mobile Crossing WayPoint Map Loader Instrukcja Operatora Strona 29

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Nawigatory Mobile Crossing WayPoint Map Loader