After completing three novels using my handy-dandy spreadsheet and being 10,000 words into my fourth, I discovered I was lacking a column.
This far into the game, I thought I would have had my spreadsheet nailed. The joke’s on me.
My first three novels take place in a fictitious ski resort (Stone Mountain) in British Columbia. I needed one location column when I had one town and a bunch of locations within the town. All I needed to note in the location column was where the scene took place within Stone Mountain. That meant on the ski lift, in an office, on a trail, in the forest, in a car, etc.
My fourth novel starts out in Kingston, ON, moves to Ft. Lauderdale, FL, and then makes its way through the Bahamian island chain.
Now, I need to keep track of locations within the new locations. The new column lists the town or island where the scene takes place. The existing column still works and lists where in the town or island the scene happens. This means on a beach, at anchor, in the dinghy, etc.
I guess my spreadsheet will continue to evolve as I write more novels.