Sustainability & Risk / Green Building / Scoring - Track

Calculating your Certification Score and Financial Data

Once you enter the scores for your credits and subcredits for all categories in your rating project, you must have the system total your scores. Totaling your scores does the following:

• calculates your total self-score
• calculates your total official score
• calculates your total capital cost
• calculates your total annual savings
• checks that all prerequisite credits for all categories have been entered. If prerequisites have not been scored, the system does not total your data.
• maps your official score and your self score to the appropriate level within the certification standard. For example, if you are following the LEED standard and garner 49 points, the routine will inform you that you meet the Gold standard.

Once the system makes these calculations, it updates the upper right pane with the total data, as per the below image. In parentheses next to the total self-score and official score values, you can see the corresponding certification levels.

To calculate your score:

1. Verify that you have entered all credits, subcredits, and prerequisite credits.
2. Select Score Project.
3. In the left pane, select your rating project.
4. In the right pane, choose Update Totals.
5. Examine the upper right pane for your total score and the corresponding certification level, as shown in the above image.

Note: The certification level displayed in parentheses (as shown in the image) is for your reference. The system does not automatically update the Certified Level field of the Rating Projects table with this value. The Certified Level field is designed for you to enter the value returned by the certifying agency.

When reviewing the Scoring reports and dashboards, you will find that some reports focus on the certification level that maps to your score, whereas other reports focus on the value of Certified Level.

Calculation Details

When you define a certification standard, you choose one of the following scoring methods: 

• Point Total - The system sums the Self-Score field of all credits in the project.
• Weighted Point Total -- The system obtains the Self-Score total for each credit category, multiplies each category’s Self-Score total by the category’s weighting factor, and sums the weighted totals. For example, the Energy category might be weighted at 19 percent and the Transport category might be weighted at 20 percent.
• Weighted Category Percent Total -- With this method, the number of points in each category is weighted according to a percentage representing perceived importance. For each credit category, the system calculates the percent of the category’s total maximum score that the category’s total self-score represents; multiplies the category’s percent value by its weighed factor; and sums the weighted totals of all categories.

The system uses these calculations to score rating projects according to the above methods:

Point Total pseudo SQL:

SELECT bl_id,project_name, cert_std, sum (self_score) AS ‘Total Self Score’
FROM gb_cert_scores
WHERE credit_type =’C’
GROUP BY bl_id, project_name, cert_std;

Weighted Point Total pseudo SQL:

SELECT bl_id,project_name, cert_std, sum (cat_self_score) AS ‘Total Self Score’
FROM (SELECT bl_id, project_name, cert_std, cert_cat, sum (self_score)*weighting_factor AS ‘cat_self_score’
FROM gb_cert_scores, gb_cert_cat
WHERE credit_type =’C’
GROUP BY bl_id,project_name, cert_std, cert_cat)
GROUP BY bl_id,project_name, cert_std;

Weighted Category % Total pseudo SQL:

SELECT bl_id,project_name, cert_std, sum (cat_self_score) AS ‘Total Self Score’
FROM (SELECT bl_id,project_name, cert_std, cert_cat, (sum(self_score)/sum(maximum_score))*100*weighting_factor) AS ‘cat_self_score’
FROM gb_cert_scores, gb_cert_credits,gb_cert_cat
WHERE credit_type =’C’
GROUP BY bl_id,project_name, cert_std, cert_cat)
GROUP BY bl_id,project_name, cert_std;