imDEV 1.4.2 – omics data exploration and visualization in Excel

imDEV 1.4.2


imDEV (Interactive modules for Data Exploration and Visualization) 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.


Dmitry Grapov




  •  Excel
  • R package





Bioinformatics. 2012 Sep 1;28(17):2288-90. doi: 10.1093/bioinformatics/bts439. Epub 2012 Jul 18.
imDEV: a graphical user interface to R multivariate analysis tools in Microsoft Excel.
Grapov D, Newman JW.