I came across a blog through my agent’s blog that's full of all sorts of goodies for writers. One of my favourite posts is about the process and — for lack of a better word — technique of revision. Check it out here.
The blogger, author Laurie Halse Anderson, and I have a very similar approach to revising, save for one area: the actual "roadmap" itself. While she prefers using large sheets of paper to outline her roadmap, I find an Excel spreadsheet to be most effective. Aside from being an organizational lifesaver, a digital spreadsheet is portable. Woo hoo! I just email it to my iPhone and I can refer to my roadmap wherever I go. (It came in very handy this morning when I was trapped on the subway for half an hour. The power was off and transit supervisors were searching the tracks for a dead body, but I was revising on the go, so who cares?)
I don’t think I’ve used Excel as it’s meant to be used more than a dozen times. I remember my husband casually mentioning that it's just a big calculator a while back, and I was all “Get the fu%$ out!” And now that I've discovered Excel art (see Mega Man above), it's safe to say that I'm going to be moving farther and father away from the software's raison d'être.
I don't do anything fancy on my spreadsheet roadmap. I just break my book down into scenes, making note of the most important events. I also use colour coding, which helps me with stuff like this:
1. Pacing my story
My book has a bit of a magical realism bent to it, but I don't want to overdo it and annoy my readers. To ensure that doesn't happen, I colour those moments orange. This way, I can easily see if there’s too much "magic" in any particular section.
2. Organizing locations
I like to keep my characters on the move. For example, my main character’s apartment is assigned the colour blue. Too much blue clotted together on the spreadsheet? Scenes will need to be shuffled to keep things interesting.
3. Periphery characters
I want to spread these guys around and colour coding helps me do that. For example, I’ve assigned Steve red and Margaret yellow. That way I have an instant visual map. Too much red in one area? Again, that’s a sign that scenes need to be shuffled. You get the drift. Now here's some more Excel art for you, you clever drift-getter you!