{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Welcome!","Reproduction(R)","R. Investment Costs","R. Operating Costs","R. Revenue","Growout (GO)","GO. Investment Costs","GO. Operating Costs","GO. Revenue","GO & R results","Currency data","Tables"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"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":"Welcome!","index":0,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,14,10],[26,2,26,9],[31,2,31,9],[15,2,15,9],[17,2,20,9],[24,4,24,9],[28,3,28,6],[30,2,30,9],[38,2,38,9],[49,2,49,9],[53,2,53,9],[54,2,55,9],[25,4,25,9],[33,7,33,9],[42,2,42,9],[51,2,51,9],[44,2,45,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SIMplified Black soldier fly Approach - COST MODEL"]
[]
[null,null,"This cost model is based on: The SIMBA Grow-Out Guide¹ and The SIMBA Reproduction Guide². Accordingly, this cost model is divided into two parts: Grow-Out Unit and Reproduction Unit, estimating cost and revenue based on one year of operation.  \nDisclaimer: 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,"1.","How to read and use this model:"]
[null,null,"a.","Make sure to \"Enable Content/Macros\" when opening this model in excel."]
[null,null,"b.","yellow cells","indicates a default value. If the value does not match your case/facility - you have the option to change it"]
[null,null,"c.","orange cells","have no default value. Here you must select an option from the drop-down menu in the cell."]
[]
[]
[null,null,"2.","What currency do you want the cost model in?",null,null,null,"Currency:","EUR",{"$f":"INDEX(Currency_World[],MATCH(I29,INDEX(Currency_World[],0,2),0),3)","v":"Euro"}]
[null,null,null,null,null,null,null,"1 EUR =",1,{"$f":"I29","v":"EUR"}]
[]
[null,null,{"$f":"IF(I29=\"EUR\",\"\",\"* Please change the currency rate to EUR to ensure that the default values in this model, which are currently in EUR, are correctly converted to your selected currency.\")","v":""}]
[]
[null,null,"3.","What kind of SIMBA Unit you have/ want to set up?"]
[]
[]
[null,null,null,null,"Cost model for Grow-out Unit*:"]
[]
[null,null,"*Grow-out unit: has the purpose to find a balance between optimal growth of the larvae for harvesting, production of frass for use as soil amendment and organic waste reduction. This all, while keeping the labour effort as low as possible. The grow-out unit will include the waste pre-processing, treatment of waste and product harvesting step."]
[]
[null,null,null,null,"Cost model for Reproduction Unit*: "]
[]
[null,null,"*Reproduction unit: has the purpose to create optimal conditions to maintain the lifecycle of BSF including: BSF pupation, mating, laying of eggs, hatching and first days of larvae feeding while keeping the labour effort as low as possible."]
[]
[null,null,"The cost model is seperating the cost related to the Reproduction unit and Grow-out unit. Go through the reproduction unit first, continue with the grow out unit, and then you will find a combined results at the end. "]
[]
[]
[]
[]
[null,null,"Reproduction unit: has the purpose to create optimal conditions to maintain the lifecycle of BSF including: BSF pupation, mating, laying of eggs, hatching and first days of larvae feeding while keeping the labour effort as low as possible."]
[]
[null,null,"Grow-Out Unit: has the purpose to find a balance between optimal growth of the larvae for harvesting, production of frass for use as soil amendment and organic waste reduction. This all, while keeping the labour effort as low as possible. The grow-out unit will include the waste pre-processing, treatment of waste and product harvesting step."]
[]
[null,null,"1. Diener, S., Dortmans, B,. Peguero, D., & Zurbrügg, C. (2025) SIMPLIFIED BLACK SOLDIER FLY APPROACH (SIMBA) – GROW-OUT UNIT: STANDARD OPERATIONS PROCEDURE"]
[null,null,"2. Diener, S., Dortmans, B,. Peguero, D., & Zurbrügg, C. (2025) SIMPLIFIED BLACK SOLDIER FLY APPROACH (SIMBA) – REPRODUCTION UNIT: STANDARD OPERATIONS PROCEDURE"]

{"sheet":"Reproduction(R)","index":1,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[[13,2,13,5],[20,2,20,5],[64,2,65,5],[15,2,18,5],[61,2,62,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Reproduction Unit "]
[]
[null,null,"This page provides an overview of your investment, operational expenses and revenues related to the reproduction unit. Default values are based on the SIMBA Reproduction Guide², which aims to treat 250 kg of waste per week. To increase accuracy, please ensure that the performance indicators and default values below are aligned with values from your facility and your treatment capacity."]
[]
[]
[]
[]
[null,null,"Default values in yellow cells can be changed "]
[]
[null,null,"1. How many kg waste do you want the larva to be able to treat per week?",null,null,250]
[]
[null,null,"A","Performance Indicators"," Values from SIMBA guide","Your values"]
[null,null,1,"Egg division"]
[null,null,null,"gram eggs per week",{"$f":"F23/(25/3)","v":29.999999999999996},{"$f":"E27","v":29.999999999999996}]
[null,null,null,"gram 7-DOL per week",{"$f":"E43/E30","v":1258.7412587412587},{"$f":"E28","v":1258.7412587412587}]
[null,null,null,"# egg equals 1 gram",{"$f":"E41/E27","v":40000.000000000007},{"$f":"E29","v":40000.000000000007}]
[null,null,null,"# 7-DOL equals 1 gram",{"$f":"286","v":286},{"$f":"E30","v":286}]
[null,null,"2","Larva division"]
[null,null,null,"# 7-DOL retained for Reproduction per week",{"$f":"E43*(1/6)","v":60000},{"$f":"E32","v":60000}]
[null,null,null,"Kg frass harvested per week",{"$f":"E48*(E32/E49)","v":20},{"$f":"E33","v":20}]
[null,null,null,"# Prepupa per week",{"$f":"E32*(2/3)","v":40000},{"$f":"E34","v":40000}]
[null,null,null,"# Pupae harvested per week",{"$f":"E34","v":40000},{"$f":"E35","v":40000}]
[null,null,"3","Adult division"]
[null,null,null,"# Flies per week",{"$f":"E35*(1/2)","v":20000},30000]
[]
[null,null,null," BSF Performance","Values based on guide²","Your facility"]
[null,null,1,"Egg unit"]
[null,null,null,"# eggs per week",{"$f":"F23*4800","v":1200000},{"$f":"F27*F29","v":1200000}]
[null,null,null,"# eggs / fly",{"$f":"E41/E37","v":60},{"$f":"F41/F37","v":40}]
[null,null,null,"# 7-DOL per week",{"$f":"E41*0.3","v":360000},{"$f":"F28*F30","v":360000}]
[null,null,null,"Hatchling rate ",{"$f":"E43/E41","v":0.3},{"$f":"F43/F41","v":0.3}]
[null,null,"2","Larva division"]
[null,null,null,"Larva retained for Reproduction",{"$f":"E32/E43","v":0.16666666666666666},{"$f":"F32/F43","v":0.16666666666666666}]
[null,null,null,"# 7-DOL Larva avaliable for sale per week",{"$f":"E43-E32","v":300000},{"$f":"F43-F32","v":300000}]
[null,null,null,"Bioconversion Rate: Frass",0.4,{"$f":"F33/(F32/F49)","v":0.4}]
[null,null,null,"# 7-DOL / kg substrate ",{"$f":"E47/F23","v":1200},{"$f":"F47/F23","v":1200}]
[null,null,null,"pupa / 7-DOL",{"$f":"E35/E32","v":0.66666666666666663},{"$f":"F35/F32","v":0.66666666666666663}]
[null,null,"3","Adult division"]
[null,null,null,"# fly / pupa",{"$f":"E37/E35","v":0.5},{"$f":"F37/F35","v":0.75}]
[]
[]
[null,null,"Profit after one year",null,{"$f":"'Welcome!'!I29","v":"EUR"},"Details"]
[null,null,"A-C","Investment Costs",{"$f":"-'R. Investment Costs'!H65","v":-1740.27}]
[null,null,"D","Wear and Tear Cost",{"$f":"-'R. Investment Costs'!H75","v":-149.40400000000002}]
[null,null,"E-G","Operating Costs",{"$f":"-'R. Operating Costs'!G42","v":-17.402699999999999}]
[null,null,"H","Sale Revenue ",{"$f":"'R. Revenue'!G28","v":795.05454545454552}]
[null,null,null,"Profit including investment cost",{"$f":"SUM(E56:E59)","v":-1112.0221545454547}]
[null,null,null,"Profit excluding investment cost*",{"$f":"SUM(E57:E59)","v":628.24784545454554}]
[null,null,{"$f":"IF(AND('R. Operating Costs'!G20=0,'R. Operating Costs'!G29=0),\n\"Mark; this a rough estimate, with assumtions like;  no substrate costs (E)  and no employee costs (F). Adjust default values (under details).\"&\" * Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year.\",\n\"Adjust values under details. * Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year.\")","v":"Mark; this a rough estimate, with assumtions like;  no substrate costs (E)  and no employee costs (F). Adjust default values (under details). * Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year."}]
[]
[]
[null,null,"2. Diener, S., Dortmans, B,. Peguero, D., & Zurbrügg, C. (2025) SIMPLIFIED BLACK SOLDIER FLY APPROACH (SIMBA) – REPRODUCTION UNIT: STANDARD OPERATIONS PROCEDURE"]

{"sheet":"R. Investment Costs","index":2,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[30,2,30,7],[5,2,6,7],[8,2,8,7],[3,2,3,3],[69,2,69,7]]}
[]
[]
[]
[null,null,"Investment Costs",null,null,"Total:",{"$f":"H65","v":1740.27},{"$f":"'Welcome!'!I29","v":"EUR"}]
[]
[null,null,"Investment costs refer to the initial one-time expenditure needed to set up the facility. All yellow cells show a default value. These default values are based on the values from the SIMBA Reproduction Guide².  "]
[]
[]
[null,null,"If you have more accurate data, change the default values in the yellow cells to represent your facility."]
[]
[]
[null,null,"A","Building and Civil Works","Amount*",{"$f":"'Welcome!'!I29&\" / unit*\"","v":"EUR / unit*"}," Total*"," Total","Lifetime(years)","Dep. per year"]
[null,null,"1","Material",null,null,{"$f":"SUM(G14:G24)","v":814.26},{"$f":"IF('Reproduction(R)'!F23=250,G13,0)","v":814.26},30,{"$f":"H13/I13","v":27.141999999999999}]
[null,null,"1.1","Cement",23,{"$f":"8.85*'Welcome!'!I30","v":8.85},{"$f":"E14*F14","v":203.54999999999998}]
[null,null,"1.2","Bricks",6500,{"$f":"0.01*'Welcome!'!I30","v":0.01},{"$f":"E15*F15","v":65}]
[null,null,"1.3","River sand (ton)",6,{"$f":"3.69*'Welcome!'!I30","v":3.69},{"$f":"E16*F16","v":22.14}]
[null,null,"1.4","Iron sheets ",26,{"$f":"10*'Welcome!'!I30","v":10},{"$f":"E17*F17","v":260}]
[null,null,"1.5","Roofing nails (kgs)",5,{"$f":"1.87*'Welcome!'!I30","v":1.87},9.3500000000000014]
[null,null,"1.6","Wire nails (kgs)",14,{"$f":"1.8*'Welcome!'!I30","v":1.8},25.2]
[null,null,"1.7","Timber Guard (liter)",2,{"$f":"1.35*'Welcome!'!I30","v":1.35},2.7]
[null,null,"1.8","Wire (rows)",2,{"$f":"0.98*'Welcome!'!I30","v":0.98},1.96]
[null,null,"1.9","Timber",54,{"$f":"2.85*'Welcome!'!I30","v":2.85},153.9]
[null,null,"1.10","Timber for cage frame ",22,{"$f":"2.7*'Welcome!'!I30","v":2.7},59.400000000000006]
[null,null,1.1100000000000001,"Wire nails  (kgs)",7,{"$f":"1.58*'Welcome!'!I30","v":1.58},11.06]
[null,null,"2","Labor cost ",null,null,{"$f":"G26","v":22.13},{"$f":"IF('Reproduction(R)'!F23=250,G25,0)","v":22.13},"-","-"]
[null,null,"2.1","Labor charge ",1,{"$f":"22.13*'Welcome!'!I30","v":22.13},{"$f":"E26*F26","v":22.13}]
[null,null,"3","Other ",null,null,{"$f":"SUM(G28:G29)","v":144.26},{"$f":"IF('Reproduction(R)'!F23=250,G27,0)","v":144.26},30,{"$f":"IFERROR(H27/I27,0)","v":4.8086666666666664}]
[null,null,"3.1","Transportation (trips)",2,{"$f":"22.13*'Welcome!'!I30","v":22.13},{"$f":"E28*F28","v":44.26}]
[null,null,"3.2","Other",1,{"$f":"100*'Welcome!'!I30","v":100},{"$f":"E29*F29","v":100}]
[null,null,"A","Total building and civil works ",null,0,null,{"$f":"SUM(H13:H29)","v":980.65},null,{"$f":"SUM(J13:J28)","v":31.950666666666667}]
[null,null,{"$f":"\"*Shows an example facilty on 30 m². Based on the SIMBA guide your unit will need \"&(30/250*'Reproduction(R)'!F23&\" m² of roofed space. Adjust or fill in the total cost for Material, Labor cost, and other costs in your facility.\")","v":"*Shows an example facilty on 30 m². Based on the SIMBA guide your unit will need 30 m² of roofed space. Adjust or fill in the total cost for Material, Labor cost, and other costs in your facility."}]
[]
[null,null,"B","Equipment","Amount","Your Amount",{"$f":"'Welcome!'!I29&\" / unit\"","v":"EUR / unit"},"Total","Lifetime(years)","Dep. per year"]
[null,null,"1","Egg division"]
[null,null,"1.1","Hatchling box (40x60cm)",{"$f":"ROUNDUP(('Reproduction(R)'!F43/480000),0)+1","v":2},{"$f":"E35","v":2},{"$f":"2.94*'Welcome!'!I30","v":2.94},{"$f":"F35*G35","v":5.88},5,{"$f":"IFERROR(H35/I35,0)","v":1.1759999999999999}]
[null,null,"1.2","Hatchling shower rack",{"$f":"ROUNDUP('Reproduction(R)'!E27/1200000*1,0)","v":1},{"$f":"E36","v":1},{"$f":"10*'Welcome!'!I30","v":10},{"$f":"F36*G36","v":10},5,{"$f":"IFERROR(H36/I36,0)","v":2}]
[null,null,"1.3","Click counter",1,1,{"$f":"6*'Welcome!'!I30","v":6},6,5,1.2]
[null,null,"1.4","Tweezer",1,{"$f":"E38","v":1},{"$f":"1*'Welcome!'!I30","v":1},1,5,0.2]
[null,null,"1.5","Spoon ",1,{"$f":"E39","v":1},{"$f":"2*'Welcome!'!I30","v":2},{"$f":"G39*F39","v":2},2,1]
[null,null,"1.6","Plastic bottle cap",1,1,{"$f":"0.5*'Welcome!'!I30","v":0.5},0.5,1,{"$f":"IFERROR(H40/I40,0)","v":0.5}]
[null,null,1.7,"Plate",1,1,{"$f":"1*'Welcome!'!I30","v":1},1,3,0.33333333333333331]
[null,null,1.8,"Sieve (2 mm) *",0,0,{"$f":"5*'Welcome!'!I30","v":5},{"$f":"G42*F42","v":0},5,0]
[null,null,1.9,"Scale (min weight 0.1gm)",1,{"$f":"E43","v":1},{"$f":"18*'Welcome!'!I30","v":18},{"$f":"G43*F43","v":18},8,2.25]
[null,null,"2","Larva division"]
[null,null,"2.1","Nursery container (40x60cm)",{"$f":"('Reproduction(R)'!F32/10000)*5","v":30},{"$f":"E45","v":30},{"$f":"2.94*'Welcome!'!I30","v":2.94},{"$f":"F45*G45","v":88.2},5,{"$f":"IFERROR(H45/I45,0)","v":17.64}]
[null,null,"2.2","Collection container",{"$f":"E45","v":30},30,{"$f":"2.94*'Welcome!'!I30","v":2.94},{"$f":"F46*G46","v":88.2},5,{"$f":"IFERROR(H46/I46,0)","v":17.64}]
[null,null,"2.3","Pupation container (40x60cm)",{"$f":"ROUNDUP('Reproduction(R)'!F34/20000*1,0)","v":2},2,{"$f":"2.94*'Welcome!'!I30","v":2.94},5.88,5,1.1759999999999999]
[null,null,"2.4","Scale (min weight 5-100kg)",{"$f":"1","v":1},{"$f":"E48","v":1},{"$f":"58.8*'Welcome!'!I30","v":58.8},{"$f":"G48*F48","v":58.8},8,7.35]
[null,null,"3","Adult division"]
[null,null,"3.1","Love cage (75x75x150 cm)",{"$f":"ROUNDUP('Reproduction(R)'!E35/20000*3,0)","v":6},{"$f":"E50","v":6},{"$f":"50*'Welcome!'!I30","v":50},{"$f":"F50*G50","v":300},8,{"$f":"IFERROR(H50/I50,0)","v":37.5}]
[null,null,"3.2","Love cage hanger ",{"$f":"E50","v":6},{"$f":"E51","v":6},{"$f":"2.24*'Welcome!'!I30","v":2.2400000000000002},{"$f":"F51*G51","v":13.440000000000001},10,{"$f":"IFERROR(H51/I51,0)","v":1.3440000000000001}]
[null,null,"3.3","Table (80x160 cm)",{"$f":"E50/2","v":3},{"$f":"E52","v":3},20,{"$f":"G52*F52","v":60},10,6]
[null,null,"3.4","Eclosion box (20x30cm)",{"$f":"ROUND('Reproduction(R)'!F35/10000,0)","v":4},{"$f":"E53","v":4},{"$f":"2.8*'Welcome!'!I30","v":2.8},{"$f":"F53*G53","v":11.2},5,2.2399999999999998]
[null,null,"3.5","Eggies",{"$f":"E50*6","v":36},{"$f":"E54","v":36},{"$f":"0.49*'Welcome!'!I30","v":0.49},{"$f":"F54*G54","v":17.64},5,3.528]
[3.6,null,3.6,"Attractant container (20x30cm)",{"$f":"E50","v":6},6,{"$f":"2.94*'Welcome!'!I30","v":2.94},17.64,5,3.528]
[null,null,3.7,"Water container, cotton cloth (20x10cm)",{"$f":"E50","v":6},6,{"$f":"3.24*'Welcome!'!I30","v":3.24},19.440000000000001,5,3.8880000000000003]
[null,null,3.8,"Shade box",{"$f":"E50","v":6},{"$f":"E57","v":6},{"$f":"5.8*'Welcome!'!I30","v":5.8},{"$f":"G57*F57","v":34.799999999999997},5,6.9599999999999991]
[null,null,"4","General task"]
[null,null,"4.1","Cleaning equipment (mopping cloth, broom, sanitizer, detergent etc.)",1,{"$f":"E59","v":1},0,{"$f":"F59*G59","v":0},2,{"$f":"IFERROR(H59/I59,0)","v":0}]
[null,null,"4.2","Office equipment and material",1,{"$f":"E60","v":1},0,{"$f":"G60*F60","v":0},2,{"$f":"IFERROR(H60/I60,0)","v":0}]
[null,null,"4.3","Other (dust bin, mug, bucket, etc)",1,{"$f":"E61","v":1},0,{"$f":"G61*F61","v":0},2,0]
[null,null,"B","Total equipment",null,null,null,{"$f":"SUM(H34:H61)","v":759.62000000000012},null,{"$f":"SUM(J35:J61)","v":117.45333333333335}]
[null,null,"* Not required to operate a SIMBA reproduciton facility. "]
[]
[null,null,"A:B","Total Investment Costs",null,null,null,{"$f":"H30+H62","v":1740.27},null,{"$f":"J30+J62","v":149.40400000000002}]
[]
[]
[null,null,"Wear and Tear Cost",null,null,"Total:",{"$f":"H75","v":149.40400000000002},{"$f":"'Welcome!'!I29&\" / year\"","v":"EUR / year"}]
[]
[null,null,"This shows depreciation cost which accounts for the wear and tear (lifetime) of the investment products. Depreciation is calculated linear over lifetime. Click on \"show calculations\" to see default values in column I. Yellow cells with \"lifetime\" show a default value for each investment. If you wish, change the default values to better reflect your facility."]
[]
[null,null,null,"Wear and tear ",null,null,null,{"$f":"'Welcome!'!I29&\" / year\"","v":"EUR / year"}]
[null,null,null,"Building ",null,null,null,{"$f":"J30","v":31.950666666666667}]
[null,null,null,"Equipment ",null,null,null,{"$f":"J62","v":117.45333333333335}]
[null,null,"C","Total Wear and Tear Cost per year",null,null,null,{"$f":"J65","v":149.40400000000002}]

{"sheet":"R. Operating Costs","index":3,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,2,6,6],[8,2,8,6],[29,2,29,6],[20,2,20,6]]}
[]
[]
[null,null,"Operating cost ",null,"Total:",{"$f":"G42","v":17.402699999999999},{"$f":"'Welcome!'!I29&\"/ year\"","v":"EUR/ year"}]
[]
[null,null,"Operating costs are all your weekly expenses required to operate a Reproduction Unit. All yellow cells show a default value. These default values are calculated based on the values from the SIMBA Reproduction Guide².  You can change the default values to represent your facility more accurately."]
[]
[]
[]
[null,null,"If you have more accurate data, change the default values in the yellow cells to represent your facility."]
[]
[null,null,"E","Feed Cost ",null,"Weekly","Yearly"]
[null,null,1,"Feed in kg","Weekly (default value)"]
[null,null,1.1000000000000001,"Feed 0-7-DOL (e.g., chicken feed)",{"$f":"6/1000*'Reproduction(R)'!F23","v":1.5},{"$f":"E13","v":1.5},{"$f":"F13*52","v":78}]
[null,null,1.2,"Waste substrate 7-DOL-Prepupae (e.g. foodwaste)",{"$f":"'Reproduction(R)'!F32/'Reproduction(R)'!F49","v":50},{"$f":"E14","v":50},{"$f":"F14*52","v":2600}]
[null,null,1.3,"Additives (e.g. saw dust or rice husk)",0,0,0]
[null,null,2,{"$f":"IF(G20=0,\"Feed cost *\",\"Feed Cost\")","v":"Feed cost *"},{"$f":"'Welcome!'!I29&\" / kg\"","v":"EUR / kg"}]
[null,null,2.1,"Feed 0-7-DOL",0,{"$f":"E13*E17","v":0},{"$f":"G13*E17","v":0}]
[null,null,2.2000000000000002,"Waste substrate 7-DOL-Prepupae (e.g. foodwaste)",0,{"$f":"E14*E18","v":0},{"$f":"G14*E18","v":0}]
[null,null,2.2999999999999998,"Additives (e.g. saw dust or rice husk)",0,{"$f":"E19*E15","v":0},{"$f":"E19*G15","v":0}]
[null,null,"E","Total feed cost",null,{"$f":"F17+F18","v":0},{"$f":"G17+G18","v":0}]
[null,null,{"$f":"IF(G20=0,\"*This model assumes that you are using your own substrate (cost = 0). If you buy substrate, please enter price per kilo.\",\"\")","v":"*This model assumes that you are using your own substrate (cost = 0). If you buy substrate, please enter price per kilo."}]
[]
[null,null,"F",{"$f":"IF(G29=0,\"Labor Cost* \",\"Labor Cost\")","v":"Labor Cost* "},null,"Weekly","Yearly"]
[null,null,null,"Number of employees",1]
[null,null,null,"Salary per h",0]
[null,null,null,"Working hours",null,16,{"$f":"F26*52","v":832}]
[null,null,1,"Salary",null,{"$f":"F26*E24*E25","v":0},{"$f":"E24*G26*E25","v":0}]
[null,null,2,"Other",null,0,{"$f":"F28*52","v":0}]
[null,null,"F","Total labor cost ",null,{"$f":"F27+F28","v":0},{"$f":"G27+G28","v":0}]
[null,null,{"$f":"IF(G29=0,\"*This model assumes 0 labor cost, if you are hiring, adjust the yellow cells accordingly.\",\" \")","v":"*This model assumes 0 labor cost, if you are hiring, adjust the yellow cells accordingly."}]
[]
[null,null,"H","Other Cost",null,"Weekly","Yearly"]
[null,null,1,"Repairs and Maintenance*",null,{"$f":"1%*('R. Investment Costs'!H65)/52","v":0.33466730769230768},{"$f":"F33*52","v":17.402699999999999}]
[null,null,2,"Utilities (Water, Electricity, Fuel)",null,0,{"$f":"F34*52","v":0}]
[null,null,3,"Transportation Cost",null,0,0]
[null,null,4,"Marketing Cost",null,0,{"$f":"F36*52","v":0}]
[null,null,5,"Consumables ",null,{"$f":"G37/52","v":0},0]
[null,null,5,"Other",null,0,0]
[null,null,"H","Total other cost",null,{"$f":"SUM(F33:F38)","v":0.33466730769230768},{"$f":"SUM(G33:G38)","v":17.402699999999999}]
[null,null,"* The default value is calculated as 1% of the investments cost"]
[null,null,null,null,null,"Weekly","Yearly"]
[null,null,"E:H","Total Operating Costs",null,{"$f":"F20+F29+F39","v":0.33466730769230768},{"$f":"G20+G29+G39","v":17.402699999999999}]

{"sheet":"R. Revenue","index":4,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,2,5,6],[7,2,7,6],[25,2,25,6],[16,2,16,6],[31,2,31,6]]}
[]
[]
[null,null,"Sale revenue",null,"Total:",{"$f":"G28","v":795.05454545454552},{"$f":"'Welcome!'!I29&\"/ year\"","v":"EUR/ year"}]
[]
[null,null,{"$f":"\"Sales revenue shows the income you will generate from your reproduction unit; selling fresh 7-dol  and/or remaining frass. Adjust the sales prices (\"&'Welcome!'!J30&\" /kg) in the yellow cells to make the calculation more accurate for your case.\"","v":"Sales revenue shows the income you will generate from your reproduction unit; selling fresh 7-dol  and/or remaining frass. Adjust the sales prices (EUR /kg) in the yellow cells to make the calculation more accurate for your case."}]
[]
[]
[null,null,"If you have more accurate data, change the default values in the yellow cells to represent your facility."]
[]
[null,null,"H","7-DOL*",null,"Weekly","Yearly"]
[null,null,1,"7-DOL in gram"]
[null,null,1.1000000000000001,"gram 7-DOL harvested ",null,{"$f":"'Reproduction(R)'!F47/'Reproduction(R)'!F30","v":1048.951048951049},{"$f":"F12*52","v":54545.454545454544}]
[null,null,1.2,"7-DOL sold ",null,{"$f":"F12","v":1048.951048951049},{"$f":"F13*52","v":54545.454545454544}]
[null,null,2,"Sale price 7-DOL"]
[null,null,2.1,{"$f":"'Welcome!'!I29&\" / gram 7-DOL\"","v":"EUR / gram 7-DOL"},{"$f":"0.01*'Welcome!'!I30","v":0.01}]
[null,null,"H","Total Revenue: 7-DOL",null,{"$f":"E15*F13","v":10.48951048951049},{"$f":"E15*G13","v":545.4545454545455}]
[null,null,"*If you use the 7-DOL in your own reproduction unit; set sale price to 0."]
[]
[null,null,"I","Frass from 7-dol",null,"Weekly","Yearly"]
[null,null,1,"Frass in kg"]
[null,null,1.1000000000000001,"Frass harvested",null,20,{"$f":"F21*52","v":1040}]
[null,null,1.2,"Frass sold",null,{"$f":"F21","v":20},{"$f":"F22*52","v":1040}]
[null,null,2,"Sale price frass "]
[null,null,2.1,{"$f":"'Welcome!'!I29&\" / kg frass\"","v":"EUR / kg frass"},{"$f":"0.24*'Welcome!'!I30","v":0.24}]
[null,null,"I","Total Revenue: Frass",null,{"$f":"E24*F22","v":4.8},{"$f":"E24*G22","v":249.6}]
[null,null,{"$f":"IF(G25=0,\"* This model assume that 0 kg of frass is sold. If you sell frass pleace adjust accordingly.\",\"\")","v":""}]
[]
[null,null,"H:I","Total Sales Revenue",null,{"$f":"F16+F25","v":15.289510489510491},{"$f":"G16+G25","v":795.05454545454552}]
[]
[]
[]
[null,null,"If you are also operating a Grow-Out unit, \"Continue to Grow-Out Unit, if not, go \"Back\" and see your results for your reproduction Unit. "]

{"sheet":"Growout (GO)","index":5,"n_rows":83,"n_cols":7,"rows_kept":83,"cut":false,"hidden":false,"merged":[[94,3,94,4],[78,2,78,5],[58,3,58,4],[18,2,18,4],[27,2,28,3],[79,2,79,5],[46,2,46,5],[55,2,55,5],[56,2,56,5],[25,4,25,5],[21,2,23,3],[11,2,11,5],[16,2,16,3],[16,4,16,5],[82,2,82,5],[13,2,14,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[null,null,"Growout Unit "]
[]
[null,null,"This model is based on the Growout SIMBA Guide¹, which aims to treat 50 kg of waste per week. Select options in all the empty orange cells to get an overview of the profit for your Growout Unit. "]
[]
[]
[null,null,"Default value - Optional to change ",null,"Select option"]
[]
[null,null,"1. How many kg waste (substrate) will you treat per week?",null,null,50]
[]
[null,null,"2. What kind of substrate will you use?",null,"Substrate","Percentage"]
[null,null,{"$f":"IF(OR(E24=\"Other\", E23=\"Other\", E22=\"Other\"), \"Default bioconversion rate for 'Other' is 10% for larvae, and 30% for frass. Change total bioconversion rate     under Calculation for BSF below.\", \"\")","v":""},null,"Food waste",1]
[]
[]
[null,null,null,null,"Sum",{"$f":"SUM(F22:F24)","v":1}]
[null,null,null,null,{"$f":"IF(F25=100%,\"\",\"The sum has to be 100%\")","v":""}]
[null,null,"Received products (per week)"]
[null,null,{"$f":"\"By treating \"&F19&\" kg of your substrate you will receive:\"","v":"By treating 50 kg of your substrate you will receive:"},null,{"$f":"IF(F25=100%,\"\"&ROUND(F73,1)&\" kg  \",\"\")","v":"8 kg  "},"fresh larvae"]
[null,null,null,null,{"$f":"IF(F25=100%,\" \"&ROUND(F78,0)&\" kg \",\"\")","v":" 21 kg "},"frass"]
[]
[null,null,"3. Do you want to sell any of your products?",null,"Yes"]
[]
[null,null,"4. How much of your product do you want to sell?"]
[null,null,null,null,"Kg sold per week","Kg kept per week"]
[null,null,"Fresh larvae",null,{"$f":"E73*D35","v":0},{"$f":"E73-E35","v":8.0265500000000003}]
[null,null,"Frass ",null,{"$f":"E78*D36","v":0},{"$f":"E78-E36","v":21.122499999999999}]
[]
[]
[null,null,"Profit after one year",null,{"$f":"'Welcome!'!I29","v":"EUR"},"Details"]
[null,null,"A:B","Investment Costs",{"$f":"-'GO. Investment Costs'!I40","v":-238.70000000000002}]
[null,null,"C","Wear and Tear Costs",{"$f":"-'GO. Investment Costs'!I50","v":-60.042857142857137}]
[null,null,"D:G","Operating Costs",{"$f":"-'GO. Operating Costs'!G52","v":-111.47790909090911}]
[null,null,"H:I","Sale Revenue ",{"$f":"'GO. Revenue'!G27","v":0}]
[null,null,"J:K","Saved Costs",{"$f":"'GO. Revenue'!G55","v":735.24887799999988}]
[null,null,null,"Profit including investment costs",{"$f":"SUM(E40:E44)","v":325.02811176623362}]
[null,null,null,"Profit excluding investment costs*",{"$f":"SUM(E41:E44)","v":563.72811176623361}]
[null,null,{"$f":"IF(AND('GO. Operating Costs'!G39=0, 'GO. Investment Costs'!I13=0, 'GO. Operating Costs'!G29=0),\n\"Mark; this a rough estimate, with assumtions like; no building costs (A), no substrate costs (E), 7DOL is bought (D),  and no employee costs (F). Adjust default values (under details).\"&\"* Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year.\",\n\"Adjust values under details. * Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year.\")","v":"Mark; this a rough estimate, with assumtions like; no building costs (A), no substrate costs (E), 7DOL is bought (D),  and no employee costs (F). Adjust default values (under details).* Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year."}]
[]
[null,null,"Profit after one year",null,{"$f":"'Welcome!'!I29","v":"EUR"},"Details"]
[null,null,"A:B","Investment Costs",{"$f":"-'GO. Investment Costs'!I40","v":-238.70000000000002}]
[null,null,"C","Wear and Tear Cost",{"$f":"-'GO. Investment Costs'!I50","v":-60.042857142857137}]
[null,null,"D:G","Operating Costs",{"$f":"-'GO. Operating Costs'!G52","v":-111.47790909090911}]
[null,null,"J:K","Saved Costs",{"$f":"'GO. Revenue'!G55","v":735.24887799999988}]
[null,null,null,"Profit including investment costs",{"$f":"SUM(E50:E53)","v":325.02811176623362}]
[null,null,null,"Profit excluding investment costs*",{"$f":"SUM(E51:E53)","v":563.72811176623361},null," "]
[null,null,{"$f":"IF(AND('GO. Operating Costs'!G39=0,  'GO. Investment Costs'!I13=0, 'GO. Operating Costs'!G29=0),\n\"Mark; this is a rough estimate, with assumptions like; no building costs (A), no substrate costs (E), 7DOL is bought (D),  and no employee costs (F). Adjust default values (under details).\"&\"* Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year.\",\n\"Adjust values under details. * Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year.\")","v":"Mark; this is a rough estimate, with assumptions like; no building costs (A), no substrate costs (E), 7DOL is bought (D),  and no employee costs (F). Adjust default values (under details).* Since investment cost will only be a cost the first year, profit excluding investment costs will be a more realistic number of your profit after the first year."}]
[]
[]
[null,null,null,"Calculation for BSF performance and Recieved Products"]
[null,null,"A","Preformans indicators","per week","per week"]
[null,null,1,"Treatment "," From SIMBA guide","Use your own values"]
[null,null,1.1000000000000001,"# 7-DOL/ kg substrate ",{"$f":"1200","v":1200},{"$f":"E62","v":1200}]
[null,null,1.2,"#7-DOL needed per week",{"$f":"F19*E62","v":60000},{"$f":"F62*F19","v":60000}]
[null,null,1.3,"# 7-DOL equals 1 gram",286,{"$f":"E64","v":286}]
[null,null,1.4,"gram 7-DOL / kg substrate",{"$f":"E62/E64","v":4.1958041958041958},{"$f":"IFERROR(F62/F64,0)","v":4.1958041958041958}]
[null,null,1.5,"gram 7-DOL needed per week",{"$f":"E65*F19","v":209.79020979020979},{"$f":"F65*F19","v":209.79020979020979}]
[null,null,2,"Products ","From literature","Use your own values"]
[null,null,2.1,"Bioconversion Rate (%DM): Larvae³",{"$f":"IF(F22=100%,E69,(E69*F22)+(E70*F23)+(E71*F24))","v":0.18886},{"$f":"E68","v":0.18886}]
[null,null,null,{"$f":" \" Bioconversion rate \"&E22 &\"\t\"","v":" Bioconversion rate Food waste\t"},{"$f":"VLOOKUP(E22,Substrate[],2,0)","v":0.18886},"-"]
[null,null,null,{"$f":"\" Bioconversion rate \"&E23&\"\"","v":" Bioconversion rate "},{"$f":"VLOOKUP(E23,Substrate[],2,0)","v":{"$error":"#N/A"}},"-"]
[null,null,null,{"$f":"\" Bioconversion rate \"&E24&\"\"","v":" Bioconversion rate "},{"$f":"IFERROR(VLOOKUP(E24,Substrate[],2,0),\"0\")","v":"0"},"-"]
[null,null,2.2000000000000002,"Product loss rate",0.15,{"$f":"E72","v":0.15}]
[null,null,2.2999999999999998,"kg larvae per week",{"$f":"F19*E68*(1-E72)","v":8.0265500000000003},{"$f":"F68*F19*(1-F72)","v":8.0265500000000003}]
[null,null,2.4,"Bioconversion Rate (%DM): Frass³",{"$f":"IF(F22=100%,E75,(E75*F22)+(E76*F23)+(E77*F24))","v":0.42244999999999999},{"$f":"E74","v":0.42244999999999999}]
[null,null,null,{"$f":" \" Bioconversion rate \"&E22&\"\"","v":" Bioconversion rate Food waste"},{"$f":"VLOOKUP(E22,Substrate[],3,0)","v":0.42244999999999999},"-"]
[null,null,null,{"$f":"\" Bioconversion rate \"&E23&\"\"","v":" Bioconversion rate "},{"$f":"VLOOKUP(E23,Substrate[],3,0)","v":{"$error":"#N/A"}},"-"]
[null,null,null,{"$f":"\" Bioconversion rate \"&E24&\"\"","v":" Bioconversion rate "},{"$f":"IFERROR(VLOOKUP(E24,Substrate[],3,0),\"0\")","v":"0"},"-"]
[null,null,2.4,"kg frass per week",{"$f":"F19*E74","v":21.122499999999999},{"$f":"F74*F19","v":21.122499999999999}]
[null,null,"3. Reusser, M., Peguero, D., Studach, C., & Zurbrügg, C. (2024). BSFL Substrate Navigator [Windows 11]. Eawag: Swiss Federal Institute of Aquatic Science and Technology. Retrieved on July 28, 2025, from "]
[null,null,"https://bsfl-substrate-navigator.onrender.com/"]
[]
[]
[null,null,"1.  Diener, S., Dortmans, B,. Peguero, D., & Zurbrügg, C. (2025) SIMPLIFIED BLACK SOLDIER FLY APPROACH (SIMBA) – GROW-OUT UNIT: STANDARD OPERATIONS PROCEDURE"]

{"sheet":"GO. Investment Costs","index":6,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,2,5,8],[43,2,44,8],[13,2,14,8],[6,2,6,4],[6,5,6,8]]}
[]
[]
[null,null,"Investment Costs",null,null,null,"Total:",{"$f":"I40","v":238.70000000000002},{"$f":"H9","v":"EUR"}]
[]
[null,null,"Investment costs refer to the initial one-time expenditure needed to set up the facility. All yellow cells show a default value. These default values are based on the values from the SIMBA Growout Guide¹.  If you have data you can change the default values that more accurately represent your facility."]
[]
[null,null,"Default value - Optional to change ",null,null,"Select option"]
[]
[null,null,"A","Building and Civil Works*",null,"Amount ",null,{"$f":"'Welcome!'!I29","v":"EUR"},"Total","Lifetime (years)",{"$f":"'Welcome!'!I29&\" / year\"","v":"EUR / year"}]
[null,null,1,"Building construction and materials",null,1,null,0,{"$f":"F10*H10","v":0},30,{"$f":"IFERROR(I10/J10,0)","v":0}]
[null,null,2,"Labor Cost",null,1,null,0,{"$f":"F11*H11","v":0},"-",{"$f":"IFERROR(I11/J11,0)","v":0}]
[null,null,3,"Other",null,1,null,0,{"$f":"F12*H12","v":0},30,0]
[null,null,"A","Total building and Civil Workers ",null,null,null,null,{"$f":"SUM(I10:I12)","v":0},null,{"$f":"SUM(K10:K12)","v":0}]
[null,null,{"$f":"\"*For treating \"&'Growout (GO)'!F19&\" kg waste, the SIMBA guide estimate that you need a \"&(150/250*'Growout (GO)'!F19)&\" m² roofed space. If you don' t have this space avaliable please estimate the costs.\"","v":"*For treating 50 kg waste, the SIMBA guide estimate that you need a 30 m² roofed space. If you don' t have this space avaliable please estimate the costs."}]
[]
[]
[null,null,"B","Equipment","Your dimensions","Amount","Your amount",{"$f":"'Welcome!'!I29&\" / unit\"","v":"EUR / unit"},"Total","Lifetime (years)",{"$f":"'Welcome!'!I29&\" / year\"","v":"EUR / year"}]
[null,null,1,"Pre-treatment"]
[null,null,"1.1","Bulk scale","-",{"$f":"ROUNDUP('Growout (GO)'!E63/10000000*1,0)","v":1},{"$f":"F19","v":1},{"$f":"74.5*'Welcome!'!I30","v":74.5},{"$f":"G19*H19","v":74.5},7,{"$f":"IFERROR(I19/J19,0)","v":10.642857142857142}]
[null,null,"1.2","Shovel/rake ","-",{"$f":"ROUNDUP('Growout (GO)'!E62/10000000*1,0)","v":1},{"$f":"F20","v":1},{"$f":"40*'Welcome!'!I30","v":40},{"$f":"G20*H20","v":40},5,{"$f":"IFERROR(I20/J20,0)","v":8}]
[null,null,"1.3","Grinder*","-",0,0,{"$f":"80*'Welcome!'!I30","v":80},{"$f":"G21*H21","v":0},{"$f":"10","v":10},0]
[null,null,"1.4","Storage bucket (60L)",60,{"$f":"MAX(ROUND('Growout (GO)'!F19/E22*1,0),1)","v":1},1,{"$f":"20*'Welcome!'!I30","v":20},20,3,6.666666666666667]
[null,null,"2","Grow-out"]
[null,null,"2.1","Incubation container (2000cm²)",600,{"$f":"MAX(ROUND('Growout (GO)'!F63/(E24*30)*1,0),1)","v":3},{"$f":"F24","v":3},{"$f":"1.8*'Welcome!'!I30","v":1.8},{"$f":"G24*H24","v":5.4},3,{"$f":"IFERROR(I24/J24,0)","v":1.8}]
[null,null,"2.2","Growout container (2400cm²)",2400,{"$f":"MAX(ROUND('Growout (GO)'!F63/(E25*6),0)*4,1)","v":16},{"$f":"F25","v":16},{"$f":"1.8*'Welcome!'!I30","v":1.8},{"$f":"G25*H25","v":28.8},3,{"$f":"IFERROR(I25/J25,0)","v":9.6}]
[null,null,"2.3","Bioponds (9000cm²)","-",0,0,{"$f":"300*'Welcome!'!I30","v":300},0]
[null,null,"3","Harvesting"]
[null,null,"3.1","Sieve","-",{"$f":"ROUNDUP('Growout (GO)'!E78/6300*1,0)","v":1},{"$f":"F28","v":1},{"$f":"50*'Welcome!'!I30","v":50},{"$f":"G28*H28","v":50},3,{"$f":"IFERROR(I28/J28,0)","v":16.666666666666668}]
[null,null,"3.2","Storage bucket (60L)",60,{"$f":"MAX(ROUND('Growout (GO)'!E78/E29*1,0),1)","v":1},{"$f":"F29","v":1},{"$f":"20*'Welcome!'!I30","v":20},{"$f":"G29*H29","v":20},3,{"$f":"IFERROR(I29/J29,0)","v":6.666666666666667}]
[null,null,"4","Post-treatment **"]
[null,null,"4.1","Hot-air oven","-",0,{"$f":"F31","v":0},0,{"$f":"G31*H31","v":0},10,{"$f":"IFERROR(I31/J31,0)","v":0}]
[null,null,"4.2","Other","-",0,{"$f":"F32","v":0},0,{"$f":"G32*H32","v":0},10,{"$f":"IFERROR(I32/J32,0)","v":0}]
[null,null,"5","General task"]
[null,null,"5.1","Cleaning equipment (mopping cloth, broom, sanitizer, detergent etc.","-",1,{"$f":"F34","v":1},0,{"$f":"G34*H34","v":0},2,{"$f":"IFERROR(I34/J34,0)","v":0}]
[null,null,"5.2","Office equipment and material","-",1,{"$f":"F35","v":1},0,{"$f":"G35*H35","v":0},2,0]
[null,null,"5.3","Other (dust bin, mug, bucket, etc)","-",1,{"$f":"F36","v":1},0,0,2,0]
[null,null,"B","Total Equipment",null,null,null,null,{"$f":"SUM(I19:I34)","v":238.70000000000002},null,{"$f":"SUM(K19:K34)","v":60.042857142857137}]
[null,null,"** Not required to operate a SIMBA growout facility. "]
[]
[null,null,"A:B","Total Investment Costs",null,null,null,null,{"$f":"I37+I13","v":238.70000000000002},null,{"$f":"K13+K37","v":60.042857142857137}]
[]
[]
[null,null,"Wear and Tear Cost",null,null,null,"Total:",{"$f":"I50","v":60.042857142857137},{"$f":"'Welcome!'!I29&\" / year\"","v":"EUR / year"}]
[null,null,"This cost is a depreciation cost which accounts for the wear and tear (lifetime) of the investment products. All yellow cells show a default value. To make the model more accurate to your case, pease change the default values that do not apply to your facility.Click on \"show calculations\" below to see further details."]
[]
[]
[null,null,null,"Wear and tear ",null,null,null,null,{"$f":"'Welcome!'!I29&\" / year\"","v":"EUR / year"}]
[null,null,null,"Building ",null,null,null,null,{"$f":"K13","v":0}]
[null,null,null,"Equipment ",null,null,null,null,{"$f":"K37","v":60.042857142857137}]
[null,null,"C","Total Wear and Tear Cost per year*",null,null,null,null,{"$f":"K40+K13","v":60.042857142857137}]

{"sheet":"GO. Operating Costs","index":7,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[39,2,39,6],[5,2,6,6],[8,2,8,6],[29,2,30,6],[14,2,14,6]]}
[]
[]
[]
[null,null,"Operating Cost ",null,"Total:",{"$f":"G52","v":111.47790909090911},{"$f":"'Welcome!'!I29&\" /year\"","v":"EUR /year"}]
[]
[null,null,"Operating costs are all your weekly expenses required to operate a Grow-Out Unit. All yellow cells show a default value. These default values are calculated based on the values from the SIMBA Grow-Out Guide².  You can change the default values to represent your facility more accurately."]
[]
[]
[null,null,"If you have more accurate data, change the default values in the yellow cells to represent your facility."]
[" "]
[" ",null,"D","7-DOL Cost*",null,"Weekly","Yearly"]
[null,null,1,"gram 7-DOL ",null,{"$f":"'Growout (GO)'!E65*F18","v":209.79020979020979},{"$f":"'Growout (GO)'!E65*G18","v":10909.09090909091}]
[null,null,2,{"$f":"'Welcome!'!I29&\" / gram 7-DOL \"","v":"EUR / gram 7-DOL "},{"$f":"0.01*'Welcome!'!I30","v":0.01}]
[null,null,"D","Total cost 7-DOL",null,{"$f":"E13*F12","v":2.0979020979020979},{"$f":"E13*G12","v":109.09090909090911}]
[null,null,"* If you dont buy 7-DOL / have your own reproduction unit.: set the price to 0."]
[]
[null,null,"E",{"$f":"IF(G29=0,\"Waste Substrate Cost*\",\"Waste Substrate Cost\")","v":"Waste Substrate Cost*"},null,"Weekly","Yearly"]
[null,null,null,"Kg Waste Substrate treated",null,{"$f":"'Growout (GO)'!F19","v":50},{"$f":"F18*52","v":2600}]
[null,null,1,"Waste substrate in kg"]
[null,null,1.1000000000000001,{"$f":"'Growout (GO)'!E22","v":"Food waste"},{"$f":"'Growout (GO)'!F22","v":1},{"$f":"E20*F18","v":50},{"$f":"E20*G18","v":2600}]
[null,null,1.2,{"$f":"IF('Growout (GO)'!E23=\"\",\"-\",'Growout (GO)'!$E$23)","v":"-"},{"$f":"'Growout (GO)'!F23","v":0},{"$f":"E21*F18","v":0},{"$f":"E21*G18","v":0}]
[null,null,1.3,{"$f":"IF('Growout (GO)'!E24=\"\",\"-\",'Growout (GO)'!$E$24)","v":"-"},{"$f":"'Growout (GO)'!F24","v":0},{"$f":"F18*E22","v":0},{"$f":"E22*G18","v":0}]
[null,null,1.4,"Additives (e.g. saw dust or rice husk)",{"$f":"\"-   \"","v":"-   "},0,{"$f":"F23*52","v":0}]
[null,null,2,"Waste substrate cost",{"$f":"'Welcome!'!I29&\" / kg\"","v":"EUR / kg"}]
[null,null,2.1,{"$f":"D20","v":"Food waste"},0,{"$f":"E25*F20","v":0},{"$f":"E25*G20","v":0}]
[null,null,2.2000000000000002,{"$f":"IF('Growout (GO)'!E23=\"\",\"-\",'Growout (GO)'!$E$23)","v":"-"},0,{"$f":"E26*F21","v":0},{"$f":"E26*G21","v":0}]
[null,null,2.2999999999999998,{"$f":"IF('Growout (GO)'!E24=\"\",\"-\",'Growout (GO)'!$E$24)","v":"-"},0,{"$f":"E27*F22","v":0},{"$f":"E27*G22","v":0}]
[null,null,2.4,"Additives (e.g. saw dust or rice husk)",0,{"$f":"E28*F23","v":0},{"$f":"E28*G23","v":0}]
[null,null,"E","Total cost waste substrate ",null,{"$f":"SUM(F25:F28)","v":0},{"$f":"SUM(G25:G28)","v":0}]
[null,null,{"$f":"IF(G29=0,\"*This model assums that you are using your own substrate (cost = 0). If you buy substrate, please enter price per kilo.\",\"\")","v":"*This model assums that you are using your own substrate (cost = 0). If you buy substrate, please enter price per kilo."}]
[]
[]
[null,null,"F",{"$f":"IF(G39=0,\"Labor Cost *\",\"Labor Cost\")","v":"Labor Cost *"},null,"Weekly","Yearly"]
[null,null,null,"Number of employees",0]
[null,null,null,"Salary per h",0]
[null,null,null,"Working hours",null,16,{"$f":"F36*52","v":832}]
[null,null,1,"Salary",null,{"$f":"F36*E34*E35","v":0},{"$f":"E34*G36*E35","v":0}]
[null,null,2,"Other",null,0,{"$f":"F38*52","v":0}]
[null,null,"F","Total labor cost ",null,{"$f":"SUM(F37:F38)","v":0},{"$f":"SUM(G37:G38)","v":0}]
[null,null,{"$f":"IF(G39=0,\"*This model assumes 0 labor cost, if you are hiring, adjust the yellow cells accordingly.\",\" \")","v":"*This model assumes 0 labor cost, if you are hiring, adjust the yellow cells accordingly."}]
[]
[null,null,"G","Other Cost",null,"Weekly","Yearly"]
[null,null,1,"Repairs and Maintenance*",null,{"$f":"G43/52","v":4.5903846153846156E-2},{"$f":"1%*('GO. Investment Costs'!I40)","v":2.387}]
[null,null,2,"Utilities (Water, Electricity, Fuel)",null,{"$f":"G44/52","v":0},0]
[null,null,3,"Transportation Costs",null,0,0]
[null,null,4,"Marketing Cost",null,{"$f":"G46/52","v":0},0]
[null,null,5,"Consumables ",null,0,0]
[null,null,6,"Other",null,0,0]
[null,null,"G","Total other cost",null,{"$f":"SUM(F43:F48)","v":4.5903846153846156E-2},{"$f":"SUM(G43:G48)","v":2.387}]
[null,null,"*The default vaule is calculated as 1% of the investments cost"]
[null,null,null,null,null,"Weekly","Yearly"]
[null,null,"D:G","Total Operating Costs",null,{"$f":"F29+F14+F39+F49","v":2.143805944055944},{"$f":"G29+G14+G39+G49","v":111.47790909090911}]

{"sheet":"GO. Revenue","index":8,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[59,2,59,3],[58,2,58,6],[4,2,5,6],[7,2,7,6],[35,2,35,6],[31,2,33,6]]}
[]
[]
[null,null,"Sale Revenue",null,"Total:",{"$f":"G27","v":0},{"$f":"'Welcome!'!I29&\"/ year\"","v":"EUR/ year"}]
[]
[null,null,{"$f":"\"Sales revenue shows the income you will generate from the grow-out unit selling fresh BSF larvae and/or frass.\nAdjust the sales prices (\"&'Welcome!'!J30&\" /kg) in the yellow cells to make the calculation more accurate for your case.\"","v":"Sales revenue shows the income you will generate from the grow-out unit selling fresh BSF larvae and/or frass.\nAdjust the sales prices (EUR /kg) in the yellow cells to make the calculation more accurate for your case."}]
[]
[]
[null,null,"If you have more accurate data, change the default values in the yellow cells to represent your facility."]
[]
[null,null,"H","Fresh BSF Larvae",null,"Weekly","Yearly"]
[null,null,1,"Larvae in kg","Weekly (default value)"]
[null,null,1.1000000000000001,"Fresh larvae sold",{"$f":"IF('Growout (GO)'!E31=\"Yes\",'Growout (GO)'!E35,0)","v":0},{"$f":"E12","v":0},{"$f":"F12*52","v":0}]
[null,null,1.2,"Dried larvae sold",0,0,{"$f":"F13*52","v":0}]
[null,null,2,"Revenue larvae",{"$f":"'Welcome!'!I29&\" / kg \"","v":"EUR / kg "}]
[null,null,2.1,"Fresh larvae",{"$f":"1.5*'Welcome!'!I30","v":1.5},{"$f":"E15*F12","v":0},{"$f":"E15*G12","v":0}]
[null,null,2.2000000000000002,"Dried larvae",{"$f":"1.02*'Welcome!'!I30","v":1.02},{"$f":"E16*F13","v":0},{"$f":"E16*G13","v":0}]
[null,null,"H","Total Revenue: BSF Larvae",null,{"$f":"SUM(F15:F16)","v":0},{"$f":"SUM(G15:G16)","v":0}]
[]
[null,null,"I","Frass / Organic Fertilizer",null,"Weekly","Yearly"]
[null,null,1,"Frass in kg","Weekly (default value)"]
[null,null,null,"kg frass sold",{"$f":"IF('Growout (GO)'!E31=\"Yes\",'Growout (GO)'!E36,0)","v":0},{"$f":"E21","v":0},{"$f":"F21*52","v":0}]
[null,null,2,"Sale price frass",{"$f":"'Welcome!'!I29&\" / kg \"","v":"EUR / kg "}]
[null,null,null,"Frass",{"$f":"0.24*'Welcome!'!I30","v":0.24}]
[null,null,"I","Total Revenue: Frass",null,{"$f":"E23*F21","v":0},{"$f":"E23*G21","v":0}]
[]
[null,null,null,null,null,"Weekly","Yearly"]
[null,null,"H:I","Total Sales Revenue",null,{"$f":"F17+F24","v":0},{"$f":"G17+G24","v":0}]
[]
[]
[null,null,"Saved cost",null,"Total:",{"$f":"G55","v":735.24887799999988},{"$f":"'Welcome!'!I29&\"/ year\"","v":"EUR/ year"}]
[]
[null,null,"Saved Cost show the amount you can save by investing in a BSF Growout Unit. For instance, if you now are saving money on feed for your animals since you have started to use BSF larvae, then this is a saved cost. Fill in or adjust the yellow fields to improve accuracy based on your specific situation. *The default values assume a 1:1 ratio between BSF feed and conventional feed, and a 1:1 ratio between frass and fertilizer. If this is not your case please also enter the estimated amount you expect to save weekly on conventional feed and fertilizer."]
[]
[]
[]
[null,null,"Change the yellow cells that do not apply to your facility"]
[]
[null,null,"J","Conventional feed",null,"Weekly","Yearly"]
[null,null,1,"Conventional feed in kg","Weekly (default value)"]
[null,null,1.1000000000000001,"Conventional feed actually saved",{"$f":"IF('Growout (GO)'!E31=\"yes\",'Growout (GO)'!F35,'Growout (GO)'!F73)","v":8.0265500000000003},{"$f":"E40","v":8.0265500000000003},{"$f":"F40*52","v":417.38060000000002}]
[null,null,2,"Conventional feed cost",{"$f":"'Welcome!'!I29&\" / kg\"","v":"EUR / kg"}]
[null,null,2.1,"Conventional feed cost",{"$f":"1.13*'Welcome!'!I30","v":1.1299999999999999},{"$f":"F40*E42","v":9.0700015},{"$f":"G40*E42","v":471.64007799999996}]
[null,null,2.2000000000000002,"Transport cost ","-",0,{"$f":"F43*52","v":0}]
[null,null,"J","Total Saved cost: Conventional feed",null,{"$f":"F42+F43","v":9.0700015},{"$f":"G42+G43","v":471.64007799999996}]
[]
[null,null,"K","Conventional Fertilizer ",null,"Weekly","Yearly"]
[null,null,1,"Conventional Fertilizer in kg","Weekly (default value)"]
[null,null,1.1000000000000001,"Fertilizer actually saved",{"$f":"IF('Growout (GO)'!E31=\"Yes\",'Growout (GO)'!F36,'Growout (GO)'!F78)","v":21.122499999999999},{"$f":"E48","v":21.122499999999999},{"$f":"F48*52","v":1098.3699999999999}]
[null,null,2,"Conventional Fertilizer cost",{"$f":"'Welcome!'!I29&\" / kg\"","v":"EUR / kg"}]
[null,null,2.2000000000000002,"Fertilizer ",{"$f":"0.24*'Welcome!'!I30","v":0.24},{"$f":"F48*E50","v":5.0693999999999999},{"$f":"G48*E50","v":263.60879999999997}]
[null,null,2.2999999999999998,"Transport cost","-",0,{"$f":"F51*52","v":0}]
[null,null,"K","Total Saved cost: Conventional Fertilizer",null,{"$f":"F50+F51","v":5.0693999999999999},{"$f":"G50+G51","v":263.60879999999997}]
[]
[null,null,null,null,null,"Weekly","Yearly"]
[null,null,"J:K","Total Saved cost",null,{"$f":"F52+F44","v":14.1394015},{"$f":"G52+G44","v":735.24887799999988}]
[]
[]
[]
[null,null,"See combined results of your Reproduction and Grow-Out unit:"]

{"sheet":"GO & R results","index":9,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,2,7,4],[3,2,3,4],[5,2,5,3],[6,2,6,3]]}
[]
[]
[null,null,"Overview of Combined Unit"]
[null,null,"This page presents the overall costs amd revenues and the resulting profit from your Reproduction and Growout unit. "]
[null,null,null,null,{"$f":"'Welcome!'!J30","v":"EUR"}]
[null,null,"First year profit when including first year investment costs",null,{"$f":"E42","v":-786.99404277922122}]
[null,null,"Profit first year (excluding investment *)",null,{"$f":"E43","v":1191.975957220779}]
[null,null,"*Annual depreciation on investments included."]
[]
[null,null,"Cost and Revenue ; Reproduction Unit",null,{"$f":"'Welcome!'!J30 &\" after one year\"","v":"EUR after one year"}]
[null,null,null,"Investment Costs ",{"$f":"'Reproduction(R)'!E56","v":-1740.27}]
[null,null,null,"Wear and Tear Cost ",{"$f":"'Reproduction(R)'!E57","v":-149.40400000000002}]
[null,null,null,"Operating Costs ",{"$f":"'Reproduction(R)'!E58","v":-17.402699999999999}]
[null,null,null,"Sale Revenue ",{"$f":"'Reproduction(R)'!E59","v":795.05454545454552}]
[]
[]
[null,null,"Cost and Revenue ; Growout Unit",null,{"$f":"'Welcome!'!J30 &\" after one year\"","v":"EUR after one year"}]
[null,null,null,"Investment Costs ",{"$f":"'Growout (GO)'!E40","v":-238.70000000000002}]
[null,null,null,"Wear and Tear Cost ",{"$f":"'Growout (GO)'!E41","v":-60.042857142857137}]
[null,null,null,"Operating Costs ",{"$f":"'Growout (GO)'!E42","v":-111.47790909090911}]
[null,null,null,"Sale Revenue",{"$f":"'Growout (GO)'!E43","v":0}]
[null,null,null,"Saved Costs ",{"$f":"'Growout (GO)'!E44","v":735.24887799999988}]
[]
[]
[null,null,"Profit after one year",null,{"$f":"'Welcome!'!J30 &\" after one year\"","v":"EUR after one year"}]
[null,null,1,"Total Investment Cost",{"$f":"SUM(E11,E18)","v":-1978.97}]
[null,null,1.1000000000000001,"Building and Civil workers ",{"$f":"'R. Investment Costs'!H30+'GO. Investment Costs'!I13","v":980.65}]
[null,null,1.2,"Equipment ",{"$f":"'R. Investment Costs'!H62+'GO. Investment Costs'!I37","v":998.32000000000016}]
[null,null,2,"Total Wear and Tear Cost",{"$f":"SUM(E12,E19)","v":-209.44685714285717}]
[null,null,2.1,"Wear and Tear Building",{"$f":"'R. Investment Costs'!H73+'GO. Investment Costs'!I48","v":31.950666666666667}]
[null,null,2.2000000000000002,"Wear and Tear Equipment ",{"$f":"'R. Investment Costs'!H74+'GO. Investment Costs'!I49","v":177.49619047619049}]
[null,null,3,"Total Operating Cost",{"$f":"SUM(E13,E20)","v":-128.8806090909091}]
[null,null,3.1,"Waste substrate cost",{"$f":"'R. Operating Costs'!G20+'GO. Operating Costs'!G29","v":0}]
[null,null,3.2,"Labor cost",{"$f":"'R. Operating Costs'!G29+'GO. Operating Costs'!G39","v":0}]
[null,null,3.3,"Other cost",{"$f":"'R. Operating Costs'!G39+'GO. Operating Costs'!G49","v":19.7897}]
[null,null,4,"Total Revenue",{"$f":"SUM(E14,E21)","v":795.05454545454552}]
[null,null,4.0999999999999996,"Fresh BSF larvae",{"$f":"'GO. Revenue'!G17","v":0}]
[null,null,4.2,"Frass",{"$f":"'R. Revenue'!G25+'GO. Revenue'!G24","v":249.6}]
[null,null,5,"Total Saved cost",{"$f":"E22","v":735.24887799999988}]
[null,null,5.0999999999999996,"Conventional Feed ",{"$f":"'GO. Revenue'!G44","v":471.64007799999996}]
[null,null,5.2,"Conventional Fertilizer ",{"$f":"'GO. Revenue'!G52","v":263.60879999999997}]
[null,null,null,"Profit including investment costs",{"$f":"SUM(E26,E29,E32,E36,E39)","v":-786.99404277922122}]
[null,null,null,"Profit excluding investment costs",{"$f":"SUM(E29,E32,E36,E39)","v":1191.975957220779}]

{"sheet":"Currency data","index":10,"n_rows":188,"n_cols":3,"rows_kept":188,"cut":false,"hidden":true,"merged":[]}
["Country","Currency Code","Currency Name"]
["Algeria","DZD","Algerian Dinar"]
["Angola","AOA","Angolan Kwanza"]
["Benin","XOF","West African CFA Franc"]
["Botswana","BWP","Botswana Pula"]
["Burkina Faso","XOF","West African CFA Franc"]
["Burundi","BIF","Burundian Franc"]
["Cameroon","XAF","Central African CFA Franc"]
["Cape Verde","CVE","Cape Verdean Escudo"]
["Central African Republic","XAF","Central African CFA Franc"]
["Chad","XAF","Central African CFA Franc"]
["Comoros","KMF","Comorian Franc"]
["Côte d'Ivoire","XOF","West African CFA Franc"]
["Democratic Republic of the Congo","CDF","Congolese Franc"]
["Djibouti","DJF","Djiboutian Franc"]
["Egypt","EGP","Egyptian Pound"]
["Equatorial Guinea","XAF","Central African CFA Franc"]
["Eritrea","ERN","Eritrean Nakfa"]
["Eswatini","SZL","Swazi Lilangeni"]
["Ethiopia","ETB","Ethiopian Birr"]
["Gabon","XAF","Central African CFA Franc"]
["Gambia","GMD","Gambian Dalasi"]
["Ghana","GHS","Ghanaian Cedi"]
["Guinea","GNF","Guinean Franc"]
["Guinea-Bissau","XOF","West African CFA Franc"]
["Kenya","KES","Kenyan Shilling"]
["Lesotho","LSL","Lesotho Loti"]
["Liberia","LRD","Liberian Dollar"]
["Libya","LYD","Libyan Dinar"]
["Madagascar","MGA","Malagasy Ariary"]
["Malawi","MWK","Malawian Kwacha"]
["Mali","XOF","West African CFA Franc"]
["Mauritania","MRU","Mauritanian Ouguiya"]
["Mauritius","MUR","Mauritian Rupee"]
["Morocco","MAD","Moroccan Dirham"]
["Mozambique","MZN","Mozambican Metical"]
["Namibia","NAD","Namibian Dollar"]
["Niger","XOF","West African CFA Franc"]
["Nigeria","NGN","Nigerian Naira"]
["Republic of the Congo","XAF","Central African CFA Franc"]
["Rwanda","RWF","Rwandan Franc"]
["São Tomé and Príncipe","STN","São Tomé and Príncipe Dobra"]
["Senegal","XOF","West African CFA Franc"]
["Seychelles","SCR","Seychellois Rupee"]
["Sierra Leone","SLE","Sierra Leonean Leone"]
["Somalia","SOS","Somali Shilling"]
["South Africa","ZAR","South African Rand"]
["South Sudan","SSP","South Sudanese Pound"]
["Sudan","SDG","Sudanese Pound"]
["Tanzania","TZS","Tanzanian Shilling"]
["Togo","XOF","West African CFA Franc"]
["Tunisia","TND","Tunisian Dinar"]
["Uganda","UGX","Ugandan Shilling"]
["Zambia","ZMW","Zambian Kwacha"]
["Zimbabwe","ZWL","Zimbabwean Dollar"]
["Afghanistan","AFN","Afghan Afghani"]
["Armenia","AMD","Armenian Dram"]
["Azerbaijan","AZN","Azerbaijani Manat"]
["Bahrain","BHD","Bahraini Dinar"]
["Bangladesh","BDT","Bangladeshi Taka"]
["Bhutan","BTN","Bhutanese Ngultrum"]
["Brunei","BND","Brunei Dollar"]
["Cambodia","KHR","Cambodian Riel"]
["China","CNY","Chinese Yuan"]
["Cyprus","EUR","Euro"]
["Georgia","GEL","Georgian Lari"]
["India","INR","Indian Rupee"]
["Indonesia","IDR","Indonesian Rupiah"]
["Iran","IRR","Iranian Rial"]
["Iraq","IQD","Iraqi Dinar"]
["Israel","ILS","Israeli New Shekel"]
["Japan","JPY","Japanese Yen"]
["Jordan","JOD","Jordanian Dinar"]
["Kazakhstan","KZT","Kazakhstani Tenge"]
["Kuwait","KWD","Kuwaiti Dinar"]
["Kyrgyzstan","KGS","Kyrgyzstani Som"]
["Laos","LAK","Lao Kip"]
["Lebanon","LBP","Lebanese Pound"]
["Malaysia","MYR","Malaysian Ringgit"]
["Maldives","MVR","Maldivian Rufiyaa"]
["Mongolia","MNT","Mongolian Tugrik"]
["Myanmar","MMK","Myanmar Kyat"]
["Nepal","NPR","Nepalese Rupee"]
["North Korea","KPW","North Korean Won"]
["Oman","OMR","Omani Rial"]
["Pakistan","PKR","Pakistani Rupee"]
["Palestine","ILS","Israeli New Shekel"]
["Philippines","PHP","Philippine Peso"]
["Qatar","QAR","Qatari Riyal"]
["Russia","RUB","Russian Ruble"]
["Saudi Arabia","SAR","Saudi Riyal"]
["Singapore","SGD","Singapore Dollar"]
["South Korea","KRW","South Korean Won"]
["Sri Lanka","LKR","Sri Lankan Rupee"]
["Syria","SYP","Syrian Pound"]
["Tajikistan","TJS","Tajikistani Somoni"]
["Thailand","THB","Thai Baht"]
["Timor-Leste","USD","US Dollar"]
["Turkey","TRY","Turkish Lira"]
["Turkmenistan","TMT","Turkmenistani Manat"]
["United Arab Emirates","AED","UAE Dirham"]
["Uzbekistan","UZS","Uzbekistani Som"]
["Vietnam","VND","Vietnamese Dong"]
["Yemen","YER","Yemeni Rial"]
["Albania","ALL","Albanian Lek"]
["Andorra","EUR","Euro"]
["Austria","EUR","Euro"]
["Belarus","BYN","Belarusian Ruble"]
["Belgium","EUR","Euro"]
["Bosnia and Herzegovina","BAM","Bosnia and Herzegovina Convertible Mark"]
["Bulgaria","BGN","Bulgarian Lev"]
["Croatia","EUR","Euro"]
["Cyprus","EUR","Euro"]
["Czech Republic","CZK","Czech Koruna"]
["Denmark","DKK","Danish Krone"]
["Estonia","EUR","Euro"]
["Finland","EUR","Euro"]
["France","EUR","Euro"]
["Georgia","GEL","Georgian Lari"]
["Germany","EUR","Euro"]
["Greece","EUR","Euro"]
["Hungary","HUF","Hungarian Forint"]
["Iceland","ISK","Icelandic Króna"]
["Ireland","EUR","Euro"]
["Italy","EUR","Euro"]
["Kosovo","EUR","Euro"]
["Latvia","EUR","Euro"]
["Liechtenstein","CHF","Swiss Franc"]
["Lithuania","EUR","Euro"]
["Luxembourg","EUR","Euro"]
["Malta","EUR","Euro"]
["Moldova","MDL","Moldovan Leu"]
["Monaco","EUR","Euro"]
["Montenegro","EUR","Euro"]
["Netherlands","EUR","Euro"]
["North Macedonia","MKD","Macedonian Denar"]
["Norway","NOK","Norwegian Krone"]
["Poland","PLN","Polish Złoty"]
["Portugal","EUR","Euro"]
["Romania","RON","Romanian Leu"]
["Russia","RUB","Russian Ruble"]
["San Marino","EUR","Euro"]
["Serbia","RSD","Serbian Dinar"]
["Slovakia","EUR","Euro"]
["Slovenia","EUR","Euro"]
["Spain","EUR","Euro"]
["Sweden","SEK","Swedish Krona"]
["Switzerland","CHF","Swiss Franc"]
["Turkey","TRY","Turkish Lira"]
["Ukraine","UAH","Ukrainian Hryvnia"]
["United Kingdom","GBP","British Pound Sterling"]
["Vatican City","EUR","Euro"]
["Antigua and Barbuda","XCD","East Caribbean Dollar"]
["Bahamas","BSD","Bahamian Dollar"]
["Barbados","BBD","Barbadian Dollar"]
["Belize","BZD","Belize Dollar"]
["Canada","CAD","Canadian Dollar"]
["Costa Rica","CRC","Costa Rican Colón"]
["Cuba","CUP","Cuban Peso"]
["Dominica","XCD","East Caribbean Dollar"]
["Dominican Republic","DOP","Dominican Peso"]
["El Salvador","USD","US Dollar"]
["Grenada","XCD","East Caribbean Dollar"]
["Guatemala","GTQ","Guatemalan Quetzal"]
["Haiti","HTG","Haitian Gourde"]
["Honduras","HNL","Honduran Lempira"]
["Jamaica","JMD","Jamaican Dollar"]
["Mexico","MXN","Mexican Peso"]
["Nicaragua","NIO","Nicaraguan Córdoba"]
["Panama","PAB","Panamanian Balboa"]
["Saint Kitts and Nevis","XCD","East Caribbean Dollar"]
["Saint Lucia","XCD","East Caribbean Dollar"]
["Saint Vincent and the Grenadines","XCD","East Caribbean Dollar"]
["Trinidad and Tobago","TTD","Trinidad and Tobago Dollar"]
["United States","USD","US Dollar"]
["Argentina","ARS","Argentine Peso"]
["Bolivia","BOB","Bolivian Boliviano"]
["Brazil","BRL","Brazilian Real"]
["Chile","CLP","Chilean Peso"]
["Colombia","COP","Colombian Peso"]
["Ecuador","USD","US Dollar"]
["French Guiana","EUR","Euro"]
["Guyana","GYD","Guyanese Dollar"]
["Paraguay","PYG","Paraguayan Guaraní"]
["Peru","PEN","Peruvian Sol"]
["Suriname","SRD","Surinamese Dollar"]
["Uruguay","UYU","Uruguayan Peso"]
["Venezuela","VES","Venezuelan Bolívar"]

{"sheet":"Tables","index":11,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Substrate data  and tables"]
["Substrate","Bioconvertion rate to larvae","Bioconvention rate to frass","Waste reduction","Price",null,"Prosentage option",null,"Yes/no option",null,"Post prosessing",null,"Units"]
["Chicken feed",0.190266666666667,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.26706666666666701},0.73293333333333299,null,null,0,null,"Yes",null,"Microwave",null,"Reproduction Unit"]
["Chicken manure",7.5266666666666704E-2,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.49480000000000002},0.50519999999999998,null,null,0.1,null,"No",null,"Solar oven",null,"Grow-out Unit"]
["Cow manure",5.5649999999999998E-2,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.62070000000000003},0.37930000000000003,null,null,0.2,null,null,null,"Hot-air oven",null,"Both Reproduction and Grow-out Unit"]
["Faecal sludge",4.9000000000000002E-2,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.49319999999999997},0.50680000000000003,null,null,0.3,null,null,null,"Other"]
["Food waste",0.18886,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.42244999999999999},0.57755000000000001,null,null,0.4]
["Fruits  ",0.18099999999999999,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.33035000000000003},0.66964999999999997,null,null,0.5]
["Pig manure",9.4333333333333297E-2,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.62580000000000002},0.37419999999999998,null,null,0.6]
["Vegetable waste",0.21213333333333301,{"$f":"1-Substrate[[#This Row],[Waste reduction]]","v":0.49913333333333298},0.50086666666666702,null,null,0.7]
["Other",0.1,0.3,null,null,null,0.8]
[null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,1]