View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Snake Snake is offline
external usenet poster
 
Posts: 5
Default 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.