Cleverscope CS300 Reference Manual v2.11
Page 86 www.cleverscope.com ©Cleverscope 2004-2015
The minimum impedance at 0° phase, and the frequency at which it occurs.
13.7 Dynamic Data Exchange (DDE)
Cleverscope can send DDE messages to any application that can subscribe to DDE links and can embed live data
directly in Excel or Access or Open Office Calc.
Links are updated by default as real format numbers with 8 decimal digits.
Note: The Signal Information display must be visible for data to be sent via DDE.
13.7.1 Using DDE
DDE uses three values to specify the source (Remote Reference Formulas) : the Service name (which is
Cscope
),
the Topic name (which is
Info
) and the item name. For Excel a typical Remote Reference Formula might be
“=Cscope|Info!A_Freq” or for Open Office Calc =DDE(“Cscope”;”Info”;”A_Freq”). This example will display
the Frequency of Channel A in the spreadsheet cell.
Note Make sure Cleverscope is running before opening the spreadsheet.
On the Help menu, click About DDE Links for more detail.
You can copy and paste one of the already-defined Remote Reference Formulas directly from the help dialog
into your receiving application.
As the signal information can have the Maths Display as a source, derived maths values can be linked via the DC
or Marker X, Marker Y values.
Start the Cleverscope Application software.
Acquire the signals.
Open the Signal Information display.
Click Send DDE.
Open Excel.
Create a new worksheet.
In the worksheet name each row to identify the data to be out into the next cell in the row.
Go to the Help menu in the Cleverscope application software and click on About DDE Links.
From the lists of link Remote Reference Formulas select one that relates to the data row in the Excel
spreadsheet.
Copy and paste from the Help menu into the cell in Excel.
The cell in Excel should be displaying the signal data from the selected channel.
Note: Item names are preceded by either A_ or B_ to define which channel is being used. Marker 1 is A_ and
Marker 2 is B_.
Note The following list of data link Remote Reference Formulas are formatted for Microsoft Excel. Other
applications may use different formatting rules.
e.g =DDE(“Cscope”;”Info”;”A_Freq”) for Cpen Office.
Time Information
=Cscope|Info!A_V_DC
=Cscope|Info!A_V_RMS
=Cscope|Info!A_V_Max
=Cscope|Info!A_V_Min
=Cscope|Info!A_Pk_Pk
=Cscope|Info!A_Std_Dev
=Cscope|Info!A_Period
=Cscope|Info!A_Freq
=Cscope|Info!A_Amplitude
=Cscope|Info!A_Pulse_Len
=Cscope|Info!A_Duty_Cycle
=Cscope|Info!A_VMarkerT
=Cscope|Info!A_VMarkerV
Spectrum Information
=Cscope|Info!A_F_DC
=Cscope|Info!A_F_RMS
=Cscope|Info!A_Fsignal
=Cscope|Info!A_Vsignal
=Cscope|Info!A_HF1
=Cscope|Info!A_HV1
=Cscope|Info!A_HF2
=Cscope|Info!A_HV2
=Cscope|Info!A_HF3
=Cscope|Info!A_HV3
=Cscope|Info!A_Sinad
=Cscope|Info!A_THD
=Cscope|Info!A_HV2_HV3
=Cscope|Info!A_FMarkerF
Examples:
=Cscope|Info!A_V_DC
=Cscope|Info!B_HF1
=Cscope|Info!A_VMarkerV
=Cscope|Info!B_FMarkerF
Display A channel DC volts
Display B fundamental frequency
Display Marker 1 volts
Display Marker 2 frequency
To Next Page
Loading...