October 2009

What do you use IMDb for?

by Sujoy on October 19, 2009

IMDb just turned 19. Yes, Techcrunch’s article reveals that the IMDb is actually older than the web browser. There’s a long ass explanation to that, which we’ll not be discussing here. But certainly, in these 19 years of web existence, IMDb is one of the most visited websites and also synonymous to the Wikipedia for movie lovers like me. We do have other ‘superior’ movie rating systems such as Metacritic or Rottentomatoes, but IMDb totally belongs to the viewer’s rating and is not limited to critics. And hence, IMDb movie ratings are often considered to be closer to the taste of the audience.
The obvious utility of IMDb is that it is the largest compilation of movies and is not limited to just Hollywood or for that matter Bollywood. Every movie lover I know goes to IMDb first to check out if a movie is worth watching or not, or even to just have a look at initial reactions of audiences on a movie. So, for world cinema lovers, this is the one stop to gather information on movies. But other than the obvious use of viewing a movie’s ratings, what are the other ways that you use IMDb for? I have listed a couple of them below.

[Continue Reading]

{ 0 comments }

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]

{ 3 comments }

How Blogging adds to your CV / Resume

by Sujoy on October 14, 2009

This post should not be considered as just a mere rant. This actually works for job interviews and in my experience of the few that I have attended, it has certainly got the positive attention of the recruiter. So, how does it work? By definition, blogging can be at different levels – personal – which is focussed on personal likes/dislikes etc and hence, is already driven by some niche. The other end of blogging is – professional blogging – which is primarily done by people who earn their bread and butter by means of blogging. Such are writers who majorly write about specific areas – such as  Technology, Blogging, Making Money Online, Entertainment, Television, Pop culture etc. They are the next generation of press reporting, and arguably pose a threat to the traditional news reporting. Such is the impact that News reporters and the likes have resorted to Blogging online. So, coming back to the question is how does Blogging add value to one’s resume?

[Continue Reading]

{ 2 comments }

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]

{ 3 comments }