imDEV

About

Interactive modules for Data Exploration and Visualization (imDEV) is a Microsoft Excel spreadsheet embedded application providing an integrated environment for the analysis of omics data through a user-friendly interface. Individual modules enable interactive and dynamic analyses of large data by interfacing R’s multivariate statistics and highly customizable visualizations with the spreadsheet environment, aiding robust inferences and generating information rich data visualizations. This tool provides access to multiple comparisons with false discovery correction, hierarchical clustering, principal (PCA) and independent component analyses (ICA), partial least squares regression (PLS) and discriminant analysis (PLS-DA), through an intuitive interface for creating high quality two and a three-dimensional visualizations including scatter plot matrices, distribution plots, dendrograms, heat maps, biplots, trellis biplots and  correlation networks.
If you find imDEV helpful please cite our application note in the Journal Bioinformatics

Developed by Dmitry Grapov 2011-2012

News (March 2013)

Some of you may have noticed that I have not updated imDEV for longer than normal. This is because I have been actively developing the next iteration of my vision for dynamic multivariate analysis and visualization, DEVIUM. Not only will this platform incorporate the ideas developed in imDEV (and most of the source code), but it will be cross-platform (Windows, Mac and Linux), RExcel and VBA independent and feature a wide array of tools for univariate statistics, multivariate modeling, network constructions and my personal passion; lots of novel data visualizations!

So keep an eye out for the official release of project code name DEVIUM, but until then check out the alpha version (best on windows) by simply running the following code in the  R console:

#load package from github repo
source("http://pastebin.com/raw.php?i=JVyTrYRD")

#check out some of the available functions (help files forthcoming)
objects()

#launch GUI (watch R console for messages regarding the downloading of dependancies)
devium.gui()