Excel Beginner-need help creating speeding fines system with butto

[Snake]

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 magistrate’s 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.

 

[Bernard Liengme]

Snake,
You need to post this in the Excel.Programming group
Boy, I'm glad I left the UK! Fines of £50 for every 1 mph over the limit
So you are 10 mph over the limit and the fine is £500+£112 (that $930)
Bernard

 

[Joe User]

You need to post this in the Excel.Programming group

I doubt that very much, and we do not want to encourage people to
"multipost" questions in multiple NGs, IMHO.

I would be surprised if any of the frequent contributors monitor
m.s.excel.programming, and not m.s.excel.worksheet.functions, m.s.excel.misc
and even m.s.excel and m.s.excel.newusers. I confess that I do not look at
the other m.s.excel.* NGs. But the MVPs might.

In any case, I suspect this "question" goes far beyond the kind of effort
that anyone is likely to do for free. Besides, it is obvious an assignment
of some sort. If the OP is having trouble getting started, he/she should
speak with the course instructor or TA or get a tutor.


----- original message -----

Snake,
You need to post this in the Excel.Programming group
Boy, I'm glad I left the UK! Fines of £50 for every 1 mph over the limit
So you are 10 mph over the limit and the fine is £500+£112 (that $930)
Bernard

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 magistrate’s 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.

 

[Fred Smith]

You really have two problems. Setting up the right formulas, and programming
the input. If you're having trouble with the first, I would concentrate on
that, and leave the programming for later (a lot later). Most people use
only formulas and never bother with programming.

If you need help with the formulas, you do it as follows:
-- enter the speed limit and offender's speed in, say, a2 and b2
-- in c2, the excess speed, calculated as =b2-a2
-- in d2, enter the number of previous offenses,
-- in e2, the fine: =c2*50+d2*75+112.50

Regards,
Fred