{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"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":"Sheet1","index":0,"n_rows":119,"n_cols":7,"rows_kept":119,"cut":false,"hidden":false,"merged":[[46,0,46,5],[118,0,118,1],[0,0,0,5],[1,0,1,2],[12,0,12,5],[21,0,21,5],[27,0,27,5],[117,0,117,1],[61,0,61,5],[68,0,68,5],[79,0,79,5],[92,0,92,5],[98,0,98,5],[112,0,112,5]]}
["Size (Peak day design capacity, gallons per day)"]
["(Check only one box)"]
[null,null,null,null,false,{"$f":"IF(E3,\"1\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E4,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E5,\"4\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E6,\"9\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E7,\"12\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E8,\"16\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E9,\"20\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E10,\"25\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E11,\"30\",\"0\")","v":"0"},{"$f":"SUM(F3+F4+F5+F6+F7+F8+F9+F10+F11)","v":0}]
[]
["Pretreatment"]
[null,null,null,null,false,{"$f":"IF(E14,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E15,\"1\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E16,\"1\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E17,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E18,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E19,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E20,\"2\",\"0\")","v":"0"},{"$f":"F14+F15+F16+F17+F18+F19+F20","v":0}]
[]
["Primary Treatment"]
[null,null,null,null,false,{"$f":"IF(E23,\"4\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E24,\"7\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E25,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E26,\"16\",\"0\")","v":"0"},{"$f":"F23+F24+F25+F26","v":0}]
[]
["Secondary Treatment"]
[null,null,null,null,false,{"$f":"IF(E29,\"5\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E30,\"8\",\"0\")","v":"0"}]
[]
[null,null,null,null,false,{"$f":"IF(E32,\"8\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E33,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E34,\"15\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E35,\"20\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E36,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E37,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E38,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E39,\"8\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E40,\"5\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E41,\"8\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E42,\"4\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E43,\"7\",\"0\")","v":"0"},{"$f":"F29+F30+F32+F33+F34+F35+F36+F37+F38+F39+F40+F41+F42+F43","v":0}]
[]
[]
[]
["Advanced Waste Treatment"]
[null,null,null,null,false,{"$f":"IF(E48,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E49,\"20\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E50,\"15\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E51,\"4\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E52,\"8\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E53,\"8\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E54,\"12\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E55,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E56,\"12\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E57,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E58,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E59,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E60,\"8\",\"0\")","v":"0"},{"$f":"F48+F49+F50+F51+F52+F53+F54+F55+F56+F57+F58+F59+F60","v":0}]
[]
["In-plant Odor Control (maximum of six points in any combination)"]
[null,null,null,null,false,{"$f":"IF(E63,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E64,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E65,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E66,\"6\",\"0\")","v":"0"},{"$f":"F63+F64+F65+F66+F67","v":0}]
[null,null,null,null,false,{"$f":"IF(E67,\"2\",\"0\")","v":"0"},{"$f":"IF(G66>=6, \"6\",IF(G66<6, G66))","v":0}]
[]
["Sludge Thickening and Dewatering"]
[null,null,null,null,false,{"$f":"IF(E70,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E71,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E72,\"4\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E73,\"5\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E74,\"6\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E75,\"8\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E76,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E77,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E78,\"3\",\"0\")","v":"0"},{"$f":"F70+F71+F72+F73+F74+F75+F76+F77+F78","v":0}]
[]
["Sludge Stabilization and Conditioning"]
[null,null,null,null,false,{"$f":"IF(E81,\"8\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E82,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E83,\"5\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E84,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E85,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E86,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E87,\"5\",\"0\")","v":"0"},{"$f":"F81+F82+F83+F84+F85+F86+F87","v":0}]
[]
[]
[]
[]
[]
["Solids Disposal"]
[null,null,null,null,false,{"$f":"IF(E94,\"12\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E95,\"5\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E96,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E97,\"1\",\"0\")","v":"0"},{"$f":"F94+F95+F96+F97","v":0}]
[]
["Disinfection"]
[null,null,null,null,false,{"$f":"IF(E100,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E101,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E102,\"12\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E103,\"12\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E104,\"1\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E105,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E106,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E107,\"4\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E108,\"5\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E109,\"10\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E110,\"3\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E111,\"1\",\"0\")","v":"0"},{"$f":"F100+F101+F102+F103+F104+F105+F106+F107+F108+F109+F110+F111","v":0}]
[]
["Effluent Discharge"]
[null,null,null,null,false,{"$f":"IF(E114,\"2\",\"0\")","v":"0"}]
[null,null,null,null,false,{"$f":"IF(E115,\"2\",\"0\")","v":"0"},{"$f":"F114+F115","v":0}]
[null,null,null,null,null,null,{"$f":"G115+G111+G97+G87+G78+G67+G60+G43+G26+G20+G11","v":0}]
[]
["Total Points",null,{"$f":"G116","v":0}]
["Classification",null,{"$f":"IF(C118>75, \"Class 4\", IF(C118>55, \"Class 3\", IF(C118>30, \"Class 2\", IF(C118>0, \"Class 1\", \"Enter Data\"))))","v":"Enter Data"}]