by Sujoy on October 14, 2009
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.
[Continue Reading]
by Sujoy on October 8, 2009
Download ONLINE. No Software Required.
Yes, you read that right. You can download Megavideo videos for free online without any software installations which load bunch of spywares and adwares into your hard drive.
For starters, Megavideo is a video hosting site, which unlike other video streaming websites like YouTube, DailyMotion and the like, has no upward time limit for videos. The range of content on Megavideo has been similar to its parent data sharing website Megaupload – [ if you know what I mean]. The catch here is that Megavideo allows non-premium users to view only 72 minutes of content at once. After this time is exhausted, the video streaming is halted. There are other work-arounds as mentioned in my post here [Firefox Hack: How to watch Unrestricted Full videos on Megavideo]. But if you are one of those, who just want it downloaded on your PC,Mac whatever, just follow the instructions below.
[Continue Reading]
Good ol Megavideo is now a paid website. And hence to enjoy the full unrestricted video viewing, one would have to pay and subscribe. Unpaid or Free users are restricted to just 78 minutes of viewing after which, the video would be disabled for the next 2 hours.So, if a movie is say, 80 minutes long, you are going to miss the nail-biting climax(That sucks!). There is a work around for this in Firefox, which allows users to view unlimited number of videos for any desired amount of time. Just follow the instructions given below.
1.Choose the URLs of the videos you want to watch. It can be even just one movie, or multiple video URL pages. Open them in multiple tabs on Firefox.
2. Start the video as usual (Hit the Red Play Button to turn it into Green, and then Push Play).
3. Pause the Video to let it Buffer. Repeat this for all the open tabs of videos.
4. Wait until Video or Videos have been 100% buffered till the last bit. (You know how to detect that, yeah the seek bar would have a grey progress bar kinda thingie approaching right).
5.Once buffered, go to File menu of Firefox. The Dropdown Menu has an option called “Work Offline”. Enable it.
6. Enjoy uncut, unrestricted viewing on Megavideo.
7.Remember to go back and deselect Work Offline when you are ready for another Movie or want to Browse the Web again.”
This also works in IE and Opera.Chrome unfortunately has Offline mode for only Google Gears enabled sites. Finally, for Mac users, there is no Work Offline mode in Safari.
by Sujoy on April 24, 2009
I know, I have done a lot of posts on YouTube video Downloads so far. Javascripts, and old favorites like Keepvid. But this new tool is fast becoming my favorite. I don’t feel the need to go back to Keepvid anymore. Because KeepHD is the one stop shop which fulfills all my YouTube needs.
a) It supports HD video download as well. Yes, just copy the URL and paste it in the address bar on the KeepHD page. And voila!! Your video can be downloaded in FLV Low Quality, 3GP Mobile video, MP4 High quality or HD.
b) Second best thing, the address bar gets auto-deleted when you click on it. So, once you are done downloading your previous video and before pasting the next URL, there is no need to select the previous URL and delete it. So you have two steps of redundant work eliminated. Also, to download a YouTube video whose URL is say: http://www.youtube.com/watch?v=CXENO12nw28 (Hary Hill’s TV Burp), you can just paste the highlighted portion after keephd.com. So this would look like http://keephd.com/watch?v=CXENO12nw28, and the download options page would be displayed.
c) Best feature as yet, you can download videos which are not available in your region. You do get frustrated when you can’t view certain videos on YouTube due to area restrictions. Just download them via KeepHD and view them offline. And especially with the new TV Shows and Movies added on YouTube, KeepHD will surely become one of the favorite internet services available. Happy Downloading!
Related YouTube posts:
How To Download HD videos from YouTube
YouTube HD for Dummies : Search, Watch, Download
How to Watch and Download HQ videos on Youtube
