Showing posts with label magic spreadsheet. Show all posts
Showing posts with label magic spreadsheet. Show all posts

Monday, September 18, 2023

Counting the words, an Open Book blog hop post



Welcome to Open Book Blog Hop. You can find us every Monday talking about the writing life. I hope you'll check out all the posts: you'll find the links at the bottom of this post.

Do you keep track of your word count on a daily basis? What's your record for most and least words? (Not including those days when you don't write anything)  
______________________

I am a word count gal, but I change that up a little depending on my needs--trying not to get so hung up on meeting a particular word count that I ignore real progress that consisted of deleting words or revising them, for example. 

More important than the number of words is just the habit of writing every day, for my practice. I know some folks can write on a more variable schedule, but for me, it's every day. 

image source

After lots of floundering around with systems that didn't work for me, I started fresh with a gamification tool called The Magic Spreadsheet in 2013 (I think). 

It was literally a group-edited spreadsheet with complex formulas that awarded you points based on making your goal (the lowest goal you could set was 250 words a day), and number of days in a row written. There was a vibrant and supportive community surrounding the document and the Facebook group, and it really helped me build a daily writing habit. I'm still in touch with some writing friends I made through that group. 

I'm coming up on nine years of writing every day on September 28 this year, and that daily writing habit has been key to my ability to move forward with a writing life alongside a busy day job and family life. Developing discipline to finish things and see them out into the world was my biggest hurdle in early days, but now I can't imagine breaking that chain for anything less than a complete disaster. 

These days, I track using Jamie Raintree's Writing & Revision tracker. I love it because it lets me set goals in different categories, and track both revision and the writing of new words. In September, I have writing goals for the novel WIP, short stories, blogs, book reviews, social media, and business (by business I mean organizational stuff and emails and the like). 

As to today's question, I don't know offhand what my largest word count ever was, but I can tell you that it happened when was hurrying to prepare a submission when I got one of my first requests for "a full" from a potential publisher. I scrambled to clean up what was then a rather messy manuscript, cursing myself for having submitted without having the full completely ready. 

That day about broke my brain, and made it hard to do any writing work for several days afterward, so I now try to plan ahead better than that and not force myself into a corner where I have to scramble to meet a deadline. It wasn't fun, and I don't really want to do that again. A good writing day for me at this stage is 800 words on a day where I worked the day job and 2,000 words on a day that I didn't. 

My lowest word count was 250 words, because I never go to bed without having written at least that much. I'm just glad that writing 250 words isn't the strain it was back in 2013. Even on a bad day, I can do that in pretty short order now, another benefit of practice. 

How about you? Do you track your creative work in numbers? In time? Or not at all? I'd love to hear about it in the comments. 

You are invited to the Inlinkz link party!

Click here to enter

Tuesday, September 26, 2017

Celebrating Four Years of Writing Every Day

Tuesday, September 26, 2017, is a landmark in my writing life. It's day number 1,460 in a row in my writing chain. That's four years of writing every single day. (cue the fireworks and confetti, please)

I've written before about what a game-changer a daily writing habit has been for me: here, here, and here, most recently. It's not for everyone, of course. Creative process works in mysterious, highly individual ways, and every day is not feasible for every artist. But for me, it meant steady, forward progress, finishing things. Even more importantly, I stopped wasting time floundering around and trying to remember my own story.

I've written a heck of a lot in four years. According to Magic Spreadsheet, one of the tracking tools I use, I've written nearly two million words in that time frame. (When I'm editing and revising, I count 10% of the words I process in that session as word count). My school-day nightly goal is 800 words, my vacation-day goal is 2,000 words. A day still counts as a writing day so long as I make the rock-bottom minimum of 250 words.

(It's best when it's not just "All work and no play makes Jack a dull boy" over and over).

https://ih1.redbubble.net/image.349879360.8035/flat,800x800,070,f.jpg

I've seen three novels, a collection of short stories, and seven short stories in multi-author anthologies onto bookshelves during that span. I swear, I look at the pile of books and I feel like Ozymandias: "Look upon my works, ye mighty, and despair!" (though I hope that doesn't leave me crumpled in the desert with dried up pages blowing by in the wind).



I still want to be more productive.

I'm a twenty-first century girl after all, and I want to make sure I live my dreams to the fullest.

I have too many unfinished projects and too many still waiting for me to develop them.

As I move into my fifth year of daily writing, I plan to be a little harder on myself. Up until now, I've counted all writing: blog posts, articles, book reviews, marketing plans, synopses, journalling, etc. I still plan to keep track of all that work, but for a day to count as a writing day, it must include at least 250 words of fiction.

After four years of building this habit, I'm not willing to let myself slack off. My expectations for myself will continue to rise.

But right now, I'm just breathing a moment of satisfaction, sticking out my chin and spreading my prideful feathers. Look how far we've come!

…I think I'll celebrate by adding 250 words to my newest novel.

Wednesday, July 5, 2017

IWSG: Valuable Lessons

Writing has taught me a lot: about myself, about wordsmithing, about the business of publishing, and how to fireproof ordinary clothing . . . In fact, I think that's part of the joy of writing as a career choice. There's no drudgery, no same-old, same-old, not waffles again. Each writing project is it's own puzzle to solve, mountain to climb, or whatever metaphor you prefer. It's all learning.

IWSG is asking this month: What is one valuable lesson you've learned since you started writing? I'm going to take "started writing" to mean "started seriously writing" because I've always dabbled and played, but I've only been serious about it since about 2013.

The most valuable lesson I've learned during this time is that you have to understand yourself as an artist to get anywhere. There are thousands of paths to a writing life, and myriad advice about when and how to work your way through the writing and publishing process, but none of that matters in the end. You have to find and do what works for you as an individual. That's going to mean trial and error to find a process that gets results.

I learned that I can write anywhere--I don't have to have a particular environment or time of day--but that I have to write every day in order to make progress and stay on track.

For me, the commitments I make only to myself have been the easiest to let slide. I've fallen off so many wagons that I have permanent spoke marks and hay in my hair. It took me until I was in my forties to understand that a little selfishness is necessary to get there (whatever *there* you've picked in your life: weight loss, mastery of a new skill, etc.). I began insisting on writing time every day.

I was reasonable about it. I didn't ask for twenty-three of every twenty-four hours or anything crazy like that. I tried to choose my writing time during hours that would have lower impact on the needs and wants of the people in my life. It took a little time, but we all adjusted and now writing is just something I do every day.

As of the writing of this post, I have written for 1,373 days in a row (250 words is the minimum to count as "having written" by my reckoning, though I shoot for 800 on schooldays and 2,000 on non-schooldays now, after building up my endurance). I've written 1,672,415 words since I started tracking with Magic Spreadsheet (1,373 days ago). I've finished drafts of six novels, and seen three through to publication (the third one comes out July 11). I've also written several short stories and novellas as well, and written a weekly blog post, articles, and guest posts galore during this time.

But all of that is after making a commitment to myself and keeping it, and getting to that point took all the forty-years that led there. My new struggle, what I'm learning now, is how to set priorities to make the most efficient use of my writing time. I still work full time, and am now managing book promotion and publication business as well as writing new words. It's a whole new ballgame.

I'm looking forward to reading the other posts by IWSGers on this topic and would love to hear from you in the comments. What have you learned? What are you still struggling with?
___________________________________________________
If you're not already following #IWSG (Insecure Writer's Support Group), you should really check it out. The monthly blog hop is a panoply of insight into the writing life at all stages of hobby and career. Search the hashtag in your favorite social media venue and you'll find something interesting on the first Wednesday of every month.

Wednesday, December 28, 2016

Writing Life: My Highlight Reel, 2016

2016 was a rough year in a lot of ways. In the news, at work, in my personal life. The winds of change can be cold and harsh. Here at the end of it, I feel a little wind burnt.

So, I thought I'd take a minute to remember the good things, the blessings, the progress.

2016 was a good one for writing life.


Publications: My second novel (Change of Life) was published, a novella was published in an anthology (Indomitable Ten), two short stories came out in other anthologies (The Seven Story House and Theme-Thology: Mad Science).  Going Through the Change, my debut novel, won an award!

There's some good lead in to 2017 with the third novel and two anthologies already on the docket, with talk of another novella, too. Seeing a line of books that you actual have to scroll across on my Amazon page never fails to thrill me. I'm doing this for reals, y'all!


Appearances: I was accepted as a guest at a few Southern cons: Illogicon, Con-Gregate, and Atomacon; I'll be back at Illogicon in 2017, and will get to attend Mysticon and Ravencon as well. I don't know about my year beyond April yet, but I've got some applications in and hope to be busy during the summer cons, too. Attending cons is one of the things that makes this all very real. Plus, participating in panels is a great way to connect with other authors and just get to talk geeky bookish fun!

Productivity: Readers of this blog will already know that I am big fan of the Magic Spreadsheet for tracking my word count and motivating myself to keep on keeping on, even when I don't feel like writing. I've written about it a few times on this blog. It's a gamification system that rewards you with points and levels for having written consistently. The part that really works for me is the idea of the chain. My chain of days written in a row is 1,186 days long as I write this. Even when I'm sick or exhausted, that keeps me motivated. I *always* write at least the minimum of 250 words now, and, as a result, I see steady and consistent progress on my projects. I don't lose the thread and have to flounder for hours finding it. When I sit down to write, I fall back into my projects easily because it's only been a day since I was last there. Best. Thing. Ever. (for me, anyway)


This year, I began using Jamie Raintree's Writing and Revision Tracker. It doesn't award me points, but it does let me categorize my writing, set monthly goals, and track both writing and revision (on Magic Spreadsheet, I play math games to credit myself with revision time, counting in pomodoros or giving myself 10% of wordcount edited). It's been a really good tool for me, letting me make sure that, not only am I writing, but I am writing the right things, in order to finish in time for deadlines. Now that I have multiple irons in the fire all the time, staying on track means more than just writing. It means keeping focus and not getting distracted by side projects while the main one languishes.

Whether these tools or my own determination deserve credit, I don't know, but either way I'm proud of these numbers. As of December 26, I wrote 248,529 new words in 2016 and revised 584,267. Especially when you consider that I do this while holding down a demanding day job (middle school teaching) and keeping a household of five (hubby, two daughters, and a dog) going, I think I'm amaze-balls!


So, there you go: my year in words. And it was a good one! Lots to celebrate and lots to look forward to. It's a wonderful thing, doing what you love. May 2017 bring all of you the chance to do the same.




Thursday, April 23, 2015

T is for Time: A to Z Blogging Challenge


You hear a lot about how slowly the traditional publishing world moves. It's been described as glacial. It's a source of frustration, especially for eager new writers who are anxious to get their words into the hands of readers.

So I thought I'd share some details of the how much time went into the creation and release of Going Through the Change. For me, from conception of the idea to a book you can now buy (!) was almost exactly three years.

http://40.media.tumblr.com/tumblr_mbicfqDTiv1rfyxp4o1_500.jpg
In Spring 2012, I was struggling to finish the first novel I ever wrote (unpublished, His Other Mother, women's issues fiction). It's a dark story and it was emotionally hard on me to finish it.  So, part of my brain was trying to escape, and I came up with the general concept and some rough character descriptions for a superhero novel, escapism at its best. I filed them away and used them as a bribe to myself to make myself finish that first book.

In July 2012, I finished writing His Other Mother (that one took four years just for the writing of the first draft), and let myself start writing Going Through the Change. I finished the first draft in August 2013 (somewhere in there, I picked up my Magic Spreadsheet habit, which really increased my productivity). By the end of 2013, the book had been through my critique group and I had rewritten it. Keep in mind I also had a full time day job (middle school teaching) and a family during this time--there was only 1-2 hours per day I could get for direct focus on writing, often less.

I started querying it and submitting it in January 2014.  I won't make you suffer through the rejections and no-answer-answers with me.  The story ends happily with a book contract from +Curiosity Quills Press in August 2014. CQ had a really quick process. From my initial submission to my contract offer was only a space of about two weeks.

Since then, we've been working steadily on edits, cover art, marketing plans, etc. All the behind-the-scenes stuff that makes my book as beautiful and polished and perfect as it can be.  So, here we are on BOOK RELEASE DAY! It's been nearly three years to the day since I thought up the idea. In traditional publishing, I'd call that speedy-fast-quick!
_______________________________________________
This posting is part of the A to Z blogging challenge, in which bloggers undertake to post every day in April, excepting Sundays, which amounts to 26 postings, one for each letter of the alphabet--preferably along a theme. My postings will all be about my debut novel and my experiences writing it and seeing it published.

Blogging A to Z is a great opportunity to connect with some excellent bloggers and interesting people. I encourage you to check out other participating blogs, too!

____________________________________________
click the image to preorder on Amazon!



Wednesday, April 8, 2015

G is for Goals: A to Z blogging challenge


Goals are vital in writing, both for the writer and the characters. I've written on other occasions about the Magic Spreadsheet, a gamification tool I use to track my word count goals and keep myself moving forward and making progress on my project goals. I've been using it for around two years now and it has completely changed my mindset about writing. I no longer allow my writing to get shoved to the bottom of the to-do list (last on the list is a dangerous position--it's easy to fall off the list altogether).

Now that my first book is being published (15 more days!), setting specific writing goals has become that much more important. In the hour or two I can find each day for writing tasks, I have to decide how best to use them. Which project gets the priority today? I answer that question based on the "big picture" of balancing finishing things, creating new things, keeping up social media contacts, etc. Now more than ever, my life is a balancing act.

Turns out, setting goals works for fictional people, too. In any particular scene, if I got stuck in the writing, I just asked myself what the character's goals were. What does she want? What's in her way? How will she try and get around that obstacle?  What will she do if she fails? Nine times out of ten, that helped me find the conflict that would guide me through the next bend in the river of narrative.

The women in Going Through the Change want a lot of things, and sometimes their obstacles were each other, or even themselves.  Sometimes, I felt like a sadist torturing my poor characters, but the end result is a good story. I hope my readers agree!

___________________________________________________
This posting is part of the A to Z blogging challenge, in which bloggers undertake to post every day in April, excepting Sundays, which amounts to 26 postings, one for each letter of the alphabet--preferably along a theme. My postings will all be about my debut novel and my experiences writing it and seeing it published.

Blogging A to Z is a great opportunity to connect with some excellent bloggers and interesting people. I encourage you to check out other participating blogs, too!
____________________________________________
click the image to preorder on Amazon!

Monday, August 19, 2013

Level 6: TGFMS (Thank G-d for Magic Spreadsheet!)

So, I've written about the Magic Spreadsheet before.  It's a simple concept.  You commit to a minimum daily word count (level one is 250 words) and record your words in a spreadsheet where other writers do the same.

After taking four years to complete a first draft of a novel, I was becoming desperate to find a way to write more.  I have plenty of obstacles and challenges to that goal, starting with two children and a teaching career.  But I wasn't willing to let writing be that someday thing anymore.

So, in March, I found a mention of the Magic Spreadsheet somewhere in my Google+ feed.  I was curious and looked it up. They had a group on Facebook.  I joined.  I started tapping out my 250 words every day.  It was a revolution.

First, I noticed the difference in what I could do with a brief writing session. Since I was writing every day, I no longer needed thirty minutes or more to "get back up to speed" by reading what I had previously written and shuffling through notes.  I was already in the flow.  Between writing daily and taking a piece of advice from James Maxey to stop writing each session before the well runs dry (where you have a good starting place for the next day), I was flying.

It didn't take long to level up. Now I was shooting for 300 words a day, then 350, then 400, then 450. And now, ta-da!, 500 words a day.

Over summer, I could get my daily words pretty easily.  My days were mine to structure. I often wrote 2000 words a day.  I know that may change now that I have to add teaching back into my life-work balance sheet, but even if I can't keep up 500 words a day, I know I'm an addict now. I'll keep writing every day.

Because you know what? I finished the rewrite of my first novel.  Then, I finished the first draft of my second novel.  Now, I'm working on the rewrite of that second novel.  I have three new ideas for novels percolating that I'm making notes for.  I'm more productive in my writing than I have ever been in my life, even when I was twenty-two, mortgageless and childless. 

My ideas are making it to fruition.  One day a time, a few hundred words in a chunk. It adds up fast. And equals one girl who isn't going to write someday anymore. I'm writing now.