Saturday, September 08, 2007

Spreadsheets are the new blogs

You heard it here first.

Merging blogs and spreadsheets
I think we are going to start seeing people merge blogs and spreadsheets in interesting ways. A straightforward example would be for a weight loss program. Instead of just having an excel sheet with calories, the date, and weight this could be expanded by having a comments section that is really a description of the person's entire day.
If someone who was charismatic and could write well did this it could take off. People would be able to get into the persons ups and downs. Pictures of the person could be taken on different days and interested into the cell.

Another popular possibility could be the spreadsheet of an athlete training for the Olympics. People could see how her changing her training regime affected her sprint times.


Spreadsheets will be checked for daily progress
An important part of this is that these spreadsheets are not just presented at the end in progress. Seeing a spreadsheet of a training regiment that an athlete present after the Olympics was over would be interesting but dry. But for people to be able to check in each day and see how the timings are going gets exciting.

The personal spreadsheet
It will be startling how personal a spreadsheet can be. Even just a record of how you spend your leisure time can startle you. One part of creating a spreadsheet is that your idea of what will be in there changes as you create it. You may start with just 4 columns but as you begin to enter data, you think of other fields that may be related. This type of thinking is not available to conventional bloggers they are thinking more generally.

What needs to be done
The technology isn't here yet to make this easy. Or it is here and isn't properly integrated. The presentation also needs to be fixed. The product that ends up winning won't look like a spreadsheet.

It may take less work to make blogs more like spreadsheets. It will also reduce the intimidation factor. Here's a simple change that could be made to blogger. In the preferences a new section is created called "personal stats." There you can choose from a drop-down with some fixed values (e.g. weight, mile time, money spent) or have the ability to add a custom one.
Then in each new post web page. The name in the name value will appear (non-editable) next to a text box. The user will enter a number.

That is all the user has to do. Blogger will then create graphs based on the date of the post and the data.
This setup should be very easy to understand even for people with no spreadsheet experience.

No comments: