Description:
This spreadsheet accesses the user’s credit card website, downloading balance information and all transactions ytd. The program then processes that transaction information and prompts the user to classify each transaction according to the user’s budget categories. The program generates and displays current spending amounts for each budget category and also ytd spending under each budget category.
Quick Stats:
475 lines of code
19 sub procedures
2 web queries
»24 hours of work
Limitations:
This spreadsheet will not work off of my hard drive. The first reason for this is that I have removed my user name and password information that the program uses to access my financial data. The second reason is that the web query that imports the financial data into the spreadsheet is dependent upon a specific file path on my machine.
No comments:
Post a Comment