Linux goes mainstream

You don’t get much more mainstream than coverage on the beeb. Linked from the front page no less. Now if only Dell could do that so people could find and buy the systems… (not that anyone is buying Dell anymore right?)

I have noticed that most of this new breed of cheap sub notebooks from the Eee and OLPC onwards tend to come with Linux installed. And there seems to be hundreds of them now. Perhaps one day PC World will catch on and start stocking them, I believe one of the most likely places to get an Eee when they were (are?) scarce was Toys-r-Us.

Anyone else got one of these new cheapo things?

I’m very pleased with my Eee, looking forward to trying to justify getting the 900 which has a more usable screen size.

Chers

Simon

Excel consulting firms

Where are they?
Where are the multi person Excel, or other spreadsheet, consulting/development firms?
If this technology is as important and useful as we think it is, and its hardly new (mature I think is the correct terminology (one step before legacy)), then why aren’t there more/any 10/20/100/200 person specialist firms?
Sharepoint has them, why not us?
(Is it because that is a ‘professional’ tech and Excel isn’t?;-))
Its like Excel dev is locked in the artisan phase and never going to move towards a more ‘engineered’ approach.
I’m not overly worried from a quality POV as I think if you get the right artisan you will get quality far beyond some tick list based ‘way’.
Its credibility that worries me, I think a few formalised big consulting firm standards would give the whole market a bit more clout. Even if they did conflict massively.
So where are they, and why aren’t there more?
cheers
Simon

First thing

Whats the very first thing you look at/for when you open a workbook from someone else? (that you trust not to be malicious)

And whats the first thing you look at/for when looking at someone elses code?

For spreadsheets its neatness/layout of whatever opens
too neat = gold plating/time wasting
too scruffy = slack/ little care

(Of course the ‘correct’ level of neatness is the sort of stuff I produce ;-)). I’m thinking use of formatting, use of number formatting, use of space etc.

I’d like to pretend thats its some kind of rational measure (file properties maybe?), but really its just a judgement on the initial visual appeal.

For (VB/VBA) code it is Option Explicit - missing = cowboy everytime. If its a snippet/function then I look to see if parameters variables and return are typed (as in Dim … as …., rather than dim x, y, z)

What about you?
one only for each category.
And is it relative to your own work? or do you think its an absolute measure?
cheers
Simon

Incompatibility strategy

It occurred to me the other day that one of the major benefits of releasing a new version of a product that is not very compatible with previous version is the speed of uptake within migrating orgs.

What I’m thinking of is how rapid the implementation is likely to be. If a company decides to adopt Office 2007 say, its likely to be a fairly sharp switch over. More so than say the move from 2002 to 2003, those co-exist much more easily.

Also for independent consultants like some of us here, switching back and forth from 2007 to prior versions is more pain than previously. That might encourage us to encourage clients to migrate to 2007, Or it may mean we drop non 2007 clients so we can stick with one version. Or we may avoid 2007 of course and offer 2003, 2002, 2000 and maybe 97 and OOo instead.

It seems that if you release an incompatible version you force people to make a choice about which version (or vendor) they will work with, but those that do migrate are unlikely to go back, and likely to drag others with them.

I know there are plenty of resources to help the move to 2007, thats not my point. I’m thinking that as soon as an org gets some 2007, they will want to move completely, rather than support 2 vastly different versions. If your IT team was going to support 2007 and 2003, then I wonder how much extra work it would be to support OpenOffice as well?

Many of the folks who have got past the initial hurdles of 2007 have suggested they do not want to go back and use previous versions as its is too hard to work with such different designs. Thats an interesting observation as I don’t mind at all using anything from 97-2003 and OOo as the differences are quite easy to work around.

I think the strength of the (generally strong) views around 2007 (either for or against) are part of the same thing (over the hurdle in ribbon user experience nirvana or resenting its pointlessness).

I’m not sure how the VB6-.net thing ties in, or if it does?

I’m not softening to the jumbled up UI, but I am starting to see a hint of a possible strategic justification. (I’m not suggesting it will work)

Do you think this is just standard planned obsolescence?
Would you do it with your product?
cheers
Simon

Access User Group - May MS Reading

Just got a note about the upcoming UK Access User group meet May 15th.

Its at MS TVP and they have great line up of speakers, if you don’t recognise the names, give yourself a slap and google them. If you are not a database person then fair enough I guess.

All the info is here.

might see you there?

cheers

Simon

Get some street cred

Those nice people at BonaVista are offering the chance to win an iphone (also known as the Jesus phone (El reg only?)).

Obviously its aimed at getting us to try their Excel add-in based micro charting tool to design your whiz bang dashboard.

I was wondering about aiming for second place so I can drag Stephen Few to Carlisle which is completely nowhere ;-)

Most people I know have a blackberry, not sure we could step down to an iphone, but some folks get quite forceful in their defence (so I heard…).

If you enter let us know how you get on (I’m guessing if you come last you may not rush to tell us?)

cheers

Simon

I think they mean us

Guerilla IT

How to love your superusers!

The article is a bit more related to sys admin type stuff, and thinly veiled sales pitches, rather than deep and dirty Office dev. But I like the principle - instead of IS battling against the power users, support them and encourage them - same effort, much better outcome for everyone.

Of course, back in the real world there is the small matter of something called FEAR…

I have worked at the odd place that worked this way and supported and encouraged those users pushing the limits. But most places are some way off I reckon.

Anyone else worked somewhere where IS encouraged them, or are we all brow beaten into submission daily?

cheers

Simon

Excel accuracy

The Excel team have a great post explaining Excels accuracy here.

Do you think its adequate for normal spreadsheet use?

Do you think it should be improved in todays 64 bit computing world?

Would you be willing to take a performance hit for greater accuracy?

My answers - yes, no, no.

In fairness I have tripped over accuracy issues in spreadsheets I’ve worked with, so if it didn’t impact performance (I’m not bothered about file size), and didn’t break a bunch of old stuff, then a few more significant digits would be welcome. What about you?

cheers

Simon

Consistency

important or overrated?

I think I am gradually getting more consistent in more things as time goes on and I find ways of doing stuff that I think are the best in the circumstances.

But every project is different and in many I will do a similar operation in different ways. Sometimes because I am searching for a ‘best’ way. Often because I forgot I already solved this in a previous project (even with the nagging deja vu). Sometimes I know I solved it before but can’t find the right project.

I do have tons of library code that finds its way into nearly all my projects, for managing Excel, managing Essbase, menus, common constants, ADO, logging etc.

I am thinking things like working with certain types of list, managing application state etc. Stuff that is not totally general but is in 1 in 3 projects or something. And I mean consistent across projects, not within one.

When I work with other peoples work if I find the same thing solved is many different ways in the same project I would probably start to worry. But if I got 2 projects and one used the app.rows approach and the other used the used range intersection approach it wouldn’t bother me as being inconsistent, would it bother you?

I think some consistency is handy enough, but overall I think it could be a little overrated, especially if we are constantly learning.

What do you think?

how consistent do you think you are (beyond library code stuff)?

cheers

Simon

Decent UK ISP

I am planning on changing my broadband ISP anyone got any recommendations?

I’m currently on an 8 Mb (arf arf) pipe, _allegedly_ - I have never seen a download speed greater than 300k.

I was going to change to BT, but not after this phorm fiasco. Phorm have just fessed up to changing some wikipedia stuff about themselves - not the sort of org I want to deal with.

Any suggestions welcome, ones to avoid?

cheers

Simon