So I finished Nanowrimo, and then like the survivors of great battles and those that complete marathon races, I had a very bad case of fatigue and I was overcome with a serious case of ‘What the f$%k do I do now?’
I made sure of course that I backed up all of my files; multiple times (in Drop box, One Drive, USB, External backup) and – as I was using Scrivener, made sure I took a snapshot of the work, before I ever go back and then sat there, twiddling my thumbs. There as lots of twiddling. Lots of doubt. Lot’s of house cleaning and social engagements to fill up my time predominantly, but when in front of a computer – and starting at a blank screen – still faced with the same question: What to do?
I very much wanted to rest MUTAGENE – my Nano novel – and wait a while before revisiting it for editing / rewriting purposes. There are some plotting / planning activities and exercises I can still do on it, if I get desperate. But I wanted a break from it. After all, things had grown stagnant and we both needed to see other people. Or at least I needed some fun.
So I trawled back through my folders, trying to work out which of my other legacy projects was in need of love – as I didn’t have any burning new ideas to work on at that moment. That’s when I realised that I not only had one candidate, a short story I’d forgotten about (called ADRIFT), I also stumbled across a feature script I’d completely forgotten that I’d written (for a Script Frenzy competition a few years back)! Such a shambles. Such disorganised folders and files! And entrusting my faulty memory to guiding me clearly wasn’t working all that well. I decided that I needed to come up with a more appropriate plan to manage my writing projects.
After some soul searching, and some web searching, I realised that I needed a tool, like a database to track / catalogue every single idea, and I then needed to track which ideas then get worked on and when they become ready for circulation or publication.
I had three options:
- an online writing database tool, such as writersdb and QueryTracker.
- using Ulysses or Scrivener to track all of my projects; or
- building my own tool to track all of my ideas and projects.
It wouldn’t be fun building such a tool, or populating it. But afterwards I would be in a much better position to track each idea through to completed project, and track my career more professionally – e.g. evaluate how much money I’d paid for editing surfaces, or been paid for successful story submissions, or for contest submission fees for scripts etc. I’d then have enough data to take stock of how things were progressing and make a judgement as to whether, like any business, it was still worth pursuing; or if torn between taking different roads, I’d have more than a gut feel to direct my decisions.
I didn’t really feel a need to track my writing each day, as that data would sit within Scrivener, or could easily be tracked in each project if I wanted to. And I was wary of my data being online, and being restricted to someone else’s design. And although I saw how someone else was using Scrivener to do their project management, it didn’t resonate with me. Seemed overly bloated and cumbersome. I wanted something small and portable. So I turned to what I know – I know spreadsheets. I know Excel.
So here’s what I built:
An excel sheet that has a project tracker tab: that tracks the name, type of project, genre (for film and prose), what stage it is in and what draft no and what is the latest file version.
It also has a second tab for tracking submissions – once you’ve ushered a project through to completion on the first tab, you go to the tab called ‘Manuscript Script Submissions’ – for screenplays you submit to competitions or production companies, or manuscripts you submit to publishing companies or literary markets – and the feedback or decisions you get on that work, that may help you shape how you later go back to the rewrite / edit stage.
The drop downs are populated on a third tab – so you can edit the field to your heart’s content and customise it to fit.
DOWNLOAD THE FILE HERE:
Please do download it. Give it a whirl. It’s nothing fancy. But it works for me.
Feel free to try it out, if you think that it might be useful for you also. If you change it, I’d love to know why and how, in case it may be useful to put it into a new version to share with others. And also, if you think it’s flawed – please let me know and I’d gladly consider any amends. I’m especially curious to know if there’s anyone else out there in the same boat, with more ideas than organisation.
For now, I’ve got some data to populate into this thing. I’ve got one short story to write. And then I need to plan how I intend to start my Nano novel editing / rewrite process; come January I want a proper plan in place.