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.
No comments:
Post a Comment