can the excel 'paste as link' command show both channels?

 
Post new topic   Reply to topic    Pico Technology Forum Index -> VB and VBA (Excel, Access)
Author Message
NathanUnger
User
User


Joined: 27 Sep 2006
Posts: 4

PostPosted: Tue May 13, 2008 5:18 am    Post subject: can the excel 'paste as link' command show both channels? Reply with quote
I have a picoscope 3223, and wanted to use it to calculate values based on variables from both channels. For example, if I measure voltage on ch A, and have an amp probe on ch B, then I would like to know what the wattage of the device under test is. Ch A volts X Ch B amps = watts.
I tried the paste as link command, but it only gave me channel A in Excel as live data. How do I get it to show Channel B live data at the same time? If I could, then I could simply use an Excel cell formula to derive my calculated result at a specified time.

Is this possible? Or is there another way to achieve this? I think it only works in software version 5.
Back to top
picojohn
Site Admin
Site Admin


Joined: 11 Jun 2007
Posts: 365

PostPosted: Tue May 13, 2008 9:21 am    Post subject: Reply with quote
Hello Nathan,

As you have noted, what you wish to achieve is possible with PS5 but not PS6.

Two options that you may wish to consider are:

1. Write your own application software

2. use PicoLog application software (http://www.picotech.com/data-logging-software.html)

Presumably, the power that you wish to determine is d.c. ?

Regards
John
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> VB and VBA (Excel, Access)
All times are GMT
Page 1 of 1

 


Pico Technology topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group