{"id":467,"date":"2018-09-26T11:15:15","date_gmt":"2018-09-26T11:15:15","guid":{"rendered":"http:\/\/avpsoft.com\/blog\/?p=467"},"modified":"2018-09-26T11:15:15","modified_gmt":"2018-09-26T11:15:15","slug":"apfill_using_excel_template_page_dimension","status":"publish","type":"post","link":"https:\/\/avpsoft.com\/blog\/2018\/09\/26\/apfill_using_excel_template_page_dimension\/","title":{"rendered":"Example of configuring an Excel template in APFill software to display the page size in inches or millimeters"},"content":{"rendered":"<p>Starting from <a href=\"\/products\/apfill\/\">APFill 5.6<\/a>, the program allows users <a href=\"\/blog\/2012\/08\/29\/apfill_using_excel_templates\/\">to use MS Excel files as templates<\/a> for processing the results of document toner coverage measurements.<br \/>\n<!--more--><\/p>\n<p>If the default template is used, APFill will process a PDF file and generate a new Excel file of the following form containing the results of CMYK toner coverage measurements.<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2018\/09\/apfill_template_page_dimension_0.png \" alt=\"APFill using Excel templates to know PDF page dimension default\" \/><\/p>\n<p>Let&#8217;s consider a situation where we need to specify the size of each page in inches or millimeters. APFill shows the coverage ratio for each page in the results table, as well as <a href=\"\/blog\/2012\/08\/29\/apfill_using_excel_templates\/\" title=\"APFill: resolution and default page size\">its size in pixels and the resolution used for  PDF file rasterization<\/a>. This data is sufficient for determining the size of each page in inches or millimeters. To do it, you need to add extra columns containing the formulas below to the Excel template.<\/p>\n<p><code>Page Width in inches = Page Width in pixels\/Resolution<\/code><\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2018\/09\/apfill_template_page_dimension_1.png \" alt=\"APFill using Excel templates to know PDF page dimension width inches\" \/><\/p>\n<p><code>Page Width in millimeters = (Page Width in pixels\/Resolution)*25.4<\/code><br \/>\nWhere <strong>25.4<\/strong> is the ratio for converting inches to millimeters.<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2018\/09\/apfill_template_page_dimension_2.png \" alt=\"APFill using Excel templates to know PDF page dimension width mm\" \/><\/p>\n<p>Identical formulas are added for the page height.<\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2018\/09\/apfill_template_page_dimension_3.png \" alt=\"APFill using Excel templates to know PDF page dimension height inches\" \/><\/p>\n<p><img src=\"\/blog\/wp-content\/uploads\/2018\/09\/apfill_template_page_dimension_4.png \" alt=\"APFill using Excel templates to know PDF page dimension height mm\" \/><\/p>\n<p>This is how adding formulas to the default template helps you configure APFill to calculate all the necessary CMYK toner coverage measurements for a PDF file.<\/p>\n<p>Related links:<\/p>\n<p><a href=\"\/products\/apfill\/\">Download a trial version of APFill Ink Coverage Calculator<\/a><\/p>\n<p><a href=\"\/blog\/2012\/08\/29\/apfill_using_excel_templates\/\"> Using MS Excel templates in APFill for processing results.<\/a><\/p>\n<p><a href=\"\/products\/apfill\/apfill_users_guide\/\"> APFill User\u2019s Manual<\/a><\/p>\n<p><a href=\"\/blog\/2010\/12\/10\/apfill-ink-coverage-calculator-resolution-page-size-parameters\/\">APFill: \u201cresolution\u201d and \u201cdefault page size\u201d parameters<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Starting from APFill 5.6, the program allows users to use MS Excel files as templates for processing the results of document toner 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,13,14],"_links":{"self":[{"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/posts\/467"}],"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=467"}],"version-history":[{"count":4,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/posts\/467\/revisions"}],"predecessor-version":[{"id":473,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/posts\/467\/revisions\/473"}],"wp:attachment":[{"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/avpsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}