Ecuador R022, R023, R024, R028, R058 collusion indicators

open-contracting / cardinal-rs

Measure red flags and procurement indicators using OCDS data

https://cardinal.readthedocs.io

MIT License

9 stars 3 forks source link

Ecuador R022, R023, R024, R028, R058 collusion indicators #89

Open Camilamila opened 11 months ago

Camilamila commented 11 months ago

[x] For Ecuador these indicators will only be calculated for Reverse auctions (procurementMethodDetails='Subasta Inversa Electrónica'). We verified with Sercop and they agreed the indicators can be calculated for this method.
- Solution: Set (and use) price_comparison_procurement_methods
- [ ] R022 "Great disparity in offer prices"
- [ ] R023 Fixed-multiple bid prices
- [x] R024 Price close to winning bid
- [x] R028 Identical bid prices
All reverse auctions have 1 round but the same bidder can submit multiple bids per round. For the indicators we can consider the last bid.
- Solution: Don't compare a tenderer's bid to its other bids.
- [ ] R022
- [ ] R023
- [x] R024 (see comment below)
- [x] R028 (see comment below)
[x] Exclude R058, since after 2022 they automatically eliminate bids that are lower than 50% of the reference price.

jpmckinney commented 11 months ago

Ok, so I'll change R058 to "no" in the spreadsheet.

jpmckinney commented 11 months ago

For R028 (Different tenderers submitted bids with the same price.) do we need to only consider the last bid? It seems fine to consider all bids by the same tenderer.

jpmckinney commented 11 months ago

For R024 (Price close to winning bid), I've now fixed a bug, so that we treat the lowest bid by the winner as the winning bid. We don't need to exclude any bids from non-winners, since each is individually compared to the winning bid to determine the second-lowest (and we already don't compare the winner's other bids to itself).

jpmckinney commented 11 months ago

For Ecuador these indicators will only be calculated for Reverse auctions

Although R036 is not calculated for Ecuador, I've made the new configuration (price_comparison_procurement_methods) apply to R036 (in addition to the others).

jpmckinney commented 5 months ago

All reverse auctions have 1 round but the same bidder can submit multiple bids per round. For the indicators we can consider the last bid.

@Camilamila I don't see the problem with considering all bids, not just the last?

Camilamila commented 5 months ago

For R024, if we already don't compare the winner's other bids to itself, as you mention then it wouldn't be a problem. Similar to R028

jpmckinney commented 5 months ago

And similar for R022 and R023 (i.e. as long as we don't compare a tenderer's own bids to each other) ?

Camilamila commented 4 months ago

Yes!