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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Beginner-need help creating speeding fines system with butto
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 "Snake" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Beginner-need help creating speeding fines system with butto
"Bernard Liengme" wrote:
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 ----- "Bernard Liengme" wrote in 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 "Snake" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Beginner-need help creating speeding fines system with butto
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 "Snake" wrote in message ... 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. |
Reply |
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) |