Mobile phone usage analysis

I mentioned earlier that I am using the Tmobile "myFaves" plan. This plan allows me unlimited calling to five numbers and 300 minutes to all other numbers. Now, there are two, maybe three, people that I talk to regularly so they instantly went into my "faves". For the remaining slots available, I want to make sure that I am getting the numbers in there that I talk to frequently. Since I'm allowed to make changes once per month, I have been going through a quick spreadsheet analysis to determine which numbers I am using the most and ensure they are in my "faves".

To do this analysis, I first downloaded my call records from Tmobile's website. They offer the ability to download in a CSV format making it easy to import into your favorite spreadsheet.

I, then, created a pivot table on my call data. (If your favorite spreadsheet cannot do pivot tables, then get the free OpenOffice application.) To create the pivot table, I simply highlight the data, drag the "minutes" column into the main data space, drag the "numbers" column into the left-hand row space, and click "done".

Once the pivot table has aggregated all my minutes by number, I then highlighted that dataset, sort descending by minutes, and I now have a nice list of my most frequently used numbers!

Using the top five of these numbers, I go back to Tmobile's website (which has timed out my login. Nice.) and "manage" my "faves". This has been a very useful activity taking about 10 minutes once per month. This activity really saved me last month when a friend that is on my list of five changed their phone number. I updated it in my phone's contact list, but did not remember to update my "faves" until just now when I looked at the data. It would be nice if Tmobile would aggregate the data in this way, but I suspect it is not in their interest for me to have a finely tuned "fave" list.