All articles with 'information' Tag

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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. […]

Today I ran a search in Del.icio.us for Infosys to get some information. What I saw in the results page is height of online anti-advertising. Generally you expect to see some ads related to the search tags. What you see here is on a different dimension altogether. When I clicked on the ad, it took […]

Dashboards are very common business monitoring tools, but creating them in excel with all the bells and whistles is not so easy. So here is a quick 1-2-3 on how to do it. Lets take a sample of 2 consecutive year sales figures for 7 regions. The colums have Region name, 2004-05, 2005-06 figures and […]

My love for excel doesnt stop at the application. I thought starting an excel specific blog to share my excel knowledge and discuss it with other enthusiasts is a good idea. So R1C1 was born a couple of days back. Today I posted an article on creating unique lists in Excel there. Do check it […]

I recently had to perform some analysis on a set of insurance companies in certain geography. After searching the net I found such list of companies operating in that continent. But the problem is, These companies are listed multiple times, one time for each of their geographical area of operation. I cannot count each company […]

>>> How come chennai doesnt have any English / Hindi FM channels? I think (correct me) all other metros have them. The only FM channel where you can hear something in Hindi is All India Radio’s FM Channel. >>> I am planning to buy a TV. My budget is 10k. The TV must be flat […]

All you hopeless and wifeless bachelors, get up and start looking. With PHD releasing “the unofficial bachelors guide to renting a house in Chennai” today, you will never again get a “no, we dont rent to criminals, politicians, drummers, dogs, carpenters and bachelors” reply from your prospective landlords. Where to look: Never call a housing […]

It is amazing how attention to smaller details can change the face of a service organization. There are several things that are done just the way they are since they were first done. Ok, thats a complex statement, for example, when you go to a website and it has some data/animation to load, all you […]

The above seen is a snapshot of the interactive ad for Indage Chateau Wine sellers. It took me to this page when I clicked on it. What went wrong with this ad? In above page you can see that there is no way in hell I can find out where all this Indage Chateau is […]