Archive for June, 2010

Urbanathlon Training Tips

Wednesday, June 30th, 2010

I noticed from my web traffic logs that a lot of people were coming across my blog while searching for urbanathlon training tips. My existing articles didn’t really touch on how to train for an urbanathlon so I thought I would write something up for everyone out there. I remember back when I was prepping for the race reading the Men’s Health Training Guide and thinking that it seemed pretty ridiculous. After having actually completed a race I would say the training guide is a cut and paste job. Unless you have an extra hour a day to waste on stretching and weight training then save yourself a lot of time and get some advice from me.

First and foremost this is a foot race. If you want to have a killer time then train like you were going to run a half marathon. That means starting twelve to sixteen weeks out if you aren’t already in good form and focus on running three to four times per week and steadily increasing mileage/pace. I would shoot for being able to run ten miles at your goal pace two weeks before race day. Make sure that you stretch before and after running as well as stay hydrated and eat after running! If you are having trouble increasing your pace then mix in some interval training. I won’t get too into this because there are a million guides to half marathon training already out there. If you do nothing but train for the run and handle the obstacles as they come on race day you will do just fine.

The obstacles are easy. Okay, not easy easy, but relatively speaking they comprise a miniscule part of the overall race. Except for the stair climb each obstacle took me no more than a minute. So even if you are a five minute miler those obstacles will only consist of about 2% of your course time. The most important aspect of the obstacles is to have some foresight into how best to handle the obstacle and to maybe have practiced a little bit on your own. You do not need to go out of your way to train really hard at the obstacles.

The tire stutter step and climb over is easy. Concentrate on landing in the front half of the tire, keep your knees high and stay on your toes. If you step right in the middle and you have big feet like me then your heel may hit the rear of the tire and send you flying. The “monster” truck tires are actually quite small. I stepped up with one high foot and “walked” over them. The last tire actually was large, but you can sit on the edge and swing your legs over. I did not witness anyone having trouble handing them. For me it felt like in the middle of a run I increased my pace 20% for thirty seconds. I really don’t think it is even worth “training” for this obstacle.

Next are the monkey bars and certain people may need to train a little for this. The monkey bars at your local playground may not be the best training arena. The urbanathlon bars are farther apart and quite thick in diameter. Really concentrate on keeping your momentum by swinging your legs. It is most efficient to climb by keeping your arms straight and swinging (like a monkey). If it is raining you may want to consider wearing a set of batting or golf gloves to keep your grip. To practice for this I would find a jungle gym and instead of using the narrow hand rails I would instead use the cross supports. Do a dead hang and focus on using your legs/core to reach out to the other cross support. Then match hands, reverse without coming down and repeat. There are only ten or so bars to handle.

The marine hurdles may pose a difficulty, especially for shorter individuals. They are about five feet high and on the beach. The most efficient way to climb is to place your palms on top, jump straight up into a stiff arm position and swing first one leg over, then the other. Gentlemen… be careful as that other leg comes across. Then hop down and continue. To train for this I would find a chainlink fence and practice jumping up into a stiff arm position. If this is hard for you then pullup/tricep exercises would seem appropriate. Also practice throwing a leg over from this stiff arm position.

The stair climb! Oh how I dreaded and feared it. Turns out it didn’t really matter though. By the time I got to the stairs there was a backup and I ended up slowly walking them. The funny part… I was actually rested after the stair climb because it was so slow. I did get a chance to do a couple full to the top runs and my quads were burning on those. At Soldier’s Field in Chicago the steps are really tiny though. So think about stutter steps to get you up. You get a decent rest on the descent. If you have a race where it is one long set of stairs like NYC then I would do a lot more training for this. Otherwise I think that the running prepares you quite well. If you want extra training just do some hill training. Focus on going fast enough that you really feel the burn in your quads.

Taxi cab hurdle is really more like a crawl over the hood of a car hurdle.

The finishing wall. So I saw a lot of people struggling on this. They have these stupid ass ropes hanging off the wall to “help” you up. I tried one of these ropes post race and I think they hurt you more than they help you. The problem is that the ropes don’t go to the very top of the wall. There is a hole cut in that they run through. Even if you do get up the rope it ends before the top of the wall and you are stuck! Also, the wall has absolutely no traction so you cannot press your feet into the wall easily and work your way up. So the trick is to be able to jump up and grab the top ledge, do a pullup and throw a leg over the edge. For some people that may sound like a lot. This is the only obstacle where I could see training being absolutely required. If you cannot do a pullup then getting over that wall is not going to be easy. Practice jumping up and grabbing the edge of an eight foot ledge. Pull up half way and then throw an arm over the backside of the wall. Finally kick a foot up and over the edge.  If you have the strength then do the same thing you do with the marine hurdles and go into a straight arm before swinging your legs over.

Feel free to leave training tips in the comment section!

Opening Excel Files in New Processes – Excel Launcher Helper App

Monday, June 21st, 2010

Excel Launcher 1.1 (9/1/2010)

So after some comments in the forums about my installer having problems I have updated Excel Launcher to use a new installation package (NSIS) and also made it easier to set the location of your Excel installation. NSIS did not support associating Excel files with Excel launcher so you will need to manually associate them using the technique shown at the end of this blog post. Please uninstall any existing version of Excel Launcher before installing this one.  Download Excel Launcher 1.1

  • Abandoned MS Installation package and switched to NSIS to stop bug where every time you opened a file a searching screen appeared.
  • Running Excel Launcher standalone now prompts you to set your Excel installation location every time and not just the first time

I am a multi-monitor fanatic. If  I could afford it I would have three 24″ monitors sitting on my office desk. Of course all this real estate requires good window management and fortunately Microsoft has finally improved theirs with Windows 7. Dragging windows up against the borders of a monitor causes them to fill either half or the whole monitor. This is fantastic for having side-by-side windows for work. You can also use the Windows Key + the arrow keys to quickly move windows across your monitors. Bravo!

But of course one of my most used applications does not support opening files in new processes. Excel. Why?!?! Why oh why must files always open in an existing Excel instance? This happens in other apps like Internet Explorer, but I can rip off the tabs and make them into new windows. Only Excel seems to cage me into this single window paradigm. After some googling I found a lot of people in the same boat and some very unsatisfactory workarounds including:

  • Modifying the shortcuts for all of your Excel files so that they open in a new instance – I don’t always use the same files so this is out.
  • Disabling DDE – which is no longer possible on Windows 7 and Vista
  • Dragging your Excel window to be really big and then using the internal Excel Window management – not good for multimonitor
  • Always launching a new Excel instance and choosing file -> open -> browse (sigh)

Disappointed, I resolved to manually opening new instances of Excel. But during a restless night it occurred to me – Excel does not open as a new process, but an application launcher could open new instances of Excel. What a fun programming project! I would create my own executable that would be associated with Excel file types -> xls, xlsx, csv, etc. That program would launch Excel and tell it to open the file. Bingo bango boingo we are in business.

So I sat down and within thirty minutes I had working code. I then thought it would be fun to make an installer instead of a dumb exe since there seemed to be so many people looking for this solution. Why not make it easy for them? I wish I had made it easy on myself. Four hours and many google searches later I finally have my program done and created in an installer package. In case anyone is wondering why it took so long I had to account for the fact that I am installing to the Program Files directory. With that comes access restrictions. Then I had to figure out how to read/write/store stuff to the registry. That required error handling. Auto updating research, tray application research, blah, blah blah.

Okay, enough complaining, this is what you are looking for. Download and install Excel Launcher. When you run it the first time it will prompt you for the location of your Excel application. This should be in program files or program files(x86): \microsoft office\officeXX\Excel.exe. Next associate any files that you want to open in a new Excel instance to Excel Launcher. By default XLS, XLSX and CSV files will be associated with Excel Launcher. To associate other files

  1. Right mouse button on an the file -> Open With -> Choose Default Program -> Browse
  2. Navigate to Excel Launcher.exe which should be in your program files directory
  3. Check the box for “Always use the selected program to open this kind of file.”

That’s it. Now whenever you open an Excel file it will use Excel Launcher which will create a new Excel process for you each time and open the file. As of now there is no argument passing so if you use arguments they will be ignored. If there is enough interest I may implement this for people in my copious free time.

Some ideas for improvements:

  • Prompt user to associate common file types when installing
  • Instead of storing Excel path in registry store it in an xml file in program files directory. This will allow multiple program types to leverage this functionality.
  • Allow passing of arguments through to Excel
  • Support DDE? I never really researched this so don’t even know if this is possible.

Removing ATI Underscan from your HDMI LCD TV

Friday, June 18th, 2010

So recently I switched up from using a VGA cable to an HDMI cable on my HTPC and was greeted with a black border around the screen. No problem, just adjust the video scaling and be done with it yes? Unfortunately no. There are tons of posts by people looking for the solution to this problem and not all answers are effective. ATI certainly must know of this deficiency and with the number of people hooking laptops, htpc and business computers up to lcd tvs these days you would think it would be a priority to fix it.

I won’t rehash what has already been explained. AJ does a great job of explaining how to get most people up and running here - http://www.aoclarkejr.com/ati-catalyst-9-9-overcan-and-underscan-options.html

However this article is for the people who this does not work for or who do not want to install the ATI Catalyst Control Center. I happen to be both types. For me selecting “Configure” on my monitor just brought me back to the ATI Welcome Screen. Awesome.

Before we begin ensure that your TV is configured correctly. On my Samsung LCD TV I had to change the picture type to “Just Fit.” This caused my HDMI underscan problem to become slightly less worse, but did not fix the issue.

To fix your display:

  1. Write down the resolution and display frequency you are running at
  2. Start -> Run -> regedit
  3. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Video
  4. On my machine there were five subfolders in this key. Each of these subfolders contained keys named 0000 and 1111. Only one of these subfolders contained a ton of entries while the rest had only six entries. The subfolder with a ton of entries is the folder you want to be working with.
  5. Backup the 0000 and 1111 keys. Don’t just backup the whole video folder or subfolder.
  6. Select the 0000 folder and search for your tv’s resolution. In my case it was 1920×1080.
  7. There will be multiple entries found in the format Name ResolutionxFrequency. eg:
    • DALR6 CRT1920x1080x0x59 - I believe this is your VGA connection
    • DALR6 DFPI 21920x1080x0x59 - this was hdmi for me
  8. Edit the key that matches your resolution AND frequency – change everything to zeroes
  9. There is a corresponding key in the 0001 folder. Change that one also.
  10. Change your monitor resolution and then change it back to 1920×1080 or whatever you are using
  11. The underscan should be gone

I tried to figure out what these keys control, but failed to decipher what the binary representations were. I even wrote a little program to try and convert the key to hex/string/int/decimal/etc with no success. If anyone could provide feedback on this it would be good karma. Logical sense would say it should be a decimal like .01 or an integer like 1 to represent 1%.

I’ve had this post waiting in the wings for weeks and of course just as I am about to post all this crap ATI releases Catalyst 10.6 which appears to have fixed the problem where the welcome screen doesn’t appear. Ugh.