Archive for the ‘skill’ Category

VBA third most hated language

Thursday, 2nd November, 2017

amongst Stack Overflow devs anyway…

On SO devs can mention tech they would rather avoid. Perl was top at being avoid worthy, then Delphi (is that even still alive??) followed closely by our own VBA.

This is developers so its not really a surprise they prefer to avoid VBA. They want to be playing with new shit not adding business value.

Interestingly SO reported that VBA is still an actively tagged language so still popular in use, just not by devs.

In fact, of those languages disliked by over 3% of mentions, VBA is the only one not shrinking in tag mentions, in fact its growing slightly.

Advertisements

VBA course hosting

Friday, 27th October, 2017

I think I might have mentioned that I am thinking of making an online video VBA course?

Well anyway, I haven’t exactly finished the content yet…

But I have been poking around for a ‘platform’.

I was initially thinking of Udemy, and I still might go that way initially, but I have heard a few not so positive things about them from an instructor POV. Although I am not sure if that is all old stuff or recent.

Cost wise I imagine the course being around 50 quid/dollars/francs.

I had a look at this place and they have that price as an example.

If the student pays 50 quid the instructor can get as little as 3.15!!!!!

That is the content creator, the author, gets just over 5% of the price the student pays!!

I just can’t quite believe it!

I think I might look into creating a ‘platform’ instead. Its only hosting with a few bells and whistles, most of which I won’t use.

Maybe I’ll have to do youtube with ads after all.

Some Blog stats

Saturday, 7th October, 2017

Here are the top 10 or so pages on this blog over the last 10 years. Not perfect as some of these have probably been here for 10 years, some might be merely months old.

But still the focus on 2007 errors makes me laugh. Maybe I didn’t post much about 2010 errors (2003, as we know didn’t have any (ha ha)).

In fairness 2010 was much better than 2007 in almost every way. Well, except dev tools maybe (the bit we looked at ironically).

Home page / Archives 171,829
Excel 2007 workbook window not visible 75,716
Excel 2007 Error: Link source not found 15,901
R1C1 notation 13,728
The spreadsheet disadvantage 12,988
Excel 2007 screen lock up 10,373
Code execution has been interrupted 10,280
Excel 2007 =#N/A error 9,550
xlls With ExcelDNA 7,530
Excel 2007 screen / video issues 6,290

Delighted to see ExcelDNA in there too, it is an excellent tool.

And lo, what’s that? a spreadsheet quality post in the mix? Methinks a far sighted undergrad course may have pointed the students towards some research into the disadvantages of using spreadsheets (for everything).

I never started SOS to get big viewer numbers, I wanted to have a conversation about more advanced Excel development related topics. Somewhere where XLM would not be auto ‘corrected’ to XML, somewhere we could discuss the merits of the C API v the COM interface, or the merits of manual calc v auto calc without drowning in ‘my Excel stopped adding up’ cries.

I have always resisted going for the bulk beginner audience here. But I am contemplating developing a beginner level VBA course at the moment, so may have to revisit that. Although I would probs set up yet another blog I think.

So anyway there you go, at least 75,000 people came here because they could not find their Excel 2007 workbook window.

Drum roll please…

Friday, 2nd June, 2017

To avoid polluting this place with loads of off topic nonsense and to try and preserve it as a mainly spreadsheet development resource I have created a new blog.

Its mainly about my new life as an Android developer, so if you are interested in that topic or just find my writing A-fookin-mazing, or you are that stalker that nicks my underpants off the washing line, be sure to follow me over there… on.. wait for it.. in a moment of blinding originality… MURF ON MOBILE. :-)

Excel Conference in Amsterdam

Tuesday, 5th January, 2016

I just saw this (on linkedin of all places – I only go there twice a year).

Dunno much about it, except its being run by a gang of well known Excel experts so should be very excellent.

I won’t be going as Excel is basically dead to me these days.

If you are going, have fun.

cheers

simon

 

 

Linux

Tuesday, 23rd September, 2014

I’m doing my first proper commercial Linux project at the moment.

Might need to resurrect my Eclipse and dust off my Java skillz.

cool…

Excel Modeling World Championships 2014

Wednesday, 27th August, 2014

I saw this last year and thought it was a great idea, and have just been prompted to mention it.

Here is all the info

Big wedge for the winner…

And the fame of course…

ciao, peeps

Video Somnolency

Tuesday, 28th January, 2014

As discussed previously I have concerns about the market viability of the old Excel/VBA/C# skill set, so I am developing other skills.

Part of this reskilling involves watching some very good videos.

Every time I put one on I get extreme head lolling syndrome.

I was watching one on the train last night and nearly missed my stop I was so flat out asleep.

I’m getting scared to put the videos on as they seem to just flick an off switch in my brain, and within 5 mins I’m snoring like a good-un.

As I mentioned they are good videos, so I really don’t think it is the fault of the producers.

I remember the same from years (decades!!) ago when I was learning Access 2.0, it seems I’m just not very good at learning from videos.

Maybe I should put them on my iplop and watch them whilst walking, although latest research suggests that using a smart device on the move is the cause of an increasing number of accidents. I have never fallen asleep whilst walking but I have dozed off whilst standing, so this could be risky.

I have some related books that are pretty heavy going too. Maybe I just need to start straightaway building something, even if it is very badly, and cobble it together as I go. But before I do that I was really wanting to get some perspective about what is possible. Maybe I just have to resign myself to building the same thing half a dozen times as I learn more and more…

Do you have the same video learning problems? (Maybe this is an important issue for all these MOOC’s)

What do you find is the best way to introduce new stuff for you?

cheers

simon

Competitive rate

Tuesday, 21st January, 2014

Why put this on the ad if it isn’t?

Do you really think you are going to trick us into accepting a crap paying job by telling us its competitive??

There has been a bit of a buzz the last couple of days about an apparently interesting job advertised. One of my buddies put me onto it so I applied. noting the ‘competitive rate’.

The agent was cagey when he phoned, wouldn’t say what the budget was, asked what I wanted etc – the usual shizzle. Eventually he fessed up – the client is a consultancy and known for paying low rates!

Why waste everyones time then?? dipshit.

Just put ‘crap paying job for desperate developer or substandard one’. You might drop lucky and find someone who can’t calculate day rate – accom – travel = 0 or less, but is still a great financial systems developer.

I notice it is now out with loads of agencies – a clear sign of desperation. The poor consultancy may have to give up some of their 200% margin to the actual worker. Unless they can find a local with the right experience and a low cost base.

These consultancies are weaselling in all over the market and charging a fortune for nothing (well maybe sue-ability). They take from both sides and provide nothing as far as I can tell. Unless you know different?

cheers

simon

 

GPH

Tuesday, 14th January, 2014

Googles per hour.

My new proposal for estimating developer toolset proficiency.

In Excel/VBA mine is pretty close to nack all these days, I spend more time on codematic trying to unforget stuff I once knew. C# is a bit higher as I always like to check if things have changed since the last time I opened VS.

In my more recent dabbling tools (Eclispe and xcode) I have a google window open all the time, and use it all the time too.

so

Excel/VBA 0.1 gph (roughly 1 a day)

C# 0.5 gph (1 every couple of hours)

xcode 10 gph (the rountrip time it take to find, copy a line and change the variables to the ones I am using). It might reach even higher if I start getting better search hits.

what about you?

cheers

simon