The Great Scene Tracker

I am going to share with you my greatest writing tool, the thing that keeps me sane in the crazy made-up world in my head.  Behold, the Scene Tracker(Please note: This is an excel file.  It was virus free when it left my computer, but because I don’t want any mean emails, etc., you are downloading at your own risk, I make no guarantees as to how it will affect your computer).

Now that I’ve scared the crap out of you and you probably wouldn’t download it if I paid you, we’ll discuss it’s merits.  Here is an actual image of mine from my finished novel.

A sample of my actual scene tracker for a finished work
A sample of my actual scene tracker for a finished work

You can just click it to get a nice full size view.

In the first column, you’ll see that I divided my scenes into chapters.  I didn’t do this at first, I did it later, as I looked them over.  I think that in the future, I’ll be writing with the chapter endings in mind, so I can be sure they end with page turning material.  But, whatever works for you.

In the second column, I’ve done two things.  First, I’ve divided the book up into Acts (I guess that was actually done on different rows as opposed to columns, but let’s keep going.)  I’ve also numbered each scene as they occur in the act.  You’ll notice that scene 9 is greyed out.  I did that because I was considering (and did) taking the scene out.  By being able to see my story as a whole on this spreadsheet, it became clear that the scene served no purpose and this character didn’t really need a POV.  Ever.  So, if my scene tracker did nothing else for me, that alone would’ve made it worth it.

Okay, next column: the timeline.  I didn’t think, at first, this would matter.  And then I realized that in the beginning of this story, Act I takes place over a week.  And my week?  Had 8 days.  That’s why I created this spreadsheet, to help me keep track of what happened, when.  Later on, when I needed my character to make reference, I could easily go back and see that event had happened two weeks prior.  You may think you will remember this… but you won’t.  Because it’s been a month or six for you, or maybe just two days, but it probably wasn’t two weeks.

The next column gives a brief description of what action takes place in the scene.  Generally, when I’m writing, I make four folders and name them for each of the acts.  Each scene is it’s own file in the respective folder, so the third scene was named: scene 3 justine tells mom.doc.  It keeps them in order in the folder and lets me know at a glance what the scene is about.  Sure, it’s cryptic to you, but I know exactly what she’s telling her.  I just need a little jab to the memory.

Skip two columns over where the page count for the scene is listed.  If you look all the way down to Row 22 of that column, you’ll see that Excel did my math for me.  I know how long my first act is now.  It’s a bit over my target (at least 15 pages, yikes), in fact, so I know with just a look, I’m going to have to cut.

After that: Chapter length.  This formula isn’t built in because it depends on how many scenes are in your first chapter, or second.  But it’s still fairly simple, even if you want to do the math yourself.  For me, a chapter goal is about 20 to 30 pages.  Your mileage may vary, but the point is, when I go to cut, I can look at this and see where I got a little wordy or if maybe I need to reorganize how I divided my chapters.

The next is self-explanatory: whose POV is the scene in.  Next to that, the number of pages each character is getting, as a whole.  I’m not a head hopper, but I do know who my hero and heroine are and who my secondary characters that are getting page time are, and I know a secondary character shouldn’t be getting more and I’d like my hero/heroine to be close to even.  Again, it’s right there, at my fingertips.  I’ve compiled the information as I wrote.  This formula is also not included in the above file for similar reasons–it’ll be different for every story.

The next column isn’t on this picture, I added it to my blank template, the one you’re getting.  Emotional Arc.  The fourth column tells the action.  This column tells the emotional outcome/events of the scene.

Finally, my notes for editing.  I highlighted in column K each day so I’d know what I’d done in my first round of editing and the  notes tell me what is yet to be done.  I can also make a note, like, “Did the necklace come up again anywhere?” (if not, I take it out), or “Mention the number of suitcases,” because I know later, it’s going to be noticed by someone else.

At the very bottom, not pictured here, is the total page count for my novel.  Another perk is that I want my acts to get shorter, so Act 1 should have more scenes than Act 2.  And I can see that it does.

That is the Scene Tracker I’ve created, which you are more than free to use if you believe it would help you.  I hate to pull a Dawn–inside joke, sorry–but don’t redistribute this or repost it anywhere else.  Link back to the post, please. (Just click the title, then copy and paste from the address bar).

31 Comments

  1. But does Scene Tracker make you look fat? That’s the real question.

  2. This looks very workable. I have several structures I keep track of ad putting the in one place like this would help. thanks for the visual!

  3. Hi
    I’m finding your words to help track your excel sheet is missing pieces. I’m not sure what column is your words or pages. It appears you may have hidden parts of the viewing panel. The example I downloaded does ot show the comments to remind the storyteller on what goes where.

  4. Hi Michelle,
    I opened the spreadsheet up that is presented here and I’m not sure what piece is missing. I honestly don’t use this anymore. It was more helpful to me in the past than now, when I plot so much ahead of time.

    If you want to email me, I can break out an old one and we can compare to see what I might’ve left out. lori @ lorisizemore(dot)com

  5. Thanks for your thoughts. One thing really noticed is banks plus financial institutions really know the spending behavior of consumers while also understand that plenty of people max out their own credit cards around the holidays. They smartly take advantage of this kind of fact and begin flooding your inbox and snail-mail box by using hundreds of Zero APR credit cards offers immediately after the holiday season comes to an end. Knowing that if you’re like 98 in the American open public, you’ll get at the possible opportunity to consolidate personal credit card debt and move balances to 0 rate credit cards.

  6. Hey there just wanted to give you a brief heads up and let you know a few of the pictures aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different web browsers and both show the same results.

  7. Hello, i think that i noticed you visited my website so i came to “go back the desire”.I’m trying to find things to improve my site!I suppose its ok to make use of a few of your concepts!!

  8. I every time emailed this blog post page to all my associates,
    because if like to read it afterward my friends will too.
    Proxies buy | Proxies buyMy Profile

  9. Quality content is the important to invite the
    viewers to go to see the web site, that’s what this web page
    is providing.
    Proxies Buy | Proxies BuyMy Profile

  10. For many years, the most commonly used antibiotics for treatment of brucellosis were tetracycline, trimethoprim sulfamethoxazole, aminoglycosides, rifampicin, quinolones, chloramphenicol, doxycycline, and streptomycin 5 7 buying priligy online

  11. Thanks for another informative web site. The place else may I am getting that type of info written in such a perfect approach? I’ve a venture that I’m just now working on, and I’ve been at the glance out for such info.

  12. Hey there! I know this is kinda off topic but I was wondering which blog platform are you using for this website? I’m getting sick and tired of WordPress because I’ve had issues with hackers and I’m looking at options for another platform. I would be great if you could point me in the direction of a good platform.

  13. Thanks for the helpful post. It is also my belief that mesothelioma cancer has an particularly long latency interval, which means that signs and symptoms of the disease won’t emerge until 30 to 50 years after the preliminary exposure to mesothelioma. Pleural mesothelioma, which can be the most common style and has an effect on the area within the lungs, may cause shortness of breath, breasts pains, and a persistent coughing, which may lead to coughing up blood vessels.

  14. Hi it’s me, I am also visiting this website regularly, this website is
    in fact nice and the visitors are really sharing pleasant thoughts.
    PrivateProxies | PrivateProxiesMy Profile

  15. Thanks for your text. I would also like to say that the health insurance brokerage also works for the benefit of the particular coordinators of a group insurance policy. The health broker is given a long list of benefits sought by individuals or a group coordinator. What any broker will is hunt for individuals and also coordinators which best match those requirements. Then he shows his tips and if the two of you agree, the particular broker formulates a contract between the 2 parties.

  16. I think other web-site proprietors should take this website as an model, very clean and excellent user friendly style and design, let alone the content. You are an expert in this topic!

  17. Профессиональный сервисный центр по ремонту бытовой техники с выездом на дом.
    Мы предлагаем: ремонт крупногабаритной техники в москве
    Наши мастера оперативно устранят неисправности вашего устройства в сервисе или с выездом на дом!

  18. You must take part in a contest for top-of-the-line blogs on the web. I’ll advocate this web site!

  19. Hiya, I’m really glad I’ve found this info. Today bloggers publish just about gossips and web and this is actually annoying. A good blog with interesting content, that is what I need. Thank you for keeping this web-site, I will be visiting it. Do you do newsletters? Can not find it.

  20. Профессиональный сервисный центр по ремонту компьютеров и ноутбуков в Москве.
    Мы предлагаем: вызвать мастера по ремонту макбуков
    Наши мастера оперативно устранят неисправности вашего устройства в сервисе или с выездом на дом!

  21. Hello there! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying
    to get my blog to rank for some targeted keywords
    but I’m not seeing very good gains. If you know of
    any please share. Cheers! I saw similar text here:
    Wool product
    Kristine | KristineMy Profile

  22. sugar defender Finding Sugar Protector has been a game-changer for me, as I have actually always been vigilant regarding handling my blood sugar level
    levels. I now really feel encouraged and certain in my ability
    to preserve healthy levels, and my newest checkup have mirrored this progression. Having a credible
    supplement to enhance my a big resource of convenience, and I’m absolutely grateful
    for the substantial distinction Sugar Protector has actually made in my general health.

    sugar defender
    sugar defender | sugar defenderMy Profile

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge