Turning my spreadsheet green

17 Jan

Well here we are two weeks in to the new year and I can report that I’ve been turning my spreadsheet green. I think I should explain – because life, work and family tend to take up rather a lot of time and head space when I do settle down to work I want it to be productive. I’m also a bit of a control freak and a pessimist so keeping a spreadsheet of my work really helps.

First I’ve created a worksheet for the year called Goals 2013, then I note down all the competitions, submissions and other writerly task generally needing done in a list, with deadlines filtered so they appear in order. I also put down the weblinks which saves loads of time when I go back to check on competition rules/guidelines etc.

Then I’ve got another sheet with all my short stories listed, with the magazines/comps that I’ve submitted to listed, with dates that they’ve been sent off and the date that I should expect to hear.

Then there’s the colourful part – I colour code everything. On my goals website I’ve got priorities colour coded, although they tend either to be HIGH in red, or just left blank. Then when I send something off I put in my Achievements column the date I’ve sent it off and highlight it green.

On my Submission worksheet I’ve got a more complex system with Blue for’ it’s nowhere/still needing work’; Yellow for ‘it’s out in the world’ and Green for’ Hooray it’s been accepted.’

So my plan for the year is to turn as much as I can Green. I know that all the goals won’t be met (as really they’re mainly a list of possibilities) but it’s great to get over the pessimism to see that I am achieving things and turning them Green.

Want to start your own list, here’s some suggestions of competitions and submissions that are open at the moment – let me know how you get on turning them green:







One Response to “Turning my spreadsheet green”

  1. ellenarnison27 January 18, 2013 at 9:25 am #

    Colette, this is inspiring. Also inconvenienced by life, work and family, I tend to find myself ramming writing into the tiny spaces left. This would give it a sense of purpose.
    And thanks too for the links to the competitions – I’ll put them at the top of my new Writing list.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Paula Williams Writer

a blog about writing, books and sometimes Dalmatians


Remixt: a magazine of multiple perspectives

Scottish Writers' Centre

Company No: SC349247 - Charity No: SC040823


Stumbling about gob-smacked by the world

Sarah Tinsley

The Power of Words

Sally Jenkins

A Writer on Writing, Reading and Life

MorgEn Bailey - Editor, Comp Columnist/Judge, Tutor & Writing Guru

A wealth of writing-related goodies from Morgen With An E (writer, editor, tutor, speaker and oh yes, blogger)

The Bath Novel Award

two international competitions for unpublished & independently published novelists


Helping authors get their books published

Zoë Strachan

News from www.zoestrachan.com

Bucket List Publications

Indulge- Travel, Adventure, & New Experiences

The Reading Room (Seòmar Leughaidh)

Promoting all things writerly on the Isle of Skye

Wee Scoops

Measure for Measure

The Daily Post

The Art and Craft of Blogging


She turns coffee into books so she can afford to buy more coffee. And more books.

Blog About Writing

Just another WordPress.com site


I make nice frocks and write average poetry. And there's a bit of embroidery and the occasional rant.

Help! I Need a Publisher!

Writing and the Creative Process

%d bloggers like this: