{"id":267,"date":"2012-08-29T06:42:13","date_gmt":"2012-08-29T06:42:13","guid":{"rendered":"http:\/\/avpsoft.com\/blog\/?p=267"},"modified":"2012-08-29T06:42:13","modified_gmt":"2012-08-29T06:42:13","slug":"apfill_using_excel_templates","status":"publish","type":"post","link":"https:\/\/avpsoft.com\/blog\/2012\/08\/29\/apfill_using_excel_templates\/","title":{"rendered":"Using MS Excel templates in APFill for processing results."},"content":{"rendered":"<p><a href=\"\/products\/apfill\/\">APFill 5.6<\/a> allows users to use MS Excel files as templates for processing the results of document coverage measurements.<br \/>\n<!--more--><\/p>\n<p>The program installation package includes one default template (default_template.xls). The user can use any XLS file as a template. A result processing template is an MS Excel file with one its cells (on any sheet) containing the <strong>&#8220;##RESULTS&#8221;<\/strong> keyword. This keyword marks the start of the area that will be filled with values from APFill.<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2011\/09\/apfill_template_example.png \" alt=\"APFill using templates example\" \/><\/p>\n<p>As the result, APFill will process this template and generate a resulting file containing measurement results.<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2011\/09\/apfill_template_example2.png  \" alt=\"APFill using templates example results\" \/><\/p>\n<p>The template file is configured in the &#8220;Options&#8221; window.<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2011\/09\/apfill_template_options.png\" alt=\"APFill using templates options\" \/><\/p>\n<p>If the <strong>&#8220;Open Excel template automatically&#8221;<\/strong> option is enabled, APFill will use this document to automatically generate and open an MS Excel file with measurement results.<\/p>\n<p>If this option is disabled, APFill will open a standard results window after completing the measurement. In this case, the user will need to click <strong>\u201cOpen in Excel\u201d<\/strong> to generate an MS Excel file based on this template.<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2011\/09\/apfill_results_dialog.png\" alt=\"APFill using templates results\" \/><\/p>\n<p>Therefore, users can use this template, formulas and macros to perform all kinds of calculations with APFill measurement data.<\/p>\n<p>For instance, the default template contains formulas that adapt data for A4 sheet coverage (the <strong>&#8220;Equivalent A4 coverage&#8221;<\/strong> sheet) and calculate document-wide statistical values (sum, max CMYK coverage, average coverage). Besides, the &#8220;Chart&#8221; sheet contains a chart reflecting the CMYK coverage for the analyzed document<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2011\/09\/apfill_default_template_1.png\" alt=\"APFill using templates default template\" \/><\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2011\/09\/apfill_default_template_2.png\" alt=\"APFill using templates default template A4 equivalent\" \/><\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2011\/09\/apfill_default_template_3.png\" alt=\"APFill using templates default template CMYK chart\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>APFill 5.6 allows users to use MS Excel files as templates for processing the results of document coverage measurements.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[25,14,18],"_links":{"self":[{"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/posts\/267"}],"collection":[{"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=267"}],"version-history":[{"count":3,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/posts\/267\/revisions"}],"predecessor-version":[{"id":284,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/posts\/267\/revisions\/284"}],"wp:attachment":[{"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}