A complete list of all current patrols
OK I was bored (plus I needed a patrol list for Delta mark farming), so I went ahead and downloaded and modified Lars' spreadsheet in Excel:
https://docs.google.com/spreadsheets/d/1AuA8ZgMwuh9Mh55QgZezttW1RjVUeZ2_D02-u2iayac/edit?usp=sharing
I'm not sure if the sort will survive being uploaded or if that's just on my local copy, so if it doesn't, here's how to sort it in Excel 2010 (other versions similar) to list the patrol systems at the top in map grid order:
That should sort the list as described above. You can also use this method to sort it in other ways, of course.
- Added a column with map grid coordinates per the image above
- Added the image above to each quadrant tab of the spreadsheet for grid reference
- Color-coded the quadrant tabs (bottom of the Excel window) per map icons for better visibility
- Sorted each tab by Patrol Y/N then by Grid Coordinates
https://docs.google.com/spreadsheets/d/1AuA8ZgMwuh9Mh55QgZezttW1RjVUeZ2_D02-u2iayac/edit?usp=sharing
I'm not sure if the sort will survive being uploaded or if that's just on my local copy, so if it doesn't, here's how to sort it in Excel 2010 (other versions similar) to list the patrol systems at the top in map grid order:
- On the Excel ribbon Home tab, click the Sort & Filter button, usually at top right
- Select Custom Sort from the menu to open the sorting options panel
- From left to right, select Patrol?/Values/Z to A from the dropdown lists
- Click the Add Level button at top left
- From left to right, select Map Grid/Values/A to Z from the dropdown lists
That should sort the list as described above. You can also use this method to sort it in other ways, of course.