Cell Phone Bill Calculator

Executive Summary

Three of my siblings and I share a family cell phone plan. Each month I end up logging into T-Mobile’s website and calculating out what each person owes. This wouldn’t be too bad except that each line has different feature adds and sometimes someone will end up with extra usage charges for texting too much or calling out of the country or something.

To make this monthly process easier I wrote a VBA program that will login to the T-Mobile site and download the most current bill. It then calculates what each individual user owes. Once it has calculated out the bill it gives you the ability to send out an email to each of the users informing them of what they owe for the month.

http://files.gove.net/shares/files/10f/jwd29/Joe_Dredge_Cell_Phone_Bill.xlsm

http://files.gove.net/shares/files/10f/jwd29/Joe_Dredge_Cell_Phone_Bill_Calculator.pdf