Techkeyla:How To

Pwn YouTube with PwnYouTube to download Youtube videos

Posted on: 20-08-2010

Category : how to, tools

Yes, we have done quite a few YouTube downloading how-tos in the past. Some of them still work, some don’t. The one which continues to work is the ever-updating awesome tool – KeepVid.com. But remember the good ol’ days of the javascript bookmarklet which used to make life so much easier. Well, the bookmarklet is back again.

And it’s called – PwnYouTube. Go drag and drop it on your bookmarks bar just as I did.

PwnYouTube Bookmarklet

Now when you visit a YouTube video, on the page, when you hit the bookmarklet, the menu option appears on top of the screen. Its on a yellow background, so I don’t think you’ll miss it. For your convenience, it looks like this.

PwnYouTube to download HD videos from YouTube

Right click, and save as shown. Voila! Easy peasy!

Else, there is another alternative. Just append ‘pwn’ before the youtube video URL.

e.g. To download video: http://www.youtube.com/watch?v=66TuSJo4dZM, enter

http://www.pwnyoutube.com/watch?v=66TuSJo4dZM

You’ll be redirected to deturl.com, and there, you’ll find options to download it from SaveVid, YouDDL and KeepVid.

So there you go, happy downloading YouTube videos.

Google Image Search Hack: Full size images, No Thumbnails

Posted on: 04-08-2010

(0)

Category : google, how to

Tags: google, hacks, resources, services

**********************************************************

Google Image Hack

Google Image search is one of the most visited search engines. Be it searching for normal images we want for a project, or something we want to grace our desktop/laptop as a wallpaper. And more often than not, it is the latter. So, it is quite cumbersome when it comes to searching on Google Images for the appropriate sized – or in other words, wallpaper sized images from the huge list of thumbnails. It is a further pain to sort out by clicking on each of them to verify if they are indeed good looking images in the full size, and if they are not pixelised.

The solution: a Google Image Search hack which allows Full size image results, no thumbnails whatsoever, for your full viewing pleasure. [ as shown in the pic above]

The link is here:

Google Image Ripper » Dear Computer,.

Enter your search keyword, choose your size – which ranges from icon to xxlarge to huge. Press “Rip Google” and voila. Just be prepared to be hit by a massive wall of wallpapers. And just for your viewing pleasure, I’ll attach a massive High Definition wallpaper of Inception. Of course, this one’s a thumbnail, so do click on it to enjoy it in full HD glory. [ The image below might take a while to load ]

Edit and Share YouTube videos online with TubeChop

Posted on: 10-07-2010

(0)

Category : how to, tools

Tags: hacks, how to, YouTube

TubeChop

We all love to share YouTube videos don’t we. Especially with the ever growing number of excellent videos on the world’s biggest video database, we always find something or the other which we would rate as amusing or simply a must-watch. But for some impatient ones like me, we always tend to be really excited about the stuff we share. And we want to share a specific portion of a YouTube video. We often even use YouTube videos for referencing – like a particular portion from a video would help an opinion etc etc. You get it. But how do we achieve it. Well, the usual drill was to mention, please refer the video from 2 mins and 40 seconds onwards blah blah! But not anymore. Techkeyla is here to the rescue. Enter – TubeChop. Not only can you edit YouTube videos, but also share it, embed it, and prove your awesomeness.

So how do you actually do it?

Glad you asked. Just go to TubeChop. The text bar on the site, asks for the YouTube video URL. Just paste your desired URL . For our tutorial, we are using this supercute LOLcat video. Once you paste and hit enter, it will ask you to select the start and end points of the video.

Just drag and seek the start and end position bars as required. Easy peasy!!

TubeChop tutorial - Editing LOLCAT video

Once done, hit the Chop It button. The next page gives you the link, as well as the Embed Code. Howzzat!
The only weakness of this tool is that it does not work with videos which have disabled embedding.

And because you have been so attentive, you get to see this really cute and home-edited version of LOLCATS. Enjoy and happy edited sharing. Cheerio!

Excel Tips: How To Create a Dynamic Range of Cell Selection

Posted on: 14-10-2009

(3)

Category : excel, how to

Tags: analysis, excel, how to, techkeyla

In the past couple of months of working on Excel and VBA Macros, I have been exposed to a few challenges which in the course of time, I have overcome. So, I thought I would share them with my beloved readers. This section: Excel Tips aims at sharing the small tips and tricks that I have come across which makes life easier for anyone working with Excel or VBA Macros. Cheers!

Here we’ll be focussing on how to select a range dynamically and perform further operations to it etc.
For e.g. If we have a Sheet “Input” of which one cell is required say column B, and we need to perform some kind of mathematical operation on them – viz. average, sum, etc. we need to do that by selecting the entire range of non-empty values of those two cells.

The problem here is that the number of entries in column A will vary from time to time, but we want a command button which automatically knows the amount of non-empty values and accordingly runs the mathematical operation. This is known as Dynamic Range Selection.