Say you’ve got a table like this:

and you want a daily summary of the transactions, where the number of rows per day is not fixed. Tricky.

Using this forumula in cell C2:

=IF(A2=A3,”",SUMIF(A:A,A2,B:B))

 and copying it down the page will work. To break it down:

1. If A2=A3, then this is not the last entry for this date, so output an empty cell. (”")
2. If A2!=A3, then this IS the last entry for this date, so search column A (A:A) for rows where the value is equal to A2 (ie, 1-Jan) and sum the values in column B (B:B) to output the answer:

Not the food markets, I’m talking about the stock market. My “IRL” portfolio is within half a point of it’s break-even point, from 20% down a few weeks ago. I’ve also gone into the black on the Share Market Game, although still a long way behind Blacky. Looking at Blacky’s stocks QGC might be a good buy. I credit my success to the Qantas shares sucking less. TOL is now wins my worst performer prize with -24.62% and STO a close second at -22.92%. FLT win the best performer award, with a +22.64%, second place honours going to CBA with +14.95%.

This afternoon I’m taking a walk to pickup Rob Wilson’s new suit, courtesy of Majestic Tailors, Sukhumvit. Almost the weekend people, hang in there!

I recently “mooched” Tom Clancy’s Rainbow Six from Bookmooch, and last night, I finished it. It was pretty good, but long - 850 some pages, and the boring stuff sometimes got in the way. You know how you’re reading one subplot and it’s completely fascinating, and then the author moves to another, more boring, subplot and you’re tempted to skip ahead to the next chapter? That, a couple of times.

Yesterday I went for a walk to the Post Office and did the usual 20 minute wait. Man, it’s amazing how busy our local post office is … presumably it’s a time-of-day thing, since I never go before 2pm.

Dr Horrible’s singalong blog has now vanished, but if anyone’s interested, I can search around for it and see what I can find. You know, internet-ninja style.

“Dr. Horrible’s Sing-Along Blog” will be streamed, FREE on Drhorrible.com, in mid-July. Specifically:

ACT I went up Tuesday July 15th.
ACT II went up Thursday July 17th.
ACT III (presumably here) will go up Saturday July 19th. (around 5pm QLD time)

All acts will stay up until midnight Sunday July 20th (approximately 5pm Monday, 21 July QLD time). Then they will vanish into the night, like a phantom.

Be sure not to miss it.

Three things.

1. Skyrates
Last night and early this morning, I finished a long-time Skyrates goal: I traded my cargo-kitted and performance-kitted Nomad for a cargo-kitted and performance-kitted Lancaster.  That means this to that. Most of Skyrates is trade-based, so the most important statistic is CKPH - Cargo Kilograms per hour, a function of your maximum speed times your cargo space. Leyton’s Dauntless has a higher CKPH than I do, but his plane is now tricked out and can’t go any higher without selling stuff first. We’re using different methods, and it’s interesting to compare. My current Lancaster is the motoring equivalent of a station wagon, with a seperate V12 for each wheel and massive roof racks. Yes, I am an online bevan.

2. Rainy Season
Rainy season in Bangkok isn’t that bad, but there’s occasional inconvenience. A couple of times, we’ve had to wait out storms before we could walk home (sometimes even thinking of a taxi is madness, with traffic … you’re better off sitting in McDonalds taking a really long time to finish your coffee than getting frustrated sitting in a taxi and paying for that priviledge). Of course, sometimes (well once, since I’ve been here) get floods which aren’t pleasant, and in hindsight I’m *ashamed* that I let M&D take off their shoes to wade through it because they only had one pair. They should’ve bought new shoes, considering the risk of  leptospirosis, which is commonly acquired this way.  As I’ve since learnt, all it takes is a small nick, cut, or even a blister on the feet to allow the bacteria to enter the body.  It can be a potentially fatal disease if not treated properly as septic shock can set in and then you are pretty much buggered. M&D, you’re still alive right? Oh, also, after the rain has stopped you can occasionally be walking along, minding your own business when your foot gets sprayed with unpleasant warm water. It took a *long* time to work out this is because the water settles under the paving until you step on it, which forces it up and onto your shoe. The first few times I thought someone had sprayed me, I kid you not.

3. Ailments
I’ve been reasonably well, but have been suffering repeat mouth ulcers on my gums. Perhaps I need a softer toothbrush, either that, or it’s a case of the scurvy.

Dudes on and all, hello.

Yesterday I performed the most valiant and difficult tasks of all: a day spending no money. It was kinda fun actually I suppose, considering it just meant kicking around the apartment reading my book (Tom Clancy: Rainbox Six) and playing the interweb. I went for a walk at one stage, which did threaten my tight-fisted goals, but I resisted.

Saturday, was much more fun. We’d been shopping Friday night at Foodland and Tops, and the Tops delivery around midday was welcome. It included 10 cartons of water, so that covers the water requirements for the next few weeks at least. And you have to make up the 1000 baht requirement for free delivery somehow. One wierd thing though, the Tops guys usually leave it with security, but Saturday they came up from the lobby with the trolley and unpacked the trolley into the kitchen for us. I had to hurriedly send Mint (wearing only her underwear) into the bathroom to hide, but it was worth it.

Oh, we went to the movies on Saturday afternoon for an evening session of Hellboy 2. It was stupid, although I did like their representation of the elves as “darker” than the average fantasy flick:

 If anyone’s interested in helping me out, or learning a little about the wonderful world of software development, perhaps you’d consider installing the super-alpha version of a new program we’re working on?

You need to use windows of some kind, and USB drives.

Thanks!

My property allures the gentlemen to the pen,
which, upon comparison, they find yours lacking.

Whilst I agree your pen could be improved,
Alas, that is not a free service.

I’m pretty busy today, but I wanted to quickly wish Godfrey a happy birthday with an inappropriate, kinda gross comic:

We are pleased to advise that the Westpac 2008 interim dividend payment was paid on 2 July 2008 and your Shareholder Newsletter is now available online.

The Westpac 2008 interim dividend paid was $0.70 per share, fully franked.

Woo! The answer to “Who loves banks?” is me. I’m no Blacky, but perhaps my Wall Street genius levels start today.

I read a joke:  a Hollywood man was telephoned by the police. “Mr Jones? I’m sorry to have to tell you this, but your family has been brutally murdered in your house.”
“My god, that’s terrible. Any leads?”
“Actually we have already closed the case. It was your agent.”
“Whoa! My agent came to my house?”

So it’s a lame joke, but there you go. This is a lame blog entry. What’d you expect?