AALLB
jyrilcez08
blahblah.xlsxEdges
| Visual Properties | Labels | Graph Metrics | Do Not Edit | Other Columns | |||||||||
| Vertex 1 TonyAdmin: Vertex 1 Name Enter the name of the edge's first vertex. Worksheet Overview To create a NodeXL graph in Excel 2007, enter the graph's edges on this worksheet, one row per edge. The first two columns are required; the other columns can be used to customize the edge's appearance. To customize the appearance of an individual vertex or add an isolated vertex not connected to an edge, click the "Vertices" tab near Excel's lower-left corner. After you have entered the edges, click the "Show Graph" button in the NodeXL tab in Excel's Ribbon. Formulas This column is formatted as Text, which causes formulas to be ignored. If you want to use an Excel formula in this column, you must change the column format to General. Frozen Columns The Vertex 1 and Vertex 2 columns are frozen, meaning that they remain visible even if you scroll the worksheet to the right. To unfreeze them, use View, Freeze Panes, Unfreeze Panes in the Excel Ribbon. | Vertex 2 TonyAdmin: Vertex 2 Name Enter the name of the edge's second vertex. Formulas This column is formatted as Text, which causes formulas to be ignored. If you want to use an Excel formula in this column, you must change the column format to General. Frozen Columns The Vertex 1 and Vertex 2 columns are frozen, meaning that they remain visible even if you scroll the worksheet to the right. To unfreeze them, use View, Freeze Panes, Unfreeze Panes in the Excel Ribbon. | Color TonyAdmin: Edge Color To select an optional edge color, right-click and select Select Color on the right-click menu. If you are familiar with CSS color names, such as Red, MediumBlue, and DarkOliveGreen, you can enter one of the names instead of using Select Color. Spaces in CSS color names are optional, so Medium Blue is the same as MediumBlue. You can also enter a color in the format "R, G, B" (don't include the quotes), where R, G, and B are between 0 and 255. Sample: "240, 12, 135". | Width TonyAdmin: Edge Width Enter an optional edge width between 1 and 10. | Style Tony: Edge Style Select an optional edge style. Formulas If you are using Excel formulas to compute the styles, you may find it helpful to use the numerical options instead of text: 1 = Solid 2 = Dash 3 = Dot 4 = Dash Dot 5 = Dash Dot Dot Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Opacity TonyAdmin: Edge Opacity Enter an optional edge opacity between 0 (transparent) and 100 (opaque). | Visibility TonyAdmin: Edge Visibility Select an optional edge visibility. Show Show the edge when the graph is refreshed. This is the default. Skip Skip the edge row. Hide Use the edge when laying out the graph but then hide it. Formulas If you are using Excel formulas to compute the visibilities, you may find it helpful to use the numerical options instead of text: 1 = Show 0 = Skip 2 = Hide Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Label Tony C.: Edge Label Enter an optional edge label. Formulas This column is formatted as Text, which causes formulas to be ignored. If you want to use an Excel formula in this column, you must change the column format to General. | Label Text Color Tony: Edge Label Text Color To select an optional label text color, right-click and select Select Color on the right-click menu. If you are familiar with CSS color names, such as Red, MediumBlue, and DarkOliveGreen, you can enter one of the names instead of using Select Color. Spaces in CSS color names are optional, so Medium Blue is the same as MediumBlue. You can also enter a color in the format "R, G, B" (don't include the quotes), where R, G, and B are between 0 and 255. Sample: "240, 12, 135". | Label Font Size Tony: Edge Label Font Size Enter an optional label font size between 8 and 72. | Reciprocated? Tony: Edge Reciprocated? You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | ID TonyAdmin: Edge ID This is a unique ID that gets filled in automatically. Do not edit this column. | Dynamic Filter | Add Your Own Columns Here TonyAdmin: How to Add Your Own Columns If you want NodeXL to use any columns you add, you must add them to this table. The table is distinguished from the rest of the worksheet by the table column headers in row 2, so you can tell where the table ends and the rest of the worksheet begins. You can add a column to the right end of the table by simply typing a column name into the first empty cell in row 2. Excel will automatically extend the table to the right to include the new column. You can also insert a column anywhere within the table, but that will interfere with NodeXL's ability to show and hide groups of related columns and is not recommended. |
Vertices
| Visual Properties | Labels | Layout | Graph Metrics | Do Not Edit | Other Columns | |||||||||||||||||||||||
| Vertex TonyAdmin: Vertex Name Enter the name of the vertex. Worksheet Overview Use this worksheet to customize the appearance of the graph's vertices and to add isolated vertices that are not connected to edges. You do not have to enter anything on this worksheet if you don't need either of these features. Isolated Vertices To add an isolated vertex that is not connected to any edges, enter it on this worksheet and set its Visibility cell to "Show." Formulas This column is formatted as Text, which causes formulas to be ignored. If you want to use an Excel formula in this column, you must change the column format to General. Frozen Column The Vertex column is frozen, meaning that it remains visible even if you scroll the worksheet to the right. To unfreeze it, use View, Freeze Panes, Unfreeze Panes in the Excel Ribbon. | Color TonyAdmin: Vertex Color To select an optional vertex color, right-click and select Select Color on the right-click menu. If you are familiar with CSS color names, such as Red, MediumBlue, and DarkOliveGreen, you can enter one of the names instead of using Select Color. Spaces in CSS color names are optional, so Medium Blue is the same as MediumBlue. You can also enter a color in the format "R, G, B" (don't include the quotes), where R, G, and B are between 0 and 255. Sample: "240, 12, 135". | Shape TonyAdmin: Vertex Shape Select an optional vertex shape. Formulas If you are using Excel formulas to compute the shapes, you may find it helpful to use the numerical options instead of text: 1 = Circle 2 = Disk 3 = Sphere 4 = Square 5 = Solid Square 6 = Diamond 7 = Solid Diamond 8 = Triangle 9 = Solid Triangle 10 = Label 11 = Image Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Size TonyAdmin: Vertex Size Enter an optional vertex size between 1 and 1,000. | Opacity TonyAdmin: Vertex Opacity Enter an optional vertex opacity between 0 (transparent) and 100 (opaque). | Image File TonyAdmin: Vertex Image File To show a vertex as an image, set the Shape to Image and enter one of the following into the Image File column: * The full path to an image file on your computer or local network. Example: "C:\MyImages\Image.jpg". * If the workbook has been saved, a path that is relative to the saved workbook file. Example: "Images\Image.jpg" * An URL to an image on the Internet. Example: "http://www.somesite.com/Image.jpg". | Visibility TonyAdmin: Vertex Visibility Select an optional vertex visibility Show if in an Edge Show the vertex when the graph is refreshed if it is part of an edge. Otherwise, ignore the vertex row. This is the default. Skip Skip the vertex row and any edge rows that use the vertex. Hide If the vertex is part of an edge, use it when laying out the graph but then hide it. Otherwise, ignore the vertex row. Show Show the vertex regardless of whether it is part of an edge. Formulas If you are using Excel formulas to compute the visibilities, you may find it helpful to use the numerical options instead of text: 1 = Show if in an Edge 0 = Skip 2 = Hide 4 = Show Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Label TonyAdmin: Vertex Label To show a vertex as a box containing text, set the Shape to Label and enter the text into the Label column. To annotate another shape with text, set the Shape to something else and enter the annotation text into the Label column. Formulas This column is formatted as Text, which causes formulas to be ignored. If you want to use an Excel formula in this column, you must change the column format to General. | Label Fill Color TonyAdmin: Vertex Label Fill Color To select an optional fill color for the Label shape, right-click and select Select Color on the right-click menu. If you are familiar with CSS color names, such as Red, MediumBlue, and DarkOliveGreen, you can enter one of the names instead of using Select Color. Spaces in CSS color names are optional, so Medium Blue is the same as MediumBlue. You can also enter a color in the format "R, G, B" (don't include the quotes), where R, G, and B are between 0 and 255. Sample: "240, 12, 135". | Label Position Tony C.: Vertex Label Position Select an optional vertex label position. This is used only when the label annotates the vertex, not when the vertex Shape is Label. Hover the mouse over the Label column header for more details. Formulas If you are using Excel formulas to compute the positions, you may find it helpful to use the numerical options instead of text: 0 = Nowhere 1 = Top Left 2 = Top Center 3 = Top Right 4 = Middle Left 5 = Middle Center 6 = Middle Right 7 = Bottom Left 8 = Bottom Center 9 = Bottom Right Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Tooltip TonyAdmin: Vertex Tooltip Enter optional text that will pop up when the mouse is hovered over the vertex in the graph pane. Formulas This column is formatted as Text, which causes formulas to be ignored. If you want to use an Excel formula in this column, you must change the column format to General. | Layout Order TonyAdmin: Vertex Layout Order Enter an optional number to control the order in which the vertices are laid out in the graph when a geometric layout algorithm (Circle, Spiral and so on) is used. This also controls the vertex stacking order when vertices overlap. Vertices with larger numbers are stacked on top of vertices with smaller numbers. | X TonyAdmin: Vertex Location Enter an optional vertex location. X and Y values should be between 0 and 9,999. If you enter X and Y values, you should set NodeXL, Graph, Layout to "None" to prevent NodeXL from overwriting your values when you show the graph. | Y TonyAdmin: Vertex Location Enter an optional vertex location. X and Y values should be between 0 and 9,999. If you enter X and Y values, you should set NodeXL, Graph, Layout to "None" to prevent NodeXL from overwriting your values when you show the graph. | Locked? TonyAdmin: Vertex Locked? Set to Yes to lock the vertex at its current location. Formulas If you are using Excel formulas to compute the locked values, you may find it helpful to use the numerical options instead of text: 0 = No 1 = Yes Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Polar R TonyAdmin: Vertex Polar R Enter an optional vertex polar radial coordinate. This is used only when the Layout is set to Polar or Polar Absolute in the graph pane. For the Polar Layout 0.0 represents the polar origin, which is the center of the graph pane, while 1.0 represents one-half the graph pane's width or height, whichever is smaller. Polar R values less than 0.0 are allowed, but they have the same effect as the value 0.0. Similarly, polar R values greater than 1.0 are allowed, but they have the same effect as the value 1.0. Any vertex that is missing polar coordinates is placed at the polar origin. For the Polar Absolute Layout 0.0 represents the polar origin, which is the center of the graph pane, while 1.0 represents an absolute distance of about 1/96 inch. There are no limits on Polar R values when using the Polar Absolute layout. Negative values have the effect of adding 180 degrees to the specified Polar Angle. Any vertex that is missing polar coordinates is placed at the polar origin. | Polar Angle TonyAdmin: Vertex Polar Angle Enter an optional vertex polar angle coordinate, in degrees. This is used only when the Layout is set to Polar or Polar Absolute in the graph pane. 0.0 degrees is to the right, 90.0 degrees is up, 180.0 degrees is to the left, and 270.0 degrees is down. Angles less than 0 are allowed: -1.0 is the same as 359.0, for example. Similarly, angles greater than 360.0 are allowed: 361.0 is the same as 1.0, for example. Any vertex that is missing polar coordinates is placed at the polar origin. | Degree TonyAdmin: Vertex Degree You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | In-Degree TonyAdmin: Vertex In-Degree You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Out-Degree TonyAdmin: Vertex Out-Degree You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Betweenness Centrality TonyAdmin: Vertex Betweenness Centrality You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Closeness Centrality TonyAdmin: Vertex Closeness Centrality You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Eigenvector Centrality TonyAdmin: Vertex Eigenvector Centrality You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | PageRank Tony: Vertex PageRank You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Clustering Coefficient TonyAdmin: Vertex Clustering Coefficient You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Reciprocated Vertex Pair Ratio Tony: Vertex Reciprocated Pair Ratio You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | ID TonyAdmin: Vertex ID This is a unique ID that gets filled in automatically. Do not edit this column. | Dynamic Filter | Add Your Own Columns Here TonyAdmin: How to Add Your Own Columns If you want NodeXL to use any columns you add, you must add them to this table. The table is distinguished from the rest of the worksheet by the table column headers in row 2, so you can tell where the table ends and the rest of the worksheet begins. You can add a column to the right end of the table by simply typing a column name into the first empty cell in row 2. Excel will automatically extend the table to the right to include the new column. You can also insert a column anywhere within the table, but that will interfere with NodeXL's ability to show and hide groups of related columns and is not recommended. |
Do Not Delete
| This worksheet is no longer used but is retained to allow older versions of NodeXL to open workbooks created with NodeXL version 1.0.1.96 or later. |
| Do not delete this worksheet. |
Groups
| Visual Properties | Labels | Layout | Do Not Edit | Graph Metrics | |||||||||||||||||||
| Group TonyAdmin: Group Name (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) Enter the name of the group. Worksheet Overview A group is a set of related vertices. Groups are usually indicated by vertex color and shape when the graph is refreshed. All the vertices in one group might be blue disks, for example. You can control how groups are shown using NodeXL, Analysis, Groups, Group Options. | Vertex Color TonyAdmin: Group Vertex Color (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) To select a color to use for all vertices in the group, right-click and select Select Color on the right-click menu. If you are familiar with CSS color names, such as Red, MediumBlue, and DarkOliveGreen, you can enter one of the names instead of using Select Color. Spaces in CSS color names are optional, so Medium Blue is the same as MediumBlue. You can also enter a color in the format "R, G, B" (don't include the quotes), where R, G, and B are between 0 and 255. Sample: "240, 12, 135". | Vertex Shape TonyAdmin: Group Vertex Shape (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) Select a shape to use for all vertices in the group. Pasting If you want to paste shapes into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the shape drop-downs from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Visibility Tony: Group Visibility Select an optional group visibility. Show Show the group's vertices and edges when the graph is refreshed. This is the default. Skip Skip the group's vertices and edges. Hide Use the group's vertices and edges when laying out the graph, but then hide the group's vertices and edges. Formulas If you are using Excel formulas to compute the visibilities, you may find it helpful to use the numerical options instead of text: 1 = Show 0 = Skip 2 = Hide Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Collapsed? Tony: Group Collapsed? (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) Set to Yes to collapse the group. Formulas If you are using Excel formulas to compute the collapsed values, you may find it helpful to use the numerical options instead of text: 0 = No 1 = Yes Pasting If you want to paste values into this column, do not use the standard Paste command (Ctrl-V). The standard Paste command removes the drop-down lists from the column. Instead, use Home, Paste, Paste Values in the Excel Ribbon. | Label Tony: Group Label Enter an optional group label. Group labels are used when you choose to lay out each of the graph's groups in its own box (NodeXL, Graph, Layout, Layout Options), and when you collapse a group (NodeXL, Analysis, Groups, Collapse Selected Groups). Formulas This column is formatted as Text, which causes formulas to be ignored. If you want to use an Excel formula in this column, you must change the column format to General. | Collapsed X Tony: Collapsed Location (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) Enter an optional location for the group when it is collapsed. Collapsed X and Collapsed Y values should be between 0 and 9,999. If you enter Collapsed X and Collapsed Y values, you should set NodeXL, Graph, Layout to "None" to prevent NodeXL from overwriting your values when you show the graph. | Collapsed Y Tony: Collapsed Location (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) Enter an optional location for the group when it is collapsed. Collapsed X and Collapsed Y values should be between 0 and 9,999. If you enter Collapsed X and Collapsed Y values, you should set NodeXL, Graph, Layout to "None" to prevent NodeXL from overwriting your values when you show the graph. | ID | Collapsed Properties | Vertices Tony: Group Vertices You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Unique Edges Tony: Group Unique Edges You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Edges With Duplicates Tony: Group Edges With Duplicates You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Total Edges Tony: Group Total Edges You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Self-Loops Tony: Group Self-Loops You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Reciprocated Vertex Pair Ratio Tony: Group Reciprocated Vertex Pair Ratio You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Reciprocated Edge Ratio Tony: Group Reciprocated Edge Ratio You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Connected Components Tony: Group Connected Components You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Single-Vertex Connected Components Tony: Group Single-Vertex Connected Components You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Maximum Vertices in a Connected Component Tony: Group Maximum Vertices in a Connected Component You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Maximum Edges in a Connected Component Tony: Group Maximum Edges in a Connected Component You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Maximum Geodesic Distance (Diameter) Tony: Group Maximum Geodesic Distance (Diameter) You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Average Geodesic Distance Tony: Group Average Geodesic Distance You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. | Graph Density Tony: Group Graph Density You can tell NodeXL to calculate this and other graph metrics by going to NodeXL, Analysis, Graph Metrics in the Ribbon. |
Group Vertices
| Group TonyAdmin: Group Name (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) Enter the name of the group. The group name must also be entered on the Groups worksheet. Worksheet Overview A group is a set of related vertices. Groups are usually indicated by vertex color and shape when the graph is refreshed. All the vertices in one group might be blue disks, for example. You can control how groups are shown using NodeXL, Analysis, Groups, Group Options. | Vertex TonyAdmin: Vertex Name (In most cases, you should not edit this worksheet. Instead, use the items on the NodeXL, Analysis, Groups menu to create and work with groups.) Enter the name of a vertex to include in this group. | Vertex ID Tony: Vertex ID This gets filled in by the items on the NodeXL, Analysis, Groups menu. |
Overall Metrics
| Graph Metric TonyAdmin: Overall Metrics Worksheet Overview This worksheet displays overall graph metrics, which can be calculated using NodeXL, Analysis, Graph Metrics in the Ribbon. It also displays overall readability metrics, which can be calculated using NodeXL, Graph, Layout, Calculate Readability Metrics. | Value | Degree Bin | Degree Frequency | In-Degree Bin | In-Degree Frequency | Out-Degree Bin | Out-Degree Frequency | Betweenness Centrality Bin | Betweenness Centrality Frequency | Closeness Centrality Bin | Closeness Centrality Frequency | Eigenvector Centrality Bin | Eigenvector Centrality Frequency | PageRank Bin | PageRank Frequency | Clustering Coefficient Bin | Clustering Coefficient Frequency | Dynamic Filter Bin | Dynamic Filter Frequency | Histogram Property | Value | ||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | Bin Divisor | 43 | ||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | No Metric Message | Not Available | ||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | Dynamic Filter Source Column Range | TableName[ColumnName] | ||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| Readability Metric | Value | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||||
| Minimum Degree | Not Available | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||
| Maximum Degree | Not Available | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||
| Average Degree | Not Available | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | ERROR:#REF! | ERROR:#REF! | ||||
| Median Degree | Not Available | ||||||||||||||||||||||
| Minimum In-Degree | Not Available | ||||||||||||||||||||||
| Maximum In-Degree | Not Available | ||||||||||||||||||||||
| Average In-Degree | Not Available | ||||||||||||||||||||||
| Median In-Degree | Not Available | ||||||||||||||||||||||
| Minimum Out-Degree | Not Available | ||||||||||||||||||||||
| Maximum Out-Degree | Not Available | ||||||||||||||||||||||
| Average Out-Degree | Not Available | ||||||||||||||||||||||
| Median Out-Degree | Not Available | ||||||||||||||||||||||
| Minimum Betweenness Centrality | Not Available | ||||||||||||||||||||||
| Maximum Betweenness Centrality | Not Available | ||||||||||||||||||||||
| Average Betweenness Centrality | Not Available | ||||||||||||||||||||||
| Median Betweenness Centrality | Not Available | ||||||||||||||||||||||
| Minimum Closeness Centrality | Not Available | ||||||||||||||||||||||
| Maximum Closeness Centrality | Not Available | ||||||||||||||||||||||
| Average Closeness Centrality | Not Available | ||||||||||||||||||||||
| Median Closeness Centrality | Not Available | ||||||||||||||||||||||
| Minimum Eigenvector Centrality | Not Available | ||||||||||||||||||||||
| Maximum Eigenvector Centrality | Not Available | ||||||||||||||||||||||
| Average Eigenvector Centrality | Not Available | ||||||||||||||||||||||
| Median Eigenvector Centrality | Not Available | ||||||||||||||||||||||
| Minimum PageRank | Not Available | ||||||||||||||||||||||
| Maximum PageRank | Not Available | ||||||||||||||||||||||
| Average PageRank | Not Available | ||||||||||||||||||||||
| Median PageRank | Not Available | ||||||||||||||||||||||
| Minimum Clustering Coefficient | Not Available | ||||||||||||||||||||||
| Maximum Clustering Coefficient | Not Available | ||||||||||||||||||||||
| Average Clustering Coefficient | Not Available | ||||||||||||||||||||||
| Median Clustering Coefficient | Not Available |
Degree
Frequency
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0In-Degree
Frequency
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0Out-Degree
Frequency
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0Betweenness Centrality
Frequency
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0Closeness Centrality
Frequency
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0Eigenvector Centrality
Frequency
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0Clustering Coefficient
Frequency
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0PageRank
Frequency
Misc
| Valid Edge Visibilities | Valid Edge Styles | Valid Vertex Visibilities | Valid Vertex Shapes | Valid Group Shapes | Valid Group Visibilities | Valid Booleans Default False | Valid Vertex Label Positions | Per-Workbook Setting | Value | Table Name | Column Name | Selected Minimum | Selected Maximum | ||||
| Show | Solid | Show if in an Edge | Circle | Circle | Show | No | Nowhere | Template Version | 108 | ||||||||
| Skip | Dash | Skip | Disk | Disk | Skip | Yes | Top Left | Graph Directedness | Undirected | ||||||||
| Hide | Dot | Hide | Sphere | Sphere | Hide | 0 | Top Center | Auto Layout on Open | |||||||||
| 1 | Dash Dot | Show | Square | Square | 1 | 1 | Top Right | Workbook Settings 1 | <?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <section name="GeneralUserSettings4" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" /> <section name="GraphZoomAndScaleUserSettings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" /> </sectionGroup> </configSections> <userSettings> <GeneralUserSettings4> <setting name="ReadGroupLabels" serializeAs="String"> <value>True</value> </setting> <setting name="ReadVertexLabels" serializeAs="String"> <value>True</value> </setting> <setting name="ReadEdgeLabels" serializeAs="String"> <value>True</value> </setting> <setting name="ShowGraphLegend" serializeAs="String"> <value>False</value> </setting> <setting name="ShowGraphAxes" serializeAs="String"> <value>False</value> </setting> </GeneralUserSettings4> <GraphZoomAndScaleUserSettings> <setting name="GraphScale" serializeAs="String"> <value>1</value> </setting> </GraphZoomAndScaleUserSettings> </userSettings> </configuration> | ||||||||
| 0 | Dash Dot Dot | 1 | Solid Square | Solid Square | 0 | Middle Left | Workbook Settings Cell Count | 1 | The empty chart above is used to create histogram images for dynamic filters. It is associated with two columns in the HistogramBins table on the Overall Metrics worksheet, and on the HistogramProperties table on that worksheet. The chart is on this worksheet instead of the more logical Overall Metrics worksheet because the chart must be visible for a histogram image to be created. If the chart where in Overall Metrics in a visible range the user would see it, whereas the user never sees this Misc worksheet because the entire worksheet is hidden. | ||||||||
| 2 | 1 | 0 | Diamond | Diamond | 2 | Middle Center | |||||||||||
| 2 | 2 | Solid Diamond | Solid Diamond | Middle Right | |||||||||||||
| 3 | 4 | Triangle | Triangle | Bottom Left | |||||||||||||
| 4 | Solid Triangle | Solid Triangle | Bottom Center | ||||||||||||||
| 5 | Label | 1 | Bottom Right | ||||||||||||||
| Image | 2 | 0 | |||||||||||||||
| 1 | 3 | 1 | |||||||||||||||
| 2 | 4 | 2 | |||||||||||||||
| 3 | 5 | 3 | |||||||||||||||
| 4 | 6 | 4 | |||||||||||||||
| 5 | 7 | 5 | |||||||||||||||
| 6 | 8 | 6 | |||||||||||||||
| 7 | 9 | 7 | |||||||||||||||
| 8 | 8 | ||||||||||||||||
| 9 | 9 | ||||||||||||||||
| 10 | |||||||||||||||||
| 11 |
