I am creating maps of underground utilities using DDP with a grid layers as my index layer. Each grid shows a segment of the run. The pages must be generated in an order that maintains the continuous run.
My problem is that I don't have a good sort field because none of the grid fields adequately align with the continuity of the run. For example, page 1 should be where the run starts and page 17 would be where it ends. But I don't have a sorting index for this unless I create a page index field and manually assign values.
The problem is that I have over 45 MXDs to data drive, each with its own grid package, and some grid packages containing up to 15 grids apiece.
This means I am having to manually sort roughly 200 pages in total which is going to take way more time than I have.
Is there a way to rearrange the page order without having to rely on the index layers attributes? At first I accomplished this by simply reordering the PDF pages in Adobe, however this is not a good option because then my dynamic text page numbers are off (for example page 1 of 17 might be followed by page 8 of 17 followed by page 6 of 17 etc.