Visualization data

Former Member over 4 years ago

Hi all,

I'm new on Garmin BaseCamp and I'm trying to understand its functionalities.

I've registered a track on the GPS and upload it to BaseCamp.

When I go to the graph visualization and I scroll the mouse on the track the tool shows the grade.

My first question is: can I highlight on the map portions of the track depending on the grade? (i.e. portion of the track which grade is between 3 and 6% etc?)

In case the tool does not allow to do that, is there any chance to post process the data in excel to get the grade between points of the track?

I assume grade is calculated by the ratio between different elevation between two points and their corresponding distance but when I visualize the properties of the track I get a positive or negative grade even if elevation between two points is the same (not sure if I need to increase the precision of the elation to a decimal numbers as currently it shows only differences in meters).

I hope someone can help me on that.

Thanks in advance.

Best,

Roberto

0 BTLAAKE over 4 years ago

The short answer is no. On the graph, you can click on a point, shift click on a second point and the map will show two figures on the track corresponding to the two points on the graph. However, you can only do this for one section. A third left mouse click will remove the prior selection. The points selected on the graph are not highlighted in the table.

In the table, you can highlight a section of the track on the map by selecting consecutive points in the table. But you can only do one selection at a time. You also cannot add a grade column to the table.

The table rounds data to the nearest integer, while the graph uses the raw data. I think elevation data is stored to two decimal places (i.e. xxx.xx). You can get a little better precision in the table by switching to statue units. The table itself can be copied and pasted into Excel.

You can also open a track gpx file with excel. Only the last 4 or so columns will be of interest to you. These will contain the latitude, longitude, elevation and time stamp. Elevation will be in meters regardless of the settings in BaseCamp or device. The time stamp will be UTC in text format. It can be converted to an Excel time by using the replace command to remove the Z and replace the T with a space. You would then have to write a macro to calculated the distance between points. The simplest would be a Great Circle calculation, which should be good enough for your purpose.

Yes % grade is change in elevation divided by leg distance times 100.