Copy and paste measurements

Forum for discussing PicoScope (version 5)
Post Reply
arielmedina61
Active User
Active User
Posts: 21
Joined: Fri Sep 23, 2005 1:17 pm
Location: Buenos Aires-Argentina
Contact:

Copy and paste measurements

Post by arielmedina61 »

Hi,
I want that the information (measurements) in the spreadsheet (.xls - Excel) to be updated automatically each time PicoScope collects new data, so I select Copy measurements and then Paste Link or Paste Special rather than Paste as this creates a DDE link between the applications.

This function works ok.
But when I make a math operation with this measurement data in excel spreadsheet does not work.

If I select Copy as text works successfully.

Could you advise how do it?

Thanks

Ariel

Michael
Advanced User
Advanced User
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire

Post by Michael »

Hello,

I am not sure how you would do this with Excel.

Try copying the measurement to another cell and performing the calculation there.

The other way would involve using the device directly with the device drivers.

Best regards,
Michael
Michael - Tech Support
Pico Technology
Web Support Forum

arielmedina61
Active User
Active User
Posts: 21
Joined: Fri Sep 23, 2005 1:17 pm
Location: Buenos Aires-Argentina
Contact:

Post by arielmedina61 »

Hello, Michael.
Thank you for your post.

If I copy the measurement to another cell and performing the calculation there, does not work. The cell shows an error #VALUE!. Please , could you verify?

Remember that I want to update automatically each time PicoScope collects new data. (DDE link).

Best regards,
Ariel.

Michael
Advanced User
Advanced User
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire

Post by Michael »

Hello,

You will need to create a Macro to pass this reading to another cell.

Create a loop to increment the cell rows and calculate your values from there.

Best regards,
Michael
Michael - Tech Support
Pico Technology
Web Support Forum

arielmedina61
Active User
Active User
Posts: 21
Joined: Fri Sep 23, 2005 1:17 pm
Location: Buenos Aires-Argentina
Contact:

Post by arielmedina61 »

Hi, Michael!

Sorry, I don´t know how to do this.
Could you send me a small example?


thanks.

Ariel

Michael
Advanced User
Advanced User
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire

Post by Michael »

Hello,

I have attached a simple spreadsheet with a DDE link to scope readings.

This spreadsheet calculates RMS volts from these measurements.

I cannot offer any more support than this.

Best regards,
Michael
Attachments
DDEWithRMSCalc.xls
(1.27 MiB) Downloaded 652 times
Michael - Tech Support
Pico Technology
Web Support Forum

arielmedina61
Active User
Active User
Posts: 21
Joined: Fri Sep 23, 2005 1:17 pm
Location: Buenos Aires-Argentina
Contact:

Post by arielmedina61 »

Thank you very much, Michael!

I ´m going to test the file.


Best regards,

Ariel

Post Reply