<div>
What is the resolution of your sine wave? &nbsp;And what is the format of your data? 
 
Your data format is not the same as the serial port configuration: 8 bit, odd, 2 bit of stop. 
 
You have to know how the data is encoded: &nbsp;number of characters per sample, twos complement or offset binary representation, volts per bit scaling, and so on. &nbsp; 
 
I have done this sort of conversion with Python in real time, but I did not have to operate at 115 kbps. &nbsp;You can probably do it in Excel as well, but not in real time.
</div>

<div>
The microcontroller is on 16bit. 
The data x rolls over as follows: -32768 is -Pi, 32767 is +0.999969482421875*Pi. 
Then y=sin(x) and that y is sent to UART as low byte first and high byte afterwards.
</div>

<div>
Did you write the uC program? &nbsp; 
What is the sampling rate? 
Is y also a 16-bit value? 
 
Presumably there are gaps between your 2-byte samples. &nbsp;Otherwise you would have trouble determining where the boundaries are between pairs. 
 
If you save the data in HEX format, you should be able to convert it with Excel. &nbsp;ASCII is not useful. 
You have one sign bit and a 15-bit magnitude. &nbsp; 
 
But there are at least three possibilities for the format: signed binary, offset binary, and twos complement. &nbsp;Conversions between them are pretty simple.
</div>

<div>
The code is not written by me, I found it online and I try to understand it. 
I programmed the PIC and I can see the data on PC. I arrive only to that point. 
The XC16 code project file for MPLABX and raw data are attached. The raw data is not captured by me and the author forgot how he captured it. 
I am able to see that raw data in Audacity for example. 
But I am interested to find out how can I capture it by myself. 
<a href="http://www.microchip.com/forums/download.axd?file=0;790718" rel="ugc">www.microchip.com/forums/download.axd?file=0;790718</a> 
<a href="http://www.microchip.com/forums/download.axd?file=2;790718" rel="ugc">www.microchip.com/forums/download.axd?file=2;790718</a>
</div>

<div>
I used RealTerm to visualize and capture data: 
<a href="https://sourceforge.net/projects/realterm/" rel="ugc">https://sourceforge.net/projects/realterm/</a> 
Then also RS232 Data Logger from Eltima, the freeware version: 
<a href="https://sourceforge.net/projects/rs232portlogger/" rel="ugc">https://sourceforge.net/projects/rs232portlogger/</a> 
 
Here are the screenshots video recordings and the captured data: 
<a href="https://goo.gl/YIIjQD" rel="ugc">https://goo.gl/YIIjQD</a> 
 
Then I have tried some trial version of Device Monitoring Studio and Advanced Serial Data Logger: 
<a href="https://www.hhdsoftware.com/device-monitoring-studio" rel="ugc">https://www.hhdsoftware.com/device-monitoring-studio</a> 
<a href="https://www.aggsoft.com/asdl-rs232-to-excel.htm" rel="ugc">https://www.aggsoft.com/asdl-rs232-to-excel.htm</a> 
Or simple Tera Term: 
<a href="https://ttssh2.osdn.jp/index.html.en" rel="ugc">https://ttssh2.osdn.jp/index.html.en</a>&nbsp; 
The data is saved in a .txt or .log file or any other specific file, attached you may see the .txt captured files. 
The PIC sends continuous in a loop. 
 
As you can see above, I have no problem to capture the data, even though I do not know if I capture all or enough packages. 
My problem is to see/get/convert the data correctly, because the data comes in packages of 8bit and 1 data sample for sine wave is 16bit. That means I have to remake 1 sample by putting together, by concatenate 2 byte. That 1 sample is 1 point of the sine wave. 
These data loggers/captures will store in a file either continuously data without any delimitation between packages as I see in HEX file from RealTerm or 1 byte as ASCII string. 
I do not know how I should convert that in a usable number, 2 byte together, to get the points of the sine. It is just a conversion problem or perhaps setting of the capture serial software. 
I would like to have in captured file the same as I see on the RealTerm screen terminal when I set in16 and 2 byte for one frame, then I think I see the correct usable numbers. Then as second part, would be even more interesting to know how the author arrived to that .raw file which I am able to see in Audacity. 
So, how do I convert what I capture at serial port in a usable format?
</div>

<div>
I have sorted out. Here is what I have done: 
- Used RealTerm, set up the serial port as 115200 baud rate, 8bit of data, odd, 2bit stop, then on Display int16, then went to Capture, set to capture in capture.txt for 60s, but not as HEX. 
- Then in Audacity I just went to Import Raw Data, Signed 16bit PCM, Little-endian, 1 Channel Mono, Sample Rate 44100 Hz, Start offset 0 bytes, Amount to Import 100%. 
- And I got the same wave as in initial .raw file of the author, the same frequency, of course less cycles and not sync with yours, which is logical. 
- The same I could do it with Tera Term. 
It did not cross to my mind to try to import as Raw Data the .txt file; I thought it must be always .raw file. 
Everything is fine now, looks good. The exporting to .raw or text seems that involves saving first as uncompressed WAV file: <a href="https://www.hellomico.com/getting-started/convert-audio-to-raw/" rel="ugc">https://www.hellomico.com/getting-started/convert-audio-to-raw/</a>&nbsp;. I will investigate that later. 
Next I went to Audacity, Analyze, Sample Data Export, I have tried 100K samples with Data (CSV) and also Time Indexed (txt) and I have imported that resulted file in Excel with Data, From Text and after I arranged the samples I got a nice sine wave. 
I have tried also Adobe Audition, where we can see and analyze even nicer the waveform. 
Here is the result: 
<a href="https://goo.gl/oUdAhP" rel="ugc">https://goo.gl/oUdAhP</a>
</div>

<div>
Something must be wrong with how I capture the data, because in the initial file below is 16bit resolution: 
<a href="http://www.microchip.com/forums/download.axd?file=2;790718" rel="ugc">www.microchip.com/forums/download.axd?file=2;790718</a>
</div>

<div>
It is a very good observation, but let’s discusses it one more time. 
First of all, as I said earlier, the code is not written by me, I just test it and I want to see how it works and analyze the output of the generated number/sine wave. 
The PIC is PIC24H series on 16bit, working with internal oscillator with PLL with a clock of 80MHz. 
The sine is generated using a math function library with sin() and then the 16bit output of the sine is sent to the UART in 2 bytes, LSB first. 
The way how is sent is a continuous loop without end and without \n\r or other characters useful to sync the data at the receiver side. That can create confusion between MSB and LSB in the captured file, because we do not know which byte is first inside the file. To correct that we must sometime delete/shift 1 byte in the “capture.txt” file in order to get it right. 
The biggest problem that I had was to convert the data captured in useful info. 
RealTerm and Tera Term can capture direct to file in HEX. 
There are differences between them. RealTerm saves as continuous HEX code with all the bits following each other. To split them I used HxD Hex editor and with the right setting view we can export the data as 1 column of 2 bytes as a .txt file. That file may be imported than in Excel and plotted as graph. Even here there is a problem, because we import HEX and Excel treats E from HEX as E from power of 10. We must use Text at import moment. Then we have 16bit signed and HEX2DEC function in Excel does not help alone. Next trick must be used: <a href="http://www.cypress.com/blog/daves-corner-dave-van-ess-blog/really-cool-hex-signed-interger-trick-excel" rel="ugc">http://www.cypress.com/blog/daves-corner-dave-van-ess-blog/really-cool-hex-signed-interger-trick-excel</a> 
Tera Term has other problems; it adds spaces between each 1 byte. Here I used Notepad++ with other tricks to arrange the data readable for Excel as 1 column and many rows. Once the data is arranged nice without spaces and only 1 bytes per row, 1 column in the txt or log file captured, then it can be imported in Excel. This approach provides direct info of the bytes received from serial port, but I did not use any time stamp in the captured program. The RealTerm will add only one time the time stamp in the beginning of the capture, because the file is a continuously long text/string. With Tera Term I did not try to find that options. Even to capture as HEX is not straight forward, must be put in Debug mode. 
The raw data, seen as ASCII characters in captured txt or log file can be used with time stamp automatically assigned at Import Raw Data in Audacity or Adobe Audition. Here the sample rate set at importing time place an important role as I’ve got different frequencies for the signal if I changed that. But this is not so important now. 
Coming back to your observation that “MSByte is counting up slowly, and the LSByte 01 never changes. &nbsp;This is really 8 bit resolution and a waste of space.” Well, from the way how the sine is generated inside the PIC24H, with argument of the sine rolling in a range of 65536 and as well by analysis in Excel we can see that the sine has 65536 levels/steps in increment of 1, which is 2 power 16, so that is 16bit resolution. 
Here are more captured data and arranged data, the Excel files are big 10-12MB with 50K-300K rows and graphics, so must be downloaded in PC, cannot be seen easy online: 
<a href="https://goo.gl/EYcGct" rel="ugc">https://goo.gl/EYcGct</a> 
 
The fact that it changes slowly, I though it may be another story as for example there are many points with the same value because the shape of the sine requires at high resolution to maintain in time the same value several time steps. The 1 cycle/period of the sine has 65536 samples and that creates confusion for me thinking that is also 16bit (resolution). 
But you are right, when I analyze the data properly I see that only goes from between -32768 and +32768, but many are repeated, are identical, the same number each 256 samples, so can be scaled down by dividing with 256 and I get only 8bit resolution. 
How is that possible? What mistake do I make? What should I watch? 
I said to myself that maybe the PC port or the serial terminal software or RS232 TTL to USB has some problems, so I decided to look into details and I analyzed the data at UART port with an oscilloscope that has decoding possibility for RS232. I captured many frames and look at them. The decoding offers even a table with HEX or DEC format for the bytes received. And it is the same as in serial terminal software. I see repeated numbers for long periods indicating 8bit resolution with 16bit data sample. 
My question is this: 
- Why with the provided “PIC_Output.zip” raw data I can see in Audacity the sine wave with 16bit resolution and 16bit data/sample and what I see at PIC24H UART is 8bit resolution 16bit data/sample?
</div>

<div>
I found the problem. 
It is an error in the code &quot;main.c&quot;, most probably a mistyping error and less probably logic error. 
 

<pre><code class="code-10 nolinks" id="code-20-42126886-1">// Transmitting the sine function results over UART

#include &lt;xc.h&gt; //The base for compiler
#include &quot;custom_header.h&quot; //Custom project-specific functions and definitions
#include &lt;libq.h&gt; //Fixed point math

int main(void) {
 _Q0_15 X,Y; //Argument and Result
 unsigned short int Z; //Transmitted symbol counter
 
 Initialization(); //Setitng up default pins states and configuring the clock
 UART1_initialization(); //Configuring and enabling UART1

 X=0; //X rolls over. -32768 is -Pi, 32767 is +0.999969482421875*Pi
 Z=0; //Symbol counter for TX LED indication

 do {
 Y=_Q15sinPI(X++); //Computing sine value then incrementing X
 UART1_wait_and_indicate(&amp;Z); //Waiting for TX and flashing by LED
 U1TXREG = Y &amp;&amp; 0xFF; //Transmitting low byte
 UART1_wait_and_indicate(&amp;Z); //Waiting for TX and flashing by LED
 U1TXREG = Y &gt;&gt; 8; //Transmitting high byte
 }while(1);
}
</code></pre>
 
The line &quot;U1TXREG = Y &amp;&amp;&nbsp;0xFF; //Transmitting low byte&quot; should be with only one &quot;&amp;&quot;: 

<pre><code class="code-1 nolinks" id="code-20-42126886-2">U1TXREG = Y &amp; 0xFF; //Transmitting low byte
</code></pre>
Now works fine like that. 
I recorded and processed new data and everything looks fine: 
<a href="https://goo.gl/Sdq3P9" rel="ugc">https://goo.gl/Sdq3P9</a>
</div>

<div>
<div class="content wysiwyg-content">
I use a microcontroller to generate a sine wave. The microcontroller has a serial port (UART) and sends the digital generated data to a serial port of the PC. I use a USB to RS232 TTL adapter. 
I can see the data on PC using serial port terminal software. 
The data is sent using 115200 baud rate and has the format 8 bit, odd, 2 bit of stop. 
I have tested several serial port programs. Among them are RealTerm to see and capture or RS232 Data Logger to capture. 
My problem is that I cannot see the data in the proper format. 
I expect to see some number, positive and negative, which define the sine wave and in fact I can see them on the screen using RealTerm software set properly, but the real problem is that I would like to capture the data and analyze it later, eventually in Excel or other programs. 
When is captured, then is either HEX or String ASCII and for some reason I cannot convert it to the positive and negative, which define the sine wave. Either is not captured properly or must be converted. Here I need the help.
</div>
</div>

I use a microcontroller to generate a sine wave. The microcontroller has a serial port (UART) and sends the digital generated data to a serial port of the PC. I use a USB to RS232 TTL adapter.
I can see the data on PC using serial port terminal software.
The data is sent using 115200 baud rate and has the format 8 bit, odd, 2 bit of stop.
I have tested several serial port programs. Among them are RealTerm to see and capture or RS232 Data Logger to capture.
My problem is that I cannot see the data in the proper format.
I expect to see some number, positive and negative, which define the sine wave and in fact I can see them on the screen using RealTerm software set properly, but the real problem is that I would like to capture the data and analyze it later, eventually in Excel or other programs.
When is captured, then is either HEX or String ASCII and for some reason I cannot convert it to the positive and negative, which define the sine wave. Either is not captured properly or must be converted. Here I need the help.

Capture and interpret serial port data

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.

Miscellaneous

The Math / Science topic primarily includes discussions of mathematics, physics, statistics and economic analysis, but also biology, chemistry and other sciences.

Math / Science

A personal computer is a general-purpose computer whose size, capabilities and price make it useful for individuals, and is intended to be operated directly by an end-user with no intervening computer time-sharing models that allowed systems to be used by many people, usually at the same time. Personal computers may be connected to a local area network (LAN), either by a cable or a wireless connection, and through that to the Internet. A personal computer may be a laptop computer or a desktop computer running an operating system such as Windows, Linux or Macintosh OS.

Hardware includes cell phones and other digital living devices, tablets, computers, servers, peripherals and components, printers and scanners, gaming consoles, networking hardware such as routers, hubs, switches and modems, storage devices and security equipment such as firewalls and other appliances.