Test and Measurement Forum

ADC-11 real time to Excel

Post your VB and VBA discussions here

ADC-11 real time to Excel

Postby Sidney » Sun Apr 22, 2007 8:25 am

Hi
I currenttly use ADC-11 to collect the voltage chnage for new product, and now I try to purchase another one for other project, but before I go for it I hope you guys may help me to clear out some my confusing.

my question is:
if I can get real-time graphic on Excel throught ADC-11?
I can see real-time data change on adc-11 data logger but can I also get real-time data change on excel without press record?

Thank you :D
Sidney
User
User
 
Posts: 4
Joined: Sun Apr 22, 2007 8:00 am

Postby ziko » Mon Apr 23, 2007 8:32 am

Hi and thank you for your email, if you do a custom installation you can choose to install the programming examples. If you have not done so, re-install the software, choose modify and select the programming examples.

By default the programming examples in excel for the Parallel ADC11 and USB ADC11 are located in:

C:\Program Files\Pico Technology\Pico Full\Examples\ADC11


Hope this answers your question.

Kind regards
Ziko

Technical Specialist
ziko
Zen Master
Zen Master
 
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots

Postby Sidney » Tue Apr 24, 2007 3:09 am

I did install example but seems still not working now, I can't get any number out through adc-11 to excell the only thing I get is 0 value... but my major question is "can I monitor real-time value on excel same as I see on picolog recorder without press record on picolog recorder?"
soory I am kind newbie for this..
Sidney
User
User
 
Posts: 4
Joined: Sun Apr 22, 2007 8:00 am

Postby ziko » Tue Apr 24, 2007 8:30 am

Hi,

In PicoLog when you set your sample rate, your data is collected at those intervals, you can achieve the same using the macros.

There are two ADC11 excel files, one for the USB ported device, usbadc11.xls and one for the parallel ported product adc1132.xls. Do you have a parallel ported or USB ADC11 and which of the excel files did you use?

Let me know how you get on.
Ziko

Technical Specialist
ziko
Zen Master
Zen Master
 
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots

Postby Sidney » Mon Apr 30, 2007 5:36 am

Hi
I try the Example parallel files today and single channel is working prefect but when I try to use mutiple channels to pick up the ample from ADC-11 seems not working more than three channel..
what I did is
I only use terminal resistor one the terminla so channel 5 is only channel I use. then I add one more channel on the original example but seems I can't get channel 5 sample on spreadsheet. and I did change couple of value on the original marco.. but there is something I don't understand

1.Call adc11_set_trigger(True, True, 1000, 10, False, 512, 0). what is that 10 mean? Original example only use two channels but why it is 10 ?

2. ' Say that we want to take 100 readings in 20000us
' from channels 1 and 3
channels(0) = 1
channels(1) = 3
Call adc11_set_interval(10000, 100, channels(0), 2)
If take reading from 1 and 3 why only call channels(0) only?

3. For i = 0 To 99
Cells(i + 4, "A").value = times(i)
Cells(i + 4, "B").value = adc_to_mv(values(2 * i))
Cells(i + 4, "C").value = adc_to_mv(values(2 * i + 1))
Where is i from? I didn’t see anywhere declare i ? and on the second line only use (values(2*i) but why on the third line need add+1

4. To make things simple, if I want to have 5 channels, where should I add/change in the original marco?

thank you
Sidney
User
User
 
Posts: 4
Joined: Sun Apr 22, 2007 8:00 am

Postby ziko » Wed May 02, 2007 10:13 am

Hi,

What the code is doing as the manual shows, it is triggering of channel 10, but measuring channels 1 & 3, so to answer your question in full:


1. Triggering off channel 10 to start the measurements


2." ...If take reading from 1 and 3 why only call channels(0) only?"
This is the address of an array, listing the channels to
be used (so it has channel 1 and 3 included in it)

3. You do not have to explicitly declare the variable, the first time it is called it is declared automatically.

The values are stored in an interleaved fashion, so location i is for channel 1 and location i+1 is for channel 3.

4. If you wanted to measure just channel 5 you would need to make the following amendments:

change channels(0) to = 5 rather than 1
remove channels(1) = 3

Change the last parameter to 1 rather then (since you are only measuring one channel)

Call adc11_set_interval(10000, 100, channels(0), 1)

In the for loop remove the line below , since you are only measuring one channel.

Cells(i + 4, "C").value = adc_to_mv(values(2 * i + 1))


Hope this helps.

Kind regards
Ziko

Technical Specialist
ziko
Zen Master
Zen Master
 
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots

Postby Sidney » Thu May 03, 2007 6:41 am

Hi
actually I am talking about 5 channels not just single one channel, anyway I clear out my confusion and I already figure out for 10 channels already.

Many thank you

Sidney
Sidney
User
User
 
Posts: 4
Joined: Sun Apr 22, 2007 8:00 am

Postby ziko » Thu May 03, 2007 8:38 am

Hi, yeah sorry I misread the last bit.

Well its good to know that its all working now.

Kind regards

Ziko
Ziko

Technical Specialist
ziko
Zen Master
Zen Master
 
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots


Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: sscthj89 and 0 guests