{"id":12430,"date":"2023-10-16T17:04:18","date_gmt":"2023-10-16T08:04:18","guid":{"rendered":"https:\/\/prodskill.com\/?p=12430"},"modified":"2023-10-16T17:12:34","modified_gmt":"2023-10-16T08:12:34","slug":"data-standard-checker-v1-40","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/","title":{"rendered":"Distribution of data standard check tool v1.40_20231016"},"content":{"rendered":"<p>We distribute data standard check tool v1.40_20231016, which complements the physical name-based standard check function similarly to the logical name-based standard check function and adds an option to remove and check the numeric suffix first. The previous version was v1.37.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/#1_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v137_20230923%EC%97%90_%EA%B5%AC%ED%98%84%EB%90%98%EC%A7%80_%EC%95%8A%EC%9D%80_%EA%B8%B0%EB%8A%A5\" >1. Functions not implemented in data standard check tool v1.37_20230923<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/#2_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v140_20231016_%EA%B5%AC%ED%98%84_%EB%82%B4%EC%9A%A9\" >2. Data standard check tool v1.40_20231016 implementation details<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/#21_%EC%88%AB%EC%9E%90_Suffix_%EC%A0%9C%EA%B1%B0%ED%9B%84_%EC%A0%90%EA%B2%80_%EA%B2%B0%EA%B3%BC_%EC%98%88%EC%8B%9C_v137%EA%B9%8C%EC%A7%80%EC%9D%98_%EB%8F%99%EC%9E%91_%EB%B0%A9%EC%8B%9D\" >2.1. Example of inspection results after removing numeric suffix (operation method up to v1.37)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/#22_%EC%88%AB%EC%9E%90_Suffix_%EC%A0%9C%EA%B1%B0%ED%95%98%EC%A7%80_%EC%95%8A%EA%B3%A0_%EC%A0%90%EA%B2%80_%EA%B2%B0%EA%B3%BC_%EC%98%88%EC%8B%9Cv140%EC%97%90%EC%84%9C_%EC%83%88%EB%A1%9C_%EC%B6%94%EA%B0%80%EB%90%9C_%EB%8F%99%EC%9E%91_%EB%B0%A9%EC%8B%9D\" >2.2. Example of check result without removing numeric suffix (new operation method added in v1.40)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/#23_%EB%85%BC%EB%A6%AC%EB%AA%85_%EB%AC%BC%EB%A6%AC%EB%AA%85_%EC%A0%90%EA%B2%80_%EA%B8%B0%EB%8A%A5_%EC%88%98%EC%A0%95\" >2.3. Modification of logical name and physical name check function<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/#3_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v140_20231016_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C\" >3. Download data standard check tool v1.40_20231016<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/#4_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v140_20231016_%EC%9D%BC%EB%9F%AC%EB%91%90%EA%B8%B0\" >4. Data standard check tool v1.40_20231016 Note<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v137_20230923%EC%97%90_%EA%B5%AC%ED%98%84%EB%90%98%EC%A7%80_%EC%95%8A%EC%9D%80_%EA%B8%B0%EB%8A%A5\"><\/span>1. Functions not implemented in data standard check tool v1.37_20230923<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In the data standard check tool v1.37_20230923, there are many items that are not displayed as check results when checking the standard based on physical names, as shown in the figure below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"537\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1024x537.png\" alt=\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.37_20230923 \uc5d0\uc11c \ubb3c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900 \uc810\uac80\uc2dc \uc810\uac80\uacb0\uacfc\ub85c \ud45c\uc2dc\ub418\uc9c0 \uc54a\uc740 \ud56d\ubaa9\" class=\"wp-image-12431\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1024x537.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-300x157.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-768x403.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-48x25.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image.png 1075w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Items not displayed as inspection results when performing standard inspection based on physical name in data standard inspection tool v1.37_20230923<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Items that are not displayed are as follows.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Combination of standard words and physical names<\/li>\n\n\n\n<li>Attribute Name Check Result<\/li>\n\n\n\n<li>Standard terms Type\/Size<\/li>\n\n\n\n<li>attribute name terminator<\/li>\n\n\n\n<li>Property name terminator check result<\/li>\n\n\n\n<li>Domain, Data Type Check Result<\/li>\n\n\n\n<li>Additional candidate words<\/li>\n<\/ul>\n\n\n\n<p>Anything other than \u201cstandard word logical name combination\u201d is not displayed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v140_20231016_%EA%B5%AC%ED%98%84_%EB%82%B4%EC%9A%A9\"><\/span>2. Data standard check tool v1.40_20231016 implementation details<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A standard check (based on physical name) function was added as follows.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Added standard dictionary search option (word &amp; term, word, term selection)<\/li>\n\n\n\n<li>Add inspection result output (standard word physical name combination, physical name inspection result, standard term Type\/Size, attribute name terminator, attribute name terminator inspection result, domain, Data Type inspection result, additional candidate words)\n<ul class=\"wp-block-list\">\n<li>Until v1.37, only standard word logical name combinations are output in the inspection results.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Add check option after removing number suffix\n<ul class=\"wp-block-list\">\n<li>Select the check method if there is a number at the end of the column name (physical name) (when checking, remove the suffix and check as in the check based on logical name)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Assuming that the standard word dictionary contains the following standard words, let&#039;s look at an example result according to the \u201cCheck after removing number suffix\u201d option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"267\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1.png\" alt=\"\ud45c\uc900\ub2e8\uc5b4\uc0ac\uc804 \uc608\uc2dc\" class=\"wp-image-12432\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1.png 494w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1-300x162.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-1-48x26.png 48w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/a><figcaption class=\"wp-element-caption\">Standard word dictionary example<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21_%EC%88%AB%EC%9E%90_Suffix_%EC%A0%9C%EA%B1%B0%ED%9B%84_%EC%A0%90%EA%B2%80_%EA%B2%B0%EA%B3%BC_%EC%98%88%EC%8B%9C_v137%EA%B9%8C%EC%A7%80%EC%9D%98_%EB%8F%99%EC%9E%91_%EB%B0%A9%EC%8B%9D\"><\/span>2.1. Example of inspection results after removing numeric suffix (operation method up to v1.37)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"541\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-1024x541.png\" alt=\"\uc22b\uc790 Suffix \uc81c\uac70\ud6c4 \uc810\uac80 \uacb0\uacfc \uc608\uc2dc (v1.37\uae4c\uc9c0\uc758 \ub3d9\uc791 \ubc29\uc2dd)\" class=\"wp-image-12434\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-1024x541.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-300x159.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-768x406.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3-48x25.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-3.png 1396w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Example of inspection results after removing numeric suffix (operation method up to v1.37)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Column name \u201cH01\u2033 outputs the result by checking only \u201cH\u201d by first removing \u201c01\u201d, which is the number suffix before inspection. Accordingly, only \u201cH\u201d was recommended as an additional candidate word. The column names \u201cH02\u201d, \u201cH11\u201d, and \u201cDMD_H01\u201d are all the same.<\/p>\n\n\n\n<p>In this case, even if \u201cH01\u201d, \u201cH02\u201d, etc. are registered in the standard word dictionary, the number Siffix is removed first and does not match as a standard word.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22_%EC%88%AB%EC%9E%90_Suffix_%EC%A0%9C%EA%B1%B0%ED%95%98%EC%A7%80_%EC%95%8A%EA%B3%A0_%EC%A0%90%EA%B2%80_%EA%B2%B0%EA%B3%BC_%EC%98%88%EC%8B%9Cv140%EC%97%90%EC%84%9C_%EC%83%88%EB%A1%9C_%EC%B6%94%EA%B0%80%EB%90%9C_%EB%8F%99%EC%9E%91_%EB%B0%A9%EC%8B%9D\"><\/span>2.2. Example of check result without removing numeric suffix (new operation method added in v1.40)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"717\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-1024x717.png\" alt=\"\uc22b\uc790 Suffix \uc81c\uac70\ud558\uc9c0 \uc54a\uace0 \uc810\uac80 \uacb0\uacfc \uc608\uc2dc(v1.40\uc5d0\uc11c \uc0c8\ub85c \ucd94\uac00\ub41c \ub3d9\uc791 \ubc29\uc2dd)\" class=\"wp-image-12435\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-1024x717.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-300x210.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-768x537.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4-48x34.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png 1396w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Example of check result without removing numeric suffix (new operation method added in v1.40)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If the numeric suffix is not removed, the column names \u201cH01\u201d, \u201cH02\u201d, and \u201cDMD_H01\u201d are output by matching standard words. In the above example, \u201cH11\u201d is not registered in the standard word dictionary, so it is displayed as \u201cNo standard word\u201d and \u201cH11\u201d is recommended as an additional candidate word.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"23_%EB%85%BC%EB%A6%AC%EB%AA%85_%EB%AC%BC%EB%A6%AC%EB%AA%85_%EC%A0%90%EA%B2%80_%EA%B8%B0%EB%8A%A5_%EC%88%98%EC%A0%95\"><\/span>2.3. Modification of logical name and physical name check function<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The following items were commonly modified and reflected in the attribute standard check (based on logical name) and standard check (based on physical name) sheets.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When checking \u201cSelected properties only\u201d and clearing, change to clear only the selected properties (previously, all properties were cleared)<\/li>\n\n\n\n<li>Domain and Data Type inspection results: Changed so that Type and Size inspection results are output separately.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v140_20231016_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C\"><\/span>3. Download data standard check tool v1.40_20231016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can download it from the github URL below.<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DAToolset\/ToolsForDataStandard\/raw\/main\/\uc18d\uc131%20\ud45c\uc900\uc810\uac80%20\ub3c4\uad6c_v1.40_20231016_1.xlsm\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/DAToolset\/ToolsForDataStandard\/raw\/main\/\uc18d\uc131%20\ud45c\uc900\uc810\uac80%20\ub3c4\uad6c_v1.40_20231016_1.xlsm<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC_v140_20231016_%EC%9D%BC%EB%9F%AC%EB%91%90%EA%B8%B0\"><\/span>4. Data standard check tool v1.40_20231016 Note<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>As for the standard inspection based on physical names, features are being added little by little whenever there is a user request. Since I am not directly carrying out the standardization work and am only adding features, it is difficult to know if there are any inconveniences in use.<\/p>\n\n\n\n<p>If you have any comments or suggestions for improvement regarding v1.40, please leave a comment.<\/p>","protected":false},"excerpt":{"rendered":"<p>We distribute data standard check tool v1.40_20231016, which complements the physical name-based standard check function similarly to the logical name-based standard check function and adds an option to remove and check the numeric suffix first. The previous version was v1.37. 1. Functions not implemented in data standard check tool v1.37_20230923 Data standard check tool v1.37_20230923...<\/p>","protected":false},"author":1,"featured_media":12435,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[17,73,113,114],"class_list":["post-12430","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-standard-checker","tag-vba","tag-excel-vba","tag-113","tag-114"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\ubb3c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uc744 \ub17c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uacfc \uc720\uc0ac\ud558\uac8c \ubcf4\uc644\ud558\uace0 \uc22b\uc790 Suffix \ub97c \uba3c\uc800 \uc81c\uac70\ud558\uace0 \uc810\uac80\ud560\uc9c0 \uc635\uc158\uc744 \ucd94\uac00\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \uc744 \ubc30\ud3ec\ud55c\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\ubb3c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uc744 \ub17c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uacfc \uc720\uc0ac\ud558\uac8c \ubcf4\uc644\ud558\uace0 \uc22b\uc790 Suffix \ub97c \uba3c\uc800 \uc81c\uac70\ud558\uace0 \uc810\uac80\ud560\uc9c0 \uc635\uc158\uc744 \ucd94\uac00\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \uc744 \ubc30\ud3ec\ud55c\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-16T08:04:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-16T08:12:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1396\" \/>\n\t<meta property=\"og:image:height\" content=\"977\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec\",\"datePublished\":\"2023-10-16T08:04:18+00:00\",\"dateModified\":\"2023-10-16T08:12:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/\"},\"wordCount\":69,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"Excel VBA\",\"\ub370\uc774\ud130 \ud45c\uc900\",\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80\"],\"articleSection\":[\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/\",\"url\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/\",\"name\":\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png\",\"datePublished\":\"2023-10-16T08:04:18+00:00\",\"dateModified\":\"2023-10-16T08:12:34+00:00\",\"description\":\"\ubb3c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uc744 \ub17c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uacfc \uc720\uc0ac\ud558\uac8c \ubcf4\uc644\ud558\uace0 \uc22b\uc790 Suffix \ub97c \uba3c\uc800 \uc81c\uac70\ud558\uace0 \uc810\uac80\ud560\uc9c0 \uc635\uc158\uc744 \ucd94\uac00\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \uc744 \ubc30\ud3ec\ud55c\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png\",\"width\":1396,\"height\":977},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prodskill.com\/ko\/#website\",\"url\":\"https:\/\/prodskill.com\/ko\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prodskill.com\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\"},\"url\":\"https:\/\/prodskill.com\/en\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Standard Check Tool v1.40_20231016 Released - Productivity Skill","description":"We are distributing the data standard inspection tool v1.40_20231016, which supplements the standard inspection function based on physical names to be similar to the standard inspection function based on logical names, and adds an option to remove and inspect numeric suffixes first.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/","og_locale":"en_US","og_type":"article","og_title":"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill","og_description":"\ubb3c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uc744 \ub17c\ub9ac\uba85 \uae30\uc900 \ud45c\uc900\uc810\uac80 \uae30\ub2a5\uacfc \uc720\uc0ac\ud558\uac8c \ubcf4\uc644\ud558\uace0 \uc22b\uc790 Suffix \ub97c \uba3c\uc800 \uc81c\uac70\ud558\uace0 \uc810\uac80\ud560\uc9c0 \uc635\uc158\uc744 \ucd94\uac00\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \uc744 \ubc30\ud3ec\ud55c\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/data-standard-checker-v1-40\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2023-10-16T08:04:18+00:00","article_modified_time":"2023-10-16T08:12:34+00:00","og_image":[{"width":1396,"height":977,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec","datePublished":"2023-10-16T08:04:18+00:00","dateModified":"2023-10-16T08:12:34+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/"},"wordCount":69,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png","keywords":["\uc5d1\uc140VBA","Excel VBA","\ub370\uc774\ud130 \ud45c\uc900","\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80"],"articleSection":["\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/data-standard-checker-v1-40\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/","url":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/","name":"Data Standard Check Tool v1.40_20231016 Released - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png","datePublished":"2023-10-16T08:04:18+00:00","dateModified":"2023-10-16T08:12:34+00:00","description":"We are distributing the data standard inspection tool v1.40_20231016, which supplements the standard inspection function based on physical names to be similar to the standard inspection function based on logical names, and adds an option to remove and inspect numeric suffixes first.","breadcrumb":{"@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/data-standard-checker-v1-40\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2023\/10\/image-4.png","width":1396,"height":977},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/data-standard-checker-v1-40\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c v1.40_20231016 \ubc30\ud3ec"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/12430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=12430"}],"version-history":[{"count":3,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/12430\/revisions"}],"predecessor-version":[{"id":12438,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/12430\/revisions\/12438"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/12435"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=12430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=12430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=12430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}