 |
|
|
|
 |
|
||
 |
 |
 |
|
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
|
||
 |
VBAMSTER |
VBAMSTER is a reformatting tool for extracting raw microarray data from SAM output to text format using an Excel Macro written in VBA (Visual Basic). The text output is written into a new worksheet within the SAM Excel file, and may then be visualized by heatmap (possibly using HeatMap Builder, http://quertermous.stanford.edu/heatmap.htm, written by Watt, Spin and Ashley of the Quertermous Lab at Stanford), or fed into Cluster or other programs.
After SAM analysis, one is left with an Excel spreadsheet containing up- and down- regulated genes. In 2002, Charlie Kim wrote a standalone Windows executable called Samster1, capable of extracting raw SAM data to text format, avoiding the tedious necessity of creating a database to link SAM output to the data. The downsides of Samster are that it requires installation and running of independent programs, and saving and closing the SAM worksheet in advance. Also, it is a bit slow, and the generated text file has to be saved separately from the original Excel file.
VBAMSTER uses an Excel macro written in Visual Basic that accomplishes the same thing, but writes the data into a new worksheet in the same SAM file. As a macro it is convenient to use, and is much faster than SAMSTER in head-to-head tests. The program works with all current SAM outputs, and comes with a custom button if you wish to install the macro to your Excel toolbar. It requires no additional programs to be installed.
The program is free to the academic community. To download the executable, please go to our registration page. If you've already registered, please go here. If you have forgotten your username and/or password, please e-mail the webmaster. Installation and running documentation is available here in pdf format. For enquiries, please email Joshua Spin.
If you would like to make a
citation to VBAMSTER, please cite this website.
Reference (http://quertermous.stanford.edu/vbamster.htm).
Version 1.0
July 1, 2004
VBAMSTER program Copyright 2004 Joshua Spin, MD PhD
VBAMSTER documentation Copyright 2004 Joshua Spin, MD, PhD
jspin@cvmed.stanford.edu
Stanford University
1Mueller A, O'Rourke J, Chu P, Kim CC, Sutton P, Lee A, Falkow S.
Protective immunity against Helicobacter is characterized by a unique
transcriptional signature.
Proc Natl Acad Sci U S A. 2003 Oct 14;100(21):12289-94.
Other Tools :
-
HeatMap
Builder
- Web-
Genehunter
- Roger's Tool
- GeneData
- SMD
- Agilent's
- GenePilot