Monday, March 10, 2014

Changes Are Happening at Operation Awesome

Do you want to be part of the Operation Awesome team? We're looking for a new member. Go here for more details and info on how to apply.

Also, we're revamping the Mystery Agent contest and we'd love to get your input. Go here to take a short survey. You can also find the survey in the sidebar of the Operation Awesome blog.

Have a great week! :)

Monday, January 6, 2014

Words Per Day 2014 Spreadsheets

The Words Per Day 2014 spreadsheets are finally finished! :)

I incorporated some of the features from the NaNo Tracker and added a few new features to make them easier to set up and use.

All the setup is done in one sheet. I created three versions so you can set one annual goal, monthly goals, or set a daily goal for each month. Whatever works best for you. :) All versions can be used on either an every day, Monday through Friday, or weekends only schedule. Just enter an X in the box next to the schedule you prefer and clear the other boxes.

Click images to enlarge.

Annual Goal:
Monthly Goal:

Daily Goal:

I've also included a WIP Calculator. The titles can be entered at the top for easy tracking, then enter your daily total word count and it will calculate words written for that day.

On the monthly entry pages, it will pull in/calculate your selected writing schedule, daily goal, weekly goal, and monthly goal. You'll only need to enter your daily words in the green column. It will also highlight the current day.

The Stats sheet shows your progress over the year.
And all sheets contain links for easy navigation within the workbook. :)

To download:

1.  Click one of the links below.

Annual Goal
Monthly Goal
Daily Goal

2.  After you click on a link, you will get something like this :


Click File and then click Download.

3.  Open the file.

Chrome: Click the button in the bottom left corner of your screen.


Internet Explorer: Click Open on the bar at the bottom of the window.


Firefox: Click OK in the window that pops up.



Once the file is open, you might need to enable editing. To do this, simply click the yellow Enable Editing button at the top of the spreadsheet. If you don't see this button, you don't need to do anything--you should be good to go.

4.  Don't forget to save your file when you're done. :) Also, Google Drive doesn't like 97-2003 format (xls). If you want the 97-2003 format (xls), leave me your email address in the comments or email me by clicking the button under "Email Me" on the left, and I'll send it directly to you. Just FYI, I don't have access to versions of Excel older than 2007, so I'm not sure how making the file 97-2003 compatible will affect the functionality.

The workbook and worksheet are protected to protect the structure and the formulas. Like the NaNo Tracker, I added a password to these ones because I put so much time into them. I'd like to keep my signature on them. I've been over them and tested them several times, but it's still possible I missed something. If you find any issues with them, please let me know and I'll make corrections.

If you want to share the files, please do. I just ask that you use the links below and that you give me credit, link back to my blog, and let me know in the comments or on Twitter @abbyannis. I'd love to check it out. :)

Annual Goal: http://bit.ly/1dnCTTv
Monthly Goal: http://bit.ly/1iGEDyA
Daily Goal: http://bit.ly/JVkB4c

Please note: If your computer is telling you it can only be downloaded as read-only, you probably need to save it to your computer, close it, and reopen it before it will let you make changes. If all else fails, leave me your email in the comments or click the email button on the left and I'll send it directly to you.

Mac Users: If you can't get it to download, please email me by clicking the button on the left or leave me your email in the comments. I'm happy to send it directly to you. If it's opening in read only, try the instructions found here: http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/office-files-locked-for-editing-in-mixed/d838b0d7-6b26-4206-b310-029c73cf0ba6. If that doesn't work, let me know what it's doing, what type of error messages you're getting, and I'll try to figure it out.

Any questions, please leave them below.

Happy writing! :)
Want a colorful spreadsheet to track your writing goals for 2014? Download one here from @abbyannis

Monday, October 28, 2013

NaNo Tracker Spreadsheet

2014 Words Per Day Spreadsheet

ETA: 11/1/13 And of course there's an error in the formula on day one. The error only affects day one and you won't even notice it unless you enter a starting word count, but I went ahead and fixed it. Future downloads should work the way they're supposed to. :)

NaNoWriMo starts on Friday! Are you ready?

In addition to all the outlining I've done, I've created a tracking spreadsheet, and I'd love to share it with all of you. I think it has some pretty cool features, but I did make it myself, so it's possible that's just me patting myself on the back. Go me! ;)

I set it up to be easily changed with just a few minor adjustments. 

Depending on your schedule, you can select to write daily, Monday through Friday, or only on the weekends, and it will calculate what you need to write on those days to stay on track. You can also adjust the total goal for the month and it will recalculate the amounts based on that. And if you're using a WIP for NaNo instead of starting at zero, you can enter your starting word count and it will factor that into the totals for the month so you can just enter your WIP total each day. 

Plus, it's date driven, so it will highlight the day you should be on and it will let you know your goal for that day. It will also show you if you're on track to meet your monthly goal. :)

Here are some examples to give you an idea of what it will look like as you enter your word count throughout the month. Click the pics to enlarge.

Before you start . . .

About 1/4 of the way through . . .

Halfway point . . .

3/4 of the way there . . .

And you're a winner! :)

So how do you get a copy for yourself? 

You can download it here: http://sdrv.ms/190sFtU 

After you click on the link, you will likely get something like this :


Just click OK and then click the appropriate button to open the file.

Internet Explorer:


Firefox:


Chrome automatically downloads the file and displays it in the bottom left corner of your screen. Just click the button and it will open.



Once the file is open, you may need to enable editing. To do this, simply click the yellow Enable Editing button at the top of the spreadsheet. If you don't see this button, you don't need to do anything--you should be good to go.

Don't forget to save your file when you're done. :) Also, Skydrive automatically converts the file to the newest format (xlsx) when uploaded. If you want the 97-2003 format (xls), leave me your email address in the comments or email me by clicking the button under "Email Me" on the left, and I'll send it directly to you. Just FYI, I don't have access to versions of Excel older than 2007, so I'm not sure how making the file 97-2003 compatible will affect the functionality.

The workbook and worksheet are protected to protect the structure and the formulas, but I added a password to this one because I put so much time into it. I'd like to keep my signature on it. I've been over it and tested it several times, but it's still possible I missed something. If you find any issues with it, please let me know and I'll make corrections.

If you want to share it, please do. I just ask that you use this link (http://sdrv.ms/190sFtU) and that you give me credit and link back to my blog.

ETA: If your computer is telling you it can only be downloaded as read-only, you probably need to save it to your computer, close it, and reopen it before it will let you make changes. If all else fails, leave me your email in the comments or click the email button on the left and I'll send it directly to you. Thanks so much for the Blitz, everyone! It's been a fabulous day! :)

Mac Users: Several Mac users have not been able to use the file, either because it won't download or because it's locked. If you can't get it to download, please email me by clicking the button on the left or leave me your email in the comments. I'm happy to send it directly to you. If it's opening in read only, try the instructions found here: http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/office-files-locked-for-editing-in-mixed/d838b0d7-6b26-4206-b310-029c73cf0ba6. If that doesn't work, let me know what it's doing, what type of error messages you're getting, and I'll try to figure it out.

Any questions, please leave them below.

So, who's participating this year? If you want to add me as a buddy, my profile is here. Or leave your username in the comments and I'll track you down.

Good luck, NaNo-ers! And Happy Monday!!! :)

Tuesday, October 22, 2013

Sip Swap!

This is such a fun idea! :)


Go to http://kelseymacke.com/sipswap for more details and to sign up.

Happy Tuesday, everyone! :)