A little late to the party, but I made some more word count trackers, this time with Supernatural themes. There’s one each featuring Cas, Dean, and Sam, and also one featuring all three taking turns every month. So if you’re a SPN fan the boys will keep you company throughout the year while you write! Previews and download links are below – the previews are for the NaNo spreadsheets, but they look the same, I promise!
I’m working on two Once Upon A Time themed spreadsheets now, they’ll hopefully be up tomorrow. If there are any other designs you’d like to see, let me know.
Edit: OUAT designs are up and available now, a little late but at least they’re here!
The other designs are all posted here.
I also want to say a huge thank you to everyone who has donated! It’s amazing, and I hope you know how much I appreciate it. Same thing goes for all the lovely feedback and comments. It’s still a little incredible to me that people from all over the world are apparently using these, but it’s so awesome to see, and I love hearing from everyone.
As always, if you run into any problems, just let me know and I’ll look into it, but – fingers crossed – these should be bug-free. Enjoy!
These are really, really cool! Thanks a lot for taking time to make these.
Thank you for the SPN wordtrackers. The boys will motivate me to write at least *something* daily, just so I can pop in and say “squee!” (OMG. I sound like Becky. Gank me now…)
You’re awesome! ;)
Hey, thank you for these fantastic spreadsheets! I’ve been using the Sam one and although I didn’t manage to make last month’s target word count, I got about 75% of it done, which is a huge success for writer’s-block-plagued me :)
I’ve found a little bug in February though. In the ‘words left’ column for each day it’s actually minusing the year’s running tally from the monthly target. So if the monthly target is 15,000 and I wrote 9,000 last month and 1,000 this month the remaining words left for the current month is shown as 5000, even if I’ve only written 1000 words that month.
The formula for the ‘words left’ column is: =IF(ISNUMBER(O11),IF((E5-O11)>0,(E5-O11),””),””)
The month’s running tally is M11 and the year’s running tally is O11. But I’m not sure how to fix this bug. I tred changing all the Os in that formula to Ms but it doesn’t work.
Everything else is working fine in the spreadsheet (including the ‘Words left’ box at the top), it’s just this one bug. Do you have any idea how to fix it?
Also, I don’t know if it’s relevant but I’ve been using the spreadsheet in Libre Office, I don’t have MS Office but it seemed to convert fine.
Hi Svenja, the links for these seem to have stopped working. :(
Thank you for the OUaT spreadsheets. I love Rumple’s. I can just hear him saying “Get writing, dearie.”
the Spreadsheet links seems to be disabled :( any plans of re-enabling them ?
Awesome! Thanks!
Hi. I downloaded the Dean word count spreadsheet and none of the images are there. It’s just a basic word count. And I was wondering if you could do one that went for, say, two months instead of twelve?
Holy moly, these are spectacular! They are so much *prettier* than the one I made up!
Also… your art is amazing.
Wow.
Haha! :D We all sound like Becky sometimes, I think, so you’re all right. ;) I hope it’s working out for you, good luck with your writing! :)
Glad you like them, and thank you! :)
Ohhh, you’re right. That is wrong. Changing all the O’s to M’s should work, though. That’s what I’m doing now. Give this a try, and see if it works for you? It’s the edited version.
Thanks for pointing it out! I’ll go back now and fix all the others. I guess I wasn’t paying attention when I made that column!
And I’m glad this has been helpful for your writing, that’s really really cool! And congrats on making it so far despite writer’s block! :D
I got it to work! I must have been doing something wrong the first time but I tried changed the Os to Ms and it worked this time. The new one in the link works as well. Thank you!
And yeah, these spreadsheets have been really helpful. I love that you have SPN versions as well. Sam’s my favourite character so it’s like the little picture of him is encouraging me to keep writing with his steely gaze! XD
Between this and Write-or-Die I’m getting loads of writing done! :D
Oh excellent! So we both managed to fix it then, that’s great. Thanks again for pointing it out!
And it’s so cool to hear that these have been helpful. Or rather, Sam’s steely gaze. Whatever works. :D That’s great news, yay for writing! :D I love Write or Die. And sometimes I hate it. *lol* But it’s SO good for productivity!
That’s weird, they’re working fine for me. :/ But I can email you the spreadsheets you want, if the links don’t work for you? Just let me know which ones you want. :)
Thank you, I got them now! Looks like the issue was on my end — my PC had blocked Dropbox links and didn’t feel like telling me.
Thank you so much for the awesome spreadsheets. :D
Ah, that explains it. I’m glad it all works now though! :D And you’re very welcome!
No problem, I’m glad you like them! I bet Rumple makes for a good muse. :D
Huh, you’re right. Apparently Dropbox disabled them for some reason. I’ve re-enabled them and they should work again now. Thanks so much for letting me know!
No problem, glad you like them! :)
Hmm, weird – I tried it and they show up fine for me. Maybe it’s the program you’re using to open it? And you can actually adjust it to work for as many months as you want – if you fill in “0” as your word count for all the months you DON’T want it to count, it’ll ignore all those months and adjust everything automatically. I hope that helps!
I tried using Microsoft Spreadsheet, and the images still will not show up. When I view it in my dropbox, the pictures are there. But when I download it and open it in Spreadsheet, they’re not. What program are you using?
Ignore last comment. It finally worked. Lol. Writer’s brain, I guess.
Yay, glad you got it to work! :)
Thank you! I’ll have new ones up for this year’s NaNo and also for 2015. :) I’m glad you like them! And thanks for the kind words about my art as well! ^^
I’m fascinated, because I work with Excel for a living, and you do things with this sheet I’ve never seen (mostly the status bar) (and the colors and images behind the charts!)
Thanks! I learned by looking at sheets other people had made and figured out the principles from that, pretty much! The images in the charts is pretty straightforward, it’s just an option in the format dialog box! :)