The Blarg of Fosnez

If you have not got the ability to create a Salesforce.com custom field to generate the 18 digit case insensetive ID, as demonstrated here , you can use this formula to convert the ID in "A2" to the 18 digit ID. Of course you can then extend this formula all the way down column A if you need to. =A2 & LOOKUP(IF(AND(CODE(RIGHT(LEFT($A2,5),1))>=65,CODE(RIGHT(LEFT($A2,5),1))<=90),1,0) & IF(AND(CODE(RIGHT(LEFT($A2,4),1))>=65,CODE(RIGHT(LEFT($A2,4),1))<=90),1,0) & IF(AND(CODE(RIGHT(LEFT($A2,3),1))>=65,CODE(RIGHT(LEFT($A2,3),1))<=90),1,0)& IF(AND(CODE(RIGHT(LEFT($A2,2),1))>=65,CODE(RIGHT(LEFT($A2,2),1))<=90),1,0)& IF(AND(CODE(LEFT($A2,1))>=65,CODE(LEFT($A2,1))<=90),1,0),{"00000","00001","00010","00011","00100","00101","00110","00111","01000","01001","01010","01011","01100","01101","0111...

In my spare time, I work on little projects. Here's one of them. █▀▀▀▀▀█  ▀▀█▄ █ ▄ █▀▀▀▀▀█ █ ███ █ ▄▀██  █▄█ █ ███ █ █ ▀▀▀ █ ▀▄█ ▀█▄ █ █ ▀▀▀ █ ▀▀▀▀▀▀▀ ▀▄▀ █▄▀▄▀ ▀▀▀▀▀▀▀ ▀█▄ ▄█▀▀ ▀█ ▀ ██   ▄██▄▄   █▄█ █▀█ ▀▄█▀ ▄█▄▄▀▀▀█ ▀█ █▀▀   ▀  ▀█ ▄██▄▀ ▀▄   ▄▀ █ █▄▀▄▀▀▀█  ▄███▄▄▄▀▄▀▄▀█ ▀ ▀▀  ▀ ██▀ ▀ ▀██▀▀▀█ █   █▀▀▀▀▀█ █▄█▄▀▀█▄█ ▀ █▀  ▀ █ ███ █  ▀█▀▄▄ ████▀▀█▀▄█ █ ▀▀▀ █ ▄▀▄ ▄█▀█▄  █▄ ▀ █ ▀▀▀▀▀▀▀ ▀  ▀▀▀  ▀ ▀  ▀  ▀ It creates QR Codes in text, instead of images. The Source is available.

Over the last few days, with all the rain around, I have been checking the webcams on QLD Transport's Site every now and then. I use iGoogle as my homepage most of the time, so I thought it would be convienent if I could watch them there. After a some hours of programming, here is the end result . It allows you to select up to 5 of the 75 cameras in Queensland ( there are four in Cairns ). You can also add two of your own feeds, so if you have a webcam at home for security or whatever, you can load it in as well. Let me know what you think and tell your friends about it!