{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Main","Model Parameters","Input Data","Water Budget","Model Sensitivity","Model Output","Definitions","Lookup Tables"],"not_rendered":{"charts":5,"images":7,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,7],[1,0,6,11],[10,1,10,7]]}
[]
["On behalf of the B.C. Ministry of Environment, Associated Environmental Consultants Inc. prepared this workbook to provide a monthly water budget for Similkameen Valley Aquifer (259).  Throuhgout the workbook, yellow cells indicate user-input parameters and data and blue cells indicate auto-populated terms."]
[]
[]
[]
[]
[]
["Revision Date","2016-06-01"]
["Revised By","Associated"]
[null,null,null,null,null,null,null,null,null,null,"Navigation"]
["Aquifer Name","Similkameen Valley Aquifer"]
["Aquifer Number",259]

{"sheet":"Model Parameters","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,5,36,7]]}
[null,{"$f":"Main!$B$11","v":"Similkameen Valley Aquifer"}]
[null,{"$f":"CONCATENATE(\"Aquifer #\", Main!$B$12)","v":"Aquifer #259"}]
[]
[]
[null,"MODEL SCENARIO","Units","Select Scenario",null,"WATER BUDGET OUTPUTS","Units"]
[]
[null,"Select 'Normal', 'Dry', 'Wet', or 'Other' Year","-","NORMAL",null,"Evaporation Direct from Similkameen River"]
[null,null,null,null,null,"Annual Total Evaporation","mm",{"$f":"'Lookup Tables'!AD16","v":967.40000000000009}]
[null,"SYSTEM CHARACTERISTICS","Units"]
[null,null,null,null,null,"Surface Water Outflow"]
[null,"Aquifer Characteristics",null,null,null,"Mean Annual Similkameen River Outflow","m3/s",{"$f":"'Lookup Tables'!AD24","v":54.475000000000001}]
[null,"Aquifer Length","m",94300]
[null,"Aquifer Area","m2",120629426,null,"Groundwater Outflow"]
[null,"Specific Yield","-",0.26,null,"Outflow at Downstream Aquifer Boundary","m3/day",{"$f":"IF('Lookup Tables'!D76=2, H15*H16*H17*H18, IF('Lookup Tables'!D76=1, 'Model Parameters'!H15*'Model Parameters'!H16*'Model Sensitivity'!M29*'Model Parameters'!H18))","v":20000}]
[null,null,null,null,null,"Aquifer Width","m",1250]
[null,"Similkameen River Characteristics",null,null,null,"Aquifer Depth","m",40]
[null,"Similkameen River Surface Area","m2",10260397,null,"Hydraulic Conductivity (K)","m/day",100]
[null,null,null,null,null,"Hydraulic Gradient (i)","-",4.0000000000000001E-3]
[null,"WATER BUDGET INPUTS","Units"]
[null,null,null,null,null,"Water Demand"]
[null,"Precipitation",null,null,null,"Select Water Demand Scenario","-","Estimated Actual Demand"]
[null,"Annual Total Precipitation","mm",{"$f":"'Lookup Tables'!O13","v":347}]
[null,null,null,null,null,"Estimated Existing Surface Water Demand"]
[null,"Surface Water Inflow",null,null,null,"Mean Annual Surface Water Demand","m3/s",{"$f":"'Lookup Tables'!AD34","v":2.9416666666666674E-2}]
[null,"Mean Annual Similkameen River Inflow","m3/s",{"$f":"'Lookup Tables'!O23","v":42.200833333333335},null,"Mean Seasonal Surface Water Demand","m3/s",{"$f":"'Lookup Tables'!AD42","v":0.25791666666666663}]
[null,"Mean Annual Tributary Inflow","m3/s",{"$f":"'Lookup Tables'!O31","v":12.578833333333336}]
[null,null,null,null,null,"Estimated Existing Groundwater Demand"]
[null,"Aquifer Recharge",null,null,null,"Mean Annual Groundwater Demand","m3/s",{"$f":"'Lookup Tables'!AD52","v":6.9749999999999993E-2}]
[null,"Select Aquifer Recharge Option","-","Monthly Distribution",null,"Mean Seasonal Groundwater Demand","m3/s",{"$f":"'Lookup Tables'!AD60","v":0.31791666666666668}]
[null,"Percentage of Precipitation Recharging Aquifer","%",20]
[null,null,null,null,null,"Total Existing Licensed Surface Water Demand"]
[null,"Water Demand",null,null,null,"Mean Annual Licensed Water Demand","m3/s",{"$f":"'Lookup Tables'!AD63","v":0.90549999999999997}]
[null,"Select Irrigation Return Option","-","Fixed Percentage",null,"Mean Seasonal Licensed Water Demand","m3/s",{"$f":"'Lookup Tables'!AD64","v":1.1149166666666666}]
[null,"Irrigation Return to Aquifer","%",15]
[null,null,null,null,null,{"$f":"CONCATENATE(\"Model Sensitivity Mode is \",IF('Lookup Tables'!D76=1,\"ON\",IF('Lookup Tables'!D76=2,\"OFF. A summary of current parameters is provided below.\")),\". \", IF('Lookup Tables'!D76=1, \" Parameters highlighted red may be adjusted on the Model Sensitivity Page. A summary of current adjustments is provided below. Turn off Model Sensitivity Mode to revert changes.\", \"\"))","v":"Model Sensitivity Mode is OFF. A summary of current parameters is provided below.. "}]
[null,"Groundwater Inflow"]
[null,"Inflow at Upstream Aquifer Boundary","m3/day",{"$f":"IF('Lookup Tables'!D76=2, D38*D39*D40*D41, IF('Lookup Tables'!D76=1, 'Model Parameters'!D38*D39*'Model Sensitivity'!M25*'Model Parameters'!D41))","v":10235}]
[null,"Aquifer Width","m",1150]
[null,"Aquifer Depth","m",20,null,"Specific Yield",{"$f":"IF('Lookup Tables'!$D$76=2, 'Model Parameters'!$D$14, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!$M$17))","v":0.26}]
[null,"Hydraulic Conductivity (K)","m/day",89,null,"Percentage of Precipitation Recharging to Aquifer",{"$f":"IF('Lookup Tables'!$D$76=2,'Model Parameters'!$D$30/100,IF('Lookup Tables'!$D$76=1,'Model Sensitivity'!$M$19/100))","v":0.2}]
[null,"Hydraulic Gradient (i)","-",5.0000000000000001E-3,null,"Irrigation Return to Aquifer",{"$f":"IF('Lookup Tables'!$D$76=2, 'Model Parameters'!$D$34/100, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!$M$21/100))","v":0.15}]
[null,null,null,null,null,"Percentage change of Tributary Inflow Estimates",{"$f":"IF('Lookup Tables'!$D$76=2, 0, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!M23/100))","v":0}]
[null,"Mountain Block Recharge",null,null,null,"Groundwater Inflow - Hydraulic Conductivity (K)",{"$f":"IF('Lookup Tables'!$D$76=2,'Model Parameters'!$D$40,IF('Lookup Tables'!$D$76=1,'Model Sensitivity'!$M$25))","v":89}]
[null,"Select MBR Method","-","Darcy Equation",null,"Percentage change of MBR Estimate",{"$f":"IF('Lookup Tables'!$D$76=2, 0, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!$M$27/100))","v":0}]
[null,"Aquifer Length","m",{"$f":"D12","v":94300},null,"Groundwater Outflow - Hydraulic Conductivity (K)",{"$f":"IF('Lookup Tables'!$D$76=2, 'Model Parameters'!$H$17, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!$M$29))","v":100}]
[null,"Aquifer Depth","m",60,null,"Percentage change of Total Estimated Surface Water Demand",{"$f":"IF('Lookup Tables'!$D$76=2, 0, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!$M$31/100))","v":0}]
[null,{"$f":"IF(D44=\"Neilson-Welch\", \"Neilson-Welch Flux Rate (30-50 mm/y)\", \"Hydraulic Conductivity (K)\")","v":"Hydraulic Conductivity (K)"},{"$f":"IF(B47=\"Hydraulic Conductivity (K)\", \"m/day\", IF(B47=\"Neilson-Welch Flux Rate (30-50 mm/y)\", \"mm/year\"))","v":"m/day"},8.6400000000000001E-3,null,"Percentage change of Total Estimated Groundwater Demand",{"$f":"IF('Lookup Tables'!$D$76=2, 0, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!$M$33/100))","v":0}]
[null,{"$f":"IF(D44=\"Neilson-Welch\", \"\", \"Hydraulic Gradient (i)\")","v":"Hydraulic Gradient (i)"},{"$f":"IF(D44=\"Neilson-Welch\", \"\", \"-\")","v":"-"},0.05,null,"Percentage change of Total Licensed Water Demand",{"$f":"IF('Lookup Tables'!$D$76=2, 0, IF('Lookup Tables'!$D$76=1, 'Model Sensitivity'!$M$35/100))","v":0}]
[null,"MBR Estimate","m3/day",{"$f":"IF(D44=\"Neilson-Welch\",((D45*D46*2)*(D47/1000))/'Lookup Tables'!O3, IF(D44=\"Darcy Equation\", ((D45*D46*2)*D47*D48), \"Select MBR Method\"))","v":4888.5120000000006}]

{"sheet":"Input Data","index":2,"n_rows":61,"n_cols":32,"rows_kept":61,"cut":false,"hidden":false,"merged":[[4,1,4,15],[4,17,4,31],[38,1,38,15]]}
[null,{"$f":"Main!$B$11","v":"Similkameen Valley Aquifer"}]
[null,{"$f":"CONCATENATE(\"Aquifer #\", Main!$B$12)","v":"Aquifer #259"}]
[]
[]
[null,"WATER BUDGET INPUTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WATER BUDGET OUTPUTS"]
[]
[null,"PRECIPITATION DATA","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL",null,"EVAPORATION DATA","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Normal Year","mm",39.700000000000003,20.5,16.5,18.399999999999999,29.6,37.6,29.6,24.3,23.8,26.1,44.5,36.4,{"$f":"SUM(D8:O8)","v":347},null,"Normal Year","mm",18.3,27.4,57.6,89,127.7,143.80000000000001,165.4,147.6,98.1,52.9,23.7,15.9,{"$f":"SUM(T8:AE8)","v":967.40000000000009}]
[null,"Dry Year","mm",19.600000000000001,21.3,16.2,11.9,7.4,21.3,14.3,2.2000000000000002,6.8,15.9,26.4,26.3,{"$f":"SUM(D9:O9)","v":189.60000000000002},null,"Dry Year","mm",18.399999999999999,25.3,57.9,84.6,135.19999999999999,134.80000000000001,161.69999999999999,155.30000000000001,104.7,49.3,27.2,16.8,{"$f":"SUM(T9:AE9)","v":971.2}]
[null,"Wet Year","mm",35.9,23.3,20.399999999999999,40.200000000000003,54.2,62.2,24,42.6,5.2,19,37.4,30.4,394.79999999999995,null,"Wet Year","mm",16.2,28.9,52.8,87.3,116.7,131,166.3,140.30000000000001,109,57.6,23.9,18,948]
[null,"Other","mm",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Other","mm",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"SURFACE WATER INFLOW DATA","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN",null,"SURFACE WATER OUTFLOW DATA","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Year","m3/s",19.100000000000001,17.7,22.9,58.6,183,186,67.7,21.6,13.4,16,27.6,20.100000000000001,{"$f":"AVERAGE(T14:AE14)","v":54.475000000000001}]
[null,"SIMILKAMEEN RIVER INFLOW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Year","m3/s",9.39,8.2200000000000006,9.3800000000000008,21.3,109,78.8,25.1,9.36,5.39,7.19,15.2,10.1,{"$f":"AVERAGE(T15:AE15)","v":25.702500000000004}]
[null,"Normal Year","m3/s",15,12.3,18.399999999999999,55.1,155,138,42.6,11.4,7.61,11.7,24.7,14.6,{"$f":"AVERAGE(D16:O16)","v":42.200833333333335},null,"Wet Year","m3/s",30.3,47.7,40.200000000000003,94.5,319,342,194,47.9,20.100000000000001,12.8,19.2,15.5,98.600000000000009]
[null,"Dry Year","m3/s",6.54,5.07,6.18,21.7,102,54.4,12.6,4.74,3.35,5.21,13,7.71,{"$f":"AVERAGE(D17:O17)","v":20.208333333333336},null,"Other","m3/s",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Wet Year","m3/s",20.100000000000001,39.4,29.9,82.7,243,260,139,30.4,11.5,6.6,13.1,11,73.891666666666666]
[null,"Other","m3/s",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,"EXISTING SURFACE WATER DEMAND DATA","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[]
[null,"TRIBUTARY INFLOW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL WATER DEMAND"]
[null,"Normal Year","m3/s",2.774,2.5190000000000001,3.34,11.8,48.16,44.99,16.489999999999998,5.8650000000000002,3.802,3.5670000000000002,4.4370000000000003,3.202,{"$f":"AVERAGE(D22:O22)","v":12.578833333333336},null,"Normal Year","m3/s",2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,0.03,0.03,0.03,0.03,0.03,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,{"$f":"AVERAGE(T22:AE22)","v":2.9416666666666674E-2}]
[null,"Dry Year","m3/s",1.8,1.6,1.83,5.17,26.53,17.57,7.14,3.09,1.58,1.75,2.78,2.4700000000000002,{"$f":"AVERAGE(D23:O23)","v":6.1091666666666669},null,"Dry Year","m3/s",2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,0.03,0.03,0.03,0.03,0.03,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,{"$f":"AVERAGE(T23:AE23)","v":2.9416666666666674E-2}]
[null,"Wet Year","m3/s",4.2389999999999999,5.8789999999999996,5.1260000000000003,16.47,89.46,99.4,41.96,11.43,5.0199999999999996,2.9889999999999999,3.3159999999999998,2.734,24.001916666666659,null,"Wet Year","m3/s",2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,0.03,0.03,0.03,0.03,0.03,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9416666666666674E-2]
[null,"Other","m3/s",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,"Other","m3/s",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[]
[null,"AQUIFER RECHARGE",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL",null,"SEASONAL WATER DEMAND"]
[null,"Normal Year","%",4,2,20,24,18,8,4,3,4,9,1.5,2.5,{"$f":"SUM(D28:O28)","v":100},null,"Normal Year","m3/s",0,0,0,1.7999999999999999E-2,0.20699999999999999,0.65400000000000003,0.90100000000000002,0.81799999999999995,0.497,0,0,0,0.25791666666666663]
[null,"Dry Year","%",4,2,20,24,18,8,4,3,4,9,1.5,2.5,{"$f":"SUM(D29:O29)","v":100},null,"Dry Year","m3/s",0,0,0,8.9999999999999993E-3,0.183,0.76600000000000001,0.85799999999999998,0.94399999999999995,0.61699999999999999,0,0,0,0.28141666666666665]
[null,"Wet Year","%",4,2,20,24,18,8,4,3,4,9,1.5,2.5,100,null,"Wet Year","m3/s",0,0,0,1.4E-2,0.10299999999999999,0.50900000000000001,0.90400000000000003,0.67300000000000004,0.61799999999999999,0,0,0,0.23508333333333334]
[null,"Other","%",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Other","m3/s",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[]
[null,"IRRIGATION RETURN",null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL",null,"EXISTING GROUNDWATER DEMAND DATA","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,"Normal Year","%",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D34:O34)","v":0}]
[null,"Dry Year","%",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D35:O35)","v":0},null,"ANNUAL WATER DEMAND"]
[null,"Wet Year","%",0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Normal Year","m3/s",6.6000000000000003E-2,5.5E-2,5.8999999999999997E-2,6.7000000000000004E-2,7.6999999999999999E-2,7.8E-2,8.2000000000000003E-2,8.7999999999999995E-2,7.9000000000000001E-2,6.5000000000000002E-2,5.6000000000000001E-2,6.5000000000000002E-2,{"$f":"AVERAGE(T36:AE36)","v":6.9749999999999993E-2}]
[null,"Other","%",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Dry Year","m3/s",6.4000000000000001E-2,5.2999999999999999E-2,5.7000000000000002E-2,6.5000000000000002E-2,7.3999999999999996E-2,7.4999999999999997E-2,7.9000000000000001E-2,8.4000000000000005E-2,7.5999999999999998E-2,6.3E-2,5.5E-2,6.3E-2,{"$f":"AVERAGE(T37:AE37)","v":6.7333333333333342E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wet Year","m3/s",6.4000000000000001E-2,5.2999999999999999E-2,5.7000000000000002E-2,6.5000000000000002E-2,7.3999999999999996E-2,7.4999999999999997E-2,7.9000000000000001E-2,8.4000000000000005E-2,7.5999999999999998E-2,6.3E-2,5.5E-2,6.3E-2,6.7333333333333342E-2]
[null,"MODEL CALIBRATION - OBSERVATION WELL DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other","m3/s",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[]
[null,"OBSERVATION WELL DATA","Units","DEC1","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC",null,"SEASONAL WATER DEMAND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Year","m3/s",0,0,0,7.8E-2,0.38400000000000001,0.81,1.0529999999999999,0.92700000000000005,0.56299999999999994,0,0,0,{"$f":"AVERAGE(T42:AE42)","v":0.31791666666666668}]
[null,"Keremeos (Well # 75)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Year","m3/s",0,0,0,5.8000000000000003E-2,0.372,0.89500000000000002,0.99399999999999999,1.087,0.69499999999999995,0,0,0,0.34175]
[null,"Normal Year","m bgl",2.6880000000000002,2.5859999999999999,2.702,2.6440000000000001,2.4670000000000001,1.97,2.0550000000000002,2.3069999999999999,2.7349999999999999,2.883,2.8679999999999999,2.6859999999999999,2.6880000000000002,null,"Wet Year","m3/s",0,0,0,5.3999999999999999E-2,0.23400000000000001,0.61799999999999999,1.0369999999999999,0.76700000000000002,0.63100000000000001,0,0,0,0.2784166666666667]
[null,"Dry Year","m bgl",2.875,2.9750000000000001,3.0249999999999999,2.9649999999999999,2.7949999999999999,2.2749999999999999,2.5049999999999999,2.8650000000000002,3.1949999999999998,3.0249999999999999,3.0549999999999997,3.01,3.0049999999999999,null,"Other","m3/s",null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Wet Year","m bgl",2.0150000000000001,1.9424999999999999,1.9474999999999998,2.0699999999999998,2.1175000000000002,1.22,1.17,1.4475,2.2599999999999998,2.5649999999999999,2.6150000000000002,2.62,2.6349999999999998]
[null,"Other","m bgl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL LICENSED WATER DEMAND","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Demand","m3/s",0.60799999999999998,0.57199999999999995,0.56799999999999995,0.72599999999999998,1.0960000000000001,1.1850000000000001,1.6850000000000001,1.6160000000000001,1.0660000000000001,0.67100000000000004,0.53200000000000003,0.54100000000000004,{"$f":"AVERAGE(T48:AE48)","v":0.90549999999999997}]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seasonal Demand","m3/s",0,0,0,8.2000000000000003E-2,0.89600000000000002,2.82,3.8889999999999998,3.5529999999999999,2.1389999999999998,0,0,0,{"$f":"AVERAGE(T49:AE49)","v":1.1149166666666666}]
[null,"Normal Year","m bgl"]
[null,"Dry Year","m bgl"]
[null,"Wet Year","m bgl"]
[null,"Other","m bgl"]
[]
[null,"Mean Groundwater Level"]
[null,"Normal Year","m",{"$f":"IF(D50=\"\",D44,(AVERAGE(D50,D44)))","v":2.6880000000000002},{"$f":"IF(E50=\"\",E44,(AVERAGE(E50,E44)))","v":2.5859999999999999},2.702,2.6440000000000001,2.4670000000000001,1.97,2.0550000000000002,2.3069999999999999,2.7349999999999999,2.883,2.8679999999999999,2.6859999999999999,2.6880000000000002]
[null,"Dry Year","m",{"$f":"IF(D51=\"\",D45,(AVERAGE(D51,D45)))","v":2.875},2.9750000000000001,3.0249999999999999,2.9649999999999999,2.7949999999999999,2.2749999999999999,2.5049999999999999,2.8650000000000002,3.1949999999999998,3.0249999999999999,3.0549999999999997,3.01,3.0049999999999999]
[null,"Wet Year","m",{"$f":"IF(D52=\"\",D46,(AVERAGE(D52,D46)))","v":2.0150000000000001},1.9424999999999999,1.9474999999999998,2.0699999999999998,2.1175000000000002,1.22,1.17,1.4475,2.2599999999999998,2.5649999999999999,2.6150000000000002,2.62,2.6349999999999998]
[null,"Other","m",{"$f":"IF(D53=\"\",D47,(AVERAGE(D53,D47)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Notes:"]
[null,"1. Average groundwater level from the preceding December. For 'Normal' Year, this value is assumed to equal the average December groundwater level"]

{"sheet":"Water Budget","index":3,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,1,4,15]]}
[null,{"$f":"Main!$B$11","v":"Similkameen Valley Aquifer"}]
[null,{"$f":"CONCATENATE(\"Aquifer #\", Main!$B$12)","v":"Aquifer #259"}]
[]
[]
[null,"WATER BUDGET"]
[]
[null,"INPUTS","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Direct Precipitation to Similkameen river","m3",{"$f":"('Lookup Tables'!C13/1000) * 'Model Parameters'!$D$17","v":407337.76090000005},{"$f":"('Lookup Tables'!D13/1000)*'Model Parameters'!$D$17","v":210338.1385},{"$f":"('Lookup Tables'!E13/1000)*'Model Parameters'!$D$17","v":169296.55050000001},{"$f":"('Lookup Tables'!F13/1000)*'Model Parameters'!$D$17","v":188791.30479999998},{"$f":"('Lookup Tables'!G13/1000)*'Model Parameters'!$D$17","v":303707.7512},{"$f":"('Lookup Tables'!H13/1000)*'Model Parameters'!$D$17","v":385790.92720000003},{"$f":"('Lookup Tables'!I13/1000)*'Model Parameters'!$D$17","v":303707.7512},{"$f":"('Lookup Tables'!J13/1000)*'Model Parameters'!$D$17","v":249327.64710000003},{"$f":"('Lookup Tables'!K13/1000)*'Model Parameters'!$D$17","v":244197.4486},{"$f":"('Lookup Tables'!L13/1000)*'Model Parameters'!$D$17","v":267796.36170000001},{"$f":"('Lookup Tables'!M13/1000)*'Model Parameters'!$D$17","v":456587.66649999999},{"$f":"('Lookup Tables'!N13/1000)*'Model Parameters'!$D$17","v":373478.45079999999},{"$f":"SUM(D8:O8)","v":3560357.7590000005}]
[null,"Similkameen River Inflow","m3",{"$f":"('Lookup Tables'!C23*(60*60*24)) * 'Lookup Tables'!C3","v":40176000},{"$f":"('Lookup Tables'!D23*(60*60*24)) * 'Lookup Tables'!D3","v":29756160},{"$f":"('Lookup Tables'!E23*(60*60*24)) * 'Lookup Tables'!E3","v":49282559.999999993},{"$f":"('Lookup Tables'!F23*(60*60*24)) * 'Lookup Tables'!F3","v":142819200},{"$f":"('Lookup Tables'!G23*(60*60*24)) * 'Lookup Tables'!G3","v":415152000},{"$f":"('Lookup Tables'!H23*(60*60*24)) * 'Lookup Tables'!H3","v":357696000},{"$f":"('Lookup Tables'!I23*(60*60*24)) * 'Lookup Tables'!I3","v":114099840},{"$f":"('Lookup Tables'!J23*(60*60*24)) * 'Lookup Tables'!J3","v":30533760},{"$f":"('Lookup Tables'!K23*(60*60*24)) * 'Lookup Tables'!K3","v":19725120},{"$f":"('Lookup Tables'!L23*(60*60*24)) * 'Lookup Tables'!L3","v":31337279.999999996},{"$f":"('Lookup Tables'!M23*(60*60*24)) * 'Lookup Tables'!M3","v":64022400},{"$f":"('Lookup Tables'!N23*(60*60*24)) * 'Lookup Tables'!N3","v":39104640},{"$f":"SUM(D9:O9)","v":1333704960}]
[null,"Tributary Inflow","m3",{"$f":"IF('Lookup Tables'!$D$76=2, (('Lookup Tables'!C31*(60*60*24)) * 'Lookup Tables'!C3), IF('Lookup Tables'!$D$76=1, (('Lookup Tables'!C31*(60*60*24)) * 'Lookup Tables'!C3) + ((('Lookup Tables'!C31*(60*60*24)) * 'Lookup Tables'!C3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":7429881.6000000006},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!D31*60*60*24*'Lookup Tables'!D3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!D31*60*60*24*'Lookup Tables'!D3) + (('Lookup Tables'!D31*60*60*24*'Lookup Tables'!D3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":6093964.8000000007},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!E31*60*60*24*'Lookup Tables'!E3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!E31*60*60*24*'Lookup Tables'!E3) + (('Lookup Tables'!E31*60*60*24*'Lookup Tables'!E3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":8945855.9999999981},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!F31*60*60*24*'Lookup Tables'!F3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!F31*60*60*24*'Lookup Tables'!F3) + (('Lookup Tables'!F31*60*60*24*'Lookup Tables'!F3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":30585600},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!G31*60*60*24*'Lookup Tables'!G3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!G31*60*60*24*'Lookup Tables'!G3) + (('Lookup Tables'!G31*60*60*24*'Lookup Tables'!G3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":128991744},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!H31*60*60*24*'Lookup Tables'!H3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!H31*60*60*24*'Lookup Tables'!H3) + (('Lookup Tables'!H31*60*60*24*'Lookup Tables'!H3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":116614080},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!I31*60*60*24*'Lookup Tables'!I3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!I31*60*60*24*'Lookup Tables'!I3) + (('Lookup Tables'!I31*60*60*24*'Lookup Tables'!I3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":44166815.999999993},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!J31*60*60*24*'Lookup Tables'!J3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!J31*60*60*24*'Lookup Tables'!J3) + (('Lookup Tables'!J31*60*60*24*'Lookup Tables'!J3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":15708816.000000004},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!K31*60*60*24*'Lookup Tables'!K3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!K31*60*60*24*'Lookup Tables'!K3) + (('Lookup Tables'!K31*60*60*24*'Lookup Tables'!K3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":9854784.0000000019},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!L31*60*60*24*'Lookup Tables'!L3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!L31*60*60*24*'Lookup Tables'!L3) + (('Lookup Tables'!L31*60*60*24*'Lookup Tables'!L3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":9553852.8000000007},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!M31*60*60*24*'Lookup Tables'!M3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!M31*60*60*24*'Lookup Tables'!M3) + (('Lookup Tables'!M31*60*60*24*'Lookup Tables'!M3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":11500704.000000002},{"$f":"IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!N31*60*60*24*'Lookup Tables'!N3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!N31*60*60*24*'Lookup Tables'!N3) + (('Lookup Tables'!N31*60*60*24*'Lookup Tables'!N3) * ('Model Sensitivity'!$M$23/100)), \"Error\"))","v":8576236.8000000007},{"$f":"SUM(D10:O10)","v":398022336}]
[null,"Direct Aquifer Recharge","m3",{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!C39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!C39/100))))))","v":306384.42450399994},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!D39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!D39/100))))))","v":153192.21225199997},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!E39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!E39/100))))))","v":1531922.1225199997},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!F39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!F39/100))))))","v":1838306.5470239997},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!G39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!G39/100))))))","v":1378729.9102679996},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!H39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!H39/100))))))","v":612768.84900799987},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!I39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!I39/100))))))","v":306384.42450399994},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!J39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!J39/100))))))","v":229788.31837799997},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!K39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!K39/100))))))","v":306384.42450399994},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!L39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!L39/100))))))","v":689364.95513399981},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!M39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!M39/100))))))","v":114894.15918899998},{"$f":"IF('Model Parameters'!$D$29=\"Fixed Percentage\",IF('Lookup Tables'!$D$76=2,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)),IF('Lookup Tables'!$D$76=1,((('Lookup Tables'!$O$13/12)/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)))),IF('Model Parameters'!$D$29=\"Monthly Distribution\",IF('Lookup Tables'!$D$76=2,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Parameters'!$D$30/100)*('Lookup Tables'!N39/100)),IF('Lookup Tables'!$D$76=1,(('Lookup Tables'!$O$13/1000)*('Model Parameters'!$D$13-'Model Parameters'!$D$17)*('Model Sensitivity'!$M$19/100)*('Lookup Tables'!N39/100))))))","v":191490.26531499997},{"$f":"SUM(D11:O11)","v":7659610.6125999968}]
[null,"Irrigation Return","m3",{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!R42,'Lookup Tables'!R60)*(60*60*24*'Lookup Tables'!C3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!R42,'Lookup Tables'!R60)*(60*60*24*'Lookup Tables'!C3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!R42,'Lookup Tables'!R60)*(60*60*24*'Lookup Tables'!C3)) * 'Lookup Tables'!C47/100))","v":0},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!S42,'Lookup Tables'!S60)*(60*60*24*'Lookup Tables'!D3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!S42,'Lookup Tables'!S60)*(60*60*24*'Lookup Tables'!D3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!S42,'Lookup Tables'!S60)*(60*60*24*'Lookup Tables'!D3)) * 'Lookup Tables'!D47/100))","v":0},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!T42,'Lookup Tables'!T60)*(60*60*24*'Lookup Tables'!E3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!T42,'Lookup Tables'!T60)*(60*60*24*'Lookup Tables'!E3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!T42,'Lookup Tables'!T60)*(60*60*24*'Lookup Tables'!E3)) * 'Lookup Tables'!E47/100))","v":0},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!U42,'Lookup Tables'!U60)*(60*60*24*'Lookup Tables'!F3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!U42,'Lookup Tables'!U60)*(60*60*24*'Lookup Tables'!F3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!U42,'Lookup Tables'!U60)*(60*60*24*'Lookup Tables'!F3)) * 'Lookup Tables'!F47/100))","v":37324.799999999996},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!V42,'Lookup Tables'!V60)*(60*60*24*'Lookup Tables'!G3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!V42,'Lookup Tables'!V60)*(60*60*24*'Lookup Tables'!G3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!V42,'Lookup Tables'!V60)*(60*60*24*'Lookup Tables'!G3)) * 'Lookup Tables'!G47/100))","v":237440.15999999997},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!W42,'Lookup Tables'!W60)*(60*60*24*'Lookup Tables'!H3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!W42,'Lookup Tables'!W60)*(60*60*24*'Lookup Tables'!H3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!W42,'Lookup Tables'!W60)*(60*60*24*'Lookup Tables'!H3)) * 'Lookup Tables'!H47/100))","v":569203.19999999995},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!X42,'Lookup Tables'!X60)*(60*60*24*'Lookup Tables'!I3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!X42,'Lookup Tables'!X60)*(60*60*24*'Lookup Tables'!I3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!X42,'Lookup Tables'!X60)*(60*60*24*'Lookup Tables'!I3)) * 'Lookup Tables'!I47/100))","v":785039.03999999992},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!Y42,'Lookup Tables'!Y60)*(60*60*24*'Lookup Tables'!J3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!Y42,'Lookup Tables'!Y60)*(60*60*24*'Lookup Tables'!J3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!Y42,'Lookup Tables'!Y60)*(60*60*24*'Lookup Tables'!J3)) * 'Lookup Tables'!J47/100))","v":701071.2},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!Z42,'Lookup Tables'!Z60)*(60*60*24*'Lookup Tables'!K3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!Z42,'Lookup Tables'!Z60)*(60*60*24*'Lookup Tables'!K3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!Z42,'Lookup Tables'!Z60)*(60*60*24*'Lookup Tables'!K3)) * 'Lookup Tables'!K47/100))","v":412128},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!AA42,'Lookup Tables'!AA60)*(60*60*24*'Lookup Tables'!L3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!AA42,'Lookup Tables'!AA60)*(60*60*24*'Lookup Tables'!L3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!AA42,'Lookup Tables'!AA60)*(60*60*24*'Lookup Tables'!L3)) * 'Lookup Tables'!L47/100))","v":0},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!AB42,'Lookup Tables'!AB60)*(60*60*24*'Lookup Tables'!M3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!AB42,'Lookup Tables'!AB60)*(60*60*24*'Lookup Tables'!M3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!AB42,'Lookup Tables'!AB60)*(60*60*24*'Lookup Tables'!M3)) * 'Lookup Tables'!M47/100))","v":0},{"$f":"IF('Model Parameters'!$D$33=\"Fixed Percentage\", IF('Lookup Tables'!$D$76=2, (SUM('Lookup Tables'!AC42,'Lookup Tables'!AC60)*(60*60*24*'Lookup Tables'!N3))*('Model Parameters'!$D$34/100), IF('Lookup Tables'!$D$76=1, (SUM('Lookup Tables'!AC42,'Lookup Tables'!AC60)*(60*60*24*'Lookup Tables'!N3)) * ('Model Sensitivity'!$M$21/100))), IF('Model Parameters'!$D$33=\"Monthly Distribution\",(SUM('Lookup Tables'!AC42,'Lookup Tables'!AC60)*(60*60*24*'Lookup Tables'!N3)) * 'Lookup Tables'!N47/100))","v":0},{"$f":"SUM(D12:O12)","v":2742206.3999999994}]
[null,"Groundwater Inflow at Upstream Aquifer Boundary","m3",{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!C3","v":317285},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!D3","v":286580},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!E3","v":317285},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!F3","v":307050},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!G3","v":317285},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!H3","v":307050},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!I3","v":317285},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!J3","v":317285},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!K3","v":307050},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!L3","v":317285},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!M3","v":307050},{"$f":"'Model Parameters'!$D$37*'Lookup Tables'!N3","v":317285},3735775]
[null,"Mountain Block Recharge (Bedrock Aquifer) to Valley Aquifer","m3",{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!C3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!C3)+(('Model Parameters'!$D$49*'Lookup Tables'!C3)*('Model Sensitivity'!$M$27/100))))","v":151543.87200000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!D3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!D3)+(('Model Parameters'!$D$49*'Lookup Tables'!D3)*('Model Sensitivity'!$M$27/100))))","v":136878.33600000001},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!E3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!E3)+(('Model Parameters'!$D$49*'Lookup Tables'!E3)*('Model Sensitivity'!$M$27/100))))","v":151543.87200000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!F3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!F3)+(('Model Parameters'!$D$49*'Lookup Tables'!F3)*('Model Sensitivity'!$M$27/100))))","v":146655.36000000002},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!G3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!G3)+(('Model Parameters'!$D$49*'Lookup Tables'!G3)*('Model Sensitivity'!$M$27/100))))","v":151543.87200000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!H3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!H3)+(('Model Parameters'!$D$49*'Lookup Tables'!H3)*('Model Sensitivity'!$M$27/100))))","v":146655.36000000002},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!I3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!I3)+(('Model Parameters'!$D$49*'Lookup Tables'!I3)*('Model Sensitivity'!$M$27/100))))","v":151543.87200000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!J3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!J3)+(('Model Parameters'!$D$49*'Lookup Tables'!J3)*('Model Sensitivity'!$M$27/100))))","v":151543.87200000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!K3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!K3)+(('Model Parameters'!$D$49*'Lookup Tables'!K3)*('Model Sensitivity'!$M$27/100))))","v":146655.36000000002},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!L3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!L3)+(('Model Parameters'!$D$49*'Lookup Tables'!L3)*('Model Sensitivity'!$M$27/100))))","v":151543.87200000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!M3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!M3)+(('Model Parameters'!$D$49*'Lookup Tables'!M3)*('Model Sensitivity'!$M$27/100))))","v":146655.36000000002},{"$f":"IF('Lookup Tables'!$D$76=2,('Model Parameters'!$D$49*'Lookup Tables'!N3),IF('Lookup Tables'!$D$76=1,('Model Parameters'!$D$49*'Lookup Tables'!N3)+(('Model Parameters'!$D$49*'Lookup Tables'!N3)*('Model Sensitivity'!$M$27/100))))","v":151543.87200000003},1784306.8800000004]
[]
[null,"TOTAL","m3",{"$f":"SUM(D8:D14)","v":48788432.657403998},{"$f":"SUM(E8:E14)","v":36637113.486752003},{"$f":"SUM(F8:F14)","v":60398463.545019992},{"$f":"SUM(G8:G14)","v":175922928.01182404},{"$f":"SUM(H8:H14)","v":546532450.69346786},476331548.33620805,160130616.087704,47891592.037478007,30996319.233104002,42317122.988833994,76548291.185689002,48714674.388114996,{"$f":"SUM(P8:P14)","v":1751209552.6516004}]
[]
[null,"OUTPUTS","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Direct Evaporation from Similkameen River","m3",{"$f":"('Lookup Tables'!R16/1000)*'Model Parameters'!$D$17","v":187765.26509999999},{"$f":"('Lookup Tables'!S16/1000)*'Model Parameters'!$D$17","v":281134.87779999996},{"$f":"('Lookup Tables'!T16/1000)*'Model Parameters'!$D$17","v":590998.86719999998},{"$f":"('Lookup Tables'!U16/1000)*'Model Parameters'!$D$17","v":913175.33299999998},{"$f":"('Lookup Tables'!V16/1000)*'Model Parameters'!$D$17","v":1310252.6969000001},{"$f":"('Lookup Tables'!W16/1000)*'Model Parameters'!$D$17","v":1475445.0886000001},{"$f":"('Lookup Tables'!X16/1000)*'Model Parameters'!$D$17","v":1697069.6638000002},{"$f":"('Lookup Tables'!Y16/1000)*'Model Parameters'!$D$17","v":1514434.5971999997},{"$f":"('Lookup Tables'!Z16/1000)*'Model Parameters'!$D$17","v":1006544.9456999999},{"$f":"('Lookup Tables'!AA16/1000)*'Model Parameters'!$D$17","v":542775.0013},{"$f":"('Lookup Tables'!AB16/1000)*'Model Parameters'!$D$17","v":243171.40889999998},{"$f":"('Lookup Tables'!AC16/1000)*'Model Parameters'!$D$17","v":163140.31230000002},{"$f":"SUM(D19:O19)","v":9925908.0578000005}]
[null,"Similkameen River Outflow","m3",{"$f":"('Lookup Tables'!R24*(60*60*24)) * 'Lookup Tables'!C3","v":51157440.000000007},{"$f":"('Lookup Tables'!S24*(60*60*24)) * 'Lookup Tables'!D3","v":42819840},{"$f":"('Lookup Tables'!T24*(60*60*24)) * 'Lookup Tables'!E3","v":61335359.999999993},{"$f":"('Lookup Tables'!U24*(60*60*24)) * 'Lookup Tables'!F3","v":151891200},{"$f":"('Lookup Tables'!V24*(60*60*24)) * 'Lookup Tables'!G3","v":490147200},{"$f":"('Lookup Tables'!W24*(60*60*24)) * 'Lookup Tables'!H3","v":482112000},{"$f":"('Lookup Tables'!X24*(60*60*24)) * 'Lookup Tables'!I3","v":181327680},{"$f":"('Lookup Tables'!Y24*(60*60*24)) * 'Lookup Tables'!J3","v":57853440.000000007},{"$f":"('Lookup Tables'!Z24*(60*60*24)) * 'Lookup Tables'!K3","v":34732800},{"$f":"('Lookup Tables'!AA24*(60*60*24)) * 'Lookup Tables'!L3","v":42854400},{"$f":"('Lookup Tables'!AB24*(60*60*24)) * 'Lookup Tables'!M3","v":71539200},{"$f":"('Lookup Tables'!AC24*(60*60*24)) * 'Lookup Tables'!N3","v":53835840.000000007},{"$f":"SUM(D20:O20)","v":1721606400}]
[null,"Groundwater Outflow at Downstream Aquifer Boundary","m3",{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!C3","v":620000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!D3","v":560000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!E3","v":620000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!F3","v":600000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!G3","v":620000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!H3","v":600000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!I3","v":620000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!J3","v":620000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!K3","v":600000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!L3","v":620000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!M3","v":600000},{"$f":"'Model Parameters'!$H$14*'Lookup Tables'!N3","v":620000},{"$f":"SUM(D21:O21)","v":7300000}]
[null,"Existing Annual Surface Water Demand From Similkameen River","m3",{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!R34*60*60*24*'Lookup Tables'!C3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!R34*60*60*24*'Lookup Tables'!C3) + (('Lookup Tables'!R34*60*60*24*'Lookup Tables'!C3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":77673.600000000006},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!S34*60*60*24*'Lookup Tables'!D3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!S34*60*60*24*'Lookup Tables'!D3) + (('Lookup Tables'!S34*60*60*24*'Lookup Tables'!D3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":70156.800000000017},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!T34*60*60*24*'Lookup Tables'!E3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!T34*60*60*24*'Lookup Tables'!E3) + (('Lookup Tables'!T34*60*60*24*'Lookup Tables'!E3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":77673.600000000006},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!U34*60*60*24*'Lookup Tables'!F3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!U34*60*60*24*'Lookup Tables'!F3) + (('Lookup Tables'!U34*60*60*24*'Lookup Tables'!F3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":75168.000000000015},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!V34*60*60*24*'Lookup Tables'!G3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!V34*60*60*24*'Lookup Tables'!G3) + (('Lookup Tables'!V34*60*60*24*'Lookup Tables'!G3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":80351.999999999985},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!W34*60*60*24*'Lookup Tables'!H3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!W34*60*60*24*'Lookup Tables'!H3) + (('Lookup Tables'!W34*60*60*24*'Lookup Tables'!H3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":77759.999999999985},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!X34*60*60*24*'Lookup Tables'!I3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!X34*60*60*24*'Lookup Tables'!I3) + (('Lookup Tables'!X34*60*60*24*'Lookup Tables'!I3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":80351.999999999985},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!Y34*60*60*24*'Lookup Tables'!J3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!Y34*60*60*24*'Lookup Tables'!J3) + (('Lookup Tables'!Y34*60*60*24*'Lookup Tables'!J3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":80351.999999999985},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!Z34*60*60*24*'Lookup Tables'!K3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!Z34*60*60*24*'Lookup Tables'!K3) + (('Lookup Tables'!Z34*60*60*24*'Lookup Tables'!K3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":77759.999999999985},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!AA34*60*60*24*'Lookup Tables'!L3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AA34*60*60*24*'Lookup Tables'!L3) + (('Lookup Tables'!AA34*60*60*24*'Lookup Tables'!L3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":77673.600000000006},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!AB34*60*60*24*'Lookup Tables'!M3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AB34*60*60*24*'Lookup Tables'!M3) + (('Lookup Tables'!AB34*60*60*24*'Lookup Tables'!M3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":75168.000000000015},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!AC34*60*60*24*'Lookup Tables'!N3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AC34*60*60*24*'Lookup Tables'!N3) + (('Lookup Tables'!AC34*60*60*24*'Lookup Tables'!N3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":77673.600000000006},{"$f":"SUM(D22:O22)","v":927763.2}]
[null,"Existing Seasonal Surface Water Demand From Similkameen River","m3",{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!R42*60*60*24*'Lookup Tables'!C3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!R42*60*60*24*'Lookup Tables'!C3) + (('Lookup Tables'!R42*60*60*24*'Lookup Tables'!C3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!S42*60*60*24*'Lookup Tables'!D3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!S42*60*60*24*'Lookup Tables'!D3) + (('Lookup Tables'!S42*60*60*24*'Lookup Tables'!D3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!T42*60*60*24*'Lookup Tables'!E3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!T42*60*60*24*'Lookup Tables'!E3) + (('Lookup Tables'!T42*60*60*24*'Lookup Tables'!E3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!U42*60*60*24*'Lookup Tables'!F3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!U42*60*60*24*'Lookup Tables'!F3) + (('Lookup Tables'!U42*60*60*24*'Lookup Tables'!F3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":46655.999999999993},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!V42*60*60*24*'Lookup Tables'!G3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!V42*60*60*24*'Lookup Tables'!G3) + (('Lookup Tables'!V42*60*60*24*'Lookup Tables'!G3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":554428.80000000005},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!W42*60*60*24*'Lookup Tables'!H3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!W42*60*60*24*'Lookup Tables'!H3) + (('Lookup Tables'!W42*60*60*24*'Lookup Tables'!H3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":1695168.0000000002},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!X42*60*60*24*'Lookup Tables'!I3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!X42*60*60*24*'Lookup Tables'!I3) + (('Lookup Tables'!X42*60*60*24*'Lookup Tables'!I3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":2413238.4000000004},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!Y42*60*60*24*'Lookup Tables'!J3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!Y42*60*60*24*'Lookup Tables'!J3) + (('Lookup Tables'!Y42*60*60*24*'Lookup Tables'!J3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":2190931.1999999997},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!Z42*60*60*24*'Lookup Tables'!K3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!Z42*60*60*24*'Lookup Tables'!K3) + (('Lookup Tables'!Z42*60*60*24*'Lookup Tables'!K3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":1288224},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!AA42*60*60*24*'Lookup Tables'!L3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AA42*60*60*24*'Lookup Tables'!L3) + (('Lookup Tables'!AA42*60*60*24*'Lookup Tables'!L3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!AB42*60*60*24*'Lookup Tables'!M3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AB42*60*60*24*'Lookup Tables'!M3) + (('Lookup Tables'!AB42*60*60*24*'Lookup Tables'!M3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", IF('Lookup Tables'!$D$76=2, ('Lookup Tables'!AC42*60*60*24*'Lookup Tables'!N3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AC42*60*60*24*'Lookup Tables'!N3) + (('Lookup Tables'!AC42*60*60*24*'Lookup Tables'!N3) * ('Model Sensitivity'!$M$31/100)))), 0)","v":0},8188646.4000000004]
[null,"Existing Annual Groundwater Demand","m3",{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!R52*60*60*24*'Lookup Tables'!C3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!R52*60*60*24*'Lookup Tables'!C3)+(('Lookup Tables'!R52*60*60*24*'Lookup Tables'!C3)*('Model Sensitivity'!$M$33/100)),0))","v":176774.39999999999},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!S52*60*60*24*'Lookup Tables'!D3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!S52*60*60*24*'Lookup Tables'!D3)+(('Lookup Tables'!S52*60*60*24*'Lookup Tables'!D3)*('Model Sensitivity'!$M$33/100)),0))","v":133056},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!T52*60*60*24*'Lookup Tables'!E3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!T52*60*60*24*'Lookup Tables'!E3)+(('Lookup Tables'!T52*60*60*24*'Lookup Tables'!E3)*('Model Sensitivity'!$M$33/100)),0))","v":158025.60000000001},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!U52*60*60*24*'Lookup Tables'!F3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!U52*60*60*24*'Lookup Tables'!F3)+(('Lookup Tables'!U52*60*60*24*'Lookup Tables'!F3)*('Model Sensitivity'!$M$33/100)),0))","v":173664},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!V52*60*60*24*'Lookup Tables'!G3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!V52*60*60*24*'Lookup Tables'!G3)+(('Lookup Tables'!V52*60*60*24*'Lookup Tables'!G3)*('Model Sensitivity'!$M$33/100)),0))","v":206236.79999999999},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!W52*60*60*24*'Lookup Tables'!H3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!W52*60*60*24*'Lookup Tables'!H3)+(('Lookup Tables'!W52*60*60*24*'Lookup Tables'!H3)*('Model Sensitivity'!$M$33/100)),0))","v":202175.99999999997},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!X52*60*60*24*'Lookup Tables'!I3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!X52*60*60*24*'Lookup Tables'!I3)+(('Lookup Tables'!X52*60*60*24*'Lookup Tables'!I3)*('Model Sensitivity'!$M$33/100)),0))","v":219628.79999999999},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!Y52*60*60*24*'Lookup Tables'!J3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!Y52*60*60*24*'Lookup Tables'!J3)+(('Lookup Tables'!Y52*60*60*24*'Lookup Tables'!J3)*('Model Sensitivity'!$M$33/100)),0))","v":235699.19999999995},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!Z52*60*60*24*'Lookup Tables'!K3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!Z52*60*60*24*'Lookup Tables'!K3)+(('Lookup Tables'!Z52*60*60*24*'Lookup Tables'!K3)*('Model Sensitivity'!$M$33/100)),0))","v":204768},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AA52*60*60*24*'Lookup Tables'!L3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!AA52*60*60*24*'Lookup Tables'!L3)+(('Lookup Tables'!AA52*60*60*24*'Lookup Tables'!L3)*('Model Sensitivity'!$M$33/100)),0))","v":174096.00000000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AB52*60*60*24*'Lookup Tables'!M3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!AB52*60*60*24*'Lookup Tables'!M3)+(('Lookup Tables'!AB52*60*60*24*'Lookup Tables'!M3)*('Model Sensitivity'!$M$33/100)),0))","v":145152},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AC52*60*60*24*'Lookup Tables'!N3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!AC52*60*60*24*'Lookup Tables'!N3)+(('Lookup Tables'!AC52*60*60*24*'Lookup Tables'!N3)*('Model Sensitivity'!$M$33/100)),0))","v":174096.00000000003},2203372.8000000003]
[null,"Existing Seasonal Groundwater Demand","m3",{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!R60*60*60*24*'Lookup Tables'!C3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!R60*60*60*24*'Lookup Tables'!C3)+(('Lookup Tables'!R60*60*60*24*'Lookup Tables'!C3)*('Model Sensitivity'!$M$33/100)),0))","v":0},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!S60*60*60*24*'Lookup Tables'!D3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!S60*60*60*24*'Lookup Tables'!D3)+(('Lookup Tables'!S60*60*60*24*'Lookup Tables'!D3)*('Model Sensitivity'!$M$33/100)),0))","v":0},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!T60*60*60*24*'Lookup Tables'!E3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!T60*60*60*24*'Lookup Tables'!E3)+(('Lookup Tables'!T60*60*60*24*'Lookup Tables'!E3)*('Model Sensitivity'!$M$33/100)),0))","v":0},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!U60*60*60*24*'Lookup Tables'!F3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!U60*60*60*24*'Lookup Tables'!F3)+(('Lookup Tables'!U60*60*60*24*'Lookup Tables'!F3)*('Model Sensitivity'!$M$33/100)),0))","v":202175.99999999997},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!V60*60*60*24*'Lookup Tables'!G3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!V60*60*60*24*'Lookup Tables'!G3)+(('Lookup Tables'!V60*60*60*24*'Lookup Tables'!G3)*('Model Sensitivity'!$M$33/100)),0))","v":1028505.6},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!W60*60*60*24*'Lookup Tables'!H3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!W60*60*60*24*'Lookup Tables'!H3)+(('Lookup Tables'!W60*60*60*24*'Lookup Tables'!H3)*('Model Sensitivity'!$M$33/100)),0))","v":2099520},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!X60*60*60*24*'Lookup Tables'!I3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!X60*60*60*24*'Lookup Tables'!I3)+(('Lookup Tables'!X60*60*60*24*'Lookup Tables'!I3)*('Model Sensitivity'!$M$33/100)),0))","v":2820355.1999999997},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!Y60*60*60*24*'Lookup Tables'!J3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!Y60*60*60*24*'Lookup Tables'!J3)+(('Lookup Tables'!Y60*60*60*24*'Lookup Tables'!J3)*('Model Sensitivity'!$M$33/100)),0))","v":2482876.8000000003},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!Z60*60*60*24*'Lookup Tables'!K3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!Z60*60*60*24*'Lookup Tables'!K3)+(('Lookup Tables'!Z60*60*60*24*'Lookup Tables'!K3)*('Model Sensitivity'!$M$33/100)),0))","v":1459296},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AA60*60*60*24*'Lookup Tables'!L3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!AA60*60*60*24*'Lookup Tables'!L3)+(('Lookup Tables'!AA60*60*60*24*'Lookup Tables'!L3)*('Model Sensitivity'!$M$33/100)),0))","v":0},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AB60*60*60*24*'Lookup Tables'!M3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!AB60*60*60*24*'Lookup Tables'!M3)+(('Lookup Tables'!AB60*60*60*24*'Lookup Tables'!M3)*('Model Sensitivity'!$M$33/100)),0))","v":0},{"$f":"IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AC60*60*60*24*'Lookup Tables'!N3),IF('Lookup Tables'!$D$76=1,('Lookup Tables'!AC60*60*60*24*'Lookup Tables'!N3)+(('Lookup Tables'!AC60*60*60*24*'Lookup Tables'!N3)*('Model Sensitivity'!$M$33/100)),0))","v":0},10092729.6]
[]
[null,"Total Existing Licensed Surface Water Demand","m3",{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!R66*60*60*24*'Lookup Tables'!C3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!R66*60*60*24*'Lookup Tables'!C3) + (('Lookup Tables'!R66*60*60*24*'Lookup Tables'!C3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!S66*60*60*24*'Lookup Tables'!D3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!S66*60*60*24*'Lookup Tables'!D3) + (('Lookup Tables'!S66*60*60*24*'Lookup Tables'!D3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!T66*60*60*24*'Lookup Tables'!E3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!T66*60*60*24*'Lookup Tables'!E3) + (('Lookup Tables'!T66*60*60*24*'Lookup Tables'!E3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!U66*60*60*24*'Lookup Tables'!F3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!U66*60*60*24*'Lookup Tables'!F3) + (('Lookup Tables'!U66*60*60*24*'Lookup Tables'!F3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!V66*60*60*24*'Lookup Tables'!G3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!V66*60*60*24*'Lookup Tables'!G3) + (('Lookup Tables'!V66*60*60*24*'Lookup Tables'!G3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!W66*60*60*24*'Lookup Tables'!H3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!W66*60*60*24*'Lookup Tables'!H3) + (('Lookup Tables'!W66*60*60*24*'Lookup Tables'!H3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!X66*60*60*24*'Lookup Tables'!I3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!X66*60*60*24*'Lookup Tables'!I3) + (('Lookup Tables'!X66*60*60*24*'Lookup Tables'!I3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!Y66*60*60*24*'Lookup Tables'!J3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!Y66*60*60*24*'Lookup Tables'!J3) + (('Lookup Tables'!Y66*60*60*24*'Lookup Tables'!J3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!Z66*60*60*24*'Lookup Tables'!K3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!Z66*60*60*24*'Lookup Tables'!K3) + (('Lookup Tables'!Z66*60*60*24*'Lookup Tables'!K3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AA66*60*60*24*'Lookup Tables'!L3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AA66*60*60*24*'Lookup Tables'!L3) + (('Lookup Tables'!AA66*60*60*24*'Lookup Tables'!L3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AB66*60*60*24*'Lookup Tables'!M3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AB66*60*60*24*'Lookup Tables'!M3) + (('Lookup Tables'!AB66*60*60*24*'Lookup Tables'!M3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"IF('Model Parameters'!$H$21=\"Total Licensed Demand\", IF('Lookup Tables'!$D$76=2,('Lookup Tables'!AC66*60*60*24*'Lookup Tables'!N3), IF('Lookup Tables'!$D$76=1, ('Lookup Tables'!AC66*60*60*24*'Lookup Tables'!N3) + (('Lookup Tables'!AC66*60*60*24*'Lookup Tables'!N3) * ('Model Sensitivity'!$M$35/100)))),0)","v":0},{"$f":"SUM(D27:O27)","v":0}]
[]
[null,"TOTAL","m3",{"$f":"SUM(D19:D27)","v":52219653.26510001},{"$f":"SUM(E19:E27)","v":43864187.6778},62782058.067199998,153902039.333,493946975.89690006,488262069.08859998,189178324.06380001,64977733.797200009,39369392.945699997,44268944.601300001,72602691.408899993,54870749.912300006,{"$f":"SUM(P19:P25,P27)","v":1760244820.0578001}]
[]
[null,"RESULT","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"System Net"]
[null,"Surplus/Deficit","m3",{"$f":"D16-D29","v":-3431220.6076960117},-7227074.1910479963,-2383594.5221800059,22020888.678824037,52585474.796567798,-11930520.752391934,-29047707.976096004,-17086141.759722002,-8373073.7125959955,-1951821.6124660075,3945599.7767890096,-6156075.5241850093,-9035267.4061996937]
[null,"ΔhGW (Simulated)","m",{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!D33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!D33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.10940118655038905},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!E33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!E33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.2304283466982463},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!F33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!F33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-7.5998631040106818E-2},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!G33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!G33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":0.70211496892793601},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!H33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!H33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":1.6766375572461512},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!I33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!I33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.38039324068764546},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!J33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!J33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.92615837991482608},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!K33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!K33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.54477528430819711},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!L33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!L33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.26696744510606185},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!M33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!M33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-6.2231964875571373E-2},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!N33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!N33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":0.12580167426877092},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!O33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!O33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.19628057879142793},{"$f":"IF('Lookup Tables'!$D$76=2, ('Water Budget'!P33/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF('Lookup Tables'!$D$76=1, 'Water Budget'!P33/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.28808085752960005}]
[null,"Ratio Qsw in - R/Qsw out","-",{"$f":"((D9+D10)-D11)/D20","v":0.924586867042135},0.83365403952345452,0.92436881233728796,1.1295354401899254,1.1073510449304456,0.9825461949733505,0.87113159764408821,0.79533365140641576,0.84282060690459737,0.9381012881959846,1.0540823749889712,0.88211471270226294,1.0014296446547828]
[]
[null,"Surface Water Only"]
[null,"Surplus/Deficit","m3",{"$f":"(D8+D9+D10) - (D19+D20+D22+D23+D27)","v":-3409659.5042000115},{"$f":"(E8+E9+E10) - (E19+E20+E22+E23+E27)","v":-7110668.7392999977},-3606319.9167000055,20667391.971799999,52355218.254299939,-10664502.161399961,-26947976.312600017,-15147254.150100008,-7281227.4970999956,-2315919.4396000057,4122152.2576000094,-6022298.6615000069,-5361063.8988001347]
[null,"Δh Surface Water Component Only","m",{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!D38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!D38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.10871373139215543},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!E38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!E38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.22671687023019246},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!F38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!F38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.11498406050673692},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!G38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!G38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":0.65896002126635078},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!H38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!H38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":1.6692960476741368},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!I38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!I38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.34002744906855864},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!J38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!J38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.85921044456241791},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!K38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!K38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.48295570773980928},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!L38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!L38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.23215497305518382},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!M38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!M38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-7.3840875774373843E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!N38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!N38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":0.13143088121798768},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!O38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!O38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.19201523150425512},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!P38/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!P38/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.17093239367521049}]
[]
[null,"Groundwater Only"]
[null,"Surplus/Deficit","m3",{"$f":"(D11+D12+D13+D14) - (D21+D24+D25)","v":-21561.103496000054},{"$f":"(E11+E12+E13+E14) - (E21+E24+E25)","v":-116405.45174799999},1222725.3945199996,1353496.7070239997,{"$f":"(H11+H12+H13+H14) - (H21+H24+H25)","v":230256.54226799961},-1266018.5909920002,-2099731.6634960002,-1938887.6096220003,-1091846.2154959999,364097.8271339999,-176552.48081099999,-133776.86268500006,-3674203.5074000005]
[null,"Δh Groundwater Component Only","m",{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!D42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!D42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-6.8745515823362814E-4},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!E42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!E42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-3.7114764680538734E-3},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!F42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!F42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":3.8985429466630098E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!G42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!G42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":4.3154947661584009E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!H42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!H42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":7.341509572018956E-3},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!I42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!I42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-4.0365791619087654E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!J42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!J42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-6.6947935352408575E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!K42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!K42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-6.1819576568387991E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!L42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!L42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-3.4812472050878042E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!M42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!M42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":1.1608910898802519E-2},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!N42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!N42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-5.6292069492167749E-3},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!O42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!O42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-4.2653472871727657E-3},{"$f":"IF('Lookup Tables'!$D$76=2, 'Water Budget'!P42/('Model Parameters'!$D$13 * 'Model Parameters'!$D$14), IF('Lookup Tables'!$D$76=1, 'Water Budget'!P42/('Model Parameters'!$D$13 * 'Model Sensitivity'!$M$17)))","v":-0.11714846385440367}]

{"sheet":"Model Sensitivity","index":4,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,1,4,13],[12,7,12,13],[36,7,36,8]]}
[null,{"$f":"Main!$B$11","v":"Similkameen Valley Aquifer"}]
[null,{"$f":"CONCATENATE(\"Aquifer #\", Main!$B$12)","v":"Aquifer #259"}]
[]
[]
[null,"MODEL SENSITIVITY"]
[]
[null,null,"Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"Simulated ΔhGW","m",{"$f":"'Water Budget'!D34","v":-0.10940118655038905},{"$f":"'Water Budget'!E34","v":-0.2304283466982463},{"$f":"'Water Budget'!F34","v":-7.5998631040106818E-2},{"$f":"'Water Budget'!G34","v":0.70211496892793601},{"$f":"'Water Budget'!H34","v":1.6766375572461512},{"$f":"'Water Budget'!I34","v":-0.38039324068764546},{"$f":"'Water Budget'!J34","v":-0.92615837991482608},{"$f":"'Water Budget'!K34","v":-0.54477528430819711},{"$f":"'Water Budget'!L34","v":-0.26696744510606185},{"$f":"'Water Budget'!M34","v":-6.2231964875571373E-2},{"$f":"'Water Budget'!N34","v":0.12580167426877092},{"$f":"'Water Budget'!O34","v":-0.19628057879142793}]
[]
[null,"Observed ΔhGW","m",{"$f":"'Lookup Tables'!C71-'Lookup Tables'!D71","v":0.10200000000000031},{"$f":"'Lookup Tables'!D71-'Lookup Tables'!E71","v":-0.1160000000000001},{"$f":"'Lookup Tables'!E71-'Lookup Tables'!F71","v":5.7999999999999829E-2},{"$f":"'Lookup Tables'!F71-'Lookup Tables'!G71","v":0.17700000000000005},{"$f":"'Lookup Tables'!G71-'Lookup Tables'!H71","v":0.49700000000000011},{"$f":"'Lookup Tables'!H71-'Lookup Tables'!I71","v":-8.5000000000000187E-2},{"$f":"'Lookup Tables'!I71-'Lookup Tables'!J71","v":-0.25199999999999978},{"$f":"'Lookup Tables'!J71-'Lookup Tables'!K71","v":-0.42799999999999994},{"$f":"'Lookup Tables'!K71-'Lookup Tables'!L71","v":-0.14800000000000013},{"$f":"'Lookup Tables'!L71-'Lookup Tables'!M71","v":1.5000000000000124E-2},{"$f":"'Lookup Tables'!M71-'Lookup Tables'!N71","v":0.18199999999999994},{"$f":"'Lookup Tables'!N71-'Lookup Tables'!O71","v":-2.0000000000002238E-3}]
[]
[]
[null,null,null,null,null,null,null,"MODEL SENSITIVITY PARAMETERS"]
[]
[null,null,null,null,null,null,"Model Sensitivity Mode:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slider Value"]
[null,null,null,null,null,null,"Specific Yield",null,null,null,null,null,{"$f":"P17/100","v":0.26},null,null,26]
[]
[null,null,null,null,null,null,"Percentage of Precipitation Recharging Aquifer",null,null,null,null,"%",20,20]
[]
[null,null,null,null,null,null,"Irrigation Return to Aquifer",null,null,null,null,"%",15,15]
[]
[null,null,null,null,null,null,"Percentage change of Tributary Inflow Estimates",null,null,null,null,"+/- %",{"$f":"P23-20","v":0},null,null,20]
[]
[null,null,null,null,null,null,"Groundwater Inflow - Hydraulic Conductivity (K)",null,null,null,null,"m/day",89,89]
[]
[null,null,null,null,null,null,"Percentage change of MBR Estimate",null,null,null,null,"+/- %",{"$f":"P27-20","v":0},null,null,20]
[]
[null,null,null,null,null,null,"Groundwater Outflow - Hydraulic Conductivity (K)",null,null,null,null,"m/day",100,100]
[]
[null,null,null,null,null,null,"Percentage change of Total Estimated Surface Water Demand",null,null,null,null,"+/- %",{"$f":"P31-20","v":0},null,null,20]
[]
[null,null,null,null,null,null,"Percentage change of Total Estimated Groundwater Demand",null,null,null,null,"+/- %",{"$f":"P33-20","v":0},null,null,20]
[]
[null,null,null,null,null,null,"Percentage change of Total Licensed Water Demand",null,null,null,null,"+/- %",{"$f":"P35-20","v":0},null,null,20]
[]
[null,null,null,null,null,null,null,"Relationship between ΔhGW"]
[null,null,null,null,null,null,null,"R-Squared",{"$f":"RSQ(D10:O10,D8:O8)","v":0.79333298985057732}]
[null,null,null,null,null,null,null,"RMSE",{"$f":"SQRT(SUM((D10-D8)^2, (E10-E8)^2, (F10-F8)^2, (G10-G8)^2, (H10-H8)^2, (I10-I8)^2, (J10-J8)^2, (K10-K8)^2, (L10-L8)^2, (M10-M8)^2, (N10-N8)^2, (O10-O8)^2)/12)","v":0.4434180512191821}]

{"sheet":"Model Output","index":5,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[24,3,24,4],[24,5,24,7],[4,1,4,16],[23,5,23,7],[21,5,21,7],[22,5,22,7],[23,3,23,4],[21,3,21,4],[22,3,22,4]]}
[null,{"$f":"Main!$B$11","v":"Similkameen Valley Aquifer"}]
[null,{"$f":"CONCATENATE(\"Aquifer #\", Main!$B$12)","v":"Aquifer #259"}]
[]
[]
[null,"MODEL OUTPUT"]
[]
[null,"SYSTEM NET","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Surplus/Deficit","m3",{"$f":"'Water Budget'!D33","v":-3431220.6076960117},{"$f":"'Water Budget'!E33","v":-7227074.1910479963},{"$f":"'Water Budget'!F33","v":-2383594.5221800059},{"$f":"'Water Budget'!G33","v":22020888.678824037},{"$f":"'Water Budget'!H33","v":52585474.796567798},{"$f":"'Water Budget'!I33","v":-11930520.752391934},{"$f":"'Water Budget'!J33","v":-29047707.976096004},{"$f":"'Water Budget'!K33","v":-17086141.759722002},{"$f":"'Water Budget'!L33","v":-8373073.7125959955},{"$f":"'Water Budget'!M33","v":-1951821.6124660075},{"$f":"'Water Budget'!N33","v":3945599.7767890096},{"$f":"'Water Budget'!O33","v":-6156075.5241850093},{"$f":"SUM(D8:O8)","v":-9035267.4062001221}]
[null,"Simulated Groundwater Level (Calibrated)","m bgl",{"$f":"'Lookup Tables'!C71-'Water Budget'!D34","v":2.7974011865503892},{"$f":"D9-'Water Budget'!E34","v":3.0278295332486356},{"$f":"E9-'Water Budget'!F34","v":3.1038281642887422},{"$f":"F9-'Water Budget'!G34","v":2.4017131953608062},{"$f":"G9-'Water Budget'!H34","v":0.72507563811465503},{"$f":"H9-'Water Budget'!I34","v":1.1054688788023004},{"$f":"I9-'Water Budget'!J34","v":2.0316272587171262},{"$f":"J9-'Water Budget'!K34","v":2.5764025430253232},{"$f":"K9-'Water Budget'!L34","v":2.8433699881313852},{"$f":"L9-'Water Budget'!M34","v":2.9056019530069568},{"$f":"M9-'Water Budget'!N34","v":2.7798002787381857},{"$f":"N9-'Water Budget'!O34","v":2.9760808575296136}]
[null,"Observed Groundwater Level (Well 75)","m bgl",{"$f":"'Lookup Tables'!D71","v":2.5859999999999999},{"$f":"'Lookup Tables'!E71","v":2.702},{"$f":"'Lookup Tables'!F71","v":2.6440000000000001},{"$f":"'Lookup Tables'!G71","v":2.4670000000000001},{"$f":"'Lookup Tables'!H71","v":1.97},{"$f":"'Lookup Tables'!I71","v":2.0550000000000002},{"$f":"'Lookup Tables'!J71","v":2.3069999999999999},{"$f":"'Lookup Tables'!K71","v":2.7349999999999999},{"$f":"'Lookup Tables'!L71","v":2.883},{"$f":"'Lookup Tables'!M71","v":2.8679999999999999},{"$f":"'Lookup Tables'!N71","v":2.6859999999999999},{"$f":"'Lookup Tables'!O71","v":2.6880000000000002}]
[]
[null,"Similkameen River Outflow","m3/s",{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!R24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!R24 + SUM('Lookup Tables'!R34,'Lookup Tables'!R42)) - 'Lookup Tables'!R66))","v":19.100000000000001},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!S24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!S24 + SUM('Lookup Tables'!S34,'Lookup Tables'!S42)) - 'Lookup Tables'!S66))","v":17.7},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!T24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!T24 + SUM('Lookup Tables'!T34,'Lookup Tables'!T42)) - 'Lookup Tables'!T66))","v":22.9},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!U24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!U24 + SUM('Lookup Tables'!U34,'Lookup Tables'!U42)) - 'Lookup Tables'!U66))","v":58.6},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!V24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!V24 + SUM('Lookup Tables'!V34,'Lookup Tables'!V42)) - 'Lookup Tables'!V66))","v":183},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!W24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!W24 + SUM('Lookup Tables'!W34,'Lookup Tables'!W42)) - 'Lookup Tables'!W66))","v":186},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!X24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!X24 + SUM('Lookup Tables'!X34,'Lookup Tables'!X42)) - 'Lookup Tables'!X66))","v":67.7},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!Y24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!Y24 + SUM('Lookup Tables'!Y34,'Lookup Tables'!Y42)) - 'Lookup Tables'!Y66))","v":21.6},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!Z24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!Z24 + SUM('Lookup Tables'!Z34,'Lookup Tables'!Z42)) - 'Lookup Tables'!Z66))","v":13.4},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!AA24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!AA24 + SUM('Lookup Tables'!AA34,'Lookup Tables'!AA42)) - 'Lookup Tables'!AA66))","v":16},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!AB24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!AB24 + SUM('Lookup Tables'!AB34,'Lookup Tables'!AB42)) - 'Lookup Tables'!AB66))","v":27.6},{"$f":"IF('Model Parameters'!$H$21=\"Estimated Actual Demand\", 'Lookup Tables'!AC24, IF('Model Parameters'!$H$21=\"Total Licensed Demand\", ('Lookup Tables'!AC24 + SUM('Lookup Tables'!AC34,'Lookup Tables'!AC42)) - 'Lookup Tables'!AC66))","v":20.100000000000001}]
[null,"Environmental Flow Needs (Rearing)","m3/s",null,null,null,null,4.78,4.78,4.78,4.78,4.78,4.78]
[null,"Environmental Flow Needs (Spawning)","m3/s",null,null,null,null,9.5299999999999994,9.5299999999999994,9.5299999999999994,9.5299999999999994,9.5299999999999994]
[]
[null,"Surplus/Deficit (including New Licence)","m3",{"$f":"D8-D34","v":-3431220.6076960117},{"$f":"E8-E34","v":-7227074.1910479963},-2383594.5221800059,22020888.678824037,52585474.796567798,-11930520.752391934,-29047707.976096004,-17086141.759722002,-8373073.7125959955,-1951821.6124660075,3945599.7767890096,-6156075.5241850093,{"$f":"SUM(D16:O16)","v":-9035267.4062001221}]
[null,"Simulated Groundwater Level (including New Licence) ","m bgl",{"$f":"'Lookup Tables'!C71 - IF('Lookup Tables'!$D$76=2,(D8-D34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(D8-D34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.7974011865503892},{"$f":"D9-IF('Lookup Tables'!$D$76=2,(E8-E34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(E8-E34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":3.0278295332486356},{"$f":"E9-IF('Lookup Tables'!$D$76=2,(F8-F34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(F8-F34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":3.1038281642887422},{"$f":"F9-IF('Lookup Tables'!$D$76=2,(G8-G34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(G8-G34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.4017131953608062},{"$f":"G9-IF('Lookup Tables'!$D$76=2,(H8-H34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(H8-H34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.72507563811465503},{"$f":"H9-IF('Lookup Tables'!$D$76=2,(I8-I34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(I8-I34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":1.1054688788023004},{"$f":"I9-IF('Lookup Tables'!$D$76=2,(J8-J34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(J8-J34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.0316272587171262},{"$f":"J9-IF('Lookup Tables'!$D$76=2,(K8-K34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(K8-K34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.5764025430253232},{"$f":"K9-IF('Lookup Tables'!$D$76=2,(L8-L34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(L8-L34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.8433699881313852},{"$f":"L9-IF('Lookup Tables'!$D$76=2,(M8-M34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(M8-M34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.9056019530069568},{"$f":"M9-IF('Lookup Tables'!$D$76=2,(N8-N34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(N8-N34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.7798002787381857},{"$f":"N9-IF('Lookup Tables'!$D$76=2,(O8-O34)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(O8-O34)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":2.9760808575296136}]
[null,"Groundwater Level Allocation Threshold","m bgl",3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998,3.1949999999999998]
[null,"Volume Available for Allocation (Maximum Licensed versus Allocation Threshold)","m3",{"$f":"(D18-'Lookup Tables'!C100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":10841683.127623988},{"$f":"(E18-'Lookup Tables'!D100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":3859293.7365759853},{"$f":"(F18-'Lookup Tables'!E100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":1338150.414395984},{"$f":"(G18-'Lookup Tables'!F100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":22786034.293220025},{"$f":"(H18-'Lookup Tables'!G100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":72130472.289787799},{"$f":"(I18-'Lookup Tables'!H100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":55154364.337395884},{"$f":"(J18-'Lookup Tables'!I100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":21558214.761299886},{"$f":"(K18-'Lookup Tables'!J100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":5556825.0015778765},{"$f":"(L18-'Lookup Tables'!K100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":2721040.8889818895},{"$f":"(M18-'Lookup Tables'!L100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":7279372.8765158681},{"$f":"(N18-'Lookup Tables'!M100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":11643235.053304881},{"$f":"(O18-'Lookup Tables'!N100) * ('Model Parameters'!$D$14*'Model Parameters'!$D$13)","v":5417089.1291198796},{"$f":"SUM(D19:O19)","v":220285775.90979993}]
[null,"Similkameen River Outflow (including New Licence)","m3/s",{"$f":"IF((D12 - (D34 / (60*60*24*'Lookup Tables'!C3))) < 0, 0, D12 - (D34 / (60*60*24*'Lookup Tables'!C3)))","v":19.100000000000001},{"$f":"IF((E12 - (E34 / (60*60*24*'Lookup Tables'!D3))) < 0, 0, E12 - (E34 / (60*60*24*'Lookup Tables'!D3)))","v":17.7},{"$f":"IF((F12 - (F34 / (60*60*24*'Lookup Tables'!E3))) < 0, 0, F12 - (F34 / (60*60*24*'Lookup Tables'!E3)))","v":22.9},{"$f":"IF((G12 - (G34 / (60*60*24*'Lookup Tables'!F3))) < 0, 0, G12 - (G34 / (60*60*24*'Lookup Tables'!F3)))","v":58.6},{"$f":"IF((H12 - (H34 / (60*60*24*'Lookup Tables'!G3))) < 0, 0, H12 - (H34 / (60*60*24*'Lookup Tables'!G3)))","v":183},{"$f":"IF((I12 - (I34 / (60*60*24*'Lookup Tables'!H3))) < 0, 0, I12 - (I34 / (60*60*24*'Lookup Tables'!H3)))","v":186},{"$f":"IF((J12 - (J34 / (60*60*24*'Lookup Tables'!I3))) < 0, 0, J12 - (J34 / (60*60*24*'Lookup Tables'!I3)))","v":67.7},{"$f":"IF((K12 - (K34 / (60*60*24*'Lookup Tables'!J3))) < 0, 0, K12 - (K34 / (60*60*24*'Lookup Tables'!J3)))","v":21.6},{"$f":"IF((L12 - (L34 / (60*60*24*'Lookup Tables'!K3))) < 0, 0, L12 - (L34 / (60*60*24*'Lookup Tables'!K3)))","v":13.4},{"$f":"IF((M12 - (M34 / (60*60*24*'Lookup Tables'!L3))) < 0, 0, M12 - (M34 / (60*60*24*'Lookup Tables'!L3)))","v":16},{"$f":"IF((N12 - (N34 / (60*60*24*'Lookup Tables'!M3))) < 0, 0, N12 - (N34 / (60*60*24*'Lookup Tables'!M3)))","v":27.6},{"$f":"IF((O12 - (O34 / (60*60*24*'Lookup Tables'!N3))) < 0, 0, O12 - (O34 / (60*60*24*'Lookup Tables'!N3)))","v":20.100000000000001}]
[]
[null,"FUTURE LICENSED WATER DEMAND","Units",null,null,"Select Demand Distribution"]
[]
[null,"New Surface Water Licence","m3/year",null,null,"ANNUAL"]
[null,"New Groundwater Licence","m3/year",null,null,"ANNUAL"]
[]
[null,"FUTURE LICENSED WATER DEMAND DATA","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Annual Demand","m3",{"$f":"SUM('Lookup Tables'!R69,'Lookup Tables'!R76)","v":0},{"$f":"SUM('Lookup Tables'!S69,'Lookup Tables'!S76)","v":0},{"$f":"SUM('Lookup Tables'!T69,'Lookup Tables'!T76)","v":0},{"$f":"SUM('Lookup Tables'!U69,'Lookup Tables'!U76)","v":0},{"$f":"SUM('Lookup Tables'!V69,'Lookup Tables'!V76)","v":0},{"$f":"SUM('Lookup Tables'!W69,'Lookup Tables'!W76)","v":0},{"$f":"SUM('Lookup Tables'!X69,'Lookup Tables'!X76)","v":0},{"$f":"SUM('Lookup Tables'!Y69,'Lookup Tables'!Y76)","v":0},{"$f":"SUM('Lookup Tables'!Z69,'Lookup Tables'!Z76)","v":0},{"$f":"SUM('Lookup Tables'!AA69,'Lookup Tables'!AA76)","v":0},{"$f":"SUM('Lookup Tables'!AB69,'Lookup Tables'!AB76)","v":0},{"$f":"SUM('Lookup Tables'!AC69,'Lookup Tables'!AC76)","v":0},{"$f":"SUM(D28:O28)","v":0}]
[null,"Seasonal Demand","m3",{"$f":"SUM('Lookup Tables'!R70,'Lookup Tables'!R77)","v":0},{"$f":"SUM('Lookup Tables'!S70,'Lookup Tables'!S77)","v":0},{"$f":"SUM('Lookup Tables'!T70,'Lookup Tables'!T77)","v":0},{"$f":"SUM('Lookup Tables'!U70,'Lookup Tables'!U77)","v":0},{"$f":"SUM('Lookup Tables'!V70,'Lookup Tables'!V77)","v":0},{"$f":"SUM('Lookup Tables'!W70,'Lookup Tables'!W77)","v":0},{"$f":"SUM('Lookup Tables'!X70,'Lookup Tables'!X77)","v":0},{"$f":"SUM('Lookup Tables'!Y70,'Lookup Tables'!Y77)","v":0},{"$f":"SUM('Lookup Tables'!Z70,'Lookup Tables'!Z77)","v":0},{"$f":"SUM('Lookup Tables'!AA70,'Lookup Tables'!AA77)","v":0},{"$f":"SUM('Lookup Tables'!AB70,'Lookup Tables'!AB77)","v":0},{"$f":"SUM('Lookup Tables'!AC70,'Lookup Tables'!AC77)","v":0},{"$f":"SUM(D29:O29)","v":0}]
[null,"Other Demand","m3",{"$f":"SUM('Lookup Tables'!R71,'Lookup Tables'!R78)","v":0},{"$f":"SUM('Lookup Tables'!S71,'Lookup Tables'!S78)","v":0},{"$f":"SUM('Lookup Tables'!T71,'Lookup Tables'!T78)","v":0},{"$f":"SUM('Lookup Tables'!U71,'Lookup Tables'!U78)","v":0},{"$f":"SUM('Lookup Tables'!V71,'Lookup Tables'!V78)","v":0},{"$f":"SUM('Lookup Tables'!W71,'Lookup Tables'!W78)","v":0},{"$f":"SUM('Lookup Tables'!X71,'Lookup Tables'!X78)","v":0},{"$f":"SUM('Lookup Tables'!Y71,'Lookup Tables'!Y78)","v":0},{"$f":"SUM('Lookup Tables'!Z71,'Lookup Tables'!Z78)","v":0},{"$f":"SUM('Lookup Tables'!AA71,'Lookup Tables'!AA78)","v":0},{"$f":"SUM('Lookup Tables'!AB71,'Lookup Tables'!AB78)","v":0},{"$f":"SUM('Lookup Tables'!AC71,'Lookup Tables'!AC78)","v":0},{"$f":"SUM(D30:O30)","v":0}]
[]
[null,"If 'Other Demand', define monthly distribution","%",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D32:O32)","v":0}]
[]
[null,"Total Demand","m3",{"$f":"SUM('Lookup Tables'!R73,'Lookup Tables'!R80)","v":0},{"$f":"SUM('Lookup Tables'!S73,'Lookup Tables'!S80)","v":0},{"$f":"SUM('Lookup Tables'!T73,'Lookup Tables'!T80)","v":0},{"$f":"SUM('Lookup Tables'!U73,'Lookup Tables'!U80)","v":0},{"$f":"SUM('Lookup Tables'!V73,'Lookup Tables'!V80)","v":0},{"$f":"SUM('Lookup Tables'!W73,'Lookup Tables'!W80)","v":0},{"$f":"SUM('Lookup Tables'!X73,'Lookup Tables'!X80)","v":0},{"$f":"SUM('Lookup Tables'!Y73,'Lookup Tables'!Y80)","v":0},{"$f":"SUM('Lookup Tables'!Z73,'Lookup Tables'!Z80)","v":0},{"$f":"SUM('Lookup Tables'!AA73,'Lookup Tables'!AA80)","v":0},{"$f":"SUM('Lookup Tables'!AB73,'Lookup Tables'!AB80)","v":0},{"$f":"SUM('Lookup Tables'!AC73,'Lookup Tables'!AC80)","v":0},{"$f":"SUM(D34:O34)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SURFACE WATER ONLY","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Surplus/Deficit","m3",{"$f":"'Water Budget'!D38","v":-3409659.5042000115},{"$f":"'Water Budget'!E38","v":-7110668.7392999977},{"$f":"'Water Budget'!F38","v":-3606319.9167000055},{"$f":"'Water Budget'!G38","v":20667391.971799999},{"$f":"'Water Budget'!H38","v":52355218.254299939},{"$f":"'Water Budget'!I38","v":-10664502.161399961},{"$f":"'Water Budget'!J38","v":-26947976.312600017},{"$f":"'Water Budget'!K38","v":-15147254.150100008},{"$f":"'Water Budget'!L38","v":-7281227.4970999956},{"$f":"'Water Budget'!M38","v":-2315919.4396000057},{"$f":"'Water Budget'!N38","v":4122152.2576000094},{"$f":"'Water Budget'!O38","v":-6022298.6615000069},{"$f":"'Water Budget'!P38","v":-5361063.8988001347}]
[null,"Δh Surface Water Component","m",{"$f":"'Water Budget'!D39","v":-0.10871373139215543},{"$f":"'Water Budget'!E39","v":-0.22671687023019246},{"$f":"'Water Budget'!F39","v":-0.11498406050673692},{"$f":"'Water Budget'!G39","v":0.65896002126635078},{"$f":"'Water Budget'!H39","v":1.6692960476741368},{"$f":"'Water Budget'!I39","v":-0.34002744906855864},{"$f":"'Water Budget'!J39","v":-0.85921044456241791},{"$f":"'Water Budget'!K39","v":-0.48295570773980928},{"$f":"'Water Budget'!L39","v":-0.23215497305518382},{"$f":"'Water Budget'!M39","v":-7.3840875774373843E-2},{"$f":"'Water Budget'!N39","v":0.13143088121798768},{"$f":"'Water Budget'!O39","v":-0.19201523150425512}]
[null,"Δh Surface Water Component including New Licence","m",{"$f":"IF('Lookup Tables'!$D$76=2,(D61-'Lookup Tables'!R73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(D61-'Lookup Tables'!R73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.10871373139215543},{"$f":"IF('Lookup Tables'!$D$76=2,(E61-'Lookup Tables'!S73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(E61-'Lookup Tables'!S73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.22671687023019246},{"$f":"IF('Lookup Tables'!$D$76=2,(F61-'Lookup Tables'!T73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(F61-'Lookup Tables'!T73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.11498406050673692},{"$f":"IF('Lookup Tables'!$D$76=2,(G61-'Lookup Tables'!U73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(G61-'Lookup Tables'!U73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.65896002126635078},{"$f":"IF('Lookup Tables'!$D$76=2,(H61-'Lookup Tables'!V73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(H61-'Lookup Tables'!V73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":1.6692960476741368},{"$f":"IF('Lookup Tables'!$D$76=2,(I61-'Lookup Tables'!W73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(I61-'Lookup Tables'!W73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.34002744906855864},{"$f":"IF('Lookup Tables'!$D$76=2,(J61-'Lookup Tables'!X73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(J61-'Lookup Tables'!X73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.85921044456241791},{"$f":"IF('Lookup Tables'!$D$76=2,(K61-'Lookup Tables'!Y73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(K61-'Lookup Tables'!Y73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.48295570773980928},{"$f":"IF('Lookup Tables'!$D$76=2,(L61-'Lookup Tables'!Z73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(L61-'Lookup Tables'!Z73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.23215497305518382},{"$f":"IF('Lookup Tables'!$D$76=2,(M61-'Lookup Tables'!AA73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(M61-'Lookup Tables'!AA73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-7.3840875774373843E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(N61-'Lookup Tables'!AB73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(N61-'Lookup Tables'!AB73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.13143088121798768},{"$f":"IF('Lookup Tables'!$D$76=2,(O61-'Lookup Tables'!AC73)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(O61-'Lookup Tables'!AC73)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-0.19201523150425512}]
[null,""]
[null,"GROUNDWATER ONLY","Units","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Surplus/Deficit","m3",{"$f":"'Water Budget'!D42","v":-21561.103496000054},{"$f":"'Water Budget'!E42","v":-116405.45174799999},{"$f":"'Water Budget'!F42","v":1222725.3945199996},{"$f":"'Water Budget'!G42","v":1353496.7070239997},{"$f":"'Water Budget'!H42","v":230256.54226799961},{"$f":"'Water Budget'!I42","v":-1266018.5909920002},{"$f":"'Water Budget'!J42","v":-2099731.6634960002},{"$f":"'Water Budget'!K42","v":-1938887.6096220003},{"$f":"'Water Budget'!L42","v":-1091846.2154959999},{"$f":"'Water Budget'!M42","v":364097.8271339999},{"$f":"'Water Budget'!N42","v":-176552.48081099999},{"$f":"'Water Budget'!O42","v":-133776.86268500006},{"$f":"'Water Budget'!P42","v":-3674203.5074000005}]
[null,"Δh Groundwater Component","m",{"$f":"'Water Budget'!D43","v":-6.8745515823362814E-4},{"$f":"'Water Budget'!E43","v":-3.7114764680538734E-3},{"$f":"'Water Budget'!F43","v":3.8985429466630098E-2},{"$f":"'Water Budget'!G43","v":4.3154947661584009E-2},{"$f":"'Water Budget'!H43","v":7.341509572018956E-3},{"$f":"'Water Budget'!I43","v":-4.0365791619087654E-2},{"$f":"'Water Budget'!J43","v":-6.6947935352408575E-2},{"$f":"'Water Budget'!K43","v":-6.1819576568387991E-2},{"$f":"'Water Budget'!L43","v":-3.4812472050878042E-2},{"$f":"'Water Budget'!M43","v":1.1608910898802519E-2},{"$f":"'Water Budget'!N43","v":-5.6292069492167749E-3},{"$f":"'Water Budget'!O43","v":-4.2653472871727657E-3}]
[null,"Δh Groundwater Component Only including New Licence","m",{"$f":"IF('Lookup Tables'!$D$76=2,(D66-'Lookup Tables'!R80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(D66-'Lookup Tables'!R80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-6.8745515823362814E-4},{"$f":"IF('Lookup Tables'!$D$76=2,(E66-'Lookup Tables'!S80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(E66-'Lookup Tables'!S80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-3.7114764680538734E-3},{"$f":"IF('Lookup Tables'!$D$76=2,(F66-'Lookup Tables'!T80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(F66-'Lookup Tables'!T80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":3.8985429466630098E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(G66-'Lookup Tables'!U80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(G66-'Lookup Tables'!U80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":4.3154947661584009E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(H66-'Lookup Tables'!V80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(H66-'Lookup Tables'!V80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":7.341509572018956E-3},{"$f":"IF('Lookup Tables'!$D$76=2,(I66-'Lookup Tables'!W80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(I66-'Lookup Tables'!W80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-4.0365791619087654E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(J66-'Lookup Tables'!X80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(J66-'Lookup Tables'!X80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-6.6947935352408575E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(K66-'Lookup Tables'!Y80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(K66-'Lookup Tables'!Y80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-6.1819576568387991E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(L66-'Lookup Tables'!Z80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(L66-'Lookup Tables'!Z80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-3.4812472050878042E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(M66-'Lookup Tables'!AA80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(M66-'Lookup Tables'!AA80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":1.1608910898802519E-2},{"$f":"IF('Lookup Tables'!$D$76=2,(N66-'Lookup Tables'!AB80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(N66-'Lookup Tables'!AB80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-5.6292069492167749E-3},{"$f":"IF('Lookup Tables'!$D$76=2,(O66-'Lookup Tables'!AC80)/('Model Parameters'!$D$13*'Model Parameters'!$D$14),IF('Lookup Tables'!$D$76=1,(O66-'Lookup Tables'!AC80)/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":-4.2653472871727657E-3}]

{"sheet":"Definitions","index":6,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[13,11,13,19],[12,11,12,19],[22,11,22,19],[20,11,20,19],[19,11,19,19],[18,11,18,19],[17,11,17,19],[16,11,16,19],[15,11,15,19],[14,11,14,19],[23,11,23,19],[21,11,21,19],[31,11,31,19],[30,11,30,19],[29,11,29,19],[28,11,28,19],[27,11,27,19],[25,11,25,19],[24,11,24,19],[26,11,26,19],[4,1,4,9],[5,1,5,9],[7,1,7,9],[6,1,6,9],[8,1,8,9],[44,1,44,9],[11,1,11,9],[10,1,10,9],[29,1,29,9],[28,1,28,9],[27,1,27,9],[26,1,26,9],[25,1,25,9],[24,1,24,9],[23,1,23,9],[18,1,18,9],[17,1,17,9],[16,1,16,9],[15,1,15,9],[14,1,14,9],[13,1,13,9],[50,1,50,9],[48,1,48,9],[47,1,47,9],[34,1,34,9],[37,1,37,9],[38,1,38,9],[49,1,49,9],[46,1,46,9],[43,1,43,9],[42,1,42,9],[41,1,41,9],[40,1,40,9],[39,1,39,9],[36,1,36,9],[35,1,35,9],[45,1,45,9],[33,1,33,9],[4,11,4,19],[11,11,11,19],[10,11,10,19],[9,11,9,19],[8,11,8,19],[7,11,7,19],[6,11,6,19],[5,11,5,19],[30,1,30,9],[22,1,22,9],[21,1,21,9],[20,1,20,9],[31,1,31,9],[32,1,32,9],[12,1,12,9],[57,1,57,9],[56,1,56,9],[55,1,55,9],[54,1,54,9],[51,1,51,9],[53,1,53,9],[52,1,52,9]]}
[null,{"$f":"Main!$B$11","v":"Similkameen Valley Aquifer"}]
[null,{"$f":"CONCATENATE(\"Aquifer #\", Main!$B$12)","v":"Aquifer #259"}]
[]
[]
[null,"MODEL SCENARIO",null,null,null,null,null,null,null,null,null,"WATER BALANCE OUTPUTS"]
[null,"Normal: Represents 'average' conditions based on average data for the latest climate normal period (i.e., 1981-2010)."]
[null,"Dry: Represents 'dry' conditions based on data from 2001.",null,null,null,null,null,null,null,null,null,"Evaporation Direct from Similkameen River"]
[null,"Wet: Represents 'wet' conditions based on data from 1991.",null,null,null,null,null,null,null,null,null,"Annual Total Evaporation: Total annual evaporation for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on Evaporation data entered on 'Input Data' tab. Included here for user reference only. Evaporation data included in the water budget is taken from the gridded climate dataset used within the AWDM (van der Gulik et al. 2013). "]
[null,"Other: Represents user-defined conditions based on data entered into 'Other' categories on 'Input Data' tab."]
[null,null,null,null,null,null,null,null,null,null,null,"Surface Water"]
[null,"SYSTEM CHARACTERISTICS",null,null,null,null,null,null,null,null,null,"Mean Annual Similkameen River Outflow: Estimated mean annual discharge for the Similkameen River at the downstream boundary of the Similkameen Valley Aquifer for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on Similkameen River Outflow data entered on the 'Input Data' tab. Included here for reference only. Similkameen River Outflow estimates included in the water budget (enetered on the 'Input Data' tab) is based on streamflow records from WSC Station 08NL022 (Similkameen River near Nighthawk)  for each climate scenario scaled to the U.S. border (using a drainage area of 8,117 km2)."]
[]
[null,"Aquifer Characteristics",null,null,null,null,null,null,null,null,null,"Groundwater Outflow"]
[null,"Aquifer Length: Length of the Similkameen Aquifer based on information taken from BC Water Resources Atlas (http://maps.gov.bc.ca/ess/sv/wrbc/).",null,null,null,null,null,null,null,null,null,"Outflow at Downstream Aquifer Boundary: Groundwater outflow calculated at the downstream boundary of the Similkameen Valley Aquifer using Darcy's Law. Below parameters are used within the Darcy's Law equation."]
[null,"Aquifer Area: Total surface area of the Similkameen Valley Aquifer (including the Similkameen River) based on information taken from BC Water Resources Atlas (http://maps.gov.bc.ca/ess/sv/wrbc/).",null,null,null,null,null,null,null,null,null,"Aquifer Width: Aquifer width at the downstream boundary of the Similkameen Valley Aquifer based on information taken from BC Water Resources Atlas (http://maps.gov.bc.ca/ess/sv/wrbc/)."]
[null,"Specific Yield: Level of saturation in an unconfined unit with changes in the amount of storage. Suggested range for Similkameen Valley Aquifer is between 0.15 and 0.26 (Fetter 1994 and Freeze et. al. 1979).",null,null,null,null,null,null,null,null,null,"Aquifer Depth: Aquifer depth at the downstream boundary of the Similkameen Valley Aquifer."]
[null,null,null,null,null,null,null,null,null,null,null,"Hydraulic Conductivity (K): Represents the permeability of the Similkameen Valley Aquifer at the downstream boundary. Suggested range for Similkameen Valley Aquifer is between 8 and 864 m/d (Freeze et. al. 1979)."]
[null,"Similkameen River Characteristics",null,null,null,null,null,null,null,null,null,"Hydraulic Gradient (i): Represents the difference between two groundwater levels over a known distance. Herein, i is estimated using groundwater levels recorded at Princeton and Keremeos. Suggested range is 0.001 to 0.1."]
[null,"Similkameen River Surface Area: Total surface area of the Similkameen River within the Similkameen Valley Aquifer boundary."]
[null,null,null,null,null,null,null,null,null,null,null,"Water Demand"]
[null,"WATER BALANCE INPUTS",null,null,null,null,null,null,null,null,null,"Select Water Demand Scenario"]
[null,null,null,null,null,null,null,null,null,null,null,"→ Estimated Actual Demand: Water balance calculations include only 'Estimated Existing Water Demand' for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other') for both surface water and groundwater based on data entered on the 'Input Data' tab. Water demand data included in the water budget is taken from the AWDM (van der Gulik at al. 2013)."]
[null,"Precipitation",null,null,null,null,null,null,null,null,null,"→ Total Licensed Demand: Water balance calculations include only 'Total Existing Licensed Water Demand' for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other') values based on data entered on the 'Input Data' tab. Total licensed demand data included in the water budget was estimated from existing water licenses within the Similkameen River."]
[null,"Annual Total Precipitation: Total annual precipitation for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on Precipitation data entered on 'Input Data' tab. Included here for user reference only. Precipitation data included in the water budget (entered on the 'Input Data' tab) is taken from precipitation records at Princeton A Cilmate Station (Station ID: 1126510) for the period 1981-2010 (Normal), 2001 (Dry), 1991 (Wet).",null,null,null,null,null,null,null,null,null,"Estimated Existing Surface Water Demand"]
[null,null,null,null,null,null,null,null,null,null,null,"Mean Annual Surface Water Demand: Estimated mean annual surface water demand within the Similkameen Valley Aquifer boundary for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on 'Existing Surface Water Demand' data entered on the 'Input Data' tab. Included here for user reference only."]
[null,"Surface Water",null,null,null,null,null,null,null,null,null,"Mean Seasonal Surface Water Demand: Estimated mean seasonal surface water demand within the Similkameen Valley Aquifer boundary for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on 'Existing Surface Water Demand' data entered on the 'Input Data' tab. Included here for user reference only."]
[null,"Mean Annual Similkameen River Inflow: Estimated mean annual discharge for the Similkameen River at the upstream boundary of the Similakmeen Valley Aquifer for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on Similkameen River Inflow data entered on the 'Input Data' tab. Included here for user reference only. Similkameen River Inflow is the sum of streamflows recorded at the WSC hydrometric stations Similkameen River at Princeton (WSC Station 08NL007) and Tulameen River at Princeton (WSC Station 08NL024) for each of the climate scenarios.",null,null,null,null,null,null,null,null,null,"Estimated Existing Groundwater Demand"]
[null,"Mean Annual Tributary Inflow: Estimated mean annual discharge for all tributary flow into the Similkameen River within the Similkameen Valley Aquifer boundary for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on Tributary Inflow data entered on the 'Input Data' tab. Included here for user reference only. A summary of Tributary Inflow estimates is provided in the accompanying report.",null,null,null,null,null,null,null,null,null,"Mean Annual Groundwater Demand: Estimated mean annual groundwater demand within the Similkameen Valley Aquifer boundary for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on 'Existing Groundwater Demand' data entered on the 'Input Data' tab. Included here for user reference only."]
[null,null,null,null,null,null,null,null,null,null,null,"Mean Seasonal Groundwater Demand: Estimated mean seasonal Groundwater demand within the Similkameen Valley Aquifer boundary for the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other'). Value is calculated based on 'Existing Groundwater Demand' data entered on the 'Input Data' tab. Included here for user reference only."]
[null,"Aquifer Recharge",null,null,null,null,null,null,null,null,null,"Total Existing Licensed Water Demand"]
[null,"Select Aquifer Recharge Option:",null,null,null,null,null,null,null,null,null,"Mean Annual Licensed Water Demand: Mean annual total licensed water demand within the Similkameen Valley Aquifer. Total licensed water demand values do not consider the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other') since water licences are not conditional on climate conditions."]
[null,"→ Fixed Percentage: Total annual precipitation is distributed evenly across all 12 months, and the select 'Percentage of Precipitation Recharging Aquifer' is then applied to each monthly value. Accordingly, 'Aquifer Recharge' is assumed constant throughout the year.",null,null,null,null,null,null,null,null,null,"Mean Seasonal Licensed Water Demand: Mean seasonal total licensed water demand within the Similkameen Valley Aquifer. Total licensed water demand values do not consider the current scenario (i.e., 'Normal', 'Dry', 'Wet', or 'Other') since water licences are not conditional on climate conditions."]
[null,"→ Monthly Distribution: Total annual precipitation is distributed monthly based on monthly distribution defined on the 'Input Data' tab. The select 'Percentage of Precipitation Recharging Aquifer' is then applied to each monthly value. Accordingly, 'Aquifer Recharge' varies throughout the year."]
[null,"Percentage of Precipitation Recharging Aquifer: The percentage of precipitation that recharges the aquifer. Recharge only occurs across the 'residual' aquifer area (i.e., Total aquifer area - Similkameen River Surface Area). The suggested range is 10 to 20 % for the sand and gravel aquifer (Golder 2005)."]
[]
[null,"Water Demand"]
[null,"Select Irrigation Return Option:"]
[null,"→ Fixed Percentage: A fixed percentage of total monthly 'Seasonal' water demand (i.e., Seasonal water demand from both surface water and groundwater sources)"]
[null,"→ Monthly Distribution: A percentage of total monthly 'Seasonal' water demand (i.e., Seasonal water demand from both surface water and groundwater sources), based on the monthly distribution defined by the user on the 'Input Data' tab."]
[null,"Irrigation Return to Aquifer: If 'Fixed Percentage' is selected, define the percentage of total monthly 'Seasonal' water demand (i.e., Seasonal water demand from both surface water and groundwater sources) to return to the aquifer as 'Irrigation Return'."]
[]
[null,"Groundwater Inflow"]
[null,"Inflow at Upstream Aquifer Boundary: Groundwater inflow calculated at the upstream boundary of the Similkameen Valley Aquifer using Darcy's Law. Below parameters are used within the Darcy's Law equation."]
[null,"Aquifer Width: Aquifer width at the upstream boundary of the Similkameen Valley Aquifer based on information taken from BC Water Resources Atlas (http://maps.gov.bc.ca/ess/sv/wrbc/)."]
[null,"Aquifer Depth: Aquifer depth at the upstream boundary of the Similkameen Valley Aquifer based on information taken from BC Water Resources Atlas (http://maps.gov.bc.ca/ess/sv/wrbc/)."]
[null,"Hydraulic Conductivity (K): Represents the permeability of the Similkameen Valley Aquifer at the upstream boundary. Suggested range for Similkameen Valley Aquifer is between 8 and 864 m/d (Freeze et. al. 1979)."]
[null,"Hydraulic Gradient (i): Represents the difference between two groundwater levels over a known distance. Herein, i is estimated using groundwater levels recorded at Princeton and Keremeos. Suggested range is 0.001 to 0.1."]
[]
[null,"Mountain Block Recharge"]
[null,"Mountain Block Recharge (MBR) is the collective name for the fractured aquifer on both sides and below the unconsolidated aquifer which interacts with groundwater flow into the Similkameen Valley Aquifer."]
[null,"Select MBR Method"]
[null,"→ Darcy Equation: MBR is calculated using Darcy's Law Equation, similar to Groundwater Inflow/Outflow. However, K is typically much lower for MBR estimates with a suggested value for the Similkameen Valley Aquifer of 0.0086 m/d (Voeckler 2012)."]
[null,"→ Neilson-Welch: MBR is calculated using the Nielson-Welch and Allen (2007) method. This method uses a 'Neilson-Welch Flux Rate' with a typical range between 30 and 50 mm/year."]
[null,"Aquifer Length: Aquifer length based on information taken from BC Water Resources Atlas (http://maps.gov.bc.ca/ess/sv/wrbc/)."]
[null,"Aquifer Depth: Mean aquifer depth along the length of the Similkameen Valley Aquifer."]
[null,"Neilson-Welch Flux Rate (30-50 mm/y): This term is only used if 'Neilson-Welch' is selected for the MBR method. This term replaces K within the Neilson-Welch and Allen MBR estimation method. Suggested range for Similkameen Valley Aquifer is between 30 and 50 mm/year (Nielson-Welch and Allen 2007)."]
[null,"Hydraulic Conductivity (K): This term is only used if 'Darcy Equation' is selected for the MBR method. K represents the permeability of the Similkameen Valley Aquifer at the boundary with fractured aquifer on both sides and below the Similkameen Valley Aquifer. Suggested value for the Similkameen Valley Aquifer is 0.0086 m/d (Voeckler 2012)."]
[null,"Hydraulic Gradient (i): Represents the difference between two groundwater levels over a known distance. Due to the steep nature of the Similkameen Valley, the estimated suggested range for the Similkameen Valley Aquifer is between 0.001 and 0.1."]

{"sheet":"Lookup Tables","index":7,"n_rows":100,"n_cols":32,"rows_kept":100,"cut":false,"hidden":false,"merged":[[85,2,86,2],[72,1,72,14],[4,1,4,14],[48,1,48,14],[7,16,7,29],[82,1,82,15]]}
[]
[null,"Number of Days in Month","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL",null,"Water Demand - Monthly Distribution","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Result to use for model run",31,28,31,30,31,30,31,31,30,31,30,31,{"$f":"SUM(C3:N3)","v":365},null,"ANNUAL",5.6000000000000001E-2,4.8000000000000001E-2,5.2999999999999999E-2,6.7000000000000004E-2,0.105,0.11,0.16300000000000001,0.14899999999999999,9.1999999999999998E-2,6.0999999999999999E-2,4.5999999999999999E-2,0.05,{"$f":"SUM(R3:AC3)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEASONAL",0,0,0,0.01,0.08,0.21,0.28999999999999998,0.26,0.15,0,0,0,{"$f":"SUM(R4:AC4)","v":1}]
[null,"WATER BALANCE INPUTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Demand",{"$f":"'Model Output'!D32/100","v":0},{"$f":"'Model Output'!E32/100","v":0},{"$f":"'Model Output'!F32/100","v":0},{"$f":"'Model Output'!G32/100","v":0},{"$f":"'Model Output'!H32/100","v":0},{"$f":"'Model Output'!I32/100","v":0},{"$f":"'Model Output'!J32/100","v":0},{"$f":"'Model Output'!K32/100","v":0},{"$f":"'Model Output'!L32/100","v":0},{"$f":"'Model Output'!M32/100","v":0},{"$f":"'Model Output'!N32/100","v":0},{"$f":"'Model Output'!O32/100","v":0},{"$f":"SUM(R6:AC6)","v":0}]
[null,"Precipitation Data (mm/month)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"NORMAL",{"$f":"'Input Data'!D8","v":39.700000000000003},{"$f":"'Input Data'!E8","v":20.5},{"$f":"'Input Data'!F8","v":16.5},{"$f":"'Input Data'!G8","v":18.399999999999999},{"$f":"'Input Data'!H8","v":29.6},{"$f":"'Input Data'!I8","v":37.6},{"$f":"'Input Data'!J8","v":29.6},{"$f":"'Input Data'!K8","v":24.3},{"$f":"'Input Data'!L8","v":23.8},{"$f":"'Input Data'!M8","v":26.1},{"$f":"'Input Data'!N8","v":44.5},{"$f":"'Input Data'!O8","v":36.4},{"$f":"'Input Data'!P8","v":347},null,"WATER BALANCE OUTPUTS"]
[null,"DRY",{"$f":"'Input Data'!D9","v":19.600000000000001},{"$f":"'Input Data'!E9","v":21.3},{"$f":"'Input Data'!F9","v":16.2},{"$f":"'Input Data'!G9","v":11.9},{"$f":"'Input Data'!H9","v":7.4},{"$f":"'Input Data'!I9","v":21.3},{"$f":"'Input Data'!J9","v":14.3},{"$f":"'Input Data'!K9","v":2.2000000000000002},{"$f":"'Input Data'!L9","v":6.8},{"$f":"'Input Data'!M9","v":15.9},{"$f":"'Input Data'!N9","v":26.4},{"$f":"'Input Data'!O9","v":26.3},{"$f":"'Input Data'!P9","v":189.60000000000002}]
[null,"WET",{"$f":"'Input Data'!D10","v":35.9},{"$f":"'Input Data'!E10","v":23.3},{"$f":"'Input Data'!F10","v":20.399999999999999},{"$f":"'Input Data'!G10","v":40.200000000000003},{"$f":"'Input Data'!H10","v":54.2},{"$f":"'Input Data'!I10","v":62.2},{"$f":"'Input Data'!J10","v":24},{"$f":"'Input Data'!K10","v":42.6},{"$f":"'Input Data'!L10","v":5.2},{"$f":"'Input Data'!M10","v":19},{"$f":"'Input Data'!N10","v":37.4},{"$f":"'Input Data'!O10","v":30.4},{"$f":"'Input Data'!P10","v":394.79999999999995},null,"Evaporation Data (mm/month)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"OTHER",{"$f":"'Input Data'!D11","v":0},{"$f":"'Input Data'!E11","v":0},{"$f":"'Input Data'!F11","v":0},{"$f":"'Input Data'!G11","v":0},{"$f":"'Input Data'!H11","v":0},{"$f":"'Input Data'!I11","v":0},{"$f":"'Input Data'!J11","v":0},{"$f":"'Input Data'!K11","v":0},{"$f":"'Input Data'!L11","v":0},{"$f":"'Input Data'!M11","v":0},{"$f":"'Input Data'!N11","v":0},{"$f":"'Input Data'!O11","v":0},{"$f":"'Input Data'!P11","v":0},null,"NORMAL",{"$f":"'Input Data'!T8","v":18.3},{"$f":"'Input Data'!U8","v":27.4},{"$f":"'Input Data'!V8","v":57.6},{"$f":"'Input Data'!W8","v":89},{"$f":"'Input Data'!X8","v":127.7},{"$f":"'Input Data'!Y8","v":143.80000000000001},{"$f":"'Input Data'!Z8","v":165.4},{"$f":"'Input Data'!AA8","v":147.6},{"$f":"'Input Data'!AB8","v":98.1},{"$f":"'Input Data'!AC8","v":52.9},{"$f":"'Input Data'!AD8","v":23.7},{"$f":"'Input Data'!AE8","v":15.9},{"$f":"'Input Data'!AF8","v":967.40000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DRY",{"$f":"'Input Data'!T9","v":18.399999999999999},{"$f":"'Input Data'!U9","v":25.3},{"$f":"'Input Data'!V9","v":57.9},{"$f":"'Input Data'!W9","v":84.6},{"$f":"'Input Data'!X9","v":135.19999999999999},{"$f":"'Input Data'!Y9","v":134.80000000000001},{"$f":"'Input Data'!Z9","v":161.69999999999999},{"$f":"'Input Data'!AA9","v":155.30000000000001},{"$f":"'Input Data'!AB9","v":104.7},{"$f":"'Input Data'!AC9","v":49.3},{"$f":"'Input Data'!AD9","v":27.2},{"$f":"'Input Data'!AE9","v":16.8},{"$f":"'Input Data'!AF9","v":971.2}]
[null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!C$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!C$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!C$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!C$11,\"Select Scenario\"))))","v":39.700000000000003},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!D$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!D$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!D$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!D$11,\"Select Scenario\"))))","v":20.5},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!E$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!E$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!E$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!E$11,\"Select Scenario\"))))","v":16.5},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!F$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!F$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!F$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!F$11,\"Select Scenario\"))))","v":18.399999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!G$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!G$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!G$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!G$11,\"Select Scenario\"))))","v":29.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!H$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!H$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!H$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!H$11,\"Select Scenario\"))))","v":37.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!I$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!I$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!I$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!I$11,\"Select Scenario\"))))","v":29.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!J$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!J$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!J$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!J$11,\"Select Scenario\"))))","v":24.3},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!K$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!K$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!K$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!K$11,\"Select Scenario\"))))","v":23.8},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!L$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!L$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!L$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!L$11,\"Select Scenario\"))))","v":26.1},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!M$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!M$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!M$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!M$11,\"Select Scenario\"))))","v":44.5},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!N$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!N$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!N$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!N$11,\"Select Scenario\"))))","v":36.4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!O$8,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!O$9,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!O$10,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!O$11,\"Select Scenario\"))))","v":347},null,"WET",{"$f":"'Input Data'!T10","v":16.2},{"$f":"'Input Data'!U10","v":28.9},{"$f":"'Input Data'!V10","v":52.8},{"$f":"'Input Data'!W10","v":87.3},{"$f":"'Input Data'!X10","v":116.7},{"$f":"'Input Data'!Y10","v":131},{"$f":"'Input Data'!Z10","v":166.3},{"$f":"'Input Data'!AA10","v":140.30000000000001},{"$f":"'Input Data'!AB10","v":109},{"$f":"'Input Data'!AC10","v":57.6},{"$f":"'Input Data'!AD10","v":23.9},{"$f":"'Input Data'!AE10","v":18},{"$f":"'Input Data'!AF10","v":948}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",{"$f":"'Input Data'!T11","v":0},{"$f":"'Input Data'!U11","v":0},{"$f":"'Input Data'!V11","v":0},{"$f":"'Input Data'!W11","v":0},{"$f":"'Input Data'!X11","v":0},{"$f":"'Input Data'!Y11","v":0},{"$f":"'Input Data'!Z11","v":0},{"$f":"'Input Data'!AA11","v":0},{"$f":"'Input Data'!AB11","v":0},{"$f":"'Input Data'!AC11","v":0},{"$f":"'Input Data'!AD11","v":0},{"$f":"'Input Data'!AE11","v":0},{"$f":"'Input Data'!AF11","v":0}]
[null,"Surface Water Inflow Data (m3/s)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!R$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!R$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!R$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!R$14,\"Select Scenario\"))))","v":18.3},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!S$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!S$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!S$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!S$14,\"Select Scenario\"))))","v":27.4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!T$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!T$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!T$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!T$14,\"Select Scenario\"))))","v":57.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!U$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!U$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!U$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!U$14,\"Select Scenario\"))))","v":89},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!V$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!V$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!V$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!V$14,\"Select Scenario\"))))","v":127.7},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!W$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!W$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!W$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!W$14,\"Select Scenario\"))))","v":143.80000000000001},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!X$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!X$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!X$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!X$14,\"Select Scenario\"))))","v":165.4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Y$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Y$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Y$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Y$14,\"Select Scenario\"))))","v":147.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Z$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Z$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Z$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Z$14,\"Select Scenario\"))))","v":98.1},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AA$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AA$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AA$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AA$14,\"Select Scenario\"))))","v":52.9},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AB$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AB$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AB$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AB$14,\"Select Scenario\"))))","v":23.7},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AC$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AC$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AC$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AC$14,\"Select Scenario\"))))","v":15.9},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AD$11,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AD$12,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AD$13,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AD$14,\"Select Scenario\"))))","v":967.40000000000009}]
[null,"MAINSTEM INFLOW"]
[null,"NORMAL",{"$f":"'Input Data'!D16","v":15},{"$f":"'Input Data'!E16","v":12.3},{"$f":"'Input Data'!F16","v":18.399999999999999},{"$f":"'Input Data'!G16","v":55.1},{"$f":"'Input Data'!H16","v":155},{"$f":"'Input Data'!I16","v":138},{"$f":"'Input Data'!J16","v":42.6},{"$f":"'Input Data'!K16","v":11.4},{"$f":"'Input Data'!L16","v":7.61},{"$f":"'Input Data'!M16","v":11.7},{"$f":"'Input Data'!N16","v":24.7},{"$f":"'Input Data'!O16","v":14.6},{"$f":"'Input Data'!P16","v":42.200833333333335},null,"Surface Water Outflow Data (m3/s)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,"DRY",{"$f":"'Input Data'!D17","v":6.54},{"$f":"'Input Data'!E17","v":5.07},{"$f":"'Input Data'!F17","v":6.18},{"$f":"'Input Data'!G17","v":21.7},{"$f":"'Input Data'!H17","v":102},{"$f":"'Input Data'!I17","v":54.4},{"$f":"'Input Data'!J17","v":12.6},{"$f":"'Input Data'!K17","v":4.74},{"$f":"'Input Data'!L17","v":3.35},{"$f":"'Input Data'!M17","v":5.21},{"$f":"'Input Data'!N17","v":13},{"$f":"'Input Data'!O17","v":7.71},{"$f":"'Input Data'!P17","v":20.208333333333336},null,"NORMAL",{"$f":"'Input Data'!T14","v":19.100000000000001},{"$f":"'Input Data'!U14","v":17.7},{"$f":"'Input Data'!V14","v":22.9},{"$f":"'Input Data'!W14","v":58.6},{"$f":"'Input Data'!X14","v":183},{"$f":"'Input Data'!Y14","v":186},{"$f":"'Input Data'!Z14","v":67.7},{"$f":"'Input Data'!AA14","v":21.6},{"$f":"'Input Data'!AB14","v":13.4},{"$f":"'Input Data'!AC14","v":16},{"$f":"'Input Data'!AD14","v":27.6},{"$f":"'Input Data'!AE14","v":20.100000000000001},{"$f":"'Input Data'!AF14","v":54.475000000000001}]
[null,"WET",{"$f":"'Input Data'!D18","v":20.100000000000001},{"$f":"'Input Data'!E18","v":39.4},{"$f":"'Input Data'!F18","v":29.9},{"$f":"'Input Data'!G18","v":82.7},{"$f":"'Input Data'!H18","v":243},{"$f":"'Input Data'!I18","v":260},{"$f":"'Input Data'!J18","v":139},{"$f":"'Input Data'!K18","v":30.4},{"$f":"'Input Data'!L18","v":11.5},{"$f":"'Input Data'!M18","v":6.6},{"$f":"'Input Data'!N18","v":13.1},{"$f":"'Input Data'!O18","v":11},{"$f":"'Input Data'!P18","v":73.891666666666666},null,"DRY",{"$f":"'Input Data'!T15","v":9.39},{"$f":"'Input Data'!U15","v":8.2200000000000006},{"$f":"'Input Data'!V15","v":9.3800000000000008},{"$f":"'Input Data'!W15","v":21.3},{"$f":"'Input Data'!X15","v":109},{"$f":"'Input Data'!Y15","v":78.8},{"$f":"'Input Data'!Z15","v":25.1},{"$f":"'Input Data'!AA15","v":9.36},{"$f":"'Input Data'!AB15","v":5.39},{"$f":"'Input Data'!AC15","v":7.19},{"$f":"'Input Data'!AD15","v":15.2},{"$f":"'Input Data'!AE15","v":10.1},{"$f":"'Input Data'!AF15","v":25.702500000000004}]
[null,"OTHER",{"$f":"'Input Data'!D19","v":0},{"$f":"'Input Data'!E19","v":0},{"$f":"'Input Data'!F19","v":0},{"$f":"'Input Data'!G19","v":0},{"$f":"'Input Data'!H19","v":0},{"$f":"'Input Data'!I19","v":0},{"$f":"'Input Data'!J19","v":0},{"$f":"'Input Data'!K19","v":0},{"$f":"'Input Data'!L19","v":0},{"$f":"'Input Data'!M19","v":0},{"$f":"'Input Data'!N19","v":0},{"$f":"'Input Data'!O19","v":0},{"$f":"'Input Data'!P19","v":{"$error":"#DIV/0!"}},null,"WET",{"$f":"'Input Data'!T16","v":30.3},{"$f":"'Input Data'!U16","v":47.7},{"$f":"'Input Data'!V16","v":40.200000000000003},{"$f":"'Input Data'!W16","v":94.5},{"$f":"'Input Data'!X16","v":319},{"$f":"'Input Data'!Y16","v":342},{"$f":"'Input Data'!Z16","v":194},{"$f":"'Input Data'!AA16","v":47.9},{"$f":"'Input Data'!AB16","v":20.100000000000001},{"$f":"'Input Data'!AC16","v":12.8},{"$f":"'Input Data'!AD16","v":19.2},{"$f":"'Input Data'!AE16","v":15.5},{"$f":"'Input Data'!AF16","v":98.600000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",{"$f":"'Input Data'!T17","v":0},{"$f":"'Input Data'!U17","v":0},{"$f":"'Input Data'!V17","v":0},{"$f":"'Input Data'!W17","v":0},{"$f":"'Input Data'!X17","v":0},{"$f":"'Input Data'!Y17","v":0},{"$f":"'Input Data'!Z17","v":0},{"$f":"'Input Data'!AA17","v":0},{"$f":"'Input Data'!AB17","v":0},{"$f":"'Input Data'!AC17","v":0},{"$f":"'Input Data'!AD17","v":0},{"$f":"'Input Data'!AE17","v":0},{"$f":"'Input Data'!AF17","v":{"$error":"#DIV/0!"}}]
[null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!C$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!C$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!C$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!C$21,\"Select Scenario\"))))","v":15},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!D$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!D$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!D$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!D$21,\"Select Scenario\"))))","v":12.3},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!E$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!E$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!E$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!E$21,\"Select Scenario\"))))","v":18.399999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!F$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!F$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!F$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!F$21,\"Select Scenario\"))))","v":55.1},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!G$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!G$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!G$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!G$21,\"Select Scenario\"))))","v":155},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!H$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!H$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!H$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!H$21,\"Select Scenario\"))))","v":138},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!I$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!I$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!I$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!I$21,\"Select Scenario\"))))","v":42.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!J$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!J$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!J$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!J$21,\"Select Scenario\"))))","v":11.4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!K$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!K$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!K$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!K$21,\"Select Scenario\"))))","v":7.61},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!L$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!L$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!L$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!L$21,\"Select Scenario\"))))","v":11.7},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!M$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!M$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!M$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!M$21,\"Select Scenario\"))))","v":24.7},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!N$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!N$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!N$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!N$21,\"Select Scenario\"))))","v":14.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!O$18,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!O$19,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!O$20,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!O$21,\"Select Scenario\"))))","v":42.200833333333335}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!R$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!R$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!R$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!R$22,\"Select Scenario\"))))","v":19.100000000000001},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!S$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!S$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!S$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!S$22,\"Select Scenario\"))))","v":17.7},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!T$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!T$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!T$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!T$22,\"Select Scenario\"))))","v":22.9},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!U$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!U$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!U$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!U$22,\"Select Scenario\"))))","v":58.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!V$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!V$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!V$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!V$22,\"Select Scenario\"))))","v":183},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!W$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!W$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!W$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!W$22,\"Select Scenario\"))))","v":186},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!X$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!X$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!X$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!X$22,\"Select Scenario\"))))","v":67.7},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Y$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Y$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Y$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Y$22,\"Select Scenario\"))))","v":21.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Z$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Z$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Z$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Z$22,\"Select Scenario\"))))","v":13.4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AA$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AA$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AA$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AA$22,\"Select Scenario\"))))","v":16},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AB$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AB$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AB$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AB$22,\"Select Scenario\"))))","v":27.6},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AC$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AC$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AC$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AC$22,\"Select Scenario\"))))","v":20.100000000000001},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AD$19,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AD$20,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AD$21,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AD$22,\"Select Scenario\"))))","v":54.475000000000001}]
[null,"TRIBUTARY INFLOW"]
[null,"NORMAL",{"$f":"'Input Data'!D22","v":2.774},{"$f":"'Input Data'!E22","v":2.5190000000000001},{"$f":"'Input Data'!F22","v":3.34},{"$f":"'Input Data'!G22","v":11.8},{"$f":"'Input Data'!H22","v":48.16},{"$f":"'Input Data'!I22","v":44.99},{"$f":"'Input Data'!J22","v":16.489999999999998},{"$f":"'Input Data'!K22","v":5.8650000000000002},{"$f":"'Input Data'!L22","v":3.802},{"$f":"'Input Data'!M22","v":3.5670000000000002},{"$f":"'Input Data'!N22","v":4.4370000000000003},{"$f":"'Input Data'!O22","v":3.202},{"$f":"'Input Data'!P22","v":12.578833333333336},null,"Existing Surface Water Demand Data (m3/s)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,"DRY",{"$f":"'Input Data'!D23","v":1.8},{"$f":"'Input Data'!E23","v":1.6},{"$f":"'Input Data'!F23","v":1.83},{"$f":"'Input Data'!G23","v":5.17},{"$f":"'Input Data'!H23","v":26.53},{"$f":"'Input Data'!I23","v":17.57},{"$f":"'Input Data'!J23","v":7.14},{"$f":"'Input Data'!K23","v":3.09},{"$f":"'Input Data'!L23","v":1.58},{"$f":"'Input Data'!M23","v":1.75},{"$f":"'Input Data'!N23","v":2.78},{"$f":"'Input Data'!O23","v":2.4700000000000002},{"$f":"'Input Data'!P23","v":6.1091666666666669}]
[null,"WET",{"$f":"'Input Data'!D24","v":4.2389999999999999},{"$f":"'Input Data'!E24","v":5.8789999999999996},{"$f":"'Input Data'!F24","v":5.1260000000000003},{"$f":"'Input Data'!G24","v":16.47},{"$f":"'Input Data'!H24","v":89.46},{"$f":"'Input Data'!I24","v":99.4},{"$f":"'Input Data'!J24","v":41.96},{"$f":"'Input Data'!K24","v":11.43},{"$f":"'Input Data'!L24","v":5.0199999999999996},{"$f":"'Input Data'!M24","v":2.9889999999999999},{"$f":"'Input Data'!N24","v":3.3159999999999998},{"$f":"'Input Data'!O24","v":2.734},{"$f":"'Input Data'!P24","v":24.001916666666659},null,"ANNUAL WATER DEMAND"]
[null,"OTHER",{"$f":"'Input Data'!D25","v":0},{"$f":"'Input Data'!E25","v":0},{"$f":"'Input Data'!F25","v":0},{"$f":"'Input Data'!G25","v":0},{"$f":"'Input Data'!H25","v":0},{"$f":"'Input Data'!I25","v":0},{"$f":"'Input Data'!J25","v":0},{"$f":"'Input Data'!K25","v":0},{"$f":"'Input Data'!L25","v":0},{"$f":"'Input Data'!M25","v":0},{"$f":"'Input Data'!N25","v":0},{"$f":"'Input Data'!O25","v":0},{"$f":"'Input Data'!P25","v":{"$error":"#DIV/0!"}},null,"NORMAL",{"$f":"'Input Data'!T22","v":2.9000000000000001E-2},{"$f":"'Input Data'!U22","v":2.9000000000000001E-2},{"$f":"'Input Data'!V22","v":2.9000000000000001E-2},{"$f":"'Input Data'!W22","v":2.9000000000000001E-2},{"$f":"'Input Data'!X22","v":0.03},{"$f":"'Input Data'!Y22","v":0.03},{"$f":"'Input Data'!Z22","v":0.03},{"$f":"'Input Data'!AA22","v":0.03},{"$f":"'Input Data'!AB22","v":0.03},{"$f":"'Input Data'!AC22","v":2.9000000000000001E-2},{"$f":"'Input Data'!AD22","v":2.9000000000000001E-2},{"$f":"'Input Data'!AE22","v":2.9000000000000001E-2},{"$f":"'Input Data'!AF22","v":2.9416666666666674E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DRY",{"$f":"'Input Data'!T23","v":2.9000000000000001E-2},{"$f":"'Input Data'!U23","v":2.9000000000000001E-2},{"$f":"'Input Data'!V23","v":2.9000000000000001E-2},{"$f":"'Input Data'!W23","v":2.9000000000000001E-2},{"$f":"'Input Data'!X23","v":0.03},{"$f":"'Input Data'!Y23","v":0.03},{"$f":"'Input Data'!Z23","v":0.03},{"$f":"'Input Data'!AA23","v":0.03},{"$f":"'Input Data'!AB23","v":0.03},{"$f":"'Input Data'!AC23","v":2.9000000000000001E-2},{"$f":"'Input Data'!AD23","v":2.9000000000000001E-2},{"$f":"'Input Data'!AE23","v":2.9000000000000001E-2},{"$f":"'Input Data'!AF23","v":2.9416666666666674E-2}]
[null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!C$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!C$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!C$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!C$29,\"Select Scenario\"))))","v":2.774},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!D$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!D$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!D$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!D$29,\"Select Scenario\"))))","v":2.5190000000000001},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!E$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!E$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!E$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!E$29,\"Select Scenario\"))))","v":3.34},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!F$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!F$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!F$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!F$29,\"Select Scenario\"))))","v":11.8},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!G$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!G$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!G$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!G$29,\"Select Scenario\"))))","v":48.16},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!H$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!H$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!H$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!H$29,\"Select Scenario\"))))","v":44.99},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!I$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!I$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!I$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!I$29,\"Select Scenario\"))))","v":16.489999999999998},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!J$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!J$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!J$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!J$29,\"Select Scenario\"))))","v":5.8650000000000002},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!K$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!K$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!K$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!K$29,\"Select Scenario\"))))","v":3.802},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!L$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!L$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!L$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!L$29,\"Select Scenario\"))))","v":3.5670000000000002},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!M$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!M$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!M$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!M$29,\"Select Scenario\"))))","v":4.4370000000000003},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!N$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!N$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!N$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!N$29,\"Select Scenario\"))))","v":3.202},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!O$26,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!O$27,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!O$28,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!O$29,\"Select Scenario\"))))","v":12.578833333333336},null,"WET",{"$f":"'Input Data'!T24","v":2.9000000000000001E-2},{"$f":"'Input Data'!U24","v":2.9000000000000001E-2},{"$f":"'Input Data'!V24","v":2.9000000000000001E-2},{"$f":"'Input Data'!W24","v":2.9000000000000001E-2},{"$f":"'Input Data'!X24","v":0.03},{"$f":"'Input Data'!Y24","v":0.03},{"$f":"'Input Data'!Z24","v":0.03},{"$f":"'Input Data'!AA24","v":0.03},{"$f":"'Input Data'!AB24","v":0.03},{"$f":"'Input Data'!AC24","v":2.9000000000000001E-2},{"$f":"'Input Data'!AD24","v":2.9000000000000001E-2},{"$f":"'Input Data'!AE24","v":2.9000000000000001E-2},{"$f":"'Input Data'!AF24","v":2.9416666666666674E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",{"$f":"'Input Data'!T25","v":0},{"$f":"'Input Data'!U25","v":0},{"$f":"'Input Data'!V25","v":0},{"$f":"'Input Data'!W25","v":0},{"$f":"'Input Data'!X25","v":0},{"$f":"'Input Data'!Y25","v":0},{"$f":"'Input Data'!Z25","v":0},{"$f":"'Input Data'!AA25","v":0},{"$f":"'Input Data'!AB25","v":0},{"$f":"'Input Data'!AC25","v":0},{"$f":"'Input Data'!AD25","v":0},{"$f":"'Input Data'!AE25","v":0},{"$f":"'Input Data'!AF25","v":{"$error":"#DIV/0!"}}]
[null,"Aquifer Recharge - Monthly Distribution(%)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Monthly Distrbution - NORMAL",{"$f":"'Input Data'!D28","v":4},{"$f":"'Input Data'!E28","v":2},{"$f":"'Input Data'!F28","v":20},{"$f":"'Input Data'!G28","v":24},{"$f":"'Input Data'!H28","v":18},{"$f":"'Input Data'!I28","v":8},{"$f":"'Input Data'!J28","v":4},{"$f":"'Input Data'!K28","v":3},{"$f":"'Input Data'!L28","v":4},{"$f":"'Input Data'!M28","v":9},{"$f":"'Input Data'!N28","v":1.5},{"$f":"'Input Data'!O28","v":2.5},{"$f":"SUM(C34:N34)","v":100},null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!R$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!R$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!R$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!R$32,\"Select Scenario\"))))","v":2.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!S$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!S$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!S$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!S$32,\"Select Scenario\"))))","v":2.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!T$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!T$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!T$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!T$32,\"Select Scenario\"))))","v":2.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!U$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!U$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!U$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!U$32,\"Select Scenario\"))))","v":2.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!V$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!V$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!V$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!V$32,\"Select Scenario\"))))","v":0.03},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!W$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!W$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!W$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!W$32,\"Select Scenario\"))))","v":0.03},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!X$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!X$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!X$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!X$32,\"Select Scenario\"))))","v":0.03},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Y$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Y$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Y$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Y$32,\"Select Scenario\"))))","v":0.03},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Z$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Z$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Z$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Z$32,\"Select Scenario\"))))","v":0.03},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AA$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AA$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AA$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AA$32,\"Select Scenario\"))))","v":2.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AB$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AB$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AB$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AB$32,\"Select Scenario\"))))","v":2.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AC$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AC$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AC$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AC$32,\"Select Scenario\"))))","v":2.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AD$29,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AD$30,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AD$31,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AD$32,\"Select Scenario\"))))","v":2.9416666666666674E-2}]
[null,"Monthly Distrbution - DRY",{"$f":"'Input Data'!D29","v":4},{"$f":"'Input Data'!E29","v":2},{"$f":"'Input Data'!F29","v":20},{"$f":"'Input Data'!G29","v":24},{"$f":"'Input Data'!H29","v":18},{"$f":"'Input Data'!I29","v":8},{"$f":"'Input Data'!J29","v":4},{"$f":"'Input Data'!K29","v":3},{"$f":"'Input Data'!L29","v":4},{"$f":"'Input Data'!M29","v":9},{"$f":"'Input Data'!N29","v":1.5},{"$f":"'Input Data'!O29","v":2.5},{"$f":"SUM(C35:N35)","v":100}]
[null,"Monthly Distrbution - WET",{"$f":"'Input Data'!D30","v":4},{"$f":"'Input Data'!E30","v":2},{"$f":"'Input Data'!F30","v":20},{"$f":"'Input Data'!G30","v":24},{"$f":"'Input Data'!H30","v":18},{"$f":"'Input Data'!I30","v":8},{"$f":"'Input Data'!J30","v":4},{"$f":"'Input Data'!K30","v":3},{"$f":"'Input Data'!L30","v":4},{"$f":"'Input Data'!M30","v":9},{"$f":"'Input Data'!N30","v":1.5},{"$f":"'Input Data'!O30","v":2.5},100,null,"SEASONAL WATER DEMAND"]
[null,"Monthly Distrbution - OTHER",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"NORMAL",{"$f":"'Input Data'!T28","v":0},{"$f":"'Input Data'!U28","v":0},{"$f":"'Input Data'!V28","v":0},{"$f":"'Input Data'!W28","v":1.7999999999999999E-2},{"$f":"'Input Data'!X28","v":0.20699999999999999},{"$f":"'Input Data'!Y28","v":0.65400000000000003},{"$f":"'Input Data'!Z28","v":0.90100000000000002},{"$f":"'Input Data'!AA28","v":0.81799999999999995},{"$f":"'Input Data'!AB28","v":0.497},{"$f":"'Input Data'!AC28","v":0},{"$f":"'Input Data'!AD28","v":0},{"$f":"'Input Data'!AE28","v":0},{"$f":"'Input Data'!AF28","v":0.25791666666666663}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DRY",{"$f":"'Input Data'!T29","v":0},{"$f":"'Input Data'!U29","v":0},{"$f":"'Input Data'!V29","v":0},{"$f":"'Input Data'!W29","v":8.9999999999999993E-3},{"$f":"'Input Data'!X29","v":0.183},{"$f":"'Input Data'!Y29","v":0.76600000000000001},{"$f":"'Input Data'!Z29","v":0.85799999999999998},{"$f":"'Input Data'!AA29","v":0.94399999999999995},{"$f":"'Input Data'!AB29","v":0.61699999999999999},{"$f":"'Input Data'!AC29","v":0},{"$f":"'Input Data'!AD29","v":0},{"$f":"'Input Data'!AE29","v":0},{"$f":"'Input Data'!AF29","v":0.28141666666666665}]
[null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!C$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!C$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!C$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!C$37,\"Select Scenario\"))))","v":4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!D$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!D$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!D$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!D$37,\"Select Scenario\"))))","v":2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!E$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!E$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!E$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!E$37,\"Select Scenario\"))))","v":20},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!F$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!F$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!F$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!F$37,\"Select Scenario\"))))","v":24},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!G$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!G$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!G$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!G$37,\"Select Scenario\"))))","v":18},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!H$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!H$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!H$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!H$37,\"Select Scenario\"))))","v":8},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!I$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!I$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!I$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!I$37,\"Select Scenario\"))))","v":4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!J$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!J$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!J$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!J$37,\"Select Scenario\"))))","v":3},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!K$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!K$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!K$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!K$37,\"Select Scenario\"))))","v":4},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!L$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!L$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!L$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!L$37,\"Select Scenario\"))))","v":9},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!M$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!M$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!M$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!M$37,\"Select Scenario\"))))","v":1.5},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!N$34,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!N$35,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!N$36,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!N$37,\"Select Scenario\"))))","v":2.5},null,null,"WET",{"$f":"'Input Data'!T30","v":0},{"$f":"'Input Data'!U30","v":0},{"$f":"'Input Data'!V30","v":0},{"$f":"'Input Data'!W30","v":1.4E-2},{"$f":"'Input Data'!X30","v":0.10299999999999999},{"$f":"'Input Data'!Y30","v":0.50900000000000001},{"$f":"'Input Data'!Z30","v":0.90400000000000003},{"$f":"'Input Data'!AA30","v":0.67300000000000004},{"$f":"'Input Data'!AB30","v":0.61799999999999999},{"$f":"'Input Data'!AC30","v":0},{"$f":"'Input Data'!AD30","v":0},{"$f":"'Input Data'!AE30","v":0},{"$f":"'Input Data'!AF30","v":0.23508333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",{"$f":"'Input Data'!T31","v":0},{"$f":"'Input Data'!U31","v":0},{"$f":"'Input Data'!V31","v":0},{"$f":"'Input Data'!W31","v":0},{"$f":"'Input Data'!X31","v":0},{"$f":"'Input Data'!Y31","v":0},{"$f":"'Input Data'!Z31","v":0},{"$f":"'Input Data'!AA31","v":0},{"$f":"'Input Data'!AB31","v":0},{"$f":"'Input Data'!AC31","v":0},{"$f":"'Input Data'!AD31","v":0},{"$f":"'Input Data'!AE31","v":0},{"$f":"'Input Data'!AF31","v":{"$error":"#DIV/0!"}}]
[null,"Irrigation Return - Monthly Distribution (%)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL TOTAL"]
[null,"Monthly Distrbution - NORMAL",{"$f":"'Input Data'!D34","v":0},{"$f":"'Input Data'!E34","v":0},{"$f":"'Input Data'!F34","v":0},{"$f":"'Input Data'!G34","v":0},{"$f":"'Input Data'!H34","v":0},{"$f":"'Input Data'!I34","v":0},{"$f":"'Input Data'!J34","v":0},{"$f":"'Input Data'!K34","v":0},{"$f":"'Input Data'!L34","v":0},{"$f":"'Input Data'!M34","v":0},{"$f":"'Input Data'!N34","v":0},{"$f":"'Input Data'!O34","v":0},{"$f":"SUM(C42:N42)","v":0},null,"Result ot use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!R$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!R$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!R$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!R$40,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!S$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!S$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!S$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!S$40,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!T$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!T$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!T$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!T$40,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!U$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!U$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!U$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!U$40,\"Select Scenario\"))))","v":1.7999999999999999E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!V$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!V$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!V$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!V$40,\"Select Scenario\"))))","v":0.20699999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!W$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!W$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!W$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!W$40,\"Select Scenario\"))))","v":0.65400000000000003},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!X$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!X$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!X$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!X$40,\"Select Scenario\"))))","v":0.90100000000000002},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Y$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Y$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Y$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Y$40,\"Select Scenario\"))))","v":0.81799999999999995},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Z$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Z$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Z$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Z$40,\"Select Scenario\"))))","v":0.497},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AA$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AA$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AA$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AA$40,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AB$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AB$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AB$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AB$40,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AC$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AC$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AC$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AC$40,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AD$37,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AD$38,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AD$39,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AD$40,\"Select Scenario\"))))","v":0.25791666666666663}]
[null,"Monthly Distrbution - DRY",{"$f":"'Input Data'!D35","v":0},{"$f":"'Input Data'!E35","v":0},{"$f":"'Input Data'!F35","v":0},{"$f":"'Input Data'!G35","v":0},{"$f":"'Input Data'!H35","v":0},{"$f":"'Input Data'!I35","v":0},{"$f":"'Input Data'!J35","v":0},{"$f":"'Input Data'!K35","v":0},{"$f":"'Input Data'!L35","v":0},{"$f":"'Input Data'!M35","v":0},{"$f":"'Input Data'!N35","v":0},{"$f":"'Input Data'!O35","v":0},{"$f":"SUM(C43:N43)","v":0}]
[null,"Monthly Distrbution - WET",{"$f":"'Input Data'!D36","v":0},{"$f":"'Input Data'!E36","v":0},{"$f":"'Input Data'!F36","v":0},{"$f":"'Input Data'!G36","v":0},{"$f":"'Input Data'!H36","v":0},{"$f":"'Input Data'!I36","v":0},{"$f":"'Input Data'!J36","v":0},{"$f":"'Input Data'!K36","v":0},{"$f":"'Input Data'!L36","v":0},{"$f":"'Input Data'!M36","v":0},{"$f":"'Input Data'!N36","v":0},{"$f":"'Input Data'!O36","v":0},0,null,"Existing Groundwater Demand Data (m3/s)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,"Monthly Distrbution - OTHER",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL WATER DEMAND"]
[null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!C$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!C$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!C$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!C$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!D$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!D$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!D$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!D$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!E$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!E$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!E$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!E$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!F$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!F$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!F$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!F$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!G$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!G$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!G$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!G$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!H$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!H$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!H$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!H$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!I$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!I$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!I$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!I$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!J$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!J$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!J$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!J$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!K$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!K$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!K$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!K$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!L$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!L$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!L$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!L$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!M$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!M$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!M$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!M$45,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!N$42,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!N$43,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!N$44,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!N$45,\"Select Scenario\"))))","v":0},null,null,"NORMAL",{"$f":"'Input Data'!T36","v":6.6000000000000003E-2},{"$f":"'Input Data'!U36","v":5.5E-2},{"$f":"'Input Data'!V36","v":5.8999999999999997E-2},{"$f":"'Input Data'!W36","v":6.7000000000000004E-2},{"$f":"'Input Data'!X36","v":7.6999999999999999E-2},{"$f":"'Input Data'!Y36","v":7.8E-2},{"$f":"'Input Data'!Z36","v":8.2000000000000003E-2},{"$f":"'Input Data'!AA36","v":8.7999999999999995E-2},{"$f":"'Input Data'!AB36","v":7.9000000000000001E-2},{"$f":"'Input Data'!AC36","v":6.5000000000000002E-2},{"$f":"'Input Data'!AD36","v":5.6000000000000001E-2},{"$f":"'Input Data'!AE36","v":6.5000000000000002E-2},{"$f":"'Input Data'!AF36","v":6.9749999999999993E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DRY",{"$f":"'Input Data'!T37","v":6.4000000000000001E-2},{"$f":"'Input Data'!U37","v":5.2999999999999999E-2},{"$f":"'Input Data'!V37","v":5.7000000000000002E-2},{"$f":"'Input Data'!W37","v":6.5000000000000002E-2},{"$f":"'Input Data'!X37","v":7.3999999999999996E-2},{"$f":"'Input Data'!Y37","v":7.4999999999999997E-2},{"$f":"'Input Data'!Z37","v":7.9000000000000001E-2},{"$f":"'Input Data'!AA37","v":8.4000000000000005E-2},{"$f":"'Input Data'!AB37","v":7.5999999999999998E-2},{"$f":"'Input Data'!AC37","v":6.3E-2},{"$f":"'Input Data'!AD37","v":5.5E-2},{"$f":"'Input Data'!AE37","v":6.3E-2},{"$f":"'Input Data'!AF37","v":6.7333333333333342E-2}]
[null,"MODEL CALIBRATION - OBSERVATION WELL DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WET",{"$f":"'Input Data'!T38","v":6.4000000000000001E-2},{"$f":"'Input Data'!U38","v":5.2999999999999999E-2},{"$f":"'Input Data'!V38","v":5.7000000000000002E-2},{"$f":"'Input Data'!W38","v":6.5000000000000002E-2},{"$f":"'Input Data'!X38","v":7.3999999999999996E-2},{"$f":"'Input Data'!Y38","v":7.4999999999999997E-2},{"$f":"'Input Data'!Z38","v":7.9000000000000001E-2},{"$f":"'Input Data'!AA38","v":8.4000000000000005E-2},{"$f":"'Input Data'!AB38","v":7.5999999999999998E-2},{"$f":"'Input Data'!AC38","v":6.3E-2},{"$f":"'Input Data'!AD38","v":5.5E-2},{"$f":"'Input Data'!AE38","v":6.3E-2},{"$f":"'Input Data'!AF38","v":6.7333333333333342E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",{"$f":"'Input Data'!T39","v":0},{"$f":"'Input Data'!U39","v":0},{"$f":"'Input Data'!V39","v":0},{"$f":"'Input Data'!W39","v":0},{"$f":"'Input Data'!X39","v":0},{"$f":"'Input Data'!Y39","v":0},{"$f":"'Input Data'!Z39","v":0},{"$f":"'Input Data'!AA39","v":0},{"$f":"'Input Data'!AB39","v":0},{"$f":"'Input Data'!AC39","v":0},{"$f":"'Input Data'!AD39","v":0},{"$f":"'Input Data'!AE39","v":0},{"$f":"'Input Data'!AF39","v":{"$error":"#DIV/0!"}}]
[null,"OBSERVATION WELL DATA (m bgl)","Preceding DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!R$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!R$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!R$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!R$50,\"Select Scenario\"))))","v":6.6000000000000003E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!S$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!S$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!S$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!S$50,\"Select Scenario\"))))","v":5.5E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!T$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!T$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!T$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!T$50,\"Select Scenario\"))))","v":5.8999999999999997E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!U$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!U$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!U$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!U$50,\"Select Scenario\"))))","v":6.7000000000000004E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!V$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!V$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!V$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!V$50,\"Select Scenario\"))))","v":7.6999999999999999E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!W$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!W$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!W$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!W$50,\"Select Scenario\"))))","v":7.8E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!X$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!X$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!X$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!X$50,\"Select Scenario\"))))","v":8.2000000000000003E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Y$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Y$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Y$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Y$50,\"Select Scenario\"))))","v":8.7999999999999995E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Z$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Z$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Z$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Z$50,\"Select Scenario\"))))","v":7.9000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AA$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AA$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AA$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AA$50,\"Select Scenario\"))))","v":6.5000000000000002E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AB$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AB$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AB$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AB$50,\"Select Scenario\"))))","v":5.6000000000000001E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AC$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AC$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AC$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AC$50,\"Select Scenario\"))))","v":6.5000000000000002E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AD$47,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AD$48,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AD$49,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AD$50,\"Select Scenario\"))))","v":6.9749999999999993E-2}]
[null,"Keremeos (Well # 75)"]
[null,"NORMAL",{"$f":"'Input Data'!D44","v":2.6880000000000002},{"$f":"'Input Data'!E44","v":2.5859999999999999},{"$f":"'Input Data'!F44","v":2.702},{"$f":"'Input Data'!G44","v":2.6440000000000001},{"$f":"'Input Data'!H44","v":2.4670000000000001},{"$f":"'Input Data'!I44","v":1.97},{"$f":"'Input Data'!J44","v":2.0550000000000002},{"$f":"'Input Data'!K44","v":2.3069999999999999},{"$f":"'Input Data'!L44","v":2.7349999999999999},{"$f":"'Input Data'!M44","v":2.883},{"$f":"'Input Data'!N44","v":2.8679999999999999},{"$f":"'Input Data'!O44","v":2.6859999999999999},{"$f":"'Input Data'!P44","v":2.6880000000000002},null,"SEASONAL WATER DEMAND"]
[null,"DRY",{"$f":"'Input Data'!D45","v":2.875},{"$f":"'Input Data'!E45","v":2.9750000000000001},{"$f":"'Input Data'!F45","v":3.0249999999999999},{"$f":"'Input Data'!G45","v":2.9649999999999999},{"$f":"'Input Data'!H45","v":2.7949999999999999},{"$f":"'Input Data'!I45","v":2.2749999999999999},{"$f":"'Input Data'!J45","v":2.5049999999999999},{"$f":"'Input Data'!K45","v":2.8650000000000002},{"$f":"'Input Data'!L45","v":3.1949999999999998},{"$f":"'Input Data'!M45","v":3.0249999999999999},{"$f":"'Input Data'!N45","v":3.0549999999999997},{"$f":"'Input Data'!O45","v":3.01},{"$f":"'Input Data'!P45","v":3.0049999999999999},null,"NORMAL",{"$f":"'Input Data'!T42","v":0},{"$f":"'Input Data'!U42","v":0},{"$f":"'Input Data'!V42","v":0},{"$f":"'Input Data'!W42","v":7.8E-2},{"$f":"'Input Data'!X42","v":0.38400000000000001},{"$f":"'Input Data'!Y42","v":0.81},{"$f":"'Input Data'!Z42","v":1.0529999999999999},{"$f":"'Input Data'!AA42","v":0.92700000000000005},{"$f":"'Input Data'!AB42","v":0.56299999999999994},{"$f":"'Input Data'!AC42","v":0},{"$f":"'Input Data'!AD42","v":0},{"$f":"'Input Data'!AE42","v":0},{"$f":"'Input Data'!AF42","v":0.31791666666666668}]
[null,"WET",{"$f":"'Input Data'!D46","v":2.0150000000000001},{"$f":"'Input Data'!E46","v":1.9424999999999999},{"$f":"'Input Data'!F46","v":1.9474999999999998},{"$f":"'Input Data'!G46","v":2.0699999999999998},{"$f":"'Input Data'!H46","v":2.1175000000000002},{"$f":"'Input Data'!I46","v":1.22},{"$f":"'Input Data'!J46","v":1.17},{"$f":"'Input Data'!K46","v":1.4475},{"$f":"'Input Data'!L46","v":2.2599999999999998},{"$f":"'Input Data'!M46","v":2.5649999999999999},{"$f":"'Input Data'!N46","v":2.6150000000000002},{"$f":"'Input Data'!O46","v":2.62},{"$f":"'Input Data'!P46","v":2.6349999999999998},null,"DRY",{"$f":"'Input Data'!T43","v":0},{"$f":"'Input Data'!U43","v":0},{"$f":"'Input Data'!V43","v":0},{"$f":"'Input Data'!W43","v":5.8000000000000003E-2},{"$f":"'Input Data'!X43","v":0.372},{"$f":"'Input Data'!Y43","v":0.89500000000000002},{"$f":"'Input Data'!Z43","v":0.99399999999999999},{"$f":"'Input Data'!AA43","v":1.087},{"$f":"'Input Data'!AB43","v":0.69499999999999995},{"$f":"'Input Data'!AC43","v":0},{"$f":"'Input Data'!AD43","v":0},{"$f":"'Input Data'!AE43","v":0},{"$f":"'Input Data'!AF43","v":0.34175}]
[null,"OTHER",{"$f":"'Input Data'!D47","v":0},{"$f":"'Input Data'!E47","v":0},{"$f":"'Input Data'!F47","v":0},{"$f":"'Input Data'!G47","v":0},{"$f":"'Input Data'!H47","v":0},{"$f":"'Input Data'!I47","v":0},{"$f":"'Input Data'!J47","v":0},{"$f":"'Input Data'!K47","v":0},{"$f":"'Input Data'!L47","v":0},{"$f":"'Input Data'!M47","v":0},{"$f":"'Input Data'!N47","v":0},{"$f":"'Input Data'!O47","v":0},{"$f":"'Input Data'!P47","v":0},null,"WET",{"$f":"'Input Data'!T44","v":0},{"$f":"'Input Data'!U44","v":0},{"$f":"'Input Data'!V44","v":0},{"$f":"'Input Data'!W44","v":5.3999999999999999E-2},{"$f":"'Input Data'!X44","v":0.23400000000000001},{"$f":"'Input Data'!Y44","v":0.61799999999999999},{"$f":"'Input Data'!Z44","v":1.0369999999999999},{"$f":"'Input Data'!AA44","v":0.76700000000000002},{"$f":"'Input Data'!AB44","v":0.63100000000000001},{"$f":"'Input Data'!AC44","v":0},{"$f":"'Input Data'!AD44","v":0},{"$f":"'Input Data'!AE44","v":0},{"$f":"'Input Data'!AF44","v":0.2784166666666667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",{"$f":"'Input Data'!T45","v":0},{"$f":"'Input Data'!U45","v":0},{"$f":"'Input Data'!V45","v":0},{"$f":"'Input Data'!W45","v":0},{"$f":"'Input Data'!X45","v":0},{"$f":"'Input Data'!Y45","v":0},{"$f":"'Input Data'!Z45","v":0},{"$f":"'Input Data'!AA45","v":0},{"$f":"'Input Data'!AB45","v":0},{"$f":"'Input Data'!AC45","v":0},{"$f":"'Input Data'!AD45","v":0},{"$f":"'Input Data'!AE45","v":0},{"$f":"'Input Data'!AF45","v":{"$error":"#DIV/0!"}}]
[null,"Other"]
[null,"NORMAL",{"$f":"'Input Data'!D50","v":0},{"$f":"'Input Data'!E50","v":0},{"$f":"'Input Data'!F50","v":0},{"$f":"'Input Data'!G50","v":0},{"$f":"'Input Data'!H50","v":0},{"$f":"'Input Data'!I50","v":0},{"$f":"'Input Data'!J50","v":0},{"$f":"'Input Data'!K50","v":0},{"$f":"'Input Data'!L50","v":0},{"$f":"'Input Data'!M50","v":0},{"$f":"'Input Data'!N50","v":0},{"$f":"'Input Data'!O50","v":0},{"$f":"'Input Data'!P50","v":0},null,"Result ot use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!R$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!R$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!R$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!R$58,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!S$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!S$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!S$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!S$58,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!T$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!T$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!T$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!T$58,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!U$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!U$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!U$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!U$58,\"Select Scenario\"))))","v":7.8E-2},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!V$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!V$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!V$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!V$58,\"Select Scenario\"))))","v":0.38400000000000001},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!W$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!W$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!W$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!W$58,\"Select Scenario\"))))","v":0.81},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!X$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!X$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!X$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!X$58,\"Select Scenario\"))))","v":1.0529999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Y$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Y$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Y$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Y$58,\"Select Scenario\"))))","v":0.92700000000000005},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!Z$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!Z$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!Z$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!Z$58,\"Select Scenario\"))))","v":0.56299999999999994},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AA$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AA$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AA$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AA$58,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AB$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AB$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AB$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AB$58,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AC$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AC$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AC$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AC$58,\"Select Scenario\"))))","v":0},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!AD$55,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!AD$56,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!AD$57,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!AD$58,\"Select Scenario\"))))","v":0.31791666666666668}]
[null,"DRY",{"$f":"'Input Data'!D51","v":0},{"$f":"'Input Data'!E51","v":0},{"$f":"'Input Data'!F51","v":0},{"$f":"'Input Data'!G51","v":0},{"$f":"'Input Data'!H51","v":0},{"$f":"'Input Data'!I51","v":0},{"$f":"'Input Data'!J51","v":0},{"$f":"'Input Data'!K51","v":0},{"$f":"'Input Data'!L51","v":0},{"$f":"'Input Data'!M51","v":0},{"$f":"'Input Data'!N51","v":0},{"$f":"'Input Data'!O51","v":0},{"$f":"'Input Data'!P51","v":0}]
[null,"WET",{"$f":"'Input Data'!D52","v":0},{"$f":"'Input Data'!E52","v":0},{"$f":"'Input Data'!F52","v":0},{"$f":"'Input Data'!G52","v":0},{"$f":"'Input Data'!H52","v":0},{"$f":"'Input Data'!I52","v":0},{"$f":"'Input Data'!J52","v":0},{"$f":"'Input Data'!K52","v":0},{"$f":"'Input Data'!L52","v":0},{"$f":"'Input Data'!M52","v":0},{"$f":"'Input Data'!N52","v":0},{"$f":"'Input Data'!O52","v":0},{"$f":"'Input Data'!P52","v":0},null,"Total Licensed Water Demand Data (m3/s)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","ANNUAL MEAN"]
[null,"OTHER",{"$f":"'Input Data'!D53","v":0},{"$f":"'Input Data'!E53","v":0},{"$f":"'Input Data'!F53","v":0},{"$f":"'Input Data'!G53","v":0},{"$f":"'Input Data'!H53","v":0},{"$f":"'Input Data'!I53","v":0},{"$f":"'Input Data'!J53","v":0},{"$f":"'Input Data'!K53","v":0},{"$f":"'Input Data'!L53","v":0},{"$f":"'Input Data'!M53","v":0},{"$f":"'Input Data'!N53","v":0},{"$f":"'Input Data'!O53","v":0},{"$f":"'Input Data'!P53","v":0},null,"Annual Water Use",{"$f":"'Input Data'!T48","v":0.60799999999999998},{"$f":"'Input Data'!U48","v":0.57199999999999995},{"$f":"'Input Data'!V48","v":0.56799999999999995},{"$f":"'Input Data'!W48","v":0.72599999999999998},{"$f":"'Input Data'!X48","v":1.0960000000000001},{"$f":"'Input Data'!Y48","v":1.1850000000000001},{"$f":"'Input Data'!Z48","v":1.6850000000000001},{"$f":"'Input Data'!AA48","v":1.6160000000000001},{"$f":"'Input Data'!AB48","v":1.0660000000000001},{"$f":"'Input Data'!AC48","v":0.67100000000000004},{"$f":"'Input Data'!AD48","v":0.53200000000000003},{"$f":"'Input Data'!AE48","v":0.54100000000000004},{"$f":"'Input Data'!AF48","v":0.90549999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seasonal Water Use",{"$f":"'Input Data'!T49","v":0},{"$f":"'Input Data'!U49","v":0},{"$f":"'Input Data'!V49","v":0},{"$f":"'Input Data'!W49","v":8.2000000000000003E-2},{"$f":"'Input Data'!X49","v":0.89600000000000002},{"$f":"'Input Data'!Y49","v":2.82},{"$f":"'Input Data'!Z49","v":3.8889999999999998},{"$f":"'Input Data'!AA49","v":3.5529999999999999},{"$f":"'Input Data'!AB49","v":2.1389999999999998},{"$f":"'Input Data'!AC49","v":0},{"$f":"'Input Data'!AD49","v":0},{"$f":"'Input Data'!AE49","v":0},{"$f":"'Input Data'!AF49","v":1.1149166666666666}]
[null,"Mean Groundwater Level"]
[null,"NORMAL",{"$f":"'Input Data'!D56","v":2.6880000000000002},{"$f":"'Input Data'!E56","v":2.5859999999999999},{"$f":"'Input Data'!F56","v":2.702},{"$f":"'Input Data'!G56","v":2.6440000000000001},{"$f":"'Input Data'!H56","v":2.4670000000000001},{"$f":"'Input Data'!I56","v":1.97},{"$f":"'Input Data'!J56","v":2.0550000000000002},{"$f":"'Input Data'!K56","v":2.3069999999999999},{"$f":"'Input Data'!L56","v":2.7349999999999999},{"$f":"'Input Data'!M56","v":2.883},{"$f":"'Input Data'!N56","v":2.8679999999999999},{"$f":"'Input Data'!O56","v":2.6859999999999999},{"$f":"'Input Data'!P56","v":2.6880000000000002},null,"Result ot use for model run",{"$f":"SUM(R63:R64)","v":0.60799999999999998},{"$f":"SUM(S63:S64)","v":0.57199999999999995},0.56799999999999995,0.80799999999999994,1.992,4.0049999999999999,5.5739999999999998,5.1690000000000005,3.2050000000000001,0.67100000000000004,0.53200000000000003,0.54100000000000004,2.0204166666666667]
[null,"DRY",{"$f":"'Input Data'!D57","v":2.875},{"$f":"'Input Data'!E57","v":2.9750000000000001},{"$f":"'Input Data'!F57","v":3.0249999999999999},{"$f":"'Input Data'!G57","v":2.9649999999999999},{"$f":"'Input Data'!H57","v":2.7949999999999999},{"$f":"'Input Data'!I57","v":2.2749999999999999},{"$f":"'Input Data'!J57","v":2.5049999999999999},{"$f":"'Input Data'!K57","v":2.8650000000000002},{"$f":"'Input Data'!L57","v":3.1949999999999998},{"$f":"'Input Data'!M57","v":3.0249999999999999},{"$f":"'Input Data'!N57","v":3.0549999999999997},{"$f":"'Input Data'!O57","v":3.01},{"$f":"'Input Data'!P57","v":3.0049999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,"WET",{"$f":"'Input Data'!D58","v":2.0150000000000001},{"$f":"'Input Data'!E58","v":1.9424999999999999},{"$f":"'Input Data'!F58","v":1.9474999999999998},{"$f":"'Input Data'!G58","v":2.0699999999999998},{"$f":"'Input Data'!H58","v":2.1175000000000002},{"$f":"'Input Data'!I58","v":1.22},{"$f":"'Input Data'!J58","v":1.17},{"$f":"'Input Data'!K58","v":1.4475},{"$f":"'Input Data'!L58","v":2.2599999999999998},{"$f":"'Input Data'!M58","v":2.5649999999999999},{"$f":"'Input Data'!N58","v":2.6150000000000002},{"$f":"'Input Data'!O58","v":2.62},{"$f":"'Input Data'!P58","v":2.6349999999999998},null,"Future Surface Water Demand Data (m3/month)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"OTHER",{"$f":"'Input Data'!D59","v":0},{"$f":"'Input Data'!E59","v":0},{"$f":"'Input Data'!F59","v":0},{"$f":"'Input Data'!G59","v":0},{"$f":"'Input Data'!H59","v":0},{"$f":"'Input Data'!I59","v":0},{"$f":"'Input Data'!J59","v":0},{"$f":"'Input Data'!K59","v":0},{"$f":"'Input Data'!L59","v":0},{"$f":"'Input Data'!M59","v":0},{"$f":"'Input Data'!N59","v":0},{"$f":"'Input Data'!O59","v":0},{"$f":"'Input Data'!P59","v":0},null,"Annual",{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!R3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!S3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!T3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!U3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!V3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!W3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!X3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!Y3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!Z3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!AA3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!AB3, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"ANNUAL\", 'Model Output'!$D$24*'Lookup Tables'!AC3, 0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seasonal",{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!R4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!S4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!T4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!U4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!V4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!W4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!X4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!Y4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!Z4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!AA4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!AB4, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"SEASONAL\", 'Model Output'!$D$24*'Lookup Tables'!AC4, 0)","v":0}]
[null,"Result to use for model run",{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!C$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!C$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!C$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!C$69,\"Select Scenario\"))))","v":2.6880000000000002},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!D$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!D$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!D$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!D$69,\"Select Scenario\"))))","v":2.5859999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!E$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!E$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!E$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!E$69,\"Select Scenario\"))))","v":2.702},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!F$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!F$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!F$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!F$69,\"Select Scenario\"))))","v":2.6440000000000001},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!G$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!G$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!G$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!G$69,\"Select Scenario\"))))","v":2.4670000000000001},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!H$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!H$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!H$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!H$69,\"Select Scenario\"))))","v":1.97},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!I$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!I$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!I$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!I$69,\"Select Scenario\"))))","v":2.0550000000000002},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!J$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!J$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!J$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!J$69,\"Select Scenario\"))))","v":2.3069999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!K$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!K$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!K$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!K$69,\"Select Scenario\"))))","v":2.7349999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!L$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!L$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!L$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!L$69,\"Select Scenario\"))))","v":2.883},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!M$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!M$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!M$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!M$69,\"Select Scenario\"))))","v":2.8679999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!N$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!N$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!N$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!N$69,\"Select Scenario\"))))","v":2.6859999999999999},{"$f":"IF('Model Parameters'!$D$7=\"NORMAL\",'Lookup Tables'!O$66,IF('Model Parameters'!$D$7=\"DRY\",'Lookup Tables'!O$67,IF('Model Parameters'!$D$7=\"WET\",'Lookup Tables'!O$68,IF('Model Parameters'!$D$7=\"OTHER\",'Lookup Tables'!O$69,\"Select Scenario\"))))","v":2.6880000000000002},null,"Other",{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!R6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!S6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!T6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!U6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!V6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!W6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!X6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!Y6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!Z6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!AA6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!AB6, 0)","v":0},{"$f":"IF('Model Output'!$F$24=\"OTHER\", 'Model Output'!$D$24*'Lookup Tables'!AC6, 0)","v":0}]
[]
[null,"SCENARIO/OPTION SELECTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Result ot use for model run",{"$f":"SUM(R69:R71)","v":0},{"$f":"SUM(S69:S71)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"MBR Method","Model Calibration Mode",null,null,"Surface Water Use Scenario",null,null,null,"Recharge/Irrigation Return Option",null,null,null,null,null,null,"Future GroundWater Demand Data (m3/month)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"Neilson-Welch","ON = 1; OFF = 2",2,null,"Estimated Actual Demand",null,null,null,"Monthly Distribution",null,null,null,null,null,null,"Annual",{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!R3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!S3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!T3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!U3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!V3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!W3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!X3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!Y3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!Z3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!AA3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!AB3, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"ANNUAL\", 'Model Output'!$D$25*'Lookup Tables'!AC3, 0)","v":0}]
[null,"Darcy Equation",null,null,null,"Total Licensed Demand",null,null,null,"Fixed Percentage",null,null,null,null,null,null,"Seasonal",{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!R4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!S4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!T4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!U4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!V4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!W4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!X4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!Y4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!Z4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!AA4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!AB4, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"SEASONAL\", 'Model Output'!$D$25*'Lookup Tables'!AC4, 0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!R6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!S6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!T6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!U6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!V6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!W6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!X6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!Y6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!Z6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!AA6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!AB6, 0)","v":0},{"$f":"IF('Model Output'!$F$25=\"OTHER\", 'Model Output'!$D$25*'Lookup Tables'!AC6, 0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Result ot use for model run",{"$f":"SUM(R76:R78)","v":0},{"$f":"SUM(S76:S78)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"SAFETY FACTORS"]
[]
[null,"","Absolute Value","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"ΔS - +25%",{"$f":"AVERAGE(ABS('Water Budget'!D34), ABS('Water Budget'!E34), ABS('Water Budget'!F34), ABS('Water Budget'!G34), ABS('Water Budget'!H34), ABS('Water Budget'!I34), ABS('Water Budget'!J34), ABS('Water Budget'!K34), ABS('Water Budget'!L34), ABS('Water Budget'!M34), ABS('Water Budget'!N34), ABS('Water Budget'!O34))","v":0.44143243820127737},{"$f":"'Model Output'!D17+('Lookup Tables'!$C$86*0.25)","v":2.9077592961007084},{"$f":"'Model Output'!E17+('Lookup Tables'!$C$86*0.25)","v":3.1381876427989548},{"$f":"'Model Output'!F17+('Lookup Tables'!$C$86*0.25)","v":3.2141862738390614},{"$f":"'Model Output'!G17+('Lookup Tables'!$C$86*0.25)","v":2.5120713049111254},{"$f":"'Model Output'!H17+('Lookup Tables'!$C$86*0.25)","v":0.83543374766497436},{"$f":"'Model Output'!I17+('Lookup Tables'!$C$86*0.25)","v":1.2158269883526198},{"$f":"'Model Output'!J17+('Lookup Tables'!$C$86*0.25)","v":2.1419853682674455},{"$f":"'Model Output'!K17+('Lookup Tables'!$C$86*0.25)","v":2.6867606525756424},{"$f":"'Model Output'!L17+('Lookup Tables'!$C$86*0.25)","v":2.9537280976817044},{"$f":"'Model Output'!M17+('Lookup Tables'!$C$86*0.25)","v":3.015960062557276},{"$f":"'Model Output'!N17+('Lookup Tables'!$C$86*0.25)","v":2.8901583882885049},{"$f":"'Model Output'!O17+('Lookup Tables'!$C$86*0.25)","v":3.0864389670799328}]
[null,"ΔS - -25%",null,{"$f":"'Model Output'!D17-('Lookup Tables'!$C$86*0.25)","v":2.6870430770000699},{"$f":"'Model Output'!E17-('Lookup Tables'!$C$86*0.25)","v":2.9174714236983164},{"$f":"'Model Output'!F17-('Lookup Tables'!$C$86*0.25)","v":2.993470054738423},{"$f":"'Model Output'!G17-('Lookup Tables'!$C$86*0.25)","v":2.291355085810487},{"$f":"'Model Output'!H17-('Lookup Tables'!$C$86*0.25)","v":0.6147175285643357},{"$f":"'Model Output'!I17-('Lookup Tables'!$C$86*0.25)","v":0.99511076925198105},{"$f":"'Model Output'!J17-('Lookup Tables'!$C$86*0.25)","v":1.9212691491668068},{"$f":"'Model Output'!K17-('Lookup Tables'!$C$86*0.25)","v":2.466044433475004},{"$f":"'Model Output'!L17-('Lookup Tables'!$C$86*0.25)","v":2.733011878581066},{"$f":"'Model Output'!M17-('Lookup Tables'!$C$86*0.25)","v":2.7952438434566376},{"$f":"'Model Output'!N17-('Lookup Tables'!$C$86*0.25)","v":2.6694421691878665},{"$f":"'Model Output'!O17-('Lookup Tables'!$C$86*0.25)","v":2.8657227479792944}]
[]
[null,"TOTAL OFFSTREAM LICENCES (m3/s)","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"Total Offstream Licence (m3/s)",1.26,1.22,1.45,1.99,3.49,6.54,9.32,8.52,5.24,1.7,1.1599999999999999,1.18]
[]
[null,"Similkameen outflow + 40% Total Offstream Licence",{"$f":"R24+('Lookup Tables'!C90*0.4)","v":19.604000000000003},{"$f":"S24+('Lookup Tables'!D90*0.4)","v":18.187999999999999},{"$f":"T24+('Lookup Tables'!E90*0.4)","v":23.479999999999997},{"$f":"U24+('Lookup Tables'!F90*0.4)","v":59.396000000000001},{"$f":"V24+('Lookup Tables'!G90*0.4)","v":184.39599999999999},{"$f":"W24+('Lookup Tables'!H90*0.4)","v":188.61600000000001},{"$f":"X24+('Lookup Tables'!I90*0.4)","v":71.427999999999997},{"$f":"Y24+('Lookup Tables'!J90*0.4)","v":25.008000000000003},{"$f":"Z24+('Lookup Tables'!K90*0.4)","v":15.496},{"$f":"AA24+('Lookup Tables'!L90*0.4)","v":16.68},{"$f":"AB24+('Lookup Tables'!M90*0.4)","v":28.064},{"$f":"AC24+('Lookup Tables'!N90*0.4)","v":20.572000000000003}]
[null,"Similkameen outflow - 60% Total Offstream Licence",{"$f":"(R24-('Lookup Tables'!C90*0.6)) - (SUM(R73,R80)/(60*60*24*C3))","v":18.344000000000001},{"$f":"(S24-('Lookup Tables'!D90*0.6)) - (SUM(S73,S80)/(60*60*24*D3))","v":16.968},{"$f":"(T24-('Lookup Tables'!E90*0.6)) - (SUM(T73,T80)/(60*60*24*E3))","v":22.029999999999998},{"$f":"(U24-('Lookup Tables'!F90*0.6)) - (SUM(U73,U80)/(60*60*24*F3))","v":57.405999999999999},{"$f":"(V24-('Lookup Tables'!G90*0.6)) - (SUM(V73,V80)/(60*60*24*G3))","v":180.90600000000001},{"$f":"(W24-('Lookup Tables'!H90*0.6)) - (SUM(W73,W80)/(60*60*24*H3))","v":182.07599999999999},{"$f":"(X24-('Lookup Tables'!I90*0.6)) - (SUM(X73,X80)/(60*60*24*I3))","v":62.108000000000004},{"$f":"(Y24-('Lookup Tables'!J90*0.6)) - (SUM(Y73,Y80)/(60*60*24*J3))","v":16.488000000000003},{"$f":"(Z24-('Lookup Tables'!K90*0.6)) - (SUM(Z73,Z80)/(60*60*24*K3))","v":10.256},{"$f":"(AA24-('Lookup Tables'!L90*0.6)) - (SUM(AA73,AA80)/(60*60*24*L3))","v":14.98},{"$f":"(AB24-('Lookup Tables'!M90*0.6)) - (SUM(AB73,AB80)/(60*60*24*M3))","v":26.904},{"$f":"(AC24-('Lookup Tables'!N90*0.6)) - (SUM(AC73,AC80)/(60*60*24*N3))","v":19.392000000000003}]
[]
[null,"TOTAL LICENSED USE IN AQUIFER #259","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,"Total Licenced Use in Aquifer #259 (m3)",{"$f":"R66*(60*60*24*C3)","v":1628467.2},1383782.3999999999,1521331.2,2094335.9999999998,5335372.8,10380960,14929401.6,13844649.600000001,8307360,1797206.4000000001,1378944,1449014.4000000001]
[]
[null,"Equivalent GW Level",{"$f":"IF($D$76=2, (C96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, C96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":5.1922118775690633E-2},{"$f":"IF($D$76=2, (D96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, D96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":4.4120578008884824E-2},{"$f":"IF($D$76=2, (E96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, E96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":4.8506189908868881E-2},{"$f":"IF($D$76=2, (F96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, F96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":6.6775899783676831E-2},{"$f":"IF($D$76=2, (G96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, G96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.17011325756772327},{"$f":"IF($D$76=2, (H96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, H96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.33098697850696257},{"$f":"IF($D$76=2, (I96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, I96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.47600968759161116},{"$f":"IF($D$76=2, (J96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, J96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.44142340781504102},{"$f":"IF($D$76=2, (K96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, K96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":0.26487222624589635},{"$f":"IF($D$76=2, (L96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, L96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":5.7302206740934898E-2},{"$f":"IF($D$76=2, (M96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, M96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":4.396631025360901E-2},{"$f":"IF($D$76=2, (N96/('Model Parameters'!$D$13*'Model Parameters'!$D$14)), IF($D$76=1, N96/('Model Parameters'!$D$13*'Model Sensitivity'!$M$17)))","v":4.6200437923764208E-2}]
[]
[null,"GW Level with total licenced extraction",{"$f":"('Model Output'!D9+'Lookup Tables'!C98) + ('Model Output'!D17-'Model Output'!D9)","v":2.8493233053260796},{"$f":"('Model Output'!E9+'Lookup Tables'!D98) + ('Model Output'!E17-'Model Output'!E9)","v":3.0719501112575203},{"$f":"('Model Output'!F9+'Lookup Tables'!E98) + ('Model Output'!F17-'Model Output'!F9)","v":3.152334354197611},{"$f":"('Model Output'!G9+'Lookup Tables'!F98) + ('Model Output'!G17-'Model Output'!G9)","v":2.4684890951444829},{"$f":"('Model Output'!H9+'Lookup Tables'!G98) + ('Model Output'!H17-'Model Output'!H9)","v":0.89518889568237836},{"$f":"('Model Output'!I9+'Lookup Tables'!H98) + ('Model Output'!I17-'Model Output'!I9)","v":1.436455857309263},{"$f":"('Model Output'!J9+'Lookup Tables'!I98) + ('Model Output'!J17-'Model Output'!J9)","v":2.5076369463087373},{"$f":"('Model Output'!K9+'Lookup Tables'!J98) + ('Model Output'!K17-'Model Output'!K9)","v":3.0178259508403644},{"$f":"('Model Output'!L9+'Lookup Tables'!K98) + ('Model Output'!L17-'Model Output'!L9)","v":3.1082422143772814},{"$f":"('Model Output'!M9+'Lookup Tables'!L98) + ('Model Output'!M17-'Model Output'!M9)","v":2.9629041597478918},{"$f":"('Model Output'!N9+'Lookup Tables'!M98) + ('Model Output'!N17-'Model Output'!N9)","v":2.8237665889917949},{"$f":"('Model Output'!O9+'Lookup Tables'!N98) + ('Model Output'!O17-'Model Output'!O9)","v":3.0222812954533778}]