Skip to main content
Skip table of contents

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.

taxf1.png

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.

taxf2.png

Example of TICCS® taxonomy

taxf3.png

Example of TICCS® taxonomy mapping to NACE taxonomy

Note that when the optional boolean 3rd parameter is set to FALSE, the Description column is not rendered

Examples

Query the entire TICCS® taxonomy:

CODE
=PRIVATEMETRICS.TAXONOMIES("TICCS")

Query the entire TICCS® taxonomy without Description:

CODE
=PRIVATEMETRICS.TAXONOMIES("PECCS", , FALSE)

Query only the Industrial Activity pillar from TICCS® taxonomy:

CODE
=PRIVATEMETRICS.TAXONOMIES("TICCS","Industrial Activity")

Query only the Industrial Activity pillar from TICCS® taxonomy without Description:

CODE
=PRIVATEMETRICS.TAXONOMIES("TICCS","Industrial Activity", FALSE)

Query only the Activity Class pillar from PECCS® taxonomy:

CODE
=PRIVATEMETRICS.TAXONOMIES("PECCS","Activity Class")

Query only the Activity Class pillar from PECCS® taxonomy without Description:

CODE
=PRIVATEMETRICS.TAXONOMIES("PECCS","Activity Class", FALSE)

Query the mapping between TICCS® and NACE taxonomy:

CODE
=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.

taxf4.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.