A discussion group for the PICMicro microcontroller. Also called the Microchip PIC, this list is dedicated to the use and abuse of this fine, simple, microcontroller. Close to topic posts are welcome, ie. general electronics.
|
Hi folks Have a pic based data logger, it outputs a text string. I neend some help to make a windows or excel based program to display the data in a useable format. If anyone can help or point me in the right direction I would be most grateful. Thanks Dave |
|
|
|
Depends on what protocol the output from the data logger is; if RS232 then it is fairly easy to capture the data. Look at VBA examples for Excel or MScomm examples in VB. If it is a different format (CAN, RS485 etc..) you can get a converter to go from that format to RS232 and read it in that way. Madhu -----Original Message----- Hi folks Have a pic based data logger, it outputs a text string. I neend some help to make a windows or excel based program to display the data in a useable format. If anyone can help or point me in the right direction I would be most grateful. Thanks Dave |
|
|
|
Thanks I can capture the data no problem (RS232) what I need to do is get some software to display it. At the moment I have to inport it to excel, average the first 10 or so samples, subtract this average form the data stream then graph it. There must be an easier way..... Dave > Depends on what protocol the output from the data logger is; if RS232 then > it is fairly easy to capture the data. Look at VBA examples for Excel or > MScomm examples in VB. If it is a different format (CAN, RS485 etc..) you > can get a converter to go from that format to RS232 and read it in that way. > Madhu > > -----Original Message----- > Hi folks > Have a pic based data logger, it outputs a text string. I neend some > help to make a windows or excel based program to display the data in > a useable format. > If anyone can help or point me in the right direction I would be most > grateful. > Thanks Dave |
|
|
|
How about LabView if you don't want to roll your own VBA code? Madhu -----Original Message----- From: kartnz [mailto:] Sent: Monday, August 04, 2003 5:22 PM To: Subject: [piclist] Re: Software help Thanks I can capture the data no problem (RS232) what I need to do is get some software to display it. At the moment I have to inport it to excel, average the first 10 or so samples, subtract this average form the data stream then graph it. There must be an easier way..... Dave > Depends on what protocol the output from the data logger is; if RS232 then > it is fairly easy to capture the data. Look at VBA examples for Excel or > MScomm examples in VB. If it is a different format (CAN, RS485 etc..) you > can get a converter to go from that format to RS232 and read it in that way. > Madhu > > -----Original Message----- > Hi folks > Have a pic based data logger, it outputs a text string. I neend some > help to make a windows or excel based program to display the data in > a useable format. > If anyone can help or point me in the right direction I would be most > grateful. > Thanks Dave to unsubscribe, go to http://www.yahoogroups.com and follow the instructions |
|
|
|
Madhu I don't know much about software programming, would you be keen to help with my project? Can email a sample of the data stream for you to look at if you are willing to help. Thanks Dave > How about LabView if you don't want to roll your own VBA code? > Madhu > > -----Original Message----- > From: kartnz [mailto:davelowe@w...] > Sent: Monday, August 04, 2003 5:22 PM > To: > Subject: [piclist] Re: Software help > Thanks > I can capture the data no problem (RS232) what I need to do is get > some software to display it. > At the moment I have to inport it to excel, average the first 10 or > so samples, subtract this average form the data stream then graph it. > There must be an easier way..... > > Dave > > > Depends on what protocol the output from the data logger is; if > RS232 then > > it is fairly easy to capture the data. Look at VBA examples for > Excel or > > MScomm examples in VB. If it is a different format (CAN, RS485 > etc..) you > > can get a converter to go from that format to RS232 and read it in > that way. > > Madhu > > > > -----Original Message----- > > Hi folks > > Have a pic based data logger, it outputs a text string. I neend some > > help to make a windows or excel based program to display the data in > > a useable format. > > If anyone can help or point me in the right direction I would be > most > > grateful. > > Thanks Dave > > to unsubscribe, go to http://www.yahoogroups.com and follow the instructions |
|
|
|
Are you looking for a way to speed up what you do in Excel? If so you can do this using Excel Macros (you can do the import, average, display using a single or a group of macros). If on the other hand you are looking for a stand-alone application that can do what you are doing in Excel then I am afraid you will have to get into programming (I am sorry but I am swamped at work and it will be a while before I can put together a program for you). Madhu -----Original Message----- Madhu I don't know much about software programming, would you be keen to help with my project? Can email a sample of the data stream for you to look at if you are willing to help. Thanks Dave > How about LabView if you don't want to roll your own VBA code? > Madhu > I can capture the data no problem (RS232) what I need to do is get > some software to display it. > At the moment I have to inport it to excel, average the first 10 or > so samples, subtract this average form the data stream then graph it. > There must be an easier way..... > Dave > > > Depends on what protocol the output from the data logger is; if > RS232 then > > it is fairly easy to capture the data. Look at VBA examples for > Excel or > > MScomm examples in VB. If it is a different format (CAN, RS485 > etc..) you > > can get a converter to go from that format to RS232 and read it in > that way. > > Madhu > > > > -----Original Message----- > > Hi folks > > Have a pic based data logger, it outputs a text string. I neend some > > help to make a windows or excel based program to display the data in > > a useable format. > > If anyone can help or point me in the right direction I would be > most > > grateful. > > Thanks Dave |