{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Title","FIRI Worksheet","Detailed report","Summary Report","System_Descript","Factors","Development notes"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Title","index":0,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,2,8,17],[24,3,25,14],[26,3,32,14],[37,3,46,14],[35,7,36,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Revision date:",{"$f":"MAX('Development notes'!A9:A700)","v":"2015-03-23"}]
[]
[null,null,"Farm Irrigation Rating Index (FIRI) 2015.1.01"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"-------------------------------------     DISCLAIMER     ---------------------------------------"]
[]
[null,null,null,"Although this Design Sheet has been tested by its developers, The program is distrubted on an \"AS IS Basis\". No Warranty, expressed or implied, is made as to the accuracy or functioning of the program and related program materials or output nor shall the fact of distribution constitute any such warranty. NO responsibility is assumed by the developers in connection or use of the progam therewith. Any Modifications and any subsequent ouput are solely the responsibility of the person or persons who made the modifications.   "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Development of FIRI"]
[]
[null,null,null,"FIRI, a uniform and objective evaluation method for planning irrigation water· conservation and identifying ground water and surface water pollution potential. It was developed at the USDA, Soil Conservation Service, West National Technical Center; Portland, OR. Input and review was provided by Agronomists, Resource Conservationists, Irrigation Engineers, Water Quality Specialists, and Water Resource Planners from the western states and other NTC's. Much of the basic data and procedure originated as a result of a westwide water conservation emphasis program during the 1980's. Several western states and a national SCS committee initiated the development of an irrigation system evaluation method to estimate water conservation based on system improvements. FIRI is a result of these efforts. In 2004 The computation method was changed to Statistical method to better reflect the interaction multiple components had on each other."]

{"sheet":"FIRI Worksheet","index":1,"n_rows":233,"n_cols":44,"rows_kept":233,"cut":false,"hidden":false,"merged":[[44,4,47,13],[2,3,2,13],[3,10,3,11],[4,11,4,13],[0,3,0,13],[16,4,16,6],[43,4,43,5],[39,4,39,5],[43,9,43,10],[39,9,39,10],[31,4,32,5],[33,4,33,5],[36,4,36,5],[31,12,32,12],[36,9,36,10],[37,9,37,10],[21,9,21,11],[17,4,17,5],[18,4,18,5],[21,4,21,6],[18,9,18,10],[17,9,17,10],[19,9,19,11],[20,9,20,11],[20,4,20,6],[25,9,25,11],[22,4,22,6],[23,4,23,6],[25,4,25,6],[24,4,24,6],[22,9,22,11],[23,9,23,11],[24,9,24,11],[1,5,1,13],[3,3,3,5],[3,7,3,8],[1,3,1,4],[4,9,4,10],[12,4,12,6],[13,4,13,6],[12,9,12,11],[13,9,13,11],[14,9,14,11],[14,4,14,6],[6,9,6,12],[16,9,16,11],[9,9,9,11],[10,9,10,11],[7,9,7,11],[11,9,11,11],[0,1,2,2],[3,1,3,2],[4,1,4,2],[9,1,14,1],[16,1,25,1],[17,2,18,2],[6,2,7,3],[6,1,7,1],[17,3,18,3],[4,3,4,4],[19,4,19,6],[6,4,6,7],[7,4,7,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[31,6,32,6],[31,7,32,8],[39,2,41,2],[39,6,39,7],[29,4,29,5],[31,2,32,3],[33,2,33,3],[31,1,41,1],[36,2,37,2],[27,1,29,1],[39,11,39,12],[35,12,35,13],[27,6,28,6],[27,7,28,7],[27,11,28,11],[33,9,33,10],[31,9,32,10],[28,9,28,10],[27,12,28,12],[29,9,29,10],[33,7,33,8],[37,4,37,5],[28,4,28,5]]}
[null,"NRCS",null,"Farm Irrigation Rating Tool 2015.1"]
[]
[null,null,null,"       Natural Resources Conservation Service (NRCS)   "]
[null,"Client:",null,null,null,null,"Planner:",null,null,"Location:",null,null,"Date:",{"$f":"TODAY()","v":"2015-03-24"}]
[null,"Tract No.",null,null,null," Farm No.",null,"Field No.",null,"Field Name/description:"]
[]
[null,"System ","Irrigation Type",null,"Present Condition",null,null,null,null,"Planned Condition"]
[null,null,null,null,"",null,null,{"$f":"IF(E8<>\"\",VLOOKUP(E8,$AE$113:$AF$146,2,FALSE)*100,\"\")","v":""},null,"",null,null,{"$f":"IF(J8<>\"\",VLOOKUP(J8,$AE$113:$AF$146,2,FALSE)*100,\"\")","v":""},{"$f":"IF(M10=\"\",\"\",(1-M10)^2)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Management Factors","Measurement","Md",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($E10,$AE$40:$AF$44,2,0)),\"\",VLOOKUP($E10,$AE$40:$AF$44,2,0))","v":""},{"$f":"IF(H10=\"\",\"\",(1-H10)^2)","v":""},null,null,null,{"$f":"IF(ISERROR(VLOOKUP($J10,$AE$40:$AF$44,2,0)),\"\",VLOOKUP($J10,$AE$40:$AF$44,2,0))","v":""},""]
[null,null,"Scheduling","S",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($E11,$AE$47:$AF$54,2,0)),\"\",VLOOKUP($E11,$AE$47:$AF$54,2,0))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($J11,$AE$47:$AF$54,2,0)),\"\",VLOOKUP($J11,$AE$47:$AF$54,2,0))","v":""},""]
[null,null,"Skill","I",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($E12,$AE$57:$AF$59,2,0)),\"\",VLOOKUP($E12,$AE$57:$AF$59,2,0))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($J12,$AE$57:$AF$59,2,0)),\"\",VLOOKUP($J12,$AE$57:$AF$59,2,0))","v":""},""]
[null,null,"Maintenance","M",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($E13,$AE$149:$AF$152,2,0)),\"\",VLOOKUP($E13,$AE$149:$AF$152,2,0))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($J13,$AE$149:$AF$152,2,0)),\"\",VLOOKUP($J13,$AE$149:$AF$152,2,0))","v":""},""]
[null,null,"Delivery","D",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($E14,$AE$158:$AF$167,2,0)),\"\",VLOOKUP($E14,$AE$158:$AF$167,2,0))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($J14,$AE$158:$AF$167,2,0)),\"\",VLOOKUP($J14,$AE$158:$AF$167,2,0))","v":""}]
[null,null,"Soil","Sc",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($E15,$AE$62:$AF$72,2,0)),\"\",VLOOKUP($E15,$AE$62:$AF$72,2,0))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($J15,$AE$62:$AF$72,2,0)),\"\",VLOOKUP($J15,$AE$62:$AF$72,2,0))","v":""}]
[]
[null,"System Design  Factors","Water Distribution Control","Wc",null,null,null,{"$f":"IF(ISERROR(VLOOKUP($E17,$AE$75:$AF$78,2,0)),\"\",VLOOKUP($E17,$AE$75:$AF$78,2,0))","v":""},{"$f":"IF(H17=\"\",\"\",(1-H17)^2)","v":""},null,null,null,{"$f":"IF(ISERROR(VLOOKUP($J17,$AE$75:$AF$78,2,0)),\"\",VLOOKUP($J17,$AE$75:$AF$78,2,0))","v":""},{"$f":"IF(M17=\"\",\"\",(1-M17)^2)","v":""}]
[null,null,"Conveyance","Ce","              Material",null,"Length(ft)",null,null,"             Material",null,"Length(ft)"]
[null,null,null,null,null,null,null,{"$f":"IF(E19=\"Multiple\",AG80^(G19/1000),IF(ISERROR(VLOOKUP($E19,$AE$81:$AF$88,2,0)^(G19/1000)),\"\",VLOOKUP($E19,$AE$81:$AF$88,2,0)^(G19/1000)))","v":""},{"$f":"IF(H19=\"\",\"\",(1-H19)^2)","v":""},null,null,null,{"$f":"IF(J19<>\"Multiple\",IF(ISERROR(VLOOKUP($J19,$AE$81:$AF$88,2,0)^(L19/1000)),\"\",VLOOKUP($J19,$AE$81:$AF$88,2,0)^(L19/1000)),AH80^(L19/1000))","v":""},""]
[null,null,"Land Leveling","L",null,null,null,null,{"$f":"IF(H20=\"\",\"\",(1-H20)^2)","v":""},null,null,null,null,""]
[null,null,"Tailwater reuse","R",null,null,null,{"$f":"IF(E21=\"\",\"\",IF(ISERROR($H$8*$I$27),\"\",tailwater(E21*100,H8*I27)))","v":""},{"$f":"IF(H21=\"\",1,IF(H21>1,-1*(1-H21)^2,(1-H21)^2))","v":1},null,null,null,{"$f":"IF(J21=\"\",\"\",IF(ISERROR($M$8*$N$27),\"\",tailwater(J21*100,M8*N27)))","v":""},{"$f":"IF(M21=\"\",\"\",IF(M21>1,-1*(1-M21)^2,(1-M21)^2))","v":""}]
[null,null,"Climate","C",null,null,null,{"$f":"IF(OR(E22=\"Surface System N/A\",E22=\"Non-Spray (LEPA) or Point Source Drip N/A\"),\"\",IF(ISERROR(VLOOKUP($E22,$AE$169:$AF$175,2,FALSE)),\"\",VLOOKUP($E22,$AE$169:$AF$175,2,FALSE)))","v":""},{"$f":"IF(H22=\"\",\"\",IF(H22>1,-1*(1-H22)^2,(1-H22)^2))","v":""},null,null,null,{"$f":"IF(OR(J22=\"Surface System N/A\",J22=\"Non-Spray (LEPA) or Point Source Drip N/A\"),\"\",IF(ISERROR(VLOOKUP($J22,$AE$169:$AF$175,2,0)),\"\",VLOOKUP($J22,$AE$169:$AF$175,2,0)))","v":""},{"$f":"IF(M22=\"\",\"\",IF(M22>1,-1*(1-M22)^2,(1-M22)^2))","v":""}]
[null,null,"Wind","W",null,null,null,{"$f":"IF(OR(E23=\"Surface System N/A\",E23=\"Non-Spray (LEPA) or Point Source Drip N/A\"),\"\",IF(ISERROR(VLOOKUP($E23,$AE$177:$AF$189,2,0)),\"\",VLOOKUP($E23,$AE$177:$AF$189,2,0)))","v":""},{"$f":"IF(H23=\"\",\"\",(1-H23)^2)","v":""},null,null,null,{"$f":"IF(OR(J23=\"Surface System N/A\",J23=\"Non-Spray (LEPA) or Point Source Drip N/A\"),\"\",IF(ISERROR(VLOOKUP($J23,$AE$177:$AF$189,2,0)),\"\",VLOOKUP($J23,$AE$177:$AF$189,2,0)))","v":""},""]
[null,null,"Sprinkler","Sd",null,null,null,{"$f":"IF(OR(E24=\"Surface System N/A\",E24=\"Micro System N/A\"),\"\",IF(ISERROR(VLOOKUP($E24,$AE$190:$AF$197,2,FALSE)),\"\",VLOOKUP($E24,$AE$190:$AF$197,2,FALSE)))","v":""},{"$f":"IF(H24=\"\",\"\",(1-H24)^2)","v":""},null,null,null,{"$f":"IF(OR(J24=\"Surface System N/A\",J24=\"Micro System N/A\"),\"\",IF(ISERROR(VLOOKUP($J24,$AE$190:$AF$197,2,FALSE)),\"\",VLOOKUP($J24,$AE$190:$AF$197,2,FALSE)))","v":""},""]
[null,null,"Emitter","E",null,null,null,{"$f":"IF(OR($E$25=\"Surface System N/A\",$E$25=\"Surface or Sprinkler System  N/A\"),\"\",IF(ISERROR(VLOOKUP($E25,$AE$198:$AF$220,2,FALSE)),\"\",VLOOKUP($E25,$AE$198:$AF$220,2,FALSE)))","v":""},{"$f":"IF(H25=\"\",\"\",(1-H25)^2)","v":""},null,null,null,{"$f":"IF(OR(J25=\"Surface System N/A\",J25=\"Surface or Sprinkler System  N/A\"),\"\",IF(ISERROR(VLOOKUP($J25,$AE$198:$AF$220,2,FALSE)),\"\",VLOOKUP($J25,$AE$198:$AF$220,2,FALSE)))","v":""},""]
[null,null,"Drip-Micro","T",null,null,null,{"$f":"IF(OR(E26=\"Surface System N/A\",E26=\"Surface or Sprinkler System N/A\"),\"\",IF(ISERROR(VLOOKUP($E26,$AE$219:$AF$233,2,FALSE)),\"\",VLOOKUP($E26,$AE$219:$AF$233,2,FALSE)))","v":""},{"$f":"IF(H26=\"\",\"\",(1-H26)^2)","v":""},null,null,null,{"$f":"IF(OR(J26=\"Surface System N/A\",J26=\"Surface or Sprinkler System N/A\"),\"\",IF(ISERROR(VLOOKUP($J26,$AE$219:$AF$233,2,FALSE)),\"\",VLOOKUP($J26,$AE$219:$AF$233,2,FALSE)))","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"(1-SQRT(SUM(I9:I15,I17:I20,I22:I26)))","v":1},null,null,null,null,{"$f":"(1-SQRT(SUM(N8:N13,N17:N20,N22:N26)))","v":1}]
[null,"FIRI Rating",null,null,null,null,"Percent of maximum potential rating","Meets Quality Criteria",null,null,null,"Percent of maximum potential rating","Meets Quality Criteria"]
[null,null,null,null,"Rating Value",null,null,null,null,"Rating Value"]
[null,null,null,null,{"$f":"IF(ISERROR(H8*I27),\"\",IF( H21<>\"\",H8*H21*I27,H8*I27))","v":""},null,{"$f":"IF(ISERROR(E30/H8),\"\",E30/H8)","v":""},null,null,{"$f":"IF(ISERROR(M8*N27),\"\",IF(M21<>\"\",M8*M21*N27,M8*N27))","v":""},null,{"$f":"IF(ISERROR(J30/M8),\"\",J30/M8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intake categories"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEFT(J$8,4)<>\"Micr\", 0,IF(AND(LEFT(J$8,4)=\"Micr\",LEFT($G$34,3)=\"Med\"),VLOOKUP(J8,$AE$113:$AK$146,5,FALSE),IF(AND(LEFT(J8,4)=\"Micr\",LEFT($G$34,3)=\"Low\"),VLOOKUP(J$8,$AE$113:$AK$146,7,FALSE))))","v":0}]
[null,"Water Quantity","Climatic region/zone",null,"Soil description",null,"Soil intake Characteristic","Major crop grown",null,"Annual Net Irrigation Requirement (inches)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Intake Open Porous Soils"]
[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,"Medium Intake Loam Soils"]
[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,"Low Intake Fine Textured Soils"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Change in Gross Water Applied "]
[null,null,{"$f":"IF(M32=\"\",\"\",\"Limited water supply\")","v":""},null,{"$f":"IF($J$34=\"\",\"\",IF($M$34=\"\",\"Estimated Gross Irrigation Required (in)\",\"Maximum Available Gross Irrigation (in)\"))","v":""},null,{"$f":"IF($J$34=\"\",\"\",IF($M$34=\"\",\"Net Irrigation Requirement (in)\",\"Net Irrigation Available\"))","v":""},null,null,{"$f":"IF($J$34=\"\",\"\",IF($M$34=\"\",\"Estimated Gross Irrigation Required (in)\",IF($J$34/J30*100>M34,\"Maximum Available Gross Irrigation (in)\",\"Estimated Gross Irrigation Required (in)\")))","v":""},null,{"$f":"IF($J$34=\"\",\"\",IF($M$34=\"\",\"Net Irrigation Requirement (in)\",\"Net Irrigation Available\"))","v":""},"    (ac-in/ac)","Percent (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Enhancement Category",null,"iwm"]
[null,null,null,null,{"$f":"IF(OR(ISERROR($M$34/E30),$J$34=\"\"),\"\",IF($M$34=\"\",$J$34/E30*100,IF($J$34/E30*100>$M$34,$M$34,$J$34/E30*100)))","v":""},null,{"$f":"IF(OR(ISERROR($M$34*E30/100),J34=\"\"),\"\",IF($M$34=\"\",$J$34,IF($M$34*E30/100<$J$34,$M$34*E30/100,$J$34)))","v":""},null,null,{"$f":"IF(OR(ISERROR($M$34/J30),$J$34=\"\"),\"\",IF($M$34=\"\",$J$34/J30*100,IF($J$34/J30*100>$M$34,$M$34,$J$34/J30*100)))","v":""},null,{"$f":"IF(OR(ISERROR($M$34*J30/100),J34=\"\"),\"\",IF($M$34=\"\",$J$34,IF($M$34*J30/100<$J$34,$M$34*J30/100,$J$34)))","v":""},{"$f":"IF(AND(J34<>\"\",E38<>\"\",J38<>\"\"), J38-E38,\"\")","v":""},{"$f":"IF(ISERROR(M38/(J34/E30*100)),\"\",ABS(M38/(J34/E30*100)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigation Enhancement Action","Rating"]
[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,"Improved Water Measurement"]
[null,null,"Excess water applied going to",null,{"$f":"IF(AO113<>\"\",\"User defined percentages\",\"     Default percentages\")","v":"     Default percentages"},null,"Estimated faction of excess water going to (ac-in/ac)",null,null,{"$f":"IF(AS113<>\"\",\"User defined percentages\",\"     Default percentages\")","v":"     Default percentages"},null,"Estimated fraction of excess water going to  (ac-in/ac)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No flow measuring devices",0.9]
[null,null,null,null,"Runoff (%)","Deep percolation /leaching (%)","Runoff","Deep Percolation",null,"Runoff (%)","Deep percolation /leaching (%)","Runoff","Deep Percolation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow measurement - whole farm-manually recorded",0.93]
[null,null,null,null,{"$f":"IF(AM113=\"\",\"\",IF(AO113=\"\",AM113,AO113))","v":""},{"$f":"IF(AN113=\"\",\"\",IF(AP113=\"\",AN113,AP113))","v":""},{"$f":"IF($G$38>=$J$34,IF(ISERROR(($J$34/$E$30*100-$J$34)*$E$42/100),\"\",($J$34/$E$30*100-$J$34)*$E$42/100),($G$38/$E$30*100-$G$38)*$E$42/100)","v":""},{"$f":"IF($G$38>=$J$34,IF(ISERROR(($J$34/$E$30*100-$J$34)*$F$42/100),\"\",($J$34/$E$30*100-$J$34)*$F$42/100),($G$38/$E$30*100-$G$38)*$F$42/100)","v":""},null,{"$f":"IF(AQ113=\"\",\"\",IF(AS113=\"\",AQ113,AS113))","v":""},{"$f":"IF(AR113=\"\",\"\",IF(AT113=\"\",AR113,AT113))","v":""},{"$f":"IF($L$38>=$J$34,IF(ISERROR(($J$34/$J$30*100-$J$34)*$J$42/100),\"\",($J$34/$J$30*100-$J34)*$J$42/100),($L$38/$J$30*100-$L$38)*$J$42/100)","v":""},{"$f":"IF($L$38>=$J$34,IF(ISERROR(($J$34/$J$30*100-$J$34)*$K$42/100),\"\",($J$34/$J$30*100-$J$34)*$K$42/100),($L$38/$J$30*100-$L$38)*$K$42/100)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow measurement - whole farm-automatic recorded",0.95]
[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,"Flow measurement - whole farm plus individual field manual recorded",0.97]
[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,"Flow measurement - whole farm plus individual field automatic recorded",1]
[null,null,null,"Notes:"]
[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,"Improved Soil Moisture Monitoring and Irrigation Scheduling"]
[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,"None",0.9]
[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,"Visual crop stress",0.94]
[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 moisture by NRCS feel method",0.95]
[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,"Check book scheduling, irrigation scheduler, etc.",0.95]
[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,"Irrigation scheduling via pan evaporation or atmometer for field",0.96]
[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,"Irrigation scheduling via regional weather network",0.97]
[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 moisture using Gypsum blocks, moisture probe, etc.",0.98]
[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,"Continuous measurement of soil moisture, water applied and ET",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,"Irrigation skill and Action"]
[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,"Significant over-irrigation",0.8]
[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,"Good-Lack of full attention ",0.92]
[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,"Following IWM plan",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,"Improved Soil Condition Index"]
[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 Condition Index from SCI = -1 or lower",0.9]
[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 Condition Index from SCI = -0.8",0.91]
[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 Condition Index from SCI = -0.6",0.92]
[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 Condition Index from SCI = -0.4",0.93]
[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 Condition Index from SCI = -0.2",0.94]
[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 Condition Index from SCI = 0",0.95]
[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 Condition Index from SCI = 0.3",0.96]
[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 Condition Index from SCI = 0.6",0.97]
[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 Condition Index from SCI = 0.8",0.98]
[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 Condition Index from SCI = 1.12",0.99]
[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 Condition Index from SCI = 1.4 or more",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,"Improved Distribution System"]
[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,"Very poor diversion facilities.  Little control of flow rate to farm.",0.9]
[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,"Can control flow rates to farm, but the on farm delivery system is such that it is very hard to deliver the desired flow to any given field.",0.94]
[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,"Flow rates to each field are adequately controlled. Flow rates to each set are difficult to control.",0.98]
[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,"All flow rates to each set are adequately controlled.",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,"Improved Conveyance system",null,null,0.92833333333333334,0.80727272727272725]
[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,"Open ditch or canal - very gravelly",0.8]
[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,"Open ditch or canal - sand/gravel",0.88]
[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,"Open ditch or canal - sand",0.95]
[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,"Open ditch or canal - sandy/loam",0.97]
[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,"Open ditch or canal - clay/silt loam",0.99]
[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,"Open ditch or canal - clay soil",0.995]
[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,"Open canal - lined",0.998]
[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,"Closed conduit pipeline",0.999]
[]
[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,"Improved Land Leveling"]
[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,"Unleveled-Not Proper Run length",0.75]
[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,"Unleveled-Proper Run length",0.8]
[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,"Land smoothed",0.9]
[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,"Land leveled",0.94]
[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,"Land precision leveled ",0.98]
[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,"Land precision leveled - slope <= .005",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,"A sprinkler or drip system is utilized",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,"Adding Tail water recovery with and without irrigation storage reservoirs","Tail water Reuse @ 50% Efficiency"]
[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,0,"Calculated"]
[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,0.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,0.2]
[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,0.3]
[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,0.4]
[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,0.5]
[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,0.6]
[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,0.7]
[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,0.8]
[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,0.9]
[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,"Irrigation System Type",null,"PE","High Intake Open Porous Soils","Medium Intake Loam Soils","Mlateral","Low Intake Fine textured Soils","Llateral"]
[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,"Border - Graded Border",0.8,85,50,null,15,null,null,{"$f":"IF(ISERROR(100-AN113),\"\",IF(LEFT(E$8,4)<>\"Micr\", 100-AN113,IF(AND(LEFT(E$8,4)=\"Micr\",LEFT($G$34,3)=\"Med\"),100-AN113-VLOOKUP(E8,$AE$113:$AK$146,5,FALSE),IF(AND(LEFT(E8,4)=\"Micr\",LEFT($G$34,3)=\"Low\"),100-AN113-VLOOKUP(E$8,$AE$113:$AK$146,7,FALSE)))))","v":""},{"$f":"IF(ISERROR(IF($G$34=\"High Intake Open Porous Soils\",VLOOKUP(E$8,$AE$113:$AK$146,3,FALSE),IF($G$34=\"Medium Intake Loam Soils\",VLOOKUP(E$8,$AE$113:$AK$146,4,FALSE),IF($G$34=\"Low Intake Fine textured Soils\",VLOOKUP(E$8,$AE$113:$AK$146,6,FALSE),\"\")))),\"\",IF(G34=\"High Intake Open Porous Soils\",VLOOKUP(E$8,$AE$113:$AK$146,3,FALSE),IF($G$34=\"Medium Intake Loam Soils\",VLOOKUP(E$8,$AE$113:$AK$146,4,FALSE),IF($G$34=\"Low Intake Fine textured Soils\",VLOOKUP(E$8,$AE$113:$AK$146,6,FALSE),\"\"))))","v":""},null,null,{"$f":"IF(ISERROR(100-AR113),\"\",IF(LEFT(J$8,4)<>\"Micr\", 100-AR113,IF(AND(LEFT(J$8,4)=\"Micr\",LEFT($G$34,3)=\"Med\"),100-AR113-VLOOKUP(J8,$AE$113:$AK$146,5,FALSE),IF(AND(LEFT(J8,4)=\"Micr\",LEFT($G$34,3)=\"Low\"),100-AR113-VLOOKUP(J$8,$AE$113:$AK$146,7,FALSE)))))","v":""},{"$f":"IF(ISERROR(IF($G$34=\"High Intake Open Porous Soils\",VLOOKUP(J$8,$AE$113:$AK$146,3,FALSE),IF($G$34=\"Medium Intake Loam Soils\",VLOOKUP(J$8,$AE$113:$AK$146,4,FALSE),IF($G$34=\"Low Intake Fine textured Soils\",VLOOKUP(J$8,$AE$113:$AK$146,6,FALSE),\"\")))),\"\",IF($G$34=\"High Intake Open Porous Soils\",VLOOKUP(J$8,$AE$113:$AK$146,3,FALSE),IF($G$34=\"Medium Intake Loam Soils\",VLOOKUP(J$8,$AE$113:$AK$146,4,FALSE),IF($G$34=\"Low Intake Fine textured Soils\",VLOOKUP(J$8,$AE$113:$AK$146,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,null,null,null,null,null,"Border - Level or Basin",0.9,100,100,null,100]
[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,"Border - Guide",0.7,85,50,null,15]
[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,"Border - Contour Level field crop",0.7,100,100,null,100]
[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,"Border - Contour - Level Rice",0.8,100,100,null,100]
[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,"Border - Contour - Level Rice - Side Inlets",0.85,100,100,null,100]
[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,"Border - Border Ditch",0.6,85,50,null,15]
[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,"Furrow - Level or Basin",0.9,100,100,null,100]
[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,"Furrow - Graded Furrow",0.75,85,50,null,15]
[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,"Furrow - Contour furrow",0.75,85,50,null,15]
[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,"Furrow - Corrugations",0.75,85,50,null,15]
[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,"Furrow - Surge",0.8,85,50,null,15]
[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,"Subirrigation - Subirrigated",0.75,100,100,null,100]
[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,"Flood - Controlled",0.6,85,50,null,15]
[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,"Flood - Uncontrolled",0.5,85,50,null,15]
[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,"Flood - Contour Ditch",0.6,85,50,null,15]
[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,"Sprinkler - Big Gun or Boom",0.6,90,65,null,30]
[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,"Sprinkler - Hand Line or Wheel Line",0.7,90,65,null,30]
[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,"Sprinkler - Solid Set (above canopy)",0.75,90,65,null,30]
[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,"Sprinkler - Solid Set (below canopy)",0.8,90,65,null,30]
[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,"Center Pivot",0.8,90,65,null,30]
[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,"Center Pivot (Low Pressure Improved)",0.82,90,65,null,30]
[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,"Center Pivot - Low Pressure Precision Application (LEPA)",0.92,90,65,null,30]
[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,"Center Pivot - Low Elevation Spray Application (LESA)",0.89,90,65,null,30]
[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,"Center Pivot - Low Pressure In Canopy (LPIC)",0.87,90,65,null,30]
[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,"Center Pivot - Mid Elevation Spray application(MESA)",0.85,90,65,null,30]
[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,"Center Pivot - Variable Rate Irrigation (VRI)",0.87,90,65,null,30]
[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,"Lateral Move ",0.82,90,65,null,30]
[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,"Lateral Move (LEPA, LESA, LPIC, MESA)",0.87,90,65,null,30]
[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,"Lateral Move (VRI)",0.87,90,65,null,30]
[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,"Micro, Point Source",0.9,100,50,30,20,20]
[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,"Micro, Sprays",0.85,100,50,30,20,20]
[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,"Micro, Continuous Tape",0.9,100,50,30,20,20]
[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,"Micro, Subsurface Drip Irrigation (SDI)",0.92,100,50,50,20,80]
[]
[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,"Maintenance Factor"]
[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,"Poor",0.9]
[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,"Fair",0.94]
[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,"Good",0.98]
[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,"Excellent",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,"future",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,"future",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,"future",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,"Water Delivery"]
[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,"Rotation -- Limited",0.8]
[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,"Rotation -- Fixed",0.83]
[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,"Rotation -- Modified frequency",0.85]
[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,"Rotation -- Modified amount",0.88]
[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,"Arranged -- Fixed duration",0.9]
[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,"Arranged -- Restricted",0.93]
[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,"Arranged -- Limited rate",0.96]
[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,"Arranged -- Arranged",0.97]
[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,"Demand -- Limited rate",0.98]
[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,"Demand -- Unrestricted",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,"Climatic Factor"]
[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,"Surface System N/A"]
[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,"Non-Spray (LEPA) or Point Source Drip N/A"]
[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,"Cool -- peak avg et 0.15",1.01]
[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,"Warm -- peak avg et 0.30",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,"Hot -- peak avg et 0.45",0.98]
[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,"Hot -- peak avg et 0.6",0.95]
[]
[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,"Wind Factor"]
[]
[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,"Surface System N/A"]
[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,"Non-Spray (LEPA) or Point Source Drip N/A"]
[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,"Fine spray wind speed 1- 4 MPH",0.94]
[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,"Fine spray wind speed 4 -10 MPH",0.9]
[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,"Fine spray wind speed > 10 MPH",0.87]
[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,"Medium spray wind speed 1- 4 MPH",0.96]
[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,"Medium spray wind speed 4 -10 MPH",0.93]
[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,"Medium spray wind speed > 10 MPH",0.91]
[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,"Coarse spray wind speed 1- 4 MPH",0.98]
[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,"Coarse spray wind speed 4 -10 MPH",0.96]
[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,"Coarse spray wind speed > 10 MPH",0.96]
[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,"Sprinkler Factor"]
[]
[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,"Surface System N/A"]
[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,"Micro System N/A"]
[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,"Pressure variation > 40%, Uniformity <70%, Application rate > soil intake",0.86]
[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,"Pressure variation > 30%, Uniformity 70 - 80%, Application rate <= soil intake",0.93]
[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,"Pressure variation  20-30%, Uniformity 70-80%, Application rate <= soil intake",0.97]
[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,"Pressure variation <= 20%, Uniformity >80%, Application rate <= soil intake",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,"Emitter Clogging Factor"]
[]
[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,"Surface or Sprinkler System  N/A"]
[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,"BUBBLER--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%",0.98]
[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,"BUBBLER--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%",0.98699999999999999]
[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,"BUBBLER--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%",0.99299999999999999]
[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,"BUBBLER--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%",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,"SPRAY--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%",0.96]
[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,"SPRAY--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%",0.97]
[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,"SPRAY--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%",0.98]
[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,"SPRAY--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%",0.99]
[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,"DRIPPER--no cover--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%",0.94]
[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,"DRIPPER--no cover--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%",0.95299999999999996]
[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,"DRIPPER--no cover--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%",0.96699999999999997]
[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,"DRIPPER--no cover--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%",0.98]
[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,"DRIPPER--covered--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%",0.92]
[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,"DRIPPER--covered--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%",0.93700000000000006]
[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,"DRIPPER--covered--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%",0.95299999999999996]
[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,"DRIPPER--covered--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%",0.97]
[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,"DRIPPER--Underground--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%",0.9]
[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,"DRIPPER--Underground--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%",0.92]
[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,"DRIPPER--Underground--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%",0.94]
[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,"DRIPPER--Underground--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%",0.96]
[]
[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,"Trickle Design Factor"]
[]
[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,"Surface or Sprinkler system N/A"]
[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,"Excellent CV - Flow Variability +/- 30%",0.94]
[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,"Excellent CV - Flow Variability +/- 15%",0.97]
[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,"Excellent CV - Flow Variability +/- 5%",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,"Average CV - Flow Variability +/- 30%",0.92]
[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,"Average CV - Flow Variability +/- 15%",0.95]
[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,"Average CV - Flow Variability +/- 5%",0.98]
[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,"Marginal CV - Flow Variability +/- 30%",0.9]
[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,"Marginal CV - Flow Variability +/- 15%",0.93]
[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,"Marginal CV - Flow Variability +/- 5%",0.96]

{"sheet":"Detailed report","index":2,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,2,1],[2,3,2,16],[0,3,0,16],[1,3,1,15],[6,16,7,16],[4,12,4,13],[4,14,4,18],[3,12,3,13],[3,14,3,18],[5,12,5,16],[4,3,4,4],[4,5,4,6],[20,12,20,15],[21,12,21,15],[22,12,22,15],[23,12,23,15],[9,1,9,3],[7,6,9,7],[8,12,9,13],[15,12,15,15],[16,12,16,15],[17,12,17,15],[18,12,18,15],[19,12,19,15],[13,6,13,10],[10,6,10,7],[17,4,17,9],[11,2,11,3],[30,4,30,9],[24,12,24,15],[30,12,30,15],[29,12,29,15],[25,12,25,15],[26,12,26,15],[27,12,27,15],[28,12,28,15],[26,4,26,9],[27,4,27,9],[28,4,28,9],[29,4,29,9],[18,4,18,9],[12,2,12,3],[5,6,5,10],[4,7,4,9],[6,1,6,3],[8,1,8,3],[15,4,15,9],[16,4,16,9],[14,6,14,9],[14,13,14,15],[34,3,40,15],[3,3,3,9],[19,4,19,9],[20,4,20,9],[21,4,21,9],[22,4,22,9],[23,4,23,9],[24,4,24,9],[25,4,25,9],[15,1,15,3],[16,1,21,1],[22,1,30,1],[13,14,13,16],[13,2,14,3],[32,2,32,6]]}
[null,"NRCS",null,"Farm Irrigation Rating Tool"]
[null,null,null,"Detail Report"]
[null,null,null,"       Natural Resources Conservation Service (NRCS)   "]
[null,null,"Client:",{"$f":"IF('FIRI Worksheet'!D4<>\"\",'FIRI Worksheet'!D4,\"\")","v":""},null,null,null,null,null,null,"Date:",{"$f":"'FIRI Worksheet'!N4","v":"2015-03-24"},"Planner:",null,{"$f":"IF('FIRI Worksheet'!H4<>\"\",'FIRI Worksheet'!H4,\"\")","v":""}]
[null,null,"Tract No.",{"$f":"'FIRI Worksheet'!D5:E5","v":0},null," Farm No.",null,{"$f":"'FIRI Worksheet'!G5","v":0},null,null,"Field No.",{"$f":"'FIRI Worksheet'!I5","v":0},"Description:",null,{"$f":"IF('FIRI Worksheet'!L5<>\"\",'FIRI Worksheet'!L5,\"\")","v":""}]
[null,null,null,null,null,null,"Current System Status",null,null,null,null,null,"Planned improvements or Management"]
[null,"  FIRI Rating Index",null,null,null,null,null,null,{"$f":"'FIRI Worksheet'!E30","v":""},null,null,null,null,null,{"$f":"'FIRI Worksheet'!J30","v":""},null,{"$f":"IF(Q10=\"\",\"\",\"Estimated change\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF('FIRI Worksheet'!M34<>\"\",\"Corrected for limited water\",\"\")","v":""}]
[null,"  Net  Irrigation Applied ",null,null,null,null,null,null,{"$f":"'FIRI Worksheet'!G38","v":""},{"$f":"IF(I9<>\"\",\"ac-in/ac\",)","v":0},null,null,{"$f":"IF(AND('FIRI Worksheet'!M34<>\"\",'FIRI Worksheet'!M34<='FIRI Worksheet'!J38),\"Corrected for limited water\",\"\")","v":""},null,{"$f":"'FIRI Worksheet'!L38","v":""},{"$f":"IF(O9<>\"\",\"ac-in/ac\",)","v":0}]
[null,"  Gross Irrigation Available ",null,null,null,null,null,null,{"$f":"'FIRI Worksheet'!E38","v":""},0,null,null,null,null,{"$f":"'FIRI Worksheet'!J38","v":""},0,{"$f":"IF(O10>=I10,\"\",IFERROR(O10-I10,\"\"))","v":""},{"$f":"IF(Q10<>\"\",\"ac-in/ac\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(I13=\"\",\"\",IF('FIRI Worksheet'!AO113=\"\",\"Default (%)\",\"User defined (%)\"))","v":""},null,null,null,null,null,{"$f":"IF(O13=\"\",\"\",IF('FIRI Worksheet'!AS113=\"\",\"Default (%)\",\"User defined (%)\"))","v":""}]
[null,null,"  Runoff ",null,null,{"$f":"IF(I13=\"\",\"\",\"Break down\")","v":""},{"$f":"IF(I13=\"\",\"\",'FIRI Worksheet'!E42)","v":""},null,{"$f":"'FIRI Worksheet'!G42","v":""},{"$f":"IF(I12<>\"\",\"ac-in/ac\",\"\")","v":""},null,null,{"$f":"IF(O13=\"\",\"\",'FIRI Worksheet'!J42)","v":""},null,{"$f":"'FIRI Worksheet'!L42","v":""},{"$f":"IF(O12<>\"\",\"ac-in/ac\",\"\")","v":""},{"$f":"IF(O10>I10,\"\",IFERROR(I12-O12,\"\"))","v":""},{"$f":"IF(Q12<>\"\",\"ac-in/ac\",\"\")","v":""}]
[null,null,"  Deep Percolation ",null,null,null,{"$f":"IF(I13=\"\",\"\",'FIRI Worksheet'!F42)","v":""},null,{"$f":"'FIRI Worksheet'!H42","v":""},{"$f":"IF(I13<>\"\",\"ac-in/ac\",\"\")","v":""},null,null,{"$f":"IF(O13=\"\",\"\",'FIRI Worksheet'!K42)","v":""},null,{"$f":"'FIRI Worksheet'!M42","v":""},{"$f":"IF(O13<>\"\",\"ac-in/ac\",\"\")","v":""},{"$f":"IF(O10>I10,\"\",IFERROR(I13-O13,\"\"))","v":""},{"$f":"IF(Q13<>\"\",\"ac-in/ac\",\"\")","v":""}]
[null,null,"FIRI Factors"]
[null,null,null,null,null,null,"Practice",null,null,null,"Rating",null,null,"Practice",null,null,"Rating"]
[null,"System Type",null,null,{"$f":"IF('FIRI Worksheet'!E8=\"\",\"N/A\",'FIRI Worksheet'!E8)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H8","v":""},null,{"$f":"IF('FIRI Worksheet'!J8=\"\",\"N/A\",'FIRI Worksheet'!J8)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M8","v":""}]
[null,"Management","Water Measurement","Md",{"$f":"IF('FIRI Worksheet'!E10=\"\",\"N/A\",'FIRI Worksheet'!E10)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H10","v":""},null,{"$f":"IF('FIRI Worksheet'!J10=\"\",\"N/A\",'FIRI Worksheet'!J10)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M10","v":""}]
[null,null,"Irrigation Scheduling","S",{"$f":"IF('FIRI Worksheet'!E11=\"\",\"N/A\",'FIRI Worksheet'!E11)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H11","v":""},null,{"$f":"IF('FIRI Worksheet'!J11=\"\",\"N/A\",'FIRI Worksheet'!J11)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M11","v":""}]
[null,null,"Irrigation Knowledge or Skill","I",{"$f":"IF('FIRI Worksheet'!E12=\"\",\"N/A\",'FIRI Worksheet'!E12)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H12","v":""},null,{"$f":"IF('FIRI Worksheet'!J12=\"\",\"N/A\",'FIRI Worksheet'!J12)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M12","v":""}]
[null,null,"System Maintenance","M",{"$f":"IF('FIRI Worksheet'!E13=\"\",\"N/A\",'FIRI Worksheet'!E13)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H13","v":""},null,{"$f":"IF('FIRI Worksheet'!J13=\"\",\"N/A\",'FIRI Worksheet'!J13)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M13","v":""}]
[null,null,"Water Availability and Delivery","D",{"$f":"IF('FIRI Worksheet'!E14=\"\",\"N/A\",'FIRI Worksheet'!E14)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H14","v":""},null,{"$f":"IF('FIRI Worksheet'!J14=\"\",\"N/A\",'FIRI Worksheet'!J14)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M14","v":""}]
[null,null,"Soil Condition or health","Sc",{"$f":"IF('FIRI Worksheet'!E15=\"\",\"N/A\",'FIRI Worksheet'!E15)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H15","v":""},null,{"$f":"IF('FIRI Worksheet'!J15=\"\",\"N/A\",'FIRI Worksheet'!J15)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M15","v":""}]
[null,"Hardware Design","Water delivery Control","Wc",{"$f":"IF('FIRI Worksheet'!E17=\"\",\"N/A\",'FIRI Worksheet'!E17)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H17","v":""},null,{"$f":"IF('FIRI Worksheet'!J17=\"\",\"N/A\",'FIRI Worksheet'!J17)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M17","v":""}]
[null,null,"Type of water Conveyance used","Ce",{"$f":"IF('FIRI Worksheet'!E19=\"\",\"N/A\",'FIRI Worksheet'!E19)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H19","v":""},null,{"$f":"IF('FIRI Worksheet'!J19=\"\",\"N/A\",'FIRI Worksheet'!J19)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M19","v":""}]
[null,null,"Field Levelness","L",{"$f":"IF('FIRI Worksheet'!E20=\"\",\"N/A\",'FIRI Worksheet'!E20)","v":"N/A"},null,null,null,null,null,{"$f":"IF('FIRI Worksheet'!H20=\"\",\"\",'FIRI Worksheet'!H20)","v":""},null,{"$f":"IF('FIRI Worksheet'!J20=\"\",\"N/A\",'FIRI Worksheet'!J20)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!M20=\"\",\"\",'FIRI Worksheet'!M20)","v":""}]
[null,null,"Tailwater reuse","R",{"$f":"IF('FIRI Worksheet'!E21=\"\",\"N/A\",'FIRI Worksheet'!E21)","v":"N/A"},null,null,null,null,null,{"$f":"IF('FIRI Worksheet'!H21=\"\",\"\",'FIRI Worksheet'!H21)","v":""},null,{"$f":"IF('FIRI Worksheet'!J21=\"\",\"N/A\",'FIRI Worksheet'!J21)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M21","v":""}]
[null,null,"Climate","C",{"$f":"IF('FIRI Worksheet'!E22=\"\",\"N/A\",'FIRI Worksheet'!E22)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H22","v":""},null,{"$f":"IF('FIRI Worksheet'!J22=\"\",\"N/A\",'FIRI Worksheet'!J22)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M22","v":""}]
[null,null,"Wind","W",{"$f":"IF('FIRI Worksheet'!E23=\"\",\"N/A\",'FIRI Worksheet'!E23)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H23","v":""},null,{"$f":"IF('FIRI Worksheet'!J23=\"\",\"N/A\",'FIRI Worksheet'!J23)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M23","v":""}]
[null,null,"Sprinkler Design","Sd",{"$f":"IF('FIRI Worksheet'!E24=\"\",\"N/A\",'FIRI Worksheet'!E24)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H24","v":""},null,{"$f":"IF('FIRI Worksheet'!J24=\"\",\"N/A\",'FIRI Worksheet'!J24)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M24","v":""}]
[null,null,"Emitter selection/care","E",{"$f":"IF('FIRI Worksheet'!E25=\"\",\"N/A\",'FIRI Worksheet'!E25)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H25","v":""},null,{"$f":"IF('FIRI Worksheet'!J25=\"\",\"N/A\",'FIRI Worksheet'!J25)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M25","v":""}]
[null,null,"Drip-Micro Design","T",{"$f":"IF('FIRI Worksheet'!E26=\"\",\"N/A\",'FIRI Worksheet'!E26)","v":"N/A"},null,null,null,null,null,{"$f":"'FIRI Worksheet'!H26","v":""},null,{"$f":"IF('FIRI Worksheet'!J26=\"\",\"N/A\",'FIRI Worksheet'!J26)","v":"N/A"},null,null,null,{"$f":"'FIRI Worksheet'!M26","v":""}]
[]
[null,null,"Percent of maximum potential rating",null,null,null,null,null,null,null,{"$f":"'FIRI Worksheet'!G30","v":""},null,null,null,null,null,{"$f":"'FIRI Worksheet'!L30","v":""}]
[]
[null,null,"Notes:"]

{"sheet":"Summary Report","index":3,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[27,1,29,4],[14,8,14,11],[5,2,6,3],[5,8,6,9],[13,1,13,2],[14,4,14,6],[12,8,12,11],[7,4,9,6],[7,9,9,11],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[11,8,11,11],[30,9,31,9],[12,4,12,6],[19,4,19,6],[13,4,13,6],[19,8,19,11],[13,8,13,11],[15,8,15,11],[16,8,16,11],[17,8,17,11],[18,8,18,11],[15,4,15,6],[16,4,16,6],[18,4,18,6],[17,4,17,6],[24,4,24,6],[25,8,25,11],[42,2,42,11],[45,3,45,4],[38,2,38,11],[21,4,21,6],[22,4,22,6],[39,4,39,6],[40,2,40,11],[41,4,41,6],[21,8,21,11],[22,8,22,11],[23,8,23,11],[24,8,24,11],[37,1,37,11],[24,1,24,2],[25,1,25,2],[23,4,23,6],[0,1,2,1],[7,1,9,3],[10,1,10,3],[11,1,11,2],[12,1,12,2],[0,3,0,11],[1,3,1,11],[2,3,2,11],[3,3,3,5],[3,10,3,11],[11,4,11,6],[10,4,10,6],[3,7,3,8],[4,7,4,8],[10,8,10,11],[4,10,4,11],[39,2,39,3],[34,1,34,11],[35,1,35,11],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[20,4,20,6],[30,10,31,11],[20,8,20,11],[25,4,25,6],[28,5,29,5],[28,6,29,6],[27,9,28,11],[29,10,29,11]]}
[null,"NRCS",null,"Farm Irrigation Rating Tool"]
[null,null,null,"Summary Sheet"]
[null,null,null,"       Natural Resources Conservation Service (NRCS)   "]
[null,null,"Client:",{"$f":"IF('FIRI Worksheet'!D4<>\"\",'FIRI Worksheet'!D4,\"\")","v":""},null,null,"Date:",{"$f":"'FIRI Worksheet'!N4","v":"2015-03-24"},null,"Planner:",{"$f":"IF('FIRI Worksheet'!H4<>\"\",'FIRI Worksheet'!H4,\"\")","v":""}]
[null,null,"Tract No.",{"$f":"'FIRI Worksheet'!D5","v":0}," Farm No.",{"$f":"'FIRI Worksheet'!G5","v":0},"Field No.",{"$f":"'FIRI Worksheet'!I5","v":0},null,"Field Name:",{"$f":"IF('FIRI Worksheet'!L5<>\"\",'FIRI Worksheet'!L5,\"\")","v":""}]
[null,null,"Initial assessment year (yr)",null,"Current ",null,null,null,"Period of Planned activities (yr)",null,"Start","End"]
[]
[null,"System rating categories",null,null,"Current system status",null,null,null,null,"Planned improvements or Management"]
[]
[]
[null,"System Type",null,null,{"$f":"IF('FIRI Worksheet'!E8=\"\",\"N/A\",'FIRI Worksheet'!E8)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J8=\"\",\"\",'FIRI Worksheet'!J8)","v":""}]
[null,"Water Measurement",null,"Md",{"$f":"IF('FIRI Worksheet'!E10=\"\",\"N/A\",'FIRI Worksheet'!E10)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J10=\"\",\"N/A\",'FIRI Worksheet'!J10)","v":"N/A"}]
[null,"Irrigation Scheduling",null,"S",{"$f":"IF('FIRI Worksheet'!E11=\"\",\"N/A\",'FIRI Worksheet'!E11)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J11=\"\",\"N/A\",'FIRI Worksheet'!J11)","v":"N/A"}]
[null,"Irrigation Knowledge or Skill",null,"I",{"$f":"IF('FIRI Worksheet'!E12=\"\",\"N/A\",'FIRI Worksheet'!E12)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J12=\"\",\"N/A\",'FIRI Worksheet'!J12)","v":"N/A"}]
[null,"System Maintenance",null,"M",{"$f":"IF('FIRI Worksheet'!E13=\"\",\"N/A\",'FIRI Worksheet'!E13)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J13=\"\",\"N/A\",'FIRI Worksheet'!J13)","v":"N/A"}]
[null,"Water Availability and Delivery",null,"D",{"$f":"IF('FIRI Worksheet'!E14=\"\",\"N/A\",'FIRI Worksheet'!E14)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J14=\"\",\"N/A\",'FIRI Worksheet'!J14)","v":"N/A"}]
[null,"Soil Condition or Health",null,"Sc",{"$f":"IF('FIRI Worksheet'!E15=\"\",\"N/A\",'FIRI Worksheet'!E15)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J15=\"\",\"N/A\",'FIRI Worksheet'!J15)","v":"N/A"}]
[null,"Water delivery Control",null,"Wc",{"$f":"IF('FIRI Worksheet'!E17=\"\",\"N/A\",'FIRI Worksheet'!E17)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J17=\"\",\"N/A\",'FIRI Worksheet'!J17)","v":"N/A"}]
[null,"Type of water Conveyance used",null,"Ce",{"$f":"IF('FIRI Worksheet'!E19=\"\",\"N/A\",'FIRI Worksheet'!E19)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J19=\"\",\"N/A\",'FIRI Worksheet'!J19)","v":"N/A"}]
[null,"Field Levelness",null,"L",{"$f":"IF('FIRI Worksheet'!E20=\"\",\"N/A\",'FIRI Worksheet'!E20)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J20=\"\",\"N/A\",'FIRI Worksheet'!J20)","v":"N/A"}]
[null,"Tailwater reuse",null,"R",{"$f":"IF('FIRI Worksheet'!E21=\"\",\"N/A\",'FIRI Worksheet'!E21)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J21=\"\",\"N/A\",'FIRI Worksheet'!J21)","v":"N/A"}]
[null,"Climate",null,"C",{"$f":"IF('FIRI Worksheet'!E22=\"\",\"N/A\",'FIRI Worksheet'!E22)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J22=\"\",\"N/A\",'FIRI Worksheet'!J22)","v":"N/A"}]
[null,"Wind",null,"W",{"$f":"IF('FIRI Worksheet'!E23=\"\",\"N/A\",'FIRI Worksheet'!E23)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J23=\"\",\"N/A\",'FIRI Worksheet'!J23)","v":"N/A"}]
[null,"Sprinkler Design",null,"Sd",{"$f":"IF('FIRI Worksheet'!E24=\"\",\"N/A\",'FIRI Worksheet'!E24)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J24=\"\",\"N/A\",'FIRI Worksheet'!J24)","v":"N/A"}]
[null,"Emitter selection/care",null,"E",{"$f":"IF('FIRI Worksheet'!E25=\"\",\"N/A\",'FIRI Worksheet'!E25)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J25=\"\",\"N/A\",'FIRI Worksheet'!J25)","v":"N/A"}]
[null,"Drip-Micro Design",null,"T",{"$f":"IF('FIRI Worksheet'!E26=\"\",\"N/A\",'FIRI Worksheet'!E26)","v":"N/A"},null,null,null,{"$f":"IF('FIRI Worksheet'!J26=\"\",\"N/A\",'FIRI Worksheet'!J26)","v":"N/A"}]
[]
[null,"Estimated Irrigation Rating Index from worksheet",null,null,null,"Current","Planned",null,null,"Estimated change in gross water applied"]
[null,null,null,null,null,{"$f":"'FIRI Worksheet'!E30","v":""},{"$f":"'FIRI Worksheet'!J30","v":""}]
[null,null,null,null,null,null,null,null,null,"ac-in/ac","%"]
[null,null,null,null,null,null,null,null,null,{"$f":"'FIRI Worksheet'!M38","v":""},{"$f":"'FIRI Worksheet'!N38","v":""}]
[]
[null,null,"Percent of maximum Potential rating",null,null,{"$f":"'FIRI Worksheet'!G30","v":""},{"$f":"'FIRI Worksheet'!L30","v":""}]
[]
[null,"Additional Requirements:    "]
[null,"Existing items and installed planned enhancements should be maintained.  Changes to the irrigation system and its management will impact irrigation efficiency.  Assistance with planning changes can be obtained from your NRCS Conservationist.   Improvements in the irrigation system index can increase \"On farm\" water availability, decrease deep percolation and runoff losses, and enhance crop uniformity.  "]
[]
[null,"Producer Acknowledgement:"]
[null,null,"I agree to install, manage, and maintain or enhance the Irrigation System described above. "]
[null,null,"Client:",null,null,null,null,null,"Date:"]
[null,null,"These actions are planned according to the CO-01 Technical Assistance Program:"]
[null,null,null,"Conservationist:",null,null,null,null,"Date:"]
[null,null,"These actions have been applied and reviewed by (initial below)"]
[null,null,{"$f":"IF(K7<>\"\",K7,\"\")","v":""},{"$f":"IF(C44<>\"\",C44+1,\"\")","v":""},{"$f":"IF(D44<>\"\",D44+1,\"\")","v":""},"","",null,{"$f":"IF(G44<>\"\",G44+1,\"\")","v":""},"","",""]

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

{"sheet":"Factors","index":5,"n_rows":195,"n_cols":25,"rows_kept":195,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'FIRI Worksheet'!AD37","v":" Enhancement Category"},null,{"$f":"'FIRI Worksheet'!AF37","v":"iwm"}]
[null,{"$f":"'FIRI Worksheet'!AE38","v":"Irrigation Enhancement Action"},{"$f":"'FIRI Worksheet'!AF38","v":"Rating"}]
[{"$f":"'FIRI Worksheet'!AD39","v":"Improved Water Measurement"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uniform","<=0.05%","None","<0.3%"]
[null,{"$f":"'FIRI Worksheet'!AE40","v":"No flow measuring devices"},{"$f":"'FIRI Worksheet'!AF40","v":0.9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairly uniform",">0.05%","Uniform",">=0.3 <0.5%","Not proper length of run"]
["[Md]",{"$f":"'FIRI Worksheet'!AE41","v":"Flow measurement - whole farm-manually recorded"},{"$f":"'FIRI Worksheet'!AF41","v":0.93},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable",null,"Variable","<0.5%","Proper length of run"]
[null,{"$f":"'FIRI Worksheet'!AE42","v":"Flow measurement - whole farm-automatic recorded"},{"$f":"'FIRI Worksheet'!AF42","v":0.95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=0.5%"]
[null,{"$f":"'FIRI Worksheet'!AE43","v":"Flow measurement - whole farm plus individual field manual recorded"},{"$f":"'FIRI Worksheet'!AF43","v":0.97}]
[null,{"$f":"'FIRI Worksheet'!AE44","v":"Flow measurement - whole farm plus individual field automatic recorded"},{"$f":"'FIRI Worksheet'!AF44","v":1}]
[]
[{"$f":"'FIRI Worksheet'!AD46","v":"Improved Soil Moisture Monitoring and Irrigation Scheduling"}]
[null,"None",0.9]
["[ S ]",{"$f":"'FIRI Worksheet'!AE48","v":"Visual crop stress"},0.94]
[null,{"$f":"'FIRI Worksheet'!AE49","v":"Soil moisture by NRCS feel method"},0.95]
[null,{"$f":"'FIRI Worksheet'!AE50","v":"Check book scheduling, irrigation scheduler, etc."},0.95]
[null,{"$f":"'FIRI Worksheet'!AE51","v":"Irrigation scheduling via pan evaporation or atmometer for field"},0.96]
[null,{"$f":"'FIRI Worksheet'!AE52","v":"Irrigation scheduling via regional weather network"},0.97]
[null,{"$f":"'FIRI Worksheet'!AE53","v":"Soil moisture using Gypsum blocks, moisture probe, etc."},0.98]
[null,{"$f":"'FIRI Worksheet'!AE54","v":"Continuous measurement of soil moisture, water applied and ET"},1]
[]
[{"$f":"'FIRI Worksheet'!AD56","v":"Irrigation skill and Action"}]
[null,{"$f":"'FIRI Worksheet'!AE57","v":"Significant over-irrigation"},{"$f":"'FIRI Worksheet'!AF57","v":0.8}]
["[ I ]",{"$f":"'FIRI Worksheet'!AE58","v":"Good-Lack of full attention "},{"$f":"'FIRI Worksheet'!AF58","v":0.92}]
[null,{"$f":"'FIRI Worksheet'!AE59","v":"Following IWM plan"},{"$f":"'FIRI Worksheet'!AF59","v":1}]
[]
[{"$f":"'FIRI Worksheet'!AD61","v":"Improved Soil Condition Index"}]
[null,{"$f":"'FIRI Worksheet'!AE62","v":"Soil Condition Index from SCI = -1 or lower"},{"$f":"'FIRI Worksheet'!AF62","v":0.9}]
["[Sc]",{"$f":"'FIRI Worksheet'!AE63","v":"Soil Condition Index from SCI = -0.8"},{"$f":"'FIRI Worksheet'!AF63","v":0.91}]
[null,{"$f":"'FIRI Worksheet'!AE64","v":"Soil Condition Index from SCI = -0.6"},{"$f":"'FIRI Worksheet'!AF64","v":0.92}]
[null,{"$f":"'FIRI Worksheet'!AE65","v":"Soil Condition Index from SCI = -0.4"},{"$f":"'FIRI Worksheet'!AF65","v":0.93}]
[null,{"$f":"'FIRI Worksheet'!AE66","v":"Soil Condition Index from SCI = -0.2"},{"$f":"'FIRI Worksheet'!AF66","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE67","v":"Soil Condition Index from SCI = 0"},{"$f":"'FIRI Worksheet'!AF67","v":0.95}]
[null,{"$f":"'FIRI Worksheet'!AE68","v":"Soil Condition Index from SCI = 0.3"},{"$f":"'FIRI Worksheet'!AF68","v":0.96}]
[null,{"$f":"'FIRI Worksheet'!AE69","v":"Soil Condition Index from SCI = 0.6"},{"$f":"'FIRI Worksheet'!AF69","v":0.97}]
[null,{"$f":"'FIRI Worksheet'!AE70","v":"Soil Condition Index from SCI = 0.8"},{"$f":"'FIRI Worksheet'!AF70","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE71","v":"Soil Condition Index from SCI = 1.12"},{"$f":"'FIRI Worksheet'!AF71","v":0.99}]
[null,{"$f":"'FIRI Worksheet'!AE72","v":"Soil Condition Index from SCI = 1.4 or more"},{"$f":"'FIRI Worksheet'!AF72","v":1}]
[]
[{"$f":"'FIRI Worksheet'!AD74","v":"Improved Distribution System"}]
[null,{"$f":"'FIRI Worksheet'!AE75","v":"Very poor diversion facilities.  Little control of flow rate to farm."},{"$f":"'FIRI Worksheet'!AF75","v":0.9}]
["[Wc]",{"$f":"'FIRI Worksheet'!AE76","v":"Can control flow rates to farm, but the on farm delivery system is such that it is very hard to deliver the desired flow to any given field."},{"$f":"'FIRI Worksheet'!AF76","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE77","v":"Flow rates to each field are adequately controlled. Flow rates to each set are difficult to control."},{"$f":"'FIRI Worksheet'!AF77","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE78","v":"All flow rates to each set are adequately controlled."},{"$f":"'FIRI Worksheet'!AF78","v":1}]
[]
[{"$f":"'FIRI Worksheet'!AD80","v":"Improved Conveyance system"}]
[null,"Open ditch or canal - very gravelly",0.8]
["[Ce]","Open ditch or canal - sand/gravel",0.88]
[null,"Open ditch or canal - sand",0.95]
[null,"Open ditch or canal - sandy/loam",0.97]
[null,"Open ditch or canal - clay/silt loam",0.99]
[null,"Open ditch or canal - clay soil",0.995]
[null,"Open canal - lined",0.998]
[null,"Closed conduit pipeline",0.999]
[]
[{"$f":"'FIRI Worksheet'!AD90","v":"Improved Land Leveling"}]
[null,"Unlevel-Not Proper Run length",0.75]
["[ L ]","Unlevel-Proper Run length",0.8]
[null,{"$f":"'FIRI Worksheet'!AE93","v":"Land smoothed"},{"$f":"'FIRI Worksheet'!AF93","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE94","v":"Land leveled"},{"$f":"'FIRI Worksheet'!AF94","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE95","v":"Land precision leveled "},{"$f":"'FIRI Worksheet'!AF95","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE96","v":"Land precision leveled - slope <= .005"},{"$f":"'FIRI Worksheet'!AF96","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE97","v":"A sprinkler or drip system is utilized"},{"$f":"'FIRI Worksheet'!AF97","v":1}]
[]
[{"$f":"'FIRI Worksheet'!AD99","v":"Adding Tail water recovery with and without irrigation storage reservoirs"},"Tailwater Reuse @ 50% Efficiency"]
[null,0,1]
["[ R ]",0.1,1.05]
[null,0.2,1.1000000000000001]
[null,0.3,1.1499999999999999]
[null,0.4,1.2]
[null,0.5,1.25]
[null,0.6,1.3]
[null,0.7,1.35]
[null,0.8,1.4]
[null,0.9,1.45]
[null,1,1.5]
[]
[{"$f":"'FIRI Worksheet'!AD112","v":"Irrigation System Type"}]
[null,{"$f":"'FIRI Worksheet'!AE113","v":"Border - Graded Border"},{"$f":"'FIRI Worksheet'!AF113","v":0.8}]
[null,{"$f":"'FIRI Worksheet'!AE114","v":"Border - Level or Basin"},{"$f":"'FIRI Worksheet'!AF114","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE115","v":"Border - Guide"},{"$f":"'FIRI Worksheet'!AF115","v":0.7}]
[null,{"$f":"'FIRI Worksheet'!AE116","v":"Border - Contour Level field crop"},{"$f":"'FIRI Worksheet'!AF116","v":0.7}]
[null,{"$f":"'FIRI Worksheet'!AE117","v":"Border - Contour - Level Rice"},{"$f":"'FIRI Worksheet'!AF117","v":0.8}]
[null,{"$f":"'FIRI Worksheet'!AE118","v":"Border - Contour - Level Rice - Side Inlets"},{"$f":"'FIRI Worksheet'!AF118","v":0.85}]
[null,{"$f":"'FIRI Worksheet'!AE119","v":"Border - Border Ditch"},{"$f":"'FIRI Worksheet'!AF119","v":0.6}]
[null,{"$f":"'FIRI Worksheet'!AE120","v":"Furrow - Level or Basin"},{"$f":"'FIRI Worksheet'!AF120","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE121","v":"Furrow - Graded Furrow"},{"$f":"'FIRI Worksheet'!AF121","v":0.75}]
[null,{"$f":"'FIRI Worksheet'!AE122","v":"Furrow - Contour furrow"},{"$f":"'FIRI Worksheet'!AF122","v":0.75}]
[null,{"$f":"'FIRI Worksheet'!AE123","v":"Furrow - Corrugations"},{"$f":"'FIRI Worksheet'!AF123","v":0.75}]
[null,{"$f":"'FIRI Worksheet'!AE124","v":"Furrow - Surge"},{"$f":"'FIRI Worksheet'!AF124","v":0.8}]
[null,{"$f":"'FIRI Worksheet'!AE125","v":"Subirrigation - Subirrigated"},{"$f":"'FIRI Worksheet'!AF125","v":0.75}]
[null,{"$f":"'FIRI Worksheet'!AE126","v":"Flood - Controlled"},{"$f":"'FIRI Worksheet'!AF126","v":0.6}]
[null,{"$f":"'FIRI Worksheet'!AE127","v":"Flood - Uncontrolled"},{"$f":"'FIRI Worksheet'!AF127","v":0.5}]
[null,{"$f":"'FIRI Worksheet'!AE128","v":"Flood - Contour Ditch"},{"$f":"'FIRI Worksheet'!AF128","v":0.6}]
[null,{"$f":"'FIRI Worksheet'!AE129","v":"Sprinkler - Big Gun or Boom"},{"$f":"'FIRI Worksheet'!AF129","v":0.6}]
[null,{"$f":"'FIRI Worksheet'!AE130","v":"Sprinkler - Hand Line or Wheel Line"},{"$f":"'FIRI Worksheet'!AF130","v":0.7}]
[null,{"$f":"'FIRI Worksheet'!AE131","v":"Sprinkler - Solid Set (above canopy)"},{"$f":"'FIRI Worksheet'!AF131","v":0.75}]
[null,{"$f":"'FIRI Worksheet'!AE132","v":"Sprinkler - Solid Set (below canopy)"},{"$f":"'FIRI Worksheet'!AF132","v":0.8}]
[null,{"$f":"'FIRI Worksheet'!AE133","v":"Center Pivot"},{"$f":"'FIRI Worksheet'!AF133","v":0.8}]
[null,{"$f":"'FIRI Worksheet'!AE134","v":"Center Pivot (Low Pressure Improved)"},{"$f":"'FIRI Worksheet'!AF134","v":0.82}]
[null,{"$f":"'FIRI Worksheet'!AE135","v":"Center Pivot - Low Pressure Precision Application (LEPA)"},{"$f":"'FIRI Worksheet'!AF135","v":0.92}]
[null,{"$f":"'FIRI Worksheet'!AE136","v":"Center Pivot - Low Elevation Spray Application (LESA)"},{"$f":"'FIRI Worksheet'!AF136","v":0.89}]
[null,{"$f":"'FIRI Worksheet'!AE137","v":"Center Pivot - Low Pressure In Canopy (LPIC)"},{"$f":"'FIRI Worksheet'!AF137","v":0.87}]
[null,{"$f":"'FIRI Worksheet'!AE138","v":"Center Pivot - Mid Elevation Spray application(MESA)"},{"$f":"'FIRI Worksheet'!AF138","v":0.85}]
[null,{"$f":"'FIRI Worksheet'!AE139","v":"Center Pivot - Variable Rate Irrigation (VRI)"},{"$f":"'FIRI Worksheet'!AF139","v":0.87}]
[null,{"$f":"'FIRI Worksheet'!AE140","v":"Lateral Move "},{"$f":"'FIRI Worksheet'!AF140","v":0.82}]
[null,{"$f":"'FIRI Worksheet'!AE141","v":"Lateral Move (LEPA, LESA, LPIC, MESA)"},{"$f":"'FIRI Worksheet'!AF141","v":0.87}]
[null,{"$f":"'FIRI Worksheet'!AE142","v":"Lateral Move (VRI)"},{"$f":"'FIRI Worksheet'!AF142","v":0.87}]
[null,{"$f":"'FIRI Worksheet'!AE143","v":"Micro, Point Source"},{"$f":"'FIRI Worksheet'!AF143","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE144","v":"Micro, Sprays"},{"$f":"'FIRI Worksheet'!AF144","v":0.85}]
[null,{"$f":"'FIRI Worksheet'!AE145","v":"Micro, Continuous Tape"},{"$f":"'FIRI Worksheet'!AF145","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE146","v":"Micro, Subsurface Drip Irrigation (SDI)"},{"$f":"'FIRI Worksheet'!AF146","v":0.92}]
[]
[{"$f":"'FIRI Worksheet'!AD148","v":"Maintenance Factor"}]
[null,{"$f":"'FIRI Worksheet'!AE149","v":"Poor"},{"$f":"'FIRI Worksheet'!AF149","v":0.9}]
["[ M ]",{"$f":"'FIRI Worksheet'!AE150","v":"Fair"},{"$f":"'FIRI Worksheet'!AF150","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE151","v":"Good"},{"$f":"'FIRI Worksheet'!AF151","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE152","v":"Excellent"},{"$f":"'FIRI Worksheet'!AF152","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE153","v":"future"},{"$f":"'FIRI Worksheet'!AF153","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE154","v":"future"},{"$f":"'FIRI Worksheet'!AF154","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE155","v":"future"},{"$f":"'FIRI Worksheet'!AF155","v":1}]
[]
[{"$f":"'FIRI Worksheet'!AD157","v":"Water Delivery"}]
[null,{"$f":"'FIRI Worksheet'!AE158","v":"Rotation -- Limited"},{"$f":"'FIRI Worksheet'!AF158","v":0.8}]
["[ D ]",{"$f":"'FIRI Worksheet'!AE159","v":"Rotation -- Fixed"},{"$f":"'FIRI Worksheet'!AF159","v":0.83}]
[null,{"$f":"'FIRI Worksheet'!AE160","v":"Rotation -- Modified frequency"},{"$f":"'FIRI Worksheet'!AF160","v":0.85}]
[null,{"$f":"'FIRI Worksheet'!AE161","v":"Rotation -- Modified amount"},{"$f":"'FIRI Worksheet'!AF161","v":0.88}]
[null,{"$f":"'FIRI Worksheet'!AE162","v":"Arranged -- Fixed duration"},{"$f":"'FIRI Worksheet'!AF162","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE163","v":"Arranged -- Restricted"},{"$f":"'FIRI Worksheet'!AF163","v":0.93}]
[null,{"$f":"'FIRI Worksheet'!AE164","v":"Arranged -- Limited rate"},{"$f":"'FIRI Worksheet'!AF164","v":0.96}]
[null,{"$f":"'FIRI Worksheet'!AE165","v":"Arranged -- Arranged"},{"$f":"'FIRI Worksheet'!AF165","v":0.97}]
[null,{"$f":"'FIRI Worksheet'!AE166","v":"Demand -- Limited rate"},{"$f":"'FIRI Worksheet'!AF166","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE167","v":"Demand -- Unrestricted"},{"$f":"'FIRI Worksheet'!AF167","v":1}]
[]
[{"$f":"'FIRI Worksheet'!AD169","v":"Climatic Factor"}]
[null,{"$f":"'FIRI Worksheet'!AE172","v":"Cool -- peak avg et 0.15"},{"$f":"'FIRI Worksheet'!AF172","v":1.01}]
["[ C ]",{"$f":"'FIRI Worksheet'!AE173","v":"Warm -- peak avg et 0.30"},{"$f":"'FIRI Worksheet'!AF173","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE174","v":"Hot -- peak avg et 0.45"},{"$f":"'FIRI Worksheet'!AF174","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE175","v":"Hot -- peak avg et 0.6"},{"$f":"'FIRI Worksheet'!AF175","v":0.95}]
[]
[{"$f":"'FIRI Worksheet'!AD177","v":"Wind Factor"}]
[null,{"$f":"'FIRI Worksheet'!AE179","v":"Surface System N/A"},{"$f":"'FIRI Worksheet'!AF179","v":0}]
["[ W ]",{"$f":"'FIRI Worksheet'!AE181","v":"Fine spray wind speed 1- 4 MPH"},{"$f":"'FIRI Worksheet'!AF181","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE182","v":"Fine spray wind speed 4 -10 MPH"},{"$f":"'FIRI Worksheet'!AF182","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE183","v":"Fine spray wind speed > 10 MPH"},{"$f":"'FIRI Worksheet'!AF183","v":0.87}]
[null,{"$f":"'FIRI Worksheet'!AE184","v":"Medium spray wind speed 1- 4 MPH"},{"$f":"'FIRI Worksheet'!AF184","v":0.96}]
[null,{"$f":"'FIRI Worksheet'!AE185","v":"Medium spray wind speed 4 -10 MPH"},{"$f":"'FIRI Worksheet'!AF185","v":0.93}]
[null,{"$f":"'FIRI Worksheet'!AE186","v":"Medium spray wind speed > 10 MPH"},{"$f":"'FIRI Worksheet'!AF186","v":0.91}]
[null,{"$f":"'FIRI Worksheet'!AE187","v":"Coarse spray wind speed 1- 4 MPH"},{"$f":"'FIRI Worksheet'!AF187","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE188","v":"Coarse spray wind speed 4 -10 MPH"},{"$f":"'FIRI Worksheet'!AF188","v":0.96}]
[null,{"$f":"'FIRI Worksheet'!AE189","v":"Coarse spray wind speed > 10 MPH"},{"$f":"'FIRI Worksheet'!AF189","v":0.96}]
[null,{"$f":"'FIRI Worksheet'!AE180","v":"Non-Spray (LEPA) or Point Source Drip N/A"},{"$f":"'FIRI Worksheet'!AF180","v":0}]
[]
[{"$f":"'FIRI Worksheet'!AD190","v":"Sprinkler Factor"},null,{"$f":"'FIRI Worksheet'!AF191","v":0}]
[null,{"$f":"'FIRI Worksheet'!AE192","v":"Surface System N/A"},{"$f":"'FIRI Worksheet'!AF192","v":0}]
["[Sd]",{"$f":"'FIRI Worksheet'!AE194","v":"Pressure variation > 40%, Uniformity <70%, Application rate > soil intake"},{"$f":"'FIRI Worksheet'!AF194","v":0.86}]
[null,{"$f":"'FIRI Worksheet'!AE195","v":"Pressure variation > 30%, Uniformity 70 - 80%, Application rate <= soil intake"},{"$f":"'FIRI Worksheet'!AF195","v":0.93}]
[null,{"$f":"'FIRI Worksheet'!AE196","v":"Pressure variation  20-30%, Uniformity 70-80%, Application rate <= soil intake"},0.97]
[null,{"$f":"'FIRI Worksheet'!AE197","v":"Pressure variation <= 20%, Uniformity >80%, Application rate <= soil intake"},{"$f":"'FIRI Worksheet'!AF197","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE193","v":"Micro System N/A"},{"$f":"'FIRI Worksheet'!AF193","v":0}]
[]
[{"$f":"'FIRI Worksheet'!AD198","v":"Emitter Clogging Factor"}]
[]
["[ E ]",{"$f":"'FIRI Worksheet'!AE200","v":"Surface or Sprinkler System  N/A"},{"$f":"'FIRI Worksheet'!AF200","v":0}]
[null,{"$f":"'FIRI Worksheet'!AE201","v":"BUBBLER--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%"},{"$f":"'FIRI Worksheet'!AF201","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE202","v":"BUBBLER--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%"},{"$f":"'FIRI Worksheet'!AF202","v":0.98699999999999999}]
[null,{"$f":"'FIRI Worksheet'!AE203","v":"BUBBLER--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%"},{"$f":"'FIRI Worksheet'!AF203","v":0.99299999999999999}]
[null,{"$f":"'FIRI Worksheet'!AE204","v":"BUBBLER--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%"},{"$f":"'FIRI Worksheet'!AF204","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE205","v":"SPRAY--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%"},{"$f":"'FIRI Worksheet'!AF205","v":0.96}]
[null,{"$f":"'FIRI Worksheet'!AE206","v":"SPRAY--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%"},{"$f":"'FIRI Worksheet'!AF206","v":0.97}]
[null,{"$f":"'FIRI Worksheet'!AE207","v":"SPRAY--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%"},{"$f":"'FIRI Worksheet'!AF207","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE208","v":"SPRAY--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%"},{"$f":"'FIRI Worksheet'!AF208","v":0.99}]
[null,{"$f":"'FIRI Worksheet'!AE209","v":"DRIPPER--no cover--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%"},{"$f":"'FIRI Worksheet'!AF209","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE210","v":"DRIPPER--no cover--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%"},{"$f":"'FIRI Worksheet'!AF210","v":0.95299999999999996}]
[null,{"$f":"'FIRI Worksheet'!AE211","v":"DRIPPER--no cover--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%"},{"$f":"'FIRI Worksheet'!AF211","v":0.96699999999999997}]
[null,{"$f":"'FIRI Worksheet'!AE212","v":"DRIPPER--no cover--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%"},{"$f":"'FIRI Worksheet'!AF212","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE213","v":"DRIPPER--covered--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%"},{"$f":"'FIRI Worksheet'!AF213","v":0.92}]
[null,{"$f":"'FIRI Worksheet'!AE214","v":"DRIPPER--covered--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%"},{"$f":"'FIRI Worksheet'!AF214","v":0.93700000000000006}]
[null,{"$f":"'FIRI Worksheet'!AE215","v":"DRIPPER--covered--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%"},{"$f":"'FIRI Worksheet'!AF215","v":0.95299999999999996}]
[null,{"$f":"'FIRI Worksheet'!AE216","v":"DRIPPER--covered--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%"},{"$f":"'FIRI Worksheet'!AF216","v":0.97}]
[null,{"$f":"'FIRI Worksheet'!AE217","v":"DRIPPER--Underground--Treatment: None, Flushing: None, Temperature: 149F, Sum of clogging:  > 20%"},{"$f":"'FIRI Worksheet'!AF217","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE218","v":"DRIPPER--Underground--Treatment: Screen, Flushing: Manual, Temperature: 50F, Sum of clogging:  15%"},{"$f":"'FIRI Worksheet'!AF218","v":0.92}]
[null,{"$f":"'FIRI Worksheet'!AE219","v":"DRIPPER--Underground--Treatment: Screen+media filter, Flushing: Periodic, Temperature: 95F, Sum of clogging:  10%"},{"$f":"'FIRI Worksheet'!AF219","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE220","v":"DRIPPER--Underground--Treatment: Screen+media filter+chemical, Flushing: Continuous, Temperature: 68F, Sum of Clogging: <5%"},{"$f":"'FIRI Worksheet'!AF220","v":0.96}]
[]
[{"$f":"'FIRI Worksheet'!AD222","v":"Trickle Design Factor"}]
[]
["[ T  ]",{"$f":"'FIRI Worksheet'!AE224","v":"Surface or Sprinkler system N/A"},{"$f":"'FIRI Worksheet'!AF224","v":0}]
[null,{"$f":"'FIRI Worksheet'!AE225","v":"Excellent CV - Flow Variability +/- 30%"},{"$f":"'FIRI Worksheet'!AF225","v":0.94}]
[null,{"$f":"'FIRI Worksheet'!AE226","v":"Excellent CV - Flow Variability +/- 15%"},{"$f":"'FIRI Worksheet'!AF226","v":0.97}]
[null,{"$f":"'FIRI Worksheet'!AE227","v":"Excellent CV - Flow Variability +/- 5%"},{"$f":"'FIRI Worksheet'!AF227","v":1}]
[null,{"$f":"'FIRI Worksheet'!AE228","v":"Average CV - Flow Variability +/- 30%"},{"$f":"'FIRI Worksheet'!AF228","v":0.92}]
[null,{"$f":"'FIRI Worksheet'!AE229","v":"Average CV - Flow Variability +/- 15%"},{"$f":"'FIRI Worksheet'!AF229","v":0.95}]
[null,{"$f":"'FIRI Worksheet'!AE230","v":"Average CV - Flow Variability +/- 5%"},{"$f":"'FIRI Worksheet'!AF230","v":0.98}]
[null,{"$f":"'FIRI Worksheet'!AE231","v":"Marginal CV - Flow Variability +/- 30%"},{"$f":"'FIRI Worksheet'!AF231","v":0.9}]
[null,{"$f":"'FIRI Worksheet'!AE232","v":"Marginal CV - Flow Variability +/- 15%"},{"$f":"'FIRI Worksheet'!AF232","v":0.93}]
[null,{"$f":"'FIRI Worksheet'!AE233","v":"Marginal CV - Flow Variability +/- 5%"},{"$f":"'FIRI Worksheet'!AF233","v":0.96}]

{"sheet":"Development notes","index":6,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,2,5,5],[7,1,7,8]]}
[null,"Development notes"]
[null,null,"Questions or bug reports contact Clarence Prestwich                     WNTSC, Portland, OR                                                    (503) 414-3075 clarence.prestwich@por.usda.gov"]
[]
[]
[]
[]
[]
["Date","Notes"]
["2014-01-31","Added more functionality to the worksheet. Added Report sheets and title sheet"]
["2014-02-04","Corrected error on the conveyance factor when using multiple pipes."]
["2014-02-06","Fixed error with emmitter design factor display"]
["2014-02-14","embedded alternative conveyance lost method in spreadsheet to avoid the necessity of having companion files when distributing"]
["2014-02-20","Corrected error in e30 adjusted to save values selected on multiple section conveyance and land leveling, Tweaked land leveling to better guide selection, gray out more sections when different systems are selected. Changed name to 2014.1"]
["2014-02-24","corrected error in conveyance and made land leveling more robust"]
["2014-02-26","corrected formating errors on summary page"]
["2014-06-26","Corrected errors with sprinkler and trickle design. Corrected cell protection. Added spot for crop and climate information"]
["2014-07-15","Fixed #Ref! errors on Factors tab"]
["2014-08-22","fixed soil condition SCI index numbers by changing them back to original values"]
["2014-10-30","Fixed formating errors"]
["2015-01-09","corrected error with limited water supply and erroron trickle design factor. Adjusted formating"]
["2015-01-14","locked cells for deep perc percentages"]
["2015-01-21","After consulting with agronomists changed the SCI values back to the 2004 values which according to agronomist are more realistic values. Reworked limited water supply formula's and output of report sheets."]
["2015-02-17","Added field name box to summary sheet header"]
["2015-03-23","corrected error with high intake soil default deep perc and runoff"]