Thursday 17 September 2015

Outlining with Excel

Outline for the first arc of my current WIP

Until quite recently, I'd considered myself a loud and proud pantser. I had tried outlining in detail once before, it killed my muse, and I declared that I'd never do it again.

Then I started getting writer's block more often than not, and would stare at the page and not know what comes next.

I mixed and matched outlining methods and ways to structure story to find the one that suited me that best.

Right now, I've come up with the spreadsheet method that's shown on the right, but I promise it isn't as terrifying as it looks. This is by no means the best or only way to outline, but it's my way.

Quick things to note:
  • I sort of use the three arc structure.
  • I use the scene/sequel structure (if you don't know what that is, click here and here).
  • My current manuscript is told from a singular first person POV (I'll suggest alternatives for people working with dual/multiple POV further down) 
  • I'll be using Pride and Prejudice examples taken from K.M. Weiland's Structuring Your Novel to illustrate everything as I learnt a lot from it. 
  • Row = Horizontal, Column = Vertical
This post is a little long, so I'll put it underneath a cut.



Okay! So let's get started.

I open up Excel and start to fill in the top row. If I was outlining Pride and Prejudice, it would look something like this:


From left to right, my columns are set as such:
  • Arc - I use this column to track where my Key Points are (more on those later)
  • - I place a tick there when I finish writing that scene
  • Summary (Protagonist POV) - 1-2 sentence summary of the scene, 
  • Place - Where the scene happens
  • Time - When the scene happens 
  • One column each for significant supporting characters - A line about what they're doing either behind the scenes (if important) or in the scene. If they're not in the scene, whether doing something important behind the scenes or not, I block it out with grey
  • Scene/Sequel - See linked posts above
  • Goal/Reaction - See linked posts above
  • Conflict/Dilemma - See linked posts above 
  • Disaster/Decision - See linked posts above 
  • Short-term goal - Not the scene goal, but a very minor goal that takes more than one scene to complete (e.g. to steal enough money to pay the dressmaker) 
  • Long-term goal - Big Picture things that are needed to achieve the end goal (e.g. to disguise herself as a noblewoman to enter the palace)
  • Overarching goal - The end goal, what the protagonist wants (e.g. to kill the royal family)
While the sheet is still empty (apart from the column labels), I copy it twice so I have three sheets which are exactly the same. I name them Arc One, Arc Two and Arc Three. You could keep it all in one spreadsheet, but because I plot out every scene, it tends to get very long and I'd rather click between tabs than keep scrolling.

These are columns are completely flexible, I have some characters don't get their own columns until arc two, and some characters who were significant enough to get their own column in arcs one and two, but ends up dying during the third plot point and no longer needs a column.

If you don't think it's important to keep track of the location of the scene, you don't need a location column. If the weather is important, add a weather column.

One scene in one row. I fill in all the columns, and if major parts that make up the scene/sequel are .  missing, I know that I'll have to seriously rethink about whether or not I need that scene. Potential filler scene avoided before it even began. I can move the scenes around, insert new rows if I need a scene to go in-between, and easily get rid of scenes that I no longer want.

Then I add another sheet called "Key Points." Pride and Prejudice would have one that looked something like this:


In column A, I write down in each row:
  • Hook
  • Inciting Incident 
  • Key Event
  • First Plot Point
  • First Pinch Point
  • Midpoint
  • Second Pinch Point
  • Third Plot Point 
  • Climax
If you have no idea what any (or some) of these points here, click here.

In column B, I write down the scene(s) involved involved in that plot structure point. I edit and add to this as I outline-- usually it goes from a vague idea (e.g. Elizabeth rejects Mr Darcy), to an more concrete idea (e.g. Elizabeth rejects Mr Darcy in the rain after he acts like an asshole and insults her entire family before declaring his love). This really helps me keep track of where the story is going.

I usually set up empty spreadsheets for all of my significant characters, and everything and anything that suddenly comes to me goes there. Pictures, dialogue, "what-ifs," all the ideas I get during outlining that I'm not quite sure where to put. Same goes for a worldbuilding and locations.

Quick Tips:
  • Freeze the top row. 
  • Colour is your friend. Colour code everything. 
  • Wrapping the text will save you.
  • If something no longer works, change it. 
  • If you suddenly feel the need to revamp everything, click Save As and save it as a new file before going on a deleting spree. 
  • If you have more than one POV character then one way of adapting it would be to repeat the scene summary column for as many POV characters you have, and add a POV column. Indicate which POV is being used (through colour or column) and keep notes about what your other POV character is doing during that time in their columns. 
Hopefully, all of this made sense and didn't confuse anyone too much. If you have any questions or want me to expand on something, feel free to leave a comment!

22 comments:

  1. this is so helpful thank you so much

    ReplyDelete
  2. Is there a downloadable excel template?

    ReplyDelete
  3. Great content thanks for sharing this informative blog which provided me technical information keep posting.
    python interview questions and answers
    python tutorials
    python course institute in electronic city

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    Python Online certification training
    python Training institute in Chennai
    Python training institute in Bangalore

    ReplyDelete
  6. I Regreat For Sharing The information The InFormation shared Is Very Valuable Please Keep Updating Us Time Just Went On Reading The Article Python Online Training AWS Online Training Hadoop Online Training Data Science Online Training

    ReplyDelete
  7. Like your sharing this with others. Is a clearer image of the excel sheet available. Having a hard time following visually.

    ReplyDelete
  8. I think this is one of the most significant information for me. And i’m glad reading your article. But should remark on some general things, The web site style is perfect, the articles is really great : D. Good job, cheers
    excel training institute in gurgaon

    ReplyDelete
  9. Meritstep is Top Best PEGA Online Training Institution & Learning Organization in India, USA. We Provide PEGA Online Training Platform in USA, UK and Australia.

    ReplyDelete
  10. Enlighten Messages are Circled Through this sites,Thanks for Sharing A Post.Are you Searching For BEST PYTHON TRAINING IN CHENNAI WITH PLACEMENT???Do visit Here
    python training in chennai | python training in annanagar | python training in omr | python training in porur | python training in tambaram | python training in velachery

    ReplyDelete
  11. This particular papers fabulous, and My spouse and i enjoy each of the perform that you have placed into this. I’m sure that you will be making a really useful place. I has been additionally pleased. Good perform! bill tracking sheets

    ReplyDelete
  12. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing. excel training in gurgaon

    ReplyDelete
  13. Thank you for sharing this article. It was very useful. Data science training in Hyderabad

    ReplyDelete

Darcy Hsu. All rights reserved. BLOG DESIGN BY Labinastudio.