Finding Trends in Your Phone Bills
Your phone usage has patterns. If you knew what those patterns are, you could come to an arrangement with the telephone company that will save you a lot of money.
But “how on earth can I unveil those patterns?” you ask. Well good news, Excel can crack your calling habits wide open.
Lets take a look at your phone bill in its original pattern:
Sample Phone Bill
There seems to be no patterns here.
But wait, let’s convert it into Excel. I do this by using Cogniview’s PDF to XLS converter.
Here is the result:
OK, that looks better. Still no patterns it seems, but you do have that calming blue grid. Now let’s work some magic.
First let’s split the Destination into state and city:
And the time into the hours of the day:
Now let’s make some graphs and see if there is a specific state I call to:
Now the patterns show with full force.
Apparently I should find some sort of deal with cheap calls to NY and also possibly Nevada.
Let’s see what our analysis of call hours will come up with:
It’s glaringly obvious that I should look for a discount on calls between 9AM and 11AM and possibly right after lunch.
If you get your phone bills as PDF files like I do, use PDF2XL to convert them into Excel. In fact, even if you still get your bills on paper, you can scan them and convert them to Excel using the same software!
Armed with the power of Excel and a little conversion help I was able to uncover hidden treasures inside my phone bill and I am sure you will be able to do this as well.
The phone bill analysis can be found here.