vba代写-B351F
时间:2021-10-29
1
BIA B351F Assignment
Due dates: November 5, 2021
Weighting: 25% of final course score
Instructions
This is an individual assignment on Excel VBA programming.

You are to develop an Excel VBA program for taxi drivers to keep track of their income. Your program
allows users to input information of a ride via a UserForm with data validation, which contains suitable
controls for entering the date, the total distance (km), the total waiting time (minutes), the number of
baggage, whether it is a telephone booking, and other extra charges ($). The above information will be
appended to the worksheet with a sequential ID in the first column. The taxi fare is then calculated
according to the following rules:

First 2 kilometres or any part thereof $24
Every subsequent 200 metres or every minute waiting time $1.7
After reaching $83.5,
Every subsequent 200 metres or every minute waiting time $1.2
Every piece of baggage $6
Hiring arranged through telephone booking $5
Other extra charges ($)

In addition, your program should enable users to perform the following actions via a UserForm:
● search a ride record by ID and show the information in a dialogue box
● change a ride’s information (except ID)

Based on the ride records, the program can generate the following statistics in a separated worksheet:
● the total number of rides
● the total income
● the average cost per ride
● a table showing the number of rides, the income, the average cost per ride in each month

What to hand in:
1. The Excel VBA program (XSLM format)
2. A test plan in Word format

Note that your program should be well documented with comprehensive variable names and comments for
the programming logic. You also need to prepare a test plan that specifies all possible scenarios you have
considered. For example, how your program behaves if there are no data in the Excel file, or more than a
year of data, etc. For each specified scenario, either make up a test case (Excel data record) to verify the
correctness of your program or simply assume such a case will never happen. However, your assumptions
should be reasonable, such as:
1. All existing Excel data records have been validated and thus contain no error.
2. The ride data are in chronological order. (from the oldest to the latest)
3. The ride data period is within year 2021.

Your assignment will be graded according to the following criteria: correctness, programming style
(organization, comments, indentation, variable names, clarity and efficiency), data validation, user interface
and test plan. Submit all required files to OLE by the due date at 5pm. (Please hand in your work early as the
OLE is often busy around the assignment deadline.) Note that 10% of the marks awarded to the assignment
will be deducted for every calendar day overdue.



学霸联盟





















































学霸联盟


essay、essay代写