{"id":259,"date":"2017-02-28T15:57:42","date_gmt":"2017-02-28T14:57:42","guid":{"rendered":"http:\/\/spreadsheets.ist.tugraz.at\/?page_id=259"},"modified":"2017-11-22T16:13:57","modified_gmt":"2017-11-22T15:13:57","slug":"fritz","status":"publish","type":"page","link":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/software\/fritz\/","title":{"rendered":"Fritz"},"content":{"rendered":"<p>Fritz is a stand-alone Java application that provides spreadsheet analysis, visualization, and evaluation. \u00a0Fritz computes advanced structures such as:<\/p>\n<ul>\n<li>Partitioned formula groups,<\/li>\n<li>Reference-based groups,<\/li>\n<li>Computation blocks, and<\/li>\n<li>Headers.<\/li>\n<\/ul>\n<p>More information about the implemented structure analysis process can be found in our IWPD&#8217;16 paper (\u00a0<a href=\"http:\/\/ieeexplore.ieee.org\/stamp\/stamp.jsp?arnumber=7789397\">Static Spreadsheet Analysis<\/a>)\u00a0 and in our <a href=\"https:\/\/www.youtube.com\/watch?v=j2YTfDU2i98\">YouTube video<\/a>.<\/p>\n<p>Furthermore, Fritz can be used to check if a spreadsheet contains smells. Fritz detects the following\u00a0smells:<\/p>\n<ul>\n<li>Inter-worksheet smells (e.g., Feature Envy),<\/li>\n<li>Intra-worksheet smells (e.g., Long Calculation Chain),<\/li>\n<li>Input smells (e.g., Pattern Finder), and<\/li>\n<li>Structural smells (e.g., Overburdened Worksheet).<\/li>\n<\/ul>\n<p>The calculated smell metrics can be displayed in the GUI or exported to a CSV file.<\/p>\n<h2>Download<\/h2>\n<p>Version 1.0 of Fritz can be\u00a0download\u00a0<a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/fritz_v1.jar\">here<\/a>.<\/p>\n<p>The tool was tested on an x64 Windows 10 machine, using JRE 1.8.0_121-b13.<\/p>\n<h2>Usage<\/h2>\n<p>Fritz can be used as command-line tool. Start it by the command<\/p>\n<pre style=\"padding-left: 30px;\"><strong>java -jar fritz.jar <\/strong><\/pre>\n<p>We provide multiple command-line options. For an extensive list, start Fritz with the command<\/p>\n<pre style=\"padding-left: 30px;\"><strong>java -jar fritz.jar -help<\/strong><\/pre>\n<p>Fritz also provides a graphical user-interface. This is the\u00a0 default start option.<\/p>\n<h2>GUI<\/h2>\n<p>When starting Fritz with GUI, the main application window appears.<\/p>\n<figure id=\"attachment_286\" aria-describedby=\"caption-attachment-286\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_blank.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-286\" src=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_blank.jpg\" alt=\"\" width=\"627\" height=\"341\" srcset=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_blank.jpg 627w, https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_blank-300x163.jpg 300w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/a><figcaption id=\"caption-attachment-286\" class=\"wp-caption-text\">Fritz Application Window<\/figcaption><\/figure>\n<p>The following menus and underlying operations are available:<\/p>\n<ul>\n<li><strong>File<\/strong>\n<ul>\n<li><strong>Open<\/strong>: select a spreadsheet file to open via a file chooser.<\/li>\n<li><strong>Exit<\/strong>: ends the application<\/li>\n<\/ul>\n<\/li>\n<li><strong>View<\/strong>\n<ul>\n<li><strong>Indication Options Window<\/strong>: toggles the related GUI window<\/li>\n<li><strong>Context Information Window<\/strong>: toggles the related GUI window<\/li>\n<li><strong>Value View<\/strong>: toggles between formula- and value view for the display of formulas<\/li>\n<li><strong>R1C1 View<\/strong>: toggles between R1C1 and A1 style for the display of formulas<\/li>\n<\/ul>\n<\/li>\n<li><strong>Tools<\/strong>\n<ul>\n<li><strong>Preprocess Corpus<\/strong>: toggles the related GUI window<\/li>\n<li><strong>Start Corpus Evaluation<\/strong>: toggles the related GUI window<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Fritz provides different application windows to control visualization and initiate advanced operations:<\/p>\n<h4>Spreadsheet Visualizer<\/h4>\n<p>The main application window serves as visualizer for an opened spreadsheet file. Worksheets of the spreadsheet are displayed in separate windows.<\/p>\n<figure id=\"attachment_288\" aria-describedby=\"caption-attachment-288\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_openFile.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-288\" src=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_openFile.jpg\" alt=\"\" width=\"627\" height=\"341\" srcset=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_openFile.jpg 627w, https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_openFile-300x163.jpg 300w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/a><figcaption id=\"caption-attachment-288\" class=\"wp-caption-text\">Application window with open spreadsheet<\/figcaption><\/figure>\n<h4>Indication Options<\/h4>\n<p>Fritz provides a number of metric- and relation-indication options.<\/p>\n<ul>\n<li>Background Indications highlight specific cells in the main application window by applying background colors.<\/li>\n<li>Mouse-over Indications enable interactive coloring of cells in the main window based on a chosen relation<\/li>\n<li>Tool-Tip indications add specific tool-tips to cells in the main application window<\/li>\n<li>Indication Presets apply predefined sets of background, mouse-over, and tool-tip indications.<\/li>\n<\/ul>\n<figure id=\"attachment_284\" aria-describedby=\"caption-attachment-284\" style=\"width: 242px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_indication.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-284\" src=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_indication.jpg\" alt=\"\" width=\"242\" height=\"761\" srcset=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_indication.jpg 242w, https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_indication-95x300.jpg 95w\" sizes=\"auto, (max-width: 242px) 100vw, 242px\" \/><\/a><figcaption id=\"caption-attachment-284\" class=\"wp-caption-text\">Indication options window<\/figcaption><\/figure>\n<figure id=\"attachment_287\" aria-describedby=\"caption-attachment-287\" style=\"width: 627px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_groupIndication.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-287\" src=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_groupIndication.jpg\" alt=\"\" width=\"627\" height=\"341\" srcset=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_groupIndication.jpg 627w, https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_spreadsheet_groupIndication-300x163.jpg 300w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/a><figcaption id=\"caption-attachment-287\" class=\"wp-caption-text\">Application window with active background indication<\/figcaption><\/figure>\n<h4>Context Information<\/h4>\n<p>In this window, Fritz provides additional information and a number of calculated metrics for entities (cell, worksheet) related to the currently selected cell in the main application window.<\/p>\n<figure id=\"attachment_290\" aria-describedby=\"caption-attachment-290\" style=\"width: 660px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/02\/fritz_gui_window_contextInformation.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-290\" src=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/02\/fritz_gui_window_contextInformation.jpg\" alt=\"\" width=\"660\" height=\"761\" srcset=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/02\/fritz_gui_window_contextInformation.jpg 660w, https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/02\/fritz_gui_window_contextInformation-260x300.jpg 260w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><figcaption id=\"caption-attachment-290\" class=\"wp-caption-text\">Contextual information window<\/figcaption><\/figure>\n<h4>Corpus Preprocess Settings<\/h4>\n<p>This window provides access to various filtering operations that can be applied to a specified spreadsheet corpus.<\/p>\n<figure id=\"attachment_292\" aria-describedby=\"caption-attachment-292\" style=\"width: 727px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_preprocess.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-292\" src=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_preprocess.jpg\" alt=\"\" width=\"727\" height=\"293\" srcset=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_preprocess.jpg 727w, https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_preprocess-300x121.jpg 300w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/a><figcaption id=\"caption-attachment-292\" class=\"wp-caption-text\">Corpus preprocess window<\/figcaption><\/figure>\n<h4>Corpus Evaluation Settings<\/h4>\n<p>This window provides access to various evaluation operations that can be applied to a specified spreadsheet corpus.<\/p>\n<figure id=\"attachment_295\" aria-describedby=\"caption-attachment-295\" style=\"width: 728px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_evaluation.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-295\" src=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_evaluation.jpg\" alt=\"\" width=\"728\" height=\"293\" srcset=\"https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_evaluation.jpg 728w, https:\/\/spreadsheets.sai.tugraz.at\/wp-content\/uploads\/sites\/3\/2017\/03\/fritz_gui_window_evaluation-300x121.jpg 300w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><figcaption id=\"caption-attachment-295\" class=\"wp-caption-text\">Corpus evaluation window<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Fritz is a stand-alone Java application that provides spreadsheet analysis, visualization, and evaluation. \u00a0Fritz computes advanced structures such as: Partitioned formula groups, Reference-based groups, Computation blocks, and Headers. More information about the implemented structure analysis process can be found in our IWPD&#8217;16 paper (\u00a0Static Spreadsheet Analysis)\u00a0 and in our YouTube video. Furthermore, Fritz can be &hellip; <a href=\"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/software\/fritz\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Fritz<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":256,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-259","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/pages\/259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/comments?post=259"}],"version-history":[{"count":24,"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/pages\/259\/revisions"}],"predecessor-version":[{"id":368,"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/pages\/259\/revisions\/368"}],"up":[{"embeddable":true,"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/pages\/256"}],"wp:attachment":[{"href":"https:\/\/spreadsheets.sai.tugraz.at\/index.php\/wp-json\/wp\/v2\/media?parent=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}