ChromaBlast - a Data Visualization Tool
Abstract
Experimental systems in biology now have the capability to produce massive amounts of numerical data. Large scale analysis of such data is facilitated by costly integrated software packages. Often however, such packages have limited or no data reduction or manipulation tools, such as basic spreadsheet functionality. Thus the researcher is compelled to utilize a competent spreadsheet package, such as Microsoft Excel, then export the data set to analysis software. Reformatting data or reducing it for analysis must then be redone in the spreadsheet after each analysis run, until the final dataset is appropriately formatted for the analysis package. In order to facilitate the use of the capabilities of the spreadsheet software and perform data reduction or basic analysis without having to switch back and forth between software units, we are building a set of analysis tools in Excel. One of the most useful of the tool set is ChromaBlast, which normalizes columnar data, sorts the data into user-selectable range-driven bins, develops a colour heat map from the data, and outputs the heat map and bin assortment for review. Using intrinsic tools in the spreadsheet software, output data can be filtered and sorted to emphasize data patterns, and facilitate rapid data review.
Document Details
- Document Type
- Technical Report
- Publication Date
- Jun 01, 2006
- Accession Number
- ADA457115
Entities
People
- Barry N. Ford
- Catharine Richardson
- Stephen Bjarnason
- Yimin Shei