We have a folder with like 5000 documents dating back from like the year 2000. In this folder a lot of documents are drafts or duplicates. The workflow must 1st check if there are any non docx Word documents and save them as docx. 2nd remove duplicates by identifying the latest version and excluding drafts. 3rd extract certain meta data such as date, location, author, summary, report number and put those in a excel spreadsheet that functions as a register. 4th Recreate the report, 5th ANalyze all graphs and figures in the report, count, map and sumamrize them and create a seperate graphics file for each report concerning that.
This is what I currently have, any body some tips or ideas to help me along the way?