{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["per Safley and Westerman"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"per Safley and Westerman","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
["Effect of temperature on biogas, at least according to one formula…"]
[]
[]
[null,"Equation from \"Psychrophilic anaerobic digestion of animal manure: Proposed design methodology\" by Safley and Westerman"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"David William House"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.completebiogas.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CompleteBiogas@gmail.com"]
[null,null,"LR2","=","Loading rate at temperature T2 (kg VS/m3) of reference digester"]
[null,null,"LR1","=","Loading rate at temperature T1 (kg VS/m3) of lower temp digester"]
[null,null,"T1","=","Temperature of digestion of the reference digester"]
[null,null,"T2","=","Temperature of the lower temp digester"]
[null,null,"p","=","0.1, rate constant per °C-1"]
[]
[]
[]
[]
[]
[null,null,"LR2","=","?","kg VS/m3","Solve for LR2"]
[null,null,"LR1","=",2,"kg VS/m3","(LR for silage, from \"Biogas production from mono-digestion of maize\" by Lebuhn et al)"]
[null,null,"T1","=",38,"°C","ref temp from above"]
[null,null,"T2","=","(varies)"]
[null,null,"p","=",0.1]
[]
[null,"Since the loading rate is directly proportional to the gas production, the formula will provide a ratio that applies to either."]
[null,"(In other words, if the LR should be 25% of the reference digester, then the gas production will also be 25% of the ref digester."]
[null,"Therefore to achieve a comparable gas production, the size of the digester must increase by the reciprocal: i.e. @ 25% LR, "]
[null,"digester vol would have to be 4x to achieve comparable gas production.)"]
[]
[null,"@",38,"°C",{"$f":"LoadRate1*(EXP(RateConstant*(C32-Temp1)))","v":2},"kg VS/m3",{"$f":"CONCATENATE(\"i.e., either LR or vol/da will be \",ROUND(E32/LoadRate1*100,2),\"% at \",C32,\"°C (\",convTempCtoF(C32),\"°F)\")","v":"i.e., either LR or vol/da will be 100% at 38°C (100.4°F)"}]
[null,"@",30,"°C",{"$f":"LoadRate1*(EXP(RateConstant*(C33-Temp1)))","v":0.89865792823444313},"kg VS/m3",{"$f":"CONCATENATE(\"i.e., either LR or vol/da will be \",ROUND(E33/LoadRate1*100,2),\"% at \",C33,\"°C (\",convTempCtoF(C33),\"°F)\")","v":"i.e., either LR or vol/da will be 44.93% at 30°C (86°F)"}]
[null,"@",20,"°C",{"$f":"LoadRate1*(EXP(RateConstant*(C34-Temp1)))","v":0.33059777644317306},"kg VS/m3",{"$f":"CONCATENATE(\"i.e., either LR or vol/da will be \",ROUND(E34/LoadRate1*100,2),\"% at \",C34,\"°C (\",convTempCtoF(C34),\"°F)\")","v":"i.e., either LR or vol/da will be 16.53% at 20°C (68°F)"}]
[null,"@",13,"°C",{"$f":"LoadRate1*(EXP(RateConstant*(C35-Temp1)))","v":0.1641699972477976},"kg VS/m3",{"$f":"CONCATENATE(\"i.e., either LR or vol/da will be \",ROUND(E35/LoadRate1*100,2),\"% at \",C35,\"°C (\",convTempCtoF(C35),\"°F)\")","v":"i.e., either LR or vol/da will be 8.21% at 13°C (55.4°F)"}]
[null,"@",10,"°C",{"$f":"LoadRate1*(EXP(RateConstant*(C36-Temp1)))","v":0.1216201252504359},"kg VS/m3",{"$f":"CONCATENATE(\"i.e., either LR or vol/da will be \",ROUND(E36/LoadRate1*100,2),\"% at \",C36,\"°C (\",convTempCtoF(C36),\"°F)\")","v":"i.e., either LR or vol/da will be 6.08% at 10°C (50°F)"}]