Writing Advice: Managing Progress

I like spreadsheets. If there is a place, there will be a spreadsheet. And writing is no different. I have in the past recommended an app called Writeometer that I used to manage my writing progress and now I have started a new book once more. However, when I went to download the app again, I found it no longer existed.

Just starting a new book and already falling at the first hurdle I was very downtrodden. So, what to do? MAKE A SPREADSHEET OF COURSE! Now I’d like to share how I track my progress which shall be a half writing blog and half maths blog so you’re in for a treat aren’t you (it’s not that much maths).

DSC_0507

First what is your target? It could be chapters or pages or scenes. I track my progress using both words and scenes because I plan my book by scenes and words are much more accurate than using pages in my opinion. I aim for 200’000 words because it’s probably a bit long so I will finish the book before I get there but also, I know how much I write so I need to aim high.

Then decide how many words you can write in a day? Be realistic, it’s nice to challenge yourself but choosing a target that you will never reach day in day out you’ll only make yourself upset. I can do two thousand words on a good day. So then, from this you can work out how many days it should take you to write your book (days = total word count/words per day). Now if this target seems too tight you can obviously change it. There are no hard and fast rules of course, you know you own abilities best.

DSC_0528

I then diarise these days in a spreadsheet so I can see how many words are written per day and measure how far I am from my target (% target = actual word count per day/target word count per day).

Now onto scenes. I never plan to write a scene per day because my scenes dramatically change in size – 1st scene was 10’053, 2nd was 7’243 and the 3rd was 1’012. But this means I can keep an eye on how much of my book is complete, given I have no idea how long it will actually be in terms of words, but I do know how many scenes there should be. I list the number of scenes there should be and then put 1s beside them as I complete them and total that up at the bottom (% scenes completed = total completed scenes/number of scenes).

I also, just to be that little bit extra, colour code my completed scenes by how good I feel they are. Green for good, orange for needs a bit of work and red for definitely needs a rewrite. It’s all to help when I come round to editing them.

 

2 thoughts on “Writing Advice: Managing Progress

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s