Patent Tool for Excel
To help Patent Attorneys, Patent Searchers, Inventors we have provided a simple excel macro tool.
With this excel macro, we can
- attach hyperlinks for google patents or espacenet site by selecting a column with Publication numbers and clicking the respective menu button
- format the selected date column to DDMMMYYYY format
- Mark duplicate values in a particular column
- Combine all the selected values using a delimiter like ‘OR’ etc
- Split the delimited values into separate single cells
- Remove the kind code from the publication number
- Remove the hyperlinks by selecting a number of cells
The macro tool can be downloaded from the below link
For any further help, you can check the help section. Please leave your comments / thanks to jjsamuel@lexadept.com.
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 ‘ctrl+z’ button.
The demo video of the patent excel tool is given below.
Patent Tool for Word
With this Word macro, we can
- 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
- Remove any number of Hyperlinks from the selected paragraph or from whole document
- Highlight multiple terms separated by comma with different font colors for easy reviewing of text
The word macro tool can be downloaded from the below link
The demo video of the Patent Word Macro tool is given below
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 ‘ctrl+z’ button.
Free Bubble Chart Generator
With this Excel macro,
- Clicking on the “Bubble Data” will create the data table for generating a bubble chart
- The “Bubble chart” menu generates the Bubble chart
The Free Bubble chart generator can be downloaded from the below link
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 ‘ctrl+z’ button.
Free TDS Challan details capturing macro
With this Excel macro,
- You can combine a number of TDS challans pdf files into one
- Clicking the macro button will capture the below details in excel row by row from all the challans in the pdf
- Nature of Payment, Tax, Penalty, Total Tax, Bank /card details, BSR code, Tender Date, CIN, Bank Ref No and Challan No
The Free TDS Challan details capturing macrocan be downloaded from the below link
Free TDS challan details capturing macro
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 ‘ctrl+z’ button.
Disclaimer:
We disclaim any issue or damage caused to your file / system by running the above macro tools.