Cell phone bill analyisis

goonie79

New Member
Joined
Dec 2, 2009
Messages
2
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.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

goonie79

New Member
Joined
Dec 2, 2009
Messages
2
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

Board Regular
Joined
Nov 25, 2009
Messages
164
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,127,210
Messages
5,623,405
Members
415,972
Latest member
SY1234

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top