{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Waste Volumes","Rainfall","CIRC. TANK","Earthen Pond ","RAMP","Rect Tank","Bedding","Module1"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":7,"reason":"part_missing"}],"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":"Waste Volumes","index":0,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["COUNTY","Name",null,null,null,"DATE"]
["OWNER","Farmer's Name",null,null,null,"ADDRESS"," "]
["PREPARER",null,null,null,null,"TITLE",null,null,"DATE",{"$f":"G4","v":"00:00:00"}]
["CHECKED"," ",null,null,null,"TITLE"," ",null,"DATE"," "]
[]
["LIVESTOCK",null,null,null,1,null,2,null,3,null,4]
["A.  ANIMALS (dairy cattle, beef, swine, etc.)",null,null,null," DAIRY"]
["B.  NUMBER OF ANIMALS"]
["B1. % OF MANURE ENTERING STRUCTURE",null,null,null,100,"%",null,"%",null,"%",null,"%"]
["C.  WEIGHT OF ANIMALS (lbs.)",null,null,null,0,"lbs.",null,"lbs.",null,"lbs.",null,"lbs."]
["D.  AVERAGE ANNUAL MILK PRODUCTION",null,null,null,0,"lbs./yr.","XXXXXXXX",null,"XXXXXXXX",null,"XXXXXXXX"]
["E.  WASTE - (cu ft per day per AU)",null,null,null,{"$f":"0.00004*E14+0.8","v":0.8},"cu. ft.",null,"cu. ft.",null,"cu. ft.",null,"cu. ft."]
["F.  STORAGE PERIOD - days",null,null,null,0,"days",null,"days",null,"days",null,"days"]
["G.  MANURE VOLUME cu ft (BxCxExF)",null,null,null,{"$f":"E11/1000*(E12/100)*E13*E15*E16","v":0},"cu. ft.",{"$f":"G11/1000*(G12/100)*G13*G15*G16","v":0},"cu. ft.",{"$f":"I11/1000*(I12/100)*I13*I15*I16","v":0},"cu. ft.",{"$f":"K11/1000*(K12/100)*K13*K15*K16","v":0},"cu. ft."]
["H.  BEDDING TYPE",null,null,null,"Sawdust",null,"None",null,"None",null,"None"]
["    BEDDING VOLUME(cu ft/day*cow) or",null,null,null,0,"cu. ft.",null,"cu. ft.",0,"cu. ft.",10,"cu. ft."]
["    BEDDING VOLUME (Total cu ft/day)",null,null,null,0,"cu. ft.",0,"cu. ft.",0,"cu. ft.",0,"cu. ft."]
["    BEDDING REDUCTION FACTOR (See note)",null,null,null,0.5,null,0.5,null,0.5,null,0.5,null,"NOTE:  Use 1.0 for "]
["    TOTAL BEDDING",null,null,null,{"$f":"IF(E20=0,E11*E16*E19*E21,E16*E20*E21)","v":0},"cu. ft.",{"$f":"IF(G20=0,G11*G16*G19*G21,G16*G20*G21)","v":0},"cu. ft.",{"$f":"IF(I20=0,I11*I16*I19*I21,I16*I20*I21)","v":0},"cu. ft.",{"$f":"IF(K20=0,K11*K16*K19*K21,K16*K20*K21)","v":0},"cu. ft.","sand,  0.5 for all"]
["I.  MANURE + BEDDING VOLUME",null,null,null,{"$f":"E17+E22","v":0},"cu. ft.",{"$f":"G17+G22","v":0},"cu. ft.",{"$f":"I17+I22","v":0},"cu. ft.",{"$f":"K17+K22","v":0},"cu. ft.","other bedding types"]
[]
[]
[null,"MANURE STORAGE REQUIRED",null,null,{"$f":"E23+G23+I23+K23","v":0},"CU. FT."]
[]
[]
[]
["RUNOFF"]
[null,"CONTRIBUTING AREA",null,null,null,null,"sq. ft."]
[null,"NORMAL RUNOFF",null,null,null,null,"in."]
[null,"25 YR/24 HR RUNOFF",null,null,null,null,"in."]
[null,"STORAGE PERIOD (Largest of above)",null,null,null,{"$f":"LARGE((E16,G16,I16,K16),1)","v":0},"days"]
[null,"RUNOFF STORAGE REQUIRED (cu. ft.)",null,null,null,{"$f":"F31*(F32+F33)/12","v":0},"cu. ft."]
[]
[]
["WASH WATER",null,null,"Water Used Per Washing"]
[null,"EQUIPMENT",null,null,"Gallons per day"]
[null,"WASHING MACHINE (TOWELS)",null,null,"Gallons per day"]
[null,"WATER SOFTENER",null,null,"Gallons per day"]
[null,"PIPELINE",null,null,"Gallons per day"]
[null,"BULK TANK",null,null,"Gallons per day"]
[null,"MILK HOUSE FLOOR",null,null,"Gallons per day"]
[null,"WASHING CATTLE",null,null,"Gallons per day"]
[null,null,"Total",{"$f":"SUM(D39:D45)","v":0},"Gallons per day"]
[]
[null,null,"Total",{"$f":"SUM(D39:D45)/7.48*F34","v":0}," cu. ft."]
[]
[]
["TOTAL STORAGE REQUIRED"]
[null,"MANURE +BEDDING",null,{"$f":"E26","v":0},"cu. ft."]
[null,"RUNOFF",null,{"$f":"F35","v":0},"cu. ft."]
[null,"WASH WATER",null,{"$f":"D48","v":0},"cu. ft."]
[]
[null,"TOTAL",null,{"$f":"SUM(D52:D54)","v":0},"cu. ft. per",{"$f":"F34","v":0},"days"]

{"sheet":"Rainfall","index":1,"n_rows":346,"n_cols":8,"rows_kept":346,"cut":false,"hidden":false,"merged":[]}
["State = ","PA"]
["County =","Columbia"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",2.5,0.48,0.17,{"$f":"B7*C7","v":1.2},{"$f":"B7*D7","v":0.42500000000000004},0.9,{"$f":"B7-G7","v":1.6}]
["February",2.4,0.5,0.19,{"$f":"B8*C8","v":1.2},{"$f":"B8*D8","v":0.45599999999999996},0.9,{"$f":"B8-G8","v":1.5}]
["March",2.9,0.5,0.19,1.45,0.55099999999999993,1.5,1.4]
["April",3.6,0.51,0.2,1.8360000000000001,0.72000000000000008,2.1,1.5]
["May",4.2,0.51,0.2,2.1420000000000003,0.84000000000000008,3,1.2000000000000002]
["June",3.5,0.54,0.23,1.8900000000000001,0.80500000000000005,3.9,-0.39999999999999991]
["July",4.5999999999999996,0.54,0.24,2.484,1.1039999999999999,4.5,9.9999999999999645E-2]
["August",4.2,0.57999999999999996,0.27,2.4359999999999999,1.1340000000000001,4.2,0]
["September",3.1,0.57999999999999996,0.27,1.7979999999999998,0.83700000000000008,3.6,-0.5]
["October",2.9,0.53,0.22,1.5369999999999999,0.63800000000000001,2.7,0.19999999999999973]
["November",3.2,0.53,0.22,1.6960000000000002,0.70400000000000007,1.8,1.4000000000000001]
["December",2.8,0.48,0.17,1.3439999999999999,0.47599999999999998,0.9,1.9]
["Total=",{"$f":"SUM(B7:B18)","v":39.900000000000006}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E17:E18,E7:E10)","v":8.7260000000000009},{"$f":"SUM(F17:F18,F7:F10)","v":3.3320000000000003},{"$f":"SUM(H17:H18,H7:H10)","v":9.3000000000000007}]
["May-Oct",{"$f":"SUM(E11:E16)","v":12.286999999999999},{"$f":"SUM(F11:F16)","v":5.3579999999999997},{"$f":"SUM(H11:H16)","v":0.59999999999999964}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",5.0999999999999996,97,4.8600000000000003]
["Unpaved",5.0999999999999996,90,3.97]
[]
[]
[]
["State = ","PA"]
["County =","Centre"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on May 25, 2006:"]
["http://panutrientmgmt.cas.psu.edu/pdf/tm_appendix06.pdf"]
["Month","Direct Precipitation Inches","Direct Precipitation with Evaporation",null,"Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved"]
["January",2.4300000000000002,1.63,null,1.1200000000000001,0.36]
["February",2.5,1.7,null,1.2,0.43]
["March",3.33,1.93,null,1.6,0.56999999999999995]
["April",3.26,1.26,null,1.6,0.59]
["May",3.92,1.1200000000000001,null,1.92,0.71]
["June",4.3,0.7,null,2.3199999999999998,0.99]
["July",4.09,0,null,2.21,0.94]
["August",3.71,0,null,2.08,0.93]
["September",3.36,0.06,null,1.88,0.84]
["October",2.93,0.43,null,1.49,0.59]
["November",3.35,1.65,null,1.71,0.67]
["December",2.67,1.87,null,1.23,0.4]
["Total=",{"$f":"SUM(B38:B49)","v":39.85},{"$f":"SUM(C38:C49)","v":12.350000000000001},null,{"$f":"SUM(E38:E49)","v":20.36},{"$f":"SUM(F38:F49)","v":8.02}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E48:E49,E38:E41)","v":8.4600000000000009},{"$f":"SUM(F48:F49,F38:F41)","v":3.02},{"$f":"SUM(H48:H49,H38:H41)","v":0}]
["May-Oct",{"$f":"SUM(E42:E47)","v":11.9},{"$f":"SUM(F42:F47)","v":5},{"$f":"SUM(H42:H47)","v":0}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",5.2,97,4.8499999999999996]
["Unpaved",5.2,90,4.07]
[]
[]
[]
[]
[]
[]
[]
["State = ","PA"]
["County =","Luzerne"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",2.1,0.49,0.18,{"$f":"B73*C73","v":1.0289999999999999},{"$f":"B73*D73","v":0.378},0.9,{"$f":"B73-G73","v":1.2000000000000002}]
["February",2.2000000000000002,0.51,0.2,{"$f":"B74*C74","v":1.1220000000000001},{"$f":"B74*D74","v":0.44000000000000006},0.9,{"$f":"B74-G74","v":1.3000000000000003}]
["March",2.7,0.51,0.2,1.3770000000000002,0.54,1.5,1.2000000000000002]
["April",3.3,0.51,0.2,1.6829999999999998,0.66,3,0.29999999999999982]
["May",3.8,0.55000000000000004,0.24,2.09,0.91199999999999992,3.9,-0.10000000000000009]
["June",3.5,0.55000000000000004,0.24,1.9250000000000003,0.84,4.5,-1]
["July",4.0999999999999996,0.6,0.28999999999999998,2.4599999999999995,1.1889999999999998,4.2,-0.10000000000000053]
["August",4.0999999999999996,0.6,0.28999999999999998,2.4599999999999995,1.1889999999999998,3.6,0.49999999999999956]
["September",3.1,0.6,0.28999999999999998,1.8599999999999999,0.89899999999999991,3.56,-0.45999999999999996]
["October",2.9,0.54,0.23,1.5660000000000001,0.66700000000000004,2.7,0.19999999999999973]
["November",3.2,0.54,0.23,1.7280000000000002,0.7360000000000001,1.8,1.4000000000000001]
["December",2.8,0.49,0.18,1.3719999999999999,0.504,0.9,1.9]
["Total=",{"$f":"SUM(B73:B84)","v":37.800000000000004}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E83:E84,E73:E76)","v":8.3109999999999999},{"$f":"SUM(F83:F84,F73:F76)","v":3.2580000000000005},{"$f":"SUM(H83:H84,H73:H76)","v":7.3000000000000007}]
["May-Oct",{"$f":"SUM(E77:E82)","v":12.360999999999999},{"$f":"SUM(F77:F82)","v":5.6959999999999997},{"$f":"SUM(H77:H82)","v":-0.9600000000000013}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",5.2,97,4.8499999999999996]
["Unpaved",5.2,90,4.07]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State = ","PA"]
["County =","Lycoming"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",2.8,0.45,0.14000000000000001,{"$f":"B115*C115","v":1.26},{"$f":"B115*D115","v":0.39200000000000002},0.8,{"$f":"B115-G115","v":1.9999999999999998}]
["February",2.9,0.48,0.17,{"$f":"B116*C116","v":1.3919999999999999},{"$f":"B116*D116","v":0.49299999999999999},0.8,{"$f":"B116-G116","v":2.0999999999999996}]
["March",3.6,0.48,0.17,1.728,0.6120000000000001,1.4,2.2000000000000002]
["April",3.5,0.48,0.18,1.68,0.63,2,1.5]
["May",3.7,0.49,0.18,1.8129999999999999,0.66600000000000004,2.8,0.90000000000000036]
["June",4,0.53,0.22,2.12,0.88,3.6,0.39999999999999991]
["July",4,0.53,0.22,2.12,0.88,4.2,-0.20000000000000018]
["August",3.2,0.56000000000000005,0.25,1.7920000000000003,0.8,3.9,-0.69999999999999973]
["September",3.5,0.56000000000000005,0.25,1.9600000000000002,0.875,3.4,0.10000000000000009]
["October",3.2,0.51,0.2,1.6320000000000001,0.64000000000000012,2.5,0.70000000000000018]
["November",3.7,0.51,0.2,1.8870000000000002,0.7400000000000001,1.7,2]
["December",3.4,0.45,0.14000000000000001,1.53,0.47600000000000003,0.8,2.5999999999999996]
["Total=",{"$f":"SUM(B115:B126)","v":41.5}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E125:E126,E115:E118)","v":9.4770000000000003},{"$f":"SUM(F125:F126,F115:F118)","v":3.343},{"$f":"SUM(H125:H126,H115:H118)","v":12.399999999999999}]
["May-Oct",{"$f":"SUM(E119:E124)","v":11.437000000000001},{"$f":"SUM(F119:F124)","v":4.7409999999999997},{"$f":"SUM(H119:H124)","v":1.2000000000000006}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",4.9000000000000004,97,4.55]
["Unpaved",4.9000000000000004,90,3.78]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State = ","PA"]
["County =","Montour"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",2.6,0.48,0.17,{"$f":"B157*C157","v":1.248},{"$f":"B157*D157","v":0.44200000000000006},0.9,{"$f":"B157-G157","v":1.7000000000000002}]
["February",2.6,0.5,0.19,{"$f":"B158*C158","v":1.3},{"$f":"B158*D158","v":0.49400000000000005},0.9,{"$f":"B158-G158","v":1.7000000000000002}]
["March",3,0.5,0.19,1.5,0.57000000000000006,1.5,1.5]
["April",3.2,0.5,0.19,1.6,0.6080000000000001,2.1,1.1000000000000001]
["May",3.7,0.5,0.19,1.85,0.70300000000000007,3,0.70000000000000018]
["June",4.5,0.55000000000000004,0.24,2.4750000000000001,1.08,3.9,0.60000000000000009]
["July",3.5,0.55000000000000004,0.24,1.9250000000000003,0.84,4.5,-1]
["August",3.2,0.57999999999999996,0.27,1.8559999999999999,0.8640000000000001,4.2,-1]
["September",4,0.57999999999999996,0.27,2.3199999999999998,1.08,3.6,0.39999999999999991]
["October",2.6,0.53,0.22,1.3780000000000001,0.57200000000000006,2.7,-0.10000000000000009]
["November",3.2,0.53,0.22,1.6960000000000002,0.70400000000000007,1.8,1.4000000000000001]
["December",3.2,0.48,0.17,1.536,0.54400000000000004,0.9,2.3000000000000003]
["Total=",{"$f":"SUM(B157:B168)","v":39.300000000000004}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E167:E168,E157:E160)","v":8.8800000000000008},{"$f":"SUM(F167:F168,F157:F160)","v":3.3620000000000005},{"$f":"SUM(H167:H168,H157:H160)","v":9.7000000000000011}]
["May-Oct",{"$f":"SUM(E161:E166)","v":11.804},{"$f":"SUM(F161:F166)","v":5.1390000000000002},{"$f":"SUM(H161:H166)","v":-0.39999999999999991}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",5,97,4.6500000000000004]
["Unpaved",5,90,3.88]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State = ","PA"]
["County =","Northumberland"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",2.6,0.48,0.17,{"$f":"B199*C199","v":1.248},{"$f":"B199*D199","v":0.44200000000000006},0.9,{"$f":"B199-G199","v":1.7000000000000002}]
["February",2.6,0.5,0.19,{"$f":"B200*C200","v":1.3},{"$f":"B200*D200","v":0.49400000000000005},0.9,{"$f":"B200-G200","v":1.7000000000000002}]
["March",3,0.5,0.19,1.5,0.57000000000000006,1.5,1.5]
["April",3.2,0.5,0.19,1.6,0.6080000000000001,2.1,1.1000000000000001]
["May",3.7,0.5,0.19,1.85,0.70300000000000007,3,0.70000000000000018]
["June",4.5,0.55000000000000004,0.24,2.4750000000000001,1.08,3.9,0.60000000000000009]
["July",3.5,0.55000000000000004,0.24,1.9250000000000003,0.84,4.5,-1]
["August",3.2,0.57999999999999996,0.27,1.8559999999999999,0.8640000000000001,4.2,-1]
["September",4,0.57999999999999996,0.27,2.3199999999999998,1.08,3.6,0.39999999999999991]
["October",2.6,0.53,0.22,1.3780000000000001,0.57200000000000006,2.7,-0.10000000000000009]
["November",3.2,0.53,0.22,1.6960000000000002,0.70400000000000007,1.8,1.4000000000000001]
["December",3.1,0.48,0.17,1.488,0.52700000000000002,0.9,2.2000000000000002]
["Total=",{"$f":"SUM(B199:B210)","v":39.200000000000003}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E209:E210,E199:E202)","v":8.8320000000000007},{"$f":"SUM(F209:F210,F199:F202)","v":3.3450000000000002},{"$f":"SUM(H209:H210,H199:H202)","v":9.6}]
["May-Oct",{"$f":"SUM(E203:E208)","v":11.804},{"$f":"SUM(F203:F208)","v":5.1390000000000002},{"$f":"SUM(H203:H208)","v":-0.39999999999999991}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",5,97,4.6500000000000004]
["Unpaved",5,90,3.88]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State = ","PA"]
["County =","Snyder"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",2.6,0.48,0.17,{"$f":"B241*C241","v":1.248},{"$f":"B241*D241","v":0.44200000000000006},0.9,{"$f":"B241-G241","v":1.7000000000000002}]
["February",2.6,0.5,0.19,{"$f":"B242*C242","v":1.3},{"$f":"B242*D242","v":0.49400000000000005},0.9,{"$f":"B242-G242","v":1.7000000000000002}]
["March",3,0.5,0.19,1.5,0.57000000000000006,1.5,1.5]
["April",3.2,0.5,0.19,1.6,0.6080000000000001,2.1,1.1000000000000001]
["May",3.7,0.5,0.19,1.85,0.70300000000000007,3,0.70000000000000018]
["June",4.5,0.55000000000000004,0.24,2.4750000000000001,1.08,3.9,0.60000000000000009]
["July",3.5,0.55000000000000004,0.24,1.9250000000000003,0.84,4.5,-1]
["August",3.2,0.59,0.28000000000000003,1.8879999999999999,0.89600000000000013,4.2,-1]
["September",4,0.59,0.28000000000000003,2.36,1.1200000000000001,3.6,0.39999999999999991]
["October",2.6,0.53,0.22,1.3780000000000001,0.57200000000000006,2.7,-0.10000000000000009]
["November",3.2,0.53,0.22,1.6960000000000002,0.70400000000000007,1.8,1.4000000000000001]
["December",3.1,0.48,0.17,1.488,0.52700000000000002,0.9,2.2000000000000002]
["Total=",{"$f":"SUM(B241:B252)","v":39.200000000000003}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E251:E252,E241:E244)","v":8.8320000000000007},{"$f":"SUM(F251:F252,F241:F244)","v":3.3450000000000002},{"$f":"SUM(H251:H252,H241:H244)","v":9.6}]
["May-Oct",{"$f":"SUM(E245:E250)","v":11.875999999999999},{"$f":"SUM(F245:F250)","v":5.2110000000000003},{"$f":"SUM(H245:H250)","v":-0.39999999999999991}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",5,97,4.6500000000000004]
["Unpaved",5,90,3.88]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State = ","PA"]
["County =","Tioga"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",1.8,0.43,0.12,{"$f":"B283*C283","v":0.77400000000000002},{"$f":"B283*D283","v":0.216},0.8,{"$f":"B283-G283","v":1}]
["February",1.8,0.46,0.15,{"$f":"B284*C284","v":0.82800000000000007},{"$f":"B284*D284","v":0.27},0.8,{"$f":"B284-G284","v":1}]
["March",2.7,0.46,0.15,1.2420000000000002,0.40500000000000003,1.4,1.3000000000000003]
["April",2.8,0.48,0.17,1.3439999999999999,0.47599999999999998,1.9,0.89999999999999991]
["May",3.9,0.48,0.17,1.8719999999999999,0.66300000000000003,2.8,1.1000000000000001]
["June",3.3,0.53,0.22,1.7489999999999999,0.72599999999999998,3.6,-0.30000000000000027]
["July",4,0.53,0.22,2.12,0.88,4.0999999999999996,-9.9999999999999645E-2]
["August",4,0.55000000000000004,0.24,2.2000000000000002,0.96,3.9,0.10000000000000009]
["September",3.2,0.55000000000000004,0.22,1.7600000000000002,0.70400000000000007,4.0999999999999996,-0.89999999999999947]
["October",2.8,0.5,0.19,1.4,0.53199999999999992,2.5,0.29999999999999982]
["November",2.4,0.5,0.19,1.2,0.45599999999999996,1.7,0.7]
["December",2,0.43,0.12,0.86,0.24,0.8,1.2]
["Total=",{"$f":"SUM(B283:B294)","v":34.700000000000003}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E293:E294,E283:E286)","v":6.2479999999999993},{"$f":"SUM(F293:F294,F283:F286)","v":2.0629999999999997},{"$f":"SUM(H293:H294,H283:H286)","v":6.1}]
["May-Oct",{"$f":"SUM(E287:E292)","v":11.101000000000001},{"$f":"SUM(F287:F292)","v":4.4649999999999999},{"$f":"SUM(H287:H292)","v":0.20000000000000062}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",4.7,97,4.3499999999999996]
["Unpaved",4.7,90,3.59]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State = ","PA"]
["County =","Union"]
["Using Procedure Outlined in SCS ASMF N12-76.1 - N12-76.13"]
["Data Collected from the following internet web site on Feb, 14, 1999:"]
["www.psu.edu/docs/CASDEPT/AGRONOMY/EXTENSION/NMPennState/raindata/counties3.html"]
["Month","Direct Precipitation Inches","% of Mean Precipitation Paved Lot (CN - 97)","% of Mean Precipitation Unpaved Lot (CN - 90)","Drainage Area, Inches of Runoff - Paved","Drainage Area, Inches of Runoff - Unpaved","*Direct Evaporation Inches","Net Precipitation Inches"]
["January",2.6,0.47,0.16,{"$f":"B325*C325","v":1.222},{"$f":"B325*D325","v":0.41600000000000004},0.9,{"$f":"B325-G325","v":1.7000000000000002}]
["February",2.6,0.49,0.18,{"$f":"B326*C326","v":1.274},{"$f":"B326*D326","v":0.46799999999999997},0.9,{"$f":"B326-G326","v":1.7000000000000002}]
["March",3,0.49,0.18,1.47,0.54,1.5,1.5]
["April",3.2,0.5,0.19,1.6,0.6080000000000001,2.1,1.1000000000000001]
["May",3.7,0.5,0.19,1.85,0.70300000000000007,3,0.70000000000000018]
["June",4.5,0.54,0.23,2.4300000000000002,1.0350000000000001,3.9,0.60000000000000009]
["July",3.5,0.54,0.23,1.8900000000000001,0.80500000000000005,4.5,-1]
["August",3.2,0.57999999999999996,0.27,1.8559999999999999,0.8640000000000001,4.2,-1]
["September",4,0.57999999999999996,0.27,2.3199999999999998,1.08,3.6,0.39999999999999991]
["October",2.6,0.52,0.21,1.3520000000000001,0.54600000000000004,2.7,-0.10000000000000009]
["November",3.2,0.52,0.21,1.6640000000000001,0.67200000000000004,1.8,1.4000000000000001]
["December",3.1,0.47,0.16,1.4569999999999999,0.49600000000000005,0.9,2.2000000000000002]
["Total=",{"$f":"SUM(B325:B336)","v":39.200000000000003},{"$f":"SUM(C325:C336)/12","v":0.51666666666666672}]
[]
["Months","Runoff, Paved Lot Inches","Runoff, Unpaved Lot Inches","Net Precipitation Inches"]
["Nov-Apr",{"$f":"SUM(E335:E336,E325:E328)","v":8.6869999999999994},{"$f":"SUM(F335:F336,F325:F328)","v":3.2},{"$f":"SUM(H335:H336,H325:H328)","v":9.6}]
["May-Oct",{"$f":"SUM(E329:E334)","v":11.698},{"$f":"SUM(F329:F334)","v":5.0330000000000004},{"$f":"SUM(H329:H334)","v":-0.39999999999999991}]
[]
["25 Yr Runoff"]
["Lot","P25","Runoff Curve Number","Runoff Inches (Table 2-2a, EFM-2)"]
["Paved",4.9000000000000004,97,4.55]
["Unpaved",4.9000000000000004,90,3.78]

{"sheet":"CIRC. TANK","index":2,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["COUNTY",{"$f":"'Waste Volumes'!B4","v":"Name"},null,null,null,"DATE",{"$f":"'Waste Volumes'!G4","v":"00:00:00"}]
["OWNER",{"$f":"'Waste Volumes'!B5","v":"Farmer's Name"},null,null,null,"ADDRESS",{"$f":"'Waste Volumes'!G5","v":" "}]
["PREPARER",{"$f":"'Waste Volumes'!B6","v":0},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G6","v":0},null,"DATE",{"$f":"'Waste Volumes'!J6","v":0}]
["CHECKED",{"$f":"'Waste Volumes'!B7","v":" "},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G7","v":" "},null,"DATE",{"$f":"'Waste Volumes'!J7","v":" "}]
[]
[]
["STORAGE VOLUME REQUIRED",null,null,{"$f":"'Waste Volumes'!D56","v":0},"cu. ft."]
["STORAGE LENGTH",null," ",{"$f":"'Waste Volumes'!F56","v":0},"days"]
[null,null,null,"TRIAL 1",null,"TRIAL 2",null,"TRIAL 3",null,"TRIAL 4"]
["  A.  TOTAL TANK DEPTH",null,null,8,"FT.",10,"FT.",12,"FT.",14,"FT.",null,null,null,null,{"$f":"IF($C$27=1,D13,IF($C$27=2,F13,IF($C$27=3,H13,IF($C$27=4,J13))))","v":12}]
["  B.  FREEBOARD DEPTH",null,null,0.5,"FT.",0.5,"FT.",0.5,"FT.",0.5,"FT.",null,null,null,null,0.5]
["  C.  RAINFALL DEPTH",null,null,{"$f":"$D$11/180+0.4","v":0.4},"FT.",{"$f":"$D$11/180+0.4","v":0.4},"FT.",{"$f":"$D$11/180+0.4","v":0.4},"FT.",{"$f":"$D$11/180+0.4","v":0.4},"FT.",null,null,null,null,0.4]
["  D.  MIN. PUMPOUT DEPTH",null,null,0.5,"FT.",0.5,"FT.",0.5,"FT.",0.5,"FT.",null,null,null,null,0.5]
["  E.  STORAGE DEPTH",null,null,{"$f":"D13-D14-D15-D16","v":6.6},"FT.",{"$f":"F13-F14-F15-F16","v":8.6},"FT.",{"$f":"H13-H14-H15-H16","v":10.6},"FT.",{"$f":"J13-J14-J15-J16","v":12.6},"FT.",null,null,null,null,10.6]
["  G.  REQ'D TANK DIAMETER",null,null,{"$f":"ROUNDUP(2*SQRT($D$10/(PI()*D17)),0)","v":0},"FT.",{"$f":"ROUNDUP(2*SQRT($D$10/(PI()*F17)),0)","v":0},"FT.",{"$f":"ROUNDUP(2*SQRT($D$10/(PI()*H17)),0)","v":0},"FT.",{"$f":"ROUNDUP(2*SQRT($D$10/(PI()*J17)),0)","v":0},"FT.",null,null,null,null,0]
["ACTUAL TANK CAPACITY OF"]
["                   STORAGE DEPTH",null,null,{"$f":"PI()*POWER((D18/2),2)*D17","v":0},"cu. ft.",{"$f":"PI()*POWER((F18/2),2)*F17","v":0},"cu. ft.",{"$f":"PI()*POWER((H18/2),2)*H17","v":0},"cu. ft.",{"$f":"PI()*POWER((J18/2),2)*J17","v":0},"cu. ft."]
[null,null,null,{"$f":"D20*7.5","v":0},"GAL",{"$f":"F20*7.5","v":0},"GAL",{"$f":"H20*7.5","v":0},"GAL",{"$f":"J20*7.5","v":0},"GAL"]
["ACTUAL TANK CAPACITY AT"]
["              FREEBOARD DEPTH",null,null,{"$f":"PI()*POWER((D18/2),2)*(D13-D14)","v":0},"cu. ft.",{"$f":"PI()*POWER((F18/2),2)*(F13-F14)","v":0},"cu. ft.",{"$f":"PI()*POWER((H18/2),2)*(H13-H14)","v":0},"cu. ft.",{"$f":"PI()*POWER((J18/2),2)*(J13-J14)","v":0},"cu. ft."]
[null,null,null,{"$f":"D23*7.5","v":0},"GAL",{"$f":"F23*7.5","v":0},"GAL",{"$f":"H23*7.5","v":0},"GAL",{"$f":"J23*7.5","v":0},"GAL"]
[]
[]
[null,"SELECT TRIAL #",3]
[]
[null,null,null,null,null,null,null,null,"TANK DEPTH",{"$f":"P13","v":12},"FT"]
[null,null,null,null,null,null,null,null,"FREEBOARD",{"$f":"P14","v":0.5},"FT"]
[null,null,null,null,null,null,null,null,"RAIN FALL",{"$f":"P15","v":0.4},"FT"]
[]
[]
[null,null,null,null,null,null,null,null,"STORAGE"]
[null,null,null,null,null,null,null,null,"DEPTH",{"$f":"P17","v":10.6},"FT"]
[]
[]
[null,null,null,null,null,null,null,null,"PUMP OUT",{"$f":"P16","v":0.5},"FT"]

{"sheet":"Earthen Pond ","index":3,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["COUNTY",{"$f":"'Waste Volumes'!B4","v":"Name"},null,null,null,"DATE",{"$f":"'Waste Volumes'!G4","v":"00:00:00"}]
["OWNER",{"$f":"'Waste Volumes'!B5","v":"Farmer's Name"},null,null,null,"ADDRESS",{"$f":"'Waste Volumes'!G5","v":" "}]
["PREPARER",{"$f":"'Waste Volumes'!B6","v":0},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G6","v":0},null,"DATE",{"$f":"'Waste Volumes'!J6","v":0}]
["CHECKED",{"$f":"'Waste Volumes'!B7","v":" "},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G7","v":" "},null,"DATE",{"$f":"'Waste Volumes'!J7","v":" "}]
[]
[]
["STORAGE VOLUME REQUIRED",null,null,{"$f":"'Waste Volumes'!D56","v":0},"cu. ft.",null,"SIDE SLOPE",2,":1"]
["DESIGN FULL ",null,null,{"$f":"D10-'Waste Volumes'!F31*'Waste Volumes'!F33/12","v":0},"(LESS 25 YR RUNOFF)"]
["DESIGN 1/2 FULL ",null,null,{"$f":"D10/2","v":0},"(LESS 25 YR RUNOFF)"]
["STORAGE LENGTH",null," ",{"$f":"'Waste Volumes'!F56","v":0},"days"]
[]
["STORAGE FROM COMPUTATION",null,null,null,"TOTAL STORAGE",null,"Design Full",null,"Design 1/2 Full"]
["  A.  TOTAL DEPTH",null,null,null,10,"FT.",{"$f":"E16","v":10},"FT.",{"$f":"E16","v":10},"FT."]
["  B.  FREEBOARD DEPTH",null,null,null,1,"FT.",{"$f":"E17","v":1},"FT.",{"$f":"E17","v":1},"FT."]
["  C.  RAINFALL DEPTH",null,null,null,{"$f":"$D$13/180+0.4","v":0.4},"FT.",{"$f":"$D$13/180+0.4","v":0.4},"FT.",{"$f":"$D$13/180+0.4","v":0.4},"FT."]
["  D.  MIN. PUMPOUT DEPTH",null,null,null,0.5,"FT.",{"$f":"E19","v":0.5},"FT.",{"$f":"E19","v":0.5},"FT."]
["  E.  STORAGE DEPTH",null,null,null,{"$f":"E16-E17-E18-E19","v":8.1},"FT.",8.1,"FT.",8.1,"FT."]
["  F.  TOP WIDTH",null,null,null,100,"FT.",{"$f":"E21","v":100},"FT.",{"$f":"E21","v":100},"FT."]
["  G.  TOP LENGTH",null,null,null,100,"FT.",{"$f":"E22","v":100},"FT.",{"$f":"E22","v":100},"FT."]
["  H.  TOP WIDTH AT STORAGE DEPTH",null,null,null,{"$f":"E21-$H$10*2*(E$17+E$18)","v":94.4},"FT.",{"$f":"G25+$H$10*2*($G$20)","v":94.4},"FT.",{"$f":"I25+$H$10*2*($I$20)","v":94.4},"FT."]
["  I.  TOP LENGTH AT STORAGE DEPTH",null,null,null,{"$f":"E22-$H$10*2*(E$17+E$18)","v":94.4},"FT.",{"$f":"G26+$H$10*2*($G$20)","v":94.4},"FT.",{"$f":"I26+$H$10*2*($I$20)","v":94.4},"FT."]
["  J.  BOTTOM WIDTH AT STORAGE DEPTH",null,null,null,{"$f":"E21-$H$10*2*(E16-E19)","v":62},"FT.",{"$f":"E25","v":62},"FT.",{"$f":"I21-$H$10*2*(I16-I19)","v":62},"FT."]
["  K.  BOTTOM LENGTH AT STORAGE DEPTH",null,null,null,{"$f":"E22-$H$10*2*(E16-E19)","v":62},"FT.",{"$f":"E26","v":62},"FT.",{"$f":"I22-$H$10*2*(I16-I19)","v":62},"FT."]
["  L.  AREA @ BASE STORAGE DEPTH",null,null,null,{"$f":"E25*E26","v":3844},"FT.2",{"$f":"G25*G26","v":3844},"FT.2",{"$f":"I25*I26","v":3844},"FT.2"]
["  M.  AREA @ TOP STORAGE DEPTH",null,null,null,{"$f":"E23*E24","v":8911.36},"FT.2",{"$f":"G23*G24","v":8911.36},"FT.2",{"$f":"I23*I24","v":8911.36},"FT.2"]
["  N.  CALCULATED STORAGE VOLUME",null,null,null,{"$f":"(E$23*E$24*E$20)-($H$10*E$23*(E$20)^2)-($H$10*E$24*(E$20)^2)+1.33*((($H$10)^2)*(E$20)^3)","v":50234.946119999993},"CU. FT.",{"$f":"(G$23*G$24*G$20)-($H$10*G$23*(G$20)^2)-($H$10*G$24*(G$20)^2)+1.33*((($H$10)^2)*(G$20)^3)","v":50234.946119999993},"CU. FT.",{"$f":"(I$23*I$24*I$20)-($H$10*I$23*(I$20)^2)-($H$10*I$24*(I$20)^2)+1.33*((($H$10)^2)*(I$20)^3)","v":50234.946119999993},"CU. FT."]
[]
[]
[null,null,"              USE TRIAL #",null,1]
[]
[]
[null,null,"TOP WIDTH",{"$f":"CHOOSE($E$32+1,0,E21,G21,I21)","v":100},"FT",null,"BOTTOM WIDTH",{"$f":"D35-(CHOOSE($E$32+1,0,$E$16,$G$16,$I$16,)*2)*$H$10","v":60},"FT"]
[null,null,"TOP LENGTH",{"$f":"CHOOSE($E$32+1,0,E22,G22,I22)","v":100},"FT",null,"BOTTOM LENGTH",{"$f":"D36-(CHOOSE($E$32+1,0,$E$16,$G$16,$I$16,)*2)*$H$10","v":60},"FT"]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL DEPTH",{"$f":"CHOOSE($E$32+1,0,E16,G16,I16)","v":10},"FT."]
[null,null,null,null,null,null,null,null,null,null,"FREEBOARD",{"$f":"CHOOSE($E$32+1,0,E17,G17,I17)","v":1},"FT."]
[null,null,null,null,null,null,null,null,null,null,"RAINFALL",{"$f":"CHOOSE($E$32+1,0,E18,G18,I18)","v":0.4},"FT."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"DEPTH TO MAXIMUM STORAGE"]
[null,null,null,null,null,null,null,null,null,null,"FULL",{"$f":"E20+E19+E18-0.4","v":8.6},"FT."]
[null,null,null,null,null,null,null,null,null,null,"DESIGN",{"$f":"G20+G19+E18-0.4","v":8.6},"FT."]
[null,null,null,null,null,null,null,null,null,null,"1/2 DESIGN",{"$f":"I20+I19+E18-0.4","v":8.6},"FT."]
[]
[null,null,null,null,null,null,null,null,null,null,"PUMPOUT",{"$f":"CHOOSE($E$32+1,0,E19,G19,I19)","v":0.5},"FT."]

{"sheet":"RAMP","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["COUNTY",{"$f":"'Waste Volumes'!B4","v":"Name"},null,null,null,"DATE",{"$f":"'Waste Volumes'!G4","v":"00:00:00"}]
["OWNER",{"$f":"'Waste Volumes'!B5","v":"Farmer's Name"},null,null,null,"ADDRESS",{"$f":"'Waste Volumes'!G5","v":" "}]
["PREPARER",{"$f":"'Waste Volumes'!B6","v":0},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G6","v":0},null,"DATE",{"$f":"'Waste Volumes'!J6","v":0}]
["CHECKED",{"$f":"'Waste Volumes'!B7","v":" "},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G7","v":" "},null,"DATE",{"$f":"'Waste Volumes'!J7","v":" "}]
[]
[]
["STORAGE VOLUME REQUIRED",null,null,{"$f":"'Waste Volumes'!D56","v":0},"cu. ft.",null,"SIDE SLOPE",{"$f":"'Earthen Pond '!H10","v":2},":1"]
["STORAGE LENGTH",null," ",{"$f":"'Waste Volumes'!F56","v":0},"days"]
[]
["  A.  RAMP SLOPE =",null,null,8,"FT."]
["  B.  STORAGE DEPTH=",null,null,{"$f":"'Earthen Pond '!L43","v":8.6},"FT."]
["  C.  PIT SIDE SLOPE =",null,null,{"$f":"H10","v":2},"FT./ 1 FT."]
["  D.  RAMP WIDTH =",null,null,12,"FT."]
["  E.  TOTAL VOLUME OF RAMP =",null,null,{"$f":"(D16/2+(D14*D15)/3)*(D13-D15)*POWER(D14,2)","v":5206.7839999999997},"cu. ft."]

{"sheet":"Rect Tank","index":5,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["COUNTY",{"$f":"'Waste Volumes'!B4","v":"Name"},null,null,null,"DATE",{"$f":"'Waste Volumes'!G4","v":"00:00:00"}]
["OWNER",{"$f":"'Waste Volumes'!B5","v":"Farmer's Name"},null,null,null,"ADDRESS",{"$f":"'Waste Volumes'!G5","v":" "}]
["PREPARER",{"$f":"'Waste Volumes'!B6","v":0},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G6","v":0},null,"DATE",{"$f":"'Waste Volumes'!J6","v":0}]
["CHECKED",{"$f":"'Waste Volumes'!B7","v":" "},null,null,null,"TITLE",{"$f":"'Waste Volumes'!G7","v":" "},null,"DATE",{"$f":"'Waste Volumes'!J7","v":" "}]
[]
[]
["STORAGE VOLUME REQUIRED",null,null,{"$f":"'Waste Volumes'!D56","v":0},"cu. ft."]
["STORAGE LENGTH",null," ",{"$f":"'Waste Volumes'!F56","v":0},"days"]
[]
["  A.  TOTAL TANK DEPTH",null,null,4,"FT."]
["  B.  FREEBOARD DEPTH",null,null,0.5,"FT."]
["  C.  RAINFALL DEPTH",null,null,0,"FT."]
["  D.  MIN. PUMPOUT DEPTH",null,null,0.5,"FT."]
["  E.  STORAGE DEPTH",null,null,{"$f":"D13-D14-D15-D16","v":3},"FT."]
["  F.  INSIDE LENGTH",null,null,8,"FT."]
["  G.  INSIDE WIDTH",null,null,{"$f":"D10/(D17*D18)","v":0},"FT."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"FREEBOARD",{"$f":"D14","v":0.5},"FT"]
[null,null,null,null,null,null,null,null,"RAIN FALL",{"$f":"D15","v":0},"FT"]
[]
[]
[null,null,null,null,null,null,null,null,"STORAGE"]
[null,null,null,null,null,null,null,null,"DEPTH",{"$f":"D17","v":3},"FT"]
[]
[]
[null,null,null,null,null,null,null,null,"PUMP OUT",{"$f":"D16","v":0.5},"FT"]

{"sheet":"Bedding","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}