DCS F-16 Data card Generator

[PeneCruz]

Sharing my data card generator for the DCS F-16C. Built for my personal use, but happy to share with the community.
- Based on the Excel Data Card builders used in real squadrons. 
- It imports the DCS Route Tool saved routes from you Saved Games folder and converts to usable LAT/LON route information to automatically allow for Stores & Weight Planning, Fuel Planning, TOLD computation and a function to export the data inlcuding the route directly to the printable 2 page data card.
- The workbook has an Attack Planner for both Pop-Up and Dive Attacks that are also exported to drag and drop shapes and datablocks to speed up Data Card generation.
- The datacard has a bunch of configurable data blocks (via a block editior) to suit different mission sets.
- Also configuarle shapes and symbols to allow plans to be visualized and understood.

I see this suited to muliplayer users where co-ordination and planning is important and also allows better use of the Route Tool function built into multiplarer DCS. The Cover is completly unlocked to allow it to be customised to your own squadron.

Video on how to use it and what to expect.
How to Use It

Link to the workbook
F-16C Data Card Generator

And a payload config file that matches the Mission Planners STD Stores configurations (goes in your Saved Games\DCS\MissionEditor\UnitPayloads folder) Not required but makes things very quick from panning to mission execution.

Payload Config File

Built for my personal use but sharing with the community as is. It uses macros and VBA Code to run many of it's functions, you will get a security warning from Excel. It will NOT run in Google Sheets for the same reason. I use Excel 365 and many of the Macros are quite modern so may not be backward compatible.

Happy Viper Flying.

[theonetruejason]

This is absolutely lovely work.

[GPatricks]

Very nice, and assume it can be used by OpenKneeboard to display in the cockpit in VR!

[PeneCruz]

31 minutes ago, GPatricks said:

Very nice, and assume it can be used by OpenKneeboard to display in the cockpit in VR!

Yes that's how I use it works really well with my Wacom tablet in VR.

[Delta134]

Awesome work! I'm curious; do you do these performance calculations through interpolated empirical data (graphs and tables from the manual) or is it done using flight mechanics and equations of motion?

[PeneCruz]

2 hours ago, Delta134 said:

Awesome work! I'm curious; do you do these performance calculations through interpolated empirical data (graphs and tables from the manual) or is it done using flight mechanics and equations of motion?

It uses an F-16 tabulated data set for performance calculations. Fuel planning is pretty rudimentary at the moment using interpolation at a single drag index. I have already added a full data set of cruise tables and will add drag index and a proper vertical interpolation based on the imported route rather than the selected profiles.