03-27-2018 08:03 AM
Currently having an issue with the Data being shown on the Excel Worksheet. Previously I had a sample rate of 10,000 Hz and a finite sample amount of 2000. Which would work with my program and display the data every time sampling collection interval. The new finite sample amount is 125000 to equate to 12.5 seconds of capture time which would relate to the gears output I am trying to acquire. Unfortunately looking at the probe all the data is being collected I'm just not seeing the output of data collected in Excel. Below I'm attaching a snippet of code which shows all the data collection information.
03-27-2018 08:17 AM
After researching Excels column limit I believe that is the issue, but i'm not sure of a good work around just yet if anyone has suggestions? Excel column limit is 16,384.
03-27-2018 01:14 PM
How many rows do you have? Can you transpose your data?
03-28-2018 11:09 AM
Were you able to get Excel to "keep up" when you sent 10KHz data 2000 points at a time? If you want to send 12.5 seconds of data, but need to keep each "chunk" under 16K rows, why not send 5000 points at a time? When you've done this 50 times, you'll have 12.5 seconds of data, and will have "worked around" Excel's Column limit.
Bob Schor