New Year, fresh intent

January 3rd, 2012 / No Comments » / by Owen

As with many people who claim to run a blog, I’ve been a bit lapse. This year, for at least a week, I will be keeping my blog up-to-date

Tags: ,

Evaluating Excel Array Formulas

October 25th, 2011 / No Comments » / by Owen

This is a quick one, it may even be a useful reminder for myself.

In April I put an Excel sheet together for my wife to track the costings of the additional requirements for special needs children in her school; she wanted to be able to put an ‘x’ in the cell and for each column that the child needed and have the total in the end of the row.

The formula was similar to this;

=(SUM(IF(LOWER(M30:BM30)=”x”,1,0)*($M$15:$BM$15)))

I just spent flipping ages pressing F2 to check the formula was still right then pressing enter and getting an error.

REMEMBER, array formula require Ctrl+Shift+Enter not Enter

Tags: , ,

Where's Wall-E

August 19th, 2011 / No Comments » / by Owen

This is great, must have taken a lot of time and effort!

Where’s Wall-E

Tags: ,

Scrum (not a process or methodology)

June 12th, 2011 / No Comments » / by Owen

This week I’ve been doing Scrum training with Ripple Rock. Over three days Colin Bird and Simon Reindl have almost converted me to Scrum as a framework for software products.

To be fair to them, the did acknowledge that the intent of Scrum is very clean when more often than not the projects are quite dirty. I do feel that there is a need for rose glasses to fully embrace and believe this is the panacea of development but it has very strong merits.
Read more…

Tags: , ,

Tardiness

June 7th, 2011 / 1 Comment » / by Owen

I’ve been a bit tardy recently, this has mostly been due to moving to a new job and the purchase of an iPad. I do however have several in progress posts on said fruit product waiting for completion and subsequent upload.

Tags:

How to check email works without using SMTP

April 15th, 2011 / No Comments » / by Owen

I found this little snippet today, so many times this would have been great to know….
Testing code that sends email has always been a pain. You had to set up a SMTP service just to test that your .NET application sends the e-mail correctly.
Read more…

Tags:

Self-hosted WCF and Impersonation

March 29th, 2011 / No Comments » / by Owen

Last week I spent a lot of time trying to work out how to get there user credentials from the client consumers of a service I have written into the Oracle DB when accessing the service.
Read more…

Tags: , ,

Updates about my OU

March 13th, 2011 / 1 Comment » / by Owen

I’ve decided not to quite as vocal about the progress of my modules, as I had previously intended. I will continue to update about significant points or truely horrendous/overwhelmingly good results for TMA/CMA’s but not the day to day submission.

The reason for this is quite simple, when I look at the list of recent posts I noticed they all follow the same theme and i’ve been lax in updating. I was never intending to dedicate the blog to OU and I don’t want it to go that way.

M256 – TMA01

February 15th, 2011 / No Comments » / by Owen

Last night I submitted my first section of the first TMA for M256.

I’ve enjoyed this one, some of the answers seemed to need to be a bit verbose and I hope I haven’t been overly explicit. It focuses on Object and Sequence Diagrams, I’ve never had any formal training in these so its been good to fill that gap.

MST121 – TMA01

February 11th, 2011 / No Comments » / by Owen

I’ve taken the feedback I was given for the first TMA, TMA10 and I’m happy with what I’ve submitted for my next effort.

I’m ahead of schedule at the moment, if I can continue like this then I’m comfortable I can cope with any unforseen delays later down the line.

Fingers crossed I can manage over 90% this time.

UPDATE: I’ve just been looking at my viewer statistics, someone came to this post using a Google query searching for TMA01 answers (query); sorry mate, that’s something you’re not getting here… this takes too much effort to just hand over my hard work

Tags: , ,