Questions about the registration process

The steps for successful registration differ. It depends whether your organization is already registered on the portal. Information about all ways to register can be found in this Tutorial

Only registered users have access to further information about case studies, such as field reports and pictures.

Questions about the conduction of WFD studies

The tool needs accurate values, if the values were entered in decimal points, make sure that total sum including the decimals is 100%. Another option could be to enter round up values.

This error could be due to the amount of collected waste being calculated lesser than the amount of waste sorted and/or recovered and/or disposed. Brining the % value for total collected waste >100.

As indicted in the WFD user manual,

“ The data requirements of the “Scenario data entry” sheet differ compared to those of the “Baseline data entry” sheet in that they follow a simpler linear approach (waste generation > collection > treatment > disposal). This is due to the scenarios not necessarily having to be based of ground-based measurements and therefore they don’t have the same restrictions that were applied to the baseline data for quality control. For example, in the baseline method, the collection coverage and uncollected waste is calculated by comparing measurements of what is treated and disposed compared to that generated at source. The “Baseline data entry” sheet uses measured weights in tonnes as inputs. In contrast, the “Scenario data entry” does not require these measured data points as it assesses possible hypothetical scenarios. Instead, the “Scenario data entry” sheet largely uses percentages to split the initial waste generation across each stage of the solid waste management system. This approach has both advantages and challenges. By allowing percentage-based data inputs for each stage of the waste management system, interventions can be targeted at aspects that would not be feasible using the baseline approach. For instance, collection coverage (%) can be specified as an input and therefore analysed as an intervention. However, challenges with this scenario method involve how the user is able to adequately select percentages for these inputs if these cannot be directly measured”

That is due to total amount of waste generation is less than total waste collected and disposed. Therefore, the division value will be >1, bringing it above 100%.

The errors are due to unbalanced mass or values divided by 0. Please double check the various subsections values, in section 5 of Baseline. If even one of the subsections has all the values set to none, this will tell the program that the divider value is 0, thus creating errors.

#DIV0 is the error value shown when trying to divide by zero. This error may occur if some of the data inputs in the ‘Value’ columns are not complete or if a zero value has incorrectly being added to a cell.

#N/A error means “no value is available.” This error may occur if some of the data inputs in the ‘Value’ columns are not complete, this error may occur if data has been entered in the wrong format.

For instance, numeric values entered as text. Otherwise, the error may occur when Excel converts the numbers to regional settings. The numbers must have decimal points as periods (.) and not commas (,) Please change under >file>>settings>>advanced to decimal points. For more info, check also https://docs.microsoft.com/en-us/office/troubleshoot/excel/formula-errors

The error check boxes in the flow diagram and calculations sheet will show a red cross if there is an error in the calculations. This typically occurs due to errors in the mass balance or due to flows being calculated as going negative.

This error may occur if data input values are not correct, or if assumptions and approximations used in the data input are unsatisfactory to allow the mass of the system to balance. It is advised users carefully check all data inputs and analysis performed, including that of the SDG11.6.1 methodology. The calculations sheet shows a detailed breakdown of where the errors in the mass balance of the system occur to aid in troubleshooting.

Baseline follows the linear data approach and thus takes the data from the same column. Whereas the scenario column we can have a condition, based on the data entered for various scenarios.

What we need is composition of total generated MSW, which measures the composition of HH waste and disposed waste. When following the SDG 11.6.1 method, an extra step will be required to calculate the composition of total generated MSW. As this method does not measure composition of non HH MSW. The MSW includes HH, commercial and institutional waste.

This could be due to longer labels, increase the diagram width. This can be done in the Size & Margin section, on the Sankey Matic website provided in the excel tool while creating or editing the diagram.

Questions about the WFD Portal

If you click the “publish” button, your study gets checked by the data curation team. After passing, the study gets released.

As long as you don’t click the “publish” button, only people from your organization can see your case studies.

You can delete your case studies by clicking the trash can icon under the case study in the user dashboard. You must be logged in to see the user dashboard.

Waste Flow Diagram