Blogs

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Getting in shape for Le Tour de France

Watching cycling in Australia is very much like riding. The time difference to the rest of the world forces us to adopt a lifestyle of late nights and bleary eyed mornings as us dedicated fans adapt to the rigours of the major events leading up to the pinnacle grand event, the Tour de France. The lead up events are all good training. So far I am not doing too well, but I’m starting to get my legs in as I build up for July.

2011-07-22 Col de Galibier 032Warning – mixed metaphors coming – substitution of riding and watching will happen randomly in the following post.
The Giro d’Italia was a poor event for me. After sleeping in at the hotel on the first day i missed the time trial and was booted from the event before it even started. I rode bits of it courtesy of the highlights packages for the minor days and thanks to my media centre i was able to ride the extended longer weekend stages in most cases in one go. Riding after the actual race day though meant a lot of the ambience and excitement wasn’t there. No live twitter feed to cheer me on and no sag wagon to support. No race directors forcing me to stay on course meant a few short cuts occurred and in some cases allowed parts of the stages to be ridden over two days. Towards the end I did put in a marathon three days ride in one early morning and caught up to he field to ride the final two days with the actual race.
This meant I couldn’t compete in the Tour of California which runs at the same time. I did however ride it solo later on. Once again skipping many kilometres but making sure I completed the main mountain stages and time trial.
All this was getting me in good stead for the big event by getting miles into my lounge chair. The tour curtain raiser is the Criterium du Dauphine. I’m ashamed to say I missed the first five stages. With no real excuse either. Just missed them. Stage six was started well but unfortunately i was dropped by the bunch when Wiggens launched off the front of the peloton to drive across to Cadel Evans group. My fault – missing those first 5 stages meant i had no staying power. The race was over when I awoke and I had to back up to where I had left off. Unfortunately this happened three more times in the next 25 kms before I finished the race.
I have two more stages left this weekend to get my legs in. My biorhythms are changing slowly. Come July I hope to be in great form and able to stay with the bunch all the way through. Surely those rest days wont come soon enough. But the excitement, the dedication of all the other fans cheering at their TV screens all around Australia in the dead of the night as our heroes do battle for ultimate glory culminating in the finish on the Champs Elysees three weeks later is just incomparable to any thing else.
This time last year i had no idea that in just a few short weeks i would actually be in France living an absolute dream thanks to HTC. This year unless a miracle happens again I’ll be doing it from my armchair along with all my mates from #sbstdf and #sagwagon.
See you in the peloton.

jethro's picture

Link dump for June 2012

2009-11-01 Photowalking 278Here are some interesting links and reviews from this weeks reading and research.

Far Cry 3 preview – reviewed by Fidget from fragdolls – I loved Far Cry 1 and 2 – cant wait for 3.

Assassin’s Creed 3 preview – reviewed by Cryptik from fragdolls – I have played and loved every Assassins Creed game so far – cant wait for this one!

Windows 8 and Metro Development – great explanation of Metro for Windows 8 by Damana.

Skydrive has now launched apps for Windows and Mac. We have tested the Windows one extensively and are now implementing it as a cloud backup strategy for small home users.

We love Photosynth. I have yet to install and play with the new Photosynth app on a Windows phone – but will try it later and let you know how it goes. There is also a Photosynth iPhone app available

Australia’s Labor government is about to start stealing money off us with a Carbon Tax – explained away by insisting that global warming is caused by human emitted CO2. The video here shows the fallacy of this “science”.

Social Media Links

Social Media use is on the rise on a massive way. Companies and businesses are still learning if and how to get involved. Here are a number of great articles.

Dion Hinchcliffe writes an excellent article titled Should companies drive their traffic to Facebook?

I wish this social media course run by Laurel Papworth was coming to Brisbane. Sydney people go and learn!

26 Tips for Integrating Social Media Activities – lots of good info here. Worth a read.

5 Reasons you should measure Social Media Return on Investment

5 Ways to tell if Pinterest is right for your business. We have started using Pinterest; watch for our boards to grow and expand as we learn more about this cool new tool.

Facebook Adds Admin Roles – a good explanation of the role settings and use.

5 Simple Metrics to Track Your Social Media Efforts

jethro's picture

Work Life Balance

We hear a lot about work life balance these days. ITs a big problem for a lot of people and its something i definitely struggle with also.

One of the main reasons i struggle with it is because my life is my work. I am passionate and excited about what i do – well most of it anyway, and as such my every waking moment and some of my sleeping ones are planning and thinking about work.

Slide1But what is my work? For me it includes web development, photography, sports coaching and software development (those dreams are nightmares usually). I have fun doing all those things, I love the interaction with clients customers and staff and I am passionate about my art.

My relax and off times are often found with a camera in hand having fun with my family. We go the beach, the park, fly a kite and i have two motives, one is to go and hang our with the girls and have fun and the other is to take some photos. I explore new ideas, try new techniques and still manage to interact with the girls.

My Spiritual side – my Christian life – is completely bound up in who I am and what I do. I am a member of the High Calling Website because i completely believe that my work is as much a part of my spiritual being as anything else. They are featuring a fair number of my photos there in their articles which is fantastic.

My sports and exercise are more than ever involved with my family now. I used to play sports that did not involve the family such as AFL football and Soccer and squash. three years ago i made a decision to quit football, not because i wasn’t excited about playing anymore but because i wanted to put that time into sports and exercise pursuits with my family. Now I run, cycle and exercise with all my family on a regular basis. I still do more extreme riding than the family is up to both on the road and mountain bike.

Slide2So – I reject this common expression of balance as an impossibility. No ones lives are segmented like that.

Instead I prefer an overlapping holistic view that to some extent allows separation but also shows the overlapping nature of life’s components.

How do you manage balance in your life? Do you have techniques or ideas that work for you? Comment below or on Facebook.

Here are some links from The High Calling about balance.

Work-Life Balance Doesn’t Exist

Keeping Your Life Balance

jethro's picture

A practical way to use the IF function in Excel

The IF function is a very useful logical tool. I have written an explanation on the IF Function before so I wont repeat that here. There are a number of other posts also that incorporate the use of the IF Function.

ExcelWhat I want to do is highlight a useful way to use the IF function.

I use it a lot to compare lists of data. today I had been sent some data in a spread sheet that contained email addresses. I had to create a mail out to those email addresses and when i did that I received a number of bounce backs for incorrect email addresses. I then received a second email from the original person containing a revised spread sheet with the corrections to email addresses. given that there were a large number of addresses and only a few changes I didn’t want to painstakingly work my way through the list looking for changes. Instead I copied the new list beside the old list and then wrote an if statement to compare the original with the revised. It is very simple and uses a 1 or 0 result. You could use anything there including TRUE or FALSE or “OK” and “ERROR” etc. Then a simple filter showed me the incorrect ones and the fixes i needed to apply in my mailing list.

Obviously I have obfuscated the email addresses in this example for privacy reasons.

The actual IF statement is very simple. In Cell C1 I wrote =IF(B2=A2,0,1). Filling it down is as simple as double-clicking the right hand bottom corner of the cell.

image

Then I added a simple filter to hide the correct results and only display those with differences.

image

I use this technique many times a week in comparing data lists.