TAXONOMIES(taxonomy, pillar)
You can see the taxonomy of our TICCS®, PECCS®, and TICCS®+ classification using TAXONOMIES function, as well as the mapping between TICCS® taxonomy into NACE taxonomy or EU taxonomy.
If you're new to using Excel custom functions, don't worry! You can easily use our intuitive task pane UI instead.
It accepts 3 parameters, a taxonomy, a pillar as an optional parameter, and a boolean value as an optional parameter that the user can use to show/hide the description column.
Parameters
TAXONOMY: Text
Choose between these options: "TICCS", "PECCS", "TICCS+", "TICCS-NACE", or "TICCS-EU".
PILLAR: Text (Optional)
Available only if the taxonomy is either "TICCS", "PECCS", or "TICCS+".
Select a specific pillar to be displayed. If no pillar is specified, displays the entire taxonomy.
The available pillars are:
|
Taxonomy |
Pillar |
|---|---|
|
“TICCS” |
"Business Risk" |
|
|
"Geo Economic Exposure" |
|
|
"Industrial Activity" |
|
|
"Corporate Structure" |
|
“PECCS” |
"Activity Class" |
|
|
"Life Cycle Phase" |
|
|
"Revenue Model" |
|
|
"Customer Model" |
|
|
"Value Chain" |
|
“TICCS+” |
“Environment” |
|
|
“Social” |
|
|
“Governance” |
|
“TICCS-NACE” |
N/A |
|
“TICCS-EU” |
N/A |
SHOWDESCRIPTION: Boolean (Optional)
If not provided or if specified as TRUE, the Description column appears
Otherwise, the Description column is not displayed.
Returns
A table of taxonomy or mapping.
Examples
Query the entire TICCS® taxonomy:
=PRIVATEMETRICS.TAXONOMIES("TICCS")
Query the entire TICCS® taxonomy without Description:
=PRIVATEMETRICS.TAXONOMIES("PECCS", , FALSE)
Query only the Industrial Activity pillar from TICCS® taxonomy:
=PRIVATEMETRICS.TAXONOMIES("TICCS","Industrial Activity")
Query only the Industrial Activity pillar from TICCS® taxonomy without Description:
=PRIVATEMETRICS.TAXONOMIES("TICCS","Industrial Activity", FALSE)
Query only the Activity Class pillar from PECCS® taxonomy:
=PRIVATEMETRICS.TAXONOMIES("PECCS","Activity Class")
Query only the Activity Class pillar from PECCS® taxonomy without Description:
=PRIVATEMETRICS.TAXONOMIES("PECCS","Activity Class", FALSE)
Query the mapping between TICCS® and NACE taxonomy:
=PRIVATEMETRICS.TAXONOMIES("TICCS-NACE")
Note that the table will only show if it has enough space to display the data on the sheet. Otherwise it will show #SPILL! error. The blue border indicates how much space required to show the data. Clear the entire cell within the blue border to see the data.
