Search the web
Sign In
New User? Sign Up
ultimaserial_group · UltimaSerial Users
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Pls come in Help need   Message List  
Reply | Forward Message #532 of 794 |
Re: Pls come in Help need

This line sends the all the data (count) to Excel sheet

oSheet.Range("A3").Resize(Val(Text1.Text),
UltimaSerial.ChannelCount).Value = oExcel.Worksheetfunction.Transpose(v)

If you don't want to send the raw data, you will need to extract the
data from the variant V first (see
http://www.ultimaserial.com/standard.html#GetData), perform the
conversion according to the spec of the sensor/gain, then use
something like

For i = 0 To UltimaSerial.ChannelCount - 1
oSheet.Range(Chr$(Asc("A") + i) + "1").Value = ...
Next

To fill the cells in the sheet

Or, you can create a new column and use the built-in feature of Excel
to perform the conversion

--- In ultimaserial_group@yahoogroups.com, "vr_man02" <vr_man02@...>
wrote:
>
> sorry dont mind i ask u how to put the format in the code dat i posted
> (1st post) so that it will show uV and Degree in excel? i keep looking
> in google n yahoo but i cant find it..im jam here..pls
>








Wed Sep 13, 2006 6:22 pm

ultimaserial
Offline Offline

Forward
Message #532 of 794 |
Expand Messages Author Sort by Date

I was introduce to this group Hi im new here,i would like u guys to help me out..Real thx Im trying to create a VB program. basically my DATAQ (Dl-710) was...
vr_man02
Offline Send Email
Sep 12, 2006
2:10 am

To convert count to volt Count*Fullscale_at_the_gain/32768 From volt, you can convert to degree according to your sensor's spec...
ultimaserial
Offline
Sep 12, 2006
11:28 am

thx..yup i noe the format to get count to voltage and count to degree..but in the codes i provided in the earlier post where should i put the format so to get...
vr_man02
Offline Send Email
Sep 13, 2006
1:11 am

These two lines send the data to lables, not to the sheet in Excel, I think a VB book, along with google, will be very helpful for you Good luck! ... should i...
ultimaserial
Offline
Sep 13, 2006
1:40 am

sorry dont mind i ask u how to put the format in the code dat i posted (1st post) so that it will show uV and Degree in excel? i keep looking in google n yahoo...
vr_man02
Offline Send Email
Sep 13, 2006
1:59 am

Once you place the counts in a column, can't you create new columns in Excel with the conversion equations embeded in to convert counts to uV or degree?...
xchen992000
Offline
Sep 13, 2006
11:46 am

This line sends the all the data (count) to Excel sheet oSheet.Range("A3").Resize(Val(Text1.Text), UltimaSerial.ChannelCount).Value =...
ultimaserial
Offline
Sep 13, 2006
6:25 pm

hi i added my full program to you at this link: http://tech.groups.yahoo.com/group/ultimaserial_group/files btw i keep on trying upgrading the program but...
vr_man02
Offline Send Email
Sep 14, 2006
1:51 am

If you are new to VB programming, and you've got the counts into the spreadsheet successfully, I strongly suggest creating a new column in Excel and let Excel...
ultimaserial
Offline
Sep 14, 2006
12:28 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help