Test and Measurement Forum

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

Post your VB and VBA discussions here

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

Postby NathanUnger » Tue May 13, 2008 5:18 am

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.
Posts: 2
Joined: Wed Sep 27, 2006 9:51 am

Postby picojohn » Tue May 13, 2008 9:21 am

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. ?

Zen Master
Zen Master
Posts: 382
Joined: Mon Jun 11, 2007 1:10 pm

Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests