{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ReadMe","Aug.20.2012_Model","North_Channel","Unmeasured_Gains_Losses","Measured_Main_Stem_Data","Concentration Interactive","Load Interactive","Discharge Calibration Plot","Major_inflows"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"Concentration Interactive","index":5,"reason":"not_a_worksheet"},{"sheet":"Load Interactive","index":6,"reason":"not_a_worksheet"},{"sheet":"Discharge Calibration Plot","index":7,"reason":"not_a_worksheet"}],"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":"ReadMe","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,16],[13,1,13,16],[6,0,6,16],[7,1,7,16],[8,0,8,16],[9,1,9,16],[10,0,10,16],[11,1,11,16],[5,1,5,16],[1,1,1,16],[2,1,2,16],[0,0,0,16],[3,1,3,16],[4,0,4,16]]}
["Aug.20.2012_Model"]
["Abbreviations","USGS, U.S. Geological Survey; ID, identifier; TP, total phosphorus; No., number; SW, surface water; RM, river mile; GW, groundwater; Q, discharge; WWTP, wastewater treatment plant; IDWR, Idaho Department of Water Resources; LT-MDL, long-term method detection limit; RL, reporting level; MRL, method reporting level; ft3/s, cubic feet per second; mg/L, milligrams per liter; lbs/d, pounds per day; kg/d, kilograms per day."]
["Explanation","Refer to the methods section of the report for a full explanation of computations used in the model. Variables explained in the methods section are provided at the top of each column where they are relevant. The equation number in the report that describes a variable is also referenced. Bold, italic sites are main-stem Boise River sites. Bold green sites are sampled returns. Column B is hidden and shows site names. Green-filled column headings indicate measured data. Yellow-filled column headings indicate measured and estimated or computed information. Light blue highlighted cells are groundwater calculations. Light orange cells show results for the measured mass balance model. Light red cells show results for the predictive mass balance model.  Yellow cells in the assumed groundwater TP columns are input data for assumed groundwater TP concentrations. Dark blue headings indicate that the user can change inputs to see the resulting scenario in the predictive mass balance model. See comments in specific cells for more detailed information."]
["Predictive Model Scenarios","Use the password \"model\" to unlock cells described in this section. To run a scenario using the predictive model, set the assumed groundwater concentration below RM 28.8 in cell O39. Paste the selected groundwater assumptions as values into the \"Assumed GW TP Dial\" column M. Change desired concentrations in blue- and purple-highlighted cells in the \"SW TP Concentration Dial\" column. Purple-highlighted cells represent point sources and blue-highlighted cells represent nonpoint sources. View results on the \"Concentration Interactive\" and \"Load Interactive\" worksheets. To revert SW TP concentrations back to their measured values, press the \"Revert\" button. If the user would prefer load output in kg/d, change the conversion factor to 2.445 in the \"Conversion Factor\" cell T2."]
["North Channel"]
["Explanation","Abbreviations are the same as in the Aug.20.2012_Model worksheet. This worksheet shows model calculations in the North Channel. No user inputs are enabled in this worksheet."]
["Unmeasured_Gains_Losses"]
["Explanation","Abbreviations are the same as in the Aug.20.2012_Model worksheet. Variables as well as the equation in which they are defined in the report are provided at column headings. The variables computed in this worksheet are used to interpolate groundwater and TP gains throughout the modeling reach. "]
["Measured_Main_Stem_Data"]
["Explanation","Abbreviations are the same as in the Aug.20.2012_Model worksheet. This worksheet shows measured main-stem TP concentrations, discharges, and instantaneous loads and is used to plot those measured values on various charts. It also updates a comparison chart to view predictive versus measured model output. Mm, Cp, and Cm stand for measured model loads, predictive model concentrations, and measured model concentrations, respectively."]
["Concentration Interactive, Load Interactive, and Discharge Calibration Plot"]
["Explanation","Abbreviations are the same as in the Aug.20.2012_Model worksheet. These worksheets show model results. The Concentration Interactive worksheet shows measured model and predictive model TP concentrations. It will also show predictive model concentrations when a scenario is run on the predictive model. The measured model is static on this worksheet. The Load Interactive worksheet shows measured model and predictive model TP loads. It will also show predictive model loads when a scenario is run on the predictive model. The measured model is static on this worksheet. The blue line represents net surface-water TP loads without the influence of groundwater. The Discharge Calibration Plot worksheet shows modeled discharge as a red line. It also shows net surface-water discharge without the influence of groundwater as a blue line. The distance of the red line above or below the blue line indicates the magnitude and cumulative amount of unaccounted for discharge gains and losses, respectively. The gains and losses are assumed to represent groundwater exchange in the Boise River."]
["Major_inflows"]
["Explanation","Abbreviations are the same as in the Aug.20.2012_Model worksheet. This worksheet it simply used to plot vertical lines on charts showing the location of major tributary inflows to the lower Boise River. "]

{"sheet":"Aug.20.2012_Model","index":1,"n_rows":83,"n_cols":25,"rows_kept":83,"cut":false,"hidden":false,"merged":[[6,16,6,17],[6,22,6,23]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable in Report","Factor","Conversion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",5.3937799999999996,"[ft3/s ∙ mg/L] to lbs/d"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/F",{"$f":"1/T2","v":0.18539873706380314},"lbs/d to [ft3/s ∙ mg/L]"]
[]
[null,null,null,"Equation No. In Report",1,5,5,1,5,null,1,3,4,18,18,null,14,17,5,5,7,null,9,12]
[null,null,null,"Variable in Report","QUS, QDS, QD,or QR","CUS, CDS, or CR","CD","= QUS - QD or + QR","= MUS - MD or + MR",null,"Qgw","Qgwi…n","Qmi…n","Cgw i…n","Cgwupper i…n, Cgw = 0.25",null,"Cp","Mp","MUS, -MD, +MR","∆M","∆Mi…n","Cgwbc","Cm","Mm"]
["Diversion, Return, or Main-stem","Site Name","USGS Site ID","River Mile","Measured Discharge","Measured TP","Estimated Diversion TP","Net SW Discharge","Net SW Load","Discharge Uncertainty Propogation of Errror","GW Gain/Loss per Subreach","GW Gain/Loss per RM ","Modeled Discharge with GW Gain/Loss","Estimated GW TP Dial","Constant GW TP\nRM 28.8 to 3.8","SW TP Concentration Dial","Predictive TP Mass Balance Model",null,"SW Load In/Out ","\nLoad Gain/Loss per Subreach","Load In/Out per RM","Back-Calculated GW TP per Reach","Measured TP Mass Balance Model",null,"Notes"]
[null,null,null,"mile","ft3/s","mg/L","mg/L","ft3/s","lbs/d","ft3/s","ft3/s","ft3/s/mi","ft3/s","mg/L","mg/L","mg/L","mg/L","lbs/d","lbs/d","lbs/d","lbs/d/mi","mg/L","mg/L","lbs/d"]
["M","Boise River below Diversion Dam near Boise, ID",13203510,61.1,{"$f":"3860-2255","v":1605},1.2E-2,null,{"$f":"E9","v":1605},{"$f":"F9*E9*$T$2","v":103.8842028},null,null,0,1599,0.01,0.01,1.2E-2,{"$f":"F9","v":1.2E-2},{"$f":"Q9*M9*$T$2","v":103.49585063999999},{"$f":"F9*M9*$T$2","v":103.49585063999999},0,0,0,{"$f":"F9","v":1.2E-2},{"$f":"W9*M9*$T$2","v":103.49585063999999},"used unpublished value which was a detection below MRL, daily flow"]
["M","Boise River at Veteran's Memorial Parkway at Boise, ID",13205642,50.17,759,1.4999999999999999E-2,null,{"$f":"E10","v":759},{"$f":"F10*E10*$T$2","v":61.408185299999992},28.84,0,0,{"$f":"E10","v":759},0.01,0.01,{"$f":"F10","v":1.4999999999999999E-2},{"$f":"P10","v":1.4999999999999999E-2},61.408185299999992,{"$f":"F10*M10*$T$2","v":61.408185299999992},0,0,0,{"$f":"F10","v":1.4999999999999999E-2},61.408185299999992,"used lab result which was above LT-MDL, below RL"]
["R","Boise City Sewer Outflow at Boise, ID (Lander WWTP)",13205643,50.01,20.8,2.23,null,{"$f":"H10+E11","v":779.8},{"$f":"I10+(F11*E11*$T$2)","v":311.59327681999997},null,null,{"$f":"(D10-D11)*Unmeasured_Gains_Losses!$B$6","v":-1.6659176029962894},{"$f":"M10+E11+L11","v":778.13408239700368},0.01,0.01,{"$f":"F11","v":2.23},{"$f":"((P11*E11)+(Q10*M10)+(L11*Q10))/(M11)","v":7.4208304895317628E-2},{"$f":"F11","v":2.23},{"$f":"(F11*E11*$T$2)","v":250.18509151999999},null,{"$f":"(D10-D11)*Unmeasured_Gains_Losses!$C$6","v":-1.1346639310938491E-2},null,{"$f":"((W10*M10)+(F11*E11)+(U11*$T$3))/M11","v":7.4237715137028509E-2},311.58193018068903]
["D","Riverside Village",null,47.69,0,null,7.0000000000000007E-2,{"$f":"H11+E12","v":779.8},{"$f":"I11+(G12*E12*$T$2)","v":311.59327681999997},null,null,{"$f":"(D11-D12)*Unmeasured_Gains_Losses!$B$6","v":-24.155805243445641},{"$f":"M11+E12+L12","v":753.978277153558},0.01,0.01,null,{"$f":"((Q11*M11)+(E12*Q11)+(L12*Q11))/M12","v":7.4208304895317628E-2},301.78981130924529,{"$f":"(G12*E12*$T$2)","v":0},null,{"$f":"(D11-D12)*Unmeasured_Gains_Losses!$C$6","v":-0.16452627000860434},null,{"$f":"((W11*M11)+(E12*G12)+(U12*$T$3))/M12","v":7.6575672183417043E-2},311.41740391068043]
["M","Boise River at Glenwood Bridge near Boise, ID",13206000,47.5,752,7.0000000000000007E-2,null,{"$f":"H12","v":779.8},{"$f":"I12","v":311.59327681999997},47.43,{"$f":"E13-(E10+SUM(E11:E12))","v":-27.799999999999955},{"$f":"(D12-D13)*Unmeasured_Gains_Losses!$B$6","v":-1.9782771535580244},{"$f":"M12+L13","v":752},1.2137834036568188E-2,{"$f":"O12+((($O$39-$O$10)/($D$10-$D$39))*(D12-D13))","v":1.2137834036568188E-2},null,{"$f":"((Q12*M12)+(L13*Q12))/M13","v":7.4208304895317628E-2},300.99797962525628,{"$f":"F13*M13*$T$2","v":283.9285792},-0.18934704350128181,{"$f":"(D12-D13)*Unmeasured_Gains_Losses!$C$6","v":-1.3474134181738985E-2},{"$f":"(T13/K13)*$T$3","v":1.2627590910756366E-3},{"$f":"((W12*M12)+(U13*$T$3))/M13","v":7.6773796937856506E-2},311.40392977649867,"mean daily Q"]
["D","New Dry Creek Canal",null,46.01,-38,null,7.0000000000000007E-2,{"$f":"H13+E14","v":741.8},{"$f":"I13+(G14*E14*$T$2)","v":297.24582201999999},null,null,{"$f":"(D13-D14)*Unmeasured_Gains_Losses!$B$7","v":6.6891489361702243},{"$f":"M13+E14+L14","v":720.68914893617023},2.8902953586497887E-2,2.8902953586497887E-2,null,{"$f":"((Q13*M13)+(E14*Q13)+(L14*N14))/M14","v":7.3787798713203526E-2},286.83078805542982,{"$f":"(G14*E14*$T$2)","v":-14.3474548},null,{"$f":"(D13-D14)*Unmeasured_Gains_Losses!$C$7","v":30.108676718638328},null,{"$f":"((W13*M13)+(E14*G14)+(U14*$T$3))/M14","v":8.4163895106651773E-2},327.16515169513701,"Not on North channel"]
["D","Loss to North Channel (Boise River North Channel at Eagle, ID)",13206300,45.51,{"$f":"North_Channel!E5/-1","v":-177},0.06,null,564.79999999999995,{"$f":"I14+(F15*E15*$T$2)","v":239.96387842000001},null,null,{"$f":"(D14-D15)*Unmeasured_Gains_Losses!$B$7","v":2.2446808510638308},{"$f":"M14+E15+L15","v":545.933829787234},3.4528832630098448E-2,3.4528832630098448E-2,{"$f":"Q15","v":7.3626380159175372E-2},{"$f":"((Q14*M14)+(E15*Q14)+(L15*N15))/M15","v":7.3626380159175372E-2},216.80369742668029,{"$f":"(F15*E15*$T$2)","v":-57.281943599999991},null,{"$f":"(D14-D15)*Unmeasured_Gains_Losses!$C$7","v":10.103582791489359},null,{"$f":"((W14*M14)+(E15*W14)+(U15*$T$3))/M15","v":8.7249013327519803E-2},256.91754294236733,"instantaneous Q, measured at RM 42.8. RM 45.5 Q = 161 + Ballentyne + Mace Mace"]
["D","Lemp Canal",null,44.809999999999995,-2,null,0.06,562.79999999999995,{"$f":"I15+(G16*E16*$T$2)","v":239.31662482000002},null,null,{"$f":"(D15-D16)*Unmeasured_Gains_Losses!$B$7","v":3.1425531914893758},{"$f":"M15+E16+L16","v":547.07638297872336},4.2405063291139265E-2,4.2405063291139265E-2,null,{"$f":"((Q15*M15)+(E16*Q15)+(L16*N16))/M16","v":7.3447036557406392E-2},216.72822445658846,{"$f":"(G16*E16*$T$2)","v":-0.64725359999999987},null,{"$f":"(D15-D16)*Unmeasured_Gains_Losses!$C$7","v":14.14501590808516},null,{"$f":"((W15*M15)+(E16*G16)+(U16*$T$3))/M16","v":9.1641053490891633E-2},270.41530525045249]
["D","Warm Springs Canal",null,44.5,-7,null,0.06,555.79999999999995,{"$f":"I16+(G17*E17*$T$2)","v":237.05123722000002},null,null,{"$f":"(D16-D17)*Unmeasured_Gains_Losses!$B$7","v":1.3917021276595534},{"$f":"M16+E17+L17","v":541.46808510638289},4.5893108298171559E-2,4.5893108298171559E-2,null,{"$f":"((Q16*M16)+(E17*Q16)+(L17*N17))/M17","v":7.3376216389720583E-2},214.29962258707621,{"$f":"(G17*E17*$T$2)","v":-2.2653875999999999},null,{"$f":"(D16-D17)*Unmeasured_Gains_Losses!$C$7","v":6.2642213307233048},null,{"$f":"((W16*M16)+(E17*G17)+(U17*$T$3))/M17","v":9.3959433988736865E-2},274.41413898117577]
["R","West Boise Sewer Outflow near Eagle, ID (West Boise WWTP)",13206303,44.16,22.9,4.28,null,578.69999999999993,{"$f":"I17+(F18*E18*$T$2)","v":765.70640258000003},null,null,{"$f":"(D17-D18)*Unmeasured_Gains_Losses!$B$7","v":1.5263829787234202},{"$f":"M17+E18+L18","v":565.89446808510627},4.9718706047819979E-2,4.9718706047819979E-2,{"$f":"F18","v":4.28},{"$f":"((P18*E18)+(Q17*M17)+(L18*N18))/(M18)","v":0.24354146742922786},743.36412076043518,{"$f":"(F18*E18*$T$2)","v":528.65516535999996},null,{"$f":"(D17-D18)*Unmeasured_Gains_Losses!$C$7","v":6.8704362982128329},null,{"$f":"((W17*M17)+(E18*F18)+(U18*$T$3))/M18","v":0.26535301806439243},809.93974063938867]
["D","Conway-Hamming Canal",null,43.5,0,null,0.27,578.69999999999993,{"$f":"I18+(G19*E19*$T$2)","v":765.70640258000003},null,null,{"$f":"(D18-D19)*Unmeasured_Gains_Losses!$B$7","v":2.9629787234042411},{"$f":"M18+E19+L19","v":568.85744680851053},5.7144866385372681E-2,5.7144866385372681E-2,null,{"$f":"((Q18*M18)+(E19*Q18)+(L19*N19))/M19","v":0.24257059297534425},744.27739032166937,{"$f":"(G19*E19*$T$2)","v":0},null,{"$f":"(D18-D19)*Unmeasured_Gains_Losses!$C$7","v":13.336729284765884},null,{"$f":"((W18*M18)+(E19*G19)+(U19*$T$3))/M19","v":0.26831751721739233},823.27646992415453]
["D","Thomas Aiken Canal",null,43.07,-1,null,0.27,577.69999999999993,{"$f":"I19+(G20*E20*$T$2)","v":764.25008198},null,null,{"$f":"(D19-D20)*Unmeasured_Gains_Losses!$B$7","v":1.9304255319148931},569.78787234042545,6.198312236286916E-2,6.198312236286916E-2,null,{"$f":"((Q19*M19)+(E20*Q19)+(L20*N20))/M20","v":0.24195876762605714},743.614404192611,{"$f":"(G20*E20*$T$2)","v":-1.4563206},null,{"$f":"(D19-D20)*Unmeasured_Gains_Losses!$C$7","v":8.6890812006808424},null,{"$f":"((W19*M19)+(E20*G20)+(U20*$T$3))/M20","v":0.27023278299461817},830.50923052483529]
["D","Mace-Catlin Canal",null,43.07,-6,null,0.27,571.69999999999993,{"$f":"I20+(G21*E21*$T$2)","v":755.51215837999996},null,null,{"$f":"(D20-D21)*Unmeasured_Gains_Losses!$B$7","v":0},563.78787234042545,6.198312236286916E-2,6.198312236286916E-2,null,{"$f":"((Q20*M20)+(E21*Q20)+(L21*N21))/M21","v":0.24195876762605711},735.78397002273448,{"$f":"(G21*E21*$T$2)","v":-8.7379236000000002},null,{"$f":"(D20-D21)*Unmeasured_Gains_Losses!$C$7","v":0},null,{"$f":"((W20*M20)+(E21*G21)+(U21*$T$3))/M21","v":0.27023526034121648},821.77130692483524]
["D","Graham-Gilbert Canal",null,42.849999999999994,-1,null,0.27,570.69999999999993,{"$f":"I21+(G22*E22*$T$2)","v":754.05583777999993},null,null,{"$f":"(D21-D22)*Unmeasured_Gains_Losses!$B$7","v":0.98765957446811237},563.77553191489358,6.4458509142053477E-2,6.4458509142053477E-2,null,{"$f":"((Q21*M21)+(E22*Q21)+(L22*N22))/M22","v":0.24164781083591971},734.82228222086678,{"$f":"(G22*E22*$T$2)","v":-1.4563206},null,{"$f":"(D21-D22)*Unmeasured_Gains_Losses!$C$7","v":4.4455764282554382},null,{"$f":"((W21*M21)+(E22*G22)+(U22*$T$3))/M22","v":0.27122419838812278},824.76056275309054]
["M","Boise River South Channel at Eagle, ID",13206305,42.8,564,0.27,null,{"$f":"H22","v":570.69999999999993},{"$f":"I22","v":754.05583777999993},32.89,{"$f":"E23-(E13+(SUM(E14:E22)))","v":21.100000000000023},{"$f":"(D22-D23)*Unmeasured_Gains_Losses!$B$7","v":0.22446808510637031},{"$f":"M22+L23","v":564},6.5021097046413498E-2,6.5021097046413498E-2,null,{"$f":"((Q22*M22)+(L23*N23))/M23","v":0.24157751462985061},734.90100530915026,{"$f":"F23*M23*$T$2","v":821.36481839999999},{"$f":"S23-(S13+(SUM(S14:S22)))","v":94.973678240000027},{"$f":"(D22-D23)*Unmeasured_Gains_Losses!$C$7","v":1.0103582791488785},{"$f":"(T23/K23)*$T$3","v":0.83450236966824576},{"$f":"((W22*M22)+(U23*$T$3))/M23","v":0.27144837919040904},825.77092103223936,"mean daily Q"]
["D","Jon Wroten Canal",null,42.7,0,null,0.27,{"$f":"H23+E24","v":570.69999999999993},{"$f":"I23+(G24*E24*$T$2)","v":754.05583777999993},null,null,{"$f":"(D23-D24)*Unmeasured_Gains_Losses!$B$8","v":7.4607843137250978},{"$f":"M23+E24+L24","v":571.46078431372507},6.6146272855133553E-2,6.6146272855133553E-2,null,{"$f":"((Q23*M23)+(E24*Q23)+(L24*N24))/M24","v":0.23928714809430268},737.56285232464063,{"$f":"(G24*E24*$T$2)","v":0},null,{"$f":"(D23-D24)*Unmeasured_Gains_Losses!$C$8","v":-8.5100099549014505},null,{"$f":"((W23*M23)+(E24*G24)+(U24*$T$3))/M24","v":0.26514354952162283},817.26091107733794,"not in IDWR report"]
["D","Barber Pumps",null,42.4,-0.1,null,0.27,{"$f":"H24+E25","v":570.59999999999991},{"$f":"I24+(G25*E25*$T$2)","v":753.91020571999991},null,null,{"$f":"(D24-D25)*Unmeasured_Gains_Losses!$B$8","v":22.382352941176883},{"$f":"M24+E25+L25","v":593.74313725490197},6.9521800281293941E-2,6.9521800281293941E-2,null,{"$f":"((Q24*M24)+(E25*Q24)+(L25*N25))/M25","v":0.23288749866087918},745.82683934233648,{"$f":"(G25*E25*$T$2)","v":-0.14563206000000001},null,{"$f":"(D24-D25)*Unmeasured_Gains_Losses!$C$8","v":-25.530029864706169},null,{"$f":"((W24*M24)+(E25*G25)+(U25*$T$3))/M25","v":0.24717575035857353},791.58524915263195]
["D","Seven Suckers Canal",null,42.019999999999996,0,null,0.27,{"$f":"H25+E26","v":570.59999999999991},{"$f":"I25+(G26*E26*$T$2)","v":753.91020571999991},null,null,{"$f":"(D25-D26)*Unmeasured_Gains_Losses!$B$8","v":28.350980392157172},{"$f":"M25+E26+L26","v":622.09411764705919},7.3797468354430393E-2,7.3797468354430393E-2,null,{"$f":"((Q25*M25)+(E26*Q25)+(L26*N26))/M26","v":0.22563721578267851},757.11187079099875,{"$f":"(G26*E26*$T$2)","v":0},null,{"$f":"(D25-D26)*Unmeasured_Gains_Losses!$C$8","v":-32.33803782862757},null,{"$f":"((W25*M25)+(E26*G26)+(U26*$T$3))/M26","v":0.22627359768501468},759.24721132400441]
["R","Thurman Drain at Mouth near Eagle, ID ",13208750,41.89,11,0.05,null,{"$f":"H26+E27","v":581.59999999999991},{"$f":"I26+(F27*E27*$T$2)","v":756.87678471999993},null,null,{"$f":"(D26-D27)*Unmeasured_Gains_Losses!$B$8","v":9.699019607842839},{"$f":"M26+E27+L27","v":642.79313725490204},7.5260196905766491E-2,7.5260196905766491E-2,{"$f":"F27","v":0.05},{"$f":"((P27*E27)+(Q26*M26)+(L27*N27))/(M27)","v":0.22036254990378465},764.01564017880582,{"$f":"(F27*E27*$T$2)","v":2.9665789999999999},null,{"$f":"(D26-D27)*Unmeasured_Gains_Losses!$C$8","v":-11.063012941372127},null,{"$f":"((W26*M26)+(F27*E27)+(U27*$T$3))/M27","v":0.21665197930700519},751.15077738263244]
["M","Boise River above Phyllis Diversion near Eagle, ID",13208800,41.779999999999994,651,0.21,null,{"$f":"H27","v":581.59999999999991},{"$f":"I27","v":756.87678471999993},37.520000000000003,{"$f":"E28-(E23+SUM(E24:E27))","v":76.100000000000023},{"$f":"(D27-D28)*Unmeasured_Gains_Losses!$B$8","v":8.2068627450985616},{"$f":"M27+L28","v":651.00000000000057},7.6497890295358695E-2,7.6497890295358695E-2,null,{"$f":"((Q27*M27)+(L28*N28))/M28","v":0.21854891316756855},767.40189671909479,{"$f":"F28*M28*$T$2","v":737.38366380000059},{"$f":"S28-(S23+(SUM(S24:S27)))","v":-86.802101539999398},{"$f":"(D27-D28)*Unmeasured_Gains_Losses!$C$8","v":-9.3610109503926839},{"$f":"(T28/K28)*$T$3","v":-0.2114717477003927},{"$f":"((W27*M27)+(U28*$T$3))/M28","v":0.21125481699445567},741.78976643223973,"instantaneous Q on different day, likely lower on 8/21/12"]
["D","Phyllis Canal",null,41.41,-328,null,0.21,{"$f":"H28+E29","v":253.59999999999991},{"$f":"I28+(G29*E29*$T$2)","v":385.35321832},null,null,{"$f":"(D28-D29)*Unmeasured_Gains_Losses!$B$9","v":-9.0328638497651852},{"$f":"M28+E29+L29","v":313.96713615023538},8.0661040787623081E-2,8.0661040787623081E-2,null,{"$f":"((Q28*M28)+(E29*Q28)+(L29*Q28))/M29","v":0.21854891316756858},370.10595359316852,{"$f":"(G29*E29*$T$2)","v":-371.52356639999994},null,{"$f":"(D28-D29)*Unmeasured_Gains_Losses!$C$9","v":-9.2289348403755245},null,{"$f":"((W28*M28)+(E29*G29)+(U29*$T$3))/M29","v":0.2131938196471358},361.03726519186426]
["M","GAIN FROM NORTH CHANNEL","Gain from N. Channel",40.199999999999996,{"$f":"North_Channel!L16","v":92},0.08,null,{"$f":"H29+E30","v":345.59999999999991},{"$f":"I29+(F30*E30*$T$2)","v":425.05143912},null,null,{"$f":"(D29-D30)*Unmeasured_Gains_Losses!$B$9","v":-29.539906103286373},{"$f":"M29+E30+L30","v":376.42723004694898},9.4275668073136448E-2,9.4275668073136448E-2,{"$f":"North_Channel!P16","v":7.7191501734651974E-2},{"$f":"((P30*E30)+(Q29*M29)+(L30*Q29))/(M30)","v":0.18400071682638913},373.58873775809252,{"$f":"(F30*E30*$T$2)","v":39.698220800000001},null,{"$f":"(D29-D30)*Unmeasured_Gains_Losses!$C$9","v":-30.18111123474181},null,{"$f":"((W29*M29)+(F30*E30)+(U30*$T$3))/M30","v":0.18250622593075755},370.55437475712245,"TP result from North Channel sample upstream (RM 41.8)"]
["M","Boise River Below Eagle Island, ID",434050116260100,39.65,363,0.18,null,{"$f":"H30","v":345.59999999999991},{"$f":"I30","v":425.05143912},43.48,{"$f":"E31-(E28+SUM(E29:E30))","v":-52},{"$f":"(D30-D31)*Unmeasured_Gains_Losses!$B$9","v":-13.427230046948273},{"$f":"M30+L31","v":363.00000000000068},0.10046413502109704,0.10046413502109704,null,{"$f":"((Q30*M30)+(L31*Q30))/M31","v":0.18400071682638913},360.262757264595,{"$f":"F31*M31*$T$2","v":352.42958520000059},{"$f":"S31-(S28+(SUM(S29:S30)))","v":-53.128733000000068},{"$f":"(D30-D31)*Unmeasured_Gains_Losses!$C$9","v":-13.71868692488256},{"$f":"(T31/K31)*$T$3","v":0.18942307692307719},{"$f":"((W30*M30)+(U31*$T$3))/M31","v":0.18225037427931312},356.8356878322399]
["R","Eureka No. 1 Canal at Star Road near Star, ID",13209490,36.629999999999995,2.59,0.16,null,{"$f":"H31+E32","v":348.18999999999988},{"$f":"I31+(F32*E32*$T$2)","v":427.28662155199999},null,null,{"$f":"(D31-D32)*Unmeasured_Gains_Losses!$B$10","v":0.38098461538463907},{"$f":"M31+E32+L32","v":365.97098461538531},0.13444444444444448,0.13444444444444448,{"$f":"F32","v":0.16},{"$f":"((P32*E32)+(Q31*M31)+(L32*N32))/M32","v":0.18377927294870344},362.77421593109619,{"$f":"(F32*E32*$T$2)","v":2.2351824319999998},null,{"$f":"(D31-D32)*Unmeasured_Gains_Losses!$C$10","v":-54.402972864197054},null,{"$f":"((W31*M31)+(F32*E32)+(U32*$T$3))/M32","v":0.15434295552477983},304.66789740004288]
["M","Boise River near Star, ID",13210000,36.4,366,0.15,null,{"$f":"H32","v":348.18999999999988},{"$f":"I32","v":427.28662155199999},19.59,{"$f":"E33-(E31+SUM(E32))","v":0.41000000000002501},{"$f":"(D32-D33)*Unmeasured_Gains_Losses!$B$10","v":2.9015384615385994E-2},{"$f":"M32+L33","v":366.00000000000068},0.13703234880450071,0.13703234880450071,null,{"$f":"((Q32*M32)+(L33*N33))/M33","v":0.18377556699246403},362.79566185013687,{"$f":"F33*M33*$T$2","v":296.1185220000005},{"$f":"S33-(S31+S32)","v":-58.54624563200008},{"$f":"(D32-D33)*Unmeasured_Gains_Losses!$C$10","v":-4.1432727678030261},{"$f":"(T33/K33)*$T$3","v":-26.474146341461839},{"$f":"((W32*M32)+(U33*$T$3))/M33","v":0.1522319285884991},300.52462463223986]
["D","Canyon County Canal",null,36.32,-68,null,0.15,{"$f":"H33+E34","v":280.18999999999988},{"$f":"I33+(G34*E34*$T$2)","v":372.27006555200001},null,null,{"$f":"(D33-D34)*Unmeasured_Gains_Losses!$B$11","v":-0.16096579476860826},{"$f":"M33+E34+L34","v":297.83903420523205},0.13793248945147679,0.13793248945147679,null,{"$f":"((Q33*M33)+(E34*Q33)+(L34*Q33))/M34","v":0.18377556699246403},295.23144682866808,{"$f":"(G34*E34*$T$2)","v":-55.016555999999994},null,{"$f":"(D33-D34)*Unmeasured_Gains_Losses!$C$11","v":0.52874237746477959},null,{"$f":"((W33*M33)+(E34*G34)+(U34*$T$3))/M34","v":0.15315290742237961},246.03681100970468]
["D","Caldwell Highline Canal",null,36.269999999999996,-35,null,0.15,{"$f":"H34+E35","v":245.18999999999988},{"$f":"I34+(G35*E35*$T$2)","v":343.95272055200002},null,null,{"$f":"(D34-D35)*Unmeasured_Gains_Losses!$B$11","v":-0.10060362173039089},{"$f":"M34+E35+L35","v":262.73843058350167},0.13849507735583691,0.13849507735583691,null,{"$f":"((Q34*M34)+(E35*Q34)+(L35*Q34))/M35","v":0.183775566992464},260.43814977324467,{"$f":"(G35*E35*$T$2)","v":-28.317344999999996},null,{"$f":"(D34-D35)*Unmeasured_Gains_Losses!$C$11","v":0.33046398591552251},null,{"$f":"((W34*M34)+(E35*G35)+(U35*$T$3))/M35","v":0.15386474505559897},218.0499299956202]
["D","Otter Mitigation",null,35.739999999999995,0,null,0.15,{"$f":"H35+E36","v":245.18999999999988},{"$f":"I35+(G36*E36*$T$2)","v":343.95272055200002},null,null,{"$f":"(D35-D36)*Unmeasured_Gains_Losses!$B$11","v":-1.0663983903420549},{"$f":"M35+E36+L36","v":261.67203219315962},0.14445850914205352,0.14445850914205352,null,{"$f":"((Q35*M35)+(E36*Q35)+(L36*Q35))/M36","v":0.183775566992464},259.38108772455593,{"$f":"(G36*E36*$T$2)","v":0},null,{"$f":"(D35-D36)*Unmeasured_Gains_Losses!$C$11","v":3.5029182507042473},null,{"$f":"((W35*M35)+(E36*G36)+(U36*$T$3))/M36","v":0.15697366628557388},221.55284824632446]
["M","Boise River near Middleton, ID",13210050,31.43,253,0.18,null,{"$f":"H36","v":245.18999999999988},{"$f":"I36","v":343.95272055200002},29.87,{"$f":"E37-(E33+SUM(E34:E36))","v":-10},{"$f":"(D36-D37)*Unmeasured_Gains_Losses!$B$11","v":-8.6720321931589446},{"$f":"M36+L37","v":253.00000000000068},0.19295358649789029,0.19295358649789029,null,{"$f":"((Q36*M36)+(L37*Q36))/M37","v":0.18377556699246397},250.78497936635159,{"$f":"F37*M37*$T$2","v":245.63274120000062},{"$f":"S37-(S33+(SUM(S34:S36)))","v":32.848120200000125},{"$f":"(D36-D37)*Unmeasured_Gains_Losses!$C$11","v":28.485995585915578},{"$f":"(T37/K37)*$T$3","v":-0.60900000000000232},{"$f":"((W36*M36)+(U37*$T$3))/M37","v":0.18322879787901455},250.03884383224005,"Idaho Power Gage - mean daily Q"]
["R","Fifteenmile Creek at Mouth near Middleton, ID",13210815,30.310000000000002,92.8,0.3,null,{"$f":"H37+E38","v":337.9899999999999},{"$f":"I37+(F38*E38*$T$2)","v":494.11555575199998},null,null,{"$f":"(D37-D38)*Unmeasured_Gains_Losses!$B$12","v":45.924324324324218},{"$f":"M37+E38+L38","v":391.72432432432493},0.20555555555555552,0.20555555555555552,{"$f":"F38","v":0.3},{"$f":"((P38*E38)+(Q37*M37)+(L38*N38))/M38","v":0.21386269181418641},451.86509776635148,{"$f":"(F38*E38*$T$2)","v":150.16283519999999},null,{"$f":"(D37-D38)*Unmeasured_Gains_Losses!$C$12","v":60.783527264864823},null,{"$f":"((W37*M37)+(F38*E38)+(U38*$T$3))/M38","v":0.21817913707553951},460.98520629710481,"includes Fivemile Creek + Meridian WWTP + Tenmile Creek"]
["M","Boise River at Middleton Road near Middleton, ID",13210820,28.84,452,0.22,null,{"$f":"H38","v":337.9899999999999},{"$f":"I38","v":494.11555575199998},30.64,{"$f":"E39-(E37+E38)","v":106.19999999999999},{"$f":"(D38-D39)*Unmeasured_Gains_Losses!$B$12","v":60.275675675675778},{"$f":"M38+L39","v":452.00000000000068},0.25,0.25,null,{"$f":"((Q38*M38)+(L39*N39))/M39","v":0.21868171984073514},533.1435312528381,{"$f":"F39*M39*$T$2","v":536.35748320000084},{"$f":"S39-(S37+S38)","v":140.5619068000002},{"$f":"(D38-D39)*Unmeasured_Gains_Losses!$C$12","v":79.778379535135386},{"$f":"(T39/K39)*$T$3","v":0.24538606403013224},{"$f":"((W38*M38)+(U39*$T$3))/M39","v":0.22180726960927141},540.76358583224021]
["R","Mill Slough below Grade Ditch near Middleton, ID",132108247,27.23,122,0.19,null,{"$f":"H39+E40","v":459.9899999999999},{"$f":"I39+(F40*E40*$T$2)","v":619.14337615199997},null,null,{"$f":"(D39-D40)*Unmeasured_Gains_Losses!$B$13","v":45.149567901234555},{"$f":"M39+E40+L40","v":619.14956790123529},0.25,{"$f":"O39","v":0.25},{"$f":"F40","v":0.19},{"$f":"((P40*E40)+(Q39*M39)+(L40*N40))/M40","v":0.21531393423274831},719.05306074141845,{"$f":"(F40*E40*$T$2)","v":125.02782039999998},null,{"$f":"(D39-D40)*Unmeasured_Gains_Losses!$C$13","v":54.361929790835454},null,{"$f":"((W39*M39)+(F40*E40)+(U40*$T$3))/M40","v":0.21564340171236432},720.15333602307567,"sum of North and South Middleton Drains, Star, Watts, Long Feeders. Middleton WWTP discharges below sampling location"]
[0.3,"Middleton WWTP on Boise River near Middleton, ID",434149116382200,27.1,1.01,3.23,null,460.99999999999989,636.739504646,null,null,{"$f":"(D40-D41)*Unmeasured_Gains_Losses!$B$13","v":3.6456172839505898},623.80518518518591,0.25,{"$f":"O40","v":0.25},{"$f":"F41","v":3.23},{"$f":"((P41*E41)+(Q40*M40)+(L41*N41))/M41","v":0.22039770897943758},741.56510363387531,17.596128493999998,null,{"$f":"(D40-D41)*Unmeasured_Gains_Losses!$C$13","v":4.3894725918065571},null,{"$f":"((W40*M40)+(E41*F41)+(U41*$T$3))/M41","v":0.22056825581694045},{"$f":"W41*M41*$T$2","v":742.13893710888226},"1.0 ft3/s on 8/22/12"]
["R","Willow Creek at Middleton, ID",13210835,26.95,31.6,0.19,null,492.59999999999991,669.12375976600003,null,null,{"$f":"(D41-D42)*Unmeasured_Gains_Losses!$B$13","v":4.2064814814815419},659.61166666666747,0.25,0.25,{"$f":"F42","v":0.19},{"$f":"((P42*E42)+(Q41*M41)+(L42*N42))/M42","v":0.21913022667581528},779.6215676751716,32.384255119999999,null,{"$f":"(D41-D42)*Unmeasured_Gains_Losses!$C$13","v":5.0647760674692153},null,{"$f":"((W41*M41)+(F42*E42)+(U42*$T$3))/M42","v":0.21912078281253303},779.58796829635151]
["R","Mason Slough near Caldwell, ID",13210849,25.57,13.2,0.22,null,505.7999999999999,684.78729688600004,null,null,{"$f":"(D42-D43)*Unmeasured_Gains_Losses!$B$13","v":38.699629629629605},711.51129629629713,0.25,0.25,{"$f":"F43","v":0.22},{"$f":"((P43*E43)+(Q42*M42)+(L43*N43))/M43","v":0.22082539273790616},847.46942687109743,15.663537119999999,null,{"$f":"(D42-D43)*Unmeasured_Gains_Losses!$C$13","v":46.595939820716083},null,{"$f":"((W42*M42)+(F43*E43)+(U43*$T$3))/M43","v":0.2193604710983332},841.84744523706752]
["R","Mason Creek near Caldwell, ID",13210983,24.95,155,0.31,null,660.8,943.95842588599999,null,null,{"$f":"(D43-D44)*Unmeasured_Gains_Losses!$B$13","v":17.386790123456819},883.89808641975401,0.25,0.25,{"$f":"F44","v":0.31},{"$f":"((P44*E44)+(Q43*M43)+(L44*N44))/M44","v":0.23703689621232371},1130.0856860791223,259.17112899999995,null,{"$f":"(D43-D44)*Unmeasured_Gains_Losses!$C$13","v":20.934407745539158},null,{"$f":"((W43*M43)+(F44*E44)+(U44*$T$3))/M44","v":0.23533105128339651},1121.9529819826068]
["D","Riverside Canal at HWY 20-26 Xing at Caldwell, ID",132109853,24.57,-224,0.25,null,436.79999999999995,641.90674588599995,null,null,{"$f":"(D44-D45)*Unmeasured_Gains_Losses!$B$13","v":10.656419753086393},670.55450617284043,0.25,0.25,null,{"$f":"((Q44*M44)+(L45*N45)+(E45*Q44))/M45","v":0.23724290523022257},{"$f":"Q45*M45*$T$2","v":858.06571112140091},-302.05167999999998,null,{"$f":"(D44-D45)*Unmeasured_Gains_Losses!$C$13","v":12.830766037588463},null,{"$f":"((W44*M44)+(F45*E45)+(U45*$T$3))/M45","v":0.23023851499355769},832.73206802019513,"181 ft3/s measured by IDWR on 8/22/12"]
["R","Hartley Drain near Caldwell, ID",13210988,24.43,34.9,0.24,null,471.69999999999993,687.08504716599998,null,null,{"$f":"(D45-D46)*Unmeasured_Gains_Losses!$B$13","v":3.9260493827160658},709.3805555555565,0.25,0.25,{"$f":"F46","v":0.24},{"$f":"((P46*E46)+(Q45*M45)+(L46*N46))/M46","v":0.2374491522021272},908.53807406127748,45.178301279999992,null,{"$f":"(D45-D46)*Unmeasured_Gains_Losses!$C$13","v":4.7271243296378866},null,{"$f":"((W45*M45)+(F46*E46)+(U46*$T$3))/M46","v":0.23067995777805878},882.6374936298331]
["D","Sebree Canal",null,24.03,-321,null,0.24,150.69999999999993,{"$f":"I46+(G47*E47*$T$2)","v":271.54823596600005},null,null,{"$f":"(D46-D47)*Unmeasured_Gains_Losses!$B$13","v":11.217283950617245},{"$f":"M46+E47+L47","v":399.59783950617373},0.25,0.25,null,{"$f":"((Q46*M46)+(E47*Q46)+(L47*N47))/M47","v":0.23780147248429817},512.54369981717014,{"$f":"(G47*E47*$T$2)","v":-415.53681119999993},null,{"$f":"(D46-D47)*Unmeasured_Gains_Losses!$C$13","v":13.506069513251001},null,{"$f":"((W46*M46)+(E47*G47)+(U47*$T$3))/M47","v":0.22298390037518628},480.60675194308419,"Also known as Farmer's Co-op Ditch"]
["D","Campbell Canal",null,24.02,-19,null,0.24,131.69999999999993,{"$f":"I47+(G48*E48*$T$2)","v":246.95259916600006},null,null,{"$f":"(D47-D48)*Unmeasured_Gains_Losses!$B$13","v":0.28043209876547598},{"$f":"M47+E48+L48","v":380.87827160493919},0.25,0.25,null,{"$f":"((Q47*M47)+(E48*Q47)+(L48*N48))/M48","v":0.23781045398554965},488.55151937971914,{"$f":"(G48*E48*$T$2)","v":-24.595636799999998},null,{"$f":"(D47-D48)*Unmeasured_Gains_Losses!$C$13","v":0.33765173783132901},null,{"$f":"((W47*M47)+(E48*G48)+(U48*$T$3))/M48","v":0.22213523676168792},456.34876688091549,"Include this in model because Campbell Canal is diverted before Sebree Canal is measured"]
["M","Boise River at HWY 20-26 Crossing near Caldwell, ID",13211000,23.98,382,0.22,null,{"$f":"H48","v":131.69999999999993},{"$f":"I48","v":246.95259916600006},94.93,{"$f":"E49-(E39+(SUM(E40:E48)))","v":136.29},{"$f":"(D48-D49)*Unmeasured_Gains_Losses!$B$13","v":1.1217283950617045},{"$f":"M48+L49","v":382.00000000000091},0.25,0.25,null,{"$f":"((Q48*M48)+(L49*N49))/M49","v":0.23784624812138033},490.06410842539816,{"$f":"F49*M49*$T$2","v":453.29327120000107},{"$f":"S49-(S39+(SUM(S40:S48)))","v":164.09874458600024},{"$f":"(D48-D49)*Unmeasured_Gains_Losses!$C$13","v":1.350606951325076},{"$f":"(T49/K49)*$T$3","v":0.22322767627852411},{"$f":"((W48*M48)+(U49*$T$3))/M49","v":0.22213844466856209},457.69937383224061,"Measuring section did not include Seebree Q or Campbell Q, WQ at Seebree & Cambell assumed the same"]
["D","Shipley Pumps",null,23.19,0,null,0.22,{"$f":"H49+E50","v":131.69999999999993},{"$f":"I49+(G50*E50*$T$2)","v":246.95259916600006},null,null,{"$f":"(D49-D50)*Unmeasured_Gains_Losses!$B$14","v":3.3613725490196105},{"$f":"M49+E50+L50","v":385.36137254902053},0.25,0.25,null,{"$f":"((Q49*M49)+(E50*Q49)+(L50*N50))/M50","v":0.23795226105065281},494.59673443226092,{"$f":"(G50*E50*$T$2)","v":0},null,{"$f":"(D49-D50)*Unmeasured_Gains_Losses!$C$14","v":6.1284445641177561},null,{"$f":"((W49*M49)+(E50*G50)+(U50*$T$3))/M50","v":0.22314922530229722},463.8278183963584]
["D","Wagner Pumps",null,23.09,-0.4,null,0.22,{"$f":"H50+E51","v":131.29999999999993},{"$f":"I50+(G51*E51*$T$2)","v":246.47794652600007},null,null,{"$f":"(D50-D51)*Unmeasured_Gains_Losses!$B$14","v":0.42549019607843824},{"$f":"M50+E51+L51","v":385.38686274509899},0.25,0.25,null,{"$f":"((Q50*M50)+(E51*Q50)+(L51*N51))/M51","v":0.23796556247657932},494.65709970106798,{"$f":"(G51*E51*$T$2)","v":-0.47465264000000001},null,{"$f":"(D50-D51)*Unmeasured_Gains_Losses!$C$14","v":0.77575247647061385},null,{"$f":"((W50*M50)+(E51*G51)+(U51*$T$3))/M51","v":0.22327931643085039},464.12891823282911]
["R","Caldwell WWTP on Boise River at Caldwell, ID",434038116420900,22.55,12.85,1.83,null,{"$f":"H51+E52","v":144.14999999999992},{"$f":"I51+(F52*E52*$T$2)","v":373.31538011600003},null,null,{"$f":"(D51-D52)*Unmeasured_Gains_Losses!$B$14","v":2.29764705882353},{"$f":"M51+E52+L52","v":400.53450980392256},0.25,0.25,{"$f":"F52","v":1.83},{"$f":"((P52*E52)+(Q51*M51)+(L52*N52))/M52","v":0.28911045239426608},624.59278397930336,{"$f":"(F52*E52*$T$2)","v":126.83743358999999},null,{"$f":"(D51-D52)*Unmeasured_Gains_Losses!$C$14","v":4.1890633729412485},null,{"$f":"((W51*M51)+(E52*F52)+(U52*$T$3))/M52","v":0.27548453287582014},595.15541519577039]
["R","Indian Creek at Mouth near Caldwell, ID",13211445,22.44,69.7,0.45,null,{"$f":"H52+E53","v":213.84999999999991},{"$f":"I52+(F53*E53*$T$2)","v":542.49128981600006},null,null,{"$f":"(D52-D53)*Unmeasured_Gains_Losses!$B$14","v":0.46803921568627299},{"$f":"M52+E53+L53","v":470.7025490196088},0.25,0.25,{"$f":"F53","v":0.45},{"$f":"((P53*E53)+(Q52*M52)+(L53*N53))/M53","v":0.31289552911835566},794.3998188194995,{"$f":"(F53*E53*$T$2)","v":169.17590970000001},null,{"$f":"(D52-D53)*Unmeasured_Gains_Losses!$C$14","v":0.85332772411765867},null,{"$f":"((W52*M52)+(F53*E53)+(U53*$T$3))/M53","v":0.30138835770447953},765.18465261988808]
["M","Boise River below WWTP near Caldwell, ID",13211600,21.43,475,0.3,null,{"$f":"H53","v":213.84999999999991},{"$f":"I53","v":542.49128981600006},85.93,{"$f":"E54-(E49+(SUM(E50:E53)))","v":10.850000000000023},{"$f":"(D53-D54)*Unmeasured_Gains_Losses!$B$14","v":4.2974509803921714},{"$f":"M53+L54","v":475.00000000000097},0.25,0.25,null,{"$f":"((Q53*M53)+(L54*N54))/M54","v":0.31232649658515155},800.19469510675447,{"$f":"F54*M54*$T$2","v":768.61365000000148},{"$f":"S54-(S49+(SUM(S50:S53)))","v":19.781688150000377},{"$f":"(D53-D54)*Unmeasured_Gains_Losses!$C$14","v":7.8351000123531005},{"$f":"(T54/K54)*$T$3","v":0.33801843317972924},{"$f":"((W53*M53)+(U54*$T$3))/M54","v":0.3017197597124015},773.01975263224108]
["D","Simplot Pumps",null,20.079999999999998,-0.4,null,0.3,{"$f":"H54+E55","v":213.4499999999999},{"$f":"I54+(G55*E55*$T$2)","v":541.84403621600006},null,null,{"$f":"(D54-D55)*Unmeasured_Gains_Losses!$B$15","v":18.811091854419427},{"$f":"M54+E55+L55","v":493.41109185442042},0.25,0.25,null,{"$f":"((Q54*M54)+(E55*Q54)+(L55*N55))/M55","v":0.30995032492711072},824.88656969808665,{"$f":"(G55*E55*$T$2)","v":-0.64725359999999987},null,{"$f":"(D54-D55)*Unmeasured_Gains_Losses!$C$15","v":41.291863112651711},null,{"$f":"((W54*M54)+(E55*G55)+(U55*$T$3))/M55","v":0.3057335913721142},813.66436214489272]
["D","Eureka No.2 Canal",null,20.079999999999998,-106,null,0.3,107.4499999999999,370.32183221600008,null,null,{"$f":"(D55-D56)*Unmeasured_Gains_Losses!$B$15","v":0},{"$f":"M55+E56+L56","v":387.41109185442042},0.25,0.25,null,0.30995032492711072,647.67536015803944,-171.52220399999996,null,{"$f":"(D55-D56)*Unmeasured_Gains_Losses!$C$15","v":0},null,0.30730236598446442,642.14215814489273]
["D","Upper Center Point Canal",null,20.080000000000002,-19,null,0.3,88.449999999999903,339.57728621600006,null,null,{"$f":"(D56-D57)*Unmeasured_Gains_Losses!$B$15","v":-4.9504017292124823E-14},368.41109185442036,0.25,0.25,null,0.30995032492711072,615.91108674991767,-30.744546,null,{"$f":"(D56-D57)*Unmeasured_Gains_Losses!$C$15","v":-1.086653088173892E-13},null,0.30767896961223917,611.39761214489272]
["D","McManus and Teater Canal",null,20,0,null,0.3,88.449999999999903,339.57728621600006,null,null,{"$f":"(D57-D58)*Unmeasured_Gains_Losses!$B$15","v":1.1147313691508054},369.52582322357119,0.25,0.25,null,0.30976947556940126,617.41424069099219,0,null,{"$f":"(D57-D58)*Unmeasured_Gains_Losses!$C$15","v":2.4469252214905257},null,0.30797848168891528,613.84453736638318]
["D","Vale Pumps",null,19.07,0,null,0.3,88.449999999999903,339.57728621600006,null,null,{"$f":"(D58-D59)*Unmeasured_Gains_Losses!$B$15","v":12.95875216637781},382.48457538994899,0.25,0.25,null,0.30774445842922354,634.88840525598357,0,null,{"$f":"(D58-D59)*Unmeasured_Gains_Losses!$C$15","v":28.445505699826697},null,0.31133219605451373,642.29004306620993]
["D","Lower Center Point Canal",null,18.059999999999999,-39,null,0.32,49.449999999999903,272.26291181600004,null,null,{"$f":"(D59-D60)*Unmeasured_Gains_Losses!$B$15","v":14.073483535528617},357.55805892547761,0.25,0.25,null,0.30547163681414408,589.12939346758083,-67.314374399999991,null,{"$f":"(D59-D60)*Unmeasured_Gains_Losses!$C$15","v":30.892430921317224},null,0.31415088455378737,605.86809958752701]
["M","Boise River at Notus, ID",13212500,15.66,391,0.32,null,{"$f":"H60","v":49.449999999999903},{"$f":"I60","v":272.26291181600004},45.16,{"$f":"E61-(E54+(SUM(E55:E60)))","v":80.399999999999977},{"$f":"(D60-D61)*Unmeasured_Gains_Losses!$B$15","v":33.441941074523371},{"$f":"M60+L61","v":391.00000000000097},0.25,0.25,null,{"$f":"((Q60*M60)+(L61*N61))/M61","v":0.30072718870763265},634.22401169981629,{"$f":"F61*M61*$T$2","v":674.86975360000167},{"$f":"S61-(S54+(SUM(S55:S60)))","v":176.48448160000009},{"$f":"(D60-D61)*Unmeasured_Gains_Losses!$C$15","v":73.407756644714041},{"$f":"(T61/K61)*$T$3","v":0.40696517412935362},{"$f":"((W60*M60)+(U61*$T$3))/M61","v":0.32208922215700941},679.27585623224104]
["D","Bowman and Swisher Canal",null,14.98,-11,null,0.32,{"$f":"H61+E62","v":38.449999999999903},{"$f":"I61+(G62*E62*$T$2)","v":253.27680621600004},null,null,{"$f":"(D61-D62)*Unmeasured_Gains_Losses!$B$16","v":3.5332365747460024},383.53323657474698,0.25,0.25,null,{"$f":"((Q61*M61)+(E62*Q61)+(L62*N62))/M62","v":0.30025987286278821},621.14576763786772,{"$f":"(G62*E62*$T$2)","v":-18.986105599999998},null,{"$f":"(D61-D62)*Unmeasured_Gains_Losses!$C$16","v":3.0545234477793524},null,{"$f":"((W61*M61)+(E62*G62)+(U62*$T$3))/M62","v":0.32065849560073995},663.34427408002034]
["R","Conway Gulch at Notus. ID",13212550,14.219999999999999,37,0.32,null,75.449999999999903,{"$f":"I62+(F63*E63*$T$2)","v":317.13916141600004},null,null,{"$f":"(D62-D63)*Unmeasured_Gains_Losses!$B$16","v":3.9489114658926008},{"$f":"M62+E63+L63","v":424.48214804063957},0.25,0.25,{"$f":"F63","v":0.32},{"$f":"((P63*E63)+(Q62*M62)+(L63*N63))/M63","v":0.30151295951981233},690.33301275949327,{"$f":"(F63*E63*$T$2)","v":63.862355199999996},null,{"$f":"(D62-D63)*Unmeasured_Gains_Losses!$C$16","v":3.4138791475181081},null,{"$f":"((W62*M62)+(F63*E63)+(U63*$T$3))/M63","v":0.31910910779317608},730.62050842753854,"includes Notus WWTP - seasonal discharge not during synoptic"]
["D","Baxter Canal",null,13.329999999999998,-14,null,0.32,61.449999999999903,{"$f":"I63+(G64*E64*$T$2)","v":292.97502701600001},null,null,{"$f":"(D63-D64)*Unmeasured_Gains_Losses!$B$16","v":4.6243831640058017},415.10653120464536,0.25,0.25,null,{"$f":"((Q63*M63)+(E64*Q63)+(L64*N64))/M64","v":0.30093909318713813},673.8006151238983,{"$f":"(G64*E64*$T$2)","v":-24.164134400000002},null,{"$f":"(D63-D64)*Unmeasured_Gains_Losses!$C$16","v":3.9978321595935684},null,{"$f":"((W63*M63)+(E64*G64)+(U64*$T$3))/M64","v":0.31730966069484734},710.45420618713217]
["R","Unnamed Drain Near Notus, ID",434335116510400,12.329999999999998,12.2,0.21,null,73.649999999999906,{"$f":"I64+(F65*E65*$T$2)","v":306.79389137600003},null,null,{"$f":"(D64-D65)*Unmeasured_Gains_Losses!$B$16","v":5.1959361393323586},{"$f":"M64+E65+L65","v":432.50246734397768},0.25,0.25,{"$f":"F65","v":0.21},{"$f":"((P65*E65)+(Q64*M64)+(L65*N65))/M65","v":0.2977619246948574},694.62591359130022,{"$f":"(F65*E65*$T$2)","v":13.818864359999997},null,{"$f":"(D64-D65)*Unmeasured_Gains_Losses!$C$16","v":4.4919462467343436},null,{"$f":"((W64*M64)+(F65*E65)+(U65*$T$3))/M65","v":0.31239616864984687},728.76501679386661]
["D","Andrews Canal",null,11.09,-20,null,0.32,53.649999999999906,{"$f":"I65+(G66*E66*$T$2)","v":272.27369937600002},null,null,{"$f":"(D65-D66)*Unmeasured_Gains_Losses!$B$16","v":6.4429608127721165},{"$f":"M65+E66+L66","v":418.94542815674981},0.25,0.25,null,{"$f":"((Q65*M65)+(E66*Q65)+(L66*N66))/M66","v":0.29702739416064089},671.19264560086617,{"$f":"(G66*E66*$T$2)","v":-34.520192000000002},null,{"$f":"(D65-D66)*Unmeasured_Gains_Losses!$C$16","v":5.5700133459505787},null,{"$f":"((W65*M65)+(E66*G66)+(U66*$T$3))/M66","v":0.30969376546361899},699.81483813981708]
["R","Unnamed Drain Near Dixie Drain near Notus, ID",434348116523600,10.93,23,0.2,null,76.649999999999906,{"$f":"I66+(F67*E67*$T$2)","v":297.08508737600005},null,null,{"$f":"(D66-D67)*Unmeasured_Gains_Losses!$B$16","v":0.83134978229317813},442.77677793904297,0.25,0.25,{"$f":"F67","v":0.2},{"$f":"((P67*E67)+(Q66*M66)+(L67*N67))/M67","v":0.29189901708052085},697.1250630580505,{"$f":"(F67*E67*$T$2)","v":24.811388000000001},null,{"$f":"(D66-D67)*Unmeasured_Gains_Losses!$C$16","v":0.71871139947749563},null,{"$f":"((W66*M66)+(F67*E67)+(U67*$T$3))/M67","v":0.3037151947790766},725.34493753929462]
["R","Dixie Drain near Wilder, ID",13212890,10.53,264,0.33,null,340.64999999999992,{"$f":"I67+(F68*E68*$T$2)","v":766.99120097600007},null,null,{"$f":"(D67-D68)*Unmeasured_Gains_Losses!$B$16","v":2.0783744557329453},708.85515239477593,0.25,0.25,{"$f":"F68","v":0.33},{"$f":"((P68*E68)+(Q67*M67)+(L68*N68))/M68","v":0.30596617538533721},1169.8337503010116,{"$f":"(F68*E68*$T$2)","v":469.90611359999997},null,{"$f":"(D67-D68)*Unmeasured_Gains_Losses!$C$16","v":1.796778498693739},null,{"$f":"((W67*M67)+(F68*E68)+(U68*$T$3))/M68","v":0.31308392845856275},1197.0478296379886]
["D","Mammon Pumps",null,10,-7,null,0.31,333.64999999999992,{"$f":"I68+(G69*E69*$T$2)","v":755.28669837600012},null,null,{"$f":"(D68-D69)*Unmeasured_Gains_Losses!$B$16","v":2.7538461538461467},{"$f":"M68+E69+L69","v":704.60899854862203},0.25,0.25,null,{"$f":"((Q68*M68)+(E69*Q68)+(L69*N69))/M69","v":0.30574744097072165},1161.994960715645,{"$f":"(G69*E69*$T$2)","v":-11.704502599999998},null,{"$f":"(D68-D69)*Unmeasured_Gains_Losses!$C$16","v":2.3807315107691993},null,{"$f":"((W68*M68)+(E69*G69)+(U69*$T$3))/M69","v":0.31251735485753812},1187.724058548758]
["M","Boise River at HWY 95 Crossing near Parma, ID",13212900,8.77,711,0.31,null,{"$f":"H69","v":333.64999999999992},{"$f":"I69","v":755.28669837600012},39.67,{"$f":"E70-(E61+SUM(E62:E69))","v":35.799999999999955},{"$f":"(D69-D70)*Unmeasured_Gains_Losses!$B$16","v":6.3910014513788029},{"$f":"M69+L70","v":711.0000000000008},0.25,0.25,null,{"$f":"((Q69*M69)+(L70*N70))/M70","v":0.30524634114490656},1170.6128746677493,{"$f":"F70*M70*$T$2","v":1188.8430498000012},{"$f":"S70-(S61+(SUM(S62:S69)))","v":30.949509639999633},{"$f":"(D69-D70)*Unmeasured_Gains_Losses!$C$16","v":5.5250938834832448},{"$f":"(T70/K70)*$T$3","v":0.16027932960893687},{"$f":"((W69*M69)+(U70*$T$3))/M70","v":0.31114892526496596},1193.2491524322411]
["D","Hass Canal",null,8.0500000000000007,-13,null,0.31,{"$f":"H70+E71","v":320.64999999999992},{"$f":"I70+(G71*E71*$T$2)","v":733.54976497600012},null,null,{"$f":"(D70-D71)*Unmeasured_Gains_Losses!$B$17","v":11.299798792756523},{"$f":"M70+E71+L71","v":709.29979879275731},0.25,0.25,null,{"$f":"((Q70*M70)+(E71*Q70)+(L71*N71))/M71","v":0.30436621606939412},1164.4464209216205,{"$f":"(G71*E71*$T$2)","v":-21.736933399999998},null,{"$f":"(D70-D71)*Unmeasured_Gains_Losses!$C$17","v":13.111769104225372},null,{"$f":"((W70*M70)+(E71*G71)+(U71*$T$3))/M71","v":0.30964028422085776},1184.6239881364666]
["D","Parma Canal",null,7.47,-36,null,0.31,{"$f":"H71+E72","v":284.64999999999992},{"$f":"I71+(G72*E72*$T$2)","v":673.35518017600009},null,null,{"$f":"(D71-D72)*Unmeasured_Gains_Losses!$B$17","v":9.1026156941650047},682.40241448692234,0.25,0.25,null,{"$f":"((Q71*M71)+(E72*Q71)+(L72*N72))/M72","v":0.30364102113877872},1117.6201588205508,{"$f":"(G72*E72*$T$2)","v":-60.194584799999994},null,{"$f":"(D71-D72)*Unmeasured_Gains_Losses!$C$17","v":10.562258445070473},null,{"$f":"((W71*M71)+(E72*G72)+(U72*$T$3))/M72","v":0.30836060395603537},1134.991661781537]
["D","Island Highline Canal",null,6.33,-58,null,0.3,{"$f":"H72+E73","v":226.64999999999992},{"$f":"I72+(G73*E73*$T$2)","v":579.50340817600011},null,null,{"$f":"(D72-D73)*Unmeasured_Gains_Losses!$B$17","v":17.891348088531181},642.29376257545357,0.25,0.25,null,{"$f":"((Q72*M72)+(E73*Q72)+(L73*N73))/M73","v":0.30214682917096336},{"$f":"Q73*M73*$T$2","v":1046.7548314079108},{"$f":"(G73*E73*$T$2)","v":-93.851771999999983},null,{"$f":"(D72-D73)*Unmeasured_Gains_Losses!$C$17","v":20.760301081690201},null,{"$f":"((W72*M72)+(E73*G73)+(U73*$T$3))/M73","v":0.306518552327878},{"$f":"W73*M73*$T$2","v":1061.9001908632272}]
["D","Crawforth Pumps",null,4.32,0,null,0.3,{"$f":"H73+E74","v":226.64999999999992},{"$f":"I73+(G74*E74*$T$2)","v":579.50340817600011},null,null,{"$f":"(D73-D74)*Unmeasured_Gains_Losses!$B$17","v":31.545271629778671},673.83903420523222,0.25,0.25,null,{"$f":"((Q73*M73)+(E74*Q73)+(L74*N74))/M74","v":0.29970561427047915},1089.2918952107277,{"$f":"(G74*E74*$T$2)","v":0},null,{"$f":"(D73-D74)*Unmeasured_Gains_Losses!$C$17","v":36.603688749295884},null,{"$f":"((W73*M73)+(E74*G74)+(U74*$T$3))/M74","v":0.30224018141077352},1098.503879612523]
["D","McConnel Island Canal",null,3.9099999999999997,-58,null,0.3,{"$f":"H74+E75","v":168.64999999999992},{"$f":"I74+(G75*E75*$T$2)","v":485.65163617600012},null,null,{"$f":"(D74-D75)*Unmeasured_Gains_Losses!$B$17","v":6.4346076458752606},622.27364185110753,0.25,0.25,null,{"$f":"((Q74*M74)+(E75*Q74)+(L75*N75))/M75","v":0.29919163440034302},1004.2089331256602,{"$f":"(G75*E75*$T$2)","v":-93.851771999999983},null,{"$f":"(D74-D75)*Unmeasured_Gains_Losses!$C$17","v":7.4664240732394704},null,{"$f":"((W74*M74)+(E75*G75)+(U75*$T$3))/M75","v":0.30154820148771372},1012.1185316857625]
["M","Boise River near Parma, ID",13213000,3.8,624,0.3,null,{"$f":"H75","v":168.64999999999992},{"$f":"I75","v":485.65163617600012},42.25,{"$f":"E76-(E70+(SUM(E71:E75)))","v":78},{"$f":"(D75-D76)*Unmeasured_Gains_Losses!$B$17","v":1.7263581488933584},{"$f":"M75+L76","v":624.00000000000091},0.25,0.25,null,{"$f":"((Q75*M75)+(L76*N76))/M76","v":0.29905554084440644},1006.5368321397448,{"$f":"F76*M76*$T$2","v":1009.7156160000014},{"$f":"S76-(S70+(SUM(S71:S75)))","v":90.507628400000272},{"$f":"(D75-D76)*Unmeasured_Gains_Losses!$C$17","v":2.0031869464788774},{"$f":"(T76/K76)*$T$3","v":0.2151282051282058},{"$f":"((W75*M75)+(U76*$T$3))/M76","v":0.30130911196056215},1014.1217186322414]
[null,null,null,null,null,null,null,null,null,null,null,null,"flow-weighted TP in GW gain:",{"$f":"(SUM(,N76*L76,N75*L75,N74*L74,N73*L73,N72*L72,N71*L71,N70*L70,N69*L69,N68*L68,N67*L67,N66*L66,N65*L65,N64*L64,N63*L63,N62*L62,N61*L61,N60*L60,N59*L59,N58*L58,N57*L57,N56*L56,N55*L55,N54*L54,N53*L53,N52*L52,N51*L51,N50*L50,N49*L49,N48*L48,N47*L47,N46*L46,N45*L45,N44*L44,N43*L43,N42*L42,N41*L41,N40*L40,N39*L39,N38*L38,N33*L33,N32*L32,N28*L28,N27*L27,N26*L26,N25*L25,N24*L24,N23*L23,N22*L22,N21*L21,N20*L20,N19*L19,L18*N18,L17*N17,L16*N16,L15*N15,N14*L14))/(SUM(L14:L28,L32:L33,L38:L76))","v":0.2133536862820071}]
[]
["Sites Outside Modeling Reach"]
["R","Sand Hollow Creek at Mouth near Parma, ID",13213080,"NA",169,0.35,null,null,null,null,null,null,null,null,null,"Boise River near Parma + Sand Hollow Creek at Mouth",{"$f":"((Q76*$E$76)+($E$80*$F$80))/($E$76+$E$80)","v":0.30991255673002477},{"$f":"Q80*(E80+M76)*$T$2","v":1325.578919139745},null,null,null,null,{"$f":"((W76*$E$76)+($E$80*$F$80))/($E$76+$E$80)","v":0.31168585859191777},{"$f":"W80*(E80+E76)*$T$2","v":1333.1638056322399}]
["SR","Snake River near Adrian, OR",13173600,"NA",5497,0.05,null,null,null,null,null,null,null,null,null,"Snake River NR Adrian",{"$f":"F81","v":0.05},{"$f":"Q81*E81*$T$2","v":1482.4804329999999},null,null,null,null,0.05,{"$f":"W81*E81*$T$2","v":1482.4804329999999}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"E83-E81-E80-E76","v":-10},null,null,null,null,"Other Sources",null,{"$f":"R83-R81-R80","v":-4.4643232943417388},null,null,null,null,null,{"$f":"X83-X81-X80","v":-4.4763819374122704}]
["SR","Snake River at Nyssa, OR",13213100,"NA",6280,0.09,null,null,null,null,null,null,null,null,null,"Snake River at Nyssa",{"$f":"(($E$81*$F$81)+(Q80*($E$80+$E$76)))/($E$81+$E$80+$E$76)","v":8.2767990061511865E-2},{"$f":"Q83*E83*$T$2","v":2803.5950288454032},null,null,null,null,{"$f":"(($E$81*$F$81)+(W80*($E$80+$E$76)))/($E$81+$E$80+$E$76)","v":8.2991555781143214E-2},{"$f":"W83*E83*$T$2","v":2811.1678566948276}]

{"sheet":"North_Channel","index":2,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Equation No. In Report",null,null,null,null,null,1,3,4,18,5,7,14,9,5]
[null,null,null,"Variable in Report",null,null,null,null,null,"Qgw","Qgwi…n","Qmi…n","Cgw i…n","∆M","∆Mi…n","Cp","Cm","MUS, -MD, +MR"]
["Diversion, Return, or Main-stem",null,null,null,"Measured Discharge","MeasuredTP","Estimated Diversion TP","Net SW Discharge","Discharge Uncertainty Propogation of Errror","Discharge Gain/Loss per Subreach","GW Gain/Loss per RM ","Modeled Flow with GW","Estimated GW TP","Load Gain/Loss per Subreach","Load In/Out per RM","TP","TP","SW Load in/out"]
[null,"Name","Site ID","RM","ft3/s","mg/L","mg/L","ft3/s","ft3/s","ft3/s","ft3/s/mi","ft3/s","mg/L","lbs/d","lbs/d/mi","mg/L","mg/L","lbs/d","Note"]
["D","Loss to North Channel (Boise River North Channel near Eagle, ID)","Computed",45.5,{"$f":"E8-E6-E7","v":177},null,7.0000000000000007E-2,{"$f":"E5","v":177},null,null,null,{"$f":"H5","v":177},{"$f":"Aug.20.2012_Model!N14","v":2.8902953586497887E-2},null,{"$f":"(D5-D6)*Unmeasured_Gains_Losses!$C$18","v":-2.8766826666666594},{"$f":"Aug.20.2012_Model!P15","v":7.3626380159175372E-2},{"$f":"((G5*E5)+(O5*Aug.20.2012_Model!T3))/H5","v":6.6986817325800391E-2},{"$f":"(Aug.20.2012_Model!S15/-1)-R6","v":62.459972399999991},"Computed from measured Q at RM 45.5 = 161 + Ballentyne + Mace Mace"]
["D","Ballentyne Canal",null,44,-16,null,0.06,{"$f":"E6+E5","v":161},null,null,null,{"$f":"H6","v":161},{"$f":"Aug.20.2012_Model!N15","v":3.4528832630098448E-2},null,{"$f":"(D6-D7)*Unmeasured_Gains_Losses!$C$18","v":-2.3013461333333329},{"$f":"((P5*L5)+(E6*P5))/L6","v":7.3626380159175386E-2},{"$f":"((G6*E6)+(Q5*L5)+(O6*Aug.20.2012_Model!$T$3))/L6","v":6.5031055900621137E-2},{"$f":"E6*G6*Aug.20.2012_Model!$T$2","v":-5.178028799999999}]
["D","Mace-Mace Canal",null,42.8,0,null,0.06,{"$f":"H6+E7","v":161},null,null,null,161,{"$f":"Aug.20.2012_Model!N16","v":4.2405063291139265E-2},null,{"$f":"(D7-D8)*Unmeasured_Gains_Losses!$C$18","v":0},{"$f":"((P6*L6)+(E7*P6))/L7","v":7.3626380159175386E-2},{"$f":"((G7*E7)+(Q6*L6)+(O7*Aug.20.2012_Model!$T$3))/L7","v":6.5031055900621137E-2},{"$f":"E7*G7*Aug.20.2012_Model!$T$2","v":0}]
["M","Boise River North Channel near Eagle, ID",13206300,42.8,161,0.06,null,161,23.73,{"$f":"H8-H7","v":0},0,{"$f":"L7+K8","v":161},{"$f":"Aug.20.2012_Model!N17","v":4.5893108298171559E-2},{"$f":"R8-(SUM(R5:R7))","v":-5.1780287999999928},0,{"$f":"((P7*L7)+(K8*M8))/L8","v":7.3626380159175386E-2},{"$f":"((Q7*L7)+(O8*Aug.20.2012_Model!$T$3))/L8","v":6.5031055900621137E-2},{"$f":"E8*F8*Aug.20.2012_Model!$T$2","v":52.103914799999998},"Instantaneous Q"]
["R","Eagle Drain at Eagle, ID",13206400,42.7,40,0.09,null,{"$f":"H8+E9","v":201},null,null,{"$f":"(D8-D9)*Unmeasured_Gains_Losses!$B$19","v":2.97899999999983},{"$f":"L8+K9+E9","v":203.97899999999984},{"$f":"Aug.20.2012_Model!N18","v":4.9718706047819979E-2},null,{"$f":"(D8-D9)*Unmeasured_Gains_Losses!$C$19","v":2.8345932033998391},{"$f":"((P8*L8)+(E9*F9)+(K9*M9))/L9","v":7.6488066080055775E-2},{"$f":"((E9*F9)+(Q8*L8)+(O9*Aug.20.2012_Model!$T$3))/L9","v":7.1554081547610213E-2},{"$f":"E9*F9*Aug.20.2012_Model!$T$2","v":19.417607999999998},"Mean daily Q"]
["R","Dry Creek at Eagle, ID",13208000,42.5,5.21,7.0000000000000007E-2,null,{"$f":"H9+E10","v":206.21},null,null,{"$f":"(D9-D10)*Unmeasured_Gains_Losses!$B$19","v":5.9580000000000828},{"$f":"L9+K10+E10","v":215.14699999999993},{"$f":"Aug.20.2012_Model!N19","v":5.7144866385372681E-2},null,{"$f":"(D9-D10)*Unmeasured_Gains_Losses!$C$19","v":5.6691864068000806},{"$f":"((P9*L9)+(E10*F10)+(K10*M10))/L10","v":7.5795285757494849E-2},{"$f":"((E10*F10)+(Q9*L9)+(O10*Aug.20.2012_Model!$T$3))/L10","v":7.4420233607719322E-2},{"$f":"E10*F10*Aug.20.2012_Model!$T$2","v":1.967111566},"Instantaneous Q"]
["D","Hart-Davis Canal",null,42.1,-8,null,0.08,{"$f":"H10+E11","v":198.21},null,null,{"$f":"(D10-D11)*Unmeasured_Gains_Losses!$B$19","v":11.915999999999954},219.06299999999987,{"$f":"Aug.20.2012_Model!N20","v":6.198312236286916E-2},null,{"$f":"(D10-D11)*Unmeasured_Gains_Losses!$C$19","v":11.33837281359996},{"$f":"((P10*L10)+(E11*F11)+(K11*M11))/L11","v":7.7811950128244822E-2},{"$f":"((G11*E11)+(Q10*L10)+(O11*Aug.20.2012_Model!$T$3))/L11","v":7.9764314375316628E-2},{"$f":"G11*E11*Aug.20.2012_Model!T2","v":-3.4520191999999996}]
["M","Boise River (North Channel) above Middleton Canal, ID",13208600,41.8,228,0.08,null,{"$f":"H11","v":198.21},18.670000000000002,{"$f":"E12-(SUM(E8:E11))","v":29.789999999999992},{"$f":"(D11-D12)*Unmeasured_Gains_Losses!$B$19","v":8.9370000000001237},{"$f":"L11+K12","v":228},{"$f":"Aug.20.2012_Model!N21","v":6.198312236286916E-2},{"$f":"R12-(SUM(R8:R11))","v":28.345932034},{"$f":"(D11-D12)*Unmeasured_Gains_Losses!$C$19","v":8.5037796102001213},{"$f":"((P11*L11)+(K12*M12))/L12","v":7.7191501734652002E-2},{"$f":"((Q11*L11)+(O12*Aug.20.2012_Model!$T$3))/L12","v":8.3552631578947351E-2},{"$f":"E12*F12*Aug.20.2012_Model!$T$2","v":98.382547200000005},"Instantaneous Q"]
["D","Middleton Canal",null,41.5,-117,null,0.08,{"$f":"H12+E13","v":81.210000000000008},null,null,null,{"$f":"K13+L12+E13","v":111},{"$f":"Aug.20.2012_Model!N22","v":6.4458509142053477E-2},null,null,{"$f":"((P12*L12)+(E13*P12)+(K13*M13))/L13","v":7.7191501734651988E-2},{"$f":"((G13*E13)+(Q12*L12)+(O13*Aug.20.2012_Model!$T$3))/L13","v":8.729729729729728E-2},{"$f":"E13*G13*Aug.20.2012_Model!$T$2","v":-50.485780799999993}]
["D","Eagle Island Park",null,41.4,0,null,0.08,{"$f":"H13+E14","v":81.210000000000008},null,null,null,{"$f":"K14+L13+E14","v":111},{"$f":"Aug.20.2012_Model!N23","v":6.5021097046413498E-2},null,null,{"$f":"((P13*L13)+(E14*P13)+(K14*M14))/L14","v":7.7191501734651988E-2},{"$f":"((G14*E14)+(Q13*L13)+(O14*Aug.20.2012_Model!$T$3))/L14","v":8.729729729729728E-2},{"$f":"E14*G14*Aug.20.2012_Model!$T$2","v":0}]
["D","Little Pioneer Canal",null,41.2,-19,null,0.08,{"$f":"H14+E15","v":62.210000000000008},null,null,null,{"$f":"K15+L14+E15","v":92},{"$f":"Aug.20.2012_Model!N24","v":6.6146272855133553E-2},null,null,{"$f":"((P14*L14)+(E15*P14)+(K15*M15))/L15","v":7.7191501734651974E-2},{"$f":"((G15*E15)+(Q14*L14)+(O15*Aug.20.2012_Model!$T$3))/L15","v":8.8804347826086941E-2},{"$f":"E15*G15*Aug.20.2012_Model!$T$2","v":-8.1985455999999992},"Computed Q"]
["R","GAIN FROM North Channel","Computed",40.200000000000003,{"$f":"L16","v":92},null,0.08,null,null,null,null,92,null,null,null,{"$f":"P15","v":7.7191501734651974E-2},{"$f":"Q15","v":8.8804347826086941E-2}]

{"sheet":"Unmeasured_Gains_Losses","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Unaccounted-for Gains and Losses in Discharge and Mass"]
["Equation No. In Report",2,6,null,null,1,5]
["Variable in Report","QgwRM","∆MRM",null,null,"Qgw","∆M"]
[null,"Discharge Gain/Loss Per River Mile","Load Gain/Loss Per River Mile","Beginning Reach\n(RM)","End Reach \n(RM)","Discharge Gain / Loss over Reach","Load Gain/Loss over Reach"]
[null,"ft3/s","lbs/d","mi","mi","ft3/s","lbs/d"]
[null,{"$f":"F6/(D6-E6)","v":-10.411985018726568},{"$f":"G6/(D6-E6)","v":-7.0916495693363932E-2},50.17,47.5,{"$f":"Aug.20.2012_Model!K13","v":-27.799999999999955},{"$f":"Aug.20.2012_Model!T13","v":-0.18934704350128181}]
[null,4.4893617021276615,{"$f":"G7/(D7-E7)","v":20.207165582978718},47.5,42.8,{"$f":"Aug.20.2012_Model!K23","v":21.100000000000023},{"$f":"Aug.20.2012_Model!T23","v":94.973678240000027}]
[null,74.607843137255216,-85.100099549019347,42.8,41.78,{"$f":"Aug.20.2012_Model!K28","v":76.100000000000023},{"$f":"Aug.20.2012_Model!T28","v":-86.802101539999398}]
[null,-24.413145539906075,-24.943067136150237,41.78,39.65,{"$f":"Aug.20.2012_Model!K31","v":-52},{"$f":"Aug.20.2012_Model!T31","v":-53.128733000000068}]
[null,0.12615384615385386,-18.014229425230795,39.65,36.4,{"$f":"Aug.20.2012_Model!K33","v":0.41000000000002501},{"$f":"Aug.20.2012_Model!T33","v":-58.54624563200008}]
[null,-2.0120724346076462,6.6092797183098861,36.4,31.43,{"$f":"Aug.20.2012_Model!K37","v":-10},{"$f":"Aug.20.2012_Model!T37","v":32.848120200000125}]
[null,41.003861003861005,54.27100648648657,31.43,28.84,{"$f":"Aug.20.2012_Model!K39","v":106.19999999999999},{"$f":"Aug.20.2012_Model!T39","v":140.5619068000002}]
[null,28.043209876543212,33.765173783127622,28.84,23.98,{"$f":"Aug.20.2012_Model!K49","v":136.29},{"$f":"Aug.20.2012_Model!T49","v":164.09874458600024}]
[null,4.2549019607843217,7.7575247647060284,23.98,21.43,{"$f":"Aug.20.2012_Model!K54","v":10.850000000000023},{"$f":"Aug.20.2012_Model!T54","v":19.781688150000377}]
[null,13.934142114384747,30.586565268630867,21.43,15.66,{"$f":"Aug.20.2012_Model!K61","v":80.399999999999977},{"$f":"Aug.20.2012_Model!T61","v":176.48448160000009}]
[null,5.1959361393323586,4.4919462467343436,15.66,8.77,{"$f":"Aug.20.2012_Model!K70","v":35.799999999999955},{"$f":"Aug.20.2012_Model!T70","v":30.949509639999633}]
[null,15.694164989939638,18.210790422535268,8.77,3.8,{"$f":"Aug.20.2012_Model!K76","v":78},{"$f":"Aug.20.2012_Model!T76","v":90.507628400000272}]
["Begin North Channel",{"$f":"F18/(D18-E18)","v":0},{"$f":"G18/(D18-E18)","v":-1.9177884444444397},45.5,42.8,{"$f":"North_Channel!J8","v":0},{"$f":"North_Channel!N8","v":-5.1780287999999928}]
[null,{"$f":"F19/(D19-E19)","v":29.789999999999992},{"$f":"G19/(D19-E19)","v":28.345932034},42.8,41.8,{"$f":"North_Channel!J12","v":29.789999999999992},{"$f":"North_Channel!N12","v":28.345932034}]

{"sheet":"Measured_Main_Stem_Data","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["RM","Discharge","Measured TP","Measured Load","Mm TP ","1:1 Line","Cp TP","Cm TP"]
["mile","cfs","mg/L","lbs/d","lbs/d","mg/L","mg/L","mg/L"]
[61.1,1605,1.2E-2,{"$f":"C3*B3*Aug.20.2012_Model!$T$2","v":103.8842028},null,{"$f":"C3","v":1.2E-2}]
[50.17,752,1.4999999999999999E-2,{"$f":"C4*B4*Aug.20.2012_Model!$T$2","v":60.841838399999993},{"$f":"Aug.20.2012_Model!X10","v":61.408185299999992},1.4999999999999999E-2,{"$f":"Aug.20.2012_Model!Q10","v":1.4999999999999999E-2},{"$f":"Aug.20.2012_Model!W10","v":1.4999999999999999E-2}]
[47.5,778,7.0000000000000007E-2,{"$f":"C5*B5*Aug.20.2012_Model!$T$2","v":293.74525880000004},{"$f":"Aug.20.2012_Model!X13","v":311.40392977649867},7.0000000000000007E-2,{"$f":"Aug.20.2012_Model!Q13","v":7.4208304895317628E-2},{"$f":"Aug.20.2012_Model!W13","v":7.6773796937856506E-2}]
[42.8,564,0.27,{"$f":"C6*B6*Aug.20.2012_Model!$T$2","v":821.36481839999999},{"$f":"Aug.20.2012_Model!X23","v":825.77092103223936},0.27,{"$f":"Aug.20.2012_Model!Q23","v":0.24157751462985061},{"$f":"Aug.20.2012_Model!W23","v":0.27144837919040904}]
[41.779999999999994,651,0.21,{"$f":"C7*B7*Aug.20.2012_Model!$T$2","v":737.38366380000002},{"$f":"Aug.20.2012_Model!X28","v":741.78976643223973},0.21,{"$f":"Aug.20.2012_Model!Q28","v":0.21854891316756855},{"$f":"Aug.20.2012_Model!W28","v":0.21125481699445567}]
[39.65,363,0.18,{"$f":"C8*B8*Aug.20.2012_Model!$T$2","v":352.42958519999996},{"$f":"Aug.20.2012_Model!X31","v":356.8356878322399},0.18,{"$f":"Aug.20.2012_Model!Q31","v":0.18400071682638913},{"$f":"Aug.20.2012_Model!W31","v":0.18225037427931312}]
[36.4,366,0.15,{"$f":"C9*B9*Aug.20.2012_Model!$T$2","v":296.11852199999998},{"$f":"Aug.20.2012_Model!X33","v":300.52462463223986},0.15,{"$f":"Aug.20.2012_Model!Q33","v":0.18377556699246403},{"$f":"Aug.20.2012_Model!W33","v":0.1522319285884991}]
[31.43,253,0.18,{"$f":"C10*B10*Aug.20.2012_Model!$T$2","v":245.63274119999997},{"$f":"Aug.20.2012_Model!X37","v":250.03884383224005},0.18,{"$f":"Aug.20.2012_Model!Q37","v":0.18377556699246397},{"$f":"Aug.20.2012_Model!W37","v":0.18322879787901455}]
[28.84,452,0.22,{"$f":"C11*B11*Aug.20.2012_Model!$T$2","v":536.35748319999993},{"$f":"Aug.20.2012_Model!X39","v":540.76358583224021},0.22,{"$f":"Aug.20.2012_Model!Q39","v":0.21868171984073514},{"$f":"Aug.20.2012_Model!W39","v":0.22180726960927141}]
[23.98,382,0.22,{"$f":"C12*B12*Aug.20.2012_Model!$T$2","v":453.29327119999999},{"$f":"Aug.20.2012_Model!X49","v":457.69937383224061},0.22,{"$f":"Aug.20.2012_Model!Q49","v":0.23784624812138033},{"$f":"Aug.20.2012_Model!W49","v":0.22213844466856209}]
[21.43,475,0.3,{"$f":"C13*B13*Aug.20.2012_Model!$T$2","v":768.61364999999989},{"$f":"Aug.20.2012_Model!X54","v":773.01975263224108},0.3,{"$f":"Aug.20.2012_Model!Q54","v":0.31232649658515155},{"$f":"Aug.20.2012_Model!W54","v":0.3017197597124015}]
[15.66,391,0.32,{"$f":"C14*B14*Aug.20.2012_Model!$T$2","v":674.86975359999997},{"$f":"Aug.20.2012_Model!X61","v":679.27585623224104},0.32,{"$f":"Aug.20.2012_Model!Q61","v":0.30072718870763265},{"$f":"Aug.20.2012_Model!W61","v":0.32208922215700941}]
[8.77,711,0.31,{"$f":"C15*B15*Aug.20.2012_Model!$T$2","v":1188.8430497999998},{"$f":"Aug.20.2012_Model!X70","v":1193.2491524322411},0.31,{"$f":"Aug.20.2012_Model!Q70","v":0.30524634114490656},{"$f":"Aug.20.2012_Model!W70","v":0.31114892526496596}]
[3.8,624,0.3,{"$f":"C16*B16*Aug.20.2012_Model!$T$2","v":1009.7156159999998},{"$f":"Aug.20.2012_Model!X76","v":1014.1217186322414},{"$f":"C16","v":0.3},{"$f":"Aug.20.2012_Model!Q76","v":0.29905554084440644},{"$f":"Aug.20.2012_Model!W76","v":0.30130911196056215}]
[null,null,0.6,null,null,0.6]
[null,null,0,null,null,{"$f":"C18","v":0}]

{"sheet":"Major_inflows","index":8,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"x","y","y2","y3"]
[null,"RM","TP range","TP load Range","Q range"]
["Inflow","mile","mg/L","lbs/d","ft3/s"]
["Lander WWTP",50.01,0,0,0]
[null,50.01,0.6,1600,4000]
["West Boise WWTP",44.16,0,0,0]
["West Boise WWTP",44.16,0.6,1600,4000]
["15mile",30.310000000000002,0,0,0]
[null,30.310000000000002,0.6,1600,4000]
["Mason",24.95,0,0,0]
[null,24.95,0.6,1600,4000]
["Caldwell WWTP",22.55,0,0,0]
[null,22.55,0.6,1600,4000]
["Indian",22.44,0,0,0]
[null,22.44,0.6,1600,4000]
["Dixie",10.53,0,0,0]
[null,10.53,0.6,1600,4000]
["North and South Channel Start",45.51,0,0,0]
[null,45.51,0.6,1600,4000]
["North and South Channel End",40.200000000000003,0,0,0]
[null,40.200000000000003,0.6,1600,4000]
["TP target",70,7.0000000000000007E-2]
[null,0,7.0000000000000007E-2]