|
|
| Author |
Message |
arielmedina61
Super User
Joined: 23 Sep 2005
Posts: 20
Location: Buenos Aires-Argentina
|
 Posted: Fri Mar 10, 2006 7:32 pm Post subject: Copy and paste measurements |
 |
|
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
|
|
| Back to top |
|
 |
Michael
Guru
Joined: 07 Jul 2005
Posts: 93
Location: St Neots, Cambridgeshire
|
| Posted: Mon Mar 13, 2006 10:14 am Post subject: |
|
|
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
|
|
| Back to top |
|
|
arielmedina61
Super User
Joined: 23 Sep 2005
Posts: 20
Location: Buenos Aires-Argentina
|
| Posted: Tue Mar 14, 2006 1:03 pm Post subject: |
|
|
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.
|
|
| Back to top |
|
|
Michael
Guru
Joined: 07 Jul 2005
Posts: 93
Location: St Neots, Cambridgeshire
|
| Posted: Tue Mar 14, 2006 4:37 pm Post subject: |
|
|
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
|
|
| Back to top |
|
|
arielmedina61
Super User
Joined: 23 Sep 2005
Posts: 20
Location: Buenos Aires-Argentina
|
| Posted: Tue Mar 14, 2006 8:28 pm Post subject: |
|
|
Hi, Michael!
Sorry, I don´t know how to do this.
Could you send me a small example?
thanks.
Ariel
|
|
| Back to top |
|
|
Michael
Guru
Joined: 07 Jul 2005
Posts: 93
Location: St Neots, Cambridgeshire
|
| Posted: Wed Mar 15, 2006 10:02 am Post subject: |
|
|
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
| Description: |
|
Download |
| Filename: |
DDEWithRMSCalc.xls |
| Filesize: |
1.27 MB |
| Downloaded: |
128 Time(s) |
|
|
| Back to top |
|
|
arielmedina61
Super User
Joined: 23 Sep 2005
Posts: 20
Location: Buenos Aires-Argentina
|
| Posted: Wed Mar 15, 2006 2:26 pm Post subject: |
|
|
Thank you very much, Michael!
I ´m going to test the file.
Best regards,
Ariel
|
|
| Back to top |
|
|
|
Cart
Email