Excel Active Graph the Application

EAG loads an Excel document that takes the first row as column headers.

A user selects a sheet and may select a column for nodes list.
Edges of the graph consists of these nodes. With columns for "To" and "From" nodes.
The user can constrain the graph with a filter by selecting a column that contains a criteria and then selecting an item that will only pull rows that contain that constraint.


Screenshots of the application.....


Welcome screen: Provides an initial welcome page with instructions. A login in screen is a available to registered users.

Configuration Screen: Basic configuration of the application.




The Active Graph has basic navigation using 3 radio buttons and a scroll bar.
Clicking-and-dragging on the background allows for rotating the graph on a invisible 3D sphere.
Nodes can be clicked-and-dragged to reorient the graph.


Double-clicking on a node bring focus to that node.
Right-clicking on a node bring up a context menu.
Red badges on a node indicate additional nodes to the graph are hidden.

Next the WebSite

Welcome to Excel Active Graph

Excel Active Graph

This blog will cronical an experiment to see how a project can evolve quickly week to week. I will set out weekly aggressive goals that involve end to end creation and marketing of a product. I will document the tools used along the way.

So as not to blog about the blog too much and just get to the meat of the project. Here is the outline this weeks goals through the mindmap.

FreeMind was used to create this simple static graph to plan out this weeks activities.

This week is very aggressive. Create the app and a supporting website to allow users to download.


Next: The App