A
ali.alauoubiy
Hi Everyone..
I am Java Developer and have no idea how VBA works.. I have the
following excercise need to be done asap part of my MBA... Would anyone
can help and get me started or write it fully for me and I can pay some
money for that..
Regards
p.s. If someone is going to write it, I want it to be well committed so
I can go over the code and understand myself so I can do it next time..
Regards
Ali
You are to design, build and test a spreadsheet for the task described
below:
Task:
An Independent Financial Advisor, wishes to have an Excel spreadsheet
which can be down-loaded from their website which will provide advice
as to the most competitive home loans available. The system should be
able to cope with at least 3 types of loans
1. First-time buyers.
2. re-mortgaging an existing property
3. moving home
The system should be able to cope with mortgages for individuals and
couples and give appropriate warnings if no suitable mortgage is
available.
In considering your design you should note:
While most lenders offer loans of up to 3.5 times highest income + 2
times second income, the multiples can vary between lenders (and also
may depend on the profession of the mortgage).
Interest rates may vary depending on the percentage of the value of the
property to be mortgaged.
The data on currently available mortgages will need to be updated by
linking to a suitable web page or from an external database. The final
format for either a database or webpage to do this has not been decided
so you should suggest an appropriate one, and provide example data that
demonstrates that you spreadsheet will be able to be updates
appropriately.
Other factors such as separate listings of fixed, discount and variable
rate mortgages may be included.
You should hand in:
1. A detailed specification of the system including house style and
example customer data and lender data.
2. your system on disk
3. a test schedule
4. some detailed test results which should demonstrate the system at
least works correctly on the example data (from 1 above)
Your system should demonstrate the following:
1. at least one fully working User Form
2. use of cell protection, data validation and conditional formatting
3. clear documentation of VBA code
4. clear and uncluttered layout
5. appropriate error messages
6. Ability to update the mortgage data from at least one of a database
or web page.
7. Good use of Excels Charts and built-in formula.
Marks will be rewarded for:
1) A spreadsheet system (70%)
· appropriate use of excel formula, data validation, protection
· some simple use of VBA
· at least one User form for data input
· connection to Web-page and/or database
2) Documentation (15%)
· a specification of the system
· a house style
· example data (in database or web page)
3) Testing (15%)
· A test schedule
· Detailed documentation of some test that illustrate the features of
the spreadsheet produced
I am Java Developer and have no idea how VBA works.. I have the
following excercise need to be done asap part of my MBA... Would anyone
can help and get me started or write it fully for me and I can pay some
money for that..
Regards
p.s. If someone is going to write it, I want it to be well committed so
I can go over the code and understand myself so I can do it next time..
Regards
Ali
You are to design, build and test a spreadsheet for the task described
below:
Task:
An Independent Financial Advisor, wishes to have an Excel spreadsheet
which can be down-loaded from their website which will provide advice
as to the most competitive home loans available. The system should be
able to cope with at least 3 types of loans
1. First-time buyers.
2. re-mortgaging an existing property
3. moving home
The system should be able to cope with mortgages for individuals and
couples and give appropriate warnings if no suitable mortgage is
available.
In considering your design you should note:
While most lenders offer loans of up to 3.5 times highest income + 2
times second income, the multiples can vary between lenders (and also
may depend on the profession of the mortgage).
Interest rates may vary depending on the percentage of the value of the
property to be mortgaged.
The data on currently available mortgages will need to be updated by
linking to a suitable web page or from an external database. The final
format for either a database or webpage to do this has not been decided
so you should suggest an appropriate one, and provide example data that
demonstrates that you spreadsheet will be able to be updates
appropriately.
Other factors such as separate listings of fixed, discount and variable
rate mortgages may be included.
You should hand in:
1. A detailed specification of the system including house style and
example customer data and lender data.
2. your system on disk
3. a test schedule
4. some detailed test results which should demonstrate the system at
least works correctly on the example data (from 1 above)
Your system should demonstrate the following:
1. at least one fully working User Form
2. use of cell protection, data validation and conditional formatting
3. clear documentation of VBA code
4. clear and uncluttered layout
5. appropriate error messages
6. Ability to update the mortgage data from at least one of a database
or web page.
7. Good use of Excels Charts and built-in formula.
Marks will be rewarded for:
1) A spreadsheet system (70%)
· appropriate use of excel formula, data validation, protection
· some simple use of VBA
· at least one User form for data input
· connection to Web-page and/or database
2) Documentation (15%)
· a specification of the system
· a house style
· example data (in database or web page)
3) Testing (15%)
· A test schedule
· Detailed documentation of some test that illustrate the features of
the spreadsheet produced