70 likes | 179 Vues
TANGO is a comprehensive framework developed by Sean Kelley at Rensselaer Polytechnic Institute, designed for analyzing tables and generating ontologies in electrical engineering. It utilizes concept diagrams to elucidate the function of tables and XY trees, providing a structured understanding of data relationships. The framework highlights differences in table formatting and importation between Excel and OpenOffice. Notable features include OpenOffice's support for a language akin to Microsoft VBA, enhancing compatibility for program conversion, alongside its Python support for advanced scripting.
E N D
TANGO – Table Analysis for Generating Ontologies Sean Kelley Rensselaer Polytechnic Institute 2011 Electrical Engineering
Table Ontology • Concept diagrams will help us understand the function of tables and XY trees
Initial concept diagram for table Table 4:* 1 Cell 2:* has Stub (1) Delta cell Data value 1 1:* has 1 Label Header Is defined by U+ Row header Column header 1:* 1:*
Initial XY Tree concept diagram XY Tree 6:* 7:* 1 1:* 2 Node Branch Connects to 1 has 1 Label Leaf Node Intermediate Node Cut Type (H or V) Root Node (1)
Using OpenOffice • There are several differences in the ways that Excel and OpenOffice Calc import tables from the web. • OpenOffice preserves formatting (boldface, justification, etc) while Excel does not • Excel imports the title of the table, while OpenOffice does not • Excel imports indentations, while OpenOffice does not
Table comparison Excel OpenOffice
For macros, OpenOffice uses a language called OpenOffice Basic, which is very similar to Microsoft VBA • This will make it simple to convert Ramana’s programs to run in OpenOffice. • OpenOffice also supports Python.