Help
About SCview.xls, version 4.2, 22-November-2006
SCview.xls is an Excel Spreadsheet for viewing and printing results from the
SC11 version 2.3 or later and the SC15 (any version).
Because of a file format change, you need version 1.7 or later for SC11 version 4.2.
This version of the spreadsheet is required to view the Chart and Spectrum Datalog files.
It is provided by Spicer Consulting free of charge, but without any support commitment.
Feel free to copy and modify it. It was developed under Excel 97 and requires Visual Basic Macros enabled.
Using this Spreadsheet
To view exported data, click the Chart tab and press the Open button which is to the right
of the chart. Select a text file that has been exported by the SC11 or SC15 and click
Open. The file will be displayed on the chart. The Preview button gives you a Print Preview and the
Print button prints the chart immediately, with no intervening dialog boxes.
The "Chart Axes" button gives access to a simple window to change the axis and title options. There are 3 buttons:
"Apply" makes any changes to the chart and keeps the window open, "OK" makes any changes and closes the window.
"Cancel" and the "close window" icon in the corner will close the window without making any changes since the last time "Apply" w
The tables below control the standard settings of the Y axis for the various different units.
You can edit the table to change the settings.
If you wish to add a user defined unit to the SC11 list below, use the "Add User Defined Y unit" button.
This will ensure that the unit is placed in the list in a position where the search for units is not disrupted.
The new export file format contains range information for the data. This is used to set up the initial chart.
If this range information is not present then the chart range is set using the tables below
How it works
Open calls the macro LoadFile which opens the text file and
puts it under the Data tab. It then fills in the X axis values and works out all the information for the
chart before updating it. Open relies on the chart being partly set up beforehand. Therefore you can
change some aspects of the chart manually and Open will keep them the same. However, it might
stop working if you remove something it expects to be there.
The "Add User Defined Y unit" button brings up a form to fill in the details of the new unit. It also checks
that the details are valid and places the new unit in the list in a position where the "open" routine's search
for an appropriate unit will not be disrupted. Note: the unit may not be placed in an obvious location in the list.
SC15 Y Unit Table
SC11 Y Unit Table This table sets a standard Y axis title a
This table sets a standard Y axis title and range for each Y unit * is a wildcard. The last row matches a
Yunit Title Log Ymin Ymax Yunit
mG Magnetic Field TRUE 0.001 10 *N
nT Magnetic Field TRUE 1 1000 *lbf
uT Magnetic Field TRUE 0.001 1 *Pa
A/m Magnetic Field TRUE 0.001 1 *psi
mA/m Magnetic Field TRUE 0.1 100 dB
V Voltage TRUE 0.001 10 um/s2
mV Voltage TRUE 1 1000 mm/s2
ug's Acceleration TRUE 0.0001 10 *m/s2
mg's Acceleration TRUE 0.0001 10 *g's
mm/s2 Acceleration TRUE 0.01 100 *Gal
mm/s Velocity TRUE 0.0001 0.1 mil/s2
um/s Velocity TRUE 0.01 100 inch/s2
um Displacement TRUE 0.001 1 um/s
nm Displacement TRUE 0.001 1 mm/s
Pa Sound Level TRUE 0.001 1 *m/s
Page 1
Help
mPa Sound Level TRUE 1 30 mil/s
dB Sound Level FALSE 50 90 inch/s
Default User Defined Units TRUE Auto Auto um
Add User Defined Y unit
mm
*m
mil
inch
degrees
*V
*T
*Gauss
(*)2
(*)2/Hz
*
Page 2
Help
sual Basic Macros enabled.
title options. There are 3 buttons:
s any changes and closes the window.
making any changes since the last time "Apply" was clicked.
Defined Y unit" button.
r units is not disrupted.
o set up the initial chart.
new unit. It also checks
e "open" routine's search
n obvious location in the list.
SC15 Y Unit Table
This table sets a standard Y axis title and range for each Y unit
* is a wildcard. The last row matches anything the other rows missed.
Title Log Ymin Ymax
Force TRUE 0.001 100
Force TRUE 0.001 100
Pressure TRUE 0.001 100
Pressure TRUE 0.001 100
FALSE -60 40
Acceleration TRUE 0.001 100
Acceleration TRUE 0.001 100
Acceleration TRUE 0.001 100
Acceleration TRUE 0.001 100
Acceleration TRUE 0.001 100
Acceleration TRUE 0.001 100
Acceleration TRUE 0.001 100
Velocity TRUE 0.001 100
Velocity TRUE 0.001 100
Velocity TRUE 0.001 100
Page 3
Help
Velocity TRUE 0.001 100
Velocity TRUE 0.001 100
Displacement TRUE 0.001 100
Displacement TRUE 0.001 100
Displacement TRUE 0.001 100
Displacement TRUE 0.001 100
Displacement TRUE 0.001 100
Phase FALSE -200 200
Voltage TRUE 0.001 100
Magnetic Field Strength TRUE 0.001 100
Magnetic Field Strength TRUE 0.001 100
Power Spectrum TRUE 0.001 100
Power Spectral Density TRUE 0.001 100
FALSE Auto Auto
Page 4
Data
Exported by SC11 Spectrum Analyser 3.0 - Sensor 02016
14:30 21-May-02
window Hanning averages 8
xunit Hz fx 1.258925 points 21 x0
Frequency (Hz) A Spec
dB (RMS) dB (RMS)
1.58E+01 6.50E+01 7.00E+01
2.00E+01 4.92E+01 5.00E+01
2.51E+01 5.15E+01 5.00E+01
3.16E+01 5.34E+01 5.00E+01
3.98E+01 5.06E+01 5.00E+01
5.01E+01 5.28E+01 4.00E+01
6.31E+01 4.89E+01 4.00E+01
7.94E+01 5.16E+01 4.00E+01
1.00E+02 4.76E+01 4.00E+01
1.26E+02 4.51E+01 7.00E+01
1.58E+02 4.54E+01 7.00E+01
2.00E+02 4.88E+01 7.00E+01
2.51E+02 4.48E+01 7.00E+01
3.16E+02 4.08E+01 5.00E+01
3.98E+02 4.23E+01 5.00E+01
5.01E+02 4.67E+01 5.00E+01
6.31E+02 4.48E+01 5.00E+01
7.94E+02 4.20E+01 4.00E+01
1.00E+03 3.97E+01 4.00E+01
1.26E+03 4.03E+01 4.00E+01
1.58E+03 3.64E+01 4.00E+01
Page 5
Data
1.58E+01
Page 6
90
85
80
Sound Level dB (RMS)
75
70
65
60
55
50
Frequency (Hz)
A Spec
Averages: 8 Window: Hanning A Peak: 65.041 dB (RMS) At: 15.85 Hz
Filename: C:\Data\SoundLevel3.txt Program: Exported by SC11 Spectrum Analyser 3.0 - Sensor 02016
Figure: 1 Time: 14:30 21-May-02