Check out the article in October 2002 issue of Nuts and Volts -- "Simple
Interface Uses Common Tools".

There also is free software available on the web site at
www.nutsvolts.com
To get your data into Excel.  This is at
http://emergingtech-llc.com/downloads.htmland is called InByte.

That should help.

Good Luck
Steve Smith
Electrical Engineer


-----Original Message-----
From: pic microcontroller discussion list
[mailto:PICLIST@MITVMA.MIT.EDU] On Behalf Of Robert Rolf
Sent: Monday, October 07, 2002 7:11 AM
To: PICLIST@MITVMA.MIT.EDU
Subject: Re: [OT]: Plotting RS232 data

Diego, did you try using the 'new' version of RS232 scope? (Which is VB
code,
not Excel).
His web page says that he forgot to include a DLL. I haven't tried it
yet, but if it's been fixed you should be able to get your real time
data.

OOPS. In reading the web page, it would seem that RS232 scope
requires that your number be surrounded by a frame header: "TX" and
"/T".

You may also need to tie the handshaking line together on the serial
port since the author of RS232 may not have disabled them in the
'open port' command. Typically you tie RTS to CTS and DTR to DSR & CD
if you're only using a 3 wire interface.

R
=========================
http://www.electronic-engineering.ch/microchip/software/scope.html
RS232 Scope V1.02     (Excel 97 Worksheet)  178 kb ScopeV102.zip

Note: In the previous version I forgot to add one DLL file (because they
have
all more or less the same names). So it couldn't work at all. Sorry
guys.


Claudio Tagliola wrote:
>
> If it's an whatever delimited ascii string, do the following:
>
> Capture to file with HyperTerm, open Excel, import object, use file,
select
> ascii dump. Now, create the graph you want, let it refresh every 60
seconds
> or so and off you go. Not real time cause there are two buffers in the
> system, but works well on the long run. Just fiddle around with Excel,
you
> can do a lot of neat tricks there.
>
> Regards,
> Claudio
>
> -----Oorspronkelijk bericht-----
> Van: pic microcontroller discussion list
> [mailto:PICLIST@MITVMA.MIT.EDU]Namens Diego Sierra
> Verzonden: donderdag 3 oktober 2002 23:43
> Aan: PICLIST@MITVMA.MIT.EDU
> Onderwerp: [OT]: Plotting RS232 data
>
> Hi!
>
> I would like to plot in a graph the real-time data I receive via the
PC
> serial port. I tried to use windmill software (www.windmill.co.uk)
with no
> success (it lost 8 from 10 values). And also an excel program
(RS232Scope),
> this one said it doesn't receive anything from the port. ?Is there
another
> free and easy tool to do that?
>
> The data received at the serial port is just a number and a newline,
every
> second more or less.
>
> Cheers,
> Diego.

--
http://www.piclist.com#nomail Going offline? Don't AutoReply us!
email listserv@mitvma.mit.edu with SET PICList DIGEST in the body

--
http://www.piclist.com#nomail Going offline? Don't AutoReply us!
email listserv@mitvma.mit.edu with SET PICList DIGEST in the body