These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 11, 2012

Cell Phone Bill Calculator

Alex, Lucas, Julia, and I have a “family” plan with Verizon wireless. Each month Lucas, the designated “bill reconciler,” is in charge of summarizing the month’s cell phone bill and allocating the appropriate charges to each member. The allocations are complex, and the inputs and nature of charges often changes from month to month.

Lucas is consistently late with his duties. We always get a last-minute text, 5 days after the bill is due (the day before late charges begin accruing), telling us to “hurry and logon to the Verizon site and pay $XX.XX before 5:00.”

My VBA code logs onto the Verizon site, downloads all appropriate information, calculates and allocates the bill, reconciles it to the total, and then sends a text message to each person informing them of their charge, along with relevant usage data. The text also includes the due date of the bill.

No comments:

Post a Comment

Blog Archive