28 June 2001
the alphabet. Make sure you change both letters.
These reference the
months and will update the cockpit chart for you.
3. Follow the same procedure as above for the information that is
Make sure that the correct series is changed if there are
several displayed in the box. It is recommended that you
actually display the series by left clicking the RED arrow box
to the right of the series. This will take you to the "Chart
Data" where you can visually confirm that the correct
information is displayed. Then simply change the letters with
the range to have the correct data plotted.
CREATING A NEW PANEL
1. Prior to creating the new panel, establish another area on the
"Chart Data" page so that it can be linked to the new chart.
2. Use the "Chart Wizard" function of Excel to create the new chart.
Once it is completed, including the linkage to the "Chart Data" page,
you will be asked to place it.
Place it as an object in the current chart.
4. If this is a new center panel, left click on the outer edge of the
current center panel. Eight black squares will appear. Use these to
shrink the current chart to provide space to accommodate the new
5. Drag the new chart into position and size it accordingly. Make
sure that the "borders" option is turned off around the new chart.
"X" DATA MANAGEMENT
1. Use the "Source Data Xs" tab to compute the information to track
and establish the number of Xs required to be flown by month.
2. Once the calculation is completed, transfer the appropriate
information (number flown in the month-ACTUAL and number required next
month-ENTITLEMENT) to the "Chart Data" tab. This will automatically
update the appropriate panel(s).
As the cockpit chart process matures within CNATRA, Cycles of
Learning will be applied and certain refinements may be
required. In order to maintain a standard set of cockpit charts
supporting "drill down"; procedures for changes to this
instruction are included. No changes should be made to the
cockpit charts, the data sources, definitions, or other portions
of this process until after approval in accord with the
instructions that follow.