1.2.8 PRIVATEMETRICS.TAXONOMIES
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® and PECCS® 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 "PECCS-NACE"
.
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.