List of Excel Macros available for licensing
| BASIC MACROS | ||||
|---|---|---|---|---|
| S. No. | Macro name | Description | Input data | Output data |
| 1 | IPC | This macro is used to normalize and pick only first 4 characters in a IPC/CPC class code. This will also normalize the data when multiple class codes are there in one cell. It will also remove duplicates after normalization | A46B000100 | A46B000912 | A46D000100 | B29C004526 | B29C004533 | A46B, A46D, B29C |
| 2 | Country code | This macro is used to find # of countries that a patent has been filed based on INPADOC data provided by a patent database | EP2682022A1 | EP2866611A1 | US20150135456A1 | EPO, United States |
| 3 | Priority year | This macro normalizes the priority year from a list of multiple priority dates. It also provides additional features of grouping the priority years as required (e.g., if the user wants to show all the priority years before 1996 as “Before 1996”, this macro can do that) | 2012-07-02 | 2013-05-17 | 2012 |
| 4 | IPC Definition | This macro will provide the definition of any IPC code (first four characters only) | A46B | BRUSHES (handles not integral with brushware B25G) |
| 5 | Family de-dupe | When a spreadsheet is downloaded from commercial patent database(s), though reduced one per family, a few duplicates still remain. This macro removes the family duplicates. Can be used with DWPI accession number or INPADOC family. Online version is also available. | ||
| 6 | Synonyms | Synonyms used in medical domain. Updates periodically. End user can easily search for required synonym in one place. Hand curated. | ||
| 7 | Bubble/Heat map data creator | This macro simplifies the task of creating 3D data for Heat Map/Bubble graph. | ||
| 8 | Find and replace | Multiple variants available. Can search entire sheet/range/within cell etc. Can summarize all cells data into one. Useful in normalizing data after analysis. Saves substantial time with high accuracy | ||
| 9 | PubMed data converter | This macro helps end user in converting PubMed data into Excel format. This supports text file or XML data. | ||
| 10 | Data normalization for Country code/IPC/Date/General | Easily group/convert/normalize raw data into summarization. This is useful in analysis and plotting graphs | ||
| 11 | Clean up Orbit data | Clean downloaded Orbit data | ||
| 12 | Others | Remove/replace a char in cell with user defined characters. Find family, extract URLs, and add URLs to cells, TI-Orbit-XPN Data format changer, Search-Copy-Paste data from once Excel file to another, Data copy with font color match, pattern match,convert shapes, remove hyperlinks etc. | ||
| ADVANCED MACROS | ||||
| 13 | Hyperlink | This macro provides hyperlinks to the patents to a USPTO or EPO site. The hyperlinks be set to a homepage of the user choice, to “Bibliographic information” or to the “Description” or to the “Claims” or “Mosaics” or to the “Original PDF Document” on the respective patent office site | US20150135456A1 | US20150135456A1 |
| 14 | Matrix | This is something similar to pivot tables, where user can generate a matrix data with one parameter on rows and another parameter on columns and number of occurrences in the respective cells. The advantage of this macro over a pivot table is, if the information in a cell is separated by a comma, the pivot table takes it as a single value but in our matrix it will take as two separate values | xx, yy | xx and yy shown in a pivot table separately |
| 15 | Legal status from EPO | This macro provides legal status of a patent in EPO. Useful when dealing with large patent data sets | Patent number | Legal status of patents |
| 16 | Excel to printable Word format | This macro converts the data available in selected fields of Excel into a Word document (can also set it up to go to PowerPoint or PDF or other formats) | Excel file with multiple fields against each patent number | One-page Word document capturing all the fields |
| 17 | Excel to PowerPoint conversion | This converts data in Excel into PowerPoint in a predefined format in PowerPoint | Excel file with multiple fields against each patent number | One-page PowerPoint document capturing all the fields |
| 18 | Patent number conversion between databases | This macro converts the patent numbers in TI format to Orbit format | Show TI # in input data and Orbit # in output data | |
| 19 | Claim charting | Divide claims in source cell into “Main Claim”, “Independent claim”, “Dependent Claim” with color codes | ||
| OTHER EXCEL TOOLS | ||||
| 20 | Interactive Sheet | This is a standalone tool that provides multiple filter options in both bibliographic and analyzed fields. Can have the option to search free text fields available in Excel work sheet | ||
| 21 | Patent analyzer | This is a macro enabled standalone Excel tool which will help an analyst to highlight the text within selected Excel fields, indicating the number of occurrences of a word. Various colors can be set for different key words | ||