Custom Cell Formatting in Excel - Few Tips & Tricks

The other day I had to make an excel sheet for tracking all errors across one of the applications we are doing for our customer. The format was something like this,

We wanted to use a consistent message id format [4 digits: 0001, 0002, ... , 1000 etc.]. Now I do not want to type “0001″ [...]

Auto tagging your old blog posts

As you all may know I have recently moved my blog from blogger to wordpress. Since I have started blogging way back in 2004 most of my posts were untagged. I have used blogger labels ever since they were introduced, still almost 400 of my posts were untagged. I had two options,

Manually edit posts and [...]

Say NO to Default Charts Forever!

or Excel Charting Hacks # 2Roughly 35-40% of my working time in office is spent with powerpoint. As one of my mentors said, powerpoint gives neither the power nor the point. Apart from writing truck loads of bullet points and using auto shapes, I also work alot with numbers and charts. Obviously I resort to [...]

Excel Charting Hacks #1

The other day I had to make some graphs about revenues and profits of a set of companies. While doing it I wanted to use bar chart with bars of profit and revenue overlapping. But when I mentioned the revenue as 3000 and profit as 1500, the graph would show up something like this. As [...]

Howto: Excel Based Mutual Fund Portfolio Tracker

Instead of searching for the NAVs of all my funds at MyIRIS or MutualFundsIndia, I have developed a small excel sheet which will fetch the values for me and displays the current portfolio value at the click of a button. Here I am trying to share the “HOWTO” of the same.

Create an excel workbook [...]

Coimbatore Bus Mafia and Adventure Trip to Ooty

Heard of black tickets? Well you must have somany times. After Aamir Khan glorified selling black tickets big way in Rangeela, Chennai’s private bus operators couldnt help but pick up a trick or two of the trade.
So there I am, unaware of the UCBTM (Undergroud Coimbatore Bus Transportation Mafia) cancerously proliferating and thriving in Koyembedu’s [...]

Cameras: Most Popular vs. Most Clicked

A couple of days I guess S.Anand has given this link to Flickr’s Top Digital cameras. The funda is simple. The site tells you what are Top camera models in Flickr based on the EXIF data available using some Flickr API.
I was wondering if the same cameras are also most sought after by people. So [...]