{"id":529,"date":"2022-11-11T02:08:00","date_gmt":"2022-11-10T20:38:00","guid":{"rendered":"https:\/\/www.lexadept.com\/?p=529"},"modified":"2024-02-23T05:54:29","modified_gmt":"2024-02-23T00:24:29","slug":"patent-tool","status":"publish","type":"post","link":"https:\/\/www.lexadept.com\/?p=529","title":{"rendered":"Patent Tools"},"content":{"rendered":"\n<h2 class=\"has-medium-font-size wp-block-heading\"><strong>Patent Tool for Excel<\/strong><\/h2>\n\n\n\n<p>To help Patent Attorneys, Patent Searchers, Inventors we have provided a simple excel macro tool.<\/p>\n\n\n\n<p>With this excel macro, we can<\/p>\n\n\n\n<ul><li>attach hyperlinks for google patents or espacenet site by selecting a column with Publication numbers and clicking the respective menu button<\/li><li>format the selected date column to DDMMMYYYY format<\/li><li>Mark duplicate values in a particular column<\/li><li>Combine all the selected values using a delimiter like \u2018OR\u2019 etc<\/li><li>Split the delimited values into separate single cells<\/li><li>Remove the kind code from the publication number<\/li><li>Remove the hyperlinks by selecting a number of cells<\/li><\/ul>\n\n\n\n<p><strong>The macro tool can be downloaded from the below link<\/strong><\/p>\n\n\n\n<p><a href=\"http:\/\/www.lexadept.com\/patenttool.xla\">patenttool.xla<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>For any further help, you can check the help section. Please leave your comments \/ thanks to <a href=\"mailto:jjsamuel@lexadept.com\">jjsamuel@lexadept.com<\/a>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>The above tool is safer to use and its circulated freely. There is no suspicious script in this tool that will cause any data collection or any harm to the computer. We always advise to save a copy of your file before running macros as the actions cannot be undone using \u2018ctrl+z\u2019 button.<\/p>\n\n\n\n<p>The demo video of the patent excel tool is given below. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Patenttool Demo  | Free Patent Macro tool | Free Patent hyperlinking tool demo of the menus\" width=\"830\" height=\"467\" src=\"https:\/\/www.youtube.com\/embed\/DLBWeJFI58o?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>  <\/p>\n\n\n\n<p>    <strong>Patent Tool for Word<\/strong><\/p>\n\n\n\n<p>With this Word macro, we can<\/p>\n\n\n\n<ul><li>attach hyperlinks for google patents or espacenet site by selecting a paragraph or a list of publication number or the whole document with Publication numbers and clicking the respective menu button<\/li><li>Remove any number of Hyperlinks from the selected paragraph or from whole document<\/li><li>Highlight multiple terms separated by comma with different font colors for easy reviewing of text<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>The word macro tool can be downloaded from the below link<\/strong><\/p>\n\n\n\n<p><a href=\"http:\/\/www.lexadept.com\/Normal.dotm\">patenttool.dotm<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>The demo video of the Patent Word Macro tool is given below<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Free Patent Tool Word | Patent word Macro | Word Hyperlinking Tool | Word Highlighter tool Demo\" width=\"830\" height=\"467\" src=\"https:\/\/www.youtube.com\/embed\/PHlQxV-xs4E?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The above tool is safer to use and its circulated freely. There is no suspicious script in this tool that will cause any data collection or any harm to the computer. We always advise to save a copy of your file before running macros as the actions cannot be undone using \u2018ctrl+z\u2019 button.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"has-medium-font-size wp-block-heading\"><strong>Free Bubble Chart Generator<\/strong><\/h2>\n\n\n\n<p>With this Excel macro, <\/p>\n\n\n\n<ul><li>Clicking on the &#8220;Bubble Data&#8221; will create the data table for generating a bubble chart<\/li><li>The &#8220;Bubble chart&#8221; menu generates the Bubble chart<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>The Free Bubble chart generator can be downloaded from the below link<\/strong><\/p>\n\n\n\n<p><a href=\"http:\/\/www.lexadept.com\/Patenttool5.xla\"><strong>Free Bubble Chart generator<\/strong><\/a><\/p>\n\n\n\n<p>The above tool is safer to use and its circulated freely. There is no suspicious script in this tool that will cause any data collection or any harm to the computer. We always advise to save a copy of your file before running macros as the actions cannot be undone using \u2018ctrl+z\u2019 button.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Free TDS Challan details capturing macro<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>With this Excel macro, <\/p>\n\n\n\n<ul><li>You can combine a number of TDS challans pdf files into one<\/li><li><span style=\"color: initial;\">Clicking the macro button will capture the below details in excel row by row from all the challans in the pdf<\/span><\/li><li>Nature of Payment, Tax, Penalty, Total Tax, Bank \/card details, BSR code, Tender Date, CIN, Bank Ref No and Challan No<\/li><\/ul>\n\n\n\n<p><strong>The Free <strong>TDS Challan details capturing macro<\/strong>can be downloaded from the below link<\/strong><\/p>\n\n\n\n<p><strong><a href=\"http:\/\/www.lexadept.com\/TDStool.xla\">Free TDS challan details capturing macro<\/a><\/strong><\/p>\n\n\n\n<p>The above tool is safer to use and its circulated freely. There is no suspicious script in this tool that will cause any data collection or any harm to the computer. We always advise to save a copy of your file before running macros as the actions cannot be undone using \u2018ctrl+z\u2019 button.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Disclaimer:<\/strong><\/p>\n\n\n\n<p>&nbsp;We disclaim any issue or damage caused to your file \/ system by running the above macro tools.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Patent Excel tool with functions to help the patent searchers and attorneys<\/p>\n","protected":false},"author":1,"featured_media":572,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[29],"tags":[136,144,139,133,143,140,141,142],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.11 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Patent Tools - Lexadept IP Associates<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.lexadept.com\/?p=529\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Patent Tools - Lexadept IP Associates\" \/>\r\n<meta property=\"og:description\" content=\"Patent Excel tool with functions to help the patent searchers and attorneys\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.lexadept.com\/?p=529\" \/>\r\n<meta property=\"og:site_name\" content=\"Lexadept IP Associates\" \/>\r\n<meta property=\"article:published_time\" content=\"2022-11-10T20:38:00+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2024-02-23T00:24:29+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.lexadept.com\/wp-content\/uploads\/2022\/11\/laptp.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\r\n\t<meta property=\"og:image:height\" content=\"694\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\r\n<meta name=\"author\" content=\"ph13030083162_kj63e10j\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ph13030083162_kj63e10j\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.lexadept.com\/?p=529#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.lexadept.com\/?p=529\"},\"author\":{\"name\":\"ph13030083162_kj63e10j\",\"@id\":\"https:\/\/www.lexadept.com\/#\/schema\/person\/2f98b9ae02f82a4257339c4103de8e16\"},\"headline\":\"Patent Tools\",\"datePublished\":\"2022-11-10T20:38:00+00:00\",\"dateModified\":\"2024-02-23T00:24:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.lexadept.com\/?p=529\"},\"wordCount\":613,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.lexadept.com\/#organization\"},\"keywords\":[\"Design patent registration\",\"Espacenet hyperlinking macro\",\"Free Patent tool\",\"Industrial designs IPO\",\"Patent excel macro\",\"Patent excel tool\",\"Patent hyperlinking tool\",\"Patent macro\"],\"articleSection\":[\"Benefits\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.lexadept.com\/?p=529#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.lexadept.com\/?p=529\",\"url\":\"https:\/\/www.lexadept.com\/?p=529\",\"name\":\"Patent Tools - Lexadept IP Associates\",\"isPartOf\":{\"@id\":\"https:\/\/www.lexadept.com\/#website\"},\"datePublished\":\"2022-11-10T20:38:00+00:00\",\"dateModified\":\"2024-02-23T00:24:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.lexadept.com\/?p=529#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.lexadept.com\/?p=529\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.lexadept.com\/?p=529#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.lexadept.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Patent Tools\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.lexadept.com\/#website\",\"url\":\"https:\/\/www.lexadept.com\/\",\"name\":\"Lexadept IP Associates\",\"description\":\"Intellectual Property &amp; Regulatory Law Attorneys\",\"publisher\":{\"@id\":\"https:\/\/www.lexadept.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.lexadept.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.lexadept.com\/#organization\",\"name\":\"Lexadept IP Associates\",\"url\":\"https:\/\/www.lexadept.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.lexadept.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.lexadept.com\/wp-content\/uploads\/2022\/11\/lexadeptlogo1-2.jpg\",\"contentUrl\":\"https:\/\/www.lexadept.com\/wp-content\/uploads\/2022\/11\/lexadeptlogo1-2.jpg\",\"width\":80,\"height\":83,\"caption\":\"Lexadept IP Associates\"},\"image\":{\"@id\":\"https:\/\/www.lexadept.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.lexadept.com\/#\/schema\/person\/2f98b9ae02f82a4257339c4103de8e16\",\"name\":\"ph13030083162_kj63e10j\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.lexadept.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1761e388bebb403509fb2a140d514edb?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1761e388bebb403509fb2a140d514edb?s=96&d=mm&r=g\",\"caption\":\"ph13030083162_kj63e10j\"},\"url\":\"https:\/\/www.lexadept.com\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Patent Tools - Lexadept IP Associates","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:\/\/www.lexadept.com\/?p=529","og_locale":"en_US","og_type":"article","og_title":"Patent Tools - Lexadept IP Associates","og_description":"Patent Excel tool with functions to help the patent searchers and attorneys","og_url":"https:\/\/www.lexadept.com\/?p=529","og_site_name":"Lexadept IP Associates","article_published_time":"2022-11-10T20:38:00+00:00","article_modified_time":"2024-02-23T00:24:29+00:00","og_image":[{"width":1024,"height":694,"url":"https:\/\/www.lexadept.com\/wp-content\/uploads\/2022\/11\/laptp.jpg","type":"image\/jpeg"}],"author":"ph13030083162_kj63e10j","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ph13030083162_kj63e10j","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.lexadept.com\/?p=529#article","isPartOf":{"@id":"https:\/\/www.lexadept.com\/?p=529"},"author":{"name":"ph13030083162_kj63e10j","@id":"https:\/\/www.lexadept.com\/#\/schema\/person\/2f98b9ae02f82a4257339c4103de8e16"},"headline":"Patent Tools","datePublished":"2022-11-10T20:38:00+00:00","dateModified":"2024-02-23T00:24:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.lexadept.com\/?p=529"},"wordCount":613,"commentCount":0,"publisher":{"@id":"https:\/\/www.lexadept.com\/#organization"},"keywords":["Design patent registration","Espacenet hyperlinking macro","Free Patent tool","Industrial designs IPO","Patent excel macro","Patent excel tool","Patent hyperlinking tool","Patent macro"],"articleSection":["Benefits"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.lexadept.com\/?p=529#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.lexadept.com\/?p=529","url":"https:\/\/www.lexadept.com\/?p=529","name":"Patent Tools - Lexadept IP Associates","isPartOf":{"@id":"https:\/\/www.lexadept.com\/#website"},"datePublished":"2022-11-10T20:38:00+00:00","dateModified":"2024-02-23T00:24:29+00:00","breadcrumb":{"@id":"https:\/\/www.lexadept.com\/?p=529#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lexadept.com\/?p=529"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.lexadept.com\/?p=529#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lexadept.com\/"},{"@type":"ListItem","position":2,"name":"Patent Tools"}]},{"@type":"WebSite","@id":"https:\/\/www.lexadept.com\/#website","url":"https:\/\/www.lexadept.com\/","name":"Lexadept IP Associates","description":"Intellectual Property &amp; Regulatory Law Attorneys","publisher":{"@id":"https:\/\/www.lexadept.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.lexadept.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.lexadept.com\/#organization","name":"Lexadept IP Associates","url":"https:\/\/www.lexadept.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.lexadept.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.lexadept.com\/wp-content\/uploads\/2022\/11\/lexadeptlogo1-2.jpg","contentUrl":"https:\/\/www.lexadept.com\/wp-content\/uploads\/2022\/11\/lexadeptlogo1-2.jpg","width":80,"height":83,"caption":"Lexadept IP Associates"},"image":{"@id":"https:\/\/www.lexadept.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.lexadept.com\/#\/schema\/person\/2f98b9ae02f82a4257339c4103de8e16","name":"ph13030083162_kj63e10j","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.lexadept.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1761e388bebb403509fb2a140d514edb?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1761e388bebb403509fb2a140d514edb?s=96&d=mm&r=g","caption":"ph13030083162_kj63e10j"},"url":"https:\/\/www.lexadept.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.lexadept.com\/index.php?rest_route=\/wp\/v2\/posts\/529"}],"collection":[{"href":"https:\/\/www.lexadept.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lexadept.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lexadept.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lexadept.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=529"}],"version-history":[{"count":18,"href":"https:\/\/www.lexadept.com\/index.php?rest_route=\/wp\/v2\/posts\/529\/revisions"}],"predecessor-version":[{"id":620,"href":"https:\/\/www.lexadept.com\/index.php?rest_route=\/wp\/v2\/posts\/529\/revisions\/620"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.lexadept.com\/index.php?rest_route=\/wp\/v2\/media\/572"}],"wp:attachment":[{"href":"https:\/\/www.lexadept.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lexadept.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lexadept.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}