RICS 2nd edition excel upload

Buildings Assessments RICS & GLA
1

Hi, I had some issues uploading the Excel template into OneClick RICs v2 tool (the template available here Upload template

Below are some of my issues:

  • RICS v2 seems not to have all EPDs as RICS v1. For example building energy consumption only has 2 electricity profiles? I’ve attached my errors report below to show other mismatches as well.
  • Some new building CLASSes did not match from the template
  • Some AI material matches were inaccurate so we resorted to using the old uploader

image
image1374×807 89.4 KB

Would be great to know overall how ready the new RICS v2 tool is?

Thanks,

2

Hi Grigory,

Yes, there are only 2 electricity profiles in the RICS V2 tool. This is as according to the RICS 2nd edition guidelines laid out in Section 5.3 and Appendix H. If we have misunderstood this, please let us know if we have missed in our reading, that there should be more choices than those currently available.

The new import will not recognise the CLASSES in the RICS Excel template, it will only recognise the building materials.
If you are importing into the RICS V2 tool using the template, the classical import is recommended.

Screenshot 2024-11-13 161559
Screenshot 2024-11-13 1615591627×180 3.5 KB

Based on the screenshot, it looks like some of the mismatches were due to the Quantity Type, as in the unit of measurement. For example district heating is expecting kWh, or MJ, but is entered as m3.

As to why the AI mapping were inaccurate, this may be due to a combination of causes.

Please send us the Excel sheet you have used to support@oneclicklca.com
This will help us understand some of the root causes for the issues you have experienced.

3

Hi, thanks for this.

Attaching below section 4.9 which needs default and decarbonised scenarios for electricity - I believe this would require other profiles?

decarb oneclick
decarb oneclick677×316 44.4 KB

Could you please link to the template that I need to use for RICS v2?

Thanks,

4

Hi Grigory,

The energy profiles included in the RICS v2 tool automatically calculate both options. No need to select other templates for this.

image
image956×196 11 KB

Which will result in e.g:

image
image976×418 25.6 KB

Edit: If you meant reporting templates, you will find these automatically generate on the results page.

image
image416×154 7.12 KB

Hope this helps!

1 Like
5

Thank you! helps a lot, I meant template which are used for uploading into RICS v2 Tool. Previously, I sourced it here Templates

6

Aha, those can still be used. The correct one would be ‘OCL_import_form_Building_Metric_v1_11.xlsx’. Since we have made changes to our import process you no longer have to use those. You can upload any file, as long as some key column headers (name, quantity, unit, and class) are present.

More information on the new import process you can find here: Updated Import Process in One Click LCA – One Click LCA Help Centre

1 Like