Tandem Capacity Model (TCM) Manual

from the database. This option is useful for deleting all history data for an old apportionment
method.
Sort History
The Sort History option is used to sort the Capacity History data by transaction name or by sample
name. It is available only when there is a Capacity History (.HST) file in the current session.
To sort Capacity History data:
1. Select History > Sort History.
2. When the Sort History dialog box appears, click the button for the sort method.
• To see how much a transaction varies by sample, select Sort by Transaction.
• To see a chronological list of data, select Sort by Sample.
3. Click OK.
For online help about the Sort History dialog box, click the Help button in the Sort History dialog
box.
Chart History
The Chart History command creates two types of History charts from the History file, Trend charts,
and Mix charts. Trend charts and Mix charts are placed on worksheets named TrendCharts and
MixCharts, respectively, in the History file workbook. To select a worksheet, click its sheet tab at
the bottom of the screen or find it using the TCM Find command.
Display Tab
The Display tab is used to specify what information TCM displays and how it is displayed.
Display (or Undisplay) Scratch Areas
The Display (Undisplay) Scratch Areas option allows you to view several areas of the model that
are hidden during normal use. These hidden areas contain valuable scratch data for the proper
operation of the model and data that could be helpful to you if you want to understand the model’s
structure and formulas. Once selected, the option toggles to Undisplay Scratch Areas, which you
can select to return the screens to their normal appearance.
Change Display Fonts
The Change Display Fonts option changes the fonts that TCM uses to display its data. TCM supports
four font characteristics: Normal, Bold, Italic, and Title. You are prompted to select the font
characteristics for each font.
For more information, refer to the Microsoft Excel documentation.
Show Value (Control-V)
The Show Value option shows the current field value up to 15 decimal places.
128 Workload Apportionment Model