September 2008

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Lightning Shots

Storm season is here again with 2 storms in 2 days so far and another one forecast for tonight apparently. I managed to get a couple of shots of lightning last night. I missed most of the good spikes!. Here is the best picture I got.

IMG_2756

More shots of the lightning storm yesterday up on flickr.

jethro's picture

Photo time at the park

I took a bunch of photos yesterday. We went to the park in the afternoon. These photos were all taken with the HTC Touch Diamond. After the first few photos I decided to play with the settings and see what could be done.

Here is Erin and a shot of the kite flying. Erin climbed the light pole to the top and Mercedes got on the base of it.

IMAGE_006IMAGE_011IMAGE_008 IMAGE_012IMAGE_014IMAGE_017

jethro's picture

Whats your favourite day of the week?

jethro's picture

Erin's Birthday

IMG_2719 Erin blowing out her candles on her birthday cake on her birthday the other day. My little girl is growing up fast. She is 7 now and a little livewire bundle. When you hold her she clings like a monkey, and you can feel every muscle and tendon is just wiry – she is bursting with energy and hardly ever sits still.

She loves to jump up to me to get a cuddle and she springs off the floor and into my arms and wraps her arms around my neck. Usually this is followed by her wriggling back down (all too soon) and she is off and running at the next thing. She has endless stamina, I think she will be a good long distance runner. Erin also loves to draw. She often comes in and borrows my whiteboard markers – making a little box on the whiteboard to draw pictures for daddy.

I love her!

jethro's picture

Conditional formatting in Excel 2007 - entire row colours

I had an interesting question about conditional formatting posed in the comments by Stephen.

In a new sheet, I am trying to make a whole row turn red, green or amber depending on the value of one cell in that row, so I can easily see which jobs we have won, lost or are pending. Any 'IF' conditional formula I write gets thrown out by Excel. What am I doing wrong?

I promised him an answer so here it is.

For this exercise I am making some assumptions.

  • You are using Excel 2007 format Excel spreadsheet (.xlsx or .xlsm). These instructions will not work in detail for Excel 2003, though the concept is similar.
  • That there are 3 conditions we  are looking for. Of course Excel 2007 allows more than 3 conditions so you can add more if you need. (One of the improvements on Excel 2003 that only allowed 3 rules)
  • That the entire row is needed to be coloured. If you need a smaller section than change the formulas accordingly.
  • That the entire worksheet needs this formatting. If you need a smaller section than change the formulas accordingly.
  • That the conditional formats are going to be based on a cell that returns a specific result based on some other rule.
jethro's picture

Ok so why was I in hospital?

Well it was stupid really. I have had enough experience with emergency departments now that I should have listened to my inner voice of reason and not bothered going.

Anyway – I didn’t. Late Saturday night my Uvula decided to get inflamed and swollen. I was a little worried when I tried sleeping that I couldn’t breath and was choking on it. After some will I? wont I? games I rang my doctor father in New Zealand (waking him at 4:45am his time) to ask his advice. He suggested going to the hospital. I don’t think my father has ever waited in a public hospital emergency waiting room. He is always on the other side of the wall. Anyway forgetting this fact I then ran the local hospital 24 hour nursing line. They advised the same thing. So now all I had to do was decided if I could drive without choking, passing out and crashing thus killing myself in the process. After some more will I? won’t I? I decided against calling an ambulance and drove myself the 20 minutes to the hospital. I parked and went in at 3am. After being seeing in about 10 minutes by a nurse who oohed and aahed and said “my yes it is swollen we will have to get a doctor to see you” I sat and waited. Fortunately I took my walkman and 2 books. I had finished the first book, and was starting on the second at 7AM. at 7:25 I was seen by a doctor who took all of 5 minutes to examine me and tell me to go home and take 2 over the counter anti inflammatory pain meds. Bah Humbug!

I went home took the meds and went to sleep.

I am recording here for evermore my intention never to go the hospital again unless an ambulance takes me! My advice for anybody is that if you can walk or drive chances are you don’t actually need to go to the hospital. Wait and it will be all ok. If not the ambulance will get you anyway.

And if I had done some Googling before I went I would have found this fantastic advice at http://swollenuvula.blogspot.com/ and these yummy pictures.

jethro's picture

Joel Spolsky launches StackOverflow

Joel Spolsky, one of the worlds leading authorities on software development, has launched a new questions and answer website called StackOverflow.

Here is his rationale behind the decision to do so.

stackoverflow-logo-250 You know what drives me crazy? Programmer Q&A websites. You know what I’m talking about. You type a very specific programming question into Google and you get back:

  • A bunch of links to discussion forums where very unknowledgeable people are struggling with the same problem and getting nowhere,
  • A link to a Q&A site that purports to have the answer, but when you get there, the answer is all encrypted, and you’re being asked to sign up for a paid subscription plan,
  • An old Usenet post with the exact right answer—for Windows 3.1—but it just doesn’t work anymore,
  • And something in Japanese.

If you’re very lucky, on the fourth page of the search results, if you have the patience, you find a seven-page discussion with hundreds of replies, of which 25% are spam advertisements posted by bots trying to get googlejuice for timeshares in St. Maarten, yet some of the replies are actually useful, and someone whose name is “Anon Y. Moose” has posted a decent answer, grammatically incorrect though it may be, and which contains a devastating security bug, but this little gem is buried amongst a lot of dreck.

jethro's picture

HTC Touch Diamond

Following the mishap of my Nokia N81 (broken screen) I needed to obtain a new phone. As I had another phone that was out of contract I was able to get the new HTC Touch Diamond. This is an awesome touch screen phone. The apple iPhone is basically a poor copy of the HTC touch phones only running substandard software including the Music crippling DRM iTunes software. In reality there is no comparison. The iPhone is an iPod with htc touch diamond a phone application attached. It does the internet badly (no java or flash support) has no Bluetooth (OK it has bluetooth but you cannot use it to transfer files or data – isn’t that he point of bluetooth?), cannot MMS pictures, has a very bad battery life and you have to install and run iTunes before you can even use the phone application. The HTC Touch Diamond by contrast is first and foremost a Smartphone. That is, it is a PDA phone  running the Windows Mobile 6.1 software. Not only does it have the full phone functionality that every mobile phone should have, it combines this with the PDA capability of Mobile Office, Word, Excel and PowerPoint, integration with Outlook and Exchange, SMS and MMS, photos and video (using a 3.2Mega Pixel camera) has a touch screen interface including some cool scrolling applications just like the iPhone has. Data connectivity includes Bluetooth, Wifi, multi-band Phone (3G, GSM and HSDPA). GPS can be integrated easily (using an external device which is good because it doesn’t then rely on cell coverage). Possibly the only poor comparison to the iPhone is the internal storage is fixed at 4GB. The battery life is also poor, but it can be replaced unlike the iPhone!

jethro's picture

Coming up on SpyJournal

I have lots of things in draft format to be posted on here. I will endeavour to get them all written in the near future. Some pressing client issues are to be dealt with first however.

So in the next few days look for posts on:

  • Why I was in hospital most of last night
  • Live Mesh - How to set it up and use it (being written by aManda)
  • Photosynth – what it is, how to use it and the ones I have created so far
  • Books I have read lately (mostly so i can stop tripping over the stack beside my desk that isn’t getting put away until I write this post)
  • And if I get time, the next VBA primer.

Ok back to work!

amanda's picture

Inaugural Geek Girl Dinner Report

 

ggd

On the 28th of August 2008, about two weeks ago, Tim and I attended the Girl Geek Dinner in Brisbane which was held at a Turkish restaurant.

The food was amazing!! It was worth going that night just for the food, seriously. But, besides the food, it was really interesting to spend that time with other women who are also involved in computer related work. Some people showed up already knowing other people there, others showed up not knowing anyone… it was geek_girl_dinner_foodinteresting to observe the different ways everyone interacted with one another. We’re all so different! I was pretty quiet, but I wasn’t afraid to make conversation with other people, I actually enjoyed talking to some of the other girls during the night. However different from me, some ladies were quite loud and outgoing. Some ladies moved around and talked to most of the girls who showed up, whereas others stayed in their own seat the whole night and just talked with the girls sitting near them. But either way, everyone seemed to really enjoy themselves and I’m certain everyone loved the food.