Photographing Every Country in the World, Overland.

Archive for March, 2008

Hacking my maps

Day 196

Morelia,

I spent 2 days messing about with my , getting them linked to my posts, and its been a minor . Its not good to have to edit them manually so I’ve been working on automating the whole process through macros. After much effort I finally succeeded and so now I only have to press a few buttons and its mostly sorted out.

So, in case anyone is interested, here is the code. I will do a better post sometime in the future. Maybe. The results should be apparent in a few hours…

Sub Macro1()

‘ Macro1 Macro
‘ Macro recorded 1/19/2008 by

‘ Keyboard Shortcut: Ctrl+q

‘initial cut to 10kmh subroutine
‘Application.ScreenUpdating = False
‘delete first row
Range(“A1″).Select
ActiveCell.EntireRow.Delete
Range(“A2″).Select
Do

If ActiveCell.Offset(0, 5).Value < 10 Then

ActiveCell.EntireRow.Delete
ActiveCell.Offset(-1, 0).Select

End If

ActiveCell.Offset(1, 0).Select

Loop Until IsEmpty(ActiveCell.Offset(1, 0))
‘delete last row
ActiveCell.Offset(0, 0).EntireRow.Delete

Application.ScreenUpdating = True

‘delete unneeded time and distance columns
Columns(“E:F”).Delete

End Sub

Sub Macro2()

‘ Macro2 Macro
‘ Macro recorded 1/19/2008 by

‘ Keyboard Shortcut: Ctrl+w

‘second macro to halve the output each time it runs

Range(“A2″).Select
‘Application.ScreenUpdating = False
Do
ActiveCell.EntireRow.Delete
ActiveCell.Offset(1, 0).Select
‘ActiveCell.EntireRow.Select
‘ActiveCell.EntireRow.Clear

Loop Until IsEmpty(ActiveCell.Offset(1, 0))

Application.ScreenUpdating = True

End Sub

Sub Macro3()

‘ Macro3 Macro

‘ Keyboard Shortcut: Ctrl+Shift+E

‘make sure we can see the date
Columns(“D:D”).Select
Selection.ColumnWidth = 20

Dim startdate As Date
Dim datenow As Date
Dim days As String

Dim blogtitle As String
Dim blogpage As String
Dim blogloc As String
Dim currcell As String

‘define start of trip
startdate = “13/09/2007″

‘start at row 3
Range(“A3″).Select
Application.ScreenUpdating = False
Do
‘check if the dates change
If ActiveCell.Offset(0, 3).Value <> ActiveCell.Offset(1, 3) Then
‘select the row under &
ActiveCell.Offset(1, 0).Select
‘make a new line for kml info
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
‘remember active cell
currcell = ActiveCell.Row
‘copy the date now
datenow = ActiveCell.Offset(-1, 3).Value

Range(“K1″).Select
blogtitle = ” No entry for this day”
blogpage = “”
blogloc = “”

‘work out the date and then pull the info from the list of points from the K column
Do
If ActiveCell.Offset(0, 1).Value = datenow Then
blogpage = “http://www.traveltrousers.com//?p=” + ActiveCell.Offset(0, 0).Text
blogtitle = ActiveCell.Offset(0, 2)
blogtitle = “<![CDATA[<p><A href=" + Chr$(34) + blogpage + Chr$(34) + ">" + blogtitle + "</A>]]>”
blogloc = ActiveCell.Offset(0, 3)
‘info found so exit loop
Exit Do

End If
‘move down to continue loop
ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Offset(0, 0) = “END”

‘start back at the top
Range(“a1″).Select
‘& go back to previous cell

ActiveCell.Offset(currcell – 1, 0).Select
‘work out how many days have passed
days = Application.WorksheetFunction.Days360(startdate, datenow)
‘fill out the cell with the info
ActiveCell.Offset(0, 0).Value = “</coordinates></LineString></Placemark><Placemark><name>Day ” + days + “</name><description>” + ActiveCell.Offset(-1, 3).Text + blogtitle + “</description><styleUrl>#msn_ylw-pushpin</styleUrl><Point><coordinates>” + ActiveCell.Offset(-1, 0).Text + “,” + ActiveCell.Offset(-1, 1).Text + “,” + ActiveCell.Offset(-1, 2).Text + “</coordinates></Point></Placemark><Placemark><name>” + blogloc + “</name><description>” + ActiveCell.Offset(-1, 3).Text + blogtitle + “</description><styleUrl>#sn_ylw-pushpin</styleUrl><LineString><coordinates>”

‘move on if succesful
ActiveCell.Offset(1, 0).Select
End If
‘move down to continue loop
ActiveCell.Offset(1, 0).Select
Loop Until IsEmpty(ActiveCell.Offset(1, 0))
‘delete the unneeded columns
Columns(“D:N”).Delete

End Sub

Tags: , , , , , , , , , , ,

I’m going home….

Day 194

Morelia,

I bought a flight back to the UK today. I guess I had no choice, who else would be my Brothers best man? :p So on the 22nd of April I will be flying up to New York for 4 days before heading back over the Atlantic for 3 1/2 weeks. I’m not sure whether to be happy or depressed :/

Spent the day wandering around Morelia, which is a pretty nice town and took a few pics. Here are some of the better ones.

27Mar2008_Mexico_Morelia_0031 27Mar2008_Mexico_Morelia_002627Mar2008_Mexico_Morelia_004527Mar2008_Mexico_Morelia_0029 27Mar2008_Mexico_Morelia_001927Mar2008_Mexico_Morelia_004227Mar2008_Mexico_Morelia_005127Mar2008_Mexico_Morelia_006128Mar2008_Mexico_Morelia_009528Mar2008_Mexico_Morelia_0005

28Mar2008_Mexico_Morelia_000327Mar2008_Mexico_Morelia_0062

Tags: , , , , , , , , , ,

The Mexican Mirror Scam

Day 192

Guadalaraja,

I finally got some new mirrors so I’m gonna be out of here tomorrow. With Easter making all the shops close for a week I didn’t want to have a 400km over to Morelia with no mirrors, or even my little hand held taped on… I went down to the ‘Spare parts’ district on Saturday after I found everywhere was closed from Wednesday onwards and you should have seen the guys running after me when they spotted I didn’t have any mirrors. One guys seemed to think he could get some but after standing around for 5 minutes I drove off, much to his dismay, I’m perfectly capable of getting my own mirrors… Some other guys stopped me, and wanted …. $120! wow! They dropped down to $90, and kept going on about original parts. Big deal, they’re only mirrors, and they’re probably MY original parts. I wasn’t prepared to negotiate from such a high figure so left the area. Its a great scam, I saw a few other people with US plates looking for mirrors… Steal their mirrors, sell them to the shops and everyone is happy. Apart from the .

I went back this afternoon and got 2 mirrors and the plates for $40. I probably should have haggled harder. He started at $60 and kept making a show of calling someone on his mobile to get a cheaper price. As usual the threat of walking away got the price down, but I suspect you could get exactly the same mirrors for $20 in a US breakers yard. So if you’re driving south bring a spare , or 2. There’s a good chance they’ll be broken sooner or later anyway. So after 2 weeks of hanging out in a large city, reading, writing and learning Spanish I really have to get a move on.

With some luck I will be doing some more paragliding later in the week, apparently a place called Valle de Bravo, near Meico City, is quite good for it. Wish me luck! :)

Tags: , , , , , , ,

Merry Easter

Day 188

Guadalajara,

I woke with a jerk this morning. Or should I say this afternoon.

I’ve been in Guadalaraja for over a week, just wandering around in the day,  eating at a nice cheap veggie place I found, sitting in the plazas reading and learning Spanish, playing my guitar, but sleeping later and later. I my alarm and just ignore it. Its a hard habit to break.  I was going to leave today but yesterday, when I eventually got up at 2 PM, found all the car parts places were shut due to ‘Semana Santa’ or Easter as its known here. I can’t go driving without mirrors so I was stuck. But I’ve been paying for my room and playing it by ear, they asked how long I wanted to stay at the start and I said ‘Quién sabe’  or ‘Who knows’… They don’t speak English here though, but I know enough Spanish now to let them know when the light stopped working or that I didn’t need the woman cleaning my room every single day. I’d just prefer it if they bought a and killed the mini cockroaches in the bathroom. :p

But the owner was hammering on the door just before noon and just before my alarm sounded. He had shown me sign yesterday that said checkout was at noon, which I knew, but I wasn’t checking out… I was reading in my guidebook that you should book ahead for Easter in some places but I didn’t think much of it, apart from when I got woken up and then he wouldn’t take my for another night. Great. I understood enough to work out the room was already booked, probably for the weekend. What was I going to do now? Well, there is always the beach… only 5 hours drive away.

Guadalaraja is nice, lots of old buildings and ambience. Its been getting busier in the run up to Easter though. Yesterday the center was pedestrianised and it was bedlam, people everywhere and impossible to walk around. I had off towards the west side with a in my head and an address, always the best way to find somewhere. I wanted a cable to connect my flash to my camera, since I lost my wireless receiver on day 5 of my trip. They didn’t have any, but I still had to go off to see some upstairs who spoke English so the assistant could ask ‘why? It connects on the pins’. The assistant only works in a camera shop, its not enough for him to understand that Canon sell them, I want one, ‘why’ doesn’t come into it. I guess I should have told him to go to www.thestrobist.com but its all in English.

I started packing my stuff, took down  my mosquito net, which is now saving me from daily ravishments by the local insect population (I put it up when I woke to find my forehead bitten a dozen times…. I must buy some anti-malarials soon too….) and got my shit together. I went down to talk to the owners wife, she was either afraid or liked her distance as she kept backing away from me :p She explained I could move into the little room on the rooftop. Fine with me. I finished packing my stuff and then she comes to tell me I don’t need to move after all. Kind of even better, despite the fact that I’m ready to go.

At least I saw a Easter miracle today. I rose from the dead in the morning :)

Tags: , , , , , , ,

Bloody kids!

Day 182

Guadalajara,

I go outside to my car and find some ass-masters have stolen the glass in my rear view mirrors! I thought about getting mad but then…. they’re only mirrors…

16Mar2008_Mexico_0643

Tags: , , , , , , , ,

Wandering around Guadalajara

Day 181

Guadalajara,

I was getting close to finishing off the current book I’m reading, an Umberto Eco novel called ‘The island of yesterday’ which was a tour de force of brilliance but was slightly distracting in my quest to be a tourist. I must try not to read when I wake up as there is a natural tendency to fall asleep once more, which is of course what happened. It was afternoon by the time I woke and I wandered up into town to find something to eat. My car was sitting baking in the and I opened it up to find the new wax on my surf had melted and dripped all over one of my mats :/

The city center isn’t very far so I decided against putting my bike together and just walked up. The was pretty bad, but this being the second largest city in would only be eclipsed by City, a place I’m not looking forward to driving in, but shouldn’t be any worse than anywhere else, it would just be more crowded. People in the states told me that Boston had the worst drivers but I didn’t particularly find that to be true just as people in warn me that City is a to drive in, but I’m not so sure. I’m sure its only as bad as or Kamapala in Uganda. More means you go slower but also means its safer. Then you only have the problem with the around you. I’ve found Mexican drivers to be rather selfish though, the usual of third world thinking where everyone is looking out for number one. Yesterday I saw a ambulance sitting at the lights with his lights flashing and no one moved. So either it wasn’t a real emergency or the driver realised that even using his siren wouldn’t get them out of the way. This is the scariest thing I guess, you can your car, get some help and the still kills you on the way to hospital.

Surveys show that the vast majority of people consider themselves to be an above average driver but this is clearly impossible. I find it better to regard myself as a below average driver since I am regularly doing what is the most dangerous activity in my life it is better to regard the whole act of driving as a easy route to my own death and I would be better thinking I barely knew how to drive. Hidden oil spills, dogs on the road, blown tires, mechanical failure, gravel, dust and sand, huge potholes…. the list is endless and all waiting for an unwary driver to not be concentrating. Dying in a car is surely the stupidest and most pointless way to die as its highly preventable. Dying in a drink driving is far, far worse, but we’re in … It happens.

Maybe I should go , Guadalajara has loads of stores and I think my current wardrobe is rather lacking. At least I don’t have to carry any :) In the city center I off in search of something to eat but I didn’t seem to have much luck. Everything seemed so… meaty! I wasn’t going to starve though I’m sure, and I’m happy to back into size 32" jeans once more, maybe I can get it down to 30" before the end of the year, something unseen for 10 years. Kira reminded me about a water/maple syrup/cayenne pepper/lemon juice diet with daily water enemas which would probably do it. 10 days of that and I’d be really able to eat like crazy for a few months :p If only I could find some food. I found myself in the wedding dress district which was clearly the wrong place for a hungry tourist although it was packed with hopeful looking all window for their perfect dress, whether they had the perfect man to go with it was unclear.

16Mar2008_Mexico_0645

Guadalajara isn’t a bad place to get lost searching for something to eat though, the architecture is stunning, with sunny plazas around every corner and neoclassic buildings towering overhead. Its still typical though with plenty of street sellers hawking their wares; beggars and buskers. I finally gave up and headed for Sanborns, a slice of the 50′s and somewhere I had eaten in before. I was disappointed to see that they give you Nescafe if you order with hot milk, although I’m not sure whether that was a better option than the weak Americano with those awful non-dairy creamer pots you get. What’s so wrong with milk?? I spent far too long reading but tempered my guilt with going through some Spanish-English flash and hopefully sticking a few more words to my dull brain. By the time I was onto the last chapter it was dark outside but it was still early and I ‘t even eaten. I then realised that I had gone through a time zone and lost an hour, but this is hopefully the last one I will have to suffer. I really don’t like going east!

Tags: , , , , , , , , , ,

Time to leave

Day 179

San Blas,

Everyone had gone! Even the two under Cabana had left, heading into town for a hotel room before their early morning bus ride, there was only the German group left and they weren’t too keen on speaking in English all day. Maybe I should have gone to Sayalita with Ben and Noah, but they didn’t ask and I didn’t push. I made some (my had run out) and sat on my balcony for most of the day trying to get back up to date with my . I wrote and I wrote and slowly the days disappeared, its funny how long it takes to get back up to date, even when you’re seeming doing very little. My legs and arms were a galaxy of red stars though, the sandflies setting off supernovas all over my body that itched like crazy. I was thinking it might be time to get out of San Blas, really break the curse and move on, I would head to Tepic and decide from there.

Tags: , , , , , , , , , ,

Hunting Crocs

Day 178

San Blas, 20080311_San Blas_1120 20080311_San Blas_011920080311_San Blas_1113 20080311_San Blas_0282 20080311_San Blas_0214 20080311_San Blas_0170 20080311_San Blas_0136 20080311_San Blas_0114 20080311_San Blas_1137 20080311_San Blas_001220080311_San Blas_116220080311_San Blas_1161

20080311_San Blas_1172

boat trip/bye to kira/finding the right boat/ etc/ swing/laundry and /dinner with boys/lazy boys/ride into town/renaming /looking for croc skull/guitar-surf-run/taco’s in town

Tags: , , , , , , , , , , , , , , ,

Lazy Mathematics

Day 175

San Blas,

Getting up at 11am + playing Super Mario 64 on my for 1/4 of the day + reading for 1/4 of the day + surfing for an hour while the sets + playing my guitar+ 4 = Bliss

until 11/Mario/reading/surfing /

Tags: , , , , , , , , , , , , , ,