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).

116 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

  23. sugar defender Incorporating Sugar Protector right into my day-to-day program has
    been a game-changer for my overall well-being. As somebody who already prioritizes healthy consuming, this supplement has actually
    given an included boost of defense. in my energy levels, and my wish for undesirable treats
    so simple and easy can have such an extensive impact on my day-to-day live.
    sugar defender reviews
    sugar defender | sugar defenderMy Profile

  24. I’m now not positive the place you’re getting your info, but good topic. I must spend some time learning much more or figuring out more. Thanks for excellent info I was in search of this information for my mission.

  25. benazepril ezetimibe 10 mg side effects The solution is obvious enough the end of the State Championships in their current format they need not necessarily be scrapped the small teams can play each other in a league basis for a few months, for example, with the winners qualifying for the second phase, with the big clubs, played as a midweek cup competition can i get cytotec without a prescription

  26. I am not sure the place you’re getting your information, but good topic. I needs to spend a while studying much more or working out more. Thanks for magnificent info I used to be searching for this info for my mission.

  27. This is a topic that is close to my heart… Cheers! Where can I find the contact details for questions?

  28. Wonderful post! We are linking to this particularly great post on our site. Keep up the great writing.

  29. It’s hard to find well-informed people in this particular subject, but you sound like you know what you’re talking about! Thanks

  30. I blog quite often and I seriously appreciate your information. The article has really peaked my interest. I am going to book mark your site and keep checking for new information about once per week. I opted in for your Feed as well.

  31. Hello there, just changed into alert to your weblog thru Google, and found that it’s really informative. I’m going to watch out for brussels. I will appreciate if you continue this in future. Numerous other folks shall be benefited out of your writing. Cheers!

  32. You could certainly see your expertise in the work you write. The world hopes for even more passionate writers like you who aren’t afraid to say how they believe. Always go after your heart.

  33. Pretty! This has been a really wonderful article. Thank you for supplying this info.

  34. Please let me know if you’re looking for a author for your weblog. You have some really great posts and I think I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some content for your blog in exchange for a link back to mine. Please shoot me an email if interested. Regards!

  35. Nice post. I learn something totally new and challenging on sites I stumbleupon everyday. It will always be interesting to read through content from other writers and practice something from their websites.

  36. You need to take part in a contest for one of the highest quality websites online. I’m going to recommend this site!

  37. Way cool! Some very valid points! I appreciate you penning this write-up and also the rest of the site is also very good.

  38. It’s hard to come by knowledgeable people on this topic, but you seem like you know what you’re talking about! Thanks

  39. Oh my goodness! Amazing article dude! Thank you, However I am going through issues with your RSS. I don’t understand the reason why I cannot join it. Is there anybody else getting the same RSS problems? Anybody who knows the answer can you kindly respond? Thanks.

  40. Terrific work! This is the type of information that should be shared around the web. Shame on Google for not positioning this post higher! Come on over and visit my site . Thanks =)

  41. Having read this I believed it was really informative. I appreciate you taking the time and effort to put this short article together. I once again find myself personally spending a significant amount of time both reading and posting comments. But so what, it was still worth it!

  42. I really like reading through an article that will make men and women think. Also, thank you for allowing for me to comment.

  43. This is a topic which is near to my heart… Best wishes! Exactly where can I find the contact details for questions?

  44. I love reading a post that can make men and women think. Also, many thanks for allowing me to comment.

  45. I think other site owners should take this web site as an model – very clean and fantastic style and design, not to mention the content. You’re an expert in this area!

  46. Greetings! Very useful advice in this particular article! It is the little changes that make the greatest changes. Many thanks for sharing!

  47. I seriously love your blog.. Pleasant colors & theme. Did you develop this amazing site yourself? Please reply back as I’m wanting to create my own personal blog and would love to know where you got this from or what the theme is named. Cheers!

  48. I think this is among the most vital info for me. And i am glad reading your article. But want to remark on some general things, The site style is great, the articles is really great : D. Good job, cheers

  49. You ought to be a part of a contest for one of the highest quality websites on the internet. I most certainly will highly recommend this web site!

  50. Great – I should certainly pronounce, impressed with your website. I had no trouble navigating through all the tabs as well as related info ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your customer to communicate. Excellent task.

  51. Your style is unique compared to other folks I’ve read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just bookmark this blog.

  52. It’s best to take part in a contest for one of the best blogs on the web. I will recommend this website!

  53. This is really attractive, You’re an exceedingly seasoned article author. I’ve joined with your feed and furthermore , look ahead to viewing all of your awesome write-ups. What’s more, I’ve got shared your webblog throughout our web pages.

  54. Hello there, I think your site could be having internet browser compatibility problems. When I look at your site in Safari, it looks fine however, if opening in IE, it’s got some overlapping issues. I just wanted to give you a quick heads up! Other than that, great blog!

  55. Undeniably believe that which you stated. Your favorite reason appeared to be on the net the simplest thing to be aware of. I say to you, I certainly get annoyed while people consider worries that they plainly do not know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side effect , people can take a signal. Will likely be back to get more. Thanks

  56. Pleased to determine this website is useful on my small iPhone , every little thing I want to do can be well-designed. Thanks for keeping it up currently using the newest.

  57. Hello, you used to write great, but the last few posts have been kinda boring? I miss your tremendous writings. Past few posts are just a little bit out of track! come on!

  58. There are a few intriguing points in time in this post but I do not determine if I see these people center to heart. There is some validity but I will take hold opinion until I investigate it further. Excellent article , thanks and we want more! Added onto FeedBurner too

  59. Aw, this has been an exceptionally good post. In concept I would like to place in writing similar to this moreover – spending time and actual effort to have a really good article… but what can I say… I procrastinate alot and by no means seem to get something completed.

  60. Hi there, There’s no doubt that your web site might be having internet browser compatibility issues. Whenever I look at your website in Safari, it looks fine but when opening in Internet Explorer, it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Aside from that, wonderful site.

  61. Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something. I think that you could do with a few pics to drive the message home a bit, but other than that, this is fantastic blog. A great read. I’ll certainly be back.

  62. Thank you for any other great article. The place else may just anyone get that type of information in such a perfect method of writing? I’ve a presentation next week, and I’m at the look for such info.

  63. Thank you for the good writeup. It in fact used to be a enjoyment account it. Look complicated to far brought agreeable from you! However, how can we keep up a correspondence?

  64. You need to take part in a contest for one of the most useful websites on the internet. I will recommend this web site!

  65. Your style is unique compared to other people I have read stuff from. Many thanks for posting when you have the opportunity, Guess I’ll just book mark this page.

  66. I have been exploring for a little for any high quality articles or blog posts in this kind of area . Exploring in Yahoo I ultimately stumbled upon this web site. Reading this information So i¡¦m glad to show that I have an incredibly good uncanny feeling I came upon exactly what I needed. I such a lot indubitably will make certain to don¡¦t forget this web site and give it a look a relentless basis.

  67. This web page is usually a walk-through its the internet you wished about it and didn’t know who must. Glimpse here, and you’ll certainly discover it.

  68. After a brief firefight that results in the hood of Highsmith’s car getting blown into the windshield, the two inadvertently crash into the side of a double decker bus.

  69. I’d need to talk with you here. Which is not some thing I usually do! I spend time reading an article that will get people to believe. Also, many thanks for permitting me to comment!

  70. Nice read, I just passed this onto a friend who was doing some research on that. And he just bought me lunch since I found it for him smile Thus let me rephrase that: Thanks for lunch!

  71. Greetings! This is my first comment here so I just wanted to give a quick shout out and tell you I genuinely enjoy reading through your blog posts. Can you recommend any other blogs/websites/forums that deal with the same topics? Thank you so much!

  72. Good post. I learn something new and challenging on sites I stumbleupon every day. It’s always helpful to read through articles from other authors and practice a little something from other sites.

  73. Currently it seems like BlogEngine is the best blogging platform out there right now. (from what I’ve read) Is that what you’re using on your blog?

  74. It’s actually a nice and helpful piece of info. I am happy that you simply shared this useful information with us. Please keep us up to date like this. Thanks for sharing.

  75. I really like reading an article that can make men and women think. Also, thank you for allowing for me to comment.

  76. I and my pals ended up viewing the best pointers found on your web site while suddenly developed a horrible feeling I never thanked the website owner for those tips. All of the people were totally passionate to read all of them and have now surely been tapping into these things. We appreciate you indeed being well considerate and also for finding these kinds of excellent themes most people are really eager to understand about. My very own sincere regret for not saying thanks to earlier.

  77. Aw, this was an exceptionally nice post. Taking the time and actual effort to produce a top notch article… but what can I say… I procrastinate a whole lot and never seem to get nearly anything done.

  78. Next time I read a blog, Hopefully it does not fail me as much as this particular one. I mean, Yes, it was my choice to read, but I actually thought you would have something useful to say. All I hear is a bunch of crying about something you can fix if you weren’t too busy seeking attention.

  79. Excellent web site you’ve got here.. It’s difficult to find quality writing like yours nowadays. I truly appreciate individuals like you! Take care!!

  80. Hello! I simply wish to supply a massive thumbs up for your wonderful information you might have here on this post. I am returning to your blog post for more soon.

  81. After examine a couple of of the weblog posts in your website now, and I truly like your manner of blogging. I bookmarked it to my bookmark website list and might be checking back soon. Pls take a look at my website as effectively and let me know what you think.

  82. It’s rare knowledgeable men and women for this topic, but the truth is be understood as you know what you are discussing! Thanks

  83. The both of us really enjoyed your post. It appears like you’ve put a lot of effort into your story and the human race need much more of these on the Net these days. I do not real have a large deal to say in retort, I just wanted to comment to tell well done. marvelous post. i never thought of that.

  84. To your organization online business owner, releasing an important company is the bread so butter inside of their opportunity, and choosing a wonderful child care company often means the particular between a victorious operation this is. how to start a daycare

  85. I was able to find good advice from your content.

  86. I truly love your website.. Great colors & theme. Did you create this web site yourself? Please reply back as I’m planning to create my very own blog and would like to learn where you got this from or what the theme is called. Thanks!

Leave a Reply

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

CommentLuv badge