Quotation information automation solution
Niu, Yimeng (2011)
Niu, Yimeng
Turun ammattikorkeakoulu
2011
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201105137808
https://urn.fi/URN:NBN:fi:amk-201105137808
Tiivistelmä
This thesis deals with a quotation information automation solution for Reka Kumi Oy. In Reka Kumi Oy, the information needed for generating quotation sheet is spread in several different sheets in an Excel template file. Every time quotation sheet is generated, the sales department needs to fill in those sheets in the template, then gather the information needed for the quotation from different sheets, copy them to another file and then print it as the quotation sheet. The company needed a more convenient way of generating quotation sheets and accessing quotation information.
The solution includes the following steps:
1. Making a 'Cover' page for the excel template. Collecting and calculating the information needed for generating quotation sheet into this 'Cover' page.
2. Creating a database to store the information of the 'Cover' page.
3. Using VBA code to transfer information from the Excel template to database.
4. Using C# to build a website to display and modify the quotation information.
This project is going to significantly reduce the time and labour consume by generating quotation sheet.
The solution includes the following steps:
1. Making a 'Cover' page for the excel template. Collecting and calculating the information needed for generating quotation sheet into this 'Cover' page.
2. Creating a database to store the information of the 'Cover' page.
3. Using VBA code to transfer information from the Excel template to database.
4. Using C# to build a website to display and modify the quotation information.
This project is going to significantly reduce the time and labour consume by generating quotation sheet.