Data can be exported from the www.yacht-bot.com website into a CSV (comma separated values) format. This is a human readable format that can be viewed in a text editor or imported in Excel.
www.yacht-bot.com enables you to export either,
- the race session definition, eg, the boat names, attached trackers and manual buoy locations,
- or all the device data from a race, eg all the GPS positions, heading, wind of the YachtBot or WindBot hardware.
1. Export a race session definition into a CVS files
From the www.yacht-bot.com dashboard screen, select the race that you want to export the competitor list from. From the race information screen you can export the list of Yacht, Race marks and Wind sensors.
Exported list looks like this...
,Object 0,yacht,CA-CJ-AACE,#FF00DD,,
,Object 1,yacht,CA-CJ-AACD,#FFBF00,,
,Object 2,yacht,CA-CJ-AAAM,#FFBF00,,
and imports into excel like this...
These CSV files can be used to make a new race by using the import CSV described here...
2. Export CSV device data from a race
Available to PRO level users; Data can be downloaded from any YachtBot or WindBot device that is in a defined race. Once the race is defined click on "Export".
Chose the time format and files options. Click "Export".
The www.yacht-bot.com website will generate the data as a background task and send you an email with a link to download the data. It can take several minutes for the data to be prepared for download.
Below is example CSV data from a single combined file.
| timestamp | latitude | longitude | GPS_ quality | GPS_ count | Course_ Over_ Ground | Heading_ Magnetic | Heading_ True | Speed_ Over_ Ground(kph) |
| 40:55.0 | 174.8622317 | -36.824165 | 1 | 7 | 60.3 | 2.4076 | ||
| 40:55.5 | 174.8622367 | -36.82416333 | 66.3 | 2.778 | ||||
| 40:56.0 | 174.86224 | -36.82416333 | 64.7 | 2.5928 | ||||
| 40:56.5 | 174.8622417 | -36.82416 | 24.3 | 2.0372 | ||||
| 40:57.0 | 174.862245 | -36.82415833 | 52.3 | 1.6668 | ||||
| 40:57.5 | 174.8622467 | -36.82415667 | 6 | 49.4 | 1.6668 | |||
| 40:58.0 | 174.8622467 | -36.824155 | 16.1 | 1.852 | ||||
| 40:58.5 | 174.8622483 | -36.82415167 | 10.3 | 1.852 | ||||
| 40:59.0 | 174.8622483 | -36.82415 | 7 | 21.6 | 2.778 | |||
| 40:59.5 | 174.8622517 | -36.824145 | 27.6 | 3.3336 | ||||
| 41:00.0 | 174.862255 | -36.82414167 | 8 | 40.2 | 3.704 | |||
| 41:00.5 | 174.8622583 | -36.82413833 | 38.7 | 3.8892 | ||||
| 41:01.0 | 174.862265 | -36.82413167 | ||||||
| 41:01.5 | 174.8622717 | -36.82412667 | 7 | 47.3 | 6.482 | |||
| 41:02.0 | 174.86228 | -36.82412167 | 59.2 | 7.0376 | ||||
| 41:02.5 | 174.8622917 | -36.82411667 | 8 | 68.6 | 8.1488 | |||
| 41:03.0 | 174.862305 | -36.82411333 | 9 | 68.9 | 8.1488 | |||
| 41:03.5 | 174.8623183 | -36.82411 | 8 | 69.4 | 8.5192 |
Other data columns includes...
- Speed_Through_Water(kph)
- Apparent_Wind_Angle
- Apparent_Wind_Speed(kph)
- event_time
- heart_beat_count
- computed_heart_rate
- cadence