Cell phone bill analyisis

[goonie79]

I am hoping to see if it is possible to create a spreadsheet to compare cell phone costs on a monthly basis. The info I would like to input is minutes used, text used, overage minutes, overage texts, and even data packages. In the end I would like to create a graph that shows a rage of plans based on this criteria that shows where I stand and where the other plans stand. It would show yearly cost along side with yearly savings if there is any, and even compare cost of other carriers. I know this is a long shot, but it would be a great tool to compare my carrier along side with other carriers. Thanks for any info.

 

[goonie79]

I am hoping to see if it is possible to create a spreadsheet to compare cell phone costs on a monthly basis. The info I would like to input is minutes used, text used, overage minutes, overage texts, and even data packages. In the end I would like to create a graph that shows a rage of plans based on this criteria that shows where I stand and where the other plans stand. It would show yearly cost along side with yearly savings if there is any, and even compare cost of other carriers. I know this is a long shot, but it would be a great tool to compare my carrier along side with other carriers. Thanks for any info.

Sorry I forgot to add that my family has four lines. Is it still possible to incorporate data from each phone number to distinguish the variables of each phone number? Thanks again.

 

[detlion1643]

This might help get you started in the right direction...

1) get plans from verizon site, sprint site, at&t site, etc.
2) put plan info into worksheet, or each company on their own worksheet
3) split data gathered from each into each's own plans(minutes, text, prices, etc.)
4) compare all of company's data and pull out best plans for each step
5) choose which plan you have
6) calculate your costs again the costs of the best plans for each step by company


Hope this helps!