{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Introduction","Substrate Preparation Unit","Reproduction Unit","Treatment Unit","Processing Unit","Conventional Emissions","Results; Emission per ton waste","Results; Emission per year","Data","ElecMix"],"not_rendered":{"charts":14,"images":10,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Introduction","index":0,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,12,3,13],[35,2,35,8],[36,2,36,8],[37,2,37,8],[4,2,4,8],[2,3,2,7],[3,3,3,7],[33,3,33,7],[39,3,39,7],[47,3,47,7]]}
[]
[]
[null,null,null,"BSFL GHG Emissions Calculator Tool"]
[null,null,null,"Version September 2025; by Johanna Brendow"]
[null,null,"Disclaimer: Eawag and the authors assume no responsibility for errors or omissions in this document or for any actions taken based on the information provided. Eawag and the authors are not liable for any damages arising from the use of this document. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Introduction"]
[]
[null,null,"This tool estimates greenhouse gas (GHG) emissions occurring in black soldier fly (BSF) systems as well as net emissions savings when comparing to landfill disposal or composting.\nFor BSF systems it includes direct biogenic emissions from all life cycle stages of BSF and also the biogenic emissions from frass composting. It further includes indirect emissions of operating a BSF biowaste conversion system, which includes emissions from energy and fuel consumption. Following LCA principles of “cradle to gate”, the systems boundaries include: (i) the collection and pre-processing of the waste, (ii) the reproduction unit of BSF,  (iii) the bioconversion of waste by the BSFL, and (iv) post-processing of BSF larvae and frass."]
[null,null,"The scope of this tool is to focus on simplified small to medium scale, mainly labour based, non-industrialised BSF biowaste conversion setups and the operational aspects of such systems, that are typical for low and middle-income countries. \nBiogenic emissions are estimated based on values reported in scientific literature or approved methodologies and databases for emissions estimations."]
[null,null,"The tool relies on case specific input data with regard to country and scale of operations!  Use of commonly accessible technologies, equipment and practices are included, whereas high-end industrial equipment (automized processing machinery and technology, or large-scale transport fleets) are not included.\nUse of \"heating, ventilation, and air conditioning (HVAC)\" in the treatment unit is not considered, assuming suitable ambient temperature for BSF conversion! "]
[]
[null,null,null,"How to use the Calculator"]
[]
[]
[null,null,null,"Users must enter data in orange cells ",null,"Users must select an option in blue cells",null,"Users can enter data in green cells"]
[]
[null,null,null,null,null,"If no data is entered, the displayed default value in the white cell is applied."]
[]
[]
[null,null,null,"Please fill general information"]
[]
[null,null,null,"Select country: ",null,"Indonesia",null,"kgCO2eq / kWh"]
[null,null,null,"Select substrate type: ",null,"pig manure (pure)",null,{"$f":"VLOOKUP(Introduction!F50, ElecMix!A:C, 3, FALSE)","v":0.6759309}]
[null,null,null,"Ton waste / day: ",null,10]

{"sheet":"Substrate Preparation Unit","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,3,5,7],[35,3,36,5],[7,6,8,7]]}
[]
[]
[]
[null,null,null,"Substrate Preparation Unit",null,"Select option","Enter data","Optional"]
[]
[null,null,null,"Collection and Transport"]
[]
[null,null,null,"Details","Vehicle type","Driving distance (km/day)","If your facility does not include waste substrate transport, then enter \"0\" in km/day"]
[null,null,null,"Waste Transport","light vehicle",10]
[]
[null,null,null,"Emission","kgCO₂/tkm factor",null,"kgCO₂eq / ton waste ","tonCO₂eq/year"]
[null,null,null,"Transport  ",{"$f":"VLOOKUP(E9, Data!A:B,2, FALSE)","v":0.29799999999999999},null,{"$f":"F9*E12*(5/3)","v":4.9666666666666668},{"$f":"G12*Introduction!F52*365/1000","v":18.128333333333337}]
[null,null,null,"Total emission transport",null,null,{"$f":"G12","v":4.9666666666666668},{"$f":"H12","v":18.128333333333337}]
[]
[null,null,null,"Substrate Pre-processing"]
[]
[null,null,null,"Details","Technique/type","Power of machine (kW)","Hours of use (daily)","kWh / day "]
[null,null,null,"Substrate Size Reduction","manual",null,null,{"$f":"IF(OR(ISBLANK(F18), ISBLANK(G18)),\"\",F18*G18)","v":""}]
[null,null,null,"Substrate Mixing","industrial mixer",null,null,{"$f":"IF(OR(ISBLANK(F19), ISBLANK(G19)),\"\",F19*G19)","v":""}]
[]
[]
[null,null,null,"Are any additives added?","No"]
[]
[null,null,null,"Additive Quantity","kg additive/ ton waste"]
[]
[]
[null,null,null,null,"Vehicle type","Driving distance (km/day)"]
[null,null,null,"Additive Transport","light vehicle"]
[]
[null,null,null,"Emission","kWh / ton waste",null,"kgCO₂eq/ ton waste ","tonCO₂eq/ year "]
[null,null,null,"Substrate Size Reduction",{"$f":"IF(E18=\"manual\", Data!B10, IF(AND(E18=\"electric shredder\", OR(ISBLANK(F18), ISBLANK(G18))), Data!B9,  H18/ Introduction!F52))","v":0},"-",{"$f":"IF(ISNUMBER(#REF!),#REF!* Introduction!H51, E31* Introduction!H51)","v":0},{"$f":"G31*Introduction!F52*365/1000","v":0}]
[null,null,null,"Substrate Mixing",{"$f":"IF(E19=\"manual\", Data!B14, IF(AND(E19=\"industrial mixer\", OR(ISBLANK(F19), ISBLANK(G19))), Data!B13,  H19/ Introduction!F52))","v":17.5},"-",{"$f":"IF(ISNUMBER(#REF!),#REF!* Introduction!H51, E32* Introduction!H51)","v":11.82879075},{"$f":"G32*Introduction!F52*365/1000","v":43.17508623749999}]
[null,null,null,"Bulking agent input","-",{"$f":"IF(E22=\"Yes \",VLOOKUP(E28, Data!A:B,2, FALSE),\"-\")","v":"-"},{"$f":"IF(E22=\"Yes \",F33*F28*(5/3)*E25/1000,0)","v":0},{"$f":"G33*Introduction!F52*365/1000","v":0}]
[null,null,null,"Total emission pre-processing   ",null,null,{"$f":"SUM(G31:G33)","v":11.82879075},{"$f":"SUM(H31:H33)","v":43.17508623749999}]
[]
[null,null,null,"Total GHG Emissions of Substrate Preparation Unit :",null,null," kgCO₂eq/ ton waste :"," tonCO₂eq/ year :"]
[null,null,null,null,null,null,{"$f":"SUM(G13,G34)","v":16.795457416666665},{"$f":"SUM(H13,H34)","v":61.303419570833327}]

{"sheet":"Reproduction Unit","index":2,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[36,3,37,5]]}
[]
[]
[]
[null,null,null,"Reproduction Unit",null,"Select option","Enter data","Optional"]
[]
[]
[null,null,null,"Feed used for the reproduction"]
[]
[null,null,null,"Details","kg feed / kg eggs","g eggs / ton waste"]
[null,null,null,"BSF default preformance",{"$f":"IF(E11=\"\", Data!B26, \"\")","v":37.5},{"$f":"IF(F11=\"\", Data!B28, \"\")","v":57.5}]
[null,null,null,"Own preformance "]
[]
[null,null,null,null,"Type","kg feed / ton waste","Driving distance (km/day)"]
[null,null,null,"Feed","chicken feed (animal mix)",{"$f":"IFERROR((IF(E11<>\"\",E11,E10))*(IF(F11<>\"\",F11,F10)/1000),\"\")","v":2.15625},"-"]
[null,null,null,"Transport /Vehicle","light vehicle","-",10]
[]
[]
[null,null,null,"Emission","kg CO₂ eq / kg feed"," kg CO₂ eq / tkm factor"," kgCO₂eq/ ton waste "," tonCO₂eq/ year"]
[null,null,null,"Feed",{"$f":"VLOOKUP(E14,Data!A:B,2,FALSE)","v":0.97},"-",{"$f":"E19*F14","v":2.0915624999999998},{"$f":"G19*Introduction!F52*365/1000","v":7.6342031249999991}]
[null,null,null,"Transportation ","-",{"$f":"VLOOKUP(E15, Data!A:B,2, FALSE)","v":0.29799999999999999},{"$f":"G15*F20*(5/3)*F14/1000","v":1.0709375E-2},{"$f":"G20*Introduction!F52*365/1000","v":3.9089218750000002E-2}]
[null,null,null,"Total emission Feed ",null,null,{"$f":"SUM(G19:G20)","v":2.1022718749999996},{"$f":"SUM(H19:H20)","v":7.6732923437499991}]
[]
[null,null,null,"Equipment use for reproduction"]
[]
[null,null,null,"Details","Power (Watt)","Amount","Hours of use(daily)"]
[null,null,null,"Ventilation type 1 details"]
[null,null,null,"Ventilation type 2 details"]
[]
[null,null,null,"Lighting type 1 details"]
[null,null,null,"Lighting type 2 details"]
[]
[null,null,null,"Emission","kWh / day","kWh / ton waste"," kgCO₂eq/ ton waste "," tonCO₂eq/ year"]
[null,null,null,"Emission ventilation",{"$f":"IF(OR(ISBLANK(E26), ISBLANK(F26), ISBLANK(G26)),\"\",SUM((E26*F26*G26/1000),E27*F27*G27/1000))","v":""},{"$f":"IF(OR(ISBLANK(E26), ISBLANK(F26), ISBLANK(G26)), Data!B31,  E33/ Introduction!F52)","v":1.76},{"$f":"F33* Introduction!H51","v":1.189638384},{"$f":"G33*Introduction!F52*365/1000","v":4.3421801016000003}]
[null,null,null,"Emission lighting",{"$f":"IF(OR(ISBLANK(E29), ISBLANK(F29), ISBLANK(G29)),\"\",SUM((E29*F29*G29/1000),(E30*F30*G30/1000)))","v":""},{"$f":"IF(OR(ISBLANK(E29), ISBLANK(F29), ISBLANK(G29)), Data!B32, E34/ Introduction!F52)","v":1.1000000000000001},{"$f":"F34*Introduction!H51","v":0.74352399000000002},{"$f":"G34*Introduction!F52*365/1000","v":2.7138625634999998}]
[null,null,null,"Total emission infrastructure ",null,{"$f":"SUM(F33:F34)","v":2.8600000000000003},{"$f":"SUM(G33:G34)","v":1.9331623740000001},7.0560426650999997]
[]
[null,null,null,"Total GHG Emissions of Reproduction Unit :",null,null,"kgCO₂eq/ ton waste:","tonCO₂eq/ year :"]
[null,null,null,null,null,null,{"$f":"SUM(G21,G35)","v":4.0354342489999997},{"$f":"SUM(H21,H35)","v":14.729335008849999}]

{"sheet":"Treatment Unit","index":3,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,3,24,5]]}
[]
[]
[]
[null,null,null,"Treatment Unit",null,null,"Select option","Optional"]
[]
[null,null,null,"BSFL Treatment"]
[]
[null,null,null,"Substrate type","pig manure (pure)"]
[]
[null,null,null,"Emission","g / ton waste",null,"kgCO₂eq/ ton waste ","tonCO₂eq/ year"]
[null,null,null,"Methane (CH₄)",{"$f":"VLOOKUP(E8,Data!A:D,2,FALSE)","v":258.7},null,{"$f":"E11*0.027","v":6.9848999999999997},{"$f":"G11*Introduction!F52*365/1000","v":25.494884999999996}]
[null,null,null,"N₂O",{"$f":"VLOOKUP(E8,Data!A:D,4,FALSE)","v":0.23},null,{"$f":"E12*0.273","v":6.2790000000000012E-2},{"$f":"G12*Introduction!F52*365/1000","v":0.22918350000000004}]
[null,null,null,"Total BSFL treatment",null,null,{"$f":"SUM(G11,G12)","v":7.0476899999999993},{"$f":"SUM(H11,H12)","v":25.724068499999998}]
[]
[null,null,null,"Separation"]
[]
[null,null,null,null," Separation technique","Power of machine (kW)","Hours of use (daily)"]
[null,null,null,"Separation details","automated sieve"]
[]
[null,null,null,null,"kWh / day ","kWh / ton waste","kgCO₂eq/ ton waste ","tonCO₂eq/ year"]
[null,null,null,"Emission ",{"$f":"IF(OR(ISBLANK(F18), ISBLANK(G18)),\"\",F18*G18)","v":""},{"$f":"IF(E18=\"manual sieve\", Data!B44,\n IF(AND(E18=\"automated sieve\", OR(F18=\"\", G18=\"\")), Data!B42,\n  IF(AND(E18=\"pressurized water\", OR(F18=\"\", G18=\"\")), Data!B43,\n   E21/ Introduction!F52))\n)","v":19.5},{"$f":"IF(ISNUMBER(#REF!),#REF!* Introduction!H51, F21*Introduction!H51)","v":13.18065255},{"$f":"G21*Introduction!F52*365/1000","v":48.109381807499993}]
[null,null,null,"Total emission separation",null,null,{"$f":"G21","v":13.18065255},{"$f":"H21","v":48.109381807499993}]
[]
[null,null,null,"Total GHG Emissions of Treatment Unit:",null,null,"kgCO₂eq/ ton waste : ","tonCO₂eq/ year : "]
[null,null,null,null,null,null,{"$f":"SUM(G13,G22)","v":20.228342550000001},{"$f":"SUM(H13,H22)","v":73.833450307499987}]

{"sheet":"Processing Unit","index":4,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,3,24,4]]}
[]
[]
[]
[null,null,null,"Processing Unit",null,"Select option","Optional"]
[]
[null,null,null,"Insect Processing"]
[]
[null,null,null,null,"Type of process","kgCO₂eq / ton waste","tonCO₂eq / year "]
[null,null,null,"Larvae Sanitizing","boiling",{"$f":"VLOOKUP(E9,Data!A:B,2,FALSE)","v":2.88},{"$f":"F9*Introduction!F52*365/1000","v":10.511999999999999}]
[null,null,null,"Larvae Drying","oven",{"$f":"VLOOKUP(E10,Data!A:B,2,FALSE)","v":17.884455683100001},{"$f":"F10*Introduction!F52*365/1000","v":65.278263243314996}]
[null,null,null,"Total emission processing",null,{"$f":"SUM(F9:F10)","v":20.7644556831},{"$f":"SUM(G9:G10)","v":75.790263243314996}]
[]
[null,null,null,"Frass Composting"]
[]
[null,null,null,"Details","Frass type","kg residue / ton waste"]
[null,null,null,"Frass default value","food waste residue",{"$f":"IF(ISNUMBER(F17), \"\",\nIFERROR(VLOOKUP(E16, Data!A:B, 2, FALSE),\"\"))","v":258.86}]
[null,null,null,"Own value",null,null,{"$f":"IF(F17=\"\",\"\",IF(F17<200,\"this value is unrealistic\",\"\"))","v":""}]
[]
[null,null,null,"Emission ","kg / ton waste","kgCO₂eq / ton waste ","tonCO₂eq / year"]
[null,null,null,"Methane (CH₄)",{"$f":"IF(AND(F17<>\"\",ISNUMBER(F17)),F17*VLOOKUP(E16,Data!A:F,4,FALSE)/1000/1000, F16*VLOOKUP(E16,Data!A:F,4,FALSE)/1000/1000)","v":0.51772000000000007},{"$f":"E20*27","v":13.978440000000003},{"$f":"F20*Introduction!F52*365/1000","v":51.02130600000001}]
[null,null,null,"N₂O",{"$f":"IF(AND(F17<>\"\",ISNUMBER(F17)),F17*VLOOKUP(E16,Data!A:F,6,FALSE)/1000/1000, F16*VLOOKUP(E16,Data!A:F,6,FALSE)/1000/1000)","v":5.1771999999999999E-2},{"$f":"E21*273","v":14.133756},{"$f":"F21*Introduction!F52*365/1000","v":51.588209399999997}]
[null,null,null,"Total emission frass composting",null,{"$f":"SUM(F20:F21)","v":28.112196000000004},{"$f":"SUM(G20:G21)","v":102.60951540000001}]
[]
[null,null,null,"Total GHG Emissions of Processing Unit :",null,"kgCO₂eq/ ton waste :","tonCO₂eq/ year :"]
[null,null,null,null,null,{"$f":"SUM(F11,F22)","v":48.876651683100008},{"$f":"SUM(G11,G22)","v":178.39977864331502}]

{"sheet":"Conventional Emissions","index":5,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,2,39,7],[7,6,8,6],[7,3,8,4],[7,5,8,5],[23,3,23,4],[35,3,36,4]]}
[]
[]
[]
[null,null,null,"Conventional Emissions",null,"Select option","Enter data"]
[]
[null,null,null,"Emissions from waste disposal"]
[]
[null,null,null,"How much of your waste would normally go to waste disposal per day? The rest is assumed to go to composting.",null,0.6,{"$f":"ROUND(F8,2)*Introduction!F52&\" ton\"","v":"6 ton"}]
[]
[]
[null,null,null,"Details","Type ","Distance to landfill (km)","kgCO₂ / tkm"]
[null,null,null,"Disposal Site","Unmanaged","-","-"]
[null,null,null,"Waste","food waste","-","-"]
[null,null,null,"Transport ","light vehicle",10,{"$f":"VLOOKUP(E14, Data!A:B,2, FALSE)","v":0.29799999999999999}]
[]
[]
[null,null,null,"Emission","kg/ ton waste","kgCO₂eq/ ton waste ","tonCO₂eq/ year "]
[null,null,null,"Transport ","-",{"$f":"G14*F14*F8*(5/3)","v":2.98},{"$f":"F18*Introduction!F52*F8*365/1000","v":6.5262000000000002}]
[null,null,null,"Methane (CH₄)",{"$f":"INDEX(Data!B69:E70, MATCH(E13, Data!A69:A70, 0), MATCH(E12, Data!B68:E68, 0))*F8","v":25.416},{"$f":"E19*27","v":686.23199999999997},{"$f":"F19*Introduction!F52*F8*365/1000","v":1502.8480799999998}]
[null,null,null,"Total emission landfill",null,{"$f":"SUM(F18:F19)","v":689.21199999999999},{"$f":"SUM(G18:G19)","v":1509.3742799999998}]
[]
[null,null,null,"Emissions from composting"]
[]
[null,null,null,"Amount of waste to composting /day",null,{"$f":"Introduction!F52*(1-F8)","v":4},"ton"]
[]
[null,null,null,"Details","Type","Distance to compost (km)","kgCO₂ / km"]
[null,null,null,"Waste ",{"$f":"E13","v":"food waste"},"-",{"$f":"\"-\"","v":"-"}]
[null,null,null,"Transport ","light vehicle",10,{"$f":"VLOOKUP(E28, Data!A:B,2, FALSE)","v":0.29799999999999999}]
[]
[null,null,null,"Emission","kg / ton waste","kgCO₂ / ton waste","ton CO₂ / year"]
[null,null,null,"Methane (CH₄)",{"$f":"VLOOKUP(E27,Data!A77:D78,2,)*(1-F8)/1000","v":0.8},{"$f":"E31*27","v":21.6},{"$f":"F31*Introduction!F52*365/1000","v":78.84}]
[null,null,null,"N₂O",{"$f":"VLOOKUP(E27,Data!A77:D78,4,)*(1-F8)/1000","v":0.08},{"$f":"E32*273","v":21.84},{"$f":"F32*Introduction!F52*365/1000","v":79.715999999999994}]
[null,null,null,"Transport","-",{"$f":"G28*F28*(5/3)*(1-F8)","v":1.9866666666666668},{"$f":"F33*Introduction!F52*365/1000","v":7.2513333333333341}]
[null,null,null,"Total emission compost",null,{"$f":"SUM(F31:F33)","v":45.426666666666662},{"$f":"SUM(G31:G33)","v":165.8073333333333}]
[]
[null,null,null,"Total Avoided GHG Emissions: ",null,"kgCO₂eq/ ton waste :","tonCO₂eq/ year :"]
[null,null,null,null,null,{"$f":"SUM(F20,F34)","v":734.63866666666661},{"$f":"SUM(G20,G34)","v":1675.1816133333332}]
[]
[]
[null,null,"Emissions reduction by substituting conventional animal feed with BSF larvae is NOT considered in this tool.\nHowever below are some indicative values of emissions from conventional animal feed production"]
[]
[null,null,null,"Emisssions from production of fishmeal ","0.5 - 1.0 kg CO₂-eq per kg","Anchoveta Fishmeal (Peru/Chile, main global source)","(factory gate, including fishing and processing). Source: IFFO (International Fishmeal and Fish Oil Organisation)."]
[null,null,null,"Emisssions from production of soybean meal","0.4 – 0.7 kg CO₂-eq per kg ","Without Land-Use Change","(processing + farming + transport). NOPA / USB Life Cycle Assessment of U.S. Soybeans, Soybean Meal, and Soy Oil (2024)"]

{"sheet":"Results; Emission per ton waste","index":6,"n_rows":77,"n_cols":26,"rows_kept":77,"cut":false,"hidden":false,"merged":[[70,3,70,4],[70,6,70,7],[70,9,70,10],[70,12,70,13],[71,3,71,4],[71,6,71,7],[71,9,71,10],[71,12,71,13],[31,3,31,4],[31,9,31,10],[32,3,32,4],[32,9,32,10],[33,3,33,4],[33,9,33,10],[3,3,3,13],[5,3,5,14],[7,3,7,13],[29,6,29,7],[30,3,30,4],[30,9,30,10]]}
[]
[]
[]
[null,null,null,"GHG Calculator Results "]
[]
[null,null,null,"All emissions in kgCO₂eq / ton waste"]
[]
[null,null,null,{"$f":"\"Total emissions from the BSF conversion facility  =    \"&ROUND(G31,2)&\"    kgCO₂eq/ton waste\"","v":"Total emissions from the BSF conversion facility  =    89.94    kgCO₂eq/ton waste"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Net"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total emissions from BSF facility",null,null,{"$f":"SUM(D72,G72,J72,M72)","v":89.935885898766671},"kgCO₂eq/ ton waste",null,"Energy emissions",null,null,{"$f":"SUM('Substrate Preparation Unit'!G31,'Substrate Preparation Unit'!G32,'Reproduction Unit'!G33,'Reproduction Unit'!G34,'Treatment Unit'!G22,'Processing Unit'!F9,'Processing Unit'!F10)","v":47.707061357100002},"kgCO₂eq/ ton waste"]
[null,null,null,"Avoided landfill emissions ",null,null,{"$f":"-'Conventional Emissions'!F20","v":-689.21199999999999},"kgCO₂eq/ ton waste",null,"Biogenic emissions",null,null,{"$f":"SUM('Treatment Unit'!G13,'Processing Unit'!F22)","v":35.159886},"kgCO₂eq/ ton waste"]
[null,null,null,"Avoided compost emissions",null,null,{"$f":"-'Conventional Emissions'!F34","v":-45.426666666666662},"kgCO₂eq/ ton waste",null,"Emissions from inputs used",null,null,{"$f":"'Reproduction Unit'!G19","v":2.0915624999999998},"kgCO₂eq/ ton waste"]
[null,null,null,"Net avoided emissions ",null,null,{"$f":"G32+G31+G33","v":-644.70278076789998},"kgCO₂eq/ ton waste",null,"Transport emissions",null,null,{"$f":"SUM('Substrate Preparation Unit'!G13,'Substrate Preparation Unit'!G33,'Reproduction Unit'!G20)","v":4.977376041666667},"kgCO₂eq/ ton waste"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Substrate Preparation ",null,null,"Reproduction ",null,null,"Treatment ",null,null,"Processing "]
[null,null,null,{"$f":"'Substrate Preparation Unit'!G37","v":16.795457416666665},null,null,{"$f":"'Reproduction Unit'!G38","v":4.0354342489999997},null,null,{"$f":"'Treatment Unit'!G25","v":20.228342550000001},null,null,{"$f":"'Processing Unit'!F25","v":48.876651683100008}]
[]
[null,null,null,"Waste input",{"$f":"'Substrate Preparation Unit'!G13","v":4.9666666666666668},null,"Ventilation",{"$f":"'Reproduction Unit'!G33","v":1.189638384},null,"Biogenic CH4",{"$f":"'Treatment Unit'!G11","v":6.9848999999999997},null,"Larvae sanitizing",{"$f":"'Processing Unit'!F9","v":2.88}]
[null,null,null,"Size reduction",{"$f":"'Substrate Preparation Unit'!G31","v":0},null,"Lighting",{"$f":"'Reproduction Unit'!G34","v":0.74352399000000002},null,"Biogenic N2O",{"$f":"'Treatment Unit'!G12","v":6.2790000000000012E-2},null,"Larvae drying",{"$f":"'Processing Unit'!F10","v":17.884455683100001}]
[null,null,null,"Mixing",{"$f":"'Substrate Preparation Unit'!G32","v":11.82879075},null,"Feed input",{"$f":"'Reproduction Unit'!G21","v":2.1022718749999996},null,"Separation",{"$f":"'Treatment Unit'!G22","v":13.18065255},null,"Biogenic CH4",{"$f":"'Processing Unit'!F20","v":13.978440000000003}]
[null,null,null,"Additives input",{"$f":"'Substrate Preparation Unit'!G33","v":0},null,null,null,null,null,null,null,"Biogenic N2O",{"$f":"'Processing Unit'!F21","v":14.133756}]

{"sheet":"Results; Emission per year","index":7,"n_rows":77,"n_cols":26,"rows_kept":77,"cut":false,"hidden":false,"merged":[[3,3,3,13],[7,3,7,13],[5,3,5,14],[29,6,29,7],[70,12,70,13],[71,12,71,13],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[70,3,70,4],[71,3,71,4],[70,6,70,7],[71,6,71,7],[70,9,70,10],[71,9,71,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10]]}
[]
[]
[]
[null,null,null,"GHG Calculator Results "]
[]
[null,null,null,"All emission is in tonCO₂eq/ year"]
[]
[null,null,null,{"$f":"\"Total emissions  from the BSF conversion facility =    \"&ROUND(G31,2)&\"    tonCO₂eq/year\"","v":"Total emissions  from the BSF conversion facility =    328.27    tonCO₂eq/year"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Net"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total emissions from BSF facility",null,null,{"$f":"SUM(D72,G72,J72,M72)","v":328.26598353049832},"tonCO₂eq/ year",null,"Energy",null,null,{"$f":"SUM('Substrate Preparation Unit'!H31,'Substrate Preparation Unit'!H32,'Reproduction Unit'!H33,'Reproduction Unit'!H34,'Treatment Unit'!H22,'Processing Unit'!G9,'Processing Unit'!G10)","v":174.13077395341497},"tonCO₂eq/ year"]
[null,null,null,"Avoided landfill emissions ",null,null,{"$f":"-'Conventional Emissions'!G20","v":-1509.3742799999998},"tonCO₂eq/ year",null,"Biogenic",null,null,{"$f":"SUM('Treatment Unit'!H13,'Processing Unit'!G22)","v":128.33358390000001},"tonCO₂eq/ year"]
[null,null,null,"Avoided compost emissions",null,null,{"$f":"-'Conventional Emissions'!G34","v":-165.8073333333333},"tonCO₂eq/ year",null,"Inputs",null,null,{"$f":"'Reproduction Unit'!H19","v":7.6342031249999991},"tonCO₂eq/ year"]
[null,null,null,"Net avoided emissions ",null,null,{"$f":"G32+G31+G33","v":-1346.9156298028347},"tonCO₂eq/ year",null,"Transport",null,null,{"$f":"SUM('Substrate Preparation Unit'!H13,'Substrate Preparation Unit'!H33,'Reproduction Unit'!H20)","v":18.167422552083337},"tonCO₂eq/ year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Substrate Preparation ",null,null,"Reproduction ",null,null,"Treatment ",null,null,"Processing "]
[null,null,null,{"$f":"'Substrate Preparation Unit'!H37","v":61.303419570833327},null,null,{"$f":"'Reproduction Unit'!H38","v":14.729335008849999},null,null,{"$f":"'Treatment Unit'!H25","v":73.833450307499987},null,null,{"$f":"'Processing Unit'!G25","v":178.39977864331502}]
[]
[null,null,null,"Waste input",{"$f":"'Substrate Preparation Unit'!H13","v":18.128333333333337},null,"Ventilation",{"$f":"'Reproduction Unit'!H33","v":4.3421801016000003},null,"Biogenic CH4",{"$f":"'Treatment Unit'!H11","v":25.494884999999996},null,"Larvae sanitizing",{"$f":"'Processing Unit'!G9","v":10.511999999999999}]
[null,null,null,"Size reduction",{"$f":"'Substrate Preparation Unit'!H31","v":0},null,"Lighting",{"$f":"'Reproduction Unit'!H34","v":2.7138625634999998},null,"Biogenic N2O",{"$f":"'Treatment Unit'!H12","v":0.22918350000000004},null,"Larvae drying",{"$f":"'Processing Unit'!G10","v":65.278263243314996}]
[null,null,null,"Mixing",{"$f":"'Substrate Preparation Unit'!H32","v":43.17508623749999},null,"Feed input",{"$f":"'Reproduction Unit'!H21","v":7.6732923437499991},null,"Separation",{"$f":"'Treatment Unit'!H22","v":48.109381807499993},null,"Biogenic CH4",{"$f":"'Processing Unit'!G20","v":51.02130600000001}]
[null,null,null,"Additives input",{"$f":"'Substrate Preparation Unit'!H33","v":0},null,null,null,null,null,null,null,"Biogenic N2O",{"$f":"'Processing Unit'!G21","v":51.588209399999997}]

{"sheet":"Data","index":8,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
["Substrate Preparation Unit"]
["TRANSPORT"]
["options","kgCO2eq/ ton waste"]
["light vehicle",0.29799999999999999]
["medium truck ",0.19400000000000001]
["WASTE SIZE REDUCTION"]
["options","kWh/ ton waste"]
["electric shredder",14.7]
["manual",0]
["SUBSTRATE MIXING"]
["options","kWh/ ton waste"]
["industrial mixer",17.5]
["manual",0]
["BULKING AGENT"]
["options"]
["Any additives added?","Yes "]
[null,"No"]
["Reproduction Unit "]
["FEED TYPE"]
["options","kgCO2eq / kg"]
["maize grain feed",0.64400000000000002]
["chicken feed (animal mix)",0.97]
["chicken feed (vegetarian mix)",1.139]
["feed:eggs ratio","kg feed / kg eggs"]
["kg feed / kg eggs",37.5]
["substrate:eggs ratio","g eggs / ton feed"]
["g eggs / ton feed",57.5]
["INFRASTRUCTURE"]
["options","kWh / ton waste"]
["ventilation",1.76]
["lighting",1.1000000000000001]
[]
["Treatment Unit"]
["BSFL TREATMENT"]
["options","gCH4 / ton waste",null,"gN2O / ton waste"]
["mixed food waste",1.3129999999999999,null,3.484]
["pig manure (pure)",258.7,null,0.23]
["pig manure + corncob",111.14,null,0.22]
["SEPARATION"]
["options","kWh / ton waste"]
["automated sieve",19.5]
["pressurized water",2.93]
["manual sieve",0]
[]
["Processing Unit"]
["SANITIZING"]
["options","kgCO2eq / ton waste"]
["boiling",2.88]
["washing",0]
["DRYING"]
["options","kgCO2/ton waste",null,"kWh/ton raw substrate"]
["oven",{"$f":"D53*Introduction!H51","v":17.884455683100001},null,26.459]
["natural gas",1.794]
["sun drying",0]
["COMPOST "]
["options","kg / ton waste",null,"gCH4 / ton residue",null,"gN2O / ton residue"]
["food waste residue",258.86,null,2000,null,200]
["pig manure residue",476.67,null,2820,null,354]
[]
["Avoided Emissions Unit"]
["TRANSPORT"]
["options","kgCO2eq/ ton waste"]
["light vehicle",0.29799999999999999]
["medium truck ",0.19400000000000001]
["LANDFILL"]
["options","kgCH4 / ton waste"]
["Emissions in kgCH4 / ton waste","Managed well (semi-aerobic)","Managed well (active aeration)","Managed poorly","Unmanaged"]
["food waste",35.299999999999997,28.24,49.42,42.36]
["pig manure ",40.006999999999998,32.005000000000003,56.009,48.008000000000003]
[]
[]
["Percentage to landfill",0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
[]
["COMPOST "]
["options","gCH4 / ton waste",null,"gN2O / ton waste"]
["food waste",2000,null,200]
["pig manure ",2820,null,354]

{"sheet":"ElecMix","index":9,"n_rows":220,"n_cols":3,"rows_kept":220,"cut":false,"hidden":false,"merged":[]}
["Country","gCO2/kWh","kgCO2/kWh"]
["Afghanistan",132.53012000000001,{"$f":"B2/1000","v":0.13253012}]
["Africa",554.15314000000001,{"$f":"B3/1000","v":0.55415314000000004}]
["Albania",24.285715,2.4285714999999999E-2]
["Algeria",634.61099999999999,0.63461100000000004]
["American Samoa",611.11109999999996,0.61111110000000002]
["Angola",174.73436000000001,0.17473436000000001]
["Antigua and Barbuda",611.11109999999996,0.61111110000000002]
["Argentina",354.10287,0.35410287000000001]
["Armenia",264.53814999999997,0.26453814999999997]
["Aruba",561.22450000000003,0.56122450000000002]
["Asia",594.40783999999996,0.59440783999999991]
["Australia",548.69226000000003,0.54869226000000004]
["Austria",110.81243000000001,0.11081243]
["Azerbaijan",671.38904000000002,0.67138903999999999]
["Bahamas",660.09860000000003,0.66009859999999998]
["Bahrain",904.61450000000002,0.90461449999999999]
["Bangladesh",691.41120000000001,0.6914112]
["Barbados",605.50459999999998,0.60550459999999995]
["Belarus",441.74,0.44174000000000002]
["Belgium",138.10679999999999,0.1381068]
["Belize",225.80645999999999,0.22580645999999999]
["Benin",584.07079999999996,0.5840708]
["Bermuda",650.79363999999998,0.65079363999999995]
["Bhutan",23.333334000000001,2.3333334000000001E-2]
["Bolivia",531.68726000000004,0.53168725999999999]
["Bosnia and Herzegovina",600.00005999999996,0.60000005999999995]
["Botswana",847.90869999999995,0.84790869999999996]
["Brazil",98.348240000000004,9.8348240000000003E-2]
["British Virgin Islands",647.05880000000002,0.64705880000000005]
["Brunei",893.91300000000001,0.89391299999999996]
["Bulgaria",335.3338,0.33533380000000002]
["Burkina Faso",467.53250000000003,0.46753250000000002]
["Burundi",250.00002000000001,0.25000001999999999]
["Cambodia",417.70711999999997,0.41770711999999999]
["Cameroon",305.4187,0.30541869999999999]
["Canada",170.04250999999999,0.17004250999999998]
["Cape Verde",558.1395,0.55813950000000001]
["Cayman Islands",642.85709999999995,0.64285709999999996]
["Central African Republic",0,0]
["Chad",628.57140000000004,0.6285714]
["Chile",291.11349999999999,0.29111349999999997]
["China",582.31695999999999,0.58231695999999999]
["Colombia",259.51116999999999,0.25951117000000001]
["Comoros",642.85720000000003,0.64285720000000002]
["Congo",700,0.7]
["Cook Islands",250,0.25]
["Costa Rica",53.377814999999998,5.3377814999999995E-2]
["Cote d'Ivoire",393.88490000000002,0.39388490000000004]
["Croatia",204.96161000000001,0.20496161000000002]
["Cuba",637.6096,0.6376096]
["Cyprus",534.3229,0.53432290000000005]
["Czechia",449.72433000000001,0.44972433000000001]
["Democratic Republic of Congo",24.456524000000002,2.4456524E-2]
["Denmark",151.65029999999999,0.15165029999999999]
["Djibouti",692.30780000000004,0.69230780000000003]
["Dominica",529.41179999999997,0.52941179999999999]
["Dominican Republic",580.7799,0.58077990000000002]
["East Timor",666.66669999999999,0.66666669999999995]
["Ecuador",150.22354000000001,0.15022354000000002]
["Egypt",570.30553999999995,0.57030554]
["El Salvador",271.46816999999999,0.27146817000000001]
["Equatorial Guinea",591.83672999999999,0.59183673000000003]
["Eritrea",631.57889999999998,0.63157889999999994]
["Estonia",416.66669999999999,0.4166667]
["Eswatini",172.41379000000001,0.17241379000000001]
["Ethiopia",24.643318000000001,{"$f":"B67/1000","v":2.4643318000000001E-2}]
["Europe",318.78185999999999,0.31878185999999997]
["European Union (27)",291.85494999999997,0.29185494999999995]
["Falkland Islands",500,0.5]
["Faroe Islands",404.76193000000001,0.40476192999999999]
["Fiji",288.46158000000003,0.28846158000000005]
["Finland",79.158325000000005,7.9158325000000002E-2]
["France",56.038589999999999,5.6038589999999999E-2]
["French Polynesia",442.85714999999999,0.44285714999999998]
["Gabon",491.59661999999997,0.49159661999999998]
["Gambia",666.66669999999999,0.66666669999999995]
["Georgia",167.59388999999999,0.16759389]
["Germany",380.95047,0.38095046999999999]
["Ghana",484.00002999999998,0.48400002999999997]
["Gibraltar",600.00005999999996,0.60000005999999995]
["Greece",336.57351999999997,0.33657351999999996]
["Greenland",178.57142999999999,0.17857143]
["Grenada",640,0.64]
["Guam",622.85720000000003,0.6228572]
["Guatemala",328.26751999999999,0.32826751999999998]
["Guinea",236.84211999999999,0.23684211999999999]
["Guinea-Bissau",625,0.625]
["Guyana",640.35090000000002,0.64035090000000006]
["Haiti",567.30769999999995,0.56730769999999997]
["Honduras",282.26477,0.28226477]
["Hong Kong",699.49914999999999,0.69949914999999996]
["Hungary",204.18994000000001,0.20418994000000001]
["Iceland",27.679918000000001,2.7679918000000001E-2]
["India",713.44069999999999,0.71344070000000004]
["Indonesia",675.93089999999995,0.6759309]
["Iran",655.12494000000004,0.65512493999999999]
["Iraq",688.81395999999995,0.68881395999999995]
["Ireland",290.80500000000001,0.29080499999999998]
["Israel",582.9271,0.58292710000000003]
["Italy",330.71823000000001,0.33071823]
["Jamaica",555.55553999999995,0.55555553999999996]
["Japan",485.39236,0.48539236000000002]
["Jordan",540.92364999999995,0.54092364999999998]
["Kazakhstan",821.39089999999999,0.82139090000000003]
["Kenya",70.491805999999997,7.049180599999999E-2]
["Kiribati",666.66669999999999,0.66666669999999995]
["Kosovo",894.65409999999997,0.89465410000000001]
["Kuwait",649.16340000000002,0.64916340000000006]
["Kyrgyzstan",147.29239999999999,0.14729239999999999]
["Laos",265.50594999999998,0.26550594999999999]
["Latin America and Caribbean (Ember)",258.5933,0.25859330000000003]
["Latvia",123.2,0.1232]
["Lebanon",599.005,0.59900500000000001]
["Lesotho",20,0.02]
["Liberia",227.84810999999999,0.22784810999999999]
["Libya",818.69219999999996,0.81869219999999998]
["Lithuania",160.07194999999999,0.16007194999999999]
["Luxembourg",105.26315,0.10526315]
["Macao",448.97958,0.44897957999999999]
["Madagascar",436.44063999999997,0.43644063999999999]
["Malawi",66.666669999999996,6.6666669999999997E-2]
["Malaysia",605.83136000000002,0.60583136000000004]
["Maldives",611.76469999999995,0.61176469999999994]
["Mali",407.99997000000002,0.40799997000000005]
["Malta",459.14395000000002,0.45914395000000002]
["Mauritania",464.70589999999999,0.46470590000000001]
["Mauritius",632.47864000000004,0.63247864000000009]
["Mexico",507.24511999999999,0.50724511999999999]
["Moldova",643.46349999999995,0.64346349999999997]
["Mongolia",775.30864999999994,{"$f":"B131/1000","v":0.77530864999999993}]
["Montenegro",417.07317999999998,0.41707317999999999]
["Montserrat",1000,1]
["Morocco",630.01415999999995,0.63001415999999999]
["Mozambique",135.64668,0.13564667999999999]
["Myanmar",398.89803999999998,0.39889803999999995]
["Namibia",59.259259999999998,5.9259259999999994E-2]
["Nauru",750,0.75]
["Nepal",24.439920000000001,2.443992E-2]
["Netherlands",267.62177000000003,0.26762177000000004]
["New Caledonia",660.58389999999997,0.6605839]
["New Zealand",112.75830999999999,0.11275831]
["Nicaragua",265.11626999999999,0.26511626999999999]
["Niger",670.88604999999995,0.6708860499999999]
["Nigeria",523.24725000000001,0.52324725000000005]
["North America",365.84262000000001,0.36584262000000001]
["North Korea",389.58706999999998,0.38958706999999998]
["North Macedonia",565.3451,0.56534510000000004]
["Norway",30.080083999999999,3.0080084E-2]
["Oceania",507.69279999999998,0.50769279999999994]
["Oman",564.63495,0.56463494999999997]
["Pakistan",440.60849999999999,0.44060850000000001]
["Palestine",516.12900000000002,0.51612900000000006]
["Panama",161.67665,0.16167665000000001]
["Papua New Guinea",507.24633999999998,0.50724634000000002]
["Paraguay",23.75506,2.3755060000000001E-2]
["Peru",266.47753999999998,0.26647753999999996]
["Philippines",610.68835000000001,0.61068834999999999]
["Poland",661.92583999999999,0.66192583999999999]
["Portugal",165.55257,0.16555257000000001]
["Puerto Rico",678.73770000000002,0.6787377]
["Qatar",602.50049999999999,0.60250049999999999]
["Romania",240.58280999999999,0.24058281000000001]
["Russia",441.03885000000002,0.44103885000000004]
["Rwanda",316.32654000000002,0.31632654000000004]
["Saint Helena",1000,1]
["Saint Kitts and Nevis",636.36365000000001,0.63636365000000006]
["Saint Lucia",666.66660000000002,0.6666666]
["Saint Pierre and Miquelon",600,0.6]
["Saint Vincent and the Grenadines",529.41179999999997,0.52941179999999999]
["Samoa",473.68423000000001,0.47368423000000004]
["Sao Tome and Principe",642.85720000000003,0.64285720000000002]
["Saudi Arabia",706.79049999999995,0.70679049999999999]
["Senegal",511.59793000000002,0.51159792999999998]
["Serbia",636.06226000000004,0.63606225999999999]
["Seychelles",564.51610000000005,0.56451610000000008]
["Sierra Leone",50,0.05]
["Singapore",470.78320000000002,0.47078320000000001]
["Slovakia",116.773544,0.11677354400000001]
["Slovenia",231.27463,0.23127463000000001]
["Solomon Islands",700,0.7]
["Somalia",578.94730000000004,0.57894730000000005]
["South Africa",707.68560000000002,0.70768560000000003]
["South America",179.66322,0.17966321999999998]
["South Korea",430.56707999999998,0.43056707999999999]
["South Sudan",629.03219999999999,0.62903220000000004]
["Spain",174.05005,0.17405005000000001]
["Sri Lanka",509.78134,0.50978133999999997]
["Sudan",263.15787,0.26315787000000002]
["Suriname",349.28232000000003,0.34928232000000003]
["Sweden",40.694878000000003,4.0694878000000004E-2]
["Switzerland",34.842716000000003,3.4842716000000003E-2]
["Syria",701.66070000000002,0.70166070000000003]
["Taiwan",642.37750000000005,0.64237750000000005]
["Tajikistan",116.85825,{"$f":"B195/1000","v":0.11685825}]
["Tanzania",339.24610000000001,0.33924609999999999]
["Thailand",549.58270000000005,0.54958270000000009]
["Togo",443.18180000000001,0.44318180000000001]
["Tonga",625,0.625]
["Trinidad and Tobago",681.52859999999998,0.68152859999999993]
["Tunisia",563.95623999999998,0.56395624]
["Turkey",464.58609999999999,0.4645861]
["Turkmenistan",1306.0251000000001,1.3060251]
["Turks and Caicos Islands",653.84619999999995,0.65384619999999993]
["Uganda",44.526904999999999,4.4526904999999999E-2]
["Ukraine",259.69301999999999,0.25969302]
["United Arab Emirates",561.13480000000004,0.56113480000000004]
["United Kingdom",237.58902,0.23758902000000001]
["United States",369.47318000000001,0.36947318000000001]
["United States Virgin Islands",632.35297000000003,0.63235297000000001]
["Upper-middle-income countries",538.57249999999999,0.53857250000000001]
["Uruguay",128.78789,0.12878789000000002]
["Uzbekistan",1167.6029000000001,1.1676029000000001]
["Vanuatu",571.42859999999996,0.57142859999999995]
["Venezuela",185.80202,0.18580202000000001]
["Vietnam",475.44873000000001,0.47544872999999999]
["World",480.84857,0.48084856999999998]
["Yemen",566.10159999999996,0.56610159999999998]
["Zambia",111.96713,0.11196713]
["Zimbabwe",297.87234000000001,0.29787234000000001]