• About Megan Cashman
  • Author Interview Guidelines
  • The Dark Proposal
  • Video Services for Authors

Megan Cashman

~ Author

Megan Cashman

Tag Archives: story plots

Outlining Your Story Using Spreadsheets

05 Thursday May 2016

Posted by Megan in Being an Author, On Writing, Storytelling Musings

≈ Leave a comment

Tags

authors, Being an Author, books, Excel, novels, plots, spreadsheets, story plots, storytelling, subplots, writers, writing, writing a book, writing a novel

I’ll be the first to say that I am a Spreadsheet Queen. I can’t live without spreadsheets. Whether it is to keep track of finances, freelance work, or plans for the summer, spreadsheets is the way to go for me, and likely for many other people.

That probably also includes fellow authors outlining their next book. Some authors choose between outlining or flying by the seat of their pants when it comes to writing. I myself have debated this issue. But lately, due to my crazy schedule, I find it best to outline. And I’ve made that possible for myself through spreadsheets.

How do I outline using spreadsheets? Simple. I make each column represent each chapter. So when you see my sheet, you’ll see Chapter 1, Chapter 2, Chapter 3… all lined up in columns. Next, I put the scenes of each chapter in the rows. This is a good way to figure out which scene should end or begin a chapter, or which scene belongs in which chapter.

Photo by Craig Chew-Moulding on Flickr via Creative Commons

Photo by Craig Chew-Moulding on Flickr via Creative Commons

Doing this has made the planning of my sequel very easy. Granted, I do not stick to it religiously; I have moved a few scenes around and added a few more without consulting my spreadsheet. But overall, spreadsheets has been helping me keep track of the scenes of my second book.

It is not unusual for authors to use this to help plot their books. JK Rowling plotted her Harry Potter books using spreadsheets, and I’ve seen a few other, less-known authors do the same thing.

Because life can be so busy sometimes, I recommend authors to outline their stories. It is too easy to come up with an idea, only to not be able to write it down because either you’re at work, going to or from work, or busy with home life. Also, writing is a discipline, and if you are working on a book, you need to be organized and professional about your craft and your story. I was not like this when I wrote my first book, but then again, I was unemployed at the time. That meant having plenty of time to write whenever I pleased, as much as I wanted.

Nowadays, I do not have that luxury and I have to rely on spreadsheets to make my next book possible. It is funny how being a professional these days has made me rely on a program intended for professionals, in order to be more professional with my story!

Raise your hand if you use spreadsheets to help organize your story!

 

August 2022
S M T W T F S
 123456
78910111213
14151617181920
21222324252627
28293031  
« Apr    

Archives

Enter your email address to follow this blog and receive notifications of new posts by email.

The Dark Proposal by Megan Cashman

Now on Kindle!

Also on Smashwords: https://www.smashwords.com/books/view/276775

My Facebook Page

My Facebook Page

Twitter Updates

Error: Please make sure the Twitter account is public.

Categories

  • Author Interviews
  • Being an Author
  • Between Light and Dark
  • Blog Awards
  • Book Trailers/Videos
  • Books
  • Characters
  • Entertainment
  • Miscellaneous
  • My Books
  • On Writing
  • Random Thoughts & Opinions
  • Reading
  • Reviews
  • Self-Publishing
  • Staten Island
  • Storytelling Musings
  • The Cats
  • The Dark Proposal
  • The Future
  • Vampires
  • Word Grammar Punctuation

Recent Posts

  • Vampires Today: Smartphones
  • Who is Your Audience?
  • Are Vampires Passe?
  • Why Do I Write?
  • “The Dark Proposal” – on tour at Bewitching Book Tours

Top Posts & Pages

  • Disclaimer: This is a Work of Fiction...
  • Vampires Today: Smartphones
  • Mom, Dad - Please Don't Read My Book!
  • Why the Hate for Fictional Characters?
  • My Shout Out to Fellow Staten Island Authors
©Megan Cashman and Megan Cashman Books 2012 - 2017. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Megan Cashman and Megan Cashman Books with appropriate and specific direction to the original content.

Blogroll

  • Discuss
  • Get Inspired
  • Get Polling
  • Get Support
  • Learn WordPress.com
  • The Dark Proposal – Now on Kindle!
  • Theme Showcase
  • WordPress Planet
  • WordPress.com News

Archives

wordpress stats plugin

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Megan Cashman
    • Join 1,392 other followers
    • Already have a WordPress.com account? Log in now.
    • Megan Cashman
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...