Appendix, Appendix a: fastcalxp pressure units, Appendix b: excel template tags – Crystal FastCalXP Calibration Software User Manual

Page 53: Appendix b: excel template, Tags, Appendix b: excel, Template tags

Advertising
background image

Appendix

51

FastCalXP Operation Manual

Appendix





APPENDIX A: FASTCALXP PRESSURE UNITS

FastCalXP uses the following standard units and associated conversion factors from PSI. All conversion factors use a gravity constant of 9.80665 m/sec

2

.

1 PSI =

27.6806 inches of water column (water at 4° C [39.2° F])

27.7070 inches of water column (water at 15.6° C [60° F])

27.7292 inches of water column (water at 20° C [68° F])

2.03602 inches of mercury (mercury at 0° C [32° F])

51.7149 millimeters of mercury (mercury at 0° C [32° F])

703.087 millimeters of water column (water at 4° C [39.2° F])

0.070307 kilograms per square centimeter

68.948

millibar

6.8948

kilopascals

0.068948

bar

0.006895

megapascals





APPENDIX B: EXCEL TEMPLATE TAGS

Following is a list of Excel template tags used by FastCalXP to create certifi cates using search-and-replace operations.

Tags are always included within chevrons (e.g., <tag>) and they can occur anywhere within a template worksheet. However, FastCalXP will only search and

replace in a worksheet that includes the <CertNum> tag. Bold tags must be present for FastCalXP to fi ll fi elds defi ned by other tags in the same group.

Tags marked “Saved in Cert” are values that will remain constant within a certifi cate once the certifi cate is created, even if the information in the database

is changed at a later date. For example, the gauge number for a given certifi cate will not change even if it is changed in the database after the certifi cate is

created. Since the system can recreate the certifi cate at a later date, saved fi elds provide an assurance that the major elements within a certifi cate will not be

modifi ed after the certifi cate is created.

Some of the tags have a number sign (#) as part of the tag. This is to support multiple values of the same type (i.e., multiple references or data points) to be

included in the certifi cate. For example, to have a certifi cate that has ten indicated pressure points for run 1, you would need to include <ARRun1Point1Indi-

cated> through <ARRun1Point10Indicated> tags in the template. To have a certifi cate that has multiple runs i.e. 5 runs, you would need to include <ARRun-

1Point1Indicated> through <ARRun5Point1I0ndicated>. The registry entry value for the following must be at least the same number of runs in the template:

HKEY_CURRENT_USER\Software\Crystal Engineering\FastCalXP\Settings\ExcelMaxRuns Value Data “5”.

Advertising
This manual is related to the following products: