• Which the release of FS2020 we see an explosition of activity on the forun and of course we are very happy to see this. But having all questions about FS2020 in one forum becomes a bit messy. So therefore we would like to ask you all to use the following guidelines when posting your questions:

    • Tag FS2020 specific questions with the MSFS2020 tag.
    • Questions about making 3D assets can be posted in the 3D asset design forum. Either post them in the subforum of the modelling tool you use or in the general forum if they are general.
    • Questions about aircraft design can be posted in the Aircraft design forum
    • Questions about airport design can be posted in the FS2020 airport design forum. Once airport development tools have been updated for FS2020 you can post tool speciifc questions in the subforums of those tools as well of course.
    • Questions about terrain design can be posted in the FS2020 terrain design forum.
    • Questions about SimConnect can be posted in the SimConnect forum.

    Any other question that is not specific to an aspect of development or tool can be posted in the General chat forum.

    By following these guidelines we make sure that the forums remain easy to read for everybody and also that the right people can find your post to answer it.

skyLOGX: Pilot Navigation Log & Flight Plan Converter

bina

bina

Messages
217
Country
azerbaijan
I can see that FSDeveloper is mainly a discussion platform for aircraft and scenery developers. Nevertheless, I've decided to share my humble project called "skyLOGX" ['skai 'lɒdʒiks] with fellow aviators to assist them with pre-flight routine.

This is basically a MS Excel VBA tool to create a navigation log with almost all information necessary for a successful flight and to convert flight plans generated by FSX/P3D or Plan-G (in PLN format) to Google Earth's KML and/or SkyVector format. The reversed conversion from SkyVector back to PLN is also possible.

I've been able to test the program in Excel 2007 / 2010 for 32-bit Windows platforms but I hope it will also work on higher versions of MS Excel. To avoid potential runtime errors, however, I would recommend getting all necessary updates through Microsoft's Windows Update.

I've tried to keep the user-interface as simple as possible. You can modify the cells with values colored in green and change formatting to your liking.

skyLOGX comes with a separate database compiled from various resources and is freely expandable/updateable which means you can add your own airports, navaids or waypoint fixes to the database provided that the general layout and cell formatting of dBase files is kept intact.

Currently, skyLOGX supports two types of aircraft but I'm planning to add other aircraft profiles upon users' request and availability of reference documentation such as performance charts.

The project is currently in version 2.0 beta which is a complete overhaul of the previously released v1.0 with many bugs fixed and new features added. And I hope to get as much feedback from you guys as possible to further polish the code before stable release. Please feel free to download skyLOGX and try for yourself... I will highly appreciate any comments, thoughts and recommendations!!!

Prerequisites:
* Microsoft Excel 2007/2010 on 32-bit Windows machines patched with latest updates
* MSXML parser 4.0 SP3 or higher
* Enabled macros
* FSX/P3D (in XML format) or SkyVector flight plan. See sample flight plans dispatched with the archive
* Stable Internet connection
* Free Time Zone API key from World Weather Online. This is basically required to ensure correct time calculations. You'll be requested to enter you API key upon the first launch of application.



DOWNLOAD v2 Beta (build 27-03-2015)

Thank you!

Vüqar
 
Last edited:
Hello. I got an error message when I clicked on the FSX/P3D button: "compile error in hidden module: FSXP3D". I h ave macros enabled and MSXML 4.0 SP3 installed.
 
I haven't but just downloaded, thanks for your reply. I did download the latest version and I still get the same error message. Also, the macros seem to be password-protected. That is okay but it doesn't allow me to troubleshoot the problem myself.
 
Last edited by a moderator:
The updated version is in the works... But, as always, I need some spare time to concentrate on it. It will include some new features and fixes.
 
Last edited:
Hello. I do not know if bina saw my message above but I did download the latest skyLOGX_v2.xlsm and I still get the message: compile error in hidden module: Functions. I'm using Excel 2007. I have FSX running, copied the url from Skyvector.com and whether I load the spreadsheet or click on a a button, I still get the error message. Since the macros are password-protected, I am unable to fix the problem myself, please help, thanks.
---- update ----
Well, I was able to get into the modules but I couldn't see anything that helped. I did come across a website for help (http://www.codedawn.com/index/-compile-error-in-hidden-module-message-in-excel) but the suggestions didn't work either. Does anyone know what addin(s) it's talking about (the Find&Replace addin install didn't work either)?
 
Last edited by a moderator:
I know it's been a long time but does any know if there was ever an update to this to allow use with Excel 2016?

Would bina be willing to provide the password so we can try to fix the problem ourselves?

Or has anyone else been able to figure a work-around to the 'compile' error?
 
You must log in or register to reply here.
Back
Top