Description
The SCORE function fetches a company's scorecard total for a rubric and reporting period from the Novata API, so you can place a score directly in any cell.
Syntax
=NOV.SCORE(company, rubric, reportingPeriod, fieldName)
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
company |
String | Required | Company name as shown on the scorecard (e.g. "The Clean Co"), or its Company Id. |
rubric |
String | Required | Rubric name (e.g. "ESG Rubric") or Rubric Id. A name always means the active rubric; use the Rubric Id for an archived rubric. |
reportingPeriod |
String | Required | Reporting period, in the same formats as NOV.ANSWER: "2024", "Q3 2024", "H1 2024" or "Jan 2025". |
fieldName |
String | Required | The scorecard field to return (see available fields below). |
Available Field Names
You can use any of the following field names as the fieldName parameter:
score
Total scorecard score
min_score
Lowest possible score
max_score
Highest possible score
aggregation_method
How question scores roll up (average or sum)
is_completed
Whether every question has been scored
is_stale
Whether report data changed after the scorecard was generated
last_generated_at
When the scorecard was last generated
Examples
Example 1: Get the total score
=NOV.SCORE("The Clean Co", "ESG Rubric", "2024", "score")
Result: 7.5
Example 2: Get the maximum score
=NOV.SCORE("The Clean Co", "ESG Rubric", "2024", "max_score")
Result: 10
Important Notes
Note:
- Company, rubric, category and question names match what the Scorecard Management panel inserts, ignoring case and surrounding spaces.
- A rubric name only matches the active rubric. For a rubric that has been archived, use its Rubric Id.
- Archived scorecards are ignored.
- Field names are case-sensitive. Use the exact field names listed above.
- Make sure you're logged into the Novata Excel Add-in before using this function.
Related Functions
NOV.CATEGORY - Retrieve scorecard category data
NOV.QUESTION - Retrieve scorecard question data
NOV.ANSWER - Retrieve answer data
NOV.COMP - Retrieve company attributes