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.

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.