Wednesday, March 28, 2007

A second life for Second Life stats

In spite of the fact that Second Life won't run on my laptop, I've been watching the space - expecting that one day I'll stop rushing around this First Life just long enough to find a Second Life to rush around in ;) ...

I'm generally interested in how products grow up around other products ("parasitical products" does that sound negative?) and how ad budgets follow (with Adidas and Toyota making news as reported on the GigaOM blog)... so this space is not just ripe for that activity - it's fallen off the tree and begun to (no, not rot) take root.

Anyway - I found this statistical post about the growth of SecondLife on their blog which seemed like a great candidate for using Google Spreadsheets - especially given all the comments on on how people wanted the data in mutliple forms and wanted to view the data on machines without MS-Office. (http://blog.secondlife.com/2007/02/09/state-of-the-virtual-world-%e2%80%93-key-metrics-january-2007/#comment-176730) It would be great to see the Second Life crew follow the lead of Meta Linden in his (or her?) post which publishes the stats using a google spreadsheet - That spreadsheet link as is looks like:
http://spreadsheets.google.com/pub?key=pxbDc4B2FH95A_Mr7_a_gVw
- which allows anyone to see the data with a quick web link.... But, one of the lesser known features provides immediate access to alternative formats - You can just add &output=xls to the end of the published spreadsheet link to get that spreadsheet in .xls form... or &output=ods to get openOffice format!
The xls link looks like this:
http://spreadsheets.google.com/pub?key=pxbDc4B2FH95A_Mr7_a_gVw&output=xls
Whaddya say Linden clan?

Monday, March 26, 2007

An early-life use for spreadsheets

So, I help my son use a Google spreadsheet to create Word Search puzzles.. very cool for me - not just because we found this fun use case for spreadsheets, but because my 6 year old is involved. He's creating his own new ones now, with themes - it's great.
But it didn't take more than a few minutes after his first printed word search flew out of the printer that he became another demanding user with his own high priority feature requests...

He literally got teary-eyed when I informed him that the grid lines on the printed versions could not be turned off... oh my... raise the priority on that feature, quickly! My son is crying!! quickly!!! Give him the option to turn off the gridlines!!
Do you think Dan Bricklin hit this issue with visi-calc?

Update: in the cells which aren't part of the hidden words, I use a formula to automatically generate a random letter...
The simple form of it is: =CHAR(RANDbetween(65,90)
But, to force a regeneration of the random letters used, i change the formula to include dependency on another cell (which is multiplied by zero to have no impact on the actual result)... then, any change to that 'other cell' will force the formula to recalculate and give me a new random letter.
So, the updated formula looks like this: =CHAR(RANDbetween(65,90) + (code($C$100)*0))
(that reference to C100 is 'absolute' so you can copy it to other cells and still have all dependent on a single cell)

Then - any change to cell C100 forces all the random letters to change... This is handy when your first set of random letters by chance form an offensive 4-letter word or two... ;)

To get a copy of my original puzzle, use this link:
http://spreadsheets.google.com/ccc?key=pO3Ze62OAU2EWwuXIT85kag
and then use the "File" "copy spreadsheet..." command...

Sunday, March 25, 2007

Usability not always required

Products...products...products.... so many products... Thousands intersect our lives each day, but this past Friday I was introduced to about 2 dozen new web-based products and actually judged eight of 'em at the Under the Radar conference... So many times, while considering the potential success of these products I considered the usability factors - how easy are they to use? Are they so usable that they offset the pain of switching from existing competitive (and possibly un-usable) products?... So after a long day of pondering products, I board my red-eye flight from San Francisco to NY on a Friday night, with the goal, of course, being to avoid killing a weekend.
What an eye-opener (ironcially).
With the most important factor of an overnight flight being comfort enough to sleep, the overnight flight fails in every respect! This has got to be the worst product ever used by so many people on such a regular basis (second only to the hospital bed pan, of course)
Now, I'm in coach - so those of you in business class might actually have a 23% better experience, but still... overall failure in usability. Being in an exit row helped, but was largely offset by the fact that my new found friends in the exit row also seem to need the space... So, I try to sleep between two men in size XL whose faces are about 18 inches from mine (pleasant) and whose feet are now semi-exposed in the well worn socks, which, no doubt, have seen shorter and less sweaty days and whose head colds now seem to be blooming rather nicely with the onset of spring...

The plane was completely packed... they can't make enough of this product! It's so in-demand, that they could probably tell us to strip naked and sit on our luggage in a fully gutted freight plane and they would still over-sell the flights (not to mention turning me into an image-posting blogger ;)

So - First of all... Why are airlines going bankrupt so regularly? If they can continue to gain customers with a crap product, what's the issue with making money?

Second - what are the lessons for product managers and entrepreneurs looking for hints to find the best products to introduce to the market?
1 - Screw Usability? Just get a product to people who need it ;)
2 - Even if competition is high, a crappy product will sell if demand is higher?... there are seemingly plenty of overnight flights, but the combination of airports and times actually reduces real competition to a very beatable level. Each of these airport pairs actually becomes a sub-market, most of which has a rather low level of competition given the demand.

There's more of course - but i'm tired (did i mention that i got no sleep Friday night?) and this post is way too long...
All I can say is, to beat the competition in a product with this standard, as Richard Branson will tell you, all you have to do is give each passenger a private bed.

Please... doesn't anyone want to enter my SanFran-NY submarket with this improved product?

Don't mind me... I'm just jet-lagged from a sleepless flight back east ;)

Friday, March 23, 2007

another customer for the noise-cancellation headphones

Not an hour after my prior post, David Allen is talking at the Under The Radar conference - all about how we, as humns, can't get anything done - because we're distracted... in much funnier language and much deeper..
The notable bullet on his slide - which just begs for the Noise-Cancellation-Headphones I mentioned- said:
"Your ability to concentrate is directly proportional to your ability to eliminate distraction"

yup.

Reducing the noise

I was on my way to the Under the Radar Conference in Mountain View, CA earlier this week... and an interesting (to me) analogy struck me... Me and this guy next to me both took out our bulky noise-cancellation headphones at the same time... His, the nice Bose set in the fancy zippered hardcase... very cool. Mine, the cheap clone in a pleather bag. Bose or clone, these things really do improve the listening experience - reducing the high level of white noise in the airplane.

It immediately struck me that I need a derivative of these headphones at work! We all do...
The "noise" level is different - it's not sound.. it's every distraction that takes me off my 'must do' list... it's email, meetings, phone calls, simple requests, new ideas, old issues.... Noise all day... If I had a way to remove the noise all day - even for a few hours a day - I might just finish more things and see my to do list (and m inbox) actually shrink rather than grow.

"just block time on your calender"
"lock yourself in a room alone"
"ignore email for a few hours"
yes, yes, yes... i know... but the headphones idea is much more magical... I would even buy Bose version....

Saturday, March 17, 2007

New Rule: management by spreadsheet

Actually, this is an old rule. Managing everything using a spreadsheet is very 80's (I would have said 70's, but I don't think Visi-calc was being used for number-less and formula-less lists much). The simple list of tasks across a team of people was more challenging to manage than it should have been - not to mention the reporting of the status to a broader audience, before the acceptance of a simple spreadsheet... Even then - sharing? ugh... the email chain of attachments begins... anyway... I swear I didn't want this to be a podium... just a simple sample of a cool Project Status report I saw today... From the Zend development team (the PHP company). This spreadsheet they use shows the status of each framework component in their product - and since it seems to be a broad community of developers, the Google spreadsheet platform is a great fit for both the collaboration and the publishing of status to their whole user community... use this one as a guide if you're trying to organize a team of remote developers (or those sitting close enough to smell your coffee or hear your ear buds...

Wednesday, March 14, 2007

Another example (to bury the prior example quickly ;)

Another long tail example of how people are using spreadsheets on the web... planning their housework... One spreadsheet describes "how to have a clean house (and dinner on the table) in 2 hours a day" - and is linked to from Miss Practical's Blog Post.

Scary part is, this isn't actually a long-tail example.. I've seen it too often... there's a whole community of OCD sufferers who organize their chores this way... Miss Practical actually seems to just be trying to improve her productivity, but the people at "Fly Lady" seem to be the OCD crowd... and one of them suggests using this spreadsheet to organize the housecleaning parts of her life... (yikes).