It is currently Thu Jun 22, 2017 4:41 pm

All times are UTC




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: K8055 Excel Project
PostPosted: Wed May 17, 2017 11:11 am 
Offline
Member
Member

Joined: Wed May 17, 2017 10:42 am
Posts: 3
Hello,

I am working on an Excel project using the K8055 USB Experiment Interface Board. My understanding of the device and of Visual Basic, however, is quite limited and so any help that could be offered would be greatly appreciated.

The kit has been assembled and I am able to successfully run the demo software provided.

What I require is very simple functionality, whereby the Excel spreadsheet will receive data being provided by an analogue input device.

The device will offer new data approximately once a minute and all I require is for this data to be listed in order of receipt. The data will take the form of a single number ranging from 0 to 100000 or more.

Is anybody able to provide me with a basic example to get me started?

Many thanks.


Top
 Profile  
 
 Post subject: Re: K8055 Excel Project
PostPosted: Wed May 17, 2017 2:45 pm 
Offline
User avatar
Velleman Support
Velleman Support

Joined: Mon Dec 11, 2006 12:03 pm
Posts: 4918
Location: Belgium
Please see this thread: viewtopic.php?f=3&t=4426&start=0
There is a link to download an Excel spreadsheet application who reads the analog inputs once a minute and displays the results on the sheet.


Top
 Profile  
 
 Post subject: Re: K8055 Excel Project
PostPosted: Wed May 17, 2017 3:06 pm 
Offline
Member
Member

Joined: Wed May 17, 2017 10:42 am
Posts: 3
Thanks for pointing me in the right direction. I'll look into this solution.


Top
 Profile  
 
 Post subject: Re: K8055 Excel Project
PostPosted: Wed May 24, 2017 10:55 am 
Offline
Member
Member

Joined: Wed May 17, 2017 10:42 am
Posts: 3
The software provided is very similar to what I need and, with some adjustments, could be perfect.

I am unable to get the spreadsheet to receive the data, however. The card is connected, but the device only returns a 0. Do you have any ideas as to why this might be?

I know that the interface is set up correctly because it has been used successfully with the same device for another project. Unfortunately, I do not have access to that software or to the person who created it!


Top
 Profile  
 
 Post subject: Re: K8055 Excel Project
PostPosted: Wed May 24, 2017 3:09 pm 
Offline
User avatar
Velleman Support
Velleman Support

Joined: Mon Dec 11, 2006 12:03 pm
Posts: 4918
Location: Belgium
Quote:
I am unable to get the spreadsheet to receive the data, however.
You may try to test the K8055 card operation with Excel by following:
- Download the package "K8055N software pack" from this website: http://www.velleman.eu/support/download ... 055n&type=
- Extract the package.
- In the folder \Examples\K8055NDemoExcel there is K8055DemoExcel.xls
- Open it in Excel
- Click the "Open and Run" button
- Text "Card 0 Connected" should appear
- Analog input values are shown in cells B2 and B3
- Digital output value is incremented

This indicates that the connection between Excel and K8055(N) is working properly.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group