{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Blank Analysis Sheet","Sample Analysis Sheet","Assumptions","Climate Station Data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Blank Analysis Sheet","index":0,"n_rows":126,"n_cols":27,"rows_kept":126,"cut":false,"hidden":false,"merged":[[64,14,65,14],[64,15,65,15],[55,1,55,13],[62,1,62,15],[63,1,63,7],[63,9,63,15],[64,4,65,4],[64,5,65,5],[64,6,65,6],[64,7,65,7],[64,12,65,12],[64,13,65,13],[34,7,34,8],[34,12,34,13],[36,1,36,13],[37,1,37,13],[38,2,38,4],[38,6,38,8],[38,10,38,11],[28,7,28,8],[28,12,28,13],[30,7,30,8],[30,12,30,13],[32,7,32,8],[32,12,32,13],[26,7,26,8],[26,12,26,13],[11,7,11,8],[13,7,13,8],[15,1,15,13],[16,1,16,2],[17,7,17,8],[17,11,17,12],[19,1,19,13],[22,7,22,8],[22,12,22,13],[24,7,24,8],[24,12,24,13],[9,7,9,8],[1,1,1,13],[2,1,2,13],[3,1,3,13],[5,7,5,8],[7,7,7,8]]}
[]
[null,"THE ECONOMICS OF IRRIGATION EFFICIENCY IMPROVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"System Type","Hours per Acre to Operate",null,null,"Station Name 2007","Base Yield","Max Yield","Yield Within Influence","% Within Influence","CU Value for Alfalfa","NIR (annual)","Alt. Base Yield"]
[null,"Economic Analysis Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,2008,2008,2008,2008,2008,2008]
[null,"Instructions:  Enter data into all applicable blue cells.  The yellow results cells and summary will auto-populate based on the information entered into the blue cells.",null,null,null,null,null,null,null,null,null,null,null,null,null,"High-Efficiency Flood (Graded Borders)",0.11,null,null,"ALLEN'S RANCH",1.0980000000000003,6.734,6.734,{"$f":"+Z4/Y4","v":0.83694683694683691},33.67,28.18,{"$f":"+(Y4-Z4)/5","v":1.0980000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Improved Flood",0.13,null,null,"ALPINE",1.5340000000000003,6.9420000000000002,4.6360000000000001,{"$f":"+Z5/Y5","v":0.77902621722846432},34.71,27.04,{"$f":"+(Y5-Z5)/5","v":1.5340000000000003}]
[null,"1.","How efficient is your current irrigation system?",null,null,"6.","What is the expected market value of your crop?",null,null,"11.","What interest rate would you expect to pay if you were to borrow money to fund your project?",null,null,null,null,"None",0,null,null,"ALTAMONT",1.0739999999999994,5.5759999999999996,4.5839999999999996,0.80738880918220957,27.88,22.51,1.0739999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pivot",0.09,null,null,"ALTON",1.3140000000000001,5.79,3.7460000000000004,0.77305699481865287,28.95,22.38,1.3140000000000001]
[null,"2.","How efficient will your new, updated, or better-managed irrigation system be?",null,null,"7.","How much will it cost you (total out-of-pocket) to install your new irrigation system or to upgrade your existing system?",null,null,"12.","Which climate station is closest to your farm?",null,null,null,null,"Unimproved Flood",0.9,"Yes",null,"ANTIMONY",0.84,5.0579999999999998,4.63,0.83392645314353497,25.29,21.09,0.83999999999999986]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheel Line",0.18,"No",null,"BEAR RIVER BAY",1.4279999999999995,6.1479999999999997,4.51,0.76772934287573202,30.74,23.6,1.4279999999999995]
[null,"3.","How many acres are covered by your current irrigation system?",null,"Acres","8.","How much do you estimate you currently spend per year on all irrigation-related energy for the project area?",null,null,"13.","Are you going to install soil moisture sensors as part of your irrigation efficiency improvement project?",null,null,null,null,null,null,null,null,"BEAVER",1.19,5.9039999999999999,4.6660000000000004,0.79844173441734423,29.52,23.57,1.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High-Efficiency Flood (Graded Borders)",null,null,null,"BIRDSEYE",1.1299999999999999,5.5540000000000003,3.762,0.79654303204897381,27.77,22.12,1.1299999999999997]
[null,"4.","How many acres will be covered by your new irrigation system and/or efficiency improvement project?",null,"Acres","9.","How much do you estimate you will spend per year on all system-related energy after implementing your project?",null,null,"14.","What type of irrigation system is your \"before\" system?",null,null,null,null,"Improved Flood",null,null,null,"BLACK ROCK",1.0640000000000007,7.1120000000000001,7.1120000000000001,0.85039370078740151,35.56,30.24,1.0640000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pivot",null,null,null,"BLANDING",1.3440000000000005,7.02,5.354000000000001,0.80854700854700845,35.1,28.38,1.3440000000000005]
[null,"5.","How many acre feet of water (per acre) will be available for you to use?",null,"Acre Feet","10.","What is the hourly value of the system operator's and/or soil moisture sensor data collector's time? ",null,null,"15.","What type of irrigation system will your \"after\" system be?",null,null,null,null,"Wheel Line",null,null,null,"BLUFF",0.98599999999999999,8.4580000000000002,7.5,0.88342397729959798,42.29,37.36,0.98599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOULDER",1.18,6.02,4.8620000000000001,0.80398671096345509,30.1,24.2,1.1800000000000004]
[null,"Answer questions 16 through 18 if you are installing soil moisture sensors.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRIGHAM CITY",1.7380000000000002,7.3340000000000005,4.572000000000001,0.76302154349604578,36.67,27.98,1.7380000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALLAO",0.93600000000000061,6.7540000000000004,6.1880000000000006,0.8614154575066626,33.770000000000003,29.09,0.93600000000000061]
[null,"16.","Is this project an IWM-only project?  ",null,null,"17.","If you are going to install soil moisture sensors, how many will you install?",null,null,"18.","If you are going to install soil moisture sensors, how much will the sensors and reader system cost (total, including installation)?",null,null,null,null,null,null,null,null,"CASTLEDALE",0.99400000000000044,6.4560000000000004,5.6720000000000006,0.84603469640644358,32.28,27.31,0.99400000000000044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASTLE VALLEY",1.3379999999999996,7.85,7.85,0.8295541401273886,39.25,32.56,1.3379999999999996]
[null,"Economic Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDAR CITY",1.1819999999999999,6.6840000000000002,5.4120000000000008,0.8231597845601436,33.42,27.51,1.1819999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDAR POINT",1.4319999999999999,6.68,6.68,0.78562874251497006,33.4,26.24,1.4319999999999999]
[null,null,null,"\"Before\"","\"After\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIRCLEVILLE",1.0720000000000005,5.9340000000000002,5.0919999999999996,0.8193461408830468,29.67,24.31,1.0720000000000005]
[null,null,"System Efficiency: ",{"$f":"D6","v":0},{"$f":"D8","v":0},"Acre Inches","Estimated Time per Year to Read Soil Moisture Sensors and Analyze Data:",{"$f":"IF($L$10=\"Yes\",(((28*((30*2)+(H18*5))))/60),0)","v":0},null,null,"Maximum Potential Yield ",{"$f":"+L29/5","v":{"$error":"#N/A"}},"Tons",null,null,null,null,null,null,"COALVILLE",1.3520000000000003,5.9420000000000002,3.9740000000000002,0.7724671827667452,29.71,22.95,1.3520000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CORINNE",1.6240000000000001,6.9779999999999998,4.9719999999999995,0.76726855832616792,34.89,26.77,1.6240000000000001]
[null,null,"Estimated Yield per Acre:",{"$f":"IF(L25>L31,(((L31/5)*D23)+L33),(((L25/5)*D23)+L33))","v":{"$error":"#N/A"}},{"$f":"IF(L25>L31,(((L31/5)*E23)+L33),(((L25/5)*E23)+L33))","v":{"$error":"#N/A"}},"Tons","Difference in Yield per Acre:",{"$f":"E25-D25","v":{"$error":"#N/A"}},null,"Tons","Total Acre Inches Available for Crop Production:",{"$f":"(D14*12)","v":0},"Acre Inches",null,null,null,null,null,null,"COTTONWOOD WEIR / EAST BENCH",2.1839999999999997,6.6879999999999997,6.6879999999999997,0.67344497607655507,33.44,22.52,2.1839999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COVE FORT",1.1160000000000003,5.9340000000000002,4.2780000000000005,0.8119312436804853,29.67,24.09,1.1160000000000003]
[null,null,"Total Tons Produced:",{"$f":"+D25*D10","v":{"$error":"#N/A"}},{"$f":"+E25*D12","v":{"$error":"#N/A"}},"Tons","Difference in Total Tons Produced:",{"$f":"+E27-D27","v":{"$error":"#N/A"}},null,"Tons","Percent of Total Yield that Can be Affected by Efficiency Measures:",{"$f":"IF($L$8=\" \",\" \",LOOKUP($L8,$T$4:$T$128,$X$4:$X$128))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"DEER CREEK DAM",1.4060000000000001,5.92,5.92,0.76249999999999996,29.6,22.57,1.4060000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DELTA",1.04,7.5280000000000005,6.5580000000000007,0.86184909670563226,37.64,32.44,1.0400000000000005]
[null,null,"Total Revenue:",{"$f":"+D27*H6","v":{"$error":"#N/A"}},{"$f":"+E27*H6","v":{"$error":"#N/A"}},null,"Difference in Total Revenue:",{"$f":"+E29-D29","v":{"$error":"#N/A"}},null,null,"Consumptive Use Value (CU):",{"$f":"IF($L$8=\" \",\" \",LOOKUP($L8,$T$4:$T$128,$Y$4:$Y$128))","v":{"$error":"#N/A"}},"Inches",null,null,null,null,null,null,"DEWEY",1.0540000000000007,8.668000000000001,8.668000000000001,0.87840332256575904,43.34,38.07,1.0540000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DUCHESNE",1.2120000000000004,6.6920000000000002,5.7640000000000002,0.81888822474596523,33.46,27.4,1.2120000000000004]
[null,null,"Estimated Total Operating Cost:",{"$f":"('Blank Analysis Sheet'!H96*D35)+H10","v":{"$error":"#N/A"}},{"$f":"(P96*E35)+H12","v":{"$error":"#N/A"}},null,"Difference in Estimated Total Operating Cost:",{"$f":"+E31-D31","v":{"$error":"#N/A"}},null,null,"Net Irrigation Requirement (NIR):",{"$f":"IF($L$8=\" \",\" \",LOOKUP($L8,$T$4:$T$128,$Z$4:$Z$128))","v":{"$error":"#N/A"}},"Inches",null,null,null,null,null,null,"DUGWAY",1.0620000000000005,7.3340000000000005,6.42,0.85519498227433866,36.67,31.36,1.0620000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELBERTA",1.2440000000000004,7.1540000000000008,5.886000000000001,0.82611126642437793,35.770000000000003,29.55,1.2440000000000004]
[null,null,"Total Inches of Water Required to Produce Max Potential Yield Given the Efficiency of the System:",{"$f":"+((L$23-L$33)*5)/D$23","v":{"$error":"#N/A"}},{"$f":"+((L$23-L$33)*5)/E$23","v":{"$error":"#N/A"}},"Inches","Estimated Difference in Total  Net Revenue:",{"$f":"H29-H31","v":{"$error":"#N/A"}},null,null,"Base Yield/Acre:",{"$f":"+(L29-L31)/5","v":{"$error":"#N/A"}},"Tons",null,null,null,null,null,null,"EMERY",1.0160000000000005,5.9380000000000006,5.2640000000000002,0.82889861906365769,29.69,24.61,1.0160000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENTERPRISE/ BERYL",1.1240000000000001,7.0780000000000003,5.9260000000000002,0.84119807855326356,35.39,29.77,1.1240000000000001]
[null,null,"Total Acres in Production:",{"$f":"D10","v":0},{"$f":"D12","v":0},"Acres","Estimated Profit Per Hour for Soil Moisture Sensor Reading and Data Analysis:",{"$f":"IF($L$10=\"Yes\",(IF(D18=\"Yes\",($H$33/$H$23),((H33*(IF($L14=\" \",\" \",LOOKUP($L14,$P$4:$P$9,$Q$4:$Q$9))))/H23))),0)","v":0},null,null,"Approximate Payoff Period for Project (Years):",{"$f":"IF(H33>0,+(ABS((LN(1-((L6/12)*((H8+L18)/(H33/12)))))/(LN(1+(L6/12))))/12),\"Will Never Pay Off\")","v":{"$error":"#N/A"}},"Years",null,null,null,null,null,null,"EPHRAIM",1.2480000000000004,6.62,6.62,0.81148036253776434,33.1,26.86,1.2480000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESCALANTE",1.1859999999999999,7.7780000000000005,6.6380000000000008,0.84751864232450502,38.89,32.96,1.1859999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESKDALE",0.96600000000000041,7.0260000000000007,7.0260000000000007,0.86251067463706232,35.130000000000003,30.3,0.96600000000000041]
[null,"Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAIRFIELD",1.2339999999999995,6.444,5.0199999999999996,0.80850403476101806,32.22,26.05,1.2339999999999995]
[null,null,"\"Before & After\" Figures",null,null,null,"Basic Data",null,null,null,"Economic Results",null,null,null,null,null,null,null,null,"FARMINGTON USU",2.0080000000000005,7.3980000000000006,4.3840000000000003,0.72857529061908621,36.99,26.95,2.0080000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FERRON",1.046,6.1059999999999999,5.2480000000000002,0.82869308876514902,30.53,25.3,1.046]
[null,null,"\"Before\" System Efficiency:",{"$f":"D23","v":0},null,null,"Total Acres in Production:",{"$f":"D10","v":0},"Acres",null,"Estimated Profit per Hour for Soil Moisture Sensor Reading: ",{"$f":"H35","v":0},null,null,null,null,null,null,null,"FILLMORE",1.45,7.14,5.0760000000000005,0.79691876750700275,35.700000000000003,28.45,1.4500000000000006]
[null,null,"\"After\" System Efficiency:",{"$f":"E23","v":0},null,null,"Difference in Yield Per Acre:",{"$f":"H25","v":{"$error":"#N/A"}},"Tons",null,null,null,null,null,null,null,null,null,null,"FISH SPRINGS",1.1040000000000005,7.4260000000000002,7.4260000000000002,0.85133315378400209,37.130000000000003,31.61,1.1040000000000005]
[null,null,"Before Yield per Acre:",{"$f":"D25","v":{"$error":"#N/A"}},"Tons",null,"Difference in Total Tons Produced:",{"$f":"H27","v":{"$error":"#N/A"}},"Tons",null,"Difference in Total Revenue:",{"$f":"H29","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"FLAMING GORGE",1.3020000000000003,5.8179999999999996,5.8179999999999996,0.77621175661739428,29.09,22.58,1.3020000000000003]
[null,null,"After Yield per Acre:",{"$f":"E25","v":{"$error":"#N/A"}},"Tons",null,"Maximum Potential Yield:",{"$f":"L23","v":{"$error":"#N/A"}},"Tons",null,null,null,null,null,null,null,null,null,null,"FORT DUCHESNE",0.93400000000000039,6.9760000000000009,6.3060000000000009,0.86611238532110091,34.880000000000003,30.21,0.93400000000000039]
[null,null,"Before Acres:",{"$f":"D33","v":{"$error":"#N/A"}},"Acres",null,"Base Yield per Acre:",{"$f":"L33","v":{"$error":"#N/A"}},"Tons",null,"Difference in Total Costs:",{"$f":"H31","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"FRUITLAND",1.2939999999999998,5.8220000000000001,4.5819999999999999,0.77773960838199929,29.11,22.64,1.2939999999999998]
[null,null,"After Acres:",{"$f":"E33","v":{"$error":"#N/A"}},"Acres",null,"Percent of Max that can be Affected:",{"$f":"L27","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"GARFIELD",1.79,6.2560000000000002,4.0640000000000001,0.71387468030690526,31.28,22.33,1.7900000000000005]
[null,null,"Before Total Tons Produced:",{"$f":"D27","v":{"$error":"#N/A"}},"Tons",null,"Total Acre Inches Available:",{"$f":"L25","v":0},"Ac In",null,"Estimated Total Additional Net Revenue per Year:",{"$f":"H33","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"GARRISON",1.01,7.22,6.3520000000000003,0.86011080332409973,36.1,31.05,1.0100000000000002]
[null,null,"After Total Tons Produced:",{"$f":"E27","v":{"$error":"#N/A"}},"Tons",null,"Consumptive Use Value:",{"$f":"L29","v":{"$error":"#N/A"}},"Inches",null,null,null,null,null,null,null,null,null,null,"GRANTSVILLE",1.31,6.854000000000001,6.854000000000001,0.8088707324190253,34.270000000000003,27.72,1.3100000000000009]
[null,null,"Before Total Revenue:",{"$f":"D29","v":{"$error":"#N/A"}},null,null,"Net Irrigation Requirement:",{"$f":"L31","v":{"$error":"#N/A"}},"Inches",null,"Approximate Payoff Period for Project (in Years):",{"$f":"L35","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"GREEN RIVER",1.03,8.395999999999999,7.895999999999999,0.87732253454025733,41.98,36.83,1.0299999999999998]
[null,null,"After Total Revenue:",{"$f":"E29","v":{"$error":"#N/A"}},null,null,"Sensor Reading Hr/Yr:",{"$f":"D35","v":0},"Hours",null,null,null,null,null,null,null,null,null,null,"GROUSE CREEK",1.1340000000000003,5.9420000000000002,4.68,0.80915516661056874,29.71,24.04,1.1340000000000003]
[null,null,"Before Estimated Cost:",{"$f":"D31","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUNNISON",0.97399999999999953,6.7159999999999993,5.61,0.85497319833234076,33.58,28.71,0.97399999999999953]
[null,null,"After Estimated Cost:",{"$f":"E31","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HANKSVILLE",0.9159999999999997,9.032,8.4619999999999997,0.89858281665190431,45.16,40.58,0.9159999999999997]
[null,null,"Before Total Inches of Water Required for Max:",{"$f":"D33","v":{"$error":"#N/A"}},"Inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HANNA",1.1679999999999999,5.3380000000000001,4.0979999999999999,0.78119145747470964,26.69,20.85,1.1679999999999999]
[null,null,"After Total Inches of Water Required for Max:",{"$f":"E33","v":{"$error":"#N/A"}},"Inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEBER",1.2419999999999995,6.298,4.0960000000000001,0.80279453794855515,31.49,25.28,1.2419999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HENRIEVILLE",1.1379999999999995,6.73,5.5119999999999996,0.83090638930163452,33.65,27.96,1.1379999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUNTSVILLE",1.4780000000000002,6.2539999999999996,3.1979999999999995,0.76367125039974415,31.27,23.88,1.4780000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IBAPAH",1.0519999999999996,5.84,4.8040000000000003,0.81986301369863024,29.2,23.94,1.0519999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IOSEPA",1.0679999999999992,8.2459999999999987,6.9459999999999988,0.87048265825854965,41.23,35.89,1.0679999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JENSEN",1.0480000000000005,7.3040000000000003,6.4020000000000001,0.85651697699890472,36.520000000000003,31.28,1.0480000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KAMAS",1.22,5.22,3.0380000000000007,0.76628352490421447,26.1,20,1.2200000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KANAB",1.4960000000000009,8.52,6.75,0.82441314553990597,42.6,35.119999999999997,1.4960000000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KANOSH",1.482,7.0579999999999998,5.0579999999999998,0.79002550297534713,35.29,27.88,1.482]
[null,"Crop Budgets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor Hours per Year per Acre","KOOSHAREM",1.0219999999999998,5.1859999999999999,4.2699999999999996,0.80293096799074437,25.93,20.82,1.0219999999999998]
[null,"\"Before\" Scenario",null,null,null,null,null,null,null,"\"After\" Scenario",null,null,null,null,null,null,null,"High-Efficiency Flood (Graded Borders)",0.76500000000000012,"LAKETOWN",1.2,5.39,3.9859999999999998,0.77736549165120594,26.95,20.95,1.2]
[null,null,null,null,"Quantity per acre","Unit","Cost per unit","Projected Cost per Acre",null,null,null,null,"Quantity per acre","Unit","Cost per unit","Projected Cost per Acre",null,"Improved Flood",1.8,"LASAL",1.4160000000000004,6.2919999999999998,4.8919999999999995,0.77495232040686579,31.46,24.38,1.4160000000000004]
[null,"Operating costs",null,null,null,null,null,null,null,"Operating costs",null,null,null,null,null,null,null,"Pivot",0.6352941176470589,"LAVERKIN",1.3159999999999996,9.3580000000000005,7.8260000000000005,0.85937166061124171,46.79,40.21,1.3159999999999996]
[null,null,"Fertilization",null,null,null,null,null,null,null,"Fertilization",null,null,null,null,null,null,"Unimproved Flood",7.2,"LEVAN",1.3059999999999996,6.66,4.7639999999999993,0.80390390390390398,33.299999999999997,26.77,1.3059999999999996]
[null,null,null,"Phosphate (11-52-0)",192,"pounds",0.63,{"$f":"E68*G68","v":120.96000000000001},null,null,null,"Phosphate (11-52-0)",192,"pounds",0.63,{"$f":"M68*O68","v":120.96000000000001},null,"Wheel Line",1.0285714285714287,"LOA",1.0240000000000002,5.234,4.6280000000000001,0.80435613297669084,26.17,21.05,1.0240000000000002]
[null,null,null,"Custom application",1,"acre",7.82,{"$f":"E69*G69","v":7.82},null,null,null,"Custom application",1,"acre",7.82,{"$f":"M69*O69","v":7.82},null,null,null,"LOGAN 5SW",1.4660000000000004,6.3280000000000003,3.9359999999999999,{"$f":"+Z69/Y69","v":0.76833122629582806},31.64,24.31,{"$f":"+(Y69-Z69)/5","v":1.4660000000000004}]
[null,null,"Pesticides/herbicides",null,null,null,null,null,null,null,"Pesticides/herbicides",null,null,null,null,null,null,null,null,"LOGAN RADIO",1.5879999999999996,6.7319999999999993,4.6659999999999995,0.76411170528817596,33.659999999999997,25.72,1.5879999999999996]
[null,null,null,"Permethrin",8,"oz",0.98,7.84,null,null,null,"Permethrin",8,"oz",0.98,{"$f":"M71*O71","v":7.84},null,"One or More Farm Laborers",null,"LOGAN USU",1.74,6.3179999999999996,4.1379999999999999,0.72459639126305797,31.59,22.89,1.7399999999999998]
[null,null,null,"Gramoxone Extra",1.5,"oz",5.85,8.7749999999999986,null,null,null,"Gramoxone Extra",1.5,"oz",5.85,{"$f":"M72*O72","v":8.7749999999999986},null,"Owner and/or Farm Manager",null,"MANILA",1.1980000000000004,5.4960000000000004,4.6880000000000006,0.78202328966521095,27.48,21.49,1.1980000000000004]
[null,null,null,"Pursuit",4,"oz",4.4608999999999996,17.843599999999999,null,null,null,"Pursuit",4,"oz",4.4608999999999996,{"$f":"M73*O73","v":17.843599999999999},null,null,null,"MANTI",1.3140000000000001,6.4060000000000006,4.7880000000000003,0.7948798001873244,32.03,25.46,1.3140000000000001]
[null,null,null,"Custom application",2,"acre",7.82,15.64,null,null,null,"Custom application",2,"acre",7.82,{"$f":"M74*O74","v":15.64},null,null,null,"MARYSVALE",0.97599999999999976,6.3079999999999998,5.4340000000000002,0.84527584020291691,31.54,26.66,0.97599999999999976]
[null,null,"Irrigation",null,null,null,null,null,null,null,"Irrigation",null,7,"irrigations",null,null,null,null,null,"MEXICAN HAT",0.9899999999999991,9.1440000000000001,8.4160000000000004,0.89173228346456701,45.72,40.770000000000003,0.9899999999999991]
[null,null,null,{"$f":"L12","v":0},null,null,null,null,null,null,null,{"$f":"L14","v":0},null,null,null,null,null,null,null,"MIDVALE",1.3760000000000006,7.4680000000000009,5.5760000000000005,0.81574718800214241,37.340000000000003,30.46,1.3760000000000006]
[null,null,null,"Labor",{"$f":"LOOKUP(D76,$R$64:$R$68,$S$64:$S$68)","v":{"$error":"#N/A"}},"hours",{"$f":"H14","v":0},{"$error":"#N/A"},null,null,null,"Labor",{"$f":"(LOOKUP(L76,$R$64:$R$68,$S$64:$S$68))+(H23/E35)","v":{"$error":"#N/A"}},"hours",{"$f":"H14","v":0},{"$f":"M77*O77","v":{"$error":"#N/A"}},null,null,null,"MILFORD",1.0739999999999994,7.08,5.97,0.84830508474576283,35.4,30.03,1.0739999999999994]
[null,null,null,"Water assessment",1,"share",20,20,null,null,null,"Water assessment",1,"share",20,{"$f":"M78*O78","v":20},null,null,null,"MOAB",1.1719999999999999,8.61,7.5359999999999996,0.8638792102206736,43.05,37.19,1.1719999999999999]
[null,null,null,"Repairs/maintenance",1,"acre",2.2999999999999998,2.2999999999999998,null,null,null,"Repairs/maintenance",1,"acre",2.2999999999999998,{"$f":"M79*O79","v":2.2999999999999998},null,null,null,"MODENA",1.1239999999999994,7.4319999999999995,6.2619999999999996,0.84876210979547906,37.159999999999997,31.54,1.1239999999999994]
[null,null,null,"Pumping",1,"acre",0,0,null,null,null,"Pumping",1,"acre",0,{"$f":"M80*O80","v":0},null,null,null,"MONTICELLO",1.4,6.032,4.2919999999999998,0.76790450928381959,30.16,23.16,1.4]
[null,null,"Harvesting",null,null,null,null,null,null,null,"Harvesting",null,null,null,null,null,null,null,null,"MORGAN",1.3420000000000001,6.3340000000000005,3.8940000000000006,0.78812756551941898,31.67,24.96,1.3420000000000001]
[null,null,null,"Swathing",4,"acre",4.0342850617283954,16.137140246913582,null,null,null,"Swathing",4,"acre",4.0342850617283954,{"$f":"M82*O82","v":16.137140246913582},null,null,null,"MORONI",1.0560000000000003,6.6859999999999999,5.4879999999999995,0.84205803170804661,33.43,28.15,1.0560000000000003]
[null,null,null,"Raking",4,"acre",1.3922788008130083,5.569115203252033,null,null,null,"Raking",4,"acre",1.3922788008130083,{"$f":"M83*O83","v":5.569115203252033},null,null,null,"NEOLA",1.0879999999999996,5.8479999999999999,4.9079999999999995,0.81395348837209314,29.24,23.8,1.0879999999999996]
[null,null,null,"Baling ",{"$f":"D25","v":{"$error":"#N/A"}},"tons",4.79,{"$f":"E84*G84","v":{"$error":"#N/A"}},null,null,null,"Baling ",{"$f":"E25","v":{"$error":"#N/A"}},"tons",4.79,{"$f":"M84*O84","v":{"$error":"#N/A"}},null,null,null,"NEPHI",1.3940000000000006,7.1420000000000003,5.2320000000000002,0.80481657798935868,35.71,28.74,1.3940000000000006]
[null,null,null,"Hauling/stacking",{"$f":"D25","v":{"$error":"#N/A"}},"tons",3.63,{"$f":"E85*G85","v":{"$error":"#N/A"}},null,null,null,"Hauling/stacking",{"$f":"E25","v":{"$error":"#N/A"}},"tons",3.63,{"$f":"M85*O85","v":{"$error":"#N/A"}},null,null,null,"NEW HARMONY",1.468,7.1079999999999997,4.7140000000000004,0.79347214406302757,35.54,28.2,1.468]
[null,null,"Crop insurance (75% Yield, 100% Price)",null,1,"acre",19.11,19.11,null,null,"Crop insurance (75% Yield, 100% Price)",null,1,"acre",19.11,{"$f":"M86*O86","v":19.11},null,null,null,"OAK CITY",1.3679999999999999,7.35,5.661999999999999,0.81387755102040815,36.75,29.91,1.3679999999999999]
[null,null,"Interest on operating capital",null,null,null,7.6100000000000001E-2,{"$f":"((SUM(H68:H74)*G87*(6/12))+SUM(H77:H85)*G87*(3/12))","v":{"$error":"#N/A"}},null,null,"Interest on operating capital",null,null,null,7.6100000000000001E-2,{"$f":"((SUM(P68:P74)*O87*(6/12))+SUM(P77:P85)*O87*(3/12))","v":{"$error":"#N/A"}},null,null,null,"OGDEN SUGAR FACTORY",1.714,7.42,5.1379999999999999,0.76900269541778976,37.1,28.53,1.714]
[null,null,null,"Subtotal",null,null,null,{"$f":"SUM(H68:H87)","v":{"$error":"#N/A"}},null,null,null,"Subtotal",null,null,null,{"$f":"SUM(P68:P87)","v":{"$error":"#N/A"}},null,null,null,"ORDERVILLE",1.2479999999999998,6.9379999999999997,4.9219999999999997,0.82012107235514564,34.69,28.45,1.2479999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PANGUITCH",1.1380000000000003,5.9820000000000002,5.0579999999999998,0.8097626211969241,29.91,24.22,1.1380000000000003]
[null,"Ownership costs (excludes cost of land)",null,null,null,null,null,null,null,"Ownership costs (excludes cost of land)",null,null,null,null,null,null,null,null,null,"PARK VALLEY",1.268,5.9240000000000004,4.7460000000000004,0.7859554355165429,29.62,23.28,1.268]
[null,null,"Farm insurance",null,1,"acre",2,2,null,null,"Farm insurance",null,1,"acre",2,{"$f":"M91*O91","v":2},null,null,null,"PAROWAN",1.31,6.6739999999999995,5.1819999999999995,0.80371591249625418,33.369999999999997,26.82,1.3099999999999994]
[null,null,"Machinery ownership costs",null,1,"acre",49.634396795383097,49.634396795383097,null,null,"Machinery ownership costs",null,1,"acre",49.634396795383097,{"$f":"M92*O92","v":49.634396795383097},null,null,null,"PARTOUN",0.97199999999999986,6.6379999999999999,6.6379999999999999,0.85357035251581803,33.19,28.33,0.97199999999999986]
[null,null,"Irrigation equipment  costs",null,1,"acre",8.25,8.25,null,null,"Irrigation equipment  costs",null,1,"acre",8.25,{"$f":"M93*O93","v":8.25},null,null,null,"PELICAN LAKE/OURAY",1.2240000000000009,7.9340000000000002,7.22,0.84572724981094016,39.67,33.549999999999997,1.2240000000000009]
[null,null,null,"Total Ownership Costs",null,null,null,{"$f":"SUM(H91:H93)","v":59.884396795383097},null,null,null,"Total Ownership Costs",null,null,null,{"$f":"SUM(P91:P93)","v":59.884396795383097},null,null,null,"PLEASANT GROVE",1.5560000000000003,7.05,4.8040000000000003,0.77929078014184394,35.25,27.47,1.5560000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLEASANT VALLEY/MYTON",1.028,7.194,6.5220000000000002,0.85710314150681122,35.97,30.83,1.028]
[null,null,null,"Total Costs",null,null,null,{"$f":"H94+H88","v":{"$error":"#N/A"}},null,null,null,"Total Costs",null,null,null,{"$f":"P94+P88","v":{"$error":"#N/A"}},null,null,null,"PRICE",1.1499999999999999,7.1920000000000002,6.19,0.84010011123470518,35.96,30.21,1.1499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROVO",1.8539999999999992,7.4739999999999993,4.8279999999999994,0.75194005887075199,37.369999999999997,28.1,1.8539999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANDOLPH",1.06,4.0579999999999998,4.0579999999999998,0.7387875800887137,20.29,14.99,1.0599999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RICHFIELD",1.0380000000000003,6.8340000000000005,5.9440000000000008,0.84811237928007022,34.17,28.98,1.0380000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RICHMOND",1.6840000000000004,6.9640000000000004,4.4660000000000002,0.75818495117748419,34.82,26.4,1.6840000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVERDALE",1.7979999999999996,6.7239999999999993,4.2619999999999996,0.73259964306960146,33.619999999999997,24.63,1.7979999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROOSEVELT",1.1040000000000005,7.47,6.668000000000001,0.85220883534136538,37.35,31.83,1.1040000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUSH VALLEY/ JOHNSON PASS",1.5880000000000003,6.6920000000000002,6.6920000000000002,0.76270173341303049,33.46,25.52,1.5880000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALINA",1.08,6.9159999999999995,5.7319999999999993,0.84384037015615965,34.58,29.18,1.0799999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALT LAKE CITY",1.5920000000000001,6.992,4.8559999999999999,0.77231121281464532,34.96,27,1.5920000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANDY RANCH",1.0120000000000005,6.7060000000000004,5.93,0.84909036683566952,33.53,28.47,1.0120000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCIPIO",1.2239999999999995,6.4580000000000002,4.7940000000000005,0.81046763703933111,32.29,26.17,1.2239999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCOFIELD DAM",0,0,-1.786,{"$error":"#DIV/0!"},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SNOWVILLE",1.24,6.3439999999999994,4.9479999999999995,0.8045397225725095,31.72,25.52,1.2399999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPANISH FORK PWR PLNT",1.7819999999999994,7.11,4.4659999999999993,0.74936708860759504,35.549999999999997,26.64,1.7819999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST GEORGE",0.97600000000000053,9.6780000000000008,8.5540000000000003,0.89915271750361636,48.39,43.51,0.97600000000000053]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THIOKOL/ HOWELL",1.4119999999999997,6.9640000000000004,5.3160000000000007,0.79724296381390014,34.82,27.76,1.4119999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOOELE",1.7280000000000002,6.734,4.3979999999999997,0.74339174339174341,33.67,25.03,1.7280000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TREMONTON",1.7059999999999995,6.7159999999999993,4.5999999999999996,0.74597974985110194,33.58,25.05,1.7059999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRENTON/ LEWISTON",1.42,6.2320000000000002,3.9120000000000004,0.77214377406931956,31.16,24.06,1.4200000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TROPIC",1.2119999999999997,6.28,4.9219999999999988,0.80700636942675164,31.4,25.34,1.2119999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNIV OF UTAH",1.7820000000000007,6.8680000000000003,4.3760000000000003,0.74053581828771109,34.340000000000003,25.43,1.7820000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UTAH LAKE LEHI",1.2619999999999998,6.9139999999999997,5.524,0.81747179635522138,34.57,28.26,1.2619999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERNAL",1.0839999999999996,7.0359999999999996,6.1119999999999992,0.84593519044911891,35.18,29.76,1.0839999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERNON",1.1299999999999999,6.4580000000000002,5.266,0.82502322700526487,32.29,26.64,1.1299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEYO",1.4579999999999997,8.1660000000000004,6.21,0.82145481263776632,40.83,33.54,1.4579999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WAH WAH RANCH",0.96400000000000008,6.9580000000000002,6.282,0.86145444093130208,34.79,29.97,0.96400000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WANSHIP",1.3220000000000005,5.87,3.9160000000000004,0.77478705281090277,29.35,22.74,1.3220000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WENDOVER",0.8380000000000003,6.3920000000000003,5.8940000000000001,0.86889862327909884,31.96,27.77,0.8380000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOODRUFF",0.96400000000000008,4.3520000000000003,3.4220000000000002,0.77849264705882348,21.76,16.940000000000001,0.96400000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZION NP",1.63,8.8699999999999992,8.8699999999999992,0.81623449830890649,44.35,36.200000000000003,1.6299999999999997]

{"sheet":"Sample Analysis Sheet","index":1,"n_rows":126,"n_cols":27,"rows_kept":126,"cut":false,"hidden":false,"merged":[[64,14,65,14],[64,15,65,15],[55,1,55,13],[62,1,62,15],[63,1,63,7],[63,9,63,15],[64,4,65,4],[64,5,65,5],[64,6,65,6],[64,7,65,7],[64,12,65,12],[64,13,65,13],[34,7,34,8],[34,12,34,13],[36,1,36,13],[37,1,37,13],[38,2,38,4],[38,6,38,8],[38,10,38,11],[28,7,28,8],[28,12,28,13],[30,7,30,8],[30,12,30,13],[32,7,32,8],[32,12,32,13],[26,7,26,8],[26,12,26,13],[11,7,11,8],[13,7,13,8],[15,1,15,13],[16,1,16,2],[17,7,17,8],[17,11,17,12],[19,1,19,13],[22,7,22,8],[22,12,22,13],[24,7,24,8],[24,12,24,13],[9,7,9,8],[1,1,1,13],[2,1,2,13],[3,1,3,13],[5,7,5,8],[7,7,7,8]]}
[]
[null,"THE ECONOMICS OF IRRIGATION EFFICIENCY IMPROVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"System Type","Hours per Acre to Operate",null,null,"Station Name 2007","Base Yield","Max Yield","Yield Within Influence","% Within Influence","CU Value for Alfalfa","NIR (annual)","Alt. Base Yield"]
[null,"Economic Analysis Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,2008,2008,2008,2008,2008,2008]
[null,"Instructions:  Enter data into all applicable blue cells.  The yellow results cells and summary will auto-populate based on the information entered into the blue cells.",null,null,null,null,null,null,null,null,null,null,null,null,null,"High-Efficiency Flood (Graded Borders)",0.11,null,null,"ALLEN'S RANCH",1.0980000000000003,6.734,6.734,{"$f":"+Z4/Y4","v":0.83694683694683691},33.67,28.18,{"$f":"+(Y4-Z4)/5","v":1.0980000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Improved Flood",0.13,null,null,"ALPINE",1.5340000000000003,6.9420000000000002,4.6360000000000001,{"$f":"+Z5/Y5","v":0.77902621722846432},34.71,27.04,{"$f":"+(Y5-Z5)/5","v":1.5340000000000003}]
[null,"1.","How efficient is your current irrigation system?",0.55000000000000004,null,"6.","What is the expected market value of your crop?",200,null,"11.","What interest rate would you expect to pay if you were to borrow money to fund your project?",0.03,null,null,null,"None",0,null,null,"ALTAMONT",1.0739999999999994,5.5759999999999996,4.5839999999999996,0.80738880918220957,27.88,22.51,1.0739999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pivot",0.09,null,null,"ALTON",1.3140000000000001,5.79,3.7460000000000004,0.77305699481865287,28.95,22.38,1.3140000000000001]
[null,"2.","How efficient will your new, updated, or better-managed irrigation system be?",0.6,null,"7.","How much will it cost you (total out-of-pocket) to install your new irrigation system or to upgrade your existing system?",10000,null,"12.","Which climate station is closest to your farm?","FAIRFIELD",null,null,null,"Unimproved Flood",0.9,"Yes",null,"ANTIMONY",0.84,5.0579999999999998,4.63,0.83392645314353497,25.29,21.09,0.83999999999999986]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheel Line",0.18,"No",null,"BEAR RIVER BAY",1.4279999999999995,6.1479999999999997,4.51,0.76772934287573202,30.74,23.6,1.4279999999999995]
[null,"3.","How many acres are covered by your current irrigation system?",160,"Acres","8.","How much do you estimate you currently spend per year on all irrigation-related energy for the project area?",8700,null,"13.","Are you going to install soil moisture sensors as part of your irrigation efficiency improvement project?","Yes",null,null,null,null,null,null,null,"BEAVER",1.19,5.9039999999999999,4.6660000000000004,0.79844173441734423,29.52,23.57,1.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High-Efficiency Flood (Graded Borders)",null,null,null,"BIRDSEYE",1.1299999999999999,5.5540000000000003,3.762,0.79654303204897381,27.77,22.12,1.1299999999999997]
[null,"4.","How many acres will be covered by your new irrigation system and/or efficiency improvement project?",160,"Acres","9.","How much do you estimate you will spend per year on all system-related energy after implementing your project?",7600,null,"14.","What type of irrigation system is your \"before\" system?","Wheel Line",null,null,null,"Improved Flood",null,null,null,"BLACK ROCK",1.0640000000000007,7.1120000000000001,7.1120000000000001,0.85039370078740151,35.56,30.24,1.0640000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pivot",null,null,null,"BLANDING",1.3440000000000005,7.02,5.354000000000001,0.80854700854700845,35.1,28.38,1.3440000000000005]
[null,"5.","How many acre feet of water (per acre) will be available for you to use?",2,"Acre Feet","10.","What is the hourly value of the system operator's and/or soil moisture sensor data collector's time? ",12,null,"15.","What type of irrigation system will your \"after\" system be?","Wheel Line",null,null,null,null,null,null,null,"BLUFF",0.98599999999999999,8.4580000000000002,7.5,0.88342397729959798,42.29,37.36,0.98599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOULDER",1.18,6.02,4.8620000000000001,0.80398671096345509,30.1,24.2,1.1800000000000004]
[null,"Answer questions 16 through 18 if you are installing soil moisture sensors.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRIGHAM CITY",1.7380000000000002,7.3340000000000005,4.572000000000001,0.76302154349604578,36.67,27.98,1.7380000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALLAO",0.93600000000000061,6.7540000000000004,6.1880000000000006,0.8614154575066626,33.770000000000003,29.09,0.93600000000000061]
[null,"16.","Is this project an IWM-only project?  ","No",null,"17.","If you are going to install soil moisture sensors, how many will you install?",16,null,"18.","If you are going to install soil moisture sensors, how much will the sensors and reader system cost (total, including installation)?",1380,null,null,null,null,null,null,null,"CASTLEDALE",0.99400000000000044,6.4560000000000004,5.6720000000000006,0.84603469640644358,32.28,27.31,0.99400000000000044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASTLE VALLEY",1.3379999999999996,7.85,7.85,0.8295541401273886,39.25,32.56,1.3379999999999996]
[null,"Economic Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDAR CITY",1.1819999999999999,6.6840000000000002,5.4120000000000008,0.8231597845601436,33.42,27.51,1.1819999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDAR POINT",1.4319999999999999,6.68,6.68,0.78562874251497006,33.4,26.24,1.4319999999999999]
[null,null,null,"\"Before\"","\"After\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIRCLEVILLE",1.0720000000000005,5.9340000000000002,5.0919999999999996,0.8193461408830468,29.67,24.31,1.0720000000000005]
[null,null,"System Efficiency: ",{"$f":"D6","v":0.55000000000000004},{"$f":"D8","v":0.6},"Acre Inches","Estimated Time per Year to Read Soil Moisture Sensors and Analyze Data:",{"$f":"IF(L10=\"Yes\",((28*((30*2)+(H18*5)))/60),0)","v":65.333333333333329},null,null,"Maximum Potential Yield ",{"$f":"+L29/5","v":6.444},"Tons",null,null,null,null,null,null,"COALVILLE",1.3520000000000003,5.9420000000000002,3.9740000000000002,0.7724671827667452,29.71,22.95,1.3520000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CORINNE",1.6240000000000001,6.9779999999999998,4.9719999999999995,0.76726855832616792,34.89,26.77,1.6240000000000001]
[null,null,"Estimated Yield per Acre:",{"$f":"IF(L25>L31,(((L31/5)*D23)+L33),(((L25/5)*D23)+L33))","v":3.8739999999999997},{"$f":"IF(L25>L31,(((L31/5)*E23)+L33),(((L25/5)*E23)+L33))","v":4.113999999999999},"Tons","Difference in Yield per Acre:",{"$f":"E25-D25","v":0.23999999999999932},null,"Tons","Total Acre Inches Available for Crop Production:",{"$f":"(D14*12)","v":24},"Acre Inches",null,null,null,null,null,null,"COTTONWOOD WEIR / EAST BENCH",2.1839999999999997,6.6879999999999997,6.6879999999999997,0.67344497607655507,33.44,22.52,2.1839999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COVE FORT",1.1160000000000003,5.9340000000000002,4.2780000000000005,0.8119312436804853,29.67,24.09,1.1160000000000003]
[null,null,"Total Tons Produced:",{"$f":"+D25*D10","v":619.83999999999992},{"$f":"+E25*D12","v":658.23999999999978},"Tons","Difference in Total Tons Produced:",{"$f":"+E27-D27","v":38.399999999999864},null,"Tons","Percent of Total Yield that Can be Affected by Efficiency Measures:",{"$f":"IF($L$8=\" \",\" \",LOOKUP($L8,$T$4:$T$128,$X$4:$X$128))","v":0.80850403476101806},null,null,null,null,null,null,null,"DEER CREEK DAM",1.4060000000000001,5.92,5.92,0.76249999999999996,29.6,22.57,1.4060000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DELTA",1.04,7.5280000000000005,6.5580000000000007,0.86184909670563226,37.64,32.44,1.0400000000000005]
[null,null,"Total Revenue:",{"$f":"+D27*H6","v":123967.99999999999},{"$f":"+E27*H6","v":131647.99999999994},null,"Difference in Total Revenue:",{"$f":"+E29-D29","v":7679.9999999999563},null,null,"Consumptive Use Value (CU):",{"$f":"IF($L$8=\" \",\" \",LOOKUP($L8,$T$4:$T$128,$Y$4:$Y$128))","v":32.22},"Inches",null,null,null,null,null,null,"DEWEY",1.0540000000000007,8.668000000000001,8.668000000000001,0.87840332256575904,43.34,38.07,1.0540000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DUCHESNE",1.2120000000000004,6.6920000000000002,5.7640000000000002,0.81888822474596523,33.46,27.4,1.2120000000000004]
[null,null,"Estimated Total Operating Cost:",{"$f":"('Sample Analysis Sheet'!H96*D35)+H10","v":65554.422397198097},{"$f":"(P96*E35)+H12","v":65582.817312398111},null,"Difference in Estimated Total Operating Cost:",{"$f":"+E31-D31","v":28.394915200013202},null,null,"Net Irrigation Requirement (NIR):",{"$f":"IF($L$8=\" \",\" \",LOOKUP($L8,$T$4:$T$128,$Z$4:$Z$128))","v":26.05},"Inches",null,null,null,null,null,null,"DUGWAY",1.0620000000000005,7.3340000000000005,6.42,0.85519498227433866,36.67,31.36,1.0620000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELBERTA",1.2440000000000004,7.1540000000000008,5.886000000000001,0.82611126642437793,35.770000000000003,29.55,1.2440000000000004]
[null,null,"Total Inches of Water Required to Produce Max Potential Yield Given the Efficiency of the System:",{"$f":"+((L$23-L$33)*5)/D$23","v":47.363636363636367},{"$f":"+((L$23-L$33)*5)/E$23","v":43.416666666666679},"Inches","Estimated Difference in Total  Net Revenue:",{"$f":"H29-H31","v":7651.6050847999431},null,null,"Base Yield/Acre:",{"$f":"+(L29-L31)/5","v":1.2339999999999995},"Tons",null,null,null,null,null,null,"EMERY",1.0160000000000005,5.9380000000000006,5.2640000000000002,0.82889861906365769,29.69,24.61,1.0160000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENTERPRISE/ BERYL",1.1240000000000001,7.0780000000000003,5.9260000000000002,0.84119807855326356,35.39,29.77,1.1240000000000001]
[null,null,"Total Acres in Production:",{"$f":"D10","v":160},{"$f":"D12","v":160},"Acres","Estimated Profit Per Hour for Soil Moisture Sensor Reading and Data Analysis:",{"$f":"IF($L$10=\"Yes\",(IF(D18=\"Yes\",($H$33/$H$23),((H33*(IF($L14=\" \",\" \",LOOKUP($L14,$P$4:$P$9,$Q$4:$Q$9))))/H23))),0)","v":21.080952784652908},null,null,"Approximate Payoff Period for Project (Years):",{"$f":"IF(H33>0,+(ABS((LN(1-((L6/12)*((H8+L18)/(H33/12)))))/(LN(1+(L6/12))))/12),\"Will Never Pay Off\")","v":1.5233714496454029},"Years",null,null,null,null,null,null,"EPHRAIM",1.2480000000000004,6.62,6.62,0.81148036253776434,33.1,26.86,1.2480000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESCALANTE",1.1859999999999999,7.7780000000000005,6.6380000000000008,0.84751864232450502,38.89,32.96,1.1859999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESKDALE",0.96600000000000041,7.0260000000000007,7.0260000000000007,0.86251067463706232,35.130000000000003,30.3,0.96600000000000041]
[null,"Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAIRFIELD",1.2339999999999995,6.444,5.0199999999999996,0.80850403476101806,32.22,26.05,1.2339999999999995]
[null,null,"\"Before & After\" Figures",null,null,null,"Basic Data",null,null,null,"Economic Results",null,null,null,null,null,null,null,null,"FARMINGTON USU",2.0080000000000005,7.3980000000000006,4.3840000000000003,0.72857529061908621,36.99,26.95,2.0080000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FERRON",1.046,6.1059999999999999,5.2480000000000002,0.82869308876514902,30.53,25.3,1.046]
[null,null,"\"Before\" System Efficiency:",{"$f":"D23","v":0.55000000000000004},null,null,"Total Acres in Production:",{"$f":"D10","v":160},"Acres",null,"Estimated Profit per Hour for Soil Moisture Sensor Reading: ",{"$f":"H35","v":21.080952784652908},null,null,null,null,null,null,null,"FILLMORE",1.45,7.14,5.0760000000000005,0.79691876750700275,35.700000000000003,28.45,1.4500000000000006]
[null,null,"\"After\" System Efficiency:",{"$f":"E23","v":0.6},null,null,"Difference in Yield Per Acre:",{"$f":"H25","v":0.23999999999999932},"Tons",null,null,null,null,null,null,null,null,null,null,"FISH SPRINGS",1.1040000000000005,7.4260000000000002,7.4260000000000002,0.85133315378400209,37.130000000000003,31.61,1.1040000000000005]
[null,null,"Before Yield per Acre:",{"$f":"D25","v":3.8739999999999997},"Tons",null,"Difference in Total Tons Produced:",{"$f":"H27","v":38.399999999999864},"Tons",null,"Difference in Total Revenue:",{"$f":"H29","v":7679.9999999999563},null,null,null,null,null,null,null,"FLAMING GORGE",1.3020000000000003,5.8179999999999996,5.8179999999999996,0.77621175661739428,29.09,22.58,1.3020000000000003]
[null,null,"After Yield per Acre:",{"$f":"E25","v":4.113999999999999},"Tons",null,"Maximum Potential Yield:",{"$f":"L23","v":6.444},"Tons",null,null,null,null,null,null,null,null,null,null,"FORT DUCHESNE",0.93400000000000039,6.9760000000000009,6.3060000000000009,0.86611238532110091,34.880000000000003,30.21,0.93400000000000039]
[null,null,"Before Acres:",{"$f":"D33","v":47.363636363636367},"Acres",null,"Base Yield per Acre:",{"$f":"L33","v":1.2339999999999995},"Tons",null,"Difference in Total Costs:",{"$f":"H31","v":28.394915200013202},null,null,null,null,null,null,null,"FRUITLAND",1.2939999999999998,5.8220000000000001,4.5819999999999999,0.77773960838199929,29.11,22.64,1.2939999999999998]
[null,null,"After Acres:",{"$f":"E33","v":43.416666666666679},"Acres",null,"Percent of Max that can be Affected:",{"$f":"L27","v":0.80850403476101806},null,null,null,null,null,null,null,null,null,null,null,"GARFIELD",1.79,6.2560000000000002,4.0640000000000001,0.71387468030690526,31.28,22.33,1.7900000000000005]
[null,null,"Before Total Tons Produced:",{"$f":"D27","v":619.83999999999992},"Tons",null,"Total Acre Inches Available:",{"$f":"L25","v":24},"Ac In",null,"Estimated Total Additional Net Revenue per Year:",{"$f":"H33","v":7651.6050847999431},null,null,null,null,null,null,null,"GARRISON",1.01,7.22,6.3520000000000003,0.86011080332409973,36.1,31.05,1.0100000000000002]
[null,null,"After Total Tons Produced:",{"$f":"E27","v":658.23999999999978},"Tons",null,"Consumptive Use Value:",{"$f":"L29","v":32.22},"Inches",null,null,null,null,null,null,null,null,null,null,"GRANTSVILLE",1.31,6.854000000000001,6.854000000000001,0.8088707324190253,34.270000000000003,27.72,1.3100000000000009]
[null,null,"Before Total Revenue:",{"$f":"D29","v":123967.99999999999},null,null,"Net Irrigation Requirement:",{"$f":"L31","v":26.05},"Inches",null,"Approximate Payoff Period for Project (in Years):",{"$f":"L35","v":1.5233714496454029},null,null,null,null,null,null,null,"GREEN RIVER",1.03,8.395999999999999,7.895999999999999,0.87732253454025733,41.98,36.83,1.0299999999999998]
[null,null,"After Total Revenue:",{"$f":"E29","v":131647.99999999994},null,null,"Sensor Reading Hr/Yr:",{"$f":"D35","v":160},"Hours",null,null,null,null,null,null,null,null,null,null,"GROUSE CREEK",1.1340000000000003,5.9420000000000002,4.68,0.80915516661056874,29.71,24.04,1.1340000000000003]
[null,null,"Before Estimated Cost:",{"$f":"D31","v":65554.422397198097},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUNNISON",0.97399999999999953,6.7159999999999993,5.61,0.85497319833234076,33.58,28.71,0.97399999999999953]
[null,null,"After Estimated Cost:",{"$f":"E31","v":65582.817312398111},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HANKSVILLE",0.9159999999999997,9.032,8.4619999999999997,0.89858281665190431,45.16,40.58,0.9159999999999997]
[null,null,"Before Total Inches of Water Required for Max:",{"$f":"D33","v":47.363636363636367},"Inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HANNA",1.1679999999999999,5.3380000000000001,4.0979999999999999,0.78119145747470964,26.69,20.85,1.1679999999999999]
[null,null,"After Total Inches of Water Required for Max:",{"$f":"E33","v":43.416666666666679},"Inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEBER",1.2419999999999995,6.298,4.0960000000000001,0.80279453794855515,31.49,25.28,1.2419999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HENRIEVILLE",1.1379999999999995,6.73,5.5119999999999996,0.83090638930163452,33.65,27.96,1.1379999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUNTSVILLE",1.4780000000000002,6.2539999999999996,3.1979999999999995,0.76367125039974415,31.27,23.88,1.4780000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IBAPAH",1.0519999999999996,5.84,4.8040000000000003,0.81986301369863024,29.2,23.94,1.0519999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IOSEPA",1.0679999999999992,8.2459999999999987,6.9459999999999988,0.87048265825854965,41.23,35.89,1.0679999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JENSEN",1.0480000000000005,7.3040000000000003,6.4020000000000001,0.85651697699890472,36.520000000000003,31.28,1.0480000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KAMAS",1.22,5.22,3.0380000000000007,0.76628352490421447,26.1,20,1.2200000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KANAB",1.4960000000000009,8.52,6.75,0.82441314553990597,42.6,35.119999999999997,1.4960000000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KANOSH",1.482,7.0579999999999998,5.0579999999999998,0.79002550297534713,35.29,27.88,1.482]
[null,"Crop Budgets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor Hours per Year per Acre","KOOSHAREM",1.0219999999999998,5.1859999999999999,4.2699999999999996,0.80293096799074437,25.93,20.82,1.0219999999999998]
[null,"\"Before\" Scenario",null,null,null,null,null,null,null,"\"After\" Scenario",null,null,null,null,null,null,null,"High-Efficiency Flood (Graded Borders)",0.76500000000000012,"LAKETOWN",1.2,5.39,3.9859999999999998,0.77736549165120594,26.95,20.95,1.2]
[null,null,null,null,"Quantity per acre","Unit","Cost per unit","Projected Cost per Acre",null,null,null,null,"Quantity per acre","Unit","Cost per unit","Projected Cost per Acre",null,"Improved Flood",1.8,"LASAL",1.4160000000000004,6.2919999999999998,4.8919999999999995,0.77495232040686579,31.46,24.38,1.4160000000000004]
[null,"Operating costs",null,null,null,null,null,null,null,"Operating costs",null,null,null,null,null,null,null,"Pivot",0.6352941176470589,"LAVERKIN",1.3159999999999996,9.3580000000000005,7.8260000000000005,0.85937166061124171,46.79,40.21,1.3159999999999996]
[null,null,"Fertilization",null,null,null,null,null,null,null,"Fertilization",null,null,null,null,null,null,"Unimproved Flood",7.2,"LEVAN",1.3059999999999996,6.66,4.7639999999999993,0.80390390390390398,33.299999999999997,26.77,1.3059999999999996]
[null,null,null,"Phosphate (11-52-0)",192,"pounds",0.63,{"$f":"E68*G68","v":120.96000000000001},null,null,null,"Phosphate (11-52-0)",192,"pounds",0.63,{"$f":"M68*O68","v":120.96000000000001},null,"Wheel Line",1.0285714285714287,"LOA",1.0240000000000002,5.234,4.6280000000000001,0.80435613297669084,26.17,21.05,1.0240000000000002]
[null,null,null,"Custom application",1,"acre",7.82,{"$f":"E69*G69","v":7.82},null,null,null,"Custom application",1,"acre",7.82,{"$f":"M69*O69","v":7.82},null,null,null,"LOGAN 5SW",1.4660000000000004,6.3280000000000003,3.9359999999999999,{"$f":"+Z69/Y69","v":0.76833122629582806},31.64,24.31,{"$f":"+(Y69-Z69)/5","v":1.4660000000000004}]
[null,null,"Pesticides/herbicides",null,null,null,null,null,null,null,"Pesticides/herbicides",null,null,null,null,null,null,null,null,"LOGAN RADIO",1.5879999999999996,6.7319999999999993,4.6659999999999995,0.76411170528817596,33.659999999999997,25.72,1.5879999999999996]
[null,null,null,"Permethrin",8,"oz",0.98,7.84,null,null,null,"Permethrin",8,"oz",0.98,{"$f":"M71*O71","v":7.84},null,"One or More Farm Laborers",null,"LOGAN USU",1.74,6.3179999999999996,4.1379999999999999,0.72459639126305797,31.59,22.89,1.7399999999999998]
[null,null,null,"Gramoxone Extra",1.5,"oz",5.85,8.7749999999999986,null,null,null,"Gramoxone Extra",1.5,"oz",5.85,{"$f":"M72*O72","v":8.7749999999999986},null,"Owner and/or Farm Manager",null,"MANILA",1.1980000000000004,5.4960000000000004,4.6880000000000006,0.78202328966521095,27.48,21.49,1.1980000000000004]
[null,null,null,"Pursuit",4,"oz",4.4608999999999996,17.843599999999999,null,null,null,"Pursuit",4,"oz",4.4608999999999996,{"$f":"M73*O73","v":17.843599999999999},null,null,null,"MANTI",1.3140000000000001,6.4060000000000006,4.7880000000000003,0.7948798001873244,32.03,25.46,1.3140000000000001]
[null,null,null,"Custom application",2,"acre",7.82,15.64,null,null,null,"Custom application",2,"acre",7.82,{"$f":"M74*O74","v":15.64},null,null,null,"MARYSVALE",0.97599999999999976,6.3079999999999998,5.4340000000000002,0.84527584020291691,31.54,26.66,0.97599999999999976]
[null,null,"Irrigation",null,null,null,null,null,null,null,"Irrigation",null,7,"irrigations",null,null,null,null,null,"MEXICAN HAT",0.9899999999999991,9.1440000000000001,8.4160000000000004,0.89173228346456701,45.72,40.770000000000003,0.9899999999999991]
[null,null,null,{"$f":"L12","v":"Wheel Line"},null,null,null,null,null,null,null,{"$f":"L14","v":"Wheel Line"},null,null,null,null,null,null,null,"MIDVALE",1.3760000000000006,7.4680000000000009,5.5760000000000005,0.81574718800214241,37.340000000000003,30.46,1.3760000000000006]
[null,null,null,"Labor",{"$f":"LOOKUP(D76,$R$64:$R$68,$S$64:$S$68)","v":1.0285714285714287},"hours",{"$f":"H14","v":12},12.342857142857145,null,null,null,"Labor",{"$f":"(LOOKUP(L76,$R$64:$R$68,$S$64:$S$68))+(H23/E35)","v":1.4369047619047621},"hours",{"$f":"H14","v":12},{"$f":"M77*O77","v":17.242857142857147},null,null,null,"MILFORD",1.0739999999999994,7.08,5.97,0.84830508474576283,35.4,30.03,1.0739999999999994]
[null,null,null,"Water assessment",1,"share",20,20,null,null,null,"Water assessment",1,"share",20,{"$f":"M78*O78","v":20},null,null,null,"MOAB",1.1719999999999999,8.61,7.5359999999999996,0.8638792102206736,43.05,37.19,1.1719999999999999]
[null,null,null,"Repairs/maintenance",1,"acre",2.2999999999999998,2.2999999999999998,null,null,null,"Repairs/maintenance",1,"acre",2.2999999999999998,{"$f":"M79*O79","v":2.2999999999999998},null,null,null,"MODENA",1.1239999999999994,7.4319999999999995,6.2619999999999996,0.84876210979547906,37.159999999999997,31.54,1.1239999999999994]
[null,null,null,"Pumping",1,"acre",0,0,null,null,null,"Pumping",1,"acre",0,{"$f":"M80*O80","v":0},null,null,null,"MONTICELLO",1.4,6.032,4.2919999999999998,0.76790450928381959,30.16,23.16,1.4]
[null,null,"Harvesting",null,null,null,null,null,null,null,"Harvesting",null,null,null,null,null,null,null,null,"MORGAN",1.3420000000000001,6.3340000000000005,3.8940000000000006,0.78812756551941898,31.67,24.96,1.3420000000000001]
[null,null,null,"Swathing",4,"acre",4.0342850617283954,16.137140246913582,null,null,null,"Swathing",4,"acre",4.0342850617283954,{"$f":"M82*O82","v":16.137140246913582},null,null,null,"MORONI",1.0560000000000003,6.6859999999999999,5.4879999999999995,0.84205803170804661,33.43,28.15,1.0560000000000003]
[null,null,null,"Raking",4,"acre",1.3922788008130083,5.569115203252033,null,null,null,"Raking",4,"acre",1.3922788008130083,{"$f":"M83*O83","v":5.569115203252033},null,null,null,"NEOLA",1.0879999999999996,5.8479999999999999,4.9079999999999995,0.81395348837209314,29.24,23.8,1.0879999999999996]
[null,null,null,"Baling ",{"$f":"D25","v":3.8739999999999997},"tons",4.79,{"$f":"E84*G84","v":18.556459999999998},null,null,null,"Baling ",{"$f":"E25","v":4.113999999999999},"tons",4.79,{"$f":"M84*O84","v":19.706059999999994},null,null,null,"NEPHI",1.3940000000000006,7.1420000000000003,5.2320000000000002,0.80481657798935868,35.71,28.74,1.3940000000000006]
[null,null,null,"Hauling/stacking",{"$f":"D25","v":3.8739999999999997},"tons",3.63,{"$f":"E85*G85","v":14.062619999999999},null,null,null,"Hauling/stacking",{"$f":"E25","v":4.113999999999999},"tons",3.63,{"$f":"M85*O85","v":14.933819999999995},null,null,null,"NEW HARMONY",1.468,7.1079999999999997,4.7140000000000004,0.79347214406302757,35.54,28.2,1.468]
[null,null,"Crop insurance (75% Yield, 100% Price)",null,1,"acre",19.11,19.11,null,null,"Crop insurance (75% Yield, 100% Price)",null,1,"acre",19.11,{"$f":"M86*O86","v":19.11},null,null,null,"OAK CITY",1.3679999999999999,7.35,5.661999999999999,0.81387755102040815,36.75,29.91,1.3679999999999999]
[null,null,"Interest on operating capital",null,null,null,7.6100000000000001E-2,{"$f":"((SUM(H68:H74)*G87*(6/12))+SUM(H77:H85)*G87*(3/12))","v":8.4989505940822578},null,null,"Interest on operating capital",null,null,null,7.6100000000000001E-2,{"$f":"((SUM(P68:P74)*O87*(6/12))+SUM(P77:P85)*O87*(3/12))","v":8.6306188140822577},null,null,null,"OGDEN SUGAR FACTORY",1.714,7.42,5.1379999999999999,0.76900269541778976,37.1,28.53,1.714]
[null,null,null,"Subtotal",null,null,null,{"$f":"SUM(H68:H87)","v":295.45574318710504},null,null,null,"Subtotal",null,null,null,{"$f":"SUM(P68:P87)","v":302.50821140710502},null,null,null,"ORDERVILLE",1.2479999999999998,6.9379999999999997,4.9219999999999997,0.82012107235514564,34.69,28.45,1.2479999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PANGUITCH",1.1380000000000003,5.9820000000000002,5.0579999999999998,0.8097626211969241,29.91,24.22,1.1380000000000003]
[null,"Ownership costs (excludes cost of land)",null,null,null,null,null,null,null,"Ownership costs (excludes cost of land)",null,null,null,null,null,null,null,null,null,"PARK VALLEY",1.268,5.9240000000000004,4.7460000000000004,0.7859554355165429,29.62,23.28,1.268]
[null,null,"Farm insurance",null,1,"acre",2,2,null,null,"Farm insurance",null,1,"acre",2,{"$f":"M91*O91","v":2},null,null,null,"PAROWAN",1.31,6.6739999999999995,5.1819999999999995,0.80371591249625418,33.369999999999997,26.82,1.3099999999999994]
[null,null,"Machinery ownership costs",null,1,"acre",49.634396795383097,49.634396795383097,null,null,"Machinery ownership costs",null,1,"acre",49.634396795383097,{"$f":"M92*O92","v":49.634396795383097},null,null,null,"PARTOUN",0.97199999999999986,6.6379999999999999,6.6379999999999999,0.85357035251581803,33.19,28.33,0.97199999999999986]
[null,null,"Irrigation equipment  costs",null,1,"acre",8.25,8.25,null,null,"Irrigation equipment  costs",null,1,"acre",8.25,{"$f":"M93*O93","v":8.25},null,null,null,"PELICAN LAKE/OURAY",1.2240000000000009,7.9340000000000002,7.22,0.84572724981094016,39.67,33.549999999999997,1.2240000000000009]
[null,null,null,"Total Ownership Costs",null,null,null,{"$f":"SUM(H91:H93)","v":59.884396795383097},null,null,null,"Total Ownership Costs",null,null,null,{"$f":"SUM(P91:P93)","v":59.884396795383097},null,null,null,"PLEASANT GROVE",1.5560000000000003,7.05,4.8040000000000003,0.77929078014184394,35.25,27.47,1.5560000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLEASANT VALLEY/MYTON",1.028,7.194,6.5220000000000002,0.85710314150681122,35.97,30.83,1.028]
[null,null,null,"Total Costs",null,null,null,{"$f":"H94+H88","v":355.34013998248815},null,null,null,"Total Costs",null,null,null,{"$f":"P94+P88","v":362.39260820248813},null,null,null,"PRICE",1.1499999999999999,7.1920000000000002,6.19,0.84010011123470518,35.96,30.21,1.1499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROVO",1.8539999999999992,7.4739999999999993,4.8279999999999994,0.75194005887075199,37.369999999999997,28.1,1.8539999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANDOLPH",1.06,4.0579999999999998,4.0579999999999998,0.7387875800887137,20.29,14.99,1.0599999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RICHFIELD",1.0380000000000003,6.8340000000000005,5.9440000000000008,0.84811237928007022,34.17,28.98,1.0380000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RICHMOND",1.6840000000000004,6.9640000000000004,4.4660000000000002,0.75818495117748419,34.82,26.4,1.6840000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVERDALE",1.7979999999999996,6.7239999999999993,4.2619999999999996,0.73259964306960146,33.619999999999997,24.63,1.7979999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROOSEVELT",1.1040000000000005,7.47,6.668000000000001,0.85220883534136538,37.35,31.83,1.1040000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUSH VALLEY/ JOHNSON PASS",1.5880000000000003,6.6920000000000002,6.6920000000000002,0.76270173341303049,33.46,25.52,1.5880000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALINA",1.08,6.9159999999999995,5.7319999999999993,0.84384037015615965,34.58,29.18,1.0799999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALT LAKE CITY",1.5920000000000001,6.992,4.8559999999999999,0.77231121281464532,34.96,27,1.5920000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANDY RANCH",1.0120000000000005,6.7060000000000004,5.93,0.84909036683566952,33.53,28.47,1.0120000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCIPIO",1.2239999999999995,6.4580000000000002,4.7940000000000005,0.81046763703933111,32.29,26.17,1.2239999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCOFIELD DAM",0,0,-1.786,{"$error":"#DIV/0!"},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SNOWVILLE",1.24,6.3439999999999994,4.9479999999999995,0.8045397225725095,31.72,25.52,1.2399999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPANISH FORK PWR PLNT",1.7819999999999994,7.11,4.4659999999999993,0.74936708860759504,35.549999999999997,26.64,1.7819999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST GEORGE",0.97600000000000053,9.6780000000000008,8.5540000000000003,0.89915271750361636,48.39,43.51,0.97600000000000053]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THIOKOL/ HOWELL",1.4119999999999997,6.9640000000000004,5.3160000000000007,0.79724296381390014,34.82,27.76,1.4119999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOOELE",1.7280000000000002,6.734,4.3979999999999997,0.74339174339174341,33.67,25.03,1.7280000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TREMONTON",1.7059999999999995,6.7159999999999993,4.5999999999999996,0.74597974985110194,33.58,25.05,1.7059999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRENTON/ LEWISTON",1.42,6.2320000000000002,3.9120000000000004,0.77214377406931956,31.16,24.06,1.4200000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TROPIC",1.2119999999999997,6.28,4.9219999999999988,0.80700636942675164,31.4,25.34,1.2119999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNIV OF UTAH",1.7820000000000007,6.8680000000000003,4.3760000000000003,0.74053581828771109,34.340000000000003,25.43,1.7820000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UTAH LAKE LEHI",1.2619999999999998,6.9139999999999997,5.524,0.81747179635522138,34.57,28.26,1.2619999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERNAL",1.0839999999999996,7.0359999999999996,6.1119999999999992,0.84593519044911891,35.18,29.76,1.0839999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERNON",1.1299999999999999,6.4580000000000002,5.266,0.82502322700526487,32.29,26.64,1.1299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEYO",1.4579999999999997,8.1660000000000004,6.21,0.82145481263776632,40.83,33.54,1.4579999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WAH WAH RANCH",0.96400000000000008,6.9580000000000002,6.282,0.86145444093130208,34.79,29.97,0.96400000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WANSHIP",1.3220000000000005,5.87,3.9160000000000004,0.77478705281090277,29.35,22.74,1.3220000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WENDOVER",0.8380000000000003,6.3920000000000003,5.8940000000000001,0.86889862327909884,31.96,27.77,0.8380000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOODRUFF",0.96400000000000008,4.3520000000000003,3.4220000000000002,0.77849264705882348,21.76,16.940000000000001,0.96400000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZION NP",1.63,8.8699999999999992,8.8699999999999992,0.81623449830890649,44.35,36.200000000000003,1.6299999999999997]

{"sheet":"Assumptions","index":2,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Value or Term","How it's calculated in the spreadsheet OR its definition"]
[null,"Acre inches that efficiency measures make available for additional yield and other uses (wildlife, etc.)","Total acre inches available x (\"after\" percent efficiency - \"before\" percent efficiency)"]
[null,"Approximate payoff period for project (years)","Estimated number of years it will take to pay for the planned irrigation system improvements assuming that all additional net revenue is paid toward the loan each year until the loan is completely paid off (based on the interest rate entered by the user … should be used for economic analysis regardless of whether or not the producer actually needs to borrow money in order to fund the project)"]
[null,"Base yield","(CU - NIR) / 5"]
[null,"Consumptive use value (CU)","Total inches of water that the crop is able to utilize for growth given local climate and precipitation conditions"]
[null,"Difference in tons produced","\"After\" tons produced - \"before\" tons produced"]
[null,"Difference in total revenue","\"After\" total revenue - \"before\" total revenue"]
[null,"Difference in yield per acre","\"After\" yield - \"before\" yield"]
[null,"Estimated profit per hour for soil moisture sensor reading","((Estimated total additional net revenue) x (percent of total efficiency improvement that can be attributed to IWM as opposed to the irrigation system alone)) / estimated time per year to read soil moisture sensors"]
[null,"Estimated time per year to read soil moisture sensors and analyze data","((30 minutes x 2 times per week to collect data) + (5 minutes per sensor to analyze data)) x 28 weeks"]
[null,"Estimated total additional net revenue","Difference in total revenue - estimated additional production costs"]
[null,"Estimated yield per acre if water availability is a limiting factor","((Acre inches available / 5) x (percent system efficiency)) + base yield"]
[null,"Estimated yield per acre if water availability is not a limiting factor","((NIR / 5) x (percent system efficiency)) + base yield"]
[null,"Inches of water required per ton of yield","Assumed to be equal to 5 inches"]
[null,"Labor costs","Determined by user"]
[null,"Maximum potential yield","CU / 5 (This assumes a 100% efficient irrigation system, which is not possible to achieve under actual field conditions)"]
[null,"Net irrigation requirement (NIR)","Total inches of irrigation water required to make up the difference between average precipitation and CU"]
[null,"Percent of total efficiency improvement that can be attributed to IWM as opposed to the irrigation system alone","Unimproved flood: 90%; Improved flood: 80%; Wheel line: 40%; Pivot: 20%; High-Efficiency Flood/Graded Borders: 90%"]
[null,"Percent of total yield that can be affected by efficiency measures","NIR / CU"]
[null,"System efficiency","Determined by user"]
[null,"Total acre inches available for crop production","(Water right or available water in acre feet per acre) x 12"]
[null,"Total acres in production","Determined by user"]
[null,"Total inches required to produce maximum potential yield given the efficiency of the system","((Maximum yield - base yield) x 5) / (percent system efficiency)"]
[null,"Total revenue","Total tons produced x expected market value of the crop"]
[null,"Total tons produced","Estimated yield x total acres in production"]

{"sheet":"Climate Station Data","index":3,"n_rows":125,"n_cols":8,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Station Name 2007","Base Yield","Max Yield","Yield Within Influence","% Within Influence","CU Value for Alfalfa","NIR (annual)","Alt. Base Yield"]
[null,2006,2008,2008,2008,2008,2008,2008]
["ALLEN'S RANCH",1.0980000000000003,6.734,6.734,{"$f":"+G3/F3","v":0.83694683694683691},33.67,28.18,{"$f":"+(F3-G3)/5","v":1.0980000000000003}]
["ALPINE",1.5340000000000003,6.9420000000000002,4.6360000000000001,{"$f":"+G4/F4","v":0.77902621722846432},34.71,27.04,{"$f":"+(F4-G4)/5","v":1.5340000000000003}]
["ALTAMONT",1.0739999999999994,5.5759999999999996,4.5839999999999996,0.80738880918220957,27.88,22.51,1.0739999999999994]
["ALTON",1.3140000000000001,5.79,3.7460000000000004,0.77305699481865287,28.95,22.38,1.3140000000000001]
["ANTIMONY",0.84,5.0579999999999998,4.63,0.83392645314353497,25.29,21.09,0.83999999999999986]
["BEAR RIVER BAY",1.4279999999999995,6.1479999999999997,4.51,0.76772934287573202,30.74,23.6,1.4279999999999995]
["BEAVER",1.19,5.9039999999999999,4.6660000000000004,0.79844173441734423,29.52,23.57,1.19]
["BIRDSEYE",1.1299999999999999,5.5540000000000003,3.762,0.79654303204897381,27.77,22.12,1.1299999999999997]
["BLACK ROCK",1.0640000000000007,7.1120000000000001,7.1120000000000001,0.85039370078740151,35.56,30.24,1.0640000000000007]
["BLANDING",1.3440000000000005,7.02,5.354000000000001,0.80854700854700845,35.1,28.38,1.3440000000000005]
["BLUFF",0.98599999999999999,8.4580000000000002,7.5,0.88342397729959798,42.29,37.36,0.98599999999999999]
["BOULDER",1.18,6.02,4.8620000000000001,0.80398671096345509,30.1,24.2,1.1800000000000004]
["BRIGHAM CITY",1.7380000000000002,7.3340000000000005,4.572000000000001,0.76302154349604578,36.67,27.98,1.7380000000000002]
["CALLAO",0.93600000000000061,6.7540000000000004,6.1880000000000006,0.8614154575066626,33.770000000000003,29.09,0.93600000000000061]
["CASTLEDALE",0.99400000000000044,6.4560000000000004,5.6720000000000006,0.84603469640644358,32.28,27.31,0.99400000000000044]
["CASTLE VALLEY",1.3379999999999996,7.85,7.85,0.8295541401273886,39.25,32.56,1.3379999999999996]
["CEDAR CITY",1.1819999999999999,6.6840000000000002,5.4120000000000008,0.8231597845601436,33.42,27.51,1.1819999999999999]
["CEDAR POINT",1.4319999999999999,6.68,6.68,0.78562874251497006,33.4,26.24,1.4319999999999999]
["CIRCLEVILLE",1.0720000000000005,5.9340000000000002,5.0919999999999996,0.8193461408830468,29.67,24.31,1.0720000000000005]
["COALVILLE",1.3520000000000003,5.9420000000000002,3.9740000000000002,0.7724671827667452,29.71,22.95,1.3520000000000003]
["CORINNE",1.6240000000000001,6.9779999999999998,4.9719999999999995,0.76726855832616792,34.89,26.77,1.6240000000000001]
["COTTONWOOD WEIR / EAST BENCH",2.1839999999999997,6.6879999999999997,6.6879999999999997,0.67344497607655507,33.44,22.52,2.1839999999999997]
["COVE FORT",1.1160000000000003,5.9340000000000002,4.2780000000000005,0.8119312436804853,29.67,24.09,1.1160000000000003]
["DEER CREEK DAM",1.4060000000000001,5.92,5.92,0.76249999999999996,29.6,22.57,1.4060000000000001]
["DELTA",1.04,7.5280000000000005,6.5580000000000007,0.86184909670563226,37.64,32.44,1.0400000000000005]
["DEWEY",1.0540000000000007,8.668000000000001,8.668000000000001,0.87840332256575904,43.34,38.07,1.0540000000000007]
["DUCHESNE",1.2120000000000004,6.6920000000000002,5.7640000000000002,0.81888822474596523,33.46,27.4,1.2120000000000004]
["DUGWAY",1.0620000000000005,7.3340000000000005,6.42,0.85519498227433866,36.67,31.36,1.0620000000000005]
["ELBERTA",1.2440000000000004,7.1540000000000008,5.886000000000001,0.82611126642437793,35.770000000000003,29.55,1.2440000000000004]
["EMERY",1.0160000000000005,5.9380000000000006,5.2640000000000002,0.82889861906365769,29.69,24.61,1.0160000000000005]
["ENTERPRISE/ BERYL",1.1240000000000001,7.0780000000000003,5.9260000000000002,0.84119807855326356,35.39,29.77,1.1240000000000001]
["EPHRAIM",1.2480000000000004,6.62,6.62,0.81148036253776434,33.1,26.86,1.2480000000000004]
["ESCALANTE",1.1859999999999999,7.7780000000000005,6.6380000000000008,0.84751864232450502,38.89,32.96,1.1859999999999999]
["ESKDALE",0.96600000000000041,7.0260000000000007,7.0260000000000007,0.86251067463706232,35.130000000000003,30.3,0.96600000000000041]
["FAIRFIELD",1.2339999999999995,6.444,5.0199999999999996,0.80850403476101806,32.22,26.05,1.2339999999999995]
["FARMINGTON USU",2.0080000000000005,7.3980000000000006,4.3840000000000003,0.72857529061908621,36.99,26.95,2.0080000000000005]
["FERRON",1.046,6.1059999999999999,5.2480000000000002,0.82869308876514902,30.53,25.3,1.046]
["FILLMORE",1.45,7.14,5.0760000000000005,0.79691876750700275,35.700000000000003,28.45,1.4500000000000006]
["FISH SPRINGS",1.1040000000000005,7.4260000000000002,7.4260000000000002,0.85133315378400209,37.130000000000003,31.61,1.1040000000000005]
["FLAMING GORGE",1.3020000000000003,5.8179999999999996,5.8179999999999996,0.77621175661739428,29.09,22.58,1.3020000000000003]
["FORT DUCHESNE",0.93400000000000039,6.9760000000000009,6.3060000000000009,0.86611238532110091,34.880000000000003,30.21,0.93400000000000039]
["FRUITLAND",1.2939999999999998,5.8220000000000001,4.5819999999999999,0.77773960838199929,29.11,22.64,1.2939999999999998]
["GARFIELD",1.79,6.2560000000000002,4.0640000000000001,0.71387468030690526,31.28,22.33,1.7900000000000005]
["GARRISON",1.01,7.22,6.3520000000000003,0.86011080332409973,36.1,31.05,1.0100000000000002]
["GRANTSVILLE",1.31,6.854000000000001,6.854000000000001,0.8088707324190253,34.270000000000003,27.72,1.3100000000000009]
["GREEN RIVER",1.03,8.395999999999999,7.895999999999999,0.87732253454025733,41.98,36.83,1.0299999999999998]
["GROUSE CREEK",1.1340000000000003,5.9420000000000002,4.68,0.80915516661056874,29.71,24.04,1.1340000000000003]
["GUNNISON",0.97399999999999953,6.7159999999999993,5.61,0.85497319833234076,33.58,28.71,0.97399999999999953]
["HANKSVILLE",0.9159999999999997,9.032,8.4619999999999997,0.89858281665190431,45.16,40.58,0.9159999999999997]
["HANNA",1.1679999999999999,5.3380000000000001,4.0979999999999999,0.78119145747470964,26.69,20.85,1.1679999999999999]
["HEBER",1.2419999999999995,6.298,4.0960000000000001,0.80279453794855515,31.49,25.28,1.2419999999999995]
["HENRIEVILLE",1.1379999999999995,6.73,5.5119999999999996,0.83090638930163452,33.65,27.96,1.1379999999999995]
["HUNTSVILLE",1.4780000000000002,6.2539999999999996,3.1979999999999995,0.76367125039974415,31.27,23.88,1.4780000000000002]
["IBAPAH",1.0519999999999996,5.84,4.8040000000000003,0.81986301369863024,29.2,23.94,1.0519999999999996]
["IOSEPA",1.0679999999999992,8.2459999999999987,6.9459999999999988,0.87048265825854965,41.23,35.89,1.0679999999999992]
["JENSEN",1.0480000000000005,7.3040000000000003,6.4020000000000001,0.85651697699890472,36.520000000000003,31.28,1.0480000000000005]
["KAMAS",1.22,5.22,3.0380000000000007,0.76628352490421447,26.1,20,1.2200000000000002]
["KANAB",1.4960000000000009,8.52,6.75,0.82441314553990597,42.6,35.119999999999997,1.4960000000000009]
["KANOSH",1.482,7.0579999999999998,5.0579999999999998,0.79002550297534713,35.29,27.88,1.482]
["KOOSHAREM",1.0219999999999998,5.1859999999999999,4.2699999999999996,0.80293096799074437,25.93,20.82,1.0219999999999998]
["LAKETOWN",1.2,5.39,3.9859999999999998,0.77736549165120594,26.95,20.95,1.2]
["LASAL",1.4160000000000004,6.2919999999999998,4.8919999999999995,0.77495232040686579,31.46,24.38,1.4160000000000004]
["LAVERKIN",1.3159999999999996,9.3580000000000005,7.8260000000000005,0.85937166061124171,46.79,40.21,1.3159999999999996]
["LEVAN",1.3059999999999996,6.66,4.7639999999999993,0.80390390390390398,33.299999999999997,26.77,1.3059999999999996]
["LOA",1.0240000000000002,5.234,4.6280000000000001,{"$f":"+G67/F67","v":0.80435613297669084},26.17,21.05,{"$f":"+(F67-G67)/5","v":1.0240000000000002}]
["LOGAN 5SW",1.4660000000000004,6.3280000000000003,3.9359999999999999,0.76833122629582806,31.64,24.31,1.4660000000000004]
["LOGAN RADIO",1.5879999999999996,6.7319999999999993,4.6659999999999995,0.76411170528817596,33.659999999999997,25.72,1.5879999999999996]
["LOGAN USU",1.74,6.3179999999999996,4.1379999999999999,0.72459639126305797,31.59,22.89,1.7399999999999998]
["MANILA",1.1980000000000004,5.4960000000000004,4.6880000000000006,0.78202328966521095,27.48,21.49,1.1980000000000004]
["MANTI",1.3140000000000001,6.4060000000000006,4.7880000000000003,0.7948798001873244,32.03,25.46,1.3140000000000001]
["MARYSVALE",0.97599999999999976,6.3079999999999998,5.4340000000000002,0.84527584020291691,31.54,26.66,0.97599999999999976]
["MEXICAN HAT",0.9899999999999991,9.1440000000000001,8.4160000000000004,0.89173228346456701,45.72,40.770000000000003,0.9899999999999991]
["MIDVALE",1.3760000000000006,7.4680000000000009,5.5760000000000005,0.81574718800214241,37.340000000000003,30.46,1.3760000000000006]
["MILFORD",1.0739999999999994,7.08,5.97,0.84830508474576283,35.4,30.03,1.0739999999999994]
["MOAB",1.1719999999999999,8.61,7.5359999999999996,0.8638792102206736,43.05,37.19,1.1719999999999999]
["MODENA",1.1239999999999994,7.4319999999999995,6.2619999999999996,0.84876210979547906,37.159999999999997,31.54,1.1239999999999994]
["MONTICELLO",1.4,6.032,4.2919999999999998,0.76790450928381959,30.16,23.16,1.4]
["MORGAN",1.3420000000000001,6.3340000000000005,3.8940000000000006,0.78812756551941898,31.67,24.96,1.3420000000000001]
["MORONI",1.0560000000000003,6.6859999999999999,5.4879999999999995,0.84205803170804661,33.43,28.15,1.0560000000000003]
["NEOLA",1.0879999999999996,5.8479999999999999,4.9079999999999995,0.81395348837209314,29.24,23.8,1.0879999999999996]
["NEPHI",1.3940000000000006,7.1420000000000003,5.2320000000000002,0.80481657798935868,35.71,28.74,1.3940000000000006]
["NEW HARMONY",1.468,7.1079999999999997,4.7140000000000004,0.79347214406302757,35.54,28.2,1.468]
["OAK CITY",1.3679999999999999,7.35,5.661999999999999,0.81387755102040815,36.75,29.91,1.3679999999999999]
["OGDEN SUGAR FACTORY",1.714,7.42,5.1379999999999999,0.76900269541778976,37.1,28.53,1.714]
["ORDERVILLE",1.2479999999999998,6.9379999999999997,4.9219999999999997,0.82012107235514564,34.69,28.45,1.2479999999999998]
["PANGUITCH",1.1380000000000003,5.9820000000000002,5.0579999999999998,0.8097626211969241,29.91,24.22,1.1380000000000003]
["PARK VALLEY",1.268,5.9240000000000004,4.7460000000000004,0.7859554355165429,29.62,23.28,1.268]
["PAROWAN",1.31,6.6739999999999995,5.1819999999999995,0.80371591249625418,33.369999999999997,26.82,1.3099999999999994]
["PARTOUN",0.97199999999999986,6.6379999999999999,6.6379999999999999,0.85357035251581803,33.19,28.33,0.97199999999999986]
["PELICAN LAKE/OURAY",1.2240000000000009,7.9340000000000002,7.22,0.84572724981094016,39.67,33.549999999999997,1.2240000000000009]
["PLEASANT GROVE",1.5560000000000003,7.05,4.8040000000000003,0.77929078014184394,35.25,27.47,1.5560000000000003]
["PLEASANT VALLEY/MYTON",1.028,7.194,6.5220000000000002,0.85710314150681122,35.97,30.83,1.028]
["PRICE",1.1499999999999999,7.1920000000000002,6.19,0.84010011123470518,35.96,30.21,1.1499999999999999]
["PROVO",1.8539999999999992,7.4739999999999993,4.8279999999999994,0.75194005887075199,37.369999999999997,28.1,1.8539999999999992]
["RANDOLPH",1.06,4.0579999999999998,4.0579999999999998,0.7387875800887137,20.29,14.99,1.0599999999999998]
["RICHFIELD",1.0380000000000003,6.8340000000000005,5.9440000000000008,0.84811237928007022,34.17,28.98,1.0380000000000003]
["RICHMOND",1.6840000000000004,6.9640000000000004,4.4660000000000002,0.75818495117748419,34.82,26.4,1.6840000000000004]
["RIVERDALE",1.7979999999999996,6.7239999999999993,4.2619999999999996,0.73259964306960146,33.619999999999997,24.63,1.7979999999999996]
["ROOSEVELT",1.1040000000000005,7.47,6.668000000000001,0.85220883534136538,37.35,31.83,1.1040000000000005]
["RUSH VALLEY/ JOHNSON PASS",1.5880000000000003,6.6920000000000002,6.6920000000000002,0.76270173341303049,33.46,25.52,1.5880000000000003]
["SALINA",1.08,6.9159999999999995,5.7319999999999993,0.84384037015615965,34.58,29.18,1.0799999999999996]
["SALT LAKE CITY",1.5920000000000001,6.992,4.8559999999999999,0.77231121281464532,34.96,27,1.5920000000000001]
["SANDY RANCH",1.0120000000000005,6.7060000000000004,5.93,0.84909036683566952,33.53,28.47,1.0120000000000005]
["SCIPIO",1.2239999999999995,6.4580000000000002,4.7940000000000005,0.81046763703933111,32.29,26.17,1.2239999999999995]
["SCOFIELD DAM",0,0,-1.786,{"$error":"#DIV/0!"},null,null,0]
["SNOWVILLE",1.24,6.3439999999999994,4.9479999999999995,0.8045397225725095,31.72,25.52,1.2399999999999998]
["SPANISH FORK PWR PLNT",1.7819999999999994,7.11,4.4659999999999993,0.74936708860759504,35.549999999999997,26.64,1.7819999999999994]
["ST GEORGE",0.97600000000000053,9.6780000000000008,8.5540000000000003,0.89915271750361636,48.39,43.51,0.97600000000000053]
["THIOKOL/ HOWELL",1.4119999999999997,6.9640000000000004,5.3160000000000007,0.79724296381390014,34.82,27.76,1.4119999999999997]
["TOOELE",1.7280000000000002,6.734,4.3979999999999997,0.74339174339174341,33.67,25.03,1.7280000000000002]
["TREMONTON",1.7059999999999995,6.7159999999999993,4.5999999999999996,0.74597974985110194,33.58,25.05,1.7059999999999995]
["TRENTON/ LEWISTON",1.42,6.2320000000000002,3.9120000000000004,0.77214377406931956,31.16,24.06,1.4200000000000004]
["TROPIC",1.2119999999999997,6.28,4.9219999999999988,0.80700636942675164,31.4,25.34,1.2119999999999997]
["UNIV OF UTAH",1.7820000000000007,6.8680000000000003,4.3760000000000003,0.74053581828771109,34.340000000000003,25.43,1.7820000000000007]
["UTAH LAKE LEHI",1.2619999999999998,6.9139999999999997,5.524,0.81747179635522138,34.57,28.26,1.2619999999999998]
["VERNAL",1.0839999999999996,7.0359999999999996,6.1119999999999992,0.84593519044911891,35.18,29.76,1.0839999999999996]
["VERNON",1.1299999999999999,6.4580000000000002,5.266,0.82502322700526487,32.29,26.64,1.1299999999999997]
["VEYO",1.4579999999999997,8.1660000000000004,6.21,0.82145481263776632,40.83,33.54,1.4579999999999997]
["WAH WAH RANCH",0.96400000000000008,6.9580000000000002,6.282,0.86145444093130208,34.79,29.97,0.96400000000000008]
["WANSHIP",1.3220000000000005,5.87,3.9160000000000004,0.77478705281090277,29.35,22.74,1.3220000000000005]
["WENDOVER",0.8380000000000003,6.3920000000000003,5.8940000000000001,0.86889862327909884,31.96,27.77,0.8380000000000003]
["WOODRUFF",0.96400000000000008,4.3520000000000003,3.4220000000000002,0.77849264705882348,21.76,16.940000000000001,0.96400000000000008]
["ZION NP",1.63,8.8699999999999992,8.8699999999999992,0.81623449830890649,44.35,36.200000000000003,1.6299999999999997]