RSS Feed

The Novel Spreadsheet

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.

About these ads

About Kristina Stanley

www.KristinaStanley.net

9 responses »

  1. Nancy J Nicholson

    I’m so glad I’m not the only one with Spreadsheets. Lots and lots of spreadsheets.

    Reply
  2. Let us know when you have your perfect spreadsheet :). I always like to see how writers set up their novels. I tried a spreadsheet and a timeline and the darn things keep changing!

    Reply
    • I don’t know if it will ever be finished. You’re right – they just keep changing. I guess that keeps things interesting. BTW – I like the name of your blog. Very motivating.

      Reply
  3. At least you have a spreadsheet:) Love Ft. Lauderdale . . . I’m across the way on the Gulf:)

    Reply
  4. It’s funny how the process evolves along with the needs of the story! I’m glad you found a way to adapt your spreadsheet to the new story, since it sounds like quite a useful way to work.
    The novel sounds intriguing as well. :)

    Reply
    • Thanks for the comments on my novel. I’m trying something new. I’m using only two POV characters. My first 3 novels have at least 7 POV characters. That puts a new slant on my spreadsheet as well.

      Reply

Thank you for commenting!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 2,012 other followers

%d bloggers like this: