Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speeding up Excel calculations | Excel Worksheet Functions | |||
Speeding up Excel 2003 | Excel Discussion (Misc queries) | |||
i need help creating a stock control system | Excel Discussion (Misc queries) | |||
creating a VERY BASIC invoice system | Excel Discussion (Misc queries) | |||
Creating an invoice accounting system | Excel Discussion (Misc queries) |