{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Introduction","Questions","Answers","Capture Zone"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":1,"defined_names":3,"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Questions","index":1,"n_rows":110,"n_cols":6,"rows_kept":110,"cut":false,"hidden":false,"merged":[[106,4,106,5],[106,1,106,2]],"flags":["formulas_cached_only"]}
{"$rows_empty":91}
[null,null,"Aquifer-Test",null,"Slug-Test","Grain-Size"]
[null,null,"Case",null,"Case","Case"]
[null,"K value (ft/d)",350,null,185,50]
[null,"Q (gpm)"]
[null,"2YL (ft)"]
[null,"XL (ft)"]
{"$rows_empty":9}
[null,"Aquifer Thickness (b)",null,null,"Hydraulic Gradient (i)"]
[null,40,80,null,0.005,0.01]
["XL (ft)"]
["2YL (ft)"]

{"sheet":"Answers","index":2,"n_rows":110,"n_cols":6,"rows_kept":110,"cut":false,"hidden":false,"merged":[[106,4,106,5],[106,1,106,2]],"flags":["formulas_cached_only"]}
{"$rows_empty":91}
[null,null,"Aquifer-Test",null,"Slug-Test","Grain-Size"]
[null,null,"Case",null,"Case","Case"]
[null,"K value (ft/d)",350,null,185,50]
[null,"Q (gpm)",150,null,80,25]
[null,"2YL (ft)",412,null,416,482]
[null,"XL (ft)",-65.7,null,-66.2,-76.6]
{"$rows_empty":9}
[null,"Aquifer Thickness (b)",null,null,"Hydraulic Gradient (i)"]
[null,40,80,null,0.005,0.01]
["XL (ft)",-65.7,-32.8,null,-65.7,-32.8]
["2YL (ft)",412,206,null,412,206]

{"sheet":"Capture Zone","index":3,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Aquifer Parameters",null,null,null,"Well Location & Pumping Rate",null,null,null,"Capture-Curve Geometry"]
[null,"K =",350,"ft/day",null,"Q =",50,"gpm",null,"XL =",-21.88532448933626,"ft"]
[null,"b =",40,"ft",null,"Q =",9625.668449197861,"ft3/d",null,"YL =",68.75477463712758,"ft"]
[null,"T =",14000,"ft2/day",null,"X =",0]
[null,"i =",0.005,"ft/ft",null,"Y =",0]
[]
[null,"Computed Curve (quad. 1 & 2)",{"$nulls":4},"Computed Curve (quad. 3 & 4)"]
[null,"PRIMARY CURVE (y > 0)",{"$nulls":4},"MIRROR IMAGE (y < 0)"]
[null,null,"Calc.","Input",null,null,null,"Calc.","Input"]
[null,null,"x (ft)","y (ft)",null,null,null,"x (ft)","y (ft)"]
[null,null,-21.885172180058206,0.1,null,null,null,-21.885172180058206,-0.1]
[null,null,-20.240826450969855,10.313216195569137,null,null,null,-20.240826450969855,-10.313216195569137]
[null,null,-14.985980333189266,20.626432391138273,null,null,null,-14.985980333189266,-20.626432391138273]
[null,null,-2.1058701478566807e-15,34.37738731856379,null,null,null,-2.1058701478566807e-15,-34.37738731856379]
[null,null,13.40386829379444,41.252864782276546,null,null,null,13.40386829379444,-41.252864782276546]
[null,null,34.96728744410824,48.1283422459893,null,null,null,34.96728744410824,-48.1283422459893]
[null,null,75.70626300528998,55.00381970970207,null,null,null,75.70626300528998,-55.00381970970207]
[null,null,114.6980165554958,58.44155844155844,null,null,null,114.6980165554958,-58.44155844155844]
[null,null,190.4448942025942,61.87929717341483,null,null,null,190.4448942025942,-61.87929717341483]
[null,null,412.3955343809899,65.3170359052712,null,null,null,412.3955343809899,-65.3170359052712]
[null,null,1070.9693317256724,67.37967914438502,null,null,null,1070.9693317256724,-67.37967914438502]
[null,null,5996.736038284217,68.50477463712758,null,null,null,5996.736038284217,-68.50477463712758]
[{"$nulls":6}," "]
[]
[]
[{"$nulls":9}," "]
{"$rows_empty":38}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[{"$nulls":7}," "]