Excel Beginner-need help creating speeding fines system with butto
Hi, I'm learning excel on my own and would love someone's help with this
problem that I've got. I wouldn't mind if its a couple of helpful remarks or
a full solution. I thank you very much either way.
The problem is:
You have been hired to work for a local magistrates court. The clerk of the
court needs a spreadsheet that will calculate speeding fines that need to be
paid by offenders. The worksheet must contain the following information
Legal speed limit
Speed offender was traveling
Number of miles per hour the offender was traveling above the speeding limit
Number of previous speeding offenses
Total cost of the fine
Some of these values will be calculated, others will be entered by the user.
Speeding fines are calculated using the following assumptions:-
£50 fine for each mile per hour above the legal speed limit
Court costs of £112.50 [this is a fixed amount]
Additional charges [£75 for each previous offense]
Add a command button labeled New Case. The button should clear the worksheet
of all data in order for a new case to be entered, then presents a series of
Input Boxes. Each input box should ask the user to enter the following:-
Name of the offender
Legal speed limit in the area
Speed the offender was traveling
Number of previous speeding offenses.
Would love ur comments thanks.
|