I had some spare time in the hotel room last week, and I took another look at the script that automatically generates flight test cards. I described the initial version  back in March. Since then, I've added a check to see if the weight and CG for the flight match that specified for each test point. I've also cleaned up the CG chart in the test card.

All the planned test points are in a MySQL database. There are also database tables with the aircraft empty weight and CG, the details for each flight (date, crew names and weight, fuel load, ballast, etc). Most test points have a template that gets filled out with the test point condition.

Once I pick the test points for a flight, I run a perl script that pulls the data from the database, creates a CG chart, populates the LaTeX templates with test point data, and about 10 seconds later I'm looking at a test card in pdf format. The script also alerts me if the loading for the flight isn't compatible with the weight and CG range I've specified for each test point.

I've got a few things to sort out, such as adding tracking of completed test points, test points that need repeating, plus create templates for some of the test types, etc. I'll release it to the world once I have it working the way I want. Here is an example of the automatically created test card. All the tests on that card obviously wouldn't be on the same flight, as they need different CGs - it just shows some of the different aspects of the test cards.