sheets

the sheets:

There are four catagories of sheets:

shapes and lines sheets:

• first sheet:Nodes to define nodes
• second sheet:edges to define edges
• third sheet: Clusters to define clusters
• fourth sheet: Cluster_Structure to define hierarchy of clusters

shapes and lines types sheets:

• fifth sheet: Enum_Node_type to define node types (used in nodes sheet)
• sixth sheet: Enum_Edge_type to define edge types (used in edges sheet)
• seventh sheet: Enum_Cluster_type to define cluster types (used in clusters sheet)

graphviz variables sheets:

• eight sheet: GVVariables Graphviz node, edge and cluster type variables
• ninth sheet: GVGraphAttributes Grpahviz graph attributes

tool and output control sheet:

• tenth sheet: Settings for the excel-to-graphviz tool itself

first Sheet: Nodes (graphviz nodes)

Defines the nodes. Fill out this sheet with all concerned nodes the following way:

• col A: the name of the node
• col B: (optional) the node version (not the technical version). whole numbers
• col C: hidden concatenation of name and version. just forget about this but don't overwrite this
• col D: (dropdown) the node type (defined in fifth sheet Enum_Edge_type)
• col E: (optional) the cluster in which the node resides
• col F: concatenation of name, version and optional type and cluster to assure uniqueness
• col H: rankID. nodes with the same RankID which are in the same cluster are placed adjacent to another
• col x: you can add any column you want after col H for your own filtering purpose

Only visibile rows will be used to draw the image

second Sheet: Edges (graphviz edges)

    contains all relations that exist between listed nodes in a consumer<->consumed (or vice versa if you like) releationship
    Fill out this sheet with all listed nodes the following way:
    col A:  (dropdown) the name(.version) of the consuming(right or top) node
    col B:  (dropdown) the name(.version) of the providing(left or bottom) node
    col C:  (dropdown) The edge type (defined in sheet six: Enum_Edge_type)
    col D:  If you want another label than the standard edge-type label

third Sheet: Clusters (graphviz clusters)

    contains all clusters
    Fill out this sheet with all listed clusters the following way:
    col A:  The name of the cluster
    col B:  (dropdown) the type of the cluster (defined in sheet seven: Enum_Cluster_type)

fourth Sheet: Cluster_Structure

    Defines the hierarchy of clusters
    Fill out this sheet with listed clusters the following way:
    col A:  (dropdown) The name of the parent(contaiing) cluster
    col B:  (dropdown) The name of the child(contaiined) cluster)

fifth Sheet: enum_node_type

    Contains all required node types and their graphviz characteristics
    col A:  node_type       the name of the node type
    col B:  fontname        of the text 
    col C:  fontsize        of the text
    col D:  fontcolor       of the text. use html rgb color wiht preceding #
    col E:  shape           (dropdown) select one of the available graphviz shape types
    col F:  style           (dropdown) select one of the combination of available graphviz shape styles 
    col G:  fillcolor       when the style contains the word "filled" then this is the fillcolor. use html rgb colors with preceding #
    col H:  color           line color. use html rgb colors with preceding #

sixth Sheet: enum_relation_type

    Contains all required relation types and their graphviz characteristics (arrows etc.) required for Integration and Business services and processes high level design for use with QuickScan and ImpactAnalysis.
    col A:  relation_type   the name of the relation type
    col B:  dir             Direction of the relation type (usually an arrow)
    col C:  color           Color of the releation type (a line if visible)
    col D:  arrowhead       the shape of the relation type's arrowhead (dropdown)
    col E:  arrowtail       the shape of the relation type's arrowtail (dropdown)
    col F:  arrowsize       the relation type's size of both arrow ends
    col G:  label           the general text that resides with this relation type's line
    col H:  style           (dropdown) select one of the combination of available graphviz shape styles 
    col I:  fontname        of the text 
    col J:  fontsize        of the text
    col K:  fontcolor       of the text. use html rgb color wiht preceding #

eigth Sheet: GraphVizVariables

    contains selectable graphviz variables for nodes and edges (artifacts and releations) 
    do not touch unless you know what you're doing.

ninth Sheet: GraphVizGraphAttributes

    contains changeable attributes that have an effect on how the graph is rendered and displayed (for dot and neato graphs).
    please refer to the graphviz dotguide.pdf for more information.

tenth Sheet: Settings

    contains changeable graph specific settings