Sign in

username:

password:



Not a member?

Search hc11



Search tips

Subscribe to hc11



Ads

Discussion Groups

Discussion Groups | M68HC11 | Serial Transmission

Technical discussions about Freescale Microcontrollers: M68HC11. (Freescale Semiconductor is a Subsidiary of Motorola).

Serial Transmission - bal_gill21 - Dec 22 5:50:00 2004


Hi,
I have got 96 bytes of (temperature) data that I want to send
serially to my PC using the SCI. Is there a recommended program that
I can use on my PC to recieve the data via RS232 and then import it
to Excel or something to create a graph of the data.

Thanks

Bal






(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )


Re: Serial Transmission - Bob Smith - Dec 22 7:51:00 2004

Most terminal emulators have a file capture tool. Procomm is particularily
nice to work with.

If you want a direct-to-Excel interface, look into writing a "wedge" for it.

Bob Smith

--- Avoid computer viruses, Practice safe hex ---

-- Specializing in small, cost effective
embedded control systems --

http://www.smithmachineworks.com/embedprod.html Robert L. (Bob) Smith
Smith Machine Works, Inc.
9900 Lumlay Road
Richmond, VA 23236 804/745-2608
----- Original Message -----
From: "bal_gill21" <>
To: <>
Sent: Wednesday, December 22, 2004 5:50 AM
Subject: [m68HC11] Serial Transmission >
> Hi,
> I have got 96 bytes of (temperature) data that I want to send
> serially to my PC using the SCI. Is there a recommended program that
> I can use on my PC to recieve the data via RS232 and then import it
> to Excel or something to create a graph of the data.
>
> Thanks
>
> Bal >
>
> Yahoo! Groups Sponsor
>
> Get unlimited calls to
>
> U.S./Canada >
>
> --------------------------------------------------------------------------
------
> Yahoo! Groups Links
>
> a.. To




(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )

Re: Serial Transmission - bal_gill21 - Dec 22 7:58:00 2004


Whats a "wedge" ? --- In , "Bob Smith" <bobsmith5@v...> wrote:
> Most terminal emulators have a file capture tool. Procomm is
particularily
> nice to work with.
>
> If you want a direct-to-Excel interface, look into writing
a "wedge" for it.
>
> Bob Smith
>
> --- Avoid computer viruses, Practice safe hex ---
>
> -- Specializing in small, cost effective
> embedded control systems --
>
> http://www.smithmachineworks.com/embedprod.html > Robert L. (Bob) Smith
> Smith Machine Works, Inc.
> 9900 Lumlay Road
> Richmond, VA 23236 804/745-2608
>
> bobsmith5@v...
>
> ----- Original Message -----
> From: "bal_gill21" <bal_gill21@y...>
> To: <>
> Sent: Wednesday, December 22, 2004 5:50 AM
> Subject: [m68HC11] Serial Transmission > >
> > Hi,
> > I have got 96 bytes of (temperature) data that I want to send
> > serially to my PC using the SCI. Is there a recommended program
that
> > I can use on my PC to recieve the data via RS232 and then import
it
> > to Excel or something to create a graph of the data.
> >
> > Thanks
> >
> > Bal
> >
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > Get unlimited calls to
> >
> > U.S./Canada
> >
> >
> >
> >
> > ------------------------------------------------------------------
--------
> ------
> > Yahoo! Groups Links
> >
> > a.. To
> >
>






(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )

Re: Re: Serial Transmission - Jim Peterson - Dec 22 8:56:00 2004

<grin> it is s short iron clup used for hitting short, high shots from
sand rough, or close to the green....

In software terms it is an exit or trap routine that hooks itself at
some known address of a routine that has the desired data or event
information as an input parameter.

Jim

bal_gill21 wrote:

>Whats a "wedge" ? >--- In , "Bob Smith" <bobsmith5@v...> wrote: >>Most terminal emulators have a file capture tool. Procomm is
>>
>>
>particularily >>nice to work with.
>>
>>If you want a direct-to-Excel interface, look into writing
>>
>>
>a "wedge" for it. >> Bob Smith
>>
>>--- Avoid computer viruses, Practice safe hex ---
>>
>>-- Specializing in small, cost effective
>> embedded control systems --
>>
>>http://www.smithmachineworks.com/embedprod.html
>>
>>
>>Robert L. (Bob) Smith
>>Smith Machine Works, Inc.
>>9900 Lumlay Road
>>Richmond, VA 23236 804/745-2608
>>
>> bobsmith5@v...
>>
>>----- Original Message -----
>>From: "bal_gill21" <bal_gill21@y...>
>>To: <>
>>Sent: Wednesday, December 22, 2004 5:50 AM
>>Subject: [m68HC11] Serial Transmission
>>
>>
>>
>>
>>>Hi,
>>>I have got 96 bytes of (temperature) data that I want to send
>>>serially to my PC using the SCI. Is there a recommended program
>>>
>>>
>that >>>I can use on my PC to recieve the data via RS232 and then import
>>>
>>>
>it >>>to Excel or something to create a graph of the data.
>>>
>>>Thanks
>>>
>>>Bal
>>>
>>>
>>>
>>>
>>> Yahoo! Groups Sponsor
>>>
>>> Get unlimited calls to
>>>
>>> U.S./Canada
>>>
>>>
>>>
>>>
>>>------------------------------------------------------------------
>>>
>>>
>-------- >>------
>>
>>
>>>Yahoo! Groups Links
>>>
>>> a.. To >>>
>> >
>
>Yahoo! Groups Links
[Non-text portions of this message have been removed]



(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )

Re: Serial Transmission - Scott Grodevant - Dec 22 9:10:00 2004

Hi all and Bal,

You can send the data in CSV format, which is very easy to work with, and easily importable into Excel (including formulas). You simply put commas between numerical values in sequential columns and carriage returns at the end of each row. Strings are surrounded with double quotes.

For example:

12,13,14<cr>
"hello","this","is","text"<cr>
23.4<cr>

will import each entity into its own cell.

Best regards,
Scott bal_gill21 <> wrote:

Hi,
I have got 96 bytes of (temperature) data that I want to send
serially to my PC using the SCI. Is there a recommended program that
I can use on my PC to recieve the data via RS232 and then import it
to Excel or something to create a graph of the data.

Thanks

Bal

Yahoo! Groups Sponsor
Get unlimited calls to

U.S./Canada ---------------------------------
Yahoo! Groups Links

To
---------------------------------




(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )

Re: Re: Serial Transmission - Bob Smith - Dec 22 10:58:00 2004

A "wedge" is an Excel_ism for a user written program that can be magically
attached to an Excel spreadsheet (see the Excel documentation for the howto)
that will custom process your data or calculations.

They can be used, in addition to other purposes, to import/export data to
the spread sheet.

I have just exhausted my knowledge of the subject, you will have to find an
Excel expert for more information.

I normally perform the functions you desire by using the Excel data import
and "parse" tools available from the tool bar. Tip: have your MCU data
output through the SCI port in the necessary "comma and quote" delimited
format so that it will column separate when you import it. See the Excel
documentation for full information on acceptable data formats.

Yes, this does require manual operations on Excel, but you can write macros
to do most of the repetitive work.

Ho, ho, ho, and best wishes,

Bob Smith
--- Avoid computer viruses, Practice safe hex ---

-- Specializing in small, cost effective
embedded control systems --

http://www.smithmachineworks.com/embedprod.html Robert L. (Bob) Smith
Smith Machine Works, Inc.
9900 Lumlay Road
Richmond, VA 23236 804/745-2608
----- Original Message -----
From: "bal_gill21" <>
To: <>
Sent: Wednesday, December 22, 2004 7:58 AM
Subject: [m68HC11] Re: Serial Transmission >
> Whats a "wedge" ? > --- In , "Bob Smith" <bobsmith5@v...> wrote:
> > Most terminal emulators have a file capture tool. Procomm is
> particularily
> > nice to work with.
> >
> > If you want a direct-to-Excel interface, look into writing
> a "wedge" for it.
> >
> > Bob Smith
> >
> > --- Avoid computer viruses, Practice safe hex ---
> >
> > -- Specializing in small, cost effective
> > embedded control systems --
> >
> > http://www.smithmachineworks.com/embedprod.html
> >
> >
> > Robert L. (Bob) Smith
> > Smith Machine Works, Inc.
> > 9900 Lumlay Road
> > Richmond, VA 23236 804/745-2608
> >
> > bobsmith5@v...
> >
> > ----- Original Message -----
> > From: "bal_gill21" <bal_gill21@y...>
> > To: <>
> > Sent: Wednesday, December 22, 2004 5:50 AM
> > Subject: [m68HC11] Serial Transmission
> >
> >
> > >
> > > Hi,
> > > I have got 96 bytes of (temperature) data that I want to send
> > > serially to my PC using the SCI. Is there a recommended program
> that
> > > I can use on my PC to recieve the data via RS232 and then import
> it
> > > to Excel or something to create a graph of the data.
> > >
> > > Thanks
> > >
> > > Bal
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Sponsor
> > >
> > > Get unlimited calls to
> > >
> > > U.S./Canada
> > >
> > >
> > >
> > >
> > > ------------------------------------------------------------------
> --------
> > ------
> > > Yahoo! Groups Links
> > >
> > > a.. To
> > >
> > >
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT > --------------------------------------------------------------------------
------
> Yahoo! Groups Links
>
> a.. To



(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )

Re: Serial Transmission - PFC - Dec 23 6:00:00 2004

Seasons greetings to all,
I found the information provided on importing data to Excel very useful. As
a result I have made some quick notes for myself for future use as I am
bound to have forgotten how to do this when I require it. I have included
these quick notes below if anyone in interested. Importing data to Excel.

Data can be imported from a comma separated text file and refreshed at a
given schedule as follows.

Create a text file and save with the extension CSV , it is not essential to
have this extension it just ties in with the Excel file name format.

The file format should be as follows:

Commas after numbers, text is surrounded by quotes, carriage returns to
change row.
12,23,34,56,9

1,2,3,4,5,6,7

"This is good text"

1,6,8,9,33,0
See Excel help for additional information on CVS format.

In Excel enable the "external data" toolbar. (View, Toolbars, External data)

To import data, Data, Import external data, Import Data.

Set the format as appropriate.

Select the imported data and using the External data toolbar click on "Data
range properties". Select the refresh interval required.
PFC.
----- Original Message -----
From: "Scott Grodevant" <>
To: <>
Sent: Wednesday, December 22, 2004 2:10 PM
Subject: Re: [m68HC11] Serial Transmission >
> Hi all and Bal,
>
> You can send the data in CSV format, which is very easy to work with, and
easily importable into Excel (including formulas). You simply put commas
between numerical values in sequential columns and carriage returns at the
end of each row. Strings are surrounded with double quotes.
>
> For example:
>
> 12,13,14<cr>
> "hello","this","is","text"<cr>
> 23.4<cr>
>
> will import each entity into its own cell.
>
> Best regards,
> Scott > bal_gill21 <> wrote:
>
> Hi,
> I have got 96 bytes of (temperature) data that I want to send
> serially to my PC using the SCI. Is there a recommended program that
> I can use on my PC to recieve the data via RS232 and then import it
> to Excel or something to create a graph of the data.
>
> Thanks
>
> Bal >
>
> Yahoo! Groups Sponsor
> Get unlimited calls to
>
> U.S./Canada > ---------------------------------
> Yahoo! Groups Links
>
> To >
> --------------------------------- >
> Yahoo! Groups Links





(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )

Re: Serial Transmission - Mark Schultz - Dec 23 16:22:00 2004


Several people here have suggested that you have your program output
its data in comma-seperated format. I have no argument with
suggestions of this nature, and you should set up your program to do
this, if you can.

I thought it would be worth mentioning - in case it is not obvious -
that you will need to perform two operations on the 'raw' temperature
readings you get from the HC11 ADC before you can output them to the
SCI. These operations are:

1. Convert the 'raw' readings into standardized units (deg. C or deg.
F). Just how you do this will depend on what sort of temp. sensor
you are using and how it is interfaced to the HC11. If you are using
a linear type of temp. sensor, odds are you will be able to perform
this step with simple integer math.

2. Once you have a number that is representative of the temperature
reading, scaled for standard units, you will need to create a routine
that can take a number stored in a register or RAM location and from
this create/output a string that is the ASCII decimal representation
of this number. This may seem like a trivial operation (esp. to
those here who are old hands at writing such routines) but may seem
daunting to a beginner. Should you need help writing such a routine,
let me know and I'll give you some pointers.



(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )

Re: Re: Serial Transmission - PFC - Dec 29 6:51:00 2004

Just an observation on the message below.
If the raw data is sent to an Excel file from the HC11, all the
calculations can be done in on the PC, hence all the functions of Excel are
available and all the memory of the PC is also available.
This may be an easer way to generate the temperature values for people who
are not proficient in HC11 coding.

PFC. ----- Original Message -----
From: "Mark Schultz" <>
To: <>
Sent: Thursday, December 23, 2004 9:22 PM
Subject: [m68HC11] Re: Serial Transmission >
>
> Several people here have suggested that you have your program output
> its data in comma-seperated format. I have no argument with
> suggestions of this nature, and you should set up your program to do
> this, if you can.
>
> I thought it would be worth mentioning - in case it is not obvious -
> that you will need to perform two operations on the 'raw' temperature
> readings you get from the HC11 ADC before you can output them to the
> SCI. These operations are:
>
> 1. Convert the 'raw' readings into standardized units (deg. C or deg.
> F). Just how you do this will depend on what sort of temp. sensor
> you are using and how it is interfaced to the HC11. If you are using
> a linear type of temp. sensor, odds are you will be able to perform
> this step with simple integer math.
>
> 2. Once you have a number that is representative of the temperature
> reading, scaled for standard units, you will need to create a routine
> that can take a number stored in a register or RAM location and from
> this create/output a string that is the ASCII decimal representation
> of this number. This may seem like a trivial operation (esp. to
> those here who are old hands at writing such routines) but may seem
> daunting to a beginner. Should you need help writing such a routine,
> let me know and I'll give you some pointers. > Yahoo! Groups Links





(You need to be a member of hc11 -- send a blank email to hc11-subscribe@yahoogroups.com )