Tips to Jump-start Your June for Writing—Do You Know About The ‘Magic Spreadsheet’?
Posted June 9, 2014on:
June provides a great time for us to review the goals, commitments and visions we made at the beginning of the year. Do we even remember the commitments we made in January? Do our goals still take our breath away? Have we already accomplished some of them?
When you think about your writing goals are you feeling a sense of ‘Woo-hoo’ or ‘Uh-oh’? I hope you’re on the side of joy and excitement. If not, then it may be time to take stock of your writing strategies thus far and make some adjustments. There is still plenty of time to meet the writing goals that you set at the beginning of the year. This month, I’m going to suggest some tips that can support your writing.
Tip #1: Track your daily word count using the ‘Magic Spreadsheet’ (or your own system).
I discovered the Magic Spreadsheet from author Mur Lafferty. For many years Mur has hosted a terrific (and addictive) podcast for writers called I Should Be Writing. One of her MFA buddies, Tony Pisculli got inspired to design a support structure that would encourage one of the hardest practices of the writing life to maintain—daily writing. The story goes that he heard that author Cory Doctorow say that if you write about 250 words per day, in a year you’ll have a book. When it comes to writing, small increments of time and energy can yield tremendous results. And, Tony thought on most days, one can write at least 250 words.
So, he designed a system (a spreadsheet) where people can enter their daily 250 word count. He also added elements of ‘gamification’, meaning that it has fun elements–there are points awarded, levels to gain, etc. He circulated it to his MFA community and then over the last two years many other people discovered it and joined in. Currently, it is hosted on Google.
I think the Magic Spreadsheet is brilliant and is a great service to writers. This idea appeals to me on a variety of levels. I love group related activities that provide public support and accountability. I love the idea of friendly competition (it’s all on an honor system), and I love anything that kind of resembles a video game. Score, score, score!
The only thing that you do is enter your name, a few details and then move across the spreadsheet to enter your daily word count and with a click of a button, the program calculates all the other stuff. It’s like magic!
People are using the Magic Spreadsheet to make progress on their goals of finishing short stories, novels, plays, and even a few dissertations. You get more points for every day you write and every day you make the 250 word count (but you are of course free to enter in higher word counts).
A few days ago, on my birthday, I found a space on the spreadsheet and entered my name and word count. I wanted to start the spreadsheet on my birthday with the intention of writing every day from now until my birthday next year. I’m a pretty consistent writer, but have never tried to write 7 days a week, no matter what and with a minimum word count. It was a great way to kick off my birthday!
If you’re interested, you can listen to two podcasts here where Mur Lafferty interviews Tony about the Magic Spreadsheet’s origins and about the technology behind the scenes that makes it possible. You can also find all the info about the Magic Spreadsheet and how to join in here. There’s info at the link about the Facebook and Google+ groups. And, BTW, it’s all free! How is that for support?
Give the Magic Spreadsheet a try or set up your own system. Setting a specific and manageable word count (or page length) and sticking to it consistently is a fantastic way to build your writing muscle that is fun and sustainable.