ICT implementation report

1. chain of mountains of dataThis is my data, which offers all the polar autos and the details some them. The table is lap bulge in and take by the specifications of the cars and besides includes their expenses.2. Creating aim sheet3. client details of army sheetThis is the crystalize segment of my erect sheet, which argon the nodes details and the comp whatsoever logotype on the top right hand ramp of the page.4. Setting up combo boxesI concur created combo boxes so that customers tin sight choose what they bowl over c ar from my data of cars. Each combo-box category has 5 cars and an leisure space left encase the customer chooses not to choose a car from a current category. This holdion is associate to the cubicleular phone attached to it as individually car has a preset proceeds and the arrive is what makes the booth named cars change to what is selected in the combo box.5. SpinnersThe measurement is make using spinners. As the customer selects the type of car they prefer the equipment casualty mechanically pursues up in the cost stallular phone and they can change the quantity up to 6 cars for for each one which is highly unlikely. As the quantity government issue changes the scathe is multiplied by the go in the quantity cell.6. TotalsAfter these processes are done the total price is calculated by reproduceing the quantity chosen with the price of the car.7. LookupsColumn F uses a VLOOKUP in order to find what car has been chosen by the customer. This is done by linking it with Column C and this column shows a number which is the number of the car chosen on the combo-box and the number in the combo-box is the number which the cars are set as in the Data sheet. Hence displaying the selected car.There is also a VLOOKUPS done for the price which also kit and caboodle in the alike way.8. Tick box and IF narrative for Online DiscountThis is the online usher out trounce box which is linked to the cell contiguou s to it as you can hold above. As the box is ticked and un-ticked the cell next to it allow change to TRUE or FALSE this change me to create an IF literary argument ordinance that links to this cell in order to give discount or not.This IF statement is designed to give a 15% discount if B25 displays TRUE and if not then 0 will be shown.9. Delivery YES, zero(prenominal)buttons and IF statementAs shown in step 8 the Buttons are linked to the cell next to them. However this epoch the cell C28 will display either 1 or 2 which represent YES or NO. From this the IF statement in I24 can be done. If cell C28 is displaying 1 then a 6.99 charge will be put on the totals if number 2 is being displayed then cell I24 will come up as blank as in that location is no Delivery charge.10. Tick box and IF statement Claims Bonus DiscountThis is the Claims Bonus discount tick box which is linked to the cell next to it as you can see above. As the box is ticked and un-ticked the cell next to it will change to TRUE or FALSE this enable me to create an IF statement commandment that links to this cell in order to give discount or not.11. Sub-TotalThis is a sum grammatical construction which adds all the prices which are displayed in the selected columns.12. Working out bath%Simply input the percentage I treasured as my VAT into cell H26. In the cell next to it a multiplication formula is used to spawn the percentage by the sub-total which leaves the VAT in cell I26.13. Working out discount price.Simply input the percentage I cute to discount into cell H25. In the cell next to it a multiplication formula is used to multiply the percentage by the sub-total which leaves the discount in cell I25.14. Working out Claims bonus Discount priceSimply input the percentage I wanted to discount into cell H27. In the cell next to it a multiplication formula is used to multiply the percentage by the sub-total which leaves the discount in cell I27.15. Grand-TotalThis is a sum formula that is more than complex because it is subtracting discounts and adding different prices. This formula mechanically alters and changes consort to what is displayed in the cells above it.16. supplement MacrosThese macros are save to copy the details of the chosen car from each row and insert them on to the invoice sheet. They are also set to change the font survival of the fittest and insert a new row so that cars which are chosen do not fill in each other so that the substance abuser can select more then one car or extra.17. Go to government note & Go to allegeThese macros have been set up so that the user can toggle between the two sheets without any hassle. They are both very simple macros designed so that the user can change or add anything they want to their receipt.18. Print MacroThis has been created in order to present the user with a issue menu once it is selected or scar as soon as it is pressed, so that they can select their gull option or directly print the re ceipt.19. Logos, company details and pictureThis print dodging shows the company logo and the colour scheme which is twin(a) throughout the project and the picture in order to make the project more attractive. Part of the logo is the company details that are merged with it.20. Invoice number and date.Located below the logo, this is one of the essentials for the receipt, however there is no formula or schedule option used so the date has to be manually changed every day and the invoice number every time the invoice is being rescue and printed.21. Order detailsThese details are automatically pasted from the order sheet using the Add Macros. Therefore the titles are set in that order according to the data sheet and the font has been set to be changed as part of the processes of the add macro.22. node details on the invoice.These formulas simply display the instruction/details which the end-user would fill out at the top of the order sheet.23. Calculation formulas on invoiceThe pr int screen above shows all the formulas used I order to calculate the grand total. These are the same formulas used as the order sheet which I have explained in detail, however these have different cell references and copy the if statements from the order sheet so that the customers order is transferred correctly and so I do not have to repeat the process again.