{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Scenario 2 - Problem 3","Scenario 1 - Problem 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Scenario 2 - Problem 3","index":0,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Rainfall",40,"in/yr"]
["Drainage Basin Area",100,"km2","=",100000000,"m2"]
[]
["Flow paths\nfrom Rainfall","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Evapotranspiration",0.05,2,0.0508,5080000,13917.808219178081,3676667.397260274]
["Runoff",0.1,4,0.1016,10160000,27835.616438356163,7353334.794520548]
["Infiltration",0.85,34,0.8636,86360000,236602.7397260274,62503345.75342466]
["Total\n(should equal rainfall total)",1,40,1.016,101600000,278356.16438356164,73533347.94520548]
[]
["Flow paths\nfrom infiltration","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Ground water",0.25,8.5,0.2159,21590000,59150.68493150685,15625836.438356165]
["Runoff",0.05,1.7000000000000002,0.04318,4318000,11830.13698630137,3125167.287671233]
["Evapotranspiration",0.7,23.799999999999997,0.60452,60451999.99999999,165621.91780821915,43752342.02739725]
["Total\n(should equal infiltration total)",1,34,0.8636,86360000,236602.7397260274,62503345.75342466]
[]
["Flow paths\nfrom ground water","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Runoff",0.9,7.65,0.19431,19431000,53235.61643835616,14063252.794520548]
["Ground water outflow",0.1,0.8500000000000001,0.02159,2159000,5915.068493150685,1562583.6438356165]
["Total\n(should equal Ground water total)",1,8.5,0.2159,21590000,59150.68493150685,15625836.438356165]
[]
["OUTPUTS","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Total ET",0.6449999999999999,25.799999999999997,0.6553199999999999,65531999.99999999,179539.72602739724,47429009.42465753]
["Total Runoff",0.33375000000000005,13.350000000000001,0.33909000000000006,33909000.00000001,92901.36986301372,24541754.876712337]
["Total Ground water outflow",0.02125,0.8500000000000001,0.02159,2159000,5915.068493150685,1562583.6438356165]
["Total\n(should equal input - rainfall)",1,40,1.016,101600000,278356.16438356164,73533347.94520548]
[]
[]
[]
[]
["Consumption Capacity"]
["Personal Usage",200,"gal/day/person"]
["Stremflow alotmanet",15000000,"gal/day"]
["Avalablie Streamflow",9541754.876712337,"gal/day"]
["People supported",47708.774383561686]
[]
[]
["Change from scenario one"]
["Scenario 1:  Runoff",43605275.331506856,"gal/day"]
["Scenario 2:  Runoff",24541754.876712337,"gal/day"]
["Difference",-19063520.45479452,"gal/day"]
["Percent Change",-0.4371838111298481]

{"sheet":"Scenario 1 - Problem 2","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Rainfall",40,"in/yr"]
["Drainage Basin Area",100,"km2","=",100000000,"m2"]
[]
["Flow paths\nfrom Rainfall","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Evapotranspiration",0.05,2,0.0508,5080000,13917.808219178081,3676667.397260274]
["Runoff",0.1,4,0.1016,10160000,27835.616438356163,7353334.794520548]
["Infiltration",0.85,34,0.8636,86360000,236602.7397260274,62503345.75342466]
["Total\n(should equal rainfall total)",null,40,1.016,101600000,278356.16438356164,73533347.94520548]
[]
["Flow paths\nfrom infiltration","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Ground water",0.4,13.600000000000001,0.34544,34544000,94641.09589041096,25001338.301369864]
["Runoff",0.2,6.800000000000001,0.17272,17272000,47320.54794520548,12500669.150684932]
["Evapotranspiration",0.4,13.600000000000001,0.34544,34544000,94641.09589041096,25001338.301369864]
["Total\n(should equal infiltration total)",null,34,0.8636,86360000,236602.7397260274,62503345.75342466]
[]
["Flow paths\nfrom ground water","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Runoff",0.95,12.92,0.328168,32816800,89909.04109589041,23751271.386301372]
["Ground water outflow",0.05,0.6800000000000002,0.017272000000000003,1727200.0000000002,4732.054794520549,1250066.9150684935]
["Total\n(should equal Ground water total)",null,13.6,0.34544,34544000,94641.09589041096,25001338.301369864]
[]
["OUTPUTS","% of flux","in/yr","m/yr","m3/yr","m3/day","gal/day"]
["Total ET",0.39,15.600000000000001,0.39624000000000004,39624000,108558.90410958904,28678005.69863014]
["Total Runoff",0.593,23.72,0.602488,60248800,165065.20547945207,43605275.331506856]
["Total Ground water outflow",0.017000000000000005,0.6800000000000002,0.017272000000000003,1727200.0000000002,4732.054794520549,1250066.9150684935]
["Total\n(should equal input - rainfall)",1,40,1.016,101600000,278356.16438356164,73533347.94520548]
[]
[]
[]
[]
["Consumption Capacity"]
["Personal Usage",200,"gal/day/person"]
["Stremflow alotmanet",15000000,"gal/day"]
["Avalablie Streamflow",28605275.331506856,"gal/day"]
["People supported",143026.37665753427]