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

Thursday, December 6, 2012

Shopping Analytics Tool

Executive Summary:
I developed a program to assist my Sister in being a more effective shopper. With four children and many personal projects of her own, shopping is a constant source of pain in her budget. She requested a tool to help her keep better control over what is happening with her shopping. She asked me to create a project to help her keep track of how she is spending money on groceries and other small ticket items that are usually lumped together in budget programs. She had created a spreadsheet where she been putting all her purchase before, but it was not very efficient. From the structure she had developed I designed a program that serves as both a custom shopping list developer and a purchase analyzer.

Within the workbook there are two individual worksheets that serve as databases. The first worksheet serves as a comprehensive shopping list where she inputs all the details of every item she wants to purchase so she can know about how much she will spend on her shopping trips. The second worksheet serves as a database for her to input the details about each individual purchase from her shopping trips. A third worksheet serves as  a way to make pivot tables and pivot charts to analyze her data by month, by item, or by whatever else she wants.

1 comment:

  1. Quantum Binary Signals

    Get professional trading signals sent to your cell phone every day.

    Follow our signals today and make up to 270% daily.


Blog Archive