{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["T.O.C.","1. Soil Class (WSS)","2. Seepage","3. Evaporation","4. Storage","5. Capacity","6. Tips","1.1 Soil Class (GIS)","1.2 Soil Class (PDF)"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":0,"defined_names":7,"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":"T.O.C.","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1. Soil Class (WSS)","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["Soil Classification with the NRCS Web Soil Survey"]

{"sheet":"2. Seepage","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,0,11,1],[16,0,16,1],[22,0,22,1],[0,0,0,7],[9,0,9,1],[4,1,4,2],[5,1,5,2],[6,1,6,2],[20,0,20,1],[18,0,18,4],[15,0,15,1],[13,0,14,1],[13,2,14,4],[31,0,31,7],[25,0,25,7],[30,0,30,7],[24,0,24,7],[27,0,27,7],[28,0,28,7],[29,0,29,7],[26,0,26,7]]}
["Seepage Loss Calculations"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Classification","Seepage"]
["FILE NUMBER","xx-xxxxx",null,null,null,null,null,"User Input",null,"GW",0.2]
["REVIEWER ","Joe Agent",null,null,null,null,null,"Calculated value",null,"GP",0.2]
["DATE ","2000-01-01",null,null,null,null,null,"Formula Explanations ",null,"GM",0.2]
[null,null,null,null,null,null,null,null,null,"GC",0.2]
["INPUTS",null,null,null,null,null,null,null,null,"SW",0.2]
["Pond Surface Area (AC.)",null,5,"AC.",null,null,null,null,null,"SP",0.2]
[null,null,null,null,null,null,null,null,null,"SM",0.2]
["Pond Surface Area (SQ. FT.) ",null,{"$f":"C10*43560","v":217800},"SQ. FT.",null,null,null,null,null,"OL",0.02]
[null,null,null,null,null,null,null,null,null,"ML",0.02]
["I used the following method to obtain\n my Soil Classification information:",null,"NRCS Web Soil Survey",null,null,null,null,null,null,"SC",7.0000000000000001E-3]
[null,null,null,null,null,null,null,null,null,"CL",3.0000000000000001E-3]
["My Soil Classification is",null,"GP",null,null,null,null,null,null,"MH",2.9999999999999997E-4]
["Suggested Seepage Rate  (FT./DAY) ",null,{"$f":"VLOOKUP(C16,Table1[],2,FALSE)","v":0.2},"FT./DAY",null,null,null,null,null,"OH",2.9999999999999997E-4]
[null,null,null,null,null,null,null,null,null,"PT",2.9999999999999997E-4]
["Formula:  (Surface Area X Seepage Rate) X 7.48  = Gallons Per Day Loss ",null,null,null,null,null,null,null,null,"CH",2.9999999999999997E-4]
[null,null,null,null,null,null,null,null,null,"Lined",0]
["Convert to GPD ",null,{"$f":"(C17*C12)*7.48","v":325828.80000000005},"GPD",null,null,null,null,null,"GrndWtr",0]
[]
["Total Seepage Loss (AFA)",null,{"$f":"C21*365/325850","v":364.97625287709076},"AFA"]
[null,null,null,null,null,null,null,null,null,"Class Method"]
["Suggested Seepage Rates for Different Soil Types: ",null,null,null,null,null,null,null,null,"NRCS Web Soil Survey"]
["GW, GP, GM, GC, SW, SP and SM (silty sand, sand silt mixtures and gravel mixtures) = 0.2 ft per day",null,null,null,null,null,null,null,null,"PondSoils Layer in GIS"]
["OL and ML (inorganic silts - very fine sands, silty, or clayey fine sands) = 0.02 ft per day",null,null,null,null,null,null,null,null,"Published Soil Surveys"]
["SC (clayey sands, sand clay mixtures) = 0.007 ft per day"]
["CL (Low to medium plasticity clays) = 0.003 ft per day"]
["MH, OH, PT and CH (high plasticity clays) = 0.0003 ft per day"]
["LINED PONDS (liners can be chemical, fabric, or bentonite) = 0 ft per day"]
["Ponds Intercepting Groundwater (excavated ponds filled by ground water) = 0 ft per day"]

{"sheet":"3. Evaporation","index":3,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,9],[45,0,45,9],[41,0,41,9],[44,1,44,8],[7,0,7,1],[8,0,8,1],[9,0,9,1],[11,0,12,1],[39,2,39,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
["Evaporation Loss Calculations"]
[]
[]
["FILE NUMBER",{"$f":"'2. Seepage'!B5:C5","v":"xx-xxxxx"}]
["REVIEWER ",{"$f":"'2. Seepage'!B6:C6","v":"Joe Agent"}]
["DATE ",{"$f":"'2. Seepage'!B7:C7","v":"2000-01-01"}]
[]
["User Input"]
["Calculated value"]
["Formula Explanations "]
[]
["The acronyms used on the Kimberly Research Center website are defined below:"]
[]
["P = Precipitation"]
["ET= Evapotranspiration"]
["Pd = Precipitation deficit"]
["Pd  =ET-P"]
[]
[]
[]
[]
["Found at:","http://data.kimberly.uidaho.edu/ETIdaho/"]
[]
[null,"Precipitation Deficit"]
[null,"Station:","Twin Falls 2 NNE (NWS -- 109294)"]
[null,"Month","mm/day¹","Days per month","mm/Month"]
[null,"Jan",-1.34,31,{"$f":"IF(C27*D27>0,C27*D27,0)","v":0}]
[null,"Feb",-0.72,28,{"$f":"IF(C28*D28>0,C28*D28,0)","v":0}]
[null,"March",-0.28999999999999998,31,0]
[null,"April",1.0900000000000001,30,32.700000000000003]
[null,"May",1.77,31,54.87]
[null,"June",3.33,30,99.9]
[null,"July",4.41,31,136.71]
[null,"August",3.81,31,118.11]
[null,"September",2.2799999999999998,30,68.399999999999991]
[null,"October",0.89,31,27.59]
[null,"November",-1.27,30,0]
[null,"December",-1.76,31,0]
[]
[null,null,"Total mm/year =",null,{"$f":"SUM(E27:E38)","v":538.28}]
[]
["[(mm/yr)  ÷ (convert to feet) ] X (Surface area of pond, in acres) = Evaporation Loss in Acre Feet"]
["(",{"$f":"E40","v":538.28},"÷",304.8,")   X",{"$f":"'2. Seepage'!C10","v":5},"=",{"$f":"(B43/D43)*F43","v":8.8300524934383198},"AFA"]
[]
[null,"Surface Area of Pond is automatically carried over from the Seepage Loss Sheet. "]
["Example Data:"]

{"sheet":"4. Storage","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,9],[20,2,20,8],[18,2,18,8],[19,2,19,8],[16,2,16,8],[17,2,17,8],[14,8,14,9],[13,2,13,8],[10,2,10,8],[8,2,8,8],[11,2,11,8],[12,2,12,8],[15,2,15,8],[6,2,6,8],[7,2,7,8]]}
["Total Storage Calculations"]
["FILE NUMBER",{"$f":"'2. Seepage'!B5:C5","v":"xx-xxxxx"},null,null,null,null,null,null,"User Input"]
["REVIEWER ",{"$f":"'2. Seepage'!B6:C6","v":"Joe Agent"},null,null,null,null,null,null,"Calculated value"]
["DATE ",{"$f":"'2. Seepage'!B7:C7","v":"2000-01-01"},null,null,null,null,null,null,"Formula Explanations "]
[]
[]
["Surface Area               (AC.)",{"$f":"'2. Seepage'!C10","v":5},"\"Surface Area\" is automatically carried over from the \"Seepage Loss\" sheet."]
["Average Pond Depth                      (FT.)",6.8,"\"Average Pond Depth\" depicts the actual depth of the pond either measured or estimated.  Note:  If you know the maximum depth and not the average depth, the Field Examiner's Handbook suggests multiplying the maximum depth by 0.4 to get the average depth, or you can use any method that seems reasonable to attain average depth.  "]
["Pond Capacity               (AF)",{"$f":"B8*B7","v":34},"Pond Capacity is calculated by multiplying the Pond Surface Area by the Average Pond Depth.  If you know the capacity, divide the capacity by surface area and enter the average pond depth in the space above.  \nNote: If pond capacity is determined using a method shown on the \"Pond Capacity\" sheet, the user may need to modify the value of \"Pond Capacity\" (cell B9) manually.  Note that if the value is modified manually, the formula will be altered for future use."]
[]
["Multiple Fill Volume Above Initial Fill to Fulfill From Storage Needs- \"Multiple Fills\"                                     (AF)",5,"The \"Multiple Fill Volume Above Initial Fill\" is  the acre-feet of water required to meet a from storage component if the from storage component exceeds a one time fill.  This section should not include the amount of water needed to fill the pond initially or the amount of water needed to maintain the pond level due to evaporation or seepage.  For example: if a pond has a capacity of 5 acre feet and 2.5 acre feet of seepage and evaporation, but the pond is used for irrigation that requires 10 acre feet of from storage for the irrigation use, then you would insert 5 acre feet into this location (10 acre feet needed - 5 acre feet from the initial fill = 5 acre feet of additional storage needed).\nNote: You must have a \"From Storage\" component exceeding the initial fill on the permit to include a volume in this space. "]
["Estimated Seepage Loss (AF)",{"$f":"'2. Seepage'!C23","v":364.97625287709076},"The \"Estimated Seepage Loss\"  is automatically carried over from the \"Seepage Loss\" sheet."]
["Estimated Evaporation Loss                                       (AF)",{"$f":"'3. Evaporation'!H43","v":8.8300524934383198},"The \"Estimated Evaporation Loss\" is automatically carried over from the \"Evaporation Loss\" sheet."]
["Total Volume Required                      (AF)",{"$f":"B9+B11+B12+B13","v":412.80630537052906},"The \"Total Volume Required\" is calculated by adding the Pond Capacity, Multiple Fills, Seepage Loss, and Evaporation Loss amounts to determine the total amount of storage required. "]
[]
["Flow Rate into Pond (CFS)",1,"The \"Flow Rate into Pond\" depicts the actual flow, either measured or estimated, into the pond.  For offstream facilities, this will be equivalent to \"diversion to storage\" rate. "]
["Highest Daily Evaporation Rate From Evaporation Tab.                                 (mm/Day)",{"$f":"MAX('3. Evaporation'!C27:C38)","v":4.41},"This number is carried over from the \"Evaporation Loss\" sheet. It is the highest recorded number in the \"Precipitation Deficit Table\"."]
["Required Daily Maintenance Volume                  (AF/Day)",{"$f":"((B17/304.8)*B7)+(B12/365)","v":1.0722774590743291},"\"Required Daily Maintenance Volume\" is the maximum volume of water needed on any given day during the year to maintain pond volume. It is calculated by adding the highest daily evaporation loss to the average daily seepage loss in acre feet.  The average daily seepage loss is calculated by dividing the \"Estimated Seepage Loss\" by 365 days.  This is acceptable, since the seepage rate shouldn't vary throughout the season unless the pond completely freezes over during the winter months. The highest daily evaporation loss is calculated by dividing the Highest Daily Evaporation Rate by the 304.8 conversion factor and multiplying this number by the pond surface area to attain a combined daily acre feet requirement.  "]
["Minimum Maintenance Flow                 (CFS)",{"$f":"B18/1.9835","v":0.54059866855272454},"The \"Minimum Maintenance Flow\" is the minimum amount of flow required to maintain the level of the pond.  This number is determined by dividing the \"Maximum Required Daily Maintenance Volume\" by 1.9835.  This flow can be used to determine if the flow rate into the pond is adequate to maintain the pond level.  "]
["Days Required to Fill the Pond",{"$f":"B9/((B16-B19)*1.9835)","v":37.312509812872818},"The \"Days Required to Fill the Pond\" is calculated by dividing the \"Pond Capacity\" by the \"Flow Rate\" minus \"Minimum Maintenance Flow\" multiplied by 1.9835.  This section will assist you in determining if the flow rate being diverted to the pond is adequate to fill the pond while maintaining  the pond level.  The length of time to fill the pond will help determine if the flow rate is adequate for the size of pond being proposed.    If this number is approximately 6 months (180 days) or more, the reviewer should have a discussion with the applicant to make sure he/she understands that it will take a significant length of time to fill the pond.  "]
["Days Required to Fill the Pond at 13,000 Gallons per Day",{"$f":"(B9*325850)/(13000-(B18*325850))","v":-32.9335522463861},"Some water users may want to fill a pond under the 13,000 gallons per day domestic exemption.  The \"Days Required to Fill the Pond at 13,000 Gallons per Day\" is calculated by converting the \"Pond Capacity\" and the \"Required Daily Maintenance Volume\" to gallons.  The \"Pond Capacity\" is then divided by 13,000 gallons minus the \"Required Daily Maintenance Volume\" in gallons to determine the number of days to fill pond.   If this number is approximately 6 months (180 days) or more, the reviewer should have a discussion with the applicant to make sure he/she understands that it will take a significant length of time to fill the pond.    \nNegative values indicate that the supply of 13,000 gallons per day is not enough volume to overcome the required daily maintenance volume; the pond will never fill."]

{"sheet":"5. Capacity","index":5,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Pond Capacity Determination"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The surface area of a freeform polygons should be measured using aerial photography and ArcGIS."]

{"sheet":"6. Tips","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Helpful Tips for Determining Pond Volumes"]

{"sheet":"1.1 Soil Class (GIS)","index":7,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11]]}
["Soil Classification with ArcMap"]
["Alternative to Soil Classification with the NRCS Web Soil Survey"]

{"sheet":"1.2 Soil Class (PDF)","index":8,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[12,0,12,6],[18,0,18,6],[26,0,26,6],[24,0,24,2],[24,3,24,6],[27,0,27,6],[31,0,31,6],[29,0,29,6],[30,0,30,6],[23,0,23,6],[28,0,28,6],[1,0,1,6],[32,0,32,6],[36,0,36,3],[0,0,0,6],[22,3,22,4],[22,5,22,6],[5,1,5,2],[6,1,6,2],[7,1,7,2],[16,0,16,2],[13,0,13,6],[14,0,14,6],[16,3,16,6],[19,0,19,6],[20,0,20,6],[22,0,22,2]]}
["Soil Classification with Published Soil Surveys"]
["Alternative to Soil Classification with the NRCS Web Soil Survey"]
[]
[]
[]
["FILE NUMBER","xx-xxxxx",null,null,null,null,"User Input"]
["REVIEWER ","Joe Agent",null,null,null,null,"Calculated value"]
["DATE ","2000-01-01",null,null,null,null,"Formula Explanations "]
[]
[]
["County:","Ada",", Idaho"]
[]
["1. Navigate to the NRCS Soil Survey Website"]
["NRCS Published Soil Surveys for Idaho found at: "]
["http://www.nrcs.usda.gov/wps/portal/nrcs/surveylist/soils/survey/state/?stateId=ID"]
[]
["Reviewer used the Survey entitled:",null,null,"Ada County Area"]
[]
["2. Use GIS and the Soil Survey to determine Soil Type"]
["Utilize ArcGIS to Obtain the Soil Symbol (may be a number or abbreviated name)"]
["The shapefile SSURGOOnePlan is found at X:\\Spatial\\Soils\\SSURGOOnePlan\\soils.shp"]
[]
["Soil Symbol (GIS field MUSYM):",null,null,116,null,"What if my Soil Symbol is 999?* (see box)"]
["Find the name of the soil in the Soil Legend.  \nThe Soil Legend is typically the last bookmark in the Soil Survey report."]
["The Full Name of This Soil is: ",null,null,"Payette-Quincy complex, 15 to 30 percent slopes"]
[]
["3. Use the Soil Survey to determine the USCS Classification"]
["Within the county NRCS Soil Survey report, click the bookmarked link to \"Tables.\" "]
["Scroll down until you reach a table called \"Engineering Properties and Classifications\" or \n\"Engineering Index Properties.\"  The table is ordered by soil symbol and the soil name. "]
["Scroll down until you reach the soil which matches your soil symbol and name. "]
["The table lists the USCS Classification for each depth in the soil profile."]
["Be sure to use the predominant soil classification for the pond depth where seepage occurs."]
["If the pond has a greater depth than the soil survey, use data from the lowest depth reported."]
[]
["Pond Depth:",4,"feet","=",{"$f":"B35*12","v":48},"inches"]
[]
["The Soil Survey states the soil USCS Classification at ",null,null,null,{"$f":"E35","v":48},"inches is","SM"]