{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Intro","Ref_sys","New_tech","sLCA","Inputs","Results","Parameter_tables","LCA_variables","Pictures","My_techn"],"not_rendered":{"charts":5,"images":26,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Decision Supporting System developed in project INCOVER"]
["\nThis spreadsheet model, the Decision Support System  (DSS) was developed in the INCOVER project (https://incover-project.eu/) evaluating technologies developed for wastewater treatment and waste recovery. DSS is programmed in Visual Basic where only the active sheets are accessible for the user. Data inputs and other commads are defined as command buttons on these active sheets.\nThe ultimate goal of creating this Decision Support System was to provide easy understandable environmental indicators for various maintenance and investment projects, since this part of the information is usually not considered. In addition, although in many cases environmental prescriptions and regulations have to be kept and followed, they do not always support increasing environmental efficiency. Thus, just following the regulation does not guarantee a progressive approach toward sustainability and an easy approximate calculation of environmental impacts for different investment options can assist decison making.\nIn Project INCOVER we had the opportunity to use some very important and relevant LCA database units, i.e. unit processes, that could be used to make a quick preliminary evaluation of investment and maintenance alternatives at hand. These unit processes build the bases of the DSS. Additionally, a simple economic calculation was also built in to the DSS based on the economic data given by the user. And what is more, the anticipated social impacts of INCOVER technologies is also given on sheet \"sLCA\".\nThe DSS has four active sheets: “Intro”, “Ref_sys”, \"New_tech”, and \"sLCA\". On this sheet “Intro” is the short introduction to the application and the disclimer of the dataset providing company Think Step. The worksheet “Ref_sys” is designed for selecting the reference technology. This is of utmost importance, because the reference technology is the technology with the results of the new technology are compared with. Without this comparison, the sustainbility results are hard to understand and interpret, because sustainabilty assessment is only possible in relative terms, i.e. not absolute but relative sustainability can be assessed. This relativeness is provided by the reference system. In the worksheet “New_tech” the new technology can be defined and this page also contains the environmental and economic results of the conparison. These results are presented in tables and in case of LCA calculations also in charts. On the worksheet \"sLCA\" the user can have a look at the social assessment results of INCOVER technologies.\n\nImportant! Since the application uses macros, before you proceed with calculations, please allow the use of macros in Excel!"]
[]
["Disclaimer"]
["thinkstep AG (database provider) is not liable for the up-to-dateness, correctness, usability, completeness and quality of any calculations, conclusions and other results obtained through the use of the software provided by thinkstep AG and the user data. Any liability of thinkstep AG for the use of the calculations, conclusions and other results obtained through the software use is excluded. The user only is responsible for the up-to-dateness, correctness, usability, completeness and quality of his data, any calculations, conclusions and other results obtained by his data, tools, calculation tools, software and their subsequent use. He bears the sole risk of possible miscalculations, incompleteness, incorrectness and any further deficiencies. thinkstep AG is solely responsible for providing the software and the content already included therein."]
["The project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No.\n689242. The dissemination of results herein reflects only the author’s view and the Commission is not responsible for any use that may be made of the information it contains."]

{"sheet":"Ref_sys","index":1,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,1],[19,0,19,1],[18,0,18,1],[17,0,17,1],[3,0,3,1],[9,0,9,1]]}
["Selecting the reference technology"]
["In this worksheet you can select the reference technology that suits the best to your system.\nBear in mind that the function of the reference system should be the same with your system and the size shouldn't alter more than +/-50%.\n"]
[]
["Main features of the selected reference technology"]
["Technology selection","Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"]
["Size of technology, flow rate [m3/day]",{"$f":"VLOOKUP(B5,Inputs!A2:D19,4,FALSE)","v":300}]
["Lifetime of technologies [years]",{"$f":"VLOOKUP(B5,Inputs!A2:E19,5,FALSE)","v":40}]
["Reference flow of technology [m3/lifetime]",{"$f":"B6*365*B7","v":4380000}]
[]
["Technical perfomance of the reference technology"]
["Input values","Output values"]
[{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,8,FALSE)","v":"BOD [mg/L] 350"},{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,13,FALSE)","v":"BOD [mg/L] 6.75"}]
[{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,9,FALSE)","v":"COD [mg/L] 800"},{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,14,FALSE)","v":"COD [mg/L] 28.68"}]
[{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,10,FALSE)","v":"TSS [mg/L] 500"},{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,15,FALSE)","v":"TSS [mg/L] 10"}]
[{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,11,FALSE)","v":"TKN [mg/L] 67"},{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,16,FALSE)","v":"TN [mg/L] 12.35"}]
[{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,12,FALSE)","v":"TP [mg/L] 10"},{"$f":"VLOOKUP(Ref_sys!$B$5,Results!A4:Q20,17,FALSE)","v":"TP [mg/L] 1.34"}]
[]
["Description of the reference technology"]
[{"$f":"VLOOKUP(Ref_sys!B5,Results!A4:Q20,7,FALSE)","v":"The WW treatment plant was designed to clear a WW inflow of max. 300 m3/day, (1,600 PE).The SBR plant consists of a pretreatment unit with a filter and sand trap, a buffer tank, an SBR tank, and a sludge tank. The WW treated has exclusively municipal origins and first passes a filter, where the larger solid particles are selected out. Then the WW passes a sand trap (7 m3) and a buffer tank (110 m3) with a WW pump. Here is the WW stored for the next cycle in the SBR. Up here this phase is considered as pretreatment. Next, WW is treated in the 884 m3 SBR tank. In this tank 3 cycles of WW treatment are done per day, each lasting for 8 hours following this schedule: filling 57.47 min., anaerobic mixing 120 min., react – aerobic mixing 120 min., anoxic mixing 30 min, settle 90 min., decant 57.47 min., idle 4.8 min. Subsequent to the SBR tank, a sludge tank is included where the settled sludge is treated with the addition of PAM (Praestol) to thicken and to obtain a dry matter content of the sludge comparable to the dry matter content of the algal biomass after separation (i.e. ca. 3.5-4.8%)."}]
[]
[]
[]
["Technology"]
["Conventional wastewater treatment plant, flow rate: 30,137 m3/day"]
["High-rate algae pond with pretreatment and settler, flow rate: 300 m3/day"]
["Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"]
["Biogas production: 900 Nm3/day"]
["Algae-based biogas upgrade with HRAP, flow rate: 0.05 m3/day"]
["Pressure swing adsorption: 26,920.7 m3/day"]
["Raw sewage sludge incineration"]
["Evaporative system for digestate and sludge, flow rate: 0.427 m3/day"]
["Willow zero-discharge system for wastewater, flow rate: 4 m3/day"]
["Sludge Treatment Wetland, flow rate: 0.0225 m3/day"]
["Planted filter for outlet water from a HRAP with Phragmites australis, flow rate: 4 m3/day"]
["Planted filter for outlet water from a HRAP with Arundo donax, flow rate: 4 m3/day"]
["Planted filter with Phragmites Australis for municipal wastewater, flow rate: 4 m3/day"]
["Conventional chlorination, flow rate: 8 m3/day"]
["A. niger-based citric acid production"]
["Solar anodic oxidation: 8 m3/day"]
["no information"]

{"sheet":"New_tech","index":2,"n_rows":81,"n_cols":12,"rows_kept":81,"cut":false,"hidden":false,"merged":[[95,8,95,9],[95,11,95,12],[102,11,102,12],[3,0,3,7],[0,0,0,7],[3,8,3,20],[1,0,1,6],[10,0,10,2],[22,0,22,2],[33,0,33,2]]}
["Define your system"]
["This worksheet builds the main part of the application DSS. Here the user can define the composition of the new technology using different material and energy flows. This list of flows comprises the most common building materials and process additives that are used in wastewater treatment (WWT). In addition, you are welcome to define the performance of your technology by giving the input and output values too. To open this dialog box click on the button “Data input”. \nFirst, name the new technology. Next, the life span and the flow rate of the technology has to be defined. As a next step, fill in the first colum where the material and energy flows of the new technology are required. Please, be aware of the dimensions predifined for each flow. There are two main life phases important: construction and operation. In case of construction, the total amounts are to be defined and the calculation adjusts these amount to the total life span of the technology. Operation data should be provided per year and the calculation automatically considers the total amount for the whole life-cycle. \n\nIn the second column the cost of the material and energy flows, and for transportation and personnel has to be given. In addition, you can provide a short description of the newly defined system and provide characteristic input and output indicators describing the technical performance of the technology. To make these inputs understandable for others, please give the dimension as well, e.g. COD 800 [mg/L]. When this dialog box is filled in, click OK to show the results or Cancel to delete the inputs made so far.\n\nThere are three additional buttons available on this sheet: “Record my technology”, “Finish and close”, and “Back”. With the “Record my technology” button you can save the new technology as a reference system and all the inputs and results will be saved to this list. Consequently, when returning to the “Ref_sys” page, among the reference systems in the drop-down you will find the newly saved technology as well. With the “Finish and close” button the Excel file is closed without saving the results! The “Back” button allows to return back to the “Ref_sys” worksheet."]
[]
["Results"]
["Name of selected technologies",{"$f":"B51","v":"New technology"},{"$f":"C51","v":"Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"},null,null,null,{"$f":"B5","v":"New technology"},{"$f":"C5","v":"Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"}]
["Lifespan of technology",{"$f":"B52","v":40},{"$f":"C52","v":40}]
["Lifespan of technology",{"$f":"B52","v":40},40,null,"Global warming potential","kg CO2-eq./FU",{"$f":"My_techn!B3","v":1.0983278038572926},{"$f":"VLOOKUP(H5,Results!$A$4:$F$98,2,FALSE)","v":0.27500669633653646}]
["Flow rate of technology, unit/years",300,300,null,"Eutrophication potential","kg PO4 eq./FU",{"$f":"My_techn!C3","v":2.954455874247656E-3},{"$f":"VLOOKUP(H5,Results!$A$4:$F$98,3,FALSE)","v":1.6440547357798364E-4}]
["Flow rate of technology, unit/lifetime",4380000,4380000,null,"Acidification potential","kg SO4 eq./FU",{"$f":"My_techn!D3","v":5.9560531235069124E-3},{"$f":"VLOOKUP(H5,Results!$A$4:$F$98,4,FALSE)","v":1.1552444508891727E-3}]
[null,null,null,null,"Human toxicity potential","kg DCB eq./FU",{"$f":"My_techn!E3","v":0.44955564021275102},{"$f":"VLOOKUP(H5,Results!$A$4:$F$98,5,FALSE)","v":0.46170799794601725}]
["Building materials",null,null,null,"Primer energy demand","MJ/FU",{"$f":"My_techn!F3","v":25.906032022619605},{"$f":"VLOOKUP(H5,Results!$A$4:$F$98,6,FALSE)","v":4.7820917928464892}]
["Concrete, kg",{"$f":"B56","v":50},{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,6,FALSE)","v":335154.39999999997}]
["Steel components, kg",{"$f":"B74","v":10},{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,24,FALSE)","v":19137.1104829}]
["PVC pipes, kg",{"$f":"B57","v":0},{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,7,FALSE)","v":249.8}]
["HDPE pipes, kg",56,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,8,FALSE)","v":0}]
["Glass fibre reinforced PE pipe, kg",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,9,FALSE)","v":0}]
["PE plastic parts, kg",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,10,FALSE)","v":0}]
["PP plastic parts, kg",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,11,FALSE)","v":0}]
["PVC plastic parts, kg",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,12,FALSE)","v":0}]
["Glass fibre reinforced PE parts, kg",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,13,FALSE)","v":0}]
["Pumps, kg",50,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,14,FALSE)*C64/C7","v":280}]
[]
["Operational imputs"]
["Flocculant PAC18%, kg/day",{"$f":"B65","v":0},{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,15,FALSE)/(365*$C$7)","v":17.470068493150684}]
["Coagulants Polyacrylamide, kg/day",100,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,16,FALSE)/(365*$C$7)","v":0.63130136986301366}]
["Polyether polyol, kg/day",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,17,FALSE)/(365*$C$7)","v":0}]
["Limestone, kg/day",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,18,FALSE)/(365*$C$7)","v":0}]
["Sodium silicate, kg/day",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,19,FALSE)/(365*$C$7)","v":0}]
["Process water, kg/day",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,20,FALSE)/(365*$C$7)","v":0}]
["Electricity, kWh/day",100,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,21,FALSE)/(365*$C$7*3.6)","v":132.02795395738207}]
["PV electricity, kWh/day",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,22,FALSE)/(365*$C$7)","v":0}]
["Heat, MJ/day",0,{"$f":"VLOOKUP($C$5,Inputs!$A$3:$X$100,23,FALSE)/(365*$C$7)","v":0}]
[]
["Economic results"]
["CAPEX, €",{"$f":"SUM(G56:G64)+G74+G73","v":0},{"$f":"SUM(I56:I64)+I74+I73","v":0}]
["OPEX, €/year",{"$f":"SUM(G65:G72)+G75","v":0},{"$f":"SUM(I65:I72)+I75","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Name of the technology","New technology",{"$f":"Ref_sys!B5","v":"Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"}]
["Lifespan of technology",40,{"$f":"Ref_sys!B7","v":40}]
["Flow rate of technology per day",300,{"$f":"Ref_sys!B6","v":300}]
["Flow rate of technology per lifetime",{"$f":"B52*B53*365","v":4380000},{"$f":"C52*C53*365","v":4380000}]
[null,null,"lifespan",null,"Cost","Cost",null,{"$f":"C5","v":"Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"}]
["Concrete, kg",50,40,{"$f":"B56*$B$52/C56","v":50},null,"Concrete, €/kg",{"$f":"D56*E56","v":0},{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,6,FALSE)*$C$52/C56","v":335154.39999999997},{"$f":"H56*E56","v":0}]
["PVC pipes, kg",null,40,{"$f":"B57*$B$52/C57","v":0},null,"PVC pipes, €/kg",{"$f":"D57*E57","v":0},{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,7,FALSE)*$C$52/C57","v":249.8},{"$f":"H57*E57","v":0}]
["HDPE pipes, kg",56,40,56,null,"HDPE pipes, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,8,FALSE)*$C$52/C58","v":0},0]
["Glass fibre reinforced PE pipe, kg",null,40,0,null,"Glass fibre reinforced PE pipe, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,9,FALSE)*$C$52/C59","v":0},0]
["PE plastic parts, kg",null,40,0,null,"PE plastic parts, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,10,FALSE)*$C$52/C60","v":0},0]
["PP plastic parts, kg",null,40,0,null,"PP plastic parts, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,11,FALSE)*$C$52/C61","v":0},0]
["PVC plastic parts, kg",null,40,0,null,"PVC plastic parts, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,12,FALSE)*$C$52/C62","v":0},0]
["Glass fibre reinforced PE parts, kg",null,40,0,null,"Glass fibre reinforced PE parts, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,13,FALSE)*$C$52/C63","v":0},0]
["Pumps, kg",50,10,200,null,"Pumps, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,14,FALSE)","v":1120},{"$f":"H64*E64","v":0}]
["Flocculant PAC18%, kg/day",null,365,{"$f":"B65*C65*$B$52","v":0},null,"Flocculant PAC18%, €/kg",{"$f":"B65*C65*E65","v":0},{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,15,FALSE)","v":255063},{"$f":"H65/$C$52*E65","v":0}]
["Coagulants Polyacrylamide, kg/day",100,365,{"$f":"B66*C66*$B$52","v":1460000},null,"Coagulants Polyacrylamide, €/kg",{"$f":"B66*C66*E66","v":0},{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,16,FALSE)","v":9217},{"$f":"H66/$C$52*E66","v":0}]
["Polyether polyol, kg/day",null,365,0,null,"Polyether polyol, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,17,FALSE)","v":0},0]
["Limestone, kg/day",null,365,0,null,"Limestone, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,18,FALSE)","v":0},0]
["Sodium silicate, kg/day",null,365,0,null,"Sodium silicate, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,19,FALSE)","v":0},0]
["Process water, kg/day",null,365,0,null,"Process water, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,20,FALSE)","v":0},0]
["Electricity, kWh/day",100,365,{"$f":"B71*C71*$B$52*3.6","v":5256000},null,"Electricity, €/kWh",{"$f":"B71*C71*E71","v":0},{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,21,FALSE)","v":6939389.2600000007},{"$f":"H71/($C$52*3.6)*E71","v":0}]
["PV electricity, kWh/day",null,365,{"$f":"B72*C72*$B$52*3.6","v":0},null,"Heat, €/MJ",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,23,FALSE)","v":0},{"$f":"H72/$C$52*E72","v":0}]
["Heat, MJ/day",null,365,{"$f":"B73*C73*$B$52","v":0},null,"Trasport cost, €/tkm",{"$f":"(SUM(D56:D69)+D74)/1000*E73*B75","v":0},{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,6,FALSE)","v":335154.39999999997},{"$f":"(SUM(H56:H69)+H74)/1000*E73*B75","v":0}]
["Steel components, kg",10,40,{"$f":"B74*$B$52/C74","v":10},null,"Steel components, €/kg",0,{"$f":"VLOOKUP($H$55,Inputs!$A$3:$X$100,24,FALSE)*$C$52/C74","v":19137.1104829},{"$f":"H74*E74","v":0}]
["Average transport distance, km",null,12,null,null,"Personal costs, €/month",{"$f":"E75*C75","v":0},null,{"$f":"G75","v":0}]
[null,null,"Life span"]
[null,null,5]
[null,null,10]
[null,null,15]
[null,null,20]
[null,null,40,null,null,null,"Input",null,null,null,null,"Output"]

{"sheet":"sLCA","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,17,4],[0,0,0,4],[3,0,17,0]]}
["On this sheet the user can read about the social life-cycle assessment results of the technologies in INCOVER"]
["Name of the evaluated technology - Please choose from the drop-down list!","Description of results of the social life-cycle assessment"]
["Hydrothermal carbonization",{"$f":"VLOOKUP(A3,F20:H27,3,FALSE)","v":"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Creation of significant indirect jobs are not expected. Could be significant if was created a small economy related with large scale production of biochar, which could be used by local agents as carbon sequestration agent, soil amendment and adsorbent/ oin exchanger for water and air purification.\n- Wastewater providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are physical, ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n-  Should be feasible to have the technology installed at existing WWTP. However, in case of a stand-alone production plant is envisaged, private land occupation could be some of the emerging social issues.\n- Like others WWTP, this technology could produce odors and liquid effluents, so there is a possibility to arise life quality conflicts on community. \n- Technology energy consumption should not be significant to promote natural resources conflicts on community. The energy balance depends very strongly on the treated biomass. Worst case means that we need energy to heat up the water to 110 °C, the resting needs are coming from the energy recovery at the end of the process. Best case is that there are light energy surpluses, which have to be removed. Most probable case is to install the HTC unit at a place where energy already exists as a surplus, e.g. CHP or a biogas plant.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community is not significant. It may be significant in some decades where there will be desertified soils on UE. HTC could provide fertilization capabilities for poor quality, degraded or desertified soils and to use in hydroponic cultures and, therefore, improve production on agriculture activities and promote economic growth.\n- The technology could have impact on pollution mitigation because promotes circular economy and waste reuse and valorization. This technology shows also potential for CO2 reduction comparing to natural rotting processes. Should be applied to wastewater treatment plants where energy or heat surplus already exists (e.g. CHP or a biogas plant), in order to fulfill high energy demands of the technology. The liquid by-product (process water or effluent) is very rich in nutrients, and could be treated or can be used as liquid fertilizer (which needs to be tested first to assess all the impacts). Odor production should be also removed. CO2 is about 80 % of the gas phase.\n- It is expected to give information to users about the resources and origin of biochar and liquid fertilizer, recommended uses for it, or safe disposal. \n- The inadequate use of biochar and liquid fertilizer could arise environmental risks. Is also expected to give this information to users.\n- User, consumer or community satisfaction surveys regarding quality of service should be done.\n"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Name of technology",null,"Description of resulst"]
[null,null,null,null,null,"Water irrigation remotely controlled systems",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Is not expected to create significant indirect jobs.\n- Technology works with local suppliers for installation services either in agronomy domain (planting) or hydraulic issues (irrigation driplines, pump deployment), for system's maintenance, as well as go-to-market partners since irrigation market and the supply chain is highly complex (manufacturers, irrigation consultants/ auditors, dealers, end-users). \n- Development of agriculture activities and sectorial economy growth. Smart farming tools make farming more convenient, evidence-based and digitized so younger generations are more appealed jump in the agriculture production. The flexibility for remote monitoring of farms may lead to cultivating currently unexploited lands and thus contribute to regional employability. FINT's technology powers the local data economy creation and optimizing the water consumption on farming activities depending on weather conditions resulting on the boost of production of agriculture sector. Farming increasing productivity and minimizing risk since when extreme weather conditions occur users are timely notified. \n- Local equipment or other material suppliers will be contracted during O&M for all commissioned modules. Local waste management operators will be contracted during dismantlement for all commissioned modules. \n- Occupational risk for workers are expected to be very low, therefore, is expected no need to implement health and safety policies, preventive plan and measures or emergency protocols regarding workers, beside legal requirements.\n- Is not expected to generate community conflicts related to natural resources consumption, health and safety of population, security issues, life quality issues, casualties or injuries, resettlements, or others. The technology needs occupation of land to operate, but the risk of inducing conflicts or social impairments is considered not significant.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as public meetings with local community members and open door events regarding smart farming tools, media reports on TV and Internet, newsletters publication, information by email, etc.\n- The technology has a significant impact on pollution mitigation because it contributes to consumption reduction of water resources, pesticides, and fertilizers on the farming activities. The technology monitoring capabilities promotes the prevention of pollution and improvement of environmental conditions. Also increase the trust in primary production and minimize the production risks related with extreme weather conditions because users are timely notified. \n- The technology delivers water traceability and quality monitoring which promotes food safety to consumers and health beneficiation.\n- The use of retreated water application on non-demanding irrigation applications (e.g. energy crop, urban washing, landscape or sport-courts watering) avoid the excessive consumption of mineral water resources, and therefore, could prevent social conflicts on water scarcity regions.\n- Is expected to give information to users about the resources and origin of the water, quality parameters or conditions, recommended uses for the water and possible environmental or health risks (or other adverse effects) when treated wastewater is used by FINT's irrigation systems.\n- At dismantlement phase the equipment should be collected and sent to recommended destination (reuse or recycling) or safely dispose following all the relevant guidelines and best practices for residues. \n- Consumer or user satisfaction surveys regarding quality of service and reports on irrigation equipment performance on an on-demand service scheme.\n"]
[null,null,null,null,null,"Solar driven disinfection systems by ultrafiltration",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Is not expected to create significant indirect jobs.\n- Wastewater providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff, mainly on handling of chemicals during service cleaning. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n-  Should be feasible to have the technology installed at existing WWTP. The technology needs occupation of land to operate, but the risk of inducing conflicts or social impairments is considered not significant.\n- The technology does not produce extra odors or other significant emissions to air, so should not promote life quality conflicts on community.\n- The technology energy consumption should not be significant to promote natural resources conflicts on community.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community should not significant.\n- The technology has a significant impact on pollution mitigation because it contributes to consumption reduction of water resources, saving water due to reuse and providing high quality / disinfected water for non-demanding uses (e.g. irrigation and washing activities). The technology monitoring capabilities promotes the prevention of pollution and improvement of environmental conditions. \n- The technology delivers water traceability and quality monitoring which promotes food safety to consumers when crops are irrigated by disinfected water or increase the sanitary conditions when disinfected water is used for cleaning and washing activities, promoting health beneficiation.\n- The use of retreated water application on non-demanding irrigation applications (e.g. energy crop, urban washing, landscape or sport-courts watering) avoid the excessive consumption of mineral water resources, and therefore, could prevent social conflicts on water scarcity regions.\n- Is expected to give information to users about the resources and origin of the water, quality parameters or conditions, recommended uses for the disinfected water and possible environmental or health risks (or other adverse effects) when treated wastewater is used.\n- At dismantlement phase the equipment should be collected and sent to recommended destination (reuse or recycling) or safely dispose following all the relevant guidelines and best practices for residues. \n- Consumer or user satisfaction surveys regarding quality of service and reports on solar disinfection equipment performance on an on-demand service scheme.\n"]
[null,null,null,null,null,"High Rate Algae Ponds (HRAP) system for wastewater treatment, thermal pre-treatment and anaerobic co-digestion of microalgae with biogas production",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Creation of significant indirect jobs are not expected. Could be significant if was created a small economy related with large scale production of biogas, which could be used by local road vehicles or energy production.\n- Wastewater providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n-  Should be feasible to have the technology installed at existing WWTP. However, in case of a full scale and stand-alone production plant is envisaged, and considering the need of large size of territory to build algae ponds, private land occupation and need for resettlements could be some of the emerging social issues.\n- Like others WWTP, this technology could produce odors, so there is a possibility to arise life quality conflicts on community.\n- HRAP is a eco-efficient process that needs less electric consumption then conventional activated sludge wastewater treatments. Therefore, technology energy consumption should not be significant to promote natural resources conflicts on community.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community is not significant.\n- The technology has a significant impact on pollution mitigation and health beneficiation because it contributes to wastewater treatment and improvement of sanitary conditions of community. The technology contributes to CO2 absorption by microalgae, and combined with anaerobic co-digestion produces biomethane that could be reused as vehicle fuel for transportation in public transport (buses, trash truck and other public vehicles) or energy recovery systems and promoting circular economy. After dried and purified from H2S and siloxanes the biogas will be used directly in vehicles - Fuel quality: <20 mg/Nm3 of total sulphur and water dew point of -10ºC at 200 bar, according to ISO 6327. Vehicles adapted to natural gas can also be used for this biofuel. These solutions contribute positively for CO2 emissions reduction and global warming mitigation and adaption. All of these environmental aspects bring social benefits to quality of life, pollution mitigation and health or sanitary conditions.\n- These technologies allows the reuse of treated wastewater for several non-demanding uses (e.g. irrigation, washing) and avoid mineral water consumption, so could prevent some social conflicts in regions with water scarcity. \n- It is expected to give information to users about the resources and origin of biomethane, recommended uses for it, or safe disposal. \n- The inadequate use of biomethane could arise environmental and occupational or safety risks. Is also expected to give this information to users.\n- User, consumer or community satisfaction surveys regarding quality of service should be done.\n- At dismantlement phase the equipment should be collected and sent to recommended destination (reuse or recycling) or safely dispose following all the relevant guidelines and best practices for residues.\n"]
[null,null,null,null,null,"Hydrothermal carbonization",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Creation of significant indirect jobs are not expected. Could be significant if was created a small economy related with large scale production of biochar, which could be used by local agents as carbon sequestration agent, soil amendment and adsorbent/ oin exchanger for water and air purification.\n- Wastewater providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are physical, ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n-  Should be feasible to have the technology installed at existing WWTP. However, in case of a stand-alone production plant is envisaged, private land occupation could be some of the emerging social issues.\n- Like others WWTP, this technology could produce odors and liquid effluents, so there is a possibility to arise life quality conflicts on community. \n- Technology energy consumption should not be significant to promote natural resources conflicts on community. The energy balance depends very strongly on the treated biomass. Worst case means that we need energy to heat up the water to 110 °C, the resting needs are coming from the energy recovery at the end of the process. Best case is that there are light energy surpluses, which have to be removed. Most probable case is to install the HTC unit at a place where energy already exists as a surplus, e.g. CHP or a biogas plant.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community is not significant. It may be significant in some decades where there will be desertified soils on UE. HTC could provide fertilization capabilities for poor quality, degraded or desertified soils and to use in hydroponic cultures and, therefore, improve production on agriculture activities and promote economic growth.\n- The technology could have impact on pollution mitigation because promotes circular economy and waste reuse and valorization. This technology shows also potential for CO2 reduction comparing to natural rotting processes. Should be applied to wastewater treatment plants where energy or heat surplus already exists (e.g. CHP or a biogas plant), in order to fulfill high energy demands of the technology. The liquid by-product (process water or effluent) is very rich in nutrients, and could be treated or can be used as liquid fertilizer (which needs to be tested first to assess all the impacts). Odor production should be also removed. CO2 is about 80 % of the gas phase.\n- It is expected to give information to users about the resources and origin of biochar and liquid fertilizer, recommended uses for it, or safe disposal. \n- The inadequate use of biochar and liquid fertilizer could arise environmental risks. Is also expected to give this information to users.\n- User, consumer or community satisfaction surveys regarding quality of service should be done.\n"]
[null,null,null,null,null,"Biogas upgrading system",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Is not expected to create significant indirect jobs. Could be significant if was created a small economy related with waste transportation, valorization and production of biogas in large scale installations.\n- Wastewater and waste providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff, mainly on handling of chemicals during service cleaning. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n- The technology is an integrate module which should be installed at existing WWTP or any anaerobic digestion plant. Besides usual WWTP social impacts, the technology does not produce any extra conflicts to the community.\n- The technology does not produce extra odors or other significant emissions to air, so should not promote life quality conflicts on community.\n- The technology energy consumption should not be significant to promote natural resources conflicts on community.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community should not significant.\n- The technology has a significant impact on pollution mitigation and health beneficiation because it contributes to wastewater treatment and improvement of sanitary conditions of community. The technology combined with anaerobic co-digestion produces biomethane that could be reused as vehicle fuel or energy recovery systems, promoting circular economy of waste. These solutions contribute positively for CO2 emissions reduction and global warming mitigation and adaption. All of these environmental aspects bring social benefits to quality of life, pollution mitigation and health or sanitary conditions.\n- It is expected to give information to users about the resources and origin of biomethane, recommended uses for it, or safe disposal. \n- The inadequate use of biomethane could arise environmental and occupational or safety risks. Is also expected to give this information to users.\n- User, consumer or community satisfaction surveys regarding quality of service should be done.\n- At dismantlement phase the equipment should be collected and sent to recommended destination (reuse or recycling) or safely dispose following all the relevant guidelines and best practices for residues.\n"]
[null,null,null,null,null,"Photobioreactor (PBR) system for wastewater treatment, thermal pre-treatment and anaerobic co-digestion of cianobacteria with biogas production",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Creation of significant indirect jobs are not expected. Could be significant if was created a small economy related with large scale production of biogas, which could be used by local road vehicles or energy production.\n- Wastewater providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n-  Should be feasible to have the technology installed at existing WWTP. The technology needs occupation of land to operate, but the risk of inducing conflicts or social impairments is considered not significant.\n- Like others WWTP, this technology could produce odors, so there is a possibility to arise life quality conflicts on community.\n- The technology energy consumption should not be significant to promote natural resources conflicts on community.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community is not significant.\n- The technology has a significant impact on pollution mitigation and health beneficiation because it contributes to wastewater treatment and improvement of sanitary conditions of community. The technology combined with anaerobic co-digestion produces biomethane that could be reused as vehicle fuel for transportation or energy recovery systems (electric grid supply), promoting circular economy. These solutions contribute positively for CO2 emissions reduction and global warming mitigation and adaption. All of these environmental aspects brings social benefits to quality of life, pollution mitigation and health or sanitary conditions.\n- These technologies allows the reuse of treated wastewater for several non-demanding uses (e.g. irrigation, washing) and avoid mineral water consumption, so could prevent some social conflicts in regions with water scarcity. \n- It is expected to give information to users about the resources and origin of biomethane, recommended uses for it, or safe disposal. \n- The inadequate use of biomethane could arise environmental and occupational or safety risks. Is also expected to give this information to users.\n- User, consumer or community satisfaction surveys regarding quality of service should be done.\n- At dismantlement phase the equipment should be collected and sent to recommended destination (reuse or recycling) or safely dispose following all the relevant guidelines and best practices for residues.\n"]
[null,null,null,null,null,"Wastewater treatment by planted filter / Solid digestate (sludge) valorization on evaporative systems or wetlands for nutrient recovery",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Creation of significant indirect jobs are not expected. Could be significant if was created a small economy related with large scale production of biogas, which could be used by local road vehicles or energy production.\n- Wastewater providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n- Should be feasible to have the technology installed at existing WWTP. However, in case of a full scale and stand-alone production plant is envisaged, and considering the need of large size of territory to implement wetlands or planted filters, private land occupation and need for resettlements could be some of the emerging social issues.\n- This technology could produce odors and dust temporarily, so there is a possibility to arise life quality conflicts on community.\n- Some health and food safety issues could emerge on community generating conflicts due to lack of information related with the health and food safety when the wastewater and sludge subtracts are used to fertilize crops on farmland as sources of carbon and nutrients.\nand other food produced on this treated and recycled sludge and water.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community should not significant.\n- The technology has a significant impact on pollution mitigation and health beneficiation because it contributes to wastewater treatment and improvement of sanitary conditions of community. The technologies contribute to mitigation of CO2 and therefore, contribute positively to prevent climate change and air quality. Cleaning wastewater and removing nutrients from sludge has an overall benefit to pollution mitigation on local water resources. The reuse of clean water, allows less/no use of freshwater to irrigate the crops or other non-demanding uses of water. The technology allows safely reuse of recovered nutrients on agriculture soils. Contributes also to the reduction on use of artificial fertilizers which have a bad environmental footprint and which are already scarce. \n- These technologies allows the reuse of treated wastewater for several non-demanding uses (e.g. irrigation, washing) and avoid mineral water consumption, so could prevent some social conflicts in regions with water scarcity. \n- It is expected to give information to users about the resources and origin of the nutrients, best practices and recommended uses for it, and safe disposal.                 \n- Small tests showed that the use of these crops has no environmental and health risks while eating vegetables or other food produced with treated wastewater or sludge. Is also expected to give this information to users.\n- User, consumer or community satisfaction surveys regarding quality of service should be done.\n- At dismantlement phase the equipment should be collected and sent to recommended destination (reuse or recycling) or safely dispose following all the relevant guidelines and best practices for residues.\n"]
[null,null,null,null,null,"Solar driven disinfection systems by anodic oxidation",null,"The technology major social impacts are:\n- Creation of local jobs on a technical level during operation and maintenance for the commissioned modules.\n- Is not expected to create significant indirect jobs.\n- Water or treated wastewater providers, and equipment or other material local suppliers, and waste management operators will be contracted during O&M. Waste management operators will be contracted during dismantlement. \n- There are ergonomic, chemical and biological contamination risks related with wastewater O&M activities for our staff, mainly on handling of chemicals during service cleaning. Same risks on dismantlement phase. Therefore, health and safety policies, preventive plan and measures should be implemented and emergency protocols regarding workers, beside legal requirements.\n- The technology is an integrate module which should be installed at existing WWTP. Besides usual WWTP social impacts, the technology does not produce any extra conflicts to the community.\n- The technology could produce some chlorine odors but should not induce life quality conflicts on community. The technology should be installed inside WWTP.\n- The technology energy consumption should not be significant and will be fully solar, so is not expected to promote natural resources conflicts on community.\n- The participation and engagement of the local community should be promoted. It provides transparency, education and social pacification through relevant information to population during the activities and operations. There's an intention to participate on promotion events and communication activities with local community, such as attend to community meetings, promote installation visits, media reports on TV and Internet, newsletters publication, information by email, abstracts or scientific articles, etc.\n- Although there's a capability of job generation, the impact on economic growth of community should not significant.\n- The technology has a significant impact on pollution mitigation and health beneficiation because it contributes to disinfection of water and treated wastewater and improvement of sanitary conditions of community. The system transforms free available Cl- into chlorine using it as a disinfection agent without using any chemicals. The system is completely solar driven and does not required any additional energy input for disinfection of treated wastewater. By polishing the treated wastewater further, it becomes process/irrigational water and thus reducing the abstraction of limited available fresh water resources. Additional water becomes available for further appliances. increasing e.g. crop yield, and can result in some economic growth (but not significant). The system contributes for climate change policies because all the technology runs with renewable energy. It could also prevent social conflicts in regions with water scarcity because the produced water can be used safely for several uses, avoiding consumption of mineral water from natural resources.  \n- It is expected to give information to users about the resources and origin of the disinfected water, recommended uses for it, or safe disposal. \nThere are no significant environmental or safety risks, beside the presence of chlorine on water. \n- User, consumer or community satisfaction surveys regarding quality of service should be done.\n- At dismantlement phase the equipment should be collected and sent to recommended destination (reuse or recycling) or safely dispose following all the relevant guidelines and best practices for residues.\n"]

{"sheet":"Inputs","index":4,"n_rows":19,"n_cols":24,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Technology","FU","Reference flow","Flow rate, m3/day","Lifetime","Concrete","PVC pipes","HDPE pipes","Glass fibre reinforced PE pipe","PE plastic parts","PP plastic parts","PVC plastic parts","Glass fibre reinforced PE parts","Pumps","Flocculant PAC18%","Coagulants Polyacrylamide","Polyether polyol","Limestone","Sodium silicate","Process water","Electricity","PV electricity","Heat","Steel components"]
["Conventional wastewater treatment plant, flow rate: 30,137 m3/day","1 m3",440000000,30137,40]
["High-rate algae pond with pretreatment and settler, flow rate: 300 m3/day","1 m3",4380000,300,40,{"$f":"212522+9940+34675.2+501775.2","v":758912.4},{"$f":"90.84+121.23+208.57+11.02+4*50","v":631.66},{"$f":"12.4+11.16+4*80","v":343.56},null,null,{"$f":"1143","v":1143},{"$f":"6858","v":6858},{"$f":"222.56*4","v":890.24},{"$f":"458.8+195+208","v":861.8},{"$f":"82.1*1000","v":82100},{"$f":"12264","v":12264},null,null,null,null,{"$f":"78840+268056+693792+148014.926","v":1188702.926},null,null,{"$f":"30+80.67+30+850+5+85+17292.439+863.835+20*4+40*4+365.151082*4","v":20937.548327999997}]
["Sequencing batch reactor with sludge settler, flow rate: 300 m3/day","1 m3",4380000,300,40,{"$f":"8262+49703.8+177060.3+100128.3","v":335154.39999999997},{"$f":"205.8+44","v":249.8},null,null,null,null,null,null,{"$f":"294+294+266+266","v":1120},255063,9217,null,null,null,null,{"$f":"227059+755172.4+5957157.86","v":6939389.2600000007},null,null,{"$f":"70*2+413.1014957+214.47+2485.191289+8853.015652+708+472+423.9538462+19.6223+5006.4159+240+161.34","v":19137.1104829}]
["Biogas production: 900 Nm3/day","1 Nm3",{"$f":"D6*E6*365","v":6570000},900,20]
["Algae-based biogas upgrade with HRAP, flow rate: 0.05 m3/day","1 Nm3",280390.07999999996,0.05,40,{"$f":"17160+36000+80640+(2812+8436)*2","v":156296},{"$f":"475","v":475},null,null,{"$f":"374.416896","v":374.41689600000001},{"$f":"190.5","v":190.5},{"$f":"1143","v":1143},{"$f":"515","v":515},{"$f":"64+212+178","v":454},null,null,null,null,null,null,{"$f":"441504+100915.2+1240.416+203564.88","v":747224.49599999993},null,null,{"$f":"538.343082+2882+231.315*2+100+150","v":4132.9730820000004}]
["Pressure swing adsorption: 26,920.7 m3/day","1 Nm3",3248500,{"$f":"633*24","v":15192},20,194684.16000000003,null,null,null,null,1320,null,null,16218.679999999998,null,null,null,null,null,null,184966.92,null,null,42546]
["Raw sewage sludge incineration","kg  ",64000000,{"$f":"C9/40/365","v":4383.5616438356165},20]
["Evaporative system for digestate and sludge, flow rate: 0.427 m3/day","1 m3",5950,0.40699999999999997,40,null,null,228.24439999999998,null,240.25,0.45,null,null,98.8,null,null,null,null,null,null,1083.9000000000001]
["Willow zero-discharge system for wastewater, flow rate: 4 m3/day","1 m3",58400,4,40,2850,null,911.00800000000004,null,1187.5,917.92,null,40,395.2,null,null,null,null,null,null,115632.00000000001,null,null,0.104]
["Sludge Treatment Wetland, flow rate: 0.0225 m3/day","1 m3",328.5,{"$f":"22.5/1000","v":2.2499999999999999E-2},40,null,15.2,6.34,null,71.8,{"$f":"21.6+1.5","v":23.1},null,null,20.5,null,null,null,null,null,null,36,null,null,44.624000000000002]
["Planted filter for outlet water from a HRAP with Phragmites australis, flow rate: 4 m3/day","1 m3",58400,4,40,658,17.410000000000004,93.639400000000023,15,41.8,{"$f":"31.7+0.992","v":32.692},null,null,89.2,null,null,null,null,null,null,null,null,null,{"$f":"25.2+0.026","v":25.225999999999999}]
["Planted filter for outlet water from a HRAP with Arundo donax, flow rate: 4 m3/day","1 m3",58400,4,40,658,17.410000000000004,93.639400000000023,15,41.8,{"$f":"31.7+0.992","v":32.692},null,null,89.2,null,null,null,null,null,null,null,null,null,{"$f":"25.2+0.026","v":25.225999999999999}]
["Planted filter with Phragmites Australis for municipal wastewater, flow rate: 4 m3/day","1 m3",58400,4,40,658,17.91,151.63940000000002,125,41.8,{"$f":"31.7+0.992","v":32.692},null,null,89.2,null,null,null,null,null,null,null,null,null,{"$f":"25.2+0.026","v":25.225999999999999}]
["Conventional chlorination, flow rate: 8 m3/day","1 m3",116800,8,40,{"$f":"556.8+27.84","v":584.64},null,null,null,null,null,5,null,13.6,null,null,null,null,null,null,329.63417906911138,null,null,27.84]
["A. niger-based citric acid production","kg  ",10000000,{"$f":"C17/40/365","v":684.93150684931504}]
["Solar anodic oxidation: 8 m3/day","1 m3",116800,8,40,0,122,14.8,0,0,0,0,10.6,47.6,0,0,0,0,0,0,0,0,0,0]
["no information"]

{"sheet":"Results","index":5,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,7,1,11],[1,12,1,16]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"GWP","EP","AP","HTP","Primary energy demand","Description","INPUT",null,null,null,null,"OUTPUT"]
[null,"kg CO2-eq./FU","kg PO4 eq./FU","kg SO4 eq./FU","kg DCB eq./FU","MJ/FU"]
["Conventional wastewater treatment plant, flow rate: 30,137 m3/day",0.53804044814084695,1.4764066993322399E-2,4.7309643519636603E-3,0.75313764441001696,5.9348730716335698,"This technology contains mechanical, biological and chemical treatment steps for the waste water, and treatment steps for the sludge. The outflow goes directly to the receiving water. The sewage passes through the bar screens for rag removal. Next, the sewage is transported to the grit tanks. In the separator suspended particles such as oils, fats are removed. The settlement tank can remove the larger suspended solids. The aeration tanks provide a location where biological treatment of the sewage takes place. The activated sludge converts organic substances into oxidised products, which are settled out in the secondary clarifiers. Phosphoric acid is used as nutrient for micro-organisms. The cleared overflow in the secondary clarifiers goes to a natural surface water body. The settled solids are pumped to the primary thickener where the solids are thickened. The sludge is pumped to filter presses for dewatering, which use chemical flocculants to separate the water from the solids. Next, the sludge is getting dried with thermal energy. The dried sludge is fed into an incinerator, which produces energy for the wastewater treatment plant.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a."]
["High-rate algae pond with pretreatment and settler, flow rate: 300 m3/day",{"$f":"Parameter_tables!K53/Inputs!$C$4","v":0.11000364084546149},{"$f":"Parameter_tables!L53/Inputs!$C$4","v":9.5866823288444939E-5},{"$f":"Parameter_tables!M53/Inputs!$C$4","v":5.3296865756288184E-4},{"$f":"Parameter_tables!N53/Inputs!$C$4","v":0.48291043733327987},{"$f":"Parameter_tables!O53/Inputs!$C$4","v":1.6761248506199409},"This technology is based on a mixture of algae and bacteria that consume the contaminants in the provided wastewater in a collaborative way. Due to this collaboration aeration is not needed that saves a lot of energy. The plant was designed to treat 300 m3 WW per day. The municipal WW first passes a rotary drum filter selecting out solid particles bigger than 1 mm. This pretreatment phase additionally has two pumps and an open tank to store the sold wastes. From here the filtered WW is continuously led to theraceway ponds with an average flow of 12.5 m3/hour. The raceway ponds have an active surface of 3000 m2, a volume of 900 m3, and are designed to operate at a 36-hour hydraulic retention time. The HRAP uses a new less energy intensive patented mixing system (LEAR) with an effective flow pumped of 0.49 m3/s. In the next step the treated WW from the HRAP is led to the separator (DAFAST), where the algae sludge is flocculated and separated from water fraction. The separator consists of a conical flotation tank, a clear water tank, a collection tank, agitator, three pumps, and a polymere dosing unit. In this phase the coagulant poly-aluminum-chlorid and the flocculant polyacrylamide is added. After separation cleared WW is led to the effluent and sludge with 4% dry matter is delivered from the plant.","BOD [mg/L] 350","COD [mg/L] 800","TSS [mg/L] 500","TKN [mg/L] 67","TP [mg/L] 10","BOD [mg/L] 9","COD [mg/L] 80","TSS [mg/L] 20","TKN [mg/L] 15","TP [mg/L] 1"]
["Sequencing batch reactor with sludge settler, flow rate: 300 m3/day",{"$f":"Parameter_tables!K54/Inputs!$C$5","v":0.27500669633653646},{"$f":"Parameter_tables!L54/Inputs!$C$5","v":1.6440547357798364E-4},{"$f":"Parameter_tables!M54/Inputs!$C$5","v":1.1552444508891727E-3},{"$f":"Parameter_tables!N54/Inputs!$C$5","v":0.46170799794601725},{"$f":"Parameter_tables!O54/Inputs!$C$5","v":4.7820917928464892},"The WW treatment plant was designed to clear a WW inflow of max. 300 m3/day, (1,600 PE).The SBR plant consists of a pretreatment unit with a filter and sand trap, a buffer tank, an SBR tank, and a sludge tank. The WW treated has exclusively municipal origins and first passes a filter, where the larger solid particles are selected out. Then the WW passes a sand trap (7 m3) and a buffer tank (110 m3) with a WW pump. Here is the WW stored for the next cycle in the SBR. Up here this phase is considered as pretreatment. Next, WW is treated in the 884 m3 SBR tank. In this tank 3 cycles of WW treatment are done per day, each lasting for 8 hours following this schedule: filling 57.47 min., anaerobic mixing 120 min., react – aerobic mixing 120 min., anoxic mixing 30 min, settle 90 min., decant 57.47 min., idle 4.8 min. Subsequent to the SBR tank, a sludge tank is included where the settled sludge is treated with the addition of PAM (Praestol) to thicken and to obtain a dry matter content of the sludge comparable to the dry matter content of the algal biomass after separation (i.e. ca. 3.5-4.8%).","BOD [mg/L] 350","COD [mg/L] 800","TSS [mg/L] 500","TKN [mg/L] 67","TP [mg/L] 10","BOD [mg/L] 6.75","COD [mg/L] 28.68","TSS [mg/L] 10","TN [mg/L] 12.35","TP [mg/L] 1.34"]
["Biogas production: 900 Nm3/day",0.27300359465975599,1.7974528011364E-3,2.52904418461559E-3,-9.6402765289138707E-3,2.2678308860182201,"Organic wastes and energy crops of 140 t per day are anaerobically fermented with a pretreatment. Pretreatment means sorting out impurities as well as grinding the material. The fermentation is a continuous two-phase digestion of wet fermentation with mesophilic conditions. Dry matter content is 20%. After the digestion, the digestate is separated into a solid and a liquid phase. The liquid phase is partly reused in the fermentation process. The parasitic electricity consumption of the produced electricity is set to 7.8 %. The electrical efficiency of the CHP is 35 %. Desulphurization is done by a biological scrubber and by impregnated activated carbon.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a."]
["Algae-based biogas upgrade with HRAP, flow rate: 0.05 m3/day",{"$f":"Parameter_tables!K56/Inputs!$C$7","v":0.69657649436526037},{"$f":"Parameter_tables!L56/Inputs!$C$7","v":5.5967527943693767E-3},{"$f":"Parameter_tables!M56/Inputs!$C$7","v":8.7174237560502851E-3},{"$f":"Parameter_tables!N56/Inputs!$C$7","v":6.8060625301810624},{"$f":"Parameter_tables!O56/Inputs!$C$7","v":11.152691128253535},"The Demo scale plant was composed of a 9.6 m3 HRAP with an illuminated surface of 32 m2 interconnected to a 7 m3 settler and a 150 L bubble absorption column. The bubble column was provided with a membrane diffuser AFD-270 located at the bottom of the column. The HRAP was divided by a central wall and baffles in each side of the curvature. The internal recirculation velocity of the cultivation broth in the HRAP was 25 cm s-1, which was provided by 6-blade paddlewheel. The HRAP was fed with raw domestic wastewater at 113 L h-1. This flow rate resulted in an initial hydraulic retention time (HRT) in the HRAP of 3.5 days, which was then increased to 8 days by decreasing the raw wastewater flowrate in order to test the influence of this variable. The cultivation broth was pumped from the HRAP to the settler. The HRT in the settler was 7 hours. The settled biomass was recirculated to the HRAP operated with a flow rate equivalent to 20% of the wastewater inlet flowrate. The clarified effluent from the settler was collected in a 100 L tank before being pumped to the bubble column. The liquid phase with the CO2 and H2S absorbed exited the bottom of the absorption column and returned to the HRAP. On the other hand, the biogas obtained from an anaerobic digester prior to be stored in a gasometer was sparged at the bottom of the bubble column under counter-current flow operation. For this purpose, a vacuum pump was timed in order to obtain the inorganic carbon necessary to maintain a biomass productivity of 53 g m-2 d-1 assuming a C content of 50%. ","WW COD [mg/L] 500","WW TN [mg/L] 500","CH4 [%] 68.4±1.6","CO2 [%] 34.0±1.8","H2S [ppm] 2068±991","WW COD [mg/L] 50","WW TN [mg/L] 500","CH4 [%] 86.8±1.6","CO2 [%] 3.4","H2S [ppm] 62.04"]
["Pressure swing adsorption: 26,920.7 m3/day",{"$f":"Parameter_tables!K57/Inputs!$C$8","v":0.11290858902404899},{"$f":"Parameter_tables!L57/Inputs!$C$8","v":1.0053649440490592E-4},{"$f":"Parameter_tables!M57/Inputs!$C$8","v":6.5944243950051605E-4},{"$f":"Parameter_tables!N57/Inputs!$C$8","v":1.2740825724692626},{"$f":"Parameter_tables!O57/Inputs!$C$8","v":1.4737047465624014},"The biogas upgrade plant is located in Brandis, Saxony, Germany and treats 26920.7 m3 biogas per day. The plant is built together with a biogas plant and uses the pressure swing adsorption (PSA) technology. Since in the PSA technology H2S is irreversibly captured by the adsorbent material, desulfurization has to be placed before PSA. This is done with a biological pretreatment section connected to the technology as a first purification step. After this step, the biogas is filtered with active carbon to remove the rest of H2S. In the third step, the desulfurized biogas is chilled to remove moisture. Then, the dry biogas is compressed and pumped to a pressurized vessel with an adsorbent, in this case active carbon, to temporary adsorb carbon dioxide. In the next step, the purified methane is led to a gas container and the pressurized vessel is revitalized with a slight vacuum which clears the adsorbent from carbon dioxide and from a small fraction of captured methane too. This gas mixture is called waste gas and is burned with a flameless oxidation burner to heat the biogas plant. The purified biogas is injected to the natural gas net. ","CH4 [%] 52.2","CO2 [%] 47","H2S [%] 1",null,null,"CH4 [%] 96","CO2 [%] 3.5","H2S [ppm] 1"]
["Raw sewage sludge incineration",1.3859679800953401E-3,8.8250865183844107E-6,1.2077828005960999E-5,2.2816723365477501E-4,1.4274482797951999E-2,"This technology represents the activity of waste disposal of raw sewage sludge in a municipal solid waste incinerator. The produced slag is landfilled. The calculation comprises direct emissions too.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a."]
["Evaporative system for digestate and sludge, flow rate: 0.427 m3/day",{"$f":"Parameter_tables!K59/Inputs!$C$10","v":6.2899910851227201},{"$f":"Parameter_tables!L59/Inputs!$C$10","v":0.1624804805645822},{"$f":"Parameter_tables!M59/Inputs!$C$10","v":0.21065229609861608},{"$f":"Parameter_tables!N59/Inputs!$C$10","v":161.52166673187224},{"$f":"Parameter_tables!O59/Inputs!$C$10","v":96.311747875459929},"An evaporative system is a constructed treatment wetland with zero discharge. The system is a pit dug into the ground and lined with a 0.5 mm PE film protected by a layer of 180 grams/m2 geotextile on both sides against stabs done by sharp items. There is a bottom drain inside the system for flushing of salt sediments when necessary. The pit is filled up with the soil dug out onsite and a layer of washed sand (grain diameters 0-4 mm) as a distribution layer for wastewater or water from sludge. Wastewater and sludge is distributed at middle of the longer axis of the facility under U-shaped plastic tunnels, e.g. rainwater gutters. They cover a ditch with a volume fitted for at least ten years of sludge. The surface of the site is covered with trees. In subtropical areas Eucalyptus camaldulensis is used and in temperate areas three clones of Salix viminalis (“Tora”, “Björn” and “Jorr”) are usually planted. Water and nutrients distributed on the site with the sludge are absorbed by the plants making room for the next charge. Trees are harvested in a 3-4 year rotation to remove/utilize the nutrients from the facility. Sludge or digestate is applied the system usually dimensioned for 10 year, i.e. sludge with approx. 30% dry matter content has to be removed after 10 years of accumulation in the system. The only energy need is the electricity for pumping. The system was developed, built, and run by the Center for Recirkulering, Denmark.","COD [mg/L] 10000","TN [mg/L] 1600","TP [mg/L] 250",null,null,"n.a.","TN [mg/L] 3.3","TP [mg/L] 4.2"]
["Willow zero-discharge system for wastewater, flow rate: 4 m3/day",{"$f":"Parameter_tables!K60/Inputs!$C$11","v":3.4342354988000405},{"$f":"Parameter_tables!L60/Inputs!$C$11","v":8.1903074762441963E-2},{"$f":"Parameter_tables!M60/Inputs!$C$11","v":0.10694056548896001},{"$f":"Parameter_tables!N60/Inputs!$C$11","v":81.341054293631728},{"$f":"Parameter_tables!O60/Inputs!$C$11","v":53.938312115321835},"A willow zero-discharge evaporative system is a constructed treatment wetland designed for treating wastewater. The technology is a pit dug into the ground and lined with a 0.5 mm PE liner protected by a layer of 180 grams/m2 geotextile on both sides against stabs done by sharp items. There is a bottom drain inside the system for flushing of salt sediments when necessary. The pit is filled up normally with the soil dug out onsite and a layer of washed sand (grain diameters 0-4 mm) as a distribution layer for wastewater. Before wastewater is distributed the sludge is taken away by a settling tank that is emptied out normally one time per year but in big systems up to 4 times a year. This sludge can be used directly as soil conditioner and fertilizer, incinerated or landfilled. The settled wastewater is distributed in the middle of the longer axis of the facility under U-shaped plastic tunnels, e.g. turned-around rainwater gutters. The width of the tunnel is determined by the amount of distributed materials that can freely percolate into the system without evaporation. The surface of the site is covered with trees. In subtropical areas Eucalyptus camaldulensis is used and in temperate areas three clones of Salix viminalis (“Tora”, “Björn” and “Jorr”) are usually planted. Trees are harvested in a 3-4 year rotation to remove/utilize the nutrients from the facility. If sludge or digestate is applied the system is dimensioned for 10 year. The only energy need is the electricity for pumping. The system was developed, built, and run by the Center for Recirkulering, Denmark.","COD [mg/L] 587.6","TN [mg/L] 86.22","TP [mg/L] 6.2",null,null,"no discharge","no discharge","no discharge"]
["Sludge Treatment Wetland, flow rate: 0.0225 m3/day",{"$f":"Parameter_tables!K61/Inputs!$C$12","v":34.67507328943843},{"$f":"Parameter_tables!L61/Inputs!$C$12","v":0.88043701238965399},{"$f":"Parameter_tables!M61/Inputs!$C$12","v":1.1461370147257468},{"$f":"Parameter_tables!N61/Inputs!$C$12","v":887.11580057401181},{"$f":"Parameter_tables!O61/Inputs!$C$12","v":522.59916242182953},"The Sludge Treatment Wetland is a constructed treatment wetland designed for treating wastewater sludge of digestate. The system is a 1.5 m deep pit lined with a 1 mm PE film protected by a layer of 180 g/m2 geotextile on both sides against stabs done by sharp items. The system is dimensioned for a maximum load of 35 kg/m2 sludge in total during first year of operation and 65 kg/m2 of sludge in the following years. The upper geotextile on the surface has to be covered especially in subtropical areas because it can be degraded by the sun. An aerated drain pipe system ending up in an outlet pipe is installed at the bottom of the pit. The outlet pipe is connected with a level pipe in order to adjust the water level in the facility. The drain pipes are covered with 0.2 m layer of coarse gravel, 0.15 m layer of smaller gravel, and finally a layer washed filter sand with a grain diameter of 0-4 or 0- 2 mm. On the surface of the wetland plants are grown. For planting the filter sand is mixed with sludge and then planted with 4-5 shoots Phragmites australis per m2. The sludge is distributed via a fixed pipeline or with a flexible hose. When distributed the sludge stays on top of the sand layer and can even dry out building a hard layer. The hollow stems and roots of the plant Phragmites australis provide aeration for the degrading process, mix the filter material within the system, and fragment the hard surface of sludge. When the sludge layer on the top extends 1 m it is taken out. This layer can have 30% dry matter content. In the next period Phragmites start growing again from the left over roots. The only energy need is the electricity for pumping.","COD [mg/L] 12694","TN [mg/L] 1331","TP [mg/L] 120.8",null,null,"n.a.","n.a.","TP [mg/L] 0.487"]
["Planted filter for outlet water from a HRAP with Phragmites australis, flow rate: 4 m3/day",{"$f":"Parameter_tables!K62/Inputs!$C$13","v":0.12457488483316789},{"$f":"Parameter_tables!L62/Inputs!$C$13","v":2.8864823945636831E-3},{"$f":"Parameter_tables!M62/Inputs!$C$13","v":3.7911533019894515E-3},{"$f":"Parameter_tables!N62/Inputs!$C$13","v":2.916355752026242},{"$f":"Parameter_tables!O62/Inputs!$C$13","v":1.9662185944290385},"A planted filter is a constructed treatment wetland cleaning water with bacteria and recycling 50 % of the outlet water back to the surface of the system. The recycled water is mixed with fresh organic matter from newly distributed water from the High Rate Algae Pond in order to have enough carbon for a better denitrification. The planted filter is a lined pit with a PE film protected on both sides by a 180g/m2 geotextile layer against stabs done by sharp items. Each of two systems has a surface of 50 m2. In the bottom is an aerated drain settled into a layer of 0.15 m washed gravel (grain diameters 8-16 mm). Above this is a > 0.5 m layer of washed filter sand (grain diameters 0-4 mm). On top of the sand is a distribution pipe system installed for distributing water equally. The surface of the system is planted with Phragmites australis in a density of 4 plants per m2. Plants can be used for compost harvested in subtropical areas in January before the new stems start growing from the roots. In temperate areas harvest needs to wait until frost has ended, because the biomass protects the facility from low temperatures. Nevertheless the biomass production is low. The output water is led to a well before discharge where N and P can be adsorbed and recycled. The only energy need is for distributing the inlet water with a pump. ","COD [mg/L] 68.36","TN [mg/L] 45.2","Orto-P [mg/L] 0.686",null,null,"COD [mg/L] 32.76","TN [mg/L] 41.3","Orto-P [mg/L] 2.232"]
["Planted filter for outlet water from a HRAP with Arundo donax, flow rate: 4 m3/day",{"$f":"Parameter_tables!K63/Inputs!$C$14","v":0.12457488483316789},{"$f":"Parameter_tables!L63/Inputs!$C$14","v":2.8864823945636831E-3},{"$f":"Parameter_tables!M63/Inputs!$C$14","v":3.7911533019894515E-3},{"$f":"Parameter_tables!N63/Inputs!$C$14","v":2.916355752026242},{"$f":"Parameter_tables!O63/Inputs!$C$14","v":1.9662185944290385},"A planted filter is a constructed treatment wetland clearing water with bacteria and recycling 50 % of the outlet water back to the surface of the system. The recycled water is mixed with fresh organic matter from newly distributed water from the High Rate Algae Pond in order to have enough carbon for a better denitrification. The planted filter is a lined pit with a PE film protected on both sides by a 180g/m2 geotextile layer against stabs done by sharp items. The system has a surface of 50 m2. In the bottom is an aerated drain settled into a layer of 0.15 m washed gravel (grain diameters 8-16 mm). Above this is a > 0.5 m layer of washed filter sand (grain diameters 0-4 mm). On top of the sand is a distribution pipe system installed for distributing water equally. The surface of the system is planted with Arundo donax in a density of 3 plants per m2. Plants can be used for compost harvested in subtropical areas in January before the new stems start growing from the roots. In temperate areas harvest needs to wait until frost has ended, because the biomass protects the facility from low temperatures. The biomass production can be very high. The output water is led to a well before discharge where N and P can be adsorbed and recycled. The only energy need is for distributing the inlet water with a pump. ","COD [mg/L] 68.36","TN [mg/L] 45.2","Orto-P [mg/L] 0.686",null,null,"COD [mg/L] 31.34","TN [mg/L] 33.78","Orto-P [mg/L] 1.98"]
["Planted filter with Phragmites Australis for municipal wastewater, flow rate: 4 m3/day",{"$f":"Parameter_tables!K64/Inputs!$C$15","v":0.12944058619209622},{"$f":"Parameter_tables!L64/Inputs!$C$15","v":2.8876455700824416E-3},{"$f":"Parameter_tables!M64/Inputs!$C$15","v":3.8017417335703555E-3},{"$f":"Parameter_tables!N64/Inputs!$C$15","v":2.9167603458967366},{"$f":"Parameter_tables!O64/Inputs!$C$15","v":2.1175333085605565},"A planted filter is a constructed treatment wetland cleaning water with bacteria and recycling 50 % of the outlet water back to the system. This outlet water is led to a mixing well where it is mixed with fresh organic matter from the municipal wastewater in order to have enough carbon for a better denitrification. The system input is municipal wastewater first led to a rotating grid with 1 mm holes, then to a settling tank and finally to a pump well for distribution. The outlet is led to a split well where half of the water goes back to the pump well and the other half run out. In that way 10 % of the water is recycled. The planted filter is a lined pit with a PE film protected on both sides by a 180g/m2 geotextile layer against stabs done by sharp items. The system has a surface of 50 m2. In the bottom is an aerated drain settled into a layer of 0.15 m washed gravel (grain diameters 8-16 mm). Above this is a > 0.5 m layer of washed filter sand (grain diameters 0-4 mm). On top of the sand is a distribution pipe system installed for distributing water equally. The surface of the system is planted with Phragmites australis in a density of 4 plants per m2. Plants can be used for compost harvested in subtropical areas in January before the new stems start growing from the roots. In temperate areas harvest needs to wait until frost has ended, because the biomass protects the facility from low temperatures. The biomass production is relatively high. The output water is led to a well where N and P can be adsorbed and recycled. The only energy need is for distributing the inlet water with a pump. The system was developed by Hans Brix, Aarhus University, Denmark.","COD [mg/L] 578.6","TN [mg/L] 86.22","Orto-P [mg/L] 6.212",null,null,"COD [mg/L] 161.6","TN [mg/L] 60.22","Orto-P [mg/L] 9.338"]
["Conventional chlorination, flow rate: 8 m3/day",1.3673205705051297E-3,4.2308957801784261E-7,4.3068605985637273E-6,1.3946053861242512E-3,1.8028525995056804E-2,"This chlorination unit was plant to have the same purification effect as the anodic oxidation technology. Thus, it works with a concentration of 10.5 mg/L chlorine in a sodium hypochlorite solution. The technology comprises a concrete contact tank of 1.2x0.8 m in a zig-zag format to guarantee 15 minute contact time of water with chlorine. In addition, a dosing pump and a 100 L PE tank for storing the sodium hypochlorite solution is included. The cleaned wastewater is led to the contact tank where it is mixed with the appropriate amount of chlorine and then it is discharged to the effluent.","COD [mg/L] 20-40","Turbidity [NTU] 5","Pathogens 100000",0,0,"COD [mg/L] 20-30","Turbidity [NTU] 0.15-0.3","Pathogens 0"]
["A. niger-based citric acid production",27.172319060028698,5.0397259438794202E-2,0.206158211576456,16.598611729979901,326.85446855417098,"Citric acid is produced by a submerged fermentation process which employs a strain of the micro-organism Aspergillus niger to convert sugar into citric acid: The carbohydrate substrate (glucose syrup or sugar), which is made from European corn or sugar beet, is heat treated and inoculated with Aspergillus niger. After the fermentation the biological solids (mycelium) are removed. Then citric acid is recovered from the remaining broth and the resulting citric acid solution is purified by ion exchange and carbon treatment. Finally the citric acid solution is evaporated, and citric acid is crystallized, dried and sieved. Energy (natural gas and electricity) is used in Europe. Steam is generated by modern evaporation facilities.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a."]
["Solar anodic oxidation: 8 m3/day",6.1069073204799637E-3,2.636482018755524E-6,2.5976947294384262E-5,1.0059302121791557E-2,0.11452452533040779,"The disinfection of treated wastewater is required for different reuse options, among them for irrigation, sanitation (flushing, washing), cooling, and other industrial needs. \nThese reuse applications require an additional residual disinfection treatment step based on chlorination. Especially in small scale remote wastewater treatment applications chlorine is not easily available and storage as well as handling requires special security measures. In those cases the electrolytic onsite chlorine production poses an environmentally friendly, safe and economic alternative. The by AUTARCON developed technology produces a diluted (<0.5 g/L) chlorine solution at the site of treatment using the natural chloride content of the treated wastewater and solar produced electricity. The solution is then dosed into the treated wastewater to meet the required residual disinfectant concentration – generally in the range of 0.5 - 1 mg/L. An integrated online sensor setting assures that pathogen indicator organisms are completely absent (0 CFU/100ml), allowing reuse applications, with strictest requirements on the water quality. Prior to the disinfection process the wastewater is filtrated using Activated Filtration Media to achieve turbidity rates below 0.5 NTU. About 1% of the disinfected wastewater is de-hardened and then reused for the production of the chlorine solution. All operational data are transferred online allowing remote supervision of the disinfection system and the water quality. The station operates completely autonomous, which includes backwashing of the filter, regenerating the softener, and the chlorine production as well as its dosing. This way, maintenance intervals can be reduced to an annual system and sensor performance checkup, which does not require special technical skills.","COD [mg/L] 20-40","Turbidity [NTU] 5","Pathogens 100000",0,0,"COD [mg/L] 20-30","Turbidity [NTU] 0.15-0.3","Pathogens 0",0,0]
["no information"]

{"sheet":"Parameter_tables","index":6,"n_rows":86,"n_cols":33,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"GWP","EP","AP","HTP","PE","Costs"]
["Construction",null,null,null,null,null,null,null,"€/unit"]
["Circulating pump 250-1000W, kg","Pump","Pumps",{"$f":"VLOOKUP($B3,LCA_variables!$A$2:$F$24,2,FALSE)","v":3.8305551682551},{"$f":"VLOOKUP($B3,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.2679734419800701E-3},{"$f":"VLOOKUP($B3,LCA_variables!$A$2:$F$24,4,FALSE)","v":1.6310240891866199E-2},{"$f":"VLOOKUP($B3,LCA_variables!$A$2:$F$24,5,FALSE)","v":8.3172091681993692},{"$f":"VLOOKUP($B3,LCA_variables!$A$2:$F$24,6,FALSE)","v":54.459634633891298},11]
["PVC Pipe, kg","PVC_pipe","PVC pipes",{"$f":"VLOOKUP($B4,LCA_variables!$A$2:$F$24,2,FALSE)","v":3.3203249900464602},{"$f":"VLOOKUP($B4,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.19454712628066E-3},{"$f":"VLOOKUP($B4,LCA_variables!$A$2:$F$24,4,FALSE)","v":1.4801351085148001E-2},{"$f":"VLOOKUP($B4,LCA_variables!$A$2:$F$24,5,FALSE)","v":6.2699094229076904},{"$f":"VLOOKUP($B4,LCA_variables!$A$2:$F$24,6,FALSE)","v":65.859118767786399},14]
["HDPE Pipe, kg","HDPE_pipe","HDPE pipes",{"$f":"VLOOKUP($B5,LCA_variables!$A$2:$F$24,2,FALSE)","v":2.0206785436920001},{"$f":"VLOOKUP($B5,LCA_variables!$A$2:$F$24,3,FALSE)","v":4.8913160147916602E-4},{"$f":"VLOOKUP($B5,LCA_variables!$A$2:$F$24,4,FALSE)","v":4.3893663203704997E-3},{"$f":"VLOOKUP($B5,LCA_variables!$A$2:$F$24,5,FALSE)","v":0.169262847815526},{"$f":"VLOOKUP($B5,LCA_variables!$A$2:$F$24,6,FALSE)","v":82.918443158772007},6.2]
["Glass fibre reinforced pipe, kg","GFR_pipe","Glass fibre reinforced PE pipes",{"$f":"VLOOKUP($B6,LCA_variables!$A$2:$F$24,2,FALSE)","v":1.5027040121114099},{"$f":"VLOOKUP($B6,LCA_variables!$A$2:$F$24,3,FALSE)","v":3.5420494405989899E-4},{"$f":"VLOOKUP($B6,LCA_variables!$A$2:$F$24,4,FALSE)","v":3.2398225654614002E-3},{"$f":"VLOOKUP($B6,LCA_variables!$A$2:$F$24,5,FALSE)","v":9.7055292292209397E-2},{"$f":"VLOOKUP($B6,LCA_variables!$A$2:$F$24,6,FALSE)","v":36.314364024436003},18]
["Concrete with concrete pumping, kg","Concrete","Concrete",{"$f":"VLOOKUP($B7,LCA_variables!$A$2:$F$24,2,FALSE)","v":9.0822291961504195E-2},{"$f":"VLOOKUP($B7,LCA_variables!$A$2:$F$24,3,FALSE)","v":2.7543897746763902E-5},{"$f":"VLOOKUP($B7,LCA_variables!$A$2:$F$24,4,FALSE)","v":1.7191631256922301E-4},{"$f":"VLOOKUP($B7,LCA_variables!$A$2:$F$24,5,FALSE)","v":2.6135125225518599E-2},{"$f":"VLOOKUP($B7,LCA_variables!$A$2:$F$24,6,FALSE)","v":0.50527631191706801},4.3846500721500717E-2]
["Steel components, kg","Steel","Steel components",{"$f":"VLOOKUP($B8,LCA_variables!$A$2:$F$24,2,FALSE)","v":6.1406628043058902},{"$f":"VLOOKUP($B8,LCA_variables!$A$2:$F$24,3,FALSE)","v":6.89687965873465E-3},{"$f":"VLOOKUP($B8,LCA_variables!$A$2:$F$24,4,FALSE)","v":4.1429019413693001E-2},{"$f":"VLOOKUP($B8,LCA_variables!$A$2:$F$24,5,FALSE)","v":93.960627313493703},{"$f":"VLOOKUP($B8,LCA_variables!$A$2:$F$24,6,FALSE)","v":76.800686740490093}]
["PVC film, kg","PVC_film","PVC plastic parts",{"$f":"VLOOKUP($B9,LCA_variables!$A$2:$F$24,2,FALSE)","v":3.2615970199138},{"$f":"VLOOKUP($B9,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.19191137653651E-3},{"$f":"VLOOKUP($B9,LCA_variables!$A$2:$F$24,4,FALSE)","v":1.45640282909743E-2},{"$f":"VLOOKUP($B9,LCA_variables!$A$2:$F$24,5,FALSE)","v":6.4751076511184804},{"$f":"VLOOKUP($B9,LCA_variables!$A$2:$F$24,6,FALSE)","v":68.100673284426406},8]
["PP film, kg","PP_film","PP plastic parts",{"$f":"VLOOKUP($B10,LCA_variables!$A$2:$F$24,2,FALSE)","v":3.24164036327937},{"$f":"VLOOKUP($B10,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.18042754882308E-3},{"$f":"VLOOKUP($B10,LCA_variables!$A$2:$F$24,4,FALSE)","v":1.59228167792261E-2},{"$f":"VLOOKUP($B10,LCA_variables!$A$2:$F$24,5,FALSE)","v":2.73953034529709E-2},{"$f":"VLOOKUP($B10,LCA_variables!$A$2:$F$24,6,FALSE)","v":97.709135362438801},6.72]
["Glass fibre reinforced polyamide, kg","GFR_plastic","Glass fibre reinforced PE parts",{"$f":"VLOOKUP($B11,LCA_variables!$A$2:$F$24,2,FALSE)","v":9.0534582821516203},{"$f":"VLOOKUP($B11,LCA_variables!$A$2:$F$24,3,FALSE)","v":8.9256289475718592E-3},{"$f":"VLOOKUP($B11,LCA_variables!$A$2:$F$24,4,FALSE)","v":3.6510615434123699E-2},{"$f":"VLOOKUP($B11,LCA_variables!$A$2:$F$24,5,FALSE)","v":1.09370676193922},{"$f":"VLOOKUP($B11,LCA_variables!$A$2:$F$24,6,FALSE)","v":143.60193411307901},18]
["Photovoltaics, electric installation for 3kWp module, at building, kW","PV_install","PV installation",{"$f":"VLOOKUP($B12,LCA_variables!$A$2:$F$24,2,FALSE)","v":151.753207507121},{"$f":"VLOOKUP($B12,LCA_variables!$A$2:$F$24,3,FALSE)","v":4.0228435735350896},{"$f":"VLOOKUP($B12,LCA_variables!$A$2:$F$24,4,FALSE)","v":5.2046032238179096},{"$f":"VLOOKUP($B12,LCA_variables!$A$2:$F$24,5,FALSE)","v":3996.6141849835199},{"$f":"VLOOKUP($B12,LCA_variables!$A$2:$F$24,6,FALSE)","v":2273.9104672404701},{"$f":"5000/3","v":1666.6666666666667}]
["Electricity grid mix EU 28, MJ","Electricity","Electricity",{"$f":"VLOOKUP($B13,LCA_variables!$A$2:$F$24,2,FALSE)","v":0.115889567588735},{"$f":"VLOOKUP($B13,LCA_variables!$A$2:$F$24,3,FALSE)","v":3.0669157757711998E-5},{"$f":"VLOOKUP($B13,LCA_variables!$A$2:$F$24,4,FALSE)","v":3.2731055879038601E-4},{"$f":"VLOOKUP($B13,LCA_variables!$A$2:$F$24,5,FALSE)","v":6.4334546567663001E-3},{"$f":"VLOOKUP($B13,LCA_variables!$A$2:$F$24,6,FALSE)","v":2.2120664120437201},2.8000000000000001E-2]
["Electricity from photovoltaic, MJ","PV_electricity","PV electricity",{"$f":"VLOOKUP($B14,LCA_variables!$A$2:$F$24,2,FALSE)","v":1.3420762070429901E-2},{"$f":"VLOOKUP($B14,LCA_variables!$A$2:$F$24,3,FALSE)","v":4.2653849631350497E-6},{"$f":"VLOOKUP($B14,LCA_variables!$A$2:$F$24,4,FALSE)","v":5.3374373928954899E-5},{"$f":"VLOOKUP($B14,LCA_variables!$A$2:$F$24,5,FALSE)","v":9.7264424538513992E-3},{"$f":"VLOOKUP($B14,LCA_variables!$A$2:$F$24,6,FALSE)","v":0.18820821945549701},0.1]
["Process steam from natural gas, MJ","Steam","Heat",{"$f":"VLOOKUP($B15,LCA_variables!$A$2:$F$24,2,FALSE)","v":7.8472298187877501E-2},{"$f":"VLOOKUP($B15,LCA_variables!$A$2:$F$24,3,FALSE)","v":7.8820776072244104E-6},{"$f":"VLOOKUP($B15,LCA_variables!$A$2:$F$24,4,FALSE)","v":4.4572606026695799E-5},{"$f":"VLOOKUP($B15,LCA_variables!$A$2:$F$24,5,FALSE)","v":4.6632265891982097E-3},{"$f":"VLOOKUP($B15,LCA_variables!$A$2:$F$24,6,FALSE)","v":1.4497645686568901},{"$f":"49.53/3.6/1000","v":1.3758333333333332E-2}]
["Polyacrylamide, kg","PAM","Coagulants Polyacrylamide",{"$f":"VLOOKUP($B16,LCA_variables!$A$2:$F$24,2,FALSE)","v":2.8771335595026102},{"$f":"VLOOKUP($B16,LCA_variables!$A$2:$F$24,3,FALSE)","v":8.7527180164251005E-3},{"$f":"VLOOKUP($B16,LCA_variables!$A$2:$F$24,4,FALSE)","v":1.6687149072093101E-2},{"$f":"VLOOKUP($B16,LCA_variables!$A$2:$F$24,5,FALSE)","v":1.3237161868995699},{"$f":"VLOOKUP($B16,LCA_variables!$A$2:$F$24,6,FALSE)","v":69.743472991058496},{"$f":"2412.93/1000","v":2.4129299999999998}]
["Polyether polyol, kg","PEP","Polyether polyol",{"$f":"VLOOKUP($B17,LCA_variables!$A$2:$F$24,2,FALSE)","v":3.6642387612401701},{"$f":"VLOOKUP($B17,LCA_variables!$A$2:$F$24,3,FALSE)","v":5.6648363638783002E-3},{"$f":"VLOOKUP($B17,LCA_variables!$A$2:$F$24,4,FALSE)","v":1.39786254781585E-2},{"$f":"VLOOKUP($B17,LCA_variables!$A$2:$F$24,5,FALSE)","v":1.3892373929733},{"$f":"VLOOKUP($B17,LCA_variables!$A$2:$F$24,6,FALSE)","v":88.965810485775705}]
["Limestone flour, kg","Lime","Limestone",{"$f":"VLOOKUP($B18,LCA_variables!$A$2:$F$24,2,FALSE)","v":2.49096543722418E-2},{"$f":"VLOOKUP($B18,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.0563299917843501E-5},{"$f":"VLOOKUP($B18,LCA_variables!$A$2:$F$24,4,FALSE)","v":4.7918853969185003E-5},{"$f":"VLOOKUP($B18,LCA_variables!$A$2:$F$24,5,FALSE)","v":1.44665701155162E-3},{"$f":"VLOOKUP($B18,LCA_variables!$A$2:$F$24,6,FALSE)","v":0.37301429125378799},1.25]
["Sodium silicate, kg","Sodium_silicate","Sodium silicate",{"$f":"VLOOKUP($B19,LCA_variables!$A$2:$F$24,2,FALSE)","v":0.79012827955319898},{"$f":"VLOOKUP($B19,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.09458769995385E-3},{"$f":"VLOOKUP($B19,LCA_variables!$A$2:$F$24,4,FALSE)","v":4.3554703779002902E-3},{"$f":"VLOOKUP($B19,LCA_variables!$A$2:$F$24,5,FALSE)","v":0.63145657924475196},{"$f":"VLOOKUP($B19,LCA_variables!$A$2:$F$24,6,FALSE)","v":7.9302350138973701},1.2067000000000001]
["Process water, kg","P_water","Process water",{"$f":"VLOOKUP($B20,LCA_variables!$A$2:$F$24,2,FALSE)","v":1.2432970201363999E-3},{"$f":"VLOOKUP($B20,LCA_variables!$A$2:$F$24,3,FALSE)","v":9.9372393906605102E-7},{"$f":"VLOOKUP($B20,LCA_variables!$A$2:$F$24,4,FALSE)","v":3.24022012714799E-6},{"$f":"VLOOKUP($B20,LCA_variables!$A$2:$F$24,5,FALSE)","v":6.6195661864580801E-5},{"$f":"VLOOKUP($B20,LCA_variables!$A$2:$F$24,6,FALSE)","v":2.1147787371140699E-2},1.91]
["Polyaluminum chloride, kg","PAC18","Flocculant PAC18%",{"$f":"VLOOKUP($B21,LCA_variables!$A$2:$F$24,2,FALSE)","v":0.86541088672447197},{"$f":"VLOOKUP($B21,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.1121198044814599E-3},{"$f":"VLOOKUP($B21,LCA_variables!$A$2:$F$24,4,FALSE)","v":6.9097234327798593E-3},{"$f":"VLOOKUP($B21,LCA_variables!$A$2:$F$24,5,FALSE)","v":0.57891731439688099},{"$f":"VLOOKUP($B21,LCA_variables!$A$2:$F$24,6,FALSE)","v":12.686322025687101},{"$f":"241.29/1000","v":0.24129}]
[]
[]
["Reference systems"]
["treatment of raw sewage sludge, municipal incineration, kg","Sludge",null,{"$f":"VLOOKUP($B25,LCA_variables!$A$2:$F$24,2,FALSE)","v":8.0283824593506303E-2},{"$f":"VLOOKUP($B25,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.0322010292213601E-3},{"$f":"VLOOKUP($B25,LCA_variables!$A$2:$F$24,4,FALSE)","v":4.7663083239294799E-4},{"$f":"VLOOKUP($B25,LCA_variables!$A$2:$F$24,5,FALSE)","v":2.81036228682182E-2},{"$f":"VLOOKUP($B25,LCA_variables!$A$2:$F$24,6,FALSE)","v":0.47632441994930702}]
["treatment of wastewater, average, capacity 1.1E10l/year, m3","WW",null,{"$f":"VLOOKUP($B26,LCA_variables!$A$2:$F$24,2,FALSE)","v":0.53804044814084695},{"$f":"VLOOKUP($B26,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.4764066993322399E-2},{"$f":"VLOOKUP($B26,LCA_variables!$A$2:$F$24,4,FALSE)","v":4.7309643519636603E-3},{"$f":"VLOOKUP($B26,LCA_variables!$A$2:$F$24,5,FALSE)","v":0.75313764441001696},{"$f":"VLOOKUP($B26,LCA_variables!$A$2:$F$24,6,FALSE)","v":5.9348730716335698}]
["citric acid production, kg","CA",null,{"$f":"VLOOKUP($B27,LCA_variables!$A$2:$F$24,2,FALSE)","v":27.172319060028698},{"$f":"VLOOKUP($B27,LCA_variables!$A$2:$F$24,3,FALSE)","v":5.0397259438794202E-2},{"$f":"VLOOKUP($B27,LCA_variables!$A$2:$F$24,4,FALSE)","v":0.206158211576456},{"$f":"VLOOKUP($B27,LCA_variables!$A$2:$F$24,5,FALSE)","v":16.598611729979901},{"$f":"VLOOKUP($B27,LCA_variables!$A$2:$F$24,6,FALSE)","v":326.85446855417098}]
["Biogas from biomass mix for bioenergy (2015), kg","Biogas",null,{"$f":"VLOOKUP($B28,LCA_variables!$A$2:$F$24,2,FALSE)","v":0.27300359465975599},{"$f":"VLOOKUP($B28,LCA_variables!$A$2:$F$24,3,FALSE)","v":1.7974528011364E-3},{"$f":"VLOOKUP($B28,LCA_variables!$A$2:$F$24,4,FALSE)","v":2.52904418461559E-3},{"$f":"VLOOKUP($B28,LCA_variables!$A$2:$F$24,5,FALSE)","v":-9.6402765289138707E-3},{"$f":"VLOOKUP($B28,LCA_variables!$A$2:$F$24,6,FALSE)","v":2.2678308860182201}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,null,null,null,null,null,null,null,null,null,"GWP","EP","AP","HTP","PE",null,"Conventional wastewater treatment plant","High-rate algae pond with pretreatment and settler ","Sequencing batch reactor with sludge settler","Biogas production - def??","Algae-based biogas upgrade with HRAP","Pressure swing adsorption","Raw sewage sludge incineration","Evaporative system for digestate and sludge","Willow zero-discharge system for wastewater","Sludge Treatment Wetland","Planted filter for outlet water from a HRAP with Phragmites australis","Planted filter for outlet water from a HRAP with Arundo donax","Planted filter with Phragmites Australis for municipal wastewater","Conventional chlorination","A. niger-based citric acid production","Solar anodic oxidation",{"$f":"J68","v":"New technology"}]
[null,null,null,null,null,null,null,null,null,"Concrete",{"$f":"VLOOKUP($J32,$C$3:$H$21,2,FALSE)","v":9.0822291961504195E-2},{"$f":"VLOOKUP($J32,$C$3:$H$21,3,FALSE)","v":2.7543897746763902E-5},{"$f":"VLOOKUP($J32,$C$3:$H$21,4,FALSE)","v":1.7191631256922301E-4},{"$f":"VLOOKUP($J32,$C$3:$H$21,5,FALSE)","v":2.6135125225518599E-2},{"$f":"VLOOKUP($J32,$C$3:$H$21,6,FALSE)","v":0.50527631191706801},null,{"$f":"TRANSPOSE(Inputs!F3:X19)","v":0},758912.4,335154.39999999997,0,156296,194684.16000000003,0,0,2850,0,658,658,658,584.64,0,0,{"$f":"New_tech!D56","v":50}]
[null,null,null,null,null,null,null,null,null,"PVC pipes",{"$f":"VLOOKUP($J33,$C$3:$H$21,2,FALSE)","v":3.3203249900464602},{"$f":"VLOOKUP($J33,$C$3:$H$21,3,FALSE)","v":1.19454712628066E-3},{"$f":"VLOOKUP($J33,$C$3:$H$21,4,FALSE)","v":1.4801351085148001E-2},{"$f":"VLOOKUP($J33,$C$3:$H$21,5,FALSE)","v":6.2699094229076904},{"$f":"VLOOKUP($J33,$C$3:$H$21,6,FALSE)","v":65.859118767786399},null,0,631.66,249.8,0,475,0,0,0,0,15.2,17.410000000000004,17.410000000000004,17.91,0,0,122,{"$f":"New_tech!D57","v":0}]
[null,null,null,null,null,null,null,null,null,"HDPE pipes",2.0206785436920001,4.8913160147916602E-4,4.3893663203704997E-3,0.169262847815526,82.918443158772007,null,0,343.56,0,0,0,0,0,228.24439999999998,911.00800000000004,6.34,93.639400000000023,93.639400000000023,151.63940000000002,0,0,14.8,{"$f":"New_tech!D58","v":56}]
[null,null,null,null,null,null,null,null,null,"Glass fibre reinforced PE pipes",1.5027040121114099,3.5420494405989899E-4,3.2398225654614002E-3,9.7055292292209397E-2,36.314364024436003,null,0,0,0,0,0,0,0,0,0,0,15,15,125,0,0,0,{"$f":"New_tech!D59","v":0}]
[null,null,null,null,null,null,null,null,null,"PV installation",151.753207507121,4.0228435735350896,5.2046032238179096,3996.6141849835199,2273.9104672404701,null,0,0,0,0,374.41689600000001,0,0,240.25,1187.5,71.8,41.8,41.8,41.8,0,0,0,{"$f":"New_tech!D60","v":0}]
[null,null,null,null,null,null,null,null,null,"PP plastic parts",3.24164036327937,1.18042754882308E-3,1.59228167792261E-2,2.73953034529709E-2,97.709135362438801,null,0,1143,0,0,190.5,1320,0,0.45,917.92,23.1,32.692,32.692,32.692,0,0,0,{"$f":"New_tech!D61","v":0}]
[null,null,null,null,null,null,null,null,null,"PVC plastic parts",3.2615970199138,1.19191137653651E-3,1.45640282909743E-2,6.4751076511184804,68.100673284426406,null,0,6858,0,0,1143,0,0,0,0,0,0,0,0,5,0,0,{"$f":"New_tech!D62","v":0}]
[null,null,null,null,null,null,null,null,null,"Glass fibre reinforced PE parts",9.0534582821516203,8.9256289475718592E-3,3.6510615434123699E-2,1.09370676193922,143.60193411307901,null,0,890.24,0,0,515,0,0,0,40,0,0,0,0,0,0,10.6,{"$f":"New_tech!D63","v":0}]
[null,null,null,null,null,null,null,null,null,"Pumps",3.8305551682551,1.2679734419800701E-3,1.6310240891866199E-2,8.3172091681993692,54.459634633891298,null,0,861.8,1120,0,454,16218.679999999998,0,98.8,395.2,20.5,89.2,89.2,89.2,13.6,0,47.6,{"$f":"New_tech!D64","v":200}]
[null,null,null,null,null,null,null,null,null,"Flocculant PAC18%",0.86541088672447197,1.1121198044814599E-3,6.9097234327798593E-3,0.57891731439688099,12.686322025687101,null,0,82100,255063,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D65","v":0}]
[null,null,null,null,null,null,null,null,null,"Coagulants Polyacrylamide",2.8771335595026102,8.7527180164251005E-3,1.6687149072093101E-2,1.3237161868995699,69.743472991058496,null,0,12264,9217,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D66","v":1460000}]
[null,null,null,null,null,null,null,null,null,"Polyether polyol",3.6642387612401701,5.6648363638783002E-3,1.39786254781585E-2,1.3892373929733,88.965810485775705,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D67","v":0}]
[null,null,null,null,null,null,null,null,null,"Limestone",2.49096543722418E-2,1.0563299917843501E-5,4.7918853969185003E-5,1.44665701155162E-3,0.37301429125378799,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D68","v":0}]
[null,null,null,null,null,null,null,null,null,"Sodium silicate",0.79012827955319898,1.09458769995385E-3,4.3554703779002902E-3,0.63145657924475196,7.9302350138973701,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D69","v":0}]
[null,null,null,null,null,null,null,null,null,"Process water",1.2432970201363999E-3,9.9372393906605102E-7,3.24022012714799E-6,6.6195661864580801E-5,2.1147787371140699E-2,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D70","v":0}]
[null,null,null,null,null,null,null,null,null,"Electricity",0.115889567588735,3.0669157757711998E-5,3.2731055879038601E-4,6.4334546567663001E-3,2.2120664120437201,null,0,1188702.926,6939389.2600000007,0,747224.49599999993,184966.92,0,1083.9000000000001,115632.00000000001,36,0,0,0,329.63417906911138,0,0,{"$f":"New_tech!D71","v":5256000}]
[null,null,null,null,null,null,null,null,null,"PV electricity",1.3420762070429901E-2,4.2653849631350497E-6,5.3374373928954899E-5,9.7264424538513992E-3,{"$f":"VLOOKUP($J48,$C$3:$H$21,6,FALSE)","v":0.18820821945549701},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D72","v":0}]
[null,null,null,null,null,null,null,null,null,"Heat",7.8472298187877501E-2,7.8820776072244104E-6,4.4572606026695799E-5,4.6632265891982097E-3,1.4497645686568901,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"New_tech!D73","v":0}]
[null,null,null,null,null,null,null,null,null,"Steel components",6.1406628043058902,6.89687965873465E-3,4.1429019413693001E-2,93.960627313493703,76.800686740490093,null,0,20937.548327999997,19137.1104829,0,4132.9730820000004,42546,0,0,0.104,44.624000000000002,25.225999999999999,25.225999999999999,25.225999999999999,27.84,0,0,{"$f":"New_tech!D74","v":10}]
[null,null,null,null,null,null,null,null,"Reference flow"]
[null,null,null,null,null,null,null,null,440000000,"Conventional wastewater treatment plant, flow rate: 30,137 m3/day",{"$f":"SUMPRODUCT(K$32:K$49,$Q$32:$Q$49)","v":0},{"$f":"SUMPRODUCT(L$32:L$49,$Q$32:$Q$49)","v":0},{"$f":"SUMPRODUCT(M$32:M$49,$Q$32:$Q$49)","v":0},{"$f":"SUMPRODUCT(N$32:N$49,$Q$32:$Q$49)","v":0},{"$f":"SUMPRODUCT(O$32:O$49,$Q$32:$Q$49)","v":0}]
[null,null,null,null,null,null,null,null,4380000,"High-rate algae pond with pretreatment and settler, flow rate: 300 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$R$32:$R$50)","v":481815.94690312131},{"$f":"SUMPRODUCT(L$32:L$50,$R$32:$R$50)","v":419.89668600338882},{"$f":"SUMPRODUCT(M$32:M$50,$R$32:$R$50)","v":2334.4027201254225},{"$f":"SUMPRODUCT(N$32:N$50,$R$32:$R$50)","v":2115147.7155197659},{"$f":"SUMPRODUCT(O$32:O$50,$R$32:$R$50)","v":7341426.8457153412}]
[null,null,null,null,null,null,null,null,4380000,"Sequencing batch reactor with sludge settler, flow rate: 300 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$S$32:$S$50)","v":1204529.3299540298},{"$f":"SUMPRODUCT(L$32:L$50,$S$32:$S$50)","v":720.09597427156837},{"$f":"SUMPRODUCT(M$32:M$50,$S$32:$S$50)","v":5059.9706948945768},{"$f":"SUMPRODUCT(N$32:N$50,$S$32:$S$50)","v":2022281.0310035555},{"$f":"SUMPRODUCT(O$32:O$50,$S$32:$S$50)","v":20945562.052667622}]
[null,null,null,null,null,null,null,null,6570000,"Biogas production: 900 Nm3/day",{"$f":"SUMPRODUCT(K$32:K$50,$T$32:$T$50)","v":0},{"$f":"SUMPRODUCT(L$32:L$50,$T$32:$T$50)","v":0},{"$f":"SUMPRODUCT(M$32:M$50,$T$32:$T$50)","v":0},{"$f":"SUMPRODUCT(N$32:N$50,$T$32:$T$50)","v":0},{"$f":"SUMPRODUCT(O$32:O$50,$T$32:$T$50)","v":0}]
[null,null,null,null,null,null,null,null,280390.07999999996,"Algae-based biogas upgrade with HRAP, flow rate: 0.05 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$U$32:$U$50)","v":195313.13898119488},{"$f":"SUMPRODUCT(L$32:L$50,$U$32:$U$50)","v":1569.2739637534528},{"$f":"SUMPRODUCT(M$32:M$50,$U$32:$U$50)","v":2444.2791443528395},{"$f":"SUMPRODUCT(N$32:N$50,$U$32:$U$50)","v":1908352.4173224703},{"$f":"SUMPRODUCT(O$32:O$50,$U$32:$U$50)","v":3127103.9576662984}]
[null,null,null,null,null,null,null,null,3248500,"Pressure swing adsorption: 26,920.7 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$V$32:$V$50)","v":366783.55144462315},{"$f":"SUMPRODUCT(L$32:L$50,$V$32:$V$50)","v":326.59280207433687},{"$f":"SUMPRODUCT(M$32:M$50,$V$32:$V$50)","v":2142.1987647174265},{"$f":"SUMPRODUCT(N$32:N$50,$V$32:$V$50)","v":4138857.2366663995},{"$f":"SUMPRODUCT(O$32:O$50,$V$32:$V$50)","v":4787329.8692079606}]
[null,null,null,null,null,null,null,null,64000000,"Raw sewage sludge incineration",{"$f":"SUMPRODUCT(K$32:K$50,$W$32:$W$50)","v":0},{"$f":"SUMPRODUCT(L$32:L$50,$W$32:$W$50)","v":0},{"$f":"SUMPRODUCT(M$32:M$50,$W$32:$W$50)","v":0},{"$f":"SUMPRODUCT(N$32:N$50,$W$32:$W$50)","v":0},{"$f":"SUMPRODUCT(O$32:O$50,$W$32:$W$50)","v":0}]
[null,null,null,null,null,null,null,null,5950,"Evaporative system for digestate and sludge, flow rate: 0.427 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$X$32:$X$50)","v":37425.446956480184},{"$f":"SUMPRODUCT(L$32:L$50,$X$32:$X$50)","v":966.75885935926408},{"$f":"SUMPRODUCT(M$32:M$50,$X$32:$X$50)","v":1253.3811617867657},{"$f":"SUMPRODUCT(N$32:N$50,$X$32:$X$50)","v":961053.91705463978},{"$f":"SUMPRODUCT(O$32:O$50,$X$32:$X$50)","v":573054.89985898661}]
[null,null,null,null,null,null,null,null,58400,"Willow zero-discharge system for wastewater, flow rate: 4 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$Y$32:$Y$50)","v":200559.35312992235},{"$f":"SUMPRODUCT(L$32:L$50,$Y$32:$Y$50)","v":4783.1395661266106},{"$f":"SUMPRODUCT(M$32:M$50,$Y$32:$Y$50)","v":6245.3290245552644},{"$f":"SUMPRODUCT(N$32:N$50,$Y$32:$Y$50)","v":4750317.5707480926},{"$f":"SUMPRODUCT(O$32:O$50,$Y$32:$Y$50)","v":3149997.4275347954}]
[null,null,null,null,null,null,null,null,328.5,"Sludge Treatment Wetland, flow rate: 0.0225 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$Z$32:$Z$50)","v":11390.761575580524},{"$f":"SUMPRODUCT(L$32:L$50,$Z$32:$Z$50)","v":289.22355857000133},{"$f":"SUMPRODUCT(M$32:M$50,$Z$32:$Z$50)","v":376.50600933740782},{"$f":"SUMPRODUCT(N$32:N$50,$Z$32:$Z$50)","v":291417.5404885629},{"$f":"SUMPRODUCT(O$32:O$50,$Z$32:$Z$50)","v":171673.824855571}]
[null,null,null,null,null,null,null,null,58400,"Planted filter for outlet water from a HRAP with Phragmites australis, flow rate: 4 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$AA$32:$AA$50)","v":7275.1732742570048},{"$f":"SUMPRODUCT(L$32:L$50,$AA$32:$AA$50)","v":168.57057184251909},{"$f":"SUMPRODUCT(M$32:M$50,$AA$32:$AA$50)","v":221.40335283618396},{"$f":"SUMPRODUCT(N$32:N$50,$AA$32:$AA$50)","v":170315.17591833253},{"$f":"SUMPRODUCT(O$32:O$50,$AA$32:$AA$50)","v":114827.16591465585}]
[null,null,null,null,null,null,null,null,58400,"Planted filter for outlet water from a HRAP with Arundo donax, flow rate: 4 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$AB$32:$AB$50)","v":7275.1732742570048},{"$f":"SUMPRODUCT(L$32:L$50,$AB$32:$AB$50)","v":168.57057184251909},{"$f":"SUMPRODUCT(M$32:M$50,$AB$32:$AB$50)","v":221.40335283618396},{"$f":"SUMPRODUCT(N$32:N$50,$AB$32:$AB$50)","v":170315.17591833253},{"$f":"SUMPRODUCT(O$32:O$50,$AB$32:$AB$50)","v":114827.16591465585}]
[null,null,null,null,null,null,null,null,58400,"Planted filter with Phragmites Australis for municipal wastewater, flow rate: 4 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$AC$32:$AC$50)","v":7559.3302336184197},{"$f":"SUMPRODUCT(L$32:L$50,$AC$32:$AC$50)","v":168.6385012928146},{"$f":"SUMPRODUCT(M$32:M$50,$AC$32:$AC$50)","v":222.02171724050876},{"$f":"SUMPRODUCT(N$32:N$50,$AC$32:$AC$50)","v":170338.80420036943},{"$f":"SUMPRODUCT(O$32:O$50,$AC$32:$AC$50)","v":123663.94521993649}]
[null,null,null,null,null,null,null,null,116800,"Conventional chlorination, flow rate: 8 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$AD$32:$AD$50)","v":330.65909510687516},{"$f":"SUMPRODUCT(L$32:L$50,$AD$32:$AD$50)","v":0.24142599241165669},{"$f":"SUMPRODUCT(M$32:M$50,$AD$32:$AD$50)","v":1.6564252183894563},{"$f":"SUMPRODUCT(N$32:N$50,$AD$32:$AD$50)","v":2778.7537735069773},{"$f":"SUMPRODUCT(O$32:O$50,$AD$32:$AD$50)","v":4243.8629550778787}]
[null,null,null,null,null,null,null,null,10000000,"A. niger-based citric acid production",{"$f":"SUMPRODUCT(K$32:K$50,$AE$32:$AE$50)","v":0},{"$f":"SUMPRODUCT(L$32:L$50,$AE$32:$AE$50)","v":0},{"$f":"SUMPRODUCT(M$32:M$50,$AE$32:$AE$50)","v":0},{"$f":"SUMPRODUCT(N$32:N$50,$AE$32:$AE$50)","v":0},{"$f":"SUMPRODUCT(O$32:O$50,$AE$32:$AE$50)","v":0}]
[null,null,null,null,null,null,null,null,116800,"Solar anodic oxidation: 8 m3/day",{"$f":"SUMPRODUCT(K$32:K$50,$AF$32:$AF$50)","v":713.28677503205972},{"$f":"SUMPRODUCT(L$32:L$50,$AF$32:$AF$50)","v":0.30794109979064521},{"$f":"SUMPRODUCT(M$32:M$50,$AF$32:$AF$50)","v":3.0341074439840816},{"$f":"SUMPRODUCT(N$32:N$50,$AF$32:$AF$50)","v":1174.9264878252538},{"$f":"SUMPRODUCT(O$32:O$50,$AF$32:$AF$50)","v":13376.46455859163}]
[null,null,null,null,null,null,null,null,null,{"$f":"New_tech!B51","v":"New technology"},{"$f":"SUMPRODUCT(K$32:K$50,$AG$32:$AG$50)","v":4810675.7808949417},{"$f":"SUMPRODUCT(L$32:L$50,$AG$32:$AG$50)","v":12940.516729204734},{"$f":"SUMPRODUCT(M$32:M$50,$AG$32:$AG$50)","v":26087.512680960277},{"$f":"SUMPRODUCT(N$32:N$50,$AG$32:$AG$50)","v":1969053.7041318496},{"$f":"SUMPRODUCT(O$32:O$50,$AG$32:$AG$50)","v":113468420.25907387}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Conventional wastewater treatment plant, flow rate: 30,137 m3/day",{"$f":"K52/$I52","v":0},{"$f":"L52/$I52","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,"High-rate algae pond with pretreatment and settler, flow rate: 300 m3/day",0.11000364084546149,9.5866823288444939E-5,5.3296865756288184E-4,0.48291043733327987,1.6761248506199409]
[null,null,null,null,null,null,null,null,null,"Sequencing batch reactor with sludge settler, flow rate: 300 m3/day",0.27500669633653646,{"$f":"L54/$I54","v":1.6440547357798364E-4},1.1552444508891727E-3,0.46170799794601725,4.7820917928464892]
[null,null,null,null,null,null,null,null,null,"Biogas production: 900 Nm3/day",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Algae-based biogas upgrade with HRAP, flow rate: 0.05 m3/day",0.69657649436526037,5.5967527943693767E-3,8.7174237560502851E-3,6.8060625301810624,11.152691128253535]
[null,null,null,null,null,null,null,null,null,"Pressure swing adsorption: 26,920.7 m3/day",0.11290858902404899,1.0053649440490592E-4,6.5944243950051605E-4,1.2740825724692626,1.4737047465624014]
[null,null,null,null,null,null,null,null,null,"Raw sewage sludge incineration",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Evaporative system for digestate and sludge, flow rate: 0.427 m3/day",6.2899910851227201,0.1624804805645822,0.21065229609861608,161.52166673187224,96.311747875459929]
[null,null,null,null,null,null,null,null,null,"Willow zero-discharge system for wastewater, flow rate: 4 m3/day",3.4342354988000405,8.1903074762441963E-2,0.10694056548896001,81.341054293631728,53.938312115321835]
[null,null,null,null,null,null,null,null,null,"Sludge Treatment Wetland, flow rate: 0.0225 m3/day",34.67507328943843,0.88043701238965399,1.1461370147257468,887.11580057401181,522.59916242182953]
[null,null,null,null,null,null,null,null,null,"Planted filter for outlet water from a HRAP with Phragmites australis, flow rate: 4 m3/day",0.12457488483316789,2.8864823945636831E-3,3.7911533019894515E-3,2.916355752026242,1.9662185944290385]
[null,null,null,null,null,null,null,null,null,"Planted filter for outlet water from a HRAP with Arundo donax, flow rate: 4 m3/day",0.12457488483316789,2.8864823945636831E-3,3.7911533019894515E-3,2.916355752026242,1.9662185944290385]
[null,null,null,null,null,null,null,null,null,"Planted filter with Phragmites Australis for municipal wastewater, flow rate: 4 m3/day",0.12944058619209622,2.8876455700824416E-3,3.8017417335703555E-3,2.9167603458967366,2.1175333085605565]
[null,null,null,null,null,null,null,null,null,"Conventional chlorination, flow rate: 8 m3/day",2.8309854033122875E-3,2.0670033596888414E-6,1.4181722760183702E-5,2.3790700115641928E-2,3.6334443108543481E-2]
[null,null,null,null,null,null,null,null,null,"A. niger-based citric acid production",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Solar anodic oxidation: 8 m3/day",6.1069073204799637E-3,2.636482018755524E-6,2.5976947294384262E-5,1.0059302121791557E-2,0.11452452533040779]

{"sheet":"LCA_variables","index":7,"n_rows":78,"n_cols":23,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"kg CO2 eq.","kg Phosphate eq.","kg SO2 eq.","kg DCB eq.","MJ"]
["Biogas",0.27300359465975599,1.7974528011364E-3,2.52904418461559E-3,-9.6402765289138707E-3,2.2678308860182201]
["CA",27.172319060028698,5.0397259438794202E-2,0.206158211576456,16.598611729979901,326.85446855417098]
["Concrete",9.0822291961504195E-2,2.7543897746763902E-5,1.7191631256922301E-4,2.6135125225518599E-2,0.50527631191706801]
["Electricity",0.115889567588735,3.0669157757711998E-5,3.2731055879038601E-4,6.4334546567663001E-3,2.2120664120437201]
["GFR_pipe",1.5027040121114099,3.5420494405989899E-4,3.2398225654614002E-3,9.7055292292209397E-2,36.314364024436003]
["GFR_plastic",9.0534582821516203,8.9256289475718592E-3,3.6510615434123699E-2,1.09370676193922,143.60193411307901]
["HDPE_pipe",2.0206785436920001,4.8913160147916602E-4,4.3893663203704997E-3,0.169262847815526,82.918443158772007]
["Lime",2.49096543722418E-2,1.0563299917843501E-5,4.7918853969185003E-5,1.44665701155162E-3,0.37301429125378799]
["PAM",2.8771335595026102,8.7527180164251005E-3,1.6687149072093101E-2,1.3237161868995699,69.743472991058496]
["PEP",3.6642387612401701,5.6648363638783002E-3,1.39786254781585E-2,1.3892373929733,88.965810485775705]
["PP_film",3.24164036327937,1.18042754882308E-3,1.59228167792261E-2,2.73953034529709E-2,97.709135362438801]
["Steam",7.8472298187877501E-2,7.8820776072244104E-6,4.4572606026695799E-5,4.6632265891982097E-3,1.4497645686568901]
["P_water",1.2432970201363999E-3,9.9372393906605102E-7,3.24022012714799E-6,6.6195661864580801E-5,2.1147787371140699E-2]
["Pump",3.8305551682551,1.2679734419800701E-3,1.6310240891866199E-2,8.3172091681993692,54.459634633891298]
["PV_electricity",1.3420762070429901E-2,4.2653849631350497E-6,5.3374373928954899E-5,9.7264424538513992E-3,0.18820821945549701]
["PV_install",151.753207507121,4.0228435735350896,5.2046032238179096,3996.6141849835199,2273.9104672404701]
["PVC_film",3.2615970199138,1.19191137653651E-3,1.45640282909743E-2,6.4751076511184804,68.100673284426406]
["PVC_pipe",3.3203249900464602,1.19454712628066E-3,1.4801351085148001E-2,6.2699094229076904,65.859118767786399]
["Sludge",8.0283824593506303E-2,1.0322010292213601E-3,4.7663083239294799E-4,2.81036228682182E-2,0.47632441994930702]
["Sodium_silicate",0.79012827955319898,1.09458769995385E-3,4.3554703779002902E-3,0.63145657924475196,7.9302350138973701]
["WW",0.53804044814084695,1.4764066993322399E-2,4.7309643519636603E-3,0.75313764441001696,5.9348730716335698]
["PAC18",{"$f":"B59/1000","v":0.86541088672447197},{"$f":"B63/1000","v":1.1121198044814599E-3},{"$f":"B67/1000","v":6.9097234327798593E-3},{"$f":"B71/1000","v":0.57891731439688099},{"$f":"B75/1000","v":12.686322025687101}]
["Steel",6.1406628043058902,6.89687965873465E-3,4.1429019413693001E-2,93.960627313493703,76.800686740490093]
[]
[]
[]
[]
[]
[]
["CML2001 - Jan. 2016, Global Warming Potential (GWP 100 years), excl biogenic carbon","kg CO2 eq."]
[]
[null,"Biogas","CA","Concrete","Electricity","GFR_pipe","GFR_plastic","HDPE_pipe","Lime","PAM","PEP","PP_film","Steam","P_water","Pump","PV_electricity","PV_install","PVC_film","PVC_pipe","Sludge","Sodium_silicate","WW","Steel_components"]
["Flows",0.27300359465975599,27.172319060028698,9.0822291961504195E-2,0.115889567588735,1.5027040121114099,9.0534582821516203,2.0206785436920001,2.49096543722418E-2,2.8771335595026102,3.6642387612401701,3.24164036327937,7.8472298187877501E-2,1.2432970201363999E-3,3.8305551682551,1.3420762070429901E-2,151.753207507121,3.2615970199138,3.3203249900464602,1.3859679800953401E-3,0.79012827955319898,0.53804044814084695,6.1406628043058902]
[]
["CML2001 - Jan. 2016, Eutrophication Potential (EP)","kg Phosphate eq."]
[]
[null,"Biogas","CA","Concrete","Electricity","GFR_pipe","GFR_plastic","HDPE_pipe","Lime","PAM","PEP","PP_film","Steam","P_water","Pump","PV_electricity","PV_install","PVC_film","PVC_pipe","Sludge","Sodium_silicate","WW","Steel_components"]
["Flows",1.7974528011364E-3,5.0397259438794202E-2,2.7543897746763902E-5,3.0669157757711998E-5,3.5420494405989899E-4,8.9256289475718592E-3,4.8913160147916602E-4,1.0563299917843501E-5,8.7527180164251005E-3,5.6648363638783002E-3,1.18042754882308E-3,7.8820776072244104E-6,9.9372393906605102E-7,1.2679734419800701E-3,4.2653849631350497E-6,4.0228435735350896,1.19191137653651E-3,1.19454712628066E-3,8.8250865183844107E-6,1.09458769995385E-3,1.4764066993322399E-2,6.89687965873465E-3]
[]
["CML2001 - Jan. 2016, Acidification Potential (AP)","kg SO2 eq."]
[]
[null,"Biogas","CA","Concrete","Electricity","GFR_pipe","GFR_plastic","HDPE_pipe","Lime","PAM","PEP","PP_film","Steam","P_water","Pump","PV_electricity","PV_install","PVC_film","PVC_pipe","Sludge","Sodium_silicate","WW","Steel_components"]
["Flows",2.52904418461559E-3,0.206158211576456,1.7191631256922301E-4,3.2731055879038601E-4,3.2398225654614002E-3,3.6510615434123699E-2,4.3893663203704997E-3,4.7918853969185003E-5,1.6687149072093101E-2,1.39786254781585E-2,1.59228167792261E-2,4.4572606026695799E-5,3.24022012714799E-6,1.6310240891866199E-2,5.3374373928954899E-5,5.2046032238179096,1.45640282909743E-2,1.4801351085148001E-2,1.2077828005960999E-5,4.3554703779002902E-3,4.7309643519636603E-3,4.1429019413693001E-2]
[]
["CML2001 - Jan. 2016, Human Toxicity Potential (HTP inf.)","kg DCB eq."]
[]
[null,"Biogas","CA","Concrete","Electricity","GFR_pipe","GFR_plastic","HDPE_pipe","Lime","PAM","PEP","PP_film","Steam","P_water","Pump","PV_electricity","PV_install","PVC_film","PVC_pipe","Sludge","Sodium_silicate","WW","Steel_components"]
["Flows",-9.6402765289138707E-3,16.598611729979901,2.6135125225518599E-2,6.4334546567663001E-3,9.7055292292209397E-2,1.09370676193922,0.169262847815526,1.44665701155162E-3,1.3237161868995699,1.3892373929733,2.73953034529709E-2,4.6632265891982097E-3,6.6195661864580801E-5,8.3172091681993692,9.7264424538513992E-3,3996.6141849835199,6.4751076511184804,6.2699094229076904,2.2816723365477501E-4,0.63145657924475196,0.75313764441001696,93.960627313493703]
[]
["Primary energy from non renewable resources (gross cal. value)","MJ"]
[]
[null,"Biogas","CA","Concrete","Electricity","GFR_pipe","GFR_plastic","HDPE_pipe","Lime","PAM","PEP","PP_film","Steam","P_water","Pump","PV_electricity","PV_install","PVC_film","PVC_pipe","Sludge","Sodium_silicate","WW","Steel_components"]
["Flows",2.2678308860182201,326.85446855417098,0.50527631191706801,2.2120664120437201,36.314364024436003,143.60193411307901,82.918443158772007,0.37301429125378799,69.743472991058496,88.965810485775705,97.709135362438801,1.4497645686568901,2.1147787371140699E-2,54.459634633891298,0.18820821945549701,2273.9104672404701,68.100673284426406,65.859118767786399,1.4274482797951999E-2,7.9302350138973701,5.9348730716335698,76.800686740490093]
[]
[]
["CML2001 - Jan. 2016, Global Warming Potential (GWP 100 years), excl biogenic carbon","kg CO2 eq."]
[null,"EU-28: Water treatment UFZ <LC>"]
["Flows",865.41088672447199]
[]
["CML2001 - Jan. 2016, Eutrophication Potential (EP)","kg Phosphate eq."]
[null,"EU-28: Water treatment UFZ <LC>"]
["Flows",1.11211980448146]
[]
["CML2001 - Jan. 2016, Acidification Potential (AP)","kg SO2 eq."]
[null,"EU-28: Water treatment UFZ <LC>"]
["Flows",6.9097234327798596]
[]
["CML2001 - Jan. 2016, Human Toxicity Potential (HTP inf.)","kg DCB eq."]
[null,"EU-28: Water treatment UFZ <LC>"]
["Flows",578.91731439688101]
[]
["Primary energy from non renewable resources (gross cal. value)","MJ"]
[null,"EU-28: Water treatment UFZ <LC>"]
["Flows",12686.322025687101]
[]
[]
["CML2001 - Jan. 2016, Global Warming Potential (GWP 100 years), excl biogenic carbon","kg CO2 eq."]

{"sheet":"Pictures","index":8,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["https://www.youtube.com/watch?v=rTyZmSHDLBA",null,null,{"$f":"Ref_sys!B5","v":"Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"}]
["Conventional wastewater treatment plant, flow rate: 30,137 m3/day","no picture available"]
["High-rate algae pond with pretreatment and settler, flow rate: 300 m3/day"]
["Sequencing batch reactor with sludge settler, flow rate: 300 m3/day"]
["Biogas production: 900 Nm3/day"]
["Algae-based biogas upgrade with HRAP, flow rate: 0.05 m3/dy"]
["Pressure swing adsorption: 26,920.7 m3/day"]
["Raw sewage sludge incineration"]
["Evaporative system for digestate and sludge, flow rate: 0.427 m3/day"]
["Willow zero-discharge system for wastewater, flow rate: 4 m3/day"]
["Sludge Treatment Wetland, flow rate: 0.0225 m3/day"]
["Planted filter for outlet water from a HRAP with Phragmites australis, flow rate: 4 m3/day"]
["Planted filter for outlet water from a HRAP with Arundo donax, flow rate: 4 m3/day"]
["Planted filter with Phragmites Australis for municipal wastewater, flow rate: 4 m3/day"]
["Conventional chlorination, flow rate: 8 m3/day"]
["A. niger-based citric acid production"]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
["Solar anodic oxidation: 8 m3/day"]
["no information"]

{"sheet":"My_techn","index":9,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,7,1,11],[1,12,1,16]]}
[{"$f":"New_tech!B51","v":"New technology"},null,{"$f":"New_tech!$B$9","v":4380000},{"$f":"New_tech!B8","v":300},{"$f":"New_tech!B7","v":40},{"$f":"New_tech!D56","v":50},{"$f":"New_tech!$D57","v":0},{"$f":"New_tech!$D58","v":56},{"$f":"New_tech!$D59","v":0},{"$f":"New_tech!$D60","v":0},{"$f":"New_tech!$D61","v":0},{"$f":"New_tech!$D62","v":0},{"$f":"New_tech!$D63","v":0},{"$f":"New_tech!$D64","v":200},{"$f":"New_tech!$D65","v":0},{"$f":"New_tech!$D66","v":1460000},{"$f":"New_tech!$D67","v":0},{"$f":"New_tech!$D68","v":0},{"$f":"New_tech!$D69","v":0},{"$f":"New_tech!$D70","v":0},{"$f":"New_tech!$D71","v":5256000},{"$f":"New_tech!$D72","v":0},{"$f":"New_tech!$D73","v":0},{"$f":"New_tech!D74","v":10}]
[null,"GWP","EP","AC","HTP","PED","System description","INPUT",null,null,null,null,"OUTPUT"]
[{"$f":"New_tech!B51","v":"New technology"},{"$f":"Parameter_tables!K68/$C$1","v":1.0983278038572926},{"$f":"Parameter_tables!L68/$C$1","v":2.954455874247656E-3},{"$f":"Parameter_tables!M68/$C$1","v":5.9560531235069124E-3},{"$f":"Parameter_tables!N68/$C$1","v":0.44955564021275102},{"$f":"Parameter_tables!O68/$C$1","v":25.906032022619605},{"$f":"New_tech!F82","v":0},{"$f":"New_tech!G82","v":0},{"$f":"New_tech!H82","v":0},{"$f":"New_tech!I82","v":0},{"$f":"New_tech!J82","v":0},{"$f":"New_tech!K82","v":0},{"$f":"New_tech!L82","v":0},{"$f":"New_tech!M82","v":0},{"$f":"New_tech!N82","v":0},{"$f":"New_tech!O82","v":0},{"$f":"New_tech!P82","v":0}]