Google Spreadsheet provides many formulas to make our life easy. One such formula is matrix multiply or MMULT. This formula provides great possibilities to otherwise lengthy drag and drop method of implementation. To start with I assume that you have a prior knowledge of matrices and matrix multiplication. If not try going through some brief [...]

While writing formulas in Google spreadsheets, doing drag and drop of formulas, ever wondered how to get rid or cleanup the cells which have a value as 0 or have errors ? There is a formula provided in Google spreadsheets ” IFERROR“. Basically this formula if encounters an error will replace the cell contents with [...]

Today I had to provide an excel spreadsheet to some users with transaction information in it. Since they were not aware of the System, I wanted to highlight similar rows so that its easier for them to understand. Now I had around 30K rows for example and there were 5000 entities. This meant that for [...]

A good percentage of people use Skype for making International calls. I used to do that long time back too (in 2006-7). But then I came across a cheaper and better alternative i.e. SIP or VOIP calling! This is in my opinion the cheapest and better way to make calls. I have used ActionVoip, Freecall [...]

Mobile phones being smarter than ever before, ever wondered how some websites redirect you to the mobile version to make it easier to navigate. I use my Nokia E61i a lot for web browsing, while I am traveling. So it was obvious that I had to try this interesting feature Now back to the topic. [...]

Its not always possible to purchase costly software which we use day to day on our PC’s. Reason I am saying so is there are so many free to use and opensource alternatives, that there is no such need to purchase the copyrighted ones In this post I will list down the ones which I [...]

I am a Citizen of India and have been in the Netherlands for quite sometime now. I got married this summer and as it happens with every other expat, had to start the paperwork of my wife. Let me tell you upfront, it seems to be an easy task, but beware! this process takes time. [...]

How many times have you seen that a chkdisk operation runs and all of a sudden some of your most important folders with important files in it, got converted to a 32Kb file. I had such an experience where our marriage photographs contained in a folder were all gone! This was just unacceptable. So I [...]

As with everyone, I had tough time playing .mt2s files generated by my Sony handycam. Below solution helped me to play these files without problem. First install the latest version of VLC ( ref here Then install few restricted packages on Ubuntu ( ref here ) Now open VLC player and make few setting changes [...]

Last night started installing Vista 32bit on my Dell Inspiron 1525 and got the error “Windows is unable to find a system volume that meets its criteria for installation.”. It was quite strange, as installing windows it not rocket science I have Ubuntu installed on other partitions (/boot, /opt, / and swap ). Initially when [...]