Guide to Using Package X1 - Exporting Bidding Results to Excel

Tuesday, 09 April 2024 9:03 AM
Software Package X1 - Exporting Bidding Results to Excel - designed for organizations and individuals who need to extract contractor selection results into Excel for research, statistics, calculations, and finding the most frequently winning contractors... Let's take a look at the article below to learn how to use this software package!
Guide to Using Package X1 - Exporting Bidding Results to Excel
Guide to Using Package X1 - Exporting Bidding Results to Excel

Nhấn VÀO ĐÂY để chuyển bài viết sang bản tin tiếng Việt

Video: Guide to Using Package X1 - Exporting Bidding Results to Excel

You can register for the X1 software package - Exporting Bidding Results to Excel with 03 options:

  • X1QK - Exporting historical data
  • X1HT - Exporting current month's data
    • Monthly maintenance payment Yearly maintenance payment
    • Each option will have a different price.
Additionally, if you are currently using VIP1 or VIP2 packages, you can purchase the X1 package at a discounted price. For details, please visit: https://dauthau.asia/en/page/x1-package-features-price.html

1. Guide to exporting bidding results to Excel file

To use the feature of Exporting Bidding Results to Excel, please follow these steps:

Log in to your DauThau.info software account, go to the Bidding menu, select For Contractors, and choose Export bidding results to Excel (see Picture 1)

menu đấu thầu
Picture 1: Export bidding results to Excel

Basically, both X1QK and X1HT packages have similar features. The difference lies in:

  • X1QK can only export past data, with a time usage limit of 7 days from the registration date.
  • X1HT can only export data for the current month; data from past months cannot be exported.

Regarding the number of data exports, both X1QK and X1HT packages allow unlimited data exports within the software subscription period.

2. Types of Bid-Winning Data Export

Currently, DauThau.info supports exporting bid-winning data in 7 formats:

2.1. Exporting Bid-Winning Data by name of Bid Inviter

To export bid-winning data byname of Bid Inviter, simply select the name of the procuring entity (up to 3 entities). The system will export all results associated with the selected procuring entity.

Example:

  • Procuring Entity: Bệnh viện Hữu nghị Việt Tiệp
  • Approval Date: 02/27/2023 - 03/12/22023
  • Select Export "Goods name" for export
Result: This unit has published 26 bid packages with contractor selection results.
theo bên mời thầu full
Picture 2: Export Bidding Results by Inviting Party

Sample Data: Bid Results by Inviting Party

2.2. Exporting bidding results by month

To export bid-winning data by month, simply choose the desired month/year.

Example:

  • Month: 08/2023
  • Excel Template: Template 2 (Add list of failed bidders, tax code, phone number, email...)
  • Bid Packages in Province/City: Hanoi
  • Do not select Export "Goods name"

Result: This unit has published 2468 bid packages with contractor selection results.

theo tháng full
Picture 3: Export Bidding Results by Month

Sample Data: Bid Results by Month

2.3. Exporting Bid-Winning Data by Completion Date

To export bid-winning data by completion date, just enter the time period of completion.

Example:

  • Completion Period: 02/27/2023 – 03/12/22023
  • Excel Template: Template 1 (Normal template) 
  • Bid Packages in Province/City: Da Nang
  • Select Export "Goods name"

Result: This unit has published 2439 bid packages with contractor selection results.

theo ngày hoàn thành full
Picture 4: Exporting data by completion date

Sample Data: Bid Results by Completion Date

2.4. Exporting bidding results by keyword

To export bidding results by keyword, you input all the necessary content you want to export, specifically.

Content Description
Primary Keyword
(Required Input)
These are the keywords that will appear in the returned results.

Note: This is a mandatory field. You can enter up to 5 main keywords in this box, with each keyword separated by a comma ",".

If you enter 5 main keywords, the exported data will include bidding packages containing any of the 5 keywords entered. For example: If the main keywords are A, B, C, D, then the returned results will include bidding packages containing A, B, C, or D.
Additional Keywords
(Not required input)
Additional Keywords are mandatory keywords found within the bidding package. You can use up to 5 additional keywords, separated by commas (,).

Note: If you enter 5 additional keywords, the exported data will include bidding packages containing all 5 keywords entered. For example: If the additional keywords are A, B, C, D, then the returned results will include bidding packages containing all 4 keywords A, B, C, and D.
Excluded Keywords
(Not required input)
All information containing the entered keywords in this data field will not appear in the returned data export results. Use this field when the exported data results contain many irrelevant pieces of information. The maximum number of keywords is 5.
Format
(Not required input)
For Online or Live, leave it unchanged if you want to export data for both
Completion Time
(Not required input)
Enter the completion timeframe of the bidding package for which data export is required
Winning Bid Price From - Winning Bid Price To
(Not required input)
Enter the winning bid price threshold for which data export is required
Bidding Packages in Province/City
(Not required input)
Enter the province/city for which data export is required

For example: You export bid-winning data by keyword with the following information:

  • Main Keyword: Computer
  • Completion Date: 07/21/2023 – 07/28/2023
  • Excel Template: Template 1 (Normal template)
  • Do not select Export "Goods name"

Result: With the keyword "Computer", this unit has published 61 bid packages with contractor selection results.

theo từ khóa full
Picture 5: Export Bidding Results by Keyword

Sample Data: Bid Results by Keyword

2.5. Exporting bidding results by name of Winning/Awarded Bidder

To export bid-winning data by name of Winning/Awarded Bidder, select the name of the contractor (up to 3 contractors). The system will export all relevant results.

Example:

  • Contractor: Tổng công ty bảo hiểm PVI
  • Contractor Selection Completion Date: 07/21/2023 – 07/28/2023
  • Select Export "Goods name"

Result: This contractor won 24 bid packages within the specified time period.

tên nhà thầu trúng thầu full
Picture 6: Export Bidding Results by name of Winning/Awarded Bidder

Note: By default, the system only exports awarded goods specific to the selected contractor. To export all awarded goods within the packages, uncheck the relevant option.

Sample Data: Bid Results by name of Winning/Awarded Bidder

2.6. Exporting bidding results by name of Bid-Awarded Goods

To export bid-winning data by name of Bid-Awarded Goods, simply enter the goods name(s) to be searched (up to 5 keywords).

Example:

  • Goods Name: Computer, office equipment
  • Bid Packages in Province/City: Da Nang
  • Do not select Export "Goods name"

Result: 8 bid packages with the specified goods have been awarded.

theo tên hàng hóa full
Picture 7: Export Bidding Results by name of Bid-Awarded Goods

Note: By default, the system shows the full list of awarded goods. If you uncheck the option, it will only display goods that exactly match the keywords.

Sample Data: Bid Results by name of Bid-Awarded Goods

2.7. Exporting bidding results by name or ID of the ITB (Invitation to Bid)

This is a newly added feature suitable for users needing results from specific bid packages.

To export by ITB numbers, input a comma-separated list of the relevant codes.

Example:

  • ITB Numbers: IB2300383804-00, IB2400030123-00, IB2400030121-00
  • Select Export "Goods name"

Result: Data will be returned once processing is complete and ready for download.

theo danh sách tbmt full
Picture 8: Export Bidding Results by name or ID of the ITB (Invitation to Bid)

Sample Data: Bid Results by ITB Numbers

You can access the full sample Excel data export here:
https://drive.google.com/drive/folders/15wWMMnEU8y3RGHqja-VJmBU56TpRrGuD?usp=drive_link

Note: Software features and Excel file formats may change over time and may not exactly match the provided sample data.

The above guide explains how to use the X1 software package – Export Bidding Results to Excel. We hope these instructions help you utilize the X1 package effectively and efficiently.

If you have any questions during use, feel free to contact DauThau.info for timely support!

Newer articles

Older articles

You did not use the site, Click here to remain logged. Timeout: 60 second