PDF to Excel – Data Mining
Many years ago I used Monarch to perform data mining extracts from a payers 835 remittance advice into excel. We captured all elements spread throughout the PDF into single line item details. Sadly, the times have changed and what used to cost $150 for the Monarch CD to use is now totally different, costing over $5k for a yearly prescription cost.
I have attached a Mock PDF and a mock of what I want to see in excel. Any thoughts of a program that will not break my tiny little bank would be great. Or, using the data extract option in excel to work properly.
Many years ago I used Monarch to perform data mining extracts from a payers 835 remittance advice into excel. We captured all elements spread throughout the PDF into single line item details. Sadly, the times have changed and what used to cost $150 for the Monarch CD to use is now totally different, costing over $5k for a yearly prescription cost. I have attached a Mock PDF and a mock of what I want to see in excel. Any thoughts of a program that will not break my tiny little bank would be great. Or, using the data extract option in excel to work properly. Read More