{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Agronomy Tech Note 63","SISL Help","SISL Present Condition","SISL Alternative 1","SISL Alternative 2","SISL Print out","Soil Volume x Bulk Density 2013","Soil Volume x Bulk Density 1983"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":1,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Agronomy Tech Note 63","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SISL Help","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"     This spreadsheet has all of the tables and equation that was developed with the SISL model built in.  "]
[null,"But for the users peace of mind the tables are also included in the help section."]
[null,"The green",null," indicates cells that require user input.  Select the tab at the bottom for Present Condition, Alternative 1,"]
[null,"or Alternative 2.  Enter the values indicated by the green and the program will calculate the associated SISL value."]
[null,"The columns Crop Class through Irrigation Practice are not regular spreadsheet cells so the normal spreadsheet commands will not"]
[null,"work ( arrow, tab, page up or down). These cells are pick lists and can be selected by a mouse click on the cell."]
[]
[null,"When selecting a PAM option, choose the method that is used and don't select a second conservation practice or irrigation practice."]
[]
[null,"To print the current worksheet press Ctrl B.  To print a summary of all the alternatives press Crtl A.  "]
[null,"Press Ctrl T to return to the top of the page."]

{"sheet":"SISL Present Condition","index":2,"n_rows":142,"n_cols":45,"rows_kept":142,"cut":false,"hidden":false,"merged":[[6,9,6,10],[8,9,8,10],[18,10,18,12],[22,10,22,11],[22,8,22,9],[15,1,15,4],[23,8,23,9],[38,1,38,2],[24,1,24,2],[34,1,34,2],[32,1,32,2],[6,2,6,6],[8,2,8,6],[11,7,11,14],[15,6,15,7],[120,2,120,3],[120,4,120,5],[26,1,26,2],[28,1,28,2],[121,2,121,3],[11,0,11,6],[107,2,107,6],[109,2,109,6],[132,10,132,11],[132,8,132,9],[131,8,131,9],[119,10,119,11],[121,8,121,9],[123,6,123,7],[120,6,120,7],[122,6,122,7],[122,8,122,9],[128,6,128,7],[125,6,125,7],[127,10,127,12],[128,10,128,12],[129,10,129,12],[124,10,124,12],[125,10,125,12],[124,2,124,3],[124,4,124,5],[125,2,125,3],[126,2,126,3],[125,4,125,5],[124,6,124,7],[121,4,121,5],[122,2,122,3],[122,4,122,5],[123,2,123,3],[123,4,123,5],[121,6,121,7],[123,8,123,9],[118,10,118,12],[120,8,120,9],[109,8,109,9],[121,10,121,12],[122,10,122,12],[6,14,6,15],[8,14,8,15],[126,4,126,5],[126,6,126,7],[126,10,126,12],[120,10,120,12],[124,8,124,9],[119,6,119,7],[123,10,123,12],[111,2,111,5],[113,2,113,12],[23,1,23,2],[21,11,21,12],[18,6,18,7],[19,6,19,7],[30,1,30,2],[17,10,17,11],[40,1,40,2],[42,1,42,2],[14,10,14,11],[23,3,23,4],[36,1,36,2],[118,0,119,1],[118,2,119,3],[118,4,119,5],[107,11,107,12],[109,11,109,12],[116,2,116,5],[116,0,116,1],[119,8,119,9],[118,6,118,7],[118,8,118,9],[116,11,116,12],[107,8,107,9],[129,2,129,3],[129,4,129,5],[129,6,129,7],[127,8,127,9],[128,8,128,9],[127,2,127,3],[127,4,127,5],[129,8,129,9],[125,8,125,9],[126,8,126,9],[127,6,127,7],[128,2,128,3],[128,4,128,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,null,null,null,null,"Conservation",null,"Irrigation ",null,"Irrigation ",null,"Convex ","Slope","Irrigation ","Crop ","Run "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface Irrigation Soil Loss (SISL) Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K factor","Adjustment","Prior Crop","Adjustment","Practice","Adjustment","Management","Adjustment","Management","Adjustment","Category",null,"Type","Class","Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado Agronomy Technical Note 63 (Revised)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing",1,null,null,"Nothing",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional Tillage",1,null,null,"Conventional Tillage",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.22",0.45,"Pasture",0.65,"Residue Management",0.2,"Nothing",1,"Residue Management",0.2,"None","< 1%","Siphon Tubes","Permanent Cover",660]
[null,"Cooperator","",null,null,null,null,null,"Tract",null,null,null,null,"Date",{"$f":"TODAY()","v":"2013-06-26"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.28",0.56999999999999995,"Alfalfa",0.7,"   Seasonal",0.2,"High level IWM w/o cutback",0.9,"   Seasonal",0.2,"Moderate","1-1.9%","Gated Pipe","Close Growing",1320]
[null,null,null,null,null,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.32",0.65,"Mint",0.7,"   Mulch Till",0.15,"High level IWM with cutback",0.7,"   Mulch Till",0.15,"Severe","2-2.9%","Dirt Ditches With Feeder Ditch","Row Crop"]
[null,"Planner","",null,null,null,null,null,"Field",null,null,null,null,"Conservation District",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.37",0.76,"Alfalfa Seed",0.75,"   No Till",0.1,"Surge Irrigation",0.5,"   No Till",0.1,null,"> 3%",null,"Intensive Row Crop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.43",0.87,"Small Grain high residue",0.75,"PAM  Full Season (FS)",0.5,null,null,"PAM  Full Season (FS)",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.49",1,"Corn high residue",0.75,"FS   PAM alone",0.3,null,null,"FS   PAM alone",0.3]
["Present Condition Resource Description and Inventory Date",null,null,null,null,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.55",1.1200000000000001,"Peas",0.8,"FS   PAM + IWM",0.05,null,null,"FS   PAM + IWM",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corn Silage",0.85,"FS   PAM + IWM +Res. Mgt.",0.01,null,null,"FS   PAM + IWM +Res. Mgt.",0.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,null,null,"Small Grain residue harvested",0.85,"PAM Part Season (PS)",0.3,null,null,"PAM Part Season (PS)",0.5]
[null,"Soil Survey Area",null,null,null,null,"Soil Map Unit",null,null,null,"Slope",null,null,"K Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sugar Beets",1,"PS   PAM alone",0.5,null,null,"PS   PAM alone",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,"bsl","con pra2","iwm1","con pra","Ka Factor","pc factor","iwm2",null,"Beans",1,"PS   PAM + IWM",0.2,null,null,"PS   PAM + IWM",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,{"$f":"bsl($AQ$21,AR21,$AS$21,$AP$21,$AO$21)","v":0},{"$f":"IF(AK21=\"\",1,VLOOKUP(AK21,_iwm2,2,FALSE))","v":1},{"$f":"IF(AM21=\"\",1,VLOOKUP(AM21,iwm,2,FALSE))","v":1},{"$f":"IF(AI21=\"\",1,VLOOKUP(AI21,ConPra,2,FALSE))","v":1},{"$f":"IF(AB8=\"\",1,VLOOKUP(AB8,AE6:AF12,2,FALSE))","v":1},{"$f":"IF(AG21=\"\",1,VLOOKUP(AG21,Priorcrop,2,FALSE))","v":1},{"$f":"IF(AN21=\"\",1,VLOOKUP(AN21,iwm,2,FALSE))","v":1},null,"Potatoes",1,"PS   PAM + IWM +Res. Mgt.",0.05,null,null,"PS   PAM + IWM +Res. Mgt.",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"bsl($AQ$21,AR22,$AS$21,$AP$21,$AO$21)","v":0},1,{"$f":"IF(AM22=\"\",1,VLOOKUP(AM22,iwm,2,FALSE))","v":1},{"$f":"IF(AI22=\"\",1,VLOOKUP(AI22,ConPra,2,FALSE))","v":1},null,{"$f":"IF(AG22=\"\",1,VLOOKUP(AG22,Priorcrop,2,FALSE))","v":1},{"$f":"IF(AN22=\"\",1,VLOOKUP(AN22,iwm,2,FALSE))","v":1},null,"Onions",1,"Deep Tillage",0.5,null,null,"Deep Tillage",0.5]
[null,"Irrigation System",null,null,null,null,"Length of Run (ft)",null,null,null,"Convex End Category",null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,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,0,1,1,1,null,1,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,0,1,1,1,null,1,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,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,null,null,null,null,null,null,null,"1st Conservation",null,"2nd Conservation ",null,null,"Irrigation Mangement",null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
["Year","Crop Rotation",null,"Crop Class",null,"Prior Crop",null,null,"Practice",null,"Practice",null,null,"Practice",null,"SISL",null,null,null,null,null,null,null,null,0,{"$f":"IF(AK28=\"\",1,VLOOKUP(AK28,_iwm2,2,FALSE))","v":1},1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[1,"",null,"","","","","","","","","","",null,null,{"$f":"Y17*Z17*AA17*AB17*$AC$17*AD17*AE17","v":0},null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[2,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y18*Z18*AA18*AB18*$AC$17*AD18*AE18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[3,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y19*Z19*AA19*AB19*$AC$17*AD19*AE19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[4,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y20*Z20*AA20*AB20*$AC$17*AD20*AE20","v":0}]
[null,""]
[5,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y21*Z21*AA21*AB21*$AC$17*AD21*AE21","v":0}]
[null,""]
[6,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y22*Z22*AA22*AB22*$AC$17*AD22*AE22","v":0}]
[null,""]
[7,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y23*Z23*AA23*AB23*$AC$17*AD23*AE23","v":0}]
[null,""]
[8,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y24*Z24*AA24*AB24*$AC$17*AD24*AE24","v":0}]
[null,""]
[9,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y25*Z25*AA25*AB25*$AC$17*AD25*AE25","v":0}]
[null,""]
[10,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y26*Z26*AA26*AB26*$AC$17*AD26*AE26","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"tt(P25,P27,P29,P31,P33,P35,P37,P39,P41,P43)","v":0},"Tons"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"P45/ct(B25,B27,B29,B31,B33,B35,B37,B39,B41,B43)","v":0},"Tons/yr"]
[]
[null,"Notes:"]
[null,"Crop Class:"]
[null,"Permanent Cover -     Alfalfa, grass, pasture, clover, etc.",null,null,null,null,null,null,"To print this worksheet press Ctrl B"]
[null,"Close Growing -         Grain, peas, etc.",null,null,null,null,null,null,"To print a summary of all Alternatives press Crtl A"]
[null,"Row crop -                 Beans, corn, etc."]
[null,"intensive Row crop - Sugar beets, potatoes, onions, etc."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Surface Irrigation Soil Loss (SISL) Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null," Colorado Agronomy Technical Note 63 (Revised)"]
[]
[null,"Cooperator",{"$f":"IF(C7=0,\"\",C7)","v":""},null,null,null,null,"Tract",{"$f":"IF(J7=0,\"\",J7)","v":""},null,"Date",{"$f":"O7","v":"2013-06-26"}]
[]
[null,"Planner",{"$f":"IF(C9=0,\"\",C9)","v":""},null,null,null,null,"Field",{"$f":"IF(J9=0,\"\",J9)","v":""},null,"CD",{"$f":"IF(O9=0,\"\",O9)","v":""}]
[]
[null,"Soil Survey Area",{"$f":"IF(B16=0,\"\",B16)","v":""},null,null,null,null,"Map Unit",{"$f":"IF(G16=0,\"\",G16)","v":""},"Slope",{"$f":"IF(AP21=0,\"\",AP21)","v":""},"K factor",{"$f":"$AB$8","v":""}]
[]
[null,"Present Condition",{"$f":"IF(H12=0,\"\",H12)","v":""}]
[]
[]
["Irrigation System",null,{"$f":"IF(AQ21=0,\"\",AQ21)","v":""},null,null,null,null,"Length of Run (ft)",{"$f":"IF(AS21=0,\"\",AS21)","v":""},null,"Convex End Cat.",{"$f":"IF(AO21=0,\"\",AO21)","v":""}]
[]
["Crop Rotation",null,"Crop Class",null,"Prior Crop",null,"1st Conservation",null,"2nd Conservation",null,"Irrigation Managment"]
[null,null,null,null,null,null,"Practice",null,"Practice",null,"Practice"]
[{"$f":"IF(B25=0,\"\",B25)","v":""},null,{"$f":"IF(AR21=0,\"\",AR21)","v":""},null,{"$f":"IF(AG21=0,\"\",AG21)","v":""},null,{"$f":"IF(AI21=0,\"\",AI21)","v":""},null,{"$f":"IF(AK21=0,\"\",AK21)","v":""},null,{"$f":"IF(AM21=0,\"\",AM21)","v":""}]
[{"$f":"IF(B27=0,\"\",B27)","v":""},null,{"$f":"IF(AR22=0,\"\",AR22)","v":""},null,{"$f":"IF(AG22=0,\"\",AG22)","v":""},null,{"$f":"IF(AI22=0,\"\",AI22)","v":""},null,{"$f":"IF(AK22=0,\"\",AK22)","v":""},null,{"$f":"IF(AM22=0,\"\",AM22)","v":""}]
[{"$f":"IF(B29=0,\"\",B29)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B31=0,\"\",B31)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B33=0,\"\",B33)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B35=0,\"\",B35)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B37=0,\"\",B37)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B39=0,\"\",B39)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B41=0,\"\",B41)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B43=0,\"\",B43)","v":""},null,"",null,"",null,"",null,"",null,""]
[]
["Factors","BSL","PC","CP","IP",null,"SISL",null,"Total Loss (tons)",null,"Average loss (tons/year)"]
[null,{"$f":"Y17","v":0},{"$f":"AD17","v":1},{"$f":"AB17*Z17","v":1},{"$f":"AA17*AE17","v":1},null,{"$f":"P25","v":0},null,{"$f":"P45","v":0},null,{"$f":"P47","v":0}]
[null,{"$f":"Y18","v":0},{"$f":"AD18","v":1},{"$f":"AB18*Z18","v":1},{"$f":"AA18*AE18","v":1},null,{"$f":"P27","v":0}]
[null,0,1,1,1,null,{"$f":"P29","v":0}]
[null,0,1,1,1,null,{"$f":"P31","v":0}]
[null,0,1,1,1,null,{"$f":"P33","v":0}]
[null,0,1,1,1,null,{"$f":"P35","v":0}]
[null,0,1,1,1," ",{"$f":"P37","v":0}]
[null,0,1,1,1,null,{"$f":"P39","v":0}]
[null,0,1,1,1,null,{"$f":"P41","v":0}]
[null,0,1,1,1,null,{"$f":"P43","v":0}]

{"sheet":"SISL Alternative 1","index":3,"n_rows":142,"n_cols":45,"rows_kept":142,"cut":false,"hidden":false,"merged":[[15,10,15,11],[111,2,111,5],[18,10,18,12],[124,10,124,12],[125,10,125,12],[126,10,126,12],[127,10,127,12],[128,10,128,12],[129,10,129,12],[126,2,126,3],[126,4,126,5],[126,6,126,7],[126,8,126,9],[125,2,125,3],[125,4,125,5],[125,6,125,7],[34,1,34,2],[36,1,36,2],[38,1,38,2],[40,1,40,2],[42,1,42,2],[21,11,21,12],[22,8,22,9],[22,10,22,11],[123,8,123,9],[122,6,122,7],[120,10,120,12],[121,10,121,12],[122,10,122,12],[116,11,116,12],[120,6,120,7],[118,0,119,1],[118,2,119,3],[118,4,119,5],[118,10,118,12],[123,2,123,3],[123,4,123,5],[123,6,123,7],[122,2,122,3],[122,4,122,5],[122,8,122,9],[120,8,120,9],[121,8,121,9],[123,10,123,12],[107,8,107,9],[125,8,125,9],[124,2,124,3],[124,4,124,5],[124,6,124,7],[124,8,124,9],[15,1,15,4],[132,10,132,11],[119,8,119,9],[119,10,119,11],[131,8,131,9],[118,8,118,9],[26,1,26,2],[28,1,28,2],[30,1,30,2],[32,1,32,2],[132,8,132,9],[119,6,119,7],[118,6,118,7],[121,2,121,3],[121,4,121,5],[121,6,121,7],[120,2,120,3],[120,4,120,5],[129,2,129,3],[129,4,129,5],[129,6,129,7],[129,8,129,9],[128,2,128,3],[128,4,128,5],[128,6,128,7],[128,8,128,9],[127,2,127,3],[127,4,127,5],[127,6,127,7],[127,8,127,9],[11,5,11,14],[113,2,113,12],[116,2,116,5],[116,0,116,1],[6,14,6,15],[8,14,8,15],[109,11,109,12],[107,11,107,12],[107,2,107,6],[109,2,109,6],[23,3,23,4],[24,1,24,2],[17,10,17,11],[18,6,18,7],[6,2,6,6],[8,2,8,6],[14,10,14,11],[6,9,6,10],[8,9,8,10],[109,8,109,9],[23,8,23,9],[19,6,19,7],[15,6,15,7],[23,1,23,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,null,null,null,null,"Conservation",null,"Irrigation ",null,"Irrigation ",null,"Convex ","Slope","Irrigation ","Crop ","Run "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface Irrigation Soil Loss (SISL) Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K factor","Adjustment","Prior Crop","Adjustment","Practice","Adjustment","Management","Adjustment","Management","Adjustment","Category",null,"Type","Class","Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado Agronomy Technical Note 63 (Revised)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing",1,null,null,"Nothing",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional Tillage",1,null,null,"Conventional Tillage",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.22",0.45,"Pasture",0.65,"Residue Management",0.2,"Nothing",1,"Residue Management",0.2,"None","< 1%","Siphon Tubes","Permanent Cover",660]
[null,"Cooperator",{"$f":"IF('SISL Present Condition'!C7=\"\",\"\",'SISL Present Condition'!C7)","v":""},null,null,null,null,null,"Tract",{"$f":"IF('SISL Present Condition'!J7=0,\"\",'SISL Present Condition'!J7)","v":""},null,null,null,"Date",{"$f":"'SISL Present Condition'!O7","v":"2013-06-26"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.28",0.56999999999999995,"Alfalfa",0.7,"   Seasonal",0.2,"High level IWM w/o cutback",0.9,"   Seasonal",0.2,"Moderate","1-1.9%","Gated Pipe","Close Growing",1320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('SISL Present Condition'!AB8=\"\",\"\",'SISL Present Condition'!AB8)","v":""},null,null,"0.32",0.65,"Mint",0.7,"   Mulch Till",0.15,"High level IWM with cutback",0.7,"   Mulch Till",0.15,"Severe","2-2.9%","Dirt Ditches With Feeder Ditch","Row Crop"]
[null,"Planner",{"$f":"IF('SISL Present Condition'!C9 =\"\",\"\",'SISL Present Condition'!C9)","v":""},null,null,null,null,null,"Field",{"$f":"IF('SISL Present Condition'!J9=0,\"\",'SISL Present Condition'!J9)","v":""},null,null,null,"Conservation District",{"$f":"IF('SISL Present Condition'!O9=\"\",\"\",'SISL Present Condition'!O9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.37",0.76,"Alfalfa Seed",0.75,"   No Till",0.1,"Surge Irrigation",0.5,"   No Till",0.1,null,"> 3%",null,"Intensive Row Crop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.43",0.87,"Small Grain high residue",0.75,"PAM  Full Season (FS)",0.5,null,null,"PAM  Full Season (FS)",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.49",1,"Corn high residue",0.75,"FS   PAM alone",0.3,null,null,"FS   PAM alone",0.3]
[null,"Alternative 1 Resource Description ",null,null,null,null,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.55",1.1200000000000001,"Peas",0.8,"FS   PAM + IWM",0.05,null,null,"FS   PAM + IWM",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corn Silage",0.85,"FS   PAM + IWM +Res. Mgt.",0.01,null,null,"FS   PAM + IWM +Res. Mgt.",0.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,null,null,"Small Grain residue harvested",0.85,"PAM Part Season (PS)",0.3,null,null,"PAM Part Season (PS)",0.5]
[null,"Soil Survey Area",null,null,null,null,"Soil Map Unit",null,null,null,"Slope",null,null,"K Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sugar Beets",1,"PS   PAM alone",0.5,null,null,"PS   PAM alone",0.5]
[null,{"$f":"IF('SISL Present Condition'!B16=\"\",\"\",'SISL Present Condition'!B16)","v":""},null,null,null,null,{"$f":"IF('SISL Present Condition'!G16=\"\",\"\",'SISL Present Condition'!G16)","v":""},null,null,null,{"$f":"IF('SISL Present Condition'!AP21=\"\",\"\",'SISL Present Condition'!AP21)","v":""},null,null,{"$f":"IF('SISL Present Condition'!AB8=\"\",\"\",'SISL Present Condition'!AB8)","v":""},null,null,null,null,null,null,null,null,null,null,"bsl","con pra2","iwm1","con pra","Ka Factor","pc factor","iwm2",null,"Beans",1,"PS   PAM + IWM",0.2,null,null,"PS   PAM + IWM",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,{"$f":"bsl($AQ$21,AR21,$AS$21,$AP$21,$AO$21)","v":0},{"$f":"IF(AK21=\"\",1,VLOOKUP(AK21,_iwm2,2,FALSE))","v":1},{"$f":"IF(AM21=\"\",1,VLOOKUP(AM21,iwm,2,FALSE))","v":1},{"$f":"IF(AI21=\"\",1,VLOOKUP(AI21,ConPra,2,FALSE))","v":1},{"$f":"IF(AB8=\"\",1,VLOOKUP(AB8,AE6:AF12,2,FALSE))","v":1},{"$f":"IF(AG21=\"\",1,VLOOKUP(AG21,Priorcrop,2,FALSE))","v":1},{"$f":"IF(AN21=\"\",1,VLOOKUP(AN21,iwm,2,FALSE))","v":1},null,"Potatoes",1,"PS   PAM + IWM +Res. Mgt.",0.05,null,null,"PS   PAM + IWM +Res. Mgt.",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"bsl($AQ$21,AR22,$AS$21,$AP$21,$AO$21)","v":0},1,{"$f":"IF(AM22=\"\",1,VLOOKUP(AM22,iwm,2,FALSE))","v":1},{"$f":"IF(AI22=\"\",1,VLOOKUP(AI22,ConPra,2,FALSE))","v":1},null,{"$f":"IF(AG22=\"\",1,VLOOKUP(AG22,Priorcrop,2,FALSE))","v":1},1,null,"Onions",1,"Deep Tillage",0.5,null,null,"Deep Tillage",0.5]
[null,"Irrigation System",null,null,null,null,"Length of Run (ft)",null,null,null,"Convex End Category",null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,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,0,1,1,1,null,1,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,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,"",{"$f":"IF('SISL Present Condition'!AP21=\"\",\"\",'SISL Present Condition'!AP21)","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,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,null,null,null,null,null,null,null,"1st Conservation",null,"2nd Conservation",null,null,"Irrigation Mangement",null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
["Year","Crop Rotation",null,"Crop Class",null,null,"Prior Crop",null,"Practice",null,"Practice",null,null,"Practice",null,"SISL",null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[1,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y17*Z17*AA17*AB17*$AC$17*AD17*AE17","v":0},null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[2,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y18*Z18*AA18*AB18*$AC$17*AD18*AE18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[3,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y19*Z19*AA19*AB19*$AC$17*AD19*AE19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[4,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y20*Z20*AA20*AB20*$AC$17*AD20*AE20","v":0}]
[null,""]
[5,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y21*Z21*AA21*AB21*$AC$17*AD21*AE21","v":0}]
[null,""]
[6,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y22*Z22*AA22*AB22*$AC$17*AD22*AE22","v":0}]
[null,""]
[7,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y23*Z23*AA23*AB23*$AC$17*AD23*AE23","v":0}]
[null,""]
[8,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y24*Z24*AA24*AB24*$AC$17*AD24*AE24","v":0}]
[null,""]
[9,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y25*Z25*AA25*AB25*$AC$17*AD25*AE25","v":0}]
[null,""]
[10,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y26*Z26*AA26*AB26*$AC$17*AD26*AE26","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"tt(P25,P27,P29,P31,P33,P35,P37,P39,P41,P43)","v":0},"Tons"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"P45/ct(B25,B27,B29,B31,B33,B35,B37,B39,B41,B43)","v":0},"Tons/yr"]
[]
[null,"Notes:"]
[null,"Crop Class:"]
[null,"Permanent Cover -     Alfalfa, grass, pasture, clover, etc.",null,null,null,null,null,null,"To print this worksheet press Ctrl B"]
[null,"Close Growing -         Grain, peas, etc.",null,null,null,null,null,null,"To print a summary of all Alternatives press Crtl A"]
[null,"Row crop -                 Beans, corn, etc."]
[null,"intensive Row crop - Sugar beets, potatoes, onions, etc."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Surface Irrigation Soil Loss (SISL) Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null," Colorado Agronomy Technical Note 63 (Revised)"]
[]
[null,"Cooperator",{"$f":"IF(ISTEXT(C7),C7,\"\")","v":""},null,null,null,null,"Tract",{"$f":"IF('SISL Present Condition'!J7=0,\"\",'SISL Present Condition'!J7)","v":""},null,"Date",{"$f":"O7","v":"2013-06-26"}]
[]
[null,"Planner",{"$f":"IF(ISTEXT(C9),C9,\"\")","v":""},null,null,null,null,"Field",{"$f":"IF('SISL Present Condition'!J9=0,\"\",'SISL Present Condition'!J9)","v":""},null,"CD",{"$f":"IF('SISL Present Condition'!O9=\"\",\"\",'SISL Present Condition'!O9)","v":""}]
[]
[null,"Soil Survey Area",{"$f":"IF('SISL Present Condition'!B16=\"\",\"\",'SISL Present Condition'!B16)","v":""},null,null,null,null,"Map Unit",{"$f":"IF(ISTEXT(G16),G16,\"\")","v":""},"Slope",{"$f":"IF(ISTEXT(AP21),AP21,\"\")","v":""},"K factor",{"$f":"$AB$8","v":""}]
[]
["Alternative 1",null,{"$f":"IF(ISTEXT(F12),F12,\"\")","v":""}]
[]
[]
["Irrigation System",null,{"$f":"IF(ISTEXT(AQ21),AQ21,\"\")","v":""},null,null,null,null,"Length of Run (ft)",{"$f":"IF(ISTEXT(AS21),AS21,\"\")","v":""},null,"Convex End Cat.",{"$f":"IF(ISTEXT(AO21),AO21,\"\")","v":""}]
[]
["Crop Rotation",null,"Crop Class",null,"Prior Crop",null,"1st Conservation",null,"2nd Conservation",null,"Irrigation Managment"]
[null,null,null,null,null,null,"Practice",null,"Practice",null,"Practice"]
[{"$f":"IF(ISTEXT(B25),B25,\"\")","v":""},null,{"$f":"IF(ISTEXT(AR21),AR21,\"\")","v":""},null,{"$f":"IF(ISTEXT(AG21),AG21,\"\")","v":""},null,{"$f":"IF(ISTEXT(AI21),AI21,\"\")","v":""},null,{"$f":"IF(ISTEXT(AK21),AK21,\"\")","v":""},null,{"$f":"IF(ISTEXT(AM21),AM21,\"\")","v":""}]
[{"$f":"IF(ISTEXT(B27),B27,\"\")","v":""},null,{"$f":"IF(ISTEXT(AR22),AR22,\"\")","v":""},null,{"$f":"IF(ISTEXT(AG22),AG22,\"\")","v":""},null,{"$f":"IF(ISTEXT(AI22),AI22,\"\")","v":""},null,{"$f":"IF(ISTEXT(AK22),AK22,\"\")","v":""},null,{"$f":"IF(ISTEXT(AM22),AM22,\"\")","v":""}]
[{"$f":"IF(ISTEXT(B29),B29,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(ISTEXT(B31),B31,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(ISTEXT(B33),B33,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(ISTEXT(B35),B35,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(ISTEXT(B37),B37,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(ISTEXT(B39),B39,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(ISTEXT(B41),B41,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(ISTEXT(B43),B43,\"\")","v":""},null,"",null,"",null,"",null,"",null,""]
[]
["Factors","BSL","PC","CP","IP",null,"SISL",null,"Total Loss (tons)",null,"Average loss (tons/year)"]
[null,{"$f":"Y17","v":0},{"$f":"AD17","v":1},{"$f":"AB17*Z17","v":1},{"$f":"AA17*AE17","v":1},null,{"$f":"P25","v":0},null,{"$f":"P45","v":0},null,{"$f":"P47","v":0}]
[null,{"$f":"Y18","v":0},{"$f":"AD18","v":1},{"$f":"AB18*Z18","v":1},{"$f":"AA18*AE18","v":1},null,{"$f":"P27","v":0}]
[null,0,1,1,1,null,{"$f":"P29","v":0}]
[null,0,1,1,1,null,{"$f":"P31","v":0}]
[null,0,1,1,1,null,{"$f":"P33","v":0}]
[null,0,1,1,1,null,{"$f":"P35","v":0}]
[null,0,1,1,1,null,{"$f":"P37","v":0}]
[null,0,1,1,1,null,{"$f":"P39","v":0}]
[null,0,1,1,1,null,{"$f":"P41","v":0}]
[null,0,1,1,1,null,{"$f":"P43","v":0}]

{"sheet":"SISL Alternative 2","index":4,"n_rows":142,"n_cols":45,"rows_kept":142,"cut":false,"hidden":false,"merged":[[116,2,116,5],[111,2,111,5],[113,2,113,12],[118,0,119,1],[118,2,119,3],[109,8,109,9],[107,8,107,9],[107,2,107,6],[118,4,119,5],[118,10,118,12],[119,6,119,7],[116,11,116,12],[109,11,109,12],[107,11,107,12],[118,6,118,7],[118,8,118,9],[127,4,127,5],[126,4,126,5],[125,4,125,5],[124,4,124,5],[121,10,121,12],[124,10,124,12],[125,10,125,12],[126,10,126,12],[127,10,127,12],[122,10,122,12],[123,10,123,12],[121,4,121,5],[127,8,127,9],[122,6,122,7],[123,6,123,7],[124,6,124,7],[124,8,124,9],[125,8,125,9],[121,6,121,7],[126,8,126,9],[6,2,6,6],[21,11,21,12],[19,6,19,7],[22,8,22,9],[22,10,22,11],[23,1,23,2],[23,3,23,4],[23,8,23,9],[17,10,17,11],[18,6,18,7],[6,9,6,10],[8,9,8,10],[8,2,8,6],[14,10,14,11],[18,10,18,12],[11,5,11,14],[6,14,6,15],[8,14,8,15],[15,1,15,4],[15,6,15,7],[15,10,15,11],[132,10,132,11],[119,8,119,9],[119,10,119,11],[120,8,120,9],[121,8,121,9],[122,8,122,9],[123,8,123,9],[131,8,131,9],[24,1,24,2],[26,1,26,2],[28,1,28,2],[30,1,30,2],[32,1,32,2],[34,1,34,2],[36,1,36,2],[38,1,38,2],[40,1,40,2],[42,1,42,2],[115,8,115,9],[116,0,116,1],[109,2,109,6],[120,10,120,12],[132,8,132,9],[126,6,126,7],[120,6,120,7],[128,10,128,12],[129,10,129,12],[120,2,120,3],[121,2,121,3],[120,4,120,5],[129,2,129,3],[128,4,128,5],[129,4,129,5],[128,6,128,7],[129,6,129,7],[128,8,128,9],[129,8,129,9],[128,2,128,3],[122,2,122,3],[123,2,123,3],[123,4,123,5],[122,4,122,5],[124,2,124,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[125,6,125,7],[127,6,127,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,null,null,null,null,"Conservation",null,"Irrigation ",null,"Irrigation ",null,"Convex ","Slope","Irrigation ","Crop ","Run "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface Irrigation Soil Loss (SISL) Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K factor","Adjustment","Prior Crop","Adjustment","Practice","Adjustment","Management","Adjustment","Management","Adjustment","Category",null,"Type","Class","Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado Agronomy Technical Note 63 (Revised)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing",1,null,null,"Nothing",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional Tillage",1,null,null,"Conventional Tillage",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.22",0.45,"Pasture",0.65,"Residue Management",0.2,"Nothing",1,"Residue Management",0.2,"None","< 1%","Siphon Tubes","Permanent Cover",660]
[null,"Cooperator",{"$f":"IF('SISL Present Condition'!C7=\"\",\"\",'SISL Present Condition'!C7)","v":""},null,null,null,null,null,"Tract",{"$f":"IF('SISL Present Condition'!J7=0,\"\",'SISL Present Condition'!J7)","v":""},null,null,null,"Date",{"$f":"'SISL Present Condition'!O7","v":"2013-06-26"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.28",0.56999999999999995,"Alfalfa",0.7,"   Seasonal",0.2,"High level IWM w/o cutback",0.9,"   Seasonal",0.2,"Moderate","1-1.9%","Gated Pipe","Close Growing",1320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('SISL Present Condition'!AB8=\"\",\"\",'SISL Present Condition'!AB8)","v":""},null,null,"0.32",0.65,"Mint",0.7,"   Mulch Till",0.15,"High level IWM with cutback",0.7,"   Mulch Till",0.15,"Severe","2-2.9%","Dirt Ditches With Feeder Ditch","Row Crop"]
[null,"Planner",{"$f":"IF('SISL Present Condition'!C9 =\"\",\"\",'SISL Present Condition'!C9)","v":""},null,null,null,null,null,"Field",{"$f":"IF('SISL Present Condition'!J9=0,\"\",'SISL Present Condition'!J9)","v":""},null,null,null,"Conservation District",{"$f":"IF('SISL Present Condition'!O9=0,\"\",'SISL Present Condition'!O9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.37",0.76,"Alfalfa Seed",0.75,"   No Till",0.1,"Surge Irrigation",0.5,"   No Till",0.1,null,"> 3%",null,"Intensive Row Crop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0.43",0.87,"Small Grain high residue",0.75,"PAM  Full Season (FS)",0.5,null,null,"PAM  Full Season (FS)",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.49",1,"Corn high residue",0.75,"FS   PAM alone",0.3,null,null,"FS   PAM alone",0.3]
[null,"Alternative 2 Resource Description ",null,null,null,null,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.55",1.1200000000000001,"Peas",0.8,"FS   PAM + IWM",0.05,null,null,"FS   PAM + IWM",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corn Silage",0.85,"FS   PAM + IWM +Res. Mgt.",0.01,null,null,"FS   PAM + IWM +Res. Mgt.",0.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,null,null,"Small Grain residue harvested",0.85,"PAM Part Season (PS)",0.3,null,null,"PAM Part Season (PS)",0.5]
[null,"Soil Survey Area",null,null,null,null,"Soil Map Unit",null,null,null,"Slope",null,null,"K Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sugar Beets",1,"PS   PAM alone",0.5,null,null,"PS   PAM alone",0.5]
[null,{"$f":"IF('SISL Present Condition'!B16=\"\",\"\",'SISL Present Condition'!B16)","v":""},null,null,null,null,{"$f":"IF('SISL Present Condition'!G16=\"\",\"\",'SISL Present Condition'!G16)","v":""},null,null,null,{"$f":"IF('SISL Present Condition'!AP21=\"\",\"\",'SISL Present Condition'!AP21)","v":""},null,null,{"$f":"IF('SISL Present Condition'!AB8=\"\",\"\",'SISL Present Condition'!AB8)","v":""},null,null,null,null,null,null,null,null,null,null,"bsl","con pra2","iwm1","con pra","Ka Factor","pc factor","iwm2",null,"Beans",1,"PS   PAM + IWM",0.2,null,null,"PS   PAM + IWM",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,{"$f":"bsl($AQ$21,AR21,$AS$21,$AP$21,$AO$21)","v":0},{"$f":"IF(AK21=\"\",1,VLOOKUP(AK21,_iwm2,2,FALSE))","v":1},{"$f":"IF(AM21=\"\",1,VLOOKUP(AM21,iwm,2,FALSE))","v":1},{"$f":"IF(AI21=\"\",1,VLOOKUP(AI21,ConPra,2,FALSE))","v":1},{"$f":"IF(AB8=\"\",1,VLOOKUP(AB8,AE6:AF12,2,FALSE))","v":1},{"$f":"IF(AG21=\"\",1,VLOOKUP(AG21,Priorcrop,2,FALSE))","v":1},{"$f":"IF(AN21=\"\",1,VLOOKUP(AN21,iwm,2,FALSE))","v":1},null,"Potatoes",1,"PS   PAM + IWM +Res. Mgt.",0.05,null,null,"PS   PAM + IWM +Res. Mgt.",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"bsl($AQ$21,AR22,$AS$21,$AP$21,$AO$21)","v":0},{"$f":"IF(AK22=\"\",1,VLOOKUP(AK22,_iwm2,2,FALSE))","v":1},{"$f":"IF(AM22=\"\",1,VLOOKUP(AM22,iwm,2,FALSE))","v":1},{"$f":"IF(AI22=\"\",1,VLOOKUP(AI22,ConPra,2,FALSE))","v":1},null,{"$f":"IF(AG22=\"\",1,VLOOKUP(AG22,Priorcrop,2,FALSE))","v":1},1,null,"Onions",1,"Deep Tillage",0.5,null,null,"Deep Tillage",0.5]
[null,"Irrigation System",null,null,null,null,"Length of Run (ft)",null,null,null,"Convex End Category",null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,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,0,1,1,1,null,1,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,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,"",{"$f":"IF('SISL Present Condition'!AP21=\"\",\"\",'SISL Present Condition'!AP21)","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,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,null,null,null,null,null,null,null,"1st Conservation",null,"2nd Conservation",null,null,"Irrigation Mangement",null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
["Year","Crop Rotation",null,"Crop Class",null,null,"Prior Crop",null,"Practice",null,"Practice",null,null,"Practice",null,"SISL",null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[1,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y17*Z17*AA17*AB17*$AC$17*AD17*AE17","v":0},null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1,1,null,1,1,null,"",null,"",null,"",null,"",null,null,null,null,""]
[2,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y18*Z18*AA18*AB18*$AC$17*AD18*AE18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[3,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y19*Z19*AA19*AB19*$AC$17*AD19*AE19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,null,null,null,""]
[4,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y20*Z20*AA20*AB20*$AC$17*AD20*AE20","v":0}]
[null,""]
[5,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y21*Z21*AA21*AB21*$AC$17*AD21*AE21","v":0}]
[null,""]
[6,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y22*Z22*AA22*AB22*$AC$17*AD22*AE22","v":0}]
[null,""]
[7,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y23*Z23*AA23*AB23*$AC$17*AD23*AE23","v":0}]
[null,""]
[8,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y24*Z24*AA24*AB24*$AC$17*AD24*AE24","v":0}]
[null,""]
[9,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y25*Z25*AA25*AB25*$AC$17*AD25*AE25","v":0}]
[null,""]
[10,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y26*Z26*AA26*AB26*$AC$17*AD26*AE26","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"tt(P25,P27,P29,P31,P33,P35,P37,P39,P41,P43)","v":0},"Tons"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"P45/ct(B25,B27,B29,B31,B33,B35,B37,B39,B41,B43)","v":0},"Tons/yr"]
[]
[null,"Notes:"]
[null,"Crop Class:"]
[null,"Permanent Cover -     Alfalfa, grass, pasture, clover, etc.",null,null,null,null,null,null,"To print this worksheet press Ctrl B"]
[null,"Close Growing -         Grain, peas, etc.",null,null,null,null,null,null,"To print a summary of all Alternatives press Crtl A"]
[null,"Row crop -                 Beans, corn, etc."]
[null,"intensive Row crop - Sugar beets, potatoes, onions, etc."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Surface Irrigation Soil Loss (SISL) Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null," Colorado Agronomy Technical Note #63 (Revised)"]
[]
[null,"Cooperator",{"$f":"IF(C7=0,\"\",C7)","v":""},null,null,null,null,"Tract",{"$f":"IF('SISL Present Condition'!J7=0,\"\",'SISL Present Condition'!J7)","v":""},null,"Date",{"$f":"O7","v":"2013-06-26"}]
[]
[null,"Planner",{"$f":"IF(C9=0,\"\",C9)","v":""},null,null,null,null,"Field",{"$f":"IF('SISL Present Condition'!J9=0,\"\",'SISL Present Condition'!J9)","v":""},null,"CD",{"$f":"IF('SISL Present Condition'!M9=0,\"\",'SISL Present Condition'!M9)","v":""}]
[]
[null,"Soil Survey Area",{"$f":"IF('SISL Present Condition'!B16=\"\",\"\",'SISL Present Condition'!B16)","v":""},null,null,null,null,"Map Unit",{"$f":"IF(G16=0,\"\",G16)","v":""},"Slope",{"$f":"IF(AP21=0,\"\",AP21)","v":""},"K factor",{"$f":"$AB$8","v":""}]
[]
["Alternative 2",null,{"$f":"IF(F12=0,\"\",F12)","v":""}]
[]
[]
["Irrigation System",null,{"$f":"IF(AQ21=0,\"\",AQ21)","v":""},null,null,null,null,"Length of Run (ft)",{"$f":"IF(AS21=0,\"\",AS21)","v":""},null,"Convex End Cat.",{"$f":"IF(AO21=0,\"\",AO21)","v":""}]
[]
["Crop Rotation",null,"Crop Class",null,"Prior Crop",null,"1st Conservation",null,"2nd Conservation",null,"Irrigation Management"]
[null,null,null,null,null,null,"Practice",null,"Practice",null,"Practice"]
[{"$f":"IF(B25=0,\"\",B25)","v":""},null,{"$f":"IF(AR21=0,\"\",AR21)","v":""},null,{"$f":"IF(AG21=0,\"\",AG21)","v":""},null,{"$f":"IF(AI21=0,\"\",AI21)","v":""},null,{"$f":"IF(AK21=0,\"\",AK21)","v":""},null,{"$f":"IF(AM21=0,\"\",AM21)","v":""}]
[{"$f":"IF(B27=0,\"\",B27)","v":""},null,{"$f":"IF(AR22=0,\"\",AR22)","v":""},null,{"$f":"IF(AG22=0,\"\",AG22)","v":""},null,{"$f":"IF(AI22=0,\"\",AI22)","v":""},null,{"$f":"IF(AK22=0,\"\",AK22)","v":""},null,{"$f":"IF(AM22=0,\"\",AM22)","v":""}]
[{"$f":"IF(B29=0,\"\",B29)","v":""},null,"",null,"",null,"",null,"",null,""]
[{"$f":"IF(B30=0,\"\",B30)","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,""]
["",null,"",null,"",null,"",null,"",null,""]
[]
["Factors","BSL","PC","CP","IP",null,"SISL",null,"Total Loss (tons)",null,"Average loss (tons/year)"]
[null,{"$f":"Y17","v":0},{"$f":"AD17","v":1},{"$f":"AB17*Z17","v":1},{"$f":"AA17*AE17","v":1},null,{"$f":"P25","v":0},null,{"$f":"P45","v":0},null,{"$f":"P47","v":0}]
[null,{"$f":"Y18","v":0},{"$f":"AD18","v":1},{"$f":"AB18*Z18","v":1},{"$f":"AA18*AE18","v":1},null,{"$f":"P27","v":0}]
[null,0,1,1,1,null,{"$f":"P29","v":0}]
[null,0,1,1,1,null,{"$f":"P31","v":0}]
[null,0,1,1,1,null,{"$f":"P33","v":0}]
[null,0,1,1,1,null,{"$f":"P35","v":0}]
[null,0,1,1,1,null,{"$f":"P37","v":0}]
[null,0,1,1,1,null,{"$f":"P39","v":0}]
[null,0,1,1,1,null,{"$f":"P41","v":0}]
[null,0,1,1,1,null,{"$f":"P43","v":0}]

{"sheet":"SISL Print out","index":5,"n_rows":66,"n_cols":45,"rows_kept":66,"cut":false,"hidden":false,"merged":[[66,0,70,9],[5,8,5,9],[7,8,7,9],[5,1,5,3],[7,1,7,3],[5,5,5,6],[7,5,7,6],[9,1,9,3],[11,2,11,9],[29,2,29,9],[47,2,47,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,null,null,null,null,"Conservation",null,"Irrigation ",null,"Irrigation ",null,"Convex ","Slope","Irrigation ","Crop ","Run "]
[null,null,null,null,null,null,null,null,null,"Surface Irrigation Soil Loss (SISL) Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K factor","Adjustment","Prior Crop","Adjustment","Practice","Adjustment","Management","Adjustment","Management","Adjustment","Category",null,"Type","Class","Length"]
[null,null,null,null,null,null,null,null,null," Colorado Agronomy Technical Note 63 (Revised)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing",1,null,null,"Nothing",1]
[]
["Cooperator",{"$f":"IF('SISL Present Condition'!C7=0,\"\",'SISL Present Condition'!C7)","v":""},null,null,"Tract",{"$f":"IF('SISL Present Condition'!J7=0,\"\",'SISL Present Condition'!J7)","v":""},null,"Date",{"$f":"'SISL Present Condition'!O7","v":"2013-06-26"}]
[]
["Planner",{"$f":"IF('SISL Present Condition'!C9 = \"\",\" \",'SISL Present Condition'!C9)","v":" "},null,null,"Field",{"$f":"IF('SISL Present Condition'!J9=0,\"\",'SISL Present Condition'!J9)","v":""},null,"CD",{"$f":"IF('SISL Present Condition'!O9=0,\"\",'SISL Present Condition'!O9)","v":""}]
[]
["Soil Survey",{"$f":"IF('SISL Present Condition'!B16=\"\",\"\",'SISL Present Condition'!B16)","v":""},null,null,"Map Unit",{"$f":"IF('SISL Present Condition'!G16=0,\"\",'SISL Present Condition'!G16)","v":""},"Slope",{"$f":"'SISL Present Condition'!AP21","v":""},"K factor",{"$f":"'SISL Present Condition'!AB8","v":""}]
[]
["Present Condition:",null,{"$f":"IF('SISL Present Condition'!H12=0,\"\",'SISL Present Condition'!H12)","v":""}]
[]
["Irrigation System",null,{"$f":"IF('SISL Present Condition'!AQ21=0,\"\",'SISL Present Condition'!AQ21)","v":""},null,"Length of run (ft)",{"$f":"IF('SISL Present Condition'!AS21=0,\"\",'SISL Present Condition'!AS21)","v":""},null,null,"Convex End Category",{"$f":"IF('SISL Present Condition'!AO21=0,\"\",'SISL Present Condition'!AO21)","v":""}]
[]
["Crop Rotation",null,null,null,"BSL","PC","CP","IP",null,"SISL"]
[{"$f":"IF('SISL Present Condition'!B25=0,\"\",'SISL Present Condition'!B25)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y17","v":0},{"$f":"'SISL Present Condition'!AD17","v":1},{"$f":"'SISL Present Condition'!AB17*'SISL Present Condition'!Z17","v":1},{"$f":"'SISL Present Condition'!AA17","v":1},null,{"$f":"'SISL Present Condition'!P25","v":0}]
[{"$f":"IF('SISL Present Condition'!B27=0,\"\",'SISL Present Condition'!B27)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y18","v":0},{"$f":"'SISL Present Condition'!AD18","v":1},{"$f":"'SISL Present Condition'!AB18*'SISL Present Condition'!Z18","v":1},{"$f":"'SISL Present Condition'!AA18","v":1},null,{"$f":"'SISL Present Condition'!P27","v":0}]
[{"$f":"IF('SISL Present Condition'!B29=0,\"\",'SISL Present Condition'!B29)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y19","v":0},{"$f":"'SISL Present Condition'!AD19","v":1},{"$f":"'SISL Present Condition'!AB19*'SISL Present Condition'!Z19","v":1},{"$f":"'SISL Present Condition'!AA19","v":1},null,{"$f":"'SISL Present Condition'!P29","v":0}]
[{"$f":"IF('SISL Present Condition'!B31=0,\"\",'SISL Present Condition'!B31)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y20","v":0},{"$f":"'SISL Present Condition'!AD20","v":1},{"$f":"'SISL Present Condition'!AB20*'SISL Present Condition'!Z20","v":1},{"$f":"'SISL Present Condition'!AA20","v":1},null,{"$f":"'SISL Present Condition'!P31","v":0}]
[{"$f":"IF('SISL Present Condition'!B33=0,\"\",'SISL Present Condition'!B33)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y21","v":0},{"$f":"'SISL Present Condition'!AD21","v":1},{"$f":"'SISL Present Condition'!AB21*'SISL Present Condition'!Z21","v":1},{"$f":"'SISL Present Condition'!AA21","v":1},null,{"$f":"'SISL Present Condition'!P33","v":0}]
[{"$f":"IF('SISL Present Condition'!B35=0,\"\",'SISL Present Condition'!B35)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y22","v":0},{"$f":"'SISL Present Condition'!AD22","v":1},{"$f":"'SISL Present Condition'!AB22*'SISL Present Condition'!Z22","v":1},{"$f":"'SISL Present Condition'!AA22","v":1},null,{"$f":"'SISL Present Condition'!P35","v":0}]
[{"$f":"IF('SISL Present Condition'!B37=0,\"\",'SISL Present Condition'!B37)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y23","v":0},{"$f":"'SISL Present Condition'!AD23","v":1},{"$f":"'SISL Present Condition'!AB23*'SISL Present Condition'!Z23","v":1},{"$f":"'SISL Present Condition'!AA23","v":1},null,{"$f":"'SISL Present Condition'!P37","v":0}]
[{"$f":"IF('SISL Present Condition'!B39=0,\"\",'SISL Present Condition'!B39)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y24","v":0},{"$f":"'SISL Present Condition'!AD24","v":1},{"$f":"'SISL Present Condition'!AB24*'SISL Present Condition'!Z24","v":1},{"$f":"'SISL Present Condition'!AA24","v":1},null,{"$f":"'SISL Present Condition'!P39","v":0}]
[{"$f":"IF('SISL Present Condition'!B41=0,\"\",'SISL Present Condition'!B41)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y25","v":0},{"$f":"'SISL Present Condition'!AD25","v":1},{"$f":"'SISL Present Condition'!AB25*'SISL Present Condition'!Z25","v":1},{"$f":"'SISL Present Condition'!AA25","v":1},null,{"$f":"'SISL Present Condition'!P41","v":0}]
[{"$f":"IF('SISL Present Condition'!B43=0,\"\",'SISL Present Condition'!B43)","v":""},null,null,null,{"$f":"'SISL Present Condition'!Y26","v":0},{"$f":"'SISL Present Condition'!AD26","v":1},{"$f":"'SISL Present Condition'!AB26*'SISL Present Condition'!Z26","v":1},{"$f":"'SISL Present Condition'!AA26","v":1},null,{"$f":"'SISL Present Condition'!P43","v":0}]
[null,null,null,null,null,null,null,"Total (tons)",null,{"$f":"'SISL Present Condition'!P45","v":0}]
[null,null,null,null,null,null,null,"Average (tons/year)",null,{"$f":"'SISL Present Condition'!P47","v":0}]
[]
["Alternative 1:",null,{"$f":"IF('SISL Alternative 1'!F12=0,\"\",'SISL Alternative 1'!F12)","v":""}]
[]
["Irrigation System",null,{"$f":"'SISL Alternative 1'!AQ21","v":""},null,"Length of run (ft)",{"$f":"'SISL Alternative 1'!AS21","v":""},null,null,"Convex End Category",{"$f":"'SISL Alternative 1'!AO21","v":""}]
[]
["Crop Rotation",null,null,null,"BSL","PC","CP","IP",null,"SISL"]
[{"$f":"IF('SISL Alternative 1'!B25=0,\"\",'SISL Alternative 1'!B25)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y17","v":0},{"$f":"'SISL Alternative 1'!AD17","v":1},{"$f":"'SISL Alternative 1'!AB17*'SISL Alternative 1'!Z17","v":1},{"$f":"'SISL Alternative 1'!AA17","v":1},null,{"$f":"'SISL Alternative 1'!P25","v":0}]
[{"$f":"IF('SISL Alternative 1'!B27=0,\"\",'SISL Alternative 1'!B27)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y18","v":0},{"$f":"'SISL Alternative 1'!AD18","v":1},{"$f":"'SISL Alternative 1'!AB18*'SISL Alternative 1'!Z18","v":1},{"$f":"'SISL Alternative 1'!AA18","v":1},null,{"$f":"'SISL Alternative 1'!P27","v":0}]
[{"$f":"IF('SISL Alternative 1'!B29=0,\"\",'SISL Alternative 1'!B29)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y19","v":0},{"$f":"'SISL Alternative 1'!AD19","v":1},{"$f":"'SISL Alternative 1'!AB19*'SISL Alternative 1'!Z19","v":1},{"$f":"'SISL Alternative 1'!AA19","v":1},null,{"$f":"'SISL Alternative 1'!P29","v":0}]
[{"$f":"IF('SISL Alternative 1'!B31=0,\"\",'SISL Alternative 1'!B31)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y20","v":0},{"$f":"'SISL Alternative 1'!AD20","v":1},{"$f":"'SISL Alternative 1'!AB20*'SISL Alternative 1'!Z20","v":1},{"$f":"'SISL Alternative 1'!AA20","v":1},null,{"$f":"'SISL Alternative 1'!P31","v":0}]
[{"$f":"IF('SISL Alternative 1'!B33=0,\"\",'SISL Alternative 1'!B33)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y21","v":0},{"$f":"'SISL Alternative 1'!AD21","v":1},{"$f":"'SISL Alternative 1'!AB21*'SISL Alternative 1'!Z21","v":1},{"$f":"'SISL Alternative 1'!AA21","v":1},null,{"$f":"'SISL Alternative 1'!P33","v":0}]
[{"$f":"IF('SISL Alternative 1'!B35=0,\"\",'SISL Alternative 1'!B35)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y22","v":0},{"$f":"'SISL Alternative 1'!AD22","v":1},{"$f":"'SISL Alternative 1'!AB22*'SISL Alternative 1'!Z22","v":1},{"$f":"'SISL Alternative 1'!AA22","v":1},null,{"$f":"'SISL Alternative 1'!P35","v":0}]
[{"$f":"IF('SISL Alternative 1'!B37=0,\"\",'SISL Alternative 1'!B37)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y23","v":0},{"$f":"'SISL Alternative 1'!AD23","v":1},{"$f":"'SISL Alternative 1'!AB23*'SISL Alternative 1'!Z23","v":1},{"$f":"'SISL Alternative 1'!AA23","v":1},null,{"$f":"'SISL Alternative 1'!P37","v":0}]
[{"$f":"IF('SISL Alternative 1'!B39=0,\"\",'SISL Alternative 1'!B39)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y24","v":0},{"$f":"'SISL Alternative 1'!AD24","v":1},{"$f":"'SISL Alternative 1'!AB24*'SISL Alternative 1'!Z24","v":1},{"$f":"'SISL Alternative 1'!AA24","v":1},null,{"$f":"'SISL Alternative 1'!P39","v":0}]
[{"$f":"IF('SISL Alternative 1'!B41=0,\"\",'SISL Alternative 1'!B41)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y25","v":0},{"$f":"'SISL Alternative 1'!AD25","v":1},{"$f":"'SISL Alternative 1'!AB25*'SISL Alternative 1'!Z25","v":1},{"$f":"'SISL Alternative 1'!AA25","v":1},null,{"$f":"'SISL Alternative 1'!P41","v":0}]
[{"$f":"IF('SISL Alternative 1'!B43=0,\"\",'SISL Alternative 1'!B43)","v":""},null,null,null,{"$f":"'SISL Alternative 1'!Y26","v":0},{"$f":"'SISL Alternative 1'!AD26","v":1},{"$f":"'SISL Alternative 1'!AB26*'SISL Alternative 1'!Z26","v":1},{"$f":"'SISL Alternative 1'!AA26","v":1},null,{"$f":"'SISL Alternative 1'!P43","v":0}]
[null,null,null,null,null,null,null,"Total (tons)",null,{"$f":"'SISL Alternative 1'!P45","v":0}]
[null,null,null,null,null,null,null,"Average (tons/year)",null,{"$f":"'SISL Alternative 1'!P47","v":0}]
[]
["Alternative 2:",null,{"$f":"IF('SISL Alternative 2'!F12=0,\"\",'SISL Alternative 2'!F12)","v":""}]
[]
["Irrigation System",null,{"$f":"'SISL Alternative 2'!AQ21","v":""},null,"Length of run (ft)",{"$f":"'SISL Alternative 2'!AS21","v":""},null,null,"Convex End Category",{"$f":"'SISL Alternative 2'!AO21","v":""}]
[]
["Crop Rotation",null,null,null,"BSL","PC","CP","IP",null,"SISL"]
[{"$f":"IF('SISL Alternative 2'!B25=0,\"\",'SISL Alternative 2'!B25)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y17","v":0},{"$f":"'SISL Alternative 2'!AD17","v":1},{"$f":"'SISL Alternative 2'!AB17*'SISL Alternative 2'!Z17","v":1},{"$f":"'SISL Alternative 2'!AA17","v":1},null,{"$f":"'SISL Alternative 2'!P25","v":0}]
[{"$f":"IF('SISL Alternative 2'!B27=0,\"\",'SISL Alternative 2'!B27)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y18","v":0},{"$f":"'SISL Alternative 2'!AD18","v":1},{"$f":"'SISL Alternative 2'!AB18*'SISL Alternative 2'!Z18","v":1},{"$f":"'SISL Alternative 2'!AA18","v":1},null,{"$f":"'SISL Alternative 2'!P27","v":0}]
[{"$f":"IF('SISL Alternative 2'!B29=0,\"\",'SISL Alternative 2'!B29)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y19","v":0},{"$f":"'SISL Alternative 2'!AD19","v":1},{"$f":"'SISL Alternative 2'!AB19*'SISL Alternative 2'!Z19","v":1},{"$f":"'SISL Alternative 2'!AA19","v":1},null,{"$f":"'SISL Alternative 2'!P29","v":0}]
[{"$f":"IF('SISL Alternative 2'!B31=0,\"\",'SISL Alternative 2'!B31)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y20","v":0},{"$f":"'SISL Alternative 2'!AD20","v":1},{"$f":"'SISL Alternative 2'!AB20*'SISL Alternative 2'!Z20","v":1},{"$f":"'SISL Alternative 2'!AA20","v":1},null,{"$f":"'SISL Alternative 2'!P31","v":0}]
[{"$f":"IF('SISL Alternative 2'!B33=0,\"\",'SISL Alternative 2'!B33)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y21","v":0},{"$f":"'SISL Alternative 2'!AD21","v":1},{"$f":"'SISL Alternative 2'!AB21*'SISL Alternative 2'!Z21","v":1},{"$f":"'SISL Alternative 2'!AA21","v":1},null,{"$f":"'SISL Alternative 2'!P33","v":0}]
[{"$f":"IF('SISL Alternative 2'!B35=0,\"\",'SISL Alternative 2'!B35)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y22","v":0},{"$f":"'SISL Alternative 2'!AD22","v":1},{"$f":"'SISL Alternative 2'!AB22*'SISL Alternative 2'!Z22","v":1},{"$f":"'SISL Alternative 2'!AA22","v":1},null,{"$f":"'SISL Alternative 2'!P35","v":0}]
[{"$f":"IF('SISL Alternative 2'!B37=0,\"\",'SISL Alternative 2'!B37)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y23","v":0},{"$f":"'SISL Alternative 2'!AD23","v":1},{"$f":"'SISL Alternative 2'!AB23*'SISL Alternative 2'!Z23","v":1},{"$f":"'SISL Alternative 2'!AA23","v":1},null,{"$f":"'SISL Alternative 2'!P37","v":0}]
[{"$f":"IF('SISL Alternative 2'!B39=0,\"\",'SISL Alternative 2'!B39)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y24","v":0},{"$f":"'SISL Alternative 2'!AD24","v":1},{"$f":"'SISL Alternative 2'!AB24*'SISL Alternative 2'!Z24","v":1},{"$f":"'SISL Alternative 2'!AA24","v":1},null,{"$f":"'SISL Alternative 2'!P39","v":0}]
[{"$f":"IF('SISL Alternative 2'!B41=0,\"\",'SISL Alternative 2'!B41)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y25","v":0},{"$f":"'SISL Alternative 2'!AD25","v":1},{"$f":"'SISL Alternative 2'!AB25*'SISL Alternative 2'!Z25","v":1},{"$f":"'SISL Alternative 2'!AA25","v":1},null,{"$f":"'SISL Alternative 2'!P41","v":0}]
[{"$f":"IF('SISL Alternative 2'!B43=0,\"\",'SISL Alternative 2'!B43)","v":""},null,null,null,{"$f":"'SISL Alternative 2'!Y26","v":0},{"$f":"'SISL Alternative 2'!AD26","v":1},{"$f":"'SISL Alternative 2'!AB26*'SISL Alternative 2'!Z26","v":1},{"$f":"'SISL Alternative 2'!AA26","v":1},null,{"$f":"'SISL Alternative 2'!P43","v":0}]
[null,null,null,null,null,null,null,"Total (tons)",null,{"$f":"'SISL Alternative 2'!P45","v":0}]
[null,null,null,null,null,null,null,"Average (tons/year)",null,{"$f":"'SISL Alternative 2'!P47","v":0}]
[]
["Field Notes:"]

{"sheet":"Soil Volume x Bulk Density 2013","index":6,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[20,11,20,12],[31,0,38,12],[23,9,24,11],[23,1,24,2],[20,3,20,5],[5,11,5,12],[7,11,7,12],[12,0,12,12],[5,2,5,6],[7,2,7,6],[5,8,5,9],[7,8,7,9],[9,2,9,6],[9,9,9,10],[14,0,14,12],[16,11,16,12],[18,11,18,12],[13,0,13,12],[16,3,16,5],[18,3,18,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Modified Soil Loss Volume x Bulk Density Calculation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Colorado Agronomy Technical Note 63 (Revised)"]
[]
[]
[null,"Cooperator","",null,null,null,null,"Tract","",null,"Date",{"$f":"TODAY()","v":"2013-06-26"}]
[]
[null,"Planner","",null,null,null,null,"Field",null,null,"CD"]
[]
[null,"Soil Survey",null,null,null,null,null,null,"Soil Map Unit"]
[]
[]
["     This method is appropriate to estimate furrow irrigation-induced soil erosion after one of more irrigation events, prior to row cultivation or post-harvest tillage operations.  It follows the same principal used to estimate other types of concentrated flow erosion by multiplying the volume of soil lost by the unit soil weight, or moist bulk density.  \n\n"]
["     Field observations are required to estimate the average in-furrow depth and width of soil loss across a field.  Irregularly sloped fields will require more extensive field observations than evenly sloped fields, to develop plausible soil loss volume estimates.  Attach additional computation sheets as needed to support field estimates. "]
["     The unit soil weight, or moist bulk density, is included in physical soil properties information available in Web Soil Survey Reports and SSURGO databases.  Moist bulk density is generally expressed as a range because the values are affected by compaction, irrigation and tillage.  For newly prepared seed beds use lighter densities, or the lower end of the density range.  As the irrigation season progresses and the soil becomes more dense, use mid-values of the density range.  A table of representative moist bulk densities by soil textural class is provided below for reference.          "]
[]
[null,null,"Surface soil texture",null,null,null,null,null,null,null,"Average in-furrow depth of soil loss (in)"]
[]
[null,null,"Bulk density (g/cm3)",null,null,null,null,null,null,null,"Average in-furrow width of soil loss (in)"]
[]
[null,null,"Row spacing (in)",null,null,null,null,null,null,null,"Estimated soil loss (tons/acre) ",{"$f":"IF(ISTEXT(D17)*AND(ISNUMBER(D19),ISNUMBER(D21),ISNUMBER(L17),ISNUMBER(L19)),(L17/12)*(L19/D21)*(D19*62.4222)*43560/2000,\"\")","v":""}]
[]
[]
[null,"Soil Texture",null,null,null,null,null,null,null,"Estimated Moist Bulk Density (g/cm3)"]
[]
[null,"Clay, Silty clay, Silty clay loam, Silt loam",null,null,null,null,null,null,null,null,"1.15 - 1.30"]
[null,"Sandy clay, Sandy clay loam, Clay loam, Loam",null,null,null,null,null,null,null,null,"1.25 - 1.40"]
[null,"Sandy loam",null,null,null,null,null,null,null,null,"1.35 - 1.50"]
[null,"Loamy sand, Sand",null,null,null,null,null,null,null,null,"1.45 - 1.60"]
[]
["Field Notes"]

{"sheet":"Soil Volume x Bulk Density 1983","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}