Test and Measurement Forum

Copy and paste measurements

Forum for discussing PicoScope (version 5)

Copy and paste measurements

Postby arielmedina61 » Fri Mar 10, 2006 7:32 pm

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
arielmedina61
Super User
Super User
 
Posts: 21
Joined: Fri Sep 23, 2005 1:17 pm
Location: Buenos Aires-Argentina

Postby Michael » Mon Mar 13, 2006 10:14 am

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
Michael
Zen Master
Zen Master
 
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire

Postby arielmedina61 » Tue Mar 14, 2006 1:03 pm

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.
arielmedina61
Super User
Super User
 
Posts: 21
Joined: Fri Sep 23, 2005 1:17 pm
Location: Buenos Aires-Argentina

Postby Michael » Tue Mar 14, 2006 4:37 pm

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
Michael
Zen Master
Zen Master
 
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire

Postby arielmedina61 » Tue Mar 14, 2006 8:28 pm

Hi, Michael!

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


thanks.

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

Postby Michael » Wed Mar 15, 2006 10:02 am

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 284 times
Michael - Tech Support
Pico Technology
Web Support Forum
Michael
Zen Master
Zen Master
 
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire

Postby arielmedina61 » Wed Mar 15, 2006 2:26 pm

Thank you very much, Michael!

I ´m going to test the file.


Best regards,

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


Return to PicoScope 5

Who is online

Users browsing this forum: No registered users and 0 guests