X-Stream Operator’s Manual
WM-OM-E Rev I 11
Solutions ............................................................................................................................... 254
Examples .............................................................................................................................. 255
What is Excel? ...................................................................................................................... 260
What is Mathcad? ................................................................................................................. 260
What is MATLAB?................................................................................................................. 260
What is VBS?........................................................................................................................ 260
What can you do with a customized instrument? ................................................................. 262
Number of Samples................................................................................................... 263
Calling Excel From Your Instrument .......................................................................... 263
Calling Excel Directly from the Instrument............................................................................ 263
How to Select a Math Function Call...................................................................................... 263
How to Select a Parameter Function Call............................................................................. 264
The Excel Control Dialog ...................................................................................................... 264
Entering a File Name ............................................................................................................ 264
Organizing Excel sheets ....................................................................................................... 265
Scale Setting the Vertical Scale........................................................................................... 265
Trace Descriptors.................................................................................................................. 266
Multiple Inputs and Outputs .................................................................................................. 266
Simple Excel Example 2 ....................................................................................................... 269
Exponential Decay Time Constant Excel Parameter (Excel Example 1) ............................. 273
Gated Parameter Using Excel (Excel Example 2)................................................................ 276
How Does this Work? ........................................................................................................... 277
Correlation Excel Waveform Function (Excel Example 3).................................................... 277
Multiple Traces on One Grid (Excel Example 4) .................................................................. 279
Using a Surface Plot (Excel Example 5)............................................................................... 283
Writing VB Scripts...................................................................................................... 284
Types of Scripts in VBS ........................................................................................................284
Loading and Saving VBScripts ............................................................................................. 284
The default parameter function script: explanatory notes..................................................... 288
Scripting with VBScript.......................................................................................................... 289
Variable Types ...................................................................................................................... 289
Variable Names .................................................................................................................... 290
General usage ...................................................................................................................... 290
Arithmetic Operators ............................................................................................................. 291
Results of Calculations ......................................................................................................... 291
Order of Calculations ............................................................................................................ 292
VBS Controls ........................................................................................................................ 292