{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Macro","License","Introduction","Biogas","Plug Flow Codigester","Parameters"],"not_rendered":{"charts":0,"images":149,"macros":1,"external_links":0,"defined_names":1,"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":"Macro","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,2,3]]}
[]
[null,"Enable Macros"]
[]
[]
[null,"Before you can use RTI’s Biogas Codigester Creator Tool, you will need to enable Macros in Excel."]
[]
[]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have enabled Macros in Excel, continue to the Biogas Codigester Creator Tool."]

{"sheet":"License","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,1],[24,2,24,3],[24,5,24,6],[3,1,3,9],[1,0,2,10]]}
[]
["RTI’s Biogas Codigester Creator Tool (Ver. 3.0)"]
[]
[null,"RTI International, Turning Knowledge Into Practice"]
[]
[]
[null,"Terms and conditions:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"I agree to these conditions:  "]
[]
[]
[]
["Version 3.0",null,"2019-02-04T17:18:43",null,"Expires:","2019-08-04T17:18:43"]

{"sheet":"Introduction","index":2,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,1,5]]}
["RTI’s Biogas Codigester Creator"]
[]
[]
[]
["1)","What are the sources of influent into the Biogas Codigester?",null,null,null,null,null,null,null,null,null,"        C:N Ratio of influent Codigester Waste:"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"a) Animal (Brown) Waste",null,null,null,null,"Units"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"i)",null,null,null,null,null,"Chickens"]
[]
[null,"ii)"]
[]
[null,"iii)"]
[]
[null,"iv)"]
[]
[null,"v)"]
[]
[null,"b) Crop (Green) Waste",null,null,null,null,"Units"]
[]
[null,"i)",null,null,null,null,null,"Kg"]
[]
[null,"ii)",null,null,null,null,null,"Kg"]
[]
[null,"iii)",null,null,null,null,null,"Kg"]
[]
[null,"iv)",null,null,null,null,null,"Kg"]
[]
[null,"v)",null,null,null,null,null,"Kg"]
[]
[null,"c) Food Related Waste",null,null,null,null,"Units"]
[]
[null,"i)",null,null,null,null,null,"Kg"]
[]
[null,"ii)",null,null,null,null,null,"Kg"]
[]
[]
["2)","What is the climate for the region your project is located in?"]
[]
[]
[]
["3)","What is the detention time for your system?"]
[]
[null,null,null,null,"Days"]

{"sheet":"Biogas","index":3,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":true,"merged":[[22,3,22,5],[35,17,36,17],[33,1,34,2],[11,1,12,2],[0,0,1,3],[1,15,1,19],[2,15,2,19],[34,18,34,19],[32,11,32,12]]}
["Dome Biogas Codigester"]
[null,null,null,null,null,null,null,null,null,"Dome Fermentation Chamber",null,null,null,null,null,"Hydraulic Chamber (Overflow Tank)"]
[]
[]
[null,null,null,null,"Influents"]
[null,null,null,"Total Discharge:",387799.64999999997,"Kg/day"]
[null,null,null,"Total Solid of fresh Discharge:",37228.766399999993,"Kg/day"]
[null,null,null,"Water Added:",77559.929999999993,"L/day",null,null,null,null,"Biogas Chamber Volume:",31023.971999999994,"m³"]
[null,null,null,"Total Influent:",465359.5799999999,"Kg/day",null,null,null,null,"Biogas Chamber Diameter:",41.09,"m"]
[null,null,null,null,null,null,null,null,null,null,"Biogas Chamber Height:",29.803302968901313,"m"]
[]
[null,"Plan View"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Outputs"]
[null,null,null,"Lower","Average","Upper"]
[null,null,"Methane (m³): ",10710.656999999997,12600.552427649996,14490.447855299995]
[null,null,"Power (KW):",1492.3871186254391,1755.7188257068981,2019.0505327883568]
[null,null,"Stove Hours (hrs/day):",19279.182599999993,22680.994369769996,26082.806139539993]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,"  .3 m",null,null,null,null,null,null,null,"4.41 m"]
[null,"Profile View"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tank Volume: ","200735.36 m³"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"240.76 m"]
[]
[]
[]
[]
[]
[null,null,"Dome Geometrical Dimensions",null,null,null,null,null,null,null,null,null,null,"16.45 m"]
[null,null,"Upper Dome Volume:",5738.8768901817984,"m³",null,null,null,null,null,null,null,"10.48 m",null,null,null,null,null,"Biogas System Volumes"]
[null,null,"Cross Sectional Volume:",21803.568547704002,"m³",null,null,null,null,null,null,null,null,null,null,null,null,null,"Biogas Chamber Volume:",31023.971999999994,"m³"]
[null,null,"Lower Dome Volume:",3477.3291531681975,"m³",null,null,null,null,null,"41.09 m",null,null,null,null,null,null,null,"Gas Collecting Chamber Volume:",1551.1985999999997,"m³"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Storage Chamber Volume:",12099.349079999998,"m³"]
[null,null,"Upper Dome Height:",8.2187126265621604,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fermentation Chamber Volume:",12719.828519999995,"m³"]
[null,null,"Cross Sectional Height:",16.447894950737801,"m",null,null,null,null,null,null,null,null,null,null," ",null,null,"Sludge Layer Volume:",4653.5957999999991,"m³"]
[null,null,"Lower Dome Height:",5.13669539160135,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydaulic Chamber Volume:",200735.356778213,"m³"]

{"sheet":"Plug Flow Codigester","index":4,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,0,1,4],[32,23,32,24],[33,22,34,22],[2,18,2,22],[9,1,10,2],[30,11,30,12],[31,1,32,2],[19,3,19,5]]}
["Plug Flow Biogas Codigester"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydraulic Chamber (Overflow Tank)"]
[null,null,null,null,"Influents",null,null,null,null,null,"Fermentation Bag Chamber",null,null,null,null,null,null,null,null,null,"Hydraulic Chamber Volume:",0.23549999999999999,"m³"]
[null,null,null,"Total Discharge:",387799.64999999997,"Kg/day",null,null,null,null,null,"Biogas Chamber Volume:",22562.888727272726,"m³",null,null,null,null,null,null,"Hydraulic Chamber Diameter:",1,"m"]
[null,null,null,"Total Solid of fresh Discharge:",37228.766399999993,"Kg/day",null,null,null,null,null,"Biogas Chamber Length:",89.568441568498557,"m",null,null,null,null,null,null,"Hydraulic Chamber Height:",0.3,"m"]
[null,null,null,"Water Added:",-49356.319090909084,"L/day",null,null,null,null,null,"Biogas Chamber Diameter:",17.913688313699712,"m"]
[null,null,null,"Total Influent:",338443.33090909087,"Kg/day"]
[]
[null,"Plan View"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Outputs",null,null,null,null,null,null,null,null,null,"Gas Storage Bag"]
[null,null,null,"Lower","Average","Upper",null,null,null,null,null,null,"Gas Storage Bag Volume:",8.7359999999999989,"m³"]
[null,null,"Methane (m³): ",10710.656999999997,12600.552427649996,14490.447855299995]
[null,null,"Power (KW):",1492.3871186254391,1755.7188257068981,2019.0505327883568,null,"       Moisture Trap"]
[null,null,"Stove Hours (hrs/day):",19279.182599999993,22680.994369769996,26082.806139539993]
[]
[]
[]
[]
[]
[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,null,null,null,"0.3 m"]
[null,"Profile View",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 m"]
[null,null,null,null,null,null,null,null,null,null,null,"89.57 m"]
[]
[]
[null,null,"Bag Geometrical Dimensions",null,null,null,null,null,null,null,null,null,null,"17.91 m",null,null,null,null,null,null,null,"Biogas System Volumes"]
[null,null,"Bag Codigester Volume:",22562.888727272726,"m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biogas Chamber Volume:",22562.888727272726,"m³"]
[null,null,"Bag Codigester Length:",89.568441568498557,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Collecting Chamber Volume:",1128.1444363636363,"m³"]
[null,null,"Bag Codigester diameter:",17.913688313699712,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Storage Chamber Volume:",12099.349079999998,"m³"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fermentation Chamber Volume:",5950.961901818182,"m³"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sludge Layer Volume:",3384.433309090909,"m³"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydaulic Chamber Volume:",0.23549999999999999,"m³"]

{"sheet":"Parameters","index":5,"n_rows":58,"n_cols":20,"rows_kept":58,"cut":false,"hidden":true,"merged":[[46,5,47,6],[48,5,49,6],[46,1,47,2],[46,3,47,4],[46,7,47,8],[46,9,47,10],[46,11,47,12],[48,1,49,2],[48,3,49,4],[48,7,49,8],[48,9,49,10],[48,11,49,12],[14,13,15,14],[27,1,28,2],[27,9,28,10],[23,3,24,4],[23,5,24,6],[23,7,24,8],[23,9,24,10],[25,9,26,10],[25,3,26,4],[25,5,26,6],[25,7,26,8],[25,1,26,2],[27,11,28,12],[27,3,28,4],[27,5,28,6],[27,7,28,8],[0,0,1,2],[10,3,11,4],[12,1,13,2],[16,1,17,2],[18,1,19,2],[14,1,15,2],[14,3,15,4],[14,17,15,18],[14,19,15,20],[10,5,11,6],[12,5,13,6],[14,5,15,6],[16,5,17,6],[18,5,19,6],[10,9,11,10],[10,11,11,12],[12,9,13,10],[12,11,13,12],[14,9,15,10],[14,11,15,12],[16,9,17,10],[16,11,17,12],[18,9,19,10],[18,11,19,12],[10,19,11,20],[12,19,13,20],[16,19,17,20],[18,19,19,20],[23,11,24,12],[25,11,26,12],[10,7,11,8],[12,7,13,8],[14,7,15,8],[16,7,17,8],[18,7,19,8],[16,13,17,14],[18,13,19,14],[10,15,11,16],[12,15,13,16],[16,15,17,16],[18,15,19,16],[10,17,11,18],[12,17,13,18],[16,17,17,18],[18,17,19,18],[10,13,11,14],[12,13,13,14],[14,15,15,16],[12,3,13,4],[16,3,17,4],[18,3,19,4],[34,11,35,12],[36,1,37,2],[36,3,37,4],[36,7,37,8],[36,9,37,10],[36,11,37,12],[34,1,35,2],[34,3,35,4],[34,7,35,8],[34,9,35,10],[36,5,37,6],[32,5,33,6],[34,5,35,6],[32,3,33,4],[32,7,33,8],[32,9,33,10],[32,11,33,12],[38,11,39,12],[40,3,41,4],[40,7,41,8],[40,9,41,10],[40,11,41,12],[40,1,41,2],[38,1,39,2],[38,3,39,4],[38,7,39,8],[38,9,39,10],[38,5,39,6],[40,5,41,6],[42,9,43,10],[42,11,43,12],[44,3,45,4],[44,7,45,8],[44,9,45,10],[44,11,45,12],[42,1,43,2],[44,1,45,2],[42,3,43,4],[42,7,43,8],[42,5,43,6],[44,5,45,6],[57,1,58,2],[57,3,58,4],[57,7,58,8],[57,9,58,10],[57,11,58,12],[53,3,54,4],[53,7,54,8],[53,9,54,10],[53,11,54,12],[55,1,56,2],[55,3,56,4],[55,7,56,8],[55,9,56,10],[55,11,56,12],[53,5,54,6],[55,5,56,6],[57,5,58,6]]}
["Parameters"]
[]
[]
[]
["1)","Percent Total Solids (TS) of Codigester feed"]
[]
[null,null,"a) Dome Codigester:",null,null,"%","b) Plug Flow Codigester:",null,null,"%"]
[]
["2)","Animal (Brown) Waste"]
[]
[null,null,null,"Discharge per day (kg)",null,"Average Animal Weight (kg)",null,"Assumed Animal Weight (kg)",null,"VS (kg) per day",null,"CH4 m³ per VS (m³/kg)",null,"TS of Fresh Discharge (%)",null,"Percent Carbon of Waste (%)",null,"Percent Nitrogen of Waste (%)",null,"Moisture of Waste (%)"]
[]
[null,"  a) Cows - Dairy"]
[]
[null,"  b) Cows - Beef"]
[]
[null,"  c) Chickens"]
[]
[null,"  d) Pigs - Market/ Breeding"]
[]
[]
["3)","Human Waste"]
[]
[null,null,null,"Discharge per day (kg)",null,"TS of Fresh Discharge (%)",null,"Percent Carbon of Waste (%)",null,"Percent Nitrogen of Waste (%)",null,"Moisture of Waste (%)"]
[]
[null,"  a) Feaces"]
[]
[null,"  b) Urine"]
[]
[]
["4)","Crop (Green) Waste"]
[]
[null,null,null,"TS of Fresh Discharge (%)",null,"VS of Fresh Discharge (%)",null,"Percent Carbon of Waste (%)",null,"Percent Nitrogen of Waste (%)",null,"Moisture of Waste (%)"]
[]
[null,"  a) Corn Straw"]
[]
[null,"  b) Fruit Waste"]
[]
[null,"  c) Grass"]
[]
[null,"  d) Rice Straw"]
[]
[null,"  e) Water Hyacinth"]
[]
[null,"  f) Wheat Straw"]
[]
[null,"  g) Corn Stalk"]
[]
[null,"  h) Oat Straw"]
[]
[]
["5)","Food Related Waste"]
[]
[null,null,null,"TS of Fresh Discharge (%)",null,"VS of Fresh Discharge (%)",null,"Percent Carbon of Waste (%)",null,"Percent Nitrogen of Waste (%)",null,"Moisture of Waste (%)"]
[]
[null,"  a) Food Waste"]
[]
[null,"  b) Fat, Oils, Grease"]