This is a post to iron out some specifics in the process of cataloging imagined shots.I apologize but I can not write here the steps to using your personal version of office software. Please find a specialist in that department to help you.
It can be a little difficult to prioritize by location so here is a tip on accomplishing this goal. Leave a column to the left of your “location” column and assign each location a letter. Please note that this will limit you to 26 locations, but here is the downfall of using numbers to assign priority for each location: spread-sheet protocol typically organizes first by the beginning number until there are no more of that number and then move onto the next in sequence.
In my experience 26 locations will be sufficient as this list is meant to be constantly revised and amended. Also remember that multiple shots at the same location can be cataloged with the same letter! So you will not be limited to 26 shots, but 26 locations.
This process is very simple for me. If it is not for you, please organize the spread-sheet in a way that works best for you. If it is not simple and effective for you, it is not worth using. As everything else, I am only share with you what I have done, to give you hope; possible ideas of how you can make these things your own and make your fun more inspiring! Enjoy!