New GRT flight data analysis tools (Garmin and Dynon too, sorta)

[flysrv10]

clicking on this "https://drive.google.com/file/d/1f7sEsmv2m6vBiJ5ykkU8Zb0Dp7oOsOEf/view?usp=sharing" on your website for the latest file sez that your file is in your trash. What am I missing? Thanks.

[RV-14E]

Greetings.

My apologies. I neglected to update the link from v4.0 (which is now in the trash). It's been updated on the site to point to v4.1.


You can find my free public domain Microsoft Excel-based software here and view much of the information in the initial posts with higher resolution images and embedded videos.

[Skid]

Originally Posted by RVProcess

Skid - I?ve been uploading my GRT .csv file to Savvy for a couple of years now with no problems.

I uploaded a csv file to Savvy today and it worked fine. Are you running an R66 as well?

[RV-14E]

You can find my free public domain Microsoft Excel-based software here and view much of the information in the initial posts with higher resolution images and embedded videos.

Greetings.

Version 5.0 is up. Stability improvements and bug fixes. Plus a number of new features. See images below.

For Garmin, Dynon, AFS and GRT users

• Airports along your flightpath can be plotted in Google Earth based on a worldwide database of nearly 42,000 airports. The info box for these airports include a nice popup VFR chart snippet.

For GRT LOG file users only:
Flight Data:

• New "stats" page provided that shows which devices are connected to your EFIS, what your serial port and EIS setups are and how much data each device sent to your EFIS.
• TAS and DA calculations improved and now essentially match what your EFIS shows.

ADS-B :

• ADS-B processing is 2.5 times faster.
• FIS-B text products are extracted and provided in a new sheet. You can see METARs, TFRs, PIREPs, Winds Aloft, TAFs, CWAs, etc. from your entire flight.
• Comprehensive FIS-B statistics provided.
• Comprehensive ADS-B and TIS-B statistics provided.
• For ADS-B processing, you can choose with targets to process (ADS-B and/or TIS-B)
• For non-GDL90 ADS-B users, you can now process UAT targets including anonymous TIS-B targets (not to worry: GDL90 users always had this capability with my program).
• More silhouettes are matched to aircraft type on the aircraft list.
• Silhouettes are also provided on the aircraft info box in Google Earth.
• In Google Earth you can flag any aircraft with a red icon, based on highly versatile rules.
• Ground transceivers (a.k.a., "towers") received during your flight are plotted at their locations with a red tower icon.
• URL to actual aircraft image is now saved in the master database.
• You can automatically process your master database to update the actual aircraft image URLs from the image server.
• Reminders given when your aircraft databases are getting stale.

Airports along path.


Info box for each airport.


Airport info box with FIS-B data from flight (METARs, SPECIs and/or NOTAMs.


New comprehensive stats page with EFIS and EIS setup.


LOG file list with flight times and time for EFIS to flush the file to USB.


Comprehensive ADS-B and FIS-B stats.


ADS-B traffic with aircraft silhouette based on manufacturer and type and comprehensive ADS-B and FIS-B stats.


Aircraft info box in Google Earth includes silhouette and image from the image server when available.


ADS-B Towers received during your flight are shown in red.


Example of FIS-B data (shown here formatted differently than in the program).

For Beast binary (folks that use any dump1090-type receiver such as FlightRadar24, FlightAware, ADS-Bx, etc.) and GDL90 binary users (folks that may record data directly from a Stratux using UDP port 4000), the various ADS-B processing improvements for the GRT LOG files have been incorporated into these binary formats too.

For those that are using my program to visualize your ADS-B data, please send me your "No Silhouette Found.txt" file after you've processed some data so I can continue to expand the mapping of the aircraft to their silhouettes. Each locale has a kind of "aircraft ecosystem" so the kinds of planes I see where I fly can be different from those that you may see where you fly. With your help, I can make the silhouette map more comprehensive. I will periodically update the map and publish it so you can import the new map back into the Excel file (easily done through a single button click).

Once again, I am especially indebted to user "R" who is uniquely skilled at finding bugs in my program and has kindly offered suggestions for improvement and a lot of good flight data to test against. Thank you kind sir! And thanks to user "J" for sharing some of his data that helped find holes in my code.

You can find my free public domain Microsoft Excel-based software here and view much of the information in the initial posts with higher resolution images and embedded videos.

[Tankerpilot75]

Does this analysis tool work with the GRT WS EFIS and it’s older format of data recording?

I am just barely functional with Excel (used to be better but ten plus years of retirement has reduced my computer skills) and wondering is there a Macro button for up loading data from a usb drive? I would love to be able to do some engine analysis from previous flights and look closely at stall and climb data.

Jim

[Canadian_JOY]

Originally Posted by Skid

I uploaded a csv file to Savvy today and it worked fine. Are you running an R66 as well?

Thanks for confirming Savvy now works with GRT EIS-66R data files.

As an update from this corner of the world, I've finally got the EIS-66R installed. It's controlled by a newly-installed Sport EX EFIS, with data shared over to the HX as well. I haven't yet pulled any files from the Sport EX to see what they look like - when I do it will be very helpful to be able to upload the files to Savvy.

[h&jeuropa]

Jim Tankerpilot75,

Have you tried Savvy (https://www.savvyanalysis.com/home) to analyze your GRT data? Not only will it display engine data, but also altitude and airspeed. It will accept the older GRT LOG files.

Jim Butcher

[rv8ch]

Hi Emarit, would you be able to take the data and give information about IAS accuracy?

I guess all the information needed is in the file. Assuming you know the GPS groundspeed, the IAS, the rate of climb, heading/track, etc. it should be possible to figure out the IAS error.

Is this something that's already in your excel program, or something you could add? I realize it's not as sexy as the other cool stuff that you've added in the last versions!

Thanks!

[BobTurner]

Originally Posted by rv8ch

Hi Emarit, would you be able to take the data and give information about IAS accuracy?

I guess all the information needed is in the file. Assuming you know the GPS groundspeed, the IAS, the rate of climb, heading/track, etc. it should be possible to figure out the IAS error.

Is this something that's already in your excel program, or something you could add? I realize it's not as sexy as the other cool stuff that you've added in the last versions!

Thanks!

To do this you need to know the wind, or be able to calculate it. Usually people will fly a triangle to figure the average wind (hoping it won’t change much during the three legs). It would then be easy to program up in Excel.

[RV-14E]

Originally Posted by Tankerpilot75

Does this analysis tool work with the GRT WS EFIS and it’s older format of data recording?

I am just barely functional with Excel (used to be better but ten plus years of retirement has reduced my computer skills) and wondering is there a Macro button for up loading data from a usb drive? I would love to be able to do some engine analysis from previous flights and look closely at stall and climb data.

Jim

Hi Jim,

The program will work for your EFIS and in fact it will work for all GRT EFISs to-date.

Please download the program and read the "Welcome" sheet on the spreadsheet to learn how to use it. It does take a little time investment, however it's worth the effort.

For LOG files, there are two ways to ingest them into the program:

1. Place the LOG files from one contiguous flight that you want to analyze into the same folder as the spreadsheet. Hit the big blue button on the "LOG - Options" sheet and wait a few seconds for the analysis to complete. Note: If you have LOG files from more than one flight in the folder, the program will popup a warning message.
   
2. On the "LOG - Options" sheet, change the "LOG File(s) Location" option to "Choose Files", press the blue button and then select the files from one flight that you wish to analyze.

In either case, then change to the "FDL - Graphs" sheet to see the flight and engine data graphs (including graphs that show your EFIS' "health", like temperature and voltage), change the bounds, zoom, etc.

Also, by default, KMZ file(s) will be available for viewing in Google Earth. One KMZ file would be of your flight path showing engine and flight data at each point and a "virtual pilot" mode for you to take the pilot's view of the flight in real time, or quicker. If you had ADS-B data being fed to your EFIS, you will see the results of that processing on the "LOG - ADS-B" with highly specific silhouettes and other aircraft information, including a separate KMZ file animating all the traffic from your flight with each aircraft shown with an icon representing type (by default, I set all RVs to be red icons, whereas others are yellow).

Once you use the program a few times, it becomes natural and you'll be a pro at it!

I hope you find the program useful and helpful.