[David Cutler]

Throwing an idea out to see what other thoughts it generates. How about collecting your data directly in Revu, rather than trying to import it in?

You could create a markup that you apply to your drawing in the field and then capture your meter reading in a custom column directly in Revu.

Once you have a number of results captured your could sort your markups by the meter reading column. You could select all of the markups in the desired range and change the color of the markup. This way your “dots” would be color coded and located on the drawing sheet.

As an added benefit when you hover over your markup in the PDF, depending upon how you have the data entered, you will see some of the information displayed on the screen at your curser (this is how it works on a PC at least). Complete data would be shown in the markup list.

If you need the data in Excel for reporting you could export the data from Revu and then process the information in Excel – perhaps with a Power Query.