Just like great people still put their pants on one leg at a time, all great novels start the same: with a nugget, an inspiration, an idea. Some unique or quirky character that must be shared, some plot that needs exploring. Something to get the brain started.
For me, often, it’s a topic I want to understand. This was Michael Shaara’s inspiration for Killer Angels, one of the outstanding fiction accounts of the Civil war. He used Stephen Crane (author of The Red Badge of Courage) as his mentor–
“reading the cold history was not enough; he wanted to know what it was like to be there, what the weather was like, what men’s faces looked like. In order to live it he had to write it. This book was written for much the same reason.”
- I create an Excel spreadsheet with columns for Section, Chapter, Purpose, Day, Time, Characters (major and minor), Setting (at the start and finish), character’s success or failure in each section, whether the section includes action or a reaction. Summary, Follow-up. These are the mechanics of a great novel. I know–sounds formulaic. It isn’t. I want to be sure I include all important parts of writing a story people want to read. I write for myself–yes–but I promise you, the writing is better–and more fun–if you follow conventions.
- Why Excel? It’s easy to map out the action. the columns insure I’ve included all dramatic requirements of a good novel and followed up on all the details. I can also move blocks of text around easily, with a better reference for where they should fit.
- I add my one-paragraph of skeletal details under Summary. This feels good. I’ve started.
- And right there, I’m stuck. What comes next?
- On a separate worksheet in the same Excel workbook, I define the plot, subplots, themes, goals, premise, idea,
moral–not all of those, but enough I understand my purpose
- On that same worksheet, I plot the story–how does it start (life is pretty good), what happens to change that, what does my protagonist do to fix things, how does that not work (its failure creates the required drama), what’s my protagonist’s next and next plan and how do they also fail, what is the climax–the final unsolvable problem that will destroy my protagonist, how do I solve it. This forces me to understand a whole lot more about my characters, plot, even the setting because that will play into how my characters interact.
- The only way I can plot the story is to know my characters. As I’m working the timeline, I develop character biographies–what’s their background, their likes and dislikes, quirks, physical appearance, what drives them, how do they influence the story, what’s their ruling passion, what’s their purpose in the story (protagonist, antagonist, confidant, supporting actors), what are their emotional firestorms, what’s their psychological profile?
- Knowing my characters clarifies the subplots. Though my protagonist may be focused on rescuing her kidnapped child, those around her will have their own agendas that will dictate their participation in her goal. Therein live my subplots.
- Now I can return to my outline and fill it in. I create the Timeline portion (start/finish) early so I can be sure I’m including details of the day, time of day, month and year if required, in the Summary section. I want to know if it’s been a week or a day, if it’s winter or summer. These affect action.
- I map out which characters are involved in which sections early. This insures that my protagonist is indeed the main character, and the protagonist shows up regularly to botch up the plot. I also insure the confidant appears every time I must share details which I couldn’t otherwise get out.
- As I’m adding the pieces, I make notes for what must be researched, followed up later in the story, clarified, etc.
- I check the columns about Action/Reaction. Most readers want to know what the POV (point of view) character is thinking, why s/he’s doing what s/he’s doing. I add as much introspection as action (almost–and this will vary depending upon whether you’re writing a thriller or literary fiction) and be sure the reader understands only what the POV character gets. This is a good way to develop drama–fear for the future
- I add details of characters, settings to the outline. If this changes the plot, I work that change through
- I clean up my ‘Follow up’ column. this is harder than it sounds. Too often, I find out that following up on some innocuous detail changes the plot. Be rigorous about having this logical progression. In fiction, a willing suspension of disbelief is our greatest ally. Lose that and your reader puts the book down.
- I clean up transitions between all the parts.
- I convert the Excel spreadsheet into text, in a Word doc (or Google Docs)
- I clean it up.
Because I’m also a teacher, this takes me a year. By summer I get to the Word doc and spend my two months off–ten hours a day–working out my novel.
At least, that’s the plan. How about you?
Jacqui Murray is the editor of a technology curriculum for K-fifth grade and creator of two technology training books for middle school. She is the author of Building a Midshipman, the story of her daughter’s journey from high school to United States Naval Academy midshipman. She is webmaster for five blogs, an Amazon Vine Voicebook reviewer, a columnist for Examiner.com, an Editorial Review Board member forSIGCT, an IMS tech expert, and a weekly contributor to Write Anything andTechnology in Education. Currently, she’s working on a techno-thriller that should be ready this summer. Contact Jacqui at her writing office or her tech lab, Ask a Tech Teacher.
You are simply awesome. Do you create this type of great content yourself or are you a member of a team? I’m here for the second time today. I used to live out in Massachusetts so I know what you are talking about here.
LikeLiked by 1 person
I love writing so do all of this myself. Thanks for visiting, Jesse!
LikeLike
I really think this is a great idea and will help in sorting out my ideas. I am not at all familiar with Excel but perhaps it may be worth trying just to get things in order. Thanks for sharing this information
LikeLiked by 1 person
I’m working one up right now for my next book. Love dragging and dropping those rows!
LikeLike
Isn’t it a bit disconcerting to work in Excel though?
LikeLiked by 1 person
For me, not at all. I type in the cell which resizes as needed. I add a column to the right for stuff I need to follow up on (say, he promised to pick up his daughter that afternoon–I’ll note that there). I add another column for stuff I need to research (like satellites Israel may have). I can drag-drop the rows in any order, much like others do with post-its or index cards.
LikeLike
Ok that makes sense now. I will definitely try it. Thanks so much for this tip. It will help in getting things on track
LikeLiked by 1 person
Pingback: The Power of Positive Writing | WordDreams...
Pingback: The Power of Positive Writing | Today's Author
The excel document is a really good idea. I have loads of ideas but actually writing them out in a format that will make sense when I look back over it is difficult. Also, I hear you with the planning taking a year. I’m a doctor, fitting in my writing is a nightmare, but it keeps me sane so I have to force myself to do it on a regular basis!
LikeLike
That is a challenge. Being a doctor always sounds like 23 hours on, one off–can you write between appointments? I agree about writing being a sanity check. Done right, it forces you do concentrate on a different world, which gives a break from real life.
LikeLike
I carry a little book of ideas with me so I can jot down snippits when they come to me. They soon add up and then when I’ve got a substantial amount of free time then I can sit down and write them all together. You are right though, sometimes there are long gaps between writing sessions.
LikeLiked by 1 person
Pingback: How to Write Your Novel Part II « Jacqui Murray's WordDreams…
Use Excel as you would a table, but only with the column headings. I tried row headings, but they quickly became fairly useless. Here’s a sample of what mine looks like as well as one from JK Rowlings.
LikeLike
I really discovered a lot because of you. Your article is absolutely on point! Listen to your gut then back that up with some data. I really liked your blogs. I take a look at your post about every hour or so. You have really hit the nail on the head.
LikeLike
So far so good-Jacqui. I do know that it feels really good to put plot, actions of characters, sucessful or not into these ‘blocks’. I’m really not a type A person, per se-I have a writer friend who is also an accountant & she uses exel-made perfect sense. But me ? No way! All it took was to give it a try. In addition, I am not familiar with Excel at all-never before a reason to use it! Any tid-bits of info about Excel you can share that would help?
LikeLike
I have been looking at all the different software available to help writers and was leaning towards scrivener – mostly because I use excel every day for work – but the reality is that I know excel really well and I’d have to learn any of the other options from scratch. Thanks for sharing your experience and method – this is a great help!
LikeLike
You and I are rare. I find putting my thoughts into excel to be relaxing, inspires my creativity. I tried several different writing software but nothing worked better than excel.
Let me know how it works.
LikeLike
This has been such a really awesome time! This stuff is like health food for my mind. Great blog, I look forward to see it improve ongoing. Thank you for making my morning great.
LikeLike
Jacqui,
I am so thrilled to find you! I have been searching for (I saw this at a writer’s conference) the excel spreadsheet for writer’s. I am not a systematic person-but I feel that at this point in my writing (I’ve been revising for a year now!) that this approach is much needed. There is too much to keep track of without it.
Also-very interested to hear more about your daughters journey to a midshipman in the Navy. I have a son who just finished high school entering into Mass Maritime in 2-wks. Its been an emotional roller-coaster! Not sure if either one of us is going to make it until the 20th when he reports to Orientation where I will not hear from him for 2-wks.
Any thoughts?
LikeLike
I’m glad you like the Excel spreadsheet approach. Some think it stifles creativitiy. Me–it tracks the details so I can be creative. It made a huge difference in my plotting.
For the USNA journey, check out my blog USNA or Bust. I even wrote a book on it! I have lots of info not only on the process but the Navy lifestyle. USNA Plebes are in the middle of their Plebe Summer right now–6 weeks of physical prep (some mental) for the Ac Year. My daughter’s out now, serving her country on the USS San Diego. What’s your son’s goal?
LikeLike
Pingback: Daily Dose of Excel » Blog Archive » Some Links
Pingback: Plotting a Story–with a Spreadsheet « Word Dreams…
Pingback: How to Write Your Novel Part III: Character Development « Word Dreams…
Pingback: How to Write Your Novel Part II « Word Dreams…