{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Structure Sizing Data","Circular Structure Sizing","Earthen Pit Sizing","Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Instructions","index":0,"n_rows":98,"n_cols":2,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"General information about these spreadsheets:"]
[]
["1.","These spreadsheets are intended to be used for dairy waste only."]
[]
["2.","All areas highlighted in yellow on the spreadsheets are items that must be inputted."]
[]
["3.","All areas highlighted in blue on the spreadsheets are items that have been calculated."]
[]
["4.","The sizing calculations performed on these spreadsheets are in accordance with Virginia Conservation Practice Standard 313 \" Waste Storage Facility\"."]
[]
[null,"Instructions for using the \"Structure Sizing Data\" spreadsheet"]
[]
["1.","Enter the cooperator's name in the space provided."]
[]
["2.","Enter the service center name in the space provided."]
[]
["3.","Select the appropriate conservation district from the pull-down list."]
[]
["4.","Enter the name of the person assisting the cooperator in the space provided."]
[]
["5.","Enter the tract and field numbers in the spaces provided."]
[]
["6.","Enter the waste storage period in the space provided.  The minimum storage period shall be a minimum of 120 days."]
[]
["7.","Enter the total number of cows, heifers, calves, or other with the corresponding average weights in the spaces provided.  Enter the % confinement and corresponding"]
[null,"days in the spaces provided.  The total number of days for each animal type must add up to equal the storage period entered in step 6 above."]
[]
["8.","Enter the bedding volume that can be expected during the storage period in the space provided.  This information should be obtained from the cooperator whenever"]
[null,"possible."]
[]
["9.","Enter the feed waste volume that can be expected during the storage period in the space provided.  This information should be obtained from the cooperator"]
[null,"whenever possible."]
[]
["10.","Enter the drainage area and amount of runoff for all of the paved and unpaved areas draining to the structure in the spaces provided.  Historical rainfall data for the "]
[null,"area of  the project should be used in correlation with table 2-2 in the Engineering Field Handbook to obtain the runoff amount."]
[]
["11.","Enter the 25-year, 24-hour storm rainfall depth in the space provided.  This information should be obtained from the Engineering Field Handbook, Chapter 2."]
[]
["12.","Enter the volume of waste generated by each animal type in the spaces provided (this value can range anywhere from 1.30 to 1.39 c.f./AU/day). Consult the"]
[null,"Area Engineer for guidance on these volume generations."]
[]
["13.","Enter the amount of wastewater produced daily, and the number of days in the spaces provided.  This information should be obtained from the cooperator whenever"]
[null,"possible."]
[]
["14.","Once all of the data in the above steps is entered, the spreadsheet will calculate the volume of waste.  This waste volume does not include direct rainfall on the "]
[null,"proposed structure (this volume will be calculated in the following spreadsheets if designing a circular structure or an earthen pit)."]
[]
[null,"Instructions for using the \"Circular Structure Sizing\" spreadsheet"]
[]
["1.","Make sure that all necessary data has been entered into the Structure Sizing Data spreadsheet (as described above) prior to entering any data into this spreadsheet."]
[]
["2.","The cooperator, storage period, and waste total from the Structure Sizing Data spreadsheet will be automatically entered into this spreadsheet."]
[]
["3.","Enter any additional storage volume that will be needed for the design of the structure in the space provided."]
[]
["4.","The total volume of waste and runoff  to be stored in the proposed structure will be calculated based on the total waste volume from the Structure Sizing Data"]
[null,"spreadsheet and the additional storage volume entered in step 3 above."]
[]
["5.","Enter the diameter of the structure that you wish to install in the space provided.  The spreadsheet will then calculate the required height of the structure based on"]
[null,"this diameter.  Change the diameter as necessary to obtain the combination of diameter and height that works best for the site."]
[]
["6.","Enter the direct rainfall on the structure during the storage period in the space provided.  Historical rainfall data for the area of the project should be used."]
[]
["7.","The direct contribution from the 25-year, 24-hour storm will be automatically calculated based on the precipitation information inputted on the Structure Sizing"]
[null,"Data spreadsheet."]
[]
["8.","Enter any additional freeboard required for the structure in the space provided.  A minimum of 6 inches (0.5 feet) is required."]
[]
["9.","The final dimensions of the structure will then be calculated based on the inputted information."]
[]
[null,"Instructions for using the \"Earthen Pit Sizing\" spreadsheet"]
[]
["1.","Make sure that all necessary data has been entered into the Structure Sizing Data spreadsheet (as described above) prior to entering any data into this spreadsheet."]
[]
["2.","The cooperator, storage period, and waste total from the Structure Sizing Data spreadsheet will be automatically entered into this spreadsheet."]
[]
["3.","Enter any additional storage volume that will be needed for the design of the structure in the space provided."]
[]
["4.","The total volume of waste and runoff  to be stored in the proposed structure will be calculated based on the total waste volume from the Structure Sizing Data"]
[null,"spreadsheet and the additional storage volume entered in step 3 above."]
[]
["5.","Enter the side slope data for the pit in the space provided.  Side slopes should be no steeper than 3:1, except where compacted earth liners are part of an earthen"]
[null,"fill operation."]
[]
["6.","Under the structure sizing by trial and error section, enter the bottom width, bottom length, and depth of the pit into the spaces provided.  There is room for 4"]
[null,"different trials.  The spreadsheet will calculate the volume based on the information that was inputted, and will state whether it is less than or greater than the volume"]
[null,"required."]
[]
["7.","Enter the trial that you would like to use for the final design into the space provided."]
[]
["8.","Enter the direct rainfall on the structure during the storage period in the space provided.  Historical rainfall data for the area of the project should be used."]
[]
["9.","The direct contribution from the 25-year, 24-hour storm will be automatically calculated based on the precipitation information inputted on the Structure Sizing"]
[null,"Data spreadsheet."]
[]
["10.","Enter any additional freeboard required for the structure in the space provided (a minimum of 1 foot is required)."]
[]
["11.","The final dimensions of the structure will then be calculated based on the inputted information."]

{"sheet":"Structure Sizing Data","index":1,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[36,0,36,2],[22,3,22,12],[61,10,61,12],[55,0,55,1],[19,5,19,6],[51,0,51,2],[52,1,52,12],[38,0,38,8],[41,0,41,8],[44,0,44,8],[48,0,48,2],[16,0,16,1],[16,3,16,4],[17,0,17,8],[17,13,17,15],[19,0,19,1],[19,3,19,4],[19,13,19,15],[16,5,16,6],[13,0,13,1],[13,3,13,4],[14,0,14,8],[14,13,14,15],[13,5,13,6],[7,2,7,3],[7,9,7,13],[8,4,8,7],[8,12,8,15],[10,0,10,1],[10,3,10,4],[10,13,11,15],[11,0,11,8],[10,5,10,6],[4,14,4,15],[5,2,5,4],[5,9,5,13],[6,0,6,1],[6,2,6,4],[6,6,6,7],[6,9,6,13],[6,14,6,15],[3,2,3,4],[3,9,3,13],[4,0,4,1],[4,2,4,4],[4,6,4,7],[4,9,4,13],[0,0,0,15],[1,0,1,15],[2,0,2,1],[2,2,2,4],[2,6,2,7],[2,9,2,13],[2,14,2,15]]}
["Virginia NRCS Dairy Waste Structure Sizing Data Worksheet"]
[]
["Cooperator:",null,null,null,null,null,null,null,"Service Center:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Conservation District:",null,null,null,null,null,null,null,"Assisted By:"]
[]
["Tract Number:",null,null,null,null,null,null,null,"Field Number:"]
[]
[null,"Date:",{"$f":"TODAY()","v":"2014-04-01"},null,null,null,null,null,"Storage Period:",null,"days"]
[]
["Number of Cows:",null,null,"Average weight:",null,null,null,"lbs.","% confinement:",null,"for",null,"days",{"$f":"IF(L11+L12=J9,\" \",\"Total Days Must = Storage Period!\")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,"for",null,"days"]
[]
["Replacement Heifers:",null,null,"Average weight:",null,null,null,"lbs.","% confinement:",null,"for",null,"days"]
[null,null,null,null,null,null,null,null,null,null,"for",null,"days"]
[]
["Calves:",null,null,"Average weight:",null,null,null,"lbs.","% confinement:",null,"for",null,"days"]
[null,null,null,null,null,null,null,null,null,null,"for",null,"days"]
[]
["Other:",null,null,"Average weight:",null,null,null,"lbs.","% confinement:",null,"for",null,"days"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enter bedding volume for the planned storage period here","=",null,"cubic feet"]
[null,null,null,"(this value should be obtained directly from cooperator when possible)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enter feed waste volume for the planned storage period here","=",null,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(this value should be obtained directly from cooperator when possible)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Drainage area to structure (paved area)","=",null,"square feet"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total amount of runoff for paved area (less evaporation) over the entire storage period","=",null,"inches"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Drainage area to structure (unpaved area)","=",null,"square feet"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total amount of runoff for unpaved area (less evaporation) over the entire storage period","=",null,"inches"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"25-year, 24-hour storm rainfall depth","=",null,"inches"]
["I. Manure Production:"]
[{"$f":"C11","v":0},"Cows   X",{"$f":"F11/1000","v":0},"animal units","X",null,"cf/AU/day","X"," % confinement:",{"$f":"J11","v":0},"for",{"$f":"L11","v":0},"days","=",{"$f":"A38*C38*F38*(J38/100)*L38","v":0},"cubic feet"]
[null,null,null,null,null,null,null,null,null,{"$f":"J12","v":0},"for",{"$f":"L12","v":0},"days","=",{"$f":"A38*C38*F38*(J39/100)*L39","v":0},"cubic feet"]
[]
[{"$f":"C14","v":0},"Heifers   X",{"$f":"F14/1000","v":0},"animal units","X",null,"cf/AU/day","X"," % confinement:",{"$f":"J14","v":0},"for",{"$f":"L14","v":0},"days","=",{"$f":"A41*C41*F41*(J41/100)*L41","v":0},"cubic feet"]
[null,null,null,null,null,null,null,null,null,{"$f":"J15","v":0},"for",{"$f":"L15","v":0},"days","=",{"$f":"A41*C41*F41*(J42/100)*L42","v":0},"cubic feet"]
[]
[{"$f":"C17","v":0},"Calves   X",{"$f":"F17/1000","v":0},"animal units","X",null,"cf/AU/day","X"," % confinement:",{"$f":"J17","v":0},"for",{"$f":"L17","v":0},"days","=",{"$f":"A44*C44*F44*(J44/100)*L44","v":0},"cubic feet"]
[null,null,null,null,null,null,null,null,null,{"$f":"J18","v":0},"for",{"$f":"L18","v":0},"days","=",{"$f":"A44*C44*F44*(J45/100)*L45","v":0},"cubic feet"]
[]
[{"$f":"C20","v":0},"Other   X",{"$f":"F20/1000","v":0},"animal units","X",null,"cf/AU/day","X"," % confinement:",{"$f":"J20","v":0},"for",{"$f":"L20","v":0},"days","=",{"$f":"A47*C47*F47*(J47/100)*L47","v":0},"cubic feet"]
[]
["II. Wastewater Production:"]
[null,null,"gallons per day",null,"X",null,"1 cubic foot / 7.48 gallons",null,null,"for",null,null,"days","=",{"$f":"B50*L50/7.48","v":0},"cubic feet"]
[]
["III. Bedding & Feed Waste:"]
[null,"Bedding & Feed Waste volumes should be obtained directly from cooperator where possible and entered above:",null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"O22+O25","v":0},"cubic feet"]
[]
["IV. Runoff:"]
["Paved area:",null,{"$f":"O28","v":0},"square feet","X",null,{"$f":"O30","v":0},"\" of runoff (less evaporation) for storage period",null,null,null,null,null,"=",{"$f":"C56*G56/12","v":0},"cubic feet"]
[]
[null,"Unpaved area:",{"$f":"O32","v":0},"square feet","X",null,{"$f":"O34","v":0},"\" of runoff (less evaporation) for storage period",null,null,null,null,null,null,{"$f":"C58*G58/12","v":0},"cubic feet"]
[]
[null,"25 year storm:",{"$f":"O28+O32","v":0},"square feet","X",null,{"$f":"O36","v":0},"\" of rainfall depth",null,null,null,null,null,null,{"$f":"C60*G60/12","v":0},"cubic feet"]
[]
[null,null,null,null,null,null,null,null,null,null,"Subtotal of I-IV",null,null,"=",{"$f":"SUM(O38:O61)","v":0},"cubic feet"]

{"sheet":"Circular Structure Sizing","index":2,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[28,0,28,4],[28,6,28,7],[28,9,28,12],[31,0,31,13],[29,0,29,13],[30,0,30,2],[30,3,30,5],[30,6,30,7],[30,9,30,12],[26,0,26,2],[26,3,26,4],[26,5,26,7],[26,10,26,13],[27,0,27,13],[22,0,22,13],[23,0,23,1],[23,2,23,13],[24,0,24,1],[25,0,25,13],[19,0,19,13],[20,0,20,5],[20,6,20,13],[21,0,21,2],[21,4,21,5],[21,6,21,13],[17,0,17,2],[17,4,17,5],[17,6,17,13],[18,0,18,2],[18,3,18,13],[14,0,14,2],[14,4,14,12],[15,0,15,13],[16,0,16,2],[16,3,16,13],[11,0,11,13],[12,0,12,2],[12,4,12,7],[12,8,12,13],[13,0,13,13],[8,6,8,7],[8,8,8,13],[9,0,9,13],[10,0,10,2],[10,4,10,5],[10,6,10,13],[41,10,41,11],[41,12,41,13],[0,0,0,13],[1,0,1,1],[1,2,1,3],[1,6,1,7],[1,9,1,13],[4,0,4,13],[5,0,5,7],[2,0,2,13],[3,0,3,3],[3,6,3,7],[3,8,3,13],[6,0,6,13],[7,0,7,9],[8,0,8,3]]}
["Virginia NRCS Dairy Waste Circular Structure Sizing Worksheet"]
["Cooperator:",null,{"$f":"'Structure Sizing Data'!C3:E3","v":0},null,null,"Storage Period:",{"$f":"'Structure Sizing Data'!J9","v":0},null,"days"]
[]
["Subtotal of I-IV from previous page:",null,null,null,null,{"$f":"'Structure Sizing Data'!O62","v":0},"cubic feet"]
[]
["Enter any additional volume that will be utilized as storage in the new system:",null,null,null,null,null,null,null,null,"cubic feet"]
[]
["To determine total volume of waste and runoff to be stored in new structure:"]
[null,null,null,null,null,{"$f":"F4+I6","v":0},"cubic feet"]
[]
["Select diameter for structure:",null,null,null,"feet."]
[" "]
["This structure provides:",null,null,{"$f":"3.141592654*(D11/2)^2","v":0},"cubic feet of storage per foot of height"]
[]
["So it will take:",null,null,{"$f":"F9/D13","v":{"$error":"#DIV/0!"}},"feet of height in this diameter structure to store the waste and runoff volume."]
[]
["V. Direct Precipitation:"]
["Direct rainfall on the structure:",null,null,null,"feet"]
["(less evaporation)"]
[]
["VI. Direct Contribution by 25-year, 24-hour storm:"]
["Direct rainfall on the structure:",null,null,{"$f":"'Structure Sizing Data'!O36/12","v":0},"feet"]
[]
["VII. Freeboard"]
[null,null,"Add:",null,"feet of freeboard (0.5' minimum)"]
[]
["Total height of the structure =",null,null,{"$f":"D15+D18+D22+D25","v":{"$error":"#DIV/0!"}},null,"feet for the selected diameter of ",null,null,{"$f":"D11","v":0},"feet"]
[]
["Final dimensions of the structure:",null,null,null,null,{"$f":"ROUNDUP(D27,1)","v":{"$error":"#DIV/0!"}},"feet high and",null,{"$f":"D11","v":0},"feet in diameter"]
[]
["Structure sized for:",null,null,{"$f":"F9","v":0},null,null,"to provide",null,{"$f":"G2","v":0},"days storage"]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D25","v":0},"ft. needed for freeboard"]
[]
[null,null,null,null,null,null,null,null,null,null," ",{"$f":"D22","v":0},"ft. needed for direct 25 yr. storm"]
[{"$f":"I29","v":0}," ft. diameter",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D18","v":0},"ft. needed for direct rainfall"]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D15","v":{"$error":"#DIV/0!"}},"ft. needed for waste & runoff"]
[]
[null,null,null,null,null,null,null,null,null,"Total Volume of Structure = ",{"$f":"(3.141592654*(I29/2)^2)*(L34+L36+L38+L40)","v":{"$error":"#DIV/0!"}},null,"cubic feet"]

{"sheet":"Earthen Pit Sizing","index":3,"n_rows":58,"n_cols":20,"rows_kept":58,"cut":false,"hidden":false,"merged":[[23,8,23,9],[28,0,28,3],[28,6,28,7],[51,13,51,14],[37,0,37,3],[37,5,37,6],[34,0,34,1],[35,0,35,1],[35,6,35,7],[35,8,35,15],[32,0,32,3],[32,6,32,7],[32,8,32,15],[29,0,29,3],[31,8,31,15],[14,8,14,12],[17,15,17,18],[19,15,19,18],[21,15,21,18],[17,8,17,9],[19,8,19,9],[21,8,21,9],[57,11,57,12],[0,0,0,15],[1,0,1,1],[1,3,1,5],[1,8,1,9],[1,10,1,11],[1,12,1,15],[3,10,3,15],[8,6,8,7],[8,8,8,9],[8,10,8,15],[7,13,7,15],[3,6,3,7],[3,8,3,9],[11,0,11,3],[23,15,23,18]]}
["Virginia NRCS Dairy Waste Earthen Pit Sizing Worksheet"]
["Cooperator:",null,null,{"$f":"'Structure Sizing Data'!C3","v":0},null,null,null,"Storage Period:",{"$f":"'Structure Sizing Data'!J9","v":0},null,"days"]
[]
["Subtotal of I-IV from first page:",null,null,null,null,null,{"$f":"'Structure Sizing Data'!O62","v":0},null,"cubic feet"]
[]
["Enter any additional volume that will be utilized as storage in the new system:",null,null,null,null,null,null,null,null,null,null,"cubic feet"]
[]
["To determine total volume of waste and runoff to be stored in new structure:"]
[null,null,null,null,null,null,{"$f":"G4+K6","v":0},null,"cubic feet"]
[]
["Structure sizing by trial and error:"]
["Select side slopes for structure:",null,null,null,null,null,"to 1 (interior)"]
[]
["NOTE: 3:1 Side slopes are the minimum recommended interior side slopes for earthen structures."]
[]
["Trial #","Bottom Length",null,"Bottom Width",null,"Depth","Volume provided by this criteria in cubic feet"]
[]
[1,null,null,null,null,null,"",null,{"$f":"(B18*D18*F18)+((B18+D18)*F12*F18^2)+(1.333*F12^2*F18^3)","v":0},null,null,null,"this is",{"$f":"IF(I18>O18,\"greater than the\",\"less than the\")","v":"less than the"},{"$f":"G9","v":0},"cubic feet required"]
[]
[2,null,null,null,null,null,"",null,{"$f":"(B20*D20*F20)+((B20+D20)*F12*F20^2)+(1.333*F12^2*F20^3)","v":0},null,null,null,"this is",{"$f":"IF(I20>O20,\"greater than the\",\"less than the\")","v":"less than the"},{"$f":"G9","v":0},"cubic feet required"]
[]
[3,null,null,null,null,null,"",null,{"$f":"(B22*D22*F22)+((B22+D22)*F12*F22^2)+(1.333*F12^2*F22^3)","v":0},null,null,null,"this is",{"$f":"IF(I22>O22,\"greater than the\",\"less than the\")","v":"less than the"},{"$f":"G9","v":0},"cubic feet required"]
[]
[4,null,null,null,null,null,"",null,{"$f":"(B24*D24*F24)+((B24+D24)*F12*F24^2)+(1.333*F12^2*F24^3)","v":0},null,null,null,"this is",{"$f":"IF(I24>O24,\"greater than the\",\"less than the\")","v":"less than the"},{"$f":"G9","v":0},"cubic feet required"]
[]
["Note: The depth selected in this step is not the final depth of the structure.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["V. Direct Precipitation:"]
["Direct rainfall on the structure:",null,null,null,null,null,"feet",null,null,null,null,null,"Choose a successful Trial # (1-4) from above:"]
["   (less evaporation)"]
[]
["VI. Direct Contribution by 25-year, 24-hour storm:"]
["Direct rainfall on the structure:",null,null,null,null,{"$f":"'Structure Sizing Data'!O36/12","v":0},"feet"]
[]
["VII. Freeboard"]
[null,null,null,"Add:",null,null,"feet of freeboard"]
[]
["Total height needed =",null,null,null,null,{"$f":"IF(N29=1,F18+F29+F33+F36,IF(N29=2,F20+F29+F33+F36,IF(N29=3,F22+F29+F33+F36,IF(N29=4,F24+F29+F33+F36))))","v":false},null,"feet for the selected bottom dimensions of ",null,null,null,{"$f":"IF(N29=1,B18,IF(N29=2,B20,IF(N29=3,B22,IF(N29=4,B24))))","v":false},"feet long &",{"$f":"IF(N29=1,D18,IF(N29=2,D20,IF(N29=3,D22,IF(N29=4,D24))))","v":false},"feet wide"]
[]
["Final dimensions of the structure:",null,null,null,null,null,null,null,"Total Depth (ft.):",{"$f":"ROUNDUP(F38,1)","v":0},null,null,"Top Width (ft.):",{"$f":"N42+2*F12*J40","v":0},null,null,"Top Length (ft.):",{"$f":"R42+2*F12*J40","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bottom Width (ft.):",{"$f":"N38","v":false},null,null,"Bottom Length (ft.):",{"$f":"L38","v":false}]
[]
["Structure sized for:",null,null,{"$f":"G9","v":0},null,"cubic feet to provide",null,null,null,{"$f":"I2","v":0}," days of storage"]
[null," "]
[null,null,"Top Length (ft. )=",{"$f":"R40","v":0}]
[]
[null,null,"Bottom Length (ft.) =",{"$f":"R42","v":false}]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"F36","v":0},"ft. needed for freeboard"]
["",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":"F33","v":0},"ft. needed for direct 25 yr. storm"]
[null,null,null,null,null,null,null,"Top Width (ft.) =",{"$f":"N40","v":0}]
[]
[null,null,null,null,null,null,null,"Bottom Width (ft.) =",{"$f":"N42","v":false},null,null,null,null,null,{"$f":"F29","v":0},"ft. needed for direct rainfall"]
[]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N29=1,F18,IF(N29=2,F20,IF(N29=3,F22,IF(N29=4,F24))))","v":false},"ft. needed for waste & runoff"]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Volume of Structure = ",{"$f":"(I54*D48*J40)+((I54+D48)*F12*J40^2)+(1.333*F12^2*J40^3)","v":0},null,"cubic feet"]

{"sheet":"Tables","index":4,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,"SWCD's"]
[1]
[2,"Appomattox River SWCD"]
[3,"Big Walker SWCD"]
[4,"Blue Ridge SWCD"]
[5,"Clinch Valley SWCD"]
[6,"Colonial SWCD"]
[7,"Culpeper SWCD"]
[8,"Daniel Boone SWCD"]
[9,"Eastern Shore SWCD"]
[10,"Evergreen SWCD"]
[11,"Halifax SWCD"]
[12,"Hanover-Caroline SWCD"]
[13,"Headwaters SWCD"]
[14,"Henricropolis SWCD"]
[15,"Holston River SWCD"]
[16,"J.R. Horsley SWCD"]
[17,"James River SWCD"]
[18,"John Marshall SWCD"]
[19,"Lake Country SWCD"]
[20,"Lonesome Pine SWCD"]
[21,"Lord Fairfax SWCD"]
[22,"Loudoun SWCD"]
[23,"Monacan SWCD"]
[24,"Mountain SWCD"]
[25,"Mountain Castles SWCD"]
[26,"Natural Bridge SWCD"]
[27,"Natural Tunnel SWCD"]
[28,"New River SWCD"]
[29,"Northern Neck SWCD"]
[30,"Northern Virginia SWCD"]
[31,"Patrick SWCD"]
[32,"Peaks of Otter SWCD"]
[33,"Peanut SWCD"]
[34,"Peter Franscisco SWCD"]
[35,"Piedmont SWCD"]
[36,"Pittsylvania SWCD"]
[37,"Prince William SWCD"]
[38,"Robert E. Lee SWCD"]
[39,"Shenadoah Valley SWCD"]
[40,"Skyline SWCD"]
[41,"Southside SWCD"]
[42,"Tazewell SWCD"]
[43,"Thomas Jefferson SWCD"]
[44,"Three Rivers SWCD"]
[45,"Tidewater SWCD"]
[46,"Tri-County SWCD"]
[47,"Virginia Dare SWCD"]