Writing productivity trackers
I'm looking for an exhaustive writing tracker, either software or a spreadsheet. ideally, the basic things it would need to track are word count per session, projects worked on, submission status, etc. The more things related to writing to track the better.
If there's a way to create or it includes graphs that would be amazing. Basically, the more it looks like productivity porn, the better.
I'd really like this to be some kind of software or website, so I don't have to have multiple "2014 Writing Year", "2015 Writing Year", etc. files in a folder on my computer. But I haven't been able to google up anything that fits what I'm looking for. I do have one giant spreadsheet that I've been using, but I made the mistake of renaming it so I can't just say "Hey, I'm looking for something a little more involved than So-and-so's Spreadsheet of Doom" or whatever.
The thought behind the ask: I write better when I have something that will visually show me "hey if you don't write something you're going to break your streak, loser", and I write more if I'm trying to beat someone, including myself. The shinier something is with the more bells and whistles, the more likely I am to consistently use it. Basically, I'm trying to instill good writing habits in myself by tricking myself into having good writing habits, using methods that have worked in the past for other things.
Can anyone help?
This post was sourced from https://writers.stackexchange.com/q/19764. It is licensed under CC BY-SA 3.0.
2 answers
You are accessing this answer with a direct link, so it's being shown above all other answers regardless of its score. You can return to the normal view.
Excel, absolutely.
You might not want to consider this, but give it a shot. Here are the things it could do for you:
- Word Count. It has this one in the bag. Simply write for a session and count the words. If you're using MS Word, just highlight the words. It will tell you the word count down on the bottom of the screen. I know there are also websites/programs that can do this for you. Then just put that number into Excel. The next time you write, put the second number next to the first. Then run a formula to calculate the average. You can keep from having to update the formula by inserting columns/rows before the formula to add new data. When you do this, Excel automatically changes the formula to include the new column or row.
- Projects. Simply make a new sheet in the same file. This way, you have one big file with all of your past, present, and future projects in it. In addition, you can see the specs of each project individually. Be sure to back this big file up somewhere.
- Submission Status. It's up to you how you want to track this. I use Excel to track my writing progress in a similar fashion. I have an in depth development process, followed by the writing process. For each step, I have a cell containing how much I think the step is worth (for example, a particular step may be worth 1, and another may be worth 5 because it takes longer). As I go through the process, I have another column that I fill in with numbers corresponding to the step value, as I complete them. At the top of the sheet, I have a cell with a formula dividing the sums of the two columns by each other and writing the result as a percent, so telling me how far I am through the project.
- Graphs. They're a little hard to work with in Excel (Word is easier to arrange them), but MS Office 2007 and up has a lot of excellent charts and graphs you can use to track practically anything. Want a line graph depicting how often, how much, and when you write? No problem. Want to later change that line graph to a different format (of a line graph) without losing the data? No problem.
Something else you could consider is MS Access. It's not as easy to work as Excel or Word, and you need to know what you are doing, but it is ultimately far more powerful than either.
Hope that helps!
0 comment threads
You can try my old buddy Scrivener. I don't use even a quarter of the bells and whistles I know are there, so hunt around the documentation and see if it's useful. I know it at least has a Goal function so you can set a word count goal to meet, and keeps track in the footer.
Inexpensive program, you own it rather than rent it (I'm looking at you, Adobe), and the trial is fully powered for the trial period rather than being crippled.
0 comment threads
0 comment threads