Route in Excel for Logbook

If you have an idea how to improve application, post it here...

Re: Route in Excel for Logbook

Postby kitercuda » 16 Apr 2017, 16:06

Díky za inspiraci. Asi to talčítko Donate udělám, s aplikaci trávím 90 procent svého pracovního času, ale představuje tak do 10% mých příjmů. Dělám to jen, protože mě to baví ;)
User avatar
Posts: 1108
Joined: 11 Apr 2012, 11:25

Re: Route in Excel for Logbook

Postby FIFFAN » 29 Nov 2018, 17:54

Dear kitercuda,

I am trying to customize .xls Navigation Log and following your instructions in manual.

Everything goes well but when I export routes in "FIF_compact.xls" form I cant get coordinates in "raw_data" sheet in MGRS format.
MGRS format of coordinates is selected in App settings / Preferences / Units select / Geographical coordinate unit / MGRS 10 digit grid and used without problems in Fly is Fun application on android device.

In "raw_data" sheet in section with Units and its formats it stands Coordinates 34UBA 93921 67312

And down where at route details are "Decimal latitude" & "Decimal longitude" columns with D.DDDDD formats and "Latitude" & "Longitude" columns with 34UBA 93921 67312 format. But regardless all the coordinates in all those rows are in D.DDDDD format.

How can I get MGRS format in "Latitude" & "Longitude" columns? I believe it has to be possible.
Also, is it possible to get that data in DDD:MM:SS.SS and MGRS formats in the "raw_data" sheet simultaneously?

Additional question, in "raw_data" sheet all times in EET columns are in hh:mm format, is it possible to get it in hh:mm:ss format ?

Thank You in advance,
Best regards!
Posts: 1
Joined: 29 Nov 2018, 16:30


Return to User suggestions

Who is online

Users browsing this forum: No registered users and 1 guest