Tuesday, June 13, 2006

New Son!!

Guys!! I have a new son!!

Evan David Moorhouse was born at 3:05 am on 13th June 2006, weighing a very healthy 8lbs and 8oz.

He has my build, and a lovely little birthmark on his left calf.
He hardly cries, and sleeps so much... I'm sure that will change very soon!

Now all I need is sleep!

Thursday, June 08, 2006

New Job

Sorry I've been away for so long! I've been working hard on my new job, which seems to be flying by.
I'm now a data development analyst, building databases for 9 RCCs throughout the UK.
I have a slightly frustrating time at the moment, in that although I can speak "Techie" and "Lamans" I have to be able to understand how everything actually works. Not how to do it, or how its been set up, or what it stands for; how it works and what it is.
For example, "Calculate AHT by grabbing a sum of ActTalkTime for each StaffNo from dbo_tblAgCalls, and dividing it by CallsTaken, adding a date criteria of >Date()-2 where 2 is the number of days you want to go back". What?!
Ok, AHT is Average Handling Time, so we know that we're aiming for the average duration of each call a staff member handles (either makes or receives).
To work that out, we need the total amount of time they've spent on calls, and the number of calls they've taken.

The total amount of time is nice and easy, sum([dbo_tblAgCalls]![ActTalkTime]) adds up (sum) all of the talk times (ActTalkTime) from the agent calls table (dbo_tblAgCalls).
eg: call 1=2 mins, call 2=6 mins, call 3=22 mins. 2+6+22=30

The number of calls is also easy - Sum([dbo_tblAgCalls]![CallsTaken]), adds up all of the calls taken (CallsTaken) from the agent calls table (dbo_tblAgCalls).
eg day 1=1 call, day 2=2 calls 1+2=3 calls

We then divide the total talk time by the number of calls to get the average talk time per call - 30 mins / 3 calls = 10 mins per call.

You can also add a criteria (rule) into access, which limits the records it looks at. Under the date information you can ask it to look at dates greater than todays date, minus however many days. (> = greater than, date() = todays date, -2 = take away 2 days).

That's just one figure!! I'll learn it eventually!


Oh, and just in case you were wondering, yes Evan is still in Laura's tummy.