Suljettu

MICROSOFT VISUAL BASIC

HI I NEED HELP ASAP FOR MY COURSEWORK AT BRUNEL UNIVERSITY I HAVE TO MAKE A LOAN CALCULATOR USING THE VBA FUNCTION IN EXCEL. I NEED TO CREATE A USER FORM OF A LOAN CALCULATOR WITH A COUPLE OF FEATURES E.G A PAYMENT OF 2 LOANS, I NEED HELP ASAP AS THE DEADLINE IS FRIDAY!! PLEASE CONTACTME ON THANK YOU.

Create one working piece of software using VBA in Excel. You will convert your software into an Excel add- in (add-ins will be covered in the lectures). As is characteristic of add-ins, all output should be shown on an Excel worksheet rather than a userform; you are not expected to format the output, whether numerical or graphical. In addition, all numerical results outputted should be values, not formula. That is, none of the cells should contain an excel formula; all calculations should be done within VBA and only the result should be outputted to the worksheet. Finally, your software should have no more than two userforms.

Predefined and fixed options restrict the functionality and versatility of software. You want to give the user as much choice as they require. To do so, your software should have at least one aspect which is versatile. For example, for the repayment of a loan, let the user choose how they repay their loan, such as specify the number of repayments, the minimum payment or a fixed payment amount. Another example would be to offer repayment of 2 or more loans simultaneously, rather than just one loan.

You are expected to apply the GUI design theory discussed in lectures as well as the coding techniques. This software is simple enough that you should not need to take any code from the internet. You will be expected to explain your code during the oral presentation and if I have any doubts about its authenticity I will meet with your group at a set time after the presentation to discuss the code further.

During week 20, you will have an opportunity to receive feedback from other users (your peers in MA3696) on the usability of your software and the GUI design. You will also be providing feedback on your peers’ work. Your work will not be marked or assessed – you will only receive constructive comments on the strengths of your software as well as the aspects which could be improved. So, even if you are not finished with it, you will benefit from taking part.

?

End user documentation

Clearly and concisely describe how to use the software (no more than 2 sides of A4). This should include key definitions to any words the user may not know. If needed, use screen shots to create diagrams. As discussed in the GUI design theory, ideally the user shouldn’t need any instructions, the software should be straight forward to use. Thus, this documentation should be a reference for the user, but not a necessity.

Individual report

“Individual” means separately, by yourself, not with anyone else. You will work together to create the software, but you will work on your own to write this short report. Please do not exceed 3 sides of A4.

The report should give justification for the GUI design implemented, including a specific and explicit description of all GUI principles you have applied, with examples. You should also include details of how you applied the user feedback you receive. If you do not participate in the peer feedback, please explain why you chose to opt out. Finally, describe any extensions or improvements that you would have made if you had the knowledge needed to program it in VBA. That is, is there anything you wanted to add or change (in order to improve your software), but were unable to because you didn’t have the knowledge of programming needed to do it?

Taidot: C-ohjelmointi, Excel, graafinen suunnittelu, Microsoft, verkkosivujen suunnittelu

Näytä lisää: website design worksheet, visual programming website, visual basic programming software, visual basic programming code, visual basic in programming, visual basic for website, versatile it, vba programming using excel, vba programming in excel, vba excel programming, software design principles, programming theory, programming techniques, programming in visual basic, programming in vba, programming in excel vba, programming in excel 2013, programming definitions, principles of programming, principles of design definitions, piece of software for short, peer programming, order form format in excel, opt programming, numerical programming

About the Employer:
( 0 reviews ) United Kingdom

Projektin tunnus: #4262516

11 freelanceria on tarjonnut keskimäärin 142 £ tähän työhön

maysam

Quality work

300 £ GBP 3 päivässä
(28 arvostelua)
5.9
samitXI

Please check your inbox. Thanks

250 £ GBP 2 päivässä
(40 arvostelua)
5.5
vbexcel

Excel/VBA expert - ten years of experience.

100 £ GBP 3 päivässä
(27 arvostelua)
5.3
jal540

I have done many custom Excel VBA projects and have excellent ratings.

200 £ GBP 7 päivässä
(20 arvostelua)
4.7
satsin7

Hi I'm an experienced excel user and VBA programmer and I think I already have what you need. Pls see PMB.

35 £ GBP 2 päivässä
(12 arvostelua)
4.1
techlegends786

We are Excel/VBA experts. We can provide you with the solution.

250 £ GBP 1 päivässä
(6 arvostelua)
4.3
vikashgadia

we have more than 13 years of experience in excel vba programming

80 £ GBP 1 päivässä
(13 arvostelua)
3.5
farr4u

Hi, Excel VBA expert here, I have got the application almost ready as per you requirements, plz chk PM for DEMO. Regards.

35 £ GBP 1 päivässä
(7 arvostelua)
3.0
vedranvivoda

Hello! I have already developed exactly what you need - loan payment calculator which can calculate independently two loans with different loan properties and make payment tables with annual sums or without annual s Lisää

80 £ GBP 1 päivässä
(1 arvostelu)
1.6
SurfrazAhmad

I am Expert in VBA and I can do this Coursework for you.

130 £ GBP 3 päivässä
(1 arvostelu)
0.6
tozoku

Greetings, I'm very experienced in VBA, but also i know how to write my own code, in other words you may not get best and prettiest possible solution, but it will be unique.

100 £ GBP 2 päivässä
(0 arvostelua)
0.0