{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Use of Tool","Field Data Sheet","Nutrient Management","Water Management","CONS","CALCS","Soils and Landform","IRRIG","NVALUES","CROP N UPTAKE","Assessment Report"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":0,"defined_names":18,"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":"Use of Tool","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Field Data Sheet","index":1,"n_rows":124,"n_cols":8,"rows_kept":124,"cut":false,"hidden":false,"merged":[[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[98,3,98,4],[99,3,99,4],[103,0,103,1],[92,0,92,7],[94,0,94,1],[95,0,95,1],[93,0,93,1],[93,6,93,7],[123,0,125,6],[41,0,43,0],[41,1,41,6],[42,7,43,7],[45,0,47,0],[45,1,45,6],[46,7,47,7],[104,3,104,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[101,3,101,4],[93,3,93,4],[102,3,102,4],[103,3,103,4],[104,0,104,1],[105,0,105,1],[106,0,106,1],[65,5,66,5],[65,6,66,6],[65,7,66,7],[67,0,69,0],[67,1,67,6],[68,7,69,7],[65,1,66,1],[65,2,66,2],[65,3,66,3],[65,4,66,4],[63,1,64,1],[63,2,64,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[61,1,62,1],[61,2,62,2],[61,3,62,3],[61,4,62,4],[54,0,56,0],[54,1,54,6],[61,5,62,5],[61,6,62,6],[55,7,56,7],[58,0,60,0],[58,1,58,6],[59,7,60,7],[37,0,39,0],[37,1,37,6],[38,7,39,7],[49,0,51,0],[49,1,49,6],[50,7,51,7],[61,7,62,7],[33,0,35,0],[33,1,33,6],[34,7,35,7],[19,4,21,4],[19,5,21,5],[19,6,21,6],[19,7,21,7],[16,1,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[29,0,31,0],[29,1,29,6],[30,7,31,7],[22,5,24,5],[22,6,24,6],[22,7,24,7],[25,0,27,0],[25,1,25,6],[26,7,27,7],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[75,4,76,4],[116,1,117,5],[110,7,112,7],[113,6,115,6],[113,7,115,7],[13,0,15,0],[13,1,13,6],[14,7,15,7],[16,5,18,5],[16,6,18,6],[70,5,71,5],[70,6,71,6],[70,7,71,7],[72,0,74,0],[72,1,72,6],[73,7,74,7],[70,1,71,1],[70,2,71,2],[70,3,71,3],[70,4,71,4],[16,7,18,7],[19,1,21,1],[19,2,21,2],[19,3,21,3],[116,6,117,6],[116,7,117,7],[118,0,120,0],[118,1,118,6],[119,7,120,7],[109,1,109,6],[113,1,115,5],[88,0,90,0],[88,1,88,6],[89,7,90,7],[97,0,97,1],[98,0,98,1],[99,0,99,1],[113,0,114,0],[94,6,95,7],[97,6,98,7],[100,6,101,7],[103,6,104,7],[106,6,107,7],[96,0,96,1],[100,3,100,4],[100,0,100,1],[101,0,101,1],[102,0,102,1],[83,1,83,6],[82,0,82,7],[80,6,81,6],[80,7,81,7],[84,7,86,7],[11,0,11,7],[80,2,81,2],[80,3,81,3],[80,4,81,4],[75,5,76,5],[75,6,76,6],[65,0,66,0],[70,0,71,0],[53,0,53,5],[80,0,81,0],[12,0,12,7],[80,5,81,5],[75,7,76,7],[77,0,79,0],[77,1,77,6],[78,7,79,7],[75,1,76,1],[75,2,76,2],[75,3,76,3],[0,0,0,7],[1,0,1,7],[2,3,2,4],[10,0,10,7],[4,6,4,7],[6,6,6,7],[4,1,4,3],[5,1,5,3],[6,1,6,3],[2,6,2,7],[7,1,7,3],[2,0,2,1]]}
["FIELD DATA SHEET"]
["                       Idaho Nutrient Transport Risk Assessment                                "]
["Natural Resource Conservation Service",null,null,"Water Quality Assessment Tool",null,null,"Version: August 2012"]
[" "]
["   Landowner:",null,null,null,null,"Date:"]
["        Planner:",null,null,null,null,null,null," "]
["Rotation",null,null,null,null,"Field Office:"]
["Critical Crop*"]
[null,null,null,null,null,null,"Tract Number:"]
[]
["\nThe factors outlined on the following pages provide a means to estimate the potential risk of off-site transport of phophorus and nitrogen. Answers to some of the factors cannot be determined in the field. Additional data will need to be obtained from other assessment tools and through calculations provided in the accompanying INTRA automated spreadsheet."]
["*Critical crop is the crop in the rotation which is most likely to have off-site transport of nutrients (either off-field or below the root zone)."]
["Idaho Nutrient Transport Risk Assessment - Field Data Sheet        Idaho NRCS, Version: July 2006"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low ","Medium","High ","Very High","Critical"]
[null,0,1,2,4,8,10]
["Soil Test P (ppm)","< 8","9 - 15","16 - 39","40 - 79 ","80 - 159\n(or no soil test)","> 160"]
["Olsen Method (Bicarbonate)"]
["0 – 12”"]
["Soil Test P (ppm)","< 10","10 - 20","21 - 69","70 - 139 ","140 - 279\n(or no soil test)","> 280"]
["Bray Method"]
["0 – 12”"]
["Soil Test P (ppm)","< 1.0","1.0 – 2.0","2.1 – 6.9","7.0 - 13.9","14.0 - 27.9\n(or no soil test)","> 28.0"]
["Morgan Method (Sodium Acetate)"]
["0 – 12”"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,0.75,1.5,3,6]
["Phosphorus Fertilizer Application Rate (lbs/ac P2O5)",0,"< 60","60 - 150","151- 300","> 300"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,0.5,1,2,4,10]
["Phosphorus Fertilizer Application Method ","None applied","Placed with planter (banded) or injected > 2\" or plowed","Incorporated > 3\" by disking or chiseling, etc.","Chemigated, or incorporated < 3\" by harrowing, etc.","Surface applied, no incorporation (includes application on perennial crop)","Surface applied on a field with surface runoff (natural or from irrigation) and no incorporation"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1,2,4,8," "]
["Organic Phosphorus Application Rate (lbs/ac P2O5)",0,"< 40","40 - 100","101 - 200","> 200\n(or unknown for any reason)"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,0.75,1.5,3,6,10]
["Organic Phosphorus Application Method","None applied","Injected > 2\" or plowed","Incorporated > 3\" by disking or chiseling, etc.","Chemigated, or incorporated < 3\" by harrowing, etc.","Surface applied, no incorporation (includes application on perennial crop)","Surface applied on a field with surface runoff (natural or from irrigation) and no incorporation."]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1,2,4,8," "]
["Soil Test N (ppm)\n0 - 12\" Soil Layer\n","< 5","5 - 10","10 - 20","20 - 30","> 30"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1,2,4,8," "]
["Soil Test N (ppm)\n12 - 24\" Soil Layer\n","< 2","2 - 5","5 - 10","10 - 15","> 15"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1,2,4,8," "]
["Nitrogen Application Rate (% of Crop Requirement)","< 40","40 - 60","60 - 100","100 - 120","> 120"]
["Deterimine amount of nitrogen applied, then determine % of crop requirement using estimator tool in spreadsheet."]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,0.75,1.5,3,6,10]
["Nitrogen Fertilizer Application Method (prior to critical runoff period)","None applied","Placed with planter (banded) or injected > 2\" or plowed","Incorporated > 3\" by disking or chiseling, etc.","Chemigated, or incorporated < 3\" by harrowing, etc.","Surface applied, no incorporation (includes application on perennial crop)","Surface applied on a field with surface runoff (natural or from irrigation) and no incorporation"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,0.5,1,2,4," "]
["Runoff  Index","No runoff occurs","----- ","Water runs off field less than 50% of set time","-----","Water runs off field 50% or more of set time"]
["(Surface Irrigated)"]
["Runoff  Index ","No runoff occurs","Water moves across the surface but not off the field","-----","Runoff leaves the field","----"]
["(Sprinkler Irrigated)"]
["Runoff  Class ","Negligible","Very Low or Low","Medium","High","Very High"]
[]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,-1,-2,-4,-8," "]
["Runoff BMPs","No conservation practices","One or two on-field practices that reduce runoff","Multiple conservation practices that reduce runoff or trap nutrients","Multiple conservation practices that reduce runoff and trap/filter pollutants","Conservation practice(s) that eliminates runoff"]
[]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1,2,4,8," "]
["Average Total Soil Erosion due to Water and Wind","< 1 ton/acre","1 - 5 tons/acre","5 - 10 tons/acre","10 - 15 tons/acre","> 15 tons/acre"," "]
["(tons/ac/year)"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1,2,4,8," "]
["Distance to Surface Water","> 2640 feet","2640 - 1320 feet\nor adequately buffered","1319 - 600 feet","599 - 200 feet","< 200 feet"]
[null,"( > 0.5 mile)\nor no runoff to waterbody"]
["     Determine amount of nitrogen applied, then determine % of crop requirement using estimator tool in spreadsheet."]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
["Irrigated>",0,0.75,1.5,3,6," "]
["Not Irrigated>",0,1,2,4,8]
["Nitrogen Application Timing","None applied","Nitrogen applied in several applications during the primary growing season, the first application no greater than 30 days of start of primary growing season","Majority of nitrogen is applied within 30 days of, or during, the primary growing season. Nitrogen applied outside this time frame is less than 50 lbs and is applied with a nitrification inhibitor or when soil temperatures are less than 50 deg. F.","Nitrogen is applied as a single application within 90 days of the primary growing season OR a split application is made which does not meet the conditions described for LOW or MEDIUM.","Nitrogen is applied as a single application more than 90 days prior to the primary growing season."]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1.5,3,6,12," "]
["Irrigation Index","> 79 ","70 - 79","60 - 69","50-59","< 50"]
["This index requires information on the irrigation system type, water measurement and distribution, irrigation scheduling, SCI, and whether pre or post season irrigation is used. Circle the most appropriate selection in each category."]
["Irrigation System",null,null,"Irrigation Scheduling",null,null,"Water Control and Measurement"]
["Surface - Graded Border",null,null,"Use a set irrigation schedule each year",null,null,"Poor - no water measurement AND poor control of water due to inadequate water conrtol structures throughout the conveyance system"]
["Surface - Level Border (Basin)",null,null,"Irrigation based on visual observation of crop stress"]
["Surface - Graded Furrow or Corrugates ",null,null,"Soil moisture by NRCS feel method"]
["Surface - Surge",null,null,"Check book scheduling, irrigation scheduler, etc.",null,null,"Fair - manually recorded water measurement at delivery point to farm AND poor control of water due to inadequate control structures throughout the conveyance system"]
["Surface - Controlled with contour ditch, turnouts, canvas dams, etc.",null,null,"Irrigation scheduling via pan evaporation of atmometer in field"]
["Surface - Uncontrolled (wild flood, no control with turnouts, etc.)",null,null,"Irrigation scheduling via regional weather network (e.g. AgriMet)"]
["Sprinkler - Big gun or boom",null,null,"Soil moisture monitoring using Gypsum blocks, moisture probes, etc.",null,null,"Average - manual recordings somewhere in the system OR  good control of water with effective water control structures throughout the conveyance system"]
["Sprinkler - Periodic Move (hand line or wheel line)",null,null,"Continuous measurement of soil moisture, water applied, and ET"]
["Sprinkler - Solid set ",null,null,"Pre/Post Irrigation"]
["Sprinkler - Center pivot",null,null,"Pre- and post-season irrigations based on standard run time",null,null,"Good - manual recordings somewhere in the system AND  good control of water with effective water control structures throughout the conveyance system"]
["Sprinkler - Lateral/linear move",null,null,"Pre-season OR post-season irrigations based on standard run time"]
["Micro Irrigation - Sprays and Bubblers",null,null,"Pre- and post-season irrigations based on soil moisture assessment"]
["Micro Irrigation - Tubing or tape w/ integrated or punched-in emitters",null,null,"Pre- OR post-season irrigations based on soil moisture assessment",null,null,"Excellent - Continuous recording water measurement device(s) AND good control of water with effective water control structures throughout the conveyance system"]
[null,null,null,"No irrigation outside crop growing season"]
[" "]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
["Irrigated>",0,0.5,1,2,4," "]
["Not Irrigated>",0,1.5,3,6,12]
["Leaching Index","Values are calculated from database information in the spreadsheet"]
[]
["(Irrigated)"]
["Leaching Index","Values are calculated from database information in the spreadsheet"]
["(Not Irrigated)"]
["Site Characteristic","Rating and Point Value",null,null,null,null,null,"SELECTED RATING"]
[null,"Very Low","Low","Medium","High ","Very High","Critical "]
[null,0,1,2,4,8," "]
["Water Table/Geologic Feature Depth and Soil Type","Water table or geologic feature > 5 feet from surface, Hydrologic Group D","Water table or geologic feature > 5 feet from surface, Hydrologic Group C","Water table or geologic feature > 5 feet from surface, Hydrologic Groups A, B","Water table or geologic feature < 5 feet to surface, Hydrologic Groups C, D","Water table or geologic feature < 5 feet to surface, Hydrologic Groups A, B"]
[]
["Collect the information on this data sheet in the field and running additional tools (like RUSLE2 and WEPS), then use the INTRA automated spreadsheet to calculate the surface and ground water quality risks associated with current management and site characteristics."]

{"sheet":"Nutrient Management","index":2,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,0,51,4],[10,0,10,1],[36,0,36,1],[9,2,9,4],[9,0,9,1],[14,3,14,4],[18,3,18,4],[13,3,13,4],[17,3,17,4],[25,3,25,4],[47,3,47,4],[40,3,40,4],[43,3,43,4],[44,3,44,4],[48,3,48,4],[1,0,2,4],[11,0,11,4],[37,0,37,4],[22,3,22,4],[39,3,39,4],[21,3,21,4],[26,3,26,4],[29,0,29,1],[30,0,30,4],[32,3,32,4],[31,3,31,4],[34,3,34,4]]}
["SOIL TEST P",null,null,null,null,null,null,null,null,null,null," "," ",null,null,null,null,0]
["Determine the risk associated with amount of nutrients currently in the soil. Plant available phosphorus in soils is estimated with a soil analysis. Select ONLY ONE of the soil P test methods used below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,1,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," "]
[]
["Soil Test P Result:   "]
["PHOSPHORUS APPLICATION"]
["The rates and methods of commercial phosphorus fertilizer and manure application can greatly impact the risk of off-site transport. Evaluate each of the four factors below."]
[]
[null,null,null,"Phosphorus Fertilizer Application Rate:"]
[null,null," "]
[]
[]
[null,null,null,"Phosphorus Fertilizer Application Method:"]
[]
[]
[]
[null,null,null,"Manure - Phosphorus Application Rate:"]
[]
[]
[]
[null,null,null,"Manure - Phosphorus Application Method:"]
[]
[]
[]
["Soil Test Nitrogen"]
["Determine the risk associated with the amount of nitrate and ammonium presently in the soil. Risks to both surface water and ground water increase as soil N levels rise, especially when post harvest samples show residual N after crop production for the year."]
[null,null,null,"Soil Test Nitrogen Result:"]
[null,null,"0-12\""]
[]
[null,null,"12-24\""]
[]
["NITROGEN APPLICATION"]
["The rate, timing, and method of nitrogen fertilizer application can have a great impact on potential for off-site transport. Evaluate the following three factors."]
[]
[null,null,null,"Nitrogen Fertilizer Application Rate:"]
[]
[]
[]
[null,null,null,"Nitrogen Fertilizer Application Timing:"]
[]
[]
[]
[null,null,null,"Nitrogen Fertilizer Method:"]
[]
[]
[]
["When you are completed with this section, proceed to the WATER MANAGEMENT Worksheet. Otherwise, go back and evaluate any missing factors."]

{"sheet":"Water Management","index":3,"n_rows":252,"n_cols":23,"rows_kept":252,"cut":false,"hidden":false,"merged":[[28,0,28,4],[20,0,20,1],[24,0,24,2],[34,0,34,4],[41,0,43,4],[30,0,30,4],[38,0,38,4],[1,0,2,4],[17,0,18,4],[22,0,22,4],[26,0,26,4],[9,2,9,3],[12,0,12,4],[11,0,11,4],[14,3,14,4],[4,0,4,2],[6,2,6,3]]}
["RUNOFF CLASS AND IRRIGATION RUNOFF INDEX",null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(A23=\"\",\"\",VLOOKUP($A23,IRRIG!$C$88:$D$100,2,FALSE))","v":""}]
["The Runoff Class and Irrigation Runoff Index determine the risk of soluble nutrients leaving the site in runoff from storm events and from application of irrigation water. The runoff risk for each is calculated differently. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A27=\"\",\"\",VLOOKUP($A27,IRRIG!$C$105:$D$109,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A31=\"\",\"\",VLOOKUP($A31,IRRIG!$C$48:$D$55,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",VLOOKUP($A35,IRRIG!$C$71:$D$81,2,FALSE))","v":""}]
["If irrigation is used, select the appropriate button to the right, and then proceed to Runoff Class. If no irrigation is used, skip and go to Runoff Class (below).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A39=\"\",\"\",VLOOKUP($A39,IRRIG!$C$58:$D$62,2,FALSE))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplicative Irrigation Index"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,{"$f":"W1*W2*W3*W4*W5","v":{"$error":"#VALUE!"}}]
[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,"Winter Ppt"]
["RUNOFF MANAGEMENT USING CONSERVATION PRACTICES",null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP($A43,IRRIG!$J$4:$O$156,6,FALSE))","v":""}]
["Runoff conservation practices include any practice which serves to reduce runoff and the movement of soil, thereby reducing the potential for soluble phosphorus and nitrogen, and sediment attached phophorus loss. Runoff conservation practices can include on-field practices like residue management, contour farming, and irrigation water management, and off-field practices like sediment basins, filter strips, and buffers."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrologic Group A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP($A43,IRRIG!$J$4:$O$156,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrologic Group B"]
["IRRIGATION INDEX (For Deep Percolation)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poor - no water measurement AND poor control of water ",null,null,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP($A43,IRRIG!$J$4:$O$156,3,FALSE))","v":""}]
["Irrigation water management has a direct impact on the downward movement of nutrients in the soil. The following factors will help determine whether irrigation water management is adequate, or if improvements need to be made. For each factor, select the appropriate choice in the drop-down list in the blue-shaded boxes. If no irrigation is used, check the box below and select the \"Done with Water Management\" button below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fair - manually recorded water measurement at delivery point to farm AND poor control of water ",null,null,null,null,"Hydrologic Group C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average - manual recordings somewhere in the system OR good control of water ",null,null,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP($A43,IRRIG!$J$4:$O$156,4,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Good - manual recordings somewhere in the system AND good control of water ",null,null,null,null,"Hydrologic Group D"]
["IRRIGATION SYSTEM TYPE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excellent - continuous recording water measurment device(s) AND good control of water ",null,null,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP($A43,IRRIG!$J$4:$O$156,5,FALSE))","v":""}]
[]
[""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Graded Border"]
["WATER CONTROL AND MEASUREMENT:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Level Border (Basin)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Guide Border"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Border - Contour Level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Border - Border Ditch"]
["SOIL MOISTURE  MONITORING AND IRRIGATION SCHEDULING:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Level Furrow (Basin with furrows or corrugations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Graded Furrow"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Contour Furrow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Corrugations"]
["SOIL CONDITION INDEX:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Surge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Controlled with contour ditch, turnouts, canvas dams, etc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface - Uncontrolled (wild flood, no control with turnouts, etc.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subirrigation (typically with a surface system to apply water)"]
["PRE AND POST SEASON IRRIGATION:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Big gun or boom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Hand line or wheel line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Solid set (above canopy)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Solid set (below canopy)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Center pivot, high pressure"]
["When you have completed all the factors above, select the DONE WITH WATER MANAGEMENT button below to complete final water management calculations. Then proceed to SOILS AND LANDFORM worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Center pivot - low pressure improved"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Center pivot, LEPA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Center pivot - LESA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Center pivot, LPIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Center pivot - MESA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Variable rate application (precision farming technique)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Lateral/linear move"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprinkler - Lateral/linear move with LEPA, LESA, LPIC, MESA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Micro Irrigation - Point source (emitters punched into hose, tubing, etc.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Micro Irrigation - Sprays"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Micro Irrigation - Continuous tape"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Micro Irrigation - SDI (subsurface drip)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No flow measurement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow measurement - whole farm, manually recorded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow measurement - whole farm, automatically recorded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow measurement - whole farm plus each field, manually recorded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow measurement - whole farm plus each field, automatically recorded"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use a set irrigation schedule each year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigation based on visual observation of crop stress"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil moisture by NRCS feel method"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check book scheduling, irrigation scheduler, etc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigation scheduling via pan eveporation of atmometer in field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigation scheduling via regional weather network (e.g. AgriMet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil moisture monitoring using Gypsum blocks, moisture probes, etc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continuous measurement of soil moisture, water applied, and ET"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre- and post-season irrigations based on standard run time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-season OR post-season irrigations based on standard run time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre- and post-season irrigations based on soil moisture assessment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre- OR post-season irrigations based on soil moisture assessment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No irrigation outside crop growing season"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Little or no control of flow to farm. Very poor diversion facilitities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Can control flow rate to farm, but on-farm delivery system inadequate  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow rates to field controlled, but flow rates to sets poorly controlled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All flow rates to each set are adequately controlled"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI less than 0.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.1 to 0.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.2 to 0.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.3 to 0.4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.4 to 0.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.5 to 0.6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.6 to 0.7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.7 to 0.8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.8 to 0.9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = 0.9 to 1.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCI = Greater than 1.0"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aberdeen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"American Falls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anderson Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arbon 2 NW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arco 3 SW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arrowrock Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ashton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avery Ranger Sta 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avery Ranger Sta 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bayview Model Basin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blackfoot 2 SSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bliss 4 NW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boise 7 N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boise Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boise Lucky Peak Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonners Ferry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brownlee Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruneau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buhl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burley Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cabinet Gorge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caldwell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambridge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cascade 1 NW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Castleford 2 N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Challis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chilly Barton Flat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cobalt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coeur D'Alene"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cottonwood 2 WSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Craigmont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Craters of the Moon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deadwood Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dee Flat Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dixie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Driggs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dubois Exp. Station"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dworshak Fish Hatchery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elk City Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elk River 1 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emmet 2 E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairfield 3 SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairfield Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fenn Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Hall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galena"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garden Valley Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gibbonsville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glenns Ferry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gooding 2 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grace"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand View 2 W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grangeville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grouse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hagerman 2 SW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hailey 3 NNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazelton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Headquarters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Henry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hill City 1 W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hollister"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Howe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls 16 SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls 2 ESE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls 46W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Island Park"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jerome"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kamiah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kellogg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ketchum Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kilgore"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kooskia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kuna 2 NNE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leadore 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lewiston WSO AP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lifton Pumping Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lowman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mackay Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malad City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malta 2E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Massacre Rocks St Park"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McCall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McCammon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Middle Fork Lodge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minidoka 10 WNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minidoka Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montpelier Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moscow, U of Idaho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mountain Home"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mullan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nampa Sugar Factory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Meadows Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nez Perce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ola"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ola 4 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orofino"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palisades"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parma Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paul 1 ENE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payette"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Picabo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pierce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pierce Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plummer 3 WSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pocatello Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porthill"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potlatch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Powell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preston Sugar Factory 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priest River Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rexburg, Ricks College"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reynolds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Richfield"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Riggins"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rupert 3 WSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saint Maries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salmon KSRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandpoint Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoshone 1 WNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver City 5 W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soda Springs Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St Anthony 1 WNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stanley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strevell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sugar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun Valley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swan Falls Power House"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swan Valley 2 E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taylor Ranch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tensed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tetonia Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Three Creek"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls 2 NNE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls 3 SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls KMVT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls WSO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wallace"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wallace Woodland Park"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weiser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winchester"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow Pine 7 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellowpine Bar"]

{"sheet":"CONS","index":4,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,"No rating value"]
[0,"Very Low",0,"None Used, or No Runoff"]
[1,"Low",1,"Few BMPs"]
[2,"Medium",2,"Average"]
[4,"High",4,"Good"]
[8,"Very High",8,"Excellent"]
[10,"Critical"]
[100,"Critical"]
[null,"Soil Test P","P Rate","P Method","Mrate","Mmethod","N rate","Ntime","Nmethod","Runoff Class","BMPs","Irrigation Index","Leaching Index","Distance","SoilProp","Soil erosion","Runoff Index","Soil Test N"]
["Very Low","Soil test P is in the very low range for most crops. Recommendation: Use and follow crop-specific U of I Fertilizer Guides.","No phosphorus fertlizer used.","No phosphorus fertlizer used.","No animal waste applied","No animal waste applied","N application rate does not meet crop needs. Potential for yield reduction. Recommended: Use soil tests and U of I Fertilizer Guide recommendations.","No N applied","No N applied","Little surface runoff occurs from storm events. Low risk of soluble and/or sediment-attached nutrient loss.","REQUIRED if runoff occurs: Apply in-field conservation practices (reduced tillage, etc.) that reduce soil erosion and runoff. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Good water management. Leaching during the growing season is minimized.","Lower potential for leaching during the non-growing season.","Increased distance to surface water reduces transport risk ","Soils with slow infiltration/water transmission. Reduced risk of leaching.","No erosion occurs","Little surface runoff occurs from irrigation. Low risk of soluble and/or sediment-attached nutrient loss.","Soil test N is in the low range for most crops. Recommendation: Use and follow crop-specific U of I Fertilizer Guides."]
["Low","Soil test P is in the low range for most crops. Recommendation: Use and follow crop-specific U of I Fertilizer Guides.","Recommended: Use and follow crop specific U of I Fertilzer Guides.","Current placement minimizes risk of runoff/erosion loss.","Rate of application may contribute to phosphorus loading over time. Recommended: Follow the 590 standard.","Current placement minimizes risk of runoff/erosion loss.","N application rate meets the crop needs and does not exceed crop needs by more than 20%.","Proper nitrogen application timing. Recommendation: Follow N application rate recommendations and apply according to crop growth needs.","Using proper placement methods.","Little surface runoff occurs from storm events. Low risk of soluble and/or sediment-attached nutrient loss.","REQUIRED if runoff occurs: Apply in-field conservation practices (reduced tillage, etc.) that reduce soil erosion and runoff. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Good water management. Leaching during the growing season is minimized.","Lower potential for leaching during the non-growing season.","Increased distance to surface water reduces transport risk. Recommendation: Use practices that reduce runoff. ","Soils with slow infiltration/water transmission. Reduced risk of leaching.","Erosion probably less than T. Recommendation: Follow good soil conservation practices","Little surface runoff occurs from irrigation. Low risk of soluble and/or sediment-attached nutrient loss.","Soil test N is in the low range for most crops. Recommendation: Use and follow crop-specific U of I Fertilizer Guides."]
["Medium","Soil test P is at an adequate range for most crops, and may be approaching an agronomic threshold (or no soil test P but no P application). Recommended: Annual soil testing per the 590 standard.","Increased P application rate increases the risk of off-site transport. Recommended: Use and follow crop-specific U of I Fertilizer Guides.","Recommended: Place commercial fertilizer P with planter, or inject > 2\", or incorporate immediately after broadcasting on annuals. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement.","Rate of application may contribute to phosphorus loading over time. Recommended: Follow the 590 standard.","Recommended: Place commercial fertilizer P with planter, or inject > 2\", or incorporate immediately after broadcasting. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement.","Increased potential for off-site nitrogen transport. Recommended: Nitrogen application rates should be based on the U of I Fertilzer Guides.","Recommended: Split fall/spring applications utilizing soil temperatures (<50 o F), nitrification inhibitors, time release fertilizers (especially for >50lbs/ac in fall), or split spring applications of N, to provide nutrients at the times of maximum crop uptake. Where the risk of runoff in winter/spring is high, fall applications should be timed to allow incorporation/injection, regardless of soil temperature.","Recommended: place commercial fertilizer N with planter, or inject > 2\", or incorporate immediately after broadcasting on annuals. For perennials, apply when adequate cover is present.","Recommended: Apply in-field conservation practices (reduced tillage, etc.) that reduce soil erosion and runoff from storms.","Recommended if runoff occurs: Apply in-field conservation practices (reduced tillage, etc.) that reduce soil erosion and runoff.","Potential for leaching of nutrients exists. Recommended: Use IWM (449).","Potential for soluble nutrient leaching to occur. Recommended: Minimize carry-over nitrogen by following 590.","Inherent risk for nutrient transport. Recommended: Apply in-field conservation practices that reduce soil erosion and runoff.","Soil properties or proximity of water table to surface increases groundwater vulnerability. Recommended :Use proper nutrient timing/form, and IWM.","Erosion greater than T. Recommeded: Use appropriate soil conservation practices to reduce soil erosion to acceptable levels (T).","Recommended: Apply in-field conservation practices that reduce soil erosion and runoff of irrigation water.","Soil test N is at a moderate range (or no soil test N but no N application). Recommended: Annual soil testing per the 590 standard."]
["High","Soil test P is above the agronomic threshold, and is approaching a level where a drawdown strategy may be needed. REQUIRED: Annual soil testing per the 590 standard.","Increased P application rate  increases the risk of off-site transport. REQUIRED: Use and follow crop-specific U of I Fertilizer Guides.","REQUIRED: Place commercial fertilizer P with planter, deep band,  inject > 2\",  disk in, or incorporate immediately after broadcasting. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement.","Rate of application may contribute to phosphorus loading over time. REQUIRED: Proper manure management using the 590 standard.","REQUIRED: Place commercial fertilizer P with planter, deep band,  inject > 2\",  disk in, or incorporate immediately after broadcasting. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement.","REQUIRED: Nitrogen application rates based on the U of I Fertilzer Guides and the 590 standard.","REQUIRED: Split fall/spring applications utilizing soil temperatures (<50 o F), nitrification inhibitors, time release fertilizers (especially for >50lbs/ac in fall), or split spring applications of N, to provide nutrients at the times of maximum crop uptake. Where the risk of runoff in winter/spring is high, fall applications should be timed to allow incorporation/injection, regardless of soil temperature.","REQUIRED: place commercial fertilizer N with planter, or inject > 2\", or incorporate immediately after broadcasting on annuals. For perennials, apply when adequate cover is present.","REQUIRED: Apply in-field conservation practices (reduced tillage, etc.) that reduce soil erosion and runoff from storms. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Good use of conservation practices to reduce runoff and remove pollutants.","Potential for leaching of nutrients exists. REQUIRED: Use IWM (449). Recommendation: Use advanced soil moisture monitoring/scheduling techniques. If using surface irrigation, consider conversion to sprinkler.","Potential for soluble nutrient leaching to occur. REQUIRED: Minimize carry-over nitrogen by following 590.","Inherent risk for nutrient transport. REQUIRED: Apply in-field conservation practices that reduce soil erosion and runoff. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Soil properties or proximity of water table to surface increases groundwater vulnerability. REQUIRED:Use proper nutrient timing/form, and IWM.","Erosion greater than T. REQUIRED: Use appropriate soil conservation practices to reduce soil erosion to acceptable levels (T).","REQUIRED: Apply in-field conservation practices that reduce soil erosion and runoff or irrigation water. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Soil test N is at a high level, increasing the risk to both surface and ground water.  REQUIRED: Annual soil testing per the 590 standard. Use post harvest soil tests to determine leaching risk, and use crop rotation and other practices to reduce soil nitrate levels. "]
["Very High","Soil Test P has reached a level where a drawdown strategy is required. This strategy will include reducing applications of P below the crop requirement and the use of conservation practices (or no Soil Test P in last 5 years). REQUIRED: Annual soil testing per the 590 standard, and a drawdown strategy.","High P application rate  increases the risk of off-site transport. REQUIRED: Use and follow crop-specific U of I Fertilizer Guides.","REQUIRED: Place commercial fertilizer P with planter, deep band,  inject > 2\",  disk in, or incorporate immediately after broadcasting. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement.","Rate of application may contribute to phosphorus loading over time. REQUIRED: Proper manure management using the 590 standard.","REQUIRED: Place commercial fertilizer P with planter, deep band,  inject > 2\",  disk in, or incorporate immediately after broadcasting. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement.","REQUIRED: Nitrogen application rates based on the U of I Fertilzer Guides and the 590 standard.","REQUIRED: Split fall/spring applications utilizing soil temperatures (<50 o F), nitrification inhibitors, time release fertilizers (especially for >50lbs/ac in fall), or split spring applications of N, to provide nutrients at the times of maximum crop uptake. Where the risk of runoff in winter/spring is high, fall applications should be timed to allow incorporation/injection, regardless of soil temperature.","REQUIRED: place commercial fertilizer N with planter, or inject > 2\", or incorporate immediately after broadcasting on annuals. For perennials, apply when adequate cover is present.","REQUIRED: Apply in-field conservation practices (reduced tillage, etc.) that reduce soil erosion and runoff from storms. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Good use of conservation practices to reduce runoff and remove pollutants","Potential for leaching of nutrients is high. REQUIRED: Use IWM (449). Use conservation practices that reduce runoff and trap/filter nutrients and sediment. Recommendation: use advanced soil moisture monitoring/scheduling techniques. If using surface irrigation, consider conversion to sprinkler.","High potential for soluble nutrient leaching to occur. REQUIRED: Minimize carryover nitrogen by following 590.","Inherent risk for nutrient transport. REQUIRED: Apply in-field conservation practices that reduce soil erosion and runoff. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Soil properties and proximity of water table to surface increases groundwater vulnerability. REQUIRED:Use proper nutrient timing/form, and IWM.","Erosion greater than T. REQUIRED: Use appropriate soil conservation practices to reduce soil erosion to acceptable levels (T).","REQUIRED: Apply in-field conservation practices that reduce soil erosion and runoff of irrigation water. Conservation practices that trap and/or filter nutrients are also required when in-field practices are insufficient.","Soil Test N is at a very high level, significantly increasing the risk to both surface and ground water.  REQUIRED: Annual soil testing per the 590 standard. Use post harvest soil tests to determine leaching risk, and use crop rotation, IWM, and other practices to reduce soil nitrate levels."]
["Critical","Soil test P has exceeded the environmental threshold. No further applications of manure are allowed. REQUIRED: Annual soil testing per the 590 standard, with no additional application of manure allowed.",null,"REQUIRED: Place commercial fertilizer P with planter, deep band,  inject > 2\",  disk in, or incorporate immediately after broadcasting. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement. Control surface runoff.",null,"REQUIRED: Place commercial fertilizer P with planter, deep band,  inject > 2\",  disk in, or incorporate immediately after broadcasting. For perennials, surface apply when adequate cover is present to reduce risk of off-site movement. Control surface runoff.",null,null,"REQUIRED: place commercial fertilizer N with planter, or inject > 2\", or incorporate immediately after broadcasting on annuals. For perennials, apply when adequate cover is present. Control surface runoff.",null,null,null,null,null,null,null,null,"Soil Test N is at an excessive level, significantly increasing the risk to both surface and ground water.  REQUIRED: Annual soil testing per the 590 standard. Use post harvest soil tests to determine leaching risk, and use crop rotation, IWM, and other practices to reduce soil nitrate levels."]
[]
[]
[]
[]
[null,"Note: Recommendations are for Very Low, Low, Medium",null,null,null,null,null,"Use verbage from N timing email"]
[]
[null,"BMPs"]
["None Used, or No Runoff","REQUIRED if runoff occurs: Apply in-field conservation practices that reduce soil erosion and runoff. Conservation practices that trap and/or filter nutrients are also required."]
["Few BMPs","REQUIRED if runoff occurs: Apply in-field conservation practices that reduce soil erosion and runoff. Conservation practices that trap and/or filter nutrients are also required."]
["Average","REQUIRED if runoff occurs: Apply in-field conservation practices that reduce soil erosion and runoff."]
["Good","Good use of conservation practices to reduce runoff and remove pollutants."]
["Excellent","Good use of conservation practices to reduce runoff and remove pollutants"]

{"sheet":"CALCS","index":5,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Soil Test P",null,null,{"$f":"B1*C1","v":0},null,null,"surface - P","ground","surface - N"]
["P application rate",null,null,{"$f":"B2*C2","v":0},null,null,{"$f":"D1+D2+D3+D4+D5+D10+D11+D15+D17+D14","v":0},{"$f":"D6+D7+D12+D13+D16+D20","v":0},{"$f":"D5+D10+D11+D15+D17+D8+D6+D14+D19","v":0}]
["P application method",null,null,0]
["Manure application rate",null,null,0]
["Manure application method",null,null,0]
["N fertilizer rate as % crop need",null,null,0]
["N application timing",null,null,0]
["N application method",null,null,0]
[]
["Runoff Class",null,null,0]
["Runoff BMPs",null,null,{"$f":"B11*C11","v":0},{"$f":"IF(B11=\"\",\"\",(ABS(B11)))","v":""}]
["Irrigation Index",null,null,0]
["Leaching Index",null,null,0]
["Irrigation Runoff Index",null,null,0]
["Distance to Water Body",null,null,0]
["Watertable and Soil",null,null,0]
["Soil Erosion",null,null,0]
[null,null,null,null,null,"Average N rating for assessment page"]
["Soil Test N 0-12",null,null,0,null,null," ",null,{"$f":"IF(B19=\"\",\"\",MAX(D19:D20))","v":""},"not used now"]
["Soil Test N 12-24",null,null,0]
["TOTALS",null,null,{"$f":"SUM(D1:D20)","v":0}]

{"sheet":"Soils and Landform","index":6,"n_rows":156,"n_cols":18,"rows_kept":156,"cut":false,"hidden":false,"merged":[[20,3,20,4],[21,3,21,4],[30,0,33,4],[17,0,17,4],[18,0,18,4],[24,0,24,4],[26,0,26,2],[28,0,28,4],[25,0,25,4],[13,3,13,4],[12,3,12,4],[14,3,14,4],[15,3,15,4],[0,0,0,4],[1,0,2,4],[8,0,8,4],[9,0,10,4],[4,3,4,4],[5,3,5,4]]}
["DISTANCE TO SURFACE WATER BODY",null,null,null,null,null,null,null,null,null," ",null,null,true," ",null,null,"Winter Ppt"]
["The closer the distance from the edge of the agricultural field to the nearest receiving water body (ditch, canal, drain, waterway - any perennial or ephemeral water body with eventual connection to the river or stream), the greater the potential for the majority of the phosphorus lost from the field/operation to reach the water body and negatively impact water quality.",null,null,null,null,null,null,null,null,null," ",null,null," ",null,null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP($A29,IRRIG!$J$4:$O$156,6,FALSE))","v":""}]
[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,"Aberdeen"]
[null,null,null,"Distance to Surface Water Body:",null,null,null,null,null,null,null,null," "," ","American Falls",null,null,"Hydrologic Group A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","Anderson Dam",null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP($A29,IRRIG!$J$4:$O$156,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arbon 2 NW",null,null,"Hydrologic Group B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arco 3 SW",null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP($A29,IRRIG!$J$4:$O$156,3,FALSE))","v":""}]
["WATER TABLE DEPTH, GEOLOGIC FEATURES AND SOIL TYPE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Arrowrock Dam",null,null,"Hydrologic Group C"]
["Soils can stop or slow nitrogen movement depending on their chemical and physical characteristics. Depth of soils, texture and structure, depth to water tables, and limiting layers such as hard pans or gravels, will influence rooting depth, nitrogen movement, and leaching potential.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ashton",null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP($A29,IRRIG!$J$4:$O$156,4,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avery Ranger Sta 1",null,null,"Hydrologic Group D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avery Ranger Sta 2",null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP($A29,IRRIG!$J$4:$O$156,5,FALSE))","v":""}]
[null,null,null,"Water Table/Geologic Feature Depth:",null,null,null,null,null,null,null,null,null,null,"Bayview Model Basin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blackfoot 2 SSW"]
[null,null,null,"Hydrologic Group:",null,null,null,null,null,null,null,null,null,null,"Bliss 4 NW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boise 7 N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boise Airport"]
["ESTIMATE OF TOTAL SOIL EROSION BY WATER",null,null,null,null,null,null,null,null,null,null,null,null,null,"Boise Lucky Peak Dam"]
["Field-scale estimates of erosion resulting from water processes are an indication of the potential for sediment and attached phosphorus moverment toward a water body. Sheet and rill soil erosion is estimated using RUSLE2 (Revised Universal Soil Loss Equation).  Irrigation-induced erosion is estimated using SISL (Surface Irrigation Soil Loss) or observation/estimation for sprinkler. WEPS is used to estimate the amount of wind erosion.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonners Ferry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brownlee Dam"]
[null,null,null,"Tons of Erosion (sheet/rill + irrigation-induced + wind)",null,null,null,null,null,null,null,null,null,null,"Bruneau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buhl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burley Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cabinet Gorge"]
["CLIMATIC PATTERN",null,null,null,null,null,null,null,null,null,null,null,null,null,"Caldwell"]
["Climatic patterns affect site hydrology, including runoff and leaching potential. Select the most appropriate climatic station below.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambridge"]
["NEAREST CLIMATIC STATION:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cascade 1 NW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Castleford 2 N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Challis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chilly Barton Flat"]
["When you have completed all the factors above, select the FINAL CALCULATIONS button below to complete final calculations. Then Proceed to the ASSESSMENT REPORT for the Risk Index and summary of results.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cobalt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coeur D'Alene"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cottonwood 2 WSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Craigmont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Craters of the Moon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deadwood Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dee Flat Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dixie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Driggs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dubois Exp. Station"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dworshak Fish Hatchery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elk City Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elk River 1 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emmet 2 E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairfield 3 SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairfield Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fenn Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Hall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galena"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garden Valley Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gibbonsville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glenns Ferry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gooding 2 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grace"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand View 2 W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grangeville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grouse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hagerman 2 SW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hailey 3 NNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazelton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Headquarters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Henry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hill City 1 W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hollister"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Howe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls 16 SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls 2 ESE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls 46W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idaho Falls Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Island Park"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jerome"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kamiah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kellogg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ketchum Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kilgore"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kooskia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kuna 2 NNE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leadore 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lewiston WSO AP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lifton Pumping Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lowman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mackay Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malad City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malta 2E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Massacre Rocks St Park"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McCall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McCammon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Middle Fork Lodge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minidoka 10 WNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minidoka Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montpelier Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moscow, U of Idaho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mountain Home"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mullan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nampa Sugar Factory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Meadows Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nez Perce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ola"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ola 4 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orofino"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palisades"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parma Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paul 1 ENE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payette"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Picabo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pierce"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pierce Ranger Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plummer 3 WSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pocatello Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porthill"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potlatch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Powell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preston Sugar Factory 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priest River Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rexburg, Ricks College"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reynolds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Richfield"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Riggins"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rupert 3 WSW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saint Maries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salmon KSRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandpoint Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoshone 1 WNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver City 5 W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soda Springs Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St Anthony 1 WNW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stanley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strevell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sugar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun Valley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swan Falls Power House"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swan Valley 2 E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taylor Ranch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tensed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tetonia Experiment Sta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Three Creek"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls 2 NNE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls 3 SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls KMVT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Twin Falls WSO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wallace"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wallace Woodland Park"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weiser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winchester"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow Pine 7 S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellowpine Bar"]

{"sheet":"IRRIG","index":7,"n_rows":156,"n_cols":15,"rows_kept":156,"cut":false,"hidden":true,"merged":[[0,0,0,2],[2,0,2,3]]}
["IRRIGATION SYSTEM AND WATER MANAGEMENT",null,null,null,null,null,null,null,null,"Climate Station Leaching Index for Non Irrigated by hydrologic Group"]
[]
["NOTE: This tool has been modified from the CSP IWM Calculator to capture the irrigation water management factors that have the greatest impact on deep percolation over the irrigation season.",null,null,null,null,null,null,null,null,null,"A","B","C","D","Winter PPt"]
[null,null,null,null,null,null,null,null,null,"Aberdeen",0.45807267342983954,4.2741295336689446E-2,1.8839591033119839E-2,0.11802891348965475,4.3899999999999997]
[null,null,null,null,null,null,null,null,null,"American Falls",1.1479395367340011,0.32062648770481245,3.7930157109174183E-2,7.9150675024550893E-4,5.8]
[null,null,"Irrigation System","Multiplier","Additional Notes",null,null,null,null,"Anderson Dam",2.6612902953336839,0.491111020468813,1.2393239728400488E-3,0.24529460466576589,14.21]
[null,null,null,null,null,null,null,null,null,"Arbon 2 NW",1.0852553530279005,2.6659891859006982E-2,0.27498833712832588,0.90633969574361861,8.74]
[null,null,"Surface - Graded Border",80,null,null,null,null,null,"Arco 3 SW",0.65034789312905839,0.10807306660242397,4.5415664719656744E-4,5.3465356974549717E-2,4.55]
[null,null,"Surface - Level Border (Basin)",90,null,null,null,null,null,"Arrowrock Dam",2.3515224116336753,0.36626939076225445,1.6286408224137999E-2,0.34252448750752484,13.63]
[null,null,"Surface - Guide Border",70,null,null,null,null,null,"Ashton",2.3392841258050443,0.40961057171385823,3.9759136159696401E-3,0.25239962884998107,10.74]
[null,null,"Surface - Border - Contour Level",70,null,null,null,null,null,"Avery Ranger Sta 1",11.227248907038712,6.0151418175427507,2.9491560619829729,1.5589047815336654,21.44]
[null,null,"Surface - Border - Border Ditch",60,null,null,null,null,null,"Avery Ranger Sta 2",15.569449964417949,9.3731834991541216,5.4279901408869646,3.4601587150863629,25.09]
[null,null,"Surface - Level Furrow (Basin with furrows or corrugations",90,null,null,null,null,null,"Bayview Model Basin",5.1907994829010322,1.8819322193887515,0.41577494896757744,3.4923905697849589E-2,15.17]
[null,null,"Surface - Graded Furrow",75,null,null,null,null,null,"Blackfoot 2 SSW",0.81691066753332009,0.170575756498488,2.8033259956003051E-3,2.6566012966634335E-2,5.17]
[null,null,"Surface - Contour Furrow",75,null,null,null,null,null,"Bliss 4 NW",0.68057264419973762,0.10360333778951773,2.1789995832473476E-3,7.1655536153519883E-2,6.28]
[null,null,"Surface - Corrugations",75,null,null,null,null,null,"Boise 7 N",2.3486067058006403,0.39210989853583073,8.0693502227162234E-3,0.28851929034746232,11.93]
[null,null,"Surface - Surge",80,null,null,null,null,null,"Boise Airport",1.455337282138663,0.46116789507762768,8.4511402159817908E-2,3.3145869052975349E-3,7.27]
[null,null,"Surface - Controlled with contour ditch, turnouts, canvas dams, etc.",60,null,null,null,null,null,"Boise Lucky Peak Dam",0.41072913354739843,6.0790769949093076E-2,0.87565492240055831,1.8571546516593569,8.4600000000000009]
[null,null,"Surface - Uncontrolled (wild flood, no control with turnouts, etc.)",50,null,null,null,null,null,"Bonners Ferry",4.1007668091169158,1.2392355163461242,0.14882642823073616,5.0472522502152724E-3,14.37]
[null,null,"Subirrigation (typically with a surface system to apply water)",75,null,null,null,null,null,"Brownlee Dam",1.4158206653219203,8.3746825822382423E-2,0.17407807540471318,0.73471412507121159,10.46]
[null,null,"Sprinkler - Big gun or boom",60,null,null,null,null,null,"Bruneau",0.19610334119764256,2.260241692799038E-4,0.12228018766591188,0.30312292273795144,4.26]
[null,null,"Sprinkler - Hand line or wheel line",70,null,null,null,null,null,"Buhl",0.65173132102513243,9.9788060588656274E-2,1.9454163342773896E-3,6.7590935051217702E-2,5.45]
[null,null,"Sprinkler - Solid set (above canopy)",75,null,null,null,null,null,"Burley Airport",0.79412210406680084,0.15703251490847545,1.1127786914125026E-3,3.3959785132527606E-2,5.48]
[null,null,"Sprinkler - Solid set (below canopy)",80,null,null,null,null,null,"Cabinet Gorge",11.044335250474901,5.8826789377790041,2.8584668475945412,1.4943334750810273,21.19]
[null,null,"Sprinkler - Center pivot, high pressure",80,"typically impact sprinklers on top of pipe span",null,null,null,null,"Caldwell",1.0375557587063444,0.25289724456727752,1.5415244168088198E-2,1.0612295695194517E-2,6.76]
[null,null,"Sprinkler - Center pivot - low pressure improved",83,"less than 30 psi nozzle pressure, applicator device > 8' above ground",null,null,null,null,"Cambridge",3.1041215580762898,0.69428766982575663,9.3737261247713085E-3,0.13261506284224067,14.6]
[null,null,"Sprinkler - Center pivot, LEPA",92,"low energy precision application, drag hoses, socks or shielded pad < 18\" from ground, maximum 1% slope in majority of field",null,null,null,null,"Cascade 1 NW",4.082126201122132,1.2206040665258786,0.14028414698312403,7.054939920243088E-3,14.67]
[null,null,"Sprinkler - Center pivot - LESA",89,"low energy spray application, applicator device < 18\" above ground, maximum 3% slope in majority of field",null,null,null,null,"Castleford 2 N",0.80455466100933015,0.15973938767973897,1.2226675568169109E-3,3.3763688264128067E-2,5.64]
[null,null,"Sprinkler - Center pivot, LPIC",87,"low pressure in canopy, applicator device within canopy for at least half of the irrigation season, applicator device from 18\" to 36\" above ground",null,null,null,null,"Challis",0.16323518614786517,3.4331831905670749E-4,0.10716818176976776,0.26291885021654932,2.64]
[null,null,"Sprinkler - Center pivot - MESA",85,"mid elevation spray application, applicator device more that 18\" but less than 7\" above ground",null,null,null,null,"Chilly Barton Flat",0.25914153224093767,7.8871986453643798E-3,4.7730671119890662E-2,0.16225720324324699,2.38]
[null,null,"Sprinkler - Variable rate application (precision farming technique)",87,null,null,null,null,null,"Cobalt",1.5276183634494094,0.14494454374738708,8.521124861526784E-2,0.50572612485560653,7.91]
[null,null,"Sprinkler - Lateral/linear move",82,null,null,null,null,null,"Coeur D'Alene",6.0397665754940348,2.3851849988081111,0.6555802593575808,0.11976365514911916,16.77]
[null,null,"Sprinkler - Lateral/linear move with LEPA, LESA, LPIC, MESA",87,null,null,null,null,null,"Conda",2.2286159380717181,0.37100122084841597,7.9321366579098145E-3,0.27584699071496643,10.25]
[null,null,"Micro Irrigation - Point source (emitters punched into hose, tubing, etc.)",90,null,null,null,null,null,"Cottonwood 2 WSW",3.7401759311804255,1.1459775624162809,0.14548725687295735,2.641230084732449E-3,10.42]
[null,null,"Micro Irrigation - Sprays",85,null,null,null,null,null,"Council",5.3867685626881903,1.954554711660188,0.43277854264694621,3.6723037054375643E-2,16.899999999999999]
[null,null,"Micro Irrigation - Continuous tape",90,null,null,null,null,null,"Craigmont",3.4253017351108159,0.96176028533973035,8.2813617586626045E-2,2.1600024829822321E-2,10.55]
[null,null,"Micro Irrigation - SDI (subsurface drip)",92,null,null,null,null,null,"Craters of the Moon",0.93107146860743983,5.8739247312810661E-3,0.38128481957102711,1.0998912578791411,9.14]
[null,null,null,null,null,null,null,null,null,"Deadwood Dam",11.590088768377317,6.1872105580392427,3.0168172097151804,1.5838576668758844,24.14]
[null,null,null,null,null,null,null,null,null,"Dee Flat Dam",0.75037318710187084,0.13424535258641893,0,4.827558196945738E-2,5.91]
[null,null,"Water Measurement","Multiplier",null,null,null,null,null,"Dixie",7.9509053345197378,3.7055931812481067,1.4384480079779673,0.54663906562064024,17.239999999999998]
[null,null,"No flow measurement",0.9,"no measuring devices such as flumes, weirs, or flow meters",null,null,null,null,"Driggs",0.88795897324127504,7.9979579638275438E-3,0.33321973527369353,0.9831531718469011,7.19]
[null,null,"Flow measurement - whole farm, manually recorded",0.93,"not individual fields",null,null,null,null,"Dubois Exp. Station",1.3303001132629291,0.43471402737366943,8.7162227348213425E-2,5.8743936050985844E-3,4.88]
[null,null,"Flow measurement - whole farm, automatically recorded",0.95,null,null,null,null,null,"Dworshak Fish Hatchery",5.9229654433272696,2.3467915161185386,0.65007663573115892,0.12135053652064001,15.59]
[null,null,"Flow measurement - whole farm plus each field, manually recorded",0.97,null,null,null,null,null,"Elk City Ranger Sta",8.9144239914230852,4.4442883218419276,1.9417880798033917,0.88229992021294967,16.690000000000001]
[null,null,"Flow measurement - whole farm plus each field, automatically recorded",1,null,null,null,null,null,"Elk River 1 S",15.340057007316382,9.1761198992846857,5.2684995459136967,3.3288120519668323,25.21]
[null,null,null,null,null,null,null,null,null,"Emmet 2 E",0.34954760387137362,9.1267788639964584E-2,0.9904493211803479,2.0290809602259827,8.7100000000000009]
[null,null,"Improved Soil Moisture Monitoring and Scheduling",null,null,null,null,null,null,"Fairfield 3 SE",1.7899119171339055,0.64058248785815985,0.16285357735707692,2.7287993317861914E-2,7.89]
[null,null,"Use a set irrigation schedule each year",0.85,null,null,null,null,null,"Fairfield Ranger Sta",0.80543083170884877,1.0629537061444754E-4,0.51618622905253608,1.3411936493245054,10.199999999999999]
[null,null,"Irrigation based on visual observation of crop stress",0.9,null,null,null,null,null,"Fenn Ranger Sta",15.418003402049862,9.3288668791848899,5.4386364217323582,3.4908825237134993,23.43]
[null,null,"Soil moisture by NRCS feel method",0.93,"operator typically trained with pamphlet",null,null,null,null,"Fort Hall",1.0972496732102566,0.30084700719379781,3.2990081098453666E-2,1.4804539065626323E-3,5.41]
[null,null,"Check book scheduling, irrigation scheduler, etc.",0.96,null,null,null,null,null,"Galena",5.7172995584636119,2.184391076522366,0.553903988117185,7.9305027407608211E-2,16.38]
[null,null,"Irrigation scheduling via pan eveporation of atmometer in field",0.97,null,null,null,null,null,"Garden Valley Ranger Sta",5.7476829536858318,2.1642405810005467,0.52886274340007178,6.6727376941477734E-2,17.68]
[null,null,"Irrigation scheduling via regional weather network (e.g. AgriMet)",0.98,null,null,null,null,null,"Gibbonsville",1.1798604519013491,4.4330537067226457E-2,0.22618554597151116,0.81443922856337503,8.68]
[null,null,"Soil moisture monitoring using Gypsum blocks, moisture probes, etc.",0.99,null,null,null,null,null,"Glenns Ferry",0.68074954871962967,0.10302846446706235,2.3329694465864018E-3,7.2760948042871962E-2,6.36]
[null,null,"Continuous measurement of soil moisture, water applied, and ET",1,null,null,null,null,null,"Gooding 2 S",0.65158461111883659,9.3973682521937552E-2,3.6189462015744148E-3,7.8431730597904467E-2,6.14]
[null,null,null,null,null,null,null,null,null,"Grace",0.65757838790326995,1.7754229475851542E-3,0.50008247707029885,1.2541913672425651,6.97]
[null,null,"Pre and Post Season Irrigation",null,null,null,null,null,null,"Grand View 2 W",0.11588012947306754,1.067826369134278E-2,0.1829048596167703,0.38750802770581994,3.74]
[null,null,"Pre- and post-season irrigations based on standard run time",0.9,"Run time not based on soil moisture assessment, done to ease field cultivations, seed germ.",null,null,null,null,"Grangeville",4.2913953107390963,1.4836720018173626,0.28579066384158919,1.091643386530493E-2,10.29]
[null,null,"Pre-season OR post-season irrigations based on standard run time",0.93,null,null,null,null,null,"Grouse",1.6164838858785691,0.57382212917764541,0.14303203476287574,2.2607913493072309E-2,6.04]
[null,null,"Pre- and post-season irrigations based on soil moisture assessment",0.93,null,null,null,null,null,"Hagerman 2 SW",0.94624922159705771,0.20919294515765463,6.2673921495675277E-3,2.1805179945530651E-2,6.86]
[null,null,"Pre- OR post-season irrigations based on soil moisture assessment",0.97,null,null,null,null,null,"Hailey 3 NNW",1.0931883286087927,2.0435903286763646E-2,0.31726012494265765,1.0046257605394948,10.220000000000001]
[null,null,"No irrigation outside crop growing season",1,null,null,null,null,null,"Hamer",0.44670527654176856,4.5898118533943377E-2,1.3956218423440145E-2,0.10077927819273544,3.54]
[null,null,null,null,null,null,null,null,null,"Hazelton",0.85950559698306228,0.17678003071355122,2.3831419180433667E-3,3.0296137670217743E-2,6.27]
[null,null,"Control of Water Distribution",null,null,null,null,null,null,"Headquarters",17.4661048509331,10.890493195072306,6.6029845328055075,4.4084628993178701,26.78]
[null,null,"Little or no control of flow to farm. Very poor diversion facilitities",0.9,"diversion facilities do not provide good flow rate control",null,null,null,null,"Henry",3.014085795352035,0.72889767889059309,2.3441726154127464E-2,8.1673618421704411E-2,10.96]
[null,null,"Can control flow rate to farm, but on-farm delivery system inadequate  ",0.94,"very hard to deliver the desired flow to any given field",null,null,null,null,"Hill City 1 W",0.66088161324447436,9.1056941199704911E-3,0.64466681380216617,1.5420995823513211,10.050000000000001]
[null,null,"Flow rates to field controlled, but flow rates to sets poorly controlled",0.98,"flow rates to farm and to each field adequately controlled",null,null,null,null,"Hollister",0.78794317614767706,0.16144179897418817,2.0623926884426567E-3,2.8330068882932845E-2,4.88]
[null,null,"All flow rates to each set are adequately controlled",1,null,null,null,null,null,"Howe",0.28495755528314576,8.2128332132037907E-3,5.4487833232352088E-2,0.18303494208546736,3.28]
[null,null,null,null,null,null,null,null,null,"Idaho City",5.0527670286025508,1.7484611548453828,0.33770380497688829,1.3153702741368583E-2,16.739999999999998]
[null,null,"Soil Condition Index",null,null,null,null,null,null,"Idaho Falls 16 SE",0.90276428387715024,6.6285550192511289E-3,0.35702458612375337,1.0391277869091049,8.01]
[null,null,"SCI less than 0.1",0.9,null,null,null,null,null,"Idaho Falls 2 ESE",1.5123053389274406,0.51568571291273779,0.11612223822513627,1.3035250303604543E-2,5.95]
[null,null,"SCI = 0.1 to 0.2",0.91,null,null,null,null,null,"Idaho Falls 46W",0.41405412983075357,3.4323190948982875E-2,2.2498872905422077E-2,0.12324328306683829,3.8]
[null,null,"SCI = 0.2 to 0.3",0.92,null,null,null,null,null,"Idaho Falls Airport",0.76060980687857271,0.15283346533335981,1.4455567625243843E-3,3.0146361699952096E-2,4.62]
[null,null,"SCI = 0.3 to 0.4",0.93,null,null,null,null,null,"Island Park",8.2265318269113532,3.9098978263468056,1.5726167626882082,0.63235137615455783,17.18]
[null,null,"SCI = 0.4 to 0.5",0.94,null,null,null,null,null,"Jerome",0.9255544766008742,0.20251627468857622,5.5180773955259953E-3,2.2819767988146569E-2,6.61]
[null,null,"SCI = 0.5 to 0.6",0.95,null,null,null,null,null,"Kamiah",4.6210354582916695,1.6090042157852138,0.31659760782780866,1.4030576273519333E-2,12.51]
[null,null,"SCI = 0.6 to 0.7",0.96,null,null,null,null,null,"Kellogg",9.9014077671280329,5.0574114398053744,2.2998091326470593,1.1038276817044619,19.809999999999999]
[null,null,"SCI = 0.7 to 0.8",0.97,null,null,null,null,null,"Ketchum Ranger Sta",2.1134087782894899,0.30512434305993918,2.5185444325905089E-2,0.36312100929284641,11.31]
[null,null,"SCI = 0.8 to 0.9",0.98,null,null,null,null,null,"Kilgore",3.2375426768218158,0.85328860776280024,5.1686659117786443E-2,4.3788622805276164E-2,10.73]
[null,null,"SCI = 0.9 to 1.0",0.99,null,null,null,null,null,"Kooskia",4.9817856456447114,1.8335666951988523,0.42202171958853069,4.2349240563292027E-2,12.63]
[null,null,"SCI = Greater than 1.0",1,null,null,null,null,null,"Kuna 2 NNE",0.76486210164290647,0.1412896629571945,1.0595510791118359E-4,4.3657780966179338E-2,5.8]
[null,null,null,null,null,null,null,null,null,"Leadore 2",0.24238832560428852,5.2995541362899834E-3,5.4723594377259883E-2,0.17468250441524139,2.38]
[null,null,null,null,null,null,null,null,null,"Lewiston WSO AP",1.7363106777454731,0.63457200267034219,0.16952047309251481,3.2582003513228847E-2,6.51]
[null,null,"MODIFIED LIST OF SYSTEM (per Bruce Sandoval 6/21/2006)",null,null,null,null,null,null,"Lifton Pumping Sta",0.93245347668286438,0.23056427103958568,1.5280190197535159E-2,8.1479874675850373E-3,4.6900000000000004]
[null,null,null,null,null,null,null,null,null,"Lowman",6.5489433631481848,2.6895735318808502,0.80873496624744923,0.18617386961058846,17.96]
[null,null,"Irrigation System","Multiplier",null,null,null,null,null,"Mackay Ranger Sta",0.58360589393422557,8.8842122998226053E-2,1.8685396930091061E-3,6.1446185926829697E-2,3.96]
[null,null,null,null,null,null,null,null,null,"Malad",0.63511960472853035,5.5928501478732864E-3,0.56845118728662558,1.3814602589617389,7.88]
[null,null,"Surface - Graded Border",80,null,null,null,null,null,"Malad City",0.3147646720808403,8.2185874669514727E-2,0.89189126843147759,1.8271703081278461,6.36]
[null,null,"Surface - Level Border (Basin)",90,null,null,null,null,null,"Malta 2E",1.0113633611993533,0.27467574327149585,2.8928208563265809E-2,1.7901335856390114E-3,4.38]
[null,null,"Surface - Graded Furrow or Corrugates",75,null,null,null,null,null,"Massacre Rocks St Park",1.4385956905324631,0.46541171033500822,9.067407509605499E-2,5.233445453506071E-3,6.44]
[null,null,"Surface - Surge",80,null,null,null,null,null,"May",0.20794769935530757,1.3059187035572824E-3,7.3326157025474611E-2,0.20699162460740089,2.4500000000000002]
[null,null,"Surface - Controlled with contour ditch, turnouts, canvas dams, etc.",60,null,null,null,null,null,"McCall",7.046210240090633,3.0493601470892586,1.0252368498290447,0.30084187305335647,17.489999999999998]
[null,null,"Surface - Uncontrolled (wild flood, no control with turnouts, etc.)",50,null,null,null,null,null,"McCammon",1.0809832323185571,2.5243404367144191E-2,0.2814919676286663,0.92018523296972843,8.8699999999999992]
[null,null,"Sprinkler - Big gun or boom",60,null,null,null,null,null,"Middle Fork Lodge",1.0792442279547192,2.6953042566192294E-2,0.27098052619047136,0.89560047787999542,8.52]
[null,null,"Sprinkler - Periodic Move (hand line or wheel line)",70,null,null,null,null,null,"Minidoka 10 WNW",0.65087720352546197,0.10137513030812115,1.5526810779030941E-3,6.4495861515858025E-2,5.24]
[null,null,"Sprinkler - Solid set ",75,null,null,null,null,null,"Minidoka Dam",0.64243115359212355,9.8364090861637513E-2,1.9176553581634424E-3,6.6626416402733549E-2,5.22]
[null,null,"Sprinkler - Center pivot",85,null,null,null,null,null,"Montpelier Ranger Sta",0.49202078365223323,2.4630653694616044E-2,0.68000631134564038,1.5341000259317419,7.05]
[null,null,"Sprinkler - Lateral/linear move",87,null,null,null,null,null,"Moscow, U of Idaho",4.9287771938058533,1.7146471497140223,0.33649978590213053,1.4651380752503551E-2,15.23]
[null,null,"Micro Irrigation - Sprays and Bubblers",85,null,null,null,null,null,"Mountain Home",0.83093122530986863,0.16297735700658836,9.7847899983802148E-4,3.6887403502034781E-2,6.41]
[null,null,"Micro Irrigation - Tubing or tape with integrated or punched-in emitters",90,null,null,null,null,null,"Mullan",13.248300621128232,7.6052080314865922,4.1261681497464018,2.4537651231606366,22.03]
[null,null,null,null,null,null,null,null,null,"Nampa Sugar Factory",1.2471323776299861,0.35461755938693695,4.4993763937050783E-2,3.2125723187811125E-4,6.97]
[null,null,null,null,null,null,null,null,null,"New Meadows Ranger Sta",5.1473143621704534,1.841909590662496,0.39234100461493804,2.7617519025338263E-2,15.57]
[null,null,"COMBINED MEASUREMENT AND DISTRIBUTION (per Bruce Sandoval 7/13/06)",null,null,null,null,null,null,"Nez Perce",3.1106598460111976,0.80391020603673802,4.2946824317868587E-2,5.0570921953118096E-2,10.06]
[null,null,null,null,null,null,null,null,null,"Oakley",1.0303784619696137,0.27849580014624081,2.872527026254338E-2,2.065030981723922E-3,4.71]
[null,null,"Poor - no water measurement AND poor control of water (inadequate contyol structures)",0.85,null,null,null,null,null,"Ola",3.7185889748550416,1.0103224532136641,7.3124693920204292E-2,3.6245737543946721E-2,14.89]
[null,null,"Fair - manually recorded water measurement at delivery point to farm AND poor control of water (inadequate control structures)",0.91,null,null,null,null,null,"Ola 4 S",2.7885602720966807,0.56208198461585002,4.4527268056125744E-4,0.18890146344969916,13.51]
[null,null,"Average - manual recordings somewhere in the system OR good control of water with effective control structures throughout conveyance system",0.94,null,null,null,null,null,"Orofino",6.026336630933173,2.3924524721684381,0.6657994578591756,0.12587014484565162,16.28]
[null,null,"Good - manual recordings somewhere in the system AND good control of water with effective control structures throughout conveyance system",0.97,null,null,null,null,null,"Palisades",2.5614221597695241,0.52323364050876087,8.2452312823458242E-4,0.16467386963931396,10.16]
[null,null,"Excellent - continuous recording water measurment device(s) AND good control of water with effective control structures throughout conveyance system",1,null,null,null,null,null,"Parma Experiment Sta",0.8827401675350659,0.18637881562188902,3.499464126027846E-3,2.6987410997702837E-2,6.33]
[null,null,null," ",null,null,null,null,null,"Paul 1 ENE",0.71478669018767749,0.12607899232388217,1.8964443938323778E-5,4.8353658506555895E-2,5.28]
[null,null,null,null,null,null,null,null,null,"Payette",1.0911428820596112,0.27511848038809844,2.0302151527031735E-2,7.5137258393707289E-3,7.06]
[null,null,null,null,null,null,null,null,null,"Picabo",1.9433021352240851,0.72630036541487286,0.20417539170588297,4.4637566642572048E-2,8.17]
[null,null,null,null,null,null,null,null,null,"Pierce",18.302705139586827,11.624503775171753,7.2151970944560997,4.9284398724559813,26.42]
[null,null,null,null,null,null,null,null,null,"Pierce Ranger Sta",18.611961602641969,11.82906695371855,7.3485362994067822,5.0237097712216174,27.62]
[null,null,null,null,null,null,null,null,null,"Plummer 3 WSW",8.7042785538332605,4.1519866870303028,1.6808226917967621,0.6826613256894104,19.95]
[null,null,null,null,null,null,null,null,null,"Pocatello Airport",1.2980239409346817,0.39422279521099679,6.3198137955928352E-2,6.4732439133286532E-4,6.12]
[null,null,null,null,null,null,null,null,null,"Porthill",3.2785963549602832,0.83817428619518985,4.160458125919924E-2,5.8560065251185678E-2,12.14]
[null,null,null,null,null,null,null,null,null,"Potlatch",5.6656059907865677,2.1708313130595291,0.55441103283660242,8.1245194112825062E-2,15.75]
[null,null,null,null,null,null,null,null,null,"Powell",16.488282302353195,10.139857670895962,6.0390681765499385,3.9610669402779459,25.2]
[null,null,null,null,null,null,null,null,null,"Preston",1.2834265039505115,6.9570236145791345E-2,0.17474051746144242,0.7096681008462814,8.42]
[null,null,null,null,null,null,null,null,null,"Preston Sugar Factory 2",0.69685374482048446,9.7463309141685394E-4,0.49913898637497089,1.2670765229036456,7.65]
[null,null,null,null,null,null,null,null,null,"Priest River Experiment Sta",10.22562326280876,5.271522079598939,2.4332263350853247,1.1912246034706941,20.63]
[null,null,null,null,null,null,null,null,null,"Rexburg, Ricks College",0.30149432926204844,8.9255275637606546E-2,0.91474057527671226,1.8596113287926979,6.35]
[null,null,null,null,null,null,null,null,null,"Reynolds",1.0149133194737769,0.25237374263999796,1.726591884412066E-2,8.3038530813467938E-3,5.94]
[null,null,null,null,null,null,null,null,null,"Richfield",1.1808037161740816,0.31683086557828549,3.164538899675385E-2,2.8172312548897576E-3,7.27]
[null,null,null,null,null,null,null,null,null,"Riggins",1.2984155355287204,7.6156504566055605E-2,0.16129468384691961,0.67808349359106568,8.1300000000000008]
[null,null,null,null,null,null,null,null,null,"Rupert 3 WSW",0.50009129462036395,4.9497352263283355E-2,1.7489433219359234E-2,0.11900801054572915,5.25]
[null,null,null,null,null,null,null,null,null,"Saint Maries",9.5980690113368965,4.805119825185999,2.1141330754596925,0.97001538955166267,20.329999999999998]
[null,null,null,null,null,null,null,null,null,"Salmon KSRA",0.68469588679832316,0.13208382898637258,5.3697226566174622E-4,3.27171715978243E-2,3.74]
[null,null,null,null,null,null,null,null,null,"Sandpoint Experiment Sta",10.939697117174362,5.7906413725444841,2.7866817754194382,1.4393467778543245,21.43]
[null,null,null,null,null,null,null,null,null,"Shoshone 1 WNW",0.92916841873368583,0.20189338481127,5.1441850172107267E-3,2.3945029878773168E-2,6.82]
[null,null,null,null,null,null,null,null,null,"Shoup",0.57331920998712083,1.0375549399762551E-2,0.59409178291180387,1.4058875677497573,7.17]
[null,null,null,null,null,null,null,null,null,"Silver City 5 W",3.6858846240419396,1.0294020815455989,8.6271032641509995E-2,2.5133003046886211E-2,13.36]
[null,null,null,null,null,null,null,null,null,"Soda Springs Airport",0.95174466115189049,1.6040156062708127E-2,0.2888593210952381,0.90306657700052939,7.06]
[null,null,null,null,null,null,null,null,null,"St Anthony 1 WNW",0.53947399500131277,1.5700538361035844E-2,0.6312213564693776,1.4629127420970405,7.17]
[null,null,null,null,null,null,null,null,null,"Stanley",0.32240488782413723,9.715779792884785E-2,0.98785316943712109,2.0060604502551347,7.91]
[null,null,null,null,null,null,null,null,null,"Strevell",1.0008892516534076,0.27248196705823863,2.8993039281936316E-2,1.6604216371994712E-3,4.21]
[null,null,null,null,null,null,null,null,null,"Sugar",1.8012909776245443,0.67969449390876135,0.19517182093134408,4.4872176515223072E-2,6.2]
[null,null,null,null,null,null,null,null,null,"Sun Valley",1.5940772069371898,0.13233820748529623,0.11734674674966736,0.61253528497481546,10.55]
[null,null,null,null,null,null,null,null,null,"Swan Falls Power House",0.2587758269269485,2.4281181070027347E-3,8.2123544163427098E-2,0.23823386801114782,4.18]
[null,null,null,null,null,null,null,null,null,"Swan Valley 2 E",1.6609144677075856,0.19012824578102155,5.541964032056465E-2,0.42794109493705207,7.9]
[null,null,null,null,null,null,null,null,null,"Taylor Ranch",0.56895655521945443,6.6157881675666767E-3,0.53619888949538153,1.2906962711234522,6.1]
[null,null,null,null,null,null,null,null,null,"Tensed",6.0233697814973368,2.3755539416893652,0.65088066576420422,0.11786218203616121,16.73]
[null,null,null,null,null,null,null,null,null,"Tetonia Experiment Sta",1.074367631422307,3.2253833649964279E-2,0.24156147804566375,0.82606977712913277,7.57]
[null,null,null,null,null,null,null,null,null,"Three Creek",1.7772432348222909,0.66743993701231152,0.189650027295139,4.2539001850400028E-2,6.1]
[null,null,null,null,null,null,null,null,null,"Twin Falls 2 NNE",0.62011994001182591,8.7765590733262053E-2,4.0358441709262153E-3,7.7993382720401183E-2,5.49]
[null,null,null,null,null,null,null,null,null,"Twin Falls 3 SE",0.62350812941204858,8.9924399691705875E-2,3.4630074714501967E-3,7.5052143339723862E-2,5.38]
[null,null,null,null,null,null,null,null,null,"Twin Falls KMVT",0.65247568584747639,9.8749339079834228E-2,2.2360732263218856E-3,6.9738936392212278E-2,5.6]
[null,null,null,null,null,null,null,null,null,"Twin Falls WSO",1.0629018846578564,0.27237723012764586,2.1869083439713465E-2,5.8497540529803835E-3,6.19]
[null,null,null,null,null,null,null,null,null,"Wallace",17.774247996260176,11.094270069251742,6.7356052286895851,4.5029744803069187,27.98]
[null,null,null,null,null,null,null,null,null,"Wallace Woodland Park",15.113957655308518,9.0080701018411009,5.1467666469548341,3.2353568389010854,24.79]
[null,null,null,null,null,null,null,null,null,"Warren",6.1469058713522911,2.5365808952362072,0.77085804248189282,0.1819394256516593,14.53]
[null,null,null,null,null,null,null,null,null,"Weiser",1.4641291930793494,0.45734623457815149,8.0212517874606856E-2,2.2366460062280473E-3,7.85]
[null,null,null,null,null,null,null,null,null,"Winchester",4.867437442435004,1.7703761954407113,0.39459833500027425,3.4499071041598738E-2,12.35]
[null,null,null,null,null,null,null,null,null,"Yellow Pine 7 S",7.0135352306277543,3.0384127144525772,1.0237559860112557,0.30169410817506637,17.16]
[null,null,null,null,null,null,null,null,null,"Yellowpine Bar",3.4702801800480496,0.96918759138220112,8.122464081900789E-2,2.3662857423641388E-2,11.15]

{"sheet":"NVALUES","index":8,"n_rows":83,"n_cols":5,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
[{"$f":"IF('CROP N UPTAKE'!B2=\"\",\"\",+'CROP N UPTAKE'!B2)","v":""},{"$f":"IF($A$1=\"\",\"\",VLOOKUP($A$1,$A$3:$E$88,2,FALSE))","v":""},{"$f":"IF($A$1=\"\",\"\",VLOOKUP($A$1,$A$3:$E$88,3,FALSE))","v":""},{"$f":"IF($A$1=\"\",\"\",VLOOKUP($A$1,$A$3:$E$88,4,FALSE))","v":""},{"$f":"IF($A$1=\"\",\"\",VLOOKUP($A$1,$A$3:$E$88,5,FALSE))","v":""}]
[null,"N Uptake","Average Yield","Units of Yield","N+Yield"]
[]
["NORTHERN IDAHO"]
["Alfalfa-Hay, N-ID",0,2,"tons/acre",0]
["Alfalfa-Silage, N-ID",0,3,"tons/acre",0]
["Barley-Spring, N-ID, 21\" or less Precipitation",224,4000,"lbs/acre",0.06]
["Barley-Spring, N-ID, 22-24\" Precipitation",233,4000,"lbs/acre",0.06]
["Barley-Spring, N-ID, 24\" or more Precipitation",241,4000,"lbs/acre",0.06]
["Barley-Winter, N-ID, 21\" or less Precipitation",156,4000,"lbs/acre",0.04]
["Barley-Winter, N-ID, 22-24\" Precipitation",168,4000,"lbs/acre",0.04]
["Barley-Winter, N-ID, 24\" or more Precipitation",184,4000,"lbs/acre",0.05]
["Bluegrass-Seed, N-ID, 19\" or less Precipitation",160,1000,"lbs/acre",0.16]
["Bluegrass-Seed, N-ID, 19-21\" Precipitation",170,1000,"lbs/acre",0.17]
["Bluegrass-Seed, N-ID, 22-24\" Precipitation",185,1000,"lbs/acre",0.19]
["Bluegrass-Seed, N-ID, 24\" or more Precipitation",195,1000,"lbs/acre",0.2]
["Canola-Spring, N-ID",175,2000,"lbs/acre",7.0000000000000007E-2]
["Chickpeas, N-ID",0,1000,"lbs/acre",0]
["Grass-Seeding for Conservation Programs, N-ID, 18\" or less Precipitation",40,2,"tons/acre",0]
["Grass-Seeding for Conservation Programs, N-ID, 18-20\" Precipitation",50,2,"tons/acre",0]
["Grass-Seeding for Conservation Programs, N-ID, 20-22\" Precipitation",55,3,"tons/acre",0]
["Grass-Seeding for Conservation Programs, N-ID, 22\" or more Precipitation",60,3,"tons/acre",0]
["Lentils, N-ID",0,1200,"lbs/acre",0]
["Oats, N-ID",165,4000,"lbs/acre",0.04]
["Pasture-Grass, N-ID, 20\" or less Precipitation",80,2,"tons/acre",10]
["Pasture-Grass, N-ID, 20-22\" Precipitation",100,2,"tons/acre",5]
["Pasture-Grass, N-ID, 22-25\" Precipitation",120,2,"tons/acre",7.5]
["Pasture-Grass, N-ID, 25\" or more Precipitation",135,2,"tons/acre",10]
["Pasture-Grass, N-ID, Irrigated",140,2,"tons/acre",10]
["Pasture-Legume/Grass, N-ID",25,2,"tons/acre",0]
["Peas, N-ID",0,1500,"lbs/acre",0]
["Rapeseed-Winter, N-ID",270,3000,"lbs/acre",7.0000000000000007E-2]
["Wheat-Spring, Hard Red, N-ID, 21\" or less Precipitation",322,100,"bu/acre",3.22]
["Wheat-Spring, Hard Red, N-ID, 22-24\" Precipitation",336,100,"bu/acre",3.36]
["Wheat-Spring, Hard Red, N-ID, 24\" or more Precipitation",350,100,"bu/acre",3.5]
["Wheat-Spring, Soft White, N-ID, 21\" or less Precipitation",230,100,"bu/acre",2.2999999999999998]
["Wheat-Spring, Soft White, N-ID, 22-24\" Precipitation",240,100,"bu/acre",2.4]
["Wheat-Spring, Soft White, N-ID, 24\" or more Precipitation",250,100,"bu/acre",2.5]
["Wheat-Winter, N-ID, 21\" or less Precipitation",250,100,"bu/acre",2.5]
["Wheat-Winter, N-ID, 22-24\" Precipitation",270,100,"bu/acre",2.7]
["Wheat-Winter, N-ID, 24\" or more Precipitation",290,100,"bu/acre",2.9]
["SOUTHERN IDAHO"]
["Alfalfa, Hay,    New Seeding, S-ID, Irrigated",30,6,"tons/acre",0]
["Alfalfa, Hay, S-ID, Irrigated",0,6,"tons/acre",0]
["Alfalfa, New Seeding, S-ID, Irrigated",30,4,"tons/acre",0]
["Barley, Spring, S-ID, Irrigated",180,120,"bu/acre",1.5]
["Barley-Spring, Malting, S-ID, Irrigated",150,120,"bu/acre",1]
["Barley-Winter, S-ID, Irrigated",240,120,"bu/acre",2]
["Beans, Double Cropped, S-ID, Irrigated",50,20,"cwt/acre",0]
["Beans, S-ID, Irrigated",30,20,"cwt/acre",0]
["Corn, Field, Grain, S-ID, Irrigated",245,130,"bu/acre",0.8]
["Corn, Field, Silage, Double Cropped, S-ID, Irrigated",210,20,"tons/acre",4]
["Corn, Field, Silage, S-ID, Irrigated",250,30,"tons/acre",4]
["Corn, Sweet, Processing, S-ID, Irrigated",140,8,"tons/acre",20]
["Corn, Sweet, Seed, S-ID, Irrigated",120,2000,"lbs/acre",0]
["Oats, S-ID, Irrigated",60,60,"bu/acre",1.5]
["Onions (Fumigated), S-ID, Irrigated",140,700,"cwt/acre",0.2]
["Onions (Non-Fumigated), S-ID, Irrigated",140,700,"cwt/acre",0.2]
["Pasture,  Poor Condition, Root Depth 2 feet, S-ID, Irrigated",100,2,"tons/acre",50]
["Pasture, Good Condition-Root Depth 4 feet, S-ID, Irrigated",150,3,"tons/acre",50]
["Peppermint, New Seeding, S-ID, Irrigated",140,60,"lbs/acre",0]
["Peppermint, S-ID, Irrigated",300,90,"lbs/acre",0]
["Potatoes, S-ID, Irrigated",220,350,"cwt/acre",0.4]
["Small Grain-Spring, Hay, S-ID, Irrigated",160,3,"tons/acre",20]
["Small Grain-Spring, Haylage, Double Cropped, S-ID, Irrigated",160,6,"tons/acre",13.3]
["Small Grain-Spring, Haylage, S-ID, Irrigated",160,6,"tons/acre",2]
["Small Grain-Winter, Haylage, Double Cropped, S-ID, Irrigated",160,6,"tons/acre",13.3]
["Small Grain-Winter, Haylage, S-ID, Irrigated",160,6,"tons/acre",13.3]
["Sorghum, Double Cropped, S-ID, Irrigated",210,20,"tons/acre",4]
["Sorghum/Sudan, Double Cropped, S-ID, Irrigated",210,20,"tons/acre",4]
["Sugar Beets, S-ID, Irrigated",210,28,"tons/acre",10]
["Tricale-Winter, S-ID, Irrigated",228,120,"bu/acre",1.7]
["Triticale, Spring, S-ID, Irrigated",240,120,"bu/acre",2]
["Triticale-Spring, Haylage, Double Cropped, S-ID, Irrigated",160,6,"tons/acre",13.3]
["Triticale-Winter,  Haylage, Double Cropped, S-ID, Irrigated",160,6,"tons/acre",13.3]
["Triticale Haylage, Spring, Double Cropped, S-ID, Irrigated",160,6,"tons/acre",13.3]
["Triticale Haylage, Winter, Double Cropped, S-ID, Irrigated",160,6,"tons/acre",13.3]
["Wheat, Spring, Hard Red, S-ID, Irrigated",280,120,"bu/acre",3]
["Wheat-Spring, S-ID, Dryland",117,35,"bu/acre",3.3]
["Wheat-Spring, S-ID, Irrigated",230,120,"bu/acre",1.75]
["Wheat-Winter, Hard Red, S-ID, Irrigated",240,120,"bu/acre",2]
["Wheat-Winter, S-ID, Dryland",324,120,"bu/acre",2.7]
["Wheat-Winter, S-ID, Irrigated",240,120,"bu/acre",2]

{"sheet":"CROP N UPTAKE","index":9,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,2],[3,1,3,2],[5,1,5,2],[1,1,1,4]]}
[null,"Select crop from the list in the cell below, then type in the expected yield to see the N requirement based on the Idaho Fertilizer Guides"]
[]
[null,"Default Average Yield",null,{"$f":"IF(NVALUES!$C$1=0,\"\",+NVALUES!C1)","v":""},{"$f":"IF(NVALUES!$C$1=0,\"\",+NVALUES!D1)","v":""}]
[null,"Expected Yield/acre",null,0,{"$f":"IF(NVALUES!$C$1=0,\"\",+NVALUES!D1)","v":""}]
[]
[null,"Nitrogen-N requirement",null,{"$f":"IF(D4=0,+NVALUES!B1,IF(D4>0,NVALUES!$B$1+(D4-NVALUES!$C$1)*NVALUES!$E$1))","v":""},"lb-N/acre"]

{"sheet":"Assessment Report","index":10,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[15,2,15,3],[15,4,15,12],[27,1,27,3],[27,4,29,12],[24,2,24,3],[25,2,25,3],[26,2,26,3],[24,4,24,12],[25,4,25,12],[16,2,16,3],[22,2,22,3],[20,2,20,3],[21,2,21,3],[18,4,18,12],[19,4,19,12],[21,4,21,12],[16,4,16,12],[30,4,32,12],[33,0,33,12],[31,1,31,3],[23,4,23,12],[30,1,30,3],[29,1,29,3],[23,2,23,3],[28,1,28,3],[18,2,18,3],[17,2,17,3],[17,4,17,12],[32,1,32,3],[11,4,11,12],[12,4,12,12],[13,2,13,3],[5,9,5,12],[5,7,5,8],[5,2,5,6],[6,2,6,6],[7,5,7,6],[7,10,7,11],[9,4,9,12],[10,4,10,12],[0,0,0,12],[2,0,2,12],[1,11,1,12],[4,11,4,12],[3,7,3,8],[4,7,4,8],[1,0,1,1],[1,3,1,7],[3,9,3,12],[4,2,4,6],[3,2,3,6],[35,0,44,12],[8,26,8,28],[9,26,9,28],[26,4,26,12],[10,2,10,3],[11,2,11,3],[12,2,12,3],[34,0,34,12],[8,0,8,12],[13,4,13,12],[14,4,14,12],[9,2,9,3],[20,4,20,12],[22,4,22,12],[19,2,19,3],[14,2,14,3]]}
["Idaho Nutrient Transport Risk Assessment                                ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," ",null,null,{"$f":"B28+B29","v":0}]
["Natural Resource Conservation Service",null,null,"Water Quality Assessment Tool",null,null,null,null,null,null,null,"Version: April 2014",null,null,null,null,null,null,null," ",null,null,null,null,null,"do not delete"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["   Landowner:",null," ",null,null,null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null," "," "," "," "]
["        Planner:",null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null," "," "," "," "]
["Rotation:","                      ",null,null,null,null,null,"Field Office",null,null,null,null,null,null,null,null,null,null,null," "," "]
["Critical Crop:",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,"Tract Number(s):",null,null,null,null,null,null,null,null,null," "]
["Factors Impacting Water Quality ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," "," ",null,null," "]
[null,"RATING","RISK CATEGORY",null,"MITIGATING PRACTICES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," "," ",null,null," "]
["Soil Test P",{"$f":"IF(CALCS!B1=\"\",\"\",CALCS!B1)","v":""},{"$f":"IF(B11=\"\",\"\",VLOOKUP($B11,CONS!$A$1:$B$8,2,FALSE))","v":""},null,{"$f":"IF(C11=\"\",\"\",VLOOKUP($C11,CONS!$A$10:$B$15,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["P Fertlizer Rate",{"$f":"IF(CALCS!B2=\"\",\"\",CALCS!B2)","v":""},{"$f":"IF(B12=\"\",\"\",VLOOKUP($B12,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C12=\"\",\"\",VLOOKUP($C12,CONS!$A$10:$C$15,3,FALSE))","v":""}]
["P Fertilizer Method",{"$f":"IF(CALCS!B3=\"\",\"\",CALCS!B3)","v":""},{"$f":"IF(B13=\"\",\"\",VLOOKUP($B13,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C13=\"\",\"\",VLOOKUP($C13,CONS!$A$10:$Q$15,4,FALSE))","v":""}]
["P Organic Rate",{"$f":"IF(CALCS!B4=\"\",\"\",CALCS!B4)","v":""},{"$f":"IF(B14=\"\",\"\",VLOOKUP($B14,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C14=\"\",\"\",VLOOKUP($C14,CONS!$A$10:$Q$15,5,FALSE))","v":""}]
["P Organic Method",{"$f":"IF(CALCS!B5=\"\",\"\",CALCS!B5)","v":""},{"$f":"IF(B15=\"\",\"\",VLOOKUP($B15,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C15=\"\",\"\",VLOOKUP($C15,CONS!$A$10:$Q$15,6,FALSE))","v":""}]
["Soil Test N",{"$f":"IF(CALCS!I19=\"\",\"\",CALCS!I19)","v":""},{"$f":"IF(B16=\"\",\"\",VLOOKUP($B16,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C16=\"\",\"\",VLOOKUP($C16,CONS!$A$10:$R$15,18,FALSE))","v":""}]
["N Fertilizer Rate",{"$f":"IF(CALCS!B6=\"\",\"\",CALCS!B6)","v":""},{"$f":"IF(B17=\"\",\"\",VLOOKUP($B17,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C17=\"\",\"\",VLOOKUP($C17,CONS!$A$10:$Q$15,7,FALSE))","v":""}]
["N Fertilizer Timing ",{"$f":"IF(CALCS!B7=\"\",\"\",CALCS!B7)","v":""},{"$f":"IF(B18=\"\",\"\",VLOOKUP($B18,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C18=\"\",\"\",VLOOKUP($C18,CONS!$A$10:$Q$15,8,FALSE))","v":""}]
["N Fertilizer Method",{"$f":"IF(CALCS!B8=\"\",\"\",CALCS!B8)","v":""},{"$f":"IF(B19=\"\",\"\",VLOOKUP($B19,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C19=\"\",\"\",VLOOKUP($C19,CONS!$A$10:$Q$15,9,FALSE))","v":""}]
["Runoff Class",{"$f":"IF(CALCS!B10=\"\",\"\",CALCS!B10)","v":""},{"$f":"IF(B20=\"\",\"\",VLOOKUP($B20,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C20=\"\",\"\",VLOOKUP($C20,CONS!$A$10:$Q$15,10,FALSE))","v":""}]
["Irrigation Runoff Index",{"$f":"IF(CALCS!B14=\"\",\"\",CALCS!B14)","v":""},{"$f":"IF(B21=\"\",\"\",VLOOKUP($B21,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C21=\"\",\"\",VLOOKUP($C21,CONS!$A$10:$Q$15,17,FALSE))","v":""}]
["Runoff BMPs (level of use, not risk)",{"$f":"IF(CALCS!E11=\"\",\"\",CALCS!E11)","v":""},{"$f":"IF(B22=\"\",\"\",VLOOKUP($B22,CONS!$C$1:$D$7,2,FALSE))","v":""},null,{"$f":"IF(C22=\"\",\"\",VLOOKUP($C22,CONS!$A$23:$B$27,2,FALSE))","v":""}]
["Irrigation Index (for deep percolation)",{"$f":"IF(CALCS!B12=\"\",\"\",CALCS!B12)","v":""},{"$f":"IF(B23=\"\",\"\",VLOOKUP($B23,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C23=\"\",\"\",VLOOKUP($C23,CONS!$A$10:$Q$15,12,FALSE))","v":""}]
["Leaching Index (non-growing season risk)",{"$f":"IF(CALCS!B13=\"\",\"\",CALCS!B13)","v":""},{"$f":"IF(B24=\"\",\"\",VLOOKUP($B24,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C24=\"\",\"\",VLOOKUP($C24,CONS!$A$10:$Q$15,13,FALSE))","v":""}]
["Distance",{"$f":"IF(CALCS!B15=\"\",\"\",CALCS!B15)","v":""},{"$f":"IF(B25=\"\",\"\",VLOOKUP($B25,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C25=\"\",\"\",VLOOKUP($C25,CONS!$A$10:$Q$15,14,FALSE))","v":""}]
["Soil Properties",{"$f":"IF(CALCS!B16=\"\",\"\",CALCS!B16)","v":""},{"$f":"IF(B26=\"\",\"\",VLOOKUP($B26,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C26=\"\",\"\",VLOOKUP($C26,CONS!$A$10:$Q$15,15,FALSE))","v":""}]
["Soil Erosion",{"$f":"IF(CALCS!B17=\"\",\"\",CALCS!B17)","v":""},{"$f":"IF(B27=\"\",\"\",VLOOKUP($B27,CONS!$A$1:$B$7,2,FALSE))","v":""},null,{"$f":"IF(C27=\"\",\"\",VLOOKUP($C27,CONS!$A$10:$Q$15,16,FALSE))","v":""}]
["Total Points for Surface Water - P:",{"$f":"CALCS!G2","v":0},null,null,"< These numbers are a product of the rating and the weighting factors."]
["Total Points for Surface Water - N:",{"$f":"CALCS!I2","v":0}]
["Total Points for Ground Water:",{"$f":"CALCS!H2","v":0}]
["Overall Risk Level for Surface Water Quality - Phosphorus:",{"$f":"IF(B28<10,\"LOW\",(IF(B28>65,\"VERY HIGH\",(IF(B28>28,\"HIGH\",\"MEDIUM\")))))","v":"LOW"},null,null,"If Risk Level is not LOW, then appropriate mitigating practices are required in order to meet Quality Criteria for Surface Water Quality and/or Ground Water Quality. Conservation practices and management techniques need to be incorporated into planning alternatives in order to address source and transport problems. Nutrient Management (590) and Irrigation Water Management (449) (if irrigated) are MANDATORY mitigating practices. Additional required practices are indicated above for individual factors."]
["Overall Risk Level for Surface Water Quality - Nitrogen:",{"$f":"IF(B29<9,\"LOW\",(IF(B29>50,\"VERY HIGH\",(IF(B29>27,\"HIGH\",\"MEDIUM\")))))","v":"LOW"}]
["Overall Risk Level for Ground  Water Quality:",{"$f":"IF(CALCS!H2<10,\"LOW\",(IF(CALCS!H2>40,\"VERY HIGH\",(IF(CALCS!H2>21,\"HIGH\",\"MEDIUM\")))))","v":"LOW"}]
["Regardless of the final risk level, any individual factor with a High or Very High rating should be evaluated. Conservation practices should be applied, where possible, to address these factors (see recommendations in MITIGATING PRACTICES for each factor). Explain what needs to be done in the INTERPRETATION below."]
["INTERPRETATION: What are the mitigating practices needed to achieve water quality criteria?"]