Sunday, September 30, 2007

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

No comments: