{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data & Calculations","Survival Allocation","Interactive Calculations","Stan sex ratio + fecundity"],"not_rendered":{"charts":1,"images":0,"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":"Data & Calculations","index":0,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Year","Water Year Index","Oakdale RST Expanded Passage","Caswell RST Expanded Passage","Adult Production","Ocean Harvest","Freshwater Harvest","Totatl Harvest",{"$f":"CONCATENATE(\"Grandtab Escapement\", \" (geomean=\", ROUND(GEOMEAN(I2:I37),0),\")\")","v":"Grandtab Escapement (geomean=2054)"},{"$f":"CONCATENATE(\"Weir Escapement\", \" (geomean=\", ROUND(GEOMEAN(J2:J37),0),\")\")","v":"Weir Escapement (geomean=2008)"},"Median % females","Median fecundity",{"$f":"CONCATENATE(\"Ocean Production : Spawning Escapement\", \" (geomean=\", ROUND(GEOMEAN(M2:M37),3),\")\")","v":"Ocean Production : Spawning Escapement (geomean=0.602)"},"Estimated Egg Deposition",{"$f":"CONCATENATE(\"Oakdale to Caswell\", \" (geoman=\", ROUND(GEOMEAN(O2:O37),3),\")\")","v":"Oakdale to Caswell (geoman=0.16)"},{"$f":"CONCATENATE(\"Eggs to Oakdale RST\", \" (geomean=\", ROUND(GEOMEAN(P2:P37),2),\")\")","v":"Eggs to Oakdale RST (geomean=0.11)"},{"$f":"CONCATENATE(\"Eggs to Caswell RST\", \" (geomean=\", ROUND(GEOMEAN(Q2:Q37),3),\")\")","v":"Eggs to Caswell RST (geomean=0.019)"},{"$f":"CONCATENATE(\"Calculated Caswell to Vernalis\", \" (geomean=\", ROUND(GEOMEAN(R2:R37),2),\")\")","v":"Calculated Caswell to Vernalis (geomean=0.54)"},{"$f":"CONCATENATE(\"Eggs to Vernalis\", \" (geomean=\", ROUND(GEOMEAN(S2:S37),3),\")\")","v":"Eggs to Vernalis (geomean=0.009)"}]
[1995,"Wet",null,null,2241,1591.6889000000001,30.95,1622.6389000000001,619,null,0.6,5813,{"$f":"I2/E2","v":0.27621597501115575},{"$f":"PRODUCT(I2,K2,L2)","v":2158948.1999999997},{"$f":"IF(C2>0,D2/C2,\".\")","v":"."},{"$f":"IF(C2>0,C2/N2,\".\")","v":"."},{"$f":"IF(D2>0,D2/N2,\".\")","v":"."},{"$f":"IF(C2>0, (O2^(1/32.1) + 3.75^(1/54.5))/2, \".\")","v":"."},{"$f":"IF(C2>0, Q2*R2, \".\")","v":"."}]
[1996,"Wet",245892,70885,365,188.7653,8.4,197.1653,168,null,{"$f":"K2","v":0.6},{"$f":"L2","v":5813},{"$f":"I3/E3","v":0.46027397260273972},{"$f":"PRODUCT(I3,K3,L3)","v":585950.4},{"$f":"IF(C3>0,D3/C3,\".\")","v":0.28827696712377793},{"$f":"IF(C3>0,C3/N2,\".\")","v":0.11389434910944136},{"$f":"IF(D3>0,D3/N2,\".\")","v":3.2833117533806515E-2},{"$f":"IF(C3>0, ((O3^(1/32.1) +  0.0375^(1/54.5))/2)^10.5, \".\")","v":0.59504610711758554},1.9537218773025708E-2]
[1997,"Wet",null,98287,14424,8422.3384000000005,279.39999999999998,8701.7384000000002,5588,null,{"$f":"K3","v":0.6},{"$f":"L3","v":5813},0.38740987243483083,19489826.399999999,".",{"$f":"IF(C4>0,C4/N3,\".\")","v":"."},{"$f":"IF(D4>0,D4/N3,\".\")","v":0.16773945371485369},{"$f":"IF(C4>0, ((O4^(1/32.1) +  0.0375^(1/54.5))/2)^10.5, \".\")","v":"."},"."]
[1998,"Wet",954312,1152154,6145,2840.8425000000002,154.35,2995.1925000000001,3087,null,0.6,5813,0.50235964198535399,{"$f":"PRODUCT(I5,K5,L5)","v":10766838.6},1.207313750639204,4.896462289679502E-2,{"$f":"IF(D5>0,D5/N4,\".\")","v":5.9115662518163838E-2},{"$f":"IF(C5>0, ((O5^(1/32.1) +  0.0375^(1/54.5))/2)^10.5, \".\")","v":0.7559777842018317},4.4690127562104776E-2]
[1999,"Above",3889456,1457859,7577,2980.4825000000001,217.45,3197.9324999999999,4349,null,0.6,5813,0.57397386828560115,15168442.200000001,0.37482336861504539,0.36124401456152599,0.13540269842997368,0.62149374779453781,8.4151930508737927E-2]
[2000,"Above",2818845,2060282,17671,8636.4462000000003,424.9,9061.3462,8498,null,0.6,5813,{"$f":"I7/E7","v":0.48090091109727801},29639324.400000002,0.73089581016338256,0.18583615659622579,0.13582686823304768,{"$f":"IF(C7>0, ((O7^(1/32.1) +  0.0375^(1/54.5))/2)^10.5, \".\")","v":0.69473918205428908},9.4364247337223248E-2]
[2001,"Dry",1119203,178557,9503,2119.6158999999998,351.65,2471.2658999999999,7033,null,0.6,5813,{"$f":"I8/E8","v":0.74008207934336523},{"$f":"PRODUCT(I8,K8,L8)","v":24529697.400000002},0.15953942224958295,3.7760745990553006E-2,6.024327599046083E-3,0.53984532676969932,3.2522051012747509E-3]
[2002,"Dry",993796,78505,11527,3351.3517000000002,389.35,3740.7017000000001,7787,null,0.6,5813,{"$f":"I9/E9","v":0.67554437407825108},27159498.599999998,7.8995085510507185E-2,4.0513993458394633E-2,3.2004063776180131E-3,0.4814366059710764,1.5407927841686033E-3]
[2003,"Below",1742219,119654,8753,2527.0030000000002,295.10000000000002,2822.1030000000001,5902,4848,0.6,5813,0.67428310293613614,20584995.599999998,6.867908110289235E-2,6.4147686437775409E-2,4.4056041594228842E-3,0.47065599235546085,2.0735239975785236E-3]
[2004,"Dry",2467746,327083,8623,4410.5752000000002,200.75,4611.3252000000002,4015,4408,0.6,5813,{"$f":"I11/E11","v":0.46561521512234721},14003517,0.1325432196020174,0.1198808126050802,1.5889388871183439E-2,0.52372169257776457,8.3216176336424873E-3]
[2005,"Wet",1304977,266763,2532,1033.9948999999999,71.349999999999994,1105.3448999999998,1427,4121,0.6,5813,0.56358609794628756,4977090.5999999996,0.20441969475324087,9.3189232390691573E-2,1.9049714439593995E-2,0.56226029291914825,1.0710898020832247E-2]
[2006,"Wet",4414407,156185,2671,652.1748,96.15,748.32479999999998,1923,3056,0.6,5813,0.71995507300636463,6707039.3999999994,3.5380743098676677E-2,0.88694527682497892,3.1380782981929242E-2,0.42303952054100213,1.3275311386876586E-2]
[2007,"Critical",867739,69959,824,376.92910000000001,22.15,399.07909999999998,443,408,0.6,5813,0.53762135922330101,1545095.4000000001,8.0622168647485018E-2,0.1293773523978404,1.0430682724183789E-2,0.48302972121964882,5.0383297683931029E-3]
[2008,"Critical",134216,17833,865,null,null,null,865,923,0.6,5813,1,3016947,0.13286791440662812,8.6865833656614336E-2,1.1541682151147429E-2,0.52393103042652456,6.047045422306099E-3]
[2009,"Below",160541,8704,595,null,null,null,595,1303,0.6,5813,1,2075241,5.4216679851252954E-2,5.3213066056513422E-2,2.8850357662895637E-3,0.45303724221235947,1.3070286472438451E-3]
[2010,"Above",null,26242,1222,248.84729999999999,null,248.84729999999999,1086,1363,0.6,5813,0.88870703764320791,3787750.8000000003,{"$f":"IF(C17>0,D17/C17,\".\")","v":"."},".",1.2645278307435136E-2,".","."]
[2011,"Wet",null,31113,1669,null,null,null,1309,818,0.6,5813,0.78430197723187534,4565530.2,".",".",8.2141095449045909E-3,".","."]
[2012,"Dry",null,105821,6665,null,null,null,4006,7248,0.6,5813,0.60105026256564142,13972126.799999999,".",".",2.317824992155347E-2,".","."]
[2013,null,null,null,4238,null,null,null,2845,null,0.6,5813,0.67130722038697499,9922791,".",".",".",".","."]
[2014,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]

{"sheet":"Survival Allocation","index":1,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,7,12,13],[13,7,14,13],[21,8,22,13],[30,8,31,13]]}
["Table 1. Calculated recruits per spawner based on consensus estimates",null,null,null,null,null,null,"Table 5. Reach-specific calculations for pre-marine entry survival"]
["Reach","USDOI (2011)","NMFS (2012)","Consensus Estimate","RM","Survival/RM",null,"Current7","Current Weighting of Survival Upstream vs. Downstream of Oakdale","Reach","River miles","Objective A","Objective B","Objective C"]
["Eggs to Caswell",6.6400000000000001E-2,5.6399999999999999E-2,{"$f":"GEOMEAN('Data & Calculations'!Q2:Q20)","v":1.8662138918200021E-2},46.5,{"$f":"D3^(1/46.5)","v":0.91794439545344186},null,{"$f":"$D$4","v":0.10616729642582408},{"$f":"H3/H4","v":0.66252392435839469},"Eggs to Oakdale",14.4,{"$f":"SQRT($L$5)*I3","v":0.1875025267440977},{"$f":"SQRT($M$5)*I3","v":0.21636215576155202},{"$f":"SQRT($N$5)*I3","v":0.32711912548213401}]
["Eggs to Oakdale","-","-",{"$f":"GEOMEAN('Data & Calculations'!P2:P20)","v":0.10616729642582408},14.4,{"$f":"D4^(1/14.4)","v":0.85577672250507564},null,{"$f":"$D$5","v":0.16024673603845965},{"$f":"H4/H3","v":1.5093794551923931},"Oakdale to Caswell ",32.1,{"$f":"SQRT($L$5)*I4","v":0.42717319519937325},{"$f":"SQRT($M$5)*I4","v":0.49292196218254974},{"$f":"SQRT($N$5)*I4","v":0.74525140791163547}]
["Oakdale to Caswell","-","-",{"$f":"GEOMEAN('Data & Calculations'!O2:O20)","v":0.16024673603845965},{"$f":"32.1","v":32.1},{"$f":"D5^(1/32.1)","v":0.94455462231389742},null,{"$f":"$D$3","v":1.8662138918200021E-2},null,"Eggs to Caswell",{"$f":"K3+K4","v":46.5},{"$f":"E15/L6","v":8.0096053457232128E-2},{"$f":"E24/M6","v":0.10664965836003069},{"$f":"E33/N6","v":0.24378598882038335}]
["Caswell to Vernalis 1","-","-",{"$f":"GEOMEAN('Data & Calculations'!R2:R20)","v":0.54091056698925244},10.5,{"$f":"D6^(1/10.5)","v":0.9431556650827333},null,{"$f":"$D$6","v":0.54091056698925244},null,"Caswell to Vernalis 8",10.5,{"$f":"AVERAGE(F15:F16)^10.5","v":0.68245957669066026},{"$f":"AVERAGE(F24:F25)^10.5","v":0.72196029448680044},{"$f":"AVERAGE(F33:F34)^10.5","v":0.82039169259787126}]
["Vernalis to Chipps Island",0.05,3.7499999999999999E-2,3.7499999999999999E-2,72.5,0.95569999999999999,null,{"$f":"$D$7","v":3.7499999999999999E-2},null,"Vernalis to Chipps Island",72.5,{"$f":"E16","v":0.20306376506440285},{"$f":"E25","v":0.28603367504228666},{"$f":"E34","v":0.5}," "]
["Chipps Island to Adult2","-","-",5.4025999999999998E-2,"-","-",null,{"$f":"PRODUCT(H5:H7)","v":3.7854555538034126E-4},null,"Freshwater Survival",null,{"$f":"PRODUCT(L5:L7)","v":1.1099936249888746E-2},{"$f":"PRODUCT(M5:M7)","v":2.2023683035493548E-2},{"$f":"PRODUCT(N5:N7)","v":0.1}]
["Adult to Spawner",0.5,0.7,{"$f":"GEOMEAN('Data & Calculations'!M2:M20)","v":0.60241485552950713},"-","-",null,"7 Estimated survival rates from Egg-to-Oakdale and Oakdale-to-Caswell were calculated annually only for those years in which sampling data are available from Oakdale RST. The product of  Egg-to-Oakdale and Oakdale-to-Caswell values do not equal the current Egg-to-Caswell survival estimate because time series differ for Oakdale and Caswell data sets. Thus, only the proportional survival from \"Eggs-to-Oakdale\" and \"Oakdale-to-Caswell\"  was used to estimate survival guidance for the reach above Oakdale. The Egg-Oakdale survival guidance target represents the proportional survival above and below Oakdale applied to the respective \"Eggs-to-Caswell\" survival objective listed here. "]
["Recruits per Spawner",null,null,{"$f":"(PRODUCT('Data & Calculations'!$K$2:$L$2))*(PRODUCT('Survival Allocation'!D3,D6:D9))","v":4.2970282805363906E-2}]
["1 Based on average between Oakdale to Caswell and Vernalis to Chipps estimates, adjusted by river miles"]
["2 Geometric mean of the lower 95% confidence bounds for annual estimates calculated by Michel (2018)"]
["Table 2. Calculated survival required to achieve Objective A (1.26 recruits per spawner) 3"]
["Reach","Current","RM","Increase","Target Survival","Target Survival/RM",null,"8 Based on average of per RM survival rates for (1) Eggs to Vernalis and (2) Vernalis to Chipps Island as derived from \"current\" and each objective, respectively."]
["Eggs to Vernalis",{"$f":"D3*D6","v":1.0094548143475768E-2},57,{"$f":"SQRT($E$19/$D$10)","v":5.4150337350507431},{"$f":"PRODUCT(B15,D15)","v":5.4662318737015131E-2},{"$f":"E15^(1/C15)","v":0.95028566130339231}]
["Vernalis to Chipps Island",{"$f":"$D$7","v":3.7499999999999999E-2},72.5,{"$f":"SQRT($E$19/$D$10)","v":5.4150337350507431},{"$f":"PRODUCT(B16,D16)","v":0.20306376506440285},{"$f":"E16^(1/C16)","v":0.97825055404717209}]
["Chipps Island to Adult",{"$f":"$D$8","v":5.4025999999999998E-2},"-","-",{"$f":"$D$8","v":5.4025999999999998E-2},"-"]
["Adult to Spawner",{"$f":"$D$9","v":0.60241485552950713},"-","-",{"$f":"$D$9","v":0.60241485552950713},"-"]
["Recruits per Spawner",null,null,null,1.26]
["3 Population growth rate of two-fold over three generations"]
[]
["Table 3. Calculated survival required to achieve Objective B (2.5 recruits per spawner) 4",null,null,null,null,null,null,null,"Table 6. Actual survival objectives as they appear in the text. Egg-to-Oakdale survival is guidance for attaining Egg-to-Caswell Objective. For Objective A and Objective B, guidance target is less than implied by proportionate increase in survival before and after Oakdale, though it may be exceeded in practice; for Objective C, guidance target represents typical egg-to-fry survival (Quinn 2005)."]
["Reach","Current","RM","Increase","Target Survival","Target Survival/RM"]
["Eggs to Vernalis",{"$f":"$D$3*$D$6","v":1.0094548143475768E-2},57,{"$f":"SQRT($E$28/$D$10)","v":7.627564667794311},{"$f":"PRODUCT(B24,D24)","v":7.6996818756524421E-2},{"$f":"E24^(1/C24)","v":0.95601440191672538},null,null,"Reach","River miles","Current","Objective A","Objective B","Objective C"]
["Vernalis to Chipps Island",{"$f":"$D$7","v":3.7499999999999999E-2},72.5,{"$f":"SQRT($E$28/$D$10)","v":7.627564667794311},{"$f":"PRODUCT(B25,D25)","v":0.28603367504228666},{"$f":"E25^(1/C25)","v":0.98288409127541998},null,null,"Eggs to Oakdale ",14.4,{"$f":"D4","v":0.10616729642582408},0.18,0.21,0.35]
["Chipps Island to Adult",{"$f":"$D$8","v":5.4025999999999998E-2},"-","-",{"$f":"$D$8","v":5.4025999999999998E-2},"-",null,null,"Oakdale to Caswell 9",32.1,{"$f":"D5","v":0.16024673603845965},"xx","yy","zz"]
["Adult to Spawner",{"$f":"$D$9","v":0.60241485552950713},"-","-",{"$f":"$D$9","v":0.60241485552950713},"-"," ",null,"Eggs to Caswell",46.5,{"$f":"D3","v":1.8662138918200021E-2},0.08,0.107,0.24399999999999999]
["Recruits per Spawner",null,null,null,2.5,null," ",null,"Caswell to Vernalis",10.5,{"$f":"D6","v":0.54091056698925244},0.68200000000000005,0.72199999999999998,0.82," "]
["4 Population resilience",null,null,null,null,null,null,null,"Vernalis to Chipps Island",72,{"$f":"D7","v":3.7499999999999999E-2},0.20300000000000001,0.28599999999999998,0.5]
[null,null,null,null,null,null,null,null,"Freshwater Survival",null,{"$f":"K27*K28*K29","v":3.7854555538034126E-4},1.11E-2,2.1999999999999999E-2,0.1]
["Table 4. Calculated survival required to achieve Objective C (10% freshwater survival) 5",null,null,null,null,null,null,null,"9 xx, yy, zz represent the survival needed to achieve overall egg-to-caswell survival objectives \n(e.g., \"Oakdale to Caswell %\" = \"Egg to Caswell %\" / actual \"Egg to Oakdale %\")"]
["Reach","Current","RM","Increase","Target Survival","Target Survival/RM"]
["Eggs to Vernalis",{"$f":"$D$3*$D$6","v":1.0094548143475768E-2},57,{"$f":"SQRT(0.1/($D$3*$D$6*$D$7))","v":16.25327652615756},0.2,{"$f":"E33^(1/C33)","v":0.9721591504929985},null,null,null,null,null," "," "," "]
["Vernalis to Chipps Island 6",{"$f":"$D$7","v":3.7499999999999999E-2},72.5,{"$f":"D33","v":16.25327652615756},0.5,{"$f":"E34^(1/C34)","v":0.99048490695244773},null,null,null,null,null,null," "]
["Chipps Island to Adult",{"$f":"$D$8","v":5.4025999999999998E-2},"-","-",{"$f":"$D$8","v":5.4025999999999998E-2},"-"]
["Adult to Spawner",{"$f":"$D$9","v":0.60241485552950713},"-","-",{"$f":"$D$9","v":0.60241485552950713},"-"," "]
["Recruits per Spawner",null,null,null,{"$f":"(PRODUCT('Data & Calculations'!$K$2:$L$2)*(PRODUCT('Survival Allocation'!E33:E36)))","v":11.351416545411501}]
["5 Based on published values"]
["6 Capped at 50%"]

{"sheet":"Interactive Calculations","index":2,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[19,3,19,5],[29,1,29,7]]}
[null,"Table 7. Estimated recruits per spawner based on interactive values"]
[]
[null,"Reach","Value","Units","RM","S/RM",null,null,null,null,null,null,null,{"$f":"I20*C4*C5*0.01","v":6975600}]
[null,"Proportion of females",60,"%","-","-",null,null,null,null,null,null,"Fry to Oakdale",{"$f":"N3*C6*0.01","v":740808.72}]
[null,"Fecundity",5813,"n","-","-",null,null,null,null,null,null,"Juv to Caswell",118677.556944]
[null,"Eggs to Oakdale",10.62,"%",14.4,{"$f":"(C6/100)^(1/E6)","v":0.85579502626040427},null,null,null,null,null,null,"Juv to Vernalis",64192.690551009611]
[null,"Oakdale to Caswell",16.02,"%",32.1,{"$f":"(C7/100)^(1/E7)","v":0.94454603917549762},null,null,null,null,null,null,"Smolts to Chipps",2407.2258956628607]
[null,"Caswell to Vernalis",54.09,"%",10.5,{"$f":"(C8/100)^(1/E8)","v":0.94315391029852791},null,null,null,null,null,null,"Ocean Production",129.9901983657945]
[null,"Vernalis to Chipps Island",3.75,"%",54.5,{"$f":"(C9/100)^(1/E9)","v":0.9415327610942027},null,null,null,null,null,null,"Spawners",78.306095495554615]
[null,"Chipps Island to Adult",5.4,"%","-","-"]
[null,"Adult to Spawner",60.24,"%","-","-",null,null,60]
[null,"Recruits per Spawner",{"$f":"(C4/100)*(C5)*(C6/100)*(C7/100)*(C8/100)*(C9/100)*(C10/100)*(C11/100)","v":3.9153047747777302E-2}]
[]
[null,"Notes"]
[null,"Objective A: Population growth rate of two-fold over three generations (recruits per spawner of 1.26)"]
[null,"Objective B: Population resilience (recruits per spawner of 2.5)"]
[null,"Objective C: Sustainability (typical survival rate for Chinook salmon in freshwater = 10%) (recruits per spawner of 5.95)"]
[]
[null,"Table 7. Reference performance measures based on objectives"]
[null,null,null,"Objective",null,null,null,"# Spawners",2000]
[null,"Reach","Current","A","B","C"]
[null,"Eggs to Caswell",{"$f":"'Survival Allocation'!D3","v":1.8662138918200021E-2},{"$f":"'Survival Allocation'!L5","v":8.0096053457232128E-2},{"$f":"'Survival Allocation'!M5","v":0.10664965836003069},{"$f":"'Survival Allocation'!N5","v":0.24378598882038335}]
[null,"Eggs to Oakdale",{"$f":"'Survival Allocation'!D4","v":0.10616729642582408},{"$f":"'Survival Allocation'!L25","v":0.18},{"$f":"'Survival Allocation'!M25","v":0.21},{"$f":"'Survival Allocation'!N25","v":0.35}]
[null,"Oakdale to Caswell10",{"$f":"'Survival Allocation'!D5","v":0.16024673603845965},{"$f":"'Survival Allocation'!L26","v":"xx"},{"$f":"'Survival Allocation'!M26","v":"yy"},{"$f":"'Survival Allocation'!N26","v":"zz"}]
[null,"Caswell to Vernalis",{"$f":"'Survival Allocation'!D6","v":0.54091056698925244},{"$f":"'Survival Allocation'!L6","v":0.68245957669066026},{"$f":"'Survival Allocation'!M6","v":0.72196029448680044},{"$f":"'Survival Allocation'!N6","v":0.82039169259787126}]
[null,"Vernalis to Chipps Island",{"$f":"'Survival Allocation'!$D$7","v":3.7499999999999999E-2},{"$f":"'Survival Allocation'!L7","v":0.20306376506440285},{"$f":"'Survival Allocation'!M7","v":0.28603367504228666},{"$f":"'Survival Allocation'!N7","v":0.5}]
[null,"Chipps Island to Adult",{"$f":"'Survival Allocation'!$D$8","v":5.4025999999999998E-2},{"$f":"'Survival Allocation'!$D$8","v":5.4025999999999998E-2},{"$f":"'Survival Allocation'!$D$8","v":5.4025999999999998E-2},{"$f":"'Survival Allocation'!$D$8","v":5.4025999999999998E-2}]
[null,"Adult to Spawner",{"$f":"'Survival Allocation'!$D$9","v":0.60241485552950713},{"$f":"'Survival Allocation'!$D$9","v":0.60241485552950713},{"$f":"'Survival Allocation'!$D$9","v":0.60241485552950713},{"$f":"'Survival Allocation'!$D$9","v":0.60241485552950713}]
[null,"Recruits per Spawner",{"$f":"C22*C25*C26*C27*C28*0.6*5813","v":4.2970282805363913E-2},{"$f":"D22*D25*D26*D27*D28*(0.6)*(5813)","v":1.2600000000000002},{"$f":"E22*E25*E26*E27*E28*(0.6)*(5813)","v":2.5000000000000004},11.351416545411501]
[null,"10 xx, yy, zz represent the survival needed to achieve overall egg-to-caswell survival objectives (e.g., \"Oakdale to Caswell %\" = \"Egg to Caswell %\" / actual \"Egg to Oakdale %\")"]

{"sheet":"Stan sex ratio + fecundity","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,4,6,11]]}
["Stanislaus River Escapement data from Domenic Guidice via Stephen Louie (CDFW)"]
[]
["Year","% females","Eggs per female",null,"“An estimate for the number of eggs produced by the 2005 fall run was generated using a standard regression equation \n(158.45 * fork length cm – 6138.91 =  number of eggs). \nThis fork length-fecundity relationship was determined for 48 San Joaquin \nfall-run chinook salmon females ranging from 62.5 to 94.0 cm fork length (Loudermilk et al. 1990).”"]
[1995,0.47222222222222221,5190.2650000000021]
[1996,0.4375,4545.1471428571413]
[1997,0.54560530679933661,5372.3606153846094]
[1998,"na","na"]
[1999,0.5,5343.0347169811212]
[2000,0.62704309063893016,5938.960023696688]
[2001,0.60676532769556024,6404.726280487821]
[2002,0.59895287958115184,5929.3289860140103]
[2003,0.59305339554173142,5935.8387325175017]
[2004,0.60252935862691959,5540.0665367316424]
[2005,0.67777777777777781,5796.271311475406]
[2006,0.70750988142292492,6090.0662569832357]
[2007,0.375,6026.5288888888872]
[2008,0.62037037037037035,5870.1810447761209]
[2009,0.44565217391304346,5661.6537499999995]
[2010,0.45454545454545453,5728.9949999999999]
[2011,0.51626016260162599,4961.9472834645603]
[2012,0.646095717884131,5830.0879532163854]
[2013,0.62765957446808507,6116.9438606403091]
[]
["Max",{"$f":"MAX(B4:B22)","v":0.70750988142292492},{"$f":"MAX(C4:C22)","v":6404.726280487821}]
["Average",{"$f":"AVERAGE(B4:B22)","v":0.55858570522718143},{"$f":"AVERAGE(C4:C22)","v":5682.3557435619687}]
["Median",{"$f":"MEDIAN(B4:B22)","v":0.59600313756144163},{"$f":"MEDIAN(C4:C22)","v":5813.1796323458957}]
["Min",{"$f":"MIN(B4:B22)","v":0.375},{"$f":"MIN(C2:C22)","v":4545.1471428571413}]