MATLAB Why Does MATLAB Only Read 10,000 Data Points from My Spreadsheet?

  • Thread starter Thread starter Beer-monster
  • Start date Start date
  • Tags Tags
    Matlab
AI Thread Summary
The discussion revolves around the challenge of analyzing a long sound file using a storage oscilloscope, which captures data in segments of 10,000 data points. The user has split the sound file into smaller samples for analysis but faces difficulties in combining the results into a single dataset for comprehensive analysis. Despite modifying MATLAB code to read the data from a spreadsheet, the user encounters issues where MATLAB only recognizes a fraction of the data points, leading to an inaccurate spectrum output. Suggestions include exporting the individual datasets separately and combining them in MATLAB, as well as addressing the potential issue of the data being read as a matrix instead of a column vector. The conversation highlights the need for proper data formatting and import methods in MATLAB to ensure all data points are accurately analyzed.
Beer-monster
Messages
285
Reaction score
0
Okay,avoiding a long story, for an experiment I'm having to analyse a long sound file using a storage oscilloscope. Th scope stores about a seconds worth of data as 10,000 datapoints on a csv sheet. The file I want to analyse is around 15 secs long, but I used a computer to split it into consecutive samples and played them one after the other.

Now my problem is I want to combine all the results for each separate run so that I can analyse all the data as if I recorded the file all at once. I modified a MATLAB code used to FT wav files to read spreadsheets using xlsread, and it seems to work for each data set individually, but not for all of them.

I've put all the data on a single spreadsheet and tried different ways to input it into matlab, including specifying the range in the code and direct import using the wizard, but I still don't get a suitable spectrum but rather one large peak and a couple of bumps. The only clue I have is that dispite the fact that I've in put arounf 150 thousand data points, MATLAB tells me there's only 10,000.

I'm sortry this is really hard to explain in text, but does anyone think they can guess where I'm going wrong?

Thanks
 
Physics news on Phys.org
It sounds like MATLAB is only reading one of the fifteen seconds of data.

Can you output the 15 or so sets of 10,000 data points individually? If so you could recombine them in matlab.
 
You mean combine the graphs?

Well I think my issue might be the code reads the spreadsheet as a matrix but requires a column vector. Is there a way to read a matrix and a long column?
 

Similar threads

Replies
4
Views
1K
Replies
3
Views
3K
Replies
5
Views
3K
Replies
8
Views
2K
Replies
6
Views
5K
Replies
1
Views
4K
Replies
1
Views
3K
Back
Top