{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Solution 1","Solution 2","Solution 3","Solution 4","Solution 5","Solution 6"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Solution 1","index":0,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,9,45,16],[37,9,37,16],[49,9,49,16],[8,9,8,12],[9,9,9,12],[10,9,10,12],[8,13,8,14],[8,15,8,16],[15,14,16,14],[43,9,43,16],[35,9,35,16],[48,9,48,16],[26,22,26,26],[19,23,19,26],[20,23,20,26],[21,23,21,26],[22,23,22,26],[23,23,23,26],[11,3,11,4],[11,5,11,6],[15,23,16,26],[17,23,17,26],[18,23,18,26],[15,5,16,5],[15,6,16,6],[15,9,15,10],[15,19,16,19],[15,20,16,20],[15,18,16,18],[15,13,16,13],[15,15,16,15],[15,22,16,22],[15,12,16,12],[15,16,16,16],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,21,16,21],[15,28,16,28],[15,29,15,30],[47,9,47,16],[44,9,44,16],[39,9,39,16],[41,9,41,16],[40,9,40,16],[38,9,38,16],[42,9,42,16],[36,9,36,16],[46,9,46,16],[27,21,30,21],[27,18,30,18],[24,23,24,26],[25,23,25,26]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,"Herd Composition"]
[null,null,null,null,null,null,null,null,null,"Reference Values for Drought Severity Effects on Seasonal Forage Production",null,null,null,null,null,null,null,null,null,"Jan - May","June - Dec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter*",null,"Summer",null,null,"Cows",300,300]
[null,null,null,null,null,null,null,null,null,"Standard Precipitation Index (SPI)",null,null,null,-1,-2,-1,-2,null,"Bulls",{"$f":"T9/15","v":20},{"$f":"U9/15","v":20}]
[null,null,null,"% of averag forage production, for SPI values -1, -2 in the winter and summer seasons",null,null,null,null,null,"Estimated Forage Reduction (% of Average)",null,null,null,0.57999999999999996,0.34,0.72,0.52,null,"Yearlings",150,40]
[null,null,null,"Winter",null,"Summer",null,null,null,"*Winter = October - May; Summer = June - September",null,null,null,null,null,null,null,null,"Total Herd AU's",{"$f":"T9+(T10*1.75)+(T11*0.7)","v":440},{"$f":"U9+(U10*1.75)+(U11*0.7)","v":363}]
[]
[null,null,null,"SPI -1","SPI -2","SPI -1","SPI -2"]
["Pasture Forage Production",null,null,0.57999999999999996,0.34,0.72,0.52,null,null,"Drought Factors",null,null,"Grazing Plan"]
["Pasture","Acreage","Average Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)",null,null,"SPI Value          (pasture level)",null,null,"Pasture","Pasture Rotation Sequence","Planned % Utilization ","Water   (dates when unavailable)","Seasonal Use  Restrictions (dates)",null,"Number Days in Pasture","First Day in Pasture","Last Day in Pasture","Maximum Seasonal Grazing Days","Drought Season Affecting Forage Production","Pasture Warnings",null,null,null,null," Herd Grazing Days Without Drought","Drought-Adjusted Seasonal Herd Grazing Days "]
[null,null,null,null,null,null,null,null,null,"Winter     Season","Summer Season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter Season","Summer Season"]
["Riparian",3000,850,{"$f":"C18*$D$15","v":492.99999999999994},{"$f":"C18*$E$15","v":289},{"$f":"C18*$F$15","v":612},{"$f":"C18*$G$15","v":442},null,null,0,0,null,"Riparian",1,0.2,null,null,null,43,"2016-01-01",{"$f":"IF(S18=0,(T18+0),(T18+S18)-1)","v":"2016-02-12"},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),AE18,IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),AE18,IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),AE18,IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),AE18,IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),AE18,IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),AE18,AD18))))))","v":44.580419580419587},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),\"Summer\",IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),\"Summer\",IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),\"Summer\",IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),\"Summer\",IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),\"Summer\",IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S18>V18,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T18>=DATE(2016,1,1),(T18<=DATE(2016,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2015,1,1),(T18<=DATE(2015,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2017,1,1),(T18<=DATE(2017,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2018,1,1),(T18<=DATE(2018,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2019,1,1),(T18<=DATE(2019,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2020,1,1),(T18<=DATE(2020,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),(((B18*C18)*O18/26)/$U$12)))))))))))))","v":44.580419580419587},{"$f":"IF(J18=0,AC18,IF(J18=-1,AC18*0.58,IF(J18=-2,(AC18*0.34),\"NA\")))","v":44.580419580419587},{"$f":"IF(K18=0,AC18,IF(K18=-1,AC18*0.72,IF(K18=-2,(AC18*0.52),\"NA\")))","v":44.580419580419587}]
["Headquarters",800,700,406,238.00000000000003,504,364,null,null,0,0,null,"Headquarters",2,0.4,null,null,null,19,{"$f":"IF(S19=0,U18,U18+1)","v":"2016-02-13"},{"$f":"IF(S19=0,(T19+0),(T19+S19)-1)","v":"2016-03-02"},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),AE19,IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),AE19,IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),AE19,IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),AE19,IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),AE19,IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),AE19,AD19))))))","v":19.58041958041958},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),\"Summer\",IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),\"Summer\",IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),\"Summer\",IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),\"Summer\",IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),\"Summer\",IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S19>V19,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T19>=DATE(2016,1,1),(T19<=DATE(2016,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2015,1,1),(T19<=DATE(2015,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2017,1,1),(T19<=DATE(2017,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2018,1,1),(T19<=DATE(2018,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2019,1,1),(T19<=DATE(2019,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2020,1,1),(T19<=DATE(2020,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),(((B19*C19)*O19/26)/$U$12)))))))))))))","v":19.58041958041958},{"$f":"IF(J19=0,AC19,IF(J19=-1,AC19*0.58,IF(J19=-2,(AC19*0.34),\"NA\")))","v":19.58041958041958},{"$f":"IF(K19=0,AC19,IF(K19=-1,AC19*0.72,IF(K19=-2,(AC19*0.52),\"NA\")))","v":19.58041958041958}]
["Pipeline",4000,550,319,187,396,286,null,null,0,0,null,"Pipeline",3,0.4,null,null,null,60,{"$f":"IF(S20=0,U19,U19+1)","v":"2016-03-03"},"2016-05-01",76.92307692307692,"Winter","",null,null,null,null,76.92307692307692,76.92307692307692,76.92307692307692]
["Wydot",3900,650,377,221.00000000000003,468,338,null,null,0,0,null,"Wydot",4,0.4,null,null,null,50,"2016-05-02","2016-06-20",88.63636363636364,"Winter","",null,null,null,null,88.63636363636364,88.63636363636364,88.63636363636364]
["Son of A Gun",2800,600,348,204.00000000000003,432,312,null,null,0,0,null,"Son of A Gun",5,0.4,null,null,null,40,"2016-06-21","2016-07-30",71.201525746980295,"Summer","",null,null,null,null,71.201525746980295,71.201525746980295,71.201525746980295]
["Miners Camp*",4800,300,174,102.00000000000001,216,156,null,null,0,0,null,"Miners Camp**",6,0.2,null,null,null,25,"2016-07-31","2016-08-24",30.514939605848696,"Summer","",null,null,null,null,30.514939605848696,30.514939605848696,30.514939605848696]
["Timber Top*",3500,325,188.5,110.50000000000001,234,169,null,null,0,0,null,"Timber Top**",7,0,null,null,null,0,"2016-08-24","2016-08-24",0,"Summer","",null,null,null,null,0,0,0]
["Preacher Tom",4000,550,319,187,396,286,null,null,0,0,null,"Preacher Tom",8,0.4,null,null,null,76,"2016-08-25","2016-11-08",93.240093240093231,"Summer","",null,null,null,null,93.240093240093231,93.240093240093231,93.240093240093231]
["Old Homestead",3200,600,348,204.00000000000003,432,312,null,null,0,0,null,"Old Homestead",9,0.4,null,null,null,52,"2016-11-09",{"$f":"IF(S26=0,(T26+0),(T26+S26)-1)","v":"2016-12-30"},81.373172282263198,"Summer","",null,null,null,null,81.373172282263198,81.373172282263198,81.373172282263198]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(S18:S26)","v":365},null,null,{"$f":"SUM(V18:V26)","v":506.0500105954651},null,null,null,null,null,null,{"$f":"SUM(AC18:AC26)","v":506.0500105954651},{"$f":"SUM(AD18:AD26)","v":506.0500105954651},{"$f":"SUM(AE18:AE26)","v":506.0500105954651}]
[null,null,null,null,null,null,null,null,null,null,null,null,"**Rest rotation every other year, summer use",null,null,null,null,null,{"$f":"IF(S27>365,\"Exceeds 365 days in grazing year!\",\"\")","v":""},null,null,{"$f":"IF(V27<365,\"Less than 365 days of available forage!\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Instructions for Drought Scenario Planning"]
[null,null,null,null,null,null,null,null,null,"1. Input user defined data into open white boxes"]
[null,null,null,null,null,null,null,null,null,"2. Enter SPI value for winter and summer for each pasture"]
[null,null,null,null,null,null,null,null,null,"3. Enter Unavailable water dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"4. Enter use restriction dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"5. Examine warnings for use levels exceeded (red text)"]
[null,null,null,null,null,null,null,null,null,"6. Consider adjustments to maintain use within allowable levels. Consider the following:"]
[null,null,null,null,null,null,null,null,null,"          a. Herd size and composition"]
[null,null,null,null,null,null,null,null,null,"          b. Days in pasture"]
[null,null,null,null,null,null,null,null,null,"          c. Pasture rotation sequence"]
[null,null,null,null,null,null,null,null,null,"          d. Planned utilization"]
[null,null,null,null,null,null,null,null,null,"Other Features"]
[null,null,null,null,null,null,null,null,null,"1. \"Pasture Sequence Re-Sort\" button on the screen will re-arrange the pastures and dates according to the pasture rotation sequence you selected if you decide to make changes to the original sequence (cannot undo this action except by hand)."]
[null,null,null,null,null,null,null,null,null,"2. Saving scenario solutions in spreadsheet tabs: Identical copies of the tool with the specific scenario details are saved in different spreadsheet tabs located at the bottom of the window; these can be used to save different possible solutions to a single drought scenario. These are labeled by default as \"Solution 1\", \"Solution 2\", etc."]
[null,null,null,null,null,null,null,null,null,"3. Worksheet: used in conjunction with this tool to identify solutions and determine whether they will need consultation and approval with updated AOI and deviation from AMP.  "]

{"sheet":"Solution 2","index":1,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,3,11,4],[11,5,11,6],[8,9,8,12],[8,13,8,14],[8,15,8,16],[9,9,9,12],[10,9,10,12],[15,15,16,15],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,9,15,10],[15,12,16,12],[15,13,16,13],[15,14,16,14],[19,23,19,26],[15,16,16,16],[15,18,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[15,22,16,22],[15,23,16,26],[15,28,16,28],[15,29,15,30],[17,23,17,26],[18,23,18,26],[37,9,37,16],[20,23,20,26],[21,23,21,26],[22,23,22,26],[23,23,23,26],[24,23,24,26],[25,23,25,26],[26,22,26,26],[27,18,30,18],[27,21,30,21],[35,9,35,16],[36,9,36,16],[49,9,49,16],[38,9,38,16],[39,9,39,16],[40,9,40,16],[41,9,41,16],[42,9,42,16],[43,9,43,16],[44,9,44,16],[45,9,45,16],[46,9,46,16],[47,9,47,16],[48,9,48,16]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,"Herd Composition"]
[null,null,null,null,null,null,null,null,null,"Reference Values for Drought Severity Effects on Seasonal Forage Production",null,null,null,null,null,null,null,null,null,"Jan - May","June - Dec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter*",null,"Summer",null,null,"Cows",300,300]
[null,null,null,null,null,null,null,null,null,"Standard Precipitation Index (SPI)",null,null,null,-1,-2,-1,-2,null,"Bulls",{"$f":"T9/15","v":20},{"$f":"U9/15","v":20}]
[null,null,null,"% of averag forage production, for SPI values -1, -2 in the winter and summer seasons",null,null,null,null,null,"Estimated Forage Reduction (% of Average)",null,null,null,0.57999999999999996,0.34,0.72,0.52,null,"Yearlings",150,40]
[null,null,null,"Winter",null,"Summer",null,null,null,"*Winter = October - May; Summer = June - September",null,null,null,null,null,null,null,null,"Total Herd AU's",{"$f":"T9+(T10*1.75)+(T11*0.7)","v":440},{"$f":"U9+(U10*1.75)+(U11*0.7)","v":363}]
[]
[null,null,null,"SPI -1","SPI -2","SPI -1","SPI -2"]
["Pasture Forage Production",null,null,0.57999999999999996,0.34,0.72,0.52,null,null,"Drought Factors",null,null,"Grazing Plan"]
["Pasture","Acreage","Average Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)",null,null,"SPI Value          (pasture level)",null,null,"Pasture","Pasture Rotation Sequence","Planned % Utilization ","Water   (dates when unavailable)","Seasonal Use  Restrictions (dates)",null,"Number Days in Pasture","First Day in Pasture","Last Day in Pasture","Maximum Seasonal Grazing Days","Drought Season Affecting Forage Production","Pasture Warnings",null,null,null,null," Herd Grazing Days Without Drought","Drought-Adjusted Seasonal Herd Grazing Days "]
[null,null,null,null,null,null,null,null,null,"Winter     Season","Summer Season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter Season","Summer Season"]
["Riparian",3000,850,{"$f":"C18*$D$15","v":492.99999999999994},{"$f":"C18*$E$15","v":289},{"$f":"C18*$F$15","v":612},{"$f":"C18*$G$15","v":442},null,null,0,0,null,"Riparian",1,0.2,null,null,null,43,"2016-01-01",{"$f":"IF(S18=0,(T18+0),(T18+S18)-1)","v":"2016-02-12"},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),AE18,IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),AE18,IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),AE18,IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),AE18,IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),AE18,IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),AE18,AD18))))))","v":44.580419580419587},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),\"Summer\",IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),\"Summer\",IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),\"Summer\",IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),\"Summer\",IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),\"Summer\",IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S18>V18,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T18>=DATE(2016,1,1),(T18<=DATE(2016,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2015,1,1),(T18<=DATE(2015,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2017,1,1),(T18<=DATE(2017,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2018,1,1),(T18<=DATE(2018,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2019,1,1),(T18<=DATE(2019,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2020,1,1),(T18<=DATE(2020,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),(((B18*C18)*O18/26)/$U$12)))))))))))))","v":44.580419580419587},{"$f":"IF(J18=0,AC18,IF(J18=-1,AC18*0.58,IF(J18=-2,(AC18*0.34),\"NA\")))","v":44.580419580419587},{"$f":"IF(K18=0,AC18,IF(K18=-1,AC18*0.72,IF(K18=-2,(AC18*0.52),\"NA\")))","v":44.580419580419587}]
["Headquarters",800,700,406,238.00000000000003,504,364,null,null,0,0,null,"Headquarters",2,0.4,null,null,null,19,{"$f":"IF(S19=0,U18,U18+1)","v":"2016-02-13"},{"$f":"IF(S19=0,(T19+0),(T19+S19)-1)","v":"2016-03-02"},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),AE19,IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),AE19,IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),AE19,IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),AE19,IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),AE19,IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),AE19,AD19))))))","v":19.58041958041958},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),\"Summer\",IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),\"Summer\",IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),\"Summer\",IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),\"Summer\",IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),\"Summer\",IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S19>V19,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T19>=DATE(2016,1,1),(T19<=DATE(2016,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2015,1,1),(T19<=DATE(2015,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2017,1,1),(T19<=DATE(2017,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2018,1,1),(T19<=DATE(2018,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2019,1,1),(T19<=DATE(2019,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2020,1,1),(T19<=DATE(2020,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),(((B19*C19)*O19/26)/$U$12)))))))))))))","v":19.58041958041958},{"$f":"IF(J19=0,AC19,IF(J19=-1,AC19*0.58,IF(J19=-2,(AC19*0.34),\"NA\")))","v":19.58041958041958},{"$f":"IF(K19=0,AC19,IF(K19=-1,AC19*0.72,IF(K19=-2,(AC19*0.52),\"NA\")))","v":19.58041958041958}]
["Pipeline",4000,550,319,187,396,286,null,null,0,0,null,"Pipeline",3,0.4,null,null,null,60,{"$f":"IF(S20=0,U19,U19+1)","v":"2016-03-03"},"2016-05-01",76.92307692307692,"Winter","",null,null,null,null,76.92307692307692,76.92307692307692,76.92307692307692]
["Wydot",3900,650,377,221.00000000000003,468,338,null,null,0,0,null,"Wydot",4,0.4,null,null,null,50,"2016-05-02","2016-06-20",88.63636363636364,"Winter","",null,null,null,null,88.63636363636364,88.63636363636364,88.63636363636364]
["Son of A Gun",2800,600,348,204.00000000000003,432,312,null,null,0,0,null,"Son of A Gun",5,0.4,null,null,null,40,"2016-06-21","2016-07-30",71.201525746980295,"Summer","",null,null,null,null,71.201525746980295,71.201525746980295,71.201525746980295]
["Miners Camp*",4800,300,174,102.00000000000001,216,156,null,null,0,0,null,"Miners Camp**",6,0.2,null,null,null,25,"2016-07-31","2016-08-24",30.514939605848696,"Summer","",null,null,null,null,30.514939605848696,30.514939605848696,30.514939605848696]
["Timber Top*",3500,325,188.5,110.50000000000001,234,169,null,null,0,0,null,"Timber Top**",7,0,null,null,null,0,"2016-08-24","2016-08-24",0,"Summer","",null,null,null,null,0,0,0]
["Preacher Tom",4000,550,319,187,396,286,null,null,0,0,null,"Preacher Tom",8,0.4,null,null,null,76,"2016-08-25","2016-11-08",93.240093240093231,"Summer","",null,null,null,null,93.240093240093231,93.240093240093231,93.240093240093231]
["Old Homestead",3200,600,348,204.00000000000003,432,312,null,null,0,0,null,"Old Homestead",9,0.4,null,null,null,52,"2016-11-09",{"$f":"IF(S26=0,(T26+0),(T26+S26)-1)","v":"2016-12-30"},81.373172282263198,"Summer","",null,null,null,null,81.373172282263198,81.373172282263198,81.373172282263198]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(S18:S26)","v":365},null,null,{"$f":"SUM(V18:V26)","v":506.0500105954651},null,null,null,null,null,null,{"$f":"SUM(AC18:AC26)","v":506.0500105954651},{"$f":"SUM(AD18:AD26)","v":506.0500105954651},{"$f":"SUM(AE18:AE26)","v":506.0500105954651}]
[null,null,null,null,null,null,null,null,null,null,null,null,"**Rest rotation every other year, summer use",null,null,null,null,null,{"$f":"IF(S27>365,\"Exceeds 365 days in grazing year!\",\"\")","v":""},null,null,{"$f":"IF(V27<365,\"Less than 365 days of available forage!\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Instructions for Drought Scenario Planning"]
[null,null,null,null,null,null,null,null,null,"1. Input user defined data into open white boxes"]
[null,null,null,null,null,null,null,null,null,"2. Enter SPI value for winter and summer for each pasture"]
[null,null,null,null,null,null,null,null,null,"3. Enter Unavailable water dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"4. Enter use restriction dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"5. Examine warnings for use levels exceeded (red text)"]
[null,null,null,null,null,null,null,null,null,"6. Consider adjustments to maintain use within allowable levels. Consider the following:"]
[null,null,null,null,null,null,null,null,null,"          a. Herd size and composition"]
[null,null,null,null,null,null,null,null,null,"          b. Days in pasture"]
[null,null,null,null,null,null,null,null,null,"          c. Pasture rotation sequence"]
[null,null,null,null,null,null,null,null,null,"          d. Planned utilization"]
[null,null,null,null,null,null,null,null,null,"Other Features"]
[null,null,null,null,null,null,null,null,null,"1. \"Pasture Sequence Re-Sort\" button on the screen will re-arrange the pastures and dates according to the pasture rotation sequence you selected if you decide to make changes to the original sequence (cannot undo this action except by hand)."]
[null,null,null,null,null,null,null,null,null,"2. Saving scenario solutions in spreadsheet tabs: Identical copies of the tool with the specific scenario details are saved in different spreadsheet tabs located at the bottom of the window; these can be used to save different possible solutions to a single drought scenario. These are labeled by default as \"Solution 1\", \"Solution 2\", etc."]
[null,null,null,null,null,null,null,null,null,"3. Worksheet: used in conjunction with this tool to identify solutions and determine whether they will need consultation and approval with updated AOI and deviation from AMP.  "]

{"sheet":"Solution 3","index":2,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,3,11,4],[11,5,11,6],[8,9,8,12],[8,13,8,14],[8,15,8,16],[9,9,9,12],[10,9,10,12],[15,15,16,15],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,9,15,10],[15,12,16,12],[15,13,16,13],[15,14,16,14],[19,23,19,26],[15,16,16,16],[15,18,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[15,22,16,22],[15,23,16,26],[15,28,16,28],[15,29,15,30],[17,23,17,26],[18,23,18,26],[37,9,37,16],[20,23,20,26],[21,23,21,26],[22,23,22,26],[23,23,23,26],[24,23,24,26],[25,23,25,26],[26,22,26,26],[27,18,30,18],[27,21,30,21],[35,9,35,16],[36,9,36,16],[49,9,49,16],[38,9,38,16],[39,9,39,16],[40,9,40,16],[41,9,41,16],[42,9,42,16],[43,9,43,16],[44,9,44,16],[45,9,45,16],[46,9,46,16],[47,9,47,16],[48,9,48,16]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,"Herd Composition"]
[null,null,null,null,null,null,null,null,null,"Reference Values for Drought Severity Effects on Seasonal Forage Production",null,null,null,null,null,null,null,null,null,"Jan - May","June - Dec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter*",null,"Summer",null,null,"Cows",300,300]
[null,null,null,null,null,null,null,null,null,"Standard Precipitation Index (SPI)",null,null,null,-1,-2,-1,-2,null,"Bulls",{"$f":"T9/15","v":20},{"$f":"U9/15","v":20}]
[null,null,null,"% of averag forage production, for SPI values -1, -2 in the winter and summer seasons",null,null,null,null,null,"Estimated Forage Reduction (% of Average)",null,null,null,0.57999999999999996,0.34,0.72,0.52,null,"Yearlings",150,40]
[null,null,null,"Winter",null,"Summer",null,null,null,"*Winter = October - May; Summer = June - September",null,null,null,null,null,null,null,null,"Total Herd AU's",{"$f":"T9+(T10*1.75)+(T11*0.7)","v":440},{"$f":"U9+(U10*1.75)+(U11*0.7)","v":363}]
[]
[null,null,null,"SPI -1","SPI -2","SPI -1","SPI -2"]
["Pasture Forage Production",null,null,0.57999999999999996,0.34,0.72,0.52,null,null,"Drought Factors",null,null,"Grazing Plan"]
["Pasture","Acreage","Average Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)",null,null,"SPI Value          (pasture level)",null,null,"Pasture","Pasture Rotation Sequence","Planned % Utilization ","Water   (dates when unavailable)","Seasonal Use  Restrictions (dates)",null,"Number Days in Pasture","First Day in Pasture","Last Day in Pasture","Maximum Seasonal Grazing Days","Drought Season Affecting Forage Production","Pasture Warnings",null,null,null,null," Herd Grazing Days Without Drought","Drought-Adjusted Seasonal Herd Grazing Days "]
[null,null,null,null,null,null,null,null,null,"Winter     Season","Summer Season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter Season","Summer Season"]
["Riparian",3000,850,{"$f":"C18*$D$15","v":492.99999999999994},{"$f":"C18*$E$15","v":289},{"$f":"C18*$F$15","v":612},{"$f":"C18*$G$15","v":442},null,null,0,0,null,"Riparian",1,0.2,null,null,null,43,"2016-01-01",{"$f":"IF(S18=0,(T18+0),(T18+S18)-1)","v":"2016-02-12"},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),AE18,IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),AE18,IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),AE18,IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),AE18,IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),AE18,IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),AE18,AD18))))))","v":44.580419580419587},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),\"Summer\",IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),\"Summer\",IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),\"Summer\",IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),\"Summer\",IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),\"Summer\",IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S18>V18,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T18>=DATE(2016,1,1),(T18<=DATE(2016,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2015,1,1),(T18<=DATE(2015,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2017,1,1),(T18<=DATE(2017,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2018,1,1),(T18<=DATE(2018,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2019,1,1),(T18<=DATE(2019,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2020,1,1),(T18<=DATE(2020,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),(((B18*C18)*O18/26)/$U$12)))))))))))))","v":44.580419580419587},{"$f":"IF(J18=0,AC18,IF(J18=-1,AC18*0.58,IF(J18=-2,(AC18*0.34),\"NA\")))","v":44.580419580419587},{"$f":"IF(K18=0,AC18,IF(K18=-1,AC18*0.72,IF(K18=-2,(AC18*0.52),\"NA\")))","v":44.580419580419587}]
["Headquarters",800,700,406,238.00000000000003,504,364,null,null,0,0,null,"Headquarters",2,0.4,null,null,null,19,{"$f":"IF(S19=0,U18,U18+1)","v":"2016-02-13"},{"$f":"IF(S19=0,(T19+0),(T19+S19)-1)","v":"2016-03-02"},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),AE19,IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),AE19,IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),AE19,IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),AE19,IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),AE19,IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),AE19,AD19))))))","v":19.58041958041958},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),\"Summer\",IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),\"Summer\",IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),\"Summer\",IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),\"Summer\",IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),\"Summer\",IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S19>V19,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T19>=DATE(2016,1,1),(T19<=DATE(2016,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2015,1,1),(T19<=DATE(2015,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2017,1,1),(T19<=DATE(2017,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2018,1,1),(T19<=DATE(2018,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2019,1,1),(T19<=DATE(2019,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2020,1,1),(T19<=DATE(2020,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),(((B19*C19)*O19/26)/$U$12)))))))))))))","v":19.58041958041958},{"$f":"IF(J19=0,AC19,IF(J19=-1,AC19*0.58,IF(J19=-2,(AC19*0.34),\"NA\")))","v":19.58041958041958},{"$f":"IF(K19=0,AC19,IF(K19=-1,AC19*0.72,IF(K19=-2,(AC19*0.52),\"NA\")))","v":19.58041958041958}]
["Pipeline",4000,550,319,187,396,286,null,null,0,0,null,"Pipeline",3,0.4,null,null,null,60,{"$f":"IF(S20=0,U19,U19+1)","v":"2016-03-03"},"2016-05-01",76.92307692307692,"Winter","",null,null,null,null,76.92307692307692,76.92307692307692,76.92307692307692]
["Wydot",3900,650,377,221.00000000000003,468,338,null,null,0,0,null,"Wydot",4,0.4,null,null,null,50,"2016-05-02","2016-06-20",88.63636363636364,"Winter","",null,null,null,null,88.63636363636364,88.63636363636364,88.63636363636364]
["Son of A Gun",2800,600,348,204.00000000000003,432,312,null,null,0,0,null,"Son of A Gun",5,0.4,null,null,null,40,"2016-06-21","2016-07-30",71.201525746980295,"Summer","",null,null,null,null,71.201525746980295,71.201525746980295,71.201525746980295]
["Miners Camp*",4800,300,174,102.00000000000001,216,156,null,null,0,0,null,"Miners Camp**",6,0.2,null,null,null,25,"2016-07-31","2016-08-24",30.514939605848696,"Summer","",null,null,null,null,30.514939605848696,30.514939605848696,30.514939605848696]
["Timber Top*",3500,325,188.5,110.50000000000001,234,169,null,null,0,0,null,"Timber Top**",7,0,null,null,null,0,"2016-08-24","2016-08-24",0,"Summer","",null,null,null,null,0,0,0]
["Preacher Tom",4000,550,319,187,396,286,null,null,0,0,null,"Preacher Tom",8,0.4,null,null,null,76,"2016-08-25","2016-11-08",93.240093240093231,"Summer","",null,null,null,null,93.240093240093231,93.240093240093231,93.240093240093231]
["Old Homestead",3200,600,348,204.00000000000003,432,312,null,null,0,0,null,"Old Homestead",9,0.4,null,null,null,52,"2016-11-09",{"$f":"IF(S26=0,(T26+0),(T26+S26)-1)","v":"2016-12-30"},81.373172282263198,"Summer","",null,null,null,null,81.373172282263198,81.373172282263198,81.373172282263198]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(S18:S26)","v":365},null,null,{"$f":"SUM(V18:V26)","v":506.0500105954651},null,null,null,null,null,null,{"$f":"SUM(AC18:AC26)","v":506.0500105954651},{"$f":"SUM(AD18:AD26)","v":506.0500105954651},{"$f":"SUM(AE18:AE26)","v":506.0500105954651}]
[null,null,null,null,null,null,null,null,null,null,null,null,"**Rest rotation every other year, summer use",null,null,null,null,null,{"$f":"IF(S27>365,\"Exceeds 365 days in grazing year!\",\"\")","v":""},null,null,{"$f":"IF(V27<365,\"Less than 365 days of available forage!\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Instructions for Drought Scenario Planning"]
[null,null,null,null,null,null,null,null,null,"1. Input user defined data into open white boxes"]
[null,null,null,null,null,null,null,null,null,"2. Enter SPI value for winter and summer for each pasture"]
[null,null,null,null,null,null,null,null,null,"3. Enter Unavailable water dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"4. Enter use restriction dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"5. Examine warnings for use levels exceeded (red text)"]
[null,null,null,null,null,null,null,null,null,"6. Consider adjustments to maintain use within allowable levels. Consider the following:"]
[null,null,null,null,null,null,null,null,null,"          a. Herd size and composition"]
[null,null,null,null,null,null,null,null,null,"          b. Days in pasture"]
[null,null,null,null,null,null,null,null,null,"          c. Pasture rotation sequence"]
[null,null,null,null,null,null,null,null,null,"          d. Planned utilization"]
[null,null,null,null,null,null,null,null,null,"Other Features"]
[null,null,null,null,null,null,null,null,null,"1. \"Pasture Sequence Re-Sort\" button on the screen will re-arrange the pastures and dates according to the pasture rotation sequence you selected if you decide to make changes to the original sequence (cannot undo this action except by hand)."]
[null,null,null,null,null,null,null,null,null,"2. Saving scenario solutions in spreadsheet tabs: Identical copies of the tool with the specific scenario details are saved in different spreadsheet tabs located at the bottom of the window; these can be used to save different possible solutions to a single drought scenario. These are labeled by default as \"Solution 1\", \"Solution 2\", etc."]
[null,null,null,null,null,null,null,null,null,"3. Worksheet: used in conjunction with this tool to identify solutions and determine whether they will need consultation and approval with updated AOI and deviation from AMP.  "]

{"sheet":"Solution 4","index":3,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,3,11,4],[11,5,11,6],[8,9,8,12],[8,13,8,14],[8,15,8,16],[9,9,9,12],[10,9,10,12],[15,15,16,15],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,9,15,10],[15,12,16,12],[15,13,16,13],[15,14,16,14],[19,23,19,26],[15,16,16,16],[15,18,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[15,22,16,22],[15,23,16,26],[15,28,16,28],[15,29,15,30],[17,23,17,26],[18,23,18,26],[37,9,37,16],[20,23,20,26],[21,23,21,26],[22,23,22,26],[23,23,23,26],[24,23,24,26],[25,23,25,26],[26,22,26,26],[27,18,30,18],[27,21,30,21],[35,9,35,16],[36,9,36,16],[49,9,49,16],[38,9,38,16],[39,9,39,16],[40,9,40,16],[41,9,41,16],[42,9,42,16],[43,9,43,16],[44,9,44,16],[45,9,45,16],[46,9,46,16],[47,9,47,16],[48,9,48,16]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,"Herd Composition"]
[null,null,null,null,null,null,null,null,null,"Reference Values for Drought Severity Effects on Seasonal Forage Production",null,null,null,null,null,null,null,null,null,"Jan - May","June - Dec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter*",null,"Summer",null,null,"Cows",300,300]
[null,null,null,null,null,null,null,null,null,"Standard Precipitation Index (SPI)",null,null,null,-1,-2,-1,-2,null,"Bulls",{"$f":"T9/15","v":20},{"$f":"U9/15","v":20}]
[null,null,null,"% of averag forage production, for SPI values -1, -2 in the winter and summer seasons",null,null,null,null,null,"Estimated Forage Reduction (% of Average)",null,null,null,0.57999999999999996,0.34,0.72,0.52,null,"Yearlings",150,40]
[null,null,null,"Winter",null,"Summer",null,null,null,"*Winter = October - May; Summer = June - September",null,null,null,null,null,null,null,null,"Total Herd AU's",{"$f":"T9+(T10*1.75)+(T11*0.7)","v":440},{"$f":"U9+(U10*1.75)+(U11*0.7)","v":363}]
[]
[null,null,null,"SPI -1","SPI -2","SPI -1","SPI -2"]
["Pasture Forage Production",null,null,0.57999999999999996,0.34,0.72,0.52,null,null,"Drought Factors",null,null,"Grazing Plan"]
["Pasture","Acreage","Average Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)",null,null,"SPI Value          (pasture level)",null,null,"Pasture","Pasture Rotation Sequence","Planned % Utilization ","Water   (dates when unavailable)","Seasonal Use  Restrictions (dates)",null,"Number Days in Pasture","First Day in Pasture","Last Day in Pasture","Maximum Seasonal Grazing Days","Drought Season Affecting Forage Production","Pasture Warnings",null,null,null,null," Herd Grazing Days Without Drought","Drought-Adjusted Seasonal Herd Grazing Days "]
[null,null,null,null,null,null,null,null,null,"Winter     Season","Summer Season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter Season","Summer Season"]
["Riparian",3000,850,{"$f":"C18*$D$15","v":492.99999999999994},{"$f":"C18*$E$15","v":289},{"$f":"C18*$F$15","v":612},{"$f":"C18*$G$15","v":442},null,null,0,0,null,"Riparian",1,0.2,null,null,null,43,"2016-01-01",{"$f":"IF(S18=0,(T18+0),(T18+S18)-1)","v":"2016-02-12"},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),AE18,IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),AE18,IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),AE18,IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),AE18,IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),AE18,IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),AE18,AD18))))))","v":44.580419580419587},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),\"Summer\",IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),\"Summer\",IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),\"Summer\",IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),\"Summer\",IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),\"Summer\",IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S18>V18,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T18>=DATE(2016,1,1),(T18<=DATE(2016,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2015,1,1),(T18<=DATE(2015,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2017,1,1),(T18<=DATE(2017,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2018,1,1),(T18<=DATE(2018,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2019,1,1),(T18<=DATE(2019,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2020,1,1),(T18<=DATE(2020,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),(((B18*C18)*O18/26)/$U$12)))))))))))))","v":44.580419580419587},{"$f":"IF(J18=0,AC18,IF(J18=-1,AC18*0.58,IF(J18=-2,(AC18*0.34),\"NA\")))","v":44.580419580419587},{"$f":"IF(K18=0,AC18,IF(K18=-1,AC18*0.72,IF(K18=-2,(AC18*0.52),\"NA\")))","v":44.580419580419587}]
["Headquarters",800,700,406,238.00000000000003,504,364,null,null,0,0,null,"Headquarters",2,0.4,null,null,null,19,{"$f":"IF(S19=0,U18,U18+1)","v":"2016-02-13"},{"$f":"IF(S19=0,(T19+0),(T19+S19)-1)","v":"2016-03-02"},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),AE19,IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),AE19,IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),AE19,IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),AE19,IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),AE19,IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),AE19,AD19))))))","v":19.58041958041958},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),\"Summer\",IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),\"Summer\",IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),\"Summer\",IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),\"Summer\",IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),\"Summer\",IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S19>V19,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T19>=DATE(2016,1,1),(T19<=DATE(2016,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2015,1,1),(T19<=DATE(2015,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2017,1,1),(T19<=DATE(2017,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2018,1,1),(T19<=DATE(2018,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2019,1,1),(T19<=DATE(2019,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2020,1,1),(T19<=DATE(2020,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),(((B19*C19)*O19/26)/$U$12)))))))))))))","v":19.58041958041958},{"$f":"IF(J19=0,AC19,IF(J19=-1,AC19*0.58,IF(J19=-2,(AC19*0.34),\"NA\")))","v":19.58041958041958},{"$f":"IF(K19=0,AC19,IF(K19=-1,AC19*0.72,IF(K19=-2,(AC19*0.52),\"NA\")))","v":19.58041958041958}]
["Pipeline",4000,550,319,187,396,286,null,null,0,0,null,"Pipeline",3,0.4,null,null,null,60,{"$f":"IF(S20=0,U19,U19+1)","v":"2016-03-03"},"2016-05-01",76.92307692307692,"Winter","",null,null,null,null,76.92307692307692,76.92307692307692,76.92307692307692]
["Wydot",3900,650,377,221.00000000000003,468,338,null,null,0,0,null,"Wydot",4,0.4,null,null,null,50,"2016-05-02","2016-06-20",88.63636363636364,"Winter","",null,null,null,null,88.63636363636364,88.63636363636364,88.63636363636364]
["Son of A Gun",2800,600,348,204.00000000000003,432,312,null,null,0,0,null,"Son of A Gun",5,0.4,null,null,null,40,"2016-06-21","2016-07-30",71.201525746980295,"Summer","",null,null,null,null,71.201525746980295,71.201525746980295,71.201525746980295]
["Miners Camp*",4800,300,174,102.00000000000001,216,156,null,null,0,0,null,"Miners Camp**",6,0.2,null,null,null,25,"2016-07-31","2016-08-24",30.514939605848696,"Summer","",null,null,null,null,30.514939605848696,30.514939605848696,30.514939605848696]
["Timber Top*",3500,325,188.5,110.50000000000001,234,169,null,null,0,0,null,"Timber Top**",7,0,null,null,null,0,"2016-08-24","2016-08-24",0,"Summer","",null,null,null,null,0,0,0]
["Preacher Tom",4000,550,319,187,396,286,null,null,0,0,null,"Preacher Tom",8,0.4,null,null,null,76,"2016-08-25","2016-11-08",93.240093240093231,"Summer","",null,null,null,null,93.240093240093231,93.240093240093231,93.240093240093231]
["Old Homestead",3200,600,348,204.00000000000003,432,312,null,null,0,0,null,"Old Homestead",9,0.4,null,null,null,52,"2016-11-09",{"$f":"IF(S26=0,(T26+0),(T26+S26)-1)","v":"2016-12-30"},81.373172282263198,"Summer","",null,null,null,null,81.373172282263198,81.373172282263198,81.373172282263198]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(S18:S26)","v":365},null,null,{"$f":"SUM(V18:V26)","v":506.0500105954651},null,null,null,null,null,null,{"$f":"SUM(AC18:AC26)","v":506.0500105954651},{"$f":"SUM(AD18:AD26)","v":506.0500105954651},{"$f":"SUM(AE18:AE26)","v":506.0500105954651}]
[null,null,null,null,null,null,null,null,null,null,null,null,"**Rest rotation every other year, summer use",null,null,null,null,null,{"$f":"IF(S27>365,\"Exceeds 365 days in grazing year!\",\"\")","v":""},null,null,{"$f":"IF(V27<365,\"Less than 365 days of available forage!\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Instructions for Drought Scenario Planning"]
[null,null,null,null,null,null,null,null,null,"1. Input user defined data into open white boxes"]
[null,null,null,null,null,null,null,null,null,"2. Enter SPI value for winter and summer for each pasture"]
[null,null,null,null,null,null,null,null,null,"3. Enter Unavailable water dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"4. Enter use restriction dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"5. Examine warnings for use levels exceeded (red text)"]
[null,null,null,null,null,null,null,null,null,"6. Consider adjustments to maintain use within allowable levels. Consider the following:"]
[null,null,null,null,null,null,null,null,null,"          a. Herd size and composition"]
[null,null,null,null,null,null,null,null,null,"          b. Days in pasture"]
[null,null,null,null,null,null,null,null,null,"          c. Pasture rotation sequence"]
[null,null,null,null,null,null,null,null,null,"          d. Planned utilization"]
[null,null,null,null,null,null,null,null,null,"Other Features"]
[null,null,null,null,null,null,null,null,null,"1. \"Pasture Sequence Re-Sort\" button on the screen will re-arrange the pastures and dates according to the pasture rotation sequence you selected if you decide to make changes to the original sequence (cannot undo this action except by hand)."]
[null,null,null,null,null,null,null,null,null,"2. Saving scenario solutions in spreadsheet tabs: Identical copies of the tool with the specific scenario details are saved in different spreadsheet tabs located at the bottom of the window; these can be used to save different possible solutions to a single drought scenario. These are labeled by default as \"Solution 1\", \"Solution 2\", etc."]
[null,null,null,null,null,null,null,null,null,"3. Worksheet: used in conjunction with this tool to identify solutions and determine whether they will need consultation and approval with updated AOI and deviation from AMP.  "]

{"sheet":"Solution 5","index":4,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,3,11,4],[11,5,11,6],[8,9,8,12],[8,13,8,14],[8,15,8,16],[9,9,9,12],[10,9,10,12],[15,15,16,15],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,9,15,10],[15,12,16,12],[15,13,16,13],[15,14,16,14],[19,23,19,26],[15,16,16,16],[15,18,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[15,22,16,22],[15,23,16,26],[15,28,16,28],[15,29,15,30],[17,23,17,26],[18,23,18,26],[37,9,37,16],[20,23,20,26],[21,23,21,26],[22,23,22,26],[23,23,23,26],[24,23,24,26],[25,23,25,26],[26,22,26,26],[27,18,30,18],[27,21,30,21],[35,9,35,16],[36,9,36,16],[49,9,49,16],[38,9,38,16],[39,9,39,16],[40,9,40,16],[41,9,41,16],[42,9,42,16],[43,9,43,16],[44,9,44,16],[45,9,45,16],[46,9,46,16],[47,9,47,16],[48,9,48,16]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,"Herd Composition"]
[null,null,null,null,null,null,null,null,null,"Reference Values for Drought Severity Effects on Seasonal Forage Production",null,null,null,null,null,null,null,null,null,"Jan - May","June - Dec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter*",null,"Summer",null,null,"Cows",300,300]
[null,null,null,null,null,null,null,null,null,"Standard Precipitation Index (SPI)",null,null,null,-1,-2,-1,-2,null,"Bulls",{"$f":"T9/15","v":20},{"$f":"U9/15","v":20}]
[null,null,null,"% of averag forage production, for SPI values -1, -2 in the winter and summer seasons",null,null,null,null,null,"Estimated Forage Reduction (% of Average)",null,null,null,0.57999999999999996,0.34,0.72,0.52,null,"Yearlings",150,40]
[null,null,null,"Winter",null,"Summer",null,null,null,"*Winter = October - May; Summer = June - September",null,null,null,null,null,null,null,null,"Total Herd AU's",{"$f":"T9+(T10*1.75)+(T11*0.7)","v":440},{"$f":"U9+(U10*1.75)+(U11*0.7)","v":363}]
[]
[null,null,null,"SPI -1","SPI -2","SPI -1","SPI -2"]
["Pasture Forage Production",null,null,0.57999999999999996,0.34,0.72,0.52,null,null,"Drought Factors",null,null,"Grazing Plan"]
["Pasture","Acreage","Average Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)",null,null,"SPI Value          (pasture level)",null,null,"Pasture","Pasture Rotation Sequence","Planned % Utilization ","Water   (dates when unavailable)","Seasonal Use  Restrictions (dates)",null,"Number Days in Pasture","First Day in Pasture","Last Day in Pasture","Maximum Seasonal Grazing Days","Drought Season Affecting Forage Production","Pasture Warnings",null,null,null,null," Herd Grazing Days Without Drought","Drought-Adjusted Seasonal Herd Grazing Days "]
[null,null,null,null,null,null,null,null,null,"Winter     Season","Summer Season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter Season","Summer Season"]
["Riparian",3000,850,{"$f":"C18*$D$15","v":492.99999999999994},{"$f":"C18*$E$15","v":289},{"$f":"C18*$F$15","v":612},{"$f":"C18*$G$15","v":442},null,null,0,0,null,"Riparian",1,0.2,null,null,null,43,"2016-01-01",{"$f":"IF(S18=0,(T18+0),(T18+S18)-1)","v":"2016-02-12"},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),AE18,IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),AE18,IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),AE18,IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),AE18,IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),AE18,IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),AE18,AD18))))))","v":44.580419580419587},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),\"Summer\",IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),\"Summer\",IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),\"Summer\",IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),\"Summer\",IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),\"Summer\",IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S18>V18,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T18>=DATE(2016,1,1),(T18<=DATE(2016,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2015,1,1),(T18<=DATE(2015,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2017,1,1),(T18<=DATE(2017,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2018,1,1),(T18<=DATE(2018,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2019,1,1),(T18<=DATE(2019,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2020,1,1),(T18<=DATE(2020,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),(((B18*C18)*O18/26)/$U$12)))))))))))))","v":44.580419580419587},{"$f":"IF(J18=0,AC18,IF(J18=-1,AC18*0.58,IF(J18=-2,(AC18*0.34),\"NA\")))","v":44.580419580419587},{"$f":"IF(K18=0,AC18,IF(K18=-1,AC18*0.72,IF(K18=-2,(AC18*0.52),\"NA\")))","v":44.580419580419587}]
["Headquarters",800,700,406,238.00000000000003,504,364,null,null,0,0,null,"Headquarters",2,0.4,null,null,null,19,{"$f":"IF(S19=0,U18,U18+1)","v":"2016-02-13"},{"$f":"IF(S19=0,(T19+0),(T19+S19)-1)","v":"2016-03-02"},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),AE19,IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),AE19,IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),AE19,IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),AE19,IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),AE19,IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),AE19,AD19))))))","v":19.58041958041958},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),\"Summer\",IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),\"Summer\",IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),\"Summer\",IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),\"Summer\",IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),\"Summer\",IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S19>V19,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T19>=DATE(2016,1,1),(T19<=DATE(2016,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2015,1,1),(T19<=DATE(2015,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2017,1,1),(T19<=DATE(2017,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2018,1,1),(T19<=DATE(2018,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2019,1,1),(T19<=DATE(2019,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2020,1,1),(T19<=DATE(2020,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),(((B19*C19)*O19/26)/$U$12)))))))))))))","v":19.58041958041958},{"$f":"IF(J19=0,AC19,IF(J19=-1,AC19*0.58,IF(J19=-2,(AC19*0.34),\"NA\")))","v":19.58041958041958},{"$f":"IF(K19=0,AC19,IF(K19=-1,AC19*0.72,IF(K19=-2,(AC19*0.52),\"NA\")))","v":19.58041958041958}]
["Pipeline",4000,550,319,187,396,286,null,null,0,0,null,"Pipeline",3,0.4,null,null,null,60,{"$f":"IF(S20=0,U19,U19+1)","v":"2016-03-03"},"2016-05-01",76.92307692307692,"Winter","",null,null,null,null,76.92307692307692,76.92307692307692,76.92307692307692]
["Wydot",3900,650,377,221.00000000000003,468,338,null,null,0,0,null,"Wydot",4,0.4,null,null,null,50,"2016-05-02","2016-06-20",88.63636363636364,"Winter","",null,null,null,null,88.63636363636364,88.63636363636364,88.63636363636364]
["Son of A Gun",2800,600,348,204.00000000000003,432,312,null,null,0,0,null,"Son of A Gun",5,0.4,null,null,null,40,"2016-06-21","2016-07-30",71.201525746980295,"Summer","",null,null,null,null,71.201525746980295,71.201525746980295,71.201525746980295]
["Miners Camp*",4800,300,174,102.00000000000001,216,156,null,null,0,0,null,"Miners Camp**",6,0.2,null,null,null,25,"2016-07-31","2016-08-24",30.514939605848696,"Summer","",null,null,null,null,30.514939605848696,30.514939605848696,30.514939605848696]
["Timber Top*",3500,325,188.5,110.50000000000001,234,169,null,null,0,0,null,"Timber Top**",7,0,null,null,null,0,"2016-08-24","2016-08-24",0,"Summer","",null,null,null,null,0,0,0]
["Preacher Tom",4000,550,319,187,396,286,null,null,0,0,null,"Preacher Tom",8,0.4,null,null,null,76,"2016-08-25","2016-11-08",93.240093240093231,"Summer","",null,null,null,null,93.240093240093231,93.240093240093231,93.240093240093231]
["Old Homestead",3200,600,348,204.00000000000003,432,312,null,null,0,0,null,"Old Homestead",9,0.4,null,null,null,52,"2016-11-09",{"$f":"IF(S26=0,(T26+0),(T26+S26)-1)","v":"2016-12-30"},81.373172282263198,"Summer","",null,null,null,null,81.373172282263198,81.373172282263198,81.373172282263198]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(S18:S26)","v":365},null,null,{"$f":"SUM(V18:V26)","v":506.0500105954651},null,null,null,null,null,null,{"$f":"SUM(AC18:AC26)","v":506.0500105954651},{"$f":"SUM(AD18:AD26)","v":506.0500105954651},{"$f":"SUM(AE18:AE26)","v":506.0500105954651}]
[null,null,null,null,null,null,null,null,null,null,null,null,"**Rest rotation every other year, summer use",null,null,null,null,null,{"$f":"IF(S27>365,\"Exceeds 365 days in grazing year!\",\"\")","v":""},null,null,{"$f":"IF(V27<365,\"Less than 365 days of available forage!\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Instructions for Drought Scenario Planning"]
[null,null,null,null,null,null,null,null,null,"1. Input user defined data into open white boxes"]
[null,null,null,null,null,null,null,null,null,"2. Enter SPI value for winter and summer for each pasture"]
[null,null,null,null,null,null,null,null,null,"3. Enter Unavailable water dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"4. Enter use restriction dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"5. Examine warnings for use levels exceeded (red text)"]
[null,null,null,null,null,null,null,null,null,"6. Consider adjustments to maintain use within allowable levels. Consider the following:"]
[null,null,null,null,null,null,null,null,null,"          a. Herd size and composition"]
[null,null,null,null,null,null,null,null,null,"          b. Days in pasture"]
[null,null,null,null,null,null,null,null,null,"          c. Pasture rotation sequence"]
[null,null,null,null,null,null,null,null,null,"          d. Planned utilization"]
[null,null,null,null,null,null,null,null,null,"Other Features"]
[null,null,null,null,null,null,null,null,null,"1. \"Pasture Sequence Re-Sort\" button on the screen will re-arrange the pastures and dates according to the pasture rotation sequence you selected if you decide to make changes to the original sequence (cannot undo this action except by hand)."]
[null,null,null,null,null,null,null,null,null,"2. Saving scenario solutions in spreadsheet tabs: Identical copies of the tool with the specific scenario details are saved in different spreadsheet tabs located at the bottom of the window; these can be used to save different possible solutions to a single drought scenario. These are labeled by default as \"Solution 1\", \"Solution 2\", etc."]
[null,null,null,null,null,null,null,null,null,"3. Worksheet: used in conjunction with this tool to identify solutions and determine whether they will need consultation and approval with updated AOI and deviation from AMP.  "]

{"sheet":"Solution 6","index":5,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,3,11,4],[11,5,11,6],[8,9,8,12],[8,13,8,14],[8,15,8,16],[9,9,9,12],[10,9,10,12],[15,15,16,15],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,9,15,10],[15,12,16,12],[15,13,16,13],[15,14,16,14],[19,23,19,26],[15,16,16,16],[15,18,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[15,22,16,22],[15,23,16,26],[15,28,16,28],[15,29,15,30],[17,23,17,26],[18,23,18,26],[37,9,37,16],[20,23,20,26],[21,23,21,26],[22,23,22,26],[23,23,23,26],[24,23,24,26],[25,23,25,26],[26,22,26,26],[27,18,30,18],[27,21,30,21],[35,9,35,16],[36,9,36,16],[49,9,49,16],[38,9,38,16],[39,9,39,16],[40,9,40,16],[41,9,41,16],[42,9,42,16],[43,9,43,16],[44,9,44,16],[45,9,45,16],[46,9,46,16],[47,9,47,16],[48,9,48,16]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,"Herd Composition"]
[null,null,null,null,null,null,null,null,null,"Reference Values for Drought Severity Effects on Seasonal Forage Production",null,null,null,null,null,null,null,null,null,"Jan - May","June - Dec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter*",null,"Summer",null,null,"Cows",300,300]
[null,null,null,null,null,null,null,null,null,"Standard Precipitation Index (SPI)",null,null,null,-1,-2,-1,-2,null,"Bulls",{"$f":"T9/15","v":20},{"$f":"U9/15","v":20}]
[null,null,null,"% of averag forage production, for SPI values -1, -2 in the winter and summer seasons",null,null,null,null,null,"Estimated Forage Reduction (% of Average)",null,null,null,0.57999999999999996,0.34,0.72,0.52,null,"Yearlings",150,40]
[null,null,null,"Winter",null,"Summer",null,null,null,"*Winter = October - May; Summer = June - September",null,null,null,null,null,null,null,null,"Total Herd AU's",{"$f":"T9+(T10*1.75)+(T11*0.7)","v":440},{"$f":"U9+(U10*1.75)+(U11*0.7)","v":363}]
[]
[null,null,null,"SPI -1","SPI -2","SPI -1","SPI -2"]
["Pasture Forage Production",null,null,0.57999999999999996,0.34,0.72,0.52,null,null,"Drought Factors",null,null,"Grazing Plan"]
["Pasture","Acreage","Average Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)","SPI - 1 Forage Production (lbs/A)","SPI - 2 Forage Production (lbs/A)",null,null,"SPI Value          (pasture level)",null,null,"Pasture","Pasture Rotation Sequence","Planned % Utilization ","Water   (dates when unavailable)","Seasonal Use  Restrictions (dates)",null,"Number Days in Pasture","First Day in Pasture","Last Day in Pasture","Maximum Seasonal Grazing Days","Drought Season Affecting Forage Production","Pasture Warnings",null,null,null,null," Herd Grazing Days Without Drought","Drought-Adjusted Seasonal Herd Grazing Days "]
[null,null,null,null,null,null,null,null,null,"Winter     Season","Summer Season",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter Season","Summer Season"]
["Riparian",3000,850,{"$f":"C18*$D$15","v":492.99999999999994},{"$f":"C18*$E$15","v":289},{"$f":"C18*$F$15","v":612},{"$f":"C18*$G$15","v":442},null,null,0,0,null,"Riparian",1,0.2,null,null,null,43,"2016-01-01",{"$f":"IF(S18=0,(T18+0),(T18+S18)-1)","v":"2016-02-12"},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),AE18,IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),AE18,IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),AE18,IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),AE18,IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),AE18,IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),AE18,AD18))))))","v":44.580419580419587},{"$f":"IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),\"Summer\",IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),\"Summer\",IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),\"Summer\",IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),\"Summer\",IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),\"Summer\",IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S18>V18,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T18>=DATE(2016,1,1),(T18<=DATE(2016,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2016,6,1),(T18<=DATE(2016,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2015,1,1),(T18<=DATE(2015,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2015,6,1),(T18<=DATE(2015,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2017,1,1),(T18<=DATE(2017,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2017,6,1),(T18<=DATE(2017,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2018,1,1),(T18<=DATE(2018,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2018,6,1),(T18<=DATE(2018,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2019,1,1),(T18<=DATE(2019,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2019,6,1),(T18<=DATE(2019,12,31))),(((B18*C18)*O18/26)/$U$12),IF(AND(T18>=DATE(2020,1,1),(T18<=DATE(2020,5,31))),(((B18*C18)*O18/26)/$T$12),IF(AND(T18>=DATE(2020,6,1),(T18<=DATE(2020,12,31))),(((B18*C18)*O18/26)/$U$12)))))))))))))","v":44.580419580419587},{"$f":"IF(J18=0,AC18,IF(J18=-1,AC18*0.58,IF(J18=-2,(AC18*0.34),\"NA\")))","v":44.580419580419587},{"$f":"IF(K18=0,AC18,IF(K18=-1,AC18*0.72,IF(K18=-2,(AC18*0.52),\"NA\")))","v":44.580419580419587}]
["Headquarters",800,700,406,238.00000000000003,504,364,null,null,0,0,null,"Headquarters",2,0.4,null,null,null,19,{"$f":"IF(S19=0,U18,U18+1)","v":"2016-02-13"},{"$f":"IF(S19=0,(T19+0),(T19+S19)-1)","v":"2016-03-02"},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),AE19,IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),AE19,IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),AE19,IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),AE19,IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),AE19,IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),AE19,AD19))))))","v":19.58041958041958},{"$f":"IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),\"Summer\",IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),\"Summer\",IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),\"Summer\",IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),\"Summer\",IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),\"Summer\",IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),\"Summer\",\"Winter\"))))))","v":"Winter"},{"$f":"IF(S19>V19,\"Exceeds Maximum Seasonal Grazing Days\",\"\")","v":""},null,null,null,null,{"$f":"IF(AND(T19>=DATE(2016,1,1),(T19<=DATE(2016,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2016,6,1),(T19<=DATE(2016,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2015,1,1),(T19<=DATE(2015,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2015,6,1),(T19<=DATE(2015,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2017,1,1),(T19<=DATE(2017,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2017,6,1),(T19<=DATE(2017,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2018,1,1),(T19<=DATE(2018,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2018,6,1),(T19<=DATE(2018,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2019,1,1),(T19<=DATE(2019,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2019,6,1),(T19<=DATE(2019,12,31))),(((B19*C19)*O19/26)/$U$12),IF(AND(T19>=DATE(2020,1,1),(T19<=DATE(2020,5,31))),(((B19*C19)*O19/26)/$T$12),IF(AND(T19>=DATE(2020,6,1),(T19<=DATE(2020,12,31))),(((B19*C19)*O19/26)/$U$12)))))))))))))","v":19.58041958041958},{"$f":"IF(J19=0,AC19,IF(J19=-1,AC19*0.58,IF(J19=-2,(AC19*0.34),\"NA\")))","v":19.58041958041958},{"$f":"IF(K19=0,AC19,IF(K19=-1,AC19*0.72,IF(K19=-2,(AC19*0.52),\"NA\")))","v":19.58041958041958}]
["Pipeline",4000,550,319,187,396,286,null,null,0,0,null,"Pipeline",3,0.4,null,null,null,60,{"$f":"IF(S20=0,U19,U19+1)","v":"2016-03-03"},"2016-05-01",76.92307692307692,"Winter","",null,null,null,null,76.92307692307692,76.92307692307692,76.92307692307692]
["Wydot",3900,650,377,221.00000000000003,468,338,null,null,0,0,null,"Wydot",4,0.4,null,null,null,50,"2016-05-02","2016-06-20",88.63636363636364,"Winter","",null,null,null,null,88.63636363636364,88.63636363636364,88.63636363636364]
["Son of A Gun",2800,600,348,204.00000000000003,432,312,null,null,0,0,null,"Son of A Gun",5,0.4,null,null,null,40,"2016-06-21","2016-07-30",71.201525746980295,"Summer","",null,null,null,null,71.201525746980295,71.201525746980295,71.201525746980295]
["Miners Camp*",4800,300,174,102.00000000000001,216,156,null,null,0,0,null,"Miners Camp**",6,0.2,null,null,null,25,"2016-07-31","2016-08-24",30.514939605848696,"Summer","",null,null,null,null,30.514939605848696,30.514939605848696,30.514939605848696]
["Timber Top*",3500,325,188.5,110.50000000000001,234,169,null,null,0,0,null,"Timber Top**",7,0,null,null,null,0,"2016-08-24","2016-08-24",0,"Summer","",null,null,null,null,0,0,0]
["Preacher Tom",4000,550,319,187,396,286,null,null,0,0,null,"Preacher Tom",8,0.4,null,null,null,76,"2016-08-25","2016-11-08",93.240093240093231,"Summer","",null,null,null,null,93.240093240093231,93.240093240093231,93.240093240093231]
["Old Homestead",3200,600,348,204.00000000000003,432,312,null,null,0,0,null,"Old Homestead",9,0.4,null,null,null,52,"2016-11-09",{"$f":"IF(S26=0,(T26+0),(T26+S26)-1)","v":"2016-12-30"},81.373172282263198,"Summer","",null,null,null,null,81.373172282263198,81.373172282263198,81.373172282263198]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(S18:S26)","v":365},null,null,{"$f":"SUM(V18:V26)","v":506.0500105954651},null,null,null,null,null,null,{"$f":"SUM(AC18:AC26)","v":506.0500105954651},{"$f":"SUM(AD18:AD26)","v":506.0500105954651},{"$f":"SUM(AE18:AE26)","v":506.0500105954651}]
[null,null,null,null,null,null,null,null,null,null,null,null,"**Rest rotation every other year, summer use",null,null,null,null,null,{"$f":"IF(S27>365,\"Exceeds 365 days in grazing year!\",\"\")","v":""},null,null,{"$f":"IF(V27<365,\"Less than 365 days of available forage!\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Instructions for Drought Scenario Planning"]
[null,null,null,null,null,null,null,null,null,"1. Input user defined data into open white boxes"]
[null,null,null,null,null,null,null,null,null,"2. Enter SPI value for winter and summer for each pasture"]
[null,null,null,null,null,null,null,null,null,"3. Enter Unavailable water dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"4. Enter use restriction dates for each pasture"]
[null,null,null,null,null,null,null,null,null,"5. Examine warnings for use levels exceeded (red text)"]
[null,null,null,null,null,null,null,null,null,"6. Consider adjustments to maintain use within allowable levels. Consider the following:"]
[null,null,null,null,null,null,null,null,null,"          a. Herd size and composition"]
[null,null,null,null,null,null,null,null,null,"          b. Days in pasture"]
[null,null,null,null,null,null,null,null,null,"          c. Pasture rotation sequence"]
[null,null,null,null,null,null,null,null,null,"          d. Planned utilization"]
[null,null,null,null,null,null,null,null,null,"Other Features"]
[null,null,null,null,null,null,null,null,null,"1. \"Pasture Sequence Re-Sort\" button on the screen will re-arrange the pastures and dates according to the pasture rotation sequence you selected if you decide to make changes to the original sequence (cannot undo this action except by hand)."]
[null,null,null,null,null,null,null,null,null,"2. Saving scenario solutions in spreadsheet tabs: Identical copies of the tool with the specific scenario details are saved in different spreadsheet tabs located at the bottom of the window; these can be used to save different possible solutions to a single drought scenario. These are labeled by default as \"Solution 1\", \"Solution 2\", etc."]
[null,null,null,null,null,null,null,null,null,"3. Worksheet: used in conjunction with this tool to identify solutions and determine whether they will need consultation and approval with updated AOI and deviation from AMP.  "]