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

The Excel to Graphviz Relationship Visualizer spreadsheet transforms your Excel data into professional Graphviz diagrams. Enter simple "A is related to B" rows to instantly generate polished relationship graphs using the Graphviz DOT language. Ideal for data analysis, network visualization, and IT architecture. Free, open-source, MIT-licensed. Customize the look of nodes, edges, and clusters with the Style Designer. Build a CSS-like gallery of reusable styles that lets you apply consistent visual themes. Run SQL queries for advanced data import. Export graphs as BMP, GIF, JPG, PDF, PNG, or SVG files (with animation support). View Graphviz DOT code and command-line messages. Works on Windows and macOS with a ribbon interface and UTF-8 support for global text. Explore illustrated guides at https://exceltographviz.com With over 10,000 downloads and a SourceForge Community Choice award, this open-source VBA tool clarifies complex data. Download now and turn data into insight.

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.

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

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.