LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Speeding up Excel calculations JP Ronse Excel Worksheet Functions 11 March 1st 10 03:23 PM
Speeding up Excel 2003 yogart Excel Discussion (Misc queries) 3 August 30th 08 01:21 AM
i need help creating a stock control system Reza Excel Discussion (Misc queries) 1 February 5th 07 06:51 PM
creating a VERY BASIC invoice system hiker Excel Discussion (Misc queries) 2 May 31st 05 02:03 PM
Creating an invoice accounting system Sir Paul Excel Discussion (Misc queries) 1 January 12th 05 11:13 AM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"