Open Source Visual Basic for Applications (VBA) Data Visualization Software

Takes Excel data relationships and creates Graphviz graph visualizations.

XLibraryDisplay is an intuitive sequence analysis program optimized for protein engineering. It is ideal for all directed evolution platforms including phage, ribosome, and yeast display. Analysis can be quickly done on hundreds to thousands of sequences. Best suited for Sanger sequencing. Requirements: Microsoft Windows XP, 7, 8, or 10 and Excel 2007, 2010, 2013, or 2016 Described in Stafford et al JCIM 2014: http://pubs.acs.org/doi/abs/10.1021/ci500362s

Free, easy to use, excel tool to create data and process flow diagrams with table data In separate excel sheets you define items(nodes), lines(edges) and grouping(clusters) Separate definition of node, edge and cluster styles Graph settings sheet Output control sheet Examples and readme are included in the zip file Get it working: -Install graphviz (http://graphviz.org/Download.php) -Download Excel to Graphviz -Open one of the ExcelToGraphviz workbooks -Go to sheet settings and update "dotpath" to where graphviz' dot.exe was installed (e.g. C:\Program Files (x86)\Graphviz2.38\bin\dot.exe) -Generate the flow diagram with cntrl-M -Import from older version with cntrl-I This tool was initially made to show the usefulness of a service registry or service catalog in an enterprise integration environment. Therefore most examples are (anonymized) output of its use with ESB's at various telecom, banking and logistics companies Review/Feedback appreciated

Controversial ideas of Williamson, Margulis & others suggest speciation by hybridizing might be more common than originally thought. Taking this concept to the nth degree & assuming that indeed, speciation mostly occurs by hybridizing events, not the accumulation of mutations or genetic drift, here is a catalogueoflife2gedcom converter. It allows the tree of life to be displayed as a human genealogy tree with hybridizing events depicted as "marriages." The idea then is that mutation accrual & genetic drift are the determining factors for "species maturation," not speciation itself. Unfortunately the Catalogue of Life Project, catalogueoflife.org, changed its database format more recently, so this converter only works on older versions of the data. In the last working version of the database, making the assumption that each taxonomic name, no matter what level, refers to an original real species & starting them all as female, over 2 million "species/persons" were generated.

HP93000 Shmoo Excel Tools read the shmoo files in hp93000 shmoo text-file format, and show them or overlay them.

MyDataBars is a Microsoft Excel add-in program that draws data bars in worksheet cells. This program will enable you to create data bars in Excel prior to 2007.

You may also like some newer work: http://createdatasol.com/ Project imDEV is an application of RExcel, which seamlessly integrates Excel and R for tasks focused on multivariate data visualization, exploration, and analysis. Interactive modules for dimensional reduction (imPCA), prediction (imPLS), feature selection, analysis of correlation (imCorrelations) and generation of networked structures (imGraph) provide an integrated environment for systems level analysis of multivariate data.