I know that some of you out there are as obsessive as me when it comes to trying to track your progress and work habits during Script Frenzy so I decided to share my personal calculator. It’s simple but very powerful. (If you aren’t sure why you should be taking such an in depth look into your daily writing habit over the course of Screnzy, I invite you to read this article.)
This calculator will work in Open Office, Microsoft Excel or Google Docs, depending on what you use. But it works best in Google Docs since that is what I set it up in (there are also some handy little charts in the Google Docs version the other versions won’t get).
It is very simple to use. All you do is type in your page and word count each day (or just a running total, if you prefer) and then it calculates your percentage done, average words and pages per day, average words per page, and even graphs your productivity. It’s a pretty useful little tool that gives you a lot more info than most widgets and counters around. It’s also a great way to motivate yourself to stay on track and gather data about your work habits.
If you want to add, share or customize this, please feel free to! I only ask one favor. Please keep my url on the spreadsheet as credit so that I at least get some traffic for my work. Or just link to this page!
How to use the spreadsheet with Google Docs:
- Log into your Google Docs account. (If you have a Gmail or Google account, you already have a Google Docs account, you just need to activate it.)
- Go to the direct link to the calculator.
- Once there, select “Make a copy” from the File menu. (If you aren’t logged in, you won’t get this option which is why I had you log in first.)
- Select a file name and click OK. The calculator should now be ready for use in your own Google Docs account.
How to download for use in Excel, Calc or other desktop program:
- Go to the direct link to the calculator.
- Once there, select File > Download as… and then select the file type of your choice. I recommend Excel format for maximum compatibility.
- Because this was designed for Google Docs, you’ll lose the charts but everything else will work just fine!
Any questions? Let me know below and I’ll help you out as best as I can.
If you find this tool useful, thanks are appreciated in the comments as well. Thanks and happy Screnzy-ing!
(PS: I update this calculator every year so don’t let the date on this post or the comments fool you. 
)
Hillary DePiano is a playwright, fiction and non-fiction writer who loves writing of all kinds except for writing bios like this.
Blurr on how to use it..
very good!