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.
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.