| procedure type | award criterion | tenders | avg days to prepare | avg total bids | single bidder tenders | avg price weight | avg award amount |
|---|---|---|---|---|---|---|---|
|
Mazie iepirkumi
|
Architectural, construction, engineering and inspection services
|
4
|
17.5
|
2.75
|
0
|
|
26362
|
|
Atklāts konkurss
|
Architectural, construction, engineering and inspection services
|
3
|
29
|
3.67
|
0
|
100
|
194702
|
|
Atklāts konkurss
|
Repair and maintenance services
|
3
|
15.3
|
2.33
|
1
|
|
61178
|
|
Mazie iepirkumi
|
IT services: consulting, software development, Internet and support
|
3
|
15.7
|
3.33
|
2
|
|
24182
|
|
Atklāts konkurss
|
Other community, social and personal services
|
2
|
20
|
2
|
0
|
|
102587
|
|
Mazie iepirkumi
|
Sewage-, refuse-, cleaning-, and environmental services
|
2
|
15
|
3
|
0
|
|
41999
|
|
Atklāts konkurss
|
Agricultural, forestry, horticultural, aquacultural and apicultural services
|
1
|
29
|
74
|
0
|
|
4.0e8
|
|
Atklāts konkurss
|
Business services: law, marketing, consulting, recruitment, printing and security
|
1
|
21
|
6
|
0
|
|
142999
|
|
Atklāts konkurss
|
Education and training services
|
1
|
16
|
4
|
0
|
|
26788
|
|
Atklāts konkurss
|
IT services: consulting, software development, Internet and support
|
1
|
29
|
1
|
1
|
|
41986
|
|
Atklāts konkurss
|
Supporting and auxiliary transport services; travel agencies services
|
1
|
14
|
5
|
0
|
|
746001
|
|
Atklāts konkurss
|
Transport services (excl. Waste transport)
|
1
|
33
|
3
|
0
|
|
2300826
|
|
Mazie iepirkumi
|
Education and training services
|
1
|
15
|
1
|
1
|
|
21978
|
|
Mazie iepirkumi
|
Furniture (incl. office furniture), furnishings, domestic appliances (excl. lighting) and cleaning products
|
1
|
17
|
1
|
1
|
|
2720
|
|
Mazie iepirkumi
|
Repair and maintenance services
|
1
|
15
|
2
|
0
|
|
28113
|
|
Mazie iepirkumi
|
Research and development services and related consultancy services
|
1
|
17
|
3
|
0
|
|
31990
|
|
Mazie iepirkumi
|
Transport equipment and auxiliary products to transportation
|
1
|
22
|
2
|
0
|
|
41983
|
|
|
|
1
|
|
|
0
|
|
|
SELECT
procedure_type,
award_criterion,
COUNT(*) AS tenders,
ROUND(AVG(try_cast(days_to_prepare AS DOUBLE)), 1) AS avg_days_to_prepare,
ROUND(AVG(try_cast(total_bids AS DOUBLE)), 2) AS avg_total_bids,
SUM(CASE WHEN lower(single_bidder) IN ('true','yes','1') OR try_cast(total_bids AS INTEGER)=1 THEN 1 ELSE 0 END) AS single_bidder_tenders,
ROUND(AVG(try_cast(price_weight AS DOUBLE)), 1) AS avg_price_weight,
ROUND(AVG(try_cast(award_amount AS DOUBLE)), 0) AS avg_award_amount
FROM xlsx_inventory_v3_4b022d33_1
GROUP BY procedure_type, award_criterion
ORDER BY tenders DESC, procedure_type, award_criterion