Date of Award


Document Type


Degree Name

Master of Science


Department of Operational Sciences

First Advisor

Richard F. Deckro, PhD


Fighter Pilots students undertake an intense 120-day training program. New classes of students enter the training program at regular interval. Students endured rigorous academic, simulator, and aircraft training throughout the program. Squadron schedulers ensure the multiple classes and students are scheduled for the activities. Simulator and aircraft training are scheduled individual for each student. Academic training are taught to the class. Aircraft utilization must also be considered. Aircraft Sortie training are also constrained by daylight hours. Additionally, students are limited to a maximum of three training events in a given day. Squadron schedulers must balance these requirements to ensure students meet their training requirements and successfully graduate. The dynamic training environment requires advanced robust schedules with flexibility to accommodate changes. A Visual Interactive Modeling approach is used to generate schedules. Current schedules are being generated manually with an Excel spreadsheet. Taking advantage of Excel's Visual Basic Programming language, the Excel tool is modified in several ways. Scheduling Dispatch rules are implemented to automatically generate feasible schedules. Graphical User Interfaces are used to create a user-friendly environment. Schedulers guide the schedule building process to produce a robust schedule. An attrition environment is created to simulate attrition probabilities of aircraft sortie training due to operations, maintenance, weather, and other cancellations. Analysis of dispatch rules are analyzed.

AFIT Designator


DTIC Accession Number