{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input","Operation","Daily Calculations","Summary","Annual","Variables List","Values","Schematics"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":25,"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":"Input","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,0,6,4],[23,0,23,4],[14,0,14,4]]}
["Walker River Conveyance Agreement"]
["Accounting Tool"]
["DRAFT Version 1A, September 20, 2013"]
[]
["Analysis Date (previous day)","2012-01-01"]
[]
["USGS Gage Flow Data"]
["Gage Name","Gage ID","Avg. Daily Flow"]
["Walker Rv nr Wabuska, NV",10301500,null,"cfs","Qwab",{"$f":"HYPERLINK(Values!B54,\"Get Data\")","v":"Get Data"}]
["Walker River below Weber Reservoir",10301720,null,"cfs","Qwebout",{"$f":"HYPERLINK(Values!B56,\"Get Data\")","v":"Get Data"}]
["Canal No 1 blw Little Dam nr Schurz, NV",10301755,null,"cfs","Qcanal 1",{"$f":"HYPERLINK(Values!B58,\"Get Data\")","v":"Get Data"}]
["Canal No 2 abv Little Dam nr Schurz, NV",10301742,null,"cfs","Qcanal 2",{"$f":"HYPERLINK(Values!B59,\"Get Data\")","v":"Get Data"}]
["Walker Rv abv Little Dam nr Schurz, NV",10301745,null,"cfs","Qld",{"$f":"HYPERLINK(Values!B57,\"Get Data\")","v":"Get Data"}]
[]
["Weber Reservoir Data"]
["Reservoir Stage and Storage"]
["Weber Reservoir nr Schurz, NV",10301700]
["Stage, end of day",null,null,"ft","WEBstage",{"$f":"HYPERLINK(Values!B60,\"Get Data\")","v":"Get Data"}]
["Storage, end of day",null,null,"ac-ft","WEB"]
["Temperature"]
["[Wabuska station or future climate station at Weber Res.]"]
["  Max. Temperature",null,null,"°F","Tempweb"]
["  Precipitation",null,null,"in","PPTweb"]
["Program Water Data"]
["The following will be determined by the Water Master"]
["Program Water at Wabuska Gage",null,null,"cfs","PWwab"]

{"sheet":"Operation","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,0,11,5],[13,0,13,5],[4,0,4,5],[6,0,6,5]]}
["Operation at Weber Reservoir and Little Dam"]
["Must input data on 'Input' page before using this page."]
[]
[]
["Current Operation Day"]
["Operation Date",{"$f":"Input!B5+1","v":"2012-01-02"}]
["Data for Beginning of Operation Day"]
["Program Water inflow to Weber Reservoir",{"$f":"'Daily Calculations'!O10","v":{"$error":"#DIV/0!"}},"cfs",null,null,"PWwebin"]
["Weber Reservoir Stage",{"$f":"Input!C18","v":0},"ft",null,null,"WEBstage"]
["Weber Reservoir total storage",{"$f":"Input!C19","v":0},"ac-ft",null,null,"WEB"]
["Program Water in Weber Reservoir",{"$f":"'Daily Calculations'!R10","v":{"$error":"#N/A"}},"ac-ft",{"$f":"B11/cfstoacft","v":{"$error":"#N/A"}},"cfs","PWweb"]
["Target Releases"]
["Target Program Water Release",0,"cfs",{"$f":"B13*cfstoacft","v":0},"ac-ft","TPWwebout t+1",{"$f":"IF(B13>D11+0.1,\"Exceeds PW maximum allowable release!\",\"Program Water release okay\")","v":{"$error":"#N/A"}}]
["Little Dam Target Flows"]
["Program Water at Little Dam",{"$f":"'Daily Calculations'!Y10","v":{"$error":"#DIV/0!"}},"cfs",{"$f":"B15*cfstoacft","v":{"$error":"#DIV/0!"}},"ac-ft","TPWld t+1"]

{"sheet":"Daily Calculations","index":2,"n_rows":15,"n_cols":25,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,23,4,24],[4,18,4,22],[4,3,4,17]]}
["Walker River Conveyance Agreement"]
["Daily Accounting Calculations"]
[]
[]
[null,"A. At Wabuska",null,"B. Wabuska through Weber Reservoir",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C: Weber Reservoir to Little Dam",null,null,null,null,"PW Targets (t+1)"]
[]
[]
[]
["Date","Qwab","PWwab","WEBstage","WEBt-1","WEB","WEBsurf","PPTweb","Precipweb","Qwebout","LOSStot","Tempweb","Evapweb","LOSSriv","PWwebin","PWwebout","PWloss","PWweb","Qcanal 1","Qcanal 2","Qld","LGF","PWld","TPWwebout t+1","TPWld t+1"]
[{"$f":"AnalysisDate","v":"2012-01-01"},{"$f":"Qwab","v":0},{"$f":"Input!C26","v":0},{"$f":"WEBstage","v":0},{"$f":"WEBt_1","v":{"$error":"#N/A"}},{"$f":"WEB","v":0},{"$f":"WEBsurf","v":{"$error":"#N/A"}},{"$f":"PPTweb","v":0},{"$f":"PPTweb/12*WEBsurf/cfstoacft","v":{"$error":"#N/A"}},{"$f":"Qwebout","v":0},{"$f":"(WEBt_1-WEB)/cfstoacft+Qwab-Qwebout+Precipweb","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(TEMPweb)=TRUE,TEMPweb,\"--\")","v":"--"},{"$f":"IF(ISNUMBER(TEMPweb)=TRUE,WEBsurf*((0.0003*TEMPweb)-0.0116)/cfstoacft,\"--\")","v":"--"},{"$f":"LOSStot-Evapweb","v":{"$error":"#N/A"}},{"$f":"PWwab-PWwab/Qwab*LOSSriv","v":{"$error":"#DIV/0!"}},{"$f":"PWld/(1-LGF)","v":{"$error":"#N/A"}},{"$f":"(PWwab/Qwab)*LOSSriv+(PWwebt_1-PWwebout*cfstoacft)/WEBt_1*Evapweb","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((PWwebt_1/cfstoacft+PWwab-PWwebout-PWloss)*cfstoacft,2)","v":{"$error":"#N/A"}},{"$f":"Qcanal1","v":0},{"$f":"Qcanal2","v":0},{"$f":"Qld","v":0},{"$f":"(Qwebout-(Qcanal1+Qcanal2+Qld))/Qwebout","v":{"$error":"#DIV/0!"}},{"$f":"IF(TPWwebout>0,MIN(Qld,PWwebt_1/cfstoacft*(1-LGF)),0)","v":{"$error":"#N/A"}},{"$f":"TPWweboutt1","v":0},{"$f":"TPWweboutt1*(1-LGF)","v":{"$error":"#DIV/0!"}}]
[null,"cfs","cfs","ft","ac-ft","ac-ft","ac","in","cfs","cfs","cfs","°F","cfs","cfs","cfs","cfs","cfs","ac-ft","cfs","cfs","cfs","unitless","cfs","cfs","cfs"]
[]
[]
["Press the button to record the daily values to the 'Annual' page."]
["(Date must be the next day after the previous recorded value.)"]

{"sheet":"Summary","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,0,3,3],[4,0,4,3],[12,0,12,3]]}
["Summary of Program Water"]
["Daily Average Values"]
[]
["Program Water"]
["Daily Average Values"]
["At Wabuska Gage",{"$f":"'Daily Calculations'!C10","v":0},"cfs","PWwab"]
["Inflow to Weber Reservoir",{"$f":"'Daily Calculations'!O10","v":{"$error":"#DIV/0!"}},"ac-ft","PWwebin"]
["Stored in Weber Reservoir (end of day)",{"$f":"'Daily Calculations'!R10","v":{"$error":"#N/A"}},"ac-ft","PWweb"]
["Net loss from Wabuska through Weber Reservoir reach",{"$f":"'Daily Calculations'!Q10","v":{"$error":"#DIV/0!"}},"ac-ft","PWloss"]
["Released from Weber Reservoir",{"$f":"'Daily Calculations'!P10","v":{"$error":"#N/A"}},"cfs","PWwebout"]
["At Little Dam Gage",{"$f":"'Daily Calculations'!W10","v":{"$error":"#N/A"}},"cfs","PWld"]
[]
["Cumulative Values for Year"]
["At Wabuska Gage",{"$f":"Annual!C6","v":0},"ac-ft","PWwab"]
["Inflow to Weber Reservoir",{"$f":"Annual!O6","v":0},"ac-ft","PWwebin"]
["Remaining in Weber Reservoir (end of period)",{"$f":"OFFSET(Annual!R13,COUNT(Annual!R14:R380),0)","v":"ac-ft"},"ac-ft","PWweb"]
["Net loss from Wabuska through Weber Reservoir reach",{"$f":"Annual!Q6","v":0},"ac-ft","PWloss"]
["Released from Weber Reservoir",{"$f":"Annual!P6","v":0},"ac-ft","PWwebout"]
["At Little Dam Gage",{"$f":"Annual!W6","v":0},"ac-ft","PWld"]

{"sheet":"Annual","index":4,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,23,8,24],[8,1,8,2],[8,18,8,22],[8,3,8,17]]}
["Walker River Conveyance Agreement"]
["Record of Daily Accounting",null,null,null,null,null,null,"Must manually enter data as indicated."]
["Year:",2012]
[]
["Totals (cfs)",{"$f":"SUM(B14:B380)","v":0},{"$f":"SUM(C14:C380)","v":0},null,null,null,null,null,{"$f":"SUM(I14:I380)","v":0},{"$f":"SUM(J14:J380)","v":0},{"$f":"SUM(K14:K380)","v":0},null,{"$f":"SUM(M14:M380)","v":0},{"$f":"SUM(N14:N380)","v":0},{"$f":"SUM(O14:O380)","v":0},{"$f":"SUM(P14:P380)","v":0},0,null,{"$f":"SUM(S14:S380)","v":0},0,{"$f":"SUM(U14:U380)","v":0},null,{"$f":"SUM(W14:W380)","v":0},{"$f":"SUM(X14:X380)","v":0},0]
["Totals (ac-ft)",{"$f":"SUM(B14:B380)*cfstoacft","v":0},{"$f":"SUM(C14:C380)*cfstoacft","v":0},null,null,null,null,null,{"$f":"SUM(I14:I380)*cfstoacft","v":0},{"$f":"SUM(J14:J380)*cfstoacft","v":0},{"$f":"SUM(K14:K380)*cfstoacft","v":0},null,{"$f":"SUM(M14:M380)*cfstoacft","v":0},{"$f":"SUM(N14:N380)*cfstoacft","v":0},{"$f":"SUM(O14:O380)*cfstoacft","v":0},{"$f":"SUM(P14:P380)*cfstoacft","v":0},0,null,{"$f":"SUM(S14:S380)*cfstoacft","v":0},0,{"$f":"SUM(U14:U380)*cfstoacft","v":0},null,0,{"$f":"SUM(X14:X380)*cfstoacft","v":0},0]
["Previous Value",{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,B11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,C11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,D11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,E11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,F11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,G11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,H11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,I11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,J11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,K11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,L11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,M11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,N11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,O11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,P11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,Q11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,R11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,S11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,T11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,U11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,V11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,W11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,X11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!$B$5-1,Annual!$A$14:$Y$380,Y11)","v":{"$error":"#N/A"}}]
[]
[null,"A. At Wabuska",null,"B. Wabuska through Weber Reservoir",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C: Weber Reservoir to Little Dam",null,null,null,null,"PW Targets (t+1)"]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,"Qwab","PWwab","WEBstage","WEBt-1","WEB","WEBsurf","PPTweb","Precipweb","Qwebout","LOSStot","Tempweb","Evapweb","LOSSriv","PWwebin","PWwebout","PWloss","PWweb","Qcanal 1","Qcanal 2","Qld","LGF","PWld","TPWwebout t+1","TPWld t+1"]
["Date","cfs","cfs","ft","ac-ft","ac-ft","ac","in","cfs","cfs","cfs","°F","cfs","cfs","cfs","cfs","cfs","ac-ft","cfs","cfs","cfs","unitless","cfs","cfs","cfs"]
["2013-01-01"]

{"sheet":"Variables List","index":5,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Variables List"]
["All variables represent daily averages unless otherwise indicated."]
[]
["Qwab","Flow at Wabuska Gage"]
["PWwab","Program Water at Wabuska Gage, final calculation with losses/gains check and Tribe's decree water check"]
["WEBstage","Weber Reservoir end of day stage"]
["WEBt-1","Gaged Weber Reservoir end of previous day storage"]
["WEB","Gaged Weber Reservoir end of day storage"]
["WEBsurf","Surface area of Weber Reservoir"]
["PPTweb","Unit precipitation falling on Weber Resrvoir, in"]
["Precipweb","Precipitation falling on Weber Resrvoir, ac-ft"]
["Qwebout","Flow at gage below Weber Reservoir"]
["LOSStot","Caculated total net loss in Wabuska through Weber Reservoir reach"]
["Tempweb","Maximum temperature recorded at Weber Reservoir"]
["Evapweb","Estimated evaporation from Weber Reservoir, assumed portion of total reach losses due to Weber Reservoir"]
["LOSSriv","Portion of total net loss apportioned to river losses"]
["PWweb t-1","End of previous day Program Water stored in Weber Reservoir"]
["PWwebin","Calculated Program Water inflow to Weber Reservoir"]
["PWwebout","Calculated Program Water outflow from Weber Reservoir"]
["PWloss","Program Water net loss from Wabuska through Weber Reservoir reach"]
["PWweb","End of day Program Water stored in Weber Reservoir"]
["Qcanal 1","Flow at Canal 1 Gage"]
["Qcanal 2","Flow at Canal 2 Gage"]
["Qld","Flow at Little Dam Gage"]
["LGF","Loss/Gain Factor between Weber Reservoir and Little Dam"]
["PWld","Program Water at Little Dam Gage"]
["TPWwebout t+1","Target Program Water outflow from Weber Reservoir for Operation Day (t+1)"]
["TPWld t+1","Target Program Water flow at Little Dam for Operation Day (t+1)"]

{"sheet":"Values","index":6,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Walker River Conveyance Agreement"]
["Data used for purposes of the Walker River Conveyance Agreement"]
["(Values should only be changed under direction by the Conveyance Committee.)"]
[]
["Conversion factors"]
[null,1.9835,"cfs to ac-ft"]
[]
["Weber Reservoir stage/surface area table",null,null,"Area digitized from Katzer and Harmsen, 1973",null,null,null,"[Determine new values once new Weber Reservoir bathymetry is available.]"]
[null,"Stage, ft","Surface Area, ac","Vertical lookup values for interpolation",null,null,null,"Interpolated"]
[null,4178,0,"End of Day",null,null,null,"Area, ac"]
[null,4179,2,"Value 1:",{"$f":"VLOOKUP(Input!C18,Values!$B$10:$C$41,1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!C18,Values!$B$10:$C$41,2)","v":{"$error":"#N/A"}},null,{"$f":"ROUND(Values!F11+(Values!F12-Values!F11)*(Input!C18-Values!E11)/(Values!E12-Values!E11),1)","v":{"$error":"#N/A"}},null,"Average"]
[null,4180,16,"Value 2:",{"$f":"VLOOKUP(Input!C18+1,Values!$B$10:$C$41,1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Input!C18+1,Values!$B$10:$C$41,2)","v":{"$error":"#N/A"}},null,null,null,"Area, ac"]
[null,4181,30,null,null,null,null,"Interpolated",null,{"$f":"(H11+H15)/2","v":{"$error":"#N/A"}}]
[null,4182,42,"Beginning of Day",null,null,null,"Area, ac"]
[null,4183,53,"Value 1:",{"$f":"VLOOKUP(Annual!D7,Values!$B$10:$C$41,1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Annual!D7,Values!$B$10:$C$41,2)","v":{"$error":"#N/A"}},null,{"$f":"ROUND(Values!F15+(Values!F16-Values!F15)*(Annual!D7-Values!E15)/(Values!E16-Values!E15),1)","v":{"$error":"#N/A"}}]
[null,4184,66,"Value 2:",{"$f":"VLOOKUP(Annual!D7+1,Values!$B$10:$C$41,1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Annual!D7+1,Values!$B$10:$C$41,2)","v":{"$error":"#N/A"}}]
[null,4185,75]
[null,4186,89]
[null,4187,101]
[null,4188,113]
[null,4189,146]
[null,4190,188.9]
[null,4191,230]
[null,4192,268.5]
[null,4193,300.8]
[null,4194,335.8]
[null,4195,374.3]
[null,4196,412.8]
[null,4197,455.6]
[null,4198,498.5]
[null,4199,544.79999999999995]
[null,4200,596.4]
[null,4201,646.29999999999995]
[null,4202,690.9]
[null,4203,729.4]
[null,4204,765.2]
[null,4205,804.6]
[null,4206,836.9]
[null,4207,873.7]
[null,4208,908.6]
[null,4209,944.6]
[]
["Maximum Weber Reservoir storage",null,null,"[Determine values once new Weber Reservoir bathymetry is available.]"]
[null,10700,"ac-ft"]
[]
["Maximum Weber Reservoir release"]
[null,3000,"cfs"]
[]
["USGS data hyperlinks"]
["Stn. ID","Link"]
[10301120,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A51&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301120&referred_module=sw"}]
[10301495,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A52&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301495&referred_module=sw"}]
[10301290,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A53&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301290&referred_module=sw"}]
[10301500,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A54&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301500&referred_module=sw"}]
[10301600,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A55&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301600&referred_module=sw"}]
[10301720,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A56&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301720&referred_module=sw"}]
[10301745,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A57&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301745&referred_module=sw"}]
[10301755,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A58&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301755&referred_module=sw"}]
[10301742,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A59&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00060=on&format=rdb&period=&begin_date=2012-1-1&end_date=2012-1-1&site_no=10301742&referred_module=sw"}]
[10301700,{"$f":"\"http://waterdata.usgs.gov/nv/nwis/dv?cb_00062=on&cb_00054=on&format=rdb&period=&begin_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5-1)&\"&end_date=\"&YEAR(Input!$B$5)&\"-\"&MONTH(Input!$B$5)&\"-\"&DAY(Input!$B$5)&\"&site_no=\"&A60&\"&referred_module=sw\"","v":"http://waterdata.usgs.gov/nv/nwis/dv?cb_00062=on&cb_00054=on&format=rdb&period=&begin_date=2012-1-31&end_date=2012-1-1&site_no=10301700&referred_module=sw"}]

{"sheet":"Schematics","index":7,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,8,0,15],[0,0,0,7]]}
["Reach B: Wabuska Gage to Weber Reservoir",null,null,null,null,null,null,null,"Reach C: Weber Reservoir to Little Dam"]