Results 1 to 4 of 4
Like Tree3Likes
  • 2 Post By kyt
  • 1 Post By srkmagnus
  1. Thread Author  Thread Author    #1  
    kyt
    kyt is offline
    kyt's Avatar

    Posts
    14 Posts

    Post Carrier Comparison Sheet

    Our contract with Sprint is coming to an end July 31, 2013 and I'm tired of how much we pay for how poor our Sprint service is.
    My wife and I both have an Epic 4G Touch (WiMAX) which we never got service for in Louisville, KY, and Sprint has now abandoned.
    I'm not going to stick around in hopes of them ever starting up LTE here.
    I've started shopping around, and I really want to switch to T-Mobile.
    A co-worker and I sit on the 4th floor of a concrete and steel office building right next to North facing windows. My Sprint 3G bandwidth (Sprint has no "4G" here) is 539kbps/434kbps to a server in town. His T-Mobile 3G bandwidth (test phone did not have 4G) 4299kbps/2302kbps!

    My wife can get a ~20% through her office for Verizon, and my mother, who is on our plan, gets 50% from AT&T.
    Trying to compare different carrier sites can get confusing, so I built a Google spreadsheet with a lot of numbers and some guessing.
    I've spent roughly a week working on it and I've found it to be exceptionally helpful.
    So helpful, I want to share it with all of you.



    I've removed the discounts from the formulas, and put a sales tax field so you can change the sales tax percentage should yours not be 6%.
    If you're familiar with how spreadsheets work, you can easily add lines (rows) or service add-ons (columns).
    Actual communications taxes and fees vary greatly, so I adjusted the amount to be 14% since that's the number that made the Sprint page match what my account is (not exactly I have a 25% discount on mine, but it would match sans the discount [-ish]).
    I don't have a tax law degree nor the time to research exact numbers for every place. This will still give you a rough estimate, and err on the high side hopefully. If you know exactly what yours are, feel free to change it to exactly that.

    The sheet is shared publicly, anyone can view without having to login.
    If you want to change some stuff you'll need to copy it to your Drive (File > Make a copy...) or download it (File > Download as...).
    All sheets except for the Comparison sheet have 3 smartphones and a flip phone.
    All you need to do is change the prices to what you get on the carriers' websites.
    Watch for cells where I left personalized notes

    The Comparison sheet aggregates the data from the other sheets so you can view them all together.
    I discovered, from my own needs, T-Mobile would save me around $1000/year.

    Mods, please move if this would better serve someplace else.

    Feedback is greatly appreciated!
    Thanked by 4:
    RumoredNow and jdbii like this.
  2. #2  
    srkmagnus's Avatar

    Posts
    6,751 Posts
    Global Posts
    6,754 Global Posts
    ROM
    Stock 4.4 (KitKat)

    Default Re: Carrier Comparison Sheet

    Good work, thanks for sharing. You definitely want to go with a carrier that offers the coverage you need within your hometown or area you spend most of your time in. T-Mobile is definitely a good choice. You might also want to consider one of the prepaid plans that use T-Mobile towers, such as Net10, and get a device off contract. The prepaid plans are great now and very competitive. The big carriers are starting to see this and have begun offering prepaid plans.
    jdbii likes this.
  3. #3  

    Default Re: Carrier Comparison Sheet

    Quote Originally Posted by kyt View Post
    Our contract with Sprint is coming to an end July 31, 2013 and I'm tired of how much we pay for how poor our Sprint service is.
    My wife and I both have an Epic 4G Touch (WiMAX) which we never got service for in Louisville, KY, and Sprint has now abandoned.
    I'm not going to stick around in hopes of them ever starting up LTE here.
    I've started shopping around, and I really want to switch to T-Mobile.
    A co-worker and I sit on the 4th floor of a concrete and steel office building right next to North facing windows. My Sprint 3G bandwidth (Sprint has no "4G" here) is 539kbps/434kbps to a server in town. His T-Mobile 3G bandwidth (test phone did not have 4G) 4299kbps/2302kbps!

    My wife can get a ~20% through her office for Verizon, and my mother, who is on our plan, gets 50% from AT&T.
    Trying to compare different carrier sites can get confusing, so I built a Google spreadsheet with a lot of numbers and some guessing.
    I've spent roughly a week working on it and I've found it to be exceptionally helpful.
    So helpful, I want to share it with all of you.



    I've removed the discounts from the formulas, and put a sales tax field so you can change the sales tax percentage should yours not be 6%.
    If you're familiar with how spreadsheets work, you can easily add lines (rows) or service add-ons (columns).
    Actual communications taxes and fees vary greatly, so I adjusted the amount to be 14% since that's the number that made the Sprint page match what my account is (not exactly I have a 25% discount on mine, but it would match sans the discount [-ish]).
    I don't have a tax law degree nor the time to research exact numbers for every place. This will still give you a rough estimate, and err on the high side hopefully. If you know exactly what yours are, feel free to change it to exactly that.

    The sheet is shared publicly, anyone can view without having to login.
    If you want to change some stuff you'll need to copy it to your Drive (File > Make a copy...) or download it (File > Download as...).
    All sheets except for the Comparison sheet have 3 smartphones and a flip phone.
    All you need to do is change the prices to what you get on the carriers' websites.
    Watch for cells where I left personalized notes

    The Comparison sheet aggregates the data from the other sheets so you can view them all together.
    I discovered, from my own needs, T-Mobile would save me around $1000/year.

    Mods, please move if this would better serve someplace else.

    Feedback is greatly appreciated!
    You just want a good price vs performance. I would avoid AT&T, they are very stingy with the data. I would buy an unlocked phone online and get a sim from a tmo mvno like GoSmart(45 for unl text/talk and 5gig data).

    Sent from my LG-VM696 using Tapatalk 2
  4. #4  
    mmtowns's Avatar

    Posts
    109 Posts
    Global Posts
    112 Global Posts

    Default Re: Carrier Comparison Sheet

    I found this "" wiki to be helpful in the USA and when thinking about traveling to other countries.

Similar Threads

  1. Prepaid carrier comparison
    By mmtowns in forum Other US Carriers
    Replies: 16
    Last Post: 11-26-2012, 01:03 PM
  2. US Carriers and release date speculation...
    By Jeremy in forum HTC Desire
    Replies: 54
    Last Post: 07-06-2010, 10:22 AM
  3. Comparison sheet of ALL the Android phones?
    By sniffs in forum The Android Central Lounge
    Replies: 0
    Last Post: 05-07-2010, 12:55 PM
  4. Nexus / iPhone 3GS photo comparisons
    By rvinny in forum Google / HTC Nexus One
    Replies: 44
    Last Post: 02-15-2010, 01:07 PM
  5. carrier that doubles as wallet?
    By bsmith1051 in forum HTC Hero
    Replies: 2
    Last Post: 01-22-2010, 03:26 PM

Posting Permissions

B