{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Unit Conversion","Lookup","SigFigures","Treatment Efficiency","F-M Ratio","Sludge Generation","Alkalinity - Nitrification","Flow Concentration & Loading","Geometric Mean"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":42,"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":"Unit Conversion","index":0,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[null,null,null,null,null,null,null,null,null,null,"Click Here to Select Type of Conversion"]
[null,"Unit Conversions",null,null,null,null,null,null,null,null,"Area"]
[null,null,null,null,null,null,null,null,null,null,"Flow"]
[null,"Click Here to Select Type of Conversion",null,null,null,null,null,null,null,null,"Length"]
[null,"Enter Value","Select Unit of Measurement 1","Converts To","Result","Select Unit of Measurement 2",null,"Area Lookup","Result",null,"Mass"]
[null,null,null,{"$f":"IF(AND(B6<>\"\",C6<>\"\"),\"=\",\"\")","v":""},{"$f":"IFERROR(IF(AND(D6<>\"\",F6<>\"\"),IF(ROUND(I24,SigFigures!C24)=0,I24,ROUND(I24,SigFigures!C24)),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(Lookup!$A$2:$A$82,SMALL(IF((Lookup!$B$2:$B$82=C6)*(Lookup!$C$2:$C$82=F6),ROW($2:$82)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND(D6<>\"\",F6<>\"\",B4=\"Area\"),B6*H6,\"\")","v":""},null,"Power"]
[null,null,null,null,null,null,null,"Volume Lookup","Result",null,"Pressure"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!$E$2:$E$145,SMALL(IF((Lookup!$F$2:$F$145=C6)*(Lookup!$G$2:$G$145=F6),ROW($2:$145)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Volume\"),$B$6*H8,\"\")","v":""},null,"Temperature"]
[null,null,null,null,null,null,null,"Flow Lookup","Result",null,"Time"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!$I$2:$I$101,SMALL(IF((Lookup!$J$2:$J$101=C6)*(Lookup!$K$2:$K$101=F6),ROW($2:$101)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Flow\"),$B$6*H10,\"\")","v":""},null,"Volume"]
[null,null,null,null,null,null,null,"Length Lookup","Result"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!$M$2:$M$82,SMALL(IF((Lookup!$N$2:$N$82=C6)*(Lookup!$O$2:$O$82=F6),ROW($2:$82)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Length\"),$B$6*H12,\"\")","v":""}]
[null,null,null,null,null,null,null,"Power Lookup","Result"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!$W$2:$W$65,SMALL(IF((Lookup!$X$2:$X$65=C6)*(Lookup!$Y$2:$Y$65=F6),ROW($2:$65)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Power\"),$B$6*H14,\"\")","v":""}]
[null,null,null,null,null,null,null,"Pressure Lookup","Result"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!$AA$2:$AA$50,SMALL(IF((Lookup!$AB$2:$AB$50=C6)*(Lookup!$AC$2:$AC$50=F6),ROW($2:$50)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Pressure\"),$B$6*H16,\"\")","v":""}]
[null,null,null,null,null,null,null,"Temperature Lookup","Result"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Temperature\"),IF(AND(C6=\"Degrees Fahrenheit\",F6=\"Degrees Celsius\"),ROUND(0.55555*(B6-32),2),IF(AND(C6=\"Degrees Fahrenheit\",F6=\"Degrees Fahrenheit\"),B6,IF(AND(C6=\"Degrees Celsius\",F6=\"Degrees Celsius\"),B6,IF(AND(C6=\"Degrees Celsius\",F6=\"Degrees Fahrenheit\"),ROUND((1.8*B6)+32,2),IF(AND(C6=\"Degrees Kelvin\",F6=\"Degrees Kelvin\"),B6,IF(AND(C6=\"Degrees Rankine\",F6=\"Degrees Rankine\"),B6,IF(AND(C6=\"Degrees Fahrenheit\",F6=\"Degrees Kelvin\"),ROUND((0.55555*B6)+255.37,2),IF(AND(C6=\"Degrees Fahrenheit\",F6=\"Degrees Rankine\"),B6+459.67,IF(AND(C6=\"Degrees Kelvin\",F6=\"Degrees Fahrenheit\"),ROUND(1.8*(B6-255.37),2),IF(AND(C6=\"Degrees Rankine\",F6=\"Degrees Fahrenheit\"),ROUND(B6-459.67,2),IF(AND(C6=\"Degrees Celsius\",F6=\"Degrees Kelvin\"),ROUND(B6+273.15,2),IF(AND(C6=\"Degrees Celsius\",F6=\"Degrees Rankine\"),ROUND(1.8*(B6+491.67),2),IF(AND(C6=\"Degrees Kelvin\",F6=\"Degrees Celsius\"),ROUND(B6-273.15,2),IF(AND(C6=\"Degrees Rankine\",F6=\"Degrees Celsius\"),ROUND(0.55555*(B6-491.67),2),IF(AND(C6=\"Degrees Kelvin\",F6=\"Degrees Rankine\"),ROUND(1.8*B6,2),IF(AND(C6=\"Degrees Rankine\",F6=\"Degrees Kelvin\"),ROUND(0.55555*B6,2),\"\")))))))))))))))),\"\")","v":""}]
[null,null,null,null,null,null,null,"Time Lookup","Result"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!$S$2:$S$65,SMALL(IF((Lookup!$T$2:$T$65=C6)*(Lookup!$U$2:$U$65=F6),ROW($2:$65)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Time\"),$B$6*H20,\"\")","v":""}]
[null,null,null,null,null,null,null,"Mass Lookup","Result"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!$AE$2:$AE$65,SMALL(IF((Lookup!$AF$2:$AF$65=C6)*(Lookup!$AG$2:$AG$65=F6),ROW($2:$65)-ROW($1:$1)),ROW($A1))),\"\")","v":""},{"$f":"IF(AND($D$6<>\"\",$F$6<>\"\",$B$4=\"Mass\"),$B$6*H22,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Use Result"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I6<>\"\",I6,IF(I8<>\"\",I8,IF(I10<>\"\",I10,IF(I12<>\"\",I12,IF(I14<>\"\",I14,IF(I16<>\"\",I16,IF(I18<>\"\",I18,IF(I20<>\"\",I20,IF(I22<>\"\",I22))))))))),\"\")","v":false}]

{"sheet":"Lookup","index":1,"n_rows":145,"n_cols":33,"rows_kept":145,"cut":false,"hidden":true,"merged":[]}
["Value","Area_1","Area_2",null,"Value","Volume_1","Volume_2",null,"Value","Flow_1","Flow_2",null,"Value","Length_1","Length_2",null,"Temp",null,"Value","Time_1","Time_2",null,"Value","Power_1","Power_2",null,"Value","Pressure_1","Pressure_2",null,"Value","Weight_1","Weight_2"]
[1,"Acres","Acres",null,1,"Gallons","Gallons",null,1,"Gallons/Day","Gallons/Day",null,1,"Miles","Miles",null,"Degrees Fahrenheit",null,1,"Milliseconds","Milliseconds",null,1,"BTU/Minute","BTU/Minute",null,1,"Atmospheres","Atmospheres",null,1,"Grams","Grams"]
[0.40468700000000002,"Acres","Hectares",null,3.0689E-6,"Gallons","Acre-Feet",null,6.9444000000000005E-4,"Gallons/Day","Gallons/Minute",null,5280,"Miles","Feet",null,"Degrees Celsius",null,1E-3,"Milliseconds","Seconds",null,60,"BTU/Minute","BTU/Hour",null,1.01325,"Atmospheres","Bars",null,1000,"Grams","Milligrams"]
[40468700,"Acres","Square Centimeters",null,3785.4,"Gallons","Cubic Centimeters",null,1.15741E-5,"Gallons/Day","Gallons/Second",null,160934,"Miles","Centimeters",null,"Degrees Kelvin",null,1.666E-5,"Milliseconds","Minutes",null,778.17,"BTU/Minute","Foot-Pound/Minute",null,29.920999999999999,"Atmospheres","Inches Hg at 32 Degrees F",null,1E-3,"Grams","Kilograms"]
[43560,"Acres","Square Feet",null,0.13367999999999999,"Gallons","Cubic Feet",null,9.9999999999999995E-7,"Gallons/Day","Million Gallons/Day",null,1609340,"Miles","Millimeters",null,"Degrees Rankine",null,2.7776999999999998E-7,"Milliseconds","Hours",null,12.9696,"BTU/Minute","Foot-Pound/Second",null,760,"Atmospheres","Millimeters Hg at 0 Degrees C",null,15.432,"Grams","Grains"]
[6272660,"Acres","Square Inches",null,231,"Gallons","Cubic Inches",null,0.13367200000000001,"Gallons/Day","Cubic Feet/Day",null,1.60934,"Miles","Kilometers",null,null,null,1.1574E-8,"Milliseconds","Days",null,2.3574999999999999E-2,"BTU/Minute","Horsepower",null,101325,"Atmospheres","Pascals",null,3.5274E-2,"Grams","Ounces"]
[4.0468700000000002E-3,"Acres","Square Kilometers",null,3.7854E-3,"Gallons","Cubic Meters",null,9.2830000000000004E-5,"Gallons/Day","Cubic Feet/Minute",null,1609.34,"Miles","Meters",null,null,null,1.6534000000000001E-9,"Milliseconds","Weeks",null,17.576000000000001,"BTU/Minute","Watts",null,14.696,"Atmospheres","Pounds/Square Inch",null,2.2046000000000001E-3,"Grams","Pounds"]
[4046.87,"Acres","Square Meters",null,4.9509999999999997E-3,"Gallons","Cubic Yards",null,1.54713E-6,"Gallons/Day","Cubic Feet/Second",null,63360,"Miles","Inches",null,null,null,3.9193999999999999E-10,"Milliseconds","Months",null,1.7576000000000001E-2,"BTU/Minute","Kilowatts",null,760,"Atmospheres","Torrs",null,1.1023E-6,"Grams","Tons"]
[1.5625000000000001E-3,"Acres","Square Miles",null,3.7854000000000001,"Gallons","Liters",null,3.7854000000000001,"Gallons/Day","Liters/Day",null,1760,"Miles","Yards",null,null,null,4.5899999999999996E-12,"Milliseconds","Years",null,1.7575999999999999E-5,"BTU/Minute","Megawatts",null,0.98692299999999999,"Bars","Atmospheres",null,9.9999999999999995E-7,"Grams","Metric Tons"]
[4840,"Acres","Square Yards",null,3785.4,"Gallons","Milliliters",null,2.6289999999999998E-3,"Gallons/Day","Liters/Minute",null,8,"Miles","Furlongs",null,null,null,1000,"Seconds","Milliseconds",null,1.6666E-2,"BTU/Hour","BTU/Minute",null,1,"Bars","Bars",null,1E-3,"Milligrams","Grams"]
[2.4710399999999999,"Hectares","Acres",null,128,"Gallons","Ounces",null,4.3812500000000001E-5,"Gallons/Day","Liters/Second",null,1.894E-4,"Feet","Miles",null,null,null,1,"Seconds","Seconds",null,1,"BTU/Hour","BTU/Hour",null,29.53,"Bars","Inches Hg at 32 Degrees F",null,1,"Milligrams","Milligrams"]
[1,"Hectares","Hectares",null,8,"Gallons","Pints",null,1440,"Gallons/Minute","Gallons/Day",null,1,"Feet","Feet",null,null,null,1.66666E-2,"Seconds","Minutes",null,12.9696,"BTU/Hour","Foot-Pound/Minute",null,750,"Bars","Millimeters Hg at 0 Degrees C",null,9.9999999999999995E-7,"Milligrams","Kilograms"]
[100000000,"Hectares","Square Centimeters",null,4,"Gallons","Quarts",null,1,"Gallons/Minute","Gallons/Minute",null,30.48,"Feet","Centimeters",null,null,null,2.7769999999999997E-4,"Seconds","Hours",null,0.21615999999999999,"BTU/Hour","Foot-Pound/Second",null,100000,"Bars","Pascals",null,1.5432E-2,"Milligrams","Grains"]
[107639,"Hectares","Square Feet",null,352851,"Acre-Feet","Gallons",null,1.66666E-2,"Gallons/Minute","Gallons/Second",null,304.8,"Feet","Millimeters",null,null,null,1.1574E-5,"Seconds","Days",null,3.9290000000000001E-4,"BTU/Hour","Horsepower",null,14.504,"Bars","Pounds/Square Inch",null,3.5274000000000001E-5,"Milligrams","Ounces"]
[15499993.800000001,"Hectares","Square Inches",null,1,"Acre-Feet","Acre-Feet",null,1.4400000000000001E-3,"Gallons/Minute","Million Gallons/Day",null,3.0479999999999998E-4,"Feet","Kilometers",null,null,null,1.6533999999999999E-6,"Seconds","Weeks",null,0.29310000000000003,"BTU/Hour","Watts",null,750,"Bars","Torrs",null,2.2046E-6,"Milligrams","Pounds"]
[0.01,"Hectares","Square Kilometers",null,1335682175,"Acre-Feet","Cubic Centimeters",null,192.49,"Gallons/Minute","Cubic Feet/Day",null,0.30480000000000002,"Feet","Meters",null,null,null,3.9194E-7,"Seconds","Months",null,2.9310000000000002E-4,"BTU/Hour","Kilowatts",null,3.3419999999999998E-2,"Inches Hg at 32 Degrees F","Atmospheres",null,1.1023E-9,"Milligrams","Tons"]
[10000,"Hectares","Square Meters",null,43560,"Acre-Feet","Cubic Feet",null,0.13370000000000001,"Gallons/Minute","Cubic Feet/Minute",null,12,"Feet","Inches",null,null,null,3.1689E-8,"Seconds","Years",null,2.931E-7,"BTU/Hour","Megawatts",null,3.3860000000000001E-2,"Inches Hg at 32 Degrees F","Bars",null,1.0000000000000001E-9,"Milligrams","Metric Tons"]
[3.8610200000000002E-3,"Hectares","Square Miles",null,81508581,"Acre-Feet","Cubic Inches",null,2.2279999999999999E-3,"Gallons/Minute","Cubic Feet/Second",null,0.33333000000000002,"Feet","Yards",null,null,null,60000,"Minutes","Milliseconds",null,1.2841E-3,"Foot-Pound/Minute","BTU/Minute",null,1,"Inches Hg at 32 Degrees F","Inches Hg at 32 Degrees F",null,1000,"Kilograms","Grams"]
[11959.9,"Hectares","Square Yards",null,1233.5,"Acre-Feet","Cubic Meters",null,5451,"Gallons/Minute","Liters/Day",null,1.51515E-3,"Feet","Furlongs",null,null,null,60,"Minutes","Seconds",null,7.6999999999999999E-2,"Foot-Pound/Minute","BTU/Hour",null,25.4,"Inches Hg at 32 Degrees F","Millimeters Hg at 0 Degrees C",null,1000000,"Kilograms","Milligrams"]
[2.4710455E-8,"Square Centimeters","Acres",null,1613.3,"Acre-Feet","Cubic Yards",null,3.7854000000000001,"Gallons/Minute","Liters/Minute",null,6.2140000000000001E-6,"Centimeters","Miles",null,null,null,1,"Minutes","Minutes",null,1,"Foot-Pound/Minute","Foot-Pound/Minute",null,3386.4,"Inches Hg at 32 Degrees F","Pascals",null,1,"Kilograms","Kilograms"]
[1E-8,"Square Centimeters","Hectares",null,1335682.175,"Acre-Feet","Liters",null,6.3089999999999993E-2,"Gallons/Minute","Liters/Second",null,3.2808400000000001E-2,"Centimeters","Feet",null,null,null,1.6666E-2,"Minutes","Hours",null,1.6666E-2,"Foot-Pound/Minute","Foot-Pound/Second",null,0.49114999999999998,"Inches Hg at 32 Degrees F","Pounds/Square Inch",null,15432,"Kilograms","Grains"]
[1,"Square Centimeters","Square Centimeters",null,1335682175,"Acre-Feet","Milliliters",null,86400,"Gallons/Second","Gallons/Day",null,1,"Centimeters","Centimeters",null,null,null,6.9444000000000005E-4,"Minutes","Days",null,3.0300000000000001E-5,"Foot-Pound/Minute","Horsepower",null,25.4,"Inches Hg at 32 Degrees F","Torrs",null,35.274000000000001,"Kilograms","Ounces"]
[1.0763999999999999E-3,"Square Centimeters","Square Feet",null,45164928,"Acre-Feet","Ounces",null,60,"Gallons/Second","Gallons/Minute",null,10,"Centimeters","Millimeters",null,null,null,9.9205999999999999E-5,"Minutes","Weeks",null,2.2596999999999999E-2,"Foot-Pound/Minute","Watts",null,1.3158E-3,"Millimeters Hg at 0 Degrees C","Atmospheres",null,2.2046000000000001,"Kilograms","Pounds"]
[0.155,"Square Centimeters","Square Inches",null,2822808,"Acre-Feet","Pints",null,1,"Gallons/Second","Gallons/Second",null,1.0000000000000001E-5,"Centimeters","Kilometers",null,null,null,2.3515000000000001E-5,"Minutes","Months",null,2.2597000000000002E-6,"Foot-Pound/Minute","Kilowatts",null,1.3332000000000001E-3,"Millimeters Hg at 0 Degrees C","Bars",null,1.1023000000000001E-3,"Kilograms","Tons"]
[1E-10,"Square Centimeters","Square Kilometers",null,1411404,"Acre-Feet","Quarts",null,0.86399999999999999,"Gallons/Second","Million Gallons/Day",null,0.01,"Centimeters","Meters",null,null,null,1.9013300000000001E-6,"Minutes","Years",null,2.2597E-8,"Foot-Pound/Minute","Megawatts",null,3.9370000000000002E-2,"Millimeters Hg at 0 Degrees C","Inches Hg at 32 Degrees F",null,1E-3,"Kilograms","Metric Tons"]
[1E-4,"Square Centimeters","Square Meters",null,2.6416999999999999E-4,"Cubic Centimeters","Gallons",null,11550,"Gallons/Second","Cubic Feet/Day",null,0.39370100000000002,"Centimeters","Inches",null,null,null,3600000,"Hours","Milliseconds",null,7.7045000000000002E-2,"Foot-Pound/Second","BTU/Minute",null,1,"Millimeters Hg at 0 Degrees C","Millimeters Hg at 0 Degrees C",null,6.4798999999999995E-2,"Grains","Grams"]
[3.8610000000000003E-11,"Square Centimeters","Square Miles",null,7.4866999999999996E-10,"Cubic Centimeters","Acre-Feet",null,8.0207999999999995,"Gallons/Second","Cubic Feet/Minute",null,1.0936E-2,"Centimeters","Yards",null,null,null,3600,"Hours","Seconds",null,4.6227,"Foot-Pound/Second","BTU/Hour",null,133.32,"Millimeters Hg at 0 Degrees C","Pascals",null,64.799000000000007,"Grains","Milligrams"]
[1.1959999999999999E-4,"Square Centimeters","Square Yards",null,1,"Cubic Centimeters","Cubic Centimeters",null,0.13370000000000001,"Gallons/Second","Cubic Feet/Second",null,4.9709999999999997E-5,"Centimeters","Furlongs",null,null,null,60,"Hours","Minutes",null,60,"Foot-Pound/Second","Foot-Pound/Minute",null,1.9337E-2,"Millimeters Hg at 0 Degrees C","Pounds/Square Inch",null,6.4799000000000001E-5,"Grains","Kilograms"]
[2.29568E-5,"Square Feet","Acres",null,3.5315000000000003E-5,"Cubic Centimeters","Cubic Feet",null,327067.2,"Gallons/Second","Liters/Day",null,6.2139999999999999E-7,"Millimeters","Miles",null,null,null,1,"Hours","Hours",null,1,"Foot-Pound/Second","Foot-Pound/Second",null,1,"Millimeters Hg at 0 Degrees C","Torrs",null,1,"Grains","Grains"]
[9.2903399999999992E-6,"Square Feet","Hectares",null,6.1024000000000002E-2,"Cubic Centimeters","Cubic Inches",null,227.13,"Gallons/Second","Liters/Minute",null,3.2807999999999999E-3,"Millimeters","Feet",null,null,null,4.1666000000000002E-2,"Hours","Days",null,1.8182000000000001E-3,"Foot-Pound/Second","Horsepower",null,9.8692000000000003E-6,"Pascals","Atmospheres",null,2.2856999999999999E-3,"Grains","Ounces"]
[929.03399999999999,"Square Feet","Square Centimeters",null,9.9999999999999995E-7,"Cubic Centimeters","Cubic Meters",null,3.7854000000000001,"Gallons/Second","Liters/Second",null,0.1,"Millimeters","Centimeters",null,null,null,5.9524000000000001E-3,"Hours","Weeks",null,1.3557999999999999,"Foot-Pound/Second","Watts",null,1.0000000000000001E-5,"Pascals","Bars",null,1.4286E-4,"Grains","Pounds"]
[1,"Square Feet","Square Feet",null,1.2077999999999999E-6,"Cubic Centimeters","Cubic Yards",null,1000000,"Million Gallons/Day","Gallons/Day",null,1,"Millimeters","Millimeters",null,null,null,1.4109999999999999E-3,"Hours","Months",null,1.3558000000000001E-3,"Foot-Pound/Second","Kilowatts",null,2.9639999999999999E-4,"Pascals","Inches Hg at 32 Degrees F",null,7.1428999999999997E-8,"Grains","Tons"]
[144,"Square Feet","Square Inches",null,1E-3,"Cubic Centimeters","Liters",null,694.44,"Million Gallons/Day","Gallons/Minute",null,9.9999999999999995E-7,"Millimeters","Kilometers",null,null,null,1.1408000000000001E-4,"Hours","Years",null,1.3558E-6,"Foot-Pound/Second","Megawatts",null,7.5285600000000001E-3,"Pascals","Millimeters Hg at 0 Degrees C",null,6.4798999999999997E-8,"Grains","Metric Tons"]
[9.2903400000000003E-8,"Square Feet","Square Kilometers",null,1,"Cubic Centimeters","Milliliters",null,11.5741,"Million Gallons/Day","Gallons/Second",null,1E-3,"Millimeters","Meters",null,null,null,86400000,"Days","Milliseconds",null,42.375,"Horsepower","BTU/Minute",null,1,"Pascals","Pascals",null,28.349499999999999,"Ounces","Grams"]
[9.2903399999999997E-2,"Square Feet","Square Meters",null,3.3813999999999997E-2,"Cubic Centimeters","Ounces",null,1,"Million Gallons/Day","Million Gallons/Day",null,3.9370000000000002E-2,"Millimeters","Inches",null,null,null,86400,"Days","Seconds",null,2542.5,"Horsepower","BTU/Hour",null,1.4504000000000001E-4,"Pascals","Pounds/Square Inch",null,28349.5,"Ounces","Milligrams"]
[3.58702E-8,"Square Feet","Square Miles",null,2.1134000000000001E-3,"Cubic Centimeters","Pints",null,133678,"Million Gallons/Day","Cubic Feet/Day",null,1.0935999999999999E-3,"Millimeters","Yards",null,null,null,1440,"Days","Minutes",null,33000,"Horsepower","Foot-Pound/Minute",null,7.5009999999999999E-3,"Pascals","Torrs",null,2.83495E-2,"Ounces","Kilograms"]
[0.111112,"Square Feet","Square Yards",null,1.0567E-3,"Cubic Centimeters","Quarts",null,92.831999999999994,"Million Gallons/Day","Cubic Feet/Minute",null,4.9710000000000003E-6,"Millimeters","Furlongs",null,null,null,24,"Days","Hours",null,550,"Horsepower","Foot-Pound/Second",null,6.8045999999999995E-2,"Pounds/Square Inch","Atmospheres",null,437.5,"Ounces","Grains"]
[1.5942200000000001E-7,"Square Inches","Acres",null,7.4809999999999999,"Cubic Feet","Gallons",null,1.5471999999999999,"Million Gallons/Day","Cubic Feet/Second",null,0.62136999999999998,"Kilometers","Miles",null,null,null,1,"Days","Days",null,1,"Horsepower","Horsepower",null,6.8949999999999997E-2,"Pounds/Square Inch","Bars",null,1,"Ounces","Ounces"]
[6.4515999999999994E-8,"Square Inches","Hectares",null,2.2957000000000001E-5,"Cubic Feet","Acre-Feet",null,3785400,"Million Gallons/Day","Liters/Day",null,3280.84,"Kilometers","Feet",null,null,null,0.14285700000000001,"Days","Weeks",null,745.7,"Horsepower","Watts",null,2.036,"Pounds/Square Inch","Inches Hg at 32 Degrees F",null,6.25E-2,"Ounces","Pounds"]
[6.4516,"Square Inches","Square Centimeters",null,28317,"Cubic Feet","Cubic Centimeters",null,2628.75,"Million Gallons/Day","Liters/Minute",null,100000,"Kilometers","Centimeters",null,null,null,3.3863999999999998E-2,"Days","Months",null,0.74570000000000003,"Horsepower","Kilowatts",null,51.715000000000003,"Pounds/Square Inch","Millimeters Hg at 0 Degrees C",null,3.1250000000000001E-5,"Ounces","Tons"]
[6.9443999999999999E-3,"Square Inches","Square Feet",null,1,"Cubic Feet","Cubic Feet",null,43.813000000000002,"Million Gallons/Day","Liters/Second",null,1000000,"Kilometers","Millimeters",null,null,null,2.7379000000000001E-3,"Days","Years",null,7.4569999999999997E-4,"Horsepower","Megawatts",null,6894.8,"Pounds/Square Inch","Pascals",null,2.8350000000000001E-5,"Ounces","Metric Tons"]
[1,"Square Inches","Square Inches",null,1728,"Cubic Feet","Cubic Inches",null,7.4809999999999999,"Cubic Feet/Day","Gallons/Day",null,1,"Kilometers","Kilometers",null,null,null,604800000,"Weeks","Milliseconds",null,5.6829999999999999E-2,"Watt","BTU/Minute",null,1,"Pounds/Square Inch","Pounds/Square Inch",null,453.5924,"Pounds","Grams"]
[6.4515999999999997E-10,"Square Inches","Square Kilometers",null,2.8316999999999998E-2,"Cubic Feet","Cubic Meters",null,5.195E-3,"Cubic Feet/Day","Gallons/Minute",null,1000,"Kilometers","Meters",null,null,null,604800,"Weeks","Seconds",null,3.4119999999999999,"Watt","BTU/Hour",null,51.715000000000003,"Pounds/Square Inch","Torrs",null,453592.4,"Pounds","Milligrams"]
[6.4515999999999998E-4,"Square Inches","Square Meters",null,3.7037E-2,"Cubic Feet","Cubic Yards",null,8.6589999999999996E-5,"Cubic Feet/Day","Gallons/Second",null,39370,"Kilometers","Inches",null,null,null,10080,"Weeks","Minutes",null,44.253999999999998,"Watt","Foot-Pound/Minute",null,1.3158E-3,"Torrs","Atmospheres",null,0.45359240000000001,"Pounds","Kilograms"]
[2.4909799999999998E-10,"Square Inches","Square Miles",null,28.3169,"Cubic Feet","Liters",null,7.481E-6,"Cubic Feet/Day","Million Gallons/Day",null,1093.6099999999999,"Kilometers","Yards",null,null,null,168,"Weeks","Hours",null,0.73755999999999999,"Watt","Foot-Pound/Second",null,1.3332000000000001E-3,"Torrs","Bars",null,7000,"Pounds","Grains"]
[7.7160499999999997E-4,"Square Inches","Square Yards",null,28317,"Cubic Feet","Milliliters",null,1,"Cubic Feet/Day","Cubic Feet/Day",null,4.9710000000000001,"Kilometers","Furlongs",null,null,null,7,"Weeks","Days",null,1.341E-3,"Watt","Horsepower",null,3.9370000000000002E-2,"Torrs","Inches Hg at 32 Degrees F",null,16,"Pounds","Ounces"]
[247.10400000000001,"Square Kilometers","Acres",null,957.51,"Cubic Feet","Ounces",null,6.9439999999999997E-4,"Cubic Feet/Day","Cubic Feet/Minute",null,6.2137E-4,"Meters","Miles",null,null,null,1,"Weeks","Weeks",null,1,"Watt","Watts",null,1,"Torrs","Millimeters Hg at 0 Degrees C",null,1,"Pounds","Pounds"]
[100,"Square Kilometers","Hectares",null,59.844000000000001,"Cubic Feet","Pints",null,1.1569999999999999E-5,"Cubic Feet/Day","Cubic Feet/Second",null,3.28084,"Meters","Feet",null,null,null,0.23699999999999999,"Weeks","Months",null,1E-3,"Watt","Kilowatts",null,133.322,"Torrs","Pascals",null,5.0000000000000001E-4,"Pounds","Tons"]
[10000000000,"Square Kilometers","Square Centimeters",null,29.922000000000001,"Cubic Feet","Quarts",null,283.13299999999998,"Cubic Feet/Day","Liters/Day",null,100,"Meters","Centimeters",null,null,null,1.9165399999999999E-2,"Weeks","Years",null,9.9999999999999995E-7,"Watt","Megawatts",null,1.9337E-2,"Torrs","Pounds/Square Inch",null,4.5359000000000003E-4,"Pounds","Metric Tons"]
[1076400,"Square Kilometers","Square Feet",null,4.3290000000000004E-3,"Cubic Inches","Gallons",null,0.19661999999999999,"Cubic Feet/Day","Liters/Minute",null,1000,"Meters","Millimeters",null,null,null,2551400000,"Months","Milliseconds",null,56.869,"Kilowatt","BTU/Minute",null,1,"Torrs","Torrs",null,907185,"Tons","Grams"]
[4014484259,"Square Kilometers","Square Inches",null,1.2269000000000001E-8,"Cubic Inches","Acre-Feet",null,3.277E-4,"Cubic Feet/Day","Liters/Second",null,1E-3,"Meters","Kilometers",null,null,null,2551400,"Months","Seconds",null,3412.1,"Kilowatt","BTU/Hour",null,null,null,null,null,907185000,"Tons","Milligrams"]
[1,"Square Kilometers","Square Kilometers",null,16.3871,"Cubic Inches","Cubic Centimeters",null,10772,"Cubic Feet/Minute","Gallons/Day",null,1,"Meters","Meters",null,null,null,42524,"Months","Minutes",null,44254,"Kilowatt","Foot-Pound/Minute",null,null,null,null,null,907.18499999999995,"Tons","Kilograms"]
[1000000,"Square Kilometers","Square Meters",null,5.7870000000000003E-4,"Cubic Inches","Cubic Feet",null,7.4809999999999999,"Cubic Feet/Minute","Gallons/Minute",null,39.370100000000001,"Meters","Inches",null,null,null,708.73,"Months","Hours",null,737.56,"Kilowatt","Foot-Pound/Second",null,null,null,null,null,14000000,"Tons","Grains"]
[0.386102,"Square Kilometers","Square Miles",null,1,"Cubic Inches","Cubic Inches",null,0.12467499999999999,"Cubic Feet/Minute","Gallons/Second",null,1.0935999999999999,"Meters","Yards",null,null,null,29.53,"Months","Days",null,1.341,"Kilowatt","Horsepower",null,null,null,null,null,32000,"Tons","Ounces"]
[1195990,"Square Kilometers","Square Yards",null,1.6387000000000001E-5,"Cubic Inches","Cubic Meters",null,1.0772E-2,"Cubic Feet/Minute","Million Gallons/Day",null,4.9709999999999997E-3,"Meters","Furlongs",null,null,null,4.2186000000000003,"Months","Weeks",null,1000,"Kilowatt","Watts",null,null,null,null,null,2000,"Tons","Pounds"]
[2.47104E-4,"Square Meters","Acres",null,2.1433999999999998E-5,"Cubic Inches","Cubic Yards",null,1440,"Cubic Feet/Minute","Cubic Feet/Day",null,1.5783000000000001E-5,"Inches","Miles",null,null,null,1,"Months","Months",null,1,"Kilowatt","Kilowatts",null,null,null,null,null,1,"Tons","Tons"]
[1E-4,"Square Meters","Hectares",null,1.6387100000000002E-2,"Cubic Inches","Liters",null,1,"Cubic Feet/Minute","Cubic Feet/Minute",null,8.3333000000000004E-2,"Inches","Feet",null,null,null,8.0851999999999993E-2,"Months","Years",null,1E-3,"Kilowatt","Megawatts",null,null,null,null,null,0.90718500000000002,"Tons","Metric Tons"]
[10000,"Square Meters","Square Centimeters",null,16.3871,"Cubic Inches","Milliliters",null,1.6666E-2,"Cubic Feet/Minute","Cubic Feet/Second",null,2.54,"Inches","Centimeters",null,null,null,31557000000,"Years","Milliseconds",null,56869,"Megawatt","BTU/Minute",null,null,null,null,null,1000000,"Metric Tons","Grams"]
[10.7639,"Square Meters","Square Feet",null,0.55410000000000004,"Cubic Inches","Ounces",null,40776.199999999997,"Cubic Feet/Minute","Liters/Day",null,25.4,"Inches","Millimeters",null,null,null,31557000,"Years","Seconds",null,3412100,"Megawatt","BTU/Hour",null,null,null,null,null,1000000000,"Metric Tons","Milligrams"]
[1550,"Square Meters","Square Inches",null,3.4632000000000003E-2,"Cubic Inches","Pints",null,28.316800000000001,"Cubic Feet/Minute","Liters/Minute",null,2.5400000000000001E-5,"Inches","Kilometers",null,null,null,525969,"Years","Minutes",null,44254000,"Megawatt","Foot-Pound/Minute",null,null,null,null,null,1000,"Metric Tons","Kilograms"]
[9.9999999999999995E-7,"Square Meters","Square Kilometers",null,1.7316000000000002E-2,"Cubic Inches","Quarts",null,0.47194999999999998,"Cubic Feet/Minute","Liters/Second",null,2.5399999999999999E-2,"Inches","Meters",null,null,null,8765.7999999999993,"Years","Hours",null,737560,"Megawatt","Foot-Pound/Second",null,null,null,null,null,15430000,"Metric Tons","Grains"]
[1,"Square Meters","Square Meters",null,227,"Cubic Meters","Gallons",null,646317,"Cubic Feet/Second","Gallons/Day",null,1,"Inches","Inches",null,null,null,365.24200000000002,"Years","Days",null,1341,"Megawatt","Horsepower",null,null,null,null,null,35274,"Metric Tons","Ounces"]
[3.861E-7,"Square Meters","Square Miles",null,6.4333000000000001E-4,"Cubic Meters","Acre-Feet",null,448.83,"Cubic Feet/Second","Gallons/Minute",null,2.7777E-2,"Inches","Yards",null,null,null,52.177,"Years","Weeks",null,1000000,"Megawatt","Watts",null,null,null,null,null,2204.62,"Metric Tons","Pounds"]
[1.1959900000000001,"Square Meters","Square Yards",null,1000000,"Cubic Meters","Cubic Centimeters",null,7.4809999999999999,"Cubic Feet/Second","Gallons/Second",null,1.2626299999999999E-4,"Inches","Furlongs",null,null,null,12.369,"Years","Months",null,1000,"Megawatt","Kilowatts",null,null,null,null,null,1.1023000000000001,"Metric Tons","Tons"]
[640,"Square Miles","Acres",null,35.314700000000002,"Cubic Meters","Cubic Feet",null,0.64631700000000003,"Cubic Feet/Second","Million Gallons/Day",null,5.6818299999999999E-4,"Yards","Miles",null,null,null,1,"Years","Years",null,1,"Megawatt","Megawatts",null,null,null,null,null,1,"Metric Tons","Metric Tons"]
[259,"Square Miles","Hectares",null,61024,"Cubic Meters","Cubic Inches",null,86400,"Cubic Feet/Second","Cubic Feet/Day",null,3,"Yards","Feet"]
[25900025900,"Square Miles","Square Centimeters",null,1,"Cubic Meters","Cubic Meters",null,60,"Cubic Feet/Second","Cubic Feet/Minute",null,91.440200000000004,"Yards","Centimeters"]
[27878500,"Square Miles","Square Feet",null,1.3080000000000001,"Cubic Meters","Cubic Yards",null,1,"Cubic Feet/Second","Cubic Feet/Second",null,914.40200000000004,"Yards","Millimeters"]
[4014510000,"Square Miles","Square Inches",null,1000,"Cubic Meters","Liters",null,2446560,"Cubic Feet/Second","Liters/Day",null,9.144E-4,"Yards","Kilometers"]
[2.59,"Square Miles","Square Kilometers",null,1000000,"Cubic Meters","Milliliters",null,1699,"Cubic Feet/Second","Liters/Minute",null,0.91440200000000005,"Yards","Meters"]
[2590000,"Square Miles","Square Meters",null,33814,"Cubic Meters","Ounces",null,28.317,"Cubic Feet/Second","Liters/Second",null,36,"Yards","Inches"]
[1,"Square Miles","Square Miles",null,2113.4,"Cubic Meters","Pints",null,0.26417000000000002,"Liters/Day","Gallons/Day",null,1,"Yards","Yards"]
[3097610,"Square Miles","Square Yards",null,1056.7,"Cubic Meters","Quarts",null,1.8349999999999999E-4,"Liters/Day","Gallons/Minute",null,4.5454600000000003E-3,"Yards","Furlongs"]
[2.0661099999999999E-4,"Square Yards","Acres",null,202,"Cubic Yards","Gallons",null,3.0580000000000002E-6,"Liters/Day","Gallons/Second",null,0.125,"Furlongs","Miles"]
[8.3612700000000007E-5,"Square Yards","Hectares",null,6.2E-4,"Cubic Yards","Acre-Feet",null,2.6417000000000002E-7,"Liters/Day","Million Gallons/Day",null,660,"Furlongs","Feet"]
[8361.27,"Square Yards","Square Centimeters",null,764555,"Cubic Yards","Cubic Centimeters",null,3.3689999999999998E-2,"Liters/Day","Cubic Feet/Day",null,20116.8,"Furlongs","Centimeters"]
[9,"Square Yards","Square Feet",null,27,"Cubic Yards","Cubic Feet",null,2.3396000000000001E-5,"Liters/Day","Cubic Feet/Minute",null,201168,"Furlongs","Millimeters"]
[1296,"Square Yards","Square Inches",null,46656,"Cubic Yards","Cubic Inches",null,3.9000000000000002E-7,"Liters/Day","Cubic Feet/Second",null,0.20116800000000001,"Furlongs","Kilometers"]
[8.3612700000000003E-7,"Square Yards","Square Kilometers",null,0.76456000000000002,"Cubic Yards","Cubic Meters",null,1,"Liters/Day","Liters/Day",null,201.16800000000001,"Furlongs","Meters"]
[0.83612699999999995,"Square Yards","Square Meters",null,1,"Cubic Yards","Cubic Yards",null,6.9439999999999997E-4,"Liters/Day","Liters/Minute",null,7920,"Furlongs","Inches"]
[3.2283100000000001E-7,"Square Yards","Square Miles",null,764.56,"Cubic Yards","Liters",null,1.1574E-5,"Liters/Day","Liters/Second",null,220,"Furlongs","Yards"]
[1,"Square Yards","Square Yards",null,764555,"Cubic Yards","Milliliters",null,380.4,"Liters/Minute","Gallons/Day",null,1,"Furlongs","Furlongs"]
[null,null,null,null,25853,"Cubic Yards","Ounces",null,0.26417000000000002,"Liters/Minute","Gallons/Minute"]
[null,null,null,null,1616,"Cubic Yards","Pints",null,4.4000000000000003E-3,"Liters/Minute","Gallons/Second"]
[null,null,null,null,807.9,"Cubic Yards","Quarts",null,3.8039999999999998E-4,"Liters/Minute","Million Gallons/Day"]
[null,null,null,null,0.26417000000000002,"Liters","Gallons",null,50.86,"Liters/Minute","Cubic Feet/Day"]
[null,null,null,null,7.4867300000000002E-7,"Liters","Acre-Feet",null,3.5319999999999997E-2,"Liters/Minute","Cubic Feet/Minute"]
[null,null,null,null,1000,"Liters","Cubic Centimeters",null,5.8858000000000001E-4,"Liters/Minute","Cubic Feet/Second"]
[null,null,null,null,3.5314999999999999E-2,"Liters","Cubic Feet",null,1440,"Liters/Minute","Liters/Day"]
[null,null,null,null,61.024000000000001,"Liters","Cubic Inches",null,1,"Liters/Minute","Liters/Minute"]
[null,null,null,null,1E-3,"Liters","Cubic Meters",null,1.6660000000000001E-2,"Liters/Minute","Liters/Second"]
[null,null,null,null,1.3079999999999999E-3,"Liters","Cubic Yards",null,22824,"Liters/Second","Gallons/Day"]
[null,null,null,null,1,"Liters","Liters",null,15.85,"Liters/Second","Gallons/Minute"]
[null,null,null,null,1000,"Liters","Milliliters",null,0.26417000000000002,"Liters/Second","Gallons/Second"]
[null,null,null,null,33.814,"Liters","Ounces",null,2.2824000000000001E-2,"Liters/Second","Million Gallons/Day"]
[null,null,null,null,2.1133999999999999,"Liters","Pints",null,3051.2,"Liters/Second","Cubic Feet/Day"]
[null,null,null,null,1.0567,"Liters","Quarts",null,2.1189,"Liters/Second","Cubic Feet/Minute"]
[null,null,null,null,2.6416999999999999E-4,"Milliliters","Gallons",null,3.5314699999999997E-2,"Liters/Second","Cubic Feet/Second"]
[null,null,null,null,7.4866999999999996E-10,"Milliliters","Acre-Feet",null,86400,"Liters/Second","Liters/Day"]
[null,null,null,null,1,"Milliliters","Cubic Centimeters",null,60,"Liters/Second","Liters/Minute"]
[null,null,null,null,3.5315000000000003E-5,"Milliliters","Cubic Feet",null,1,"Liters/Second","Liters/Second"]
[null,null,null,null,6.1024000000000002E-2,"Milliliters","Cubic Inches"]
[null,null,null,null,9.9999999999999995E-7,"Milliliters","Cubic Meters"]
[null,null,null,null,1.2077999999999999E-6,"Milliliters","Cubic Yards"]
[null,null,null,null,1E-3,"Milliliters","Liters"]
[null,null,null,null,1,"Milliliters","Milliliters"]
[null,null,null,null,3.3813999999999997E-2,"Milliliters","Ounces"]
[null,null,null,null,2.1134000000000001E-3,"Milliliters","Pints"]
[null,null,null,null,1.0567E-3,"Milliliters","Quarts"]
[null,null,null,null,7.8125E-3,"Ounces","Gallons"]
[null,null,null,null,2.2141E-8,"Ounces","Acre-Feet"]
[null,null,null,null,29.573499999999999,"Ounces","Cubic Centimeters"]
[null,null,null,null,1.0444E-3,"Ounces","Cubic Feet"]
[null,null,null,null,1.8047,"Ounces","Cubic Inches"]
[null,null,null,null,2.9573500000000001E-5,"Ounces","Cubic Meters"]
[null,null,null,null,3.8680000000000002E-5,"Ounces","Cubic Yards"]
[null,null,null,null,2.9574E-2,"Ounces","Liters"]
[null,null,null,null,29.573499999999999,"Ounces","Milliliters"]
[null,null,null,null,1,"Ounces","Ounces"]
[null,null,null,null,6.25E-2,"Ounces","Pints"]
[null,null,null,null,3.125E-2,"Ounces","Quarts"]
[null,null,null,null,0.125,"Pints","Gallons"]
[null,null,null,null,3.5426E-7,"Pints","Acre-Feet"]
[null,null,null,null,473.17599999999999,"Pints","Cubic Centimeters"]
[null,null,null,null,1.6709999999999999E-2,"Pints","Cubic Feet"]
[null,null,null,null,28.875,"Pints","Cubic Inches"]
[null,null,null,null,4.7318000000000002E-4,"Pints","Cubic Meters"]
[null,null,null,null,6.1888999999999998E-4,"Pints","Cubic Yards"]
[null,null,null,null,0.47317999999999999,"Pints","Liters"]
[null,null,null,null,473.17599999999999,"Pints","Milliliters"]
[null,null,null,null,16,"Pints","Ounces"]
[null,null,null,null,1,"Pints","Pints"]
[null,null,null,null,0.5,"Pints","Quarts"]
[null,null,null,null,0.25,"Quarts","Gallons"]
[null,null,null,null,7.0851000000000004E-7,"Quarts","Acre-Feet"]
[null,null,null,null,946.35299999999995,"Quarts","Cubic Centimeters"]
[null,null,null,null,3.3419999999999998E-2,"Quarts","Cubic Feet"]
[null,null,null,null,57.75,"Quarts","Cubic Inches"]
[null,null,null,null,9.4634999999999999E-4,"Quarts","Cubic Meters"]
[null,null,null,null,1.2378000000000001E-3,"Quarts","Cubic Yards"]
[null,null,null,null,0.946353,"Quarts","Liters"]
[null,null,null,null,946.35299999999995,"Quarts","Milliliters"]
[null,null,null,null,32,"Quarts","Ounces"]
[null,null,null,null,2,"Quarts","Pints"]
[null,null,null,null,1,"Quarts","Quarts"]

{"sheet":"SigFigures","index":2,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Significant Figures"]
[]
["Value",{"$f":"'Unit Conversion'!I24","v":false}]
["Decimal",{"$f":"IF(ISERR(FIND(\".\",B3)),\"No\",\"Yes\")","v":"No"}]
[]
["1st Digit Zero?",{"$f":"IF(LEFT(B3,1)=\"0\",\"Yes\",\"\")","v":""}]
["Last Digit Zero?",{"$f":"IF(RIGHT(B3,1)=\"0\",\"Yes\",\"\")","v":""}]
[]
[null,"Value","Non-Zero SFs","Zero SFs"]
["Digit 1",{"$f":"IF(AND(LEFT(B3,1)<>\"\",LEFT(B3,1)<>\".\"),VALUE(LEFT(B3,1)),LEFT(B3,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(B10<>\"\",IF(AND(B10<>0,B10<>\".\"),\"Yes\",\"No\"),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(B10<>\"\",B10<>\".\",C10=\"No\"),IF(AND(SUM($B9:B$10)>0,OR(SUM(B11:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":{"$error":"#VALUE!"}}]
["Digit 2",{"$f":"IF(AND(MID(B3,2,1)<>\"\",MID(B3,2,1)<>\".\"),VALUE(MID(B3,2,1)),MID(B3,2,1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(B11<>\"\",B11<>\".\",C11=\"No\"),IF(AND(SUM($B$10:B10)>0,OR(SUM(B12:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":{"$error":"#VALUE!"}}]
["Digit 3",{"$f":"IF(AND(MID(B3,3,1)<>\"\",MID(B3,3,1)<>\".\"),VALUE(MID(B3,3,1)),MID(B3,3,1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(B12<>\"\",B12<>\".\",C12=\"No\"),IF(AND(SUM($B$10:B11)>0,OR(SUM(B13:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":{"$error":"#VALUE!"}}]
["Digit 4",{"$f":"IF(AND(MID(B3,4,1)<>\"\",MID(B3,4,1)<>\".\"),VALUE(MID(B3,4,1)),MID(B3,4,1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(B13<>\"\",B13<>\".\",C13=\"No\"),IF(AND(SUM($B$10:B12)>0,OR(SUM(B14:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":{"$error":"#VALUE!"}}]
["Digit 5",{"$f":"IF(AND(MID(B3,5,1)<>\"\",MID(B3,5,1)<>\".\"),VALUE(MID(B3,5,1)),MID(B3,5,1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(B14<>\"\",B14<>\".\",C14=\"No\"),IF(AND(SUM($B$10:B13)>0,OR(SUM(B15:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":{"$error":"#VALUE!"}}]
["Digit 6",{"$f":"IF(AND(MID(B3,6,1)<>\"\",MID(B3,6,1)<>\".\"),VALUE(MID(B3,6,1)),MID(B3,6,1))","v":""},"",{"$f":"IF(AND(B15<>\"\",B15<>\".\",C15=\"No\"),IF(AND(SUM($B$10:B14)>0,OR(SUM(B16:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
["Digit 7",{"$f":"IF(AND(MID(B3,7,1)<>\"\",MID(B3,7,1)<>\".\"),VALUE(MID(B3,7,1)),MID(B3,7,1))","v":""},"",{"$f":"IF(AND(B16<>\"\",B16<>\".\",C16=\"No\"),IF(AND(SUM($B$10:B15)>0,OR(SUM(B17:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
["Digit 8",{"$f":"IF(AND(MID(B3,8,1)<>\"\",MID(B3,8,1)<>\".\"),VALUE(MID(B3,8,1)),MID(B3,8,1))","v":""},"",{"$f":"IF(AND(B17<>\"\",B17<>\".\",C17=\"No\"),IF(AND(SUM($B$10:B16)>0,OR(SUM(B18:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
["Digit 9",{"$f":"IF(AND(MID(B3,9,1)<>\"\",MID(B3,9,1)<>\".\"),VALUE(MID(B3,9,1)),MID(B3,9,1))","v":""},"",{"$f":"IF(AND(B18<>\"\",B18<>\".\",C18=\"No\"),IF(AND(SUM($B$10:B17)>0,OR(SUM(B19:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
["Digit 10",{"$f":"IF(AND(MID(B3,10,1)<>\"\",MID(B3,10,1)<>\".\"),VALUE(MID(B3,10,1)),MID(B3,10,1))","v":""},"",{"$f":"IF(AND(B19<>\"\",B19<>\".\",C19=\"No\"),IF(AND(SUM($B$10:B18)>0,OR(SUM(B20:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
["Digit 11",{"$f":"IF(AND(MID(B3,11,1)<>\"\",MID(B3,11,1)<>\".\"),VALUE(MID(B3,11,1)),MID(B3,11,1))","v":""},"",{"$f":"IF(AND(B20<>\"\",B20<>\".\",C20=\"No\"),IF(AND(SUM($B$10:B19)>0,OR(SUM(B21:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
["Digit 12",{"$f":"IF(AND(MID(B3,12,1)<>\"\",MID(B3,12,1)<>\".\"),VALUE(MID(B3,12,1)),MID(B3,12,1))","v":""},"",{"$f":"IF(AND(B21<>\"\",B21<>\".\",C21=\"No\"),IF(AND(SUM($B$10:B20)>0,OR(SUM(B22:$B$22)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
["Digit 13",{"$f":"IF(AND(MID(B3,13,1)<>\"\",MID(B3,13,1)<>\".\"),VALUE(MID(B3,13,1)),MID(B3,13,1))","v":""},"",{"$f":"IF(AND(B22<>\"\",B22<>\".\",C22=\"No\"),IF(AND(SUM($B$10:B21)>0,OR(SUM(B$22:$B23)>0,$B$4=\"Yes\")),\"Yes\",\"No\"),\"\")","v":""}]
[null,null,{"$f":"COUNTIF(C10:C22,\"Yes\")","v":0},{"$f":"COUNTIF(D10:D22,\"Yes\")","v":0}]
[null,"Total SFs:",{"$f":"C23+D23","v":0}]
[]
["Rules:"]
[]
["1) ALL non-zero numbers (1,2,3,4,5,6,7,8,9) are ALWAYS significant."]
[]
["2) ALL zeroes between non-zero numbers are ALWAYS significant."]
[]
["3) ALL zeroes which are SIMULTANEOUSLY to the right of the decimal point AND at the end of the number are ALWAYS significant."]
[]
["4) ALL zeroes which are to the left of a written decimal point and are in a number >= 10 are ALWAYS significant."]

{"sheet":"Treatment Efficiency","index":3,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,1,3,7]]}
[]
[null,"Treatment Unit Efficiency"]
[]
[null,"Enter Influent Flow (MGD), Influent Concentration (mg/L) and Effluent Concentration (mg/L) for any parameter"]
[null,"Influent Flow (MGD)","Influent Concentration (mg/L)","Effluent Concentration (mg/L)","Influent Mass Entering Treatment Unit (lbs)","Effluent Mass Leaving Treatment Unit (lbs)","Mass Removed by Treatment Unit (lbs)","Removal Efficiency"]
[null,null,null,null,{"$f":"IF(AND(B6<>\"\",C6<>\"\"),B6*C6*8.34,\"\")","v":""},{"$f":"IF(AND(B6<>\"\",D6<>\"\"),B6*D6*8.34,\"\")","v":""},{"$f":"IF(AND(B6<>\"\",C6<>\"\",D6<>\"\"),(C6-D6)*B6*8.34,\"\")","v":""},{"$f":"IF(AND(B6<>\"\",C6<>\"\",D6<>\"\"),(C6-D6)/C6,\"\")","v":""}]

{"sheet":"F-M Ratio","index":4,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,1,3,7]]}
[]
[null,"Food to Microorganism (F:M) Ratio",null,null,null,"Read More -"]
[]
[null,"Enter Influent Flow (MGD), Influent CBOD Concentration (mg/L), Volume of Aeration System (gallons), and MLVSS (mg/L)"]
[null,"Influent Flow (MGD)","Influent CBOD Concentration (mg/L)","Volume of Aeration System (gallons)","Mixed Liquor Volatile Suspended Solids (MLVSS) (mg/L)","Pounds of Food (F) Entering Aeration (lbs)","Pounds of Volatile Solids Under Aeration (lbs)","F:M Ratio"]
[null,null,null,null,null,{"$f":"IF(AND(B6<>\"\",C6<>\"\"),B6*C6*8.34,\"\")","v":""},{"$f":"IF(AND(D6<>\"\",E6<>\"\"),(D6/1000000)*E6*8.34,\"\")","v":""},{"$f":"IF(AND(F6<>\"\",G6<>\"\"),F6/G6,\"\")","v":""}]

{"sheet":"Sludge Generation","index":5,"n_rows":74,"n_cols":43,"rows_kept":74,"cut":false,"hidden":false,"merged":[[69,3,70,5],[69,6,70,14],[69,18,70,20],[69,21,70,29],[71,6,72,14],[71,21,72,29],[73,3,74,5],[73,6,74,14],[73,18,74,20],[73,21,74,29],[0,0,68,0],[0,30,68,30],[5,1,5,29],[6,1,6,4],[6,5,6,15],[6,17,6,19],[6,20,6,27],[8,1,8,5],[8,6,8,13],[8,14,8,19],[8,20,8,27],[8,28,8,29],[9,1,9,29],[6,28,6,29],[7,1,7,5],[7,6,7,13],[7,14,7,19],[7,20,7,27],[7,28,7,29],[11,1,11,29],[12,1,12,10],[12,11,12,21],[12,23,12,27],[12,28,12,29],[13,1,13,29],[10,5,10,7],[10,8,10,9],[10,10,10,16],[10,17,10,24],[10,25,10,27],[10,28,10,29],[17,1,17,29],[18,1,18,17],[18,18,18,21],[18,22,18,24],[18,25,18,29],[19,1,19,29],[14,1,14,10],[14,11,14,21],[14,23,14,27],[14,28,14,29],[15,1,15,29],[16,1,16,11],[16,12,16,15],[16,16,16,29],[24,1,24,29],[25,1,25,11],[25,12,25,14],[25,16,25,18],[25,19,25,20],[25,21,25,29],[20,1,20,17],[20,18,20,21],[20,22,20,24],[20,25,20,29],[21,1,21,29],[22,1,23,17],[22,18,23,21],[22,22,23,29],[30,1,31,15],[30,16,31,18],[30,19,31,29],[32,1,32,29],[33,1,34,15],[33,16,34,18],[33,19,34,21],[33,22,34,29],[26,1,26,29],[27,1,28,15],[27,16,28,18],[27,19,28,21],[27,22,28,29],[29,1,29,29],[39,16,39,18],[39,19,39,21],[39,22,39,23],[39,24,39,26],[39,27,39,29],[40,1,40,29],[35,1,35,29],[36,1,37,15],[36,16,37,18],[36,19,37,21],[36,22,37,29],[38,1,38,29],[45,3,45,5],[45,6,45,14],[45,18,45,20],[45,21,45,29],[46,3,46,5],[46,6,46,14],[46,18,46,20],[46,21,46,29],[41,1,41,29],[42,1,42,29],[43,1,43,14],[43,16,43,29],[44,1,44,14],[44,16,44,29],[49,3,49,5],[49,6,49,14],[49,18,49,20],[49,21,49,29],[50,1,50,14],[50,16,50,29],[47,1,47,14],[47,16,47,29],[48,3,48,5],[48,6,48,14],[48,18,48,20],[48,21,48,29],[53,1,53,14],[53,16,53,29],[54,3,54,5],[54,6,54,14],[54,18,54,20],[54,21,54,29],[51,3,51,5],[51,6,51,14],[51,18,51,20],[51,21,51,29],[52,3,52,5],[52,6,52,14],[52,18,52,20],[52,21,52,29],[57,1,57,14],[57,16,57,29],[58,3,58,5],[58,6,58,14],[58,18,58,20],[58,21,58,29],[55,3,55,5],[55,6,55,14],[55,18,55,20],[55,21,55,29],[56,3,56,5],[56,6,56,14],[56,18,56,20],[56,21,56,29],[67,3,67,5],[67,6,67,14],[67,18,67,20],[67,21,67,29],[1,1,1,29],[3,1,4,29],[59,6,59,14],[59,21,59,29],[65,2,66,2],[65,3,66,5],[65,6,66,14],[65,17,66,17],[65,18,66,20],[65,21,66,29],[62,1,62,14],[62,16,62,29],[63,3,64,5],[63,6,64,14],[63,18,64,20],[63,21,64,29],[61,3,61,5],[61,6,61,14],[61,18,61,20],[61,21,61,29]]}
[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,null,null,null,null,null,null,null,null,null,null,"BOD5","Extended Aeration",0.65,"No Digestion",1]
[null,"Solids Management (Sludge) Calculator",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,null,null,null,null,null,null,null,null,"CBOD5","Conventional Activated Sludge",0.85,"Aerobic Digestion, HDT = 10 Days",0.9]
[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,null,null,null,null,null,null,null,null,null,null,"Activated Sludge with Primary Clarification",0.7,"Aerobic Digestion, HDT = 15",0.8]
[null,"This worksheet calculates the expected sludge volume that should be produced by various treatment processes over a one-year period.  Enter data into green cells - hit the Tab key to move between cells.  Red cells are calculated.",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,null,null,null,null,null,null,null,null,null,"Sequencing Batch Reactor",0.65,"Aerobic Digestion, HDT = 20",0.7]
[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,null,null,null,null,null,null,null,null,null,null,null,"Oxidation Ditch",0.65,"Aerobic Digestion, HDT= >30",0.65]
[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,null,null,null,null,null,null,null,null,null,null,null,"Contact Stabilization",1,"Aerobic Thermophilic",0.5]
[null,"Facility Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permit No.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trickling Filter",1,"Anaerobic Digestion, HDT = 20",0.75]
[null,null,null,null,null,null,"Enter Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotating Biological Contactor",1,"Anaerobic Digestion, HDT = 30",0.65]
[null,"Evaluation Period:",null,null,null,null,null,null,null,null,null,null,null,null,"to",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,"Anaerobic Digestion, HDT = 40",0.55000000000000004]
[]
[null,"Design Flow:",null,null,null,null,null,null,"MGD",null,null,null,null,null,null,null,null,"Actual Annual Average Flow:",null,null,null,null,null,null,null,null,null,null,"MGD"]
[]
[null,"Type of Biological Treatment Process:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Treatment Factor:",null,null,null,null,{"$f":"IF(L13<>\"\",IF(VLOOKUP(L13,$AN$1:$AO$8,2,FALSE)=\"\",\"\",VLOOKUP(L13,$AN$1:$AO$8,2,FALSE)),\"\")","v":""}]
[]
[null,"Type of Digestion Process:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digestion Factor:",null,null,null,null,{"$f":"IF(L15<>\"\",IF(VLOOKUP(L15,$AP$1:$AQ$9,2,FALSE)=\"\",\"\",VLOOKUP(L15,$AP$1:$AQ$9,2,FALSE)),\"\")","v":""}]
[]
[null,"Total Population Served by Treatment Plant:"]
[]
[null,"Average Annual Influent BOD5 Load (per Ch. 94 Report):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lbs/day"]
[]
[null,"Average Annual Influent BOD5 Load (Expected based on Population):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Population<>\"\",Population*0.17,\"\")","v":""},null,null,null,"lbs/day",null,null,"(Population x 0.17)"]
[]
[null,"% of Influent BOD5 Load per Ch. 94 Report / Influent Load Expected:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Influent_Load<>\"\",Influent_Load_Expected<>\"\"),Influent_Load/Influent_Load_Expected,\"\")","v":""},null,null,null,"(Influent Load per Ch. 94 Report / Influent Load based on Population)"]
[]
[]
[null,"Average Annual Effluent Concentration of",null,null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,null,"mg/L",null,{"$f":"IF(M26<>\"\",IF(M26=\"CBOD5\",IF(Q26<>\"\",CONCATENATE(\"Assume \",Q26*1.2,\" mg/L BOD5\"),\"\"),\"\"),\"\")","v":""}]
[]
[null,"Average Annual Pounds (lbs) of BOD5 Discharged:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Actual_Flow<>\"\",BOD_Conc<>\"\"),Actual_Flow*IF(M26=\"CBOD5\",BOD_Conc*1.2,BOD_Conc)*8.34,\"\")","v":""},null,null,"lbs/day",null,null,"(Actual Flow x Effluent BOD5 Concentration x 8.34)"]
[]
[]
[null,"Influent BOD5 Load per Person per Day (based on Ch. 94):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Population<>\"\",Influent_Load<>\"\"),Influent_Load/Population,\"\")","v":""},null,null,"(Influent BOD5 Load per Ch. 94 Report / Population - 0.17 to 0.22 is typical)"]
[]
[]
[null,"Pounds of BOD5 Removed (based on Ch. 94):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Influent_Load<>\"\",BOD5_Discharged<>\"\"),Influent_Load-BOD5_Discharged,\"\")","v":""},null,null,"lbs/day",null,null,"(Influent BOD5 Load per Ch. 94 Report - BOD5 Discharged)"]
[]
[]
[null,"Pounds of BOD5 Removed (based on Population):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Influent_Load_Expected<>\"\",BOD5_Discharged<>\"\"),Influent_Load_Expected-BOD5_Discharged,\"\")","v":""},null,null,"lbs/day",null,null,"(Influent BOD5 Load Expected based on Population - BOD5 Discharged)"]
[]
[]
[null,"Sludge Removed from Treatment Plant (Previous Year):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Tons",null,null,"=",null,{"$f":"IF(Q40<>\"\",Q40*2000,\"\")","v":""},null,null,"Dry lbs"]
[]
[null,"Sludge Production and Wasting Calculations"]
[]
[null,"Based on Chapter 94 Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Based on Population"]
[]
[null,null,null,{"$f":"IF(Ch94BOD5Removed<>\"\",Ch94BOD5Removed,\"\")","v":""},null,null,"BOD5 Removed / Day (lbs)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PopBOD5Removed<>\"\",PopBOD5Removed,\"\")","v":""},null,null,"BOD5 Removed / Day (lbs)"]
[null,null,"X",{"$f":"IF(Treatment_Factor<>\"\",Treatment_Factor,\"\")","v":""},null,null,"Treatment Factor",null,null,null,null,null,null,null,null,null,null,"X",{"$f":"IF(Treatment_Factor<>\"\",Treatment_Factor,\"\")","v":""},null,null,"Treatment Factor"]
[]
[null,null,null,{"$f":"IF(AND(Ch94BOD5Removed<>\"\",Treatment_Factor<>\"\"),Ch94BOD5Removed*Treatment_Factor,\"\")","v":""},null,null,"Daily Solids Production (lbs)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(PopBOD5Removed<>\"\",Treatment_Factor<>\"\"),PopBOD5Removed*Treatment_Factor,\"\")","v":""},null,null,"Daily Solids Production (lbs)"]
[null,null,"X",{"$f":"IF(Digestion_Factor<>\"\",Digestion_Factor,\"\")","v":""},null,null,"Digestion Factor",null,null,null,null,null,null,null,null,null,null,"X",{"$f":"IF(Digestion_Factor<>\"\",Digestion_Factor,\"\")","v":""},null,null,"Digestion Factor"]
[]
[null,null,null,{"$f":"IF(AND(Ch94DailySludge<>\"\",Digestion_Factor<>\"\"),Ch94DailySludge*Digestion_Factor,\"\")","v":""},null,null,"Daily Digested Solids (lbs)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(PopDailySludge<>\"\",Digestion_Factor<>\"\"),PopDailySludge*Digestion_Factor,\"\")","v":""},null,null,"Daily Digested Solids (lbs)"]
[null,null,"X",365,null,null,"Days per Year",null,null,null,null,null,null,null,null,null,null,"X",365,null,null,"Days per Year"]
[]
[null,null,null,{"$f":"IF(Ch94DigestedSolids<>\"\",Ch94DigestedSolids*365,\"\")","v":""},null,null,"Solids Generated / Year (lbs)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PopDigestedSolids<>\"\",PopDigestedSolids*365,\"\")","v":""},null,null,"Solids Generated / Year (lbs)"]
[null,null," -",{"$f":"IF(DryPoundsRemoved<>\"\",DryPoundsRemoved,\"\")","v":""},null,null,"Solids Actually Wasted / Year (lbs)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DryPoundsRemoved<>\"\",DryPoundsRemoved,\"\")","v":""},null,null,"Solids Actually Wasted / Year (lbs)"]
[null,null,null,{"$f":"IF(AND(D55<>\"\",D56<>\"\"),D55-D56,\"\")","v":""},null,null,"Difference (lbs)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S55<>\"\",S56<>\"\"),S55-S56,\"\")","v":""},null,null,"Difference (lbs)"]
[]
[null,null,null,{"$f":"IF(AND(D56<>\"\",D55<>\"\"),D56/D55,\"\")","v":""},null,null,"% of Expected Volume Wasted",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S56<>\"\",S55<>\"\"),S56/S55,\"\")","v":""},null,null,"% of Expected Volume Wasted"]
[null,null,null,null,null,null,"(85 - 115% is generally acceptable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(85 - 115% is generally acceptable)"]
[]
[null,null,null,null,null,null,"Percent Solids of Wasted Solids",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D62<>\"\",D62,\"\")","v":""},null,null,"Percent Solids of Removed Solids"]
[]
[null,null,null,{"$f":"IF(AND(D55<>\"\",D62<>\"\"),(D55/2000)/((D62*100)*0.0000417),\"\")","v":""},null,null,"Volume of Solids to Remove Annually (gallons)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S55<>\"\",S62<>\"\"),(S55/2000)/((S62*100)*0.0000417),\"\")","v":""},null,null,"Volume of Solids to Remove Annually (gallons)"]
[]
[null,null," -",{"$f":"IF(AND(Q40<>\"\",D62<>\"\"),Q40/((D62*100)*0.0000417),\"\")","v":""},null,null,"Volume of Solids Actually Removed Annually (gallons)",null,null,null,null,null,null,null,null,null,null," -",{"$f":"IF(AND(Q40<>\"\",S62<>\"\"),Q40/((S62*100)*0.0000417),\"\")","v":""},null,null,"Volume of Solids Actually Removed Annually (gallons)"]
[]
[null,null,null,{"$f":"IF(AND(D64<>\"\",D66<>\"\"),D64-D66,\"\")","v":""},null,null,"Difference (gallons)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S64<>\"\",S66<>\"\"),S64-S66,\"\")","v":""},null,null,"Difference (gallons)"]
[]
[null,null,null,null,null,null,"Actual Cost of Sludge Removal ($/Gallon)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual Cost of Sludge Removal ($/Gallon)"]
[]
[null,null,null,null,null,null,"(Default - $0.08/gallon dewatered sludge, $0.15/gallon liquid sludge)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Default - $0.08/gallon dewatered sludge, $0.15/gallon liquid sludge)"]
[]
[null,null,null,{"$f":"IF(AND(D68<>\"\",D70<>\"\"),D68*D70,\"\")","v":""},null,null,"Cost Savings for Not Removing Sufficient Sludge",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S68<>\"\",S70<>\"\"),S68*S70,\"\")","v":""},null,null,"Cost Savings for Not Removing Sufficient Sludge"]

{"sheet":"Alkalinity - Nitrification","index":6,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,1,15,5],[16,1,16,5],[10,1,10,3],[11,1,11,5],[3,1,4,5],[6,1,6,3],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[null,null,null,null,null,null,null,null,null,null,false]
[null,"Alkalinity Required for Nitrification"]
[]
[null,"Alkalinity is needed for nitrification to meet effluent limits for Ammonia-Nitrogen (NH3-N).  For every pound of NH3-N that must be removed / nitrified, 7.2 lbs of alkalinity is required.  A residual alkalinity of 50 mg/L is assumed for final effluent to meet pH limits but this value can be adjusted."]
[]
[]
[null,"Check box if treatment plant has primary clarifier(s):"]
[null,"Influent Flow (MGD)",{"$f":"IF(K1=TRUE,\"NH3-N Concentration in Primary Clarifier Effuent (mg/L)\",\"Influent NH3-N Concentration (mg/L)\")","v":"Influent NH3-N Concentration (mg/L)"},{"$f":"IF(K1=TRUE,\"Alkalinity Concentration in Primary Clarifier Effuent (mg/L)\",\"Influent Alkalinity Concentration (mg/L)\")","v":"Influent Alkalinity Concentration (mg/L)"},"Average Monthly NH3-N Effluent Limit (mg/L)","Alkalinity Desired in Final Effluent (mg/L)"]
[null,null,null,null,null,50]
[]
[null,{"$f":"IF(AND(B9<>\"\",C9<>\"\",E9<>\"\"),\"NH3-N that must be removed / nitrified:\",\"\")","v":""}]
[null,{"$f":"IF(AND(B9<>\"\",C9<>\"\",E9<>\"\"),CONCATENATE(\"(\",C9,\" mg/L\",\" - \",E9,\" mg/L\",\")\",\" x \",B9,\" MGD\",\" x \",\"8.34 = \",(C9-E9)*B9*8.34,\" lbs/day\"),\"\")","v":""}]
[null,{"$f":"IF(AND(B9<>\"\",C9<>\"\",E9<>\"\"),\"Alkalinity needed for nitification:\",\"\")","v":""}]
[null,{"$f":"IF(AND(B9<>\"\",C9<>\"\",E9<>\"\"),CONCATENATE((C9-E9)*B9*8.34,\" lbs/day\",\" x 7.2 = \",(C9-E9)*B9*8.34*7.2,\" lbs/day\"),\"\")","v":""}]
[null,{"$f":"IF(AND(B9<>\"\",D9<>\"\",F9<>\"\"),\"Alkalinity available for nitrification:\",\"\")","v":""}]
[null,{"$f":"IF(AND(B9<>\"\",D9<>\"\",F9<>\"\"),CONCATENATE(\"(\",D9,\" mg/L\",\" - \",F9,\" mg/L\",\")\",\" x \",B9,\" MGD\",\" x \",\"8.34 = \",(D9-F9)*B9*8.34,\" lbs/day\"),\"\")","v":""}]
[null,{"$f":"IF(AND(B9<>\"\",C9<>\"\",D9<>\"\",E9<>\"\",F9<>\"\"),IF((D9-F9)*B9*8.34>(C9-E9)*B9*8.34*7.2,\"There is sufficient alkalinity for nitrification to achieve NH3-N effluent limits\",CONCATENATE((C9-E9)*B9*8.34*7.2-(D9-F9)*B9*8.34,\" lbs/day or \",((C9-E9)*B9*8.34*7.2-(D9-F9)*B9*8.34)/(8.34*B9),\" mg/L of alkalinity must be added for nitrification to meet NH3-N effluent limits\")),\"\")","v":""}]

{"sheet":"Flow Concentration & Loading","index":7,"n_rows":60,"n_cols":35,"rows_kept":60,"cut":false,"hidden":false,"merged":[[3,1,5,23],[48,20,48,22],[59,20,59,22],[8,20,8,22],[24,3,24,4],[8,5,8,11],[8,1,8,4],[15,9,15,10],[23,14,23,15],[48,15,48,17],[48,12,48,14],[48,3,48,5],[48,9,48,11],[37,19,37,21],[37,17,37,18],[37,14,37,16],[29,9,29,10],[37,9,37,11],[8,17,8,19],[8,13,8,16],[9,1,9,3],[59,3,59,5],[59,9,59,11],[59,12,59,14],[59,15,59,17],[37,3,37,5],[37,12,37,13]]}
[]
[null,"Flow, Concentration & Loading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Concentration",0]
[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,"Flow or Volume",1]
[null,"Below is a Davidson Pie Chart used to illustrate the calculation of flow, concentration and loading.  Click on the drop-down list next to \"Find:\" to select the parameter you wish to calculate.  Click on the drop-down list next to \"Round To:\" to select the number of decimal places you would like to see displayed in the results.  Enter data for the other two parameters into the purple-highlighted cells below the chart.  Note that volume (in million gallons, MG) may be used to determine the pounds (load, lbs) of a parameter such as BOD within a tank, if concentration is known.",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,"Loading or Load",2]
[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,3]
[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,4,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,null,null,null,null,null,5]
[]
[null,"Find:",null,null,null,null,null,null,null,null,null,null,null,"Round To:",null,null,null,null,null,null,"Decimals"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F9<>\"\",IF(AND(F9=\"Loading or Load\",T38<>\"\"),T38,IF(AND(F9=\"Concentration\",D49<>\"\"),D49,IF(AND(F9=\"Flow or Volume\",D60<>\"\"),D60,\"\"))),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.34]
[null,null,null,{"$f":"IF(F9<>\"\",IF(AND(F9=\"Loading or Load\",D38<>\"\"),D38,IF(AND(F9=\"Concentration\",U49<>\"\"),U49,IF(AND(F9=\"Flow or Volume\",J60<>\"\"),J60,\"\"))),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F9<>\"\",IF(AND(F9=\"Flow or Volume\",U60<>\"\"),U60,IF(AND(F9=\"Concentration\",J49<>\"\"),J49,IF(AND(F9=\"Loading or Load\",J38<>\"\"),J38,\"\"))),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"x",null,null,null,null,"x",null,8.34,null,null,"=",null,{"$f":"IFERROR(IF(AND(D38<>\"\",J38<>\"\"),IF($R$9<>\"\",ROUND(AB38,$R$9),ROUND(AB38,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(D38<>\"\",J38<>\"\"),D38*J38*8.34,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"/",null,null,null,null,"x",null,null,8.34,null,null,"=",null,{"$f":"IFERROR(IF(AND(D49<>\"\",J49<>\"\"),IF($R$9<>\"\",ROUND(AB49,$R$9),ROUND(AB49,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(D49<>\"\",J49<>\"\"),D49/(J49*8.34),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"/",null,null,null,null,"x",null,null,8.34,null,null,"=",null,{"$f":"IFERROR(IF(AND(D60<>\"\",J60<>\"\"),IF($R$9<>\"\",ROUND(AB60,$R$9),ROUND(AB60,0)),\"\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(D60<>\"\",J60<>\"\"),D60/(J60*8.34),\"\")","v":""}]

{"sheet":"Geometric Mean","index":8,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,1,5,5]]}
[null,null,null,null,null,null,null,null,null,null,1,"<"]
[null,"Fecal Coliform Geometric Mean",null,null,null,null,null,null,null,null,2,">"]
[null,null,null,null,null,null,null,null,null,null,3]
[null,"Select the number of samples collected and analyzed for fecal coliform (or other bacterial parameters) during a month.  Enter the dates the samples were collected, select a qualifier (less than (<) or greater than (>)), if applicable, and enter the result (whole number) in CFU/100 mL or MPN or No./100 mL.  For results of \"0\", enter 1.",null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,7]
[null,"No. Samples:",null,null,"Geometric Mean:",{"$f":"IF(SUM(E12:E42)<>0,IF(AND(H43=0,H44=0),ROUND(GEOMEAN(E12:E42),0),IF(AND(H43>0,H44=0),CONCATENATE(\"< \",ROUND(GEOMEAN(E12:E42),0)),IF(OR(AND(H43>0,H44>0),AND(H43=0,H44>0)),CONCATENATE(\"> \",ROUND(GEOMEAN(E12:E42),0))))),\"\")","v":""},null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,"Date","Qualifier","Result",null,null,null,null,null,11]
[null,null,null,null,null,null,null,{"$f":"IF(AND(D12=\"<\",E12<>\"\"),1,IF(AND(D12=\">\",E12<>\"\"),2,\"\"))","v":""},null,null,12]
[null,null,null,null,null,null,null,{"$f":"IF(AND(D13=\"<\",E13<>\"\"),1,IF(AND(D13=\">\",E13<>\"\"),2,\"\"))","v":""},null,null,13]
[null,null,null,null,null,null,null,"",null,null,14]
[null,null,null,null,null,null,null,"",null,null,15]
[null,null,null,null,null,null,null,"",null,null,16]
[null,null,null,null,null,null,null,"",null,null,17]
[null,null,null,null,null,null,null,"",null,null,18]
[null,null,null,null,null,null,null,"",null,null,19]
[null,null,null,null,null,null,null,"",null,null,20]
[null,null,null,null,null,null,null,"",null,null,21]
[null,null,null,null,null,null,null,"",null,null,22]
[null,null,null,null,null,null,null,"",null,null,23]
[null,null,null,null,null,null,null,"",null,null,24]
[null,null,null,null,null,null,null,"",null,null,25]
[null,null,null,null,null,null,null,"",null,null,26]
[null,null,null,null,null,null,null,"",null,null,27]
[null,null,null,null,null,null,null,"",null,null,28]
[null,null,null,null,null,null,null,"",null,null,29]
[null,null,null,null,null,null,null,"",null,null,30]
[null,null,null,null,null,null,null,"",null,null,31]
[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,""]
[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,""]
[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,{"$f":"COUNTIF(H12:H42,1)","v":0}]
[null,null,null,null,null,null,null,{"$f":"COUNTIF(H12:H42,2)","v":0}]