You have to send each value from the pic "like" this:

[assuming your data on the pic is right justified]

Send_232( hex_to_ascii( upper_byte & 0x03 ) );	// send upper 2 bits MSB
Send_232( hex_to_ascii(   lower_byte>>4   ) );	// Send mid 4 bits
Send_232( hex_to_ascii( lower_byte & 0x0F ) );	// send lower 4 bits LSB

Send_232( /n );	// new line
Send_232( /r );	// return of carriage (cursor actually)

So you'll end up having something like

125
245
2a4
2b6
Etc
Etc
Etc

Hex to accii must conver a 0~15 value to its corresponding ASCCII (48, 49...
Etc)

Then, capture that with any terminal software and import to excell. It will
open up as a column with data.

The you must use a built in function called HEX2DEC( "source" ) I don't
recall if it has more params.

If excell doesn't recognize the function you might have to add it. Go to
TOOLS> ADD-Ins
Add "solver.." and "analisys..."

Best regards,


Mauricio Jancic
Janso Desarrollos - Microchip Consultants Program Member
info@janso.com.ar
www.janso.com.ar
(54) 11 - 4542 - 3519
 

> -----Original Message-----
> From: piclist-bounces@mit.edu 
> [mailto:piclist-bounces@mit.edu] On Behalf Of wayne
> Sent: Monday, May 16, 2005 7:18 PM
> To: 'Microcontroller discussion list - Public.'
> Subject: RE: [OT] Can this be done in excel?
> 
> Hex2dec.... I think you need the maths library pluging thingy
> 
> Wayne Allen
> Director E-Stim Systems
> http://www.e-stim.co.uk
> wayne@e-stim.co.uk
> 
> 
> -----Original Message-----
> From: piclist-bounces@mit.edu 
> [mailto:piclist-bounces@mit.edu] On Behalf Of alan smith
> Sent: 16 May 2005 23:07
> To: Microcontroller discussion list - Public.
> Subject: [OT] Can this be done in excel?
> 
> Gathering data...by hand right now at least....a data packet 
> from the PIC, representing the 10bit AD values.
>  Would be nice for something to dump right into excel...
> 
> 
> So ive got it left justified, high byte being the upper 8 
> bits and low byte upper two bits being the lowest two 
> bits...that made sense right?
> 
> Say we have the value 0x79C0, I want to have excel strip off 
> the lower 6 bits and convert to decimal. 
> And so I get the final result of 487.  Is there a simple way 
> in excel to do this?
> 
> 
> 		
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone. 
> http://mobile.yahoo.com/learn/mail
> --
> http://www.piclist.com PIC/SX FAQ & list archive View/change 
> your membership options at 
> http://mailman.mit.edu/mailman/listinfo/piclist
> 
> -- 
> http://www.piclist.com PIC/SX FAQ & list archive
> View/change your membership options at
> http://mailman.mit.edu/mailman/listinfo/piclist
> 

-- 
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist