Excel extractors - Revision history

Akivela at 15:32, 3 March 2015

2015-03-03T15:32:36Z

2013-09-25T18:27:04Z

‎Excel adjacency matrix extractor

2013-09-25T18:22:58Z

‎Excel adjacency matrix extractor

2013-09-25T18:22:34Z

‎Excel adjacency matrix extractor

2013-09-25T18:21:36Z

‎Excel adjacency matrix extractor

2013-09-25T17:45:16Z

‎Excel adjacency list extractor

2013-09-25T17:44:07Z

‎Excel adjacency list extractor

2013-09-24T18:57:22Z

2013-09-24T18:53:14Z

2013-09-24T18:51:28Z

‎See also

@@ Line 46: / Line 46: @@
-Wandora features a [[Graph topic panel]] used to visualize topics. Next screen capture views created adjacency matrix associations in Graph topic panel. Graph contains three separate subgraphs. Graph topic panel doesn't view topic's associations with it self. Thus, '''Player9''' seems to be alone.
+Wandora features a [[Graph topic panel]] used to visualize topics. Next screen capture views created adjacency matrix associations in Graph topic panel. Graph contains three separate subgraphs. Graph topic panel doesn't view topic's associations with itself. Hence the '''Player9''' seems to be alone.
@@ Line 65: / Line 65: @@
 == Excel sheet extractor ==
-Extractors described above process all sheets in the spreadsheet file. Some times this is not a good idea. Different sheets may have different cell layout. Excel sheet extractor is a meta extractor that collects all other extractors under a single interface and allows the user to decide which extractor is applied to which spreadsheet sheet. User can also skip sheets.
+Extractors described above process all sheets in the spreadsheet file. Sometimes this is not a good idea. Different sheets may have different cell layout. Excel sheet extractor is a meta extractor that collects all other extractors under a single interface and allows the user to decide which extractor is applied to which spreadsheet sheet. User can also skip sheets.
 == Spreadsheet cell topics ==

← Older revision		Revision as of 18:27, 25 September 2013
Line 46:		Line 46:


−	Wandora features a [[Graph topic panel]] used to visualize topics. Next screen capture views created adjacency matrix associations. Graph contains three separate subgraphs. Graph topic panel doesn't view topic's associations with it self. Thus, '''Player9''' seems to be alone.	+	Wandora features a [[Graph topic panel]] used to visualize topics. Next screen capture views created adjacency matrix associations in Graph topic panel. Graph contains three separate subgraphs. Graph topic panel doesn't view topic's associations with it self. Thus, '''Player9''' seems to be alone.

← Older revision		Revision as of 18:22, 25 September 2013
Line 46:		Line 46:


−	Wandora features a [[Graph topic panel]] used to visualize topics. Next screen capture views created adjacency matrix associations. Graph contains three separate subgraphs. Graph topic panel doesn't view topic's associations with it self. Thus, '''~~Topic9~~''' seems to be alone.	+	Wandora features a [[Graph topic panel]] used to visualize topics. Next screen capture views created adjacency matrix associations. Graph contains three separate subgraphs. Graph topic panel doesn't view topic's associations with it self. Thus, '''Player9''' seems to be alone.

@@ Line 43: / Line 43: @@
-[[File:excel_adjacency_matrix_extracted.png|center]]
+[[File:excel_association_matrix_extracted.png|center]]
@@ Line 49: / Line 49: @@
-[[File:excel_adjacency_matrix_extracted_as_graph.png|center]]
+[[File:excel_association_matrix_extracted_as_graph.png|center]]
 == Excel topic tree extractor ==

← Older revision		Revision as of 18:21, 25 September 2013
Line 33:		Line 33:

	Excel adjacency matrix extractor interprets the spreadsheet as a matrix where first row and first column are topics. Whenever a spreadsheet cell has a value, Wandora creates an association between column and row topics.		Excel adjacency matrix extractor interprets the spreadsheet as a matrix where first row and first column are topics. Whenever a spreadsheet cell has a value, Wandora creates an association between column and row topics.
		+
		+	Next screen capture views an adjacency matrix in OpenOffice Calc. First row and column contains labels that will be topics in Wandora. Cell value '''X''' marks an association between row and column topics.
		+
		+
		+	[[File:excel_adjacency_matrix.png\|center]]
		+
		+
		+	When the XSL file is extracted, Wandora creates topics and associations. Next screen capture views Wandora after extraction. Wandora views all created associations.
		+
		+
		+	[[File:excel_adjacency_matrix_extracted.png\|center]]
		+
		+
		+	Wandora features a [[Graph topic panel]] used to visualize topics. Next screen capture views created adjacency matrix associations. Graph contains three separate subgraphs. Graph topic panel doesn't view topic's associations with it self. Thus, '''Topic9''' seems to be alone.
		+
		+
		+	[[File:excel_adjacency_matrix_extracted_as_graph.png\|center]]

	== Excel topic tree extractor ==		== Excel topic tree extractor ==

@@ Line 20: / Line 20: @@
 Next screen capture views a simple adjacency list in OpenOffice Calc. First row contains roles and all next rows association player pairs.
 [[File:excel_adjacency_list.png|center]]
-When the XSL file is extracted, the Wandora creates topics for each spreadsheet cell and associations for each row. Next screen capture views Wandora's association type topic and all associations.
 [[File:excel_adjacency_list_extracted.png|center]]

← Older revision		Revision as of 17:44, 25 September 2013
Line 18:		Line 18:

	Excel adjacency list extractor interprets each spreadsheet row as an association. First row specifies association role types. Each column represents one player in the association. If column has no value, the player is ignored. Association type is a default Excel association type topic.		Excel adjacency list extractor interprets each spreadsheet row as an association. First row specifies association role types. Each column represents one player in the association. If column has no value, the player is ignored. Association type is a default Excel association type topic.
		+
		+	Next screen capture views a simple adjacency list in OpenOffice Calc. First row contains roles and all next rows association player pairs.
		+
		+	[[File:excel_adjacency_list.png\|center]]
		+
		+	When the XSL file is extracted, the Wandora creates topics for each spreadsheet cell and associations for each row. Next screen capture views Wandora's association type topic and all associations.
		+
		+	[[File:excel_adjacency_list_extracted.png\|center]]

	== Excel adjacency matrix extractor ==		== Excel adjacency matrix extractor ==

@@ Line 49: / Line 49: @@
 * [[Adjacency matrix import]]
 * [[Export adjacency matrix]]
 __NOTOC__

@@ Line 47: / Line 47: @@
 * Wandora features also a [[Simple CSV association extractor]] that resembles the '''Excel adjacency list extractor''' but doesn't interpret the first row columns as association roles.
 * [[Adjacency list import]]
 * [[Adjacency matrix import]]
 __NOTOC__