# cursor values into excell

**Cursor values into excell**, a forum discussion on Cleverscope Mixed Signal USB Oscilloscopes. Join us for more discussions on

*Cursor values into excell*on our Interesting Questions forum.

Back to Forum Index : Back to Interesting Questions |

**bnevins**

10 Sep 2015

Posts: 21

Is there an easy way to get the cursor values into excel?

I am using the cursors on the maths graph. I need to take several values to

average the noise power. I would like successive values of the "dv" (cursor 1 - cursor 2) to appear in

a spread sheet column.

Since I am using the exponential average, the samples are not independent of each other.

The exponential average can have a new value every time an FFT is finished. However, it will be highly correlated to the previous average since the decay rate of samples is small. Is there an easy way to know what the "decay" rate between successive displayed values is?

I am using the cursors on the maths graph. I need to take several values to

average the noise power. I would like successive values of the "dv" (cursor 1 - cursor 2) to appear in

a spread sheet column.

Since I am using the exponential average, the samples are not independent of each other.

The exponential average can have a new value every time an FFT is finished. However, it will be highly correlated to the previous average since the decay rate of samples is small. Is there an easy way to know what the "decay" rate between successive displayed values is?

**bartschroder**

16 Jan 2016

Posts: 466

Hello,

Yes you can use the Signal Information to log values as seen by the markers. If you place the markers on the part of the signal you want to save, you can select Marker Y to show the amplitude under the Marker, and Marker X to show the X axis value. Marker 1 maps to Chan A and Marker 2 maps to Chan B. Note that the markers can be on any channels. Make sure you have set the Information Source to Maths.

I hope this helps.

The decay rate is set by the Exponential Averaging count. This acts as an RC delay delay. Let N = Number of Averages, then we calculate

New Average = [New Value + (N-1) Old Value]/N, allowing you to calculate the difference.

Yes you can use the Signal Information to log values as seen by the markers. If you place the markers on the part of the signal you want to save, you can select Marker Y to show the amplitude under the Marker, and Marker X to show the X axis value. Marker 1 maps to Chan A and Marker 2 maps to Chan B. Note that the markers can be on any channels. Make sure you have set the Information Source to Maths.

I hope this helps.

The decay rate is set by the Exponential Averaging count. This acts as an RC delay delay. Let N = Number of Averages, then we calculate

New Average = [New Value + (N-1) Old Value]/N, allowing you to calculate the difference.

**bartschroder**

2 Aug 2017

Posts: 466

You are correct, the updated exponential average is dependent on both the past accumulation and the new value. Can you please explain what the problem is here?

The decay rate is set in the Settings/Averaging dialog with the value 'Number of averages'. As explained above

New Average = [New Value + (N-1) Old Value]/N

The decay rate is set in the Settings/Averaging dialog with the value 'Number of averages'. As explained above

New Average = [New Value + (N-1) Old Value]/N

Back to Forum Index : Back to Interesting Questions |