Data & calculations for: The circular economy potential of urban organic waste streams in low- and middle-income countries 

Introduction
This spreadsheet tool consists of five (5) worksheets which altogether contain the data used to determine the circular economy potential of organic waste streams in Kampala. Some of the data, along with the calculations can be used in the estimation of the resource recovery potential of organic waste streams in other cities/towns.

Section 1: Overview of worksheets
The WasteQuality sheet has data on the physical and chemical characteristic of the waste streams.
The TreatmentProcesses sheet has data on the physical and chemical transformation of waste streams as they go through the treatment processes.
The Prices sheet has data on the potential prices that resource recovery products can be sold at.
In the Calculation sheet, the quantities of waste streams that are available in the city are filled in as well as the percentage of each waste stream that should be used for each resource recovery option. The Table below is then populated with results indicating the resource recovery potential for each option. The buttons in the top left-hand corner can be used to show summarised or detailed results and also to copy the results of one iteration or scenario to a new sheet so as to save them while one explores other potential scenarios. One is prompted to name the new sheets copied for each scenario with names like ""Result-A"" & ""Graph-A"" for a given scenario.
The Graphs sheet contains bar graphs that were used to compare the various resource recovery options on the basis of their revenue potential, the amounts of nutrients that can be recovered and the energy amount that can be recovered. The graphs here are also copied and saved to a new sheet along with the related Results table, when one uses the ""Copy Results & Graphs to New Sheet"" button.

Section 2: Waste Streams in this tool
Faecal Sludge: Faecal sludge comes from onsite sanitation technologies, i.e., it has not been transported through a sewer. It results from the collection and storage/treatment of excreta or blackwater, with or without greywater. Faecal sludge includes both sludge from pit latrines and that from septic tanks.
Sewage Sludge: Sewage sludge (also referred to as wastewater sludge) is sludge that originates from sewer-based wastewater collection and (semi-) centralized treatment processes. 
Organic Municipal Solid Waste: This is the organic part of the urban solid waste and it includes items like food waste, market waste and crop residues.

Section 3: Resource Recovery Options in this tool
Anaerobic Digestion: This is a process which generates biogas, which has about 60% methane content. Biogas can be used for lighting, cooking and also for generating electricity and heat. The process of anaerobic digestion also generates a residue which can be used as soil conditioner or fertilizer in a farm to recover nutrients like nitrogen, phosphorus and potassium."
Solid Fuel: Excreta and organic waste streams have a high calorific value and can be turned into a solid dry fuel for combustion in briquette or powder form. This can be used either for cooking in households and institutional kitchens as well as for industrial applications like kilns and boilers.
Black soldier fly larvae: Organic waste streams can can be treated using fly larvae composting, for example with the Black Soldier Fly, to produce valuable larvae and a residue. The larvae of the black soldier fly is 40% protein and 30% fat and can therefore make a protein-rich animal feed. The residue from the fly larvae composting contains nutrients and can be applied to a garden as soil conditioner or fertilizer."
Composting: This is a process whereby a waste stream is composted to make soil conditioner or fertilizer for applying on farms. The compost generated is often rich in nutrients and also rich in organic matter content.

The worksheets in this tool are locked in order to protect the formulae, with the exception of the cells where the user has to make input. The sheets can be unlocked without a password in case the user would like to have a closer look at the formulas behind the tool. In case of any inquiries, contact daniel.ddiba@sei.org or kim.andersson@sei.org, or check out www.sei.org/revamp to learn more.

For the rest of the data in this dataset, please see https://doi.org/10.5281/zenodo.4465809