I have a present for you guys! Well, maybe you won't need it, but I made it all the same.
This last year, I had a bit of trouble juggling multiple projects. I have to "see" things to understand them. I have to "see" that if I take tomorrow off, I'll need to write X number of words a day to stay on track for my deadline.
I would have KILLED for this worksheet, then. I didn't even know you could track your progress this way, until the wonderful and amazing Meljean Brook sent me the worksheet she uses! (So thank her, because deconstructing her worksheet allowed me to make this one.)
As long as you do your set-up correctly, all you have to do everyday is type in your ending word count.
So it's easy... but the set-up isn't quite as much. If you want me to setup or customize one for you in Excel 2009, then I'll be happy to. You don't, of course, have to write six novels, LOL. They can be novels, novellas, short stories, edits, rewrites, whatever. Or you can delete the extras altogether. Again, if you don't know how to use Excel, I'll be happy to customize one for you.
The best part: the pretty charts it makes! (I'm a teensy bit proud of myself: two days ago, I didn't have a clue how to work Excel!)
I posted links so you can download them, too! It's tons prettier in Excel 2007, and I'm pretty sure Excel 2003 strips out all the pretty charts. :-(
You can download it here:
PRETTIEST: Excel 2007: Juggling Multiple Books
Google Spreadsheets: Juggling Multiple Books
Older Excel: Juggling Multiple Books (I don't have an older version of Excel, but I think it strips out my pretty charts. Hopefully you can put them back in?)
As a bonus New Year's present, if you have trouble customizing it, I'll customize one for you (on Excel 2007), if you send me all the info and stuff. It might take me a few days, but I'd be happy to.
Here's a walkthrough:
First, there's the Overview page, where you can see where you are for the year, all in one spot. It pulls information from each novel's page, so once it's set up, you don't need to fiddle:
On this page, I also track my proposal progress, so you can keep that or delete that:
Then each novel's page does several automatic calculations. Four, as you can see:
And, of course, we need a pretty graph to motivate us:
And finally, the "End" column is the only thing you need to update each day, and everything else automatically calculates for you! Under the "Daily Count" column, it lets you know whether you're under or over your goal. In the "Target" column, it lets you know the same thing, except every 5 days.
So how do you juggle multiple projects? Do you use any pretty charts to keep you motivated along the way to meeting your goals?