Executive Summary
The Problem
It was about 2 years ago that I created a budgeting spreadsheet within Excel. I tracked the many costs that both my wife and I had, expenses from education to entertainment. This helped to achieve a growth in savings, even amidst a tight budget. The ability to track the money that came in and out of our house was something interesting to me. After all, I am studying accounting, and this is a simple application of such a study. The problem arose when I wanted a better spreadsheet, but was not completely able to design one with the knowledge that I had.
The Investigation
One day I was talking to a fellow classmate of mine about budgeting. He mentioned a budgeting software that he used called “You need a budget” or “YNAB.” He said that while it cost $60 to purchase, it did allow a 1 week free installation to test-drive the software. I downloaded YNAB and quickly found ways that it was much better than the budgeting tool I was currently using. The problem was I, nor my wife, did not want to pay the $60 to purchase a budgeting software. It was the following week that I entered MBA 614 and we were to create something within Excel, using VBA, for a business use. I thought this would be the perfect time to create what I desired.
The Solution
My product is called iSYB, short for “I Stole Your Budget.” With the week that I had YNAB, I learned the in’s and out’s and designed my own product within Excel. It has two spreadsheets, (1) Budget Detail, and (2) Charts. Both are used to help the person budgeting to see the details of his/her income and expenses. It allows both detailed and summary views of the data. Ultimately, iSYB is a budgeting solution for all those that can’t fork out big money to help manage their cash flow.
Links
iSYB Budget
iSYB Budget Write-Up
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
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(150)
-
▼
April
(71)
- Using Excel as a Music Player
- Experimental Design and Conjoint Analysis
- ITunes Playlist Comparer
- Comparable Company Automation Project
- Text file manipulation with VBA
- Bryce Newbold's VBA Project
- Calculating and Graphing the Efficient Frontier f...
- Gift Card Reconciliation
- Personal Budget Spreadsheet
- BLS PPI Database Query to Analyse Year-to-Year Cha...
- ReportFileExecutive SummaryThe purpose of my VBA p...
- Home Salon Management System
- New York City Apartment Complaint ListingExecutive...
- Personal Finance Tool
- Sales Agent Scorecard Generation for Integra Telecom
- The Matchmaker
- Numerical Heat Transfer Optimizations in VBA
- Web Table Converter
- CRM Data Entry Segmenation - Chris Brasher
- Report System for The Pendulum Court
- ScheduAll Report Automation - Karl Rosengren - Win...
- Farr Appraising Market Conditions Report
- Portfolio Tracker
- Luke's Automated SWA Boarder
- Sync Department Data
- A First Step Towards User-Defined Financial Ratios
- Business Charge Entry / Invoice Manager
- Awesome Adobe Automation
- Textbook List Price Aggregator by Adam Cuppett
- Money Allocator
- Minchin Timesheet v1.0.25059
- A more accurate bid
- Kingdom of Loathing Market Dashboard
- CALLING ALL CATTLE! AUTOMATING SWA’S ON-LINE RESE...
- Business Broker Searches
- Cowtail Biomechanics Analysis
- Crime in Cities data compilation
- Sudoku Solver
- Report Generator for a Legacy System
- Ward Directory Creator
- Fraud Analyzer
- Valuation of a company. Calculation of NPV and Pri...
- Daily Sales and Inventory Control for Costco Retai...
- Customer Relationship Management & Analysis Progra...
- JJ Webb - FDIC data generation
- Generating iTunes Related-Artist Playlists
- ZIltch!
- Byron Mackay - Mariner Add-ons
- Option Pricing
- Potential Project Portfolio by Erik Wenzel
- Appointment Reminders Program - Micah Lorenc
- US Army APFT score calculator and automated Counse...
- Martech Computers Invoice Scraper
- iSYB Budget - Dustin Skinner (Winter 2010)
- Tory Betts Final Project
- U.S. Treasury TARP Report Generator - Ryan Wood - ...
- Copy Report Automation - Shauna Call, Winter 2010
- Easycache - a time saving tool for Geocaching.com ...
- Inventory Optimizer - Andrea Cordani, Winter 2010
- Get a Room! - Mark Tuttle - Winter 2010
- MyData info parser - Jeff Baxter - Winter 2010
- Whisk Recipe Organizer - Brandon Anderson - Winter...
- http://files.gove.net/shares/files/10w/kdl22/VBA_...
- Day Planner - Howard Kuan - Winter 2010
- Carman Violin Studio - Jesse Carman - Winter 2010
- MyComfort Product Tracker and Serial Number Genera...
- Financial Markets Update Service - Jason Merrill, ...
- MemoSend - Danny Patterson, Winter 2010
- Cinema Data Aggregator - Adam Solter, Winter 2010
- AutoRegister - John Wilson - Winter 2010
- VDC Requests - Kevin Brinkerhoff - Winter 2010
-
▼
April
(71)
No comments:
Post a Comment