I Don't See All My Data in Analysis Graph or when Exporting to a Text File Using BioBench 1.0
Primary Software: Other NI Software>>BioBench
Primary Software Version: 1.0
Primary Software Fixed Version: N/A
Secondary Software:
Problem: I am exporting data from BioBench 1.0 to a text file and I don't see all my data exported. Also, the data in my graph in the analysis window looks fuzzy and does not resemble the data that I collected. What can I do to fix this?
Solution: These two problems are related to each other. Data in BioBench will be decimated if it has too many points for the graph to display. You can tell if BioBench is using decimation because it will read "dec 2:1" (or some other ratio) to the right of the manipulation buttons on the analysis screen. Decimation is implemented when you try to view more than 5,000 points on a graph. Therefore, if you acquired 10,000 points and try to view your entire set of data, BioBench will only display 5,000 points of your data. Your displayed data will not accurately represent the data that you acquired. This creates a related problem, because only the portions of the data that are being displayed can be exported to a spreadsheet file.
There are three different possible solutions to the issue with decimation:
- See KnowledgeBase 24CGFO7Z (linked below) for an updated version of the BB.llb file (located in BB.zip). The updated BB.llb file will not decimate data exported to a spreadsheet, and it fully supports any filters or transforms you have selected in the Analysis window and exports the data in filtered and/or transformed form. NI-DAQ must be installed if you are using this fixed BB.llb, otherwise BioBench will not work.
- See KnowledgeBase 24CGFO7Z (linked below) for the BioBenchtoExcel.exe file, which is a LabVIEW executable that will enable you to send a BioBench binary file to a spreadsheet. This executable will not decimate data that it saves to a spreadsheet. Run the executable and select your BioBench file (.bb). You will then save your data to a text file (.txt) or an Excel file (.xls). This executable requires the LabVIEW Run-Time Engine (see the Related Link, below). You do not need the updated BB.llb file to run this executable.
- If you do not want to use one of the first two methods, then you are left with a more tedious option. You must be in analysis mode to export your data. Highlight your entire data file by hitting the middle graph navigation button, which selects the entire file, and then hit the far right graph navigation button, which highlights all data on the analysis screen. You can export this entire region by going to File » Export to Spreadsheet.
If you see a decimation factor to the right of the manipulation buttons on the analysis screen, then you need to select a window of data (using the manipulation buttons), such that the decimation factor disappears. Once the (dec x:1) disappears, then you can highlight the selected piece of data to export to file. Once you have exported that piece you can use the >> button to jump the same data points over and then simply highlight your data again and export, this time appending to the original file. Using this method will result in all data points being exported to the .txt file.
Note: When data is appended to a file the header information is added again as well. So if you append data to a file 6 times you will have a total of 7 header information sections. You will need to delete these header sections, if you want a contiguous data set. Attached is an Excel macro which will strip out the unnecessary headers for you. Excel 95 is limited to only 16384 lines whereas, Excel 97 has a much greater limit (65536).
Related Links: KnowledgeBase 24CGFO7Z: BioBench Support Files
Drivers and Updates: LabVIEW Run-Time Engine
BioBench Support
Attachments:
Report Date: 02/02/1998
Last Updated: 12/19/2003
Document ID: 161EAQRY
