There may be bugs. In fact, considering the number of formulas, despite the hours of bug hunting I’ve done… there are probably bugs. I did this for me and am sharing with you because I can, so please be kind if you find a bug. I’ve removed as many as I was able to without actually *using* the sheet, but I typically correct bugs as I find them and upload a new version.
Anyway, a LOT has changed compared to last year’s sheet. Instead of a monthly planner, it is now a daily planner. The yearly overview sheet is gone; you now get the monthly word count in the monthly planner spreadsheet, which still exists to let you see how many words you’d write in a month *if* you were writing $x per day. It’s meant to be a tool to help you use the daily planner.
I needed the daily planner I could adjust/work on as I go, and I needed to be able to track weekends/plan around weekends better, thus the changes.
Anyway, you can download the sheet here: https://www.dropbox.com/s/x4674cvwa0o5nwq/2022%20Wordcount%20Planner%20and%20Tracking%20Sheet%20-%20Public%20Master.xlsx?dl=0
Here’s a quick and dirty list of changes:
Daily average word count goals is now calculated as an average off the daily planner sheet, which is broken up by week.
Panes are frozen to allow you to scroll left/right and view the date.
The sheet maxes out at 24 projects. The number of formulas would make the sheet utterly unwieldy. If you want more projects in the same sheet… good luck. You’ll need it. I recommend just using a second copy of the sheet if you exceed 24 projects.
Ask questions if you have them here. I will do my best to answer them for you as I have time. At time of posting this, I’ve been working on this for around 8 hours and I redefine what it means to be tired.
If you don’t like how I do the sheet or color the sheet, etc, color it however you like, but I won’t be color-stripping, etc on request. (This is meant for my use, I’m just sharing because I can.)
I do NOT recommend deleting ANY rows anywhere in this sheet. You will destroy the sheet. I won’t fix sheets that were modified, sorry. (I will try to fix actual bugs and update the sheet, but if you delete half the projects because you didn’t need them and it broke the formulas… that’s not my problem.)
if you don’t want to see the excess projects, I recommend you use the paintbrush and text color tool to turn those projects white and leave the spreadsheet intact.
Is there going to be another book in the water viper series
Absolutely! I haven’t decided if I’m doing an anthology of side stories featuring the whole crew or if I will be doing the next. It will be a quartet with an anthology of side stories once completed.
Just a thought, It would be really fun to see the cindercorn household that first summer with all the kids and watching them figure out police chief if with I think it maxed out at 6 kids
Are you going to do a book about Dustin Walker? I read the anthology and thought a book about him would be good.
Maybe/maybe not. I have the idea for one, just don’t know if I’ll have the spoons/energy to write it. I enjoy the character a LOT but he’s not a huge seller, so he’s very much last in line. We’ll see.
Hello R.J. Blain,
I just wanted to thank you for sharing this great spreadsheet. This has solved so many headaches for me! I now use it and I adapted it to my needs. For sure, you and your friends who contributed into this tool will be in my list of thank you in my first publication! 🙂 Thanks!