Method for automatically generating bidding document by utilizing big dataTechnical Field
The invention relates to a method for automatically generating bidding documents by utilizing big data, belonging to the technical field of office automation.
Background
Project bidding is a long term job that each company needs to complete. Conventionally, making a bid document is a physical effort with a long period and high repeatability. The method involves a lot of people, is difficult to unify standards and is difficult to modify. Once in error, a significant loss is incurred to the company. The method solves the series of problems, meets the compliance requirement of the business owner bidding structure, improves the manufacturing efficiency of the bidding and the quality of the finished product of the bidding, and becomes an important work for daily management of enterprises.
Although the basic data is almost the same, the conventional bidding documents are produced, however, owners of different platforms have different requirements. The format and the template are different. Therefore, it is difficult to create a bid file and establish a uniform format and data. Most of bidding manufacturers manually paste bidding document data of last bidding into new documents in order to save production time. The following treatments have great disadvantages:
1. high repetitive workload, time and labor waste
The bid file production is a work with low technical content and time and labor waste, and the repeated work of copying and pasting is easy to feel tired, so that the bid file production is most prominent when written by personnel and performance files.
Taking the south net bidding document staff resume table as an example, the filling of one person data takes about 7 minutes, the sticking of a practice qualification, a job title and the like takes 5 minutes (the time of collecting the finishing certification data is not included), the making of 1 person data takes 12 minutes, the calculation of 30 person data is carried out, and one light person resume table takes 360 minutes (6 hours). Adding information on performance, qualification, intellectual property, etc. requires at least 20 hours (3 days of work).
2. Personnel and performance can not be updated along with actual performance running conditions of company
In order to save time, most of the working processes of the bidding manufacturers are to paste the data of the previous bidding, and the requirements of each project on the profession and performance of the staff are different, so that the bidding documents written by simple copy-paste cannot be obtained with high score.
Meanwhile, operators do not have comprehensive knowledge of the personnel resource allocation situation of the whole company, most of bidding documents are applied with the same personnel data to participate in bidding, the personnel resource reality of the company cannot be comprehensively displayed, a plurality of personnel with practice qualification and advanced title cannot appear in the project personnel allocation list, and the improvement of the personal practice qualification, the title and the academic cannot be reflected in the bidding documents in time. The witness of the particular job cannot be placed on the appropriate post in the bidding document. Staffing is not optimal, and scoring scores of the staffing structure items are directly affected.
Moreover, the staff information of the dictionary staff is not deleted in time, and new staff information is added, so that staff information which is already at work elsewhere appears in the bidding document, and even competitor staff can appear in extreme cases. This is extremely prone to waste labels.
3. Expiration of documents such as qualification certificates, financial statements and the like is ignored
The traditional bidding document production is usually mechanical operation, historical data is copied into new documents, and the documents with aging like qualification certificates are easy to ignore after expiration, so that huge burden is brought to the post verification and auditing work. Once the key qualification certificate is out of date, the business scoring score is influenced slightly, the unlabeled label is directly caused by the heavy price, and huge losses are brought to the company.
4. Checking and correcting work abnormality is heavy
The bidding documents are comprehensive displays of the comprehensive strength of the company. Therefore, in order to ensure the accuracy of the bidding documents, the document proofreading work before bidding is also extremely important. And each time of proofreading work needs to read the bidding documents comprehensively, the bidding documents are over 500 pages, and the difficulty of repeated proofreading is obvious.
5. The later-period modification work is tedious and easy to make mistakes
Due to linkage characteristics of bidding document performance, personnel, organizations and the like, once errors are found and the bidding document needs to be modified, the bidding document needs to be repeatedly read, all linkage data are modified, and once the bidding document is missed, inconsistent front and rear data or contradiction in meaning can be caused, the bid evaluation score is influenced, and even the bid is disqualified. The workload of the post-modification work is often several times that of the pre-writing work.
Disclosure of Invention
The invention aims to solve the technical problems that: a method for automatically generating bid documents using big data is provided to overcome the shortcomings of the prior art.
The technical scheme of the invention is as follows: a method of automatically generating a bid document using big data, the method comprising:
the method comprises the steps of establishing a structural database, wherein the structural database comprises a personnel information base and a project information base, the personnel information base is used for storing personnel information, the personnel information base is connected with a personnel platform database, the project information base is used for storing project information, the project information base is connected with a project management database, and hyperlink items for storing catalogues are arranged in the structural database;
establishing an unstructured database, wherein the unstructured data is used for storing unstructured data, and a storage directory of the unstructured data is uniformly established into a directory structure according to project information and personnel information in the structured database and named;
determining a demand list, primarily screening in a structural database according to bidding demands, deriving the demand list, and filling the demand list;
outputting a standard table of bidding document production data, importing the demand list into an ACCESS database for processing, and outputting the standard table of bidding document production data by the ACCESS database;
automatically generating a bidding file to manufacture a standard form by utilizing the macro function of EXCEL, and exporting a report form in a standard format;
and (3) making a bidding document template according to different requirements of bidding documents, and extracting data in a standard form by using a WORD link EXCEL standard form data source to complete automatic writing of WORD documents.
Further, the unstructured data in the sub-table is stored by:
the database automatically reads information such as project numbers and the like, establishes a standard archive folder by utilizing batch files, establishes an unstructured data warehouse according to a unified format, and automatically creates hyperlink access links by the database.
Further, the unstructured data warehouse stores contracts, receipts, payment materials, invoice scan, project process documents.
Further, the method for uniformly establishing the directory structure and naming the storage directory of the unstructured data according to the project information and the personnel information in the structure database comprises the following steps: after the non-structural database is established, the internal functions and the expression generator of the ACCESS database are utilized to automatically calculate and judge the path of non-structural data storage according to the related structural data, and the path is stored in the structural database.
Further, the macro function of EXCEL is utilized to automatically generate a standard form for making a bidding document, and the exporting of the report in the standard format specifically includes:
establishing a standard filling template by utilizing the EXCEL macro function;
opening a standard table derived from the database by VB statement operation;
the VB command is utilized to automatically select needed data from the database export table, the original data table is read and copied, and the data is pasted into a standard filling template;
preprocessing the copied data by utilizing VB commands or SQL query sentences;
prefabricating, positioning and filling the processed format data into a standard form by utilizing a VB command;
automatically exporting a standard form by using a VB command and storing the standard form to a specified path;
and (3) automatically filling the document text and picture information according to a standard format by using a WORD link standard data source.
The beneficial effects of the invention are as follows: in contrast to the prior art, the method has the advantages that,
1) According to the invention, by constructing the structural database and the non-structural database and connecting the human resource platform database and the engineering project management database, repeated labor such as manual searching, copying and pasting is greatly reduced, and the time cost for manufacturing the bidding documents is reduced;
2) The information in the database is updated in real time, so that errors caused by manually updating the data are reduced. Particularly, due to the expiration of qualification certificates and other problems, the database can be provided with a prompt, so that the loss caused by neglect is avoided;
3) The method has the advantages that the proper personnel information can be queried in real time according to different project requirements, so that personnel configuration is more optimized, and bidding success rate is improved;
4) By utilizing the macro function of EXCEL, standard tables can be automatically generated for bidding documents, and reports can be exported in a standard format. The data in the standard table is extracted through the WORD link EXCEL standard table data source to complete automatic writing of the WORD document, so that the working efficiency is further improved;
5) As the data are uniformly stored in the database, the modification and correction work becomes more convenient, and the errors caused by modifying the data are greatly reduced. All data is stored in the database, and the security and stability of the data are higher than those of the traditional file form.
Drawings
FIG. 1 is a flow chart of embodiment 1 of the present invention;
FIG. 2 is a flowchart showing the process of making a tagbook according to embodiment 1 of the present invention;
FIG. 3 is a graph of time consumption versus raw average time consumption for the present invention.
Detailed Description
In order to better understand the above technical solutions, the following detailed description will refer to the accompanying drawings and specific embodiments.
Implementation example 1: referring to fig. 1-2, the present embodiment employs a method for automatically generating a bid document using big data, the method comprising:
in order to scientifically manage the structural data, standard database information materials such as a personnel information base, a project information base and the like are respectively established. And the unstructured data files such as JPG are stored in a background library. Unified calling is performed through the ACCESS database platform. And the stored data is finely classified by utilizing the strong data management capability of the database, and is read as required when in use. The data classification and analysis work is completed by the database, the unstructured database is stored outside, the database is positioned inside, and the data storage standardization and the reading accuracy are ensured. The standard table is used for uniquely storing personnel information, job title, practice qualification and other information of the company, so that accurate and complete data are achieved, and uniqueness is ensured. The database management structure type basic data is used for interfacing with a corporate human resource platform database, an engineering project management database and a qualification management database, and is updated periodically (monthly or half year) to ensure the accuracy and the integrity of information. The update of the bottom data does not affect the upper application, and the data information is synchronous, complete and unified without changing each writing.
The bidding document related data is various unstructured information such as personnel professional qualification, title, contract data, invoice scanning piece, project acceptance document and the like besides the structural information of tables and charts. The formats of the documents are PDF, WORD, JPG, ZIP and the like, and the documents are completely impossible to completely enter into a common structural database, firstly, the structural database has no management capability on the complex unstructured data, and secondly, a large number of document data are entered, so that the database is bulky and huge, and the ACCESS has no capability to manage the huge database. If the distributed database is used for management, the large materials are small, and the capability requirement on a database manager is very high; and the operation interface of the distributed database needs to be developed by third-party software, and different problems are often encountered in terms of interface compatibility.
Thus unstructured data is managed using an ACCESS out-of-library link. And creating an unstructured data warehouse outside, uniformly storing unstructured data such as documents, pictures and the like outside the database, classifying and storing, uniformly establishing a directory structure by the database according to information such as project numbers, personnel names and the like, and naming. The hyperlink item is added in the structural database, and when the non-structural data item is input, the database automatically creates the hyperlink according to the information such as the item name, the number and the like, so that the non-structural data information can be finely managed one by one, and the non-structural data information can be called in the database at any time according to the need.
The database automatically reads information such as project numbers, personnel names and the like, establishes a standard archive folder by utilizing batch files, establishes an unstructured data warehouse according to a unified format, and automatically establishes a hyperlink access link by the database so as to achieve the purpose of accessing the unstructured data by one key. And (5) establishing a document warehouse outside the library, and storing personnel names, contract data, invoice scanning pieces and project acceptance documents in a classified set. Therefore, the method not only can realize the standard storage of the project data, but also can call the project data in time, and can call the project data at any time in the process of browsing the project basic information no matter what the document data storage format is. The technical barriers to data access between structured and unstructured data are completely eliminated.
Determining a demand list, primarily screening in a structural database according to bidding demands, deriving the demand list, and filling the demand list;
outputting a standard table of bidding document production data, importing the demand list into an ACCESS database for processing, and outputting the standard table of bidding document production data by the ACCESS database;
automatically generating a bidding file to manufacture a standard form by utilizing the macro function of EXCEL, and exporting a report form in a standard format;
and (3) making a bidding document template according to different requirements of bidding documents, and extracting data in a standard form by using a WORD link EXCEL standard form data source to complete automatic writing of WORD documents.
Referring to FIG. 3, the invention improves the efficiency of making the bidding documents, the accuracy of the bidding document data reaches 100%, the workload and pressure of each link of making, checking, auditing and later modification are greatly reduced, the workload is reduced by more than 70%, 8 persons are allocated to each company to complete the bidding work calculation, more than 5 persons can be saved for each branch company, the production efficiency is greatly improved, the economic benefit is obvious, and the practicability and the economy are better; the source of the root data is consistent, so that the uniqueness and the accuracy of the data can be absolutely ensured, and the file checking workload is greatly reduced by more than 90%.
Further, the unstructured data in the sub-table is stored by: the database automatically reads information such as project numbers and the like, establishes a standard archive folder by utilizing batch files, establishes an unstructured data warehouse according to a unified format, and automatically creates hyperlink access links by the database.
The information such as project numbers is automatically read through the database, and the standard archive folder is established by utilizing batch files, so that manual operation can be reduced, and the working efficiency is improved. And the unstructured data warehouse is built according to a unified format, so that the consistency and the regularity of the data can be ensured, and the management and the use of the data are facilitated. The hyperlink access link is automatically created through the database, so that a user can conveniently access and search the required unstructured data, and the working efficiency is improved. All unstructured data are stored in a database, and compared with the traditional file form, the data are higher in safety and stability.
Further, the unstructured data warehouse stores contracts, receipts, payment materials, invoice scan, project process documents.
Further, the method for uniformly establishing the directory structure and naming the storage directory of the unstructured data according to the project information and the personnel information in the structure database comprises the following steps: after the non-structural database is established, the internal functions and the expression generator of the ACCESS database are utilized to automatically calculate and judge the path of non-structural data storage according to the related structural data, and the path is stored in the structural database.
By utilizing the internal functions of the ACCESS database and the expression generator, the path for storing the unstructured data can be automatically calculated and judged according to the related structured data, so that the working efficiency is improved, and errors possibly caused by manual operation are reduced. The directory structure is built according to the project information and personnel information in the structure database, so that the efficiency of data management can be improved, and the subsequent data retrieval and use are facilitated. The automatic calculation and the discrimination of the storage path enable the storage of the unstructured data to be more flexible, and the storage path can be automatically adjusted according to the change of project information and personnel information, so that the real-time property of the data is maintained.
Further, the macro function of EXCEL is utilized to automatically generate a standard form for making a bidding document, and the exporting of the report in the standard format specifically includes:
establishing a standard filling template by utilizing the EXCEL macro function;
opening a standard table derived from the database by VB statement operation;
the VB command is utilized to automatically select needed data from the database export table, the original data table is read and copied, and the data is pasted into a standard filling template;
preprocessing the copied data by utilizing VB commands or SQL query sentences;
prefabricating, positioning and filling the processed format data into a standard form by utilizing a VB command;
and automatically exporting the standard table and storing the standard table to a specified path by utilizing the VB command.
And (3) automatically filling the document text and picture information according to a standard format by using a WORD link standard data source.
Preprocessing the data in the data according to various requirements, and establishing various query mechanisms so as to unify and uniquely identify the data sources. And building a related application platform to realize standardized management of structural data.
When in actual use, the database is used for preprocessing data, and the database is subjected to preliminary screening according to the actual qualification, title, intellectual property, qualification certificate and company rewarding requirement, so as to derive an EXCEL standard table. And (5) carrying out secondary screening by the business and technicians according to the requirements, and determining a requirement list.
The demand list is imported into the database for processing, and the database outputs the bidding document to make the data standard table.
Fully exerts the macro programmable advantage of EXCEL. And performing secondary development by utilizing VB sentences, automatically generating bidding files to manufacture standard tables by utilizing the macro function of EXCEL after reading database data, and exporting reports in a standard format to ensure that the data accuracy is 100%.
Meanwhile, the standard format is filled by utilizing the macro function, the compatibility problem of database structure data and EXCEL data is solved, the information structures such as the data format, decimal place number, date display format, character length and the like are highly unified, the problem of inconsistent front and back formats when a bidding document is manually manufactured is completely avoided, condition format judgment is added, key data is subjected to key correction, and major errors affecting a major office are prevented.
The standard table is only required to be checked by a label maker, the error is modified, and part of rationality is adjusted. The standard table is used as the basis for automatic generation of bidding documents.
The EXCEL standard table data sources are linked using WORD. And (3) according to different requirements of the bidding documents, making bidding document templates, and extracting data processed by the database to complete automatic writing of WORD documents. The task of writing the items of personnel, performance and patents one by one is not needed.
Thirty people only need 20 seconds for the profile derivation. The method has the advantages that the writing efficiency is improved, the document error rate is reduced, the document format is completely unified, the picture size is unified, and the data is comprehensive, complete and accurate.
The foregoing is a further detailed description of the invention in connection with the preferred embodiments, and it is not intended that the invention be limited to the specific embodiments described. It will be apparent to those skilled in the art that several simple deductions or substitutions may be made without departing from the spirit of the invention, and these should be considered to be within the scope of the invention.