The database should contain multiple tables, and each table records the information of the judges with corresponding bid evaluation qualifications (including expert number, expert name, expert ID number, qualification level and contact information) according to the category and scale of the bidding project.
The database should have backup function and powerful password protection function to prevent others from deleting or adding data!
The second step is to establish a database directory table, which is convenient to find the corresponding data.
The third step is to write a program to randomly select judges with corresponding qualifications.
The plan needs to be completed through the following small steps:
1, the program needs to input the following four aspects of information through human-computer interaction:
(1), the category of the project subject to tender, (2), the scale of the project subject to tender, (3), the minimum qualification level of the bid evaluation experts, and (4), the number of candidates for bid evaluation experts to be extracted as determined by the bidding specifications.
2. According to the above conditions (①-③), the program takes out the number of all qualified experts from the corresponding table in the database to form a list, and at the same time excludes the number of experts who conflict with their task time, which can be used as the list of primary elections, and counts their total number ZS.
Step 3, compare the number of judges required by XS with the actual number of qualified judges in ZS, if it exceeds, report that the number of experts is insufficient and exit the program; Otherwise, continue to the next step,
Step 4, generate a random integer r between 1 and ZS, extract the r number from the obtained expert number list and record it in the extraction table. At the same time, delete this number from the temporary expert list to avoid repeated extraction. The new total number ZS is reduced by 1, and the extracted expert number YS is increased by 1.
Step 5, compare the number of extracted experts YS with the total number of experts XS to be extracted. If not, repeat step 4 and draw 1 experts until the number is full.
Step 6, according to all the extracted expert numbers, extract their corresponding detailed information (but not including contact information for the time being) from the database as a tentative list and submit it to relevant departments for review. According to the final examination and approval results, the contact information is supplemented from the database to form an official document, which is distributed to relevant units and departments, and a special judge card for bidding projects is made to inform experts to bring their ID cards to get the cards within a time limit!
When the number of declared experts in the scheme is insufficient, on the one hand, we can consider delaying the bid evaluation date slightly, so that those experts who are qualified to serve as judges but are not selected due to task conflicts can enter the extraction stage; On the other hand, if the number of experts in some categories in the internal expert database is really insufficient, we should hire experts in time, but do a good job in qualification screening!