Open Source Visual Basic for Applications (VBA) Data Management Systems

Takes Excel data relationships and creates Graphviz graph visualizations.

XL Toolbox is a free Excel statistics addin that helps analyzing and presenting data: Smart custom error bars, chart design, chart export to TIFF; formula builder, transpose wizard, analysis of variance (ANOVA); automatic backups, workbook management and more.

ISOPLOT is a flexible software tool for the analysis and interpretation of radiogenic-isotope data. It is developed by Dr Ken Ludwig of the Berkeley Geochronology Center. DISCLAIMER: Isoplot is BGC’s Visual Basic Add-in for Microsoft’s Excel(R) for data analysis and graphical presentation of geochronology, earth science and other radiogenic isotope data only. BGC’s Isoplot is not the Isoplot(R) for analysis of any measuring system as described at http://www.shainin.com/. BGC is not affiliated with Red X(R) Holdings, LLC. Isoplot(R) is a registered trademark of Red X(R) Holdings, and is licensed to Shainin(R) LLC.

MerciGest is a free inventory management software. The program allows you to manage thousands of items in the warehouse by showing them in a complete list of loads, unloads, returns and stock. The software also allows you to print transport documents and invoices. The program is available in 4 languages: english, italian, spanish and french In this project there is both the desktop version for Windows and for MS Access. The application written in VBA for MS Access is distributed in open source mode under GPL license.

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

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

ALPHA VERSION OF APPLICATION, MANY FEATURES MAY DON'T WORK. We are looking for programmers who know the language vb.net, preferably who speak Italian or in English. Use the forum for more information about. User friendly management company, located in Italian, lets you write invoices, deadlines, vat, orders loading / unloading, handling customers and suppliers, financial charts and much more. It connects to MSAccess DB or SQL to store data. Allows you to manage small and medium enterprises remembering important dates such payments and collections.

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.

SCOREMATH implements the simple-yet-ingenious weighted linear model for multi-criteria selection problems described in Ng, Wan Lung. "An efficient and simple model for multiple criteria supplier selection problem." European Journal of Operational Research 186, no. 3 (2008): 1059-1067. "There are many real situations where the decision makers are able to tell the criteria importance ranking (although they cannot tell the exact values of weights). The decision makers may not have enough knowledge to assign exact weight values but they can rank the importance by their expertise or experience. [...] [Our model] requires no pre-defined weight values. At the same time, our model can incorporate some user control by ranking of relative importance of the criteria. [...] decision makers only rank the relative importance of criteria, rather than specifying the degree of relativity. [...] [our model] does not require users with any optimization background."

A collection of Visual Basic macros and a template for the analysis of terminal restriction fragment length polymorphism data using Microsoft Excel.

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.