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 2 parameters, a taxonomy, and a pillar as an optional parameter.

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

Returns

A table of taxonomy or mapping.

Example of TICCS® taxonomy mapping to NACE taxonomy

Examples

Query the entire TICCS® taxonomy:

CODE

=PRIVATEMETRICS.TAXONOMIES("TICCS")

Query only the Industrial Activity pillar from TICCS® taxonomy:

CODE

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

Query only the Activity Class pillar from PECCS® taxonomy:

CODE

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

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.