Connecting an electronic gage to SPC Express can be very simple. SPC Express allows sample information to come from:

• the keyboard,
• a serial communications port (1-6),
• a txt file (click for more info), or
• a DDE exchange.

SPC Express requires that each sample value received from a gage be contained within a data transmission from the gage. This data transmission (hereafter referred to as a "record") should be ASCII data and be terminated with a Carriage Return [CR]. Each record should contain one sample value and an optional ID field. The ID field may be used if readings will be sent that belong to different charateristics. In this way, various readings can be "routed" to the correct characteristic on the screen.

As each record is received by the computer, SPC Express looks for the sample value and puts that reading into the next empty sample field of a subgroup entry form that is in the "new" mode. If a Gage ID has been specified (see below) then the sample value will be place into that subgroup only if the Gage ID matches. As soon as the last sample for that subgroup is received, the subgroup is saved to disk and also charted if a graph for that charateristic is open on the screen.

THE BASICS:

• First go to the "Input Options" Tab on the Edit Characteristic screen.
• Set the Comm Port to 1, 2, 3, 4, 5 or 6.
• Be sure that the Baud Rate and Parity on the screen match your gage.
• Define where the sample value appears within the record from the gage.
• Define where the Gage ID (if any) appears within the record from the gage.

• Specify a Minimum and Maximum Record Length. This can be used to help verify that a valid gage transmission was received. (Use zeros to skip checking.)
• Specify a Formula to be performed on the incoming sample value. There are several math formulas and other functions that may be applied. For example:
  • *2.54 would take the reading that was received and multiply it by 2.54
  • MIN=1.2, MAX=1.4 would filter out gage readings that fell outside these limits. This is sometimes referred to as "reasonableness checking".
  • -[nnn] would subtract the contents of a traceability field named "nnn" from the incoming gage reading.
  • ##LotNumber##101A## would cause the value "101A" to be placed into the traceability field named "LotNumber". A record may contain traceability data or sample data but not both.
  • #P001 would use the incoming reading and also "Publish" it as Tag 001 so that other windows may use this value (used to perform inter-window math   Click for details ).
  • +{001} would add the value that had been "Published" as Tag 001 (used to perform inter-window math   Click for details ).
    Also, {00n:F} and {00n:L} for First and Last Readings.  For example: If Window 1 is using a Difference function and Window 2 is using an Average function, then the formula +{001:F} -{002:L} will add the FIRST reading of the series from Window 1's #D function, then it will subtract the LAST reading of the series from Window 2's #A function.
  • Other functions include:
    
    + - * / @ABS @MAXTRUE4 @MAX2 @SQR #Ann #Dnn #MINnn #MAXnn
    #G #T:ARCTANGENT #T:HYPOTENUSE ^2 ODD EVEN
    NETNEXTSG RATIONEXTSG RATIONEXTSGI
    NETPERCENTNEXTSG NETPERCENTNEXTSG1 NETPERCENTNEXTSG2
    NETPERCENTNEXTSG3 NETPERCENTNEXTSG4
    POPUP=WARN POPUP=DENY ALLOWVOIDS
    
    These are all explained in more detail in your User Manual and New Features Section.

EXAMPLE:

Let's say your data from your gage looks like this:

01 1.6125 inches DIA [CR]
12345678901234567890
(numbers above for ease of counting)

Starting from the left, count the number of characters and you will see that the sample value (1.6125) starts in byte position 4 and is 6 bytes long. Enter this information on the Input Options screen. The Gage ID (DIA) starts in byte position 18 and is 3 bytes long. So enter 18 for the GageID Starting Byte and set the GageID to DIA. Then only records containing the letters "DIA" will be accepted into this characteristic.

TROUBLESHOOTING:

1. If you're having trouble reading your gage, try running the MMS Communications Utility, MMSCOMM.EXE.   It is on your Start menu, under SPC Express for Windows.   This will let you try different baud rates, parity, etc. and see what the gage is sending.   There is a 'ruler' at the top of the Utility screen that will help you count how far over the Sample Value and GageID fields (if any) are.
2. In rare cases, the Comm Utility will be able to read your device but SPC Express won't.   If that is the case, check to see if your system has a file called MSCOMM32.OCX and that it is registered.   Download MSCOMM32.OCX (06/24/1998)   (Save in windows system folder and register using REGSVR32)
3. You can also enter TRACE=1 in the Formula field.   This will show you step-by-step how SPC Express is trying to handle your gage input.  
4. It is also a good idea to turn on "Show gage data on StatusBar" in the Global Preferences.

•   InterWindow Math   (Publish, Use, Chain, and Trigger)
  
•   Importing CSV Files from Excel
  
•   Download MSCOMM32.OCX (06/24/1998)   (Save in windows system folder and register using REGSVR32)