Spreadsheets....

[spacedogfromspace]

So when I started writing I kept track of word counts and time spent in a little book because I like stats... except my math is off sometimes so later on I also made a spreadsheet to basically do the math for me. It's cool. My 2023 one shows me how many words I wrote each month, and how much time I spent, and also how much I wrote over the whole year and the total since I started writing. And you can see the difference between how many words were drafting words and how many were editing words...

But now 2024 is on the horizon and I'm... tweaking the spreadsheet. Now I want to see the following things in my monthly, yearly, and all time stat boxes: 1. total words written* 2. total time written in both minutes hours* 3. number of words drafted* 4. time spent drafting in minutes and hours 5. number of words edited* 6. time spent editing in both minutes and hours 7. total fanfiction wordcount 8. time spent writing fanfiction in minutes and hours 9. total original fiction wordcount 10. time spend writing original fiction on minutes and hours 11. total creative non-fiction wordcount 12. time spent writing creative non-fiction on minutes and hours

*Stats that are in my 2023 spreadsheet

Just overall a big ol' breakdown of stuff. I knew I wanted to show time editing vs drafting which isnt in my current sheet, but I also am thinking of doing some creative non-fiction (book reviews, episode analyses, etc) and maybe some original fiction (it's all been fanfic so far since I started) that I thought I'd think ahead and add those categories too.

I'm not very good at google sheets and this is a bit more complicated than the last one I made... so it's a learning experience. I'll probably make a blank template copy of it to share once it's done!