The Greater London Authority (GLA) Whole Life-Cycle Carbon (WLC) assessment and the Circular Economy (CE) statement both require results taken from their respective tools in One Click LCA to be added to Excel templates for submission to the GLA. Links to both templates can be found below:

Once you have completed your calculation using the 'Carbon assessment, GLA / RICS / Green Mark' tool, guidance for which can be found here: Whole Life Carbon Assessment, RICS & Greater London Authority, you are ready to add your results to the assessment template. The WLC has three stages of assessment, the Outline planning stage, the Detailed planning stage and the Post-construction stage. The format of these is quite similar but depending on the stage you are assessing, you'll need to fill the results into the corresponding tab.

Fill in your Project details and Assessment details based on your project information.

The Estimated WLC emissions will be calculated based on the formulas within the Excel template itself using the data from later inputs. You should only need to set the appropriate benchmark from the dropdown and later explain any reasons for the divergence from the benchmarks.

Retention of existing buildings and structures, Summary of key actions, and Further opportunities to reduce emissions will also need to be filled in by yourself based on the actions you have taken and possible options you have identified to reduce carbon emissions further.

The majority of these results are taken directly from the detailed report on the results page, however, they require to be grouped per RICS category as per the headings in column B of the template. These respective categories are used as column headings in the calculation detailed report.

This can be found under the 'Resource type' column of the detailed report

This can be found under the 'Mass of raw materials kg' column of the detailed report

Details for this can be found under the 'Service life' column in the detailed report and 'Repair/year (B3)' in the building materials query

This can be found under the 'EOL Process' column of the detailed report

The results for 'Estimated reusable materials (kg)' and 'Estimated recyclable materials (kg)' can be found in the detailed report under the column Estimated reusable materials kg and Estimated recyclable materials kg respectively.

Details for this section of the table can be taken from your inputs to the 'Emissions and removals' query under '1. Refrigerants'. The Refrigerant GWP result can be found in the detailed report under the '5 Services (MEP)' column and will be assigned to B1.

All results for this table can be taken directly from the 'Results summary', which is available to download as an Excel:

The table has been formatted in a way that is compatible with the GWP Potential table. Please note however that as the WLC submission Excel has formulas built within it, so there is no need to manually paste the totals. Biogenic carbon has also been arranged in a way that allows for this to be correctly calculated with the A1-A3 benefits being taken from the 'Biogenic carbon (kg CO2e)' column, but the emissions released at end-of-life in the C3 stage are included in the tables C3 figures.

Once you have completed your calculation using the 'Building Circularity, GLA ' tool, guidance for which can be found here: Building Circularity, Greater London Authority, you are ready to add your results to the statement template. The CE statement also has three stages of assessment, the Outline planning stage, the Detailed planning stage and the Post-construction stage. Again, the format of these is quite similar but depending on the stage you are assessing, you'll need to fill the results into the corresponding tab.

Fill in your Project details, Circular Economy Design Approaches and Circular Economy Design Principles by Building Layer based on your project information. The main content of the GLA submission Excel for the Circular Economy Statement should be taken from the material efficiency reports as detailed below. Please also note that the two versions of the material efficiency report provide the same calculation results, however, 'Materials efficiency report v1.1' provides subtotals by resource type, RICS category and total for the design

The following sections require input and this information can be taken from the 'Material efficiency report'. Please note, you will need to click the '+' symbol on the left-hand side of the Bill of Materials table to view or hide the input rows for each building element category. The rows for the substructure and frame have been unhidden to highlight this.

This can be found under the 'Resource type' column of the materials efficiency report. Subtotals for each column of the material efficiency report by resource type are provided in the material efficiency report v1.1.

This can be found under the 'Material Quantity (Module A) kg' column of the materials efficiency report. Please note that this now includes A1-A5 masses.

This can be found under the 'Waste factor' column of the materials efficiency report

This can be found under the 'Recycled kg' column of the materials efficiency report

This can be found under the 'Recycled content by value %' column of the materials efficiency report

This can be found under the 'Service life' column of the materials efficiency report

This can be found under the 'Waste factor' column of the materials efficiency report and will be the same factor as 'Construction Waste Factor (Module A)'

This can be found under the 'DfD' column of the materials efficiency report

This can be found under the 'EOL Process' column of the materials efficiency report

This can be found under the 'Reusing %' column of the materials efficiency report

This can be found under the 'Recycling %' column of the materials efficiency report

Finally, the Recycling and Waste Reporting table and the Circular Economy Targets require to be filled based on project information and can not be calculated by the software at this time.

The tool does not report this directly but there is a workaround for this.
​
With an Expert license, you can download this input from the Building materials tab in the Building Circularity tool.
​

The downloaded Excel will look like this:
​

You can hide the columns in this Excel, which are not necessary for the calculations for Appendix 3, leaving you with something similar to the screenshot below.

Column AE was manually added with the formula

(QUANTITY * COST PER UNIT * RECYCLED SHARE /100

Alternatively, TOTAL COST * RECYCLED SHARE /100 also suffices.
​
The total value will be the sum of the new column "RECYCLED CONTENT BY VALUE".