WebGenii Consulting offers a wide variety of technical services to help you get the most out of your computer software for reasonable rates.
I offer: Custom Template Design, VBA Programming, Web Design and Web Writing , Technical Writing, PDF Conversion, Software Training and User Support for the novice and advanced user. Don't forget to check out the Tips page.
A Technical Memo describing an Excel Addin I wrote for DRDC - Suffield has now been released. Entitled ChromaBlast - a Data Visualization Tool the paper describes the purpose and function of the ChromaBlast tool. The code and examples of Chromoblast in action are available in pdf form. ChromaBlast was designed to convert large data sets into heat or colour maps.
From the paper:
ChromaBlast was designed to facilitate rapid comparison of microarray data, without the prior requirement for statistical analysis. It proves to be useful for analyzing disparate data types. Multiple numerical data models ranging from microarray data, population statistics, and global temperature data have been analyzed here with ChromaBlast.
Recently, I completed a project in Excel where the data processing was going to take some time. No way around it. Typically, at this point a dialogue displays showing that Excel is working. This prevents the user from accidental cancellation and reassures them that everything is proceeding as it should.
Wouldn't it be cool, I thought, if we could see the data being processed in a "Matrix" type display. After all, if you are doing cool science - shouldn't it look cool?
Yes, there is a time cost to the display - but not as much as one might think.
The following is a link showing what I came up with. Tell me what you think.
Want a different picture? - just refresh your browser.
The pictures are chosen by a JavaScript. If you are not using JavaScript you will not be able to see them - sorry!
Last updated:June 17, 2011
Custom Template Design | VBA Programming | Microsoft Project |Web Design | Technical Writing | Training and Support | |PDF Conversion | Web Writing | Tips | About WebGenii | The Blog