Wat are the values inside the columns of the csv-export of the AD5933 Eval Software ?
There are headers missing and in the example attached the value under "real" is 0 but I have measured a resistor.
I'm not sure where the extra 3 columns came on the excel to the left. They should not be on the excel automatically generated by code. In any case your results look wrong and I'm guessing the eval board hook-up might be incorrect.
Can you review the Apps note for Rev C of Eval-AD5933EBZ.
Explains the columns and how a measurement is made.
Just to clarify how looks the file,
I know how the file should look like but it doesn't.
I installed AD5933setup_rev1.3.exe from the homepage. In the first example I had an additional unknown Z during the mesurement.
The mesurement was with 100 Ohms for Z and the feedback resistor.
I still have more columns than expected:
What can I do ? What are the wrong columns ?
Are you closing the csv file before export the data?
Are you using different file name each time?
I can not open the csv directly. When I click on "Download Impe..." I have to select the path where to save the file. After that I can open it.
Yes I used always a different name.
yes this is exactly what I do. Any Idea what I can do ?
which is your board revision?
If is Rev.C,Could you use CAL = 100ohms and Z = 90ohms?
Could you provide a screen shoot of your measurement?
And your exported CSV file?
I found the problem ! The csv has a "," as limiter AND as decimal sign. With that Excel devides all values like 12,345 in two columns.
Is there a possibility to change the limiter or the decimal sign ?
Excel should be able to open the file with problem.
Maybe this will help...
i know this post is 2 yrs old. But the problem happened to me also only days ago.
I Isolved it within Windows 7.
Go to System-Control -> Region and Language ->format -> advanced Settings
"decimal delimiter" -> from "," to "." (point)
"symbol for counting signs" from "," to " " (space)
after that the .csv gets imported correct and you can sort it by using "data to rows" with "," as delimiter.
So you insert 100 Ohms as Zunknown and 100Ohms as Rrb. Load register settings as shown. Hit Program Registersd - Hit Calculate Gain Factor - Hit Sweep and you get correct plot as shown. Then you pressed Download Impedance Data and opened up excel to find the following data ? Is that the procedure you are using ?
The plot Magnitude is correct while the excel impedance is stating 1.
Retrieving data ...