1. Forum
  2. Usenet
  3. REC.AVIATION.SOARING

  • Slice & Dice Glider Accidents Data

    From IdoMillet@21:1/5 to All on Sat Apr 16 10:41:00 2022
    I used FAA data to compile USA glider accidents into an excel file. My Visual CUT software converted that data into this interactive web page: https://www.milletsoftware.com/Data/Glider_Events.html

    This allows you to slice & dice the data via pivot tables & charts. A dropdown allows you to select from master report layouts. You can filter, sort, modify and add your own reports (accessible only to you).

    Double-clicking a summary cell or a chart node provides a drill-down to the detail rows making up that summary. Hover over details to see the full text via a tooltip.

    One of the master reports provides accident frequency and damage level by Make, Model, and Registration Number. So you can look up past damage for a particular glider.

    A video segment explaining the functionality is available here: https://youtu.be/Vwt8TXdKU7A?t=548
    It uses different data, but the idea is the same.

    Please send feedback and ideas for additional report layouts.

    Fly Safe!
    - ido

    Ido Millet
    www.MilletSoftware.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From IdoMillet@21:1/5 to All on Wed Apr 27 05:14:00 2022
    I used FAA data to compile USA glider accidents into an interactive web page: https://www.milletsoftware.com/Data/Glider_Events.html

    This allows you to slice & dice the data via pivot tables & charts. A dropdown allows you to select from predefined report layouts. You can filter, sort, modify and add your own reports (accessible only to you).

    Double-clicking a summary cell or a chart node provides a drill-down to the detail rows making up that summary. Hover over details to see the full text via a tooltip.

    One of the master reports provides accident frequency and damage level by Make, Model, and Registration Number. So you can look up past damage for a particular glider.

    A video segment explaining the functionality is available here: https://youtu.be/Vwt8TXdKU7A?t=548
    It uses different data, but the idea is the same.

    Please send feedback and ideas for additional report layouts.

    Fly Safe!
    - ido

    Ido Millet
    www.MilletSoftware.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From IdoMillet@21:1/5 to All on Wed Apr 27 05:26:48 2022
    I compiled FAA USA glider accident data into an interactive web page: https://www.milletsoftware.com/Data/Glider_Events.html

    This allows you to slice & dice the data using pivot tables & charts. A dropdown allows you to select from predefined report layouts. You can filter, sort, modify and add your own reports (accessible only to you).

    Double-clicking a summary cell or a chart node provides a drill-down to the detail rows making up that summary. Hover over details to see the full text via a tooltip.

    One of the predefined reports provides accident frequency and damage level by Make, Model, and Registration Number. So you can look up a particular glider.

    A video demo is available here: https://youtu.be/Vwt8TXdKU7A?t=667
    It uses different data, but the idea is the same.

    Please send feedback and ideas for additional report layouts.

    Fly Safe!
    - ido

    Ido Millet
    www.MilletSoftware.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Shaun Wheeler@21:1/5 to All on Fri May 6 12:38:51 2022
    Very nice work. I went through a pile of these the hard way, this would have saved me a lot of work!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From IdoMillet@21:1/5 to All on Wed May 18 11:37:00 2022
    Added a 'Phase' column and a couple of displays focusing on flight phase (Landing, Takeoff, etc.).

    Reminder: these displays are interactive, so you can Slice & Dice, Drill-Down, Filter, and create your own displays:
    https://www.milletsoftware.com/Data/Glider_Events.html

    - ido

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)