The Practice of Creativity

Posts Tagged ‘The Magic Spreadsheet

One of the things I deeply enjoy about my blog is conducting author interviews. I love finding out how writers create magic on the page and what sustains them when working on long projects. My blog allows me to reach out to new and established writers after I hear them give a reading, or learn about them online, and ask for an interview. Every time an author agrees to an interview, I feel excited and inspired. My goal is to ask thought-provoking questions that get at the heart of their ideas about craft. I look forward to checking my email and seeing how they play with and sculpt answers to my questions. Interviewing and helping to promote writers is a passion and gratitude generating activity for me.

At the end of each interview, I always ask an author: What’s your best writing tip that you’d like to share?

Below, I have collected the most intriguing answers from writers I interviewed in 2015.

Keep this list close at hand. The advice is inspiring and offers a great way to jump-start your new year of fresh writing. And, look forward to even more author interviews in 2016!

*To see the full interview, click on the author’s name.

 

Camille Armantrout, co-author, Two Brauds Abroad: A Departure from Life As We Know It

Camille (right)

Camille (right)

What’s your best writing tip that you’d like to share?

Pay attention to your writing patterns. If you discover, as I did, that your words flow in the morning, clear your am calendar to take advantage of that creative burst. Keep pen and paper handy at all times, in your pocket or purse, on your bedside table, and in the car.

 

Karoline Barrett, Bun for Your Lifefb home picture----

What’s your best writing tip that you’d like to share?  

Just one? That’s hard! I’d have to say, don’t get bogged down with self-doubt, just write!

 

 

Samantha Bryant, Going Through the Change: A Menopausal Superhero Novel

full-swing-computer-shoes2

What’s your best writing tip that you’d like to share?

The one thing that truly made a difference for me was committing to a daily writing habit. For me, I did that with Magic Spreadsheet, a gamification tool for writers created by Tony Pisculli, which awards points for meeting a daily minimum word count.

For many years, I struggled to write while meeting all the rest of my responsibilities as a teacher, wife, mother, dog-mom, sister, daughter, etc., etc., etc. I would get a few hours once a month or so, and spend half of them just trying to get back in the flow.

But, once I committed to writing at least 250 words every day, come hell or high-water, that problem disappeared. It’s not hard to find my way back into the story if I’ve only been away twenty-four hours. It made the time I had more productive. Over time, with practice, I became able to write more words in one hour than I used to write in a four or five hour session. I began to finish things. So there it is: write every day.

 

Laurie Cannady, Crave: Sojourn of a Hungry Soul

cannady03-210

What’s your best writing tip that you’d like to share?

Write a page every day, no matter what, and don’t be afraid to allow your narrative to reveal things to you. When I first began writing memoir, I thought I had to write everything, as accurately as I could remember, to some self-imposed end. It took years to realize that my narrative had its own end and its own way in which it wanted to be relayed. So, writing a page a day was a relief. I allowed the scenes to unfold as they pleased and once that writing was done, I was able to shape all that I had written into Crave.

 

Amy Ferris, Shades of Blue: Writers on Depression, Suicide and Feeling Blue

What’s your best writing tip that you’d like to share? 

amy_ferris

write as if no one – not one single soul – will ever read what you’ve written.

yeah, write that kinda balls-out scary heart-wrenching beautiful truthful.

 

Mur Lafferty, The Shambling Guide to New York City

Mur_lafferty-300x198

What’s your best writing tip that you’d like to share?

Never give up. That’s the fastest way to failure.

 

James Maxey, Bitterwood: The Complete Collection

What’s your best writing tip that you’d like to share?

600_JamesMaxey

Momentum matters. Going back to my last answer, the biggest trap beginning authors can fall into is to write only when you feel inspired. If you practiced piano only when you felt inspired, would you ever master the piano? If you only went out and ran when you felt inspired, would you ever build the endurance and mental stamina needed to run a marathon? A key thing to understand is that any time you sit down to write, you aren’t working only on the story or chapter in front of you. You’re working on your entire career. If you want to “make it” as a writer, odds are you will write millions of words over the course of decades, maybe tens of millions. To get there, you’ve got to put your butt in the chair and slog out the words on days when you’re tired, or a little sick, or worried about your family or your job. You’ve got to keep tapping the keyboard when you are certain you are writing the worst sentences ever recorded onto a hard drive, when you hate every last character in your novel and can think of not one original idea for where you’re taking the plot. Because, you know what? Writing is where the magic happens. You can sit around daydreaming all you want, but until you start typing, you don’t actually know what’s going to emerge. Again and again I’ve discovered that, as I’m slogging through something I don’t want to write, something will spark and the next thing I know I’m on fire. I start out telling myself I can quit for the night if I make to 500 words, and the next thing I know it’s 3 a.m. and I’ve got 5000 words that just sparkle.

 

Jennifer Steil, The Ambassador’s Wife

Jennifer Steil-1

What’s your best writing tip that you’d like to share?

Go away. Go far, far away. The best thing any writer could do for herself is to go out into the world and have adventures that will give her something to write about. Take risks. Go to difficult places and do impossible things. If you want a guaranteed fantastic story, give up a comfortable life and move to the most difficult country in the world. Stories will find you. In abundance. Of course, if you already have an uncomfortable and crazy life where you are, you’re all set!

 

Advertisements

I admit it—I’m crushing hard. Two months ago, I wrote about a free motivational tool called ‘The Magic Spreadsheet’ developed by Tony Pisculli. This is one of the most helpful writing ideas I’ve come across in a long time and I can’t speak highly enough of it.

Here is a link to my first post that goes into detail about the Magic Spreadsheet, its origins and how to find the links to join.

Since I’ve become such a fan, I thought I’d report back about why I think the ‘MS’ is so great and what it’s has been like to use it.

Recap: The ‘MS’ is a fun way to get past the twin challenges of motivation and momentum regarding writing. The commitment is to write 250 words every day (you can always do more) and to enter your word count into a public Google spreadsheet. The program keeps track of your daily word count (like magic). And, you get awarded points and levels along the way for consistency and higher word counts. The points and levels add a cool element of ‘gamification’ to the Magic Spreadsheet. And, if you write 250 words a day, in a year you’ll have a draft of a book.

magic-12

Motivation: It can be very hard to stay motivated to write, especially when working on long projects. Think about the chapter, report, or essay you are trying to finish right now. It’s hard to get up the motivation to tackle something so big. But, writing 250 words a day feels very easy to sustain. Most of us can muster up the motivation to write 1-2 paragraphs that will take about 15-20 minutes. If you do more, that’s great. But if you don’t, at least you’ve got your 250 words done for the day and you’ve moved some project along.

Momentum: Momentum is such an important component in a writer’s life. It makes the difference between finished projects and unfinished ones. How does one develop momentum? It’s much easier if you are consistent, which means writing frequently.

Walter Mosley in his essay, ‘For Authors, Fragile Ideas Need Loving Every Day’* makes this point with care: “Nothing we create is art at first. It’s simply a collection of notions that may never be understood. Returning every day thickens the atmosphere. Images appear. Connections are made. But even these clearer notions will fade if you stay away more than a day.”

The MS helps to strengthen your momentum.

When you get too far away from a project (days, weeks or even years), it’s harder and harder to muster the motivation to pick up where you left off. Once you fall out of a writing rhythm, it becomes harder and harder to recapture the momentum that you once had. I also find that steady momentum helps keep those pesky inner critics at bay. They see you doing the work and shut up (or at least pester you about other things).

More: I love the ritual that I have gotten into in using the MS.  When I’m done with my words, I go and log them in to the MS. This act now completes my writing ritual. I also enjoy looking at other people who are on my page (each page or tab has hundreds of people). Although I don’t know them, by occasionally scrolling down through their entries, it reinforces a feeling that we are all in this crazy writing business together. Everyone has challenges getting motivated and sustaining momentum. I feel less lonely looking at all the other people attempting their 250 words a day like me. And, I’ve even looked up some the writers to find out more about them.

Results

I decided to use the Magic Spreadsheet to track my creative work only. Some people are using it to track their dissertations, academic articles, etc., and the MS works well for that, too. I also knew I wanted to work on multiple projects. Many people use the spreadsheet just for new writing or moving forward on a first draft of a novel, memoir, etc.

My 7-days a week, 250+ words practice has generated:

-One essay submission

-One poem that I had in draft form for two years

-A new short prose poem. I wrote this the same day I revised the other poem.

-Three columns for the Chapel Hill News

-Revisions on 4 short stories

-A conclusion to a story that I was having trouble with for several months

-Several blog posts (including this one)

-Two 3 page synopses of possible novels that I’m auditioning for in preparation for NaNoWriMo

-6 character sketches for one of the above possible novels

-Drafting and outlining for my old unfinished novel

-30,000 words in 65 days

Some of these pieces might have written because of standing deadlines, but most would not have been written without the nudge of the Magic Spreadsheet. And, much of the work has felt effortless.

I’m a believer. I’m a convert. I’m in love with the MS. Try it. It just might change your writing life.

*You can find Mosely’s essay in Writers on Writing: Collected Essays from The New York Times (2001).

This month, I’m offering some tips that can support your writing practice mid-year.

Tip 2: Increase Your Submission Rate & Strive for 99 Rejections

Years ago, writer Marjorie Hudson, shifted my perspective on submitting one’s work and coping with rejection. She declared that as part of claiming the mantle of a writer, one should strive to gather at least 99 rejections. I sat in the workshop feeling pretty smug thinking that surely with all the years that I have been trying to get published I reached that number, no problem. Later, when I reviewed my submission file, I was shocked to realize that I wasn’t even half way close to 99 rejections! This revelation spurred me on submit my work, in a serious and organized way.

regret-550x368-300x200

I love Chris Offutt’s essay, ‘The Eleventh Draft’, where he discusses how he dealt with the fear of rejection:

“The notion of submitting anything to a magazine filled me with terror. A stranger would read my precious words, judge them deficient, and reject them, which meant I was worthless. A poet friend was so astonished by my inaction that he shamed me into sending stories out. My goal, however, was not publication, which was still too scary a thought. My goal was a hundred rejections a year.

I mailed my stories in multiple submissions and waited eagerly for their return, which they promptly did. Each rejection brought me that much closer to my goal—a cause for celebration, rather than depression. Eventually disaster struck. The Coe Review published my first story in spring 1990. The magazine was in the small industrial town of Cedar Rapids, Iowa, with a circulation that barely surpassed the city limits. The payment was one copy of the magazine, and the editor spelled my name wrong. Nevertheless, I felt valid in every way—I was no longer a hillbilly with a pencil full of dreams. I was a real live writer.”

The common suggestion is for writers to have at least five pieces submitted at any given time. Last year, I submitted pieces to a total of 21 different contests, anthologies, and literary journals, etc. Three pieces were accepted for publication and another story placed in a contest. And, I received my fair share of rejections. However, I also received a few lovely emails from editors who although declined the piece submitted, encouraged me to submit something else. The submission and rejection cycle is also one of building relationships with editors whose work you admire. Think of it as deepening your apprenticeship.

This year, I have submitted to 9 places and can claim an even higher rate of success with four pieces accepted for publication and an honorable mention in a contest. I’m hoping to beat last year’s submission record by the end June. The more work you have out, the easier rejection becomes. It’s also incredibly gratifying to take action in support of your writing life.

 
How is your submission rate going? Are you close to 99 rejections?

June is a great time to research new markets and submit to them.

BTW: Have you checked out my post on the ‘Magic Spreadsheet’ and how it can support your daily writing practice?

PS, If you’ve surpassed 99 rejections go and celebrate and also check out Mur Lafferty’s excellent podcast about going beyond 100 rejections and keeping the submission process fun and creative (Episode 317)

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!

magic-12

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.


Michele Tracy Berger

Michele Tracy Berger

Author, Academic, Creativity Expert I'm an award winning writer.

View Full Profile →

Follow me on Twitter

Follow Us

Follow Us

Follow Us

Follow The Practice of Creativity on WordPress.com
Advertisements
%d bloggers like this: