24.12.13

Reddy the Labrador Retriever

Here's my dog with Nye: the boy lives in the next village.

I have known Reddy for just a few hours so I am looking forward to getting to know him.

21.12.13

Intellectual Joke in German

I love listening to Bach's Christmas Oratorio at, erm, Christmas. I listen to a German version and it starts with what sounds like Joseph O Lopez. So I sing along to Joseph O Lopez. Eventually curiosity got the better of me and I checked the real text and Joseph O Lopez is really Jauchzet, frohlocket! Jauchzet, frohlocket! means shout for joy, rejoice! Jauchzet, frohlocket! auf, preiset die Tage, Rühmet, was heute der Höchste getan! Lasset das Zagen, verbannet die Klage, Stimmet voll Jauchzen und Fröhlichkeit an! Dienet dem Höchsten mit herrlichen Chören, Laßt uns den Namen des Herrschers verehren! Shout for joy, exult, rise up, glorify the day, praise what today the highest has done! Abandon hesitation, banish lamentation, begin to sing with rejoicing and exaltation! Serve the highest with glorious choirs, let us honour the name of our ruler! Thank you http://www.bach-cantatas.com/Texts/BWV248-1-Eng3.htm and I wonder what happened to Joseph O Lopez, then? DW

30.11.13

Goodness!

There are Christmas adverts on Thai TV. I think I might emigrate!!

DW

28.11.13

That Old Rake Joke

There was a joke that lasted for years on the telly, in films and even in cartoons. Some buffoon would stand on the prongs of a rake thus bringing the handle sharply in connection with his face. Guffaw! Uproar!

Let me tell you, it really hurts and I've got a lump on the side of my head to prove it.

It knocked me sideways and affected my hearing for a while too. Fortunately my hearing has returned to normal.

Who put the rake in my way? I did!! And I am embarrassed at how easy it was to banjos myself.

DW

27.11.13

I Don't like Dogs

There are now four dogs in and around this house and I've taken a dislike to them.

Number one, they are not working dogs so they do nothing.

Number two, when they could catch and eat the rats and mice that live around here, they don't. They didn't seem to notice the rats that chewed the wires in my car even though they slept next to the car.

Number three, they are cowards. Any other adult dog, literally any other adult dog, can wander into the garden and steal their food. As they do so, our dogs move aside and wait for them to finish.

Number four, I give the cat a bowl of milk when it wanders across but yesterday, one of the pups saw the cat drinking and just barged in and finished the lot before I realised what was going on. I banished the thing as I gave the cat some more milk but it was clear that this pup couldn't understand why it couldn't just drink the new milk too.

Number five, they are dirty creatures. We do not allow the dogs to come  into our house but we can see the trail of their dirt on the steps and the patio outside the house. Imagine if we let them bring in what they liked!

Number six, they rummage around in bins and leave trails of rubbish wherever they like.

Maa baa ... bad dog!

DW

25.11.13

Stewart and Meme: the pups

Here they are ... getting very big. In the last two weeks they have doubled in size again! Stewart in particular has a voracious appetite.

We did a spot of gardening today and after we had put the sand and soil in these old tyre pots, you can see what happened. I hope you can appreciate how big they pups are too. I have included a photo where they are next to my leg to give you a reference point.

DW

Does Anyone Understand?

I have been saying this for a long time ... I think people click ads on Google with no idea that they just clicked an ad that automatically sends money to Google.

By the same token, I have never seen an ad on Facebook but if I found that I had inadvertently sent money to Facebook I would be horrified.

Let anyone start a business but let them do it honestly.

Read this article to see why I said all of that:

Google showcase comes at a premium - http://www.ft.com/cms/8c1f2e90-5501-11e3-86bc-00144feabdc0.html

DW

24.11.13

Two Dogs and a Cat

The Dogs

We got back home early this evening and all is well with the family.

We were really keen to see the pups as I had been away for about two weeks. Last time I was away for 9 - 10 days and by the time I got back they had doubled in size. Well, they did it again: they doubled in size again and Stewart is big and heavy whereas Meme is just big.

We held them for a while to check them over and both of them jumped to the floor and both of them did the same flop landing as their front legs could not coordinate with the rest of their bodies.

The Cat!

Kitty, aka meow meow, paid a call too and made a lot of noise. This is odd behaviour for her as she normally never bothers us. We gave her some milk, two lots in fact. She stayed with us for quite a while and if we moved she made more noise. Then suddenly she launched herself at one of our pot plants and ended up on top of it, breaking off its growing point in the process. I think it was trying to catch an insect!! Anyway, we put her out after that. Let's see her mood tomorrow.

DW

23.11.13

Beta: how to find one!

Another course completed and another post for the blog just suggests itself naturally.

This week a delegate wanted to know how to find the weighted average cost of capital for his company: not just an academic view but a real WACC value. One of the aspects of WACC that is often a bit tricky is to find the value of Beta. It's easy to find Beta values for listed companies in the UK, Europe and the USA but this company is in Saudi Arabia and I could not find the Beta value on the Saudi stock exchange web site.

What I did was to go and find a sample of the changes in the index of the entire stick exchange and the changes in the price of the share. I found the information I needed at bloomberg.com and here is the table I prepared in the Excel file:

savola_1

 

All we need to do then is to create this formula: =SLOPE(C5:C12,B5:B12) ... in cell E16 and the estimate of Beta this gives is 0.8314 ... with a market Beta of 1, this tells us that Savola is rather a conservative company as far as the Saudi stock market is concerned.

If I have time over the next week I will try to expand this table to 70 prices and changes to give us a more reliable estimate of Savola's Beta.

Watch this space!

Duncan Williamson

21.11.13

Tea at The Ritz

We just had afternoon tea at The Ritz and it was very good. Highly recommended. We didn't take any cameras with us so a photo of their advertising card is the best I can offer!

The harp music was very subdued but i think that was right.

Four afternoon teas served while we were there.

DW

20.11.13

Butterfly Park and the Damp Walk Back

We took a taxi to the KL butterfly park this afternoon and then enjoyed walking around and taking photos of the little things. For some reason I didn't fully grasp, we ended up walking away from the park. Then our attempts at flagging down a taxi failed. Then it started raining. Then we walked all the way back to the hotel where a long hot shower awaited!

So here I am, post shower, feeling comfortable and ready for dinner somewhere!

Butterfly photos later!

DW

16.11.13

I Wonder Why!

We have just spent two hours in the Platinum shopping centre in Bangkok and in one part of the mall there is a clothes shop called Galashiels. I happen to know that Galashiels is a small town on the borders of England and Scotland and if only my Thai were much better I would have asked how they ended up with a shop with that name. Fascinating! For references, here is a link to that Scottish town, population just over 12,000: http://en.wikipedia.org/wiki/Galashiels Please note, this is not criticism of anyone or anything, just wondering aloud. DW

15.11.13

Moresby, Mali and Melbourne

I am in transit in Dubai and I have just been chatting to a Kiwi who works in a gold mine in Mali. I said, there’s a bit of strife over there at the moment isn’t there? In the North, yes, but not where he and his 149 expat colleagues are helping to mine gold and silver.

He started his expat life in Papua New Guinea but was baled out by the New Guinean army when the locals cut up rough over a pay claim and drove machinery and vehicles over cliff edges … you can imagine.

He is on his way to Melbourne now, a fourteen hour flight. His route is as follows:

  • Mali to Paris
  • Paris to Dubai
  • Dubai to Melbourne

Two and a half days to get home. He has just left to find a bed for the night as he has a 9 hour wait for his next flight!

Good luck as we shook hands in farewell!

DW

14.11.13

Password Possibly Poleaxing

This has happened before but I can't remember when.

For some reason many of the services I use online are refusing to recognise my passwords. I then go through the process of resetting the dratted things but I cannot guarantee that I won't have to reset it again very soon afterwards.

Frustrating waste of time.

DW

Pivot Table COUNT Default Problem CURED!

I had a delegate this week whose Pivot Tables would take any of his numerical data and by default count them rather than sum them. When he asked me why that happened I went through the normal explanation of data v numbers ... which is true. However, in his case there seemed to be no reason behind this phenomenon: his data was clean as he was using my files and no one else had the same problem. He was using a good quality company laptop too.

We both checked on the internet last night and gained nothing from the many discussions on this problem: most of which related to data v numbers I have to say.

This morning I suggested that we look at his Windows Regional etc settings. His default language etc was US English and that seemed to be in order; but I said, let's try this, change it to UK English and see what happens.

Ta daa! For some reason, this change did the trick and now this delegate's Pivot Tables sum his data rather than counting it.

Another success story fromExcelMaster!

Duncan Williamson

Weak in Riyadh

The title's a pun!

Just finished my working week in Riyadh and will be travelling back home in about four hours from now.

DW

12.11.13

Reverse Pivot Magic

UPDATE: 13th September 2019 I can imagine some of my visitors will still find this page of use if they are using a very old version of Excel. However, if you are using Excel 2016 or 2013 or even 2010, you should be able to use a much newer and more powerful technique for unpivoting data. Of course, I already have a page for that and here it is: Power Query Unpivoting

UPDATE: 16th January 2014: I have been using this technique since I last reported and I have found some limitations AND solutions to this reverse pivot technique. I will prepare a page and video to demonstrate what I have found.

2nd December 2013

Watch the video and then imagine that you have downloaded a five year set of financial statements for a company. Nothing wrong with the data or the database they came from but imagine you want to set up a pivot table from them. Probably not possible unless you are lucky enough to have a data provider who has designed their output with this in mind.

Let's cut a long story short: open this file amazon_case_reverse_pivot and try to apply the reverse pivot technique in my video to the data you will see there. Good luck and it will be worth any effort you put into it! PLEASE READ THE NOTES in this work book re copyright ...

I didn't invent this technique but I learned it a couple of weeks ago and used it in earnest just now ... watch the video!

I had a table that had months across the top, years down the left hand side and data in between. What I wanted was the data in a list in three columns:

year month value

transposing, rotating, copying and pasting can give you what you want but it will take a long time. My original table covered all twelve months and five years ...

Reversing a Pivot table is what it's called and this is how to do it:


  1. Press Alt + D then P to call up the pivot table wizard and select Create a "Multiple Consolidation Ranges PivotTable."

  2. Select "I will create my own page fields".

  3. Select your data range and choose 0 page fields

  4. When you see your pivot table, double click on the intersection of Row Grand and Column Grand, in the bottom right hand corner of your pivot table

  5. You will be presented with your new table in the form of a list ... that is, from pivot table style to list style ... it's magic!



The video [wpvideo tGsBeRej]

Duncan Williamson

AGGREGATE Function Templates

I know I learned this function a while ago but then I forgot about it. The aggregate function was newly created for Excel 2010 and it provides us with some interesting functionality: overcoming shortfalls in the performance of such functions as AVERAGE, MIN, MAX, LARGE, SMALL and a few more ... 19 of them altogether. The trouble is, good as it is, it is not that simple to apply. What I have done then is  to create templates that will help you to use the aggregate function in one or both of the formats in which it might be used.

From the Excel Help File:

Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.

Syntax

Reference form

AGGREGATE(function_num, options, ref1, [ref2], …)

Array form

AGGREGATE(function_num, options, array, [k])

The AGGREGATE function syntax has the following arguments (argument:

Function Number

Required. A number from 1 to 19 that specifies which function to use

Options

Required. A numerical value that determines which values to ignore in the evaluation range for the function

Ref 1

Required. The first numeric argument for functions that take multiple numeric arguments for which you want the aggregate value

Ref 2

Optional. Numeric arguments 2 to 253 for which you want the aggregate value

For functions that take an array, ref1 is an array, an array formula, or a reference to a range of cells for which you want the aggregate value. Ref2 is a second argument that is required for certain functions. The following functions require a ref2 argument:

  • LARGE(array,k)

  • SMALL(array,k)

  • PERCENTILE.INC(array,k)

  • QUARTILE.INC(array,quart)

  • PERCENTILE.EXC(array,k)

  • QUARTILE.EXC(array,quart)


The AGGREGATE function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using option 1, such as AGGREGATE(1, 1, ref1), hiding a column does not affect the aggregate sum value. But, hiding a row in vertical range does affect the aggregate.

My templates will tell you if you are trying to use the wrong format of aggregate and has then been set up to ensure you don't make any other mistakes when using it. This includes providing combobox guidance for choosing which functions and options you need to use.

The Excel file is available here: aggregate_function ... just click!

All feedback is warmly received as are suggestions for improvement.

Duncan Williamson

11.11.13

Wildcards are Great ... Until THIS Happens!

Wildcards

As I am working away this week, I can be found looking at, opening up, working on a spreadsheet or two. Last night I came across yet another excuse to build an Excel data set. I found the TopTrack 250 and just had to have it: all seven years' worth of day for the top 250 companies according to the Top Track definition. Look here for the 2013 data set.

So I duly copied and pasted the data for 2013 into a spreadsheet and edited it. Having seen that I liked what I had done I then copied over the other six years' worth of data from Top Track. Because the data copied over in a very standard and predictable way, I was able to select all six sheets of the additional data and work on them all concurrently: moving data from one row to another, setting up columns in a better way, lining up the data to make it consistent with what I had already done with the 2013 set. Easy and not too time consuming.

But now the wildcards. On the web site that the data came from they had symbols such as asterisks that pointed to a note that said ... average, estimate ... or something like that. I needed to get rid of them all! As it was late and I wasn't looking carefully, I carried out an edit and replace of * and having pressed Replace All, found that ALL of my data disappeared ... it was doing what a wildcard must do ... in this case, any character was being replaced by nothing! A very hasty Ctrl+Z put everything back to the way it was but I still had to get rid of these symbols.

What to do? Delete every symbol manually? No, there were too many of them. Given that the symbol was in the same place in the cell it was in, at the beginning, I ended up with a formula solution that I entered in a new blank column that I would eventually use to replace the current data:

=IF(LEFT(D6,1)="*",RIGHT(D6,LEN(D6)-1),D6)

Why D6? That's where the first of my data points is in each of the tables I set up. I then copied the formula across to the next cell on the right and then down to the bottom of the table ... it worked a treat.

I remembered that I should have added that there were other symbols in the data in addition to the * and I amended my formula to cope with the ‡ symbol:

=IF(OR(LEFT(D6,1)="*",LEFT(D6,1)="‡"),RIGHT(D6,LEN(D6)-1),D6)

Now I had to copy and paste my edited values as text rather than leaving them in formula format, otherwise I have to leave the original data in the file AND have the edited version. So I just copied and pasted the edited values over the original data and my data were now clean and tidy ... but read on!

Numbers as Text

One problem remained: having replaced these symbols, the result was numbers as text rather than number as number. In this case I did this:

  • enter 1 in any available cell

  • copy that cell

  • select the entire range of numbers ... all of them so you miss nothing and don't waste your time selecting just the affected ones if your data set is large like mine

  • paste special, multiply

  • ta daa! your numbers as text have now become numbers as numbers

  • Delete that cell with 1 in it


There you are wildcards and paste special to set up a nice, clean table of data copied from the web.

Duncan Williamson

9.11.13

Oor Wullie

Willie Robertson, Oor Wullie for four hours.

Willie made himself known to me at Bangkok International Airport as we were just two of three people in the Emirates lounge. He said, Its just you and me now. I looked up from my spreadsheet and suggested we start a riot then. He felt a riot was not the answer.

After confirming that it would be fine for us to chat for a while, we got to talking about life, the universe and everything. We are of very similar ages and I gathered from very similar backgrounds: his Dundee upbringing v my West Yorkshire upbringing. The common bond, of course, was my Scottish mother.

I don't normally chat to fellow travellers because they invariably think I want to hear about their aeroplane and airport stories. Thanks, everyone; but you can keep them to yourself.

We spent about four hours together, chewing the cud, putting the world to rights, making pots of green tea and eating desserts. Willie had a couple of glasses of white wine.

He started by telling me that he does competency training in the Oil & Gas industry. I said, I've got a spreadsheet for that!! I have too!

Willie mentioned the book he wrote: On the Milk ... available on Amazon. I checked as we chatted. If I can find a way of getting the book to me I will buy it. It's Willie's story of adolescence in Dundee, involving a milk cart. I asked if he meant horse and cart and as he started to object by saying he was not so old, I said we had a horse and cart milkman well into the 1960s!

He came to reveal his authorship as I vented bile against backpacking gap year people with their dreadful clothes, bad manners and bad habits. I also said white people with dreadlocks looked stupid. He replied by pointing at his own barnet suggesting his dreadlocks weren't too bad. I said there's a difference between your slightly long hair and dreadlocks. Then he said he had grown his hair long in an attempt to look more like an author. Well, that's one way of telling me about his book.

Speaking of colour, later in the evening he told me that Baa Baa Black Sheep has become Baa Baa Rainbow Sheep. I said, you're joking ... Well, I will be baa baa black sheeping all over twitter for a while now. Who are these morons who think they've done something clever. Here's the truth: black sheep really exist, rainbow sheep don't. When I was growing up and raising my own children, baa baa black sheep NEVER conjured up images of racial turmoil. These people are sick.

I told Willie the story of the £80,000 Urinal v Non Urinal sign changes on the toilets in Manchester University. How these things ever get beyond zero is the most mysterious thing.

Then again, what about MARY and her little lamb with its fleece as WHITE as snow? I need a lie down now that I have thought of that. Somebody DO something.

After watching me make my pot of tea he asked if I ever had a drink so I said no and explained why: waking up too early with a thick head had lost its appeal!! Fair enough he said, as he took another swig of his WHITE wine. I then explained how some people try to force me into having a drink ... you can't celebrate with lemonade ... ok, if really want to buy me a beer, feel free ... but I won't drink it. That led to an evening of teasing over the champagne I was missing out on.

I started talking about Andrew Mitchell and William Hague. How they became an MP and then treat it as a vehicle for doing many other things rather than concentrating on representing their constituents. Willie said that whilst he didn't like this Mitchell chap, he had been treated shabbily. I said fair enough but it was clear that he had taken his bike to the wrong gate and had argued with the policemen about it. Normal people wouldn't have argued. Moreover, why did he resign so quickly? Still, he should worry.

At various stages Willie said he would change his shirt before boarding his plane. He never got round to it until a minute before i left for my flight. As I was packing up, he returned, sporting a more normal shirt than his tee shirt. Standards!

For some reason I mentioned the Newsnight programme I watched while I was in London two weeks ago. The one in which Jeremy Paxman was sent to interview Russell Brand. What we got was a rant: why are there poor people, we need to do something about poverty, there is illness in the world and that's wrong ... that's what I heard. I thought, who thought that getting someone with the views of a sixteen year old on Newsnight would be informative and useful in any way? I thought at one stage Brand was going to come out with that Monty Python classic: narcosyndicalist but he didn't. Then I imagined Brand going back to his multi million pound home and lifestyle and stopped worrying about that irksome man.

As we meandered through our views on life, Willie mentioned his time in Romania and how he ended up buying two friendly policemen there a tot of whisky each a two in the morning. Which sparked my own memory of the beautiful (untouched) girls of Bucharest and of the Ceaucescu monstrous building that I walked the circumference of but which I never considered stepping inside of. Along the same lines, when someone suggested in Georgia that we take a detour to go to Gori and sit on the bed that Stalin was born in, I said, drive on!

I was was impressed by the revelation that Willie has £2,000 in £2 coins in a sock under the bed.

A propos nothing I told Willie that I met a British couple one weekend at a resort on Lake Malawi. We chatted about this and that then one of them said, you know, we drove to Zomba and back the other day and we didn't see one WHITE face. Rather odd that, don't you think?!!! How do we let these people out?

So called reality TV got a mauling from Willie. Who are these 19 year olds, Willie wanted to know, who end up on our television screens whilst caterwauling that all they want to do is sing and if they don't win this competition, life is over for them. How about getting a life and working their way around the clubs and theatres like normal people? Of course, most of them warble rather than sing anyway! I added that Willie must never forget that erstwhile cooks on TV cookery competitions all tell us how PASSIONATE they are about food. Then just about all of them start murdering their ingredients and recipes. I really wouldn't want to eat what most of them throw together, would you?

Let me finish with this. Willie talked about his efforts to find someone in the Dundee government machinery who could help and advise him with his work ... like me, he works abroad so he exports his services. He got nowhere, no names of commercial attaches anywhere. I pointed out that William Hague has reformed passport renewal for the UK. If you find yourself abroad with the need to renew your passport, you will find that it will take six WEEKS. That's the death of my business for six weeks then. Stupid, stupid man, Mr Hague.

Well, there you are: the perturbations of two grumpy old men in an airport lounge in Bangkok. Entertaining!

Thank you Oor Willie, I would not have done any of that without you!!

DW

8.11.13

Travelling

Leaving home today for this trip:

Bangkok
Riyadh via Dubai
Bangkok
Kuala Lumpur
Bangkok
Home

There you are!

DW

7.11.13

Here it is but you can't have it

Of late I hace come across this Windows shocker.

Open Windows Explorer and search for something. On average, if it's on your hdd, Windows will find it. However, I have had occasions when I have known something was there but I had to refine the search to get at it.

Sometimes,  twice yesterday, this happens ... enter your search term and wait. Windows shows you one or more files so you click one to open it and it says, I kid you not, Windows cannot find that file ... Explain that!

Another Windows Explorer niggle comes when I want to refine my search ab initio by, eg, saying, only find xlsx or pptx files ... usually such a choice is not available to me. Then sometimes it is ... not very often, though.

DW

6.11.13

Tabs? Where are my tabs? I want my taaaaaaabs

Eeessh! Calm down!

So, you know your work book compriees at least two work sheets but you cannot see any tabs at the bottom of your Excel work book.

Click on maximise in the top right hand corner, just in case. If you still cannot see them, try this

Click the office button at the top left, it's either a Windows circle or a rectangle saying File
Click options
Click advanced
Scroll to Display options ...
Select Show sheet tabs if it is not selected
That should solve this problem.

This happened to me yesterday with an old file and since I NEVER deselect show tabs, I just wonder how these things happen!

Duncan Williamson

4.11.13

Rejected ... they didn't like my cake ; (

I signed up to an online photo storage/selling site and so far I have uploaded a few photos and they have been accepted. I had one rejected last week because it contained the name of an hotel, fair enough.

Now, make your own mind up: why do you think this photo was rejected today? I have no idea!

Well, I'd show you the photo if I could but Blogger won't let me upload it for some reason. I'll find a work around soon!

DW

2.11.13

New App

I have finally managed to install the Blogger App on my Galaxy Tab. Editing seems to be a problem with it. Once I press finished, published or not, I think I can't edit a post.

So forgive all errors and omissions.

DW

The Master Bedroom

We have bought and had fitted the curtains for our bedroom now. The bedding doesn't quite match, however! There's time for that :)

1.11.13

Puppies ar Six Weeks

Well, one of the two puppies. Stewart (!) Followed me to the lake on the motorbike just as I had stopped to admire some Buffalo taking a dip.

Stewart was fascinated and showed no fear if the water or the steeply sloping bank. He was half submerged at one point!

Here he is, then, six weeks old ...

Misbehaving in a cell? UPDATE

I wonder if this is a feature, a bug or a coincidence within 24 hours of uploading this post it happened again ... see below8w.

Last week I was working on a file in Excel and one aspect the work was to use the COUNTIFS () function. I know this function and have used and demonstrated it many times. Would it work? Yes it did and then it point blank refused.

Yesterday a friend asked me about setting up hyperlinks in an Excel file and then saving that file as a Web Page before uploading it on to an intranet. I set to work and created two basic hyperlinks, saved as Web Page ... one link worked and one didn't. I corrected the error, saved the file again. Did the correction work? Not at all. I went back and checked my work but still it didn't work.

Is there a theme here? Yes!

In both cases, when I deleted the error completely and started again from scratch I got rid of the errors, no amount of editing in these cases looked as if it would work.

UPDATE

This morning I was working through some lookup examples that included a complex formula that included INDEX, ROW and should have been array entered. I copied and pasted an example formula that I knew would not work. Then I edited the formula but just could not make it work. So I started again I a new cell and bingo, it worked.

If something you KNOW is correct is not working: delete, start again.

Let me know if this worked for you too.

Duncan Williamson

29.10.13

We're in

The builder's finished and we have moved in. We built our last piece of furniture last night ... A wardrobe ... Big! It took 3".5hours to build.

Looking good overall I have to say!

DW

London Bound

I start a long trek to London today. Because of bus times I leave here in about two hours, one night in Bangkok then hop over to Kuala Lumpur for the direct flight to Heathrow.

This is all for work.

DW

Wonderful Technology

Yes, modern technology is wonderful, so where have I been, where are my latest posts?

There are two posts firmly rooted in my blogger outbox. I tried to create other posts whilst I was travelling.

Technology is wonderful but just try being a little off centre in your demands and you might as well be trying to use the internet on the moon!

DW

9.10.13

We're in ... Almost

The house is almost ready but not quite. I said, I can't wait much longer. Living in a room in someone else's house, taking up space, trying to keep out of their way as much as possible.

So, we've moved into bedroom two was three and we sleep there. As work goes on, we spend the day in the house with the family.

Every time I look at the jobs that need to be done I see another week or two to wait.

Now, though, I spend my evenings in the new room and the nights snoozing in it!

Here is a photo of what I can see from the bed ... iPad camera, poor quality.


No curtains yet!

DW

29.9.13

Here's Another Contrast

The beginning and the end: the alpha and the omega!!

DW






One Week Old

Here they are after one week, the puppies!



DW


Step One

We are here ...


Hope you can read Siem Reap on that plate!

DW


28.9.13

Shoulder, Shoulder ...

Although my shoulder/chest pain is still with me and I have spent a lot of time in agony over the last few nights, I slept pretty well last night.

I know a lot about the problem I am facing but fully beating it is proving to be a challenge.

This morning my left arm is aching a little but it is inconvenient rather than outright agony. Looks like I might have started to beat whatever I did to start this torture.

By the way, the pain has been so bad that paracetamol and NSAIDs have not helped.

DW


26.9.13

When I'm Cleaning Windows!

Well, I will, once they've put the glass in. Anyway, this is the first window to be fully installed, glass excluded.

I asked to be framed! Suave as ever 😳

DW


22.9.13

Puppies Arrived!

Slutty the dog became pregnant after the dog of her dreams bounded into her life one afternoon. I saw the dog at the same time as she did. I wanted to beat it with a stick but she swooned and ran to him.

I had seen her with other dogs while she was in season and she rejected them all. This one was different: tall, brown and with a hint of ridgeback. I assume he is the father of her pups and when pup number one arrived I said, aha! I was right!

That's why I call her Slutty: a bitch of easy virtue!!

The pups arrived early on Saturday and I was the first person on the scene. My torturing shoulder was keeping me awake and I could hear squealing coming from outside. As I walked out through the back door, the family dog bounded over very excitedly and as I walked on he ran backwards and forwards and led me to a place just behind the washing machine. His look said, look what I found, what do you think?!!

Slutty was hiding in the bottom of an old wardrobe when I walked past and she came over to us too, looked at the puppy, rolling around and squealing. Her body language said, this just sort of popped out ... no idea what to do with it!! The little thing had been licked clean and was already dry so he had been born a while before.

I called for backup and within minutes there were four people, two dogs, the kitten and Slutty's first born.

I couldn't sleep because of my shoulder so I hung around for a while until puppy two  arrived. I had seen the waters break   for this one so knew it wasn't far away. It took a while though.

Photos done I went to bed and managed to sleep.

In the morning there was great excitement outside as puppies three and four had arrived while I had been asleep. They arrived together, literally inseparable, as they were conjoined twins. I had never seen such a thing before and there they were: six legs, two tails and they didn't, they couldn't, survive.

Two healthy puppies, two unhealthy puppies. A decent result for Slutty, first time mother!

Photos below.

DW









Discombobulated Chest and Brain

By the time I got onto the plane to Bangkok the strained muscle in my chest was annoying me and the sleep cells in my brain were shouting ... we neeeeed to go to work ... go to sleep!

I had checked in the lounge if there were business seats available and they said no but check once you're on board. I checked and there were a coupe of seats free so i bagged one!

We were delayed taking off for an hour and i slept all of that hour and continued to sleep for another two hours or so. I did need that sleep!

DW 

15.9.13

Windows ... Who Wrote that Sh*t?

In transit at Dubai airport and the phone hooked up with the wifi in the lounge. The laptop wouldn't connect: Windows couldn't  connect ... Loose cable ... See the administrator ...

So I rebooted and tried again. After a few twiddles, Windows' prognostications were looking expensive.

I went to the connections list, right clicked the one I was trying to open and found ... the password that had been saved was wrong. I changed it earlier this week but it looks as if that loose cable was preventing the saving of it!!

DW


Julius Nyerere Airport Tanzania

I have to say a big thanks to the men and women at the JN Airport, Dar es Salaam.

I arrived with $50 to pay for my visa ... it was $250!

After some faffography I enlisted the help of a kindly member of staff and she got me through the airport to the ATMs but it wasn't her fault that there was no money in either of them. She went out of her way for me!

Then there was the rather severe acting immigration officer who allowed me to get a visa with an IOU stamp in my passport! Bark worse than bite: thank you!

Today I learned that I should have paid the extra $200 in the office in the city. 😳

Another severe type man went out of his way at the airport and was very helpful as he took me through the airport to solve my problem. Again, thank you, sir.

A positive experience all told!

DW



13.9.13

We Made the Bed!

For reasons i will report on later, we decided to build our IKEA bed. I meant to take a photo at every stage but of course I couldn't. Here are the photos I did take!

DW









Yellow Tie

I am the one wearing the yellow tie!

My group in Dar es Salaam this week.

DW


10.9.13

Speed, Distance, Time Left, Petrol Consumption

Average Speed

This is not complicated but it's what I did as I was travelling from A to B on a long bus journey: I set up a spreadsheet to deal with the following.

Although there should have been nothing to worry about, I wanted to be sure that I would make my connection at my destination.

So I wanted to know how fast we were going. There were kilometre posts on the road side for most of the journey and my phone has a stopwatch utility. I found the speed of the bus by combining the distance travelled, one kilometre; and time taken to travel it. I could check our speed whenever I wanted to now!

Then I wanted to know how long it would take us at the last recorded speed to get to our destination B. All I needed to know was the distance to B and then use my knowledge of speed to estimate the time remaining. I could find the distance to B every now and again from the sign posts on the road that told us!

That's all I really needed to know but then I enhanced my spreadsheet by adding these calculations too:

Time to cover one kilometre:

In minutes
In seconds

I considered creating a table to record all of the speeds I found together with distances remaining etc but decided that was academic!

Finally, this spreadsheet can cope with kilometres or miles ... and can convert from one to the other.

Petrol Consumption

As I bought a new car recently I decided I would keep a record of all of the petrol I buy for it. I have also kept a record of the kilometres driven. I record the litres of petrol bought, odometer reading at the time I bought the petrol, cost of petrol, type of petrol: my car can use either E20 or gasohol 91 petrol.

My very simple spreadsheet shows all of the above data and the calculation of kilometres driven per litre of petrol and average cost per litre.

At this stage there are very few data points and the consumption averages have yet to settle down.

Duncan Williamson

Water, Water ... Anywhere?

The water for the house comes from the ground. So they are drilling for it today. As you can see here!

DW





9.9.13

Point to Point

Since i moved to Thailand i have travelled to Saudi Arabia, Mexico, England and Bangkok. All of those journeys essentially started in Bangkok.

Today i am taking a 6-7 hour bus journey to get to Bangkok as I wend my way to Dar es Salaam. 

The bus left 30 minutes late, which is not much of a worry as it can easily make up the lost time en route.

Any stress will come as we approach Bangkok. Last time I did this journey there were horrific holds ups at major road works near Bangkok. 

Whilst i am confident that my schedule has some slack in it, i like to control such things but when I can't I get tetchy! Anyone who has travelled with in times of loss of slack knows what I mean.

So far so good, then: free biscuits already  eaten and free bottle water started. 😁

DW

PS we were well on our way to the bus station when Namwan told me I'd left my jacket behind. Very unusually for me I turned the car round and got said Jacket. Clot!

Kitchen Work has Started

They have started fitting the kitchen now and the skirting tiles are going on ...

DW





31.8.13

Furniture Number One

The first piece of furniture we have built for the house: chest of drawers for the master suite. Being used before we move in, to tidy the space we're occupying at the moment 😁

DW




29.8.13

Book Review: We Bought a Zoo

Benjamin Mee wrote this good easy read. Matt Damon and Scarlett Johansson starred in the film of the book.

Surprise number one: the film is set in the USA, the book is set in England and France. The zoo is in England.

Mee is or was a journalist so his writing style is good, his story flows and develops stories and characters very well.

The story gas several prongs that include the death of the father, who we never meet; the death of the wife, who we do meet and the outrageously unlikely prospect of going from journalist to zoo owner and manager!

They do it! That's not much of a spoiler really as they made a documentary series on the Mee's rehabilitation of the zoo and there is that film to go on!

Mee tells stories of cowardly dogs, wild and very dangerous animals as well as people stories.

There's the big cat under sedation, being carried to the surgery ... when it wakes up 😳 everyone scatters as you can well imagine. Mee is left in its sights and groggy as the cat is, it is still a lethal killing machine. All ends well but it is the kind of story that keeps the book going.

As i was about half way through the book i thought that the stories of leadership, raising money, organising the family, learning how a business works, knowing who to hire and why made this as much a business book as a family tale. Much to learn here by your BA (BS) and B Com student.

The book us a few years old now but well worth reading: family and business points of view alike.

DW

27.8.13

Torrential rain Stopped Play

It rained and rained and lashed it down overnight and none of the building team came to work 😔

There was water in the dining room to mop up and dust to sweep: easily dealt with.

Then we spent an hour or so enjoying the peace and potential of this house. Reading my book, checking emails and so on.

We are looking forward to moving in!!


DW

26.8.13

The Rats Dug Deeper

We went to collect the car today from the Toyota repair shop to be told we couldn't have it yet.

The rats had done far more damage than everyone had thought and it will take more time to sort it all out.

😡 We've got to go back to Bangkok on Thursday!!!

DW

T'tiles are bein' laid

Here you are ... they are laying floor tiles now.

The fuse box was installed today ... about 20 fuses/switches altogether.

Progress!




Here's a Universal Truth

When you are carrying out a significant task or project or some such, everyone who has access to your work will tell you what you are doing wrong or that you are just creating problems for the future.

Very few, if any, if these people will say to you, i would like to help you here ... and then, actually give you that help. 

Of course, such help is often not needed in the slightest!

DW

21.8.13

Miss Mozzie Regrets

If you are a mosquito who bites my legs and feels they might like to read my book, too, take heed ... I will probably do this to you ...
DW

18.8.13

Channel V ... down wi' d kids!!

Channel V is on in the room and i take a look every now and again. This is what i see:

After a maximum of two seconds, the image/scene changes
The singer or group is singing on a stage in a studio or somewhere
The singer/group does, right, forward and backward steps to comprise the dance
They might grab their crotch st some stage
The same two second rule applies 
After a short time as they continue with their dance they will have suddenly changed their clothes from black to white
Each singer takes it in turn to face the camera and tries to look cool or worldly wise as they do so

The good news is that all of the singers look clean and tidy but of course there are still tattoos here and there.

Don't worry about baseball caps either: when worn, they are worn at a raunchy angle!

Not much originality boys and girls!

DW

17.8.13

The 9:15 am ...

This is the 9:15 am Gold Class service from Bangkok to Sisaket and it has just left on time.

DW



Two to the Power of what?

We had planned to tavel back to Isaan on Sunday or even Monday but things changed, as sometimes happens. That meant that we had to book our places on the coach by phone, go to 7-11 to pay for them, all quick quick.

Namwan did everything of course and when she told me it would cost 1,024 Baht for both of us i said,

That's two to the power of ten ...

Namwan: what?

Me: 1,024, that's two to the power of ten. Two to the power of ten is one thousand and twenty four.

Namwan: What are you saying?

I took the piece of paper she was using and wrote 2^10 ...

Namwan: Ah! I see. 

Then she said, You can teach me English but you will never teach me mathematics!

Let's see!

DW

14.8.13

T' Tiles 'ave Come!

There are tiles on site now. For floors, walls and columns. For example:




They did it again!

On the way back to Bangkok i said to Namwan, don't be surprised to find a new nest on the balcony where the old one was.

Sure enough, the adult surviving bird has found another mate and here is their new home ...

DW


6.8.13

Beetlemania

I had the beetle, the camera and the time. Oh! And the torch.

Here's what one might do with the aforementioned!

DW



Today's Nursery Update

The birds are doing well now and their eyes are beginning to open.

We are still feeding them on bread and water but found some ants today. Let's see if they like them.

They eat huge portions i have to say!

DW


Birds? I Spy SHOES!!

At first there was rapture at the sight of those six delicate little birds. Then they saw the shoes that Her Indoors had brought with her.

Birds ... you're already history!!!

DW

5.8.13

Parents of Orphans

Death comes to all of us and to find one parent dead and the other gone, one's thoughts turn to the children. There are six children of this union: sextuplets, in fact. That's rare enough but to be orphaned too makes it even more rare don't you think?

I am not sure what species of bird they are but i photograpged them as they built their nest on our balcony and then settled for what became inevitable: she would get pregnant. They would raise their chicks. Everyone would fly away and the life cycle would have started all over again.

I can hear at least one survivor as type: on the balcony in their nest, now modified to allow human access.

We are trying to rear these chicks but i think our first attempts have given them the itches. Muesli mixed with cow's milk and mashed to a pulp. They were all feeding last night.

I can just hope that the next three weeks or so are kind to all of us and here they are:


DW

2.8.13

Feminists: you did something bad, really bad

Just read this article, everyone.

https://m.devex.com/news/breastfeeding-needs-more-aid/81555?mkt_tok=3RkMMJWWfF9wsRonuK%2FOce%2FhmjTEU5z16ewrUaayhokz2EFye%2BLIHETpodcMS8ZlPK%2BTFAwTG5toziV8R7bNKc1r2NkQXBfn

Now, when you meet a feminist just tell her to stop worrying about portraits of women on a bank note and worry about the catastrophic consequences of bottle rather thab breast fed babies.

It's shocking.

DW

1.8.13

Lungfish or Abouttodiefish?

This fish was skittering across the garden: wither and whence I know not!

Is it a lungfish?

I made a very short video ... usual story, i can't upload from this app. Will try another way.

DW

UPDATE: when we returned from Bangkok the fish had gone! No one else knew it was in the pot so i assume it went over the wall in good old POW fashion!!




Another Moth!

This week I have seen and snapped a Tiger Moth and a half inch long frog in the loo here. Yesterday I found this one ... it's an Arctiid Moth according to http://marianlyman.wordpress.com/. Notice the image of a Lion's Head at the top of the back ... well, Lion's head as far as I can see!
What next I wonder as I ponder in the backa beyonda!! DW