Archive for February, 2018

2018 UK Excel meet up/conference

Sunday, 25th February, 2018

Would anyone be interested in an Excel related conference in the UK this year?

Probably summer time, probably that London, probably one day (with pissups before and after hopefully). Cost – unclear, probably between 50 and 200 gbp depending on numbers and the type of event. (the room I hired in 2012 has gone up in price 1,000%!, for real – 10x more expensive now!!!)

It could be user focused or developer focused (state your preference)

It could be classic Excel, on stuff that works on every version for the past 15/20 years, or it could be on the new stuff in 2013 and 2016 (again state your preference)

No promises, but if there is enough interest a few of us might try to get something organised.

At this stage we are just trying to gauge interest (do we need a phone box or the Albert Hall?)

So if you might be interested please leave a comment. (no commitment (either way))

Venue suggestions welcome too.

ta muchly

 

Advertisements

Instagram

Friday, 9th February, 2018

On a more positive note (one of my teenage kids said I was acting like a stroppy teenager moaning about that recruitment process), one of my teenage kids (a different one) suggested I cross promote my Instagram here.

Bloody teenagers think they know everything!!

Anyway for 2018 I am aiming to post 1 pic per day to my instagram account. I am mainly doing black and white landscapes, if you are interested…

My account is here.

Here are a couple of my favourite images to give you an idea

Birds fly. Vevey. Infrared

A post shared by simon (@simurphyphoto) on

and

More infrared mountains

A post shared by simon (@simurphyphoto) on

Feel free to not bother

(There is no spreadsheet angle to this post at all)

cheers

VBA test exercise

Tuesday, 6th February, 2018

I have just been offered the opportunity to do a VBA test (“should take no more than 3 hours”!) for the chance to get an interview… for a 3 month contract!

I didn’t find out how many had been selected for the ‘opportunity’. I could have been 1 of 2 or 3, or 1 of 2-3,000. I would guess 10-20? that’s a lot of people wasting 3+ hours

I told them to do one obviously, but I couldn’t help taking a peek at the exercise and scoping it out (wasting a ton of time which I am annoyed at myself for doing, but there you go).

I could do a pretty half arsed job of it in 3 hours, but to do it properly and considering some of the ‘peripheral’ elements (date integrity, error handling etc) there is no way I could do it to what I would consider an acceptable standard in 3 hours. Add the fact that some of the specs were wrong (do I do as per spec or what I think is correct?) and it was at least a full days work.

Bearing in mind this is a test, that will be reviewed so needs to look the part not just functional.

Perhaps if I had ready to go VBA libraries and components I could cobble them together within the timescales. But who has loads of libraries they actually have the right to use? I have a lots of stuff from all the codematic and xlanalyst stuff, but the bulk of the code I have written belongs to clients. (and some of the more useful stuff appears to only be in C, C++ or C#)

The other red flag was advice to do it in a object oriented way. IN A NON OO LANGUAGE FFS!

This may be contentious, but Object Oriented in Excel VBA is utterly retarded. Fact!

(There may be some exceptions but if you are combining data and operations in VBA ‘objects’, what are you using the Excel grid for? Or are you duplicating all that data?)

So I have a few problems with this company’s recruitment process:

  1. Its unduly burdensome on the potential candidates
  2. The timescales are for an amateur standard hack
  3. pre-built components may not be owned by candidates
  4. OO approach smacks of boys playing at being men.
  5. Spec was vague and incorrect
  6. Required effort will put off many candidates
  7. Some of whom might be ideal but too busy to risk 3+ hours
  8. 3+ hours for a chance of an interview for a 3 month contract is a very poor risk return compared to the rest of the job market.
  9. 3+ hours feels more like they want hobbyists rather than professionals.
  10. lack of respect for candidates time doesn’t bode well for the future role

I mentioned it to one of my contractor mates: “for free? fuck that”.

precisely!