I want to get the sine wave using excel.

ertansuluagac · Joined: 13 Jul 2017 Posts: 135 Location: IZMIR

hello everyone.
PIC16F1784 dac output from I want to get the sine wave using excel.
How can I do?

The outputs for the sine wave was calculated as follows, the values were rounded to the nearest integer value:

#define WAVE_POINTS 100

DEGREE_INC_VALUE = 360 / WAVE_POINTS = 360 / 100 =
DEGREE_INC_VALUE = 3.6
For outputs 0 - 99:
Output[i] = (DAC_MAX_VALUE / 2) (sin(i * DEGREE_INC_VALUE) + 1)
_________________
Es

temtronic · Posted: Thu Dec 26, 2019 10:02 am

One way is to send the data as 'CSV' (Comma Separated Variables) to a PC terminal program and have it save to a file (maybe named 'DACoutput.CSV')
You then open Excel and import' 'DACoutput.CSV'.
The numbers wll 'magically' be put into a spreadsheet.
You should also send 'start of data', 'end of data' markers just so you know all data is sent.

Jay

ertansuluagac · Joined: 13 Jul 2017 Posts: 135 Location: IZMIR

ex_sine.c in made in this sample from ccs .how these values are formed. and how it applies to Excel.

temtronic · Posted: Thu Dec 26, 2019 12:31 pm

here's what I think
1st sine waves are AC( + and - values) , PIC DAC is DC ( +ve only)

Those numbers represent an 'offset' sine wave broken into 200 points. So 360* / 200 = 1.8* ( * means degrees) uisng 8 bit 'math'.

The numbers are unsigned integers ( 0 - 255)

'128' is the middle and so represents the 'zero' voltage line
'248' represent the maximum positive level
'8' represents the maximum negative level

The more 'points', the smoother the sinewave will be,but requires more time to create it. Usually you add an R-C filter to the DAC output and you'll get a very nice 'sine' wave. Using a 16 or 32bit DAC will result in an even better 'sine wave' but costs more money in hardware.

Others will reply,hopefully with better explanations.

Jay

ertansuluagac · Joined: 13 Jul 2017 Posts: 135 Location: IZMIR

how do i apply these values to excel. I want to see the sinus wave in excel.
_________________
Es

ertansuluagac · Joined: 13 Jul 2017 Posts: 135 Location: IZMIR

how create this values.

#define WAVE_POINTS 100

dyeatman · Joined: 06 Sep 2003 Posts: 1933 Location: Norman, OK

Go here to learn how to create a graph in Excel.

https://www.workzone.com/blog/how-to-make-a-graph-in-excel/

Using that info it took me 5 minutes to create the graph using your data.
I saved the values to a CSV file (with no CRLFs except at the end) then opened the file in Excel which created one row of data.
I then used Insert Graph and selected the data to create the graph of a clean sine wave.
_________________
Google and Forum Search are some of your best tools!!!!

ertansuluagac · Joined: 13 Jul 2017 Posts: 135 Location: IZMIR

using these values I see the sine wave. How do I make these values. so , this numbers how can create?

[WAVE_POINTS] = {128, 136, 143, 151, 159, 167, 174, 182, 189, 196,
202, 209, 215, 220, 226, 231, 235, 239, 243, 246,
249, 251, 253, 254, 255, 255, 255, 254, 253, 251,
249, 246, 243, 239, 235, 231, 226, 220, 215, 209,
202, 196, 189, 182, 174, 167, 159, 151, 143, 136,
128, 119, 112, 104, 96, 88, 81, 73, 66, 59,
53, 46, 40, 35, 29, 24, 20, 16, 12, 9,
6, 4, 2, 1, 0, 0, 0, 1, 2, 4,
6, 9, 12, 16, 20, 24, 29, 35, 40, 46,
53, 59, 66, 73, 81, 88, 96, 104, 112, 119};
how these numbers are calculated. I wrote a formula above. I think when I apply this formula to excel, these numbers occur. te te how do I apply that formula to excel.
this formula;

The outputs for the sine wave was calculated as follows, the values were rounded to the nearest integer value:

ertansuluagac · Joined: 13 Jul 2017 Posts: 135 Location: IZMIR

does anyone know how it occurs these values?
yes, from excel in these values very beautiful sinus waves see. but, how it occurs these values
_________________
Es

ertansuluagac · Joined: 13 Jul 2017 Posts: 135 Location: IZMIR

[SOLVED]

the problem is solved.
thanks
_________________
Es