{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Step 1 Instructions","Step 1 Project Scores","Step 2 Instructions","Step 2 Portfolio Analysis"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":96,"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":"Step 1 Instructions","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,13],[2,0,7,13],[9,0,14,13]]}
["DO NOT CHANGE ANY VALUES EXCEPT IN CELLS COLORED IN GREY"]
[]
["Step 1 - fill in the project names, and the scores in the gray boxes. "]
[]
[]
[]
[]
[]
[]
["Step 2 - move onto the next spreadsheet, the rest of the work on Step 1 is done for you"]

{"sheet":"Step 1 Project Scores","index":1,"n_rows":91,"n_cols":56,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,2,0,15]]}
["SCORES",null,"DO NOT CHANGE ANY VALUES EXCEPT IN CELLS COLORED IN GREY"]
[]
[null,null,"manage_species","manage_spatial","manage_uncertainty","manage_currentpractices","manage_adaptivemanagement","pop_conservationneed A","pop_conservationneed B","pop_spatialscope","pop_temporalscope","hab_temporal","hab_quantity","hab_quality","ecoprocess_spp","ecoprocess_uncertainty","datasharing","broaderimpacts","exisitingpriorities","partners","leverage","alignment","objhyp","response","targettaxa","surveydesign","stats","datamanagement","budget","timeline"]
["Project Name",null,"metric1","metric2","metric3","metric4","metric5","metric6a","metric6b","metric7","metric8","metric9","metric10","metric11","metric12","metric13","metric14","metric15","metric16","metric17","metric18","metric19","metric20","metric21","metric22","metric23","metric24","metric25","metric26","metric27"]
["Project 1",null,9,6.25,2,2,0,186,1054,75,5,0,2,0,0,0,4,0,2,3,0,0,2,3,3,3,2,3,2,2]
["Project 2",null,3,28.2,1,0,0,0,0,0,0,0,2,0,4,1,0,0,3,3,0,0,2,3,3,3,2,3,2,2]
["Project 3",null,8,28.2,2,0,0,0,0,0,0,0,2,0,5,1,0,2,0,0,0,1,2,3,3,3,2,1,2,2]
["Project 4",null,1,6.25,2,0,0,0,0,0,0,0,2,0,4,1,0,1,3,3,4,0,1,3,3,1,0,0,2,1]
["Project 5",null,4,3.1,2,0,0,0,0,50,2,0,2,0,0,0,0,1,3,3,4,1,0,3,3,2,0,0,2,1]
["Project 6",null,10,6.2E-2,2,0,0,0,0,10,2,0,2,0,0,0,0,1,0,3,3,0,0,0,3,0,0,0,2,1]
["Project 7",null,52,18.8,0,2,0,0,0,85,12,85,8,12,8,1,0,0,3,3,0,0,2,0,1,3,2,2,0,2]
["Project 8",null,3,18.8,2,1,1,0,0,14,14,14,8,14,0,0,0,3,1,3,0,0,2,3,3,3,2,0,1,1]
["Project 9",null,9,15.6,2,1,0,70,140,0,0,0,2,0,0,0,3,0,3,2,1,0,2,3,3,1,2,1,1,2]
["Project 10",null,0,0,0,0,0,0,0,0,0,0,2,0,6,2,1,2,3,2,2,0,0,2,3,3,1,1,0,2]
["Project 11",null,0,0,0,0,0,6,102,52,15,52,8,15,3,1,1,0,3,3,2,2,2,1,3,3,1,2,0,1]
["Project 12",null,2,15.6,2,1,0,0,0,0,0,0,2,0,0,0,0,1,3,3,3,0,1,1,3,1,2,1,2,0]
["Project 13",null,0,0,0,0,0,0,12,39,2,39,8,2,7,1,1,0,3,3,0,0,1,0,1,0,2,1,1,1]
["Project 14",null,6,15.6,1,1,0,0,0,0,0,0,2,0,6,1,1,0,3,3,0,0,1,1,3,3,1,2,1,1]
["Project 15",null,23,12.5,2,1,1,0,0,23,3,23,8,3,1,2,2,0,2,3,3,2,0,3,1,1,2,3,2,1]
["Project 16",null,0,0,0,0,0,0,0,100,15,100,7,15,0,0,3,0,3,3,5,0,2,2,2,1,2,3,2,2]
["Project 17",null,2,15.6,2,1,1,58,290,0,0,0,8,3,0,0,0,0,3,2,0,0,2,3,1,0,1,0,2,1]
["Project 18",null,0,0,0,0,0,0,30,0,0,0,2,0,8,1,1,3,3,3,5,1,2,2,1,2,1,2,1,0]
["Project 19",null,8,3.125,1,2,0,0,0,0,0,0,2,0,8,2,0,0,2,3,0,0,1,1,3,2,0,1,0,1]
["Project 20",null,9,15.6,1,2,0,0,435,76,10,76,6,10,8,2,1,0,3,3,3,2,1,0,0,1,2,1,0,1]
["Project 21",null,0,0,0,0,0,0,0,0,0,0,2,0,8,2,0,1,3,3,5,1,0,2,3,1,0,3,1,2]
["Project 22",null,0,0,0,0,0,16,64,0,0,0,2,0,1,2,4,2,2,3,5,0,1,2,1,0,2,1,2,1]
["Project 23",null,9,18.8,2,0,0,0,0,0,0,0,2,0,0,0,3,0,3,3,5,0,2,1,2,1,1,1,0,1]
["Project 24",null,5,6.25,2,0,0,0,0,0,0,0,2,0,0,0,0,0,3,3,5,0,0,3,1,3,2,1,0,2]
["Project 25",null,9,18.8,2,0,0,176,308,0,0,0,2,0,8,1,2,2,3,3,0,0,2,1,3,2,1,1,2,2]
["Project 26",null,17,18.8,2,1,0,0,0,0,0,0,2,0,0,0,3,0,3,3,4,0,2,1,0,2,0,1,2,2]
["Project 27",null,0,6.25,2,0,0,0,0,0,0,80,2,5,0,0,2,2,3,3,5,0,1,2,3,1,0,0,0,0]
["Project 28",null,3,6.25,2,0,1,0,0,0,0,0,4,5,0,0,4,0,3,3,4,0,2,3,3,1,0,2,2,1]
["Project 29",null,9,12.5,2,1,0,0,0,15,12,15,8,12,0,0,1,0,3,3,4,0,2,1,0,2,1,1,1,2]
["Project 30",null,33,18.8,2,0,0,0,0,0,0,0,4,2,0,0,0,0,1,1,0,0,0,3,1,2,0,2,2,0]
["Project 31",null,4,18.8,1,0,0,0,0,65,4,0,4,4,0,0,2,0,3,2,3,0,1,0,1,1,2,2,1,1]
["Project 32",null,5,3.125,2,2,1,6,102,40,16,40,8,16,0,0,2,3,3,0,4,0,0,2,1,2,1,0,2,1]
["Project 33",null,14,18.8,2,1,0,0,0,0,0,0,5,0,0,0,2,0,3,2,0,0,1,3,0,2,2,3,0,0]
["Project 34",null,0,0,0,0,0,0,12,100,15,100,8,15,0,0,2,0,3,3,4,0,2,3,3,0,2,2,1,0]
["Project 35",null,8,9.4,1,1,1,0,0,0,0,100,6,5,8,0,0,0,3,3,3,0,2,2,0,1,2,0,1,1]
[]
[]
["Weights",null,"metric1","metric2","metric3","metric4","metric5","metric6",null,"metric7","metric8","metric9","metric10","metric11","metric12","metric13","metric14","metric15","metric16","metric17","metric18","metric19","metric20","metric21","metric22","metric23","metric24","metric25","metric26","metric27"]
[null,null,"manage_species","manage_spatial","manage_uncertainty","manage_currentpractices","manage_adaptivemanagement","pop_conservationneed",null,"pop_spatialscope","pop_temporalscope","hab_temporal","hab_quantity","hab_quality","ecoprocess_spp","ecoprocess_uncertainty","datasharing","broaderimpacts","exisitingpriorities","partners","leverage","alignment","objhyp","response","targettaxa","surveydesign","stats","datamanagement","budget","timeline"]
[null,null,0.03,0.03,0.03,0.03,0.04,0.03,null,0.03,0.02,0.02,0.02,0.02,0.03,0.09,0.04,0.04,0.05,0.05,0.03,0.03,0.05,0.04,0.04,0.05,0.05,0.04,0.04,0.03,{"$f":"SUM(C44:AD44)","v":1.0000000000000004}]
["Weighted Utility"]
["Project Name","Total Benefit","metric1","metric2","metric3","metric4","metric5","metric6",null,"metric7","metric8","metric9","metric10","metric11","metric12","metric13","metric14","metric15","metric16","metric17","metric18","metric19","metric20","metric21","metric22","metric23","metric24","metric25","metric26","metric27"]
["Project 1",{"$f":"SUM(C47:AD47)","v":0.62852931598576234},{"$f":"$C$44*ValueE(C5,$B$86,$B$87,$B$88,$B$89)","v":2.5041071294184137E-2},{"$f":"$D$44*ValueE(D5, $D$86,$D$87,$D$88,$D$89)","v":1.3942790146123618E-2},{"$f":"$E$44*ValuePL(E5,$E$86:$E$88,$F$86:$F$88)","v":0.03},{"$f":"$F$44*ValuePL(F5,$G$86:$G$88,$H$86:$H$88)","v":0.03},{"$f":"$G$44*ValuePL(G5,$I$86:$I$87,$J$86:$J$87)","v":0},{"$f":"$H$44*((ValueE(H5,$L$86,$L$87,$L$88,$L$89)+ValueE(I5,$N$86,$N$87,$N$88,$N$89))/2)","v":0.03},null,{"$f":"$J$44*ValuePL(J5, $O$86:$O$89,$P$86:$P$89)","v":2.7545454545454547E-2},{"$f":"$K$44*ValuePL(K5,$Q$86:$Q$89,$R$86:$R$89)","v":2E-3},{"$f":"$L$44*ValuePL(L5,$S$86:$S$89,$T$86:$T$89)","v":0},{"$f":"$M$44*ValueE(M5,$V$86,$V$87,$V$88,$V$89)","v":0},{"$f":"$N$44*ValuePL(N5,$W$86:$W$89,$X$86:$X$89)","v":0},{"$f":"$O$44*ValueE(O5,$Z$86,$Z$87,$Z$88,$Z$89)","v":0},{"$f":"$P$44*ValuePL(P5,$AA$86:$AA$88,$AB$86:$AB$89)","v":0},{"$f":"$Q$44*ValuePL(Q5,$AC$86:$AC$90,$AD$86:$AD$90)","v":0.04},{"$f":"$R$44*ValuePL(R5,$AE$86:$AE$89,$AF$86:$AF$89)","v":0},{"$f":"$S$44*ValuePL(S5,$AG$86:$AG$89,$AH$86:$AH$89)","v":4.0000000000000008E-2},{"$f":"$T$44*ValuePL(T5,$AI$86:$AI$89,$AJ$86:$AJ$89)","v":0.05},{"$f":"$U$44*ValuePL(U5,$AK$86:$AK$91,$AL$86:$AL$91)","v":0},{"$f":"$V$44*ValuePL(V5,$AM$86:$AM$88,$AN$86:$AN$88)","v":0},{"$f":"$W$44*ValuePL(W5,$AO$86:$AO$88,$AP$86:$AP$88)","v":0.05},{"$f":"$X$44*ValuePL(X5,$AQ$86:$AQ$89,$AR$86:$AR$89)","v":0.04},{"$f":"$Y$44*ValuePL(Y5,$AS$86:$AS$89,$AT$86:$AT$89)","v":0.04},{"$f":"$Z$44*ValuePL(Z5,$AU$86:$AU$89,$AV$86:$AV$89)","v":0.05},{"$f":"$AA$44*ValuePL(AA5,$AW$86:$AW$88,$AX$86:$AX$88)","v":0.05},{"$f":"$AB$44*ValuePL(AB5,$AY$86:$AY$89,$AZ$86:$AZ$89)","v":0.04},{"$f":"$AC$44*ValuePL(AC5,$BA$86:$BA$88,$BB$86:$BB$88)","v":0.04},{"$f":"$AD$44*ValuePL(AD5,$BC$86:$BC$88,$BD$86:$BD$88)","v":0.03}]
["Project 2",{"$f":"SUM(C48:AD48)","v":0.53424877401727988},1.3535671425672068E-2,2.8213102591607857E-2,1.4999999999999999E-2,0,0,0,null,0,0,0,0,0,1.4999999999999999E-2,2.2499999999999999E-2,0,0,0.05,0.05,0,0,{"$f":"$W$44*ValuePL(W6,$AO$86:$AO$88,$AP$86:$AP$88)","v":0.05},0.04,{"$f":"$Y$44*ValuePL(Y6,$AS$86:$AS$89,$AT$86:$AT$89)","v":0.04},0.05,0.05,0.04,0.04,0.03]
["Project 3",0.45890624332907692,2.3943140737469053E-2,2.8213102591607857E-2,0.03,0,0,0,null,0,0,0,0,0,1.8749999999999999E-2,2.2499999999999999E-2,0,0.02,0,0,0,7.4999999999999997E-3,0.05,0.04,0.04,0.05,0.05,8.0000000000000002E-3,0.04,0.03]
["Project 4",0.37738087579326757,5.4380856471439951E-3,1.3942790146123618E-2,0.03,0,0,0,null,0,0,0,0,0,1.4999999999999999E-2,2.2499999999999999E-2,0,4.0000000000000001E-3,0.05,0.05,2.4E-2,0,2.5000000000000001E-2,0.04,0.04,1.0000000000000002E-2,0,0,0.04,7.4999999999999997E-3]
["Project 5",0.37358983775406607,1.6520156106900608E-2,7.9969543744382362E-3,0.03,0,0,0,null,1.5272727272727275E-2,8.0000000000000004E-4,0,0,0,0,0,0,4.0000000000000001E-3,0.05,0.05,2.4E-2,7.4999999999999997E-3,0,0.04,0.04,4.0000000000000008E-2,0,0,0.04,7.4999999999999997E-3]
["Project 6",0.21762541381415162,2.5939980805710805E-2,1.8543300844080441E-4,0.03,0,0,0,null,1.1999999999999999E-3,8.0000000000000004E-4,0,0,0,0,0,0,4.0000000000000001E-3,0,0.05,1.7999999999999999E-2,0,0,0,0.04,0,0,0,0.04,7.4999999999999997E-3]
["Project 7",0.55883167443779502,2.9999132478518691E-2,2.542345105018548E-2,0,0.03,0,0,null,0.03,1.3454545454545455E-2,0.02,0.02,1.3454545454545455E-2,0.03,2.2499999999999999E-2,0,0,0.05,0.05,0,0,0.05,0,8.0000000000000002E-3,0.05,0.05,3.5999999999999997E-2,0,0.03]
["Project 8",0.52659366793040296,1.3535671425672068E-2,2.542345105018548E-2,0.03,1.4999999999999999E-2,0.04,0,null,1.6800000000000003E-3,1.6727272727272726E-2,0,0.02,1.6727272727272726E-2,0,0,0,0.04,1.0000000000000002E-2,0.05,0,0,0.05,0.04,0.04,0.05,0.05,0,0.01,7.4999999999999997E-3]
["Project 9",0.45837563615750632,2.5041071294184137E-2,2.3696993705826886E-2,0.03,1.4999999999999999E-2,0,7.6375711574952557E-3,null,0,0,0,0,0,0,0,0.03,0,0.05,3.3000000000000002E-2,6.0000000000000001E-3,0,0.05,0.04,0.04,1.0000000000000002E-2,0.05,8.0000000000000002E-3,0.01,0.03]
["Project 10",0.42049999999999998,0,0,0,0,0,0,null,0,0,0,0,0,2.2499999999999999E-2,0.09,0.01,0.02,0.05,3.3000000000000002E-2,1.2E-2,0,0,0.03,0.04,0.05,2.5000000000000001E-2,8.0000000000000002E-3,0,0.03]
["Project 11",0.48800366568914949,0,0,0,0,0,1.9354838709677417E-3,null,1.6254545454545456E-2,1.8363636363636363E-2,1.0836363636363637E-2,0.02,1.8363636363636363E-2,1.125E-2,2.2499999999999999E-2,0.01,0,0.05,0.05,1.2E-2,0.03,0.05,8.0000000000000002E-3,0.04,0.05,2.5000000000000001E-2,3.5999999999999997E-2,0,7.4999999999999997E-3]
["Project 12",0.38158740731015961,9.8904136043327599E-3,2.3696993705826886E-2,0.03,1.4999999999999999E-2,0,0,null,0,0,0,0,0,0,0,0,4.0000000000000001E-3,0.05,0.05,1.7999999999999999E-2,0,2.5000000000000001E-2,8.0000000000000002E-3,0.04,1.0000000000000002E-2,0.05,8.0000000000000002E-3,0.04,0]
["Project 13",0.30547532344316031,0,0,0,0,0,1.7077798861480075E-4,null,9.8727272727272726E-3,8.0000000000000004E-4,6.5818181818181817E-3,0.02,8.0000000000000004E-4,2.6249999999999999E-2,2.2499999999999999E-2,0.01,0,0.05,0.05,0,0,2.5000000000000001E-2,0,8.0000000000000002E-3,0,0.05,8.0000000000000002E-3,0.01,7.4999999999999997E-3]
["Project 14",0.4311611991122532,2.0964205406426323E-2,2.3696993705826886E-2,1.4999999999999999E-2,1.4999999999999999E-2,0,0,null,0,0,0,0,0,2.2499999999999999E-2,2.2499999999999999E-2,0.01,0,0.05,0.05,0,0,2.5000000000000001E-2,8.0000000000000002E-3,0.04,0.05,2.5000000000000001E-2,3.5999999999999997E-2,0.01,7.4999999999999997E-3]
["Project 15",0.60971431784243146,2.9698489925153143E-2,2.1405827917278249E-2,0.03,1.4999999999999999E-2,0.04,0,null,2.7600000000000003E-3,1.2000000000000003E-3,1.2000000000000003E-3,0.02,1.2000000000000003E-3,3.7499999999999999E-3,0.09,0.02,0,4.0000000000000008E-2,0.05,1.7999999999999999E-2,0.03,0,0.04,8.0000000000000002E-3,1.0000000000000002E-2,0.05,0.04,0.04,7.4999999999999997E-3]
["Project 16",0.54339393939393943,0,0,0,0,0,0,null,0.03,1.8363636363636363E-2,0.02,1.6666666666666666E-2,1.8363636363636363E-2,0,0,0.03,0,0.05,0.05,0.03,0,0.05,0.03,0.03,1.0000000000000002E-2,0.05,0.04,0.04,0.03]
["Project 17",0.40209196138985603,9.8904136043327599E-3,2.3696993705826886E-2,0.03,1.4999999999999999E-2,0.04,8.8045540796963927E-3,null,0,0,0,0.02,1.2000000000000003E-3,0,0,0,0,0.05,3.3000000000000002E-2,0,0,0.05,0.04,8.0000000000000002E-3,0,2.5000000000000001E-2,0,0.04,7.4999999999999997E-3]
["Project 18",0.43942694497153706,0,0,0,0,0,4.2694497153700185E-4,null,0,0,0,0,0,0.03,2.2499999999999999E-2,0.01,0.04,0.05,0.05,0.03,7.4999999999999997E-3,0.05,0.03,8.0000000000000002E-3,4.0000000000000008E-2,2.5000000000000001E-2,3.5999999999999997E-2,0.01,0]
["Project 19",0.41549503742461386,2.3943140737469053E-2,8.0518966871447988E-3,1.4999999999999999E-2,0.03,0,0,null,0,0,0,0,0,0.03,0.09,0,0,4.0000000000000008E-2,0.05,0,0,2.5000000000000001E-2,8.0000000000000002E-3,0.04,4.0000000000000008E-2,0,8.0000000000000002E-3,0,7.4999999999999997E-3]
["Project 20",0.55885300951154004,2.5041071294184137E-2,2.3696993705826886E-2,1.4999999999999999E-2,0.03,0,6.1907020872865271E-3,null,2.8036363636363634E-2,1.0181818181818183E-2,1.8690909090909088E-2,1.3333333333333332E-2,1.0181818181818183E-2,0.03,0.09,0.01,0,0.05,0.05,1.7999999999999999E-2,0.03,2.5000000000000001E-2,0,0,1.0000000000000002E-2,0.05,8.0000000000000002E-3,0,7.4999999999999997E-3]
["Project 21",0.42149999999999999,0,0,0,0,0,0,null,0,0,0,0,0,0.03,0.09,0,4.0000000000000001E-3,0.05,0.05,0.03,7.4999999999999997E-3,0,0.03,0.04,1.0000000000000002E-2,0,0.04,0.01,0.03]
["Project 22",0.44445113851992418,0,0,0,0,0,2.2011385199240986E-3,null,0,0,0,0,0,3.7499999999999999E-3,0.09,0.04,0.02,4.0000000000000008E-2,0.05,0.03,0,2.5000000000000001E-2,0.03,8.0000000000000002E-3,0,0.05,8.0000000000000002E-3,0.04,7.4999999999999997E-3]
["Project 23",0.37896452234436967,2.5041071294184137E-2,2.542345105018548E-2,0.03,0,0,0,null,0,0,0,0,0,0,0,0.03,0,0.05,0.05,0.03,0,0.05,8.0000000000000002E-3,0.03,1.0000000000000002E-2,2.5000000000000001E-2,8.0000000000000002E-3,0,7.4999999999999997E-3]
["Project 24",0.37890643564363613,1.896364549751255E-2,1.3942790146123618E-2,0.03,0,0,0,null,0,0,0,0,0,0,0,0,0,0.05,0.05,0.03,0,0,0.04,8.0000000000000002E-3,0.05,0.05,8.0000000000000002E-3,0,0.03]
["Project 25",0.53254137243924626,2.5041071294184137E-2,2.542345105018548E-2,0.03,0,0,1.8576850094876661E-2,null,0,0,0,0,0,0.03,2.2499999999999999E-2,0.02,0.02,0.05,0.05,0,0,0.05,8.0000000000000002E-3,0.04,4.0000000000000008E-2,2.5000000000000001E-2,8.0000000000000002E-3,0.04,0.03]
["Project 26",0.42942229688880618,2.8998845838620748E-2,2.542345105018548E-2,0.03,1.4999999999999999E-2,0,0,null,0,0,0,0,0,0,0,0.03,0,0.05,0.05,2.4E-2,0,0.05,8.0000000000000002E-3,0,4.0000000000000008E-2,0,8.0000000000000002E-3,0.04,0.03]
["Project 27",0.34094279014612355,0,1.3942790146123618E-2,0.03,0,0,0,null,0,0,0.02,0,2E-3,0,0,0.02,0.02,0.05,0.05,0.03,0,2.5000000000000001E-2,0.03,0.04,1.0000000000000002E-2,0,0,0,0]
["Project 28",0.49364512823846229,1.3535671425672068E-2,1.3942790146123618E-2,0.03,0,0.04,0,null,0,0,0,6.6666666666666662E-3,2E-3,0,0,0.04,0,0.05,0.05,2.4E-2,0,0.05,0.04,0.04,1.0000000000000002E-2,0,3.5999999999999997E-2,0.04,7.4999999999999997E-3]
["Project 29",0.4451559901205534,2.5041071294184137E-2,2.1405827917278249E-2,0.03,1.4999999999999999E-2,0,0,null,1.8E-3,1.3454545454545455E-2,0,0.02,1.3454545454545455E-2,0,0,0.01,0,0.05,0.05,2.4E-2,0,0.05,8.0000000000000002E-3,0,4.0000000000000008E-2,2.5000000000000001E-2,8.0000000000000002E-3,0.01,0.03]
["Project 30",0.28334935206828327,2.9959234351431094E-2,2.542345105018548E-2,0.03,0,0,0,null,0,0,0,6.6666666666666662E-3,8.0000000000000004E-4,0,0,0,0,1.0000000000000002E-2,1.6500000000000001E-2,0,0,0,0.04,8.0000000000000002E-3,4.0000000000000008E-2,0,3.5999999999999997E-2,0.04,0]
["Project 31",0.35694663746011634,1.6520156106900608E-2,2.542345105018548E-2,1.4999999999999999E-2,0,0,0,null,2.2636363636363635E-2,1.6000000000000001E-3,0,6.6666666666666662E-3,1.6000000000000001E-3,0,0,0.02,0,0.05,3.3000000000000002E-2,1.7999999999999999E-2,0,2.5000000000000001E-2,0,8.0000000000000002E-3,1.0000000000000002E-2,0.05,3.5999999999999997E-2,0.01,7.4999999999999997E-3]
["Project 32",0.49072375332835239,1.896364549751255E-2,8.0518966871447988E-3,0.03,0.03,0.04,1.9354838709677417E-3,null,1.0363636363636363E-2,0.02,6.909090909090909E-3,0.02,0.02,0,0,0.02,0.04,0.05,0,2.4E-2,0,0,0.03,8.0000000000000002E-3,4.0000000000000008E-2,2.5000000000000001E-2,0,0.04,7.4999999999999997E-3]
["Project 33",0.40659919186173665,2.8175740811551258E-2,2.542345105018548E-2,0.03,1.4999999999999999E-2,0,0,null,0,0,0,0.01,0,0,0,0.02,0,0.05,3.3000000000000002E-2,0,0,2.5000000000000001E-2,0.04,0,4.0000000000000008E-2,0.05,0.04,0,0]
["Project 34",0.47689805071588748,0,0,0,0,0,1.7077798861480075E-4,null,0.03,1.8363636363636363E-2,0.02,0.02,1.8363636363636363E-2,0,0,0.02,0,0.05,0.05,2.4E-2,0,0.05,0.04,0.04,0,0.05,3.5999999999999997E-2,0.01,0]
["Project 35",0.45305846901133295,2.3943140737469053E-2,1.8281994940530583E-2,1.4999999999999999E-2,1.4999999999999999E-2,0.04,0,null,0,0,0.02,1.3333333333333332E-2,2E-3,0.03,0,0,0,0.05,0.05,1.7999999999999999E-2,0,0.05,0.03,0,1.0000000000000002E-2,0.05,0,0.01,7.4999999999999997E-3]
[]
["Utility Functions"]
["metric 1",null,"metric 2",null,"metric 3",null,"metric 4",null,"metric 5",null,"metric 6a",null,"metric 6b",null,"metric 7",null,"metric 8",null,"metric 9",null,"metric 10",null,"metric 11",null,"metric 12",null,"metric 13",null,"metric 14",null,"metric 15",null,"metric 16",null,"metric 17",null,"metric 18",null,"metric 19",null,"metric 20",null,"metric 21",null,"metric 22",null,"metric 23",null,"metric 24",null,"metric 25",null,"metric 26",null,"metric 27"]
["Taxa (x)","f(x)","Spatial (x)","f(x)","Uncert (x)","y","Freq (x)","y","ARM (x)","y","Trend (x)","f(x)","SumCS (x)","f(x)","PopSpatial (x)","y","Poptime (x)","y","HabSpat (x)","y","HabQual (x)","f(x)","HabTime (x)","y","EPTaxa (x)","f(x)","EPUncert (x)","y","Share (x)","y","Impacts (x)","y","ExPriorities (x)","y","Partners (x)","y","Leverage (x)","y","Alignment (x)","y","Objectives (x)","y","Response (x)","y","Taxa (x)","y","Design (x)","y","Stats (x)","y","Data Plan (x)","y","Budget (x)","y","Timeline (x)","y"]
["Low",0,"Low",0,0,0,0,0,0,0,"Low",0,"Low",0,0,0,0,0,0,0,"Low",2,0,0,"Low",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["High",67,"High",100,1,0.5,1,0.5,1,1,"High",186,"High",1054,25,0.1,5,0.1,20,0,"High",8,5,0.1,"High",8,1,0.25,1,0.25,1,0.1,1,0.2,1,0.33,1,0.2,1,0.25,1,0.5,1,0.2,1,0.2,1,0.2,1,0.5,1,0.2,1,0.25,1,0.25]
["Mono","increasing","Mono","increasing",2,1,2,1,null,null,"Mono","increasing","Mono","increasing",80,1,16,1,25,0.1,"Mono","increasing",16,1,"Mono","increasing",2,1,2,0.5,2,0.5,2,0.8,2,0.66,2,0.4,2,1,2,1,2,0.75,2,0.75,2,0.8,2,1,2,0.9,2,1,2,1]
["Rho",5,"Rho",10,null,null,null,null,null,null,"Rho","infinity","Rho","infinity",100,1,20,1,80,1,"Rho","infinity",20,1,"Rho","infinity",null,null,3,0.75,3,1,3,1,3,1,3,0.6,null,null,null,null,3,1,3,1,3,1,null,null,3,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,1,null,null,null,null,null,null,null,null,4,1,null,null,null,null,null,null,4,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1]

{"sheet":"Step 2 Instructions","index":2,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,0,5,7],[1,9,5,14],[47,9,51,14],[18,9,22,14],[31,9,33,14],[7,0,11,7],[18,0,22,7],[8,9,10,14]]}
[]
["Step 1 - Fill in the cost, and any constraints in the table from row 5 down to a maximum of row 101 (unused rows are not a problem, leave blank)",null,null,null,null,null,null,null,null,"Step 1B - How to Code Constraints - If you are coding a 'does a proposal do X' constraint, it should be a 0 or a 1 (e.g. Does the project take place in Texas, 1 for yes, 0 for no)."]
[]
[]
[]
[]
[]
["Step 2 - Set your constraints (Gray Boxes). These can be maximums or minimums or equalities when we code them, but here it is just the numeric value. You will not set a constraint for Benefit (utility), as Solver will always maximize benefit."]
[null,null,null,null,null,null,null,null,null,"Step 3 - Open up Solver. -> Data Tab at the Top -> All the way over on the right -> Click on \"Solver\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 4 - See Below Image. These are the minimum settings. This will maximize benefits (C3) by turning projects on and off (the P column). It will turn them on and off with 1s or 0s (P= binary). An additional constraint indicates that total cost of the selected projects (B3) must be less than or equal to the available budget (B4).",null,null,null,null,null,null,null,null,"Step 5 - Add additional Constraints. Do this by pressing the add button, Then select the cell in row 4 with the constraint, then selecting the appropraite equality, either >=, = or <=, then select the cell in row 3 with the total. Click ok. Repeat for all constraints"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Step 6 - Click \"Solve\" Excel will then find the optimal solution. This make take several minutes. Be patient. This window will pop up at the end. Click OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"How to interpret results. Selected projects will have 1s in Column P and their information will show up in columns Q,R and S. The actual total cost will be in B3, and the benefit (utility) in C3. "]

{"sheet":"Step 2 Portfolio Analysis","index":3,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,11,3,11],[0,12,3,12],[0,14,0,27],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,8],[0,9,3,9],[0,10,3,10]]}
["Proposal Name","Cost","Monitoring Benefit","Constraints",null,null,null,null,null,"Included in Portfolio","Proposal Name","Cost","Monitoring Benefit",null,"DO NOT CHANGE ANY VALUES EXCEPT IN CELLS COLORED IN GREY"]
[null,null,null,"TX","LA","MS","AL","FL","sea"]
["Total",{"$f":"SUMPRODUCT(J5:J101,B5:B101)","v":3985000},{"$f":"SUMPRODUCT(C5:C101,J5:J101)","v":4.4047190421847136},{"$f":"SUMPRODUCT(D5:D101,$J$5:$J$101)","v":9},{"$f":"SUMPRODUCT(E5:E101,$J$5:$J$101)","v":9},10,11,11,2]
["Portfolio Constraints",4000000,"~~~",0,0,0,0,11,2]
[{"$f":"'Step 1 Project Scores'!A5","v":"Project 1"},700000,{"$f":"'Step 1 Project Scores'!B47","v":0.62852931598576234},1,1,1,1,1,0,0,{"$f":"IF($J5=1,A5,\"\")","v":""},"",""]
[{"$f":"'Step 1 Project Scores'!A6","v":"Project 2"},5400000,{"$f":"'Step 1 Project Scores'!B48","v":0.53424877401727988},0,0,1,1,0,1,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A7","v":"Project 3"},250000,{"$f":"'Step 1 Project Scores'!B49","v":0.45890624332907692},0,1,0,0,0,1,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A8","v":"Project 4"},150000,{"$f":"'Step 1 Project Scores'!B50","v":0.37738087579326757},0,1,0,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A9","v":"Project 5"},220000,{"$f":"'Step 1 Project Scores'!B51","v":0.37358983775406607},1,1,1,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A10","v":"Project 6"},110000,{"$f":"'Step 1 Project Scores'!B52","v":0.21762541381415162},0,0,0,1,1,0,1,"Project 6",110000,0.21762541381415162]
[{"$f":"'Step 1 Project Scores'!A11","v":"Project 7"},1000000,{"$f":"'Step 1 Project Scores'!B53","v":0.55883167443779502},1,1,1,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A12","v":"Project 8"},5000000,{"$f":"'Step 1 Project Scores'!B54","v":0.52659366793040296},1,1,1,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A13","v":"Project 9"},25000,{"$f":"'Step 1 Project Scores'!B55","v":0.45837563615750632},1,1,1,1,1,0,1,"Project 9",25000,0.45837563615750632]
[{"$f":"'Step 1 Project Scores'!A14","v":"Project 10"},900000,{"$f":"'Step 1 Project Scores'!B56","v":0.42049999999999998},0,0,0,1,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A15","v":"Project 11"},1500000,{"$f":"'Step 1 Project Scores'!B57","v":0.48800366568914949},1,1,1,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A16","v":"Project 12"},100000,{"$f":"'Step 1 Project Scores'!B58","v":0.38158740731015961},1,0,0,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A17","v":"Project 13"},250000,{"$f":"'Step 1 Project Scores'!B59","v":0.30547532344316031},1,1,1,1,1,0,1,"Project 13",250000,0.30547532344316031]
[{"$f":"'Step 1 Project Scores'!A18","v":"Project 14"},500000,{"$f":"'Step 1 Project Scores'!B60","v":0.4311611991122532},0,1,0,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A19","v":"Project 15"},800000,{"$f":"'Step 1 Project Scores'!B61","v":0.60971431784243146},0,1,1,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A20","v":"Project 16"},2000000,{"$f":"'Step 1 Project Scores'!B62","v":0.54339393939393943},0,0,0,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A21","v":"Project 17"},500000,{"$f":"'Step 1 Project Scores'!B63","v":0.40209196138985603},0,0,1,1,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A22","v":"Project 18"},300000,{"$f":"'Step 1 Project Scores'!B64","v":0.43942694497153706},1,1,1,1,1,0,1,"Project 18",300000,0.43942694497153706]
[{"$f":"'Step 1 Project Scores'!A23","v":"Project 19"},750000,{"$f":"'Step 1 Project Scores'!B65","v":0.41549503742461386},1,1,1,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A24","v":"Project 20"},1500000,{"$f":"'Step 1 Project Scores'!B66","v":0.55885300951154004},1,1,1,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A25","v":"Project 21"},900000,{"$f":"'Step 1 Project Scores'!B67","v":0.42149999999999999},1,1,1,1,1,1,1,"Project 21",900000,0.42149999999999999]
[{"$f":"'Step 1 Project Scores'!A26","v":"Project 22"},750000,{"$f":"'Step 1 Project Scores'!B68","v":0.44445113851992418},1,1,1,1,1,1,1,"Project 22",750000,0.44445113851992418]
[{"$f":"'Step 1 Project Scores'!A27","v":"Project 23"},1000000,{"$f":"'Step 1 Project Scores'!B69","v":0.37896452234436967},1,1,1,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A28","v":"Project 24"},150000,{"$f":"'Step 1 Project Scores'!B70","v":0.37890643564363613},1,1,1,1,1,0,1,"Project 24",150000,0.37890643564363613]
[{"$f":"'Step 1 Project Scores'!A29","v":"Project 25"},250000,{"$f":"'Step 1 Project Scores'!B71","v":0.53254137243924626},1,1,1,1,1,0,1,"Project 25",250000,0.53254137243924626]
[{"$f":"'Step 1 Project Scores'!A30","v":"Project 26"},500000,{"$f":"'Step 1 Project Scores'!B72","v":0.42942229688880618},1,1,1,1,1,0,1,"Project 26",500000,0.42942229688880618]
[{"$f":"'Step 1 Project Scores'!A31","v":"Project 27"},1200000,{"$f":"'Step 1 Project Scores'!B73","v":0.34094279014612355},1,1,1,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A32","v":"Project 28"},500000,{"$f":"'Step 1 Project Scores'!B74","v":0.49364512823846229},0,0,1,1,1,0,1,"Project 28",500000,0.49364512823846229]
[{"$f":"'Step 1 Project Scores'!A33","v":"Project 29"},2000000,{"$f":"'Step 1 Project Scores'!B75","v":0.4451559901205534},1,1,1,1,1,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A34","v":"Project 30"},250000,{"$f":"'Step 1 Project Scores'!B76","v":0.28334935206828327},1,1,1,1,1,0,1,"Project 30",250000,0.28334935206828327]
[{"$f":"'Step 1 Project Scores'!A35","v":"Project 31"},650000,{"$f":"'Step 1 Project Scores'!B77","v":0.35694663746011634},0,0,1,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A36","v":"Project 32"},200000,{"$f":"'Step 1 Project Scores'!B78","v":0.49072375332835239},0,1,0,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A37","v":"Project 33"},400000,{"$f":"'Step 1 Project Scores'!B79","v":0.40659919186173665},0,0,1,0,0,1,0,{"$f":"IF($J37=1,A37,\"\")","v":""},"",""]
[{"$f":"'Step 1 Project Scores'!A38","v":"Project 34"},900000,{"$f":"'Step 1 Project Scores'!B80","v":0.47689805071588748},0,1,0,0,0,0,0,"","",""]
[{"$f":"'Step 1 Project Scores'!A39","v":"Project 35"},900000,{"$f":"'Step 1 Project Scores'!B81","v":0.45305846901133295},0,0,1,0,1,0,0,"","",""]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF($J69=1,A69,\"\")","v":""},"",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]
[null,null,null,null,null,null,null,null,null,0,"","",""]