| A | |
|---|---|
1 | OC4IDS Indicators |
2 | |
3 | This spreadsheet contains a list of indicators than can be calculated using OC4IDS data. |
4 | The Indicators sheet lists the indicators. It has the following columns: - A unique identifier for the indicator. - A TRUE/FALSE field indicating whether the indicator is deprecated. - Why the indicator was deprecated. - The primary use case the indicator relates to, from the following list: Market Opportunity, Public Integrity, Service Delivery, Internal Efficiency, Value for Money. - A description for the indicator. - Notes about the indicator. |
5 | |
6 | The Methods sheet lists the methods for calculating the indicators, i.e. groups of OC4IDS fields needed to calculate each indicator. One indicator can have many methods. The Methods sheet has the following columns: - A unique identifier for the group of fields that can be used to calculate the indicator. - The identifier for the indicator each group of fields relates to, from the Indicators sheet. - The group of fields that can be used to calculate the indicator. - Notes about the calculation method. |
7 | |
8 | For help with this resource, contact the OC4IDS Helpdesk: data@open-contracting.org |
9 | |
10 | Prior work: The indicators in this spreadsheet are based on a list of use cases collated by the Open Contracting Partnership's infrastructure team. |
| A | D | F | G | |
|---|---|---|---|---|
1 | id | use_case | description | notes |
2 | I1 | Value for money | Proportion of projects with final value > budget | Results can be split into buckets, e.g. < 5%, 5-10%, 10-20%, 30%+ etc. |
3 | I2 | Value for money | Proportion of contracts with a final value which is greater than the original value | Results can be split into buckets, e.g. < 5%, 5-10%, 10-20%, 30%+ etc. |
4 | I3 | Value for money | Proportion of contracts with a modified value which is greater than the original value | Results can be split into buckets, e.g. < 5%, 5-10%, 10-20%, 30%+ etc. |
5 | I4 | Internal efficiency | Proportion of projects with actual completion date > planned completion date | Results can be split into buckets, e.g. <1 month, 1-3 months, 3-6 months, 6-12 months, 12 months+ etc. |
6 | I5 | Internal efficiency | Proportion of contracts with a modified end date which is greater than the original end date | Results can be split into buckets, e.g. <1 month, 1-3 months, 3-6 months, 6-12 months, 12 months+ etc. |
7 | I6 | Market opportunity | Suppliers ranked by number of contract awards | |
8 | I7 | Market opportunity | Suppliers ranked by value of contract awards | |
9 | I8 | Market opportunity | Rotation of winning bidders by geographic area, time or other factors (Unusual Bidding Patterns, Abnormal Joint Bid Patterns) | See NF057 in Red Flags to OCDS mapping |
10 | I9 | Market opportunity | Number of contracting processes by procurement method | |
11 | I10 | Market opportunity | Value of tenders by procurement method | |
12 | I11 | Market opportunity | Value of contract awards by procurement method | |
13 | I12 | Value for money | Difference between project budget and final value | |
14 | I13 | Value for money | Difference between contract cost estimate and final value | |
15 | I14 | Value for money | Difference between budgets for projects with the same sector, type and locality | |
16 | I15 | Value for money | Difference between budgets for projects with the same sector, type and region | |
17 | I16 | Market opportunity | Funders ranked by number of projects | |
18 | I17 | Market opportunity | Funders ranked by value of project budget contributions | |
19 | I18 | Market opportunity | Proportion of project budget contributions from international funders | |
20 | I19 | Market opportunity | Proportion of project budget contributions from public funders | |
21 | I20 | Market opportunity | Proportion of project budget contributions from private funders | |
22 | I21 | Market opportunity | Number of projects with an international supplier or suppliers | |
23 | I22 | Market opportunity | Value of projects with an international supplier or suppliers | |
24 | I23 | Market opportunity | Number of contracts with an international supplier or suppliers | |
25 | I24 | Market opportunity | Value of contracts with an international supplier or suppliers | |
26 | I25 | Value for money | Difference between project budget and final value and reasons | |
28 | I27 | Value for money | Difference between modified and original contract value and reasons | |
29 | I28 | Public integrity | Proportion of projects with a feasibility study | |
30 | I29 | Public integrity | Proportion of projects with an environmental impact assessment | |
31 | I30 | Public integrity | Proportion of projects with a social impact assessment | |
32 | I31 | Public integrity | Difference between construction start date and publication date of feasibility study | |
33 | I32 | Public integrity | Difference between construction start date and publication date of environmental impact assessment | |
34 | I33 | Public integrity | Difference between construction start date and publication date of social impact assessment | |
36 | I35 | Internal efficiency | Number of modifications by type | |
37 | I36 | Service delivery | Proportion of projects with a supervision contract | |
38 | I37 | Market opportunity | Number of parties by role | |
39 | I38 | Market opportunity | Number of tenderers | Number of tenderers can be compared to the average number of tenderers per bid for the market-sector |
| A | B | C | D | |
|---|---|---|---|---|
1 | id | indicator_id | fields | notes |
2 | I1-1 | I1 | id budget/amount/amount budget/amount/currency completion/finalValue/amount completion/finalValue/currency | |
3 | I10-1 | I10 | id contractingProcesses/id contractingProcesses/summary/tender/procurementMethod contractingProcesses/summary/tender/costEstimate/amount contractingProcesses/summary/tender/costEstimate/currency | |
4 | I11-1 | I11 | id contractingProcesses/id contractingProcesses/summary/tender/procurementMethod contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency | |
5 | I12-1 | I12 | id budget/amount/amount budget/amount/currency completion/finalValue/amount completion/finalValue/currency | |
6 | I13-1 | I13 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/finalValue/amount contractingProcesses/summary/finalValue/currency | |
7 | I14-1 | I14 | id budget/amount/amount budget/amount/currency sector type locations/address/locality | |
8 | I15-1 | I15 | id budget/amount/amount budget/amount/currency sector type locations/address/region | |
9 | I16-1 | I16 | id budget/budgetBreakdown/sourceParty/id parties/id parties/identifier/id parties/identifier/scheme | |
10 | I16-2 | I16 | id budget/budgetBreakdown/sourceParty/name | |
11 | I16-3 | I16 | id parties/roles parties/identifier/id parties/identifier/scheme | |
12 | I16-4 | I16 | id parties/roles parties/name | |
13 | I17-1 | I17 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/id parties/id parties/identifier/id parties/identifier/scheme | |
14 | I17-2 | I17 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/name | |
15 | I18-1 | I18 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/id parties/id parties/identifier/id parties/identifier/scheme parties/address/countryName | |
16 | I18-2 | I18 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/id parties/id parties/identifier/id parties/identifier/scheme | |
17 | I18-3 | I18 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/id parties/id parties/name parties/address/countryName | |
18 | I18-4 | I18 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/id budget/budgetBreakdown/sourceParty/name parties/id parties/address/countryName | |
19 | I19-1 | I19 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/id parties/id parties/identifier/id parties/identifier/scheme | |
20 | I19-2 | I19 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/name | |
21 | I2-1 | I2 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/finalValue/amount contractingProcesses/summary/finalValue/currency | |
22 | I20-1 | I20 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/id parties/id parties/identifier/id parties/identifier/scheme | |
23 | I20-2 | I20 | id budget/budgetBreakdown/amount/amount budget/budgetBreakdown/amount/currency budget/budgetBreakdown/sourceParty/name | |
24 | I21-1 | I21 | id contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme parties/address/countryName | |
25 | I21-2 | I21 | id contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme | |
26 | I21-3 | I21 | id contractingProcesses/summary/suppliers/id parties/id parties/name parties/address/countryName | |
27 | I21-4 | I21 | id contractingProcesses/summary/suppliers/id contractingProcesses/summary/suppliers/name parties/id parties/address/countryName | |
28 | I21-5 | I21 | id parties/roles parties/id parties/identifier/id parties/identifier/scheme parties/address/countryName | |
29 | I21-6 | I21 | id parties/roles parties/id parties/identifier/id parties/identifier/scheme | |
30 | I21-7 | I21 | id parties/roles parties/id parties/name parties/address/countryName | |
31 | I22-1 | I22 | id budget/amount/amount budget/amount/currency contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme parties/address/countryName | |
32 | I22-2 | I22 | id budget/amount/amount budget/amount/currency contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme | |
33 | I22-3 | I22 | id budget/amount/amount budget/amount/currency contractingProcesses/summary/suppliers/id parties/id parties/name parties/address/countryName | |
34 | I22-4 | I22 | id budget/amount/amount budget/amount/currency contractingProcesses/summary/suppliers/id contractingProcesses/summary/suppliers/name parties/id parties/address/countryName | |
35 | I22-5 | I22 | id budget/amount/amount budget/amount/currency parties/roles parties/id parties/identifier/id parties/identifier/scheme parties/address/countryName | |
36 | I22-6 | I22 | id budget/amount/amount budget/amount/currency parties/roles parties/id parties/identifier/id parties/identifier/scheme | |
37 | I22-7 | I22 | id budget/amount/amount budget/amount/currency parties/roles parties/id parties/name parties/address/countryName | |
38 | I23-1 | I23 | id contractingProcesses/id contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme parties/address/countryName | |
39 | I23-2 | I23 | id contractingProcesses/id contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme | |
40 | I23-3 | I23 | id contractingProcesses/id contractingProcesses/summary/suppliers/id parties/id parties/name parties/address/countryName | |
41 | I23-4 | I23 | id contractingProcesses/id contractingProcesses/summary/suppliers/id contractingProcesses/summary/suppliers/name parties/id parties/address/countryName | |
42 | I24-1 | I24 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme parties/address/countryName | |
43 | I24-2 | I24 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme | |
44 | I24-3 | I24 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/suppliers/id parties/id parties/name parties/address/countryName | |
45 | I24-4 | I24 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/suppliers/id contractingProcesses/summary/suppliers/name parties/id parties/address/countryName | |
46 | I25-1 | I25 | id budget/amount/amount budget/amount/currency completion/finalValue/amount completion/finalValue/currency completion/finalValueDetails completion/finalScope completion/finalScopeDetails | |
47 | I26-1 | I26 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/finalValue/amount contractingProcesses/summary/finalValue/currency | |
48 | I27-1 | I27 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/modifications/id contractingProcesses/summary/modifications/newContractValue/amount contractingProcesses/summary/modifications/newContractValue/currency contractingProcesses/summary/modifications/description contractingProcesses/summary/modifications/rationale | |
49 | I28-1 | I28 | id documents/id documents/documentType | |
50 | I29-1 | I29 | id documents/id documents/documentType | |
51 | I3-1 | I3 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/modifications/id contractingProcesses/summary/modifications/newContractValue/amount contractingProcesses/summary/modifications/newContractValue/currency | |
52 | I30-1 | I30 | id documents/id documents/documentType | |
53 | I31-1 | I31 | id documents/id documents/documentType documents/datePublished contractingProcesses/id contractingProcesses/summary/nature contractingProcesses/summary/contractPeriod/startDate | |
54 | I32-1 | I32 | id documents/id documents/documentType documents/datePublished contractingProcesses/id contractingProcesses/summary/nature contractingProcesses/summary/contractPeriod/startDate | |
55 | I33-1 | I33 | id documents/id documents/documentType documents/datePublished contractingProcesses/id contractingProcesses/summary/nature contractingProcesses/summary/contractPeriod/startDate | |
56 | I34-1 | I34 | id assetLifetime/durationInDays | |
57 | I34-2 | I34 | id assetLifetime/startDate assetLifetime/endDate | |
58 | I35-1 | I35 | id contractingProcesses/id contractingProcesses/summary/modifications/id contractingProcesses/summary/modifications/type | |
59 | I36-1 | I36 | id contractingProcesses/id contractingProcesses/summary/nature | |
60 | I37-1 | I37 | id parties/id parties/roles | |
61 | I38-1 | I38 | id contractingProcesses/id contractingProcesses/summary/suppliers/id contractingProcesses/summary/tender/tenderers/id parties/id parties/identifier/id parties/identifier/scheme parties/roles publicAuthority/id | |
62 | I38-2 | I38 | id contractingProcesses/id contractingProcesses/summary/tender/numberOfTenderers parties/id parties/identifier/id parties/identifier/scheme parties/roles publicAuthority/id | |
63 | I4-1 | I4 | id period/endDate completion/endDate | |
64 | I5-1 | I5 | id contractingProcesses/id contractingProcesses/summary/status contractingProcesses/summary/contractPeriod/endDate contractingProcesses/summary/modifications/id contractingProcesses/summary/modifications/newContractPeriod/endDate | |
65 | I6-1 | I6 | id contractingProcesses/id contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme | |
66 | I6-2 | I6 | id contractingProcesses/id contractingProcesses/summary/suppliers/name | |
67 | I7-1 | I7 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/suppliers/id parties/id parties/identifier/id parties/identifier/scheme | |
68 | I7-2 | I7 | id contractingProcesses/id contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/suppliers/name | |
69 | I8-1 | I8 | id locations contractingProcesses/id contractingProcesses/summary/nature contractingProcesses/summary/contractValue/amount contractingProcesses/summary/contractValue/currency contractingProcesses/summary/suppliers/id contractingProcesses/summary/tender/tenderers/id parties/id parties/identifier/id parties/identifier/scheme | |
70 | I8-2 | I8 | id contractingProcesses/id contractingProcesses/summary/suppliers/name contractingProcesses/summary/tender/tenderers/name | |
71 | I9-1 | I9 | id contractingProcesses/id contractingProcesses/summary/tender/procurementMethod |