Excel Macros

Excel Macros

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 will normalize the priority year from a list of multiple priority dates. This macro 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 will simplify the task of creating 3D data for Heat Map/Bubble graph.
8 Find and replace Multiple variants available. Can search entire sheet/range/with in 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 provide 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 table, 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 one will convert 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

Title Here