The one and only

We are ready to represent the best custom paper writing assistance that can cope with any task like The one and only even at the eleventh hour. The matter is that we posses the greatest base of expert writers. Our staff of freelance writers includes approximately 300 experienced writers are at your disposal all year round. They are striving to provide the best ever services to the most desperate students that have already lost the hope for academic success. We offer the range of the most widely required, however, not recommended for college use papers. It is advisable to use our examples like The one and only in learning at public-education level. Get prepared and be smart with our best essay samples cheap and fast! Get in touch and we will write excellent custom coursework or essay especially for you.

1 Evaluation

1.1 Effectiveness of the Solution

My final system meets all of the User requirements that were made.

• On-screen display of all the cars- I did this by putting all the car names and prices onto one worksheet.




• On-screen display of all the extras- I did this by putting all the extras and their prices onto another worksheet.

• On-screen display of car colours- I also done this as the one above but you cant actually see the colours worksheet when you’re using the system.

• On-screen display of quote- I have made the quote sheet so the user will have to type in customer details and have drag down the drop down boxes and select the chosen item. I have used seven drop down boxes. Also the prices of the selected items appear onto the quote and add up together with added Vat to the correct total amount. The customer can clearly see what will be happening on the screen

• Print out of quote- the print out is different from the quote sheet, only in the way it looks because it has no drop down boxes etc. It has been set out differently to the quote sheet. It shows the same information as the quote sheet and shows all the calculating stages for example price before vat and price after vat.

• Macros- I have used macros to do the short cuts that the user required. I have made two separate macros that will make the user go onto the cars and extras worksheet and then assigned them to two different buttons on the quote sheet. I also made a macro to clear the areas where the user had to fill in or drag down on the drop down boxes so it will look like a new quote, for this macro I assigned a button on the quote sheet. I also made a macro so that the final quote could be printed with out going onto the final quote sheet and then pressing print. The user only has to click on the print quote macro, which is on the quote sheet, which will print out a copy of the final quote.

I have made the system very easy to use and user friendly, the user will be able to use it without any training and without even looking at the user guide.

1. Limitations of the Solution

Below is a list of the various limitations of the system

• Once you have chosen an item from the drop down boxes for example an alloy wheel, only the name appears at the moment but it would be better if an image of the item would also appear on the screen. If I could do the system again I would make images of the item chosen appear on the screen to show the customer how it looks, and therefore if a mistake was ever made by choosing the wrong item you will be able to see the image and then change it to the chosen one.

• Once you have made a quote for the customer and had it printed for the customer there is no way to save the quote made, so if the customer comes back a few days later and doesn’t bring there printed copy, the company has no details of the quote made and therefore has to be made again. If I could do the system again I would make the facility to save the quotes made and give the quote individual reference numbers so you don’t get all the quotes muddled up.

• Also after you have inputted the customer details, they only get transferred onto the final quote (printed version), they don’t get saved so I would next time connect the spreadsheet to a database if there is a way, so if I wanted to contact a customer I could go onto the database and type in there name and it would come up with all there details.

• At the moment there is no front end to the system but if I could make it again I would make a front end and on that front end include somewhere to input the users name and their password. So that no one except for an employee could enter the system.

• At the moment I have password protected the cars, extras and final quote worksheets so that no one can edit or delete anything from those sheets without knowing the password. But it would be better instead of saying this “the cell or chart you are trying to change is protected and therefore read-only” it could ask the user to type in the password.

• It would make the system much better if the main menu bar at the top couldn’t be accessed or even wasn’t there, so the user can only use what is on the screen. Also by doing this, if someone quite advanced with using Microsoft excel will not be able to access the macros and disable them even if its by mistake.

• The validation checks on the post code aren’t that accurate as information can still be entered as 14567 or asdfghj, so therefore the postcode would be invalid, but at the moment the check only checks the length of the data in the cell.

• It would make the system better if I could have validated the cells D6 to D10 on the quote sheet for presence so that if the user had forgotten to input data into that cell, then a message would appear saying please input data. But couldn’t find a way to do it.

• At the moment the user can delete the titles on the quote by accident because I couldn’t find a way to protect them cells with titles in.

• The final quote (printed version) looks good but would have looked professional if it had a quote reference number on it, so if I had to make it again I would include one.

If I was going to do this again, I would try to include these in or at least try to get closer to doing these.



Mind that the sample papers like The one and only presented are to be used for review only. In order to warn you and eliminate any plagiarism writing intentions, it is highly recommended not to use the essays in class. In cases you experience difficulties with essay writing in class and for in class use, order original papers with our expert writers. Cheap custom papers can be written from scratch for each customer that entrusts his or her academic success to our writing team. Order your unique assignment from the best custom writing services cheap and fast!