IMI Sensors: A PCB Piezotronics Div 699A07 User Manual
MAN-0192 rev A Page 10 of 39 800-959-4464
user to create and print a calibration certificate with just a few mouse clicks. In order
to use the file, make sure macros are enabled, otherwise Excel won’t be able to load
data and create the certificates.
The Excel workbook consists of the following worksheets or tabs:
• FRData – Use this tab to create a frequency response certificates in just 2 steps:
1. Clicking on Import Data from File button prompts the user to select and import a
.csv calibration data file previously created by the 699A07
2. Once data is loaded into the table, click View Certificate to see and print a
calibration certificate containing the frequency response data (the reference
frequency for the calibration certificate is 100Hz and can be changed by the user as
needed)
Note: If testing a charge-mode accelerometer and calibration certificate in pC
units is desired, click the box at top left of the FRData tab and enter the sensitivity of
the charge amplifier in the “mV/pC” box located at cell D8. See the section
“Calibrating Charge-Mode Accelerometers” for more information.
• LINData – Use this tab to create linearity response certificates. The worksheet
applies linear regression to interpolate the data. The Max Linearity is calculated for
the worst deviation of a particular point from the best-fit straight line (BFSL) of all
tested points. The table also displays the specific results at each test level.
The LINData worksheet has 2 tables. The left table should be used for creating
dynamic linearity data calibration certificates in just 2 steps:
1. Click on Import Data from File to select and import a .csv calibration data file
previously created by the 699A07
2. Once data is loaded into the table, click View Certificate to see and print a
calibration certificate containing the linearity response data. The worksheet expects
the data points to be taken at the same frequency (speed). A checkbox option
labeled Set Y-intercept to zero is available to force the interpolation to go through
the origin point.
The right table in the LINData worksheet is used to create a DC proximity probe
curve or linearity certificate for 4-20 mA vibration transmitter. Creating a DC
proximity probe curve requires the 600A22 or 600A23 proximity probe adaptor kits
and a DC voltmeter (not included). Creating a linearity certificate for a 4-20 mA
vibration transmitter requires DMM set to DC current input.
1. Select the appropriate vibration scale (Acceleration, Velocity or Displacement) by
clicking in cell H12 and selecting from drop down menu.
2. Select the appropriate units (g’s pk, g’s RMS, m/sec
2
pk, m/sec
2
RMS, in/sec pk,
in/sec RMS, mm/sec pk, mm/sec RMS, mils p-p or µm p-p) in cell H13. Make sure
cell H12 is set to the right scale first.
3. Enter known amplitude and output for the first test point next to “Starting Point”
and repeat for each additional test point moving down the table. Once data is
entered into the table, click View Certificate to see and print a calibration certificate
containing the linearity response data.
• FRCert - Displays the frequency response calibration certificate using the current
data and information from FRData.
• LINCert - Displays the linearity response calibration certificate using dynamic
linearity data from LINData.
• SLINCert - Displays the linearity response calibration certificate using static
linearity data from LINData.
To Next Page
Loading...
Need help?
General