
Creating Certi cates 24
FastCalXP Operation Manual
EXCEL TEMPLATES
One of FastCalXP’s greatest strengths is the ability to create custom certi cates using an Excel template. This allows the certi cate to be fully customized, in-
cluding the use of graphics and foreign languages. Each model in the database can have a di erent template, allowing for the greatest exibility in generating
certi cates.
FastCalXP creates certi cates by lling an Excel template with the appropriate stored data, replacing tags that identify the elds that are to be lled. Fast-
CalXP does search-and-replace operations in each worksheet in the template that includes a certi cate number tag. Refer to Appendix B: Excel Template
T
ags f
or a list of tags that can be included in the certi cate
templates.
Tags are organized in a hierarchy so that the software will not search for tags that are lower in the hierarchy unless it has already found associated upper level
tags. For example, reference elds will not be lled unless there is a reference number tag associated with those elds. Bold tags listed in Appendix B: Excel
Templa
te Tags are necessary tags in the tag group with which they are associated.
The number sig
n that is included in some of the tags is a placeholder indicating that numbering is required. FastCalXP will not add elds to a template when it is
creating a certi cate but it will empty all unused elds. For example, if the template only contains tags for 5 data points, but the pro le contains 10 data points,
only the rst 5 data points will be placed in the certi cate.
Worksheets within the template can be password protected if the Excel password is set in the Options dialog (see Settings and Options on page 26). Every
sheet in the work
book will be password protected, even if no tags exist on a sheet.
Templates are associated with models. A standard template is provided with the FastCalXP software. This template can be copied and edited to create any
number of di erent templates. Refer to Excel documentation for help with creating Excel templates.
To Create a New Template
1 Copy the provided template
2 Rename the copy and edit the new template in Excel.
Make sur
e there are enough elds and tags for the number of data points to be collected.
To Specify the Default Template
1 Choose Options from the Tools menu and click on the Certi cate Settings tab.
2 Browse to nd the desired template.
T
ake care in making this change, as this will a ect all models that do not have the checkbox Use custom certi ca
te template checked.
To Change the Template That is Associated with a Model for Models That Have a Custom Template Selected
1 Choose Manage Database from the Tools menu and click on Models.
2 Select the desired model, click Edit and use the Browse button to nd the desired template.
Comentários a estes Manuais