I’m in the middle of my first revision pass for my second novel, which I finished last weekend. Here’s my revision command central. The list of chapter numbers, working titles, and revised titles is the left three columns. The next three are elapsed time and start and end dates, so I’m consistent with timing as the story progresses and know how much time is passing for the characters.

The yellow boxes to the right are issues in some chapters that I want to check or correct or do better. Some of them are really minor, while others are things I blew it on the first time through that will take some work to fix.

The gray box on the far right is a screencap of my writing software showing the original descriptive chapter names so I can keep them straight as I rename them to stupid puns.

The colored column in the middle is whether I think the chapter is funny or not – red and yellow less funny, blue and green more. At least to me. I don’t know if there’s anything to be learned there, but I figured I’d note it for pacing and revisions. The dark blue line shall remain mysterious for now. I’ve done 31 of 63 chapters so far, and I’m shooting to have this first pass through it done before classes start on Monday.

Anyone who knows me well knows that I can’t help but use spreadsheets for stuff. Not sure if this is interesting to anybody, but I thought it might be. Blurred to hide spoilers.