Subscribe to this blog

Subscribe to full feed RSS
What the? RSS?!

Subscribe Via Email

We respect your privacy.


Follow me on Twitter and Digg

Write More Effective With a Worksheet

By Mikkel Juhl On September 18, 2009 Under General

Every sunday afternoon I brainstorm. You should do so too, I have to come up with at least 4 ideas to blog posts, normally it is more than that.

When I have 4 subjects to write about I open Excel (you can use Google Documents if you want to), and I fill out these forms:

  1. Working Title
  2. Title
  3. Date for publishing
  4. The plot
  5. The tweet

1: I find a title that is describing the subject very well. So I can remember what to write about, the next week.

2. I leave this empty, unless I have an eye-catching title.

3. The date the article has to be published.excel_worksheet

4. The plot, what am I going to write about in two-three sentences.. Or more, it have to be very good written, and easy to understand.

5. The tweet I want to send out to my followers. Sometimes I decide to write every single blog post after I have made the Excel worksheet, and then I can schedule the tweet, with HootSuite.com.

This is pretty much how I keep my productivity high. I really mean this, seriously, this can really change your way to work. In a good way, you can speed up your work 10 times.

You don’t have to think about what to write about, you have a schedule, which is great. You really can manage time that way.

If you do it a sunday, you are well rested and you have the time for thinking about it. When you aren’t tired it will be easier for you to think about, what you should write about.

Let me know what you do to keep your productivity  and creativity high.


7 comments - add yours

Britt Malka

September 18, 2009 at 17:43

I use the off line editor Ecto, when I’m writing blog posts, and I either write right away, or do as you do – write a headline, notes to the blog post, and I set the timer to the publishing date and hour.

Ecto is nice, but I am still searching for something which is easier to use, when it comes to uploading pictures with the blog post. Haven’t found anything yet (for Mac).

Reply to this comment

Mikkel Juhl

September 18, 2009 at 18:42

Hmm, that is a great solution. I like to have an Excel sheet, it’s giving me a great view from my week..

And then I use my iPod for the weeks to do stuff. Using a application.

Thank you for your tweet and comment, I appreciate it!

Reply to this comment

Henrik Blunck - Denmark

September 20, 2009 at 18:55

I mostly do as Britt. I simply just write when inspired. Often I get extra articles done, and subsequently I am ahead of time quite often.
I did, however, create a spreadsheet when we went on vacation to keep an overview of the many blogs where content appeared on a regular basis while we were in France.

So there are quite a few ways to do this. Maybe even a blog article about extra methods. :-)

Reply to this comment

Mikkel Juhl

September 20, 2009 at 20:35

You are right, I just love doing this. It is simple, normally I don’t force myself writing blog posts.

If I didn’t use this method, I end up writing no blog posts. So this method is important for me. But there are many ways doing this.

Have a nice day! :)

Reply to this comment

Sarge

September 21, 2009 at 00:38

I set myself up an offline tiddlywiki (http://www.tiddlywiki.com/) to organise my blog posts. It’s a very simple wikipedia type tool and great for storing ideas/blog posts/research and whatever you feel like!

I have a couple of personal wiki’s I work on offline to capture data in different fields.

Not much of a fan of excel I’m afraid, it’s a numbers game! But I can see how it would be useful to organise by date etc.

Reply to this comment

Paul

December 15, 2009 at 01:57

This is a good idea. I’ve got a number of blogs and I try to think of subjects to write about on the hoof. An hour before I start to write. Setting some time apart and actually thinking about what to write about sounds like a good stratergy. I think I’ll give it a try.
.-= Paul´s last blog ..Ebay Research =-.

Reply to this comment

Other Responses to This Blog Post

  1. How to Give Your Readers What They Want | DaneBlogger

Can You Have More Sales, Too?
Helping over 75,000 businesses like yours raise profits and build customer relationships using AWeber's opt-in email marketing software for over 10 years.
Take a Free Test Drive today!