Thursday, February 26, 2015

Expanded Petty Gods Writer's Index is done!

It took me about three hours this evening, but I finished the writer's index for Expanded Petty Gods. I definitely think the work was worth it.

One of the things I did when I rebuilt the spreadsheets at the inauguration of my leg of this project, was to split out the last names and first names for all writers and artists, with this absolute goal in mind... being able to alphabetize by last name. Once all the art is completed for the book, I'll do the same thing for the artists.

So tonight, I had to finish adding the page numbers (from the layout) to the Excel spreadsheets I've been using to manage each section of the project. Then I took just the columns for page number, writer's last name, and writer's first name from each of the master Excel files, and kept adding those to a single new Excel file. Then, in that composite Excel file, I ordered the columns: 1) last name, 2) first name, 3) page number. After that, I sorted them in that same order (ascending by Column A, then Column B, then Column C). Doing that also showed any inconsistencies in how a single person's name might appear. This allowed me to proof and edit the names (not just in the index, but double-checking them in the layout as well). From there it was just a lot of selecting boxes and "clearing contents" in Excel, followed by some "find/replace" in TextEdit, to create the final text file I imported into the layout. Ironically, the actual typesetting of the 2 pages took about 10 minutes. It was the three hours of prep-work that took all the time.

11 comments:

  1. It is an honour to be listed among such literary giants. Thank you for picking up the torch and running with it on this project, Richard. (Expanded) Petty Gods is a highlight in my years of gaming and encouraged me to write and draw again.

    ReplyDelete
  2. Awesome, neat seeing my name here! Honored!

    ReplyDelete
  3. I am pretty pleased to see my name on this list too.

    ReplyDelete
  4. Holy.Shit. I didn't realize I had contributed that much.

    ReplyDelete
    Replies
    1. Yeah dude you and Richard share MVP on this one.

      Delete
    2. Eric Potter's been no slouch either. He's been my "go to" guy for helping me create things to facilitate better page breaks, etc.

      Delete
  5. I was happy to help out with this project. Nice, clean layout as always, Richard!

    ReplyDelete
  6. I sit a meager man amongst gods and giants.

    ReplyDelete
  7. Woah... First time I've seen my name in print in a good context!

    ReplyDelete