{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ProjectPairing","Map_ManagementReaches"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"ProjectPairing","index":0,"n_rows":59,"n_cols":22,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,13,58,13],[57,4,58,4],[57,3,58,3],[57,2,58,2],[57,1,58,1],[57,0,58,0],[5,5,5,12],[0,5,0,12],[5,13,6,13],[0,0,1,4],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,13,10,13],[7,0,8,0],[7,1,8,4],[35,4,36,4],[35,0,36,0],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[47,2,48,2],[47,3,48,3],[47,4,48,4],[31,2,32,2],[31,1,32,1],[31,0,32,0],[29,0,30,0],[29,1,30,1],[29,2,30,2],[37,3,38,3],[37,4,38,4],[39,4,40,4],[39,3,40,3],[31,3,32,3],[31,4,32,4],[37,0,38,0],[39,0,40,0],[39,2,40,2],[39,1,40,1],[37,1,38,1],[37,2,38,2],[35,2,36,2],[35,1,36,1],[35,3,36,3],[11,13,12,13],[13,13,14,13],[15,13,16,13],[23,4,24,4],[21,4,22,4],[19,4,20,4],[17,4,18,4],[15,4,16,4],[21,0,22,0],[23,0,24,0],[21,1,22,1],[23,1,24,1],[11,3,12,3],[13,3,14,3],[15,3,16,3],[17,3,18,3],[19,3,20,3],[21,3,22,3],[23,3,24,3],[15,2,16,2],[17,2,18,2],[19,2,20,2],[21,2,22,2],[23,2,24,2],[17,13,18,13],[19,13,20,13],[21,13,22,13],[23,13,24,13],[51,13,52,13],[49,0,50,0],[49,1,50,1],[49,13,50,13],[51,0,52,0],[51,1,52,1],[51,2,52,2],[31,13,32,13],[29,13,30,13],[27,13,28,13],[25,13,26,13],[17,0,18,0],[19,0,20,0],[17,1,18,1],[19,1,20,1],[47,13,48,13],[39,13,40,13],[37,13,38,13],[35,13,36,13],[33,13,34,13],[53,13,54,13],[55,13,56,13],[55,0,56,0],[53,0,54,0],[53,1,54,1],[55,1,56,1],[53,2,54,2],[53,3,54,3],[53,4,54,4],[55,2,56,2],[55,3,56,3],[55,4,56,4],[51,3,52,3],[51,4,52,4],[49,4,50,4],[49,3,50,3],[49,2,50,2],[13,4,14,4],[11,4,12,4],[11,0,12,0],[13,0,14,0],[15,0,16,0],[11,1,12,1],[13,1,14,1],[15,1,16,1],[11,2,12,2],[13,2,14,2],[29,3,30,3],[29,4,30,4],[47,0,48,0],[47,1,48,1],[45,0,46,0],[45,1,46,1],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,13,46,13],[41,0,42,0],[41,1,42,1],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,13,42,13],[43,0,44,0],[43,1,44,1],[43,2,44,2],[43,3,44,3],[43,4,44,4],[43,13,44,13]]}
["Project Pairing Spreadsheet",null,null,null,null,"Summer/Fall Flow Targets Met From Existing Flow and Projects Selected"]
[null,null,null,null,null,"1 - Flow @ Milton-Freewater","2 - Flow @ Nursery Bridge","3 - Flow @ Pepper Bridge","4 - Flow @ Beet Road","5 - Flow @ Detour Road","6 - Flow @ McDonald Road","7 - Flow @ Touchet Confluence","8 - Flow @ RV Park"]
["Total Project Cost","Total Annual O&M","O&M / Acre-Foot","Project Cost / Instream CFS","Unallocated Water (Acre-feet)",{"$f":"F4/65","v":1.6584615384615384},0.49076923076923074,0.30769230769230771,0.50769230769230766,0.6661538461538461,0.20153846153846156,0.47538461538461535,0.42307692307692307]
[{"$f":"SUM(P10:P64)","v":0},{"$f":"SUM(S10:S64)","v":0},{"$f":"(B4/SUM(U10:U64))","v":{"$error":"#DIV/0!"}},{"$f":"(A4/(SUM(V10:V59)))","v":{"$error":"#DIV/0!"}},{"$f":"(SUM(Q10:Q64)+33100)","v":33100},{"$f":"SUM(F9,F11,F13,F15,F17,F19,F21,F23,F25,F27,F29,F31,F33,F35,F37,F39,F41,F43,F45,F47,F49,F51,F53,F55,F57,F59)","v":107.8},{"$f":"SUM(G9,G11,G13,G15,G17,G19,G21,G23,G25,G27,G29,G31,G33,G35,G37,G39,G41,G43, G45,G47,G49,G51,G53,G55,G57,G59)","v":31.9},{"$f":"SUM(H9,H11,H13,H15,H17,H19,H21,H23,H25,H27,H29,H31,H33,H35,H37,H39,H41,H43,H45,H47,H49,H51,H53,H55,H57,H59)","v":20},33,43.3,13.100000000000001,30.9,27.5]
[null,null,null,null,"Total Water Available from WWR"]
[null,null,null,null,"33,100 Acre-feet","Flow Targets Met at Management Points?",null,null,null,null,null,null,null,"Include Project?",null,null,null,"Yes"]
["Potential Project List","Project Criteria Scoring","Cost","Annual O&M","Water Budget Impact (Acre-feet)","1 - Above MF","2 - MF to Nursery Bridge","3 - Nursery Bridge to Pepper Bridge","4 - Pepper Bridge to Beet Road","5 - Beet Road to Detour Road","6 - Detour Road to McDonald Road","7 - McDonald Road to Touchet Confluence","8 - Touchet Confluence to RV Park",null,"Additional Formula","If \"YES\", Add Project Cost","If \"YES\", Add Project Water Budget Impact","No","If \"YES\", Add Project O&M","Project AF/Yr (For calculating O&M/AF)","\"YES\"Project AF/YR","\"Yes\" CFS"]
["Existing Conditions",null,null,null,null,{"$f":"F9/65","v":1.6584615384615384},{"$f":"G9/65","v":0.49076923076923074},0.30769230769230771,0.53384615384615386,0.69230769230769229,0.24307692307692308,0.52307692307692311,0.47076923076923077,"No"]
[null,null,null,null,null,107.8,31.9,20,34.700000000000003,45,15.8,34,30.6,"No"]
["Pine Creek Reservoir (WWR Fill) - 33.1K AF",null,271000000,177804,-27594,{"$f":"(F11/65)","v":0},{"$f":"(G11/65)","v":0},{"$f":"(H11/65)","v":0},0,0,0,0,0,"No",null,{"$f":"IF(N10=\"Yes\",C10,0)","v":0},{"$f":"IF(N10=\"Yes\",E10,0)","v":0},null,{"$f":"IF(N10=\"Yes\",D10,0)","v":0},30000,{"$f":"IF(N10=\"Yes\",T10,0)","v":0}]
[null,null,null,null,null,{"$f":"IF($N$10=\"Yes\",0,0)","v":0},{"$f":"IF($N$10=\"Yes\",57.5,0)","v":0},{"$f":"IF($N$10=\"Yes\",52.9,0)","v":0},{"$f":"IF($N$10=\"Yes\",42.5,0)","v":0},{"$f":"IF($N$10=\"Yes\",42.5,0)","v":0},{"$f":"IF($N$10=\"Yes\",45,0)","v":0},{"$f":"IF($N$10=\"Yes\",45,0)","v":0},{"$f":"IF($N$10=\"Yes\",26,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N10=\"Yes\",(SUM(F11:M11)),0)","v":0}]
["Pine Creek Reservoir (WWR & Mill Creek Fill) - 33.1K AF",null,288600000,270000,-29587,{"$f":"(F13/65)","v":0},{"$f":"(G13/65)","v":0},0,0,0,0,0,0,"No",null,{"$f":"IF(N12=\"Yes\",C12,0)","v":0},{"$f":"IF(N12=\"Yes\",E12,0)","v":0},null,{"$f":"IF(N12=\"Yes\",D12,0)","v":0},30000,{"$f":"IF(N12=\"Yes\",T12,0)","v":0}]
[null,null,null,null,null,{"$f":"IF($N$12=\"Yes\",0,0)","v":0},{"$f":"IF($N$12=\"Yes\",57,0)","v":0},{"$f":"IF($N$12=\"Yes\",52.9,0)","v":0},{"$f":"IF($N$12=\"Yes\",42.5,0)","v":0},{"$f":"IF($N$12=\"Yes\",42.5,0)","v":0},{"$f":"IF($N$12=\"Yes\",45,0)","v":0},{"$f":"IF($N$12=\"Yes\",45,0)","v":0},{"$f":"IF($N$12=\"Yes\",29,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N12=\"Yes\",(SUM(F13:M13)),0)","v":0}]
["Pine Creek Reservoir (WWR & LWW/Columbia Fill) - 33.1K AF",null,319000000,500000,-31908,{"$f":"(F15/65)","v":0},{"$f":"(G15/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,30000,0]
[null,null,null,null,null,{"$f":"IF($N$14=\"Yes\",0,0)","v":0},{"$f":"IF($N$14=\"Yes\",0,0)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(N14=\"Yes\",(SUM(F15:M15)),0)","v":0}]
["Pine Creek Reservoir (WWR Fill) - 45.8K AF",null,284000000,250000,-30000,{"$f":"(F17/65)","v":0},{"$f":"(G17/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,46000,0]
[null,null,null,null,null,{"$f":"IF($N$16=\"Yes\",0,0)","v":0},{"$f":"IF($N$16=\"Yes\",0,0)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(N16=\"Yes\",(SUM(F17:M17)),0)","v":0}]
["Pine Creek Reservoir (WWR & Mill Creek Fill) - 45.8K AF",null,319000000,270000,-31908,{"$f":"(F19/65)","v":0},{"$f":"(G19/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,46000,0]
[null,null,null,null,null,{"$f":"IF($N$18=\"Yes\",0,0)","v":0},{"$f":"IF($N$18=\"Yes\",57.5,0)","v":0},{"$f":"IF($N$18=\"Yes\",(G19*0.78),0)","v":0},{"$f":"IF($N$18=\"Yes\",H19,0)","v":0},{"$f":"IF($N$18=\"Yes\",I19+5,0)","v":0},{"$f":"IF($N$18=\"Yes\",J19*1.03,0)","v":0},{"$f":"IF($N$18=\"Yes\",K19,0)","v":0},{"$f":"IF($N$18=\"Yes\",30.5,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N18=\"Yes\",(SUM(F19:M19)),0)","v":0}]
["Pine Creek Reservoir (WWR & LWW/Columbia Fill) - 45.8K AF",null,387000000,500000,-31908,{"$f":"(F21/65)","v":0},{"$f":"(G21/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,46000,0]
[null,null,null,null,null,{"$f":"IF($N$20=\"Yes\",0,0)","v":0},{"$f":"IF($N$20=\"Yes\",59,0)","v":0},{"$f":"IF($N$20=\"Yes\",(G21*0.8),0)","v":0},{"$f":"IF($N$20=\"Yes\",H21,0)","v":0},{"$f":"IF($N$20=\"Yes\",I21,0)","v":0},{"$f":"IF($N$20=\"Yes\",53,0)","v":0},{"$f":"IF($N$20=\"Yes\",K21,0)","v":0},{"$f":"IF($N$20=\"Yes\",L21,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N20=\"Yes\",(SUM(F21:M21)),0)","v":0}]
["Columbia River Exchange (WWRID/HBDIC/GFID/Lowden4)",null,163000000,2250000,0,{"$f":"(F23/65)","v":0},{"$f":"(G23/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,35971,0]
[null,null,null,null,null,{"$f":"IF($N$22=\"Yes\",0,0)","v":0},{"$f":"IF($N$22=\"Yes\",59,0)","v":0},{"$f":"IF($N$22=\"Yes\",(41),0)","v":0},{"$f":"IF($N$22=\"Yes\",42,0)","v":0},{"$f":"IF($N$22=\"Yes\",50,0)","v":0},{"$f":"IF($N$22=\"Yes\",45,0)","v":0},{"$f":"IF($N$22=\"Yes\",86,0)","v":0},{"$f":"IF($N$22=\"Yes\",29.5,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N22=\"Yes\",(SUM(F23:M23)),0)","v":0}]
["Columbia River Exchange (GFID/Lowden4)",null,67000000,445000,0,{"$f":"(F25/65)","v":0},{"$f":"(G25/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,null,0]
[null,null,null,null,null,{"$f":"IF($N$24=\"Yes\",0,0)","v":0},{"$f":"IF($N$24=\"Yes\",0,0)","v":0},0,0,0,{"$f":"IF($N$24=\"Yes\",25,0)","v":0},{"$f":"IF($N$24=\"Yes\",(K25*0.94),0)","v":0},{"$f":"IF($N$24=\"Yes\",L25,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N24=\"Yes\",(SUM(F25:M25)),0)","v":0}]
["MAR Targeted for Instream Flow (14.5K AF & ~5cfs Instream Flow)",null,1400000,178000,-14566,{"$f":"(F27/65)","v":0},{"$f":"(G27/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,14500,0]
[null,null,null,null,null,{"$f":"IF($N$26=\"Yes\",0,0)","v":0},{"$f":"IF($N$26=\"Yes\",0,0)","v":0},{"$f":"IF($N$26=\"Yes\",5,0)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(N26=\"Yes\",(SUM(F27:M27)),0)","v":0}]
["Current MAR (7.5K AF - ~3.1 cfs Instream Flow)",null,762000,85000,-7500,{"$f":"(F29/65)","v":0},{"$f":"(G29/65)","v":0},0,-2.6153846153846153E-2,-2.6153846153846153E-2,-4.1538461538461538E-2,-4.7692307692307694E-2,-4.7692307692307694E-2,"No",null,0,0,null,0,7500,0]
[null,null,null,null,null,{"$f":"IF($N$28=\"Yes\",0,0)","v":0},{"$f":"IF($N$28=\"Yes\",0,0)","v":0},{"$f":"IF($N$28=\"Yes\",0,0)","v":0},{"$f":"IF($N$28=\"No\",-1.7,0)","v":-1.7},{"$f":"IF($N$28=\"No\",-1.7,0)","v":-1.7},{"$f":"IF($N$28=\"No\",-2.7,0)","v":-2.7},{"$f":"IF($N$28=\"No\",-3.1,0)","v":-3.1},{"$f":"IF($N$28=\"No\",-3.1,0)","v":-3.1},null,null,null,null,null,null,null,null,{"$f":"IF(N28=\"Yes\",(SUM(F29:M29)),0)","v":0}]
["Increased MAR (14.5K AF & ~4.2 cfs Instream Flow)",null,1400000,178000,-14566,{"$f":"(F31/65)","v":0},{"$f":"(G31/65)","v":0},{"$f":"(H31/65)","v":0},{"$f":"(I31/65)","v":0},{"$f":"(J31/65)","v":0},{"$f":"(K31/65)","v":0},{"$f":"(L31/65)","v":0},{"$f":"(M31/65)","v":0},"No",null,0,0,null,0,14500,0]
[null,null,null,null,null,{"$f":"IF($N$30=\"Yes\",0,0)","v":0},{"$f":"IF($N$30=\"Yes\",0,0)","v":0},0,{"$f":"IF($N$30=\"Yes\",3.9,0)","v":0},{"$f":"IF($N$30=\"Yes\",3.9,0)","v":0},{"$f":"IF($N$30=\"Yes\",6.2,0)","v":0},{"$f":"IF($N$30=\"Yes\",7.3,0)","v":0},{"$f":"IF($N$30=\"Yes\",7.3,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N30=\"Yes\",(SUM(F31:M31)),0)","v":0}]
["Maximuim MAR (24.2K AF & ~7.8 cfs Instream Flow)",null,3114000,350000,-24200,{"$f":"(F33/65)","v":0},{"$f":"(G33/65)","v":0},{"$f":"(H33/65)","v":0},{"$f":"(I33/65)","v":0},{"$f":"(J33/65)","v":0},{"$f":"(K33/65)","v":0},{"$f":"(L33/65)","v":0},{"$f":"(M33/65)","v":0},"No",null,0,0,null,0,24200,0]
[null,null,null,null,null,{"$f":"IF($N$32=\"Yes\",0,0)","v":0},{"$f":"IF($N$32=\"Yes\",0,0)","v":0},0,{"$f":"IF($N$32=\"Yes\",5.7,0)","v":0},{"$f":"IF($N$32=\"Yes\",5.7,0)","v":0},{"$f":"IF($N$32=\"Yes\",8.7,0)","v":0},{"$f":"IF($N$32=\"Yes\",3.1+7.8,0)","v":0},{"$f":"IF($N$32=\"Yes\",3.1+7.8,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N32=\"Yes\",(SUM(F33:M33)),0)","v":0}]
["Aquifer Storage & Recovery - Lowden area (WWR Source)",null,1750000,70000,-880,{"$f":"(F35/65)","v":0},{"$f":"(G35/65)","v":0},{"$f":"(H35/65)","v":0},{"$f":"(I35/65)","v":0},{"$f":"(J35/65)","v":0},{"$f":"(K35/65)","v":0},{"$f":"(L35/65)","v":0},{"$f":"(M35/65)","v":0},"No",null,0,0,null,0,880,0]
[null,null,null,null,null,{"$f":"IF($N$34=\"Yes\",0,0)","v":0},{"$f":"IF($N$34=\"Yes\",0,0)","v":0},0,0,0,{"$f":"IF($N$34=\"Yes\",5.5,0)","v":0},{"$f":"IF($N$34=\"Yes\",(5.5*0.94),0)","v":0},{"$f":"IF($N$34=\"Yes\",(5.5*0.94),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N34=\"Yes\",(SUM(F35:M35)),0)","v":0}]
["Aquifer Storage & Recovery - Yellowhawk/Mill Creek area (Non-WWR Source)",null,1750000,70000,0,{"$f":"(F37/65)","v":0},{"$f":"(G37/65)","v":0},{"$f":"(H37/65)","v":0},{"$f":"(I37/65)","v":0},{"$f":"(J37/65)","v":0},{"$f":"(K37/65)","v":0},{"$f":"(L37/65)","v":0},{"$f":"(M37/65)","v":0},"No",null,0,0,null,0,880,0]
[null,null,null,null,null,{"$f":"IF($N$36=\"Yes\",0,0)","v":0},{"$f":"IF($N$36=\"Yes\",0,0)","v":0},{"$f":"IF($N$370=\"Yes\",0,0)","v":0},{"$f":"IF($N$36=\"Yes\",5.5,0)","v":0},{"$f":"IF($N$36=\"Yes\",(5.5*0.96),0)","v":0},{"$f":"IF($N$36=\"Yes\",(J37*0.94),0)","v":0},{"$f":"IF($N$36=\"Yes\",K37,0)","v":0},{"$f":"IF($N$36=\"Yes\",(L37*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N36=\"Yes\",(SUM(F37:M37)),0)","v":0}]
["Aquifer Storage & Recovery - Lowden area (WWR Source) - 10 Sites",null,17500000,700000,-8800,{"$f":"(F39/65)","v":0},{"$f":"(G39/65)","v":0},{"$f":"(H39/65)","v":0},{"$f":"(I39/65)","v":0},{"$f":"(J39/65)","v":0},{"$f":"(K39/65)","v":0},{"$f":"(L39/65)","v":0},{"$f":"(M39/65)","v":0},"No",null,{"$f":"IF(N38=\"Yes\",C38,0)","v":0},{"$f":"IF(N38=\"Yes\",E38,0)","v":0},null,0,8800,0]
[null,null,null,null,null,{"$f":"IF($N$38=\"Yes\",0,0)","v":0},{"$f":"IF($N$38=\"Yes\",0,0)","v":0},{"$f":"IF($N$38=\"Yes\",0,0)","v":0},{"$f":"IF($N$38=\"Yes\",0,0)","v":0},{"$f":"IF($N$38=\"Yes\",0,0)","v":0},{"$f":"IF($N$38=\"Yes\",31.5,0)","v":0},{"$f":"IF($N$38=\"Yes\",(31.5*0.94),0)","v":0},{"$f":"IF($N$38=\"Yes\",(L39*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N38=\"Yes\",(SUM(F39:M39)),0)","v":0}]
["Aquifer Storage & Recovery - Yellowhawk/Mill Creek area (Non-WWR Source) - 10 Sites",null,17500000,700000,0,{"$f":"(F41/65)","v":0},{"$f":"(G41/65)","v":0},{"$f":"(H41/65)","v":0},{"$f":"(I41/65)","v":0},{"$f":"(J41/65)","v":0},{"$f":"(K41/65)","v":0},{"$f":"(L41/65)","v":0},{"$f":"(M41/65)","v":0},"No",null,0,0,null,0,8800,0]
[null,null,null,null,null,{"$f":"IF($N$40=\"Yes\",0,0)","v":0},{"$f":"IF($N$40=\"Yes\",0,0)","v":0},{"$f":"IF($N$40=\"Yes\",0,0)","v":0},{"$f":"IF($N$40=\"Yes\",31.5,0)","v":0},{"$f":"IF($N$40=\"Yes\",(31.5*0.96),0)","v":0},{"$f":"IF($N$40=\"Yes\",(J41*0.94),0)","v":0},{"$f":"IF($N$40=\"Yes\",K41,0)","v":0},{"$f":"IF($N$40=\"Yes\",(L41*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N40=\"Yes\",(SUM(F41:M41)),0)","v":0}]
["Aquifer Storage and Recovery - Direct Instream Flow Improvement (Tumalum Reach)",null,1750000,70000,-880,{"$f":"(F43/65)","v":0},{"$f":"(G43/65)","v":0},0,0,0,0,0,0,"No",null,0,0,null,0,880,0]
[null,null,null,null,null,{"$f":"IF($N$42=\"Yes\",0,0)","v":0},{"$f":"IF($N$42=\"Yes\",5.6,0)","v":0},{"$f":"IF($N$42=\"Yes\",(G43*0.81),0)","v":0},{"$f":"IF($N$42=\"Yes\",(H43*0.95),0)","v":0},{"$f":"IF($N$42=\"Yes\",(I43),0)","v":0},{"$f":"IF($N$42=\"Yes\",(J43*0.94),0)","v":0},{"$f":"IF($N$42=\"Yes\",K43,0)","v":0},{"$f":"IF($N$42=\"Yes\",(L43*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N42=\"Yes\",(SUM(F43:M43)),0)","v":0}]
["Aquifer Storage and Recovery - Direct Instream Flow Improvement (McDonald Rd Reach)",null,1750000,70000,-880,{"$f":"(F45/65)","v":0},0,0,0,0,0,0,0,"No",null,0,0,null,0,880,0]
[null,null,null,null,null,{"$f":"IF($N$44=\"Yes\",0,0)","v":0},{"$f":"IF($N$44=\"Yes\",0,0)","v":0},{"$f":"IF($N$44=\"Yes\",0,0)","v":0},{"$f":"IF($N$44=\"Yes\",0,0)","v":0},{"$f":"IF($N$44=\"Yes\",0,0)","v":0},{"$f":"IF($N$44=\"Yes\",3.1,0)","v":0},{"$f":"IF($N$44=\"Yes\",(K45),0)","v":0},{"$f":"IF($N$44=\"Yes\",(3.1*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N44=\"Yes\",(SUM(F45:M45)),0)","v":0}]
["Eastside ASR",null,2406250,60000,-1980,{"$f":"(F47/65)","v":0},0,0,0,0,0,0,0,"No",null,0,0,null,0,1980,0]
[null,null,null,null,null,{"$f":"IF($N$46=\"Yes\",0,0)","v":0},{"$f":"IF($N$46=\"Yes\",7,0)","v":0},{"$f":"IF($N$46=\"Yes\",(G47*0.81),0)","v":0},{"$f":"IF($N$46=\"Yes\",(H47*0.95),0)","v":0},{"$f":"IF($N$46=\"Yes\",(I47),0)","v":0},{"$f":"IF($N$46=\"Yes\",(J47*0.94),0)","v":0},{"$f":"IF($N$46=\"Yes\",K47,0)","v":0},{"$f":"IF($N$46=\"Yes\",(L47*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N46=\"Yes\",(SUM(F47:M47)),0)","v":0}]
["White Ditch Piping",null,2500000,0,2500,{"$f":"(F49/65)","v":0},{"$f":"(G49/65)","v":0},{"$f":"(H49/65)","v":0},{"$f":"(I49/65)","v":0},{"$f":"(J49/65)","v":0},{"$f":"(K49/65)","v":0},{"$f":"(L49/65)","v":0},{"$f":"(M49/65)","v":0},"No",null,0,0,null,0,2500,0]
[null,null,null,null,null,{"$f":"IF($N$48=\"Yes\",0,0)","v":0},{"$f":"IF($N$48=\"Yes\",5.6,0)","v":0},{"$f":"IF($N$48=\"Yes\",(G49*0.81),0)","v":0},{"$f":"IF($N$48=\"Yes\",(H49*0.95),0)","v":0},{"$f":"IF($N$48=\"Yes\",(I49),0)","v":0},{"$f":"IF($N$48=\"Yes\",(J49*0.94),0)","v":0},{"$f":"IF($N$48=\"Yes\",K49,0)","v":0},{"$f":"IF($N$48=\"Yes\",(L49*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N48=\"Yes\",(SUM(F49:M49)),0)","v":0}]
["Upper Gardena Farms Canal Piping",null,14000000,10000,2500,{"$f":"(F51/65)","v":0},{"$f":"(G51/65)","v":0},{"$f":"(H51/65)","v":0},{"$f":"(I51/65)","v":0},{"$f":"(J51/65)","v":0},{"$f":"(K51/65)","v":0},{"$f":"(L51/65)","v":0},{"$f":"(M51/65)","v":0},"No",null,{"$f":"IF(N50=\"Yes\",C50,0)","v":0},{"$f":"IF(N50=\"Yes\",E50,0)","v":0},null,0,2500,0]
[null,null,null,null,null,{"$f":"IF($N$50=\"Yes\",0,0)","v":0},{"$f":"IF($N$50=\"Yes\",0,0)","v":0},{"$f":"IF($N$50=\"Yes\",0,0)","v":0},{"$f":"IF($N$50=\"Yes\",5,0)","v":0},{"$f":"IF($N$50=\"Yes\",(I51),0)","v":0},{"$f":"IF($N$50=\"Yes\",(J51*0.94),0)","v":0},{"$f":"IF($N$50=\"Yes\",K51,0)","v":0},{"$f":"IF($N$50=\"Yes\",(L51*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N50=\"Yes\",I51,0)","v":0}]
["Lowden 2, Garden City & Mud Creek 7 Piping",null,3160000,2000,1500,{"$f":"(F53/65)","v":0},{"$f":"(G53/65)","v":0},{"$f":"(H53/65)","v":0},{"$f":"(I53/65)","v":0},{"$f":"(J53/65)","v":0},{"$f":"(K53/65)","v":0},{"$f":"(L53/65)","v":0},{"$f":"(M53/65)","v":0},"No",null,0,0,null,0,1500,0]
[null,null,null,null,null,{"$f":"IF($N$52=\"Yes\",0,0)","v":0},{"$f":"IF($N$52=\"Yes\",0,0)","v":0},{"$f":"IF($N$52=\"Yes\",0,0)","v":0},{"$f":"IF($N$52=\"Yes\",0,0)","v":0},{"$f":"IF($N$52=\"Yes\",0,0)","v":0},{"$f":"IF($N$52=\"Yes\",5.5,0)","v":0},{"$f":"IF($N$52=\"Yes\",K53,0)","v":0},{"$f":"IF($N$52=\"Yes\",(L53*0.96),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N52=\"Yes\",(K53),0)","v":0}]
["Telemetry",null,151800,75000,712,{"$f":"(F55/65)","v":0},{"$f":"(G55/65)","v":0},{"$f":"(H55/65)","v":0},{"$f":"(I55/65)","v":0},{"$f":"(J55/65)","v":0},{"$f":"(K55/65)","v":0},{"$f":"(L55/65)","v":0},{"$f":"(M55/65)","v":0},"No",null,{"$f":"IF(N54=\"Yes\",C54,0)","v":0},{"$f":"IF(N54=\"Yes\",E54,0)","v":0},null,{"$f":"IF(N54=\"Yes\",D54,0)","v":0},712,0]
[null,null,null,null,null,{"$f":"IF($N$54=\"Yes\",0,0)","v":0},{"$f":"IF($N$54=\"Yes\",2,0)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(N54=\"Yes\",G55,0)","v":0}]
["Water Market",null,500000,5000,365,{"$f":"(F57/65)","v":0},{"$f":"(G57/65)","v":0},{"$f":"(H57/65)","v":0},{"$f":"(I57/65)","v":0},{"$f":"(J57/65)","v":0},{"$f":"(K57/65)","v":0},{"$f":"(L57/65)","v":0},{"$f":"(M57/65)","v":0},"No",null,{"$f":"IF(N56=\"Yes\",C56,0)","v":0},{"$f":"IF(N56=\"Yes\",E56,0)","v":0},null,{"$f":"IF(N56=\"Yes\",D56,0)","v":0},365,0]
[null,null,null,null,null,{"$f":"IF($N$56=\"Yes\",0,0)","v":0},{"$f":"IF($N$56=\"Yes\",1,0)","v":0},{"$f":"IF($N$56=\"Yes\",1,0)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(N56=\"Yes\",G57,0)","v":0}]
["GFID Pump-back Loop",null,260000,20000,0,{"$f":"(F59/65)","v":0},0,0,0,0,0,0,0,"No",null,0,0,null,0,1200,0]
[null,null,null,null,null,{"$f":"IF($N$58=\"Yes\",0,0)","v":0},{"$f":"IF($N$58=\"Yes\",0,0)","v":0},0,{"$f":"IF($N$58=\"Yes\",10,0)","v":0},{"$f":"IF($N$58=\"Yes\",I59*0.96,0)","v":0},{"$f":"IF($N$58=\"Yes\",J59*0.94,0)","v":0},{"$f":"IF($N$58=\"Yes\",K59,0)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"IF(N58=\"Yes\",I59,0)","v":0}]

{"sheet":"Map_ManagementReaches","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}