{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Structure Sizing Data","Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"General information about this spreadsheet:"]
[]
["1.","These spreadsheets are intended to be used for beef waste only."]
[]
["2.","All areas highlighted in yellow on the spreadsheet are items that must be inputted."]
[]
["3.","All areas highlighted in blue on the spreadsheet are items that have been calculated."]
[]
["4.","The sizing calculations performed in this spreadsheet 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 area of "]
[null,"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."]
[null," "]
["12.","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."]

{"sheet":"Structure Sizing Data","index":1,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,1],[2,2,2,4],[2,5,2,6],[2,8,2,12],[2,13,2,14],[3,8,3,12],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,8,4,12],[4,13,4,14],[5,8,5,12],[6,0,6,1],[6,2,6,4],[6,5,6,6],[6,8,6,12],[6,13,6,14],[7,2,7,3],[7,8,7,12],[8,4,8,6],[8,11,8,14],[10,0,10,1],[10,3,10,4],[10,12,11,14],[11,0,11,7],[13,0,13,1],[13,3,13,4],[14,0,14,7],[14,12,14,14],[16,0,16,1],[16,3,16,4],[19,0,19,1],[19,3,19,4],[58,0,58,8],[17,0,17,7],[17,12,17,14],[19,12,19,14],[36,0,36,2],[21,0,21,11],[22,3,22,11],[27,0,27,11],[58,9,58,11],[52,0,52,1],[48,0,48,2],[49,1,49,11],[38,0,38,7],[41,0,41,7],[44,0,44,7]]}
["Virginia NRCS Beef Waste Structure Sizing Data Worksheet"]
[]
["Cooperator:",null,null,null,null,null,null,"Service Center:"]
[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,"Assisted By:"]
[]
["Tract Number:",null,null,null,null,null,null,"Field Number:"]
[]
[null,"Date:",{"$f":"TODAY()","v":"2014-04-11"},null,null,null,null,"Storage Period:",null,"days"]
[]
["Number of Cows:",null,null,"Average weight:",null,null,null,"% confinement:",null,"for",null,"days",{"$f":"IF(K11+K12=I9,\" \",\"Total Days Must = Storage Period!\")","v":" "}]
[null,null,null,null,null,null,null,null,null,"for",null,"days"]
[]
["Replacement Heifers:",null,null,"Average weight:",null,null,null,"% confinement:",null,"for",null,"days"]
[null,null,null,null,null,null,null,null,null,"for",null,"days"]
[]
["Calves:",null,null,"Average weight:",null,null,null,"% confinement:",null,"for",null,"days"]
[null,null,null,null,null,null,null,null,null,"for",null,"days"]
[]
["Other:",null,null,"Average weight:",null,null,null,"% confinement:",null,"for",null,"days"]
[]
["Enter bedding volume for the planned storage period here",null,null,null,null,null,null,null,null,null,null,null,"=",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,"Enter feed waste volume for the planned storage period here","=",null,"cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,"(this value should be obtained directly from cooperator when possible)"]
[]
["Drainage area to structure (paved area)",null,null,null,null,null,null,null,null,null,null,null,"=",null,"square feet"]
[]
[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,"Drainage area to structure (unpaved area)","=",null,"square feet"]
[]
[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,"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","1.0 cf/AU/day","X"," % confinement:",{"$f":"I11","v":0},"for",{"$f":"K11","v":0},"days","=",{"$f":"A38*C38*(I38/100)*K38","v":0},"cubic feet"]
[null,null,null,null,null,null,null,null,{"$f":"I12","v":0},"for",{"$f":"K12","v":0},"days","=",{"$f":"A38*C38*(I39/100)*K39","v":0},"cubic feet"]
[]
[{"$f":"C14","v":0},"Heifers   X",{"$f":"F14/1000","v":0},"animal units","X","1.0 cf/AU/day","X"," % confinement:",{"$f":"I14","v":0},"for",{"$f":"K14","v":0},"days","=",{"$f":"A41*C41*(I41/100)*K41","v":0},"cubic feet"]
[null,null,null,null,null,null,null,null,{"$f":"I15","v":0},"for",{"$f":"K15","v":0},"days","=",{"$f":"A41*C41*(I42/100)*K42","v":0},"cubic feet"]
[]
[{"$f":"C17","v":0},"Calves   X",{"$f":"F17/1000","v":0},"animal units","X","1.0 cf/AU/day","X"," % confinement:",{"$f":"I17","v":0},"for",{"$f":"K17","v":0},"days","=",{"$f":"A44*C44*(I44/100)*K44","v":0},"cubic feet"]
[null,null,null,null,null,null,null,null,{"$f":"I18","v":0},"for",{"$f":"K18","v":0},"days","=",{"$f":"A44*C44*(I45/100)*K45","v":0},"cubic feet"]
[]
[{"$f":"C20","v":0},"Other   X",{"$f":"F20/1000","v":0},"animal units","X","1.0 cf/AU/day","X"," % confinement:",{"$f":"I20","v":0},"for",{"$f":"K20","v":0},"days","=",{"$f":"A47*C47*(I47/100)*K47","v":0},"cubic feet"]
[]
["II. 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,"=",{"$f":"N22+N25","v":0},"cubic feet"]
[]
["III. Runoff:"]
["Paved area:",null,{"$f":"N28","v":0},"square feet","X",{"$f":"N30","v":0},"\" of runoff (less evaporation) for storage period",null,null,null,null,null,"=",{"$f":"C53*F53/12","v":0},"cubic feet"]
[]
[null,"Unpaved area:",{"$f":"N32","v":0},"square feet","X",{"$f":"N34","v":0},"\" of runoff (less evaporation) for storage period",null,null,null,null,null,"=",{"$f":"C55*F55/12","v":0},"cubic feet"]
[]
[null,"25 year storm:",{"$f":"N28+N32","v":0},"square feet","X",{"$f":"N36","v":0},"\" of rainfall depth",null,null,null,null,null,"=",{"$f":"C57*F57/12","v":0},"cubic feet"]
[]
[null,null,null,null,null,null,null,null,null,"Subtotal of I-III",null,null,"=",{"$f":"SUM(N38:N57)","v":0},"cubic feet"]

{"sheet":"Tables","index":2,"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"]